src/Controller/MainController.php line 28

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Customer;
  6. use App\Entity\Service;
  7. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  8. use Symfony\Component\Routing\Annotation\Route;
  9. use Doctrine\ORM\EntityRepository;
  11. class MainController extends AbstractController
  12. {
  14.     private function amount_service_invoiced_lastXmonths($months) {
  15.         $today = date('Y-m-d');
  16.         $xmonths_ago = date('Y-m-d',strtotime($today . ' -' . $months . ' month'));
  17.         $em = $this->getDoctrine()->getManager();
  18.         $sql = 'select sum(invoicedamount) as sum from service where invoiced = 1 and invoiced_date >= "' . $xmonths_ago . '" and invoiced_date <= "' . $today . '"';
  19.         $sta = $em->getConnection()->prepare($sql);
  20.         $sta->execute();
  21.         $res = $sta->execute()->fetch();
  22.         return $res['sum'];
  23.     }
  25.     /**
  26.      * @Route("/", name="homepage")
  27.      */
  28.     public function homepage() {
  29.         $num_services = $this->getDoctrine()->getRepository(Service::class)->count([]);
  30.         $num_services_started = $this->getDoctrine()->getRepository(Service::class)->count(['status' => 1]);
  31.         $num_services_finished = $this->getDoctrine()->getRepository(Service::class)->count(['status' => 2]);
  32.         $num_services_invoiced = $this->getDoctrine()->getRepository(Service::class)->count(['invoiced' => true]);
  33.         $num_customers = $this->getDoctrine()->getRepository(Customer::class)->count([]);
  35.         $amount_service_invoiced_last_month = $this->amount_service_invoiced_lastXmonths(1);
  36.         $amount_service_invoiced_last_six_month = $this->amount_service_invoiced_lastXmonths(6);;
  38.         return $this->render('main/dashboard.html.twig', [
  39.             'num_services_invoiced' => $num_services_invoiced,
  40.             'amount_service_invoiced_last_month' => $amount_service_invoiced_last_month,
  41.             'amount_service_invoiced_last_six_month' => $amount_service_invoiced_last_six_month,
  42.             'num_services' => $num_services,
  43.             'num_services_started' => $num_services_started,
  44.             'num_services_finished' => $num_services_finished,
  45.             'num_customers' => $num_customers,
  46.         ]);
  47.     }
  49.     public function getUserInfo() {
  51.         $user = $this->getUser();
  53.         return $this->render('baseinfo.html.twig', [
  54.             'user' => $user,
  55.         ]);
  57.     }
  59. }