src/Controller/AdminInvoicesController.php line 1207

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  6. use Symfony\Component\Routing\Annotation\Route;
  7. use App\Forms\Admin\AdminUserForm;
  8. use App\Helpers\InvoicesHelper;
  9. use App\Helpers\PreordersHelper;
  10. use App\Helpers\EmailHelper;
  11. use Symfony\Component\Validator\Constraints\File;
  12. use Symfony\Component\Form\Extension\Core\Type\TextType;
  13. use Symfony\Component\Form\Extension\Core\Type\ChoiceType;
  14. use Symfony\Component\Form\Extension\Core\Type\CheckboxType;
  15. use Symfony\Component\Form\Extension\Core\Type\SubmitType;
  16. use Symfony\Component\Form\Extension\Core\Type\DateType;
  17. use Symfony\Component\Form\Extension\Core\Type\UrlType;
  18. use Symfony\Component\Filesystem\Filesystem;
  19. use Symfony\Component\HttpFoundation\Request;
  20. use Symfony\Component\HttpFoundation\File\Exception\FileException;
  21. use Symfony\Component\HttpFoundation\JsonResponse;
  22. use App\Entity\Invoices;
  23. use App\Entity\InvoicesPayers;
  24. use App\Entity\Reminders;
  25. use Symfony\Component\String\Slugger\SluggerInterface;
  26. use Knp\Component\Pager\PaginatorInterface;
  27. use App\Managements\SettingsManagement;
  28. use Symfony\Contracts\Translation\TranslatorInterface;
  29. use App\Managements\InvoicesManagement;
  30. use App\Forms\Admin\AdminInvoiceForm;
  31. use Doctrine\ORM\EntityManagerInterface;
  32. use Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorageInterface;
  33. use Doctrine\DBAL\Driver\Connection;
  34. use App\Entity\Users;
  35. use App\Managements\PreordersManagement;
  36. use App\Managements\Logs as LogsManagement;
  37. use App\Helpers\Logs as LogsHelper;
  38. use App\Managements\PayersManagement;
  40. class AdminInvoicesController extends AbstractController
  41. {
  43.     /**
  44.      * @var EntityManagerInterface
  45.      */
  46.     private $entityManager;
  48.     public function __construct(
  49.         SluggerInterface $slugger,
  50.         EntityManagerInterface $entityManager,
  51.         TokenStorageInterface $tokenStorage,
  52.         TranslatorInterface $translator,
  53.         PayersManagement $payersManagement,
  54.         // $activeMenuParent = 'admin_invoices'
  55.     ) {
  56.         $this->slugger = $slugger;
  57.         $this->translator = $translator;
  58.         $this->tokenStorage = $tokenStorage;
  59.         $this->entityManager = $entityManager;
  60.         $this->activeMenuParent = 'admin_invoices';
  61.         $this->ordering = array();
  62.         $this->filters = array();
  63.         $this->incompletePayers = $payersManagement->loadIncomplete();
  64.         (!isset($_SESSION['accessModules'])) ? $_SESSION['accessModules'] = [] : '';
  65.     }
  67.     /**
  68.      * @Route("/admin/faktury-old", name="admin_invoices_old")
  69.      */
  70.     public function old_index(
  71.         InvoicesManagement $invoicesManagement,
  72.         SettingsManagement $settingsManagement,
  73.         InvoicesHelper $invoicesHelper,
  74.         EmailHelper $emailHelper,
  75.         PaginatorInterface $paginator,
  76.         Request $request
  77.     ) {
  78.         if ($this->getUser()) {
  79.             $access = $this->getDoctrine()->getRepository(Users::class)->findOneBy(array("email" => $this->getUser()->getEmail()))->getAccessModules();
  80.             $_SESSION['accessModules'] = explode(",", $access);
  81.         }
  82.         if (in_array($this->activeMenuParent, $_SESSION['accessModules'])) {
  83.             $summary = 0;
  84.             $title = 'Lista faktur';
  85.             $searchForm = $this->invoicesFilterForm();
  86.             $searchForm->handleRequest($request);
  87.             if ($searchForm->isSubmitted() && $searchForm->isValid()) {
  88.                 $this->filters = $searchForm->getData();
  89.             }
  90.             $this->filters['status'] = 'active';
  91.             $items = $invoicesManagement->load(null, $this->filters, $this->ordering);
  92.             // dd($items);
  93.             //UPDATE `invoices` SET `number_int`=REPLACE(`number`, '/','') WHERE `number_int` IS NULL;
  94.             $items = $invoicesHelper->prepareForListing($items);
  95.             foreach ($items as $item) {
  96.                 $summary = $summary + $item['value'];
  97.             }
  98.             // dump($items);
  99.             $items = $paginator->paginate($items, $request->query->getInt('page', 1), $settingsManagement->value('itemsPerDashboardPage'));
  100.             $this->filters['deadline'] = 1;
  101.             $this->filters['sorting'] = 'deadline';
  102.             $items1 = $invoicesManagement->load(null, $this->filters, $this->ordering);
  103.             $items1 = $invoicesHelper->prepareForListing($items1);
  104.             $items1 = $paginator->paginate($items1, $request->query->getInt('page', 1), $settingsManagement->value('itemsPerDashboardPage'));
  105.             $this->filters = array();
  106.             return $this->render('Admin/Invoices/list.html.twig', [
  107.                 'accessModules' => $_SESSION['accessModules'],
  108.                 'incompletePayers' => $this->incompletePayers,
  109.                 'title' => $title,
  110.                 'activeMenuParent' => $this->activeMenuParent,
  111.                 'searchForm' => $searchForm->createView(),
  112.                 'items' => $items,
  113.                 'items1' => $items1,
  114.                 'summary' => $summary
  115.             ]);
  116.         } else {
  117.             return $this->redirectToRoute($_SESSION['accessModules'][0]);
  118.         }
  119.     }
  121.     /**
  122.      * @Route("/admin/faktury", name="admin_invoices")
  123.      */
  124.     public function index(
  125.         InvoicesManagement $invoicesManagement,
  126.         SettingsManagement $settingsManagement,
  127.         InvoicesHelper $invoicesHelper,
  128.         EmailHelper $emailHelper,
  129.         PaginatorInterface $paginator,
  130.         Request $request
  131.     ) {
  132.         if ($this->getUser()) {
  133.             $access = $this->getDoctrine()->getRepository(Users::class)->findOneBy(array("email" => $this->getUser()->getEmail()))->getAccessModules();
  134.             $_SESSION['accessModules'] = explode(",", $access);
  135.         }
  136.         if (in_array($this->activeMenuParent, $_SESSION['accessModules'])) {
  137.             $summary = 0;
  138.             $title = 'Lista faktur';
  139.             $searchForm = $this->invoicesFilterForm();
  140.             $searchForm->handleRequest($request);
  141.             if ($searchForm->isSubmitted() && $searchForm->isValid()) {
  142.                 $this->filters = $searchForm->getData();
  143.             }
  144.             $this->filters['status'] = 'active';
  145.             $this->filters['opcjonalne'] = false;
  148.             $items = $invoicesManagement->load(null, $this->filters, $this->ordering);
  149.             // dd($items);
  150.             //UPDATE `invoices` SET `number_int`=REPLACE(`number`, '/','') WHERE `number_int` IS NULL;
  151.             $items = $invoicesHelper->prepareForListing2($items);
  152.             foreach ($items as $item) {
  153.                 $summary = $summary + $item['value'];
  154.             }
  155.             dump($items);
  156.             $items = $paginator->paginate($items, $request->query->getInt('page', 1), $settingsManagement->value('itemsPerDashboardPage'));
  157.             $this->filters['deadline'] = 1;
  158.             $this->filters['sorting'] = 'deadline';
  159.             $items1 = $invoicesManagement->load(null, $this->filters, $this->ordering);
  160.             $items1 = $invoicesHelper->prepareForListing2($items1);
  161.             $items1 = $paginator->paginate($items1, $request->query->getInt('page', 1), $settingsManagement->value('itemsPerDashboardPage'));
  162.             $this->filters = array();
  163.             return $this->render('Admin/Invoices/listing.html.twig', [
  164.                 'accessModules' => $_SESSION['accessModules'],
  165.                 'incompletePayers' => $this->incompletePayers,
  166.                 'title' => $title,
  167.                 'activeMenuParent' => $this->activeMenuParent,
  168.                 'searchForm' => $searchForm->createView(),
  169.                 'items' => $items,
  170.                 'items1' => $items1,
  171.                 'summary' => $summary
  172.             ]);
  173.         } else {
  174.             return $this->redirectToRoute($_SESSION['accessModules'][0]);
  175.         }
  176.     }
  179.     /**
  180.      * @Route("/admin/faktury-opcjonalne", name="admin_invoices_opt")
  181.      */
  182.     public function index_opt(
  183.         InvoicesManagement $invoicesManagement,
  184.         SettingsManagement $settingsManagement,
  185.         InvoicesHelper $invoicesHelper,
  186.         EmailHelper $emailHelper,
  187.         PaginatorInterface $paginator,
  188.         Request $request
  189.     ) {
  190.         if ($this->getUser()) {
  191.             $access = $this->getDoctrine()->getRepository(Users::class)->findOneBy(array("email" => $this->getUser()->getEmail()))->getAccessModules();
  192.             $_SESSION['accessModules'] = explode(",", $access);
  193.         }
  194.         if (in_array($this->activeMenuParent, $_SESSION['accessModules'])) {
  195.             $summary = 0;
  196.             $title = 'Lista faktur opcjonalnych';
  197.             $searchForm = $this->invoicesFilterForm();
  198.             $searchForm->handleRequest($request);
  199.             if ($searchForm->isSubmitted() && $searchForm->isValid()) {
  200.                 $this->filters = $searchForm->getData();
  201.             }
  202.             $this->filters['status'] = 'active';
  203.             $this->filters['opcjonalne'] = true;
  206.             $items = $invoicesManagement->load(null, $this->filters, $this->ordering);
  207.             // dd($items);
  208.             //UPDATE `invoices` SET `number_int`=REPLACE(`number`, '/','') WHERE `number_int` IS NULL;
  209.             $items = $invoicesHelper->prepareForListing2($items);
  210.             foreach ($items as $item) {
  211.                 $summary = $summary + $item['value'];
  212.             }
  213.             // dump($items);
  214.             $items = $paginator->paginate($items, $request->query->getInt('page', 1), $settingsManagement->value('itemsPerDashboardPage'));
  215.             $this->filters['deadline'] = 1;
  216.             $this->filters['sorting'] = 'deadline';
  217.             $items1 = $invoicesManagement->load(null, $this->filters, $this->ordering);
  218.             $items1 = $invoicesHelper->prepareForListing2($items1);
  219.             $items1 = $paginator->paginate($items1, $request->query->getInt('page', 1), $settingsManagement->value('itemsPerDashboardPage'));
  220.             $this->filters = array();
  221.             return $this->render('Admin/Invoices/listing.html.twig', [
  222.                 'accessModules' => $_SESSION['accessModules'],
  223.                 'incompletePayers' => $this->incompletePayers,
  224.                 'title' => $title,
  225.                 'activeMenuParent' => $this->activeMenuParent,
  226.                 'searchForm' => $searchForm->createView(),
  227.                 'items' => $items,
  228.                 'items1' => $items1,
  229.                 'summary' => $summary
  230.             ]);
  231.         } else {
  232.             return $this->redirectToRoute($_SESSION['accessModules'][0]);
  233.         }
  234.     }
  236.     /**
  237.      * @Route("/admin/faktury/subiekt", name="admin_subiekt_invoices")
  238.      */
  239.     public function subiekt(
  240.         InvoicesManagement $invoicesManagement,
  241.         SettingsManagement $settingsManagement,
  242.         InvoicesHelper $invoicesHelper,
  243.         EmailHelper $emailHelper,
  244.         PaginatorInterface $paginator,
  245.         Request $request
  246.     ) {
  247.         if ($this->getUser()) {
  248.             $access = $this->getDoctrine()->getRepository(Users::class)->findOneBy(array("email" => $this->getUser()->getEmail()))->getAccessModules();
  249.             $_SESSION['accessModules'] = explode(",", $access);
  250.         }
  251.         if (in_array($this->activeMenuParent, $_SESSION['accessModules'])) {
  252.             $summary = 0;
  253.             $title = 'Faktury z importu Subiekt';
  254.             $searchForm = $this->invoicesFilterForm2();
  255.             $searchForm->handleRequest($request);
  256.             if ($searchForm->isSubmitted() && $searchForm->isValid()) {
  257.                 $this->filters = $searchForm->getData();
  258.             }
  259.             $this->filters['status'] = 'subiekt';
  260.             $this->filters['sorting'] = 'number';
  261.             $items = $invoicesManagement->load(null, $this->filters, $this->ordering);
  262.             $items = $invoicesHelper->prepareForListing($items);
  263.             foreach ($items as $item) {
  264.                 $summary = $summary + $item['value'];
  265.             }
  266.             $items = $paginator->paginate($items, $request->query->getInt('page', 1), 100);
  267.             $this->filters['deadline'] = 1;
  268.             $this->filters['sorting'] = 'deadline';
  269.             $items1 = $invoicesManagement->load(null, $this->filters, $this->ordering);
  270.             $items1 = $invoicesHelper->prepareForListing($items1);
  271.             $items1 = $paginator->paginate($items1, $request->query->getInt('page', 1), 100);
  272.             $this->filters = array();
  273.             return $this->render('Admin/Invoices/subiekt-list.html.twig', [ 
  274.                 'accessModules' => $_SESSION['accessModules'],
  275.                 'source' => 'subiekt',
  276.                 'incompletePayers' => $this->incompletePayers,
  277.                 'title' => $title,
  278.                 'activeMenuParent' => $this->activeMenuParent,
  279.                 'searchForm' => $searchForm->createView(),
  280.                 'items' => $items,
  281.                 'items1' => $items1,
  282.                 'summary' => $summary
  283.             ]);
  284.         } else {
  285.             return $this->redirectToRoute($_SESSION['accessModules'][0]);
  286.         }
  287.     }
  289.     /**
  290.      * @Route("/admin/faktury/fakturownia", name="admin_fakturownia_invoices")
  291.      */
  292.     public function fakturownia(
  293.         InvoicesManagement $invoicesManagement,
  294.         SettingsManagement $settingsManagement,
  295.         InvoicesHelper $invoicesHelper,
  296.         EmailHelper $emailHelper,
  297.         PaginatorInterface $paginator,
  298.         Request $request
  299.     ) {
  300.         if ($this->getUser()) {
  301.             $access = $this->getDoctrine()->getRepository(Users::class)->findOneBy(array("email" => $this->getUser()->getEmail()))->getAccessModules();
  302.             $_SESSION['accessModules'] = explode(",", $access);
  303.         }
  304.         if (in_array($this->activeMenuParent, $_SESSION['accessModules'])) {
  305.             $summary = 0;
  306.             $title = 'Faktury z importu Fakturownia';
  307.             $searchForm = $this->invoicesFilterForm2();
  308.             $searchForm->handleRequest($request);
  309.             if ($searchForm->isSubmitted() && $searchForm->isValid()) {
  310.                 $this->filters = $searchForm->getData();
  311.             }
  312.             $this->filters['status'] = 'fakturownia';
  313.             $this->filters['sorting'] = 'number';
  314.             $items = $invoicesManagement->load(null, $this->filters, $this->ordering);
  315.             $items = $invoicesHelper->prepareForListing($items);
  316.             foreach ($items as $item) {
  317.                 $summary = $summary + $item['value'];
  318.             }
  319.             $items = $paginator->paginate($items, $request->query->getInt('page', 1), $settingsManagement->value('itemsPerDashboardPage'));
  320.             $this->filters['deadline'] = 1;
  321.             $this->filters['sorting'] = 'deadline';
  322.             $items1 = $invoicesManagement->load(null, $this->filters, $this->ordering);
  323.             $items1 = $invoicesHelper->prepareForListing($items1);
  324.             $items1 = $paginator->paginate($items1, $request->query->getInt('page', 1), $settingsManagement->value('itemsPerDashboardPage'));
  325.             $this->filtedrs = array();
  326.             return $this->render('Admin/Invoices/subiekt-list.html.twig', [
  327.                 'accessModules' => $_SESSION['accessModules'],
  328.                 'source' => 'fakturownia',
  329.                 'incompletePayers' => $this->incompletePayers,
  330.                 'title' => $title,
  331.                 'activeMenuParent' => $this->activeMenuParent,
  332.                 'searchForm' => $searchForm->createView(),
  333.                 'items' => $items,
  334.                 'items1' => $items1,
  335.                 'summary' => $summary
  336.             ]);
  337.         } else {
  338.             return $this->redirectToRoute($_SESSION['accessModules'][0]);
  339.         }
  340.     }
  342.     /**
  343.      * @Route("/admin/prognozy", name="admin_forecasts")
  344.      */
  345.     public function forecasts(
  346.         InvoicesManagement $invoicesManagement,
  347.         SettingsManagement $settingsManagement,
  348.         PreordersManagement $preordersManagement,
  349.         InvoicesHelper $invoicesHelper,
  350.         PreordersHelper $preordersHelper,
  351.         PaginatorInterface $paginator,
  352.         Request $request
  353.     ) {
  354.         if (in_array($this->activeMenuParent, $_SESSION['accessModules'])) {
  355.             $title = 'Prognozy';
  356.             $items = $invoicesManagement->load(null, $this->filters, $this->ordering);
  357.             $items = $invoicesHelper->prepareForecastsForListing($items);
  358.             $total = $preorders_total = $forecast_sum = 0.00;
  359.             $sum = $preorders_sum = 0;
  360.             foreach ($items as $item) {
  361.                 $total = $total + $item['value'];
  362.                 $sum++;
  363.             }
  364.             $preorders = $preordersManagement->load(null, array("status" => 'active'), $this->ordering);
  366.             $preorders = $preordersHelper->prepareForecastsForListing($preorders);
  369.             foreach ($preorders as $forecast_nr => $forecast) {
  370.                 $forecast_sum = 0.00;
  371.                 // dump($forecast);
  372.                 foreach ($forecast as $trans) {
  373.                     $value = @$this->toFloat(($trans));
  374.                     $forecast_sum = $forecast_sum + $value;
  375.                     $preorders_total = $preorders_total + $value;
  376.                     $preorders_sum++;
  377.                 }
  378.                 $preorders[$forecast_nr] = number_format($forecast_sum, 2, ',', ' ');
  379.             }
  380.             // die();
  381.             $preorders_total = number_format($preorders_total, 2, ',', ' ');
  382.             // dump($preorders);die();
  383.             $items = $paginator->paginate($items, $request->query->getInt('page', 1), $settingsManagement->value('itemsPerDashboardPage'));
  386.             return $this->render('Admin/Invoices/forecasts.html.twig', [
  387.                 'accessModules' => $_SESSION['accessModules'],
  388.                 'incompletePayers' => $this->incompletePayers,
  389.                 'title' => $title,
  390.                 'activeMenuParent' => $this->activeMenuParent,
  391.                 'items' => $items,
  392.                 'total' => $total,
  393.                 'sum' => $sum,
  394.                 'preorders' => $preorders,
  395.                 'preorders_total' => $preorders_total,
  396.                 'preorders_sum' => $preorders_sum
  397.             ]);
  398.         } else {
  399.             return $this->redirectToRoute($_SESSION['accessModules'][0]);
  400.         }
  401.     }
  405.     private function toFloat($number)
  406.     {
  407.         $floated = 0.00;
  409.         $value = str_replace(' ', '', $number);
  410.         // dump($value);
  411.         $value = preg_replace('/\s+/', '', $value);
  412.         // dump($value);
  413.         $value = str_replace(',', '.', $value);
  414.         // dump($value);
  415.         // $value = number_format($value, 2, '.', '');
  416.         $floated += $value;
  418.         return $floated;
  419.     }
  421.     /**
  422.      * @Route("/admin/faktury/edytuj/{id}", name="admin_edit_invoice")
  423.      */
  424.     public function edit(
  425.         $id,
  426.         InvoicesManagement $invoicesManagement,
  427.         LogsManagement $logsManagement,
  428.         InvoicesHelper $invoicesHelper,
  429.         Request $request
  430.     ) {
  431.         if (in_array($this->activeMenuParent, $_SESSION['accessModules'])) {
  432.             $item = $invoicesManagement->load($id, null, null);
  433.             if ($item->getStatus() == 'fakturownia') {
  434.                 $urlredirect = 'admin_fakturownia_invoices';
  435.             }
  436.             if ($item->getStatus() == 'subiekt') {
  437.                 $urlredirect = 'admin_subiekt_invoices';
  438.             }
  439.             if ($item->getStatus() == 'active') {
  440.                 $urlredirect = 'admin_invoices';
  441.             }
  442.             $title = 'Faktura ' . $item->getNumber();
  443.             $form = $this->createForm(AdminInvoiceForm::class, $item);
  444.             $form->handleRequest($request);
  445.             if ($form->isSubmitted() && $form->isValid()) {
  446.                 $service = '';
  447.                 $item = $form->getData();
  448.                 $item->setStatus($item->getStatus());
  449.                 $item->setNumberInt(intval(str_replace('/', '', $item->getNumber())));
  450.                 if ($item->getPozycjonowanie() == 1) {
  451.                     $service .= 'Pozycjonowanie, ';
  452.                 }
  453.                 if ($item->getGads() == 1) {
  454.                     $service .= 'Google Ads, ';
  455.                 }
  456.                 if ($item->getFads() == 1) {
  457.                     $service .= 'Facebook Ads, ';
  458.                 }
  459.                 if ($item->getOpinie() == 1) {
  460.                     $service .= 'Opinie, ';
  461.                 }
  462.                 if ($item->getReklama() == 1) {
  463.                     $service .= 'Działania reklamowe, ';
  464.                 }
  465.                 if ($item->getDomena() == 1) {
  466.                     $service .= 'Domena, ';
  467.                 }
  468.                 if ($item->getHosting() == 1) {
  469.                     $service .= 'Hosting, ';
  470.                 }
  471.                 if ($item->getSslt() == 1) {
  472.                     $service .= 'SSL, ';
  473.                 }
  474.                 if ($item->getRata() == 1) {
  475.                     $service .= 'WWW Rata, ';
  476.                 }
  477.                 if ($item->getPrototyp() == 1) {
  478.                     $service .= 'WWW Prototyp, ';
  479.                 }
  480.                 if ($item->getGrafika() == 1) {
  481.                     $service .= 'WWW Grafika, ';
  482.                 }
  483.                 if ($item->getProgramowanie() == 1) {
  484.                     $service .= 'WWW Programowanie, ';
  485.                 }
  486.                 if ($item->isPraceProgramistyczne() == 1) {
  487.                     $service .= 'Prace Programistyczne, ';
  488.                 }
  489.                 if ($item->getAktualizacja() == 1) {
  490.                     $service .= 'Aktualizacja, ';
  491.                 }
  492.                 if ($item->getOpieka() == 1) {
  493.                     $service .= 'Opieka, ';
  494.                 }
  495.                 if ($item->isOpiekaWizytowka() == 1) {
  496.                     $service .= 'Opieka nad wizytówką, ';
  497.                 }
  498.                 if ($item->getArchiwizacja() == 1) {
  499.                     $service .= 'Archiwizacja, ';
  500.                 }
  501.                 if ($item->getId() >= 715) {
  502.                     $item->setService($service);
  503.                 }
  504.                 $item->setGrossValue(str_replace(',', '.', $item->getGrossValue()));
  505.                 // dump($item);
  506.                 // die();
  507.                 $item->setCustomerPrio($item->getCustomerPrio());
  508.                 $item->setCreatedDate(new \DateTime());
  509.                 ('active');
  510.                 if (!is_null($item->getClient())) {
  511.                     $oldPayer = $this->getDoctrine()->getRepository(InvoicesPayers::class)->FindOneBy(array('invoice' => $item));
  512.                     $this->entityManager->remove($oldPayer);
  513.                     $this->entityManager->flush();
  514.                     $payer = $invoicesManagement->loadPayer($item->getClient(), null, null);
  516.                     $clientData = array(
  517.                         "name" => $payer->getName(),
  518.                         "email" => $payer->getEmail(),
  519.                         "phone" => $payer->getPhone(),
  520.                         "notify" => $payer->getNotify(),
  521.                         "description" => $payer->getDescription(),
  522.                         "invoice" => $item
  523.                     );
  524.                     $invoicesManagement->createPayer($clientData);
  525.                 }
  526.                 $entityManager = $this->getDoctrine()->getManager();
  527.                 $entityManager->persist($item);
  528.                 $entityManager->flush();
  529.                 $this->addFlash('success', $this->translator->trans('Success updated'));
  530.                 $item = $invoicesHelper->prepareInvoiceDetails($item);
  531.                 $data = array(
  532.                     "user" => $this->tokenStorage->getToken()->getUser()->getEmail(),
  533.                     "path" => $request->getPathInfo(),
  534.                     "action" => "Edycja faktury - [" . $item['symbol'] . "]" . $item['number'],
  535.                     "ip" => $request->getClientIp()
  536.                 );
  537.                 $logsManagement->createPanelEntry($data);
  538.                 return $this->redirectToRoute($urlredirect);
  539.             }
  541.             $item = $invoicesHelper->prepareInvoiceDetails($item);
  542.             $reminds = array();
  543.             // if(isset($item['payer'])){
  544.             $reminders = $this->getDoctrine()->getRepository(Reminders::class)->FindBy(array('client' => $item['payer']->getId()));
  545.             foreach ($reminders as $remind) {
  546.                 $name = "SMS";
  547.                 if ($remind->getType() == "2") {
  548.                     $name = "E-mail";
  549.                 }
  550.                 $reminds[] = array(
  551.                     'createdDate' => date_format($remind->getCreatedDate(), 'd-m-Y'),
  552.                     'name' => $name
  553.                 );
  554.             }
  555.             // }
  556.             return $this->render('Admin/Invoices/details.html.twig', [
  557.                 'accessModules' => $_SESSION['accessModules'],
  558.                 'incompletePayers' => $this->incompletePayers,
  559.                 'title' => $title,
  560.                 'activeMenuParent' => $this->activeMenuParent,
  561.                 'item' => $item,
  562.                 'reminders' => $reminds,
  563.                 'form' => $form->createView(),
  564.             ]);
  565.         } else {
  566.             return $this->redirectToRoute($_SESSION['accessModules'][0]);
  567.         }
  568.     }
  570.     /**
  571.      * @Route("/admin/faktury/klonuj/{id}", name="admin_clone_invoice")
  572.      */
  573.     public function clone(
  574.         $id,
  575.         InvoicesManagement $invoicesManagement,
  576.         LogsManagement $logsManagement,
  577.         InvoicesHelper $invoicesHelper,
  578.         Request $request
  579.     ) {
  580.         if (in_array($this->activeMenuParent, $_SESSION['accessModules'])) {
  581.             $origin = $invoicesManagement->load($id, null, null);
  582.             $item = new Invoices();
  583.             $item->setId(null);
  584.             $item->setNumber($origin->getNumber() . '-Kopia');
  585.             $item->setStatus('active');
  586.             $item->setCustomerPrio($origin->getCustomerPrio());
  587.             $item->setCreatedDate(new \DateTime());
  588.             $item->setBillDate($origin->getBillDate());
  589.             $item->setDueDate($origin->getDueDate());
  590.             $item->setForecast($origin->getForecast());
  591.             $item->setCompany($origin->getCompany());
  592.             $item->setDeadlineNote($origin->getDeadlineNote());
  593.             $item->setService($origin->getService());
  594.             $item->setGrossValue($origin->getGrossValue());
  595.             $item->setType($origin->getType());
  596.             $entityManager = $this->getDoctrine()->getManager();
  597.             $entityManager->persist($item);
  598.             $entityManager->flush();
  599.             foreach ($origin->getPayer() as $payer) {
  600.                 $payer = $invoicesManagement->loadInvoicePayer($payer->getId(), null, null);
  601.                 $clientData = array(
  602.                     "name" => $payer->getName(),
  603.                     "email" => $payer->getEmail(),
  604.                     "phone" => $payer->getPhone(),
  605.                     "notify" => $payer->getNotify(),
  606.                     "description" => $payer->getDescription(),
  607.                     "invoice" => $item
  608.                 );
  609.                 $invoicesManagement->createPayer($clientData);
  610.             }
  611.             $item = $invoicesHelper->prepareInvoiceDetails($item);
  612.             $data = array(
  613.                 "user" => $this->tokenStorage->getToken()->getUser()->getEmail(),
  614.                 "path" => $request->getPathInfo(),
  615.                 "action" => "Sklonowanie faktury ID - " . $origin->getId() . " do pozycji - [" . $item['symbol'] . "]" . $item['number'],
  616.                 "ip" => $request->getClientIp()
  617.             );
  618.             $logsManagement->createPanelEntry($data);
  619.             return $this->redirectToRoute('admin_invoices');
  620.         } else {
  621.             return $this->redirectToRoute($_SESSION['accessModules'][0]);
  622.         }
  623.     }
  625.     /**
  626.      * @Route("/admin/faktury/dodaj", name="admin_add_invoice")
  627.      */
  628.     public function add(
  629.         InvoicesManagement $invoicesManagement,
  630.         InvoicesHelper $invoicesHelper,
  631.         LogsManagement $logsManagement,
  632.         Request $request
  633.     ) {
  634.         if (in_array($this->activeMenuParent, $_SESSION['accessModules'])) {
  635.             $title = "Dodaj fakturę";
  636.             $item = new Invoices();
  637.             $item->setNumber(date_format(new \DateTime(), '/m/Y'));
  638.             $item->setBillDate(new \DateTime());
  639.             $date = date_format($item->getBillDate(), 'd-m-Y');
  640.             $billDate = date('d-m-Y', strtotime($date . ' + 7 days'));
  641.             $item->setDueDate(new \DateTime($billDate));
  642.             $form = $this->createForm(AdminInvoiceForm::class, $item);
  643.             $form->handleRequest($request);
  644.             if ($form->isSubmitted() && $form->isValid()) {
  645.                 $service = '';
  646.                 $item = $form->getData();
  647.                 if ($item->getPozycjonowanie() == 1) {
  648.                     $service .= 'Pozycjonowanie, ';
  649.                 }
  650.                 if ($item->getGads() == 1) {
  651.                     $service .= 'Google Ads, ';
  652.                 }
  653.                 if ($item->getFads() == 1) {
  654.                     $service .= 'Facebook Ads, ';
  655.                 }
  656.                 if ($item->getOpinie() == 1) {
  657.                     $service .= 'Opinie, ';
  658.                 }
  659.                 if ($item->getReklama() == 1) {
  660.                     $service .= 'Działania reklamowe, ';
  661.                 }
  662.                 if ($item->getDomena() == 1) {
  663.                     $service .= 'Domena, ';
  664.                 }
  665.                 if ($item->getHosting() == 1) {
  666.                     $service .= 'Hosting, ';
  667.                 }
  668.                 if ($item->getSslt() == 1) {
  669.                     $service .= 'SSL, ';
  670.                 }
  671.                 if ($item->getRata() == 1) {
  672.                     $service .= 'WWW Rata, ';
  673.                 }
  674.                 if ($item->getPrototyp() == 1) {
  675.                     $service .= 'WWW Prototyp, ';
  676.                 }
  677.                 if ($item->getGrafika() == 1) {
  678.                     $service .= 'WWW Grafika, ';
  679.                 }
  680.                 if ($item->getProgramowanie() == 1) {
  681.                     $service .= 'WWW Programowanie, ';
  682.                 }
  683.                 if ($item->isPraceProgramistyczne() == 1) {
  684.                     $service .= 'Prace Programistyczne, ';
  685.                 }
  686.                 if ($item->getAktualizacja() == 1) {
  687.                     $service .= 'Aktualizacja, ';
  688.                 }
  689.                 if ($item->getOpieka() == 1) {
  690.                     $service .= 'Opieka, ';
  691.                 }
  692.                 if ($item->isOpiekaWizytowka() == 1) {
  693.                     $service .= 'Opieka nad wizytówką, ';
  694.                 }
  695.                 if ($item->getArchiwizacja() == 1) {
  696.                     $service .= 'Archiwizacja, ';
  697.                 }
  698.                 if ($item->getLogo() == 1) {
  699.                     $service .= 'Logo, ';
  700.                 }
  701.                 if ($item->getIdentyfikacja() == 1) {
  702.                     $service .= 'Identyfikacja, ';
  703.                 }
  704.                 if ($item->getPgraficzne() == 1) {
  705.                     $service .= 'Projekty graficzne, ';
  706.                 }
  707.                 if ($item->getInne() == 1) {
  708.                     $service .= 'Inne, ';
  709.                 }
  710.                 $item->setService($service);
  711.                 $item->setNumberInt(intval(str_replace('/', '', $item->getNumber())));
  712.                 $item->setStatus('active');
  713.                 $item->setCustomerPrio('neutral');
  714.                 $item->setCreatedDate(new \DateTime());
  715.                 $entityManager = $this->getDoctrine()->getManager();
  716.                 $entityManager->persist($item);
  717.                 $entityManager->flush();
  718.                 $clientntity = $invoicesManagement->loadPayer(intVal($item->getClient()), array(), array());
  719.                 $clientData = array(
  720.                     "name" => $clientntity->getName(),
  721.                     "email" => $clientntity->getEmail(),
  722.                     "phone" => $clientntity->getPhone(),
  723.                     "notify" => $clientntity->getNotify(),
  724.                     "description" => $clientntity->getDescription(),
  725.                     "invoice" => $item
  726.                 );
  727.                 $taxnumber = ($request->request->all()['taxnumber']) ? $request->request->all()['taxnumber'] : '';
  728.                 ($taxnumber) ? $clientData['tax_number'] = $taxnumber : '';
  729.                 $invoicesManagement->createPayer($clientData);
  730.                 //$item = $invoicesHelper->prepareInvoiceDetails($item);
  731.                 $data = array(
  732.                     "user" => $this->tokenStorage->getToken()->getUser()->getEmail(),
  733.                     "path" => $request->getPathInfo(),
  734.                     "action" => "Utworzenie faktury ID - " . $item->getId(),
  735.                     "ip" => $request->getClientIp()
  736.                 );
  737.                 $logsManagement->createPanelEntry($data);
  738.                 $this->addFlash('success', $this->translator->trans('Success created'));
  739.                 return $this->redirectToRoute('admin_invoices');
  740.             }
  741.             // die();
  742.             return $this->render('Admin/Invoices/add.html.twig', [
  743.                 'accessModules' => $_SESSION['accessModules'],
  744.                 'incompletePayers' => $this->incompletePayers,
  745.                 'title' => $title,
  746.                 'activeMenuParent' => $this->activeMenuParent,
  747.                 'item' => $item,
  748.                 'form' => $form->createView(),
  749.             ]);
  750.         } else {
  751.             return $this->redirectToRoute($_SESSION['accessModules'][0]);
  752.         }
  753.     }
  755.     function invoicesFilterForm2($fields = null)
  756.     {
  757.         $form = $this->createFormBuilder();
  758.         $form = $form->add('name', TextType::class, [
  759.             'required' => false,
  760.             'label' => 'Type tekst',
  761.             'label_attr' => ['class' => 'form-label'],
  762.             'attr' => [
  763.                 'style' => 'height: 50px',
  764.                 'class' => 'form-control pull-left'
  765.             ]
  766.         ]);
  767.         $form = $form->add('forecast', ChoiceType::class, [
  768.             'label' => "Prognoza",
  769.             'choices' => array(
  770.                 'Wszystkie' => null,
  771.                 '0 dni - nie zapłacą' => 0,
  772.                 '1 dni - zapłacone' => 1,
  773.                 '3 dni' => 3,
  774.                 '7 dni' => 7,
  775.                 '10 dni' => 10,
  776.                 '14 dni' => 14,
  777.                 '21 dni' => 21,
  778.                 '30 dni - w kolejnym miesiącu' => 30,
  779.                 '60 dni - status niepewny' => 60,
  780.                 // 'Nie uwzględniaj' => 111,
  781.                 'Opcjonalne' => 888,
  782.                 'Nie przypominaj' => 999
  783.             ),
  784.             'attr' => [
  785.                 'style' => 'height: 50px',
  786.                 'class' => 'form-control'
  787.             ]
  788.         ]);
  789.         $form = $form->add('company', ChoiceType::class, [
  790.             'label' => "Wystawca",
  791.             'choices' => array(
  792.                 '-Wybierz-' => null,
  793.                 'GOT' => 'GOT',
  794.                 'JDG' => 'JDG',
  795.                 'ZOO' => 'ZOO'
  796.             ),
  797.             'attr' => [
  798.                 'style' => 'height: 50px',
  799.                 'class' => 'form-control'
  800.             ]
  801.         ]);
  802.         $form = $form->add('type', ChoiceType::class, [
  803.             'label' => 'Typ',
  804.             'choices' => [
  805.                 '-Wybierz-' => null,
  806.                 'PROFORMA' => 1,
  807.                 'FVAT' => 2,
  808.                 'NOTA KSIĘGOWA' => 3,
  809.                 'GOTÓWKA' => 4
  810.             ],
  811.             'attr' => [
  812.                 'style' => 'height: 50px',
  813.                 'class' => 'form-control select2'
  814.             ]
  815.         ]);
  816.         $form = $form->add('dateFrom', DateType::class, [
  817.             'label' => 'Od',
  818.             'widget' => 'single_text',
  819.             'required' => false,
  820.             'format' => 'yyyy-MM-dd',
  821.             'attr' => [
  822.                 // 'value' => date_format(new \DateTime(), 'Y-m-d'),
  823.                 'class' => 'form-control'
  824.             ]
  825.         ]);
  826.         $form = $form->add('dateTo', DateType::class, [
  827.             'label' => 'Do',
  828.             'widget' => 'single_text',
  829.             'required' => false,
  830.             'format' => 'yyyy-MM-dd',
  831.             'attr' => [
  832.                 'class' => 'form-control'
  833.             ]
  834.         ]);
  835.         // $form = $form->add('got', CheckboxType::class, [
  836.         //     'label'    => 'GOT',
  837.         //     'required' => false,
  838.         //     'attr' => ['class' => 'basicBox']
  839.         // ]);
  840.         // $form = $form->add('jdg', CheckboxType::class, [
  841.         //     'label'    => 'JDG',
  842.         //     'required' => false,
  843.         //     'attr' => ['class' => 'basicBox']
  844.         // ]);
  845.         // $form = $form->add('zoo', CheckboxType::class, [
  846.         //     'label'    => 'ZOO',
  847.         //     'required' => false,
  848.         //     'attr' => ['class' => 'basicBox']
  849.         // ]);
  850.         $form = $form->add('sorting', ChoiceType::class, [
  851.             'label' => "Sortowanie",
  852.             'choices' => array(
  853.                 'Klient A-Z' => 'client',
  854.                 'Numer 1-N' => 'number'
  855.             ),
  856.             'attr' => [
  857.                 'style' => 'height: 50px',
  858.                 'class' => 'form-control'
  859.             ]
  860.         ]);
  861.         $form = $form->add('save', SubmitType::class, [
  862.             'label' => 'Search',
  863.             'attr' => [
  864.                 'style' => 'height: 50px',
  865.                 'class' => 'btn btn-theme w-100'
  866.             ]
  867.         ]);
  868.         $form = $form->getForm();
  869.         return $form;
  870.     }
  872.     function getForecasts()
  873.     {
  874.         $response = [
  875.             'Wszystkie' => null,
  876.             '0 dni - nie zapłacą' => 0,
  877.             '1 dni - zapłacone' => 1,
  878.             '3 dni' => 3,
  879.             '7 dni' => 7,
  880.             '10 dni' => 10,
  881.             '14 dni' => 14,
  882.             '21 dni' => 21,
  883.             '30 dni - w kolejnym miesiącu' => 30,
  884.             '60 dni - status niepewny' => 60,
  885.             // 'Nie uwzględniaj' => 111,
  886.             'Opcjonalne' => 888,
  887.             'Nie przypominaj' => 999
  888.         ];
  889.         return $response;
  890.     }
  893.     function invoicesFilterForm($fields = null)
  894.     {
  895.         $form = $this->createFormBuilder();
  896.         $form = $form->add('name', TextType::class, [
  897.             'required' => false,
  898.             'label' => 'Type tekst',
  899.             'label_attr' => ['class' => 'form-label'],
  900.             'attr' => [
  901.                 'style' => 'height: 50px',
  902.                 'class' => 'form-control pull-left'
  903.             ]
  904.         ]);
  905.         $form = $form->add('forecast', ChoiceType::class, [
  906.             'label' => "Prognoza",
  907.             'choices' => $this->getForecasts(),
  908.             'attr' => [
  909.                 'style' => 'height: 50px',
  910.                 'class' => 'form-select'
  911.             ]
  912.         ]);
  913.         $form = $form->add('company', ChoiceType::class, [
  914.             'label' => "Wystawca",
  915.             'choices' => array(
  916.                 '-Wybierz-' => null,
  917.                 'GOT' => 'GOT',
  918.                 'JDG' => 'JDG',
  919.                 'ZOO' => 'ZOO'
  920.             ),
  921.             'attr' => [
  922.                 'style' => 'height: 50px',
  923.                 'class' => 'form-select'
  924.             ]
  925.         ]);
  926.         $form = $form->add('type', ChoiceType::class, [
  927.             'label' => 'Typ',
  928.             'choices' => [
  929.                 '-Wybierz-' => null,
  930.                 'PROFORMA' => 1,
  931.                 'FVAT' => 2,
  932.                 'NOTA KSIĘGOWA' => 3,
  933.                 'GOTÓWKA' => 4
  934.             ],
  935.             'attr' => [
  936.                 'style' => 'height: 50px',
  937.                 'class' => 'form-select select2'
  938.             ]
  939.         ]);
  940.         $form = $form->add('dateFrom', DateType::class, [
  941.             'label' => 'Od',
  942.             'widget' => 'single_text',
  943.             'required' => false,
  944.             'format' => 'yyyy-MM-dd',
  945.             'attr' => [
  946.                 'style' => 'height: 50px',
  947.                 'class' => 'mt-2 form-control'
  948.             ]
  949.         ]);
  950.         $form = $form->add('dateTo', DateType::class, [
  951.             'label' => 'Do',
  952.             'widget' => 'single_text',
  953.             'required' => false,
  954.             'format' => 'yyyy-MM-dd',
  955.             'attr' => [
  956.                 'style' => 'height: 50px',
  957.                 'class' => 'mt-2 form-control'
  958.             ]
  959.         ]);
  960.         $form = $form->add('sorting', ChoiceType::class, [
  961.             'label' => "Sortowanie",
  962.             'choices' => array(
  963.                 'Klient A-Z' => 'client',
  964.                 'Numer 1-N' => 'number'
  965.             ),
  966.             'attr' => [
  967.                 'style' => 'height: 50px',
  968.                 'class' => 'form-select'
  969.             ]
  970.         ]);
  971.         $form = $form->add('save', SubmitType::class, [
  972.             'label' => 'Search',
  973.             'attr' => [
  974.                 'style' => 'height: 50px',
  975.                 'class' => 'btn btn-theme w-100'
  976.             ]
  977.         ]);
  978.         $form = $form->getForm();
  979.         return $form;
  980.     }
  982.     /**
  983.      * @Route("/admin/faktury/usun",  methods="POST")
  984.      */
  985.     function remove(
  986.         Request $request,
  987.         LogsManagement $logsManagement,
  988.         InvoicesManagement $invoicesManagement
  989.     ) {
  990.         $requestContent = json_decode($request->getContent(), true);
  991.         if (isset($requestContent['source'])) {
  992.             if ($invoicesManagement->removAllFrom($requestContent['source'])) {
  993.                 return new JsonResponse(['message' => $this->translator->trans('Success removed')], JsonResponse::HTTP_OK);
  994.             } else {
  995.                 return new JsonResponse([], JsonResponse::HTTP_CONFLICT);
  996.             }
  997.         } else {
  998.             if ($invoicesManagement->remove($requestContent['id'])) {
  999.                 $data = array(
  1000.                     "user" => $this->tokenStorage->getToken()->getUser()->getEmail(),
  1001.                     "path" => $request->getPathInfo(),
  1002.                     "action" => "Kasowanie faktury ID - " . $requestContent['id'],
  1003.                     "ip" => $request->getClientIp()
  1004.                 );
  1005.                 $logsManagement->createPanelEntry($data);
  1006.                 return new JsonResponse(['message' => $this->translator->trans('Success removed')], JsonResponse::HTTP_OK);
  1007.             } else {
  1008.                 return new JsonResponse([], JsonResponse::HTTP_CONFLICT);
  1009.             }
  1010.         }
  1011.     }
  1012.     /**
  1013.      * @Route("/admin/faktury/akceptuj",  methods="POST")
  1014.      */
  1015.     function accept(
  1016.         Request $request,
  1017.         LogsManagement $logsManagement,
  1018.         InvoicesManagement $invoicesManagement
  1019.     ) {
  1020.         $requestContent = json_decode($request->getContent(), true);
  1021.         if ($invoicesManagement->accept($requestContent['id'])) {
  1022.             $data = array(
  1023.                 "user" => $this->tokenStorage->getToken()->getUser()->getEmail(),
  1024.                 "path" => $request->getPathInfo(),
  1025.                 "action" => "Akceptacja faktury ID - " . $requestContent['id'],
  1026.                 "ip" => $request->getClientIp()
  1027.             );
  1028.             $logsManagement->createPanelEntry($data);
  1029.             return new JsonResponse(['message' => $this->translator->trans('Success removed')], JsonResponse::HTTP_OK);
  1030.         } else {
  1031.             return new JsonResponse([], JsonResponse::HTTP_CONFLICT);
  1032.         }
  1033.     }
  1035.     /**
  1036.      * @Route("/admin/faktury/prognozuj",  methods="POST")
  1037.      */
  1038.     function changeForecast(
  1039.         Request $request,
  1040.         LogsManagement $logsManagement,
  1041.         InvoicesManagement $invoicesManagement
  1042.     ) {
  1043.         $requestContent = json_decode($request->getContent(), true);
  1044.         if ($invoicesManagement->changeForecast($requestContent['id'], $requestContent['value'])) {
  1045.             $data = array(
  1046.                 "user" => $this->tokenStorage->getToken()->getUser()->getEmail(),
  1047.                 "path" => $request->getPathInfo(),
  1048.                 "action" => "Zmiana prognozy dla faktury ID - " . $requestContent['id'],
  1049.                 "ip" => $request->getClientIp()
  1050.             );
  1051.             $logsManagement->createPanelEntry($data);
  1052.             return new JsonResponse(['message' => $this->translator->trans('Success updated')], JsonResponse::HTTP_OK);
  1053.         } else {
  1054.             return new JsonResponse([], JsonResponse::HTTP_CONFLICT);
  1055.         }
  1056.     }
  1058.     /**
  1059.      * @Route("/admin/faktury/zmien-wystawce",  methods="POST")
  1060.      */
  1061.     function changeCompany(
  1062.         Request $request,
  1063.         LogsManagement $logsManagement,
  1064.         InvoicesManagement $invoicesManagement
  1065.     ) {
  1066.         $requestContent = json_decode($request->getContent(), true);
  1067.         if ($invoicesManagement->changeCompany($requestContent['id'], $requestContent['value'])) {
  1068.             $data = array(
  1069.                 "user" => $this->tokenStorage->getToken()->getUser()->getEmail(),
  1070.                 "path" => $request->getPathInfo(),
  1071.                 "action" => "Zmiana wystawcy dla faktury ID - " . $requestContent['id'],
  1072.                 "ip" => $request->getClientIp()
  1073.             );
  1074.             $logsManagement->createPanelEntry($data);
  1075.             return new JsonResponse(['message' => $this->translator->trans('Success updated')], JsonResponse::HTTP_OK);
  1076.         } else {
  1077.             return new JsonResponse([], JsonResponse::HTTP_CONFLICT);
  1078.         }
  1079.     }
  1080.     /**
  1081.      * @Route("/admin/faktury/add-position",  methods="POST")
  1082.      */
  1083.     function addPosition(
  1084.         Request $request,
  1085.         InvoicesManagement $invoicesManagement
  1086.     ) {
  1087.         $requestContent = json_decode($request->getContent(), true);
  1088.         if ($invoicesManagement->addPosition($requestContent['id'], $requestContent['name'], $requestContent['deadline'])) {
  1089.             return new JsonResponse(['message' => $this->translator->trans('Success updated')], JsonResponse::HTTP_OK);
  1090.         } else {
  1091.             return new JsonResponse([], JsonResponse::HTTP_CONFLICT);
  1092.         }
  1093.     }
  1094.     /**
  1095.      * @Route("/admin/faktury/remove-position",  methods="POST")
  1096.      */
  1097.     function removePosition(
  1098.         Request $request,
  1099.         InvoicesManagement $invoicesManagement
  1100.     ) {
  1101.         $requestContent = json_decode($request->getContent(), true);
  1102.         if ($invoicesManagement->removePosition($requestContent['id'])) {
  1103.             return new JsonResponse(['message' => $this->translator->trans('Success removed')], JsonResponse::HTTP_OK);
  1104.         } else {
  1105.             return new JsonResponse([], JsonResponse::HTTP_CONFLICT);
  1106.         }
  1107.     }
  1108.     /**
  1109.      * @Route("/admin/faktury/zmien-kolor",  methods="POST")
  1110.      */
  1111.     function changeCustomerPrio(
  1112.         Request $request,
  1113.         LogsManagement $logsManagement,
  1114.         InvoicesManagement $invoicesManagement
  1115.     ) {
  1116.         $requestContent = json_decode($request->getContent(), true);
  1117.         if ($invoicesManagement->changeCustomerPrio($requestContent['id'], $requestContent['value'])) {
  1118.             $data = array(
  1119.                 "user" => $this->tokenStorage->getToken()->getUser()->getEmail(),
  1120.                 "path" => $request->getPathInfo(),
  1121.                 "action" => "Zmiana koloru dla faktury ID - " . $requestContent['id'],
  1122.                 "ip" => $request->getClientIp()
  1123.             );
  1124.             $logsManagement->createPanelEntry($data);
  1125.             return new JsonResponse(['message' => $this->translator->trans('Success updated')], JsonResponse::HTTP_OK);
  1126.         } else {
  1127.             return new JsonResponse([], JsonResponse::HTTP_CONFLICT);
  1128.         }
  1129.     }
  1131.     /**
  1132.      * @Route("/admin/invoice/check-num",  methods="POST")
  1133.      */
  1134.     function checkNum(
  1135.         Request $request,
  1136.         InvoicesManagement $invoicesManagement
  1137.     ) {
  1138.         $requestContent = json_decode($request->getContent(), true);
  1139.         $this->filters = array("number" => $requestContent['number'], "company" => $requestContent['company']);
  1140.         $item = $invoicesManagement->load(null, $this->filters, $this->ordering);
  1141.         if (empty($item)) {
  1142.             return new JsonResponse(['isset' => false], JsonResponse::HTTP_OK);
  1143.         } else {
  1144.             return new JsonResponse(['isset' => true], JsonResponse::HTTP_OK);
  1145.         }
  1146.     }
  1148.     /**
  1149.      * @Route("/admin/faktury/ponaglenie1",  methods="POST")
  1150.      */
  1151.     function notify1(
  1152.         Request $request,
  1153.         InvoicesHelper $invoicesHelper,
  1154.         InvoicesManagement $invoicesManagement
  1155.     ) {
  1156.         $requestContent = json_decode($request->getContent(), true);
  1157.         $invoice = $invoicesManagement->load($requestContent['id'], array(), array());
  1158.         $invoice = $invoicesHelper->prepareInvoiceDetails($invoice);
  1159.         $tel =  $invoice['payer']->getPhone();
  1160.         // $tel =  '602850051'; 
  1161.         // dump($tel);
  1162.         // die();
  1163.         // $tel =  '727964646';
  1164.         $value = $invoice['grossValue'];
  1165.         $invoiceNumber = $invoice['number'];
  1166.         if ($invoice['type'] == "4") {
  1167.             $invoiceNumber = $invoice['service'];
  1168.             $item = "usługi";
  1169.         } else {
  1170.             $invoiceNumber = $invoice['number'];
  1171.             $item = "dokumentu";
  1172.         }
  1173.         $config = new \Doctrine\DBAL\Configuration();
  1174.         $connectionParams = array(
  1175.             'dbname' => 'gdbsmeskom31',
  1176.             'user' => 'dbguser24911',
  1177.             'password' => '4zkwNhjM',
  1178.             'host' => 'mysql1.smeskom.pl',
  1179.             'driver' => 'pdo_mysql',
  1180.             'charset' => 'utf8mb4'
  1181.         );
  1182.         if ($tel != '' && !is_null($tel)) {
  1183.             $conn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
  1185.             $sql = "INSERT INTO sms_out (send_after, msisdn, body) VALUES('', '" . $tel . "', 'Przypominamy o opłaceniu " . $item . " " . $invoiceNumber . " na kwotę " . $value . " zł netto. Prosimy o uregulowanie należności. Pozdrawamy serdecznie FREELINE.')";
  1186.             try {
  1187.                 $conn->query($sql);
  1188.                 $remind = new Reminders();
  1189.                 $remind->setCreatedDate(new \DateTime());
  1190.                 $remind->setType('1');
  1191.                 $remind->setClient($invoice['payer']->getId());
  1192.                 $entityManager = $this->getDoctrine()->getManager();
  1193.                 $entityManager->persist($remind);
  1194.                 $entityManager->flush();
  1195.             } catch (FileException $e) {
  1196.             }
  1197.             $invoicesManagement->setSum($requestContent['id'], $invoice['smsSum'] + 1, 1);
  1198.             return new JsonResponse(['message' => $this->translator->trans('Success sended SMS')], JsonResponse::HTTP_OK);
  1199.         } else {
  1200.             return new JsonResponse(['message' => $this->translator->trans('Empty phone number')], JsonResponse::HTTP_OK);
  1201.         }
  1202.     }
  1204.     /**
  1205.      * @Route("/admin/faktury/ponaglenie2",  methods="POST")
  1206.      */
  1207.     function notify2(
  1208.         Request $request,
  1209.         InvoicesHelper $invoicesHelper,
  1210.         InvoicesManagement $invoicesManagement,
  1211.         EmailHelper $emailHelper
  1212.     ) {
  1213.         $template = "notify2";
  1214.         $requestContent = json_decode($request->getContent(), true);
  1215.         $invoice = $invoicesManagement->load($requestContent['id'], array(), array());
  1216.         $invoice = $invoicesHelper->prepareInvoiceDetails($invoice);
  1218.         $value = $invoice['grossValue'];
  1219.         if ($invoice['type'] == "4") {
  1220.             $invoiceNumber = $invoice['service'];
  1221.             $template = "notify2g";
  1222.         } else {
  1223.             $invoiceNumber = $invoice['number'];
  1224.         }
  1225.         $clientEmail = $invoice['payer']->getEmail();
  1226.         // $clientEmail = 'piotr@freeline.pl,piotr.ostrzyzek@gmail.com';
  1227.         // $clientEmail = 'marek.szmit@freeline.pl';
  1228.         $formData = array(
  1229.             'invoiceNumber' => $invoiceNumber,
  1230.             'invoiceTotal' => $value,
  1231.             'clientName' => 'Paweł',
  1232.             'clientEmail' => $clientEmail,
  1233.             'subject' => 'WAŻNE - upłynął termin płatności dokumentu | Freeline',
  1234.             'fromEmail' => 'Rozliczenia | Freeline Agencja Interaktywna <rozliczenia@freeline.pl>',
  1235.             'bcc' => 'ponaglenia@freeline.pl'
  1236.         );
  1238.         try {
  1239.             $emailHelper->sendEmail($formData, $template);
  1240.             $remind = new Reminders();
  1241.             $remind->setCreatedDate(new \DateTime());
  1242.             ('active');
  1243.             $remind->setType('2');
  1244.             $remind->setClient($invoice['payer']->getId());
  1245.             $entityManager = $this->getDoctrine()->getManager();
  1246.             $entityManager->persist($remind);
  1247.             $entityManager->flush();
  1248.         } catch (FileException $e) {
  1249.         }
  1250.         $invoicesManagement->setSum($requestContent['id'], $invoice['emailSum'] + 1, 2);
  1251.         return new JsonResponse(['message' => $this->translator->trans('Success sended E-mail')], JsonResponse::HTTP_OK);
  1252.     }
  1254.         /**
  1255.      * @Route("/admin/faktury/usun-statusy",  methods="GET", name="admin_dump_all_invoices")
  1256.      */
  1257.     function dumpAllStatuses()
  1258.     {
  1259.         $items = $this->entityManager->getRepository(Invoices::class)->findBy(['customerPrio' => 'niebieski']);
  1260.         foreach ($items as $item) {
  1261.             $item->setCustomerPrio('neutralny');
  1262.             $entityManager = $this->getDoctrine()->getManager();
  1263.             $entityManager->persist($item);
  1264.             $entityManager->flush();
  1265.         }
  1266.         return $this->redirectToRoute('admin_invoices');
  1267.     }
  1272. }