protected function doJob($arg)
 {
     $models = Newsletter::model()->findAll(array('condition' => 't.remain_subscribers IS NOT NULL AND length(t.remain_subscribers) > 0 AND t.send_time <= NOW()', 'order' => 't.id ASC'));
     foreach ($models as $model) {
         $mail_models = ProNewsletterMail::model()->findAll(array('condition' => 't.newsletter_id = ' . $model->id, 'order' => 't.id ASC'));
         if (count($mail_models)) {
             $receivers = explode(',', $model->remain_subscribers);
             $subscriber_count = 0;
             foreach ($mail_models as $key => $k) {
                 $revei = array_shift($receivers);
                 // need update this field
                 $s = Subscriber::model()->getSubscriberByEmail($k->email);
                 if (empty($s)) {
                     continue;
                 }
                 if ($s) {
                     if ($s->status == 0) {
                         continue;
                     }
                 }
                 // add by Nguyen Dung
                 $url = Yii::app()->setting->getItem('server_name') . '/site/track_newsletter?newsletter_id=' . $model->id . '&subscriber_email=' . $s->email;
                 $img_track_read_email = '<img src="' . $url . '" alt="" height="1" width="1"/>';
                 $r = array('subject' => $model->subject, 'params' => array('content' => $model->content . $img_track_read_email, 'newsletterName' => Yii::app()->params['title'], 'unsubscribe' => Yii::app()->setting->getItem('server_name') . '/site/unsubscribe?id=' . $s->id . '&code=' . md5($s->id . $s->email)), 'view' => 'newsletter', 'to' => $s->email, 'from' => Yii::app()->params['autoEmail']);
                 $this->data[] = $r;
                 //Delete record in newsletter mail
                 ProNewsletterMail::model()->deleteByPk($k->id);
                 $subscriber_count++;
                 //count subscriber is served for current newsletter job
                 $this->index++;
                 //count email is sent for current cron job
                 if ($this->index >= $this->max) {
                     break;
                 }
             }
             $model->total_sent = $model->total_sent + $subscriber_count;
             // track amount mail sent
             $model->remain_subscribers = implode(',', $receivers);
             $model->update(array('remain_subscribers', 'total_sent'));
         }
     }
     //when sent all subscriber of a newsletter job but the
     //        if($this->index < $this->max)
     //            $this->doJob($arg);
 }
 public function buildListSubscriberAdd($mNewsletter)
 {
     $newsletter_id = $mNewsletter->id;
     $send_time = $mNewsletter->send_time;
     $criteria = new CDbCriteria();
     $criteria->compare('t.status', 1);
     $listIdSubsciber = '';
     $totalSubscriber = 0;
     // if not select group => we get all subscriber => don't exist
     if (!isset($_POST['Newsletter']['newsletter_group_subscriber']) || count($_POST['Newsletter']['newsletter_group_subscriber']) < 1) {
         $subscribers = Subscriber::model()->findAll($criteria);
         foreach ($subscribers as $s) {
             $listIdSubsciber .= $s->id . ',';
         }
         $totalSubscriber = count($subscribers);
     } else {
         // if select group => we get all subscriber of this group
         $criteria->addInCondition('t.subscriber_group_id', $_POST['Newsletter']['newsletter_group_subscriber']);
         $subscribers = Subscriber::model()->findAll($criteria);
         $aRowInsert = array();
         $tableName = ProNewsletterMail::model()->tableName();
         foreach ($subscribers as $s) {
             $listIdSubsciber .= $s->id . ',';
             $new_model = new ProNewsletterMail();
             $new_model->name = $s->name;
             $new_model->email = $s->email;
             $new_model->subscriber_group_id = $s->subscriber_group_id;
             $new_model->newsletter_id = $newsletter_id;
             $new_model->send_time = $send_time;
             $aRowInsert[] = "('{$new_model->name}',\n                                     '{$new_model->email}',\n                                     '{$new_model->subscriber_group_id}',\n                                     '{$new_model->newsletter_id}',\n                                     '{$new_model->send_time}'\n                                     )";
         }
         $totalSubscriber = count($subscribers);
         if (count($aRowInsert)) {
             $sql = "insert into {$tableName} (name,\n                                                email,\n                                                subscriber_group_id,\n                                                newsletter_id,\n                                                send_time\n                                                ) values " . implode(',', $aRowInsert);
             ProNewsletterMail::model()->deleteAll("newsletter_id={$mNewsletter->id}");
             Yii::app()->db->createCommand($sql)->execute();
         }
     }
     return array('listIdSubsciber' => $listIdSubsciber, 'totalSubscriber' => $totalSubscriber);
 }