src/Controller/DashboardController.php line 37

  1. <?php
  3. namespace App\Controller;
  5. use App\Repository\TheCaseActionsRepository;
  6. use App\Repository\TheCaseRepository;
  7. use App\Service\EDeskService;
  8. use Nzo\UrlEncryptorBundle\Encryptor\Encryptor;
  9. use Omines\DataTablesBundle\DataTableFactory;
  10. use PhpOffice\PhpSpreadsheet\Style\Border;
  11. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  12. use Symfony\Component\HttpFoundation\Request;
  13. use Symfony\Component\HttpFoundation\Response;
  14. use Symfony\Component\HttpFoundation\Session\SessionInterface;
  15. use Symfony\Component\HttpFoundation\StreamedResponse;
  16. use Symfony\Component\Routing\Annotation\Route;
  17. use Symfony\Contracts\Translation\TranslatorInterface;
  18. use Symfony\UX\Chartjs\Builder\ChartBuilderInterface;
  19. use Symfony\UX\Chartjs\Model\Chart;
  20. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  21. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  25. class DashboardController extends AbstractController
  26. {
  27.     private EDeskService $GetStep;
  28.     private ChartBuilderInterface $chartBuilder;
  30.     public function __construct(EDeskService $GetStep,ChartBuilderInterface $chartBuilder)
  31.     {
  32.         $this->GetStep = $GetStep;
  33.         $this->chartBuilder = $chartBuilder;
  35.     }
  36.     #[Route('/dashboard', name: 'app_dashboard')]
  37.     public function index(TheCaseRepository $theCaseRepository,Request $request,TranslatorInterface $translator): Response
  38.     {
  39.         //dd($theCaseRepository->CaseWithLastAction());
  40.         $GetCharte = $this->GetCharte($theCaseRepository, $translator->trans('Cases',[],'translation'));
  41.         $GetCountCase = $theCaseRepository->CountCases($this->getUser()->getLawOffice());
  42.         $GetStepStats = $this->GetStep->GetStepStat();
  43.         return $this->render('dashboard/index.html.twig', [
  44.             'controller_name' => 'DashboardController',
  45.             'StepStats' => $GetStepStats,
  46.             'CountCases' => $GetCountCase,
  47.             'ChartByMonth'=> $GetCharte,
  48.             'CasesWithLastActions' => $theCaseRepository->CaseWithLastAction(),
  49.         ]);
  50.     }
  52.    #[Route('/light-mode', name: 'light-mode')]
  54.     public function themeLight(SessionInterface $session): Response
  55.     {
  56.         $session->remove('theme');
  58.         return $this->redirectToRoute('app_dashboard');
  59.     }
  62.     #[Route('/dark-mode', name: 'dark-mode')]
  63.     public function themeDark(SessionInterface $session): Response
  64.     {
  65.         $session->set('theme', 'dark');
  67.         return $this->redirectToRoute('app_dashboard');
  68.     }
  70.     function GetCharte(TheCaseRepository $theCaseRepository,String $ChartTitle): Chart
  71.     {
  72.         $TypeCharte = 'ChartSticks';
  73.         $labels = [];
  74.         $data = [];
  75.         $max = 0;
  76.         $DatasRepo= $theCaseRepository->CaseByMonth();
  78.         //dd($DatasRepo);
  80.         if (empty($DatasRepo))
  81.         {
  82.             return $this->chartBuilder->createChart($TypeCharte);
  83.         }
  85.         foreach ($DatasRepo as $DataRepo )
  86.         {
  87.             //dd($DataRepo);
  88.             $labels[] = $DataRepo['Month'];
  89.             $data[] = $DataRepo['Total'];
  90.             if ($DataRepo['Total'] > $max)
  91.             {
  92.                 $max = $DataRepo['Total'];
  93.             }
  94.         }
  96.         switch ($TypeCharte) {
  97.             case "ChartCurved":
  98.                 $TypeCharte = Chart::TYPE_LINE;
  99.                 break;
  100.             case "ChartPie":
  101.                 $TypeCharte = Chart::TYPE_PIE;
  102.                 break;
  103.             case "ChartSticks":
  104.                 $TypeCharte = Chart::TYPE_BAR;
  105.                 break;
  106.         }
  108.         $chart = $this->chartBuilder->createChart($TypeCharte);
  109.         $chart->setData([
  110.             'labels' => $labels,
  111.             'datasets' => [
  112.                 [
  113.                     'label' => $ChartTitle,
  114.                     'backgroundColor' => $this->GetColor(count($data)),
  115.                     'data' => $data,
  116.                 ],
  117.             ],
  118.         ]);
  120.         $chart->setOptions([
  121.             'scales' => [
  122.                 'y' => [
  123.                     'suggestedMin' => 0,
  124.                     'suggestedMax' => $max+0.2,
  125.                 ],
  126.                 //'x'=>'gridLines'
  127.             ],
  128.         ]);
  129.         return $chart;
  130.     }
  131.     function GetColor($num) {
  132.         $ColorRanges =[];
  133.         for ($i = 1; $i <= $num; $i++) {
  134.             $hash = md5('color' . $i);
  135.             $ColorRange = 'rgb('.hexdec(substr($hash, 0, 2)).','.hexdec(substr($hash, 2, 2)).','.hexdec(substr($hash, 4, 2)).')';
  136.             array_push($ColorRanges, $ColorRange);
  137.         }
  138.         return $ColorRanges;
  139.     }
  141.     #[Route('Hearing', name: 'app_Hearing', methods: ['GET'])]
  142.     public function showHearing(Request $request,TheCaseActionsRepository $theCaseActionsRepository,Encryptor $encryptor,DataTableFactory $dataTableFactory,TranslatorInterface $translator,): Response
  143.     {
  144.         $DateValue = $encryptor->decrypt($request->get("Date"));
  145.         //$DateValue = $DateValue;
  146.         $LawOffice = $this->getUser()->getLawOffice();
  147.         $theCaseActions = $theCaseActionsRepository->FindByActionDate($DateValue,$LawOffice);
  149.         //dd($theCaseActions);
  151.         $Hearings = $this->render('the_case_actions/showmodal.html.twig', [
  152.             'Hearings' => $theCaseActions,
  153.             'ThisDate' => $request->get("Date"),
  154.             'DateValue' => $DateValue,
  155.         ]);
  156.         return $this->json([
  157.             'Status' => 'Success',
  158.             'Hearing' => $Hearings,
  159.         ], 200);
  160.         //return $this->redirectToRoute('app_case_continue', ['id'=>$theCaseAction->getTheCase()->getId()], Response::HTTP_SEE_OTHER);
  161.     }
  163.     #[Route('exportHearing', name: 'app_Hearing_Export', methods: ['GET'])]
  164.     public function showHearingExport(Request $request,TheCaseActionsRepository $theCaseActionsRepository,Encryptor $encryptor,TranslatorInterface $translator,): Response
  165.     {
  166.         $DateValue = $encryptor->decrypt($request->get("Date"));
  167.         //$DateValue = $DateValue;
  168.         $LawOffice = $this->getUser()->getLawOffice();
  169.         $theCaseActions = $theCaseActionsRepository->FindByActionDate($DateValue,$LawOffice);
  170.         $SubTitleStyleArray = [
  171.             'font' => [
  172.                 'bold' => true,
  173.                 'Size'=> 13
  174.             ],
  175.             'alignment' => [
  176.                 'horizontal' => \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER,
  177.             ],
  178.             'borders' => [
  179.                 'top' => [
  180.                     'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN,
  181.                 ],
  182.             ],
  183.             'fill' => [
  184.                 'fillType' => \PhpOffice\PhpSpreadsheet\Style\Fill::FILL_GRADIENT_LINEAR,
  185.                 'startColor' => [
  186.                     'argb' => 'FFA0A0A0',
  187.                 ],
  188.                 'endColor' => [
  189.                     'argb' => 'FFFFFFFF',
  190.                 ],
  191.             ],
  192.         ];
  193.         // Convert string $DateValue to date format:
  194.         $DateSTRToDate = new \DateTime($DateValue);
  195.         $spreadsheet = new Spreadsheet();
  196.         $sheet = $spreadsheet->getActiveSheet();
  197.         $sheet = $spreadsheet->getActiveSheet()->setTitle('جدول الجلسات');
  198.         $sheet->setCellValue('A1', 'جدول الجلسات ليوم : '.$DateSTRToDate->format('Y/m/d'))->mergeCells('A1:H1');
  199.         $sheet->getStyle('A1:H1')->getFont()->setSize(14);
  200.         $sheet->getStyle('A1:H1')->getFont()->setBold(true);
  201.         $sheet->getStyle('A1:H1')->getBorders()->getAllBorders()->setBorderStyle(true);
  202.         $sheet->getStyle('A1:H1')->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  203.         $sheet->getStyle('A2:H2')->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
  204.         $sheet->getStyle('A2:H2')->getBorders()->getAllBorders()->setBorderStyle(true);
  205.         $sheet->getStyle('A2:H2')->getFont()->setBold(true);
  207.         $sheet->getColumnDimension('A')->setWidth(20);
  208.         $sheet->getColumnDimension('B')->setWidth(26);
  209.         $sheet->getColumnDimension('C')->setAutoSize(true);
  210.         $sheet->getColumnDimension('D')->setAutoSize(true);
  211.         $sheet->getColumnDimension('E')->setAutoSize(true);
  212.         $sheet->getColumnDimension('F')->setAutoSize(true);
  213.         $sheet->getColumnDimension('G')->setAutoSize(true);
  214.         $sheet->getColumnDimension('H')->setAutoSize(true);
  217.         /// Title Column
  218.         $sheet->setCellValue('A2', $translator->trans('Memo',[],'translation'));
  219.         $sheet->setCellValue('B2', $translator->trans('Demand',[],'translation'));
  220.         $sheet->setCellValue('C2', $translator->trans('LawyerAdv',[],'translation'));
  221.         $sheet->setCellValue('D2', $translator->trans('OpponentName',[],'translation'));
  222.         $sheet->setCellValue('E2', $translator->trans('Client',[],'translation'));
  223.         $sheet->setCellValue('F2', $translator->trans('CaseType',[],'translation'));
  224.         $sheet->setCellValue('G2', $translator->trans('FullFileTpiNum',[],'translation'));
  225.         $sheet->setCellValue('H2', $translator->trans('RefLawOffice',[],'translation'));
  227.         $i = 3;
  228.         //$Cells = ['A',"B","C","D","E","F","G","H"];
  229.         foreach ($theCaseActions as $theCaseAction) {
  230.             $sheet->setCellValue('A'.$i, '');
  231.             $sheet->setCellValue('B'.$i, $theCaseAction->getActionName());
  232.             $sheet->setCellValue('C'.$i, $theCaseAction->getTheCase()->getLawyerAdv());
  233.             $sheet->setCellValue('D'.$i, $theCaseAction->getTheCase()->getOpponentName());
  234.             $sheet->setCellValue('E'.$i, $theCaseAction->getTheCase()->getClient()->getFirstName().' '.$theCaseAction->getTheCase()->getClient()->getLastName());
  235.             $sheet->setCellValue('F'.$i, $theCaseAction->getTheCase()->getCaseType()->getcaseTypeName());
  236.             $sheet->setCellValue('G'.$i, $theCaseAction->getTheCase()->getFullFileTpiNum());
  237.             $sheet->setCellValue('H'.$i, $theCaseAction->getTheCase()->getRefLawOffice());
  238.             $i++;
  239.         }
  240.         $styleArrayContent = array(
  241.             'borders' => array(
  242.                 'outline' => array(
  243.                     'style' => Border::BORDER_MEDIUM,
  244.                 ),
  245.             ),
  246.         );
  247.         $CellsCoordinate = "A3:H".$i;
  248.         $sheet->getStyle($CellsCoordinate)->applyFromArray($styleArrayContent);
  250.         //dd($theCaseActions);
  252.         $contentType = 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet';
  253.         $writer = new Xlsx($spreadsheet);
  255.         $response = new StreamedResponse();
  256.         $response->headers->set('Content-Type', $contentType);
  257.         $response->headers->set('Content-Disposition', 'attachment;filename="exports-'.time().'.xlsx"');
  258.         $response->setPrivate();
  259.         $response->headers->addCacheControlDirective('no-cache', true);
  260.         $response->headers->addCacheControlDirective('must-revalidate', true);
  261.         $response->setCallback(function() use ($writer) {
  262.             $writer->save('php://output');
  263.         });
  264.         return $response;
  265.     }
  266. }