src/Controller/DashboardController.php line 63

  1. <?php
  3. namespace App\Controller;
  5. use App\Helper\DashBoardHelper;
  6. use App\Entity\User;
  7. use App\ValueObject\UserPermission;
  8. use App\ValueObject\UserTypes;
  9. use Doctrine\ORM\EntityManagerInterface;
  10. use Ecommerce121\UtilBundle\Controller\ControllerBase;
  11. use Ecommerce121\UtilBundle\Controller\ControllerUtil;
  12. use Ecommerce121\UtilBundle\Repository\QueryOptions;
  13. use Exception;
  14. use Psr\Cache\InvalidArgumentException;
  15. use Symfony\Component\Cache\Adapter\DoctrineDbalAdapter;
  16. use Symfony\Component\Routing\Attribute\Route;
  17. use Symfony\Component\HttpFoundation\Request;
  18. use Symfony\Component\HttpFoundation\Response;
  20. class DashboardController extends ControllerBase
  21. {
  22. const int YEAR_PERIOD = 11;
  23. const int SIX_MONTH_PERIOD = 5;
  24. const int SEVEN_MONTH_PERIOD = 6;
  25. const int YEAR_AND_MONTH_PERIOD = 12;
  26. const int DAYS_PERIOD = 30;
  27. const int ITEMS_PER_PAGE = 10;
  28. const int ITEM_PER_PAGE_PENDING_REGISTRATION = 5;
  29. const int ITEMS_PER_PAGE_CANDIDATE = 10;
  31. public function __construct(
  32. ControllerUtil $controllerUtil,
  33. private readonly DashBoardHelper $dashBoardHelper,
  34. private readonly EntityManagerInterface $entityManager
  35. ) {
  36. parent::__construct($controllerUtil);
  37. }
  39. /**
  40. * @throws Exception
  41. * @throws InvalidArgumentException
  42. */
  43. #[Route('/', name: 'app_home')]
  44. public function indexAction(Request $request): array|Response
  45. {
  46. $this->denyAccessUnlessGranted(UserPermission::VIEW_DASHBOARD);
  48. /** @var User $user */
  49. $user = $this->getUser();
  50. $entityId = null;
  51. $options = [];
  52. $totalInvoiced = 0;
  53. $barRegistration = null;
  54. $candidates = null;
  55. $candidatesPaginator = null;
  56. $propertiesPaginator = null;
  57. $dueInvoices = null;
  58. $dueInvoicesPaginator = null;
  59. $properties = null;
  60. $invoicesPaginator = null;
  61. $pendingRegistrationRequest = null;
  62. $pendingRegistrationRequestPaginator = null;
  63. $registrationAndRenewalPaginator = null;
  64. $userEmail = null;
  66. $cache = new DoctrineDbalAdapter(
  67. $this->entityManager->getConnection(),
  68. 'chartData',
  69. );
  70. $page = $request->query->get('page', 1);
  72. if ($user->getType() === UserTypes::MUNICIPALITY) {
  73. $entityId = $user->getMunicipality()->getId();
  74. }
  76. if ($user->getRegisterAsIndividual()) {
  77. $userEmail = $user->getEmail();
  78. }
  80. if ($user->getType() === UserTypes::REGISTER_PARTY) {
  81. if ($user->getOrganization())
  82. $entityId = $user->getOrganization()->getId();
  83. }
  85. if ($user->getType() === UserTypes::MUNIREG) {
  86. // $barInvoice = $this->dashBoardHelper->getInvoiceValues(self::YEAR_AND_MONTH_PERIOD);
  87. // $barRegistration = $this->dashBoardHelper->getRegistrationValues(self::SIX_MONTH_PERIOD, $user->getType());
  89. $barInvoiceCacheItem = $cache->getItem('barInvoice');
  90. $barRegistrationCacheItem = $cache->getItem('barRegistration_'. $user->getType().'_');
  92. $barInvoice = $barInvoiceCacheItem->get();
  93. $barRegistration = $barRegistrationCacheItem->get();
  95. $options = [
  96. 'barInvoice' => $barInvoice,
  97. 'barRegistration' => $barRegistration
  98. ];
  99. }
  101. if ($user->getType() === UserTypes::MUNICIPALITY) {
  102. // $barRegistration = $this->dashBoardHelper->getRegistrationValues(self::YEAR_PERIOD, $user->getType(), $entityId);
  103. // $pieRegistration = $this->dashBoardHelper->getRegistrationPieValues(self::YEAR_PERIOD, $user->getType(), $entityId);
  105. $barRegistrationCacheItem = $cache->getItem('barRegistration_'. $user->getType() .'_' .$entityId);
  106. $pieRegistrationCacheItem = $cache->getItem('pieRegistration_'. $user->getType() .'_' .$entityId);
  108. $barRegistration = $barRegistrationCacheItem->get();
  109. $pieRegistration = $pieRegistrationCacheItem->get();
  111. $lastForms = $this->dashBoardHelper->getRegistrationAndRenewal(
  112. self::DAYS_PERIOD,
  113. $user->getMunicipality(),
  114. new QueryOptions($page, self::ITEMS_PER_PAGE, 'createdDate', 'DESC')
  115. );
  117. $registrationAndRenewalPaginator = $this->dashBoardHelper->getRegistrationAndRenewalPaginator(
  118. self::DAYS_PERIOD,
  119. $user->getMunicipality(),
  120. $page,
  121. self::ITEMS_PER_PAGE
  122. );
  124. $options = [
  125. 'barRegistration' => $barRegistration,
  126. 'pieRegistration' => $pieRegistration,
  127. 'registrationAndRenewalPaginator' => $registrationAndRenewalPaginator,
  128. 'lastForms' => $lastForms
  129. ];
  130. }
  132. if ($user->getType() === UserTypes::REGISTER_PARTY) {
  133. $organization = $user->getOrganization();
  135. if ($organization) {
  136. $properties = $this->dashBoardHelper->getRequiredRenewalFormsByOrganization($organization,
  137. new QueryOptions($page, self::ITEMS_PER_PAGE, 'createdDate', 'DESC')
  138. );
  139. $propertiesPaginator = $this->dashBoardHelper->getRequiredRenewalFormsByOrganizationPaginator($organization, $page, self::ITEMS_PER_PAGE);
  141. $dueInvoices = $this->dashBoardHelper->getDueRenewalsByOrganization(
  142. $organization,
  143. new QueryOptions($page, 5, 'createdDate', 'DESC')
  144. );
  145. $invoicesPaginator = $this->dashBoardHelper->getDueRenewalsByOrganizationPaginator($organization, $page, self::ITEMS_PER_PAGE);
  147. $candidates = $this->dashBoardHelper->getCandidateProperties(
  148. $organization,
  149. new QueryOptions($page, self::ITEMS_PER_PAGE_CANDIDATE, 'createdDate', 'DESC')
  150. );
  151. $candidatesPaginator = $this->dashBoardHelper->getCandidatePropertiesPaginator(
  152. $organization,
  153. $page,
  154. self::ITEMS_PER_PAGE_CANDIDATE
  155. );
  157. $pendingRegistrationRequest = $this->dashBoardHelper->getPendingRegistrationRequestOfUser(
  158. $user,
  159. new QueryOptions($page, self::ITEM_PER_PAGE_PENDING_REGISTRATION,'createdDate', 'DESC'),
  160. );
  161. $pendingRegistrationRequestPaginator = $this->dashBoardHelper->getPendingRegistrationRequestOfUser(
  162. $user,
  163. new QueryOptions($page, self::ITEM_PER_PAGE_PENDING_REGISTRATION,'createdDate', 'DESC'),
  164. true,
  165. $page,
  166. self::ITEM_PER_PAGE_PENDING_REGISTRATION
  167. );
  169. $totalInvoiced = $this->dashBoardHelper->getAccountBalance($organization, $userEmail);
  170. }
  172. if ($entityId) {
  173. // $barRegistration = $this->dashBoardHelper->getRegistrationValues(self::SEVEN_MONTH_PERIOD, $user->getType(), $entityId, $userEmail);
  175. $sanitizedEmail = '';
  176. if (!empty($userEmail)) {
  177. $sanitizedEmail = str_replace(
  178. ['{', '}', '(', ')', '/', '\\', '@', ':'],
  179. '_',
  180. $userEmail
  181. );
  182. }
  184. $barRegistrationCacheItem = $cache->getItem('barRegistration_'. $user->getType() .'_' . $entityId . '_' . $sanitizedEmail);
  185. $barRegistration = $barRegistrationCacheItem->get();
  186. }
  188. $options = [
  189. 'totalInvoiced' => $totalInvoiced,
  190. 'barRegistration' => $barRegistration,
  191. 'candidates' => $candidates,
  192. 'candidatesPaginator' => $candidatesPaginator,
  193. 'dueInvoices' => $dueInvoices,
  194. 'properties' => $properties,
  195. 'propertiesPaginator' => $propertiesPaginator,
  196. 'invoicePaginator' => $invoicesPaginator,
  197. 'pendingRegistrationRequests' => $pendingRegistrationRequest,
  198. 'pendingRegistrationRequestPaginator' => $pendingRegistrationRequestPaginator,
  199. ];
  200. }
  202. if ($user->getType() === UserTypes::REGISTER_PARTY) {
  203. if ($request->isXmlHttpRequest()) {
  204. $loadCandidates = $request->query->get('type');
  206. if ($loadCandidates == 'candidates') {
  207. return $this->jsonView('Dashboard/Register/list_candidates.html.twig', $options);
  208. }
  209. if ($loadCandidates == 'require-renewal') {
  210. return $this->jsonView('Dashboard/Register/list_invoices.html.twig', $options);
  211. }
  213. if ($loadCandidates == 'pending-request') {
  214. return $this->jsonView('Dashboard/Register/list_pending_registration_request.html.twig', $options);
  215. }
  217. if ($loadCandidates == 'properties') {
  218. return $this->jsonView('Dashboard/Register/list_required_renewal_property.html.twig', $options);
  219. }
  220. }
  222. return $this->render('Dashboard/Register/index.html.twig', $options);
  223. } elseif ($user->getType() === UserTypes::MUNICIPALITY) {
  224. if ($request->isXmlHttpRequest()) {
  225. return $this->jsonView('Dashboard/Municipal/list.html.twig', $options);
  226. }
  228. return $this->render('Dashboard/Municipal/index.html.twig', $options);
  229. }
  231. return $this->render('Dashboard/munireg.html.twig', $options);
  232. }
  233. }