0])->field('id,title,pid,lev,logo')->order('sort desc,id asc')->select()->toArray(); $list = make_tree($list); $this->success('ok',['list'=>$list]); } /** * @title 获取第三级分类 * @desc 获取第三级分类 * @author qc * @url /api/Supplier/getThirdCate * @method GET * @header name:Authorization require:1 desc:Token * @param name:fid type:int default:-- desc:一级分类id * @param name:pid type:int default:-- desc:二级分类id【不传查一级分类下全部的三级分类】 * @param name:sort_type type:int default:1 desc:1默认2时间升序3时间降序 * @return name:id type:int default:-- desc:分类id * @return name:title type:string default:0 desc:分类名称 * @return name:lev type:int default:0 desc:分类等级 * @return name:children type:array default:0 desc:下级分类 */ public function getThirdCate() { $where = []; $where[]=['is_deleted','=',0]; $where[]=['pid','=',input('fid')]; $sort_type = input('get.sort_type',1); if(!$sort_type){ $order = ['sort desc,id asc']; } switch ($sort_type) { case 1: $order = 'sort desc,id asc'; break; case 2: $order = 'id asc,sort desc'; break; case 3: $order = 'id desc,sort desc'; break; } if(input('pid')) $where[] = ['id','=',input('pid')]; $list = SupplierCate::where($where)->field('id,title,pid,lev,logo')->order('sort desc,id asc')->select()->toArray(); foreach ($list as &$v) { $v['children'] = SupplierCate::where([['is_deleted','=',0],['pid','=',$v['id']]])->field('id,title,pid,lev,logo')->order($order)->select()->toArray(); } $this->success('ok',['list'=>$list]); } /** * @title 联系我们(详情内部)【两个二维码】 * @desc 联系我们 * @author qc * @method GET * @url /api/Supplier/getSupplierContact * @header name:Authorization require:1 desc:Token * @param name:supplier_id type:int default:-- desc:供应商id * @return name:phone type:string default:-- desc:供应商电话 * @return name:email type:string default:-- desc:供应商email * @return name:qr_code type:int default:-- desc:供应商二维码 * @return name:contact_qrcode type:string default:-- desc:平台二维码 * @return name:contact_phone type:string default:-- desc:平台电话 * @return name:contact_email type:string default:-- desc:平台邮箱 */ public function getSupplierContact() { $sel_where[] = ['id','=',input('get.supplier_id')]; $detail = \app\common\model\Supplier::field('id,phone,email,qr_code')->where($sel_where)->find()->toArray(); $contact = Db::name('contact')->where('tag','supplier')->field('qrcode contact_qrcode,phone contact_phone,email contact_email')->find(); $contact['phone'] = $detail['phone']; $contact['email'] = $detail['email']; $contact['qr_code'] = $detail['qr_code']; $this->success('ok',$contact); } /** * @title 获取供应商列表 * @desc 获取供应商列表 * @author qc * @method GET * @url /api/Supplier/getSupplierList * @header name:Authorization require:1 desc:Token * @param name:title type:string default:-- desc:标题 * @param name:page type:int default:0 desc:页数 * @param name:page_num type:int default:20 desc:每页数 * @param name:sort_type type:int default:1 desc:1默认2时间升序3时间降序 * @return name:title type:string default:-- desc:名称 * @return name:cover type:string default:-- desc:公司logo * @return name:phone type:string default:-- desc:电话 * @return name:email type:string default:-- desc:email * @return name:label_name type:array default:-- desc:标签 * @return name:content type:string default:-- desc:供应商详情 * @return name:create_at type:string default:-- desc:时间 * @return name:build_time type:string default:-- desc:成立时间 * @return name:work_place type:string default:-- desc:办公地点 * @return name:business type:string default:-- desc:业务范围 * @return name:total_num type:int default:-- desc:总评论数(仅一级) */ public function getSupplierList(){ $title = input('get.title'); $sort_type = input('get.sort_type',1); switch ($sort_type) { case 1: $order = ['sort'=>'desc','id'=>'asc']; break; case 2: $order = ['id'=>'asc','sort'=>'desc']; break; case 3: $order = ['id'=>'desc','sort'=>'desc']; break; } $sel_where = []; $sel_where[] = ['is_deleted','=',0]; $sel_where[] = ['status','=',1]; if($title && $this->user_id) UserSearch::saveSearchTitle($this->user_id,$title,9); $list = \app\common\model\Supplier::where($sel_where) ->when($title,function ($query)use($title){ if($title) $query->where('title|label','like','%'.$title.'%'); })->order($order)->limit($this->off_set,$this->page_num)->select()->toArray(); foreach ($list as &$v) { $v['cover'] =$v['logo'] ; $v['label_name'] =$v['label'] ? explode(',',trim($v['label'],',')):null; $v['business_arr'] = $v['business'] ? explode(',',trim($v['business'],',')) : null; } $total_num =\app\common\model\Supplier::where($sel_where)->when($title,function ($query)use($title){ if($title) $query->where('title|label','like','%'.$title.'%'); })->count(); $this->success('ok',['list'=>$list,'total_num'=>numTransform($total_num),'total_count'=>$total_num,'page_num'=>$this->page_num]); } /** * @title 获取供应商详情 * @desc 获取供应商详情 * @author qc * @method GET * @url /api/Supplier/getSupplierDetail * @header name:Authorization require:1 desc:Token * @param name:id type:int default:-- desc:供应商记录id * @return name:title type:string default:-- desc:名称 * @return name:cover type:string default:-- desc:公司logo * @return name:phone type:string default:-- desc:电话 * @return name:email type:string default:-- desc:email * @return name:label_name type:array default:-- desc:标签 * @return name:content type:string default:-- desc:供应商详情 * @return name:create_at type:string default:-- desc:时间 * @return name:build_time type:string default:-- desc:成立时间 * @return name:work_place type:string default:-- desc:办公地点 * @return name:business type:string default:-- desc:业务范围 */ public function getSupplierDetail() { $sel_where[] = ['id','=',input('get.id')]; $detail = \app\common\model\Supplier::where($sel_where)->find()->toArray(); $detail['label_name'] =$detail['label'] ? explode(',',trim($detail['label'],',')):null; $detail['business_arr'] = $detail['business'] ? explode(',',trim($detail['business'],',')) : null; UserTrack::crateTrack($this->user_id,9,input('get.id'),0); $this->success('ok',['detail'=>$detail]); } /** * @title 供应商产品推荐 * @desc 供应商产品推荐 * @author qc * @method GET * @url /api/Supplier/getRecommendList * @header name:Authorization require:1 desc:Token * @param name:page type:int default:0 desc:页数 * @param name:page_num type:int default:20 desc:每页数 * @param name:rand_user type:string default:-- desc:随机id(非登录状态必传,page=1时生成(a123),其他页数(a123),一直查询到没有数据) * @return name:id type:int default:-- desc:供应商产品d * @return name:name type:string default:-- desc:产品名称 * @return name:cover_arr type:array default:-- desc:封面 * @return name:label_name type:array default:-- desc:标签 * @return name:label type:string default:-- desc:标签 * @return name:supplier_name type:float default:-- desc:供应商名称 * @return name:supplier_logo type:string default:-- desc供应商logo * @return name:read_num type:int default:-- desc:浏览量 * @return name:release_time type:string default:-- desc:上架时间 * */ public function getRecommendList() { $user_id = $this->user_id ? $this->user_id : input('rand_user'); if(!$user_id) $this->error('参数错误'); $list = UserSynth::getRecommendList($user_id,'supplier',$this->page,$this->page_num,[],input('sort_type',1)); if($list['code'] != 200) $this->error($list['msg']); $this->success('ok',$list); $search_log = UserSearch::getSearchTitle($this->user_id,10); $search_arr = []; $where_str = 'b.id > 0'; foreach ($search_log as $t){ $search_arr[] = " b.name like '".'%'.$t."%'" .' '; $search_arr[] = " b.label like '".'%'.$t."%'" .' '; } if(!empty($search_arr)) $where_str = implode(' OR ',$search_arr); $field = 'a.id,a.supplier_id,a.name,a.label,a.cover,a.read_num,IFNULL(is_recommend,0) is_recommend ,k.title supplier_name,k.logo supplier_logo'; $table = 'dd_supplier_goods'; $order_by_two = 'a.read_num'; $sql = "SELECT $field FROM " .$table . " a LEFT JOIN ( SELECT id,IF(id,1,1) is_recommend FROM $table b WHERE ( $where_str )) AS c ON c.id = a.id LEFT JOIN dd_supplier as k ON a.supplier_id = k.id WHERE a.is_deleted = 0 AND a.status = 1 AND k.status =1 AND k.is_deleted = 0 ORDER BY is_recommend DESC , $order_by_two desc LIMIT {$this->off_set},{$this->page_num}"; $list = Db::query($sql); $list = dispose_recommend($list); array_walk($list,function (&$v,$k){ /* $supplier_info =\app\common\model\Supplier::where('id',$v['supplier_id'])->find()->toArray(); $v['supplier_name']=$supplier_info['title']; $v['supplier_logo'] =$supplier_info['logo'];*/ $v['read_num'] = numTransform($v['read_num']); $v['label_name'] = $v['label']? explode(',',trim($v['label'],',')) : null; $v['cover_arr'] = $v['cover']? explode('|',trim($v['cover'],'|')):null; }); $sql2 = "SELECT count(a.id) num FROM " .$table . " a LEFT JOIN ( SELECT id,IF(id,1,1) is_recommend FROM $table b WHERE ( $where_str )) AS c ON c.id = a.id LEFT JOIN dd_supplier as k ON a.supplier_id = k.id WHERE a.is_deleted = 0 AND a.status = 1 AND k.status =1 AND k.is_deleted = 0 "; $total = Db::query($sql2); $this->success('ok',['list'=>$list,'total_count'=>$total[0]['num'],'page_num'=>$this->page_num]); } /** * @title 合集列表--【按分类查询】 * @desc 按供应商查询 * @author qc * @method GET * @url /api/Supplier/getGoodsListByClassify * @header name:Authorization require:1 desc:Token * @param name:third_classify type:int default:-- desc:分类id【第三级】 * @param name:sort_type type:int default:1 desc:1默认2时间升序3时间降序 * @return name:name type:string default:-- desc:名称 * @return name:supplier_name type:string default:-- desc:供应商名称 * @return name:supplier_logo type:string default:-- desc供应商logo * @return name:cover type:string default:-- desc:图片【多张|隔开】 * @return name:cover_arr type:array default:-- desc:图片数组 * @return name:label_name type:array default:-- desc:标签 * @return name:release_time type:string default:-- desc:上架时间 * @return name:total_num type:array default:-- desc:总数 * */ public function getGoodsListByClassify() { $third_classify = input('get.third_classify'); $sel_where = []; $sel_where[] = ['g.is_deleted','=',0]; $sel_where[] = ['g.status','=',1]; $sel_where[] = ['g.third_classify','=',$third_classify]; $sort_type = input('get.sort_type',1); switch ($sort_type) { case 1: $order = ['g.sort'=>'desc','g.id'=>'desc']; break; case 2: $order = ['g.id'=>'asc']; break; case 3: $order = ['g.id'=>'desc']; break; } $list = SupplierGoods::where($sel_where) ->alias('g') ->field('g.id,g.label,g.cover,g.name,g.read_num,s.title supplier_name,s.logo supplier_logo,release_time') ->leftJoin('Supplier s','s.id = g.supplier_id') ->order($order) ->select()->toArray(); foreach ($list as &$v) { $v['label_name'] =$v['label'] ? explode(',',trim($v['label'],',')):null; $v['cover_arr'] =$v['cover'] ? explode('|',trim($v['cover'])):null; } $total_num = SupplierGoods::where($sel_where)->alias('g')->count(); $this->success('ok',['list'=>$list,'total_num'=>numTransform($total_num),'total_count'=>$total_num,'page_num'=>$this->page_num]); } /** * @title 合集列表--【按供应商查询】 * @desc 按供应商查询 * @author qc * @method GET * @url /api/Supplier/getSupplierGoodsList * @header name:Authorization require:1 desc:Token * @param name:supplier_id type:int default:-- desc:供应商记录id * @param name:sort_type type:int default:1 desc:1默认2时间升序3时间降序 * @return name:name type:string default:-- desc:名称 * @return name:supplier_name type:string default:-- desc:供应商名称 * @return name:supplier_logo type:string default:-- desc供应商logo * @return name:cover type:string default:-- desc:图片【多张|隔开】 * @return name:cover_arr type:array default:-- desc:图片数组 * @return name:label_name type:array default:-- desc:标签 * @return name:release_time type:string default:-- desc:上架时间 * @return name:is_recently type:int default:-- desc:是否最近观看【0否1是】 * @return name:supplier_info type:array default:-- desc:供应商信息 * @return name:supplier_info.id type:int default:-- desc:供应商id * @return name:supplier_info.title type:int default:-- desc:名称 * @return name:supplier_info.follow_switch type:int default:-- desc:订阅开关状态【0关闭1开启】 * */ public function getSupplierGoodsList() { $supplier_id = input('get.supplier_id'); $sort_type = input('get.sort_type',1); switch ($sort_type) { case 1: $order = ['sort'=>'desc','read_num'=>'desc','id'=>'asc']; break; case 2: $order = ['id'=>'asc','sort'=>'desc']; break; case 3: $order = ['id'=>'desc','sort'=>'desc']; break; } $sel_where = []; $sel_where[] = ['is_deleted','=',0]; $sel_where[] = ['status','=',1]; $sel_where[] = ['supplier_id','=',$supplier_id]; $list = SupplierGoods::where($sel_where) ->field('id,name,label,cover,create_at,read_num,release_time') ->order($order)->select()->toArray(); $supplier_info = \app\common\model\Supplier::where('id',$supplier_id)->field('id,title,logo')->find()->toArray(); $supplier_info['follow_switch'] = PlatformSwitch::checkSwitch($this->user_id,$supplier_id,5); foreach ($list as &$v) { $v['label_name'] =$v['label'] ? explode(',',trim($v['label'],',')):null; $v['cover_arr'] =$v['cover'] ? explode('|',trim($v['cover'])):null; $v['read_num'] = numTransform($v['read_num']); $v['create_at'] = substr($v['create_at'],0,10); $recently_id = UserTrack::getRecentlyTrack($this->user_id,10,$v['id']); $v['is_recently'] = $recently_id ? 1:0; } $total_num = SupplierGoods::where($sel_where)->count(); $this->success('ok',['list'=>$list,'supplier_info'=>$supplier_info,'total_num'=>numTransform($total_num),'total_count'=>$total_num,'page_num'=>$this->page_num]); } /** * @title 产品详情--【ui是供应商详情】 * @desc 产品详情 * @author qc * @method GET * @url /api/Supplier/getSupplierGoodsDetail * @header name:Authorization require:1 desc:Token * @param name:goods_id type:int default:-- desc:供应商产品id * @return name:name type:string default:-- desc:名称 * @return name:cover type:string default:-- desc:图片【多张逗号隔开】 * @return name:cover_arr type:array default:-- desc:图片数组 * @return name:label_name type:array default:-- desc:标签 * @return name:content type:string default:-- desc:详情 * @return name:article_id type:int default:-- desc:关联图文id【单个id||系列id】 * @return name:article_item type:int default:-- desc:关联图文详情id【item_list.id】 * @return name:datum_id type:int default:-- desc:资料id【单个id||系列id】 * @return name:datum_item type:int default:-- desc:资料详情id【url_arr.id】 * @return name:video_id type:int default:-- desc:关联视频id【单个id||系列id】 * @return name:video_item type:int default:-- desc:关联视频详情id【video_arr.id】 * @return name:is_collect type:int default:-- desc:是否收藏 * @return name:collect_num type:int default:-- desc:收藏量 * @return name:comment_num type:int default:-- desc:评论量 * @return name:praise_num type:int default:-- desc:点赞量 * @return name:is_praise type:int default:-- desc:是否点赞 * @return name:transmit_num type:int default:-- desc:转发量 * @return name:release_time type:string default:-- desc:上架时间 * @return name:switch_open type:int default:-- desc:通知开关【0关闭1开启】 * @return name:article_jump type:int default:-- desc:关联图文是否能跳转【0不能跳转,1能跳转,验证是否vip】 * @return name:datum_jump type:int default:-- desc:关联资料是否能跳转【0不能跳转,1能跳转,验证是否vip】 * @return name:video_jump type:int default:-- desc:关联视频是否能跳转【0不能跳转,1能跳转,验证是否vip】 * @return name:supplier_info type:array default:-- desc:供应商详情 * @return name:supplier_info.title type:string default:-- desc:名称 * @return name:supplier_info.cover type:string default:-- desc:公司logo * @return name:supplier_info.phone type:string default:-- desc:电话 * @return name:supplier_info.email type:string default:-- desc:email * @return name:supplier_info.label_name type:array default:-- desc:标签 * @return name:supplier_info.content type:string default:-- desc:供应商详情 * @return name:supplier_info.create_at type:string default:-- desc:时间 * @return name:supplier_info.build_time type:string default:-- desc:成立时间 * @return name:supplier_info.work_place type:string default:-- desc:办公地点 * @return name:supplier_info.business type:string default:-- desc:业务范围 * @return name:supplier_info.follow_switch type:int default:-- desc:订阅开关状态【0关闭1开启】 */ public function getSupplierGoodsDetail() { $goods_id = input('get.goods_id'); $detail = SupplierGoods::where('id',$goods_id)->find()->toArray(); $detail['label_name'] =$detail['label'] ? explode(',',trim($detail['label'],',')):null; $detail['is_collect'] = UserCollect::checkCollectByType($this->user_id,9,$detail['id']); $detail['collect_num'] = UserCollect::getCollectNum(9,$detail['id']); $detail['is_praise'] = PlatformLike::checkTags($this->user_id,$detail['id'],7); $detail['praise_num'] = PlatformLike::getPraiseNum($detail['id'],7); $detail['read_num'] = numTransform($detail['read_num']); $detail['transmit_num'] = numTransform($detail['transmit_num']); $detail['comment_num'] = SupplierComment::getCommentNum($detail['id']); $detail['video_vip'] = numTransform($detail['transmit_num']); $detail['article_jump'] = ArticleItem::checkVip($detail['article_item'],$this->user_id); $detail['datum_jump'] = DatumUrl::checkVip($detail['datum_item'],$this->user_id); $detail['video_jump'] = VideoUrl::checkVip($detail['video_item'],$this->user_id); $detail['switch_open'] = PlatformSwitch::checkSwitch($this->user_id,$detail['id'],11); $supplier_info = \app\common\model\Supplier::where('id',$detail['supplier_id'])->find(); if($supplier_info){ $supplier_info['label_name'] =$supplier_info['label'] ? explode(',',trim($supplier_info['label'],',')):null; $supplier_info['business_arr'] = $supplier_info['business'] ? explode(',',trim($supplier_info['business'],',')) : null; $supplier_info['cover'] = $supplier_info['logo'] ; $supplier_info['follow_switch'] = PlatformSwitch::checkSwitch($this->user_id,$detail['supplier_id'],5); } UserTrack::crateTrack($this->user_id,10,$goods_id,0); SupplierGoods::where('id',$goods_id)->setInc('read_num'); if($this->user_id){ TopSearch::seIncHotNum($detail['id'],'supplier_goods'); } if($this->user_id){ $General = new General(); $General->label($detail['label']); } $this->success('ok',['detail'=>$detail,'supplier_info'=>$supplier_info]); } /** * @title 一级评论 * @desc 一级评论 * @author qc * @method POST * @url /api/Supplier/firstComment * @header name:Authorization require:1 desc:Token * @param name:goods_id type:int require:1 default:-- desc:问题的id * @param name:content type:string default:-- desc:内容 * @return name:name type:string default:-- desc:会员名称 * @return name:headimg type:string default:-- desc:会员头像 * @return name:content type:string default:-- desc:内容 * @return name:create_at type:string default:-- desc:时间 */ public function firstComment() { $goods_id = input('post.goods_id'); $content = input('post.content'); if (!$content) $this->error('请输入评论内容'); $goods_info = SupplierGoods::where('id',$goods_id)->find()->toArray(); if(!$goods_info['comment_switch']) $this->error('评论功能已关闭'); $send_user = $goods_info['user_id']; $res = SupplierComment::create([ 'user_id'=>$this->user_id, 'content'=>$content, 'goods_id'=>$goods_id, 'is_read' => $send_user == $this->user_id ? 1 : 0, 'source_read' => $send_user == $this->user_id ? 1 : 0, ]); $detail =SupplierComment::where('c.id',$res->id) ->alias('c')->field('c.id,c.content,c.user_id,c.create_at,u.name,u.headimg') ->leftJoin('store_member u','u.id = c.user_id') ->find()->toArray(); $user_info = $this->userInfo('name'); if($send_user && $this->user_id != $send_user) UserMessage:: sendUserMessage($send_user,'supplier',4,0,$this->user_id,$goods_id,$content); $this->success('评论成功',['detail'=>$detail]); } /** * @title 二级评论 * @desc 二级评论 * @author qc * @method POST * @url /api/Supplier/secondComment * @header name:Authorization require:1 desc:Token * @param name:id type:int default:1 desc:评论id * @param name:content type:string default:-- desc:内容 * @return name:name type:string default:-- desc:会员名称 * @return name:headimg type:string default:-- desc:会员头像 * @return name:content type:string default:-- desc:内容 * @return name:create_at type:string default:-- desc:时间 */ public function secondComment() { $content = input('post.content'); if (!$content) $this->error('请输入评论内容'); $comment = SupplierComment::where('id',input('post.id'))->find()->toArray(); if($comment['user_id'] != $this->user_id)UserMessage:: sendUserMessage($comment['user_id'],'supplier',3,0,$this->user_id,$comment['id'],$content); $goods_info = SupplierGoods::where('id',$comment['goods_id'])->find()->toArray(); if(!$goods_info['comment_switch']) $this->error('评论功能已关闭'); //if($goods_info['user_id'] && $goods_info['user_id'] != $this->user_id) UserMessage:: sendUserMessage($goods_info['user_id'],'supplier',4,0,$this->user_id,$comment['goods_id'],$content); unset($comment['id']); unset($comment['create_at']); unset($comment['to_deleted']); unset($comment['is_top']); unset($comment['is_deleted']); $comment['pid'] = input('post.id'); $comment['user_id'] = $this->user_id; $comment['content'] = $content; $comment['lev']++; $comment['is_read']= $this->user_id == $goods_info['user_id'] ? 1 :0 ; $comment['source_read'] = $this->user_id == $goods_info['user_id'] ? 1 :0 ; if(!$comment['source_id']) $comment['source_id'] = input('post.id'); $res = SupplierComment::create($comment); $detail = SupplierComment::where('c.id',$res->id)->alias('c')->field('c.id,c.content,c.create_at,u.name,u.headimg') ->leftJoin('store_member u','u.id = c.user_id')->find()->toArray(); $this->success('评论成功',['detail'=>$detail]); } /** * @title 获取评论列表 * @desc 获取评论列表 * @author qc * @method GET * @url /api/Supplier/getCommentList * @header name:Authorization require:1 desc:Token) * @param name:goods_id type:int default:-- desc:产品id * @param name:sort_type type:int default:1 desc:排序规则1最新2热点 * @param name:page type:int default:1 desc:页数 * @param name:page_num type:int default:20 desc:每页数 * @return name:name type:string default:-- desc:会员名称 * @return name:headimg type:string default:-- desc:会员头像 * @return name:content type:string default:-- desc:内容 * @return name:is_top type:int default:-- desc:是否置顶(0否1是) * @return name:is_deleted type:int default:-- desc:是否删除(大于0未删除状态) * @return name:parent type:array default:-- desc:评论上一级(数据同上【一维数组】) * @return name:children type:array default:-- desc:二级评论(数据同上【二维数组】) * @return name:like_num type:int default:-- desc:点赞数量 * @return name:is_like type:int default:-- desc:是否点赞(0否1是) * @return name:can_delete type:int default:-- desc:是否可以删除(0否1是) * @return name:total_num type:int default:-- desc:总评论数(仅一级) * */ public function getCommentList() { $where = []; $where[] = ['c.goods_id','=',input('get.goods_id')]; $where[] = ['c.is_deleted','=',0]; $user_id = $this->user_id; $sort_type= input('sort_type',1); switch ($sort_type) { case 1: $order = ['c.is_top'=>'desc','c.id'=>'desc','c.like_times'=>'desc']; break; case 2: $order = ['c.is_top'=>'desc','c.like_times'=>'desc','c.id'=>'asc']; break; } $list = SupplierComment::where($where) ->alias('c')->field('c.*,u.name,u.headimg') ->leftJoin('store_member u','u.id = c.user_id')->order($order) ->limit($this->off_set,$this->page_num) ->select()->toArray(); array_walk($list,function (&$val,$k)use($user_id){ /* $children = SupplierComment::where(['c.pid'=>$val['id']]) ->alias('c')->field('c.*,u.name,u.headimg') ->leftJoin('store_member u','u.id = c.user_id') ->order('c.is_top,c.id asc') ->select()->toArray();*/ $val['like_num'] = PlatformLike::where('like_id',$val['id'])->where('type',11)->count(); $val['like_num'] = numTransform($val['like_num']); // $val['children'] = $children; $val['is_like'] = PlatformLike::where(['like_id'=>$val['id'],'user_id'=>$user_id,'type'=>11])->count(); $parent = SupplierComment::where(['c.id'=>$val['pid']])->alias('c')->field('c.*,u.name,u.headimg')->leftJoin('store_member u','u.id = c.user_id')->find(); $val['parent'] = $parent ? $parent->toArray() : null; $val['parent_comment'] = $val['parent'] ; $val['can_delete'] = $val['user_id'] == $this->user_id ? 1 :0; }); $total_num = SupplierComment::where($where)->alias('c')->count(); $this->success('ok',['list'=>$list,'total_num'=>numTransform($total_num),'total_count'=>$total_num,'page_num'=>$this->page_num]); } /** * @title 供应商搜索列表 * @desc 供应商搜索列表 * @author qc * @method GET * @url /api/Supplier/searchGoods * @header name:Authorization require:1 desc:Token * @param name:search_name type:int default:-- desc:搜索名称 * @param name:page type:int default:0 desc:页数 * @param name:page_num type:int default:20 desc:每页数 * @param name:sort_type type:int default:1 desc:1默认2时间升序3时间降序 * * @return name:name type:string default:-- desc:名称 * @return name:supplier_name type:string default:-- desc:供应商名称 * @return name:cover type:string default:-- desc:图片【多张逗号隔开】 * @return name:cover_arr type:array default:-- desc:图片数组 * @return name:label_name type:array default:-- desc:标签 * @return name:content type:string default:-- desc:详情 * @return name:read_num type:int default:-- desc:浏览量 * @return name:article_id type:int default:-- desc:关联图文id【单个id||系列id】 * @return name:article_item type:int default:-- desc:关联图文详情id【item_list.id】 * @return name:datum_id type:int default:-- desc:资料id【单个id||系列id】 * @return name:datum_item type:int default:-- desc:资料详情id【url_arr.id】 * @return name:video_id type:int default:-- desc:关联视频id【单个id||系列id】 * @return name:video_item type:int default:-- desc:关联视频详情id【video_arr.id】 * @return name:supplier_name type:string default:-- desc:供应商名称 * @return name:supplier_logo type:string default:-- desc供应商logo * @return name:total_num type:array default:-- desc:总数 * */ public function searchGoods() { $search_name = input('get.search_name'); $sort_type = input('get.sort_type',1); switch ($sort_type) { case 1: $order = ['g.sort'=>'desc','read_num'=>'desc','g.id'=>'asc']; break; case 2: $order = ['g.id'=>'asc','g.sort'=>'desc']; break; case 3: $order = ['g.id'=>'desc','g.sort'=>'desc']; break; } $sel_where = []; $sel_where[] = ['g.is_deleted','=',0]; $sel_where[] = ['s.is_deleted','=',0]; $sel_where[] = ['g.status','=',1]; $sel_where[] = ['s.status','=',1]; if($search_name && $this->user_id) UserSearch::saveSearchTitle($this->user_id,$search_name,10); $list = SupplierGoods::where($sel_where) ->field('g.id,g.supplier_id,g.name,g.label,g.read_num,g.cover,s.title supplier_name,s.logo supplier_logo') ->when($search_name,function ($query)use($search_name){ if($search_name) $query->where('g.name|g.label','like','%'.$search_name.'%'); })->alias('g') ->leftJoin('Supplier s','g.supplier_id = s.id') ->order($order)->limit($this->off_set,$this->page_num)->select()->toArray(); foreach ($list as &$v) { $v['label_name'] =$v['label'] ? explode(',',trim($v['label'],',')):null; $v['cover_arr'] =$v['cover'] ? explode('|',trim($v['cover'])):null; $v['read_num'] = numTransform($v['read_num']); } $total_num = SupplierGoods::where($sel_where)->alias('g')->leftJoin('Supplier s','g.supplier_id = s.id')->when($search_name,function ($query)use($search_name){ if($search_name) $query->where('g.name|g.label','like','%'.$search_name.'%'); })->count(); $this->success('ok',['list'=>$list,'total_num'=>numTransform($total_num),'total_count'=>$total_num,'page_num'=>$this->page_num]); } /** * @title 点赞||取消点赞 * @desc 点赞||取消点赞 * @author qc * @method POST * @url /api/Supplier/supplierTags * @header name:Authorization require:1 desc:Token * @param name:id type:int default:1 desc:记录id【产品id或评论id】 * @param name:type type:int default:7 desc:7产品,11评论 * @return name:tags type:int default:1 desc:0取消成功,1点赞成功 */ public function supplierTags() { $type = input('post.type',7); $id = input('post.id'); $ret_val = PlatformLike::userTags($this->user_id,$id,$type); $this->success($ret_val == 1 ?'点赞成功':'取消成功',['tags'=>$ret_val]); } /** * @title 供应商产品收藏||取消收藏 * @desc 用户收藏 * @author qc * @method POST * @url /api/Supplier/supplierGoodsCollect * @header name:Authorization require:1 desc:Token * @param name:id type:int require:1 default:-- desc:供应商产品记录id * @param return:status type:int default:0 desc:收藏状态(0取消收藏【未收藏】,1收藏) */ public function supplierGoodsCollect(){ $coll_status = UserCollect::plateCollect($this->user_id,9,input('post.id',0)); $coll_status ? $this->success('收藏成功',['status'=>1]) : $this->success('取消收藏成功',['status'=>0]); } /** * @title 转发(转发数量统计【供应商】) * @desc 转发成功后调用 * @author qc * @method POST * @url /api/Supplier/supplierTransmit * @header name:Authorization require:1 desc:Token * @param name:id type:int default:-- desc:供应商记录id */ public function supplierTransmit() { $id = input('post.id',0); \app\common\model\Supplier::where('id',$id)->setInc('transmit_num'); $this->success('ok'); } /** * @title 转发(转发数量统计【供应商产品】) * @desc 转发成功后调用 * @author qc * @method POST * @url /api/Supplier/supplierGoodsTransmit * @header name:Authorization require:1 desc:Token * @param name:id type:int default:-- desc:供应商产品记录id */ public function supplierGoodsTransmit() { $id = input('post.id',0); SupplierGoods::where('id',$id)->setInc('transmit_num'); $this->success('ok'); } /** * @title 我的浏览历史【供应商产品】 * @desc 我的浏览历史 * @author qc * @method GET * @url /api/Supplier/getSupplierGoodsTrack * @header name:Authorization require:1 desc:Token * @param name:name type:string default:-- desc:产品名称 * @param name:page type:int default:-- desc:页数 * @param name:page_num type:int default:-- desc:每页数 * @return name:id type:string default:-- desc:浏览记录id * @return name:goods_id type:string default:-- desc:产品id * @return name:name type:string default:-- desc:产品名称 * @return name:cover type:string default:-- desc:封面(多张|隔开) * @return name:cover_arr type:array default:-- desc:封面 * @return name:label_name type:array default:-- desc:标签 * @return name:supplier_logo type:string default:-- desc:供应商名称 * @return name:supplier_name type:string default:-- desc:供应商名称 * @return name:time type:string default:-- desc:时间 * @return name:read_num type:string default:-- desc:浏览量 */ public function getSupplierGoodsTrack() { $sel_where = []; $sel_where[] = ['t.user_id','=',$this->user_id]; $sel_where[] = ['t.type','=',10]; $name = input('get.name'); if($name) $sel_where[] = ['i.name|i.label','like','%'.$name.'%']; $list = UserTrack::where($sel_where) ->alias('t') ->field('t.id,t.update_int,t.first_id goods_id,i.read_num,i.name,i.cover,i.label,supplier_id,s.logo supplier_logo,s.title supplier_name') ->leftJoin('SupplierGoods i','t.first_id = i.id') ->leftJoin('Supplier s','s.id = i.supplier_id') ->order('update_int desc') ->limit($this->off_set,$this->page_num) ->select()->toArray(); foreach ($list as &$v) { $v['time'] = date("Y-m-d",$v['update_int']); $v['cover_arr'] = $v['cover']? explode('|',$v['cover']) : null; $v['label_name'] = $v['label']? explode(',',trim($v['label'],',')) : null; $v['read_num'] = numTransform($v['read_num']); $v['is_normal'] = CheckPower::checkModulesPower($v['goods_id'],0,'supplier_goods'); } $total_num =UserTrack::where($sel_where)->alias('t')->leftJoin('SupplierGoods i','t.first_id = i.id')->count(); $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]); } /** * @title 我的点赞--产品 * @desc 供应商产品点赞列表 * @author qc * @method GET * @url /api/Supplier/getTagsSupplierGoods * @header name:Authorization require:1 desc:Token * @param name:name type:string default:-- desc:产品名称 * @param name:page type:int default:-- desc:页数 * @param name:page_num type:int default:-- desc:每页数 * @return name:id type:string default:-- desc:浏览记录id * @return name:goods_id type:string default:-- desc:产品id * @return name:name type:string default:-- desc:名称 * @return name:cover type:string default:-- desc:封面(多张|隔开) * @return name:cover_arr type:array default:-- desc:封面 * @return name:label_name type:array default:-- desc:标签 * @return name:supplier_name type:string default:-- desc:供应商名称 * @return name:supplier_logo type:string default:-- desc:供应商logo * @return name:create_at type:string default:-- desc:时间 * @return name:transmit_num type:string default:-- desc:转发量 * @return name:comment_num type:string default:-- desc:评论量 * @return name:praise_num type:int default:-- desc:点赞量 * @return name:read_num type:int default:-- desc:阅读量 * @return name:collect_num type:int default:-- desc:收藏量 * @return name:is_collect type:int default:-- desc:是否收藏 * @return name:switch_open type:int default:-- desc:通知开关【0关闭1开启】 */ public function getTagsSupplierGoods() { $sel_where = []; $name = input('get.name'); if($name) $sel_where[] = ['i.name|i.label','like','%'.$name.'%']; $sel_where[] = ['t.user_id','=',$this->user_id]; $sel_where[] = ['t.type','=',7]; $list = PlatformLike::where($sel_where)->alias('t') ->field('t.id,t.create_at,t.like_id goods_id,i.transmit_num,i.name,i.cover,supplier_id,s.title supplier_name,s.logo supplier_logo,i.read_num') ->leftJoin('SupplierGoods i','t.like_id = i.id') ->leftJoin('Supplier s','s.id = i.supplier_id') ->order('id desc') ->limit($this->off_set,$this->page_num) ->select()->toArray(); foreach ($list as &$v) { $v['cover_arr'] = explode('|',$v['cover']); $v['is_normal'] = CheckPower::checkModulesPower($v['goods_id'],0,'supplier_goods'); $v['transmit_num'] = numTransform($v['transmit_num']); $v['read_num'] = numTransform($v['read_num']); $v['comment_num'] = SupplierComment::getCommentNum($v['goods_id']); $v['praise_num'] = PlatformLike::getPraiseNum($v['goods_id'],7); $v['collect_num'] =UserCollect::getCollectNum(9,$v['goods_id']); $v['is_collect'] = UserCollect::checkCollectByType($this->user_id,9,$v['goods_id']); $v['switch_open'] = PlatformSwitch::checkSwitch($this->user_id,$v['goods_id'],11); } $total_num = PlatformLike::where($sel_where)->alias('t')->leftJoin('SupplierGoods i','t.like_id = i.id')->count(); $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]); } /** * @title 我的点赞--评论 * @desc 评论点赞列表 * @author qc * @method GET * @url /api/Supplier/getTagsComment * @header name:Authorization require:1 desc:Token * @param name:page type:int default:0 desc:页数 * @param name:page_num type:int default:20 desc:每页数 * @return name:create_at type:string default:-- desc:时间 * @return name:user_name type:string default:-- desc:会员名称 * @return name:headimg type:string default:-- desc:会员头像 * @return name:content type:string default:-- desc:评论内容 * @return name:cover type:string default:-- desc:封面 * @return name:ali_vid type:string default:-- desc:云点播id * @return name:read_num type:string default:-- desc:浏览量 * @return name:supplier_name type:string default:-- desc:供应商名称 * @return name:supplier_logo type:string default:-- desc:供应商logo * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情) */ public function getTagsComment() { $list = PlatformLike::field('l.id,c.goods_id,c.content,c.id as like_id,g.read_num,g.name,g.cover,u.name user_name,u.headimg,s.title supplier_name,s.logo supplier_logo') ->alias('l') ->where(['l.user_id'=>$this->user_id,'l.type'=>11]) ->where('c.user_id','<>',$this->user_id) ->leftJoin('SupplierComment c','l.like_id = c.id') ->leftJoin('SupplierGoods g','g.id = c.goods_id') ->leftJoin('Supplier s','s.id = g.supplier_id') ->leftJoin('store_member u','u.id = c.user_id') ->order('l.id desc') ->limit($this->off_set,$this->page_num) ->select()->toArray(); array_walk($list,function (&$v){ $v['read_num'] = numTransform($v['read_num']); $v['cover_arr'] = explode('|',$v['cover']); $v['is_normal'] = CheckPower::checkModulesPower($v['goods_id'],0,$this->request->controller()); }); $total_num = PlatformLike::alias('l')->where(['l.user_id'=>$this->user_id,'l.type'=>11]) ->where('c.user_id','<>',$this->user_id) ->leftJoin('SupplierComment c','l.like_id = c.id')->count(); $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]); } /** * @title 我的收藏【供应商产品收藏列表】 * @desc 供应商产品收藏列表 * @author qc * @method GET * @url /api/Supplier/getCollectSupplierGoods * @header name:Authorization require:1 desc:Token * @param name:name type:string default:-- desc:产品名称 * @param name:page type:int default:-- desc:页数 * @param name:page_num type:int default:-- desc:每页数 * * @return name:goods_id type:string default:-- desc:产品id * @return name:name type:string default:-- desc:名称 * @return name:cover type:string default:-- desc:封面(多张|隔开) * @return name:cover_arr type:array default:-- desc:封面 * @return name:label_name type:array default:-- desc:标签 * @return name:supplier_name type:string default:-- desc:供应商名称 * @return name:supplier_logo type:string default:-- desc:供应商logo * @return name:create_at type:string default:-- desc:时间 * @return name:transmit_num type:string default:-- desc:转发量 * @return name:comment_num type:string default:-- desc:评论量 * @return name:praise_num type:int default:-- desc:点赞量 * @return name:is_praise type:int default:-- desc:是否点赞 * @return name:collect_num type:int default:-- desc:收藏量 * @return name:switch_open type:int default:-- desc:通知开关【0关闭1开启】 */ public function getCollectSupplierGoods() { $sel_where = []; $name = input('get.name'); if($name) $sel_where[] = ['i.name','like','%'.$name.'%']; $sel_where[] = ['t.user_id','=',$this->user_id]; $sel_where[] = ['t.coll_type','=',9]; $list = UserCollect::where($sel_where)->alias('t') ->field('t.id,t.create_at,t.coll_id goods_id,i.read_num,i.transmit_num,i.name,i.cover,i.label,i.supplier_id,s.logo supplier_logo ,s.title supplier_name') ->leftJoin('SupplierGoods i','t.coll_id = i.id') ->leftJoin('Supplier s','s.id = i.supplier_id') ->order('id desc') ->limit($this->off_set,$this->page_num) ->select()->toArray(); foreach ($list as &$v) { $v['cover_arr'] = explode('|',$v['cover']); $v['label_name'] = explode(',',$v['label']); $v['read_num'] = numTransform($v['read_num']); $v['transmit_num'] = numTransform($v['transmit_num']); $v['comment_num'] = SupplierComment::getCommentNum($v['goods_id']); $v['is_praise'] = PlatformLike::checkTags($this->user_id,$v['goods_id'],7); $v['is_normal'] = CheckPower::checkModulesPower($v['goods_id'],0,$this->request->controller()); $v['switch_open'] = PlatformSwitch::checkSwitch($this->user_id,$v['goods_id'],11); $v['collect_num'] = UserCollect::getCollectNum(9,$v['goods_id']); $v['praise_num'] = PlatformLike::getPraiseNum($v['goods_id'],7); } $total_num= UserCollect::where($sel_where)->alias('t') ->leftJoin('SupplierGoods i','t.coll_id = i.id')->count(); $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]); } /** * @title 我的订阅--供应商 * @desc 供应商 * @author qc * @method GET * @url /api/Supplier/getFollowUpList * @header name:Authorization require:1 desc:Token * @param name:title type:string default:-- desc:搜索关键字 * @param name:page type:int default:0 desc:页数 * @param name:page_num type:int default:20 desc:每页数 * @return name:create_at type:string default:-- desc:时间 * @return name:title type:string default:-- desc:供应商标题 * @return name:goods_num type:int default:-- desc:商品数量 * @return name:supplier_id type:int default:-- desc:供应商id * @return name:supplier_name type:string default:-- desc:供应商名称 * @return name:supplier_logo type:string default:-- desc:供应商logo * @return name:recently_title type:string default:-- desc:上次观看商品 */ public function getFollowUpList() { $sel_where = []; $sel_where[] = ['p.user_id','=',$this->user_id]; $sel_where[] = ['p.type','=',5]; $sel_where[] = ['p.switch_value','=',1]; $field = 'p.id,p.switch_id as supplier_id,p.create_at,a.title,a.logo supplier_logo,a.title supplier_name'; $list = PlatformSwitch::field($field)->alias('p') ->leftJoin('Supplier a','p.switch_id = a.id') ->where($sel_where)->limit($this->off_set,$this->page_num)->order('p.id desc') ->select()->toArray(); array_walk($list,function (&$v){ $v['goods_num'] = SupplierGoods::getGoodsNum($v['supplier_id']); $v['recently_title'] = UserTrack::getRecentlyGoodsName($this->user_id,$v['supplier_id']); }); $total_num= PlatformSwitch::where($sel_where)->alias('p')->leftJoin('Supplier a','p.switch_id = a.id')->count(); $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]); } /** * @title 我的订阅消息 * @desc 我的订阅消息 * @author qc * @method GET * @url /api/Supplier/getFollowUpMessage * @header name:Authorization require:1 desc:Token * @param name:title type:int default:-- desc:搜索内容 * @param name:page type:int default:-- desc:页数 * @param name:page_num type:int default:-- desc:每页数 * @return name:id type:int default:-- desc:记录id * @return name:title type:string default:-- desc:标题 * @return name:content type:string default:-- desc:内容 * @return name:create_at type:string default:-- desc:时间 * @return name:is_read type:int default:-- desc:是否已读【0否1是】 * @return name:supplier_id type:int default:-- desc:供应商id * @return name:goods_id type:int default:-- desc:产品id */ public function getFollowUpMessage() { $title = input('title'); $list = UserMessage::where(['m.user_id'=>$this->user_id,'m.is_deleted'=>0,'m.module'=>'supplier','m.type_id'=>5]) ->alias('m') ->when($title,function ($query)use ($title){ if($title) $query->where('m.content','like','%'.$title.'%');}) ->field('m.id,v.create_at,m.title,m.is_read,m.children_id goods_id,m.content,m.relation_id supplier_id,m.module,v.title supplier_name') ->leftJoin('Supplier v','v.id= m.relation_id') ->limit($this->off_set,$this->page_num) ->order(['m.id'=>'desc']) ->select()->toArray(); $total_num = UserMessage::where(['m.user_id'=>$this->user_id,'m.is_deleted'=>0,'m.module'=>'supplier','m.type_id'=>5])->alias('m')->leftJoin('Supplier v','v.id= m.relation_id')->count(); $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]); } /** * @title 点赞我的--产品 * @desc 点赞我的--产品 * @author qc * @method GET * @url /api/Supplier/praiseGoodsList * @header name:Authorization require:1 desc:Token * @param name:page type:int default:-- desc:页数 * @param name:page_num type:int default:-- desc:每页数 * @return name:id type:int default:-- desc:记录id * @return name:name type:string default:-- desc:产品 * @return name:create_at type:string default:-- desc:时间 * @return name:user_name type:string default:-- desc:会员名称 * @return name:headimg type:string default:-- desc:会员头像 * @return name:supplier_logo type:string default:-- desc:供应商logo * @return name:supplier_name type:string default:-- desc:供应商名称 * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情) */ public function praiseGoodsList() { $sel_where = []; $sel_where[] = ['p.type', '=', 7]; $sel_where[] = ['g.user_id', '=', $this->user_id]; $sel_where[] = ['p.to_deleted', '=', 0]; $list = PlatformLike::where($sel_where) ->field('p.*,g.id goods_id,g.name,g.read_num,u.name user_name,u.headimg,s.logo supplier_logo ,s.title supplier_name,g.cover')->alias('p') ->leftJoin('SupplierGoods g', 'g.id = p.like_id') ->leftJoin('Supplier s', 's.id = g.supplier_id') ->leftJoin('StoreMember u', 'u.id = p.user_id') ->order('p.id desc') ->limit($this->off_set,$this->page_num) ->select()->toArray(); array_walk($list,function (&$v){ $v['read_num'] = numTransform($v['read_num']); $v['cover_arr'] = $v['cover']? explode('|',trim($v['cover'],'|')):null; $v['is_normal'] = CheckPower::checkModulesPower($v['goods_id'],0,$this->request->controller()); }); $total_num = PlatformLike::where($sel_where)->alias('p') ->leftJoin('SupplierGoods g', 'g.id = p.like_id') ->leftJoin('Supplier s', 's.id = g.supplier_id') ->leftJoin('StoreMember u', 'u.id = p.user_id') ->count(); $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]); } /** * @title 点赞我的--评论 * @desc 点赞我的 * @author qc * @method GET * @url /api/Supplier/praiseCommentList * @header name:Authorization require:1 desc:Token * @param name:page type:int default:-- desc:页数 * @param name:page_num type:int default:-- desc:每页数 * @return name:id type:int default:-- desc:记录id * @return name:name type:string default:-- desc:产品 * @return name:create_at type:string default:-- desc:时间 * @return name:user_name type:string default:-- desc:会员名称 * @return name:headimg type:string default:-- desc:会员头像 * @return name:content type:string default:-- desc:评论内容 * @return name:supplier_logo type:string default:-- desc:供应商logo * @return name:supplier_name type:string default:-- desc:供应商名称 * @return name:cover_arr type:array default:-- desc:图片 * @return name:goods_id type:int default:-- desc:产品id * @return name:self_name type:string default:-- desc:自己昵称 * @return name:is_deleted type:int default:-- desc:评论是否删除(0未删除,1,2已删除) * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情) */ public function praiseCommentList() { $sel_where = []; $sel_where[] = ['p.type', '=', 11]; $sel_where[] = ['c.user_id', '=', $this->user_id]; $sel_where[] = ['p.to_deleted', '=', 0]; $list = PlatformLike::where($sel_where) ->alias('p') ->field('p.*,c.content,c.is_deleted,g.read_num,c.goods_id,u.name user_name,u.headimg,s.logo supplier_logo ,s.title supplier_name,g.cover,g.name') ->leftJoin('SupplierComment c', 'c.id = p.like_id') ->leftJoin('SupplierGoods g', 'g.id = c.goods_id') ->leftJoin('Supplier s', 's.id = g.supplier_id') ->leftJoin('StoreMember u', 'u.id = p.user_id') ->order('p.id desc') ->limit($this->off_set,$this->page_num) ->select()->toArray(); array_walk($list,function (&$v){ $v['self_name'] = $this->user_info['name']; $v['read_num'] = numTransform($v['read_num']); $v['cover_arr'] = $v['cover']? explode('|',trim($v['cover'],'|')):null; $v['is_normal'] = CheckPower::checkModulesPower($v['goods_id'],0,$this->request->controller()); }); $total_num = PlatformLike::where($sel_where) ->alias('p')->leftJoin('SupplierComment c', 'c.id = p.like_id') ->leftJoin('SupplierGoods g', 'g.id = c.goods_id') ->leftJoin('Supplier s', 's.id = g.supplier_id') ->leftJoin('StoreMember u', 'u.id = p.user_id')->count(); $this->success('ok', ['list' => $list, 'total_count' => $total_num, 'page_num' => $this->page_num]); } /** * @title 我的发布 * @desc 我的发布 * @author qc * @method GET * @url /api/Supplier/getMyGoodsList * @header name:Authorization require:1 desc:Token * @param name:page type:int default:-- desc:页数 * @param name:page_num type:int default:-- desc:每页数 * @param name:title type:string default:-- desc:关键词 * @return name:id type:int default:-- desc:产品id * @return name:name type:string default:-- desc:产品 * @return name:create_at type:string default:-- desc:时间 * @return name:supplier_logo type:string default:-- desc:供应商logo * @return name:supplier_name type:string default:-- desc:供应商名称 * @return name:cover_arr type:array default:-- desc:图片 */ public function getMyGoodsList() { $where = []; $where[] = ['user_id','=',$this->user_id]; $where[] = ['is_deleted','=',0]; $where[] = ['status','=',1]; $title = input('get.title'); if ($title) $where[] = ['name', 'like', '%' . $title . '%']; $list = SupplierGoods::where($where) ->field('id,name,create_at,label,cover,read_num') ->order('id desc') ->limit($this->off_set,$this->page_num) ->select()->toArray(); array_walk($list,function (&$v){ $v['label_name'] =$v['label'] ? explode(',',trim($v['label'],',')):null; $v['cover_arr'] = $v['cover']? explode('|',trim($v['cover'],'|')):null; }); $total_num = SupplierGoods::where($where)->count(); $this->success('ok', ['list' => $list, 'total_count' => $total_num, 'page_num' => $this->page_num]); } /** * @title 评论我的 * @desc 评论我的 * @author qc * @method GET * @url /api/Supplier/commentOnMyGoods * @header name:Authorization require:1 desc:Token * @param name:title type:string default:-- desc:关键字 * @param name:page type:int default:-- desc:页数 * @param name:page_num type:int default:-- desc:每页数量 * @return name:create_at type:string default:-- desc:时间 * @return name:content type:string default:0 desc:评论内容 * @return name:user_name type:string default:-- desc:评论用户 * @return name:headimg type:string default:-- desc:评论用户头像 * @return name:is_deleted type:int default:-- desc:是否删除(0否1是) * @return name:is_read type:int default:-- desc:是否已读(0未读1已读) * @return name:is_top type:int default:-- desc:是否置顶(0否1是) * @return name:cover_arr type:array default:-- desc:图片 * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情) */ public function commentOnMyGoods() { $where = []; $where[] = ['g.user_id', '=', $this->user_id]; $where[] = ['c.is_deleted', '=', 0]; $where[] = ['c.user_id', '<>', $this->user_id]; $where[] = ['c.to_deleted', '=', 0]; $where[] = ['c.pid','=',0]; if ($title = input('title')) $where[] = ['c.content', 'like', '%' . $title . '%']; $list = SupplierComment::field('c.*,m.name user_name,m.headimg,g.name,s.logo supplier_logo ,s.title supplier_name,g.cover,g.read_num') ->alias('c')->where($where) ->leftJoin('store_member m', 'm.id = c.user_id') ->leftJoin('SupplierGoods g', 'g.id = c.goods_id') ->leftJoin('Supplier s', 's.id = g.supplier_id') ->order('c.is_top desc,c.id desc') ->limit($this->off_set, $this->page_num) ->select()->toArray(); array_walk($list, function (&$v) { // $v['is_read'] = $v['source_read']; $v['is_normal'] = CheckPower::checkModulesPower($v['goods_id'], 0, 'supplier_goods'); $v['cover_arr'] = $v['cover']? explode('|',trim($v['cover'],'|')):null; $v['read_num'] = numTransform($v['read_num']); }); $total_num = SupplierComment::where($where)->alias('c') ->leftJoin('store_member m', 'm.id = c.user_id') ->leftJoin('SupplierGoods g', 'g.id = c.goods_id') ->leftJoin('Supplier s', 's.id = g.supplier_id')->count(); $this->success('ok', ['list' => $list, 'total_count' => $total_num, 'page_num' => $this->page_num]); } /** * @title 回复我的 * @desc 回复我的 * @author qc * @method GET * @url /api/Supplier/getReplayComment * @header name:Authorization require:1 desc:Token * @param name:title type:string default:-- desc:标题 * @param name:page type:int default:0 desc:页数 * @param name:page_num type:int default:20 desc:每页数 * @return name:id type:int default:-- desc:记录id * @return name:title type:string default:-- desc:问题标题 * @return name:create_at type:string default:-- desc:时间 * @return name:is_deleted type:int default:-- desc:回复内容是被删除【0否】 * @return name:user_name type:string default:-- desc:用户名【其他会员】 * @return name:headimg type:string default:-- desc:用户头像【其他会员】 * @return name:content type:string default:-- desc:回复内容 * @return name:is_read type:int default:-- desc:是否已读(0未读1已读) * @return name:is_top type:int default:-- desc:是否置顶(0否1是) * @return name:self_name type:string default:-- desc:自己昵称 * @return name:parent_comment type:array default:-- desc:你的评论内容【阴影部分】 * @return name:parent_comment.content type:string default:-- desc:内容 * @return name:parent_comment.is_normal type:int default:-- desc:能否跳转(0已删除或是已禁用1可以正常跳转详情) * @return name:parent_comment.is_deleted type:int default:-- desc:被评论的内容是否删除 * @return name:parent_comment.read_num type:string default:-- desc:阅读量 * @return name:parent_comment.goods_name type:string default:-- desc:产品名称 * @return name:parent_comment.name type:string default:-- desc:你的会员名称 * @return name:parent_comment.headimg type:string default:-- desc:你的头像 * @return name:parent_comment.show_title type:string default:-- desc:展示的问题标题或答案内容 * @return name:parent_comment.reply_id type:int default:-- desc:答案id【值为0是问题类型,大于0是答案类型】 * */ public function getReplayComment() { $all_comment = SupplierComment::where(['user_id'=> $this->user_id, 'is_deleted' => 0])->column('id'); if (empty($all_comment)) $this->success('ok', ['list' => null]); $sel_where = []; $title = input('get.title'); if ($title) $sel_where[] = ['t.content', 'like', '%' . $title . '%']; $sel_where[] = ['t.to_deleted', '=', 0]; $sel_where[] = ['t.user_id','<>',$this->user_id]; $sel_where[] = ['t.pid', 'in', implode(',', $all_comment)]; $list = SupplierComment::where($sel_where) ->alias('t') ->field('t.id,t.is_top,t.create_at,t.is_read,t.content,t.is_deleted,t.pid,goods_id,u.name user_name,u.headimg') ->leftJoin('store_member u', 't.user_id = u.id') ->order('t.is_top desc,t.id desc') ->limit($this->off_set, $this->page_num) ->select()->toArray(); array_walk($list,function (&$v){ $v['self_name'] = $this->user_info['name']; $parent_comment = SupplierComment::where([['t.id', '=', $v['pid']]]) ->alias('t') ->field('t.id,t.content,t.is_deleted,i.read_num,goods_id,i.name goods_name,s.logo supplier_logo ,s.title supplier_name,i.cover,u.name,u.headimg') ->leftJoin('store_member u', 't.user_id = u.id') ->leftJoin('SupplierGoods i', 't.goods_id = i.id') ->leftJoin('Supplier s', 'i.supplier_id = s.id') ->find()->toArray(); $parent_comment['cover_arr'] = $parent_comment['cover']? explode('|',trim($parent_comment['cover'],'|')):null; $parent_comment['read_num'] = numTransform($parent_comment['read_num']); $parent_comment['is_normal'] =CheckPower::checkModulesPower($parent_comment['goods_id'], 0, 'supplier'); $v['parent_comment'] = $parent_comment; }); $total_num = SupplierComment::where($sel_where)->alias('t') ->leftJoin('store_member u', 't.user_id = u.id') ->count(); $this->success('ok', ['list' => $list, 'total_count' => $total_num, 'page_num' => $this->page_num]); } /** * @title 获取角标数量 * @desc 获取角标数量 * @author qc * @method GET * @url /api/Supplier/getMarkNum * @header name:Authorization require:1 desc:Token * @return name:comment_num type:int default:-- desc:评论我的【总数量】 * @return name:reply_num type:int default:-- desc:回复我的【总数量】 * @return name:follow_num type:int default:-- desc:订阅 * @return name:praise_num type:int default:-- desc:点赞我的【包含产品点赞和评论点赞】 * @return name:total_num type:int default:-- desc:总数【comment_num+reply_num+follow_num】 */ public function getMarkNum() { // 评论我的 $comment_num = SupplierComment::where([['g.user_id', '=', $this->user_id],['c.is_deleted', '=', 0],['c.to_deleted', '=', 0],['c.is_read','=',0],['c.pid','=',0]]) ->alias('c') ->leftJoin('SupplierGoods g', 'g.id = c.goods_id')->count(); //回复我的 $all_comment = SupplierComment::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id'); $reply_num = $all_comment ? SupplierComment::where([['t.is_deleted','=',0],['t.to_deleted','=',0],['t.user_id','<>',$this->user_id],['t.is_read','=',0],['t.pid','in',implode(',',$all_comment)]])->alias('t')->count() :0; //订阅 $follow_num = UserMessage::getUnreadNum($this->user_id,'supplier',5); $total_num = $comment_num + $reply_num + $follow_num; $praise_supplier = PlatformLike::where([['p.type', '=', 7],['f.user_id', '=', $this->user_id],['p.to_deleted', '=', 0],['p.is_read','=',0]])->alias('p') ->leftJoin('SupplierGoods f', 'f.id = p.like_id')->count(); $praise_comment = PlatformLike::where([['p.type', '=', 11],['c.user_id', '=', $this->user_id],['p.to_deleted', '=', 0],['p.is_read','=',0]])->alias('p')->leftJoin('SupplierComment c', 'c.id = p.like_id')->count(); $praise_num = $praise_supplier + $praise_comment; $this->success('ok', compact([ 'comment_num','reply_num','follow_num','praise_num','total_num'])); } /** * @title 我的回复【我的回复--我回复过的评论】 * @desc 我的回复 * @author qc * @method GET * @url /api/Supplier/getReplyComment * @header name:Authorization require:1 desc:Token * @param name:title type:string default:-- desc:标题 * @param name:page type:int default:0 desc:页数 * @param name:page_num type:int default:20 desc:每页数 * @return name:create_at type:string default:-- desc:时间 * @return name:content type:string default:-- desc:回复内容 * @return name:user_name type:string default:-- desc:用户名【用户自己的】 * @return name:headimg type:string default:-- desc:用户头像【用户自己的】 * * @return name:parent_comment type:array default:-- desc:上级评论内容【阴影部分--你回复的那个】 * @return name:parent_comment.content type:string default:-- desc:内容 * @return name:parent_comment.goods_name type:string default:-- desc:产品名称 * @return name:parent_comment.name type:string default:-- desc:会员名称【别人的】 * @return name:parent_comment.headimg type:string default:-- desc:会员头像【别人的】 * @return name:parent_comment.title type:string default:-- desc:标题 * @return name:parent_comment.goods_id type:int default:-- desc:商品id * @return name:parent_comment.supplier_logo type:string default:-- desc:供应商logo * @return name:parent_comment.supplier_name type:string default:-- desc:供应商名称 * @return name:parent_comment.is_deleted type:int default:-- desc:评论删除状态(0未删除) * @return name:parent_comment.is_normal type:int default:-- desc:产品状态 * @return name:parent_comment.cover_arr type:array default:-- desc:产品封面 * @return name:parent_comment.read_num type:string default:-- desc:浏览量 */ public function getReplyComment() { $sel_where = []; $title = input('get.title'); if($title) $sel_where[] = ['t.content','like','%'.$title.'%']; $sel_where[] = ['t.user_id', '=', $this->user_id]; // $sel_where[] = ['c.user_id', '<>', $this->user_id]; $sel_where[] = ['t.to_deleted', '=', 0]; $sel_where[] = ['t.pid', '>', 0]; $list = SupplierComment::where($sel_where)->alias('t') ->field('t.id,t.is_top,t.create_at,t.content,t.pid,t.goods_id,t.is_deleted') ->leftJoin('SupplierComment c', 'c.id = t.pid') ->order('t.id desc') ->limit($this->off_set, $this->page_num) ->select()->toArray(); array_walk($list,function (&$v){ $v['user_name'] = $this->user_info['name']; $v['headimg'] = $this->user_info['headimg']; $parent_comment = SupplierComment::where([['t.id', '=', $v['pid']]]) ->field('t.id,t.content,t.pid,t.goods_id,u.name,u.headimg,i.name goods_name,i.read_num,i.cover,i.is_deleted,s.logo supplier_logo ,s.title supplier_name') ->alias('t')->leftJoin('SupplierGoods i', 't.goods_id = i.id') ->leftJoin('Supplier s', 'i.supplier_id = s.id') ->leftJoin('store_member u', 't.user_id = u.id') ->find()->toArray(); $parent_comment['is_normal'] = CheckPower::checkModulesPower($v['goods_id'],0,$this->request->controller()); $parent_comment['read_num'] = numTransform($parent_comment['read_num']); $parent_comment['cover_arr'] = $parent_comment['cover']? explode('|',trim($parent_comment['cover'],'|')):null; $v['parent_comment'] = $parent_comment; }); $total_num = SupplierComment::where($sel_where)->alias('t') ->leftJoin('SupplierComment c', 'c.id = t.pid')->count(); $this->success('ok', ['list' => $list, 'total_count' => $total_num, 'page_num' => $this->page_num]); } /** * @title 我的评论 * @desc 我的评论 * @author qc * @method GET * @url /api/Supplier/myDiscuss * @header name:Authorization require:1 desc:Token * @param name:title type:string default:-- desc:关键字 * @param name:page type:int default:-- desc:页数 * @param name:page_num type:int default:-- desc:每页数量 * @return name:create_at type:string default:-- desc:时间 * @return name:goods_name type:string default:-- desc:产品名称 * @return name:content type:string default:0 desc:评论内容 * @return name:name type:string default:-- desc:用户名 * @return name:headimg type:string default:-- desc:头像 * @return name:supplier_logo type:string default:-- desc:供应商logo * @return name:supplier_name type:string default:-- desc:供应商名称 * @return name:read_num type:string default:-- desc:阅读量 * @return name:cover_arr type:array default:-- desc:封面 * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情) */ public function myDiscuss() { $where = []; $where[] = ['c.is_deleted', '=', 0]; if ($title = input('title')) $where[] = ['c.content', 'like', '%' . $title . '%']; $where[] = ['c.user_id', '=', $this->user_id]; $where[] = ['c.pid', '=', 0]; $where[] = ['c.is_deleted', '=', 0]; $list = SupplierComment::field('c.*,m.name,m.headimg,g.name goods_name,g.read_num,s.logo supplier_logo ,s.title supplier_name,g.cover')->alias('c') ->where($where) ->leftJoin('store_member m', 'm.id = c.user_id') ->leftJoin('SupplierGoods g', 'g.id = c.goods_id') ->leftJoin('Supplier s', 's.id = g.supplier_id') ->order('c.is_top desc,c.id desc') ->limit($this->off_set, $this->page_num) ->select()->toArray(); array_walk($list, function (&$v) { $v['read_num'] = numTransform($v['read_num']); $v['is_normal'] = CheckPower::checkModulesPower($v['goods_id'],0,'supplier_goods'); $v['cover_arr'] = $v['cover']? explode('|',trim($v['cover'],'|')):null; }); $total_num = SupplierComment::where($where) ->alias('c') ->leftJoin('store_member m', 'm.id = c.user_id') ->leftJoin('SupplierGoods g', 'g.id = c.goods_id') ->leftJoin('Supplier s', 's.id = g.supplier_id')->count(); $this->success('ok', ['list' => $list, 'total_count' => $total_num, 'page_num' => $this->page_num]); } /** * @title 批量删除||批量取消 * @desc 删除||取消 * @author qc * @method POST * @url /api/Supplier/batchesDel * @header name:Authorization require:1 desc:Token * @param name:id type:string default:1 desc:记录id【多个用逗号隔开=>'1,2'】 * @param name:type type:string default:1 desc:消息类型【1我的评论,2评论我的,3我的回复,4订阅记录,5追番消息,6我的点赞-产品,7我的点赞-评论,8回复我的,9点赞我的--产品,10点赞我的--评论,11我的收藏】 */ public function batchesDel() { $type = input('post.type',1); $del_where = []; $del_where[] = ['id','in',input('post.id')]; if(in_array($type,[1,3,4,5,6,7])) $del_where[] = ['user_id','=',$this->user_id]; if(in_array($type,[1,3])) SupplierComment::where($del_where)->update(['is_deleted'=>1]); if(in_array($type,[2])) SupplierComment::where($del_where)->update(['source_deleted'=>1,'source_read'=>1,'is_read'=>1]); if(in_array($type,[4])) PlatformSwitch::where($del_where)->delete(); if(in_array($type,[5])) UserMessage::where($del_where)->update(['is_deleted'=>1]); if(in_array($type,[6,7])) PlatformLike::where($del_where)->delete(); if(in_array($type,[8])) SupplierComment::where($del_where)->update(['to_deleted'=>1,'is_read'=>1]); if(in_array($type,[9,10])) PlatformLike::where($del_where)->update(['to_deleted'=>1,'is_read'=>1]); if(in_array($type,[11])) UserCollect::where($del_where)->delete(); $this->success('操作成功'); } /** * @title 消息已读&&未读变更 * @desc 支持批量选择 * @author qc * @method POST * @url /api/Supplier/unreadChange * eadChange * @header name:Authorization require:1 desc:Token * @param name:id type:string default:-- desc:记录id(多个逗号隔开,不传修改全部]) * @param name:type type:string default:1 desc:消息类型【1评论我的,2回复我的,3订阅消息,4点赞我的】 * @param name:is_read type:int default:1 desc:变更类型【0消息变更为未读,1变更为已读】 */ public function unreadChange() { $type = input('post.type',1); $id = input('post.id'); $is_read = input('post.is_read'); $where = []; switch ($type) { case 1: SupplierComment::where([['i.user_id','=',$this->user_id]]) ->when($id ,function ($query)use ($id){ if($id) return $query->where('t.id','in',$id); })->leftJoin('SupplierGoods i','t.goods_id = i.id') ->alias('t') ->update(['source_read'=>$is_read,'is_read'=>$is_read]); break; case 2: $all_comment = SupplierComment::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id'); SupplierComment::where([['t.pid','in',implode(',',$all_comment)]]) ->when($id ,function ($query)use ($id){ if($id) return $query->where('t.id','in',$id); })->alias('t')->update(['is_read'=>$is_read]); break; case 3: $where[] = ['user_id','=',$this->user_id]; if($id) $where[] = ['id','in',$id]; UserMessage::where($where)->update(['is_read'=>$is_read]); break; case 4: PlatformLike::where([['p.type', '=', 7],['f.user_id', '=', $this->user_id],['p.to_deleted', '=', 0],['p.is_read','=',0]])->alias('p') ->leftJoin('SupplierGoods f', 'f.id = p.like_id')->update(['p.is_read'=>1]); PlatformLike::where([['p.type', '=', 11],['c.user_id', '=', $this->user_id],['p.to_deleted', '=', 0],['p.is_read','=',0]])->alias('p')->leftJoin('SupplierComment c', 'c.id = p.like_id')->update(['p.is_read'=>1]); break; } $this->success('消息变更成功'); } }