Changeset 21514 for branches/version-2_12-dev/data/class/pages/admin/products/LC_Page_Admin_Products_ProductSelect.php
- Timestamp:
- 2012/02/15 19:56:17 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/pages/admin/products/LC_Page_Admin_Products_ProductSelect.php
r21481 r21514 46 46 $this->tpl_mainpage = 'products/product_select.tpl'; 47 47 $this->tpl_mainno = 'products'; 48 $this->tpl_subno = "";48 $this->tpl_subno = ''; 49 49 $this->tpl_maintitle = '商品管理'; 50 50 $this->tpl_subtitle = '商品選択'; … … 107 107 */ 108 108 function lfInitParam(&$objFormParam) { 109 $objFormParam->addParam( "カテゴリ", 'search_category_id', STEXT_LEN, 'n');110 $objFormParam->addParam( "商品名", 'search_name', STEXT_LEN, 'KVa');111 $objFormParam->addParam( "商品コード", 'search_product_code', STEXT_LEN, 'KVa');109 $objFormParam->addParam('カテゴリ', 'search_category_id', STEXT_LEN, 'n'); 110 $objFormParam->addParam('商品名', 'search_name', STEXT_LEN, 'KVa'); 111 $objFormParam->addParam('商品コード', 'search_product_code', STEXT_LEN, 'KVa'); 112 112 } 113 113 114 114 /* 商品検索結果取得 */ 115 115 function lfGetProducts(&$objDb) { 116 $where = "del_flg = 0";116 $where = 'del_flg = 0'; 117 117 118 118 /* 入力エラーなし */ 119 119 foreach ($this->arrForm AS $key=>$val) { 120 if($val == "") continue;120 if($val == '') continue; 121 121 122 122 switch ($key) { 123 123 case 'search_name': 124 $where .= " AND name ILIKE ?";124 $where .= ' AND name ILIKE ?'; 125 125 $arrval[] = "%$val%"; 126 126 break; 127 127 case 'search_category_id': 128 128 list($tmp_where, $tmp_arrval) = $objDb->sfGetCatWhere($val); 129 if ($tmp_where != "") {130 $where.= " AND product_id IN (SELECT product_id FROM dtb_product_categories WHERE " . $tmp_where . ")";129 if ($tmp_where != '') { 130 $where.= ' AND product_id IN (SELECT product_id FROM dtb_product_categories WHERE ' . $tmp_where . ')'; 131 131 $arrval = array_merge((array)$arrval, (array)$tmp_arrval); 132 132 } 133 133 break; 134 134 case 'search_product_code': 135 $where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code LIKE ? GROUP BY product_id)";135 $where .= ' AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code LIKE ? GROUP BY product_id)'; 136 136 $arrval[] = "$val%"; 137 137 break; … … 141 141 } 142 142 143 $order = "update_date DESC, product_id DESC ";143 $order = 'update_date DESC, product_id DESC '; 144 144 145 145 $objQuery =& SC_Query_Ex::getSingletonInstance(); … … 166 166 // 検索結果の取得 167 167 // FIXME 商品コードの表示 168 $arrProducts = $objQuery->select( "*", SC_Product_Ex::alldtlSQL(), $where, $arrval);168 $arrProducts = $objQuery->select('*', SC_Product_Ex::alldtlSQL(), $where, $arrval); 169 169 return $arrProducts; 170 170 }
Note: See TracChangeset
for help on using the changeset viewer.