src/Controller/MainController.php line 27

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Church;
  6. use App\Form\ChurchType;
  7. use App\Repository\ChurchRepository;
  8. use App\Repository\LocationRepository;
  9. use App\Repository\MemberRepository;
  10. use App\Repository\PresbyteryRepository;
  11. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  12. use Symfony\Component\HttpFoundation\Request;
  13. use Symfony\Component\HttpFoundation\Response;
  14. use Symfony\Component\Routing\Annotation\Route;
  16. class MainController extends AbstractController
  17. {
  18.     #[Route('/', name: 'app_home')]
  19.     public function index(): Response
  20.     {
  21.         return $this->render('index.html.twig', [
  22.             'controller_name' => 'MainController',
  23.         ]);
  24.     }
  26.     #[Route('/about-us', name: 'about_us')]
  27.     public function aboutUs(): Response
  28.     {
  29.         return $this->render('main/about-us.html.twig', [
  30.             'controller_name' => 'MainController',
  31.         ]);
  32.     }
  34.     #[Route('/photo-gallery', name: 'photo_gallery')]
  35.     public function gallery(): Response
  36.     {
  37.         return $this->render('main/gallery.html.twig', [
  38.             'controller_name' => 'MainController',
  39.         ]);
  40.     }
  42.     #[Route('/admin/dashboard', name: 'admin_dashboard')]
  43.     public function dashboard(MemberRepository $memberRepository, ChurchRepository  $churchRepository, PresbyteryRepository $presbyteryRepository): Response
  44.     {
  45.         $presbyteryName = '';
  46.         if($this->isGranted('ROLE_SUPER_ADMIN')){
  47.             $members = $memberRepository->findAll();
  48.             $church = $churchRepository->findAll();
  49.             $presbytery = $presbyteryRepository->findAll();
  50.         }else{
  51.             $user = $this->getUser();
  52.             $id = $user->getPresbytery()->getId();
  53.             $church = $churchRepository->findBy(['presbytery' => $id]);
  54.             $members = $memberRepository->findBy(['presbytery' => $id]);
  55.             $presbytery = $presbyteryRepository->findBy(['id' => $id]);
  56.             $presbyteryName = $presbytery[0]->getName();
  57.         }
  58.         return $this->render('main/dashboard.html.twig', [
  59.             'totalMember' => count($members),
  60.             'totalChurch' => count($church),
  61.             'totalPresbytery' => count($presbytery),
  62.             'presbyteryName' => $presbyteryName
  63.         ]);
  64.     }
  66.     #[Route('dashboard/chart', name: 'dashboard_chart')]
  67.     public function getReports(MemberRepository $memberRepository){
  68.         $user = $this->getUser();
  69.         $report = $memberRepository->reporting($user);
  70.         $gender = [];
  71.         $ageGroup = [];
  72.         foreach ($report['gender'] as $k => $v)
  73.         {
  74.             array_push($gender, $v);
  75.         }
  76.         foreach ($report['age'] as $value)
  77.         {
  78.             foreach ($value as $k => $v)
  79.             {
  80.                 $ageGroup[$k] = $v;
  81.             }
  82.         }
  83.         $data = [
  84.             'gender' =>  $gender,
  85.             'age' =>  $ageGroup,
  86.             'presbytery' =>  $report['presbytery'],
  87.             'maritalStatus' =>  $report['maritalStatus']
  88.         ];
  89.         return $this->json($data,200);
  90.     }
  92.     #[Route('/executives/list', name: 'executives_list')]
  93.     public function executives(): Response
  94.     {
  95.         $executive['central-committee'] = [
  96.             ['name' => 'Mr. Phur Tshering Lepcha', 'image' => '8759063249.jpg','designation' => 'President','phone' => '8759063249','address' =>'EPC Anden, West Sikkim'],
  97.             ['name'=> 'Mr. Yon Tshering Lepcha','image' => '9832632727.jpg','designation' => 'Vice- President','phone' => '9832632727','address' =>'EPC Rehnock, East Sikkim'],
  98.             ['name'=> 'Mr. Nikanor Rai','image' => '7908440974.jpg','designation' => 'Secretary ','phone' => '7908440974','address' =>'EPC Penlong, East Sikkim'],
  99.             ['name'=> 'Ms. Leegain Lepcha','image' => '9647853240.jpg','designation' => 'Joint-Secretary','phone' => '9647853240','address' =>'EPC Rumbuk, West Sikkim'],
  100.             ['name'=> 'Ms. Samina Lakhey','image' => '701714172.jpg','designation' => 'Treasurer','phone' => '701714172','address' =>'EPC Tadong, East Sikkim'],
  101.             ['name'=> 'Mr. Andrew Lepcha','image' => '8370936842.jpg','designation' => 'Joint-Treasurer','phone' => '8370936842','address' =>'EPC Pabong, South Sikkim'],
  102.         ];
  104.         $executive['advisors'] = [
  105.             ['name' => 'Rev. Pem Kitter Sherpa', 'image' => '8016628266.jpg','designation' => '','phone' => '8016628266','address' =>'EPC Mangalbaria, West Sikkim'],
  106.             ['name'=> 'Rev. Thinlay Dorjee Lepcha','image' => '9593763235.jpg','designation' => '','phone' => '9593763235','address' =>'EPC Sagyong, North Sikkim'],
  107.             ['name'=> 'Shri Lawrence Lepcha','image' => '9933092074.jpg','designation' => ' ','phone' => '9933092074','address' =>'EPC Gangtok, East Sikkim'],
  108.             ['name'=> 'Shri Pema Sukmimoo','image' => '9434109962.jpg','designation' => '','phone' => '9434109962','address' =>'EPC Gangtok, East Sikkim'],
  109.             ['name'=> 'Elder Bimal Sherpa','image' => '9647879249.jpg','designation' => '','phone' => '9647879249','address' =>'EPC Gangtok, East Sikkim']
  110.         ];
  113.         $executive['sub-committee'] = [
  114.             ['name' => 'Mr. Jeewan Kharel', 'image' => '9434382273.jpg','designation' => 'Construction In-Charge','phone' => '9434382273','address' =>'EPC Namthang, South Sikkim'],
  115.             ['name'=> 'Ms. Jessica M. Tamang','image' => '7076174397.jpg','designation' => 'Property In-Charge','phone' => '7076174397 ','address' =>'EPC Bardang, East Sikkim'],
  116.             ['name'=> 'Mr. Samuel Tasho','image' => '9474059363.jpg','designation' => 'Property In-Charge','phone' => '9474059363 ','address' =>'EPC Fambong, West Sikkim'],
  117.         ];
  119.         $executive['executive-committee'] = [
  120.             ['name' => 'Mr. Pravin Chettri ', 'image' => '7047908765.jpg','designation' => 'Sports In-Charge','phone' => '7047908765','address' =>'EPC Namchi, South Sikkim'],
  121.             ['name'=> 'Elder Moses Tamu','image' => '9593269521.jpg','designation' => 'Publicity Secretary','phone' => '9593269521 ','address' =>'EPC Ravangla, South Sikkim'],
  122.             ['name'=> 'Mr. Simeyon Sukita Rai','image' => '8392086260.jpg','designation' => 'Literature In-Charge','phone' => '8392086260 ','address' =>'EPC Ranguthang, South Sikkim'],
  123.             ['name'=> 'Dr. Romona Lepcha','image' => '8906347419.jpg','designation' => 'Literature In-Charge','phone' => '8906347419 ','address' =>'EPC Rehnock, East Sikkim'],
  124.             ['name'=> 'Mrs. Srijana Subba','image' => 'sdfs','designation' => 'Literature In-Charge','phone' => ' ','address' =>'EPC Soreng, West Sikkim'],
  125.             ['name'=> 'Elder. Jagat Jhon Rai','image' => '9434486793.jpg','designation' => 'Social Wing In-Charge (North)','phone' => '9434486793','address' =>'EPC Gangtok, East Sikkim'],
  126.             ['name'=> 'Mr. Milan Rai ','image' => '9733110850.jpg','designation' => 'Social Wing In-Charge (East)','phone' => '9733110850','address' =>'EPC Gangtok, East Sikkim'],
  127.             ['name'=> 'Mr. Mohan Bista','image' => '7797300940.jpg','designation' => 'Social Wing In-Charge (South)','phone' => '7797300940','address' =>'EPC Ravangla, South Sikkim'],
  128.             ['name'=> 'Mr. Joel Lepcha','image' => '1111111111.jpg','designation' => 'Social Wing In-Charge (West)','phone' => '','address' =>'EPC Fambong, West Sikkim'],
  129.             ['name'=> 'Mr. Emanuel Rai','image' => '9434382209.jpg','designation' => 'Culture In-Charge','phone' => '9434382209','address' =>'EPC Ranka, East Sikkim'],
  130.             ['name'=> 'Mr. Mahindra Bardewa','image' => 'sdfs','designation' => 'Culture In-Charge','phone' => '','address' =>'EPC _________, East Sikkim'],
  131.             ['name'=> 'Mr. Biren Subba','image' => 'sdfs','designation' => 'Culture In-Charge','phone' => '','address' =>'EPC Pabong, South Sikkim'],
  132.             ['name'=> 'Mr. Allen Lepcha','image' => '9434410319.jpg','designation' => 'President, North Presbytery Youth Fellowship','phone' => '9434410319','address' =>'EPC Penlong, North Sikkim'],
  133.             ['name'=> 'Mr. Dhan Bahadur Biswakarma','image' => '2222222222.jpg','designation' => 'Vice-President, North Presbytery Youth Fellowship','phone' => '','address' =>'EPC Mangshila, North Sikkim'],
  134.             ['name'=> 'Mr. Dan Tshering Lepcha','image' => '9641214429.jpg','designation' => 'Secretary, North Presbytery Youth Fellowship','phone' => '9641214429','address' =>'EPC Zim-Gor, North Sikkim'],
  135.             ['name'=> 'Ms. Sara Rai','image' => '7908199163.jpg','designation' => 'Joint Secretary, North Presbytery Youth Fellowship','phone' => '7908199163','address' =>'EPC Penlong, North Sikkim'],
  136.             ['name'=> 'Mr. Tempa Tshering Sherpa','image' => '3333333333.jpg','designation' => 'Treasurer, North Presbytery Youth Fellowship','phone' => '9434410319','address' =>'EPC Kabi, East Sikkim'],
  137.             ['name'=> 'Mr. Purna Limboo','image' => '8158977999.jpg','designation' => 'Co-Ordianator, North Presbytery Youth Fellowship','phone' => '8158977999','address' =>'EPC Mangshila, East Sikkim'],
  138.             ['name'=> 'Mr. Pravesh Chettri','image' => '7407126839.jpg','designation' => 'President, South Presbytery Youth Fellowship, Namchi','phone' => '7407126839','address' =>'EPC Namchi, South Sikkim'],
  139.             ['name'=> 'Ms. Shinemit Lepcha','image' => '9593987841.jpg','designation' => 'Secretary, South Presbytery Youth Fellowship, Namchi','phone' => '9593987841','address' =>'EPC Lungchok, South Sikkim'],
  140.             ['name'=> 'Ms. Dawa Ongmu Sherpa','image' => '8348521349.jpg','designation' => 'Treasurer, South Presbytery Youth Fellowship, Namchi','phone' => '8348521349','address' =>'EPC Damthang, South Sikkim'],
  141.             ['name'=> 'Mr. Shawal Lepcha','image' => '7384224816.jpg','designation' => 'Co-Ordianator, South Presbytery Youth Fellowship, Namchi','phone' => '7384224816','address' =>'EPC Wok, South Sikkim'],
  142.             ['name'=> 'Mr. Palden Sukmimoo','image' => '9474357415.jpg','designation' => 'President, East Presbytery Youth Fellowship','phone' => '9474357415','address' =>'EPC Tshalamthang, East Sikkim'],
  143.             ['name'=> 'Mr. Solomon Sharma','image' => '7076219337.jpg','designation' => 'Vice-President, East Presbytery Youth Fellowship','phone' => '7076219337','address' =>'EPC Tadong, East Sikkim'],
  144.             ['name'=> 'Mr. Robin Gurung','image' => '7602997746.jpg','designation' => 'Secretary, East Presbytery Youth Fellowship','phone' => '7602997746','address' =>'EPC Gangtok, East Sikkim'],
  145.             ['name'=> 'Ms. Mayel Lepcha','image' => '7679685490.jpg','designation' => 'Joint-Secretary, East Presbytery Youth Fellowship','phone' => '7679685490','address' =>'EPC Nandok, East Sikkim'],
  146.             ['name'=> 'Ms. Uma Thapa','image' => '859791806.jpg','designation' => 'Treasurer, East Presbytery Youth Fellowship','phone' => '859791806','address' =>'EPC Pakyong, East Sikkim'],
  147.             ['name'=> 'Mr. Daniel Sukmimoo','image' => '8370978364.jpg','designation' => 'Joint-Treasurer, East Presbytery Youth Fellowship','phone' => '8370978364','address' =>'EPC Pakyong, East Sikkim'],
  148.             ['name'=> ' ','image' => 'sdfs','designation' => 'Co-Ordinator, East Presbytery Youth Fellowship','phone' => '','address' =>'EPC , East Sikkim'],
  149.             ['name'=> 'Elder Moses Tamu','image' => '9593269521.jpg','designation' => 'President, Ravangla Presbytery Youth Fellowship','phone' => '9593269521','address' =>'EPC Ravangla, South Sikkim'],
  150.             ['name'=> 'Mr. James Rai','image' => '9733146024.jpg','designation' => 'Vice-President, Ravangla Presbytery Youth Fellowship','phone' => '9733146024','address' =>'EPC Phamtam, South Sikkim'],
  151.             ['name'=> 'Mr. Lall Singh Limboo','image' => '9593387373.jpg','designation' => 'Secretary, Ravangla Presbytery Youth Fellowship','phone' => '9593387373','address' =>'EPC Pawdara, South Sikkim'],
  152.             ['name'=> 'Ms. Anjali Biswa','image' => '7872657418.jpg','designation' => 'Joint-Secretary, Ravangla Presbytery Youth Fellowship','phone' => '7872657418','address' =>'EPC Ravangla, South Sikkim'],
  153.             ['name'=> 'Mr. Mohan Bista (Chettri)','image' => '7797300940.jpg','designation' => 'Treasurer, Ravangla Presbytery Youth Fellowship','phone' => '7797300940.jpg','address' =>'EPC Ravangla, South Sikkim'],
  154.             ['name'=> 'Mr. Aliya Rai','image' => '9732956909.jpg','designation' => 'Co-Ordinator, Ravangla Presbytery Youth Fellowship','phone' => '9732956909','address' =>'EPC Ravangla, South Sikkim'],
  155.             ['name'=> 'Mr. Moses Pradhan','image' => '8372044509.jpg','designation' => 'President, West Presbytery Youth Fellowship','phone' => '8372044509','address' =>'EPC Soreng, West Sikkim'],
  156.             ['name'=> 'Ms. Galen Lepcha','image' => '9734330031.jpg','designation' => 'Secretary, West Presbytery Youth Fellowship','phone' => '9734330031','address' =>'EPC Rumbuk, West Sikkim'],
  157.             ['name'=> 'Mr. Ashit Subba','image' => '8509823278.jpg','designation' => 'Treasurer, West Presbytery Youth Fellowship','phone' => '8509823278','address' =>'EPC Soreng, West Sikkim'],
  158.             ['name'=> '','image' => '','designation' => 'Co-Ordinator, West Presbytery Youth Fellowship','phone' => '','address' =>'EPC , West Sikkim'],
  159.         ];
  160.         return $this->render('main/executives.html.twig', [
  161.             'executive' => $executive,
  162.         ]);
  163.     }
  165.     #[Route('/member/list', name: 'member_list')]
  166.     public function memberList(MemberRepository $memberRepository, PresbyteryRepository $presbyteryRepository): Response
  167.     {
  168.         if($this->isGranted('ROLE_SUPER_ADMIN')){
  169.             $members = $memberRepository->findBy([],['id' => 'DESC']);
  170.             $presbyteryList = $presbyteryRepository->findBy([],['name' => 'ASC']);
  171.         }else{
  172.             $user = $this->getUser();
  173.             $id = $user->getPresbytery()->getId();
  174.             $members = $memberRepository->findBy(['presbytery' => $id],['id' => 'DESC']);
  175.             $presbyteryList = $presbyteryRepository->findBy(['id' => $id],['name' => 'ASC']);
  176.         }
  177.         return $this->render('main/member-list.html.twig', [
  178.             'members' => $members,
  179.             'count' => count($members),
  180.             'presbytery' => $presbyteryList
  181.         ]);
  182.     }
  184.     #[Route('/presbytery/list', name: 'presbytery_list')]
  185.     public function presbyteryList(PresbyteryRepository $presbyteryRepository): Response
  186.     {
  187.         $presbytery = $presbyteryRepository->findAll();
  188.         $dataArray = [];
  189.         foreach ($presbytery as $data){
  190.             $dataArray[] = [
  191.                 'presbytery' => $data->getName(),
  192.                 'church' => $data->getChurch()->getValues()
  193.             ];
  194.         }
  195.         return $this->render('main/presbytery_list.html.twig', [
  196.             'data' => $dataArray,
  197.         ]);
  198.     }
  199.     #[Route('/location/list', name: 'location_list')]
  200.     public function locationList(LocationRepository $locationRepository): Response
  201.     {
  202.         $data = $locationRepository->findAll();
  203.         return $this->render('main/location_list.html.twig', [
  204.             'data' => $data,
  205.         ]);
  206.     }
  208.     #[Route('/church/list', name: 'church_list')]
  209.     public function churchList(ChurchRepository $churchRepository): Response
  210.     {
  211.         if($this->isGranted('ROLE_SUPER_ADMIN')){
  212.             $churches = $churchRepository->findAll();
  213.         }else{
  214.             $user = $this->getUser();
  215.             $id = $user->getPresbytery()->getId();
  216.             $churches = $churchRepository->findBy(['presbytery' => $id],['id' => 'DESC']);
  217.         }
  219.         return $this->render('church/index.html.twig', [
  220.             'churches' => $churches,
  221.         ]);
  222.     }
  224.     #[Route('/church/add', name: 'add_church')]
  225.     public function addChurch(Request $request, ChurchRepository $churchRepository): Response
  226.     {
  227.         $church = new Church();
  228.         $user = $this->getUser();
  229.         $form = $this->createForm(ChurchType::class, $church,['presbyteryId' => $user->getPresbytery() ? $user->getPresbytery()->getId() : null]);
  230.         $form->handleRequest($request);
  231.         if ($form->isSubmitted() && $form->isValid()) {
  232.             $churchRepository->add($form->getData(), true);
  233.             return $this->redirectToRoute('church_list', [], Response::HTTP_SEE_OTHER);
  234.         }
  235.         return $this->render('church/new.html.twig', [
  236.             'form' => $form->createView(),
  237.         ]);
  238.     }
  240.     #[Route('/church/edit/{id}', name: 'edit_church')]
  241.     public function editChurch(Request $request, ChurchRepository $churchRepository, $id): Response
  242.     {
  243.         $church = $churchRepository->find($id);
  244.         $user = $this->getUser();
  245.         $form = $this->createForm(ChurchType::class, $church,['presbyteryId' => $user->getPresbytery() ? $user->getPresbytery()->getId() : null]);
  246.         $form->handleRequest($request);
  247.         if ($form->isSubmitted() && $form->isValid()) {
  248.             $churchRepository->add($form->getData(), true);
  249.             return $this->redirectToRoute('church_list', [], Response::HTTP_SEE_OTHER);
  250.         }
  251.         return $this->render('church/edit.html.twig', [
  252.             'form' => $form->createView(),
  253.         ]);
  254.     }
  256.     #[Route('/filter-location', name: 'filter_location')]
  257.     public function filterLocation(Request $request, LocationRepository $locationRepository)
  258.     {
  259.         $id = $request->query->get('id');
  260.         $filterdLocation = $locationRepository->filterLocation($id);
  261.         return $this->json($filterdLocation,Response::HTTP_OK,[],['groups' => ['presbytery']]);
  262.     }
  263.     #[Route('/filter-church', name: 'filter_church')]
  264.     public function filterChurch(Request $request, ChurchRepository $churchRepository,MemberRepository $memberRepository)
  265.     {
  266.         $type = intval($request->get('church'));
  267.         $id = $request->query->get('id');
  268.         $filteredChurch = $churchRepository->filterChurch($id);
  269.         $memberCount = $memberRepository->totalMembersCount($id,$type);
  270.         return $this->json([$filteredChurch,'count' => $memberCount],Response::HTTP_OK,[],['groups' => ['presbytery']]);
  271.     }
  273. }