src/Controller/CartController.php line 418

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use Pimcore\Controller\FrontendController;
  6. use Pimcore\Model\Asset\Image;
  7. use Pimcore\Mail;
  8. use Symfony\Component\HttpFoundation\Request;
  9. use Symfony\Component\HttpFoundation\Response;
  10. use Pimcore\Model\DataObject;
  11. use \Pimcore\Bundle\EcommerceFrameworkBundle\Factory;
  13. use PHPExcel_Writer_Excel2007;
  14. use Carbon\Carbon;
  15. use Pimcore\Model\Asset;
  16. use ZipArchive;
  17. use Symfony\Component\HttpFoundation\Session\SessionInterface;
  18. use Symfony\Component\Routing\Annotation\Route;
  19. use App\Model\DataObject\BrandExtension;
  20. use PHPExcel;
  21. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  22. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  23. use Symfony\Contracts\Translation\TranslatorInterface;
  24. use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  26. #require 'PHPExcel_1.8.0/Classes/PHPExcel.php';
  27. #require 'PHPExcel_1.8.0/Classes/PHPExcel/Writer/Excel2007.php';
  29. // class CartController extends \Website\Controller\CartAware
  30. /**
  31.      * @Route("/{_locale}/cart")    
  32. */
  33. class CartController extends CartAware
  34. {
  35.     const COMPANY_NAME = "BeamSuntory";
  36.     private $session;
  37.     private $trance;
  38.     public function __construct(SessionInterface $session, TranslatorInterface $trance)
  39.     {
  40.         $this->session = $session;
  41.         $this->trance = $trance;
  42.     }
  43.     /**
  44.      * show top navigation
  45.      */
  46.     public function topNavCartAction(Request $request)
  47.     {
  48.         $params = [];
  49.         $params['language'] = $request->getLocale();
  50.         $session = $request->getSession();
  51.         $authNamespace = $session->getBag('espirit');
  52.         if ($authNamespace->has('customeraccount')) {
  53.             $params['FirstName']  = $authNamespace->get('customeraccount')->getFirstName();
  54.             $params['LastName'] = $authNamespace->get('customeraccount')->getLastName();
  55.         }
  56.         $params['cart'] = $this->getCart();
  57.         return $this->render('Cart/topNavCart.html.twig',$params);
  58.         
  59.     }
  60.     /**
  61.      * show product landing
  62.      */
  63.     public function orderJsonAction(Request $request)
  64.     {
  65.         $orders = array();
  66.         $cart = $this->getCart();
  67.         if(count($cart->getItems()) == 0) {
  68.             echo json_encode($orders);
  69.             return;
  70.         }
  71.         $orderitems = array();
  72.         foreach($cart->getItems() as $item) {
  73.             $orderitems[] = array ( "id" => $item->getProduct()->getId(), "name" => $item->getProduct()->getOSName());
  74.         }
  75.         $orders["orderinfo"] = $orderitems;
  76.         //$authNamespace = new Zend_Session_Namespace('Zend_Auth');
  77.         $authNamespace = $this->get('session')->getBag('espirit');
  78.         if ($authNamespace->get('customeraccount')) {
  79.             $orders["customeraccount"] = $authNamespace->get('customeraccount');
  80.         }
  81.         $orders["downloadlink"] = $this->view->url(array('action' => 'delivery'), 'checkout'); 
  82.         echo @json_encode($orders);
  83.     }
  84.      /**
  85.      * @Route("/download", name="cart-download")
  86.      *
  87.      * @param Request $request
  88.      * 
  89.      */
  90.     public function downloadAction(Request $request)
  91.     {
  92.         
  93.         set_time_limit(6000);
  94.         ini_set('memory_limit', '1024M'); 
  95.         //$this->layout()->setLayout('cart');
  96.         //$this->enableLayout();
  97.         $params = [];
  98.         $params['locale'] = strtolower($request->getLocale());
  99.         $params['hideNav'] = true;
  100.         $cart = $this->getCart();
  101.         $params['cart'] = $cart;
  102.         $defaultCountry = DataObject\AvailabilityCountry::getByPath('/availability-countries/us');
  103.         if(isset($this->country)){
  104.             $availableCountry = $this->country;
  105.         }else{
  106.             $availableCountry = $defaultCountry;
  107.             $params['country'] = $defaultCountry;
  108.         }
  109.         //if cart empty, redirect to cart list
  110.         if(count($cart->getItems()) == 0) {
  111.             //$urlHelper = \Pimcore::getContainer()->get('pimcore.templating.view_helper.pimcore_url');  
  112.             //return $this->redirect($urlHelper(array('action' => 'list', 'prefix' => strtolower($this->locale)), 'cart', true));
  113.             return $this->redirectToRoute('shop-cart-detail');
  114.         }
  116.         $checkoutManager = Factory::getInstance()->getCheckoutManager( $cart );
  117.         $confirmStep = $checkoutManager->getCheckoutStep('confirm');
  118.         $checkoutManager->commitStep($confirmStep, true);
  119.         $order = $checkoutManager->commitOrder();
  120.         
  121.         //$authNamespace = new Zend_Session_Namespace('Zend_Auth');
  122.         //TODO
  123.         $fileformat = 'PNG'; //We will remove this after session implementation
  124.         $session = $request->getSession();
  125.         $authNamespace = $session->getBag('espirit');
  126.         
  127.         if ($authNamespace->get('photographyfileformat') == 'JPG') {
  128.             $fileformat = 'JPG';
  129.         } else {
  130.             $fileformat = 'PNG';
  131.         }
  132.         
  133.         //TODO
  134.         $dim = "original";  //We will remove this after session implementation
  135.         $thumbnail = ["format" => $fileformat]; //We will remove this AFTER fix line no 131
  136.         
  137.         if ($authNamespace->get('photographyfiledimension')) {
  138.             switch ($authNamespace->get('photographyfiledimension')) {
  139.                 case 'eSpirits_1':
  140.                     $thumbnail = ["format" => $fileformat];
  141.                     $dim = "original";
  142.                 break;
  143.                 case 'eSpirits_2':
  144.                     $thumbnail = ["width" => 750, "height" => 1500, "frame" => true, "format" => $fileformat];
  145.                     $dim = "750x1500";
  146.                 break;
  147.                 case 'eSpirits_3':
  148.                     $thumbnail = ["width" => 1000, "height" => 1000, "frame" => true, "format" => $fileformat];
  149.                     $dim = "1000x1000";
  150.                 break;
  151.                 case 'eSpirits_4':
  152.                     $thumbnail = ["width" => 1500, "height" => 1500, "frame" => true, "format" => $fileformat];
  153.                     $dim = "1500x1500";
  154.                 break;
  155.                 case 'eSpirits_5':
  156.                     $thumbnail = ["width" => 2000, "height" => 2000, "frame" => true, "format" => $fileformat];
  157.                     $dim = "2000x2000";
  158.                 break;
  159.                 case 'eSpirits_6':
  160.                     $thumbnail = ["width" => 2500, "height" => 2500, "frame" => true, "format" => $fileformat];
  161.                     $dim = "2500x2500";
  162.                 break;
  163.                 default:
  164.                     $thumbnail = ["format" => $fileformat];
  165.                     $dim = "original";
  166.                 break;
  167.             }
  168.         }
  169.         $order->setcountry($params['country']->getName());
  171.         //TODO
  172.         $order->setcustomer($authNamespace->get('customeraccount'));
  173.         $order->setdatafileformat($authNamespace->get('datafileformat'));
  174.         $order->setotheremail($authNamespace->get('otheremail'));
  175.         $order->setphotographyfileformat($authNamespace->get('photographyfileformat'));
  176.         //$order->setcustomer('Rohit');
  177.         $order->setdatafileformat($fileformat);
  178.         $order->setotheremail('assd.fff');
  179.         $order->setphotographyfileformat($authNamespace->get('photographyfileformat'));
  181.         $order->setphotographyfiledimension($dim);
  182.         $order->setordertype("cart");
  183.         $order->save();
  185.         //Get the order zip file
  187.         //TODO
  188.         
  189.         if ($authNamespace->get('customeraccount')) {
  190.             $params['firstname'] = $authNamespace->get('customeraccount')->getFirstName();
  191.             $params['lastname'] = $authNamespace->get('customeraccount')->getLastName();
  192.         }
  193.         
  194.         $params['firstname'] = '';
  195.         $params['lastname'] = '';
  197.         $excelfile = $this->create_download_file($order);
  198.         $orderdate = $order->getOrderDate();
  199.         $orderdate = Carbon::instance($orderdate);
  201.         //TODO
  202.         $downloadfilename = ((!empty($authNamespace->get('fileDownloadName'))) ? $authNamespace->get('fileDownloadName') : "Beam-Suntory_Product-Data") . "_" . $orderdate->format('Y-M-d') . "_" . $order->getId() . ".zip";
  204.         //$downloadfilename  = "Beam-Suntory_Product-Data" . "_" . $orderdate->format('Y-M-d') . "_" . $order->getId() . ".zip"; //WE will remove after fix LINE NO 196
  205.         $downloadfile = "/downloads/" . $order->getId() . "/{$downloadfilename}";
  206.         //Create the file
  207.         $downloaddir = realpath("downloads");
  208.         $downloadpath = "";
  209.         if (!file_exists($downloaddir . "/" . $order->getId())) {
  210.             mkdir($downloaddir . "/" . $order->getId(), 0777, true);
  211.         }
  212.         $downloadpath = $downloaddir . "/" . $order->getId() . "/{$downloadfilename}";
  213.         if (!empty($downloadpath)) {
  214.             $files_to_zip = array();
  215.             foreach ($order->getItems() as $item) {
  216.                 $product = $item->getProduct();
  218.                 //Get all the lifesize
  219.                 //TODO
  221.                 
  222.                 //Get all the bottle-size photos
  223.                 $sizeVariants = $product->getSizeVariants($this->country);
  224.                 if ($sizeVariants) {
  225.                     foreach($sizeVariants as $variant) {
  226.                         //if ($variant->getBottleSize() == '750 m') {
  227.                             $countries = $variant->getCountryAvailabilityList();
  228.                             $continue = 0;
  229.                             foreach ($countries as $country) {
  230.                                     if ($country->getObject()->getId() == $this->country->getId() && $country->geteSpiritsEnable() == 1) {
  231.                                         $continue = 1;
  232.                                         break;
  233.                                     }
  234.                             }
  235.                             if ($continue == 0) {
  236.                                 continue;
  237.                             }
  238.                             if ($variant->getBottlePhoto()) {
  239.                                 $files_to_zip[] = $variant->getBottlePhoto();
  240.                             }
  241.                             
  242.                             $additionalPhotos = $variant->getAdditionalPhotos();
  243.                     
  244.                             if(!empty($additionalPhotos))
  245.                             {
  246.                                 foreach($additionalPhotos as $a)
  247.                                 { 
  248.                                     $files_to_zip[] = $a['AdditionalPhoto']->getData();
  249.                                 }
  250.                             }
  251.                         }
  252.                     //}
  253.                 }
  254.                 
  255.                 /* Excluding Videos for now        
  256.                 $videos = $product->getVideoList();
  257.             
  258.                 if(!empty($videos))
  259.                 {
  260.                     foreach($videos as $v) //
  261.                     {
  262.                         $files_to_zip[] = sprintf("/website/var/assets%s", $v->getFullPath());
  263.                     }
  264.                 }
  265.                 */
  266.                 
  267.             }
  268.             for($i=0; $i<count($files_to_zip); $i++)
  269.             {
  270.                 {
  271.                     $asset = Asset::getByPath($files_to_zip[$i]);
  272.                     $tn = $asset->getThumbnail($thumbnail, false)->getLocalFile();
  273.                     $files_to_zip[$i] = $tn; // .form-group div -> clear: both; label for picks float: left
  274.                 }
  275.             }
  276.             
  277.             $files_to_zip[] = $excelfile;
  278.             //if true, good; if false, zip creation failed
  279.             if (count($files_to_zip) > 0) {
  280.                 $result = $this->create_zip($files_to_zip,$downloadpath,true);
  281.             }
  282.         }
  283.         
  284.         $params['downloadurl']  = $downloadfile;
  285.         $params['downloadfilename']  = $downloadfilename;
  287.         //Send the Email
  288.         //$params = array();
  289.         $params["order"] = $order;
  290.         $params["customer"] = $order->getCustomer();
  291.         $params["ordernumber"] = $order->getOrdernumber();
  292.         $size = "0. 0 KB";
  293.         if (file_exists($_SERVER['DOCUMENT_ROOT'] . $downloadfile)) {
  294.             $size = $this->filesize_formatted($_SERVER['DOCUMENT_ROOT'] . $downloadfile);
  295.         }
  296.         $params["filesize_formatted"] = $size;
  297.         
  299.         $mail = new Mail(array("document" => "/espirits/" . strtolower($this->locale) . "/emails/download-confirmation", "params" => $params));
  300.         
  301.         if($order->getCustomer()) {
  302.             $mail->setIgnoreDebugMode(true);
  303.             //$mail->setDefaultFrom("contact@beamsuntory.com","eSpirits Portal");
  304.             $mail->subject("Saudi Aramco Document Data Download | " . $order->getOrderDate()->format('YYYY-MM-dd') . " | " . $order->getId());
  305.             $mail->addTo($order->getCustomer()->getEmail());
  307.             //TODO
  309.             if ($authNamespace->get('otheremail')) {
  310.                 $toemails = explode(",", $authNamespace->get('otheremail'));
  311.                 foreach ($toemails as $toemail) {
  312.                     if (!empty( $toemail )) $mail->addTo( $toemail );
  313.                 }
  314.             }
  317.             #fix the email sending
  318.             //****$mail->send();
  319.         } else {
  320.             //TODO    We will be uncomment
  321.             //\Logger::err("No Customer found!");
  322.         }
  324.         // init
  325.         $params["order"] = \Pimcore\Model\DataObject\OnlineShopOrder::getById( $order->getId() );
  326.         //need to revisit
  327.         //**$itemKeyUniversal = \Pimcore\Bundle\EcommerceFrameworkBundle\CheckoutManager\CheckoutManager::TRACK_ECOMMERCE_UNIVERSAL . "_" . $order->getOrdernumber();
  328.         $itemKeyUniversal = 'checkout_trackecommerce_universal' . "_" . $order->getOrdernumber(); 
  329.         $environment = Factory::getInstance()->getEnvironment();
  330.         $codeUniversal = $environment->getCustomItem($itemKeyUniversal);
  332.         if(!empty($codeUniversal)) {
  333.             $params["gacodeUniversal"] = $codeUniversal;
  334.             $environment->removeCustomItem($itemKeyUniversal);
  335.             $environment->save();
  336.         }
  337.         return $this->render('Cart/download.html.twig', $params);
  338.     }
  340.     /**
  341.      * @Route("/list", name="shop-cart-detail", methods={"GET"})
  342.      *
  343.      * @param Request $request
  344.      * @param BreadcrumbHelperService $breadcrumbHelperService
  345.      * @param Factory $ecommerceFactory
  346.      *
  347.      */
  348.     public function listAction(Request $request,  Factory $ecommerceFactory): Response
  349.     {
  350.         // init view
  351.         //$this->layout()->setLayout('cart');
  352.         //$this->enableLayout();
  353.         $params = [];
  354.         $params['hideNav'] = true;
  355.         $params['locale'] = strtolower($request->getLocale());
  356.         $params['params'] = $request->request->all();
  357.         $params['preview'] = $request->get('pimcore_preview',null);
  358.         $defaultCountry = DataObject\AvailabilityCountry::getByPath('/availability-countries/us');
  359.         if(isset($this->country)){
  360.             $availableCountry = $this->country;
  361.         }else{
  362.             $availableCountry = $defaultCountry;
  363.             $params['country'] = $defaultCountry;
  364.         }
  365.         $cart = $this->getCart();
  367.         // sort by item count asc
  368.         //Todo item
  369.         // $cart->sortItems(function (\Pimcore\Bundle\EcommerceFrameworkBundle\CartManager\ICartItem $a, \Pimcore\Bundle\EcommerceFrameworkBundle\CartManager\ICartItem $b) {
  371.         //     return $a->getCount() > $b->getCount();
  373.         // });
  374.             
  375.         $cart = $this->getCart();
  377.         if ($request->getMethod() == Request::METHOD_POST) {
  378.             $items = $request->get('items');
  380.             foreach ($items as $itemKey => $quantity) {
  381.                 if ($cart->getItemCount() > 99) {
  382.                     break;
  383.                 }
  384.                 $product = BrandExtension::getById($itemKey);
  385.                 if ($product instanceof CheckoutableInterface) {
  386.                     $cart->updateItem($itemKey, $product, $quantity, true);
  387.                 }
  388.             }
  389.             $cart->save();
  391.             $trackingManager = $ecommerceFactory->getTrackingManager();
  392.             $trackingManager->trackCartUpdate($cart);
  393.         }
  394.         $params['cart'] = $cart;
  395.         //$breadcrumbHelperService->enrichCartPage();
  396.         //$params = array_merge($request->request->all(), $request->query->all());
  397.         if ($cart->isEmpty()) {
  398.             return $this->render('Cart/list.html.twig', $params);
  399.         } else {
  400.             return $this->render('Cart/list.html.twig', $params);
  401.         }
  403.     }
  405.     /**
  406.      * @Route("/add-to-cart", name="shop-add-to-cart")
  407.      *
  408.      * @param Request $request
  409.      * @param Factory $ecommerceFactory
  410.      *
  411.      * @throws \Exception
  412.      */
  413.     public function addAction(Request $request)
  414.     {
  415.         // add item to cart
  416.         if(($id = $request->get('item')))
  417.         {   
  418.             $product = DataObject\BrandExtension::getById( $id );
  419.             $prefix = $request->get('prefix');
  420.             /* @var \Website\DefaultProduct $product */
  421.             $qty = (int)$request->get('qty', 1);
  422.             if($product)
  423.             {
  424.                 $cart = $this->getCart();
  425.                 $cart->addItem( $product, $qty);
  426.                 $cart->save();
  427.             }
  429.             //$urlHelper = \Pimcore::getKernel()->getContainer()->get('pimcore.templating.view_helper.pimcore_url');
  430.             //$url = $urlHelper(array('action' => 'list'), 'cart');
  431.             //return $this->redirect( $url );
  433.             // $url = $this->generateUrl('shop-cart-detail');
  434.             
  437.             //return $this->redirectToRoute('shop-cart-detail');
  438.             $url = $this->generateUrl('shop-cart-detail');
  439.             
  440.             return $this->redirect($url);
  441.            
  442.         } else {
  443.             throw new \Exception("no item given to add to cart");
  444.         }
  446.     }
  449.     /**
  450.      * @Route("/remove-from-cart", name="shop-remove-from-cart")
  451.      */
  452.     public function removeAction(Request $request)
  453.     {
  454.         // remove item from cart
  455.         if(($id = $request->get('item')))
  456.         {
  457.             $cart = $this->getCart();
  458.             $cart->removeItem( $id );
  459.             $cart->save();
  461.             //$urlHelper = \Pimcore::getContainer()->get('pimcore.templating.view_helper.pimcore_url');  
  462.             //return $this->redirect( $urlHelper(array('action' => 'list'), 'cart') );
  463.             return $this->redirectToRoute('shop-cart-detail');
  464.         } else {
  465.             throw new \Exception("no item given to remove from cart");
  466.         }
  467.     }
  470.      /**
  471.      * @Route("/update", name="cart-update", methods={"GET"})
  472.      *
  473.      * @param Request $request
  474.      * @param Factory $ecommerceFactory
  475.      *
  476.      * @throws \Exception
  477.      */
  478.     public function updateAction(Request $request)
  479.     {
  480.         if($request->get("qty")) {
  481.             $cart = $this->getCart();
  482.             foreach($request->get("qty") as $key => $qty) {
  483.                 $product = Pimcore\Model\Object\Product::getById($key);
  484.                 if($product) {
  485.                     $cart->updateItem($key, $product, intval($qty), true);
  486.                     $cart->save();
  487.                 }
  488.             }
  489.         }
  491.         $url = $this->view->url(array('action' => 'list'), 'cart');
  492.         return $this->redirect( $url );
  493.     }
  496.     /**
  497.      * Adds a voucher token to cart, sets error messages and
  498.      * redirects to list action.
  499.      */
  500.     public function addVoucherAction(Request $request)
  501.     {
  502.         $cart = $this->getCart();
  503.         $voucherError = "";
  504.         if ($token = strip_tags($request->get('voucherToken'))) {
  505.             try {
  506.                 $success = $cart->addVoucherToken($token);
  507.                 if(!$success) {
  508.                     $voucherError = $this->view->t('cart.msg-error-token-couldnt-be-applied');
  509.                 }
  510.             } catch (\Pimcore\Bundle\EcommerceFrameworkBundle\Exception\VoucherServiceException $e) {
  511.                 $voucherError = $this->view->t('cart.msg-error.' . $e->getCode());
  512.             }
  513.         } else {
  514.             $voucherError = $this->view->t('cart.msg-error-token-missing');
  515.         }
  517.         $params = ["action" => "list", "prefix" => $this->locale];
  518.         if($voucherError) {
  519.             $params["voucherError"] = $voucherError;
  520.             $params["voucherToken"] = $token;
  521.         }
  524.         $url = $this->view->url($params, 'cart', true);
  525.         return $this->redirect($url);
  526.     }
  528.     /**
  529.      * Remove a voucher token from cart, sets error messages and
  530.      * redirects to list action.
  531.      */
  532.     public function releaseVoucherAction(Request $request)
  533.     {
  534.         $cart = $this->getCart();
  535.         $voucherError = "";
  536.         if ($code = $request->get('voucherToken')) {
  537.             try {
  538.                 $cart->removeVoucherToken($code);
  539.             } catch (\Pimcore\Bundle\EcommerceFrameworkBundle\Exception\VoucherServiceException $e){
  540.                 $voucherError = $this->view->t('cart.msg-error.' . $e->getCode());
  541.             }
  542.         } else {
  543.             $voucherError = $this->view->t('cart.msg-error-token-missing');
  544.         }
  546.         $url = $this->view->url(array('action' => 'list', 'voucherError' => $voucherError), 'cart');
  547.         return $this->redirect($url);
  548.     }
  550.     private function filesize_formatted($path)
  551.     {
  552.         $size = filesize($path);
  553.         $units = array( 'B', 'KB', 'MB', 'GB', 'TB', 'PB', 'EB', 'ZB', 'YB');
  554.         $power = $size > 0 ? floor(log($size, 1024)) : 0;
  555.         return number_format($size / pow(1024, $power), 2, '.', ',') . ' ' . $units[$power];
  556.     }
  558.     /* creates a compressed zip file */
  559.     function create_zip($files = array(),$destination = '',$overwrite = false) {
  560.         //if the zip file already exists and overwrite is false, return false
  561.         if(file_exists($destination)) { 
  562.             $overwrite = true; 
  563.         } else {
  564.             $overwrite = false; 
  565.         }
  566.         //vars
  567.         $valid_files = array();
  568.         //if files were passed in...
  569.         if(is_array($files)) {
  570.             //cycle through each file
  571.             foreach($files as $file) {
  572.                 //make sure the file exists
  573.                 if(file_exists($file)) {
  574.                     $valid_files[] = $file;
  575.                 }
  576.             }
  577.             
  578.         }
  579.         
  580.         //if we have good files...
  581.         if(count($valid_files)) {
  582.             //create the archive
  583.             $zip = new ZipArchive();
  584.             if($zip->open($destination,$overwrite ? ZIPARCHIVE::OVERWRITE : ZIPARCHIVE::CREATE) !== true) {
  585.                 return false;
  586.             }
  587.             //add the files
  588.             foreach($valid_files as $file) {
  589.                 $new_filename = substr($file,strrpos($file,'/') + 1);
  590.                 
  591.                 if (preg_match('#xlsx#', $file) === 0) {
  592.                     $new_filename = "assets/" . $new_filename;
  593.                     //$new_filename = "product-media/bottle-photos/" . $new_filename;
  594.                 }
  596.                 if(is_dir($file))
  597.                 {
  598.                     continue;
  599.                 }
  600.                 
  601.                 $zip->addFile($file, $new_filename);
  602.             }
  604.             //debug
  605.             //echo 'The zip archive contains ',$zip->numFiles,' files with a status of ',$zip->status;
  606.           
  607.             //close the zip -- done!
  608.             $zip->close();
  609.             
  610.             //check to make sure the file exists
  611.             return file_exists($destination);
  612.         }
  613.         else
  614.         {
  615.             return false;
  616.         }
  617.     }
  619.     function create_download_file($order) {
  620.         
  621.         //$objPHPExcel = new PHPExcel();
  622.         $objPHPExcel = new Spreadsheet();
  623.         
  624.         // Set properties
  625.         $pr = $objPHPExcel->getProperties();
  626.         $ttl = $this->trance->trans("espirits.export.title");
  627.         
  628.         //$pr->setCreator(self::COMPANY_NAME);
  629.         $pr->setLastModifiedBy(self::COMPANY_NAME);
  630.         $pr->setTitle($ttl);
  631.         $pr->setSubject($ttl);
  632.         $pr->setDescription($ttl);
  633.                 
  634.         // Write product info sheet.
  635.         $objPHPExcel->setActiveSheetIndex(0);
  636.         $sht = $objPHPExcel->getActiveSheet();
  637.         $sht->setTitle($this->trance->trans("espirits.export.Product Info"));
  638.         
  639.         $headers = array("ObjectType", "Brand", "BrandExtensionName", "BrandExtensionNameTrademark", "BottleSize", "BrandExtensionDiscontinued", "ABV", "ShortDescription", "FullDescription", "Aging", "BottlePhoto", "LifestylePhotoList", "OriginCountry", "OriginRegion", "AlcoholType", "FlavoringType", "PricingSegment", "WhyBuy1", "WhyBuy2", "WhyBuy3", "WhyBuy4", "WhyBuy5", "WhyBuy6", "WhyBuy7", "WhyBuy8", "Keywords1", "Keywords2", "Keywords3", "Keywords4", "Keywords5", "Keywords6", "Keywords7", "Keywords8", "Keywords9", "Keywords10", "Keywords11", "Keywords12", "Keywords13", "Keywords14", "Keywords15", "Keywords16", "Keywords17", "Keywords18", "Keywords19", "Keywords20", "Keywords21", "Keywords22", "Keywords23", "Keywords24", "Keywords25", "Keywords26", "Keywords27", "Keywords28", "Keywords29", "Keywords30", "GTIN", "Material", "Height", "Width", "Depth", "Weight", "BSIID", "modificationDate", "creationDate"); 
  640.         $this->country = DataObject\AvailabilityCountry::getByPath('/availability-countries/us');
  641.         //TODO Replace default country by lofined user by country
  642.         
  643.         if($this->country != "DE")
  644.         {
  645.             $headers = array_merge(array_slice($headers, 0, 7), array("Proof"), array_slice($headers, 7));
  646.         }
  647.         
  648.         $this->writeHeaders($sht, $headers);
  649.         
  650.         $counter = 1;
  651.         foreach ($order->getItems() as $item) {
  652.             $counter++;
  653.             $product = $item->getProduct();
  654.             
  655.             if ($this->locale == "de") 
  656.             {
  657.                 $this->create_excel_row_de($objPHPExcel, $product, "BrandExtension", $counter);
  658.             } else 
  659.             {
  660.                 $this->create_excel_row($objPHPExcel, $product, "BrandExtension", $counter);
  661.             }
  662.             
  663.             $sizeVariants = $product->getSizeVariants();
  664.             if ($sizeVariants) {
  665.                 foreach($sizeVariants as $variant) {
  666.                     $countries = $variant->getCountryAvailabilityList();
  667.                     $continue = 0;
  668.                     foreach ($countries as $country) {
  669.                             if ($country->getObjectId() == $this->country->getId() && $country->geteSpiritsEnable() == 1) {
  670.                                 $continue = 1;
  671.                                 break;
  672.                             }
  673.                     }
  674.                     if ($continue == 0) {
  675.                         continue;
  676.                     }
  677.                     $counter++;
  678.                     if ($this->country->getName() == "DE") {
  679.                         $this->create_excel_row_de($objPHPExcel, $variant, "BottleVariant", $counter);
  680.                     } else {
  681.                         $this->create_excel_row($objPHPExcel, $variant, "BottleVariant", $counter);
  682.                     }
  683.                 }
  684.             }
  685.         }
  686.         
  687.         $objPHPExcel->createSheet(1);
  688.         $objPHPExcel->setActiveSheetIndex(1);
  689.         $sht = $objPHPExcel->getActiveSheet();
  690.         $sht->setTitle($this->trance->trans("espirits.export.Recipes"));
  691.         
  692.         $this->writeHeaders($sht, array("Recipe Name", "Brand Extension Name", "Ingredients", "Preparation", "Recipe Image Path"));
  693.         
  694.         $ctr = 2;
  695.         
  696.         foreach($order->getItems() as $item)
  697.         {
  698.             $product = $item->getProduct();        
  699.                         
  700.         }
  701.         $objPHPExcel->setActiveSheetIndex(0);
  702.         
  703.         // Set properties
  704.         
  705.         
  706.         $objWriter = \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($objPHPExcel, 'Xlsx');
  707.         
  708.         $objWriter->save($_SERVER['DOCUMENT_ROOT'] . "/downloads/excel/Products_Download_" . $order->getId() . ".xlsx");
  709.         return $_SERVER['DOCUMENT_ROOT'] . "/downloads/excel/Products_Download_" . $order->getId() . ".xlsx";
  710.     }
  711.     
  712.     
  713.     public function writeHeaders($sht, $hdrs)
  714.     {
  715.         $kv = "A";
  716.         foreach($hdrs as $h)
  717.         {
  718.             $sht->SetCellValue(sprintf("%s1", $kv), $this->trance->trans(sprintf("espirits.export.%s", $h)));
  719.             $kv++;
  720.         }
  721.     }
  722.     
  723.     public function removeHTML($s)
  724.     {
  725.         $rt = str_replace(array("<p>", "</p>"), array("", "\r\n"), $s);
  726.         $rt = preg_replace("/<\/?.*?>/", "", $rt);
  727.         $rt = html_entity_decode($rt, ENT_COMPAT | ENT_HTML401, "UTF-8");
  728.         
  729.         return $rt;
  730.     }
  732.     function create_excel_row($objPHPExcel, $product, $producttype, $counter)
  733.     {
  734.         $brandname = "";
  735.         $brandextname = "";
  736.         $brandextensionnametrademark = "";
  737.         $bottlesize = "";
  738.         $BrandExtensionDiscontinued = "";
  739.         $proof = "";
  740.         $abv = "";
  741.         $shortdesc = "";
  742.         $fulldesc = "";
  743.         $region  = "";
  744.         $country = "";
  745.         $alcoholtype = "";
  746.         $aging = "";
  747.         $lifestylephotos = "";
  748.         $bottlephotos = "";
  749.         $bottleGTIN = "";
  750.         $bottleBottleMaterial = "";
  751.         $bottleBottleHeight = "";
  752.         $bottleBottleWidth = "";
  753.         $bottleBottleDepth = "";
  754.         $bottleBottleWeight = "";
  755.     $flv = "";
  756.     $seg = "";
  757.         if ($producttype == "BrandExtension") {
  758.             $brandextname = $product->getName();
  759.             $brandextensionnametrademark = $product->getName();
  760.             $brand = $product->getBrand();
  761.             if ($brand) $brandname = $brand[0]->getObject()->getBrandName();
  763.                        
  764.             
  765.             $fulldesc = $product->getContent();
  767.             //Country Origin
  768.             
  769.             
  770.             $categories = $product->getCategories();
  771.             if ($categories) foreach ($categories as $category) {
  772.                 break;
  773.             }
  774.             if ($category) $alcoholtype = $category->getAlcoholType();
  775.             
  776.         } 
  778.         $objPHPExcel->getActiveSheet()->SetCellValue('A' . $counter, $this->trance->trans("espirits.export." . $producttype));
  779.         $objPHPExcel->getActiveSheet()->SetCellValue('B' . $counter, iconv("UTF-8", "ISO-8859-1//IGNORE", $brandname));
  780.         $objPHPExcel->getActiveSheet()->SetCellValue('C' . $counter, iconv("UTF-8", "ISO-8859-1//IGNORE", $brandextname));
  781.         $objPHPExcel->getActiveSheet()->SetCellValue('D' . $counter, iconv("UTF-8", "ISO-8859-1//IGNORE", $brandextensionnametrademark));      
  784.         // Existing code for keywords 1 and 2
  786.         
  788.         $objPHPExcel->getActiveSheet()->SetCellValue('E' . $counter, $product->getId());
  789.         //$create_date = new Zend_Date($product->getcreationDate());
  790.         $create_date = Carbon::createFromTimestamp($product->getcreationDate());
  791.         $create_date = $create_date->format("YYYY/MM/dd");
  792.         //$modify_date = new Zend_Date($product->getmodificationDate());
  793.         $modify_date = Carbon::createFromTimestamp($product->getmodificationDate());
  794.         $modify_date = $modify_date->format("YYYY/MM/dd");
  796.         $objPHPExcel->getActiveSheet()->SetCellValue('F' . $counter, $modify_date);
  797.         $objPHPExcel->getActiveSheet()->SetCellValue('G' . $counter, $create_date);
  798.     }
  800.     function create_excel_row_de($objPHPExcel, $product, $producttype, $counter)
  801.     {
  802.         $brandname = "";
  803.         $brandextname = "";
  804.         $brandextensionnametrademark = "";
  805.         $bottlesize = "";
  806.         $BrandExtensionDiscontinued = "";
  807.         $proof = "";
  808.         $abv = "";
  809.         $shortdesc = "";
  810.         $fulldesc = "";
  811.         $region  = "";
  812.         $country = "";
  813.         $alcoholtype = "";
  814.         $aging = "";
  815.         $lifestylephotos = "";
  816.         $bottlephotos = "";
  817.         $bottleGTIN = "";
  818.         $bottleBottleMaterial = "";
  819.         $bottleBottleHeight = "";
  820.         $bottleBottleWidth = "";
  821.         $bottleBottleDepth = "";
  822.         $bottleBottleWeight = "";
  824.         if ($producttype == "BrandExtension") {
  825.             $brandextname = $product->getBrandExtensionName();
  826.             $brandextensionnametrademark = $product->getBrandExtensionNameTrademark();
  827.             $brand = $product->getBrand();
  828.             if ($brand) $brandname = $brand[0]->getObject()->getBrandName();
  830.             if ($product->getBrandExtensionDiscontinued()) $BrandExtensionDiscontinued = "1";
  831.             $proof = $product->getProof();
  832.             $abv = $product->getABV();
  833.             $shortdesc = $product->getShortDescription();
  834.             $fulldesc = $product->getFullDescription();
  836.             //Country Origin
  837.             $region = $product->getOriginRegion();
  838.             $country = $product->getOriginCountry();
  839.             $countrydic = $product->getClass()->getFieldDefinition("OriginCountry")->getOptions();
  840.             foreach ($countrydic as $countrydicitem) {
  841.                 if ($countrydicitem['value'] == $country) {
  842.                     $country = $countrydicitem['key'];
  843.                     break;
  844.                 }
  845.             }
  846.             //Aging
  847.             $aging = $product->getAging();
  848.             //Pricing Segment
  849.             $segs = $product->PricingSegment;
  850.             if ($segs) foreach ($segs as $seg) {
  851.                 break;
  852.             }
  853.             if ($seg) $seg = $seg->getObject();
  854.             if ($seg) $seg = $seg->getPricingSegment();
  855.             //Flavoring Type
  856.             $flvs = $product->FlavoringType;
  857.             if ($flvs) foreach ($flvs as $flv) {
  858.                 break;
  859.             }
  860.             if ($flv) $flv = $flv->getObject();
  861.             if ($flv) $flv = $flv->getFlavoringType();
  862.             $categories = $product->getCategories();
  863.             if ($categories) foreach ($categories as $category) {
  864.                 break;
  865.             }
  866.             if ($category) $alcoholtype = $category->getAlcoholType();
  868.             //Get all the lifesize
  869.             if ($product->getLifestylePhotoList()) {
  870.                 foreach ($product->getLifestylePhotoList()->getItems() as $item) {
  871.                     if ($item && $item->getPhotoLifestyle() && $item->getPhotoLifestyle()->getFullPath()) {
  872.                         if (!empty($lifestylephotos)) $lifestylephotos .= ",";
  873.                         $lifestylephotos .= $item->getPhotoLifestyle()->getFullPath();
  874.                     }
  875.                 }
  876.             }
  877.         } else {
  878.             $bottlesize = $product->getBottleSize();
  879.             //Get all the bottle-size photos
  880.             $bottlephoto = $product->getBottlePhoto();
  881.             $bottlephotos = "";
  882.             if ($bottlephoto) $bottlephotos = $bottlephoto->getFilename();
  884.             $additionalPhotos = $product->getAdditionalPhotos();
  886.             if (!empty($additionalPhotos)) {
  887.                 foreach ($additionalPhotos as $a) {
  888.                     $bottlephotos .= "," . $a['AdditionalPhoto']->getData()->getFilename();
  889.                 }
  890.             }
  892.             $bottleGTIN = $product->getGTIN();
  893.             $bottleBottleMaterial = $product->getBottleMaterial();
  894.             $bottleBottleHeight = $product->getBottleHeight();
  895.             $bottleBottleWidth = $product->getBottleWidth();
  896.             $bottleBottleDepth = $product->getBottleDepth();
  897.             $bottleBottleWeight = $product->getBottleWeight();
  898.         }
  900.         $objPHPExcel->getActiveSheet()->SetCellValue('A' . $counter, $this->get('translator')->trans("espirits.export." . $producttype));
  901.         $objPHPExcel->getActiveSheet()->SetCellValue('B' . $counter, $brandname);
  902.         $objPHPExcel->getActiveSheet()->SetCellValue('C' . $counter, $brandextname);
  903.         $objPHPExcel->getActiveSheet()->SetCellValue('D' . $counter, $brandextensionnametrademark);
  904.         $objPHPExcel->getActiveSheet()->SetCellValue('E' . $counter, $bottlesize);
  905.         $objPHPExcel->getActiveSheet()->SetCellValue('F' . $counter, $BrandExtensionDiscontinued);
  906.         $objPHPExcel->getActiveSheet()->SetCellValue('G' . $counter, $abv);
  907.         $objPHPExcel->getActiveSheet()->SetCellValue('H' . $counter, $shortdesc);
  908.         $objPHPExcel->getActiveSheet()->SetCellValue('I' . $counter, $fulldesc);
  909.         $objPHPExcel->getActiveSheet()->SetCellValue('J' . $counter, $aging);
  910.         $objPHPExcel->getActiveSheet()->SetCellValue('K' . $counter, $bottlephotos);
  911.         $objPHPExcel->getActiveSheet()->SetCellValue('L' . $counter, $lifestylephotos);
  912.         $objPHPExcel->getActiveSheet()->SetCellValue('M' . $counter, $country);
  913.         $objPHPExcel->getActiveSheet()->SetCellValue('N' . $counter, $region);
  914.         $objPHPExcel->getActiveSheet()->SetCellValue('O' . $counter, $alcoholtype);
  915.         $objPHPExcel->getActiveSheet()->SetCellValue('P' . $counter, $flv);
  916.         $objPHPExcel->getActiveSheet()->SetCellValue('Q' . $counter, $seg);
  918.         $buyAlpha = array("R", "S", "T", "U", "V", "W", "X", "Y");
  919.         for ($i = 1; $i <= 8; $i++) {
  920.             if ($producttype == "BrandExtension") {
  921.                 $whybuy = "getWhyBuy" . $i;
  922.                 $whybuys = $product->$whybuy();
  923.                 if (is_null($whybuys)) {
  924.                     $whybuys = "";
  925.                 }
  926.                 $objPHPExcel->getActiveSheet()->SetCellValue($buyAlpha[$i - 1] . $counter, $whybuys);
  927.             } else {
  928.                 $objPHPExcel->getActiveSheet()->SetCellValue($buyAlpha[$i - 1] . $counter, "");
  929.             }
  930.         }
  932.         $keyAlpha = array("Z", "AA", "AB", "AC", "AD", "AE", "AF", "AG", "AH", "AI");
  933.         for ($i = 1; $i <= 10; $i++) {
  934.             if ($producttype == "BrandExtension") {
  935.                 $keyword = "Keywords" . $i;
  936.                 $kwords = $product->localizedfields->items[$this->locale->toString()][$keyword];
  937.                 if (is_null($kwords)) {
  938.                     $keywords = "";
  939.                 }
  940.                 $objPHPExcel->getActiveSheet()->SetCellValue($keyAlpha[$i - 1] . $counter, $kwords);
  941.             } else {
  942.                 $objPHPExcel->getActiveSheet()->SetCellValue($keyAlpha[$i - 1] . $counter, "");
  943.             }
  944.         }
  946.         $objPHPExcel->getActiveSheet()->SetCellValue('AJ' . $counter, $bottleGTIN);
  947.         $objPHPExcel->getActiveSheet()->SetCellValue('AK' . $counter, $bottleBottleMaterial);
  948.         $objPHPExcel->getActiveSheet()->SetCellValue('AL' . $counter, $bottleBottleHeight);
  949.         $objPHPExcel->getActiveSheet()->SetCellValue('AM' . $counter, $bottleBottleWidth);
  950.         $objPHPExcel->getActiveSheet()->SetCellValue('AN' . $counter, $bottleBottleDepth);
  951.         $objPHPExcel->getActiveSheet()->SetCellValue('AO' . $counter, $bottleBottleWeight);
  953.         $objPHPExcel->getActiveSheet()->SetCellValue('AP' . $counter, $product->getId());
  955.         //$create_date = new Zend_Date($product->getcreationDate());
  956.         $create_date = Carbon::createFromTimestamp($product->getcreationDate());
  957.         $create_date = $create_date->format("YYYY/MM/dd");
  958.         //$modify_date = new Zend_Date($product->getmodificationDate());
  959.         $modify_date = Carbon::createFromTimestamp($product->getmodificationDate());
  960.         $modify_date = $modify_date->format("YYYY/MM/dd");
  962.         $objPHPExcel->getActiveSheet()->SetCellValue('AQ' . $counter, $modify_date);
  963.         $objPHPExcel->getActiveSheet()->SetCellValue('AR' . $counter, $create_date);
  964.     }
  966. }