Changeset 21514 for branches/version-2_12-dev/data/class/pages/admin/order/LC_Page_Admin_Order_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/order/LC_Page_Admin_Order_ProductSelect.php
r21481 r21514 46 46 $this->tpl_mainpage = 'order/product_select.tpl'; 47 47 $this->tpl_mainno = 'order'; 48 $this->tpl_subno = "";48 $this->tpl_subno = ''; 49 49 $this->tpl_maintitle = '受注管理'; 50 50 $this->tpl_subtitle = '商品選択'; … … 134 134 135 135 // 表示順序 136 $order = "update_date DESC, product_id DESC";136 $order = 'update_date DESC, product_id DESC'; 137 137 $objQuery->setOrder($order); 138 138 … … 202 202 function createWhere(&$objFormParam,&$objDb) { 203 203 $arrForm = $objFormParam->getHashArray(); 204 $where = "alldtl.del_flg = 0";204 $where = 'alldtl.del_flg = 0'; 205 205 $bind = array(); 206 206 foreach ($arrForm as $key => $val) { 207 if ($val == "") {207 if ($val == '') { 208 208 continue; 209 209 } … … 211 211 switch ($key) { 212 212 case 'search_name': 213 $where .= " AND name ILIKE ?";214 $bind[] = "%".$val."%";213 $where .= ' AND name ILIKE ?'; 214 $bind[] = '%'.$val.'%'; 215 215 break; 216 216 case 'search_category_id': 217 217 list($tmp_where, $tmp_bind) = $objDb->sfGetCatWhere($val); 218 if ($tmp_where != "") {219 $where.= " AND alldtl.product_id IN (SELECT product_id FROM dtb_product_categories WHERE " . $tmp_where . ")";218 if ($tmp_where != '') { 219 $where.= ' AND alldtl.product_id IN (SELECT product_id FROM dtb_product_categories WHERE ' . $tmp_where . ')'; 220 220 $bind = array_merge((array)$bind, (array)$tmp_bind); 221 221 } 222 222 break; 223 223 case 'search_product_code': 224 $where .= " AND alldtl.product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code LIKE ? AND del_flg = 0 GROUP BY product_id)";224 $where .= ' AND alldtl.product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code LIKE ? AND del_flg = 0 GROUP BY product_id)'; 225 225 $bind[] = '%'.$val.'%'; 226 226 break; … … 279 279 */ 280 280 function lfInitParam(&$objFormParam) { 281 $objFormParam->addParam( "オーダーID", 'order_id', INT_LEN, 'n', array('EXIST_CHECK', 'MAX_LENGTH_CHECK', 'NUM_CHECK'));282 $objFormParam->addParam( "商品名", 'search_name', STEXT_LEN, 'KVa', array('MAX_LENGTH_CHECK'));283 $objFormParam->addParam( "カテゴリID", 'search_category_id', STEXT_LEN, 'KVa', array('MAX_LENGTH_CHECK', 'SPTAB_CHECK'));284 $objFormParam->addParam( "商品コード", 'search_product_code', LTEXT_LEN, 'KVa', array('MAX_LENGTH_CHECK', 'SPTAB_CHECK'));285 $objFormParam->addParam( "フッター", 'footer', LTEXT_LEN, 'KVa', array('MAX_LENGTH_CHECK', 'SPTAB_CHECK'));281 $objFormParam->addParam('オーダーID', 'order_id', INT_LEN, 'n', array('EXIST_CHECK', 'MAX_LENGTH_CHECK', 'NUM_CHECK')); 282 $objFormParam->addParam('商品名', 'search_name', STEXT_LEN, 'KVa', array('MAX_LENGTH_CHECK')); 283 $objFormParam->addParam('カテゴリID', 'search_category_id', STEXT_LEN, 'KVa', array('MAX_LENGTH_CHECK', 'SPTAB_CHECK')); 284 $objFormParam->addParam('商品コード', 'search_product_code', LTEXT_LEN, 'KVa', array('MAX_LENGTH_CHECK', 'SPTAB_CHECK')); 285 $objFormParam->addParam('フッター', 'footer', LTEXT_LEN, 'KVa', array('MAX_LENGTH_CHECK', 'SPTAB_CHECK')); 286 286 } 287 287 }
Note: See TracChangeset
for help on using the changeset viewer.