where('is_type',$request->get('is_type',0))->select(); if(empty($list)){ return app('json')->fail('类型为空'); } if (is_object($list)) $list = $list->toArray(); return app('json')->success($list); } // 订阅号详情 public function details(Request $request){ $user = $request->user(); $data=$request->get(); //if(empty($data['id'])){ //return app('json')->fail('id为空'); //} // 通过id查询媒体 $res=isUser::where('id',$data['id'])->select(); $essay=$this->essay($res,$user); // 查询该订阅号下的文章 $res2=Article::where('mer_id',$data['id'])->where('status',1)->where('is_check',1)->order('add_time', 'desc')->page($data['page'],$data['rows'])->field('id,title,add_time,image_input')->select(); $counts=count($res2); $list=[]; foreach($res2 as $v){ $count=ReplyModel::where('aid',$v['id'])->count(); $list[]=[ 'id'=>$v['id'], 'title'=>$v['title'], 'add_time'=>$v['add_time'], 'image_input'=>$v['image_input'], 'comment'=>$count ]; } $list=['count'=>$counts,'content'=>$essay,'list'=>$list]; return app('json')->success($list); } // 文章列表 public function lists(Request $request){ $data=$request->get(); $res=isUser::where('type',$data['id']) ->page(intval($data['page']),intval($data['rows'])) ->field('id,name') ->select() ->toArray(); $list=[]; $counts=0; foreach($res as $v){ $lists=Article::where('mer_id',$v['id'])->where('status',1)->where('is_check',1)->field('id,title,add_time,image_input')->select(); $counts=$counts+sizeof($lists); foreach($lists as $k){ $count=ReplyModel::where('aid',$k['id'])->count(); $list[]=[ 'id'=>$k['id'], 'title'=>$k['title'], 'add_time'=>$k['add_time'], 'image_input'=>$k['image_input'], 'name'=>$v['name'], 'comment'=>$count ]; } } $list=['count'=>$counts,'list'=>$list]; return app('json')->success($list); } // 媒体查询 public function search(Request $request){ $user = $request->user(); $data=$request->get(); $map[] = ['name','like','云']; $res=isUser::where('name','like','%'.$data['name'].'%')->page($data['page'],$data['rows'])->select()->toArray(); $essay=$this->essay($res,$user); return app('json')->success($essay); } // 企业推荐列表 public function putlist(Request $request){ $data=$request->get(); $user = $request->user(); // 当传了类型过来就通过类型查询 if(isset($data['type'])){ $res=isUser::where('type',$data['type'])->where('is_auth',2)->where('is_dle',0) ->page(intval($data['page']),intval($data['rows'])) ->field('id,name,headimg,introduce') ->select() ->toArray(); $essay=$this->essay($res,$user); return app('json')->success($essay); } $list=isUser::where('is_put',1)->where('is_auth',2)->page(intval($data['page']),intval($data['rows']))->field('id,name,headimg,introduce')->select(); $essay=$this->essay($list,$user); return app('json')->success($essay); } // 企业认证 进度 认证信息 public function rate(Request $request) { $user = $request->user(); $res=isUser::where('uid',$user['uid'])->find(); if(!$res){ return app('json')->success('未发起企业认证'); } if($res['is_auth']==1){ $data=[ 'state'=>$res['is_auth'], 'reason'=>$res['reason'] ]; } if($res['is_auth']==2){ $data=[ 'id'=>$res['id'], 'name'=>$res['name'], 'type'=>$res['type'], 'sub'=>$res['sub'], 'contacts'=>$res['contacts'], 'post'=>$res['post'], 'phone'=>$res['phone'], 'headimg'=>$res['headimg'], 'state'=>$res['is_auth'], 'reason'=>$res['reason'], 'introduce'=> html_entity_decode($res['introduce']), ]; } return app('json')->success($data); } // 信息修改 public function edit(Request $request) { list($name, $headimg,$introduce) = UtilService::postMore([ ['name', ''], ['headimg', ''], ['introduce', ''], ], $request, true); if (isUser::where('uid',$request->uid())->update(['name'=>$name,'headimg'=>$headimg,'introduce'=>$introduce])) return app('json')->successful('修改成功'); return app('json')->fail('修改失败'); } // 统计企业文章数 public function essay($list,$user){ $coutn=count($list); $list1=[]; foreach($list as $k =>$v){ // 查询该用户是否已订阅该媒体 $is_sub=InterestUser::where('uid',$user['uid'])->where('mer_id',$v['id'])->count(); $count=Article::where('mer_id',$v['id'])->count(); $read=Article::where('mer_id',$v['id'])->sum('visit'); $list1[]=[ 'id'=>$v['id'], 'name'=>$v['name'], 'headimg'=>$v['headimg'], 'visit'=>$read, 'count'=>$count, 'is_sub'=>$is_sub, 'introduce'=> html_entity_decode($v['introduce']), ]; } $lists=['coutn'=>$coutn,'list'=>$list1]; return $lists; } }