Datum.php 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398
  1. <?php
  2. namespace app\api\controller;
  3. use app\common\model\DatumCate;
  4. use app\common\model\DatumIntro;
  5. use app\common\model\DatumLike;
  6. use app\common\model\DatumUrl;
  7. use app\common\model\UserCollect;
  8. use app\common\model\UserDatum;
  9. use app\common\model\UserLevelRank;
  10. use app\common\model\UserSearch;
  11. use library\tools\Data;
  12. /**
  13. * @title 资料
  14. * @controller Datum
  15. * @group base
  16. */
  17. class Datum extends Base
  18. {
  19. // 需要登录的
  20. protected $need_login = [
  21. 'datumTransmit',
  22. 'datumRead',
  23. 'datumCollect',
  24. 'datumTags',
  25. 'userReferDatum',
  26. 'getMyDatumList',
  27. 'getUserDatumDetail',
  28. 'delUserDatum'];
  29. public function initialize()
  30. {
  31. parent::initialize();
  32. parent::setUid();
  33. }
  34. /**
  35. * @title 资料接口说明
  36. * @desc 资料接口说明
  37. * @author qc
  38. * @url /api/Datum/classIntro
  39. * @method GET
  40. * @return name:1 type:string default:-- desc:单一资料与系列资料区别,type值(1是单一,2是系列),数据:url_arr二维数组数据数量不一样(单一的只有一个,系列的可以是多个)【可以将单一资料看做只有一条记录的系列资料!!!!】
  41. * @return name:2 type:string default:-- desc:单一资料详情的字段(除id)与url_arr数组的第一个同字段名的值相同
  42. * @return name:3 type:string default:-- desc:系列资料详情的字段(除id)与url_arr数组的其中一个同字段名的值相同
  43. * @return name:4 type:string default:-- desc:关于是否的字段(0否,1是)
  44. * @return name:5 type:string default:-- desc:url_id是详情或列表url_arr下的id
  45. */
  46. public function classIntro(){ }
  47. /**
  48. * @title 获取资料目录
  49. * @desc 获取资料目录
  50. * @author qc
  51. * @url /api/Datum/getDatumCate
  52. * @method GET
  53. * @header name:Authorization require:1 desc:Token
  54. * @return name:id type:int default:-- desc:id
  55. * @return name:title type:string default:0 desc:名称
  56. * @return name:datum_list type:array default:0 desc:目录下的资料
  57. * @return name:datum_list.id type:int default:0 desc:资料记录
  58. * @return name:datum_list.title type:int default:0 desc:资料标题
  59. */
  60. public function getDatumCate()
  61. {
  62. $list = DatumCate::field('id,title')->where('is_deleted',0)->select()->toArray();
  63. foreach ($list as &$v) {
  64. $v['datum_list'] = DatumIntro::field('id,title')->where(['datum_cate'=>$v['id']])->select()->toArray();
  65. }
  66. $this->success('ok',['list'=>$list]);
  67. }
  68. /**
  69. * @title 获取资料列表(平台发布)
  70. * @desc 获取资料列表
  71. * @author qc
  72. * @method GET
  73. * @url /api/Datum/getDatumList
  74. * @header name:Authorization require:1 desc:Token
  75. * @param name:type type:int default:0 desc:类型1单个2系列
  76. * @param name:is_tj type:int default:0 desc:是否推荐0否1是
  77. * @param name:title type:string default:-- desc:标题
  78. * @param name:page type:int default:0 desc:页数
  79. * @param name:page_num type:int default:20 desc:每页数
  80. * @param name:sort_type type:int default:1 desc:1默认2时间升序3时间降序
  81. * @return name:title type:string default:-- desc:标题
  82. * @return name:type type:int default:0 desc:类型1单个2系列
  83. * @return name:datum_url type:string default:-- desc:资料地址
  84. * @return name:is_vip type:int default:-- desc:是否是vip(0否,1是)
  85. * @return name:is_over type:int default:-- desc:是否完结(0否,1是)
  86. * @return name:label type:string default:-- desc:标签
  87. * @return name:is_collect type:int default:-- desc:是否收藏
  88. * @return name:url_arr type:array default:-- desc:资料
  89. * @return name:url_arr.title type:string default:-- desc:资料标题
  90. * @return name:url_arr.is_vip type:int default:-- desc:是否是vip
  91. * @return name:url_arr.url type:string default:-- desc:资料地址
  92. */
  93. public function getDatumList()
  94. {
  95. $sel_where = [];
  96. $title = input('get.title');
  97. $type = input('get.type',0);
  98. $is_tj = input('get.is_tj',0);
  99. $sort_type = input('get.sort_type',1);
  100. $sel_where[] = ['is_deleted','=',0];
  101. $sel_where[] = ['status','=',1];
  102. $sel_where[] = ['url_num','>',0];
  103. if($title) $sel_where[] = ['title','like','%'.$title.'%'];
  104. if($type) $sel_where[] = ['type','=',$type];
  105. $order = 'is_top desc,sort desc ,id desc';
  106. if($sort_type == 2)$order = 'id asc';
  107. if($sort_type == 3)$order = 'id desc';
  108. if($title && $this->user_id) UserSearch::saveSearchTitle($this->user_id,$title,3);
  109. $where_str = 'id > 0';
  110. if($is_tj) {
  111. $search_log = UserSearch::getSearchTitle($this->user_id,3);
  112. $search_arr = [];
  113. foreach ($search_log as $t){
  114. $search_arr[] = " title like '".'%'.$t."%'" .' ';
  115. }
  116. if(!empty($search_arr)) $where_str = implode(' OR ',$search_arr);
  117. }
  118. $list = DatumIntro::where($sel_where)->with('urlArr')
  119. ->limit($this->off_set,$this->page_num)
  120. ->where($where_str)
  121. ->order($order)
  122. ->select()->toArray();
  123. array_walk($list,function (&$v,$k){
  124. $v['is_collect'] = UserCollect::checkCollectByType($this->user_id,2,$v['id']);
  125. });
  126. $this->success('ok',['list'=>$list]);
  127. }
  128. /**
  129. * @title 获取资料详情(平台)
  130. * @desc 获取资料详情
  131. * @author qc
  132. * @method GET
  133. * @url /api/Datum/getDatumDetail
  134. * @header name:Authorization require:1 desc:Token
  135. * @param name:id type:int default:0 desc:资料id
  136. * @return name:title type:string default:-- desc:标题
  137. * @return name:datum_url type:string default:-- desc:资料地址
  138. * @return name:url_arr type:array default:-- desc:资料
  139. * @return name:url_arr.title type:string default:-- desc:资料标题
  140. * @return name:url_arr.is_vip type:int default:-- desc:是否是vip
  141. * @return name:url_arr.url type:string default:-- desc:资料地址
  142. * @return name:url_arr.is_collect type:int default:-- desc:是否收藏
  143. * @return name:url_arr.collect_num type:int default:-- desc:收藏量
  144. */
  145. public function getDatumDetail()
  146. {
  147. $sel_where = [];
  148. $sel_where[] = ['id','=',input('get.id')];
  149. $detail = DatumIntro::where($sel_where)->with('urlArr')->find()->toArray();
  150. if($detail['is_deleted'] == 1 || $detail['status'] == 0)$this->error('该资料已下线');
  151. $level_id = UserLevelRank::getUserVip($this->user_id);
  152. foreach ($detail['url_arr'] as &$dv) {
  153. if($dv['is_vip'] && !$level_id) $dv['url'] = '';
  154. $dv['is_collect'] = UserCollect::checkCollectByType($this->user_id,2,$detail['id'],$dv['id']);
  155. $dv['collect_num'] = UserCollect::where(['user_id'=>$this->user_id,'coll_type'=>1,'coll_id'=>$detail['id'],'children_id'=>$dv['id']])->count();
  156. }
  157. $detail['read_num'] = array_sum(array_column($detail['url_arr'],'read_num'));
  158. $this->success('ok',['detail'=>$detail]);
  159. }
  160. /**
  161. * @title 获取资料ITEM详情(平台)
  162. * @desc 获取资料ITEM详情
  163. * @author qc
  164. * @method GET
  165. * @url /api/Datum/getDatumItemInfo
  166. * @header name:Authorization require:1 desc:Token
  167. * @param name:url_id type:int default:0 desc:url_id
  168. * @return name:title type:string default:-- desc:资料标题
  169. * @return name:is_vip type:int default:-- desc:是否是vip
  170. * @return name:cover type:string default:-- desc:封面
  171. * @return name:images type:int default:-- desc:图片
  172. * @return name:content type:int default:-- desc:内容
  173. * @return name:transmit_num type:int default:-- desc:转发量
  174. * @return name:read_num type:int default:-- desc:阅读量
  175. * @return name:collect_num type:int default:-- desc:收藏量
  176. * @return name:is_collect type:int default:-- desc:是否收藏
  177. */
  178. public function getDatumItemInfo()
  179. {
  180. $url_id = input('get.url_id');
  181. $detail = DatumUrl::where('id',$url_id)->find()->toArray();
  182. $detail['collect_num'] = UserCollect::where(['coll_type'=>2,'coll_id'=>$detail['datum_id'],'children_id'=>$detail['id']])->count();
  183. $detail['is_collect'] = UserCollect::checkCollectByType($this->user_id,2,$detail['datum_id'],$detail['id']);
  184. $this->success('ok',['detail'=>$detail]);
  185. }
  186. /**
  187. * @title 资料转发(转发数量统计)
  188. * @desc 转发成功后调用
  189. * @author qc
  190. * @method POST
  191. * @url /api/Datum/datumTransmit
  192. * @header name:Authorization require:1 desc:Token
  193. * @param name:datum_id type:int default:-- desc:资料id
  194. * @param name:url_id type:int default:-- desc:url_id
  195. */
  196. public function datumTransmit()
  197. {
  198. $datum_id= input('post.datum_id');
  199. $url_id = input('post.url_id',0);
  200. DatumUrl::where('id',$url_id)->setInc('transmit_num');
  201. $this->success('ok');
  202. }
  203. /**
  204. * @title 资料阅读(阅读数量统计)
  205. * @desc 资料阅读
  206. * @author qc
  207. * @method POST
  208. * @url /api/Datum/datumRead
  209. * @header name:Authorization require:1 desc:Token
  210. * @param name:url_id type:int default:-- desc:url_arr的id
  211. */
  212. public function datumRead()
  213. {
  214. $url_id = input('post.url_id',0);
  215. DatumUrl::where('id',$url_id)->setInc('read_num');
  216. $this->success('ok');
  217. }
  218. /**
  219. * @title 资料收藏||取消收藏
  220. * @desc 用户收藏
  221. * @author qc
  222. * @method POST
  223. * @url /api/Datum/datumCollect
  224. * @header name:Authorization require:1 desc:Token
  225. * @param name:datum_id type:int require:1 default:-- desc:记录id[资料id]
  226. * @param name:url_id type:int default:1 desc:url_id
  227. * @param name:status type:int default:0 desc:收藏状态(0取消收藏【未收藏】,1收藏)
  228. */
  229. public function datumCollect()
  230. {
  231. $coll_type = input('post.coll_type',2);
  232. $coll_id = input('post.datum_id',0);
  233. $url_id = input('post.url_id',0);
  234. $collect_check = UserCollect::checkCollectByType($this->user_id,$coll_type,$coll_id,$url_id);
  235. if($collect_check) {
  236. UserCollect::where(['user_id'=>$this->user_id,'coll_type'=>$coll_type,'coll_id'=>$coll_id,'children_id'=>$url_id])->delete();
  237. $this->success('取消收藏成功',['status'=>0]);
  238. }else{
  239. Data::save('UserCollect', [
  240. 'user_id'=>$this->user_id,
  241. 'coll_type'=>$coll_type,
  242. 'coll_id'=>$coll_id,
  243. 'children_id'=>$url_id,
  244. 'create_int'=>time()],'user_id',['user_id'=>$this->user_id,'coll_type'=>$coll_type, 'coll_id'=>$coll_id,'children_id'=>$url_id]);
  245. $this->success('收藏成功',['status'=>1]);
  246. }
  247. }
  248. /**
  249. * @title 资料点赞||取消点赞
  250. * @desc 点赞||取消点赞
  251. * @author qc
  252. * @method POST
  253. * @url /api/Datum/datumTags
  254. * @header name:Authorization require:1 desc:Token
  255. * @param name:datum_id type:int default:1 desc:资料id
  256. * @param name:url_id type:int default:1 desc:url_id
  257. * @return name:tags type:int default:1 desc:0取消成功,1点赞成功
  258. */
  259. public function datumTags()
  260. {
  261. $datum_id = input('post.datum_id');
  262. $url_id = input('post.url_id');
  263. $ret_val = 0;
  264. $check_tags = DatumLike::where(['user_id'=>$this->user_id,'datum_id'=>$datum_id,'url_id'=>$url_id])->value('id');
  265. if($check_tags) {
  266. DatumLike::where(['user_id'=>$this->user_id,'datum_id'=>$datum_id,'url_id'=>$url_id])->delete();
  267. }else{
  268. Data::save('DatumLike',
  269. ['user_id'=>$this->user_id,'datum_id'=>$datum_id,'url_id'=>$url_id],'user_id',
  270. ['user_id'=>$this->user_id,'datum_id'=>$datum_id,'url_id'=>$url_id]);
  271. $ret_val = 1;
  272. }
  273. $this->success($ret_val == 1 ?'点赞成功':'取消成功',['tags'=>$ret_val]);
  274. }
  275. /**
  276. * @title 用户提交或修改资料【个人】
  277. * @desc 用户提交或修改资料【个人】
  278. * @author qc
  279. * @method POST
  280. * @url /api/Datum/userReferDatum
  281. * @header name:Authorization require:1 desc:Token
  282. * @param name:id type:int default:-- desc:id(修改时必传)
  283. * @param name:title type:string default:-- desc:标题
  284. * @param name:datum_url type:string default:-- desc:资料地址
  285. * @param name:desc type:string default:-- desc:简介
  286. * @param name:label type:string default:-- desc:资料标签id(多个用逗号隔开)
  287. */
  288. public function userReferDatum()
  289. {
  290. $id = input('post.id',0);
  291. $title = input('post.title');
  292. $desc = input('post.desc');
  293. $datum_url = input('post.datum_url');
  294. $label = input('post.label');
  295. if(!$datum_url) $this->error('请上传资料');
  296. if($id){
  297. $check_status = UserDatum::where('id',$id)->value('status');
  298. if($check_status == 1) $this->error('已审核通过,不允许修改');
  299. }
  300. $data = [
  301. 'title' => $title,
  302. 'user_id' => $this->user_id,
  303. 'desc' => $desc,
  304. 'datum_url' => $datum_url,
  305. 'label' => $label,
  306. ];
  307. if($id) $data['id'] = $id;
  308. if($id){
  309. UserDatum::where('id',$id)->update($data);
  310. }else{
  311. $res= UserDatum::create($data) ;
  312. }
  313. $this->success('提交成功,请等待审核',['id'=> $id ? :$res->id]);
  314. }
  315. /**
  316. * @title 获取我的资料列表【个人】
  317. * @desc 获取我的资料列表【个人】
  318. * @author qc
  319. * @method GET
  320. * @url /api/Datum/getMyDatumList
  321. * @header name:Authorization require:1 desc:Token
  322. * @param name:title type:string default:-- desc:标题
  323. * @param name:page type:int default:0 desc:页数
  324. * @param name:page_num type:int default:20 desc:每页数
  325. * @return name:title type:string default:-- desc:标题
  326. * @return name:desc type:string default:-- desc:简介
  327. * @return name:datum_url type:string default:-- desc:资料地址
  328. * @return name:status type:int default:-- desc:0待审核1审核通过2审核未通过
  329. * @return name:remark type:string default:-- desc:审核备注
  330. */
  331. public function getMyDatumList()
  332. {
  333. $sel_where = [];
  334. $sel_where[] = ['is_deleted','=',0];
  335. $sel_where[] = ['user_id','=',$this->user_id];
  336. $title = input('get.title');
  337. if($title) $sel_where[] = ['title','like','%'.$title.'%'];
  338. $list = UserDatum::where($sel_where)
  339. ->field('id,title,desc,datum_url,status,remark')
  340. ->order('id desc')
  341. ->limit($this->off_set,$this->page_num)
  342. ->select()->toArray();
  343. $this->success('ok',['list'=>$list]);
  344. }
  345. /**
  346. * @title 获取我的资料详情【个人】
  347. * @desc 获取我的资料列表【个人】
  348. * @author qc
  349. * @method GET
  350. * @url /api/Datum/getUserDatumDetail
  351. * @header name:Authorization require:1 desc:Token
  352. * @param name:id type:string default:-- desc:记录id
  353. * @return name:title type:string default:-- desc:标题
  354. * @return name:desc type:string default:-- desc:简介
  355. * @return name:datum_url type:string default:-- desc:资料地址
  356. * @return name:status type:int default:-- desc:0待审核1审核通过2审核未通过
  357. * @return name:remark type:string default:-- desc:审核备注
  358. */
  359. public function getUserDatumDetail()
  360. {
  361. $detail =UserDatum::where('id',input('get.id'))->field('id,title,desc,datum_url,status,remark')->find();
  362. if(!$detail) $this->error('资料有误');
  363. $this->success('ok',['detail'=>$detail->toArray()]);
  364. }
  365. /**
  366. * @title 用户删除资料记录【个人】
  367. * @desc 用户删除资料记录【个人】
  368. * @author qc
  369. * @method POST
  370. * @url /api/Datum/delUserDatum
  371. * @header name:Authorization require:1 desc:Token
  372. * @param name:id type:int default:-- desc:id
  373. */
  374. public function delUserDatum()
  375. {
  376. UserDatum::where(['user_id'=>$this->user_id,'id'=>input('post.id')])->delete();
  377. $this->success('删除成功');
  378. }
  379. }