Changeset 18427

Timestamp:

2009/12/05 10:30:05 (14 years ago)

Author:

AMUAMU

Message:

#519 SQL文が間違っていた為、修正しました。

File:

• branches/comu-ver2/data/class/util/SC_Utils.php (modified) (3 diffs)

branches/comu-ver2/data/class/util/SC_Utils.php

@@ -789 +789 @@
     function sfInsertProductClass($objQuery, $arrList, $product_id , $product_class_id = "") {
         // すでに規格登録があるかどうかをチェックする。
-        $where = "product_id = ? AND classcategory_id1 <> 0 AND classcategory_id1 <> 0";
+        $where = "product_id = ? AND classcategory_id1 <> 0 AND classcategory_id2 <> 0";
         $count = $objQuery->count("dtb_products_class", $where,  array($product_id));
 
@@ -2030 +2030 @@
         for($i = 0; $i < $cnt; $i++) {
             $html.= "<tr>";
-            foreach($array[$i] as $val) {
+            foreach($array[$i] as $val) {
                 $html.="<td>$val</td>";
             }
@@ -2223 +2223 @@
         $town = ereg_replace("以下に掲載がない場合","",$town);
         $data_list[0]['town'] = $town;
-        $data_list[0]['state'] = $arrREV_PREF[$data_list[0]['state']];
+        $data_list[0]['state'] = $arrREV_PREF[$data_list[0]['state']];
 
         return $data_list;