src/Controller/Backend/JuryController.php line 58

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Backend;
  5. use Symfony\Component\HttpFoundation\Request;
  6. use Symfony\Component\HttpFoundation\Response;
  8. use FOS\RestBundle\Controller\Annotations as Rest;
  9. use FOS\RestBundle\View\View;
  10. use App\Annotation\Log;
  11. use App\Annotation\PermissionAdmin;
  12. use App\Annotation\PermissionPublic;
  13. use App\Utilities\ExportUtil;
  14. use Symfony\Contracts\Translation\TranslatorInterface;
  16. /**
  17.  * @Rest\Route("/api/jury")
  18.  */
  19. class JuryController extends BaseController
  20. {
  22.     public function extraFilter($input)
  23.     {
  24.         $commercialId = $input->get('filter_commercial') ?? $this->userService->getCommercialIdByUser();
  26.         $extraFilter = function ($qb) use ($commercialId) {
  27.             if ($commercialId) {
  28.                 $qb->join('Jury.profiles', 'profiles');
  29.                 $qb->andWhere('profiles.commercial IS NOT NULL AND profiles.commercial = :commercialId')
  30.                     ->setParameter('commercialId', $commercialId);
  31.             }
  32.         };
  34.         return $extraFilter;
  35.     }
  37.     /**
  38.      * @Rest\Get("/manager")
  39.      * @PermissionPublic
  40.      * @return View
  41.      */
  42.     public function juryManager(Request $request): View
  43.     {
  44.         $input = $request->query;
  45.         $extraFilter = $this->extraFilter($input);
  47.         return View::create(
  48.             $this->currentRepo->getList($request, 'App\DTO\Jury\JuryManagerOutput', $extraFilter),
  49.             Response::HTTP_OK
  50.         );
  51.     }
  53.     /**
  54.      * @Rest\Get("/manager/{id}")
  55.      * @PermissionPublic
  56.      * @return View
  57.      */
  58.     public function juryManagerProfile($id): View
  59.     {
  60.         return View::create(
  61.             $this->currentService->getProfileById($id),
  62.             Response::HTTP_OK
  63.         );
  64.     }
  66.     /**
  67.      * @Rest\Get("/list")
  68.      * @PermissionPublic
  69.      * @return View
  70.      */
  71.     public function getList(Request $request): View
  72.     {
  73.         return View::create(
  74.             $this->currentRepo->getList($request, null),
  75.             Response::HTTP_OK
  76.         );
  77.     }
  80.     /**
  81.      * @Rest\Get("/export-excel")
  82.      * @PermissionPublic
  83.      */
  84.     public function exportExcel(Request $request, TranslatorInterface $translator, ExportUtil $exportUtil)
  85.     {
  86.         ini_set('memory_limit', '-1');
  87.         ini_set('max_execution_time', 9600);
  88.         set_time_limit(0);
  90.         $input = $request->query;
  91.         $extraFilter = $this->extraFilter($input);
  93.         if ($request->get('all') == 'true') {            
  95.             $q = $this->currentRepo->getAll($request, 'App\DTO\Jury\JuryExcelOutput', $extraFilter, true);
  97.             $fileName = 'Export_' . $translator->trans('Étude_du_dossier') . '_' . date('d_m_Y') . '.xlsx';
  99.             $excelData = $exportUtil->generateByArrayJury($q);
  101.             header('Content-Description: File Transfer');
  102.             header('Access-Control-Allow-Origin: *');
  103.             header('Content-Type: application/vnd.ms-excel');
  104.             header('Content-Disposition: inline; filename=' . $fileName);
  105.             header('Expires: 0');
  106.             header('Cache-Control: must-revalidate');
  107.             header('Pragma: public');
  109.             echo $excelData;
  111.             exit;
  112.         }
  114.         $data = $this->currentRepo->getAll($request, 'App\DTO\Jury\JuryExcelOutput');
  116.         $content = $this->renderView('excel/jury_list.html.twig', [
  117.             'data' => $data,
  118.         ]);
  120.         $fileName = 'Export_' . $translator->trans('Étude_du_dossier') . '_' . date('d_m_Y') . '.xlsx';
  122.         $excelData = ExportUtil::generateExcel($content);
  124.         $result = [
  125.             'file_name' => $fileName,
  126.             'file' => "data:application/vnd.ms-excel;base64," . base64_encode($excelData),
  127.         ];
  129.         return $this->json($result);
  130.     }
  133.     /**
  134.      * @Rest\Post("")
  135.      * @PermissionAdmin
  136.      * @Log
  137.      * @return View
  138.      */
  139.     public function add(Request $request): View
  140.     {
  141.         return View::create($this->currentService->add($request), Response::HTTP_OK);
  142.     }
  144.     /**
  145.      * @Rest\Post("/update")
  146.      * @PermissionAdmin
  147.      * @Log
  148.      * @return View
  149.      */
  150.     public function update(Request $request): View
  151.     {
  152.         return View::create($this->currentService->update(null, $request), Response::HTTP_OK);
  153.     }
  155.     /**
  156.      * @Rest\Delete("/{id}")
  157.      * @PermissionAdmin
  158.      * @Log
  159.      * @return View
  160.      */
  161.     public function delete(int $id): View
  162.     {
  163.         return View::create(['result' => $this->currentService->delete($id)], Response::HTTP_OK);
  164.     }
  166.     /**
  167.      * @Rest\Get("/{id}")
  168.      * @PermissionPublic
  169.      * @return View
  170.      */
  171.     public function getOne($id): View
  172.     {
  173.         return View::create($this->currentService->getById($id), Response::HTTP_OK);
  174.     }
  175. }