Article.php 80 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634
  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. 'getFollowUpMessage',
  56. 'getTagsComment',
  57. 'getMarkNum',
  58. 'unreadChange',
  59. 'batchesDel',
  60. ];
  61. public function initialize()
  62. {
  63. parent::initialize();
  64. parent::setUid();
  65. }
  66. /**
  67. * @title 图文接口说明
  68. * @desc 图文接口说明
  69. * @author qc
  70. * @url /api/Article/classIntro
  71. * @method GET
  72. * @return name:1 type:string default:-- desc:图片(images字段)多图片都用竖线(|)隔开,会员上传多张也用(|)隔开
  73. * @return name:2 type:string default:-- desc:cover字段值是images的第一个路径【非多张】
  74. * @return name:3 type:string default:-- desc:单一图文与系列图文区别,type值(1是单一,2是系列),数据:item_list二维数组数据数量不一样(单一的只有一个,系列的可以是多个)【可以将单一图文看做只有一条记录的系列图文!!!!】
  75. * @return name:4 type:string default:-- desc:单一图文详情的字段(cover,images,is_vip,title)与item_list数组的第一个同字段名的值相同
  76. * @return name:5 type:string default:-- desc:系列图文详情的字段(cover,images)与item_list的其中一个相同
  77. * @return name:6 type:string default:-- desc:关于是否的字段(0否,1是)
  78. * @return name:7 type:string default:-- desc:item_id是数组item_list下的id
  79. */
  80. public function classIntro(){}
  81. /**
  82. * @title 获取图文分类
  83. * @desc 获取图文分类
  84. * @author qc
  85. * @url /api/Article/getArticleCate
  86. * @method GET
  87. * @header name:Authorization require:1 desc:Token
  88. * @param name:type type:int default:2 desc:类型2系列
  89. * @return name:id type:int default:-- desc:分类id
  90. * @return name:logo type:string default:-- desc:图标
  91. * @return name:title type:string default:0 desc:分类名称
  92. * @return name:children type:array default:0 desc:下级分类
  93. */
  94. public function getArticleCate()
  95. {
  96. $type = input('type',2);
  97. if($type == 1) {
  98. $list = ArticleCate::where(['is_deleted'=>0,'status'=>1])->field('id,logo,title,pid')->order('sort desc,id asc')->select()->toArray();
  99. }else{
  100. $list = SeriesArticleCate::where(['is_deleted'=>0,'status'=>1])->field('id,logo,title,pid')->order('sort desc,id asc')->select()->toArray();
  101. }
  102. $list = make_tree($list);
  103. foreach ($list as &$v) {
  104. if(empty($v['children']))$v['children'] = null;
  105. }
  106. $this->success('ok',['list'=>$list]);
  107. }
  108. /**
  109. * @title 图文推荐
  110. * @desc 图文推荐
  111. * @author qc
  112. * @method GET
  113. * @url /api/Article/getRecommendList
  114. * @header name:Authorization require:1 desc:Token
  115. * @param name:page type:int default:0 desc:页数
  116. * @param name:page_num type:int default:20 desc:每页数
  117. * @return name:id type:string default:-- desc:图文item_id
  118. * @return name:title type:string default:-- desc:标题
  119. * @return name:create_at type:string default:-- desc:时间
  120. * @return name:article_id type:string default:-- desc:系列id
  121. * @return name:cover type:string default:-- desc:封面
  122. * @return name:images_arr type:string default:-- desc:图片
  123. * @return name:is_vip type:int default:-- desc:是否是vip(0否,1是)
  124. * @return name:read_num type:int default:-- desc:阅读量
  125. * @return name:app_name type:string default:-- desc:发布者名称
  126. * @return name:app_logo type:string default:-- desc:发布者头像
  127. * @return name:author type:string default:-- desc:原创作者
  128. * @return name:content_type type:int default:1 desc:1富文本2pdf
  129. * @return name:pdf type:string default:-- desc:pdf文件路径
  130. */
  131. public function getRecommendList()
  132. {
  133. $search_log = UserSearch::getSearchTitle($this->user_id,2);
  134. $search_arr = [];
  135. $where_str = 'b.id > 0';
  136. foreach ($search_log as $t){
  137. $search_arr[] = " b.title like '".'%'.$t."%'" .' ';
  138. $search_arr[] = " b.label like '".'%'.$t."%'" .' ';
  139. }
  140. if(!empty($search_arr)) $where_str = implode(' OR ',$search_arr);
  141. $field = ' a.id,a.title,a.cover,a.content_type,a.pdf,a.images,a.create_at,a.user_id,a.is_vip,a.read_num,a.article_id ,a.author,IFNULL(is_recommend,0) is_recommend ';
  142. $table = 'dd_article_item';
  143. $order_by_two = 'a.read_num';
  144. $time_str = date("Y-m-d H:i:s");
  145. $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.release_time < '". $time_str ."' 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}";
  146. $list = Db::query($sql);
  147. $list = dispose_recommend($list);
  148. array_walk($list,function (&$v,$k){
  149. $v['read_num'] = numTransform($v['read_num']);
  150. $article_auth = ArticleItem::getArticleAuth($v['user_id'],APPNAME,APPLOGO);
  151. $v['app_name'] = $article_auth['app_name'];
  152. $v['app_logo'] = $article_auth['app_logo'];
  153. $v['images_arr'] = $v['images'] ? explode('|',$v['images']):null;
  154. });
  155. $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_article_intro as k ON k.id = a.article_id WHERE a.is_deleted = 0 AND a.release_time < '". $time_str ."' AND a.status =1 AND k.status = 1 AND k.is_deleted = 0 ";
  156. $total = Db::query($sql2);
  157. $this->success('ok',['list'=>$list,'total_count'=>$total[0]['num'],'page_num'=>$this->page_num]);
  158. }
  159. /**
  160. * @title 获取图文列表(平台发布)
  161. * @desc 获取图文列表
  162. * @author qc
  163. * @method GET
  164. * @url /api/Article/getArticleList
  165. * @header name:Authorization require:1 desc:Token
  166. * @param name:type type:int default:0 desc:类型1单个2系列
  167. * @param name:is_tj type:int default:0 desc:是否推荐0否1是
  168. * @param name:title type:string default:-- desc:标题
  169. * @param name:page type:int default:0 desc:页数
  170. * @param name:page_num type:int default:20 desc:每页数
  171. * @param name:sort_type type:int default:1 desc:1默认2时间升序3时间降序
  172. * @param name:first_classify type:int default:0 desc:一级分类
  173. * @param name:second_classify type:int default:0 desc:二级分类
  174. * @return name:id type:string default:-- desc:ID[请求/api/Article/getArticleDetail用]
  175. * @return name:title type:string default:-- desc:标题
  176. * @return name:type type:int default:0 desc:类型1单个2系列
  177. * @return name:cover type:string default:-- desc:封面()
  178. * @return name:is_vip type:int default:-- desc:是否是vip(0否,1是)
  179. * @return name:is_over type:int default:-- desc:是否完结(0否,1是)
  180. * @return name:read_num type:int default:-- desc:阅读量
  181. * @return name:label type:string default:-- desc:标签
  182. * @return name:item_list type:array default:-- desc:图文
  183. * @return name:item_list.title type:string default:-- desc:图文标题
  184. * @return name:item_list.is_vip type:int default:-- desc:是否是vip
  185. * @return name:item_list.cover type:string default:-- desc:图文封面
  186. * @return name:item_list.images type:string default:-- desc:图片(多张用|隔开)
  187. * @return name:item_list.content type:string default:-- desc:内容
  188. * @return name:item_list.app_name type:string default:-- desc:发布方名称
  189. * @return name:item_list.app_logo type:string default:-- desc:发布方头像
  190. * @return name:item_list.content_type type:int default:1 desc:1富文本2pdf
  191. * @return name:item_list.pdf type:string default:-- desc:pdf文件路径
  192. */
  193. public function getArticleList()
  194. {
  195. $sel_where = [];
  196. $title = input('get.title');
  197. $type = input('get.type',0);
  198. $is_tj = input('get.is_tj',0);
  199. $sort_type = input('get.sort_type',1);
  200. $first_classify = input('get.first_classify');
  201. $second_classify = input('get.second_classify');
  202. $sel_where[] = ['is_deleted','=',0];
  203. $sel_where[] = ['status','=',1];
  204. $sel_where[] = ['item_num','>',0];
  205. if($title) $sel_where[] = ['title|label','like','%'.$title.'%'];
  206. if($type) $sel_where[] = ['type','=',$type];
  207. if($first_classify) $sel_where[] = ['first_classify','=',$first_classify];
  208. if($second_classify) $sel_where[] = ['second_classify','=',$second_classify];
  209. switch ($sort_type) {
  210. case 1:
  211. $order = ['sort'=>'desc','read_num'=>'desc'];
  212. break;
  213. case 2:
  214. $order = ['id'=>'asc','sort'=>'desc'];
  215. break;
  216. case 3:
  217. $order = ['id'=>'desc','sort'=>'desc'];
  218. break;
  219. }
  220. if($title && $this->user_id)UserSearch::saveSearchTitle($this->user_id,$title,2);
  221. $where_str = 'id > 0';
  222. if($is_tj) {
  223. $search_log = UserSearch::getSearchTitle($this->user_id,2);
  224. $search_arr = [];
  225. foreach ($search_log as $t){
  226. $search_arr[] = " title like '".'%'.$t."%'" .' ';
  227. }
  228. if(!empty($search_arr)) $where_str = implode(' OR ',$search_arr);
  229. }
  230. $list = ArticleIntro::where($sel_where)->with('itemList')
  231. ->limit($this->off_set,$this->page_num)
  232. ->where($where_str)
  233. ->order($order)
  234. ->select()->toArray();
  235. array_walk($list,function (&$v,$k){
  236. $v['read_num']= array_sum(array_column($v['item_list'],'read_num'));
  237. $v['read_num'] = numTransform($v['read_num']);
  238. unset($v['content']);
  239. foreach ($v['item_list'] as &$iv) {
  240. unset($iv['content']);
  241. $iv['read_num'] = numTransform($iv['read_num']);
  242. $article_auth = ArticleItem::getArticleAuth($iv['user_id'],APPNAME,APPLOGO);
  243. $iv['app_name'] = $article_auth['app_name'];
  244. $iv['app_logo'] = $article_auth['app_logo'];
  245. }
  246. });
  247. $total_num = ArticleIntro::where($sel_where) ->where($where_str)->count();
  248. $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
  249. }
  250. /**
  251. * @title 获取图文系列详情(【系列的合集列表】)
  252. * @desc 获取图文系列详情
  253. * @author qc
  254. * @method GET
  255. * @url /api/Article/getArticleDetail
  256. * @header name:Authorization require:1 desc:Token
  257. * @param name:id type:int default:0 desc:图文id
  258. * @param name:sort_type type:int default:1 desc:排序1默认2时间升序3时间降序
  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:follow_switch type:int default:-- desc:订阅开关状态【0关闭1开启】
  264. * @return name:switch_open type:int default:-- desc:通知开关【0关闭1开启】
  265. * @return name:item_list type:array default:-- desc:图文
  266. * @return name:item_list.id type:string default:-- desc:[请求/api/Article/getArticleItemInfo用,请求图文模块其他接口参数:item_id]
  267. * @return name:item_list.title type:string default:-- desc:图文标题
  268. * @return name:item_list.is_vip type:int default:-- desc:是否是vip
  269. * @return name:item_list.cover type:string default:-- desc:封面
  270. * @return name:item_list.images type:int default:-- desc:图片
  271. * @return name:item_list.content type:int default:-- desc:内容
  272. * @return name:item_list.transmit_num type:int default:-- desc:转发量
  273. * @return name:item_list.read_num type:int default:-- desc:阅读量
  274. * @return name:item_list.comment_num type:int default:-- desc:评论量
  275. * @return name:item_list.desc type:int default:-- desc:简介
  276. * @return name:item_list.desc_text type:int default:-- desc:文本
  277. * @return name:item_list.collect_num type:int default:-- desc:收藏量
  278. * @return name:item_list.is_collect type:int default:-- desc:是否收藏
  279. * @return name:item_list.video_id type:int default:-- desc:关联视频id【单个id||系列id】
  280. * @return name:item_list.video_item type:int default:-- desc:关联视频详情id【video_arr.id】
  281. * @return name:item_list.datum_id type:int default:-- desc:资料id【单个id||系列id】
  282. * @return name:item_list.datum_item type:int default:-- desc:资料详情id【url_arr.id】
  283. * @return name:item_list.author type:string default:-- desc:原创作者
  284. * @return name:item_list.content_type type:int default:1 desc:1富文本2pdf
  285. * @return name:item_list.pdf type:string default:-- desc:pdf文件路径
  286. * @return name:item_list.is_recently type:int default:-- desc:是否最近观看【0否1是】
  287. * @return name:item_list.like_num type:int default:-- desc:点赞量
  288. * @return name:item_list.is_like type:int default:-- desc:是否点赞
  289. * @return name:item_list.app_name type:string default:-- desc:发布者
  290. * @return name:item_list.app_logo type:string default:-- desc:发布者头像
  291. */
  292. public function getArticleDetail()
  293. {
  294. $form = input('get.from','H5');
  295. $sel_where = [];
  296. $sel_where[] = ['id','=',input('get.id')];
  297. $sort_type = input('get.sort_type',1);
  298. $detail = ArticleIntro::where($sel_where)->with(['itemList'=>function($query)use($sort_type){
  299. switch ($sort_type) {
  300. case 1:
  301. $order = ['sort'=>'desc','id'=>'asc'];
  302. break;
  303. case 2:
  304. $order = ['id'=>'asc','sort'=>'desc'];
  305. break;
  306. case 3:
  307. $order = ['id'=>'desc','sort'=>'desc'];
  308. break;
  309. }
  310. return $query->order($order);
  311. }])->find()->toArray();
  312. if($detail['is_deleted'] == 1 || $detail['status'] == 0)$this->error('该图文已下线');
  313. if($form == 'H5') $detail['content'] = openssl_encrypt($detail['content'],'DES-ECB',123456,0);
  314. $detail['read_num'] = array_sum(array_column($detail['item_list'],'read_num'));
  315. $detail['read_num'] = numTransform($detail['read_num']);
  316. $detail['follow_switch'] = PlatformSwitch::checkSwitch($this->user_id,$detail['id'],3);
  317. $detail['switch_open'] = PlatformSwitch::checkSwitch($this->user_id,$detail['id'],8);
  318. $recently_id = UserTrack::getRecentlyTrack($this->user_id,3,$detail['id']);
  319. foreach ($detail['item_list'] as &$dv) {
  320. if($form == 'H5') $dv['content'] = openssl_encrypt($dv['content'],'DES-ECB',123456,0);
  321. $dv['comment_num'] = ArticleComment::where(['article_id'=>$detail['id'],'item_id'=>$dv['id']])->count();
  322. $dv['comment_num'] = numTransform($dv['comment_num']);
  323. $dv['collect_num'] = UserCollect::where(['coll_type'=>3,'coll_id'=>$detail['id'],'children_id'=>$dv['id']])->count();
  324. $dv['comment_num'] = numTransform($dv['collect_num']);
  325. $dv['transmit_num'] = numTransform($dv['transmit_num']);
  326. $dv['is_collect'] = UserCollect::checkCollectByType($this->user_id,3,$detail['id'],$dv['id']);
  327. $dv['read_num'] = numTransform($dv['read_num']);
  328. $dv['is_recently'] = $dv['id'] == $recently_id ? 1 : 0;
  329. $dv['is_like'] = ArticleLike::where(['user_id'=>$this->user_id,'article_id'=>$dv['article_id'],'item_id'=>$dv['id']])->count();
  330. $dv['like_num'] = ArticleLike::where(['article_id'=>$dv['article_id'],'item_id'=>$dv['id']])->count();
  331. $article_auth = ArticleItem::getArticleAuth($dv['user_id'],APPNAME,APPLOGO);
  332. $dv['app_name'] = $article_auth['app_name'];
  333. $dv['app_logo'] = $article_auth['app_logo'];
  334. }
  335. $this->success('ok',['detail'=>$detail]);
  336. }
  337. /**
  338. * @title 获取图文ITEM详情(平台)
  339. * @desc 获取图文ITEM详情
  340. * @author qc
  341. * @method GET
  342. * @url /api/Article/getArticleItemInfo
  343. * @header name:Authorization require:1 desc:Token
  344. * @param name:item_id type:int default:0 desc:item_list
  345. * @param name:from type:string default:APP desc:请求来源(APP或H5)
  346. * @return name:title type:string default:-- desc:图文标题
  347. * @return name:is_vip type:int default:-- desc:是否是vip
  348. * @return name:cover type:string default:-- desc:封面
  349. * @return name:images type:int default:-- desc:图片
  350. * @return name:content type:int default:-- desc:内容
  351. * @return name:transmit_num type:int default:-- desc:转发量
  352. * @return name:read_num type:int default:-- desc:阅读量
  353. * @return name:comment_num type:int default:-- desc:评论量
  354. * @return name:collect_num type:int default:-- desc:收藏量
  355. * @return name:is_collect type:int default:-- desc:是否收藏
  356. * @return name:like_num type:int default:-- desc:点赞量
  357. * @return name:is_like type:int default:-- desc:是否点赞
  358. * @return name:desc type:int default:-- desc:简介
  359. * @return name:desc_text type:int default:-- desc:文本
  360. * @return name:video_id type:int default:-- desc:关联视频id【单个id||系列id】
  361. * @return name:video_item type:int default:-- desc:关联视频详情id【video_arr.id】
  362. * @return name:datum_id type:int default:-- desc:资料id【单个id||系列id】
  363. * @return name:datum_item type:int default:-- desc:资料详情id【url_arr.id】
  364. * @return name:author type:string default:-- desc:原创作者
  365. * @return name:content_type type:int default:1 desc:1富文本2pdf
  366. * @return name:pdf type:string default:-- desc:pdf文件路径
  367. * @return name:app_name type:string default:-- desc:发布者
  368. * @return name:app_logo type:string default:-- desc:发布者头像
  369. * @return name:follow_switch type:int default:-- desc:订阅开关状态【0关闭1开启】
  370. * @return name:switch_open type:int default:-- desc:通知开关【0关闭1开启】
  371. * @return name:article_title type:string default:-- desc:系列标题
  372. */
  373. public function getArticleItemInfo()
  374. {
  375. $item_id = input('get.item_id');
  376. $form = input('get.from','H5');
  377. $detail = ArticleItem::field('a.*,t.is_deleted td,t.status tus,t.title article_title')->where('a.id',$item_id)->alias('a')->leftJoin('ArticleIntro t','t.id= a.article_id')->find()->toArray();
  378. if($detail['is_deleted'] == 1 || $detail['status'] == 0 || $detail['td'] == 1 || $detail['tus']==0) $this->error('图文已下架');
  379. $detail['comment_num'] = ArticleComment::where(['article_id'=>$detail['article_id'],'item_id'=>$detail['id']])->count();
  380. $detail['collect_num'] = UserCollect::where(['coll_type'=>3,'coll_id'=>$detail['article_id'],'children_id'=>$detail['id']])->count();
  381. $detail['is_collect'] = UserCollect::checkCollectByType($this->user_id,3,$detail['article_id'],$detail['id']);
  382. $detail['is_like'] = ArticleLike::where(['user_id'=>$this->user_id,'article_id'=>$detail['article_id'],'item_id'=>$detail['id']])->count();
  383. // if($form == 'H5') $detail['content'] = openssl_encrypt($detail['content'],'DES-ECB',123456,0);
  384. $detail['like_num'] = ArticleLike::where(['article_id'=>$detail['article_id'],'item_id'=>$detail['id']])->count();
  385. $detail['like_num'] = numTransform($detail['like_num']);
  386. $detail['read_num'] = numTransform($detail['read_num']);
  387. $detail['comment_num'] = numTransform($detail['comment_num']);
  388. $detail['collect_num'] = numTransform($detail['collect_num']);
  389. $detail['transmit_num'] = numTransform($detail['transmit_num']);
  390. UserTrack::crateTrack($this->user_id,3,$detail['article_id'],$item_id);
  391. $article_auth = ArticleItem::getArticleAuth($detail['user_id'],APPNAME,APPLOGO);
  392. $detail['app_name'] = $article_auth['app_name'];
  393. $detail['app_logo'] = $article_auth['app_logo'];
  394. $detail['follow_switch'] = PlatformSwitch::checkSwitch($this->user_id,$detail['article_id'],3);
  395. $detail['switch_open'] = PlatformSwitch::checkSwitch($this->user_id,$detail['article_id'],8);
  396. //var_dump($this->user_id,3,$detail['article_id'],$item_id);
  397. $this->success('ok',['detail'=>$detail]);
  398. }
  399. /**
  400. * @title 获取图文评论列表
  401. * @desc 获取图文评论列表
  402. * @author qc
  403. * @method GET
  404. * @url /api/Article/getArticleCommentList
  405. * @header name:Authorization require:1 desc:Token
  406. * @param name:article_id type:int default:-- desc:图文id
  407. * @param name:item_id type:int default:-- desc:item_id
  408. * @param name:sort_type type:int default:1 desc:排序1最新2最热
  409. * @param name:page type:int default:-- desc:页数
  410. * @return name:name type:string default:-- desc:会员名称
  411. * @return name:headimg type:string default:-- desc:会员头像
  412. * @return name:content type:string default:-- desc:内容
  413. * @return name:parent type:array default:-- desc:评论上一级(数据同上【一维数组】)
  414. * @return name:children type:array default:-- desc:二级评论(数据同上【二维数组】)
  415. * @return name:like_num type:int default:-- desc:点赞数量
  416. * @return name:is_like type:int default:-- desc:是否点赞(0否1是)
  417. * @return name:is_top type:int default:-- desc:是否置顶(0否1是)
  418. * @return name:can_delete type:int default:-- desc:是否可以删除(0否1是)
  419. * @return name:total_num type:int default:-- desc:总评论数(仅一级)
  420. */
  421. public function getArticleCommentList()
  422. {
  423. $where = [];
  424. $where[] = ['c.article_id','=',input('get.article_id')];
  425. $where[] = ['c.is_deleted','=',0];
  426. $user_id = $this->user_id;
  427. $sort_type= input('sort_type',1);
  428. if(input('get.item_id')) $where[] = ['c.item_id','=',input('get.item_id')];
  429. switch ($sort_type) {
  430. case 1:
  431. $order = ['is_top'=>'desc','id'=>'desc'];
  432. break;
  433. default:
  434. $order = ['is_top'=>'desc','like_times'=>'desc'];
  435. break;
  436. }
  437. $list =ArticleComment::where($where)
  438. ->alias('c')
  439. ->field('c.*,u.name,u.headimg')
  440. ->leftJoin('store_member u','u.id = c.user_id')
  441. ->order($order)
  442. ->limit($this->off_set,$this->page_num)
  443. ->select()->toArray();
  444. array_walk($list,function (&$val,$k)use($user_id){
  445. $children = ArticleComment::where(['c.pid'=>$val['id'],'c.is_deleted'=>0])
  446. ->alias('c')->field('c.*,u.name,u.headimg')
  447. ->leftJoin('store_member u','u.id = c.user_id')
  448. ->order('c.is_top desc,c.id asc')
  449. ->select()->toArray();
  450. $val['children'] = $children;
  451. $val['like_num'] = ArticleCommentLike::where('like_id',$val['id'])->count();
  452. $val['like_num'] = numTransform($val['like_num']);
  453. $val['is_like'] = ArticleCommentLike::where(['like_id'=>$val['id'],'user_id'=>$user_id])->count();
  454. $parent = ArticleComment::where(['c.id'=>$val['pid'],'c.is_deleted'=>0])
  455. ->alias('c')->field('c.*,u.name,u.headimg')
  456. ->leftJoin('store_member u','u.id = c.user_id')
  457. ->find();
  458. $val['parent'] = $parent ? $parent->toArray() : null;
  459. $val['can_delete'] = $val['user_id'] == $this->user_id ? 1 :0;
  460. });
  461. $total_num = ArticleComment::where($where)->alias('c') ->leftJoin('store_member u','u.id = c.user_id')->count();
  462. $this->success('ok',['list'=>$list,'total_num'=>numTransform($total_num),'total_count'=>$total_num,'page_num'=>$this->page_num]);
  463. }
  464. /**
  465. * @title 以下接口调用验证登录【需要header传Authorization】
  466. * @desc 转发成功后调用
  467. * @author qc
  468. * @method
  469. * @url /api/Article/needLogin()
  470. */
  471. public function needLogin(){}
  472. /**
  473. * @title 图文转发(转发数量统计)
  474. * @desc 转发成功后调用
  475. * @author qc
  476. * @method POST
  477. * @url /api/Article/articleTransmit
  478. * @header name:Authorization require:1 desc:Token
  479. * @param name:item_id type:int default:-- desc:item_list的id
  480. */
  481. public function articleTransmit()
  482. {
  483. $item_id = input('post.item_id',0);
  484. ArticleItem::where('id',$item_id)->setInc('transmit_num');
  485. $this->success('ok');
  486. }
  487. /**
  488. * @title 图文阅读(阅读数量统计)
  489. * @desc 图文阅读
  490. * @author qc
  491. * @method POST
  492. * @url /api/Article/articleRead
  493. * @header name:Authorization require:1 desc:Token
  494. * @param name:item_id type:int default:-- desc:item_list的id
  495. */
  496. public function articleRead()
  497. {
  498. $item_id = input('post.item_id',0);
  499. $article_id = ArticleItem::where('id',$item_id)->value('article_id');
  500. ArticleItem::where('id',$item_id)->setInc('read_num');
  501. ArticleIntro::where('id',$article_id)->setInc('read_num');
  502. $this->success('ok');
  503. }
  504. /**
  505. * @title 图文点赞||取消点赞
  506. * @desc 点赞||取消点赞
  507. * @author qc
  508. * @method POST
  509. * @url /api/Article/articleTags
  510. * @header name:Authorization require:1 desc:Token
  511. * @param name:item_id type:int default:1 desc:item_id(多个逗号隔开)
  512. * @return name:tags type:int default:1 desc:0取消成功,1点赞成功
  513. */
  514. public function articleTags()
  515. {
  516. $ids = input('post.item_id');
  517. $ret_val = 0;
  518. foreach (explode(',',$ids) as $item_id) {
  519. $article_id = ArticleItem::where('id',$item_id)->value('article_id');
  520. $check_tags = ArticleLike::where(['user_id'=>$this->user_id,'article_id'=>$article_id,'item_id'=>$item_id])->value('id');
  521. if($check_tags) {
  522. ArticleLike::where(['user_id'=>$this->user_id,'article_id'=>$article_id,'item_id'=>$item_id])->delete();
  523. }else{
  524. Data::save('ArticleLike',
  525. ['user_id'=>$this->user_id,'article_id'=>$article_id,'item_id'=>$item_id],'user_id',
  526. ['user_id'=>$this->user_id,'article_id'=>$article_id,'item_id'=>$item_id]);
  527. $ret_val = 1;
  528. }
  529. }
  530. $this->success($ret_val == 1 ?'点赞成功':'取消成功',['tags'=>$ret_val]);
  531. }
  532. /**
  533. * @title 图文评论
  534. * @desc 图文评论
  535. * @author qc
  536. * @method POST
  537. * @url /api/Article/articleComment
  538. * @header name:Authorization require:1 desc:Token
  539. * @param name:article_id type:int default:1 desc:图文id
  540. * @param name:item_id type:int default:1 desc:item_id
  541. * @param name:content type:string default:-- desc:内容
  542. * @return name:name type:string default:-- desc:会员名称
  543. * @return name:headimg type:string default:-- desc:会员头像
  544. * @return name:content type:string default:-- desc:内容
  545. */
  546. public function articleComment()
  547. {
  548. $article_id = input('post.article_id');
  549. $item_id = input('post.item_id');
  550. $content = input('post.content',0);
  551. if(!$content) $this->error('请输入评论内容');
  552. $res = ArticleComment::create(['user_id'=>$this->user_id,'content'=>$content,'article_id'=>$article_id,'item_id'=>$item_id]);
  553. $detail =ArticleComment::where('c.id',$res->id)
  554. ->alias('c')
  555. ->field('c.id,c.content,c.create_at,u.name,u.headimg')
  556. ->leftJoin('store_member u','u.id = c.user_id')
  557. ->find()->toArray();
  558. $send_user = ArticleItem::where('id',$item_id)->value('user_id');
  559. $user_info = $this->userInfo('name');
  560. if($send_user) UserMessage:: sendUserMessage($send_user,'article',4,0,$this->user_id,$item_id,$user_info['name'].'评论了您的图文');
  561. $this->success('评论成功',['detail'=>$detail]);
  562. }
  563. /**
  564. * @title 删除评论
  565. * @desc 删除评论
  566. * @author qc
  567. * @method POST
  568. * @url /api/Article/delComment
  569. * @header name:Authorization require:1 desc:Token
  570. * @param name:id type:int default:1 desc:评论id
  571. */
  572. public function delComment(){
  573. ArticleComment::where(['id'=>input('post.id'),'user_id'=>$this->user_id])->update(['is_deleted'=>1]);
  574. $this->success('删除成功');
  575. }
  576. /**
  577. * @title 图文二级评论
  578. * @desc 图文二级评论
  579. * @author qc
  580. * @method POST
  581. * @url /api/Article/secondCommend
  582. * @header name:Authorization require:1 desc:Token
  583. * @param name:id type:int default:1 desc:评论id
  584. * @param name:content type:string default:-- desc:内容
  585. * @return name:name type:string default:-- desc:会员名称
  586. * @return name:headimg type:string default:-- desc:会员头像
  587. * @return name:content type:string default:-- desc:内容
  588. */
  589. public function secondCommend()
  590. {
  591. $comment = ArticleComment::where('id',input('post.id'))->find()->toArray();
  592. $user_info = $this->userInfo('name');
  593. UserMessage:: sendUserMessage($comment['user_id'],'article',3,0,$this->user_id,$comment['id'],$user_info['name'].'回复了您的评论');
  594. $send_user = ArticleItem::where('id',$comment['item_id'])->value('user_id');
  595. if($send_user) UserMessage:: sendUserMessage($send_user,'article',4,0,$this->user_id,$comment['item_id'],$user_info['name'].'评论了您的图文');
  596. unset($comment['id']);
  597. unset($comment['create_at']);
  598. $comment['pid'] = input('post.id');
  599. $comment['user_id'] = $this->user_id;
  600. $comment['content'] = input('post.content');
  601. $comment['lev']++;
  602. if(!$comment['source_id']) $comment['source_id'] = input('post.id');
  603. $res = ArticleComment::create($comment);
  604. $detail = ArticleComment::where('c.id',$res->id)
  605. ->alias('c')
  606. ->field('c.id,c.content,c.create_at,u.name,u.headimg')
  607. ->leftJoin('store_member u','u.id = c.user_id')
  608. ->find()->toArray();
  609. $this->success('评论成功',['detail'=>$detail]);
  610. }
  611. /**
  612. * @title 评论点赞||取消点赞
  613. * @desc 评论
  614. * @author qc
  615. * @method POST
  616. * @url /api/Article/commentTags
  617. * @header name:Authorization require:1 desc:Token
  618. * @param name:comment_id type:int default:1 desc:评论记录id
  619. * @return name:tags type:int default:1 desc:0取消成功,1点赞成功
  620. */
  621. public function commentTags()
  622. {
  623. $comment_id = input('post.comment_id');
  624. $ret_val = 0;
  625. $check_tags = ArticleCommentLike::where(['user_id'=>$this->user_id,'like_id'=>$comment_id])->value('id');
  626. if($check_tags) {
  627. ArticleCommentLike::where(['user_id'=>$this->user_id,'like_id'=>$comment_id])->delete();
  628. // ArticleItem::where('id',$comment_id)->setDec('like_times');
  629. }else{
  630. Data::save('ArticleCommentLike',
  631. ['user_id'=>$this->user_id,'like_id'=>$comment_id,],'user_id',
  632. ['user_id'=>$this->user_id,'like_id'=>$comment_id]);
  633. $ret_val = 1;
  634. // ArticleItem::where('id',$comment_id)->setInc('like_times');
  635. }
  636. $this->success($ret_val == 1 ?'点赞成功':'取消成功',['tags'=>$ret_val]);
  637. }
  638. /**
  639. * @title 图文收藏||取消收藏
  640. * @desc 用户收藏
  641. * @author qc
  642. * @method POST
  643. * @url /api/Article/articleCollect
  644. * @header name:Authorization require:1 desc:Token
  645. * @param name:article_id type:int require:1 default:-- desc:记录id[图文id]
  646. * @param name:item_id type:int default:1 desc:item_id
  647. * @param name:status type:int default:0 desc:收藏状态(0取消收藏【未收藏】,1收藏)
  648. */
  649. public function articleCollect()
  650. {
  651. $coll_type = input('post.coll_type',3);
  652. $coll_id = input('post.article_id',0);
  653. $item_id = input('post.item_id',0);
  654. $collect_check = UserCollect::checkCollectByType($this->user_id,$coll_type,$coll_id,$item_id);
  655. if($collect_check) {
  656. UserCollect::where(['user_id'=>$this->user_id,'coll_type'=>$coll_type,'coll_id'=>$coll_id,'children_id'=>$item_id])->delete();
  657. $this->success('取消收藏成功',['status'=>0]);
  658. }else{
  659. Data::save('UserCollect', [
  660. 'user_id'=>$this->user_id,
  661. 'coll_type'=>$coll_type,
  662. 'coll_id'=>$coll_id,
  663. 'children_id'=>$item_id,
  664. 'create_int'=>time()],'user_id',['user_id'=>$this->user_id,'coll_type'=>$coll_type, 'coll_id'=>$coll_id,'children_id'=>$item_id]);
  665. $this->success('收藏成功',['status'=>1]);
  666. }
  667. }
  668. /**
  669. * @title 用户提交或修改图文【个人】
  670. * @desc 用户提交或修改图文【个人】
  671. * @author qc
  672. * @method POST
  673. * @url /api/Article/userReferArticle
  674. * @header name:Authorization require:1 desc:Token
  675. * @param name:id type:int default:-- desc:id(修改时必传)
  676. * @param name:title type:string default:-- desc:标题
  677. * @param name:images type:string default:-- desc:图片(多张用|隔开)
  678. * @param name:desc type:string default:-- desc:简介
  679. * @param name:label type:string default:-- desc:图文标签(多个用逗号隔开)
  680. * @param name:document type:string default:-- desc:文件路径【单文件】
  681. */
  682. public function userReferArticle()
  683. {
  684. $id = input('post.id',0);
  685. $title = input('post.title');
  686. $desc = input('post.desc');
  687. $images = input('post.images');
  688. $label = input('post.label');
  689. $document = input('post.document');
  690. //if(!$images) $this->error('请上传图文');
  691. if($id){
  692. $check_status = UserArticle::where('id',$id)->value('status');
  693. if($check_status == 1) $this->error('已审核通过,不允许修改');
  694. }
  695. $data = [
  696. 'title' => $title,
  697. 'user_id' => $this->user_id,
  698. 'desc' => $desc,
  699. 'images' => $images,
  700. 'label' => $label,
  701. 'document' => $document,
  702. 'cover' => $images ? explode('|',$images)[0] : '',
  703. 'status' => 0,
  704. 'remark' => '',
  705. ];
  706. if($id) $data['id'] = $id;
  707. if($id){
  708. UserArticle::where('id',$id)->update($data);
  709. }else{
  710. $res= UserArticle::create($data) ;
  711. }
  712. UserMessage::sendUserMessage($this->user_id,'article',1,0,0,$id ? $id:$res->id);
  713. $this->success('提交成功,请等待审核',['id'=> $id ? :$res->id]);
  714. }
  715. /**
  716. * @title 我的发布--个人发布的
  717. * @desc 获取我的图文列表【个人】
  718. * @author qc
  719. * @method GET
  720. * @url /api/Article/getMyArticleList
  721. * @header name:Authorization require:1 desc:Token
  722. * @param name:title type:string default:-- desc:标题
  723. * @param name:page type:int default:0 desc:页数
  724. * @param name:page_num type:int default:20 desc:每页数
  725. * @return name:title type:string default:-- desc:标题
  726. * @return name:desc type:string default:-- desc:简介
  727. * @return name:images type:string default:-- desc:图片【多张|隔开】
  728. * @return name:images_arr type:array default:-- desc:图片数组
  729. * @return name:status type:int default:-- desc:0待审核1审核通过2审核未通过
  730. * @return name:remark type:string default:-- desc:审核备注
  731. * @return name:create_at type:string default:-- desc:时间
  732. * @return name:label_name type:array default:-- desc:标签
  733. * @return name:cover type:string default:-- desc:封面
  734. */
  735. public function getMyArticleList()
  736. {
  737. $sel_where = [];
  738. $sel_where[] = ['is_deleted','=',0];
  739. $sel_where[] = ['user_id','=',$this->user_id];
  740. $title = input('get.title');
  741. if($title) $sel_where[] = ['title|label','like','%'.$title.'%'];
  742. $list = UserArticle::where($sel_where)
  743. ->field('id,title,desc,images,status,remark,create_at,label')
  744. ->order('id desc')
  745. ->limit($this->off_set,$this->page_num)
  746. ->select()->toArray();
  747. array_map(function (&$v){
  748. $v['label_name'] =$v['label'] ? explode(',',trim($v['label'],',')) :null;
  749. $v['images_arr'] = $v['images'] ? explode('|',$v['images']):null;
  750. },$list);
  751. $total_num = UserArticle::where($sel_where)->count();
  752. $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
  753. }
  754. /**
  755. * @title 获取我的图文详情【个人】
  756. * @desc 获取我的图文列表【个人】
  757. * @author qc
  758. * @method GET
  759. * @url /api/Article/getUserArticleDetail
  760. * @header name:Authorization require:1 desc:Token
  761. * @param name:id type:string default:-- desc:记录id
  762. * @return name:title type:string default:-- desc:标题
  763. * @return name:desc type:string default:-- desc:简介
  764. * @return name:images type:string default:-- desc:图文[多张|隔开]
  765. * @return name:status type:int default:-- desc:0待审核1审核通过2审核未通过
  766. * @return name:remark type:string default:-- desc:审核备注
  767. * @return name:label type:string default:-- desc:标签
  768. * @return name:document type:string default:-- desc:文件路径
  769. */
  770. public function getUserArticleDetail()
  771. {
  772. $detail =UserArticle::where('id',input('get.id'))->field('id,title,desc,images,status,remark,label,document')->find();
  773. if(!$detail) $this->error('图文有误');
  774. $this->success('ok',['detail'=>$detail->toArray()]);
  775. }
  776. /**
  777. * @title 用户删除图文记录【个人】
  778. * @desc 用户删除图文记录【个人】
  779. * @author qc
  780. * @method POST
  781. * @url /api/Article/delUserArticle
  782. * @header name:Authorization require:1 desc:Token
  783. * @param name:id type:int default:-- desc:id
  784. */
  785. public function delUserArticle()
  786. {
  787. UserArticle::where(['user_id'=>$this->user_id,'id'=>input('post.id')])->delete();
  788. $this->success('删除成功');
  789. }
  790. /**
  791. * @title 以下接口学习服务模块的
  792. * @desc
  793. * @author qc
  794. * @method
  795. * @url /api/Article/learn()
  796. */
  797. public function learn(){}
  798. /**
  799. * @title 图文学习历史
  800. * @desc 图文学习历史
  801. * @author qc
  802. * @method GET
  803. * @url /api/Article/getLearnHistory
  804. * @header name:Authorization require:1 desc:Token
  805. * @param name:title type:string default:-- desc:标题
  806. * @param name:page type:int default:0 desc:页数
  807. * @param name:page_num type:int default:20 desc:每页数
  808. * @return name:title type:string default:-- desc:标题
  809. * @return name:article_id type:string default:-- desc:文章id
  810. * @return name:item_id type:string default:-- desc:item_id
  811. * @return name:cover type:string default:-- desc:封面
  812. * @return name:time type:string default:-- desc:时间
  813. * @return name:read_num type:int default:-- desc:阅读量
  814. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  815. * @return name:app_name type:string default:-- desc:发布者
  816. * @return name:app_logo type:string default:-- desc:发布者头像
  817. */
  818. public function getLearnHistory()
  819. {
  820. $sel_where = [];
  821. $sel_where[] = ['t.user_id','=',$this->user_id];
  822. $sel_where[] = ['t.type','=',3];
  823. $title = input('get.title');
  824. if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
  825. $list = UserTrack::where($sel_where)
  826. ->alias('t')
  827. ->field('t.id,t.update_int,t.first_id article_id,t.second_id item_id,i.title,i.cover,i.read_num,i.user_id')
  828. ->leftJoin('ArticleItem i','t.second_id = i.id')
  829. ->order('update_int desc')
  830. ->limit($this->off_set,$this->page_num)
  831. ->select()->toArray();
  832. foreach ($list as &$v) {
  833. $v['read_num'] = numTransform($v['read_num']);
  834. $v['time'] = date("Y-m-d H:i:s",$v['update_int']);
  835. $v['is_normal'] = CheckPower::checkModulesPower($v['article_id'],$v['item_id'],$this->request->controller());
  836. $article_auth = ArticleItem::getArticleAuth($v['user_id'],APPNAME,APPLOGO);
  837. $v['app_name'] = $article_auth['app_name'];
  838. $v['app_logo'] = $article_auth['app_logo'];
  839. }
  840. $total_num = UserTrack::where($sel_where)->alias('t') ->leftJoin('ArticleItem i','t.second_id = i.id')->count();
  841. $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
  842. }
  843. /**
  844. * @title 我的收藏--图文
  845. * @desc 图文收藏记录
  846. * @author qc
  847. * @method GET
  848. * @url /api/Article/getArticleCollect
  849. * @header name:Authorization require:1 desc:Token
  850. * @param name:title type:string default:-- desc:标题
  851. * @param name:page type:int default:0 desc:页数
  852. * @param name:page_num type:int default:20 desc:每页数
  853. * @return name:title type:string default:-- desc:标题
  854. * @return name:read_num type:int default:-- desc:阅读量
  855. * @return name:article_id type:string default:-- desc:文章id
  856. * @return name:item_id type:string default:-- desc:item_id
  857. * @return name:cover type:string default:-- desc:封面
  858. * @return name:create_at type:string default:-- desc:时间
  859. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  860. * @return name:desc type:string default:-- desc:简介
  861. * @return name:switch_open type:int default:-- desc:通知开关【0关闭1开启】
  862. * @return name:transmit_num type:int default:-- desc:转发量
  863. * @return name:comment_num type:int default:-- desc:评论量
  864. * @return name:is_collect type:int default:-- desc:是否收藏
  865. * @return name:collect_num type:int default:-- desc:收藏量
  866. * @return name:like_num type:string default:-- desc:点赞量
  867. * @return name:is_like type:string default:-- desc:是否点赞[0否1是]
  868. */
  869. public function getArticleCollect()
  870. {
  871. $sel_where = [];
  872. $title = input('get.title');
  873. if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
  874. $sel_where[] = ['t.user_id','=',$this->user_id];
  875. $sel_where[] = ['t.coll_type','=',3];
  876. $list = UserCollect::where($sel_where)
  877. ->alias('t')
  878. ->field('t.id,t.create_at,t.coll_id article_id,t.children_id item_id,i.title,i.cover,i.read_num,i.transmit_num,i.desc')
  879. ->leftJoin('ArticleItem i','t.children_id = i.id')
  880. ->order('id desc')
  881. ->limit($this->off_set,$this->page_num)
  882. ->select()->toArray();
  883. array_walk($list,function (&$v){
  884. $v['switch_open'] = PlatformSwitch::checkSwitch($this->user_id,$v['article_id'],8);
  885. $v['read_num'] = numTransform($v['read_num']);
  886. $v['is_normal'] = CheckPower::checkModulesPower($v['article_id'],$v['item_id'],$this->request->controller());
  887. $v['transmit_num'] = numTransform($v['transmit_num']);
  888. $v['collect_num'] = UserCollect::where(['coll_type'=>3,'coll_id'=>$v['article_id'],'children_id'=>$v['item_id']])->count();
  889. $v['collect_num'] = numTransform($v['collect_num']);
  890. $v['is_collect'] = UserCollect::checkCollectByType($this->user_id,3,$v['article_id'],$v['item_id']);
  891. $v['like_num'] = ArticleLike::where(['article_id'=>$v['article_id'],'item_id'=>$v['item_id']])->count();
  892. $v['like_num'] = numTransform($v['like_num']);
  893. $v['comment_num'] = ArticleComment::getArticleCommentNum($v['item_id']);
  894. $v['is_like'] = ArticleLike::where(['user_id'=>$this->user_id,'article_id'=>$v['article_id'],'item_id'=>$v['item_id']])->count();
  895. });
  896. $total_num = UserCollect::where($sel_where)->alias('t') ->leftJoin('ArticleItem i','t.children_id = i.id')->count();
  897. $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
  898. }
  899. /**
  900. * @title 我的评论【学习服务--我评论过的图文】
  901. * @desc 我的评论
  902. * @author qc
  903. * @method GET
  904. * @url /api/Article/getCommentArticle
  905. * @header name:Authorization require:1 desc:Token
  906. * @param name:title type:string default:-- desc:标题
  907. * @param name:page type:int default:0 desc:页数
  908. * @param name:page_num type:int default:20 desc:每页数
  909. * @return name:title type:string default:-- desc:标题
  910. * @return name:article_id type:string default:-- desc:文章id
  911. * @return name:item_id type:string default:-- desc:item_id
  912. * @return name:cover type:string default:-- desc:封面
  913. * @return name:is_top type:int default:-- desc:是否置顶(0否1是)
  914. * @return name:create_at type:string default:-- desc:时间
  915. * @return name:user_name type:string default:-- desc:用户名【用户自己的】
  916. * @return name:headimg type:string default:-- desc:用户头像【用户自己的】
  917. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  918. */
  919. public function getCommentArticle()
  920. {
  921. $user_info = $this->userInfo();
  922. $sel_where = [];
  923. $title = input('get.title');
  924. if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
  925. $sel_where[] = ['t.user_id','=',$this->user_id];
  926. $sel_where[] = ['t.is_deleted','=',0];
  927. $sel_where[] = ['t.lev','=',1];
  928. $list = ArticleComment::where($sel_where)
  929. ->alias('t')
  930. ->field('t.id,t.create_at,t.article_id,t.item_id,t.is_top,t.lev,t.content,i.title,i.cover')
  931. ->leftJoin('ArticleItem i','t.item_id = i.id')
  932. ->order('t.is_top desc,id desc')
  933. ->limit($this->off_set,$this->page_num)
  934. ->select()->toArray();
  935. foreach ($list as &$v)
  936. {
  937. $v['user_name'] = $user_info['name'];
  938. $v['headimg'] = $user_info['headimg'];
  939. $v['is_normal'] = CheckPower::checkModulesPower($v['article_id'],$v['item_id'],$this->request->controller());
  940. }
  941. $total_num = ArticleComment::where($sel_where)->alias('t') ->leftJoin('ArticleItem i','t.item_id = i.id')->count();
  942. $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
  943. }
  944. /**
  945. * @title 评论我的【学习服务--评论我的】
  946. * @desc 评论我的
  947. * @author qc
  948. * @method GET
  949. * @url /api/Article/commentMyArticle
  950. * @header name:Authorization require:1 desc:Token
  951. * @param name:title type:string default:-- desc:标题
  952. * @param name:page type:int default:0 desc:页数
  953. * @param name:page_num type:int default:20 desc:每页数
  954. * @return name:title type:string default:-- desc:标题
  955. * @return name:article_id type:string default:-- desc:文章id
  956. * @return name:item_id type:string default:-- desc:item_id
  957. * @return name:cover type:string default:-- desc:封面
  958. * @return name:is_read type:int default:-- desc:是否已读(0未读1已读)
  959. * @return name:is_top type:int default:-- desc:是否置顶(0否1是)
  960. * @return name:create_at type:string default:-- desc:时间
  961. * @return name:user_name type:string default:-- desc:用户名
  962. * @return name:headimg type:string default:-- desc:用户头像
  963. * @return name:read_num type:int default:-- desc:阅读量
  964. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  965. * @return name:app_name type:string default:-- desc:发布者
  966. * @return name:app_logo type:string default:-- desc:发布者头像
  967. */
  968. public function commentMyArticle()
  969. {
  970. $sel_where = [];
  971. $title = input('get.title');
  972. if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
  973. $sel_where[] = ['t.is_deleted','=',0];
  974. $sel_where[] = ['i.user_id','=',$this->user_id];
  975. $list = ArticleComment::where($sel_where)
  976. ->alias('t')
  977. ->field('t.id,t.is_read,t.is_top,t.create_at,i.read_num,t.article_id,t.item_id,t.lev,t.content,i.title,i.cover,u.name user_name,u.headimg')
  978. ->leftJoin('ArticleItem i','t.item_id = i.id')
  979. ->leftJoin('store_member u','t.user_id = u.id')
  980. ->order('t.is_top desc,t.id desc')
  981. ->limit($this->off_set,$this->page_num)
  982. ->select()->toArray();
  983. $user_info = $this->userInfo('name,headimg');
  984. array_walk($list,function (&$v)use ($user_info){
  985. $v['is_normal'] = CheckPower::checkModulesPower($v['article_id'],$v['item_id'],$this->request->controller());
  986. $v['read_num'] = numTransform($v['read_num']);
  987. $v['app_name'] = $user_info['name'];
  988. $v['app_log'] = $user_info['headimg'];
  989. });
  990. $total_num= ArticleComment::where($sel_where)->alias('t') ->leftJoin('ArticleItem i','t.item_id = i.id')
  991. ->leftJoin('store_member u','t.user_id = u.id')->count();
  992. $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
  993. }
  994. /**
  995. * @title 我的已购--已购列表
  996. * @desc 我的已购--已购列表
  997. * @author qc
  998. * @method GET
  999. * @url /api/Article/getPurchaseArticle
  1000. * @header name:Authorization require:1 desc:Token
  1001. * @param name:title type:string default:-- desc:标题
  1002. * @param name:page type:int default:0 desc:页数
  1003. * @param name:page_num type:int default:20 desc:每页数
  1004. * @return name:title type:string default:-- desc:标题
  1005. * @return name:article_id type:string default:-- desc:文章id
  1006. * @return name:item_id type:string default:-- desc:item_id
  1007. * @return name:cover type:string default:-- desc:封面
  1008. * @return name:create_at type:string default:-- desc:时间
  1009. * @return name:total_sequel type:int default:-- desc:期数
  1010. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  1011. * @return name:is_recently type:int default:-- desc:是否最近观看【0否1是】
  1012. * @return name:recently_title type:string default:-- desc:上次观看标题
  1013. */
  1014. public function getPurchaseArticle()
  1015. {
  1016. $sel_where = [];
  1017. $title = input('get.title');
  1018. if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
  1019. $sel_where[] = ['t.user_id','=',$this->user_id];
  1020. $sel_where[] = ['t.type','=',3];
  1021. $sel_where[] = ['t.end_int','>',time()];
  1022. $list = UserLearn::where($sel_where)
  1023. ->alias('t')
  1024. ->field('t.id,t.create_at,t.first_id article_id,t.second_id item_id,i.title,i.cover,a.total_sequel')
  1025. ->leftJoin('ArticleItem i','t.second_id = i.id')
  1026. ->leftJoin('ArticleIntro a','t.first_id = a.id')
  1027. ->order('id desc')
  1028. ->limit($this->off_set,$this->page_num)
  1029. ->select()->toArray();
  1030. array_walk($list,function (&$v){
  1031. $v['is_normal'] = CheckPower::checkModulesPower($v['article_id'],$v['item_id'],$this->request->controller());
  1032. $recently_id = UserTrack::getRecentlyTrack($this->user_id,3,$v['article_id']);
  1033. $v['is_recently'] = $recently_id ? 1 : 0;
  1034. $v['recently_title'] = ArticleItem::where('id',$recently_id)->value('title');
  1035. });
  1036. $total_num = UserLearn::where($sel_where)->alias('t') ->leftJoin('ArticleItem i','t.second_id = i.id')
  1037. ->leftJoin('ArticleIntro a','t.first_id = a.id')->count();
  1038. $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
  1039. }
  1040. /**
  1041. * @title 我的回复【我的回复--我回复过的评论】
  1042. * @desc 我的回复
  1043. * @author qc
  1044. * @method GET
  1045. * @url /api/Article/getReplyArticle
  1046. * @header name:Authorization require:1 desc:Token
  1047. * @param name:title type:string default:-- desc:标题
  1048. * @param name:page type:int default:0 desc:页数
  1049. * @param name:page_num type:int default:20 desc:每页数
  1050. * @return name:title type:string default:-- desc:标题
  1051. * @return name:article_id type:string default:-- desc:文章id
  1052. * @return name:item_id type:string default:-- desc:item_id
  1053. * @return name:cover type:string default:-- desc:封面
  1054. * @return name:create_at type:string default:-- desc:时间
  1055. * @return name:is_top type:int default:-- desc:是否置顶(0否1是)
  1056. * @return name:user_name type:string default:-- desc:用户名【用户自己的】
  1057. * @return name:headimg type:string default:-- desc:用户头像【用户自己的】
  1058. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  1059. * @return name:parent_comment type:array default:-- desc:上级评论内容【你评论的那个评论】
  1060. * @return name:parent_comment.content type:string default:-- desc:内容
  1061. * @return name:parent_comment.name type:string default:-- desc:会员名称
  1062. * @return name:parent_comment.title type:string default:-- desc:图文标题
  1063. * @return name:parent_comment.article_id type:string default:-- desc:文章id
  1064. * @return name:parent_comment.item_id type:string default:-- desc:item_id
  1065. */
  1066. public function getReplyArticle()
  1067. {
  1068. $user_info = $this->userInfo();
  1069. $sel_where = [];
  1070. $title = input('get.title');
  1071. if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
  1072. $sel_where[] = ['t.user_id','=',$this->user_id];
  1073. $sel_where[] = ['t.is_deleted','=',0];
  1074. $sel_where[] = ['t.lev','>=',2];
  1075. $list = ArticleComment::where($sel_where)
  1076. ->alias('t')
  1077. ->field('t.id,t.article_id,t.is_top,t.item_id,t.create_at,t.lev,t.content,i.title,t.pid')
  1078. ->leftJoin('ArticleItem i','t.item_id = i.id')
  1079. ->order('t.is_top desc,t.id desc')
  1080. ->limit($this->off_set,$this->page_num)
  1081. ->select()->toArray();
  1082. foreach ($list as &$v) {
  1083. $v['user_name'] = $user_info['name'];
  1084. $v['headimg'] = $user_info['headimg'];
  1085. $v['is_normal'] = CheckPower::checkModulesPower($v['article_id'],$v['item_id'],$this->request->controller());
  1086. $parent_comment = ArticleComment::where([['t.id','=',$v['pid']]])
  1087. ->field('t.id,t.article_id,t.is_top,t.item_id,t.content,i.title,i.cover,t.pid,u.name')
  1088. ->alias('t')
  1089. ->leftJoin('ArticleItem i','t.item_id = i.id')
  1090. ->leftJoin('store_member u','t.user_id = u.id')
  1091. ->find()->toArray();
  1092. $v['parent_comment'] = $parent_comment;
  1093. }
  1094. $total_num = ArticleComment::where($sel_where)->alias('t') ->leftJoin('ArticleItem i','t.item_id = i.id')->count();
  1095. $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
  1096. }
  1097. /**
  1098. * @title 回复我的【回复我的--回复过我的评论】
  1099. * @desc 回复我的
  1100. * @author qc
  1101. * @method GET
  1102. * @url /api/Article/getReplyComment
  1103. * @header name:Authorization require:1 desc:Token
  1104. * @param name:title type:string default:-- desc:标题
  1105. * @param name:page type:int default:0 desc:页数
  1106. * @param name:page_num type:int default:20 desc:每页数
  1107. * @return name:title type:string default:-- desc:标题
  1108. * @return name:article_id type:string default:-- desc:文章id
  1109. * @return name:item_id type:string default:-- desc:item_id
  1110. * @return name:cover type:string default:-- desc:封面
  1111. * @return name:is_read type:int default:-- desc:是否已读(0未读1已读)
  1112. * @return name:is_top type:int default:-- desc:是否置顶(0否1是)
  1113. * @return name:create_at type:string default:-- desc:时间
  1114. * @return name:is_deleted type:int default:-- desc:0未删除
  1115. * @return name:user_name type:string default:-- desc:用户名【其他会员】
  1116. * @return name:headimg type:string default:-- desc:用户头【其他会员】
  1117. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  1118. * @return name:parent_comment type:array default:-- desc:你的评论内容【别人回复的那个评论】
  1119. * @return name:parent_comment.content type:string default:-- desc:内容
  1120. * @return name:parent_comment.name type:string default:-- desc:会员名称
  1121. * @return name:parent_comment.title type:string default:-- desc:图文标题
  1122. * @return name:parent_comment.article_id type:string default:-- desc:文章id
  1123. * @return name:parent_comment.item_id type:string default:-- desc:item_id
  1124. * @return name:parent_comment.is_deleted type:int default:-- desc:0未删除
  1125. */
  1126. public function getReplyComment()
  1127. {
  1128. $all_comment = ArticleComment::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
  1129. if(empty($all_comment)) $this->success('ok',['list'=>null]);
  1130. $sel_where = [];
  1131. $title = input('get.title');
  1132. if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
  1133. $sel_where[] = ['t.is_deleted','=',0];
  1134. $sel_where[] = ['t.lev','>=',2];
  1135. //$sel_where[] = ['t.user_id','<>',$this->user_id];
  1136. $sel_where[] = ['t.pid','in',implode(',',$all_comment)];
  1137. $list = ArticleComment::where($sel_where)
  1138. ->alias('t')
  1139. ->field('t.id,t.is_read,t.article_id,t.is_top,t.is_deleted,t.item_id,t.create_at,t.lev,t.content,t.pid,u.name user_name,u.headimg')
  1140. ->leftJoin('store_member u','t.user_id = u.id')
  1141. ->leftJoin('ArticleItem i','t.item_id = i.id')
  1142. ->order('t.is_top desc,t.id desc')
  1143. ->limit($this->off_set,$this->page_num)
  1144. ->select()->toArray();
  1145. foreach ($list as &$v) {
  1146. $v['is_normal'] = CheckPower::checkModulesPower($v['article_id'],$v['item_id'],$this->request->controller());
  1147. $parent_comment = ArticleComment::where([['t.id','=',$v['pid']]])
  1148. ->field('t.id,t.article_id,t.is_top,t.item_id,t.content,i.title,i.cover,t.pid,u.name,t.is_deleted')
  1149. ->alias('t')
  1150. ->leftJoin('ArticleItem i','t.item_id = i.id')
  1151. ->leftJoin('store_member u','t.user_id = u.id')
  1152. ->find()->toArray();
  1153. $v['parent_comment'] = $parent_comment;
  1154. }
  1155. $total_num = ArticleComment::where($sel_where)->alias('t') ->leftJoin('store_member u','t.user_id = u.id')
  1156. ->leftJoin('ArticleItem i','t.item_id = i.id')->count();
  1157. $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
  1158. }
  1159. /**
  1160. * @title 图文点赞列表【我的点赞】
  1161. * @desc 图文点赞列表
  1162. * @author qc
  1163. * @method GET
  1164. * @url /api/Article/getTagsArticle
  1165. * @header name:Authorization require:1 desc:Token
  1166. * @param name:title type:string default:-- desc:标题
  1167. * @param name:page type:int default:0 desc:页数
  1168. * @param name:page_num type:int default:20 desc:每页数
  1169. * @return name:title type:string default:-- desc:标题
  1170. * @return name:article_id type:string default:-- desc:文章id
  1171. * @return name:item_id type:string default:-- desc:item_id
  1172. * @return name:like_num type:string default:-- desc:点赞量
  1173. * @return name:is_like type:string default:-- desc:是否点赞[0否1是]
  1174. * @return name:cover type:string default:-- desc:封面
  1175. * @return name:is_vip type:int default:-- desc:是否vip[0否1是]
  1176. * @return name:create_at type:string default:-- desc:时间
  1177. * @return name:read_num type:int default:-- desc:阅读量
  1178. * @return name:images_arr type:array default:-- desc:图片
  1179. * @return name:app_name type:string default:-- desc:发布方名称
  1180. * @return name:app_logo type:string default:-- desc:发布方头像
  1181. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  1182. * @return name:desc type:string default:-- desc:简介
  1183. * @return name:switch_open type:int default:-- desc:通知开关【0关闭1开启】
  1184. * @return name:transmit_num type:int default:-- desc:转发量
  1185. * @return name:comment_num type:int default:-- desc:评论量
  1186. * @return name:is_collect type:int default:-- desc:是否收藏
  1187. * @return name:collect_num type:int default:-- desc:收藏量
  1188. */
  1189. public function getTagsArticle()
  1190. {
  1191. $sel_where = [];
  1192. $title = input('get.title');
  1193. if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
  1194. $sel_where[] = ['t.user_id','=',$this->user_id];
  1195. $list = ArticleLike::where($sel_where)
  1196. ->alias('t')
  1197. ->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,i.transmit_num,i.desc')
  1198. ->leftJoin('ArticleItem i','t.item_id = i.id')
  1199. ->order('id desc')
  1200. ->limit($this->off_set,$this->page_num)
  1201. ->select()->toArray();
  1202. foreach ($list as &$v) {
  1203. $v['switch_open'] = PlatformSwitch::checkSwitch($this->user_id,$v['article_id'],8);
  1204. $v['like_num'] = ArticleLike::where(['article_id'=>$v['article_id'],'item_id'=>$v['item_id']])->count();
  1205. $v['like_num'] = numTransform($v['like_num']);
  1206. $v['read_num'] = numTransform($v['read_num']);
  1207. $v['is_like'] = ArticleLike::where(['user_id'=>$this->user_id,'article_id'=>$v['article_id'],'item_id'=>$v['item_id']])->count();
  1208. $v['images_arr'] = $v['images'] ? explode('|',$v['images']):null;
  1209. $v['is_normal'] = CheckPower::checkModulesPower($v['article_id'],$v['item_id'],$this->request->controller());
  1210. $article_auth = ArticleItem::getArticleAuth($v['user_id'],APPNAME,APPLOGO);
  1211. $v['app_name'] = $article_auth['app_name'];
  1212. $v['app_logo'] = $article_auth['app_logo'];
  1213. $v['is_collect'] = UserCollect::checkCollectByType($this->user_id,3,$v['article_id'],$v['item_id']);
  1214. $v['collect_num'] = UserCollect::getCollectNum(3,$v['article_id'],$v['item_id']);
  1215. $v['comment_num'] = ArticleComment::getArticleCommentNum($v['item_id']);
  1216. }
  1217. $total_num = ArticleLike::where($sel_where)->alias('t') ->leftJoin('ArticleItem i','t.item_id = i.id')->count();
  1218. $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
  1219. }
  1220. /**
  1221. * @title 以下接口为二期需求
  1222. * @desc 以下接口为二期需求
  1223. * @author qc
  1224. * @url /api/Article/secondPhase
  1225. * @method
  1226. * @return name:1 type:string default:-- desc:以下接口为二期需求
  1227. */
  1228. public function secondPhase(){}
  1229. /**
  1230. * @title 我的发布[审核成功]--后台图文绑定该会员
  1231. * @desc 后台图文绑定该会员
  1232. * @author qc
  1233. * @method GET
  1234. * @url /api/Article/getBoundList
  1235. * @header name:Authorization require:1 desc:Token
  1236. * @param name:title type:string default:-- desc:标题
  1237. * @param name:page type:int default:0 desc:页数
  1238. * @param name:page_num type:int default:20 desc:每页数
  1239. * @return name:id type:string default:-- desc:记录id【item_id】
  1240. * @return name:title type:string default:-- desc:标题
  1241. * @return name:article_id type:string default:-- desc:图文id
  1242. * @return name:cover type:string default:-- desc:封面
  1243. * @return name:create_at type:string default:-- desc:时间
  1244. * @return name:is_vip type:int default:-- desc:是否是vip[0否1是]
  1245. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  1246. */
  1247. public function getBoundList()
  1248. {
  1249. $sel_where = [];
  1250. $title = input('get.title');
  1251. $sel_where[] = ['user_id','=',$this->user_id];
  1252. $sel_where[] = ['is_deleted','=',0];
  1253. if($title) $sel_where[] = ['title|label','like','%'.$title.'%'];
  1254. $list = ArticleItem::where($sel_where)
  1255. ->alias('t')
  1256. ->field('id,title,cover,read_num,label,is_vip,article_id,create_at')
  1257. ->order('id desc')
  1258. ->limit($this->off_set,$this->page_num)
  1259. ->select()->toArray();
  1260. foreach ($list as &$v) {
  1261. $v['is_normal'] = CheckPower::checkModulesPower($v['article_id'],$v['id'],$this->request->controller());;
  1262. $v['label_name'] =$v['label'] ? explode(',',trim($v['label'],',')) :null;
  1263. }
  1264. $total_num = ArticleItem::where($sel_where)->alias('t')->count();
  1265. $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
  1266. }
  1267. /**
  1268. * @title 我的订阅列表--图文
  1269. * @desc 我的订阅列表
  1270. * @author qc
  1271. * @method GET
  1272. * @url /api/Article/getFollowUpList
  1273. * @header name:Authorization require:1 desc:Token
  1274. * @param name:title type:string default:-- desc:标题
  1275. * @param name:page type:int default:0 desc:页数
  1276. * @param name:page_num type:int default:20 desc:每页数
  1277. * @return name:create_at type:string default:-- desc:追更设置时间
  1278. * @return name:article_id type:int default:-- desc:图文id
  1279. * @return name:total_sequel type:int default:-- desc:期数
  1280. * @return name:title type:string default:-- desc:标题
  1281. * @return name:is_recently type:int default:-- desc:是否最近观看【0否1是】
  1282. * @return name:recently_title type:string default:-- desc:上次观看标题
  1283. */
  1284. public function getFollowUpList()
  1285. {
  1286. $sel_where = [];
  1287. $sel_where[] = ['p.user_id','=',$this->user_id];
  1288. $sel_where[] = ['p.type','=',3];
  1289. $sel_where[] = ['p.switch_value','=',1];
  1290. $field = 'p.id,p.switch_id as article_id,p.create_at,a.title,a.total_sequel';
  1291. $list = PlatformSwitch::field($field)
  1292. ->alias('p')
  1293. ->leftJoin('ArticleIntro a','p.switch_id = a.id')
  1294. ->where($sel_where)
  1295. ->limit($this->off_set,$this->page_num)
  1296. ->order('p.id desc')
  1297. ->select()->toArray();
  1298. array_walk($list,function ($v){
  1299. $recently_id = UserTrack::getRecentlyTrack($this->user_id,3,$v['article_id']);
  1300. $v['is_recently'] = $recently_id ? 1 : 0;
  1301. $v['recently_title'] = ArticleItem::where('id',$recently_id)->value('title');
  1302. });
  1303. $total_num= PlatformSwitch::field($field)->alias('p') ->leftJoin('ArticleIntro a','p.switch_id = a.id')->where($sel_where)->count();
  1304. $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
  1305. }
  1306. /**
  1307. * @title 我的订阅---消息
  1308. * @desc 订阅消息
  1309. * @author qc
  1310. * @method GET
  1311. * @url /api/Article/getFollowUpMessage
  1312. * @header name:Authorization require:1 desc:Token
  1313. * @param name:page type:int default:-- desc:页数
  1314. * @param name:page_num type:int default:-- desc:每页数
  1315. *
  1316. * @return name:id type:int default:-- desc:记录id
  1317. * @return name:title type:string default:-- desc:标题
  1318. * @return name:content type:string default:-- desc:内容
  1319. * @return name:create_at type:string default:-- desc:时间
  1320. * @return name:is_read type:int default:-- desc:是否已读【0否1是】
  1321. * @return name:article_title type:string default:-- desc:系列标题
  1322. */
  1323. public function getFollowUpMessage()
  1324. {
  1325. $list = UserMessage::where(['m.user_id'=>$this->user_id,'m.is_deleted'=>0,'m.module'=>'article','m.type_id'=>5])
  1326. ->alias('m')
  1327. ->field('m.id,v.create_at,m.is_read,m.content,m.relation_id article_id,m.module,v.title article_title')
  1328. ->leftJoin('ArticleIntro v','v.id= m.relation_id')
  1329. ->limit($this->off_set,$this->page_num)
  1330. ->order(['m.id'=>'desc'])
  1331. ->select()->toArray();
  1332. $total_num = UserMessage::where(['m.user_id'=>$this->user_id,'m.is_deleted'=>0,'m.module'=>'article','m.type_id'=>5])
  1333. ->alias('m')->leftJoin('ArticleIntro v','v.id= m.relation_id')->count();
  1334. $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
  1335. }
  1336. /**
  1337. * @title 评论点赞列表--我的点赞
  1338. * @desc 评论点赞列表
  1339. * @author qc
  1340. * @method GET
  1341. * @url /api/Article/getTagsComment
  1342. * @header name:Authorization require:1 desc:Token
  1343. * @param name:title type:string default:-- desc:标题
  1344. * @param name:page type:int default:0 desc:页数
  1345. * @param name:page_num type:int default:20 desc:每页数
  1346. * @return name:create_at type:string default:-- desc:时间
  1347. * @return name:user_name type:string default:-- desc:会员名称
  1348. * @return name:headimg type:string default:-- desc:会员头像
  1349. * @return name:content type:string default:-- desc:评论内容
  1350. * @return name:cover type:string default:-- desc:封面
  1351. * @return name:title type:string default:-- desc:标题
  1352. * @return name:read_num type:string default:-- desc:阅读量
  1353. * @return name:app_name type:string default:-- desc:发布者
  1354. * @return name:app_logo type:string default:-- desc:发布者头像
  1355. */
  1356. public function getTagsComment()
  1357. {
  1358. $list = ArticleCommentLike::field('l.*,i.read_num,c.content,i.read_num,i.title,i.cover,u.name user_name,u.headimg,i.user_id buid')
  1359. ->alias('l')
  1360. ->where(['l.user_id'=>$this->user_id,'l.type'=>1])
  1361. ->leftJoin('ArticleComment c','l.like_id = c.id')
  1362. ->leftJoin('ArticleItem i','i.id = c.item_id')
  1363. ->leftJoin('store_member u','u.id = c.user_id')
  1364. ->order('l.id desc')
  1365. ->limit($this->off_set,$this->page_num)
  1366. ->select()->toArray();
  1367. array_walk($list,function (&$v){
  1368. $article_auth = ArticleItem::getArticleAuth($v['buid'],APPNAME,APPLOGO);
  1369. $v['app_name'] = $article_auth['app_name'];
  1370. $v['app_logo'] = $article_auth['app_logo'];
  1371. });
  1372. $total_num =ArticleCommentLike::where(['l.user_id'=>$this->user_id,'l.type'=>1])
  1373. ->alias('l')
  1374. ->leftJoin('ArticleComment c','l.like_id = c.id')
  1375. ->leftJoin('ArticleItem i','i.id = c.item_id')
  1376. ->leftJoin('store_member u','u.id = c.user_id')
  1377. ->count();
  1378. $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
  1379. }
  1380. /**
  1381. * @title 获取角标数量
  1382. * @desc 获取角标数量
  1383. * @author qc
  1384. * @method GET
  1385. * @url /api/Article/getMarkNum
  1386. * @header name:Authorization require:1 desc:Token
  1387. * @return name:reply_num type:int default:-- desc:未读量--回复我的
  1388. * @return name:comment_num type:int default:-- desc:未读量--评论我的
  1389. * @return name:praise_num type:int default:-- desc:点赞我的【包含视频点赞和评论点赞】
  1390. * @return name:article_praise_num type:int default:-- desc:-图文点赞
  1391. * @return name:comment_praise_num type:int default:-- desc:评论点赞
  1392. * @return name:follow_num type:int default:-- desc:订阅
  1393. */
  1394. public function getMarkNum()
  1395. {
  1396. // 评论我的
  1397. $comment_num = ArticleComment::where([['t.is_deleted','=',0],['i.user_id','=',$this->user_id],['is_read','=',0]])
  1398. ->leftJoin('ArticleItem i','t.item_id = i.id')
  1399. ->alias('t')->count();
  1400. // 回复我的
  1401. $all_comment = ArticleComment::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
  1402. $reply_num = ArticleComment::where([['t.is_deleted','=',0],['t.lev','>=',2],['is_read','=',0],['t.pid','in',implode(',',$all_comment)]])->alias('t')->count();
  1403. // 点赞我的
  1404. $all_article = ArticleItem::where('user_id',$this->user_id)->where('is_deleted',0)->column('id');
  1405. $article_praise_num = ArticleCommentLike::where([['is_read','=',0],['like_id','in',$all_article]])->count();
  1406. $comment_praise_num = ArticleLike::where([['is_read','=',0],['item_id','in',$all_comment]])->count();
  1407. $praise_num = $article_praise_num + $comment_praise_num;
  1408. $follow_num = UserMessage::getUnreadNum($this->user_id,'article',5);
  1409. $this->success('ok',compact(['reply_num','comment_num','praise_num','article_praise_num','comment_praise_num','follow_num']));
  1410. }
  1411. /**
  1412. * @title 消息已读&&未读变更
  1413. * @desc 消息已读
  1414. * @author qc
  1415. * @method POST
  1416. * @url /api/Article/unreadChange
  1417. * @header name:Authorization require:1 desc:Token
  1418. * @param name:id type:string default:-- desc:记录id(多个逗号隔开)
  1419. * @param name:type type:string default:1 desc:消息类型【1评论我的,2回复我的,3订阅消息】
  1420. * @param name:is_read type:int default:1 desc:变更类型【0消息变更为未读,1变更为已读】
  1421. *
  1422. */
  1423. public function unreadChange()
  1424. {
  1425. $type = input('post.type',1);
  1426. switch ($type) {
  1427. case 3:
  1428. UserMessage::where('id','in',input('post.id'))->update(['is_read'=>input('post.is_read')]);
  1429. break;
  1430. default :
  1431. ArticleComment::where('id','in',input('post.id'))->update(['is_read'=>input('post.is_read')]);
  1432. break;
  1433. }
  1434. $this->success('消息变更成功');
  1435. }
  1436. /**
  1437. * @title 批量删除||批量取消
  1438. * @desc 删除||取消
  1439. * @author qc
  1440. * @method POST
  1441. * @url /api/Article/batchesDel
  1442. * @header name:Authorization require:1 desc:Token
  1443. * @param name:id type:int default:1 desc:记录id【多个用逗号隔开=>'1,2'】
  1444. * @param name:type type:string default:1 desc:消息类型【1我的评论,2评论我的,3我的回复,4我的已购,5用户图文删除,6订阅记录,7订阅消息,8我的点赞-图文,9我的点赞-评论,10回复我的,11点赞我的--图文,12点赞我的--评论,13我的收藏】
  1445. */
  1446. public function batchesDel(){
  1447. $type = input('post.type',1);
  1448. $del_where = [];
  1449. $del_where[] = ['id','in',input('post.id')];
  1450. if(in_array($type,[1,3,4,5,6,7,8,9])) $del_where[] = ['user_id','=',$this->user_id];
  1451. if(in_array($type,[1,2,3,10])) ArticleComment::where($del_where)->update(['is_deleted'=>1]);
  1452. if(in_array($type,[4])) UserLearn::where($del_where)->update(['is_deleted'=>1]);
  1453. if(in_array($type,[5])) UserArticle::where($del_where)->update(['is_deleted'=>1]);
  1454. if(in_array($type,[6])) UserLearn::where($del_where)->update(['is_deleted'=>1]);
  1455. if(in_array($type,[7])) UserMessage::where($del_where)->update(['is_deleted'=>1]);
  1456. if(in_array($type,[8,11])) ArticleLike::where($del_where)->delete();
  1457. if(in_array($type,[9,12])) ArticleCommentLike::where($del_where)->delete();
  1458. if(in_array($type,[13])) UserCollect::where($del_where)->delete();
  1459. $this->success('删除成功');
  1460. }
  1461. /**
  1462. * @title 点赞我的--图文
  1463. * @desc 点赞我的--图文
  1464. * @author qc
  1465. * @method GET
  1466. * @url /api/Article/praiseMyArticleList
  1467. * @header name:Authorization require:1 desc:Token
  1468. * @param name:page type:int default:-- desc:页数
  1469. * @param name:page_num type:int default:-- desc:每页数
  1470. *
  1471. * @return name:id type:int default:-- desc:记录id
  1472. * @return name:title type:string default:-- desc:标题
  1473. * @return name:create_at type:string default:-- desc:时间
  1474. * @return name:read_num type:int default:-- desc:阅读量
  1475. * @return name:user_name type:string default:-- desc:会员名称
  1476. * @return name:headimg type:string default:-- desc:会员头像
  1477. * @return name:cover type:string default:-- desc:封面
  1478. */
  1479. public function praiseMyArticleList()
  1480. {
  1481. $all_list = ArticleItem::where('user_id',$this->user_id)->where('is_deleted',0)->column('id');
  1482. $user_info = $this->userInfo('name,headimg');
  1483. $list = ArticleLike::where([['item_id','in',$all_list]])
  1484. ->alias('l')
  1485. ->field('l.id,l.user_id,m.name user_name,m.headimg,l.create_at,v.cover,v.title,v.read_num')
  1486. ->leftJoin('StoreMember m','m.id = l.user_id')
  1487. ->join('ArticleItem v','v.id = l.item_id')
  1488. ->limit($this->off_set,$this->page_num)
  1489. ->select()->toArray();
  1490. array_walk($list,function (&$v,$k)use ($user_info){
  1491. $v['app_name'] = $user_info['name'] ;
  1492. $v['app_logo'] = $user_info['headimg'];
  1493. $v['read_num'] = numTransform($v['read_num']);
  1494. });
  1495. $total_num = ArticleLike::where([['item_id','in',$all_list]])
  1496. ->alias('l')
  1497. ->leftJoin('StoreMember m','m.id = l.user_id')
  1498. ->join('ArticleItem v','v.id = l.item_id')
  1499. ->count();
  1500. $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
  1501. }
  1502. /**
  1503. * @title 点赞我的--评论
  1504. * @desc 点赞我的--评论
  1505. * @author qc
  1506. * @method GET
  1507. * @url /api/Article/praiseMyComment
  1508. * @header name:Authorization require:1 desc:Token
  1509. * @param name:page type:int default:-- desc:页数
  1510. * @param name:page_num type:int default:-- desc:每页数
  1511. *
  1512. * @return name:id type:int default:-- desc:记录id
  1513. * @return name:title type:string default:-- desc:标题
  1514. * @return name:create_at type:string default:-- desc:时间
  1515. * @return name:read_num type:int default:-- desc:播放量
  1516. * @return name:user_name type:string default:-- desc:会员名称
  1517. * @return name:headimg type:string default:-- desc:会员头像
  1518. * @return name:cover type:string default:-- desc:封面
  1519. */
  1520. public function praiseMyComment()
  1521. {
  1522. $user_info = $this->userInfo('name,headimg');
  1523. $list = ArticleCommentLike::where([['c.user_id','=',$this->user_id]])
  1524. ->alias('l')
  1525. ->field('l.id,l.user_id,m.name user_name,m.headimg,l.create_at,v.cover,v.title,v.read_num')
  1526. ->leftJoin('StoreMember m','m.id = l.user_id')
  1527. ->leftJoin('ArticleComment c','c.id = l.like_id')
  1528. ->join('ArticleItem v','v.id = c.item_id')
  1529. ->limit($this->off_set,$this->page_num)
  1530. ->select()->toArray();
  1531. array_walk($list,function (&$v,$k)use ($user_info){
  1532. $v['app_name'] = $user_info['name'] ;
  1533. $v['app_logo'] = $user_info['headimg'];
  1534. $v['read_num'] = numTransform($v['read_num']);
  1535. });
  1536. $total_num = ArticleCommentLike::where([['c.user_id','=',$this->user_id]])
  1537. ->alias('l')->leftJoin('StoreMember m','m.id = l.user_id')
  1538. ->leftJoin('ArticleComment c','c.id = l.like_id')
  1539. ->join('ArticleItem v','v.id = c.item_id')->count();
  1540. $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
  1541. }
  1542. }