src/EventListener/WorkflowEvents.php line 619

Open in your IDE?
  1. <?php
  2. namespace App\EventListener;
  4. use Pimcore\Controller\FrontendController;
  5. use \Pimcore\Model\DataObject;
  6. use App\Library\EmailLibrary;
  7. use Symfony\Component\Workflow\Event\EnteredEvent;
  8. use Symfony\Component\Workflow\Event\EnterEvent;
  9. use Symfony\Component\Workflow\Event\AnnounceEvent;
  10. use Pimcore\Model\Comment;
  11. use Symfony\Component\Workflow\Event\CompletedEvent;
  12. use Symfony\Component\Workflow\Event\LeaveEvent;
  14. class WorkflowEvents extends FrontendController {
  16.     private $executePreviousEvents = true;
  17.     private $team = '';
  18.     private $sendComment = false;
  19.     private $commonId = '';
  21.     public function demandPlanningEmail($objectData) {
  23.         $division = $objectData->getdivision();
  24.         $productName = $objectData->getname();
  26.         $escalationEmail = new DataObject\EscalationEmails\Listing();
  27.         $escalationEmail->setCondition(" division = '$division' ");
  29.         $escalationEmail = $escalationEmail->getdata();
  31.         if(count($escalationEmail) && !empty($escalationEmail[0])) {
  32.             $escalationEmail = $escalationEmail[0];
  33.             $productId = $objectData->getId();
  34.             $emailIds = $escalationEmail->getdemandPlanningTeam();
  36.             if(!empty($emailIds)) {
  38.                 $emailParam = array();
  40.                 $emailParam['to'] = $emailIds;
  41.                 $emailParam['subject'] = 'ITC - Product YVBYMARA';
  42.                 // $emailParam['isDebug'] = true;
  44.                 $templateData['product'] = $objectData;
  46.                 $templateData['url'] = \Pimcore\Tool::getHostUrl().'/admin/login/deeplink?object_'.$productId.'_object';
  48.                 $user = \Pimcore\Tool\Session::getReadonly()->get("user");
  49.                 if (empty($user)) {
  50.                     $templateData['userInfo'] = \Pimcore\Model\User::getById($user->getId());
  51.                 }
  53.                 $templateData['productName'] = $productName;
  55.                 $emailParam['message'] = $this->render('default/email/demand_planning/yvbymara.html.twig', $templateData)->getContent();
  57.                 $emailLib = new EmailLibrary();
  58.                 $sendEmail = $emailLib->sendEmailNotification($emailParam);
  59.             }
  60.         }
  61.     }
  63.     public function sendEmail($team,$objectData,$wfPlace = 'correction') {
  65.         $division = $objectData->getdivision();
  66.         $productName = $objectData->getname();
  68.         $escalationEmail = new DataObject\EscalationEmails\Listing();
  69.         $escalationEmail->setCondition(" division = '$division' ");
  71.         $escalationEmail = $escalationEmail->getdata();
  73.         if(count($escalationEmail) && !empty($escalationEmail[0])) {
  74.             $escalationEmail = $escalationEmail[0];
  76.             $productId = $objectData->getId();
  77.             $attachment = array();
  79.             if($team == 'snop') {
  80.                 $emailIds = $escalationEmail->getsnopTeam();
  81.             } else if($team == 'finance') {
  82.                 $emailIds = $escalationEmail->getfinanceTeam();
  83.             } else if($team == 'brand') {
  84.                 $emailIds = $escalationEmail->getbrandTeam();
  85.             } else if($team == 'packaging') {
  86.                 $emailIds = $escalationEmail->getpackagingTeam();
  87.             } else if($team == 'indirectTax') {
  88.                 $emailIds = $escalationEmail->getindirecttaxTeam();
  89.             } else if($team == 'operationsTeam') {
  90.                 $emailIds = $escalationEmail->getoperationsTeam();
  91.             } else if($team == 'demandPlanningTeam') {
  92.                 $emailIds = $escalationEmail->getdemandPlanningTeam();
  93.             } else if($team == 'smisTeam') {
  94.                 $emailIds = $escalationEmail->getsmisTeam();
  95.             } else if($team == 'sapTeam') {
  96.                 $emailIds = $escalationEmail->getsapTeam();
  97.             }
  99.             if(!empty($emailIds)) {
  101.                 $emailParam = array();
  103.                 $emailParam['to'] = $emailIds;
  104.                 $emailParam['subject'] = 'ITC - Product Approval';
  105.                 // $emailParam['isDebug'] = true;
  107.                 $templateData['product'] = $objectData;
  108.                 $templateData['teamEmail'] = $team;
  110.                 $correction = false;
  111.                 $sendBackToSnop = false;
  112.                 if($wfPlace == 'correction') {
  113.                     $correction = true;
  114.                     $this->sendComment = true;
  115.                 } else if ($wfPlace == 'sendBackToSnop') {
  116.                     $sendBackToSnop = true;
  117.                 }
  119.                 $projectId = '';
  120.                 $productId = '';
  121.                 $projectTitle = '';
  122.                 if (!empty($this->commonId)) {
  123.                     $projectId = $this->commonId;
  124.                 } else {
  125.                     $projectId = $objectData->getprojectName();
  126.                 }
  127.                 if (!empty($projectId)) {
  128.                     $projectData = DataObject\ProductByName::getById($projectId);
  129.                     if (!empty($projectData)) {
  130.                         $projectId = $projectData->getId();
  131.                         $projectTitle = $projectData->getproductName();
  132.                     } else {
  133.                         $projectId = '';
  134.                     }
  135.                 } else {
  136.                     $productId = $objectData->getId();
  137.                 }
  139.                 if($team == 'sapTeam' && (!empty($projectId) || !empty($productId))) {
  141.                     $objId = (!empty($projectId)) ? $projectId : $productId;
  142.                     $isProduct = (!empty($projectId)) ? false : true;
  143.                     $lsmw = $this->saveLsmwSheetAction($objId,$isProduct);
  144.                     if (!empty($lsmw)) {
  145.                         $attachment[] = $lsmw;
  146.                     }
  147.                     $adtional = $this->saveAdditionalDataAction($objId,$isProduct);
  148.                     if (!empty($adtional)) {
  149.                         $attachment[] = $adtional;
  150.                     }
  151.                     $yvbymara = $this->saveYvbymaraAction($objId,$isProduct);
  152.                     if (!empty($yvbymara)) {
  153.                         $attachment[] = $yvbymara;
  154.                     }
  155.                 }
  157.                 $templateData['url'] = \Pimcore\Tool::getHostUrl().'/admin/login/deeplink?object_'.$productId.'_object';
  159.                 $templateData['projectUrl'] = (!empty($projectId)) ? \Pimcore\Tool::getHostUrl().'/admin/login/deeplink?object_'.$projectId.'_object' : '';
  160.                 $templateData['productUrl'] = (!empty($productId)) ? \Pimcore\Tool::getHostUrl().'/admin/login/deeplink?object_'.$productId.'_object' : '';
  161.                 $templateData['downloadUrl'] = (!empty($projectId)) ? \Pimcore\Tool::getHostUrl().'/export/teamdata?t='.md5($team).'&i='.md5($projectId) : '';
  163.                 if (!empty($this->sendComment)) {
  165.                     $cid = (!empty($this->commonId)) ? $this->commonId : $productId;
  167.                     $dbConnection = \Pimcore\Db::get();
  168.                     $notes = $dbConnection->fetchAssoc("SELECT * FROM `notes` WHERE cid = '$cid' ORDER BY `id` DESC LIMIT 1");
  170.                     if(!empty($notes['description'])) {
  171.                         $templateData['notes'] = nl2br($notes['description']);
  172.                     }
  173.                 }
  175.                 $user = \Pimcore\Tool\Session::getReadonly()->get("user");
  176.                 if (empty($user)) {
  177.                     $templateData['userInfo'] = \Pimcore\Model\User::getById($user->getId());
  178.                 }
  180.                 $templateData['correction'] = $correction;
  181.                 $templateData['sendBackToSnop'] = $sendBackToSnop;
  182.                 $templateData['productName'] = $productName;
  183.                 $templateData['team'] = $this->team;
  184.                 $templateData['projectTitle'] = $projectTitle;
  186.                 $emailParam['message'] = $this->render('default/escalation_email_template.html.twig', $templateData)->getContent();
  187.                 $emailParam['attachment'] = (count($attachment)) ? $attachment : array();
  189.                 $emailLib = new EmailLibrary();
  190.                 $sendEmail = $emailLib->sendEmailNotification($emailParam);
  191.             }
  192.         }
  193.         $objectData->save();
  194.     }
  196.     public function snopCorrection($objectData) {
  198.         if ($this->executePreviousEvents) {
  200.             $this->sendEmail('snop',$objectData);
  201.         }
  202.     }
  204.     public function financeCorrection($objectData) {
  206.         if ($this->executePreviousEvents) {
  208.             $this->sendEmail('finance',$objectData);
  209.         }
  210.     }
  212.     public function brandCorrection($objectData) {
  214.         if ($this->executePreviousEvents) {
  215.             $this->sendEmail('brand',$objectData,'correction');
  216.         }
  217.     }
  219.     public function packagingCorrection($objectData) {
  221.         if ($this->executePreviousEvents) {
  223.             $this->sendEmail('packaging',$objectData);
  224.         }
  225.     }
  227.     public function indirectTaxCorrection($objectData) {
  229.         if ($this->executePreviousEvents) {
  231.             $this->sendEmail('indirectTax',$objectData);
  232.         }
  233.     }
  235.     public function operationteamCorrection($objectData) {
  237.         if ($this->executePreviousEvents) {
  239.             $this->sendEmail('operationsTeam',$objectData);
  240.         }
  241.     }
  243.     public function demandPlanningTeam($objectData) {
  245.         if ($this->executePreviousEvents) {
  247.             $this->sendEmail('demandPlanningTeam',$objectData);
  248.         }
  249.     }
  251.     public function smisTeam($objectData) {
  253.         if ($this->executePreviousEvents) {
  255.             $this->sendEmail('smisTeam',$objectData);
  256.         }
  257.     }
  259.     public function financeAction($objectData) {
  261.         if ($this->executePreviousEvents) {
  263.             $this->sendEmail('finance',$objectData,'Finance');
  264.         }
  265.     }
  267.     public function brandAction($objectData) {
  269.         if ($this->executePreviousEvents) {
  271.             $this->sendEmail('brand',$objectData,'Brand');
  272.         }
  273.     }
  275.     public function packagingAction($objectData) {
  277.         if ($this->executePreviousEvents) {
  279.             $this->sendEmail('packaging',$objectData,'Packaging');
  280.         }
  281.     }
  283.     public function indirectTaxAction($objectData) {
  285.         if ($this->executePreviousEvents) {
  287.             $this->sendEmail('indirectTax',$objectData,'Indirect Tax');
  288.         }
  289.     }
  291.     public function operationsAction($objectData) {
  293.         if ($this->executePreviousEvents) {
  295.             $this->sendEmail('operationsTeam',$objectData,'Operations Team');
  296.         }
  297.     }
  299.     public function demandPlanningAction($objectData) {
  301.         if ($this->executePreviousEvents) {
  303.             $this->sendEmail('demandPlanningTeam',$objectData,'Demand Planning Team');
  304.         }
  305.     }
  307.     public function smisAction($objectData) {
  309.         if ($this->executePreviousEvents) {
  311.             $this->sendEmail('smisTeam',$objectData,'SMIS');
  312.         }
  313.     }
  315.     public function sapAction($objectData) {
  317.         if ($this->executePreviousEvents) {
  319.             $this->sendEmail('sapTeam',$objectData,'sap');
  320.             $this->demandPlanningEmail($objectData);
  321.         }
  322.     }
  324.     public function packagingToSnop($objectData) {
  326.         if ($this->executePreviousEvents) {
  328.             $this->team = 'Packaging Team';
  329.             $this->sendEmail('snop',$objectData,'sendBackToSnop');
  330.         }
  331.     }
  332.     public function financeToSnop($objectData) {
  334.         if ($this->executePreviousEvents) {
  336.             $this->team = 'Finance Team';
  337.             $this->sendEmail('snop',$objectData,'sendBackToSnop');
  338.         }
  339.     }
  340.     public function brandToSnop($objectData) {
  342.         if ($this->executePreviousEvents) {
  344.             $this->team = 'Brand Team';
  345.             $this->sendEmail('snop',$objectData,'sendBackToSnop');
  346.         }
  347.     }
  348.     public function indirectTaxToSnop($objectData) {
  350.         if ($this->executePreviousEvents) {
  352.             $this->team = 'Indirect Tax Team';
  353.             $this->sendEmail('snop',$objectData,'sendBackToSnop');
  354.         }
  355.     }
  356.     public function operationsToSnop($objectData) {
  358.         if ($this->executePreviousEvents) {
  360.             $this->team = 'Operations Team';
  361.             $this->sendEmail('snop',$objectData,'sendBackToSnop');
  362.         }
  363.     }
  364.     public function demandPlanningToSnop($objectData) {
  366.         if ($this->executePreviousEvents) {
  368.             $this->team = 'Demand Planning Team';
  369.             $this->sendEmail('snop',$objectData,'sendBackToSnop');
  370.         }
  371.     }
  372.     public function smisToSnop($objectData) {
  374.         if ($this->executePreviousEvents) {
  376.             $this->team = 'SMIS Team';
  377.             $this->sendEmail('snop',$objectData,'sendBackToSnop');
  378.         }
  379.     }
  381.     public function sapApproved($objectData) {
  383.         $folder = DataObject\Service::createFolderByPath('/Products/SAP/Approved/');
  384.         $folderId = $folder->getId();
  386.         $objectData->setParentId($folderId);
  387.         $objectData->setisProductApproved('yes');
  388.         $objectData->save();
  390.         $this->createMarketPlaceProduct($objectData);
  391.     }
  393.     public function createMarketPlaceProduct($productObj) {
  395.         $key = $productObj->getkey();
  397.         // Create Amazon DataObject
  399.         // $size = $productObj->getsize();
  400.         // $product_type = $productObj->getproduct_type();
  402.         $newObject = new DataObject\ProductAmazon();
  403.         $newObject->setKey(\Pimcore\Model\Element\Service::getValidKey('A_'.$key, 'object'));
  404.         // $newObject->setproduct_type($size);
  405.         // $newObject->setsize($product_type);
  406.         $newObject->setstoreProduct($productObj);
  407.         $newObject->seto_parentId('1');
  408.         $newObject->save(["versionNote" => "Product created from SAP"]);
  410.         // Create Big Basket DataObject
  412.         // $how_to_use = $productObj->gethow_to_use();
  413.         // $product_description = $productObj->getproduct_description();
  414.         $hsn_code = $productObj->gethsn_code();
  415.         if (!empty($hsn_code)) {
  416.             $hsn_code = floatval($hsn_code);
  417.         }
  419.         $newObject = new DataObject\ProductBigBasket();
  420.         $newObject->setKey(\Pimcore\Model\Element\Service::getValidKey('BB_'.$key, 'object'));
  421.         // $newObject->sethow_to_use($how_to_use);
  422.         // $newObject->setproduct_description($product_description);
  423.         $newObject->sethsn_code($hsn_code);
  424.         $newObject->seto_parentId('1');
  425.         $newObject->setstoreProduct($productObj);
  426.         $newObject->save(["versionNote" => "Product created from SAP"]);
  428.         // Create Blinkit DataObject
  430.         // $key_features = $productObj->getkey_features();
  431.         // $product_type = $productObj->getproduct_type();
  432.         // $price = $productObj->getprice();
  433.         // $ingredients = $productObj->getingredients();
  435.         $newObject = new DataObject\ProductBlinkit();
  436.         $newObject->setKey(\Pimcore\Model\Element\Service::getValidKey('BI_'.$key, 'object'));
  437.         // $newObject->setkey_features($key_features);
  438.         // $newObject->setproduct_type($product_type);
  439.         // $newObject->setprice($price);
  440.         // $newObject->setingredients($ingredients);
  441.         $newObject->seto_parentId('1');
  442.         $newObject->setstoreProduct($productObj);
  443.         $newObject->save(["versionNote" => "Product created from SAP"]);
  445.         $newObject = new DataObject\ProductFlipkart();
  446.         $newObject->setKey(\Pimcore\Model\Element\Service::getValidKey('FK_'.$key, 'object'));
  447.         $newObject->seto_parentId('1');
  448.         $newObject->setstoreProduct($productObj);
  449.         $newObject->save(["versionNote" => "Product created from SAP"]);
  451.         // Create JioMart DataObject
  453.         $hsn_code = $productObj->gethsn_code();
  454.         // $how_to_use = $productObj->gethow_to_use();
  455.         // $product_type = $productObj->getproduct_type();
  456.         // $ingredients = $productObj->getingredients();
  457.         // $size = $productObj->getsize();
  458.         // $food_type = $productObj->getfood_type();
  460.         $newObject = new DataObject\ProductJioMart();
  461.         $newObject->setKey(\Pimcore\Model\Element\Service::getValidKey('JM_'.$key, 'object'));
  463.         $newObject->sethsn_code($hsn_code);
  464.         // $newObject->sethow_to_use($how_to_use);
  465.         // $newObject->setproduct_type($product_type);
  466.         // $newObject->setingredients($ingredients);
  467.         // $newObject->setsize($size);
  468.         // $newObject->setfood_type($food_type);
  470.         $newObject->seto_parentId('1');
  471.         $newObject->setstoreProduct($productObj);
  472.         $newObject->save(["versionNote" => "Product created from SAP"]);
  474.         // Create Swiggy DataObject
  476.         $sku_name = $productObj->getmaterial_number();
  477.         $weight = $productObj->getpack_weight();
  478.         if (!empty($weight)) {
  479.             $weight = floatval($weight);
  480.         }
  482.         $newObject = new DataObject\ProductSwiggy();
  483.         $newObject->setKey(\Pimcore\Model\Element\Service::getValidKey('SG_'.$key, 'object'));
  484.         $newObject->setsku_name($sku_name);
  485.         $newObject->setweight($weight);
  486.         $newObject->seto_parentId('1');
  487.         $newObject->setstoreProduct($productObj);
  488.         $newObject->save(["versionNote" => "Product created from SAP"]);
  491.         // Create Zepto DataObject
  493.         $newObject = new DataObject\ProductZepto();
  494.         $newObject->setKey(\Pimcore\Model\Element\Service::getValidKey('Zepto_'.$key, 'object'));
  495.         $newObject->sethsn_code($hsn_code);
  496.         $newObject->seto_parentId('1');
  497.         $newObject->setstoreProduct($productObj);
  498.         $newObject->save(["versionNote" => "Product created from SAP"]);
  501.         $msku = $productObj->getold_material_number();
  502.         $sku_name = $productObj->getname();
  503.         if (!empty($msku)) {
  504.             $msku = floatval($msku);
  505.         }
  507.         $newObject = new DataObject\ProductITCStore();
  508.         $newObject->setKey(\Pimcore\Model\Element\Service::getValidKey('Store_'.$key, 'object'));
  509.         $newObject->seto_parentId('1');
  510.         $newObject->setmsku_itcstore($msku);
  511.         $newObject->setsku_name($sku_name);
  512.         $newObject->setproduct_title($sku_name);
  513.         $newObject->setstoreProduct($productObj);
  514.         $newObject->save(["versionNote" => "Product created from SAP"]);
  516.         // $productSyncKey = "enlwq7pkg6t2od9blt93coomo7g6p9p0"; // Live Integration
  517.         $productSyncKey = "qzgg1vbpgwk6pjctbv6ku2a65906ocpb"; // Local
  519.         // $productUpdatedUrl = 'https://integration-5ojmyuq-23txbi6folvo6.ap-3.magentosite.cloud/rest/V1/bridge/catalog/product/add';
  520.         // $productUpdatedUrl = 'http://local.itc.com/rest/V1/bridge/catalog/product/add';
  522.         // $data = array( "product_id" => $productObj->getId(),"store_view_id" => "0", );
  523.         // $data_json = json_encode(array("data" => $data));
  525.         // $curl = curl_init();
  526.         // curl_setopt($curl, CURLOPT_CUSTOMREQUEST, "PUT");
  527.         // curl_setopt($curl, CURLOPT_POSTFIELDS, $data_json);
  528.         // curl_setopt($curl, CURLOPT_URL, $productUpdatedUrl);
  529.         // curl_setopt($curl, CURLOPT_HTTPHEADER, array( 'Authorization: Bearer ' . $productSyncKey, 'Accept: application/json', 'Content-Type:application/json', ));
  530.         // curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
  531.         // curl_setopt($curl, CURLOPT_HTTPAUTH, CURLAUTH_BASIC);
  533.         // $result = curl_exec($curl);
  534.         // $resultArray = json_decode($result);
  535.         // curl_close($curl);
  536.     }
  538.     public function snopEmailNotification(EnterEvent $e) {
  540.         $objectData = $e->getSubject();
  541.         $productId = $objectData->getId();
  542.         $transition = $e->getTransition();
  543.         $toPlace = $transition->getTos();
  545.         foreach ($toPlace as $key => $value) {
  547.             if($objectData->getpreviousWorkflowPlace() != 'sap_action') {
  548.                 $objectData->setpreviousWorkflowPlace($value);
  549.             }
  551.             switch ($value) {
  553.                 case 'packaging_to_snop':
  554.                     $this->packagingToSnop($objectData);
  555.                     break;
  557.                 case 'finance_to_snop':
  558.                     $this->financeToSnop($objectData);
  559.                     break;
  561.                 case 'brand_to_snop':
  562.                     $this->brandToSnop($objectData);
  563.                     break;
  565.                 case 'indirectTax_to_snop':
  566.                     $this->indirectTaxToSnop($objectData);
  567.                     break;
  569.                 case 'operations_to_snop':
  570.                     $this->operationsToSnop($objectData);
  571.                     break;
  573.                 case 'demandPlanning_to_snop':
  574.                     $this->demandPlanningToSnop($objectData);
  575.                     break;
  577.                 case 'smis_to_snop':
  578.                     $this->smisToSnop($objectData);
  579.                     break;
  580.     
  581.                 default:
  582.                     # code...
  583.                     break;
  584.             }
  585.         }
  586.     }
  588.     public function sapCorrectionEmails(AnnounceEvent $e) {
  590.         if ($this->executePreviousEvents) {
  592.             $this->sendComment = true;
  593.             $objectData = $e->getSubject();
  594.             $className = $objectData->getClassName();
  595.             $objectId = $objectData->getId();
  596.             $transition = $e->getTransition();
  597.             $toPlace = $transition->getTos();
  599.             if ($className == 'ProductByName') {
  600.                 $products = $objectData->getproducts();
  601.                 $this->commonId = $objectId;
  602.                 foreach ($products as $key => $value) {
  604.                     if ($key == 0) {
  605.                         $this->applyTransition($value,$toPlace,true);
  606.                     }
  607.                     $value->setpreviousWorkflowPlace(implode(',',$toPlace));
  608.                     $value->save();
  609.                     $objectData->setpreviousPlace(implode(',',$toPlace));
  610.                 }
  611.             } else {
  612.                 $this->applyTransition($objectData,$toPlace,true);
  613.             }
  615.             $this->executePreviousEvents = false;
  616.         }
  617.     }
  619.     public function correctionEmails(CompletedEvent $e) {
  621.         if ($this->executePreviousEvents) {
  623.             $this->sendComment = true;
  625.             $objectData = $e->getSubject();
  626.             $className = $objectData->getClassName();
  627.             $objectId = $objectData->getId();
  628.             $transition = $e->getTransition();
  629.             $toPlace = $transition->getTos();
  631.             if ($className == 'ProductByName') {
  632.                 $products = $objectData->getproducts();
  633.                 $this->commonId = $objectId;
  634.                 foreach ($products as $key => $value) {
  635.                     if ($key == 0) {
  636.                         $this->applyTransition($value,$toPlace,true);
  637.                     }
  638.                     $value->setpreviousWorkflowPlace(implode(',',$toPlace));
  639.                     $value->save();
  640.                     $objectData->setpreviousPlace(implode(',',$toPlace));
  641.                 }
  642.             } else {
  643.                 $this->applyTransition($objectData,$toPlace,true);
  644.             }
  646.             $this->executePreviousEvents = false;
  647.         }
  648.     }
  650.     public function emailNotification(EnterEvent $e) {
  652.         if ($this->executePreviousEvents) {
  654.             $objectData = $e->getSubject();
  655.             $className = $objectData->getClassName();
  657.             $transition = $e->getTransition();
  658.             $toPlace = $transition->getTos();
  660.             if ($className == 'ProductByName') {
  661.                 $products = $objectData->getproducts();
  662.                 $this->commonId = $objectData->getId();
  663.                 foreach ($products as $key => $value) {
  664.                     if ($key == 0) {
  665.                         $this->applyTransition($value,$toPlace,true);
  666.                     }
  667.                     $value->setpreviousWorkflowPlace(implode(',',$toPlace));
  668.                     $value->save();
  669.                     $objectData->setpreviousPlace(implode(',',$toPlace));
  670.                 }
  671.             } else {
  672.                 $this->applyTransition($objectData,$toPlace,true);
  673.             }
  675.             $this->executePreviousEvents = false;
  676.         }
  677.     }
  679.     public function saveLsmwSheetAction($projectId = false,$isProduct = false) {
  681.         require_once('third_party/vendor/autoload.php');
  683.         $spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet();
  684.         $sheet = $spreadsheet->getActiveSheet();
  686.         $xlsHead = array('Material Number','Industry sector','Material type','Plant','Storage location','Sales Organization','Distribution Channel','Indicator: include first Work Schedu','Include Accounting View','Indicator: consider MRP 1 view','Indicator: consider "MRP 2"','Indicator: Consider Purchasing view','Indicator: consider Purchase Order T','Include Basic Data View','Indicator: consider "Storage" view','Indicator: consider "forecasting" vi','Include "Warehouse Management" View','Indicator: consider Sales 1 view','Indicator: consider Sales Text view','Indicator: consider Sales/Plant Data view','Indicator: take Production Resources/Tools view into acc','Indicator: consider "quality assurance" view','Indicator: Take "Costing" view into account','Indicator: take Classification view into account','Indicator: Take "Work Scheduling 2" View into Account','Indicator: Take "MRP 3" view into account','UOM','Material description','Material group','product hieararchy','Old material number','Gross weight (BTCI)','Net weight','Weight Unit','Volume','Volume unit','Ind.Std.Descr','basic material','Size/dimensions','Division','Delivering Plant','Minimum order quantity in base unit of measure (B','Cash discount indicator','Material statistics group','Item category group from material master','Product hierarchy','material group1','material group2','material group3','material group4','material group5','Pricing reference material','Material Pricing Group','Account assignment group for this material','Tax category (sales tax, federal sales tax,...)','Tax classification material','Batch management','Transportation group','Loading group','Text','Order unit','Purchasing value key','Purchasing group','Tax indicator for material (Purchasing)','Control code','Post to inspection stock','Spcial procurement key','MRP group','Valid from','MRP Type','Procurement type','Backflush','Prod. stor. location','In-house production','SchedMargin key','Planning strategy group','Consumption mode','Bwd consumption per.','MRP controller','Planned delivery time','Fiscal year variant','Safety stock','ss days','Lot size (materials planning)','Minimum lot size','Maximum lot size','Fixed lot size','Rounding value for purchase order quantity','Checking Group for Availability Check','material freight group','Period indicator','Selection method','Dependent requirements ind. for individual and coll.','prod sched profile','Under delivery','Over delivery','unltd over delivery','Production scheduler','Processing time (BTCI)','Setup time (BTCI)','Interoperation time (BTCI)','Base quantity (BTCI)','STORAGE CONDITION','Unit of issue','Price control indicator','Moving average price (BTCI)','Standard price','Price unit (BTCI)','Valuation Class','Profit Center','Origin Group as Subdivision of Cost Element','Lot Size of Product Cost Estimate (BTCI)','Material Is Costed with Quantity Structure','QM in Procurement is Active','Ind.: Repetitive mfg allowed','Certificate Type','Control Key for Quality Management in Procurement','Documentation required indicator','Variance Key','Repetitive manufacturing profile','GR processing time','Catalog Profile','Minimum Remaining Shelf Life (BTCI)','Total shelf life in days (BTCI)','Discontinuation indicator','Effective-Out Date (BTCI)','Follow-up material','Material-related origin','Interval to next periodic inspection (BTCI)','Fair share rule','Period indicator for shelf life expiration date','Selection method','Component Scrap %');
  687.         $projectName = '';
  689.         if ($projectId) {
  691.             if ($isProduct) {
  693.                 $products = DataObject\Products::getById($projectId);
  695.                 if (!empty($products)) {
  696.                     $projectName = $products->getname().'_';
  697.                     $products = array($products);
  698.                 } else {
  699.                     return '';
  700.                 }
  702.             } else {
  704.                 $products = new DataObject\ProductByName\Listing();
  705.                 $products->setCondition(" o_id = $projectId ");
  707.                 if (!empty($products->getdata())) {
  708.                     $products = $products->getdata()[0];
  709.                     $projectName = $products->getproductName().'_';
  710.                     $products = $products->getproducts();
  711.                 } else {
  712.                     return '';
  713.                 }
  714.             }
  715.         }
  717.         $col = 'A';
  718.         foreach ($xlsHead as $key => $value) {
  719.             $colIndex = $col;
  720.             $sheet->setCellValue($col++.'1', $value);
  721.             $sheet->getColumnDimension($colIndex)->setWidth(30);
  722.         }
  724.         $index = 2;
  725.         $col = 'A';
  727.         $saldistData = new DataObject\SalesAndDistribution\Listing();
  728.         $so = array(); $ds = array();
  729.         foreach ($saldistData as $key => $value) {
  730.             $so[] = $value->getsalesOrganization();
  731.             $ds[] = $value->getdistributionChannel();
  732.         }
  734.         foreach ($products as $key => $value) {
  736.             // $so = (!empty($value->getsales_organization())) ? $value->getsales_organization() : array();
  737.             // $ds = (!empty($value->getdistribution_channel())) ? $value->getdistribution_channel() : array();
  739.             $plants = array();
  740.             if (is_array($value->getplant())) {
  741.                 $plants = $value->getplant();
  742.             } else {
  743.                 $plants[] = $value->getplant();
  744.             }
  746.             $division = trim(strtolower($value->getdivision()));
  748.             $arrayLength = count($plants);
  750.             for ($i = 0; $i < $arrayLength; $i++) {
  752.                 $plantValue = $plants[$i % count($plants)];
  753.                 $soValue = $so[$i % count($so)];
  754.                 $dsValue = $ds[$i % count($ds)];
  756.                 $sheet->setCellValue('A'.$index, $value->getmaterial_number());
  757.                 $sheet->setCellValue('B'.$index, (!empty($value->getindustry_sector()) ? $value->getindustry_sector() : 'F'));
  758.                 $sheet->setCellValue('C'.$index, $value->getmaterial_type());
  759.                 $sheet->setCellValue('D'.$index, $plantValue);
  760.                 $storage_location = (!empty($value->getstorage_location())) ? implode(',',$value->getstorage_location()) : 'BRND';
  761.                 $sheet->setCellValue('E'.$index, $storage_location);
  763.                 $sheet->setCellValue('F'.$index, $soValue);
  764.                 $sheet->setCellValue('G'.$index, $dsValue);
  765.                 $sheet->setCellValue('H'.$index, 'X');
  766.                 $sheet->setCellValue('I'.$index, 'X');
  767.                 $sheet->setCellValue('J'.$index, 'X');
  768.                 $sheet->setCellValue('K'.$index, 'X');
  769.                 $sheet->setCellValue('L'.$index, 'X');
  770.                 $sheet->setCellValue('M'.$index, 'X');
  771.                 $sheet->setCellValue('N'.$index, 'X');
  772.                 $sheet->setCellValue('O'.$index, 'X');
  773.                 $sheet->setCellValue('P'.$index, 'X');
  774.                 $sheet->setCellValue('Q'.$index, 'X');
  775.                 $sheet->setCellValue('R'.$index, 'X');
  776.                 $sheet->setCellValue('S'.$index, 'X');
  777.                 $sheet->setCellValue('T'.$index, 'X');
  778.                 $sheet->setCellValue('U'.$index, 'X');
  779.                 $sheet->setCellValue('V'.$index, 'X');
  780.                 $sheet->setCellValue('W'.$index, 'X');
  781.                 $sheet->setCellValue('X'.$index, 'X');
  782.                 $sheet->setCellValue('Y'.$index, 'X');
  783.                 $sheet->setCellValue('Z'.$index, 'X');
  784.                 $sheet->setCellValue('AA'.$index, $value->getuom());
  785.                 $sheet->setCellValue('AB'.$index, $value->getmaterial_description());
  786.                 $sheet->setCellValue('AC'.$index, $value->getmaterial_group());
  787.                 $sheet->setCellValue('AD'.$index, $value->getproduct_hieararchy());
  788.                 $sheet->setCellValue('AE'.$index, $value->getold_material_number());
  789.                 $net_weight = (!empty($value->getnet_weight())) ? $value->getnet_weight() : 1.000;
  790.                 $wu = $net_weight;
  792.                 if ($division == 'ss') {
  793.                     $sheet->setCellValue('AF'.$index, $value->getpack_weight());
  794.                     $sheet->setCellValue('AG'.$index, $value->getpack_weight());
  795.                 } else {
  796.                     $sheet->setCellValue('AF'.$index, $wu);
  797.                     $sheet->setCellValue('AG'.$index, $net_weight);
  798.                 }
  800.                 $sheet->setCellValue('AH'.$index, (!empty($value->getweight_unit()) ? $value->getweight_unit() : 'KG'));
  802.                 $vlume = '';
  803.                 if(!empty($value->getlength()) && !empty($value->getbreadth()) && !empty($value->getheight()) && !empty($value->getcfcweightgross())) {
  804.                     $vlume = ($value->getlength() * $value->getbreadth() * $value->getheight()) / $value->getcfcweightgross();
  805.                     $vlume = round($vlume,3);
  806.                 }
  807.                 $sheet->setCellValue('AI'.$index, $vlume);
  808.                 $sheet->setCellValue('AJ'.$index, (!empty($value->getvolume_unit()) ? $value->getvolume_unit() : 'M3'));
  809.                 $sheet->setCellValue('AK'.$index, '');
  810.                 $sheet->setCellValue('AL'.$index, '');
  811.                 $sheet->setCellValue('AM'.$index, '');
  812.                 $sheet->setCellValue('AN'.$index, $value->getdivision());
  813.                 $sheet->setCellValue('AO'.$index, '');
  814.                 $gw = $value->getcfcweightgross();
  815.                 if(!empty($gw)) {
  816.                     $gw = number_format((float)$gw, 3, '.', '');
  817.                 }
  819.                 if ($division == 'ss') {
  820.                     $sheet->setCellValue('AP'.$index, '');
  821.                 } else {
  822.                     $sheet->setCellValue('AP'.$index, $gw);
  823.                 }
  824.                 $sheet->setCellValue('AQ'.$index, (!empty($value->getcash_discount_indicator()) ? $value->getcash_discount_indicator() : "X"));
  825.                 $sheet->setCellValue('AR'.$index, (!empty($value->getmaterial_statistics_group()) ? $value->getmaterial_statistics_group() : '1'));
  826.                 $sheet->setCellValue('AS'.$index, (!empty($value->getitem_category_group()) ? $value->getitem_category_group() : 'NORM'));
  827.                 $sheet->setCellValue('AT'.$index, $value->getproduct_hieararchy());
  828.                 $sheet->setCellValue('AU'.$index, (!empty($value->getmaterial_group1()) ? $value->getmaterial_group1() : 'GFP'));
  829.                 $sheet->setCellValue('AV'.$index, $value->getmaterial_group2());
  830.                 $sheet->setCellValue('AW'.$index, $value->getmaterial_group3());
  831.                 $sheet->setCellValue('AX'.$index, $value->getmaterial_group4());
  832.                 $sheet->setCellValue('AY'.$index, $value->getmaterial_group5());
  833.                 $sheet->setCellValue('AZ'.$index, '');
  834.                 $sheet->setCellValue('BA'.$index, $value->getmaterial_pricing_group());
  835.                 $sheet->setCellValue('BB'.$index, $value->getaccount_assignment());
  836.                 $sheet->setCellValue('BC'.$index, (!empty($value->gettax_category()) ? $value->gettax_category() : 'JOIG'));
  837.                 $sheet->setCellValue('BD'.$index, (!empty($value->gettax_classification_material()) ? $value->gettax_classification_material() : '0'));
  838.                 $sheet->setCellValue('BE'.$index, (!empty($value->getbatch_management()) ? $value->getbatch_management() : 'X'));
  839.                 $sheet->setCellValue('BF'.$index, (!empty($value->gettransportation_group()) ? $value->gettransportation_group() : 'Z001'));
  840.                 $sheet->setCellValue('BG'.$index, (!empty($value->getloading_group()) ? $value->getloading_group() : '0001'));
  841.                 $sheet->setCellValue('BH'.$index, '');
  842.                 $sheet->setCellValue('BI'.$index, '');
  843.                 $sheet->setCellValue('BJ'.$index, '');
  844.                 $sheet->setCellValue('BK'.$index, $value->getpurchasing_group());
  845.                 $sheet->setCellValue('BL'.$index, '');
  846.                 $sheet->setCellValue('BM'.$index, $value->gethsn_code());
  847.                 $sheet->setCellValue('BN'.$index, '');
  848.                 $sheet->setCellValue('BO'.$index, '');
  849.                 $sheet->setCellValue('BP'.$index, '');
  850.                 $sheet->setCellValue('BQ'.$index, '');
  851.                 $sheet->setCellValue('BR'.$index, (!empty($value->getmrp_type()) ? $value->getmrp_type() : 'X0'));
  853.                 if ($division == 'ss') {
  854.                     $sheet->setCellValue('BS'.$index, '');
  855.                     $sheet->setCellValue('BU'.$index, '');
  856.                 } else {
  857.                     $sheet->setCellValue('BS'.$index, $value->getprocurement_type());
  858.                     $sheet->setCellValue('BU'.$index, $value->getproduction_storage_location());
  859.                 }
  860.                 $sheet->setCellValue('BT'.$index, '');
  861.                 $sheet->setCellValue('BV'.$index, '');
  862.                 $sheet->setCellValue('BW'.$index, (!empty($value->getschedmargin_key()) ? $value->getschedmargin_key() : '000'));
  863.                 $sheet->setCellValue('BX'.$index, '');
  864.                 $sheet->setCellValue('BY'.$index, '');
  865.                 $sheet->setCellValue('BZ'.$index, '');
  866.                 $sheet->setCellValue('CA'.$index, $value->getmrp_controller());
  867.                 $sheet->setCellValue('CB'.$index, '');
  868.                 $sheet->setCellValue('CC'.$index, '');
  869.                 $sheet->setCellValue('CD'.$index, '');
  871.                 if ($division == 'ss') {
  872.                     $sheet->setCellValue('CE'.$index, '');
  873.                 } else {
  874.                     $sheet->setCellValue('CE'.$index, (!empty($value->getss_days()) ? $value->getss_days() : '4'));
  875.                 }
  877.                 $sheet->setCellValue('CF'.$index, (!empty($value->getlot_size()) ? $value->getlot_size() : 'EX'));
  878.                 $minimum_lot_size = (!empty($value->getminimum_lot_size()) ? $value->getminimum_lot_size() : $value->getcfcweightgross());
  880.                 if ($division == 'ss') {
  881.                     $sheet->setCellValue('CG'.$index, '');
  882.                 } else {
  883.                     $sheet->setCellValue('CG'.$index, $minimum_lot_size); // fixed value = CFC wt
  884.                 }
  885.                 $mls = (!empty($value->getmaximum_lot_size()) ? $value->getmaximum_lot_size() : $value->getcfcweightgross()*10000);
  887.                 if ($division == 'ss') {
  888.                     $sheet->setCellValue('CH'.$index, '');
  889.                 } else {
  890.                     $sheet->setCellValue('CH'.$index, $mls); // fixed value = CFC wt *10000
  891.                 }
  892.                 $sheet->setCellValue('CI'.$index, '');
  893.                 $rv = (!empty($value->getrounding_value()) ? $value->getrounding_value() : $value->getcfcweightgross());
  895.                 if ($division == 'ss') {
  896.                     $sheet->setCellValue('CJ'.$index, '');
  897.                 } else {
  898.                     $sheet->setCellValue('CJ'.$index, $rv); //fixed value = CFC wt
  899.                 }
  900.                 $sheet->setCellValue('CK'.$index, '02');
  901.                 $sheet->setCellValue('CL'.$index, (!empty($value->getmaterial_freight_group()) ? $value->getmaterial_freight_group() : '0'));
  902.                 $sheet->setCellValue('CM'.$index, (!empty($value->getperiod_indicator()) ? $value->getperiod_indicator() : 'M'));
  903.                 $sheet->setCellValue('CN'.$index, (!empty($value->getselection_method()) ? $value->getselection_method() : '2'));
  904.                 $sheet->setCellValue('CO'.$index, '');
  905.                 $sheet->setCellValue('CP'.$index, '');
  906.                 $sheet->setCellValue('CQ'.$index, '');
  907.                 $sheet->setCellValue('CR'.$index, '');
  908.                 $sheet->setCellValue('CS'.$index, '');
  909.                 $sheet->setCellValue('CT'.$index, '');
  910.                 $sheet->setCellValue('CU'.$index, '');
  911.                 $sheet->setCellValue('CV'.$index, '');
  912.                 $sheet->setCellValue('CW'.$index, '');
  913.                 $sheet->setCellValue('CX'.$index, '');
  914.                 $sheet->setCellValue('CY'.$index, '01');
  915.                 $sheet->setCellValue('CZ'.$index, '');
  916.                 $sheet->setCellValue('DA'.$index, 'V');
  917.                 $sheet->setCellValue('DB'.$index, '');
  918.                 $sheet->setCellValue('DC'.$index, '');
  919.                 $sheet->setCellValue('DD'.$index, '1');
  920.                 $sheet->setCellValue('DE'.$index, $value->getvaluation_class());
  921.                 $sheet->setCellValue('DF'.$index, $value->getprofit_center());
  922.                 $sheet->setCellValue('DG'.$index, $value->getvaluation_class());
  923.                 $sheet->setCellValue('DH'.$index, '1000'); //$value->getlot_size_of_product_cost()
  924.                 $sheet->setCellValue('DI'.$index, 'X'); //$value->getmaterial_cost()
  925.                 $sheet->setCellValue('DJ'.$index, '');
  926.                 $sheet->setCellValue('DK'.$index, '');
  927.                 $sheet->setCellValue('DL'.$index, '');
  928.                 $sheet->setCellValue('DM'.$index, '');
  929.                 $sheet->setCellValue('DN'.$index, 'X');
  930.                 $sheet->setCellValue('DO'.$index, '000001'); //$value->getvariance_key()
  931.                 $sheet->setCellValue('DP'.$index, '');
  932.                 $sheet->setCellValue('DQ'.$index, '');
  933.                 $sheet->setCellValue('DR'.$index, 'FBD000001'); //$value->getcatalog_profile()
  934.                 $sheet->setCellValue('DS'.$index, $value->getminimum_remaining_shelf_life());
  935.                 $sheet->setCellValue('DT'.$index, $value->gettotal_shelf_life());
  936.                 $sheet->setCellValue('DU'.$index, '');
  937.                 $sheet->setCellValue('DV'.$index, '');
  938.                 $sheet->setCellValue('DW'.$index, '');
  939.                 $mro = (!empty($value->getmaterial_related_origin())) ? implode(',',$value->getmaterial_related_origin()) : 'X';
  940.                 $sheet->setCellValue('DX'.$index, $mro);
  941.                 $sheet->setCellValue('DY'.$index, '');
  942.                 $sheet->setCellValue('DZ'.$index, '');
  943.                 $sheet->setCellValue('EA'.$index, 'D');
  944.                 $sheet->setCellValue('EB'.$index, '2');
  945.                 $sheet->setCellValue('EC'.$index, '');
  947.                 // $sheet->setCellValue('ED'.$index, $value->getpack_weight());
  948.                 // $sheet->setCellValue('EE'.$index, $value->getcfcweight());
  950.                 $index++;
  951.                 $col++;
  952.             }
  953.         }
  955.         $xlsName = $projectName.'LSMW_';
  957.         $fileName = (!empty($xlsName)) ? $xlsName.date('d M').'.xlsx' : 'Products'.date('d M').'.xlsx';
  959.         $folderName = '';
  961.         try {
  963.             if (!is_dir('product')) {
  964.                 mkdir('product/',0777);
  965.                 $folderName = 'product/';
  966.             } else if (is_dir('product')) {
  967.                 $folderName = 'product/';
  968.             } else {
  969.                 $folderName = '';
  970.             }
  972.         } catch (\Throwable $th) {
  973.             $folderName = '';
  974.         }
  976.         try {
  977.             unlink($folderName.$fileName);
  978.         } catch (\Throwable $th) {
  979.         }
  981.         $writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet);
  982.         $writer->save($folderName.$fileName);
  984.         return $folderName.$fileName;
  985.     }
  987.     public function saveYvbymaraAction($projectId,$isProduct = false) {
  989.         require_once('third_party/vendor/autoload.php');
  991.         $spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet();
  992.         $sheet = $spreadsheet->getActiveSheet();
  994.         if ($projectId) {
  996.             if ($isProduct) {
  998.                 $products = DataObject\Products::getById($projectId);
  1000.                 if (!empty($products)) {
  1001.                     $projectName = $products->getname().'_';
  1002.                     $products = array($products);
  1003.                 } else {
  1004.                     return '';
  1005.                 }
  1007.             } else {
  1009.                 $products = new DataObject\ProductByName\Listing();
  1010.                 $products->setCondition(" o_id = $projectId ");
  1012.                 if (!empty($products->getdata())) {
  1013.                     $products = $products->getdata()[0];
  1014.                     $projectName = $products->getproductName().'_';
  1015.                     $products = $products->getproducts();
  1016.                 } else {
  1017.                     return '';
  1018.                 }
  1019.             }
  1020.         }
  1022.         $xlsHead = array('MSKU','Material','DISCRIPTION','VARIANT','VARIANT_DESCR','SUBCAT','SUBCAT_DESCR','BRAND','CROSSPROMOITC','CROSSPROMONON_ITC','NICHE_NON_NICHE','ATTRIBUTE_Y');
  1024.         $col = 'A';
  1025.         foreach ($xlsHead as $key => $value) {
  1026.             $colIndex = $col;
  1027.             $sheet->setCellValue($col++.'1', $value);
  1028.             $sheet->getColumnDimension($colIndex)->setWidth(30);
  1029.         }
  1031.         $index = 2;
  1032.         $col = 'A';
  1034.         foreach ($products as $key => $value) {
  1036.             $sheet->setCellValue('A'.$index, $value->getold_material_number());
  1037.             $sheet->setCellValue('B'.$index, $value->getmaterial_number());
  1038.             $sheet->setCellValue('C'.$index, $value->getmaterial_description());
  1039.             $sheet->setCellValue('D'.$index, $value->getvariant());
  1040.             $sheet->setCellValue('E'.$index, $value->getvariant_description());
  1041.             $sheet->setCellValue('F'.$index, $value->getsubcat());
  1042.             $sheet->setCellValue('G'.$index, $value->getsubcat_descr());
  1043.             $sheet->setCellValue('H'.$index, $value->getbrand());
  1044.             $sheet->setCellValue('I'.$index, $value->getcross_promo_itc());
  1045.             $sheet->setCellValue('J'.$index, $value->getcross_promo_nonitc());
  1046.             $sheet->setCellValue('K'.$index, $value->getniche_non_niche());
  1047.             $sheet->setCellValue('L'.$index, $value->getattribute_y());
  1048.             $index++;
  1049.         }
  1051.         $xlsName = $projectName.'YVBYMARA_'.date('d M').'.xlsx';
  1052.         $fileName = $xlsName;
  1054.         $folderName = '';
  1056.         try {
  1058.             if (!is_dir('product')) {
  1059.                 mkdir('product/',0777);
  1060.                 $folderName = 'product/';
  1061.             } else if (is_dir('product')) {
  1062.                 $folderName = 'product/';
  1063.             } else {
  1064.                 $folderName = '';
  1065.             }
  1067.         } catch (\Throwable $th) {
  1068.             $folderName = '';
  1069.         }
  1071.         try {
  1072.             unlink($folderName.$fileName);
  1073.         } catch (\Throwable $th) {
  1074.             //echo $th; exit;
  1075.         }
  1077.         $writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet);
  1078.         $writer->save($folderName.$fileName);
  1080.         return $folderName.$fileName;
  1081.     }
  1083.     public function saveAdditionalDataAction($projectId = false, $isProduct = false) {
  1085.         require_once('third_party/vendor/autoload.php');
  1087.         $spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet();
  1088.         $sheet = $spreadsheet->getActiveSheet();
  1090.         $xlsHead = array('Material','view','EAN','Z1','BG','Z1 DISC','BG DISC','ST Denominator','PAC Denominator','CFC Denominator','ST','PAC','CFC','ST Numerator','PAC Numerator','CFC Numerator','L','B','H','M','M3','M3/KG  Denominator','M3/KG','M3/KG  Numerator','HE','vajra');
  1092.         if ($projectId) {
  1094.             if ($isProduct) {
  1096.                 $products = DataObject\Products::getById($projectId);
  1098.                 if (!empty($products)) {
  1099.                     $projectName = $products->getname().'_';
  1100.                     $products = array($products);
  1101.                 } else {
  1102.                     return '';
  1103.                 }
  1105.             } else {
  1107.                 $products = new DataObject\ProductByName\Listing();
  1108.                 $products->setCondition(" o_id = $projectId ");
  1110.                 if (!empty($products->getdata())) {
  1111.                     $products = $products->getdata()[0];
  1112.                     $projectName = $products->getproductName().'_';
  1113.                     $products = $products->getproducts();
  1114.                 } else {
  1115.                     return '';
  1116.                 }
  1117.             }
  1118.         }
  1120.         $col = 'A';
  1121.         foreach ($xlsHead as $key => $value) {
  1122.             $colIndex = $col;
  1123.             $sheet->setCellValue($col++.'1', $value);
  1124.             $sheet->getColumnDimension($colIndex)->setWidth(30);
  1125.         }
  1127.         $index = 2;
  1128.         $col = 'A';
  1130.         foreach ($products as $key => $value) {
  1132.             $sheet->setCellValue('A'.$index, $value->getmaterial_number());
  1133.             $sheet->setCellValue('B'.$index, 'X');
  1134.             $sheet->setCellValue('C'.$index, $value->getean_number());
  1135.             $sheet->setCellValue('D'.$index, 'Z1');
  1136.             $sheet->setCellValue('E'.$index, "BG");
  1137.             $sheet->setCellValue('F'.$index, $value->getzi_disc());
  1138.             $sheet->setCellValue('G'.$index, $value->getbg_disc());
  1139.             $sheet->setCellValue('H'.$index, '1');
  1140.             $sheet->setCellValue('I'.$index, '1000');
  1141.             $sheet->setCellValue('J'.$index, '1000');
  1142.             $sheet->setCellValue('K'.$index, 'ST');
  1143.             $sheet->setCellValue('L'.$index, 'PAC');
  1144.             $sheet->setCellValue('M'.$index, 'CFC');
  1145.             $sheet->setCellValue('N'.$index, '1');
  1146.             $sheet->setCellValue('O'.$index, $value->getpack_weight());
  1147.             $gw = $value->getcfcweightgross();
  1148.             if(!empty($gw)) {
  1149.                 $gw = number_format((float)$gw, 3, '.', '');
  1150.             }
  1151.             $sheet->setCellValue('P'.$index, $gw);
  1152.             $sheet->setCellValue('Q'.$index, $value->getlength());
  1153.             $sheet->setCellValue('R'.$index, $value->getbreadth());
  1154.             $sheet->setCellValue('S'.$index, $value->getheight());
  1155.             $sheet->setCellValue('T'.$index, 'M');
  1156.             $sheet->setCellValue('U'.$index, 'M3');
  1157.             $v = '';
  1158.             if(!empty($value->getlength()) && !empty($value->getbreadth()) * !empty($value->getheight())) {
  1159.                 $v = round(($value->getlength()*$value->getbreadth()*$value->getheight()),3);
  1160.             }
  1161.             $sheet->setCellValue('V'.$index, $v);
  1162.             $sheet->setCellValue('W'.$index, 'M3');
  1163.             $sheet->setCellValue('X'.$index, $gw);
  1164.             $sheet->setCellValue('Y'.$index, 'HE');
  1165.             $sheet->setCellValue('Z'.$index, $value->getvajra_description());
  1166.             $index++;
  1167.         }
  1169.         $xlsName = $projectName.'Additional_Data_';
  1171.         $fileName = (!empty($xlsName)) ? $xlsName.date('d M').'.xlsx' : 'Additional_Data'.date('d M').'.xlsx';
  1173.         $folderName = '';
  1175.         try {
  1177.             if (!is_dir('product')) {
  1178.                 mkdir('product/',0777);
  1179.                 $folderName = 'product/';
  1180.             } else if (is_dir('product')) {
  1181.                 $folderName = 'product/';
  1182.             } else {
  1183.                 $folderName = '';
  1184.             }
  1186.         } catch (\Throwable $th) {
  1187.             $folderName = '';
  1188.         }
  1190.         try {
  1191.             unlink($folderName.$fileName);
  1192.         } catch (\Throwable $th) {
  1193.             //echo $th; exit;
  1194.         }
  1196.         $writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet);
  1197.         $writer->save($folderName.$fileName);
  1199.         return $folderName.$fileName;
  1200.     }
  1202.     public function applyTransition($objectData,$toPlace,$isProductClass = true) {
  1204.         foreach ($toPlace as $key => $value) {
  1206.             if ($isProductClass) {
  1208.                 // if($objectData->getpreviousWorkflowPlace() != 'sap_action' || $value != 'sap_action') {
  1209.                     $objectData->setpreviousWorkflowPlace($value);
  1210.                 // }
  1211.             }
  1213.             switch ($value) {
  1215.                 case 'finance_action':
  1216.                     $this->financeAction($objectData);
  1217.                     break;
  1219.                 case 'brand_action':
  1220.                     $this->brandAction($objectData);
  1221.                     break;
  1223.                 case 'packaging_action':
  1224.                     $this->packagingAction($objectData);
  1225.                     break;
  1227.                 case 'indirect_tax_action':
  1228.                     $this->indirectTaxAction($objectData);
  1229.                     break;
  1231.                 case 'operations_action':
  1232.                     $this->operationsAction($objectData);
  1233.                     break;
  1235.                 case 'demand_planning_action':
  1236.                     $this->demandPlanningAction($objectData);
  1237.                     break;
  1239.                 case 'smis_action':
  1240.                     $this->smisAction($objectData);
  1241.                     break;
  1243.                 case 'sap_action':
  1244.                     $this->sapAction($objectData);
  1245.                     break;
  1247.                 case 'packaging_to_snop':
  1248.                     $this->packagingToSnop($objectData);
  1249.                     break;
  1251.                 case 'finance_to_snop':
  1252.                     $this->financeToSnop($objectData);
  1253.                     break;
  1255.                 case 'brand_to_snop':
  1256.                     $this->brandToSnop($objectData);
  1257.                     break;
  1259.                 case 'indirectTax_to_snop':
  1260.                     $this->indirectTaxToSnop($objectData);
  1261.                     break;
  1263.                 case 'operations_to_snop':
  1264.                     $this->operationsToSnop($objectData);
  1265.                     break;
  1267.                 case 'demandPlanning_to_snop':
  1268.                     $this->demandPlanningToSnop($objectData);
  1269.                     break;
  1271.                 case 'smis_to_snop':
  1272.                     $this->smisToSnop($objectData);
  1273.                     break;
  1275.                 case 'packaging_correction':
  1276.                     $this->packagingCorrection($objectData);
  1277.                     break;
  1279.                 case 'finance_correction':
  1280.                     $this->financeCorrection($objectData);
  1281.                     break;
  1283.                 case 'brand_correction':
  1284.                     $this->brandCorrection($objectData);
  1285.                     break;
  1286.                 
  1287.                 case 'indirectTax_correction':
  1288.                     $this->indirectTaxCorrection($objectData);
  1289.                     break;
  1290.                 
  1291.                 case 'operations_correction':
  1292.                     $this->operationteamCorrection($objectData);
  1293.                     break;
  1294.                 
  1295.                 case 'demandPlanning_correction':
  1296.                     $this->demandPlanningTeam($objectData);
  1297.                     break;
  1298.                 
  1299.                 case 'smis_correction':
  1300.                     $this->smisTeam($objectData);
  1301.                     break;
  1303.                 case 'snop_correction':
  1304.                     $this->snopCorrection($objectData);
  1305.                     break;
  1307.                 case 'sap_approved':
  1308.                     $this->sapApproved($objectData);
  1309.                     break;
  1310.    
  1311.                 case 'snop_packaging_correction':
  1312.                     $this->packagingCorrection($objectData);
  1313.                     break;
  1315.                 case 'snop_finance_correction':
  1316.                     $this->financeCorrection($objectData);
  1317.                     break;
  1319.                 case 'snop_brand_correction':
  1320.                     $this->brandCorrection($objectData);
  1321.                     break;
  1323.                 case 'snop_indirectTax_correction':
  1324.                     $this->indirectTaxCorrection($objectData);
  1325.                     break;
  1327.                 case 'snop_operations_correction':
  1328.                     $this->operationteamCorrection($objectData);
  1329.                     break;
  1331.                 case 'snop_demandPlanning_correction':
  1332.                     $this->demandPlanningTeam($objectData);
  1333.                     break;
  1335.                 case 'snop_smis_correction':
  1336.                     $this->smisTeam($objectData);
  1337.                     break;
  1338.                     
  1339.                 default:
  1340.                     # code...
  1341.                     break;
  1342.             }
  1343.         }
  1344.     }
  1345. }