src/Controller/admin/AdminHomeController.php line 23

Open in your IDE?
  1. <?php
  4. namespace App\Controller\admin;
  7. use App\Entity\Bursary;
  8. use App\Entity\FundAccount;
  9. use Sensio\Bundle\FrameworkExtraBundle\Configuration\IsGranted;
  10. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  11. use Symfony\Component\HttpFoundation\JsonResponse;
  12. use Symfony\Component\HttpFoundation\Request;
  13. use Symfony\Component\HttpFoundation\Response;
  14. use Symfony\Component\Routing\Annotation\Route;
  16. class AdminHomeController extends AbstractController {
  18.     /**
  19.      * @Route("/admin", name="adminHomeRoute")
  20.      * @IsGranted("ROLE_ADMIN")
  21.      * @return Response
  22.      */
  23.     public function home(Request $request): Response {
  25.         $em = $this->getDoctrine()->getManager();
  27.         $countyId = $request->getSession()->get('county_id');
  30.         $currentBursary = $em->getRepository(Bursary::class)->findOneBy([
  31.             // 'county' => $countyId
  32.         ],[ 'id' => 'desc']);
  35.         /** @var FundAccount[] $funds */
  36.         $funds = $em->getRepository("App:FundAccount")->findBy([
  37.             'isCounty' => true
  38.         ]);
  41.         $countyTotals = $em->getRepository('App:Student')
  42.             ->getCountyTotals($currentBursary);
  44.         $perWardTotals = $em->getRepository('App:Student')->getPerWardTotals($currentBursary);
  48.         return $this->render('admin/home.html.twig',[
  49.             "totals" => $countyTotals,
  50.             "ward_totals" => $perWardTotals,
  51.             "bursary" => $currentBursary,
  52.             "funds" => $funds
  53.         ]);
  54.     }
  56.     /**
  57.      * @Route("/admin/application_statistics", name="adminDashStatistics")
  58.      * @IsGranted("ROLE_ADMIN")
  59.      * @return Response
  60.      */
  61.     public function dashStatistics(): Response
  62.     {
  64.         $em = $this->getDoctrine()->getManager();
  66.         $currentBursary = $em->getRepository(Bursary::class)->findOneBy([
  67.             // 'county' => $countyId
  68.         ],[ 'id' => 'desc']);
  70.         $stats  = $em->getRepository('App:Student')->getPerWardTotals($currentBursary);
  71.         $categoryStats = $em->getRepository('App:Student')->getPerCategoryTotals($currentBursary);
  73.         $data = [
  74.             'gender_stats' => $stats,
  75.             'category_stats' => $categoryStats
  76.         ];
  78.         return new JsonResponse($data, Response::HTTP_OK, [
  79.             'content-type' => 'application/json'
  80.         ]);
  81.     }
  86.     /**
  87.      * @Route("/admin/fix_users", name="adminHomeUserfixRoute")
  88.      * @IsGranted("ROLE_ADMIN")
  89.      * @return Response
  90.      */
  91.     public function userFixAdmin(Request $request): Response {
  92.         $em = $this->getDoctrine()->getManager();
  94.         $countyId = $request->getSession()->get('county_id');
  95.         $county = $em->getRepository("App:County")->findOneBy([
  96.             'id' => $countyId
  97.         ]);
  101.         $wards = $em->getRepository('App:Ward')->findAll();
  103.         foreach ($wards as $index => $ward) {
  104.            $fundAccount = new FundAccount();
  105.            $fundAccount->setAmount(0);
  106.            $fundAccount->setBalance(0);
  107.            $fundAccount->setCounty($county);
  108.            $fundAccount->setCreatedBy($this->getUser());
  109.            $fundAccount->setAccountName($ward->getWardName().' WARD BURSARY FUND ACCOUNT');
  110.            $fundAccount->setIsDefault(false);
  111.            $fundAccount->setCreatedAt(new \DateTimeImmutable());
  113.            $em->persist($fundAccount);
  114.         }
  116.         $em->flush();
  118.          return $this->redirectToRoute('adminHomeRoute');
  119.     }
  120. }