File Manager - BorneoXploit

← Back

Editing: AgencyController.php

<?php

namespace App\Controller;

use App\DTO\AgencyImport as AgencyImportDTO;
use App\Entity\Agency;
use App\Form\Admin\AgencyImportCommitType;
use App\Form\Admin\AgencyImportPreviewType;
use App\Form\AgencyType;
use App\Form\Filter\UserFilterType;
use App\Import\AgencyExport;
use App\Import\AgencyImporter;
use App\Repository\AgencyRepository;
use App\Repository\ItemRepository;
use App\Service\SolutionService;
use Doctrine\Common\Collections\Criteria;
use Doctrine\DBAL\Exception\UniqueConstraintViolationException;
use Doctrine\ORM\EntityManagerInterface;
use Doctrine\ORM\OptimisticLockException;
use Doctrine\ORM\ORMException;
use Dompdf\Dompdf;
use Dompdf\Options;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
use Symfony\Component\HttpFoundation\BinaryFileResponse;
use Symfony\Component\HttpFoundation\File\Exception\FileException;
use Symfony\Component\HttpFoundation\File\UploadedFile;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\HttpFoundation\Response;
use Symfony\Component\HttpFoundation\ResponseHeaderBag;
use Symfony\Component\HttpKernel\KernelInterface;
use Symfony\Component\Routing\Annotation\Route;

#[Route(path: '/agency')]
class AgencyController extends AbstractController
{
    /**
     * @throws \PhpOffice\PhpSpreadsheet\Writer\Exception
     */
    #[Route(path: '/export/index', name: 'agency_export_index', methods: ['GET'])]
    public function exportIndex(AgencyRepository $agencyRepository): Response
    {
        $agencyList = $agencyRepository->findAll();
        $spreadsheet = new Spreadsheet();
        $sheet = $spreadsheet->getActiveSheet();
        $sheet->setTitle('Adresse');

$sheet->setCellValue('A1', 'Nom');
        $sheet->setCellValue('B1', 'Email');
        $sheet->setCellValue('C1', 'Téléphone fixe');
        $sheet->setCellValue('D1', 'Date début contrat');
        $sheet->setCellValue('E1', 'Date fin contrat');
        $sheet->setCellValue('F1', 'Nombre licence');
        $sheet->setCellValue('G1', 'Nom contact');
        $sheet->setCellValue('H1', 'Prénom contact');
        $sheet->setCellValue('I1', 'Mail contact');
        $sheet->setCellValue('J1', 'Téléphone contact');

for ($i = 0; $i < count($agencyList); ++$i) {
            $sheet->setCellValue('A'.($i + 2), $agencyList[$i]->getNom());
            $sheet->setCellValue('B'.($i + 2), $agencyList[$i]->getEmail());
            $sheet->setCellValue('C'.($i + 2), $agencyList[$i]->getTelephoneFixe());
            $sheet->setCellValue('D'.($i + 2), $agencyList[$i]->getDateDebutContrat());
            $sheet->setCellValue('E'.($i + 2), $agencyList[$i]->getDateFinContrat());
            $sheet->setCellValue('F'.($i + 2), $agencyList[$i]->getNombreLicence());
            $sheet->setCellValue('G'.($i + 2), $agencyList[$i]->getNomContact());
            $sheet->setCellValue('H'.($i + 2), $agencyList[$i]->getPrenomContact());
            $sheet->setCellValue('I'.($i + 2), $agencyList[$i]->getMailContact());
            $sheet->setCellValue('J'.($i + 2), $agencyList[$i]->getTelephoneContact());
        }

$writer = new Xlsx($spreadsheet);
        $fileName = 'agencys.xlsx';
        $tmpFile = tempnam(sys_get_temp_dir(), $fileName);

// Create the excel file in the tmp directory of the system
        $writer->save($tmpFile);

// Return the excel file as an attachment
        return $this->file($tmpFile, $fileName, ResponseHeaderBag::DISPOSITION_INLINE);
    }

#[Route(path: '/export/pdf', name: 'agency_export_pdf_index', methods: ['GET'])]
    public function exportPdfIndex(AgencyRepository $agencyRepository): Response
    {
        $agencyList = $agencyRepository->findAll();
        // Configure Dompdf according to your needs
        $pdfOptions = new Options();
        $pdfOptions->set('defaultFont', 'Arial');
        // Instantiate Dompdf with our options
        $dompdf = new Dompdf($pdfOptions);
        $dompdf->set_option('isHtml5ParserEnabled', true);
        $title = 'Welcome to our PDF Test';
        // Retrieve the HTML generated in our twig file
        $html = $this->renderView(
            'export/pdf_agency.html.twig',
            [
                'agencyList' => $agencyList,
                'user' => $this->getUser(),
            ]
        );

// Load HTML to Dompdf
        $dompdf->loadHtml($html);

// (Optional) Setup the paper size and orientation 'portrait' or 'landscape'
        $dompdf->setPaper('A4', 'landscape');

// Render the HTML as PDF
        $dompdf->render();

// Output the generated PDF to Browser (force download)
        $dompdf->stream(
            'entreprises.pdf',
            [
                'Attachment' => true,
            ]
        );

return new Response();
    }

#[Route(path: '/', name: 'agency_index', methods: ['GET'])]
    public function index(Request $request, AgencyRepository $agencyRepository): Response
    {
        $agencies = $agencyRepository->getAgencysWithSearch($request->get('s'));

return $this->render(
            'client/index.html.twig',
            [
                'agencies' => $agencies,
            ]
        );
    }

#[Route(path: '/{id}/utilisateurs', name: 'agency_user_index', methods: ['GET', 'POST'])]
    public function agencyUsers(Agency $agency, Request $request): Response
    {
        $criteria = Criteria::create();
        $userFilterType = $this->createForm(UserFilterType::class);

$userFilterType->handleRequest($request);

if ($userFilterType->isSubmitted()) {
            $data = $userFilterType->getData();

if ($data['role']) {
                $criteria->andWhere(Criteria::expr()->contains('roles', $data['role']));
            }
        }
        $agencyUsers = $agency->getUsers()->matching($criteria);

return $this->render(
            'client/user.html.twig',
            [
                'userFilterForm' => $userFilterType->createView(),
                'agency' => $agency,
                'agencyUsers' => $agencyUsers,
            ]
        );
    }

/**
     * @throws ORMException
     * @throws OptimisticLockException
     * @throws \PhpOffice\PhpSpreadsheet\Exception
     * @throws \ReflectionException
     * @throws \App\Import\AgencyImportException
     */
    #[Route(path: '/import/{agency}', name: 'agency_import')]
    public function import(
        Agency $agency,
        ItemRepository $itemRepository,
        SolutionService $solutionService
    ): Response {
        $defaultItems = $itemRepository->findDefaultByAgency($agency, $solutionService->getCurrent());
        $import = new AgencyImportDTO($defaultItems);

$previewForm = $this->createForm(AgencyImportPreviewType::class, $import);

return $this->render('client/import.html.twig', ['agency' => $agency, 'form' => $previewForm->createView()]);
    }

#[Route(path: '/import/{agency}/preview', name: 'agency_import_preview', methods: ['POST'])]
    public function importPreview(
        Agency $agency,
        Request $request,
        AgencyImporter $agencyImport,
        KernelInterface $kernel,
    ): Response {
        $import = new AgencyImportDTO();
        $previewForm = $this->createForm(AgencyImportPreviewType::class, $import);
        $previewForm->handleRequest($request);

if (!$previewForm->isValid()) {
            $this->addFlash('danger', 'Formulaire invalide');