Changeset 23461 for branches/version-2_13-dev/data/class/pages/admin/products/LC_Page_Admin_Products_ReviewEdit.php

Timestamp:

2014/05/29 18:54:58 (10 years ago)

Author:

pineray

Message:

#2560 pageクラスからdtb_reviewテーブルを直接指定している箇所をなくす

File:

• branches/version-2_13-dev/data/class/pages/admin/products/LC_Page_Admin_Products_ReviewEdit.php (modified) (4 diffs)

branches/version-2_13-dev/data/class/pages/admin/products/LC_Page_Admin_Products_ReviewEdit.php

@@ -72 +72 @@
     public function action()
     {
+        $objReview = new SC_Helper_Review_Ex();
         // パラメーター情報の初期化
         $objFormParam = new SC_FormParam_Ex();
@@ -88 +89 @@
                 if (SC_Utils_Ex::isBlank($this->arrErr)) {
                     // レビュー情報の更新
-                    $this->lfRegistReviewData($this->arrForm['review_id'], $objFormParam);
+                    $arrValues = $objFormParam->getDbArray();
+                    $objReview->save($arrValues);
                     // レビュー情報のDB取得
-                    $this->arrForm = $this->lfGetReviewData($this->arrForm['review_id']);
+                    $this->arrForm = $objReview->get($this->arrForm['review_id']);
                     $this->tpl_onload = "alert('登録が完了しました。');";
                 }
@@ -96 +98 @@
             default:
                 // レビュー情報のDB取得
-                $this->arrForm = $this->lfGetReviewData($this->arrForm['review_id']);
+                $this->arrForm = $objReview->get($this->arrForm['review_id']);
                 break;
         }
@@ -125 +127 @@
         $objFormParam->addParam('コメント', 'comment', LTEXT_LEN, 'KVa', array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK'));
     }
-
-    /**
-     * レビュー情報のDB取得
-     *
-     * @param  integer $review_id レビューID
-     * @return array   レビュー情報
-     */
-    public function lfGetReviewData($review_id)
-    {
-        $objQuery =& SC_Query_Ex::getSingletonInstance();
-        $select='review_id, A.product_id, reviewer_name, sex, recommend_level, ';
-        $select.='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 ';
-        $where = 'A.del_flg = 0 AND B.del_flg = 0 AND review_id = ? ';
-        $arrReview = $objQuery->select($select, $from, $where, array($review_id));
-        if (empty($arrReview)) {
-            SC_Utils_Ex::sfDispError('');
-        }
-
-        return $arrReview[0];
-    }
-
-    /**
-     * レビュー情報の更新
-     *
-     * @param  integer      $review_id    レビューID
-     * @param  SC_FormParam $objFormParam SC_FormParam インスタンス
-     * @return void
-     */
-    public function lfRegistReviewData($review_id, &$objFormParam)
-    {
-        $objQuery =& SC_Query_Ex::getSingletonInstance();
-        $arrValues = $objFormParam->getDbArray();
-        $arrValues['update_date'] = 'CURRENT_TIMESTAMP';
-        $objQuery->update('dtb_review', $arrValues, 'review_id = ?', array($review_id));
-    }
 }