Changeset 10943

Timestamp:

2006/12/18 21:18:07 (20 years ago)

Author:

uehara

Message:

 

File:

• temp/branches/ec-cube-beta/html/admin/contents/campaign_create_tag.php (modified) (3 diffs)

temp/branches/ec-cube-beta/html/admin/contents/campaign_create_tag.php

@@ -60 +60 @@
                 $where.= $tmp_where . " )";
                 break;
-            case 'search_product_code':
-                $where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code LIKE ? GROUP BY product_id)";
-                $where .= " OR product_code LIKE ?";
-                $arrval[] = "%$val%";
-                $arrval[] = "%$val%";
-                break;
+            case 'search_product_id':
+                if($val != "") {
+                    $where .= " AND product_id = ?";
+                    if(!sfIsInt($val)) $val = 0;
+                    $arrval[] = $val;
+                }
             default:
                 break;
@@ -75 +75 @@
     // Æɤ߹þ¤àÎó¤È¥Æ¡¼¥Ö¥ë¤Î»ØÄê
     $col = "product_id, name, category_id, main_list_image, status, product_code, price01, stock, stock_unlimited";
-    $from = "vw_products_class AS cls";
+    $from = "vw_products_class AS allcls";
         
     $objQuery = new SC_Query();
@@ -100 +100 @@
     
     // view¤â¹Ê¹þ¤ß¤ò¤«¤±¤ë(mysqlÍÑ)
-    sfViewWhere("&&cls_where&&", $where, $arrval, $objQuery->order . " " .  $objQuery->setlimitoffset($page_max, $startno, true));
+    sfViewWhere("&&allcls_where&&", $where, $arrval, $objQuery->order . " " .  $objQuery->setlimitoffset($page_max, $startno, true));
     
     // ¸¡º÷·ë²Ì¤Î¼èÆÀ