src/Controller/Admin/AdminStoresController.php line 44

  1. <?php
  3. namespace App\Controller\Admin;
  5. use App\Controller\Bootstrap\DefaultSalesHubController;
  6. use App\Entity\Cms;
  7. use App\Entity\Configuration;
  8. use App\Entity\ProductRelation;
  9. use App\Entity\Store;
  10. use App\Entity\SyncLog;
  11. use App\Service\ProductRelationTools;
  12. use App\Utils\Breadcrumb;
  13. use Doctrine\ORM\EntityManagerInterface;
  14. use Doctrine\ORM\Query\Expr\Join;
  15. use Symfony\Component\Form\Extension\Core\Type\CheckboxType;
  16. use Symfony\Component\Form\Extension\Core\Type\ChoiceType;
  17. use Symfony\Component\Form\Extension\Core\Type\IntegerType;
  18. use Symfony\Component\Form\Extension\Core\Type\SubmitType;
  19. use Symfony\Component\Form\Extension\Core\Type\TextType;
  20. use Symfony\Component\HttpFoundation\JsonResponse;
  21. use Symfony\Component\HttpFoundation\Request;
  22. use Symfony\Component\HttpFoundation\Response;
  23. use Symfony\Component\Routing\Annotation\Route;
  24. use App\Service\Prestashop\PrestashopProductManager;
  25. use App\Service\Wordpress\WordpressProductManager;
  26. use App\Service\Shopify\ShopifyProductManager;
  28. class AdminStoresController extends DefaultSalesHubController
  29. {
  30.     public string $page_name = 'Stores';
  31.     public $productRelationTools;
  32.     public const PRESTASHOP_PRODUCT_PER_PAGE = 500;
  33.     public const WORDPRESS_PRODUCT_PER_PAGE = 100; //Wordpress max value is 100
  34.     public const SHOPIFY_PRODUCT_PER_PAGE = 20;
  36.     public function assignBreadcrumb(){
  37.         $this->breadcrumb = [
  38.             (new Breadcrumb('Dashboard', $this->router->generate('dashboard'))),
  39.             (new Breadcrumb('Stores')),
  40.         ];
  41.     }
  43.     #[Route('/admin/stores', name: 'stores')]
  44.     public function index(
  45.         EntityManagerInterface $entityManager,
  46.         Request $request,
  47.         ProductRelationTools $productRelationTools,
  48.         PrestashopProductManager $prestashopProductManager,
  49.         WordpressProductManager $wordpressProductManager,
  50.         ShopifyProductManager $shopifyProductManager
  51.     ): Response
  52.     {
  53.         $this->productRelationTools = $productRelationTools;
  55.         $this->theme->addJsDef([
  56.             'ajax_url' => $this->generateUrl('stores', ['ajax' => 1])
  57.         ]);
  58.         if($request->request->get('ajax') || $request->query->get('ajax')){
  59.             return $this->handleAjax($entityManager, $request, $prestashopProductManager, $wordpressProductManager, $shopifyProductManager);
  60.         }
  62.         if($request->query->has('set_store')){
  63.             return $this->form($entityManager, $request);
  64.         }elseif($request->query->has('set_products')){
  65.             return $this->productsForm($entityManager, $request);
  66.         }elseif($request->query->has('delete_store')){
  67.             $this->deleteEntity($entityManager, $request);
  68.         }
  70.         return $this->listing($entityManager);
  72.     }
  74.     protected function listing(EntityManagerInterface $entityManager){
  75.         $cms = $entityManager->getRepository(Cms::class)->findAll();
  76.         $cmsFilter = [];
  77.         foreach ($cms as $cms_single){
  78.             $cmsFilter[$cms_single->getId()] = $cms_single->getName();
  79.         }
  81.         $datatable = [
  82.             'name' => 'Stores',
  83.             'selector' => 'stores',
  84.             'columns' => [
  85.                 ['display_name' => 'ID', 'data' => 'id', 'name' => 'store.id'],
  86.                 ['display_name' => 'Cms', 'data' => 'cms_name', 'name' => 'cms.name'],
  87.                 ['display_name' => 'Name', 'data' => 'name', 'name' => 'store.name'],
  88.                 ['display_name' => 'Base url', 'data' => 'base_url', 'name' => 'store.base_url'],
  89.                 ['display_name' => 'Extra price amount', 'data' => 'extra_price_amount', 'name' => 'store.extra_price_amount'],
  90.                 ['display_name' => 'Extra price percentage', 'data' => 'extra_price_percentage', 'name' => 'store.extra_price_percentage'],
  91.                 ['display_name' => 'Active', 'data' => 'active', 'name' => 'store.active'],
  92.             ],
  93.             'column_actions' => [
  94.                 [
  95.                     'name' => 'Edit',
  96.                     'url' => $this->generateUrl('stores', ['set_store' => 1, 'id_store' => '__the_id__']),
  97.                 ],
  98.                 [
  99.                     'name' => 'Set Products',
  100.                     'url' => $this->generateUrl('stores', ['set_products' => 1, 'id_store' => '__the_id__']),
  101.                 ],
  102.                 [
  103.                     'name' => 'Delete',
  104.                     'url' => $this->generateUrl('stores', ['delete_store' => 1, 'id_store' => '__the_id__']),
  105.                 ],
  106.             ],
  107.             'filter' => [
  108.                 'field' => 'cms.id',
  109.                 'options' => $cmsFilter
  110.             ],
  111.             'columnDefs' => [
  112.                 [
  113.                     'targets' => 6,
  114.                     'orderable' => false,
  115.                     'render' => [
  116.                         'val_check' => 'active',
  117.                         'if_true' => '<span class="badge py-3 px-4 fs-7 badge-light-success">Active</span>',
  118.                         'if_false' => '<span class="badge py-3 px-4 fs-7 badge-light-danger">Inactive</span>',
  119.                     ]
  120.                 ]
  121.             ]
  123.         ];
  124.         $this->theme->addJavascriptFile('js/custom/utilities/datatables.js');
  125.         $this->theme->addJsDef([
  126.             'datatables' => [
  127.                 $datatable
  128.             ]
  129.         ]);
  131.         $rendered_datatable = $this->render('partials/datatable.html.twig', [
  132.             'datatable' => $datatable,
  133.         ])->getContent();
  136.         return $this->render('pages/stores/index.html.twig', [
  137.             'rendered_datatable' => $rendered_datatable,
  138.             'add_product_url' => $this->generateUrl('stores', ['set_store' => 1]),
  139.         ]);
  140.     }
  142.     protected function form(EntityManagerInterface $entityManager, Request $request)
  143.     {
  144.         $this->theme->addJavascriptFile('js/custom/pages/stores/general.js');
  145.         
  146.         $cms = $entityManager->getRepository(Cms::class)->findAll();
  147.         $cms_choices = [];
  148.         foreach ($cms as $cms_single){
  149.             $cms_choices[$cms_single->getName()] = $cms_single->getId();
  150.         }
  152.         $form = $this->createFormBuilder(null)
  153.             ->add('cms', ChoiceType::class, [
  154.                 'choices' => $cms_choices
  155.             ])
  156.             ->add('name', TextType::class)
  157.             ->add('admin_id_manufacturer', IntegerType::class)
  158.             ->add('admin_id_supplier', IntegerType::class)
  159.             ->add('base_url', TextType::class, [
  160.                 'required' => false,
  161.             ])
  162.             ->add('api_key', TextType::class, [
  163.                 'required' => false,
  164.             ])
  165.             ->add('api_secret', TextType::class, [
  166.                 'required' => false,
  167.             ])
  168.             ->add('extra_price_amount', IntegerType::class)
  169.             ->add('extra_price_percentage', IntegerType::class)
  170.             ->add('active', CheckboxType::class, [
  171.                 'required' => false,
  172.             ])
  173.             ->add('unlimited_stock', CheckboxType::class, [
  174.                 'required' => false,
  175.             ])
  176.             ->add('save', SubmitType::class, ['label' => 'Save'])
  177.             ->getForm();
  179.         $form->handleRequest($request);
  182.         if ($form->isSubmitted() && $form->isValid()) {
  183.             $form_data = $form->getData();
  184.             $id_store = $request->query->get('id_store');
  186.             if($id_store){
  187.                 $storeObj = $entityManager->getRepository(Store::class)->findOneBy(['id' => $id_store]);
  188.             }else{
  189.                 $storeObj = new Store();
  190.             }
  192.             $cmsObj = $entityManager->getRepository(Cms::class)->findOneBy(['id' => $form_data['cms']]);
  193.             $storeObj->setCms($cmsObj);
  194.             $storeObj->setName($form_data['name']);
  195.             $storeObj->setAdminIdManufacturer($form_data['admin_id_manufacturer']);
  196.             $storeObj->setAdminIdSupplier($form_data['admin_id_supplier']);
  197.             $storeObj->setBaseUrl($form_data['base_url']);
  198.             $storeObj->setApiKey((string)$form_data['api_key']);
  199.             $storeObj->setApiSecret((string)$form_data['api_secret']);
  200.             $storeObj->setExtraPriceAmount($form_data['extra_price_amount']);
  201.             $storeObj->setExtraPricePercentage($form_data['extra_price_percentage']);
  202.             $storeObj->setActive($form_data['active']);
  203.             $storeObj->setUnlimitedStock($form_data['unlimited_stock']);
  204.             $entityManager->persist($storeObj);
  205.             $entityManager->flush();
  206.         }else{
  207.             $id_store = $request->query->get('id_store');
  208.             if($id_store){
  209.                 $storeObj = $entityManager->getRepository(Store::class)->findOneBy(['id' => $id_store]);
  210.                 $form->setData([
  211.                     'cms' => ($storeObj->getCms())->getId(),
  212.                     'name' => $storeObj->getName(),
  213.                     'admin_id_manufacturer' => $storeObj->getAdminIdManufacturer(),
  214.                     'admin_id_supplier' => $storeObj->getAdminIdSupplier(),
  215.                     'base_url' => $storeObj->getBaseUrl(),
  216.                     'api_key' => $storeObj->getApiKey(),
  217.                     'api_secret' => $storeObj->getApiSecret(),
  218.                     'extra_price_amount' => $storeObj->getExtraPriceAmount(),
  219.                     'extra_price_percentage' => $storeObj->getExtraPricePercentage(),
  220.                     'active' => $storeObj->isActive(),
  221.                     'unlimited_stock' => $storeObj->isUnlimitedStock(),
  222.                 ]);
  223.             }else{
  224.                 $form->setData([
  225.                     'extra_price_amount' => 0,
  226.                     'extra_price_percentage' => 0,
  227.                 ]);
  228.             }
  229.         }
  231.         return $this->render('pages/stores/form.html.twig', [
  232.             'form' => $form->createView(),
  233.         ]);
  234.     }
  236.     protected function productsForm(EntityManagerInterface $entityManager, Request $request)
  237.     {
  238.         $id_store = $request->query->get('id_store');
  239.         $storeObj = $entityManager->getRepository(Store::class)->findOneBy(['id' => $id_store]);
  240.         $this->theme->addJavascriptFile('js/custom/pages/stores/products_wordpress.js');
  241.         $this->theme->addJsDef([
  242.             'id_store' => $id_store,
  243.             'id_cms' => $storeObj->getCms()->getId()
  244.         ]);
  246.         $datatable = [
  247.             'name' => 'ProductRelations',
  248.             'selector' => 'product_relations_'.$id_store,
  249.             'columns' => [
  250.                 ['display_name' => 'ID', 'data' => 'id', 'name' => 'product_relation.id'],
  251.                 ['display_name' => 'Id product', 'data' => 'id_product', 'name' => 'product_relation.id_product'],
  252.                 ['display_name' => 'Name', 'data' => 'name', 'name' => 'product_relation.name'],
  253.                 ['display_name' => 'Image', 'data' => 'sample_image_url', 'name' => 'product_relation.sample_image_url'],
  254.                 ['display_name' => 'Admin Id product', 'data' => 'admin_id_product', 'name' => 'product_relation.admin_id_product'],
  255.             ],
  256.             'filter' => [],
  257.             'columnDefs' => [
  258.                 [
  259.                     'targets' => 3,
  260.                     'orderable' => false,
  261.                     'render' => [
  262.                         'handle_function' => 'renderProductImage',
  263.                     ]
  264.                 ],
  265.                 [
  266.                     'targets' => 4,
  267.                     'orderable' => false,
  268.                     'render' => [
  269.                         'handle_function' => 'renderAdminIdProduct',
  270.                     ]
  271.                 ]
  272.             ]
  274.         ];
  275.         $this->theme->addJavascriptFile('js/custom/utilities/datatables.js');
  276.         $this->theme->addJsDef([
  277.             'datatables' => [
  278.                 $datatable
  279.             ]
  280.         ]);
  282.         $rendered_datatable = $this->render('partials/datatable.html.twig', [
  283.             'datatable' => $datatable,
  284.         ])->getContent();
  286.         return $this->render('pages/stores/productsForm.html.twig', [
  287.             'rendered_datatable' => $rendered_datatable
  288.         ]);
  289.     }
  291.     protected function deleteEntity(EntityManagerInterface $entityManager, Request $request)
  292.     {
  293.         $id_store = $request->query->get('id_store');
  294.         if($id_store){
  295.             $storeObj = $entityManager->getRepository(Store::class)->findOneBy(['id' => $id_store]);
  296.             $entityManager->remove($storeObj);
  297.             $entityManager->flush();
  298.         }
  299.     }
  302.     public function handleAjax(EntityManagerInterface $entityManager, Request $request, PrestashopProductManager $prestashopProductManager, WordpressProductManager $wordpressProductManager, ShopifyProductManager $shopifyProductManager): JsonResponse
  303.     {
  304.         $ajaxData = json_decode($request->getContent(), true);
  305.         if($draw = $request->query->get('draw')){
  306.             $selector = $request->query->get('selector');
  308.             if($selector && substr($selector, 0, strlen('product_relations')) == 'product_relations'){
  309.                 $id_store = substr($selector, strlen('product_relations_'));
  310.                 return $this->drawProductsForm($entityManager, $request, $id_store);
  311.             }else{
  312.                 return $this->drawListingTable($entityManager, $request, $draw);
  313.             }
  314.         }elseif(isset($ajaxData['ajaxAction']) && $ajaxData['ajaxAction'] == 'loadProducts'){
  315.             return $this->loadProducts($entityManager, $prestashopProductManager, $wordpressProductManager, $shopifyProductManager, $ajaxData['id_store'], $ajaxData['page'], $ajaxData['total_products'], $ajaxData['after']);
  316.         }elseif(isset($ajaxData['ajaxAction']) && $ajaxData['ajaxAction'] == 'saveAdminIdProduct'){
  317.             return $this->saveAdminIdProduct($entityManager, $ajaxData['id_product_relation'], $ajaxData['admin_id_product']);
  318.         }elseif(isset($ajaxData['ajaxAction']) && $ajaxData['ajaxAction'] == 'checkApi'){
  319.             return $this->checkApi($prestashopProductManager, $wordpressProductManager, $shopifyProductManager, $ajaxData['id_cms'], $ajaxData['base_url'], $ajaxData['api_key'], $ajaxData['api_secret']);
  320.         }
  321.     }
  323.     protected function drawListingTable(EntityManagerInterface $entityManager, Request $request, $draw) : JsonResponse
  324.     {
  325.         $options = $request->query->all();
  326.         $order_by = 'id';
  327.         $order_way = 'DESC';
  328.         $where = null;
  329.         $limit = (isset($options['length']) ? $options['length'] : 10);
  330.         $offset = (isset($options['start']) ? $options['start'] : 0);
  332.         if(isset($options['order']) && isset($options['order'][0])){
  333.             $order_by = $options['columns'][$options['order'][0]['column']]['name'];
  334.             $order_way = $options['order'][0]['dir'];
  335.         }
  337.         if(isset($options['search']) && isset($options['search']['value']) && $options['search']['value']){
  338.             $where = $options['search']['value'];
  339.         }
  342.         $query = $entityManager->createQueryBuilder()
  343.             ->select('store')
  344.             ->from('App\Entity\Store', 'store')
  345.             ->leftJoin(
  346.                 'App\Entity\Cms',
  347.                 'cms',
  348.                 Join::WITH,
  349.                 'store.cms = cms.id'
  350.             );
  352.         if($where){
  353.             $query->where($where);
  354.         }
  356.         $stores = $query
  357.             ->orderBy($order_by, $order_way)
  358.             ->setMaxResults($limit)
  359.             ->setFirstResult($offset)
  360.             ->getQuery()
  361.             ->getResult();
  363.         $resultTotal = $entityManager->getRepository(Store::class)->count([]);
  365.         $resultDatatable = [];
  366.         foreach ($stores as $store){
  367.             $this_cms = $store->getCms();
  368.             $this_data = [
  369.                 'id' => $store->getId(),
  370.                 'cms_id' => $this_cms->getId(),
  371.                 'cms_name' => $this_cms->getName(),
  372.                 'name' => $store->getName(),
  373.                 'base_url' => $store->getBaseUrl(),
  374.                 'extra_price_amount' => $store->getExtraPriceAmount(),
  375.                 'extra_price_percentage' => $store->getExtraPricePercentage(),
  376.                 'active' => $store->isActive(),
  377.             ];
  379.             $resultDatatable[] = $this_data;
  380.         }
  381.         return JsonResponse::fromJsonString(json_encode([
  382.             'draw' => $draw,
  383.             'recordsTotal' => $resultTotal,
  384.             'recordsFiltered' => $resultTotal,
  385.             'data' => $resultDatatable
  386.         ]));
  387.     }
  389.     protected function drawProductsForm(EntityManagerInterface $entityManager, Request $request, $id_store) : JsonResponse
  390.     {
  391.         $options = $request->query->all();
  392.         $order_by = 'id';
  393.         $order_way = 'ASC';
  394.         $where = null;
  395.         $limit = (isset($options['length']) ? $options['length'] : 10);
  396.         $offset = (isset($options['start']) ? $options['start'] : 0);
  398.         if(isset($options['order']) && isset($options['order'][0])){
  399.             $order_by = $options['columns'][$options['order'][0]['column']]['name'];
  400.             $order_way = $options['order'][0]['dir'];
  401.         }
  403.         if(isset($options['search']) && isset($options['search']['value']) && $options['search']['value']){
  404.             $where = $options['search']['value'];
  405.         }
  407.         $query = $entityManager->createQueryBuilder()
  408.             ->select('product_relation')
  409.             ->from('App\Entity\ProductRelation', 'product_relation')
  410.             ->where('product_relation.store = '.$id_store.' AND product_relation.deleted = 0');
  412.         if($where){
  413.             $query->where($where);
  414.         }
  416.         $resultTotal = $entityManager->createQueryBuilder()
  417.             ->select('count(product_relation)')
  418.             ->from('App\Entity\ProductRelation', 'product_relation')
  419.             ->where('product_relation.store = '.$id_store.' AND product_relation.deleted = 0')
  420.             ->getQuery()
  421.             ->getSingleScalarResult();
  423.         $productRelations = $query
  424.             ->orderBy($order_by, $order_way)
  425.             ->setMaxResults($limit)
  426.             ->setFirstResult($offset)
  427.             ->getQuery()
  428.             ->getResult();
  430.         $resultDatatable = [];
  431.         foreach ($productRelations as $productRelation){
  432.             $this_data = [
  433.                 'id' => $productRelation->getId(),
  434.                 'id_product' => $productRelation->getIdProduct(),
  435.                 'name' => $productRelation->getName(),
  436.                 'sample_image_url' => $productRelation->getSampleImageUrl(),
  437.                 'admin_id_product' => $productRelation->getAdminIdProduct(),
  438.             ];
  440.             $resultDatatable[] = $this_data;
  441.         }
  442.         return JsonResponse::fromJsonString(json_encode([
  443.             'draw' => $options['draw'],
  444.             'recordsTotal' => $resultTotal,
  445.             'recordsFiltered' => $resultTotal,
  446.             'data' => $resultDatatable
  447.         ]));
  448.     }
  450.     protected function loadProducts(
  451.         EntityManagerInterface $entityManager,
  452.         PrestashopProductManager $prestashopProductManager,
  453.         WordpressProductManager $wordpressProductManager,
  454.         ShopifyProductManager $shopifyProductManager,
  455.         int $id_store,
  456.         int $page,
  457.         $total_products,
  458.         $after
  459.     ) : JsonResponse
  460.     {
  461.         $storeObj = $entityManager->getRepository(Store::class)->findOneBy(['id' => $id_store]);
  462.         $productRelationRepository = $entityManager->getRepository(ProductRelation::class);
  463.         $extra_params = [];
  464.         $products_per_page = 10;
  465.         switch ($storeObj->getCms()->getId()) {
  466.             case Cms::PRESTASHOP_ID:
  467.                 $products_per_page = self::PRESTASHOP_PRODUCT_PER_PAGE;
  468.                 $prestashopProductManager->setExternalApiDataByStore($storeObj);
  469.                 $prestashopProductManager->assignExternalApiData();
  471.                 //First time loaded
  472.                 if(!$total_products){
  473.                     $this->productRelationTools->disableAllProducts($id_store);
  474.                     $total_products = count($prestashopProductManager->getAllProducts());
  475.                 }
  477.                 $prestashopProducts = $prestashopProductManager->getProducts(null, $page, $products_per_page);
  478.                 foreach ($prestashopProducts as $product){
  479.                     $productRelation = $productRelationRepository->findOneBy([
  480.                         'id_product' => $product['id'],
  481.                         'store' => $storeObj->getId(),
  482.                     ]);
  483.                     if(!$productRelation){
  484.                         $productRelation = new ProductRelation();
  485.                         $productRelation->setStore($storeObj);
  486.                         $productRelation->setIdProduct($product['id']);
  487.                         $productRelation->setName(reset($product['name']));
  488.                     }
  490.                     if(!$productRelation->getSampleImageUrl() && $product['images']){
  491.                         $img_url_parts = explode('/', reset($product['images']));
  492.                         $id_image = end($img_url_parts);
  493.                         $image_url = $storeObj->getBaseUrl().'img/p/' . implode('/', str_split($id_image)) . '/' . $id_image . '.jpg';
  494.                         $productRelation->setSampleImageUrl($image_url);
  495.                     }
  497.                     $productRelation->setDeleted(false);
  498.                     $entityManager->persist($productRelation);
  499.                 }
  500.                 $entityManager->flush();
  501.                 break;
  502.             case Cms::WORDPRESS_ID:
  503.                 $products_per_page = self::WORDPRESS_PRODUCT_PER_PAGE;
  504.                 try {
  505.                     $wordpressProductManager->setConnectionByStore($storeObj);
  507.                     //First time loaded
  508.                     if(!$total_products){
  509.                         $this->productRelationTools->disableAllProducts($id_store);
  510.                     }
  512.                     $wordpressResponse = $wordpressProductManager->getProducts($page, $products_per_page, true);
  513.                     foreach ($wordpressResponse['products'] as $product){
  514.                         $productRelation = $productRelationRepository->findOneBy([
  515.                             'id_product' => $product['id'],
  516.                             'store' => $storeObj->getId(),
  517.                         ]);
  518.                         if(!$productRelation){
  519.                             $productRelation = new ProductRelation();
  520.                             $productRelation->setStore($storeObj);
  521.                             $productRelation->setIdProduct($product['id']);
  522.                             $productRelation->setName($product['name']);
  523.                         }
  525.                         if(!$productRelation->getSampleImageUrl() && $product['images']){
  526.                             $productRelation->setSampleImageUrl($product['images'][0]['src']);
  527.                         }
  529.                         $productRelation->setDeleted(false);
  530.                         $entityManager->persist($productRelation);
  531.                     }
  532.                     $entityManager->flush();
  534.                     $total_products = $wordpressResponse['total_products'];
  535.                     break;
  536.                 }catch (\Exception $e){
  537.                     return JsonResponse::fromJsonString(json_encode([
  538.                         'error' => $e->getMessage(),
  539.                     ]));
  540.                 }
  541.             case Cms::SHOPIFY_ID:
  542.                 $products_per_page = self::SHOPIFY_PRODUCT_PER_PAGE;
  543.                 $shopifyProductManager->setConnectionByStore($storeObj);
  545.                 //First time loaded
  546.                 if(!$total_products){
  547.                     $this->productRelationTools->disableAllProducts($id_store);
  548.                     $total_products = count($shopifyProductManager->getAllProductIds());
  549.                 }
  551.                 $response = $shopifyProductManager->getProducts($products_per_page, $after);
  552.                 foreach ($response['products'] as $product){
  553.                     $productRelation = $productRelationRepository->findOneBy([
  554.                         'id_product' => $product['id'],
  555.                         'store' => $storeObj->getId(),
  556.                     ]);
  557.                     if(!$productRelation){
  558.                         $productRelation = new ProductRelation();
  559.                         $productRelation->setStore($storeObj);
  560.                         $productRelation->setIdProduct($product['id']);
  561.                         $productRelation->setName($product['name']);
  562.                     }
  564.                     if(!$productRelation->getSampleImageUrl() && $product['images']){
  565.                         $productRelation->setSampleImageUrl($product['images'][0]);
  566.                     }
  568.                     $productRelation->setDeleted(false);
  569.                     $entityManager->persist($productRelation);
  570.                 }
  571.                 $entityManager->flush();
  573.                 $extra_params['after'] = $response['after'];
  574.                 break;
  575.         }
  577.         $pending_products = 'unknown';
  578.         $percentage_progress = 'unknown';
  579.         $percentage_progress_formatted = 'unknown';
  581.         if(is_integer((int)$total_products) && $total_products){
  582.             $pending_products = $total_products - ($page * $products_per_page);
  583.             $percentage_progress = ($page * $products_per_page) * 100 / $total_products;
  584.             if($pending_products <= 0){
  585.                 $pending_products = 0;
  586.                 $percentage_progress = 100;
  587.             }
  589.             $percentage_progress = round($percentage_progress, 2);
  590.             $percentage_progress_formatted = number_format($percentage_progress, 2, ',', '');
  591.         }
  592.         return JsonResponse::fromJsonString(json_encode([
  593.             'total_products' => $total_products,
  594.             'pending_products' => $pending_products,
  595.             'percentage_progress' => $percentage_progress,
  596.             'percentage_progress_formatted' => $percentage_progress_formatted,
  597.             'id_cms' => $storeObj->getCms()->getId(),
  598.             'extra_params' => $extra_params
  599.         ]));
  600.     }
  602.     protected function saveAdminIdProduct(EntityManagerInterface $entityManager, $id_product_relation, $admin_id_product) : JsonResponse
  603.     {
  604.         if($productRelation = $entityManager->getRepository(ProductRelation::class)->findOneBy(['id' => $id_product_relation])) {
  605.             $productRelation->setAdminIdProduct(($admin_id_product ? $admin_id_product : null));
  606.             $entityManager->persist($productRelation);
  607.             $entityManager->flush();
  608.         }
  610.         return JsonResponse::fromJsonString(json_encode([
  611.             'success' => true,
  612.         ]));
  613.     }
  615.     protected function checkApi(
  616.         PrestashopProductManager $prestashopProductManager,
  617.         WordpressProductManager $wordpressProductManager,
  618.         ShopifyProductManager $shopifyProductManager,
  619.         $id_cms,
  620.         $base_url,
  621.         $api_key,
  622.         $api_secret
  623.     ) : JsonResponse
  624.     {
  626.         switch ($id_cms) {
  627.             case Cms::PRESTASHOP_ID:
  628.                 $prestashopProductManager->prestashop_url = $base_url;
  629.                 $prestashopProductManager->prestashop_apikey = $api_key;
  631.                 try {
  632.                     $prestashopProductManager->checkEndpoints();
  633.                     return JsonResponse::fromJsonString(json_encode([
  634.                         'error' => false,
  635.                     ]));
  636.                 }catch (\Exception $e){
  637.                     return JsonResponse::fromJsonString(json_encode([
  638.                         'error' => $e->getMessage(),
  639.                     ]));
  640.                 }
  641.                 break;
  642.             case Cms::WORDPRESS_ID:
  643.                 $wordpressProductManager->setUrl($base_url);
  644.                 $wordpressProductManager->setApiKey($api_key);
  645.                 $wordpressProductManager->setApiSecret($api_secret);
  647.                 try {
  648.                     $wordpressProductManager->checkEndpoints();
  649.                     return JsonResponse::fromJsonString(json_encode([
  650.                         'error' => false,
  651.                     ]));
  652.                 }catch (\Exception $e){
  653.                     return JsonResponse::fromJsonString(json_encode([
  654.                         'error' => $e->getMessage(),
  655.                     ]));
  656.                 }
  657.                 break;
  658.             case Cms::SHOPIFY_ID:
  659.                 $shopifyProductManager->setUrl($base_url);
  660.                 $shopifyProductManager->setAccessToken($api_key);
  662.                 try {
  663.                     $shopifyProductManager->checkEndpoints();
  664.                     return JsonResponse::fromJsonString(json_encode([
  665.                         'error' => false,
  666.                     ]));
  667.                 }catch (\Exception $e){
  668.                     return JsonResponse::fromJsonString(json_encode([
  669.                         'error' => $e->getMessage(),
  670.                     ]));
  671.                 }
  672.                 break;
  673.         }
  674.     }
  675. }