Changeset 23654 for branches/version-2_13_3/data/class/pages/admin/products/LC_Page_Admin_Products_Review.php

Timestamp:

2014/10/14 11:27:26 (10 years ago)

Author:

kim

Message:

#2560 r23461 r23464 をリバート

既存関数の削除が多く、2.13.3では採用を見送ります。
下位互換が担保された場合、2.13.4で採用を検討します。

File:

• branches/version-2_13_3/data/class/pages/admin/products/LC_Page_Admin_Products_Review.php (modified) (5 diffs)

branches/version-2_13_3/data/class/pages/admin/products/LC_Page_Admin_Products_Review.php

@@ -86 +86 @@
     public function action()
     {
-        $objReview = new SC_Helper_Review_Ex();
         // パラメーター管理クラス
         $objFormParam = new SC_FormParam_Ex();
@@ -106 +105 @@
         switch ($this->getMode()) {
             case 'delete':
-                $objReview->delete($this->arrForm['review_id']);
+                $this->lfDeleteReview($this->arrForm['review_id']);
             case 'search':
             case 'csv':
 
+                // 検索条件を取得
+                list($where, $arrWhereVal) = $this->lfGetWhere($this->arrForm);
                 // 検索結果を取得
-                $this->arrReview = $this->lfGetReview($objReview);
+                $this->arrReview = $this->lfGetReview($this->arrForm, $where, $arrWhereVal);
 
                 //CSVダウンロード
                 if ($this->getMode() == 'csv') {
-                    // 検索条件を取得
-                    list($where, $arrWhereVal) = $this->lfGetWhere($this->arrForm);
                     $this->lfDoOutputCsv($where, $arrWhereVal);
 
@@ -159 +158 @@
 
         return $objErr->arrErr;
+    }
+
+    /**
+     * 商品レビューの削除
+     *
+     * @param  integer $review_id 商品レビューのID
+     * @return void
+     */
+    public function lfDeleteReview($review_id)
+    {
+        $objQuery =& SC_Query_Ex::getSingletonInstance();
+        $sqlval['del_flg'] = 1;
+        $objQuery->update('dtb_review', $sqlval, 'review_id = ?', array($review_id));
     }
 
@@ -322 +334 @@
      * レビュー検索結果の取得
      *
-     * @param  SC_Helper_Review $objReview
+     * @param  array  $arrForm     フォームデータ
+     * @param  string $where       WHERE文
+     * @param  array  $arrWhereVal WHERE文の判定値
      * @return array  レビュー一覧
      */
-    public function lfGetReview(SC_Helper_Review $objReview)
-    {
-        $arrForm = $this->arrForm;
-
-        $query = $this->makeQuery($arrForm);
-        $linemax = $objReview->count($query);
-
+    public function lfGetReview($arrForm, $where, $arrWhereVal)
+    {
+        $objQuery =& SC_Query_Ex::getSingletonInstance();
+
+        // ページ送りの処理
+        $page_max = SC_Utils_Ex::sfGetSearchPageMax($arrForm['search_page_max']);
+
+        if (!isset($arrWhereVal)) $arrWhereVal = array();
+
+        $from = 'dtb_review AS A LEFT JOIN dtb_products AS B ON A.product_id = B.product_id ';
+        $linemax = $objQuery->count($from, $where, $arrWhereVal);
         $this->tpl_linemax = $linemax;
+
         $this->tpl_pageno = isset($arrForm['search_pageno']) ? $arrForm['search_pageno'] : '';
 
         // ページ送りの取得
-        $page_max = SC_Utils_Ex::sfGetSearchPageMax($arrForm['search_page_max']);
         $objNavi = new SC_PageNavi_Ex($this->tpl_pageno, $linemax, $page_max,
                                       'eccube.moveNaviPage', NAVI_PMAX);
@@ -343 +361 @@
 
         // 取得範囲の指定(開始行番号、行数のセット)
-        $params = array(
-            'query' => $query,
-            'limit' => $page_max,
-            'offset' => $startno
-        );
-        $arrReview = $objReview->find($params);
+        $objQuery->setLimitOffset($page_max, $startno);
+
+        // 表示順序
+        $order = 'A.create_date DESC';
+        $objQuery->setOrder($order);
+        //検索結果の取得
+        //レビュー情報のカラムの取得
+        $col = 'review_id, A.product_id, reviewer_name, sex, recommend_level, ';
+        $col .= 'reviewer_url, title, comment, A.status, A.create_date, A.update_date, name';
+        $from = 'dtb_review AS A LEFT JOIN dtb_products AS B ON A.product_id = B.product_id ';
+        $arrReview = $objQuery->select($col, $from, $where, $arrWhereVal);
 
         return $arrReview;
     }
-
-    /**
-     * SC_Helper_Reviewインスタンスへ渡す検索条件の配列を作成.
-     *
-     * @param array $data
-     * @return array
-     */
-    private function makeQuery($data = array()) {
-        $query = array();
-
-        foreach ($data AS $key => $val) {
-            if (empty($val)) continue;
-
-            switch ($key) {
-                case 'search_reviewer_name':
-                    $query['reviewer_name'] = $val;
-                    break;
-
-                case 'search_reviewer_url':
-                    $query['reviewer_url'] = $val;
-                    break;
-
-                case 'search_name':
-                    $query['product_name'] = $val;
-                    break;
-
-                case 'search_product_code':
-                    $query['product_code'] = $val;
-                    break;
-
-                case 'search_sex':
-                    $query['reviewer_sex'] = $val;
-                    break;
-
-                case 'search_recommend_level':
-                    $query['recommend_level'] = $val;
-                    break;
-
-                case 'search_startyear':
-                    if (isset($_POST['search_startyear']) && isset($_POST['search_startmonth']) && isset($_POST['search_startday'])) {
-                        $date = SC_Utils_Ex::sfGetTimestamp($_POST['search_startyear'], $_POST['search_startmonth'], $_POST['search_startday']);
-                        $query['date_from'] = $date;
-                    }
-                    break;
-
-                case 'search_endyear':
-                    if (isset($_POST['search_startyear']) && isset($_POST['search_startmonth']) && isset($_POST['search_startday'])) {
-                        $date = SC_Utils_Ex::sfGetTimestamp($_POST['search_endyear'], $_POST['search_endmonth'], $_POST['search_endday']);
-                        $end_date = date('Y/m/d', strtotime('1 day', strtotime($date)));
-                        $query['date_to'] = $end_date;
-                    }
-                    break;
-
-                default:
-                    break;
-            }
-
-        }
-
-        return $query;
-    }
 }