app/Customize/Service/MessageService.php line 119

Open in your IDE?
  1. <?php
  2. /**
  3.  * @version EC=CUBE4
  4.  * @copyright 株式会社 翔 kakeru.co.jp
  5.  * @author
  6.  * 2022年08月15日作成
  7.  *
  8.  * app/Customize/Service/MessageSErvice.php
  9.  *
  10.  *
  11.  * メッセージサービス
  12.  *
  13.  *
  14.  *                               C= C= C= ┌(;･_･)┘ﾄｺﾄｺ
  15.  ******************************************************/
  17. namespace Customize\Service;
  19. use Lm\Service\Db\SqlService;
  21. class MessageService
  22. {
  23.     private $lmHelper;
  25.     public function __construct(LmHelper $lmHelper)
  26.     {
  27.         $this->lmHelper = $lmHelper;
  28.     }
  30. public function GetMessage($GoodsId = null ,$CategoryId = null){
  32.     $Sql = new SqlService();
  34.     $Sql->Table('customer_message_table')
  35.         ->Set('display',1 )
  36.         ->Set('approval' ,1)
  37.         ->Order('cm_id','DESC');
  39.     if (!is_null($GoodsId)){
  40.         $Sub ='oh_id IN (SELECT S1.ol_oh FROM order_list_table AS S1 INNER JOIN goods_table AS S2 ON S1.ol_goods = S2.goods_id WHERE S2.goods_ddate IS NULL AND S1.ol_goods = :GoodsId)';
  41.         $Sql->Where($Sub)
  42.         ->Param(':GoodsId',$GoodsId);
  43.     }elseif (!is_null($CategoryId)){
  44.         $Sql->Set('cm_id',0 ,'>')
  45.             ->Set('category','"'.$CategoryId.'"','LIKE');
  47.     }
  49.         return $Sql->FindAll();
  51. }
  52. public function GetGoodsList($Id){
  54.     $Sql = new SqlService();
  55.     return  $Sql->Table('customer_message_table')
  56.                 ->Select('T.*,T1.*,T2.*')
  57.                 ->Join('order_list_table','oh_id = ol_oh','INNER')
  58.                 ->Join('goods_table', 'T1.ol_goods = goods_id', 'INNER')
  59.                 ->Set('T.cm_id',$Id)
  60.                 ->Order('T.display_datetime','DESC')
  61.                 ->FindAll();
  62. }
  64. public function GetCategoryList(){
  66.     $Sql = new SqlService();
  68.     return  $Sql->Table('customer_message_category_table')
  69.                 ->Set('delete',0)
  70.                 ->FindAll();
  74. }
  76.     public function getCustomerMessagesAndCount($goodsId, $limit)
  77.     {
  78.         $messages = (new SqlService())
  79.             ->Sql("
  80.                 SELECT SQL_CALC_FOUND_ROWS
  81.                     customer_message_table.cm_id,
  82.                     customer_message_table.oh_id,
  83.                     customer_message_table.customer_name,
  84.                     customer_message_table.title,
  85.                     customer_message_table.comment,
  86.                     customer_message_table.staff_comment,
  87.                     customer_message_table.category,
  88.                     customer_message_table.use,
  89.                     customer_message_table.file,
  90.                     customer_message_table.display,
  91.                     customer_message_table.approval,
  92.                     customer_message_table.app_datetime,
  93.                     customer_message_table.upd_datetime,
  94.                     customer_message_table.add_datetime,
  95.                     customer_message_table.display_datetime,
  96.                     CASE WHEN customer_message_table.file IS NULL THEN 0 ELSE 1 END AS file_exits,
  97.                     customer_table.customer_user_name
  98.                 FROM customer_message_table
  99.                 INNER JOIN order_header_table ON order_header_table.oh_id = customer_message_table.oh_id
  100.                 INNER JOIN customer_table ON oh_customer = customer_table.customer_id
  101.                 INNER JOIN order_list_table ON customer_message_table.oh_id = ol_oh
  102.                 INNER JOIN goods_table ON ol_goods = goods_id
  103.                 WHERE goods_id = :goods_id AND display = '1' AND approval = '1'
  104.                 GROUP BY customer_message_table.cm_id
  105.                 ORDER BY file_exits DESC, customer_message_table.display_datetime DESC
  106.                 LIMIT :limit;
  107.             ")
  108.             ->Params(['goods_id' => $goodsId, 'limit' => $limit])
  109.             ->FetchAll();
  110.         if (empty($messages)) {
  111.             return [[], 0];
  112.         }
  114.         $foundMessages = (new SqlService())->Sql('SELECT FOUND_ROWS() AS total')->Fetch();
  116.         return [$messages, $foundMessages['total'] ?? 0];
  117.     }
  119.     public function formatCustomerMessages($messages)
  120.     {
  121.         return array_map(function ($message) {
  122.             $message['display_datetime'] = date('Y年m月d日', strtotime($message['display_datetime']));
  123.             $attachments = unserialize($message['file']);
  124.             if ($attachments) {
  125.                 $message['file'] = $this->lmHelper->getConfig('CFIMG_BACK_URL') . '/images/koe_admin/'
  126.                     . $message['cm_id'] . '/' . reset($attachments);
  127.             }
  128.             if ($message['comment']) {
  129.                 $comment = strip_tags(str_replace("<br />", "", $message['comment']));
  130.                 $message['shorted_comment'] = mb_substr($comment, 0, 216);
  131.                 $message['extra_comment'] = mb_substr(strip_tags($comment), 216);
  132.             }
  133.             if ($message['staff_comment']) {
  134.                 $staffComment = strip_tags($message['staff_comment']);
  135.                 $message['shorted_staff_comment'] = mb_substr($staffComment, 0, 216);
  136.                 $message['extra_staff_comment'] = mb_substr(strip_tags($staffComment), 216);
  137.             }
  139.             return $message;
  140.         }, $messages);
  141.     }
  142. }