src/AdminBundle/Controller/DashboardController.php line 39

Open in your IDE?
  1. <?php
  4. namespace AdminBundle\Controller;
  6. use DateTime;
  7. use Symfony\Bundle\FrameworkBundle\Console\Application;
  8. use Symfony\Component\Console\Input\ArrayInput;
  9. use Symfony\Component\Console\Output\BufferedOutput;
  10. use CoreBundle\Component\FormManager;
  11. use CoreBundle\Entity\Forms;
  12. use CoreBundle\Entity\Ticket;
  13. use CoreBundle\Entity\User;
  14. use CoreBundle\Entity\Dealer;
  15. use CoreBundle\Entity\VehicleEstimate;
  16. use DcSiteBundle\Entity\OnlineServiceBooking;
  17. use Symfony\Bundle\FrameworkBundle\Controller\Controller;
  18. use Symfony\Component\HttpFoundation\JsonResponse;
  19. use Symfony\Component\HttpFoundation\Request;
  21. class DashboardController extends \Symfony\Bundle\FrameworkBundle\Controller\AbstractController
  22. {
  23.     public function init(Request $request)
  24.     {
  25.         /** @var User $User */
  26.         $User = $this->getUser();
  27.         $Dealer = $User->getDealer();
  28.         $leadsResult = null;
  29.         $ticketsResult = null;
  30.         $leadsByUtm = [];
  32.         $date = new DateTime();
  34.         if ($request->get('isPrev')) {
  35.             $date = $date->modify('-1 month');
  36.         }
  38.         if ($Dealer) {
  39.             $monthLeads = $this->getDoctrine()->getRepository(Forms::class)->getMonthForms($Dealer, $date);
  40.             $monthCount = count($monthLeads);
  41.             $monthInCrmCount = 0;
  42.             $todayCount = 0;
  43.             $todayInCrmCount = 0;
  44.             $leads = [];
  45.             $leadsByType = [];
  46.             /** @var Forms $lead */
  47.             foreach ($monthLeads as $lead) {
  48.                 $type = $lead->getType();
  49.                 if ($lead->getUtm()) {
  50.                     $decodedUtm = json_decode($lead->getUtm());
  51.                     if (!isset($leadsByUtm[$decodedUtm->utm_source])) {
  52.                         $leadsByUtm[$decodedUtm->utm_source] = [];
  53.                     }
  54.                     if (!isset($leadsByUtm[$decodedUtm->utm_source][$decodedUtm->utm_medium])) {
  55.                         $leadsByUtm[$decodedUtm->utm_source][$decodedUtm->utm_medium] = [];
  56.                     }
  58.                     $name = $decodedUtm->utm_campaign . ' / ' . $decodedUtm->utm_content;
  59.                     $hash = md5($name);
  60.                     if (!isset($leadsByUtm[$decodedUtm->utm_source][$decodedUtm->utm_medium][$hash])) {
  61.                         $leadsByUtm[$decodedUtm->utm_source][$decodedUtm->utm_medium][$hash] = [
  62.                             'count' => 1,
  63.                             'name' => $name,
  64.                         ];
  65.                     } else {
  66.                         $leadsByUtm[$decodedUtm->utm_source][$decodedUtm->utm_medium][$hash]['count']++;
  67.                     }
  68.                 }
  69.                 if (!isset($leadsByType[$type])) {
  70.                     $leadsByType[$type] = [
  71.                         'type' => $type,
  72.                         'title' => FormManager::getTypeName($type),
  73.                         'count' => 0,
  74.                     ];
  75.                 }
  76.                 $leadsByType[$type]['count']++;
  77.             }
  78.             for ($i = 1; $i <= date('t'); $i++) {
  79.                 $leads[$i] = [
  80.                     'total' => 0,
  81.                     'inCrm' => 0,
  82.                 ];
  83.                 /** @var Forms $lead */
  84.                 foreach ($monthLeads as $lead) {
  85.                     $day = $lead->getDateCreate()->format('d');
  86.                     if ((int)$day != $i) {
  87.                         continue;
  88.                     }
  89.                     $leads[$i]['total']++;
  90.                     if ($lead->getInCrm() && $lead->getCrmLeadId()) {
  91.                         $monthInCrmCount++;
  92.                         $leads[$i]['inCrm']++;
  93.                         if ($day == date('t')) {
  94.                             $todayInCrmCount++;
  95.                         }
  96.                     }
  97.                     if ($day == date('t')) {
  98.                         $todayCount++;
  99.                     }
  100.                 }
  102.             }
  104.             $oEst = $this->getDoctrine()->getRepository(VehicleEstimate::class)->getMonth($Dealer, $date);
  105.             /** @var VehicleEstimate $lead */
  106.             foreach ($oEst as $lead) {
  107.                 if ($lead->getForm()) {
  108.                     continue;
  109.                 }
  110.                 if ($lead->getUtm()) {
  111.                     $decodedUtm = json_decode($lead->getUtm());
  112.                     if (!isset($leadsByUtm[$decodedUtm->utm_source])) {
  113.                         $leadsByUtm[$decodedUtm->utm_source] = [];
  114.                     }
  115.                     if (!isset($leadsByUtm[$decodedUtm->utm_source][$decodedUtm->utm_medium])) {
  116.                         $leadsByUtm[$decodedUtm->utm_source][$decodedUtm->utm_medium] = [];
  117.                     }
  119.                     $name = $decodedUtm->utm_campaign . ' / ' . $decodedUtm->utm_content;
  120.                     $hash = md5($name);
  121.                     if (!isset($leadsByUtm[$decodedUtm->utm_source][$decodedUtm->utm_medium][$hash])) {
  122.                         $leadsByUtm[$decodedUtm->utm_source][$decodedUtm->utm_medium][$hash] = [
  123.                             'count' => 1,
  124.                             'name' => $name,
  125.                         ];
  126.                     } else {
  127.                         $leadsByUtm[$decodedUtm->utm_source][$decodedUtm->utm_medium][$hash]['count']++;
  128.                     }
  129.                 }
  130.             }
  133.             $oBooking =
  134.                 $this->getDoctrine()->getRepository(OnlineServiceBooking::class)->getMonth($Dealer, $date);
  135.             /** @var OnlineServiceBooking $lead */
  136.             foreach ($oBooking as $lead) {
  137.                 if (!$lead->getUtm()) {
  138.                     continue;
  139.                 }
  140.                 $decodedUtm = json_decode($lead->getUtm());
  141.                 if (!isset($leadsByUtm[$decodedUtm->utm_source])) {
  142.                     $leadsByUtm[$decodedUtm->utm_source] = [];
  143.                 }
  144.                 if (!isset($leadsByUtm[$decodedUtm->utm_source][$decodedUtm->utm_medium])) {
  145.                     $leadsByUtm[$decodedUtm->utm_source][$decodedUtm->utm_medium] = [];
  146.                 }
  148.                 $name = $decodedUtm->utm_campaign . ' / ' . $decodedUtm->utm_content;
  149.                 $hash = md5($name);
  150.                 if (!isset($leadsByUtm[$decodedUtm->utm_source][$decodedUtm->utm_medium][$hash])) {
  151.                     $leadsByUtm[$decodedUtm->utm_source][$decodedUtm->utm_medium][$hash] = [
  152.                         'count' => 1,
  153.                         'name' => $name,
  154.                     ];
  155.                 } else {
  156.                     $leadsByUtm[$decodedUtm->utm_source][$decodedUtm->utm_medium][$hash]['count']++;
  157.                 }
  158.             }
  161.             $leadsResult = [
  162.                 'count' => $monthCount,
  163.                 'countInCrm' => $monthInCrmCount,
  164.                 'today' => $todayCount,
  165.                 'todayInCrm' => $todayInCrmCount,
  166.                 'byDays' => $leads,
  167.                 'byTypes' => $leadsByType,
  168.             ];
  170. //TODO remove magic numbers rename to normal
  171.             $Tickets = $this->getDoctrine()->getRepository(Ticket::class)->getByState([], [3, 8], $Dealer);
  172.             $ticketsResult = [
  173.                 'total' => count($Tickets),
  174.                 'inProgress' => 0,
  175.                 'wait' => 0,
  176.                 'done' => 0,
  177.             ];
  178.             /** @var Ticket $ticket */
  179.             foreach ($Tickets as $ticket) {
  180.                 $state = $ticket->getState();
  181.                 switch ($state) {
  182.                     case \CoreBundle\Model\Ticket::STATE_DOING:
  183.                     case \CoreBundle\Model\Ticket::STATE_STOP:
  184.                         $ticketsResult['inProgress']++;
  185.                         break;
  186.                     case \CoreBundle\Model\Ticket::STATE_WAIT:
  187.                         $ticketsResult['wait']++;
  188.                         break;
  189.                     case \CoreBundle\Model\Ticket::STATE_DONE:
  190.                         $ticketsResult['done']++;
  191.                         break;
  192.                 }
  193.             }
  194.         }
  196.         return new JsonResponse([
  197.             'leads' => $leadsResult,
  198.             'leadsByUtm' => $leadsByUtm,
  199.             'tickets' => $ticketsResult,
  200.         ]);
  201.     }
  203.     public function statistic(Request $request)
  204.     {
  205.         $result = [];
  206.         $em = $this->container->get('doctrine.orm.entity_manager');
  207.         $forms = $em->getRepository(Forms::class);
  208.         $dealers = $em->getRepository(Dealer::class)->findAll();
  209.         $types = [];
  210.         foreach (FormManager::getFormTypeName(null, true) as $key => $type) {
  211.             $types[] = [
  212.                 'id' => $key,
  213.                 'name' => $type,
  214.             ];
  215.         }
  216.         if ($request->isXmlHttpRequest()) {
  217.             $date_start = $request->get('date_start');
  218.             $date_end = $request->get('date_end');
  219.             $dealer = $request->get('dealer');
  220.             $type = $request->get('type');
  221.             $formResult = $forms->createQueryBuilder('f')
  222.                 ->select('COUNT(f.type) as counted, f.type as type')
  223.                 ->where('f.date_create BETWEEN :dateStart AND :dateEnd')
  224.                 ->setParameter('dateStart', date($date_start))
  225.                 ->setParameter('dateEnd', date($date_end));
  226.             if ($dealer !== 'vidi') {
  227.                 $formResult
  228.                     ->andWhere('f.dealer = :dealer')->setParameter('dealer', $dealer);
  229.             } else {
  230.                 $formResult->andWhere('f.domain = :domain')->setParameter('domain', 'vidi.ua');
  231.             }
  232.             if ($type !== 'all') {
  233.                 $formResult
  234.                     ->andWhere('f.type = :type')->setParameter('type', $type);
  235.             }
  236.             $formResult
  237.                 ->groupBy('f.type');
  238.             foreach ($formResult->getQuery()->getResult() as $item) {
  239.                 $result[] = [
  240.                     'form' => FormManager::getFormTypeName($item['type'], true),
  241.                     'count' => $item['counted'],
  242.                 ];
  243.             }
  244.             return new JsonResponse($result);
  245.         }
  246.         return $this->render(
  247.             '@Admin/admin/statistic.html.twig',
  248.             ['dealers' => $dealers, 'result' => $result, 'types' => $types]
  249.         );
  250.     }
  252.     public function changePassword(Request $request)
  253.     {
  254.         $result = [];
  255.         $em = $this->container->get('doctrine.orm.entity_manager');
  256.         $forms = $em->getRepository(Forms::class);
  257.         $dealers = $em->getRepository(Dealer::class)->findAll();
  258.         $types = [];
  259.         foreach (FormManager::getFormTypeName(null, true) as $key => $type) {
  260.             $types[] = [
  261.                 'id' => $key,
  262.                 'name' => $type,
  263.             ];
  264.         }
  265.         if ($request->isXmlHttpRequest()) {
  266.             $date_start = $request->get('date_start');
  267.             $date_end = $request->get('date_end');
  268.             $dealer = $request->get('dealer');
  269.             $type = $request->get('type');
  270.             $formResult = $forms->createQueryBuilder('f')
  271.                 ->select('COUNT(f.type) as counted, f.type as type')
  272.                 ->where('f.date_create BETWEEN :dateStart AND :dateEnd')
  273.                 ->setParameter('dateStart', date($date_start))
  274.                 ->setParameter('dateEnd', date($date_end));
  275.             if ($dealer !== 'vidi') {
  276.                 $formResult
  277.                     ->andWhere('f.dealer = :dealer')->setParameter('dealer', $dealer);
  278.             } else {
  279.                 $formResult->andWhere('f.domain = :domain')->setParameter('domain', 'vidi.ua');
  280.             }
  281.             if ($type !== 'all') {
  282.                 $formResult
  283.                     ->andWhere('f.type = :type')->setParameter('type', $type);
  284.             }
  285.             $formResult
  286.                 ->groupBy('f.type');
  287.             foreach ($formResult->getQuery()->getResult() as $item) {
  288.                 $result[] = [
  289.                     'form' => FormManager::getFormTypeName($item['type'], true),
  290.                     'count' => $item['counted'],
  291.                 ];
  292.             }
  293.             return new JsonResponse($result);
  294.         }
  295.         return $this->render(
  296.             '@Admin/admin/change-password.html.twig',
  297.             ['dealers' => $dealers, 'result' => $result, 'types' => $types]
  298.         );
  299.     }
  301.     public function savePassword(Request $request){
  303.         /**
  304.          * @var User $user
  305.          */
  306.         $user = $this->getUser();
  307.         $em = $this->container->get('doctrine.orm.entity_manager');
  308.         $newPassword = $request->get('newPassword');
  310.         $password = password_hash($newPassword, PASSWORD_BCRYPT, ['cost' => 13]);
  311.         $user->setEnabled(true);
  312.         $user->setPassword($password);
  313.         $em->persist($user);
  314.         $em->flush();
  315.         return new JsonResponse(['successMessage' => 'Ви успішно змінили пароль!']);
  316.     }
  318.     public function runMigration()
  319.     {
  320.         if (!defined('STDIN')) {
  321.             define('STDIN', fopen('php://stdin', 'r'));
  322.         }
  323.         if (!defined('STDOUT')) {
  324.             define('STDOUT', fopen('php://stdout', 'w'));
  325.         }
  326.         if (!defined('STDERR')) {
  327.             define('STDERR', fopen('php://stderr', 'w'));
  328.         }
  330.         $this->denyAccessUnlessGranted('ROLE_SUPER_ADMIN');
  332.         $application = new Application($this->get('kernel'));
  333.         $application->setAutoExit(false);
  335.         $input = new ArrayInput([
  336.             'command' => 'doctrine:migrations:migrate',
  337.             '--no-interaction' => true,
  338.         ]);
  340.         $output = new BufferedOutput();
  342.         $application->run($input, $output);
  344.         $result = $output->fetch();
  346.         $this->addFlash('sonata_flash_success', 'Команда успешно выполнена. Вывод: ' . $result);
  348.         return $this->redirect($this->generateUrl('sonata_admin_dashboard'));
  349.     }
  351. }