Article.php 102 KB

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