src/Controller/VehicleStatisticController.php line 121

  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\VehicleStatistic;
  6. use App\Repository\DealerRepository;
  7. use App\Repository\VehicleRepository;
  8. use App\Repository\VehicleStatisticRepository;
  9. use App\Repository\VehicleFormRepository;
  10. use App\Service\VehicleStatisticService;
  11. use DateTime;
  12. use Knp\Component\Pager\PaginatorInterface;
  13. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Security;
  14. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  15. use Symfony\Component\HttpFoundation\JsonResponse;
  16. use Symfony\Component\HttpFoundation\Request;
  17. use Symfony\Component\HttpFoundation\Response;
  18. use Symfony\Component\Routing\Annotation\Route;
  20. #[Route('/vehicle-statistics')]
  21. class VehicleStatisticController extends AbstractController
  22. {
  23.     #[Security('is_granted("ROLE_ADMIN")')]
  24.     #[Route('/', name: 'app_vehicle_statistics_index', methods: ['GET'])]
  25.     public function index(
  26.         Request $request, 
  27.         DealerRepository $dealerRepository,
  28.         VehicleStatisticRepository $vehicleStatisticRepository,
  29.         VehicleFormRepository $vehicleFormRepository,
  30.         VehicleRepository $vehicleRepository
  31.     ): Response {
  32.         $dealerId = $request->query->get('dealer');
  33.         $monthFrom = $request->query->get('month_from');
  34.         $monthTo = $request->query->get('month_to');
  35.         
  36.         $dealers = $dealerRepository->findBy(['visible' => true], ['name' => 'ASC']);
  37.         $selectedDealer = null;
  38.         $statistics = [];
  39.         $totalStats = [];
  40.         $vehicleInquiries = [];
  41.         $dealerVehicles = [];
  42.         $allDealersStats = [];
  44.         $yearFrom = null;
  45.         $monthFromInt = null;
  46.         if ($monthFrom) {
  47.             [$yearFrom, $monthFromInt] = explode('-', $monthFrom);
  48.             $yearFrom = (int) $yearFrom;
  49.             $monthFromInt = (int) $monthFromInt;
  50.         }
  51.         
  52.         $yearTo = null;
  53.         $monthToInt = null;
  54.         if ($monthTo) {
  55.             [$yearTo, $monthToInt] = explode('-', $monthTo);
  56.             $yearTo = (int) $yearTo;
  57.             $monthToInt = (int) $monthToInt;
  58.         }
  59.         
  60.         if ($dealerId) {
  61.             $selectedDealer = $dealerRepository->find($dealerId);
  62.             
  63.             if ($selectedDealer) {
  64.                 $statistics = $vehicleStatisticRepository->getStatisticsByDealer(
  65.                     $selectedDealer, 
  66.                     $yearFrom, 
  67.                     $monthFromInt, 
  68.                     $yearTo, 
  69.                     $monthToInt
  70.                 );
  71.                 
  72.                 $totalStats = $vehicleStatisticRepository->getTotalStatisticsByDealer(
  73.                     $selectedDealer, 
  74.                     $yearFrom, 
  75.                     $monthFromInt, 
  76.                     $yearTo, 
  77.                     $monthToInt
  78.                 );
  80.                 $dateFromObj = $monthFrom ? new DateTime($monthFrom . '-01 00:00:00') : null;
  81.                 $dateToObj = $monthTo ? new DateTime($monthTo . '-' . date('t', strtotime($monthTo . '-01')) . ' 23:59:59') : null;
  82.                 
  83.                 $vehicleInquiries = $vehicleFormRepository->getInquiriesByDealer(
  84.                     $selectedDealer, 
  85.                     $dateFromObj, 
  86.                     $dateToObj
  87.                 );
  89.                 $dealerVehicles = $vehicleRepository->findVisibleInPeriod(
  90.                     $selectedDealer,
  91.                     $dateFromObj,
  92.                     $dateToObj
  93.                 );
  94.             }
  95.         } else {
  96.             $allDealersStats = $vehicleStatisticRepository->getAllDealersStatistics(
  97.                 $yearFrom, 
  98.                 $monthFromInt, 
  99.                 $yearTo, 
  100.                 $monthToInt
  101.             );
  102.         }
  103.         
  104.         return $this->render('vehicle_statistics/index.html.twig', [
  105.             'dealers' => $dealers,
  106.             'selectedDealer' => $selectedDealer,
  107.             'statistics' => $statistics,
  108.             'totalStats' => $totalStats,
  109.             'vehicleInquiries' => $vehicleInquiries,
  110.             'dealerVehicles' => $dealerVehicles,
  111.             'allDealersStats' => $allDealersStats,
  112.             'filters' => [
  113.                 'dealer' => $dealerId,
  114.                 'month_from' => $monthFrom,
  115.                 'month_to' => $monthTo,
  116.             ]
  117.         ]);
  118.     }
  120.     #[Route('/track', name: 'app_vehicle_statistics_track', methods: ['POST'])]
  121.     public function track(
  122.         Request $request, 
  123.         VehicleRepository $vehicleRepository,
  124.         VehicleStatisticService $vehicleStatisticService
  125.     ): JsonResponse {
  126.         $vehicleId = $request->request->get('vehicle_id');
  127.         $action = $request->request->get('action');
  128.         
  129.         if (!$vehicleId || !$action) {
  130.             return new JsonResponse(['success' => false, 'error' => 'Missing parameters'], 400);
  131.         }
  132.         
  133.         $vehicle = $vehicleRepository->find($vehicleId);
  134.         if (!$vehicle) {
  135.             return new JsonResponse(['success' => false, 'error' => 'Vehicle not found'], 404);
  136.         }
  138.         $allowedActions = ['view', 'call_dealer', 'phone_click', 'message_dealer'];
  139.         if (!in_array($action, $allowedActions)) {
  140.             return new JsonResponse(['success' => false, 'error' => 'Invalid action'], 400);
  141.         }
  142.         
  143.         $tracked = $vehicleStatisticService->trackAction($vehicle, $action);
  144.         
  145.         return new JsonResponse([
  146.             'success' => true, 
  147.             'tracked' => $tracked,
  148.             'message' => $tracked ? 'Action tracked' : 'Action already tracked today'
  149.         ]);
  150.     }
  151. }