Changeset 16808 for branches/feature-module-update/data/class/pages/products/LC_Page_Products_List.php
- Timestamp:
- 2007/11/27 20:32:49 (16 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/feature-module-update/data/class/pages/products/LC_Page_Products_List.php
r16777 r16808 382 382 //価格順 383 383 case 'price': 384 $distinct = "DISTINCT ON (price02_min, product_id)"; 385 $col = $distinct . " *"; 386 $from = "vw_products_allclass "; 387 $order = "price02_min ASC, product_id ASC"; 384 $col = "DISTINCT price02_min, product_id, product_code_min, product_code_max," 385 . " price01_min, price01_max, price02_max," 386 . " stock_min, stock_max, stock_unlimited_min," 387 . " stock_unlimited_max, del_flg, status, name, comment1," 388 . " comment2, comment3, main_list_comment, main_image," 389 . " main_list_image, product_flag, deliv_date_id, sale_limit," 390 . " point_rate, sale_unlimited, create_date, deliv_fee"; 391 $from = "vw_products_allclass AS T1"; 392 $order = "price02_min, product_id"; 388 393 break; 389 394 390 395 //新着順 391 396 case 'date': 392 $distinct = "DISTINCT ON (create_date, product_id)"; 393 $col = $distinct . " *"; 394 $from = "vw_products_allclass "; 395 $order = "create_date DESC, product_id ASC"; 397 $col = "DISTINCT create_date, product_id, product_code_min, product_code_max," 398 . " price01_min, price01_max, price02_min, price02_max," 399 . " stock_min, stock_max, stock_unlimited_min," 400 . " stock_unlimited_max, del_flg, status, name, comment1," 401 . " comment2, comment3, main_list_comment, main_image," 402 . " main_list_image, product_flag, deliv_date_id, sale_limit," 403 . " point_rate, sale_unlimited, create_date, deliv_fee"; 404 $from = "vw_products_allclass AS T1"; 405 $order = "create_date DESC, product_id"; 396 406 break; 397 407 398 408 default: 399 409 $col = "DISTINCT T1.product_id, product_code_min, product_code_max," 400 . " price01_min, price01_max, price02_min, price02_max, 401 . " stock_min, stock_max, stock_unlimited_min, 402 . " stock_unlimited_max, del_flg, status, name, comment1, 403 . " comment2, comment3, main_list_comment, main_image, 410 . " price01_min, price01_max, price02_min, price02_max," 411 . " stock_min, stock_max, stock_unlimited_min," 412 . " stock_unlimited_max, del_flg, status, name, comment1," 413 . " comment2, comment3, main_list_comment, main_image," 404 414 . " main_list_image, product_flag, deliv_date_id, sale_limit," 405 415 . " point_rate, sale_unlimited, create_date, deliv_fee, " 406 416 . " T4.product_rank, T4.category_rank"; 407 $from = "vw_products_allclass AS T1 417 $from = "vw_products_allclass AS T1" 408 418 . " JOIN (" 409 . " SELECT max(T3.rank) AS category_rank, 410 . " max(T2.rank) AS product_rank, 419 . " SELECT max(T3.rank) AS category_rank," 420 . " max(T2.rank) AS product_rank," 411 421 . " T2.product_id" 412 . " FROM dtb_product_categories T2 413 . " JOIN dtb_category T3 USING (category_id) 422 . " FROM dtb_product_categories T2" 423 . " JOIN dtb_category T3 USING (category_id)" 414 424 . " GROUP BY product_id) AS T4 USING (product_id)"; 415 425 $order = "T4.category_rank DESC, T4.product_rank DESC"; … … 588 598 589 599 $classcategory_id_2 = $classcategory_id . "_2"; 590 if (!isset($ $classcategory_id_2)) $$classcategory_id_2 = "";591 if (!isset($_POST[$ $classcategory_id_2])) $_POST[$$classcategory_id_2] = "";600 if (!isset($classcategory_id_2)) $classcategory_id_2 = ""; 601 if (!isset($_POST[$classcategory_id_2])) $_POST[$classcategory_id_2] = ""; 592 602 593 603 $this->tpl_onload .= "lnSetSelect('" . $classcategory_id ."_1', " 594 . "'" . $ $classcategory_id_2 . "',"604 . "'" . $classcategory_id_2 . "'," 595 605 . "'" . $product_id . "'," 596 . "'" . $_POST[$ $classcategory_id_2] ."'); ";606 . "'" . $_POST[$classcategory_id_2] ."'); "; 597 607 598 608 // 規格1が設定されている
Note: See TracChangeset
for help on using the changeset viewer.