Ignore:
Timestamp:
2007/11/27 20:32:49 (16 years ago)
Author:
satou
Message:

#188
修正完了。

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/feature-module-update/data/class/pages/products/LC_Page_Products_List.php

    r16777 r16808  
    382382        //価格順 
    383383        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"; 
    388393            break; 
    389394 
    390395        //新着順 
    391396        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"; 
    396406            break; 
    397407 
    398408        default: 
    399409            $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," 
    404414                . " main_list_image, product_flag, deliv_date_id, sale_limit," 
    405415                . " point_rate, sale_unlimited, create_date, deliv_fee, " 
    406416                . " T4.product_rank, T4.category_rank"; 
    407             $from = "vw_products_allclass AS T1 " 
     417            $from = "vw_products_allclass AS T1" 
    408418                . " 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," 
    411421                . "        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)" 
    414424                . " GROUP BY product_id) AS T4 USING (product_id)"; 
    415425            $order = "T4.category_rank DESC, T4.product_rank DESC"; 
     
    588598 
    589599        $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] = ""; 
    592602 
    593603        $this->tpl_onload .= "lnSetSelect('" . $classcategory_id ."_1', " 
    594             . "'" . $$classcategory_id_2 . "'," 
     604            . "'" . $classcategory_id_2 . "'," 
    595605            . "'" . $product_id . "'," 
    596             . "'" . $_POST[$$classcategory_id_2] ."'); "; 
     606            . "'" . $_POST[$classcategory_id_2] ."'); "; 
    597607 
    598608        // 規格1が設定されている 
Note: See TracChangeset for help on using the changeset viewer.