1. <?php
3. namespace App\Controller;
5. use App\Entity\SalesInvoice;
6. use App\Entity\SalesInvoiceDetails;
7. use App\Entity\Country;
8. use App\Entity\Courier;
9. use App\Entity\ProductType;
10. use App\Entity\Customer;
11. use App\Entity\CourierWiseZone;
12. use App\Entity\ZoneWiseMasterRate;
13. use App\Entity\CountryWiseMasterRate;
14. use App\Entity\ZoneWiseSalesRate;
15. use App\Entity\ZoneWiseCommonSalesRate;
16. use App\Entity\CountryWiseSalesRate;
17. use App\Entity\CountryWiseCommonSalesRate;
18. use App\Entity\SettingsInfo;
19. use App\Entity\ZoneWiseCovidCharge;
20. use App\Entity\CountryWiseCovidCharge;
21. use App\Entity\ReceiveVoucher;
22. use App\Entity\AdditionalCharge;
23. use App\Entity\InvoiceAdditionalCharge;
24. use App\Entity\Shipment;
25. use App\Form\SalesInvoiceType;
26. use App\Form\SalesInvoiceDetailsType;
27. use App\Form\SalesInvoiceEditType;
28. use App\Form\InvoiceSurchargeType;
29. use App\Repository\SalesInvoiceRepository;
30. use App\Repository\SettingsInfoRepository;
31. use App\Repository\CountryRepository;
32. use App\Repository\CourierRepository;
33. use App\Repository\ProductTypeRepository;
34. use App\Repository\SalesInvoiceDetailsRepository;
35. use App\Repository\ReceiveVoucherRepository;
36. use App\Repository\AccountNameRepository;
37. use App\Repository\ShipmentRepository;
38. use App\Repository\CustomerRepository;
39. use App\Repository\CourierWiseZoneRepository;
40. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
41. use Symfony\Component\HttpFoundation\Request;
42. use Symfony\Component\HttpFoundation\Response;
43. use Symfony\Component\Routing\Annotation\Route;
44. use Symfony\Component\Form\Extension\Core\Type\TextType;
45. use App\Service\UtilsService;
46. use Doctrine\ORM\EntityManagerInterface;
47. use Symfony\Component\HttpFoundation\JsonResponse;
48. use Doctrine\Common\Collections\ArrayCollection;
49. use Dompdf\Dompdf;
50. use Dompdf\Options;
51. use Symfony\Component\Form\Extension\Core\Type\FileType;
52. use Symfony\Component\String\Slugger\SluggerInterface;
53. use Symfony\Component\HttpFoundation\File\Exception\FileException;
54. use Symfony\Component\Validator\Constraints\File;
55. use PhpOffice\PhpSpreadsheet\IOFactory;
56. use Symfony\Bridge\Doctrine\Form\Type\EntityType;
57. use Symfony\Component\Form\Extension\Core\Type\DateType;
58. use Symfony\Component\HttpFoundation\Session\Session;
59. use Dompdf\FontMetrics; 
60. use DateTime; 
61. use Symfony\Component\Security\Http\Attribute\IsGranted;
62. use Symfony\Component\Form\Extension\Core\Type\HiddenType;
64. #[IsGranted("ROLE_ACCOUNTS")]
65. class SalesInvoiceController extends AbstractController
66. {
67.     #[Route('/{page<[1-9]\d*>}', defaults: ['page' => '1'], name: 'app_sales_invoice_index', methods: ['GET', 'POST'])]
68.     #[IsGranted("ROLE_ACCOUNTS")]
69.     public function index(Request $request, int $page, SalesInvoiceRepository $salesInvoiceRepository): Response
70.     {
71.         $form = $this->createFormBuilder(null)
72.             ->add('customer',TextType::class, [       
73.                 'attr' => ['class' => 'form-control',
74.                 'placeholder' => 'Search by Customer',
75.             ],
76.                 'label' => false,
77.                 'required' => false,                
78.             ])
79.             ->add('invoiceNo',TextType::class, [       
80.                 'attr' => ['class' => 'form-control',
81.                 'placeholder' => 'Search by Invoice No',
82.             ],
83.                 'label' => false,
84.                 'required' => false,                
85.             ])
86.             ->add('hawbno',TextType::class, [       
87.                 'attr' => ['class' => 'form-control',
88.                 'placeholder' => 'Search by Hawb No'
89.             ],
90.                 'label' => false,
91.                 'required' => false,                
92.             ])
93.             ->getForm();
95.         $form->handleRequest($request);
96.         $session = new Session();  
97.         
98.         if ($form->isSubmitted() && $form->isValid()) {
99.             // data is an array with "name", "email", and "message" keys
100.             // $data = $form->getData();            
101.             // $filter = $data['search'];
103.             $data = $form->getData();                     
104.             $customer =  $form->get('customer')->getData() !== null ? $form->get('customer')->getData() : "";
105.             $invoiceNo =  $form->get('invoiceNo')->getData() !== null ? $form->get('invoiceNo')->getData() : "";
106.             $hawbNO = $form->get('hawbno')->getData() !== null ? $form->get('hawbno')->getData() : "";
107.             $page = 1;
108.                         
109.             if(isset($customer))
110.             {               
111.                 // set and get session attributes
112.                 $session->set('exp_clt_customer', $customer);
113.                 
114.             }
115.                            
116.             $sales_invoices = $salesInvoiceRepository->findAllSalesInvoice($customer, $invoiceNo, $hawbNO, 1, $this->getUser()->getUserCompany()->getId(), $page);
117.             
118.             return $this->render('sales_invoice/index.html.twig', [
119.                 'sales_invoices' => $sales_invoices,
120.                 'form' => $form->createView(),
121.             ]);
122.         }
124.         $customer = "";
125.         if($page > 1)
126.         {            
127.             $customer = $session->get('exp_clt_customer');
128.         }
129.         else
130.         {
131.             $session->remove('exp_clt_customer');                
132.         }
133.         
134.         $sales_invoices = $salesInvoiceRepository->findAllSalesInvoice($customer === null ? "" : $customer, "", "", 1, $this->getUser()->getUserCompany()->getId(), $page);
136.         return $this->render('sales_invoice/index.html.twig', [
137.             'sales_invoices' => $sales_invoices,
138.             'form' => $form->createView(),
139.         ]);
140.     }
142.     #[Route('/salesinvoice/new', name: 'app_sales_invoice_new', methods: ['GET', 'POST'])]
143.     #[IsGranted("ROLE_ACCOUNTS")]
144.     public function new(Request $request, SalesInvoiceRepository $salesInvoiceRepository, UtilsService $utilsService, EntityManagerInterface $entityManager, SettingsInfoRepository $settingsInfoRepository, ReceiveVoucherRepository $receiveVoucherRepository, AccountNameRepository $accountNameRepository): Response
145.     {
146.         $gloPaymentReceived = -1;
147.         $salesInvoice = new SalesInvoice();
148.         $salesInvoice->setInvoiceDate(new \DateTime("now", new \DateTimeZone("Asia/Dhaka")));
149.       
150.         $form = $this->createForm(SalesInvoiceType::class, $salesInvoice);                     
151.         $form->handleRequest($request);
153.         $salesInvoiceDetails = new SalesInvoiceDetails();
154.         $formDet = $this->createForm(SalesInvoiceDetailsType::class, $salesInvoiceDetails);
155.         $formDet->handleRequest($request);
156.        
157.         if ($request->isXMLHttpRequest()) {
158.             $salesInvoiceObj = $request->request->get('salesInvoiceObj');            
159.             if (!empty($salesInvoiceObj)) {
160.                
161.                 $salesInvoiceObj_array = json_decode($salesInvoiceObj, true);
162.                
163.                 $hawbNo_array = json_decode($request->request->get('hawbNo'));
164.                 $reference_array = json_decode($request->request->get('reference'));
165.                 $country_array = json_decode($request->request->get('country'));
166.                 $courier_array = json_decode($request->request->get('courier'));
167.                 $productType_array = json_decode($request->request->get('productType'));
168.                 $weight_array = json_decode($request->request->get('weight'));
169.                 $bookingWeight_array = json_decode($request->request->get('bookingWeight'));
170.                 $bookingRate_array = json_decode($request->request->get('bookingRate'));
171.                 $salesRate_array = json_decode($request->request->get('salesRate'));
172.                // $agent_array = json_decode($request->request->get('agent'));
173.                // var_dump($accountNameId_array); die();
174.               
175.                $salesInvoiceDetailsList = new ArrayCollection();
176.                $gloPaymentReceived = $salesInvoiceObj_array['PaymentReceived'];
178.                $index = 0;               
179.                foreach($hawbNo_array as $key=>$Row) 
180.                {
181.                    $keyValue = $key;
182.                    $keyValue = $keyValue + 1;
183.                   
184.                    $salesInvoiceDetailsObj = new SalesInvoiceDetails();
185.                    
186.                    $salesInvoiceDetObj = $entityManager->getRepository(SalesInvoiceDetails::class)
187.                                                        ->findOneBy(['hawbNo' => $hawbNo_array[$index]]);                              
188.                    if($salesInvoiceDetObj !== null)
189.                    {
190.                         return new JsonResponse(array('success' => false, 'responseText' => 'Duplicate HAWB Number : '. $hawbNo_array[$index].' in Row Number '.$keyValue.'.'));
191.                    }
192.                    
193.                    $salesInvoiceDetailsObj->setShipmentDate(new \DateTime($salesInvoiceObj_array['ShipmentDate']));
194.                    $salesInvoiceDetailsObj->setHawbNo($hawbNo_array[$index]);
195.                    $salesInvoiceDetailsObj->setReference($reference_array[$index]);
197.                    $countryObj = $entityManager->find(Country::class, $country_array[$index]);                  
198.                    $salesInvoiceDetailsObj->setCountry($countryObj);
200.                    $courierObj = $entityManager->find(Courier::class, $courier_array[$index]);                
201.                    $salesInvoiceDetailsObj->setCourier($courierObj);
202.                    
203.                    $productTypeObj = $entityManager->find(ProductType::class, $productType_array[$index]);                 
204.                    $salesInvoiceDetailsObj->setProductType($productTypeObj);
206.                    $customerObj = $entityManager->find(Customer::class, $salesInvoiceObj_array['CustomerId']);                 
207.                    $salesInvoiceDetailsObj->setCustomer($customerObj);
209.                    $salesInvoiceDetailsObj->setWeight($weight_array[$index]);
210.                    $salesInvoiceDetailsObj->setBookingWeight($bookingWeight_array[$index]);
211.                    $salesInvoiceDetailsObj->setRateApplicable($salesInvoiceObj_array['RateApplicable']);
213.                   // return new JsonResponse(array('success' => false, 'responseText' => $salesInvoiceObj_array['InvoiceApplicable']  ));
214.                   // $salesInvoiceDetailsObj->setInvoiceStatus($salesInvoiceObj_array['InvoiceApplicable']);
215.                                    
216.                    //Zone Assign Start
217.                 //    if($courier_array[$index] < 0)
218.                 //    {
219.                         $courierWiseZoneObj = $entityManager->getRepository(CourierWiseZone::class)
220.                                                             ->findOneBy(['courier' => $courier_array[$index], 'country' => $country_array[$index] ]);                       
221.                         if($courierWiseZoneObj === null )
222.                         {
223.                                 return new JsonResponse(array('success' => false, 'responseText' => 'Courier Wise Zone is not set for Courier : '. $courierObj->getName().', and Country : '.$countryObj->getName().' in Row Number '.$keyValue.'.'));
224.                         }
225.                         $salesInvoiceDetailsObj->setZone($courierWiseZoneObj->getZone());
226.                         //return new JsonResponse(array('success' => false, 'responseText' => $courierWiseZoneObj->getZone() ));
227.                 //    }
228.                 //    else
229.                 //    {
230.                 //     $courierWiseZoneObj = $this->getDoctrine()
231.                 //             ->getRepository(CourierWiseZone::class)
232.                 //             ->find(1);
233.                 //    }
234.                    //Zone Assign End
236.                    //Customer Weight Calculation Start 
237.                    // Half and Per KG
238.                    $weight = trim($weight_array[$index]);
239.                    $pointInputWeight = $weight - floor($weight);
240.                    $intInputWeight = floor($weight);
241.                    $finalWeight = 0;
242.                    $rateWeight = 0;
243.                    if($weight <  $courierObj->getWeightPerkg())
244.                    {
245.                        if($pointInputWeight > 0 && $pointInputWeight <= 0.5)
246.                        {
247.                            $finalWeight = (float)0.5;
248.                        }
249.                        elseif($pointInputWeight > 0.5 && $pointInputWeight <=1)
250.                        {
251.                            $finalWeight = (float)1;
252.                        }
253.                    }
254.                    else
255.                    {
256.                        if($pointInputWeight > 0 && $pointInputWeight <=1)
257.                        {
258.                            $finalWeight = (float)1;
259.                        }
260.                    }
261.                    $rateWeight = $intInputWeight + $finalWeight;
263.                    //Only Per KG
264.                    $pointInputPerKgWeight = $weight - floor($weight);
265.                    $intInputPerKgWeight = floor($weight);
266.                    $finalPerKgWeight = 0;
267.                    $ratePerKgWeight = 0;
268.                    if($pointInputPerKgWeight > 0 && $pointInputPerKgWeight <=1)
269.                    {
270.                        $finalPerKgWeight = (float)1;
271.                    }
272.                    $ratePerKgWeight = $intInputPerKgWeight + $finalPerKgWeight;
273.                    //Customer Weight Calculation End
275.                    //Vendor/Booking weight Calculation Start 
276.                    // Half and Per KG
277.                    $bookingWeight = trim($bookingWeight_array[$index]);
278.                    $pointInputBookingWeight = $bookingWeight - floor($bookingWeight);
279.                    $intInputBookingWeight = floor($bookingWeight);
280.                    $finalBookingWeight = 0;
281.                    $rateBookingWeight = 0;
282.                    if($bookingWeight <  $courierObj->getWeightPerkg())
283.                    {
284.                        if($pointInputBookingWeight > 0 && $pointInputBookingWeight <= 0.5)
285.                        {
286.                            $finalBookingWeight = (float)0.5;
287.                        }
288.                        elseif($pointInputBookingWeight > 0.5 && $pointInputBookingWeight <=1)
289.                        {
290.                            $finalBookingWeight = (float)1;
291.                        }
292.                    }
293.                    else
294.                    {
295.                        if($pointInputBookingWeight > 0 && $pointInputBookingWeight <=1)
296.                        {
297.                            $finalBookingWeight = (float)1;
298.                        }
299.                    }
300.                    $rateBookingWeight = $intInputBookingWeight + $finalBookingWeight;
302.                    //Only Per KG
303.                    $pointInputPerKgBookingWeight = $bookingWeight - floor($bookingWeight);
304.                    $intInputPerKgBookingWeight = floor($bookingWeight);
305.                    $finalPerKgBookingWeight = 0;
306.                    $ratePerKgBookingWeight = 0;
307.                    if($pointInputPerKgBookingWeight > 0 && $pointInputPerKgBookingWeight <=1)
308.                    {
309.                        $finalPerKgBookingWeight = (float)1;
310.                    }
311.                    $ratePerKgBookingWeight = $intInputPerKgBookingWeight + $finalPerKgBookingWeight;
312.                    //Weight Calculation End
314.                    if($salesInvoiceObj_array['RateApplicable'] == 1)  // Predefine Rate
315.                    {
316.                         //Master Rate Assign Start       
317.                         $finalMasterRateCal = 0;                 
318.                         $perKgRateWeight = $courierObj->getWeightPerkgRate();
319.                         if($rateBookingWeight < $perKgRateWeight )
320.                         {
321.                             $zoneWiseMasterRate = $entityManager->getRepository(ZoneWiseMasterRate::class)
322.                                                     ->findBookingRatebyCourierAndWeight($courierObj->getId(), $courierWiseZoneObj->getZone(), $productTypeObj->getId(), $rateBookingWeight);                       
323.                             
324.                             if($zoneWiseMasterRate !== null)      
325.                             { 
326.                                 $finalMasterRateCal = $zoneWiseMasterRate->getRate();
327.                             }
328.                         }
329.                         else
330.                         {
331.                             $zoneWiseMasterRate = $entityManager->getRepository(ZoneWiseMasterRate::class)
332.                                                     ->findBookingRatebyCourierAndWeight($courierObj->getId(), $courierWiseZoneObj->getZone(), $productTypeObj->getId(), $rateBookingWeight);                     
333.                             if($zoneWiseMasterRate !== null)      
334.                             { 
335.                                 $finalMasterRateCal = $zoneWiseMasterRate->getRate() * $rateBookingWeight;                                
336.                             }
337.                         }
339.                         if($zoneWiseMasterRate === null)  
340.                         {
341.                             if($rateBookingWeight < $perKgRateWeight )
342.                             { 
343.                                 $countryWiseMasterRate = $entityManager->getRepository(CountryWiseMasterRate::class)
344.                                                             ->findOneBy(['courier' => $courierObj->getId(), 'country' => $countryObj->getId(), 'productType' => $productTypeObj->getId(), 'weight' => $rateBookingWeight ]);                                          
346.                                 if($countryWiseMasterRate !== null) 
347.                                 { 
348.                                     $finalMasterRateCal =  $countryWiseMasterRate->getRate();
349.                                 }                           
350.                             }
351.                             else
352.                             {
353.                                 $countryWiseMasterRate = $entityManager->getRepository(CountryWiseMasterRate::class)
354.                                                             ->findOneBy(['courier' => $courierObj->getId(), 'country' => $countryObj->getId(), 'productType' => $productTypeObj->getId(), 'weight' => $perKgRateWeight ]);                           
355.                                 if($countryWiseMasterRate !== null) 
356.                                 { 
357.                                     $finalMasterRateCal = $countryWiseMasterRate->getRate() * $rateBookingWeight;                                    
358.                                 }
359.                             }
360.                         }        
362.                         if($zoneWiseMasterRate !== null)
363.                         {
364.                             $salesInvoiceDetailsObj->setBookingRate($finalMasterRateCal);                            
365.                         }
366.                         else if($countryWiseMasterRate !== null)
367.                         {
368.                             $salesInvoiceDetailsObj->setBookingRate($finalMasterRateCal);                            
369.                         }
370.                         else
371.                         {                                   
372.                             return new JsonResponse(array('success' => false, 'responseText' => 'Master Rate is not set for Courier : '.$courierObj->getName().', Country : '.$countryObj->getName().', Product Type : '.$productTypeObj->getName().', Weight : '.$rateWeight.' in Row Number '.$keyValue.'.'));
373.                         }
374.                         
375.                         //Master Rate Assign End
377.                         //Sales Rate Assign Start 
378.                         // if($customerObj->getRateCurrency() == 2)
379.                         // {
380.                         //     $perKgRateWeight = 21;
381.                         // }
383.                         $finalRateCal = 0;
385.                         // Own Company Rate for Customer Start
386.                         $salesCourierId = 0;
387.                         $salesCourierName = "";
388.                         if($this->getUser()->getUserCompany()->getCustomerRate() == 2 ) // Own Company Wise Customer Rate
389.                         {
390.                             if($customerObj->getCustomerType() == 1 )  //Customer
391.                             {
392.                                 $salesCourierId = $this->getUser()->getUserCompany()->getCompanyCourier()->getId();
393.                                 $salesCourierName = $this->getUser()->getUserCompany()->getCompanyCourier()->getName();
394.                                 return new JsonResponse(array('success' => false, 'responseText' => 1 ));
395.                             }
396.                             else  //Agent
397.                             {
398.                                 $salesCourierId = $courierObj->getId();
399.                                 $salesCourierName = $courierObj->getName();
400.                                 return new JsonResponse(array('success' => false, 'responseText' => 2 ));
401.                             }
402.                         }
403.                         else   // Separate Courier Wise Customer Rate
404.                         {
405.                             $salesCourierId = $courierObj->getId();
406.                             $salesCourierName = $courierObj->getName();
407.                             return new JsonResponse(array('success' => false, 'responseText' => 3 ));
408.                         }
409.                         // Own Company Rate for Customer End
412.                         if($customerObj->getRateType() == 1)  // Customer wise sales rate     
413.                         {                         
414.                             if($rateWeight < $perKgRateWeight )
415.                             {
416.                                 $zoneWiseSalesRate = $entityManager->getRepository(ZoneWiseSalesRate::class)
417.                                                         ->findSalesRatebyCustomerAndWeight($customerObj->getId(), $salesCourierId, $courierWiseZoneObj->getZone(), $productTypeObj->getId(), $rateWeight);                                     
418.                                 if($zoneWiseSalesRate !== null)     
419.                                 {                         
420.                                     $finalRateCal = $zoneWiseSalesRate->getRate();
421.                                 }
422.                             }
423.                             else
424.                             {                                                                       
425.                                 $zoneWiseSalesRate = $entityManager->getRepository(ZoneWiseSalesRate::class)
426.                                                         ->findSalesRatebyCustomerAndWeight($customerObj->getId(), $salesCourierId, $courierWiseZoneObj->getZone(), $productTypeObj->getId(), $rateWeight);                       
427.                                 
428.                                 if($zoneWiseSalesRate !== null)     
429.                                 { 
430.                                     $finalRateCal = $zoneWiseSalesRate->getRate() * $rateWeight;                                      
431.                                 }
432.                             }
434.                             if($zoneWiseSalesRate === null)  
435.                             {
436.                                 if($rateWeight < $perKgRateWeight )
437.                                 { 
438.                                     $countryWiseSalesRate = $entityManager->getRepository(CountryWiseSalesRate::class)
439.                                                             ->findOneBy(['customer' => $customerObj->getId(), 'courier' => $salesCourierId, 'country' => $countryObj->getId(), 'productType' => $productTypeObj->getId(), 'weight' => $rateWeight ]);                                        
440.                                     if($countryWiseSalesRate !== null)     
441.                                     {                         
442.                                         $finalRateCal = $countryWiseSalesRate->getRate();
443.                                     }
444.                                 }
445.                                 else
446.                                 {
447.                                     $countryWiseSalesRate = $entityManager->getRepository(CountryWiseSalesRate::class)
448.                                                             ->findOneBy(['customer' => $customerObj->getId(), 'courier' => $salesCourierId, 'country' => $countryObj->getId(), 'productType' => $productTypeObj->getId(), 'weight' => $perKgRateWeight ]);                           
449.                                     if($countryWiseSalesRate !== null)     
450.                                     { 
451.                                         $finalRateCal = $countryWiseSalesRate->getRate() * $rateWeight;                                            
452.                                     }
453.                                 }
454.                             }        
456.                             if($zoneWiseSalesRate !== null)
457.                             {
458.                                 $salesInvoiceDetailsObj->setSalesRate($finalRateCal);
459.                                 
460.                             }
461.                             else if($countryWiseSalesRate !== null)
462.                             {
463.                                 $salesInvoiceDetailsObj->setSalesRate($finalRateCal);                                    
464.                             }
465.                             else
466.                             {                                   
467.                                 return new JsonResponse(array('success' => false, 'responseText' => 'Customer Wise Sales Rate is not set for Customer '.$customerObj->getName().' Courier : '.$salesCourierName.', Country : '.$countryObj->getName().', Product Type : '.$productTypeObj->getName().', Weight : '.$rateWeight.' in Row Number '.$keyValue.'.'));
468.                             }
469.                         }
470.                         else  // Common sales rate   
471.                         {
472.                                 if($rateWeight < $perKgRateWeight )
473.                                 {
474.                                     $zoneWiseSalesRate = $entityManager->getRepository(ZoneWiseCommonSalesRate::class)
475.                                                             ->findCommonSalesRatebyCourierAndWeight($salesCourierId, $courierWiseZoneObj->getZone(), $productTypeObj->getId(), $rateWeight);                                     
476.                                 }
477.                                 else
478.                                 {
479.                                     $zoneWiseSalesRate = $entityManager->getRepository(ZoneWiseCommonSalesRate::class)
480.                                                             ->findCommonSalesRatebyCourierAndWeight($salesCourierId, $courierWiseZoneObj->getZone(), $productTypeObj->getId(), $perKgRateWeight);                       
481.                                     if($zoneWiseSalesRate !== null)     
482.                                     {       
483.                                         $zoneWiseSalesRate->setRate($zoneWiseSalesRate->getRate() * $rateWeight);
484.                                     }
485.                                 }
487.                                 if($zoneWiseSalesRate === null)  
488.                                 {
489.                                     if($rateWeight < $perKgRateWeight )
490.                                     { 
491.                                         $countryWiseSalesRate = $entityManager->getRepository(CountryWiseCommonSalesRate::class)
492.                                                                 ->findOneBy(['courier' => $salesCourierId, 'country' => $countryObj->getId(), 'productType' => $productTypeObj->getId(), 'weight' => $rateWeight ]);                           
493.                                     }
494.                                     else
495.                                     {
496.                                         $countryWiseSalesRate = $entityManager->getRepository(CountryWiseCommonSalesRate::class)
497.                                                                 ->findOneBy(['courier' => $salesCourierId, 'country' => $countryObj->getId(), 'productType' => $productTypeObj->getId(), 'weight' => $perKgRateWeight ]);                           
498.                                         if($countryWiseSalesRate !== null)     
499.                                         {   
500.                                             $countryWiseSalesRate->setRate($countryWiseSalesRate->getRate() * $rateWeight);
501.                                         }
502.                                     }
503.                                 }        
505.                                 if($zoneWiseSalesRate !== null)
506.                                 {
507.                                     $salesInvoiceDetailsObj->setSalesRate($zoneWiseSalesRate->getRate());
508.                                 }
509.                                 else if($countryWiseSalesRate !== null)
510.                                 {
511.                                     $salesInvoiceDetailsObj->setSalesRate($countryWiseSalesRate->getRate());
512.                                 }
513.                                 else
514.                                 {                                   
515.                                     return new JsonResponse(array('success' => false, 'responseText' => 'Common Sales Rate is not set for Courier : '.$salesCourierName.', Country : '.$countryObj->getName().', Product Type : '.$productTypeObj->getName().', Weight : '.$rateWeight.' in Row Number '.$keyValue.'.'));
516.                                 }
517.                         }
518.                         //Sales Rate Assign End
519.                        
520.                     }
521.                     else  // Special Calculated Rate
522.                     {
523.                         $salesInvoiceDetailsObj->setBookingRate($bookingRate_array[$index]);
524.                         $salesInvoiceDetailsObj->setSalesRate($salesRate_array[$index]);                        
525.                     }
528.                     // if($salesInvoiceObj_array['RateApplicable'] <= 2)  // Predefine Rate
529.                     // {
530.                     //     if($customerObj->getRateCurrency() == 2)
531.                     //     {
532.                     //         $salesInvoiceDetailsObj->setCovidCharge(0);
533.                     //     }
534.                     //     else
535.                     //     {
536.                     //         //Covid Charge Cal Start
537.                     //         if($courierObj->getCovidChargeApplicable() == 1 && $courierObj->getId() == 1)  // DHL Covid Charge Cal
538.                     //         {
539.                     //             $zoneWiseCovidCharge = $entityManager->getRepository(ZoneWiseCovidCharge::class)
540.                     //                                 ->findOneBy(['courier' => $courierObj->getId(), 'zone' => $courierWiseZoneObj->getZone() ]); 
542.                     //             if($zoneWiseCovidCharge === null)
543.                     //             {
544.                     //                 $countryWiseCovidCharge = $entityManager->getRepository(CountryWiseCovidCharge::class)
545.                     //                                         ->findOneBy(['courier' => $courierObj->getId(), 'country' => $countryObj->getId() ]);                           
546.                     //             }
548.                     //             if($zoneWiseCovidCharge !== null)
549.                     //             {                            
550.                     //                 $salesInvoiceDetailsObj->setCovidCharge($rateWeight <= 1 ? $zoneWiseCovidCharge->getRate() : $zoneWiseCovidCharge->getRate() * $rateWeight);
551.                     //                 $salesInvoiceDetailsObj->setVendorCovidCharge($rateBookingWeight <= 1 ? $zoneWiseCovidCharge->getRate() : $zoneWiseCovidCharge->getRate() * $rateBookingWeight);
552.                     //             }
553.                     //             else if($countryWiseCovidCharge !== null)
554.                     //             {                          
555.                     //                 $salesInvoiceDetailsObj->setCovidCharge($countryWiseCovidCharge->getRate() * $ratePerKgWeight);
556.                     //             }
557.                     //             else
558.                     //             {
559.                     //                 return new JsonResponse(array('success' => false, 'responseText' => 'Covid Charge is not set for Courier : '.$courierObj->getName().', Country : '.$countryObj->getName().' in Row Number '.$keyValue.'.'));
560.                     //             }
561.                                     
562.                     //         }
563.                     //         else if($courierObj->getCovidChargeApplicable() == 1 && $courierObj->getId() == 2) // Fedex Covid Charge Cal
564.                     //         {
565.                     //             if($courierWiseZoneObj->getZone()->getId() == 16 || $courierWiseZoneObj->getZone()->getId() == 18) // Zone G & I
566.                     //             {
567.                     //                 if($rateWeight <= 1)
568.                     //                 {
569.                     //                     $salesInvoiceDetailsObj->setCovidCharge(1);
570.                     //                     $salesInvoiceDetailsObj->setVendorCovidCharge(1);
571.                     //                 }
572.                     //                 else
573.                     //                 {
574.                     //                     $zoneWiseCovidCharge = $entityManager->getRepository(ZoneWiseCovidCharge::class)
575.                     //                                         ->findOneBy(['courier' => $courierObj->getId(), 'zone' => $courierWiseZoneObj->getZone() ]); 
576.                     //                     if($zoneWiseCovidCharge !== null)
577.                     //                     {                            
578.                     //                         $salesInvoiceDetailsObj->setCovidCharge($zoneWiseCovidCharge->getRate() * $rateWeight);
579.                     //                         $salesInvoiceDetailsObj->setVendorCovidCharge($zoneWiseCovidCharge->getRate() * $rateBookingWeight);
580.                     //                     }                         
581.                     //                     else
582.                     //                     {
583.                     //                         return new JsonResponse(array('success' => false, 'responseText' => 'Covid Charge is not set for Courier : '.$courierObj->getName().', Country : '.$countryObj->getName().' in Row Number '.$keyValue.'.'));
584.                     //                     }
585.                     //                 }
586.                     //             }
587.                     //             else if($courierWiseZoneObj->getZone()->getId() == 17) // Zone H
588.                     //             {
589.                     //                 if($rateWeight <= 1)
590.                     //                 {
591.                     //                     $salesInvoiceDetailsObj->setCovidCharge(2);
592.                     //                     $salesInvoiceDetailsObj->setVendorCovidCharge(2);
593.                     //                 }
594.                     //                 else
595.                     //                 {
596.                     //                     $zoneWiseCovidCharge = $entityManager->getRepository(ZoneWiseCovidCharge::class)
597.                     //                                         ->findOneBy(['courier' => $courierObj->getId(), 'zone' => $courierWiseZoneObj->getZone() ]); 
598.                     //                     if($zoneWiseCovidCharge !== null)
599.                     //                     {                            
600.                     //                         $salesInvoiceDetailsObj->setCovidCharge($zoneWiseCovidCharge->getRate() * $rateWeight);
601.                     //                         $salesInvoiceDetailsObj->setVendorCovidCharge($zoneWiseCovidCharge->getRate() * $rateBookingWeight);
602.                     //                     }                         
603.                     //                     else
604.                     //                     {
605.                     //                         return new JsonResponse(array('success' => false, 'responseText' => 'Covid Charge is not set for Courier : '.$courierObj->getName().', Country : '.$countryObj->getName().' in Row Number '.$keyValue.'.'));
606.                     //                     }
607.                     //                 }
608.                     //             }
609.                     //             else
610.                     //             {
611.                     //                 if($rateWeight < 5)
612.                     //                 {
613.                     //                     $salesInvoiceDetailsObj->setCovidCharge(1);
614.                     //                     $salesInvoiceDetailsObj->setVendorCovidCharge(1);
615.                     //                 }
616.                     //                 else
617.                     //                 {
618.                     //                     $zoneWiseCovidCharge = $entityManager->getRepository(ZoneWiseCovidCharge::class)
619.                     //                                         ->findOneBy(['courier' => $courierObj->getId(), 'zone' => $courierWiseZoneObj->getZone() ]); 
620.                     //                     if($zoneWiseCovidCharge !== null)
621.                     //                     {                            
622.                     //                         $salesInvoiceDetailsObj->setCovidCharge($zoneWiseCovidCharge->getRate() * $rateWeight);
623.                     //                         $salesInvoiceDetailsObj->setVendorCovidCharge($zoneWiseCovidCharge->getRate() * $rateBookingWeight);
624.                     //                     }                         
625.                     //                     else
626.                     //                     {
627.                     //                         return new JsonResponse(array('success' => false, 'responseText' => 'Covid Charge is not set for Courier : '.$courierObj->getName().', Country : '.$countryObj->getName().' in Row Number '.$keyValue.'.'));
628.                     //                     }
629.                     //                 }
630.                     //             }
631.                             
632.                     //         }
633.                     //         //Covid Charge Cal End
634.                     //     }
635.                        
636.                     // }
637.                     // else
638.                     // {
639.                     //     $salesInvoiceDetailsObj->setCovidCharge(0);
640.                     // }
642.                     //Covid Charge Cal Start
643.                     if($courierObj->getCovidChargeApplicable() == 1 && $courierObj->getId() == 1)  // DHL Covid Charge Cal
644.                     {
645.                         $zoneWiseCovidCharge = $entityManager->getRepository(ZoneWiseCovidCharge::class)
646.                                             ->findOneBy(['courier' => $courierObj->getId(), 'zone' => $courierWiseZoneObj->getZone() ]); 
648.                         if($zoneWiseCovidCharge === null)
649.                         {
650.                             $countryWiseCovidCharge = $entityManager->getRepository(CountryWiseCovidCharge::class)
651.                                                     ->findOneBy(['courier' => $courierObj->getId(), 'country' => $countryObj->getId() ]);                           
652.                         }
654.                         // Vendor Covid Charge Start                       
655.                         if($zoneWiseCovidCharge !== null)
656.                         {                   
657.                             $salesInvoiceDetailsObj->setVendorCovidCharge($rateBookingWeight <= 1 ? $zoneWiseCovidCharge->getRate() : $zoneWiseCovidCharge->getRate() * $rateBookingWeight);
658.                         }
659.                         else if($countryWiseCovidCharge !== null)
660.                         {                          
661.                             $salesInvoiceDetailsObj->setVendorCovidCharge($countryWiseCovidCharge->getRate() * $ratePerKgWeight);
662.                         }
663.                         else
664.                         {
665.                             return new JsonResponse(array('success' => false, 'responseText' => 'Covid Charge is not set for Courier : '.$courierObj->getName().', Country : '.$countryObj->getName().' in Row Number '.$keyValue.'.'));
666.                         }
667.                         // Vendor Covid Charge End   
669.                         //Customer Covid Charge Start       
670.                         if($salesInvoiceObj_array['RateApplicable'] <= 2)  // Predefine Rate
671.                         {
672.                             if($customerObj->getRateCurrency() == 2)
673.                             {
674.                                 $salesInvoiceDetailsObj->setCovidCharge(0);
675.                             }
676.                             else
677.                             {
678.                                 if($zoneWiseCovidCharge !== null)
679.                                 {                            
680.                                     $salesInvoiceDetailsObj->setCovidCharge($rateWeight <= 1 ? $zoneWiseCovidCharge->getRate() : $zoneWiseCovidCharge->getRate() * $rateWeight);                                    
681.                                 }
682.                                 else if($countryWiseCovidCharge !== null)
683.                                 {                          
684.                                     $salesInvoiceDetailsObj->setCovidCharge($countryWiseCovidCharge->getRate() * $ratePerKgWeight);
685.                                 }
686.                             }
687.                         }
688.                         else
689.                         {
690.                             $salesInvoiceDetailsObj->setCovidCharge(0);
691.                         }
692.                         //Customer Covid Charge End       
693.                             
694.                     }
695.                     else if($courierObj->getCovidChargeApplicable() == 1 && $courierObj->getId() == 2) // Fedex Covid Charge Cal
696.                     {
697.                         if($courierWiseZoneObj->getZone()->getId() == 16 || $courierWiseZoneObj->getZone()->getId() == 18) // Zone G & I
698.                         {
699.                             // Vendor Covid Charge Start
700.                             if($rateWeight <= 1)
701.                             {                                
702.                                 $salesInvoiceDetailsObj->setVendorCovidCharge(1);
703.                             }
704.                             else
705.                             {
706.                                 $zoneWiseCovidCharge = $entityManager->getRepository(ZoneWiseCovidCharge::class)
707.                                                     ->findOneBy(['courier' => $courierObj->getId(), 'zone' => $courierWiseZoneObj->getZone() ]); 
708.                                 if($zoneWiseCovidCharge !== null)
709.                                 {                           
710.                                     $salesInvoiceDetailsObj->setVendorCovidCharge($zoneWiseCovidCharge->getRate() * $rateBookingWeight);
711.                                 }                         
712.                                 else
713.                                 {
714.                                     return new JsonResponse(array('success' => false, 'responseText' => 'Covid Charge is not set for Courier : '.$courierObj->getName().', Country : '.$countryObj->getName().' in Row Number '.$keyValue.'.'));
715.                                 }
716.                             }
717.                             // Vendor Covid Charge Start
719.                             // Customer Covid Charge Start
720.                             if($salesInvoiceObj_array['RateApplicable'] <= 2)  // Predefine Rate
721.                             {
722.                                 if($customerObj->getRateCurrency() == 2)
723.                                 {
724.                                     $salesInvoiceDetailsObj->setCovidCharge(0);
725.                                 }
726.                                 else
727.                                 {
728.                                     if($rateWeight <= 1)
729.                                     {
730.                                         $salesInvoiceDetailsObj->setCovidCharge(1);
731.                                         
732.                                     }
733.                                     else
734.                                     {
735.                                         $zoneWiseCovidCharge = $entityManager->getRepository(ZoneWiseCovidCharge::class)
736.                                                             ->findOneBy(['courier' => $courierObj->getId(), 'zone' => $courierWiseZoneObj->getZone() ]); 
737.                                         if($zoneWiseCovidCharge !== null)
738.                                         {                            
739.                                             $salesInvoiceDetailsObj->setCovidCharge($zoneWiseCovidCharge->getRate() * $rateWeight);
740.                                             
741.                                         }                
742.                                     
743.                                     }
744.                                 }
745.                             }
746.                             else
747.                             {
748.                                 $salesInvoiceDetailsObj->setCovidCharge(0);
749.                             }
750.                             // Customer Covid Charge End
751.                         }
752.                         else if($courierWiseZoneObj->getZone()->getId() == 17) // Zone H
753.                         {
754.                             // Vendor Covid Charge Start
755.                             if($rateWeight <= 1)
756.                             {                                
757.                                 $salesInvoiceDetailsObj->setVendorCovidCharge(2);
758.                             }
759.                             else
760.                             {
761.                                 $zoneWiseCovidCharge = $entityManager->getRepository(ZoneWiseCovidCharge::class)
762.                                                     ->findOneBy(['courier' => $courierObj->getId(), 'zone' => $courierWiseZoneObj->getZone() ]); 
763.                                 if($zoneWiseCovidCharge !== null)
764.                                 {                           
765.                                     $salesInvoiceDetailsObj->setVendorCovidCharge($zoneWiseCovidCharge->getRate() * $rateBookingWeight);
766.                                 }                         
767.                                 else
768.                                 {
769.                                     return new JsonResponse(array('success' => false, 'responseText' => 'Covid Charge is not set for Courier : '.$courierObj->getName().', Country : '.$countryObj->getName().' in Row Number '.$keyValue.'.'));
770.                                 }
771.                             }
772.                             // Vendor Covid Charge End
774.                             // Customer Covid Charge Start
775.                             if($salesInvoiceObj_array['RateApplicable'] <= 2)  // Predefine Rate
776.                             {
777.                                 if($customerObj->getRateCurrency() == 2)
778.                                 {
779.                                     $salesInvoiceDetailsObj->setCovidCharge(0);
780.                                 }
781.                                 else
782.                                 {
783.                                     if($rateWeight <= 1)
784.                                     {
785.                                         $salesInvoiceDetailsObj->setCovidCharge(2);
786.                                         $salesInvoiceDetailsObj->setVendorCovidCharge(2);
787.                                     }
788.                                     else
789.                                     {
790.                                         $zoneWiseCovidCharge = $entityManager->getRepository(ZoneWiseCovidCharge::class)
791.                                                             ->findOneBy(['courier' => $courierObj->getId(), 'zone' => $courierWiseZoneObj->getZone() ]); 
792.                                         if($zoneWiseCovidCharge !== null)
793.                                         {                            
794.                                             $salesInvoiceDetailsObj->setCovidCharge($zoneWiseCovidCharge->getRate() * $rateWeight);
795.                                             $salesInvoiceDetailsObj->setVendorCovidCharge($zoneWiseCovidCharge->getRate() * $rateBookingWeight);
796.                                         }                         
797.                                        
798.                                     }
799.                                 }
800.                             }
801.                             else
802.                             {
803.                                 $salesInvoiceDetailsObj->setCovidCharge(0);
804.                             }
805.                             // Customer Covid Charge End
806.                         }
807.                         else
808.                         {
809.                             // Vendor Covid Charge Start
810.                             if($rateWeight < 5)
811.                             {                                
812.                                 $salesInvoiceDetailsObj->setVendorCovidCharge(1);
813.                             }
814.                             else
815.                             {
816.                                 $zoneWiseCovidCharge = $entityManager->getRepository(ZoneWiseCovidCharge::class)
817.                                                     ->findOneBy(['courier' => $courierObj->getId(), 'zone' => $courierWiseZoneObj->getZone() ]); 
818.                                 if($zoneWiseCovidCharge !== null)
819.                                 {                                 
820.                                     $salesInvoiceDetailsObj->setVendorCovidCharge($zoneWiseCovidCharge->getRate() * $rateBookingWeight);
821.                                 }                         
822.                                 else
823.                                 {
824.                                     return new JsonResponse(array('success' => false, 'responseText' => 'Covid Charge is not set for Courier : '.$courierObj->getName().', Country : '.$countryObj->getName().' in Row Number '.$keyValue.'.'));
825.                                 }
826.                             }
827.                             // Vendor Covid Charge End
829.                             // Customer Covid Charge Start
830.                             if($salesInvoiceObj_array['RateApplicable'] <= 2)  // Predefine Rate
831.                             {
832.                                 if($customerObj->getRateCurrency() == 2)
833.                                 {
834.                                     $salesInvoiceDetailsObj->setCovidCharge(0);
835.                                 }
836.                                 else
837.                                 {
838.                                     if($rateWeight < 5)
839.                                     {
840.                                         $salesInvoiceDetailsObj->setCovidCharge(1);
841.                                         
842.                                     }
843.                                     else
844.                                     {
845.                                         $zoneWiseCovidCharge = $entityManager->getRepository(ZoneWiseCovidCharge::class)
846.                                                             ->findOneBy(['courier' => $courierObj->getId(), 'zone' => $courierWiseZoneObj->getZone() ]); 
847.                                         if($zoneWiseCovidCharge !== null)
848.                                         {                            
849.                                             $salesInvoiceDetailsObj->setCovidCharge($zoneWiseCovidCharge->getRate() * $rateWeight);                                    
850.                                         }                         
851.                                     
852.                                     }
853.                                 }
854.                             }
855.                             else
856.                             {
857.                                 $salesInvoiceDetailsObj->setCovidCharge(0);
858.                             }
859.                             // Customer Covid Charge End
860.                         }
861.                     
862.                     }
863.                     //Covid Charge Cal End
865.                     $salesInvoiceDetailsList->add($salesInvoiceDetailsObj);                    
866.                     $index ++;
867.                 }  
870.                 //Data Save Process Start  
871.                 $index = 0;
872.                 $individualSalesInvoiceId = 0;
873.                 foreach($salesInvoiceDetailsList as $row)
874.                 { 
875.                      $keyValue = $key;
876.                      $keyValue = $keyValue + 1;
877.  
878.                      $shipmentDate = $row->getShipmentDate();
879.  
880.                      // Get Settings Currency Start
881.                      $settingsObj = $settingsInfoRepository
882.                                          ->findByDate($shipmentDate->format('Y-m-d')); 
883.                      if($settingsObj === null)
884.                      {                                
885.                          return new JsonResponse(array('success' => false, 'responseText' => 'Currency is not set in Settings for Month : '.$shipmentDate->format('F').'-'.$shipmentDate->format('Y').' in Row Number '.$keyValue.'.'));
886.                      }                       
887.                      // Get Settings Currency End
889.                     $firstDateofMonth = date('Y-m-01', strtotime($shipmentDate->format('Y-m-d')));            
890.                     $lastDateofMonth = date('Y-m-t', strtotime($shipmentDate->format('Y-m-d')));
891.                     $lastDateofMonth = new \DateTime($lastDateofMonth);
892.                     $halfDateofMonth = date('Y-m-d', strtotime($firstDateofMonth. ' + 14 days'));
893.                     $halfDateofMonth = new \DateTime($halfDateofMonth);
895.                     if($row->getCustomer()->getRateCurrency() == 2)
896.                     {
897.                         $row->setRateApplicable(3);
898.                     }
899.                     
900.                     if($row->getCustomer()->getInvoicePeriod() == 1)  //Monthly Invoice Save Process
901.                     {
902.                         $salesInvoiceObj = $salesInvoiceRepository->findSalesInvoiceObjbyCustomerandDateRange($row->getCustomer()->getId(), $lastDateofMonth, $lastDateofMonth, 1, $row->getCustomer()->getInvoicePeriod(), $this->getUser()->getUserCompany()->getId()  );                    
903.  
904.                         $invocieDate = $lastDateofMonth;
906.                         if($salesInvoiceObj === null)
907.                         {
908.                             $salesInv = new SalesInvoice();
909.                             $salesInvoiceDetailsObj = new SalesInvoiceDetails();
911.                             $salesInv->setCustomer($row->getCustomer());
912.                             
913.                             $salesInvocieLastObj = $salesInvoiceRepository->findLastSalesInvoiceObj($row->getCustomer()->getId());
914.                             $invoiceNO = $utilsService->invoiceNoGenerator($salesInvocieLastObj, $row->getCustomer(), $invocieDate);
915.                             $salesInv->setInvoiceNo($invoiceNO); 
917.                             $salesInv->setInvoiceDate($invocieDate);                                         
918.                             $salesInv->setVat($settingsObj->getVat());                          
919.                             $salesInv->setApproval(0);
920.                             $salesInv->setPaymentNote($this->getUser()->getUserCompany()->getPaymentNote());                           
921.                             $salesInv->setInvoicePeriod($row->getCustomer()->getInvoicePeriod());  
922.                             $salesInv->setRateApplicable($row->getRateApplicable());
923.                             $salesInv->setInvoiceType(1);
925.                             $salesInvoiceDetailsObj->setHawbNo($row->getHawbNo());   
926.                             $salesInvoiceDetailsObj->setReference($row->getReference());                               
927.                             $salesInvoiceDetailsObj->setWeight($row->getWeight());       
928.                             $salesInvoiceDetailsObj->setBookingWeight($row->getBookingWeight());                             
929.                             $salesInvoiceDetailsObj->setShipmentDate($row->getShipmentDate());                       
930.                             $salesInvoiceDetailsObj->setCountry($row->getCountry());                               
931.                             $salesInvoiceDetailsObj->setZone($row->getZone());
932.                             $salesInvoiceDetailsObj->setProductType($row->getProductType());                               
933.                             $salesInvoiceDetailsObj->setCourier($row->getCourier());                          
934.                             $salesInvoiceDetailsObj->setBookingRate($row->getBookingRate());                               
935.                             $salesInvoiceDetailsObj->setSalesRate($row->getSalesRate());
937.                             if($row->getCustomer()->getRateCurrency() == 2)
938.                             {
939.                                $salesInvoiceDetailsObj->setCurrency(1);
940.                             }
941.                             else
942.                             {
943.                                 $salesInvoiceDetailsObj->setCurrency($row->getCustomer()->getCurrency() == 0 ? $settingsObj->getCurrency() : $row->getCustomer()->getCurrency() );
944.                             }
946.                             $salesInvoiceDetailsObj->setVendorCurrency($row->getCourier()->getId() == 1 ?  $settingsObj->getVendorCurrency() : $settingsObj->getCurrency());
947.                             $salesInvoiceDetailsObj->setVatApplicable(0);
948.                             $salesInvoiceDetailsObj->setRateApplicable($row->getRateApplicable());
949.                             
950.                             if($row->getRateApplicable() <= 2)
951.                                 $salesInvoiceDetailsObj->setFsc( $row->getCustomer()->getFsc() == 0 ? $row->getCourier()->getFsc() : $row->getCustomer()->getFsc() ); 
952.                             else
953.                                 $salesInvoiceDetailsObj->setFsc(0); 
955.                             $salesInvoiceDetailsObj->setVendorFsc($row->getCourier()->getFsc()); 
956.                             $salesInvoiceDetailsObj->setCustomer($row->getCustomer());
957.                             $salesInvoiceDetailsObj->setCovidCharge($row->getCovidCharge() === null ? 0 : $row->getCovidCharge());
958.                             $salesInvoiceDetailsObj->setVendorCovidCharge($row->getVendorCovidCharge() === null ? 0 : $row->getVendorCovidCharge());
960.                             $salesInv->addSalesInvoiceDetail($salesInvoiceDetailsObj);
961.     
962.                             $entityManager->persist($salesInv);
963.                             $entityManager->flush($salesInv);   
964.                             
965.                             $salesInvoiceId = $salesInv->getId();
966.     
967.                         }
968.                         else
969.                         {
970.                             $salesInvoiceDetailsObj = new SalesInvoiceDetails();
972.                             $salesInvoiceDetailsObj->setHawbNo($row->getHawbNo());   
973.                             $salesInvoiceDetailsObj->setReference($row->getReference());                               
974.                             $salesInvoiceDetailsObj->setWeight($row->getWeight());       
975.                             $salesInvoiceDetailsObj->setBookingWeight($row->getBookingWeight());                             
976.                             $salesInvoiceDetailsObj->setShipmentDate($row->getShipmentDate());                           
977.                             $salesInvoiceDetailsObj->setCountry($row->getCountry());                               
978.                             $salesInvoiceDetailsObj->setZone($row->getZone());
979.                             $salesInvoiceDetailsObj->setProductType($row->getProductType());                               
980.                             $salesInvoiceDetailsObj->setCourier($row->getCourier());                          
981.                             $salesInvoiceDetailsObj->setBookingRate($row->getBookingRate());                               
982.                             $salesInvoiceDetailsObj->setSalesRate($row->getSalesRate());
984.                             if($row->getCustomer()->getRateCurrency() == 2)
985.                             {
986.                                $salesInvoiceDetailsObj->setCurrency(1);
987.                             }
988.                             else
989.                             {
990.                                 $salesInvoiceDetailsObj->setCurrency($row->getCustomer()->getCurrency() == 0 ? $settingsObj->getCurrency() : $row->getCustomer()->getCurrency() );
991.                             }
993.                             $salesInvoiceDetailsObj->setVendorCurrency($row->getCourier()->getId() == 1 ?  $settingsObj->getVendorCurrency() : $settingsObj->getCurrency());
994.                             $salesInvoiceDetailsObj->setVatApplicable(0);
995.                             $salesInvoiceDetailsObj->setRateApplicable($row->getRateApplicable());
997.                             if($row->getRateApplicable() <= 2)
998.                                 $salesInvoiceDetailsObj->setFsc( $row->getCustomer()->getFsc() == 0 ? $row->getCourier()->getFsc() : $row->getCustomer()->getFsc() ); 
999.                             else
1000.                                 $salesInvoiceDetailsObj->setFsc(0); 
1002.                             $salesInvoiceDetailsObj->setVendorFsc($row->getCourier()->getFsc());
1003.                             $salesInvoiceDetailsObj->setCustomer($row->getCustomer());
1004.                             $salesInvoiceDetailsObj->setCovidCharge($row->getCovidCharge() === null ? 0 : $row->getCovidCharge());
1005.                             $salesInvoiceDetailsObj->setVendorCovidCharge($row->getVendorCovidCharge() === null ? 0 : $row->getVendorCovidCharge());                            
1006.                             $salesInvoiceDetailsObj->setSalesInvoice($salesInvoiceObj);
1007.                                         
1008.                             $entityManager->persist($salesInvoiceDetailsObj);
1009.                             $entityManager->flush($salesInvoiceDetailsObj);
1010.                         }
1012.                     }
1013.                     else if($row->getCustomer()->getInvoicePeriod() == 2) //Half Monthly Invoice Save Process
1014.                     {
1015.                         if($shipmentDate <= $halfDateofMonth) // First Half month
1016.                         { 
1017.                             $salesInvoiceObj = $salesInvoiceRepository
1018.                                     ->findSalesInvoiceObjbyCustomerandDateRange($row->getCustomer()->getId(), $halfDateofMonth, $halfDateofMonth, 1, $row->getCustomer()->getInvoicePeriod(), $this->getUser()->getUserCompany()->getId() );                              
1019.                             
1020.                             $invocieDate = $halfDateofMonth;
1021.                         }  
1022.                         else
1023.                         {
1024.                             $salesInvoiceObj = $salesInvoiceRepository
1025.                                 ->findSalesInvoiceObjbyCustomerandDateRange($row->getCustomer()->getId(), $lastDateofMonth, $lastDateofMonth, 1, $row->getCustomer()->getInvoicePeriod(), $this->getUser()->getUserCompany()->getId() );                              
1027.                             $invocieDate = $lastDateofMonth;
1028.                         }
1030.                         ////////////////Common portion
1032.                         if($salesInvoiceObj === null)
1033.                         {
1034.                             $salesInv = new SalesInvoice();
1035.                             $salesInvoiceDetailsObj = new SalesInvoiceDetails();
1037.                             $salesInv->setCustomer($row->getCustomer());
1038.                             
1039.                             $salesInvocieLastObj = $salesInvoiceRepository->findLastSalesInvoiceObj($row->getCustomer()->getId());
1040.                             $invoiceNO = $utilsService->invoiceNoGenerator($salesInvocieLastObj, $row->getCustomer(), $invocieDate);
1041.                             $salesInv->setInvoiceNo($invoiceNO); 
1043.                             $salesInv->setInvoiceDate($invocieDate);                                         
1044.                             $salesInv->setVat($settingsObj->getVat());                          
1045.                             $salesInv->setApproval(0);
1046.                             $salesInv->setPaymentNote($this->getUser()->getUserCompany()->getPaymentNote());                           
1047.                             $salesInv->setInvoicePeriod($row->getCustomer()->getInvoicePeriod());  
1048.                             $salesInv->setRateApplicable($row->getRateApplicable());
1049.                             $salesInv->setInvoiceType(1);
1051.                             $salesInvoiceDetailsObj->setHawbNo($row->getHawbNo());   
1052.                             $salesInvoiceDetailsObj->setReference($row->getReference());                               
1053.                             $salesInvoiceDetailsObj->setWeight($row->getWeight());       
1054.                             $salesInvoiceDetailsObj->setBookingWeight($row->getBookingWeight());                             
1055.                             $salesInvoiceDetailsObj->setShipmentDate($row->getShipmentDate());                       
1056.                             $salesInvoiceDetailsObj->setCountry($row->getCountry());                               
1057.                             $salesInvoiceDetailsObj->setZone($row->getZone());
1058.                             $salesInvoiceDetailsObj->setProductType($row->getProductType());                               
1059.                             $salesInvoiceDetailsObj->setCourier($row->getCourier());                          
1060.                             $salesInvoiceDetailsObj->setBookingRate($row->getBookingRate());                               
1061.                             $salesInvoiceDetailsObj->setSalesRate($row->getSalesRate());
1063.                             if($row->getCustomer()->getRateCurrency() == 2)
1064.                             {
1065.                                $salesInvoiceDetailsObj->setCurrency(1);
1066.                             }
1067.                             else
1068.                             {
1069.                                 $salesInvoiceDetailsObj->setCurrency($row->getCustomer()->getCurrency() == 0 ? $settingsObj->getCurrency() : $row->getCustomer()->getCurrency() );
1070.                             }
1072.                             $salesInvoiceDetailsObj->setVendorCurrency($row->getCourier()->getId() == 1 ?  $settingsObj->getVendorCurrency() : $settingsObj->getCurrency());
1073.                             $salesInvoiceDetailsObj->setVatApplicable(0);
1074.                             $salesInvoiceDetailsObj->setRateApplicable($row->getRateApplicable());
1075.                             
1076.                             if($row->getRateApplicable() <= 2)
1077.                                 $salesInvoiceDetailsObj->setFsc( $row->getCustomer()->getFsc() == 0 ? $row->getCourier()->getFsc() : $row->getCustomer()->getFsc() ); 
1078.                             else
1079.                                 $salesInvoiceDetailsObj->setFsc(0); 
1081.                             $salesInvoiceDetailsObj->setVendorFsc($row->getCourier()->getFsc());
1082.                             $salesInvoiceDetailsObj->setCustomer($row->getCustomer());
1083.                             $salesInvoiceDetailsObj->setCovidCharge($row->getCovidCharge() === null ? 0 : $row->getCovidCharge());
1084.                             $salesInvoiceDetailsObj->setVendorCovidCharge($row->getVendorCovidCharge() === null ? 0 : $row->getVendorCovidCharge());
1086.                             $salesInv->addSalesInvoiceDetail($salesInvoiceDetailsObj);
1087.     
1088.                             $entityManager->persist($salesInv);
1089.                             $entityManager->flush($salesInv);    
1090.                             
1091.                             $salesInvoiceId = $salesInv->getId();
1092.     
1093.                         }
1094.                         else
1095.                         {
1096.                             $salesInvoiceDetailsObj = new SalesInvoiceDetails();
1098.                             $salesInvoiceDetailsObj->setHawbNo($row->getHawbNo());   
1099.                             $salesInvoiceDetailsObj->setReference($row->getReference());                               
1100.                             $salesInvoiceDetailsObj->setWeight($row->getWeight());       
1101.                             $salesInvoiceDetailsObj->setBookingWeight($row->getBookingWeight());                             
1102.                             $salesInvoiceDetailsObj->setShipmentDate($row->getShipmentDate());                           
1103.                             $salesInvoiceDetailsObj->setCountry($row->getCountry());                               
1104.                             $salesInvoiceDetailsObj->setZone($row->getZone());
1105.                             $salesInvoiceDetailsObj->setProductType($row->getProductType());                               
1106.                             $salesInvoiceDetailsObj->setCourier($row->getCourier());                          
1107.                             $salesInvoiceDetailsObj->setBookingRate($row->getBookingRate());                               
1108.                             $salesInvoiceDetailsObj->setSalesRate($row->getSalesRate());
1110.                             if($row->getCustomer()->getRateCurrency() == 2)
1111.                             {
1112.                                $salesInvoiceDetailsObj->setCurrency(1);
1113.                             }
1114.                             else
1115.                             {
1116.                                 $salesInvoiceDetailsObj->setCurrency($row->getCustomer()->getCurrency() == 0 ? $settingsObj->getCurrency() : $row->getCustomer()->getCurrency() );
1117.                             }
1119.                             $salesInvoiceDetailsObj->setVendorCurrency($row->getCourier()->getId() == 1 ?  $settingsObj->getVendorCurrency() : $settingsObj->getCurrency());
1120.                             $salesInvoiceDetailsObj->setVatApplicable(0);
1121.                             $salesInvoiceDetailsObj->setRateApplicable($row->getRateApplicable()); 
1123.                             if($row->getRateApplicable() <= 2)
1124.                                 $salesInvoiceDetailsObj->setFsc( $row->getCustomer()->getFsc() == 0 ? $row->getCourier()->getFsc() : $row->getCustomer()->getFsc() ); 
1125.                             else
1126.                                 $salesInvoiceDetailsObj->setFsc(0); 
1128.                             $salesInvoiceDetailsObj->setVendorFsc($row->getCourier()->getFsc());
1129.                             $salesInvoiceDetailsObj->setCustomer($row->getCustomer());
1130.                             $salesInvoiceDetailsObj->setCovidCharge($row->getCovidCharge() === null ? 0 : $row->getCovidCharge()); 
1131.                             $salesInvoiceDetailsObj->setVendorCovidCharge($row->getVendorCovidCharge() === null ? 0 : $row->getVendorCovidCharge());                           
1132.                             $salesInvoiceDetailsObj->setSalesInvoice($salesInvoiceObj);
1133.                                         
1134.                             $entityManager->persist($salesInvoiceDetailsObj);
1135.                             $entityManager->flush($salesInvoiceDetailsObj);
1136.                         }
1138.                         /////////////Common 
1139.                     }
1140.                     else // HAWB NO Wise Invoice Save Process
1141.                     {
1142.                         $salesInv = new SalesInvoice();
1143.                         $salesInvoiceDetailsObj = new SalesInvoiceDetails();
1145.                         $salesInv->setCustomer($row->getCustomer());
1146.                         
1147.                         $salesInvocieLastObj = $salesInvoiceRepository->findLastSalesInvoiceObj($row->getCustomer()->getId());
1148.                         $invoiceNO = $utilsService->invoiceNoGenerator($salesInvocieLastObj, $row->getCustomer(), $shipmentDate);
1149.                         $salesInv->setInvoiceNo($invoiceNO); 
1151.                         $salesInv->setInvoiceDate($shipmentDate);                                        
1152.                         $salesInv->setVat($settingsObj->getVat());                          
1153.                         $salesInv->setApproval(0);
1154.                         $salesInv->setPaymentNote($this->getUser()->getUserCompany()->getPaymentNote());                           
1155.                         $salesInv->setInvoicePeriod($row->getCustomer()->getInvoicePeriod());  
1156.                         $salesInv->setRateApplicable($row->getRateApplicable());
1157.                         $salesInv->setInvoiceType(1);
1159.                         $salesInvoiceDetailsObj->setHawbNo($row->getHawbNo());   
1160.                         $salesInvoiceDetailsObj->setReference($row->getReference());                               
1161.                         $salesInvoiceDetailsObj->setWeight($row->getWeight());       
1162.                         $salesInvoiceDetailsObj->setBookingWeight($row->getBookingWeight());                             
1163.                         $salesInvoiceDetailsObj->setShipmentDate($row->getShipmentDate());                       
1164.                         $salesInvoiceDetailsObj->setCountry($row->getCountry());                               
1165.                         $salesInvoiceDetailsObj->setZone($row->getZone());
1166.                         $salesInvoiceDetailsObj->setProductType($row->getProductType());                               
1167.                         $salesInvoiceDetailsObj->setCourier($row->getCourier());                          
1168.                         $salesInvoiceDetailsObj->setBookingRate($row->getBookingRate());                               
1169.                         $salesInvoiceDetailsObj->setSalesRate($row->getSalesRate());
1171.                         if($row->getCustomer()->getRateCurrency() == 2)
1172.                         {
1173.                             $salesInvoiceDetailsObj->setCurrency(1);
1174.                         }
1175.                         else
1176.                         {
1177.                             $salesInvoiceDetailsObj->setCurrency($row->getCustomer()->getCurrency() == 0 ? $settingsObj->getCurrency() : $row->getCustomer()->getCurrency() );
1178.                         }
1180.                         $salesInvoiceDetailsObj->setVendorCurrency($row->getCourier()->getId() == 1 ?  $settingsObj->getVendorCurrency() : $settingsObj->getCurrency());
1181.                         $salesInvoiceDetailsObj->setVatApplicable(0);
1182.                         $salesInvoiceDetailsObj->setRateApplicable($row->getRateApplicable());
1184.                         if($row->getRateApplicable() <= 2)
1185.                             $salesInvoiceDetailsObj->setFsc( $row->getCustomer()->getFsc() == 0 ? $row->getCourier()->getFsc() : $row->getCustomer()->getFsc() ); 
1186.                         else
1187.                             $salesInvoiceDetailsObj->setFsc(0); 
1189.                         $salesInvoiceDetailsObj->setVendorFsc($row->getCourier()->getFsc());    
1190.                         $salesInvoiceDetailsObj->setCustomer($row->getCustomer());
1191.                         $salesInvoiceDetailsObj->setCovidCharge($row->getCovidCharge() === null ? 0 : $row->getCovidCharge());
1192.                         $salesInvoiceDetailsObj->setVendorCovidCharge($row->getVendorCovidCharge() === null ? 0 : $row->getVendorCovidCharge());
1194.                         $salesInv->addSalesInvoiceDetail($salesInvoiceDetailsObj);
1196.                         $entityManager->persist($salesInv);
1197.                         $entityManager->flush($salesInv); 
1198.                         
1199.                         $salesInvoiceId = $salesInv->getId();
1201.                         if($gloPaymentReceived == 1 && $salesInvoiceId > 0)
1202.                         {
1203.                             
1204.                             $salesValue = $salesInvoiceRepository->getSingalSalesValueCalculation($salesInvoiceId);
1205.                             
1206.                             $receiveVoucher = new ReceiveVoucher();
1207.         
1208.                             $receiveVoucher->setSalesInvoice($salesInvoiceRepository->find($salesInvoiceId));
1209.                             $receiveVoucher->setDescription('N/A');
1210.                             $receiveVoucher->setReceiveDate(new \DateTime('now'));
1211.                             
1212.                             //Start Reference no Generate $salesInvoiceObj_array['ShipmentDate']
1213.                             $receiveVoucherLastObj = $receiveVoucherRepository->findLastObjReceiveVoucher();
1214.                 
1215.                             $now = new \DateTime('now');           
1216.                             $year = substr($now->format('Y'),2); 
1217.                             $refNO = "";
1218.                             $serialNo = "";
1219.                             if(null !== $receiveVoucherLastObj)
1220.                                 $refYear = substr($receiveVoucherLastObj->getVoucherno(),-2);
1221.                             else
1222.                                 $refYear = 20;
1223.                 
1224.                             if($receiveVoucherLastObj == null)
1225.                             {
1226.                                 $refNO = "RV-00001/".$year;
1227.                             } 
1228.                             else if($year != $refYear)
1229.                             {
1230.                                 $refNO = "RV-00001/".$year;
1231.                             }          
1232.                             else
1233.                             {
1234.                                 $serialNo = substr($receiveVoucherLastObj->getVoucherno(),-8,-3);
1235.                                 $serialNo += 1;
1236.                                 $serialNo = str_pad($serialNo,5,"0",STR_PAD_LEFT);
1237.                                 $refNO ="RV-".$serialNo."/".$year;
1238.                             
1239.                             }
1240.                             //End Reference no Generate
1241.                 
1242.                             $receiveVoucher->setVoucherno($refNO);
1243.                 
1244.                             $debitAccountName = $accountNameRepository->find(1);
1245.                             $receiveVoucher->setDebitAccount($debitAccountName);
1246.                 
1247.                             $creditAccountName = $accountNameRepository->find(3);
1248.                             $receiveVoucher->setCreditAccount($creditAccountName);
1249.                             $receiveVoucher->setReceiveAmount($salesValue[0]);
1250.                 
1251.                             $receiveVoucherRepository->save($receiveVoucher, true);
1252.                         }
1253.                     }
1256.                     $index ++;
1257.                 } 
1259.                                
1260.                 $this->addFlash('notice', 'Booking Created successfully!');
1261.                 
1262.                 return new JsonResponse(array('success' => true));                
1263.             }
1264.         }
1266.         // if ($form->isSubmitted() && $form->isValid()) {
1267.         //     $salesInvoiceRepository->save($salesInvoice, true);
1269.         //     return $this->redirectToRoute('app_sales_invoice_index', [], Response::HTTP_SEE_OTHER);
1270.         // }
1272.         return $this->renderForm('sales_invoice/new.html.twig', [
1273.             'sales_invoice' => $salesInvoice,
1274.             'form' => $form,
1275.             'formDet' => $formDet,
1276.         ]);
1277.     }
1279.     #[Route('/salesinvoice/{id}/show', name: 'app_sales_invoice_show', methods: ['GET'])]
1280.     public function show(SalesInvoice $salesInvoice, Request $request, ReceiveVoucherRepository $receiveVoucherRepository): Response
1281.     {
1283.         $searchForm = $this->createFormBuilder(null)            
1284.             ->add('reference', EntityType::class, [
1285.                 // looks for choices from this entity
1286.                 'class' => SalesInvoiceDetails::class,
1287.                 'query_builder' => function (SalesInvoiceDetailsRepository $er) use ($salesInvoice) {
1288.                     return $er->createQueryBuilder('v')  
1289.                         ->where('v.salesInvoice = '.$salesInvoice->getId())                     
1290.                         ->orderBy('v.reference', 'ASC')
1291.                         ->groupBy('v.reference')
1292.                         ;
1293.                 },                
1294.                 // uses the User.username property as the visible option string
1295.                 'choice_label' => 'reference',
1296.                 'placeholder' => 'Select a Reference...',
1297.                 'attr' => [
1298.                     'class' => 'form-control select-tags',
1299.                     'style' => 'width:100%;',
1300.                     ],
1301.                 'label' => 'Reference Name',            
1302.                 // used to render a select box, check boxes or radios
1303.                 // 'multiple' => true,
1304.                 // 'expanded' => true,
1305.                 ])       
1306.             ->getForm();
1308.         $searchForm->handleRequest($request);
1310.         $receiveVoucherList = $receiveVoucherRepository
1311.                         ->findBy(array('salesInvoice' => $salesInvoice->getId()));
1313.         return $this->render('sales_invoice/show.html.twig', [
1314.             'sales_invoice' => $salesInvoice,
1315.             'receiveVoucherList' => $receiveVoucherList,
1316.             'searchForm' => $searchForm->createView(),
1317.         ]);
1318.     }
1319.     
1320.     #[Route('/salesinvoice/{id}/search-show/', name: 'app_sales_invoice_search_show', methods: ['GET'])]
1321.     public function searchShow(SalesInvoiceDetails $salesInvoiceDetailsObj, SalesInvoiceDetailsRepository $salesInvoiceDetailsRepository): Response
1322.     {
1323.         $salesInvoiceDetails = $salesInvoiceDetailsRepository
1324.                         ->findByReference($salesInvoiceDetailsObj->getSalesInvoice()->getId(), 
1325.                                           $salesInvoiceDetailsObj->getReference()
1326.                                     );
1328.         return $this->render('sales_invoice/search_show.html.twig', [
1329.             'sales_invoice' => $salesInvoiceDetailsObj->getSalesInvoice(),    
1330.             'salesInvoiceDetails' => $salesInvoiceDetails,        
1331.         ]);
1332.     }
1335.     #[Route('/salesinvoice/{id}/edit', name: 'app_sales_invoice_edit', methods: ['GET', 'POST'])]
1336.     #[IsGranted("ROLE_ACCOUNTS")]
1337.     public function edit(Request $request, SalesInvoice $salesInvoice, SalesInvoiceRepository $salesInvoiceRepository, CountryRepository $countryRepository, CourierRepository $courierRepository, ProductTypeRepository $productTypeRepository, SalesInvoiceDetailsRepository $salesInvoiceDetailsRepository, EntityManagerInterface $entityManager, SettingsInfoRepository $settingsInfoRepository): Response
1338.     {
1339.         // Start remove item by Edit
1340.         // Original Order details
1341.         $originalSalesInvoiceDetails = new ArrayCollection();
1343.         $originalInvoiceAdditionalCharge = new ArrayCollection();
1344.         
1345.         foreach($salesInvoice->getSalesInvoiceDetails() as $invoiceDetail)
1346.         {
1347.             $originalSalesInvoiceDetails->add($invoiceDetail);
1349.             foreach($invoiceDetail->getInvoiceAdditionalCharges() as $invAdditionalCharge)
1350.             {
1351.                 $originalInvoiceAdditionalCharge->add($invAdditionalCharge);
1352.             }
1353.         }
1354.      
1355.         // End remove item by Edit
1357.         $form = $this->createForm(SalesInvoiceEditType::class, $salesInvoice);
1358.         $form->handleRequest($request);
1360.         $countryList = $countryRepository->findAll();
1361.         $courierList = $courierRepository->findAll();
1362.         $productTypeList = $productTypeRepository->findAll(); 
1363.         $additionalChargeList = $entityManager->getRepository(AdditionalCharge::class)->findAll(); 
1365.         if ($request->isXMLHttpRequest()) {
1366.             //return new JsonResponse(array('success' => false, 'responseText' =>  $salesInvoice->getInvoiceno() ));
1367.             $salesInvoiceObj = $request->request->get('salesInvoiceObj');            
1368.             if (!empty($salesInvoiceObj)) {
1370.                 $salesInvoiceObj_array = json_decode($salesInvoiceObj, true);
1371.                 $shipmentDate_array = json_decode($request->request->get('shipmentDate'));
1372.                 $hawbNo_array = json_decode($request->request->get('hawbNo'));
1373.                 $reference_array = json_decode($request->request->get('reference'));
1374.                 $country_array = json_decode($request->request->get('country'));
1375.                 $courier_array = json_decode($request->request->get('courier'));
1376.                 $productType_array = json_decode($request->request->get('productType'));
1377.                 $weight_array = json_decode($request->request->get('weight'));
1378.                 $vendorWeight_array = json_decode($request->request->get('vendorWeight'));
1379.                 $bookingRate_array = json_decode($request->request->get('bookingRate'));
1380.                 $salesRate_array = json_decode($request->request->get('salesRate'));
1381.                 $fsc_array = json_decode($request->request->get('fsc'));
1382.                 $vendorCovidCharge_array = json_decode($request->request->get('vendorCovidCharge')); 
1383.                 $covidCharge_array = json_decode($request->request->get('covidCharge')); 
1384.                 $customerCurrency_array = json_decode($request->request->get('customerCurrency'));
1385.                 $vendorCurrency_array = json_decode($request->request->get('vendorCurrency'));             
1386.                 $invoiceDetailsId_array = json_decode($request->request->get('invoiceDetailsId'));
1387.                 $vatApplicable_array = json_decode($request->request->get('vatApplicable'));
1388.                 $vendorVatApplicable_array = json_decode($request->request->get('vendorVatApplicable'));
1389.                 $vendorFsc_array = json_decode($request->request->get('vendorFsc'));
1391.                 $additionalCharge_array = json_decode($request->request->get('additionalCharge'));
1392.                 $additionalPayableAmount_array = json_decode($request->request->get('additionalPayableAmount'));
1393.                 $additionalReceivableAmount_array = json_decode($request->request->get('additionalReceivableAmount'));
1394.                 $additionalFscApplicable_array = json_decode($request->request->get('additionalFscApplicable'));
1395.                 $additionalVatApplicable_array = json_decode($request->request->get('additionalVatApplicable'));
1396.                 $additionalChargeId_array = json_decode($request->request->get('additionalChargeId'));
1398.                 // var_dump($accountNameId_array); die();
1399.                 // return new JsonResponse(array('success' => false, 'responseText' =>  $salesInvoiceObj_array['CustomerId'] ));
1401.                 $customerObj = $entityManager->find(Customer::class, $salesInvoiceObj_array['CustomerId']);                                
1402.                 $salesInvoice->setCustomer($customerObj);
1404.                 $salesInvoice->setInvoiceNo($salesInvoiceObj_array['Invoiceno']);
1405.                 $salesInvoice->setInvoiceDate(new \DateTime($salesInvoiceObj_array['Invoicedate']));        
1406.                 $salesInvoice->setVat($salesInvoiceObj_array['Vat']);   
1407.                 $salesInvoice->setPreviousDues($salesInvoiceObj_array['Previousdues']);
1408.                 $salesInvoice->setApproval($salesInvoiceObj_array['Approval']); 
1409.                 $salesInvoice->setPaymentNote($salesInvoiceObj_array['PaymentNote']);   
1410.                 $salesInvoice->setRateApplicable($salesInvoiceObj_array['RateApplicable']);        
1411.                 $salesInvoice->setRemarks($salesInvoiceObj_array['Remarks']);
1412.                 
1413.                 if($salesInvoiceObj_array['Submissiondate'] == '')
1414.                     $salesInvoice->setSubmissionDate(new \DateTime($salesInvoiceObj_array['Invoicedate'])); 
1415.                 else
1416.                     $salesInvoice->setSubmissionDate(new \DateTime($salesInvoiceObj_array['Submissiondate'])); 
1417.                 
1418.                 $salesInvoice->getSalesInvoiceDetails()->clear();
1420.                 $index = 0;
1421.                 foreach($hawbNo_array as $key=>$row) 
1422.                 {
1423.                     $keyValue = $key;
1424.                     $keyValue = $keyValue + 1;
1426.                     if($invoiceDetailsId_array[$index] !== null)
1427.                     {
1428.                         // $salesInvoiceDetailsObj = $salesInvoiceDetailsRepository->find($invoiceDetailsId_array[$index]); 
1429.                         
1430.                         // $salesInvoiceDetailsObj->getInvoiceAdditionalCharges()->clear();
1431.                         // $salesInvoiceDetailsObj->setShipmentDate(new \DateTime($shipmentDate_array[$index]));
1432.                         // $salesInvoiceDetailsObj->setHawbNo($hawbNo_array[$index]);   
1433.                         // $salesInvoiceDetailsObj->setReference($reference_array[$index]); 
1435.                         // $countryObj = $countryRepository->find($country_array[$index]);         
1436.                         // $salesInvoiceDetailsObj->setCountry($countryObj); 
1438.                         // $courierObj = $courierRepository->find($courier_array[$index]);  
1439.                         // $salesInvoiceDetailsObj->setCourier($courierObj); 
1441.                         // $productTypeObj =$productTypeRepository->find($productType_array[$index]);  
1442.                         // $salesInvoiceDetailsObj->setProductType($productTypeObj);    
1444.                         // $salesInvoiceDetailsObj->setWeight($weight_array[$index]);  
1445.                         // $salesInvoiceDetailsObj->setBookingWeight($vendorWeight_array[$index]);                   
1446.                         // $salesInvoiceDetailsObj->setBookingRate($bookingRate_array[$index]);                               
1447.                         // $salesInvoiceDetailsObj->setSalesRate($salesRate_array[$index]);
1448.                         // $salesInvoiceDetailsObj->setFsc($fsc_array[$index]);
1449.                         // $salesInvoiceDetailsObj->setVendorCovidCharge($vendorCovidCharge_array[$index]);
1450.                         // $salesInvoiceDetailsObj->setCovidCharge($covidCharge_array[$index]);
1451.                         // $salesInvoiceDetailsObj->setCurrency($customerCurrency_array[$index]);
1452.                         // $salesInvoiceDetailsObj->setVendorCurrency($vendorCurrency_array[$index]);
1453.                         // $salesInvoiceDetailsObj->setVatApplicable($vatApplicable_array[$index]);
1454.                         // $salesInvoiceDetailsObj->setVendorVatApplicable($vendorVatApplicable_array[$index]);
1455.                         // $salesInvoiceDetailsObj->setVendorFsc($vendorFsc_array[$index]);
1457.                         // $salesInvoice->addSalesInvoiceDetail($salesInvoiceDetailsObj);
1459.                         ///////////
1460.                         
1461.                         //return new JsonResponse(array('success' => false, 'responseText' =>  $invoiceDetailsId_array[$index] ));
1462.                         $salesInvDetailsObj = $salesInvoiceDetailsRepository->find($invoiceDetailsId_array[$index]); 
1463.         
1464.                         $countryObj = $countryRepository->find($country_array[$index]);         
1465.                         $salesInvDetailsObj->setCountry($countryObj); 
1467.                         $courierObj = $courierRepository->find($courier_array[$index]);  
1468.                         $salesInvDetailsObj->setCourier($courierObj); 
1469.                         
1470.                         // Rate Type get Start Here getRateType()
1471.                         if($courierObj->getZoneRateType() !== null)
1472.                             $zoneWiseMasterRateTypeObj = $entityManager->find(ZoneWiseMasterRate::class, $courierObj->getZoneRateType());
1473.                         else 
1474.                             $zoneWiseMasterRateTypeObj = new ZoneWiseMasterRate();
1475.                         // Rate Type get End Here
1477.                         $productTypeObj =$productTypeRepository->find($productType_array[$index]);  
1478.                         $salesInvDetailsObj->setProductType($productTypeObj); 
1479.                         
1480.                         $shipmentObj = $salesInvDetailsObj->getShipment();
1481.                         
1482.                         $shipmentDate = new \DateTime($shipmentDate_array[$index]);
1483.                         
1484.                        // $salesInvDetailsObj->setRateApplicable(!$salesInvDetailsObj->isExpedite() ? $customerObj->getRateType() : 5);   // Expedite Rate Type 5 
1485.         
1486.                         $courierWiseZoneObj = $entityManager->getRepository(CourierWiseZone::class)
1487.                                                             ->findOneBy(['courier' => $courierObj->getId(), 'country' => $countryObj->getId() ]);  
1488.         
1489.                         if($courierWiseZoneObj === null )
1490.                         {
1491.                             return new JsonResponse(array('success' => false, 'responseText' => 'Courier Wise Zone is not set for Courier : '. $courierObj->getName().', and Country : '.$countryObj->getName().' in Row Number '.$keyValue.'.'));
1492.                                                         
1493.                         }
1494.                         $salesInvDetailsObj->setZone($courierWiseZoneObj->getZone());
1495.         
1496.                         $salesInvDetailsObj->setShipmentDate(new \DateTime($shipmentDate_array[$index]));  
1497.                         $salesInvDetailsObj->setHawbNo($hawbNo_array[$index]);                         
1498.                         $salesInvDetailsObj->setReference($reference_array[$index]);
1500.                         $salesInvDetailsObj->setWeight($weight_array[$index]);       
1501.                         $salesInvDetailsObj->setBookingWeight($vendorWeight_array[$index]);    
1502.                         $salesInvDetailsObj->setVatApplicable($vatApplicable_array[$index]);
1503.                                                     
1504.                         //Customer Weight Calculation Start 
1505.                         // Half and Per KG
1506.                         $weight = $weight_array[$index];
1507.                         $pointInputWeight = $weight - floor($weight);
1508.                         $intInputWeight = floor($weight);
1509.                         $finalWeight = 0;
1510.                         $rateWeight = 0;
1511.                         if($weight <  $courierObj->getWeightPerkg())
1512.                         {
1513.                             if($pointInputWeight > 0 && $pointInputWeight <= 0.5)
1514.                             {
1515.                                 $finalWeight = (float)0.5;
1516.                             }
1517.                             elseif($pointInputWeight > 0.5 && $pointInputWeight <=1)
1518.                             {
1519.                                 $finalWeight = (float)1;
1520.                             }
1521.                         }
1522.                         else
1523.                         {
1524.                             if($pointInputWeight > 0 && $pointInputWeight <=1)
1525.                             {
1526.                                 $finalWeight = (float)1;
1527.                             }
1528.                         }
1529.                         $rateWeight = $intInputWeight + $finalWeight;
1530.         
1531.                         //Only Per KG
1532.                         $pointInputPerKgWeight = $weight - floor($weight);
1533.                         $intInputPerKgWeight = floor($weight);
1534.                         $finalPerKgWeight = 0;
1535.                         $ratePerKgWeight = 0;
1536.                         if($pointInputPerKgWeight > 0 && $pointInputPerKgWeight <=1)
1537.                         {
1538.                             $finalPerKgWeight = (float)1;
1539.                         }
1540.                         $ratePerKgWeight = $intInputPerKgWeight + $finalPerKgWeight;
1541.                         //Customer Weight Calculation End
1542.         
1543.                         //Vendor/Booking weight Calculation Start 
1544.                         // Half and Per KG
1545.                         $bookingWeight = trim($vendorWeight_array[$index]);
1546.                         $pointInputBookingWeight = $bookingWeight - floor($bookingWeight);
1547.                         $intInputBookingWeight = floor($bookingWeight);
1548.                         $finalBookingWeight = 0;
1549.                         $rateBookingWeight = 0;
1550.                         if($bookingWeight <  $courierObj->getWeightPerkg())
1551.                         {
1552.                             if($pointInputBookingWeight > 0 && $pointInputBookingWeight <= 0.5)
1553.                             {
1554.                                 $finalBookingWeight = (float)0.5;
1555.                             }
1556.                             elseif($pointInputBookingWeight > 0.5 && $pointInputBookingWeight <=1)
1557.                             {
1558.                                 $finalBookingWeight = (float)1;
1559.                             }
1560.                         }
1561.                         else
1562.                         {
1563.                             if($pointInputBookingWeight > 0 && $pointInputBookingWeight <=1)
1564.                             {
1565.                                 $finalBookingWeight = (float)1;
1566.                             }
1567.                         }
1568.                         $rateBookingWeight = $intInputBookingWeight + $finalBookingWeight;
1569.         
1570.                         //Only Per KG
1571.                         $pointInputPerKgBookingWeight = $bookingWeight - floor($bookingWeight);
1572.                         $intInputPerKgBookingWeight = floor($bookingWeight);
1573.                         $finalPerKgBookingWeight = 0;
1574.                         $ratePerKgBookingWeight = 0;
1575.                         if($pointInputPerKgBookingWeight > 0 && $pointInputPerKgBookingWeight <=1)
1576.                         {
1577.                             $finalPerKgBookingWeight = (float)1;
1578.                         }
1579.                         $ratePerKgBookingWeight = $intInputPerKgBookingWeight + $finalPerKgBookingWeight;
1580.                         //Weight Calculation End
1581.                         //return new JsonResponse(array('success' => false, 'responseText' =>  $salesInvDetailsObj->getRateApplicable() ));
1582.                         
1583.                         // Get Settings Currency Start
1584.                         $settingsObj = $settingsInfoRepository->findByDateCurrency(1, $salesInvDetailsObj->getShipmentDate()->format('Y-m-d')); 
1586.                         if($settingsObj === null)
1587.                         {                                
1588.                             return new JsonResponse(array('success' => false, 'responseText' => 'Currency is not set in Settings for Month : '.$salesInvDetailsObj->getShipmentDate()->format('F').'-'.$salesInvDetailsObj->getShipmentDate()->format('Y').' in Row Number '.$keyValue.'.'));
1589.                         }                       
1590.                         // Get Settings Currency End
1591.                         
1592.                         
1593.                         //Master Rate Assign Start  
1594.                         if($salesInvDetailsObj->getShipment() === null )
1595.                         {   
1596.                             // Accessaccessory Surcharge
1597.                             $salesInvDetailsObj->setBookingRate($bookingRate_array[$index]);  
1598.                         }
1599.                         else if(!$salesInvDetailsObj->getShipment()->isExpedite() && $salesInvDetailsObj->getShipment() !== null)
1600.                         {     
1601.                             $finalMasterRateCal = 0;                 
1602.                             $perKgRateWeight = $courierObj->getWeightPerkgRate();
1603.                             if($courierObj->getId() != 3)
1604.                             {
1605.                                 if($rateBookingWeight < $perKgRateWeight )
1606.                                 { 
1607.                                     $countryWiseMasterRate = $entityManager->getRepository(CountryWiseMasterRate::class) 
1608.                                                             ->findOneBy(['type' => $salesInvDetailsObj->getShipment()->getShipmentType(), 'courier' => $courierObj->getId(), 'country' => $countryObj->getId(), 'productType' => $productTypeObj->getRateid(), 'weight' => $rateBookingWeight ]);                                          
1609.     
1610.                                     if($countryWiseMasterRate !== null) 
1611.                                     { 
1612.                                         $finalMasterRateCal =  $countryWiseMasterRate->getRate();
1613.                                     }                           
1614.                                 }
1615.                                 else
1616.                                 {
1617.                                     $countryWiseMasterRate = $entityManager->getRepository(CountryWiseMasterRate::class)
1618.                                                             ->findOneBy(['type' => $salesInvDetailsObj->getShipment()->getShipmentType(), 'courier' => $courierObj->getId(), 'country' => $countryObj->getId(), 'productType' => $productTypeObj->getRateid(), 'weight' => $perKgRateWeight ]);                           
1619.                                     if($countryWiseMasterRate !== null) 
1620.                                     { 
1621.                                         $finalMasterRateCal = $countryWiseMasterRate->getRate() * $rateBookingWeight;                                    
1622.                                     }
1623.                                 }
1624.             
1625.                                 if($countryWiseMasterRate === null)  
1626.                                 {
1627.                                     if($rateBookingWeight < $perKgRateWeight )
1628.                                     { 
1629.                                        $zoneWiseMasterRate = $entityManager->getRepository(ZoneWiseMasterRate::class)
1630.                                                             ->findBookingRatebyCourierAndWeight($salesInvDetailsObj->getShipment()->getShipmentType(), $zoneWiseMasterRateTypeObj->getRateType(), $courierObj->getId(), $courierWiseZoneObj->getZone()->getId(), $productTypeObj->getRateid(), $rateBookingWeight);                       
1631.                                                 
1632.                                         if($zoneWiseMasterRate !== null)      
1633.                                         { 
1634.                                             $finalMasterRateCal = $zoneWiseMasterRate->getRate();
1635.                                         }
1636.                                     }
1637.                                     else
1638.                                     {
1639.                                         
1640.                                        $zoneWiseMasterRate = $entityManager->getRepository(ZoneWiseMasterRate::class)
1641.                                                             ->findBookingRatebyCourierAndWeight($salesInvDetailsObj->getShipment()->getShipmentType(), $zoneWiseMasterRateTypeObj->getRateType(), $courierObj->getId(), $courierWiseZoneObj->getZone()->getId(), $productTypeObj->getRateid(), $courierObj->getId() == 3 ?  $perKgRateWeight : $rateBookingWeight );                     
1642.                                         if($zoneWiseMasterRate !== null)      
1643.                                         { 
1644.                                             $finalMasterRateCal = $zoneWiseMasterRate->getRate() * $rateBookingWeight;                                
1645.                                         }
1646.                                     }
1647.                                 }        
1648.             
1649.                                 if($countryWiseMasterRate !== null)
1650.                                 {
1651.                                     $salesInvDetailsObj->setBookingRate($finalMasterRateCal);                            
1652.                                 }
1653.                                 else if($zoneWiseMasterRate !== null)
1654.                                 {
1655.                                     $salesInvDetailsObj->setBookingRate($finalMasterRateCal);                            
1656.                                 }
1657.                                 else
1658.                                 { 
1659.             
1660.                                     return new JsonResponse(array('success' => false, 'responseText' => 'Master Rate is not set for Courier : '.$courierObj->getName().', Country : '.$countryObj->getName().', Product Type : '.$productTypeObj->getName().', Weight : '.$rateWeight.' in Row Number '.$keyValue.'.'));
1661.                                 }
1662.                             }
1663.                             else
1664.                             {
1665.                                 if($rateBookingWeight <= 30) 
1666.                                 {
1667.                                     $zoneWiseMasterRate = $entityManager->getRepository(ZoneWiseMasterRate::class)
1668.                                         ->findBookingRatebyCourierAndWeight(
1669.                                             $shipmentObj->getShipmentType(), 
1670.                                             $zoneWiseMasterRateTypeObj->getRateType(), 
1671.                                             $courierObj->getId(), 
1672.                                             $courierWiseZoneObj->getZone()->getId(), 
1673.                                             $productTypeObj->getRateid(), 
1674.                                             $rateBookingWeight
1675.                                     );   
1676.                                     
1677.                                     $finalRate = $zoneWiseMasterRate->getRate();
1678.                                 }
1679.                                 else if($rateBookingWeight > 30 && $rateBookingWeight <= 70)
1680.                                 {
1681.                                     $zoneWiseMasterRateFs = $entityManager->getRepository(ZoneWiseMasterRate::class)
1682.                                         ->findBookingRatebyCourierAndWeight(
1683.                                             $shipmentObj->getShipmentType(), 
1684.                                             $zoneWiseMasterRateTypeObj->getRateType(), 
1685.                                             $courierObj->getId(), 
1686.                                             $courierWiseZoneObj->getZone()->getId(), 
1687.                                             $productTypeObj->getRateid(), 
1688.                                             30
1689.                                     );   
1690.     
1691.                                     $zoneWiseMasterRateSs = $entityManager->getRepository(ZoneWiseMasterRate::class)
1692.                                         ->findBookingRatebyCourierAndWeight(
1693.                                             $shipmentObj->getShipmentType(), 
1694.                                             $zoneWiseMasterRateTypeObj->getRateType(), 
1695.                                             $courierObj->getId(), 
1696.                                             $courierWiseZoneObj->getZone()->getId(), 
1697.                                             $productTypeObj->getRateid(), 
1698.                                             31
1699.                                     ); 
1700.                                     
1701.                                     $finalRate = $zoneWiseMasterRateFs->getRate() + (($rateBookingWeight - 30) * $zoneWiseMasterRateSs->getRate());
1702.                                 }
1703.                                 else if($rateBookingWeight > 70)
1704.                                 {
1705.                                     $zoneWiseMasterRateFs = $entityManager->getRepository(ZoneWiseMasterRate::class)
1706.                                         ->findBookingRatebyCourierAndWeight(
1707.                                             $shipmentObj->getShipmentType(), 
1708.                                             $zoneWiseMasterRateTypeObj->getRateType(), 
1709.                                             $courierObj->getId(), 
1710.                                             $courierWiseZoneObj->getZone()->getId(), 
1711.                                             $productTypeObj->getRateid(), 
1712.                                             30
1713.                                     );   
1714.     
1715.                                     $zoneWiseMasterRateSs = $entityManager->getRepository(ZoneWiseMasterRate::class)
1716.                                         ->findBookingRatebyCourierAndWeight(
1717.                                             $shipmentObj->getShipmentType(), 
1718.                                             $zoneWiseMasterRateTypeObj->getRateType(), 
1719.                                             $courierObj->getId(), 
1720.                                             $courierWiseZoneObj->getZone()->getId(), 
1721.                                             $productTypeObj->getRateid(), 
1722.                                             31
1723.                                     ); 
1724.     
1725.                                     $zoneWiseMasterRateTs = $entityManager->getRepository(ZoneWiseMasterRate::class)
1726.                                         ->findBookingRatebyCourierAndWeight(
1727.                                             $shipmentObj->getShipmentType(), 
1728.                                             $zoneWiseMasterRateTypeObj->getRateType(), 
1729.                                             $courierObj->getId(), 
1730.                                             $courierWiseZoneObj->getZone()->getId(), 
1731.                                             $productTypeObj->getRateid(), 
1732.                                             71
1733.                                     ); 
1734.     
1735.                                     $finalRate = $zoneWiseMasterRateFs->getRate() + (40 * $zoneWiseMasterRateSs->getRate()) + (($rateBookingWeight - 70) * $zoneWiseMasterRateTs->getRate());
1736.                                 }
1737.     
1738.                                 $salesInvDetailsObj->setBookingRate($finalRate);
1739.     
1740.                             }
1741.                         }
1742.                         else
1743.                         {
1744.                             
1745.                             // Expedite Rate 
1748.                             // $salesInvDetailsObj->setBookingRate($countryObj->getMasterExpediteRate() * $rateBookingWeight);   
1750.                             // Expedite Or Cash Master Rate
1751.                             $countryWiseCashMasterRate = $entityManager->getRepository(CountryWiseMasterRate::class) 
1752.                                                             ->findCashBookingRatebyCourierAndWeight(2, $salesInvDetailsObj->getShipmentDate(), $courierObj->getId(), $countryObj->getId(), $productTypeObj->getRateid(), $rateBookingWeight);                                          
1754.                             if($countryWiseCashMasterRate == null)
1755.                             {
1756.                                 $zoneWiseMasterRate = $entityManager->getRepository(ZoneWiseMasterRate::class)
1757.                                                         ->findBookingCashRatebyCourierAndWeight(3, $salesInvDetailsObj->getShipmentDate(), $courierObj->getId(), $courierWiseZoneObj->getZone()->getId(), $productTypeObj->getRateid(), $rateBookingWeight );                     
1759.                             }
1761.                             if($countryWiseCashMasterRate !== null)
1762.                             {
1763.                                 $salesInvDetailsObj->setBookingRate($countryWiseCashMasterRate->getRate() * $rateBookingWeight); 
1764.                             }
1765.                             else if($zoneWiseMasterRate !== null)      
1766.                             {                          
1767.                                 $salesInvDetailsObj->setBookingRate(round(($zoneWiseMasterRate->getRate() * $rateBookingWeight) / $settingsObj->getCurrency(),2));                           
1768.                             }
1769.                             else
1770.                             {
1771.                                 return new JsonResponse(array('success' => false, 'responseText' => 'Cash Master Rate is not set for Courier : '.$courierObj->getName().', Country : '.$countryObj->getName().', Product Type : '.$productTypeObj->getName().', Weight : '.$rateWeight.' in Row Number '.$keyValue.'.'));
1772.                             }
1775.                           //  return new JsonResponse(array('success' => false, 'responseText' =>  3 ));
1777.                         }
1778.                         //Master Rate Assign End
1779.         
1780.                         
1782.                         // Own Company Rate for Customer Start
1783.                         $salesCourierId = 0;
1784.                         $salesCourierName = "";
1785.                         $salesZoneId = 0;
1787.                         if($this->getUser()->getUserCompany()->getCustomerRate() == 2 ) // Own Company Wise Customer Rate
1788.                         {
1789.                             if($customerObj->getCustomerType() == 1 )  //Customer
1790.                             {
1791.                                 $salesCourierId = $this->getUser()->getUserCompany()->getCompanyCourier()->getId();
1792.                                 $salesCourierName = $this->getUser()->getUserCompany()->getCompanyCourier()->getName();
1793.     
1794.                                 /// Zone 
1795.                                 $courierWiseZoneObject = $entityManager->getRepository(CourierWiseZone::class)
1796.                                                     ->findOneBy(['courier' => $salesCourierId, 'country' => $countryObj->getId() ]);                       
1797.                                 if($courierWiseZoneObject === null )
1798.                                 {
1799.                                     return new JsonResponse(array('success' => false, 'responseText' => 'Courier Wise Zone is not set for Courier : '. $courierObj->getName().', and Country : '.$countryObj->getName().' in Row Number '.$keyValue.'.'));
1800.                                                                             
1801.                                 }
1802.     
1803.                                 $salesZoneId = $courierWiseZoneObject->getZone()->getId();
1804.                                                                 
1805.                             }
1806.                             else  //Agent
1807.                             {
1808.                                 $salesCourierId = $courierObj->getId();
1809.                                 $salesCourierName = $courierObj->getName();
1810.                                 $salesZoneId = $courierWiseZoneObj->getZone()->getId();
1811.                                 
1812.                             }
1813.                         }
1814.                         else   // Separate Courier Wise Customer Rate
1815.                         {
1816.                             $salesCourierId = $courierObj->getId();
1817.                             $salesCourierName = $courierObj->getName();
1818.                             $salesZoneId = $courierWiseZoneObj->getZone()->getId();
1819.                             
1820.                         }
1821.                         // Own Company Rate for Customer End
1822.                         
1823.                         
1824.                         // return new JsonResponse(array('success' => false, 'responseText' =>  123 ));
1825.                         if($salesInvDetailsObj->getRateApplicable() <= 2 &&  $salesInvDetailsObj->getShipment() === null)
1826.                         {
1827.                             
1828.                             // Accessaccessory Surcharge
1829.                             $salesInvDetailsObj->setSalesRate($salesRate_array[$index]);
1831.                         }
1832.                         else if($salesInvDetailsObj->getRateApplicable() <= 2 && !$salesInvDetailsObj->getShipment()->isExpedite()  && $salesInvDetailsObj->getShipment() !== null)  // Predefine Rate
1833.                         {
1834.                             
1835.                             //Sales Rate Assign Start 
1836.                             // if($customerObj->getRateCurrency() == 2)
1837.                             // {
1838.                             //     $perKgRateWeight = 21;
1839.                             // }
1840.     
1841.                             $finalRateCal = 0;
1842.     
1843.                             if($customerObj->getRateType() == 1)  // Customer wise sales rate     
1844.                             {
1845.                                 if($courierObj->getId() != 3)  
1846.                                 {
1847.                                     if($rateWeight < $perKgRateWeight )
1848.                                     { 
1849.                                         $countryWiseSalesRate = $entityManager->getRepository(CountryWiseSalesRate::class)
1850.                                                         ->findOneBy(['type' => $salesInvDetailsObj->getShipment()->getShipmentType(), 'customer' => $customerObj->getId(), 'courier' => $salesCourierId, 'country' => $countryObj->getId(), 'productType' => $productTypeObj->getRateid(), 'weight' => $rateWeight ]);                                        
1851.                                         if($countryWiseSalesRate !== null)     
1852.                                         {                         
1853.                                             $finalRateCal = $countryWiseSalesRate->getRate();
1854.                                         }
1855.                                     }
1856.                                     else
1857.                                     {
1858.                                         $countryWiseSalesRate = $entityManager->getRepository(CountryWiseSalesRate::class)
1859.                                                         ->findOneBy(['type' => $salesInvDetailsObj->getShipment()->getShipmentType(), 'customer' => $customerObj->getId(), 'courier' => $salesCourierId, 'country' => $countryObj->getId(), 'productType' => $productTypeObj->getRateid(), 'weight' => $perKgRateWeight ]);                           
1860.                                         if($countryWiseSalesRate !== null)     
1861.                                         { 
1862.                                             $finalRateCal = $countryWiseSalesRate->getRate() * $rateWeight;                                            
1863.                                         }
1864.                                     }
1865.                                 
1866.                                     if($countryWiseSalesRate === null)  
1867.                                     {
1868.                                         if($rateWeight < $perKgRateWeight )
1869.                                         {
1870.                                             $zoneWiseSalesRate = $entityManager->getRepository(ZoneWiseSalesRate::class)
1871.                                                                     ->findSalesRatebyCustomerAndWeight($salesInvDetailsObj->getShipment()->getShipmentType(), $customerObj->getId(), $salesCourierId, $salesZoneId, $productTypeObj->getRateid(), $rateWeight);                                     
1872.                                             if($zoneWiseSalesRate !== null)     
1873.                                             {                         
1874.                                                 $finalRateCal = $zoneWiseSalesRate->getRate();
1875.                                             }
1876.                                         }
1877.                                         else
1878.                                         {                                                             
1879.                                             $zoneWiseSalesRate = $entityManager->getRepository(ZoneWiseSalesRate::class) 
1880.                                                                     ->findSalesRatebyCustomerAndWeight($salesInvDetailsObj->getShipment()->getShipmentType(), $customerObj->getId(), $salesCourierId, $salesZoneId, $productTypeObj->getRateid(), $courierObj->getId() == 3 ?  $perKgRateWeight : $rateWeight );                       
1881.                                             
1882.                                             if($zoneWiseSalesRate !== null)     
1883.                                             { 
1884.                                                 $finalRateCal = $zoneWiseSalesRate->getRate() * $rateWeight;                                      
1885.                                             }
1886.                                         }
1887.                                     }        
1888.         
1889.                                     if($countryWiseSalesRate !== null)
1890.                                     {
1891.                                         $salesInvDetailsObj->setSalesRate($finalRateCal);
1892.                                         
1893.                                     }
1894.                                     else if($zoneWiseSalesRate !== null)
1895.                                     {
1896.                                         $salesInvDetailsObj->setSalesRate($finalRateCal);                                    
1897.                                     }
1898.                                     else
1899.                                     { 
1900.                                         return new JsonResponse(array('success' => false, 'responseText' => 'Customer Wise Sales Rate is not set for Customer : '.$customerObj->getName().' Courier : '.$salesCourierName.', Country : '.$countryObj->getName().', Product Type : '.$productTypeObj->getName().', Weight : '.$rateWeight.' in Row Number '.$keyValue.'.'));
1901.                                     }
1902.                                 }
1903.                                 else
1904.                                 {
1905.                                     if($rateWeight <= 30)
1906.                                     {
1907.                                         $zoneWiseSalesRate = $entityManager->getRepository(ZoneWiseSalesRate::class)
1908.                                             ->findSalesRatebyCustomerAndWeight(
1909.                                                 $shipmentObj->getShipmentType(), 
1910.                                                 $customerObj->getId(), 
1911.                                                 $salesCourierId, 
1912.                                                 $salesZoneId, 
1913.                                                 $productTypeObj->getRateid(), 
1914.                                                 $rateWeight
1915.                                             );   
1916.     
1917.                                         $finalSalesRate = $zoneWiseSalesRate->getRate();                      
1918.                                     }
1919.                                     else if($rateWeight > 30 && $rateWeight <= 70)
1920.                                     {
1921.                                         $zoneWiseSalesRateFs = $entityManager->getRepository(ZoneWiseSalesRate::class)
1922.                                             ->findSalesRatebyCustomerAndWeight(
1923.                                                 $shipmentObj->getShipmentType(), 
1924.                                                 $customerObj->getId(), 
1925.                                                 $salesCourierId, 
1926.                                                 $salesZoneId, 
1927.                                                 $productTypeObj->getRateid(), 
1928.                                                 30
1929.                                             );   
1930.                                         
1931.                                         $zoneWiseSalesRateSs = $entityManager->getRepository(ZoneWiseSalesRate::class)
1932.                                             ->findSalesRatebyCustomerAndWeight(
1933.                                                 $shipmentObj->getShipmentType(), 
1934.                                                 $customerObj->getId(), 
1935.                                                 $salesCourierId, 
1936.                                                 $salesZoneId, 
1937.                                                 $productTypeObj->getRateid(), 
1938.                                                 31
1939.                                             );  
1940.     
1941.                                         $finalSalesRate = $zoneWiseSalesRateFs->getRate() + (($rateWeight - 30) * $zoneWiseSalesRateSs->getRate()); 
1942.                                     }
1943.                                     else if($rateWeight > 70)
1944.                                     {
1945.                                         $zoneWiseSalesRateFs = $entityManager->getRepository(ZoneWiseSalesRate::class)
1946.                                             ->findSalesRatebyCustomerAndWeight(
1947.                                                 $shipmentObj->getShipmentType(), 
1948.                                                 $customerObj->getId(), 
1949.                                                 $salesCourierId, 
1950.                                                 $salesZoneId, 
1951.                                                 $productTypeObj->getRateid(), 
1952.                                                 30
1953.                                             );   
1954.                                     
1955.                                         $zoneWiseSalesRateSs = $entityManager->getRepository(ZoneWiseSalesRate::class)
1956.                                             ->findSalesRatebyCustomerAndWeight(
1957.                                                 $shipmentObj->getShipmentType(), 
1958.                                                 $customerObj->getId(), 
1959.                                                 $salesCourierId, 
1960.                                                 $salesZoneId, 
1961.                                                 $productTypeObj->getRateid(), 
1962.                                                 31
1963.                                             );  
1964.     
1965.                                         $zoneWiseSalesRateTs = $entityManager->getRepository(ZoneWiseSalesRate::class)
1966.                                             ->findSalesRatebyCustomerAndWeight(
1967.                                                 $shipmentObj->getShipmentType(), 
1968.                                                 $customerObj->getId(), 
1969.                                                 $salesCourierId, 
1970.                                                 $salesZoneId, 
1971.                                                 $productTypeObj->getRateid(), 
1972.                                                 71
1973.                                             ); 
1974.                                         
1975.                                         $finalSalesRate = $zoneWiseSalesRateFs->getRate() + (40 * $zoneWiseSalesRateSs->getRate()) + (($rateWeight - 70) * $zoneWiseSalesRateTs->getRate()); 
1976.                                     }
1977.                                     
1978.                                      $salesInvDetailsObj->setSalesRate($finalSalesRate);
1979.                                 }
1980.                             }
1981.                             else  // Common sales rate   
1982.                             {
1983.                                 if($rateWeight < $perKgRateWeight )
1984.                                 { 
1985.                                     $countryWiseSalesRate = $entityManager->getRepository(CountryWiseCommonSalesRate::class)
1986.                                                             ->findOneBy(['type' => $salesInvDetailsObj->getShipment()->getShipmentType(), 'courier' => $salesCourierId, 'country' => $countryObj->getId(), 'productType' => $productTypeObj->getRateid(), 'weight' => $rateWeight ]);                           
1987.                                 }
1988.                                 else
1989.                                 {
1990.                                     $countryWiseSalesRate = $entityManager->getRepository(CountryWiseCommonSalesRate::class)
1991.                                                             ->findOneBy(['type' => $salesInvDetailsObj->getShipment()->getShipmentType(), 'courier' => $salesCourierId, 'country' => $countryObj->getId(), 'productType' => $productTypeObj->getRateid(), 'weight' => $perKgRateWeight ]);                           
1992.                                     if($countryWiseSalesRate !== null)     
1993.                                     {   
1994.                                         $countryWiseSalesRate->setRate($countryWiseSalesRate->getRate() * $rateWeight);
1995.                                     }
1996.                                 }
1997.                                     
1998.     
1999.                                 if($countryWiseSalesRate === null)  
2000.                                 {
2001.                                     if($rateWeight < $perKgRateWeight )
2002.                                     {
2003.                                         $zoneWiseSalesRate = $entityManager->getRepository(ZoneWiseCommonSalesRate::class)
2004.                                                                 ->findCommonSalesRatebyCourierAndWeight($salesInvDetailsObj->getShipment()->getShipmentType(), $salesCourierId, $salesZoneId, $productTypeObj->getRateid(), $rateWeight);                                     
2005.                                     }
2006.                                     else
2007.                                     {
2008.                                         $zoneWiseSalesRate = $entityManager->getRepository(ZoneWiseCommonSalesRate::class)
2009.                                                                 ->findCommonSalesRatebyCourierAndWeight($salesInvDetailsObj->getShipment()->getShipmentType(), $salesCourierId, $salesZoneId, $productTypeObj->getRateid(), $courierObj->getId() == 3 ?  $perKgRateWeight : $rateWeight );                       
2010.                                         if($zoneWiseSalesRate !== null)     
2011.                                         {       
2012.                                             $zoneWiseSalesRate->setRate($zoneWiseSalesRate->getRate() * $rateWeight);
2013.                                         }
2014.                                     }
2015.                                 }        
2016.     
2017.                                 if($countryWiseSalesRate !== null)
2018.                                 {
2019.                                     $salesInvDetailsObj->setSalesRate($zoneWiseSalesRate->getRate());
2020.                                 }
2021.                                 else if($zoneWiseSalesRate !== null)
2022.                                 {
2023.                                     $salesInvDetailsObj->setSalesRate($countryWiseSalesRate->getRate());
2024.                                 }
2025.                                 else
2026.                                 {
2027.                                     return new JsonResponse(array('success' => false, 'responseText' => 'Common Sales Rate is not set for Courier : '.$salesCourierName.', Country : '.$countryObj->getName().', Product Type : '.$productTypeObj->getName().', Weight : '.$rateWeight.' in Row Number '.$keyValue.'.'));
2028.                                 }
2029.                             }
2030.                             //Sales Rate Assign End
2031.                             
2032.                         }
2033.                         else  // Special Calculated Rate
2034.                         {
2035.                             
2036.                            $salesInvDetailsObj->setSalesRate($salesRate_array[$index]);                  
2037.                         }
2038.     
2039.                         
2041.                         // Master Weight and Sales Rate Calculation Start                                
2042.                         if($salesInvDetailsObj->getShipment() !== null && $salesInvDetailsObj->getRateApplicable() <= 2 && !$salesInvDetailsObj->getShipment()->isExpedite())  // Predefine Rate
2043.                         {
2044.                             
2045.                             //Sales Rate Assign Start 
2046.                             // if($customerObj->getRateCurrency() == 2)
2047.                             // {
2048.                             //     $perKgRateWeight = 21;
2049.                             // }
2050.     
2051.                             $finalRateCal = 0;
2052.     
2053.                             if($customerObj->getRateType() == 1)  // Customer wise sales rate     
2054.                             {
2055.                                 if($rateBookingWeight < $perKgRateWeight )
2056.                                 { 
2057.                                   $countryWiseSalesRate = $entityManager->getRepository(CountryWiseSalesRate::class)
2058.                                                     ->findOneBy(['type' => $salesInvDetailsObj->getShipment()->getShipmentType(), 'customer' => $customerObj->getId(), 'courier' => $courierObj->getId(), 'country' => $countryObj->getId(), 'productType' => $productTypeObj->getRateid(), 'weight' => $rateBookingWeight ]);                              
2059.                                     if($countryWiseSalesRate !== null)     
2060.                                     {                         
2061.                                         $finalRateCal = $countryWiseSalesRate->getRate();
2062.                                     }
2063.                                 }
2064.                                 else
2065.                                 {
2066.                                      $countryWiseSalesRate = $entityManager->getRepository(CountryWiseSalesRate::class)
2067.                                                     ->findOneBy(['type' => $salesInvDetailsObj->getShipment()->getShipmentType(), 'customer' => $customerObj->getId(), 'courier' => $courierObj->getId(), 'country' => $countryObj->getId(), 'productType' => $productTypeObj->getRateid(), 'weight' => $perKgRateWeight ]);
2068.                                     if($countryWiseSalesRate !== null)     
2069.                                     { 
2070.                                         $finalRateCal = $countryWiseSalesRate->getRate() * $rateBookingWeight;                                            
2071.                                     }
2072.                                 }
2073.                             
2074.                                 if($countryWiseSalesRate === null)  
2075.                                 {
2076.                                     if($rateBookingWeight < $perKgRateWeight )
2077.                                     {
2078.                                         $zoneWiseSalesRate = $entityManager->getRepository(ZoneWiseSalesRate::class)
2079.                                                                 ->findSalesRatebyCustomerAndWeight($salesInvDetailsObj->getShipment()->getShipmentType(), $customerObj->getId(), $courierObj->getId(), $courierWiseZoneObj->getZone()->getId(), $productTypeObj->getRateid(), $rateBookingWeight);                                     
2080.                                         // return new JsonResponse(array('success' => false, 'responseText' => $rateBookingWeight .'-'. $zoneWiseSalesRate->getRate() ));                           
2081.                                         if($zoneWiseSalesRate !== null)     
2082.                                         {                         
2083.                                             $finalRateCal = $zoneWiseSalesRate->getRate();
2084.                                         }
2085.                                     }
2086.                                     else
2087.                                     {                                                             
2088.                                         $zoneWiseSalesRate = $entityManager->getRepository(ZoneWiseSalesRate::class) 
2089.                                                                 ->findSalesRatebyCustomerAndWeight($salesInvDetailsObj->getShipment()->getShipmentType(), $customerObj->getId(), $courierObj->getId(), $courierWiseZoneObj->getZone()->getId(), $productTypeObj->getRateid(), $courierObj->getId() == 3 ?  $perKgRateWeight : $rateWeight );                       
2090.                                         
2091.                                         if($zoneWiseSalesRate !== null)     
2092.                                         { 
2093.                                             $finalRateCal = $zoneWiseSalesRate->getRate() * $rateBookingWeight;                                      
2094.                                         }
2095.                                     }
2096.                                 }        
2097.     
2098.                                 if($countryWiseSalesRate !== null)
2099.                                 {
2100.                                     $salesInvDetailsObj->setSalesMasterRate($finalRateCal);
2101.                                     
2102.                                 }
2103.                                 else if($zoneWiseSalesRate !== null)
2104.                                 {
2105.                                     $salesInvDetailsObj->setSalesMasterRate($finalRateCal);                                    
2106.                                 }
2107.                                 else
2108.                                 {                                   
2109.                                     return new JsonResponse(array('success' => false, 'responseText' => 'Customer Wise Sales Rate is not set for Customer : '.$customerObj->getName().' Courier : '.$salesCourierName.', Country : '.$countryObj->getName().', Product Type : '.$productTypeObj->getName().', Weight : '.$rateWeight.' in Row Number '.$keyValue.'.'));
2110.                                 }
2111.                             }
2112.                             else  // Common sales rate   
2113.                             {
2114.                                 if($rateBookingWeight < $perKgRateWeight )
2115.                                 { 
2116.                                     $countryWiseSalesRate = $entityManager->getRepository(CountryWiseCommonSalesRate::class)
2117.                                                             ->findOneBy(['type' => $salesInvDetailsObj->getShipment()->getShipmentType(), 'courier' => $courierObj->getId(), 'country' => $countryObj->getId(), 'productType' => $productTypeObj->getRateid(), 'weight' => $rateBookingWeight ]);                           
2118.                                 }
2119.                                 else
2120.                                 {
2121.                                     $countryWiseSalesRate = $entityManager->getRepository(CountryWiseCommonSalesRate::class)
2122.                                                             ->findOneBy(['type' => $salesInvDetailsObj->getShipment()->getShipmentType(), 'courier' => $courierObj->getId(), 'country' => $countryObj->getId(), 'productType' => $productTypeObj->getRateid(), 'weight' => $perKgRateWeight ]);                           
2123.                                     if($countryWiseSalesRate !== null)     
2124.                                     {   
2125.                                         $countryWiseSalesRate->setRate($countryWiseSalesRate->getRate() * $rateWeight);
2126.                                     }
2127.                                 }
2128.                                     
2129.     
2130.                                 if($countryWiseSalesRate === null)  
2131.                                 {
2132.                                     if($rateWeight < $perKgRateWeight )
2133.                                     {
2134.                                         $zoneWiseSalesRate = $entityManager->getRepository(ZoneWiseCommonSalesRate::class)
2135.                                                                 ->findCommonSalesRatebyCourierAndWeight($salesInvDetailsObj->getShipment()->getShipmentType(), $courierObj->getId(), $courierWiseZoneObj->getZone()->getId(), $productTypeObj->getRateid(), $rateBookingWeight);                                     
2136.                                     }
2137.                                     else
2138.                                     {
2139.                                         $zoneWiseSalesRate = $entityManager->getRepository(ZoneWiseCommonSalesRate::class)
2140.                                                                 ->findCommonSalesRatebyCourierAndWeight($salesInvDetailsObj->getShipment()->getShipmentType(), $courierObj->getId(), $courierWiseZoneObj->getZone()->getId(), $productTypeObj->getRateid(), $courierObj->getId() == 3 ?  $perKgRateWeight : $rateBookingWeight );                       
2141.                                         if($zoneWiseSalesRate !== null)     
2142.                                         {       
2143.                                             $zoneWiseSalesRate->setRate($zoneWiseSalesRate->getRate() * $rateBookingWeight);
2144.                                         }
2145.                                     }
2146.                                 }        
2147.     
2148.                                 if($countryWiseSalesRate !== null)
2149.                                 {
2150.                                     $salesInvDetailsObj->setSalesMasterRate($zoneWiseSalesRate->getRate());
2151.                                 }
2152.                                 else if($zoneWiseSalesRate !== null)
2153.                                 {
2154.                                     $salesInvDetailsObj->setSalesMasterRate($countryWiseSalesRate->getRate());
2155.                                 }
2156.                                 else
2157.                                 {                                   
2158.                                     return new JsonResponse(array('success' => false, 'responseText' => 'Common Sales Rate is not set for Courier : '.$salesCourierName.', Country : '.$countryObj->getName().', Product Type : '.$productTypeObj->getName().', Weight : '.$rateWeight.' in Row Number '.$keyValue.'.'));
2159.                                 }
2160.                             }
2161.                             //Sales Rate Assign End
2162.                             
2163.                         }
2164.                         else if($salesInvDetailsObj->getShipment() === null)
2165.                         {
2166.                             
2167.                             $salesInvDetailsObj->setSalesMasterRate($salesInvDetailsObj->getBookingRate());
2168.                         }
2169.                         else  // Special Calculated Rate
2170.                         {
2171.                             
2172.                             // Get Settings Currency Start
2173.                             $settingsObj = $settingsInfoRepository
2174.                                                 ->findByDateCurrency(1, $salesInvDetailsObj->getShipmentDate()->format('Y-m-d')); 
2175.     
2176.                             if($settingsObj === null)
2177.                             {                                
2178.                                 return new JsonResponse(array('success' => false, 'responseText' => 'Currency is not set in Settings for Month : '.$salesInvoiceDetailsObj->getShipmentDate()->format('F').'-'.$salesInvoiceDetailsObj->getShipmentDate()->format('Y').' in Row Number '.$keyValue.'.'));
2179.                             }                       
2180.                             // Get Settings Currency End
2181.     
2182.                             $salesInvDetailsObj->setSalesMasterRate(round((float)$salesRate_array[$index] / $settingsObj->getCurrency(),2));                        
2183.                         }                    
2184.     
2185.                         // Master Weight and Sales Rate Calculation End
2186.     
2187.                          // SRO Calculation Start
2188.                         if($salesInvDetailsObj->getShipment() !== null && $courierObj->getSro() == 1 && $salesInvDetailsObj->getRateApplicable() <= 2 && !$salesInvDetailsObj->getShipment()->isExpedite())
2189.                         {
2190.                             $salesInvDetailsObj->setSro($courierObj->getSroCharge());
2191.                         }
2192.                         else
2193.                         {
2194.                             $salesInvDetailsObj->setSro(0);
2195.                         }
2196.                         // SRO Calculation End
2197.                     
2198.                         //Master Covid Charge Cal Start
2199.                         if($salesInvDetailsObj->getRateApplicable() <= 3 && $salesInvDetailsObj->getShipment() !== null && !$salesInvDetailsObj->getShipment()->isExpedite())
2200.                         {
2201.                             if($courierObj->getCovidChargeApplicable() == 1 && $courierObj->getId() == 1)  // DHL Covid Charge Cal
2202.                             {
2203.                                
2204.                                 // // Demand Charge Start
2205.                                 // $comparisonDate = new DateTime('2024-09-14');
2207.                                 // if($salesInvDetailsObj->getShipmentDate() > $comparisonDate)
2208.                                 // {
2209.                                 //     $countryWiseCovidCharge = $entityManager->getRepository(CountryWiseCovidCharge::class)
2210.                                 //                                 ->findOneBy(['courier' => $courierObj->getId(), 'country' => $countryObj->getId() ]); 
2211.                                     
2212.                                 //     if($countryWiseCovidCharge !== null)
2213.                                 //     {                          
2214.                                 //         $salesInvDetailsObj->setVendorCovidCharge($countryWiseCovidCharge->getRate() * $rateBookingWeight);                                       
2215.                                 //     }
2216.                                 //     else
2217.                                 //     {
2218.                                 //         return new JsonResponse(array('success' => false, 'responseText' => 'Demand Charge is not set for Courier : '.$courierObj->getName().', Country : '.$countryObj->getName().' in Row Number '.$keyValue.'.'));
2219.                                 //     }   
2220.                                 // }                          
2221.                                 // // Demand Charge End
2222.                                 
2223.                                 // // Go Green Charge Start
2224.                                 // $comparisonDate = new DateTime('2024-04-01');
2225.     
2226.                                 // if ($salesInvDetailsObj->getShipmentDate() < $comparisonDate) {
2227.                                 //     if($countryObj->getId() == 11 || $countryObj->getId() == 151)
2228.                                 //     {
2229.                                 //         $covidChargeUsd = 3.35;
2230.                                 //     }
2231.                                 //     else
2232.                                 //     {
2233.                                 //         $covidChargeUsd = 1.15;
2234.                                 //     }
2235.                                 // } else {
2236.                                 //     if($countryObj->getId() == 11 || $countryObj->getId() == 151)
2237.                                 //     {
2238.                                 //         $covidChargeUsd = 0.56;
2239.                                 //     }
2240.                                 //     else
2241.                                 //     {
2242.                                 //         $covidChargeUsd = 0.56;
2243.                                 //     }
2244.                                 // }
2245.     
2246.                                 // $salesInvDetailsObj->setVendorCovidCharge($covidChargeUsd * $rateBookingWeight);
2247.                                 // // Go Green Charge End
2249.                           
2250.                                   
2251.                                     
2252.                             }
2253.                             else if($courierObj->getCovidChargeApplicable() == 1 && $courierObj->getId() == 2) // Fedex Covid Charge Cal
2254.                             {
2255.                                 // Demand Charge Start
2256.                                 $comparisonDate = new DateTime('2024-11-17');
2258.                                 if($salesInvDetailsObj->getShipmentDate() > $comparisonDate)
2259.                                 {
2260.                                     $zoneWiseCovidCharge = $entityManager->getRepository(ZoneWiseCovidCharge::class)
2261.                                                         ->findOneBy(['courier' => $courierObj->getId(), 'zone' => $courierWiseZoneObj->getZone() ]); 
2262.                                     if($zoneWiseCovidCharge !== null)
2263.                                     {
2264.                                         $demandCharge =  $zoneWiseCovidCharge->getRate() * $rateBookingWeight;  
2265.                                     
2266.                                         if($demandCharge < 1)
2267.                                             $salesInvDetailsObj->setVendorCovidCharge(1);
2268.                                         else
2269.                                             $salesInvDetailsObj->setVendorCovidCharge($demandCharge);
2270.                                     }                         
2271.                                     else
2272.                                     {
2273.                                         return new JsonResponse(array('success' => false, 'responseText' => 'Demand Charge is not set for Courier : '.$courierObj->getName().', Country : '.$countryObj->getName().' in Row Number '.$keyValue.'.'));
2274.                                     }
2275.                                 
2276.                                 }
2277.                                 else
2278.                                 {
2279.                                     if($rateBookingWeight <= 3)
2280.                                     {
2281.                                         $salesInvDetailsObj->setVendorCovidCharge(1);
2282.                                     }
2283.                                     else
2284.                                     {
2285.                                         $salesInvDetailsObj->setVendorCovidCharge($rateBookingWeight * 0.30);
2286.                                     }
2287.                                 }
2288.                             }
2289.                         }
2290.                         else
2291.                         {                            
2292.                             $salesInvDetailsObj->setVendorCovidCharge(0);
2293.                         }
2294.                         //Master Covid Charge Cal End
2297.                         //Sales Covid Charge Cal Start
2298.                         if($salesInvDetailsObj->getRateApplicable() <= 2 && $salesInvDetailsObj->getShipment() !== null && !$salesInvDetailsObj->getShipment()->isExpedite())
2299.                         {
2300.                             if($courierObj->getCovidChargeApplicable() == 1 && $courierObj->getId() == 1)  // DHL Covid Charge Cal
2301.                             {
2302.                             
2303.                                 // // Demand Charge Start
2304.                                 // $comparisonDate = new DateTime('2024-09-14');
2306.                                 // if($salesInvDetailsObj->getShipmentDate() > $comparisonDate)
2307.                                 // {
2308.                                 //     $countryWiseCovidCharge = $entityManager->getRepository(CountryWiseCovidCharge::class)
2309.                                 //                                 ->findOneBy(['courier' => $courierObj->getId(), 'country' => $countryObj->getId() ]); 
2310.                                     
2311.                                 //     if($countryWiseCovidCharge !== null)
2312.                                 //     {                
2313.                                        
2314.                                 //         $salesInvDetailsObj->setCovidCharge($countryWiseCovidCharge->getRate() * $rateWeight);  
2315.                                 //     }
2316.                                 //     else
2317.                                 //     {
2318.                                 //         return new JsonResponse(array('success' => false, 'responseText' => 'Demand Charge is not set for Courier : '.$courierObj->getName().', Country : '.$countryObj->getName().' in Row Number '.$keyValue.'.'));
2319.                                 //     }   
2320.                                 // }                          
2321.                                 // // Demand Charge End
2322.                                 
2323.                                 // // Go Green Charge Start
2324.                                 // $comparisonDate = new DateTime('2024-04-01');
2325.     
2326.                                 // if ($salesInvDetailsObj->getShipmentDate() < $comparisonDate) {
2327.                                 //     if($countryObj->getId() == 11 || $countryObj->getId() == 151)
2328.                                 //     {
2329.                                 //         $covidChargeUsd = 3.35;
2330.                                 //     }
2331.                                 //     else
2332.                                 //     {
2333.                                 //         $covidChargeUsd = 1.15;
2334.                                 //     }
2335.                                 // } else {
2336.                                 //     if($countryObj->getId() == 11 || $countryObj->getId() == 151)
2337.                                 //     {
2338.                                 //         $covidChargeUsd = 0.56;
2339.                                 //     }
2340.                                 //     else
2341.                                 //     {
2342.                                 //         $covidChargeUsd = 0.56;
2343.                                 //     }
2344.                                 // }
2345.                                 
2346.                                 // $salesInvDetailsObj->setCovidCharge($covidChargeUsd * $rateWeight);
2347.                                 // // Go Green Charge End
2349.                                                                     
2350.                             }
2351.                             else if($courierObj->getCovidChargeApplicable() == 1 && $courierObj->getId() == 2) // Fedex Covid Charge Cal
2352.                             {
2353.                                 // Demand Charge Start
2354.                                 $comparisonDate = new DateTime('2024-11-17');
2356.                                 if($salesInvDetailsObj->getShipmentDate() > $comparisonDate)
2357.                                 {
2358.                                     $zoneWiseCovidCharge = $entityManager->getRepository(ZoneWiseCovidCharge::class)
2359.                                                         ->findOneBy(['courier' => $courierObj->getId(), 'zone' => $courierWiseZoneObj->getZone() ]); 
2360.                                     if($zoneWiseCovidCharge !== null)
2361.                                     {
2362.                                         $demandCharge =  $zoneWiseCovidCharge->getRate() * $rateWeight;  
2363.                                     
2364.                                         if($demandCharge < 1)
2365.                                             $salesInvDetailsObj->setCovidCharge(1);
2366.                                         else
2367.                                             $salesInvDetailsObj->setCovidCharge($demandCharge);
2368.                                     }                         
2369.                                     else
2370.                                     {
2371.                                         return new JsonResponse(array('success' => false, 'responseText' => 'Demand Charge is not set for Courier : '.$courierObj->getName().', Country : '.$countryObj->getName().' in Row Number '.$keyValue.'.'));
2372.                                     }
2373.                                 
2374.                                 }
2375.                                 else
2376.                                 {
2377.                                     if($rateWeight <= 3)
2378.                                     {
2379.                                         $salesInvDetailsObj->setCovidCharge(1);
2380.                                     }
2381.                                     else
2382.                                     {
2383.                                         $salesInvDetailsObj->setCovidCharge($rateWeight * 0.30);
2384.                                     }
2385.                                 }
2386.                             
2387.                             }
2388.                         }
2389.                         else
2390.                         {
2391.                             $salesInvDetailsObj->setCovidCharge(0);                             
2392.                         }
2393.                         //Sales Covid Charge Cal End
2394.                         
2395.                         if($salesInvDetailsObj->getShipment() !== null && !$salesInvDetailsObj->getShipment()->isExpedite())
2396.                         {
2397.                         
2398.                             $shipmentDate = $salesInvDetailsObj->getShipmentDate();
2399.             
2400.                             // Get Settings Currency Start
2401.                             $settingsObj = $settingsInfoRepository
2402.                                             ->findByDateCurrency(1, $shipmentDate->format('Y-m-d')); 
2403.             
2404.                             if($settingsObj === null)
2405.                             {                                
2406.                                 
2407.                                 return new JsonResponse(array('success' => false, 'responseText' => 'Currency is not set in Settings for Month : '.$salesInvoiceDetailsObj->getShipmentDate()->format('F').'-'.$salesInvoiceDetailsObj->getShipmentDate()->format('Y').' in Row Number '.$keyValue.'.'));
2408.                             }                       
2409.                             // Get Settings Currency End
2410.             
2411.                             // Get Vendor FSC Start
2412.                             $vendorFscObj = $settingsInfoRepository
2413.                                             ->findByDate(2, $courierObj->getId(), $shipmentDate->format('Y-m-d')); 
2414.             
2415.                             if($vendorFscObj === null)
2416.                             {                               
2417.                                 return new JsonResponse(array('success' => false, 'responseText' => 'FSC is not set in FSC Setup for Courier: '.$courierObj->getName().' Month : '.$shipmentDate->format('F').'-'.$shipmentDate->format('Y').' in Row Number '.$keyValue.'.'));
2418.                             }                       
2419.                             // Get Vendor FSC End
2420.             
2421.                             // Get Customer FSC Start
2422.                             $fscObj = $settingsInfoRepository
2423.                                             ->findByDate(2, $this->getUser()->getUserCompany()->getCustomerRate() == 1 ? $courierObj->getId() : $salesCourierId, $shipmentDate->format('Y-m-d')); 
2424.             
2425.                             if($fscObj === null)
2426.                             {                                
2427.                                 
2428.                                 return new JsonResponse(array('success' => false, 'responseText' => 'FSC is not set in FSC Setup for Month : '.$shipmentDate->format('F').'-'.$shipmentDate->format('Y').' in Row Number '.$keyValue.'.'));
2429.                             }                       
2430.                             // Get Customer FSC End
2431.             
2432.             
2433.                             if($customerObj->getRateCurrency() == 2)
2434.                             {
2435.                                 $salesInvDetailsObj->setCurrency(1);
2436.                             }
2437.                             else
2438.                             {
2439.                                 $salesInvDetailsObj->setCurrency($customerObj->getCurrency() == 0 ? $settingsObj->getCurrency() : $customerObj->getCurrency() );
2440.                             }
2441.             
2442.                             $salesInvDetailsObj->setVendorCurrency($courierObj->getId() == 1 ?  $settingsObj->getVendorCurrency() : $settingsObj->getCurrency());
2443.             
2444.                             if($salesInvDetailsObj->getRateApplicable() <= 2)
2445.                                 $salesInvDetailsObj->setFsc( $customerObj->getFsc() == 0 ? $fscObj->getCurrency() : $customerObj->getFsc() ); 
2446.                             else
2447.                                 $salesInvDetailsObj->setFsc(0); 
2448.             
2449.                             if($salesInvDetailsObj->getRateApplicable() <= 3)
2450.                                 $salesInvDetailsObj->setVendorFsc($vendorFscObj->getCurrency()); 
2451.                             else
2452.                                 $salesInvDetailsObj->setVendorFsc(0);
2453.                         }
2454.                         else
2455.                         {
2456.                             $salesInvDetailsObj->setVendorFsc(0);
2457.                             $salesInvDetailsObj->setFsc(0); 
2458.                         }
2459.                             
2460.                         $salesInvoice->addSalesInvoiceDetail($salesInvDetailsObj);
2461.         
2462.         
2463.                         // // DHL Go Green Plus Fee Start
2464.                         // if($row->getCourier()->getId() == 1)
2465.                         // {
2466.                         //     $invoiceAdditionalChargeObj = new InvoiceAdditionalCharge();
2467.                         //     $invoiceAdditionalChargeObj->setAdditionalCharge($entityManager->find(AdditionalCharge::class, 4)); // 4 for Go Green Plus Fee
2468.                         //     $invoiceAdditionalChargeObj->setCharge($receivableGoGreen);
2469.                         //     $invoiceAdditionalChargeObj->setFsc(0);
2470.                         //     $invoiceAdditionalChargeObj->setVat(0);
2471.                         //     $invoiceAdditionalChargeObj->setPayableCharge($payableGoGreen);
2472.                         //     $salesInvoiceDetailsObj->addInvoiceAdditionalCharge($invoiceAdditionalChargeObj);
2473.                         // }
2474.                         // // DHL Go Green Plus Fee Start
2475.                         
2476.                         
2477.                         
2478.                                     
2479.                         //////////
2482.                     }
2483.                     else if($additionalChargeId_array[$index] !== null)
2484.                     {  
2485.                         $invoiceAdditionalChargeObj = $entityManager->find(InvoiceAdditionalCharge::class, $additionalChargeId_array[$index]);  
2487.                         $additionalChargeObj = $entityManager->find(AdditionalCharge::class, $additionalCharge_array[$index]);       
2488.                         $invoiceAdditionalChargeObj->setAdditionalCharge($additionalChargeObj);
2490.                         $invoiceAdditionalChargeObj->setCharge($additionalReceivableAmount_array[$index]);
2491.                         $invoiceAdditionalChargeObj->setPayableCharge($additionalPayableAmount_array[$index]);
2492.                         $invoiceAdditionalChargeObj->setFsc($additionalFscApplicable_array[$index]);
2493.                         $invoiceAdditionalChargeObj->setVat($additionalVatApplicable_array[$index]);
2494.                         
2495.                         $salesInvDetailsObj->addInvoiceAdditionalCharge($invoiceAdditionalChargeObj);
2496.                     }
2498.                     $index++;
2499.                 } 
2500.                 
2501.                  // Start remove item by Edit
2502.                  foreach($originalSalesInvoiceDetails as $key=>$salesInvDetails)
2503.                  {                   
2504.                      //check if the shaft is in the $project->getShaft()
2505.                      if($salesInvoice->getSalesInvoiceDetails()->contains($salesInvDetails) === false)
2506.                      {                        
2507.                          $entityManager->remove($salesInvDetails);                        
2508.                      }                  
2509.                  }  
2510.                  
2511.                  $formInvoiceAdditionalCharge = new ArrayCollection();
2512.  
2513.                  foreach($salesInvoice->getSalesInvoiceDetails() as $formSid)
2514.                  {
2515.                      foreach($formSid->getInvoiceAdditionalCharges() as $key=>$formAcd)
2516.                      {                       
2517.                          $formInvoiceAdditionalCharge->add($formAcd);
2518.                      }
2519.                  }
2520.                               
2521.                  foreach($originalInvoiceAdditionalCharge as $key=>$orInvoiceAdditionalCharge)
2522.                  {                   
2523.                      if($formInvoiceAdditionalCharge->contains($orInvoiceAdditionalCharge) === false)
2524.                      { 
2525.                          $entityManager->remove($orInvoiceAdditionalCharge);                        
2526.                      }
2527.                  }
2528.                  // End remove item by Edit
2530.                 
2531.                 $entityManager->flush();             
2533.                 $this->addFlash('notice', 'Invoice Updated successfully!');
2534.                 
2535.                 return new JsonResponse(array('success' => true, 'responseText' =>  'Data Saved successfully' ));                
2536.             }
2537.         }
2539.         return $this->renderForm('sales_invoice/edit.html.twig', [
2540.             'sales_invoice' => $salesInvoice,
2541.             'form' => $form,
2542.             'countryList' => $countryList,
2543.             'courierList' => $courierList,
2544.             'productTypeList' => $productTypeList,
2545.             'additionalChargeList' => $additionalChargeList,
2546.         ]);
2547.     }
2550.     #[Route('/salesinvoice/{id}/delete', name: 'app_sales_invoice_delete', methods: ['POST'])]
2551.     #[IsGranted("ROLE_ACCOUNTS")]
2552.     public function delete(Request $request, SalesInvoice $salesInvoice, SalesInvoiceRepository $salesInvoiceRepository): Response
2553.     {
2554.         if ($this->isCsrfTokenValid('delete'.$salesInvoice->getId(), $request->request->get('_token'))) {
2555.             $salesInvoiceRepository->remove($salesInvoice, true);
2556.         }
2558.         return $this->redirectToRoute('app_sales_invoice_index', [], Response::HTTP_SEE_OTHER);
2559.     }
2561.     #[Route('/salesinvoice/{id}/invoice/{currencyType}', name: 'app_sales_invoice_invoice')]  
2562.     #[IsGranted("ROLE_ACCOUNTS")]
2563.     public function invoice(int $id, int $currencyType, ReceiveVoucherRepository $receiveVoucherRepository, ShipmentRepository $shipmentRepository, SalesInvoiceRepository $salesInvoiceRepository, SalesInvoiceDetailsRepository $salesInvoiceDetailsRepository)
2564.     {
2565.         $salesInvoice = $salesInvoiceRepository->findBySingleOrderObj($id);
2566.             
2567.         // Configure Dompdf according to your needs
2568.         $pdfOptions = new Options();
2569.         $pdfOptions->set('defaultFont', 'Arial');
2570.             
2571.         // Instantiate Dompdf with our options
2572.         $dompdf = new Dompdf($pdfOptions);
2573.        
2574.         $userObj = $this->getUser();
2575.         
2576.         if($salesInvoice->getCustomer()->getLastReceivedAmount() == 1)
2577.         {
2578.             $lastReceivedObj = $receiveVoucherRepository->findReceiveVoucherByCustomer($salesInvoice->getCustomer()->getId(), $this->getUser()->getUserCompany()->getId());
2579.         }
2580.         else
2581.         {
2582.             $lastReceivedObj = null;
2583.         }
2585.         if($salesInvoice->getCustomer()->getPreviousDuesAmount() == 1)
2586.         {
2587.             $duesAmount = $shipmentRepository->getCustomerPreviousDuesCalculation($this->getUser()->getUserCompany()->getId(), $salesInvoice->getCustomer()->getId(), 
2588.             $salesInvoice->getSubmissionDate() ? $salesInvoice->getSubmissionDate()->format('Y-m-d') : $salesInvoice->getInvoiceDate()->format('Y-m-d'),
2589.             $salesInvoice->getId()
2590.             );
2591.             $duesAmount = $duesAmount[0];
2592.            
2593.             
2594.         }
2595.         else
2596.         {
2597.             $duesAmount = 0;
2598.         }
2599.        
2600.         $groupByCourier = $salesInvoiceDetailsRepository->findGroupByCourier($id);
2601.         
2602.         $totalReceivedAmount = $receiveVoucherRepository->findTotalReceivedAmountBySalesInvoiceId($id, $salesInvoice->getInvoiceDate());
2604.         $totalReceivedAmount = $totalReceivedAmount !== null ? $totalReceivedAmount : 0;
2605.          
2606.         // Retrieve the HTML generated in our twig file 
2607.         if($salesInvoice->getRateApplicable() <= 3)
2608.         {
2609.             $html = $this->renderView('sales_invoice/invoice.html.twig', [
2610.                 'salesInvoice' => $salesInvoice, 
2611.                 'userObj' => $userObj,
2612.                 'lastReceivedObj' => $lastReceivedObj,
2613.                 'duesAmount' => $duesAmount,
2614.                 'userCompanyLogo' => $this->imageToBase64($this->getParameter('kernel.project_dir') . '/public/uploads/usercompanylogo/'. $userObj->getUserCompany()->getLogoPath() ),         
2615.                 'currencyType' => $currencyType,
2616.                 'groupByCourier' => $groupByCourier,
2617.                 'totalReceivedAmount' => $totalReceivedAmount,
2618.             ]);
2619.         }
2620.         else
2621.         {
2622.             $html = $this->renderView('sales_invoice/invoice.html.twig', [
2623.                 'salesInvoice' => $salesInvoice, 
2624.                 'userObj' => $userObj,
2625.                 'lastReceivedObj' => $lastReceivedObj,
2626.                 'duesAmount' => $duesAmount,
2627.                 'userCompanyLogo' => $this->imageToBase64($this->getParameter('kernel.project_dir') . '/public/uploads/usercompanylogo/'. $userObj->getUserCompany()->getLogoPath() ),         
2628.                 'currencyType' => $currencyType,
2629.                 'groupByCourier' => $groupByCourier, 
2630.                 'totalReceivedAmount' => $totalReceivedAmount,
2631.             ]);
2632.         }
2633.        
2634.          
2635.         // Load HTML to Dompdf
2636.         $dompdf->loadHtml($html);
2637.         
2638.         // (Optional) Setup the paper size and orientation 'portrait' or 'landscape'
2639.         $dompdf->setPaper('A4', 'portrait');
2641.         // Render the HTML as PDF
2642.         $dompdf->render();
2644.         //  Add Watermark in Domdpf
2646.         // Instantiate canvas instance 
2647.         $canvas = $dompdf->getCanvas();
2648.             
2649.         // Get the number of pages in the PDF
2650.         $pageCount = $canvas->get_page_count();
2652.         // if($salesInvoice->getApproval() == 0)
2653.         // {
2654.         //   $callback = function ($pageNumber) use ($pageCount, $pdfOptions, $canvas) {
2655.         //     // Set text opacity 
2656.         //     $canvas->set_opacity(0.2, 'Multiply');   
2658.         //     // Instantiate font metrics class 
2659.         //     $fontMetrics = new FontMetrics($canvas, $pdfOptions);
2661.         //     // Get height and width of page 
2662.         //     $w = $canvas->get_width(); 
2663.         //     $h = $canvas->get_height(); 
2664.             
2665.         //     // Get font family file 
2666.         //     $font = $fontMetrics->getFont('times'); 
2667.             
2668.         //     // Specify watermark text 
2669.         //     $text = "DRAFT"; 
2670.             
2671.         //     // Get height and width of text 
2672.         //     $txtHeight = $fontMetrics->getFontHeight($font, 75); 
2673.         //     $textWidth = $fontMetrics->getTextWidth($text, $font, 75); 
2674.                         
2675.         //     // Specify horizontal and vertical position 
2676.         //     $x = (($w-$textWidth)/2); 
2677.         //     $y = (($h-$txtHeight)/2); 
2678.             
2679.         //     // Writes text at the specified x and y coordinates 
2680.         //     $canvas->text($x, $y, $text, $font, 75, array(0, 0, 0), 0, 'B');       
2681.         //     };
2683.         //     // Add the callback function to each page
2684.         //     for ($i = 0; $i < $pageCount; $i++) {        
2685.         //         $canvas->page_script($callback);        
2686.         //     }
2687.         // }
2688.         
2689.         // Page number and total page count Start
2691.         // Define the callback function to add the page number and total page count
2692.         $callback2 = function ($pageNumber) use ($pageCount, $canvas) {
2693.             // Set text opacity             
2694.             $canvas->set_opacity(0.9, 'Multiply');
2696.             // Set the text and position for page number and total page count
2697.             $text = 'Page ' . $pageNumber . ' of ' . $pageCount;
2698.             $x = 530; // X-coordinate position
2699.             $y = 813; // Y-coordinate position
2700.         
2701.             // Add the page number and total page count to the current page
2702.             $canvas->text($x, $y, $text, null, 10);
2703.         };
2704.        
2705.         // Add the callback function to each page
2706.         for ($i = 0; $i < $pageCount; $i++) {              
2707.             $canvas->page_script($callback2);        
2708.         }
2710.         // Output the generated PDF to Browser (force download)
2711.         $dompdf->stream("Invoice_".$salesInvoice->getInvoiceNo().".pdf", [
2712.             "Attachment" => false
2713.         ]);
2715.         exit(0);
2716.     
2717.     }
2719.     #[Route('/salesinvoice/{id}/master-invoice', name: 'app_sales_invoice_master_invoice')]  
2720.     #[IsGranted("ROLE_ACCOUNTS")]
2721.     public function masterInvoice(int $id, SalesInvoiceRepository $salesInvoiceRepository,  ReceiveVoucherRepository $receiveVoucherRepository)
2722.     {
2723.         $salesInvoice = $salesInvoiceRepository->findBySingleOrderObj($id);
2724.         
2725.         // Configure Dompdf according to your needs
2726.         $pdfOptions = new Options();
2727.         $pdfOptions->set('defaultFont', 'Arial');
2728.             
2729.         // Instantiate Dompdf with our options
2730.         $dompdf = new Dompdf($pdfOptions);
2731.        
2732.         $userObj = $this->getUser();
2733.         
2734.         if($salesInvoice->getCustomer()->getLastReceivedAmount() == 1)
2735.         {
2736.             $lastReceivedObj = $receiveVoucherRepository->findReceiveVoucherByCustomer($salesInvoice->getCustomer()->getId(), $this->getUser()->getUserCompany()->getId());
2737.         }
2738.         else
2739.         {
2740.             $lastReceivedObj = null;
2741.         }
2742.                    
2743.         // Retrieve the HTML generated in our twig file 
2744.         if($salesInvoice->getRateApplicable() <= 2)
2745.         {
2746.             $html = $this->renderView('sales_invoice/masterInvoice.html.twig', [
2747.                 'salesInvoice' => $salesInvoice, 
2748.                 'userObj' => $userObj,
2749.                 'lastReceivedObj' => $lastReceivedObj,
2750.                 'userCompanyLogo' => $this->imageToBase64($this->getParameter('kernel.project_dir') . '/public/uploads/usercompanylogo/'. $userObj->getUserCompany()->getLogoPath() ),         
2751.             ]);
2752.         }
2753.         else
2754.         {
2755.             $html = $this->renderView('sales_invoice/calculatedInvoice.html.twig', [
2756.                 'salesInvoice' => $salesInvoice, 
2757.                 'userObj' => $userObj,
2758.                 'lastReceivedObj' => $lastReceivedObj,
2759.                 'userCompanyLogo' => $this->imageToBase64($this->getParameter('kernel.project_dir') . '/public/uploads/usercompanylogo/'. $userObj->getUserCompany()->getLogoPath() ),         
2760.             ]);
2761.         }
2762.        
2763.          
2764.         // Load HTML to Dompdf
2765.         $dompdf->loadHtml($html);
2766.         
2767.         // (Optional) Setup the paper size and orientation 'portrait' or 'landscape'
2768.         $dompdf->setPaper('A4', 'portrait');
2770.         // Render the HTML as PDF
2771.         $dompdf->render();
2773.         //  Add Watermark in Domdpf
2775.         // Instantiate canvas instance 
2776.         $canvas = $dompdf->getCanvas();
2777.             
2778.         // Get the number of pages in the PDF
2779.         $pageCount = $canvas->get_page_count();
2781.         if($salesInvoice->getApproval() == 0)
2782.         {
2783.             $callback = function ($pageNumber) use ($pageCount, $pdfOptions, $canvas) {
2784.                 // Set text opacity 
2785.                 $canvas->set_opacity(0.2, 'Multiply');   
2787.                 // Instantiate font metrics class 
2788.                 $fontMetrics = new FontMetrics($canvas, $pdfOptions);
2790.                 // Get height and width of page 
2791.                 $w = $canvas->get_width(); 
2792.                 $h = $canvas->get_height(); 
2793.                 
2794.                 // Get font family file 
2795.                 $font = $fontMetrics->getFont('times'); 
2796.                 
2797.                 // Specify watermark text 
2798.                 $text = "DRAFT"; 
2799.                 
2800.                 // Get height and width of text 
2801.                 $txtHeight = $fontMetrics->getFontHeight($font, 75); 
2802.                 $textWidth = $fontMetrics->getTextWidth($text, $font, 75); 
2803.                             
2804.                 // Specify horizontal and vertical position 
2805.                 $x = (($w-$textWidth)/2); 
2806.                 $y = (($h-$txtHeight)/2); 
2807.                 
2808.                 // Writes text at the specified x and y coordinates 
2809.                 $canvas->text($x, $y, $text, $font, 75, array(0, 0, 0), 0, 'B');       
2810.             };
2812.             // Add the callback function to each page
2813.             for ($i = 0; $i < $pageCount; $i++) {        
2814.                 $canvas->page_script($callback);        
2815.             }
2816.         }
2817.         
2818.         // Page number and total page count Start
2820.         // Define the callback function to add the page number and total page count
2821.         $callback2 = function ($pageNumber) use ($pageCount, $canvas) {
2822.             // Set text opacity             
2823.             $canvas->set_opacity(0.9, 'Multiply');
2825.             // Set the text and position for page number and total page count
2826.             $text = 'Page ' . $pageNumber . ' of ' . $pageCount;
2827.             $x = 530; // X-coordinate position
2828.             $y = 820; // Y-coordinate position
2829.         
2830.             // Add the page number and total page count to the current page
2831.             $canvas->text($x, $y, $text, null, 10);
2832.         };
2833.        
2834.         // Add the callback function to each page
2835.         for ($i = 0; $i < $pageCount; $i++) {        
2836.             $canvas->page_script($callback2);        
2837.         }
2839.         // Output the generated PDF to Browser (force download)
2840.         $dompdf->stream("Invoice_".$salesInvoice->getInvoiceNo().".pdf", [
2841.             "Attachment" => false
2842.         ]);
2844.         exit(0);
2845.     
2846.     }
2847.     
2848.     #[Route('/salesinvoice/{id}/master-weight-sales-rate/{currencyType}', name: 'app_sales_invoice_masterWeightSalesRate')]  
2849.     #[IsGranted("ROLE_ACCOUNTS")]
2850.     public function masterWeightSalesRateinvoice(int $id, int $currencyType, ReceiveVoucherRepository $receiveVoucherRepository, ShipmentRepository $shipmentRepository, SalesInvoiceRepository $salesInvoiceRepository, SalesInvoiceDetailsRepository $salesInvoiceDetailsRepository)
2851.     {
2852.         $salesInvoice = $salesInvoiceRepository->findBySingleOrderObj($id);
2853.             
2854.         // Configure Dompdf according to your needs
2855.         $pdfOptions = new Options();
2856.         $pdfOptions->set('defaultFont', 'Arial');
2857.             
2858.         // Instantiate Dompdf with our options
2859.         $dompdf = new Dompdf($pdfOptions);
2860.        
2861.         $userObj = $this->getUser();
2862.         
2863.         if($salesInvoice->getCustomer()->getLastReceivedAmount() == 1)
2864.         {
2865.             $lastReceivedObj = $receiveVoucherRepository->findReceiveVoucherByCustomer($salesInvoice->getCustomer()->getId(), $this->getUser()->getUserCompany()->getId());
2866.         }
2867.         else
2868.         {
2869.             $lastReceivedObj = null;
2870.         }
2872.         if($salesInvoice->getCustomer()->getPreviousDuesAmount() == 1)
2873.         {
2874.             $duesAmount = $shipmentRepository->getCustomerWiseCreditLimitCalculation($salesInvoice->getCustomer()->getId());
2875.             $duesAmount = $duesAmount[0];
2876.         }
2877.         else
2878.         {
2879.             $duesAmount = 0;
2880.         }
2882.         $groupByCourier = $salesInvoiceDetailsRepository->findGroupByCourier($id);
2883.        
2884.         // Retrieve the HTML generated in our twig file 
2885.         if($salesInvoice->getRateApplicable() <= 3)
2886.         {
2887.             $html = $this->renderView('sales_invoice/masterWeightSalesRateinvoice.html.twig', [
2888.                 'salesInvoice' => $salesInvoice, 
2889.                 'userObj' => $userObj,
2890.                 'lastReceivedObj' => $lastReceivedObj,
2891.                 'duesAmount' => $duesAmount,
2892.                 'userCompanyLogo' => $this->imageToBase64($this->getParameter('kernel.project_dir') . '/public/uploads/usercompanylogo/'. $userObj->getUserCompany()->getLogoPath() ),         
2893.                 'currencyType' => $currencyType,
2894.                 'groupByCourier' => $groupByCourier,
2895.             ]);
2896.         }
2897.         else
2898.         {
2899.             $html = $this->renderView('sales_invoice/masterWeightSalesRateinvoice.html.twig', [
2900.                 'salesInvoice' => $salesInvoice, 
2901.                 'userObj' => $userObj,
2902.                 'lastReceivedObj' => $lastReceivedObj,
2903.                 'duesAmount' => $duesAmount,
2904.                 'userCompanyLogo' => $this->imageToBase64($this->getParameter('kernel.project_dir') . '/public/uploads/usercompanylogo/'. $userObj->getUserCompany()->getLogoPath() ),         
2905.             ]);
2906.         }
2907.        
2908.          
2909.         // Load HTML to Dompdf
2910.         $dompdf->loadHtml($html);
2911.         
2912.         // (Optional) Setup the paper size and orientation 'portrait' or 'landscape'
2913.         $dompdf->setPaper('A4', 'portrait');
2915.         // Render the HTML as PDF
2916.         $dompdf->render();
2918.         //  Add Watermark in Domdpf
2920.         // Instantiate canvas instance 
2921.         $canvas = $dompdf->getCanvas();
2922.             
2923.         // Get the number of pages in the PDF
2924.         $pageCount = $canvas->get_page_count();
2926.         // if($salesInvoice->getApproval() == 0)
2927.         // {
2928.         //     $callback = function ($pageNumber) use ($pageCount, $pdfOptions, $canvas) {
2929.         //         // Set text opacity 
2930.         //         $canvas->set_opacity(0.2, 'Multiply');   
2932.         //         // Instantiate font metrics class 
2933.         //         $fontMetrics = new FontMetrics($canvas, $pdfOptions);
2935.         //         // Get height and width of page 
2936.         //         $w = $canvas->get_width(); 
2937.         //         $h = $canvas->get_height(); 
2938.                 
2939.         //         // Get font family file 
2940.         //         $font = $fontMetrics->getFont('times'); 
2941.                 
2942.         //         // Specify watermark text 
2943.         //         $text = "DRAFT"; 
2944.                 
2945.         //         // Get height and width of text 
2946.         //         $txtHeight = $fontMetrics->getFontHeight($font, 75); 
2947.         //         $textWidth = $fontMetrics->getTextWidth($text, $font, 75); 
2948.                             
2949.         //         // Specify horizontal and vertical position 
2950.         //         $x = (($w-$textWidth)/2); 
2951.         //         $y = (($h-$txtHeight)/2); 
2952.                 
2953.         //         // Writes text at the specified x and y coordinates 
2954.         //         $canvas->text($x, $y, $text, $font, 75, array(0, 0, 0), 0, 'B');       
2955.         //     };
2957.         //     // Add the callback function to each page
2958.         //     for ($i = 0; $i < $pageCount; $i++) {        
2959.         //         $canvas->page_script($callback);        
2960.         //     }
2961.         // }
2962.         
2963.         // Page number and total page count Start
2965.         // Define the callback function to add the page number and total page count
2966.         $callback2 = function ($pageNumber) use ($pageCount, $canvas) {
2967.             // Set text opacity             
2968.             $canvas->set_opacity(0.9, 'Multiply');
2970.             // Set the text and position for page number and total page count
2971.             $text = 'Page ' . $pageNumber . ' of ' . $pageCount;
2972.             $x = 530; // X-coordinate position
2973.             $y = 813; // Y-coordinate position
2974.         
2975.             // Add the page number and total page count to the current page
2976.             $canvas->text($x, $y, $text, null, 10);
2977.         };
2978.        
2979.         // Add the callback function to each page
2980.         for ($i = 0; $i < $pageCount; $i++) {              
2981.             $canvas->page_script($callback2);        
2982.         }
2984.         // Output the generated PDF to Browser (force download)
2985.         $dompdf->stream("Invoice_".$salesInvoice->getInvoiceNo().".pdf", [
2986.             "Attachment" => false
2987.         ]);
2989.         exit(0);
2990.     
2991.     }
2994.     #[Route('/salesinvoice/datewiseinvoice', name: 'app_sales_invoice_datewiseinvoice', methods: ['GET', 'POST'])]
2995.     public function datewiseinvoice(Request $request, EntityManagerInterface $entityManager): Response
2996.     {      
2997.         $invoiceId = $request->request->get('modal-salesinvocie-id');
2998.         $fromDate = $request->request->get('modal-from-date');
2999.         $toDate = $request->request->get('modal-to-date');
3000.         
3001.         $salesInvoice = $entityManager->find(SalesInvoice::class, $invoiceId);
3002.         $salesInvoice->getSalesInvoiceDetails()->clear();
3004.         $salesInvoiceDetailsList = $entityManager->getRepository(SalesInvoiceDetails::class)->salesInvDetailsListDateWise($invoiceId, $fromDate, $toDate);
3005.         
3006.         foreach($salesInvoiceDetailsList as $salesInvoiceDetails)
3007.         {
3008.             $salesInvoice->addSalesInvoiceDetail($salesInvoiceDetails);
3009.         }
3011.         // Configure Dompdf according to your needs
3012.         $pdfOptions = new Options();
3013.         $pdfOptions->set('defaultFont', 'Arial');
3014.             
3015.         // Instantiate Dompdf with our options
3016.         $dompdf = new Dompdf($pdfOptions);
3018.         $userObj = $this->getUser();
3019.         
3020.         // Retrieve the HTML generated in our twig file 
3021.         if($salesInvoice->getRateApplicable() <= 2)
3022.         {
3023.             $html = $this->renderView('sales_invoice/invoice.html.twig', [
3024.                 'salesInvoice' => $salesInvoice, 
3025.                 'userObj' => $userObj,
3026.                 'userCompanyLogo' => $this->imageToBase64($this->getParameter('kernel.project_dir') . '/public/uploads/usercompanylogo/'. $userObj->getUserCompany()->getLogoPath() ),         
3027.             ]);
3028.         }
3029.         else
3030.         {
3031.             $html = $this->renderView('sales_invoice/calculatedInvoice.html.twig', [
3032.                 'salesInvoice' => $salesInvoice, 
3033.                 'userObj' => $userObj,
3034.                 'userCompanyLogo' => $this->imageToBase64($this->getParameter('kernel.project_dir') . '/public/uploads/usercompanylogo/'. $userObj->getUserCompany()->getLogoPath() ),         
3035.             ]);
3036.         }
3037.     
3038.         
3039.         // Load HTML to Dompdf
3040.         $dompdf->loadHtml($html);
3041.         
3042.         // (Optional) Setup the paper size and orientation 'portrait' or 'landscape'
3043.         $dompdf->setPaper('A4', 'portrait');
3045.         // Render the HTML as PDF
3046.         $dompdf->render();
3047.         
3048.         // Output the generated PDF to Browser (force download)
3049.         $dompdf->stream("Invoice.pdf", [
3050.             "Attachment" => false,
3051.         ]);
3052.              
3053.     }
3055.     #[Route('/salesinvoice/datewisedataupdate', name: 'app_sales_invoice_datewisedataupdate', methods: ['GET', 'POST'])]
3056.     public function datewisedataupdate(Request $request, EntityManagerInterface $entityManager): Response
3057.     {      
3058.         $invoiceId = $request->request->get('modal-salesinvocie-id');
3059.         $fromDate = $request->request->get('modal-from-date');
3060.         $toDate = $request->request->get('modal-to-date');
3061.         $courier = $request->request->get('modal-courier');
3062.         $fsc = $request->request->get('modal-fsc');
3063.         $currency = $request->request->get('modal-currency');
3064.         $applicable = $request->request->get('modal-applicable');
3065.        
3066.         $salesInvoiceDetailsList = $entityManager->getRepository(SalesInvoiceDetails::class)
3067.                                     ->salesInvDetailsListCourierAndDateWise($invoiceId, $fromDate, $toDate, $courier);
3068.         
3069.         foreach($salesInvoiceDetailsList as $salesInvoiceDetails)
3070.         {
3071.             if($applicable == 1)
3072.             {
3073.                 $salesInvoiceDetails->setFsc($fsc);
3074.                 $salesInvoiceDetails->setCurrency($currency);
3075.             }
3076.             else if($applicable == 2)
3077.             {
3078.                 $salesInvoiceDetails->setVendorFsc($fsc);
3079.                 $salesInvoiceDetails->setVendorCurrency($currency);
3080.             }
3081.             else
3082.             {
3083.                 $salesInvoiceDetails->setFsc($fsc);
3084.                 $salesInvoiceDetails->setCurrency($currency);
3086.                 $salesInvoiceDetails->setVendorFsc($fsc);
3087.                 $salesInvoiceDetails->setVendorCurrency($currency);
3088.             }
3090.             $entityManager->persist($salesInvoiceDetails);
3091.             $entityManager->flush($salesInvoiceDetails); 
3092.             
3093.         }
3095.         return $this->redirectToRoute('app_sales_invoice_show', ['id' => $invoiceId]);              
3096.     }
3098.     #[Route('/salesinvoice/principle-invoice-checking', name: 'app_sales_invoice_principle_invocie_checking', methods: ['GET', 'POST'])]
3099.     #[IsGranted("ROLE_ACCOUNTS")]
3100.     public function principleInvoiceChecking(Request $request, SluggerInterface $slugger, SalesInvoiceDetailsRepository $salesInvoiceDetailsRepository): Response
3101.     {
3102.         $form = $this->createFormBuilder(null)
3103.             ->add('file', FileType::class, [
3104.             'label' => 'Upload Principle Invoice Excel File ',
3106.             // unmapped means that this field is not associated to any entity property
3107.             'mapped' => false,
3108.             'attr' => [
3109.                 'class' => 'form-control select-tags',
3110.                 ],
3111.             // make it optional so you don't have to re-upload the PDF file
3112.             // every time you edit the Product details
3113.             //'required' => false,
3115.             // unmapped fields can't define their validation using annotations
3116.             // in the associated entity, so you can use the PHP constraint classes
3118.             'constraints' => [
3119.                 new File([
3120.                     'maxSize' => '1024k',
3121.                     'mimeTypes' => [         
3122.                         'application/vnd.ms-excel',              
3123.                         'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',                                              
3124.                     ],
3125.                     'mimeTypesMessage' => 'Please upload a valid Excel (.xlsx / .xls) file',
3126.                 ])
3127.             ],
3129.         ])
3130.         ->add('courier', EntityType::class, [
3131.             // looks for choices from this entity
3132.             'class' => Courier::class,
3133.             'query_builder' => function (CourierRepository $er) {
3134.                 return $er->createQueryBuilder('v')                       
3135.                     ->orderBy('v.name', 'ASC');
3136.             },                
3137.             // uses the User.username property as the visible option string
3138.             'choice_label' => 'name',
3139.             'placeholder' => 'Select a Courier...',
3140.             'attr' => [
3141.                 'class' => 'form-control select-tags',
3142.                 'style' => 'width:100%;',
3143.                 ],
3144.             'label' => 'Courier',
3145.             // used to render a select box, check boxes or radios
3146.             // 'multiple' => true,
3147.             // 'expanded' => true,
3148.             ])
3149.         ->add('fromDate', DateType::class, [
3150.             'attr' => ['class' => 'form-control'],
3151.             'widget' => 'single_text',
3152.             'empty_data' => null,                         
3153.             ])
3154.         ->add('toDate', DateType::class, [
3155.             'attr' => ['class' => 'form-control'],
3156.             'widget' => 'single_text',
3157.             'empty_data' => null,                            
3158.             ]) 
3159.               
3160.         ->getForm();
3162.        $form->handleRequest($request);
3164.         if ($form->isSubmitted() && $form->isValid()) {
3166.             $data = $form->getData();                     
3167.             $formDate =  $form->get('fromDate')->getData()->format('Y-m-d'); 
3168.             $toDate =  $form->get('toDate')->getData()->format('Y-m-d');    
3169.             $courier = $form->get('courier')->getData();      
3171.             
3172.             /* @var UploadedFile document start */
3173.             $docFile = $form->get('file')->getData();
3175.             // this condition is needed because the 'brochure' field is not required
3176.             // so the PDF file must be processed only when a file is uploaded
3177.             if ($docFile) {
3178.                 $originalFilename = pathinfo($docFile->getClientOriginalName(), PATHINFO_FILENAME);
3179.                 // this is needed to safely include the file name as part of the URL
3180.                 $safeFilename = $slugger->slug($originalFilename);
3181.                 $newFilename = $safeFilename.'-'.uniqid().'.'.$docFile->guessExtension();
3183.                 // Move the file to the directory where brochures are stored
3184.                 try {
3185.                     $docFile->move(
3186.                         $this->getParameter('filedocument_directory'),
3187.                         $newFilename
3188.                     );
3189.                 } catch (FileException $e) {
3190.                     // ... handle exception if something happens during file upload
3191.                 }
3193.                 // updates the 'brochureFilename' property to store the PDF file name
3194.                 // instead of its contents
3195.                 //$assetregister->setDocpath($newFilename);
3196.             }
3197.             /* @var UploadedFile document end */
3198.            
3199.             /* Excel file read from upload directory Start */
3201.             // Here we are able to read from the excel file 
3202.             $spreadsheet = IOFactory::load($this->getParameter('filedocument_directory').'/'.$newFilename);
3203.    
3204.             // I added this to be able to remove the first file line 
3205.             $row = $spreadsheet->getActiveSheet()->removeRow(1); 
3207.             $maxCell = $spreadsheet->getActiveSheet()->getHighestRowAndColumn();
3208.            // dd($maxCell);
3209.            // dd('A1:' . $maxCell['column'] . $maxCell['row']);
3210.            // here, the read data is turned into an array
3211.             $sheetData = $spreadsheet->getActiveSheet()->rangeToArray('A1:A' . $maxCell['row']);
3212.            // dump($sheetData);
3213.           
3214.             $salesInvoiceDetails = $salesInvoiceDetailsRepository->principleInvoiceChecking($formDate, $toDate, $courier->getId(), $this->getUser()->getUserCompany()->getId()); 
3215.             //dd($salesInvoiceDetails);
3216.              
3217.         //     $salesInvoiceDetailsforFalse = array_filter($salesInvoiceDetails, function($item) {
3218.         //         return $item['principalBill'] === false;
3219.         //     }); 
3220.             
3221.         //   // dd($salesInvoiceDetailsforFalse);
3222.             
3223.         //     $salesInvoiceDetailsforTrue = array_filter($salesInvoiceDetails, function($item) {
3224.         //         return $item['principalBill'] === true;
3225.         //     }); 
3226.             
3227.         //     dd($salesInvoiceDetailsforTrue);
3229.             // Flatten the first array
3230.             $flattenedSheetData = array_map(function($item) {
3231.                 return str_replace(' ', '', $item[0]);
3232.             }, $sheetData);
3233.  
3234.             // Flatten the second array
3235.             $flattenedSalesInvoiceDetails = array_map(function($item) {
3236.                 return str_replace(' ', '', $item["hawbNo"]);
3237.             }, $salesInvoiceDetails);
3239.             // Elements in $flattenedSheetData but not in $flattenedSalesInvoiceDetails
3240.             $missingBillCustomer = array_diff($flattenedSheetData, $flattenedSalesInvoiceDetails);
3242.             $extraBillCustomer = array_diff($flattenedSalesInvoiceDetails, $flattenedSheetData);
3244.             // dump($flattenedSheetData);
3245.             // dump($flattenedSalesInvoiceDetails);
3246.             // dump($missingBillCustomer);
3247.             // dd($extraBillCustomer);
3248.           
3249.            // $this->addFlash('notice', 'Country Created successfully!');
3251.             return $this->render('sales_invoice/principleInvoiceCheckingResult.html.twig', [
3252.                 'missing_bill_customer' => $missingBillCustomer,
3253.                 'sheet_data_count' => count($flattenedSheetData),
3255.                 'extra_bill_customer' => $extraBillCustomer,        
3256.                 'sales_invoice_count' =>  count($flattenedSalesInvoiceDetails),    
3257.                 'courier' => $courier, 
3258.             ]);
3259.             
3260.         }
3262.         return $this->renderForm('sales_invoice/principleInvoiceChecking.html.twig', [        
3263.             'form' => $form,
3264.         ]);
3265.     }
3267.     #[Route('/salesinvoice/shipmenttoinvoice', name: 'app_sales_invoice_shipmentto_invoice', methods: ['GET', 'POST'])]
3268.     #[IsGranted("ROLE_ACCOUNTS")]
3269.     public function shipmenttoinvoice(Request $request, ShipmentRepository $shipmentRepository, CourierRepository $courierRepository, CountryRepository $countryRepository, CustomerRepository $customerRepository, ProductTypeRepository $productTypeRepository)
3270.     {
3271.         $form = $this->createFormBuilder(null)           
3272.             ->add('fromDate', DateType::class, [
3273.                 'attr' => ['class' => 'form-control'],
3274.                 'widget' => 'single_text',
3275.                 'empty_data' => null,
3276.                 'label' => 'From Shipment Date',            
3277.                 ])      
3278.             ->add('toDate', DateType::class, [
3279.                 'attr' => ['class' => 'form-control'],
3280.                 'widget' => 'single_text',
3281.                 'empty_data' => null,
3282.                 'label' => 'To Shipment Date',                
3283.                 ])
3284.             ->add('customer',TextType::class, [       
3285.                 'attr' => ['class' => 'form-control'],
3286.                 'label' => 'Customer',
3287.                 'required' => false,
3288.             ])
3289.             ->add('hawbno',TextType::class, [       
3290.                 'attr' => ['class' => 'form-control'],
3291.                 'label' => 'Hawb No',
3292.                 'required' => false,
3293.             ])
3294.         ->getForm();
3295.  
3296.         $form->handleRequest($request); 
3297.                     
3298.         if ($form->isSubmitted() && $form->isValid()) {
3299.             $data = $form->getData();                     
3300.             $formDate =  $form->get('fromDate')->getData()->format('Y-m-d'); 
3301.             $toDate =  $form->get('toDate')->getData()->format('Y-m-d');    
3302.             $customer = $form->get('customer')->getData();      
3303.             $hawbNO = $form->get('hawbno')->getData();
3305.             $viewTag = 0;
3306.            
3307.             $shipmentList = $shipmentRepository->findShipmentByDateforInvoice($formDate, $toDate, $customer, $hawbNO, $this->getUser()->getUserCompany()->getId());
3308.            
3309.             foreach($shipmentList as $row)
3310.             {
3311.                 if($row->getCustomer()->getRateType() > 2 || $row->isExpedite() || $row->getPaymentOptions()->getId() == 2)
3312.                 {
3313.                     $viewTag = 1;
3314.                     break;
3315.                 }
3316.                 
3317.             }
3319.             $courierList = $courierRepository->findBy(['userCompany' => $this->getUser()->getUserCompany()->getId() ]);
3320.             $countryList = $countryRepository->findAll();
3321.             $customerList = $customerRepository->findBy(['userCompany' => $this->getUser()->getUserCompany()->getId() ]);
3322.             $productTypeList = $productTypeRepository->findBy(['type' => 2]);
3323.             
3324.             return $this->render('sales_invoice/shipmenttoinvoice.html.twig', [
3325.                 'form' => $form->createView(),
3326.                 'bookingList' => $shipmentList,    
3327.                 'courierList' => $courierList,
3328.                 'countryList' => $countryList,
3329.                 'customerList' => $customerList,
3330.                 'productTypeList' => $productTypeList,         
3331.                 'track' => 1,
3332.                 'viewTag' => $viewTag,
3333.             ]);
3334.         }
3336.         $bookingObj = new SalesInvoiceDetails();
3337.         
3338.         return $this->render('sales_invoice/shipmenttoinvoice.html.twig', [
3339.             'form' => $form->createView(),
3340.             'bookingList' => $bookingObj,            
3341.             'track' => 0,
3342.         ]);
3343.     }
3344.  
3345.     #[Route('/salesinvoice/shipmenttoinvoicepost', name: 'app_sales_invoice_shipmentto_invoice_post', methods: ['GET', 'POST'])]
3346.     #[IsGranted("ROLE_ACCOUNTS")]
3347.     public function shipmenttoinvoicepost(Request $request, EntityManagerInterface $entityManager, UtilsService $utilsService, ShipmentRepository $shipmentRepository, CourierRepository $courierRepository, CountryRepository $countryRepository, CustomerRepository $customerRepository, ProductTypeRepository $productTypeRepository, SettingsInfoRepository $settingsInfoRepository, SalesInvoiceRepository $salesInvoiceRepository)
3348.     {
3349.         if ($request->isXMLHttpRequest()) 
3350.         {
3351.             $hawbNo = $request->request->get('hawbNo');            
3352.             if (!empty($hawbNo)) 
3353.             {
3354.                 $hawbNo_array = json_decode($hawbNo, true);
3355.                // return new JsonResponse(array('success' => false, 'responseText' =>  $hawbNo_array ));
3356.                 $hawbNo_array = json_decode($request->request->get('hawbNo')); 
3357.                 $shipmentDate_array = json_decode($request->request->get('shipmentDate'));
3358.                 $reference_array = json_decode($request->request->get('reference'));
3359.                 $country_array = json_decode($request->request->get('country'));
3360.                 $customer_array = json_decode($request->request->get('customer'));
3361.                 $courier_array = json_decode($request->request->get('courier'));
3362.                 $productType_array = json_decode($request->request->get('productType'));
3363.                 $weight_array = json_decode($request->request->get('weight'));
3364.                 $bookingWeight_array = json_decode($request->request->get('bookingWeight'));
3365.                 $shipmentId_array = json_decode($request->request->get('shipmentId'));
3366.                 $vatApplicable_array = json_decode($request->request->get('vatApplicable'));
3367.                 $salesRate_array = json_decode($request->request->get('billingWeight'));
3369.                 $salesInvoiceDetailsList = new ArrayCollection();
3370.                 
3371.                 $index = 0;               
3372.                 foreach($hawbNo_array as $key=>$Row) 
3373.                 {
3374.                     $keyValue = $key;
3375.                     $keyValue = $keyValue + 1;
3376.                     
3377.                     $salesInvoiceDetailsObj = new SalesInvoiceDetails();
3378.                     
3379.                     $salesInvoiceDetObj = $entityManager->getRepository(SalesInvoiceDetails::class)
3380.                                                         ->findOneBy(['hawbNo' => $hawbNo_array[$index]]);                              
3381.                     if($salesInvoiceDetObj !== null)
3382.                     {
3383.                         return new JsonResponse(array('success' => false, 'responseText' => 'Duplicate HAWB Number : '. $hawbNo_array[$index].' in Row Number '.$keyValue.'.'));
3384.                     }
3385.                     
3386.                     $salesInvoiceDetailsObj->setShipmentDate(new \DateTime($shipmentDate_array[$index]));
3387.                     $salesInvoiceDetailsObj->setHawbNo($hawbNo_array[$index]);
3388.                     $salesInvoiceDetailsObj->setReference($reference_array[$index]);
3390.                     $countryObj = $entityManager->find(Country::class, $country_array[$index]);                  
3391.                     $salesInvoiceDetailsObj->setCountry($countryObj);
3393.                     $courierObj = $entityManager->find(Courier::class, $courier_array[$index]);                
3394.                     $salesInvoiceDetailsObj->setCourier($courierObj);
3395.                     
3396.                     // Rate Type get Start Here getRateType()
3397.                     if($courierObj->getZoneRateType() !== null)
3398.                         $zoneWiseMasterRateTypeObj = $entityManager->find(ZoneWiseMasterRate::class, $courierObj->getZoneRateType());
3399.                     else 
3400.                         $zoneWiseMasterRateTypeObj = new ZoneWiseMasterRate();
3401.                     // Rate Type get End Here
3402.                     
3403.                     $productTypeObj = $entityManager->find(ProductType::class, $productType_array[$index]);                 
3404.                     $salesInvoiceDetailsObj->setProductType($productTypeObj);
3406.                     $customerObj = $entityManager->find(Customer::class, $customer_array[$index]);                 
3407.                     $salesInvoiceDetailsObj->setCustomer($customerObj);
3409.                     $salesInvoiceDetailsObj->setWeight($weight_array[$index]);
3410.                     $salesInvoiceDetailsObj->setBookingWeight($bookingWeight_array[$index]);
3411.                        
3412.                     $shipmentObj = $entityManager->find(Shipment::class, $shipmentId_array[$index]);    
3413.                     $salesInvoiceDetailsObj->setShipment($shipmentObj);
3415.                     $salesInvoiceDetailsObj->setVatApplicable($vatApplicable_array[$index]);
3416.                     $salesInvoiceDetailsObj->setVendorVatApplicable($vatApplicable_array[$index]);
3418.                     if($salesInvoiceDetailsObj->getShipment()->isExpedite())
3419.                     {
3420.                         $rateApplicableId = 5;  // Expedite Rate Type 5 
3421.                     }
3422.                     else if ($shipmentObj->getPaymentOptions()->getId() == 2 )
3423.                     {
3424.                         $rateApplicableId = 3; // Manually Tariff Rate($) 3
3425.                     }
3426.                     else
3427.                     {
3428.                         $rateApplicableId = $customerObj->getRateType();  
3429.                     }
3431.                     $salesInvoiceDetailsObj->setRateApplicable($rateApplicableId);    
3433.                     // return new JsonResponse(array('success' => false, 'responseText' => $salesInvoiceObj_array['InvoiceApplicable']  ));
3434.                     // $salesInvoiceDetailsObj->setInvoiceStatus($salesInvoiceObj_array['InvoiceApplicable']);
3435.                                     
3436.                     //Zone Assign Start  $shipmentId_array
3437.                     //    if($courier_array[$index] < 0)
3438.                         //    {
3439.                             $courierWiseZoneObj = $entityManager->getRepository(CourierWiseZone::class)
3440.                                                                 ->findOneBy(['courier' => $courier_array[$index], 'country' => $country_array[$index] ]);                       
3441.                             if($courierWiseZoneObj === null )
3442.                             {
3443.                                     return new JsonResponse(array('success' => false, 'responseText' => 'Courier Wise Zone is not set for Courier : '. $courierObj->getName().', and Country : '.$countryObj->getName().' in Row Number '.$keyValue.'.'));
3444.                             }
3445.                             $salesInvoiceDetailsObj->setZone($courierWiseZoneObj->getZone());
3446.                             //return new JsonResponse(array('success' => false, 'responseText' => $courierWiseZoneObj->getZone() ));
3447.                     //    }
3448.                     //    else
3449.                     //    {
3450.                     //     $courierWiseZoneObj = $this->getDoctrine()
3451.                     //             ->getRepository(CourierWiseZone::class)
3452.                     //             ->find(1);
3453.                     //    }
3454.                     //Zone Assign End
3456.                     //Customer Weight Calculation Start 
3457.                     // Half and Per KG
3458.                     $weight = trim($weight_array[$index]);
3459.                     $pointInputWeight = $weight - floor($weight);
3460.                     $intInputWeight = floor($weight);
3461.                     $finalWeight = 0;
3462.                     $rateWeight = 0;
3463.                     if($weight <  $courierObj->getWeightPerkg())
3464.                     {
3465.                         if($pointInputWeight > 0 && $pointInputWeight <= 0.5)
3466.                         {
3467.                             $finalWeight = (float)0.5;
3468.                         }
3469.                         elseif($pointInputWeight > 0.5 && $pointInputWeight <=1)
3470.                         {
3471.                             $finalWeight = (float)1;
3472.                         }
3473.                     }
3474.                     else
3475.                     {
3476.                         if($pointInputWeight > 0 && $pointInputWeight <=1)
3477.                         {
3478.                             $finalWeight = (float)1;
3479.                         }
3480.                     }
3481.                     $rateWeight = $intInputWeight + $finalWeight;
3483.                     //Only Per KG
3484.                     $pointInputPerKgWeight = $weight - floor($weight);
3485.                     $intInputPerKgWeight = floor($weight);
3486.                     $finalPerKgWeight = 0;
3487.                     $ratePerKgWeight = 0;
3488.                     if($pointInputPerKgWeight > 0 && $pointInputPerKgWeight <=1)
3489.                     {
3490.                         $finalPerKgWeight = (float)1;
3491.                     }
3492.                     $ratePerKgWeight = $intInputPerKgWeight + $finalPerKgWeight;
3493.                     //Customer Weight Calculation End
3495.                     //Vendor/Booking weight Calculation Start 
3496.                     // Half and Per KG
3497.                     $bookingWeight = trim($bookingWeight_array[$index]);
3498.                     $pointInputBookingWeight = $bookingWeight - floor($bookingWeight);
3499.                     $intInputBookingWeight = floor($bookingWeight);
3500.                     $finalBookingWeight = 0;
3501.                     $rateBookingWeight = 0;
3502.                     if($bookingWeight <  $courierObj->getWeightPerkg())
3503.                     {
3504.                         if($pointInputBookingWeight > 0 && $pointInputBookingWeight <= 0.5)
3505.                         {
3506.                             $finalBookingWeight = (float)0.5;
3507.                         }
3508.                         elseif($pointInputBookingWeight > 0.5 && $pointInputBookingWeight <=1)
3509.                         {
3510.                             $finalBookingWeight = (float)1;
3511.                         }
3512.                     }
3513.                     else
3514.                     {
3515.                         if($pointInputBookingWeight > 0 && $pointInputBookingWeight <=1)
3516.                         {
3517.                             $finalBookingWeight = (float)1;
3518.                         }
3519.                     }
3520.                     $rateBookingWeight = $intInputBookingWeight + $finalBookingWeight;
3522.                     //Only Per KG
3523.                     $pointInputPerKgBookingWeight = $bookingWeight - floor($bookingWeight);
3524.                     $intInputPerKgBookingWeight = floor($bookingWeight);
3525.                     $finalPerKgBookingWeight = 0;
3526.                     $ratePerKgBookingWeight = 0;
3527.                     if($pointInputPerKgBookingWeight > 0 && $pointInputPerKgBookingWeight <=1)
3528.                     {
3529.                         $finalPerKgBookingWeight = (float)1;
3530.                     }
3531.                     $ratePerKgBookingWeight = $intInputPerKgBookingWeight + $finalPerKgBookingWeight;
3532.                     //Weight Calculation End
3533.                     
3534.                     // Get Settings Currency Start
3535.                     $settingsObj = $settingsInfoRepository->findByDateCurrency(1, $salesInvoiceDetailsObj->getShipmentDate()->format('Y-m-d')); 
3537.                     if($settingsObj === null)
3538.                     {                                
3539.                         return new JsonResponse(array('success' => false, 'responseText' => 'Currency is not set in Settings for Month : '.$salesInvoiceDetailsObj->getShipmentDate()->format('F').'-'.$salesInvoiceDetailsObj->getShipmentDate()->format('Y').' in Row Number '.$keyValue.'.'));
3540.                     }                       
3541.                     // Get Settings Currency End
3543.                     //Master Rate Assign Start  
3544.                     if(!$salesInvoiceDetailsObj->getShipment()->isExpedite())
3545.                     {   
3546.                         $perKgRateWeight = $courierObj->getWeightPerkgRate();
3547.                         if($courierObj->getId() != 3)
3548.                         {
3549.                             $finalMasterRateCal = 0;                 
3550.                             
3551.     
3552.                             if($rateBookingWeight < $perKgRateWeight )
3553.                             { 
3554.                                 $countryWiseMasterRate = $entityManager->getRepository(CountryWiseMasterRate::class) 
3555.                                                             ->findOneBy(['type' => $shipmentObj->getShipmentType(), 'courier' => $courierObj->getId(), 'country' => $countryObj->getId(), 'productType' => $productTypeObj->getRateid(), 'weight' => $rateBookingWeight ]);                                          
3556.     
3557.                                 if($countryWiseMasterRate !== null) 
3558.                                 { 
3559.                                     $finalMasterRateCal =  $countryWiseMasterRate->getRate();
3560.                                 }                           
3561.                             }
3562.                             else
3563.                             {
3564.                                 $countryWiseMasterRate = $entityManager->getRepository(CountryWiseMasterRate::class)
3565.                                                             ->findOneBy(['type' => $shipmentObj->getShipmentType(), 'courier' => $courierObj->getId(), 'country' => $countryObj->getId(), 'productType' => $productTypeObj->getRateid(), 'weight' => $perKgRateWeight ]);                           
3566.                                 if($countryWiseMasterRate !== null) 
3567.                                 { 
3568.                                     $finalMasterRateCal = $countryWiseMasterRate->getRate() * $rateBookingWeight;                                    
3569.                                 }
3570.                             }
3571.     
3572.                             if($countryWiseMasterRate === null)  
3573.                             {
3574.                                 if($rateBookingWeight < $perKgRateWeight )
3575.                                 { 
3576.                                     $zoneWiseMasterRate = $entityManager->getRepository(ZoneWiseMasterRate::class)
3577.                                                             ->findBookingRatebyCourierAndWeight($shipmentObj->getShipmentType(), $zoneWiseMasterRateTypeObj->getRateType(), $courierObj->getId(), $courierWiseZoneObj->getZone()->getId(), $productTypeObj->getRateid(), $rateBookingWeight);                       
3578.                                     
3579.                                     if($zoneWiseMasterRate !== null)      
3580.                                     { 
3581.                                         $finalMasterRateCal = $zoneWiseMasterRate->getRate();
3582.                                     }
3583.                                 }
3584.                                 else
3585.                                 {
3586.                                    
3587.                                     $zoneWiseMasterRate = $entityManager->getRepository(ZoneWiseMasterRate::class)
3588.                                                             ->findBookingRatebyCourierAndWeight($shipmentObj->getShipmentType(), $zoneWiseMasterRateTypeObj->getRateType(), $courierObj->getId(), $courierWiseZoneObj->getZone()->getId(), $productTypeObj->getRateid(), $courierObj->getId() == 3 ?  $perKgRateWeight : $rateBookingWeight );                     
3589.                                     if($zoneWiseMasterRate !== null)      
3590.                                     { 
3591.                                         $finalMasterRateCal = $zoneWiseMasterRate->getRate() * $rateBookingWeight;                                
3592.                                     }
3593.                                 }
3594.                             }        
3595.     
3596.                             if($countryWiseMasterRate !== null)
3597.                             {
3598.                                 $salesInvoiceDetailsObj->setBookingRate($finalMasterRateCal);                            
3599.                             }
3600.                             else if($zoneWiseMasterRate !== null)
3601.                             {
3602.                                 $salesInvoiceDetailsObj->setBookingRate($finalMasterRateCal);                            
3603.                             }
3604.                             else
3605.                             {                                   
3606.                                 return new JsonResponse(array('success' => false, 'responseText' => 'Master Rate is not set for Courier : '.$courierObj->getName().', Country : '.$countryObj->getName().', Product Type : '.$productTypeObj->getName().', Weight : '.$rateWeight.' in Row Number '.$keyValue.'.'));
3607.                             }
3608.                         }
3609.                         else
3610.                         {
3611.                             if($rateBookingWeight <= 30) 
3612.                             {
3613.                                 $zoneWiseMasterRate = $entityManager->getRepository(ZoneWiseMasterRate::class)
3614.                                     ->findBookingRatebyCourierAndWeight(
3615.                                         $shipmentObj->getShipmentType(), 
3616.                                         $zoneWiseMasterRateTypeObj->getRateType(), 
3617.                                         $courierObj->getId(), 
3618.                                         $courierWiseZoneObj->getZone()->getId(), 
3619.                                         $productTypeObj->getRateid(), 
3620.                                         $rateBookingWeight
3621.                                 );   
3622.                                 
3623.                                 $finalRate = $zoneWiseMasterRate->getRate();
3624.                             }
3625.                             else if($rateBookingWeight > 30 && $rateBookingWeight <= 70)
3626.                             {
3627.                                 $zoneWiseMasterRateFs = $entityManager->getRepository(ZoneWiseMasterRate::class)
3628.                                     ->findBookingRatebyCourierAndWeight(
3629.                                         $shipmentObj->getShipmentType(), 
3630.                                         $zoneWiseMasterRateTypeObj->getRateType(), 
3631.                                         $courierObj->getId(), 
3632.                                         $courierWiseZoneObj->getZone()->getId(), 
3633.                                         $productTypeObj->getRateid(), 
3634.                                         30
3635.                                 );   
3637.                                 $zoneWiseMasterRateSs = $entityManager->getRepository(ZoneWiseMasterRate::class)
3638.                                     ->findBookingRatebyCourierAndWeight(
3639.                                         $shipmentObj->getShipmentType(), 
3640.                                         $zoneWiseMasterRateTypeObj->getRateType(), 
3641.                                         $courierObj->getId(), 
3642.                                         $courierWiseZoneObj->getZone()->getId(), 
3643.                                         $productTypeObj->getRateid(), 
3644.                                         31
3645.                                 ); 
3646.                                 
3647.                                 $finalRate = $zoneWiseMasterRateFs->getRate() + (($rateBookingWeight - 30) * $zoneWiseMasterRateSs->getRate());
3648.                             }
3649.                             else if($rateBookingWeight > 70)
3650.                             {
3651.                                 $zoneWiseMasterRateFs = $entityManager->getRepository(ZoneWiseMasterRate::class)
3652.                                     ->findBookingRatebyCourierAndWeight(
3653.                                         $shipmentObj->getShipmentType(), 
3654.                                         $zoneWiseMasterRateTypeObj->getRateType(), 
3655.                                         $courierObj->getId(), 
3656.                                         $courierWiseZoneObj->getZone()->getId(), 
3657.                                         $productTypeObj->getRateid(), 
3658.                                         30
3659.                                 );   
3661.                                 $zoneWiseMasterRateSs = $entityManager->getRepository(ZoneWiseMasterRate::class)
3662.                                     ->findBookingRatebyCourierAndWeight(
3663.                                         $shipmentObj->getShipmentType(), 
3664.                                         $zoneWiseMasterRateTypeObj->getRateType(), 
3665.                                         $courierObj->getId(), 
3666.                                         $courierWiseZoneObj->getZone()->getId(), 
3667.                                         $productTypeObj->getRateid(), 
3668.                                         31
3669.                                 ); 
3671.                                 $zoneWiseMasterRateTs = $entityManager->getRepository(ZoneWiseMasterRate::class)
3672.                                     ->findBookingRatebyCourierAndWeight(
3673.                                         $shipmentObj->getShipmentType(), 
3674.                                         $zoneWiseMasterRateTypeObj->getRateType(), 
3675.                                         $courierObj->getId(), 
3676.                                         $courierWiseZoneObj->getZone()->getId(), 
3677.                                         $productTypeObj->getRateid(), 
3678.                                         71
3679.                                 ); 
3681.                                 $finalRate = $zoneWiseMasterRateFs->getRate() + (40 * $zoneWiseMasterRateSs->getRate()) + (($rateBookingWeight - 70) * $zoneWiseMasterRateTs->getRate());
3682.                             }
3684.                             $salesInvoiceDetailsObj->setBookingRate($finalRate);
3686.                         }
3687.                     }
3688.                     else
3689.                     {
3690.                         // Expedite Or Cash Master Rate
3691.                         $countryWiseCashMasterRate = $entityManager->getRepository(CountryWiseMasterRate::class) 
3692.                                                     ->findCashBookingRatebyCourierAndWeight(2, $salesInvoiceDetailsObj->getShipmentDate(), $courierObj->getId(), $countryObj->getId(), $productTypeObj->getRateid(), $rateBookingWeight);                                          
3694.                         if($countryWiseCashMasterRate == null)
3695.                         {
3696.                             $zoneWiseMasterRate = $entityManager->getRepository(ZoneWiseMasterRate::class)
3697.                                                     ->findBookingCashRatebyCourierAndWeight(3, $salesInvoiceDetailsObj->getShipmentDate(), $courierObj->getId(), $courierWiseZoneObj->getZone()->getId(), $productTypeObj->getRateid(), $rateBookingWeight );                     
3699.                         }
3700.                         
3701.                         if($countryWiseCashMasterRate !== null)
3702.                         {
3703.                             $salesInvoiceDetailsObj->setBookingRate($countryWiseCashMasterRate->getRate() * $rateBookingWeight); 
3704.                         }
3705.                         else if($zoneWiseMasterRate !== null)      
3706.                         {                          
3707.                             $salesInvoiceDetailsObj->setBookingRate(round(($zoneWiseMasterRate->getRate() * $rateBookingWeight) / $settingsObj->getCurrency(),2));                                                         
3708.                         }
3709.                         else
3710.                         {
3711.                             return new JsonResponse(array('success' => false, 'responseText' => 'Cash Master Rate is not set for Courier : '.$courierObj->getName().', Country : '.$countryObj->getName().', Product Type : '.$productTypeObj->getName().', Weight : '.$rateWeight.' in Row Number '.$keyValue.'.'));
3712.                         }
3713.                         
3714.                         //$salesInvoiceDetailsObj->setBookingRate($countryObj->getMasterExpediteRate() * $rateBookingWeight);   
3715.                     }
3716.                     //Master Rate Assign End
3719.                     // Own Company Rate for Customer Start
3720.                     $salesCourierId = 0;
3721.                     $salesCourierName = "";
3722.                     $salesZoneId = 0;
3723.                     if($this->getUser()->getUserCompany()->getCustomerRate() == 2 ) // Own Company Wise Customer Rate
3724.                     {
3725.                         if($customerObj->getCustomerType() == 1 )  //Customer
3726.                         {
3727.                             $salesCourierId = $this->getUser()->getUserCompany()->getCompanyCourier()->getId();
3728.                             $salesCourierName = $this->getUser()->getUserCompany()->getCompanyCourier()->getName();
3730.                             /// Zone 
3731.                             $courierWiseZoneObject = $entityManager->getRepository(CourierWiseZone::class)
3732.                                                 ->findOneBy(['courier' => $salesCourierId, 'country' => $countryObj->getId() ]);                       
3733.                             if($courierWiseZoneObject === null )
3734.                             {
3735.                                     return new JsonResponse(array('success' => false, 'responseText' => 'Courier Wise Zone is not set for Courier : '. $courierObj->getName().', and Country : '.$countryObj->getName().' in Row Number '.$keyValue.'.'));
3736.                             }
3738.                             $salesZoneId = $courierWiseZoneObject->getZone()->getId();
3739.                                                             
3740.                         }
3741.                         else  //Agent
3742.                         {
3743.                             $salesCourierId = $courierObj->getId();
3744.                             $salesCourierName = $courierObj->getName();
3745.                             $salesZoneId = $courierWiseZoneObj->getZone()->getId();
3746.                             
3747.                         }
3748.                     }
3749.                     else   // Separate Courier Wise Customer Rate
3750.                     {
3751.                         $salesCourierId = $courierObj->getId();
3752.                         $salesCourierName = $courierObj->getName();
3753.                         $salesZoneId = $courierWiseZoneObj->getZone()->getId();
3754.                         
3755.                     }
3756.                     // Own Company Rate for Customer End
3759.                     if($salesInvoiceDetailsObj->getRateApplicable() <= 2 && !$salesInvoiceDetailsObj->getShipment()->isExpedite())  // Predefine Rate
3760.                     {
3761.                         
3762.                         $finalRateCal = 0;
3764.                         if($customerObj->getRateType() == 1)  // Customer wise sales rate     
3765.                         {
3766.                             if($courierObj->getId() != 3)    
3767.                             {  
3768.                                 if($rateWeight < $perKgRateWeight )
3769.                                 { 
3770.                                     $countryWiseSalesRate = $entityManager->getRepository(CountryWiseSalesRate::class)
3771.                                                             ->findOneBy(['type' => $shipmentObj->getShipmentType(), 'customer' => $customerObj->getId(), 'courier' => $salesCourierId, 'country' => $countryObj->getId(), 'productType' => $productTypeObj->getRateid(), 'weight' => $rateWeight ]);                                        
3772.                                     if($countryWiseSalesRate !== null)     
3773.                                     {                         
3774.                                         $finalRateCal = $countryWiseSalesRate->getRate();
3775.                                     }
3776.                                 }
3777.                                 else
3778.                                 {
3779.                                     $countryWiseSalesRate = $entityManager->getRepository(CountryWiseSalesRate::class)
3780.                                                             ->findOneBy(['type' => $shipmentObj->getShipmentType(), 'customer' => $customerObj->getId(), 'courier' => $salesCourierId, 'country' => $countryObj->getId(), 'productType' => $productTypeObj->getRateid(), 'weight' => $perKgRateWeight ]);                           
3781.                                     if($countryWiseSalesRate !== null)     
3782.                                     { 
3783.                                         $finalRateCal = $countryWiseSalesRate->getRate() * $rateWeight;                                            
3784.                                     }
3785.                                 }
3786.                               
3787.                                 if($countryWiseSalesRate === null)  
3788.                                 {
3789.                                     if($rateWeight < $perKgRateWeight )
3790.                                     {
3791.                                         $zoneWiseSalesRate = $entityManager->getRepository(ZoneWiseSalesRate::class)
3792.                                                                 ->findSalesRatebyCustomerAndWeight($shipmentObj->getShipmentType(), $customerObj->getId(), $salesCourierId, $salesZoneId, $productTypeObj->getRateid(), $rateWeight);                                     
3793.                                         if($zoneWiseSalesRate !== null)     
3794.                                         {                         
3795.                                             $finalRateCal = $zoneWiseSalesRate->getRate();
3796.                                         }
3797.                                     }
3798.                                     else
3799.                                     {                                                             
3800.                                         $zoneWiseSalesRate = $entityManager->getRepository(ZoneWiseSalesRate::class) 
3801.                                                                 ->findSalesRatebyCustomerAndWeight($shipmentObj->getShipmentType(), $customerObj->getId(), $salesCourierId, $salesZoneId, $productTypeObj->getRateid(), $courierObj->getId() == 3 ?  $perKgRateWeight : $rateWeight );                       
3802.                                         
3803.                                         if($zoneWiseSalesRate !== null)     
3804.                                         { 
3805.                                             $finalRateCal = $zoneWiseSalesRate->getRate() * $rateWeight;                                      
3806.                                         }
3807.                                     }
3808.                                 }        
3809.     
3810.                                 if($countryWiseSalesRate !== null)
3811.                                 {
3812.                                     $salesInvoiceDetailsObj->setSalesRate($finalRateCal);
3813.                                     
3814.                                 }
3815.                                 else if($zoneWiseSalesRate !== null)
3816.                                 {
3817.                                     $salesInvoiceDetailsObj->setSalesRate($finalRateCal);                                    
3818.                                 }
3819.                                 else
3820.                                 {                                   
3821.                                     return new JsonResponse(array('success' => false, 'responseText' => '7Customer Wise Sales Rate is not set for Customer : '.$customerObj->getName().' Courier : '.$salesCourierName.', Country : '.$countryObj->getName().', Product Type : '.$productTypeObj->getName().', Weight : '.$rateWeight.' in Row Number '.$keyValue.'.'));
3822.                                 }
3823.                             }
3824.                             else
3825.                             {
3826.                                 if($rateWeight <= 30)
3827.                                 {
3828.                                     $zoneWiseSalesRate = $entityManager->getRepository(ZoneWiseSalesRate::class)
3829.                                         ->findSalesRatebyCustomerAndWeight(
3830.                                             $shipmentObj->getShipmentType(), 
3831.                                             $customerObj->getId(), 
3832.                                             $salesCourierId, 
3833.                                             $salesZoneId, 
3834.                                             $productTypeObj->getRateid(), 
3835.                                             $rateWeight
3836.                                         );   
3838.                                     $finalSalesRate = $zoneWiseSalesRate->getRate();                      
3839.                                 }
3840.                                 else if($rateWeight > 30 && $rateWeight <= 70)
3841.                                 {
3842.                                     $zoneWiseSalesRateFs = $entityManager->getRepository(ZoneWiseSalesRate::class)
3843.                                         ->findSalesRatebyCustomerAndWeight(
3844.                                             $shipmentObj->getShipmentType(), 
3845.                                             $customerObj->getId(), 
3846.                                             $salesCourierId, 
3847.                                             $salesZoneId, 
3848.                                             $productTypeObj->getRateid(), 
3849.                                             30
3850.                                         );   
3851.                                     
3852.                                     $zoneWiseSalesRateSs = $entityManager->getRepository(ZoneWiseSalesRate::class)
3853.                                         ->findSalesRatebyCustomerAndWeight(
3854.                                             $shipmentObj->getShipmentType(), 
3855.                                             $customerObj->getId(), 
3856.                                             $salesCourierId, 
3857.                                             $salesZoneId, 
3858.                                             $productTypeObj->getRateid(), 
3859.                                             31
3860.                                         );  
3862.                                     $finalSalesRate = $zoneWiseSalesRateFs->getRate() + (($rateWeight - 30) * $zoneWiseSalesRateSs->getRate()); 
3863.                                 }
3864.                                 else if($rateWeight > 70)
3865.                                 {
3866.                                     $zoneWiseSalesRateFs = $entityManager->getRepository(ZoneWiseSalesRate::class)
3867.                                         ->findSalesRatebyCustomerAndWeight(
3868.                                             $shipmentObj->getShipmentType(), 
3869.                                             $customerObj->getId(), 
3870.                                             $salesCourierId, 
3871.                                             $salesZoneId, 
3872.                                             $productTypeObj->getRateid(), 
3873.                                             30
3874.                                         );   
3875.                                 
3876.                                     $zoneWiseSalesRateSs = $entityManager->getRepository(ZoneWiseSalesRate::class)
3877.                                         ->findSalesRatebyCustomerAndWeight(
3878.                                             $shipmentObj->getShipmentType(), 
3879.                                             $customerObj->getId(), 
3880.                                             $salesCourierId, 
3881.                                             $salesZoneId, 
3882.                                             $productTypeObj->getRateid(), 
3883.                                             31
3884.                                         );  
3886.                                     $zoneWiseSalesRateTs = $entityManager->getRepository(ZoneWiseSalesRate::class)
3887.                                         ->findSalesRatebyCustomerAndWeight(
3888.                                             $shipmentObj->getShipmentType(), 
3889.                                             $customerObj->getId(), 
3890.                                             $salesCourierId, 
3891.                                             $salesZoneId, 
3892.                                             $productTypeObj->getRateid(), 
3893.                                             71
3894.                                         ); 
3895.                                     
3896.                                     $finalSalesRate = $zoneWiseSalesRateFs->getRate() + (40 * $zoneWiseSalesRateSs->getRate()) + (($rateWeight - 70) * $zoneWiseSalesRateTs->getRate()); 
3897.                                 }
3898.                                 
3899.                                  $salesInvoiceDetailsObj->setSalesRate($finalSalesRate);
3900.                             }
3901.                         }
3902.                         else  // Common sales rate   
3903.                         {
3904.                             if($rateWeight < $perKgRateWeight )
3905.                             { 
3906.                                 $countryWiseSalesRate = $entityManager->getRepository(CountryWiseCommonSalesRate::class)
3907.                                                         ->findOneBy(['type' => $shipmentObj->getShipmentType(), 'courier' => $salesCourierId, 'country' => $countryObj->getId(), 'productType' => $productTypeObj->getRateid(), 'weight' => $rateWeight ]);                           
3908.                             }
3909.                             else
3910.                             {
3911.                                 $countryWiseSalesRate = $entityManager->getRepository(CountryWiseCommonSalesRate::class)
3912.                                                         ->findOneBy(['type' => $shipmentObj->getShipmentType(), 'courier' => $salesCourierId, 'country' => $countryObj->getId(), 'productType' => $productTypeObj->getRateid(), 'weight' => $perKgRateWeight ]);                           
3913.                                 if($countryWiseSalesRate !== null)     
3914.                                 {   
3915.                                     $countryWiseSalesRate->setRate($countryWiseSalesRate->getRate() * $rateWeight);
3916.                                 }
3917.                             }
3918.                                 
3920.                             if($countryWiseSalesRate === null)  
3921.                             {
3922.                                 if($rateWeight < $perKgRateWeight )
3923.                                 {
3924.                                     $zoneWiseSalesRate = $entityManager->getRepository(ZoneWiseCommonSalesRate::class)
3925.                                                             ->findCommonSalesRatebyCourierAndWeight($shipmentObj->getShipmentType(), $salesCourierId, $salesZoneId, $productTypeObj->getRateid(), $rateWeight);                                     
3926.                                 }
3927.                                 else
3928.                                 {
3929.                                     $zoneWiseSalesRate = $entityManager->getRepository(ZoneWiseCommonSalesRate::class)
3930.                                                             ->findCommonSalesRatebyCourierAndWeight($shipmentObj->getShipmentType(), $salesCourierId, $salesZoneId, $productTypeObj->getRateid(), $courierObj->getId() == 3 ?  $perKgRateWeight : $rateWeight );                       
3931.                                     if($zoneWiseSalesRate !== null)     
3932.                                     {       
3933.                                         $zoneWiseSalesRate->setRate($zoneWiseSalesRate->getRate() * $rateWeight);
3934.                                     }
3935.                                 }
3936.                             }        
3938.                             if($countryWiseSalesRate !== null)
3939.                             {
3940.                                 $salesInvoiceDetailsObj->setSalesRate($zoneWiseSalesRate->getRate());
3941.                             }
3942.                             else if($zoneWiseSalesRate !== null)
3943.                             {
3944.                                 $salesInvoiceDetailsObj->setSalesRate($countryWiseSalesRate->getRate());
3945.                             }
3946.                             else
3947.                             {                                   
3948.                                 return new JsonResponse(array('success' => false, 'responseText' => 'Common Sales Rate is not set for Courier : '.$salesCourierName.', Country : '.$countryObj->getName().', Product Type : '.$productTypeObj->getName().', Weight : '.$rateWeight.' in Row Number '.$keyValue.'.'));
3949.                             }
3950.                         }
3951.                         //Sales Rate Assign End
3952.                         
3953.                     }
3954.                     else  // Special Calculated Rate
3955.                     {
3956.                         
3957.                         $salesInvoiceDetailsObj->setSalesRate(round((float)$salesRate_array[$index] / $settingsObj->getCurrency(),2));                        
3958.                     }
3959.                     
3960.                     
3961.                     // Master Weight and Sales Rate Calculation Start
3962.                      
3963.                     if($salesInvoiceDetailsObj->getRateApplicable() <= 2 && !$salesInvoiceDetailsObj->getShipment()->isExpedite())  // Predefine Rate
3964.                     {
3965.                        
3966.                         $finalRateCal = 0;
3968.                         if($customerObj->getRateType() == 1)  // Customer wise sales rate     
3969.                         {
3970.                             if($rateBookingWeight < $perKgRateWeight )
3971.                             { 
3972.                                 $countryWiseSalesRate = $entityManager->getRepository(CountryWiseSalesRate::class)
3973.                                                         ->findOneBy(['type' => $shipmentObj->getShipmentType(), 'customer' => $customerObj->getId(), 'courier' => $courierObj->getId(), 'country' => $countryObj->getId(), 'productType' => $productTypeObj->getRateid(), 'weight' => $rateBookingWeight ]);                              
3974.                                 if($countryWiseSalesRate !== null)     
3975.                                 {                         
3976.                                     $finalRateCal = $countryWiseSalesRate->getRate();
3977.                                 }
3978.                             }
3979.                             else
3980.                             {
3981.                                 $countryWiseSalesRate = $entityManager->getRepository(CountryWiseSalesRate::class)
3982.                                                         ->findOneBy(['type' => $shipmentObj->getShipmentType(), 'customer' => $customerObj->getId(), 'courier' => $courierObj->getId(), 'country' => $countryObj->getId(), 'productType' => $productTypeObj->getRateid(), 'weight' => $perKgRateWeight ]);
3983.                                 if($countryWiseSalesRate !== null)     
3984.                                 { 
3985.                                     $finalRateCal = $countryWiseSalesRate->getRate() * $rateBookingWeight;                                            
3986.                                 }
3987.                             }
3988.                           
3989.                             if($countryWiseSalesRate === null)  
3990.                             {
3991.                                 if($rateBookingWeight < $perKgRateWeight )
3992.                                 {
3993.                                     $zoneWiseSalesRate = $entityManager->getRepository(ZoneWiseSalesRate::class)
3994.                                                             ->findSalesRatebyCustomerAndWeight($shipmentObj->getShipmentType(), $customerObj->getId(), $courierObj->getId(), $courierWiseZoneObj->getZone()->getId(), $productTypeObj->getRateid(), $rateBookingWeight);                                     
3995.                                     // return new JsonResponse(array('success' => false, 'responseText' => $rateBookingWeight .'-'. $zoneWiseSalesRate->getRate() ));                           
3996.                                     if($zoneWiseSalesRate !== null)     
3997.                                     {                         
3998.                                         $finalRateCal = $zoneWiseSalesRate->getRate();
3999.                                     }
4000.                                 }
4001.                                 else
4002.                                 {   
4003.                                     // return new JsonResponse(array('success' => false, 'responseText' => $shipmentObj->getShipmentType() .' - '. $customerObj->getId() .' - '.$courierObj->getId() .' - '. $courierWiseZoneObj->getZone()->getId() .' - '. $productTypeObj->getRateid() . ' - ' .$rateBookingWeight ));     
4004.                                     $zoneWiseSalesRate = $entityManager->getRepository(ZoneWiseSalesRate::class) 
4005.                                                             ->findSalesRatebyCustomerAndWeight($shipmentObj->getShipmentType(), $customerObj->getId(), $courierObj->getId(), $courierWiseZoneObj->getZone()->getId(), $productTypeObj->getRateid(),  $rateBookingWeight );                       
4006.                                     
4007.                                     if($zoneWiseSalesRate !== null)     
4008.                                     { 
4009.                                         $finalRateCal = $zoneWiseSalesRate->getRate() * $rateBookingWeight;                                      
4010.                                     }
4011.                                 }
4012.                             }        
4014.                             if($countryWiseSalesRate !== null)
4015.                             {
4016.                                 $salesInvoiceDetailsObj->setSalesMasterRate($finalRateCal);
4017.                                 
4018.                             }
4019.                             else if($zoneWiseSalesRate !== null)
4020.                             {
4021.                                 $salesInvoiceDetailsObj->setSalesMasterRate($finalRateCal);                                    
4022.                             }
4023.                             else
4024.                             {                                   
4025.                                 return new JsonResponse(array('success' => false, 'responseText' => '8Customer Wise Sales Rate is not set for Customer : '.$customerObj->getName().' Courier : '.$salesCourierName.', Country : '.$countryObj->getName().', Product Type : '.$productTypeObj->getName().', Weight : '.$rateWeight.' in Row Number '.$keyValue.'.'));
4026.                             }
4027.                         }
4028.                         else  // Common sales rate   
4029.                         {
4030.                             if($rateBookingWeight < $perKgRateWeight )
4031.                             { 
4032.                                 $countryWiseSalesRate = $entityManager->getRepository(CountryWiseCommonSalesRate::class)
4033.                                                         ->findOneBy(['type' => $shipmentObj->getShipmentType(), 'courier' => $courierObj->getId(), 'country' => $countryObj->getId(), 'productType' => $productTypeObj->getRateid(), 'weight' => $rateBookingWeight ]);                           
4034.                             }
4035.                             else
4036.                             {
4037.                                 $countryWiseSalesRate = $entityManager->getRepository(CountryWiseCommonSalesRate::class)
4038.                                                         ->findOneBy(['type' => $shipmentObj->getShipmentType(), 'courier' => $courierObj->getId(), 'country' => $countryObj->getId(), 'productType' => $productTypeObj->getRateid(), 'weight' => $perKgRateWeight ]);                           
4039.                                 if($countryWiseSalesRate !== null)     
4040.                                 {   
4041.                                     $countryWiseSalesRate->setRate($countryWiseSalesRate->getRate() * $rateWeight);
4042.                                 }
4043.                             }
4044.                                 
4046.                             if($countryWiseSalesRate === null)  
4047.                             {
4048.                                 if($rateWeight < $perKgRateWeight )
4049.                                 {
4050.                                     $zoneWiseSalesRate = $entityManager->getRepository(ZoneWiseCommonSalesRate::class)
4051.                                                             ->findCommonSalesRatebyCourierAndWeight($shipmentObj->getShipmentType(), $courierObj->getId(), $courierWiseZoneObj->getZone()->getId(), $productTypeObj->getRateid(), $rateBookingWeight);                                     
4052.                                 }
4053.                                 else
4054.                                 {
4055.                                     $zoneWiseSalesRate = $entityManager->getRepository(ZoneWiseCommonSalesRate::class)
4056.                                                             ->findCommonSalesRatebyCourierAndWeight($shipmentObj->getShipmentType(), $courierObj->getId(), $courierWiseZoneObj->getZone()->getId(), $productTypeObj->getRateid(), $courierObj->getId() == 3 ?  $perKgRateWeight : $rateBookingWeight );                       
4057.                                     if($zoneWiseSalesRate !== null)     
4058.                                     {       
4059.                                         $zoneWiseSalesRate->setRate($zoneWiseSalesRate->getRate() * $rateBookingWeight);
4060.                                     }
4061.                                 }
4062.                             }        
4064.                             if($countryWiseSalesRate !== null)
4065.                             {
4066.                                 $salesInvoiceDetailsObj->setSalesMasterRate($zoneWiseSalesRate->getRate());
4067.                             }
4068.                             else if($zoneWiseSalesRate !== null)
4069.                             {
4070.                                 $salesInvoiceDetailsObj->setSalesMasterRate($countryWiseSalesRate->getRate());
4071.                             }
4072.                             else
4073.                             {                                   
4074.                                 return new JsonResponse(array('success' => false, 'responseText' => 'Common Sales Rate is not set for Courier : '.$courierObj->getName().', Country : '.$countryObj->getName().', Product Type : '.$productTypeObj->getName().', Weight : '.$rateWeight.' in Row Number '.$keyValue.'.'));
4075.                             }
4076.                         }
4077.                         //Sales Rate Assign End
4078.                         
4079.                     }
4080.                     else  // Special Calculated Rate
4081.                     {
4082.                         
4083.                         // Get Settings Currency Start
4084.                         $settingsObj = $settingsInfoRepository
4085.                                             ->findByDateCurrency(1, $salesInvoiceDetailsObj->getShipmentDate()->format('Y-m-d')); 
4087.                         if($settingsObj === null)
4088.                         {                                
4089.                             return new JsonResponse(array('success' => false, 'responseText' => 'Currency is not set in Settings for Month : '.$salesInvoiceDetailsObj->getShipmentDate()->format('F').'-'.$salesInvoiceDetailsObj->getShipmentDate()->format('Y').' in Row Number '.$keyValue.'.'));
4090.                         }                       
4091.                         // Get Settings Currency End
4093.                         $salesInvoiceDetailsObj->setSalesMasterRate(round((float)$salesRate_array[$index] / $settingsObj->getCurrency(),2));                        
4094.                     }                    
4095.  
4096.                     // Master Weight and Sales Rate Calculation End
4099.                     // SRO Calculation Start
4100.                     if($courierObj->getSro() == 1 && $salesInvoiceDetailsObj->getRateApplicable() <= 2)
4101.                     {
4102.                         $salesInvoiceDetailsObj->setSro($courierObj->getSroCharge());
4103.                     }
4104.                     // SRO Calculation End
4105.                    
4106.                     //Master Covid Charge Cal Start
4107.                     if($salesInvoiceDetailsObj->getRateApplicable() <= 3 && !$salesInvoiceDetailsObj->getShipment()->isExpedite())
4108.                     {
4109.                         if($courierObj->getCovidChargeApplicable() == 1 && $courierObj->getId() == 1)  // DHL Covid Charge Cal
4110.                         {
4111.                             // $zoneWiseCovidCharge = $entityManager->getRepository(ZoneWiseCovidCharge::class)
4112.                             //                     ->findOneBy(['courier' => $courierObj->getId(), 'zone' => $courierWiseZoneObj->getZone() ]); 
4114.                             // if($zoneWiseCovidCharge === null)
4115.                             // {
4116.                             //     $countryWiseCovidCharge = $entityManager->getRepository(CountryWiseCovidCharge::class)
4117.                             //                             ->findOneBy(['courier' => $courierObj->getId(), 'country' => $countryObj->getId() ]);                           
4118.                             // }
4121.                             // Demand Charge Start
4122.                             // $comparisonDate = new DateTime('2024-09-14');
4124.                             // if($salesInvoiceDetailsObj->getShipmentDate() > $comparisonDate)
4125.                             // {
4126.                             //     $countryWiseCovidCharge = $entityManager->getRepository(CountryWiseCovidCharge::class)
4127.                             //                                 ->findOneBy(['courier' => $courierObj->getId(), 'country' => $countryObj->getId() ]); 
4128.                                 
4129.                             //     if($countryWiseCovidCharge !== null)
4130.                             //     {                          
4131.                             //         $salesInvoiceDetailsObj->setVendorCovidCharge($countryWiseCovidCharge->getRate() * $rateBookingWeight);
4132.                             //         //$salesInvoiceDetailsObj->setCovidCharge($countryWiseCovidCharge->getRate() * $rateWeight);  
4133.                             //     }
4134.                             //     else
4135.                             //     {
4136.                             //         return new JsonResponse(array('success' => false, 'responseText' => 'Demand Charge is not set for Courier : '.$courierObj->getName().', Country : '.$countryObj->getName().' in Row Number '.$keyValue.'.'));
4137.                             //     }   
4138.                             // }                          
4139.                             // Demand Charge End
4141.                             // // Go Green Charge Start
4142.                             // $comparisonDate = new DateTime('2024-04-01');
4144.                             // if ($salesInvoiceDetailsObj->getShipmentDate() < $comparisonDate) {
4145.                             //     if($countryObj->getId() == 11 || $countryObj->getId() == 151)
4146.                             //     {
4147.                             //         $covidChargeUsd = 3.35;
4148.                             //     }
4149.                             //     else
4150.                             //     {
4151.                             //         $covidChargeUsd = 1.15;
4152.                             //     }
4153.                             // } else {
4154.                             //     if($countryObj->getId() == 11 || $countryObj->getId() == 151)
4155.                             //     {
4156.                             //         $covidChargeUsd = 0.56;
4157.                             //     }
4158.                             //     else
4159.                             //     {
4160.                             //         $covidChargeUsd = 0.56;
4161.                             //     }
4162.                             // }
4164.                             // $salesInvoiceDetailsObj->setVendorCovidCharge($covidChargeUsd * $rateBookingWeight);
4165.                             // // Go Green Charge End
4167.                           
4168.                                 
4169.                         }
4170.                         else if($courierObj->getCovidChargeApplicable() == 1 && $courierObj->getId() == 2) // Fedex Covid Charge Cal
4171.                         {
4172.                             // Demand Charge Start
4173.                             $comparisonDate = new DateTime('2024-11-17');
4175.                             if($salesInvoiceDetailsObj->getShipmentDate() > $comparisonDate)
4176.                             {
4177.                                 $zoneWiseCovidCharge = $entityManager->getRepository(ZoneWiseCovidCharge::class)
4178.                                                     ->findOneBy(['courier' => $courierObj->getId(), 'zone' => $courierWiseZoneObj->getZone() ]); 
4179.                                 if($zoneWiseCovidCharge !== null)
4180.                                 {
4181.                                     $demandCharge =  $zoneWiseCovidCharge->getRate() * $rateBookingWeight;  
4182.                                 
4183.                                     if($demandCharge < 1)
4184.                                         $salesInvoiceDetailsObj->setVendorCovidCharge(1);
4185.                                     else
4186.                                         $salesInvoiceDetailsObj->setVendorCovidCharge($demandCharge);
4187.                                 }                         
4188.                                 else
4189.                                 {
4190.                                     return new JsonResponse(array('success' => false, 'responseText' => 'Demand Charge is not set for Courier : '.$courierObj->getName().', Country : '.$countryObj->getName().' in Row Number '.$keyValue.'.'));
4191.                                 }
4192.                                
4193.                             }
4194.                             else
4195.                             {
4196.                                 if($rateBookingWeight <= 3)
4197.                                 {
4198.                                     $salesInvoiceDetailsObj->setVendorCovidCharge(1);
4199.                                 }
4200.                                 else
4201.                                 {
4202.                                     $salesInvoiceDetailsObj->setVendorCovidCharge($rateBookingWeight * 0.30);
4203.                                 }
4204.                             }
4205.                         }
4206.                     }
4207.                     //Master Covid Charge Cal End
4209.                     //Sales Covid Charge Cal Start
4210.                     if($salesInvoiceDetailsObj->getRateApplicable() <= 2 && !$salesInvoiceDetailsObj->getShipment()->isExpedite())
4211.                     {
4212.                         if($courierObj->getCovidChargeApplicable() == 1 && $courierObj->getId() == 1)  // DHL Covid Charge Cal
4213.                         {
4214.                             // $zoneWiseCovidCharge = $entityManager->getRepository(ZoneWiseCovidCharge::class)
4215.                             //                     ->findOneBy(['courier' => $courierObj->getId(), 'zone' => $courierWiseZoneObj->getZone() ]); 
4217.                             // if($zoneWiseCovidCharge === null)
4218.                             // {
4219.                             //     $countryWiseCovidCharge = $entityManager->getRepository(CountryWiseCovidCharge::class)
4220.                             //                             ->findOneBy(['courier' => $courierObj->getId(), 'country' => $countryObj->getId() ]);                           
4221.                             // }
4224.                             // Demand Charge Start
4225.                             // $comparisonDate = new DateTime('2024-09-14');
4227.                             // if($salesInvoiceDetailsObj->getShipmentDate() > $comparisonDate)
4228.                             // {
4229.                             //     $countryWiseCovidCharge = $entityManager->getRepository(CountryWiseCovidCharge::class)
4230.                             //                                 ->findOneBy(['courier' => $courierObj->getId(), 'country' => $countryObj->getId() ]); 
4231.                                 
4232.                             //     if($countryWiseCovidCharge !== null)
4233.                             //     {                          
4234.                             //       // $salesInvoiceDetailsObj->setVendorCovidCharge($countryWiseCovidCharge->getRate() * $rateBookingWeight);
4235.                             //         $salesInvoiceDetailsObj->setCovidCharge($countryWiseCovidCharge->getRate() * $rateWeight);  
4236.                             //     }
4237.                             //     else
4238.                             //     {
4239.                             //         return new JsonResponse(array('success' => false, 'responseText' => 'Demand Charge is not set for Courier : '.$courierObj->getName().', Country : '.$countryObj->getName().' in Row Number '.$keyValue.'.'));
4240.                             //     }   
4241.                             // }                          
4242.                             // Demand Charge End
4244.                             // // Go Green Charge Start
4245.                             // $comparisonDate = new DateTime('2024-04-01');
4247.                             // if ($salesInvoiceDetailsObj->getShipmentDate() < $comparisonDate) {
4248.                             //     if($countryObj->getId() == 11 || $countryObj->getId() == 151)
4249.                             //     {
4250.                             //         $covidChargeUsd = 3.35;
4251.                             //     }
4252.                             //     else
4253.                             //     {
4254.                             //         $covidChargeUsd = 1.15;
4255.                             //     }
4256.                             // } else {
4257.                             //     if($countryObj->getId() == 11 || $countryObj->getId() == 151)
4258.                             //     {
4259.                             //         $covidChargeUsd = 0.56;
4260.                             //     }
4261.                             //     else
4262.                             //     {
4263.                             //         $covidChargeUsd = 0.56;
4264.                             //     }
4265.                             // }
4267.                             // $salesInvoiceDetailsObj->setVendorCovidCharge($covidChargeUsd * $rateWeight);
4268.                             
4269.                             // // Go Green Charge End
4271.                         }
4272.                         else if($courierObj->getCovidChargeApplicable() == 1 && $courierObj->getId() == 2) // Fedex Covid Charge Cal
4273.                         {
4274.                             // Demand Charge Start
4275.                             $comparisonDate = new DateTime('2024-11-17');
4277.                             if($salesInvoiceDetailsObj->getShipmentDate() > $comparisonDate)
4278.                             {
4279.                                 $zoneWiseCovidCharge = $entityManager->getRepository(ZoneWiseCovidCharge::class)
4280.                                                     ->findOneBy(['courier' => $courierObj->getId(), 'zone' => $courierWiseZoneObj->getZone() ]); 
4281.                                 if($zoneWiseCovidCharge !== null)
4282.                                 {
4283.                                     $demandCharge =  $zoneWiseCovidCharge->getRate() * $rateWeight;  
4284.                                 
4285.                                     if($demandCharge < 1)
4286.                                         $salesInvoiceDetailsObj->setCovidCharge(1);
4287.                                     else
4288.                                         $salesInvoiceDetailsObj->setCovidCharge($demandCharge);
4289.                                 }                         
4290.                                 else
4291.                                 {
4292.                                     return new JsonResponse(array('success' => false, 'responseText' => 'Demand Charge is not set for Courier : '.$courierObj->getName().', Country : '.$countryObj->getName().' in Row Number '.$keyValue.'.'));
4293.                                 }
4294.                             
4295.                             }
4296.                             else
4297.                             {
4298.                                 if($rateWeight <= 3)
4299.                                 {
4300.                                     $salesInvoiceDetailsObj->setCovidCharge(1);
4301.                                 }
4302.                                 else
4303.                                 {
4304.                                     $salesInvoiceDetailsObj->setCovidCharge($rateWeight * 0.30);
4305.                                 }
4306.                             }
4307.                         }
4308.                     }
4309.                     //Sales Covid Charge Cal End
4311.                     $salesInvoiceDetailsList->add($salesInvoiceDetailsObj);                    
4312.                     $index ++;
4313.                 }  
4316.                     //Data Save Process Start  
4317.                     $index = 0;
4318.                     $individualSalesInvoiceId = 0;
4319.                     foreach($salesInvoiceDetailsList as $row)
4320.                     { 
4321.                         $keyValue = $key;
4322.                         $keyValue = $keyValue + 1;
4323.     
4324.                         $shipmentDate = $row->getShipmentDate();
4325.                         
4326.                         // Demand Charge Start
4327.                         if($row->getCourier()->getId() == 1)
4328.                         {
4329.                             $comparisonDate = new DateTime('2025-10-01');
4331.                             if($shipmentDate >= $comparisonDate)
4332.                             {
4333.                                 $countryWiseCovidCharge = $entityManager->getRepository(CountryWiseCovidCharge::class)
4334.                                                             ->findOneBy(['courier' => $row->getCourier()->getId(), 'country' => $row->getCountry()->getId()]); 
4335.                                 
4336.                                 if($countryWiseCovidCharge !== null)
4337.                                 {
4338.                                     //Vendor/Booking weight Calculation Start 
4339.                                     // Half and Per KG
4340.                                     $bookingWeight = $row->getBookingWeight();
4341.                                     $pointInputBookingWeight = $bookingWeight - floor($bookingWeight);
4342.                                     $intInputBookingWeight = floor($bookingWeight);
4343.                                   // return new JsonResponse(array('success' => false, 'responseText' => $bookingWeight ));
4344.                                     $finalBookingWeight = 0;
4345.                                     $rateBookingWeight = 0;
4346.                                     if($bookingWeight <  $row->getCourier()->getWeightPerkg())
4347.                                     {
4348.                                         if($pointInputBookingWeight > 0 && $pointInputBookingWeight <= 0.5)
4349.                                         {
4350.                                             $finalBookingWeight = (float)0.5;
4351.                                         }
4352.                                         elseif($pointInputBookingWeight > 0.5 && $pointInputBookingWeight <=1)
4353.                                         {
4354.                                             $finalBookingWeight = (float)1;
4355.                                         }
4356.                                     }
4357.                                     else
4358.                                     {
4359.                                         if($pointInputBookingWeight > 0 && $pointInputBookingWeight <=1)
4360.                                         {
4361.                                             $finalBookingWeight = (float)1;
4362.                                         }
4363.                                     }
4364.                                     $rateBookingWeight = $intInputBookingWeight + $finalBookingWeight;
4365.                                     //Vendor/Booking weight Calculation End
4366.                                     
4367.                                     //Customer Weight Calculation Start 
4368.                                     // Half and Per KG
4369.                                     $weight = $row->getWeight();
4370.                                     $pointInputWeight = $weight - floor($weight);
4371.                                     $intInputWeight = floor($weight);
4372.                                     $finalWeight = 0;
4373.                                     $rateWeight = 0;
4374.                                     if($weight <  $row->getCourier()->getWeightPerkg())
4375.                                     {
4376.                                         if($pointInputWeight > 0 && $pointInputWeight <= 0.5)
4377.                                         {
4378.                                             $finalWeight = (float)0.5;
4379.                                         }
4380.                                         elseif($pointInputWeight > 0.5 && $pointInputWeight <=1)
4381.                                         {
4382.                                             $finalWeight = (float)1;
4383.                                         }
4384.                                     }
4385.                                     else
4386.                                     {
4387.                                         if($pointInputWeight > 0 && $pointInputWeight <=1)
4388.                                         {
4389.                                             $finalWeight = (float)1;
4390.                                         }
4391.                                     }
4392.                                     $rateWeight = $intInputWeight + $finalWeight;
4393.                                     //Customer Weight Calculation End 
4395.                                     $bookingDemandCharge = $countryWiseCovidCharge->getRate() * $rateBookingWeight;
4396.                                     $salesDemandCharge = $countryWiseCovidCharge->getRate() * $rateWeight;  
4397.                                     
4398.                                    
4399.                                 }
4400.                                 else
4401.                                 {
4402.                                     
4403.                                     return new JsonResponse(array('success' => false, 'responseText' => 'Demand Charge is not set for Courier : '.$row->getCourier()->getName().', Country : '.$row->getCountry()->getName().' in Row Number '.$keyValue.'.'));
4404.                                 }   
4405.                             }  
4406.                             else
4407.                             {
4408.                                 $bookingDemandCharge = 0;
4409.                                 $salesDemandCharge = 0;  
4410.                             }
4411.                         }                        
4412.                         // Demand Charge End
4413.     
4414.                         // Get Settings Currency Start
4415.                         $settingsObj = $settingsInfoRepository
4416.                                             ->findByDateCurrency(1, $shipmentDate->format('Y-m-d')); 
4418.                         if($settingsObj === null)
4419.                         {                                
4420.                             return new JsonResponse(array('success' => false, 'responseText' => 'Currency is not set in Settings for Month : '.$shipmentDate->format('F').'-'.$shipmentDate->format('Y').' in Row Number '.$keyValue.'.'));
4421.                         }                       
4422.                         // Get Settings Currency End
4424.                         // Get Vendor FSC Start
4425.                         $vendorFscObj = $settingsInfoRepository
4426.                                             ->findByDate(2, $row->getCourier()->getId(), $shipmentDate->format('Y-m-d')); 
4428.                         if($vendorFscObj === null)
4429.                         {                                
4430.                             return new JsonResponse(array('success' => false, 'responseText' => 'FSC is not set in FSC Setup for Courier: '.$courierObj->getName().' Month : '.$shipmentDate->format('F').'-'.$shipmentDate->format('Y').' in Row Number '.$keyValue.'.'));
4431.                         }                       
4432.                         // Get Vendor FSC End
4435.                         // Get Customer FSC Start
4436.                         $fscObj = $settingsInfoRepository
4437.                                     ->findByDate(2, $this->getUser()->getUserCompany()->getCustomerRate() == 1 ? $row->getCourier()->getId() : $salesCourierId, $shipmentDate->format('Y-m-d')); 
4439.                         if($fscObj === null)
4440.                         {                                
4441.                             return new JsonResponse(array('success' => false, 'responseText' => 'FSC is not set in FSC Setup for Month : '.$shipmentDate->format('F').'-'.$shipmentDate->format('Y').' in Row Number '.$keyValue.'.'));
4442.                         }                       
4443.                         // Get Customer FSC End
4445.                         $firstDateofMonth = date('Y-m-01', strtotime($shipmentDate->format('Y-m-d')));            
4446.                         $lastDateofMonth = date('Y-m-t', strtotime($shipmentDate->format('Y-m-d')));
4447.                         $lastDateofMonth = new \DateTime($lastDateofMonth);
4448.                         $halfDateofMonth = date('Y-m-d', strtotime($firstDateofMonth. ' + 14 days'));
4449.                         $halfDateofMonth = new \DateTime($halfDateofMonth);
4451.                         if($row->getCustomer()->getRateCurrency() == 2)
4452.                         {
4453.                             $row->setRateApplicable(3);
4454.                         }
4455.                         
4456.                         if($row->getCustomer()->getInvoicePeriod() == 1)  //Monthly Invoice Save Process
4457.                         {
4458.                             $salesInvoiceObj = $salesInvoiceRepository->findSalesInvoiceObjbyCustomerandDateRange($row->getCustomer()->getId(), $lastDateofMonth, $lastDateofMonth, $shipmentObj->getShipmentType(), $row->getCustomer()->getInvoicePeriod(), $this->getUser()->getUserCompany()->getId() );                    
4459.     
4460.                             $invocieDate = $lastDateofMonth;
4462.                             if($salesInvoiceObj === null)
4463.                             {
4464.                                 $salesInv = new SalesInvoice();
4465.                                 $salesInvoiceDetailsObj = new SalesInvoiceDetails();
4467.                                 $salesInv->setCustomer($row->getCustomer());
4468.                                 
4469.                                 $salesInvocieLastObj = $salesInvoiceRepository->findLastSalesInvoiceObj($row->getCustomer()->getId());
4470.                                 $invoiceNO = $utilsService->invoiceNoGenerator($salesInvocieLastObj, $row->getCustomer(), $invocieDate, $shipmentObj->getShipmentType());
4471.                                 $salesInv->setInvoiceNo($invoiceNO); 
4473.                                 $salesInv->setInvoiceDate($invocieDate);                                         
4474.                                 $salesInv->setVat($settingsObj->getVat());                          
4475.                                 $salesInv->setApproval(0);
4476.                                 $salesInv->setPaymentNote($this->getUser()->getUserCompany()->getPaymentNote());                           
4477.                                 $salesInv->setInvoicePeriod($row->getCustomer()->getInvoicePeriod());  
4478.                                 $salesInv->setRateApplicable($row->getRateApplicable());
4479.                                 $salesInv->setInvoiceType($shipmentObj->getShipmentType());
4481.                                 $salesInvoiceDetailsObj->setHawbNo($row->getHawbNo());   
4482.                                 $salesInvoiceDetailsObj->setReference($row->getReference());                               
4483.                                 $salesInvoiceDetailsObj->setWeight($row->getWeight());       
4484.                                 $salesInvoiceDetailsObj->setBookingWeight($row->getBookingWeight());                             
4485.                                 $salesInvoiceDetailsObj->setShipmentDate($row->getShipmentDate());                       
4486.                                 $salesInvoiceDetailsObj->setCountry($row->getCountry());                               
4487.                                 $salesInvoiceDetailsObj->setZone($row->getZone());
4488.                                 $salesInvoiceDetailsObj->setProductType($row->getProductType());                               
4489.                                 $salesInvoiceDetailsObj->setCourier($row->getCourier());                          
4490.                                 $salesInvoiceDetailsObj->setBookingRate($row->getBookingRate());                               
4491.                                 $salesInvoiceDetailsObj->setSalesRate($row->getSalesRate());
4493.                                 if($row->getCustomer()->getRateCurrency() == 2)
4494.                                 {
4495.                                     $salesInvoiceDetailsObj->setCurrency(1);
4496.                                 }
4497.                                 else
4498.                                 {
4499.                                     $salesInvoiceDetailsObj->setCurrency($row->getCustomer()->getCurrency() == 0 ? $settingsObj->getCurrency() : $row->getCustomer()->getCurrency() );
4500.                                 }
4502.                                 $salesInvoiceDetailsObj->setVendorCurrency($row->getCourier()->getId() == 1 ?  $settingsObj->getVendorCurrency() : $settingsObj->getCurrency());
4503.                                 $salesInvoiceDetailsObj->setVatApplicable(0);
4504.                                 $salesInvoiceDetailsObj->setRateApplicable($row->getRateApplicable());
4505.                                 
4506.                                 if($row->getRateApplicable() <= 2)
4507.                                     $salesInvoiceDetailsObj->setFsc( $row->getCustomer()->getFsc() == 0 ? $fscObj->getCurrency() : $row->getCustomer()->getFsc() ); 
4508.                                 else
4509.                                     $salesInvoiceDetailsObj->setFsc(0); 
4511.                                 if($row->getRateApplicable() <= 3)
4512.                                     $salesInvoiceDetailsObj->setVendorFsc($vendorFscObj->getCurrency()); 
4513.                                 else
4514.                                     $salesInvoiceDetailsObj->setVendorFsc(0); 
4516.                                 
4517.                                 $salesInvoiceDetailsObj->setCustomer($row->getCustomer());
4518.                                 $salesInvoiceDetailsObj->setCovidCharge($row->getCovidCharge() === null ? 0 : $row->getCovidCharge());
4519.                                 $salesInvoiceDetailsObj->setVendorCovidCharge($row->getVendorCovidCharge() === null ? 0 : $row->getVendorCovidCharge());
4520.                                 $salesInvoiceDetailsObj->setShipment($row->getShipment());
4521.                                 $salesInvoiceDetailsObj->setVatApplicable($row->getVatApplicable());
4522.                                 $salesInvoiceDetailsObj->setVendorVatApplicable($row->getVatApplicable());
4523.                                 $salesInvoiceDetailsObj->setSalesMasterRate($row->getSalesMasterRate());
4524.                                 $salesInvoiceDetailsObj->setSro($row->getSro());
4526.                                 // UPS Shipment Processing Fee Start 217
4527.                                 if($row->getCourier()->getId() == 3 && $row->getCountry()->getId() == 217 && $row->getRateApplicable() <= 2)
4528.                                 {
4529.                                     $invoiceAdditionalChargeObj = new InvoiceAdditionalCharge();
4530.                                     $invoiceAdditionalChargeObj->setAdditionalCharge($entityManager->find(AdditionalCharge::class, 3)); // 3 for Shipment Processing Fee
4531.                                     $invoiceAdditionalChargeObj->setCharge(2.5);
4532.                                     $invoiceAdditionalChargeObj->setFsc(0);
4533.                                     $invoiceAdditionalChargeObj->setVat(0);
4534.                                     $invoiceAdditionalChargeObj->setPayableCharge(2.5);
4535.                                     $salesInvoiceDetailsObj->addInvoiceAdditionalCharge($invoiceAdditionalChargeObj);
4536.                                 }
4537.                                 // UPS Shipment Processing Fee Start
4538.                                 
4539.                                 //DHL Demand Charge Start
4540.                                 if($row->getCourier()->getId() == 1 && $shipmentDate > $comparisonDate)
4541.                                 {
4542.                                     $invoiceAdditionalChargeObj = new InvoiceAdditionalCharge();
4543.                                     $invoiceAdditionalChargeObj->setAdditionalCharge($entityManager->find(AdditionalCharge::class, 8)); // 4 for Go Green Plus Fee
4544.                                     $invoiceAdditionalChargeObj->setCharge($salesDemandCharge);
4545.                                     $invoiceAdditionalChargeObj->setFsc(1);
4546.                                     $invoiceAdditionalChargeObj->setVat(0);
4547.                                     $invoiceAdditionalChargeObj->setPayableCharge($bookingDemandCharge);
4548.                                     $salesInvoiceDetailsObj->addInvoiceAdditionalCharge($invoiceAdditionalChargeObj);
4549.                                 }
4550.                                 //DHL Demand Charge End
4552.                                 $salesInv->addSalesInvoiceDetail($salesInvoiceDetailsObj);
4553.         
4554.                                 $entityManager->persist($salesInv);
4555.                                 $entityManager->flush($salesInv);   
4556.                                 
4557.                                 $salesInvoiceId = $salesInv->getId();
4558.         
4559.                             }
4560.                             else
4561.                             {
4562.                                 $salesInvoiceDetailsObj = new SalesInvoiceDetails();
4564.                                 $salesInvoiceDetailsObj->setHawbNo($row->getHawbNo());   
4565.                                 $salesInvoiceDetailsObj->setReference($row->getReference());                               
4566.                                 $salesInvoiceDetailsObj->setWeight($row->getWeight());       
4567.                                 $salesInvoiceDetailsObj->setBookingWeight($row->getBookingWeight());                             
4568.                                 $salesInvoiceDetailsObj->setShipmentDate($row->getShipmentDate());                           
4569.                                 $salesInvoiceDetailsObj->setCountry($row->getCountry());                               
4570.                                 $salesInvoiceDetailsObj->setZone($row->getZone());
4571.                                 $salesInvoiceDetailsObj->setProductType($row->getProductType());                               
4572.                                 $salesInvoiceDetailsObj->setCourier($row->getCourier());                          
4573.                                 $salesInvoiceDetailsObj->setBookingRate($row->getBookingRate());                               
4574.                                 $salesInvoiceDetailsObj->setSalesRate($row->getSalesRate());
4576.                                 if($row->getCustomer()->getRateCurrency() == 2)
4577.                                 {
4578.                                 $salesInvoiceDetailsObj->setCurrency(1);
4579.                                 }
4580.                                 else
4581.                                 {
4582.                                     $salesInvoiceDetailsObj->setCurrency($row->getCustomer()->getCurrency() == 0 ? $settingsObj->getCurrency() : $row->getCustomer()->getCurrency() );
4583.                                 }
4585.                                 $salesInvoiceDetailsObj->setVendorCurrency($row->getCourier()->getId() == 1 ?  $settingsObj->getVendorCurrency() : $settingsObj->getCurrency());
4586.                                 $salesInvoiceDetailsObj->setVatApplicable(0);
4587.                                 $salesInvoiceDetailsObj->setRateApplicable($row->getRateApplicable());
4589.                                 if($row->getRateApplicable() <= 2)
4590.                                     $salesInvoiceDetailsObj->setFsc( $row->getCustomer()->getFsc() == 0 ? $fscObj->getCurrency() : $row->getCustomer()->getFsc() ); 
4591.                                 else
4592.                                     $salesInvoiceDetailsObj->setFsc(0); 
4594.                                 if($row->getRateApplicable() <= 3)
4595.                                     $salesInvoiceDetailsObj->setVendorFsc($vendorFscObj->getCurrency()); 
4596.                                 else
4597.                                     $salesInvoiceDetailsObj->setVendorFsc(0); 
4599.                                 $salesInvoiceDetailsObj->setCustomer($row->getCustomer());
4600.                                 $salesInvoiceDetailsObj->setCovidCharge($row->getCovidCharge() === null ? 0 : $row->getCovidCharge());
4601.                                 $salesInvoiceDetailsObj->setVendorCovidCharge($row->getVendorCovidCharge() === null ? 0 : $row->getVendorCovidCharge());                            
4602.                                 $salesInvoiceDetailsObj->setSalesInvoice($salesInvoiceObj);
4603.                                 $salesInvoiceDetailsObj->setShipment($row->getShipment());
4604.                                 $salesInvoiceDetailsObj->setVatApplicable($row->getVatApplicable());
4605.                                 $salesInvoiceDetailsObj->setVendorVatApplicable($row->getVatApplicable());
4606.                                 $salesInvoiceDetailsObj->setSalesMasterRate($row->getSalesMasterRate());
4607.                                 $salesInvoiceDetailsObj->setSro($row->getSro());
4609.                                 // UPS Shipment Processing Fee Start
4610.                                 if($row->getCourier()->getId() == 3 && $row->getCountry()->getId() == 217  && $row->getRateApplicable() <= 2)
4611.                                 {
4612.                                     $invoiceAdditionalChargeObj = new InvoiceAdditionalCharge();
4613.                                     $invoiceAdditionalChargeObj->setAdditionalCharge($entityManager->find(AdditionalCharge::class, 3)); // 3 for Shipment Processing Fee
4614.                                     $invoiceAdditionalChargeObj->setCharge(2.5);
4615.                                     $invoiceAdditionalChargeObj->setFsc(0);
4616.                                     $invoiceAdditionalChargeObj->setVat(0);
4617.                                     $invoiceAdditionalChargeObj->setPayableCharge(2.5);
4618.                                     $salesInvoiceDetailsObj->addInvoiceAdditionalCharge($invoiceAdditionalChargeObj);
4619.                                 }
4620.                                 // UPS Shipment Processing Fee Start
4621.                                 
4622.                                 //DHL Demand Charge Start
4623.                                 if($row->getCourier()->getId() == 1 && $shipmentDate > $comparisonDate)
4624.                                 {
4625.                                     $invoiceAdditionalChargeObj = new InvoiceAdditionalCharge();
4626.                                     $invoiceAdditionalChargeObj->setAdditionalCharge($entityManager->find(AdditionalCharge::class, 8)); // 4 for Go Green Plus Fee
4627.                                     $invoiceAdditionalChargeObj->setCharge($salesDemandCharge);
4628.                                     $invoiceAdditionalChargeObj->setFsc(1);
4629.                                     $invoiceAdditionalChargeObj->setVat(0);
4630.                                     $invoiceAdditionalChargeObj->setPayableCharge($bookingDemandCharge);
4631.                                     $salesInvoiceDetailsObj->addInvoiceAdditionalCharge($invoiceAdditionalChargeObj);
4632.                                 }
4633.                                 //DHL Demand Charge End
4634.                                             
4635.                                 $entityManager->persist($salesInvoiceDetailsObj);
4636.                                 $entityManager->flush($salesInvoiceDetailsObj);
4637.                             }
4639.                         }
4640.                         else if($row->getCustomer()->getInvoicePeriod() == 2) //Half Monthly Invoice Save Process
4641.                         {
4642.                             if($shipmentDate <= $halfDateofMonth) // First Half month
4643.                             { 
4644.                                 $salesInvoiceObj = $salesInvoiceRepository
4645.                                         ->findSalesInvoiceObjbyCustomerandDateRange($row->getCustomer()->getId(), $halfDateofMonth, $halfDateofMonth, $shipmentObj->getShipmentType(), $row->getCustomer()->getInvoicePeriod(), $this->getUser()->getUserCompany()->getId() );                              
4646.                                 
4647.                                 $invocieDate = $halfDateofMonth;
4648.                             }  
4649.                             else
4650.                             {
4651.                                 $salesInvoiceObj = $salesInvoiceRepository
4652.                                     ->findSalesInvoiceObjbyCustomerandDateRange($row->getCustomer()->getId(), $lastDateofMonth, $lastDateofMonth, $shipmentObj->getShipmentType(), $row->getCustomer()->getInvoicePeriod(), $this->getUser()->getUserCompany()->getId() );                              
4654.                                 $invocieDate = $lastDateofMonth;
4655.                             }
4657.                             ////////////////Common portion
4659.                             if($salesInvoiceObj === null)
4660.                             {
4661.                                 $salesInv = new SalesInvoice();
4662.                                 $salesInvoiceDetailsObj = new SalesInvoiceDetails();
4664.                                 $salesInv->setCustomer($row->getCustomer());
4665.                                 
4666.                                 $salesInvocieLastObj = $salesInvoiceRepository->findLastSalesInvoiceObj($row->getCustomer()->getId());
4667.                                 $invoiceNO = $utilsService->invoiceNoGenerator($salesInvocieLastObj, $row->getCustomer(), $invocieDate, $shipmentObj->getShipmentType());
4668.                                 $salesInv->setInvoiceNo($invoiceNO); 
4670.                                 $salesInv->setInvoiceDate($invocieDate);                                         
4671.                                 $salesInv->setVat($settingsObj->getVat());                          
4672.                                 $salesInv->setApproval(0);
4673.                                 $salesInv->setPaymentNote($this->getUser()->getUserCompany()->getPaymentNote());                           
4674.                                 $salesInv->setInvoicePeriod($row->getCustomer()->getInvoicePeriod());  
4675.                                 $salesInv->setRateApplicable($row->getRateApplicable());
4676.                                 $salesInv->setInvoiceType($shipmentObj->getShipmentType());
4678.                                 $salesInvoiceDetailsObj->setHawbNo($row->getHawbNo());   
4679.                                 $salesInvoiceDetailsObj->setReference($row->getReference());                               
4680.                                 $salesInvoiceDetailsObj->setWeight($row->getWeight());       
4681.                                 $salesInvoiceDetailsObj->setBookingWeight($row->getBookingWeight());                             
4682.                                 $salesInvoiceDetailsObj->setShipmentDate($row->getShipmentDate());                       
4683.                                 $salesInvoiceDetailsObj->setCountry($row->getCountry());                               
4684.                                 $salesInvoiceDetailsObj->setZone($row->getZone());
4685.                                 $salesInvoiceDetailsObj->setProductType($row->getProductType());                               
4686.                                 $salesInvoiceDetailsObj->setCourier($row->getCourier());                          
4687.                                 $salesInvoiceDetailsObj->setBookingRate($row->getBookingRate());                               
4688.                                 $salesInvoiceDetailsObj->setSalesRate($row->getSalesRate());
4690.                                 if($row->getCustomer()->getRateCurrency() == 2)
4691.                                 {
4692.                                 $salesInvoiceDetailsObj->setCurrency(1);
4693.                                 }
4694.                                 else
4695.                                 {
4696.                                     $salesInvoiceDetailsObj->setCurrency($row->getCustomer()->getCurrency() == 0 ? $settingsObj->getCurrency() : $row->getCustomer()->getCurrency() );
4697.                                 }
4699.                                 $salesInvoiceDetailsObj->setVendorCurrency($row->getCourier()->getId() == 1 ?  $settingsObj->getVendorCurrency() : $settingsObj->getCurrency());
4700.                                 $salesInvoiceDetailsObj->setVatApplicable(0);
4701.                                 $salesInvoiceDetailsObj->setRateApplicable($row->getRateApplicable());
4702.                                 
4703.                                 if($row->getRateApplicable() <= 2)
4704.                                     $salesInvoiceDetailsObj->setFsc( $row->getCustomer()->getFsc() == 0 ? $fscObj->getCurrency() : $row->getCustomer()->getFsc() ); 
4705.                                 else
4706.                                     $salesInvoiceDetailsObj->setFsc(0); 
4708.                                 if($row->getRateApplicable() <= 3)
4709.                                     $salesInvoiceDetailsObj->setVendorFsc($vendorFscObj->getCurrency()); 
4710.                                 else
4711.                                     $salesInvoiceDetailsObj->setVendorFsc(0); 
4713.                                 $salesInvoiceDetailsObj->setCustomer($row->getCustomer());
4714.                                 $salesInvoiceDetailsObj->setCovidCharge($row->getCovidCharge() === null ? 0 : $row->getCovidCharge());
4715.                                 $salesInvoiceDetailsObj->setVendorCovidCharge($row->getVendorCovidCharge() === null ? 0 : $row->getVendorCovidCharge());
4716.                                 $salesInvoiceDetailsObj->setShipment($row->getShipment());
4717.                                 $salesInvoiceDetailsObj->setVatApplicable($row->getVatApplicable());
4718.                                 $salesInvoiceDetailsObj->setVendorVatApplicable($row->getVatApplicable());
4719.                                 $salesInvoiceDetailsObj->setSalesMasterRate($row->getSalesMasterRate());
4720.                                 $salesInvoiceDetailsObj->setSro($row->getSro());
4722.                                 // UPS Shipment Processing Fee Start
4723.                                 if($row->getCourier()->getId() == 3 && $row->getCountry()->getId() == 217 && $row->getRateApplicable() <= 2)
4724.                                 {
4725.                                     $invoiceAdditionalChargeObj = new InvoiceAdditionalCharge();
4726.                                     $invoiceAdditionalChargeObj->setAdditionalCharge($entityManager->find(AdditionalCharge::class, 3)); // 3 for Shipment Processing Fee
4727.                                     $invoiceAdditionalChargeObj->setCharge(2.5);
4728.                                     $invoiceAdditionalChargeObj->setFsc(0);
4729.                                     $invoiceAdditionalChargeObj->setVat(0);
4730.                                     $invoiceAdditionalChargeObj->setPayableCharge(2.5);
4731.                                     $salesInvoiceDetailsObj->addInvoiceAdditionalCharge($invoiceAdditionalChargeObj);
4732.                                 }
4733.                                 // UPS Shipment Processing Fee Start
4734.                                 
4735.                                 //DHL Demand Charge Start
4736.                                 if($row->getCourier()->getId() == 1 && $shipmentDate > $comparisonDate)
4737.                                 {
4738.                                     $invoiceAdditionalChargeObj = new InvoiceAdditionalCharge();
4739.                                     $invoiceAdditionalChargeObj->setAdditionalCharge($entityManager->find(AdditionalCharge::class, 8)); // 4 for Go Green Plus Fee
4740.                                     $invoiceAdditionalChargeObj->setCharge($salesDemandCharge);
4741.                                     $invoiceAdditionalChargeObj->setFsc(1);
4742.                                     $invoiceAdditionalChargeObj->setVat(0);
4743.                                     $invoiceAdditionalChargeObj->setPayableCharge($bookingDemandCharge);
4744.                                     $salesInvoiceDetailsObj->addInvoiceAdditionalCharge($invoiceAdditionalChargeObj);
4745.                                 }
4746.                                 //DHL Demand Charge End
4748.                                 $salesInv->addSalesInvoiceDetail($salesInvoiceDetailsObj);
4749.         
4750.                                 $entityManager->persist($salesInv);
4751.                                 $entityManager->flush($salesInv);    
4752.                                 
4753.                                 $salesInvoiceId = $salesInv->getId();
4754.         
4755.                             }
4756.                             else
4757.                             {
4758.                                 $salesInvoiceDetailsObj = new SalesInvoiceDetails();
4760.                                 $salesInvoiceDetailsObj->setHawbNo($row->getHawbNo());   
4761.                                 $salesInvoiceDetailsObj->setReference($row->getReference());                               
4762.                                 $salesInvoiceDetailsObj->setWeight($row->getWeight());       
4763.                                 $salesInvoiceDetailsObj->setBookingWeight($row->getBookingWeight());                             
4764.                                 $salesInvoiceDetailsObj->setShipmentDate($row->getShipmentDate());                           
4765.                                 $salesInvoiceDetailsObj->setCountry($row->getCountry());                               
4766.                                 $salesInvoiceDetailsObj->setZone($row->getZone());
4767.                                 $salesInvoiceDetailsObj->setProductType($row->getProductType());                               
4768.                                 $salesInvoiceDetailsObj->setCourier($row->getCourier());                          
4769.                                 $salesInvoiceDetailsObj->setBookingRate($row->getBookingRate());                               
4770.                                 $salesInvoiceDetailsObj->setSalesRate($row->getSalesRate());
4772.                                 if($row->getCustomer()->getRateCurrency() == 2)
4773.                                 {
4774.                                 $salesInvoiceDetailsObj->setCurrency(1);
4775.                                 }
4776.                                 else
4777.                                 {
4778.                                     $salesInvoiceDetailsObj->setCurrency($row->getCustomer()->getCurrency() == 0 ? $settingsObj->getCurrency() : $row->getCustomer()->getCurrency() );
4779.                                 }
4781.                                 $salesInvoiceDetailsObj->setVendorCurrency($row->getCourier()->getId() == 1 ?  $settingsObj->getVendorCurrency() : $settingsObj->getCurrency());
4782.                                 $salesInvoiceDetailsObj->setVatApplicable(0);
4783.                                 $salesInvoiceDetailsObj->setRateApplicable($row->getRateApplicable()); 
4785.                                 if($row->getRateApplicable() <= 2)
4786.                                     $salesInvoiceDetailsObj->setFsc( $row->getCustomer()->getFsc() == 0 ? $fscObj->getCurrency() : $row->getCustomer()->getFsc() ); 
4787.                                 else
4788.                                     $salesInvoiceDetailsObj->setFsc(0); 
4790.                                 if($row->getRateApplicable() <= 3)
4791.                                     $salesInvoiceDetailsObj->setVendorFsc($vendorFscObj->getCurrency()); 
4792.                                 else
4793.                                     $salesInvoiceDetailsObj->setVendorFsc(0); 
4795.                                 $salesInvoiceDetailsObj->setCustomer($row->getCustomer());
4796.                                 $salesInvoiceDetailsObj->setCovidCharge($row->getCovidCharge() === null ? 0 : $row->getCovidCharge()); 
4797.                                 $salesInvoiceDetailsObj->setVendorCovidCharge($row->getVendorCovidCharge() === null ? 0 : $row->getVendorCovidCharge());                           
4798.                                 $salesInvoiceDetailsObj->setSalesInvoice($salesInvoiceObj);
4799.                                 $salesInvoiceDetailsObj->setShipment($row->getShipment());
4800.                                 $salesInvoiceDetailsObj->setVatApplicable($row->getVatApplicable());
4801.                                 $salesInvoiceDetailsObj->setVendorVatApplicable($row->getVatApplicable());
4802.                                 $salesInvoiceDetailsObj->setSalesMasterRate($row->getSalesMasterRate());
4803.                                 $salesInvoiceDetailsObj->setSro($row->getSro());
4805.                                 // UPS Shipment Processing Fee Start
4806.                                 if($row->getCourier()->getId() == 3 && $row->getCountry()->getId() == 217 && $row->getRateApplicable() <= 2)
4807.                                 {
4808.                                     $invoiceAdditionalChargeObj = new InvoiceAdditionalCharge();
4809.                                     $invoiceAdditionalChargeObj->setAdditionalCharge($entityManager->find(AdditionalCharge::class, 3)); // 3 for Shipment Processing Fee
4810.                                     $invoiceAdditionalChargeObj->setCharge(2.5);
4811.                                     $invoiceAdditionalChargeObj->setFsc(0);
4812.                                     $invoiceAdditionalChargeObj->setVat(0);
4813.                                     $invoiceAdditionalChargeObj->setPayableCharge(2.5);
4814.                                     $salesInvoiceDetailsObj->addInvoiceAdditionalCharge($invoiceAdditionalChargeObj);
4815.                                 }
4816.                                 // UPS Shipment Processing Fee Start
4817.                                 
4818.                                 //DHL Demand Charge Start
4819.                                 if($row->getCourier()->getId() == 1 && $shipmentDate > $comparisonDate)
4820.                                 {
4821.                                     $invoiceAdditionalChargeObj = new InvoiceAdditionalCharge();
4822.                                     $invoiceAdditionalChargeObj->setAdditionalCharge($entityManager->find(AdditionalCharge::class, 8)); // 4 for Go Green Plus Fee
4823.                                     $invoiceAdditionalChargeObj->setCharge($salesDemandCharge);
4824.                                     $invoiceAdditionalChargeObj->setFsc(1);
4825.                                     $invoiceAdditionalChargeObj->setVat(0);
4826.                                     $invoiceAdditionalChargeObj->setPayableCharge($bookingDemandCharge);
4827.                                     $salesInvoiceDetailsObj->addInvoiceAdditionalCharge($invoiceAdditionalChargeObj);
4828.                                 }
4829.                                 //DHL Demand Charge End
4830.                                             
4831.                                 $entityManager->persist($salesInvoiceDetailsObj);
4832.                                 $entityManager->flush($salesInvoiceDetailsObj);
4833.                             }
4835.                             /////////////Common 
4836.                         }
4837.                         else if($row->getCustomer()->getInvoicePeriod() == 4) //Weekly Invoice Save Process
4838.                         {
4839.                             $invoicePeriods = [
4840.                                 ['start' => 1, 'end' => 7],
4841.                                 ['start' => 8, 'end' => 15],
4842.                                 ['start' => 16, 'end' => 22],
4843.                                 ['start' => 23, 'end' => $lastDateofMonth],
4844.                             ];
4846.                             $invoicePeriod = $this->getInvoicePeriod($row->getShipmentDate(), $invoicePeriods);
4848.                            // return new JsonResponse(array('success' => false, 'responseText' => $invoicePeriod['start']. ' - ' . $invoicePeriod['end'] ));
4850.                             $fromInvDate = clone $row->getShipmentDate();
4852.                             $fromInvDate->setDate(
4853.                                 $fromInvDate->format('Y'),  // Maintain the original year
4854.                                 $fromInvDate->format('m'),  // Maintain the original month
4855.                                 $invoicePeriod['start']                      // Set the new day
4856.                             );
4858.                             $toInvDate = clone $row->getShipmentDate();
4860.                             $toInvDate->setDate(
4861.                                 $toInvDate->format('Y'),  // Maintain the original year
4862.                                 $toInvDate->format('m'),  // Maintain the original month
4863.                                 $invoicePeriod['end']                      // Set the new day
4864.                             );
4866.                             $salesInvoiceObj = $salesInvoiceRepository
4867.                                         ->findSalesInvoiceObjbyCustomerandDateRange($row->getCustomer()->getId(),  $fromInvDate, $toInvDate, $shipmentObj->getShipmentType(), $row->getCustomer()->getInvoicePeriod(), $this->getUser()->getUserCompany()->getId() );                              
4868.                            
4869.                             if($salesInvoiceObj === null)
4870.                             {
4871.                                 $invocieDate = $toInvDate;
4873.                                 $salesInv = new SalesInvoice();
4874.                                 $salesInvoiceDetailsObj = new SalesInvoiceDetails();
4876.                                 $salesInv->setCustomer($row->getCustomer());
4877.                                 
4878.                                 $salesInvocieLastObj = $salesInvoiceRepository->findLastSalesInvoiceObj($row->getCustomer()->getId());
4879.                                 $invoiceNO = $utilsService->invoiceNoGenerator($salesInvocieLastObj, $row->getCustomer(), $invocieDate, $shipmentObj->getShipmentType());
4880.                                 $salesInv->setInvoiceNo($invoiceNO); 
4882.                                 $salesInv->setInvoiceDate($invocieDate);                                         
4883.                                 $salesInv->setVat($settingsObj->getVat());                          
4884.                                 $salesInv->setApproval(0);
4885.                                 $salesInv->setPaymentNote($this->getUser()->getUserCompany()->getPaymentNote());                           
4886.                                 $salesInv->setInvoicePeriod($row->getCustomer()->getInvoicePeriod());  
4887.                                 $salesInv->setRateApplicable($row->getRateApplicable());
4888.                                 $salesInv->setInvoiceType($shipmentObj->getShipmentType());
4890.                                 $salesInvoiceDetailsObj->setHawbNo($row->getHawbNo());   
4891.                                 $salesInvoiceDetailsObj->setReference($row->getReference());                               
4892.                                 $salesInvoiceDetailsObj->setWeight($row->getWeight());       
4893.                                 $salesInvoiceDetailsObj->setBookingWeight($row->getBookingWeight());                             
4894.                                 $salesInvoiceDetailsObj->setShipmentDate($row->getShipmentDate());                       
4895.                                 $salesInvoiceDetailsObj->setCountry($row->getCountry());                               
4896.                                 $salesInvoiceDetailsObj->setZone($row->getZone());
4897.                                 $salesInvoiceDetailsObj->setProductType($row->getProductType());                               
4898.                                 $salesInvoiceDetailsObj->setCourier($row->getCourier());                          
4899.                                 $salesInvoiceDetailsObj->setBookingRate($row->getBookingRate());                               
4900.                                 $salesInvoiceDetailsObj->setSalesRate($row->getSalesRate());
4902.                                 if($row->getCustomer()->getRateCurrency() == 2)
4903.                                 {
4904.                                 $salesInvoiceDetailsObj->setCurrency(1);
4905.                                 }
4906.                                 else
4907.                                 {
4908.                                     $salesInvoiceDetailsObj->setCurrency($row->getCustomer()->getCurrency() == 0 ? $settingsObj->getCurrency() : $row->getCustomer()->getCurrency() );
4909.                                 }
4911.                                 $salesInvoiceDetailsObj->setVendorCurrency($row->getCourier()->getId() == 1 ?  $settingsObj->getVendorCurrency() : $settingsObj->getCurrency());
4912.                                 $salesInvoiceDetailsObj->setVatApplicable(0);
4913.                                 $salesInvoiceDetailsObj->setRateApplicable($row->getRateApplicable());
4914.                                 
4915.                                 if($row->getRateApplicable() <= 2)
4916.                                     $salesInvoiceDetailsObj->setFsc( $row->getCustomer()->getFsc() == 0 ? $fscObj->getCurrency() : $row->getCustomer()->getFsc() ); 
4917.                                 else
4918.                                     $salesInvoiceDetailsObj->setFsc(0); 
4920.                                 if($row->getRateApplicable() <= 3)
4921.                                     $salesInvoiceDetailsObj->setVendorFsc($vendorFscObj->getCurrency()); 
4922.                                 else
4923.                                     $salesInvoiceDetailsObj->setVendorFsc(0); 
4925.                                 $salesInvoiceDetailsObj->setCustomer($row->getCustomer());
4926.                                 $salesInvoiceDetailsObj->setCovidCharge($row->getCovidCharge() === null ? 0 : $row->getCovidCharge());
4927.                                 $salesInvoiceDetailsObj->setVendorCovidCharge($row->getVendorCovidCharge() === null ? 0 : $row->getVendorCovidCharge());
4928.                                 $salesInvoiceDetailsObj->setShipment($row->getShipment());
4929.                                 $salesInvoiceDetailsObj->setVatApplicable($row->getVatApplicable());
4930.                                 $salesInvoiceDetailsObj->setVendorVatApplicable($row->getVatApplicable());
4931.                                 $salesInvoiceDetailsObj->setSalesMasterRate($row->getSalesMasterRate());
4932.                                 $salesInvoiceDetailsObj->setSro($row->getSro());
4934.                                 // UPS Shipment Processing Fee Start
4935.                                 if($row->getCourier()->getId() == 3 && $row->getCountry()->getId() == 217 && $row->getRateApplicable() <= 2)
4936.                                 {
4937.                                     $invoiceAdditionalChargeObj = new InvoiceAdditionalCharge();
4938.                                     $invoiceAdditionalChargeObj->setAdditionalCharge($entityManager->find(AdditionalCharge::class, 3)); // 3 for Shipment Processing Fee
4939.                                     $invoiceAdditionalChargeObj->setCharge(2.5);
4940.                                     $invoiceAdditionalChargeObj->setFsc(0);
4941.                                     $invoiceAdditionalChargeObj->setVat(0);
4942.                                     $invoiceAdditionalChargeObj->setPayableCharge(2.5);
4943.                                     $salesInvoiceDetailsObj->addInvoiceAdditionalCharge($invoiceAdditionalChargeObj);
4944.                                 }
4945.                                 // UPS Shipment Processing Fee Start
4946.                                 
4947.                                 //DHL Demand Charge Start
4948.                                 if($row->getCourier()->getId() == 1 && $shipmentDate > $comparisonDate)
4949.                                 {
4950.                                     $invoiceAdditionalChargeObj = new InvoiceAdditionalCharge();
4951.                                     $invoiceAdditionalChargeObj->setAdditionalCharge($entityManager->find(AdditionalCharge::class, 8)); // 4 for Go Green Plus Fee
4952.                                     $invoiceAdditionalChargeObj->setCharge($salesDemandCharge);
4953.                                     $invoiceAdditionalChargeObj->setFsc(1);
4954.                                     $invoiceAdditionalChargeObj->setVat(0);
4955.                                     $invoiceAdditionalChargeObj->setPayableCharge($bookingDemandCharge);
4956.                                     $salesInvoiceDetailsObj->addInvoiceAdditionalCharge($invoiceAdditionalChargeObj);
4957.                                 }
4958.                                 //DHL Demand Charge End
4960.                                 $salesInv->addSalesInvoiceDetail($salesInvoiceDetailsObj);
4961.         
4962.                                 $entityManager->persist($salesInv);
4963.                                 $entityManager->flush($salesInv);    
4964.                                 
4965.                                 $salesInvoiceId = $salesInv->getId();
4966.         
4967.                             }
4968.                             else
4969.                             {
4970.                                 $salesInvoiceDetailsObj = new SalesInvoiceDetails();
4972.                                 $salesInvoiceDetailsObj->setHawbNo($row->getHawbNo());   
4973.                                 $salesInvoiceDetailsObj->setReference($row->getReference());                               
4974.                                 $salesInvoiceDetailsObj->setWeight($row->getWeight());       
4975.                                 $salesInvoiceDetailsObj->setBookingWeight($row->getBookingWeight());                             
4976.                                 $salesInvoiceDetailsObj->setShipmentDate($row->getShipmentDate());                           
4977.                                 $salesInvoiceDetailsObj->setCountry($row->getCountry());                               
4978.                                 $salesInvoiceDetailsObj->setZone($row->getZone());
4979.                                 $salesInvoiceDetailsObj->setProductType($row->getProductType());                               
4980.                                 $salesInvoiceDetailsObj->setCourier($row->getCourier());                          
4981.                                 $salesInvoiceDetailsObj->setBookingRate($row->getBookingRate());                               
4982.                                 $salesInvoiceDetailsObj->setSalesRate($row->getSalesRate());
4984.                                 if($row->getCustomer()->getRateCurrency() == 2)
4985.                                 {
4986.                                 $salesInvoiceDetailsObj->setCurrency(1);
4987.                                 }
4988.                                 else
4989.                                 {
4990.                                     $salesInvoiceDetailsObj->setCurrency($row->getCustomer()->getCurrency() == 0 ? $settingsObj->getCurrency() : $row->getCustomer()->getCurrency() );
4991.                                 }
4993.                                 $salesInvoiceDetailsObj->setVendorCurrency($row->getCourier()->getId() == 1 ?  $settingsObj->getVendorCurrency() : $settingsObj->getCurrency());
4994.                                 $salesInvoiceDetailsObj->setVatApplicable(0);
4995.                                 $salesInvoiceDetailsObj->setRateApplicable($row->getRateApplicable()); 
4997.                                 if($row->getRateApplicable() <= 2)
4998.                                     $salesInvoiceDetailsObj->setFsc( $row->getCustomer()->getFsc() == 0 ? $fscObj->getCurrency() : $row->getCustomer()->getFsc() ); 
4999.                                 else
5000.                                     $salesInvoiceDetailsObj->setFsc(0); 
5002.                                 if($row->getRateApplicable() <= 3)
5003.                                     $salesInvoiceDetailsObj->setVendorFsc($vendorFscObj->getCurrency()); 
5004.                                 else
5005.                                     $salesInvoiceDetailsObj->setVendorFsc(0); 
5007.                                 $salesInvoiceDetailsObj->setCustomer($row->getCustomer());
5008.                                 $salesInvoiceDetailsObj->setCovidCharge($row->getCovidCharge() === null ? 0 : $row->getCovidCharge()); 
5009.                                 $salesInvoiceDetailsObj->setVendorCovidCharge($row->getVendorCovidCharge() === null ? 0 : $row->getVendorCovidCharge());                           
5010.                                 $salesInvoiceDetailsObj->setSalesInvoice($salesInvoiceObj);
5011.                                 $salesInvoiceDetailsObj->setShipment($row->getShipment());
5012.                                 $salesInvoiceDetailsObj->setVatApplicable($row->getVatApplicable());
5013.                                 $salesInvoiceDetailsObj->setVendorVatApplicable($row->getVatApplicable());
5014.                                 $salesInvoiceDetailsObj->setSalesMasterRate($row->getSalesMasterRate());
5015.                                 $salesInvoiceDetailsObj->setSro($row->getSro());
5017.                                 // UPS Shipment Processing Fee Start
5018.                                 if($row->getCourier()->getId() == 3 && $row->getCountry()->getId() == 217 && $row->getRateApplicable() <= 2)
5019.                                 {
5020.                                     $invoiceAdditionalChargeObj = new InvoiceAdditionalCharge();
5021.                                     $invoiceAdditionalChargeObj->setAdditionalCharge($entityManager->find(AdditionalCharge::class, 3)); // 3 for Shipment Processing Fee
5022.                                     $invoiceAdditionalChargeObj->setCharge(2.5);
5023.                                     $invoiceAdditionalChargeObj->setFsc(0);
5024.                                     $invoiceAdditionalChargeObj->setVat(0);
5025.                                     $invoiceAdditionalChargeObj->setPayableCharge(2.5);
5026.                                     $salesInvoiceDetailsObj->addInvoiceAdditionalCharge($invoiceAdditionalChargeObj);
5027.                                 }
5028.                                 // UPS Shipment Processing Fee Start
5029.                                 
5030.                                 //DHL Demand Charge Start
5031.                                 if($row->getCourier()->getId() == 1 && $shipmentDate > $comparisonDate)
5032.                                 {
5033.                                     $invoiceAdditionalChargeObj = new InvoiceAdditionalCharge();
5034.                                     $invoiceAdditionalChargeObj->setAdditionalCharge($entityManager->find(AdditionalCharge::class, 8)); // 4 for Go Green Plus Fee
5035.                                     $invoiceAdditionalChargeObj->setCharge($salesDemandCharge);
5036.                                     $invoiceAdditionalChargeObj->setFsc(1);
5037.                                     $invoiceAdditionalChargeObj->setVat(0);
5038.                                     $invoiceAdditionalChargeObj->setPayableCharge($bookingDemandCharge);
5039.                                     $salesInvoiceDetailsObj->addInvoiceAdditionalCharge($invoiceAdditionalChargeObj);
5040.                                 }
5041.                                 //DHL Demand Charge End
5042.                                             
5043.                                 $entityManager->persist($salesInvoiceDetailsObj);
5044.                                 $entityManager->flush($salesInvoiceDetailsObj);
5045.                             }
5046.             
5048.                         }
5049.                         else // HAWB NO Wise Invoice Save Process
5050.                         {
5051.                             $salesInv = new SalesInvoice();
5052.                             $salesInvoiceDetailsObj = new SalesInvoiceDetails();
5054.                             $salesInv->setCustomer($row->getCustomer());
5055.                             
5056.                             $salesInvocieLastObj = $salesInvoiceRepository->findLastSalesInvoiceObj($row->getCustomer()->getId());
5057.                             $invoiceNO = $utilsService->invoiceNoGenerator($salesInvocieLastObj, $row->getCustomer(), $shipmentDate, $shipmentObj->getShipmentType());
5058.                             $salesInv->setInvoiceNo($invoiceNO); 
5060.                             $salesInv->setInvoiceDate($shipmentDate);                                        
5061.                             $salesInv->setVat($settingsObj->getVat());                          
5062.                             $salesInv->setApproval(0);
5063.                             $salesInv->setPaymentNote($this->getUser()->getUserCompany()->getPaymentNote());                           
5064.                             $salesInv->setInvoicePeriod($row->getCustomer()->getInvoicePeriod());  
5065.                             $salesInv->setRateApplicable($row->getRateApplicable());
5066.                             $salesInv->setInvoiceType($shipmentObj->getShipmentType());
5068.                             $salesInvoiceDetailsObj->setHawbNo($row->getHawbNo());   
5069.                             $salesInvoiceDetailsObj->setReference($row->getReference());                               
5070.                             $salesInvoiceDetailsObj->setWeight($row->getWeight());       
5071.                             $salesInvoiceDetailsObj->setBookingWeight($row->getBookingWeight());                             
5072.                             $salesInvoiceDetailsObj->setShipmentDate($row->getShipmentDate());                       
5073.                             $salesInvoiceDetailsObj->setCountry($row->getCountry());                               
5074.                             $salesInvoiceDetailsObj->setZone($row->getZone());
5075.                             $salesInvoiceDetailsObj->setProductType($row->getProductType());                               
5076.                             $salesInvoiceDetailsObj->setCourier($row->getCourier());                          
5077.                             $salesInvoiceDetailsObj->setBookingRate($row->getBookingRate());                               
5078.                             $salesInvoiceDetailsObj->setSalesRate($row->getSalesRate());
5080.                             if($row->getCustomer()->getRateCurrency() == 2)
5081.                             {
5082.                                 $salesInvoiceDetailsObj->setCurrency(1);
5083.                             }
5084.                             else
5085.                             {
5086.                                 $salesInvoiceDetailsObj->setCurrency($row->getCustomer()->getCurrency() == 0 ? $settingsObj->getCurrency() : $row->getCustomer()->getCurrency() );
5087.                             }
5089.                             $salesInvoiceDetailsObj->setVendorCurrency($row->getCourier()->getId() == 1 ?  $settingsObj->getVendorCurrency() : $settingsObj->getCurrency());
5090.                             $salesInvoiceDetailsObj->setVatApplicable(0);
5091.                             $salesInvoiceDetailsObj->setRateApplicable($row->getRateApplicable());
5093.                             if($row->getRateApplicable() <= 2)
5094.                                 $salesInvoiceDetailsObj->setFsc( $row->getCustomer()->getFsc() == 0 ? $fscObj->getCurrency() : $row->getCustomer()->getFsc() ); 
5095.                             else
5096.                                 $salesInvoiceDetailsObj->setFsc(0); 
5098.                             if($row->getRateApplicable() <= 3)
5099.                                 $salesInvoiceDetailsObj->setVendorFsc($vendorFscObj->getCurrency()); 
5100.                             else
5101.                                 $salesInvoiceDetailsObj->setVendorFsc(0); 
5102.    
5103.                             $salesInvoiceDetailsObj->setCustomer($row->getCustomer());
5104.                             $salesInvoiceDetailsObj->setCovidCharge($row->getCovidCharge() === null ? 0 : $row->getCovidCharge());
5105.                             $salesInvoiceDetailsObj->setVendorCovidCharge($row->getVendorCovidCharge() === null ? 0 : $row->getVendorCovidCharge());
5106.                             $salesInvoiceDetailsObj->setShipment($row->getShipment());
5107.                             $salesInvoiceDetailsObj->setVatApplicable($row->getVatApplicable());
5108.                             $salesInvoiceDetailsObj->setVendorVatApplicable($row->getVatApplicable());
5109.                             $salesInvoiceDetailsObj->setSalesMasterRate($row->getSalesMasterRate());
5110.                             $salesInvoiceDetailsObj->setSro($row->getSro());
5112.                             // UPS Shipment Processing Fee Start
5113.                             if($row->getCourier()->getId() == 3 && $row->getCountry()->getId() == 217 && $row->getRateApplicable() <= 2)
5114.                             {
5115.                                 $invoiceAdditionalChargeObj = new InvoiceAdditionalCharge();
5116.                                 $invoiceAdditionalChargeObj->setAdditionalCharge($entityManager->find(AdditionalCharge::class, 3)); // 3 for Shipment Processing Fee
5117.                                 $invoiceAdditionalChargeObj->setCharge(2.5);
5118.                                 $invoiceAdditionalChargeObj->setFsc(0);
5119.                                 $invoiceAdditionalChargeObj->setVat(0);
5120.                                 $invoiceAdditionalChargeObj->setPayableCharge(2.5);
5121.                                 $salesInvoiceDetailsObj->addInvoiceAdditionalCharge($invoiceAdditionalChargeObj);
5122.                             }
5123.                             // UPS Shipment Processing Fee Start
5124.                             
5125.                             //DHL Demand Charge Start
5126.                             if($row->getCourier()->getId() == 1 && $shipmentDate > $comparisonDate)
5127.                             {
5128.                                 $invoiceAdditionalChargeObj = new InvoiceAdditionalCharge();
5129.                                 $invoiceAdditionalChargeObj->setAdditionalCharge($entityManager->find(AdditionalCharge::class, 8)); // 4 for Go Green Plus Fee
5130.                                 $invoiceAdditionalChargeObj->setCharge($salesDemandCharge);
5131.                                 $invoiceAdditionalChargeObj->setFsc(1);
5132.                                 $invoiceAdditionalChargeObj->setVat(0);
5133.                                 $invoiceAdditionalChargeObj->setPayableCharge($bookingDemandCharge);
5134.                                 $salesInvoiceDetailsObj->addInvoiceAdditionalCharge($invoiceAdditionalChargeObj);
5135.                             }
5136.                             //DHL Demand Charge End
5138.                             $salesInv->addSalesInvoiceDetail($salesInvoiceDetailsObj);
5140.                             $entityManager->persist($salesInv);
5141.                             $entityManager->flush($salesInv); 
5142.                           
5143.                         }
5146.                         $index ++;
5147.                     } 
5149.                                 
5150.                                 
5151.                 }
5153.                 
5154.                 
5155.             }
5157.             $this->addFlash('notice', 'Sales Invoice Created successfully!');
5158.                     
5159.             return new JsonResponse(array('success' => true));    
5160.     }
5161.     
5162.     
5163.     #[Route('/salesinvoice/{id}/accessory-surcharge', name: 'app_sales_invoice_accessory_surcharge', methods: ['GET', 'POST'])]
5164.     public function accessorySurcharge(SalesInvoice $salesInvoice, EntityManagerInterface $entityManager, Request $request, SettingsInfoRepository $settingsInfoRepository, CourierWiseZoneRepository $courierWiseZoneRepository): Response
5165.     {
5166.         $salesInvoice->getSalesInvoiceDetails()->clear();
5167.         $form = $this->createForm(InvoiceSurchargeType::class, $salesInvoice);
5168.         $form->handleRequest($request);
5170.         if ($form->isSubmitted() && $form->isValid()) {
5172.             // Get Settings Currency Start
5173.             $settingsObj = $settingsInfoRepository
5174.                         ->findByDateCurrency(1, $salesInvoice->getInvoiceDate()->format('Y-m-d')); 
5176.             if($settingsObj === null)
5177.             {                                
5178.                 
5179.                 $this->addFlash('warning', 'Currency is not set in Settings for Month : '.$salesInvoice->getInvoiceDate()->format('F').'-'.$salesInvoice->getInvoiceDate()->format('Y'));
5180.                                                                     
5181.                 return $this->redirectToRoute('app_sales_invoice_show', ['id' => $salesInvoice->getId()]);     
5182.             }                       
5183.             // Get Settings Currency End
5185.             foreach ($form->get('salesInvoiceDetails') as $formChild) {
5186.               
5187.                 $salesInvoiceDetailsObj = new SalesInvoiceDetails();
5189.              
5190.                 $salesInvoiceDetailsObj->setSalesInvoice($salesInvoice);
5191.                 $salesInvoiceDetailsObj->setShipmentDate($formChild->get('shipmentDate')->getData());
5192.                 $salesInvoiceDetailsObj->setHawbNo($formChild->get('hawbNo')->getData());
5193.                 $salesInvoiceDetailsObj->setReference($formChild->get('reference')->getData());
5194.                 $salesInvoiceDetailsObj->setCountry($formChild->get('country')->getData());
5195.                 $salesInvoiceDetailsObj->setProductType($formChild->get('productType')->getData());
5196.                 $salesInvoiceDetailsObj->setCourier($formChild->get('courier')->getData());
5198.                 $courierWiseZoneObj = $courierWiseZoneRepository
5199.                                         ->findOneBy(['courier' => $formChild->get('courier')->getData()->getId(), 'country' => $formChild->get('country')->getData()->getId() ]);  
5201.                 if($courierWiseZoneObj === null )
5202.                 {
5203.                     $this->addFlash('warning', 'Courier Wise Zone is not set for Courier : '.  $formChild->get('courier')->getData()->getName().', and Country : '.$formChild->get('country')->getData()->getName());
5205.                     return $this->redirectToRoute('app_sales_invoice_show', ['id' => $salesInvoice->getId()]);     
5206.                 }
5207.                 $salesInvoiceDetailsObj->setZone($courierWiseZoneObj->getZone());
5209.                 $salesInvoiceDetailsObj->setWeight($formChild->get('weight')->getData());
5210.                 $salesInvoiceDetailsObj->setBookingWeight($formChild->get('weight')->getData());
5211.                 
5212.                 $salesInvoiceDetailsObj->setSalesRate($formChild->get('salesRate')->getData());
5213.                 $salesInvoiceDetailsObj->setBookingRate($formChild->get('salesRate')->getData());
5215.                 $salesInvoiceDetailsObj->setCurrency($settingsObj->getCurrency());
5216.                 $salesInvoiceDetailsObj->setVendorCurrency($settingsObj->getVendorCurrency());
5217.                 $salesInvoiceDetailsObj->setCovidCharge(0);
5218.                 $salesInvoiceDetailsObj->setFsc(0);
5219.                 $salesInvoiceDetailsObj->setVendorFsc(0);
5220.                 $salesInvoiceDetailsObj->setVendorCovidCharge(0);
5221.                 $salesInvoiceDetailsObj->setSalesMasterRate($formChild->get('salesRate')->getData());
5222.                                
5223.                 $entityManager->persist($salesInvoiceDetailsObj);
5224.                 $entityManager->flush($salesInvoiceDetailsObj); 
5226.             }
5228.             $this->addFlash('notice', 'Accessory Surcharge Created successfully!');
5230.             return $this->redirectToRoute('app_sales_invoice_show', ['id' => $salesInvoice->getId()]);         
5231.         }
5233.         return $this->renderForm('sales_invoice/accessorySurcharge.html.twig', [
5234.             'salesInvoice' => $salesInvoice,
5235.             'form' => $form,
5236.         ]);
5237.     }
5238.     
5239.     #[Route('/salesinvoice/country-wise-invoice', name: 'app_sales_invoice_country_wise_invoice', methods: ['GET', 'POST'])]
5240.     public function countryWiseInvoice(Request $request)
5241.     {
5242.         $form = $this->createFormBuilder(null)           
5243.             ->add('fromDate', DateType::class, [
5244.                 'attr' => ['class' => 'form-control'],
5245.                 'widget' => 'single_text',
5246.                 'empty_data' => null,
5247.                 'label' => 'From Date',            
5248.                 ])  
5249.             ->add('toDate', DateType::class, [
5250.                 'attr' => ['class' => 'form-control'],
5251.                 'widget' => 'single_text',
5252.                 'empty_data' => null,
5253.                 'label' => 'To Date',                
5254.                 ])   
5255.             ->add('customer', EntityType::class, [
5256.                 // looks for choices from this entity
5257.                 'class' => Customer::class,
5258.                 'query_builder' => function (CustomerRepository $er) {
5259.                     return $er->createQueryBuilder('v') 
5260.                         ->where('v.userCompany = '.$this->getUser()->getUserCompany()->getId())                        
5261.                         ->orderBy('v.name', 'ASC');
5262.                 },                
5263.                 // uses the User.username property as the visible option string
5264.                 'choice_label' => 'name',
5265.                 'placeholder' => 'Select a Customer...',
5266.                 'attr' => [
5267.                     'class' => 'form-control select-tags',
5268.                     'style' => 'width:100%;',
5269.                     ],
5270.                 'label' => 'Customer',
5271.                 // used to render a select box, check boxes or radios
5272.                 // 'multiple' => true,
5273.                 // 'expanded' => true,
5274.                 ])
5275.             ->add('country', EntityType::class, [
5276.                 // looks for choices from this entity
5277.                 'class' => Country::class,
5278.                 'query_builder' => function (CountryRepository $er) {
5279.                     return $er->createQueryBuilder('v')                                   
5280.                         ->orderBy('v.name', 'ASC');
5281.                 },                
5282.                 // uses the User.username property as the visible option string
5283.                 'choice_label' => 'name',
5284.                 'placeholder' => 'Select a Country...',
5285.                 'attr' => [
5286.                     'class' => 'form-control select-tags',
5287.                     'style' => 'width:100%;',
5288.                     ],
5289.                 'label' => 'Country',               
5290.                 // used to render a select box, check boxes or radios
5291.                 // 'multiple' => true,
5292.                 // 'expanded' => true,
5293.                 ])
5294.         
5295.             ->getForm();
5297.         $form->handleRequest($request); 
5298.                      
5299.         if ($form->isSubmitted() && $form->isValid()) {
5300.             $data = $form->getData();                     
5301.             $fromDate =  $form->get('fromDate')->getData()->format('Y-m-d');  
5302.             $toDate =  $form->get('toDate')->getData()->format('Y-m-d'); 
5303.             $customerId = $form->get('customer')->getData()->getId();  
5304.             $countryId = $form->get('country')->getData()->getId();     
5305.                
5306.             $formInvoice = $this->createFormBuilder(null)           
5307.                     ->add('reference', EntityType::class, [
5308.                         // looks for choices from this entity
5309.                         'class' => SalesInvoiceDetails::class,
5310.                         'query_builder' => function (SalesInvoiceDetailsRepository $er) use ($fromDate, $toDate, $customerId, $countryId) {
5311.                             return $er->createQueryBuilder('s')
5312.                                     ->innerJoin('s.salesInvoice', 'i')   
5313.                                     ->andWhere('i.invoiceType = 1')
5314.                                     ->andWhere('s.shipmentDate BETWEEN :fromDate AND :toDate') 
5315.                                     ->andWhere('i.customer = :customerId')      
5316.                                     ->andWhere('s.country = :countryId')                                                 
5317.                                     ->setParameter('fromDate', $fromDate)
5318.                                     ->setParameter('toDate', $toDate)    
5319.                                     ->setParameter('customerId', $customerId)  
5320.                                     ->setParameter('countryId', $countryId)            
5321.                                     ->orderBy('s.shipmentDate', 'ASC')
5322.                                     ->groupBy('s.reference');
5323.                             },     
5324.                         // uses the User.username property as the visible option string
5325.                         'choice_label' => 'reference',
5326.                         'placeholder' => 'Select a Reference No...',
5327.                         'attr' => [
5328.                             'class' => 'form-control select-tags',
5329.                             ],
5330.                         'label' => 'Reference',
5331.                         // used to render a select box, check boxes or radios
5332.                         // 'multiple' => true,
5333.                         // 'expanded' => true,
5334.                         ])
5336.                     // ADD HIDDEN FIELDS                  
5337.                     ->add('fromDate', HiddenType::class, [
5338.                         'data' => $fromDate,
5339.                     ])
5340.                     ->add('toDate', HiddenType::class, [
5341.                         'data' => $toDate,
5342.                     ])
5343.                     ->add('customer', HiddenType::class, [
5344.                         'data' => $customerId,
5345.                     ])       
5346.                     ->add('country', HiddenType::class, [
5347.                         'data' => $countryId,                       
5348.                     ])          
5349.                     ->getForm();
5350.  
5351.             $formInvoice->handleRequest($request); 
5352.            
5353.             return $this->render('sales_invoice/country_wise_invoice.html.twig', [
5354.                 'formInvoice' => $formInvoice->createView(),       
5355.                 'form' => $form->createView(),    
5356.                 'track' => 1,
5357.             ]);
5358.         }
5359.        
5361.         $bookingObj = new SalesInvoiceDetails();
5362.         
5363.         return $this->render('sales_invoice/country_wise_invoice.html.twig', [
5364.             'form' => $form->createView(),
5365.             'bookingList' => $bookingObj,            
5366.             'track' => 0,
5367.         ]);
5368.     }
5369.        
5370.     #[Route('/salesinvoice/country-sales-invoice-preview/', name: 'app_sales_invoice_country_sales_invoice_preview')]  
5371.     #[IsGranted("ROLE_ADMIN")]
5372.     public function countryWiseInvoicePreview(Request $request, ReceiveVoucherRepository $receiveVoucherRepository, ShipmentRepository $shipmentRepository, SalesInvoiceRepository $salesInvoiceRepository, SettingsInfoRepository $settingsInfoRepository, SalesInvoiceDetailsRepository $repo)
5373.     {
5374.         $currencyType = 1;
5375.         $padPrint = 1;
5377.         // You must rebuild the SAME exact reference form again
5378.         $formInvoice = $this->createFormBuilder(null)
5379.             ->add('reference', EntityType::class, [
5380.                 'class' => SalesInvoiceDetails::class,
5381.                 'choice_label' => 'reference',
5382.             ])            
5383.             ->add('fromDate', HiddenType::class)
5384.             ->add('toDate', HiddenType::class)
5385.             ->add('customer', HiddenType::class)
5386.             ->add('country', HiddenType::class)            
5387.             ->getForm();
5389.         $formInvoice->handleRequest($request);
5391.         if ($formInvoice->isSubmitted() && $formInvoice->isValid()) {
5392.             $reference = $formInvoice->get('reference')->getData()->getReference();
5394.             // HIDDEN FIELD VALUES
5395.             $fromDate  = $formInvoice->get('fromDate')->getData();
5396.             $toDate    = $formInvoice->get('toDate')->getData();
5397.             $customerId = $formInvoice->get('customer')->getData();
5398.             $countryId = $formInvoice->get('country')->getData();
5400.             $results = $repo->createQueryBuilder('s')
5401.                     ->innerJoin('s.salesInvoice', 'i')
5402.                     ->andWhere('i.invoiceType = 1')
5403.                     ->andWhere('s.shipmentDate BETWEEN :fromDate AND :toDate')
5404.                     ->andWhere('i.customer = :customerId')      
5405.                     ->andWhere('s.country = :countryId')  
5406.                     ->andWhere('s.reference = :reference')                    
5407.                     ->setParameter('fromDate', $fromDate)
5408.                     ->setParameter('toDate', $toDate)
5409.                     ->setParameter('customerId', $customerId)  
5410.                     ->setParameter('countryId', $countryId)    
5411.                     ->setParameter('reference', $reference)
5412.                     ->orderBy('s.shipmentDate', 'ASC')
5413.                     ->getQuery()
5414.                     ->getResult();
5415.            
5416.             // Configure Dompdf according to your needs
5417.             $pdfOptions = new Options();
5418.             $pdfOptions->set('defaultFont', 'Arial');
5419.                 
5420.             // Instantiate Dompdf with our options
5421.             $dompdf = new Dompdf($pdfOptions);
5422.         
5423.             $userObj = $this->getUser();
5424.                        
5425.             $lastReceivedObj = null;
5426.                     
5427.             $duesAmount = 0;
5428.     
5429.             $groupByCourier = null;
5430.             
5431.             $totalReceivedAmount =  0;
5432.             $totalAdjustAmount =  0;          
5433.             $uptoReceivedInvoiceDate = 0;
5434.         
5435.             $html = $this->renderView('sales_invoice/country_wise_invoice_preview.html.twig', [
5436.                 'salesInvoice' => $results, 
5437.                 'userObj' => $userObj,
5438.                 'lastReceivedObj' => $lastReceivedObj,
5439.                 'duesAmount' => $duesAmount + $uptoReceivedInvoiceDate,
5440.                 'userCompanyLogo' => $this->imageToBase64($this->getParameter('kernel.project_dir') . '/public/uploads/usercompanylogo/'. $userObj->getUserCompany()->getLogoPath() ),         
5441.                 'currencyType' => $currencyType,
5442.                 'groupByCourier' => $groupByCourier,
5443.                 'padPrint' => $padPrint,
5444.                 'totalReceivedAmount' => $totalReceivedAmount,
5445.                 'totalAdjustAmount' => $totalAdjustAmount,
5446.             ]);
5447.                     
5448.             // Load HTML to Dompdf
5449.             $dompdf->loadHtml($html);
5450.             
5451.             // (Optional) Setup the paper size and orientation 'portrait' or 'landscape'
5452.             $dompdf->setPaper('A4', 'portrait');
5454.             // Render the HTML as PDF
5455.             $dompdf->render();
5457.             //  Add Watermark in Domdpf
5459.             // Instantiate canvas instance 
5460.             $canvas = $dompdf->getCanvas();
5461.                 
5462.             // Get the number of pages in the PDF
5463.             $pageCount = $canvas->get_page_count();
5465.             if(1 == 0)
5466.             {
5467.                 $callback = function ($pageNumber) use ($pageCount, $pdfOptions, $canvas) {
5468.                     // Set text opacity 
5469.                     $canvas->set_opacity(0.2, 'Multiply');   
5471.                     // Instantiate font metrics class 
5472.                     $fontMetrics = new FontMetrics($canvas, $pdfOptions);
5474.                     // Get height and width of page 
5475.                     $w = $canvas->get_width(); 
5476.                     $h = $canvas->get_height(); 
5477.                     
5478.                     // Get font family file 
5479.                     $font = $fontMetrics->getFont('times'); 
5480.                     
5481.                     // Specify watermark text 
5482.                     $text = "DRAFT"; 
5483.                     
5484.                     // Get height and width of text 
5485.                     $txtHeight = $fontMetrics->getFontHeight($font, 75); 
5486.                     $textWidth = $fontMetrics->getTextWidth($text, $font, 75); 
5487.                                 
5488.                     // Specify horizontal and vertical position 
5489.                     $x = (($w-$textWidth)/2); 
5490.                     $y = (($h-$txtHeight)/2); 
5491.                     
5492.                     // Writes text at the specified x and y coordinates 
5493.                     $canvas->text($x, $y, $text, $font, 75, array(0, 0, 0), 0, 'B');       
5494.                 };
5496.                 // Add the callback function to each page
5497.                 for ($i = 0; $i < $pageCount; $i++) {        
5498.                     $canvas->page_script($callback);        
5499.                 }
5500.             }
5501.             
5502.             // Page number and total page count Start
5504.             // Define the callback function to add the page number and total page count
5505.             $callback2 = function ($pageNumber) use ($pageCount, $canvas) {
5506.                 // Set text opacity             
5507.                 $canvas->set_opacity(0.9, 'Multiply');
5509.                 // Set the text and position for page number and total page count
5510.                 $text = 'Page ' . $pageNumber . ' of ' . $pageCount;
5511.                 $x = 530; // X-coordinate position
5512.                 $y = 813; // Y-coordinate position
5513.             
5514.                 // Add the page number and total page count to the current page
5515.                 $canvas->text($x, $y, $text, null, 10);
5516.             };
5517.         
5518.             // Add the callback function to each page
5519.             for ($i = 0; $i < $pageCount; $i++) {              
5520.                 $canvas->page_script($callback2);        
5521.             }
5523.             // Output the generated PDF to Browser (force download)
5524.             $dompdf->stream("Invoice.pdf", [
5525.                 "Attachment" => false
5526.             ]);
5528.             exit(0);
5529.             
5531.         }
5532.   
5533.     
5534.     }
5538.     private function imageToBase64($path) {
5539.         $path = $path;
5540.         $type = pathinfo($path, PATHINFO_EXTENSION);
5541.         $data = file_get_contents($path);
5542.         $base64 = 'data:image/' . $type . ';base64,' . base64_encode($data);
5543.         return $base64;
5544.     }
5546.     private function getInvoicePeriod(\DateTime $date, array $invoicePeriods): ?array
5547.     {
5548.         foreach ($invoicePeriods as $period) {
5549.             if ($date->format('j') >= $period['start'] && $date->format('j') <= $period['end']) {
5550.                 return $period;
5551.             }
5552.         }
5554.         return null;
5555.     }
5557. }