src/ApplicationBundle/Modules/Accounts/Controller/RecurringBillingController.php line 19

Open in your IDE?
  1. <?php
  3. namespace ApplicationBundle\Modules\Accounts\Controller;
  5. use ApplicationBundle\Controller\GenericController;
  6. use ApplicationBundle\Interfaces\SessionCheckInterface;
  7. use ApplicationBundle\Modules\Authentication\Constants\UserConstants;
  8. use ApplicationBundle\Modules\Accounts\Service\RecurringBillingManager;
  9. use ApplicationBundle\Modules\Inventory\Inventory;
  10. use Symfony\Component\HttpFoundation\JsonResponse;
  11. use Symfony\Component\HttpFoundation\Request;
  13. /**
  14.  * Recurring billing management — list + add/edit recurring expense / sales-invoice
  15.  * templates, toggle, delete, run-now. Thin controller over RecurringBillingManager.
  16.  */
  17. class RecurringBillingController extends GenericController implements SessionCheckInterface
  18. {
  19.     public function listAction(Request $request)
  20.     {
  21.         $em  = $this->getDoctrine()->getManager();
  22.         $mgr = new RecurringBillingManager($em);
  23.         $conn = $em->getConnection();
  25.         $heads = $conn->fetchAllAssociative(
  26.             "SELECT accounts_head_id AS id, name FROM acc_accounts_head
  27.               WHERE (lock_flag = 0 OR lock_flag IS NULL) ORDER BY name"
  28.         );
  29.         $salesOrders = $conn->fetchAllAssociative(
  30.             "SELECT so.sales_order_id AS id, so.document_hash AS hash, c.client_name AS client
  31.                FROM sales_order so
  32.                LEFT JOIN acc_clients c ON c.client_id = so.client_id
  33.               WHERE so.approved = 1
  34.               ORDER BY so.sales_order_id DESC LIMIT 500"
  35.         );
  37.         return $this->render('@Accounts/pages/views/recurring_billing.html.twig', [
  38.             'schedules'    => $mgr->listSchedules(),
  39.             'heads'        => $heads,
  40.             'salesOrders'  => $salesOrders,
  41.             'currencyList' => Inventory::CurrencyList($em),
  42.             'sidebar_partial' => '@Accounts/inc/_finance_sidebar.html.twig',
  43.             'cp_active'    => 'recurring',
  44.         ]);
  45.     }
  47.     public function saveAction(Request $request): JsonResponse
  48.     {
  49.         $loginId = $request->getSession()->get(UserConstants::USER_LOGIN_ID);
  50.         $em  = $this->getDoctrine()->getManager();
  51.         $mgr = new RecurringBillingManager($em);
  52.         $s = $mgr->saveSchedule($request->request->all(), $loginId);
  53.         return new JsonResponse(['success' => true, 'id' => $s->getId()]);
  54.     }
  56.     public function toggleAction(Request $request, $id): JsonResponse
  57.     {
  58.         $em = $this->getDoctrine()->getManager();
  59.         $s = $em->getRepository('ApplicationBundle\\Entity\\RecurringSchedule')->findOneBy(['id' => (int) $id]);
  60.         if (!$s) { return new JsonResponse(['success' => false, 'message' => 'Not found']); }
  61.         $s->setEnabled($s->getEnabled() ? 0 : 1);
  62.         $s->setUpdatedAt(new \DateTime('now'));
  63.         $em->flush();
  64.         return new JsonResponse(['success' => true, 'enabled' => $s->getEnabled()]);
  65.     }
  67.     public function deleteAction(Request $request, $id): JsonResponse
  68.     {
  69.         $em = $this->getDoctrine()->getManager();
  70.         $em->getConnection()->executeStatement('DELETE FROM recurring_schedule WHERE id = ?', [(int) $id]);
  71.         return new JsonResponse(['success' => true]);
  72.     }
  74.     public function runNowAction(Request $request, $id): JsonResponse
  75.     {
  76.         $loginId = $request->getSession()->get(UserConstants::USER_LOGIN_ID);
  77.         $em  = $this->getDoctrine()->getManager();
  78.         $mgr = new RecurringBillingManager($em);
  79.         $s = $mgr->getSchedule($id);
  80.         if (!$s) { return new JsonResponse(['success' => false, 'message' => 'Not found']); }
  81.         $dry = (int) $request->request->get('dry', 0) === 1;
  82.         $result = $mgr->runSchedule($s, new \DateTime('now'), $loginId, $dry);
  83.         return new JsonResponse(['success' => true, 'result' => $result]);
  84.     }
  85. }