src/Admin/Controller/HomeController.php line 59

Open in your IDE?
  1. <?php
  3. namespace App\Admin\Controller;
  5. use App\Admin\Entity\Invoice;
  6. use App\Admin\Entity\Item;
  7. use App\Admin\Entity\ItemInvoice;
  8. use App\Admin\Entity\Notification;
  9. use App\Admin\Entity\Potm;
  10. use App\Admin\Entity\Account;
  11. use App\Admin\Entity\ApiToken;
  12. use App\Admin\Entity\Reservation;
  13. use App\Admin\Entity\Settings;
  14. use App\Service\FirebaseTokenManager;
  15. use Doctrine\ORM\EntityManagerInterface;
  16. use Exception;
  17. use IntlDateFormatter;
  18. use Knp\Bundle\TimeBundle\DateTimeFormatter;
  19. use Symfony\Component\HttpFoundation\Response;
  20. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  22. use Symfony\Component\Form\Extension\Core\Type\DateType;
  23. use Symfony\Component\Form\Extension\Core\Type\SubmitType;
  24. use Symfony\Component\Form\Extension\Core\Type\TextType;
  25. use Symfony\Component\HttpKernel\Exception\NotFoundHttpException;
  26. use Symfony\Component\HttpFoundation\Request;
  27. use \Liip\ImagineBundle\Imagine\Cache\CacheManager;
  28. use Stripe\InvoiceItem;
  29. use Symfony\Component\Serializer\Encoder\XmlEncoder;
  30. use Symfony\Component\Serializer\Encoder\JsonEncoder;
  31. use Symfony\Component\Serializer\Normalizer\ObjectNormalizer;
  32. use Symfony\Component\Serializer\Serializer;
  34. use Symfony\Component\Mailer\MailerInterface;
  35. use Symfony\Component\Mime\Email;
  36. use Symfony\Contracts\Cache\CacheInterface;
  37. use Symfony\Contracts\Translation\TranslatorInterface;
  38. use YouCan\Pay\YouCanPay;
  40. class HomeController  extends AbstractController
  41. {
  43.     private $cache;
  45.     public function __construct(CacheInterface $cache)
  46.     {
  47.         $this->cache = $cache;
  48.     }
  50.     function send_notificationTokens($tokens, $message, $key)
  51.     {
  52.         
  53.         $firebaseTokenManager = new FirebaseTokenManager($this->cache, $this->getParameter('kernel.project_dir'));
  54.         $res =  $firebaseTokenManager->send_notificationTokens($tokens, $message, $key);
  55.         return $res;
  56.         
  57.     }
  59.     public function index(MailerInterface $mailer,CacheManager $imagineCacheManager, TranslatorInterface $translator, EntityManagerInterface $entityManager): Response
  60.     {
  61.             
  64.         $em = $entityManager;
  65.         
  66.         $image = $imagineCacheManager->getBrowserPath("/admin/img/admin.png", 'thumb_500');
  68.         $notifMessage =  "message" ;
  69.         $notificationMessage =  [
  70.             "id"=>random_int(1, 99999)."",
  71.             "title"=>"rfzefez",
  72.             "message"=>$notifMessage,
  73.             "icon"=>$image,
  74.             "type"=>"messages",
  76.             "cid"=> 232,
  78.             "mid"=> 23,
  79.             "created"=> "Now",
  80.             "latitude" =>2.322,
  81.             "longitude" =>3.22,
  82.             "mtype" => 33,
  83.             "image"=> null,
  84.             "original"=> "ok",
  85.             "first"=>"kkk" ,
  87.             "uid"=>  "" ,
  88.             "ufname"=> "",
  89.             "ulname"=> "",
  90.             "uimage"=>"",
  91.             "uemail"=> "",
  93.             'click_action' => 'FLUTTER_NOTIFICATION_CLICK',
  94.         ];  
  97.         $settings = $em->getRepository(Settings::class)->findOneBy(array());
  98.         //$dd = $this->send_notificationTokens($token,$notificationMessage,$settings->getFirebasekey());
  99.     
  101.         $this->checkPotm($entityManager, $imagineCacheManager, $translator);
  103.         $start = new \DateTime;
  104.         $start->setDate($start->format('Y'), $start->format('n'), 1); // Normalize the day to 1
  105.         $start->setTime(0, 0, 0); // Normalize time to midnight
  106.         $start->sub(new \DateInterval('P12M'));
  107.         $interval = new \DateInterval('P1M');
  108.         $recurrences = 12;
  109.         $date_list  = array();
  110.         foreach (new \DatePeriod($start, $interval, $recurrences, true) as $date) {
  111.             $date_list[] =  $date; // attempting to make it more clear to read here
  112.         }
  113.         $date_list = array_reverse($date_list);
  115.         $new = new \DateTime;
  117.         $year_user = $new->format("Y");
  118.         $month_user = $new->format("m");
  119.         $_selected_user = 0;
  120.         if (isset($_GET["date_user"])) {
  121.             $year_user = $date_list[$_GET["date_user"]]->format("Y");
  122.             $month_user = $date_list[$_GET["date_user"]]->format("m");
  123.             $_selected_user = $_GET["date_user"];
  124.         }
  125.         $result_ = $em->getRepository("App\Auth\Entity\User")
  126.             ->createQueryBuilder('visiteur')
  127.             ->select('DAY(visiteur.created) AS date_, count(visiteur) as count_')
  128.             ->where("YEAR(visiteur.created) = " . $year_user, "MONTH(visiteur.created) = " . $month_user)
  129.             ->groupBy('date_')
  130.             ->getQuery()
  131.             ->getResult();
  133.         $year_matche = $new->format("Y");
  134.         $month_matche = $new->format("m");
  135.         $_selected_matche = 0;
  136.         if (isset($_GET["date_matche"])) {
  137.             $year_matche = $date_list[$_GET["date_matche"]]->format("Y");
  138.             $month_matche = $date_list[$_GET["date_matche"]]->format("m");
  139.             $_selected_matche = $_GET["date_matche"];
  140.         }
  143.         $result_matches = $em->getRepository("App\Admin\Entity\Matche")
  144.             ->createQueryBuilder('matche')
  145.             ->select('DAY(matche.created) AS date_, count(matche) as count_')
  146.             ->where("YEAR(matche.created) = " . $year_matche, "MONTH(matche.created) = " . $month_matche)
  147.             ->groupBy('date_')
  148.             ->getQuery()
  149.             ->getResult();
  151.         $year_reservation = $new->format("Y");
  152.         $month_reservation = $new->format("m");
  153.         $_selected_reservation = 0;
  154.         if (isset($_GET["date_reservation"])) {
  155.             $year_reservation = $date_list[$_GET["date_reservation"]]->format("Y");
  156.             $month_reservation = $date_list[$_GET["date_reservation"]]->format("m");
  157.             $_selected_reservation = $_GET["date_reservation"];
  158.         }
  162.         $result_reservations = $em->getRepository("App\Admin\Entity\Reservation")
  163.             ->createQueryBuilder('reservation')
  164.             ->select('DAY(reservation.date) AS date_, sum(reservation.total) as total_')
  165.             ->where("YEAR(reservation.date) = " . $year_matche, "MONTH(reservation.date) = " . $month_matche)
  166.             ->groupBy('date_')
  167.             ->getQuery()
  168.             ->getResult();
  170.         for ($i = 1; $i <= cal_days_in_month(CAL_GREGORIAN, $month_user, $year_user); $i++) {
  171.             $line_exist = false;
  172.             foreach ($result_ as $key => $value) {
  173.                 if ($value["date_"] == $i) {
  174.                     $line_exist = true;
  175.                     $result_users[$i] = $value;
  176.                 }
  177.             }
  178.             if (!$line_exist == true) {
  180.                 $new_ = array();
  181.                 $new_["date_"] = $i;
  182.                 $new_["count_"] = 0;
  183.                 $result_users[$i] = $new_;
  184.             }
  185.         }
  188.         for ($i = 1; $i <= cal_days_in_month(CAL_GREGORIAN, $month_matche, $year_matche); $i++) {
  189.             $line_exist = false;
  190.             foreach ($result_matches as $key => $value) {
  191.                 if ($value["date_"] == $i) {
  192.                     $line_exist = true;
  193.                     $result_matches_final[$i] = $value;
  194.                 }
  195.             }
  196.             if (!$line_exist == true) {
  198.                 $new_ = array();
  199.                 $new_["date_"] = $i;
  200.                 $new_["count_"] = 0;
  201.                 $result_matches_final[$i] = $new_;
  202.             }
  203.         }
  206.         for ($i = 1; $i <= cal_days_in_month(CAL_GREGORIAN, $month_reservation, $year_reservation); $i++) {
  207.             $line_exist = false;
  208.             foreach ($result_reservations as $key => $value) {
  209.                 if ($value["date_"] == $i) {
  210.                     $line_exist = true;
  211.                     $result_reservations_final[$i] = $value;
  212.                 }
  213.             }
  214.             if (!$line_exist == true) {
  216.                 $new_ = array();
  217.                 $new_["date_"] = $i;
  218.                 $new_["total_"] = 0;
  219.                 $result_reservations_final[$i] = $new_;
  220.             }
  221.         }
  224.         $messages = $em->getRepository('App\Admin\Entity\Support')->count(array());
  226.         $users = $em->getRepository('App\Auth\Entity\User')->count(array());
  227.         $matches = $em->getRepository('App\Admin\Entity\Matche')->count(array());
  228.         $comments = $em->getRepository('App\Admin\Entity\Comment')->count(array());
  229.         $ratings = $em->getRepository('App\Admin\Entity\MatcheReview')->count(array());
  230.         $terrans = $em->getRepository('App\Admin\Entity\Terrain')->count(array());
  231.         $videos = $em->getRepository('App\Admin\Entity\Video')->count(array());
  232.         $invations = $em->getRepository('App\Admin\Entity\MatcheInvitation')->count(array());
  234.         $videos_views = $em->getRepository('App\Admin\Entity\Video')->countViews();
  235.         $videos_likes = $em->getRepository('App\Admin\Entity\Video')->countLikes();
  238.         $penidng = $em->getRepository('App\Admin\Entity\Reservation')->count([
  239.             "status" => "pending"
  240.         ]);
  241.         $paid = $em->getRepository('App\Admin\Entity\Reservation')->count([
  242.             "status" => "paid"
  243.         ]);
  244.         $checking = $em->getRepository('App\Admin\Entity\Reservation')->count([
  245.             "status" => "checking"
  246.         ]);
  247.         $canceled = $em->getRepository('App\Admin\Entity\Reservation')->count([
  248.             "status" => "canceled"
  249.         ]);
  252.         $total_in_app = $em->getRepository("App\Admin\Entity\Reservation")
  253.             ->createQueryBuilder('reservation')
  254.             ->select('SUM(reservation.total) as total ')
  255.             ->where("reservation.status like 'paid' ")
  256.             ->andWhere("reservation.type like 'creditcard' or  reservation.type like 'virement' ")
  257.             ->getQuery()
  258.             ->getSingleScalarResult();
  261.         $total_out_app = $em->getRepository("App\Admin\Entity\Reservation")
  262.             ->createQueryBuilder('reservation')
  263.             ->select('SUM(reservation.total) as total ')
  264.             ->where("reservation.status like 'paid' ")
  265.             ->andWhere("reservation.type like 'manual'  ")
  266.             ->getQuery()
  267.             ->getSingleScalarResult();
  269.         $total_cc = $em->getRepository("App\Admin\Entity\Reservation")
  270.             ->createQueryBuilder('reservation')
  271.             ->select('SUM(reservation.total) as total ')
  272.             ->where("reservation.status like 'paid' ")
  273.             ->andWhere("reservation.type like 'creditcard'  ")
  274.             ->getQuery()
  275.             ->getSingleScalarResult();
  277.         $total_vir = $em->getRepository("App\Admin\Entity\Reservation")
  278.             ->createQueryBuilder('reservation')
  279.             ->select('SUM(reservation.total) as total ')
  280.             ->where("reservation.status like 'paid' ")
  281.             ->andWhere("reservation.type like 'virement'  ")
  282.             ->getQuery()
  283.             ->getSingleScalarResult();
  285.         return $this->render("Admin/Home/index.html.twig", [
  286.             "users" => $users,
  287.             "matches" => $matches,
  288.             "terrans" => $terrans,
  289.             "videos" => $videos,
  290.             "invations" => $invations,
  291.             "videos_views" => $videos_views,
  292.             "videos_likes" => $videos_likes,
  295.             "comments" => $comments,
  296.             "ratings" => $ratings,
  297.             "messages" => $messages,
  298.             "result_users" => $result_users,
  299.             "result_matches_final" => $result_matches_final,
  300.             "result_reservations_final" => $result_reservations_final,
  301.             "date_list" => $date_list,
  302.             "_selected_user" => $_selected_user,
  303.             "_selected_matche" => $_selected_matche,
  304.             "_selected_reservation" => $_selected_reservation,
  305.             "ratings" => $ratings,
  306.             "penidng" => $penidng,
  307.             "paid" => $paid,
  308.             "checking" => $checking,
  309.             "canceled" => $canceled,
  310.             "total_cc" => $total_cc,
  311.             "total_vir" => $total_vir,
  312.             "total_in_app" => $total_in_app,
  313.             "total_out_app" => $total_out_app,
  315.         ]);
  316.     }
  318.     public function checkPotm($em, $imagineCacheManager, $translator)
  319.     {
  323.         $datef = new \DateTime();
  324.         $datef->modify("first day of previous month");
  329.         $datel = new \DateTime();
  330.         $datel->modify("last day of previous month");
  334.         $repository = $em->getRepository('App\Admin\Entity\Potm');
  338.         $query = $repository->createQueryBuilder('m')
  339.             ->where("m.date > :first")
  340.             ->andWhere("m.date < :last")
  341.             ->setParameter("first", $datef)
  342.             ->setParameter("last", $datel)
  343.             ->setMaxResults(1)
  344.             ->getQuery();
  346.         $item = $query->getOneOrNullResult();
  348.         if ($item == null) {
  349.             $repository = $em->getRepository('App\Auth\Entity\User');
  353.             $query = $repository->createQueryBuilder('p')
  354.                 ->select("p")
  355.                 ->addSelect("(count(matche.id) * 0.5 + (SUM(matchePlayer.goals)*2)  + SUM(matchePlayer.assists) ) as note  ")
  356.                 ->where("matche.started > :first")
  357.                 ->andWhere("matche.started < :last")
  358.                 ->setParameter("first", $datef)
  359.                 ->setParameter("last", $datel)
  360.                 ->leftJoin('p.matchePlayers', 'matchePlayer')
  361.                 ->leftJoin('matchePlayer.matche', 'matche')
  362.                 ->groupBy("p")
  363.                 ->orderBy("note", "DESC")
  364.                 ->setMaxResults(1)
  365.                 ->getQuery();
  367.             $user = $query->getOneOrNullResult();
  368.             if ($user != null) {
  369.                 $potm = new Potm();
  370.                 $potm->setUser($user[0]);
  371.                 $potm->setDate($datel);
  372.                 $em->persist($potm);
  373.                 $em->flush();
  374.                 $user_obj = $potm->getUser();
  375.                 $notification  = new Notification();
  376.                 $notification->setContent("notification_selected_as_potm");
  377.                 $notification->setUser($potm->getUser());
  378.                 $notification->setSender("");
  380.                 $image = $imagineCacheManager->getBrowserPath("/admin/img/admin.png", 'thumb_500');
  382.                 $notification->setImage($image);
  383.                 $notification->setPositive(null);
  384.                 $notification->setNegative(null);
  385.                 $notification->setType("profile_follow");
  386.                 $now = new \DateTime();
  387.                 $notification->setExpired($now->modify("+10 years"));
  388.                 $params =  array("id" => $user_obj->getId());
  390.                 $notification->setParameters(json_encode($params));
  391.                 $em->persist($notification);
  392.                 $em->flush();
  394.                 $notificationTitle = $translator->trans('notification_selected_as_potm_title', locale: ($user_obj->getLocal() == null) ? "ar" : $user_obj->getLocal());
  395.                 $notificationMsg = $translator->trans('notification_selected_as_potm', locale: ($user_obj->getLocal() == null) ? "ar" : $user_obj->getLocal());
  398.                 $notificationMessage =  [
  399.                     "id" => random_int(1, 99999)."",
  400.                     "title" => $notificationTitle,
  401.                     "message" => $notificationMsg,
  402.                     "icon" => $image,
  403.                     "status" => "done",
  404.                     "type" => "matche",
  405.                     'click_action' => 'FLUTTER_NOTIFICATION_CLICK',
  406.                 ];
  407.                 $settings = $em->getRepository('App\Admin\Entity\Settings')->findOneBy(array());
  408.                 $this->send_notificationTokens($user_obj->getTokens(), $notificationMessage, $settings->getFirebasekey());
  409.             }
  410.         }
  411.     }
  412.     public function api_first(Request $request, $latitude, $longitude, $local, $token, CacheManager $imagineCacheManager, DateTimeFormatter $dateTimeFormatter, TranslatorInterface $translator): Response
  413.     {
  414.         if ($token != $this->getParameter('token_app')) {
  415.             throw new NotFoundHttpException("Page not found");
  416.         }
  417.         $em = $this->getDoctrine()->getManager();
  418.         if (date('d') < 2) {
  419.             $this->checkPotm($em, $imagineCacheManager, $translator);
  420.         }
  421.         $obj = [];
  424.             $query = $em->getRepository('App\Admin\Entity\Video')->createQueryBuilder('p')
  425.                         ->where('p.enabled = true')
  426.                         ->setMaxResults(15) // Example: Fetching 15 records
  427.                         ->addSelect('RAND() as HIDDEN rand') // MySQL specific: add random ordering
  428.                         ->orderBy('rand')
  429.                         ->getQuery();
  430.             $videos_list = $query->getResult();
  431.         $list = array();
  432.         foreach ($videos_list as $key => $video) {
  433.             $v["id"] = $video->getId();
  434.             $v["likes"] = $video->getLikes();
  435.             $v["views"] = $video->getViews();
  436.             $v["duration"] = $video->getDuration();
  437.             $now = new \DateTime();
  438.             $v["created"] = $dateTimeFormatter->formatDiff($video->getCreated(), $now, $local);
  439.             $v["comments"] = $video->getComments()->count();
  440.             $v["image"] = $imagineCacheManager->getBrowserPath($video->getMedia()->getPath(), 'video_thumb');
  441.             $v["video"] = $request->getSchemeAndHttpHost() . "/" . $request->getBasePath() . $video->getVideo()->getPath();
  442.             #$v["video"]="https://assets.mixkit.co/videos/preview/mixkit-young-woman-missing-a-bowling-shot-49115-large.mp4";
  444.             $u["id"] = $video->getUser()->getId();
  445.             $u["fname"] = $video->getUser()->getFname();
  446.             $u["lname"] = $video->getUser()->getLname();
  447.             $u["image"] = $imagineCacheManager->getBrowserPath($video->getUser()->getMedia()->getPath(), 'thumb_500');
  448.             $v["user"] = $u;
  449.             $list[] = $v;
  450.         }
  453.         $obj["videos"] = $list;
  456.         $repository = $em->getRepository('App\Admin\Entity\Matche');
  457.         $query_builder = $repository->createQueryBuilder('m');
  459.         if ($latitude != 0 && $longitude != 0) {
  460.             $query_builder->addSelect('org,m.id,m.title,m.places,m.description,m.fees,m.started,m.latitude,m.longitude,m.duration,m.terrainType,m.type,m.amount,m.playersnumber,m.minAge,m.maxAge,m.resultHome,m.resultAway,m.created, - ((ACOS(SIN(:lat * PI() / 180) * SIN(m.latitude * PI() / 180) + COS(:lat * PI() / 180) * COS(m.latitude * PI() / 180) * COS((:lng - m.longitude) * PI() / 180)) * 180 / PI()) * 60 * 1.1515  * 1.609344) as  distance')
  461.                 ->leftJoin('m.organizer', 'org')
  462.                 ->leftJoin('org.media', 'orgm')
  463.                 ->where("m.enabled = true", "m.started > :now")
  464.                 ->setParameter('lat', $latitude)
  465.                 ->setParameter('lng', $longitude)
  466.                 ->setParameter('now', new \DateTime());
  467.         } else {
  469.             $query_builder->addSelect("org,m.id,m.title,m.places,m.description,m.fees,m.started,m.latitude,m.longitude,m.duration,m.terrainType,m.type,m.amount,m.playersnumber,m.minAge,m.maxAge,m.resultHome,m.resultAway,m.created")
  470.                 ->leftJoin('m.organizer', 'org')
  471.                 ->leftJoin('org.media', 'orgm')
  472.                 ->where("m.enabled = true", "m.started > :now")
  473.                 ->setParameter('now', new \DateTime());
  474.         }
  476.         if ($latitude != 0 && $longitude != 0) {
  477.             $query_builder->orderBy('distance', "desc");
  478.         }
  479.         $query_builder->addOrderBy('m.started', "asc");
  480.         $query_builder->addOrderBy('m.id', 'ASC');
  483.         $query_builder->setFirstResult(0);
  484.         $query_builder->setMaxResults(10);
  485.         $query =  $query_builder->getQuery();
  486.         $matches_list = $query->getResult();
  488.         $list = array();
  490.         foreach ($matches_list as  $matche) {
  492.             $ma = null;
  494.             $ma["id"] = $matche["id"];
  495.             $ma["title"] = $matche["title"];
  496.             $ma["description"] = $matche["description"];
  497.             $ma["fees"] = $matche["fees"];
  498.             $ma["latitude"] = $matche["latitude"];
  499.             $ma["longitude"] = $matche["longitude"];
  500.             $ma["duration"] = $matche["duration"];
  501.             $ma["terrain"] = $matche["terrainType"];
  502.             $ma["type"] = $matche["type"];
  503.             $ma["amount"] = $matche["amount"];
  504.             $ma["playersnumber"] = $matche["playersnumber"];
  505.             $ma["minAge"] = $matche["minAge"];
  506.             $ma["maxAge"] = $matche["maxAge"];
  507.             $ma["places"] = $matche["places"];
  508.             $ma["resultHome"] = $matche["resultHome"];
  509.             $ma["resultAway"] = $matche["resultAway"];
  510.             $ma["locked"] = $matche[0]->isLocked();
  511.             $ma["gone"] = $matche[0]->isGone();
  512.             $ma["expired"] = $matche[0]->isExpired();
  513.             $ma["end"] = $matche[0]->isEnd();
  514.             $ma["paid"] = $matche[0]->isHasPaid();
  515.             $ma["created"] = $matche["created"]->format("d/m/Y H:i");
  518.             $formatter = new IntlDateFormatter(($local == "ar") ? "ar_ma" : "fr_fr", IntlDateFormatter::LONG, IntlDateFormatter::LONG);
  519.             $formatter->setPattern('dd/MM/yyyy  HH:mm');
  522.             $ma["started"] = $formatter->format($matche["started"]);
  523.             $ma["time"] = $dateTimeFormatter->formatDiff($matche["started"], new \DateTime(), $local);
  524.             $ma["date"] = $dateTimeFormatter->formatDiff($matche["started"], new \DateTime(), $local);
  525.             $ma["day"] = $matche["started"]->format("d");
  526.             $ma["month"] = $matche["started"]->format("F");
  527.             if (!array_key_exists("distance", $matche)) $matche["distance"] = null;
  528.             $ma["distance"] = ($matche["distance"] === null) ? null : round(abs($matche["distance"]), 2);
  529.             $positionsList = array();
  531.             foreach ($matche[0]->getPositions() as $key => $value) {
  532.                 $p = null;
  533.                 $p["id"] = $value->getId();
  534.                 $p["position"] = $value->getPosition();
  535.                 $p["quantity"] = $value->getQuantity();
  536.                 $p["side"] = $value->getSide();
  537.                 $positionsList[] = $p;
  538.             }
  539.             $ma["positions"] = $positionsList;
  542.             $playersList = array();
  543.             foreach ($matche[0]->getPlayers() as $key => $value) {
  544.                 $p = null;
  545.                 $p["id"] = $value->getId();
  546.                 $p["position"] = $value->getPosition();
  547.                 $p["side"] = $value->getSide();
  548.                 $p["type"] = $value->getType();
  549.                 $p["progress"] = $value->getProgress();
  550.                 $p["present"] = $value->getPresent();
  551.                 $p["goals"] = $value->getGoals();
  552.                 $p["assists"] = $value->getAssists();
  553.                 $p["user"]["id"] = $value->getUser()->getId();
  554.                 $p["user"]["fname"] = $value->getUser()->getFname();
  555.                 $p["user"]["lname"] = $value->getUser()->getLname();
  556.                 $p["user"]["phone"] = $value->getUser()->getPhone();
  557.                 $p["user"]["image"] = $imagineCacheManager->getBrowserPath($value->getUser()->getMedia()->getPath(), 'thumb_500');
  559.                 $playersList[] = $p;
  560.             }
  561.             $ma["players"] = $playersList;
  563.             $organizer  = null;
  564.             $organizer["id"] = $matche[0]->getOrganizer()->getId();
  565.             $organizer["fname"] = $matche[0]->getOrganizer()->getFname();
  566.             $organizer["lname"] = $matche[0]->getOrganizer()->getLname();
  567.             $organizer["phone"] = $matche[0]->getOrganizer()->getPhone();
  568.             $organizer["image"] = $imagineCacheManager->getBrowserPath($matche[0]->getOrganizer()->getMedia()->getPath(), 'thumb_500');
  569.             $ma["organizer"] =  $organizer;
  572.             $motm  = null;
  573.             if ($matche[0]->getMotm() != null) {
  574.                 $motm["id"] = $matche[0]->getMotm()->getId();
  575.                 $motm["fname"] = $matche[0]->getMotm()->getFname();
  576.                 $motm["lname"] = $matche[0]->getMotm()->getLname();
  577.                 $motm["phone"] = $matche[0]->getMotm()->getPhone();
  578.                 $motm["image"] = $imagineCacheManager->getBrowserPath($matche[0]->getMotm()->getMedia()->getPath(), 'thumb_500');
  579.             }
  580.             $ma["motm"] =  $motm;
  582.             if ($matche[0]->getConversation() != null) {
  583.                 $ma["conversation"] =  $matche[0]->getConversation()->getId();
  584.             }
  585.             $list[] = $ma;
  586.         }
  588.         $datef = new \DateTime();
  589.         $datef->modify("first day of previous month");
  594.         $datel = new \DateTime();
  595.         $datel->modify("last day of previous month");
  598.         $repository = $em->getRepository('App\Admin\Entity\Potm');
  600.         $query = $repository->createQueryBuilder('m')
  601.             ->where("m.date > :first")
  602.             ->andWhere("m.date < :last")
  603.             ->setParameter("first", $datef)
  604.             ->setParameter("last", $datel)
  605.             ->setMaxResults(1)
  606.             ->getQuery();
  608.         $potm = $query->getOneOrNullResult();
  610.         if ($potm != null) {
  611.             $p["id"] = $potm->getUser()->getId();
  612.             $p["fname"] = $potm->getUser()->getFname();
  613.             $p["lname"] = $potm->getUser()->getLname();
  614.             $p["image"] = $imagineCacheManager->getBrowserPath($potm->getUser()->getMedia()->getPath(), 'thumb_500');
  615.             $obj["potm"]["player"] = $p;
  617.             $formatter = new IntlDateFormatter(($local == "ar") ? "ar_ma" : "fr_fr", IntlDateFormatter::LONG, IntlDateFormatter::LONG);
  618.             $formatter->setPattern('MMMM');
  619.             $obj["potm"]["month"] = $formatter->format($datef);
  620.         }
  621.         $setting = $em->getRepository('App\Admin\Entity\Settings')->findOneBy(array());
  623.         $obj["matches"] = $list;
  625.         $obj["bankname"] = $setting->getBankname();
  626.         $obj["bankaccount"] = $setting->getBankaccount();
  627.         $obj["banknumber"] =  $setting->getBanknumber();
  629.         
  633.         header('Content-Type: application/json');
  634.         $encoders = array(new XmlEncoder(), new JsonEncoder());
  635.         $normalizers = array(new ObjectNormalizer());
  636.         $serializer = new Serializer($normalizers, $encoders);
  637.         $jsonContent = $serializer->serialize($obj, 'json');
  638.         return new Response($jsonContent);
  639.     }
  643.     public function api_stats(
  644.         EntityManagerInterface $em, 
  645.         Request $request, 
  646.         $token
  647.     ): Response
  648.     {
  649.         $parameters = json_decode($request->getContent(), false);
  650.         $id = $parameters->id;
  651.         $token = $parameters->token;
  652.         $duration = $parameters->duration;
  654.         $account = $em->getRepository(Account::class)->findOneBy(array("id" => $id, "enabled" => true));
  655.         $users = 0;
  656.         $terrains = 0;
  657.         $pending = 0;
  658.         $paid = 0;
  659.         $checking = 0;
  660.         $canceled = 0;
  661.         if ($account) {
  662.             $apiToken = $em->getRepository(ApiToken::class)->findOneBy(["token" => $token, "account" => $account]);
  664.             $account_id = $account->getParentId() != null
  665.                 ? $account->getParentId()
  666.                 : $account->getId();
  668.             if ($apiToken) {
  669.                 // $users = $em->getRepository('App\Auth\Entity\User')->count(array());
  670.                 $terrains = $em->getRepository('App\Admin\Entity\Terrain')->count(['account' => $account_id]);
  672.                 $query_builder = $em->getRepository('App\Admin\Entity\Terrain')->createQueryBuilder('t');
  673.                 $query_builder
  674.                     ->innerJoin('t.account', 'account')
  675.                     ->andWhere('account.id = :account_id OR account.id = :parent_id')
  676.                     ->setParameter('account_id', $account->getId())
  677.                     ->setParameter('parent_id', $account->getParentId());
  679.                 $results = $query_builder->getQuery()->getResult();
  680.                 $terrains = count($results);
  682.                 $query_builder = $em->getRepository('App\Admin\Entity\Reservation')->createQueryBuilder('r')
  683.                     ->innerJoin('r.account', 'account')
  684.                     ->andWhere("r.status = 'paid'")
  685.                     ->andWhere('account.id = :account_id OR account.id = :parent_id')
  686.                     ->setParameter('account_id', $account->getId())   
  687.                     ->setParameter('parent_id', $account->getParentId());
  689.                 $results = $query_builder->getQuery()->getResult();
  690.                 $paid = count($results);
  692.                 $query_builder = $em->getRepository('App\Admin\Entity\Reservation')
  693.                     ->createQueryBuilder('r')
  694.                     ->innerJoin('r.account', 'account')
  695.                     ->andWhere("r.status = 'canceled'")
  696.                     ->andWhere('account.id = :account_id OR account.id = :parent_id')
  697.                     ->setParameter('account_id', $account->getId())     
  698.                     ->setParameter('parent_id', $account->getParentId());
  700.                 $results = $query_builder->getQuery()->getResult();
  701.                 $canceled = count($results);
  703.                 $total_in_app = $em->getRepository("App\Admin\Entity\Reservation")
  704.                     ->createQueryBuilder('reservation')
  705.                     ->select('SUM(reservation.total) as total ')
  706.                     ->innerJoin('reservation.account', 'account')
  707.                     ->where("reservation.status like 'paid' ")
  708.                     ->andWhere("reservation.type like 'creditcard' or  reservation.type like 'virement' ")
  709.                     ->andWhere('account.id = :account_id OR account.id = :parent_id')
  710.                     ->setParameter('account_id', $account->getId())     
  711.                     ->setParameter('parent_id', $account->getParentId())
  712.                     ->getQuery()
  713.                     ->getSingleScalarResult();
  714.     
  715.                 $total_out_app = $em->getRepository("App\Admin\Entity\Reservation")
  716.                     ->createQueryBuilder('reservation')
  717.                     ->select('SUM(reservation.total) as total ')
  718.                     ->innerJoin('reservation.account', 'account')
  719.                     ->where("reservation.status like 'paid' ")
  720.                     ->andWhere("reservation.type like 'manual'  ")
  721.                     ->andWhere('account.id = :account_id OR account.id = :parent_id')
  722.                     ->setParameter('account_id', $account->getId())     
  723.                     ->setParameter('parent_id', $account->getParentId())
  724.                     ->getQuery()
  725.                     ->getSingleScalarResult();
  727.                 $graphFirstDate =  new \DateTime("30 days ago");
  728.                 $graphEndDate =  new \DateTime("tomorrow");
  729.                 if ($duration == "this.week") {
  730.                     $graphFirstDate =  new \DateTime("7 days ago");
  731.                 } else if ($duration == "this.month") {
  732.                     $graphFirstDate =  new \DateTime("first day of this month");
  733.                     $graphEndDate =  new \DateTime("tomorrow");
  734.                 } else if ($duration == "last.month") {
  735.                     $graphFirstDate =  new \DateTime("first day of last month");
  736.                     $graphEndDate =  new \DateTime("last day of last month");
  737.                 }
  738.                 $interval = \DateInterval::createFromDateString('+1 day');
  739.                 $period = new \DatePeriod($graphFirstDate, $interval, $graphEndDate);
  740.                 $new = new \DateTime;
  741.                 $year_graph = $graphFirstDate->format("Y");
  742.                 $month_graph = $graphFirstDate->format("m");
  744.                 $result_ = $em->getRepository("App\Admin\Entity\Reservation")
  745.                     ->createQueryBuilder('reservation')
  746.                     ->select('DAY(reservation.date) AS date, sum(reservation.total) as earning')
  747.                     ->innerJoin('reservation.account', 'account')
  748.                     ->where("YEAR(reservation.date) = " . $year_graph, "MONTH(reservation.date) = " . $month_graph)
  749.                     ->andWhere("reservation.status like :paid  ")
  750.                     ->andWhere('account.id = :account_id OR account.id = :parent_id')
  751.                     ->setParameter('account_id', $account->getId())     
  752.                     ->setParameter('parent_id', $account->getParentId())
  753.                     ->setParameter("paid", "paid")
  754.                     ->groupBy('date')
  755.                     ->getQuery()
  756.                     ->getResult();
  758.                 $graph = [];
  759.                 foreach ($period as $dt) {
  760.                     $line_exist = false;
  762.                     foreach ($result_ as $key => $value) {
  763.                         if ($value["date"] == $dt->format("d")) {
  764.                             $line_exist = true;
  765.                             $item = ["name" => $dt->format("d"), "value" => $value["earning"]];
  766.                             $graph[] = $item;
  767.                         }
  768.                     }
  769.                     if (!$line_exist == true) {
  770.                         $item = ["name" => $dt->format("d"), "value" => 0];
  771.                         $graph[] = $item;
  772.                     }
  773.                 }
  774.             }
  775.         }
  777.         return $this->json([
  778.             'terrains' => $terrains,
  779.             'paid' => $paid,
  780.             'canceled' => $canceled,
  781.             'total_in_app' => $total_in_app,
  782.             'total_out_app' => $total_out_app,
  783.             'graph' => $graph
  784.         ], Response::HTTP_OK);
  785.     }
  786. }