src/Controller/User/UserController.php line 1185

Open in your IDE?
  1. <?php
  3. namespace App\Controller\User;
  6. use App\Common\Tools;
  7. use App\Entity\Admin;
  8. use App\Entity\Adminevent;
  9. use App\Entity\Adminprev;
  10. use App\Entity\Adminprevrdv;
  11. use App\Entity\Client;
  12. use App\Entity\Clientvente;
  13. use App\Entity\Fournisseur;
  14. use App\Entity\Messages;
  15. use App\Entity\Moisvalide;
  16. use App\Form\User\ClientProspectType;
  17. use App\Form\User\ClientType;
  18. use App\Utils\Dates\MalysDates;
  19. use Doctrine\ORM\EntityManagerInterface;
  20. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  21. use Symfony\Component\HttpFoundation\Request;
  22. use Symfony\Component\Routing\Annotation\Route;
  25. class UserController extends AbstractController
  26. {
  27. private $malysDates;
  29. /**
  30. * @required
  31. */
  32. public function setMalysDates(MalysDates $malysDates)
  33. {
  34. $this->malysDates = $malysDates;
  35. }
  38. /**
  39. * @Route("/", name="homepage")
  40. */
  41. public function indexAction(Request $request,EntityManagerInterface $em)
  42. {
  45. return $this->homeAction(date("Y"), date("m"), date("W"), $request,$em);
  46. }
  48. /**
  49. * @Route("/mobile/{filter}", name="malys_user_mobilehome", defaults={"filter"="nom"}, requirements={"filter"="nom|datefr"})
  50. */
  51. public function mobileAction($filter, Request $request, EntityManagerInterface $em)
  52. {
  55. // on cherche un user-agent apparenté à une plateforme mobile dans la variable
  56. $iphone = strpos($request->server->get('HTTP_USER_AGENT'), 'iPhone');
  57. $ipad = strpos($request->server->get('HTTP_USER_AGENT'), 'iPad');
  58. $android = strpos($request->server->get('HTTP_USER_AGENT'), 'Android');
  59. $blackberry = strpos($request->server->get('HTTP_USER_AGENT'), 'BlackBerry');
  61. // Si c'est un mobile
  62. if ($iphone || $ipad || $android || $blackberry > -1) {
  64. // On recupère les clients du USER
  65. $clients_user = $em->getRepository(Client::class)->findMyClientsAndProspects($this->getUser()->getId(), $filter);
  67. ($filter == "datefr") ? $clients_user = array_reverse($clients_user, true) : 0;
  69. ($filter == "nom") ? $filter = 'datefr' : $filter = 'nom';
  71. return $this->render('User/mobile.html.twig', array(
  72. "clients" => $clients_user,
  73. "nom_commercial" => $this->getUser()->getUser(),
  74. "filter" => $filter
  75. ));
  76. } else {
  77. return $this->redirect($this->generateUrl('homepage'));
  78. }
  79. }
  81. /**
  82. * @Route("/mobile/commande/{id}", name="malys_user_mobilecommande", defaults={"id"=0})
  83. */
  84. public function mobilecommandeAction($id, EntityManagerInterface $em)
  85. {
  86. $clientRepository = $em->getRepository(Client::class);
  87. $client_info = $clientRepository->find($id);
  89. $limit = 30;
  91. $orders = $em->getRepository(Clientvente::class)->getLastOrdersClient($id, $limit);
  93. return $this->render('User/mobilecommande.html.twig', array(
  94. "client" => $client_info,
  95. "orders" => $orders
  96. ));
  97. }
  99. /**
  100. * @Route("/mobile/location/{id}", name="malys_user_mobilelocation", defaults={"id"=0})
  101. */
  102. public function mobilelocationAction($id, EntityManagerInterface $em)
  103. {
  104. $client_info = $em->getRepository(Client::class)->find($id);
  106. $adresse = $client_info->getAdresse() . " " . $client_info->getCp() . " " . $client_info->getVille();
  108. return $this->render('User/mobilelocation.html.twig', array(
  109. "client" => $client_info,
  110. "adresse" => $adresse
  111. ));
  112. }
  114. /**
  115. * @Route("/mobile/chart/{id}", name="malys_user_mobilechart", defaults={"id"=0})
  116. */
  117. public function mobilechartAction($id, EntityManagerInterface $em)
  118. {
  119. /* RECUPERATION DU CLIENT EN BASE */
  120. $client = $em->getRepository(Client::class)->find($id);
  122. //RECUPERE LE MOIS VALIDE LE PLUS PROCHE
  123. $MonthValid = $em->getRepository(Moisvalide::class)->findLastMoisvalide(date("n"), date("Y"));
  125. $annee_valide = $MonthValid[0]['annee'];
  126. $mois_valide = $MonthValid[0]['mois'];
  129. /* RECUPERATION CA CLIENT */
  130. $cv = $em->getRepository(Clientvente::class)->findMyClientCa($id, 'all');
  132. /* tableau ca pour chart */
  133. $t_valeur_ca_chart = array();
  134. /* tableau frn */
  135. $t_fournisseur = array();
  136. /* Total Ca client */
  137. $total_ca = 0;
  139. /* tableau ca last month */
  140. $t_last_month_ca = array();
  143. foreach ($cv as $v) {
  145. $ca_genere = 0;
  146. $annee_vente = $v[0]->getDatefr()->format('Y');
  147. $mois_vente = $v[0]->getDatefr()->format('n');
  150. (isset($v['ca_genere']) && $annee_vente == $annee_valide) ? $ca_genere = $v['ca_genere'] : $ca_genere = 0;
  152. //TABLEAU MOIS PAR MOIS
  153. if (!isset($t_valeur_ca_chart[intval($v[0]->getDatefr()->format('Y'))][intval($v[0]->getDatefr()->format('m'))])) {
  154. $t_valeur_ca_chart[intval($v[0]->getDatefr()->format('Y'))][intval($v[0]->getDatefr()->format('n'))] = array(
  155. 'ca_genere' => 0,
  156. 'ca_commission' => 0,
  157. 'solde' => 0
  158. );
  159. }
  160. $t_valeur_ca_chart[intval($v[0]->getDatefr()->format('Y'))][intval($v[0]->getDatefr()->format('n'))]['ca_genere'] += number_format($v['ca_genere'], 2, '.', '');
  161. $t_valeur_ca_chart[intval($v[0]->getDatefr()->format('Y'))][intval($v[0]->getDatefr()->format('n'))]['ca_commission'] += ($v[0]->getIdadmin()->getId() == $this->getUser()->getId()) ? number_format($v['ca_commission'], 2, '.', '') : 0;
  162. $t_valeur_ca_chart[intval($v[0]->getDatefr()->format('Y'))][intval($v[0]->getDatefr()->format('n'))]['solde'] += number_format($v[0]->getSolde(), 2, '.', '');
  165. //TABLEAU LAST MONTHS CA
  166. $date_vente = Date("n/Y", mktime(0, 0, 0, $mois_vente, 1, $annee_vente));
  167. $mois_valide_past = Date("n/Y", mktime(0, 0, 0, $mois_valide, 1, $annee_valide));
  168. $mois_past1 = Date("n/Y", mktime(0, 0, 0, $mois_valide - 1, 1, $annee_valide));
  169. $mois_past2 = Date("n/Y", mktime(0, 0, 0, $mois_valide - 2, 1, $annee_valide));
  172. if (!isset($t_last_month_ca[$v[0]->getIdfournisseur()->getId()])) {
  173. $t_last_month_ca[$v[0]->getIdfournisseur()->getId()] = array(
  174. $mois_valide_past => 0,
  175. $mois_past1 => 0,
  176. $mois_past2 => 0
  177. );
  179. if ($date_vente == $mois_valide_past or $date_vente == $mois_past1 or $date_vente == $mois_past2) {
  180. $t_last_month_ca[$v[0]->getIdfournisseur()->getId()][$mois_valide_past] = $v['ca_genere'];
  181. }
  182. } else {
  183. if ($date_vente == $mois_valide_past or $date_vente == $mois_past1 or $date_vente == $mois_past2) {
  184. $t_last_month_ca[$v[0]->getIdfournisseur()->getId()][$date_vente] = $v['ca_genere'];
  185. }
  186. }
  189. //TABLEAU FOURNISSEUR
  190. $montant = 0;
  191. if (!isset($t_fournisseur[$v[0]->getIdfournisseur()->getId()])) {
  193. $montant = $v['ca_genere'];
  194. $t_fournisseur[$v[0]->getIdfournisseur()->getId()] = array(
  195. 'nom' => $v[0]->getIdfournisseur()->getNom(),
  196. 'total_ca' => $montant
  197. );
  199. } else {
  200. $montant += $v['ca_genere'];
  201. $t_fournisseur[$v[0]->getIdfournisseur()->getId()]['total_ca'] += $montant;
  202. }
  203. //TOTAL CA CLIENT
  204. $total_ca += $ca_genere;
  205. }
  207. //CREATE JSON FOR CHART CA
  208. $t_ca_chart = array();
  209. foreach ($t_valeur_ca_chart as $key => $item_ca) {
  210. $t_ca = array();
  211. for ($i = 1; $i <= 12; $i++) {
  213. (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);
  214. }
  215. ($key == date("Y")) ? array_push($t_ca_chart, (object)array(
  216. 'name' => $key,
  217. 'data' => $t_ca
  218. )) : array_push($t_ca_chart, (object)array('name' => $key, 'visible' => false, 'data' => $t_ca));
  220. }
  221. $t_ca_chart_json = json_encode($t_ca_chart);
  223. return $this->render('User/mobilechart.html.twig', array(
  224. 'client' => $client,
  225. 'user' => $this->getUser()->getFamille(),
  226. 't_ca_chart_json' => $t_ca_chart_json,
  227. 't_frn_client' => $t_fournisseur,
  228. 'total_ca' => $total_ca,
  229. 't_last_month_ca' => $t_last_month_ca,
  230. 'month_valid' => Date("n/Y", mktime(0, 0, 0, $mois_valide, 1, $annee_valide)),
  231. 'month_valid_past' => Date("n/Y", mktime(0, 0, 0, $mois_valide - 1, 1, $annee_valide)),
  232. 'month_valid_pastpast' => Date("n/Y", mktime(0, 0, 0, $mois_valide - 2, 1, $annee_valide)),
  233. ));
  234. }
  236. /**
  237. * @Route("/mobile/show/{id}", name="malys_user_mobileshow", defaults={"id"=0})
  238. */
  239. public function mobileshowAction($id, EntityManagerInterface $em)
  240. {
  241. $tab_fonction = array(
  242. 0 => 'non renseigne',
  243. 1 => 'Chef',
  244. 2 => 'Patron',
  245. 3 => 'Resp Bar',
  246. 4 => 'Gerant',
  247. 5 => 'Autre'
  248. );
  250. $tab_typeaffaire = array(
  251. 0 => 'Restaurant traditionnel',
  252. 1 => 'VAE',
  253. 2 => 'Bistrot <100 couverts/j',
  254. 3 => 'Basserie',
  255. 4 => 'Bar pur',
  256. 5 => 'Hotel',
  257. 6 => 'Boite de nuit',
  258. 7 => 'Traiteur',
  259. 8 => 'Autre',
  260. );
  262. $tab_typecontrat = array(
  263. 0 => 'non renseigne',
  264. 1 => 'Pret',
  265. 2 => 'MaD',
  266. 3 => 'Avance sur remise'
  267. );
  269. // On recupère les infos client
  270. $client_info = $em->getRepository(Client::class)->find($id);
  272. return $this->render('User/mobileshow.html.twig', array(
  273. 'client' => $client_info,
  274. 'tab_fonction' => $tab_fonction,
  275. 'tab_typeaffaire' => $tab_typeaffaire,
  276. 'tab_typecontrat' => $tab_typecontrat,
  277. ));
  280. }
  282. /**
  283. * @Route("/mobile/modify/{id}", name="malys_user_mobilemodify", defaults={"id"=0})
  284. */
  285. public function mobilemodifyAction($id, Request $request, EntityManagerInterface $em)
  286. {
  289. //$currentRoute = $request->attributes->get('_route');
  291. /*if($currentRoute != 'malys_user_mobileshow')
  292. return $this->redirect($this->generateUrl('malys_user_mobileshow', array('id' => $id)));*/
  293. //if($this->get('request')->headers->get('referer')){ $toto = "redirect ";}
  295. $type = '';
  296. if (isset($id) and $id != 0) {
  297. $client = $em->getRepository(Client::class)->find($id);
  298. $type = "Modifier";
  299. } else {
  300. $client = new Client;
  301. $type = "Ajouter";
  302. }
  303. // On verifie si le user est un admin ou pas pour créer le formualaire correspondant
  304. if ($id && $this->isGranted('ROLE_ADMIN')) {
  305. $form = $this->createForm(new ClientType($client->getProspect(), true), $client);
  306. } else {
  307. $form = $this->createForm(new ClientType($client->getProspect()), $client);
  308. }
  310. //On Regarde si on a recu une requete POST => si oui c'est que le user nous transmet un ajout ou une modif.
  311. if ($request->getMethod() == 'POST') {
  312. $form->handleRequest($request);
  314. if ($form->isValid()) {
  316. //Si une aucune date client on met a jour
  317. if ($client->getDateclientfr() == null) {
  318. $client->setDateclientfr($client->getDatefr());
  319. }
  321. // si c'est un nouveau client, on lui associe le user en admin
  322. if ($client->getIdadmin() == null) {
  323. $client->setIdadmin($this->getUser());
  324. }
  326. $em->persist($client);
  327. $em->flush();
  328. $id_client_retour = $client->getId();
  330. return $this->redirect($this->generateUrl('malys_user_mobileshow', array('id' => $id_client_retour)));
  331. }
  333. }
  335. return $this->render('User/mobilemodify.html.twig', array(
  336. 'form' => $form->createView(),
  337. 'client' => $client,
  338. 'type' => $type
  339. ));
  341. }
  343. /**
  344. * @Route("/index/{annee}/{mois}/{semaine}", name="malys_user_homepage", defaults={"semaine"=0})
  345. */
  346. public function homeAction($annee, $mois, $semaine, Request $request, EntityManagerInterface $em)
  347. {
  350. $annee_cal = $annee;
  351. $mois_cal = $mois;
  352. $semaine_cal = $semaine;
  355. //$this->container->get('malys_user.charts');
  356. $tab_mois_fr = $this->malysDates->getTabMoisFr();
  357. $tab_jours_fr = $this->malysDates->getTabJoursFr();
  359. //echo " <pre>";print_r($tab_mois_fr); echo " </pre><pre> "; print_r($tab_jours_fr);echo " </pre>";
  361. // CA GENERE DU MOIS POUR UN COMMERCIAL
  362. /*$t_ListeCA = array();
  363. $ca = $em->getRepository(Clientvente::Class)->findCommercialCa($this->getUser()->getId(), $annee);
  364. foreach ($ca as $c)
  365. $t_ListeCA[intval($c['le_mois'])] = $c['ca_genere'];*/
  367. //RECUPERE LE MOIS VALIDE LE PLUS PROCHE
  368. //
  371. $MonthValid = $em->getRepository(Moisvalide::class)->findLastMoisvalide(date("n"), date("Y"));
  374. // debug here
  375. $annee = $MonthValid[0]['annee'];
  377. $mois_valide = $MonthValid[0]['mois'];
  379. /* GRAPH */
  380. /* $objChart = new \Chart(140, 100, "chart_bar_ca_mois_" . $this->getUser()->getId() . "_gd_small");
  381. $objChart->SetHeaderName("Evolution CA " . $annee);
  382. $objChart->SetY_Barchart_Show_Values(true);
  384. for ($i = 1; $i < 13; $i++)
  385. $objChart->AddValue((string) $i, (isset($t_ListeCA[$i])) ? intval($t_ListeCA[$i]) : 0);
  387. $objChart->SetImageDestination("images/graph/");
  388. $objChart->CreateChartImage(LINE_CHART);*/
  390. // FOURNISSEURS
  391. if ($this->getUser()->getFamille() == 'Commercial') {
  392. $fournisseurs = $em->getRepository(Fournisseur::class)->findMyClientsFournisseurs($this->getUser()->getId());
  393. } else {
  394. $fournisseurs = null;
  395. }
  398. //RECUPERATION DES MESSAGES NON LUS
  399. $mes = $em->getRepository(Messages::class)->findMyMessagesNonLus($this->getUser()->getId());
  402. //AFFICHAGE DES RDV DU JOUR ET DU LENDEMAIN
  403. $rdv = $em->getRepository(Adminevent::class)->findTodayAndTomorrowRdv($this->getUser()->getId());
  406. //RECUPERATION DES STATS CLIENTELE
  407. $t_ListePC = array();
  408. $stats = $em->getRepository(Client::class)->findMyClientsStats($this->getUser()->getId());
  411. foreach ($stats as $s) {
  412. if ($s[0]->getProspect() == 1) {
  413. $t_ListePC['prospect'][$s[0]->getNote()] = $s['nombre'];
  414. } else {
  415. $t_ListePC['client'][$s[0]->getActivite()] = $s['nombre'];
  416. }
  417. }
  419. //LISTE SIMULATION HEBDO
  420. $simu = $em->getRepository(Adminevent::class)->findCommercialSimulationHebdo($this->getUser()->getId(), $annee, $semaine);
  422. //RECUPERATION DES OBJECTIFS RDV
  423. $obj_rdv = $em->getRepository(Adminprevrdv::class)->findOneBy(array(
  424. 'idadmin' => $this->getUser()->getId(),
  425. 'annee' => $annee,
  426. 'semaine' => $semaine
  427. ));
  429. //LISTE PROSPECTION HEBDO
  430. $t_ListeProspect = array();
  431. $pro = $em->getRepository(Client::class)->findListeProspectionHebdo($this->getUser()->getId(), $annee, $semaine);
  432. foreach ($pro as $p) {
  433. $t_ListeProspect[$p[0]->getNote()] = $p['nbprospect'];
  434. }
  436. //LISTE RDV CLIENTS
  437. $rdvClient = $em->getRepository(Adminevent::class)->findMyClientRdvHebdo($this->getUser()->getId(), $annee, $semaine);
  439. //LISTE TRANSFOS CLIENTS
  440. $transfo = $em->getRepository(Client::class)->findMyTransfoClientHebdo($this->getUser()->getId(), $annee, $semaine);
  442. //OBJECTIF DE CA
  443. $caObj = $em->getRepository(Adminprev::class)->findCommercialPrevCaInMonth($this->getUser()->getId(), $annee, $mois);
  445. //ALL CA FRN BY MONTH/YEAR
  446. $getAllCaByMonth = $em->getRepository(Clientvente::class)->getAllCaByMonth(3, $this->getUser()->getId(), $this->getUser()->getFamille());
  448. //ALL OBJECTIF BY MONTH/YEAR
  449. $t_Objectifs = $em->getRepository(Adminprev::class)->getAllPrevCaByMonth($this->getUser()->getId(), $this->getUser()->getFamille(), $annee);
  451. $t_objectif = array();
  452. $obj_total = 0;
  453. foreach ($t_Objectifs as $key => $item) {
  454. (intval($item['objectif'] != 0)) ? array_push($t_objectif, intval($item['objectif'])) : array_push($t_objectif, null);
  455. $obj_total += intval($item['objectif']);
  456. }
  457. //création json pour chart CA
  458. $t_ca_chart = array();
  460. foreach ($getAllCaByMonth as $key => $item) {
  461. $t_ca = array();
  462. $i = 0;
  463. foreach ($item as $year => $ca) {
  464. if ($i != 0) {
  465. (intval($ca) != 0) ? array_push($t_ca, intval($ca)) : array_push($t_ca, null);
  466. }
  467. $i++;
  468. }
  470. ($item["Annee"] == $annee) ? array_push($t_ca_chart, (object)array(
  471. 'name' => $item["Annee"],
  472. 'data' => $t_ca
  473. )) : array_push($t_ca_chart, (object)array(
  474. 'name' => $item["Annee"],
  475. 'visible' => false,
  476. 'data' => $t_ca
  477. ));
  478. }
  479. array_push($t_ca_chart, (object)array('name' => "Objectifs", 'color' => '#a3dfd9', 'data' => $t_objectif));
  480. array_push($t_objectif, $obj_total);
  483. $t_ca_chart_json = json_encode($t_ca_chart);
  484. unset($t_ca_chart); //Free memoire
  485. unset($getAllCaByMonth);
  487. //ALL CA CLIENT BY MONTH/YEAR
  488. $t_allCaClientByMonth = $em->getRepository(Clientvente::class)->getAllClientsCaLight($annee, null, 'three year', $this->getUser()->getId(), $this->getUser()->getFamille());
  490. $t_listClientActif = array();
  491. $t_listClientNouveau = array();
  492. $t_listClientPerdu = array();
  494. $t_ListeCaClientForChart = array();
  495. $t_ListeCaFamilleForChart = array();
  497. $t_CaFamilleForChart = array();
  498. // Recuperation tab CAclient/mois et tab CaFamille/mois
  501. foreach ($t_allCaClientByMonth as $caClient => $item) {
  502. $yearfr = $item['datefr']->format('Y');
  503. $monthfr = $item['datefr']->format('n');
  505. // Recuperation des clients actifs du dernier mois valider
  506. if ($monthfr == $mois_valide && $yearfr == $annee) {
  507. if (!isset($t_listClientActif[$item['id']])) {
  508. $t_listClientActif[$item['id']] = $item['nom'];
  509. $t_listClientNouveau[$item['id']] = $item['nom'];
  510. }
  511. }
  512. // Recuperation des clients actifs du dernier mois valider-1
  513. if ($monthfr == $mois_valide - 1 && $yearfr == $annee) {
  514. if (!isset($t_listClientPerdu[$item['id']])) {
  515. $t_listClientPerdu[$item['id']] = $item['nom'];
  516. }
  517. }
  518. // Si l'année, le mois et le client n'existe pas dans le tableau d'arrivée, on l'ajoute au tableau
  519. if ($yearfr == $annee || $yearfr == $annee - 1) {
  520. if (!isset($t_ListeCaClientForChart[$yearfr][$monthfr][$item['id']])) {
  521. if ($item['ca_genere'] > 0) {
  522. $t_ListeCaClientForChart[$yearfr][$monthfr][$item['id']] = array();
  523. $t_ListeCaClientForChart[$yearfr][$monthfr][$item['id']]['ca_genere'] = number_format((float)$item['ca_genere'], 2, '.', '');
  524. }
  525. } else { // Si la case existe déjà
  526. if ($item['ca_genere'] > 0) {
  527. $t_ListeCaClientForChart[$yearfr][$monthfr][$item['id']]['ca_genere'] += number_format((float)$item['ca_genere'], 2, '.', '');
  528. }
  529. }
  530. }
  532. // Si l'année n'existe pas dans le tableau CAfamille d'arrivée, on ajoute la case avec la l'année
  533. if ($yearfr == $annee) {
  535. if (!isset($t_ListeCaFamilleForChart[$item['famille']])) {
  536. $t_ListeCaFamilleForChart[$item['famille']] = array();
  537. $t_ListeCaFamilleForChart[$item['famille']] = number_format((float)$item['ca_genere'], 2, '.', '');
  538. } else {
  539. $t_ListeCaFamilleForChart[$item['famille']] += number_format((float)$item['ca_genere'], 2, '.', '');
  540. }
  541. }
  542. }
  543. //ON RETIRE LES CLIENTS QUI ONT COMMANDES DE LA LISTE
  544. foreach ($t_listClientPerdu as $k => $value) {
  545. if (isset($t_listClientActif[$k])) {
  546. unset($t_listClientPerdu[$k]);
  547. }
  548. }
  550. foreach ($t_allCaClientByMonth as $caClient => $item) {
  551. $yearfr = $item['datefr']->format('Y');
  552. $monthfr = $item['datefr']->format('n');
  553. // Recuperation des clients Nouveau du dernier mois valider
  555. if ($yearfr == ($annee)) {
  556. if ($monthfr == ($mois_valide) - 1 ||
  557. $monthfr == ($mois_valide) - 2 ||
  558. $monthfr == ($mois_valide) - 3 ||
  559. $monthfr == ($mois_valide) - 4) {
  561. if (isset($t_listClientNouveau[$item['id']])) {
  563. unset($t_listClientNouveau[$item['id']]);
  564. }
  565. }
  566. }
  567. }
  568. unset($t_allCaClientByMonth); //Free memoire
  571. $t_ca_famille = array();
  572. foreach ($t_ListeCaFamilleForChart as $key => $value) {
  573. ($key != "") ? array_push($t_ca_famille, array(
  574. $key,
  575. intval($value)
  576. )) : array_push($t_ca_famille, array("AUTRE", intval($value)));
  577. }
  579. // Obtient une liste de colonnes
  580. foreach ($t_ca_famille as $key => $row) {
  581. $volume[$key] = $row[1];
  582. $edition[$key] = $row[0];
  583. }
  584. // Trie les données par volume décroissant, edition croissant
  585. // Ajoute $data en tant que dernier paramètre, pour trier par la clé commune
  586. if (isset($volume)) {
  587. array_multisort($volume, SORT_DESC, $edition, SORT_ASC, $t_ca_famille);
  588. }
  590. array_push($t_CaFamilleForChart, (object)array(
  591. 'type' => 'pie',
  592. 'name' => 'Famille',
  593. 'data' => $t_ca_famille
  594. ));
  596. unset($t_ca_famille); // free Memory
  598. $t_CaFamilleForChart_json = json_encode($t_CaFamilleForChart);
  601. unset($t_CaFamilleForChart);
  602. unset($t_ListeCaFamilleForChart);
  604. $t_gp_val_chart = array();
  605. $t_gp_client_chart = array();
  606. $t_ListeGainsPertes = array(
  607. 0 => array('gain' => array(), 'perte' => array(), 'type' => 'ca'),
  608. 1 => array('gain' => array(), 'perte' => array(), 'type' => 'client')
  609. );
  611. if (isset($t_ListeCaClientForChart[$annee - 1][12])) {
  612. foreach ($t_ListeCaClientForChart[$annee - 1][12] as $id => $ca) {
  613. (!array_key_exists($id, $t_ListeCaClientForChart[$annee][1])) ? $t_ListeCaClientForChart[$annee][1][$id] = array('ca_genere' => 0.0) : null;
  614. }
  615. }
  617. foreach ($t_ListeCaClientForChart as $year => $item) {
  619. foreach ($item as $month => $val) {
  621. foreach ($val as $id => $ca) {
  622. for ($i = 1; $i < count($item); $i++) {
  624. if (isset($t_ListeCaClientForChart[$year][$i])) {
  625. (!array_key_exists($id, $t_ListeCaClientForChart[$year][$i])) ? $t_ListeCaClientForChart[$year][$i][$id] = array('ca_genere' => 0.0) : null;
  626. }
  628. }
  629. }
  630. }
  631. }
  633. for ($i = 1; $i <= 12; $i++) {
  634. (!isset($t_ListeCaClientForChart[$annee][$i])) ? $t_ListeCaClientForChart[$annee][$i] = null : 1;
  635. }
  636. ksort($t_ListeCaClientForChart[$annee], SORT_ASC);
  639. //calcul et recuperation "pertes et gains" total en valeur et client/MOIS
  642. foreach ($t_ListeCaClientForChart as $year => $item) {
  643. $t_gains_valeur = array();
  644. $t_pertes_valeur = array();
  645. $t_gains_client = array();
  646. $t_pertes_client = array();
  648. if ($year == $annee) {
  649. foreach ($item as $month => $val) {
  650. $gainsValeur = 0;
  651. $pertesValeur = 0;
  652. $gainsClient = 0;
  653. $pertesClient = 0;
  654. if ($val != null) {
  655. foreach ($val as $client => $caClient) {
  656. $caMoisPrec = 0;
  657. if ($month != 1) { // Si C'est pas le mois de janvier
  658. if (isset($item[$month - 1][$client])) {
  660. $caMoisPrec = $item[$month - 1][$client]['ca_genere'];
  661. }
  662. } else { // si c'est janvier => IDEM avec décembre de l'année précédente
  663. if (isset($t_ListeCaClientForChart[$year - 1][12][$client])) {
  664. $caMoisPrec = $t_ListeCaClientForChart[$year - 1][12][$client]['ca_genere'];
  665. }
  666. }
  668. $diff = ($caClient['ca_genere']) - ($caMoisPrec); // ON calcul $diff => CA du mois - (Ca du mois-1) [exemple: CAmars - CAfevrier ]
  669. ($diff < 0) ? $pertesValeur += $diff : $gainsValeur += $diff; // On met a jour Gains et Pertes
  671. //On calcul $evoCa => (CA du mois - (Ca du mois-1)) / (Ca du mois-1) [exemple: (CAmars - CAfevrier)/CAfevrier ]
  672. if ($caMoisPrec != 0) {
  673. $evoCa = (($caClient['ca_genere']) - ($caMoisPrec)) / ($caMoisPrec);
  674. } else {
  675. $evoCa = 0;
  676. }
  677. // On met a jour Gains et Pertes Client
  678. if ($evoCa < 0) {
  679. $pertesClient--;
  680. }
  681. if ($evoCa > 0) {
  682. $gainsClient++;
  683. }
  684. }
  685. } else {
  686. $gainsClient = null;
  687. $pertesClient = null;
  688. $pertesValeur = null;
  689. $gainsValeur = null;
  690. }
  692. array_push($t_gains_valeur, $gainsValeur);
  693. array_push($t_pertes_valeur, $pertesValeur);
  694. array_push($t_gains_client, $gainsClient);
  695. array_push($t_pertes_client, $pertesClient);
  696. }
  697. }
  698. if ($year == $annee) {
  699. array_push($t_gp_val_chart, (object)array('name' => "Gains", 'data' => $t_gains_valeur)); //Valeur
  700. array_push($t_gp_val_chart, (object)array(
  701. 'name' => "Pertes",
  702. 'data' => $t_pertes_valeur
  703. )); //Valeur
  704. array_push($t_gp_client_chart, (object)array(
  705. 'name' => "Gains",
  706. 'data' => $t_gains_client
  707. )); //Client
  708. array_push($t_gp_client_chart, (object)array(
  709. 'name' => "Pertes",
  710. 'data' => $t_pertes_client
  711. )); //Client
  713. array_push($t_ListeGainsPertes[0]['gain'], $t_gains_valeur); //Valeur
  714. array_push($t_ListeGainsPertes[0]['perte'], $t_pertes_valeur); //Valeur
  715. array_push($t_ListeGainsPertes[1]['gain'], $t_gains_client); //Client
  716. array_push($t_ListeGainsPertes[1]['perte'], $t_pertes_client); //Client
  717. }
  718. }
  719. // COnstrcution JSON pour GAINS PERTES CHARTS
  720. $t_gp_val_chart_json = json_encode($t_gp_val_chart);
  721. $t_gp_client_chart_json = json_encode($t_gp_client_chart);
  723. unset($t_gp_val_chart);
  724. unset($t_gp_client_chart);
  726. //Tableau Gains Pertes
  727. $tab_moy = array('moyValP' => 0, 'moyCliP' => 0, 'moyValG' => 0, 'moyCliG' => 0);
  728. $next = 0;
  729. $nbmonth = 0;
  730. foreach ($t_ListeGainsPertes as $key => $val) {
  732. if ($val['gain'][0]) {
  733. foreach ($val['gain'][0] as $k => $value) {
  734. ($next == 0) ? $tab_moy['moyValG'] += $value : $tab_moy['moyCliG'] += $value;
  735. ($next == 0) ? $nbmonth++ : null;
  736. }
  737. }
  738. if ($val['perte'][0]) {
  739. foreach ($val['perte'][0] as $k => $value) {
  740. ($next == 0) ? $tab_moy['moyValP'] += $value : $tab_moy['moyCliP'] += $value;
  741. }
  742. }
  743. $next++;
  744. }
  745. if ($nbmonth != 0) {
  746. array_push($t_ListeGainsPertes[0]['gain'], $tab_moy['moyValG'] / $nbmonth);
  747. array_push($t_ListeGainsPertes[0]['perte'], $tab_moy['moyValP'] / $nbmonth);
  748. array_push($t_ListeGainsPertes[1]['gain'], $tab_moy['moyCliG'] / $nbmonth);
  749. array_push($t_ListeGainsPertes[1]['perte'], $tab_moy['moyCliP'] / $nbmonth);
  750. }
  752. unset($tab_moy);
  753. unset($t_gp_val_chart);
  754. unset($t_gp_client_chart);
  755. unset($t_gains_valeur);
  756. unset($t_pertes_valeur);
  757. unset($t_gains_client);
  758. unset($t_pertes_client);
  760. // Recuperation segClient/mois et segValeur/mois
  761. $t_seg_client_chart = array();
  762. $t_seg_valeur_chart = array();
  763. $t_seg_client = array(
  764. '0' => array(),
  765. '1' => array(),
  766. '2' => array(),
  767. '3' => array(),
  768. '4' => array(),
  769. '5' => array()
  770. );
  771. $t_seg_valeur = array(
  772. '0' => array(),
  773. '1' => array(),
  774. '2' => array(),
  775. '3' => array(),
  776. '4' => array(),
  777. '5' => array()
  778. );
  779. $t_seg = array(
  780. 0 => array("palier" => 500, "valeur" => 0, "client" => 0, "name" => '0-500'),
  781. 1 => array("palier" => 1500, "valeur" => 0, "client" => 0, "name" => '500-1500'),
  782. 2 => array("palier" => 3000, "valeur" => 0, "client" => 0, "name" => '1500-3000'),
  783. 3 => array("palier" => 9000, "valeur" => 0, "client" => 0, "name" => '3000-9000'),
  784. 4 => array("palier" => 20000, "valeur" => 0, "client" => 0, "name" => '9000-20000'),
  785. 5 => array("valeur" => 0, "client" => 0, "name" => '>20000'),
  786. );
  788. $Liste_client_groupe1 = array($year => array());
  790. // On recupere les valeurs de segmentation
  791. foreach ($t_ListeCaClientForChart as $year => $item) {
  792. if ($year == $annee) {
  793. foreach ($item as $month => $val) {
  794. for ($i = 0; $i < count($t_seg); $i++) {
  795. $t_seg[$i]["valeur"] = 0;
  796. $t_seg[$i]["client"] = 0;
  797. }
  798. (!isset($Liste_client_groupe1[$year][$month])) ? $Liste_client_groupe1[$year][$month] = array() : 1;
  800. if ($val != null) {
  801. foreach ($val as $client => $caClient) {
  802. //Récupération des valeurs de segementation
  803. if ($caClient['ca_genere'] > 1 && $caClient['ca_genere'] <= $t_seg[0]["palier"]) {
  804. $t_seg[0]["valeur"] += $caClient['ca_genere'];
  805. $t_seg[0]["client"] += 1;
  807. //TODO EXTRACT LIST OF CLIENT BY GROUPE AND BY MONTH
  808. array_push($Liste_client_groupe1[$year][$month], $client);
  809. } else if ($caClient['ca_genere'] > $t_seg[0]["palier"] && $caClient['ca_genere'] <= $t_seg[1]["palier"]) {
  810. $t_seg[1]["valeur"] += $caClient['ca_genere'];
  811. $t_seg[1]["client"] += 1;
  812. } else if ($caClient['ca_genere'] > $t_seg[1]["palier"] && $caClient['ca_genere'] <= $t_seg[2]["palier"]) {
  813. $t_seg[2]["valeur"] += $caClient['ca_genere'];
  814. $t_seg[2]["client"] += 1;
  815. } else if ($caClient['ca_genere'] > $t_seg[2]["palier"] && $caClient['ca_genere'] <= $t_seg[3]["palier"]) {
  816. $t_seg[3]["valeur"] += $caClient['ca_genere'];
  817. $t_seg[3]["client"] += 1;
  818. } else if ($caClient['ca_genere'] > $t_seg[3]["palier"] && $caClient['ca_genere'] <= $t_seg[4]["palier"]) {
  819. $t_seg[4]["valeur"] += $caClient['ca_genere'];
  820. $t_seg[4]["client"] += 1;
  821. } else if ($caClient['ca_genere'] > $t_seg[4]["palier"]) {
  822. $t_seg[5]["valeur"] += $caClient['ca_genere'];
  823. $t_seg[5]["client"] += 1;
  824. }
  825. }
  826. }
  827. foreach ($t_seg as $key => $value) {
  828. if ($year == $annee) {
  829. for ($i = 0; $i < 6; $i++) {
  830. if ($key == $i) {
  831. array_push($t_seg_client[$i], $value['client']);
  832. array_push($t_seg_valeur[$i], $value['valeur']);
  833. }
  834. }
  835. }
  836. }
  837. }
  838. }
  839. }
  840. $t_ListeSeg = array();
  841. array_push($t_ListeSeg, $t_seg_client);
  842. array_push($t_ListeSeg, $t_seg_valeur);
  844. foreach ($t_ListeSeg as $key => $val) {
  846. foreach ($val as $k => $value) {
  847. $total = 0;
  848. for ($i = 0; $i < count($value); $i++) {
  849. $total += $value[$i];
  850. }
  852. if ($key == 1) {
  853. $t_ListeSeg[$key][$k]['total_group'] = $total;
  854. } else {
  855. (count($value) != 0) ? $t_ListeSeg[$key][$k]['total_group'] = ($total / count($value)) : null;
  856. }
  857. for ($j = 0; $j < count($t_seg); $j++) {
  858. $t_ListeSeg[$key][$j]['nom'] = $t_seg[$j]['name'];
  859. }
  860. }
  861. }
  864. $t_listeNbCommande = array();
  865. $t_listeCaSeg = array();
  867. for ($j = 0; $j < 12; $j++) {
  868. $total_client = 0;
  869. $total_ca = 0;
  870. foreach ($t_ListeSeg[0] as $key => $val) {
  871. (isset($val[$j])) ? $total_client += $val[$j] : null;
  872. }
  873. array_push($t_listeNbCommande, $total_client);
  875. foreach ($t_ListeSeg[1] as $key => $val) {
  876. (isset($val[$j])) ? $total_ca += $val[$j] : null;
  877. }
  878. array_push($t_listeCaSeg, $total_ca);
  881. }
  883. for ($j = 5; $j > -1; $j--) {
  884. array_push($t_seg_client_chart, (object)array(
  885. 'type' => "column",
  886. 'name' => $t_seg[$j]['name'],
  887. 'data' => $t_seg_client[$j],
  888. 'id' => $t_seg[$j]['name'] . 'c',
  889. )
  890. );
  891. array_push($t_seg_valeur_chart, (object)array(
  892. 'type' => "column",
  893. 'name' => $t_seg[$j]['name'],
  894. 'data' => $t_seg_valeur[$j],
  895. 'id' => $t_seg[$j]['name'] . 'v',
  896. ));
  897. }
  898. for ($j = 5; $j > -1; $j--) {
  899. array_push($t_seg_client_chart, (object)array(
  900. 'name' => 'seg1->',
  901. 'id' => $t_seg[$j]['name'] . 'cc',
  902. 'showInLegend' => false,
  903. 'color' => 'red',
  904. 'lineWidth' => 1,
  905. 'marker' => (object)array(
  906. 'lineWidth' => 0.1,
  907. 'lineColor' => 'Highcharts.getOptions().colors[4]',
  908. 'fillColor' => "white",
  909. "radius" => 2,
  910. 'enabled' => true
  911. ),
  912. 'data' => $t_seg_client[$j]
  913. ));
  914. array_push($t_seg_valeur_chart, (object)array(
  915. 'name' => "seg1->",
  916. 'id' => $t_seg[$j]['name'] . 'vv',
  917. 'showInLegend' => false,
  918. 'color' => 'red',
  919. 'lineWidth' => 1,
  920. 'marker' => (object)array(
  921. 'lineWidth' => 0.1,
  922. 'lineColor' => 'Highcharts.getOptions().colors[4]',
  923. 'fillColor' => "white",
  924. "radius" => 2,
  925. 'enabled' => true
  926. ),
  927. 'data' => $t_seg_valeur[$j]
  928. ));
  929. }
  931. $t_seg_client_chart_json = json_encode($t_seg_client_chart);
  932. $t_seg_valeur_chart_json = json_encode($t_seg_valeur_chart);
  934. unset($t_seg);
  935. unset($t_seg_client_chart);
  936. unset($t_seg_client);
  937. unset($t_seg_valeur_chart);
  938. unset($t_seg_valeur);
  941. //vide memoire
  943. // Recupération informations pour tableau fournisseurs global
  944. // TRAITEMENT FORMULAIRE ET VALEURS PAR DEFAUT
  945. $year = $annee;
  946. $source = $request->get('source', null) == '' ? null : $request->get('source', null);
  947. $perf_ca = $request->get('perf_ca', null);
  948. $type = 'fournisseur';
  950. // GET CA
  951. $cv = $em->getRepository(Clientvente::class)->getAllFournisseursCa($year, $source, "three year", $this->getUser()->getId(), $this->getUser()->getFamille());
  953. $t_ListeCA_frn = array();
  954. $t_ListeMois = array();
  955. $t_ListeDetail = array();
  956. foreach ($cv as $c) {
  958. $mois = intval($c[0]['datefr']->format('m'));
  959. $yeartraitement = intval($c[0]['datefr']->format('Y'));
  960. $id = $c['id'];
  962. //TABLEAU ANNNEE TOTAUX
  963. if (!isset($t_ListeMois[$yeartraitement])) {
  964. $t_ListeMois[$yeartraitement] = array(
  965. 'cagenere_total' => 0,
  966. 'cacommission_total' => 0,
  967. 'solde_total' => 0
  968. );
  969. }
  972. //TABLEAU DETAILLE
  973. if (!isset($t_ListeCA_frn[$yeartraitement][$id])) {
  974. $t_ListeCA_frn[$yeartraitement][$id] = array(
  975. 'cagenere_total' => 0,
  976. 'cacommission_total' => 0,
  977. 'solde_total' => 0
  978. );
  979. }
  981. $t_ListeCA_frn[$yeartraitement][$id][$mois]['ca_genere'] = number_format($c['ca_genere'], 2, '.', '');
  982. $t_ListeCA_frn[$yeartraitement][$id][$mois]['ca_commission'] = number_format($c['ca_commission'], 2, '.', '');
  983. $t_ListeCA_frn[$yeartraitement][$id][$mois]['solde'] = number_format($c['ca_solde'], 2, '.', '');
  985. $t_ListeCA_frn[$yeartraitement][$id]['id' . $type] = $c['id'];
  986. $t_ListeCA_frn[$yeartraitement][$id]['nom'] = $c['nom'];
  988. $t_ListeCA_frn[$yeartraitement][$id]['cagenere_total'] += number_format($c['ca_genere'], 2, '.', '');
  989. $t_ListeCA_frn[$yeartraitement][$id]['cacommission_total'] += number_format($c['ca_commission'], 2, '.', '');
  990. $t_ListeCA_frn[$yeartraitement][$id]['solde_total'] += number_format($c['ca_solde'], 2, '.', '');
  991. $t_ListeCA_frn[$yeartraitement][$id]['source'] = $c['source'];
  993. //TABLEAU ANNEE MOIS PAR MOIS
  994. if (!isset($t_ListeMois[$yeartraitement][$mois])) {
  995. $t_ListeMois[$yeartraitement][$mois] = array(
  996. 'ca_genere' => 0,
  997. 'ca_commission' => 0,
  998. 'solde' => 0
  999. );
  1000. }
  1002. $t_ListeMois[$yeartraitement][$mois]['ca_genere'] += number_format($c['ca_genere'], 2, '.', '');
  1003. $t_ListeMois[$yeartraitement][$mois]['ca_commission'] += number_format($c['ca_commission'], 2, '.', '');
  1004. $t_ListeMois[$yeartraitement][$mois]['solde'] += number_format($c['ca_solde'], 2, '.', '');
  1006. //TEABLEAU TOTAL
  1007. $t_ListeMois[$yeartraitement]['cagenere_total'] += number_format($c['ca_genere'], 2, '.', '');
  1008. $t_ListeMois[$yeartraitement]['cacommission_total'] += number_format($c['ca_commission'], 2, '.', '');
  1009. $t_ListeMois[$yeartraitement]['solde_total'] += number_format($c['ca_solde'], 2, '.', '');
  1012. //TABLEAU PAR TYPE DETAIL
  1013. if (!isset($t_ListeDetail[$yeartraitement][$id])) {
  1014. $t_ListeDetail[$yeartraitement][$id] = array(
  1015. 'ca_genere' => 0,
  1016. 'ca_commission' => 0,
  1017. 'solde' => 0
  1018. );
  1019. }
  1021. $t_ListeDetail[$yeartraitement][$id]['ca_genere'] += number_format($c['ca_genere'], 2, '.', '');
  1022. $t_ListeDetail[$yeartraitement][$id]['ca_commission'] += number_format($c['ca_commission'], 2, '.', '');
  1023. $t_ListeDetail[$yeartraitement][$id]['solde'] += number_format($c['ca_solde'], 2, '.', '');
  1024. $t_ListeDetail[$yeartraitement][$id]['source'] = $c['source'];
  1026. }
  1028. if ($perf_ca != null) {
  1029. uasort($t_ListeCA, "App\\Controller\\Marketing::cmpCa");
  1030. }
  1033. // GET POTENCIEL
  1034. $potenciel = $em->getRepository(Client::class)->getPotentielCaClient(0, $this->getUser()->getId(), $this->getUser()->getFamille());
  1035. $potentiel_json = array();
  1038. $potenciel[0]['potentiel'] = 0;
  1039. if (intval($potenciel[0]['potentiel']) - intval(number_format($t_ListeMois[$annee]["cagenere_total"], 2, '.', '')) > 0) {
  1041. array_push($potentiel_json, (object)array(
  1042. 'name' => "Potentiel",
  1043. 'id' => '' + $potenciel[0]['potentiel'] + '',
  1044. 'data' => array(intval($potenciel[0]['potentiel']) - intval(number_format($t_ListeMois[$annee]["cagenere_total"], 2, '.', ''))),
  1045. ));
  1046. array_push($potentiel_json, (object)array(
  1047. 'name' => "CA realise",
  1048. 'id' => '' + intval(number_format($t_ListeMois[$annee]["cagenere_total"], 2, '.', '')) + '',
  1049. 'data' => array(intval(number_format($t_ListeMois[$annee]["cagenere_total"], 2, '.', ''))),
  1050. ));
  1051. } else {
  1052. if ($potenciel[0]['potentiel'] != 0) {
  1053. $ca = intval(number_format($t_ListeMois[$annee]["cagenere_total"], 2, '.', ''));
  1054. $pot = $potenciel[0]['potentiel'];
  1056. $percent_ca = $ca / $pot * 100;
  1057. if ($percent_ca > 200) {
  1059. $ca_enplus = $ca - $pot;
  1060. $potenciel_maj = $pot - $ca_enplus;
  1062. array_push($potentiel_json, (object)array(
  1063. 'name' => "CA realise",
  1064. 'id' => '' + $ca + '',
  1065. 'data' => array($ca_enplus),
  1066. ));
  1068. } else {
  1069. $ca_enplus = $ca - $pot;
  1070. $potenciel_maj = $pot - $ca_enplus;
  1071. echo $potenciel_maj;
  1072. array_push($potentiel_json, (object)array(
  1073. 'color' => 'green',
  1074. 'name' => "CA realise",
  1075. 'id' => '' + $ca + '',
  1076. 'data' => array($ca_enplus),
  1077. ));
  1078. array_push($potentiel_json, (object)array(
  1079. 'name' => "Potentiel",
  1080. 'id' => '' + $pot + '',
  1081. 'data' => array(intval(number_format($potenciel_maj, 2, '.', ''))),
  1082. ));
  1083. }
  1084. } else {
  1085. array_push($potentiel_json, (object)array(
  1086. 'name' => "Potentiel",
  1087. 'id' => 'Aucun Potentiel',
  1088. 'data' => array(100),
  1089. ));
  1090. }
  1091. }
  1094. $t_potentiel_json = json_encode($potentiel_json);
  1095. unset($potentiel_json);
  1097. $mois_francais = array(
  1098. 1 => 'Jan',
  1099. 2 => 'Fev',
  1100. 3 => 'Mars',
  1101. 4 => 'Avr',
  1102. 5 => 'Mai',
  1103. 6 => 'Juin',
  1104. 7 => 'Juil',
  1105. 8 => 'Aout',
  1106. 9 => 'Sept',
  1107. 10 => 'Oct',
  1108. 11 => 'Nov',
  1109. 12 => 'Dec'
  1110. );
  1112. return $this->render('User/index.html.twig', array(
  1113. 'Res_CA_obj' => (!empty($caObj)) ? $caObj[0]->getMontantht() : '0.00',
  1114. 'ListeTransfos' => $transfo[0],
  1115. 'ListeRDV' => $rdvClient[0],
  1116. 'Obj_RDV' => $obj_rdv,
  1117. 'ListeSimulation' => $simu[0],
  1118. 't_ListeProspect' => $t_ListeProspect,
  1119. 't_ListePC' => $t_ListePC,
  1120. 'tab_mois_fr' => $tab_mois_fr,
  1121. 'tab_jours_fr' => $tab_jours_fr,
  1122. 'Rdv' => $rdv,
  1123. 'Messages' => $mes,
  1124. 'fournisseurs' => $fournisseurs,
  1125. 'annee_cal' => $annee_cal,
  1126. 'mois_cal' => $mois_cal,
  1127. 'semaine_cal' => $semaine_cal,
  1128. 'mois' => $mois,
  1129. 'annee' => $annee,
  1130. 'semaine' => $semaine,
  1132. 't_potentiel_json' => $t_potentiel_json,
  1133. 't_objectif' => $t_objectif,
  1134. 't_ca_chart_json' => $t_ca_chart_json,
  1135. 't_gp_val_chart_json' => $t_gp_val_chart_json,
  1136. 't_gp_client_chart_json' => $t_gp_client_chart_json,
  1137. 't_CaFamilleForChart_json' => $t_CaFamilleForChart_json,
  1138. 't_seg_client_chart_json' => $t_seg_client_chart_json,
  1139. 't_seg_valeur_chart_json' => $t_seg_valeur_chart_json,
  1140. 'type' => 'fournisseur',
  1141. 't_listeNbCommande' => $t_listeNbCommande,
  1142. 't_listeCaSeg' => $t_listeCaSeg,
  1144. 't_ListeSeg' => $t_ListeSeg,
  1145. 't_ListeGainsPertes' => $t_ListeGainsPertes,
  1147. 't_ListeDetail' => $t_ListeDetail,
  1148. 't_ListeMois' => $t_ListeMois,
  1149. 't_ListeCA' => $t_ListeCA_frn,
  1151. 'user' => $this->getUser()->getFamille(),
  1153. 'nb_actif' => count($t_listClientActif),
  1154. 'nb_nouveau' => count($t_listClientNouveau),
  1155. 'nb_perdu' => count($t_listClientPerdu),
  1157. 'current_year' => $annee,
  1158. 'current_month' => $mois_francais[$mois_valide],
  1159. 'current_month_detail' => $MonthValid[0]['note']
  1160. ));
  1162. unset($t_listClientActif);
  1163. unset($t_listClientNouveau);
  1164. unset($t_listClientPerdu);
  1165. unset($t_ListeSeg);
  1166. unset($t_ListeGainsPertes);
  1167. unset($t_ListeDetail);
  1168. unset($t_ListeCA_frn);
  1169. unset($t_ListeMois);
  1170. unset($t_listClientPerdu);
  1171. unset($t_seg_client_chart_json);
  1172. unset($t_seg_valeur_chart_json);
  1173. unset($t_CaFamilleForChart_json);
  1174. unset($t_ca_chart_json);
  1175. unset($t_gp_client_chart_json);
  1176. unset($t_objectif);
  1177. unset($t_potentiel_json);
  1179. }
  1181. /**
  1182. * @Route("/menu", name="user_menu")
  1183. */
  1185. public function menuAction()
  1186. {
  1187. return $this->render('User/menu.html.twig');
  1188. }
  1190. /**
  1191. * @Route("/select", name="select_client")
  1192. */
  1193. public function selectClientsAction($id, EntityManagerInterface $em)
  1194. {
  1195. if ($id != 0) {
  1196. $clients = $em->getRepository(Client::class)->findMyClients($this->getUser()->getId());
  1197. $prospects = $em->getRepository(Client::class)->findMyProsPects($this->getUser()->getId());
  1198. } else {
  1199. $clients = $em->getRepository(Client::class)->findAllClientsInArray();
  1200. $prospects = $em->getRepository(Client::class)->findAllProspectInArray();
  1201. }
  1202. $form = $this->createForm(ClientProspectType::class);
  1204. return $this->render('User/clientsSelectors.html.twig', array(
  1205. 'clients' => $clients,
  1206. 'prospects' => $prospects,
  1207. 'form' => $form->createView(),
  1208. ));
  1209. }
  1211. /* AFFICHAGE DES SELECTEURS UTILISATEURS */
  1213. public function selectUtilisateursAction($id, $annee, $mois, $semaine, $route, EntityManagerInterface $em)
  1214. {
  1215. //RECUPERATION DES UTILISATEURS POUR LISTE DEROULANTE
  1216. $utilisateurs = $em->getRepository(Admin::class)->findBy(array('valide' => 1), array('contact' => 'ASC'));
  1217. return $this->render('User/utilisateursSelectors.html.twig', array(
  1218. 'utilisateurs' => $utilisateurs,
  1219. 'id' => $id,
  1220. 'route' => $route,
  1221. 'annee' => $annee,
  1222. 'mois' => $mois,
  1223. 'semaine' => $semaine
  1224. ));
  1225. }
  1227. /* AFFICHAGE DES STATS GLOBALES D'UN UTILISATEUR */
  1228. /**
  1229. * @Route("/rapport_global/{date}/{id}", name="malys_user_globalreport", defaults={"date"=0, "id"=0})
  1230. */
  1231. public function globalReportAction($date, $id, EntityManagerInterface $em)
  1232. {
  1233. /* annee courante par défaut */
  1234. if ($date == 0) {
  1235. $date = date('Y');
  1236. }
  1237. if ($id == 0) {
  1238. $id = $this->getUser()->getId();
  1239. $currentUser = true;
  1240. } else {
  1241. $currentUser = false;
  1242. }
  1244. /* selecteur de date */
  1245. $begin = date("Y", time()) - 3;
  1246. $end = date("Y", time()) + 1;
  1248. /* mois du tableau et service de graph */
  1249. $tab_mois_fr = $this->malysDates->getTabMoisFr();
  1250. // $this->container->get('malys_user.charts');
  1252. // CA GENERE DU MOIS POUR UN COMMERCIAL
  1253. $t_ListeCA = array();
  1254. $ca = $em->getRepository(Clientvente::class)->findCommercialCa($id, $date);
  1255. foreach ($ca as $c) {
  1256. $t_ListeCA[intval($c['le_mois'])] = $c['ca_genere'];
  1257. }
  1259. // CA GENERE PREVISIONNEL
  1260. $t_ListePrev = array();
  1261. $prev = $em->getRepository(Adminprev::class)->findCommercialPrevCa($id, $date);
  1262. foreach ($prev as $p) {
  1263. $t_ListePrev[intval($p['le_mois'])] = $p['montantht'];
  1264. }
  1266. //LISTE PROSPECTION
  1267. $t_ListeProspect = array();
  1268. $pro = $em->getRepository(Client::class)->findListeProspection($id, $date);
  1269. foreach ($pro as $p) {
  1270. $t_ListeProspect[intval($p['le_mois'])][$p[0]->getNote()] = $p['nbprospect'];
  1271. }
  1273. //LISTE SIMULATION
  1274. $t_ListeSimulation = array();
  1275. $sim = $em->getRepository(Adminevent::class)->findCommercialSimulation($id, $date);
  1276. foreach ($sim as $s) {
  1277. $t_ListeSimulation[intval($s['le_mois'])] = $s['nbsimulation'];
  1278. }
  1280. //LISTE RDV CLIENTS
  1281. $t_ListeRDV = array();
  1282. $rdv = $em->getRepository(Adminevent::class)->findMyClientRdv($id, $date);
  1283. foreach ($rdv as $r) {
  1284. $t_ListeRDV[intval($r['le_mois'])] = $r['nbrdv'];
  1285. }
  1287. //LISTE TRANSFOS CLIENTS
  1288. $t_ListeTransfos = array();
  1289. $tra = $em->getRepository(Client::class)->findMyTransfoClient($id, $date);
  1290. foreach ($tra as $t) {
  1291. $t_ListeTransfos[intval($t['le_mois'])] = $t['nbtransfos'];
  1292. }
  1294. /* GRAPH */
  1295. // $objChart = new \Chart(500, 240, "chart_bar_ca_mois_" . $id . "_gd");
  1296. // $objChart->SetHeaderName("Evolution CA " . $date);
  1297. // $objChart->SetY_Barchart_Show_Values(true);
  1298. //
  1299. // for ($i = 1; $i < 13; $i++) {
  1300. // $objChart->AddValue((string)$i, (isset($t_ListeCA[$i])) ? intval($t_ListeCA[$i]) : 0);
  1301. // }
  1302. //
  1303. // $objChart->SetImageDestination("images/graph/");
  1304. // $objChart->CreateChartImage(BAR_CHART);
  1306. return $this->render('User/globalReport.html.twig', array(
  1307. 't_ListeTransfos' => $t_ListeTransfos,
  1308. 't_ListeRDV' => $t_ListeRDV,
  1309. 't_ListeSimulation' => $t_ListeSimulation,
  1310. 't_ListeProspect' => $t_ListeProspect,
  1311. 't_ListePrev' => $t_ListePrev,
  1312. 't_ListeCA' => $t_ListeCA,
  1313. 'tab_mois_fr' => $tab_mois_fr,
  1314. 'date' => $date,
  1315. 'begin' => $begin,
  1316. 'end' => $end,
  1317. 'id' => $id,
  1318. 'currentUser' => $currentUser
  1319. ));
  1320. }
  1322. /**
  1323. * @Route("/rapport_client/{date}", name="malys_user_clientreport", defaults={"date"=0})
  1324. */
  1325. public function clientReportAction($date, EntityManagerInterface $em)
  1326. {
  1327. /* annee courante par défaut */
  1328. if ($date == 0) {
  1329. $date = date('Y');
  1330. }
  1332. /* selecteur de date */
  1333. $begin = date("Y", time()) - 3;
  1334. $end = date("Y", time()) + 1;
  1335. $tab_mois_fr = $this->malysDates->getTabMoisFr();
  1337. $t_ListeCA = array();
  1338. $t_ListeMois = array();
  1339. $t_ListeDetail = array();
  1340. $totalCaGenere = 0;
  1341. $totalCaCommission = 0;
  1342. $ca = $em->getRepository(Clientvente::class)->findCommercialCaParClient($this->getUser()->getId(), $date);
  1344. foreach ($ca as $c) {
  1346. //TABLEAU DETAILLE
  1347. if (!isset($t_ListeCA[$c[0]->getIdclient()->getNom()][intval($c['le_mois'])])) {
  1348. $t_ListeCA[$c[0]->getIdclient()->getNom()][intval($c['le_mois'])] = array();
  1349. }
  1350. $t_ListeCA[$c[0]->getIdclient()->getNom()][intval($c['le_mois'])]['ca_genere'] = number_format($c['ca_genere'], 2, '.', '');
  1351. $t_ListeCA[$c[0]->getIdclient()->getNom()][intval($c['le_mois'])]['ca_commission'] = number_format($c['ca_commission'], 2, '.', '');
  1352. $t_ListeCA[$c[0]->getIdclient()->getNom()][intval($c['le_mois'])]['solde'] = number_format($c['ca_solde'], 2, '.', '');
  1354. //TABLEAU MOIS PAR MOIS
  1355. if (!isset($t_ListeMois[intval($c['le_mois'])])) {
  1356. $t_ListeMois[intval($c['le_mois'])] = array('ca_genere' => 0, 'ca_commission' => 0, 'solde' => 0);
  1357. }
  1358. $t_ListeMois[intval($c['le_mois'])]['ca_genere'] += number_format($c['ca_genere'], 2, '.', '');
  1359. $t_ListeMois[intval($c['le_mois'])]['ca_commission'] += number_format($c['ca_commission'], 2, '.', '');
  1360. $t_ListeMois[intval($c['le_mois'])]['solde'] += number_format($c['ca_solde'], 2, '.', '');
  1361. $totalCaGenere += number_format($c['ca_genere'], 2, '.', '');
  1362. $totalCaCommission += number_format($c['ca_commission'], 2, '.', '');
  1364. //TABLEAU PAR TYPE DETAIL
  1365. if (!isset($t_ListeDetail[$c[0]->getIdclient()->getNom()])) {
  1366. $t_ListeDetail[$c[0]->getIdclient()->getNom()] = array(
  1367. 'ca_genere' => 0,
  1368. 'ca_commission' => 0,
  1369. 'solde' => 0
  1370. );
  1371. }
  1372. $t_ListeDetail[$c[0]->getIdclient()->getNom()]['ca_genere'] += number_format($c['ca_genere'], 2, '.', '');
  1373. $t_ListeDetail[$c[0]->getIdclient()->getNom()]['ca_commission'] += number_format($c['ca_commission'], 2, '.', '');
  1374. $t_ListeDetail[$c[0]->getIdclient()->getNom()]['solde'] += number_format($c['ca_solde'], 2, '.', '');
  1375. }
  1377. return $this->render('user/clientReport.html.twig', array(
  1378. 'totalCaGenere' => $totalCaGenere,
  1379. 'totalCaCommission' => $totalCaCommission,
  1380. 'tab_mois_fr' => $tab_mois_fr,
  1381. 't_ListeCA' => $t_ListeCA,
  1382. 't_ListeMois' => $t_ListeMois,
  1383. 't_ListeDetail' => $t_ListeDetail,
  1384. 'date' => $date,
  1385. 'begin' => $begin,
  1386. 'end' => $end
  1387. )
  1388. );
  1389. }
  1391. /**
  1392. * @Route("/rapport_liste_clients/{date}/{id}", name="malys_user_commercialreport", defaults={"date"=0, "id"=0})
  1393. */
  1394. public function commercialReportAction($date, $id, Request $request, EntityManagerInterface $em)
  1395. {
  1396. /* AFFICHAGE DES STATS CLIENT D'UN UTILISATEUR */
  1398. /* annee courante par défaut */
  1399. if ($request->get('id')) {
  1400. $id = $request->get('id');
  1401. }
  1402. if ($request->get('vannee')) {
  1403. $date = $request->get('vannee');
  1404. }
  1405. if ($date == 0) {
  1406. $date = date('Y');
  1407. }
  1408. if ($id == 0) {
  1409. $id = $this->getUser()->getId();
  1410. }
  1412. $perf_ca = $request->get('perf_ca', null);
  1414. //echo $perf_ca;
  1416. /* selecteur de date */
  1417. $begin = date("Y", time()) - 3;
  1418. $end = date("Y", time()) + 1;
  1419. $tab_mois_fr = $this->malysDates->getTabMoisFr();
  1421. $t_ListeCA = array();
  1422. $t_ListeMois = array();
  1423. $t_ListeDetail = array();
  1424. $totalCaGenere = 0;
  1425. $totalCaCommission = 0;
  1426. $totalSolde = 0;
  1427. $ca = $em->getRepository(Clientvente::class)->findCommercialCaParClient($id, $date);
  1429. foreach ($ca as $c) {
  1431. //TABLEAU DETAILLE
  1433. if (!isset($t_ListeCA[$c[0]->getIdclient()->getNom()]['idclient'])) {
  1434. $t_ListeCA[$c[0]->getIdclient()->getNom()]['idclient'] = $c[0]->getIdclient()->getId();
  1435. }
  1437. if (!isset($t_ListeCA[$c[0]->getIdclient()->getNom()][intval($c['le_mois'])])) {
  1438. $t_ListeCA[$c[0]->getIdclient()->getNom()][intval($c['le_mois'])] = array();
  1439. }
  1440. $t_ListeCA[$c[0]->getIdclient()->getNom()][intval($c['le_mois'])]['ca_genere'] = number_format($c['ca_genere'], 2, '.', '');
  1441. $t_ListeCA[$c[0]->getIdclient()->getNom()][intval($c['le_mois'])]['ca_commission'] = number_format($c['ca_commission'], 2, '.', '');
  1442. $t_ListeCA[$c[0]->getIdclient()->getNom()][intval($c['le_mois'])]['solde'] = number_format($c['ca_solde'], 2, '.', '');
  1444. $t_ListeCA[$c[0]->getIdclient()->getNom()]['cagenere_total'] += number_format($c['ca_genere'], 2, '.', '');
  1446. //TABLEAU MOIS PAR MOIS
  1447. if (!isset($t_ListeMois[intval($c['le_mois'])])) {
  1448. $t_ListeMois[intval($c['le_mois'])] = array('ca_genere' => 0, 'ca_commission' => 0, 'solde' => 0);
  1449. }
  1450. $t_ListeMois[intval($c['le_mois'])]['ca_genere'] += number_format($c['ca_genere'], 2, '.', '');
  1451. $t_ListeMois[intval($c['le_mois'])]['ca_commission'] += number_format($c['ca_commission'], 2, '.', '');
  1452. $t_ListeMois[intval($c['le_mois'])]['solde'] += number_format($c['ca_solde'], 2, '.', '');
  1453. $totalCaGenere += number_format($c['ca_genere'], 2, '.', '');
  1454. $totalCaCommission += number_format($c['ca_commission'], 2, '.', '');
  1455. $totalSolde += number_format($c['ca_solde'], 2, '.', '');
  1457. //TABLEAU PAR TYPE DETAIL
  1458. if (!isset($t_ListeDetail[$c[0]->getIdclient()->getNom()])) {
  1459. $t_ListeDetail[$c[0]->getIdclient()->getNom()] = array(
  1460. 'ca_genere' => 0,
  1461. 'ca_commission' => 0,
  1462. 'solde' => 0
  1463. );
  1464. }
  1465. $t_ListeDetail[$c[0]->getIdclient()->getNom()]['ca_genere'] += number_format($c['ca_genere'], 2, '.', '');
  1466. $t_ListeDetail[$c[0]->getIdclient()->getNom()]['ca_commission'] += number_format($c['ca_commission'], 2, '.', '');
  1467. $t_ListeDetail[$c[0]->getIdclient()->getNom()]['solde'] += number_format($c['ca_solde'], 2, '.', '');
  1468. }
  1470. if ($perf_ca != null) {
  1471. uasort($t_ListeCA, "App\Controller\User\UserController::cmpCa");
  1472. }
  1474. /*echo "<pre>";
  1475. print_r($t_ListeCA);
  1476. echo "</pre>";*/
  1478. return $this->render('User/commercialReport.html.twig', array(
  1479. 'totalCaGenere' => $totalCaGenere,
  1480. 'totalCaCommission' => $totalCaCommission,
  1481. 'totalSolde' => $totalSolde,
  1482. 'tab_mois_fr' => $tab_mois_fr,
  1483. 't_ListeCA' => $t_ListeCA,
  1484. 't_ListeMois' => $t_ListeMois,
  1485. 't_ListeDetail' => $t_ListeDetail,
  1486. 'date' => $date,
  1487. 'begin' => $begin,
  1488. 'end' => $end,
  1489. 'id' => $id
  1490. )
  1491. );
  1492. }
  1494. private static function cmpCa($a, $b)
  1495. {
  1496. if ($a['cagenere_total'] < $b['cagenere_total']) {
  1497. return true;
  1498. }
  1500. return false;
  1501. }
  1503. /**
  1504. * @Route("/rapport_detaille/{annee}/{mois}/{semaine}/{id}", name="malys_user_detailreport", defaults={"semaine"=0, "id"=0})
  1505. */
  1506. public function detailReportAction($annee, $mois, $semaine, $id, Request $request, EntityManagerInterface $em)
  1507. {
  1509. $annee_cal = $annee;
  1510. $mois_cal = $mois;
  1511. $semaine_cal = $semaine;
  1513. if ($id == 0) {
  1514. $id = $this->getUser()->getId();
  1515. $currentUser = true;
  1516. } else {
  1517. $currentUser = false;
  1518. }
  1519. /* SEMAINE PAR DEFAUT */
  1520. if ($semaine == 0) {
  1521. if ($mois != date("n", time())) {
  1522. $semaine = date("W", mktime(0, 0, 0, $mois, 1, $annee));
  1523. } else {
  1524. $semaine = date("W", mktime(0, 0, 0, $mois, date('d'), $annee));
  1525. }
  1526. }
  1529. $tab_mois_fr = $this->malysDates->getTabMoisFr();
  1531. //CA GENERE DU MOIS POUR UN COMMERCIAL
  1532. $ca = $em->getRepository(Clientvente::class)->findCommercialCaInMonth($id, $annee, $mois);
  1534. //OBJECTIF DE CA
  1535. $caObj = $em->getRepository(Adminprev::class)->findCommercialPrevCaInMonth($id, $annee, $mois);
  1537. //RECUPERATION DES COMMISSIONS UTILISATEURS
  1538. $com = $em->getRepository(Clientvente::class)->findCommercialCommission($id, $annee, $mois);
  1540. /* TOTAL COMMISSION */
  1541. $totalCommission = 0;
  1542. foreach ($com as $c) {
  1543. $totalCommission += $c->getMontantht() * $c->getAdmincom() / 100;
  1544. }
  1546. //LISTE PROSPECTION HEBDO
  1547. $t_ListeProspect = array();
  1548. $totalProspect = 0;
  1549. $pro = $em->getRepository(Client::class)->findListeProspectionHebdo($id, $annee, $semaine);
  1550. foreach ($pro as $p) {
  1551. $t_ListeProspect[$p[0]->getNote()] = $p['nbprospect'];
  1552. $totalProspect += $p['nbprospect'];
  1553. }
  1555. //RECUPERATION DES OBJECTIFS RDV
  1556. $rdv = $em->getRepository(Adminprevrdv::class)->findOneBy(array(
  1557. 'idadmin' => $id,
  1558. 'annee' => $annee,
  1559. 'semaine' => $semaine
  1560. ));
  1562. //LISTE SIMULATION HEBDO
  1563. $simu = $em->getRepository(Adminevent::class)->findCommercialSimulationHebdo($id, $annee, $semaine);
  1565. //LISTE RDV CLIENTS
  1566. $rdvClient = $em->getRepository(Adminevent::class)->findMyClientRdvHebdo($id, $annee, $semaine);
  1568. //LISTE TRANSFOS CLIENTS
  1569. $transfo = $em->getRepository(Client::class)->findMyTransfoClientHebdo($id, $annee, $semaine);
  1571. //LISTE DETAILLEE PROSPECTION HEBDO
  1572. $dPro = $em->getRepository(Client::class)->findListeProspectHebdoDetail($id, $annee, $semaine);
  1574. //LISTE SIMULATION HEBDO DETAIL
  1575. $s = $em->getRepository(Adminevent::class)->findCommercialSimulationHebdoDetail($id, $annee, $semaine);
  1577. //LISTE DETAILLEE RDV CLIENTS
  1578. $rdvClientDetail = $em->getRepository(Adminevent::class)->findMyClientRdvHebdoDetail($id, $annee, $semaine);
  1580. //LISTE DETAILLEE TRANSFOS CLIENTS
  1581. $tansfoDet = $em->getRepository(Client::class)->findMyTransfoClientHebdoDetail($id, $annee, $semaine);
  1583. //RECUPERATION DES RELANCES PROSPECTS
  1584. $relances = $em->getRepository(Adminevent::class)->findProspectRelanceHebdo($id, $annee, $semaine);
  1586. //ALL CA FRN BY MONTH/YEAR OF COMMERCIAL
  1587. $getAllCaByMonth = $em->getRepository(Clientvente::class)->getAllCaByMonth(3, $id, "Commercial");
  1590. //RECUPERE LE MOIS VALIDE LE PLUS PROCHE
  1591. $MonthValid = $em->getRepository(Moisvalide::class)->findLastMoisvalide(date("n"), date("Y"));
  1593. $annee = $MonthValid[0]['annee'];
  1594. $mois_valide = $MonthValid[0]['mois'];
  1596. //ALL OBJECTIF BY MONTH/YEAR
  1597. $t_Objectifs = $em->getRepository(Adminprev::class)->getAllPrevCaByMonth($id, "Commercial", $annee);
  1599. $t_objectif = array();
  1600. $obj_total = 0;
  1602. foreach ($t_Objectifs as $key => $item) {
  1603. (intval($item['objectif'] != 0)) ? array_push($t_objectif, intval($item['objectif'])) : array_push($t_objectif, null);
  1604. $obj_total += intval($item['objectif']);
  1605. }
  1607. //création json pour chart CA
  1608. $t_ca_chart = array();
  1610. foreach ($getAllCaByMonth as $key => $item) {
  1611. $t_ca = array();
  1612. $i = 0;
  1613. foreach ($item as $year => $ca) {
  1614. if ($i != 0) {
  1615. (intval($ca) != 0) ? array_push($t_ca, intval($ca)) : array_push($t_ca, null);
  1616. }
  1617. $i++;
  1618. }
  1619. ($item["Annee"] == $annee) ? array_push($t_ca_chart, (object)array(
  1620. 'name' => $item["Annee"],
  1621. 'data' => $t_ca
  1622. )) : array_push($t_ca_chart, (object)array(
  1623. 'name' => $item["Annee"],
  1624. 'visible' => false,
  1625. 'data' => $t_ca
  1626. ));
  1627. }
  1630. array_push($t_ca_chart, (object)array('name' => "Objectifs", 'color' => '#a3dfd9', 'data' => $t_objectif));
  1631. array_push($t_objectif, $obj_total);
  1634. $t_ca_chart_json = json_encode($t_ca_chart);
  1635. unset($t_ca_chart); //Free memoire
  1637. //ALL CA CLIENT BY MONTH/YEAR
  1638. $t_allCaClientByMonth = $em->getRepository(Clientvente::class)->getAllClientsCaLight($annee, null, 'three year', $id, "commercial");
  1640. $t_ListeCaClientForChart = array();
  1641. $t_ListeCaFamilleForChart = array();
  1643. $t_CaFamilleForChart = array();
  1645. // Recuperation tab CAclient/mois et tab CaFamille/mois
  1646. foreach ($t_allCaClientByMonth as $caClient => $item) {
  1647. $yearfr = $item['datefr']->format('Y');
  1648. $monthfr = $item['datefr']->format('n');
  1649. // Si l'année, le mois et le client n'existe pas dans le tableau d'arrivée, on l'ajoute au tableau
  1650. if ($yearfr == date('Y') || $yearfr == date('Y') - 1) {
  1651. if (!isset($t_ListeCaClientForChart[$yearfr][$monthfr][$item['id']])) {
  1652. if ($item['ca_genere'] > 0) {
  1653. $t_ListeCaClientForChart[$yearfr][$monthfr][$item['id']] = array();
  1654. $t_ListeCaClientForChart[$yearfr][$monthfr][$item['id']]['ca_genere'] = number_format((float)$item['ca_genere'], 2, '.', '');
  1655. }
  1656. } else { // Si la case existe déjà
  1657. if ($item['ca_genere'] > 0) {
  1658. $t_ListeCaClientForChart[$yearfr][$monthfr][$item['id']]['ca_genere'] += number_format((float)$item['ca_genere'], 2, '.', '');
  1659. }
  1660. }
  1661. }
  1663. // Si l'année n'existe pas dans le tableau CAfamille d'arrivée, on ajoute la case avec la l'année
  1664. if ($yearfr == date('Y')) {
  1666. if (!isset($t_ListeCaFamilleForChart[$item['famille']])) {
  1667. $t_ListeCaFamilleForChart[$item['famille']] = array();
  1668. $t_ListeCaFamilleForChart[$item['famille']] = number_format((float)$item['ca_genere'], 2, '.', '');
  1669. } else {
  1670. $t_ListeCaFamilleForChart[$item['famille']] += number_format((float)$item['ca_genere'], 2, '.', '');
  1671. }
  1672. }
  1673. }
  1675. unset($t_allCaClientByMonth); //Free memoire
  1677. $t_ca_famille = array();
  1678. foreach ($t_ListeCaFamilleForChart as $key => $value) {
  1679. ($key != "") ? array_push($t_ca_famille, array(
  1680. $key,
  1681. intval($value)
  1682. )) : array_push($t_ca_famille, array("AUTRE", intval($value)));
  1683. }
  1684. // Obtient une liste de colonnes
  1686. $volume = array();
  1687. foreach ($t_ca_famille as $key => $row) {
  1688. $volume[$key] = $row[1];
  1689. $edition[$key] = $row[0];
  1690. }
  1691. // Trie les données par volume décroissant, edition croissant
  1692. // Ajoute $data en tant que dernier paramètre, pour trier par la clé commune
  1693. if ($volume) {
  1694. array_multisort($volume, SORT_DESC, $edition, SORT_ASC, $t_ca_famille);
  1695. }
  1697. array_push($t_CaFamilleForChart, (object)array(
  1698. 'type' => 'pie',
  1699. 'name' => 'Famille',
  1700. 'data' => $t_ca_famille
  1701. ));
  1703. unset($t_ca_famille); // free Memory
  1705. $t_CaFamilleForChart_json = json_encode($t_CaFamilleForChart);
  1707. unset($t_CaFamilleForChart);
  1708. unset($t_ListeCaFamilleForChart);
  1710. $t_gp_val_chart = array();
  1711. $t_gp_client_chart = array();
  1712. $t_ListeGainsPertes = array(
  1713. 0 => array('gain' => array(), 'perte' => array(), 'type' => 'ca'),
  1714. 1 => array('gain' => array(), 'perte' => array(), 'type' => 'client')
  1715. );
  1717. if (isset($t_ListeCaClientForChart[$annee - 1][12])) {
  1718. foreach ($t_ListeCaClientForChart[$annee - 1][12] as $id_client => $ca) {
  1719. (!array_key_exists($id_client, $t_ListeCaClientForChart[$annee][1])) ? $t_ListeCaClientForChart[$annee][1][$id_client] = array('ca_genere' => 0.0) : null;
  1720. }
  1721. }
  1723. foreach ($t_ListeCaClientForChart as $year => $item) {
  1725. foreach ($item as $month => $val) {
  1727. foreach ($val as $id_client => $ca) {
  1728. for ($i = 1; $i < count($item); $i++) {
  1730. if (isset($t_ListeCaClientForChart[$year][$i])) {
  1731. (!array_key_exists($id_client, $t_ListeCaClientForChart[$year][$i])) ? $t_ListeCaClientForChart[$year][$i][$id_client] = array('ca_genere' => 0.0) : null;
  1732. }
  1734. }
  1735. }
  1736. }
  1737. }
  1739. for ($i = 1; $i <= 12; $i++) {
  1740. (!isset($t_ListeCaClientForChart[$annee][$i])) ? $t_ListeCaClientForChart[$annee][$i] = null : 1;
  1741. }
  1742. ksort($t_ListeCaClientForChart[$annee], SORT_ASC);
  1743. //calcul et recuperation "pertes et gains" total en valeur et client/MOIS
  1744. foreach ($t_ListeCaClientForChart as $year => $item) {
  1745. $t_gains_valeur = array();
  1746. $t_pertes_valeur = array();
  1747. $t_gains_client = array();
  1748. $t_pertes_client = array();
  1750. if ($year == $annee) {
  1751. foreach ($item as $month => $val) {
  1752. $gainsValeur = 0;
  1753. $pertesValeur = 0;
  1754. $gainsClient = 0;
  1755. $pertesClient = 0;
  1756. if ($val != null) {
  1757. foreach ($val as $client => $caClient) {
  1758. $caMoisPrec = 0;
  1759. if ($month != 1) { // Si C'est pas le mois de janvier
  1760. if (isset($item[$month - 1][$client])) {
  1762. $caMoisPrec = $item[$month - 1][$client]['ca_genere'];
  1763. }
  1764. } else { // si c'est janvier => IDEM avec décembre de l'année précédente
  1765. if (isset($t_ListeCaClientForChart[$year - 1][12][$client])) {
  1766. $caMoisPrec = $t_ListeCaClientForChart[$year - 1][12][$client]['ca_genere'];
  1767. }
  1768. }
  1770. $diff = ($caClient['ca_genere']) - ($caMoisPrec); // ON calcul $diff => CA du mois - (Ca du mois-1) [exemple: CAmars - CAfevrier ]
  1771. ($diff < 0) ? $pertesValeur += $diff : $gainsValeur += $diff; // On met a jour Gains et Pertes
  1773. //On calcul $evoCa => (CA du mois - (Ca du mois-1)) / (Ca du mois-1) [exemple: (CAmars - CAfevrier)/CAfevrier ]
  1774. if ($caMoisPrec != 0) {
  1775. $evoCa = (($caClient['ca_genere']) - ($caMoisPrec)) / ($caMoisPrec);
  1776. } else {
  1777. $evoCa = 0;
  1778. }
  1779. // On met a jour Gains et Pertes Client
  1780. if ($evoCa < 0) {
  1781. $pertesClient--;
  1782. }
  1783. if ($evoCa > 0) {
  1784. $gainsClient++;
  1785. }
  1786. }
  1787. } else {
  1788. $gainsClient = null;
  1789. $pertesClient = null;
  1790. $pertesValeur = null;
  1791. $gainsValeur = null;
  1792. }
  1793. array_push($t_gains_valeur, $gainsValeur);
  1794. array_push($t_pertes_valeur, $pertesValeur);
  1795. array_push($t_gains_client, $gainsClient);
  1796. array_push($t_pertes_client, $pertesClient);
  1797. }
  1798. }
  1799. if ($year == $annee) {
  1800. array_push($t_gp_val_chart, (object)array('name' => "Gains", 'data' => $t_gains_valeur)); //Valeur
  1801. array_push($t_gp_val_chart, (object)array(
  1802. 'name' => "Pertes",
  1803. 'data' => $t_pertes_valeur
  1804. )); //Valeur
  1805. array_push($t_gp_client_chart, (object)array(
  1806. 'name' => "Gains",
  1807. 'data' => $t_gains_client
  1808. )); //Client
  1809. array_push($t_gp_client_chart, (object)array(
  1810. 'name' => "Pertes",
  1811. 'data' => $t_pertes_client
  1812. )); //Client
  1814. array_push($t_ListeGainsPertes[0]['gain'], $t_gains_valeur); //Valeur
  1815. array_push($t_ListeGainsPertes[0]['perte'], $t_pertes_valeur); //Valeur
  1816. array_push($t_ListeGainsPertes[1]['gain'], $t_gains_client); //Client
  1817. array_push($t_ListeGainsPertes[1]['perte'], $t_pertes_client); //Client
  1818. }
  1819. }
  1821. $t_gp_val_chart_json = json_encode($t_gp_val_chart);
  1822. $t_gp_client_chart_json = json_encode($t_gp_client_chart);
  1825. /*TABLEAU GAINS PERTES */
  1826. $tab_moy = array('moyValP' => 0, 'moyCliP' => 0, 'moyValG' => 0, 'moyCliG' => 0);
  1827. $next = 0;
  1828. $nbmonth = 0;
  1829. foreach ($t_ListeGainsPertes as $key => $val) {
  1831. if ($val['gain'][0]) {
  1832. foreach ($val['gain'][0] as $k => $value) {
  1833. ($next == 0) ? $tab_moy['moyValG'] += $value : $tab_moy['moyCliG'] += $value;
  1834. ($next == 0) ? $nbmonth++ : null;
  1835. }
  1836. }
  1837. if ($val['perte'][0]) {
  1838. foreach ($val['perte'][0] as $k => $value) {
  1839. ($next == 0) ? $tab_moy['moyValP'] += $value : $tab_moy['moyCliP'] += $value;
  1840. }
  1841. }
  1842. $next++;
  1843. }
  1844. if ($nbmonth != 0) {
  1845. array_push($t_ListeGainsPertes[0]['gain'], $tab_moy['moyValG'] / $nbmonth);
  1846. array_push($t_ListeGainsPertes[0]['perte'], $tab_moy['moyValP'] / $nbmonth);
  1847. array_push($t_ListeGainsPertes[1]['gain'], $tab_moy['moyCliG'] / $nbmonth);
  1848. array_push($t_ListeGainsPertes[1]['perte'], $tab_moy['moyCliP'] / $nbmonth);
  1849. }
  1852. unset($t_gp_val_chart); //Free Memoire
  1853. unset($t_gp_client_chart);
  1854. unset($t_gains_valeur);
  1855. unset($t_pertes_valeur);
  1856. unset($t_gains_client);
  1857. unset($t_pertes_client);
  1859. // Recuperation segClient/mois et segValeur/mois
  1860. $t_seg_client_chart = array();
  1861. $t_seg_valeur_chart = array();
  1862. $t_seg_client = array(
  1863. '0' => array(),
  1864. '1' => array(),
  1865. '2' => array(),
  1866. '3' => array(),
  1867. '4' => array(),
  1868. '5' => array()
  1869. );
  1870. $t_seg_valeur = array(
  1871. '0' => array(),
  1872. '1' => array(),
  1873. '2' => array(),
  1874. '3' => array(),
  1875. '4' => array(),
  1876. '5' => array()
  1877. );
  1878. $t_seg = array(
  1879. 0 => array("palier" => 500, "valeur" => 0, "client" => 0, "name" => '0-500'),
  1880. 1 => array("palier" => 1500, "valeur" => 0, "client" => 0, "name" => '500-1500'),
  1881. 2 => array("palier" => 3000, "valeur" => 0, "client" => 0, "name" => '1500-3000'),
  1882. 3 => array("palier" => 9000, "valeur" => 0, "client" => 0, "name" => '3000-9000'),
  1883. 4 => array("palier" => 20000, "valeur" => 0, "client" => 0, "name" => '9000-20000'),
  1884. 5 => array("valeur" => 0, "client" => 0, "name" => '>20000'),
  1885. );
  1887. $Liste_client_groupe1 = array($year => array());
  1889. // On recupere les valeurs de segmentation
  1890. foreach ($t_ListeCaClientForChart as $year => $item) {
  1891. if ($year == $annee) {
  1892. foreach ($item as $month => $val) {
  1893. for ($i = 0; $i < count($t_seg); $i++) {
  1894. $t_seg[$i]["valeur"] = 0;
  1895. $t_seg[$i]["client"] = 0;
  1896. }
  1897. (!isset($Liste_client_groupe1[$year][$month])) ? $Liste_client_groupe1[$year][$month] = array() : 1;
  1900. if ($val != null) {
  1901. foreach ($val as $client => $caClient) {
  1902. //Récupération des valeurs de segementation
  1903. if ($caClient['ca_genere'] > 1 && $caClient['ca_genere'] <= $t_seg[0]["palier"]) {
  1904. $t_seg[0]["valeur"] += $caClient['ca_genere'];
  1905. $t_seg[0]["client"] += 1;
  1907. //TODO EXTRACT LIST OF CLIENT BY GROUPE AND BY MONTH
  1908. array_push($Liste_client_groupe1[$year][$month], $client);
  1909. } else if ($caClient['ca_genere'] > $t_seg[0]["palier"] && $caClient['ca_genere'] <= $t_seg[1]["palier"]) {
  1910. $t_seg[1]["valeur"] += $caClient['ca_genere'];
  1911. $t_seg[1]["client"] += 1;
  1912. } else if ($caClient['ca_genere'] > $t_seg[1]["palier"] && $caClient['ca_genere'] <= $t_seg[2]["palier"]) {
  1913. $t_seg[2]["valeur"] += $caClient['ca_genere'];
  1914. $t_seg[2]["client"] += 1;
  1915. } else if ($caClient['ca_genere'] > $t_seg[2]["palier"] && $caClient['ca_genere'] <= $t_seg[3]["palier"]) {
  1916. $t_seg[3]["valeur"] += $caClient['ca_genere'];
  1917. $t_seg[3]["client"] += 1;
  1918. } else if ($caClient['ca_genere'] > $t_seg[3]["palier"] && $caClient['ca_genere'] <= $t_seg[4]["palier"]) {
  1919. $t_seg[4]["valeur"] += $caClient['ca_genere'];
  1920. $t_seg[4]["client"] += 1;
  1921. } else if ($caClient['ca_genere'] > $t_seg[4]["palier"]) {
  1922. $t_seg[5]["valeur"] += $caClient['ca_genere'];
  1923. $t_seg[5]["client"] += 1;
  1924. }
  1925. }
  1926. }
  1927. foreach ($t_seg as $key => $value) {
  1928. if ($year == $annee) {
  1929. for ($i = 0; $i < 6; $i++) {
  1930. if ($key == $i) {
  1931. array_push($t_seg_client[$i], $value['client']);
  1932. array_push($t_seg_valeur[$i], $value['valeur']);
  1933. }
  1934. }
  1935. }
  1936. }
  1937. }
  1938. }
  1939. }
  1940. $t_ListeSeg = array();
  1941. array_push($t_ListeSeg, $t_seg_client);
  1942. array_push($t_ListeSeg, $t_seg_valeur);
  1944. foreach ($t_ListeSeg as $key => $val) {
  1946. foreach ($val as $k => $value) {
  1947. $total = 0;
  1948. for ($i = 0; $i < count($value); $i++) {
  1949. $total += $value[$i];
  1950. }
  1952. if ($key == 1) {
  1953. $t_ListeSeg[$key][$k]['total_group'] = $total;
  1954. } else {
  1955. (count($value) != 0) ? $t_ListeSeg[$key][$k]['total_group'] = ($total / count($value)) : null;
  1956. }
  1957. for ($j = 0; $j < count($t_seg); $j++) {
  1958. $t_ListeSeg[$key][$j]['nom'] = $t_seg[$j]['name'];
  1959. }
  1960. }
  1961. }
  1963. $t_listeNbCommande = array();
  1964. $t_listeCaSeg = array();
  1966. for ($j = 0; $j < 12; $j++) {
  1967. $total_client = 0;
  1968. $total_ca = 0;
  1969. foreach ($t_ListeSeg[0] as $key => $val) {
  1970. (isset($val[$j])) ? $total_client += $val[$j] : null;
  1971. }
  1972. array_push($t_listeNbCommande, $total_client);
  1974. foreach ($t_ListeSeg[1] as $key => $val) {
  1975. (isset($val[$j])) ? $total_ca += $val[$j] : null;
  1976. }
  1977. array_push($t_listeCaSeg, $total_ca);
  1980. }
  1982. for ($j = 5; $j > -1; $j--) {
  1983. array_push($t_seg_client_chart, (object)array(
  1984. 'type' => "column",
  1985. 'name' => $t_seg[$j]['name'],
  1986. 'data' => $t_seg_client[$j],
  1987. 'id' => $t_seg[$j]['name'] . 'c',
  1988. )
  1989. );
  1990. array_push($t_seg_valeur_chart, (object)array(
  1991. 'type' => "column",
  1992. 'name' => $t_seg[$j]['name'],
  1993. 'data' => $t_seg_valeur[$j],
  1994. 'id' => $t_seg[$j]['name'] . 'v',
  1995. ));
  1996. }
  1997. for ($j = 5; $j > -1; $j--) {
  1998. array_push($t_seg_client_chart, (object)array(
  1999. 'name' => 'seg1->',
  2000. 'id' => $t_seg[$j]['name'] . 'cc',
  2001. 'showInLegend' => false,
  2002. 'color' => 'red',
  2003. 'lineWidth' => 1,
  2004. 'marker' => (object)array(
  2005. 'lineWidth' => 0.1,
  2006. 'lineColor' => 'Highcharts.getOptions().colors[4]',
  2007. 'fillColor' => "white",
  2008. "radius" => 2,
  2009. 'enabled' => true
  2010. ),
  2011. 'data' => $t_seg_client[$j]
  2012. ));
  2013. array_push($t_seg_valeur_chart, (object)array(
  2014. 'name' => "seg1->",
  2015. 'id' => $t_seg[$j]['name'] . 'vv',
  2016. 'showInLegend' => false,
  2017. 'color' => 'red',
  2018. 'lineWidth' => 1,
  2019. 'marker' => (object)array(
  2020. 'lineWidth' => 0.1,
  2021. 'lineColor' => 'Highcharts.getOptions().colors[4]',
  2022. 'fillColor' => "white",
  2023. "radius" => 2,
  2024. 'enabled' => true
  2025. ),
  2026. 'data' => $t_seg_valeur[$j]
  2027. ));
  2028. }
  2030. $t_seg_client_chart_json = json_encode($t_seg_client_chart);
  2031. $t_seg_valeur_chart_json = json_encode($t_seg_valeur_chart);
  2034. unset($t_seg);
  2035. unset($t_seg_client_chart);
  2036. unset($t_seg_client); //free Memory
  2037. unset($t_seg_valeur_chart);
  2038. unset($t_seg_valeur); //free Memory
  2041. // Recupération informations pour tableau fournisseurs global
  2042. /* TRAITEMENT FORMULAIRE ET VALEURS PAR DEFAUT */
  2043. $year = $request->get('year', date('Y'));
  2044. $source = $request->get('source', null) == '' ? null : $request->get('source', null);
  2045. $perf_ca = $request->get('perf_ca', null);
  2046. $type = 'fournisseur';
  2048. /* GET CA */
  2049. $cv = $em->getRepository(Clientvente::class)->getAllFournisseursCa($year, $source, "three year", $id, "commercial");
  2051. $t_ListeCA_frn = array();
  2052. $t_ListeMois = array();
  2053. $t_ListeDetail = array();
  2054. foreach ($cv as $c) {
  2056. $mois = intval($c[0]['datefr']->format('m'));
  2057. $yeartraitement = intval($c[0]['datefr']->format('Y'));
  2058. $id_frn = $c['id'];
  2060. //TABLEAU ANNNEE TOTAUX
  2061. if (!isset($t_ListeMois[$yeartraitement])) {
  2062. $t_ListeMois[$yeartraitement] = array(
  2063. 'cagenere_total' => 0,
  2064. 'cacommission_total' => 0,
  2065. 'solde_total' => 0
  2066. );
  2067. }
  2070. //TABLEAU DETAILLE
  2071. if (!isset($t_ListeCA_frn[$yeartraitement][$id_frn])) {
  2072. $t_ListeCA_frn[$yeartraitement][$id_frn] = array(
  2073. 'cagenere_total' => 0,
  2074. 'cacommission_total' => 0,
  2075. 'solde_total' => 0
  2076. );
  2077. }
  2079. $t_ListeCA_frn[$yeartraitement][$id_frn][$mois]['ca_genere'] = number_format($c['ca_genere'], 2, '.', '');
  2080. $t_ListeCA_frn[$yeartraitement][$id_frn][$mois]['ca_commission'] = number_format($c['ca_commission'], 2, '.', '');
  2081. $t_ListeCA_frn[$yeartraitement][$id_frn][$mois]['solde'] = number_format($c['ca_solde'], 2, '.', '');
  2083. $t_ListeCA_frn[$yeartraitement][$id_frn]['id' . $type] = $c['id'];
  2084. $t_ListeCA_frn[$yeartraitement][$id_frn]['nom'] = $c['nom'];
  2086. $t_ListeCA_frn[$yeartraitement][$id_frn]['cagenere_total'] += number_format($c['ca_genere'], 2, '.', '');
  2087. $t_ListeCA_frn[$yeartraitement][$id_frn]['cacommission_total'] += number_format($c['ca_commission'], 2, '.', '');
  2088. $t_ListeCA_frn[$yeartraitement][$id_frn]['solde_total'] += number_format($c['ca_solde'], 2, '.', '');
  2089. $t_ListeCA_frn[$yeartraitement][$id_frn]['source'] = $c['source'];
  2091. //TABLEAU ANNEE MOIS PAR MOIS
  2092. if (!isset($t_ListeMois[$yeartraitement][$mois])) {
  2093. $t_ListeMois[$yeartraitement][$mois] = array(
  2094. 'ca_genere' => 0,
  2095. 'ca_commission' => 0,
  2096. 'solde' => 0
  2097. );
  2098. }
  2100. $t_ListeMois[$yeartraitement][$mois]['ca_genere'] += number_format($c['ca_genere'], 2, '.', '');
  2101. $t_ListeMois[$yeartraitement][$mois]['ca_commission'] += number_format($c['ca_commission'], 2, '.', '');
  2102. $t_ListeMois[$yeartraitement][$mois]['solde'] += number_format($c['ca_solde'], 2, '.', '');
  2104. //TEABLEAU TOTAL
  2105. $t_ListeMois[$yeartraitement]['cagenere_total'] += number_format($c['ca_genere'], 2, '.', '');
  2106. $t_ListeMois[$yeartraitement]['cacommission_total'] += number_format($c['ca_commission'], 2, '.', '');
  2107. $t_ListeMois[$yeartraitement]['solde_total'] += number_format($c['ca_solde'], 2, '.', '');
  2110. //TABLEAU PAR TYPE DETAIL
  2111. if (!isset($t_ListeDetail[$yeartraitement][$id_frn])) {
  2112. $t_ListeDetail[$yeartraitement][$id_frn] = array(
  2113. 'ca_genere' => 0,
  2114. 'ca_commission' => 0,
  2115. 'solde' => 0
  2116. );
  2117. }
  2119. $t_ListeDetail[$yeartraitement][$id_frn]['ca_genere'] += number_format($c['ca_genere'], 2, '.', '');
  2120. $t_ListeDetail[$yeartraitement][$id_frn]['ca_commission'] += number_format($c['ca_commission'], 2, '.', '');
  2121. $t_ListeDetail[$yeartraitement][$id_frn]['solde'] += number_format($c['ca_solde'], 2, '.', '');
  2122. $t_ListeDetail[$yeartraitement][$id_frn]['source'] = $c['source'];
  2124. }
  2126. if ($perf_ca != null) {
  2127. uasort($t_ListeCA, "App\\Controller\\Marketing::cmpCa");
  2128. }
  2131. return $this->render('User/detailReport.html.twig', array(
  2132. 'ListeRelance' => $relances[0],
  2133. 'ListeSimulationDet' => $s,
  2134. 't_prospect_note' => Tools::getNote(),
  2135. 'ListeDetProspect' => $dPro,
  2136. 'ListeDetTransfos' => $tansfoDet,
  2137. 'ListeTransfos' => $transfo[0],
  2138. 'ListeDetRDV' => $rdvClientDetail,
  2139. 'ListeRDV' => $rdvClient[0],
  2140. 'ListeSimulation' => $simu[0],
  2141. 'Obj_RDV' => $rdv,
  2142. 'Res_CA' => (!empty($ca) && isset($ca[0]['ca_genere'])) ? $ca[0]['ca_genere'] : '0.00',
  2143. 'Res_CA_obj' => (!empty($caObj)) ? $caObj[0]->getMontantht() : '0.00',
  2144. 'totalProspect' => $totalProspect,
  2145. 't_ListeProspect' => $t_ListeProspect,
  2146. 'Commissions' => $com,
  2147. 'totalCommission' => $totalCommission,
  2148. 'tab_mois_fr' => $tab_mois_fr,
  2149. 'mois_cal' => $mois_cal,
  2150. 'annee_cal' => $annee_cal,
  2151. 'semaine_cal' => $semaine_cal,
  2152. 'mois' => $mois,
  2153. 'annee' => $annee,
  2154. 'semaine' => $semaine,
  2155. 'id' => $id,
  2156. 'currentUser' => $currentUser,
  2158. 't_objectif' => $t_objectif,
  2159. 't_ca_chart_json' => $t_ca_chart_json,
  2160. 'user' => $this->getUser()->getFamille(),
  2162. 't_ListeSeg' => $t_ListeSeg,
  2163. 't_ListeGainsPertes' => $t_ListeGainsPertes,
  2164. 't_ListeDetail' => $t_ListeDetail,
  2165. 't_ListeMois' => $t_ListeMois,
  2166. 't_ListeCA' => $t_ListeCA_frn,
  2169. 't_ca_chart_json' => $t_ca_chart_json,
  2170. 't_gp_val_chart_json' => $t_gp_val_chart_json,
  2171. 't_gp_client_chart_json' => $t_gp_client_chart_json,
  2172. 't_CaFamilleForChart_json' => $t_CaFamilleForChart_json,
  2173. 't_seg_client_chart_json' => $t_seg_client_chart_json,
  2174. 't_seg_valeur_chart_json' => $t_seg_valeur_chart_json,
  2175. 'type' => 'fournisseur',
  2176. 't_listeNbCommande' => $t_listeNbCommande,
  2177. 't_listeCaSeg' => $t_listeCaSeg,
  2179. ));
  2180. }
  2182. public function calMonthAction($mois, $annee, $semaine, $route, $id = 0)
  2183. {
  2184. if ($id == 0) {
  2185. $currentUser = true;
  2186. } else {
  2187. $currentUser = false;
  2188. }
  2190. //valeurs par defaut pour le calendrier
  2191. $mois = $mois == "" ? date("n", mktime(0, 0, 0, date("m"), date("d"), $annee)) : $mois;
  2192. $annee = $annee == "" ? date("Y", mktime(0, 0, 0, date("m"), date("d"), $annee)) : $annee;
  2194. //initialisation txt fran�ais
  2195. $mois_nom = array(
  2196. "Janvier",
  2197. "Février",
  2198. "Mars",
  2199. "Avril",
  2200. "Mai",
  2201. "Juin",
  2202. "Juillet",
  2203. "Août",
  2204. "Septembre",
  2205. "Octobre",
  2206. "Novembre",
  2207. "Décembre"
  2208. );
  2210. //initialisation des dates
  2211. $premierj = date("w", mktime(0, 0, 0, $mois, 1, $annee));
  2212. $moisnj = date("t", mktime(0, 0, 0, $mois, 1, $annee));
  2214. //initialisation des donn�es tableau
  2215. if ($premierj == 0) {
  2216. $premierj = 7;
  2217. }
  2218. //nombre de case du calendrier
  2219. $nbcases = ($moisnj + $premierj - 1);
  2220. //nombre de lignes du calendrier
  2221. $nblignes = ceil($nbcases / 7);
  2223. //liens précédents & suivant
  2224. $mois_pre = $mois == 1 ? 12 : ($mois - 1);
  2225. $mois_suiv = $mois == 12 ? 1 : ($mois + 1);
  2227. $annee_prev = $mois == 1 ? $annee - 1 : $annee;
  2228. $annee_next = $mois == 12 ? $annee + 1 : $annee;
  2230. //CONSTRUCTION DU TABLEAU
  2231. $tab_html = "<table border='0' width='100%' cellspacing='0' cellpadding='0' align='center' class='Calendrier_fond'>";
  2233. //LIGNES DE LA NAVIGATION MOIS
  2234. $tab_html .= "<tr>";
  2235. $tab_html .= "<td>";
  2236. $tab_html .= "<table width='100%' border='0' cellspacing='0' cellpadding='3' class='Calendrier_titre'>";
  2237. $tab_html .= "<tr>";
  2238. if ($currentUser) {
  2239. $tab_html .= "<td width='30'><a href='" . $this->generateUrl($route, array(
  2240. 'annee' => $annee_prev,
  2241. 'mois' => $mois_pre
  2242. )) . "'>&lt;&lt;</a></td>";
  2243. } else {
  2244. $tab_html .= "<td width='30'><a href='" . $this->generateUrl($route, array(
  2245. 'annee' => $annee_prev,
  2246. 'mois' => $mois_pre,
  2247. 'id' => $id
  2248. )) . "'>&lt;&lt;</a></td>";
  2249. }
  2250. $tab_html .= "<td align='center'>" . $mois_nom[$mois - 1] . " " . $annee . "</td>";
  2251. if ($currentUser) {
  2252. $tab_html .= "<td width='30' align='right'><a href='" . $this->generateUrl($route, array(
  2253. 'annee' => $annee_next,
  2254. 'mois' => $mois_suiv
  2255. )) . "'>&gt;&gt;</a></td>";
  2256. } else {
  2257. $tab_html .= "<td width='30' align='right'><a href='" . $this->generateUrl($route, array(
  2258. 'annee' => $annee_next,
  2259. 'mois' => $mois_suiv,
  2260. 'id' => $id
  2261. )) . "'>&gt;&gt;</a></td>";
  2262. }
  2263. $tab_html .= "</tr>";
  2264. $tab_html .= "</table>";
  2265. $tab_html .= "</td>";
  2266. $tab_html .= "</tr>";
  2268. //LIGNES DU CALENDRIER
  2269. $tab_html .= "<tr>";
  2270. $tab_html .= "<td>";
  2271. $tab_html .= "<table width='100%' border='0' cellspacing='0' cellpadding='2' class='Calendrier_jours'>";
  2272. $tab_html .= "<tr>";
  2273. $tab_html .= "<td width='23'>&nbsp;</td>";
  2274. $tab_html .= "<td width='23'>L</td>";
  2275. $tab_html .= "<td width='23'>M</td>";
  2276. $tab_html .= "<td width='23'>M</td>";
  2277. $tab_html .= "<td width='23'>J</td>";
  2278. $tab_html .= "<td width='23'>V</td>";
  2279. $tab_html .= "<td width='23'>S</td>";
  2280. $tab_html .= "<td width='23'>D</td>";
  2281. $tab_html .= "</tr>";
  2282. //initialisation du compteur de case
  2283. $compteurj = 1;
  2284. //ecriture des cases
  2285. for ($i = 1; $i < ($nblignes + 1); $i++) {
  2286. $tab_html .= "<tr>";
  2288. //definition de la semaine
  2289. if ($i == 1) {
  2290. $numsemaine = intval(date("W", mktime(0, 0, 0, $mois, 1, $annee)));
  2291. } else {
  2292. $numsemaine = intval(date("W", mktime(0, 0, 0, $mois, $compteurj - $premierj + 1, $annee)));
  2293. }
  2294. if ($currentUser) {
  2295. $tab_html .= "<td width='23' " . (($semaine == $numsemaine) ? "class='Calendrier_LaSemaine'" : "") . "><a href='" . $this->generateUrl($route, array(
  2296. 'annee' => $annee,
  2297. 'mois' => $mois,
  2298. 'semaine' => $numsemaine
  2299. )) . "'>" . $numsemaine . "</a></td>";
  2300. } else {
  2301. $tab_html .= "<td width='23' " . (($semaine == $numsemaine) ? "class='Calendrier_LaSemaine'" : "") . "><a href='" . $this->generateUrl($route, array(
  2302. 'annee' => $annee,
  2303. 'mois' => $mois,
  2304. 'semaine' => $numsemaine,
  2305. 'id' => $id
  2306. )) . "'>" . $numsemaine . "</a></td>";
  2307. }
  2308. for ($j = 1; $j < 8; $j++) {
  2310. if (($compteurj >= $premierj) && ($compteurj <= ($moisnj + $premierj - 1))) {
  2311. $vclass = (($compteurj - $premierj + 1) . "/" . $mois . "/" . $annee == date("j/m/Y")) ? " class='Calendrier_LeJour'" : "";
  2312. $tab_html .= "<td " . $vclass . ">" . ($compteurj - $premierj + 1) . "</td>";
  2313. } else {
  2314. $tab_html .= "<td>&nbsp;</td>";
  2315. }
  2317. $compteurj++;
  2318. }
  2319. $tab_html .= "</tr>";
  2320. }
  2321. $tab_html .= "</table>";
  2323. $tab_html .= "</td>";
  2324. $tab_html .= "</tr>";
  2326. $tab_html .= "</table>";
  2328. //return response
  2329. $response = new \Symfony\Component\HttpFoundation\Response;
  2330. $response->setContent($tab_html);
  2332. return $response;
  2333. }
  2335. /**
  2336. * @Route("/planning/{annee}/{mois}/{semaine}", name="malys_user_planning", defaults={"semaine"=0})
  2337. */
  2338. public function planningAction($annee, $mois, $semaine, EntityManagerInterface $em)
  2339. {
  2340. if ($semaine == 0) {
  2341. $semaine = date('W', mktime(0, 0, 0, $mois, 1, $annee));
  2342. }
  2344. $tab_mois_fr = $this->malysDates->getTabMoisFr();
  2345. $tab_jours_fr = $this->malysDates->getTabJoursFr();
  2347. //AFFICHAGE DES RDV DE LA SEMAINE
  2348. $rdv = $em->getRepository(Adminevent::class)->findMyRdvHebdo($this->getUser()->getId(), $annee, $semaine);
  2350. return $this->render('User/planning.html.twig', array(
  2351. 'tab_mois_fr' => $tab_mois_fr,
  2352. 'tab_jours_fr' => $tab_jours_fr,
  2353. 'Rdv' => $rdv,
  2354. 'annee' => $annee,
  2355. 'mois' => $mois,
  2356. 'semaine' => $semaine,
  2357. ));
  2358. }
  2360. /**
  2361. * @Route("/messages", name="malys_user_messages")
  2362. */
  2363. public function messagesAction(EntityManagerInterface $em)
  2364. {
  2366. //RECUPERATION DE TOUS MES MESSAGES
  2367. $mes = $em->getRepository(Messages::class)->findMyMessages($this->getUser()->getId());
  2369. return $this->render('User/messages.html.twig', array('Messages' => $mes));
  2370. }
  2372. /**
  2373. * @Route("/message_lu/{id}", name="malys_user_readmessage")
  2374. */
  2375. public function readMessageAction($id, EntityManagerInterface $em)
  2376. {
  2377. $message = $em->getRepository(Messages::class)->find($id);
  2378. $message->setLu(1);
  2379. $message->setDatelufr(new \DateTime('now'));
  2380. $em->flush();
  2382. return $this->redirect($this->generateUrl('malys_user_messages'));
  2383. }
  2385. /**
  2386. * @Route("/rapport/{id}", name="malys_user_rapport", defaults={"id"=0})
  2387. */
  2388. public function rapportAction($id)
  2389. {
  2390. ($id == 0) ? ($id = '') : ($id);
  2392. return $this->render('User/rapport.html.twig', array('id' => $id));
  2393. }
  2395. }