src/Controller/GestionComerciale/HistoriqueEmailController.php line 56

Open in your IDE?
  1. <?php
  3. namespace App\Controller\GestionComerciale;
  5. use App\Entity\Articles\Article;
  6. use App\Entity\Clients\Client;
  7. use App\Entity\Fournisseurs\Fournisseur;
  8. use App\Entity\GestionComerciale\Commande;
  9. use App\Entity\GestionComerciale\CommandeFournisseur;
  10. use App\Entity\GestionComerciale\HistoriqueCommande;
  11. use App\Entity\Transporteurs\Transporteur;
  12. use App\Library\Datatable\Util\Datatable;
  13. use Doctrine\ORM\EntityManagerInterface;
  14. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  15. use Symfony\Component\HttpFoundation\Request;
  16. use Symfony\Component\HttpFoundation\JsonResponse;
  17. use Symfony\Component\HttpFoundation\Response;
  18. use Symfony\Component\Routing\Annotation\Route;
  19. use Symfony\Component\Validator\Validator\ValidatorInterface;
  20. use Symfony\Contracts\Translation\TranslatorInterface;
  22. class HistoriqueEmailController extends AbstractController
  23. {
  24.     /**
  25.      * @Route("/email-client/charger-tableau/{id}/{type}", name="dtc_email_client_charger_tableau")
  26.      */
  27.     public function chargerTableauAction(Request $request, $id = "0", $type = "", EntityManagerInterface $em)
  28.     {
  29.         $objet = null;
  31.         if ($type == "article") {
  32.             $repo_objet = $em->getRepository(Article::class);
  33.             $objet      = $repo_objet->find($id);
  34.         } elseif ($type == "client") {
  35.             $repo_objet = $em->getRepository(Client::class);
  36.             $objet      = $repo_objet->find($id);
  37.         } elseif ($type == "commande") {
  38.             $repo_objet = $em->getRepository(Commande::class);
  39.             $objet      = $repo_objet->find($id);
  40.         } elseif ($type == "commandeFournisseur") {
  41.             $repo_objet = $em->getRepository(CommandeFournisseur::class);
  42.             $objet      = $repo_objet->find($id);
  43.         } elseif ($type == "fournisseur") {
  44.             $repo_objet = $em->getRepository(Fournisseur::class);
  45.             $objet      = $repo_objet->find($id);
  46.         }
  48.         $rendu = $this->renderView('GestionComerciale/HistoriqueEmail/charger_tableau.html.twig', ["id" => $id, "type" => $type, "objet" => $objet]);
  50.         return new JsonResponse(['rendu' => $rendu]);
  51.     }
  53.     /**
  54.      * @Route("", name="")
  55.      */
  56.     public function listerAction(Request $request, $id, $type = "", EntityManagerInterface $em, Datatable $datatable, TranslatorInterface $translator)
  57.     {
  58.         if ($type == 'client') {
  59.             $repo_objet = $em->getRepository(Client::class);
  60.             $objet      = $repo_objet->find($id);
  61.         } elseif ($type == 'transporteur') {
  62.             $repo_objet = $em->getRepository(Transporteur::class);
  63.             $objet      = $repo_objet->find($id);
  64.         } elseif ($type == 'fournisseur') {
  65.             $repo_objet = $em->getRepository(Fournisseur::class);
  66.             $objet      = $repo_objet->find($id);
  67.         }
  69.         $tableau_class_cellule   = [];
  70.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id text-center", "targets" => [0], "visible" => true, "orderable" => true, "searchable" => false];
  71.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [1], "visible" => true, "orderable" => true, "searchable" => true];
  72.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [2], "visible" => true, "orderable" => true, "searchable" => true];
  73.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [3], "visible" => true, "orderable" => true, "searchable" => true];
  74.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id text-center", "targets" => [4], "visible" => true, "orderable" => false, "searchable" => true];
  75.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [5], "visible" => true, "orderable" => false, "searchable" => false];
  77.         /*
  78.         $tableau_class_cellule[]=array("className"=>"visible_export colonne_id","targets"=>array(0),"visible"=>true,"orderable"=>true,"searchable"=> true);
  79.         $tableau_class_cellule[]=array("className"=>"visible_export colonne_id","targets"=>array(1),"visible"=>true,"orderable"=>true,"searchable"=> true);
  80.         $tableau_class_cellule[]=array("className"=>"visible_export colonne_id","targets"=>array(2),"visible"=>true,"orderable"=>true,"searchable"=> true);
  81.         $tableau_class_cellule[]=array("className"=>"visible_export colonne_id","targets"=>array(3),"visible"=>true,"orderable"=>true,"searchable"=> true);
  82.         $tableau_class_cellule[]=array("className"=>"visible_export colonne_id","targets"=>array(4),"visible"=>true,"orderable"=>true,"searchable"=> true);
  83.         $tableau_class_cellule[]=array("className"=>"visible_export colonne_id","targets"=>array(5),"visible"=>true,"orderable"=>true,"searchable"=> true);
  84.         $tableau_class_cellule[]=array("orderable"=>false,"className"=>"colonne_id","targets"=>array(6),"visible"=>true,"orderable"=>true);
  85.         $tableau_class_cellule[]=array("orderable"=>false,"className"=>"colonne_id","targets"=>array(7),"visible"=>true,"orderable"=>true);
  86.         $tableau_class_cellule[]=array("orderable"=>false,"className"=>"colonne_id","targets"=>array(8),"visible"=>true,"orderable"=>false);
  87.         */
  88.         $this->datatable($objet, $type, $datatable, $translator);
  90.         return $this->render('GestionComerciale/HistoriqueEmail/lister.html.twig', ['tableauClassColonne' => $tableau_class_cellule, "id" => $id, "type" => $type]);
  92.     }
  94.     /**
  95.      * set datatable configs
  96.      *
  97.      * @return \App\Library\Datatable\Util\Datatable
  98.      */
  99.     private function datatable($objet, $type = "", Datatable $datatable, TranslatorInterface $translator)
  100.     {
  101.         $type_jointure = 'x.'.$type;
  102.         $datatable->setDatatableId('dta-historique-email')
  103.                   ->setEntity(HistoriqueCommande::class, "x")
  104.                   ->setFields(
  105.                       [
  106.                           //$translator->trans("ID") =>  'x.id',
  107.                           $translator->trans("Date envoi")   => 'x.date',
  108.                           $translator->trans("Expéditeur")   => 'x.expediteurMail',
  109.                           $translator->trans("Destinataire") => 'x.destinataireMail',
  110.                           $translator->trans("Sujet")        => 'x.sujetMail',
  111.                           $translator->trans("pj")           => 'x.pjMail',
  112.                           $translator->trans("Actions")      => 'x.id',
  113.                           "_identifier_"                     => 'x.id',
  114.                       ]
  115.                   )
  117.             //->addJoin('x.civilite', 'c', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  118.                   ->setWhere(
  119.                 $type_jointure.' = :objet',
  120.                 ['objet' => $objet]
  121.             )
  122.                   ->setRenderers(
  123.                       [
  124.                           0 => [
  125.                               'view'   => 'FO/DataTable/heure.html.twig',
  126.                               'params' => [],
  127.                           ],
  128.                           4 => [
  129.                               'view'   => 'FO/DataTable/total_pj_email.html.twig',
  130.                               'params' => [],
  131.                           ],
  132.                           5 => [
  133.                               'view'   => 'FO/DataTable/actions_modal.html.twig',
  134.                               'params' => [
  135.                                   'afficher_route'       => 'dtc_email_client_afficher',
  136.                                   'email_renvoyer_route' => 'dtc_commande_email_envoyer',
  137.                                   'id'                   => $objet->getId(),
  138.                                   'type'                 => $type,
  139.                                   'entite'               => 'HistoriqueCommande',
  140.                                   'objet'                => HistoriqueCommande::class,
  141.                                   'table'                => "",
  142.                                   'width_modal'          => "1000",
  143.                               ],
  144.                           ],
  146.                       ]
  147.                   )
  148.                   ->setOrder("x.id", "desc")
  149.                   ->setSearch(true)
  150.                   ->setSearchFields([1, 2, 3])
  151.                   ->setOrder("x.date", "desc");
  153.         return $datatable;
  154.     }
  157.     /**
  158.      * @Route("/historique-email/grid/{id}/{type}", name="dtc_historique_email_liste_grid")
  159.      */
  160.     public function gridAction(Request $request, $id = "", $type = "", EntityManagerInterface $em, Datatable $datatable, TranslatorInterface $translator)
  161.     {
  162.         if ($type == 'client') {
  163.             $repo_objet = $em->getRepository(Client::class);
  164.             $objet      = $repo_objet->find($id);
  165.         } elseif ($type == 'transporteur') {
  166.             $repo_objet = $em->getRepository(Transporteur::class);
  167.             $objet      = $repo_objet->find($id);
  168.         } elseif ($type == 'fournisseur') {
  169.             $repo_objet = $em->getRepository(Fournisseur::class);
  170.             $objet      = $repo_objet->find($id);
  171.         }
  173.         return $this->datatable($objet, $type, $datatable, $translator)->execute();
  174.     }
  176.     /**
  177.      * @Route("/email-client/afficher/{objet}/{id}/{type}", name="dtc_email_client_afficher")
  178.      */
  179.     public function afficherAction(Request $request, HistoriqueCommande $objet, $id, $type, TranslatorInterface $translator)
  180.     {
  181.         $type_json = "";
  183.         $user    = $this->getUser();
  184.         $param   = $request->query->all();
  185.         $get     = $request->query->all();
  187.         $titre_modal = $translator->trans("Détails email");
  190.         $rendu = $this->renderView('GestionComerciale/HistoriqueEmail/afficher_modal.html.twig', ['email' => $objet]);
  192.         return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  193.     }
  195. }