src/Controller/BackOffice/Accounting/Report/CIPVReportController.php line 166

Open in your IDE?
  1. <?php
  3. namespace App\Controller\BackOffice\Accounting\Report;
  4. use App\Controller\BaseController;
  5. use App\COREapi\CoreApi;
  6. use App\COREapi\Factory\ReportQueryBuilder;
  7. use App\Entity\QBInvoice;
  8. use App\Entity\Quote;
  9. use App\Entity\QuoteItem;
  10. use App\Entity\User;
  11. use App\ExportExcel\PhpSpreadsheet\ExportExcelBase;
  12. use App\Form\Accounting\Report\CIPVSearchType;
  13. use App\Repository\QBInvoiceRepository;
  14. use Symfony\Component\Form\FormErrorIterator;
  15. use Symfony\Component\HttpFoundation\Request;
  16. use Symfony\Component\HttpFoundation\Response;
  17. use Symfony\Component\Validator\ConstraintViolation;
  18. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Security;
  19. use Symfony\Component\Routing\Annotation\Route;
  20. use Sensio\Bundle\FrameworkExtraBundle\Configuration\IsGranted;
  21. /**
  22.  * @Route("/backoffice/accounting/reports/cipv")
  23.  * @Security("is_granted('ROLE_ACCOUNTING_ALL')")
  24.  */
  25. class CIPVReportController extends BaseController
  26. {
  27.     /**
  28.      * @Route("/", name="accounting_reports_cipv_index", methods={"GET","POST"})
  29.      */
  30.     public function index(Request $request): Response
  31.     {
  32.         $form = $this->createForm(CIPVSearchType::class);
  33.         $form->handleRequest($request);
  35.         $params['form'] = $form->createView();
  37.         //Parameters for default view
  38.         $params['excelSearchPath'] = "";
  39.         $params['tableSearchBy'] = "";
  40.         $params['parentMenu'] = 'Accounting Reports';
  41.         $params['viewTitle'] = 'CIPV Report';
  42.         $params['viewPluralTitle'] = 'CIPV Report';
  43.         $params['roleCreate'] = '';
  44.         $params['routeDataTable'] = 'accounting_reports_cipv_table';
  45.         $params['routeExcelReport'] = 'accounting_reports_cipv_excel_report';
  46.         $params['routeNew'] = '';
  48.         //        $params['tableHeader'] = array("Amount", "Client Name", "Agent", "Supplier City", "Supplier",
  49. //            "Check-In","Check-Out","Confirmation #","Invoice #", "Agency",
  50. //            "Pending Comm...","Balance Due to...","Amount Due From client less Comm","Quote #");
  52. //        $params['tableColumnsDef'] = array("total", "clientFullName","agentName","supplierCity","supplierName",
  53. //            "checkIn","checkOut","confirmationNumber", "invoiceNumber", "customerAccountName",
  54. //            "pendingCommFromSupp",  "balanceDueToSuppUSD","amountDueFromClientLessComm","quoteNumber","action");
  56.         $params['tableHeader'] = array("Name", "OLG Agent",
  57.             "Supplier City", "Supplier",
  58.             "Check-In","Check-Out",
  59.             "Confirmation #","Invoice #", "Agency", "Booking Status","Invoice Status","Canc. Policy Penalty Date","Canc. Policy");
  61.         $params['tableColumnsDef'] = array("clientFullName","agentName","supplierCity","supplierName",
  62.             "checkIn","checkOut","confirmationNumber", "invoiceNumber", "customerAccountName", 'reservationStatus', 'accountingStatus','cancellationPolicyPenaltyDate','cancellationPolicy' ,"action");
  64. //        $params['tableFooter'] = array('<th></th>', '<th  colspan="11"></th>', '<th></th>','<th></th>','<th></th>');
  66.         $params['totalRows'] = 30;
  67.         $params['orderByColumn'] = 4;
  68.         $params['orderByColumnD'] = 'desc';
  70.         try {
  71.             if ($form->isSubmitted()) {
  72.                 if (!$form->isValid()) {
  73.                     /**
  74.                      * @var FormErrorIterator $formErrors
  75.                      * @var ConstraintViolation $cause
  76.                      */
  77.                     $formErrors = $form->getErrors(true);
  78.                     $errors = $formErrors->getChildren();
  79.                     $cause = $errors->getCause();
  80.                     throw new \Exception("Form is not valid. " . $errors->getMessage() . " " . $cause->getPropertyPath() . " " . $cause->getInvalidValue());
  81.                 }
  82.                 $search = $request->request->all();
  84.                 if ($search && key_exists('cipv_search', $search)) {
  85.                     unset($search['cipv_search']['_token']);
  86.                     $search = $this->removeNullElemslOnTheArrayToSearchOnDoctrine($search);
  87.                     $params = array_merge($params, $search);
  88.                     $params['excelSearchPath'] = $this->excelSearchPath($search['cipv_search']);
  89.                     $params['tableSearchBy'] = $search['cipv_search'];
  90.                 } else {
  91.                     unset($search);
  92.                 }
  93.             }
  94.         } catch (\Exception $e) {
  95.             $request->getSession()->getFlashBag()->add('error', $e->getMessage());
  96.         }
  97. //        dd($params);
  98.         return $this->render('backOffice/accounting/report/CIPV/index.html.twig', $params);
  99.     }
  101.     /**
  102.      * TABLE AJAX GENERATOR
  103.      * @Route("/list/table/", name="accounting_reports_cipv_table",methods={"GET","POST"})
  104.      * @param Request $request
  105.      * @param \Symfony\Component\Asset\Packages $assetsManager
  106.      * @param QBInvoiceRepository $qbInvoiceRepository
  107.      * @param CoreApi $coreApi
  108.      * @return Response
  109.      * @Security("is_granted('IS_AUTHENTICATED_FULLY')")
  110.      */
  111.     public function tableIndexAction(Request $request, \Symfony\Component\Asset\Packages $assetsManager, QBInvoiceRepository $qbInvoiceRepository,CoreApi $coreApi)
  112.     {
  113.         $result = $this->getDataTable($request, $assetsManager, $qbInvoiceRepository,true,$coreApi);
  114.         return new Response(json_encode($result), Response::HTTP_OK, ['content-type' => 'application/json']);
  115.     }
  117.     /**
  118.      * Excel Report
  119.      * @Route("/report/excel", name="accounting_reports_cipv_excel_report", methods={"GET"})
  120.      */
  121.     public function excelReportAction(Request $request, \Symfony\Component\Asset\Packages $assetsManager, QBInvoiceRepository $qbInvoiceRepository,CoreApi $coreApi)
  122.     {
  123.         try {
  124.             $logo = $this->getParameter('ovn_logo_directory') . "/overseas-xpress-logo-scondary.png";
  126.             //Get report data
  127.             $reportInfo = $this->getDataTable($request, $assetsManager, $qbInvoiceRepository, false, $coreApi);
  129.             //reorder the date to match the columns
  130.             $resortedInfo = [];
  131.             $orderedReportColumns = array("clientFullName","agentName","supplierCity","supplierName",
  132.                 "checkIn","checkOut","confirmationNumber", "invoiceNumber", "customerAccountName", 'reservationStatus', 'accountingStatus','cancellationPolicyPenaltyDate','cancellationPolicy');
  133.             foreach($reportInfo['data'] as $reportRow){
  134.                 $orderedRow = array();
  135.                 foreach($orderedReportColumns as $nextColumn){
  136.                     $orderedRow[] = $reportRow[$nextColumn];
  137.                 }
  138.                 $resortedInfo[] = $orderedRow;
  139.             }
  140.             $reportInfo['data'] = $resortedInfo;
  142.             $headerTable=array("Name", "OLG Agent",
  143.                 "Supplier City", "Supplier",
  144.                 "Check-In","Check-Out",
  145.                 "Confirmation #","Invoice #", "Agency", "Booking Status","Invoice Status","Canc. Policy Penalty Date","Canc. Policy");
  146.             $reportInfo = array_merge($reportInfo,['headerTable' => $headerTable]);
  147.             $reportName = "CIPV Report";
  148.             $today = new \DateTime('now');
  149.             $todayStr=$today->format('Y-M-d');
  150.             $filename = $reportName.' '.$todayStr. ".xlsx";
  151.             $spreadsheet = new ExportExcelBase(
  152.                 reportInfo: $reportInfo,
  153.                 reportName: $filename,
  154.                 logo: $logo,
  155.                 subject: $reportName,
  156.                 category: 'Accounting Report',
  157.                 description: 'Accounting Report '.$reportName
  158.             );
  159.             return $spreadsheet->create();
  160.         } catch (\Exception $e) {
  161.             //TODO HOW TO HANDLE THIS??
  162.             exit(0);
  163.         }
  164.     }
  166.     private function getDataTable(Request $request, \Symfony\Component\Asset\Packages $assetsManager, QBInvoiceRepository $qbInvoiceRepository, $isView = true,CoreApi $coreApi)
  167.     {
  168.         $countOfSkippedItems = 0;
  169.         $offset = $request->get('start');
  170.         $limit = $request->get('length');
  172.         //Default sort: Here add the columns
  173.         $sort = array("createdAt" => "desc");
  174.         $params=array();
  176.         //Search Fields: Add here all the fields to do the SQL search...
  177. //        $params['supplierCity'] = $request->get('supplierCity');
  178. //        $params['supplierName'] = $request->get('supplierName');
  180.         $params['confirmationNumber'] = $request->get('confirmationNumber');
  182.         //Range Types. Ex. "06/18/2021 - 06/23/2021"
  183.         $params['checkIn'] = $request->get('checkIn');
  184.         $params['checkOut'] = $request->get('checkOut');
  185.         $params['clientFullName'] = $request->get('clientFullName');
  186.         $params['accountingStatus'] = $request->get('accountingStatus');
  187.         $params['reservationStatus'] = $request->get('reservationStatus');
  189.         //Search Fields: Add here all the fields to do the SQL search...
  190.         $paramsInvoice['invoiceNumber'] = $request->get('invoiceNumber');
  191.         $paramsInvoice['isVoid'] = 0;
  193.         //Search Fields: Add here all the fields to do the SQL search...
  194.         $paramsUser['agentName'] = $request->get('agentName');
  195.         //End Search Fields
  197.         //Remove the null elems
  198.         $searchBy = $this->removeNullElemslOnTheArrayToSearchOnDoctrine($params);
  199.         $dateRanges = ['checkIn' => 0, 'checkOut' => 0];
  200.         $em = $this->getDoctrine()->getManager();
  201. //----------------------------------------------------------------------------------------------------------------------
  202.         //Search by Invoice Number
  203.         $searchByInvoice = $this->removeNullElemslOnTheArrayToSearchOnDoctrine($paramsInvoice);
  204.         $rowsQBInvoice = null;
  205.         if ($searchByInvoice) {
  206.             //Do the search first by the invoice
  207.             $reportQueryBuilderInvoice = new ReportQueryBuilder($em, QBInvoice::class);
  208.             $different = null;
  209.             $like = array('invoiceNumber' => 0);
  210.             $extraSqlInvoice = null;
  211.             $rowsInvoiceResponse = $reportQueryBuilderInvoice->findByCriteria(
  212.                 $searchByInvoice, array(), null, null, true, $like, $different,null,null,$extraSqlInvoice);
  213.             foreach ($rowsInvoiceResponse as $invoice) {
  214.                 $rowsQBInvoice[] = $invoice->getId();
  215.             }
  216.         }
  217. //----------------------------------------------------------------------------------------------------------------------
  218.         //Search by Agent Name
  219.         $searchByAgent = $this->removeNullElemslOnTheArrayToSearchOnDoctrine($paramsUser);
  220.         $rowsAgent = null;
  221.         if ($searchByAgent) {
  222.             $searchByAgent['id']=$searchByAgent['agentName'];
  223.             unset($searchByAgent['agentName']);
  225.             //Do the search
  226.             $reportQueryBuilderAgent = new ReportQueryBuilder($em, User::class);
  227.             $different = null;
  228.             $like = array();
  229.             $rowsAgentResponse = $reportQueryBuilderAgent->findByCriteria(
  230.                 $searchByAgent, array(), null, null, true,
  231.                 $like, $different,null,null);
  232.             foreach ($rowsAgentResponse as $user) {
  233.                 $rowsAgent[] = $user->getId();
  234.             }
  235.         }
  236. //----------------------------------------------------------------------------------------------------------------------
  237.         $different = null;
  238.         $like = array('confirmationNumber'=>0);
  239.         $andIn = [];
  240.         $extraSQL="";
  242.         if(key_exists('clientFullName',$searchBy)){
  243.             $searchBy['clientFullName']=strtolower($searchBy['clientFullName']);
  244.             $extraSQL ="(lower(n.clientName) like '%".$searchBy['clientFullName']."%' or lower(n.clientLastName) like '%".$searchBy['clientFullName']."%')";
  245.             unset($searchBy['clientFullName']);
  246.         }
  248.         if(key_exists('accountingStatus',$searchBy)){
  249.             $searchBy['accountingStatus']=strtolower($searchBy['accountingStatus']);
  250.         }
  251.         if(key_exists('reservationStatus',$searchBy)){
  252.             $searchBy['reservationStatus']=strtolower($searchBy['reservationStatus']);
  253.         }
  255.         if ($rowsQBInvoice) {
  256.             $invoiceList = implode(",",$rowsQBInvoice);
  257.             $searchBy['qbInvoice'] = $invoiceList;
  258.             $andIn = array_merge($andIn,array('qbInvoice' => $invoiceList));
  259.         }
  260.         $rowsQuote=null;
  261.         if ($rowsAgent) {
  262.             $searchByQuote['agent'] = implode(", ", $rowsAgent);
  263.             //Do the search
  264.             $reportQueryBuilderQuote = new ReportQueryBuilder($em, Quote::class);
  265.             $different = null;
  266.             $like = array();
  267.             $rowsQuoteResponse = $reportQueryBuilderQuote->findByCriteria(
  268.                 $searchByQuote, array(), null, null, true,
  269.                 $like, $different);
  270.             foreach ($rowsQuoteResponse as $quote) {
  271.                 $rowsQuote[] = $quote->getId();
  272.             }
  273.         }
  274.         if ($rowsQuote) {
  275.             $quoteList = implode(",",$rowsQuote);
  276.             $searchBy['quote'] = $quoteList;
  277.             $andIn = array_merge($andIn,array('quote' => $quoteList));
  278.         }
  280.         //Do the search on QuoteItem
  281.         $reportQueryBuilder = new ReportQueryBuilder($em, QuoteItem::class);
  283.         //Get total
  284. //        $totalArray = $reportQueryBuilder->findByCriteriaTotalByColumns(array('retailTotal'),$searchBy, $like, $different, $andIn, $dateRanges,$extraSQL);
  285. //        $footerTotalQCAmount = $totalArray['retailTotal'];
  286. //        $footerTotalAmountDueFromClientLessComm =0; //TODO: CHECK WHERE THIS DATA COMES
  288. //        if($isView){
  289. //            $footerTotalQCAmount = '$'.number_format($totalArray['retailTotal'], 2, ',', '.');
  290. //            $footerTotalAmountDueFromClientLessComm ='$'.number_format($footerTotalAmountDueFromClientLessComm, 2, ',', '.');
  291. //        }
  292.         $recordsTotal = $reportQueryBuilder->findByCriteriaCount($searchBy, $like, $different, $andIn, $dateRanges,$extraSQL);
  294. //        if ($request->get('order')) {
  295.         //This corresponds with the columns on the view (header)
  296. //            $column =
  297. //                array("retailTotal", "clientName","agentName","supplierCity","supplierName",
  298. //                "checkIn","checkOut","confirmationNumber", "invoiceNumber", "customerAccountName",
  299. //                "pendingCommFromSupp",  "balanceDueToSuppUSD","amountDueFromClientLessComm","quoteNumber");
  300. //
  301. //            $search = $column[$request->get('order')[0]["column"]];
  302. //            $order = strtoupper($request->get('order')[0]["dir"]);
  303. //            $sort = array($search => $order);
  304. //        }
  305.         $inners=null;
  306.         if ($request->get('order')) {
  307.             //This corresponds with the columns on the view (header)
  308.             $column = array("clientFullName","agentName","supplierCity","supplierName",
  309.                 "checkIn","checkOut","confirmationNumber", "invoiceNumber", "customerAccountName", "reservationStatus", 'accountingStatus','cancellationPolicyPenaltyDate','cancellationPolicy');
  311.             $search = $column[$request->get('order')[0]["column"]];//index of column
  312.             $order = strtoupper($request->get('order')[0]["dir"]);//asc or desc
  313.             $sort = [];
  314.             if(in_array($search,["clientFullName","agentName","invoiceNumber", "customerAccountName", "reservationStatus", "accountingStatus"])){
  315. //            if(in_array($search,["clientFullName","agentName","invoiceNumber", "customerAccountName", "reservationStatus", "accountingStatus","cancellationPolicyPenaltyDate","cancellationPolicy"])){
  316.                 if ($search == "clientFullName") {
  317.                     $sort = array("clientName" => $order);
  318.                 }
  319.                 if ($search == "agentName") {
  320.                     $alias = 'j';
  321.                     if ($inners) {
  322.                         $alias .= count($inners);
  323.                     }
  324.                     $innerSingle["type"]='leftJoin';
  325.                     $innerSingle["table"] = "quote";
  326.                     $innerSingle["condition"] = $alias . ".id=n.quoteId'";
  327.                     $inners[] = $innerSingle;
  329.                     $alias2 = $alias.count($inners);
  330.                     $innerSingle["type"]='leftJoin';
  331.                     $innerSingle["table"] = $alias.".agent";
  332.                     $innerSingle["noAddAlias"] = true;
  333.                     $innerSingle["condition"] = $alias2 . ".id=j.agentId'";
  334.                     $innerSingle["orderBy"]['field'] = $alias2 . '.firstName';
  335.                     $innerSingle["orderBy"]['order'] = $order;
  336.                     $inners[] = $innerSingle;
  337.                 }
  339.                 if ($search == "accountingStatus") {
  340.                     $sort[] = array("accountingStatus" => $order);
  341.                 }
  343.                 if ($search == "reservationStatus") {
  344.                     $sort[] = array("reservationStatus" => $order);
  345.                 }
  346.                 if ($search == "invoiceNumber") {
  347.                     $alias = 'j';
  348.                     if ($inners) {
  349.                         $alias .= count($inners);
  350.                     }
  351.                     $innerSingle["type"]='leftJoin';
  352.                     $innerSingle["table"] = "qbInvoice";
  353.                     $innerSingle["condition"] = $alias . ".id=n.qbInvoice'";
  354.                     $innerSingle["orderBy"]['field'] = $alias . '.invoiceNumber';
  355.                     $innerSingle["orderBy"]['order'] = $order;
  356.                     $inners[] = $innerSingle;
  357.                 }
  358.                 if ($search == "customerAccountName") {
  359.                     $alias = 'j';
  360.                     if ($inners) {
  361.                         $alias .= count($inners);
  362.                     }
  363.                     $innerSingle["type"]='leftJoin';
  364.                     $innerSingle["table"] = "quote";
  365.                     $innerSingle["condition"] = $alias . ".id=n.quoteId'";
  366.                     $inners[] = $innerSingle;
  368.                     $alias2 = $alias.count($inners);
  369.                     $innerSingle["type"]='leftJoin';
  370.                     $innerSingle["table"] = $alias.".customerAccount";
  371.                     $innerSingle["noAddAlias"] = true;
  372.                     $innerSingle["condition"] = $alias2 . ".id=j.customerAccountId'";
  373.                     $innerSingle["orderBy"]['field'] = $alias2 . '.name';
  374.                     $innerSingle["orderBy"]['order'] = $order;
  375.                     $inners[] = $innerSingle;
  376.                 }
  377.             }
  378.             else{
  379.                 //Order default
  380.                 $sort = array($search => $order);
  381.             }
  382.         }
  383.         $data = array();
  385.         // The query to search by specifics fields. $limit, $offset
  386.         if($rows = $reportQueryBuilder->findByCriteria(
  387.             $searchBy, $sort, null, null, true, $like, $different, $andIn, $dateRanges,$extraSQL,$inners)){
  388.             $suppliers=$coreApi->getActivitySupplierList();
  389.             $hotels=$coreApi->getHotelList();
  391.             $penaltyStartDate = $penaltyEndDate = null;
  392.             if($request->get('penaltyDateRange') !== null && strlen($request->get('penaltyDateRange')>0)){
  393.                 $dates = explode('-', $request->get('penaltyDateRange'));
  394.                 $penaltyStartDate = \DateTime::createFromFormat('m/d/Y H:i:s', trim($dates[0])." 00:00:00");
  395.                 $penaltyEndDate = \DateTime::createFromFormat('m/d/Y H:i:s', trim($dates[1])." 23:59:59");
  396.             }
  398.             /**
  399.              * @var $quoteItem QuoteItem
  400.              */
  401.             foreach ($rows as $key => $quoteItem) {
  402.                 //error_log(print_r($key,true).PHP_EOL,3, '/var/www/app/var/log/brian.log');
  404.                 $supplier=$this->getSupplierInfo($suppliers, $hotels, $quoteItem);
  405.                 $values = array();
  407.                 $values["cancellationPolicyPenaltyDate"] = "";
  408.                 $values["cancellationPolicy"] = "";
  409.                 try {
  410.                     if ($cancellationPolicy = $quoteItem->getCancellationPolicy()) {
  411.                         if (!array_key_exists("penaltyDate", $cancellationPolicy)) {
  412.                             $cancellationPolicy = reset($cancellationPolicy);
  413.                         }
  414.                         if(array_key_exists("penaltyDate", $cancellationPolicy) && $cancellationPolicy['penaltyDate'] == null ){
  415.                             continue;
  416.                         }
  417.                         $values["cancellationPolicy"] = $quoteItem->makeCancellationPolicyLabel($cancellationPolicy);
  418.                         if (is_array($cancellationPolicy) && key_exists('penaltyDate', $cancellationPolicy)) {
  419.                             $penaltyDate = $cancellationPolicy['penaltyDate'];
  420.                             if (is_string($cancellationPolicy['penaltyDate'])) {
  421.                                 $penaltyDate = new \DateTime($cancellationPolicy['penaltyDate']);
  422.                             }
  423.                             if($penaltyDate == null){
  424.                                 continue;
  425.                             }
  426.                             if ($penaltyStartDate != null && ($penaltyDate < $penaltyStartDate || $penaltyDate > $penaltyEndDate)) {
  427.                                 continue;
  428.                             }
  429.                             $values["cancellationPolicyPenaltyDate"] = $penaltyDate->format("Y-m-d");
  430.                         }
  431.                     } else if ($quoteItem->getCancellationPolicy() == null && $penaltyStartDate != null) {
  432.                         continue;
  433.                     }
  434.                 } catch (\Exception $e) {
  435.                     //error_log($e->getMessage().PHP_EOL,3, '/var/www/app/var/log/CIPV_error.log');
  436.                 }
  438. //            $values["total"] = $quoteItem->getRetailTotal();
  439.                 $values["clientFullName"] = $quoteItem->getClientFullName();
  440.                 $values["agentName"] = $quoteItem->getQuote()->getCreatedBy()?$quoteItem->getQuote()->getCreatedBy()->getName():"";
  442.                 $values["supplierCity"] =  $supplier["cityName"];
  443.                 $values["supplierName"] =  $supplier["name"];
  445.                 $values["checkIn"] = $quoteItem->getCheckIn() ? $quoteItem->getCheckIn()->format("Y-m-d") : "";
  446.                 $values["checkOut"] = $quoteItem->getCheckOut() ? $quoteItem->getCheckOut()->format("Y-m-d") : "";
  447.                 $values["confirmationNumber"] = $quoteItem->getConfirmationNumber();
  448.                 $values["invoiceNumber"] = $quoteItem->getQbInvoice()?$quoteItem->getQbInvoice()->getInvoiceNumber():"";
  449.                 $values["customerAccountName"] = $quoteItem->getQuote()->getCustomerAccount()?$quoteItem->getQuote()->getCustomerAccount()->getName():"";
  450.                 $values["reservationStatus"] = $quoteItem->getReservationStatus();
  451.                 $values["accountingStatus"] = $quoteItem->getAccountingStatus();
  454. //            $values["pendingCommFromSupp"] = 0;
  455. //            $values["balanceDueToSuppUSD"] = 0;
  456. //            $values["amountDueFromClientLessComm"] = 0;
  458. //            $values["quoteNumber"] = $quoteItem->getQuote()->getQuoteNumber();
  460.                 if($isView){
  461. //                $values["total"] = '$'.number_format($values["total"], 2, ',', '.');
  462. //                $values["pendingCommFromSupp"] = '$'.number_format($values["pendingCommFromSupp"], 2, ',', '.');
  463. //                $values["balanceDueToSuppUSD"] = '$'.number_format($values["balanceDueToSuppUSD"], 2, ',', '.');
  464. //                $values["amountDueFromClientLessComm"] = '$'.number_format($values["amountDueFromClientLessComm"], 2, ',', '.');
  466.                     $url = $this->generateUrl('quality_control_index', array('quoteItemId' => $quoteItem->getId()));
  467.                     $values["action"] = '<a href="' . $url . '" class="text-blue-color-custom" title="Go to QC"><i class="fas fa-external-link-alt"></i></a>';
  468.                 }
  469.                 $data[] = $values;
  470.             }
  471.         }
  472.         $recordsTotal = count($data);
  473.         $data = array_slice($data,$offset,$limit);
  475.         return array(
  476.             "recordsTotal" => $recordsTotal,
  477.             "recordsFiltered" => $recordsTotal,
  478.             "data" => $data,
  479. //            "footerTotalQCAmount" => $footerTotalQCAmount,
  480. //            "footerTotalAmountDueFromClientLessComm" => $footerTotalAmountDueFromClientLessComm
  481.         );
  482.     }
  483. }