<?php
namespace App\Controller\Articles;
use App\Entity\Articles\Article;
use App\Entity\Articles\ArticleCategorie;
use App\Entity\Articles\Categorie;
use App\Entity\Articles\PrixDegressif;
use App\Entity\Fournisseurs\Fournisseur;
use App\Form\Articles\PrixDegressifType;
use App\Form\Articles\SupprimerPrixDegressifType;
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\Request;
use Symfony\Component\HttpFoundation\JsonResponse;
use Symfony\Component\HttpFoundation\Response;
use Symfony\Component\Routing\Annotation\Route;
use Symfony\Component\Validator\Validator\ValidatorInterface;
use Symfony\Contracts\Translation\TranslatorInterface;
class PrixDegressifController extends AbstractController
{
/**
* @Route("", name="")
*/
public function getPrixArticlePrixDegressifAction(Fournisseur $fournisseur, Article $article)
{
$prix = "";
foreach ($article->getConditionsAchat() as $c) {
//echo "<div>TEST ==> ".$fournisseur->getId()." ::: </div>";
if ($fournisseur->getId() == $c->getFournisseur()->getId()) {
$prix = $c->getPrixAchatNet();
$prix = number_format($prix, 2, '.', ' ');
$prix .= " €";
}
}
return new JsonResponse(['prix' => $prix]);
}
/**
* @Route("/prix-degressif/nouveau/{id}/{type}", name="dtc_prix_degressif_ajouter")
*/
public function ajouterAction(Request $request, $id, $type = "", EntityManagerInterface $em, TranslatorInterface $translator, ValidatorInterface $validator)
{
$titre_modal = $translator->trans("Nouveau prix degressif");
$repo_objet = $em->getRepository(Article::class);
$get = $request->query->all();
$prixDegressif = new PrixDegressif();
$objet = $repo_objet->find($id);
if (is_object($objet)) {
$prixDegressif->setArticle($objet);
//$prixDegressif->setLibelle($objet->getLibelle());
}
$user = $this->getUser();
//$prixDegressif->setUtilisateur($user);
$form = $this->createForm(PrixDegressifType::class, $prixDegressif);
$errors = "";
$form->handleRequest($request);
if ($form->isSubmitted()) {
if ($form->isValid()) {
if ($type == 'article') {
$repo_objet = $em->getRepository(Article::class);
$objet = $repo_objet->find($id);
$url = $this->generateUrl('dtc_article_modifier', ['id' => $objet->getId(), 'tab' => 'prixDegressif']);
}
$em->persist($prixDegressif);
$em->persist($objet);
$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"]],
200,
['Content-Type' => 'application/json']);
} else {
$this->addFlash('notice', $translator->trans('Prix dégressif ajouté avec succès !'));
return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
}
} else {
$errors = $validator->validate($prixDegressif);
$rendu = $this->renderView(
'Articles/PrixDegressif/ajouter.html.twig',
['form' => $form->createView(), 'errors' => $errors, 'id' => $id, 'type' => $type, 'prixDegressif' => $prixDegressif]
);
return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
}
}
$rendu = $this->renderView(
'Articles/PrixDegressif/ajouter.html.twig',
['form' => $form->createView(), 'errors' => $errors, 'id' => $id, 'type' => $type, 'prixDegressif' => $prixDegressif]
);
return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
//return $this->render('Articles/PrixDegressif/ajouter.html.twig', array('form' => $form->createView(),'errors'=>$errors,'id'=>$id,'type'=>$type));
}
/**
* @Route("/prix-degressif/modifier/{objet}/{id}/{type}", name="dtc_prix_degressif_modifier")
*/
public function modifierAction(Request $request, PrixDegressif $objet, $id, $type, EntityManagerInterface $em, TranslatorInterface $translator, ValidatorInterface $validator)
{
$prixDegressif = $objet;
$titre_modal = $translator->trans("Modifier le prix dégressif");
$get = $request->query->all();
$user = $this->getUser();
// $prixDegressif->setUtilisateur($user);
$form = $this->createForm(PrixDegressifType::class, $prixDegressif);
$errors = "";
$form->handleRequest($request);
if ($form->isSubmitted()) {
$droit = $this->isGranted(EntityVoter::UPDATE, PrixDegressif::class);
/*
if(!$droit) {
$rendu = $this->renderView('Articles/PrixDegressif/ajouter.html.twig', array('form' => $form->createView(),'errors'=>$errors,'id'=>$id,'type'=>$type,'objet'=>$objet));
return new Response(json_encode(array('rendu'=>$rendu,'valide'=>'0','url'=>'','titre'=>$titre_modal)), 200, array('Content-Type'=>'application/json'));
}
*/
if ($form->isValid()) {
if ($type == 'article') {
$repo_objet = $em->getRepository(Article::class);
$article = $repo_objet->find($id);
$url = $this->generateUrl('dtc_article_modifier', ['id' => $article->getId(), 'tab' => 'prixDegressifVente']);
}
$em->persist($prixDegressif);
$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"]],
200,
['Content-Type' => 'application/json']);
} else {
$this->addFlash('notice', $translator->trans('Prix dégressif modifié avec succès !'));
return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
}
} else {
$errors = $validator->validate($prixDegressif);
$rendu = $this->renderView(
'Articles/PrixDegressif/ajouter.html.twig',
['form' => $form->createView(), 'errors' => $errors, 'id' => $id, 'type' => $type, 'objet' => $objet, 'prixDegressif' => $prixDegressif]
);
return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
}
}
$rendu = $this->renderView(
'Articles/PrixDegressif/ajouter.html.twig',
['form' => $form->createView(), 'errors' => $errors, 'id' => $id, 'type' => $type, 'objet' => $objet, 'prixDegressif' => $prixDegressif]
);
return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
}
/**
* @Route("/prix-degressif/supprimer/{objet}/{id}/{type}", name="dtc_prix_degressif_supprimer")
*/
public function supprimerAction(Request $request, PrixDegressif $objet, $id, $type, EntityManagerInterface $em, TranslatorInterface $translator, ValidatorInterface $validator)
{
$prixDegressif = $objet;
$titre_modal = $translator->trans("Demande de confirmation");
$user = $this->getUser();
$get = $request->query->all();
$form = $this->createForm( SupprimerPrixDegressifType::class, $prixDegressif);
$errors = "";
$form->handleRequest($request);
if ($form->isSubmitted()) {
if ($form->isValid()) {
$em->remove($prixDegressif);
$em->flush();
if ($type == 'article') {
$url = $this->generateUrl('dtc_article_modifier', ['id' => $id, 'tab' => 'prixDegressifVente']);
}
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('Prix dégressif supprimé avec succès !'));
return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
}
} else {
$errors = $validator->validate($prixDegressif);
$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("/prix-degressif/charger-tableau/{id}/{type}", name="dtc_prix_degressif_charger_tableau")
*/
public function chargerTableauAction(Request $request, $id = "0", $type = "a")
{
$rendu = $this->renderView('Articles/PrixDegressif/charger_tableau.html.twig', ["id" => $id, "type" => $type]);
return new JsonResponse(['rendu' => $rendu]);
}
/**
* @Route("/prix-degressif", name="dtc_prix_degressif_liste")
*/
public function listerAction(Request $request, $id = "0", $type = "a", EntityManagerInterface $em, Datatable $datatable, TranslatorInterface $translator )
{
$tableau_class_cellule = [];
/*
$tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(0),"visible"=>true);
$tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(1),"visible"=>true);
$tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(2),"visible"=>true);
$tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(3),"visible"=>true);
$tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(4),"visible"=>true);
$tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(5),"visible"=>true);
$tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(6),"visible"=>true);
$tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(7),"visible"=>true);
$tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(8),"visible"=>true);
$tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(9),"visible"=>true);
$tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(10),"visible"=>true);
$tableau_class_cellule[]=array("searchable"=> false,"className"=>"visible_export colonne_id","targets"=>array(11),"visible"=>true);
$tableau_class_cellule[]=array("orderable"=> false,"searchable"=> false,"className"=>" colonne_id","targets"=>array(12),"visible"=>true);
*/
$modal = $request->query->get('modal');
$articleId = $request->query->get('id');
$qte = $request->query->get('qte');
if ($type == "article") {
$repo_objet = $em->getRepository(Article::class);
}
if ($type == "fournisseur") {
$repo_objet = $em->getRepository(Fournisseur::class);
}
$objet = $repo_objet->find($id);
if ($articleId != '') {
$article = $repo_objet->find($articleId);
if ($modal == 1 && is_object($article)) {
$titre_modal = $translator->trans('Prix dégressif');
$this->datatableArticle($article, $type,$datatable, $translator);
$rendu = $this->renderView(
'Articles/PrixDegressif/lister.html.twig',
['tableauClassColonne' => $tableau_class_cellule, "id" => $articleId, "type" => $type, 'qte' => $qte]
);
//$rendu = $this->renderView('FO/Supprimer/supprimer.html.twig', array('form' => $form->createView(),'errors'=>$errors,'id'=>$id,'type'=>$type,'objet'=>$objet));
return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
}
}
if (is_object($objet)) {
if ($type == "article") {
$tableau_class_cellule = [];
$tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id", "targets" => [0], "visible" => false];
$tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id text-left", "targets" => [1], "visible" => true];
$tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id text-center", "targets" => [2], "visible" => true];
$tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id text-center", "targets" => [3], "visible" => true];
$tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id text-right", "targets" => [4], "visible" => true];
$tableau_class_cellule[] = ["searchable" => true, "className" => "visible_export colonne_id text-center", "targets" => [5], "visible" => true];
$this->datatableArticle($objet, $type, $datatable, $translator);
}
return $this->render('Articles/PrixDegressif/lister.html.twig', ['tableauClassColonne' => $tableau_class_cellule, "id" => $id, "type" => $type]);
} else {
$this->datatable( $datatable, $translator);
return $this->render('Articles/PrixDegressif/lister.html.twig', ['tableauClassColonne' => $tableau_class_cellule, "id" => $id, "type" => $type]);
}
}
/**
* set datatable configs
*
* @return \App\Library\Datatable\Util\Datatable
*/
private function datatable(Datatable $datatable, TranslatorInterface $translator)
{
$datatable->setDatatableId('dta-prix-degressif')
->setEntity(PrixDegressif::class, "x")
->setFields(
[
$translator->trans("ID") => 'x.id',
$translator->trans("Libellé") => 'x.libelle',
$translator->trans("quantité max") => 'x.quantiteMax',
$translator->trans("Coefficient") => 'x.coefficient',
//$translator->trans("Libelle") => 'x.libelle',
$translator->trans("Actions") => 'x.id',
"_identifier_" => 'x.id',
]
)
//->addJoin('x.statutCommande', 's', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
/*->setWhere(
$type_jointure.' = :objet',
array('objet' => $objet)
)
*/
->setRenderers(
[
4 => [
'view' => 'FO/DataTable/actions.html.twig',
'params' => [
//'edit_route' => 'dtc_garantie_modifier',
//'supprimer_route' => 'dtc_garantie_supprimer',
'entite' => 'garantie',
'objet' => PrixDegressif::class,
],
],
]
)
->setOrder("x.id", "desc")
->setSearch(true)
->setSearchFields([1, 4]);
return $datatable;
}
/**
* set datatable configs
*
* @return \App\Library\Datatable\Util\Datatable
*/
private function datatableArticle($objet, $type = "", Datatable $datatable, TranslatorInterface $translator)
{
$type_jointure = 'x.'.$type;
$datatable->setDatatableId('dta-prix-degressif')
->setEntity(PrixDegressif::class, "x")
->setFields(
[
$translator->trans("ID") => 'x.id',
$translator->trans("Libellé") => 'x.libelle',
$translator->trans("Quantité max") => 'x.quantiteMax',
$translator->trans("Coefficient") => 'x.coefficient',
$translator->trans("Date début") => 'x.dateDebut',
$translator->trans("Date fin") => 'x.dateFin',
$translator->trans("Statut") => 'x.statut',
$translator->trans("Actions") => 'x.id',
"_identifier_" => 'x.id',
]
)
//->addJoin('x.pays', 'p', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
//->addJoin('f.devise', 'd', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
//->addJoin('x.uniteMesure', 'u', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
/*->setWhere(
$type_jointure.' = :objet',
array('objet' => $objet)
)
*/
->setWhere(
'x.article = :objet',
['objet' => $objet]
)
->setRenderers(
[
4 => [
'view' => 'FO/DataTable/date.html.twig',
],
5 => [
'view' => 'FO/DataTable/date.html.twig',
],
6 => [
'view' => 'FO/DataTable/statut.html.twig',
'params' => [
'edit_route' => 'dtc_prix_degressif_statut',
],
],
/*
0 => array(
'view' => 'FO/DataTable/date.html.twig',
),
1 => array(
'view' => 'FO/DataTable/avec_lien_edit_route.html.twig',
'params' => array(
'edit_route' => 'dtc_fournisseur_modifier',
'typeDocument' => 'fournisseur',
'target' => '_blank'
),
),
3 => array(
'view' => 'FO/DataTable/prix.html.twig',
),
7 => array(
'view' => 'FO/DataTable/num2chiffres.html.twig',
),
8 => array(
'view' => 'FO/DataTable/prix.html.twig',
),
10 => array(
'view' => 'FO/DataTable/prix.html.twig',
'params' => array('conversion'=>'*',
'forceEuro' => 1
)
),
15 => array(
'view' => 'FO/DataTable/statut.html.twig',
'params' => array(
'edit_route' => 'dtc_prixDegressifition_achat_statut'
)
),
*/
7 => [
'view' => 'FO/DataTable/actions_modal.html.twig',
'params' => [
'edit_route' => 'dtc_prix_degressif_modifier',
'supprimer_route' => 'dtc_prix_degressif_supprimer',
'id' => $objet->getId(),
'type' => $type,
'entite' => 'garantie',
'table' => 'dta-prix-degressif',
'objet' => PrixDegressif::class
,
'width_modal' => 800,
],
],
]
)
->setOrder("x.id", "desc")
->setSearch(true)//->setSearchFields(array(1,2))
;
return $datatable;
}
/**
* @Route("/prix-degressif/grid/{id}/{type}", name="dtc_prix_degressif_liste_grid")
*/
public function gridAction($id = "", $type = "", Datatable $datatable, TranslatorInterface $translator)
{
$em = $em;
if ($type == "article") {
$repo_objet = $em->getRepository(Article::class);
} elseif ($type == "fournisseur") {
$repo_objet = $em->getRepository(Fournisseur::class);
}
$objet = $repo_objet->find($id);
if (is_object($objet) and $type == "article") {
return $this->datatableArticle($objet, $type, $datatable, $translator)->execute();
} else {
return $this->datatable($datatable, $translator)->execute();
}
}
/**
* @Route("/prix-degressif/statut/{id}", name="dtc_prix_degressif_statut")
*/
public function changeStatutAction(PrixDegressif $prixDegressif, EntityManagerInterface $em)
{
if ($prixDegressif->getStatut() == 1) {
$prixDegressif->setStatut(0);
} else {
$prixDegressif->setStatut(1);
}
$em->persist($prixDegressif);
$em->flush();
$em->refresh($prixDegressif);
$headers = [
'Content-Type' => 'application/json',
'Access-Control-Allow-Origin' => '*',
'Access-Control-Allow-Methods' => 'POST',
];
return new JsonResponse(['data' => '1'], 200, $headers);
}
/**
* @Route("/prix-degressif/nouveau-ajax", name="dtc_prix_degressif_add_ajax")
*/
public function ajouterAjaxAction(Request $request, EntityManagerInterface $em)
{
$refArticle = $request->query->get('refArticle');
$quantiteMax = $request->query->get('quantiteMax');
$coefficient = $request->query->get('coefficient');
$finitions = [];
if ($this->getParameter('categorie_finitions')) {
$categorie_finitions = $em->getRepository(Categorie::class)->find($this->getParameter('categorie_finitions'));
$articlesCategories = $em->getRepository(ArticleCategorie::class)->findBy(['categorie' => $categorie_finitions]);
foreach ($articlesCategories as $articleCategorie) {
$finitions[] = $articleCategorie->getArticle();
}
}
$refArray = explode('-', $refArticle);
//$article = $repo_article->getArticleByRef();
$finition = null;
$ref = '';
foreach ($finitions as $finitionTmp) {
$refTmp = $refArray[1];
$pos = strpos($refTmp, $finitionTmp->getReference());
if ($pos !== false) {
$refTmp = str_replace($finitionTmp->getReference(), '', $refTmp);
if (strlen($refTmp) == $pos) {
$finition = $finitionTmp;
$ref = $refTmp;
break;
}
}
}
if ($ref != '') {
$ref .= '|';
if ( ! empty($refArray[2])) {
$ref .= $refArray[2];
}
$article = $em->getRepository(Article::class)->findOneBy(['reference' => $ref]);
if (is_object($article)) {
$prixDegressif = $em->getRepository(PrixDegressif::class)->findOneBy([
'article' => $article,
'quantiteMax' => $quantiteMax,
'finition' => $finition,
]);
if ( ! is_object($prixDegressif)) {
$prixDegressif = new prixDegressif;
$prixDegressif->setQuantiteMax($quantiteMax);
$prixDegressif->setArticle($article);
$prixDegressif->setFinition($finition);
$prixDegressif->setStatut(true);
}
$prixDegressif->setCoefficient($coefficient);
$em->persist($prixDegressif);
$em->flush();
}
}
$retour = 'ref: '.$ref;
if (is_object($finition)) {
$retour .= ' + finition '.$finition->getReference();
}
$retour .= ' -> '.$coefficient;
if ( ! empty($prixDegressif) && is_object($prixDegressif)) {
$retour .= ' / prix degressif ID '.$prixDegressif->getId();
}
return new JsonResponse(['data' => $retour]);
}
}