src/Diplix/KMGBundle/Controller/Accounting/BillingController.php line 507

Open in your IDE?
  1. <?php
  2. namespace Diplix\KMGBundle\Controller\Accounting;
  4. use Diplix\KMGBundle\Controller\BaseController;
  5. use Diplix\KMGBundle\DataTables\DataTablesHelper;
  6. use Diplix\KMGBundle\DataTables\Expr\ExprStub;
  7. use Diplix\KMGBundle\Entity\Accounting\Billing;
  8. use Diplix\KMGBundle\Entity\Accounting\Document;
  9. use Diplix\KMGBundle\Entity\Accounting\Job;
  10. use Diplix\KMGBundle\Entity\Accounting\JobCalcItem;
  11. use Diplix\KMGBundle\Entity\File;
  12. use Diplix\KMGBundle\Entity\Platform\PlatformClient;
  13. use Diplix\KMGBundle\Entity\Role;
  14. use Diplix\KMGBundle\Entity\StandByDispoEntry;
  15. use Diplix\KMGBundle\Form\Accounting\DocumentForm;
  16. use Diplix\KMGBundle\Form\Accounting\NewDocumentForm;
  17. use Diplix\KMGBundle\Form\DefaultDeleteForm;
  18. use Diplix\KMGBundle\Helper\ClientConfigProvider;
  19. use Diplix\KMGBundle\PdfGeneration\InvoicePdf;
  20. use Diplix\KMGBundle\PdfGeneration\ZugferdGenerator;
  21. use Diplix\KMGBundle\Repository\FileRepository;
  22. use Diplix\KMGBundle\Service\MailHelper;
  23. use Diplix\KMGBundle\Util\ExcelExportHelper;
  24. use Doctrine\ORM\AbstractQuery;
  25. use Doctrine\ORM\EntityManagerInterface;
  26. use Doctrine\ORM\EntityRepository;
  27. use Doctrine\ORM\Tools\Pagination\Paginator;
  28. use horstoeko\zugferd\ZugferdDocumentReader;
  29. use horstoeko\zugferdvisualizer\renderer\ZugferdVisualizerDefaultRenderer;
  30. use horstoeko\zugferdvisualizer\ZugferdVisualizer;
  31. use League\Flysystem\FilesystemOperator;
  32. use PHPExcel_Style_Border;
  33. use PHPExcel_Style_Fill;
  34. use Symfony\Component\Form\FormError;
  35. use Symfony\Component\HttpFoundation\BinaryFileResponse;
  36. use Symfony\Component\HttpFoundation\JsonResponse;
  37. use Symfony\Component\HttpFoundation\RedirectResponse;
  38. use Symfony\Component\HttpFoundation\Request;
  39. use Symfony\Component\HttpFoundation\Response;
  40. use Symfony\Component\HttpFoundation\ResponseHeaderBag;
  41. use Symfony\Component\HttpFoundation\StreamedResponse;
  42. use Symfony\Component\PropertyAccess\PropertyAccess;
  43. use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  45. class BillingController extends BaseController
  46. {
  47.     public static $bold = [
  48.         'font' => array(
  49.             'name' => 'Arial',
  50.             'bold'=> true,
  51.             'italic'    => false,
  52.         )];
  54.     public static $columnSetup =
  55.                 array(  0=>array('fieldName' => 'doc.id', 'caption' => '#', 'headStyle' => 'width:16px;', 'type' =>DataTablesHelper::T_SELECTOR),
  56.                         1=>array('fieldName' => 'doc.type', 'caption' => 'T','headStyle' => 'width:16px;'),
  57.                         2=>array('fieldName' => 'doc.number','caption'=>'Nummer'),
  58.                         3=>array('fieldName' => 'doc.date' , 'caption'=>'Datum'),
  59.                         4=>array('fieldName' => 'doc.accountingMonth', 'caption'=>'M'),
  60.                         5=>array('fieldName' => 'doc.accountingYear', 'caption'=>'Y'),
  61.                         6=>array('fieldName' => 'doc.ref', 'virtual'=>true, 'caption'=>'Kunde/Mitglied'),
  62.                         7=>array('fieldName' => 'doc.totalNet','caption'=>'Gesamtbetrag'),
  63.                         8=>array('fieldName' => 'doc.status', 'caption'=>'Status'),
  64.                         9=>array('fieldName'=>'sentToReceiver','type'=>DataTablesHelper::T_CSSICON, 'caption'=>'V','virtual'=>true),
  65.                         10=>array('fieldName' => '_buttons', 'caption' => '', 'virtual' =>true, 'headStyle' => 'width:96px;', 'type' =>DataTablesHelper::T_BUTTONS),
  66.                         11=>array('fieldName' => '_status','visible'=>false,'virtual'=>true),
  68.                 );
  70.     protected function getDth()
  71.     {
  72.         return new DataTablesHelper(self::$columnSetup,
  73.                     [
  74.                     'ajaxUrl'       => $this->get('router')->generate('acc-billing-jsonlist'),
  75.                     'ajaxData'      => 'requestData', // js function to call for getting additional req data
  76.                     'defaultSorting'=> array(3=> 'asc',2=> 'asc')
  77.                     ]);
  78.     }
  80.     protected function init()
  81.     {
  82.         $this->ensureUserHasRole(Role::ACCOUNTING);
  83.     }
  85.     public function __construct(
  86.         protected ClientConfigProvider $ccp,
  87.         FileRepository $fileRepository,
  88.         protected MailHelper $mailHelper,
  89.         protected FilesystemOperator $uploadsFilesystem,
  90.         private readonly \Doctrine\Persistence\ManagerRegistry $managerRegistry
  91.     )
  92.     {
  93.         $this->fileRepo = $fileRepository;
  94.     }
  96.     public function indexAction(Request $request, $type)
  97.     {
  98.         $this->init();
  100.         $now = (new \DateTime())->modify('-1 month');
  101.         $aM = $request->query->get('am',$now->format('m'));
  102.         $aY = $request->query->get('ay',$now->format('Y'));
  103.         $now = new \DateTime(sprintf('%4d-%02d-01',$aY,$aM));
  104.         $from = (clone $now)->sub(new \DateInterval('P3M'));
  105.         $until = (clone $now)->add(new \DateInterval('P3M'));
  107.         $dth = $this->getDth();
  108.         return $this->render('@DiplixKMG/Accounting/Billing/list.html.twig',[
  109.             'columnSetup' =>$dth->getColumnSetup(),
  110.             'type' => $type,
  111.             'stati' => Document::$statusMap,
  112.             'filterFrom' =>'',//$from->format('Y-m-01'),
  113.             'filterTo' =>'',//$until->format('Y-m-t'),
  114.             'accountingYear' => $aY,
  115.             'accountingMonth'=> $aM
  116.         ]);
  117.     }
  119.     public function jsonListAction(Request $request)
  120.     {
  121.         $this->init();
  122.         $dth = $this->getDth();
  124.         $req = $request->query->all();
  125.         /** @var EntityRepository $repo */
  126.         $repo = $this->managerRegistry->getRepository(Document::class);
  127.         $cb = $repo->createQueryBuilder("doc")
  128.                         ->select("doc")
  129.                         ->leftJoin("doc.member","mem")
  130.                         ->leftJoin("doc.customer","customer");
  131.         // process filtering,ordering,paging
  132.         $dth->setQueryBuilder($cb);
  133.         if ($req['type']!=='')
  134.         {
  135.             $dth->addAnd('doc.type = :type',['type'=>$req['type']]);
  136.         }
  137.         if ($req['status']!=='')
  138.         {
  139.             $dth->addAnd('doc.status = :status',['status'=>$req['status']]);
  140.         }
  141.         if ($req['filterFrom']!=='')
  142.         {
  143.             $from = new \DateTime($req['filterFrom']); $from->setTime(0,0,0);
  144.             $cb->andWhere('doc.date >= :from')->setParameter('from',$from);
  145.         }
  146.         if ($req['filterTo']!=='')
  147.         {
  148.             $to = new \DateTime($req['filterTo']); $to->setTime(23,59,59);
  149.             $cb->andWhere('doc.date <= :to')->setParameter('to',$to);
  150.         }
  151.         if ($req['accountingMonth']!=='')
  152.         {
  153.             $cb->andWhere('doc.accountingMonth = :m')->setParameter('m',$req['accountingMonth']);
  154.         }
  155.         if ($req['accountingYear']!=='')
  156.         {
  157.             $cb->andWhere('doc.accountingYear = :y')->setParameter('y',$req['accountingYear']);
  158.         }
  160.         $rawOrder = $dth->getRawColumnOrder($req);
  161.         if ($req['type']===Document::TYPE_RECHNUNG)
  162.         {
  163.             $dth->addSimpleFilter(6,$req,$rawOrder,[ExprStub::like("customer.name")],"customer.name",true);
  164.         }
  165.         else
  166.         if ($req['type']===Document::TYPE_GUTSCHRIFT)
  167.         {
  168.             $dth->addSimpleFilter(6,$req,$rawOrder,[ExprStub::like("mem.name")],"mem.name",true);
  169.         }
  170.         $dth->addSimpleFilter(9,$req,$rawOrder,[],"doc.sentToReceiver");
  173.         $dth->processRequest($request);
  174.         // query and compile paged data
  175.         $query = $cb->getQuery();
  176.         $query->setHydrationMode(AbstractQuery::HYDRATE_OBJECT);
  177.         $paginator = new Paginator($cb->getQuery(),true);
  178.         $filteredCount = $paginator->count();
  179.         $filteredAndPaged = array();
  180.         $dit = $paginator->getIterator();
  181.         /** @var Document  $row */
  182.         foreach ($dit as $row)
  183.         {
  184.             $options = [];
  185.             $options[]= array("route"=>"acc-billing-edit", "title"=>"Bearbeiten", "icon"=>"glyphicon glyphicon-pencil", "parameters"=>array("id"=>$row->getId()) );
  188.             $options[]= array("route"=>"acc-billing-new-plain", "title"=>"Klonen", "icon"=>"glyphicon glyphicon-screenshot", "parameters"=>array("type"=>$row->getType(),"cloneFrom"=>$row->getId()) );
  190.             if ($this->hasUserRole(Role::ACCOUNTING_EDIT))
  191.             {
  192.                 $options[]= array("route"=>"acc-billing-delete", "title"=>"Löschen", "icon"=>"glyphicon glyphicon-trash", "parameters"=>array("id"=>$row->getId()) );
  193.             }
  194.             $options[]= array("route"=>"acc-billing-pdf", "title"=>"Dokument", "icon"=>"glyphicon glyphicon-floppy-save", "parameters"=>array("id"=>$row->getId()) );
  195.             $one = array(
  196.                     0 => $row->getId(),
  197.                     1 => Document::$typeMap[ $row->getType()],
  198.                     2 => $row->getNumber(),
  199.                     3 => ( $row->getDate() !== null ? $row->getDate()->format("d.m.Y") : "-" ),
  200.                     4 => sprintf('%02d',$row->getAccountingMonth()),
  201.                     5 => sprintf('%4d',$row->getAccountingYear()),
  202.                     6=> trim( ($row->getCustomer()!==null ? $row->getCustomer()->getName():"") ." ". ($row->getMember()!==null ? $row->getMember()->getName():"") ),
  203.                     7 => $row->getTotalNet(),
  204.                     8 => Document::$statusMap[ $row->getStatus() ] ,
  205.                     9 => $row->isSentToReceiver()!==null ? 1 : 0,
  206.                     10 =>$options,
  207.                     11 => $row->getStatus()
  208.             );
  209.             $filteredAndPaged[]= $one;
  210.         }
  211.         // get total unfiltered count
  212.         $query = $repo->createQueryBuilder("doc")
  213.                         ->select("COUNT(doc.id)")
  214.                         ->getQuery();
  215.         $res = $query->getResult();
  216.         $totalRecords = (int)$res[0][1];
  217.         // compile output
  218.         $output = array(
  219.             "draw" => $req['draw'],
  220.             "recordsTotal"=>$totalRecords,
  221.             "recordsFiltered"=>$filteredCount,
  222.             "data" => $filteredAndPaged
  223.         );
  224.         return $this->getJsonResponse($request,$output);
  225.     }
  227.     public function newDocumentAction(Request $request,$type)
  228.     {
  229.         $this->init();
  230.         $this->ensureUserHasRole(Role::ACCOUNTING_EDIT);
  231.         $audience = $type===Document::TYPE_GUTSCHRIFT ? Billing::TYPE_MEMBER : Billing::TYPE_CUSTOMER;
  232.         return $this->redirectToRoute('acc-billing-process',['type'=>$audience,'fromStr'=>'null']);
  233.     }
  235.     public function editByBillingIdAction(Request $request, $billingId)
  236.     {
  237.         $this->init();
  238.         $repo = $this->managerRegistry->getRepository(Document::class);
  239.         $row = $repo->findOneBy(['billing' =>$billingId]);
  240.         return $this->redirectToRoute('acc-billing-edit',['id'=> ($row!==null ? $row->getId() : -1 )]);
  241.     }
  243.     protected function newPdf(Document $row, ?ZugferdGenerator $zugferdGenerator = null)
  244.     {
  245.         $config = $this->ccp;
  246.         $pdfLogo = $config->getPdfLogo()!== null ?  '@' . stream_get_contents( $this->fileRepo->getStream($config->getPdfLogo()) ) : null;
  247.         $pdf = new InvoicePdf("de","",$pdfLogo);
  248.         $pdf->setZugferdGenerator($zugferdGenerator);
  249.         $pdf->setSender(
  250.             $config->getPdfSenderShort(),
  251.             $config->getPdfSenderLong(),
  252.             $config->getPdfFooter()
  253.         );
  254.         $pdf->render($row);
  255.         return $pdf;
  256.     }
  258.     protected function createPdf(Document $row)
  259.     {
  260.         $pdf = $this->newPdf($row);
  261.         $pdfData = $pdf->Output('temp.pdf','S');
  262.         $F = File::fromPsr7StreamOrString($pdfData, $row->generateFilename(), $this->uploadsFilesystem ,'pdf');
  263.         $this->managerRegistry->getManager()->persist($F);
  264.         $this->managerRegistry->getManager()->flush();
  265.         $this->addFlash('success','PDF-Datei wurde erzeugt');
  266.         return $F;
  267.     }
  269.     protected function doFaktura(Document $row)
  270.     {
  271.         $row->setStatus(Document::STATUS_OFFEN);
  272.         $row->setTreatedBy($this->getCurrentUser());
  273.         // generate PDF
  274.         if ($row->getPdfFile()===null)
  275.         {
  276.             $F = $this->createPdf($row);
  277.             $row->setPdfFile($F);
  278.         }
  279.     }
  281.     public function editAction(Request $request,$id)
  282.     {
  283.         $this->init();
  284.         $repo = $this->managerRegistry->getRepository(Document::class);
  285.         /** @var Document $row */
  286.         $row = $repo->findOneBy(['id' =>$id]);
  287.         if (!is_object($row))
  288.         {
  289.             $this->addFlash('warning','Ungültige ID oder Zugriff verweigert.');
  290.             return $this->redirectToRoute('acc-billing');
  291.         }
  292.         $form = $this->createForm(DocumentForm::class,$row,[]);
  293.         $form->handleRequest($request);
  294.         if ( ($form->isSubmitted()) && ($form->isValid()) )
  295.         {
  296.             $this->ensureUserHasRole(Role::ACCOUNTING_EDIT);
  298.             try {
  299.                 if ($form->has('extraPdf'))
  300.                 {
  301.                     if (!$this->handleFileUpload($form,$row,"extraPdf",File::TYPE_FILE))
  302.                     {
  303.                         throw new \RuntimeException('Upload fehlgeschlagen.');
  304.                     }
  305.                 }
  306.             }
  307.             catch (\Throwable $ex)
  308.             {
  309.                 $this->addFlash('error',$ex->getMessage());
  310.                 return $this->redirectToRoute('acc-billing-edit',['id'=>$row->getId()]);
  311.             }
  314.             $this->addFlash('success','Änderungen gespeichert.');
  316.             $row->setTotalNet(    $row->recalculateExtraItems() + ($row->getBilling()!==null ?  $row->getBilling()->recalculateTotal() : 0));
  318.             if ($form->has('set_paid') && $form->get('set_paid')->isClicked())
  319.             {
  320.                 $row->setStatus(Document::STATUS_BEZAHLT);
  321.                 $this->addFlash('success','Dokument wurde bezahlt.');
  322.             }
  323.             else
  324.             if ($form->has('set_open') && $form->get('set_open')->isClicked())
  325.             {
  326.                 $this->doFaktura($row);
  327.                 $this->addFlash('success','Dokument wurde auf den Status "offen" aktualisiert.');
  328.             }
  329.             else
  330.             if ($form->has('set_canceled') && $form->get('set_canceled')->isClicked())
  331.             {
  332.                 try
  333.                 {
  334.                     $repo->cancelDocument($row);
  335.                     $this->addFlash('success','Dokument storniert');
  336.                 }
  337.                 catch (\Throwable $ex)
  338.                 {
  339.                     $this->addFlash('danger','Stornieren fehlgeschlagen. '.$ex->getMessage());
  340.                 }
  341.             }
  342.             else
  343.             if ($form->has('set_mahnung') && $form->get('set_mahnung')->isClicked())
  344.             {
  345.                 switch ($row->getStatus())
  346.                 {
  347.                     case Document::STATUS_OFFEN:
  348.                         $row->setStatus(Document::STATUS_MAHNSTUFE1);
  349.                         $row->setReminderPdf( $this->createPdf($row) );
  350.                         break;
  351.                     case Document::STATUS_MAHNSTUFE1:
  352.                         $row->setStatus(Document::STATUS_MAHNSTUFE2);
  353.                         $row->setMonition1Pdf( $this->createPdf($row) );
  354.                         break;
  355.                     case Document::STATUS_MAHNSTUFE2:
  356.                         $row->setStatus(Document::STATUS_MAHNSTUFE3);
  357.                         $row->setMonition2Pdf( $this->createPdf($row) );
  358.                         break;
  359.                     default:
  360.                         throw $this->createAccessDeniedException('Ungültige Transition');
  361.                 }
  362.             }
  365.             $repo->flush();
  367.             return $this->redirectToRoute('acc-billing-edit',['id'=>$row->getId()]);
  368.         }
  371.         return $this->render('@DiplixKMG/Accounting/Billing/edit.html.twig',[
  372.             'form' => $form->createView(),
  373.             'statusMap' => Document::$statusMap,
  374.             'typeMap' => Document::$typeMap,
  375.             'row' => $row
  376.         ]);
  377.     }
  379.     public function extraPdfAction(Request $request, $id,$type)
  380.     {
  381.         $this->init();
  382.         $repo = $this->managerRegistry->getRepository(Document::class);
  383.         /** @var Document $row */
  384.         $row = $repo->findOneBy(['id' => $id]);
  385.         if (!is_object($row)) {
  386.             $this->addFlash('warning', 'Ungültige ID oder Zugriff verweigert.');
  387.             return $this->redirectToRoute('acc-billing', ['type' => $row->getType()]);
  388.         }
  389.         $pa  = PropertyAccess::createPropertyAccessor();
  390.         /** @var File $file */
  391.         $file = $pa->getValue($row,$type);
  392.         if (!($file instanceof File))
  393.         {
  394.             throw  $this->createAccessDeniedException('Ungültiger Zugriff');
  395.         }
  397.         return $this->fileRepo->getDownloadResponseFor($request,$file->getId());
  398.     }
  400.     public function pdfAction(Request $request, $id)
  401.     {
  402.         $this->init();
  403.         $repo = $this->managerRegistry->getRepository(Document::class);
  404.         /** @var Document $row */
  405.         $row = $repo->findOneBy(['id' =>$id]);
  406.         if (!is_object($row))
  407.         {
  408.             $this->addFlash('warning','Ungültige ID oder Zugriff verweigert.');
  409.             return $this->redirectToRoute('acc-billing',['type'=>""]);
  410.         }
  412.         // serve the existing pdf if there is one, skip only if forced to do so by request param
  413.         if (($row->getPdfFile() !== null) && ($request->get('forceGeneration',0)===0))
  414.         {
  415.             return $this->fileRepo->getDownloadResponseFor($request,$row->getPdfFile()->getId());
  416.         }
  418.         if (($row->getBilling() === null)&&(count($row->getExtraCalculationItems())===0))
  419.         {
  420.             $this->addFlash('warning','PDF kann nicht mehr neu erzeugt werden da die Abrechnungsdaten nicht mehr vorhanden sind und keine weiteren Posten existieren.');
  421.             return $this->redirectToRoute('acc-billing',['type'=>$row->getType()]);
  422.         }
  423.         // neu erzeugen
  424.         $pdfFile = $this->getParameter('dx.temp_dir'). $row->generateFilename().date('Y-m-d_H_i_s').'.pdf';
  425.         try {
  426.             $pdf = $this->newPdf($row);
  427.             $pdf->Output($pdfFile);
  428.             return $this->getDownloadResponse($pdfFile,basename($pdfFile));
  429.         }
  430.         catch (\Throwable $ex)
  431.         {
  432.             $this->addFlash('danger','PDF-Erzeugung fehlgeschlagen: '.$ex->getMessage().($ex->getPrevious()!==null ? $ex->getPrevious()->getMessage():""));
  433.             return $this->redirectToRoute('acc-billing-edit',['id'=>$row->getId()]);
  434.         }
  435.     }
  437.     public function xmlAction(Request $request, EntityManagerInterface $em, $id)
  438.     {
  439.         $this->init();
  440.         $repo = $em->getRepository(Document::class);
  441.         /** @var Document $row */
  442.         $row = $repo->findOneBy(['id' =>$id]);
  443.         if (!is_object($row))
  444.         {
  445.             $this->addFlash('warning','Ungültige ID oder Zugriff verweigert.');
  446.             return $this->redirectToRoute('acc-billing',["type"=>""]);
  447.         }
  448.         $zugferd = new ZugferdGenerator();
  449.         $zugferd->setup($row);
  450.         $zugferd->setSellerFromClientConfig($this->ccp);
  451.         $tempPfd = $this->newPdf($row,$zugferd); // fill zugferd with line items
  452.         $zugferd->finalize();
  453.         $xml = $zugferd->getXmlContent();
  455.         /** @noinspection TypeUnsafeComparisonInspection */
  456.         if ($request->get('visualize',0)==1)
  457.         {
  458.             $doc = ZugferdDocumentReader::readAndGuessFromContent($xml);
  459.             $visualizer = new ZugferdVisualizer($doc);
  460.             // $visualizer->setDefaultTemplate();
  461.             $visualizer->setRenderer(new ZugferdVisualizerDefaultRenderer());
  462.             $visualizer->setTemplate(__DIR__ . "/../../Resources/views/Accounting/zugferd_visualizer_template.php");
  463.             return new Response($visualizer->renderMarkup());
  464.         }
  466.         $xmlFile = $this->getParameter('dx.temp_dir'). $row->generateFilename().date('Y-m-d_H_i_s').'.xml';
  467.         file_put_contents($xmlFile,$xml);
  468.         return $this->getDownloadResponse($xmlFile,basename($xmlFile));
  469.     }
  472.     public function deleteAction(Request $request, $id)
  473.     {
  474.         $this->init();
  475.         $this->ensureUserHasRole(Role::ACCOUNTING_EDIT);
  476.         $repo = $this->managerRegistry->getRepository(Document::class);
  477.         /** @var Document $row */
  478.         $row = $repo->findOneBy(['id' =>$id]);
  479.         if (!is_object($row))
  480.         {
  481.             $this->addFlash('warning','Ungültige ID oder Zugriff verweigert.');
  482.             return $this->redirectToRoute('acc-billing');
  483.         }
  485.         $form = null;
  486.         if ($row->getStatus() === Document::STATUS_ENTWURF)
  487.         {
  488.             $form = $this->createForm( DefaultDeleteForm::class,array('id' =>$id));
  489.             $form->handleRequest($request);
  490.             if ($form->isSubmitted())
  491.             {
  492.                 if ($form->get('commit')->getData() == 1)
  493.                 {
  494.                     $repo->cancelDocument($row);
  495.                     $this->addFlash('success','message.record-deleted');
  496.                 }
  497.                 return $this->redirectToRoute('acc-billing',['type'=>$row->getType()]);
  498.             }
  499.         }
  501.         return $this->render('@DiplixKMG/Accounting/Billing/delete.html.twig',array (
  502.             'row' => $row,
  503.             'form' => $form !== null ? $form->createView() : null,
  504.         ));
  505.     }
  507.     public function sendByMailAction(Request $request, $id)
  508.     {
  509.         $this->ensureUserHasRole(Role::ACCOUNTING_EDIT);
  510.         $type = $request->query->get('type','');
  511.         if ($request->getMethod()!==Request::METHOD_POST)
  512.         {
  513.             throw new \RuntimeException('POST required.');
  514.         }
  515.         $row = null;
  516.         $acceptsJson = in_array('application/json', $request->getAcceptableContentTypes(),false);
  517.         try {
  518.             $this->init();
  519.             $repo = $this->managerRegistry->getRepository(Document::class);
  520.             /** @var Document $row */
  521.             $row = $repo->findOneBy(['id' =>$id]);
  522.             if (!is_object($row))
  523.             {
  524.                 throw new \RuntimeException('Ungültige ID oder Zugriff verweigert.');
  525.             }
  526.             if ($row->getStatus() < Document::STATUS_OFFEN) {
  527.                 throw new \RuntimeException('Bitte fakturieren Sie das Dokument vor dem PDF-Versand.');
  528.             }
  529.             if ($row->getStatus() >= Document::STATUS_STORNIERT)
  530.             {
  531.                 throw new \RuntimeException('Ein storniertes Dokument kann nicht per eMail versendet werden.');
  532.             }
  534.             $mh = $this->mailHelper;
  535.             $mh->setFilesystem($this->uploadsFilesystem);
  536.             if ($row->getType() === Document::TYPE_RECHNUNG)
  537.             {
  538.                 if ($type === '')
  539.                 {
  540.                     $mh->SendInvoiceToCustomerMail($row);
  541.                     $row->setSentToReceiver(new \DateTime());
  542.                 }
  543.                 else
  544.                 if ($type === 'reminderPdf')
  545.                 {
  546.                     $mh->SendInvoiceFollowUpToCustomerMail($row, Document::STATUS_MAHNSTUFE1);
  547.                     $row->setReminderSentToReceiver(new \DateTime());
  548.                 }
  549.                 else
  550.                 if ($type === 'monition1Pdf')
  551.                 {
  552.                     $mh->SendInvoiceFollowUpToCustomerMail($row, Document::STATUS_MAHNSTUFE2);
  553.                     $row->setMonition1SentToReceiver(new \DateTime());
  554.                 }
  555.                 else
  556.                 if ($type === 'monition2Pdf')
  557.                 {
  558.                     $mh->SendInvoiceFollowUpToCustomerMail($row, Document::STATUS_MAHNSTUFE3);
  559.                     $row->setMonition2SentToReceiver(new \DateTime());
  560.                 }
  561.                 else
  562.                 {
  563.                     throw new \Exception('Invalid type');
  564.                 }
  565.             }
  566.             else
  567.             if ($row->getType() === Document::TYPE_GUTSCHRIFT)
  568.             {
  569.                 $mh->SendGutschriftToMemberMail($row);
  570.                 $row->setSentToReceiver(new \DateTime());
  571.             }
  573.             $repo->flush($row);
  574.             if (!$acceptsJson)
  575.             {
  576.                 $this->addFlash('success','Dokument versendet.');
  577.             }
  578.             else
  579.             {
  580.                 return new JsonResponse(['success'=>true,'message'=>'Dokument versendet']);
  581.             }
  582.         }
  583.         catch (\Throwable $ex)
  584.         {
  585.             if (!$acceptsJson)
  586.             {
  587.                 $this->addFlash('warning',$ex->getMessage());
  588.             }
  589.             else
  590.             {
  591.                 return new JsonResponse(['success'=>false,'message'=>$ex->getMessage()]);
  592.             }
  593.         }
  594.         if (!$acceptsJson)
  595.         {
  596.             return $this->redirectToRoute('acc-billing-edit',['id'=>$row->getId()]);
  597.         }
  598.     }
  601.     public function changeStateAction(Request $request, $id, $newStatus)
  602.     {
  603.         $this->ensureUserHasRole(Role::ACCOUNTING_EDIT);
  604.         $newStatus = (int)$newStatus;
  605.         try {
  606.             if ($request->getMethod() !== Request::METHOD_POST) {
  607.                 throw new \RuntimeException('POST required.');
  608.             }
  609.             $this->init();
  610.             $repo = $this->managerRegistry->getRepository(Document::class);
  611.             /** @var Document $row */
  612.             $row = $repo->findOneBy(['id' => $id]);
  613.             if (!is_object($row))
  614.             {
  615.                 throw new \RuntimeException('Ungültige ID oder Zugriff verweigert.');
  616.             }
  617.             if ($newStatus !== Document::STATUS_BEZAHLT)
  618.             {
  619.                 throw new \RuntimeException('Nichtunterstützter Statuswechsel (neuer Status ungültig)');
  620.             }
  621.             if (!in_array( $row->getStatus() , [Document::STATUS_OFFEN,Document::STATUS_MAHNSTUFE1,Document::STATUS_MAHNSTUFE2,Document::STATUS_MAHNSTUFE3]))
  622.             {
  623.                 throw new \RuntimeException('Nichtunterstützter Statuswechsel (Dokument im falschen Status)');
  624.             }
  625.             $row->setStatus($newStatus);
  626.             $repo->flush($row);
  628.             return new JsonResponse([
  629.                 'success'=>true,
  630.                 'message'=>'Status geändert.']);
  631.         }
  632.         catch (\Throwable $ex)
  633.         {
  634.             return new JsonResponse(['success' => false, 'message' => $ex->getMessage()]);
  635.         }
  636.     }
  639.     public function setOpenAction(Request $request, $id)
  640.     {
  641.         $this->ensureUserHasRole(Role::ACCOUNTING_EDIT);
  642.         if ($request->getMethod() !== Request::METHOD_POST) {
  643.             throw new \RuntimeException('POST required.');
  644.         }
  645.         $row = null;
  646.         $acceptsJson = in_array('application/json', $request->getAcceptableContentTypes(), false);
  647.         try {
  648.             $this->init();
  649.             $repo = $this->managerRegistry->getRepository(Document::class);
  650.             /** @var Document $row */
  651.             $row = $repo->findOneBy(['id' => $id]);
  652.             if (!is_object($row)) {
  653.                 throw new \RuntimeException('Ungültige ID oder Zugriff verweigert.');
  654.             }
  655.             if ($row->getStatus() != Document::STATUS_ENTWURF) {
  656.                 throw new \RuntimeException(sprintf('Dokument %s ist nicht im Entwurfsstatus',$row->getNumber()));
  657.             }
  659.             $this->doFaktura($row);
  660.             $repo->flush($row);
  661.             if (!$acceptsJson)
  662.             {
  663.                 $this->addFlash('success','Dokument wurde fakturiert.');
  664.             }
  665.             else
  666.             {
  667.                 $docUrl = $this->generateUrl('acc-billing-pdf',['id'=>$row->getId(), UrlGeneratorInterface::ABSOLUTE_URL]);
  668.                 return new JsonResponse([
  669.                     'success'=>true,
  670.                     'message'=>'Dokument fakturiert',
  671.                     'downloadUrl'=>$docUrl]);
  672.             }
  674.         } catch (\Throwable $ex) {
  675.             if (!$acceptsJson) {
  676.                 $this->addFlash('warning', $ex->getMessage());
  677.             } else {
  678.                 return new JsonResponse(['success' => false, 'message' => $ex->getMessage()]);
  679.             }
  680.         }
  681.         if (!$acceptsJson) {
  682.             return $this->redirectToRoute('acc-billing', []);
  683.         }
  684.     }
  686.     protected static function sumUpCustomerCalcCategories(Job $j)
  687.     {
  688.         $sum = [ JobCalcItem::Extra => 0, JobCalcItem::Wartezeit => 0, JobCalcItem::Pauschale => [], JobCalcItem::KM => 0 ];
  689.         /** @var JobCalcItem $item **/
  690.         foreach ($j->getCustomerCalculationItems() as $item)
  691.         {
  692.             if (in_array($item->category,[JobCalcItem::Extra, JobCalcItem::Wartezeit]))
  693.             {
  694.                 $sum[$item->category] += $item->totalNet;
  695.             }
  696.             else
  697.                 if ($item->category == JobCalcItem::KM)
  698.                 {
  699.                     $sum[$item->category] += $item->quantity;
  700.                 }
  701.                 else
  702.                 {
  703.                     $sum[JobCalcItem::Pauschale] []= $item->shortCode;
  704.                 }
  705.         }
  706.         $sum[JobCalcItem::Pauschale] = implode(',',$sum[JobCalcItem::Pauschale]);
  707.         return $sum;
  708.     }
  710.     protected function xlsLine(ExcelExportHelper $xh, Job $job, JobCalcItem $item = null)
  711.     {
  712.         if ($item === null) // first line - Job
  713.         {
  714.             $org = "";
  715.             $coce = $job->getCostCenter();
  716.             $match = ["3R","3G","3D"];
  717.             foreach ($match as $m)
  718.             {
  719.                 if (strpos($coce,$m)===0)
  720.                 {
  721.                     $org = $m;
  722.                     $coce = \Safe\substr($coce,strlen($m));
  723.                 }
  724.             }
  726.             $details = self::sumUpCustomerCalcCategories($job);
  727.             $xh->addRow(
  728.                 [
  729.                     "Bestellung" => $job->getKnownOrder()->getOrderId(),
  730.                     "Zeit" => $job->getOrderTime()->format('d.m.Y')." ".$job->getOrderTime()->format('H:i'),
  731.                     "Org" => $org,
  732.                     "Kostenstelle" => $coce,
  733.                     "Besteller" => $job->getKnownOrder()->getOrdererName(),
  734.                     "Kommentar" => $job->getInfo(),
  735.                     'KM' => [$details[JobCalcItem::KM] , ExcelExportHelper::TYPE_NUMERIC],
  736.                     // Kunden haben i.d.R. keine Pauschalen :: 'P'  => [$details[JobCalcItem::Pauschale], ExcelExportHelper::TYPE_STRING],
  737.                     'WZ(€ netto)' => [round($details[JobCalcItem::Wartezeit],2) , ExcelExportHelper::XTYPE_CURRENCY],
  738.                     'EX(€ netto)' => [round($details[JobCalcItem::Extra],2) , ExcelExportHelper::XTYPE_CURRENCY],
  739.                     ///////
  740.                     'Posten' => '',
  741.                     'Menge' => '',
  742.                     'Einzelpreis'=>'',
  743.                     'MwSt.'=>'',
  744.                     'Summe'=>'',
  745.                 ],
  746.                 self::$bold
  747.             );
  748.             return;
  749.         }
  750.         $xh->addRow([
  751.             "Menge" =>    $item->quantity,
  752.             "Einzelpreis" => [round($item->amount,2),ExcelExportHelper::XTYPE_CURRENCY],
  753.             "MwSt."   =>  sprintf('%d %%',$item->vat*100),
  754.             "Summe" =>  [round($item->totalNet,2),ExcelExportHelper::XTYPE_CURRENCY],
  755.             "Posten"  => $item->name
  756.         ]);
  757.     }
  759.     public function xlsAction(Request $request, string $tempDir, $id)
  760.     {
  761.         $this->init();
  762.         $repo = $this->managerRegistry->getRepository(Document::class);
  763.         /** @var Document $row */
  764.         $row = $repo->findOneBy(['id' =>$id]);
  765.         if (!is_object($row))
  766.         {
  767.             $this->addFlash('warning','Ungültige ID oder Zugriff verweigert.');
  768.             return $this->redirectToRoute('acc-billing-edit',['id'=>$id]);
  769.         }
  770.         if ($row->getType()!==Document::TYPE_RECHNUNG)
  771.         {
  772.             $this->addFlash('warning','XLS nur für Rechnungen verfügbar.');
  773.             return $this->redirectToRoute('acc-billing-edit',['id'=>$id]);
  774.         }
  775.         if ($row->getBilling() === null)
  776.         {
  777.             $this->addFlash('warning','Es sind keine Fahrtabrechnungsdaten verknüpft !');
  778.             return $this->redirectToRoute('acc-billing-edit',['id'=>$id]);
  779.         }
  781.         $xh = new ExcelExportHelper();
  782.         ExcelExportHelper::$xlsHeadStyle['borders'] = array('bottom' => ['style' => PHPExcel_Style_Border::BORDER_THIN]);
  783.         $sheetTitle = sprintf("%s zu %s %s im Leistungsmonat %02d/%4d\n\n",
  784.             "Beiblatt",
  785.             Document::$typeMap[$row->getType()],
  786.             $row->getNumber(),
  787.             $row->getAccountingMonth(),$row->getAccountingYear());
  788.         $xh->setSingleSheetMode('Beiblatt Rechnung '.$row->getNumber());
  789.         $xh->addIndexedRow($sheetTitle,self::$bold);
  790.         $xh->addIndexedRow('');
  791.         $xh->addIndexedRow('');
  793.         //////////////////////////////////////////////////////
  794.         foreach ($row->getBilling()->getJobList() as $j) {
  795.             if ($j->isIgnoreForCustomer()) {
  796.                 continue;
  797.             }
  798.             $items = $j->getCalcItemsFor($row->getBilling()->getType());
  799.             $this->xlsLine($xh, $j);
  800.             foreach ($items as $it) {
  801.                 $this->xlsLine($xh, $j, $it);
  802.             }
  803.         }
  804.         //////////////////////////////////////////////////////////////////
  805.         $tempFn = $tempDir . uniqid("export",true) . ".xlsx";
  806.         $outFn = $row->getNumber()."_".date('Y-m-d_H-i-s').'.' .$xh->getExtension();
  807.         $xh->saveTo($tempFn);
  808.         $resp = new BinaryFileResponse( $tempFn);
  809.         $resp->setContentDisposition(
  810.             ResponseHeaderBag::DISPOSITION_ATTACHMENT,
  811.             $outFn
  812.         );
  813.         return $resp;
  814.     }
  816.     public function newAction(Request $request, $type)
  817.     {
  818.         $this->init();
  819.         $this->ensureUserHasRole(Role::ACCOUNTING_EDIT);
  820.         $em = $this->managerRegistry->getManager();
  821.         $dor = $em->getRepository(Document::class);
  823.         // default doc
  824.         $D = new Document();
  825.         $D->setAccountingMonth(date('m'));
  826.         $D->setAccountingYear(date('Y'));
  827.         $D->setType(  $type );
  828.         $D->setTotalNet(0);
  829.         $D->setBilling(null);
  830.         $D->setDate( new \DateTime());
  832.         $cloneFrom = $request->query->get('cloneFrom', null);
  833.         $clonedFrom = null;
  834.         // fetch if copy is wanted
  835.         if (!empty($cloneFrom))
  836.         {
  837.             $clonedFrom = $dor->findOneBy(['id' =>$cloneFrom]);
  838.             if (!is_object($clonedFrom))
  839.             {
  840.                 $this->addFlash('warning','Ungültige ID oder Zugriff verweigert.');
  841.                 return $this->redirectToRoute('acc-billing-edit',['id'=>$id]);
  842.             }
  843.             $D = clone $clonedFrom;
  844.         }
  845.         // set user
  846.         $D->setTreatedBy($this->getCurrentUser());
  848.         $form = $this->createForm(NewDocumentForm::class,$D,[
  849.             NewDocumentForm::OPT_BDS => $this->hasUserRole(Role::BEREITSCHAFTSDISPO)
  850.         ]);
  851.         $form->handleRequest($request);
  852.         if ($form->isSubmitted())
  853.         {
  854.             if ((($D->getMember()!==null) xor ($D->getCustomer()!==null))!==true)
  855.             {
  856.                 $this->addFlash('warning','Bitte entweder einen Kunden oder ein Mitglied auswählen');
  857.                 $form->get('customer')->addError(new FormError('Auswahl nötig'));
  858.                 $form->get('member')->addError(new FormError('Auswahl nötig'));
  859.             }
  861.             if ($form->isValid())
  862.             {
  863.                 $D->setNumber( $dor->getNewDocumentNumber($D->getType(), $D->getDate()));
  864.                 $address='';
  865.                 if ($D->getMember()!==null)
  866.                     $address = $D->getMember()->getAddress();
  867.                 elseif ($D->getCustomer()!==null)
  868.                     $address = $D->getCustomer()->getInvoiceAddress();
  870.                 $D->setReceiverAddress($address);
  871.                 if ($D->getType()===Document::TYPE_RECHNUNG)
  872.                 {
  873.                     $ht = $D->getCustomer()!==null ? trim($D->getCustomer()->getPdfDefaultHeader()):'';
  874.                     if (empty($ht)) $ht = "Sehr geehrte Damen und Herren,\ndie in Ihrem Auftrag durchgeführten Leistungen berechnen wir wie folgt:";
  875.                     $D->setHeaderText($ht);
  876.                     $ft = $D->getCustomer()!==null ? trim($D->getCustomer()->getPdfDefaultFooter()):'';
  877.                     if (empty($ft)) $ft = 'Bitte überweisen Sie den Rechnungsbetrag ohne Abzug innerhalb von 14 Tagen. Geben Sie bei Zahlungen bitte Ihre Kundennummer und die Rechnungsnummer an.';
  878.                     $D->setFooterText($ft);
  879.                 }
  880.                 else
  881.                     if ($D->getType()===Document::TYPE_GUTSCHRIFT)
  882.                     {
  883.                         $D->setFooterText(sprintf("Der Gutschriftsbetrag wird auf Ihr bekanntes Konto überwiesen: %s ",$D->getMember()->getAccountingBankAccount()));
  884.                     }
  886.                 if ($form->get('standByDispo')->getViewData() && ($D->getCustomer()!==null))
  887.                 {
  888.                     $jdd = [];
  889.                     $rr = $this->managerRegistry->getRepository(StandByDispoEntry::class);
  890.                     /** @var StandByDispoEntry[] $data */
  891.                     $data = $rr->findFor($D->getCustomer()->getId(),$D->getAccountingYear(),$D->getAccountingMonth());
  892.                     foreach ($data as $d)
  893.                     {
  894.                         $jdd[ $d->getDate()->format('Y-m-d') ] = [
  895.                             "time" => $d->getMatrix(),
  896.                             "comment" => $d->getCommentMatrix()
  897.                         ];
  898.                     }
  899.                     $D->setStandByDispoData($jdd);
  900.                     $sum = array_sum(
  901.                         array_map(function($el) {
  902.                             return array_sum($el["time"]);
  903.                         },$jdd)
  904.                     );
  905.                     $JC = new JobCalcItem();
  906.                     $JC->shortCode = JobCalcItem::Extra;
  907.                     $JC->name = sprintf("Bereitschaftsdisposition");
  908.                     $JC->category = JobCalcItem::Extra;
  909.                     $JC->quantity = 1;
  910.                     $JC->amount =  round($sum * 0.4666666666666667,2);
  911.                     $JC->totalNet = round($JC->quantity * $JC->amount,2);
  912.                     $JC->vat = JobCalcItem::defaultVat();
  913.                     $D->setExtraCalculationItems([$JC]);
  914.                     $D->setTotalNet($JC->totalNet);
  915.                 }
  917.                 $em->persist($D);
  918.                 $em->flush();
  919.                 return $this->redirectToRoute("acc-billing-edit",['id'=>$D->getId()]);
  920.             }
  921.             $this->addFlash('warning','Bitte überprüfen Sie Ihre Eingabe');
  922.         }
  924.         return $this->render('@DiplixKMG/Accounting/Billing/new.html.twig',[
  925.             'form'=>$form->createView(),
  926.             'type'=>$type,
  927.             'typeMap'=>Document::$typeMap,
  928.             "clonedFrom" => $clonedFrom
  929.         ]);
  930.     }
  932. }