src/Controller/CarSaleController.php line 213

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\CarSale;
  6. use App\Entity\CarSaleBankCheck;
  7. use App\Entity\CarBuy;
  8. use App\Form\CarSaleType;
  9. use App\Repository\CarSaleRepository;
  10. use App\Repository\UserRepository;
  11. use Doctrine\Persistence\ManagerRegistry;
  12. use Dompdf\Dompdf;
  13. use Dompdf\Options;
  14. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  15. use Symfony\Component\HttpFoundation\Request;
  16. use Symfony\Component\HttpFoundation\Response;
  17. use Symfony\Component\HttpFoundation\JsonResponse;
  18. use Symfony\Component\Routing\Annotation\Route;
  20. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  21. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  22. use Symfony\Component\HttpFoundation\ResponseHeaderBag;
  24. //use Knp\Bundle\SnappyBundle\Snappy\Response\PdfResponse;
  26. use Doctrine\Common\Collections\ArrayCollection;
  28. use Knp\Bundle\SnappyBundle\Snappy\Response\PdfResponse;
  29. use Knp\Snappy\Pdf;
  31. use App\Service\WhatsAppService;
  34. /**
  35.  * @Route("/car/sale")
  36.  */
  37. class CarSaleController extends AbstractController
  38. {
  39.     /**
  40.      * @Route("/indexJson", name="car_sale_index_json", methods={"GET", "POST"})
  41.      */
  42.     public function indexJson(Request $request, CarSaleRepository $entityRepository): Response
  43.     {
  44.         /*---- Filters [START] ----*/
  45.         $search   = $request->get('searchPhrase');
  46.         $isDone   = $request->get('isDone');
  47.         $curMonth = $request->get('curMonth');
  48.         $dateFromRaw    = $request->get('dateFrom');
  49.         $dateToRaw      = $request->get('dateTo');
  50.         $dateFilter     = filter_var($request->get('dateFilter'), FILTER_VALIDATE_BOOLEAN);
  51.         $priceFrom      = $request->get('priceFrom');
  52.         $priceTo        = $request->get('priceTo');
  53.         $priceFilter    = filter_var($request->get('priceFilter'), FILTER_VALIDATE_BOOLEAN);
  54.         $agency      = $request->get('agency');
  55.         $seller      = $request->get('seller');
  57.         $dateFrom    = $dateFromRaw ? $dateFromRaw . ' 00:00:00' : null;
  58.         $dateTo      = $dateToRaw ? $dateToRaw . ' 23:59:59' : null;
  60.         /*---- Filters [END] ----*/
  62.         $totalR = 0;
  63.         $curPage   = $request->get('current');
  64.         $sizePage  = $request->get('rowCount');
  65.         $startPage = $curPage == 1 ? 0 : (($curPage - 1) * $sizePage);
  67.         $data = $entityRepository->createQueryBuilder('cs')
  68.             ->leftJoin('cs.carSale', 'c')
  69.             //->leftJoin('cs.carSalePayment', 'cp')
  70.             ->leftJoin('cs.carPayment', 'cscp')
  71.             ->leftJoin('cs.bankCheckId', 'csb')
  72.             ->leftJoin('cscp.car', 'cp')
  73.             ->leftJoin('cs.user', 'u')
  74.             ->leftJoin('cs.client', 'cl')
  75.             ->addSelect('c')
  76.             ->addSelect('cscp')
  77.             ->addSelect('csb')
  78.             ->addSelect('cp')
  79.             ->addSelect('u')
  80.             ->addSelect('cl')
  81.             ->where('cs.id > :id')
  82.             ->setParameter('id', '0');
  84.         if ($search !== null && $search !== '') {
  85.             $data->andWhere(
  86.                 $data->expr()->orX(
  87.                     'c.name LIKE :search',
  88.                     'c.patent LIKE :search',
  89.                     'u.firstName LIKE :search',
  90.                     'u.lastName LIKE :search',
  91.                     'cs.price LIKE :search',
  92.                     'cs.origin LIKE :search'
  93.                 )
  94.             )->setParameter(':search', "%$search%");
  95.         }
  97.         $data = $data->leftJoin(\App\Entity\Agency::class, 'ag', 'WITH', 'cs.id = ag.saleId')
  98.             ->addSelect('ag.enabledNotification, ag.status');
  100.         if ($isDone !== '' && $isDone !== null) {
  101.             $data = $data->andWhere('cs.isDone = :isDone')
  102.                 ->setParameter(':isDone', $isDone);
  103.         }
  105.         if ($dateFilter && $dateFrom && $dateTo) {
  106.             $data->andWhere('cs.isDoneDate BETWEEN :dateFrom AND :dateTo')
  107.                 ->setParameter(':dateFrom', $dateFrom)
  108.                 ->setParameter(':dateTo', $dateTo);
  109.         }
  111.         if ($priceFilter && $priceFrom !== null && $priceTo !== null && $priceFrom !== '' && $priceTo !== '') {
  112.             $data->andWhere('cs.price BETWEEN :priceFrom AND :priceTo')
  113.                 ->setParameter(':priceFrom', $priceFrom)
  114.                 ->setParameter(':priceTo', $priceTo);
  115.         }
  117.         if (!empty($seller)) {
  118.             $data->andWhere('u.id = :userId')
  119.                 ->setParameter(':userId', $seller);
  120.         }
  122.         if ($curMonth === '1') {
  123.             $data->andWhere(
  124.                 $data->expr()->orX(
  125.                     $data->expr()->andX(
  126.                         'cs.isDone = 1',
  127.                         'MONTH(cs.isDoneDate) = MONTH(CURRENT_DATE())',
  128.                         'YEAR(cs.isDoneDate) = YEAR(CURRENT_DATE())'
  129.                     ),
  130.                     'cs.isDone = 0'
  131.                 )
  132.             );
  133.         }
  135.         $total = $data->getQuery()
  136.             ->getArrayResult();
  138.         $data = $data->orderBy('cs.isDone', 'DESC')
  139.             ->addOrderBy('cs.isDoneDate', 'ASC')
  140.             ->setFirstResult($startPage)
  141.             ->setMaxResults($sizePage)
  142.             ->getQuery()
  143.             ->setHint(\Doctrine\ORM\Query::HINT_INCLUDE_META_COLUMNS, true)
  144.             ->getArrayResult();
  145.             //->getScalarResult();
  147.         $nDelivered = 0;
  148.         $nSignaled  = 0;
  149.         $nDeliveredPrice = 0;
  150.         $nSignaledPrice  = 0;
  152.         /*---- Fix data for twig template [BEGIN] ----*/
  153.         foreach ($data as $key => $item) {
  154.             $aTmp = $item[0];
  155.             $aTmp['enabledNotification'] = $item['enabledNotification'];
  156.             $aTmp['status'] = $item['status'];
  158.             if (!empty($aTmp['fechaFacturacion']) && $aTmp['fechaFacturacion'] instanceof \DateTimeInterface) {
  159.                 $aTmp['fechaFacturacion'] = $aTmp['fechaFacturacion']->format('Y-m-d');
  160.             }
  162.             $data[$key] = $aTmp;
  163.         }
  164.         /*---- Fix data for twig template [END] ----*/
  165.         //dump($data); exit();
  167.         foreach ($total as $item) {
  168.             /*if ($agency) {
  169.                 $isDone = $item[0]['isDone'];
  170.                 $price = $item[0]['price'];
  171.                 $signaledDate = $item[0]['signaledDate'];
  172.             } else {
  173.                 $isDone = $item['isDone'];
  174.                 $price = $item['price'];
  175.                 $signaledDate = $item['signaledDate'];
  176.             }*/
  178.             $isDone = $item[0]['isDone'];
  179.             $price  = $item[0]['price'];
  180.             $signaledDate = $item[0]['signaledDate'];
  182.             if ($isDone) {
  183.                 $nDelivered ++;
  184.                 $nDeliveredPrice = $nDeliveredPrice + $price;
  185.             }
  187.             if (!$isDone && $signaledDate != null) {
  188.                 $nSignaled ++;
  189.                 $nSignaledPrice = $nSignaledPrice + $price;
  190.             }
  191.         }
  193.         $json_data = array(
  194.             'current' => intval($curPage),
  195.             'rowCount' => $sizePage,
  196.             'total' => count($total),
  197.             'rows' => $data,
  198.             'delivered' => $nDelivered,
  199.             'signaled' => $nSignaled,
  200.             'deliveredPrice' => $nDeliveredPrice,
  201.             'signaledPrice' => $nSignaledPrice,
  202.             'totalPrice' => $nDeliveredPrice + $nSignaledPrice,
  203.         );
  205.         //dump($data); exit();
  207.         return $this->json($json_data);
  208.     }
  210.     /**
  211.      * @Route("/{id}/print", name="car_sale_print", methods={"GET"})
  212.      */
  213.     public function print(CarSale $carSale, Pdf $pdf): Response
  214.     {
  215.         /* Load the snappy pdf service * /
  216.         //$snappy = $this->get('knp_snappy.pdf');
  217.         $snappy = new Pdf();
  219.         $snappy->setOption('no-outline', true);
  220.         $snappy->setOption('page-size','LETTER');
  221.         $snappy->setOption('encoding', 'UTF-8');
  223.         /* Set title for pdf * /
  224.         $title = 'Detalle';
  226.         /* Render view, you can pass variables here to template view * /
  227.         $html = $this->renderView('car_sale/print.html.twig', [
  228.             'car_sale' => $carSale,
  229.         ]);
  231.         /* Set output file name and force pdf download in browser with PDFResponse * /
  232.         $filename = 'Detalle-ventas.pdf';
  234.         //exit($html);
  235.         return new PdfResponse(
  236.             $snappy->getOutputFromHtml($html),
  237.             $filename
  238.         ); //*/
  240.         /*return new Response(
  241.             $this->get('knp_snappy.pdf')->getOutputFromHtml($html),
  242.             200,
  243.             array(
  244.                 'Content-Type'          => 'application/pdf',
  245.                 'Content-Disposition'   => 'attachment; filename="tmp/file.pdf"'
  246.             )
  247.         );*/
  249.         /*---- [BEGIN] ----*/
  250.         $moneyAdvanceMultiple = $carSale->getMoneyAdvanceMultiple();
  251.         $aTmp = explode('|*|', $moneyAdvanceMultiple);
  252.         $moneyAdvanceMultiple = "";
  254.         foreach ($aTmp as $item) {
  255.             $aTmp2 = explode('|', $item);
  257.             if (count($aTmp2) > 1) {
  258.                 $amount = (float) str_replace(',', '.', str_replace('.', '', $aTmp2[3]));
  259.                 $moneyAdvanceMultiple .= $aTmp2[2] . number_format($amount, 0, ',', '.') . ', ';
  260.             }
  261.         }
  263.         $moneyAdvanceMultiple = rtrim($moneyAdvanceMultiple, ', ');
  264.         /*---- [END] ----*/
  266.         /*---- [BEGIN] ----*/
  267.         $cashMultiple = $carSale->getCashMultiple();
  268.         $aTmp = explode('|*|', $cashMultiple);
  269.         $cashMultiple = "";
  271.         foreach ($aTmp as $item) {
  272.             $aTmp2 = explode('|', $item);
  274.             if (count($aTmp2) > 1) {
  275.                 $amount = (float) str_replace(',', '.', str_replace('.', '', $aTmp2[3]));
  276.                 $cashMultiple .= $aTmp2[2] . number_format($amount, 0, ',', '.') . ', ';
  277.             }
  278.         }
  280.         $cashMultiple = rtrim($cashMultiple, ', ');
  281.         /*---- [END] ----*/
  283.         // Configure Dompdf according to your needs
  284.         $pdfOptions = new Options();
  285.         //$pdfOptions->set('defaultFont', 'Arial');
  287.         $pdfOptions->setIsHtml5ParserEnabled(true);
  288.         $pdfOptions->setIsRemoteEnabled(true);
  290.         // Instantiate Dompdf with our options
  291.         $dompdf = new Dompdf($pdfOptions);
  293.         //exit( $this->getParameter('kernel.project_dir') );
  295.         $dompdf->getOptions()->setChroot( $this->getParameter('kernel.project_dir').'\public' );
  297.         //$html = $this->renderView('car_sale/print.html.twig', [
  298.         //$html = $this->renderView('pdf/car_sales_detail.html.twig', [
  299.         $html = $this->renderView('pdf/car_sales_form.html.twig', [
  300.             'car_sale' => $carSale,
  301.             'money_advance_multiple' => $moneyAdvanceMultiple,
  302.             'cash_multiple' => $cashMultiple,
  303.             'server_root' => $_SERVER["DOCUMENT_ROOT"],
  304.         ]);
  306.         //echo $html; exit();
  308.         // Load HTML to Dompdf
  309.         $dompdf->loadHtml($html);
  311.         // (Optional) Setup the paper size and orientation 'portrait' or 'portrait'
  312.         $dompdf->setPaper('A4', 'portrait');
  314.         // Render the HTML as PDF
  315.         $dompdf->render();
  317.         ob_get_clean();
  318.         // Output the generated PDF to Browser (inline view)
  319.         $dompdf->stream("/pdfDetalle-ventas.pdf", [
  320.             "Attachment" => false,
  321.         ]);
  323.         /*
  324.         $filename = 'Detalle-ventas.pdf';
  326.         return new PdfResponse(
  327.             $pdf->getOutputFromHtml($html),
  328.             $filename
  329.         );*/
  330.     }
  332.     /**
  333.      * @Route("/{id}/detail", name="car_sale_detail", methods={"GET"})
  334.      */
  335.     public function detail(Request $request, CarSale $carSale): Response
  336.     {
  337.         if ($carSale->getProcedureDays() != null) {
  338.             $procedureDays = $carSale->getProcedureDays();
  339.         }
  341.         //dump($carSale); exit();
  342.         //dump(json_decode($mandateSalePrice)); exit();
  344.         return $this->render('car_sale/detail.html.twig', [
  345.             'car_sale' => $carSale,
  346.             'currentMenu' => 'sales',
  347.         ]);
  348.     }
  350.     /**
  351.      * @Route("/{id}/receipt", name="car_sale_receipt", methods={"GET"})
  352.      */
  353.     public function carSaleReceipt(Request $request, CarSale $carSale, $id): Response
  354.     {
  355.         $procedureLocation = 'VILLA CARLOS PAZ';
  356.         $procedureDate = date('Y/m/d');
  357.         $procedureTime = date('H:i:s');
  358.         $procedureDays = '7';
  360.         if ($carSale->getProcedureLocation() != null) {
  361.             $procedureLocation = $carSale->getProcedureLocation();
  362.         }
  364.         if ($carSale->getProcedureDate() != null) {
  365.             $procedureDate = $carSale->getProcedureDate();
  366.         }
  368.         /*if ($carSale->getProcedureTime() != null) {
  369.             $procedureTime = $carSale->getProcedureTime()->format('H:i:s');
  370.         }*/
  372.         if ($carSale->getProcedureDays() != null) {
  373.             $procedureDays = $carSale->getProcedureDays();
  374.         }
  376.         /*---- [BEGIN] ----*/
  377.         $moneyAdvanceMultiple = $carSale->getMoneyAdvanceMultiple();
  378.         $aTmp = explode('|*|', $moneyAdvanceMultiple);
  379.         $moneyAdvanceMultiple = "";
  381.         foreach ($aTmp as $item) {
  382.             $aTmp2 = explode('|', $item);
  384.             if (count($aTmp2) > 1) {
  385.                 $amount = (float) str_replace(',', '.', str_replace('.', '', $aTmp2[3]));
  386.                 $moneyAdvanceMultiple .= $aTmp2[2] . number_format($amount, 0, ',', '.') . ', ';
  387.             }
  388.         }
  389.         /*---- [END] ----*/
  391.         return $this->render('car_sale/receipt.html.twig', [
  392.             'car_sale' => $carSale,
  393.             'money_advance_multiple' => $moneyAdvanceMultiple,
  394.             'procedure_location' => $procedureLocation,
  395.             'procedure_date' => $procedureDate,
  396.             'procedure_time' => $procedureTime,
  397.             'procedure_days' => $procedureDays,
  398.             'isCreated' => $carSale->getReceiptGenerated(),
  399.             'form_number' => $carSale->getId(),
  400.             'currentMenu' => 'sales',
  401.         ]);
  402.     }
  404.     /**
  405.      * @Route("/excel", name="car_sale_excel", methods={"GET", "POST"})
  406.      */
  407.     public function excel(Request $request, CarSaleRepository $entityRepository): Response
  408.     {
  409.         /*---- Filters [START] ----*/
  410.         $search = $request->get('searchPhrase');
  411.         $isDone = $request->get('isDone');
  412.         $curMonth = $request->get('curMonth');
  413.         $dateFromRaw = $request->get('dateFrom');
  414.         $dateToRaw   = $request->get('dateTo');
  415.         $dateFilter  = filter_var($request->get('dateFilter'), FILTER_VALIDATE_BOOLEAN);
  416.         $priceFrom   = $request->get('priceFrom');
  417.         $priceTo     = $request->get('priceTo');
  418.         $priceFilter = filter_var($request->get('priceFilter'), FILTER_VALIDATE_BOOLEAN);
  419.         $seller = $request->get('seller');
  421.         /*---- Filters [END] ----*/
  423.         $totalR = 0;
  424.         $curPage = $request->get('current');
  425.         $sizePage = $request->get('rowCount');
  427.         $data = $entityRepository->createQueryBuilder('cs')
  428.             ->leftJoin('cs.carSale', 'c')
  429.             ->leftJoin('cs.carSalePayment', 'cp')
  430.             ->leftJoin('cs.user', 'u')
  431.             ->leftJoin('cs.client', 'cl')
  432.             ->addSelect('c')
  433.             ->addSelect('cp')
  434.             ->addSelect('u')
  435.             ->addSelect('cl')
  436.             ->where('cs.id > :id')
  437.             ->setParameter('id', '0');
  439.         if ($search !== null && $search !== '') {
  440.             $data->andWhere(
  441.                 $data->expr()->orX(
  442.                     'c.name LIKE :search',
  443.                     'c.patent LIKE :search',
  444.                     'u.firstName LIKE :search',
  445.                     'u.lastName LIKE :search',
  446.                     'cs.price LIKE :search',
  447.                     'cs.origin LIKE :search'
  448.                 )
  449.             )->setParameter(':search', "%$search%");
  450.         }
  452.         $dateFrom = $dateFromRaw ? $dateFromRaw . ' 00:00:00' : null;
  453.         $dateTo   = $dateToRaw ? $dateToRaw . ' 23:59:59' : null;
  455.         if ($isDone !== '' && $isDone !== null) {
  456.             $data->andWhere('cs.isDone = :isDone')
  457.                 ->setParameter(':isDone', $isDone);
  458.         }
  460.         if ($dateFilter && $dateFrom && $dateTo) {
  461.             $data->andWhere('cs.isDoneDate BETWEEN :dateFrom AND :dateTo')
  462.                 ->setParameter(':dateFrom', $dateFrom)
  463.                 ->setParameter(':dateTo', $dateTo);
  464.         }
  466.         if ($priceFilter && $priceFrom !== null && $priceTo !== null && $priceFrom !== '' && $priceTo !== '') {
  467.             $data->andWhere('cs.price BETWEEN :priceFrom AND :priceTo')
  468.                 ->setParameter(':priceFrom', $priceFrom)
  469.                 ->setParameter(':priceTo', $priceTo);
  470.         }
  472.         if (!empty($seller)) {
  473.             $data->andWhere('u.id = :userId')
  474.                 ->setParameter(':userId', $seller);
  475.         }
  477.         if ($curMonth === '1') {
  478.             $data->andWhere(
  479.                 $data->expr()->orX(
  480.                     $data->expr()->andX(
  481.                         'cs.isDone = 1',
  482.                         'MONTH(cs.isDoneDate) = MONTH(CURRENT_DATE())',
  483.                         'YEAR(cs.isDoneDate) = YEAR(CURRENT_DATE())'
  484.                     ),
  485.                     'cs.isDone = 0'
  486.                 )
  487.             );
  488.         }
  490.         $data = $data->getQuery()
  491.             ->setHint(\Doctrine\ORM\Query::HINT_INCLUDE_META_COLUMNS, true)
  492.             ->getArrayResult();
  494.         $spreadsheet = new Spreadsheet();
  496.         $sheet = $spreadsheet->getActiveSheet();
  498.         $sheet->setTitle('Listado');
  500.         $sheet->getCell('A1')->setValue(strtoupper('Vendedor'));
  501.         $sheet->getCell('B1')->setValue(strtoupper('Vehículo Vendido'));
  502.         $sheet->getCell('C1')->setValue(strtoupper('Año'));
  503.         $sheet->getCell('D1')->setValue(strtoupper('Patente'));
  504.         $sheet->getCell('E1')->setValue(strtoupper('Vehículos Recibido'));
  505.         $sheet->getCell('F1')->setValue(strtoupper('Año'));
  506.         $sheet->getCell('G1')->setValue(strtoupper('Patente'));
  507.         $sheet->getCell('H1')->setValue(strtoupper('Precio Compra'));
  508.         $sheet->getCell('I1')->setValue(strtoupper('Adelanto'));
  509.         $sheet->getCell('J1')->setValue(strtoupper('Finalizada'));
  510.         $sheet->getCell('K1')->setValue(strtoupper('Creado'));
  511.         $sheet->getCell('L1')->setValue(strtoupper('Modificado'));
  513.         foreach(range('A','H') as $columnID) {
  514.             $sheet->getColumnDimension($columnID)->setAutoSize(true);
  515.         }
  517.         $sheet->getStyle('A1:L1')
  518.             ->getFill()
  519.             ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
  520.             ->getStartColor()->setRGB('dedede');
  523.         setlocale(LC_MONETARY, 'it_IT');
  525.         $counter = 2;
  526.         foreach ($data as $item) {
  527.             $carSalePayment = $item['carSalePayment'] ?? null;
  528.             $carSalePaymentText = '';
  529.             $carSalePaymentYear = '';
  530.             $carSalePaymentPatent = '';
  532.             if ($carSalePayment) {
  533.                 $carSalePaymentText   = strtoupper($carSalePayment['name'].' ('.$carSalePayment['patent'].')');
  534.                 $carSalePaymentYear   = strtoupper($carSalePayment['year']);
  535.                 $carSalePaymentPatent = strtoupper($carSalePayment['patent']);
  536.             }
  538.             $sheet->getCell('A'.$counter)->setValue(strtoupper($item['user']['firstName'].' '.$item['user']['lastName']));
  539.             $sheet->getCell('B'.$counter)->setValue(strtoupper($item['carSale']['name'].' ('.$item['carSale']['patent'].')'));
  540.             $sheet->getCell('C'.$counter)->setValue(strtoupper($item['carSale']['year']));
  541.             $sheet->getCell('D'.$counter)->setValue(strtoupper($item['carSale']['patent']));
  542.             $sheet->getCell('E'.$counter)->setValue($carSalePaymentText);
  543.             $sheet->getCell('F'.$counter)->setValue($carSalePaymentYear);
  544.             $sheet->getCell('G'.$counter)->setValue($carSalePaymentPatent);
  545.             //$sheet->getCell('H'.$counter)->setValue(strtoupper($item['price']));
  546.             $sheet->getCell('H'.$counter)->setValue( $item['currency'].number_format($item['price'], 0, ',', '.') );
  547.             $sheet->getCell('I'.$counter)->setValue( $item['moneyAdvanceCurrency'].number_format($item['moneyAdvance'], 0, ',', '.') );
  548.             $sheet->getCell('J'.$counter)->setValue(strtoupper($item['isDone'] == 0 ? 'No' : 'Sí'));
  550.             if ($item['createdAt'] != null) {
  551.                 $sheet->getCell('K' . $counter)->setValue($item['createdAt']->format('d-m-Y H:i:s'));
  552.             }
  553.             if ($item['updatedAt'] != null) {
  554.                 $sheet->getCell('L'.$counter)->setValue($item['updatedAt']->format('d-m-Y H:i:s'));
  555.             }
  557.             $counter ++;
  558.         }
  560.         // Increase row cursor after header write
  561.         //$sheet->fromArray($data,null, 'A2', true);
  563.         $writer = new Xlsx($spreadsheet);
  565.         // Create a Temporary file in the system
  566.         $fileName = 'Ventas_'.date('d-m-Y').'.xlsx';
  567.         $temp_file = tempnam(sys_get_temp_dir(), $fileName);
  569.         // Create the excel file in the tmp directory of the system
  570.         $writer->save($temp_file);
  572.         // Return the excel file as an attachment
  573.         return $this->file($temp_file, $fileName, ResponseHeaderBag::DISPOSITION_INLINE);
  574.     }
  576.     /**
  577.      * @Route("/sale/{id}/receiptsave/", name="car_sale_receipt_save", methods="POST")
  578.      */
  579.     public function receiptSave(Request $request, $id)
  580.     {
  581.         $data = json_decode($request->getContent(), true);
  583.         $aProcedure['location'] = $data['procedure-location'];
  584.         $aProcedure['date']     = new \DateTime($data['procedure-date'].'00:00:01');
  585.         $aProcedure['time']     = new \DateTime($data['procedure-date']. $data['procedure-time']);
  586.         $aProcedure['days'] = $data['procedure-days'];
  588.         /*---- [BEGIN] ----*/
  589.         $carsale = $this->getDoctrine()->getRepository('App\Entity\CarSale')->findOneBy([ 'id' => $id ]);
  591.         $carsale->setProcedureLocation($aProcedure['location']);
  592.         $carsale->setProcedureDate($aProcedure['date']);
  593.         $carsale->setProcedureTime($aProcedure['time']);
  594.         $carsale->setProcedureDays($aProcedure['days']);
  596.         $carsale->setReceiptGenerated(1);
  598.         $this->getDoctrine()->getManager()->persist($carsale);
  599.         $this->getDoctrine()->getManager()->flush();
  600.         /*---- [END] ----*/
  602.         return $this->json('ok');
  603.     }
  605.     /**
  606.      * @Route("/sale/{id}/detailsave/", name="car_sale_detail_save", methods="POST")
  607.      */
  608.     public function detailSave(Request $request, $id)
  609.     {
  610.         $data = json_decode($request->getContent(), true);
  612.         $aProcedure['balance'] = $data['balance'];
  614.         /*---- [BEGIN] ----*/
  615.         $carsale = $this->getDoctrine()->getRepository('App\Entity\CarSale')->findOneBy([ 'id' => $id ]);
  617.         $carsale->setBalance($aProcedure['balance']);
  619.         $this->getDoctrine()->getManager()->persist($carsale);
  620.         $this->getDoctrine()->getManager()->flush();
  621.         /*---- [END] ----*/
  623.         return $this->json('ok');
  624.     }
  626.     /**
  627.      * @Route("/sale/{id}/pdf/receipt", name="car_sale_receipt_pdf", methods="GET")
  628.      */
  629.     public function receiptPdf(Request $request, CarSale $carSale, $id)
  630.     {
  631.         $procedureLocation = $carSale->getProcedureLocation();
  632.         $procedureDate = $carSale->getProcedureDate();
  633.         $procedureTime = $carSale->getProcedureTime();;
  634.         $procedureDays = $carSale->getProcedureDays();;
  635.         //$procedureTime = date('H:i:s');
  637.         $moneyAdvance = '';
  639.         /*---- [BEGIN] ----*/
  640.         $moneyAdvanceMultiple = $carSale->getMoneyAdvanceMultiple();
  641.         $aTmp = explode('|*|', $moneyAdvanceMultiple);
  642.         $moneyAdvanceMultiple = "";
  644.         foreach ($aTmp as $item) {
  645.             $aTmp2 = explode('|', $item);
  646.             if (count($aTmp2) > 1) {
  647.                 $amount = (float) str_replace(',', '.', str_replace('.', '', $aTmp2[3]));
  648.                 $moneyAdvanceMultiple .= $aTmp2[2] . number_format($amount, 0, ',', '.') . ', ';
  649.             }
  650.         }
  651.         /*---- [END] ----*/
  653.         // Configure Dompdf according to your needs
  654.         $pdfOptions = new Options();
  655.         //$pdfOptions->set('defaultFont', 'Arial');
  657.         $pdfOptions->setIsHtml5ParserEnabled(true);
  658.         $pdfOptions->setIsRemoteEnabled(true);
  660.         // Instantiate Dompdf with our options
  661.         $dompdf = new Dompdf($pdfOptions);
  663.         //exit( $this->getParameter('kernel.project_dir') );
  665.         $dompdf->getOptions()->setChroot( $this->getParameter('kernel.project_dir').'\public' );
  667.         // Retrieve the HTML generated in our twig file
  668.         $html = $this->renderView('pdf/car_sale_receipt.html.twig', [
  669.             'car_sale' => $carSale,
  670.             'money_advance_multiple' => $moneyAdvanceMultiple,
  671.             'procedure_location' => $procedureLocation,
  672.             'procedure_date' => $procedureDate,
  673.             'procedure_days' => $procedureDays,
  674.             'money_advance' => $moneyAdvance,
  675.             'form_number' => $carSale->getId(),
  676.             'server_root' => $_SERVER["DOCUMENT_ROOT"],
  677.         ]);
  679.         //dump($html); exit();
  681.         // Load HTML to Dompdf
  682.         $dompdf->loadHtml($html);
  684.         // (Optional) Setup the paper size and orientation 'portrait' or 'portrait'
  685.         $dompdf->setPaper('A4', 'portrait');
  687.         // Render the HTML as PDF
  688.         $dompdf->render();
  690.         ob_get_clean();
  691.         // Output the generated PDF to Browser (inline view)
  692.         $dompdf->stream("/Recibo-seña.pdf", [
  693.             "Attachment" => false,
  694.         ]);
  695.         //exit(0);
  696.     }
  698.     /**
  699.      * @Route("/index", name="car_sale_index", methods={"GET"})
  700.      */
  701.     public function index(ManagerRegistry $doctrine, CarSaleRepository $carSaleRepository): Response
  702.     {
  703.         $sellers = $this->getDoctrine()->getManager()->getRepository(\App\Entity\User::class)->createQueryBuilder('u')
  704.             ->indexBy('u', 'u.id')
  705.             ->orderBy('u.firstName', 'ASC')
  706.             ->getQuery()
  707.             ->getArrayResult();
  709.         $query = "
  710.             SELECT id, name
  711.             FROM branches
  712.             ORDER BY name ASC
  713.         ";
  714.         $conn = $doctrine->getConnection();
  715.         $result = $conn->executeQuery($query);
  716.         $branches  = $result->fetchAllKeyValue();
  720.         return $this->render('car_sale/index.html.twig', [
  721.             'car_sales' => $carSaleRepository->findAll(),
  722.             'branches' => $branches,
  723.             'currentMenu' => 'car_sale',
  724.             'sellers' => $sellers,
  725.         ]);
  726.     }
  728.     /**
  729.      * @Route("/addSeller", name="car_sale_add_seller", methods={"GET"})
  730.      */
  731.     public function addSeller(UserRepository $userRepository): Response
  732.     {
  733.         //$sellers = $userRepository->findBy(['roles' => 'ROLE_SALE']);
  735.         //dump($sellers); exit();
  737.         return $this->render('car_sale/add_seller.html.twig', [
  738.             'sellers' => $userRepository->findAll(),
  739.         ]);
  740.     }
  742.     /**
  743.      * @Route("/new", name="car_sale_new", methods={"GET","POST"})
  744.      */
  745.     public function new(Request $request): Response
  746.     {
  747.         $carSale = new CarSale();
  748.         $form = $this->createForm(CarSaleType::class, $carSale);
  749.         $form->handleRequest($request);
  751.         if ($form->isSubmitted() && $form->isValid()) {
  752.             if ($this->getUser()->getRoles()[0] != 'ROLE_ADMIN') {
  753.                 $carSale->SetUser($this->getUser());
  754.             }
  756.             $carSale->SetProcedureDays(7);
  758.             $entityManager = $this->getDoctrine()->getManager();
  759.             $entityManager->persist($carSale);
  760.             $entityManager->flush();
  762.             if ($carSale->getIsDone()) {
  763.                 /*---- Updated vehicle to sale [BEGIN] ----*/
  764.                 $car = $this->getDoctrine()->getManager()->getReference(\App\Entity\Car::class, $carSale->getCarSale()->getId());
  765.                 $car->setStatus('sold');
  766.                 $this->getDoctrine()->getManager()->persist($car);
  767.                 $this->getDoctrine()->getManager()->flush();
  768.                 /*---- Updated vehicle to sale [END] ----*/
  770.                 /*---- Updated vehicle_payment [BEGIN] ----*/
  771.                 if ($carSale->getCarSalePayment()) {
  772.                     $car = $this->getDoctrine()->getManager()->getReference(\App\Entity\Car::class, $carSale->getCarSalePayment()->getId());
  773.                     $car->setStatus('entered');
  774.                     $this->getDoctrine()->getManager()->persist($car);
  775.                     $this->getDoctrine()->getManager()->flush();
  776.                 }
  777.                 /*---- Updated vehicle_payment [END] ----*/
  778.             } else {
  779.                 /*---- Updated vehicle to sale [BEGIN] ----*/
  780.                 $car = $this->getDoctrine()->getManager()->getReference(\App\Entity\Car::class, $carSale->getCarSale()->getId());
  781.                 $car->setStatus('signaled');
  782.                 $this->getDoctrine()->getManager()->persist($car);
  783.                 $this->getDoctrine()->getManager()->flush();
  784.                 /*---- Updated vehicle to sale [END] ----*/
  786.                 /*---- Updated vehicle_payment [BEGIN] ----*/
  787.                 if ($carSale->getCarSalePayment()) {
  788.                     $car = $this->getDoctrine()->getManager()->getReference(\App\Entity\Car::class, $carSale->getCarSalePayment()->getId());
  789.                     $car->setStatus('to enter');
  790.                     $this->getDoctrine()->getManager()->persist($car);
  791.                     $this->getDoctrine()->getManager()->flush();
  792.                 }
  793.                 /*---- Updated vehicle_payment [END] ----*/
  794.             }
  796.             $this->syncCarPaymentPurchases($carSale);
  798.             return $this->redirectToRoute('car_sale_index', [], Response::HTTP_SEE_OTHER);
  799.         }
  801.         return $this->render('car_sale/new.html.twig', [
  802.             'car_sale' => $carSale,
  803.             'form' => $form->createView(),
  804.             'currentMenu' => 'car_sale',
  805.         ]);
  806.     }
  808.     /**
  809.      * @Route("/{id}", name="car_sale_show", methods={"GET"})
  810.      */
  811.     public function show(CarSale $carSale): Response
  812.     {
  813.         return $this->render('car_sale/show.html.twig', [
  814.             'car_sale' => $carSale,
  815.             'currentMenu' => 'car_sale',
  816.         ]);
  817.     }
  819.     /**
  820.      * @Route("/{id}/modal", name="car_sale_show_modal", methods={"GET"})
  821.      */
  822.     public function showModal(CarSale $carSale): Response
  823.     {
  824.         $sellers = $this->getDoctrine()->getManager()->getRepository(\App\Entity\User::class)->createQueryBuilder('u')
  825.             ->indexBy('u', 'u.id')
  826.             ->orderBy('u.firstName', 'ASC')
  827.             ->getQuery()
  828.             ->getArrayResult();
  830.         return $this->render('car_sale/show_modal.html.twig', [
  831.             'car_sale' => $carSale,
  832.             'sellers' => $sellers,
  833.             'currentMenu' => 'car_sale',
  834.         ]);
  835.     }
  837.     /**
  838.      * @Route("/{id}/edit", name="car_sale_edit", methods={"GET","POST"})
  839.      */
  840.     public function edit(Request $request, CarSale $carSale): Response
  841.     {
  842.         if ($carSale->getIsDone() && $this->getUser()->getRoles()[0] != 'ROLE_ADMIN') {
  843.             return $this->render('messages/no_edit_record.html.twig', [
  844.                 'currentMenu' => 'car_sale',
  845.             ]);
  846.         }
  848.         $options['edit'] = true;
  849.         $options['carSaleId']    = $carSale->getCarSale() != null ? $carSale->getCarSale()->getId() : 0;
  850.         $options['carPaymentId'] = $carSale->getCarSalePayment() != null ? $carSale->getCarSalePayment()->getId() : 0;
  852.         // save the records that are in the database first to compare them with the new one the user sent
  853.         // make sure this line comes before the $form->handleRequest();
  854.         $orignalBankCheck = new ArrayCollection();
  855.         foreach ($carSale->getBankCheckId() as $item) {
  856.             $orignalBankCheck->add($item);
  857.         }
  859.         $orignalCarPayment = new ArrayCollection();
  860.         foreach ($carSale->getCarPayment() as $item) {
  861.             $orignalCarPayment->add($item);
  862.         }
  864.         //dump($carSale->getCarPayment()); //exit();
  865.         //dump($request);
  867.         //dump($request->getMethod()); exit();
  869.         if ($request->getMethod() == 'POST') {
  870.             //exit('---- 1 ----');
  871.         }
  873.         $form = $this->createForm(CarSaleType::class, $carSale, $options);
  874.         $form->handleRequest($request);
  876.         if ($request->getMethod() == 'POST') {
  877.             //exit('---- 2 ----');
  878.         }
  880.         /*if ($form->isSubmitted()) {
  881.             dump($request);
  882.             exit($request->get('carSalePayment') . '-------');
  883.         } //*/
  885.         //exit($request->get('carSalePayment') . '-------here'. $form->isSubmitted());
  887.         if ($form->isSubmitted() && $form->isValid()) {
  889.             if ($this->getUser()->getRoles()[0] != 'ROLE_ADMIN') {
  890.                 $carSale->SetUser($this->getUser());
  891.             }
  893.             //dump($carSale->getBankCheckId()); exit();
  895.             //dump($request); dump($carSale->getBankCheck()); exit();
  897.             /*---- get rid of the ones that the user got rid of in the interface (DOM) [BEGIN] ----*/
  898.             foreach ($orignalBankCheck as $item) {
  899.                 // check if the exp is in the $user->getExp()
  900.                 // dump($user->getExp()->contains($exp));
  901.                 if ($carSale->getBankCheckId()->contains($item) === false) {
  902.                     $this->getDoctrine()->getManager()->remove($item);
  903.                 }
  904.             }
  906.             foreach ($orignalCarPayment as $item) {
  907.                 if ($carSale->getCarPayment()->contains($item) === false) {
  908.                     $this->getDoctrine()->getManager()->remove($item);
  909.                 }
  910.             }
  912.             //dump($carSale->getCarPayment()); exit();
  913.             /*---- get rid of the ones that the user got rid of in the interface (DOM) [END] ----*/
  915.             //dump($carSale); exit();
  916.             $this->getDoctrine()->getManager()->flush();
  917.             //exit('---- 3 ----');
  919.             /*---- Updated vehicle to sale [BEGIN] ----*/
  920.             $car = $this->getDoctrine()->getManager()->getReference(\App\Entity\Car::class, $carSale->getCarSale()->getId());
  922.             if ($carSale->getIsDone()) {
  923.                 $car->setStatus('sold');
  924.             } else {
  925.                 $car->setStatus('signaled');
  926.             }
  928.             $this->getDoctrine()->getManager()->persist($car);
  929.             $this->getDoctrine()->getManager()->flush();
  930.             /*---- Updated vehicle to sale [END] ----*/
  932.             /*---- Updated vehicle_payment [BEGIN] ----*/
  933.             if ($carSale->getCarSalePayment()) {
  934.                 $car = $this->getDoctrine()->getManager()->getReference(\App\Entity\Car::class, $carSale->getCarSalePayment()->getId());
  936.                 if ($carSale->getIsDone()) {
  937.                     $car->setStatus('entered');
  938.                 } else {
  939.                     $car->setStatus('to enter');
  940.                 }
  942.                 $this->getDoctrine()->getManager()->persist($car);
  943.                 $this->getDoctrine()->getManager()->flush();
  944.             } else if ($options['carPaymentId'] > 0) {
  945.                 $car = $this->getDoctrine()->getManager()->getReference(\App\Entity\Car::class, $options['carPaymentId']);
  946.                 $entityManager = $this->getDoctrine()->getManager();
  947.                 $entityManager->remove($car);
  948.                 $entityManager->flush();
  949.             }
  950.             /*---- Updated vehicle_payment [END] ----*/
  952.             /*
  953.             if ($carSale->getIsDone()) {
  954.                 /*---- Updated vehicle to sale [BEGIN] ----* /
  955.                 $car = $this->getDoctrine()->getManager()->getReference(\App\Entity\Car::class, $carSale->getCarSale()->getId());
  956.                 $car->setStatus('sold');
  957.                 $this->getDoctrine()->getManager()->persist($car);
  958.                 $this->getDoctrine()->getManager()->flush();
  959.                 /*---- Updated vehicle to sale [END] ----*/
  961.                 /*---- Updated vehicle_payment [BEGIN] ----* /
  962.                 if ($carSale->getCarSalePayment()) {
  963.                     $car = $this->getDoctrine()->getManager()->getReference(\App\Entity\Car::class, $carSale->getCarSalePayment()->getId());
  964.                     $car->setStatus('entered');
  965.                     $this->getDoctrine()->getManager()->persist($car);
  966.                     $this->getDoctrine()->getManager()->flush();
  967.                 } else if ($options['carPaymentId'] > 0) {
  968.                     $car = $this->getDoctrine()->getManager()->getReference(\App\Entity\Car::class, $options['carPaymentId']);
  969.                     $entityManager = $this->getDoctrine()->getManager();
  970.                     $entityManager->remove($car);
  971.                     $entityManager->flush();
  972.                 }
  973.                 /*---- Updated vehicle_payment [END] ----* /
  974.             } else {
  975.                 /*---- Updated vehicle to sale [BEGIN] ----* /
  976.                 $car = $this->getDoctrine()->getManager()->getReference(\App\Entity\Car::class, $carSale->getCarSale()->getId());
  977.                 $car->setStatus('signaled');
  978.                 $this->getDoctrine()->getManager()->persist($car);
  979.                 $this->getDoctrine()->getManager()->flush();
  980.                 /*---- Updated vehicle to sale [END] ----*/
  982.                 /*---- Updated vehicle_payment [BEGIN] ----* /
  983.                 if ($carSale->getCarSalePayment()) {
  984.                     $car = $this->getDoctrine()->getManager()->getReference(\App\Entity\Car::class, $carSale->getCarSalePayment()->getId());
  985.                     $car->setStatus('to enter');
  986.                     $this->getDoctrine()->getManager()->persist($car);
  987.                     $this->getDoctrine()->getManager()->flush();
  988.                 } else if ($options['carPaymentId'] > 0) {
  989.                     $car = $this->getDoctrine()->getManager()->getReference(\App\Entity\Car::class, $options['carPaymentId']);
  990.                     $entityManager = $this->getDoctrine()->getManager();
  991.                     $entityManager->remove($car);
  992.                     $entityManager->flush();
  993.                 }
  994.                 /*---- Updated vehicle_payment [END] ----* /
  995.             }*/
  997.             $this->syncCarPaymentPurchases($carSale, $orignalCarPayment);
  999.             return $this->redirectToRoute('car_sale_index', [], Response::HTTP_SEE_OTHER);
  1000.         }
  1002.         $sellers = $this->getDoctrine()->getManager()->getRepository(\App\Entity\User::class)->createQueryBuilder('u')
  1003.             ->indexBy('u', 'u.id')
  1004.             ->orderBy('u.firstName', 'ASC')
  1005.             ->getQuery()
  1006.             ->getArrayResult();
  1008.         return $this->render('car_sale/edit.html.twig', [
  1009.             'car_sale' => $carSale,
  1010.             'sellers' => $sellers,
  1011.             'form' => $form->createView(),
  1012.             //'form' => $form,
  1013.             'currentMenu' => 'car_sale',
  1014.         ]);
  1015.     }
  1017.     private function syncCarPaymentPurchases(CarSale $carSale, ?ArrayCollection $originalCarPayments = null): void
  1018.     {
  1019.         $entityManager   = $this->getDoctrine()->getManager();
  1020.         $carBuyRepo      = $entityManager->getRepository(CarBuy::class);
  1021.         $carSaleVehicle  = $carSale->getCarSale();
  1022.         $isDone          = $carSale->getIsDone();
  1023.         $defaultCurrency = $carSale->getCurrency() ?? '$';
  1024.         $defaultOrigin   = $carSale->getOrigin() ?? 'Sales Room';
  1026.         foreach ($carSale->getCarPayment() as $payment) {
  1027.             $paymentCar = $payment->getCar();
  1029.             if ($paymentCar === null) {
  1030.                 continue;
  1031.             }
  1033.             $carBuy = $carBuyRepo->findOneBy([
  1034.                 'car' => $paymentCar,
  1035.                 'carSwap' => $carSaleVehicle,
  1036.             ]);
  1038.             if ($carBuy === null) {
  1039.                 $carBuy = new CarBuy();
  1040.                 $carBuy->setCar($paymentCar);
  1041.                 $carBuy->setCarSwap($carSaleVehicle);
  1042.                 $entityManager->persist($carBuy);
  1043.             }
  1045.             $pricePurchase    = $paymentCar->getPricePurchase() ?? 0;
  1046.             $currencyPurchase = $paymentCar->getPriceCurrencyPurchase() ?? $defaultCurrency;
  1048.             $carBuy->setPrice($pricePurchase);
  1049.             $carBuy->setCurrency($currencyPurchase);
  1050.             $carBuy->setOrigin($defaultOrigin);
  1051.             $carBuy->setDescription(sprintf('Vehículo tomado en parte de pago de la venta #%d', $carSale->getId()));
  1052.             $carBuy->setUser($carSale->getUser());
  1053.             $carBuy->setClient($carSale->getClient());
  1054.             $carBuy->setIsDone($isDone);
  1055.             $carBuy->setIsDoneDate($isDone ? $carSale->getIsDoneDate() : null);
  1057.             $paymentCar->setPricePurchase($pricePurchase);
  1058.             $paymentCar->setPriceCurrencyPurchase($currencyPurchase);
  1059.             $paymentCar->setStatus($isDone ? 'entered' : 'to enter');
  1060.             $entityManager->persist($paymentCar);
  1061.         }
  1063.         if ($originalCarPayments !== null) {
  1064.             foreach ($originalCarPayments as $payment) {
  1065.                 if ($carSale->getCarPayment()->contains($payment)) {
  1066.                     continue;
  1067.                 }
  1069.                 $paymentCar = $payment->getCar();
  1070.                 if ($paymentCar === null) {
  1071.                     continue;
  1072.                 }
  1074.                 $carBuy = $carBuyRepo->findOneBy([
  1075.                     'car' => $paymentCar,
  1076.                     'carSwap' => $carSaleVehicle,
  1077.                 ]);
  1079.                 if ($carBuy !== null) {
  1080.                     $entityManager->remove($carBuy);
  1081.                 }
  1082.             }
  1083.         }
  1085.         $entityManager->flush();
  1086.     }
  1088.     /**
  1089.      * @Route("/{id}", name="car_sale_delete", methods={"POST"})
  1090.      */
  1091.     public function delete(Request $request, CarSale $carSale): Response
  1092.     {
  1093.         if ($this->isCsrfTokenValid('delete'.$carSale->getId(), $request->request->get('_token'))) {
  1094.             $entityManager = $this->getDoctrine()->getManager();
  1095.             $entityManager->remove($carSale);
  1096.             $entityManager->flush();
  1097.         }
  1099.         return $this->redirectToRoute('car_sale_index', [], Response::HTTP_SEE_OTHER);
  1100.     }
  1102.     /**
  1103.      * @Route("/{id}/delete", name="car_sale_delete_ra", methods={"GET"})
  1104.      */
  1105.     public function deleteRa(Request $request): Response
  1106.     {
  1107.         $entityManager = $this->getDoctrine()->getManager();
  1108.         $carSale = $entityManager->getReference(\App\Entity\CarSale::class, $request->get('id'));
  1109.         $entityManager->remove($carSale);
  1110.         $entityManager->flush();
  1112.         return $this->redirectToRoute('car_sale_index', [], Response::HTTP_SEE_OTHER);
  1113.     }
  1115.     #[Route('/ventas/{id}/send-thank-you', name: 'ventas_send_thank_you', methods: ['POST','GET'])]
  1116.     public function sendThankYou(CarSale $venta, WhatsAppService $whatsappService): JsonResponse
  1117.     {
  1118.         $cliente = $venta->getClient();
  1119.         $ok = $whatsappService->sendThankYouMessage($cliente);
  1121.         if ($ok) {
  1122.             return new JsonResponse([
  1123.                 'success' => true,
  1124.                 'message' => 'Mensaje enviado correctamente'
  1125.             ], 200);
  1126.         }
  1127.         else{
  1128.             return new JsonResponse([
  1129.                 'success' => false,
  1130.                 'message' => 'No se pudo enviar el mensaje'
  1131.             ], 500);
  1132.         }
  1133.        
  1134.     }  
  1135. }