ECSHOP商品评论增加评论权限购买多少次评论多少次
2016-06-13 13:05 来源:www.chinab4c.com 作者:ecshop专家
ecshop商品评论条件修改,修改为购买过该商品多少次,就只能评价多少次。不需要修改数据库,原理简介:先在后台商店设置->基本->评论条件为只有购买过此商品的会员才能评价ecshop原有机制是只要购买过一次,就可以无限评价。 这里加入了简单判断,判断会员对此商品是否进行过评价,获取评价数,再获取此商品的购物次数。评价数不能大于或等于购物次数。 修改如下:打开comment.php找到:(注意,这文件有两处一样的,都要修改!) case COMMENT_BOUGHT : if ($_SESSION['user_id'] > 0) { $sql = "SELECT o.order_id". " FROM " . $ecs->table('order_info'). " AS o, ". $ecs->table('order_goods') . " AS og ". " WHERE o.order_id = og.order_id". " AND o.user_id = '" . $_SESSION['user_id'] . "'". " AND og.goods_id = '" . $cmt->id . "'". " AND o.order_status = '" . OS_CONFIRMED . "' ". " AND (o.pay_status = '" . PS_PAYED . "' OR o.pay_status = '" . PS_PAYING . "') ". " AND (o.shipping_status = '" . SS_SHIPPED . "' OR o.shipping_status = '" . SS_RECEIVED . "') ". " LIMIT 1"; $tmp = $db->getOne($sql); if (emptyempty($tmp)) { $result['error'] = 1; $result['message'] = $_LANG['comment_brought']; } }替换为 case COMMENT_BOUGHT : if ($_SESSION['user_id'] > 0) { $sql = "SELECT COUNT(o.order_id)". " FROM " . $ecs->table('order_info'). " AS o, ". $ecs->table('order_goods') . " AS og ". " WHERE o.order_id = og.order_id". " AND o.user_id = '" . $_SESSION['user_id'] . "'". " AND og.goods_id = '" . $cmt->id . "'". " AND (o.order_status = '" . OS_CONFIRMED . "' or o.order_status = '" . OS_SPLITED . "') ". " AND (o.pay_status = '" . PS_PAYED . "' OR o.pay_status = '" . PS_PAYING . "') ". " AND (o.shipping_status = '" . SS_SHIPPED . "' OR o.shipping_status = '" . SS_RECEIVED . "') "; $bought_count = $db->getOne($sql); if (!$bought_count) { $result['error'] = 1; $result['message'] = $_LANG['comment_brought']; }else{ $sql = "SELECT COUNT(comment_id) FROM " . $ecs->table('comment') . " WHERE user_id = '" . $_SESSION['user_id'] . "'". " AND id_value= '" . $cmt->id . "'"; $comment_count = $db->getOne($sql); if($comment_count >= $bought_count){ $result['error'] = 1; $result['message'] = '您已对此商品进行过评价!您可以继续购买以便再次评论。'; } } }
最近更新
常用插件
- ecshop2.7.2退换货申请插件
ecshop2.7.2退换货申请插件,主要是在 ecshop 现在的基础上,对ecshop的订单处...
- ecshop注册推荐送现金插件
ecshop中的促销售功能还不是很完善,随着电子商务系统的发展和进步,...
- ecshop二次开发商品购买备
ecshop销售统计 插件介绍:ecshop二次开发订单销售统计和商品购买备注服...
- ecshop二次商品订购人信息
ecshop二次商品订购人信息填写插件,有时候给朋友送花,或者是送礼品的...
- ecshop会员中心订单excel倒出
ecshop会员中心订单excel倒出...