コード例 #1
0
ファイル: IndexController.php プロジェクト: anunay/stentors
 /**
  * Sends mass mailing.
  * Prepares data and tests the recipients list before sendig emails.
  *
  * @param int $releaseID The release of the the newsletter to send.
  *
  * @return array Contains data corresponding to the send result.
  */
 public function sendMassMailingAction($releaseID = null)
 {
     $this->disableView();
     if (!$releaseID) {
         $releaseID = $_REQUEST['releaseID'];
     }
     //            $releaseID  = $this->view->params['releaseID'];
     // 1- Get all newsletter to send
     $dateTimeNow = date('Y-m-d H:i:s');
     $newsletterSelect = new NewsletterReleases();
     $select = $newsletterSelect->select()->setIntegrityCheck(false);
     $select->from('Newsletter_Releases')->join('Languages', 'L_ID = NR_LanguageID')->join('CategoriesIndex', 'CI_CategoryID = NR_CategoryID')->join('Newsletter_Models_Index', 'NMI_NewsletterModelID = NR_ModelID')->join('Newsletter_Models', 'NM_ID = NMI_NewsletterModelID')->where('CI_LanguageID = NR_LanguageID')->where('NMI_LanguageID = NR_LanguageID')->where('NR_Status <> 1')->where('NR_ID = ?', $releaseID);
     $newsletterData = $newsletterSelect->fetchAll($select);
     foreach ($newsletterData as $release) {
         $listSent = array();
         $listDest = array();
         $listIds = array();
         $mailLog = array();
         $date = new Zend_Date($release['NR_Date'], null, Zend_Registry::get('languageSuffix') == 'fr' ? 'fr_CA' : 'en_CA');
         $date_string = Cible_FunctionsGeneral::dateToString($date, Cible_FunctionsGeneral::DATE_LONG_NO_DAY, '.');
         $date_string_url = Cible_FunctionsGeneral::dateToString($date, Cible_FunctionsGeneral::DATE_SQL, '-');
         $releaseLanguage = $release['NR_LanguageID'];
         $this->view->assign('languageRelease', $releaseLanguage);
         $filteredData = $this->_countFilterMembers($release['NR_CollectionFiltersID'], $releaseLanguage);
         $members = $filteredData['members'];
         $selection = $filteredData['selection'];
         $dateTimeStart = date('Y-m-d H:i:s');
         $member_count = 0;
         $stats = array('action' => 'set', 'sentTo' => 0, 'targetedTotal' => 0);
         if ($release['NR_Status'] == 0 || $release['NR_Status'] == 3) {
             //Send to all recipient even if they have already received it
             $member_count = count($members);
         } elseif ($release['NR_Status'] == 2) {
             $member_count = count($members);
             $stats['action'] = 'increment';
             //Send to recipient who have not already received it
             $alreadyMembersRecievedSelect = new NewsletterReleasesMembers();
             $select = $alreadyMembersRecievedSelect->select()->where('NRM_ReleaseID = ?', $release['NR_ID']);
             $alreadyMembersRecievedData = $alreadyMembersRecievedSelect->fetchAll($select);
             $already_received_count = count($alreadyMembersRecievedData);
             $membersTmp = array();
             for ($i = 0; $i < $member_count; $i++) {
                 $received = "false";
                 for ($j = 0; $j < $already_received_count; $j++) {
                     if ($members[$i]['GP_MemberID'] == $alreadyMembersRecievedData[$j]['NRM_MemberID']) {
                         $received = "true";
                     }
                 }
                 if ($received == "false") {
                     array_push($membersTmp, $members[$i]);
                 }
             }
             $members = $membersTmp;
             $member_count = count($members);
         }
         $stats['targetedTotal'] = $member_count;
         if (!empty($members) && $member_count > 0) {
             $newsletterArticlesSelect = new NewsletterArticles();
             $select = $newsletterArticlesSelect->select();
             $select->where('NA_ReleaseID = ?', $release['NR_ID'])->order('NA_ZoneID')->order('NA_PositionID');
             $newsletterArticlesData = $newsletterArticlesSelect->fetchAll($select);
             $this->view->articles = $newsletterArticlesData->toArray();
             $registry = Zend_Registry::getInstance()->set('format', 'email');
             $config = Zend_Registry::get('config')->toArray();
             $nbMax = $config['massMailing']['packof'];
             $sleep = $config['massMailing']['sleep'];
             $server = $config['massMailing']['server'];
             $i = 0;
             set_time_limit(0);
             $emailValidator = new Zend_Validate_EmailAddress();
             $sentToCount = 0;
             $failedEmailAddress = array();
             for ($k = 0; $k < $member_count; $k++) {
                 try {
                     if ($i == $nbMax) {
                         $protocol->quit();
                         $protocol->disconnect();
                         sleep($sleep);
                         $i = 0;
                     }
                     if ($i == 0) {
                         $transport = new Zend_Mail_Transport_Smtp();
                         $protocol = new Zend_Mail_Protocol_Smtp($server);
                         $protocol->connect();
                         $protocol->helo($server);
                         $transport->setConnection($protocol);
                     }
                     $protocol->rset();
                     if ($emailValidator->isValid($members[$k]['GP_Email'])) {
                         $date = new Zend_Date($release['NR_Date'], null, Zend_Registry::get('languageSuffix') == 'fr' ? 'fr_CA' : 'en_CA');
                         $date_string = Cible_FunctionsGeneral::dateToString($date, Cible_FunctionsGeneral::DATE_LONG_NO_DAY, '.');
                         $date_string_url = Cible_FunctionsGeneral::dateToString($date, Cible_FunctionsGeneral::DATE_SQL, '-');
                         $newsletterCategoryID = $release['NR_CategoryID'];
                         $this->view->assign('unsubscribeLink', "/" . Cible_FunctionsCategories::getPagePerCategoryView($newsletterCategoryID, 'unsubscribe', 8));
                         $this->view->assign('subscribeLink', "/" . Cible_FunctionsCategories::getPagePerCategoryView($newsletterCategoryID, 'subscribe', 8, $releaseLanguage));
                         $this->view->assign('archiveLink', "/" . Cible_FunctionsCategories::getPagePerCategoryView($newsletterCategoryID, 'list_archives', 8, $releaseLanguage));
                         //$this->view->assign('details_release', "/" . Cible_FunctionsCategories::getPagePerCategoryView($newsletterCategoryID, 'details_release', 8) . "/ID/" . $release['NR_ID']);
                         $this->view->assign('details_release', "/" . Cible_FunctionsCategories::getPagePerCategoryView($newsletterCategoryID, 'details_release', 8, $releaseLanguage) . "/" . $date_string_url . "/" . $release['NR_Title']);
                         $this->view->assign('details_page', Cible_FunctionsCategories::getPagePerCategoryView($newsletterCategoryID, 'details_article', 8));
                         $this->view->assign('isOnline', $release['NR_Online']);
                         $this->view->assign('newsletterID', $release['NR_ID']);
                         $this->view->assign('memberId', $members[$k]['GP_MemberID']);
                         $this->view->assign('moduleId', $this->_moduleID);
                         $this->view->assign('dateString', $date_string);
                         $this->view->assign('parutionDate', $date_string_url);
                         $bodyText = $this->view->render($release['NM_DirectoryEmail']);
                         $salutationsSelect = new Salutations();
                         $select = $salutationsSelect->select()->setIntegrityCheck(false);
                         $salutationId = $members[$k]['GP_Salutation'];
                         if (is_null($salutationId)) {
                             $salutationId = 0;
                         }
                         $select->from('Salutations')->join('Static_Texts', 'ST_Identifier = S_StaticTitle')->where('ST_LangID = ?', Zend_Registry::get("languageID"))->where('S_ID = ?', $salutationId);
                         $salutationsData = $salutationsSelect->fetchRow($select);
                         $bodyText = str_replace('#prenom#', $members[$k]['GP_FirstName'], $bodyText);
                         $bodyText = str_replace('#nom#', $members[$k]['GP_LastName'], $bodyText);
                         $bodyText = str_replace('#courtoisie#', $salutationsData['ST_Value'], $bodyText);
                         //$newsletterData['NR_AfficherTitre'] = $form->getValue('NR_AfficherTitre');
                         $newsletterAfficherTitre = $release['NR_AfficherTitre'];
                         $newsletterTextIntro = $release['NR_TextIntro'];
                         $newsletterTextIntro = str_replace('##prenom##', $members[$k]['GP_FirstName'], $newsletterTextIntro);
                         $newsletterTextIntro = str_replace('##nom##', $members[$k]['GP_LastName'], $newsletterTextIntro);
                         $newsletterTextIntro = str_replace('##salutation##', $salutationsData['ST_Value'], $newsletterTextIntro);
                         $this->view->intro = $newsletterTextIntro;
                         $this->view->newsletterAfficherTitre = $newsletterAfficherTitre;
                         $mail = new Zend_Mail();
                         $mail->setBodyHtml($bodyText);
                         $mail->setFrom($release['NM_FromEmail'], $release['NMI_FromName']);
                         $mail->addTo($members[$k]['GP_Email']);
                         $mail->setSubject($release['NR_Title']);
                         if (!$mail->send()) {
                             array_push($failedEmailAddress, array('fname' => $members[$k]['GP_FirstName'], 'lname' => $members[$k]['GP_LastName'], 'email' => $members[$k]['GP_Email']));
                         }
                         $sentToCount++;
                         $releaseMember = new NewsletterReleasesMembers();
                         $releaseMemberData = $releaseMember->createRow();
                         $releaseMemberData['NRM_ReleaseID'] = $release['NR_ID'];
                         $releaseMemberData['NRM_MemberID'] = $members[$k]['GP_MemberID'];
                         $releaseMemberData['NRM_DateTimeReceived'] = date('Y-m-d H:i:s');
                         $insert = $releaseMemberData->save();
                         $i++;
                     } else {
                         array_push($failedEmailAddress, array('fname' => $members[$k]['GP_FirstName'], 'lname' => $members[$k]['GP_LastName'], 'email' => $members[$k]['GP_Email']));
                     }
                 } catch (Exception $exc) {
                     $index = $releaseID . '-';
                     $index .= $k + 1 . '-';
                     $index .= $members[$k]['GP_MemberID'];
                     $mailLog[$index]['message'] = $exc->getCode() . '-' . $exc->getFile() . '-' . $exc->getLine();
                     $mailLog[$index]['log'] = $protocol->getResponse();
                     $columnsMap = array('NEL_IdIndex' => 'NEL_IdIndex', 'NEL_CodeFileLine' => 'NEL_CodeFileLine', 'NEL_Response' => 'NEL_Response', 'NEL_Timestamp' => 'timestamp');
                     $writer = new Zend_Log_Writer_Db($this->_db, 'Newsletter_ErrorsLog', $columnsMap);
                     $oZLog = new Zend_Log($writer);
                     $oZLog->setEventItem('NEL_IdIndex', $index);
                     $oZLog->setEventItem('NEL_CodeFileLine', $mailLog[$index]['message']);
                     $oZLog->setEventItem('NEL_Response', $mailLog[$index]['log'][0]);
                     $oZLog->log('errors', 4);
                 }
             }
             $protocol->quit();
             $protocol->disconnect();
         } else {
             echo Zend_Json::encode(array('sentTo' => '0', 'targetedTotal' => '0', 'failedEmail' => array(), 'select' => $selection));
             break;
         }
         $stats['sentTo'] = $sentToCount;
         $dateTimeEnd = date('Y-m-d H:i:s');
         $release['NR_MailingDateTimeStart'] = $dateTimeStart;
         $release['NR_MailingDateTimeEnd'] = $dateTimeEnd;
         $release['NR_SendTo'] = $stats['action'] == 'set' ? $stats['sentTo'] : $release['NR_SendTo'] + $stats['sentTo'];
         $release['NR_TargetedTotal'] = $stats['action'] == 'set' ? $stats['targetedTotal'] : $release['NR_TargetedTotal'] + $stats['targetedTotal'];
         $release['NR_Status'] = 1;
         $release->save();
         if (count($failedEmailAddress) > 0) {
             $this->_recordEmails($failedEmailAddress, $releaseID);
         }
         $this->_stats = array('invalidEmails' => count($failedEmailAddress), 'errors' => count($mailLog), 'totalToSend' => $stats['targetedTotal'], 'totalSent' => $stats['sentTo']);
         if ($this->_isXmlHttpRequest) {
             array_push($listSent, $release['NR_Title']);
             array_push($listIds, $release['NR_ID']);
             array_push($listDest, $release['NR_AdminEmail']);
             $data = array('list' => $listSent, 'dest' => $listDest, 'ids' => $listIds);
             $this->_adminNotification($data);
             $this->_logSending($data);
         }
         echo Zend_Json::encode(array('sentTo' => $stats['sentTo'], 'targetedTotal' => $stats['targetedTotal'], 'failedEmail' => $failedEmailAddress, 'select' => $selection));
         exit;
     }
     // If all the newsletter have a status = 1, we don't pass through the foreach
     // So redirect the action to the newsletter
     //        echo(Zend_Json::encode(array('sentTo' => '0', 'targetedTotal' => '0', 'failedEmail' => array(), 'select' => '')));
     //        exit;
 }