src/Controller/EsimController.php line 62

Open in your IDE?
  1. <?php
  2. // src/Controller/LuckyController.php
  3. namespace App\Controller;
  5. use Symfony\Component\HttpFoundation\Response;
  6. use Symfony\Component\HttpFoundation\Request;
  7. use Symfony\Component\Routing\Annotation\Route;
  8. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  9. use Symfony\Contracts\Translation\TranslatorInterface;
  10. use Symfony\Component\Validator\Validator\ValidatorInterface;
  11. use Sensio\Bundle\FrameworkExtraBundle\Configuration\IsGranted;
  12. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Method;
  13. use FOS\RestBundle\Request\ParamFetcherInterface;
  14. use FOS\RestBundle\Controller\Annotations\QueryParam;
  16. use Doctrine\ORM\EntityManagerInterface;
  18. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  19. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  20. use PhpOffice\PhpSpreadsheet\IOFactory;
  22. use App\Annotations\IgnoreFilter;
  24. use App\Entity\Esim;
  25. use App\Entity\TugeEsim;
  26. use App\Entity\MovistarEsim;
  27. use App\Entity\AiraloEsim;
  28. use App\Entity\SimPackage;
  29. use App\Entity\Region;
  30. use App\Entity\MovistarEsimCapacity;
  32. use App\Form\EsimType;
  33. use App\Form\MovistarEsimUploadType;
  34. use App\Form\MovistarEsimType;
  36. use App\Logic\TugeLogic;
  37. use App\Logic\AiraloLogic;
  39. class EsimController extends AbstractController
  40. {
  42.     protected $em;
  43.     
  44.     public function __construct(EntityManagerInterface $em){
  45.         $this->em = $em;
  46.     }
  48.     /**
  49.     * @Route({
  50.      *     "en": "/my-esims",
  51.      *     "es": "/esims",
  52.      *     "de": "/meine-esims",
  53.      *     "fr": "/mes-esims",
  54.      *     "it": "/i-miei-esims",
  55.      *     "pt": "/meus-esims",
  56.      *     "cn": "/my-esims_cn",
  57.      *     "cn2": "/my-esims_cn2",
  58.      * }, name="esims_list")
  59.     * @QueryParam(name="history", requirements="true|false", default="false", description="History.")
  60.     * @IsGranted("ROLE_USER")
  61.      */    
  62.     public function index(ParamFetcherInterface $paramFetcher)
  63.     {
  65.         // parameters
  66.         $history = $paramFetcher->get('history') === "true";
  68.         $limit = !$history;
  70.         $repo = $this->em->getRepository(Esim::class);
  71.         $repoTugeEsim = $this->em->getRepository(TugeEsim::class);
  72.         $repoMovistarEsim = $this->em->getRepository(MovistarEsim::class);
  73.         $repoAiraloEsim = $this->em->getRepository(AiraloEsim::class);
  75.         $esims =  $repo->findByUser($this->getUser(), $limit);
  76.         $tugeEsims =  $repoTugeEsim->findByUser($this->getUser(), $limit);
  77.         $movistarEsims =  $repoMovistarEsim->findByUser($this->getUser(), $limit);
  78.         $airaloEsims =  $repoAiraloEsim->findByUser($this->getUser(), $limit);
  80.         // $esims = $repo->includeDeleted(fn ($repo) => $repo->findByUser($this->getUser()));
  82.         $allEsims = array_merge($esims, $tugeEsims, $movistarEsims, $airaloEsims);
  84.         usort($allEsims, function($a, $b) {
  85.             return $a->getPurchaseTransaction()->getTransactedAt() < $b->getPurchaseTransaction()->getTransactedAt();
  86.         });
  89. //     * @IsGranted("ROLE_USER")
  90.         return $this->render('jelly/esims/index.html.twig', [
  91.             'esims' => $allEsims,        
  92.             'history' => $history
  93.         ]);
  95.     }
  98.     /**
  99.     * @Route("/esim/{esimId}", name="esim_detail")
  100.     * @IsGranted("ROLE_USER")
  101.      */    
  102.     public function detail(int $esimId)
  103.     {
  106.         $repoEsim = $this->em->getRepository(Esim::class);
  107.         $repo = $this->em->getRepository(SimPackage::class);
  109.         $esim = $repoEsim->find($esimId);
  111.         if(!$esim)
  112.             throw $this->createNotFoundException('Esim not found');
  114.         if( count($esim->getTransactions()) == 0 || $esim->getTransactions()->first()->getUser()->getId() != $this->getUser()->getId() )
  115.             throw $this->createAccessDeniedException('Esim does not belong to user');
  117.         $simPackages = $repo->findByEsim($esim);
  119.         return $this->render('jelly/esims/detail.html.twig', [
  120.             'simPackages' => $simPackages,        
  121.         ]);
  123.     }
  126.     /**
  127.     * @Route({
  128.      *     "en": "/esim/instructions/{esimId}",
  129.      *     "es": "/esim/instrucciones/{esimId}",
  130.      *     "de": "/esim/anweisungen/{esimId}",
  131.      *     "fr": "/esim/instructions_fr/{esimId}",
  132.      *     "it": "/esim/istruzioni/{esimId}",
  133.      *     "pt": "/esim/instrucoes/{esimId}",
  134.      *     "cn": "/esim/instructions_cn/{esimId}",
  135.      *     "cn2": "/esim/instructions_cn2/{esimId}",
  136.      * }, name="esim_instructions")
  137.      */    
  138.     public function instructions(Request $request, int $esimId)
  139.     {
  142.         $repoEsim = $this->em->getRepository(Esim::class);
  143.         $repo = $this->em->getRepository(SimPackage::class);
  145.         $esim = $repoEsim->find($esimId);
  147.         if(!$esim) {
  148.                 
  149.             $repoEsim = $this->em->getRepository(TugeEsim::class);
  150.             $esim = $repoEsim->find($esimId);
  151.             if ($esim) return $this->redirectToRoute("esim_tuge_instructions", ['esimId' => $esim->getId(), '_locale' => $request->getLocale() ]);
  153.             $repoEsim = $this->em->getRepository(MovistarEsim::class);
  154.             $esim = $repoEsim->find($esimId);
  155.             if ($esim) return $this->redirectToRoute("esim_movistar_instructions", ['esimId' => $esim->getId(), '_locale' => $request->getLocale()]);
  157.             $repoEsim = $this->em->getRepository(AiraloEsim::class);
  158.             $esim = $repoEsim->find($esimId);
  159.             if ($esim) return $this->redirectToRoute("esim_airalo_instructions", ['esimId' => $esim->getId(), '_locale' => $request->getLocale()]);
  161.             throw $this->createNotFoundException('Esim not found');
  164.         }
  166.         if( count($esim->getTransactions()) == 0 || $esim->getTransactions()->first()->getUser()->getId() != $this->getUser()->getId() )
  167.             throw $this->createAccessDeniedException('Esim does not belong to user');
  169.         return $this->render('jelly/esims/instructions.html.twig', [
  170.             'transaction' => $esim->getPurchaseTransaction(),        
  171.         ]);
  173.     }    
  175.     /**
  176.     * @Route({
  177.      *     "en": "/esim/instructions2/{esimId}",
  178.      *     "es": "/esim/instrucciones2/{esimId}",
  179.      *     "de": "/esim/anweisungen2/{esimId}",
  180.      *     "fr": "/esim/instructions2_fr/{esimId}",
  181.      *     "it": "/esim/istruzioni2/{esimId}",
  182.      *     "pt": "/esim/instrucoes2/{esimId}",
  183.      *     "cn": "/esim/instructions2_cn/{esimId}",
  184.      *     "cn2": "/esim/instructions2_cn2/{esimId}",
  185.      * }, name="esim_tuge_instructions")
  186.      */    
  187.     public function instructions2(int $esimId)
  188.     {
  191.         $repoEsim = $this->em->getRepository(TugeEsim::class);
  192.         $repo = $this->em->getRepository(SimPackage::class);
  194.         $esim = $repoEsim->find($esimId);
  196.         if(!$esim)
  197.             throw $this->createNotFoundException('Esim not found');
  199.         if( !$esim->getPurchaseTransaction()  )
  200.             throw $this->createAccessDeniedException('Esim does not belong to user');
  202.         return $this->render('jelly/esims/instructions.html.twig', [
  203.             'transaction' => $esim->getPurchaseTransaction(),        
  204.         ]);
  206.     }    
  208.     /**
  209.     * @Route({
  210.      *     "en": "/esim/instructions3/{esimId}",
  211.      *     "es": "/esim/instrucciones3/{esimId}",
  212.      *     "de": "/esim/anweisungen3/{esimId}",
  213.      *     "fr": "/esim/instructions3_fr/{esimId}",
  214.      *     "it": "/esim/istruzioni3/{esimId}",
  215.      *     "pt": "/esim/instrucoes3/{esimId}",
  216.      *     "cn": "/esim/instructions3_cn/{esimId}",
  217.      *     "cn2": "/esim/instructions3_cn2/{esimId}",
  218.      * }, name="esim_movistar_instructions")
  219.      */    
  220.     public function instructions3(int $esimId)
  221.     {
  224.         $repoEsim = $this->em->getRepository(MovistarEsim::class);
  226.         $esim = $repoEsim->find($esimId);
  228.         if(!$esim)
  229.             throw $this->createNotFoundException('Esim not found');
  231.         if( !$esim->getPurchaseTransaction() )
  232.             throw $this->createAccessDeniedException('Esim does not belong to user');
  234.         return $this->render('jelly/esims/instructions.html.twig', [
  235.             'transaction' => $esim->getPurchaseTransaction(),        
  236.         ]);
  238.     }    
  240.     /**
  241.     * @Route({
  242.      *     "en": "/esim/instructions4/{esimId}",
  243.      *     "es": "/esim/instrucciones4/{esimId}",
  244.      *     "de": "/esim/anweisungen4/{esimId}",
  245.      *     "fr": "/esim/instructions4_fr/{esimId}",
  246.      *     "it": "/esim/istruzioni4/{esimId}",
  247.      *     "pt": "/esim/instrucoes4/{esimId}",
  248.      *     "cn": "/esim/instructions4_cn/{esimId}",
  249.      *     "cn2": "/esim/instructions4_cn2/{esimId}",
  250.      * }, name="esim_airalo_instructions")
  251.      */    
  252.     public function instructions4(int $esimId)
  253.     {
  256.         $repoEsim = $this->em->getRepository(AiraloEsim::class);
  258.         $esim = $repoEsim->find($esimId);
  260.         if(!$esim)
  261.             throw $this->createNotFoundException('Esim not found');
  263.         if( !$esim->getPurchaseTransaction() )
  264.             throw $this->createAccessDeniedException('Esim does not belong to user');
  266.         return $this->render('jelly/esims/instructions.html.twig', [
  267.             'transaction' => $esim->getPurchaseTransaction(),        
  268.         ]);
  270.     }    
  272.     /**
  273.     * @Route("/admin/esims", name="esims_admin_list")
  274.      * @QueryParam(name="page", requirements="\d+", default=1, description="Page number.")
  275.      * @QueryParam(name="sort", requirements="e.iccid|u.lastName|r.descriptionEs|e.createdAt", description="Sort.")
  276.      * @QueryParam(name="dir", requirements="asc|desc", default="asc", description="Sort direction.")         
  277.      * @QueryParam(name="iccid", requirements=".*", default="", nullable=true, description="Iccid.")         
  278.     * @IsGranted("ROLE_ADMIN")
  279.      */    
  280.     public function adminIndex(Request $request, ParamFetcherInterface $paramFetcher)
  281.     {
  284.         // parameters
  285.         $page = $paramFetcher->get('page');
  286.         $sort = $paramFetcher->get('sort');
  287.         $dir = $paramFetcher->get('dir');
  288.         $iccid = $paramFetcher->get('iccid');
  289.         $download = $request->query->get('download');    
  291.         // query
  292.         $results_per_page = $this->getParameter('app.results_per_page');        
  294.         // filters
  295.         $currentFilters = [];
  297.         if($sort){
  298.             $currentFilters['sort'] = $sort;
  299.             $currentFilters['dir'] = $dir;          
  300.         } 
  301.         if($iccid){
  302.             $currentFilters['iccid'] = $iccid;
  303.         }        
  305.         $repo = $this->em->getRepository(Esim::class);
  307.         $form = $this->createForm(EsimType::class);
  308.         $form->handleRequest($request);
  310.         if ($form->isSubmitted() && $form->isValid()) {
  312.             $region = $form->get('region')->getData();
  313.             $file = $form->get('file')->get('file')->getData();
  315.             if ($file) {
  316.                 $this->uploadExcel($region, $file->getRealPath());
  317.             }
  319.         }
  321.         $esims = $repo->getList($sort, $dir, $page, $results_per_page, $iccid, $download);
  323.         if($download == '1')
  324.             return $this->downloadExcel($esims);
  326.         $totalPages = ceil(count($esims) / $results_per_page);
  327.         
  329. //     * @IsGranted("ROLE_USER")
  330.         return $this->render('angle/esims/index.html.twig', [
  331.             'esims' => $esims,        
  332.             'page' => $page,
  333.             'totalPages' => $totalPages,
  334.             'totalResults' =>  count($esims),            
  335.             'currentFilters' => $currentFilters,
  336.             'results_per_page' => $results_per_page,
  337.             'iccid' => $iccid,
  338.             'form' => $form->createView(),
  339.             'regions' => $this->em->getRepository(Region::class)->findBy([], ['descriptionEs' => 'ASC']), 
  341.         ]);
  343.     }    
  345.     /**
  346.     * @Route("/admin/tuge-esims", name="esims_tuge_admin_list")
  347.      * @QueryParam(name="page", requirements="\d+", default=1, description="Page number.")
  348.      * @QueryParam(name="sort", requirements="e.iccid|u.lastName|r.descriptionEs|e.createdAt|e.bytesConsumed", description="Sort.")
  349.      * @QueryParam(name="dir", requirements="asc|desc", default="asc", description="Sort direction.")         
  350.      * @QueryParam(name="iccid", requirements=".*", default="", nullable=true, description="Iccid.")         
  351.     * @IsGranted("ROLE_AGENT")
  352.     * @IgnoreFilter(filter="softdeleteable", forClasses={"App\Entity\User"})* 
  353.      */    
  354.     public function adminTugeIndex(Request $request, ParamFetcherInterface $paramFetcher)
  355.     {
  358.         // parameters
  359.         $page = $paramFetcher->get('page');
  360.         $sort = $paramFetcher->get('sort');
  361.         $dir = $paramFetcher->get('dir');
  362.         $iccid = $paramFetcher->get('iccid');
  363.         $download = $request->query->get('download');    
  365.         // query
  366.         $results_per_page = $this->getParameter('app.results_per_page');        
  368.         // filters
  369.         $currentFilters = [];
  371.         if($sort){
  372.             $currentFilters['sort'] = $sort;
  373.             $currentFilters['dir'] = $dir;          
  374.         } 
  375.         if($iccid){
  376.             $currentFilters['iccid'] = $iccid;
  377.         }        
  379.         $repo = $this->em->getRepository(TugeEsim::class);
  381.         $esims = $repo->getList($sort, $dir, $page, $results_per_page, $iccid, $download);
  383.         if($download == '1')
  384.             return $this->downloadExcel($esims);
  386.         $totalPages = ceil(count($esims) / $results_per_page);
  387.         
  389. //     * @IsGranted("ROLE_USER")
  390.         return $this->render('angle/esims/index_tuge.html.twig', [
  391.             'esims' => $esims,        
  392.             'page' => $page,
  393.             'totalPages' => $totalPages,
  394.             'totalResults' =>  count($esims),            
  395.             'currentFilters' => $currentFilters,
  396.             'results_per_page' => $results_per_page,
  397.             'iccid' => $iccid,
  399.         ]);
  401.     }        
  403.     /**
  404.     * @Route("/admin/movistar-esims", name="esims_movistar_admin_list")
  405.      * @QueryParam(name="page", requirements="\d+", default=1, description="Page number.")
  406.      * @QueryParam(name="sort", requirements="mec.amountGb|u.lastName|e.createdAt|t.createdAt", description="Sort.")
  407.      * @QueryParam(name="dir", requirements="asc|desc", default="asc", description="Sort direction.")         
  408.     * @IsGranted("ROLE_ADMIN")
  409.     * @IgnoreFilter(filter="softdeleteable", forClasses={"App\Entity\User"})* 
  410.      */    
  411.     public function adminMovistarIndex(Request $request, ParamFetcherInterface $paramFetcher)
  412.     {
  415.         // parameters
  416.         $page = $paramFetcher->get('page');
  417.         $sort = $paramFetcher->get('sort');
  418.         $dir = $paramFetcher->get('dir');
  419.         $download = $request->query->get('download');    
  421.         // query
  422.         $results_per_page = $this->getParameter('app.results_per_page');        
  424.         // filters
  425.         $currentFilters = [];
  427.         if($sort){
  428.             $currentFilters['sort'] = $sort;
  429.             $currentFilters['dir'] = $dir;          
  430.         } 
  432.         $download = $request->query->get('download');    
  434.         $repo = $this->em->getRepository(MovistarEsim::class);
  436.         $form = $this->createForm(MovistarEsimUploadType::class);
  437.         $form->handleRequest($request);
  439.         if ($form->isSubmitted() && $form->isValid()) {
  441.             $region = $form->get('region')->getData();
  442.             $file = $form->get('file')->get('file')->getData();
  444.             if ($file) {
  445.                 $this->uploadExcel2($region, $file->getRealPath());
  446.             }
  448.         }
  450.         $esims = $repo->getList($sort, $dir, $page, $results_per_page, $download);
  452.         if($download == '1')
  453.             return $this->downloadExcel2($esims);
  455.         $totalPages = ceil(count($esims) / $results_per_page);        
  457. //     * @IsGranted("ROLE_USER")
  458.         return $this->render('angle/esims/index_movistar.html.twig', [
  459.             'esims' => $esims,        
  460.             'page' => $page,
  461.             'totalPages' => $totalPages,
  462.             'totalResults' =>  count($esims),            
  463.             'currentFilters' => $currentFilters,
  464.             'results_per_page' => $results_per_page,
  465.             'form' => $form->createView(),
  467.         ]);
  469.     }        
  471.     /**
  472.     * @Route("/admin/movistar-esim/{esimId}", name="esims_movistar_admin_detail")
  473.     * @IsGranted("ROLE_ADMIN")
  474.     * @IgnoreFilter(filter="softdeleteable", forClasses={"App\Entity\User"})* 
  475.      */    
  476.     public function adminMovistarDetail(Request $request, string $esimId)
  477.     {
  479.         $repo = $this->em->getRepository(MovistarEsim::class);
  481.         $esim = $repo->find($esimId);
  483.         if(!$esim)
  484.             throw $this->createNotFoundException('Esim not found');
  486.         $form = $this->createForm(MovistarEsimType::class, $esim);
  487.         $form->handleRequest($request);
  489.         if ($form->isSubmitted() && $form->isValid()) {
  490.             $esim = $form->getData();
  491.             $this->em->persist($esim);
  492.             $this->em->flush();
  494.             return $this->redirectToRoute('esims_movistar_admin_list');
  496.         }
  498.         return $this->render('angle/esims/detail_movistar.html.twig', [
  499.             'esim' => $esim,        
  500.             'form' => $form->createView(),
  502.         ]);
  504.     }        
  506.     /**
  507.     * @Route("/admin/airalo-esims", name="esims_airalo_admin_list")
  508.      * @QueryParam(name="page", requirements="\d+", default=1, description="Page number.")
  509.      * @QueryParam(name="sort", requirements="e.iccid|u.lastName|r.descriptionEs|e.createdAt|e.bytesConsumed", description="Sort.")
  510.      * @QueryParam(name="dir", requirements="asc|desc", default="asc", description="Sort direction.")         
  511.      * @QueryParam(name="iccid", requirements=".*", default="", nullable=true, description="Iccid.")         
  512.     * @IsGranted("ROLE_AGENT")
  513.     * @IgnoreFilter(filter="softdeleteable", forClasses={"App\Entity\User"})* 
  514.      */    
  515.     public function adminAiraloIndex(Request $request, ParamFetcherInterface $paramFetcher)
  516.     {
  519.         // parameters
  520.         $page = $paramFetcher->get('page');
  521.         $sort = $paramFetcher->get('sort');
  522.         $dir = $paramFetcher->get('dir');
  523.         $iccid = $paramFetcher->get('iccid');
  524.         $download = $request->query->get('download');    
  526.         // query
  527.         $results_per_page = $this->getParameter('app.results_per_page');        
  529.         // filters
  530.         $currentFilters = [];
  532.         if($sort){
  533.             $currentFilters['sort'] = $sort;
  534.             $currentFilters['dir'] = $dir;          
  535.         } 
  536.         if($iccid){
  537.             $currentFilters['iccid'] = $iccid;
  538.         }        
  540.         $repo = $this->em->getRepository(AiraloEsim::class);
  542.         $esims = $repo->getList($sort, $dir, $page, $results_per_page, $iccid, $download);
  544.         if($download == '1')
  545.             return $this->downloadExcel($esims);
  547.         $totalPages = ceil(count($esims) / $results_per_page);
  548.         
  550. //     * @IsGranted("ROLE_USER")
  551.         return $this->render('angle/esims/index_airalo.html.twig', [
  552.             'esims' => $esims,        
  553.             'page' => $page,
  554.             'totalPages' => $totalPages,
  555.             'totalResults' =>  count($esims),            
  556.             'currentFilters' => $currentFilters,
  557.             'results_per_page' => $results_per_page,
  558.             'iccid' => $iccid,
  560.         ]);
  562.     }          
  564.      /**
  565.      * @IsGranted("ROLE_ADMIN")     
  566.      * @Route(
  567.      *    "/services/esim/assign_region.{_format}", 
  568.      *     name="esim_region_assign",
  569.      *     requirements={
  570.      *         "_format": "json"
  571.      *     },
  572.      *     methods={"GET"}
  573.      * )
  574.      */
  575.     public function assignRegion(Request $request)
  576.     {        
  577.      
  578.         $repo = $this->getDoctrine()->getRepository(Region::class);
  579.         $repoEsims = $this->getDoctrine()->getRepository(Esim::class);
  581.         $ids = $request->query->get('id');
  582.         $regionId = urldecode($request->query->get('region_id'));
  583.     
  584.         $region = $repo->find($regionId);
  586.         $idsArray =  explode(",", $ids);
  587.         
  588.         foreach($idsArray as $id) if($id){
  589.             if ($esim = $repoEsims->findOneById($id) ){
  591.                 $esim->setRegion($region);    
  593.                 $this->em->flush();
  594.                 
  595.             }
  598.         }
  601.         return ['ok' => true];
  603.     }        
  604.    
  606.     private function uploadExcel($region, $filename){
  608.         $em = $this->getDoctrine()->getManager();
  609.         $repo = $em->getRepository(Esim::class);
  611.         $spreadsheet = IOFactory::load($filename);
  613.         $sheet = $spreadsheet->getActiveSheet();
  615.         $rowCount = 2;
  616.         while (!empty($sheet->getCell("A$rowCount")->getValue())) {
  618.             $iccid = trim((string) $sheet->getCell("A$rowCount")->getValue());
  619.             $qrCode = trim((string) $sheet->getCell("D$rowCount")->getValue());
  621.             $existingDevice = $repo->findOneBy(['iccid' => $iccid]);
  623.             if($existingDevice){
  624.                 $rowCount++;
  625.                 continue;
  626.             }
  628.             $esim = new Esim();
  629.             $esim->setRegion($region);
  630.             $esim->setIccid($iccid);
  631.             $esim->setQrCode($qrCode);
  633.             $em->persist($esim);
  635.             $rowCount++;
  636.         }        
  638.         $em->flush();
  641.     }    
  644.     private function uploadExcel2($region, $filename){
  646.         $em = $this->getDoctrine()->getManager();
  647.         $repo = $em->getRepository(MovistarEsim::class);
  648.         $repoCapacity = $em->getRepository(MovistarEsimCapacity::class);
  650.         $spreadsheet = IOFactory::load($filename);
  652.         $sheet = $spreadsheet->getActiveSheet();
  654.         $rowCount = 2;
  655.         while (!empty($sheet->getCell("A$rowCount")->getValue())) {
  657.             $phoneNumber = trim((string) $sheet->getCell("A$rowCount")->getValue());
  658.             $amountGb = trim((string) $sheet->getCell("B$rowCount")->getValue());
  659.             $qrCode = trim((string) $sheet->getCell("C$rowCount")->getValue());
  661.             $existingDevice = $repo->findOneBy(['phoneNumber' => $phoneNumber]);
  663.             if($existingDevice){
  664.                 $rowCount++;
  665.                 continue;
  666.             }
  668.             $capacity = $repoCapacity->findOneBy(['amountGb' => $amountGb]);
  670.             if(!$capacity){
  671.                 $rowCount++;
  672.                 continue;
  673.             }
  675.             $esim = new MovistarEsim();
  676.             $esim->setRegion($region);
  677.             $esim->setPhoneNumber($phoneNumber);
  678.             $esim->setMovistarEsimCapacity($capacity);
  679.             $esim->setQrCode($qrCode);
  681.             $em->persist($esim);
  683.             $rowCount++;
  684.         }        
  686.         $em->flush();
  689.     }    
  691.     private $col = -1;
  693.     private function getCell($row, $forward = true) {
  695.          $cols = [ 'A' , 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', 'AA', 'AB', 'AC', 'AD', 'AE', 'AF', 'AG', 'AH', 'AI',' AJ', 'AK', 'AL', 'AM', 'AN', 'AO', 'AP', 'AQ', 'AR', 'AS', 'AT', 'AU', 'AV', 'AW', 'AX', 'AY', 'AZ'];
  697.         if( $forward )
  698.             $this->col++;
  700.         return (String) ($cols[$this->col] . $row); 
  702.     }
  704.     private function getColumnindex($forward = true) {
  706.         if( $forward )
  707.             $this->col++;
  709.         return $this->col;
  711.     }
  714.     private function resetCol() {
  715.         $this->col = -1;
  716.     }
  719.     private function downloadExcel($stats){
  721.         ini_set('memory_limit', '512M');
  722.         set_time_limit(0);
  724.        
  725.        $spreadsheet = new Spreadsheet();
  726.         $spreadsheet->getProperties()
  727.             ->setCreator("Blink+")
  728.             ->setLastModifiedBy("Blink+")
  729.             ->setTitle("beconnected esims")
  730.             ->setSubject("beconnected esims")
  731.             ->setDescription(
  732.                 "beconnected esims"
  733.             );
  734.        
  735.        $sheet = $spreadsheet->getActiveSheet();
  737.        $sheet->setCellValue($this->getCell(1, true), 'Esim');
  738.        $sheet->setCellValue($this->getCell(1, true), 'Nombre');
  739.        $sheet->setCellValue($this->getCell(1, true), 'Fecha creación');
  740.         
  741.        $row = 2;
  742.        foreach($stats as $stat){
  744.            $this->resetCol();
  746.            $sheet->setCellValue($this->getCell($row, true), $stat->getIccid());
  747.            $sheet->setCellValue($this->getCell($row, true), $stat->getPurchaseTransaction() ? (  $stat->getPurchaseTransaction()->getUser()->getFirstName() . " " . $stat->getPurchaseTransaction()->getUser()->getLastName() ) : "" );
  748.            $sheet->setCellValue($this->getCell($row, true), $stat->getCreatedAt());
  750.            $row++;
  753.        }
  755.        $writer = new Xlsx($spreadsheet);
  757.        
  758.         header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
  759.         header('Content-Disposition: attachment; filename="'. urlencode("beconnected.xlsx").'"');
  760.         $writer->save('php://output');       
  761.         die();
  763.         return;
  766.     }
  768.     private function downloadExcel2($stats){
  770.         ini_set('memory_limit', '512M');
  771.         set_time_limit(0);
  773.        
  774.        $spreadsheet = new Spreadsheet();
  775.         $spreadsheet->getProperties()
  776.             ->setCreator("Blink+")
  777.             ->setLastModifiedBy("Blink+")
  778.             ->setTitle("beconnected movistar esims")
  779.             ->setSubject("beconnected movistar esims")
  780.             ->setDescription(
  781.                 "beconnected movistar esims"
  782.             );
  783.        
  784.        $sheet = $spreadsheet->getActiveSheet();
  786.        $sheet->setCellValue($this->getCell(1, true), 'Número');
  787.        $sheet->setCellValue($this->getCell(1, true), 'Capacidad');
  788.        $sheet->setCellValue($this->getCell(1, true), 'Nombre');
  789.        $sheet->setCellValue($this->getCell(1, true), 'Fecha creación');
  790.        $sheet->setCellValue($this->getCell(1, true), 'Fecha compra');
  791.        $sheet->setCellValue($this->getCell(1, true), 'Fecha deshabilitación');
  792.         
  793.        $row = 2;
  794.        foreach($stats as $stat){
  796.            $this->resetCol();
  798.            $sheet->setCellValue($this->getCell($row, true), $stat->getPhoneNumber());
  799.            $sheet->setCellValue($this->getCell($row, true), $stat->getMovistarEsimCapacity()->getAmountGb());
  800.            $sheet->setCellValue($this->getCell($row, true), $stat->getPurchaseTransaction() ? (  $stat->getPurchaseTransaction()->getUser()->getFirstName() . " " . $stat->getPurchaseTransaction()->getUser()->getLastName() ) : "" );
  801.            $sheet->setCellValue($this->getCell($row, true), $stat->getCreatedAt());
  802.            $sheet->setCellValue($this->getCell($row, true), $stat->getPurchaseTransaction() ? $stat->getPurchaseTransaction()->getCreatedAt()  : "" );
  803.            $sheet->setCellValue($this->getCell($row, true), $stat->getDeactivatedAt());
  805.            $row++;
  808.        }
  810.        $writer = new Xlsx($spreadsheet);
  812.        
  813.         header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
  814.         header('Content-Disposition: attachment; filename="'. urlencode("beconnected.xlsx").'"');
  815.         $writer->save('php://output');       
  816.         die();
  818.         return;
  821.     }
  823.      /**
  824.      * @IsGranted("ROLE_AGENT")     
  825.      * @Route(
  826.      *    "/services/tuge_esim.{_format}", 
  827.      *     name="service_tuge_esim",
  828.      *     requirements={
  829.      *         "_format": "json"
  830.      *     },
  831.      *     methods={"GET"}
  832.      * )
  833.      */
  834.     public function tugeEsim(Request $request, TugeLogic $tugeLogic)
  835.     {        
  836.      
  837.         $repository = $this->getDoctrine()->getRepository(TugeEsim::class);
  839.         $id = $request->query->get('id');
  840.         if($id){
  841.             $entity = $repository->findOneById($id);
  842.                 
  843.             if($entity)
  844.                 $data = $tugeLogic->queryOrder($entity->getIccid());
  845.             else
  846.                 return ['ok' => false];
  848.             return ['ok' => true, 'order_status' => $data[0]->orderStatus, 'start_date' => $data[0]->startDate , 'end_date' => $data[0]->endDate, 'iccid' => $entity->getIccid() ]            ;
  850.         }
  853.         return ['ok' => false];
  855.     }    
  857.      /**
  858.      * @IsGranted("ROLE_ADMIN")     
  859.      * @Route(
  860.      *    "/services/tuge_esim_refund.{_format}", 
  861.      *     name="service_tuge_esim_refund",
  862.      *     requirements={
  863.      *         "_format": "json"
  864.      *     },
  865.      *     methods={"POST"}
  866.      * )
  867.      */
  868.     public function tugeEsimRefund(Request $request)
  869.     {        
  870.      
  871.         $repository = $this->getDoctrine()->getRepository(TugeEsim::class);
  873.         $id = $request->query->get('id');
  874.         if($id){
  875.             $entity = $repository->findOneById($id);
  876.                 
  877.             if($entity){
  878.                 $entity->setIsRefunded(true);
  879.                 $this->em->flush();
  880.             }
  882.             return true;
  884.         }
  887.         return ['ok' => false];
  889.     }    
  891.      /**
  892.      * @IsGranted("ROLE_ADMIN")     
  893.      * @Route(
  894.      *    "/services/movistar_esim_deactivate.{_format}", 
  895.      *     name="service_movistar_esim_deactivate",
  896.      *     requirements={
  897.      *         "_format": "json"
  898.      *     },
  899.      *     methods={"POST"}
  900.      * )
  901.      */
  902.     public function movistarEsimDeactivate(Request $request)
  903.     {        
  904.      
  905.         $repository = $this->getDoctrine()->getRepository(MovistarEsim::class);
  907.         $id = $request->query->get('id');
  908.         if($id){
  909.             $entity = $repository->findOneById($id);
  910.                 
  911.             if($entity){
  912.                 $entity->setDeactivatedAt(new \DateTimeImmutable);
  913.                 $this->em->flush();
  914.             }
  916.             return true;
  918.         }
  921.         return ['ok' => false];
  923.     }        
  925.      /**
  926.      * @IsGranted("ROLE_AGENT")     
  927.      * @Route(
  928.      *    "/services/airalo_esim.{_format}", 
  929.      *     name="service_airalo_esim",
  930.      *     requirements={
  931.      *         "_format": "json"
  932.      *     },
  933.      *     methods={"GET"}
  934.      * )
  935.      */
  936.     public function airaloEsim(Request $request, AiraloLogic $airaloLogic)
  937.     {        
  938.      
  939.         $repository = $this->getDoctrine()->getRepository(AiraloEsim::class);
  941.         $id = $request->query->get('id');
  942.         if($id){
  943.             $entity = $repository->findOneById($id);
  944.                 
  945.             if($entity)
  946.                 $data = $airaloLogic->fetchDataUsage($entity);
  947.             else
  948.                 return ['ok' => false];
  950.             return ['ok' => true, 'data' => $data['data'] ]            ;
  952.         }
  955.         return ['ok' => false];
  957.     }  
  959. }