send_open_leads.php 932 B

12345678910111213141516171819202122232425262728293031323334353637383940
  1. <?php
  2. use App\Enums\SaleStatuses;
  3. use App\Helpers\EmailHelper;
  4. use App\Sale;
  5. use Carbon\CarbonImmutable;
  6. use PHPMailer\PHPMailer\PHPMailer;
  7. require "../boot.php";
  8. $dt_now = CarbonImmutable::now("Europe/London");
  9. $date = $dt_now->format("d/m/Y");
  10. $sections = [];
  11. $sections[] = "Open leads as of $date";
  12. $leads = Sale::query([
  13. "status" => SaleStatuses::NEW,
  14. "dts_deleted" => null
  15. ], [
  16. "sort" => "id",
  17. "order" => "desc"
  18. ]);
  19. foreach($leads as $lead) {
  20. $location = $lead->getLocation();
  21. $sections[] = sprintf("%s - %s - %s", $lead->getReference(), $location->getDisplayName(), $lead->getDisplayAmount());
  22. }
  23. $body = implode("\n\n", $sections);
  24. $mailer = EmailHelper::getMailer();
  25. $mailer->addAddress("gabino@electrocoin.com", "Gabino Stergides");
  26. $mailer->CharSet = PHPMailer::CHARSET_UTF8;
  27. $mailer->Subject = "Open Leads As Of " . $dt_now->format("d/m/Y");
  28. $mailer->isHTML(false);
  29. $mailer->Body = $body;
  30. $mailer->send();