Article.php 59 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305
  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\PlatformSwitch;
  10. use app\common\model\SeriesArticleCate;
  11. use app\common\model\User;
  12. use app\common\model\UserCollect;
  13. use app\common\model\UserArticle;
  14. use app\common\model\UserLearn;
  15. use app\common\model\UserMessage;
  16. use app\common\model\UserSearch;
  17. use app\common\model\UserTag;
  18. use app\common\model\UserTrack;
  19. use app\common\service\CheckPower;
  20. use library\tools\Data;
  21. use think\Db;
  22. use think\db\Query;
  23. /**
  24. * @title 图文
  25. * @controller Article
  26. * @group base
  27. */
  28. class Article extends Base
  29. {
  30. // 需要登录的
  31. protected $need_login = [
  32. 'articleTransmit',
  33. 'articleRead',
  34. 'articleTags',
  35. 'articleComment',
  36. 'delComment',
  37. 'secondCommend',
  38. 'commentTags',
  39. 'articleCollect',
  40. 'userReferArticle',
  41. 'getMyArticleList',
  42. 'getUserArticleDetail',
  43. 'delUserArticle',
  44. 'delComment',
  45. 'getLearnHistory',
  46. 'getArticleCollect',
  47. 'getCommentArticle',
  48. 'commentMyArticle',
  49. 'getPurchaseArticle',
  50. 'getReplyArticle',
  51. 'getReplyComment',
  52. 'getTagsArticle',
  53. 'getBoundList',
  54. 'getFollowUpList',
  55. ];
  56. public function initialize()
  57. {
  58. parent::initialize();
  59. parent::setUid();
  60. }
  61. /**
  62. * @title 图文接口说明
  63. * @desc 图文接口说明
  64. * @author qc
  65. * @url /api/Article/classIntro
  66. * @method GET
  67. * @return name:1 type:string default:-- desc:图片(images字段)多图片都用竖线(|)隔开,会员上传多张也用(|)隔开
  68. * @return name:2 type:string default:-- desc:cover字段值是images的第一个路径【非多张】
  69. * @return name:3 type:string default:-- desc:单一图文与系列图文区别,type值(1是单一,2是系列),数据:item_list二维数组数据数量不一样(单一的只有一个,系列的可以是多个)【可以将单一图文看做只有一条记录的系列图文!!!!】
  70. * @return name:4 type:string default:-- desc:单一图文详情的字段(cover,images,is_vip,title)与item_list数组的第一个同字段名的值相同
  71. * @return name:5 type:string default:-- desc:系列图文详情的字段(cover,images)与item_list的其中一个相同
  72. * @return name:6 type:string default:-- desc:关于是否的字段(0否,1是)
  73. * @return name:7 type:string default:-- desc:item_id是数组item_list下的id
  74. */
  75. public function classIntro(){}
  76. /**
  77. * @title 获取图文分类
  78. * @desc 获取图文分类
  79. * @author qc
  80. * @url /api/Article/getArticleCate
  81. * @method GET
  82. * @header name:Authorization require:1 desc:Token
  83. * @param name:type type:int default:1 desc:类型1单个2系列
  84. * @return name:id type:int default:-- desc:分类id
  85. * @return name:logo type:string default:-- desc:图标
  86. * @return name:title type:string default:0 desc:分类名称
  87. * @return name:children type:array default:0 desc:下级分类
  88. */
  89. public function getArticleCate()
  90. {
  91. $type = input('type',1);
  92. if($type == 1) {
  93. $list = ArticleCate::where(['is_deleted'=>0,'status'=>1])->field('id,logo,title,pid')->order('sort desc,id asc')->select()->toArray();
  94. }else{
  95. $list = SeriesArticleCate::where(['is_deleted'=>0,'status'=>1])->field('id,logo,title,pid')->order('sort desc,id asc')->select()->toArray();
  96. }
  97. $list = make_tree($list);
  98. $this->success('ok',['list'=>$list]);
  99. }
  100. /**
  101. * @title 图文推荐
  102. * @desc 图文推荐
  103. * @author qc
  104. * @method GET
  105. * @url /api/Article/getRecommendList
  106. * @header name:Authorization require:1 desc:Token
  107. * @param name:page type:int default:0 desc:页数
  108. * @param name:page_num type:int default:20 desc:每页数
  109. * @return name:id type:string default:-- desc:图文item_id
  110. * @return name:title type:string default:-- desc:标题
  111. * @return name:article_id type:string default:-- desc:系列id
  112. * @return name:cover type:string default:-- desc:封面
  113. * @return name:images_arr type:string default:-- desc:图片
  114. * @return name:is_vip type:int default:-- desc:是否是vip(0否,1是)
  115. * @return name:read_num type:int default:-- desc:阅读量
  116. * @return name:app_name type:string default:-- desc:平台名称
  117. * @return name:app_logo type:string default:-- desc:平台头像
  118. * @return name:author type:string default:-- desc:原创作者
  119. */
  120. public function getRecommendList()
  121. {
  122. $app_name = sysconf('app_name');
  123. $app_logo = sysconf('app_logo');
  124. $search_log = UserSearch::getSearchTitle($this->user_id,2);
  125. $search_arr = [];
  126. $where_str = 'b.id > 0';
  127. foreach ($search_log as $t){
  128. $search_arr[] = " b.title like '".'%'.$t."%'" .' ';
  129. $search_arr[] = " b.label like '".'%'.$t."%'" .' ';
  130. }
  131. if(!empty($search_arr)) $where_str = implode(' OR ',$search_arr);
  132. $field = ' a.id,a.title,a.cover,a.images,a.user_id,a.is_vip,a.read_num,a.article_id ,a.author,IFNULL(is_recommend,0) is_recommend ';
  133. $table = 'dd_article_item';
  134. $order_by_two = 'a.read_num';
  135. $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_article_intro as k ON k.id = a.article_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}";
  136. $list = Db::query($sql);
  137. $list = dispose_recommend($list);
  138. array_walk($list,function (&$v,$k)use ($app_name,$app_logo){
  139. $v['read_num'] = numTransform($v['read_num']);
  140. if(!$v['user_id']){
  141. $v['app_name'] = $app_name;
  142. $v['app_logo'] = $app_logo;
  143. }else{
  144. $user_info = User::where('id',$v['user_id'])->field('name,headimg')->find();
  145. $v['app_name'] = $user_info ? $user_info->name : '';
  146. $v['app_logo'] = $user_info ? $user_info->headimg : '';
  147. }
  148. $v['images_arr'] = $v['images'] ? explode('|',$v['images']):null;
  149. });
  150. $this->success('ok',['list'=>$list]);
  151. }
  152. /**
  153. * @title 获取图文列表(平台发布)
  154. * @desc 获取图文列表
  155. * @author qc
  156. * @method GET
  157. * @url /api/Article/getArticleList
  158. * @header name:Authorization require:1 desc:Token
  159. * @param name:type type:int default:0 desc:类型1单个2系列
  160. * @param name:is_tj type:int default:0 desc:是否推荐0否1是
  161. * @param name:title type:string default:-- desc:标题
  162. * @param name:page type:int default:0 desc:页数
  163. * @param name:page_num type:int default:20 desc:每页数
  164. * @param name:sort_type type:int default:1 desc:1默认2时间升序3时间降序
  165. * @param name:first_classify type:int default:0 desc:一级分类
  166. * @param name:second_classify type:int default:0 desc:二级分类
  167. * @return name:id type:string default:-- desc:ID[请求/api/Article/getArticleDetail用]
  168. * @return name:title type:string default:-- desc:标题
  169. * @return name:type type:int default:0 desc:类型1单个2系列
  170. * @return name:cover type:string default:-- desc:封面()
  171. * @return name:is_vip type:int default:-- desc:是否是vip(0否,1是)
  172. * @return name:is_over type:int default:-- desc:是否完结(0否,1是)
  173. * @return name:read_num type:int default:-- desc:阅读量
  174. * @return name:label type:string default:-- desc:标签
  175. * @return name:item_list type:array default:-- desc:图文
  176. * @return name:item_list.title type:string default:-- desc:图文标题
  177. * @return name:item_list.is_vip type:int default:-- desc:是否是vip
  178. * @return name:item_list.cover type:string default:-- desc:图文封面
  179. * @return name:item_list.images type:string default:-- desc:图片(多张用|隔开)
  180. * @return name:item_list.content type:string default:-- desc:内容
  181. * @return name:item_list.app_name type:string default:-- desc:发布方名称
  182. * @return name:item_list.app_logo type:string default:-- desc:发布方头像
  183. * @return name:item_list.content_type type:int default:1 desc:1富文本2pdf
  184. * @return name:item_list.pdf type:string default:-- desc:pdf文件路径
  185. */
  186. public function getArticleList()
  187. {
  188. $sel_where = [];
  189. $title = input('get.title');
  190. $type = input('get.type',0);
  191. $is_tj = input('get.is_tj',0);
  192. $sort_type = input('get.sort_type',1);
  193. $first_classify = input('get.first_classify');
  194. $second_classify = input('get.second_classify');
  195. $sel_where[] = ['is_deleted','=',0];
  196. $sel_where[] = ['status','=',1];
  197. $sel_where[] = ['item_num','>',0];
  198. if($title) $sel_where[] = ['title|label','like','%'.$title.'%'];
  199. if($type) $sel_where[] = ['type','=',$type];
  200. if($first_classify) $sel_where[] = ['first_classify','=',$first_classify];
  201. if($second_classify) $sel_where[] = ['second_classify','=',$second_classify];
  202. switch ($sort_type) {
  203. case 1:
  204. $order = ['sort'=>'desc','read_num'=>'desc'];
  205. break;
  206. case 2:
  207. $order = ['id'=>'asc','sort'=>'desc'];
  208. break;
  209. case 3:
  210. $order = ['id'=>'desc','sort'=>'desc'];
  211. break;
  212. }
  213. if($title && $this->user_id)UserSearch::saveSearchTitle($this->user_id,$title,2);
  214. $where_str = 'id > 0';
  215. if($is_tj) {
  216. $search_log = UserSearch::getSearchTitle($this->user_id,2);
  217. $search_arr = [];
  218. foreach ($search_log as $t){
  219. $search_arr[] = " title like '".'%'.$t."%'" .' ';
  220. }
  221. if(!empty($search_arr)) $where_str = implode(' OR ',$search_arr);
  222. }
  223. $list = ArticleIntro::where($sel_where)->with('itemList')
  224. ->limit($this->off_set,$this->page_num)
  225. ->where($where_str)
  226. ->order($order)
  227. ->select()->toArray();
  228. $app_name = sysconf('app_name');
  229. $app_logo = sysconf('app_logo');
  230. array_walk($list,function (&$v,$k)use ($app_name,$app_logo){
  231. $v['read_num']= array_sum(array_column($v['item_list'],'read_num'));
  232. $v['read_num'] = numTransform($v['read_num']);
  233. unset($v['content']);
  234. foreach ($v['item_list'] as &$iv) {
  235. unset($iv['content']);
  236. $iv['read_num'] = numTransform($iv['read_num']);
  237. if(!$iv['user_id']){
  238. $iv['app_name'] = $app_name;
  239. $iv['app_logo'] = $app_logo;
  240. }else{
  241. $user_info = User::where('id',$iv['user_id'])->field('name,headimg')->find();
  242. $iv['app_name'] = $user_info ? $user_info->name : '';
  243. $iv['app_logo'] = $user_info ? $user_info->headimg : '';
  244. }
  245. }
  246. });
  247. $this->success('ok',['list'=>$list]);
  248. }
  249. /**
  250. * @title 获取图文详情(平台【系列的合集列表】)
  251. * @desc 获取图文详情
  252. * @author qc
  253. * @method GET
  254. * @url /api/Article/getArticleDetail
  255. * @header name:Authorization require:1 desc:Token
  256. * @param name:id type:int default:0 desc:图文id
  257. * @param name:sort_type type:int default:1 desc:排序1默认2时间升序3时间降序
  258. * @param name:from type:string default:APP desc:请求来源(APP或H5)
  259. * @return name:title type:string default:-- desc:标题
  260. * @return name:cover type:string default:-- desc:封面
  261. * @return name:images type:string default:-- desc:图片
  262. * @return name:is_vip type:string default:-- desc:是否VIP
  263. * @return name:item_list type:array default:-- desc:图文
  264. * @return name:item_list.id type:string default:-- desc:[请求/api/Article/getArticleItemInfo用,请求图文模块其他接口参数:item_id]
  265. * @return name:item_list.title type:string default:-- desc:图文标题
  266. * @return name:item_list.is_vip type:int default:-- desc:是否是vip
  267. * @return name:item_list.cover type:string default:-- desc:封面
  268. * @return name:item_list.images type:int default:-- desc:图片
  269. * @return name:item_list.content type:int default:-- desc:内容
  270. * @return name:item_list.transmit_num type:int default:-- desc:转发量
  271. * @return name:item_list.read_num type:int default:-- desc:阅读量
  272. * @return name:item_list.comment_num type:int default:-- desc:评论量
  273. * @return name:item_list.collect_num type:int default:-- desc:收藏量
  274. * @return name:item_list.is_collect type:int default:-- desc:是否收藏
  275. * @return name:item_list.video_id type:int default:-- desc:关联视频id【单个id||系列id】
  276. * @return name:item_list.video_item type:int default:-- desc:关联视频详情id【video_arr.id】
  277. * @return name:item_list.datum_id type:int default:-- desc:资料id【单个id||系列id】
  278. * @return name:item_list.datum_item type:int default:-- desc:资料详情id【url_arr.id】
  279. * @return name:item_list.author type:string default:-- desc:原创作者
  280. * @return name:item_list.content_type type:int default:1 desc:1富文本2pdf
  281. * @return name:item_list.pdf type:string default:-- desc:pdf文件路径
  282. */
  283. public function getArticleDetail()
  284. {
  285. $form = input('get.from','H5');
  286. $sel_where = [];
  287. $sel_where[] = ['id','=',input('get.id')];
  288. $sort_type = input('get.sort_type',1);
  289. $detail = ArticleIntro::where($sel_where)->with(['itemList'=>function($query)use($sort_type){
  290. switch ($sort_type) {
  291. case 1:
  292. $order = ['sort'=>'desc','id'=>'asc'];
  293. break;
  294. case 2:
  295. $order = ['id'=>'asc','sort'=>'desc'];
  296. break;
  297. case 3:
  298. $order = ['id'=>'desc','sort'=>'desc'];
  299. break;
  300. }
  301. return $query->order($order);
  302. }])->find()->toArray();
  303. if($detail['is_deleted'] == 1 || $detail['status'] == 0)$this->error('该图文已下线');
  304. if($form == 'H5') $detail['content'] = openssl_encrypt($detail['content'],'DES-ECB',123456,0);
  305. $detail['read_num'] = array_sum(array_column($detail['item_list'],'read_num'));
  306. $detail['read_num'] = numTransform($detail['read_num']);
  307. foreach ($detail['item_list'] as &$dv) {
  308. if($form == 'H5') $dv['content'] = openssl_encrypt($dv['content'],'DES-ECB',123456,0);
  309. $dv['comment_num'] = ArticleComment::where(['article_id'=>$detail['id'],'item_id'=>$dv['id']])->count();
  310. $dv['comment_num'] = numTransform($dv['comment_num']);
  311. $dv['collect_num'] = UserCollect::where(['coll_type'=>3,'coll_id'=>$detail['id'],'children_id'=>$dv['id']])->count();
  312. $dv['comment_num'] = numTransform($dv['collect_num']);
  313. $dv['transmit_num'] = numTransform($dv['transmit_num']);
  314. $dv['is_collect'] = UserCollect::checkCollectByType($this->user_id,3,$detail['id'],$dv['id']);
  315. $dv['read_num'] = numTransform($dv['read_num']);
  316. }
  317. $this->success('ok',['detail'=>$detail]);
  318. }
  319. /**
  320. * @title 获取图文ITEM详情(平台)
  321. * @desc 获取图文ITEM详情
  322. * @author qc
  323. * @method GET
  324. * @url /api/Article/getArticleItemInfo
  325. * @header name:Authorization require:1 desc:Token
  326. * @param name:item_id type:int default:0 desc:item_list
  327. * @param name:from type:string default:APP desc:请求来源(APP或H5)
  328. * @return name:title type:string default:-- desc:图文标题
  329. * @return name:is_vip type:int default:-- desc:是否是vip
  330. * @return name:cover type:string default:-- desc:封面
  331. * @return name:images type:int default:-- desc:图片
  332. * @return name:content type:int default:-- desc:内容
  333. * @return name:transmit_num type:int default:-- desc:转发量
  334. * @return name:read_num type:int default:-- desc:阅读量
  335. * @return name:comment_num type:int default:-- desc:评论量
  336. * @return name:collect_num type:int default:-- desc:收藏量
  337. * @return name:is_collect type:int default:-- desc:是否收藏
  338. * @return name:like_num type:int default:-- desc:点赞量
  339. * @return name:is_like type:int default:-- desc:是否点赞
  340. * @return name:video_id type:int default:-- desc:关联视频id【单个id||系列id】
  341. * @return name:video_item type:int default:-- desc:关联视频详情id【video_arr.id】
  342. * @return name:datum_id type:int default:-- desc:资料id【单个id||系列id】
  343. * @return name:datum_item type:int default:-- desc:资料详情id【url_arr.id】
  344. * @return name:author type:string default:-- desc:原创作者
  345. * @return name:content_type type:int default:1 desc:1富文本2pdf
  346. * @return name:pdf type:string default:-- desc:pdf文件路径
  347. */
  348. public function getArticleItemInfo()
  349. {
  350. $item_id = input('get.item_id');
  351. $form = input('get.from','H5');
  352. $detail = ArticleItem::field('a.*,t.is_deleted td,t.status tus')->where('a.id',$item_id)->alias('a')->leftJoin('ArticleIntro t','t.id= a.article_id')->find()->toArray();
  353. if($detail['is_deleted'] == 1 || $detail['status'] == 0 || $detail['td'] == 1 || $detail['tus']==0) $this->error('图文已下架');
  354. $detail['comment_num'] = ArticleComment::where(['article_id'=>$detail['article_id'],'item_id'=>$detail['id']])->count();
  355. $detail['collect_num'] = UserCollect::where(['coll_type'=>3,'coll_id'=>$detail['article_id'],'children_id'=>$detail['id']])->count();
  356. $detail['is_collect'] = UserCollect::checkCollectByType($this->user_id,3,$detail['article_id'],$detail['id']);
  357. $detail['is_like'] = ArticleLike::where(['user_id'=>$this->user_id,'article_id'=>$detail['article_id'],'item_id'=>$detail['id']])->count();
  358. if($form == 'H5') $detail['content'] = openssl_encrypt($detail['content'],'DES-ECB',123456,0);
  359. $detail['like_num'] = ArticleLike::where(['article_id'=>$detail['article_id'],'item_id'=>$detail['id']])->count();
  360. $detail['like_num'] = numTransform($detail['like_num']);
  361. $detail['read_num'] = numTransform($detail['read_num']);
  362. $detail['comment_num'] = numTransform($detail['comment_num']);
  363. $detail['collect_num'] = numTransform($detail['collect_num']);
  364. $detail['transmit_num'] = numTransform($detail['transmit_num']);
  365. UserTrack::crateTrack($this->user_id,3,$detail['article_id'],$item_id);
  366. //var_dump($this->user_id,3,$detail['article_id'],$item_id);
  367. $this->success('ok',['detail'=>$detail]);
  368. }
  369. /**
  370. * @title 获取图文评论列表
  371. * @desc 获取图文评论列表
  372. * @author qc
  373. * @method GET
  374. * @url /api/Article/getArticleCommentList
  375. * @header name:Authorization require:1 desc:Token
  376. * @param name:article_id type:int default:-- desc:图文id
  377. * @param name:item_id type:int default:-- desc:item_id
  378. * @param name:sort_type type:int default:1 desc:排序1默认2时间升序3时间降序
  379. * @param name:page type:int default:-- desc:页数
  380. * @return name:name type:string default:-- desc:会员名称
  381. * @return name:headimg type:string default:-- desc:会员头像
  382. * @return name:content type:string default:-- desc:内容
  383. * @return name:parent type:array default:-- desc:评论上一级(数据同上【一维数组】)
  384. * @return name:children type:array default:-- desc:二级评论(数据同上【二维数组】)
  385. * @return name:like_num type:int default:-- desc:点赞数量
  386. * @return name:is_like type:int default:-- desc:是否点赞(0否1是)
  387. * @return name:is_top type:int default:-- desc:是否置顶(0否1是)
  388. * @return name:can_delete type:int default:-- desc:是否可以删除(0否1是)
  389. * @return name:total_num type:int default:-- desc:总评论数(仅一级)
  390. */
  391. public function getArticleCommentList()
  392. {
  393. $where = [];
  394. $where[] = ['c.article_id','=',input('get.article_id')];
  395. $where[] = ['c.is_deleted','=',0];
  396. $user_id = $this->user_id;
  397. $sort_type= input('sort_type',1);
  398. if(input('get.item_id')) $where[] = ['c.item_id','=',input('get.item_id')];
  399. switch ($sort_type) {
  400. case 1:
  401. $order = ['is_top'=>'desc','sort'=>'desc','id'=>'asc'];
  402. break;
  403. case 2:
  404. $order = ['is_top'=>'desc','id'=>'asc','sort'=>'desc'];
  405. break;
  406. case 3:
  407. $order = ['is_top'=>'desc','id'=>'desc','sort'=>'desc'];
  408. break;
  409. }
  410. $list =ArticleComment::where($where)
  411. ->alias('c')
  412. ->field('c.*,u.name,u.headimg')
  413. ->leftJoin('store_member u','u.id = c.user_id')
  414. ->order($order)
  415. ->limit($this->off_set,$this->page_num)
  416. ->select()->toArray();
  417. array_walk($list,function (&$val,$k)use($user_id){
  418. $children = ArticleComment::where(['c.pid'=>$val['id'],'c.is_deleted'=>0])
  419. ->alias('c')->field('c.*,u.name,u.headimg')
  420. ->leftJoin('store_member u','u.id = c.user_id')
  421. ->order('c.is_top desc,c.id asc')
  422. ->select()->toArray();
  423. $val['children'] = $children;
  424. $val['like_num'] = ArticleCommentLike::where('like_id',$val['id'])->count();
  425. $val['like_num'] = numTransform($val['like_num']);
  426. $val['is_like'] = ArticleCommentLike::where(['like_id'=>$val['id'],'user_id'=>$user_id])->count();
  427. $parent = ArticleComment::where(['c.id'=>$val['pid'],'c.is_deleted'=>0])
  428. ->alias('c')->field('c.*,u.name,u.headimg')
  429. ->leftJoin('store_member u','u.id = c.user_id')
  430. ->find();
  431. $val['parent'] = $parent ? $parent->toArray() : null;
  432. $val['can_delete'] = $val['user_id'] == $this->user_id ? 1 :0;
  433. });
  434. $total_num = ArticleComment::where($where)->alias('c')->count();
  435. $this->success('ok',['list'=>$list,'total_num'=>numTransform($total_num)]);
  436. }
  437. /**
  438. * @title 以下接口调用验证登录【需要header传Authorization】
  439. * @desc 转发成功后调用
  440. * @author qc
  441. * @method
  442. * @url /api/Article/needLogin()
  443. */
  444. public function needLogin(){}
  445. /**
  446. * @title 图文转发(转发数量统计)
  447. * @desc 转发成功后调用
  448. * @author qc
  449. * @method POST
  450. * @url /api/Article/articleTransmit
  451. * @header name:Authorization require:1 desc:Token
  452. * @param name:item_id type:int default:-- desc:item_list的id
  453. */
  454. public function articleTransmit()
  455. {
  456. $item_id = input('post.item_id',0);
  457. ArticleItem::where('id',$item_id)->setInc('transmit_num');
  458. $this->success('ok');
  459. }
  460. /**
  461. * @title 图文阅读(阅读数量统计)
  462. * @desc 图文阅读
  463. * @author qc
  464. * @method POST
  465. * @url /api/Article/articleRead
  466. * @header name:Authorization require:1 desc:Token
  467. * @param name:item_id type:int default:-- desc:item_list的id
  468. */
  469. public function articleRead()
  470. {
  471. $item_id = input('post.item_id',0);
  472. $article_id = ArticleItem::where('id',$item_id)->value('article_id');
  473. ArticleItem::where('id',$item_id)->setInc('read_num');
  474. ArticleIntro::where('id',$article_id)->setInc('read_num');
  475. $this->success('ok');
  476. }
  477. /**
  478. * @title 图文点赞||取消点赞
  479. * @desc 点赞||取消点赞
  480. * @author qc
  481. * @method POST
  482. * @url /api/Article/articleTags
  483. * @header name:Authorization require:1 desc:Token
  484. * @param name:article_id type:int default:1 desc:图文id
  485. * @param name:item_id type:int default:1 desc:item_id
  486. * @return name:tags type:int default:1 desc:0取消成功,1点赞成功
  487. */
  488. public function articleTags()
  489. {
  490. $article_id = input('post.article_id');
  491. $item_id = input('post.item_id');
  492. $ret_val = 0;
  493. $check_tags = ArticleLike::where(['user_id'=>$this->user_id,'article_id'=>$article_id,'item_id'=>$item_id])->value('id');
  494. if($check_tags) {
  495. ArticleLike::where(['user_id'=>$this->user_id,'article_id'=>$article_id,'item_id'=>$item_id])->delete();
  496. }else{
  497. Data::save('ArticleLike',
  498. ['user_id'=>$this->user_id,'article_id'=>$article_id,'item_id'=>$item_id],'user_id',
  499. ['user_id'=>$this->user_id,'article_id'=>$article_id,'item_id'=>$item_id]);
  500. $ret_val = 1;
  501. }
  502. $this->success($ret_val == 1 ?'点赞成功':'取消成功',['tags'=>$ret_val]);
  503. }
  504. /**
  505. * @title 图文评论
  506. * @desc 图文评论
  507. * @author qc
  508. * @method POST
  509. * @url /api/Article/articleComment
  510. * @header name:Authorization require:1 desc:Token
  511. * @param name:article_id type:int default:1 desc:图文id
  512. * @param name:item_id type:int default:1 desc:item_id
  513. * @param name:content type:string default:-- desc:内容
  514. * @return name:name type:string default:-- desc:会员名称
  515. * @return name:headimg type:string default:-- desc:会员头像
  516. * @return name:content type:string default:-- desc:内容
  517. */
  518. public function articleComment()
  519. {
  520. $article_id = input('post.article_id');
  521. $item_id = input('post.item_id');
  522. $content = input('post.content',0);
  523. if(!$content) $this->error('请输入评论内容');
  524. $res = ArticleComment::create(['user_id'=>$this->user_id,'content'=>$content,'article_id'=>$article_id,'item_id'=>$item_id]);
  525. $detail =ArticleComment::where('c.id',$res->id)
  526. ->alias('c')
  527. ->field('c.id,c.content,c.create_at,u.name,u.headimg')
  528. ->leftJoin('store_member u','u.id = c.user_id')
  529. ->find()->toArray();
  530. $send_user = ArticleItem::where('id',$item_id)->value('user_id');
  531. $user_info = $this->userInfo('name');
  532. if($send_user) UserMessage:: sendUserMessage($send_user,'article',4,0,$this->user_id,$item_id,$user_info['name'].'评论了您的图文');
  533. $this->success('评论成功',['detail'=>$detail]);
  534. }
  535. /**
  536. * @title 删除评论
  537. * @desc 删除评论
  538. * @author qc
  539. * @method POST
  540. * @url /api/Article/delComment
  541. * @header name:Authorization require:1 desc:Token
  542. * @param name:id type:int default:1 desc:评论id
  543. */
  544. public function delComment(){
  545. ArticleComment::where(['id'=>input('post.id'),'user_id'=>$this->user_id])->update(['is_deleted'=>1]);
  546. $this->success('删除成功');
  547. }
  548. /**
  549. * @title 图文二级评论
  550. * @desc 图文二级评论
  551. * @author qc
  552. * @method POST
  553. * @url /api/Article/secondCommend
  554. * @header name:Authorization require:1 desc:Token
  555. * @param name:id type:int default:1 desc:评论id
  556. * @param name:content type:string default:-- desc:内容
  557. * @return name:name type:string default:-- desc:会员名称
  558. * @return name:headimg type:string default:-- desc:会员头像
  559. * @return name:content type:string default:-- desc:内容
  560. */
  561. public function secondCommend()
  562. {
  563. $comment = ArticleComment::where('id',input('post.id'))->find()->toArray();
  564. $user_info = $this->userInfo('name');
  565. UserMessage:: sendUserMessage($comment['user_id'],'article',3,0,$this->user_id,$comment['id'],$user_info['name'].'回复了您的评论');
  566. $send_user = ArticleItem::where('id',$comment['item_id'])->value('user_id');
  567. if($send_user) UserMessage:: sendUserMessage($send_user,'article',4,0,$this->user_id,$comment['item_id'],$user_info['name'].'评论了您的图文');
  568. unset($comment['id']);
  569. unset($comment['create_at']);
  570. $comment['pid'] = input('post.id');
  571. $comment['user_id'] = $this->user_id;
  572. $comment['content'] = input('post.content');
  573. $comment['lev']++;
  574. if(!$comment['source_id']) $comment['source_id'] = input('post.id');
  575. $res = ArticleComment::create($comment);
  576. $detail = ArticleComment::where('c.id',$res->id)
  577. ->alias('c')
  578. ->field('c.id,c.content,c.create_at,u.name,u.headimg')
  579. ->leftJoin('store_member u','u.id = c.user_id')
  580. ->find()->toArray();
  581. $this->success('评论成功',['detail'=>$detail]);
  582. }
  583. /**
  584. * @title 评论点赞||取消点赞
  585. * @desc 评论
  586. * @author qc
  587. * @method POST
  588. * @url /api/Article/commentTags
  589. * @header name:Authorization require:1 desc:Token
  590. * @param name:comment_id type:int default:1 desc:评论记录id
  591. * @return name:tags type:int default:1 desc:0取消成功,1点赞成功
  592. */
  593. public function commentTags()
  594. {
  595. $comment_id = input('post.comment_id');
  596. $ret_val = 0;
  597. $check_tags = ArticleCommentLike::where(['user_id'=>$this->user_id,'like_id'=>$comment_id])->value('id');
  598. if($check_tags) {
  599. ArticleCommentLike::where(['user_id'=>$this->user_id,'like_id'=>$comment_id])->delete();
  600. }else{
  601. Data::save('ArticleCommentLike',
  602. ['user_id'=>$this->user_id,'like_id'=>$comment_id,],'user_id',
  603. ['user_id'=>$this->user_id,'like_id'=>$comment_id]);
  604. $ret_val = 1;
  605. }
  606. $this->success($ret_val == 1 ?'点赞成功':'取消成功',['tags'=>$ret_val]);
  607. }
  608. /**
  609. * @title 图文收藏||取消收藏
  610. * @desc 用户收藏
  611. * @author qc
  612. * @method POST
  613. * @url /api/Article/articleCollect
  614. * @header name:Authorization require:1 desc:Token
  615. * @param name:article_id type:int require:1 default:-- desc:记录id[图文id]
  616. * @param name:item_id type:int default:1 desc:item_id
  617. * @param name:status type:int default:0 desc:收藏状态(0取消收藏【未收藏】,1收藏)
  618. */
  619. public function articleCollect()
  620. {
  621. $coll_type = input('post.coll_type',3);
  622. $coll_id = input('post.article_id',0);
  623. $item_id = input('post.item_id',0);
  624. $collect_check = UserCollect::checkCollectByType($this->user_id,$coll_type,$coll_id,$item_id);
  625. if($collect_check) {
  626. UserCollect::where(['user_id'=>$this->user_id,'coll_type'=>$coll_type,'coll_id'=>$coll_id,'children_id'=>$item_id])->delete();
  627. $this->success('取消收藏成功',['status'=>0]);
  628. }else{
  629. Data::save('UserCollect', [
  630. 'user_id'=>$this->user_id,
  631. 'coll_type'=>$coll_type,
  632. 'coll_id'=>$coll_id,
  633. 'children_id'=>$item_id,
  634. 'create_int'=>time()],'user_id',['user_id'=>$this->user_id,'coll_type'=>$coll_type, 'coll_id'=>$coll_id,'children_id'=>$item_id]);
  635. $this->success('收藏成功',['status'=>1]);
  636. }
  637. }
  638. /**
  639. * @title 用户提交或修改图文【个人】
  640. * @desc 用户提交或修改图文【个人】
  641. * @author qc
  642. * @method POST
  643. * @url /api/Article/userReferArticle
  644. * @header name:Authorization require:1 desc:Token
  645. * @param name:id type:int default:-- desc:id(修改时必传)
  646. * @param name:title type:string default:-- desc:标题
  647. * @param name:images type:string default:-- desc:图片(多张用|隔开)
  648. * @param name:desc type:string default:-- desc:简介
  649. * @param name:label type:string default:-- desc:图文标签
  650. * @param name:document type:string default:-- desc:文件路径【单文件】
  651. */
  652. public function userReferArticle()
  653. {
  654. $id = input('post.id',0);
  655. $title = input('post.title');
  656. $desc = input('post.desc');
  657. $images = input('post.images');
  658. $label = input('post.label');
  659. $document = input('post.document');
  660. //if(!$images) $this->error('请上传图文');
  661. if($id){
  662. $check_status = UserArticle::where('id',$id)->value('status');
  663. if($check_status == 1) $this->error('已审核通过,不允许修改');
  664. }
  665. $data = [
  666. 'title' => $title,
  667. 'user_id' => $this->user_id,
  668. 'desc' => $desc,
  669. 'images' => $images,
  670. 'label' => $label,
  671. 'document' => $document,
  672. 'cover' => $images ? explode('|',$images)[0] : '',
  673. 'status' => 0,
  674. 'remark' => '',
  675. ];
  676. if($id) $data['id'] = $id;
  677. if($id){
  678. UserArticle::where('id',$id)->update($data);
  679. }else{
  680. $res= UserArticle::create($data) ;
  681. }
  682. UserMessage::sendUserMessage($this->user_id,'article',1,0,0,$id ? $id:$res->id);
  683. $this->success('提交成功,请等待审核',['id'=> $id ? :$res->id]);
  684. }
  685. /**
  686. * @title 获取我的图文列表【个人--我的发布列表】
  687. * @desc 获取我的图文列表【个人】
  688. * @author qc
  689. * @method GET
  690. * @url /api/Article/getMyArticleList
  691. * @header name:Authorization require:1 desc:Token
  692. * @param name:title type:string default:-- desc:标题
  693. * @param name:page type:int default:0 desc:页数
  694. * @param name:page_num type:int default:20 desc:每页数
  695. * @return name:title type:string default:-- desc:标题
  696. * @return name:desc type:string default:-- desc:简介
  697. * @return name:images type:string default:-- desc:图文【多张|隔开】
  698. * @return name:status type:int default:-- desc:0待审核1审核通过2审核未通过
  699. * @return name:remark type:string default:-- desc:审核备注
  700. */
  701. public function getMyArticleList()
  702. {
  703. $sel_where = [];
  704. $sel_where[] = ['is_deleted','=',0];
  705. $sel_where[] = ['user_id','=',$this->user_id];
  706. $title = input('get.title');
  707. if($title) $sel_where[] = ['title|label','like','%'.$title.'%'];
  708. $list = UserArticle::where($sel_where)
  709. ->field('id,title,desc,images,status,remark')
  710. ->order('id desc')
  711. ->limit($this->off_set,$this->page_num)
  712. ->select()->toArray();
  713. $this->success('ok',['list'=>$list]);
  714. }
  715. /**
  716. * @title 获取我的图文详情【个人】
  717. * @desc 获取我的图文列表【个人】
  718. * @author qc
  719. * @method GET
  720. * @url /api/Article/getUserArticleDetail
  721. * @header name:Authorization require:1 desc:Token
  722. * @param name:id type:string default:-- desc:记录id
  723. * @return name:title type:string default:-- desc:标题
  724. * @return name:desc type:string default:-- desc:简介
  725. * @return name:images type:string default:-- desc:图文[多张|隔开]
  726. * @return name:status type:int default:-- desc:0待审核1审核通过2审核未通过
  727. * @return name:remark type:string default:-- desc:审核备注
  728. * @return name:label type:string default:-- desc:标签
  729. * @return name:document type:string default:-- desc:文件路径
  730. */
  731. public function getUserArticleDetail()
  732. {
  733. $detail =UserArticle::where('id',input('get.id'))->field('id,title,desc,images,status,remark,label,document')->find();
  734. if(!$detail) $this->error('图文有误');
  735. $this->success('ok',['detail'=>$detail->toArray()]);
  736. }
  737. /**
  738. * @title 用户删除图文记录【个人】
  739. * @desc 用户删除图文记录【个人】
  740. * @author qc
  741. * @method POST
  742. * @url /api/Article/delUserArticle
  743. * @header name:Authorization require:1 desc:Token
  744. * @param name:id type:int default:-- desc:id
  745. */
  746. public function delUserArticle()
  747. {
  748. UserArticle::where(['user_id'=>$this->user_id,'id'=>input('post.id')])->delete();
  749. $this->success('删除成功');
  750. }
  751. /**
  752. * @title 以下接口学习服务模块的
  753. * @desc
  754. * @author qc
  755. * @method
  756. * @url /api/Article/learn()
  757. */
  758. public function learn(){}
  759. /**
  760. * @title 图文学习历史
  761. * @desc 图文学习历史
  762. * @author qc
  763. * @method GET
  764. * @url /api/Article/getLearnHistory
  765. * @header name:Authorization require:1 desc:Token
  766. * @param name:title type:string default:-- desc:标题
  767. * @param name:page type:int default:0 desc:页数
  768. * @param name:page_num type:int default:20 desc:每页数
  769. * @return name:title type:string default:-- desc:标题
  770. * @return name:article_id type:string default:-- desc:文章id
  771. * @return name:item_id type:string default:-- desc:item_id
  772. * @return name:cover type:string default:-- desc:封面
  773. * @return name:time type:string default:-- desc:时间
  774. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  775. */
  776. public function getLearnHistory()
  777. {
  778. $sel_where = [];
  779. $sel_where[] = ['t.user_id','=',$this->user_id];
  780. $sel_where[] = ['t.type','=',3];
  781. $title = input('get.title');
  782. if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
  783. $list = UserTrack::where($sel_where)
  784. ->alias('t')
  785. ->field('t.id,t.update_int,t.first_id article_id,t.second_id item_id,i.title,i.cover')
  786. ->leftJoin('ArticleItem i','t.second_id = i.id')
  787. ->order('update_int desc')
  788. ->limit($this->off_set,$this->page_num)
  789. ->select()->toArray();
  790. foreach ($list as &$v) {
  791. $v['time'] = date("Y-m-d H:i:s",$v['update_int']);
  792. $v['is_normal'] = CheckPower::checkModulesPower($v['article_id'],$v['item_id'],$this->request->controller());
  793. }
  794. $this->success('ok',['list'=>$list]);
  795. }
  796. /**
  797. * @title 图文收藏记录
  798. * @desc 图文收藏记录
  799. * @author qc
  800. * @method GET
  801. * @url /api/Article/getArticleCollect
  802. * @header name:Authorization require:1 desc:Token
  803. * @param name:title type:string default:-- desc:标题
  804. * @param name:page type:int default:0 desc:页数
  805. * @param name:page_num type:int default:20 desc:每页数
  806. * @return name:title type:string default:-- desc:标题
  807. * @return name:read_num type:int default:-- desc:阅读量
  808. * @return name:article_id type:string default:-- desc:文章id
  809. * @return name:item_id type:string default:-- desc:item_id
  810. * @return name:cover type:string default:-- desc:封面
  811. * @return name:create_at type:string default:-- desc:时间
  812. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  813. */
  814. public function getArticleCollect()
  815. {
  816. $sel_where = [];
  817. $title = input('get.title');
  818. if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
  819. $sel_where[] = ['t.user_id','=',$this->user_id];
  820. $sel_where[] = ['t.coll_type','=',3];
  821. $list = UserCollect::where($sel_where)
  822. ->alias('t')
  823. ->field('t.id,t.create_at,t.coll_id article_id,t.children_id item_id,i.title,i.cover,i.read_num')
  824. ->leftJoin('ArticleItem i','t.children_id = i.id')
  825. ->order('id desc')
  826. ->limit($this->off_set,$this->page_num)
  827. ->select()->toArray();
  828. array_walk($list,function (&$v){
  829. $v['read_num'] = numTransform($v['read_num']);
  830. $v['is_normal'] = CheckPower::checkModulesPower($v['article_id'],$v['item_id'],$this->request->controller());
  831. });
  832. $this->success('ok',['list'=>$list]);
  833. }
  834. /**
  835. * @title 我的评论【学习服务--我评论过的图文】
  836. * @desc 我的评论
  837. * @author qc
  838. * @method GET
  839. * @url /api/Article/getCommentArticle
  840. * @header name:Authorization require:1 desc:Token
  841. * @param name:title type:string default:-- desc:标题
  842. * @param name:page type:int default:0 desc:页数
  843. * @param name:page_num type:int default:20 desc:每页数
  844. * @return name:title type:string default:-- desc:标题
  845. * @return name:article_id type:string default:-- desc:文章id
  846. * @return name:item_id type:string default:-- desc:item_id
  847. * @return name:cover type:string default:-- desc:封面
  848. * @return name:is_top type:int default:-- desc:是否置顶(0否1是)
  849. * @return name:create_at type:string default:-- desc:时间
  850. * @return name:user_name type:string default:-- desc:用户名【用户自己的】
  851. * @return name:headimg type:string default:-- desc:用户头像【用户自己的】
  852. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  853. */
  854. public function getCommentArticle()
  855. {
  856. $user_info = $this->userInfo();
  857. $sel_where = [];
  858. $title = input('get.title');
  859. if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
  860. $sel_where[] = ['t.user_id','=',$this->user_id];
  861. $sel_where[] = ['t.is_deleted','=',0];
  862. $sel_where[] = ['t.lev','=',1];
  863. $list = ArticleComment::where($sel_where)
  864. ->alias('t')
  865. ->field('t.id,t.create_at,t.article_id,t.item_id,t.is_top,t.lev,t.content,i.title,i.cover')
  866. ->leftJoin('ArticleItem i','t.item_id = i.id')
  867. ->order('t.is_top desc,id desc')
  868. ->limit($this->off_set,$this->page_num)
  869. ->select()->toArray();
  870. foreach ($list as &$v)
  871. {
  872. $v['user_name'] = $user_info['name'];
  873. $v['headimg'] = $user_info['headimg'];
  874. $v['is_normal'] = CheckPower::checkModulesPower($v['article_id'],$v['item_id'],$this->request->controller());
  875. }
  876. $this->success('ok',['list'=>$list]);
  877. }
  878. /**
  879. * @title 评论我的【学习服务--评论我的】
  880. * @desc 评论我的
  881. * @author qc
  882. * @method GET
  883. * @url /api/Article/commentMyArticle
  884. * @header name:Authorization require:1 desc:Token
  885. * @param name:title type:string default:-- desc:标题
  886. * @param name:page type:int default:0 desc:页数
  887. * @param name:page_num type:int default:20 desc:每页数
  888. * @return name:title type:string default:-- desc:标题
  889. * @return name:article_id type:string default:-- desc:文章id
  890. * @return name:item_id type:string default:-- desc:item_id
  891. * @return name:cover type:string default:-- desc:封面
  892. * @return name:is_read type:int default:-- desc:是否已读(0未读1已读)
  893. * @return name:is_top type:int default:-- desc:是否置顶(0否1是)
  894. * @return name:create_at type:string default:-- desc:时间
  895. * @return name:user_name type:string default:-- desc:用户名
  896. * @return name:headimg type:string default:-- desc:用户头像
  897. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  898. */
  899. public function commentMyArticle()
  900. {
  901. $sel_where = [];
  902. $title = input('get.title');
  903. if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
  904. $sel_where[] = ['t.is_deleted','=',0];
  905. $sel_where[] = ['i.user_id','=',$this->user_id];
  906. $list = ArticleComment::where($sel_where)
  907. ->alias('t')
  908. ->field('t.id,t.is_read,t.is_top,t.create_at,t.article_id,t.item_id,t.lev,t.content,i.title,i.cover,u.name user_name,u.headimg')
  909. ->leftJoin('ArticleItem i','t.item_id = i.id')
  910. ->leftJoin('store_member u','t.user_id = u.id')
  911. ->order('t.is_top desc,t.id desc')
  912. ->limit($this->off_set,$this->page_num)
  913. ->select()->toArray();
  914. array_walk($list,function (&$v){
  915. $v['is_normal'] = CheckPower::checkModulesPower($v['article_id'],$v['item_id'],$this->request->controller());
  916. });
  917. $this->success('ok',['list'=>$list]);
  918. }
  919. /**
  920. * @title 已购图文列表
  921. * @desc 已购图文列表
  922. * @author qc
  923. * @method GET
  924. * @url /api/Article/getPurchaseArticle
  925. * @header name:Authorization require:1 desc:Token
  926. * @param name:title type:string default:-- desc:标题
  927. * @param name:page type:int default:0 desc:页数
  928. * @param name:page_num type:int default:20 desc:每页数
  929. * @return name:title type:string default:-- desc:标题
  930. * @return name:article_id type:string default:-- desc:文章id
  931. * @return name:item_id type:string default:-- desc:item_id
  932. * @return name:cover type:string default:-- desc:封面
  933. * @return name:create_at type:string default:-- desc:时间
  934. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  935. */
  936. public function getPurchaseArticle()
  937. {
  938. $sel_where = [];
  939. $title = input('get.title');
  940. if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
  941. $sel_where[] = ['t.user_id','=',$this->user_id];
  942. $sel_where[] = ['t.type','=',3];
  943. $sel_where[] = ['t.end_int','>',time()];
  944. $list = UserLearn::where($sel_where)
  945. ->alias('t')
  946. ->field('t.id,t.create_at,t.first_id article_id,t.second_id item_id,i.title,i.cover')
  947. ->leftJoin('ArticleItem i','t.second_id = i.id')
  948. ->order('id desc')
  949. ->limit($this->off_set,$this->page_num)
  950. ->select()->toArray();
  951. array_walk($list,function (&$v){
  952. $v['is_normal'] = CheckPower::checkModulesPower($v['article_id'],$v['item_id'],$this->request->controller());
  953. });
  954. $this->success('ok',['list'=>$list]);
  955. }
  956. /**
  957. * @title 我的回复【我的回复--我回复过的评论】
  958. * @desc 我的评论
  959. * @author qc
  960. * @method GET
  961. * @url /api/Article/getReplyArticle
  962. * @header name:Authorization require:1 desc:Token
  963. * @param name:title type:string default:-- desc:标题
  964. * @param name:page type:int default:0 desc:页数
  965. * @param name:page_num type:int default:20 desc:每页数
  966. * @return name:title type:string default:-- desc:标题
  967. * @return name:article_id type:string default:-- desc:文章id
  968. * @return name:item_id type:string default:-- desc:item_id
  969. * @return name:cover type:string default:-- desc:封面
  970. * @return name:create_at type:string default:-- desc:时间
  971. * @return name:is_top type:int default:-- desc:是否置顶(0否1是)
  972. * @return name:user_name type:string default:-- desc:用户名【用户自己的】
  973. * @return name:headimg type:string default:-- desc:用户头像【用户自己的】
  974. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  975. * @return name:parent_comment type:array default:-- desc:上级评论内容【你评论的那个评论】
  976. * @return name:parent_comment.content type:string default:-- desc:内容
  977. * @return name:parent_comment.name type:string default:-- desc:会员名称
  978. * @return name:parent_comment.title type:string default:-- desc:图文标题
  979. * @return name:parent_comment.article_id type:string default:-- desc:文章id
  980. * @return name:parent_comment.item_id type:string default:-- desc:item_id
  981. */
  982. public function getReplyArticle()
  983. {
  984. $user_info = $this->userInfo();
  985. $sel_where = [];
  986. $title = input('get.title');
  987. if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
  988. $sel_where[] = ['t.user_id','=',$this->user_id];
  989. $sel_where[] = ['t.is_deleted','=',0];
  990. $sel_where[] = ['t.lev','>=',2];
  991. $list = ArticleComment::where($sel_where)
  992. ->alias('t')
  993. ->field('t.id,t.article_id,t.is_top,t.item_id,t.create_at,t.lev,t.content,i.title,t.pid')
  994. ->leftJoin('ArticleItem i','t.item_id = i.id')
  995. ->order('t.is_top desc,t.id desc')
  996. ->limit($this->off_set,$this->page_num)
  997. ->select()->toArray();
  998. foreach ($list as &$v) {
  999. $v['user_name'] = $user_info['name'];
  1000. $v['headimg'] = $user_info['headimg'];
  1001. $v['is_normal'] = CheckPower::checkModulesPower($v['article_id'],$v['item_id'],$this->request->controller());
  1002. $parent_comment = ArticleComment::where([['t.id','=',$v['pid']]])
  1003. ->field('t.id,t.article_id,t.is_top,t.item_id,t.content,i.title,i.cover,t.pid,u.name')
  1004. ->alias('t')
  1005. ->leftJoin('ArticleItem i','t.item_id = i.id')
  1006. ->leftJoin('store_member u','t.user_id = u.id')
  1007. ->find()->toArray();
  1008. $v['parent_comment'] = $parent_comment;
  1009. }
  1010. $this->success('ok',['list'=>$list]);
  1011. }
  1012. /**
  1013. * @title 获取角标数量
  1014. * @desc 获取角标数量
  1015. * @author qc
  1016. * @method GET
  1017. * @url /api/Article/getMarkNum
  1018. * @header name:Authorization require:1 desc:Token
  1019. * @return name:reply_num type:int default:-- desc:未读量--回复我的
  1020. * @return name:comment_num type:int default:-- desc:未读量--评论我的
  1021. */
  1022. public function getMarkNum()
  1023. {
  1024. // 回复我的
  1025. $all_comment = ArticleComment::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
  1026. $reply_num = ArticleComment::where([['t.is_deleted','=',0],['t.lev','>=',2],['is_read','=',0],['t.pid','in',implode(',',$all_comment)]])->alias('t')->count();
  1027. // 评论我的
  1028. $comment_num = ArticleComment::where([['t.is_deleted','=',0],['i.user_id','=',$this->user_id],['is_read','=',0]])
  1029. ->leftJoin('ArticleItem i','t.item_id = i.id')
  1030. ->alias('t')->count();
  1031. $this->success('ok',compact(['reply_num','comment_num']));
  1032. }
  1033. /**
  1034. * @title 消息已读
  1035. * @desc 消息已读
  1036. * @author qc
  1037. * @method POST
  1038. * @url /api/Article/unreadChange
  1039. * @header name:Authorization require:1 desc:Token
  1040. * @param name:id type:string default:-- desc:记录id【不区分类型】
  1041. */
  1042. public function unreadChange()
  1043. {
  1044. ArticleComment::where('id',input('post.id'))->update(['is_read'=>1]);
  1045. $this->success('ok');
  1046. }
  1047. /**
  1048. * @title 回复我的【回复我的--回复过我的评论】
  1049. * @desc 回复我的
  1050. * @author qc
  1051. * @method GET
  1052. * @url /api/Article/getReplyComment
  1053. * @header name:Authorization require:1 desc:Token
  1054. * @param name:title type:string default:-- desc:标题
  1055. * @param name:page type:int default:0 desc:页数
  1056. * @param name:page_num type:int default:20 desc:每页数
  1057. * @return name:title type:string default:-- desc:标题
  1058. * @return name:article_id type:string default:-- desc:文章id
  1059. * @return name:item_id type:string default:-- desc:item_id
  1060. * @return name:cover type:string default:-- desc:封面
  1061. * @return name:is_read type:int default:-- desc:是否已读(0未读1已读)
  1062. * @return name:is_top type:int default:-- desc:是否置顶(0否1是)
  1063. * @return name:create_at type:string default:-- desc:时间
  1064. * @return name:user_name type:string default:-- desc:用户名【其他会员】
  1065. * @return name:headimg type:string default:-- desc:用户头【其他会员】
  1066. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  1067. * @return name:parent_comment type:array default:-- desc:你的评论内容【别人回复的那个评论】
  1068. * @return name:parent_comment.content type:string default:-- desc:内容
  1069. * @return name:parent_comment.name type:string default:-- desc:会员名称
  1070. * @return name:parent_comment.title type:string default:-- desc:图文标题
  1071. * @return name:parent_comment.article_id type:string default:-- desc:文章id
  1072. * @return name:parent_comment.item_id type:string default:-- desc:item_id
  1073. */
  1074. public function getReplyComment()
  1075. {
  1076. $all_comment = ArticleComment::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
  1077. if(empty($all_comment)) $this->success('ok',['list'=>null]);
  1078. $sel_where = [];
  1079. $title = input('get.title');
  1080. if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
  1081. $sel_where[] = ['t.is_deleted','=',0];
  1082. $sel_where[] = ['t.lev','>=',2];
  1083. //$sel_where[] = ['t.user_id','<>',$this->user_id];
  1084. $sel_where[] = ['t.pid','in',implode(',',$all_comment)];
  1085. $list = ArticleComment::where($sel_where)
  1086. ->alias('t')
  1087. ->field('t.id,t.is_read,t.article_id,t.is_top,t.item_id,t.create_at,t.lev,t.content,t.pid,u.name user_name,u.headimg')
  1088. ->leftJoin('store_member u','t.user_id = u.id')
  1089. ->leftJoin('ArticleItem i','t.item_id = i.id')
  1090. ->order('t.is_top desc,t.id desc')
  1091. ->limit($this->off_set,$this->page_num)
  1092. ->select()->toArray();
  1093. foreach ($list as &$v) {
  1094. $v['is_normal'] = CheckPower::checkModulesPower($v['article_id'],$v['item_id'],$this->request->controller());
  1095. $parent_comment = ArticleComment::where([['t.id','=',$v['pid']]])
  1096. ->field('t.id,t.article_id,t.is_top,t.item_id,t.content,i.title,i.cover,t.pid,u.name')
  1097. ->alias('t')
  1098. ->leftJoin('ArticleItem i','t.item_id = i.id')
  1099. ->leftJoin('store_member u','t.user_id = u.id')
  1100. ->find()->toArray();
  1101. $v['parent_comment'] = $parent_comment;
  1102. }
  1103. $this->success('ok',['list'=>$list]);
  1104. }
  1105. /**
  1106. * @title 图文点赞列表【我的点赞】
  1107. * @desc 图文点赞列表
  1108. * @author qc
  1109. * @method GET
  1110. * @url /api/Article/getTagsArticle
  1111. * @header name:Authorization require:1 desc:Token
  1112. * @param name:title type:string default:-- desc:标题
  1113. * @param name:page type:int default:0 desc:页数
  1114. * @param name:page_num type:int default:20 desc:每页数
  1115. * @return name:title type:string default:-- desc:标题
  1116. * @return name:article_id type:string default:-- desc:文章id
  1117. * @return name:item_id type:string default:-- desc:item_id
  1118. * @return name:like_num type:string default:-- desc:点赞量
  1119. * @return name:is_like type:string default:-- desc:是否点赞[0否1是]
  1120. * @return name:cover type:string default:-- desc:封面
  1121. * @return name:is_vip type:int default:-- desc:是否vip[0否1是]
  1122. * @return name:create_at type:string default:-- desc:时间
  1123. * @return name:read_num type:int default:-- desc:阅读量
  1124. * @return name:images_arr type:array default:-- desc:图片
  1125. * @return name:app_name type:string default:-- desc:发布方名称
  1126. * @return name:app_logo type:string default:-- desc:发布方头像
  1127. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  1128. */
  1129. public function getTagsArticle()
  1130. {
  1131. $app_name = sysconf('app_name');
  1132. $app_logo = sysconf('app_logo');
  1133. $sel_where = [];
  1134. $title = input('get.title');
  1135. if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
  1136. $sel_where[] = ['t.user_id','=',$this->user_id];
  1137. $list = ArticleLike::where($sel_where)
  1138. ->alias('t')
  1139. ->field('t.id,t.create_at,t.article_id,t.item_id,i.title,i.cover,i.is_vip,images,i.read_num,i.user_id')
  1140. ->leftJoin('ArticleItem i','t.item_id = i.id')
  1141. ->order('id desc')
  1142. ->limit($this->off_set,$this->page_num)
  1143. ->select()->toArray();
  1144. foreach ($list as &$v) {
  1145. $v['like_num'] = ArticleLike::where(['article_id'=>$v['article_id'],'item_id'=>$v['item_id']])->count();
  1146. $v['like_num'] = numTransform($v['like_num']);
  1147. $v['read_num'] = numTransform($v['read_num']);
  1148. $v['is_like'] = ArticleLike::where(['user_id'=>$this->user_id,'article_id'=>$v['article_id'],'item_id'=>$v['item_id']])->count();
  1149. $v['images_arr'] = $v['images'] ? explode('|',$v['images']):null;
  1150. $v['is_normal'] = CheckPower::checkModulesPower($v['article_id'],$v['item_id'],$this->request->controller());
  1151. if(!$v['user_id']){
  1152. $v['app_name'] = $app_name;
  1153. $v['app_logo'] = $app_logo;
  1154. }else{
  1155. $user_info = User::where('id',$v['user_id'])->field('name,headimg')->find();
  1156. $v['app_name'] = $user_info ? $user_info->name : '';
  1157. $v['app_logo'] = $user_info ? $user_info->headimg : '';
  1158. }
  1159. }
  1160. $this->success('ok',['list'=>$list]);
  1161. }
  1162. /**
  1163. * @title 以下接口为二期需求
  1164. * @desc 以下接口为二期需求
  1165. * @author qc
  1166. * @url /api/Article/secondPhase
  1167. * @method
  1168. * @return name:1 type:string default:-- desc:以下接口为二期需求
  1169. */
  1170. public function secondPhase(){}
  1171. /**
  1172. * @title 我的绑定【后台图文绑定该会员】
  1173. * @desc 后台图文绑定该会员
  1174. * @author qc
  1175. * @method GET
  1176. * @url /api/Article/getBoundList
  1177. * @header name:Authorization require:1 desc:Token
  1178. * @param name:title type:string default:-- desc:标题
  1179. * @param name:page type:int default:0 desc:页数
  1180. * @param name:page_num type:int default:20 desc:每页数
  1181. * @return name:id type:string default:-- desc:记录id【item_id】
  1182. * @return name:title type:string default:-- desc:标题
  1183. * @return name:article_id type:string default:-- desc:图文id
  1184. * @return name:cover type:string default:-- desc:封面
  1185. * @return name:create_at type:string default:-- desc:时间
  1186. * @return name:is_vip type:int default:-- desc:是否是vip[0否1是]
  1187. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  1188. */
  1189. public function getBoundList()
  1190. {
  1191. $sel_where = [];
  1192. $title = input('get.title');
  1193. $sel_where[] = ['user_id','=',$this->user_id];
  1194. $sel_where[] = ['is_deleted','=',0];
  1195. if($title) $sel_where[] = ['title|label','like','%'.$title.'%'];
  1196. $list = ArticleItem::where($sel_where)
  1197. ->alias('t')
  1198. ->field('id,title,cover,read_num,label,is_vip,article_id')
  1199. ->order('id desc')
  1200. ->limit($this->off_set,$this->page_num)
  1201. ->select()->toArray();
  1202. foreach ($list as &$v) {
  1203. $v['is_normal'] = CheckPower::checkModulesPower($v['article_id'],$v['id'],$this->request->controller());;
  1204. }
  1205. $this->success('ok',['list'=>$list]);
  1206. }
  1207. /**
  1208. * @title 我的追更列表
  1209. * @desc 我的追更列表
  1210. * @author qc
  1211. * @method GET
  1212. * @url /api/Article/getFollowUpList
  1213. * @header name:Authorization require:1 desc:Token
  1214. * @param name:title type:string default:-- desc:标题
  1215. * @param name:page type:int default:0 desc:页数
  1216. * @param name:page_num type:int default:20 desc:每页数
  1217. * @return name:create_at type:string default:-- desc:追更设置时间
  1218. * @return name:article_id type:int default:-- desc:图文id
  1219. * @return name:title type:string default:-- desc:标题
  1220. */
  1221. public function getFollowUpList()
  1222. {
  1223. $sel_where = [];
  1224. $sel_where[] = ['p.user_id','=',$this->user_id];
  1225. $sel_where[] = ['p.type','=',2];
  1226. $sel_where[] = ['p.switch_id','=',1];
  1227. $field = 'p.id,p.switch_id as article_id,p.create_at,a.title';
  1228. $list = PlatformSwitch::field($field)
  1229. ->alias('p')
  1230. ->leftJoin('ArticleIntro a','p.switch_id = a.id')
  1231. ->where($sel_where)
  1232. ->limit($this->off_set,$this->page_num)
  1233. ->order('p.id desc')
  1234. ->select()->toArray();
  1235. $this->success('ok',['list'=>$list]);
  1236. }
  1237. }