src/Controller/CashBox/DailyFinancialStatementController.php line 102

Open in your IDE?
  1. <?php
  3. namespace App\Controller\CashBox;
  5. use App\Entity\Cashbox;
  6. use App\Entity\CashboxCounting;
  7. use App\Entity\CashboxDeposit;
  8. use App\Entity\CashboxPaymentToSupplier;
  9. use App\Entity\CashboxWithdrawal;
  10. use App\Entity\Company;
  11. use App\Entity\DailyFinancialStatement;
  12. use App\Entity\DailyFinancialStatementCashbox;
  13. use App\Entity\DailyFinancialStatementCashboxDeposit;
  14. use App\Entity\DailyFinancialStatementCashboxPaymentToSupplier;
  15. use App\Entity\DailyFinancialStatementCashboxWithdrawal;
  16. use App\Entity\DailyFinancialStatementCounting;
  17. use App\Entity\DailyFinancialStatementLocation;
  18. use App\Entity\Location;
  19. use App\Entity\Receipt;
  20. use App\Repository\CashboxRepository;
  21. use App\Repository\CompanyRepository;
  22. use App\Repository\DailyFinancialStatementRepository;
  23. use App\Repository\ReceiptRepository;
  24. use App\Service\CashBox\CashboxService;
  25. use App\Service\CashBox\DailyFinancialStatementService;
  26. use App\Service\CashBox\ReceiptService;
  27. use App\Service\TimeZoneDetectionService;
  28. use App\Structure\Fiskaly\CashPointClosingHeadStructure;
  29. use App\Structure\Fiskaly\CashPointClosingStructure;
  30. use Doctrine\ORM\EntityManagerInterface;
  31. use Dompdf\Dompdf;
  32. use Dompdf\Options;
  33. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  34. use Symfony\Component\HttpFoundation\JsonResponse;
  35. use Symfony\Component\HttpFoundation\Request;
  36. use Symfony\Component\HttpFoundation\Session\SessionInterface;
  37. use Symfony\Component\Routing\Annotation\Route;
  38. use Symfony\Component\VarDumper\Cloner\VarCloner;
  39. use Symfony\Component\VarDumper\Dumper\CliDumper;
  42. /**
  43.  * @Route("/daily_financial_statement")
  44.  */
  45. class DailyFinancialStatementController extends AbstractController
  46. {
  48.     private EntityManagerInterface $entity_manager;
  49.     private SessionInterface $session;
  50.     private ReceiptRepository $receipt_repository;
  51.     private DailyFinancialStatementRepository $daily_financial_statement_repository;
  52.     private CompanyRepository $company_repository;
  53.     private CashboxService $cashbox_service;
  54.     private DailyFinancialStatementService $daily_financial_statement_service;
  55.     private TimeZoneDetectionService $timeZoneDetectionService;
  56.     private ReceiptService $receipt_service;
  58.     public function __construct(EntityManagerInterface $entity_manager, SessionInterface $session, ReceiptRepository $receipt_repository, DailyFinancialStatementRepository $daily_financial_statement_repository, CompanyRepository $company_repository, CashboxRepository $cashbox_repository, CashboxService $cashbox_service, DailyFinancialStatementService $daily_financial_statement_service, TimeZoneDetectionService $timeZoneDetectionService, ReceiptService $receipt_service)
  59.     {
  60.         $this->entity_manager = $entity_manager;
  61.         $this->session = $session;
  62.         $this->receipt_repository = $receipt_repository;
  63.         $this->daily_financial_statement_repository = $daily_financial_statement_repository;
  64.         $this->company_repository = $company_repository;
  65.         $this->cashbox_repository = $cashbox_repository;
  66.         $this->cashbox_service = $cashbox_service;
  67.         $this->daily_financial_statement_service = $daily_financial_statement_service;
  68.         $this->timeZoneDetectionService = $timeZoneDetectionService;
  69.         $this->receipt_service = $receipt_service;
  70.     }
  72.     /**
  73.      * @Route("/", name="daily_financial_statement", methods={"GET","POST"})
  74.      */
  75.     public function index()
  76.     {
  77.         return new JsonResponse([]);
  78.     }
  80.     /**
  81.      * @Route("/load/{id}", name="load_daily_financial_statement", methods={"GET","POST"})
  82.      */
  83.     public function load(Request $request, DailyFinancialStatement $dailyFinancialStatement)
  84.     {
  85.         $_dailyFinancialStatement = [
  86.             'id' => $dailyFinancialStatement->getId(),
  87.             'start_date' => $dailyFinancialStatement->getStartDate()->format("d.m.Y / H:i"),
  88.             'end_date' => $dailyFinancialStatement->getEndDate()->format("d.m.Y / H:i"),
  89.             'cashbox_start_value' => ($dailyFinancialStatement->getCashboxStartValue() ?? 0.00),
  90.             'cashbox_end_value' => ($dailyFinancialStatement->getCashboxEndValue() ?? 0.00),
  91.             'deposit_total' => ($dailyFinancialStatement->getDeposits() ?? 0.00),
  92.             'withdrawal_total' => ($dailyFinancialStatement->getWithdrawals() ?? 0.00),
  93.             'payment_to_supplier_total' => ($dailyFinancialStatement->getPaymentsToSuppliers() ?? 0.00),
  94.             'card_payment' => ($dailyFinancialStatement->getCardPayment() ?? 0.00),
  95.         ];
  96.         return new JsonResponse(['_success' => true, 'daily_financial_statement' => $_dailyFinancialStatement]);
  97.     }
  99.     /**
  100.      * @Route("/loadprint/{id}", name="loadprint_daily_financial_statement", methods={"GET","POST"})
  101.      */
  102.     public function loadPrint_(Request $request, DailyFinancialStatement $daily_financial_statement)
  103.     {
  104.         if ($daily_financial_statement->getManually() === true) {
  105.             $cashbox_deposit_total = $daily_financial_statement->getDeposits();
  106.             $cashbox_withdrawal_total = $daily_financial_statement->getWithdrawals();
  107.             $cashbox_payments_to_supplier_total = $daily_financial_statement->getPaymentsToSuppliers();
  108.         } else {
  109.             $cashbox_deposit_total = $this->daily_financial_statement_service->getDepositTotal($daily_financial_statement);
  110.             $cashbox_withdrawal_total = $this->daily_financial_statement_service->getWithdrawalTotal($daily_financial_statement);
  111.             $cashbox_payments_to_supplier_total = $this->daily_financial_statement_service->getPaymentToSupplierTotal($daily_financial_statement);
  112.         }
  114.         $daily_financial_statement_ = [
  115.             'company' => [
  116.                 'address_addition' => null,
  117.                 'address_country' => null,
  118.                 'address_locality' => null,
  119.                 'email' => null,
  120.                 'fax_number' => null,
  121.                 'id' => null,
  122.                 'line_1' => null,
  123.                 'line_2' => null,
  124.                 'logo' => null,
  125.                 'name' => null,
  126.                 'postal_code' => null,
  127.                 'street_address' => null,
  128.                 'tax_number' => null,
  129.                 'telephone' => null,
  130.                 'vat_id' => null,
  131.                 'website' => null,
  132.             ],
  133.             'cashbox' => [
  134.                 'id' => null,
  135.                 'cashbox_id' => null,
  136.                 'name' => null,
  137.                 'comment' => null,
  138.                 'locked' => null,
  139.                 'serial_number' => null,
  140.             ],
  141.             'location' => [
  142.                 'id' => null,
  143.                 'location_id' => null,
  144.                 'name' => null,
  145.                 'logo' => null,
  146.                 'street_address' => null,
  147.                 'postal_code' => null,
  148.                 'address_locality' => null,
  149.                 'address_addition' => null,
  150.                 'address_country' => null,
  151.                 'telephone' => null,
  152.                 'website' => null,
  153.                 'email' => null,
  154.                 'fax_number' => null,
  155.                 'show_address_on_receipt' => null,
  156.                 'show_contact_on_receipt' => null,
  157.             ],
  158.             'daily_financial_statement' => [
  159.                 'id' => null,
  160.                 'cashbox_start_value' => 0,
  161.                 'cashbox_start_value_f' => 0,
  162.                 'cashbox_end_value' => 0,
  163.                 'cashbox_end_value_f' => 0,
  164.                 'receipt_value' => 0,
  165.                 'receipt_value_f' => 0,
  166.                 'start_date' => null,
  167.                 'start_date_f' => null,
  168.                 'start_date_f_y' => null,
  169.                 'start_date_f_m' => null,
  170.                 'start_date_f_d' => null,
  171.                 'start_date_f_h' => null,
  172.                 'start_date_f_i' => null,
  173.                 'start_date_f_s' => null,
  174.                 'end_date' => null,
  175.                 'end_date_f' => null,
  176.                 'end_date_f_y' => null,
  177.                 'end_date_f_m' => null,
  178.                 'end_date_f_d' => null,
  179.                 'end_date_f_h' => null,
  180.                 'end_date_f_i' => null,
  181.                 'end_date_f_s' => null,
  182.                 'deposit_total' => 0,
  183.                 'deposit_total_f' => 0,
  184.                 'withdrawal_total' => 0,
  185.                 'withdrawal_total_f' => 0,
  186.                 'payment_to_supplier_total' => 0,
  187.                 'payment_to_supplier_total_f' => 0,
  188.                 'card_payment' => 0,
  189.                 'card_payment_f' => 0,
  190.                 'manually' => false,
  191.             ],
  192.             'cashbox_counting' => [
  193.                 'counting' => [],
  194.                 'counting_total' => [],
  195.                 'total' => 0,
  196.                 'total_f' => 0,
  197.             ],
  198.             'receipt_cash' => 0,
  199.             'noreceipt_cash' => 0,
  200.             'cash_debit' => 0,
  201.             'receipt_count' => 0,
  202.             'tax' => [],
  205.             'gezaehlt' => (float)0,
  206.             'soll' => (float)0,
  207.             'differenz' => (float)0,
  208.             'zbonnr' => 0,
  209.             'anfangsbestand' => (float)0,
  210.             'einlagen' => (float)0,
  211.             'entnahmen' => (float)0,
  212.             'zahlungen_an_lieferanten' => (float)0,
  213.             'position_count' => 0,
  214.             'anzahl_bon_stornos' => 0,
  215.             'verkaufte_gutscheine' => 0,
  216.             'receipt_value_average' => (float)0,
  217.             'bar' => (float)0,
  218.             'ec_karte' => (float)0,
  219.             'kreditkarte' => (float)0,
  220.             'auf_rechnung_gezahlt' => (float)0,
  221.             'group_by_payment_method' => [],
  222.             'receipt_total' => (float)0,
  223.             'bankeinzahlungen' => (float)0,
  224.             'bar_differenzen' => (float)0,
  225.             'wechselgeldvortrag' => (float)0,
  226.             'zahlungen_von_kunden_rechnungen' => (float)0,
  227.             'geleistete_anzahlungen_auf_kassenauftraege' => (float)0,
  228.             'summe_retourenpositionen' => (float)0,
  229.             'eingeloeste_gutscheine' => (float)0,
  230.             'gutschein_aus_guthaben' => (float)0,
  231.             'verrechnete_anzahlungen' => (float)0,
  232.             'verrechnete_gutschriften' => (float)0,
  233.         ];
  234.         $daily_financial_statement_['soll_f'] = number_format($daily_financial_statement_['soll'], 2, '•', '');
  235.         $daily_financial_statement_['differenz_f'] = number_format($daily_financial_statement_['differenz'], 2, '•', '');
  236.         $daily_financial_statement_['anfangsbestand_f'] = number_format($daily_financial_statement_['anfangsbestand'], 2, '•', '');
  237.         $daily_financial_statement_['einlagen_f'] = number_format($daily_financial_statement_['einlagen'], 2, '•', '');
  238.         $daily_financial_statement_['entnahmen_f'] = number_format($daily_financial_statement_['entnahmen'], 2, '•', '');
  239.         $daily_financial_statement_['zahlungen_an_lieferanten_f'] = number_format($daily_financial_statement_['zahlungen_an_lieferanten'], 2, '•', '');
  240.         $daily_financial_statement_['receipt_cash_f'] = number_format($daily_financial_statement_['receipt_cash'], 2, '•', '');
  241.         $daily_financial_statement_['cash_debit_f'] = number_format($daily_financial_statement_['cash_debit'], 2, '•', '');
  242.         $daily_financial_statement_['receipt_value_average_f'] = number_format($daily_financial_statement_['receipt_value_average'], 2, '•', '');
  243.         $daily_financial_statement_['bar_f'] = number_format($daily_financial_statement_['bar'], 2, '•', '');
  244.         $daily_financial_statement_['ec_karte_f'] = number_format($daily_financial_statement_['ec_karte'], 2, '•', '');
  245.         $daily_financial_statement_['kreditkarte_f'] = number_format($daily_financial_statement_['kreditkarte'], 2, '•', '');
  246.         $daily_financial_statement_['auf_rechnung_gezahlt_f'] = number_format($daily_financial_statement_['auf_rechnung_gezahlt'], 2, '•', '');
  247.         $daily_financial_statement_['receipt_total_f'] = number_format($daily_financial_statement_['receipt_total'], 2, '•', '');
  248.         $daily_financial_statement_['bankeinzahlungen_f'] = number_format($daily_financial_statement_['bankeinzahlungen'], 2, '•', '');
  249.         $daily_financial_statement_['bar_differenzen_f'] = number_format($daily_financial_statement_['bar_differenzen'], 2, '•', '');
  250.         $daily_financial_statement_['wechselgeldvortrag_f'] = number_format($daily_financial_statement_['wechselgeldvortrag'], 2, '•', '');
  251.         $daily_financial_statement_['zahlungen_von_kunden_rechnungen_f'] = number_format($daily_financial_statement_['zahlungen_von_kunden_rechnungen'], 2, '•', '');
  252.         $daily_financial_statement_['geleistete_anzahlungen_auf_kassenauftraege_f'] = number_format($daily_financial_statement_['geleistete_anzahlungen_auf_kassenauftraege'], 2, '•', '');
  253.         $daily_financial_statement_['summe_retourenpositionen_f'] = number_format($daily_financial_statement_['summe_retourenpositionen'], 2, '•', '');
  254.         $daily_financial_statement_['eingeloeste_gutscheine_f'] = number_format($daily_financial_statement_['eingeloeste_gutscheine'], 2, '•', '');
  255.         $daily_financial_statement_['gutschein_aus_guthaben_f'] = number_format($daily_financial_statement_['gutschein_aus_guthaben'], 2, '•', '');
  256.         $daily_financial_statement_['verrechnete_anzahlungen_f'] = number_format($daily_financial_statement_['verrechnete_anzahlungen'], 2, '•', '');
  257.         $daily_financial_statement_['verrechnete_gutschriften_f'] = number_format($daily_financial_statement_['verrechnete_gutschriften'], 2, '•', '');
  259.         $company = $this->company_repository->findOneBy(['id' => 1]);
  260.         if ($company instanceof Company) {
  261.             $daily_financial_statement_['company'] = [
  262.                 'address_addition' => $company->getAddressAddition(),
  263.                 'address_country' => $company->getAddressCountry(),
  264.                 'address_locality' => $company->getAddressLocality(),
  265.                 'email' => $company->getEmail(),
  266.                 'fax_number' => $company->getFaxNumber(),
  267.                 'id' => $company->getId(),
  268.                 'line_1' => $company->getLine1(),
  269.                 'line_2' => $company->getLine2(),
  270.                 'logo' => $company->getLogo(),
  271.                 'name' => $company->getName(),
  272.                 'postal_code' => $company->getPostalCode(),
  273.                 'street_address' => $company->getStreetAddress(),
  274.                 'tax_number' => $company->getTaxNumber(),
  275.                 'telephone' => $company->getTelephone(),
  276.                 'vat_id' => $company->getVatId(),
  277.                 'website' => $company->getWebsite(),
  278.             ];
  279.         }
  280.         $dailyFinancialStatementCashbox = $daily_financial_statement->getDailyFinancialStatementCashbox();
  281.         if ($dailyFinancialStatementCashbox instanceof DailyFinancialStatementCashbox) {
  282.             $daily_financial_statement_['cashbox'] = [
  283.                 'id' => $dailyFinancialStatementCashbox->getId(),
  284.                 'cashbox_id' => null,
  285.                 'name' => $dailyFinancialStatementCashbox->getName(),
  286.                 'comment' => $dailyFinancialStatementCashbox->getComment(),
  287.                 'locked' => $dailyFinancialStatementCashbox->getLocked(),
  288.                 'serial_number' => $dailyFinancialStatementCashbox->getSerialNumber(),
  289.             ];
  290.             if ($dailyFinancialStatementCashbox->getCashbox() instanceof Cashbox) {
  291.                 $daily_financial_statement_['cashbox']['cashbox_id'] = $dailyFinancialStatementCashbox->getCashbox()->getId();
  292.             }
  293.             $dailyFinancialStatementLocation = $dailyFinancialStatementCashbox->getDailyFinancialStatementLocation();
  294.             if ($dailyFinancialStatementLocation instanceof DailyFinancialStatementLocation) {
  295.                 $daily_financial_statement_['location'] = [
  296.                     'id' => $dailyFinancialStatementLocation->getId(),
  297.                     'location_id' => null,
  298.                     'name' => $dailyFinancialStatementLocation->getName(),
  299.                     'logo' => $dailyFinancialStatementLocation->getLogo(),
  300.                     'street_address' => $dailyFinancialStatementLocation->getStreetAddress(),
  301.                     'postal_code' => $dailyFinancialStatementLocation->getPostalCode(),
  302.                     'address_locality' => $dailyFinancialStatementLocation->getAddressLocality(),
  303.                     'address_addition' => $dailyFinancialStatementLocation->getAddressAddition(),
  304.                     'address_country' => $dailyFinancialStatementLocation->getAddressCountry(),
  305.                     'telephone' => $dailyFinancialStatementLocation->getTelephone(),
  306.                     'website' => $dailyFinancialStatementLocation->getWebsite(),
  307.                     'email' => $dailyFinancialStatementLocation->getEmail(),
  308.                     'fax_number' => $dailyFinancialStatementLocation->getFaxNumber(),
  309.                     'show_address_on_receipt' => $dailyFinancialStatementLocation->getShowAddressOnReceipt(),
  310.                     'show_contact_on_receipt' => $dailyFinancialStatementLocation->getShowContactOnReceipt(),
  311.                 ];
  312.                 if ($dailyFinancialStatementLocation->getLocation() instanceof Location) {
  313.                     $daily_financial_statement_['location']['location_id'] = $dailyFinancialStatementLocation->getLocation()->getId();
  314.                 }
  315.             }
  316.             $daily_financial_statement__ = [
  317.                 'id' => $daily_financial_statement->getId(),
  318.                 'cashbox_start_value' => ($daily_financial_statement->getCashboxStartValue() ?? 0),
  319.                 'cashbox_start_value_f' => ($daily_financial_statement->getCashboxStartValue() ?? 0),
  320.                 'cashbox_end_value' => ($daily_financial_statement->getCashboxEndValue() ?? 0),
  321.                 'cashbox_end_value_f' => ($daily_financial_statement->getCashboxEndValue() ?? 0),
  322.                 'receipt_value' => ($daily_financial_statement->getReceiptValue() ?? 0),
  323.                 'receipt_value_f' => ($daily_financial_statement->getReceiptValue() ?? 0),
  324.                 'start_date' => $daily_financial_statement->getStartDate(),
  325.                 'start_date_f' => $daily_financial_statement->getStartDate(),
  326.                 'start_date_f_y' => $daily_financial_statement->getStartDate(),
  327.                 'start_date_f_m' => $daily_financial_statement->getStartDate(),
  328.                 'start_date_f_d' => $daily_financial_statement->getStartDate(),
  329.                 'start_date_f_h' => $daily_financial_statement->getStartDate(),
  330.                 'start_date_f_i' => $daily_financial_statement->getStartDate(),
  331.                 'start_date_f_s' => $daily_financial_statement->getStartDate(),
  332.                 'end_date' => $daily_financial_statement->getEndDate(),
  333.                 'end_date_f' => $daily_financial_statement->getEndDate(),
  334.                 'end_date_f_y' => $daily_financial_statement->getEndDate(),
  335.                 'end_date_f_m' => $daily_financial_statement->getEndDate(),
  336.                 'end_date_f_d' => $daily_financial_statement->getEndDate(),
  337.                 'end_date_f_h' => $daily_financial_statement->getEndDate(),
  338.                 'end_date_f_i' => $daily_financial_statement->getEndDate(),
  339.                 'end_date_f_s' => $daily_financial_statement->getEndDate(),
  340.                 'deposit_total' => $cashbox_deposit_total,
  341.                 'deposit_total_f' => $cashbox_deposit_total,
  342.                 'withdrawal_total' => $cashbox_withdrawal_total,
  343.                 'withdrawal_total_f' => $cashbox_withdrawal_total,
  344.                 'payment_to_supplier_total' => $cashbox_payments_to_supplier_total,
  345.                 'payment_to_supplier_total_f' => $cashbox_payments_to_supplier_total,
  346.                 'card_payment' => ($daily_financial_statement->getCardPayment() ?? 0),
  347.                 'card_payment_f' => ($daily_financial_statement->getCardPayment() ?? 0),
  348.                 'manually' => $daily_financial_statement->getManually(),
  349.             ];
  350.             $daily_financial_statement__['cashbox_start_value_f'] = number_format(round((float)$daily_financial_statement__['cashbox_start_value_f'], 2), 2, '•', '');
  351.             $daily_financial_statement__['cashbox_end_value_f'] = number_format(round((float)($daily_financial_statement__['cashbox_end_value_f'] / 100), 2), 2, '•', '');
  352.             $daily_financial_statement__['receipt_value_f'] = number_format(round((float)$daily_financial_statement__['receipt_value_f'], 2), 2, '•', '');
  353.             $daily_financial_statement__['deposit_total_f'] = number_format(round((float)$daily_financial_statement__['deposit_total_f'], 2), 2, '•', '');
  354.             $daily_financial_statement__['withdrawal_total_f'] = number_format(round((float)$daily_financial_statement__['withdrawal_total_f'], 2), 2, '•', '');
  355.             $daily_financial_statement__['payment_to_supplier_total_f'] = number_format(round((float)$daily_financial_statement__['payment_to_supplier_total_f'], 2), 2, '•', '');
  356.             $daily_financial_statement__['card_payment_f'] = number_format(round((float)$daily_financial_statement__['card_payment_f'], 2), 2, '•', '');
  357.             $daily_financial_statement__['start_date_f'] = $daily_financial_statement__['start_date_f']->format("d.m.Y / H:i:s");
  358.             $daily_financial_statement__['start_date_f_y'] = $daily_financial_statement__['start_date_f_y']->format("Y");
  359.             $daily_financial_statement__['start_date_f_m'] = $daily_financial_statement__['start_date_f_m']->format("m");
  360.             $daily_financial_statement__['start_date_f_d'] = $daily_financial_statement__['start_date_f_d']->format("d");
  361.             $daily_financial_statement__['start_date_f_h'] = $daily_financial_statement__['start_date_f_h']->format("H");
  362.             $daily_financial_statement__['start_date_f_i'] = $daily_financial_statement__['start_date_f_i']->format("i");
  363.             $daily_financial_statement__['start_date_f_s'] = $daily_financial_statement__['start_date_f_s']->format("s");
  364.             $daily_financial_statement__['end_date_f'] = $daily_financial_statement__['end_date_f']->format("d.m.Y / H:i:s");
  365.             $daily_financial_statement__['end_date_f_y'] = $daily_financial_statement__['end_date_f_y']->format("Y");
  366.             $daily_financial_statement__['end_date_f_m'] = $daily_financial_statement__['end_date_f_m']->format("m");
  367.             $daily_financial_statement__['end_date_f_d'] = $daily_financial_statement__['end_date_f_d']->format("d");
  368.             $daily_financial_statement__['end_date_f_h'] = $daily_financial_statement__['end_date_f_h']->format("H");
  369.             $daily_financial_statement__['end_date_f_i'] = $daily_financial_statement__['end_date_f_i']->format("i");
  370.             $daily_financial_statement__['end_date_f_s'] = $daily_financial_statement__['end_date_f_s']->format("s");
  372.             $daily_financial_statement_['daily_financial_statement'] = $daily_financial_statement__;
  374.             if ($daily_financial_statement->getManually() === false) {
  375.                 $countings = $daily_financial_statement->getDailyFinancialStatementCountings();
  376.                 if ($countings->count() > 0) {
  377.                     foreach ($countings as $counting) {
  378.                         $daily_financial_statement_['cashbox_counting']['counting'][$counting->getFactor()] = $counting->getAmount();
  379.                         $daily_financial_statement_['cashbox_counting']['counting_total'][$counting->getFactor()] = [
  380.                             'total' => ($counting->getFactor() * $counting->getAmount()),
  381.                             'total_f' => number_format(round((float)(($counting->getFactor() * $counting->getAmount()) / 100), 2), 2, '•', ''),
  382.                         ];
  383.                         $daily_financial_statement_['cashbox_counting']['total'] += ($counting->getFactor() * $counting->getAmount());
  384.                     }
  385.                     $daily_financial_statement_['cashbox_counting']['total_f'] = number_format(round((float)($daily_financial_statement_['cashbox_counting']['total'] / 100), 2), 2, '•', '');
  386.                 }
  387.             }
  389.             $receipt_container = $daily_financial_statement->getReceipts();
  390.             if ($receipt_container->count() > 0) {
  391.                 $tax = ['total' => [], 'cash' => [], 'nocash' => []];
  392.                 $position_count = 0;
  393.                 $receipt_totals = 0;
  394.                 $group_by_payment_method = [];
  395.                 $group_by_cash_nocash = ['cash' => 0, 'nocash' => 0];
  396.                 foreach ($receipt_container as $receipt) {
  397.                     if ($receipt->getCanceled() === true || $receipt->getReversalReceipt() === true) {
  398.                         //Do nothing
  399.                     } else {
  400.                         $base_receipt = $receipt;
  401.                         if ($receipt->getReversalReceipt() === true) {
  402.                             $receipt_ = $this->receipt_service->getReceiptFromReversalReceipt($receipt);
  403.                             if ($receipt_ !== false) {
  404.                                 $base_receipt = $receipt_;
  405.                             }
  406.                         }
  407.                         if ($daily_financial_statement->getManually() === false) {
  408.                             if ($receipt->getReversalReceipt() === true) {
  409.                                 $position_count -= $base_receipt->getReceiptCartProducts()->count();
  410. //                            $receipt_totals += 0-$receipt->getCartTotalFixed();
  411.                                 $receipt_totals -= $base_receipt->getTotalFixed();
  412.                             } else {
  413.                                 $position_count += $base_receipt->getReceiptCartProducts()->count();
  414. //                            $receipt_totals += $receipt->getCartTotalFixed();
  415.                                 $receipt_totals += $base_receipt->getTotalFixed();
  416.                             }
  417.                             $receipt_transaction = $receipt->getReceiptTransactions()->last();
  418.                             $receipt_cart_products = $receipt->getReceiptCartProducts();
  419.                             foreach ($receipt_cart_products as $receipt_cart_product) {
  420.                                 $receipt_product = $receipt_cart_product->getReceiptProduct();
  421.                                 if (!isset($tax['total'][$receipt_product->getReceiptTax()->getReceiptTax()])) {
  422.                                     $tax['total'][$receipt_product->getReceiptTax()->getReceiptTax()] = ['total' => 0, 'total_f' => 0, 'total_notax' => 0, 'total_notax_f' => 0, 'total_tax' => 0, 'total_tax_f' => 0];
  423.                                 }
  424.                                 if (!isset($tax['cash'][$receipt_product->getReceiptTax()->getReceiptTax()])) {
  425.                                     $tax['cash'][$receipt_product->getReceiptTax()->getReceiptTax()] = ['total' => 0, 'total_f' => 0, 'total_notax' => 0, 'total_notax_f' => 0, 'total_tax' => 0, 'total_tax_f' => 0];
  426.                                 }
  427.                                 if (!isset($tax['nocash'][$receipt_product->getReceiptTax()->getReceiptTax()])) {
  428.                                     $tax['nocash'][$receipt_product->getReceiptTax()->getReceiptTax()] = ['total' => 0, 'total_f' => 0, 'total_notax' => 0, 'total_notax_f' => 0, 'total_tax' => 0, 'total_tax_f' => 0];
  429.                                 }
  430.                                 if ($receipt->getReversalReceipt() === true) {
  431.                                     $tax['total'][$receipt_product->getReceiptTax()->getReceiptTax()]['total'] -= $receipt_cart_product->getTotalFixed();
  432.                                     $tax['total'][$receipt_product->getReceiptTax()->getReceiptTax()]['total_notax'] -= $receipt_cart_product->getTotalOtaxFixed();
  433.                                     $tax['total'][$receipt_product->getReceiptTax()->getReceiptTax()]['total_tax'] -= ($receipt_cart_product->getTotalFixed() - $receipt_cart_product->getTotalOtaxFixed());
  434.                                 } else {
  435.                                     $tax['total'][$receipt_product->getReceiptTax()->getReceiptTax()]['total'] += $receipt_cart_product->getTotalFixed();
  436.                                     $tax['total'][$receipt_product->getReceiptTax()->getReceiptTax()]['total_notax'] += $receipt_cart_product->getTotalOtaxFixed();
  437.                                     $tax['total'][$receipt_product->getReceiptTax()->getReceiptTax()]['total_tax'] += ($receipt_cart_product->getTotalFixed() - $receipt_cart_product->getTotalOtaxFixed());
  438.                                 }
  439.                                 $tax['total'][$receipt_product->getReceiptTax()->getReceiptTax()]['total_f'] = number_format(round((float)$tax['total'][$receipt_product->getReceiptTax()->getReceiptTax()]['total'], 2), 2, '•', '');
  440.                                 $tax['total'][$receipt_product->getReceiptTax()->getReceiptTax()]['total_notax_f'] = number_format(round((float)$tax['total'][$receipt_product->getReceiptTax()->getReceiptTax()]['total_notax'], 2), 2, '•', '');
  441.                                 $tax['total'][$receipt_product->getReceiptTax()->getReceiptTax()]['total_tax_f'] = number_format(round((float)$tax['total'][$receipt_product->getReceiptTax()->getReceiptTax()]['total_tax'], 2), 2, '•', '');
  442.                             }
  443.                             if ($receipt_transaction !== false) {
  444.                                 $receipt_payment_method = $receipt_transaction->getReceiptPaymentMethod();
  445.                                 if ($receipt_payment_method !== null) {
  446.                                     if (!isset($group_by_payment_method[$receipt_payment_method->getName()])) {
  447.                                         $group_by_payment_method[$receipt_payment_method->getName()] = 0;
  448.                                     }
  449. //                                $group_by_payment_method[$receipt_payment_method->getName()] += $receipt->getCartTotalFixed();
  450.                                     $group_by_payment_method[$receipt_payment_method->getName()] += $receipt->getTotalFixed();
  451.                                     if ($receipt_payment_method->getCash() === true) {
  452. //                                    $group_by_cash_nocash['cash'] += $receipt->getCartTotalFixed();
  453.                                         $group_by_cash_nocash['cash'] += $receipt->getTotalFixed();
  454.                                         $group_by_cash_nocash['cash_f'] = number_format(round((float)$group_by_cash_nocash['cash'], 2), 2, '•', '');
  455.                                         foreach ($receipt_cart_products as $receipt_cart_product) {
  456.                                             $receipt_product = $receipt_cart_product->getReceiptProduct();
  457.                                             $tax['cash'][$receipt_product->getReceiptTax()->getReceiptTax()]['total'] += $receipt_cart_product->getTotalFixed();
  458.                                             $tax['cash'][$receipt_product->getReceiptTax()->getReceiptTax()]['total_notax'] += $receipt_cart_product->getTotalOtaxFixed();
  459.                                             $tax['cash'][$receipt_product->getReceiptTax()->getReceiptTax()]['total_tax'] += ($receipt_cart_product->getTotalFixed() - $receipt_cart_product->getTotalOtaxFixed());
  460.                                             $tax['cash'][$receipt_product->getReceiptTax()->getReceiptTax()]['total_f'] = number_format(round((float)$tax['cash'][$receipt_product->getReceiptTax()->getReceiptTax()]['total'], 2), 2, '•', '');
  461.                                             $tax['cash'][$receipt_product->getReceiptTax()->getReceiptTax()]['total_notax_f'] = number_format(round((float)$tax['cash'][$receipt_product->getReceiptTax()->getReceiptTax()]['total_notax'], 2), 2, '•', '');
  462.                                             $tax['cash'][$receipt_product->getReceiptTax()->getReceiptTax()]['total_tax_f'] = number_format(round((float)$tax['cash'][$receipt_product->getReceiptTax()->getReceiptTax()]['total_tax'], 2), 2, '•', '');
  463.                                         }
  465.                                     } else {
  466.                                         $group_by_cash_nocash['nocash'] += $receipt->getTotalFixed();
  467. //                                    $group_by_cash_nocash['nocash'] += $receipt->getCartTotalFixed();
  468.                                         $group_by_cash_nocash['nocash_f'] = number_format(round((float)$group_by_cash_nocash['nocash'], 2), 2, '•', '');
  469.                                         foreach ($receipt_cart_products as $receipt_cart_product) {
  470.                                             $receipt_product = $receipt_cart_product->getReceiptProduct();
  471.                                             $tax['nocash'][$receipt_product->getReceiptTax()->getReceiptTax()]['total'] += $receipt_cart_product->getTotalFixed();
  472.                                             $tax['nocash'][$receipt_product->getReceiptTax()->getReceiptTax()]['total_notax'] += $receipt_cart_product->getTotalOtaxFixed();
  473.                                             $tax['nocash'][$receipt_product->getReceiptTax()->getReceiptTax()]['total_tax'] += ($receipt_cart_product->getTotalFixed() - $receipt_cart_product->getTotalOtaxFixed());
  474.                                             $tax['nocash'][$receipt_product->getReceiptTax()->getReceiptTax()]['total_f'] = number_format(round((float)$tax['nocash'][$receipt_product->getReceiptTax()->getReceiptTax()]['total'], 2), 2, '•', '');
  475.                                             $tax['nocash'][$receipt_product->getReceiptTax()->getReceiptTax()]['total_notax_f'] = number_format(round((float)$tax['nocash'][$receipt_product->getReceiptTax()->getReceiptTax()]['total_notax'], 2), 2, '•', '');
  476.                                             $tax['nocash'][$receipt_product->getReceiptTax()->getReceiptTax()]['total_tax_f'] = number_format(round((float)$tax['nocash'][$receipt_product->getReceiptTax()->getReceiptTax()]['total_tax'], 2), 2, '•', '');
  477.                                         }
  479.                                     }
  480.                                 }
  481.                             }
  482.                         } else {
  483.                             $position_count += $receipt->getReceiptCartProducts()->count();
  484. //                        $receipt_totals += $receipt->getCartTotalFixed();
  485.                             $receipt_totals += $base_receipt->getTotalFixed();
  486.                             $receipt_transaction = $receipt->getReceiptTransactions()->last();
  487.                             $receipt_cart_products = $receipt->getReceiptCartProducts();
  488.                             foreach ($receipt_cart_products as $receipt_cart_product) {
  489.                                 $receipt_product = $receipt_cart_product->getReceiptProduct();
  490.                                 if (!isset($tax['total'][$receipt_product->getReceiptTax()->getReceiptTax()])) {
  491.                                     $tax['total'][$receipt_product->getReceiptTax()->getReceiptTax()] = ['total' => 0, 'total_f' => 0, 'total_notax' => 0, 'total_notax_f' => 0, 'total_tax' => 0, 'total_tax_f' => 0];
  492.                                 }
  493.                                 if (!isset($tax['cash'][$receipt_product->getReceiptTax()->getReceiptTax()])) {
  494.                                     $tax['cash'][$receipt_product->getReceiptTax()->getReceiptTax()] = ['total' => 0, 'total_f' => 0, 'total_notax' => 0, 'total_notax_f' => 0, 'total_tax' => 0, 'total_tax_f' => 0];
  495.                                 }
  496.                                 if (!isset($tax['nocash'][$receipt_product->getReceiptTax()->getReceiptTax()])) {
  497.                                     $tax['nocash'][$receipt_product->getReceiptTax()->getReceiptTax()] = ['total' => 0, 'total_f' => 0, 'total_notax' => 0, 'total_notax_f' => 0, 'total_tax' => 0, 'total_tax_f' => 0];
  498.                                 }
  499.                                 $tax['total'][$receipt_product->getReceiptTax()->getReceiptTax()]['total'] += $receipt_cart_product->getTotalFixed();
  500.                                 $tax['total'][$receipt_product->getReceiptTax()->getReceiptTax()]['total_notax'] += $receipt_cart_product->getTotalOtaxFixed();
  501.                                 $tax['total'][$receipt_product->getReceiptTax()->getReceiptTax()]['total_tax'] += ($receipt_cart_product->getTotalFixed() - $receipt_cart_product->getTotalOtaxFixed());
  502.                                 $tax['total'][$receipt_product->getReceiptTax()->getReceiptTax()]['total_f'] = number_format(round((float)$tax['total'][$receipt_product->getReceiptTax()->getReceiptTax()]['total'], 2), 2, '•', '');
  503.                                 $tax['total'][$receipt_product->getReceiptTax()->getReceiptTax()]['total_notax_f'] = number_format(round((float)$tax['total'][$receipt_product->getReceiptTax()->getReceiptTax()]['total_notax'], 2), 2, '•', '');
  504.                                 $tax['total'][$receipt_product->getReceiptTax()->getReceiptTax()]['total_tax_f'] = number_format(round((float)$tax['total'][$receipt_product->getReceiptTax()->getReceiptTax()]['total_tax'], 2), 2, '•', '');
  505.                             }
  506.                             if ($receipt_transaction !== false) {
  507.                                 $receipt_payment_method = $receipt_transaction->getReceiptPaymentMethod();
  508.                                 if ($receipt_payment_method !== null) {
  509.                                     if (!isset($group_by_payment_method[$receipt_payment_method->getName()])) {
  510.                                         $group_by_payment_method[$receipt_payment_method->getName()] = 0;
  511.                                     }
  512. //                                $group_by_payment_method[$receipt_payment_method->getName()] += $receipt->getCartTotalFixed();
  513.                                     $group_by_payment_method[$receipt_payment_method->getName()] += $receipt->getTotalFixed();
  514.                                     if ($receipt_payment_method->getCash() === true) {
  515. //                                    $group_by_cash_nocash['cash'] += $receipt->getCartTotalFixed();
  516.                                         $group_by_cash_nocash['cash'] += $receipt->getTotalFixed();
  517.                                         $group_by_cash_nocash['cash_f'] = number_format(round((float)$group_by_cash_nocash['cash'], 2), 2, '•', '');
  518.                                     } else {
  519. //                                    $group_by_cash_nocash['nocash'] += $receipt->getCartTotalFixed();
  520.                                         $group_by_cash_nocash['nocash'] += $receipt->getTotalFixed();
  521.                                         $group_by_cash_nocash['nocash_f'] = number_format(round((float)$group_by_cash_nocash['nocash'], 2), 2, '•', '');
  522.                                     }
  523.                                     $group_by_cash_nocash['nocash'] += $daily_financial_statement->getCardPayment();
  524.                                     $group_by_cash_nocash['nocash_f'] = number_format(round((float)$group_by_cash_nocash['nocash'], 2), 2, '•', '');
  525.                                 }
  526.                             }
  527.                         }
  528.                     }
  529.                 }
  531.                 $daily_financial_statement_['receipt_cash'] = $group_by_cash_nocash['cash'];
  532.                 $daily_financial_statement_['receipt_nocash'] = $group_by_cash_nocash['nocash'];
  533.                 $daily_financial_statement_['cashbox_cash_debit'] = ($daily_financial_statement_['receipt_cash'] + $daily_financial_statement_['daily_financial_statement']['deposit_total'] + $daily_financial_statement_['daily_financial_statement']['cashbox_start_value']) - ($daily_financial_statement_['daily_financial_statement']['withdrawal_total'] + $daily_financial_statement_['daily_financial_statement']['payment_to_supplier_total']);
  534.                 $daily_financial_statement_['cashbox_cash_debit_f'] = number_format(round((float)$daily_financial_statement_['cashbox_cash_debit'], 2), 2, '•', '');
  535.                 $daily_financial_statement_['receipt_cash_f'] = number_format(round((float)$group_by_cash_nocash['cash'], 2), 2, '•', '');
  536.                 $daily_financial_statement_['receipt_nocash_f'] = number_format(round((float)$group_by_cash_nocash['nocash'], 2), 2, '•', '');
  537.                 $daily_financial_statement_['cash_debit'] = $daily_financial_statement_['daily_financial_statement']['cashbox_start_value'] + $daily_financial_statement_['receipt_cash'];
  538.                 $daily_financial_statement_['cash_debit_f'] = number_format(round((float)$daily_financial_statement_['cash_debit'], 2), 2, '•', '');
  539.                 $daily_financial_statement_['receipt_count'] = $receipt_container->count();
  540.                 $daily_financial_statement_['position_count'] = $position_count;
  541.                 $daily_financial_statement_['receipt_value_average'] = round(($receipt_totals / $receipt_container->count()), 2);
  542.                 $daily_financial_statement_['receipt_value_average_f'] = number_format((float)$daily_financial_statement_['receipt_value_average'], 2, '•', '');
  543.                 $daily_financial_statement_['group_by_payment_method'] = $group_by_payment_method;
  544.                 $daily_financial_statement_['group_by_cash_nocash'] = $group_by_cash_nocash;
  545.                 $daily_financial_statement_['receipt_total'] = $receipt_totals;
  548.                 $daily_financial_statement_['receipt_total_f'] = number_format(round((float)$daily_financial_statement_['receipt_total'], 2), 2, '•', '');
  549.                 $daily_financial_statement_['summe2'] = $daily_financial_statement_['receipt_cash'] + $daily_financial_statement_['receipt_nocash'];
  550.                 $daily_financial_statement_['summe2_f'] = number_format((float)round($daily_financial_statement_['summe2'], 2), 2, '•', '');
  551.                 $daily_financial_statement_['summe3'] = (float)0;
  552.                 $daily_financial_statement_['summe3_f'] = number_format((float)round($daily_financial_statement_['summe3'], 2), 2, '•', '');
  553.                 $daily_financial_statement_['differences'] = ['cash' => [], 'nocash' => ['Anzahlungen' => [], 'Gutschriften' => [], 'Gutscheine' => []]];
  554.                 $daily_financial_statement_['differences']['cash'] = [
  555.                     'debit' => $daily_financial_statement_['cashbox_cash_debit'],
  556.                     'debit_f' => $daily_financial_statement_['cashbox_cash_debit_f'],
  557.                     'credit' => (float)($daily_financial_statement__['cashbox_end_value'] / 100),
  558.                     'credit_f' => $daily_financial_statement__['cashbox_end_value_f'],
  559.                     'difference' => round(((float)($daily_financial_statement__['cashbox_end_value'] / 100)) - $daily_financial_statement_['cashbox_cash_debit'], 2),
  560.                     'difference_f' => number_format(round(((float)($daily_financial_statement__['cashbox_end_value'] / 100)) - $daily_financial_statement_['cashbox_cash_debit'], 2), 2, '•', ''),
  561.                 ];
  562.                 $daily_financial_statement_['differences']['nocash']['Anzahlungen'] = [
  563.                     'debit' => (float)0,
  564.                     'debit_f' => number_format((float)0, 2, '•', ''),
  565.                     'credit' => (float)0,
  566.                     'credit_f' => number_format((float)0, 2, '•', ''),
  567.                     'difference' => (float)0,
  568.                     'difference_f' => number_format((float)0, 2, '•', ''),
  569.                 ];
  570.                 $daily_financial_statement_['differences']['nocash']['Gutschriften'] = [
  571.                     'debit' => (float)0,
  572.                     'debit_f' => number_format((float)0, 2, '•', ''),
  573.                     'credit' => (float)0,
  574.                     'credit_f' => number_format((float)0, 2, '•', ''),
  575.                     'difference' => (float)0,
  576.                     'difference_f' => number_format((float)0, 2, '•', ''),
  577.                 ];
  578.                 $daily_financial_statement_['differences']['nocash']['Gutscheine'] = [
  579.                     'debit' => (float)0,
  580.                     'debit_f' => number_format((float)0, 2, '•', ''),
  581.                     'credit' => (float)0,
  582.                     'credit_f' => number_format((float)0, 2, '•', ''),
  583.                     'difference' => (float)0,
  584.                     'difference_f' => number_format((float)0, 2, '•', ''),
  585.                 ];
  586.                 $daily_financial_statement_['tax'] = $tax;
  587.             }
  588.         }
  590.         return new JsonResponse(['_success' => true, 'daily_financial_statement_print' => $daily_financial_statement_]);
  591.     }
  593.     /**
  594.      * @Route("/update/{id}", name="update_daily_financial_statement", methods={"GET","POST"})
  595.      */
  596.     public function update(Request $request, DailyFinancialStatement $dailyFinancialStatement)
  597.     {
  598.         $data = json_decode($request->getContent(), true);
  599.         $dailyFinancialStatement
  600.             ->setCashboxStartValue($data['daily_financial_statement_data']['cashbox_start_value'])
  601.             ->setCashboxEndValue($data['daily_financial_statement_data']['cashbox_end_value'])
  602.             ->setDeposits($data['daily_financial_statement_data']['deposit_total'])
  603.             ->setWithdrawals($data['daily_financial_statement_data']['withdrawal_total'])
  604.             ->setPaymentsToSuppliers($data['daily_financial_statement_data']['payment_to_supplier_total'])
  605.             ->setCardPayment($data['daily_financial_statement_data']['card_payment']);
  606.         $this->entity_manager->persist($dailyFinancialStatement);
  607.         $this->entity_manager->flush();
  608.         return new JsonResponse(['_success' => true]);
  609.     }
  611.     /**
  612.      * @Route("/print/{id}", name="print_daily_financial_statement", methods={"GET","POST"})
  613.      */
  614.     public function print(Request $request, DailyFinancialStatement $dailyFinancialStatement)
  615.     {
  616.         $data = $this->zBonData($dailyFinancialStatement);
  617.         // Configure Dompdf according to your needs
  618.         $pdfOptions = new Options();
  619.         $pdfOptions->set('defaultFont', 'Arial');
  621.         // Instantiate Dompdf with our options
  622.         $dompdf = new Dompdf($pdfOptions);
  624.         // Retrieve the HTML generated in our twig file
  625. //        $html = $this->renderView('cash_box/daily_financial_statement/zbon.a4.html.twig', $data);
  626.         $html = $this->renderView('cash_box/daily_financial_statement/zbon.80mm.html.twig', $data);
  628.         // Load HTML to Dompdf
  629.         $dompdf->loadHtml($html);
  631.         // (Optional) Setup the paper size and orientation 'portrait' or 'portrait'
  632.         $dompdf->setPaper('A4', 'portrait');
  634.         // Render the HTML as PDF
  635.         $dompdf->render();
  637.         // Output the generated PDF to Browser (inline view)
  638.         $dompdf->stream("DailyFinancialStatement_" . $dailyFinancialStatement->getStartDate()->format("d-m-Y-H-i") . "_" . $dailyFinancialStatement->getEndDate()->format("d-m-Y-H-i") . "_" . time() . ".pdf", [
  639.             "Attachment" => false
  640.         ]);
  641.     }
  643.     /**
  644.      * @Route("/list", name="list_daily_financial_statement", methods={"GET","POST"})
  645.      */
  646.     public function list(Request $request)
  647.     {
  648.         $_daily_financial_statements = $this->daily_financial_statement_repository->findAll();
  649.         $daily_financial_statements = [];
  650.         foreach ($_daily_financial_statements as $daily_financial_statement) {
  651.             $daily_financial_statements[$daily_financial_statement->getId()] = [
  652.                 'cashbox_end_value' => $daily_financial_statement->getCashboxEndValue(),
  653.                 'cashbox_start_value' => $daily_financial_statement->getCashboxStartValue(),
  654.                 'end_date' => $daily_financial_statement->getEndDate()->format("d.m.Y / H:i"),
  655.                 'id' => $daily_financial_statement->getId(),
  656.                 'start_date' => $daily_financial_statement->getStartDate()->format("d.m.Y / H:i"),
  657.                 'start_y' => $daily_financial_statement->getStartDate()->format('Y'),
  658.                 'start_m' => $daily_financial_statement->getStartDate()->format('m'),
  659.                 'start_d' => $daily_financial_statement->getStartDate()->format('d'),
  660.                 'start_h' => $daily_financial_statement->getStartDate()->format('H'),
  661.                 'start_i' => $daily_financial_statement->getStartDate()->format('i'),
  662.                 'start_s' => $daily_financial_statement->getStartDate()->format('s'),
  663.                 'end_y' => $daily_financial_statement->getEndDate()->format('Y'),
  664.                 'end_m' => $daily_financial_statement->getEndDate()->format('m'),
  665.                 'end_d' => $daily_financial_statement->getEndDate()->format('d'),
  666.                 'end_h' => $daily_financial_statement->getEndDate()->format('H'),
  667.                 'end_i' => $daily_financial_statement->getEndDate()->format('i'),
  668.                 'end_s' => $daily_financial_statement->getEndDate()->format('s'),
  669.                 'manually' => $daily_financial_statement->getManually(),
  670.             ];
  671.         }
  672.         return new JsonResponse($daily_financial_statements);
  674.     }
  676.     private function zBonData(DailyFinancialStatement $dailyFinancialStatement)
  677.     {
  678.         $data = [
  679.             'kasse' => null,
  680.             'firma' => null,
  681.             'gezaehlt' => 0,
  682.             'soll' => 0,
  683.             'differenz' => 0,
  684.             'daily_financial_statement' => 0,
  685.             'location' => null,
  686.             'zbonnr' => 0,
  687.             'anfangsbestand' => 0,
  688.             'einlagen' => 0,
  689.             'entnahmen' => 0,
  690.             'zahlungen_an_lieferanten' => 0,
  691.             'receipt_cash' => 0,
  692.             'cash_debit' => 0,
  693.             'receipt_count' => 0,
  694.             'position_count' => 0,
  695.             'anzahl_bon_stornos' => 0,
  696.             'verkaufte_gutscheine' => 0,
  697.             'receipt_value_average' => 0,
  698.             'bar' => 0,
  699.             'ec_karte' => 0,
  700.             'kreditkarte' => 0,
  701.             'auf_rechnung_gezahlt' => 0,
  702.             'group_by_payment_method' => 0,
  703.             'receipt_total' => 0,
  704.             'bankeinzahlungen' => 0,
  705.             'bar_differenzen' => 0,
  706.             'wechselgeldvortrag' => 0,
  707.             'zahlungen_von_kunden_rechnungen' => 0,
  708.             'geleistete_anzahlungen_auf_kassenauftraege' => 0,
  709.             'summe_retourenpositionen' => 0,
  710. //            'Anfangsbestand'=>null,
  711. //            'Anfangsbestand'=>null,
  712. //            'Anfangsbestand'=>null,
  713. //            'Anfangsbestand'=>null,
  714. //            'Anfangsbestand'=>null,
  715. //            'Anfangsbestand'=>null,
  716. //            'Anfangsbestand'=>null,
  717. //            'Anfangsbestand'=>null,
  718. //            'Anfangsbestand'=>null,
  719. //            'Anfangsbestand'=>null,
  720. //            'Anfangsbestand'=>null,
  721. //            'Anfangsbestand'=>null,
  722. //            'Anfangsbestand'=>null,
  723. //            'Anfangsbestand'=>null,
  724. //            'Anfangsbestand'=>null,
  725. //            'Anfangsbestand'=>null,
  726. //            'Anfangsbestand'=>null,
  727. //            'Anfangsbestand'=>null,
  728. //            'Anfangsbestand'=>null,
  729. //            'Anfangsbestand'=>null,
  730. //            'Anfangsbestand'=>null,
  731. //            'Anfangsbestand'=>null,
  732. //            'Anfangsbestand'=>null,
  733.         ];
  734.         $receipt_container = $dailyFinancialStatement->getReceipts();
  735.         if ($receipt_container->count() > 0) {
  736.             $position_count = 0;
  737.             $receipt_totals = 0;
  738.             $group_by_payment_method = [];
  739.             foreach ($receipt_container as $receipt) {
  740.                 $position_count += $receipt->getReceiptCartProducts()->count();
  741. //                $receipt_totals += $receipt->getCartTotalFixed();
  742.                 $receipt_totals += $receipt->getTotalFixed();
  743.                 $receiptTransaction = $receipt->getReceiptTransactions()->last();
  744.                 if ($receiptTransaction !== false) {
  745.                     $receiptPaymentMethod = $receiptTransaction->getReceiptPaymentMethod();
  746.                     if ($receiptPaymentMethod !== null) {
  747.                         if (!isset($group_by_payment_method[$receiptPaymentMethod->getName()])) {
  748.                             $group_by_payment_method[$receiptPaymentMethod->getName()] = 0;
  749.                         }
  750. //                        $group_by_payment_method[$receiptPaymentMethod->getName()] += $receipt->getCartTotalFixed();
  751.                         $group_by_payment_method[$receiptPaymentMethod->getName()] += $receipt->getTotalFixed();
  752.                     }
  753.                 }
  754.             }
  755.             $company = $this->company_repository->findOneBy(['id' => 1]);
  756.             $_company = [
  757.                 'address_addition' => null,
  758.                 'address_country' => null,
  759.                 'address_locality' => null,
  760.                 'email' => null,
  761.                 'fax_number' => null,
  762.                 'id' => null,
  763.                 'line_1' => null,
  764.                 'line_2' => null,
  765.                 'logo' => null,
  766.                 'name' => null,
  767.                 'postal_code' => null,
  768.                 'street_address' => null,
  769.                 'tax_number' => null,
  770.                 'telephone' => null,
  771.                 'vat_id' => null,
  772.                 'website' => null,
  773.             ];
  775.             if ($company !== null) {
  776.                 $_company = [
  777.                     'address_addition' => $company->getAddressAddition(),
  778.                     'address_country' => $company->getAddressCountry(),
  779.                     'address_locality' => $company->getAddressLocality(),
  780.                     'email' => $company->getEmail(),
  781.                     'fax_number' => $company->getFaxNumber(),
  782.                     'id' => $company->getId(),
  783.                     'line_1' => $company->getLine1(),
  784.                     'line_2' => $company->getLine2(),
  785.                     'logo' => $company->getLogo(),
  786.                     'name' => $company->getName(),
  787.                     'postal_code' => $company->getPostalCode(),
  788.                     'street_address' => $company->getStreetAddress(),
  789.                     'tax_number' => $company->getTaxNumber(),
  790.                     'telephone' => $company->getTelephone(),
  791.                     'vat_id' => $company->getVatId(),
  792.                     'website' => $company->getWebsite(),
  793.                 ];
  794.             }
  795.             $_dailyFinancialStatement = [
  796.                 'id' => $dailyFinancialStatement->getId(),
  797.                 'start_date' => $dailyFinancialStatement->getStartDate()->format("d.m.Y / H:i"),
  798.                 'end_date' => $dailyFinancialStatement->getEndDate()->format("d.m.Y / H:i"),
  799.                 'cashbox_start_value' => $dailyFinancialStatement->getCashboxStartValue(),
  800.                 'cashbox_end_value' => $dailyFinancialStatement->getCashboxEndValue(),
  801.                 'deposit_total' => $dailyFinancialStatement->getDeposits(),
  802.                 'withdrawal_total' => $dailyFinancialStatement->getWithdrawals(),
  803.                 'payment_to_supplier_total' => $dailyFinancialStatement->getPaymentsToSuppliers(),
  804.             ];
  805.             $receiptLocation = $receipt->getReceiptLocation();
  806.             $_receiptLocation = [
  807.                 'name' => null,
  808.             ];
  809.             if ($receiptLocation !== null) {
  810.                 $_receiptLocation = [
  811.                     'name' => $receiptLocation->getName(),
  812.                 ];
  813.             }
  814.             $data['zbonnr'] = $dailyFinancialStatement->getId();
  815.             $data['kasse'] = ['name' => $receipt->getReceiptCashbox()->getName(), 'sn' => $receipt->getReceiptCashbox()->getSerialNumber()];
  816.             $data['firma'] = $_company;
  817.             $data['gezaehlt'] = $dailyFinancialStatement->getCashboxEndValue();
  818.             $data['anfangsbestand'] = $dailyFinancialStatement->getCashboxStartValue();
  819.             $data['receipt_cash'] = $group_by_payment_method['Bar'];
  820.             $data['cash_debit'] = $data['anfangsbestand'] + $data['receipt_cash'];
  821.             $data['receipt_count'] = $receipt_container->count();
  822.             $data['position_count'] = $position_count;
  823.             $data['receipt_value_average'] = $receipt_totals / $receipt_container->count();
  824.             $data['group_by_payment_method'] = $group_by_payment_method;
  825.             $data['receipt_total'] = $receipt_totals;
  826.             $data['soll'] = $data['cash_debit'];
  827.             $data['differenz'] = $data['gezaehlt'] - $data['soll'];
  828.             $data['daily_financial_statement'] = $_dailyFinancialStatement;
  829.             $data['location'] = $_receiptLocation;
  830.         }
  831.         return $data;
  832.     }
  834.     /**
  835.      * @Route("/map", name="map_daily_financial_statement", methods={"GET","POST"})
  836.      */
  837.     public function map()
  838.     {
  839.         $data = [];
  840.         $daily_financial_statements = $this->daily_financial_statement_repository->findBy(['manually' => true]);
  841.         foreach ($daily_financial_statements as $daily_financial_statement) {
  842.             $detected_timezone = $this->timeZoneDetectionService->getTimezoneDifference($this->timeZoneDetectionService->DateTimeInterfaceToDateTime($daily_financial_statement->getStartDate()));
  843.             $sql = <<<SQL
  844. SELECT receipt.id
  845. FROM receipt
  846. WHERE unix_timestamp(convert_tz(create_date,'$detected_timezone',@@session.time_zone))>=:start
  847.   AND unix_timestamp(convert_tz(create_date,'$detected_timezone',@@session.time_zone))<=:end
  848. SQL;
  849.             $con = $this->entity_manager->getConnection();
  850.             $stmt = $con->executeQuery($sql, ['start' => $daily_financial_statement->getStartDate()->getTimestamp(), 'end' => $daily_financial_statement->getEndDate()->getTimestamp()]);
  851.             while (($row = $stmt->fetchAssociative()) !== false) {
  852.                 $receipt = $this->receipt_repository->findOneBy(['id' => $row['id']]);
  853.                 $receipt->setDailyFinancialStatement($daily_financial_statement);
  854.                 $this->entity_manager->persist($receipt);
  855.                 $this->entity_manager->flush();
  856.             }
  857.         }
  858.     }
  860.     /**
  861.      * @Route("/start", name="start_daily_financial_statement")
  862.      */
  863.     public function start()
  864.     {
  865.         if ($this->_check() === false) {
  866.             $daily_financial_statement = new DailyFinancialStatement();
  867.         }
  868.     }
  870.     /**
  871.      * @Route("/stop/{id}", name="stop_daily_financial_statement", methods={"GET","POST"})
  872.      */
  873.     public function stop(Request $request, DailyFinancialStatement $dailyFinancialStatement)
  874.     {
  875.     }
  877.     /**
  878.      * @Route("/check", name="check_daily_financial_statement")
  879.      */
  880.     public function check()
  881.     {
  882.         return new JsonResponse(['_success' => true, 'has_active_daily_financial_statement' => $this->_check()]);
  883.     }
  885.     /**
  886.      * @Route("/load_active", name="load_active_daily_financial_statement")
  887.      */
  888.     public function loadActive()
  889.     {
  890.         $daily_financial_statement = $this->daily_financial_statement_repository->findOneBy(['end_date' => null], ['id' => 'DESC']);
  891.         if ($daily_financial_statement instanceof DailyFinancialStatement) {
  892.             return new JsonResponse(['_success' => true, 'active_daily_financial_statement' => $daily_financial_statement->getId()]);
  893.         }
  894.         return new JsonResponse(['_success' => false, 'active_daily_financial_statement' => null]);
  895.     }
  897.     /**
  898.      * @Route("/create", name="create_daily_financial_statement", methods={"GET","POST"})
  899.      */
  900.     public function create(Request $request)
  901.     {
  902.         $log_date = new \DateTime('now');
  903.         $log_file = __DIR__ . '/../../../var/' . $log_date->format("Y_m_d_H_i_s") . '.create_daily_financial_statement.log';
  904.         $cloner = new VarCloner();
  905.         $dumper = new CliDumper();
  906.         $data = json_decode($request->getContent(), true);
  907.         if (isset($data['cashbox'], $data['money_stack_data']) && !empty($data['cashbox']) && !empty($data['money_stack_data'])) {
  908.             $cashbox = $this->cashbox_repository->findOneBy(['id' => $data['cashbox']]);
  909.             if ($cashbox instanceof Cashbox) {
  910.                 $cashbox_session = $this->cashbox_service->getLatestStartedCashboxSession($cashbox);
  911.                 if ($cashbox_session !== null) {
  912.                     foreach ($data['money_stack_data']['factory'] as $item_factor => $item_amount) {
  913.                         $cashbox_counting = new CashboxCounting();
  914.                         $cashbox_counting
  915.                             ->setAddDate(new \DateTime('now'))
  916.                             ->setCashboxSession($cashbox_session)
  917.                             ->setFactor((int)$item_factor)
  918.                             ->setAmount((int)$item_amount);
  919.                         $this->entity_manager->persist($cashbox_counting);
  920.                     }
  921.                     $this->entity_manager->flush();
  922.                     $cashbox_session
  923.                         ->setStopDate(new \DateTime('now'))
  924.                         ->setCashStop($data['money_stack_data']['total']);
  925.                     $this->entity_manager->persist($cashbox_session);
  926.                     $this->entity_manager->flush();
  928.                     $location = $cashbox->getLocation();
  929.                     $daily_financial_statement_location = null;
  930.                     if ($location instanceof Location) {
  931.                         $daily_financial_statement_location = new DailyFinancialStatementLocation();
  932.                         $daily_financial_statement_location
  933.                             ->setAddressAddition($location->getAddressAddition())
  934.                             ->setAddressCountry($location->getAddressCountry())
  935.                             ->setAddressLocality($location->getAddressLocality())
  936.                             ->setEmail($location->getEmail())
  937.                             ->setFaxNumber($location->getFaxNumber())
  938.                             ->setLocation($location)
  939.                             ->setLogo($location->getLogo())
  940.                             ->setName($location->getName())
  941.                             ->setPostalCode($location->getPostalCode())
  942.                             ->setShowAddressOnReceipt($location->getShowAddressOnReceipt())
  943.                             ->setShowContactOnReceipt($location->getShowContactOnReceipt())
  944.                             ->setStreetAddress($location->getStreetAddress())
  945.                             ->setTelephone($location->getTelephone())
  946.                             ->setWebsite($location->getWebsite());
  947.                     }
  948.                     $this->entity_manager->persist($daily_financial_statement_location);
  949.                     $this->entity_manager->flush();
  951.                     $daily_financial_statement_cashbox = new DailyFinancialStatementCashbox();
  952.                     $daily_financial_statement_cashbox
  953.                         ->setCashbox($cashbox)
  954.                         ->setComment($cashbox->getComment())
  955.                         ->setDailyFinancialStatementLocation($daily_financial_statement_location)
  956.                         ->setLocked($cashbox->getLocked())
  957.                         ->setName($cashbox->getName())
  958.                         ->setSerialNumber($cashbox->getSerialNumber());
  959.                     $this->entity_manager->persist($daily_financial_statement_cashbox);
  960.                     $this->entity_manager->flush();
  962.                     $cashbox_deposit_container = $this->cashbox_service->getCashboxDeposit($cashbox, $cashbox_session);
  963.                     /**
  964.                      * @var CashboxDeposit $cashbox_deposit
  965.                      */
  966.                     foreach ($cashbox_deposit_container as $cashbox_deposit) {
  967.                         $daily_financial_statement_cashbox_deposit = new DailyFinancialStatementCashboxDeposit();
  968.                         $daily_financial_statement_cashbox_deposit
  969.                             ->setAddDate($cashbox_deposit->getAddDate())
  970.                             ->setValue($cashbox_deposit->getValue())
  971.                             ->setCashboxDeposit($cashbox_deposit)
  972.                             ->setDailyFinancialStatementCashbox($daily_financial_statement_cashbox);
  973.                         $this->entity_manager->persist($daily_financial_statement_cashbox_deposit);
  974.                     }
  975.                     $this->entity_manager->flush();
  977.                     $cashbox_withdrawal_container = $this->cashbox_service->getCashboxWithdrawal($cashbox, $cashbox_session);
  978.                     /**
  979.                      * @var CashboxWithdrawal $cashbox_withdrawal
  980.                      */
  981.                     foreach ($cashbox_withdrawal_container as $cashbox_withdrawal) {
  982.                         $daily_financial_statement_cashbox_withdrawal = new DailyFinancialStatementCashboxWithdrawal();
  983.                         $daily_financial_statement_cashbox_withdrawal
  984.                             ->setAddDate($cashbox_withdrawal->getAddDate())
  985.                             ->setValue($cashbox_withdrawal->getValue())
  986.                             ->setCashboxWithdrawal($cashbox_withdrawal)
  987.                             ->setDailyFinancialStatementCashbox($daily_financial_statement_cashbox);
  988.                         $this->entity_manager->persist($daily_financial_statement_cashbox_withdrawal);
  989.                     }
  990.                     $this->entity_manager->flush();
  992.                     $cashbox_payment_to_supplier_container = $this->cashbox_service->getCashboxPaymentToSupplier($cashbox, $cashbox_session);
  993.                     /**
  994.                      * @var CashboxPaymentToSupplier $cashbox_payment_to_supplier
  995.                      */
  996.                     foreach ($cashbox_payment_to_supplier_container as $cashbox_payment_to_supplier) {
  997.                         $daily_financial_statement_cashbox_payment_to_supplier = new DailyFinancialStatementCashboxPaymentToSupplier();
  998.                         $daily_financial_statement_cashbox_payment_to_supplier
  999.                             ->setAddDate($cashbox_payment_to_supplier->getAddDate())
  1000.                             ->setValue($cashbox_payment_to_supplier->getValue())
  1001.                             ->setCashboxPaymentToSupplier($cashbox_payment_to_supplier)
  1002.                             ->setDailyFinancialStatementCashbox($daily_financial_statement_cashbox);
  1003.                         $this->entity_manager->persist($daily_financial_statement_cashbox_payment_to_supplier);
  1004.                     }
  1005.                     $this->entity_manager->flush();
  1007.                     $daily_financial_statement = new DailyFinancialStatement();
  1008.                     $daily_financial_statement
  1009.                         ->setStartDate($cashbox_session->getStartDate())
  1010.                         ->setEndDate($cashbox_session->getStopDate())
  1011.                         ->setCashboxStartValue($cashbox_session->getCashStart())
  1012.                         ->setCashboxEndValue($cashbox_session->getCashStop())
  1013.                         ->setDailyFinancialStatementCashbox($daily_financial_statement_cashbox)
  1014.                         ->setManually(false);
  1015.                     $this->entity_manager->persist($daily_financial_statement);
  1016.                     $this->entity_manager->flush();
  1017.                     foreach ($data['money_stack_data']['factory'] as $item_factor => $item_amount) {
  1018.                         $daily_financial_statement_counting = new DailyFinancialStatementCounting();
  1019.                         $daily_financial_statement_counting
  1020.                             ->setAddDate(new \DateTime('now'))
  1021.                             ->setDailyFinancialStatement($daily_financial_statement)
  1022.                             ->setFactor((int)$item_factor)
  1023.                             ->setAmount((int)$item_amount);
  1024.                         $this->entity_manager->persist($daily_financial_statement_counting);
  1025.                     }
  1026.                     $this->entity_manager->flush();
  1028.                     $receipt_container = $this->daily_financial_statement_service->getReceipt($cashbox, $daily_financial_statement);
  1029.                     /**
  1030.                      * @var Receipt $receipt
  1031.                      */
  1032.                     foreach ($receipt_container as $receipt) {
  1033.                         $receipt->setDailyFinancialStatement($daily_financial_statement);
  1034.                         $this->entity_manager->persist($receipt);
  1035.                     }
  1036.                     $this->entity_manager->flush();
  1037. /*
  1038.                     // Fiskaly
  1039.                     $cash_point_closing = new CashPointClosingStructure();
  1040.                     $cash_point_closing_head = new CashPointClosingHeadStructure();
  1041.                     $cash_point_closing_head->setExportCreationDate(time())
  1042.                         ->setFirstTransactionExportId()
  1043.                         ->setLastTransactionExportId();
  1044.                     $cash_point_closing->setHead($cash_point_closing_head)
  1045.                         ->setClientId()
  1046.                         ->setCashPointClosingExportId();*/
  1048.                     return new JsonResponse(['_success' => true]);
  1049.                 }
  1050.             }
  1051.         }
  1052.         return new JsonResponse(['_success' => false]);
  1053.     }
  1055.     private function _check()
  1056.     {
  1057.         $daily_financial_statement = $this->daily_financial_statement_repository->findOneBy(['end_date' => null], ['id' => 'DESC']);
  1058.         if ($daily_financial_statement instanceof DailyFinancialStatement) {
  1059.             return true;
  1060.         }
  1061.         return false;
  1062.     }
  1063. }