Article.php 102 KB

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