ecshop 待评价的功能
2016-07-07 15:01 来源:www.chinab4c.com 作者:ecshop专家
直接贴出sql语句,其它的靠你自已做了: $sql = 'select g.goods_id,g.goods_name,og.order_id from ' . $ecs->table('goods') . ' as g left join ' . $ecs->table('order_goods') . 'as og on og.goods_id=g.goods_id where o.user_id=\''.$_SESSION['user_id'].'\' andg.goods_id not exists (select c.id_value from '. $ecs->table(comment) .' as c where c.comment_type=0 and c.user_id=\''.$_SESSION['user_id'].'\' )'; 仅做参考,没做测试,可能有更好的方法 >>>>>>是有问题,改正过来了: $sql = 'select g.goods_id,g.goods_name from ' . $ecs->table('goods') . ' as g left join ' . $ecs->table('order_goods') . ' as og on og.goods_id=g.goods_idleft join ' . $ecs->table('order_info') . 'as o on o.order_id=og.order_idwhere o.user_id=\''.$_SESSION['user_id'].'\' andg.goods_id not exists (select c.id_value from '. $ecs->table(comment) .' as c where c.comment_type=0 and c.user_id=\''.$_SESSION['user_id'].'\' )'; |
最近更新
常用插件
- ecshop二次开发详细页面生
插件介绍: ECSHOP系统,在很多时候,很多商品没有人购买,不但购买的人...
- ecshop2.7.1打印发货单插件
ecshop2.7.1打印发货单插件介绍:ecshop2.7.1和以前的ecshop版本不一样,ecs...
- ecshop二次商品订购人信息
ecshop二次商品订购人信息填写插件,有时候给朋友送花,或者是送礼品的...
- ecshop分类批量扩展插件
ecshop分类批量扩展插件,这个插件是ecshop插件里面比较核心的插件。我们...
- ecshop商品分类名称增加样
ecshop插件介绍:本插件可以方便在后台管理,为ecshop商品分类名称增加样...
ecshop热门问答
ecshop热门资料
ecshop网站搬家
ecshop童鞋
ecshop搭建
ecshopPICTURE
ecshop订单中心修改
ecshop重金
ecshop去除
ecshop遮挡
ecshop托管
ecshop亟待解决
ecshop戴尔
ecshopredeclare
ecshop预订
ecshopWMV
ecshop文章模块
ecshop工商银行
ecshop798
ecshop发送队列
ecshop模板结构
ecshop双引号
ecshop马来西亚
ecshop数据导入
ecshop自定义的轮播广告位
ecshopdate
ecshop显示分析
ecshopLOGO位置
ecshop扫描
ecshop局域网
ecshop鞋帽
ecshop43591