Changeset 17955


Ignore:
Timestamp:
2009/04/08 21:49:36 (13 years ago)
Author:
Seasoft
Message:

「お気に入り登録機能」の重複表示の修正。
・Linux-user 様の報告。  http://xoops.ec-cube.net/modules/newbb/viewtopic.php?topic_id=3739&forum=1
・使用するビューが誤っていた。

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/comu-ver2/data/class/pages/mypage/LC_Page_Mypage_Favorite.php

    r17519 r17955  
    9595        } 
    9696 
    97         $col = "allcls.*"; 
    98         $from = "dtb_customer_favorite_products AS dcfp LEFT JOIN vw_products_allclass AS allcls USING(product_id)"; 
     97        $col = "alldtl.*"; 
     98        $from = "dtb_customer_favorite_products AS dcfp LEFT JOIN vw_products_allclass_detail AS alldtl USING(product_id)"; 
    9999         
    100         $where = "allcls.del_flg = 0 AND allcls.status = 1 AND dcfp.customer_id = ?"; 
     100        $where = "alldtl.del_flg = 0 AND alldtl.status = 1 AND dcfp.customer_id = ?"; 
    101101        // 在庫無し商品の非表示 
    102102        if (NOSTOCK_HIDDEN === true) { 
    103             $where .= ' AND (allcls.stock_max >= 1 OR allcls.stock_unlimited_max = 1)'; 
     103            $where .= ' AND (alldtl.stock_max >= 1 OR alldtl.stock_unlimited_max = 1)'; 
    104104        } 
    105105 
Note: See TracChangeset for help on using the changeset viewer.