src/Controller/StartController.php line 33

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  6. use Symfony\Component\HttpFoundation\Response;
  7. use Symfony\Component\HttpFoundation\Request;
  8. use Symfony\Component\Routing\Annotation\Route;
  9. use App\Entity\EmailTemplates;
  10. use App\Entity\SmsHistory;
  11. use App\Entity\SmsTemplates;
  12. use App\Repository\EmailTemplatesRepository;
  13. use App\Repository\SmsHistoryRepository;
  14. use App\Repository\SmsTemplatesRepository;
  15. use App\Repository\WarrantyRepository;
  16. use App\Repository\EventRepository;
  17. use App\Service\ConfigDataService;
  18. use Symfony\Component\Mailer\Transport;
  19. use Symfony\Component\Mailer\Mailer;
  20. use Symfony\Component\Mime\Email;
  21. use Symfony\Component\Mime\Address;
  22. use Smsapi\Client\Curl\SmsapiHttpClient;
  23. use Smsapi\Client\Feature\Sms\Bag\SendSmsBag;
  24. use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  25. use Symfony\Bridge\Twig\Mime\TemplatedEmail;
  26. use Symfony\Bridge\Twig\Mime\BodyRenderer;
  27. use Twig\Environment;
  30. class StartController extends AbstractController
  31. {
  32.     #[Route('/', name: 'app_start')]
  33.     public function homepager(): Response
  34.     {
  35.         return $this->render('start/index.html.twig', [
  36.             'controller_name' => 'StartController',
  37.         ]);
  38.     }
  40.     #[Route('/cronjob_send_email_client', name: 'app_cronjob_send_email_client')]
  41.     public function cronSendEmailClient(EventRepository $eventRepository, EmailTemplatesRepository $emailTemplatesRepository, ConfigDataService $configDataService, SmsHistoryRepository $smsHistoryRepository, SmsTemplatesRepository $smsTemplatesRepository, Request $request): Response
  42.     {
  43.         $emailTemplates = new EmailTemplates();
  44.         $emailTemplatesfindOneByTypeBefore = $emailTemplatesRepository->findOneByType($emailTemplates::TYPE_BEFORE);
  45.         $notificationBeforeEvent = $configDataService->get('before_event');
  46.         $notification = json_decode($notificationBeforeEvent, false, 512, JSON_THROW_ON_ERROR);
  47.         
  48.         $newDate = new \DateTime('2022-12-31');
  49.         $events = $eventRepository->findBy(['event_date' => $newDate]);
  50.         //dd($notification);
  51.         foreach($events as $event) {
  53.             $company_name = $configDataService->get('company_name');
  54.             $eventDate = ($event->getEventDate() != null) ? $event->getEventDate()->format('d-m-Y') : ''; 
  55.             
  56.             $contractDate = ($event->getContractDate() != null) ? $event->getContractDate()->format('d-m-Y') : ''; 
  57.             //dd($newEventDetailsPage);
  58.             $const = array(
  59.                 '[EVENT_DATE]'  => $eventDate,
  60.                 '[CONTRACT_NUMBER]' => $event->getContractNumber() . '/'. $contractDate,
  61.                 '[LOCATION]' => $event->getEventLocation()->getName(),
  62.                 '[TOTAL]'=> $event->getEventPrice()->getTotal(),
  63.                 '[ADVANCE]'=> $event->getEventPrice()->getAdvance(),
  64.                 '[AMOUNT DUE]'=> $event->getEventPrice()->getAmountDue(),
  65.                 '[EMAIL]' => $event->getClient()->getEmail(),
  66.                 '[PHONE]'   => $event->getClient()->getPhone(),
  67.                 '[FIRSTNAME]'   => $event->getClient()->getFirstName(),
  68.                 '[LASTNAME]'   => $event->getClient()->getLastName(),
  69.                 '[COMPANY_NAME]' => $company_name,
  70.                 '[SERVICE_NAME]' => $event->getService()->getName(),
  71.             );
  73.             if($notification->email == true){
  74.                 if($event->getClient()->getEmail()) {
  75.                     if( $configDataService->get('Transport') == 'sendgrid') {
  76.                         $sendGridKey = $configDataService->get('sendGridKey');
  77.                         $dsn = "sendgrid+api://". $sendGridKey ."@default";
  78.                         $transport = Transport::fromDsn($dsn);
  79.                         $mailer = new Mailer($transport);
  80.                     } else if($configDataService->get('Transport') == 'smtp') {
  81.                        //dd($configDataService);
  82.                         $host = $configDataService->get('Host');
  83.                         $port = $configDataService->get('port');
  84.                         $username = $configDataService->get('username');
  85.                         $password = $configDataService->get('password');
  86.                         $dsn = 'smtp://'.$username.':'.$password.'@'.$host.':'. $port;
  87.                         $transport = Transport::fromDsn($dsn);
  88.                         $mailer = new Mailer($transport);
  89.                     }
  90.                     //dd($const);
  91.                     $emailContent = strtr($emailTemplatesfindOneByTypeBefore->getContent(), $const);
  92.                     //dd($emailContent);
  93.                     $emailTitle = str_replace(array_keys($const), array_values($const), $emailTemplatesfindOneByTypeBefore->getTitle());
  94.                     $fromName = $configDataService->get('fromName');
  95.                     $fromEmail = $configDataService->get('fromEmail');
  96.                     $email = (new Email())
  97.                         ->from(new Address($fromEmail, $fromName))
  98.                         ->to($event->getClient()->getEmail())
  99.                         //->cc('cc@example.com')
  100.                         //->bcc('bcc@example.com')
  101.                         //->replyTo('fabien@example.com')
  102.                         //->priority(Email::PRIORITY_HIGH)
  103.                         ->subject($emailTitle)
  104.                         ->html($emailContent);
  105.                     try {
  106.                         $mailer->send($email);
  107.                     } catch(TransportExceptionInterface $e) {
  108.                         $this->addFlash('app_event_error', $e->getMessage());
  109.                        // return $this->redirectToRoute('app_event_index', [], Response::HTTP_SEE_OTHER);       
  110.                     }
  111.                 } else {
  112.                     $this->addFlash('app_event_error', 'Email address is empty. Cannot send email!');
  113.                 }         
  114.             }
  115.             if($notification->sms == true) {
  116.                 if($event->getClient()->getPhone()){
  117.                     $phone = $event->getClient()->getPhone();                      
  118.                     $smsApiHttpClient = new SmsapiHttpClient();
  119.                     $smsApiToken = $configDataService->get('smsApiToken');
  120.                     $service = $smsApiHttpClient->smsapiComService($smsApiToken); 
  121.                     $result = $service->pingFeature()->ping();
  122.                             //dd($result);
  123.                     if ($result->authorized) {
  124.                         $smsTemplates = new SmsTemplates();
  125.                         $smsTemplatesfindOneByTypeBefore = $smsTemplatesRepository->findOneByType($smsTemplates::TYPE_BEFORE);
  126.                         $smsContent = strtr($smsTemplatesfindOneByTypeBefore->getContent(), $const);
  127.                         $smsBag = SendSmsBag::withMessage($phone, $smsContent);
  128.                         //dd($smsContent);
  129.                         $smsServiceBack = $service->smsFeature()->sendSms($smsBag);
  130.                         $smsHistory = new SmsHistory();
  131.                         $smsHistory->setIdSmsapi($smsServiceBack->id);
  132.                         $smsHistory->setPoints($smsServiceBack->points);
  133.                         $smsHistory->setDateSent($smsServiceBack->dateSent);
  134.                         $smsHistory->setStatus($smsServiceBack->status);
  135.                         $smsHistory->setContent($smsServiceBack->content->message);
  136.                         $smsHistory->setEvent($event);
  137.                         $smsHistoryRepository->save($smsHistory, true);
  138.                        }                                    
  139.                    } else {
  140.                     $this->addFlash('app_event_error', 'Phone address is empty. Cannot send sms!');
  141.                 }     
  142.             }
  143.         }
  144.         return new Response('OK!');
  145.     }
  147.     #[Route('/cronjob_send_email_client_after_event', name: 'app_cronjob_send_email_client_after_event')]
  148.     public function cronSendEmailClientAfterEvent(EventRepository $eventRepository, EmailTemplatesRepository $emailTemplatesRepository, ConfigDataService $configDataService, SmsHistoryRepository $smsHistoryRepository, SmsTemplatesRepository $smsTemplatesRepository, Request $request): Response
  149.     {
  150.         $emailTemplates = new EmailTemplates();
  151.         $emailTemplatesfindOneByTypeAfter = $emailTemplatesRepository->findOneByType($emailTemplates::TYPE_AFTER);
  152.         $notificationAfterEvent = $configDataService->get('after_event');
  153.         $notification = json_decode($notificationAfterEvent, false, 512, JSON_THROW_ON_ERROR);
  155.         $events = $eventRepository->getEventsToSendEmailClientAfterEvent('cancelled');
  156.            //dd($events);
  157.         foreach($events as $event) {
  159.             $company_name = $configDataService->get('company_name');
  160.             $eventDate = ($event->getEventDate() != null) ? $event->getEventDate()->format('d-m-Y') : ''; 
  161.             
  162.             $contractDate = ($event->getContractDate() != null) ? $event->getContractDate()->format('d-m-Y') : ''; 
  163.             //dd($newEventDetailsPage);
  164.             $const = array(
  165.                 '[EVENT_DATE]'  => $eventDate,
  166.                 '[CONTRACT_NUMBER]' => $event->getContractNumber() . '/'. $contractDate,
  167.                 '[LOCATION]' => $event->getEventLocation()->getName(),
  168.                 '[TOTAL]'=> $event->getEventPrice()->getTotal(),
  169.                 '[ADVANCE]'=> $event->getEventPrice()->getAdvance(),
  170.                 '[AMOUNT DUE]'=> $event->getEventPrice()->getAmountDue(),
  171.                 '[EMAIL]' => $configDataService->get('email'),
  172.                 '[PHONE]'   => $configDataService->get('phone'),
  173.                 '[FIRSTNAME]'   => $event->getClient()->getFirstName(),
  174.                 '[LASTNAME]'   => $event->getClient()->getLastName(),
  175.                 '[COMPANY_NAME]' => $company_name,
  176.                 '[SERVICE_NAME]' => $event->getService()->getName(),
  178.             );
  179.             if($notification->email == true){
  180.                 if($event->getClient()->getEmail()) {
  181.                     if( $configDataService->get('Transport') == 'sendgrid') {
  182.                         $sendGridKey = $configDataService->get('sendGridKey');
  183.                         $dsn = "sendgrid+api://". $sendGridKey ."@default";
  184.                         $transport = Transport::fromDsn($dsn);
  185.                         $mailer = new Mailer($transport);
  186.                     } else if($configDataService->get('Transport') == 'smtp') {
  187.                        //dd($configDataService);
  188.                         $host = $configDataService->get('Host');
  189.                         $port = $configDataService->get('port');
  190.                         $username = $configDataService->get('username');
  191.                         $password = $configDataService->get('password');
  192.                         $dsn = 'smtp://'.$username.':'.$password.'@'.$host.':'. $port;
  193.                         $transport = Transport::fromDsn($dsn);
  194.                         $mailer = new Mailer($transport);
  195.                     }
  196.                     if($emailTemplatesfindOneByTypeAfter != null) {
  197.                         $emailContent = strtr($emailTemplatesfindOneByTypeAfter->getContent(), $const);
  198.                         //dd($emailContent);
  199.                         $emailTitle = str_replace(array_keys($const), array_values($const), $emailTemplatesfindOneByTypeAfter->getTitle());
  200.                         $fromName = $configDataService->get('fromName');
  201.                         $fromEmail = $configDataService->get('fromEmail');
  202.                         $email = (new Email())
  203.                             ->from(new Address($fromEmail, $fromName))
  204.                             ->to($event->getClient()->getEmail())
  205.                             //->cc('cc@example.com')
  206.                             //->bcc('bcc@example.com')
  207.                             //->replyTo('fabien@example.com')
  208.                             //->priority(Email::PRIORITY_HIGH)
  209.                             ->subject($emailTitle)
  210.                             ->html($emailContent);
  211.                         try {
  212.                             $mailer->send($email);
  213.                         } catch(TransportExceptionInterface $e) {
  214.                             $this->addFlash('app_event_error', $e->getMessage());
  215.                            // return $this->redirectToRoute('app_event_index', [], Response::HTTP_SEE_OTHER);       
  216.                         }
  217.                     } else {
  218.                         $this->addFlash('app_emailtemplate_error', 'Template is not set for after event!');
  219.                         return $this->redirectToRoute('app_email_templates_index', [], Response::HTTP_SEE_OTHER); 
  220.                     }
  221.                     
  222.                 } else {
  223.                     $this->addFlash('app_event_error', 'Email address is empty. Cannot send email!');
  224.                     return $this->redirectToRoute('app_email_templates_index', [], Response::HTTP_SEE_OTHER); 
  225.                 }         
  226.             }
  227.             if($notification->sms == true) {
  228.                 if($event->getClient()->getPhone()){
  229.                     $phone = $event->getClient()->getPhone();                      
  230.                     $smsApiHttpClient = new SmsapiHttpClient();
  231.                     $smsApiToken = $configDataService->get('smsApiToken');
  232.                     $service = $smsApiHttpClient->smsapiComService($smsApiToken); 
  233.                     $result = $service->pingFeature()->ping();
  234.                             //dd($result);
  235.                     if ($result->authorized) {
  236.                         $smsTemplates = new SmsTemplates();
  237.                         $smsTemplatesfindOneByTypeAfter = $smsTemplatesRepository->findOneByType($smsTemplates::TYPE_AFTER);
  238.                         $smsContent = strtr($smsTemplatesfindOneByTypeAfter->getContent(), $const);
  239.                         $smsBag = SendSmsBag::withMessage($phone, $smsContent);
  240.                         //dd($smsContent);
  241.                         $smsServiceBack = $service->smsFeature()->sendSms($smsBag);
  242.                         $smsHistory = new SmsHistory();
  243.                         $smsHistory->setIdSmsapi($smsServiceBack->id);
  244.                         $smsHistory->setPoints($smsServiceBack->points);
  245.                         $smsHistory->setDateSent($smsServiceBack->dateSent);
  246.                         $smsHistory->setStatus($smsServiceBack->status);
  247.                         $smsHistory->setContent($smsServiceBack->content->message);
  248.                         $smsHistory->setEvent($event);
  249.                         $smsHistoryRepository->save($smsHistory, true);
  250.                        }                                    
  251.                    } else {
  252.                     $this->addFlash('app_event_error', 'Phone address is empty. Cannot send sms!');
  253.                     return $this->redirectToRoute('app_email_templates_index', [], Response::HTTP_SEE_OTHER); 
  254.                 }     
  255.             }
  256.         }
  257.         return new Response('OK!');
  258.     }
  261.     #[Route('/cronjob_send_email_user', name: 'app_cronjob_send_email_user')]
  262.     public function cronSendEmailUser(EventRepository $eventRepository, EmailTemplatesRepository $emailTemplatesRepository, ConfigDataService $configDataService, SmsHistoryRepository $smsHistoryRepository, SmsTemplatesRepository $smsTemplatesRepository, Request $request): Response
  263.     {
  264.         $emailTemplates = new EmailTemplates();
  265.         $emailTemplatesfindOneByTypeBefore = $emailTemplatesRepository->findOneByType($emailTemplates::TYPE_USER_REMINDER);
  266.            //$baseURL = $request->getSchemeAndHttpHost();
  267.         $events = $eventRepository->getEventsToSendEmailUser('active');
  268.         //dd($events);
  269.         //$newDate = new \DateTime('2022-12-31');
  270.         //$events = $eventRepository->findBy(['event_date' => $newDate]);
  271.         //dd($events);
  272.         foreach($events as $event) {
  273.             if($event->getClient()->getEmail()){
  275.                 if( $configDataService->get('Transport') == 'sendgrid') {
  276.                     $sendGridKey = $configDataService->get('sendGridKey');
  277.                     $dsn = "sendgrid+api://". $sendGridKey ."@default";
  278.                     $transport = Transport::fromDsn($dsn);
  279.                     $mailer = new Mailer($transport);
  280.                 } else if($configDataService->get('Transport') == 'smtp') {
  281.                    //dd($configDataService);
  282.                     $host = $configDataService->get('Host');
  283.                     $port = $configDataService->get('port');
  284.                     $username = $configDataService->get('username');
  285.                     $password = $configDataService->get('password');
  286.                     $dsn = 'smtp://'.$username.':'.$password.'@'.$host.':'. $port;
  287.                     $transport = Transport::fromDsn($dsn);
  288.                     $mailer = new Mailer($transport);
  289.                 }
  291.                 $company_name = $configDataService->get('company_name');
  292.                 $eventDate = ($event->getEventDate() != null) ? $event->getEventDate()->format('d-m-Y') : ''; 
  293.                 
  294.                 $contractDate = ($event->getContractDate() != null) ? $event->getContractDate()->format('d-m-Y') : ''; 
  295.                 //dd($newEventDetailsPage);
  296.                 $const = array(
  297.                     '[EVENT_DATE]'  => $eventDate,
  298.                     '[CONTRACT_NUMBER]' => $event->getContractNumber() . '/'. $contractDate,
  299.                     '[LOCATION]' => $event->getEventLocation()->getName(),
  300.                     '[TOTAL]'=> $event->getEventPrice()->getTotal(),
  301.                     '[ADVANCE]'=> $event->getEventPrice()->getAdvance(),
  302.                     '[AMOUNT DUE]'=> $event->getEventPrice()->getAmountDue(),
  303.                     '[EMAIL]' => $event->getClient()->getEmail(),
  304.                     '[PHONE]'   => $event->getClient()->getPhone(),
  305.                     '[FIRSTNAME]'   => $event->getClient()->getFirstName(),
  306.                     '[LASTNAME]'   => $event->getClient()->getLastName(),
  307.                     '[COMPANY_NAME]' => $company_name,
  308.                     '[SERVICE_NAME]' => $event->getService()->getName(),
  309.                 );
  310.                 //dd($const);
  311.                 $emailContent = strtr($emailTemplatesfindOneByTypeBefore->getContent(), $const);
  313.                 $notificationEventDetailsJson = $configDataService->get('email_user_reminder');
  314.                 $notificationEventDetailsUsers = json_decode($notificationEventDetailsJson, true, 512, JSON_THROW_ON_ERROR);
  315.                 $notificationEventDetails = json_decode($notificationEventDetailsUsers['users'], true, 512, JSON_THROW_ON_ERROR);
  317.                 //dd($emailContent);
  318.                 $emailTitle = str_replace(array_keys($const), array_values($const), $emailTemplatesfindOneByTypeBefore->getTitle());
  319.                 $fromName = $configDataService->get('fromName');
  320.                 $fromEmail = $configDataService->get('fromEmail');
  321.                 if(in_array($fromEmail, $notificationEventDetails)) {
  322.                         //dd($notificationEventDetails);
  323.                     foreach($notificationEventDetails as $key=>$notificationEventDetail) {
  324.                         if($notificationEventDetail == $fromEmail) {
  325.                             unset($notificationEventDetails[$key]);
  326.                         }           
  327.                     }
  328.                 }
  329.                 $notificationEventDetailsMail =  array_values($notificationEventDetails);
  331.                 $email = (new Email())
  332.                     ->from(new Address($fromEmail, $fromName))
  333.                     ->to($fromEmail)
  334.                     ->cc(...$notificationEventDetailsMail)
  335.                     //->bcc('bcc@example.com')
  336.                     //->replyTo('fabien@example.com')
  337.                     //->priority(Email::PRIORITY_HIGH)
  338.                     ->subject($emailTitle)
  339.                     ->html($emailContent);
  340.                 try {
  341.                     $mailer->send($email);
  342.                 } catch(TransportExceptionInterface $e) {
  343.                     $this->addFlash('app_event_error', $e->getMessage());
  344.                    // return $this->redirectToRoute('app_event_index', [], Response::HTTP_SEE_OTHER);       
  345.                 }
  346.             }
  347.         }
  348.         return new Response('OK!');
  349.     }
  351.      #[Route('/cronjob_send_email_expire_warranties', name: 'app_cronjob_send_email_expire_warranties')]
  352.     public function cronSendEmailExpireWarranty(WarrantyRepository $warrantyRepository, EmailTemplatesRepository $emailTemplatesRepository, ConfigDataService $configDataService, SmsTemplatesRepository $smsTemplatesRepository, Request $request, Environment $twig): Response
  353.     {
  354.         $configWarrantyDaysReminder = $configDataService->get('warrantyDaysReminder');
  355.            //$baseURL = $request->getSchemeAndHttpHost();
  356.         $warranties = $warrantyRepository->findWarrantiesActiveToSendEmail('active', $configWarrantyDaysReminder);
  357.         //dd($events);
  358.         //$newDate = new \DateTime('2022-12-31');
  359.         //$events = $eventRepository->findBy(['event_date' => $newDate]);
  360.         //dd($events);
  361.         foreach($warranties as $warranty) {
  362.             if($configDataService->get('fromEmail') != null){
  364.                 if( $configDataService->get('Transport') == 'sendgrid') {
  365.                     $sendGridKey = $configDataService->get('sendGridKey');
  366.                     $dsn = "sendgrid+api://". $sendGridKey ."@default";
  367.                     $transport = Transport::fromDsn($dsn);
  368.                     $mailer = new Mailer($transport);
  369.                 } else if($configDataService->get('Transport') == 'smtp') {
  370.                    //dd($configDataService);
  371.                     $host = $configDataService->get('Host');
  372.                     $port = $configDataService->get('port');
  373.                     $username = $configDataService->get('username');
  374.                     $password = $configDataService->get('password');
  375.                     $dsn = 'smtp://'.$username.':'.$password.'@'.$host.':'. $port;
  376.                     $transport = Transport::fromDsn($dsn);
  377.                     $mailer = new Mailer($transport);
  378.                 }
  381.                 //dd($emailContent);
  382.                 $emailTitle = "Notificare garantie: Peste ". $configWarrantyDaysReminder ." zile expira " . $warranty->getName();
  383.                 $fromName = $configDataService->get('fromName');
  384.                 $fromEmail = $configDataService->get('fromEmail');
  386.                 $email = (new TemplatedEmail())
  387.                     ->from(new Address($fromEmail, $fromName))
  388.                     ->to($fromEmail)
  389.                     //->bcc('bcc@example.com')
  390.                     //->replyTo('fabien@example.com')
  391.                     //->priority(Email::PRIORITY_HIGH)
  392.                     ->subject($emailTitle)
  393.                     ->htmlTemplate('emails/warranty_notification.html.twig')
  394.                     ->context([
  395.                         'warranty' => $warranty,
  396.                         'config'    => $configDataService,
  397.                     ]);
  398.                     $renderer = new BodyRenderer($twig);
  399.                     $renderer->render($email);
  400.                 try {
  401.                     $mailer->send($email);
  402.                 } catch(TransportExceptionInterface $e) {
  403.                     $this->addFlash('app_event_error', $e->getMessage());
  404.                    // return $this->redirectToRoute('app_event_index', [], Response::HTTP_SEE_OTHER);       
  405.                 }
  406.             }
  407.         }
  408.         return new Response('OK!');
  409.     }
  410. }