app/Customize/Service/DynamicConverterService.php line 13

Open in your IDE?
  1. <?php
  3. namespace Customize\Service;
  5. use Customize\Entity\CacheTrait;
  6. use Lm\Service\Db\SqlService;
  8. class DynamicConverterService
  9. {
  11.     use CacheTrait;
  13.     public function getFbnrs($params, $siteType, $webName)
  14.     {
  15.         //
  16.         $cacheKey = md5(serialize(compact('params', 'siteType', 'webName')));
  17.         //
  18.         return $this->getCacheByKey($cacheKey, function () use ($params, $siteType, $webName){
  19.             //
  20.             log_info("[HOGE] (*'o')");
  21.             //
  22.             $result = [];
  23.             //
  24.             switch ($params['type']) {
  25.                 case 'item':
  26.                     $goodsId = $params['value'];
  27.                     $itemMcWebNames = (array)(new SqlService())
  28.                         ->Table('goods_category_table')
  29.                         ->Select('T2.main_category_webname')
  30.                         ->Join('category_table', 'T1.category_id = T.gc_category', 'INNER')
  31.                         ->Join('main_category_table', 'T2.main_category_id = T1.category_main_category', 'INNER')
  32.                         ->Set('gc_goods', $goodsId)
  33.                         ->Set('T2.main_category_has_main_categories', 1)
  34.                         ->Set('T2.main_category_status', 1)
  35.                         ->OrderBy('char_length(T2.main_category_webname) DESC')
  36.                         ->FindAll();
  37.                     foreach ($itemMcWebNames as $itemMcWebName) {
  38.                         $itemFbnr = $this->getFbnrByCategoryWebName($siteType, $itemMcWebName['main_category_webname']);
  39.                         $result[] = $itemFbnr;
  40.                     }
  42.                     break;
  43.                 case 'main-category':
  44.                 case 'category':
  45.                     $itemFbnr = $this->getFbnrByCategoryWebName($siteType, $webName);
  46.                     $result[] = $itemFbnr;
  48.                     $main_category_webname = addslashes(stripslashes($webName));
  49.                     $mcHasMainCategoryData = (new SqlService())
  50.                         ->Table("main_category_table")
  51.                         ->Select('*')
  52.                         ->Set('main_category_webname', $main_category_webname)
  53.                         ->Set('main_category_status', 1)
  54.                         ->Set('main_category_main_category', 'NOT NULL')
  55.                         ->Find();
  56.                     $itemFbnr = $this->getFbnrByCategoryWebName($siteType, $mcHasMainCategoryData['main_category_main_category_webname'] ?? null);
  57.                     $result[] = $itemFbnr;
  58.                     break;
  59.                 default:
  60.                     break;
  61.             }
  63.             //
  64.             $sql = (new SqlService())
  65.                 ->Table('floating_banner_table')
  66.                 ->Select('fbnr_content, fbnr_content2')
  67.                 ->Set('fbnr_site_type', $siteType);
  68.             $result[] = $sql->Find();
  69.             //
  70.             return $result;
  71.         });
  72.     }
  74.     public function getFbnrByCategoryWebName($siteType, $webName) {
  75.         $itemFbnr = null;
  76.         if ($webName) {
  77.             $itemFbnr = (new SqlService())
  78.                 ->Select('fbnr_content, fbnr_content2, T1.main_category_main_category, T1.main_category_main_category_webname')
  79.                 ->Table('floating_banner_table')
  80.                 ->Join('main_category_table', 'T1.main_category_id = T.target_category', 'INNER')
  81.                 ->Set('fbnr_site_type', $siteType)
  82.                 ->Set('T1.main_category_has_main_categories', 1)
  83.                 ->Set('T1.main_category_webname', $webName)
  84.                 ->Find();
  85.         } else {
  86.             $itemFbnr = (new SqlService())
  87.                 ->Select('fbnr_content, fbnr_content2, T1.main_category_main_category, T1.main_category_main_category_webname')
  88.                 ->Table('floating_banner_table')
  89.                 ->Join('main_category_table', 'T1.main_category_id = T.target_category', 'INNER')
  90.                 ->Set('fbnr_site_type', $siteType)
  91.                 ->Set('T1.main_category_has_main_categories', 1)
  92.                 ->Set('T1.main_category_webname', $webName)
  93.                 ->Find();
  94.         }
  95.         return $itemFbnr;
  96.     }
  98. }