Symfony Profiler

<?php
namespace App\Controller\Fournisseurs;
use App\Entity\Clients\Client;
use App\Entity\Fournisseurs\Fournisseur;
use App\Entity\Fournisseurs\FraisPort;
use App\Entity\Transporteurs\Transporteur;
use App\Form\Fournisseurs\FraisPortType;
use App\Form\Fournisseurs\SupprimerFraisPortType;
use App\Library\Datatable\Util\Datatable;
use App\Security\Voter\EntityVoter;
use Doctrine\ORM\EntityManagerInterface;
use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
use Symfony\Component\HttpFoundation\JsonResponse;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\HttpFoundation\Response;
use Symfony\Component\Routing\Annotation\Route;
use Symfony\Component\Validator\Validator\ValidatorInterface;
use Symfony\Contracts\Translation\TranslatorInterface;
class FraisPortController extends AbstractController
{
/**
* @Route("/frais-port-fournisseur/nouveau/{id}/{type}", name="dtc_fournisseur_frais_port_ajouter")
*/
public function ajouterAction(Request $request, $id, $type = "", EntityManagerInterface $em, TranslatorInterface $translator, ValidatorInterface $validator)
{
$titre_modal = $translator->trans("Nouveau frais de port");
$page = $request->query->get('page');
$fraisPort = new FraisPort();
$user = $this->getUser();
//$fraisPort->setUtilisateur($user);
$get = $request->query->all();
$form = $this->createForm(FraisPortType::class, $fraisPort);
$errors = "";
$form->handleRequest($request);
if ($form->isSubmitted()) {
$post = $request->request->all();
if ($form->isValid()) {
if ($type == 'client') {
$repo_objet = $em->getRepository(Client::class);
$objet = $repo_objet->find($id);
$fraisPort->setClient($objet);
$url = $this->generateUrl('dtc_client_modifier', ['id' => $objet->getId(), 'tab' => 'fraisPort']);
} elseif ($type == 'fournisseur') {
$repo_objet = $em->getRepository(Fournisseur::class);
$objet = $repo_objet->find($id);
$fraisPort->setFournisseur($objet);
$url = $this->generateUrl('dtc_fournisseur_modifier', ['id' => $objet->getId(), 'tab' => 'fraisPort']);
}
$em->persist($fraisPort);
$em->flush();
if (array_key_exists('table', $get) && $get["table"] != "") {
return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url, 'type' => 'recharger_datatable', 'id_datatable' => $get["table"]]);
} else {
$this->addFlash('notice', $translator->trans('FraisPort ajoutée avec succès !'));
return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
}
} else {
$errors = $validator->validate($fraisPort);
$rendu = $this->renderView('Fournisseurs/FraisPort/ajouter.html.twig', ['form' => $form->createView(), 'errors' => $errors, 'id' => $id, 'type' => $type]);
return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
}
}
$rendu = $this->renderView('Fournisseurs/FraisPort/ajouter.html.twig', ['form' => $form->createView(), 'errors' => $errors, 'id' => $id, 'type' => $type]);
return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
//return $this->render('Fournisseurs/FraisPort/ajouter.html.twig', array('form' => $form->createView(),'errors'=>$errors,'id'=>$id,'type'=>$type));
}
/**
* @Route("/frais-port-fournisseur/modifier/{objet}/{id}/{type}", name="dtc_fournisseur_frais_port_modifier")
*/
public function modifierAction(Request $request, FraisPort $objet, $id, $type, EntityManagerInterface $em, TranslatorInterface $translator,
ValidatorInterface $validator
) {
$fraisPort = $objet;
$titre_modal = $translator->trans("Modifier frais de port");
$get = $request->query->all();
$user = $this->getUser();
//$fraisPort->setUtilisateur($user);
$form = $this->createForm(FraisPortType::class, $fraisPort);
$errors = "";
$form->handleRequest($request);
$post = $request->request->all();
if ($form->isSubmitted()) {
$droit = $this->isGranted(EntityVoter::UPDATE, FraisPort::class);
if ( ! $droit) {
$rendu = $this->renderView(
'Fournisseurs/FraisPort/ajouter.html.twig',
['form' => $form->createView(), 'errors' => $errors, 'id' => $id, 'type' => $type, 'objet' => $objet]
);
return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
}
if ($form->isValid()) {
if ($type == 'client') {
$repo_objet = $em->getRepository(Client::class);
$objet = $repo_objet->find($id);
$fraisPort->setClient($objet);
$url = $this->generateUrl('dtc_client_modifier', ['id' => $objet->getId(), 'tab' => 'fraisPort']);
} elseif ($type == 'fournisseur') {
$repo_objet = $em->getRepository(Fournisseur::class);
$objet = $repo_objet->find($id);
$fraisPort->setFournisseur($objet);
$url = $this->generateUrl('dtc_fournisseur_modifier', ['id' => $objet->getId(), 'tab' => 'fraisPort']);
}
$em->persist($fraisPort);
$em->flush();
if (array_key_exists('table', $get) && $get["table"] != "") {
return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url, 'type' => 'recharger_datatable', 'id_datatable' => $get["table"]]);
} else {
$this->addFlash('notice', $translator->trans('FraisPort modifié avec succès !'));
return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
}
} else {
$errors = $validator->validate($fraisPort);
$rendu = $this->renderView(
'Fournisseurs/FraisPort/ajouter.html.twig',
['form' => $form->createView(), 'errors' => $errors, 'id' => $id, 'type' => $type, 'objet' => $objet]
);
return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
}
}
$rendu = $this->renderView('Fournisseurs/FraisPort/ajouter.html.twig', ['form' => $form->createView(), 'errors' => $errors, 'id' => $id, 'type' => $type, 'objet' => $objet]);
return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
}
/**
* @Route("/frais-port-fournisseur/supprimer/{objet}/{id}/{type}", name="dtc_fournisseur_frais_port_supprimer")
*/
public function supprimerAction(Request $request, FraisPort $objet, $id, $type, EntityManagerInterface $em, TranslatorInterface $translator, ValidatorInterface $validator)
{
$fraisPort = $objet;
$titre_modal = $translator->trans("Demande de confirmation");
$user = $this->getUser();
$get = $request->query->all();
$form = $this->createForm(SupprimerFraisPortType::class, $fraisPort);
$errors = "";
$form->handleRequest($request);
if ($form->isSubmitted()) {
if ($form->isValid()) {
$em->remove($fraisPort);
$em->flush();
if ($type == 'client') {
$url = $this->generateUrl('dtc_client_modifier', ['id' => $id, 'tab' => 'fraisPort']);
} elseif ($type == 'transporteur') {
$url = $this->generateUrl('dtc_transporteur_modifier', ['id' => $id, 'tab' => 'fraisPort']);
} elseif ($type == 'fournisseur') {
$url = $this->generateUrl('dtc_fournisseur_modifier', ['id' => $id, 'tab' => 'fraisPort']);
}
if (array_key_exists('table', $get) && $get["table"] != "") {
return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url, 'type' => 'recharger_datatable', 'id_datatable' => $get["table"]],
200,
['Content-Type' => 'application/json']);
} else {
$this->addFlash('notice', $translator->trans('FraisPort supprimée avec succès !'));
return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
}
} else {
$errors = $validator->validate($fraisPort);
$rendu = $this->renderView('FO/Supprimer/supprimer.html.twig', ['form' => $form->createView(), 'errors' => $errors, 'id' => $id, 'type' => $type, 'objet' => $objet]);
return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
}
}
$rendu = $this->renderView('FO/Supprimer/supprimer.html.twig', ['form' => $form->createView(), 'errors' => $errors, 'id' => $id, 'type' => $type, 'objet' => $objet]);
return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
}
/**
* @Route("", name="")
*/
public function listerAction(Request $request, $id, $type = "", EntityManagerInterface $em, Datatable $datatable, TranslatorInterface $translator)
{
if ($type == 'client') {
$repo_objet = $em->getRepository(Client::class);
$objet = $repo_objet->find($id);
} elseif ($type == 'transporteur') {
$repo_objet = $em->getRepository(Transporteur::class);
$objet = $repo_objet->find($id);
} elseif ($type == 'fournisseur') {
$repo_objet = $em->getRepository(Fournisseur::class);
$objet = $repo_objet->find($id);
}
$tableau_class_cellule[] = ["className" => "visible_export colonne_id text-right", "targets" => [0], "visible" => true, "orderable" => true, "searchable" => true];
$tableau_class_cellule[] = ["className" => "visible_export colonne_id text-right", "targets" => [1], "visible" => true, "orderable" => true, "searchable" => true];
$tableau_class_cellule[] = ["className" => "visible_export colonne_id text-center", "targets" => [2], "visible" => true, "orderable" => true, "searchable" => true];
$tableau_class_cellule[] = ["className" => "visible_export colonne_id text-center", "targets" => [3], "visible" => true, "orderable" => true, "searchable" => true];
$tableau_class_cellule[] = ["className" => "visible_export colonne_id text-right", "targets" => [4], "visible" => true, "orderable" => true, "searchable" => true];
$tableau_class_cellule[] = ["orderable" => false, "className" => "colonne_id", "targets" => [5], "visible" => true];
$this->datatable($objet, $type, $datatable, $translator);
return $this->render('Fournisseurs/FraisPort/lister.html.twig', ['tableauClassColonne' => $tableau_class_cellule, "id" => $id, "type" => $type]);
}
/**
* set datatable configs
*
* @return \App\Library\Datatable\Util\Datatable
*/
private function datatable($objet, $type = "", Datatable $datatable, TranslatorInterface $translator)
{
$type_jointure = 'x.'.$type;
$datatable->setDatatableId('dta-fournisseurs-frais-port')
->setEntity(FraisPort::class, "x")
->setFields(
[
//$translator->trans("ID") => 'x.id',
$translator->trans("Montant minimum") => 'x.montantMini',
$translator->trans("Montant maximum") => 'x.montantMaxi',
$translator->trans("Poids minimum") => 'x.poidsMini',
$translator->trans("Poids maximum") => 'x.poidsMaxi',
$translator->trans("Frais de port") => 'x.fraisPort',
$translator->trans("Actions") => 'x.id',
"_identifier_" => 'x.id',
]
)
//->addJoin('x.ville', 'v', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
//->addJoin('x.codePostal', 'cp', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
//->addJoin('x.pays', 'p', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
->setWhere(
$type_jointure.' = :objet',
['objet' => $objet]
)
->setRenderers(
[
0 => [
'view' => 'FO/DataTable/prix.html.twig',
'params' => [],
],
1 => [
'view' => 'FO/DataTable/prix.html.twig',
'params' => [],
],
4 => [
'view' => 'FO/DataTable/prix.html.twig',
'params' => [],
],
/*
0=> array(
'view' => 'FO/DataTable/edit_texte.html.twig',
'params' => array(
'objet' => 'DTCFournisseursBundle:FraisPort',
'champ' => 'setLibelle',
),
),
1=> array(
'view' => 'FO/DataTable/edit_texte.html.twig',
'params' => array(
'objet' => 'DTCFournisseursBundle:FraisPort',
'champ' => 'setNumero',
),
),
2=> array(
'view' => 'FO/DataTable/edit_texte.html.twig',
'params' => array(
'objet' => 'DTCFournisseursBundle:FraisPort',
'champ' => 'setRue',
),
),
3=> array(
'view' => 'FO/DataTable/edit_texte.html.twig',
'params' => array(
'objet' => 'DTCFournisseursBundle:FraisPort',
'champ' => 'setComplement',
),
),
*/
5 => [
'view' => 'FO/DataTable/actions_modal.html.twig',
'params' => [
'edit_route' => 'dtc_fournisseur_frais_port_modifier',
'supprimer_route' => 'dtc_fournisseur_frais_port_supprimer',
'id' => $objet->getId(),
'type' => $type,
'entite' => 'fraisPort',
'objet' => FraisPort::class,
'table' => "dta-fournisseurs-frais-port",
],
],
]
)
->setOrder("x.id", "asc")
->setSearch(true)
->setSearchFields([1, 2]);
return $datatable;
}
/**
* @Route("/frais-port-fournisseur/grid/{id}/{type}", name="dtc_fournisseur_frais_port_liste_grid")
*/
public function gridAction(Request $request, $id = "", $type = "", EntityManagerInterface $em, Datatable $datatable, TranslatorInterface $translator)
{
if ($type == 'client') {
$repo_objet = $em->getRepository(Client::class);
$objet = $repo_objet->find($id);
} elseif ($type == 'transporteur') {
$repo_objet = $em->getRepository(Transporteur::class);
$objet = $repo_objet->find($id);
} elseif ($type == 'fournisseur') {
$repo_objet = $em->getRepository(Fournisseur::class);
$objet = $repo_objet->find($id);
}
return $this->datatable($objet, $type, $datatable, $translator)->execute();
}
/**
* @Route("/frais-port-fournisseur/recuperer/fournisseur/{id}", name="dtc_fournisseur_frais_port_recuperer")
*/
public function recupererAction(Request $request, Fournisseur $fournisseur, EntityManagerInterface $em, TranslatorInterface $translator, ValidatorInterface $validator)
{
$franco = floatval($fournisseur->getFranco());
$repo_frais_port = $em->getRepository(FraisPort::class);
$montant = floatval($request->query->get('montant'));
$poids = floatval($request->query->get('poids'));
if ($franco > 0 && $montant > $franco) {
//var_dump('franco');
$fraisPort = 0;
} else {
$fraisPort = $repo_frais_port->getFraisPort($fournisseur, $montant, $poids);
}
return new JsonResponse(['fraisPort' => $fraisPort]);
}
/**
* @Route("/fraisport/charger-tableau/{id}/{type}", name="dtc_fraisport_fournisseur_charger_tableau")
*/
public function chargerTableauAction(Request $request, Fournisseur $fournisseur)
{
$rendu = $this->renderView('Fournisseurs/FraisPort/charger_tableau.html.twig', ["fournisseur" => $fournisseur]);
return new JsonResponse(['rendu' => $rendu]);
}
}

src/Controller/Fournisseurs/FraisPortController.php line 212