Article.php 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616
  1. <?php
  2. namespace app\api\controller;
  3. use app\common\model\ArticleCate;
  4. use app\common\model\ArticleComment;
  5. use app\common\model\ArticleCommentLike;
  6. use app\common\model\ArticleIntro;
  7. use app\common\model\ArticleItem;
  8. use app\common\model\ArticleLike;
  9. use app\common\model\SeriesArticleCate;
  10. use app\common\model\UserCollect;
  11. use app\common\model\UserArticle;
  12. use app\common\model\UserSearch;
  13. use library\tools\Data;
  14. /**
  15. * @title 图文
  16. * @controller Article
  17. * @group base
  18. */
  19. class Article extends Base
  20. {
  21. // 需要登录的
  22. protected $need_login = [
  23. 'articleTransmit',
  24. 'articleRead',
  25. 'articleTags',
  26. 'articleComment',
  27. 'articleCollect',
  28. 'userReferArticle',
  29. 'getMyArticleList',
  30. 'getUserArticleDetail',
  31. 'delUserArticle',
  32. 'delComment',
  33. ];
  34. public function initialize()
  35. {
  36. parent::initialize();
  37. parent::setUid();
  38. foreach ($this->need_login as $c) {
  39. if($this->request->action() == strtolower($c)) {
  40. // parent::checkLogin();
  41. }
  42. }
  43. }
  44. /**
  45. * @title 图文接口说明
  46. * @desc 图文接口说明
  47. * @author qc
  48. * @url /api/Article/classIntro
  49. * @method GET
  50. * @return name:1 type:string default:-- desc:图片(images字段)多图片都用竖线(|)隔开,会员上传多张也用(|)隔开
  51. * @return name:2 type:string default:-- desc:cover字段值是images的第一个路径【非多张】
  52. * @return name:3 type:string default:-- desc:单一图文与系列图文区别,type值(1是单一,2是系列),数据:item_list二维数组数据数量不一样(单一的只有一个,系列的可以是多个)【可以将单一图文看做只有一条记录的系列图文!!!!】
  53. * @return name:4 type:string default:-- desc:单一图文详情的字段(cover,images,is_vip,title)与item_list数组的第一个同字段名的值相同
  54. * @return name:5 type:string default:-- desc:系列图文详情的字段(cover,images)与item_list的其中一个相同
  55. * @return name:6 type:string default:-- desc:关于是否的字段(0否,1是)
  56. * @return name:7 type:string default:-- desc:item_id是数组item_list下的id
  57. */
  58. public function classIntro(){}
  59. /**
  60. * @title 获取图文分类
  61. * @desc 获取图文分类
  62. * @author qc
  63. * @url /api/Article/getArticleCate
  64. * @method GET
  65. * @header name:Authorization require:1 desc:Token
  66. * @param name:type type:int default:1 desc:类型1单个2系列
  67. * @return name:id type:int default:-- desc:分类id
  68. * @return name:logo type:string default:-- desc:图标
  69. * @return name:title type:string default:0 desc:分类名称
  70. * @return name:children type:array default:0 desc:下级分类
  71. */
  72. public function getArticleCate()
  73. {
  74. $type = input('type',1);
  75. if($type == 1) {
  76. $list = ArticleCate::where(['is_deleted'=>0])->field('id,logo,title,pid')->order('sort desc')->select()->toArray();
  77. }else{
  78. $list = SeriesArticleCate::where(['is_deleted'=>0])->field('id,logo,title,pid')->order('sort desc')->select()->toArray();
  79. }
  80. $list = make_tree($list);
  81. $this->success('ok',['list'=>$list]);
  82. }
  83. /**
  84. * @title 获取图文列表(平台发布)
  85. * @desc 获取图文列表
  86. * @author qc
  87. * @method GET
  88. * @url /api/Article/getArticleList
  89. * @header name:Authorization require:1 desc:Token
  90. * @param name:type type:int default:0 desc:类型1单个2系列
  91. * @param name:is_tj type:int default:0 desc:是否推荐0否1是
  92. * @param name:title type:string default:-- desc:标题
  93. * @param name:page type:int default:0 desc:页数
  94. * @param name:page_num type:int default:20 desc:每页数
  95. * @param name:sort_type type:int default:1 desc:1默认2时间升序3时间降序
  96. * @param name:first_classify type:int default:0 desc:一级分类
  97. * @param name:second_classify type:int default:0 desc:二级分类
  98. * @return name:title type:string default:-- desc:标题
  99. * @return name:type type:int default:0 desc:类型1单个2系列
  100. * @return name:cover type:string default:-- desc:封面()
  101. * @return name:is_vip type:int default:-- desc:是否是vip(0否,1是)
  102. * @return name:is_over type:int default:-- desc:是否完结(0否,1是)
  103. * @return name:read_num type:int default:-- desc:阅读量
  104. * @return name:label type:string default:-- desc:标签
  105. * @return name:item_list type:array default:-- desc:图文
  106. * @return name:item_list.title type:string default:-- desc:图文标题
  107. * @return name:item_list.is_vip type:int default:-- desc:是否是vip
  108. * @return name:item_list.cover type:string default:-- desc:图文封面
  109. * @return name:item_list.images type:string default:-- desc:图片(多张用|隔开)
  110. * @return name:item_list.content type:string default:-- desc:内容
  111. */
  112. public function getArticleList()
  113. {
  114. $sel_where = [];
  115. $title = input('get.title');
  116. $type = input('get.type',0);
  117. $is_tj = input('get.is_tj',0);
  118. $sort_type = input('get.sort_type',1);
  119. $first_classify = input('get.first_classify');
  120. $second_classify = input('get.second_classify');
  121. $sel_where[] = ['is_deleted','=',0];
  122. $sel_where[] = ['status','=',1];
  123. $sel_where[] = ['item_num','>',0];
  124. if($title) $sel_where[] = ['title','like','%'.$title.'%'];
  125. if($type) $sel_where[] = ['type','=',$type];
  126. if($first_classify) $sel_where[] = ['first_classify','=',$first_classify];
  127. if($second_classify) $sel_where[] = ['second_classify','=',$second_classify];
  128. $order = 'is_top desc,sort desc ,id desc';
  129. if($sort_type == 2)$order = 'id asc';
  130. if($sort_type == 3)$order = 'id desc';
  131. if($title && $this->user_id)UserSearch::saveSearchTitle($this->user_id,$title,2);
  132. $where_str = 'id > 0';
  133. if($is_tj) {
  134. $search_log = UserSearch::getSearchTitle($this->user_id,2);
  135. $search_arr = [];
  136. foreach ($search_log as $t){
  137. $search_arr[] = " title like '".'%'.$t."%'" .' ';
  138. }
  139. if(!empty($search_arr)) $where_str = implode(' OR ',$search_arr);
  140. }
  141. $list = ArticleIntro::where($sel_where)->with('itemList')
  142. ->limit($this->off_set,$this->page_num)
  143. ->where($where_str)
  144. ->order($order)
  145. ->select()->toArray();
  146. array_walk($list,function (&$v,$k){
  147. });
  148. $this->success('ok',['list'=>$list]);
  149. }
  150. /**
  151. * @title 获取图文详情(平台)
  152. * @desc 获取图文详情
  153. * @author qc
  154. * @method GET
  155. * @url /api/Article/getArticleDetail
  156. * @header name:Authorization require:1 desc:Token
  157. * @param name:id type:int default:0 desc:图文id
  158. * @return name:title type:string default:-- desc:标题
  159. * @return name:cover type:string default:-- desc:封面
  160. * @return name:images type:string default:-- desc:图片
  161. * @return name:is_vip type:string default:-- desc:是否VIP
  162. * @return name:item_list type:array default:-- desc:图文
  163. * @return name:item_list.title type:string default:-- desc:图文标题
  164. * @return name:item_list.is_vip type:int default:-- desc:是否是vip
  165. * @return name:item_list.cover type:string default:-- desc:封面
  166. * @return name:item_list.images type:int default:-- desc:图片
  167. * @return name:item_list.content type:int default:-- desc:内容
  168. * @return name:item_list.transmit_num type:int default:-- desc:转发量
  169. * @return name:item_list.read_num type:int default:-- desc:阅读量
  170. * @return name:item_list.comment_num type:int default:-- desc:评论量
  171. * @return name:item_list.collect_num type:int default:-- desc:收藏量
  172. * @return name:item_list.is_collect type:int default:-- desc:是否收藏
  173. * @return name:item_list.video_id type:int default:-- desc:关联视频id【单个id||系列id】
  174. * @return name:item_list.video_item type:int default:-- desc:关联视频详情id【video_arr.id】
  175. * @return name:item_list.datum_id type:int default:-- desc:资料id【单个id||系列id】
  176. * @return name:item_list.datum_item type:int default:-- desc:资料详情id【url_arr.id】
  177. */
  178. public function getArticleDetail()
  179. {
  180. $sel_where = [];
  181. $sel_where[] = ['id','=',input('get.id')];
  182. $detail = ArticleIntro::where($sel_where)->with('itemList')->find()->toArray();
  183. if($detail['is_deleted'] == 1 || $detail['status'] == 0)$this->error('该图文已下线');
  184. foreach ($detail['item_list'] as &$dv) {
  185. $dv['comment_num'] = ArticleComment::where(['article_id'=>$detail['id'],'item_id'=>$dv['id']])->count();
  186. $dv['collect_num'] = UserCollect::where(['coll_type'=>3,'coll_id'=>$detail['id'],'children_id'=>$dv['id']])->count();
  187. $dv['is_collect'] = UserCollect::checkCollectByType($this->user_id,3,$detail['id'],$dv['id']);
  188. }
  189. $detail['read_num'] = array_sum(array_column($detail['item_list'],'read_num'));
  190. $this->success('ok',['detail'=>$detail]);
  191. }
  192. /**
  193. * @title 获取图文ITEM详情(平台)
  194. * @desc 获取图文ITEM详情
  195. * @author qc
  196. * @method GET
  197. * @url /api/Article/getArticleItemInfo
  198. * @header name:Authorization require:1 desc:Token
  199. * @param name:item_id type:int default:0 desc:item_list
  200. * @return name:title type:string default:-- desc:图文标题
  201. * @return name:is_vip type:int default:-- desc:是否是vip
  202. * @return name:cover type:string default:-- desc:封面
  203. * @return name:images type:int default:-- desc:图片
  204. * @return name:content type:int default:-- desc:内容
  205. * @return name:transmit_num type:int default:-- desc:转发量
  206. * @return name:read_num type:int default:-- desc:阅读量
  207. * @return name:comment_num type:int default:-- desc:评论量
  208. * @return name:collect_num type:int default:-- desc:收藏量
  209. * @return name:is_collect type:int default:-- desc:是否收藏
  210. * @return name:like_num type:int default:-- desc:点赞量
  211. * @return name:is_like type:int default:-- desc:是否点赞
  212. * @return name:video_id type:int default:-- desc:关联视频id【单个id||系列id】
  213. * @return name:video_item type:int default:-- desc:关联视频详情id【video_arr.id】
  214. * @return name:datum_id type:int default:-- desc:资料id【单个id||系列id】
  215. * @return name:datum_item type:int default:-- desc:资料详情id【url_arr.id】
  216. */
  217. public function getArticleItemInfo()
  218. {
  219. $item_id = input('get.item_id');
  220. $detail = ArticleItem::where('id',$item_id)->find()->toArray();
  221. $detail['comment_num'] = ArticleComment::where(['article_id'=>$detail['article_id'],'item_id'=>$detail['id']])->count();
  222. $detail['collect_num'] = UserCollect::where(['coll_type'=>3,'coll_id'=>$detail['article_id'],'children_id'=>$detail['id']])->count();
  223. $detail['is_collect'] = UserCollect::checkCollectByType($this->user_id,3,$detail['article_id'],$detail['id']);
  224. $detail['is_like'] = ArticleLike::where(['user_id'=>$this->user_id,'article_id'=>$detail['article_id'],'item_id'=>$detail['id']])->count();
  225. $detail['like_num'] = ArticleLike::where(['article_id'=>$detail['article_id'],'item_id'=>$detail['id']])->count();
  226. $this->success('ok',['detail'=>$detail]);
  227. }
  228. /**
  229. * @title 获取图文评论列表
  230. * @desc 获取图文评论列表
  231. * @author qc
  232. * @method GET
  233. * @url /api/Article/getArticleCommentList
  234. * @header name:Authorization require:1 desc:Token
  235. * @param name:article_id type:int default:-- desc:图文id
  236. * @param name:item_id type:int default:-- desc:item_id
  237. * @param name:sort_type type:int default:1 desc:排序规则1时间2热点
  238. * @param name:page type:int default:-- desc:页数
  239. * @return name:name type:string default:-- desc:会员名称
  240. * @return name:headimg type:string default:-- desc:会员头像
  241. * @return name:content type:string default:-- desc:内容
  242. * @return name:parent type:array default:-- desc:评论上一级(数据同上【一维数组】)
  243. * @return name:children type:array default:-- desc:二级评论(数据同上【二维数组】)
  244. * @return name:like_num type:int default:-- desc:点赞数量
  245. * @return name:is_like type:int default:-- desc:是否点赞(0否1是)
  246. * @return name:can_delete type:int default:-- desc:是否可以删除(0否1是)
  247. * @return name:total_num type:int default:-- desc:总评论数(仅一级)
  248. */
  249. public function getArticleCommentList()
  250. {
  251. $where = [];
  252. $where[] = ['c.article_id','=',input('get.article_id')];
  253. $where[] = ['c.is_deleted','=',0];
  254. $user_id = $this->user_id;
  255. $sort_type= input('sort_type',1);
  256. if(input('get.item_id')) $where[] = ['c.item_id','=',input('get.item_id')];
  257. $order = $sort_type == 1 ? 'c.id desc' : 'c.like_times desc';
  258. $list =ArticleComment::where($where)
  259. ->alias('c')
  260. ->field('c.*,u.name,u.headimg')
  261. ->leftJoin('store_member u','u.id = c.user_id')
  262. ->order($order)
  263. ->limit($this->off_set,$this->page_num)
  264. ->select()->toArray();
  265. array_walk($list,function (&$val,$k)use($user_id){
  266. $children = ArticleComment::where(['c.pid'=>$val['id'],'c.is_deleted'=>0])
  267. ->alias('c')->field('c.*,u.name,u.headimg')
  268. ->leftJoin('store_member u','u.id = c.user_id')
  269. ->order('c.id asc')
  270. ->select()->toArray();
  271. $val['children'] = $children;
  272. $val['like_num'] = ArticleCommentLike::where('like_id',$val['id'])->count();
  273. $val['is_like'] = ArticleCommentLike::where(['like_id'=>$val['id'],'user_id'=>$user_id])->count();
  274. $parent = ArticleComment::where(['c.id'=>$val['pid'],'c.is_deleted'=>0])
  275. ->alias('c')->field('c.*,u.name,u.headimg')
  276. ->leftJoin('store_member u','u.id = c.user_id')
  277. ->find();
  278. $val['parent'] = $parent ? $parent->toArray() : null;
  279. $val['can_delete'] = $val['user_id'] == $this->user_id ? 1 :0;
  280. });
  281. $total_num = ArticleComment::where($where)->alias('c')->count();
  282. $this->success('ok',['list'=>$list,'total_num'=>$total_num]);
  283. }
  284. /**
  285. * @title 以下接口调用验证登录【需要header传Authorization】
  286. * @desc 转发成功后调用
  287. * @author qc
  288. * @method
  289. * @url /api/Article/needLogin()
  290. */
  291. public function needLogin(){}
  292. /**
  293. * @title 图文转发(转发数量统计)
  294. * @desc 转发成功后调用
  295. * @author qc
  296. * @method POST
  297. * @url /api/Article/articleTransmit
  298. * @header name:Authorization require:1 desc:Token
  299. * @param name:item_id type:int default:-- desc:item_list的id
  300. */
  301. public function articleTransmit()
  302. {
  303. $item_id = input('post.item_id',0);
  304. ArticleItem::where('id',$item_id)->setInc('transmit_num');
  305. $this->success('ok');
  306. }
  307. /**
  308. * @title 图文阅读(阅读数量统计)
  309. * @desc 图文阅读
  310. * @author qc
  311. * @method POST
  312. * @url /api/Article/articleRead
  313. * @header name:Authorization require:1 desc:Token
  314. * @param name:item_id type:int default:-- desc:item_list的id
  315. */
  316. public function articleRead()
  317. {
  318. $item_id = input('post.item_id',0);
  319. ArticleItem::where('id',$item_id)->setInc('read_num');
  320. $this->success('ok');
  321. }
  322. /**
  323. * @title 图文点赞||取消点赞
  324. * @desc 点赞||取消点赞
  325. * @author qc
  326. * @method POST
  327. * @url /api/Article/articleTags
  328. * @header name:Authorization require:1 desc:Token
  329. * @param name:article_id type:int default:1 desc:图文id
  330. * @param name:item_id type:int default:1 desc:item_id
  331. * @return name:tags type:int default:1 desc:0取消成功,1点赞成功
  332. */
  333. public function articleTags()
  334. {
  335. $article_id = input('post.article_id');
  336. $item_id = input('post.item_id');
  337. $ret_val = 0;
  338. $check_tags = ArticleLike::where(['user_id'=>$this->user_id,'article_id'=>$article_id,'item_id'=>$item_id])->value('id');
  339. if($check_tags) {
  340. ArticleLike::where(['user_id'=>$this->user_id,'article_id'=>$article_id,'item_id'=>$item_id])->delete();
  341. }else{
  342. Data::save('ArticleLike',
  343. ['user_id'=>$this->user_id,'article_id'=>$article_id,'item_id'=>$item_id],'user_id',
  344. ['user_id'=>$this->user_id,'article_id'=>$article_id,'item_id'=>$item_id]);
  345. $ret_val = 1;
  346. }
  347. $this->success($ret_val == 1 ?'点赞成功':'取消成功',['tags'=>$ret_val]);
  348. }
  349. /**
  350. * @title 图文评论
  351. * @desc 图文评论
  352. * @author qc
  353. * @method POST
  354. * @url /api/Article/articleComment
  355. * @header name:Authorization require:1 desc:Token
  356. * @param name:article_id type:int default:1 desc:图文id
  357. * @param name:item_id type:int default:1 desc:item_id
  358. * @param name:content type:string default:-- desc:内容
  359. * @param name:content type:string default:-- desc:内容
  360. * @return name:name type:string default:-- desc:会员名称
  361. * @return name:headimg type:string default:-- desc:会员头像
  362. * @return name:content type:string default:-- desc:内容
  363. */
  364. public function articleComment()
  365. {
  366. $article_id = input('post.article_id');
  367. $item_id = input('post.item_id');
  368. $content = input('post.content',0);
  369. if(!$content) $this->error('请输入评论内容');
  370. $res = ArticleComment::create(['user_id'=>$this->user_id,'content'=>$content,'article_id'=>$article_id,'item_id'=>$item_id]);
  371. $detail =ArticleComment::where('c.id',$res->id)
  372. ->alias('c')
  373. ->field('c.id,c.content,c.create_at,u.name,u.headimg')
  374. ->leftJoin('store_member u','u.id = c.user_id')
  375. ->find()->toArray();
  376. $this->success('评论成功',['detail'=>$detail]);
  377. }
  378. /**
  379. * @title 删除评论
  380. * @desc 删除评论
  381. * @author qc
  382. * @method POST
  383. * @url /api/Article/delComment
  384. * @header name:Authorization require:1 desc:Token
  385. * @param name:id type:int default:1 desc:评论id
  386. */
  387. public function delComment(){
  388. ArticleComment::where(['id'=>input('post.id'),'user_id'=>$this->user_id])->update(['is_deleted'=>1]);
  389. $this->success('删除成功');
  390. }
  391. /**
  392. * @title 图文二级评论
  393. * @desc 图文二级评论
  394. * @author qc
  395. * @method POST
  396. * @url /api/Article/secondCommend
  397. * @header name:Authorization require:1 desc:Token
  398. * @param name:id type:int default:1 desc:评论id
  399. * @param name:content type:string default:-- desc:内容
  400. * @return name:name type:string default:-- desc:会员名称
  401. * @return name:headimg type:string default:-- desc:会员头像
  402. * @return name:content type:string default:-- desc:内容
  403. */
  404. public function secondCommend()
  405. {
  406. $comment = ArticleComment::where('id',input('post.id'))->find()->toArray();
  407. unset($comment['id']);
  408. unset($comment['create_at']);
  409. $comment['pid'] = input('post.id');
  410. $comment['user_id'] = $this->user_id;
  411. $comment['content'] = input('post.content');
  412. $comment['lev']++;
  413. if(!$comment['source_id']) $comment['source_id'] = input('post.id');
  414. $res = ArticleComment::create($comment);
  415. $detail = ArticleComment::where('c.id',$res->id)
  416. ->alias('c')
  417. ->field('c.id,c.content,c.create_at,u.name,u.headimg')
  418. ->leftJoin('store_member u','u.id = c.user_id')
  419. ->find()->toArray();
  420. $this->success('评论成功',['detail'=>$detail]);
  421. }
  422. /**
  423. * @title 评论点赞||取消点赞
  424. * @desc 评论
  425. * @author qc
  426. * @method POST
  427. * @url /api/Article/commentTags
  428. * @header name:Authorization require:1 desc:Token
  429. * @param name:comment_id type:int default:1 desc:评论记录id
  430. * @return name:tags type:int default:1 desc:0取消成功,1点赞成功
  431. */
  432. public function commentTags()
  433. {
  434. $comment_id = input('post.comment_id');
  435. $ret_val = 0;
  436. $check_tags = ArticleCommentLike::where(['user_id'=>$this->user_id,'like_id'=>$comment_id])->value('id');
  437. if($check_tags) {
  438. ArticleCommentLike::where(['user_id'=>$this->user_id,'like_id'=>$comment_id])->delete();
  439. }else{
  440. Data::save('ArticleCommentLike',
  441. ['user_id'=>$this->user_id,'like_id'=>$comment_id,],'user_id',
  442. ['user_id'=>$this->user_id,'like_id'=>$comment_id]);
  443. $ret_val = 1;
  444. }
  445. $this->success($ret_val == 1 ?'点赞成功':'取消成功',['tags'=>$ret_val]);
  446. }
  447. /**
  448. * @title 图文收藏||取消收藏
  449. * @desc 用户收藏
  450. * @author qc
  451. * @method POST
  452. * @url /api/Article/articleCollect
  453. * @header name:Authorization require:1 desc:Token
  454. * @param name:article_id type:int require:1 default:-- desc:记录id[图文id]
  455. * @param name:item_id type:int default:1 desc:item_id
  456. * @param name:status type:int default:0 desc:收藏状态(0取消收藏【未收藏】,1收藏)
  457. */
  458. public function articleCollect()
  459. {
  460. $coll_type = input('post.coll_type',3);
  461. $coll_id = input('post.article_id',0);
  462. $item_id = input('post.item_id',0);
  463. $collect_check = UserCollect::checkCollectByType($this->user_id,$coll_type,$coll_id,$item_id);
  464. if($collect_check) {
  465. UserCollect::where(['user_id'=>$this->user_id,'coll_type'=>$coll_type,'coll_id'=>$coll_id,'children_id'=>$item_id])->delete();
  466. $this->success('取消收藏成功',['status'=>0]);
  467. }else{
  468. Data::save('UserCollect', [
  469. 'user_id'=>$this->user_id,
  470. 'coll_type'=>$coll_type,
  471. 'coll_id'=>$coll_id,
  472. 'children_id'=>$item_id,
  473. 'create_int'=>time()],'user_id',['user_id'=>$this->user_id,'coll_type'=>$coll_type, 'coll_id'=>$coll_id,'children_id'=>$item_id]);
  474. $this->success('收藏成功',['status'=>1]);
  475. }
  476. }
  477. /**
  478. * @title 用户提交或修改图文【个人】
  479. * @desc 用户提交或修改图文【个人】
  480. * @author qc
  481. * @method POST
  482. * @url /api/Article/userReferArticle
  483. * @header name:Authorization require:1 desc:Token
  484. * @param name:id type:int default:-- desc:id(修改时必传)
  485. * @param name:title type:string default:-- desc:标题
  486. * @param name:images type:string default:-- desc:图片(多张用|隔开)
  487. * @param name:desc type:string default:-- desc:简介
  488. * @param name:label type:string default:-- desc:图文标签
  489. */
  490. public function userReferArticle()
  491. {
  492. $id = input('post.id',0);
  493. $title = input('post.title');
  494. $desc = input('post.desc');
  495. $images = input('post.images');
  496. $label = input('post.label');
  497. if(!$images) $this->error('请上传图文');
  498. if($id){
  499. $check_status = UserArticle::where('id',$id)->value('status');
  500. if($check_status == 1) $this->error('已审核通过,不允许修改');
  501. }
  502. $data = [
  503. 'title' => $title,
  504. 'user_id' => $this->user_id,
  505. 'desc' => $desc,
  506. 'images' => $images,
  507. 'label' => $label,
  508. 'cover' => explode('|',$images)[0],
  509. ];
  510. if($id) $data['id'] = $id;
  511. if($id){
  512. UserArticle::where('id',$id)->update($data);
  513. }else{
  514. $res= UserArticle::create($data) ;
  515. }
  516. $this->success('提交成功,请等待审核',['id'=> $id ? :$res->id]);
  517. }
  518. /**
  519. * @title 获取我的图文列表【个人】
  520. * @desc 获取我的图文列表【个人】
  521. * @author qc
  522. * @method GET
  523. * @url /api/Article/getMyArticleList
  524. * @header name:Authorization require:1 desc:Token
  525. * @param name:title type:string default:-- desc:标题
  526. * @param name:page type:int default:0 desc:页数
  527. * @param name:page_num type:int default:20 desc:每页数
  528. * @return name:title type:string default:-- desc:标题
  529. * @return name:desc type:string default:-- desc:简介
  530. * @return name:images type:string default:-- desc:图文
  531. * @return name:status type:int default:-- desc:0待审核1审核通过2审核未通过
  532. * @return name:remark type:string default:-- desc:审核备注
  533. */
  534. public function getMyArticleList()
  535. {
  536. $sel_where = [];
  537. $sel_where[] = ['is_deleted','=',0];
  538. $sel_where[] = ['user_id','=',$this->user_id];
  539. $title = input('get.title');
  540. if($title) $sel_where[] = ['title','like','%'.$title.'%'];
  541. $list = UserArticle::where($sel_where)
  542. ->field('id,title,desc,images,status,remark')
  543. ->order('id desc')
  544. ->limit($this->off_set,$this->page_num)
  545. ->select()->toArray();
  546. $this->success('ok',['list'=>$list]);
  547. }
  548. /**
  549. * @title 获取我的图文详情【个人】
  550. * @desc 获取我的图文列表【个人】
  551. * @author qc
  552. * @method GET
  553. * @url /api/Article/getUserArticleDetail
  554. * @header name:Authorization require:1 desc:Token
  555. * @param name:id type:string default:-- desc:记录id
  556. * @return name:title type:string default:-- desc:标题
  557. * @return name:desc type:string default:-- desc:简介
  558. * @return name:images type:string default:-- desc:图文
  559. * @return name:status type:int default:-- desc:0待审核1审核通过2审核未通过
  560. * @return name:remark type:string default:-- desc:审核备注
  561. */
  562. public function getUserArticleDetail()
  563. {
  564. $detail =UserArticle::where('id',input('get.id'))->field('id,title,desc,images,status,remark')->find();
  565. if(!$detail) $this->error('图文有误');
  566. $this->success('ok',['detail'=>$detail->toArray()]);
  567. }
  568. /**
  569. * @title 用户删除图文记录【个人】
  570. * @desc 用户删除图文记录【个人】
  571. * @author qc
  572. * @method POST
  573. * @url /api/Article/delUserArticle
  574. * @header name:Authorization require:1 desc:Token
  575. * @param name:id type:int default:-- desc:id
  576. */
  577. public function delUserArticle()
  578. {
  579. UserArticle::where(['user_id'=>$this->user_id,'id'=>input('post.id')])->delete();
  580. $this->success('删除成功');
  581. }
  582. }