Symfony Profiler

<?php
namespace App\Controller;
use App\Entity\Entrants;
use App\Entity\MailingList;
use App\Entity\Regions;
use App\Entity\Tenders;
use App\Entity\Categories;
use App\Entity\Content;
use App\Form\Type\MailListFormType;
use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
use Symfony\Component\Mailer\MailerInterface;
use Symfony\Component\Mime\Email;
use Symfony\Component\Routing\Annotation\Route;
use Symfony\Component\HttpFoundation\Request;
class HomeController extends AbstractController {
/**
* @Route("/", name="homepage")
*/
public function indexAction(\Symfony\Component\HttpFoundation\Request $request){
$repo_regions = $this->getDoctrine()->getRepository(Regions::class)->findAll();
$repo_content = $this->getDoctrine()->getRepository(Content::class)->findOneBy(['page' => 'home-page']);
$repo_tenders = $this->getDoctrine()->getRepository(Tenders::class);
$closing_soon = $repo_tenders->getTendersClosing();
$repo_entrants = $this->getDoctrine()->getRepository(Entrants::class)->findAll();
if(count($repo_regions) > 0){
$tenders = [];
foreach($repo_regions as $region){
$tenders_repo = $repo_tenders->getTenders(1, $region->getId());
$arr = [];
for($i=0;$i<count($tenders_repo);$i++) {
$repo_cat = $this->getDoctrine()->getRepository(Categories::class)->findOneBy(['id' => $tenders_repo[$i]->getCategory()]);
$arr[] = [
'id' => $tenders_repo[$i]->getId(),
'closingDate' => $tenders_repo[$i]->getClosingDate(),
'projectNumber' => $tenders_repo[$i]->getProjectNumber(),
'contractDescription' => $tenders_repo[$i]->getContractDescription(),
'category' => $repo_cat->getCategory(),
'region' => $region->getRegion(),
'thumbnail' => $region->getThumbnail(),
];
}
$tenders[]['region'] = [
'regionId' => $region->getId(),
'regionName' => $region->getRegion(),
'thumb' => $region->getThumbnail(),
'data' => $arr
];
}
}
return $this->render('frontend/index.html.twig',
[
'copy' => $repo_content->getCopy(),
'regions' => $tenders,
'page' => 'home',
'closing_soon' => $closing_soon,
'entrants' => $repo_entrants,
'subscribed' => 0
]);
}
/**
* @Route("/subscribe/thank-you", name="subscribe_page")
*/
public function getSubscribeForm(MailerInterface $mailer, Request $request)
{
$repo_regions = $this->getDoctrine()->getRepository(Regions::class)->findAll();
$repo_content = $this->getDoctrine()->getRepository(Content::class)->findOneBy(['page' => 'home-page']);
$repo_tenders = $this->getDoctrine()->getRepository(Tenders::class);
$closing_soon = $repo_tenders->getTendersClosing();
$repo_entrants = $this->getDoctrine()->getRepository(Entrants::class)->findAll();
if(count($repo_regions) > 0){
$tenders = [];
foreach($repo_regions as $region){
$tenders_repo = $repo_tenders->getTenders(1, $region->getId());
$arr = [];
for($i=0;$i<count($tenders_repo);$i++) {
$repo_cat = $this->getDoctrine()->getRepository(Categories::class)->findOneBy(['id' => $tenders_repo[$i]->getCategory()]);
$arr[] = [
'id' => $tenders_repo[$i]->getId(),
'closingDate' => $tenders_repo[$i]->getClosingDate(),
'projectNumber' => $tenders_repo[$i]->getProjectNumber(),
'contractDescription' => $tenders_repo[$i]->getContractDescription(),
'category' => $repo_cat->getCategory(),
'region' => $region->getRegion(),
'thumbnail' => $region->getThumbnail(),
];
}
$tenders[]['region'] = [
'regionId' => $region->getId(),
'regionName' => $region->getRegion(),
'thumb' => $region->getThumbnail(),
'data' => $arr
];
}
}
$form = $this->createSubscribeForm();
$now = new \DateTime();
$form->handleRequest($request);
if ($form->isSubmitted() && $form->isValid()) {
// data is an array with "name", "email", and "message" keys
$data = $form->getData();
$mailing_lists = new MailingList();
$mailing_lists->setRegion($data->getRegion());
$mailing_lists->setCompanyName($data->getCompanyName());
$mailing_lists->setFullName($data->getFullName());
$mailing_lists->setEmail($data->getEmail());
$mailing_lists->setMobile($data->getMobile());
$mailing_lists->setDesignation($data->getDesignation());
$mailing_lists->setIsSubscribed(1);
$mailing_lists->setModified($now->format('Y-m-d H:i:s'));
$mailing_lists->setCreated($now->format('Y-m-d'));
$em = $this->getDoctrine()->getManager();
$em->persist($mailing_lists);
$em->flush();
// Send Email
$body = '<table style="padding: 8px; border-collapse: collapse; border: none; font-family: arial">';
$body .= '<tr><td colspan="2"><img src="https://huguenottunnel.nerdw.com/images/sanral-preferred-logo_cmyk.png"></td></tr>';
$body .= '<tr><td colspan="2"> </td></tr>';
$body .= '<tr><td colspan="2">Thank you for submitting your details.</td></tr>';
$body .= '<tr><td colspan="2"> </td></tr>';
$body .= ' <td>Contact Name</td>';
$body .= ' <td>'. $data->getFullName() .'</td>';
$body .= '</tr>';
$body .= '<tr>';
$body .= ' <td>Email</td>';
$body .= ' <td>'. $data->getEmail() .'</td>';
$body .= '</tr>';
if(!empty($data->getMobile())) {
$body .= '<tr>';
$body .= ' <td>Telephone</td>';
$body .= ' <td>' . $data->getMobile() . '</td>';
$body .= '</tr>';
}
$body .= '<tr>';
$body .= ' <td>Company Name</td>';
$body .= ' <td>'. $data->getCompanyName() .'</td>';
$body .= '</tr>';
$body .= '<tr>';
$body .= '<tr>';
$body .= ' <td>Designation</td>';
$body .= ' <td>'. $data->getDesignation() .'</td>';
$body .= '</tr>';
$body .= '<tr>';
if(!empty($data->getRegion())) {
$body .= '<tr>';
$body .= ' <td>Province</td>';
$body .= ' <td>' . $data->getRegion() . '</td>';
$body .= '</tr>';
}
$body .= '</table>';
$email = (new Email())
->from($data->getEmail())
->addTo('SANRAL <karsten@nerdw.com>')
->subject('New Subscription')
->html($body);
$mailer->send($email);
return $this->render('frontend/index.html.twig',
[
'copy' => $repo_content->getCopy(),
'form' => $form->createView(),
'regions' => $tenders,
'page' => 'home',
'closing_soon' => $closing_soon,
'entrants' => $repo_entrants,
'subscribed' => 1
]);
}
return $this->render('frontend/mailing_list_form.html.twig',
[
'copy' => $repo_content->getCopy(),
'form' => $form->createView(),
'modified' => $now->format('Y-m-d')
]
);
}
protected function createSubscribeForm()
{
$mailing_list = new MailingList();
return $this->createForm(MailListFormType::class,
$mailing_list,
[
'method' => 'POST',
'action' => $this->generateUrl('subscribe_page')
]
);
}
}

src/Controller/HomeController.php line 123