コード例 #1
0
 /**
  * @see Console\Command\Command
  */
 protected function execute(Console\Input\InputInterface $input, Console\Output\OutputInterface $output)
 {
     $this->em = $this->getApplication()->getKernel()->getContainer()->get('doctrine')->getManager();
     $etcDirectory = APPLICATION_PATH . '/../conf/';
     $notifierTemplate = '_events_notifier.tpl';
     $message = array();
     if (!FilesystemService::isReadable($etcDirectory . '/install_conf.php')) {
         exit;
     }
     // includes installation configuration file
     require_once $etcDirectory . '/install_conf.php';
     // includes campsite initialisation
     require_once APPLICATION_PATH . '/../include/campsite_init.php';
     if (!is_file($etcDirectory . '/database_conf.php')) {
         $output->writeln('Database configuration file is missing!');
         return;
     }
     $message['reply'] = $this->getReplyAddress();
     $autoId = $this->getAutoId();
     $logTimestamp = $autoId->getLogTimestamp();
     $logs = $this->em->getRepository('Newscoop\\Entity\\Log')->createQueryBuilder('l')->select('l, e, u')->leftJoin('l.eventId', 'e')->leftJoin('l.userId', 'u')->where('l.eventId = e.id')->andWhere('l.userId = u.id')->andWhere('e.notify = :notify')->andWhere('l.created > :logTimestamp')->getQuery()->setParameters(array('logTimestamp' => $logTimestamp, 'notify' => 'Y'))->getResult();
     if (count($logs) == 0) {
         return false;
     }
     $tpl = $this->initSmarty();
     $recipients = $this->getApplication()->getKernel()->getContainer()->getService('notification')->findRecipients();
     $lastTimestamp = null;
     if ($input->getOption('verbose')) {
         $output->writeln('<info>Number of found logs: ' . count($logs) . '.<info>');
     }
     foreach ($logs as $log) {
         $lastTimestamp = $log->getCreated();
         $tpl->assign('user_real_name', $log->getUser()->getFirstName());
         $tpl->assign('user_name', $log->getUser()->getUsername());
         $tpl->assign('user_email', $log->getUser()->getEmail());
         $tpl->assign('event_text', $log->getMessage());
         $tpl->assign('event_timestamp', $log->getCreated()->format('Y-m-d h:i:s'));
         $message['text'] = $tpl->fetch($notifierTemplate);
         if (count($recipients) <= 0) {
             if ($input->getOption('verbose')) {
                 $output->writeln('<error>There is no recipients.<error>');
             }
             continue;
         }
         $message['recipients'] = $recipients;
         $message['subject'] = $log->getEvent()->getName();
         $this->sendEmail($message);
         if ($input->getOption('verbose')) {
             $output->writeln('<info>Send message for event: ' . $log->getEvent()->getName() . '.<info>');
         }
     }
     if ($lastTimestamp != null) {
         $autoId->setLogTimestamp($lastTimestamp);
     }
     $this->em->flush();
 }
コード例 #2
0
 /**
  * @see Console\Command\Command
  */
 protected function execute(Console\Input\InputInterface $input, Console\Output\OutputInterface $output)
 {
     $this->em = $this->getApplication()->getKernel()->getContainer()->getService('em');
     $etcDirectory = APPLICATION_PATH . '/../conf/';
     $notifierTemplate = '_subscription_notifier.tpl';
     $message = array();
     $notifiedIndex = false;
     if (!FilesystemService::isReadable($etcDirectory . '/install_conf.php')) {
         exit;
     }
     require_once $etcDirectory . '/install_conf.php';
     require_once APPLICATION_PATH . '/../include/campsite_init.php';
     if (!is_file($etcDirectory . '/database_conf.php')) {
         $output->writeln('Database configuration file is missed!');
         return;
     }
     $message['reply'] = $this->getReplyAddress();
     $endingSubscriptions = $this->getEndingSubscriptions();
     if (count($endingSubscriptions) == 0) {
         if ($input->getOption('verbose')) {
             $output->writeln('<info>There is no ending subscriptions.<info>');
         }
         return;
     }
     $tpl = $this->initSmarty();
     $notifiedIndex = 0;
     foreach ($endingSubscriptions as $subscription) {
         $issueMaxNumber = $this->getIssueMaxNumber($subscription->getPublication()->getId(), $subscription->getPublication()->getDefaultLanguage()->getId());
         $subscriptionSectionToUpdate = $this->em->getRepository('Newscoop\\Subscription\\Section')->createQueryBuilder('ss')->where('ss.subscription = :subscription')->setParameter('subscription', $subscription->getId());
         if ($issueMaxNumber === false) {
             if ($input->getOption('verbose')) {
                 $output->writeln('<info>There is o issues for publication default language.<info>');
             }
             return;
         }
         $sectionsCount = $this->getSectionCounts($subscription, $issueMaxNumber);
         $subscritpionsSections = $this->getSubscritpionsSections($subscription->getId());
         if ($subscritpionsSections <= 0) {
             continue;
         }
         $text = '';
         $notify = false;
         $subsSections = 0;
         $counter = 0;
         $sections = '';
         foreach ($subscritpionsSections as $subscriptionSection) {
             $startDate = $subscriptionSection[0]->getStartDate();
             $formatedStartDate = $subscriptionSection['formated_start_date'];
             $paidDays = $subscriptionSection[0]->getPaidDays();
             $toDaysStartDate = $subscriptionSection['to_days_start_date'];
             $toDaysNow = $subscriptionSection['to_days_now'];
             $formatedEndDate = $subscriptionSection['formated_end_date'];
             if ($toDaysNow > $paidDays + $toDaysStartDate) {
                 continue;
             }
             $remainedDays = $paidDays + $toDaysStartDate - $toDaysNow;
             if ($remainedDays > 14 || $remainedDays <= 0) {
                 continue;
             }
             $notify = true;
             if (count($subscritpionsSections) == 1) {
                 $subSectionsCount = $this->em->getRepository('Newscoop\\Subscription\\Section')->createQueryBuilder('ss')->select('ss')->where('ss.subscription = :subscription')->andWhere('ss.noticeSent = :noticeSent')->andWhere('ss.startDate = :startDate')->andWhere('ss.paidDays = :paidDays')->getQuery()->setParameters(array('subscription' => $subscription->getId(), 'noticeSent' => 'N', 'startDate' => $startDate, 'paidDays' => $paidDays))->getResult();
             }
             if ($counter == 0) {
                 $subsType = $subscription->getType() == 'P' ? 'paid' : 'trial';
                 $tpl->assign('user_title', $subscription->getUser()->getFirstName());
                 $tpl->assign('user_name', $subscription->getUser()->getFirstName());
                 $tpl->assign('subs_type', $subsType);
                 $tpl->assign('subs_date', $formatedStartDate);
                 $tpl->assign('publication_name', $subscription->getPublication()->getName());
             }
             if ($subsSections == $sectionsCount && count($subscritpionsSections) == 1) {
                 $tpl->assign('subs_expire', 1);
                 $tpl->assign('subs_expire_date', $formatedEndDate);
                 $tpl->assign('subs_remained_days', $remainedDays);
             } else {
                 $sectionData = $this->em->getRepository('Newscoop\\Entity\\Section')->createQueryBuilder('s')->select('s.name, s.number')->from('Newscoop\\Subscription\\Section', 'ss')->andWhere('ss.subscription = :subscription')->andWhere('ss.noticeSent = :noticeSent')->andWhere('ss.startDate = :startDate')->andWhere('ss.paidDays = :paidDays')->andWhere('s.publication = :publication')->andWhere('s.issue = :issue')->andWhere('s.language = :language')->andWhere('s.number = ss.sectionNumber')->getQuery()->setParameters(array('subscription' => $subscription->getId(), 'noticeSent' => 'N', 'startDate' => $startDate, 'paidDays' => $paidDays, 'publication' => $subscription->getPublication()->getId(), 'issue' => $issueMaxNumber, 'language' => $subscription->getPublication()->getDefaultLanguage()))->getResult();
                 if ($counter == 0) {
                     $tpl->assign('subs_expire_plan', 1);
                 }
                 $expirePlan = '\\t- ';
                 $isFirst = true;
                 foreach ($sectionData as $key => $section) {
                     if (!$isFirst) {
                         $expirePlan .= ', ';
                     } else {
                         $isFirst = false;
                     }
                     $subscriptionSectionToUpdate->orWhere('ss.section = :sectionNumber_' . $key);
                     $subscriptionSectionToUpdate->setParameter('sectionNumber_' . $key, $section['number']);
                     $expirePlan .= '"' . $section['name'] . '"';
                 }
                 $tpl->assign('expire_plan', $expirePlan);
                 $tpl->assign('subs_expire_date', $formatedEndDate);
                 $tpl->assign('subs_remained_days', $remainedDays);
                 $tpl->assign('subs_start_date', $formatedStartDate);
                 $counter++;
             }
         }
         $tpl->assign('site', $subscription->getPublication()->getDefaultAlias()->getName());
         if (!$notify) {
             continue;
         }
         $message['recipients'] = array($subscription->getUser()->getEmail());
         $message['text'] = $tpl->fetch($notifierTemplate);
         $message['subject'] = 'Subscription to ' . $subscription->getPublication()->getName();
         if ($this->sendEmail($message) == false) {
             continue;
         }
         $subscriptionSectionToUpdate = $subscriptionSectionToUpdate->getQuery()->getResult();
         foreach ($subscriptionSectionToUpdate as $updateMe) {
             $updateMe->setNoticeSent('Y');
         }
         $this->em->flush();
         $notifiedIndex++;
     }
     if ($notifiedIndex > 0) {
         if ($input->getOption('verbose')) {
             $output->writeln('<info>' . $notifiedIndex . ' user(s) notified.<info>');
         }
     }
 }