src/Controller/PageController.php line 156

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\AifredRestaurants;
  6. use App\Entity\GiftCards;
  7. use App\Entity\QrRedirection;
  8. use App\Entity\User;
  9. use App\Entity\UserRestaurant;
  10. use App\Repository\RestaurantsRepository;
  11. use App\Services\EventLog;
  12. use App\Services\Postgre;
  13. use DateTime;
  14. use Doctrine\ORM\EntityManagerInterface;
  15. use Dompdf\Dompdf;
  16. use Dompdf\Options;
  17. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  18. use Symfony\Component\HttpFoundation\JsonResponse;
  19. use Symfony\Component\HttpFoundation\RedirectResponse;
  20. use Symfony\Component\HttpFoundation\Response;
  21. use Symfony\Component\HttpFoundation\Session\SessionInterface;
  22. use Symfony\Component\Routing\Annotation\Route;
  23. use Symfony\Component\Security\Core\Security;
  24. use App\Repository\UserRepository;
  25. use Symfony\Component\HttpFoundation\Request;
  26. use Symfony\Component\HttpKernel\HttpKernelInterface;
  28. use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  29. use Symfony\Component\Validator\Constraints\Date;
  31. class PageController extends AbstractController
  32. {
  33.     private $user;
  34.     private $user_vendor;
  35.     private $userCurrent;
  36.     private $user_vendors=[];
  37.     private $urid_selected="";
  38.     private $user_restaurants=[];
  39.     private $user_restaurant=[];
  40.     private $nav=[];
  42.     /**
  43.      * PageController constructor.
  44.      * @param Security $security
  45.      * @param UserRepository $userRepository
  46.      * @param Postgre $postgre
  47.      */
  48.     public function __construct(Security $security,  EntityManagerInterface $em){
  49.         $this->user = $security->getUser();
  50.         
  51.         $this->userCurrent =  $this->user ;
  52.       //  dd($this->user);
  53.         //  $this->user =  $this->getDoctrine()->getRepository(User::class)->find($securityUser->id);
  54.         if (!is_null($this->user)) {
  55.             // recuperer les userRestaurant par order de num_order ou id
  56.             $this->userCurrent = $this->user;
  57.             if(in_array(User::ROLE_ADMIN,$this->user->getRoles())){
  58.                 $this->userCurrent =$em->getRepository(User::class)->find($this->userCurrent->getUserId());
  59.             }
  60.             $UserRestaurants =  $em->getRepository(UserRestaurant::class)->findBy(['user'=>$this->userCurrent],["num_order"=>"ASC","id"=>"ASC"]);
  62.             //recuperation de tous les restaurants associer (aifred ou corporate)
  63.             $this->user_restaurants=[];
  64.             foreach (  $UserRestaurants as  $uResto){
  65.                 $key = $uResto->getId();
  66.                 $this->user_restaurants[$key]["id"]=$uResto->getId();
  67.                 $this->user_restaurants[$key]["corporate"]=[];
  68.                 $this->user_restaurants[$key]["michelin"]=[];
  69.                 $this->user_restaurants[$key]["user"]["name"]=$uResto->getUser()->getEmail();
  70.                 $this->user_restaurants[$key]["user"]["ur_id"]=$uResto->getUser()->getUrId();
  71.                 if(!is_null($uResto->getRestaurant())){
  72.                     $this->user_restaurants[$key]["corporate"]["name"]=$uResto->getRestaurant()->getName();
  73.                     $this->user_restaurants[$key]["corporate"]["prefix"]=$uResto->getRestaurant()->getShopCode();
  74.                     $this->user_restaurants[$key]["corporate"]["vendor"]=$uResto->getRestaurant()->getShopifyVendorName();
  75.                     $this->user_restaurants[$key]["corporate"]["id"]=$uResto->getRestaurant()->getId();
  76.                     $this->user_restaurants[$key]["corporate"]["city"]=$uResto->getRestaurant()->getCity();
  77.                     $this->user_restaurants[$key]["corporate"]["report"]=''; // que sur aifred_restaurant
  78.                 }
  79.                 if(!is_null($uResto->getAiRestaurant())){
  80.                     $this->user_restaurants[$key]["michelin"]["name"]=$uResto->getAiRestaurant()->getName();
  81.                     $this->user_restaurants[$key]["michelin"]["prefix"]=$uResto->getAiRestaurant()->getTrigram();
  82.                     $this->user_restaurants[$key]["michelin"]["vendor"]=$uResto->getAiRestaurant()->getShopifyVendor();
  83.                     $this->user_restaurants[$key]["michelin"]["id"]=$uResto->getAiRestaurant()->getId();
  84.                     $this->user_restaurants[$key]["michelin"]["city"]=$uResto->getAiRestaurant()->getCity();
  85.                     $this->user_restaurants[$key]["michelin"]["report"]=$uResto->getAiRestaurant()->getLookerStudioUrl();
  86.                     $this->user_restaurants[$key]["michelin"]["typeform_password"]=$uResto->getAiRestaurant()->getTypeformPassword();
  87.                 }
  88.             }
  90.             //   dd($UserRestaurants,$this->user_restaurants);
  92.             if ($this->user == "NULL") {
  93.                 return $this->redirectToRoute("app_login");
  94.             }
  96.             $UserRestaurants  =  $this->user_restaurants ;
  97.             $UserRestaurant  =  array_shift($this->user_restaurants) ;
  99.             $urid_selected =  $UserRestaurant["id"]??null;
  100.             if(null !== $this->user->getUrId()){
  101.                 $urid_selected = $this->user->getUrId();
  102.                 $UserRestaurant  = $UserRestaurants[$this->user->getUrId()] ;
  103.             }
  104.             /*
  105.                    dd([
  106.                        'userCurrent'=>$this->userCurrent->getUrId(),
  107.                        'user'=>$this->user->getUrId(),
  108.                        '$UserRestaurant'=>$UserRestaurant,
  109.                        'UserRestaurants'=>$UserRestaurants
  110.                    ]);
  111.             */
  112.             $this->user_restaurant = $UserRestaurant;
  114.             if(null !== $UserRestaurant ){
  115.                 $vendor_name = !empty($UserRestaurant["michelin"])?$UserRestaurant["michelin"]["name"] :$UserRestaurant["corporate"]["name"];
  116.                 $vendor_city = !empty($UserRestaurant["michelin"])?$UserRestaurant["michelin"]["city"] :$UserRestaurant["corporate"]["city"];
  117.                 $vendor_prefix = $UserRestaurant["michelin"] ? $UserRestaurant["michelin"]['prefix']:$UserRestaurant["corporate"]['prefix'];
  118.             }else{
  119.                 $vendor_name = $this->user->getUsername();
  120.                 $vendor_city ="";
  121.                 $vendor_prefix ="";
  122.             }
  124.             // $vendorsCurrent  = $this->user->getShopifyVendorName();
  125.             //$resultStripe = $postgre->query("SELECT stripe_connect_account_id FROM restaurants WHERE shopify_vendor_name='".str_replace("'","''",$this->user_vendor)."'");
  126.             // $resultStripe =[];
  127.             $this->nav = [
  128.                 'user_restaurants' =>  $UserRestaurants,
  129.                 'user_restaurant' =>    $UserRestaurant,
  130.                 'urid_selected' =>    $urid_selected,
  131.                 'vendor_name' =>    $vendor_name,
  132.                 'vendor_city' =>    $vendor_city,
  133.                 'prefix' =>$vendor_prefix,
  134.                 //  'stripe_id' =>   (!empty($resultStripe[0]) ?$resultStripe[0]["stripe_connect_account_id"]:""),
  135.                 'user' => $this->user,
  136.                 'userCurrent' => $this->userCurrent
  137.             ];
  139.         }
  140.         $this->em = $em;
  141.         //instance
  142.        // $this->EventLog = new EventLog($em, $this->user );
  143.     }
  145.     public function renderHtml($view, $params=[]){
  146.         $params = array_merge($params,$this->nav);
  147.         return $this->render($view, $params);
  148.     }
  150.     /**
  151.      * @Route("/", name="home")
  152.      * @param UserRepository $userRepository
  153.      * @param Postgre $postgre
  154.      * @return Response
  155.      */
  156.     public function index(UserRepository $userRepository)
  157.     {
  158.         $members=[];
  159.         if(in_array(User::ROLE_ADMIN,$this->user->getRoles())) {
  160.             // $members = $this->em->getRepository(User::class)->findAllByMemberUR();
  161.             //   $members = $this->em->getRepository(User::class)->findUsersWithRestaurants();
  162.             $members = $this->em->getRepository(User::class)->findEmailsGroupedByRestaurant();
  163.         }
  164.         $vendors = $userRepository->getVendors();
  165.         return $this->renderHtml('page/index.html.twig', [
  166.             'members' =>   $members,
  167.             'vendors' =>   $vendors,
  168.             'user' => $this->user
  169.         ]);
  170.         //  }
  171.         //return $this->renderHtml('page/stats.html.twig');
  172.     }
  174.     /**
  175.      * @Route("/gestion-des-comptes", name="manage_users")
  176.      */
  177.     public function manage_users(UserRepository $membresEntity):Response
  178.     {
  179.         if (!isset($this->user) || empty($this->user)) {
  180.             return $this->redirectToRoute("app_login");
  181.         }
  182.         if(!in_array(User::ROLE_DEV,$this->user->getRoles())){
  183.             return $this->redirectToRoute("home");
  184.         }
  185.         //recuperer les users
  186.         $membres = $membresEntity->findBy(array(), array('id' => 'DESC'));
  188.         return $this->renderHtml('page/members.html.twig', [
  189.             'members' => $membres,
  190.             'user' => $this->user
  191.         ]);
  192.     }
  194.     /**
  195.      * @Route("/gestion-des-comptes/{action}/{id?}", name="manage_user")
  196.      */
  197.     public function manage_user(string $action, User $membreEntity=null):Response
  198.     {
  200.         //edit , add, delete
  201.         if (!isset($this->user) || empty($this->user)) {
  202.             return $this->redirectToRoute("app_login");
  203.         }
  204.         if(!in_array(User::ROLE_DEV,$this->user->getRoles())){
  205.             return $this->redirectToRoute("home");
  206.         }
  207.         $url="";
  208.         $is_url=false;
  209.         if($membreEntity !==null && $membreEntity->getToken()!==null){
  210.             $url=  $this->generateUrl('resetting', ['id' => $membreEntity->getId(), 'token' => $membreEntity->getToken()],  UrlGeneratorInterface::ABSOLUTE_URL);
  211.             $is_url=ResettingController::isRequestInTime($membreEntity->getPasswordRequestedAt());
  212.         }
  214.         return $this->renderHtml('page/member.html.twig', [
  215.             'member' => $membreEntity,
  216.             'url'=>$url,
  217.             'is_url'=> $is_url ,
  218.             'action'=>$action,
  219.             'user' => $this->user
  220.         ]);
  221.     }
  223.     /**
  224.      * @Route("/user/saving", name="update_user")
  225.      */
  226.     public function update_user(Request $request):RedirectResponse{
  227.         if (!isset($this->user) || empty($this->user)) {
  228.             return $this->redirectToRoute("app_login");
  229.         }
  231.         $formDatas = $request->request->all();
  233.         $formDatas["vendor"] = join("|",$formDatas["vendors"]);
  235.         unset( $formDatas["vendors"]);
  237.         if( $formDatas["password"]===""){
  238.             unset( $formDatas["password"]);
  239.         }
  241.         $formDatas["save"]=true;
  242.         $rep = $this->controllerApiTiptoque('postRegister', [], json_encode(["user"=>$formDatas]));
  243.         // dd( json_encode(["user"=>$formDatas]),$rep);
  244.         if(isset($rep['user']['id'])){
  245.             return $this->redirectToRoute("manage_user",['action'=>'edit','id'=>$rep['user']['id']]);
  246.         }else{
  247.             return $this->redirectToRoute("manage_users");
  248.         }
  249.     }
  251.     /**
  252.      * @Route("/rapport", name="rapport_seo")
  253.      */
  254.     public function rapport_seo(SessionInterface $session,Request $request):Response
  255.     {
  256.         if (!isset($this->user) || empty($this->user)) {
  257.             return $this->redirectToRoute("app_login");
  258.         }
  260.         $choices_date = $session->get("choices_date", 'last_30_days');
  261.         $mode_display = $session->get("mode_display", "STANDARD");
  263.         $formDatas = $request->request->all();
  264.         if(isset($formDatas["format_date"]) &&  $formDatas["format_date"]!==""){
  265.             $choices_date = $formDatas["format_date"];
  266.         }
  267.         
  268.         if(isset($formDatas["mode_display"])){
  269.             $mode_display = $formDatas["mode_display"]; 
  270.             // ALL_GIFTCARD , STANDARD ou DEBUG
  271.         }
  273.         $session->set("choices_date", $choices_date);
  274.         $session->set("mode_display", $mode_display);
  277.         $now = new DateTime();
  278.         switch ($choices_date){
  279.             case "now":
  280.                 $date_start = $now->format('Y-m-d 00:00:00');
  281.                 $date_end = $now->format('Y-m-d 23:59:59');
  282.                 break;
  283.             case "yesterday":
  284.                 $yesterday = $now->modify('-1 day');
  285.                 $date_start = $yesterday->format('Y-m-d 00:00:00');
  286.                 $date_end = $yesterday->format('Y-m-d 23:59:59');
  287.                 break;
  289.             case "last_30_days":
  290.                 $date_end =  $now->modify('+1 days')->format('Y-m-d h:i:s'); // Revenir à aujourd'hui pour la fin
  291.                 $date_start = $now->modify('-30 days')->format('Y-m-d 00:00:00');
  292.                 break;
  294.             case "last_12_months":
  295.                 $date_end =  $now->modify('+1 days')->format('Y-m-d h:i:s'); // Revenir à aujourd'hui pour la fin
  296.                 $date_start = $now->modify('-12 months')->format('Y-m-d 00:00:00');
  297.                 break;
  298.                 
  299.             case "last_24_months":
  300.                 $date_end =  $now->modify('+1 days')->format('Y-m-d h:i:s'); // Revenir à aujourd'hui pour la fin
  301.                 $date_start = $now->modify('-24 months')->format('Y-m-d 00:00:00');
  302.                 break;
  304.             default:
  305.                 // Valeurs par défaut si aucune correspondance
  306.                 $date_start = $now->format('Y-m-d 00:00:00');
  307.                 $date_end = $now->format('Y-m-d 23:59:59');
  308.                 break;
  309.         }
  310.         $restaurant_id =  isset( $this->user_restaurant["corporate"]['id']) ?$this->user_restaurant["corporate"]['id'] : null;
  311.         $airestaurant_id =  isset( $this->user_restaurant["michelin"]['id']) ?$this->user_restaurant["michelin"]['id'] : null;
  313.         if(in_array(User::ROLE_ALL_GIFTCARD ,$this->user->getRoles() ) && !in_array(User::ROLE_ADMIN ,$this->user->getRoles() )){
  314.             $mode_display = "ALL_GIFTCARD";
  315.         }
  316.        // dd( $mode_display);
  318.         $giftCards = $this->em->getRepository(GiftCards::class)->getGiftCardTransactions(
  319.             $restaurant_id,$airestaurant_id,
  320.             $date_start,$date_end,$mode_display);
  321.           
  322.         /*
  323.         $userRestaurant = $this->em->getRepository(UserRestaurant::class)->findBy(['user'=>$this->user]);
  324.         ancienne version avec le iframe par looker studioUrl
  325.         $lookerStudioUrl ="";
  326.         if(!empty($userRestaurant)){
  327.             $lookerStudioUrl = $this->user_restaurant["michelin"]["report"];
  328.         }
  329.            
  330.         */
  331.         //recuperer les giftcards avec 2 tables
  332.            // dd($this->userCurrent);
  333.         //ou trouver le rapport ....
  334.         return $this->renderHtml('page/rapport.html.twig', [
  335.             "giftCards"=>$giftCards,
  336.             "choices_date"=>$choices_date,
  337.             "mode_display"=>$mode_display
  338.         ]);
  339.     }
  341.     /**
  342.      * @Route("/rapport/pdf/{order_id}", name="invoice_pdf")
  343.      */
  344.     public function invoice_pdf(string $order_id):Response{
  345.         if (!isset($this->user) || empty($this->user)) {
  346.             return $this->redirectToRoute("app_login");
  347.         }
  349.         // verifier si l invoice est que pour ce user
  352.         // Exemple de données pour la facture
  353.         $invoiceData = [
  354.             'id' => $order_id,
  355.             'date' => (new \DateTime())->format('Y-m-d'),
  356.             'customer' => 'John Doe',
  357.             'items' => [
  358.                 ['description' => 'Produit A', 'quantity' => 2, 'price' => 50],
  359.                 ['description' => 'Produit B', 'quantity' => 1, 'price' => 100],
  360.             ],
  361.             'total' => 200,
  362.         ];
  364.         // Options de configuration pour Dompdf
  365.         $options = new Options();
  366.         $options->set('defaultFont', 'Arial');
  368.         $dompdf = new Dompdf($options);
  370.         // Génération du contenu HTML pour le PDF
  371.         $html = $this->render('pdf/invoice.html.twig', [
  372.             'invoice' => $invoiceData,
  373.         ]);
  375.         // Charger le HTML dans Dompdf
  376.         $dompdf->loadHtml($html);
  378.         // (Optionnel) Définir la taille et l'orientation de la page
  379.         $dompdf->setPaper('A4', 'portrait');
  381.         // Générer le PDF
  382.         $dompdf->render();
  384.         // Créer une réponse HTTP avec le contenu du PDF
  385.         return new Response(
  386.             $dompdf->output(),
  387.             200,
  388.             [
  389.                 'Content-Type' => 'application/pdf',
  390.                 'Content-Disposition' => 'inline; filename="invoice_' . $order_id . '.pdf"',
  391.             ]
  392.         );
  394.     }
  397.     /**
  398.      * @Route("/rapport/csv", name="rapport_csv")
  399.      */
  400.     public function rapport_csv(SessionInterface $session):Response{
  401.         if (!isset($this->user) || empty($this->user)) {
  402.             return $this->redirectToRoute("app_login");
  403.         }
  405.         $choices_date = $session->get("choices_date", 'last_12_days');
  406.         $mode_display = $session->get("mode_display", "STANDARD");
  408.         $now = new DateTime();
  409.         switch ($choices_date){
  410.             case "now":
  411.                 $date_start = $now->format('Y-m-d 00:00:00');
  412.                 $date_end = $now->format('Y-m-d 23:59:59');
  413.                 $title_csv = $now->format('Y-m-d');
  414.                 break;
  415.             case "yesterday":
  416.                 $yesterday = $now->modify('-1 day');
  417.                 $date_start = $yesterday->format('Y-m-d 00:00:00');
  418.                 $date_end = $yesterday->format('Y-m-d 23:59:59');
  419.                 $title_csv = $now->format('Y-m-d');
  420.                 break;
  421.             case "last_30_days":
  422.                 $date_end = $now->format('Y-m-d h:i:s'); // Revenir à aujourd'hui pour la fin
  423.                 $title_csv = $now->format('Y-m-d');
  424.                 $date_start = $now->modify('-30 days')->format('Y-m-d 00:00:00');
  425.                 $title_csv .="_".$now->format('Y-m-d');
  426.                 break;
  427.             case "last_12_months":
  428.                 $date_end =  $now->format('Y-m-d h:i:s'); // Revenir à aujourd'hui pour la fin
  429.                 $title_csv = $now->format('Y-m-d');
  430.                 $date_start = $now->modify('-12 months')->format('Y-m-d 00:00:00');
  431.                 $title_csv .= "_".$now->format('Y-m-d');
  432.                 break;
  433.                 case "last_24_months":
  434.                     $date_end =  $now->format('Y-m-d h:i:s'); // Revenir à aujourd'hui pour la fin
  435.                     $title_csv = $now->format('Y-m-d');
  436.                     $date_start = $now->modify('-24 months')->format('Y-m-d 00:00:00');
  437.                     $title_csv .= "_".$now->format('Y-m-d');
  438.                 break;
  439.             default:
  440.                 // Valeurs par défaut si aucune correspondance
  441.                 $date_start = $now->format('Y-m-d 00:00:00');
  442.                 $date_end = $now->format('Y-m-d 23:59:59');
  443.                 break;
  444.         }
  445.         
  446.         if(in_array(User::ROLE_ALL_GIFTCARD ,$this->user->getRoles() )){
  447.             $mode_display = "ALL_GIFTCARD";
  448.         }
  450.         $restaurant_id =  isset( $this->user_restaurant["corporate"]['id']) ?$this->user_restaurant["corporate"]['id'] : null;
  451.         $airestaurant_id =  isset( $this->user_restaurant["michelin"]['id']) ?$this->user_restaurant["michelin"]['id'] : null;
  453.         $giftCards = $this->em->getRepository(GiftCards::class)->getGiftCardTransactions(
  454.             $restaurant_id,$airestaurant_id,
  455.             $date_start,$date_end, $mode_display);
  458.         $data=[
  459.             ["Date", "N° de commande", "Code de la carte", "Montant", "Date de règlement", "Statut du règlement"]
  460.         ];
  462.         foreach ($giftCards as $giftCard){
  463.             if($giftCard['echange_code'] != ""){
  464.                 continue;
  465.             }
  466.             
  467.             $dateTransaction = new DateTime($giftCard['transaction_date']);
  468.             $dateCreation = new DateTime($giftCard['creation_date']);
  469.             array_push($data,[
  470.                 $mode_display == "STANDARD" ?$dateTransaction->format('d/m/Y'):$dateCreation->format('d/m/Y')
  471.                 ,
  472.                 $giftCard['orders_name'],
  473.                 $giftCard['transaction_id'] =='' ? "En attente de validation":  $giftCard['code'],
  474.                 $giftCard['original_balance'],
  475.                 $giftCard['transaction_id'] ==''  ?"":$dateTransaction->format('d/m/Y'),
  476.                 $giftCard['transaction_id'] =='' ?"non utilisé":"payé"
  477.             ]);
  478.         }
  479.         // Génération du contenu CSV
  480.         $csvContent = $this->generateCsv($data);
  481.         // Création d'une réponse HTTP pour le téléchargement du fichier
  482.         $response = new Response($csvContent);
  483.         // Configuration des en-têtes pour le fichier CSV
  485.         $response->headers->set('Content-Type', 'text/csv; charset=UTF-8');
  486.         $response->headers->set('Content-Disposition', 'attachment; filename="rapport_' . $title_csv . '.csv"');
  488.         return $response;
  489.     }
  492.     /**
  493.      * Génère le contenu CSV à partir d'un tableau de données
  494.      */
  495.     private function generateCsv(array $data): string
  496.     {
  497.         // Utilisation de la fonction PHP output buffering pour générer le CSV
  498.         ob_start();
  499.         $output = fopen('php://output', 'w');
  501.         foreach ($data as $row) {
  502.             fputcsv($output, $row);
  503.         }
  505.         fclose($output);
  507.         return ob_get_clean();
  508.     }
  511.     /**
  512.      * @Route("/carte_cadeau", name="gift_card")
  513.      */
  514.     public function gift_card(Request $request):Response
  515.     {
  517.         if (empty($this->user)) {
  518.             return $this->redirectToRoute("app_login");
  519.         }
  520.         //  $userCurrent = $this->em->getRepository(UserRestaurant::class)->findBy(["user"=>$this->user]);
  522.         $giftcard=[];
  523.         if($request->getMethod()=="POST"){
  524.             // cree l url du typeform dans qr_redirection
  525.             $code = $request->request->get("code");
  526.             $code = trim($code);
  527.             if($code !==''){
  528.                 /** @var GiftCards[] $giftcards */
  529.                 $giftcards = $this->em->getRepository(GiftCards::class)->findBy(['code'=>$code]);
  530.                 $giftcard=   $giftcards[0]??[];
  531.                 if($giftcard!==[]){
  532.                     $shopCode = $giftcard->getShopCode();
  533.                     if($shopCode==="CCT"){
  534.                         $shopCode = $shopCode.'_LOGGED';
  535.                     }
  536.                     $qrRedir = $this->em->getRepository(QrRedirection::class)->find('GCA'.$shopCode);
  537.                     $gcaUrl = $qrRedir->getTarget();
  538.                     /*
  539.                     https://tiptoque.typeform.com/to/x9iRwMho#num_carte_cadeau=FAH_6148510482774_0
  540.                     &solde_restant=362
  541.                     &vendor=Chef Kelly Rangama
  542.                     &restaurant=Faham
  543.                     &expiration=Non
  544.                     &date_expiration=04/07/2025
  545.                     &prid=1670321471830
  546.                     &nomcarte=Menu Insulaire (4 séquences) - accords mets et vins
  547.                   
  548.                     erreur
  549.                     https://tiptoque.typeform.com/to/ToCWEu4A#
  550.                     num_carte_cadeau=LODASROUEN_11411244286336_0
  551.                     &amp;solde_restant=190
  552.                     &amp;vendor=Restaurant L Odas - Rouen
  553.                     &amp;restaurant=L'Odas&amp;expiration=Non
  554.                     &amp;date_expiration=05/01/2026
  555.                     &amp;prid=14957864550784
  556.                     &amp;nomcarte=DE L’ODAS EN 5 SERVICES - 2 personnes
  557.                     
  558.                   dans un autre script
  560.                       $page_to='https://tiptoque.typeform.com/to/ToCWEu4A#
  561.                         num_carte_cadeau='.$gift_card[0]['code'].
  562.                         '&product_name='.$product_name.
  563.                         '&solde_restant='.$gift_card[0]['balance'].
  564.                         '&vendor='.$gift_card[0]['vendor'].
  565.                         '&restaurant='.$password_restaurant[0]['name'].
  566.                         '&date_expiration='.$formatted_date.
  567.                         '&nomcarte='.$gift_card[0]['code'];
  569.                         -->GCACCT_LOGGED
  570.                         https://tiptoque.typeform.com/to/ToCWEu4A#num_carte_cadeau=__CARD_NUM__
  571.                         
  572.                         &solde_restant=__BALANCE__
  573.                         &vendor=__VENDOR__
  574.                         &restaurant=__RESTAURANT__
  575.                         &expiration=__EXPIRED__
  576.                         &date_expiration=__EXPIRATION__
  577.                         &prid=__PRID__
  578.                         &product_name=__PNAME__
  579.                         &nomcarte=__PNAME__
  580.                     * */
  584.                     $restaurantName =$this->user_restaurant["michelin"] ? $this->user_restaurant["michelin"]['name']:$this->user_restaurant["corporate"]['name'];
  586.                     $dateNow = new \DateTime();
  587.                     $isExpired = ($dateNow->getTimestamp()>$giftcard->getExpirationDate()->getTimestamp())?"Oui":"Non";
  588.                     $gcaUrl=str_replace( "__CARD_NUM__",$giftcard->getCode(),$gcaUrl);
  589.                     $gcaUrl=str_replace( "__BALANCE__",$giftcard->getBalance(),$gcaUrl);
  590.                     $gcaUrl=str_replace( "__VENDOR__",$giftcard->getVendor(),$gcaUrl);
  591.                     $gcaUrl=str_replace( "__RESTAURANT__",$restaurantName,$gcaUrl);
  592.                     $gcaUrl=str_replace( "__EXPIRED__",$isExpired,$gcaUrl);
  593.                     $gcaUrl=str_replace( "__EXPIRATION__",$giftcard->getExpirationDate()->format("d/m/Y"),$gcaUrl);
  594.                     $gcaUrl=str_replace( "__PRID__",$giftcard->getProductsId(),$gcaUrl);
  595.                     $gcaUrl=str_replace( "__PNAME__",$giftcard->getProductName(),$gcaUrl);
  597.                     if(isset($this->user_restaurant["michelin"])){
  598.                         $gcaUrl=str_replace( "__PASSWORD__",$this->user_restaurant["michelin"]['typeform_password'],$gcaUrl);
  599.                     }
  601.                 }
  602.             }
  603.         }
  605.         //   dd($formDatas);
  606.         //ou trouver le rapport ....
  607.         return $this->renderHtml('page/giftcard.html.twig', [
  608.             'giftcard' =>$giftcard,
  609.             'gcaUrl' =>$gcaUrl ?? '',
  610.             'prefix' =>$this->user_restaurant["michelin"] ? $this->user_restaurant["michelin"]['prefix']:$this->user_restaurant["corporate"]['prefix']
  611.         ]);
  612.     }
  614.     /**
  615.      * @Route("/user/deleted/{id}", name="delete_user")
  616.      */
  617.     public function delete_user(int $id):RedirectResponse{
  618.         if (!isset($this->user) || empty($this->user)) {
  619.             return $this->redirectToRoute("app_login");
  620.         }
  621.         // dd( json_encode(["user"=>$formDatas]),$rep);
  622.         $entityManager = $this->getDoctrine()->getManager();
  623.         $member = $entityManager->getRepository(User::class)->find($id);
  624.         $entityManager->remove($member);
  625.         $entityManager->flush();
  627.         return $this->redirectToRoute("manage_users");
  629.     }
  631.     /**
  632.      * @Route("/mes-commandes", name="orders")
  633.      */
  634.     public function orders():Response
  635.     {
  637.         $dateDujour = explode("/",date("Y/m/d/"));
  638.         $dateDemain = explode("/",date("Y/m/d/",strtotime("+1 DAY")));
  639.         return $this->renderHtml('tcd/index.html.twig', [
  640.             'annee_n'=>$dateDujour[0],
  641.             'mois_n'=>$dateDujour[1],
  642.             'jour_n'=>$dateDujour[2],
  643.             'annee_t'=>$dateDemain[0],
  644.             'mois_t'=>$dateDemain[1],
  645.             'jour_t'=>$dateDemain[2]
  646.         ]);
  647.     }
  649.     /**
  650.      * @Route("/mes-commandes/{annee}/{mois}/{jour}", name="orders_date")
  651.      * @param $annee
  652.      * @param $mois
  653.      * @param $jour
  654.      * @return Response
  655.      */
  656.     public function orders_date($annee, $mois, $jour):Response
  657.     {
  658.         return $this->renderHtml('tcd/date.html.twig', ['annee' => $annee, 'mois' => $mois, 'jour' => $jour]);
  659.     }
  661.     /**
  662.      * @Route("/change-vendor", name="change_vendor")
  663.      * @param Request $request
  664.      * @return RedirectResponse
  665.      */
  666.     public function changeVendor(Request $request):RedirectResponse
  667.     {
  668.         if (!isset($this->user) || empty($this->user)) {
  669.             return $this->redirectToRoute("app_login");
  670.         }
  672.         $urSelected = $request->request->get("urid");
  673.         //  dd($urSelected);
  674.         // exit($urSelected);
  675.         $this->user->setUrId($urSelected);
  676.         $this->em->persist($this->user);
  677.         $this->em->flush();
  678.         return $this->redirectToRoute("home");
  679.     }
  681.     /**
  682.      * @Route("/change-member", name="change_member")
  683.      * @param Request $request
  684.      * @return RedirectResponse
  685.      */
  686.     public function changeMember(Request $request):RedirectResponse
  687.     {
  688.       
  689.         if (!isset($this->user) || empty($this->user)) {
  690.             return $this->redirectToRoute("app_login");
  691.         }
  693.         if(!in_array(User::ROLE_ADMIN,$this->user->getRoles())){
  694.             return $this->redirectToRoute("home");
  695.         }
  697.         $userSelected = $request->request->get("user_id");
  698.         $this->user->setUrId(null);
  699.         $this->user->setUserId($userSelected);
  700.         $this->em->persist($this->user);
  701.         $this->em->flush();
  702.         return $this->redirectToRoute("home");
  703.     }
  705.     /**
  706.      * @Route("/cache/init", name="initCacheProduct")
  707.      * @param Request $request
  708.      * @return RedirectResponse
  709.      */
  710.     public function initCacheProduct(Request $request):RedirectResponse
  711.     {
  712.         $dirCacheJson = '../var/cache/' . $_ENV['APP_ENV'] . '/products';
  713.         $fileCacheJson = $dirCacheJson . '/' . ApiController::strToHandle($this->user_vendor) . '.json';
  714.         if (\is_file($fileCacheJson)) {
  715.             unlink($fileCacheJson);
  716.         }
  717.         //recharge le json
  718.         $this->forward(ApiController::class . '::getProducts');
  720.         return $this->redirectToRoute("home");
  721.     }
  723.     /**
  724.      * @Route("/mes_menus_et_mes_cartes", name="products")
  725.      * @param UserRepository $userRepository
  726.      * @return Response
  727.      */
  728.     public function products(UserRepository $userRepository):Response
  729.     {
  730.         if(in_array(User::ROLE_USER_OPS,$this->user->getRoles())){
  731.             return $this->redirectToRoute("home");
  732.         }
  733.         //prepare dossier temporaire pour les updload image
  734.         $directoryTmp = $this->getParameter("upload_tmp");
  735.         if (!is_dir($directoryTmp)) {
  736.             mkdir($directoryTmp);
  737.         }
  739.         $directoryTmpVendor = $directoryTmp . ApiController::strToHandle($this->user_vendor) . '/';
  741.         if (is_dir($directoryTmp)) {
  742.             $this->deleteDirectory($directoryTmpVendor);
  743.         }
  744.         $responseJson = $this->forward(ApiController::class . '::getSettings', ["type" => "allergens"]);
  745.         $allergens = json_decode($responseJson->getContent(), true);
  747.         $vendors = $userRepository->getVendors();
  749.         $daysWeek = ["Lundi", "Mardi", "Mercredi", "Jeudi", "Vendredi", "Samedi", "Dimanche"];
  750.         $daysWeekMin = ["Lu", "Ma", "Me", "Je", "Ve", "Sa", "Di"];
  751.         $timesSlot = ["10h - 12h", "12h - 14h", "14h - 16h", "16h - 18h", "18h - 20h"];
  752.         $intervalsSlot = [[10, 11], [12, 13], [14, 15], [16, 17], [18, 19]];
  754.         //recuperer les produits avec le json de apiController
  755.         $responseJson = $this->forward(ApiController::class . '::getProducts');
  757.         $datas = json_decode($responseJson->getContent(), true);
  758.         // $types = json_decode($this->forward(ApiController::class . '::getCategories')->getContent(), true);
  759.         $types = ApiController::getTypes();
  760.         //  $gammes = ApiController::getTypes();
  761.         //supprimer les produits autres
  762.         $types = array_filter($types, function ($element) {
  763.             return ($element["code"] != "XX" && $element["code"] != "09");
  764.         });
  766.         if (!isset($datas["products"])) {
  767.             $datas["products"] = [];
  768.         }
  770.         $typesProductOrder = [
  771.             ["show" => true, "title" => "Mes menus", "type_slug" => "menu", "type" => "Menu", "sort" => ["Menu"]],
  772.             ["show" => false, "title" => "A la carte", "type_slug" => "a-la-carte", "type" => "A la carte", "sort" => ["Entrée", "Plat", "Dessert"]],
  773.             ["show" => false, "title" => "A partager", "type_slug" => "a-partager", "type" => "A partager", "sort" => ["A partager"]],
  774.             ["show" => false, "title" => "Autres articles", "type_slug" => "autre-article", "type" => "Autre article", "sort" => ["Autre article"]],
  775.             ["show" => false, "title" => "Vins, sipiritueux et autres alcools", "type_slug" => "boissons-alcoolise", "type" =>  "Boissons alcoolisé"  , "sort" => [ "Vin blanc","Vin rosé","Vin rouge","Bière","Champagne et bulle","Spiritueux","Autre boisson alcoolisée"]],
  776.             ["show" => false, "title" => "Boissons non alcoolisees", "type_slug" => "boissons-non-alcoolise", "type" => "Boissons non alcoolisé", "sort" => ["Eau minérale","Soft"]],
  778.         ];
  780.         $listeTypeProducts = [];
  781.         foreach ($typesProductOrder as $type_index => $typesorder) {
  782.             $cptProduct = 0;
  783.             $listeTypeProducts[$type_index]["types"] = $typesorder["sort"];
  784.             $listeTypeProducts[$type_index]["type"] = $typesorder["type"];
  785.             $listeTypeProducts[$type_index]["type_slug"] = $typesorder["type_slug"];
  786.             $listeTypeProducts[$type_index]["title"] = $typesorder["title"];
  787.             $listeTypeProducts[$type_index]["show"] = $typesorder["show"];
  788.             foreach ($typesorder["sort"] as $typeorder) {
  789.                 if (isset($datas["types"][$typeorder]) && !empty($datas["types"][$typeorder])) {
  791.                     foreach ($datas["types"][$typeorder] as $product_id) {
  792.                         if (empty($datas["products"][$product_id]["tags"]) || in_array(ApiController::TAG_MENU_ITEM, $datas["products"][$product_id]["tags"])) {
  793.                             continue;
  794.                         }
  795.                         // obliger d avoir l offre particulier
  796.                         if(in_array(ApiController::TAG_OFFRE_PARTICULIER, $datas["products"][$product_id]["tags"])) {
  797.                             $listeTypeProducts[$type_index]["products"][$product_id] = $datas["products"][$product_id];
  798.                             $cptProduct++;
  799.                         }
  800.                     }
  801.                 }
  802.             }
  803.             $listeTypeProducts[$type_index]["total"] =   $cptProduct;
  804.         }
  808.         return $this->renderHtml('page/products.html.twig', [
  809.             'tag_particulier'=>ApiController::TAG_OFFRE_PARTICULIER,
  810.             'vendors' => $vendors,
  811.             'daysWeekMin' => $daysWeekMin,
  812.             'daysWeek' => $daysWeek,
  813.             'timesSlot' => $timesSlot,
  814.             'intervalsSlot' => $intervalsSlot,
  815.             'allergens' => $allergens,
  816.             'menuItems' => $datas["products"],
  817.             'types_products' => $listeTypeProducts
  818.         ]);
  819.     }
  821.     /**
  822.      * @Route("/mes_jours_d_ouvertures", name="disponibility")
  823.      * @param UserRepository $userRepository
  824.      * @return Response
  825.      */
  826.     public function disponibility(UserRepository $userRepository):Response
  827.     {
  829.         //prepare dossier temporaire pour les updload image
  830.         $directoryTmp = $this->getParameter("upload_tmp");
  831.         if (!is_dir($directoryTmp)) {
  832.             mkdir($directoryTmp);
  833.         }
  835.         $directoryTmpVendor = $directoryTmp . ApiController::strToHandle($this->user_vendor) . '/';
  837.         if (is_dir($directoryTmp)) {
  838.             $this->deleteDirectory($directoryTmpVendor);
  839.         }
  840.         $responseJson = $this->forward(ApiController::class . '::getSettings', ["type" => "allergens"]);
  842.         $vendors = $userRepository->getVendors();
  845.         $daysWeek = ["Lundi", "Mardi", "Mercredi", "Jeudi", "Vendredi", "Samedi", "Dimanche"];
  846.         $daysWeekMin = ["Lu", "Ma", "Me", "Je", "Ve", "Sa", "Di"];
  848.         //TODO reflechir a gerer les horaires par une base de donnée en postgre pour des configs special pour ic_configs (label,value)?
  849.         $timesSlot = ["10h - 12h", "12h - 14h", "14h - 16h", "16h - 18h", "18h - 20h"];//, "20h - 22h"
  850.         $intervalToString = [
  851.             "10-11" => "10h - 12h",
  852.             "12-13" => "12h - 14h",
  853.             "14-15" => "14h - 16h",
  854.             "16-17" => "16h - 18h",
  855.             "18-19" => "18h - 20h"
  856.         ];
  857.         /*,"20-21" => "20h - 22h"*/
  858.         //INFO liste interval autoriser pour la page des disponiblités
  859.         $intervalsSlot = [[10, 11], [12, 13], [14, 15], [16, 17], [18, 19]];//, [20, 21]
  862.         //recuperer les produits avec le json de apiController
  863.         $responseJson = $this->forward(ApiController::class . '::getProducts');
  864.         $datas = json_decode($responseJson->getContent(), true);
  866.         // $types = json_decode($this->forward(ApiController::class . '::getCategories')->getContent(), true);
  867.         $types = ApiController::getTypes();
  869.         //supprimer les produits autres
  870.         $types = array_filter($types, function ($element) {
  871.             return ($element["code"] != "XX" && $element["code"] != "09");
  872.         });
  874.         if (!isset($datas["products"])) {
  875.             $datas["products"] = [];
  876.         }
  878.         //preparer de l arborescence pour generer un tableau pour le formulaire
  879.         $disponibility = [];
  881.         if (isset($datas["disponibilities"]) && !empty($datas["disponibilities"])) {
  882.             foreach ($datas["disponibilities"] as $type => $dispoDays) {
  883.                 foreach ($intervalsSlot as $intervalSlot) {
  884.                     foreach ($daysWeek as $day) {
  885.                         $index_interval = join("-", $intervalSlot);
  887.                         if (isset($dispoDays[$day]) && !empty($dispoDays[$day])) {
  888.                             $dispoHours = $dispoDays[$day]["hours"];
  889.                             if(isset( $dispoHours) && !empty( $dispoHours)){
  890.                                 foreach ($dispoHours as $hour) {
  891.                                     if (intVal($hour) >= $intervalSlot[0]  && intVal($hour) < $intervalSlot[1] || intVal($hour) == $intervalSlot[1] ) {
  892.                                         // $disponibility[$type][$keyTimeSlot][$keyDay]["status"]  = true;
  893.                                         $disponibility[$day][$index_interval][$type] = true;
  894.                                     } else {
  895.                                         if (!isset($disponibility[$day][$index_interval][$type])) {
  896.                                             // $disponibility[$type][$keyTimeSlot][$keyDay]["status"] = false;
  897.                                             $disponibility[$day][$index_interval][$type] = false;
  898.                                         }
  899.                                     }
  900.                                 }
  901.                             }else{
  902.                                 $disponibility[$day][$index_interval][$type] = false;
  903.                             }
  904.                         } else {
  905.                             $disponibility[$day][$index_interval][$type]  = false;
  906.                         }
  907.                     }
  908.                 }
  909.             }
  910.         }
  912.         return $this->renderHtml('page/disponibilities.html.twig', [
  913.             'vendors' => $vendors,
  914.             'daysWeekMin' => $daysWeekMin,
  915.             'daysWeek' => $daysWeek,
  916.             'timesSlot' => $timesSlot,
  917.             'intervalToString' => $intervalToString,
  918.             'disponibility' => $disponibility
  919.         ]);
  920.     }
  922.     /**
  923.      * @Route("/mes_menus_et_mes_cartes/edit/{id?}", name="product_edit")
  924.      * @param null $id
  925.      * @param UserRepository $userRepository
  926.      * @return Response
  927.      */
  928.     public function productForm($id = null, UserRepository $userRepository):Response
  929.     {
  930.         if(in_array(User::ROLE_USER_OPS,$this->user->getRoles())){
  931.             return $this->redirectToRoute("home");
  932.         }
  933.         $directoryTmp = $this->getParameter("upload_tmp");
  934.         if (!is_dir($directoryTmp)) {
  935.             mkdir($directoryTmp);
  936.         }
  937.         $directoryTmpVendor = $directoryTmp . ApiController::strToHandle($this->user_vendor) . '/';
  938.         if (is_dir($directoryTmp)) {
  939.             $this->deleteDirectory($directoryTmpVendor);
  940.         }
  943.         $title_page = "Ajouter un produit";
  944.         $theme = $_GET["t"] ?? "autre-article";
  945.         $typesProductOrder = [
  946.             "add" => "Ajouter un produit",
  947.             "menu" => "ajouter un menu",
  948.             "a-la-carte" => "ajouter un produit à la carte",
  949.             "entree" => "ajouter un produit à la carte",
  950.             "plat" => "ajouter un produit à la carte",
  951.             "dessert" => "ajouter un produit à la carte",
  952.             "a-partager" => "ajouter un produit à partager",
  953.             "autre-article" => "ajouter un produit",
  954.             "boissons-alcoolise" => "ajouter un vin, sipiritueux et autre alcool",
  955.             "boissons-non-alcoolise" => "ajouter une boisson non alcoolisée"
  956.         ];
  958.         //recuperer les produits avec le json de apiController
  959.         $responseJson = $this->forward(ApiController::class . '::getProducts');
  960.         $datas = json_decode($responseJson->getContent(), true);
  961.         $types = ApiController::getTypes();
  963.         $menu_items = [];
  964.         if (is_null($id) || !isset($datas["products"][$id]) || empty($datas["products"][$id])) {
  965.             if ($theme != "a-la-carte") {
  966.                 $types_selected = array_filter($types, function ($type) use ($theme) {
  967.                     return $type["slug"] ==  $theme;
  968.                 });
  969.                 $types_selected = array_shift($types_selected);
  970.             }
  971.             $product = ["id" => "Add","title" => "","disponibility_dates" => "","max_per_day" => "","price" => "","type" =>   $types_selected["type"] ?? "","allergens" => "","pack" => [],"description" => ""];
  972.             $title_page =  $typesProductOrder[$theme];
  973.         } else {
  974.             $product = $datas["products"][$id];
  975.             $product["allergens"] = array_unique($product["allergens"]);
  977.             $list_menu_items = isset($datas["menu_item"]) && !empty($datas["menu_item"]) ? $datas["menu_item"] : [];
  978.             $menu_items = array_filter(
  979.                 $datas["products"],
  980.                 function ($prod) use ($list_menu_items) {
  981.                     return in_array($prod["id"], $list_menu_items);
  982.                 }
  983.             );
  985.             $title_page =   $typesProductOrder[$product["type_slug"]] ?? $title_page;
  986.             $theme = $product["type_slug"];
  987.         }
  989.         $types_theme = [];
  990.         switch ($theme){
  991.             case "a-la-carte":
  992.                 $types_theme = array_filter($types, function ($type) {
  993.                     return $type["slug"] == "a-la-carte";
  994.                 });
  995.                 break;
  996.             case "boissons-alcoolise":
  997.                 $types_theme = array_filter($types, function ($type) {
  998.                     return $type["slug"] == "boissons-alcoolise";
  999.                 });
  1001.                 break;
  1002.             case "boissons-non-alcoolise":
  1003.                 $types_theme = array_filter($types, function ($type) {
  1004.                     return $type["slug"] == "boissons-non-alcoolise";
  1005.                 });
  1006.                 break;
  1007.             case "autre-article":
  1008.                 $types_theme = $types;
  1009.                 break;
  1010.         }
  1012.         $types_menuitem = ["Entrée","Plat","Dessert","A partager","Autre boisson alcoolisée","Bière","Champagne et bulle","Cocktail","Vin blanc","Vin rosé","Vin rouge","Spiritueux","Eau minérale","Soft"];
  1013.         $types_title=["Menu"=>"Nos Menus","A partager"=> "A partager","Entrée"=>"Nos Entrées","Plat"=>"Nos Plats","Dessert"=>"Nos Desserts","Vin blanc"=>"Nos Vins Blancs","Vin rosé"=>"Nos Vins Rosés","Vin rouge"=>"Nos Vins Rouges","Soft"=>"Nos softs et eaux minérales","Eau minérale"=>"Nos softs et eaux minérales","Champagne et bulle"=>"Nos champagnes et bulles","Spiritueux"=>"Nos spiritueux et autres boissons","Bière"=>"Nos spiritueux et autres boissons","Autre boisson alcoolisée"=>"Nos spiritueux et autres boissons","Autre article"=>"Nos autres articles"];
  1015.         //  "Menu"=>"Nos autres articles"
  1016.         return $this->renderHtml('page/product_form.html.twig', [
  1017.             'user' =>  $this->user,
  1018.             'types' =>  $types,
  1019.             'types_theme' => $types_theme,
  1020.             'types_menuitem' => $types_menuitem,
  1021.             'product' =>  $product,
  1022.             'theme' =>  $theme,
  1023.             'title_page' =>  $title_page,
  1024.             'types_title' =>  $types_title,
  1025.             'menu_items' =>  $menu_items
  1026.         ]);
  1027.     }
  1029.     /**
  1030.      * @Route("/mes_menus_et_mes_cartes/update", name="update_product")
  1031.      * @param Request $request
  1032.      * @return RedirectResponse
  1033.      */
  1034.     public function updateProduct(Request $request):RedirectResponse
  1035.     {
  1036.         //Check l autorisation
  1037.         if (!isset($this->user) || empty($this->user)) {
  1038.             return $this->redirectToRoute("app_login");
  1039.         }
  1040.         if(in_array(User::ROLE_USER_OPS,$this->user->getRoles())){
  1041.             return $this->redirectToRoute("home");
  1042.         }
  1044.         //recuperation des informations du formulaire
  1045.         $formDatas = $request->request->all();
  1046.         $formDatas["tags"] = explode("|", $formDatas["tags"]);
  1047.         if (isset($formDatas["allergens"]) && !empty($formDatas["allergens"])) {
  1048.             foreach ($formDatas["allergens"] as $allergen) {
  1049.                 $formDatas["tags"][] = ApiController::TAG_PREFIX_ALLERGEN . $allergen;
  1050.             }
  1051.             unset($formDatas["allergens"]);
  1052.         }
  1053.         // translate dataform shelfs to tags shopify
  1054.         if (isset($formDatas["shelfs"]) && !empty($formDatas["shelfs"])) {
  1055.             foreach ($formDatas["shelfs"] as $shelf) {
  1056.                 $formDatas["tags"][] = ApiController::TAG_PREFIX_SHELF . $shelf;
  1057.             }
  1058.             unset($formDatas["shelfs"]);
  1059.         }
  1060.         // Changer les virgule dans les titre en 2 underscores
  1061.         if (isset($formDatas["title"]) && !empty($formDatas["title"])   && strpos($formDatas["title"],",")!==-1) {
  1062.             $formDatas["title"]= str_replace(",","__",$formDatas["title"]);
  1063.         }
  1065.         //init variable
  1066.         $reps = [];
  1067.         //si pack existe
  1068.         $pack_tags = [];
  1069.         $packsDel=[];
  1070.         $post_menu_item = [];
  1071.         //si pack existe
  1072.         if (isset($formDatas["pack"]) && !empty($formDatas["pack"])) {
  1073.             $oldPack=[];
  1074.             if(isset($formDatas["id"]) && !empty($formDatas["id"])){
  1075.                 $allTagsPackTmp =   $this->controllerApiTiptoque('getTags', ["type" => "pack"]);
  1076.                 if(isset( $allTagsPackTmp[$formDatas["id"]]) && !empty(isset($allTagsPackTmp[$formDatas["id"]]))){
  1077.                     $oldPack= $allTagsPackTmp[$formDatas["id"]];
  1078.                 }
  1079.             }
  1080.             $newPack = array_keys($formDatas["pack"]);
  1081.             $packsDel = array_diff($oldPack,$newPack);
  1082.             foreach ($formDatas["pack"] as $menuItem) {
  1083.                 if(!isset($menuItem["title"])){
  1084.                     continue;
  1085.                 }
  1086.                 $menuItem["tags"][] = ApiController::TAG_MENU_ITEM;
  1087.                 $menuItem["tags"][] = ApiController::TAG_OFFRE_PARTICULIER;
  1088.                 if(isset($formDatas["id"]) && !empty($formDatas["id"])){
  1089.                     $menuItem["tags"][] = ApiController::TAG_PREFIX_MAIN.$formDatas["id"];
  1090.                 }
  1092.                 //si menu_item id ajout du produit dans shopify et mise en place de reps pour le json
  1093.                 if (isset($menuItem["id"]) && !empty($menuItem["id"])) {
  1094.                     $menuItem_id = $menuItem["id"];
  1095.                     $pack_tags[] = ApiController::TAG_PREFIX_PACK . $menuItem["index"] . "|" . $menuItem_id . "_" . $menuItem["handle"];
  1096.                     unset($menuItem["id"]);
  1097.                     $datasJson["product"] = $menuItem;
  1098.                     //TODO faut il verifier si le produit a ete modifier?
  1099.                     $reps[] =  $this->controllerApiTiptoque('putProduct', ["id" => $menuItem_id], json_encode($datasJson));
  1100.                 } else {
  1101.                     $datasJson["product"] = $menuItem;
  1102.                     $resProduit = $this->controllerApiTiptoque('postProduct', [], json_encode($datasJson));
  1103.                     $pack_tags[] = ApiController::TAG_PREFIX_PACK . $menuItem["index"] . "|" . $resProduit["product"]["id"] . "_" . $resProduit["product"]["handle"];
  1104.                     $reps[] = $resProduit;
  1105.                     //variable pour preparer l update avec le tags MAIN|%id product%
  1106.                     $post_menu_item[]=$resProduit["product"];
  1107.                 }
  1108.             }
  1109.             $formDatas["tags"] = array_merge($formDatas["tags"], $pack_tags);
  1110.             unset($formDatas["pack"]);
  1111.         }
  1112.         //preparation des valeur pour le produit principal
  1113.         $formDatas["max_per_day"] = ($formDatas["max_per_day"] == "") ? "-1" : $formDatas["max_per_day"];
  1114.         $formDatas["disponibility_dates"] = $formDatas["dispo_date"];
  1115.         unset($formDatas["dispo_date_start"]);
  1116.         unset($formDatas["dispo_date_end"]);
  1117.         unset($formDatas["put_product"]);
  1118.         if (isset($formDatas["id"]) && !empty($formDatas["id"])) {
  1119.             $pId = $formDatas["id"];
  1120.             unset($formDatas["id"]);
  1121.             $datasJson["product"] = $formDatas;
  1122.             $prodMain  = $reps[] =   $this->controllerApiTiptoque('putProduct', ["id" => $pId], json_encode($datasJson));
  1124.             //info Suppression des menu_items qui sont supprimer
  1125.             if(isset($packsDel) && !empty($packsDel)){
  1126.                 foreach ($packsDel as $packDel){
  1127.                     $this->controllerApiTiptoque('delProduct', ["id" => $packDel, "force" => true]);//
  1128.                 }
  1129.             }
  1131.         } else {
  1132.             $datasJson["product"] = $formDatas;
  1133.             $prodMain  = $reps[] =  $this->controllerApiTiptoque('postProduct', [], json_encode($datasJson));
  1135.             //info update les pack avec le tag MAIN|%id%
  1136.             if (isset($post_menu_item) && !empty($post_menu_item)) {
  1137.                 foreach ($post_menu_item as $menuItem) {
  1138.                     $menuItem["tags"][] = ApiController::TAG_PREFIX_MAIN.$prodMain["product"]["id"];
  1139.                     $datasJson["product"] = $menuItem;
  1140.                     $this->controllerApiTiptoque('putProduct', ["id" => $menuItem["id"]], json_encode($datasJson));
  1141.                 }
  1142.             }
  1143.         }
  1145.         if((strpos(  $prodMain["product"]["type"],"Dispo")===false)){
  1146.             return $this->redirectToRoute("product_edit",["id"=>$prodMain["product"]["id"]]);
  1147.         }else{
  1148.             return $this->redirectToRoute("products");
  1149.         }
  1150.     }
  1152.     /**
  1153.      * @Route("/mes_menus_et_mes_cartes/delete", name="delete_product")
  1154.      * @param Request $request
  1155.      * @return RedirectResponse
  1156.      */
  1157.     public function deleteProduct(Request $request):RedirectResponse
  1158.     {
  1159.         if (!isset($this->user) || empty($this->user)) {
  1160.             return $this->redirectToRoute("app_login");
  1161.         }
  1162.         if(in_array(User::ROLE_USER_OPS,$this->user->getRoles())){
  1163.             return $this->redirectToRoute("home");
  1164.         }
  1165.         $pId = $request->query->get("product_id", null);
  1167.         //info récupérer le produit et verifier si il y a des menus_items pour les supprimer en cascade
  1168.         $responseProduct = $this->controllerApiTiptoque('getProduct',["id"=>$pId]);
  1169.         if(isset($responseProduct["product"]["pack"]) && !empty($responseProduct["product"]["pack"])){
  1170.             foreach ($responseProduct["product"]["pack"] as $menu_item_id){
  1171.                 $this->controllerApiTiptoque("delProduct", ["id" => $menu_item_id, "force" => true]);
  1172.             }
  1173.         }
  1175.         $this->controllerApiTiptoque('delProduct', ["id" => $pId, "force" => true]);
  1176.         return $this->redirectToRoute("products");
  1177.     }
  1179.     /**
  1180.      * @Route("/imageDelete", name="imageDelete")
  1181.      * @param Request $request
  1182.      * @return JsonResponse
  1183.      */
  1184.     public function imageDelete(Request $request):JsonResponse
  1185.     {
  1186.         //supprimer image d'un produit
  1187.         $image_id = $request->request->get("iid");
  1188.         $produit_id = $request->request->get("pid");
  1189.         if (is_numeric($image_id)) {
  1190.             // var_dump("delete image shopify", $produit_id, $image_id);
  1192.             $reponseDeleteImage = $this->controllerApiTiptoque('delImage', ["pid" => $produit_id, "id" => $image_id]);
  1193.             if(is_null($reponseDeleteImage)){
  1194.                 return $this->json(["error"=> ["pid" => $produit_id, "id" => $image_id,"reponse"=>$reponseDeleteImage]], 404 );
  1195.             }
  1196.             return $this->json(["message"=>$reponseDeleteImage], 200);
  1197.             //  return $this->json(["message" => "suppression de image id:" . $image_id], 200);
  1198.         } else {
  1199.             $directoryTmp = $this->getParameter("upload_tmp");
  1200.             $directoryTmpVendor = $directoryTmp . ApiController::strToHandle($this->user_vendor) . '/';
  1201.             $directoryTmpVendorProduct = $directoryTmpVendor . $produit_id . '/';
  1202.             unlink($directoryTmpVendorProduct . $image_id);
  1203.             //si le dossier vide le supprimer ??
  1204.             $countImg = count(scandir($directoryTmpVendorProduct ))-2;
  1205.             if( $countImg === 0){
  1206.                 $this->deleteDirectory( $directoryTmpVendor);
  1207.             }
  1209.             return $this->json(["message" => "suppression de image " . $image_id . " dans le cache"], 200);
  1210.         }
  1211.     }
  1213.     /**
  1214.      * @Route("/file-upload", name="tmpUploadFile")
  1215.      * @param Request $request
  1216.      * @return JsonResponse
  1217.      */
  1218.     public function tmpUploadFile(Request $request):JsonResponse
  1219.     {
  1220.         $produit_id = $request->request->get("pid", null);
  1221.         $produit_id = ($produit_id == "_add" || $produit_id == "Add")  ? "add" : $produit_id;
  1223.         $directoryTmp = $this->getParameter("upload_tmp");
  1224.         if (!is_dir($directoryTmp)) {
  1225.             mkdir($directoryTmp);
  1226.         }
  1227.         $directoryTmpVendor = $directoryTmp . ApiController::strToHandle($this->user_vendor);
  1228.         if (!is_dir($directoryTmpVendor)) {
  1229.             mkdir($directoryTmpVendor);
  1230.         }
  1232.         $directoryTmpVendorProduct = $directoryTmpVendor . '/' . $produit_id;
  1233.         if (!is_dir($directoryTmpVendorProduct)) {
  1234.             mkdir($directoryTmpVendorProduct);
  1235.         }
  1237.         if (is_null($produit_id)) {
  1238.             $produit_id = "add";
  1239.         }
  1240.         $file =  $request->files->get("file");
  1241.         $file->move($directoryTmpVendorProduct,$file->getClientOriginalName());
  1242.         return $this->json(["dir"=> $directoryTmpVendor,"filename" => $file->getClientOriginalName() , "id" => $produit_id], 200);
  1243.     }
  1245.     /**
  1246.      * suppression d'un dossier et ses fichiers
  1247.      * @param $dir
  1248.      * @return bool
  1249.      */
  1250.     private function deleteDirectory($dir):bool
  1251.     {
  1252.         if (!file_exists($dir)) {return true;}
  1253.         if (!is_dir($dir)) { return unlink($dir); }
  1254.         foreach (scandir($dir) as $item) {
  1255.             if ($item == '.' || $item == '..') {
  1256.                 continue;
  1257.             }
  1258.             if (!$this->deleteDirectory($dir . DIRECTORY_SEPARATOR . $item)) {
  1259.                 return false;
  1260.             }
  1261.         }
  1262.         return rmdir($dir);
  1263.     }
  1265.     /**
  1266.      * @param string $function
  1267.      * @param array $path
  1268.      * @param array $datasJson
  1269.      * @return mixed
  1270.      */
  1271.     private function controllerApiTiptoque($function = "getProducts",$path = [],$datasJson = [])
  1272.     {
  1273.         $request = new Request([], [], [], [], [], [], $datasJson);
  1274.         $request->headers->set('content-type', "application/json");
  1275.         $path['_controller'] = ApiController::class . '::' . $function;
  1276.         $subRequest = $request->duplicate([], null, $path);
  1277.         $response = $this->container->get('http_kernel')->handle($subRequest, HttpKernelInterface::SUB_REQUEST);
  1279.         // $response = $this->forward(ApiController::class . '::' . $function, $path);
  1280.         // var_dump($response->getContent());exit();
  1281.         return isset($response) && !empty($response) ? \json_decode($response->getContent(), true) : \json_decode('{"message":"Error not response"}', true);
  1282.     }
  1284.     /**
  1285.      * @param string $entree
  1286.      * @param string $plat
  1287.      * @param string $dessert
  1288.      * @return string
  1289.      */
  1290.     public function menuToDescription(string $entree,string $plat,string $dessert): string
  1291.     {
  1292.         $description = "";
  1293.         if ($entree != "") {
  1294.             $description .= "<entree><span>Entrée :</span> <descr>" . $entree . "</descr></entree><br>";
  1295.         }
  1296.         if ($plat != "") {
  1297.             $description .= "<plat><span>Plat :</span> <descr>" . $plat . "</descr></plat><br>";
  1298.         }
  1299.         if ($dessert != "") {
  1300.             $description .= "<dessert><span>Dessert :</span> <descr>" . $dessert . "</descr></dessert>";
  1301.         }
  1303.         return $description;
  1304.     }
  1305. }