src/AppBundle/Model/CustomObject.php line 449

Open in your IDE?
  1. <?php 
  3. namespace AppBundle\Model;
  4. use Pimcore\Model\DataObject;
  5. use Pimcore\Model\Asset;
  6. use AppBundle\Model\Restful;
  9. class CustomObject
  10. {
  11.     private $dataObject;
  13.     private $objectList = array();
  14.     private $resfulModel;
  16.     public function __construct($object_name)
  17.     {
  18.         $this->resfulModel = new Restful();
  19.         switch ($object_name) 
  20.         {
  21.             case 'privilege':
  22.                 $this->dataObject = new DataObject\Privilege\Listing();
  23.                 break;
  24.             case 'KiosPromotion':
  25.                 $this->dataObject = new DataObject\KiosPromotion\Listing();
  26.                 break;
  27.             case 'KiosCMS':
  28.                 $this->dataObject = new DataObject\KiosCMS\Listing();
  29.                 break;
  30.             case 'KiosCatePromotion':
  31.                 $this->dataObject = new DataObject\KiosPromoCatalogImage\Listing();
  32.                 break;
  33.             case 'MediaByLocation':
  34.                 $this->dataObject = new DataObject\MediaLocation\Listing();
  35.                 break;
  36.             case 'KiosPromoCoupon':
  37.                 $this->dataObject = new DataObject\KiosPromoCoupon\Listing();
  38.             break;
  39.         }
  41.         //$this->dataObject = $object;
  43.     }
  45.     public function getObjects($lang = 'en', $catName = '')
  46.     {
  47.         
  48.         if( $catName != '' )
  49.         {
  50.             $this->dataObject->setCondition("category LIKE ?", "%". $catName ."%");
  51.         }
  52.         
  53.         $data = $this->dataObject->load();
  55.         $localData = array();
  56.         foreach ($data as $item) 
  57.         {
  58.             $email_template = $item->email_template;
  59.             if( isset($item->localizedfields->items[$lang]) )
  60.             {
  61.                 $localData[] = $this->reformatOutputArray($item->localizedfields->items[$lang],$email_template,$lang);
  62.             }
  63.         }
  65.         return $localData;
  66.     }
  68.     /*
  69.         @param: container, lang, objectName
  70.     */
  71.     public function getObjectKiosCMS( $param = array() )
  72.     {
  73.         $lang = $param['lang'];
  75.         $containers = explode(',', $param['container']);
  77.         // Prepare string to query IN condition
  78.         $containersListString = "('" . implode ( "', '", $containers ) . "')";
  80.         $this->dataObject->setCondition("container IN $containersListString AND o_className = ? ", array($param['objectName']) );
  82.         $data = $this->dataObject->load();
  84.         $localData = array();
  85.         foreach ($data as $item) 
  86.         {
  87.             $container = $item->container;
  89.             if( isset($item->localizedfields->items[$lang]) )
  90.             {
  91.                 $tmp[$container][] = $this->reformatOutputArray($item->localizedfields->items[$lang]);
  92.             }
  93.         }
  95.         // reformat add index key 0, 1, ...
  96.         foreach($tmp as $key => $item)
  97.         {
  98.             $localData[] = array(
  99.                 'container' => $key,
  100.                 'listID' => $item,
  101.                 'totalCount' => count($item)  
  102.             );
  103.         }
  105.         return $localData;        
  106.     }
  108.     private function reformatOutputArray( $dataArray = array(),$email_template="",$lang="" )
  109.     {
  110.         $res = array();
  112.         foreach($dataArray as $key => $item)
  113.         {
  114.             // stripe _ for reserve key id, value
  115.             //echo $item;
  116.             if( $key == 'id_' || $key == 'value_' )
  117.             {
  118.                 $key = str_replace("_", "", $key);
  119.             }
  121.             $res[$key] = $item;
  123.             if ( strstr($key, 'image') )
  124.             {
  125.                 $res['cover_image'] = array(
  126.                     'id' => $item->id,
  127.                     'filename' => $item->filename
  128.                 );
  129.                 
  130.             }
  131.             if($key == 'email_subject' || $key == 'email_body'){
  132.                 if($item == "") {
  133.                     list($subject,$body) = $this->getEmailTemplate($email_template,$lang);
  134.                    $res['email_subject'] = $subject;
  135.                    $res['email_body'] = $body;
  136.                 }
  137.             }
  138.         }
  140.         return $res;
  141.     }
  143.     private function getEmailTemplate($template,$lang){
  144.         $data = new DataObject\EmailTemplate\Listing();
  145.         $data->setCondition("o_className =? and o_key =?" ,array("EmailTemplate",$template));
  146.         $obj = $data->load();
  147.         $localData = array();
  148.         foreach ($obj as $item) {
  149.             $localData = $item->localizedfields;
  150.         }
  152.         if( !$localData->items )
  153.         {
  154.             return array();
  155.         }
  157.          $subject    = $localData->items[$lang]['email_subject'];
  158.          $body       =$localData->items[$lang]['email_body'];
  160.         return array($subject,$body);
  162.     }
  164.     public function getObject($param = array())
  165.     {
  166.         $key = $param['key'];
  167.         $path = $param['path']; 
  168.         $externalKey = $param['external_key'];
  169.         $lang = $param['lang'];
  171.         $pathToQuery = '';
  172.         if( $path )
  173.         {
  174.             $tmpPath = explode('_', strtolower($path));
  175.             $pathToQuery = $tmpPath[0] .'/'. $tmpPath[1];
  176.         }
  178.         $key = strtolower($key);
  180.         if( $externalKey != '' )
  181.         {
  182.             $this->dataObject->setCondition("o_key LIKE ?", "%". $externalKey ."%");
  183.         }
  184.         
  185.         if( $pathToQuery != '' )
  186.         {
  187.             $this->dataObject->setCondition("o_path LIKE ?", "%". $pathToQuery ."%");
  188.         }
  190.         $data = $this->dataObject->load();
  192.         $localData = array();
  193.         foreach ($data as $item) {
  194.             $localData = $item->localizedfields;
  195.             $email_template = $item->email_template;
  196.         }
  198.         if( !$localData->items )
  199.         {
  200.             return array();
  201.         }
  202.         return $this->reformatOutputArray($localData->items[$lang],$email_template,$lang);
  203.     }
  205.     public function getPromoKios($key,$lang = 'en')
  206.     {
  208.         if(is_array($key)){
  209.             $txt_search = "('" . implode ( "', '", $key ) . "')";
  210.             $this->dataObject->setCondition("o_className =? and o_key in $txt_search" ,"KiosPromotion");
  211.             //$this->dataObject->setCondition("o_key in ($txt_search)");
  212.         }
  214.         $data = $this->dataObject->load();
  216.         $localData = array();
  217.         foreach ($data as $item)
  218.         {
  219.             if( isset($item->localizedfields->items[$lang]) )
  220.             {
  221.                 $localData[] = $this->reformatOutputArray($item->localizedfields->items[$lang]);
  222.             }
  223.         }
  225.         return $localData;
  226.     }
  229.     public function getPromoKiosLocation($lang = 'en',$branch)
  230.     {
  231.         $this->dataObject->setCondition("o_className =? and branch=?" ,array('KiosPromotion',$branch));
  232.         $data = $this->dataObject->load();
  233.         $localData = array();
  234.         $arr = array();
  235.         foreach ($data as $item){
  237.             //$localData['branch'] = $item->branch;
  238.             if( isset($item->localizedfields->items[$lang]) )
  239.             {
  240.                 $tmp_data = $item->localizedfields->items[$lang];
  241.                 $branch = $item->branch;
  242.                 //$localData[] = $this->reformatOutputArray($item->localizedfields->items[$lang]);
  243.                 $localData['branch'] = $branch;
  244.                 $localData['promotion_code'] = $tmp_data['promotion_code'];
  245.                 $localData['promotion_name'] = $tmp_data['promotion_name'];
  246.                 $localData['promotion_value'] = $tmp_data['promotion_value'];
  247.                 $localData['short_description'] = $tmp_data['short_description'];
  248.                 $localData['condition'] = $tmp_data['condition'];
  249.                 foreach($tmp_data as $key => $item) {
  250.                     if (strstr($key, 'image')) {
  251.                         $localData['cover_image'] = array(
  252.                             'id' => $item->id,
  253.                             'filename' => $item->filename
  254.                         );
  256.                     }
  257.                 }
  258.                 $localData['print'] = $tmp_data['print'];
  260.                 $arr[] = $localData;
  261.             }
  262.         }
  264.         return $arr;
  265.     }
  267.     public function getPromoKiosByCate($cate,$lang = 'en')
  268.     {
  269.         $localData = array();
  270.         $cate_list = array();
  271.         if( $cate != '' )
  272.         {
  273.             $this->dataObject->setCondition("o_className =? and category LIKE ?" ,array("KiosPromotion","%". $cate ."%"));
  274.             //$this->dataObject->setCondition("category LIKE ?", "%". $cate ."%");
  276.         }
  278.         $data = $this->dataObject->load();
  279.         
  280.         if(count($data) > 0) {
  281.             $localData['category_image'] = $this->getImageCate($cate,$lang);
  282.             $idx = 0;
  283.             foreach ($data as $item) {
  284.                 //category
  285.                 //brand
  286.                 if (isset($item->localizedfields->items[$lang])) {
  287.                     $cate_list[$idx]['category'] = $cate;
  288.                     $cate_list[$idx]['brand'] = $item->brand;
  289.                     $tmp = $this->reformatOutputArray($item->localizedfields->items[$lang]);
  290.                     
  291.                     foreach($tmp as $key => $value)
  292.                     {
  293.                         $cate_list[$idx][$key] = $value;
  294.                     }
  296.                     $idx++;
  298.                 }
  300.             }
  301.             $localData['categories'] = $cate_list;
  302.             return $localData;
  303.         }else{
  304.             return null;
  305.         }
  307.     }
  309.     private function getImageCate($cate,$lang){
  310.         $objectCateImage = new DataObject\KiosPromoCatalogImage\Listing();
  311.         if( $cate != '' )
  312.         {
  313.             $objectCateImage->setCondition("catalog LIKE ?", "%". $cate ."%");
  314.         }
  316.         $data = $objectCateImage->load();
  317.         $localData = array();
  318.         foreach ($data as $item) {
  319.             $localData = $item->localizedfields;
  320.         }
  322.         if( !$localData->items )
  323.         {
  324.             return array();
  325.         }
  327.         return $this->reformatOutputImage($localData->items[$lang]);
  328.     }
  330.     private function reformatOutputImage( $dataArray = array() )
  331.     {
  332.         $res = array();
  334.         foreach($dataArray as $key => $item)
  335.         {
  336.             if ( strstr($key, 'image') )
  337.             {
  338.                 $res = array(
  339.                     'type'=>$item->type,
  340.                     'mimetype'=>$item->mimetype,
  341.                     'id' => $item->id,
  342.                     'filename' => $item->filename
  343.                 );
  345.             }
  346.         }
  348.         return $res;
  349.     }
  351.     public function getCatePromoKios($lang){
  352.         $localData = array();
  353.         $this->dataObject->setCondition("o_className =? and o_path=?" ,array("KiosPromoCatalogImage","/Kios/CategoryImage/"));
  354.         $data = $this->dataObject->load();
  355.         foreach ($data as $item)
  356.         {
  357.             if( isset($item->localizedfields->items[$lang]) )
  358.             {
  359.                 $cate_code = $item->catalog;
  360.                 foreach($item->localizedfields->items[$lang] as $key => $item)
  361.                 {
  362.                     if($key == "category_name") {
  363.                         $cate_name = $item;
  364.                     }
  365.                     if ( strstr($key, 'image') )
  366.                     {
  367.                         $res = array(
  368.                             'category_code' => $cate_code,
  369.                             'category_name' => $cate_name,
  370.                             'type'=>$item->type,
  371.                             'mimetype'=>$item->mimetype,
  372.                             'id' => $item->id,
  373.                             'filename' => $item->filename
  374.                         );
  376.                     }
  377.                 }
  378.                 $localData[] = $res;
  379.             }
  381.         }
  382.         return $localData;
  383.     }
  385.     public function getAllBrandPromoKios($lang){
  386.         $localData = array();
  387.         $this->dataObject->setCondition("o_className =? and o_path=?" ,array("KiosPromoCatalogImage","/Kios/BrandImage/"));
  388.         $data = $this->dataObject->load();
  389.         foreach ($data as $item)
  390.         {
  391.             if( isset($item->localizedfields->items[$lang]) )
  392.             {
  393.                 $cate_code = $item->catalog;
  394.                 foreach($item->localizedfields->items[$lang] as $key => $item)
  395.                 {
  396.                     if($key == "category_name") {
  397.                         $cate_name = $item;
  398.                     }
  400.                     if ( strstr($key, 'image') )
  401.                     {
  402.                         $res = array(
  403.                             'category_code' => $cate_code,
  404.                             'category_name' => $cate_name,
  405.                             'type'=>$item->type,
  406.                             'mimetype'=>$item->mimetype,
  407.                             'id' => $item->id,
  408.                             'filename' => $item->filename
  409.                         );
  411.                     }
  412.                 }
  413.                 $localData[] = $res;
  414.             }
  416.         }
  417.         return $localData;
  418.     }
  420.     public function getMediaLocation($location,$lang,$app=""){
  421.         $localData = array();
  422.         $this->dataObject->setCondition("o_className =? and location=? and o_path like ?" ,array("MediaLocation",$location,"%". $app."%"));
  423.         $data = $this->dataObject->load();
  424.         $tmp = array();
  425.         foreach ($data as $item)
  426.         {
  427.             $link = $item->link;
  428.             if( isset($item->localizedfields->items[$lang]) )
  429.             {
  430.                 $location = $item->location;
  431.                 foreach($item->localizedfields->items[$lang] as $key => $value)
  432.                 {                  
  433.                     if ( strstr($key, 'title')) { 
  434.                         $title = $value; 
  435.                     }
  436.                     if ( strstr($key, 'image')) {
  437.                         if (!$value->type == null) {
  438.                             $tmp[] = array(
  439.                                 'title'  => $title,
  440.                                 'type' => $value->type,
  441.                                 'id' => $value->id,
  442.                                 'filename' => $value->filename,
  443.                                 'link'  => $link,
  444.                             );
  445.                         }
  446.                     }
  448.                     if ( strstr($key, 'vdo')){
  449.                         if($value->data != "") {
  450.                             $asset = Asset::getById($value->data->id);
  451.                             $tmp[] = array(
  452.                                 'title'  => $title,
  453.                                 'type' => $value->data->type,
  454.                                 'id' => $value->id,
  455.                                 'url' => $this->resfulModel->getSiteUrlProtocal().$_SERVER['HTTP_HOST'].'/var/assets'.$asset->path.$value->data->filename);
  456.                        }
  457.                     }
  458.                 }
  460.             }
  461.             $localData['location'] = $location;
  462.             $localData['listMedia'] = $tmp;
  463.         }
  464.         //$arr = array('location'=>$location,'listMedia'=>$localData);
  465.         return $localData;
  466.     }
  468.     public function getVersion($id,$force = false)
  469.     {
  471.         $db = \Pimcore\Db::getConnection();
  472.         $versionData = $db->fetchRow("SELECT id,date FROM versions WHERE id='120' and cid = '$id' AND ctype='object' ORDER BY `id` DESC LIMIT 1"); //Returns null, because no version exists in db
  473.         $version = \Pimcore\Model\Version::getById($versionData["id"]);
  474.         $version->getData();
  476.         print_r($version); exit();
  477.     }
  479.     public function getKiosPromoCoupon($location,$lang,$campaign,$shop_name,$promotion_code,$branch,$highlight){
  480.         $localData = array();
  481.         $condition = "";
  483.         if($location != ""){
  484.             $condition .= " and location='".$location."'";
  485.         }
  486.         if($shop_name != ''){
  487.             $condition .= " and shop_name='".$shop_name."'";
  488.         }
  489.         if($campaign != ""){
  490.             $condition .= " and campaign='".$campaign."'";
  491.         }
  492.         if($promotion_code != ""){
  493.             $condition .= " and promotion_code='".$promotion_code."'";
  494.         }
  495.         if($branch != ""){
  496.             $condition .= " and branch='".$branch."'";
  497.         }
  498.         if($highlight != ""){
  499.             $condition .= " and highlight='".$highlight."'";
  500.         }
  502.         $this->dataObject->setCondition("o_className ='KiosPromoCoupon' $condition");
  503.         $data = $this->dataObject->load();  
  504.         foreach ($data as $item)
  505.         {
  506.             if( isset($item->localizedfields->items[$lang]) )
  507.             {               
  508.                 $res['campaign'] = $item->campaign;
  509.                 $res['branch'] = $item->branch;
  510.                 $res['location'] = $item->location;
  511.                 $res['shop_name'] = trim($item->shop_name);
  512.                 $res['promotion_code'] = $item->promotion_code;
  513.                 $res['start_date'] = $item->start_date;
  514.                 $res['end_date'] = $item->end_date;
  515.                 foreach($item->logo as $key => $value){
  516.                         if ( strstr($key, 'id') )
  517.                                 $id = $value;
  518.                         if ( strstr($key, 'filename') )
  519.                                 $filename = $value;
  520.                         $res['image_logo'] = array(
  521.                             "id"=>$id,
  522.                             "filename"=>$filename,
  523.                         );
  524.                 }
  526.                 foreach($item->localizedfields->items[$lang] as $key => $item)
  527.                 {
  528.                     $res[$key] = $item;
  529.                     if ( strstr($key, 'image_thumbnails') )
  530.                     {
  531.                         $res['image_thumbnails'] = array(
  532.                             'id' => $item->id,
  533.                             'filename' => $item->filename
  534.                         );
  535.                     }
  536.                     if ( strstr($key, 'image_description') )
  537.                     {
  538.                         $res['image_description'] = array(
  539.                             'id' => $item->id,
  540.                             'filename' => $item->filename
  541.                         );
  542.                     }
  543.                     
  544.                 }
  545.                 $localData[] = $res;
  546.             }
  548.         }
  549.         return $localData;
  550.     }
  552.     public function getPromoShop($branch,$lang){
  553.         $localData = array();
  554.         $condition = "";
  555.         $shop = array();
  556.        
  557.         if($branch != ""){
  558.             $condition .= " and branch='".$branch."'";
  559.         }
  561.         $this->dataObject->setCondition("o_className ='KiosPromoCoupon' $condition");
  562.         $data = $this->dataObject->load(); 
  563.         foreach ($data as $item)
  564.         {
  565.             if( isset($item->localizedfields->items[$lang]) )
  566.             {
  567.                 if(!in_array(trim($item->shop_name), $shop)){
  568.                     array_push($shop,$item->shop_name);
  569.                     $res['branch'] = $item->branch;
  570.                     $res['location'] = $item->location;
  571.                     $res['shop_name'] = trim($item->shop_name);
  572.                     $res['promotion_code'] = $item->promotion_code;
  573.                     foreach($item->logo as $key => $value){
  574.                             if ( strstr($key, 'id') )
  575.                                     $id = $value;
  576.                             if ( strstr($key, 'filename') )
  577.                                     $filename = $value;
  578.                             $res['image_logo'] = array(
  579.                                 "id"=>$id,
  580.                                 "filename"=>$filename,
  581.                             );
  582.                     }
  584.                     
  585.                     $localData[] = $res;
  586.                 }
  587.             }
  589.         }
  590.         return $localData;
  591.     }
  592. }