Supplier.php 28 KB

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