src/project/OfficeBrain/CustomBundle/ProductBundle/Controller/ProductController.php line 963

Open in your IDE?
  1. <?php
  2. namespace App\project\OfficeBrain\CustomBundle\ProductBundle\Controller;
  4. use Symfony\Bundle\FrameworkBundle\Controller\Controller;
  5. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Route;
  6. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Template;
  7. use App\OfficeBrain\Bundle\ProductBundle\Controller\ProductController as BaseProductController;
  8. use Symfony\Component\HttpFoundation\Response;
  9. use DateTime;
  10. use App\OfficeBrain\Bundle\CoreBundle\Cache\RedisCacheService;
  11. use Symfony\Component\HttpFoundation\JsonResponse;
  12. use Aws\S3\S3Client;
  13. use Aws\Credentials\Credentials as Credentials;
  14. use Symfony\Component\HttpFoundation\Request;
  15. use Symfony\Component\DependencyInjection\ContainerInterface as Container;
  16. use App\OfficeBrain\Bundle\ProductBundle\Manager\Service\ProductAdminManager;
  17. use App\OfficeBrain\Bundle\EmailBundle\Manager\Service\EmailService;
  18. use App\OfficeBrain\Bundle\ProductTagBundle\Manager\Service\ProductTagManager;
  19. use App\project\OfficeBrain\CustomBundle\ProductBundle\Manager\Service\ProductDetailService as CustomProductDetailService;
  20. use App\OfficeBrain\Bundle\ProductBundle\Manager\Service\ProductDetailService;
  21. use App\OfficeBrain\Bundle\SearchBundle\Manager\Service\SearchManager;
  22. use App\OfficeBrain\Bundle\SolrBundle\Manager\Service\SolrService;
  23. use Symfony\Component\Routing\RouterInterface;
  24. use Symfony\Component\HttpFoundation\RequestStack;
  25. use Symfony\Component\Validator\Validator\ValidatorInterface;
  27. /**
  28.  *
  29.  * @author Employee Id: 4464
  30.  *        
  31.  *         To create custom code
  32.  *        
  33.  * @return NULL
  34.  *
  35.  * @Route("/{_locale}")
  36.  */
  37. class ProductController extends BaseProductController
  38. {
  40.     /**
  41.      *
  42.      * @author Employee Id: 4464
  43.      *        
  44.      *         To set member variables default value
  45.      *        
  46.      * @return NULL
  47.      *
  48.      */
  49.     public function __construct(Container $serviceContainer, SearchManager $searchManager, CustomProductDetailService $customProductDetailService, EmailService $emailService, ProductAdminManager $productAdminManager, SolrService $solrService, RouterInterface $router, ValidatorInterface $validator, RequestStack $requestStack, ProductTagManager $productTagManager, ProductDetailService $productDetailService)
  50.     {
  51.         parent::__construct($serviceContainer, $searchManager, $productDetailService, $emailService, $productAdminManager, $solrService, $router, $validator, $requestStack);
  52.         $this->statsh_cache_wrapper = RedisCacheService::create();
  53.         $this->moduleCachePrefix = '__RelatedProducts__';
  54.         $this->wasabiCredentials = new Credentials('RXKLAMY4M3FSY3XXR2AW', 'Xh9z0rX7EFPLrBlcpM5ec5DpJ3rRndwGz93K8w4O');
  55.         
  56.         $this->s3Client = new S3Client([
  57.             'endpoint' => 'http://s3.us-west-1.wasabisys.com',
  58.             'region' => 'us-west-1',
  59.             'version' => 'latest',
  60.             'credentials' => $this->wasabiCredentials
  61.         ]);
  62.         
  63.         $this->productApiManager = $productAdminManager;
  64.         $this->productDetailManager = $customProductDetailService->getProductApiExtended(); // 
  65.         $this->productTagManager = $productTagManager->getProductTagManagerExtended(); // symfony 4
  66.         $this->emailService = $emailService->getEmailExtended();
  67.         $this->wasabiBucket = 'ob-aakronftp';
  68.         
  69.         
  70.         
  71.     }
  73.     /**
  74.      *
  75.      * @author Employee Id: 4464
  76.      *        
  77.      *         To unseset member variables
  78.      *        
  79.      * @return NULL
  80.      */
  81.     public function __destruct()
  82.     {
  83.         parent::__destruct();
  84.     }
  86.     /**
  87.      *
  88.      * @author Employee Id: 4464
  89.      *        
  90.      *         To Initialize the member variables
  91.      *        
  92.      * @return NULL
  93.      */
  94.     public function initAction(Request $request)
  95.     {
  96.         parent::initAction($request);
  97.         // $this->productDetailManager = $this->serviceContainer->get('office_brain_product_detail_manager_custom'); // project\OfficeBrain\CustomBundle\ProductBundle\Manager\Extended\ProductApiExtended
  98.         $this->productDetailManager = $this->productDetailManager; // project\OfficeBrain\CustomBundle\ProductBundle\Manager\Extended\ProductApiExtended
  99.         // $this->productApiManager = $this->serviceContainer->get("office_brain_product_admin_manager");
  100.         $this->productApiManager = $this->productApiManager;
  101.         // $this->productTagManager = $this->serviceContainer->get('office_brain_product_tag_manager'); // symfony 4
  102.         $this->productTagManager = $this->productTagManager; // symfony 4
  103.         // $this->productTagManager = $this->get('office_brain_private_tag_extended');
  104.         $this->categoryApi = $this->serviceContainer->get("officebrain_category_api");
  105.         $this->userId = $this->projectSetting['user_id'];
  106.         // $this->emailService = $this->serviceContainer->get('office_brain_email_service');
  107.         $this->emailService = $this->emailService;
  108.         $this->languageId = $this->projectSetting['culture_id'];
  109.     }
  111.     /**
  112.      *
  113.      * @author Employee Id: 4464
  114.      *        
  115.      *         Product Detail data.
  116.      *        
  117.      * @param
  118.      *            string product slug
  119.      *            
  120.      * @return product detail information
  121.      *        
  122.      * @Route("/similar-sku/{productSku}",name="officebrain_product_bundle_similarproductsku", methods={"GET"})
  123.      *
  124.      * @Template()
  125.      *
  126.      */
  127.     public function similarProductSkuAction(Request $request)
  128.     {
  129.         $this->initAction($request);
  130.         $this->responseArray['similarSkuProducts'] = null;
  131.         $productSku = $orgProductSKU = $this->request->get('productSku', null);
  132.         $productSku = explode('-', $productSku);
  133.         if (is_array($productSku)) {
  134.             if (count($productSku) > 1) {
  135.                 // PATCH: For SKUs with closeout. Eg. 1234-Closeout
  136.                 if (strtolower($productSku[1]) == 'closeout') {
  137.                     unset($productSku[1]);
  138.                 } else {
  139.                     // unset($productSku[0]);
  140.                     $productSku = (array) $productSku[count($productSku) - 1];
  141.                 }
  142.             }
  143.             $productSku = implode('-', $productSku);
  144.             $similarSkuProducts = $this->productDetailManager->getSimilarSku($productSku);
  145.             $this->responseArray['productSku'] = $orgProductSKU;
  146.             $this->responseArray['similarSkuProducts'] = $similarSkuProducts['search_result_array']['data'];
  147.         }
  148.         return $this->responseArray;
  149.     }
  151.     /**
  152.      *
  153.      * @author Employee Id: 5460
  154.      *        
  155.      * @param
  156.      *            product_id.
  157.      *            
  158.      * @return Response
  159.      *
  160.      * @Route("/general-conformity-certificate/{product_sku}",
  161.      *     name="officebrain_custombundle_productbundle_productdetail_gcc", options={"expose"=true}
  162.      * )
  163.      *
  164.      * @Template("project/OfficeBrain/CustomBundle/ProductBundle/Product/generalConformityCertificate.html.twig")
  165.      */
  166.     public function generalConformityCertificateAction(Request $request, $product_sku)
  167.     {
  168.            /*$resp = $this->s3Client->listObjects([
  169.                  'Bucket' => $this->wasabiBucket,
  170.                  'Range' => 'bytes=0-9',
  171.                  
  172.              ]);
  173.              echo "Succeed in retrieving bucket ACL as follows: \n";
  174.              echo "<pre>";print_r($resp->get('Contents')); 
  175.              //$search = 'Chem_Tests/'.$product_sku.'*'
  176.              //print_r( array_key_exists_wildcard( $array, $search ) );
  177.              
  178.              die;  
  179.              */
  180.          
  181.         $this->initAction($request);
  183.         $this->responseArray['gccData'] = $this->productDetailManager->getProductgeneralConformityCertificate($product_sku);
  184.         $this->responseArray['gccData'] = $this->productDetailManager->updateColorTestResultURLs($this->responseArray['gccData'],$this->s3Client);
  185.         // print_r($this->responseArray['gccData']);die;
  186.         $this->responseArray['productSku'] = $product_sku;
  188.         return $this->responseArray;
  189.     }
  191.     /**
  192.      *
  193.      * @author Employee Id: 5460
  194.      *        
  195.      *         Desciption: print detail of general conformity certificate
  196.      *        
  197.      * @param
  198.      *            product_id.
  199.      *            
  200.      * @return Response
  201.      *
  202.      * @Route("/general-conformity-certificate-print/{product_sku}",
  203.      *     name="officebrain_custombundle_productbundle_productdetail_gcc_print"
  204.      * )
  205.      *
  206.      * @Template("project/OfficeBrain/CustomBundle/ProductBundle/Product/generalConformityCertificatePrint.html.twig")
  207.      */
  208.     public function generalConformityCertificatePrintAction(Request $request, $product_sku)
  209.     {
  210.         
  211.         $this->initAction($request);
  212.         $this->responseArray['gccData'] = $this->productDetailManager->getProductGeneralConformityCertificate($product_sku);
  213.         $this->responseArray['productSku'] = $product_sku;
  214.         return $this->responseArray;
  215.     }
  217.     /**
  218.      *
  219.      * @author Employee Id: 5460
  220.      *        
  221.      * Desciption: download pdf of general conformity certificate
  222.      *        
  223.      * @param
  224.      * product_id.
  225.      *            
  226.      * @return Response
  227.      *
  228.      * @Route("/general-conformity-certificate-pdf/{product_sku}",
  229.      *     name="officebrain_custombundle_productbundle_productdetail_gcc_pdf"
  230.      * )
  231.      */
  232.     public function generalConformityCertificatePdfAction(Request $request, $product_sku)
  233.     {
  234.         $response_array = $this->generalConformityCertificatePrintAction($product_sku);
  235.         $response = $this->render('OfficeBrainCustomBundleProductBundle:Product:generalConformityCertificatePrint.html.twig', $response_array);
  237.         return new Response($this->get('knp_snappy.pdf')->getOutputFromHtml($response->getContent()), 200, array(
  238.             'Content-Type' => 'application/pdf',
  239.             'Content-Disposition' => 'attachment; filename="' . $product_sku . '-gcc.pdf"'
  240.         ));
  241.     }
  243.     /**
  244.      *
  245.      * @author Employee Id: 5460
  246.      *        
  247.      *         Desciption: download pdf of general conformity certificate test result
  248.      *        
  249.      * @param
  250.      *            product_id.
  251.      *            
  252.      * @return Response
  253.      *
  254.      * @Route("/general-conformity-certificate-test-result-pdf/{test_report_file_name}",
  255.      *     name="officebrain_custombundle_productbundle_productdetail_gcc_test_result_pdf"
  256.      * )
  257.      */
  258.     public function downloadTestResultPdfAction(Request $request, $test_report_file_name)
  259.     {
  260.         
  261.         try {
  262.             
  263. //             $resp = $this->s3Client->listObjects([
  264. //                 'Bucket' => $this->wasabiBucket,
  265. //                 'key' => "Chem_Tests/01300-30619 Blue PO#47740.pdf",
  266. //                 'Range' => 'bytes=0-9',
  267. //             ]);
  268.             $resp = $this->s3Client->getObject([
  269.                  'Bucket' => $this->wasabiBucket,
  270.                 'Key' => 'Chem_Tests/'.$test_report_file_name,
  271.              ]);
  272. //             echo "Succeed in retrieving bucket ACL as follows: \n";exit;
  273. //             echo "<pre>";print_r($resp['Body']);exit;
  274.             return new Response($resp['Body'], 200, array(
  275.                 'Content-Type' => 'application/pdf',
  276.                 'Content-Disposition' => 'attachment;'
  277.             ));
  278.             //    header("Content-Type: {$result['ContentType']}");
  279.             //    echo $result['Body'];
  280.         } catch (\Exception $e) {
  281. //             die('error');
  282.             // output error message if fails
  283.             return new JsonResponse($e->getMessage());
  284.         }
  285. //         $downloadTestResultBaseUrl = $this->container->getParameter('download_test_result.base_url');
  286. //         $downloadTestResultPDFUrl = $downloadTestResultBaseUrl . "/" . $test_report_file_name;
  288. //         return new Response(file_get_contents($downloadTestResultPDFUrl), 200, array(
  289. //             'Content-Type' => 'application/pdf',
  290. //             'Content-Disposition' => 'attachment;'
  291. //         ));
  292.     }
  293.     
  294.     
  295.      /**
  296.      * @Route("/product/estimator",
  297.      *     name="officebrain_product_bundle_product_detail_estimator", methods={"GET"}
  298.      * )
  299.      *
  300.      * @Template("OfficeBrain/Bundle/ProductBundle/Product/productDetailEstimator.html.twig")
  301.      *
  302.      */
  303.     public function productDetailEstimatorAction(Request $request)
  304.     {
  305.         $this->initAction($request);
  306.         $sku = $this->request->get('sku_number', null);
  307.         return array('sku_number' => $sku);
  308.     }
  309.     
  310.     /**
  311.      *
  312.      * @author Employee Id: 4532
  313.      *        
  314.      *         Product Detail data.
  315.      *        
  316.      * @param
  317.      *            string product slug
  318.      *            
  319.      * @return product detail information
  320.      *        
  321.      * @Route("/product/{productSlug}",
  322.      *     name="officebrain_product_bundle_product_detail",
  323.      *  defaults={"main_image_url"=null}, methods={"GET"}
  324.      * )
  325.      *
  326.      * @Template("OfficeBrain/Bundle/ProductBundle/Product/productDetail.html.twig")
  327.      *
  328.      */
  329.     public function productDetailAction(Request $request, $productSlug)
  330.     {   
  331. //         $credentials = new Aws\Credentials\Credentials('RXKLAMY4M3FSY3XXR2AW', 'Xh9z0rX7EFPLrBlcpM5ec5DpJ3rRndwGz93K8w4O');
  332.         
  333. //         $s3Client = new S3Client([
  334. //             'endpoint' => 'http://s3.us-west-1.wasabisys.com',
  335. //             'region' => 'us-west-1',
  336. //             'version' => 'latest',
  337. //             'credentials' => $credentials
  338. //         ]);
  339.         
  340. //         $bucket = 'ob-aakronftp';
  341.         
  342. //         try {
  343.             
  344. //             $resp = $s3Client->listObjects([
  345. //                 'Bucket' => $bucket,
  346. //                 'Range' => 'bytes=0-9',
  347. //             ]);
  348. //             /* $resp = $s3Client->getObject([
  349. //              'Bucket' => $bucket,
  350. //              'Key' => 'Chem_Tests/# 47910 Halycon Bottle FDA.pdf'
  351. //              ]);*/
  352. //             echo "Succeed in retrieving bucket ACL as follows: \n";
  353. //             echo "<pre>";print_r($resp);
  354. //             //    header("Content-Type: {$result['ContentType']}");
  355. //             //    echo $result['Body'];
  356. //         } catch (AwsException $e) {
  357. //             // output error message if fails
  358.             
  359. //             echo $e->getMessage();
  360. //             echo "\n";
  362.         // At start of script
  363.         //$time_start = microtime(true);
  364.        // echo 'Total execution time in seconds: ' . (microtime(true) - $time_start);
  365.         // Anywhere else in the script
  366.         
  367. //         }
  368.             
  370.         $this->initAction($request);
  371.         
  372.         if (is_numeric($productSlug)) {
  373.             $productDetailArrayId = $this->productDetailManager->getProductDetailById($productSlug, $this->cultureCode);
  374.             $this->responseArray = $productDetailArrayId[$productSlug];
  375.         } else {
  376.             $this->responseArray = $this->productDetailManager->getProductDetailBySlug($productSlug, $this->cultureCode);
  377.         }
  378.         if ($this->responseArray == null) {
  379.             /* if no product found Through exception */
  380.             throw $this->createNotFoundException($this->translator->trans('transaction.page_not_found.detail'));
  381.         } // elseif(($this->responseArray['basic_information']['active'] != 1 && $this->responseArray['basic_information']['active'] != true) || ($this->responseArray['is_deleted'] != 1 && $this->responseArray['is_deleted'] != false) ){
  382.         elseif (($this->responseArray['basic_information']['active'] != 1 && $this->responseArray['basic_information']['active'] != true) || ($this->responseArray['is_deleted'] != false)) {
  383.             throw $this->createNotFoundException($this->translator->trans('transaction.page_not_found.detail'));
  384.         }
  385.         /* ------------ Cache Code For Product Details Page -------------- */
  386.         $productId = $this->responseArray['product_id'];
  387.         $isUserLoggedIn = $this->userId>0?"_not_login":"_loggedin_";
  388.         $this->moduleCachePrefix = '__ProductDetailsPageOtherProducts__';
  389.         $locale = $this->request->getLocale();
  390.         $cacheSiteKey = array(
  391.             $this->moduleCachePrefix,
  392.             "product_id#" . $productId,
  393.             $locale,
  394.             $isUserLoggedIn,
  395.             $this->projectSetting['instance_id'],
  396.             // $this->container->getParameter('kernel.environment') // symfony 4
  397.             $this->projectSetting['kernelEnvironment']
  398.         );
  399.         $cacheKey = RedisCacheService::generateKey($this->statsh_cache_wrapper, $cacheSiteKey);
  400.         $cacheData = RedisCacheService::getCacheData($this->statsh_cache_wrapper, $cacheKey);
  401.         if ($cacheData) {
  402.             /** Update Cache data for Flyer and Image */
  403.             $productSKU = $cacheData['basic_information']['sku_number'];
  404.             $supplierId = $cacheData['supplier']['supplier_id'];
  405.             $downloadImageRelativePath = $this->serviceContainer->getParameter('product_image.zip_path');
  406.             $blankFileFullPath = $downloadImageRelativePath.$supplierId.'/blank-images/'.$productSKU.'.zip';
  407.             $cacheData['download_blank_image_status'] = file_exists($blankFileFullPath)?1:0;
  409.             $downloadPdfRelativePath = $this->serviceContainer->getParameter('product_pdf.flyer_path');
  410.             $pdfFileFullPath = $downloadPdfRelativePath.$supplierId.'/flyers/'.$productSKU.'.pdf';
  411.             $cacheData['download_flyer_status'] = file_exists($pdfFileFullPath)?1:0;
  412.             //    return $cacheData;
  413.         }
  414.         /* ------------ EO: Cache Code For Product Details Page -------------- */
  416.         // feature details - made array for simply access
  417.         $featuresDetail = [];
  418.         $this->responseArray['isPackagingOpt'] = false;
  419.         $this->responseArray['isUsaConnect'] = 0;
  420.         foreach ($this->responseArray['feature_details'] as $feature) {
  421.             if($feature['label']=='Packaging Options'){
  422.                 $this->responseArray['isPackagingOpt'] = true;
  423.             }
  424.             if($feature['label']=='is_usa_connect' && !empty($feature['value'])){
  425.                 $this->responseArray['isUsaConnect'] = 1;
  426.             }
  427.             $featuresDetail[$feature['label']] = $feature['value'];
  428.         }
  430.         $categoryArr = array();
  432.         $categoryId = '';
  434.         if (is_array($this->responseArray['category']) && count($this->responseArray['category'])) {
  435.             foreach ($this->responseArray['category'] as $key => $value) {
  436.                 if (isset($featuresDetail['Main_Category'])) {
  437.                     if ($featuresDetail['Main_Category'] == $value) {
  438.                         $categoryId = $key;
  439.                     }
  440.                 }
  441.                 else {
  442.                     $categoryId = $key;
  443.                 }
  444.                 array_push($categoryArr, $key);
  445.             }
  447.          $this->responseArray['breadcrumbs'] = $this->productDetailManager->productDetailBreadcrumbs($categoryId, $featuresDetail, $categoryArr);
  449.         }
  450.         /* Product Tag section Starts */
  451.         if ($this->productConfigurationRules['show_product_tags']['status'] == 1) {
  452.             $main_sku = explode('-', $this->responseArray['basic_information']['sku_number']);
  453.             $main_sku = $main_sku[count($main_sku) - 1];
  454.             $this->responseArray['product_tags_array'] = $this->productDetailManager->getAllTagsByProductSku($main_sku);
  455.             $tagData = $this->productTagManager->getAllTagsByProductId($this->responseArray['product_id'], $this->cultureCode);
  456.             $this->responseArray['product_tags_array'] = $tagData['private_tag'];
  457.         }
  458.         
  459.         /* Product Tag section Ends */
  461.         $this->productDetailManager->recentViewProductByCookies('recent_product_cookie', $this->responseArray['product_id'], $this->cultureCode);
  462.         unset($productDetailArrayId);
  463.         /*
  464.          * Check Ob_customer id - for flyer which is visible or not
  465.          */
  467.         /* check for Availability */
  468.         $date1 = date('Y-m-d');
  470.         if ($this->responseArray['basic_information']['valid_up_to'] != '') {
  471.             $dte = DateTime::createFromFormat('m-d-Y', $this->responseArray['basic_information']['valid_up_to']);
  472.             $date2 = $dte->format('Y-m-d');
  473.             if (strtotime($date1) > strtotime($date2)) {
  474.                 // $st = 'Expired';
  475.                 $st = '';
  476.             } else {
  477.                 // $st = 'In-Stock';
  478.                 $st = $this->responseArray['basic_information']['valid_up_to'];
  479.             }
  480.         } else {
  481.             $st = '';
  482.         }
  484.         $this->responseArray['basic_information']['valid_status'] = $st;
  486.         /* Releted Product section Starts */
  487.         $productId = $this->responseArray['product_id'];
  488.         $comproductreletedid = $this->productApiManager->productreletedid($productId);
  489.         $this->responseArray['related_product'] = count($comproductreletedid);
  490.         // if($this->userId > 0)
  491.         // {
  492.         $this->responseArray['psa_special'] = $this->productDetailManager->psaSpecialView($productId);
  493.         $this->responseArray['selling_ideas'] = $this->productDetailManager->sellingIdeasView($productId);
  494.         // }
  495.         $this->responseArray['disable_overseas_pricing'] = 0;
  496.         if (isset($this->responseArray['basic_information']['sku_number']) && ! empty($this->responseArray['basic_information']['sku_number'])) {
  497.             $disableOverseasPricingArray = $this->serviceContainer->getParameter('disable_overseas_pricing');
  498.             if (in_array($this->responseArray['basic_information']['sku_number'], $disableOverseasPricingArray)) {
  499.                 $this->responseArray['disable_overseas_pricing'] = 1;
  500.             }
  501.         }
  503.         $this->responseArray['tariff_impacted_item'] = 0;
  504.         if (isset($this->responseArray['basic_information']['sku_number']) && ! empty($this->responseArray['basic_information']['sku_number'])) {
  505.             $tariffImpactesItemPricingArray = $this->serviceContainer->getParameter('tariff_impacted_item');
  506.             if (in_array($this->responseArray['basic_information']['sku_number'], $tariffImpactesItemPricingArray)) {
  507.                 $this->responseArray['tariff_impacted_item'] = 1;
  508.             }
  509.         }
  511.         $this->responseArray['imprint_color_msg'] = 0;
  512.         if (isset($this->responseArray['basic_information']['sku_number']) && ! empty($this->responseArray['basic_information']['sku_number'])) {
  513.             $impintMsgArray = $this->serviceContainer->getParameter('imprint_color_msg');
  514.             if (in_array($this->responseArray['basic_information']['sku_number'], $impintMsgArray)) {
  515.                 $this->responseArray['imprint_color_msg'] = 1;
  516.             }
  517.         }
  519.         $this->responseArray['virtual_hide_button_item'] = 0;
  520.         if (isset($this->responseArray['basic_information']['sku_number']) && ! empty($this->responseArray['basic_information']['sku_number'])) {
  521.             $virtualHideButtonItemArray = $this->serviceContainer->getParameter('virtual_hide_button_item');
  522.             if (in_array($this->responseArray['basic_information']['sku_number'], $virtualHideButtonItemArray)) {
  523.                 $this->responseArray['virtual_hide_button_item'] = 1;
  524.             }
  525.         }
  527.         $productSKU = $this->responseArray['basic_information']['sku_number'];
  528.         $supplierId = $this->responseArray['supplier']['supplier_id'];
  529.         $downloadImageRelativePath = $this->serviceContainer->getParameter('product_image.zip_path');
  530.         $blankFileFullPath = $downloadImageRelativePath.$supplierId.'/blank-images/'.$productSKU.'.zip';
  531.         $this->responseArray['download_blank_image_status'] = file_exists($blankFileFullPath)?1:0;
  533.         $downloadPdfRelativePath = $this->serviceContainer->getParameter('product_pdf.flyer_path');
  534.         $pdfFileFullPath = $downloadPdfRelativePath.$supplierId.'/flyers/'.$productSKU.'.pdf';
  535.         $this->responseArray['download_flyer_status'] = file_exists($pdfFileFullPath)?1:0;
  537.         // kjethi
  538.         $this->responseArray['productAdvertiseData'] = $this->productDetailManager->getAdvertiseForFrontByRefId($productId, 'product'); // $productId
  539.         if(array_key_exists('breadcrumbs',$this->responseArray) && array_key_exists('productAdvertiseData',$this->responseArray)){
  540.             if (count($this->responseArray['productAdvertiseData']) == 0 && count($this->responseArray['breadcrumbs']) > 0) {
  541.                 $catForAdvertise = array_keys($this->responseArray['breadcrumbs'])[0];
  542.                 if ($catForAdvertise > 0) {
  543.                     $this->responseArray['productAdvertiseData'] = $this->productDetailManager->getAdvertiseForFrontByRefId($catForAdvertise, 'category'); //
  544.                 }
  545.             }
  546.         }
  547.         
  549.         // Other Product
  550.         $mainSku = $this->responseArray['basic_information']['sku_number'] ? $this->responseArray['basic_information']['sku_number']:0;
  551.         if(strpos($this->responseArray['basic_information']['sku_number'], '-') != false){
  552.             $mainSku = explode('-', $this->responseArray['basic_information']['sku_number'])[1]; // get main sku
  553.         }
  554.         if(isset($this->responseArray['other_products']) && is_array($this->responseArray['other_products'])){
  555.             $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);
  556.             usort($this->responseArray['other_products'], function ($a, $b) use ($sortOrder) {
  557.                 $pos_a = array_search($a['sku_number'], $sortOrder);
  558.                 $pos_b = array_search($b['sku_number'], $sortOrder);
  559.                 return $pos_a - $pos_b;
  560.             });
  561.             
  562.         }
  563.         else{
  564.             $this->responseArray['other_products'] = null;
  565.         }
  566.         
  568.         $sku = $this->responseArray['basic_information']['sku_number'] ? $this->responseArray['basic_information']['sku_number']:0;
  569.         $search_skus = [];
  570.         $globalConnectPrefixes = ['20', '28', '25'];
  571.         $isGlobalConnect = 0;
  573.         if (strpos($sku, '-') !== false) {
  574.             list($prefix, $sku) = explode('-', $sku);
  575.             if($prefix == '80'){
  576.                 $search_skus = ['28-'.$sku, '20-'.$sku, '25-'.$sku];
  577.                 
  578.                 if($this->responseArray['isUsaConnect'] == 1){
  579.                     $this->responseArray["color_label"] ="Current Stock";
  580.                     $this->responseArray["color_label_1"] ="USA Connect";
  581.                 }
  582.                 else{
  583.                     $this->responseArray["color_label"] ="Domestic Stock";
  584.                     $this->responseArray["color_label_1"] ="Global Connect";
  585.                 }
  586.             }
  587.             elseif($prefix == '75'){
  588.                 $search_skus = ['25-'.$sku, '20-'.$sku, '28-'.$sku];
  589.                 
  590.                 if($this->responseArray['isUsaConnect'] == 1){
  591.                     $this->responseArray["color_label"] ="Current Stock";
  592.                     $this->responseArray["color_label_1"] ="USA Connect";
  593.                 }
  594.                 else{
  595.                     $this->responseArray["color_label"] ="Domestic Stock";
  596.                     $this->responseArray["color_label_1"] ="Global Connect";
  597.                 }
  598.             }
  599.             elseif($prefix == '20'){
  600.                 $isGlobalConnect = 1;
  601.                 $search_skus = [$sku, '80-' . $sku];
  602.                 if($this->responseArray['isUsaConnect'] == 1){
  603.                     $this->responseArray["color_label_1"] ="Current Stock";
  604.                     $this->responseArray["color_label"] ="USA Connect";
  605.                 }
  606.                 else{
  607.                     $this->responseArray["color_label_1"] ="Domestic Stock";
  608.                     $this->responseArray["color_label"] ="Global Connect";
  609.                 }
  610.                 
  611.             }
  612.             elseif($prefix == '28'){
  613.                 $isGlobalConnect = 1;
  614.                 $search_skus = ['80-' . $sku, $sku];
  615.                 if($this->responseArray['isUsaConnect'] == 1){
  616.                     $this->responseArray["color_label_1"] ="Current Stock";
  617.                     $this->responseArray["color_label"] ="USA Connect";
  618.                 }
  619.                 else{
  620.                     $this->responseArray["color_label_1"] ="Domestic Stock";
  621.                     $this->responseArray["color_label"] ="Global Connect";
  622.                 }
  623.                 
  624.             }
  625.             elseif($prefix == '25'){
  626.                 $isGlobalConnect = 1;
  627.                 $search_skus = ['75-' . $sku, $sku, '80-' . $sku];
  628.                 if($this->responseArray['isUsaConnect'] == 1){
  629.                     $this->responseArray["color_label_1"] ="Current Stock";
  630.                     $this->responseArray["color_label"] ="USA Connect";
  631.                 }
  632.                 else{
  633.                     $this->responseArray["color_label_1"] ="Domestic Stock";
  634.                     $this->responseArray["color_label"] ="Global Connect";
  635.                 }
  636.                 
  637.             }
  638.             else{
  639.                 $search_skus = ['20-' . $sku, '28-' . $sku, '25-' . $sku];
  640.                 
  641.                 if($this->responseArray['isUsaConnect'] == 1){
  642.                     $this->responseArray["color_label_1"] ="Current Stock";
  643.                     $this->responseArray["color_label"] ="USA Connect";
  644.                 }
  645.                 else{
  646.                     $this->responseArray["color_label_1"] ="Domestic Stock";
  647.                     $this->responseArray["color_label"] ="Global Connect";
  648.                 }
  649.             }
  650.         }else{
  651.             $search_skus = null;
  652.             foreach($globalConnectPrefixes as $value){
  653.                 $search_skus[] = $value.'-'.$sku;
  654.             }
  655.             
  656.             if($this->responseArray['isUsaConnect'] == 1){
  657.                 $this->responseArray["color_label"] ="Current Stock";
  658.                 $this->responseArray["color_label_1"] ="USA Connect";
  659.             }
  660.             else{
  661.                 $this->responseArray["color_label"] ="Domestic Stock";
  662.                 $this->responseArray["color_label_1"] ="Global Connect";
  663.             }
  664.         }
  666.         // $productDetailArray = $this->solrProductManager->getProductDetailBySku($sku,$this->cultureCode,$this->responseArray['supplier']['supplier_id'],true,true);
  667.         $this->responseArray["otherProducts"] = array();//$productDetailArray;
  668.         
  669.         // $productTagManager = $this->serviceContainer->get('office_brain_product_tag_manager');
  670.         $productTagManager = $this->productTagManager;
  671.         // $productTagManager = $this->get('office_brain_private_tag_extended');
  672.         $this->responseArray["laserProducts"] = $productTagManager->getAllImprintProducts();
  673.         $this->responseArray["laserProducts"] = array_column($this->responseArray["laserProducts"],'imprintMethod','productId');
  674.         
  675.        
  676.         $productHasGlobalConnect = 0;
  677.         foreach($globalConnectPrefixes as $globalPrefix){
  678.             $key = array_search($globalPrefix.'-'.$mainSku, array_column($this->responseArray['other_products'], 'sku_number'));
  679.             if($key !== false){
  680.                 $productHasGlobalConnect = 1;
  681.                 break;
  682.             }
  683.                 
  684.         }
  686.         $matching_products = null;
  687.         
  688.         foreach ($search_skus as $sku) {
  689.             $matching_products = array_filter($this->responseArray['other_products'], function($product) use ($sku) {
  690.                 return $product['sku_number'] === $sku;
  691.             });
  692.             if (!empty($matching_products)) {
  693.                 break; // Stop searching if a matching product is found
  694.             }
  695.         }
  696.             // Convert the filtered result into a simple indexed array
  697.         $matching_products = array_values($matching_products);
  699.         $this->responseArray["matching_products"] = $matching_products;
  700.         $this->responseArray["main_image_url"] = $request->get('main_image_url');
  701.         $this->responseArray["is_global_connect"] =  $isGlobalConnect;
  702.         $this->responseArray["has_global_connect"] = $productHasGlobalConnect;
  703.         return $this->responseArray;
  704.     }
  706.     /**
  707.      *
  708.      * @author Employee Id: 4464
  709.      *         Desciption: Related Product Information.
  710.      *        
  711.      * @param
  712.      *            integer product id
  713.      *            
  714.      * @return product related information
  715.      *        
  716.      * @Route("/custom-related-product/{productId}",
  717.      *     name="officebrain_custom_bundle_product_bundle_product_relatedproduct",
  718.      * )
  719.      *
  720.      * @Template("OfficeBrain/Bundle/ProductBundle/Product/relatedProduct.html.twig")
  721.      *
  722.      */
  723.     public function customRelatedProductAction(Request $request)
  724.     {
  725.         $this->initAction($request);
  726.         $productId = $this->request->get('productId', null);
  727.         $locale = $this->request->getLocale();
  729.         // -----------------------------------------------------------------------
  730.         $cacheSiteKey = array(
  731.             $this->moduleCachePrefix,
  732.             $locale,
  733.             "id#" . $productId,
  734.             $this->projectSetting['instance_id'],
  735.             $this->projectSetting['kernelEnvironment']
  736.             // $this->container->getParameter('kernel.environment') // symfony 4
  737.         );
  738.         $cacheKey = RedisCacheService::generateKey($this->statsh_cache_wrapper, $cacheSiteKey);
  739.         $cacheData = RedisCacheService::getCacheData($this->statsh_cache_wrapper, $cacheKey);
  740.         if ($cacheData) {
  741.             return $cacheData;
  742.         }
  743.         // -----------------------------------------------------------------------
  745.         $comproductreletedid = $this->productApiManager->productreletedid($productId);
  746.         foreach ($comproductreletedid as $releted_productid) {
  747.             $relatedProductInfo = $this->productDetailManager->getProductDetailById($releted_productid['relatedProductId'], $releted_productid['culture']);
  748.             $this->responseArray['related_product'][] = isset($relatedProductInfo[$releted_productid['relatedProductId']]);
  749.         }
  751.         if (! empty($cacheKey)) {
  752.             RedisCacheService::saveCacheData($this->statsh_cache_wrapper, $cacheKey, $this->responseArray);
  753.         }
  755.         return $this->responseArray;
  756.     }
  758.     /**
  759.      *
  760.      * @author Employee Id: 5633
  761.      *         Description : Use to show the list of product in this request quote.
  762.      * @param
  763.      *            1 : No paramater
  764.      * @return type : json
  765.      * @throws Exception: Null
  766.      *        
  767.      * @Route("/product-imprint-color-chart",
  768.      * name="officebrain_custom_product_bundle_imprint_custom_color",
  769.      * options={"expose"=true}
  770.      * )
  771.      * @Template("project/OfficeBrain/CustomBundle/ProductBundle/Product/imprintColorCustomChart.html.twig")
  772.      *
  773.      */
  774.     public function selectCustomColorAction(Request $request)
  775.     {
  776.         $this->initAction($request);
  777.         $product_id = $this->request->get('product_id');
  778.         $culture = $this->cultureCode;
  779.         $standardImprintColor = $this->productDetailManager->getStandardImprintColorInformation($product_id, $culture); 
  780.         $this->responseArray = $this->productDetailManager->getProductDetailById($product_id, $culture);
  781.         $this->responseArray['imprint_color_msg'] = 0;
  782.         if (isset($this->responseArray[$product_id]['basic_information']['sku_number']) && ! empty($this->responseArray[$product_id]['basic_information']['sku_number'])) {
  783.             $impintMsgArray = $this->serviceContainer->getParameter('imprint_color_msg');
  784.             if (in_array($this->responseArray[$product_id]['basic_information']['sku_number'], $impintMsgArray)) {
  785.                 $this->responseArray['imprint_color_msg'] = 1;
  786.             }
  787.         }
  789.         return array(
  790.             'standard_imprint_color' => $standardImprintColor,
  791.             'imprint_color_msg' => $this->responseArray['imprint_color_msg']
  792.         );
  793.     }
  795.     /**
  796.      *
  797.      * @author Employee Id: 5429
  798.      *        
  799.      * @Route("/image-library/{page}",name="officebrain_custom_bundle_product_bundle_image_library",
  800.      * requirements={"records_per_page"="12|24|48|100|996","page"="\d+"},
  801.      * defaults={"records_per_page"=20,"page"=1}),
  802.      * @Template("project/OfficeBrain/CustomBundle/ProductBundle/Product/imageLibrary.html.twig")
  803.      *
  804.      */
  805.     public function imageLibraryAction(Request $request)
  806.     {
  807.         $this->initAction($request);
  808.         if ($this->userId == 0) {
  809.             return $this->redirect($this->generateUrl('office_brain_userbundle_login_login'));
  810.         }
  811.         $culture = $this->cultureCode;
  812.         list ($cultureName[], $country[]) = explode("_", $culture);
  813.         $category = $this->productDetailManager->getCategoryMapping();
  814.         $masterIds = array_column($category, 'pms_id');
  815.         $params = array(
  816.             'cultures' => json_encode($cultureName),
  817.             'master_id' => json_encode($masterIds)
  818.         );
  819.         $this->categoryApi->init('list_category');
  820.         $this->categoryApi->setCallParameters($params);
  821.         $this->categoryApi->doProcess();
  822.         $data = $this->categoryApi->getResultArray();
  823.         foreach ($category as $key) {
  824.             if (array_key_exists($key['pms_id'], $data['en'])) {
  825.                 $data['en'][$key['pms_id']]['parentid'] = $key['parentid'];
  826.                 $data['en'][$key['pms_id']]['haschildid'] = $key['haschildid'];
  827.             }
  828.         }
  829.         return $data;
  830.     }
  832.     /**
  833.      *
  834.      * @author Employee Id: 5429
  835.      *        
  836.      *         Description : This function used for List Product Information
  837.      * @Route("/product/view-psa-special/",name="officebrain_custombundle_productbundle_psaSpecial_view")
  838.      * @Template("project/OfficeBrain/CustomBundle/ProductBundle/Product/viewPsaSpecial.html.twig")
  839.      *
  840.      *
  841.      */
  842.     public function viewPsaSpecialAction(Request $request)
  843.     {
  844.         $this->initAction($request);
  846.         $imagename['path'] = $this->request->get('product_id', '');
  847.         return $imagename;
  848.     }
  850.     /**
  851.      *
  852.      * @author Employee Id: 5429
  853.      *        
  854.      * @Route("/product/QRcode/view/{slug}",name="officebrain_custombundle_productbundle_qrcode_view", methods={"GET"}),
  855.      * @Template("project/OfficeBrain/CustomBundle/ProductBundle/Product/viewQRCode.html.twig")
  856.      *
  857.      */
  858.     public function viewQRCodeAction(Request $request, $slug)
  859.     {
  860.         $this->initAction($request);
  861.         return $this->productDetailManager->getQRCodedetail($slug);
  862.     }
  864.     /**
  865.      *
  866.      * @author Employee Id: 4217
  867.      *        
  868.      *         Desciption: Virtual Tool
  869.      *        
  870.      * @param
  871.      *            video_url.
  872.      *            
  873.      * @return json Response
  874.      *        
  875.      * @Route("/product-virtual-tool",
  876.      *     name="officebrain_product_bundle_product_virtual_tool"
  877.      * )
  878.      *
  879.      * @Template("OfficeBrain/Bundle/ProductBundle/Product/productVirtualTool.html.twig")
  880.      */
  881.     public function productVirtualToolAction(Request $request)
  882.     {
  883.         $this->initAction($request);
  884.         $itemNo = $this->request->get("itemno");
  885.         $prodctid = $this->request->get("prodctid");
  886.         $this->responseArray['productSku'] = $itemNo;
  888.         return $this->responseArray;
  889.     }
  891.     /**
  892.      *
  893.      * @author Employee Id: 5429
  894.      *        
  895.      * @Route("/product/email-factory-for-price/{product_id}",name="officebrain_custombundle_productbundle_email_factory_for_price", methods={"GET","POST"}),
  896.      *
  897.      */
  898.     public function emailFactoryForPriceAction(Request $request)
  899.     {
  900.         $this->initAction($request);
  901.         $productId = $this->request->get('product_id');
  902.         $productDetailArrayId = $this->productDetailManager->getProductDetailById($productId, $this->cultureCode);
  904.         if (isset($productDetailArrayId[$productId]) && ! empty($productDetailArrayId[$productId])) {
  905.             $itemName = isset($productDetailArrayId[$productId]['basic_information']['title']) ? $productDetailArrayId[$productId]['basic_information']['title'] : "";
  906.             $skuNumber = isset($productDetailArrayId[$productId]['basic_information']['sku_number']) ? $productDetailArrayId[$productId]['basic_information']['sku_number'] : "";
  907.             $imprintColors = "";
  908.             $notes = "";
  909.             if ($productDetailArrayId[$productId]['feature_details']) {
  910.                 foreach ($productDetailArrayId[$productId]['feature_details'] as $features) {
  911.                     if (strtolower(trim($features['label'])) == "imprint colors") {
  912.                         $imprintColors = $features['value'];
  913.                     }
  914.                     if (strtolower($features['label']) == "note") {
  915.                         $notes = $features['value'];
  916.                     }
  917.                 }
  918.             }
  919.             $quantity = array();
  920.             if ($productDetailArrayId[$productId]['pricing']['decorative']) {
  921.                 foreach ($productDetailArrayId[$productId]['pricing']['decorative'] as $pricing) {
  922.                     $priceTo = ! empty($pricing['to']) ? "-" . $pricing['to'] : "+";
  923.                     $quantity[] = $pricing['from'] . $priceTo;
  924.                 }
  925.             }
  926.             $quantity = implode("|", $quantity);
  927.             $eventKey = 'productDetailFactoryPriceEmail';
  928.             $to = ""; // "jrathod@officebrain.com";//specialquotes@aakronline.com
  929.             $languageId = $this->languageId;
  930.             $subject = "Test Email";
  931.             $params = array(
  932.                 'item_name' => $itemName,
  933.                 'sku_number' => $skuNumber,
  934.                 'quantity' => $quantity,
  935.                 'imprint_color' => $imprintColors,
  936.                 'additional_notes' => $notes
  937.             );
  938.             $from = ""; // "jrathod@officebrain.com";
  939.             $attachment = array();
  940.             $cc = ''; // array();
  941.             $bcc = ''; // array();
  943.             $this->emailService->sendMail($eventKey, $to, $params, $languageId, $from, $subject, $attachment, $cc, $bcc);
  945.             $this->responseArray['status'] = 'success';
  946.             $this->responseArray['success_message'] = $this->translator->trans('email.success');
  947.         } else {
  948.             $this->responseArray['status'] = 'error';
  949.             $this->responseArray['error_message'] = "There is some issue please try again later!";
  950.         }
  952.         return new JsonResponse($this->responseArray);
  953.     }
  955.     /**
  956.      *
  957.      * @author(Kjethi)
  958.      * @Route("/suggested-product/{productId}",
  959.      *     name="office_brain_search_bundle_product_suggested_product_list",
  960.      * )
  961.      * @Template("project/OfficeBrain/CustomBundle/SearchBundle/BrowseCategory/suggestedProduct.html.twig")
  962.      */
  963.     public function getSuggestedProductByProductAction(Request $request, $productId, $category = [])
  964.     {
  965.         $this->initAction($request);
  966.         $productId = $productId;
  967.         // $searchManager = $this->get('office_brain_custom_bundle_search_manager'); // symfony 4
  968.         // $searchManager = $this->serviceContainer->get('office_brain_search_manager_extended');
  969.         $searchManager = $this->searchManager;
  970.         $suggestedProductData = array();
  971.         $data = $this->productApiManager->getSuggestedProductByProductId($productId);
  972.         if (isset($data['suggestedProducts']) && count($data['suggestedProducts']) > 0) {
  973.             $suggestedProductData = $data['suggestedProducts'];
  974.         } else if (count($category) > 0) {
  975.             $api_manager = $this->serviceContainer->get('officebrain_category_api_manager');
  976.             $categoryWiseSuggestedArr = $api_manager->getSuggestedProductByRelatedCat($category[0]);
  977.             $categoryWiseSuggestedArr = array_column($categoryWiseSuggestedArr, 'suggestedProduct');
  978.             $suggestedProductData = '';
  979.             foreach ($categoryWiseSuggestedArr as $suggProductIdArr) {
  980.                 $suggestedProductData .= ($suggestedProductData ? ',' : '') . $suggProductIdArr; // array_filter - remove blank element
  981.             }
  982.             $suggestedProductData = explode(',', $suggestedProductData);
  983.             $suggestedProductData = array_filter($suggestedProductData);
  984.         }
  986.         // $api_manager = $this->get('officebrain_category_api_manager');
  987.         // $categoryWiseSuggestedArr= $api_manager->getSuggestedProductByRelatedCat($category);
  988.         // $categoryWiseSuggestedArr= array_column($categoryWiseSuggestedArr, 'suggestedProduct');
  989.         // $suggestedProductData='';
  990.         // foreach ($categoryWiseSuggestedArr as $suggProductIdArr){
  991.         // $suggestedProductData .= ($suggestedProductData ? ',': '' ).$suggProductIdArr;//array_filter - remove blank element
  992.         // }
  993.         // $suggestedProductData = explode(',',$suggestedProductData);
  994.         // $suggestedProductData = array_filter($suggestedProductData);
  996.         // /////////////////////////////////////
  998.         // $data = $this->productApiManager->getSuggestedProductByProductId($productId);
  999.         $suggestedProductData = array_merge($suggestedProductData, $data['suggestedProducts']);
  1000.         if ($data && count($suggestedProductData) > 0) {
  1001.             $result = array();
  1002.             if (count($suggestedProductData))
  1003.                 $sku = $suggestedProductData; // implode($data['suggestedProducts'], ',');
  1004.                                               // $sku = $data['suggestedProducts'];//
  1005.             $this->request->query->set('sku', $sku);
  1006.             $this->request->query->set('search_type', 'exact');
  1007.             // this is for remove By Default soring(which is Price:desc)
  1008.             $this->request->query->set('sort_by', '1');
  1009.             $this->responseArray = $searchManager->searchService(true);
  1010.             $data = array();
  1011.             // $data = $this->site_module->getProduct($criteria);
  1012.             # print_r(array_keys((array)$this->responseArray['search_result_array']));
  1013.             # echo(array_keys($this->responseArray['search_result_array']));exit;
  1014.             // print_r($this->responseArray);exit;
  1015.             $data['search_result_array'] = $this->responseArray['search_result_array'];
  1016.             // print_r(array_keys($data['search_result_array']));exit;
  1017.             $data['product_box_bootstrap_class'] = 'item';
  1018.             $data['render_model'] = 0;
  1019.             // echo "<pre>"; dump($data['search_result_array']); exit;
  1020.             // return $this->render('OfficeBrainPageBundle:tempUIElements:recommendProducts.html.twig', $data);
  1021.             $response = $this->render("project/OfficeBrain/CustomBundle/SearchBundle/BrowseCategory/suggestedProduct.html.twig", $data);
  1022.             if(!empty($cacheKey))
  1023.             {
  1024.               RedisCacheService::saveCacheData($this->statsh_cache_wrapper,$cacheKey,$response);
  1025.             }
  1026.             return $response;
  1027.         }
  1028.         else{
  1029.             return array();
  1030.         }
  1031.         
  1032.     }
  1033.     
  1034.     /**
  1035.      * @author Employee Id: 6799
  1036.      *
  1037.      * Description : This function used for Get information about ESP
  1038.      * @Route("/get-esp-data/{productSku}",name="officebrain_custombundle_productbundle_getespdata")
  1040.      * @return json Response
  1041.      *
  1042.      */
  1043.     public function getEspDataAction(Request $request)
  1044.     {
  1045.         $this->initAction($request);
  1046.         $productSku = $this->request->get("productSku");
  1047.         $selectedData = $this->productDetailManager->getEspProductData($productSku);
  1048.         $responseData = null;
  1050.         if($selectedData){
  1051.             $responseData["selected_esp_product_type"] = $selectedData->getEspProductType();
  1052.             $responseData["selected_esp_categories"] = $selectedData->getEspProductCategory();
  1053.         }
  1055.         $response = new Response(json_encode($responseData));
  1056.         $response->headers->set('Content-Type', 'application/json');
  1057.         $response->headers->set('X-Status-Code', 404);
  1059.         return $response;
  1060.     }
  1061.     
  1062.     
  1063.     /**
  1064.      *
  1065.      * @author Employee Id: Freelancer
  1066.      * @param
  1067.      * @return type : json
  1068.      * @throws Exception: Null
  1069.      *
  1070.      * @Route("/product-hts-code",
  1071.      * name="officebrain_custom_product_bundle_hts_code",
  1072.      * options={"expose"=true}
  1073.      * )
  1074.      * @Template("project/OfficeBrain/CustomBundle/ProductBundle/Product/productHtsCode.html.twig")
  1075.      *
  1076.      */
  1077.     public function productHtsCodeAction(Request $request)
  1078.     {
  1079.         $this->initAction($request);
  1080.         $product_id = $this->request->get('product_id');
  1081.         $culture = $this->cultureCode;
  1082.         
  1083.         $productDetailArray = $this->productDetailManager->getProductDetailById($product_id, $culture);
  1084.         
  1085.         $this->responseArray = $productDetailArray[$product_id];
  1086.         
  1087.         $this->responseArray['data'] = $this->responseArray['feature_details'];
  1088.         
  1089.         return $this->responseArray;
  1090.     }
  1092.     /**
  1093.      * @author Vendor
  1094.      *
  1095.      * Description : This function used for update Product Price
  1096.      * @return array
  1097.      * @Route("/product/update-tiory-price/{sku}", name="officebrain_product_update_product_pricing"),
  1098.      */
  1099.     public function updateProductPricingAction(Request $request, $sku){
  1100.         $this->initAction($request);
  1101.         $mainSku = $sku;
  1102.         // $data=$this->request->all();
  1103.         $pricingYear = $this->request->get('price_year', date("Y"));
  1105.         $prefixSku = substr($sku,0,2);
  1106.         $hasPrefixSku = false;
  1107.         if(in_array($prefixSku,["10","20","80","81","82", "75", "76", "25", "28"])){
  1108.             $hasPrefixSku = true;
  1109.             $prefixSku = substr($sku,0,2);
  1110.             $m_sku = substr($sku,2);
  1111.             $sku = $prefixSku."-". $m_sku;
  1112.         }
  1113.         
  1114.         $projectSetting = $this->request->get('project_setting');
  1115. //         $sku = $this->request->get('sku', '');
  1116.         //         $masterProductId = $this->request->get('master_product_id', '');
  1117.         $countryArray = $this->serviceContainer->getParameter('country');
  1118.         $languageArray = $this->serviceContainer->getParameter('language');
  1119.         $country_to_pass = array_column($countryArray,'short_name');
  1120.         $language_to_pass = array_keys($languageArray);
  1121.         $param = $this->request->get('_route_params');
  1122.         $locale_language = $param['_locale'];
  1123.         $locale = $this->request->get('_locale',$this->serviceContainer->getParameter('locale'));
  1124.         @list($default_language,$default_country) = explode("_",$locale);
  1125.         $cultureName = $this->projectSetting['culture_code'];
  1126.         
  1127.         
  1128.         $supplier_id = 0;
  1129.         // set global_pricing_keys which are active
  1130.         
  1131.         
  1132.         if($sku){
  1133.             
  1134.             $tioryPriceData = $this->callTioryPriceApiFromSku($mainSku, $pricingYear);
  1135.             
  1136.             //             echo "<pre>";print_r($tioryPriceData["BodyData"]["PriceData"]);exit;
  1137.             
  1138.             if($tioryPriceData["status"] != "success"){
  1139.                 $response = array('status' => "error",'error_message'=>"Tiory price not found");
  1140.                 return new JsonResponse($response);
  1141.             }
  1142.             $withPrefix0 = false;
  1143.             do {
  1144.                 $productInfoFromSku = $this->productDetailManager->getProductDetailBySku($sku,5,$cultureName);
  1145.                 if(isset($productInfoFromSku["product_id"]) || substr($sku,0,1) == "0"){
  1146.                     $withPrefix0 = true;
  1147.                 }
  1148.                 else {
  1149.                     $sku = "0".$sku;
  1150.                 }
  1151.             } while (!$withPrefix0);
  1152.             
  1153.             // need to check because sku has sometime prefix number in mainSku like (2020)
  1154.             if(!isset($productInfoFromSku["product_id"]) && $hasPrefixSku){                
  1155.                 $withPrefix0 = false;
  1156.                 $sku = $mainSku;
  1157.                 do {
  1158.                     $productInfoFromSku = $this->productDetailManager->getProductDetailBySku($sku,5,$cultureName);
  1159.                     if(isset($productInfoFromSku["product_id"]) || substr($sku,0,1) == "0"){
  1160.                         $withPrefix0 = true;
  1161.                     }
  1162.                     else {
  1163.                         $sku = "0".$sku;
  1164.                     }
  1165.                 } while (!$withPrefix0);
  1166.             }
  1167.             
  1168.             if(isset($productInfoFromSku["product_id"])){
  1169.                 $masterProductId = $productInfoFromSku["product_id"];
  1170.                 $productInfo = $this->productApiManager->editView($masterProductId,$language_to_pass,$country_to_pass,$default_language);
  1171.                 //             $masterProductId
  1172.                 //         echo "<pre>";print_r($productInfo);exit;
  1173.                 
  1174.                 $updateProductArr = $this->setProductDataAsPerUpdate($productInfo,$default_country,$default_language,$tioryPriceData["BodyData"]["PriceData"]);
  1175.                 
  1176.                 
  1177.                 $apiResponse = $this->productApiManager->add($cultureName, $updateProductArr);
  1178.                 if ($apiResponse['status']=='success') {
  1179.                     $response = array('status' => $apiResponse['status'],'success_message'=>$this->get('translator')->trans($apiResponse['success_message']));
  1180.                     
  1181.                     $actionPerformed = 'update';
  1182.                     
  1183.                     //SOLR SYNC CODE START
  1184.                     $is_solr_syn_enabled = $this->serviceContainer->getParameter('solr_sync');
  1185.                     if($is_solr_syn_enabled){
  1186.                         $env = $this->serviceContainer->getParameter("kernel.environment");
  1187.                         $localization_to_update = $this->serviceContainer->getParameter('localization_to_fetch');
  1188.                         $this->productApiManager->updateSolrData($apiResponse['master_product_id'],$localization_to_update,$projectSetting['project_id'],$env,'update');
  1189.                     }
  1190.                     
  1191.                     //SOLR SYNC CODE END
  1192.                     
  1193.                     // To Integrate With ERP
  1194.                     $erpIntegration = $projectSetting['configuration_rule']['erp_integration'];
  1195.                     if($erpIntegration && $erpIntegration['productManagement'] == 1 && !empty($this->queueApiManager)) {
  1196.                         $this->productApiManager->integrateWithErp($this->queueApiManager, $actionPerformed, $apiResponse['master_product_id']);
  1197.                     }
  1198.                     if($this->request->get('syncflag')==1){
  1199.                         if($productAddSettings['asi_call']['status']){
  1200.                             foreach ($apiResponse['product_slugs'] as $culture => $slug){
  1201.                                 if($masterProductId > 0)
  1202.                                 {
  1203.                                     $this->productDetailManager->updateSyncDetail($this->request->get('syncflag'),$updateProductArr['sku']);
  1204.                                     $asiurl = 'http://demoapi.officebrain.com/update_product_api.php?product_slug='.$slug;
  1205.                                 }
  1206.                                 else
  1207.                                 {
  1208.                                     $this->productDetailManager->insertSyncDetail($this->request->get('syncflag'),$updateProductArr['sku']);
  1209.                                     $asiurl = 'http://demoapi.officebrain.com/product_api.php?product_slug='.$slug;
  1210.                                 }
  1211.                                 //echo $asiurl;die;
  1212.                                 exec("curl '$asiurl' > /dev/null &");
  1213.                             }
  1214.                         }
  1215.                     }
  1216.                     else
  1217.                     {
  1218.                         if($masterProductId > 0)
  1219.                         {
  1220.                             $this->productDetailManager->updateSyncDetail(0,$updateProductArr['sku']);
  1221.                         }
  1222.                         else
  1223.                         {
  1224.                             $this->productDetailManager->insertSyncDetail(0,$updateProductArr['sku']);
  1225.                         }
  1226.                         
  1227.                         if(isset($updateProductArr['sku']) && !empty($updateProductArr['sku'])){
  1228.                             $asiurl = 'http://demoapi.officebrain.com/product_delete_api.php?product_sku='.$updateProductArr['sku'];
  1229.                             exec("curl '$asiurl' > /dev/null &");
  1230.                         }
  1231.                     }
  1232.                 }
  1233.                 
  1234.                 return new JsonResponse($response);;
  1235.             }
  1236.             
  1237.             
  1238.         }
  1239.         $response = array('status' => "error",'error_message'=>"Product not found");
  1240.         return new JsonResponse($response);;
  1241.     }
  1242.     function setProductDataAsPerUpdate($productInfo,$default_country,$default_language,$tioryPriceData){
  1243.         $param = $this->request->get('_route_params');
  1244.         $projectSetting = $this->request->get('project_setting');
  1245.         $locale_language = $param['_locale'];
  1246.         $countryArray = $this->serviceContainer->getParameter('country');
  1247.         $productAddSettings = $projectSetting['configuration_rule']['product']['add_update'];
  1248.         $globalPricingKeys = '';
  1249.         if(array_key_exists('global_pricing', $productAddSettings))
  1250.         {
  1251.             foreach ($productAddSettings['global_pricing'] as $key => $val)
  1252.             {
  1253.                 if ($val['status'] == 1)
  1254.                 {
  1255.                     $globalPricingKeys .= ($val['pricing_box_id'].':'.$val['pricing_box_name']).',';
  1256.                 }
  1257.             }
  1258.         }
  1259.         $productBasicInfo = $productInfo[$default_language]["basic_information"];
  1260.         $updateProductArr = array();
  1261.         $updateProductArr["master_product_id"] = $productInfo["product_id"];
  1262.         $updateProductArr["supplier_id"] = $productInfo["supplier_id"];
  1263.         $updateProductArr["product_source"] = $productInfo["product_source"];
  1264.         $updateProductArr["sku"] = $productBasicInfo["sku_number"];
  1265.         $updateProductArr["product_name"] = array(
  1266.             $default_language => $productBasicInfo["title"]
  1267.         );
  1268.         $updateProductArr["country"] = array(
  1269.             ($countryArray[$default_country]["id"]) ."_". $default_country
  1270.         );
  1271.         $updateProductArr["lang"] = array(
  1272.             $default_country => array($default_language)
  1273.         );
  1274.         $updateProductArr["brand"] = $productInfo["brand"]["id"];
  1275.         $updateProductArr["category"] = array(
  1276.             "country_".$default_country => $productInfo["category"][$default_country]
  1277.         );
  1278.         
  1279.         $updateProductArr["product_description"] = array(
  1280.             $default_language => $productBasicInfo["description"]
  1281.         );
  1282.         $updateProductArr["feature_detail_label"] = array(
  1283.             $default_language => array_column($productInfo[$default_language]["feature_details"],"label")
  1284.         );
  1285.         $updateProductArr["feature_detail"] = array(
  1286.             $default_language => array_column($productInfo[$default_language]["feature_details"],"value")
  1287.         );
  1288.         $updateProductArr["keyword"] = array(
  1289.             $default_language => $productInfo[$default_language]["keyword"]
  1290.         );
  1291.         $updateProductArr["video_url"] = $productBasicInfo["video_url"];
  1292.         $updateProductArr["distributor_central_url"] = $productBasicInfo["distributor_url"];
  1293.         $updateProductArr["details_attribute_to_add"] = array_column($productInfo["attributes"],"attribute_id");
  1294.         
  1295.         $tmpDetaiAndValues = array_reduce($productInfo["attributes_values"][$default_country], function($carry, $item){
  1296.             if(!isset($carry[$item['attribute_id']])){
  1297.                 $carry[$item['attribute_id']] = array();
  1298.             }
  1299.             array_push($carry[$item['attribute_id']],$item['attribute_val']);
  1300.             return $carry;
  1301.         });
  1302.             $updateProductArr["DetailsAndValue"] = array(
  1303.                 "country_".$default_country => array_map(function ($v){ return [implode(",",$v)]; },$tmpDetaiAndValues)
  1304.                 
  1305.             );
  1306.             $updateProductArr["PricingType"] = $productInfo["regular_variations_type"];
  1307.             
  1308.             function price($obj){
  1309.                 $a = array(
  1310.                     "start" => $obj["from"],
  1311.                     "end" => $obj["to"],
  1312.                     "price" => $obj["rate"],
  1313.                     "code" => $obj["code"],
  1314.                     "decorative_new_price" => "",
  1315.                     "decorative_new_code" => "",
  1316.                     "blank_price" => "",
  1317.                     "blank_code" => "",
  1318.                     "special_price" => "",
  1319.                     "special_code" => "",
  1320.                 );
  1321.             }
  1322.             $mainPriceArr = array();
  1323.             $regularPriceArr = array();
  1324.             $aboveCatalogPriceArr = array();
  1325.             foreach ($tioryPriceData as $k => $v) {
  1326.                 $end = $k == count($tioryPriceData)-1  ? "" : $tioryPriceData[$k+1]["quantity"]-1;
  1327.                 $tmpArr = array(
  1328.                     "start" => $v["quantity"],
  1329.                     "end" => $end,
  1330.                     'price' => $v["list"],
  1331.                     "code" => $v["price_discount_id"],
  1332.                     "decorative_new_price" => "",
  1333.                     "decorative_new_code" => "",
  1334.                     "blank_price" => "",
  1335.                     "blank_code" => "",
  1336.                     "special_price" => "",
  1337.                     "special_code" => ""
  1338.                 );
  1339.                 
  1340.                 array_push($mainPriceArr,$tmpArr);
  1341.                 if($k <= $v["eqp"]){
  1342.                     array_push($regularPriceArr,$tmpArr);
  1343.                 }
  1344.                 else if($v["eqp"]+2 >= $k){
  1345.                     array_push($aboveCatalogPriceArr,$tmpArr);
  1346.                 }
  1347.             }
  1348.             //             echo "<pre>";print_R($productBasicInfo);
  1349.             //             print_R($aboveCatalogPriceArr);exit;
  1350.             $updateProductArr["Pricing"] = array(
  1351.                 "price_unit" => $productInfo["regular_price_unit"],
  1352.                 "regular" => array(
  1353.                     "country_".$default_country => $regularPriceArr
  1354.                 )
  1355.             );
  1356.             $updateProductArr["pricing_valid_until"] = isset($productBasicInfo["pricing_valid_until"]) ? $productBasicInfo["pricing_valid_until"] : "";
  1357.             $updateProductArr["pricing_valid_starting"] = isset($productBasicInfo["pricing_valid_starting"]) ? $productBasicInfo["pricing_valid_starting"] :"";
  1358.             $updateProductArr["chk_global_pricing2"] = "pricing2";
  1359.             $updateProductArr["PricingType2"] = isset($productInfo["global_pricing"]["above_catalog"]) ? $productInfo["global_pricing"]["above_catalog"]["regular_variations_type"] : "";
  1360.             $updateProductArr["Pricing2"] = array(
  1361.                 "price_unit" => $productInfo["global_pricing"]["above_catalog"]["regular_price_unit"],
  1362.                 "regular" => array(
  1363.                     "country_".$default_country => $aboveCatalogPriceArr
  1364.                 )
  1365.             );
  1366.             $updateProductArr["general_information"] = array(
  1367.                 $default_language => $productBasicInfo["general_information"]
  1368.             );
  1369.             $updateProductArr["sample_pricing"] = array(
  1370.                 "country_".$default_country => array("price" => "","max_quantity" => "")
  1371.             );
  1372.             function prod_img_map($imgObj){
  1373.                 if(isset($imgObj["image_name"])){
  1374.                     return array($imgObj["image_name"], $imgObj["attr_val_id"]."::SEP::".$imgObj["attribute_value"]);
  1375.                 }
  1376.                 else {
  1377.                     array("");
  1378.                 }
  1379.             }
  1380.             $updateProductArr["image_product"] = array();
  1381.             if(isset($productInfo["prod_images"]["default_image"])){
  1382.                 $imgObj = $productInfo["prod_images"]["default_image"];
  1383.                 $updateProductArr["image_product"]["default_image"] = array($imgObj["image_name"], $imgObj["attr_val_id"]."::SEP::".$imgObj["attribute_value"]);
  1384.             }
  1385.             if(isset($productInfo["prod_images"]["other"])){
  1386.                 foreach ($productInfo["prod_images"]["other"]  as $i => $imgObj){
  1387.                     if(isset($imgObj["image_name"])){
  1388.                         $otherKeyName = "other_image";
  1389.                         if($i){
  1390.                             $otherKeyName = $otherKeyName."_".$i;
  1391.                         }
  1392.                         $updateProductArr["image_product"][$otherKeyName] = array($imgObj["image_name"], $imgObj["attr_val_id"]."::SEP::".$imgObj["attribute_value"]);
  1393.                     }
  1394.                 }
  1395.             }
  1396.             //         $updateProductArr["image_product"] = array(
  1397.             //             "default_image" => array_map(function ($imgObj){
  1398.             //             if(isset($imgObj["image_name"])){
  1399.                 //                 return array($imgObj["image_name"], $imgObj["attr_val_id"]."::SEP::".$imgObj["attribute_value"]);
  1400.                 //             }
  1401.                 //             else {
  1402.                 //                 array("");
  1403.                 //             }
  1404.                 //         },$productInfo["prod_images"]["default_image"]),
  1405.                 //             "other_image" => array_map(function ($imgObj){
  1406.                 //             if(isset($imgObj["image_name"])){
  1407.                 //                 return array($imgObj["image_name"], $imgObj["attr_val_id"]."::SEP::".$imgObj["attribute_value"]);
  1408.                     //             }
  1409.                     //             else {
  1410.                     //                 array("");
  1411.                     //             }
  1412.                     //             },isset($productInfo["prod_images"]["other_image"]) ? $productInfo["prod_images"]["other_image"] : array() )
  1413.                     //         );
  1414.                     
  1415.                     $charges = array();
  1416.                     
  1417.                     function returnProperFormatChargePrice($priceArr){
  1418.                         if(is_array($priceArr)){
  1419.                             return array_map(function($v){
  1420.                                 return array(
  1421.                                     "start" => $v["from"],
  1422.                                     "end" => $v["to"],
  1423.                                     "price" => $v["rate"],
  1424.                                     "code" => $v["code"],
  1425.                                 );
  1426.                             }, $priceArr);
  1427.                         }
  1428.                         else {
  1429.                             return $priceArr;
  1430.                         }
  1431.                         
  1432.                     }
  1433.                     
  1434.                     foreach ($productInfo["imprint_method_information"] as $imprint_method_id => $value) {
  1435.                         //             echo "<pre>";print_r($value);exit;
  1436.                         # code...
  1437.                         
  1438.                         $chargesArr=array();
  1439.                         if(isset($value["charges"]["country_".$default_country]["LTM_CHARGE"])){
  1440.                             $chargesArr["LTM_CHARGE"] = array();
  1441.                             $chargesArr["LTM_CHARGE"]["charge"] = isset($value["charges"]["country_".$default_country]["LTM_CHARGE"]) ? $value["charges"]["country_".$default_country]["LTM_CHARGE"]["charge"] : "";
  1442.                             if(isset($value["charges"]["country_".$default_country]["LTM_CHARGE"]["code"])){
  1443.                                 $chargesArr["LTM_CHARGE"]["code"] = $value["charges"]["country_".$default_country]["LTM_CHARGE"]["code"];
  1444.                             }
  1445.                         };
  1446.                         if(isset($value["charges"]["country_".$default_country]["RUSH_CHARGE"])){
  1447.                             $chargesArr["RUSH_CHARGE"] = array();
  1448.                             $chargesArr["RUSH_CHARGE"]["charge"] = isset($value["charges"]["country_".$default_country]["RUSH_CHARGE"]) ? $value["charges"]["country_".$default_country]["RUSH_CHARGE"]["charge"] : "";
  1449.                             if(isset($value["charges"]["country_".$default_country]["RUSH_CHARGE"]["code"])){
  1450.                                 $chargesArr["RUSH_CHARGE"]["code"] = $value["charges"]["country_".$default_country]["RUSH_CHARGE"]["code"];
  1451.                             }
  1452.                         };
  1453.                         if(isset($value["charges"]["country_".$default_country]["PMS_CHARGE"])){
  1454.                             $chargesArr["PMS_CHARGE"] = array();
  1455.                             $chargesArr["PMS_CHARGE"]["charge"] = isset($value["charges"]["country_".$default_country]["PMS_CHARGE"]) ? $value["charges"]["country_".$default_country]["PMS_CHARGE"]["charge"] : "";
  1456.                             if(isset($value["charges"]["country_".$default_country]["PMS_CHARGE"]["code"])){
  1457.                                 $chargesArr["PMS_CHARGE"]["code"] = $value["charges"]["country_".$default_country]["PMS_CHARGE"]["code"];
  1458.                             }
  1459.                             
  1460.                         };
  1461.                         if(isset($value["charges"]["country_".$default_country]["SETUP_CHARGE"])){
  1462.                             $chargesArr["SETUP_CHARGE"] = array();
  1463.                             $chargesArr["SETUP_CHARGE"]["charge"] = returnProperFormatChargePrice($value["charges"]["country_".$default_country]["SETUP_CHARGE"]["charge"]);
  1464.                             if(isset($value["charges"]["country_".$default_country]["SETUP_CHARGE"]["code"])){
  1465.                                 $chargesArr["SETUP_CHARGE"]["code"] = $value["charges"]["country_".$default_country]["SETUP_CHARGE"]["code"];
  1466.                             } else {
  1467.                                 $chargesArr["SETUP_CHARGE"]["quantity_wise"] = "on";
  1468.                             }
  1469.                         };
  1470.                         if(isset($value["charges"]["country_".$default_country]["ADDITIONAL_LOCATION_CHARGE"])){
  1471.                             $chargesArr["ADDITIONAL_LOCATION_CHARGE"] = array();
  1472.                             $chargesArr["ADDITIONAL_LOCATION_CHARGE"]["charge"] = returnProperFormatChargePrice($value["charges"]["country_".$default_country]["ADDITIONAL_LOCATION_CHARGE"]["charge"]);
  1473.                             if(isset($value["charges"]["country_".$default_country]["ADDITIONAL_LOCATION_CHARGE"]["code"])){
  1474.                                 $chargesArr["ADDITIONAL_LOCATION_CHARGE"]["code"] = $value["charges"]["country_".$default_country]["ADDITIONAL_LOCATION_CHARGE"]["code"];
  1475.                             }
  1476.                             else {
  1477.                                 $chargesArr["ADDITIONAL_LOCATION_CHARGE"]["quantity_wise"] = "on";
  1478.                             }
  1479.                         };
  1480.                         if(isset($value["charges"]["country_".$default_country]["ADDITIONAL_COLOR_CHARGE"])){
  1481.                             $chargesArr["ADDITIONAL_COLOR_CHARGE"] = array();
  1482.                             if(isset($value["charges"]["country_".$default_country]["ADDITIONAL_COLOR_CHARGE"]["code"])){
  1483.                                 $chargesArr["ADDITIONAL_COLOR_CHARGE"]["code"] = $value["charges"]["country_".$default_country]["ADDITIONAL_COLOR_CHARGE"]["code"];
  1484.                             }
  1485.                             else {
  1486.                                 $chargesArr["ADDITIONAL_COLOR_CHARGE"]["quantity_wise"] = "on";
  1487.                             }
  1488.                             $chargesArr["ADDITIONAL_COLOR_CHARGE"]["charge"] =  returnProperFormatChargePrice($value["charges"]["country_".$default_country]["ADDITIONAL_COLOR_CHARGE"]["charge"]);
  1489.                             
  1490.                             
  1491.                             
  1492.                         };
  1493.                         
  1494.                         
  1495.                         $charges[$imprint_method_id] = array(
  1496.                             "position" => implode(",",array_keys($value["imprint_location"])),
  1497.                             "imprint_area" => $value["imprint_area"],
  1498.                             "color_included" => $value["color_included_in_price"],
  1499.                             "maximum_color" => $value["maximum_selectable_color"],
  1500.                             "location_included" => $value["location_included_in_price"],
  1501.                             "maximum_location" => $value["maximum_selectable_location"],
  1502.                             "production_days" => $value["production_days"],
  1503.                             "production_unit" => $value["production_unit"],
  1504.                             "country_".$default_country => $chargesArr
  1505.                         );
  1506.                     }
  1507.                     
  1508.                     $updateProductArr["imprint_information"] = array(
  1509.                         "method" => array_keys($productInfo["imprint_methods"]),
  1510.                         "charges" => $charges
  1511.                     );
  1512.                     $updateProductArr["shipping"] = array(
  1513.                         "fob" => $productInfo["shipping_information"]["free_on_board"],
  1514.                         "carton_quantity" => isset($productInfo["shipping_information"]["carton"]["quantity"]["param"]) ? $productInfo["shipping_information"]["carton"]["weight"]["param"] : "",
  1515.                         "carton_weight" => isset($productInfo["shipping_information"]["carton"]["weight"]["param"]) ? $productInfo["shipping_information"]["carton"]["weight"]["param"] : "",
  1516.                         "carton_weight_unit" => isset($productInfo["shipping_information"]["carton"]["weight"]["unit"]) ? $productInfo["shipping_information"]["carton"]["weight"]["unit"] : "",
  1517.                         "carton_length" => isset($productInfo["shipping_information"]["carton"]["length"]["param"]) ? $productInfo["shipping_information"]["carton"]["length"]["param"] : "",
  1518.                         "carton_width" => isset($productInfo["shipping_information"]["carton"]["width"]["param"]) ? $productInfo["shipping_information"]["carton"]["width"]["param"] : "",
  1519.                         "carton_height" => isset($productInfo["shipping_information"]["carton"]["height"]["param"]) ? $productInfo["shipping_information"]["carton"]["height"]["param"] : "",
  1520.                         "carton_size_unit" => isset($productInfo["shipping_information"]["carton"]["height"]["unit"]) ? $productInfo["shipping_information"]["carton"]["height"]["unit"] : "",
  1521.                         "product_weight" => isset($productInfo["shipping_information"]["product"]["weight"]["param"]) ? $productInfo["shipping_information"]["product"]["weight"]["param"] : "",
  1522.                         "product_weight_unit" => isset($productInfo["shipping_information"]["product"]["weight"]["unit"]) ? $productInfo["shipping_information"]["product"]["weight"]["unit"] : "",
  1523.                         "product_length" => isset($productInfo["shipping_information"]["product"]["length"]["param"]) ? $productInfo["shipping_information"]["product"]["length"]["param"] : "",
  1524.                         "product_width" => isset($productInfo["shipping_information"]["product"]["width"]["param"]) ? $productInfo["shipping_information"]["product"]["width"]["param"] : "",
  1525.                         "product_height" => isset($productInfo["shipping_information"]["product"]["height"]["param"]) ? $productInfo["shipping_information"]["product"]["height"]["param"] : "",
  1526.                         "product_size_unit" => isset($productInfo["shipping_information"]["product"]["width"]["unit"]) ? $productInfo["shipping_information"]["product"]["width"]["unit"] : "",
  1527.                     );
  1528.                     $updateProductArr["valid_up_to"] = $productBasicInfo["valid_up_to"];
  1529.                     $updateProductArr["special_price_valid_up_to"] = $productBasicInfo["special_price_valid_up_to"];
  1530.                     $updateProductArr["currency_array"] = array(
  1531.                         $default_country => 3
  1532.                     );
  1533.                     $updateProductArr["old_name"] = $productBasicInfo["title"];
  1534.                     $updateProductArr["global_pricing_keys"] = trim($globalPricingKeys, ',');
  1535.                     
  1536.                     $updateProductArr['project_id'] = $projectSetting['project_id'];
  1537.                     $updateProductArr['locale_language'] = $locale_language;
  1538.                     $updateProductArr['instance_type'] = $projectSetting['instance_type'];
  1539.                     $updateProductArr['instance_id'] = $projectSetting['instance_id'];
  1540.                     $updateProductArr['thumb_width'] =  $this->serviceContainer->getParameter('thumb_width');
  1541.                     $updateProductArr['medium_thumb_width'] = $this->serviceContainer->getParameter('medium_thumb_width');
  1542.                     //                             echo "<pre>";print_r($updateProductArr);exit;
  1543.                     return $updateProductArr;
  1544.     }
  1545.     public function callTioryPriceApiFromSku($sku, $pricingYear)
  1546.     {
  1547.         $ch = curl_init();
  1548.         
  1549. //         $sku = str_replace("-","",$sku);
  1550. //         $sku = ltrim($sku , "0");
  1551.         $postData = array("pricing_year"=>$pricingYear);
  1552.         $url = "https://arc1967.tiory.com/api/update-tiory-price/$sku?pricing_year=".$pricingYear;
  1553.         //         $url = "https://arc1967.tiory.com/api/en_us/product/update-tiory-price?item_code=71117";
  1554.         curl_setopt($ch, CURLOPT_URL, $url);
  1555.         curl_setopt($ch, CURLOPT_CUSTOMREQUEST, 'POST');
  1556.         curl_setopt($ch, CURLOPT_HTTPAUTH, CURLAUTH_BASIC);
  1557.         curl_setopt($ch, CURLOPT_USERPWD, "officebeacon:test123");
  1558.         curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($postData));
  1559.         curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  1560.         curl_setopt($ch, CURLOPT_TIMEOUT, 4);
  1561.         curl_setopt($ch, CURLOPT_TIMEOUT, 1000);
  1562.         curl_setopt($ch, CURLOPT_SSL_VERIFYPEER,false);
  1563.         $xml = curl_exec($ch);
  1564.         return json_decode($xml,true);
  1565.         
  1566.     }
  1567.     
  1568.     /**
  1569.      *
  1570.      * Desciption: Order Sample
  1571.      *
  1572.      * @return json Response
  1573.      *
  1574.      * @Route("/product-order-sample",
  1575.      *     name="officebrain_product_bundle_product_order_sample"
  1576.      * )
  1577.      *
  1578.      * @Template("OfficeBrain/Bundle/ProductBundle/Product/productOrderSample.html.twig")
  1579.      */
  1580.     public function productOrderSampleAction(Request $request)
  1581.     {
  1582.         $this->initAction($request);
  1583.         $itemNo = $this->request->get("itemno");
  1584.         $prodctid = $this->request->get("prodctid");
  1585.         $this->responseArray['productSku'] = $itemNo;
  1586.         
  1587.         return $this->responseArray;
  1588.     }
  1589.     
  1590. }