custom/plugins/MojeBambinoExtensions/src/Controller/Storefront/AranzacjaPdfController.php line 76

Open in your IDE?
  1. <?php
  4. namespace MojeBambino\Extensions\Controller\Storefront;
  6. use Shopware\Core\Framework\Routing\Annotation\RouteScope;
  7. use Shopware\Core\System\SalesChannel\SalesChannelContext;
  8. use Shopware\Storefront\Controller\StorefrontController;
  9. use Symfony\Component\HttpFoundation\Response;
  10. use Symfony\Component\Routing\Annotation\Route;
  11. use Shopware\Core\Checkout\Cart\SalesChannel\CartService;
  12. use Shopware\Core\Content\Product\Cart\ProductLineItemFactory;
  13. use Doctrine\DBAL\Connection;
  14. use Crehler\Arrangements\Service\ArrangementService;
  15. use Shopware\Core\Framework\Context;
  16. use Symfony\Component\HttpFoundation\Request;
  17. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  18. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  19. use PhpOffice\PhpSpreadsheet\Style\Border;
  20. use PhpOffice\PhpSpreadsheet\Worksheet\Drawing;
  21. use PhpOffice\PhpSpreadsheet\Worksheet\MemoryDrawing;
  25. /**
  26.  * @RouteScope(scopes={"storefront"})
  27.  */
  28. class AranzacjaPdfController extends StorefrontController
  29. {
  30.     /**
  31.      * @var ArrangementService
  32.      */
  33.     private $arrangementService;
  34.     private Connection $connection;
  35.     
  36.     /**
  37.      * @var ProductLineItemFactory
  38.      */
  39.     private $productLineItemFactory;
  40.     
  41.     
  42.     public function __construct(ArrangementService $arrangementService, ProductLineItemFactory $productLineItemFactory, Connection $connection){
  43.         $this->arrangementService = $arrangementService;
  44.         $this->productLineItemFactory = $productLineItemFactory;
  45.         $this->connection = $connection;
  46.     }
  47.     
  48.     public function ciach($str,$ile) {
  49.         $str = strip_tags($str);
  50.         $body = explode(" ", $str);
  51.         if (count($body) >$ile) {
  52.             $str = $body['0']." ";
  53.             
  54.             for ($n=1; $n<$ile; $n++) {
  55.                 $str .= $body[$n]." ";
  56.             }
  57.             
  58.             $str .= "...";
  59.         }
  60.         else {
  61.             $str = $str;
  62.         }
  63.         return $str;
  64.     }
  66.     /**
  67.      * @Route("/aranzacjapdf", name="frontend.aranzacjapdf", options={"seo"="false"}, methods={"GET"})
  68.      */
  69.     public function example(SalesChannelContext $context, Request $request): Response
  70.     {
  71.         $idAr = $request->get('id'); 
  72.         $kodAr = $request->get('kod');
  73.         $co = $request->get('co');
  74.         $typ = $request->get('typ');
  75.         
  76.         $aranzacja = $this->arrangementService->getArrangementById($idAr, $context, $request);
  77.         
  78.         date_default_timezone_set('Europe/Warsaw');
  79.         $data = date("Y-m-d H:i:s");
  80.         $data_plik = date("Ymd-His");
  81.         
  82.         $okladka = $aranzacja->getCover()->getMedia()->getUrl();
  83.         $produkty = $aranzacja->getArrangementProducts();
  84.         $nazwa = $aranzacja->getName();
  85.         
  86.         if($co=="xls"){
  87.             define('FORMAT_PLN', '_-* #,##0.00\ [$zł-415]_-');
  88.             
  89.             $objPHPExcel = new Spreadsheet();
  90.             
  91.             $objPHPExcel->setActiveSheetIndex(0)
  92.                         ->setCellValue('A1', $kodAr.' '.$nazwa)
  93.                         ->setCellValue('A2', 'z dnia '.$data);
  94.             $objPHPExcel->getActiveSheet()->mergeCells('A1:G1');
  95.             $objPHPExcel->getActiveSheet()->mergeCells('A2:G2');
  96.             //$objPHPExcel->getActiveSheet()->getStyle("A1:G1")->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
  97.             $objPHPExcel->getActiveSheet()->getStyle("A1:G1")->getAlignment()->setHorizontal('center');
  98.             $objPHPExcel->getActiveSheet()->getStyle("A1:G1")->getBorders()->getTop()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN);
  99.             $objPHPExcel->getActiveSheet()->getStyle("A1:G1")->getBorders()->getRight()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN);
  100.             $objPHPExcel->getActiveSheet()->getStyle("A1:G1")->getBorders()->getLeft()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN);
  101.             $objPHPExcel->getActiveSheet()->getStyle("A1:G1")->getBorders()->getBottom()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN);
  102.             $objPHPExcel->getActiveSheet()->getStyle("A2:G2")->getAlignment()->setHorizontal('center');
  103.             $objPHPExcel->getActiveSheet()->getStyle("A2:G2")->getBorders()->getTop()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN);
  104.             $objPHPExcel->getActiveSheet()->getStyle("A2:G2")->getBorders()->getRight()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN);
  105.             $objPHPExcel->getActiveSheet()->getStyle("A2:G2")->getBorders()->getLeft()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN);
  106.             $objPHPExcel->getActiveSheet()->getStyle("A2:G2")->getBorders()->getBottom()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN);
  107.             
  108.             if($okladka!=""){
  109.                 $tmp = explode(".", $okladka);
  110.                 $ext = $tmp[count($tmp)-1];
  111.                 if($ext=="png"){
  112.                     $gdImage = imagecreatefrompng($okladka);
  113.                 }
  114.                 else{
  115.                     $gdImage = imagecreatefromjpeg($okladka);
  116.                 } 
  117.                 // Add a drawing to the worksheetecho date('H:i:s') . " Add a drawing to the worksheet\n";
  118.                 $objDrawing = new MemoryDrawing();
  119.                 $objDrawing->setName($kodAr);
  120.                 $objDrawing->setDescription($nazwa);
  121.                 $objDrawing->setImageResource($gdImage);
  122.                 if($ext=="png"){
  123.                     $objDrawing->setRenderingFunction(\PhpOffice\PhpSpreadsheet\Worksheet\MemoryDrawing::RENDERING_PNG);
  124.                     $objDrawing->setMimeType(\PhpOffice\PhpSpreadsheet\Worksheet\MemoryDrawing::MIMETYPE_PNG);
  125.                 }
  126.                 else{
  127.                     $objDrawing->setRenderingFunction(\PhpOffice\PhpSpreadsheet\Worksheet\MemoryDrawing::RENDERING_JPEG);
  128.                     $objDrawing->setMimeType(\PhpOffice\PhpSpreadsheet\Worksheet\MemoryDrawing::MIMETYPE_JPEG);
  129.                 }  
  130.                 $objDrawing->setHeight(300);
  131.                 $objDrawing->setCoordinates('C3');
  132.                 $objDrawing->setWorksheet($objPHPExcel->getActiveSheet());
  133.                 //$objDrawing->setOffsetX(20);
  134.                 $objDrawing->setOffsetY(20);
  135.                 $objPHPExcel->getActiveSheet()->getRowDimension(3)->setRowHeight(260);
  136.                 //$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(15);
  137.                 $objPHPExcel->getActiveSheet()->mergeCells('A3:G3');
  138.                 $objPHPExcel->getActiveSheet()->getStyle("A3:G3")->getBorders()->getTop()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN);
  139.                 $objPHPExcel->getActiveSheet()->getStyle("A3:G3")->getBorders()->getRight()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN);
  140.                 $objPHPExcel->getActiveSheet()->getStyle("A3:G3")->getBorders()->getLeft()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN);
  141.                 $objPHPExcel->getActiveSheet()->getStyle("A3:G3")->getBorders()->getBottom()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN);
  142.             }  
  143.             
  144.             $wiersz = 5;
  145.             $objPHPExcel->setActiveSheetIndex(0)
  146.                         ->setCellValue("A$wiersz", "")
  147.                         ->setCellValueExplicit("B$wiersz", "Kod", \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING)
  148.                         ->setCellValue("C$wiersz", "Nazwa")
  149.                         ->setCellValue("D$wiersz", "Opis")
  150.                         ->setCellValue("E$wiersz", "Ilość")
  151.                         ->setCellValue("F$wiersz", "Brutto")
  152.                         ->setCellValue("G$wiersz", "Suma");
  153.             $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(25);
  154.             $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(25);
  155.             $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(40);
  156.             $objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(15);
  157.             $objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(15);
  158.             $objPHPExcel->getActiveSheet()->getStyle("A$wiersz:G$wiersz")->getAlignment()->setHorizontal('center');
  159.             $objPHPExcel->getActiveSheet()->getStyle("A$wiersz:G$wiersz")->getBorders()->getTop()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN);
  160.             $objPHPExcel->getActiveSheet()->getStyle("A$wiersz:G$wiersz")->getBorders()->getRight()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN);
  161.             $objPHPExcel->getActiveSheet()->getStyle("A$wiersz:G$wiersz")->getBorders()->getLeft()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN);
  162.             $objPHPExcel->getActiveSheet()->getStyle("A$wiersz:G$wiersz")->getBorders()->getBottom()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN);
  163.             $wiersz++;
  164.             $suma = 0;
  165.             foreach($produkty->getElements() as $elem){
  166.                 if($elem->getProduct()->getActive()==1){
  167.                     $media = $elem->getProduct()->getCover();
  168.                     $kod = $elem->getProduct()->getProductNumber();
  169.                     $nazwa_prd = $elem->getProduct()->getName();
  170.                     $ile = $elem->getQuantity();
  171.                     $opis = $elem->getProduct()->getDescription();
  172.                     $opis = html_entity_decode($opis, ENT_QUOTES, 'UTF-8');
  173.                     $ceny = $elem->getProduct()->getPrice()->getElements();
  174.                     foreach($ceny as $c){
  175.                         $cena = $c->getGross();
  176.                     }
  177.                     $objPHPExcel->setActiveSheetIndex(0)
  178.                                 ->setCellValueExplicit("B$wiersz", $kod, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING)
  179.                                 ->setCellValue("C$wiersz", $nazwa_prd)
  180.                                 ->setCellValue("D$wiersz", strip_tags($opis))
  181.                                 ->setCellValue("E$wiersz", $ile)
  182.                                 ->setCellValue("F$wiersz", $cena)
  183.                                 ->setCellValue("G$wiersz", $ile*$cena);
  184.                     //$objPHPExcel->getActiveSheet()->getRowDimension($wiersz)->setRowHeight(-1);
  185.                     $objPHPExcel->getActiveSheet()->getStyle("F$wiersz")->getNumberFormat()->setFormatCode(FORMAT_PLN);
  186.                     $objPHPExcel->getActiveSheet()->getStyle("G$wiersz")->getNumberFormat()->setFormatCode(FORMAT_PLN);
  187.                     $objPHPExcel->getActiveSheet()->getStyle("B$wiersz")->getAlignment()->setVertical('top');
  188.                     $objPHPExcel->getActiveSheet()->getStyle("C$wiersz")->getAlignment()->setVertical('top');
  189.                     $objPHPExcel->getActiveSheet()->getStyle("D$wiersz")->getAlignment()->setVertical('top');
  190.                     $objPHPExcel->getActiveSheet()->getStyle("E$wiersz")->getAlignment()->setVertical('top');
  191.                     $objPHPExcel->getActiveSheet()->getStyle("F$wiersz")->getAlignment()->setVertical('top');
  192.                     $objPHPExcel->getActiveSheet()->getStyle("G$wiersz")->getAlignment()->setVertical('top');
  193.                     $objPHPExcel->getActiveSheet()->getStyle("C$wiersz")->getAlignment()->setWrapText(true); 
  194.                     $objPHPExcel->getActiveSheet()->getStyle("D$wiersz")->getAlignment()->setWrapText(true);   
  195.                     if($media!=""){
  196.                         $obrazek = $media->getMedia()->getUrl();
  197.                         $gdImage = imagecreatefromjpeg($obrazek);
  198.                         // Add a drawing to the worksheetecho date('H:i:s') . " Add a drawing to the worksheet\n";
  199.                         $objDrawing = new MemoryDrawing();
  200.                         $objDrawing->setName($kod);
  201.                         $objDrawing->setDescription($kod);
  202.                         $objDrawing->setImageResource($gdImage);
  203.                         $objDrawing->setRenderingFunction(\PhpOffice\PhpSpreadsheet\Worksheet\MemoryDrawing::RENDERING_JPEG);
  204.                         $objDrawing->setMimeType(\PhpOffice\PhpSpreadsheet\Worksheet\MemoryDrawing::MIMETYPE_DEFAULT);
  205.                         $objDrawing->setHeight(60);
  206.                         $objDrawing->setCoordinates('A'.$wiersz);
  207.                         $objDrawing->setWorksheet($objPHPExcel->getActiveSheet());
  208.                         $objDrawing->setOffsetX(20);
  209.                         $objDrawing->setOffsetY(20);
  210.                     }   
  211.                     //i jeszcze wysokość i szerokość, aby foty na siebie nie nachodziły
  212.                     $objPHPExcel->getActiveSheet()->getRowDimension($wiersz)->setRowHeight(80);
  213.                     $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(15);
  214.                     $objPHPExcel->getActiveSheet()->getStyle("A$wiersz")->getAlignment()->setVertical('top');
  215.                     $objPHPExcel->getActiveSheet()->getStyle("A$wiersz")->getAlignment()->setHorizontal('center');
  216.                     $objPHPExcel->getActiveSheet()->getStyle("A$wiersz:G$wiersz")->getAlignment()->setHorizontal('center');
  217.                     $objPHPExcel->getActiveSheet()->getStyle("A$wiersz:G$wiersz")->getBorders()->getTop()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN);
  218.                     $objPHPExcel->getActiveSheet()->getStyle("A$wiersz:G$wiersz")->getBorders()->getRight()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN);
  219.                     $objPHPExcel->getActiveSheet()->getStyle("A$wiersz:G$wiersz")->getBorders()->getLeft()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN);
  220.                     $objPHPExcel->getActiveSheet()->getStyle("A$wiersz:G$wiersz")->getBorders()->getBottom()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN);
  221.                     $wiersz++;
  222.                     $suma += ($ile * $cena);
  223.                 }
  224.             }
  225.             $wiersz++;
  226.             $objPHPExcel->setActiveSheetIndex(0)
  227.                         ->setCellValue("F$wiersz", "Łączna wartość")
  228.                         ->setCellValue("G$wiersz", $suma);
  229.             $objPHPExcel->getActiveSheet()->getStyle("G$wiersz")->getNumberFormat()->setFormatCode(FORMAT_PLN);
  230.             $objPHPExcel->getActiveSheet()->getStyle("F$wiersz:G$wiersz")->getBorders()->getTop()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN);
  231.             $objPHPExcel->getActiveSheet()->getStyle("F$wiersz:G$wiersz")->getBorders()->getRight()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN);
  232.             $objPHPExcel->getActiveSheet()->getStyle("F$wiersz:G$wiersz")->getBorders()->getLeft()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN);
  233.             $objPHPExcel->getActiveSheet()->getStyle("F$wiersz:G$wiersz")->getBorders()->getBottom()->setBorderStyle(\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN);
  234.             
  235.             /* foreach($objPHPExcel->getActiveSheet()->getRowDimensions() as $rd) {
  236.                 $rd->setRowHeight(-1);
  237.             } */ 
  238.             
  239.             $objPHPExcel->getActiveSheet()->setTitle("Kalkulacja");
  240.             $objPHPExcel->setActiveSheetIndex(0);
  241.             
  242.             $objWriter = new Xlsx($objPHPExcel);
  243.             
  244.             ob_start();
  245.             $objWriter->save('php://output');
  246.             
  247.             $response = new Response(ob_get_clean());
  248.             
  249.             $response->headers->addCacheControlDirective('no-cache', true);
  250.             $response->headers->addCacheControlDirective('must-revalidate', true);
  251.             $response->headers->set('Content-Type', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
  252.             $response->headers->set('Content-Disposition', 'attachment;filename="kalkulacja_'.$kodAr.'.xlsx"');
  253.             $response->headers->set('Cache-Control','max-age=0');
  254.             
  255.             return $response;
  256.         }
  257.         else{
  258.             $html = "<style>table{width:100%; vertical-align:top; border-collapse:collapse; color:#3f4c58; font-family:Signika; font-size:15px;} 
  259.             td, th{padding:5px 10px; border:1px solid #ddd;} .obrazek{width:150px;} 
  260.             .naglowek{font-weight:bold; margin-bottom:15px;} .naglowek_mail{margin-bottom:5px;} 
  261.             .naglowek_data{font-style:italic;} .right{text-align:right; white-space:nowrap;} .center{text-align:center;}
  262.             .podsumowanie{text-align:right; border-top:3px solid #eeeeee;} .podsumowanie_ost{white-space:nowrap;}</style>";
  263.             $html .= "<table>";
  264.                 $html .= "<tr>";
  265.                     $html .= "<td class='center'>";
  266.                         $html .= "<p class='naglowek'>$kodAr $nazwa</p>";
  267.                         $html .= "<p class='naglowek_data'>$data</p>";
  268.                         $html .= "<p>".($okladka!="" ? "<img src='$okladka'/>" : "")."</p>";
  269.                     $html .= "</td>";
  270.                 $html .= "<tr/>";
  271.             $html .= "</table>";
  272.             $html .= "<pagebreak />";
  273.             $html .= "<table>";
  274.                 $html .= "<tr><th width:15%></th><th width='15%'>Kod</th><th width='15%'>Nazwa</th><th width='30%'>Opis</th><th width='5%'>Szt.</th><th width='10%'>Brutto</th><th width='10%'>Suma</th></tr>";
  275.             
  276.                 $suma = 0;
  277.                 foreach($produkty->getElements() as $elem){
  278.                     if($elem->getProduct()->getActive()==1){
  279.                         $media = $elem->getProduct()->getCover();
  280.                         $html .= "<tr><td class='center'>";
  281.                         if($media!=""){
  282.                                 $html .= "<img src='".$media->getMedia()->getUrl()."' class='obrazek'/>";
  283.                         }
  284.                         $html .= "</td>";
  285.                         $html .= "<td>".$elem->getProduct()->getProductNumber()."</td><td>".$elem->getProduct()->getName()."</td>";
  286.                         $ile = $elem->getQuantity();
  287.                         $opis = $elem->getProduct()->getDescription();
  288.                         $opis = html_entity_decode($opis, ENT_QUOTES, 'UTF-8');
  289.                         $words = explode(" ", strip_tags($opis));
  290.                         if(count($words)>200){
  291.                             $opis = $this->ciach($opis, 200)."<br/>Więcej informacji na stronie <a href='https://mbpl1.mojebambino.dev' target='_blank'>www.mbpl1.mojebambino.dev</a>";
  292.                         }
  293.                         $html .= "<td>".$opis."</td><td class='right'>$ile</td>";
  294.                         $html .= "<td class='right'>";
  295.                             $ceny = $elem->getProduct()->getPrice()->getElements();
  296.                             foreach($ceny as $c){
  297.                                 $cena = $c->getGross();
  298.                             }
  299.                             $html .= number_format($cena, 2, ",", " ")." zł";
  300.                         $html .= "</td><td class='right'>".number_format(($ile * $cena), 2, ",", " ")." zł</td></tr>";
  301.                         $suma += ($ile * $cena);
  302.                     }
  303.                 }
  304.                 $html .= "<tr><td colspan=6 class='podsumowanie podsumowanie_ost'>Łączna wartość:</td>";
  305.                 $html .= "<td class='podsumowanie podsumowanie_ost'>".number_format($suma, 2, ",", " ")." zł</td></tr>";
  306.             $html .= "</table>";
  307.             
  308.             $query = $this->connection->insert('kalkulacje_arr', ['id' => NULL, 'kod'=>$kodAr, 'created_at'=>$data]);
  309.             
  310.             $mpdf = new \Mpdf\Mpdf(['mode' => 'UTF-8', 'format' => 'A4', 'orientation' => 'L']);
  311.             // Set a simple Footer including the page number
  312.             $mpdf->setFooter('Strona {PAGENO} z {nbpg}');
  313.             $mpdf->SetDefaultBodyCSS('background', "url('https://mbpl1.mojebambino.dev/images/PAPIER_MB_INSGRAF_PL_poziom.png')");
  314.             $mpdf->SetDefaultBodyCSS('background-image-resize', 6);
  315.             //$mpdf->autoPageBreak = false;
  316.             $mpdf->shrink_tables_to_fit = 1;
  317.             $mpdf->WriteHTML($html);
  318.             //$mpdf->shrink_tables_to_fit = 0;
  319.             
  320.             $plik = 'kalkulacje_arr/'.$kodAr.'_'.$data_plik.'.pdf';
  321.             $mpdf->Output($plik ,'F');
  322.             header("Content-Type: application/pdf");
  323.             header("Content-Disposition: attachment; filename=" . $plik);
  324.             readfile($plik);
  325.             unlink($plik);
  326.         }
  327.         //return $this->renderStorefront('@Storefront/storefront/page/example/test_index.html.twig');
  328.         return $response;
  329.     }
  330. }