format("d/m/Y"); $sections = []; $sections[] = "Open leads as of $date"; $leads = Sale::query([ "status" => SaleStatuses::NEW, "dts_deleted" => null ], [ "sort" => "id", "order" => "desc" ]); foreach($leads as $lead) { $location = $lead->getLocation(); $sections[] = sprintf("%s - %s - %s", $lead->getReference(), $location->getDisplayName(), $lead->getDisplayAmount()); } $body = implode("\n\n", $sections); $mailer = EmailHelper::getMailer(); $mailer->addAddress("gabino@electrocoin.com", "Gabino Stergides"); $mailer->CharSet = PHPMailer::CHARSET_UTF8; $mailer->Subject = "Open Leads As Of " . $dt_now->format("d/m/Y"); $mailer->isHTML(false); $mailer->Body = $body; $mailer->send();