Changeset 21409 for branches/version-2_11-dev/data/class/SC_Product.php

Timestamp:

2012/01/17 16:26:02 (14 years ago)

Author:

Seasoft

Message:

2.12系へマイルストーン変更となったチケット分を差し戻し
r21329 #1548
r21328 #1545

File:

• branches/version-2_11-dev/data/class/SC_Product.php (modified) (4 diffs)

branches/version-2_11-dev/data/class/SC_Product.php

@@ -165 +165 @@
             ,update_date
 __EOS__;
-        $res = $objQuery->select($col, $this->alldtlSQL());
+        $where = 'dtb_products_class.del_flg = 0';
+        $res = $objQuery->select($col, $this->alldtlSQL($where));
         return $res;
     }
@@ -221 +222 @@
     function getDetail($productId) {
         $objQuery =& SC_Query_Ex::getSingletonInstance();
-        $result = $objQuery->select("*", $this->alldtlSQL('product_id = ?'),
+        $result = $objQuery->select("*", $this->alldtlSQL("product_id = ? AND del_flg = 0"),
                                     "product_id = ?",
                                     array($productId, $productId));
@@ -688 +689 @@
         $where_clause = '';
         if (!SC_Utils_Ex::isBlank($where_products_class)) {
-            $where_products_class = 'AND (' . $where_products_class . ')';
+            $where_clause = 'WHERE ' . $where_products_class;
         }
         /*
@@ -773 +774 @@
                               COUNT(*) as class_count
                         FROM dtb_products_class
-                        WHERE del_flg = 0 $where_products_class
+                        $where_clause
                         GROUP BY product_id
                     ) AS T4