src/Controller/Parcels/TransactionController.php line 54

Open in your IDE?
  1. <?php
  2. /**
  3. * Created by PhpStorm.
  4. * User: parcel
  5. * Date: 10/25/18
  6. * Time: 7:58 AM
  7. */
  9. namespace App\Controller\Parcels;
  12. use App\Entity\DailyAccount;
  13. use App\Entity\Parcel;
  14. use App\Entity\Station;
  15. use App\Entity\Transaction;
  16. use App\Entity\WayBill;
  17. use DateTime;
  18. use JMS\Serializer\SerializationContext;
  19. use JMS\Serializer\SerializerBuilder;
  20. use PhpOffice\PhpSpreadsheet\Exception;
  21. use PhpOffice\PhpSpreadsheet\Style\Fill;
  22. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  23. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  24. use Psr\Log\LoggerInterface;
  25. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  26. use Symfony\Component\Config\Resource\ResourceInterface;
  27. use Symfony\Component\HttpFoundation\File\File;
  28. use Symfony\Component\HttpFoundation\JsonResponse;
  29. use Symfony\Component\HttpFoundation\Request;
  30. use Symfony\Component\HttpFoundation\Response;
  31. use Symfony\Component\HttpFoundation\ResponseHeaderBag;
  32. use Symfony\Component\Routing\Annotation\Route;
  33. use Symfony\Component\Serializer\Encoder\CsvEncoder;
  34. use Symfony\Component\Serializer\Normalizer\ObjectNormalizer;
  35. use Symfony\Component\Serializer\Serializer;
  37. class TransactionController extends AbstractController {
  40. /**
  41. * @Route("/transactions", name="bos_all_transactions")
  42. */
  43. public function transactionAction() {
  46. // replace this example code with whatever you need
  47. return $this->render('parcels/transactions.html.twig',[]);
  48. }
  51. /**
  52. * @Route("/transactions/transaction-list",methods={"POST"}, name="bos_get_all_transactions")
  53. */
  54. public function dailyTransactions(Request $request) {
  55. $em = $this->getDoctrine()->getManager();
  57. $context = new SerializationContext();
  58. $context->setSerializeNull(true);
  60. $fromDate = $request->request->get("from_date");
  61. $toDate = $request->request->get("to_date");
  63. // dump($fromDate);
  65. $fDate = null;
  66. $date = new \DateTime('+1 day');
  67. $tDate = null;
  71. $fromDate = empty($fromDate) ? $fDate: $fromDate;
  72. $toDate = empty($toDate) ? $tDate: $toDate;
  74. // dump($fromDate);
  75. // dump($toDate); die;
  77. $serializer = SerializerBuilder::create()->build();
  79. $page = $request->request->get('page') > 1 ? $request->request->get('page'): 1;
  80. $rows = $request->request->get('rows') > 1 ? $request->request->get('rows'): 20;
  82. $offset = ($page - 1)*$rows;
  84. $filterRules = $request->request->get('filterRules');
  88. if($fromDate && $toDate){
  89. $filterRules = json_decode($filterRules, true);
  91. $dates = [
  92. 'field'=> 'd.account_date',
  93. 'op'=> 'between',
  94. 'value' => [
  95. 'from' => str_replace(" ","", $fromDate),
  96. 'to' => str_replace(" ","", $toDate)
  97. ],
  98. ];
  99. array_push($filterRules, $dates);
  101. $filterRules = json_encode($filterRules);
  102. }
  105. // $endDate = [
  106. // 'field' => 't.createdAt',
  107. // 'op' => 'equal',
  108. // 'value' => $toDate
  109. // ];
  114. // dump(json_decode($filterRules, false)); die;
  115. // array_push($filterRules, $endDate);
  117. // [{"field":"w.fromStation","op":"equal","value":1},
  118. // {"field":"w.toStation","op":"equal","value":14},
  119. // {"from_date":"2019-08-01","to_date":"2019-08-24"}]
  122. // dump(json_encode($filterRules)); die;
  126. $parcels = $em->getRepository(Transaction::class)->getAllTransactions($filterRules,$offset,$rows);
  130. // dump($parcels);die;
  132. /** @var integer $total */
  133. $total = $em->getRepository(Transaction::class)->findBosParcelsTotalTransactions($filterRules);
  134. // dump($total);
  135. // $transactionDetails = $em->getRepository(Transaction::class)->totals($filterRules);
  137. $transaction = new Transaction();
  138. $dailyAccount = new DailyAccount();
  139. $dailyAccount->setAccountDate(NULL);
  140. // $transaction->setAmount(number_format($transactionDetails[0]['amount']));
  141. // $transaction->setTaxAmount(number_format($transactionDetails[0]['tax_amount']));
  142. // $transaction->setExpenses(number_format($transactionDetails[0]['expenses']));
  143. // $transaction->setBalance(number_format($transactionDetails[0]['balance']));
  144. $wayBill = new WayBill();
  145. $station = new Station();
  146. $station->setStationName("TOTAL");
  147. $wayBill->setToStation($station);
  148. // $wayBill->setPercelCount(number_format($transactionDetails[0]['parcel_count']));
  149. $transaction->setDailyAccount($dailyAccount);
  150. $wayBill->setFromStation(new Station());
  151. $transaction->setWayBill($wayBill);
  152. // array_push($parcels, $transaction);
  154. // dump($total);
  156. $footerTotals = array();
  157. array_push($footerTotals, $transaction);
  158. $data = [
  159. 'total' => $total[0]['count_t'],
  160. 'rows' => $parcels,
  161. // 'footer' => $footerTotals
  162. ];
  164. $data = $serializer->serialize($data,'json', $context);
  166. return new Response($data, Response::HTTP_OK);
  167. }
  170. /**
  171. * @Route("/transactions/transaction-list/excel/{fromDate}/{toDate}", name="bos_get_all_transactions_excel")
  172. */
  173. public function durationExcel(Request $request, $fromDate, $toDate, LoggerInterface $logger): Response
  174. {
  176. @ini_set("memory_limit",-1);
  178. $em = $this->getDoctrine()->getManager();
  180. $context = new SerializationContext();
  181. $context->setSerializeNull(true);
  185. // dump($request);die;
  186. // $fromDate = $request->request->get("fromDate");
  187. // $toDate = $request->request->get("toDate");
  189. $fDate = null;
  190. $date = new \DateTime('+1 day');
  191. $tDate = null;
  193. // dump($fromDate);
  194. // dump($toDate); die;
  196. $fromDate = $fromDate == 0 ? $fDate: $fromDate;
  197. $toDate = $toDate == 0 ? $tDate: $toDate;
  201. $serializer = SerializerBuilder::create()->build();
  203. // $page = $request->request->get('page') > 1 ? $request->request->get('page'): 1;
  204. // $rows = $request->request->get('rows') > 1 ? $request->request->get('rows'): 20;
  206. // $offset = ($page - 1)*$rows;
  208. $filterRules = $request->request->get('filterRules');
  210. // dump($request->request); die;
  212. if(!$filterRules) {
  213. $filterRules = "[]";
  214. }
  219. if($fromDate && $toDate){
  220. $filterRules = json_decode($filterRules, true);
  222. $dates = [
  223. 'field'=> 'd.accountDate',
  224. 'op'=> 'between',
  225. 'value' => [
  226. 'from' => str_replace(" ","", $fromDate),
  227. 'to' => str_replace(" ","", $toDate)
  228. ],
  229. ];
  230. array_push($filterRules, $dates);
  234. $filterRules = json_encode($filterRules);
  235. }
  239. // dump($filterRules);
  241. $parcels = $em->getRepository(Transaction::class)->getDatedTransactions($filterRules);
  245. $logger->debug("creating beginning file awesome vv");
  247. // $phpExcelObject = $this->get('phpexcel')->createPHPExcelObject();
  248. $phpExcelObject = new Spreadsheet();
  250. // $phpExcelObject->getProperties()->setCategory($this->getUser())
  251. // ->setLastModifiedBy($this->getUser())
  252. // ->setTitle("Transactions report")
  253. // ->setSubject("Transactions report")
  254. // ->setDescription("Transactions report")
  255. // ->setKeywords("Transactions report");
  257. $columns = str_split('ABCDEFGHIJKLMNOPUVWXYZ');
  259. $logger->debug("creating file awesome vv");
  260. // dump("creating a file"); die;
  262. $cancelStyleArray = [
  263. 'fill' => [
  264. 'fillType' => Fill::FILL_SOLID,
  265. 'color' => [
  266. 'rgb' => 'FF0000'
  267. ]
  268. ],
  269. 'font' => [
  270. 'bold' => true,
  271. 'color' => ['rgb' => 'FFFFFFFF'],
  272. 'name' => 'Calibri'
  273. ]
  275. ];
  277. $headerStyleArray = [
  278. 'font' => [
  279. 'bold' => true,
  280. 'color' => ['rgb' => '000000'],
  281. 'size' => 12,
  282. 'name' => 'Cambria'
  283. ]
  285. ];
  288. $phpExcelObject->getActiveSheet()
  289. ->setCellValue('A1', '#')
  290. ->setCellValue('B1', 'WAYBILL')
  291. ->setCellValue('C1', 'TIME')
  292. ->setCellValue('D1', 'FROM')
  293. ->setCellValue('E1', 'TO')
  294. ->setCellValue('F1', 'SENDER')
  295. ->setCellValue('G1', 'SENDER PHONE')
  296. ->setCellValue('H1', 'RECEIVER')
  297. ->setCellValue('I1', 'RECEIVER PHONE')
  298. ->setCellValue('J1', 'DESCRIPTION')
  299. ->setCellValue('K1', 'MAINTENANCE')
  300. ->setCellValue('L1', 'AMOUNT')
  301. ->setCellValue('M1', 'TAX')
  302. ->setCellValue('N1', 'CU INVOICE NUMBER')
  303. ->setCellValue('O1', 'MPESA')
  304. ->setCellValue('P1', 'MPESA AMOUNT')
  305. ->setCellValue('Q1', 'CLERK')
  306. ->setCellValue('R1', 'BUYERS PIN')
  307. ->getStyle("A1:R1")
  308. ->applyFromArray($headerStyleArray);
  313. foreach ($parcels as $count => $parcel) {
  315. $index = $count + 2;
  316. /** @var Parcel[] $p */
  317. $p = $em->getRepository(Parcel::class)->findBy([
  318. 'waybill' => $parcel['waybill']
  319. ]);
  321. $description = '';
  322. foreach ($p as $i => $pa){
  323. $description .= $pa->getDescription();
  324. if(count($p) != ($i+1)){
  325. $description .= ',';
  326. }
  327. }
  331. $date = new DateTime($parcel['created_at']);
  332. $date->format('Y-m-d H:i:s');
  334. $parcel['expenses'] = 3;
  336. $pinNumber = $parcel['pin_number'] ?: 'NA';
  340. if($parcel['is_cancelled']){
  341. // $parcel['expenses'] = -3;
  342. // $parcel['amount'] = -$parcel['amount'];
  343. $parcel['expenses'] = 0;
  344. $parcel['amount'] = -0;
  346. $phpExcelObject->getActiveSheet()
  347. ->setCellValue('A'.$index, $index)
  348. ->setCellValue('B'.$index, $parcel['waybill'])
  349. ->setCellValue('C'.$index, $date)
  350. ->setCellValue('D'.$index, $parcel['from_station'])
  351. ->setCellValue('E'.$index, $parcel['to_station'])
  353. ->setCellValue('F'.$index, $parcel['sender_name'])
  354. ->setCellValue('G'.$index, $parcel['sender_phone_number'])
  355. ->setCellValue('H'.$index, $parcel['receiver_name'])
  356. ->setCellValue('I'.$index, $parcel['receiver_phone_number'])
  358. ->setCellValue('J'.$index, $description)
  359. // ->setCellValue('J'.$index, "-")
  360. ->setCellValue('K'.$index, $parcel['expenses'])
  361. ->setCellValue('L'.$index, $parcel['amount'])
  362. ->setCellValue('M'.$index, $parcel['cu_invoice_number']?$parcel['tax_amount']:0)
  363. ->setCellValue('N'.$index, $parcel['cu_invoice_number'])
  364. ->setCellValue('O'.$index, 'NA')
  365. ->setCellValue('P'.$index, $parcel['mpesa_amount'])
  366. ->setCellValue('Q'.$index, strtoupper($parcel['clerk']))
  367. ->setCellValue('R'.$index, $pinNumber)
  368. ->getStyle("A{$index}:R{$index}")
  369. ->applyFromArray($cancelStyleArray);
  374. // $phpExcelObject->getActiveSheet()
  375. // ->getStyle("A{$index}:G{$index}")
  376. // ->applyFromArray($cancelStyleArray);
  378. }else {
  380. $phpExcelObject->getActiveSheet()
  381. ->setCellValue('A'.$index, $index)
  382. ->setCellValue('B'.$index, $parcel['waybill'])
  383. ->setCellValue('C'.$index, $date)
  384. ->setCellValue('D'.$index, $parcel['from_station'])
  385. ->setCellValue('E'.$index, $parcel['to_station'])
  387. ->setCellValue('F'.$index, $parcel['sender_name'])
  388. ->setCellValue('G'.$index, $parcel['sender_phone_number'])
  389. ->setCellValue('H'.$index, $parcel['receiver_name'])
  390. ->setCellValue('I'.$index, $parcel['receiver_phone_number'])
  392. ->setCellValue('J'.$index, $description)
  393. // ->setCellValue('J'.$index, "-")
  394. ->setCellValue('K'.$index, $parcel['expenses'])
  395. ->setCellValue('L'.$index, $parcel['amount'])
  396. ->setCellValue('M'.$index, $parcel['cu_invoice_number']?$parcel['tax_amount']:0)
  397. ->setCellValue('N'.$index, $parcel['cu_invoice_number'])
  398. ->setCellValue('O'.$index, $parcel['transaction_code'])
  399. ->setCellValue('P'.$index, $parcel['mpesa_amount'])
  400. ->setCellValue('Q'.$index, strtoupper($parcel['clerk']))
  401. ->setCellValue('R'.$index, $pinNumber)
  402. ->getStyle("A{$index}:R{$index}")
  403. ->applyFromArray([
  404. 'font' => [
  405. 'bold' => false,
  406. 'color' => ['rgb' => '000000'],
  407. 'name' => 'Calibri'
  408. ],
  409. ]);
  410. }
  414. // dump("Entering data");
  415. }
  418. // $phpExcelObject->getActiveSheet()->setTitle("Transactions");
  419. // $phpExcelObject->setActiveSheetIndex(0)->setTitle('Transactions');
  420. $phpExcelObject->getActiveSheet()->setTitle('Transactions');
  422. /** create the writer
  423. $writer = $this->get('phpexcel')->createWriter($phpExcelObject, 'Excel2007');
  424. // create the response
  425. $response = $this->get('phpexcel')->createStreamedResponse($writer);
  426. // adding headers
  427. $dispositionHeader = $response->headers->makeDisposition(
  428. ResponseHeaderBag::DISPOSITION_ATTACHMENT,
  429. 'awesome.xlsx'
  430. );
  431. $response->headers->set('Content-Type', 'text/vnd.ms-excel; charset=utf-8');
  432. $response->headers->set('Pragma', 'public');
  433. $response->headers->set('Cache-Control', 'maxage=1');
  434. $response->headers->set('Content-Disposition', $dispositionHeader);
  436. // $response = new Response();
  437. // $response->headers->set('Content-type', 'text');
  438. // $response->setContent('awesome.xlsx');
  441. $writer
  442. return $response; */
  443. $logger->debug("saving file awesome vv");
  444. // $writer = $this->get('phpexcel')->createWriter($phpExcelObject,'Excel2007');
  446. $phpExcelObject->getActiveSheet()->setAutoFilter(
  447. $phpExcelObject->getActiveSheet()
  448. ->calculateWorksheetDimension()
  449. );
  451. $writer = new Xlsx($phpExcelObject);
  453. $md5 = md5("{$fromDate}{$toDate}");
  455. $fileName = "transaction_report_{$md5}.xlsx";
  456. try {
  457. $logger->debug("saving file awesome");
  459. $writer->save("reports/{$fileName}");
  460. } catch (Exception $e) {
  461. $logger->debug($e->getMessage());
  462. }
  465. $response = new Response();
  466. $response->headers->set('Content-type', 'text');
  467. $response->setContent($fileName);
  468. // $response->headers->set('Cache-Control', 'private');
  469. // $response->headers->set('Content-length', $attachmentSize);
  470. // $response->headers->set('Content-Disposition', 'attachment; filename="' . $fileName . '";');
  475. return $response;
  478. //
  479. // foreach ($parcels as $index => $parcel) {
  480. //// $row['valdate']->format('d/m/Y');
  481. // $date = $parcel['account_date']->format('d/m/y');
  482. // $waybill = $parcel['waybill'];
  483. //
  484. // dump($index.': '.$date.'-'.$waybill);
  485. // }
  486. //
  487. // die;
  488. $fileName = "report_".rand(1,20).".csv";
  490. $fp = fopen($fileName, 'w');
  491. // $fp = fopen('php://output', 'w');
  494. $s = [
  495. 'n',
  496. 'WAYBILL',
  497. 'DATE',
  498. 'FROM',
  499. 'TO',
  500. 'MAINTENANCE',
  501. 'AMOUNT'
  502. ];
  504. // fputcsv(
  505. // $fp, // The file pointer
  506. // $s, // The fields
  507. // ',' // The delimiter
  508. // );
  510. // foreach ($parcels as $index => $parcel) {
  511. // $date = $parcel['account_date']->format('Y-m-d H:i:s');
  512. //// $stringDate = $date->format('Y-m-d H:i:s');
  513. //
  514. // if($parcel['is_cancelled']){
  515. // $parcel['amount'] = 0;
  516. // }
  517. //
  518. // $s = [
  519. // 'n' => $index,
  520. // 'waybill' => $parcel['waybill'],
  521. // 'date'=> $date,
  522. // 'from'=> $parcel['from_station'],
  523. // 'to'=> $parcel['to_station'],
  524. // 'cost'=> $parcel['expenses'],
  525. // 'amount'=> $parcel['amount']
  526. // ];
  527. // fputcsv(
  528. // $fp, // The file pointer
  529. // $s, // The fields
  530. // ',' // The delimiter
  531. // );
  532. // }
  536. $response = new Response();
  537. $response->headers->set('Content-type', 'text');
  538. $response->setContent($fileName);
  539. // $response->headers->set('Cache-Control', 'private');
  540. // $response->headers->set('Content-length', $attachmentSize);
  541. // $response->headers->set('Content-Disposition', 'attachment; filename="' . $fileName . '";');
  546. return $response;
  547. }
  550. /**
  551. * @Route("/transactions/transaction-list/maintenance/excel/{fromDate}/{toDate}", name="bos_get_all_transactions_maintenance_excel")
  552. */
  553. public function maintenanceExcel(Request $request, $fromDate, $toDate, LoggerInterface $logger){
  555. $em = $this->getDoctrine()->getManager();
  557. $context = new SerializationContext();
  558. $context->setSerializeNull(true);
  562. // dump($request);die;
  563. // $fromDate = $request->request->get("fromDate");
  564. // $toDate = $request->request->get("toDate");
  566. $fDate = null;
  567. $date = new \DateTime('+1 day');
  568. $tDate = null;
  570. // dump($fromDate);
  571. // dump($toDate); die;
  573. $fromDate = $fromDate == 0 ? $fDate: $fromDate;
  574. $toDate = $toDate == 0 ? $tDate: $toDate;
  578. $serializer = SerializerBuilder::create()->build();
  580. // $page = $request->request->get('page') > 1 ? $request->request->get('page'): 1;
  581. // $rows = $request->request->get('rows') > 1 ? $request->request->get('rows'): 20;
  583. // $offset = ($page - 1)*$rows;
  585. $filterRules = $request->request->get('filterRules');
  587. // dump($request->request); die;
  589. if(!$filterRules) {
  590. $filterRules = "[]";
  591. }
  596. if($fromDate && $toDate){
  597. $filterRules = json_decode($filterRules, true);
  599. $dates = [
  600. 'field'=> 'd.accountDate',
  601. 'op'=> 'between',
  602. 'value' => [
  603. 'from' => str_replace(" ","", $fromDate),
  604. 'to' => str_replace(" ","", $toDate)
  605. ],
  606. ];
  607. array_push($filterRules, $dates);
  609. // dump($filterRules); die;
  611. $filterRules = json_encode($filterRules);
  612. }
  617. /** @var Transaction[] $parcels */
  618. $parcels = $em->getRepository(Transaction::class)->getDatedTransactions($filterRules);
  621. $logger->debug("creating beginning file awesome vv");
  623. $phpExcelObject = $this->get('phpexcel')->createPHPExcelObject();
  625. $phpExcelObject->getProperties()->setCategory($this->getUser())
  626. ->setLastModifiedBy($this->getUser())
  627. ->setTitle("Transactions report")
  628. ->setSubject("Transactions report")
  629. ->setDescription("Transactions report")
  630. ->setKeywords("Transactions report");
  632. $columns = str_split('ABCDEFGHIJKLMNOPUVWXYZ');
  634. $logger->debug("creating file awesome vv");
  635. // dump("creating a file"); die;
  637. $cancelStyleArray = [
  638. 'fill' => [
  639. // 'fillType' => \PhpOffice\PhpSpreadsheet\Style\Fill::FILL_GRADIENT_LINEAR,
  640. 'type' => PHPExcel_Style_Fill::FILL_SOLID,
  641. 'color' => [
  642. 'rgb' => 'FF0000'
  643. ]
  644. ],
  645. 'font' => [
  646. 'bold' => true,
  647. 'color' => ['rgb' => 'FFFFFF'],
  648. // 'size' => 12,
  649. 'name' => 'Courier 10 Pitch'
  650. ]
  652. ];
  654. $headerStyleArray = [
  655. 'font' => [
  656. 'bold' => true,
  657. 'color' => ['rgb' => '000000'],
  658. 'size' => 12,
  659. 'name' => 'Bell MT'
  660. ]
  662. ];
  665. $phpExcelObject->setActiveSheetIndex(0)
  666. ->setCellValue('A1', '#')
  667. ->setCellValue('B1', 'TIME')
  668. ->setCellValue('C1', 'WAYBILL')
  669. ->setCellValue('D1', 'FROM')
  670. ->setCellValue('E1', 'TO')
  671. ->setCellValue('F1', 'MAINTENANCE')
  672. ->setCellValue('G1', 'AMOUNT')
  673. ->getStyle("A1:G1")
  674. ->applyFromArray($headerStyleArray);
  679. foreach ($parcels as $count => $parcel) {
  681. $index = $count + 2;
  682. /** @var Parcel[] $p */
  683. $p = $em->getRepository("App:Parcel")->findBy([
  684. 'waybill' => $parcel['waybill']
  685. ]);
  687. $description = '';
  688. foreach ($p as $i => $pa){
  689. $description .= $pa->getDescription();
  690. if(count($p) != ($i+1)){
  691. $description .= ',';
  692. }
  693. }
  696. $date = $parcel['created_at']->format('Y-m-d H:i:s');
  698. $parcel['expenses'] = 3;
  702. if($parcel['is_cancelled']){
  703. // $parcel['expenses'] = -3;
  704. // $parcel['amount'] = -$parcel['amount'];
  705. $parcel['expenses'] = 0;
  706. $parcel['amount'] = -0;
  708. $phpExcelObject->setActiveSheetIndex(0)
  709. ->setCellValue('A'.$index, $index)
  710. ->setCellValue('B'.$index, $parcel['waybill'])
  711. ->setCellValue('C'.$index, $date)
  712. ->setCellValue('D'.$index, $parcel['from_station'])
  713. ->setCellValue('E'.$index, $parcel['to_station'])
  714. ->setCellValue('F'.$index, $parcel['expenses'])
  715. ->setCellValue('G'.$index, $parcel['amount'])
  716. ->getStyle("A{$index}:G{$index}")
  717. ->applyFromArray($cancelStyleArray);
  722. // $phpExcelObject->getActiveSheet()
  723. // ->getStyle("A{$index}:G{$index}")
  724. // ->applyFromArray($cancelStyleArray);
  726. }else {
  727. $phpExcelObject->setActiveSheetIndex(0)
  728. ->setCellValue('A'.$index, $index)
  729. ->setCellValue('B'.$index, $parcel['waybill'])
  730. ->setCellValue('C'.$index, $date)
  731. ->setCellValue('D'.$index, $parcel['from_station'])
  732. ->setCellValue('E'.$index, $parcel['to_station'])
  733. ->setCellValue('F'.$index, $parcel['expenses'])
  734. ->setCellValue('G'.$index, $parcel['amount'])
  735. ->getStyle("A{$index}:G{$index}")
  736. ->applyFromArray([
  737. 'font' => [
  738. 'bold' => true,
  739. 'color' => ['rgb' => '000000'],
  740. 'name' => 'Courier 10 Pitch'
  741. ],
  742. ]);
  745. // $phpExcelObject->getActiveSheet()
  746. // ->getStyle("A{$index}:G{$index}")
  747. // ->applyFromArray($cancelStyleArray);
  748. }
  752. // dump("Entering data");
  753. }
  756. // $phpExcelObject->getActiveSheet()->setTitle("Transactions");
  757. $phpExcelObject->setActiveSheetIndex(0)->setTitle('Transactions');
  759. /** create the writer
  760. $writer = $this->get('phpexcel')->createWriter($phpExcelObject, 'Excel2007');
  761. // create the response
  762. $response = $this->get('phpexcel')->createStreamedResponse($writer);
  763. // adding headers
  764. $dispositionHeader = $response->headers->makeDisposition(
  765. ResponseHeaderBag::DISPOSITION_ATTACHMENT,
  766. 'awesome.xlsx'
  767. );
  768. $response->headers->set('Content-Type', 'text/vnd.ms-excel; charset=utf-8');
  769. $response->headers->set('Pragma', 'public');
  770. $response->headers->set('Cache-Control', 'maxage=1');
  771. $response->headers->set('Content-Disposition', $dispositionHeader);
  773. // $response = new Response();
  774. // $response->headers->set('Content-type', 'text');
  775. // $response->setContent('awesome.xlsx');
  778. $writer
  779. return $response; */
  780. $logger->debug("saving file awesome vv");
  781. $writer = $this->get('phpexcel')->createWriter($phpExcelObject,'Excel2007');
  783. $md5 = md5(rand());
  784. $fileName = "transaction_report_{$fromDate}-{$toDate}-{$md5}.xlsx";
  785. try {
  786. $logger->debug("saving file awesome");
  788. $writer->save("reports/{$fileName}");
  789. } catch (\PHPExcel_Writer_Exception $e) {
  790. $logger->debug($e->getMessage());
  791. }
  794. $response = new Response();
  795. $response->headers->set('Content-type', 'text');
  796. $response->setContent($fileName);
  797. // $response->headers->set('Cache-Control', 'private');
  798. // $response->headers->set('Content-length', $attachmentSize);
  799. // $response->headers->set('Content-Disposition', 'attachment; filename="' . $fileName . '";');
  804. return $response;
  807. //
  808. // foreach ($parcels as $index => $parcel) {
  809. //// $row['valdate']->format('d/m/Y');
  810. // $date = $parcel['account_date']->format('d/m/y');
  811. // $waybill = $parcel['waybill'];
  812. //
  813. // dump($index.': '.$date.'-'.$waybill);
  814. // }
  815. //
  816. // die;
  817. $fileName = "report_".rand(1,20).".csv";
  819. $fp = fopen($fileName, 'w');
  820. // $fp = fopen('php://output', 'w');
  823. $s = [
  824. 'n',
  825. 'WAYBILL',
  826. 'DATE',
  827. 'FROM',
  828. 'TO',
  829. 'MAINTENANCE',
  830. 'AMOUNT'
  831. ];
  833. // fputcsv(
  834. // $fp, // The file pointer
  835. // $s, // The fields
  836. // ',' // The delimiter
  837. // );
  839. // foreach ($parcels as $index => $parcel) {
  840. // $date = $parcel['account_date']->format('Y-m-d H:i:s');
  841. //// $stringDate = $date->format('Y-m-d H:i:s');
  842. //
  843. // if($parcel['is_cancelled']){
  844. // $parcel['amount'] = 0;
  845. // }
  846. //
  847. // $s = [
  848. // 'n' => $index,
  849. // 'waybill' => $parcel['waybill'],
  850. // 'date'=> $date,
  851. // 'from'=> $parcel['from_station'],
  852. // 'to'=> $parcel['to_station'],
  853. // 'cost'=> $parcel['expenses'],
  854. // 'amount'=> $parcel['amount']
  855. // ];
  856. // fputcsv(
  857. // $fp, // The file pointer
  858. // $s, // The fields
  859. // ',' // The delimiter
  860. // );
  861. // }
  865. $response = new Response();
  866. $response->headers->set('Content-type', 'text');
  867. $response->setContent($fileName);
  868. // $response->headers->set('Cache-Control', 'private');
  869. // $response->headers->set('Content-length', $attachmentSize);
  870. // $response->headers->set('Content-Disposition', 'attachment; filename="' . $fileName . '";');
  875. return $response;
  876. }
  878. /**
  879. * @Route("/transactions/{id}", methods={"GET"}, name="one_transaction")
  880. */
  881. public function getOneWayBill($id){
  882. $em = $this->getDoctrine()->getManager();
  884. /** @var Transaction $transaction */
  885. $transaction = $em->getRepository(Transaction::class)->findOneBy([
  886. 'id' => $id
  887. ]);
  889. $parcels = $em->getRepository(Parcel::class)->findBy([
  890. 'waybill' => $transaction->getWayBill()
  891. ]);
  893. return $this->render('parcels/view_transaction.html.twig',[
  894. 'transaction' => $transaction,
  895. 'parcels' => $parcels
  896. ]);
  897. }
  900. /**
  901. * @Route("/transactions/details/{id}", methods={"GET"}, name="one_bos_transaction_detail_parcel")
  902. */
  903. public function getDetailParcel($id){
  904. $em = $this->getDoctrine()->getManager();
  905. $transaction = $em->getRepository(Transaction::class)->findOneBy([
  906. 'id' => $id
  907. ]);
  912. return $this->render('parcels/transaction_detail.html.twig',[
  913. 'transaction' => $transaction
  914. ]);
  915. }
  918. /**
  919. * @Route("/cancelled_transactions", name="bos_all_cancelled_transactions")
  920. */
  921. public function cancelledTransactionAction() {
  924. // replace this example code with whatever you need
  925. return $this->render('parcels/transactions_cancelled.html.twig',[]);
  926. }
  929. /**
  930. * @Route("/cancelled_list",methods={"post"}, name="bos_json_all_cancelled_transactions")
  931. * @param Request $request
  932. * @return Response
  933. */
  934. public function cancelledParcels(Request $request) {
  936. $em = $this->getDoctrine()->getManager();
  938. $context = new SerializationContext();
  939. $context->setSerializeNull(true);
  941. $page = $request->request->get('page') > 1 ? $request->request->get('page'): 1;
  942. $rows = $request->request->get('rows') > 1 ? $request->request->get('rows'): 20;
  945. $offset = ($page - 1)*$rows;
  947. $serializer = SerializerBuilder::create()->build();
  949. $filterRules = $request->request->get('filterRules');
  951. $parcels = $em->getRepository( WayBill::class)->findAllCancelledParcels($filterRules,$offset,$rows);
  952. $totals = $em->getRepository(WayBill::class)->findTotalCancelledParcels($filterRules);
  954. // dump($parcels); die;
  955. $data = [
  956. 'total' => $totals[0]['count'],
  957. 'rows' => $parcels
  958. ];
  960. // dump($data);
  962. $data = $serializer->serialize($data,'json', $context);
  964. return Response($data, Response::HTTP_OK);
  965. }
  969. }