root/trunk/app/controllers/newsletters_controller.php

<?php
/** 
*   Karamelo E-Learning Platform
*   Manuel Montoya 2002-2008
*   GPLv3 License manuel<arroba>mononeurona<punto>org
*   Chipotle Software
*   @version 0.3
**/ 

App::import('Sanitize');

class NewslettersController extends AppController{

  public $helpers    = array('Ajax', 'Fck', 'Gags');
  public $components = array('Portal', 'Email');
  
  public function beforeFilter()
  {
    parent::beforeFilter();
    $this->Auth->allow(array('view', 'display', 'subscribe'));
  }
 
  public function subscribe()
  {
    $this->pageTitle = __('Newsletters', true);
    $this->layout    = 'portal';
    $this->Portal->statics(); // Charge Portal components aka Sidebars
  }

  public function display()
  {  
    $this->pageTitle = __('Newsletters', true);
    $this->layout = 'portal';
    if ($this->Auth->user()):
       $conditions   = array('Newsletter.status'=>1);
    else:
    $conditions   = array('Newsletter.status'=>1, 'Newsletter.public'=>1);  //get only public NL
    endif;
    $fields       = array('Newsletter.id', 'Newsletter.title', 'Newsletter.created', 'Newsletter.public');
    $order        = 'Newsletter.id DESC';
    $limit        = 40;
     
    $this->set('data', $this->Newsletter->findAll($conditions, $fields, $order, $limit)); 
    $this->Portal->statics(); // Using Portal component
  }
      
  public function view($newsletter_id)
  {
   $conditions = array('Newsletter.status'=>1, 'Newsletter.id'=>$newsletter_id);
   $fields     = array('Newsletter.id', 'Newsletter.title', 'Newsletter.body', 'Newsletter.created', 'Newsletter.public');
   $data       = $this->Newsletter->find($conditions, $fields);
   if ($data['Newsletter']['public'] == 0 && !$this->Auth->user()):
     $this->redirect('/newsletters/display');
     return false;
   else:
     $this->layout = 'portal';
     $this->pageTitle = $data['Newsletter']['title'];
     $this->set('data', $data);     
     $this->Portal->statics(); // Charge Portal components aka Sidebars
   endif;
  }

  /***  === ADMIN METHODS ***/ 
 public function admin_listing()
 {
  $this->layout    = 'admin';   
  $this->pageTitle =  __('Newsletters', true);
        
  $conditions   = null;
  $fields       = array('id', 'title', 'body', 'created', 'status', 'delivered', 'public');
  $order        = 'Newsletter.id DESC';
  $limit        = 20;
      
  $this->set('data', $this->Newsletter->findAll($conditions, $fields, $order, $limit)); 
 }

 public function admin_add()
 {
   $this->layout = 'admin';

   if (!empty($this->data['Newsletter'])):
       Sanitize::paranoid($this->data['Newsletter']['title']);

       Sanitize::html($this->data['Newsletter']['body']);

       $this->data['Newsletter']['user_id'] = $this->Auth->user('id');
   
       if ($this->Newsletter->save($this->data) ):
        if ( $this->data['Newsletter']['end'] == 1  ):
               $this->msgFlash(__('Data saved', true), '/admin/newsletters/listing');
            else:
               $id = $this->Newsletter->getLastInsertID();
                   $this->msgFlash(__('Data saved', true), '/admin/newsletters/edit/'.$id); 
        endif;
       endif;
    endif;
 }

 public function admin_edit($newsletter_id=null)
 {
    $this->layout = 'admin';

    if (!empty($this->data['Newsletter'])):
       
       Sanitize::paranoid($this->data['Newsletter']['title']);

       Sanitize::html($this->data['Newsletter']['body']);
   
       if ($this->Newsletter->save($this->data)):
        if ( $this->data['Newsletter']['end'] == 1  ):
               $this->msgFlash(__('Data saved', true), '/admin/newsletters/listing');
            else:
                   $this->msgFlash(__('Data saved', true), '/admin/newsletters/edit/'.$this->data['Newsletter']['id']); 
        endif;
       endif;
   else:
       $this->data     = $this->Newsletter->read(null, $newsletter_id);
   endif;
 }

  public function admin_send($newsletter_id)
  {
     if (!intval($newsletter_id))
     {
        die('Something is wrong!');
     }

     $this->layout = 'admin';

     $this->pageTitle = __('Newsletters', true);
                
     $this->set('number', $this->__sendNewsletter($newsletter_id));
  }

  private function __sendNewsletter($newsletter_id)
  {
     $conditions   = array('Newsletter.status' => 1, 'Newsletter.id' => $newsletter_id);

     $fields       = array('id', 'title', 'body', 'created', 'status');
     
     $data         = $this->Newsletter->find($conditions, $fields);

     $this->Newsletter->User->unbindModel(array("hasMany"=>array('Entry', 'Lesson', 'Faq', 'Vclassroom', 'Acquaintance')));

     $users        = $this->Newsletter->User->findAll(
                   array("User.active"=>1),
                               array("User.name", "User.email")
                ); 
    
     //exit(var_dump($users)); 
     $i = 0;    
     foreach ($users as $user):
        $this->Email->sender      = '::Karamelo Platform::';

        $this->Email->to          = $user['User']['email'];
        $this->Email->subject     = $data['Newsletter']['title'];
    $this->Email->sendAs      = 'txt';
        $this->Email->template    = null;
        $this->Email->from        = 'noreply@chipotle-software.com';
       
    if ( $this->Email->send($data['Newsletter']['body']) ):
                  $i++;
        else:
                 exit("Error!!");
    endif;
      endforeach;
     return $i;
 }

 // change status enabled/disabled
 public function admin_change($newsletter_id, $status)
 { 
   $this->data['Newsletter']['status'] = ($status == 0 ) ? 1 : 0;
      
   $this->data['Newsletter']['id']     = (int) $newsletter_id;
   
   if ($this->Newsletter->save($this->data, false)):
       $this->msgFlash(__('Status modified', true), '/admin/newsletters/listing');
   endif;
 }
 // change public / no  public
 public function admin_public($newsletter_id, $public)
 { 
   $this->data['Newsletter']['public'] = ($public == 0 ) ? 1 : 0;
      
   $this->data['Newsletter']['id']     = (int) $newsletter_id;
   
   if ($this->Newsletter->save($this->data, false)):
       $this->msgFlash(__('Status modified', true), '/admin/newsletters/listing');
   endif;
 }
 public function admin_delete($newsletter_id) 
 {
   if ( $this->Newsletter->del($newsletter_id) ):
        $this->msgFlash(__('Data removed', true), '/admin/newsletters/listing');
   endif;
  }
}
?>