src/Controller/Client/ClientController.php line 198

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Client;
  6. use App\Entity\Admin;
  7. use App\Entity\Adminevent;
  8. use App\Entity\Client;
  9. use App\Entity\Clientdocument;
  10. use App\Entity\Clientrelation;
  11. use App\Entity\Clientvente;
  12. use App\Entity\Fournisseur;
  13. use App\Form\User\AdmineventType;
  14. use App\Form\User\ClientdocumentType;
  15. use App\Form\User\ClientType;
  16. use App\Utils\Dates\MalysDates;
  17. use Doctrine\ORM\EntityManagerInterface;
  18. use Knp\Component\Pager\PaginatorInterface;
  19. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  20. use Symfony\Component\HttpFoundation\JsonResponse;
  21. use Symfony\Component\HttpFoundation\Request;
  22. use Symfony\Component\Routing\Annotation\Route;
  23. /**
  24. * @Route("/client")
  25. */
  26. class ClientController extends AbstractController
  27. {
  28. private $malysDates;
  30. /**
  31. * @required
  32. */
  33. public function setMalysDates(MalysDates $malysDates)
  34. {
  35. $this->malysDates = $malysDates;
  36. }
  38. private PaginatorInterface $paginator;
  40. public function __construct(PaginatorInterface $paginator)
  41. {
  42. $this->paginator = $paginator;
  43. }
  44. /* AFFICHAGE INDEX CLIENT */
  45. /**
  46. * @Route("/index/{id}", name="malys_client_index", defaults={"id"=0})
  47. */
  48. public function indexAction($id, EntityManagerInterface $em)
  49. {
  51. /* RECUPERATION DU CLIENT EN BASE */
  52. $client = $em->getRepository(Client::class)->find($id);
  54. /* RECUPERATION DES RDV DU CLIENT */
  55. $rdv = $em->getRepository(Adminevent::class)->findBy(array('idclient' => $client, 'type' => 'rdv'), array('datefr' => 'desc'), 5, 0);
  57. /* RECUPERATION DES PROBLEMES DU CLIENT */
  58. $pbm = $em->getRepository(Adminevent::class)->findBy(array('idclient' => $client, 'type' => 'pbm'), array('datefr' => 'desc'), 5, 0);
  60. /* COORDONNEES POUR LA MAP */
  61. $geocode = explode('|', $client->getGeocode());
  62. $lat = isset($geocode[1]) ? $geocode[0] : null;
  63. $lng = isset($geocode[1]) ? $geocode[1] : null;
  66. /* annee courante par défaut */
  67. $date = date('Y');
  69. /* RECUPERATION CA CLIENT */
  70. $cv = $em->getRepository(Clientvente::class)->findMyClientCa($id, "all");
  72. /* tableau a afficher */
  73. $totalCaGenere = array();
  74. $totalCaCommission = array();
  75. $totalSolde = array();
  76. $t_ListeCA = array();
  77. $t_ListeMois = array();
  78. $t_ListeDetail = array();
  79. $t_ListeFamille = array();
  81. foreach ($cv as $v) {
  82. //echo $v[0]->getIdfournisseur()->getFamille()." // ".$v['ca_genere']."<br/>";
  83. //TABLEAU DETAILLE
  84. $t_ListeCA[intval($v[0]->getDatefr()->format('Y'))][$v[0]->getIdfournisseur()->getNom()][intval($v[0]->getDatefr()->format('m'))]['ca_genere'] = $v['ca_genere'];
  85. $t_ListeCA[intval($v[0]->getDatefr()->format('Y'))][$v[0]->getIdfournisseur()->getNom()][intval($v[0]->getDatefr()->format('m'))]['ca_commission'] = ($v[0]->getIdadmin()->getId() == $this->getUser()->getId()) ? number_format($v['ca_commission'], 2, '.', '') : 0;
  86. $t_ListeCA[intval($v[0]->getDatefr()->format('Y'))][$v[0]->getIdfournisseur()->getNom()][intval($v[0]->getDatefr()->format('m'))]['solde'] = number_format($v[0]->getSolde(), 2, '.', '');
  87. $t_ListeCA[intval($v[0]->getDatefr()->format('Y'))][$v[0]->getIdfournisseur()->getNom()]['idclient'] = $v[0]->getIdclient()->getId();
  88. $t_ListeCA[intval($v[0]->getDatefr()->format('Y'))][$v[0]->getIdfournisseur()->getNom()]['idfournisseur'] = $v[0]->getIdfournisseur()->getId();
  90. //TABLEAU CA PAR FAMILLE
  91. if (intval($v[0]->getDatefr()->format('Y')) == $date)
  92. ($v[0]->getIdfournisseur()->getFamille() != "") ? $t_ListeFamille[$v[0]->getIdfournisseur()->getFamille()] += $v['ca_genere'] : $t_ListeFamille["Autre"] += $v['ca_genere'];
  94. //TABLEAU MOIS PAR MOIS
  95. if (!isset($t_ListeMois[intval($v[0]->getDatefr()->format('Y'))][intval($v[0]->getDatefr()->format('m'))]))
  96. $t_ListeMois[intval($v[0]->getDatefr()->format('Y'))][intval($v[0]->getDatefr()->format('m'))] = array('ca_genere' => 0, 'ca_commission' => 0, 'solde' => 0);
  97. $t_ListeMois[intval($v[0]->getDatefr()->format('Y'))][intval($v[0]->getDatefr()->format('m'))]['ca_genere'] += number_format($v['ca_genere'], 2, '.', '');
  98. $t_ListeMois[intval($v[0]->getDatefr()->format('Y'))][intval($v[0]->getDatefr()->format('m'))]['ca_commission'] += ($v[0]->getIdadmin()->getId() == $this->getUser()->getId()) ? number_format($v['ca_commission'], 2, '.', '') : 0;
  99. $t_ListeMois[intval($v[0]->getDatefr()->format('Y'))][intval($v[0]->getDatefr()->format('m'))]['solde'] += number_format($v[0]->getSolde(), 2, '.', '');
  101. // TOTAUX
  103. if (isset($totalCaGenere[intval($v[0]->getDatefr()->format('Y'))])) {
  104. $totalCaGenere[intval($v[0]->getDatefr()->format('Y'))] += number_format($v['ca_genere'], 2, '.', '');
  105. } else {
  106. $totalCaGenere[intval($v[0]->getDatefr()->format('Y'))] = number_format($v['ca_genere'], 2, '.', '');
  107. }
  109. if (isset($totalCaGenere[intval($v[0]->getDatefr()->format('Y'))])) {
  110. $totalCaCommission[intval($v[0]->getDatefr()->format('Y'))] += ($v[0]->getIdadmin()->getId() == $this->getUser()->getId()) ? number_format($v['ca_commission'], 2, '.', '') : 0;
  111. $totalSolde[intval($v[0]->getDatefr()->format('Y'))] += number_format($v[0]->getSolde(), 2, '.', '');
  112. } else {
  113. $totalCaCommission[intval($v[0]->getDatefr()->format('Y'))] = ($v[0]->getIdadmin()->getId() == $this->getUser()->getId()) ? number_format($v['ca_commission'], 2, '.', '') : 0;
  114. $totalSolde[intval($v[0]->getDatefr()->format('Y'))] = number_format($v[0]->getSolde(), 2, '.', '');
  115. }
  116. //TABLEAU PAR TYPE DETAIL
  117. if (!isset($t_ListeDetail[intval($v[0]->getDatefr()->format('Y'))][$v[0]->getIdfournisseur()->getNom()]))
  118. $t_ListeDetail[intval($v[0]->getDatefr()->format('Y'))][$v[0]->getIdfournisseur()->getNom()] = array('ca_genere' => 0, 'ca_commission' => 0, 'solde' => 0);
  119. $t_ListeDetail[intval($v[0]->getDatefr()->format('Y'))][$v[0]->getIdfournisseur()->getNom()]['ca_genere'] += number_format($v['ca_genere'], 2, '.', '');
  120. $t_ListeDetail[intval($v[0]->getDatefr()->format('Y'))][$v[0]->getIdfournisseur()->getNom()]['ca_commission'] += ($v[0]->getIdadmin()->getId() == $this->getUser()->getId()) ? number_format($v['ca_commission'], 2, '.', '') : 0;
  121. $t_ListeDetail[intval($v[0]->getDatefr()->format('Y'))][$v[0]->getIdfournisseur()->getNom()]['solde'] += number_format($v[0]->getSolde(), 2, '.', '');
  122. }
  124. //CREATE JSON AND ORDER T_CHART_FAMILLE
  125. $t_ca_famille = array();
  126. foreach ($t_ListeFamille as $key => $value) {
  127. array_push($t_ca_famille, array($key, $value));
  128. }
  129. $volume = array();
  130. foreach ($t_ca_famille as $key => $row) {
  131. $volume[$key] = $row[1];
  132. $edition[$key] = $row[0];
  133. }
  134. if ($volume) {
  135. array_multisort($volume, SORT_DESC, $edition, SORT_ASC, $t_ca_famille);
  136. }
  137. $t_ListeFamille = array();
  138. array_push($t_ListeFamille, (object)array('type' => 'pie', 'name' => 'Famille', 'data' => $t_ca_famille));
  139. $t_famille_chart_json = json_encode($t_ListeFamille);
  141. //INSERT DIFF
  142. for ($i = $date - 2; $i <= $date; $i++) {
  144. if (isset($t_ListeCA[$i])) {
  145. foreach ($t_ListeCA[$i] as $key => $v) {
  146. for ($j = 1; $j <= 12; $j++) {
  147. if (isset($t_ListeCA[$i][$key][$j - 1]['ca_genere']) && isset($t_ListeCA[$i][$key][$j]['ca_genere'])) {
  148. $t_ListeCA[$i][$key][$j]['diff'] = number_format(($t_ListeCA[$i][$key][$j]['ca_genere'] - $t_ListeCA[$i][$key][$j - 1]['ca_genere']) / $t_ListeCA[$i][$key][$j - 1]['ca_genere'] * 100, 2, '.', '');
  149. }
  150. }
  151. }
  152. }
  153. }
  155. //CREATE JSON FOR CHART CA
  156. $t_ca_chart = array();
  157. foreach ($t_ListeMois as $key => $item_ca) {
  158. $t_ca = array();
  159. for ($i = 1; $i <= 12; $i++) {
  161. (isset($item_ca[$i]['ca_genere']) && intval($item_ca[$i]['ca_genere']) != 0) ? array_push($t_ca, $item_ca[$i]['ca_genere']) : array_push($t_ca, null);
  162. }
  163. ($key == date("Y")) ? array_push($t_ca_chart, (object)array('name' => $key, 'data' => $t_ca)) : array_push($t_ca_chart, (object)array('name' => $key, 'visible' => false, 'data' => $t_ca));
  165. }
  166. $t_ca_chart_json = json_encode($t_ca_chart);
  169. /* mois du tableau */
  170. $tab_mois_fr = $this->malysDates->getTabMoisFr();
  172. return $this->render('client/index.html.twig', array(
  173. 'lat' => $lat,
  174. 'lng' => $lng,
  175. 'client' => $client,
  176. 'rdv' => $rdv,
  177. 'pbm' => $pbm,
  178. 'user' => $this->getUser()->getFamille(),
  180. 't_ListeCA' => $t_ListeCA,
  181. 't_ListeMois' => $t_ListeMois,
  182. 't_ListeDetail' => $t_ListeDetail,
  183. 'tab_mois_fr' => $tab_mois_fr,
  184. 'totalCaGenere' => $totalCaGenere,
  185. 'totalSolde' => $totalSolde,
  186. 'totalCaCommission' => $totalCaCommission,
  188. 't_famille_chart_json' => $t_famille_chart_json,
  189. 't_ca_chart_json' => $t_ca_chart_json
  190. ));
  191. }
  193. /* AJOUT/MODIFICATION DE CLIENT */
  195. /**
  196. * @Route("/modifier/{id}", name="malys_client_modify", defaults={"id"=0})
  197. */
  198. public function modifyAction($id, Request $request, EntityManagerInterface $em)
  199. {
  201. if ($id)
  202. $client = $em->getRepository(Client::class)->find($id);
  203. else
  204. $client = new Client;
  206. if ($id && $this->isGranted('ROLE_ADMIN'))
  207. $form = $this->createForm(ClientType::class, $client, ['prospect' => $client->getProspect(), 'isAdmin' => false]);
  208. else
  209. $form = $this->createForm(ClientType::class, $client, [
  210. 'prospect' => $client->getProspect(),
  211. 'isAdmin' => true
  212. ]);
  215. if ($request->getMethod() == 'POST') {
  216. $form->handleRequest($request);
  218. if ($form->isValid()) {
  220. if (!$client->getProspect() && $form->get('sameAsAdresse')->getData()) {
  221. $client->setAdresseFacturation($client->getAdresse());
  222. $client->setCpFacturation($client->getCp());
  223. $client->setVilleFacturation($client->getVille());
  224. }
  225. /* EST */
  226. if ($client->getDateclientfr() == null)
  227. $client->setDateclientfr($client->getDatefr());
  229. if ($client->getIdadmin() == null)
  230. $client->setIdadmin($this->getUser());
  232. $em->persist($client);
  233. $em->flush();
  235. return $this->redirect($this->generateUrl('malys_client_show', array('id' => $client->getId())));
  236. }
  237. }
  239. return $this->render('client/modify.html.twig', array('form' => $form->createView(), 'client' => $client));
  240. }
  243. /* AFFICHAGE FICHE CLIENT */
  244. /**
  245. * @Route("/voir/{id}", name="malys_client_show")
  246. */
  247. public function showAction($id, EntityManagerInterface $em)
  248. {
  249. /* RECUPERATION DU CLIENT EN BASE */
  250. $client = $em->getRepository(Client::class)->find($id);
  252. /* RECUPERATION DES DOCUMENTS DU CLIENT */
  253. $docs = $em->getRepository(Clientdocument::class)->findClientDocuments($id);
  255. /* RECUPERATION DES RDV DU CLIENT */
  256. $rdv = $em->getRepository(Adminevent::class)->findBy(array('idclient' => $client, 'type' => 'rdv'), array('datefr' => 'desc'), 5, 0);
  258. /* RECUPERATION DES PROBLEMES DU CLIENT */
  259. $pbm = $em->getRepository(Adminevent::class)->findBy(array('idclient' => $client, 'type' => 'pbm'), array('datefr' => 'desc'), 5, 0);
  261. /* COORDONNEES POUR LA MAP */
  262. $geocode = explode('|', $client->getGeocode());
  263. $lat = isset($geocode[1]) ? $geocode[0] : null;
  264. $lng = isset($geocode[1]) ? $geocode[1] : null;
  266. $tab_fonction = array(
  267. 1 => 'Chef',
  268. 2 => 'Patron',
  269. 3 => 'Resp Bar',
  270. 4 => 'Gerant',
  271. 5 => 'Autre'
  272. );
  274. $tab_typeaffaire = array('0' => 'Restaurant traditionnel', '1' => 'VAE', '2' => 'Bitrot <100 couverts/jours', '3' => 'Brasserie', '4' => 'Bar pur', '5' => 'Hotel', '6' => 'Boite de nuit', '7' => 'Traiteur', '8' => 'Autre');
  276. $tab_typecontrat = array(
  277. 1 => 'Pret',
  278. 2 => 'MaD',
  279. 3 => 'Avance sur remise'
  280. );
  281. $relations = $em->getRepository(Clientrelation::class)->findBy(array('idclient' => $id));
  283. return $this->render('client/show.html.twig', array(
  284. 'lat' => $lat,
  285. 'lng' => $lng,
  286. 'client' => $client,
  287. 'rdv' => $rdv,
  288. 'pbm' => $pbm,
  289. 'docs' => $docs,
  290. 'tab_fonction' => $tab_fonction,
  291. 'tab_typeaffaire' => $tab_typeaffaire,
  292. 'tab_typecontrat' => $tab_typecontrat,
  293. 'relations' => $relations,
  294. //'contrat' => $client.contrat
  296. ));
  297. }
  299. /* PASSE PROSPECT EN CLIENT */
  300. /**
  301. * @Route("/passer_en_client/{id}", name="malys_client_siwtchToClient")
  302. */
  303. public function swicthToClientAction($id,Request $request, EntityManagerInterface $em)
  304. {
  305. $client = $em->getRepository(Client::class)->find($id);
  307. if (!$client) {
  308. throw $this->createNotFoundException('Client non trouvé');
  309. }
  310. $client->setSameAsAdresse(false);
  312. // Créer un formulaire pour le client
  313. if ($id && $this->isGranted('ROLE_ADMIN'))
  314. $form = $this->createForm(ClientType::class, $client, [
  315. 'prospect' => $client->getProspect(),
  316. 'isAdmin' => true
  317. ]);
  318. else
  319. $form = $this->createForm(ClientType::class, $client, [
  320. 'prospect' => $client->getProspect(),
  321. 'isAdmin' => false
  322. ]);
  323. // Soumettre le formulaire si la requête est POST
  324. $client->setProspect(0);
  325. $client->setNote(0);
  326. $client->setActivite(1);
  327. $client->setDateclientfr(new \DateTime("now"));
  330. $em->persist($client);
  331. $em->flush();
  333. if ($request->getMethod() == 'POST') {
  334. $form->handleRequest($request);
  336. if ($form->isValid()) {
  337. $em->persist($client);
  338. $em->flush();
  340. // Redirection vers la page du client
  341. return $this->redirect($this->generateUrl('malys_client_show', array('id' => $id)));
  342. }
  343. }
  345. // Si le formulaire n'est pas valide, on retourne à la page de modification du client avec les erreurs
  346. return $this->render('client/modify.html.twig', array('form' => $form->createView(), 'client' => $client));
  348. }
  351. /* LIEN FOURNISSEURS */
  352. /**
  353. * @Route("/fournisseurs/{id}", name="malys_client_fournisseurs")
  354. */
  355. public function linkSupplierAction($id,Request $request, EntityManagerInterface $em)
  356. {
  357. $client = $em->getRepository(Client::class)->find($id);
  358. $clientrelation = $em->getRepository(Clientrelation::class)->findByIdclient($id);
  359. $fournisseurs = $em->getRepository(Fournisseur::class)->findBySource($client->getSource(), array('nom' => 'asc'));
  361. /* LIEN DES FOURNISSEURS */
  362. $rel = array();
  363. foreach ($clientrelation as $c)
  364. $rel[$c->getIdfournisseur()->getId()] = $c->getCode();
  366. $pdf = $this->get('white_october.tcpdf')->create();
  368. if ($request->getMethod() == 'POST') {
  369. $em->createQuery("DELETE App\Entity\Clientrelation r WHERE r.idclient = " . $id)->execute();
  371. $chcode = $request->request->get('chcode');
  372. $chclient = $request->request->get('chclient');
  374. foreach ($chclient as $key => $val) {
  375. $r = new Clientrelation;
  376. $r->setCode(isset($chcode[$key]) ? $chcode[$key] : '');
  377. $r->setIdclient($client);
  378. $r->setIdfournisseur($this->getFournisseur($fournisseurs, $val));
  380. $client = $em->getRepository(Client::class)->find($id);
  381. $joursLivraison = $client->getJoursLivraison();
  382. // Doctrine gère automatiquement la désérialisation JSON
  384. $fournisseur = $em->getRepository(Fournisseur::class)->find($r->getIdfournisseur()->getId());
  386. // Générer le contenu HTML avec le moteur Twig
  387. $html = $this->render('client/ouverture.html.twig', [
  388. 'title' => 'Fiche ouverture de compte Adhérent / MALYS-PRESTACHEF',
  389. 'client' => $client,
  390. 'fournisseur' => $fournisseur,
  391. 'joursLivraison' => is_array($joursLivraison) ? $joursLivraison : [],
  392. ])->getContent(); // récupère le contenu HTML généré
  394. // Ajouter une page au PDF
  395. $pdf->AddPage('P', 'A4'); // Orientation portrait, taille A4
  397. // Désactiver les marges pour occuper toute la page
  398. $pdf->SetAutoPageBreak(false); // Désactive la rupture automatique de page
  399. // Écrire le contenu HTML dans le PDF
  400. $pdf->writeHTML($html); // Appeler cette méthode sur l'objet TCPDF
  402. // 📌 Spécifier le chemin de sauvegarde
  403. $documentPath = $this->getParameter('kernel.project_dir') . '/public/documents'; // Répertoire de sauvegarde
  405. // Créer le nom du fichier PDF avec un nom dynamique (par exemple, basé sur l'ID du client)
  406. $pdfFileName = 'fiche_ouverture_' . $client->getId() . '.pdf';
  408. // 📌 Sauvegarder le fichier PDF dans le répertoire spécifié
  409. $pdf->Output($documentPath . $pdfFileName, 'F'); // 'F' pour enregistrer le fichier sur le système
  410. $r->setFichierOuverture($documentPath . $pdfFileName); // Enregistrez le chemin du fichier
  411. echo $documentPath . $pdfFileName;
  412. exit;
  413. $em->persist($r);
  415. }
  416. $em->flush();
  419. return $this->redirect($this->generateUrl('malys_client_fournisseurs', array('id' => $client->getId())));
  420. }
  422. return $this->render('client/fournisseurs.html.twig', array('client' => $client, 'fournisseurs' => $fournisseurs, 'clientrelation' => $rel));
  423. }
  425. /* CA GENERE */
  427. /**
  428. * @Route("/ca/{id}/{date}", name="malys_client_ca", defaults={"date"=0})
  429. */
  430. public function caAction($id, $date, EntityManagerInterface $em)
  431. {
  432. /* annee courante par défaut */
  433. if ($date == 0)
  434. $date = date('Y');
  436. $client = $em->getRepository(Client::class)->find($id);
  437. $cv = $em->getRepository(Clientvente::class)->findMyClientCa($id, $date);
  440. /* tableau a afficher */
  441. $totalCaGenere = 0;
  442. $totalCaCommission = 0;
  443. $totalSolde = 0;
  444. $t_ListeCA = array();
  445. $t_ListeMois = array();
  446. $t_ListeDetail = array();
  447. foreach ($cv as $v) {
  449. //TABLEAU DETAILLE
  450. $t_ListeCA[$v[0]->getIdfournisseur()->getNom()][intval($v[0]->getDatefr()->format('m'))]['ca_genere'] = $v['ca_genere'];
  451. $t_ListeCA[$v[0]->getIdfournisseur()->getNom()][intval($v[0]->getDatefr()->format('m'))]['ca_commission'] = ($v[0]->getIdadmin()->getId() == $this->getUser()->getId()) ? number_format($v['ca_commission'], 2, '.', '') : 0;
  452. $t_ListeCA[$v[0]->getIdfournisseur()->getNom()][intval($v[0]->getDatefr()->format('m'))]['solde'] = number_format($v[0]->getSolde(), 2, '.', '');
  453. $t_ListeCA[$v[0]->getIdfournisseur()->getNom()]['idclient'] = $v[0]->getIdclient()->getId();
  454. $t_ListeCA[$v[0]->getIdfournisseur()->getNom()]['idfournisseur'] = $v[0]->getIdfournisseur()->getId();
  456. //TABLEAU MOIS PAR MOIS
  457. if (!isset($t_ListeMois[intval($v[0]->getDatefr()->format('m'))]))
  458. $t_ListeMois[intval($v[0]->getDatefr()->format('m'))] = array('ca_genere' => 0, 'ca_commission' => 0, 'solde' => 0);
  459. $t_ListeMois[intval($v[0]->getDatefr()->format('m'))]['ca_genere'] += number_format($v['ca_genere'], 2, '.', '');
  460. $t_ListeMois[intval($v[0]->getDatefr()->format('m'))]['ca_commission'] += ($v[0]->getIdadmin()->getId() == $this->getUser()->getId()) ? number_format($v['ca_commission'], 2, '.', '') : 0;
  461. $t_ListeMois[intval($v[0]->getDatefr()->format('m'))]['solde'] += number_format($v[0]->getSolde(), 2, '.', '');
  463. // TOTAUX
  464. $totalCaGenere += number_format($v['ca_genere'], 2, '.', '');
  465. $totalCaCommission += ($v[0]->getIdadmin()->getId() == $this->getUser()->getId()) ? number_format($v['ca_commission'], 2, '.', '') : 0;
  466. $totalSolde += number_format($v[0]->getSolde(), 2, '.', '');
  468. //TABLEAU PAR TYPE DETAIL
  469. if (!isset($t_ListeDetail[$v[0]->getIdfournisseur()->getNom()]))
  470. $t_ListeDetail[$v[0]->getIdfournisseur()->getNom()] = array('ca_genere' => 0, 'ca_commission' => 0, 'solde' => 0);
  471. $t_ListeDetail[$v[0]->getIdfournisseur()->getNom()]['ca_genere'] += number_format($v['ca_genere'], 2, '.', '');
  472. $t_ListeDetail[$v[0]->getIdfournisseur()->getNom()]['ca_commission'] += ($v[0]->getIdadmin()->getId() == $this->getUser()->getId()) ? number_format($v['ca_commission'], 2, '.', '') : 0;
  473. $t_ListeDetail[$v[0]->getIdfournisseur()->getNom()]['solde'] += number_format($v[0]->getSolde(), 2, '.', '');
  474. }
  476. /* selecteur de date */
  477. $begin = date("Y", time()) - 3;
  478. $end = date("Y", time()) + 1;
  480. /* mois du tableau */
  481. $tab_mois_fr = $this->malysDates->getTabMoisFr();
  483. return $this->render('client/ca.html.twig', array(
  484. 'date' => $date,
  485. 'client' => $client,
  486. 'begin' => $begin,
  487. 'end' => $end,
  488. 't_ListeCA' => $t_ListeCA,
  489. 't_ListeMois' => $t_ListeMois,
  490. 't_ListeDetail' => $t_ListeDetail,
  491. 'tab_mois_fr' => $tab_mois_fr,
  492. 'totalCaGenere' => $totalCaGenere,
  493. 'totalSolde' => $totalSolde,
  494. 'totalCaCommission' => $totalCaCommission
  495. ));
  496. }
  498. /* AJOUT/MODIFICATION D'EVENEMENT */
  500. /**
  501. * @Route("/ajouter_event/{id_client}/{type}/{id_event}", name="malys_client_addevent", defaults={"id_event"=0})
  502. */
  503. public function addEventAction($id_client, $id_event, $type,Request $request, EntityManagerInterface $em)
  504. {
  505. if ($id_event)
  506. $event = $em->getRepository(Adminevent::class)->find($id_event);
  507. else
  508. $event = new Adminevent;
  510. $client = $em->getRepository(Client::class)->find($id_client);
  512. $form = $this->createForm(AdmineventType::class, $event, [
  513. 'prospect' => $client->getProspect(),
  514. 'type' => $type,
  515. 'em' => $em,
  516. ]);
  517. if ($request->getMethod() == 'POST') {
  518. $form->handleRequest($request);
  520. if ($form->isValid()) {
  521. $event->setType($request->get('chtype'));
  522. $event->setIdadmin($this->getUser());
  523. $event->setIdclient($client);
  524. $em->persist($event);
  525. $em->flush();
  527. return $this->redirect($this->generateUrl('malys_client_show', array('id' => $client->getId())));
  528. }
  529. }
  531. return $this->render('client/addEvent.html.twig', array('form' => $form->createView(), 'client' => $client, 'type' => $type));
  532. }
  534. /* SUPPRESSION D'UN EVENEMENT */
  536. /**
  537. * @Route("/supprimer_event/{id_client}/{id_event}", name="malys_client_delevent")
  538. */
  539. public function delEventAction($id_client, $id_event, EntityManagerInterface $em)
  540. {
  541. $event = $em->getRepository(Adminevent::class)->find($id_event);
  543. $em->remove($event);
  544. $em->flush();
  546. return $this->redirect($this->generateUrl('malys_client_show', array('id' => $id_client)));
  547. }
  549. /* AJOUT DE DOCUMENT */
  550. /**
  551. * @Route("/ajouter_document/{id_client}", name="malys_client_adddoc")
  552. */
  553. public function addDocAction($id_client, Request $request, EntityManagerInterface $em)
  554. {
  555. $doc = new Clientdocument();
  556. $client = $em->getRepository(Client::class)->find($id_client);
  558. $form = $this->createForm( ClientdocumentType::class, $doc);
  560. if ($request->isMethod('POST')) {
  561. $form->handleRequest($request);
  562. if ($form->isValid()) {
  564. $doc->upload($client->getId());
  565. $doc->setIdclient($client);
  567. $em->persist($doc);
  568. $em->flush();
  570. return $this->redirect($this->generateUrl('malys_client_show', array('id' => $id_client)));
  571. }
  572. }
  574. return $this->render('client/addDoc.html.twig', array('form' => $form->createView(), 'client' => $client));
  575. }
  577. /* SUPPRESSION D'UN DOCUMENT */
  578. /**
  579. * @Route("/supprimer_document/{id_client}/{id_doc}", name="malys_client_deldoc")
  580. */
  581. public function delDocAction($id_client, $id_doc, EntityManagerInterface $em)
  582. {
  583. $doc = $em->getRepository(Clientdocument::class)->find($id_doc);
  585. $doc->setEtat(0);
  587. $em->remove($doc);
  588. $em->flush();
  590. return $this->redirect($this->generateUrl('malys_client_show', array('id' => $id_client)));
  591. }
  593. /* MAINTENANCE CLIENT */
  594. /**
  595. * @Route("/admin/maintenance", name="malys_client_maintenance")
  596. */
  597. public function maintenanceAction(Request $request, EntityManagerInterface $em)
  598. {
  599. $page = $request->query->getInt('page', 1);
  600. $affiche = $request->query->getInt('affiche');
  601. $type = $request->query->getInt('type');
  602. $nom = $request->query->get('nom');
  603. //RECUPERATION DES CLIENTS
  604. $clients = $em->getRepository(Client::class)->findAllOrderByAfficheProspectNom($page, $nom, $type, $affiche, $this->paginator);
  606. return $this->render('client/maintenance.html.twig', array('clients' => $clients));
  607. }
  609. /* AFFICHE OU NON UN CLIENT */
  610. /**
  611. * @Route("/admin/affiche/{id}", name="malys_client_affiche")
  612. */
  613. public function afficheAction($id, Request $request, EntityManagerInterface $em)
  614. {
  615. $client = $em->getRepository(Client::class)->find($id);
  617. if ($client->getAffiche() == 1)
  618. $client->setAffiche(0);
  619. else
  620. $client->setAffiche(1);
  622. $em->flush();
  624. return $this->redirect($this->generateUrl('malys_client_maintenance', [
  625. 'nom' => $request->query->get('nom'),
  626. 'type' => $request->query->get('type'),
  627. 'affiche' => $request->query->get('affiche'),
  628. 'page' => $request->query->get('page'),
  629. ]));
  630. }
  632. /**
  633. * @Route("/admin/supprimer/{id}", name="malys_client_supprimer")
  634. */
  635. public function supprimerAction($id,Request $request, EntityManagerInterface $em)
  636. {
  637. $client = $em->getRepository(Client::class)->find($id);
  639. if (!$client) {
  640. throw $this->createNotFoundException('Client non trouvé.');
  641. }
  642. $ventes = $em->getRepository(Clientvente::class)->findBy(['idclient' => $client]);
  643. foreach ($ventes as $vente) {
  644. $em->remove($vente);
  645. }
  647. $em->remove($client);
  648. $em->flush();
  650. $this->addFlash('success', 'Client supprimé avec succès.');
  652. return $this->redirectToRoute('malys_client_maintenance', [
  653. 'nom' => $request->query->get('nom'),
  654. 'type' => $request->query->get('type'),
  655. 'affiche' => $request->query->get('affiche'),
  656. 'page' => $request->query->get('page'),
  657. ]); // Redirection après suppression
  658. }
  660. /**
  661. * @Route("/sans_commandes/{date}", name="malys_client_sans_commandes", defaults={"date"=0})
  662. */
  663. public function withoutOrderAction($date, EntityManagerInterface $em)
  664. {
  666. /* mois du tableau */
  667. $tab_mois_fr = $this->malysDates->getTabMoisFr();
  669. /* annee courante par défaut */
  670. if ($date == 0)
  671. $date = date('Y');
  673. //RECUPERATION DES DONNEES FACTURES
  674. $clientVente = $em->getRepository(Clientvente::class)->getAllClientsVentesInYear($date);
  676. $t_ListeCA = array();
  677. $t_ListeMois = array();
  678. $t_ListeDetail = array();
  679. foreach ($clientVente as $cv) {
  681. //TABLEAU DETAILLE
  682. $key = $cv['idClient'] . $cv['nomFournisseur'];
  683. $mois = intval($cv[0]['datefr']->format('m'));
  685. $t_ListeCA[$key][$mois]['ca_genere'] = number_format($cv[0]['montantht'], 2, '.', '');
  686. $t_ListeCA[$key]['client'] = $cv['nomClient'];
  687. $t_ListeCA[$key]['fournisseur'] = $cv['nomFournisseur'];
  688. $t_ListeCA[$key]['commercial'] = $cv['contact'];
  689. $t_ListeCA[$key]['cp'] = $cv['cpClient'];
  690. $t_ListeCA[$key]['idclient'] = $cv['idClient'];
  691. $t_ListeCA[$key]['idfournisseur'] = $cv['idFournisseur'];
  693. //TABLEAU MOIS PAR MOIS
  694. if (!isset($t_ListeMois[$mois]))
  695. $t_ListeMois[$mois] = array('ca_genere' => 0);
  696. $t_ListeMois[$mois]['ca_genere'] += number_format($cv[0]['montantht'], 2, '.', '');
  697. $t_ListeMois[$mois]['client'] = $cv['nomClient'];
  698. $t_ListeMois[$mois]['fournisseur'] = $cv['nomFournisseur'];
  699. $t_ListeMois[$mois]['commercial'] = $cv['contact'];
  700. $t_ListeMois[$mois]['cp'] = $cv['cpClient'];
  702. //TABLEAU PAR TYPE DETAIL
  703. if (!isset($t_ListeDetail[$key]))
  704. $t_ListeDetail[$key] = array('ca_genere' => 0);
  705. $t_ListeDetail[$key]['ca_genere'] += number_format($cv[0]['montantht'], 2, '.', '');
  706. $t_ListeDetail[$key]['client'] = $cv['nomClient'];
  707. $t_ListeDetail[$key]['fournisseur'] = $cv['nomFournisseur'];
  708. $t_ListeDetail[$key]['commercial'] = $cv['contact'];
  709. $t_ListeDetail[$key]['cp'] = $cv['cpClient'];
  710. }
  712. /* selecteur de date */
  713. $begin = date("Y", time()) - 3;
  714. $end = date("Y", time()) + 1;
  716. return $this->render('client/withoutOrder.html.twig', array(
  717. 'begin' => $begin,
  718. 'end' => $end,
  719. 'date' => $date,
  720. 'tab_mois_fr' => $tab_mois_fr,
  721. 't_ListeCA' => $t_ListeCA,
  722. 't_ListeMois' => $t_ListeMois,
  723. 't_ListeDetail' => $t_ListeDetail,
  724. ));
  725. }
  727. /* AFFICHAGE DE LA MAP CLIENT */
  728. /**
  729. * @Route("/carte", name="malys_client_map")
  730. */
  731. public function mapAction(Request $request, EntityManagerInterface $em)
  732. {
  734. //RECUPERATION DES UTILISATEURS POUR LISTE DEROULANTE
  735. $admins = $em->getRepository(Admin::class)->findAllOrderByContact();
  737. /* GENERATION DE LA LISTE CLIENT */
  738. $t_emplacements = array();
  739. $t_clients = array();
  740. if ($request->getMethod() == 'POST') {
  742. $clients = $em->getRepository(Client::class)->findClientsForMap($request->get('chtype'), $request->get('chcp'), $request->get('chactivite'), $request->get('chnote'), $request->get('chidadmin'));
  744. foreach ($clients as $c) {
  745. $t_geoloc = explode("|", $c->getGeocode());
  746. if ($c->getGeocode() != '0|0' && count($t_geoloc) == 2 && $t_geoloc[0] != 0 && $t_geoloc[1] != 0)
  747. $t_emplacements[] = "'" . str_replace("'", "", $c->getNom() . " - " . $c->getIdadmin()->getContact()) . "' , " . $t_geoloc[0] . ", " . $t_geoloc[1] . ", 1";
  748. $t_clients[] = str_replace("'", "", $c->getNom() . " - " . $c->getIdadmin()->getContact());
  749. }
  750. }
  752. return $this->render('client/map.html.twig', array(
  753. 'admins' => $admins,
  754. 't_emplacements' => $t_emplacements,
  755. 't_clients' => $t_clients,
  756. ));
  757. }
  759. /* CALCUL DES GEOCODES */
  760. /**
  761. * @Route("/calcul_geocode", name="malys_client_geocode")
  762. */
  763. public function calcGeocodeAction(EntityManagerInterface $em)
  764. {
  765. //RECUPERATION DES CLIENTS SANS GEOCODE
  766. $clients = $em->getRepository(Client::class)->findAllWithoutGeocode(150);
  768. foreach ($clients as $c) {
  769. $reponseGoogle = file_get_contents('http://maps.google.com/maps/geo?q=' . urlencode($c->getAdresse() . " " . $c->getCp() . " " . $c->getVille() . " " . $c->getPays()) . '&output=csv&key=ABQIAAAADxbV76bneFH864wunOoZxhR6dygP_f_bLnyCVNpf2ThnBuN3bxS3r1o22-RHvHY7f17qJiY06l3LHQ');
  770. if ($reponseGoogle != '') {
  771. $codes = explode(",", $reponseGoogle);
  772. $c->setGeocode($codes[2] . "|" . $codes[3]);
  773. }
  774. }
  775. $em->flush();
  777. return $this->redirect($this->generateUrl('malys_client_map'));
  778. }
  780. /* GET FOURNISSEUR IN ARRAY */
  782. private function getFournisseur($fournisseurs, $id)
  783. {
  784. foreach ($fournisseurs as $f)
  785. if ($f->getId() == $id)
  786. return $f;
  787. return null;
  788. }
  790. /**
  791. * @Route("/chercher/client", name="malys_client_recherche")
  792. */
  793. public function searchClientsAction(Request $request, EntityManagerInterface $em)
  794. {
  795. $searchTerm = $request->get('q');
  797. $clients = $em->getRepository(Client::class)
  798. ->createQueryBuilder('c')
  799. ->where('c.nom LIKE :term')
  800. ->andWhere('c.prospect =:prospect')
  801. ->andWhere('c.affiche =:affiche')
  802. ->setParameter('term', $searchTerm . '%')
  803. ->setParameter('prospect', 0)
  804. ->setParameter('affiche', 1)
  805. ->getQuery()
  806. ->getResult();
  808. $results = [];
  810. foreach ($clients as $client) {
  812. $results[] = [
  813. 'id' => $client->getId(),
  814. 'text' => $client->getNom(),
  815. ];
  816. }
  818. return new JsonResponse($results);
  819. }
  821. /**
  822. * @Route("/chercher/prospect", name="malys_prospect_recherche")
  823. */
  824. public function searchProspectsAction(Request $request, EntityManagerInterface $em)
  825. {
  826. $searchTerm = $request->get('q'); // Le terme de recherche
  828. // Rechercher les prospects en fonction du nom (ou tout autre champ pertinent)
  829. $prospects = $em->getRepository(Client::class)
  830. ->createQueryBuilder('c')
  831. ->where('c.nom LIKE :term')
  832. ->andWhere('c.prospect =:prospect')
  833. ->andWhere('c.affiche =:affiche')
  834. ->setParameter('term', $searchTerm . '%')
  835. ->setParameter('prospect', 1)
  836. ->setParameter('affiche', 1)
  837. ->getQuery()
  838. ->getResult();
  840. $results = [];
  842. foreach ($prospects as $prospect) {
  843. $noteSymbol = ($prospect->getNote() == 2) ? '+' : '-';
  845. $results[] = [
  846. 'id' => $prospect->getId(),
  847. 'text' => $prospect->getNom() . ' ' . $noteSymbol,
  848. ];
  849. }
  851. return new JsonResponse($results);
  852. }
  853. }