Supplier.php 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692
  1. <?php
  2. namespace app\api\controller;
  3. use app\common\model\PlatformLike;
  4. use app\common\model\PlatformSwitch;
  5. use app\common\model\PressComment;
  6. use app\common\model\SupplierCate;
  7. use app\common\model\UserCollect;
  8. use app\common\model\UserSearch;
  9. use app\common\model\SupplierGoods;
  10. use app\common\model\UserTrack;
  11. use app\common\service\CheckPower;
  12. use library\tools\Data;
  13. use think\Db;
  14. /**
  15. * @title 供应商
  16. * @controller Supplier
  17. * @group base
  18. */
  19. class Supplier extends Base
  20. {
  21. // 需要登录的
  22. protected $need_login = [
  23. 'supplierGoodsTags',
  24. 'supplierGoodsCollect',
  25. 'supplierTransmit',
  26. 'supplierGoodsTransmit',
  27. 'getSupplierGoodsTrack',
  28. 'getTagsSupplierGoods',
  29. 'getCollectSupplierGoods',
  30. 'getFollowUpList',
  31. ];
  32. public function initialize()
  33. {
  34. parent::initialize();
  35. parent::setUid();
  36. }
  37. /**
  38. * @title 供应商接口说明
  39. * @desc 供应商接口说明
  40. * @author qc
  41. * @url /api/Supplier/classIntro
  42. * @method GET
  43. * @return name:1 type:string default:-- desc:--
  44. */
  45. public function classIntro(){}
  46. /**
  47. * @title 获取供应商分类
  48. * @desc 两级分类
  49. * @author qc
  50. * @url /api/Supplier/getSupplierCate
  51. * @method GET
  52. * @header name:Authorization require:1 desc:Token
  53. * @return name:id type:int default:-- desc:分类id
  54. * @return name:title type:string default:0 desc:分类名称
  55. * @return name:children type:array default:0 desc:下级分类
  56. */
  57. public function getSupplierCate()
  58. {
  59. $list = SupplierCate::where(['is_deleted'=>0])->field('id,title,pid')->order('sort desc,id asc')->select()->toArray();
  60. $list = make_tree($list);
  61. $this->success('ok',['list'=>$list]);
  62. }
  63. /**
  64. * @title 联系我们(详情内部)【两个二维码】
  65. * @desc 联系我们
  66. * @author qc
  67. * @method GET
  68. * @url /api/Supplier/getSupplierContact
  69. * @header name:Authorization require:1 desc:Token
  70. * @param name:supplier_id type:int default:-- desc:供应商id
  71. * @return name:phone type:string default:-- desc:供应商电话
  72. * @return name:email type:string default:-- desc:供应商email
  73. * @return name:qr_code type:int default:-- desc:供应商二维码
  74. * @return name:contact_qrcode type:string default:-- desc:平台二维码
  75. * @return name:contact_phone type:string default:-- desc:平台电话
  76. * @return name:contact_email type:string default:-- desc:平台邮箱
  77. */
  78. public function getSupplierContact()
  79. {
  80. $sel_where[] = ['id','=',input('get.supplier_id')];
  81. $detail = \app\common\model\Supplier::field('id,phone,email,qr_code')->where($sel_where)->find()->toArray();
  82. $contact = Db::name('contact')->where('tag','supplier')->field('qrcode contact_qrcode,phone contact_phone,email contact_email')->find();
  83. $contact['phone'] = $detail['phone'];
  84. $contact['email'] = $detail['email'];
  85. $contact['qr_code'] = $detail['qr_code'];
  86. $this->success('ok',$contact);
  87. }
  88. /**
  89. * @title 获取供应商列表
  90. * @desc 获取供应商列表
  91. * @author qc
  92. * @method GET
  93. * @url /api/Supplier/getSupplierList
  94. * @header name:Authorization require:1 desc:Token
  95. * @param name:title type:string default:-- desc:标题
  96. * @param name:page type:int default:0 desc:页数
  97. * @param name:page_num type:int default:20 desc:每页数
  98. * @param name:sort_type type:int default:1 desc:1默认2时间升序3时间降序
  99. * @param name:first_classify type:int default:0 desc:一级分类id
  100. * @param name:second_classify type:int default:0 desc:二级分类id
  101. *
  102. * @return name:title type:string default:-- desc:名称
  103. * @return name:cover type:string default:-- desc:公司logo
  104. * @return name:phone type:string default:-- desc:电话
  105. * @return name:email type:string default:-- desc:email
  106. * @return name:label_name type:array default:-- desc:标签
  107. * @return name:content type:string default:-- desc:供应商详情
  108. * @return name:create_at type:string default:-- desc:时间
  109. * @return name:build_time type:string default:-- desc:成立时间
  110. * @return name:work_place type:string default:-- desc:办公地点
  111. * @return name:business type:string default:-- desc:业务范围
  112. * @return name:total_num type:int default:-- desc:总评论数(仅一级)
  113. */
  114. public function getSupplierList(){
  115. $title = input('get.title');
  116. $sort_type = input('get.sort_type',1);
  117. $first_classify = input('get.first_classify');
  118. $second_classify = input('get.second_classify');
  119. switch ($sort_type) {
  120. case 1:
  121. $order = ['sort'=>'desc','id'=>'asc'];
  122. break;
  123. case 2:
  124. $order = ['id'=>'asc','sort'=>'desc'];
  125. break;
  126. case 3:
  127. $order = ['id'=>'desc','sort'=>'desc'];
  128. break;
  129. }
  130. $sel_where = [];
  131. $sel_where[] = ['is_deleted','=',0];
  132. $sel_where[] = ['status','=',1];
  133. if($first_classify) $sel_where[] = ['first_classify','=',$first_classify];
  134. if($second_classify) $sel_where[] = ['second_classify','=',$second_classify];
  135. if($title && $this->user_id) UserSearch::saveSearchTitle($this->user_id,$title,9);
  136. $list = \app\common\model\Supplier::where($sel_where)
  137. ->when($title,function ($query)use($title){
  138. if($title) $query->where('title|label','like','%'.$title.'%');
  139. })->order($order)->limit($this->off_set,$this->page_num)->select()->toArray();
  140. foreach ($list as &$v) {
  141. $v['cover'] =$v['logo'] ;
  142. $v['label_name'] =$v['label'] ? explode(',',trim($v['label'],',')):null;
  143. $v['business_arr'] = $v['business'] ? explode(',',trim($v['business'],',')) : null;
  144. }
  145. $total_num =\app\common\model\Supplier::where($sel_where)->when($title,function ($query)use($title){
  146. if($title) $query->where('title|label','like','%'.$title.'%');
  147. })->count();
  148. $this->success('ok',['list'=>$list,'total_num'=>numTransform($total_num),'total_count'=>$total_num,'page_num'=>$this->page_num]);
  149. }
  150. /**
  151. * @title 获取供应商详情
  152. * @desc 获取供应商详情
  153. * @author qc
  154. * @method GET
  155. * @url /api/Supplier/getSupplierDetail
  156. * @header name:Authorization require:1 desc:Token
  157. * @param name:id type:int default:-- desc:供应商记录id
  158. * @return name:title type:string default:-- desc:名称
  159. * @return name:cover type:string default:-- desc:公司logo
  160. * @return name:phone type:string default:-- desc:电话
  161. * @return name:email type:string default:-- desc:email
  162. * @return name:label_name type:array default:-- desc:标签
  163. * @return name:content type:string default:-- desc:供应商详情
  164. * @return name:create_at type:string default:-- desc:时间
  165. * @return name:build_time type:string default:-- desc:成立时间
  166. * @return name:work_place type:string default:-- desc:办公地点
  167. * @return name:business type:string default:-- desc:业务范围
  168. */
  169. public function getSupplierDetail()
  170. {
  171. $sel_where[] = ['id','=',input('get.id')];
  172. $detail = \app\common\model\Supplier::where($sel_where)->find()->toArray();
  173. $detail['label_name'] =$detail['label'] ? explode(',',trim($detail['label'],',')):null;
  174. $detail['business_arr'] = $detail['business'] ? explode(',',trim($detail['business'],',')) : null;
  175. UserTrack::crateTrack($this->user_id,9,input('get.id'),0);
  176. $this->success('ok',['detail'=>$detail]);
  177. }
  178. /**
  179. * @title 供应商商品推荐
  180. * @desc 供应商商品推荐
  181. * @author qc
  182. * @method GET
  183. * @url /api/Supplier/getRecommendList
  184. * @header name:Authorization require:1 desc:Token
  185. * @param name:page type:int default:0 desc:页数
  186. * @param name:page_num type:int default:20 desc:每页数
  187. * @return name:id type:int default:-- desc:供应商商品d
  188. * @return name:name type:string default:-- desc:商品名称
  189. * @return name:cover_arr type:array default:-- desc:封面
  190. * @return name:label_name type:array default:-- desc:标签
  191. * @return name:label type:string default:-- desc:标签
  192. * @return name:supplier_name type:float default:-- desc:供应商名称
  193. * @return name:supplier_logo type:string default:-- desc供应商logo
  194. * @return name:read_num type:int default:-- desc:阅读量
  195. *
  196. */
  197. public function getRecommendList()
  198. {
  199. $search_log = UserSearch::getSearchTitle($this->user_id,10);
  200. $search_arr = [];
  201. $where_str = 'b.id > 0';
  202. foreach ($search_log as $t){
  203. $search_arr[] = " b.name like '".'%'.$t."%'" .' ';
  204. $search_arr[] = " b.label like '".'%'.$t."%'" .' ';
  205. }
  206. if(!empty($search_arr)) $where_str = implode(' OR ',$search_arr);
  207. $field = 'a.id,a.supplier_id,a.name,a.label,a.cover,a.read_num,IFNULL(is_recommend,0) is_recommend ';
  208. $table = 'dd_supplier_goods';
  209. $order_by_two = 'a.read_num';
  210. $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_supplier as k ON a.supplier_id = k.id WHERE a.is_deleted = 0 AND a.status = 1 AND k.status =1 AND k.is_deleted = 0 ORDER BY is_recommend DESC , $order_by_two desc LIMIT {$this->off_set},{$this->page_num}";
  211. $list = Db::query($sql);
  212. $list = dispose_recommend($list);
  213. array_walk($list,function (&$v,$k){
  214. $supplier_info =\app\common\model\Supplier::where('id',$v['supplier_id'])->find()->toArray();
  215. $v['supplier_name']=$supplier_info['title'];
  216. $v['supplier_logo'] =$supplier_info['logo'];
  217. $v['read_num'] = numTransform($v['read_num']);
  218. $v['label_name'] = $v['label']? explode(',',trim($v['label'],',')) : null;
  219. $v['cover_arr'] = $v['cover']? explode('|',trim($v['cover'],'|')):null;
  220. });
  221. $sql2 = "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_supplier as k ON a.supplier_id = k.id WHERE a.is_deleted = 0 AND a.status = 1 AND k.status =1 AND k.is_deleted = 0 ";
  222. $total = Db::query($sql2);
  223. $this->success('ok',['list'=>$list,'total_count'=>$total[0]['num'],'page_num'=>$this->page_num]);
  224. }
  225. /**
  226. * @title 供应商商品列表【产品集合】
  227. * @desc 供应商商品列表
  228. * @author qc
  229. * @method GET
  230. * @url /api/Supplier/getSupplierGoodsList
  231. * @header name:Authorization require:1 desc:Token
  232. * @param name:supplier_id type:int default:-- desc:供应商记录id
  233. * @param name:page type:int default:0 desc:页数
  234. * @param name:page_num type:int default:20 desc:每页数
  235. * @param name:sort_type type:int default:1 desc:1默认2时间升序3时间降序
  236. *
  237. * @return name:name type:string default:-- desc:名称
  238. * @return name:supplier_name type:string default:-- desc:供应商名称
  239. * @return name:supplier_logo type:string default:-- desc供应商logo
  240. * @return name:cover type:string default:-- desc:图片【多张|隔开】
  241. * @return name:cover_arr type:array default:-- desc:图片数组
  242. * @return name:label_name type:array default:-- desc:标签
  243. * @return name:content type:string default:-- desc:详情
  244. * @return name:article_id type:int default:-- desc:关联图文id【单个id||系列id】
  245. * @return name:article_item type:int default:-- desc:关联图文详情id【item_list.id】
  246. * @return name:datum_id type:int default:-- desc:资料id【单个id||系列id】
  247. * @return name:datum_item type:int default:-- desc:资料详情id【url_arr.id】
  248. * @return name:video_id type:int default:-- desc:关联视频id【单个id||系列id】
  249. * @return name:video_item type:int default:-- desc:关联视频详情id【video_arr.id】
  250. * @return name:total_num type:array default:-- desc:总数
  251. *
  252. */
  253. public function getSupplierGoodsList()
  254. {
  255. $supplier_id = input('get.supplier_id');
  256. $sort_type = input('get.sort_type',1);
  257. switch ($sort_type) {
  258. case 1:
  259. $order = ['sort'=>'desc','read_num'=>'desc','id'=>'asc'];
  260. break;
  261. case 2:
  262. $order = ['id'=>'asc','sort'=>'desc'];
  263. break;
  264. case 3:
  265. $order = ['id'=>'desc','sort'=>'desc'];
  266. break;
  267. }
  268. $sel_where = [];
  269. $sel_where[] = ['is_deleted','=',0];
  270. $sel_where[] = ['status','=',1];
  271. $sel_where[] = ['supplier_id','=',$supplier_id];
  272. $list = SupplierGoods::where($sel_where)->order($order)->limit($this->off_set,$this->page_num)->select()->toArray();
  273. $supplier_info = \app\common\model\Supplier::where('id',$supplier_id)->find()->toArray();
  274. foreach ($list as &$v) {
  275. $v['label_name'] =$v['label'] ? explode(',',trim($v['label'],',')):null;
  276. $v['cover_arr'] =$v['cover'] ? explode('|',trim($v['cover'])):null;
  277. $v['supplier_name'] =$supplier_info['title'];
  278. $v['supplier_logo'] =$supplier_info['logo'];
  279. }
  280. $total_num = SupplierGoods::where($sel_where)->count();
  281. $this->success('ok',['list'=>$list,'total_num'=>numTransform($total_num),'total_count'=>$total_num,'page_num'=>$this->page_num]);
  282. }
  283. /**
  284. * @title 供应商产品详情
  285. * @desc 供应商产品详情
  286. * @author qc
  287. * @method GET
  288. * @url /api/Supplier/getSupplierGoodsDetail
  289. * @header name:Authorization require:1 desc:Token
  290. * @param name:goods_id type:int default:-- desc:供应商产品id
  291. * @return name:name type:string default:-- desc:名称
  292. * @return name:cover type:string default:-- desc:图片【多张逗号隔开】
  293. * @return name:cover_arr type:array default:-- desc:图片数组
  294. * @return name:label_name type:array default:-- desc:标签
  295. * @return name:content type:string default:-- desc:详情
  296. * @return name:article_id type:int default:-- desc:关联图文id【单个id||系列id】
  297. * @return name:article_item type:int default:-- desc:关联图文详情id【item_list.id】
  298. * @return name:datum_id type:int default:-- desc:资料id【单个id||系列id】
  299. * @return name:datum_item type:int default:-- desc:资料详情id【url_arr.id】
  300. * @return name:video_id type:int default:-- desc:关联视频id【单个id||系列id】
  301. * @return name:video_item type:int default:-- desc:关联视频详情id【video_arr.id】
  302. * @return name:is_collect type:int default:-- desc:是否收藏
  303. * @return name:collect_num type:int default:-- desc:收藏量
  304. * @return name:praise_num type:int default:-- desc:点赞量
  305. * @return name:is_praise type:int default:-- desc:是否点赞
  306. * @return name:transmit_num type:int default:-- desc:转发量
  307. *
  308. * @return name:supplier_info type:array default:-- desc:供应商详情
  309. * @return name:supplier_info.title type:string default:-- desc:名称
  310. * @return name:supplier_info.cover type:string default:-- desc:公司logo
  311. * @return name:supplier_info.phone type:string default:-- desc:电话
  312. * @return name:supplier_info.email type:string default:-- desc:email
  313. * @return name:supplier_info.label_name type:array default:-- desc:标签
  314. * @return name:supplier_info.content type:string default:-- desc:供应商详情
  315. * @return name:supplier_info.create_at type:string default:-- desc:时间
  316. * @return name:supplier_info.build_time type:string default:-- desc:成立时间
  317. * @return name:supplier_info.work_place type:string default:-- desc:办公地点
  318. * @return name:supplier_info.business type:string default:-- desc:业务范围
  319. */
  320. public function getSupplierGoodsDetail()
  321. {
  322. $goods_id = input('get.goods_id');
  323. $detail = SupplierGoods::where('id',$goods_id)->find()->toArray();
  324. $detail['label_name'] =$detail['label'] ? explode(',',trim($detail['label'],',')):null;
  325. $detail['is_collect'] = UserCollect::checkCollectByType($this->user_id,9,$detail['id']);
  326. $detail['collect_num'] = UserCollect::getCollectNum(9,$detail['id']);
  327. $detail['is_praise'] = PlatformLike::checkTags($this->user_id,$detail['id'],7);
  328. $detail['praise_num'] = PlatformLike::getPraiseNum($detail['id'],7);
  329. $detail['read_num'] = numTransform($detail['read_num']);
  330. $detail['transmit_num'] = numTransform($detail['transmit_num']);
  331. $supplier_info = \app\common\model\Supplier::where('id',$detail['supplier_id'])->find()->toArray();
  332. $supplier_info['label_name'] =$supplier_info['label'] ? explode(',',trim($supplier_info['label'],',')):null;
  333. $supplier_info['business_arr'] = $supplier_info['business'] ? explode(',',trim($supplier_info['business'],',')) : null;
  334. $supplier_info['cover'] = $supplier_info['logo'] ;
  335. UserTrack::crateTrack($this->user_id,10,$goods_id,0);
  336. SupplierGoods::where('id',$goods_id)->setInc('read_num');
  337. $this->success('ok',['detail'=>$detail,'supplier_info'=>$supplier_info]);
  338. }
  339. /**
  340. * @title 供应商搜索列表
  341. * @desc 供应商搜索列表
  342. * @author qc
  343. * @method GET
  344. * @url /api/Supplier/searchGoods
  345. * @header name:Authorization require:1 desc:Token
  346. * @param name:search_name type:int default:-- desc:搜索名称
  347. * @param name:page type:int default:0 desc:页数
  348. * @param name:page_num type:int default:20 desc:每页数
  349. * @param name:sort_type type:int default:1 desc:1默认2时间升序3时间降序
  350. *
  351. * @return name:name type:string default:-- desc:名称
  352. * @return name:supplier_name type:string default:-- desc:供应商名称
  353. * @return name:cover type:string default:-- desc:图片【多张逗号隔开】
  354. * @return name:cover_arr type:array default:-- desc:图片数组
  355. * @return name:label_name type:array default:-- desc:标签
  356. * @return name:content type:string default:-- desc:详情
  357. * @return name:read_num type:int default:-- desc:浏览量
  358. * @return name:article_id type:int default:-- desc:关联图文id【单个id||系列id】
  359. * @return name:article_item type:int default:-- desc:关联图文详情id【item_list.id】
  360. * @return name:datum_id type:int default:-- desc:资料id【单个id||系列id】
  361. * @return name:datum_item type:int default:-- desc:资料详情id【url_arr.id】
  362. * @return name:video_id type:int default:-- desc:关联视频id【单个id||系列id】
  363. * @return name:video_item type:int default:-- desc:关联视频详情id【video_arr.id】
  364. * @return name:supplier_name type:string default:-- desc:供应商名称
  365. * @return name:supplier_logo type:string default:-- desc供应商logo
  366. * @return name:total_num type:array default:-- desc:总数
  367. *
  368. */
  369. public function searchGoods()
  370. {
  371. $search_name = input('get.search_name');
  372. $sort_type = input('get.sort_type',1);
  373. switch ($sort_type) {
  374. case 1:
  375. $order = ['g.sort'=>'desc','read_num'=>'desc','g.id'=>'asc'];
  376. break;
  377. case 2:
  378. $order = ['g.id'=>'asc','g.sort'=>'desc'];
  379. break;
  380. case 3:
  381. $order = ['g.id'=>'desc','g.sort'=>'desc'];
  382. break;
  383. }
  384. $sel_where = [];
  385. $sel_where[] = ['g.is_deleted','=',0];
  386. $sel_where[] = ['s.is_deleted','=',0];
  387. $sel_where[] = ['g.status','=',1];
  388. $sel_where[] = ['s.status','=',1];
  389. if($search_name && $this->user_id) UserSearch::saveSearchTitle($this->user_id,$search_name,10);
  390. $list = SupplierGoods::where($sel_where)
  391. ->field('g.id,g.supplier_id,g.name,g.label,g.read_num,g.cover,s.title supplier_name,s.logo supplier_logo')
  392. ->when($search_name,function ($query)use($search_name){
  393. if($search_name) $query->where('g.name|g.label','like','%'.$search_name.'%');
  394. })->alias('g')
  395. ->leftJoin('Supplier s','g.supplier_id = s.id')
  396. ->order($order)->limit($this->off_set,$this->page_num)->select()->toArray();
  397. foreach ($list as &$v) {
  398. $v['label_name'] =$v['label'] ? explode(',',trim($v['label'],',')):null;
  399. $v['cover_arr'] =$v['cover'] ? explode('|',trim($v['cover'])):null;
  400. $v['read_num'] = numTransform($v['read_num']);
  401. }
  402. $total_num = SupplierGoods::where($sel_where)->alias('g')->leftJoin('Supplier s','g.supplier_id = s.id')->when($search_name,function ($query)use($search_name){
  403. if($search_name) $query->where('g.name|g.label','like','%'.$search_name.'%');
  404. })->count();
  405. $this->success('ok',['list'=>$list,'total_num'=>numTransform($total_num),'total_count'=>$total_num,'page_num'=>$this->page_num]);
  406. }
  407. /**
  408. * @title 以下接口调用验证登录【需要header传Authorization】
  409. * @desc 以下接口调用验证登录
  410. * @author qc
  411. * @method
  412. * @url /api/Supplier/needLogin()
  413. */
  414. public function needLogin(){}
  415. /**
  416. * @title 供应商商品点赞||取消点赞
  417. * @desc 点赞||取消点赞
  418. * @author qc
  419. * @method POST
  420. * @url /api/Supplier/supplierGoodsTags
  421. * @header name:Authorization require:1 desc:Token
  422. * @param name:id type:int default:1 desc:供应商商品记录id
  423. * @return name:tags type:int default:1 desc:0取消成功,1点赞成功
  424. */
  425. public function supplierGoodsTags()
  426. {
  427. $ret_val = PlatformLike::userTags($this->user_id,input('post.id'),7);
  428. $this->success($ret_val == 1 ?'点赞成功':'取消成功',['tags'=>$ret_val]);
  429. }
  430. /**
  431. * @title 供应商商品收藏||取消收藏
  432. * @desc 用户收藏
  433. * @author qc
  434. * @method POST
  435. * @url /api/Supplier/supplierGoodsCollect
  436. * @header name:Authorization require:1 desc:Token
  437. * @param name:id type:int require:1 default:-- desc:供应商商品记录id
  438. * @param name:status type:int default:0 desc:收藏状态(0取消收藏【未收藏】,1收藏)
  439. */
  440. public function supplierGoodsCollect(){
  441. $coll_status = UserCollect::plateCollect($this->user_id,9,input('post.id',0));
  442. $coll_status ? $this->success('收藏成功',['status'=>1]) : $this->success('取消收藏成功',['status'=>0]);
  443. }
  444. /**
  445. * @title 转发(转发数量统计【供应商】)
  446. * @desc 转发成功后调用
  447. * @author qc
  448. * @method POST
  449. * @url /api/Supplier/supplierTransmit
  450. * @header name:Authorization require:1 desc:Token
  451. * @param name:id type:int default:-- desc:供应商记录id
  452. */
  453. public function supplierTransmit()
  454. {
  455. $id = input('post.id',0);
  456. \app\common\model\Supplier::where('id',$id)->setInc('transmit_num');
  457. $this->success('ok');
  458. }
  459. /**
  460. * @title 转发(转发数量统计【供应商商品】)
  461. * @desc 转发成功后调用
  462. * @author qc
  463. * @method POST
  464. * @url /api/Supplier/supplierGoodsTransmit
  465. * @header name:Authorization require:1 desc:Token
  466. * @param name:id type:int default:-- desc:供应商商品记录id
  467. */
  468. public function supplierGoodsTransmit()
  469. {
  470. $id = input('post.id',0);
  471. SupplierGoods::where('id',$id)->setInc('transmit_num');
  472. $this->success('ok');
  473. }
  474. /**
  475. * @title 我的浏览历史【供应商商品】
  476. * @desc 我的浏览历史
  477. * @author qc
  478. * @method GET
  479. * @url /api/Supplier/getSupplierGoodsTrack
  480. * @header name:Authorization require:1 desc:Token
  481. * @param name:name type:string default:-- desc:商品名称
  482. * @param name:page type:int default:-- desc:页数
  483. * @param name:page_num type:int default:-- desc:每页数
  484. * @return name:id type:string default:-- desc:浏览记录id
  485. * @return name:goods_id type:string default:-- desc:商品id
  486. * @return name:name type:string default:-- desc:名称
  487. * @return name:cover type:string default:-- desc:封面(多张|隔开)
  488. * @return name:cover_arr type:array default:-- desc:封面
  489. * @return name:label_name type:array default:-- desc:标签
  490. * @return name:supplier_name type:array default:-- desc:供应商名称
  491. * @return name:time type:string default:-- desc:时间
  492. */
  493. public function getSupplierGoodsTrack()
  494. {
  495. $sel_where = [];
  496. $sel_where[] = ['t.user_id','=',$this->user_id];
  497. $sel_where[] = ['t.type','=',10];
  498. $name = input('get.name');
  499. if($name) $sel_where[] = ['i.name|i.label','like','%'.$name.'%'];
  500. $list = UserTrack::where($sel_where)
  501. ->alias('t')
  502. ->field('t.id,t.update_int,t.first_id goods_id,i.name,i.cover,i.label,supplier_id')
  503. ->leftJoin('SupplierGoods i','t.first_id = i.id')
  504. ->order('update_int desc')
  505. ->limit($this->off_set,$this->page_num)
  506. ->select()->toArray();
  507. foreach ($list as &$v) {
  508. $v['time'] = date("Y-m-d H:i:s",$v['update_int']);
  509. $v['cover_arr'] = $v['cover']? explode('|',$v['cover']) : null;
  510. $v['label_name'] = $v['label']? explode(',',trim($v['label'],',')) : null;
  511. $v['supplier_name'] = \app\common\model\Supplier::where('id',$v['supplier_id'])->value('title');
  512. $v['is_normal'] = CheckPower::checkModulesPower($v['goods_id'],0,$this->request->controller());
  513. }
  514. $total_num =UserTrack::where($sel_where)->alias('t')->leftJoin('SupplierGoods i','t.first_id = i.id')->count();
  515. $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
  516. }
  517. /**
  518. * @title 我的点赞【供应商商品点赞列表】
  519. * @desc 供应商商品点赞列表
  520. * @author qc
  521. * @method GET
  522. * @url /api/Supplier/getTagsSupplierGoods
  523. * @header name:Authorization require:1 desc:Token
  524. * @param name:name type:string default:-- desc:商品名称
  525. * @param name:page type:int default:-- desc:页数
  526. * @param name:page_num type:int default:-- desc:每页数
  527. * @return name:id type:string default:-- desc:浏览记录id
  528. * @return name:goods_id type:string default:-- desc:商品id
  529. * @return name:name type:string default:-- desc:名称
  530. * @return name:cover type:string default:-- desc:封面(多张|隔开)
  531. * @return name:cover_arr type:array default:-- desc:封面
  532. * @return name:label_name type:array default:-- desc:标签
  533. * @return name:supplier_name type:array default:-- desc:供应商名称
  534. * @return name:create_at type:string default:-- desc:时间
  535. */
  536. public function getTagsSupplierGoods()
  537. {
  538. $sel_where = [];
  539. $name = input('get.name');
  540. if($name) $sel_where[] = ['i.name|i.label','like','%'.$name.'%'];
  541. $sel_where[] = ['t.user_id','=',$this->user_id];
  542. $sel_where[] = ['t.type','=',7];
  543. $list = PlatformLike::where($sel_where)
  544. ->alias('t')
  545. ->field('t.id,t.create_at,t.like_id goods_id,i.name,i.cover,i.label,supplier_id')
  546. ->leftJoin('SupplierGoods i','t.like_id = i.id')
  547. ->order('id desc')
  548. ->limit($this->off_set,$this->page_num)
  549. ->select()->toArray();
  550. foreach ($list as &$v) {
  551. $v['cover_arr'] = explode('|',$v['cover']);
  552. $v['label_name'] = explode(',',$v['label']);
  553. $v['supplier_name'] = \app\common\model\Supplier::where('id',$v['supplier_id'])->value('title');
  554. $v['is_normal'] = CheckPower::checkModulesPower($v['goods_id'],0,$this->request->controller());
  555. }
  556. $total_num = PlatformLike::where($sel_where)->alias('t')->leftJoin('SupplierGoods i','t.like_id = i.id')->count();
  557. $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
  558. }
  559. /**
  560. * @title 我的收藏【供应商商品收藏列表】
  561. * @desc 供应商商品收藏列表
  562. * @author qc
  563. * @method GET
  564. * @url /api/Supplier/getCollectSupplierGoods
  565. * @header name:Authorization require:1 desc:Token
  566. * @param name:name type:string default:-- desc:商品名称
  567. * @param name:page type:int default:-- desc:页数
  568. * @param name:page_num type:int default:-- desc:每页数
  569. *
  570. * @return name:id type:string default:-- desc:浏览记录id
  571. * @return name:goods_id type:string default:-- desc:商品id
  572. * @return name:name type:string default:-- desc:名称
  573. * @return name:cover type:string default:-- desc:封面(多张|隔开)
  574. * @return name:cover_arr type:array default:-- desc:封面
  575. * @return name:label_name type:array default:-- desc:标签
  576. * @return name:supplier_name type:array default:-- desc:供应商名称
  577. * @return name:create_at type:string default:-- desc:时间
  578. */
  579. public function getCollectSupplierGoods()
  580. {
  581. $sel_where = [];
  582. $name = input('get.name');
  583. if($name) $sel_where[] = ['i.name|i.label','like','%'.$name.'%'];
  584. $sel_where[] = ['t.user_id','=',$this->user_id];
  585. $sel_where[] = ['t.coll_type','=',9];
  586. $list = UserCollect::where($sel_where)
  587. ->alias('t')
  588. ->field('t.id,t.create_at,t.coll_id goods_id,i.name,i.cover,i.label,supplier_id')
  589. ->leftJoin('SupplierGoods i','t.coll_id = i.id')
  590. ->order('id desc')
  591. ->limit($this->off_set,$this->page_num)
  592. ->select()->toArray();
  593. foreach ($list as &$v) {
  594. $v['cover_arr'] = explode('|',$v['cover']);
  595. $v['label_name'] = explode(',',$v['label']);
  596. $v['supplier_name'] = \app\common\model\Supplier::where('id',$v['supplier_id'])->value('title');
  597. $v['is_normal'] = CheckPower::checkModulesPower($v['goods_id'],0,$this->request->controller());
  598. }
  599. $total_num= UserCollect::where($sel_where)->alias('t') ->leftJoin('SupplierGoods i','t.coll_id = i.id')->count();
  600. $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
  601. }
  602. /**
  603. * @title 以下接口为二期需求
  604. * @desc 以下接口为二期需求
  605. * @author qc
  606. * @url /api/Supplier/secondPhase
  607. * @method
  608. * @return name:1 type:string default:-- desc:以下接口为二期需求
  609. */
  610. public function secondPhase(){}
  611. /**
  612. * @title 我的追更列表
  613. * @desc 我的追更列表
  614. * @author qc
  615. * @method GET
  616. * @url /api/Datum/getFollowUpList
  617. * @header name:Authorization require:1 desc:Token
  618. * @param name:title type:string default:-- desc:标题
  619. * @param name:page type:int default:0 desc:页数
  620. * @param name:page_num type:int default:20 desc:每页数
  621. * @return name:create_at type:string default:-- desc:追更设置时间
  622. * @return name:recruit_id type:int default:-- desc:资料id
  623. * @return name:title type:string default:-- desc:标题
  624. * @return name:label type:string default:-- desc:标签
  625. */
  626. public function getFollowUpList()
  627. {
  628. $sel_where = [];
  629. $sel_where[] = ['p.user_id','=',$this->user_id];
  630. $sel_where[] = ['p.type','=',6];
  631. $sel_where[] = ['p.switch_value','=',1];
  632. $field = 'p.id,p.switch_id as article_id,p.create_at,a.title,a.label';
  633. $list = PlatformSwitch::field($field)
  634. ->alias('p')
  635. ->leftJoin('Supplier a','p.switch_id = a.id')
  636. ->where($sel_where)
  637. ->limit($this->off_set,$this->page_num)
  638. ->order('p.id desc')
  639. ->select()->toArray();
  640. $total_num= PlatformSwitch::where($sel_where)->alias('p')->leftJoin('Supplier a','p.switch_id = a.id')->count();
  641. $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
  642. }
  643. }