Changeset 18075 for branches/comu-ver2/data/class/pages/admin

Timestamp:

2009/06/09 19:43:22 (17 years ago)

Author:

Seasoft

Message:

merge r17951
・取得元: version-2_4
【取得元のログメッセージ】

• #292 order用に別途、商品検索、登録機能を追加。

File:

• branches/comu-ver2/data/class/pages/admin/order/LC_Page_Admin_Order_ProductSelect.php (modified) (6 diffs)

branches/comu-ver2/data/class/pages/admin/order/LC_Page_Admin_Order_ProductSelect.php

@@ -45 +45 @@
         parent::init();
         $this->tpl_mainpage = 'order/product_select.tpl';
-        $this->tpl_mainno = 'products';
+        $this->tpl_mainno = 'order';
         $this->tpl_subnavi = '';
         $this->tpl_subno = "";
@@ -67 +67 @@
 
         if (!isset($_POST['mode'])) $_POST['mode'] = "";
+
         if ($_GET['no'] != '') {
             $this->tpl_no = strval($_GET['no']);
@@ -90 +91 @@
                 switch ($key) {
                 case 'search_name':
-                    $where .= " AND name LIKE ?";
+                    $where .= " AND name ILIKE ?";
                     $arrval[] = "%$val%";
                     break;
@@ -109 +110 @@
             }
 
-
-/************
-            if (!empty($_GET['order_id'])) {
-                $arrOrderDetails = $objQuery->select('product_id', 'dtb_order_detail', 'order_id = ?', array($_GET['order_id']));
-                $tmp_where = '';
-                foreach ($arrOrderDetails AS $key=>$val) {
-                    if($tmp_where == "") {
-                        $tmp_where.= " product_id NOT IN ( ?";
-                    } else {
-                        $tmp_where.= ",? ";
-                    }
-                    $arrval[] = $val['product_id'];
-                }
-                $tmp_where.= " ) ";
-                $where .= " AND " .$tmp_where;
-            }
-************/
-
             // 読み込む列とテーブルの指定
-            #$col = "product_id, name, category_id, main_list_image, status, product_code, price01, price02, stock, stock_unlimited, point_rate, classcategory_id1, classcategory_id2, (SELECT name FROM dtb_classcategory WHERE classcategory_id = classcategory_id1) AS classcategory_name1, (SELECT name FROM dtb_classcategory WHERE classcategory_id = classcategory_id2) AS classcategory_name2";
-            #$from = "vw_products_nonclass AS noncls ";
-            #$order = "update_date DESC, product_id DESC ";
-
             $col = "DISTINCT T1.product_id, product_code_min, product_code_max,"
                 . " price01_min, price01_max, price02_min, price02_max,"
@@ -183 +162 @@
             // 規格名一覧
             $arrClassName = $objDb->sfGetIDValueList("dtb_class", "class_id", "name");
+
             // 規格分類名一覧
             $arrClassCatName = $objDb->sfGetIDValueList("dtb_classcategory", "classcategory_id", "name");
+
             // 規格セレクトボックス設定
             for($i = 0; $i < count($this->arrProducts); $i++) {
@@ -387 +368 @@
         }
     }
-
-
 }
 ?>