src/Controller/Backend/DashboardController.php line 20

Open in your IDE?
  1. <?php
  2. namespace App\Controller\Backend;
  4. use App\Controller\Base\BaseController;
  5. use App\Entity\TPublikasi;
  6. use App\Repository\FeedbackRepository;
  7. use App\Repository\TInfografikRepository;
  8. use App\Repository\TLogRepository;
  9. use App\Repository\TPermohonanRepository;
  10. use App\Repository\TPublikasiRepository;
  11. use Symfony\Component\Routing\Annotation\Route;
  12. use Kematjaya\Breadcrumb\Lib\Builder as BreacrumbBuilder;
  13. use Sonata\SeoBundle\Seo\SeoPageInterface;
  15. class DashboardController extends BaseController{
  17.     /**
  18.      * @Route("/dashboard",name="dashboard")
  19.      */
  20.     public function index(SeoPageInterface $seoPage, BreacrumbBuilder $builder, TPublikasiRepository $tPublikasiRepo, TInfografikRepository $tInfografikRepo, TLogRepository $tLogRepo, TPermohonanRepository $tPermohonanRepository, FeedbackRepository $feedbackRepository)
  21.     {
  22.         $seoPage->addTitlePrefix("Dashboard");
  23.         
  24.         $user = $this->getUser()->getRoles();
  26.         $log = $tLogRepo->findBy([], ['reff_id' => 'desc'], 5);
  27.         $conn = $this->getDoctrine()->getConnection();
  28.         $sql = "select b.div_nama, a.reff_id from t_log a join t_div b on CAST(a.reff_name AS integer) = b.id order by a.reff_id desc limit 5";
  29.         $stmt = $conn->query($sql);
  30.         // $stmt->execute();
  31.         $log = $stmt->fetchAllAssociative();
  32.         // dump($log);exit;
  34.         // $publikasi = $tPublikasiRepo->findBy(['status' => '3'], ['view' => 'desc'], 10);
  35.         $publikasi = $this->getQueryBuilder(TPublikasi::class)
  36.                     ->andWhere('this.status = 3')
  37.                     ->andWhere('this.view IS NOT NULL')
  38.                     ->orderBy('this.view', 'desc')
  39.                     ->setMaxResults(10)
  40.                     ->getQuery()
  41.                     ->getResult();
  43.         $total_publikasi = $tPublikasiRepo->findBy(['status' => '3']);
  44.         $total_infografik = $tInfografikRepo->findAll();
  45.         $total_permohonan = $tPermohonanRepository->findAll();
  46.         $total_feedback = $feedbackRepository->findAll();
  48.         $alert_revisi = count($tPublikasiRepo->findBy(['status' => '2']));
  49.         $alert_verif = count($tPublikasiRepo->findBy(['status' => '1']));
  51.         $builder->add('Dashboard ', "dashboard", array(), "&nbsp;<i class='fa fa-home'></i>");
  52.         return $this->render('backend/dashboard/index.html.twig', [
  53.             'user' => $user,
  54.             'list_publikasi' => $publikasi,
  55.             'total_publikasi' => count($total_publikasi),
  56.             'total_infografik' => count($total_infografik),
  57.             'total_permohonan' => count($total_permohonan),
  58.             'total_feedback' => count($total_feedback),
  59.             'alert_revisi' => $alert_revisi,
  60.             'alert_verif' => $alert_verif,
  61.             'log' => $log,
  62.         ]);
  63.     }
  65. }