1. <?php
2. namespace App\OfficeBrain\Bundle\ProductBundle\Controller;
4. // use Symfony\Bundle\FrameworkBundle\Controller\Controller;
5. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
6. // use Sensio\Bundle\FrameworkExtraBundle\Configuration\Route;
7. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Template;
8. use Symfony\Component\Routing\Annotation\Route;
9. use Symfony\Component\HttpFoundation\JsonResponse;
10. use Symfony\Component\HttpFoundation\Response;
11. use Symfony\Component\Translation\Translator;
12. use App\OfficeBrain\Bundle\CoreBundle\CustomeHandler as FormErrorManager;
13. use App\OfficeBrain\Bundle\CoreBundle\Cache\RedisCacheService;
14. use App\OfficeBrain\Bundle\ProductTagBundle\Entity\ImprintProductMapping;
15. use Symfony\Component\HttpFoundation\Request;
16. use Symfony\Component\DependencyInjection\ContainerInterface;
17. use App\OfficeBrain\Bundle\ProductBundle\Manager\Service\ProductAdminManager;
18. use App\OfficeBrain\Bundle\UserBundle\Manager\Service\UserService;
19. use App\OfficeBrain\Bundle\ProductBundle\Manager\Service\ProductDetailService;
20. use App\OfficeBrain\Bundle\ProductBundle\Manager\Service\BrandApiManager;
21. use App\OfficeBrain\Bundle\ProductTagBundle\Manager\Service\ProductTagManager;
22. use App\OfficeBrain\Bundle\SolrBundle\Manager\Service\SolrService;
23. use App\OfficeBrain\Bundle\QueueBundle\Manager\Service\ApiManager as QueueApiManager;
24. use App\OfficeBrain\Bundle\CategoryBundle\Manager\ApiManager as CategoryApiManager;
25. use Doctrine\Persistence\ManagerRegistry;
27. /*
28.  * This class for base functionality related to product admin. @author Office Brain - 4808 <support@officebrain.com>
29.  */
31.     // /**
32.     //  * @Route("/admin/{_locale}/product")
33.     //  */
35. #[Route('/admin/{_locale}/product')]
36. class ProductConfigureController extends AbstractController
37. {
38.     public function __construct(ContainerInterface $container, ProductAdminManager $productAdminManager, UserService $userService, ProductDetailService $productDetailService, BrandApiManager $brandApiManager, ProductTagManager $productTagManager, SolrService $solrService, QueueApiManager $queueApiManager, ManagerRegistry $doctrine)
39.     {
40.         $this->serviceContainer = $container;
41.         $this->productApiManager = $productAdminManager;
42.         $this->userService = $userService->getUserExtended();
43.         $this->productDetailManager = $productDetailService->getProductApiExtended();
44.         $this->brandApiManager = $brandApiManager;
45.         $this->productTagManager = $productTagManager->getProductTagManagerExtended();
46.         $this->solrService = $solrService->getSolrServiceExtended();
47.         $this->queueApiManager = $queueApiManager->getQueueInstance();
48.         $this->doctrine = $doctrine;
49.     }
51.     CONST PRODUCT_CACHE_CLIENT = 'product';
52.     
53.    /**
54.      * @author Employee Id: 4808
55.      * 
56.      * Description : This function used for Set and intilize variables and request array
57.      *
58.      **/
59.     public function init(Request $request){
60.          $this->request = $request;
61.         $this->entityManager = $this->doctrine->getManager();
62.         $this->session = $this->request->getSession();
63.         $this->translator = $this->serviceContainer->get('translator');
64.         $this->formErrorManager = new FormErrorManager\JsonError();
65.         // $this->productApiManager = $this->serviceContainer->get("office_brain_product_admin_manager");
66.         $this->productApiManager = $this->productApiManager;
67.         // $this->brandApiManager = $this->serviceContainer->get("officebrain_brand_api_manager");
68.         $this->brandApiManager = $this->brandApiManager;
69.         $this->categoryApiManager = $this->serviceContainer->get("officebrain_category_api_manager");
70.         // $this->userManager = $this->serviceContainer->get("office_brain_user_manager");
71.         $this->userManager = $this->userService;
72.         $this->projectSetting = $this->request->get('project_setting');
73.         $this->projectUserSetting = $this->request->get('project_user_setting');
74.         $this->userId = $this->projectUserSetting['user_data'] ? $this->projectUserSetting['user_data']->getId() : 0;
75.         // $this->productDetailManager = $this->serviceContainer->get('office_brain_product_detail_manager');
76.         $this->productDetailManager = $this->productDetailManager;
77.         $this->productTagManager = $this->productTagManager;
78.         
79.         $this->user = $this->projectUserSetting['user_data'];
80.         if (!$this->user && $this->request->isXmlHttpRequest()) {
81.            // throw new AccessDeniedHttpException();
82.         }
83.         // if ($this->serviceContainer->has('office_brain_queue_api_manager')) {
84.         //     $this->request->attributes->set('object', 'Product');
85.         //     $this->queueApiManager = $this->serviceContainer->get('office_brain_queue_api_manager');
86.         // }
87.         if ($this->queueApiManager) {
88.             $this->request->attributes->set('object', 'Product');
89.             $this->queueApiManager = $this->queueApiManager;
90.         }
91.         
92.         $this->statsh_cache_wrapper = RedisCacheService::create();
93.         $this->moduleCachePrefix='__RelatedProducts__';
94.     }
95.     
96.     // /**
97.     //  * @author Employee Id: 4808
98.     //  *
99.     //  * Description : This function used for List Product Information
100.     //  *
101.     //  * @Route("/list/{page}",
102.     //  * name="officebrain_bundle_product_list_product_wo_culture",
103.     //  * requirements={"records_per_page"="12|24|48|100|996", "page"="\d+"},
104.     //  * defaults={"records_per_page"=100,"page"=1})
105.     //  *
106.     //  * @Route("/list/{country}/{language}/{page}",
107.     //  * name="officebrain_bundle_product_list_product",
108.     //  * requirements={"records_per_page"="12|24|48|100|996","page"="\d+"},
109.     //  * defaults={"records_per_page"=20,"page"=1})
110.     //  * @Template("OfficeBrain/Bundle/ProductBundle/ProductAdmin/list.html.twig")
111.     //  */
112.     
113.     #[Route(
114.         path: '/list/{page}',
115.         name: 'officebrain_bundle_product_list_product_wo_culture',
116.         requirements: ['records_per_page' => '12|24|48|100|996', 'page' => '\d+'],
117.         defaults: ['records_per_page' => 100, 'page' => 1],
118.         methods: ['GET']
119.     )]
120.     #[Route(
121.         path: '/list/{country}/{language}/{page}',
122.         name: 'officebrain_bundle_product_list_product',
123.         requirements: ['records_per_page' => '12|24|48|100|996', 'page' => '\d+'],
124.         defaults: ['records_per_page' => 20, 'page' => 1],
125.         methods: ['GET']
126.     )]
127.     #[Template('OfficeBrain/Bundle/ProductBundle/ProductAdmin/list.html.twig')]
129.     public function listProductAction(Request $request){
130.         $this->init($request);
131.         $projectSetting = $this->request->get('project_setting');
132.         list($defaultCulture,$defaultCountry) = explode("_",$this->request->get("_locale"));
133.     
134.         $param = $this->request->get('_route_params');
135.         $culture = $this->request->get('language',$defaultCulture);
136.         $country = $this->request->get('country',$defaultCountry);
137.         $activeCulture = $culture;
138.         $searchStatus = $this->request->query->get('search_status', '');
139.         $searchQuery = $this->request->query->get('search_query', '');
140.         $sortBy = $this->request->query->get('sort', 'updatedAt');
141.         $sortType = $this->request->query->get('direction', 'desc');
142.         $searchParam = $this->request->query->get('search_param', '');
143.         $supplier_id = $this->request->query->get('supplier_id','');
144.         $brandIds = $this->request->query->get('brand_id','');
145.         $catIds = $this->request->query->get('cat_id','');
146.         $instanceType = $projectSetting['instance_type'];
147.         $cultureCategory =  $activeCulture . "_" . $country;
148.     
149.         // For Pagination
150.         $page = $this->request->get('page', '1');
151.         $records_per_page = $param['records_per_page'];
152.         $recordsPerPage = $this->request->query->get('recordsPerPage',$records_per_page);
153.         $start_index = (($page - 1) * $recordsPerPage - 1);
154.         // End Pagination
155.         $projectSetting = $this->request->get('project_setting');
156.     
157.         $projectId = $projectSetting['project_id'];
158.         $productData = $this->productApiManager->listProduct($searchStatus,$searchParam, $searchQuery, $sortType, $sortBy,$activeCulture,$country,$supplier_id,$records_per_page,$page,$projectId,$brandIds,$catIds);
159.         $supplierData = $this->productApiManager->getSupplierNameList($projectId);
160.         $brandData = $this->brandApiManager->getList($culture);
161.         //GET CATEGORY AND SUBCATEGORY
162.         $categoryAndSubCategoryData = $this->categoryApiManager->getList(array($cultureCategory),array(),true);
163.         $this->catArrayNew = array();
164.         if ($categoryAndSubCategoryData) {
165.             foreach($categoryAndSubCategoryData[$cultureCategory] as $catKey=>$categoryAndSubCategory){
166.                 $this->recursiveCategory($categoryAndSubCategory);
167.             }
168.             // Sort Category array using category name
169.             usort($this->catArrayNew, function ($a, $b) {
170.                 return strcasecmp($a['cat_name'], $b['cat_name']);
171.             });
172.         }
173.         $data['category_SubCategory_data'] = $this->catArrayNew;
174.         $paginator  = $this->serviceContainer->get('knp_paginator');
175.         $data['pagination'] = $paginator->paginate($productData, $page, $recordsPerPage);
176.         $data['page']=$page;
177.         $data['search_status']=$searchStatus;
178.         $data['search_query']=$searchQuery;
179.         $data['sort_by']=$sortBy;
180.         $data['sort_type']=$sortType;
181.         $data['search_param']=$searchParam;
182.         $data['supplier_id']=$supplier_id;
183.         $data['records_per_page'] = $recordsPerPage;
184.         $data['supplier_data'] = $supplierData;
185.         $data['brand_id']=$brandIds;
186.         $data['cat_id']=$catIds;
187.         $data['brand_data']= $brandData[$culture];
188.     
189.         if(array_key_exists('status',$productData) && $productData['status'] == 'error' && is_array($productData))
190.         {
191.             $productSentData = array();
192.             $data['error_message'] = $productData['error_message'];
193.         }
194.         else
195.         {
196.             if($productData['data']){
197.                 $data['total_product'] = $productData['count'];
198.                 $data['image_url'] = (array_key_exists('image_url',$productData)?$productData['image_url']:'');
199.                 $productSentData = $productData['data'];
200.             }else{
201.                 $productSentData = array();
202.                 $data['error_message'] = $this->serviceContainer->get('translator')->trans("product.RECORD_NOT_FOUND");
203.             }
204.         }
205.     
206.         $data['params_to_append'] = array_merge($this->request->get('_route_params'), $this->request->query->all());
207.     
208.         return array('data'=>$data,'activeCountry' => $country, 'activeCulture'=>$activeCulture,'productData'=>$productSentData);
209.     }
210.     
211.     
212.     // /**
213.     //  * @author Employee Id: 5406
214.     //  * 
215.     //  * Description : This function used for List Product Information
216.     //  * 
217.     //  * @Route("/list-product-filtered-by-category/{productId}/{page}",
218.     //  * name="officebrain_bundle_product_list_product_filtered_by_category_wo_culture",
219.     //  * requirements={"records_per_page"="12|24|48|100|996", "page"="\d+"},
220.     //  * defaults={"records_per_page"=20,"page"=1})
221.     //  *
222.     //  * @Route("/list-product-filtered-by-category/{productId}/{country}/{language}/{page}",
223.     //  * name="officebrain_bundle_product_list_product_filtered_by_category",
224.     //  * requirements={"records_per_page"="12|24|48|100|996","page"="\d+"},
225.     //  * defaults={"records_per_page"=20,"page"=1})
226.     //  * @Template("OfficeBrain/Bundle/ProductBundle/ProductAdmin/listProductFilteredByCategory.html.twig")
227.     //  */
228.     
229.     #[Route(path: '/list-product-filtered-by-category/{productId}/{page}', 
230.             name: 'officebrain_bundle_product_list_product_filtered_by_category_wo_culture', 
231.             requirements: ['page' => '\d+'], 
232.             defaults: ['records_per_page' => 20, 'page' => 1])
233.     ]
235.     #[Route(path: '/list-product-filtered-by-category/{productId}/{country}/{language}/{page}', 
236.             name: 'officebrain_bundle_product_list_product_filtered_by_category', 
237.             requirements: ['page' => '\d+'], 
238.             defaults: ['records_per_page' => 20, 'page' => 1])
239.     ]
241.     #[Template('OfficeBrain/Bundle/ProductBundle/ProductAdmin/listProductFilteredByCategory.html.twig')]
243.     public function listProductFilteredByCategoryAction(Request $request, $productId){
244.         $this->init($request);
245.         
246.         list($defaultCulture,$defaultCountry) = explode("_",$this->request->get("_locale"));
247.         
248.         $param = $this->request->get('_route_params');
249.         $culture = $this->request->get('language',$defaultCulture);
250.         $country = $this->request->get('country',$defaultCountry);
251.         $countryId = $this->serviceContainer->getParameter('country')[$country]['id'];
252.         //echo $countryId= $this->country_;exit;
253.         $activeCulture = $culture;
254.         $searchStatus = $this->request->query->get('search_status', '');
255.         $searchQuery = $this->request->query->get('search_query', '');
256.         $sortBy = $this->request->query->get('sort', 'updatedAt');
257.         $sortType = $this->request->query->get('direction', 'desc');
258.         $searchParam = $this->request->query->get('search_param', '');
259.         $supplier_id = $this->request->query->get('supplier_id','');
260.         $brandIds = $this->request->query->get('brand_id','');
261.         $catIds = $this->request->query->get('cat_id','');
262.         
263.         $cultureCategory =  $activeCulture . "_" . $country;
264.         
265.         // select all of the category ids from categorymapping entity, where product id of entity matches the product id passed in request, and country id of entity matches the country id passed in request
266.         // then using those category ids we will filter out the products and then we will show only the products coming in these specific categories
267.         $productCategoryIds = $this->productApiManager->getCategoryIds($productId,$countryId);
268.         $catIds = implode(",",$productCategoryIds);
269.         //print_r($productCategoryIds);exit;
270.         $comproductreletedid =   $this->productApiManager->productreletedid($productId);
271.         $productdetails = $this->productDetailManager->getProductDetailById($productId,$cultureCategory);
272.         $product_title = $productdetails[$productId]['basic_information']['title'];
273.         // For Pagination
274.         $page = $this->request->get('page', '1');
275.         $records_per_page = $param['records_per_page'];
276.         $recordsPerPage = $this->request->query->get('recordsPerPage',$records_per_page);
277.         $start_index = (($page - 1) * $recordsPerPage - 1);
278.         // End Pagination
279.         $projectSetting = $this->request->get('project_setting');
280.         
281.         $projectId = $projectSetting['project_id'];
282.         $instanceType = $projectSetting['instance_type'];
283.         $productData = $this->productApiManager->listProduct($searchStatus,$searchParam, $searchQuery, $sortType, $sortBy,$activeCulture,$country,$supplier_id,$records_per_page,$page,$projectId,$brandIds,$catIds);
284.         
285.         /* code for not showing the parent product in related products started */
286.         if(isset($productData['data']))
287.         {
288.             $productIndex = 0;  
289.             foreach($productData['data'] as $singleProductDetail)
290.             {
291.                 if(isset($singleProductDetail['product_master_id']))
292.                 {
293.                     if($singleProductDetail['product_master_id'] == $productId)
294.                     { 
295.                         unset($productData['data'][$productIndex]);
296.                         //$productData['count'] = $productData['count'] - 1;
297.                     }
298.                 }
299.                 $productIndex++;
300.             }    
301.         }
302.         /* code for not showing the parent product in related products ended */
303.         
304.         $supplierData = $this->productApiManager->getSupplierNameList($projectId);
305.         $brandData = $this->brandApiManager->getList($culture);
306.         //GET CATEGORY AND SUBCATEGORY
307.         $categoryAndSubCategoryData = $this->categoryApiManager->getList(array($cultureCategory),array(),true);
308.         $this->catArrayNew = array();
309.         if ($categoryAndSubCategoryData) {
310.             foreach($categoryAndSubCategoryData[$cultureCategory] as $catKey=>$categoryAndSubCategory){
311.                 $this->recursiveCategory($categoryAndSubCategory);
312.             }
313.             // Sort Category array using category name
314.             usort($this->catArrayNew, function ($a, $b) {
315.                 return strcasecmp($a['cat_name'], $b['cat_name']);
316.             });
317.         }
318.         $data['category_SubCategory_data'] = $this->catArrayNew;
319.         $paginator  = $this->serviceContainer->get('knp_paginator');
320.         $data['pagination'] = $paginator->paginate($productData, $page, $recordsPerPage);
321.         $data['page']=$page;
322.         $data['search_status']=$searchStatus;
323.         $data['search_query']=$searchQuery;
324.         $data['sort_by']=$sortBy;
325.         $data['sort_type']=$sortType;
326.         $data['search_param']=$searchParam;
327.         $data['supplier_id']=$supplier_id;
328.         $data['records_per_page'] = $recordsPerPage;
329.         $data['supplier_data'] = $supplierData;
330.         $data['brand_id']=$brandIds;
331.         $data['cat_id']=$catIds;
332.         $data['brand_data']= $brandData[$culture];
333.         $data['INSTANCE_TYPE'] = $instanceType;
334.         
335.         if(array_key_exists('status',$productData) && $productData['status'] == 'error' && is_array($productData))
336.         {
337.             $productSentData = array();
338.             $data['error_message'] = $productData['error_message'];
339.         }
340.         else
341.         {
342.             if($productData['data']){
343.                 $data['total_product'] = $productData['count'];
344.                 $data['image_url'] = (array_key_exists('image_url',$productData)?$productData['image_url']:'');
345.                 $productSentData = $productData['data'];
346.             }else{
347.                 $productSentData = array();
348.                 $data['error_message'] = $this->serviceContainer->get('translator')->trans("product.RECORD_NOT_FOUND");
349.             }
350.         }
351.         
352.         $data['params_to_append'] = array_merge($this->request->get('_route_params'), $this->request->query->all());
353.         return array('data'=>$data,'activeCountry' => $country, 'activeCulture'=>$activeCulture,'productData'=>$productSentData,'productId' => $productId,'comproductreletedid'=> $comproductreletedid,'product_title'=>$product_title);
354.     }
355.     
356.     
357.     // /**
358.     //  * EMp Id : 4246
359.     //  * Description : This Function is Used For Update Product Status According To Parameter
360.     //  *
361.     //  * @Route("/change-relation-status/{country}/{set_status}",
362.     //  * requirements = {"set_status"="1|0"},
363.     //  * name="officebrain_product_change_relation_status")
364.     //  */
365.     
366.     #[Route(path: '/change-relation-status/{country}/{set_status}', 
367.         name: 'officebrain_product_change_relation_status', 
368.         requirements: ['set_status' => '1|0'])]
370.     public function changeProductRelationStatusAction(Request $request){
371.         $this->init($request);
372.         $param=$this->request->get('_route_params');
373.         $productId=$this->request->get('productId');
374.         $setStatus=$this->request->get('set_status');
375.          
376.         $relatedProductIds = array();
377.         $relatedProductIds = $this->request->get('ids','');
378.         $relatedProductIds = explode("::",$relatedProductIds);
379.     
380.         $projectSetting = $this->request->get('project_setting');
381.         $locale_language = $projectSetting['locale_language'];
382.     
383.         //$productAdminManager = $this->get('office_brain_product_admin_manager');
384.          
385.         if($setStatus == 1)
386.         {
387.             $productData = $this->productApiManager->insertRelatedProducts($productId,$relatedProductIds,$locale_language);
388.         }
389.         else if($setStatus == 0)
390.         {
391.             $productData = $this->productApiManager->deleteRelatedProducts($productId,$relatedProductIds,$locale_language);
392.         }
393.     
394.         $data = array();
395.         $data['status'] = 'success';
396.         $data['message'] = $this->translator->trans('product.PRODUCT_RELATION_UPDATED');
397.         
398.         RedisCacheService::removeCacheByPrefix($this->statsh_cache_wrapper,$this->moduleCachePrefix);
399.         
400.         return new JsonResponse($data);
401.     }
402.     
403.     
404.     /**
405.      * Recursive function for category list
406.      * 
407.      * @param array $catArray
408.      */
409.     public function recursiveCategory($catArray){
410.         if (array_key_exists("child",$catArray)) {
411.             foreach($catArray['child'] as $subCatArray){
412.                 if (array_key_exists("child",$subCatArray)) {
413.                    foreach ($subCatArray['child'] as $leafCat) {
414.                        $this->recursiveCategory($leafCat);
415.                    }
416.                 }
417.                 else{
418.                     $this->catArrayNew[] = $subCatArray;
419.                 }
420.             }
421.         } 
422.         else {
423.               $this->catArrayNew[] = $catArray;
424.         }
425.     }
426.     public function deleteCache($productId=0,$culture)
427.     {
428.         
429.         if(!RedisCacheService::isCacheEnable())
430.         {
431.             return null;
432.         }
433.         $cacheClient=RedisCacheService::create(null,self::PRODUCT_CACHE_CLIENT);
434.         //echo "===========$productId.':*'.$culture==========";
435.         
436.         // $cacheClient->removeCacheByPrefix($productId.':*'.$culture);
437.     }
438.     // /**
439.     //  * @author Employee Id: 4808
440.     //  * 
441.     //  * Description : This function used for Add Product Information 
442.     //  * @return array 
443.     //  * @Route("/add", name="officebrain_product_add"),
444.     //  * @Template("OfficeBrain/Bundle/ProductBundle/ProductAdmin/add.html.twig")
445.     //  */
446.     
447.     #[Route(path: '/add', name: 'officebrain_product_add', methods: ['GET', 'POST'])]
448.     #[Template("OfficeBrain/Bundle/ProductBundle/ProductAdmin/add.html.twig")]
450.     public function addAction(Request $request){
451.         $this->init($request);
452.         $projectSetting = $this->request->get('project_setting');             
453.         $instanceType = $projectSetting['instance_type'];
454.         
455.         $cultureName = $this->request->get('culture_name');
456.         $master_product_id = $this->request->get('master_product_id', '');
457.         $param = $this->request->get('_route_params');
458.         $route = $this->request->get('_route');
459.         
460.         $locale_language = $param['_locale'];
461.         $productAddSettings = $projectSetting['configuration_rule']['product']['add_update'];
462.         $supplier_id = 0;
463.         // set global_pricing_keys which are active
464.         $globalPricingKeys = '';        
465.         if(array_key_exists('global_pricing', $productAddSettings))
466.         {
467.             foreach ($productAddSettings['global_pricing'] as $key => $val) 
468.             {
469.                 if ($val['status'] == 1) 
470.                 {
471.                     $globalPricingKeys .= ($val['pricing_box_id'].':'.$val['pricing_box_name']).',';
472.                 }
473.             }
474.         }
475.         
476.         //$supplierData = $this->productApiManager->getSupplierNameList($projectSetting['project_id']);        
477.         
478.         if ($this->request->isXmlHttpRequest() && $this->request->getMethod()=='POST') {
479.             $data = $this->request->request->all();
480.             $data['valid_up_to']=str_replace('/','-',$data['valid_up_to']);
481.             $data['special_price_valid_up_to']=str_replace('/','-',$data['special_price_valid_up_to']);
482.             $data['pricing_valid_until']=str_replace('/','-',$data['pricing_valid_until']);
483.             $data['pricing_valid_starting']=str_replace('/','-',$data['pricing_valid_starting']);
484.             $data['master_product_id'] = $master_product_id;
485.             $data['project_id'] = $projectSetting['project_id'];
486.             $data['locale_language'] = $locale_language;
487.             $data['instance_type'] = $projectSetting['instance_type'];
488.             $data['instance_id'] = $projectSetting['instance_id'];
489.             $data['thumb_width'] =  $this->serviceContainer->getParameter('thumb_width');
490.             $data['medium_thumb_width'] = $this->serviceContainer->getParameter('medium_thumb_width');
491.   
492.             $apiResponse =  $this->productApiManager->add($data, $cultureName);
493.             if ($apiResponse['status']=='success') {
494.                 $response = array('form_status' => $apiResponse['status'],'success_message'=>$this->serviceContainer->get('translator')->trans($apiResponse['success_message']));
495.                 $this->session->set('product-list-success', $this->serviceContainer->get('translator')->trans($apiResponse['success_message']));
496.                 
497.                 $actionPerformed = 'create';
498.                 if ($master_product_id) { 
499.                     $actionPerformed = 'update';
501.                     /* Remove Cache Of Product Details Page */
502.                     $statsh_cache_wrapper = RedisCacheService::create();
503.                     $moduleCachePrefix = '__ProductDetailsPageOtherProducts';
504.                     RedisCacheService::removeCacheByPrefix($statsh_cache_wrapper,$moduleCachePrefix."*product_id#".$master_product_id);
505.                     /* EO: Remove Cache Of Product Details Page */
506.                 }
508.                 if($data['product_name']['en']!=$data['old_name']){
509.                     $this->deleteCache($apiResponse['master_product_id'],'en_us');
510.                 }
511.                 
512.                 //SOLR SYNC CODE START
513.                 $is_solr_syn_enabled = $this->serviceContainer->getParameter('solr_sync');
514.                 if($is_solr_syn_enabled){
515.                     $env = $this->serviceContainer->getParameter("kernel.environment");
516.                     $localization_to_update = $this->serviceContainer->getParameter('localization_to_fetch');
517.                     // $this->productApiManager->updateSolrData($apiResponse['master_product_id'],$localization_to_update,$projectSetting['project_id'],$env,'update'); // symfony 4
518.                     $this->productApiManager->updateSolrData($apiResponse['master_product_id'],$localization_to_update,$projectSetting['project_id'],$env,$projectSetting['instance_id'],'update');
519.                 }
520.                 
521.                 //SOLR SYNC CODE END
522.                 
523.                 // To Integrate With ERP
524.                 $erpIntegration = $projectSetting['configuration_rule']['erp_integration'];
525.                 if($erpIntegration && $erpIntegration['productManagement'] == 1 && !empty($this->queueApiManager)) {
526.                     $this->productApiManager->integrateWithErp($this->queueApiManager, $actionPerformed, $apiResponse['master_product_id']);
527.                 }
528.                 if($this->request->get('syncflag')==1){ 
529.                     if($productAddSettings['asi_call']['status']){
530.                         foreach ($apiResponse['product_slugs'] as $culture => $slug){
531.                             if($master_product_id > 0)
532.                             {
533.                                 $this->productDetailManager->updateSyncDetail($this->request->get('syncflag'),$data['sku']);
534.                                 $asiurl = 'http://demoapi.officebrain.com/update_product_api.php?product_slug='.$slug;
535.                             }
536.                             else
537.                             {
538.                                 $this->productDetailManager->insertSyncDetail($this->request->get('syncflag'),$data['sku']);
539.                                 $asiurl = 'http://demoapi.officebrain.com/product_api.php?product_slug='.$slug;
540.                             }
541.                             //echo $asiurl;die;
542.                             exec("curl '$asiurl' > /dev/null &");
543.                         }
544.                     }
545.                 }
546.                 else
547.                 {
548.                     if($master_product_id > 0)
549.                     {
550.                         $this->productDetailManager->updateSyncDetail(0,$data['sku']);
551.                     }
552.                     else
553.                     {
554.                         $this->productDetailManager->insertSyncDetail(0,$data['sku']);
555.                     }
557.                     if(isset($data['sku']) && !empty($data['sku'])){
558.                         $asiurl = 'http://demoapi.officebrain.com/product_delete_api.php?product_sku='.$data['sku'];
559.                         exec("curl '$asiurl' > /dev/null &");
560.                     }
561.                 }
562.                 
563.             } else {
564.                 $response = array('form_status' => $apiResponse['status'],'error_message'=>$this->serviceContainer->get('translator')->trans($apiResponse['message']));
565.             }
566.             return new JsonResponse($response);
567.         }
568.         $data_to_set =  $this->productApiManager->preSetDataForPlugin($projectSetting['configuration_rule']['product'],$projectSetting['project_id'],'',1);
569.         $this->viewTwigData['plugin_data'] = $data_to_set['plugin_data'];
570.         $this->viewTwigData['ATTR_TYPE_IDS'] = $this->serviceContainer->getParameter('attributes_types');
571.         $this->viewTwigData['ATTR_IMPRINT_POSITION'] = $this->serviceContainer->getParameter('imprint_position_master_id');
572.         $this->viewTwigData['ATTR_COLOR_ID'] = $this->serviceContainer->getParameter('color_attribute_id');        
573.         $this->viewTwigData['params_to_append'] = array_merge($this->request->get('_route_params'), $this->request->query->all());
574.         $this->viewTwigData['form_method'] = 'add';
575.         $this->viewTwigData['global_pricing_keys'] = trim($globalPricingKeys, ',');
576.         $this->viewTwigData['INSTANCE_TYPE'] = strtolower($instanceType);
577.         return $this->viewTwigData;
578.     }
579.     
580.     // /**
581.     //  * @author Employee Id: 4045
582.     //  *
583.     //  * Description : This function used to Edit Product Information
584.     //  * @return array
585.     //  * @Route("/edit/{master_product_id}", name="officebrain_product_edit"),
586.     //  * @Template("OfficeBrain/Bundle/ProductBundle/ProductAdmin/add.html.twig")
587.     //  */
588.     
589.     #[Route(path: '/edit/{master_product_id}', name: 'officebrain_product_edit', methods: ['GET', 'POST'])]
590.     #[Template("OfficeBrain/Bundle/ProductBundle/ProductAdmin/add.html.twig")]
592.     public function editNewAction(Request $request){
593.         $this->init($request);
594.         $projectSetting = $this->request->get('project_setting');
595.         $countryArray = $this->serviceContainer->getParameter('country');
596.         $languageArray = $this->serviceContainer->getParameter('language');
597.         $country_to_pass = array_column($countryArray,'short_name');
598.         $language_to_pass = array_keys($languageArray);
599.         $locale = $this->request->get('_locale',$this->serviceContainer->getParameter('locale'));
600.         @list($default_language,$default_country) = explode("_",$locale);
601.         $cultureName = $this->request->get('culture_name');
602.         $masterProductId = $this->request->get('master_product_id', '');
603.         $param = $this->request->get('_route_params');
604.         $route = $this->request->get('_route');
605.         $quoteId = $this->request->get('quote_id',0);
606.         
607.         // set global_pricing_keys which are active
608.         $globalPricingKeys = '';
609.         $productAddSettings = $projectSetting['configuration_rule']['product']['add_update'];
610.         if(array_key_exists('global_pricing', $productAddSettings))
611.         {
612.             foreach ($productAddSettings['global_pricing'] as $key => $val)
613.             {
614.                 if ($val['status'] == 1)
615.                 {
616.                     $globalPricingKeys .= ($val['pricing_box_id'].':'.$val['pricing_box_name']).',';
617.                 }
618.             }
619.         }
621.         $productInfo = $this->productApiManager->editView($masterProductId,$language_to_pass,$country_to_pass,$default_language);
622.         $syncentityobj= $this->productDetailManager->getSyncDetail($productInfo['en']['basic_information']['sku_number']);
623.        //$supplierData = $this->productApiManager->getSupplierNameList($projectSetting['project_id']);
624.         if(isset($syncentityobj))
625.         {
626.             $productInfo['syncflag']=$syncentityobj['isSync'];
627.         }
628.         else
629.         {
630.             $productInfo['syncflag']=0;
631.         }
632.         if(!count($productInfo)){
633.             throw $this->createNotFoundException('The product does not exist');
634.         }
635.         
636.         $data_to_set =  $this->productApiManager->preSetDataForPlugin($projectSetting['configuration_rule']['product'], $projectSetting['project_id'],$productInfo);
637.         $this->viewTwigData['plugin_data'] = $data_to_set['plugin_data'];
638.         $this->viewTwigData['ATTR_TYPE_IDS'] = $this->serviceContainer->getParameter('attributes_types');
639.         $this->viewTwigData['ATTR_IMPRINT_POSITION'] = $this->serviceContainer->getParameter('imprint_position_master_id');
640.         $this->viewTwigData['ATTR_COLOR_ID'] = $this->serviceContainer->getParameter('color_attribute_id');
641.         $this->viewTwigData['params_to_append'] = array_merge($this->request->get('_route_params'), $this->request->query->all());
642.         $this->viewTwigData['master_product_id'] = $masterProductId;
643.         $this->viewTwigData['form_method'] = 'edit';
644.         $this->viewTwigData['global_pricing_keys'] = trim($globalPricingKeys, ',');
645.         return $this->viewTwigData;
646.     }
648.     // /**
649.     //  * @author: Employee Id : 4808
650.     //  * Description: This Function is Related For Image Library
651.     //  *
652.     //  * @Route("/image-library",name="officebrain_product_image_library"),
653.     //  * @Template("OfficeBrain/Bundle/ProductBundle/ProductAdmin/imageLibrary.html.twig")
654.     //  */
655.     
656.     #[Route(path: '/image-library', name: 'officebrain_product_image_library', methods: ['GET'])]
657.     #[Template("OfficeBrain/Bundle/ProductBundle/ProductAdmin/imageLibrary.html.twig")]
659.     public function imageLibraryAction(Request $request){
660.         //TODO: need to get dynamic product once listing get done
661.        $this->init($request);
662.        $this->viewTwigData['data']=array('productId'=>1);
663.         $mainErrorMessage='';
664.         $isImageUploaded = false;
665.         if ($this->request->getMethod() == "POST" ) {
666.             $request = $request;
667.             $fileData = $request->files->get("FileUpload");
668.             $zipData = $request->files->get("zipUpload");
670.             $fileUploadType = $request->get('FileUpload_type');
671.             //TODO: need to get dynamic product once listing get done
672.             $productId = 1;
673.             $index = 0;
674.             $imageArray = array();
675.             foreach($fileData as $image){
676.                 foreach($image as $v){
677.                     if(!empty($v)){
678.                         $isImageUploaded = true;
679.                         break;
680.                     }
681.                 }
682.                 if($isImageUploaded) break;
683.             }
684.             if(!$isImageUploaded){
685.                 foreach($zipData as $image){
686.                     foreach($image as $v){
687.                         if(!empty($v)){
688.                             $isImageUploaded = true;
689.                             break;
690.                         }
691.                     }
692.                     if($isImageUploaded) break;
693.                 }
694.             }
695.             $mainErrorMessage='';
696.             if(!$isImageUploaded){
697.                 $mainErrorMessage =  $this->serviceContainer->get('translator')->trans('admin.image_template_library.select_files_error_msg');
698.             }
699.             $res =  $this->productApiManager->uploadfiles($productId, $fileData,'image',$fileUploadType);
700.             $error_file_upload = $res['error_file_upload'];
701.             $res = $this->productApiManager->uploadfiles($productId, $zipData,'zip');
702.             $error_file_upload_zip = $res['error_file_upload'];
703.         }
704.         $errMsg = '';
705.         $successMsg = '';
706.         if (!empty($error_file_upload) || !empty($error_file_upload_zip)) {
707.             $errMsg = '<ul>';
708.             $arrImgType = array('web' => 'Web', 'template' => 'Template', 'high_res' => 'High Res');
709.             foreach ($arrImgType as $type => $files) {
710.                 if (isset($error_file_upload[$type]) || isset($error_file_upload_zip[$type])) {
711.                     $errMsg.="<li>" . $files . "<ul>\n";
712.                     if (isset($error_file_upload[$type])) {
713.                         foreach ($error_file_upload[$type] as $fileName => $error) {
714.                             $errMsg.="<li>" . $fileName . ":<i><b>" . $error . "</b></i></li>";
715.                         }
716.                     }
717.                     if (isset($error_file_upload_zip[$type])) {
718.                         foreach ($error_file_upload_zip[$type] as $fileName => $error) {
719.                             $errMsg.="<li>" . $fileName . ":<i><b>" . $error . "</b></i></li>";
720.                         }
721.                     }
722.                     $errMsg.="</ul></li>";
723.                 }
724.             }
725.             $errMsg.='</ul>';
726.         }elseif($mainErrorMessage != '' ){
727.             $errMsg = '<ul><li>'.$mainErrorMessage.'</li></ul>';
728.         }elseif($isImageUploaded){
729.             $successMsg = $this->serviceContainer->get('translator')->trans('admin.image_template_library.upload_succ');
730.         }
731.        return $this->viewTwigData;
732.     }
734.     // /**
735.     //  * @Route("/browse-product-image", name="OfficeBrainImageLibraryAdmin_browse_product_image", methods={"POST"})
736.     //  * @Template("OfficeBrain/Bundle/ProductBundle/ProductAdmin/browseProductImage.html.twig")
737.     //  */
738.     
739.     #[Route(path: '/browse-product-image', name: 'OfficeBrainImageLibraryAdmin_browse_product_image', methods: ['POST'])]
740.     #[Template("OfficeBrain/Bundle/ProductBundle/ProductAdmin/browseProductImage.html.twig")]
742.     public function browseProductImageAction(Request $request) {
743.         $this->init($request);
744.         $this->request = $request;
745.         $productId = intval($this->request->get('id'));
746.         $imageType = $this->request->get('type');
747.         $data = $this->productApiManager->productImages($productId,$imageType);
748.         $imageArray = array();
749.         if($data){
750.             if($imageType =='high_res'){
751.                 foreach($data as $image){
752.                     
753.                     if(trim($image['fileType'])!='imprinted')
754.                         $imageArray['blank'][]=$image;
755.                     else
756.                         $imageArray['imprinted'][]=$image;
757.                 }
758.             } else {
759.                 $imageArray = $data;
760.             }
761.         }
762.         return array('imageArray' => $imageArray, 'imageType' => $imageType);
763.     }
764.     // /**
765.     //  * @Route("/remove-product-image",
766.     //  * name="officebrain_image_library_admin_bundle_remove_product_image", methods={"GET","POST"}),
767.     //  * @Template()
768.     //  */
769.     
770.     #[Route(path: '/remove-product-image', name: 'officebrain_image_library_admin_bundle_remove_product_image', methods: ['GET', 'POST'])]
771.     #[Template()]
773.     public function removeProductImageAction(Request $request) {
774.         $this->init($request);
775.         $productId = $this->request->get('productId');
776.         $imageType = $this->request->get('imageType');
777.         $imageId = $this->request->get('imageId');
778.         
779.         $result = $this->productApiManager->removeProductImage($productId,$imageId);
780.         if ($result)
781.             echo $this->serviceContainer->get('translator')->trans('admin.image_template_library.image_removed_succ');
782.         else
783.             echo $this->serviceContainer->get('translator')->trans('admin.image_template_library.image_removed_fail');
784.     }
785.     // /**
786.     //  * @author Employee Id: 4246
787.     //  * Description : This function used for View Product Information
788.     //  * @Route("/view",
789.     //  * name="officebrain_product_view")
790.     //  * @Template("OfficeBrain/Bundle/ProductBundle/ProductAdmin/view.html.twig")
791.     //  */
792.     
793.     #[Route(path: '/view', name: 'officebrain_product_view')]
794.     #[Template('OfficeBrain/Bundle/ProductBundle/ProductAdmin/view.html.twig')]
796.     public function viewAction(Request $request){
797.         $this->init($request);
798.         $product_culture = $this->request->get('product_culture');
799.         $product_ids = $this->request->get('product_ids');
800.         //$productAdminManager = $this->get('office_brain_product_admin_manager');
801.         $productData = $this->productApiManager->view($product_ids,$product_culture,true);
802.         
803.         $projectSetting = $this->request->get('project_setting');
804.         $productAddSettings = $projectSetting['configuration_rule']['product']['add_update'];
805.         if(array_key_exists('global_pricing', $productAddSettings))
806.         {
807.             foreach ($productAddSettings['global_pricing'] as $key => $val)
808.             {
809.                 if ($val['status'] == 1)
810.                 {
811.                     $global_pricing_arr[$key] = 1;
812.                 }
813.             }
814.         }
815.         
816.         $culture_id = $this->request->get('culture_id');
817.         if(!count($productData)){
818.             throw $this->createNotFoundException('The product does not exist');
819.         }
820.         if($productData['status'] == "success"){
821.             $productInfo = $productData['data'];
822.             if(array_key_exists('price_unit',$productInfo[$product_ids])){
823.                 $priceUnit = $this->serviceContainer->getParameter('price_unit');
824.                 $productInfo[$product_ids]['price_unit'] = array_key_exists(trim($productInfo[$product_ids]['price_unit']),$priceUnit)?$priceUnit[$productInfo[$product_ids]['price_unit']]:$productInfo[$product_ids]['price_unit'];
825.             }
826.             $this->viewTwigData['data'] = $productInfo[$product_ids];
827.         }else{
828.             $this->viewTwigData['error_message'] = $this->serviceContainer->get('translator')->trans('product.'.$productData['message']);
829.         }
830.         $this->viewTwigData['params_to_append'] = array_merge($this->request->get('_route_params'), $this->request->query->all());
832.         $this->viewTwigData['global_pricing_arr'] = $global_pricing_arr;
833.         return $this->viewTwigData;
834.     }
835.     // /**
836.     //  * @author Employee Id: 4246
837.     //  * Description : This function used for Delete Product
838.     //  * @Route("/delete",
839.     //  * name="officebrain_product_delete")
840.     //  */
841.     
842.     #[Route(path: '/delete', name: 'officebrain_product_delete')]
844.     public function deleteAction(Request $request){
845.         $this->init($request);
846.         $product_master_id = $this->request->get('product_master_id');
847.         $product_country = $this->request->get('product_country');
848.         $projectSetting = $this->request->get('project_setting');
849.         $project_id = $projectSetting['project_id'];
850.         $locale_language = $projectSetting['locale_language'];
851.         $supplier_id = $projectSetting['user_id'];
852.         $instance_type = $projectSetting['instance_type'];
853.         $instance_id = $projectSetting['instance_id'];
854.         $productData = $this->productApiManager->delete($product_master_id, $project_id, $supplier_id, $locale_language, $instance_type, $instance_id, $product_country);
855.         // Data Array Convert Object To Array
856.         $productData['data'] = (array)$productData['data'];
857.         if($productData['status'] == 'success'){
858.             $data['status'] = 'success_message';
859.             //SOLR SYNC CODE START
860.              $is_solr_syn_enabled = $this->serviceContainer->getParameter('solr_sync');
861.              if($is_solr_syn_enabled){
862.                  $env = $this->serviceContainer->getParameter("kernel.environment");
863.                  $localization_to_update = $this->serviceContainer->getParameter('localization_to_fetch');
864.                  $this->productApiManager->updateSolrData($product_master_id,$localization_to_update,$projectSetting['project_id'],$env,'delete');
865.              }
866.             //SOLR SYNC CODE END
867.                 
868.             // To Integrate with ERP
869.             $erpIntegration = $projectSetting['configuration_rule']['erp_integration'];
870.             if($erpIntegration && $erpIntegration['productManagement'] == 1 && !empty($this->queueApiManager)) {
871.                 $dt = new \DateTime($productData['data']['deleted_at']);
872.                 $params = array('product_id' => $product_master_id, 'country_id' => $productData['data']['country_id'], 'deleted_at'=> $dt->format('Y-m-d H:i:s'));
873.                 $this->productApiManager->integrateWithErp($this->queueApiManager, 'remove', $product_master_id, $params);
874.             }
875.         }else{
876.             $data['status'] = 'error_message';
877.         }
878.         $data['message'] = $this->translator->trans($productData['message']);
879.         return new JsonResponse($data);
880.     }
881.     
882.     // /**
883.     //  * EMp Id : 4246
884.     //  * Description : This Function is Used For Update Product Status According To Parameter
885.     //  * 
886.     //  * @Route("/changestatus/{country}/{set_status}",
887.     //  * requirements = {"set_status"="1|0"},
888.     //  * name="officebrain_product_changestatus")
889.     //  */
890.     
891.     #[Route(
892.         path: '/changestatus/{country}/{set_status}',
893.         name: 'officebrain_product_changestatus',
894.         requirements: ['set_status' => '1|0']
895.     )]
897.     public function changeProductStatusAction(Request $request){
898.         $this->init($request);
899.         $param=$this->request->get('_route_params');
900.         
901.         $ids_to_pass = array();
902.         $ids = $this->request->get('ids','');
903.         $ids_to_pass = explode("::",$ids);
904.         $productId = json_encode($ids_to_pass);
905.         
906.         list($defaultCulture,$defaultCountry) = explode("_",$this->request->get("_locale"));
907.         $projectSetting = $this->request->get('project_setting');
908.         $culture = $this->request->get('language',$defaultCulture);
909.         $country = $this->request->get('country');
910.         $setStatus = $this->request->get('set_status');
911.         $cultureCategory =  $culture. "_" . $country;
912.         
913.         $project_id = $projectSetting['project_id'];
914.         $locale_language = $projectSetting['locale_language'];
915.         $supplier_id = $projectSetting['user_id'];
916.         $instance_type = $projectSetting['instance_type'];
917.         $instance_id = $projectSetting['instance_id'];
918.         
919.         //$productAdminManager = $this->get('office_brain_product_admin_manager');
920.         $productData = $this->productApiManager->changeProductStatus($productId,$country,$setStatus, $project_id, $supplier_id, $locale_language, $instance_type, $instance_id);
921.         $data = array();
922.         if($productData['status'] == 'success'){            
923.             //SOLR SYNC CODE START
924.             $is_solr_syn_enabled = $this->serviceContainer->getParameter('solr_sync');
925.             if($is_solr_syn_enabled){
926.                 $env = $this->serviceContainer->getParameter("kernel.environment");
927.                 $localization_to_update = $this->serviceContainer->getParameter('localization_to_fetch');
928.                 // $solrProductManager = $this->serviceContainer->get('office_brain_solr_product_mapping_manager');
929.                 $solrProductManager = $this->solrService;
930.                 foreach($ids_to_pass as $product_id_to_process){
931.                     if(!$setStatus){
932.                         $this->productApiManager->updateSolrData($product_id_to_process,$localization_to_update,$projectSetting['project_id'],$env, $instance_id,'delete');
933.                         $productdetails = $this->productDetailManager->getProductDetailById($product_id_to_process,$cultureCategory);
934.                         
935.                         if(strpos($productdetails[$product_id_to_process]['basic_information']['sku_number'], '-') != false && isset($productdetails[$product_id_to_process]['other_products'])){
936.                             $main_sku = $productdetails[$product_id_to_process]['basic_information']['sku_number'];
937.                             $main_sku = explode('-', $main_sku); // get main sku
939.                             $mainSku = $main_sku[1];                 
940.                             if(isset($productdetails[$product_id_to_process]['other_products']) && is_array($productdetails[$product_id_to_process]['other_products'])){
941.                                 $sortOrder = array($mainSku, '80-'.$mainSku,'75-'.$mainSku, '76-'.$mainSku, '81-'.$mainSku,'82-'.$mainSku,'86-'.$mainSku, '10-'.$mainSku, '42-'.$mainSku, '20-'.$mainSku, '28-'.$mainSku, '25-'.$mainSku );
942.                                 usort($productdetails[$product_id_to_process]['other_products'], function ($a, $b) use ($sortOrder) {
943.                                     $pos_a = array_search($a['sku_number'], $sortOrder);
944.                                     $pos_b = array_search($b['sku_number'], $sortOrder);
945.                                     return $pos_a - $pos_b;
946.                                 });
947.                                 
948.                             }
949.                             else{
950.                                 $productdetails[$product_id_to_process]['other_products'] = null;
951.                             }
953.                             // Update other Products
954.                             if(isset($productdetails[$product_id_to_process]['other_products']) && !empty($productdetails[$product_id_to_process]['other_products'])){
955.                                 foreach($productdetails[$product_id_to_process]['other_products'] as $otherProduct){
956.                                     if( $otherProduct['id'] == $product_id_to_process ){
957.                                         $this->productApiManager->updateSolrData($otherProduct['id'],$localization_to_update,$projectSetting['project_id'],$env, $instance_id,'delete');
958.                                     }
959.                                     else{
960.                                         $this->productApiManager->updateSolrData($otherProduct['id'],$localization_to_update,$projectSetting['project_id'],$env, $instance_id,'update');
961.                                     }
962.                                 }
963.                             }
964.                         }
965.                         // update main sku
966.                         // if($productdetails[$product_id_to_process]['basic_information']['sku_number']){
967.                         //     $sku_split = explode('-',$productdetails[$product_id_to_process]['basic_information']['sku_number']);
968.                         //     if(count($sku_split) == 2){
969.                         //         $productDetailArray =$this->productDetailManager->getProductDetailBySku($sku_split[1],$productdetails[$product_id_to_process]['supplier']['supplier_id'],$cultureCategory);
970.                         //         $this->productApiManager->updateSolrData($productDetailArray['product_id'],$localization_to_update,$projectSetting['project_id'],$env,'update');
971.                                 
972.                         //     }
973.                         // }
974.                     }else{
975.                         $this->productApiManager->updateSolrData($product_id_to_process,$localization_to_update,$projectSetting['project_id'],$env, $instance_id,'update');
976.                         $productdetails = $this->productDetailManager->getProductDetailById($product_id_to_process,$cultureCategory);
977.                         
978.                         // Update other Products
979.                         if(strpos($productdetails[$product_id_to_process]['basic_information']['sku_number'], '-') != false && isset($productdetails[$product_id_to_process]['other_products'])){
980.                             $main_sku = $productdetails[$product_id_to_process]['basic_information']['sku_number'];
981.                             $main_sku = explode('-', $main_sku); // get main sku
983.                             $mainSku = $main_sku[1];                 
984.                             if(isset($productdetails[$product_id_to_process]['other_products']) && is_array($productdetails[$product_id_to_process]['other_products'])){
985.                                 $sortOrder = array($mainSku, '80-'.$mainSku,'75-'.$mainSku, '76-'.$mainSku, '81-'.$mainSku,'82-'.$mainSku,'86-'.$mainSku, '10-'.$mainSku, '42-'.$mainSku, '20-'.$mainSku, '28-'.$mainSku, '25-'.$mainSku );
986.                                 usort($productdetails[$product_id_to_process]['other_products'], function ($a, $b) use ($sortOrder) {
987.                                     $pos_a = array_search($a['sku_number'], $sortOrder);
988.                                     $pos_b = array_search($b['sku_number'], $sortOrder);
989.                                     return $pos_a - $pos_b;
990.                                 });
991.                                 
992.                             }
993.                             else{
994.                                 $productdetails[$product_id_to_process]['other_products'] = null;
995.                             }
996.                         }
997.                         if(isset($productdetails[$product_id_to_process]['other_products']) && !empty($productdetails[$product_id_to_process]['other_products'])){
998.                             $index = 1;
999.                             $isFound = 0;
1000.                             $operation = 'update';
1001.                             foreach($productdetails[$product_id_to_process]['other_products'] as $otherProduct){
1002.                                 if($index == 1 && $otherProduct['id'] == $product_id_to_process){
1003.                                     $isFound = 1;
1004.                                     $operation = 'update';
1005.                                 }
1006.                                 elseif( $index > 1 && $otherProduct['id'] == $product_id_to_process){
1007.                                     $isFound = 1;
1008.                                     $operation = 'delete';
1009.                                 }
1010.                                 elseif($isFound == 1){
1011.                                     $operation = 'delete';
1012.                                 }
1013.                                 else{
1014.                                     $operation = 'update';
1015.                                 }
1016.                                 $this->productApiManager->updateSolrData($otherProduct['id'],$localization_to_update,$projectSetting['project_id'],$env, $instance_id,$operation);
1017.                                 if($operation == 'delete'){
1018.                                     $this->productApiManager->updateSolrData($otherProduct['id'],$localization_to_update,$projectSetting['project_id'],$env, $instance_id,'update');
1019.                                 }
1020.                                 $index++;
1021.                             }
1022.                         }
1023.                         
1024.                         // if($productdetails[$product_id_to_process]['basic_information']['sku_number']){
1025.                         //     $sku_split = explode('-',$productdetails[$product_id_to_process]['basic_information']['sku_number']);
1026.                         //     if(count($sku_split) == 2){
1027.                         //         $productDetailArray =$this->productDetailManager->getProductDetailBySku($sku_split[1],$productdetails[$product_id_to_process]['supplier']['supplier_id'],$cultureCategory);
1028.                         //         $this->productApiManager->updateSolrData($productDetailArray['product_id'],$localization_to_update,$projectSetting['project_id'],$env,'update');
1029.                         //     }
1030.                         // }
1031.                     }
1032.                 }
1033.             }
1034.             //SOLR SYNC CODE END
1035.             
1036.             // To Integrate with ERP
1037.             $productIds = json_decode($productId);
1038.             $erpIntegration = $projectSetting['configuration_rule']['erp_integration'];
1039.             if($erpIntegration && $erpIntegration['productManagement'] == 1 && !empty($this->queueApiManager)) {
1040.                 foreach ($productData['data'] as $key => $value) {
1041.                     $params = array('product_id' => $productIds[$key], 'country_id' => $value['countryId'],'status'=> $setStatus);
1042.                     $this->productApiManager->integrateWithErp($this->queueApiManager, 'updateStatus', $productIds[$key], $params);
1043.                 }
1044.             }
1045.             $data['status'] = 'success';
1046.             RedisCacheService::removeCacheByPrefix($this->statsh_cache_wrapper,$this->moduleCachePrefix);
1047.             
1048.         }else{
1049.             $data['status'] = 'error';
1050.         }
1051.         $data['message'] = $this->translator->trans('product.'.$productData['message']);
1052.         return new JsonResponse($data);
1053.     }
1054.     
1055.     // /**
1056.     //  * EMp Id : 4246
1057.     //  * Description : This Function is Used For Update Product Status According To Parameter
1058.     //  *
1059.     //  * @Route("/check-duplicate-sku",
1060.     //  * name="officebrain_product_check_duplicate_sku")
1061.     //  */
1062.     
1063.     #[Route(path: '/check-duplicate-sku', name: 'officebrain_product_check_duplicate_sku')]
1065.     public function checkDuplicateSKU(Request $request){
1066.         $this->init($request);
1067.         $sku = $this->request->get('sku');
1068.         $supplierId = $this->request->get('supplier_id');
1069.         $productId = $this->request->get('product_id','');
1070.         $data = $this->productApiManager->checkDuplicateSKU($sku,$supplierId,$productId);
1071.         $data['message'] = $this->translator->trans('product.'.$data['message']);
1072.         return new JsonResponse($data);
1073.     }
1074.     
1075.     // /**
1076.     //  * @author Employee Id: 5190
1077.     //  * Description : This function used for List Matrix Information
1078.     //  * @Route("/matrix/list",
1079.     //  * name="officebrain_product_matrix_list")
1080.     //  * @Template("OfficeBrain/Bundle/ProductBundle/ProductAdmin/listMatrix.html.twig")
1081.     //  */
1082.     
1083.     #[Route(path: '/matrix/list', name: 'officebrain_product_matrix_list')]
1084.     #[Template('OfficeBrain/Bundle/ProductBundle/ProductAdmin/listMatrix.html.twig')]
1086.     public function listMatrixAction(Request $request){
1087.         $this->init($request);
1088.         $projectSetting = $this->request->get('project_setting');
1089.         $projectId = $projectSetting['project_id'];
1090.         $data['matrix_data'] = $this->productApiManager->getMatrixList($projectId);
1091.         return array('data'=>$data);
1092.     }
1093.     
1094.     // /**
1095.     //  * @author Employee Id: 5540
1096.     //  *
1097.     //  * Description : This function used to Edit Product Information
1098.     //  * @return array
1099.     //  * @Route("/copy/{master_product_id}/{supplier_id}", name="officebrain_product_copy"),
1100.     //  * @Template("OfficeBrain/Bundle/ProductBundle/ProductAdmin/add.html.twig")
1101.     //  */
1103.     #[Route(path: '/copy/{master_product_id}/{supplier_id}', name: 'officebrain_product_copy')]
1104.     #[Template('OfficeBrain/Bundle/ProductBundle/ProductAdmin/add.html.twig')]
1106.     public function copyProductAction(Request $request)
1107.     {
1108.         //$this->init($request);
1109.         $supplierId = $request->get('supplier_id');
1110.         $productId = $request->get('master_product_id','');
1111.         $projectSetting = $request->get('project_setting');
1112.         // $returnData = $this->serviceContainer->get("office_brain_product_admin_manager")->copy($supplierId, $productId);
1113.         $returnData = $this->productApiManager->copy($supplierId, $productId);
1114.         $returnData = array('status' => 'success');
1115.          
1116.         /*
1117.         //SOLR SYNC CODE START
1118.             $is_solr_syn_enabled = $this->container->getParameter('solr_sync');
1119.                 if($is_solr_syn_enabled)
1120.                 {
1121.                 $env = $this->container->getParameter("kernel.environment");
1122.                 $localization_to_update = $this->container->getParameter('localization_to_fetch');
1123.                 $this->get("office_brain_product_admin_manager")->updateSolrData($newProductId,$localization_to_update,$projectSetting['project_id'],$env,$projectSetting['instance_id'],'update');
1124.             }
1125.         //SOLR SYNC CODE END
1126.         */
1127.          
1128.         if($returnData['status'] == 'success')
1129.         {
1130.             $data['status'] = 'success_message';
1131.             $data['message'] = $this->serviceContainer->get('translator')->trans('product_add_edit.product_copied_successfully');
1132.         }
1133.         else
1134.         {
1135.             $data['status'] = 'error_message';
1136.             $data['message'] = $this->serviceContainer->get('translator')->trans('product_add_edit.product_not_copied');
1137.         }
1138.          
1139.         return new JsonResponse($data);
1140.     }
1141.     
1142.     // /**
1143.     //  * @author Employee Id: 5190
1144.     //  *
1145.     //  * Description : This function used for Export Product data culture and country wise
1146.     //  * @return array
1147.     //  * @Route("/export", name="officebrain_product_export"),
1148.     //  * @Template("OfficeBrain/Bundle/ProductBundle/ProductAdmin/export.html.twig")
1149.     //  */
1150.     
1151.     #[Route(path: '/export', name: 'officebrain_product_export')]
1152.     #[Template('OfficeBrain/Bundle/ProductBundle/ProductAdmin/export.html.twig')]
1154.     public function exportAction(Request $request)
1155.     {
1156.         $this->init($request);
1157.         $projectSetting = $this->request->get('project_setting');
1158.         $projectId = $projectSetting['project_id'];
1159.         list($defaultCulture,$defaultCountry) = explode("_",$this->request->get("_locale"));
1160.         $culture = $this->request->get('language',$defaultCulture);
1161.         $country = $this->request->get('country',$defaultCountry);
1162.         $supplier_id = $this->request->query->get('supplier_id','');
1163.         $countryArray = $this->serviceContainer->getParameter('country');
1164.         $languageArray = $this->serviceContainer->getParameter('language');
1165.         $supplierData = $this->productApiManager->getSupplierNameList($projectId);
1166.         $instanceType = $projectSetting['instance_type'];
1167.         // if ($this->user->getUserType()=='admin' && $instanceType=='association'){ // symfony 4
1168.         if ($this->user && $this->user->getUserType()=='admin' && $instanceType=='association'){
1169.             $supplier_id = $this->request->query->get('supplier_id','');
1170.         // } else if($this->user && $this->user->getUserType()=='supplier' || $this->user->getUserType()=='distributor' || ($this->user->getUserType() == 'admin' && $instanceType == 'distributor') || ($this->user->getUserType() == 'admin' && $instanceType == 'supplier')){ // symfony 4
1171.         } elseif ($this->user && (
1172.             $this->user->getUserType() == 'supplier' || 
1173.             $this->user->getUserType() == 'distributor' || ( 
1174.                 $this->user->getUserType() == 'admin' && (
1175.                     $instanceType == 'distributor' || 
1176.                     $instanceType == 'supplier'
1177.                 ) 
1178.             ) 
1179.         ) ) {
1180.             $supplier_id = $this->user->getObCustomerId();
1181.             $supplier_id = str_replace(array('OB','ob'), '', $supplier_id);
1182.     
1183.             if(empty($supplier_id)){
1184.                 $supplier_id = 0;
1185.             }
1186.         }else{
1187.             $supplier_id = 0;
1188.         }
1189.     
1190.         foreach($countryArray as $countryKey => $country){
1191.             $data['country_data'][] = array('id'=>$country['id'],'code'=>$country['short_name'],'title'=>$country['name'],'language'=>$country['language']);
1192.         }
1193.     
1194.         if ($this->request->isXmlHttpRequest() && $this->request->getMethod()=='POST') {
1195.             $data = $this->request->request->all();
1196.             $apiResponse =  $this->productApiManager->getExportProduct($data);
1197.     
1198.             return new JsonResponse($apiResponse);
1199.         }
1200.         $data['project_id']= $projectId;
1201.         $data['country_array'] = $countryArray;
1202.         $data['language_data'] = $languageArray;
1203.         $data['supplier_data'] = $supplierData;
1204.         $data['INSTANCE_TYPE'] = $instanceType;
1205.         $data['supplier_id']=$supplier_id;
1206.     
1207.         return array('data'=>$data);
1208.     
1209.     }
1211.     // /**
1212.     //  * @author Employee Id: 5190
1213.     //  *
1214.     //  * Description : This function used for Import Product data supplier, culture and country wise
1215.     //  * @return array
1216.     //  * @Route("/import", name="officebrain_product_import"),
1217.     //  * @Template("OfficeBrain/Bundle/ProductBundle/ProductAdmin/import.html.twig")
1218.     //  */
1219.     
1220.     #[Route(path: '/import', name: 'officebrain_product_import')]
1221.     #[Template('OfficeBrain/Bundle/ProductBundle/ProductAdmin/import.html.twig')]
1222.     
1223.     public function importAction(Request $request){
1224.         $this->init($request);
1225.         $projectSetting = $this->request->get('project_setting');
1226.         $projectId = $projectSetting['project_id'];
1227.         list($defaultCulture,$defaultCountry) = explode("_",$this->request->get("_locale"));
1228.         $culture = $this->request->get('language',$defaultCulture);
1229.         $country = $this->request->get('country',$defaultCountry);
1230.         $supplier_id = $this->request->query->get('supplier_id','');
1231.         //echo $supplier_id;die;
1232.          
1233.         $countryArray = $this->serviceContainer->getParameter('country');
1234.         $languageArray = $this->serviceContainer->getParameter('language');
1235.     
1236.         $supplierData = $this->productApiManager->getSupplierNameList($projectId);
1237.         $instanceType = $projectSetting['instance_type'];
1239.         if ($this->user && $this->user->getUserType()=='admin' && $instanceType=='association'){
1240.             $supplier_id = $this->request->query->get('supplier_id','');
1241.         // } else if($this->user->getUserType()=='supplier' || $this->user->getUserType()=='distributor' || ($this->user->getUserType() == 'admin' && $instanceType == 'distributor') || ($this->user->getUserType() == 'admin' && $instanceType == 'supplier')){ // symfony 4
1243.         } elseif ($this->user && (
1244.             $this->user->getUserType() == 'supplier' || 
1245.             $this->user->getUserType() == 'distributor' || ( 
1246.                 $this->user->getUserType() == 'admin' && (
1247.                     $instanceType == 'distributor' || 
1248.                     $instanceType == 'supplier'
1249.                 ) 
1250.             ) 
1251.         ) ) {
1252.             $supplier_id = $this->user->getObCustomerId();
1253.             $supplier_id = str_replace(array('OB','ob'), '', $supplier_id);
1255.             if(empty($supplier_id)){
1256.                 $supplier_id = 0;
1257.             }
1258.         }else{
1259.             $supplier_id = 0;
1260.         }
1261.         foreach($countryArray as $countryKey => $country){
1262.             $data['country_data'][] = array('id'=>$country['id'],'code'=>$country['short_name'],'title'=>$country['name'],'language'=>$country['language']);
1263.         }
1264.     
1265.         if ($this->request->isXmlHttpRequest() && $this->request->getMethod()=='POST') {
1266.             $uploadImportFilePath = $this->serviceContainer->getParameter('tmp_image_upload_path');;
1267.             $allwedImportFileMimeType = $this->serviceContainer->getParameter('allowed_import_file_mime_type');
1268.             $translator = $this->serviceContainer->get('translator');
1269.             //echo $uploadImportFilePath;die;
1270.             if(!IS_DIR($uploadImportFilePath)){
1271.                 mkdir($uploadImportFilePath,0777,true);
1272.             }
1273.     
1274.             $importFileName = '';
1275.             $error = false;
1276.             $supplierId = $this->request->get('supplier_id','');
1277.             $countryId = $this->request->get('country_id','');
1278.             $cultureId = $this->request->get('culture_id','');
1279.             $userId = $this->userId;
1280.             //echo $supplierId.'---'.$countryId.'---'.$cultureId.'--'.$userId;die;
1281.             if(!empty($_FILES) && $countryId >0 && $cultureId >0 && $supplierId>0){
1282.                 foreach($_FILES as $file)
1283.                 {
1284.                     $filename = $file['name'];
1285.                     $extension = pathinfo($filename, PATHINFO_EXTENSION);
1286.                     if($extension != 'xls'){
1287.                         $error = true;
1288.                         $error_message = $translator->trans('product_import_export.allowed_import_file_type');
1289.                     }
1290.                     
1291.                     if(!$error){
1292.                         $importFileName = "import_supplierid_".$supplierId."_countryid_".$countryId."_cultureid_".$cultureId."_".time().".".$extension;
1293.                         $uploadImportFile = $uploadImportFilePath.$importFileName;
1294.                         $file_moved = @move_uploaded_file($file['tmp_name'], $uploadImportFile);
1295.                         
1296.                         if($file_moved){
1297.                             $response = $this->productApiManager->uploadImportFile($supplierId,$countryId,$cultureId,$projectId,$uploadImportFile,$uploadImportFilePath, $userId);
1298.                                                                     
1299.                             if($response['status'] == 'success'){
1300.                                 if(file_exists($uploadImportFile)){
1301.                                     @unlink($uploadImportFile);
1302.                                 }
1303.                                 $error = false;
1304.                                 $success_message = $translator->trans('product_import_export.import_process_start');
1305.                             }
1306.                             else{
1307.                                 $error = true;
1308.                                 $error_message = $translator->trans('product_import_export.file_upload_error_message');
1309.                             }
1310.                         }
1311.                         else {
1312.                             $error = true;
1313.                             $error_message = $translator->trans('product_import_export.file_upload_error_message'); 
1314.                         }
1315.                     }
1316.                 }
1317.             }
1318.  
1319.             
1320.             else{
1321.                 $error = true;
1322.                 $error_message = $translator->trans('product.file_not_found');   //"Please select file" ;
1323.             }
1324.     
1325.             if(!$error){
1326.                 $return = array (
1327.                         'status' => 'success',
1328.                         'success_message'=> $success_message,
1329.                 );
1330.             } else {
1331.                 $return = array (
1332.                         'status' => 'error',
1333.                         'error_message' => $error_message);
1334.             }
1335.     
1336.             return new JsonResponse($return);
1337.         }
1338.     
1339.         $data['country_array'] = $countryArray;
1340.         $data['language_data'] = $languageArray;
1341.         $data['supplier_data'] = $supplierData;
1342.         $data['INSTANCE_TYPE'] = $instanceType;
1343.         $data['supplier_id']=$supplier_id;
1344.     
1345.         return array('data'=>$data);
1346.     
1347.     }
1348.     
1349.     // /**
1350.     //  * @author Employee Id: 5190
1351.     //  *
1352.     //  * Description : This function used for Import Product data supplier, culture and country wise
1353.     //  * @return array
1354.     //  * @Route("/check_import_status", name="officebrain_product_check_import_status"),
1355.     //  * options={"expose"=true},
1356.     //  * @Template("OfficeBrain/Bundle/ProductBundle/ProductAdmin/checkImportStatus.html.twig")
1357.     //  */
1358.     
1359.     #[Route(path: '/check_import_status', name: 'officebrain_product_check_import_status', options: ['expose' => true])]
1360.     #[Template('OfficeBrain/Bundle/ProductBundle/ProductAdmin/checkImportStatus.html.twig')]
1361.     
1362.     public function checkImportStatusAction(Request $request){
1363.         $this->init($request);
1364.         $supplierId = $request->get('supplier_id');
1365.         $projectSetting = $this->request->get('project_setting');
1366.         $projectId = $projectSetting['project_id'];
1367.     
1368.         $returnData = $this->productApiManager->checkImportStatus($supplierId,$projectId);
1369.     
1370.         return array('data'=>$returnData);
1371.     
1372.     }
1373.     
1374.     // /**
1375.     //  * @author Employee Id: 5190
1376.     //  *
1377.     //  * Description : This function used for add inventory message sku colour wise
1378.     //  * @return array
1379.     //  * @Route("/get-inventory-message/{sku}", name="officebrain_product_add_inventory_message"),
1380.     //  * options={"expose"=true},
1381.     //  */
1382.     
1383.     #[Route(path: '/get-inventory-message/{sku}', name: 'officebrain_product_add_inventory_message', options: ['expose' => true])]
1385.     public function addInventoryMessageAction(Request $request){
1386.         $this->init($request);
1387.         $sku = $request->get('sku');
1388.         $data = json_encode(array('message'=>'','sku'=>$sku));
1389.         $obj = $this->productApiManager->getInvMessageBySku($sku);
1390.         //var_dump($obj); die;
1391.         if(count($obj)>0){ 
1392.             $data =  json_encode(array('message'=>$obj[0]->getMessage(),'sku'=>$obj[0]->getProductSku()));
1393.         }
1394.         echo $data;
1395.         die;  
1396.         //$this->productApiManager;
1397.     }
1398.     
1399.     // /**
1400.     //  * @author Employee Id: 5190
1401.     //  *
1402.     //  * Description : This function used for add inventory message sku colour wise
1403.     //  * @return array
1404.     //  * @Route("/add-inventory-message", name="officebrain_product_update_inventory_message"),
1405.     //  * options={"expose"=true},
1406.     //  */
1407.     
1408.     #[Route(path: '/add-inventory-message', name: 'officebrain_product_update_inventory_message', options: ['expose' => true])]
1410.     public function updateInventoryMessageAction(Request $request){
1411.         $this->init($request);
1412.         $parameters = $request->request->all();
1413.         /*if($parameters['inv_message']==""){
1414.          $data = json_encode(array('status'=>'error_message','message'=>'Enter Message'));
1415.          }else{*/
1416.         $object = null;
1417.         $message = $parameters['inv_message'];
1418.         $sku = $parameters['inv_sku'];
1419.         $obj = $this->productApiManager->getInvMessageBySku($sku);
1420.         if(count($obj)>0){
1421.             $object = $obj[0];
1422.         }
1423.         $this->productApiManager->updateMessage($object,$message,$sku);
1424.         $data = json_encode(array('status'=>'success_message','message'=>'Message added successfully'));
1425.         //}
1426.         echo $data;
1427.         die;
1428.     }
1429.     // /**
1430.     //  * @author Employee Id: 5190
1431.     //  *
1432.     //  * Description : This function used for get importErrorLog using importId.
1433.     //  * @return array
1434.     //  * @Route("/import_error_log/{import_id}", name="officebrain_product_import_error_log"),
1435.     //  * @Template("")
1436.     //  */
1437.     
1438.     #[Route(path: '/import_error_log/{import_id}', name: 'officebrain_product_import_error_log')]
1439.     #[Template('')]
1440.     
1441.     public function importErrorLogAction(Request $request){
1442.         $this->init($request);
1443.         $importId = $request->get('import_id');
1444.         $returnData = $this->productApiManager->importErrorLog($importId);
1445.         $filename = "import_error_log_" . $importId.".csv";
1446.         $response = $this->render('OfficeBrain/Bundle/ProductBundle/ProductAdmin/importErrorLog.csv.twig',array('data' => $returnData));
1447.         //$response->setStatusCode(200);
1448.         $response->headers->set('Content-Type', 'text/csv');
1449.         $response->headers->set('Content-Disposition', 'attachment; filename="'.$filename.'"');
1450.         $response->headers->set('Pragma', 'no-cache');
1451.         $response->headers->set('Expires', '0');
1452.         //$response->sendHeaders();
1453.         //$response->sendContent();
1454.         return $response;
1455.     
1456.         //return array('data'=>$returnData);
1457.     }
1458.     
1459.     
1460.     // /**
1461.     //  * @Route("/suggestedProduct/{id}",
1462.     //  * name="officebrain_product_bundle_get_suggested_product",
1463.     //  * options={"expose"=true}, methods={"GET"})
1464.     //  */
1465.     
1466.     #[Route(path: '/suggestedProduct/{id}', name: 'officebrain_product_bundle_get_suggested_product', options: ['expose' => true], methods: ['GET'])]
1467.     public function getSuggestedProductByProductIdAction(Request $request, $id){
1468.         $this->init($request);
1469.         $data = $this->productApiManager->getSuggestedProductByProductId($id);
1470.         
1471.         return new JsonResponse($data);
1472.     }
1473.     
1474.     // /**
1475.     //  * @Route("/suggestedProduct/{id}",
1476.     //  * name="officebrain_product_bundle_set_suggested_product",
1477.     //  * options={"expose"=true}, methods={"POST"})
1478.     //  */
1479.     
1480.     #[Route(path: '/suggestedProduct/{id}', name: 'officebrain_product_bundle_set_suggested_product', options: ['expose' => true], methods: ['POST'])]
1482.     public function setSuggestedProductByProductIdAction(Request $request, $id){
1483.         $this->init($request);
1484.         $pmsId = $id;
1485.         $productsSku = $this->request->get('products_sku');
1486.         //         $products =
1487.         $api_manager = $this->serviceContainer->get('officebrain_category_api_manager');
1488.         $data = $this->productApiManager->setSuggestedProductByProductId($pmsId,$productsSku);
1489.         $data['message'] = $this->translator->trans($data['message']);
1490.         return new JsonResponse($data);
1491.     }
1492.     
1493.     // /**
1494.     //  * @author Employee Id: 5429
1495.     //  *
1496.     //  * Description : This function used for add inventory message sku colour wise
1497.     //  * @return array
1498.     //  * @Route("/get-rsync-status/{sku}/{slug}", name="officebrain_product_rsync_check"),
1499.     //  * options={"expose"=true},
1500.     //  */
1501.     
1502.     #[Route(path: '/get-rsync-status/{sku}/{slug}', name: 'officebrain_product_rsync_check', options: ['expose' => true])]
1503.     public function getRsyncStatusAction(Request $request){
1504.         $this->init($request);
1505.         $sku = $request->get('sku');
1506.         $slug = $request->get('slug');
1507.         $this->productDetailManager->updateSyncDetail(1,$sku);
1509.         //$asiurl = 'http://demoapi.officebrain.com/update_product_api.php?product_slug=16-oz-victory-acrylic-tumbler-with-straw-lid-full-color-digital';
1510.         //$result = exec("curl '$asiurl' > /dev/null &",$output,$return_val);
1511.         $asiurl = 'https://demoapi.officebrain.com/update_product_api.php?product_slug='.$slug;
1512.        //$asiurl = 'http://demoapi.officebrain.com/update_product_api.php?product_slug=halcyon-r-waterproof-wireless-speaker-full-color-digital';
1513.       
1514.         $curl = curl_init();
1515.         curl_setopt_array($curl, array(
1516.           CURLOPT_URL => $asiurl,
1517.           CURLOPT_RETURNTRANSFER => true,
1518.           CURLOPT_ENCODING => '',
1519.           CURLOPT_MAXREDIRS => 10,
1520.           CURLOPT_TIMEOUT => 0,
1521.           CURLOPT_FOLLOWLOCATION => true,
1522.           CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
1523.           CURLOPT_CUSTOMREQUEST => 'GET',
1524.           CURLOPT_SSL_VERIFYPEER =>0
1525.         ));
1526.         $response = curl_exec($curl); 
1527.         if (curl_errno($curl)) {
1528.             echo $error_msg = curl_error($curl); die;
1529.         }
1530.         curl_close($curl); 
1531.         echo $response;
1534.        /* $result = exec("curl '$asiurl' 2>&1 &", $output);
1535.         if(isset($output[3]) && $output[3]!=''){
1536.             $msg = json_decode($output[3]);
1537.             $reason = $msg->Errors[0]->Reason;
1538.             $data = json_encode(array('status'=>'success_message','message'=>'Reason:'.$reason));
1539.         }else{
1540.             $data = json_encode(array('status'=>'success_message','message'=>'Product Sync Successfully'));
1541.         }*/
1542.        // echo $data;
1543.         die;
1544.     }
1545.     
1546.     // /**
1547.     //  * @author Employee Id: 5429
1548.     //  *
1549.     //  * Description : This function used for add imprint method on skus
1550.     //  * @return array
1551.     //  * @Route("/imprint-skus", name="officebrain_imprint_skus_product"),
1552.     //  * @Template("OfficeBrain/Bundle/ProductBundle/ProductAdmin/getImprintSkus.html.twig")
1553.     //  */
1554.     
1555.     #[Route(path: '/imprint-skus', name: 'officebrain_imprint_skus_product')]
1556.     #[Template('OfficeBrain/Bundle/ProductBundle/ProductAdmin/getImprintSkus.html.twig')]
1557.     
1558.     public function getImprintSkusAction(Request $request){
1559.         $searchParameters = array();
1560.         // $productTagManager = $this->serviceContainer->get('office_brain_product_tag_manager');
1561.         $productTagManager = $this->productTagManager;
1562.         if(!empty($_REQUEST['sku']) && $_REQUEST['sku']!=""){
1563.             $culture = $request->get('_locale','en_us');
1564.             // $productDetailManager = $this->serviceContainer->get('office_brain_product_detail_manager');
1565.             $productDetailManager = $this->productDetailManager;
1566.             $productObj = $productDetailManager->getProductDetailBySku($_REQUEST['sku'], 5,$culture,false);
1567.             if(isset($productObj['product_id'])){
1568.                 $data['product_id'] = $productObj['product_id'];
1569.                 $data['imprint'] = $_REQUEST['imprint'];
1570.                 $data['sku'] = $productObj['basic_information']['sku_number'];
1571.                 $data['product_title'] = $productObj['basic_information']['title'];
1572.                 $data['product_image'] = $productObj['basic_information']['default_image_thumb_url'];
1573.                 $productImprint = $productTagManager->getImprintProductByIdAndMethod($data['product_id'],$data['imprint']);
1574.                 if($productImprint==NULL){
1575.                     $productTagManager->addImprintProduct($data);
1576.                      //SOLR SYNC CODE START
1577.                     // $productApiManager = $this->serviceContainer->get("office_brain_product_admin_manager");
1578.                     $productApiManager = $this->productApiManager;
1579.                     $is_solr_syn_enabled = $this->serviceContainer->getParameter('solr_sync');
1580.                     if($is_solr_syn_enabled){
1581.                         $env = $this->serviceContainer->getParameter("kernel.environment");
1582.                         $localization_to_update = $this->serviceContainer->getParameter('localization_to_fetch');
1583.                         $productApiManager->updateSolrData($data['product_id'],$localization_to_update,5,$env,'update');
1584.                     }
1585.                     
1586.                     //SOLR SYNC CODE END
1587.                 
1588.                     $this->request->getSession()->getflashbag()->add('success_message', 'Sku mapped successfully.');
1589.                 }else{
1590.                     $this->request->getSession()->getflashbag()->add('error_message', 'Sku already mapped.');
1591.                     return $this->redirect($this->generateUrl('officebrain_imprint_skus_product'));
1592.                 }
1593.             }
1594.                 
1595.         }
1596.         $searchParameters['search_result_array']['data'] = $productTagManager->getAllImprintProducts();
1597.         // $this->arrayToPaginationManager = $this->serviceContainer->get('office_brain_array_to_pagination_manager');
1598.         $this->arrayToPaginationManager = $this->arrayToPaginationManager;
1599.         if(!empty($searchParameters['search_result_array'])){
1600.             $this->arrayToPaginationManager->setPaginationArray($searchParameters['search_result_array']);
1601.             $this->arrayToPaginationManager->doConvert();
1602.             $searchParameters['pagination'] = $this->arrayToPaginationManager->getPagination();
1603.         }
1604.         return $searchParameters;
1605.     }
1606.     
1607.     // /**
1608.     //  * @author Employee Id: 5429
1609.     //  *
1610.     //  * Description : This function used for add imprint method on skus
1611.     //  * @return array
1612.     //  * @Route("/remove-imprint-skus/{id}", name="officebrain_product_remove_imprint_skus"),
1613.     //  */
1614.     
1615.     #[Route(path: '/remove-imprint-skus/{id}', name: 'officebrain_product_remove_imprint_skus')]
1617.     public function removeImprintSkusAction(Request $request){
1618.         $id = $request->get('id');
1619.         $productTagManager = $this->productTagManager;
1620.         $prodData = $productTagManager->getImprintProductById($id);
1621.         if($prodData!=NULL){
1622.              $productId = $prodData->getProductId();
1623.              $productTagManager->deleteImprintProductById($prodData);
1624.               //SOLR SYNC CODE START
1625.                     // $productApiManager = $this->serviceContainer->get("office_brain_product_admin_manager");
1626.                     $productApiManager = $this->productApiManager;
1627.                     $is_solr_syn_enabled = $this->serviceContainer->getParameter('solr_sync');
1628.                     if($is_solr_syn_enabled){
1629.                         $env = $this->serviceContainer->getParameter("kernel.environment");
1630.                         $localization_to_update = $this->serviceContainer->getParameter('localization_to_fetch');
1631.                         $productApiManager->updateSolrData($productId,$localization_to_update,5,$env,'update');
1632.                     }
1633.                     
1634.                     //SOLR SYNC CODE END
1635.              $this->request->getSession()->getflashbag()->add('success_message', 'Record deleted successfully.');
1636.         }else{
1637.             $this->request->getSession()->getflashbag()->add('error_message', 'no record found');
1638.         }
1639.         return $this->redirect($this->generateUrl('officebrain_imprint_skus_product'));
1640.     }
1641.     
1642. }