历史浏览、购买了该商品的人还买了、相关联产品模块增加“市场价格”.doc

历史浏览、购买了该商品的人还买了、相关联产品模块增加“市场价格”ecshop模板堂() 一、历史浏览模块增加市场价格： 打开include/lin_insert.php 直接替换下面这段函数/* * 调用浏览历史 * * access public * return string */ function insert_history() $str = ; if (!empty($_COOKIEECShistory) $where = db_create_in($_COOKIEECShistory, goods_id); $sql = SELECT goods_id, goods_name, goods_thumb, shop_price, market_price FROM . $GLOBALSecs-table(goods) . WHERE $where AND is_on_sale = 1 AND is_alone_sale = 1 AND is_delete = 0; $query = $GLOBALSdb-query($sql); $res = array(); while ($row = $GLOBALSdb-fetch_array($query) $goodsgoods_id = $rowgoods_id; $goodsgoods_name = $rowgoods_name; $goodsshort_name = $GLOBALS_CFGgoods_name_length 0 ? sub_str($rowgoods_name, $GLOBALS_CFGgoods_name_length) : $rowgoods_name; $goodsgoods_thumb = get_image_path($rowgoods_id, $rowgoods_thumb, true); $goodsshop_price = price_format($rowshop_price); $goodsmarket_price = price_format($rowmarket_price); $goodsurl = build_uri(goods, array(gid=$rowgoods_id), $rowgoods_name); $str.=ul class=clearfixli class=goodsimga href=.$goodsurl. target=_blankimg src=.$goodsgoods_thumb. alt=.$goodsgoods_name. class=B_blue /a/lilia href=.$goodsurl. target=_blank title=.$goodsgoods_name.$goodsshort_name./abr /.原价：.$goodsmarket_price.br /.现价：.font class=f1.$goodsshop_price./fontbr /li/ul; $str .= ul id=clear_historya onclick=clear_history() . $GLOBALS_LANGclear_history . /a/ul; return $str; 二、购买过该商品的朋友还购买了模块增加市场价格： 打开goods.php 直接替换以下函数 /* * 获得购买过该商品的人还买过的商品 * * access public * param integer $goods_id * return array */ function get_also_bought($goods_id) $sql = SELECT COUNT(b.goods_id ) AS num, g.goods_id, g.goods_name, g.goods_thumb, g.goods_img, g.shop_price, g.market_price, mote_price, mote_start_date, mote_end_date . FROM . $GLOBALSecs-table(order_goods) . AS a . LEFT JOIN . $GLOBALSecs-table(order_goods) . AS b ON b.order_id = a.order_id . LEFT JOIN . $GLOBALSecs-table(goods) . AS g ON g.goods_id = b.goods_id . WHERE a.goods_id = $goods_id AND b.goods_id $goods_id AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 . GROUP BY b.goods_id . ORDER BY num DESC . LIMIT . $GLOBALS_CFGbought_goods; $res = $GLOBALSdb-query($sql); $key = 0; $arr = array(); while ($row = $GLOBALSdb-fetchRow($res) $arr$keygoods_id = $rowgoods_id; $arr$keygoods_name = $rowgoods_name; $arr$keyshort_name = $GLOBALS_CFGgoods_name_length 0 ? sub_str($rowgoods_name, $GLOBALS_CFGgoods_name_length) : $rowgoods_name; $arr$keygoods_thumb = get_image_path($rowgoods_id, $rowgoods_thumb, true); $arr$keygoods_img = get_image_path($rowgoods_id, $rowgoods_img); $arr$keyshop_price = price_format($rowshop_price); $arr$keymarket_price = price_format($rowmarket_price); $arr$keyurl = build_uri(goods, array(gid=$rowgoods_id), $rowgoods_name); if ($rowpromote_price 0) $arr$keypromote_price = bargain_price($rowpromote_price, $rowpromote_start_date, $rowpromote_end_date); $arr$keyformated_promote_price = price_format($arr$keypromote_price); else $arr$keypromote_price = 0; $key+; return $arr; 然后再