src/Controller/DefaultController.php line 41

  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\AccountTransactions;
  6. use App\Entity\Auctions;
  7. use App\Entity\AuctionVehicleBids;
  8. use App\Entity\AuctionVehicles;
  9. use App\Entity\ContentPages;
  10. use App\Entity\VehicleClients;
  11. use App\Entity\VehicleMakers;
  12. use App\Entity\VehicleModels;
  13. use App\Entity\Vehicles;
  14. use App\Service\VehicleHelper;
  15. use Doctrine\ORM\Query\Expr\Math;
  16. use DoctrineExtensions\Query\Mysql\Date;
  17. use Knp\Component\Pager\PaginatorInterface;
  18. use Symfony\Component\Routing\Annotation\Route;
  19. use Symfony\Bridge\Doctrine\Form\Type\EntityType;
  20. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  21. use Symfony\Component\Form\Extension\Core\Type\ChoiceType;
  22. use Symfony\Component\Form\Extension\Core\Type\TextType;
  23. use Symfony\Component\HttpFoundation\Request;
  24. use Symfony\Component\Security\Core\Authorization\AuthorizationCheckerInterface;
  25. use Symfony\Component\Security\Core\User\UserInterface;
  26. use Symfony\Contracts\Translation\TranslatorInterface;
  27. use Doctrine\Persistence\ManagerRegistry;
  29. /**
  30.  * Class DefaultController
  31.  * @package App\Controller
  32.  */
  33. class DefaultController extends AbstractController
  34. {
  35.     /**
  36.      *
  37.      * @return \Symfony\Component\HttpFoundation\Response
  38.      * @throws \Doctrine\ORM\NonUniqueResultException
  39.      */
  40.     #[Route('/', name: 'homepage', methods: ["GET"])]
  41.     public function indexAction(Request $request, PaginatorInterface $paginator, ManagerRegistry $doctrine)
  42.     {
  43.         $em     = $doctrine->getManager();
  44.         //the video to show with auction info
  45.         $video = $em->getRepository(ContentPages::class)->findOneBy(['keyword' => 'video']);
  46.         $locale = $request->getLocale();
  48.         $request->getSession();
  50.         $data = $this->getOngoingAuctionVehicles($request, $paginator, $doctrine);
  52.         // to set init before load page and jq
  53.         $countDown = [];
  54.         $checkNoMinus = true;
  55.         $auctionFinished = false;
  56.          if($data['endDate']){
  57.              // set default timezone
  58.              date_default_timezone_set('Asia/Riyadh'); // CDT
  59.              $datetime1 = new \DateTime();
  60.              $datetime2 = $data['endDate'];
  61.              $interval = $datetime1->diff($datetime2);
  62.              $days= $interval->format('%a');
  63.              $hours =$interval->format('%h') ;
  64.              $mins = $interval->format('%i');
  65.               if($datetime2 < $datetime1 ){
  66.                  $checkNoMinus = false;
  67.                  if($days <= 5){
  68.                      $auctionFinished = true;
  69.                  }
  71.              }else{
  72.                  $countDown['days'] = $days ;
  73.                  $countDown['hours'] = $hours ;
  74.                  $countDown['mins'] = $mins ;
  75.              }
  76.          }
  79.         // index.html.twig will be used if there is an ongoing auction. Otherwise: index-without-auction.html.twig
  81.         $auctionRepository = $em->getRepository(Auctions::class);
  82.         $auction = $auctionRepository->findOneBy(['status' => Auctions::AUCTION_STATUSES['in_progress']]);
  83.         if($auction){
  84.             $homepageTemplate = $this->getParameter('homepage_template_auction');
  85.         }else{
  86.             $homepageTemplate = $this->getParameter('homepage_template');
  87.         }
  88.         $auctionTermsContent = $em->getRepository(ContentPages::class)->findOneBy(['keyword' => 'auction_terms']);
  90.         // replace this example code with whatever you need
  91.         return $this->render($homepageTemplate, [
  92.             'searchForm'      => $data['searchForm']->createView(),
  93.             'auctionVehicles' => $data['auctionVehicles'],
  94.             'locale'          => $locale,
  95.             'imageRealPath'   => $data['imageRealPath'],
  96.             'totalResult'     => $data['totalResult'],
  97.             'loggedUser'      => $this->getUser(),
  98.             'endDate'         => $data['endDate'],
  99.             'auctionStatus'   => $data['auctionStatus'],
  100.             'countDown'       => $countDown,
  101.             'checkNoMinus'    => $checkNoMinus,
  102.             'auctionFinished' => $auctionFinished,
  103.             'auction' => $data['auction'],
  104.             'video' => $video,
  105.             'auctionTermsContent' => $auctionTermsContent
  106. /*            'homepage'        => $this->getParameter('homepage')*/
  107.         ]);
  108.     }
  110.     /**
  111.      *
  112.      * @return \Symfony\Component\HttpFoundation\Response
  113.      * @throws \Doctrine\ORM\NonUniqueResultException
  114.      */
  115.     #[Route('/auctionVehicles', name: 'auction_vehicles', methods: ["GET"])]
  116.     public function auctionVehicles(Request $request)
  117.     {
  118.         $data = $this->getOngoingAuctionVehicles($request, 'auctionVehicles');
  119.         return $this->render('default/auction_vehicles.html.twig', [
  120.             'searchForm'      => $data['searchForm']->createView(),
  121.             'auctionVehicles' => $data['auctionVehicles'],
  122.             'locale'          => $data['locale'],
  123.             'imageRealPath'   => $data['imageRealPath'],
  124.             'totalResult'     => $data['totalResult']
  125.         ]);
  126.     }
  128.     /**
  129.      * @param $vehicleId
  130.      *
  131.      * @return \Symfony\Component\HttpFoundation\Response
  132.      * @throws \Doctrine\DBAL\ConnectionException
  133.      * @throws \Doctrine\ORM\NonUniqueResultException
  134.      * @throws \Doctrine\ORM\ORMException
  135.      * @throws \Doctrine\ORM\OptimisticLockException
  136.      */
  137.     #[Route('/vehicleDetails/{vehicleId}', name: 'vehicle_details', methods: ["GET", "POST"])]
  138.     public function vehicleDetailsAction($vehicleId, Request $request, TranslatorInterface $translator, 
  139.             AuthorizationCheckerInterface $auth, ManagerRegistry $doctrine, UserInterface $user = null)
  140.     {
  141.         // if the user was not logged in and press the login url in this action page we redirect him to this action and send login parameter equal 1 with the url
  142.         $requireLogin = $request->get('login');
  143.         $loggedinUser = $auth->isGranted(['IS_AUTHENTICATED_FULLY', 'IS_AUTHENTICATED_REMEMBERED']);
  144.         if ($requireLogin && !$loggedinUser) {
  145.             throw $this->createAccessDeniedException();
  146.         } elseif ($requireLogin && $loggedinUser) { // after redirect the logged in user we remove the parameter login
  147.             $request->query->remove('login');
  148.             return $this->redirectToRoute('vehicle_details', array('vehicleId' => $vehicleId));
  149.         }
  151.         $em            = $doctrine->getManager();
  152.         $locale        = $request->getLocale();
  153.         $vehicle       = $em->getRepository(Vehicles::class)->find($vehicleId);
  154.         $imageRealPath = $this->getParameter('vehicle_uploaded_files') . '/';
  156.         if ($user instanceof \Symfony\Component\Security\Core\User\UserInterface) {
  157.             $auctionVehicle    = $em->getRepository(Auctions::class)->getAuctionVehicleAtOngoingAuction($vehicleId);
  158.             $auctionVehicleId  = $auctionVehicle->getAuctionVehicleId();
  159.             $auctionVehicleBid = $em->getRepository(AuctionVehicleBids::class)->findOneBy(['auctionVehicle' => $auctionVehicleId, 'bidder' => $user->getUserId()]);
  161.             if (!$auctionVehicleBid) {
  162.                 $auctionVehicleBid = new AuctionVehicleBids();
  163.             }
  164.         } else {
  165.             $auctionVehicleBid = new AuctionVehicleBids();
  166.         }
  168.         $bidForm = $this->createFormBuilder($auctionVehicleBid)
  169.             ->setMethod('POST')
  170.             ->add('bidValue', TextType::class, array(
  171.                 'required'           => false,
  172.                 'label'              => 'add your bid',
  173.                 'translation_domain' => 'vehicles',
  174.                 'data'               => $auctionVehicleBid->getBidValue()
  175.             ))
  176.             ->getForm();
  177.         $bidForm->handleRequest($request);
  179.         if ($bidForm->isSubmitted()) {
  180.             //a default success flash message
  181.             $session = $request->getSession();
  182.             $vehicleClient = $em->getRepository(VehicleClients::class)->find($user->getUserId());
  184.             //[1.1] suspend auto-commit until ensuring that balance funds covers all auction security locks
  185.             $em->getConnection()->beginTransaction();
  187.             //[1.2] insert\update\delete bids according user data entries
  188.             $transactionsRepo =  $doctrine->getManager()->getRepository(AccountTransactions::class);
  189.             //if a new bid and its value is entered then prepare it for saving
  190.             if (!$auctionVehicleBid->getBiddingId() && $auctionVehicleBid->getBidValue()) {
  191.                 $auctionVehicleBid->setBidder($vehicleClient);
  192.                 $auctionVehicle->addAuctionVehicleBid($auctionVehicleBid);
  193.                 $doctrine->getManager()->persist($auctionVehicleBid);
  194.                 $doctrine->getManager()->flush($auctionVehicleBid);
  195.                 $transactionsRepo->createAucSecTrans($auctionVehicleBid, $user, $user);
  196.             }
  197.             //if a new bid but no bid value entered then remove the bid object
  198.             elseif (!$auctionVehicleBid->getBiddingId() && !$auctionVehicleBid->getBidValue()) {
  199.                 $auctionVehicleBid->setAuctionVehicle(null);
  200.                 $auctionVehicle->removeAuctionVehicleBid($auctionVehicleBid);
  201.             }
  202.             //if an existing bid but no bid value entered then remove the bid from DB
  203.             elseif ($auctionVehicleBid->getBiddingId() && !$auctionVehicleBid->getBidValue()) {
  204.                 //unlock the auction security locking transaction and update user locked security amount
  205.                 $transactionsRepo->deleteBidTrans($auctionVehicleBid->getAuctionSecTransaction(), $this->getUser());
  206.                 $doctrine->getManager()->remove($auctionVehicleBid);
  207.                 $doctrine->getManager()->flush($auctionVehicleBid);
  208.             }
  209.             //if none of the above, then it is a existing bid value editing operation
  210.             else {
  211.                 $doctrine->getManager()->flush($auctionVehicleBid);
  212.             }
  214.             //[1.3] calculate unrestricted funds after applying user bids
  215.             $balance            = (float)$user->getBalance();
  216.             $lockedOtSec        = $user->getLockedOtSecurity();
  217.             $balanceAfterAction = $balance -$lockedOtSec;
  219.             //[1.4] decide whether rollback or commit changes
  220.             if ($balanceAfterAction > 0
  221.                 &&
  222.                 ($balance < 0 || $lockedOtSec < 0 ) ) {
  223.                 //[1.4.1] prevent either negative balance or negative security locks even if valid remaining funds. This odd case
  224.                 //might happen due to wrong balance or wrong security locks from the begining
  225.                 $session->getFlashBag()->add('warning',
  226.                     $translator->trans('error! balance cant be negative', array(), 'clients')
  227.                 );
  228.                 $em->getConnection()->rollBack();
  229.             } elseif ( $balanceAfterAction < 0 ) {
  230.                 //[1.4.2] the balance funds doesn't cover the requested action transactions
  231.                 $session->getFlashBag()->add('warning',
  232.                     $translator->trans('balance is less than the transaction with this amount', array('%{amount}'=> abs($balanceAfterAction) ), 'clients')
  233.                 );
  234.                 $em->getConnection()->rollBack();
  235.             } else {
  236.                 //[1.4.3] if no errors then commit changes to DB
  237.                 $session->getFlashBag()->add('success',
  238.                     $translator->trans('bids have been saved successfully', array(), 'clients')
  239.                 );
  240.                 $em->getConnection()->commit();
  241.             }
  242.         }
  244.         return $this->render('default/vehicle_details.html.twig', array(
  245.             'vehicle'       => $vehicle,
  246.             'locale'        => $locale,
  247.             'imageRealPath' => $imageRealPath,
  248.             'bidForm'       => $bidForm->createView()
  249.         ));
  250.     }
  252.     /**
  253.      * @return mixed
  254.      * @throws \Doctrine\ORM\NonUniqueResultException
  255.      */
  256.     private function getOngoingAuctionVehicles(Request $request, PaginatorInterface $paginator, ManagerRegistry $doctrine)
  257.     {
  258.         $em            = $doctrine->getManager();
  259.         $locale        = $request->getLocale();
  260.         $vehicleHelper = new VehicleHelper();
  262.         $searchForm = $this->createFormBuilder()
  263.             ->setMethod('GET')
  264.             ->add('maker', EntityType::class, array(
  265.                 'class'              => VehicleMakers::class,
  266.                 'label'              => 'Vehicle Maker',
  267.                 'choice_label'       => 'name' . ucfirst($locale),
  268.                 'placeholder'        => 'Please Select',
  269.                 'required'           => false,
  270.                 'translation_domain' => 'vehicles'
  271.             ))
  272.             ->add('model', EntityType::class, array(
  273.                 'required'           => false,
  274.                 'label'              => 'Vehicle Model',
  275.                 'class'              => VehicleModels::class,
  276.                 'choice_label'       => 'name' . ucfirst($locale),
  277.                 'placeholder'        => 'Please Select',
  278.                 'attr'               => array('disabled' => 'disabled'),
  279.                 'translation_domain' => 'vehicles'
  280.             ))
  281.             ->add('manufacturingYear', ChoiceType::class, array(
  282.                 'required'           => false,
  283.                 'label'              => 'Made Year',
  284.                 'choices'            => $vehicleHelper->getYears(1990),
  285.                 'placeholder'        => 'Please Select',
  286.                 'translation_domain' => 'vehicles'
  287.             ))
  288.             ->getForm();
  289.         $searchForm->handleRequest($request);
  291.         //$ongoingAuction  = $em->getRepository(Auctions::class)->getOngoingAuction();
  293.         $repository = $em->getRepository(Auctions::class);
  294.         //get the ongoing auction. If multiple auctions, only the last one will be returned
  295.         $qb         = $repository->createQueryBuilder('Auc')
  296.             ->orderBy('Auc.auctionId', 'DESC')
  297.             ->setMaxResults(1);
  298.         $ongoingAuction = $qb->getQuery()->getOneOrNullResult();
  300.         if ($ongoingAuction->getStatus() != Auctions::AUCTION_STATUSES['upcomming']) {
  301.             $auctionId = $ongoingAuction->getAuctionId();
  303.             $repository = $em->getRepository(Vehicles::class);
  304.             $qb = $repository->createQueryBuilder('V');
  305.             $qb->select('V', 'VR', 'AV.lineNumber');
  306.             $qb->join(AuctionVehicles::class, 'AV', 'with', 'V.vehicleId = AV.vehicle AND AV.auction = ' . $auctionId);
  307.             $qb->leftJoin('V.vehicleRegistrations', 'VR');
  309.             //if search fields submitted then filter result accordingly
  310.             if ($searchForm->isSubmitted()) {
  311.                 $qb->where('1=1'); //workaround! just initializing the where clause with an always-true condition to freely use andWhere() inside if-else statements regardless of which condition will be true
  313.                 if ($vehicleMaker = $searchForm->get('maker')->getData()) {
  314.                     if ($vehicleModel = $searchForm->get('model')->getData()) {
  315.                         $qb->andWhere('VR.model = :vehicleModel')
  316.                             ->setParameter('vehicleModel', $vehicleModel);
  317.                     } else {
  318.                         $modelsRepo = $doctrine
  319.                             ->getRepository(VehicleModels::class);
  321.                         $modelsQuery = $modelsRepo->createQueryBuilder('m')
  322.                             ->select('m.modelId')
  323.                             ->where('m.maker = :makerID')
  324.                             ->setParameter('makerID', $vehicleMaker)
  325.                             ->getQuery();
  327.                         $makerModels = $modelsQuery->getArrayResult();
  328.                         foreach ($makerModels as $maker) {
  329.                             $makerModelsArr[] = $maker['modelId'];
  330.                         }
  332.                         $qb->andWhere('VR.model IN (:makerModels)')
  333.                             ->setParameter('makerModels', $makerModelsArr);
  334.                     }
  335.                 }
  337.                 if ($manufacturingYear = $searchForm->get('manufacturingYear')->getData()) {
  338.                     $qb->andWhere('VR.manufacturingYear = :manufacturingYear')
  339.                         ->setParameter('manufacturingYear', $manufacturingYear);
  340.                 }
  341.             }
  343.             $qb->orderBy('AV.lineNumber', 'ASC');
  346.             $auctionVehicles   = $qb->getQuery()->getResult();
  347.             $totalResult       = count($auctionVehicles);
  349.             $auctionVehicles = $paginator->paginate(
  350.                 $auctionVehicles,
  351.                 $request->query->getInt('page', 1),
  352.                 $request->query->getInt('limit', 20)
  353.             );
  355.         } else {
  356.             $auctionVehicles = null;
  357.             $totalResult     = 0;
  358.             $paginator       = null;
  359.         }
  361.         $imageRealPath = $this->getParameter('vehicle_uploaded_files') . '/';
  363.         $data['searchForm']      = $searchForm;
  364.         $data['locale']          = $locale;
  365.         $data['auctionVehicles'] = $auctionVehicles;
  366.         $data['totalResult']     = $totalResult;
  367.         $data['paginator']       = $paginator;
  368.         $data['imageRealPath']   = $imageRealPath;
  369.         $data['auctionStatus']   = $ongoingAuction->getStatus();
  370.         $data['auction']         = $ongoingAuction;
  371.         $data['endDate']         = ($ongoingAuction &&$ongoingAuction->getEndDate()) ?$ongoingAuction->getEndDate() : false;
  373.         return $data;
  374.     }
  376. }