To merge in nicecoop-installation

[perso/Immae/Config/Nix.git] / modules / private / websites / nicecoop / gestion-compte / AmbassadorShiftTimeLogCommand.php

diff --git a/modules/private/websites/nicecoop/gestion-compte/AmbassadorShiftTimeLogCommand.php b/modules/private/websites/nicecoop/gestion-compte/AmbassadorShiftTimeLogCommand.php
new file mode 100644 (file)
index 0000000..e91a0a3
--- /dev/null
+++ b/modules/private/websites/nicecoop/gestion-compte/AmbassadorShiftTimeLogCommand.php
@@ -0,0 +1,92 @@
+<?php
+// src/AppBundle/Command/AmbassadorShiftTimeLogCommand.php
+namespace AppBundle\Command;
+
+use Swift_Message;
+use Symfony\Bundle\FrameworkBundle\Command\ContainerAwareCommand;
+use Symfony\Component\Console\Input\InputInterface;
+use Symfony\Component\Console\Input\InputOption;
+use Symfony\Component\Console\Output\OutputInterface;
+use Doctrine\ORM\Query\Expr\Join;
+
+class AmbassadorShiftTimeLogCommand extends ContainerAwareCommand
+{
+    protected function configure()
+    {
+        $this
+          ->setName('app:shift:send_late_shifters')
+          ->setDescription('Send shifters which are too late')
+          ->setHelp('This command allows you to send alerts for shifters that are too late')
+            ->addOption('emails', null, InputOption::VALUE_OPTIONAL, 'Email recipients (comma separated)')
+            ->addOption('emailTemplate', null, InputOption::VALUE_OPTIONAL, 'Template used in email alerts', 'SHIFT_LATE_ALERT_EMAIL');
+    }
+
+    protected function execute(InputInterface $input, OutputInterface $output)
+    {
+        $email_template = $input->getOption('emailTemplate');
+
+        $alerts = $this->computeAlerts();
+        $nbAlerts = count($alerts);
+        if ($nbAlerts > 0) {
+            $output->writeln('<fg=cyan;>Found ' . $nbAlerts . ' alerts to send</>');
+            $this->sendAlertsByEmail($input, $output, $alerts, $email_template);
+        } else {
+            $output->writeln('<fg=cyan;>No shift alert to send</>');
+        }
+    }
+
+    private function computeAlerts() {
+        $time_after_which_members_are_late_with_shifts = $this->getContainer()->getParameter('time_after_which_members_are_late_with_shifts');
+
+        $em = $this->getContainer()->get('doctrine')->getManager();
+        $qb = $em->getRepository("AppBundle:Membership")->createQueryBuilder('o');
+        $qb = $qb->leftJoin("o.beneficiaries", "b")
+            ->leftJoin("b.user", "u")
+            ->leftJoin("o.registrations", "r")->addSelect("r");
+        $qb = $qb->andWhere('o.member_number > 0'); //do not include admin user
+        $qb = $qb->leftJoin("o.registrations", "lr", Join::WITH,'lr.date > r.date')->addSelect("lr")
+            ->where('lr.id IS NULL') //registration is the last one registere
+            ->leftJoin("o.timeLogs", "c")->addSelect("c")
+            ->addSelect("(SELECT SUM(ti.time) FROM AppBundle\Entity\TimeLog ti WHERE ti.membership = o.id) AS HIDDEN time");
+        $qb = $qb->andWhere('o.withdrawn = 0');
+        $qb = $qb->andWhere('o.frozen = 0');
+        $qb = $qb->andWhere('b.membership IN (SELECT IDENTITY(t.membership) FROM AppBundle\Entity\TimeLog t GROUP BY t.membership HAVING SUM(t.time) < :compteurlt * 60)')
+            ->setParameter('compteurlt', $time_after_which_members_are_late_with_shifts);
+        $alerts = $qb->getQuery()->getResult();
+        return $alerts;
+    }
+
+    private function sendAlertsByEmail(InputInterface $input, OutputInterface $output, $alerts, $template) {
+        $mailer = $this->getContainer()->get('mailer');
+        $recipients = $input->getOption('emails') ? explode(',', $input->getOption('emails')) : null;
+        if ($recipients) {
+            setlocale(LC_TIME, 'fr_FR.UTF8');
+            $subject = '[ALERTE RETARDS] Membres en retard de shifts';
+
+            $shiftEmail = $this->getContainer()->getParameter('emails.shift');
+
+            $em = $this->getContainer()->get('doctrine')->getManager();
+            $dynamicContent = null;
+            //$dynamicContent = $em->getRepository('AppBundle:DynamicContent')->findOneByCode($template);
+            $template = null;
+            if ($dynamicContent) {
+                $template = $this->getContainer()->get('twig')->createTemplate($dynamicContent->getContent());
+            } else {
+                $template = 'emails/shift_late_alerts_default.html.twig';
+            }
+
+            $email = (new Swift_Message($subject))
+                ->setFrom($shiftEmail['address'], $shiftEmail['from_name'])
+                ->setTo($recipients)
+                ->setBody(
+                    $this->getContainer()->get('twig')->render(
+                        $template,
+                        array('alerts' => $alerts)
+                    ),
+                    'text/html'
+                );
+            $mailer->send($email);
+            $output->writeln('<fg=cyan;>Email(s) sent</>');
+        }
+    }
+}