官方提供的会员等级可以实现商品折扣,但它是针对所有的商品,而我需要的是可以针对某一个商品修改折扣,修改方法如下:
1、修改字段类型
user_price本意是某个商品在某个会员级别修改后的价格,这里把它修改为商品在不同会员级别下的折扣
alter table lab_member_price modify user_price tinyint(3) not null default 0;2、后台修改
languages/zh_cn/admin/goods.php,149行左右,把$_LANG['notice_user_price']修改为:会员价格和折扣,括号内是折扣后的价格,折扣数值范围是1-100
admin/templates/goods_info.htm,570行左右,把set_price_note函数修改为:
function set_price_note(rank_id)
{
var shop_price = parseFloat(document.forms['theForm'].elements['shop_price'].value);
var rank = new Array();
rank[rank_id] = parseInt(document.getElementById('rank_' + rank_id).value);
if (shop_price > 0 && rank[rank_id] && document.getElementById('rank_' + rank_id))
{
var price = parseInt(shop_price * rank[rank_id] + 0.5) / 100;
if (document.getElementById('nrank_' + rank_id))
{
document.getElementById('nrank_' + rank_id).innerHTML = '(' + price + ')';
}
}
else
{
if (document.getElementById('nrank_' + rank_id))
{
document.getElementById('nrank_' + rank_id).innerHTML = '';
}
}
}3、前台修改
goods.php,377行左右,把
$sql = "SELECT rank_id, IFNULL(mp.user_price, r.discount * $shop_price / 100) AS price, r.rank_name, r.discount " .修改为
$sql = "SELECT rank_id, IF(mp.user_price, mp.user_price * $shop_price / 100, $shop_price) AS price, r.rank_name, r.discount " .对整个网站进行搜索,搜索所有的sql语句,搜索条件为:IFNULL(mp.user_price, g.shop_price * '$_SESSION[discount]')
把所有的IFNULL(mp.user_price, g.shop_price * '$_SESSION[discount]')修改为:IF(mp.user_price, mp.user_price * g.shop_price / 100, g.shop_price)
include/lib_common.php,2344行左右,在"return $final_price"前面添加"$final_price = round($final_price)",意思是四舍五入取整
4、删除一个注册页面
如果没有登陆就进入结算中心,会连接到一个页面,左侧是登陆,右侧是注册,这个注册里的条件不全,将其删除
themes/joyo25/flow.dwt,803行左右,把
全部删除
5.设置购物时发票抬头为必选项,用积分换礼品时不用输入发票
languages/zh_cn/shopping_flow.php,44行左右,添加:$_LANG['no_input_invoice'] = '请输入发票抬头!';
languages/en_us/shopping_flow.php,46行左右,添加:$_LANG['no_input_invoice'] = 'Please enter the invoice title!';
flow.php,1588行左右,在
if ($order['extension_code'] == 'exchange_goods')
{
$order['integral_money'] = 0;
$order['integral'] = $total['exchange_integral'];
}下面添加:
else (empty($_POST['inv_payee']))
{
show_message($_LANG['no_input_invoice'], '', '', 'warning');
}6.批量上传文件csv添加会员折扣字段
languages/zh_cn/admin/goods_batch.php,80行左右,添加:
$_LANG['upload_goods']['registered_member'] = '注册会员折扣';
$_LANG['upload_goods']['bronze_member'] = '铜牌会员折扣';
$_LANG['upload_goods']['silver_member'] = '银牌会员折扣';
$_LANG['upload_goods']['gold_member'] = '金牌会员折扣';
languages/en_us/admin/goods_batch.php,82行左右,添加:
$_LANG['upload_goods']['registered_member'] = 'Registered member discount';
$_LANG['upload_goods']['bronze_member'] = 'bronze member discount';
$_LANG['upload_goods']['silver_member'] = 'silver member discount';
$_LANG['upload_goods']['gold_member'] = 'gold member discount';admin/goods_batch.php,429行左右,把
elseif (in_array($field, array('market_price', 'shop_price')))修改为
elseif (in_array($field, array('market_price', 'shop_price', 'registered_member', 'bronze_member', 'silver_member', 'gold_member')))admin/includes/lib_main.php,256行左右,添加一个函数:
/**
* 取得会员等级id号数组,按用户级别排序
*/
function get_rank_id_list()
{
$rank_id_list = array();
$sql = 'SELECT rank_id, rank_name, min_points FROM ' . $GLOBALS['ecs']->table('user_rank');
$sql .= ' ORDER BY min_points';
$res = $GLOBALS['db']->query($sql);
while ($row = $GLOBALS['db']->fetchRow($res))
{
$rank_id_list[] = $row['rank_id'];
}
return $rank_id_list;
}
admin/goods_batch.php,463行左右,在"$max_id = $db->insert_id() + 1;"之后添加:
$rank_list_in = get_rank_id_list();
$price_list_in = array();
$price_list_in[0] = $field_arr['registered_member'];
$price_list_in[1] = $field_arr['bronze_member'];
$price_list_in[2] = $field_arr['silver_member'];
$price_list_in[3] = $field_arr['gold_member'];
handle_member_price($max_id - 1, $rank_list_in, $price_list_in);
阅读(951) | 评论(0) | 转发(0) |