src/Controller/TimetableController.php line 62

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace App\Controller;
  7. use App\Entity\Roles;
  8. use App\Entity\Timetable;
  9. use App\Entity\User;
  10. use App\Services\ClubService;
  11. use App\Services\SessionService;
  12. use App\Services\TimetableService;
  13. use App\Services\UserService;
  14. use App\ValueObjects\Timetable\TimetableFilter;
  15. use DateTimeImmutable;
  16. use DateTime;
  17. use Exception;
  18. use Sensio\Bundle\FrameworkExtraBundle\Configuration\IsGranted;
  19. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  20. use Symfony\Component\HttpFoundation\JsonResponse;
  21. use Symfony\Component\HttpFoundation\Request;
  22. use Symfony\Component\HttpFoundation\Response;
  23. use Symfony\Component\Routing\Annotation\Route;
  24. use Symfony\Contracts\Translation\TranslatorInterface;
  25. use Throwable;
  26. use Webmozart\Assert\Assert;
  27. use Doctrine\ORM\EntityManagerInterface;
  29. /**
  30.  * Class TimetableController
  31.  * @package App\Controller
  32.  * @IsGranted ("ROLE_USER")
  33.  */
  34. class TimetableController extends AbstractController
  35. {
  36.     /** @var UserService */
  37.     private UserService $userService;
  38.     /** @var TranslatorInterface */
  39.     private TranslatorInterface $translator;
  40.     /** @var TimetableService */
  41.     private TimetableService $timetableService;
  42.     /** @var SessionService */
  43.     private SessionService $sessionService;
  44.     /** @var ClubService */
  45.     private ClubService $clubService;
  46.     private string $projectName;
  48.     public function __construct(UserService $userService, TimetableService $timetableService, TranslatorInterface $translator, SessionService $sessionService, ClubService $clubService, string $projectName, EntityManagerInterface $entityManager)
  49.     {
  50.         $this->userService = $userService;
  51.         $this->translator = $translator;
  52.         $this->timetableService = $timetableService;
  53.         $this->sessionService = $sessionService;
  54.         $this->clubService = $clubService;
  55.         $this->projectName = $projectName;
  56.         $this->entityManager = $entityManager;
  57.     }
  59.     /**
  60.      * @Route(name="app_timetable_check_online", path="/users/healthcheck/online/check", methods={"GET"})
  61.      */
  62.     public function checkOnline(): JsonResponse
  63.     {
  64.         try {
  65.             /** @var User $user */
  66.             $user = $this->getUser();
  67.             Assert::notEmpty($user, $this->translator->trans('User not found'));
  68.             if (is_null($user->getLastActionTime())) {
  69.                 $this->sessionService->invalidateAllUsersSessions($user);
  70.                 throw new Exception($this->translator->trans("Session expired. Please, login again"));
  71.             }
  72.             if($user->isTimetableEnabled()){
  73.                 /** @var Timetable $lastTimetableRecord */
  74.                 $lastTimetableRecord = $user->getTimetables()->last();
  75.                 $currentTime = (new DateTime())->format("H:i");
  76.                 if($currentTime > $user->getFinishWorkingTime()){
  77.                     throw new Exception($this->translator->trans("User don't use cashdesk now"));
  78.                 }
  79.                 $day_start = $lastTimetableRecord->getStartDatetime()->format('d');
  80.                 $day_diff = 0;
  81.                 if(!is_null($user->getLastActionTime())){
  82.                     $day_last_action = $user->getLastActionTime()->format('d');
  83.                     $day_diff = $day_last_action - $day_start;
  84.                 }
  85.                 $current_day = date("d", time());
  86.                 $day_finish = $lastTimetableRecord->getStartDatetime()->format('Y-m-d') .' '. $user->getFinishWorkingTime() . ':00';
  87.                 if($day_diff > 0 || ($current_day - $day_start) > 0){
  88.                     $date_finish = (new DateTimeImmutable())->setTimestamp(strtotime($day_finish));
  89.                     $this->userService->clearLastActionTime($user);
  90.                     $this->timetableService->finish($user, $date_finish);
  91.                     $this->sessionService->invalidateAllUsersSessions($user);
  92.                     throw new Exception($this->translator->trans("Session expired. Please, login again"));
  93.                 }
  94.             }
  95.             if ($this->timetableService->isUserLogoutRequired($user) || !$user->isWorkingTimeNow()) {
  96.                 $this->userService->releaseCurrentCashdesk($user);
  97.                 $this->userService->clearLastActionTime($user);
  98.                 $this->timetableService->finish($user);
  99.                 $this->sessionService->invalidateAllUsersSessions($user);
  100.                 throw new Exception($this->translator->trans("Session expired. Please, login again"));
  101.             }
  102.             if ($this->timetableService->isUserActionRequired($user)) {
  103.                 $response = [
  104.                     'success' => true,
  105.                     'actionRequired' => true,
  106.                     'soundRequired' => true,
  107.                 ];
  108.                 return new JsonResponse($response);
  109.             }
  110.             return new JsonResponse(
  111.                 [
  112.                     'success' => true,
  113.                 ]
  114.             );
  115.         } catch (Throwable $t) {
  116.             return new JsonResponse([
  117.                 'success' => false,
  118.                 'message' => $t->getMessage()
  119.             ]);
  120.         }
  121.     }
  124.     /**
  125.      * @Route(name="app_timetable_confirm_online", path="/users/healthcheck/online/confirm", methods={"POST"})
  126.      */
  127.     public function confirmOnline(): JsonResponse
  128.     {
  129.         try {
  130.             /** @var User $user */
  131.             $user = $this->getUser();
  132.             Assert::notEmpty($user, $this->translator->trans('User not found'));
  133.             if (is_null($user->getLastActionTime())) {
  134.                 $this->sessionService->invalidateAllUsersSessions($user);
  135.                 throw new Exception($this->translator->trans("Session expired. Please, login again"));
  136.             }
  137.             if($user->isTimetableEnabled()){
  138.                 /** @var Timetable $lastTimetableRecord */
  139.                 $lastTimetableRecord = $user->getTimetables()->last();
  140.                 $currentTime = (new DateTime())->format("H:i");
  141.                 if($currentTime > $user->getFinishWorkingTime()){
  142.                     throw new Exception($this->translator->trans("User don't use cashdesk now"));
  143.                 }
  144.                 $day_start = $lastTimetableRecord->getStartDatetime()->format('d');
  145.                 $day_diff = 0;
  146.                 if(!is_null($user->getLastActionTime())){
  147.                     $day_last_action = $user->getLastActionTime()->format('d');
  148.                     $day_diff = $day_last_action - $day_start;
  149.                 }
  150.                 $current_day = date("d", time());
  151.                 $day_finish = $lastTimetableRecord->getStartDatetime()->format('Y-m-d') .' '. $user->getFinishWorkingTime() . ':00';
  152.                 if($day_diff > 0 || ($current_day - $day_start) > 0){
  153.                     $date_finish = (new DateTimeImmutable())->setTimestamp(strtotime($day_finish));
  154.                     $this->userService->clearLastActionTime($user);
  155.                     $this->timetableService->finish($user, $date_finish);
  156.                     $this->sessionService->invalidateAllUsersSessions($user);
  157.                     throw new Exception($this->translator->trans("Session expired. Please, login again"));
  158.                 }
  159.             }
  160.             if ($this->timetableService->isUserLogoutRequired($user)) {
  161.                 $this->userService->releaseCurrentCashdesk($user);
  162.                 $this->userService->clearLastActionTime($user);
  163.                 $this->timetableService->finish($user);
  164.                 $this->sessionService->invalidateAllUsersSessions($user);
  165.                 throw new Exception($this->translator->trans("Session expired. Please, login again"));
  166.             }
  167.             $this->userService->updateLastActionTime($user);
  168.             return new JsonResponse(
  169.                 [
  170.                     'success' => true,
  171.                 ]
  172.             );
  173.         } catch (Throwable $t) {
  174.             return new JsonResponse([
  175.                 'success' => false,
  176.                 'message' => $t->getMessage()
  177.             ]);
  178.         }
  179.     }
  181.     /**
  182.      * @Route(name="app_timetable_personal_report", path="/report/timetables/personal")
  183.      * @IsGranted("ROLE_CABINET_TIMETABLE_REPORTS")
  184.      * @param Request $request
  185.      * @return Response
  186.      */
  187.     public function personalReport(Request $request): Response
  188.     {
  189.         /** @var User $currentUser */
  190.         $currentUser = $this->getUser();
  192.         $yesterday = time() - 60 * 60 * 24 * 30;
  193.         $filterStartDate = $request->request->has("start_date") ? strtotime(filter_var($request->request->get("start_date"), FILTER_SANITIZE_STRING)) : mktime(0, 0, 0, intval(date('m', $yesterday)), intval(date('d', $yesterday)), intval(date('Y', $yesterday)));
  194.         $filterFinishDate = $request->request->has("finish_date") ? strtotime(filter_var($request->request->get("finish_date"), FILTER_SANITIZE_STRING)) : mktime(23, 59, 59, intval(date('m')), intval(date('d')), intval(date('Y')));
  195.         $filterUserId = $request->request->getInt('user_id');
  196.         $export = $request->request->get('export', false);
  198.         $filter = new TimetableFilter();
  199.         $filter
  200.             ->setAllowedUsersList($currentUser->getAllowedUsersId())
  201.             ->setStartDate($filterStartDate)
  202.             ->setFinishDate($filterFinishDate)
  203.             ->setMinimalDuration(10)
  204.             ->setUserId($filterUserId);
  206.         if (!empty($filterUserId)) {
  207.             Assert::inArray($filterUserId, $currentUser->getAllowedUsersId(), $this->translator->trans('Access denied'));
  208.         }
  210.         $personalReport = $this->timetableService->getPersonalReport($filter);
  211.         if ($this->isGranted(Roles::ROLE_EXPORT_TO_EXCEL) && "xls" === $export) {
  212.             $this->timetableService->personalExportToXls($personalReport);
  213.         }
  214.         return $this->render('timetables/personal_report/index.html.twig', [
  215.             'filter' => $filter,
  216.             'users' => $this->userService->getAllowedUsersList(),
  217.             'personalReport' => $personalReport,
  218.         ]);
  219.     }
  222.     /**
  223.      * @Route(name="app_timetable_full_report", path="/report/timetables/full")
  224.      * @IsGranted("ROLE_CABINET_TIMETABLE_REPORTS")
  225.      * @param Request $request
  226.      * @return Response
  227.      */
  228.     public function fullReport(Request $request): Response
  229.     {
  230.         /** @var User $currentUser */
  231.         $currentUser = $this->getUser();
  233.         $submit = $request->request->getInt('submit');
  234.         $filterYear = $request->request->getInt('year', intval(date('Y')));
  235.         $filterMonth = $request->request->getInt('month', intval(date('m')));
  236.         $export = $request->request->get('export', false);
  237.         $clubs = $request->request->get('clubs');
  239.         $fullReport = [];
  240.         $filter = new TimetableFilter();
  241.         if (!empty($submit) || !empty($export)) {
  242.             $monthStart = mktime(0, 0, 0, $filterMonth, 1, $filterYear);
  243.             $monthFinish = mktime(23, 59, 59, $filterMonth, intval(date('t', $monthStart)), $filterYear);
  244.             $filter
  245.                 ->setAllowedClubsList($currentUser->getAllowedClubsId())
  246.                 ->setClubsList($clubs)
  247.                 ->setAllowedUsersList($currentUser->getAllowedUsersId())
  248.                 ->setYear($filterYear)
  249.                 ->setMonth($filterMonth)
  250.                 ->setStartDate($monthStart)
  251.                 ->setFinishDate($monthFinish);
  252.             $fullReport = $this->timetableService->getFullReport($filter);
  253.             if ($this->isGranted(Roles::ROLE_EXPORT_TO_EXCEL) && "xls" === $export) {
  254.                 $this->timetableService->fullExportToXls($fullReport, $this->clubService);
  255.             }
  256.         }
  257.         return $this->render('timetables/full_report/index.html.twig', [
  258.             'filter' => $filter,
  259.             'users' => $this->userService->getAllowedUsersList(),
  260.             'clubs' => $this->clubService->getAllowedClubsList(),
  261.             'years' => [date('Y'), date('Y') - 1],
  262.             'fullReport' => $fullReport,
  263.         ]);
  264.     }
  266.     /**
  267.      * @Route(name="app_timetable_full_report_new", path="/report/timetables/full_new")
  268.      * @IsGranted("ROLE_CABINET_TIMETABLE_REPORTS")
  269.      * @param Request $request
  270.      * @return Response
  271.      */
  272.     public function fullReportNew(Request $request): Response
  273.     {
  274.         /** @var User $currentUser */
  275.         $currentUser = $this->getUser();
  277.         $submit = $request->request->getInt('submit');
  278.         $filterYear = $request->request->getInt('year', intval(date('Y')));
  279.         $filterMonth = $request->request->getInt('month', intval(date('m')));
  280.         $export = $request->request->get('export', false);
  281.         $clubs = $request->request->get('clubs');
  283.         $fullReport = [];
  284.         $filter = new TimetableFilter();
  285.         if (!empty($submit) || !empty($export)) {
  286.             $monthStart = mktime(0, 0, 0, $filterMonth, 1, $filterYear);
  287.             $monthFinish = mktime(23, 59, 59, $filterMonth, intval(date('t', $monthStart)), $filterYear);
  288.             $filter
  289.                 ->setAllowedClubsList($currentUser->getAllowedClubsId())
  290.                 ->setClubsList($clubs)
  291.                 ->setAllowedUsersList($currentUser->getAllowedUsersId())
  292.                 ->setYear($filterYear)
  293.                 ->setMonth($filterMonth)
  294.                 ->setStartDate($monthStart)
  295.                 ->setFinishDate($monthFinish);
  296.             $fullReport = $this->timetableService->getFullReportNew($filter);
  297.             if ($this->isGranted(Roles::ROLE_EXPORT_TO_EXCEL) && "xls" === $export) {
  298.                 $this->timetableService->fullNewExportToXls($fullReport, $this->clubService);
  299.             }
  300.         }
  301.         return $this->render('timetables/full_report_new/index.html.twig', [
  302.             'filter' => $filter,
  303.             'users' => $this->userService->getAllowedUsersList(),
  304.             'clubs' => $this->clubService->getAllowedClubsList(),
  305.             'years' => [date('Y'), date('Y') - 1],
  306.             'fullReport' => $fullReport,
  307.         ]);
  308.     }
  310.     /**
  311.      * @Route(name="app_timetable_full_report_hours_worked", path="/report/timetables/full_hours_worked")
  312.      * @IsGranted("ROLE_CABINET_TIMETABLE_REPORTS")
  313.      * @param Request $request
  314.      * @return Response
  315.      */
  316.     public function fullReportHoursWorked(Request $request): Response
  317.     {
  318.         /** @var User $currentUser */
  319.         $currentUser = $this->getUser();
  321.         $submit = $request->request->getInt('submit');
  322.         $filterYear = $request->request->getInt('year', intval(date('Y')));
  323.         $filterMonth = $request->request->getInt('month', intval(date('m')));
  324.         $export = $request->request->get('export', false);
  325.         $clubs = $request->request->get('clubs');
  327.         $fullReport = $cashier_payments = [];
  328.         $filter = new TimetableFilter();
  329.         if (!empty($submit) || !empty($export)) {
  330.             $monthStart = mktime(0, 0, 0, $filterMonth, 1, $filterYear);
  331.             $monthFinish = mktime(23, 59, 59, $filterMonth, intval(date('t', $monthStart)), $filterYear);
  332.             $filter
  333.                 ->setAllowedClubsList($currentUser->getAllowedClubsId())
  334.                 ->setClubsList($clubs)
  335.                 ->setAllowedUsersList($currentUser->getAllowedUsersId())
  336.                 ->setYear($filterYear)
  337.                 ->setMonth($filterMonth)
  338.                 ->setStartDate($monthStart)
  339.                 ->setFinishDate($monthFinish);
  340.             $fullReport = $this->timetableService->getFullReport($filter);
  341.             $cashier_payments = $this->timetableService->getCashierPayments($filter);
  342.             if ($this->isGranted(Roles::ROLE_EXPORT_TO_EXCEL) && "xls" === $export) {
  343.                 $this->timetableService->fullHoursWorkedExportToXls($fullReport, $cashier_payments, $this->clubService);
  344.             }
  345.         }
  346.         return $this->render('timetables/full_report/index_hours_worked.html.twig', [
  347.             'filter' => $filter,
  348.             'users' => $this->userService->getAllowedUsersList(),
  349.             'clubs' => $this->clubService->getAllowedClubsList(),
  350.             'years' => [date('Y'), date('Y') - 1],
  351.             'fullReport' => $fullReport,
  352.             'cashier_payments' => $cashier_payments,
  353.         ]);
  354.     }
  356.     /**
  357.      * @Route(name="app_timetable_last_active", path="/report/timetables/last_active")
  358.      * @IsGranted("ROLE_CABINET_TIMETABLE_REPORTS")
  359.      * @param Request $request
  360.      * @return Response
  361.      */
  362.     public function ReportWorkLastActive(Request $request): Response
  363.     {
  364.         /** @var User $currentUser */
  365.         $currentUser = $this->getUser();
  367.         $yesterday = time() - 60 * 60 * 24;
  368.         $filterStartDate = $request->request->has("start_date") ? strtotime(filter_var($request->request->get("start_date"), FILTER_SANITIZE_STRING)) : mktime(0, 0, 0, intval(date('m', $yesterday)), intval(date('d', $yesterday)), intval(date('Y', $yesterday)));
  369.         $filterFinishDate = $request->request->has("finish_date") ? strtotime(filter_var($request->request->get("finish_date"), FILTER_SANITIZE_STRING)) : mktime(23, 59, 59, intval(date('m')), intval(date('d')), intval(date('Y')));
  370.         $filterUserList = $request->request->get('users') ?? [];
  371.         $filterClubList = $request->request->get('clubs') ?? [];
  372.         $export = $request->request->get('export', false);
  374.         $filter = new TimetableFilter();
  375.         $filter
  376.             ->setAllowedUsersList($currentUser->getAllowedUsersId())
  377.             ->setAllowedClubsList($currentUser->getAllowedClubsId())
  378.             ->setStartDate($filterStartDate)
  379.             ->setFinishDate($filterFinishDate);
  381.         //        if($this->projectName != "ground_cashdesk_dom"){
  382. //            die;
  383. //        }
  385.         /*timetables*/
  386.         $timetables = $timetables_tmp = $payments = [];
  387.         if(sizeof($filterUserList) > 0 || sizeof($filterClubList) > 0) {
  388.             $sql = "SELECT
  389.                 `users`.`username` AS `username`, `clubs`.`title` AS `clubtitle`, `timetables`.*
  390.                 FROM `timetables`
  391.                 LEFT JOIN `users` ON `users`.id = `timetables`.`user_id`
  392.                 LEFT JOIN `clubs` ON `clubs`.id = `timetables`.`club_id`
  393.                 WHERE `start_datetime` >= '".date('Y-m-d H:i:s', $filterStartDate)."'
  394.                 AND `finish_datetime` <= '".date('Y-m-d H:i:s', $filterFinishDate)."'
  395.                 AND `duration` > 10";
  396.             if (sizeof($filterUserList) > 0) {
  397.                 $sql .= " AND user_id IN (" . implode(', ', $filterUserList) . ")";
  398.             }
  399.             if (sizeof($filterClubList) > 0) {
  400.                 $sql .= " AND club_id IN (" . implode(', ', $filterClubList) . ")";
  401.             }
  402.             $prepareStatement = $this->entityManager->getConnection()->prepare($sql);
  403.             $result = $prepareStatement->executeQuery();
  404.             if ($result->rowCount() > 0) {
  405.                 $row = $result->fetchAllAssociative();
  406.                 foreach ($row as $value) {
  407.                     $timetables_tmp[$value["user_id"]][date("Y-m-d", strtotime($value["start_datetime"]))][] = $value;
  408.                 }
  409.             }
  410.             foreach ($timetables_tmp as $user_id => $val) {
  411.                 foreach ($val as $day => $value) {
  412.                     foreach ($value as $item) {
  413.                         $timetables[$user_id][$day]["timetable"][$item["start_datetime"]] = [
  414.                             "start" => $item["start_datetime"],
  415.                             "finish" => $item["finish_datetime"],
  416.                             "sql" => " AND `opdate` BETWEEN '".$item["start_datetime"]."' AND '".$item["finish_datetime"]."'"
  417.                         ];
  418.                         $timetables[$user_id][$day]["username"] = $item["username"];
  419.                         $timetables[$user_id][$day]["clubtitle"] = $item["clubtitle"];
  420.                     }
  421.                 }
  422.             }
  423.             foreach ($timetables as $user_id => $val) {
  424.                 foreach ($val as $day => $value) {
  425.                     foreach ($value as $item) {
  426.                         foreach ($item as $rec) {
  427.                             $sql = "
  428.                                 SELECT * FROM `payments`
  429.                                 WHERE `operator_id` = " . $user_id . " 
  430.                                 ".$rec["sql"]." 
  431.                                 ORDER BY id DESC LIMIT 1
  432.                             ";
  433.                             $prepareStatement = $this->entityManager->getConnection()->prepare($sql);
  434.                             $result = $prepareStatement->executeQuery();
  435.                             if ($result->rowCount() > 0) {
  436.                                 $row = $result->fetchAssociative();
  437.                                 $payments[$user_id][$day][$rec["start"]] = [
  438.                                     "start" => $rec["start"],
  439.                                     "finish" => $rec["finish"],
  440.                                     "last" => $row["opdate"]
  441.                                 ];
  442.                             }
  443.                         }
  444.                     }
  445.                 }
  446.             }
  447.         }
  448.         /***********/
  449.         if ($this->isGranted(Roles::ROLE_EXPORT_TO_EXCEL) && "xls" === $export) {
  450.             $this->timetableService->lastActiveToXls($timetables, $payments);
  451.         }
  453.         return $this->render('timetables/last_active/index.html.twig', [
  454.             'filter' => $filter,
  455.             'users' => $this->userService->getAllowedUsersList(),
  456.             'clubs' => $this->clubService->getAllowedClubsList(),
  457.             'filterUserList' => $filterUserList,
  458.             'filterClubList' => $filterClubList,
  459.             'timetables' => $timetables,
  460.             'payments' => $payments,
  461.         ]);
  462.     }
  463. }