Changeset 10937 for temp/branches

Timestamp:

2006/12/18 20:31:13 (20 years ago)

Author:

uehara

Message:

 

Location:

temp/branches/ec-cube-beta

Files:

• data/Smarty/templates/admin/contents/campaign_create_tag.tpl (modified) (2 diffs)
• html/admin/contents/campaign_create_tag.php (modified) (1 diff)

temp/branches/ec-cube-beta/data/Smarty/templates/admin/contents/campaign_create_tag.tpl

@@ -49 +49 @@
     </tr>
     <tr class="fs12n">
+        <td bgcolor="#f0f0f0">¾¦ÉÊID</td>
+        <td bgcolor="#ffffff"><input type="text" name="search_product_id" value="<!--{$arrForm.search_product_id}-->" size="35" class="box35" /></td>
+    </tr>
+    <tr class="fs12n">
         <td bgcolor="#f0f0f0">¾¦ÉÊ̾</td>
         <td bgcolor="#ffffff"><input type="text" name="search_name" value="<!--{$arrForm.search_name}-->" size="35" class="box35" /></td>
-    </tr>
-    <tr class="fs12n">
-        <td bgcolor="#f0f0f0">¾¦ÉÊ¥³¡¼¥É</td>
-        <td bgcolor="#ffffff"><input type="text" name="search_product_code" value="<!--{$arrForm.search_product_code}-->" size="35" class="box35" /></td>
     </tr>
 </table>
@@ -82 +82 @@
         <tr bgcolor="#f0f0f0" align="center" class="fs12">
             <td>¾¦ÉʲèÁü</td>
-            <td>¾¦ÉÊ¥³¡¼¥É</td>
+            <td>¾¦ÉÊID</td>
             <td>¾¦ÉÊ̾</td>
             <td>·èÄê</td>

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

@@ -61 +61 @@
                 $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 ILIKE ?";
-                $arrval[] = "%$val%";
-                $arrval[] = "%$val%";
+            case 'search_product_id':
+                if($val != "") {
+                    $where .= " AND product_id = ?";
+                    $arrval[] = $val;
+                }
                 break;
             default: