Changeset 18436

Timestamp:

2009/12/08 01:15:11 (12 years ago)

Author:

Seasoft

Message:

非公開の商品は、フロント機能では表示しない。非公開の商品も、管理機能では表示する。以上を徹底。

• フォーラムにて意見集約を試みる。 http://xoops.ec-cube.net/modules/newbb/viewtopic.php?topic_id=4974&forum=2
• 例外・追加事項は未実装。

Location:

branches/comu-ver2/data/class

Files:

• helper/SC_Helper_DB.php (modified) (3 diffs)
• pages/admin/contents/LC_Page_Admin_Contents_RecommendSearch.php (modified) (1 diff)
• pages/admin/order/LC_Page_Admin_Order_Edit.php (modified) (1 diff)

branches/comu-ver2/data/class/helper/SC_Helper_DB.php

@@ -250 +250 @@
      *
      * @param array $arrID 規格ID
+     * @param boolean $includePrivateProducts 非公開商品を含むか
      * @return array 規格情報の配列
      */
-    function sfGetProductsClass($arrID) {
+    function sfGetProductsClass($arrID, $includePrivateProducts = false) {
         list($product_id, $classcategory_id1, $classcategory_id2) = $arrID;
 
-        if($classcategory_id1 == "") {
+        if (strlen($classcategory_id1) == 0) {
             $classcategory_id1 = '0';
         }
-        if($classcategory_id2 == "") {
+        if (strlen($classcategory_id2) == 0) {
             $classcategory_id2 = '0';
         }
@@ -264 +265 @@
         // 商品規格取得
         $objQuery = new SC_Query();
-        $col = "product_id, deliv_fee, name, product_code, main_list_image, main_image, price01, price02, point_rate, product_class_id, classcategory_id1, classcategory_id2, class_id1, class_id2, stock, stock_unlimited, sale_limit";
-        $table = "vw_product_class AS prdcls";
-        $where = "product_id = ? AND classcategory_id1 = ? AND classcategory_id2 = ? AND status = 1";
+        $col = 'product_id, deliv_fee, name, product_code, main_list_image, main_image, price01, price02, point_rate, product_class_id, classcategory_id1, classcategory_id2, class_id1, class_id2, stock, stock_unlimited, sale_limit';
+        $table = 'vw_product_class AS prdcls';
+        $where = 'product_id = ? AND classcategory_id1 = ? AND classcategory_id2 = ?';
+        if (!$includePrivateProducts) {
+             $where .= ' AND status = 1';
+        }
         $arrRet = $objQuery->select($col, $table, $where, array($product_id, $classcategory_id1, $classcategory_id2));
         return $arrRet[0];
@@ -287 +291 @@
     /**
      * カート内商品の集計処理を行う.
+     *
+     * 管理機能での利用は想定していないので注意。(非公開商品は除外される。)
      *
      * @param LC_Page $objPage ページクラスのインスタンス

branches/comu-ver2/data/class/pages/admin/contents/LC_Page_Admin_Contents_RecommendSearch.php

@@ -73 +73 @@
             $this->lfConvertParam();
 
-            $where = "del_flg = 0 AND status = 1";
+            $where = 'del_flg = 0';
 
             /* 入力エラーなし */

branches/comu-ver2/data/class/pages/admin/order/LC_Page_Admin_Order_Edit.php

@@ -697 +697 @@
         $objDb = new SC_Helper_DB_Ex();
         $arrClassCatName = $objDb->sfGetIDValueList("dtb_classcategory", "classcategory_id", "name");
-        $arrRet = $objDb->sfGetProductsClass(array($product_id, $classcategory_id1, $classcategory_id2));
+        $arrRet = $objDb->sfGetProductsClass(array($product_id, $classcategory_id1, $classcategory_id2), true);
 
         $arrProduct['price'] = $arrRet['price02'];