Changeset 1902 for temp/trunk/html
- Timestamp:
- 2006/08/25 11:40:44 (20 years ago)
- File:
-
- 1 edited
-
temp/trunk/html/admin/customer/index.php (modified) (3 diffs)
Legend:
- Unmodified
- Added
- Removed
-
temp/trunk/html/admin/customer/index.php
r1897 r1902 209 209 210 210 // ¥Ú¡¼¥¸Á÷¤ê¤Î½èÍý 211 if(is_numeric($_POST[' search_page_max'])) {212 $page_max = $_POST[' search_page_max'];211 if(is_numeric($_POST['page_max'])) { 212 $page_max = $_POST['page_max']; 213 213 } else { 214 214 $page_max = SEARCH_PMAX; … … 331 331 332 332 switch ($key) { 333 case ' search_product_id':333 case 'product_id': 334 334 $where .= " AND product_id = ?"; 335 335 $arrval[] = $val; 336 336 break; 337 case ' search_product_class_id':337 case 'product_class_id': 338 338 $where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_class_id = ?)"; 339 339 $arrval[] = $val; 340 340 break; 341 case ' search_name':341 case 'name': 342 342 $where .= " AND name ILIKE ?"; 343 343 $arrval[] = "%$val%"; 344 344 break; 345 case ' search_category_id':345 case 'category_id': 346 346 list($tmp_where, $tmp_arrval) = sfGetCatWhere($val); 347 347 if($tmp_where != "") { … … 350 350 } 351 351 break; 352 case ' search_product_code':352 case 'product_code': 353 353 $where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code ILIKE ? GROUP BY product_id)"; 354 354 $arrval[] = "%$val%"; 355 355 break; 356 case 's earch_startyear':357 $date = sfGetTimestamp($_POST['s earch_startyear'], $_POST['search_startmonth'], $_POST['search_startday']);356 case 'startyear': 357 $date = sfGetTimestamp($_POST['startyear'], $_POST['startmonth'], $_POST['startday']); 358 358 $where.= " AND update_date >= ?"; 359 359 $arrval[] = $date; 360 360 break; 361 case ' search_endyear':362 $date = sfGetTimestamp($_POST[' search_endyear'], $_POST['search_endmonth'], $_POST['search_endday']);361 case 'endyear': 362 $date = sfGetTimestamp($_POST['endyear'], $_POST['endmonth'], $_POST['endday']); 363 363 $where.= " AND update_date <= ?"; 364 364 $arrval[] = $date; 365 365 break; 366 case ' search_product_flag':366 case 'product_flag': 367 367 global $arrSTATUS; 368 $ search_product_flag = sfSearchCheckBoxes($val);369 if($ search_product_flag != "") {368 $product_flag = sfSearchCheckBoxes($val); 369 if($product_flag != "") { 370 370 $where.= " AND product_flag LIKE ?"; 371 $arrval[] = $ search_product_flag;371 $arrval[] = $product_flag; 372 372 } 373 373 break; 374 case 's earch_status':374 case 'status': 375 375 $tmp_where = ""; 376 376 foreach ($val as $element){
Note: See TracChangeset
for help on using the changeset viewer.
