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.         return $this->redirectToRoute('invoicing_index');
  36.     }
  37.     public function retreiveFromDb( $type = 'upcoming')
  38.     {
  40.         $repository = $this->doctrine->getRepository(Reservation::class);
  41.         $now = new \DateTime();
  42.         $lastMonth = new \DateTime('-1 month');
  43.         $last2Months = new \DateTime('-1 month');
  44.         
  46.         /*case 'invoicing_today':
  47.                 $result = $this->repository->getInvoicingToday();
  48.                 break;
  49.             case 'pending':
  50.                 // pending
  51.                 $result = $this->repository->getPending();
  52.                 break;
  53.             case 'pending2':
  54.                 // pending
  55.                 $result = $this->repository->getByFlow('pending');
  56.                 break;
  57.             case 'upcoming2':
  58.                 // pending
  59.                 $result = $this->repository->getByFlow('upcoming');
  60.                 break;
  61.             case 'past':
  62.                 $result =  $this->repository->getPast();
  63.                 break;
  64.             case 'currentmonth':
  65.                 $result =   $this->repository->getCurrentMonth();
  66.                 break;*/
  68.         $data=[
  69.             'pending'=> $this->repository->getByFlow('pending'),
  70.             'needsaddress'=>   $this->repository->getNeedsAddress(),
  71.              'past'=> $this->doctrine->getManager()
  72.                     ->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')
  73.                     ->setParameter('status_canceled',"canceled"  )
  74.                     ->setParameter('status_inquiry',"inquiry"  )
  75.                     ->getResult(),
  76.              'currentmonth'=> $this->doctrine->getManager()
  77.                     ->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')
  78.                     ->setParameter('year', $now->format("Y") )
  79.                     ->setParameter('date', $now)
  80.                     ->setParameter('status_canceled',"canceled"  )
  81.                     ->setParameter('status_inquiry',"inquiry"  )
  82.                     ->getResult(),
  83.              'lastmonth'=>  $this->doctrine->getManager()
  84.                     ->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')
  85.                     ->setParameter('year', $lastMonth->format("Y") )
  86.                     ->setParameter('date', $lastMonth)
  87.                     ->setParameter('status_canceled',"canceled"  )
  88.                     ->setParameter('status_inquiry',"inquiry"  )
  89.                     ->getResult(),
  90.              'last2months'=>  $this->doctrine->getManager()
  91.                     ->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' )
  92.                     ->setParameter('year', $last2Months->format("Y") )
  93.                     ->setParameter('date', $lastMonth)
  94.                     ->setParameter('date2', $last2Months)
  95.                     ->setParameter('status_canceled',"canceled"  )
  96.                     ->setParameter('status_inquiry',"inquiry"  )
  97.                     ->getResult(),
  98.              'invoiced'=>  $this->doctrine->getManager()
  99.                     ->createQuery('SELECT e FROM App\Entity\Reservation e WHERE  e.status_invoice=1 and e.status!=:status_inquiry ORDER BY e.checkin ASC')
  100.                     ->setParameter('status_inquiry',"inquiry"  )
  101.                     ->getResult(),
  102.              'canceled'=>  $this->doctrine->getManager()
  103.                     ->createQuery('SELECT e FROM App\Entity\Reservation e WHERE  e.status= :status_canceled  or e.status=:status_inquiry ORDER BY e.checkin ASC')
  104.                     ->setParameter('status_canceled',"canceled"  )
  105.                     ->setParameter('status_inquiry',"inquiry"  )
  106.                     ->getResult(),
  107.             'invoicing_today' => $this->repository->getInvoicingToday()
  109.         ];
  112.              $data['all'] =$repository->findAll();
  114.              $data['upcoming']=$this->doctrine->getManager()
  115.                  ->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 ')
  116.                  ->setParameter('status_canceled',"canceled"  )
  117.                  ->setParameter('status_inquiry',"inquiry"  )
  118.                  ->getResult();
  120.             $checkoutFrom='01-05-2025';
  121.             $checkoutFrom= new \DateTime($checkoutFrom);
  123.              $invoiced = $this->doctrine->getManager()
  124.                  ->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')
  125.                  ->setParameter('checkout1',$checkoutFrom)
  126.                  ->setParameter('status_inquiry', "inquiry")
  127.                  ->getResult();
  128.              $autoinvoiced = $this->doctrine->getManager()
  129.                  ->createQuery('SELECT e FROM App\Entity\Reservation e WHERE  e.status_invoice=1 and e.auto_invoiced=1 ORDER BY e.checkin ASC')
  130.                  ->getResult();
  131.               $data['autoinvoiced']=[
  132.                 'autoinvoiced' => count($autoinvoiced),
  133.                 'invoiced' => count($invoiced),
  134.                 'percent' => count($autoinvoiced)/count($invoiced) * 100,
  135.               ];
  139.         return $data;
  141.     }
  142. }