Changeset 16968 for branches/feature-module-update/data/class/SC_CustomerList.php

Timestamp:

2008/01/09 17:07:57 (18 years ago)

Author:

satou

Message:

#196 顧客マスタの検索でカテゴリ指定して検索できないバグを修正

File:

• branches/feature-module-update/data/class/SC_CustomerList.php (modified) (1 diff)

branches/feature-module-update/data/class/SC_CustomerList.php

@@ -325 +325 @@
             //カテゴリーで絞込みが可能の場合
             if($tmp_where != "") {
-                $this->setWhere( " customer_id IN (SELECT distinct customer_id FROM dtb_order WHERE order_id IN (SELECT distinct order_id FROM dtb_order_detail WHERE product_id IN (SELECT product_id FROM dtb_products WHERE ".$tmp_where." ))) ");
+                $this->setWhere( " customer_id IN (SELECT distinct customer_id FROM dtb_order WHERE order_id IN (SELECT distinct order_id FROM dtb_order_detail WHERE product_id IN (SELECT product_id FROM dtb_product_categories WHERE ".$tmp_where." ))) ");
                 $this->arrVal = array_merge((array)$this->arrVal, (array)$tmp_arrval);
             }