src/Controller/DashboardController.php line 68

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Repository\GatewayLinkRepository;
  6. use App\Repository\TransactionRepository;
  7. use DateTime;
  8. use Exception;
  9. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  10. use Symfony\Component\HttpFoundation\Response;
  11. use Symfony\Component\Routing\Annotation\Route;
  12. use Symfony\UX\Chartjs\Builder\ChartBuilderInterface;
  13. use Symfony\UX\Chartjs\Model\Chart;
  15. class DashboardController extends AbstractController
  16. {
  17.     private GatewayLinkRepository $GLRepository;
  19.     private TransactionRepository $transactionRepository;
  21.     public function __construct(GatewayLinkRepository $glRepository, TransactionRepository $transactionRepository)
  22.     {
  23.         $this->GLRepository = $glRepository;
  24.         $this->transactionRepository = $transactionRepository;
  25.     }
  27.     #[Route('/', name: 'app_index')]
  28.     public function home(ChartBuilderInterface $chartBuilder): Response
  29.     {
  30.         if (!$this->getUser()) {
  32.             //return $this->redirectToRoute('app_login');
  33.             return $this->render('home.html.twig');
  35.         }
  36.         return $this->redirectToRoute('app_dashboard');
  37.     }
  39.     #[Route('/privacy', name: 'app_privacy')]
  40.     public function privacy(): Response
  41.     {
  42.         return $this->render('home/privacy.html.twig');
  44.     }
  46.     #[Route('/terms', name: 'app_terms')]
  47.     public function terms(): Response
  48.     {
  49.         return $this->render('home/terms.html.twig');
  51.     }
  53.     #[Route('/contact', name: 'app_contact')]
  54.     public function contact(): Response
  55.     {
  56.         return $this->render('home/contact.html.twig');
  58.     }
  60.     #[Route('/getit', name: 'app_getit')]
  61.     public function getit(): Response
  62.     {
  63.         return $this->render('home/getit.html.twig');
  65.     }
  67.     #[Route('/learn', name: 'app_learn')]
  68.     public function learn(): Response
  69.     {
  70.         return $this->render('home/getit.html.twig');
  72.     }
  75.     #[Route('/dashboard', name: 'app_dashboard')]
  76.     public function dashboard(ChartBuilderInterface $chartBuilder): Response
  77.     {
  78.         try {
  79.             $user = $this->getUser();
  81.             $tdate = new DateTime();
  82.             $tdate = $tdate->modify($user->getTimeZoneAdjustment());
  83.             $tdate = new DateTime($tdate->format($user->getCompletedStartDay()));
  85.             if ($user->getCompletedStart() == 'CQ'){
  86.                 $currentMonth = intval($tdate->format('m'));
  88.                 if ($currentMonth <= 3){
  89.                     $tdate = new DateTime($tdate->format('Y') . '-1-1');
  90.                 }elseif  ($currentMonth <= 6){
  91.                     $tdate = new DateTime($tdate->format('Y') . '-4-1');
  92.                 }elseif  ($currentMonth <= 9){
  93.                     $tdate = new DateTime($tdate->format('Y') . '-7-1');
  94.                 }elseif  ($currentMonth <= 12){
  95.                     $tdate = new DateTime($tdate->format('Y') . '-10-1');
  96.                 }
  97.             }
  98.             $tdate = $tdate->modify($user->getCompletedStartDayAdjustment());
  99.             $tdate = $tdate->modify($user->getTimeZoneReAdjustment());
  101.             $edate = new DateTime();
  104.             $query = $this->transactionRepository->createQueryBuilder('t')
  105.                 ->select('t','g')
  106.                 ->leftJoin('t.gateway_link', 'g')
  108.                 ->andWhere('t.user = :uid1')
  109.                 ->setParameter('uid1', $user->getId())
  110.                 ->andWhere('t.created_at >= :cdate')
  111.                 ->setParameter('cdate', $tdate->format('Y-m-d H:i:s'))
  112.                 ->andWhere('t.created_at < :edate')
  113.                 ->setParameter('edate', $edate->format('Y-m-d H:i:s'));
  116. //            $query->getQuery()
  117. //                ->getResult();
  119.             $ctotal = 0.0;
  122.             foreach ($query as $row){
  123.                 $ctotal += 1.00; //$row['transactiondata']['actions'][0]['amount'];
  125.             }
  127. //            if (!empty($newquery)){
  128. //                $tdate = $newquery[0]->getCreatedAt();
  129. //                $tdate = $tdate->modify($user->getTimeZoneAdjustment());
  130. ////                $tdate = new DateTime('' . $fdate->format('Y-m-d'));
  131. //                $edate = new DateTime($tdate->format('Y-m-d'));
  132. //                $fdate = new DateTime($tdate->format('Y-m-d'));
  133. //                $fdate = $fdate->modify($user->getTimeZoneReAdjustment());
  134. //                $edate = $edate->modify('+1 day');
  135. //                $edate = $edate->modify($user->getTimeZoneReAdjustment());
  136. //
  137. ////                $this->addFlash('msg_error', 't ' . $tdate->format('Y-m-d H:i:s' . '  e ' . $edate->format('Y-m-d')));
  138. //
  139. //                $query = $this->transactionRepository->createQueryBuilder('t')
  140. //                    ->andWhere('t.user = :uid1')
  141. //                    ->setParameter('uid1', $user->getId())
  142. //                    ->andWhere('t.created_at >= :cdate')
  143. //                    ->setParameter('cdate', $fdate->format('Y-m-d H:i:s'))
  144. //                    ->andWhere('t.created_at < :edate')
  145. //                    ->setParameter('edate', $edate->format('Y-m-d H:i:s'));
  146. //
  147. //                if (!empty($search)) {
  148. //                        $query->andWhere('t.transaction_data LIKE :search')
  149. //                            ->setParameter('search', "%$search%");
  150. //                }
  151. //
  152. //            }
  153. //            else
  154. //            {
  155. //                $tdate = new DateTime('now');
  156. //                $query = [];
  157. //            }
  160.             $dquery = $this->transactionRepository->createQueryBuilder('t')
  161.                 ->andWhere('t.user = :uid')
  162.                 ->setParameter('uid', $user->getId())
  163.                 ->orderBy('t.id', 'DESC')
  164.                 ->distinct()
  165.                 ->getQuery()
  166.                 ->getResult();
  168.             $tdate = $tdate->modify($user->getTimeZoneAdjustment());
  169.             $edate = $edate->modify($user->getTimeZoneAdjustment());
  171.             return $this->render('dashboard/index.html.twig', [
  172.                 'master' => $this->getUser(),
  173.                 'checks' => 5,
  174.                 'credit_cards' => 47,
  175.                 'other' => 0,
  176.                 'chart_title' => 'Transaction Types the last 30 days',
  177.             ]);
  179.         } catch (Exception $e) {
  180.             $this->addFlash('msg_error', $e->getMessage());
  181.             return $this->redirectToRoute('app_integration_settings');
  182.         }
  185.     }
  186. }