src/Controller/Admin/DashboardController.php line 111

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Admin;
  5. use App\Entity\Color;
  6. use App\Entity\Commission;
  7. use App\Entity\Coupon;
  8. use App\Entity\Discount;
  9. use App\Entity\DiscountName;
  10. use App\Entity\DiscountType;
  11. use App\Entity\Mailing;
  12. use App\Entity\MailingList;
  13. use App\Entity\MailingLog;
  14. use App\Entity\Orden;
  15. use App\Entity\PaymentMethod;
  16. use App\Entity\Payout;
  17. use App\Entity\PercentOff;
  18. use App\Entity\PlatformFee;
  19. use App\Entity\Product;
  20. use App\Entity\Programa;
  21. use App\Entity\ProgramaType;
  22. use App\Entity\PromoCode;
  23. use App\Entity\PromoCodeUsage;
  24. use App\Entity\Provider;
  25. use App\Entity\ProviderType;
  26. use App\Entity\Rate;
  27. use App\Entity\Restriction;
  28. use App\Entity\SendgridJob;
  29. use App\Entity\Solicitud;
  30. use App\Entity\SolicitudPublica;
  31. use App\Entity\Subscription;
  32. use App\Entity\SubscriptionStatus;
  33. use App\Entity\Tax;
  34. use App\Entity\TaxRecord;
  35. use App\Entity\Transaction;
  36. use App\Entity\User;
  37. use Doctrine\ORM\EntityManagerInterface;
  38. use EasyCorp\Bundle\EasyAdminBundle\Config\Actions;
  39. use EasyCorp\Bundle\EasyAdminBundle\Config\Assets;
  40. use EasyCorp\Bundle\EasyAdminBundle\Config\Crud;
  41. use EasyCorp\Bundle\EasyAdminBundle\Config\Dashboard;
  42. use EasyCorp\Bundle\EasyAdminBundle\Config\MenuItem;
  43. use EasyCorp\Bundle\EasyAdminBundle\Config\UserMenu;
  44. use EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractDashboardController;
  45. use EasyCorp\Bundle\EasyAdminBundle\Router\AdminUrlGenerator;
  46. use Symfony\Component\HttpFoundation\Response;
  47. use Symfony\Component\Routing\Annotation\Route;
  48. use Symfony\Component\Security\Core\User\UserInterface;
  49. use Symfony\Component\Serializer\Normalizer\DataUriNormalizer;
  50. use Symfony\Component\Workflow\Registry;
  51. use Symfony\Component\Workflow\WorkflowInterface;
  53. class DashboardController extends AbstractDashboardController
  54. {
  55. private $em;
  56. private $generator;
  57. /**
  58. * @var Registry
  59. */
  60. private $registry;
  62. public function __construct(EntityManagerInterface $em, AdminUrlGenerator $generator, Registry $registry)
  63. {
  64. $this->em = $em;
  65. $this->generator = $generator;
  66. $this->registry = $registry;
  67. }
  69. public function configureAssets(): Assets
  70. {
  71. $r = parent::configureAssets();
  72. // $r->addCssFile('https://cdn.jsdelivr.net/npm/uikit@3.15.19/dist/css/uikit.min.css')
  73. // ->addJsFile('https://cdn.jsdelivr.net/npm/uikit@3.15.19/dist/js/uikit.min.js')
  74. // ->addJsFile('https://cdn.jsdelivr.net/npm/uikit@3.15.19/dist/js/uikit-icons.min.js')
  75. // ;
  76. return $r;
  77. }
  79. public function configureCrud(): Crud
  80. {
  81. $r = parent::configureCrud();
  82. return $r
  83. ->showEntityActionsAsDropdown(false)
  84. ->setPaginatorPageSize(50)
  85. ;
  86. }
  88. public function configureActions(): Actions
  89. {
  90. $r = parent::configureActions();
  91. return $r
  92. ->remove('index', 'delete')
  93. ;
  94. }
  96. public function getCurrentMonth()
  97. {
  98. $f = new \DateTime();
  99. return $f->format('M Y');
  100. }
  101. public function getPreviousMonth()
  102. {
  103. $f = new \DateTime();
  104. $f2 = $f->sub(new \DateInterval('P1M'));
  105. return $f->format('M Y');
  106. }
  108. /**
  109. * @Route("/admin", name="admin")
  110. */
  111. public function index(): Response
  112. {
  113. $r1 = []; $r2 = [];
  114. $pcs = $this->em->getRepository(PromoCode::class)->findAll();
  115. if($pcs){
  116. foreach ($pcs as $pc){
  117. $f = new \DateTime();
  118. $f1 = $f->format('m');
  119. $fa = $f->format('M Y');
  120. $pcus = $this->em->getRepository(PromoCodeUsage::class)->findMonthUsage($pc, $f1);
  121. foreach ($pcus as $pcu){
  122. $var = 0;
  123. $var = $pcu[1] * $pc->getCommission()->getValor();
  124. if($var > 0)$r1[$fa][$pc->getContent()] = ['qty' => $pcu[1], 'comision' => $var];
  125. }
  126. $f2 = $f->sub(new \DateInterval('P1M'));
  127. $fb = $f->format('M Y');
  128. $pcus = $this->em->getRepository(PromoCodeUsage::class)->findMonthUsage($pc, $f2->format('m'));
  129. foreach ($pcus as $pcu){
  130. $var = 0;
  131. $var = $pcu[1] * $pc->getCommission()->getValor();
  132. if($var > 0)$r1[$fa][$pc->getContent()] = ['qty' => $pcu[1], 'comision' => $var];
  133. }
  134. }
  135. }
  137. $rs = [];
  138. for($i = 0; $i <7; $i++){
  139. $f1 = new \DateTime();
  140. $f1->setDate(date('Y'), date('m')-$i, 1);
  141. $r = $this->em->getRepository(Subscription::class)->fetchSubsByDateRange(-$i );
  142. $rs[$f1->format('F Y')] = [count($r), $this->makeSubsLink(SubsDetailCrudController::class, 'int', -$i)];
  143. }
  144. $rs2 = [];
  146. for($i = 0; $i <4; $i++){
  147. $f1 = new \DateTime();
  148. $f1->setDate(date('Y'), date('m')+$i, 1);
  149. $r = $this->em->getRepository(Subscription::class)->fetchSubsByDateRange(+$i );
  150. $rs2[$f1->format('F Y')] = [count($r), $this->makeSubsLink(SubsDetailCrudController::class, 'int', $i)];
  151. }
  153. $ordenes = $this->em->getRepository(Orden::class)->findBy(['currentPlace' => 'Pagada']);
  155. return $this->render('admin/dashboard.html.twig', [
  156. 'venc' => $rs,
  157. 'venc2' => $rs2,
  158. 'vencidas' => [
  159. 'mes1' => $r2,
  160. 'mes2' => $r1,
  161. ],
  162. 'recientes' => [
  163. 'count' => $this->em->getRepository(Subscription::class)->fetchRecientes(true),
  164. 'link' => $this->makeSubsLink(SubscriptionCrudController::class, 'int', 'prox3')
  165. ],
  166. 'ordenes' => [
  167. 'count' => count($ordenes),
  168. 'link' => $this->makeSubsLink(OrdenCrudController::class, 'abiertas', 1)
  169. ],
  170. 'solicitudes' => [
  171. 'count' => count($this->em->getRepository(Solicitud::class)->findAbiertas()),
  172. 'link' => $this->makeSubsLink(SolicitudCrudController::class, 'abierta', 1)
  173. ]
  174. ]);
  175. }
  177. protected function makeSubsLink($class, $key, $value)
  178. {
  179. $link = $this->generator->setAction('index')->setController($class)->set($key, $value);
  180. $r = $link->generateUrl();
  181. $this->generator->unsetAll();
  182. return $r;
  183. }
  185. public function configureUserMenu(UserInterface $user): UserMenu
  186. {
  187. $r = parent::configureUserMenu($user);
  188. $acct = MenuItem::linkToRoute('Mi Cuenta', null, 'app_account');
  189. return $r->addMenuItems([$acct]);
  190. }
  192. public function configureDashboard(): Dashboard
  193. {
  194. return Dashboard::new()
  195. ->disableUrlSignatures()
  196. ->setTitle('Dvpr2022');
  197. }
  199. public function configureMenuItems(): iterable
  200. {
  201. $url = $this->generator->unsetAll()->set('url','https://dvpr.computechapps.com');
  202. yield MenuItem::linkToDashboard('Dashboard', 'fa fa-home');
  203. yield MenuItem::linkToCrud('Solicitudes de Reservación', 'fa fa-home', Solicitud::class)
  204. ->setQueryParameter('abierta', 1)
  205. ->setController(SolicitudCrudController::class);
  206. yield MenuItem::linkToCrud('Solicitudes Socios', 'fa fa-home', SolicitudPublica::class)
  207. ->setController(SolicitudPublicaSocioCrudController::class);
  208. yield MenuItem::linkToCrud('Solicitudes no Socios', 'fa fa-home', SolicitudPublica::class)
  209. ->setController(SolicitudPublicaCrudController::class);
  210. // yield MenuItem::linkToCrud('Solicitudes no Socios', 'fa fa-home', Solicitud::class)
  211. // ->setQueryParameter('shi', 1)
  212. // ->setController(SolicitudNoSocioCrudController::class);
  213. yield MenuItem::subMenu('Users', 'fa fa-user')
  214. ->setSubItems([
  215. MenuItem::linkToCrud('Users', '', User::class)
  216. ->setQueryParameter('usertype', 'user'),
  217. MenuItem::linkToCrud('Users Activos', '', User::class)
  218. ->setQueryParameter('status', 'Activo'),
  219. MenuItem::linkToCrud('Users Activos 15d', '', User::class)
  220. ->setQueryParameter('status', 'Activo 15d'),
  221. MenuItem::linkToCrud('Users Vencidos', '', User::class)
  222. ->setQueryParameter('status', 'Vencido'),
  223. MenuItem::linkToCrud('Users Vencidos 180d', '', User::class)
  224. ->setQueryParameter('status', 'Vencido 180d'),
  225. MenuItem::linkToCrud('Admin Users', '', User::class)
  226. ->setQueryParameter('usertype', 'admin')
  227. ]);
  229. yield MenuItem::subMenu('Subscriptions', 'fa fa-copy')
  230. ->setSubItems([
  231. MenuItem::linkToCrud('General', 'fa fa-home', Subscription::class),
  232. MenuItem::linkToCrud('Activas', 'fa fa-home', Subscription::class)
  233. ->setQueryParameter('status', 1),
  234. // MenuItem::linkToCrud('Activas 15d', 'fa fa-home', Subscription::class)
  235. // ->setQueryParameter('place', 'Activa 15d'),
  236. MenuItem::linkToCrud('Vencidas', 'fa fa-home', Subscription::class)
  237. ->setQueryParameter('status', 2),
  238. // MenuItem::linkToCrud('Vencidas 180d', 'fa fa-home', Subscription::class)
  239. // ->setQueryParameter('place', 'Vencida 180d'),
  240. MenuItem::linkToCrud('Archivadas', 'fa fa-home', Subscription::class)
  241. ->setQueryParameter('status', 3),
  242. // MenuItem::linkToCrud('Recientes', 'fa fa-home', Subscription::class)
  243. // ->setQueryParameter('int', 'prox3'),
  244. ]);
  245. // yield MenuItem::linkToCrud('Mailing', 'fa fa-envelope', Mailing::class);
  246. yield MenuItem::subMenu('Promo Codes', 'fa fa-copy')
  247. ->setSubItems([
  248. MenuItem::linkToCrud('Individuos', 'fa fa-code', PromoCode::class)
  249. ->setQueryParameter('sendgrid', 0),
  250. MenuItem::linkToCrud('Sendgrid', 'fa fa-code', PromoCode::class)
  251. ->setQueryParameter('sendgrid', 1),
  252. ]);
  254. yield MenuItem::section('');
  256. yield MenuItem::subMenu('Mailing', 'fa fa-copy')
  257. ->setSubItems([
  258. MenuItem::linkToRoute('Mailing Dashboard', 'fa fa-envelope', 'app_mailing'),
  259. MenuItem::linkToCrud('Mailing Lists', 'fa fa-list', MailingList::class),
  260. MenuItem::linkToCrud('Users SendGrid', '', User::class)
  261. ->setQueryParameter('sendgrid', 1),
  262. MenuItem::linkToCrud('Users SendGrid Pending', '', User::class)
  263. ->setQueryParameter('sendgrid', 4),
  264. MenuItem::linkToCrud('Users SendGrid Renovados', '', User::class)
  265. ->setQueryParameter('sendgrid', 5),
  266. MenuItem::linkToCrud('Users no SendGrid', '', User::class)
  267. ->setQueryParameter('sendgrid', 0),
  268. MenuItem::linkToCrud('Users no SendGrid Pending', '', User::class)
  269. ->setQueryParameter('sendgrid', 3),
  270. MenuItem::linkToCrud('Uploading SendGrid', '', User::class)
  271. ->setQueryParameter('sendgrid', 2),
  272. MenuItem::linkToCrud('SendGrid Jobs', '', SendgridJob::class),
  273. ]);
  276. yield MenuItem::section('Admin');
  277. yield MenuItem::linkToCrud('Ordenes', 'fa fa-money', Orden::class);
  278. yield MenuItem::linkToCrud('Transacciones', 'fa fa-money', Transaction::class);
  279. yield MenuItem::linkToCrud('Programas', 'fa fa-home', Programa::class)
  280. ->setQueryParameter('activa', 1);
  281. yield MenuItem::linkToCrud('Productos', 'fa fa-home', Product::class)
  282. ->setQueryParameter('activa', 1);
  283. yield MenuItem::linkToCrud('Provider', 'fa fa-home', Provider::class)
  284. ->setQueryParameter('activa', 1);
  285. yield MenuItem::linkToCrud('Mailing Log', 'fa fa-money', MailingLog::class);
  286. // yield MenuItem::linkToCrud('Promo Code Usage', 'fa fa-home', PromoCodeUsage::class);
  287. yield MenuItem::linkToCrud('Payouts Pendientes', 'fa fa-home', Payout::class)
  288. ->setQueryParameter('currentPlace', 'unpaid');
  290. yield MenuItem::subMenu('Archivo' , 'fa fa-folder-open')
  291. ->setSubItems([
  292. MenuItem::linkToCrud('Payouts Pagados', 'fa fa-home', Payout::class)
  293. ->setQueryParameter('currentPlace', 'paid'),
  294. MenuItem::linkToCrud('Programas', 'fa fa-home', Programa::class)
  295. ->setQueryParameter('activa', 0),
  296. MenuItem::linkToCrud('Subscripciones', 'fa fa-home', Subscription::class)
  297. ->setQueryParameter('place', 'Archivada'),
  298. MenuItem::linkToCrud('Productos', 'fa fa-home', Product::class)
  299. ->setQueryParameter('activa', 0),
  300. MenuItem::linkToCrud('Provider', 'fa fa-home', Provider::class)
  301. ->setQueryParameter('activa', 0),
  302. MenuItem::linkToCrud('Tax Record' , 'fa fa-cog', TaxRecord::class),
  303. MenuItem::linkToCrud('Solicitudes de Reservación', 'fa fa-home', Solicitud::class)
  304. ->setQueryParameter('abierta', 0)
  305. ->setController(SolicitudCrudController::class)
  306. ]);
  308. yield MenuItem::subMenu('Promo Code Usage')
  309. ->setSubItems([
  310. MenuItem::linkToCrud( $this->getCurrentMonth(), 'fa fa-calendar', PromoCodeUsage::class)
  311. ->setQueryParameter('month', 'current'),
  312. MenuItem::linkToCrud( $this->getPreviousMonth(), 'fa fa-calendar', PromoCodeUsage::class)
  313. ->setQueryParameter('month', 'previous')
  314. ]);
  315. yield MenuItem::subMenu('Settings', 'fa fa-cogs')
  316. ->setSubItems([
  317. MenuItem::linkToCrud('Taxes', 'fa fa-cog', Tax::class),
  318. MenuItem::linkToCrud('Payment Methods', 'fa fa-cog', PaymentMethod::class),
  319. MenuItem::linkToCrud('Platform Fees', 'fa fa-cog', PlatformFee::class),
  320. MenuItem::linkToCrud('ProgramaTypes', 'fa fa-cog', ProgramaType::class),
  321. MenuItem::linkToCrud('Provider Types', 'fa fa-cog', ProviderType::class),
  322. MenuItem::linkToCrud('Rates', 'fa fa-cog', Rate::class),
  323. MenuItem::linkToCrud('Discount', 'fa fa-cog', Discount::class),
  324. MenuItem::linkToCrud('Discount Names', 'fa fa-cog', DiscountName::class),
  325. MenuItem::linkToCrud('Discount Types', 'fa fa-cog', DiscountType::class),
  326. MenuItem::linkToCrud('Restrictions', 'fa fa-cog', Restriction::class),
  327. MenuItem::linkToCrud('Colors', 'fa fa-cog', Color::class),
  328. MenuItem::linkToCrud('Commissions', 'fa fa-cog', Commission::class),
  329. MenuItem::linkToCrud('Percents Off', 'fa fa-cog', PercentOff::class),
  330. MenuItem::linkToCrud('Sendgrid Jobs', 'fa fa-cog', SendgridJob::class),
  331. ]);
  332. }
  335. //filters[fechaDeUso][comparison]=between
  336. //&filters[fechaDeUso][value][month]=9
  337. //&filters[fechaDeUso][value][day]=1
  338. //&filters[fechaDeUso][value][year]=2022
  339. //&filters[fechaDeUso][value2][month]=9
  340. //&filters[fechaDeUso][value2][day]=30
  341. //&filters[fechaDeUso][value2][year]=2022
  342. }