src/Controller/DashboardController.php line 33

  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Reservation;
  6. use App\Service\GuestyConnector;
  7. use Doctrine\Persistence\ManagerRegistry;
  8. use Psr\Log\LoggerInterface;
  9. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  10. use Symfony\Component\HttpFoundation\Request;
  11. use Symfony\Component\HttpFoundation\Response;
  12. use Symfony\Component\Routing\Annotation\Route;
  14. class DashboardController extends AbstractController
  15. {
  16.     protected ManagerRegistry $doctrine;
  17.     protected Request $request;
  18.     protected LoggerInterface $logger;
  19.     private \Doctrine\Persistence\ObjectRepository $repository;
  21.     public function __construct(
  22.         GuestyConnector $guestyconnector,
  23.         ManagerRegistry $doctrine,
  24.         LoggerInterface $logger
  26.     ){
  27.         $this->doctrine = $doctrine;
  28.         $this->logger = $logger;
  29.         $this->repository= $this->doctrine->getRepository(Reservation::class);
  31.     }
  32.     #[Route('/', name: 'app_home')]
  33.     public function index(): Response
  34.     {
  35.         $data = $this->retreiveFromDb();
  37.         return $this->render('dashboard/index.html.twig', [
  38.             'controller_name' => 'DashboardController',
  39.             'data' => $data,
  40.         ]);
  41.     }
  42.     public function retreiveFromDb( $type = 'upcoming')
  43.     {
  45.         $repository = $this->doctrine->getRepository(Reservation::class);
  46.         $now = new \DateTime();
  47.         $lastMonth = new \DateTime('-1 month');
  48.         $last2Months = new \DateTime('-1 month');
  49.         
  51.         /*case 'invoicing_today':
  52.                 $result = $this->repository->getInvoicingToday();
  53.                 break;
  54.             case 'pending':
  55.                 // pending
  56.                 $result = $this->repository->getPending();
  57.                 break;
  58.             case 'pending2':
  59.                 // pending
  60.                 $result = $this->repository->getByFlow('pending');
  61.                 break;
  62.             case 'upcoming2':
  63.                 // pending
  64.                 $result = $this->repository->getByFlow('upcoming');
  65.                 break;
  66.             case 'past':
  67.                 $result =  $this->repository->getPast();
  68.                 break;
  69.             case 'currentmonth':
  70.                 $result =   $this->repository->getCurrentMonth();
  71.                 break;*/
  73.         $data=[
  74.             'pending'=> $this->repository->getByFlow('pending'),
  75.             'needsaddress'=>   $this->repository->getNeedsAddress(),
  76.              'past'=> $this->doctrine->getManager()
  77.                     ->createQuery('SELECT e FROM App\Entity\Reservation e WHERE  e.checkout < CURRENT_DATE() and e.status != :status_canceled  and e.status!=:status_inquiry  and e.status_invoice is NULL ORDER BY e.checkout DESC')
  78.                     ->setParameter('status_canceled',"canceled"  )
  79.                     ->setParameter('status_inquiry',"inquiry"  )
  80.                     ->getResult(),
  81.              'currentmonth'=> $this->doctrine->getManager()
  82.                     ->createQuery('SELECT e FROM App\Entity\Reservation e WHERE YEAR(e.checkout) = :year AND MONTH(e.checkout) = MONTH(:date) and e.status != :status_canceled  and e.status!=:status_inquiry')
  83.                     ->setParameter('year', $now->format("Y") )
  84.                     ->setParameter('date', $now)
  85.                     ->setParameter('status_canceled',"canceled"  )
  86.                     ->setParameter('status_inquiry',"inquiry"  )
  87.                     ->getResult(),
  88.              'lastmonth'=>  $this->doctrine->getManager()
  89.                     ->createQuery('SELECT e FROM App\Entity\Reservation e WHERE YEAR(e.checkout) = :year AND MONTH(e.checkout) = MONTH(:date) and e.status != :status_canceled  and e.status!=:status_inquiry')
  90.                     ->setParameter('year', $lastMonth->format("Y") )
  91.                     ->setParameter('date', $lastMonth)
  92.                     ->setParameter('status_canceled',"canceled"  )
  93.                     ->setParameter('status_inquiry',"inquiry"  )
  94.                     ->getResult(),
  95.              'last2months'=>  $this->doctrine->getManager()
  96.                     ->createQuery('SELECT e FROM App\Entity\Reservation e WHERE YEAR(e.checkout) = :year AND (MONTH(e.checkout) = MONTH(:date)  OR  MONTH(e.checkout) = MONTH(:date2) ) and e.status != :status_canceled  and e.status!=:status_inquiry' )
  97.                     ->setParameter('year', $last2Months->format("Y") )
  98.                     ->setParameter('date', $lastMonth)
  99.                     ->setParameter('date2', $last2Months)
  100.                     ->setParameter('status_canceled',"canceled"  )
  101.                     ->setParameter('status_inquiry',"inquiry"  )
  102.                     ->getResult(),
  103.              'invoiced'=>  $this->doctrine->getManager()
  104.                     ->createQuery('SELECT e FROM App\Entity\Reservation e WHERE  e.status_invoice=1 and e.status!=:status_inquiry ORDER BY e.checkin ASC')
  105.                     ->setParameter('status_inquiry',"inquiry"  )
  106.                     ->getResult(),
  107.              'canceled'=>  $this->doctrine->getManager()
  108.                     ->createQuery('SELECT e FROM App\Entity\Reservation e WHERE  e.status= :status_canceled  or e.status=:status_inquiry ORDER BY e.checkin ASC')
  109.                     ->setParameter('status_canceled',"canceled"  )
  110.                     ->setParameter('status_inquiry',"inquiry"  )
  111.                     ->getResult(),
  112.             'invoicing_today' => $this->repository->getInvoicingToday()
  114.         ];
  117.              $data['all'] =$repository->findAll();
  119.              $data['upcoming']=$this->doctrine->getManager()
  120.                  ->createQuery('SELECT e FROM App\Entity\Reservation e WHERE e.checkin > CURRENT_DATE() and e.status != :status_canceled  and e.status!=:status_inquiry ORDER BY e.checkin ASC ')
  121.                  ->setParameter('status_canceled',"canceled"  )
  122.                  ->setParameter('status_inquiry',"inquiry"  )
  123.                  ->getResult();
  125.             $checkoutFrom='01-05-2025';
  126.             $checkoutFrom= new \DateTime($checkoutFrom);
  128.              $invoiced = $this->doctrine->getManager()
  129.                  ->createQuery('SELECT e FROM App\Entity\Reservation e WHERE  e.checkout >= :checkout1 and e.status!=:status_inquiry  and e.status_invoice=1 ORDER BY e.checkin ASC')
  130.                  ->setParameter('checkout1',$checkoutFrom)
  131.                  ->setParameter('status_inquiry', "inquiry")
  132.                  ->getResult();
  133.              $autoinvoiced = $this->doctrine->getManager()
  134.                  ->createQuery('SELECT e FROM App\Entity\Reservation e WHERE  e.status_invoice=1 and e.auto_invoiced=1 ORDER BY e.checkin ASC')
  135.                  ->getResult();
  136.               $data['autoinvoiced']=[
  137.                 'autoinvoiced' => count($autoinvoiced),
  138.                 'invoiced' => count($invoiced),
  139.                 'percent' => count($autoinvoiced)/count($invoiced) * 100,
  140.               ];
  144.         return $data;
  146.     }
  147. }