- Timestamp:
- 2013/08/26 15:52:37 (11 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_13_0/data/class/pages/mypage/LC_Page_Mypage_Favorite.php
r23103 r23126 34 34 { 35 35 /** ページナンバー */ 36 var$tpl_pageno;36 public $tpl_pageno; 37 37 38 38 /** … … 41 41 * @return void 42 42 */ 43 function init()43 public function init() 44 44 { 45 45 parent::init(); … … 53 53 * @return void 54 54 */ 55 function process()55 public function process() 56 56 { 57 57 parent::process(); … … 63 63 * @return void 64 64 */ 65 function action()65 public function action() 66 66 { 67 67 $objCustomer = new SC_Customer_Ex(); … … 109 109 * @return array お気に入り商品一覧 110 110 */ 111 function lfGetFavoriteProduct($customer_id, &$objPage)111 public function lfGetFavoriteProduct($customer_id, &$objPage) 112 112 { 113 113 $objQuery = SC_Query_Ex::getSingletonInstance(); … … 117 117 $where = 'f.customer_id = ? and p.status = 1'; 118 118 if (NOSTOCK_HIDDEN) { 119 $where .= ' AND EXISTS(SELECT * FROM dtb_products_class WHERE product_id = dtb_customer_favorite_products.product_id AND del_flg = 0 AND (stock >= 1 OR stock_unlimited = 1))';119 $where .= ' AND EXISTS(SELECT * FROM dtb_products_class WHERE product_id = f.product_id AND del_flg = 0 AND (stock >= 1 OR stock_unlimited = 1))'; 120 120 } 121 121 $arrProductId = $objQuery->getCol('f.product_id', 'dtb_customer_favorite_products f inner join dtb_products p using (product_id)', $where, array($customer_id)); … … 159 159 160 160 /* 仕方がない処理。。 */ 161 function lfMakeWhere($tablename, $arrProductId)161 public function lfMakeWhere($tablename, $arrProductId) 162 162 { 163 163 // 取得した表示すべきIDだけを指定して情報を取得。 … … 174 174 175 175 // お気に入り商品削除 176 function lfDeleteFavoriteProduct($customer_id, $product_id)176 public function lfDeleteFavoriteProduct($customer_id, $product_id) 177 177 { 178 178 $objQuery =& SC_Query_Ex::getSingletonInstance();
Note: See TracChangeset
for help on using the changeset viewer.