Supplier.php 77 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527
  1. <?php
  2. namespace app\api\controller;
  3. use app\common\model\ArticleItem;
  4. use app\common\model\DatumUrl;
  5. use app\common\model\PlatformLike;
  6. use app\common\model\PlatformSwitch;
  7. use app\common\model\SupplierCate;
  8. use app\common\model\SupplierComment;
  9. use app\common\model\TopSearch;
  10. use app\common\model\UserCollect;
  11. use app\common\model\UserMessage;
  12. use app\common\model\UserSearch;
  13. use app\common\model\SupplierGoods;
  14. use app\common\model\UserTrack;
  15. use app\common\model\VideoUrl;
  16. use app\common\service\CheckPower;
  17. use app\common\service\UserSynth;
  18. use think\Db;
  19. /**
  20. * @title 供应商
  21. * @controller Supplier
  22. * @group base
  23. */
  24. class Supplier extends Base
  25. {
  26. // 需要登录的
  27. protected $need_login = [
  28. 'firstComment',
  29. 'secondComment',
  30. 'supplierTags',
  31. 'supplierGoodsCollect',
  32. 'getSupplierGoodsTrack',
  33. 'supplierTransmit',
  34. 'getSupplierGoodsTrack',
  35. 'getTagsSupplierGoods',
  36. 'getTagsComment',
  37. 'getCollectSupplierGoods',
  38. 'getFollowUpList',
  39. 'praiseGoodsList',
  40. 'praiseCommentList',
  41. 'getMyGoodsList',
  42. 'commentOnMyGoods',
  43. 'getReplayComment',
  44. ];
  45. public function initialize()
  46. {
  47. parent::initialize();
  48. parent::setUid();
  49. }
  50. /**
  51. * @title 供应商接口说明
  52. * @desc 供应商接口说明
  53. * @author qc
  54. * @url /api/Supplier/classIntro
  55. * @method GET
  56. * @return name:1 type:string default:-- desc:--
  57. */
  58. public function classIntro(){}
  59. /**
  60. * @title 获取供应商分类
  61. * @desc 三级分类
  62. * @author qc
  63. * @url /api/Supplier/getSupplierCate
  64. * @method GET
  65. * @header name:Authorization require:1 desc:Token
  66. * @return name:id type:int default:-- desc:分类id
  67. * @return name:title type:string default:0 desc:分类名称
  68. * @return name:lev type:int default:0 desc:分类等级
  69. * @return name:children type:array default:0 desc:下级分类
  70. */
  71. public function getSupplierCate()
  72. {
  73. $list = SupplierCate::where(['is_deleted'=>0])->field('id,title,pid,lev,logo')->order('sort desc,id asc')->select()->toArray();
  74. $list = make_tree($list);
  75. $this->success('ok',['list'=>$list]);
  76. }
  77. /**
  78. * @title 获取第三级分类
  79. * @desc 获取第三级分类
  80. * @author qc
  81. * @url /api/Supplier/getThirdCate
  82. * @method GET
  83. * @header name:Authorization require:1 desc:Token
  84. * @param name:fid type:int default:-- desc:一级分类id
  85. * @param name:pid type:int default:-- desc:二级分类id【不传查一级分类下全部的三级分类】
  86. * @return name:id type:int default:-- desc:分类id
  87. * @return name:title type:string default:0 desc:分类名称
  88. * @return name:lev type:int default:0 desc:分类等级
  89. * @return name:children type:array default:0 desc:下级分类
  90. */
  91. public function getThirdCate()
  92. {
  93. $where = [];
  94. $where[]=['is_deleted','=',0];
  95. $where[]=['pid','=',input('fid')];
  96. if(input('pid')) $where[] = ['id','=',input('pid')];
  97. $list = SupplierCate::where($where)->field('id,title,pid,lev,logo')->order('sort desc,id asc')->select()->toArray();
  98. foreach ($list as &$v) {
  99. $v['children'] = SupplierCate::where([['is_deleted','=',0],['pid','=',$v['id']]])->field('id,title,pid,lev,logo')->order('sort desc,id asc')->select()->toArray();
  100. }
  101. $this->success('ok',['list'=>$list]);
  102. }
  103. /**
  104. * @title 联系我们(详情内部)【两个二维码】
  105. * @desc 联系我们
  106. * @author qc
  107. * @method GET
  108. * @url /api/Supplier/getSupplierContact
  109. * @header name:Authorization require:1 desc:Token
  110. * @param name:supplier_id type:int default:-- desc:供应商id
  111. * @return name:phone type:string default:-- desc:供应商电话
  112. * @return name:email type:string default:-- desc:供应商email
  113. * @return name:qr_code type:int default:-- desc:供应商二维码
  114. * @return name:contact_qrcode type:string default:-- desc:平台二维码
  115. * @return name:contact_phone type:string default:-- desc:平台电话
  116. * @return name:contact_email type:string default:-- desc:平台邮箱
  117. */
  118. public function getSupplierContact()
  119. {
  120. $sel_where[] = ['id','=',input('get.supplier_id')];
  121. $detail = \app\common\model\Supplier::field('id,phone,email,qr_code')->where($sel_where)->find()->toArray();
  122. $contact = Db::name('contact')->where('tag','supplier')->field('qrcode contact_qrcode,phone contact_phone,email contact_email')->find();
  123. $contact['phone'] = $detail['phone'];
  124. $contact['email'] = $detail['email'];
  125. $contact['qr_code'] = $detail['qr_code'];
  126. $this->success('ok',$contact);
  127. }
  128. /**
  129. * @title 获取供应商列表
  130. * @desc 获取供应商列表
  131. * @author qc
  132. * @method GET
  133. * @url /api/Supplier/getSupplierList
  134. * @header name:Authorization require:1 desc:Token
  135. * @param name:title type:string default:-- desc:标题
  136. * @param name:page type:int default:0 desc:页数
  137. * @param name:page_num type:int default:20 desc:每页数
  138. * @param name:sort_type type:int default:1 desc:1默认2时间升序3时间降序
  139. * @return name:title type:string default:-- desc:名称
  140. * @return name:cover type:string default:-- desc:公司logo
  141. * @return name:phone type:string default:-- desc:电话
  142. * @return name:email type:string default:-- desc:email
  143. * @return name:label_name type:array default:-- desc:标签
  144. * @return name:content type:string default:-- desc:供应商详情
  145. * @return name:create_at type:string default:-- desc:时间
  146. * @return name:build_time type:string default:-- desc:成立时间
  147. * @return name:work_place type:string default:-- desc:办公地点
  148. * @return name:business type:string default:-- desc:业务范围
  149. * @return name:total_num type:int default:-- desc:总评论数(仅一级)
  150. */
  151. public function getSupplierList(){
  152. $title = input('get.title');
  153. $sort_type = input('get.sort_type',1);
  154. switch ($sort_type) {
  155. case 1:
  156. $order = ['sort'=>'desc','id'=>'asc'];
  157. break;
  158. case 2:
  159. $order = ['id'=>'asc','sort'=>'desc'];
  160. break;
  161. case 3:
  162. $order = ['id'=>'desc','sort'=>'desc'];
  163. break;
  164. }
  165. $sel_where = [];
  166. $sel_where[] = ['is_deleted','=',0];
  167. $sel_where[] = ['status','=',1];
  168. if($title && $this->user_id) UserSearch::saveSearchTitle($this->user_id,$title,9);
  169. $list = \app\common\model\Supplier::where($sel_where)
  170. ->when($title,function ($query)use($title){
  171. if($title) $query->where('title|label','like','%'.$title.'%');
  172. })->order($order)->limit($this->off_set,$this->page_num)->select()->toArray();
  173. foreach ($list as &$v) {
  174. $v['cover'] =$v['logo'] ;
  175. $v['label_name'] =$v['label'] ? explode(',',trim($v['label'],',')):null;
  176. $v['business_arr'] = $v['business'] ? explode(',',trim($v['business'],',')) : null;
  177. }
  178. $total_num =\app\common\model\Supplier::where($sel_where)->when($title,function ($query)use($title){
  179. if($title) $query->where('title|label','like','%'.$title.'%');
  180. })->count();
  181. $this->success('ok',['list'=>$list,'total_num'=>numTransform($total_num),'total_count'=>$total_num,'page_num'=>$this->page_num]);
  182. }
  183. /**
  184. * @title 获取供应商详情
  185. * @desc 获取供应商详情
  186. * @author qc
  187. * @method GET
  188. * @url /api/Supplier/getSupplierDetail
  189. * @header name:Authorization require:1 desc:Token
  190. * @param name:id type:int default:-- desc:供应商记录id
  191. * @return name:title type:string default:-- desc:名称
  192. * @return name:cover type:string default:-- desc:公司logo
  193. * @return name:phone type:string default:-- desc:电话
  194. * @return name:email type:string default:-- desc:email
  195. * @return name:label_name type:array default:-- desc:标签
  196. * @return name:content type:string default:-- desc:供应商详情
  197. * @return name:create_at type:string default:-- desc:时间
  198. * @return name:build_time type:string default:-- desc:成立时间
  199. * @return name:work_place type:string default:-- desc:办公地点
  200. * @return name:business type:string default:-- desc:业务范围
  201. */
  202. public function getSupplierDetail()
  203. {
  204. $sel_where[] = ['id','=',input('get.id')];
  205. $detail = \app\common\model\Supplier::where($sel_where)->find()->toArray();
  206. $detail['label_name'] =$detail['label'] ? explode(',',trim($detail['label'],',')):null;
  207. $detail['business_arr'] = $detail['business'] ? explode(',',trim($detail['business'],',')) : null;
  208. UserTrack::crateTrack($this->user_id,9,input('get.id'),0);
  209. $this->success('ok',['detail'=>$detail]);
  210. }
  211. /**
  212. * @title 供应商产品推荐
  213. * @desc 供应商产品推荐
  214. * @author qc
  215. * @method GET
  216. * @url /api/Supplier/getRecommendList
  217. * @header name:Authorization require:1 desc:Token
  218. * @param name:page type:int default:0 desc:页数
  219. * @param name:page_num type:int default:20 desc:每页数
  220. * @param name:rand_user type:string default:-- desc:随机id(非登录状态必传,page=1时生成(a123),其他页数(a123),一直查询到没有数据)
  221. * @return name:id type:int default:-- desc:供应商产品d
  222. * @return name:name type:string default:-- desc:产品名称
  223. * @return name:cover_arr type:array default:-- desc:封面
  224. * @return name:label_name type:array default:-- desc:标签
  225. * @return name:label type:string default:-- desc:标签
  226. * @return name:supplier_name type:float default:-- desc:供应商名称
  227. * @return name:supplier_logo type:string default:-- desc供应商logo
  228. * @return name:read_num type:int default:-- desc:浏览量
  229. * @return name:release_time type:string default:-- desc:上架时间
  230. *
  231. */
  232. public function getRecommendList()
  233. {
  234. $user_id = $this->user_id ? $this->user_id : input('rand_user');
  235. if(!$user_id) $this->error('参数错误');
  236. $list = UserSynth::getRecommendList($user_id,'supplier',$this->page,$this->page_num,[],input('sort_type',1));
  237. if($list['code'] != 200) $this->error($list['msg']);
  238. $this->success('ok',$list);
  239. $search_log = UserSearch::getSearchTitle($this->user_id,10);
  240. $search_arr = [];
  241. $where_str = 'b.id > 0';
  242. foreach ($search_log as $t){
  243. $search_arr[] = " b.name like '".'%'.$t."%'" .' ';
  244. $search_arr[] = " b.label like '".'%'.$t."%'" .' ';
  245. }
  246. if(!empty($search_arr)) $where_str = implode(' OR ',$search_arr);
  247. $field = 'a.id,a.supplier_id,a.name,a.label,a.cover,a.read_num,IFNULL(is_recommend,0) is_recommend ,k.title supplier_name,k.logo supplier_logo';
  248. $table = 'dd_supplier_goods';
  249. $order_by_two = 'a.read_num';
  250. $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}";
  251. $list = Db::query($sql);
  252. $list = dispose_recommend($list);
  253. array_walk($list,function (&$v,$k){
  254. /* $supplier_info =\app\common\model\Supplier::where('id',$v['supplier_id'])->find()->toArray();
  255. $v['supplier_name']=$supplier_info['title'];
  256. $v['supplier_logo'] =$supplier_info['logo'];*/
  257. $v['read_num'] = numTransform($v['read_num']);
  258. $v['label_name'] = $v['label']? explode(',',trim($v['label'],',')) : null;
  259. $v['cover_arr'] = $v['cover']? explode('|',trim($v['cover'],'|')):null;
  260. });
  261. $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_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 ";
  262. $total = Db::query($sql2);
  263. $this->success('ok',['list'=>$list,'total_count'=>$total[0]['num'],'page_num'=>$this->page_num]);
  264. }
  265. /**
  266. * @title 合集列表--【按分类查询】
  267. * @desc 按供应商查询
  268. * @author qc
  269. * @method GET
  270. * @url /api/Supplier/getGoodsListByClassify
  271. * @header name:Authorization require:1 desc:Token
  272. * @param name:third_classify type:int default:-- desc:分类id【第三级】
  273. * @param name:sort_type type:int default:1 desc:1默认2时间升序3时间降序
  274. * @return name:name type:string default:-- desc:名称
  275. * @return name:supplier_name type:string default:-- desc:供应商名称
  276. * @return name:supplier_logo type:string default:-- desc供应商logo
  277. * @return name:cover type:string default:-- desc:图片【多张|隔开】
  278. * @return name:cover_arr type:array default:-- desc:图片数组
  279. * @return name:label_name type:array default:-- desc:标签
  280. * @return name:release_time type:string default:-- desc:上架时间
  281. * @return name:total_num type:array default:-- desc:总数
  282. *
  283. */
  284. public function getGoodsListByClassify()
  285. {
  286. $third_classify = input('get.third_classify');
  287. $sel_where = [];
  288. $sel_where[] = ['g.is_deleted','=',0];
  289. $sel_where[] = ['g.status','=',1];
  290. $sel_where[] = ['g.third_classify','=',$third_classify];
  291. $sort_type = input('get.sort_type',1);
  292. switch ($sort_type) {
  293. case 1:
  294. $order = ['g.sort'=>'desc','g.id'=>'desc'];
  295. break;
  296. case 2:
  297. $order = ['g.id'=>'asc'];
  298. break;
  299. case 3:
  300. $order = ['g.id'=>'desc'];
  301. break;
  302. }
  303. $list = SupplierGoods::where($sel_where)
  304. ->alias('g')
  305. ->field('g.id,g.label,g.cover,g.name,g.read_num,s.title supplier_name,s.logo supplier_logo,release_time')
  306. ->leftJoin('Supplier s','s.id = g.supplier_id')
  307. ->order($order)
  308. ->select()->toArray();
  309. foreach ($list as &$v) {
  310. $v['label_name'] =$v['label'] ? explode(',',trim($v['label'],',')):null;
  311. $v['cover_arr'] =$v['cover'] ? explode('|',trim($v['cover'])):null;
  312. }
  313. $total_num = SupplierGoods::where($sel_where)->alias('g')->count();
  314. $this->success('ok',['list'=>$list,'total_num'=>numTransform($total_num),'total_count'=>$total_num,'page_num'=>$this->page_num]);
  315. }
  316. /**
  317. * @title 合集列表--【按供应商查询】
  318. * @desc 按供应商查询
  319. * @author qc
  320. * @method GET
  321. * @url /api/Supplier/getSupplierGoodsList
  322. * @header name:Authorization require:1 desc:Token
  323. * @param name:supplier_id type:int default:-- desc:供应商记录id
  324. * @param name:sort_type type:int default:1 desc:1默认2时间升序3时间降序
  325. * @return name:name type:string default:-- desc:名称
  326. * @return name:supplier_name type:string default:-- desc:供应商名称
  327. * @return name:supplier_logo type:string default:-- desc供应商logo
  328. * @return name:cover type:string default:-- desc:图片【多张|隔开】
  329. * @return name:cover_arr type:array default:-- desc:图片数组
  330. * @return name:label_name type:array default:-- desc:标签
  331. * @return name:release_time type:string default:-- desc:上架时间
  332. * @return name:is_recently type:int default:-- desc:是否最近观看【0否1是】
  333. * @return name:supplier_info type:array default:-- desc:供应商信息
  334. * @return name:supplier_info.id type:int default:-- desc:供应商id
  335. * @return name:supplier_info.title type:int default:-- desc:名称
  336. * @return name:supplier_info.follow_switch type:int default:-- desc:订阅开关状态【0关闭1开启】
  337. *
  338. */
  339. public function getSupplierGoodsList()
  340. {
  341. $supplier_id = input('get.supplier_id');
  342. $sort_type = input('get.sort_type',1);
  343. switch ($sort_type) {
  344. case 1:
  345. $order = ['sort'=>'desc','read_num'=>'desc','id'=>'asc'];
  346. break;
  347. case 2:
  348. $order = ['id'=>'asc','sort'=>'desc'];
  349. break;
  350. case 3:
  351. $order = ['id'=>'desc','sort'=>'desc'];
  352. break;
  353. }
  354. $sel_where = [];
  355. $sel_where[] = ['is_deleted','=',0];
  356. $sel_where[] = ['status','=',1];
  357. $sel_where[] = ['supplier_id','=',$supplier_id];
  358. $list = SupplierGoods::where($sel_where)
  359. ->field('id,name,label,cover,create_at,read_num,release_time')
  360. ->order($order)->select()->toArray();
  361. $supplier_info = \app\common\model\Supplier::where('id',$supplier_id)->field('id,title,logo')->find()->toArray();
  362. $supplier_info['follow_switch'] = PlatformSwitch::checkSwitch($this->user_id,$supplier_id,5);
  363. foreach ($list as &$v) {
  364. $v['label_name'] =$v['label'] ? explode(',',trim($v['label'],',')):null;
  365. $v['cover_arr'] =$v['cover'] ? explode('|',trim($v['cover'])):null;
  366. $v['read_num'] = numTransform($v['read_num']);
  367. $v['create_at'] = substr($v['create_at'],0,10);
  368. $recently_id = UserTrack::getRecentlyTrack($this->user_id,10,$v['id']);
  369. $v['is_recently'] = $recently_id ? 1:0;
  370. }
  371. $total_num = SupplierGoods::where($sel_where)->count();
  372. $this->success('ok',['list'=>$list,'supplier_info'=>$supplier_info,'total_num'=>numTransform($total_num),'total_count'=>$total_num,'page_num'=>$this->page_num]);
  373. }
  374. /**
  375. * @title 产品详情--【ui是供应商详情】
  376. * @desc 产品详情
  377. * @author qc
  378. * @method GET
  379. * @url /api/Supplier/getSupplierGoodsDetail
  380. * @header name:Authorization require:1 desc:Token
  381. * @param name:goods_id type:int default:-- desc:供应商产品id
  382. * @return name:name type:string default:-- desc:名称
  383. * @return name:cover type:string default:-- desc:图片【多张逗号隔开】
  384. * @return name:cover_arr type:array default:-- desc:图片数组
  385. * @return name:label_name type:array default:-- desc:标签
  386. * @return name:content type:string default:-- desc:详情
  387. * @return name:article_id type:int default:-- desc:关联图文id【单个id||系列id】
  388. * @return name:article_item type:int default:-- desc:关联图文详情id【item_list.id】
  389. * @return name:datum_id type:int default:-- desc:资料id【单个id||系列id】
  390. * @return name:datum_item type:int default:-- desc:资料详情id【url_arr.id】
  391. * @return name:video_id type:int default:-- desc:关联视频id【单个id||系列id】
  392. * @return name:video_item type:int default:-- desc:关联视频详情id【video_arr.id】
  393. * @return name:is_collect type:int default:-- desc:是否收藏
  394. * @return name:collect_num type:int default:-- desc:收藏量
  395. * @return name:comment_num type:int default:-- desc:评论量
  396. * @return name:praise_num type:int default:-- desc:点赞量
  397. * @return name:is_praise type:int default:-- desc:是否点赞
  398. * @return name:transmit_num type:int default:-- desc:转发量
  399. * @return name:release_time type:string default:-- desc:上架时间
  400. * @return name:switch_open type:int default:-- desc:通知开关【0关闭1开启】
  401. * @return name:article_jump type:int default:-- desc:关联图文是否能跳转【0不能跳转,1能跳转,验证是否vip】
  402. * @return name:datum_jump type:int default:-- desc:关联资料是否能跳转【0不能跳转,1能跳转,验证是否vip】
  403. * @return name:video_jump type:int default:-- desc:关联视频是否能跳转【0不能跳转,1能跳转,验证是否vip】
  404. * @return name:supplier_info type:array default:-- desc:供应商详情
  405. * @return name:supplier_info.title type:string default:-- desc:名称
  406. * @return name:supplier_info.cover type:string default:-- desc:公司logo
  407. * @return name:supplier_info.phone type:string default:-- desc:电话
  408. * @return name:supplier_info.email type:string default:-- desc:email
  409. * @return name:supplier_info.label_name type:array default:-- desc:标签
  410. * @return name:supplier_info.content type:string default:-- desc:供应商详情
  411. * @return name:supplier_info.create_at type:string default:-- desc:时间
  412. * @return name:supplier_info.build_time type:string default:-- desc:成立时间
  413. * @return name:supplier_info.work_place type:string default:-- desc:办公地点
  414. * @return name:supplier_info.business type:string default:-- desc:业务范围
  415. * @return name:supplier_info.follow_switch type:int default:-- desc:订阅开关状态【0关闭1开启】
  416. */
  417. public function getSupplierGoodsDetail()
  418. {
  419. $goods_id = input('get.goods_id');
  420. $detail = SupplierGoods::where('id',$goods_id)->find()->toArray();
  421. $detail['label_name'] =$detail['label'] ? explode(',',trim($detail['label'],',')):null;
  422. $detail['is_collect'] = UserCollect::checkCollectByType($this->user_id,9,$detail['id']);
  423. $detail['collect_num'] = UserCollect::getCollectNum(9,$detail['id']);
  424. $detail['is_praise'] = PlatformLike::checkTags($this->user_id,$detail['id'],7);
  425. $detail['praise_num'] = PlatformLike::getPraiseNum($detail['id'],7);
  426. $detail['read_num'] = numTransform($detail['read_num']);
  427. $detail['transmit_num'] = numTransform($detail['transmit_num']);
  428. $detail['comment_num'] = SupplierComment::getCommentNum($detail['id']);
  429. $detail['video_vip'] = numTransform($detail['transmit_num']);
  430. $detail['article_jump'] = ArticleItem::checkVip($detail['article_item'],$this->user_id);
  431. $detail['datum_jump'] = DatumUrl::checkVip($detail['datum_item'],$this->user_id);
  432. $detail['video_jump'] = VideoUrl::checkVip($detail['video_item'],$this->user_id);
  433. $detail['switch_open'] = PlatformSwitch::checkSwitch($this->user_id,$detail['id'],11);
  434. $supplier_info = \app\common\model\Supplier::where('id',$detail['supplier_id'])->find()->toArray();
  435. $supplier_info['label_name'] =$supplier_info['label'] ? explode(',',trim($supplier_info['label'],',')):null;
  436. $supplier_info['business_arr'] = $supplier_info['business'] ? explode(',',trim($supplier_info['business'],',')) : null;
  437. $supplier_info['cover'] = $supplier_info['logo'] ;
  438. $supplier_info['follow_switch'] = PlatformSwitch::checkSwitch($this->user_id,$detail['supplier_id'],5);
  439. UserTrack::crateTrack($this->user_id,10,$goods_id,0);
  440. SupplierGoods::where('id',$goods_id)->setInc('read_num');
  441. if($this->user_id){
  442. TopSearch::seIncHotNum($detail['id'],'supplier_goods');
  443. }
  444. $this->success('ok',['detail'=>$detail,'supplier_info'=>$supplier_info]);
  445. }
  446. /**
  447. * @title 一级评论
  448. * @desc 一级评论
  449. * @author qc
  450. * @method POST
  451. * @url /api/Supplier/firstComment
  452. * @header name:Authorization require:1 desc:Token
  453. * @param name:goods_id type:int require:1 default:-- desc:问题的id
  454. * @param name:content type:string default:-- desc:内容
  455. * @return name:name type:string default:-- desc:会员名称
  456. * @return name:headimg type:string default:-- desc:会员头像
  457. * @return name:content type:string default:-- desc:内容
  458. * @return name:create_at type:string default:-- desc:时间
  459. */
  460. public function firstComment()
  461. {
  462. $goods_id = input('post.goods_id');
  463. $content = input('post.content');
  464. if (!$content) $this->error('请输入评论内容');
  465. $goods_info = SupplierGoods::where('id',$goods_id)->find()->toArray();
  466. if(!$goods_info['comment_switch']) $this->error('评论功能已关闭');
  467. $send_user = $goods_info['user_id'];
  468. $res = SupplierComment::create([
  469. 'user_id'=>$this->user_id,
  470. 'content'=>$content,
  471. 'goods_id'=>$goods_id,
  472. 'is_read' => $send_user == $this->user_id ? 1 : 0,
  473. 'source_read' => $send_user == $this->user_id ? 1 : 0,
  474. ]);
  475. $detail =SupplierComment::where('c.id',$res->id)
  476. ->alias('c')->field('c.id,c.content,c.user_id,c.create_at,u.name,u.headimg')
  477. ->leftJoin('store_member u','u.id = c.user_id')
  478. ->find()->toArray();
  479. $user_info = $this->userInfo('name');
  480. if($send_user && $this->user_id != $send_user) UserMessage:: sendUserMessage($send_user,'supplier',4,0,$this->user_id,$goods_id,$content);
  481. $this->success('评论成功',['detail'=>$detail]);
  482. }
  483. /**
  484. * @title 二级评论
  485. * @desc 二级评论
  486. * @author qc
  487. * @method POST
  488. * @url /api/Supplier/secondComment
  489. * @header name:Authorization require:1 desc:Token
  490. * @param name:id type:int default:1 desc:评论id
  491. * @param name:content type:string default:-- desc:内容
  492. * @return name:name type:string default:-- desc:会员名称
  493. * @return name:headimg type:string default:-- desc:会员头像
  494. * @return name:content type:string default:-- desc:内容
  495. * @return name:create_at type:string default:-- desc:时间
  496. */
  497. public function secondComment()
  498. {
  499. $content = input('post.content');
  500. if (!$content) $this->error('请输入评论内容');
  501. $comment = SupplierComment::where('id',input('post.id'))->find()->toArray();
  502. if($comment['user_id'] != $this->user_id)UserMessage:: sendUserMessage($comment['user_id'],'supplier',3,0,$this->user_id,$comment['id'],$content);
  503. $goods_info = SupplierGoods::where('id',$comment['goods_id'])->find()->toArray();
  504. if(!$goods_info['comment_switch']) $this->error('评论功能已关闭');
  505. //if($goods_info['user_id'] && $goods_info['user_id'] != $this->user_id) UserMessage:: sendUserMessage($goods_info['user_id'],'supplier',4,0,$this->user_id,$comment['goods_id'],$content);
  506. unset($comment['id']);
  507. unset($comment['create_at']);
  508. unset($comment['to_deleted']);
  509. unset($comment['is_top']);
  510. unset($comment['is_deleted']);
  511. $comment['pid'] = input('post.id');
  512. $comment['user_id'] = $this->user_id;
  513. $comment['content'] = $content;
  514. $comment['lev']++;
  515. $comment['is_read']= $this->user_id == $goods_info['user_id'] ? 1 :0 ;
  516. $comment['source_read'] = $this->user_id == $goods_info['user_id'] ? 1 :0 ;
  517. if(!$comment['source_id']) $comment['source_id'] = input('post.id');
  518. $res = SupplierComment::create($comment);
  519. $detail = SupplierComment::where('c.id',$res->id)->alias('c')->field('c.id,c.content,c.create_at,u.name,u.headimg')
  520. ->leftJoin('store_member u','u.id = c.user_id')->find()->toArray();
  521. $this->success('评论成功',['detail'=>$detail]);
  522. }
  523. /**
  524. * @title 获取评论列表
  525. * @desc 获取评论列表
  526. * @author qc
  527. * @method GET
  528. * @url /api/Supplier/getCommentList
  529. * @header name:Authorization require:1 desc:Token)
  530. * @param name:goods_id type:int default:-- desc:产品id
  531. * @param name:sort_type type:int default:1 desc:排序规则1最新2热点
  532. * @param name:page type:int default:1 desc:页数
  533. * @param name:page_num type:int default:20 desc:每页数
  534. * @return name:name type:string default:-- desc:会员名称
  535. * @return name:headimg type:string default:-- desc:会员头像
  536. * @return name:content type:string default:-- desc:内容
  537. * @return name:is_top type:int default:-- desc:是否置顶(0否1是)
  538. * @return name:is_deleted type:int default:-- desc:是否删除(大于0未删除状态)
  539. * @return name:parent type:array default:-- desc:评论上一级(数据同上【一维数组】)
  540. * @return name:children type:array default:-- desc:二级评论(数据同上【二维数组】)
  541. * @return name:like_num type:int default:-- desc:点赞数量
  542. * @return name:is_like type:int default:-- desc:是否点赞(0否1是)
  543. * @return name:can_delete type:int default:-- desc:是否可以删除(0否1是)
  544. * @return name:total_num type:int default:-- desc:总评论数(仅一级)
  545. *
  546. */
  547. public function getCommentList()
  548. {
  549. $where = [];
  550. $where[] = ['c.goods_id','=',input('get.goods_id')];
  551. $where[] = ['c.is_deleted','=',0];
  552. $user_id = $this->user_id;
  553. $sort_type= input('sort_type',1);
  554. switch ($sort_type) {
  555. case 1:
  556. $order = ['c.is_top'=>'desc','c.id'=>'desc','c.like_times'=>'desc'];
  557. break;
  558. case 2:
  559. $order = ['c.is_top'=>'desc','c.like_times'=>'desc','c.id'=>'asc'];
  560. break;
  561. }
  562. $list = SupplierComment::where($where)
  563. ->alias('c')->field('c.*,u.name,u.headimg')
  564. ->leftJoin('store_member u','u.id = c.user_id')->order($order)
  565. ->limit($this->off_set,$this->page_num)
  566. ->select()->toArray();
  567. array_walk($list,function (&$val,$k)use($user_id){
  568. /* $children = SupplierComment::where(['c.pid'=>$val['id']])
  569. ->alias('c')->field('c.*,u.name,u.headimg')
  570. ->leftJoin('store_member u','u.id = c.user_id')
  571. ->order('c.is_top,c.id asc')
  572. ->select()->toArray();*/
  573. $val['like_num'] = PlatformLike::where('like_id',$val['id'])->where('type',11)->count();
  574. $val['like_num'] = numTransform($val['like_num']);
  575. // $val['children'] = $children;
  576. $val['is_like'] = PlatformLike::where(['like_id'=>$val['id'],'user_id'=>$user_id,'type'=>11])->count();
  577. $parent = SupplierComment::where(['c.id'=>$val['pid']])->alias('c')->field('c.*,u.name,u.headimg')->leftJoin('store_member u','u.id = c.user_id')->find();
  578. $val['parent'] = $parent ? $parent->toArray() : null;
  579. $val['parent_comment'] = $val['parent'] ;
  580. $val['can_delete'] = $val['user_id'] == $this->user_id ? 1 :0;
  581. });
  582. $total_num = SupplierComment::where($where)->alias('c')->count();
  583. $this->success('ok',['list'=>$list,'total_num'=>numTransform($total_num),'total_count'=>$total_num,'page_num'=>$this->page_num]);
  584. }
  585. /**
  586. * @title 供应商搜索列表
  587. * @desc 供应商搜索列表
  588. * @author qc
  589. * @method GET
  590. * @url /api/Supplier/searchGoods
  591. * @header name:Authorization require:1 desc:Token
  592. * @param name:search_name type:int default:-- desc:搜索名称
  593. * @param name:page type:int default:0 desc:页数
  594. * @param name:page_num type:int default:20 desc:每页数
  595. * @param name:sort_type type:int default:1 desc:1默认2时间升序3时间降序
  596. *
  597. * @return name:name type:string default:-- desc:名称
  598. * @return name:supplier_name type:string default:-- desc:供应商名称
  599. * @return name:cover type:string default:-- desc:图片【多张逗号隔开】
  600. * @return name:cover_arr type:array default:-- desc:图片数组
  601. * @return name:label_name type:array default:-- desc:标签
  602. * @return name:content type:string default:-- desc:详情
  603. * @return name:read_num type:int default:-- desc:浏览量
  604. * @return name:article_id type:int default:-- desc:关联图文id【单个id||系列id】
  605. * @return name:article_item type:int default:-- desc:关联图文详情id【item_list.id】
  606. * @return name:datum_id type:int default:-- desc:资料id【单个id||系列id】
  607. * @return name:datum_item type:int default:-- desc:资料详情id【url_arr.id】
  608. * @return name:video_id type:int default:-- desc:关联视频id【单个id||系列id】
  609. * @return name:video_item type:int default:-- desc:关联视频详情id【video_arr.id】
  610. * @return name:supplier_name type:string default:-- desc:供应商名称
  611. * @return name:supplier_logo type:string default:-- desc供应商logo
  612. * @return name:total_num type:array default:-- desc:总数
  613. *
  614. */
  615. public function searchGoods()
  616. {
  617. $search_name = input('get.search_name');
  618. $sort_type = input('get.sort_type',1);
  619. switch ($sort_type) {
  620. case 1:
  621. $order = ['g.sort'=>'desc','read_num'=>'desc','g.id'=>'asc'];
  622. break;
  623. case 2:
  624. $order = ['g.id'=>'asc','g.sort'=>'desc'];
  625. break;
  626. case 3:
  627. $order = ['g.id'=>'desc','g.sort'=>'desc'];
  628. break;
  629. }
  630. $sel_where = [];
  631. $sel_where[] = ['g.is_deleted','=',0];
  632. $sel_where[] = ['s.is_deleted','=',0];
  633. $sel_where[] = ['g.status','=',1];
  634. $sel_where[] = ['s.status','=',1];
  635. if($search_name && $this->user_id) UserSearch::saveSearchTitle($this->user_id,$search_name,10);
  636. $list = SupplierGoods::where($sel_where)
  637. ->field('g.id,g.supplier_id,g.name,g.label,g.read_num,g.cover,s.title supplier_name,s.logo supplier_logo')
  638. ->when($search_name,function ($query)use($search_name){
  639. if($search_name) $query->where('g.name|g.label','like','%'.$search_name.'%');
  640. })->alias('g')
  641. ->leftJoin('Supplier s','g.supplier_id = s.id')
  642. ->order($order)->limit($this->off_set,$this->page_num)->select()->toArray();
  643. foreach ($list as &$v) {
  644. $v['label_name'] =$v['label'] ? explode(',',trim($v['label'],',')):null;
  645. $v['cover_arr'] =$v['cover'] ? explode('|',trim($v['cover'])):null;
  646. $v['read_num'] = numTransform($v['read_num']);
  647. }
  648. $total_num = SupplierGoods::where($sel_where)->alias('g')->leftJoin('Supplier s','g.supplier_id = s.id')->when($search_name,function ($query)use($search_name){
  649. if($search_name) $query->where('g.name|g.label','like','%'.$search_name.'%');
  650. })->count();
  651. $this->success('ok',['list'=>$list,'total_num'=>numTransform($total_num),'total_count'=>$total_num,'page_num'=>$this->page_num]);
  652. }
  653. /**
  654. * @title 点赞||取消点赞
  655. * @desc 点赞||取消点赞
  656. * @author qc
  657. * @method POST
  658. * @url /api/Supplier/supplierTags
  659. * @header name:Authorization require:1 desc:Token
  660. * @param name:id type:int default:1 desc:记录id【产品id或评论id】
  661. * @param name:type type:int default:7 desc:7产品,11评论
  662. * @return name:tags type:int default:1 desc:0取消成功,1点赞成功
  663. */
  664. public function supplierTags()
  665. {
  666. $type = input('post.type',7);
  667. $id = input('post.id');
  668. $ret_val = PlatformLike::userTags($this->user_id,$id,$type);
  669. $this->success($ret_val == 1 ?'点赞成功':'取消成功',['tags'=>$ret_val]);
  670. }
  671. /**
  672. * @title 供应商产品收藏||取消收藏
  673. * @desc 用户收藏
  674. * @author qc
  675. * @method POST
  676. * @url /api/Supplier/supplierGoodsCollect
  677. * @header name:Authorization require:1 desc:Token
  678. * @param name:id type:int require:1 default:-- desc:供应商产品记录id
  679. * @param return:status type:int default:0 desc:收藏状态(0取消收藏【未收藏】,1收藏)
  680. */
  681. public function supplierGoodsCollect(){
  682. $coll_status = UserCollect::plateCollect($this->user_id,9,input('post.id',0));
  683. $coll_status ? $this->success('收藏成功',['status'=>1]) : $this->success('取消收藏成功',['status'=>0]);
  684. }
  685. /**
  686. * @title 转发(转发数量统计【供应商】)
  687. * @desc 转发成功后调用
  688. * @author qc
  689. * @method POST
  690. * @url /api/Supplier/supplierTransmit
  691. * @header name:Authorization require:1 desc:Token
  692. * @param name:id type:int default:-- desc:供应商记录id
  693. */
  694. public function supplierTransmit()
  695. {
  696. $id = input('post.id',0);
  697. \app\common\model\Supplier::where('id',$id)->setInc('transmit_num');
  698. $this->success('ok');
  699. }
  700. /**
  701. * @title 转发(转发数量统计【供应商产品】)
  702. * @desc 转发成功后调用
  703. * @author qc
  704. * @method POST
  705. * @url /api/Supplier/supplierGoodsTransmit
  706. * @header name:Authorization require:1 desc:Token
  707. * @param name:id type:int default:-- desc:供应商产品记录id
  708. */
  709. public function supplierGoodsTransmit()
  710. {
  711. $id = input('post.id',0);
  712. SupplierGoods::where('id',$id)->setInc('transmit_num');
  713. $this->success('ok');
  714. }
  715. /**
  716. * @title 我的浏览历史【供应商产品】
  717. * @desc 我的浏览历史
  718. * @author qc
  719. * @method GET
  720. * @url /api/Supplier/getSupplierGoodsTrack
  721. * @header name:Authorization require:1 desc:Token
  722. * @param name:name type:string default:-- desc:产品名称
  723. * @param name:page type:int default:-- desc:页数
  724. * @param name:page_num type:int default:-- desc:每页数
  725. * @return name:id type:string default:-- desc:浏览记录id
  726. * @return name:goods_id type:string default:-- desc:产品id
  727. * @return name:name type:string default:-- desc:产品名称
  728. * @return name:cover type:string default:-- desc:封面(多张|隔开)
  729. * @return name:cover_arr type:array default:-- desc:封面
  730. * @return name:label_name type:array default:-- desc:标签
  731. * @return name:supplier_logo type:string default:-- desc:供应商名称
  732. * @return name:supplier_name type:string default:-- desc:供应商名称
  733. * @return name:time type:string default:-- desc:时间
  734. * @return name:read_num type:string default:-- desc:浏览量
  735. */
  736. public function getSupplierGoodsTrack()
  737. {
  738. $sel_where = [];
  739. $sel_where[] = ['t.user_id','=',$this->user_id];
  740. $sel_where[] = ['t.type','=',10];
  741. $name = input('get.name');
  742. if($name) $sel_where[] = ['i.name|i.label','like','%'.$name.'%'];
  743. $list = UserTrack::where($sel_where)
  744. ->alias('t')
  745. ->field('t.id,t.update_int,t.first_id goods_id,i.read_num,i.name,i.cover,i.label,supplier_id,s.logo supplier_logo,s.title supplier_name')
  746. ->leftJoin('SupplierGoods i','t.first_id = i.id')
  747. ->leftJoin('Supplier s','s.id = i.supplier_id')
  748. ->order('update_int desc')
  749. ->limit($this->off_set,$this->page_num)
  750. ->select()->toArray();
  751. foreach ($list as &$v) {
  752. $v['time'] = date("Y-m-d",$v['update_int']);
  753. $v['cover_arr'] = $v['cover']? explode('|',$v['cover']) : null;
  754. $v['label_name'] = $v['label']? explode(',',trim($v['label'],',')) : null;
  755. $v['read_num'] = numTransform($v['read_num']);
  756. $v['is_normal'] = CheckPower::checkModulesPower($v['goods_id'],0,$this->request->controller());
  757. }
  758. $total_num =UserTrack::where($sel_where)->alias('t')->leftJoin('SupplierGoods i','t.first_id = i.id')->count();
  759. $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
  760. }
  761. /**
  762. * @title 我的点赞--产品
  763. * @desc 供应商产品点赞列表
  764. * @author qc
  765. * @method GET
  766. * @url /api/Supplier/getTagsSupplierGoods
  767. * @header name:Authorization require:1 desc:Token
  768. * @param name:name type:string default:-- desc:产品名称
  769. * @param name:page type:int default:-- desc:页数
  770. * @param name:page_num type:int default:-- desc:每页数
  771. * @return name:id type:string default:-- desc:浏览记录id
  772. * @return name:goods_id type:string default:-- desc:产品id
  773. * @return name:name type:string default:-- desc:名称
  774. * @return name:cover type:string default:-- desc:封面(多张|隔开)
  775. * @return name:cover_arr type:array default:-- desc:封面
  776. * @return name:label_name type:array default:-- desc:标签
  777. * @return name:supplier_name type:string default:-- desc:供应商名称
  778. * @return name:supplier_logo type:string default:-- desc:供应商logo
  779. * @return name:create_at type:string default:-- desc:时间
  780. * @return name:transmit_num type:string default:-- desc:转发量
  781. * @return name:comment_num type:string default:-- desc:评论量
  782. * @return name:praise_num type:int default:-- desc:点赞量
  783. * @return name:read_num type:int default:-- desc:阅读量
  784. * @return name:collect_num type:int default:-- desc:收藏量
  785. * @return name:is_collect type:int default:-- desc:是否收藏
  786. * @return name:switch_open type:int default:-- desc:通知开关【0关闭1开启】
  787. */
  788. public function getTagsSupplierGoods()
  789. {
  790. $sel_where = [];
  791. $name = input('get.name');
  792. if($name) $sel_where[] = ['i.name|i.label','like','%'.$name.'%'];
  793. $sel_where[] = ['t.user_id','=',$this->user_id];
  794. $sel_where[] = ['t.type','=',7];
  795. $list = PlatformLike::where($sel_where)->alias('t')
  796. ->field('t.id,t.create_at,t.like_id goods_id,i.transmit_num,i.name,i.cover,supplier_id,s.title supplier_name,s.logo supplier_logo,i.read_num')
  797. ->leftJoin('SupplierGoods i','t.like_id = i.id')
  798. ->leftJoin('Supplier s','s.id = i.supplier_id')
  799. ->order('id desc')
  800. ->limit($this->off_set,$this->page_num)
  801. ->select()->toArray();
  802. foreach ($list as &$v) {
  803. $v['cover_arr'] = explode('|',$v['cover']);
  804. $v['is_normal'] = CheckPower::checkModulesPower($v['goods_id'],0,$this->request->controller());
  805. $v['transmit_num'] = numTransform($v['transmit_num']);
  806. $v['read_num'] = numTransform($v['read_num']);
  807. $v['comment_num'] = SupplierComment::getCommentNum($v['goods_id']);
  808. $v['praise_num'] = PlatformLike::getPraiseNum($v['goods_id'],7);
  809. $v['collect_num'] =UserCollect::getCollectNum(9,$v['goods_id']);
  810. $v['is_collect'] = UserCollect::checkCollectByType($this->user_id,9,$v['goods_id']);
  811. $v['switch_open'] = PlatformSwitch::checkSwitch($this->user_id,$v['goods_id'],11);
  812. }
  813. $total_num = PlatformLike::where($sel_where)->alias('t')->leftJoin('SupplierGoods i','t.like_id = i.id')->count();
  814. $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
  815. }
  816. /**
  817. * @title 我的点赞--评论
  818. * @desc 评论点赞列表
  819. * @author qc
  820. * @method GET
  821. * @url /api/Supplier/getTagsComment
  822. * @header name:Authorization require:1 desc:Token
  823. * @param name:page type:int default:0 desc:页数
  824. * @param name:page_num type:int default:20 desc:每页数
  825. * @return name:create_at type:string default:-- desc:时间
  826. * @return name:user_name type:string default:-- desc:会员名称
  827. * @return name:headimg type:string default:-- desc:会员头像
  828. * @return name:content type:string default:-- desc:评论内容
  829. * @return name:cover type:string default:-- desc:封面
  830. * @return name:ali_vid type:string default:-- desc:云点播id
  831. * @return name:read_num type:string default:-- desc:浏览量
  832. * @return name:supplier_name type:string default:-- desc:供应商名称
  833. * @return name:supplier_logo type:string default:-- desc:供应商logo
  834. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  835. */
  836. public function getTagsComment()
  837. {
  838. $list = PlatformLike::field('l.id,c.goods_id,c.content,c.id as like_id,g.read_num,g.name,g.cover,u.name user_name,u.headimg,s.title supplier_name,s.logo supplier_logo')
  839. ->alias('l')
  840. ->where(['l.user_id'=>$this->user_id,'l.type'=>11])
  841. ->where('c.user_id','<>',$this->user_id)
  842. ->leftJoin('SupplierComment c','l.like_id = c.id')
  843. ->leftJoin('SupplierGoods g','g.id = c.goods_id')
  844. ->leftJoin('Supplier s','s.id = g.supplier_id')
  845. ->leftJoin('store_member u','u.id = c.user_id')
  846. ->order('l.id desc')
  847. ->limit($this->off_set,$this->page_num)
  848. ->select()->toArray();
  849. array_walk($list,function (&$v){
  850. $v['read_num'] = numTransform($v['read_num']);
  851. $v['cover_arr'] = explode('|',$v['cover']);
  852. $v['is_normal'] = CheckPower::checkModulesPower($v['goods_id'],0,$this->request->controller());
  853. });
  854. $total_num = PlatformLike::alias('l')->where(['l.user_id'=>$this->user_id,'l.type'=>11]) ->where('c.user_id','<>',$this->user_id)
  855. ->leftJoin('SupplierComment c','l.like_id = c.id')->count();
  856. $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
  857. }
  858. /**
  859. * @title 我的收藏【供应商产品收藏列表】
  860. * @desc 供应商产品收藏列表
  861. * @author qc
  862. * @method GET
  863. * @url /api/Supplier/getCollectSupplierGoods
  864. * @header name:Authorization require:1 desc:Token
  865. * @param name:name type:string default:-- desc:产品名称
  866. * @param name:page type:int default:-- desc:页数
  867. * @param name:page_num type:int default:-- desc:每页数
  868. *
  869. * @return name:goods_id type:string default:-- desc:产品id
  870. * @return name:name type:string default:-- desc:名称
  871. * @return name:cover type:string default:-- desc:封面(多张|隔开)
  872. * @return name:cover_arr type:array default:-- desc:封面
  873. * @return name:label_name type:array default:-- desc:标签
  874. * @return name:supplier_name type:string default:-- desc:供应商名称
  875. * @return name:supplier_logo type:string default:-- desc:供应商logo
  876. * @return name:create_at type:string default:-- desc:时间
  877. * @return name:transmit_num type:string default:-- desc:转发量
  878. * @return name:comment_num type:string default:-- desc:评论量
  879. * @return name:praise_num type:int default:-- desc:点赞量
  880. * @return name:is_praise type:int default:-- desc:是否点赞
  881. * @return name:collect_num type:int default:-- desc:收藏量
  882. * @return name:switch_open type:int default:-- desc:通知开关【0关闭1开启】
  883. */
  884. public function getCollectSupplierGoods()
  885. {
  886. $sel_where = [];
  887. $name = input('get.name');
  888. if($name) $sel_where[] = ['i.name','like','%'.$name.'%'];
  889. $sel_where[] = ['t.user_id','=',$this->user_id];
  890. $sel_where[] = ['t.coll_type','=',9];
  891. $list = UserCollect::where($sel_where)->alias('t')
  892. ->field('t.id,t.create_at,t.coll_id goods_id,i.read_num,i.transmit_num,i.name,i.cover,i.label,i.supplier_id,s.logo supplier_logo ,s.title supplier_name')
  893. ->leftJoin('SupplierGoods i','t.coll_id = i.id')
  894. ->leftJoin('Supplier s','s.id = i.supplier_id')
  895. ->order('id desc')
  896. ->limit($this->off_set,$this->page_num)
  897. ->select()->toArray();
  898. foreach ($list as &$v) {
  899. $v['cover_arr'] = explode('|',$v['cover']);
  900. $v['label_name'] = explode(',',$v['label']);
  901. $v['read_num'] = numTransform($v['read_num']);
  902. $v['transmit_num'] = numTransform($v['transmit_num']);
  903. $v['comment_num'] = SupplierComment::getCommentNum($v['goods_id']);
  904. $v['is_praise'] = PlatformLike::checkTags($this->user_id,$v['goods_id'],7);
  905. $v['is_normal'] = CheckPower::checkModulesPower($v['goods_id'],0,$this->request->controller());
  906. $v['switch_open'] = PlatformSwitch::checkSwitch($this->user_id,$v['goods_id'],11);
  907. $v['collect_num'] = UserCollect::getCollectNum(9,$v['goods_id']);
  908. $v['praise_num'] = PlatformLike::getPraiseNum($v['goods_id'],7);
  909. }
  910. $total_num= UserCollect::where($sel_where)->alias('t') ->leftJoin('SupplierGoods i','t.coll_id = i.id')->count();
  911. $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
  912. }
  913. /**
  914. * @title 我的订阅--供应商
  915. * @desc 供应商
  916. * @author qc
  917. * @method GET
  918. * @url /api/Supplier/getFollowUpList
  919. * @header name:Authorization require:1 desc:Token
  920. * @param name:title type:string default:-- desc:搜索关键字
  921. * @param name:page type:int default:0 desc:页数
  922. * @param name:page_num type:int default:20 desc:每页数
  923. * @return name:create_at type:string default:-- desc:时间
  924. * @return name:title type:string default:-- desc:供应商标题
  925. * @return name:goods_num type:int default:-- desc:商品数量
  926. * @return name:supplier_id type:int default:-- desc:供应商id
  927. * @return name:supplier_name type:string default:-- desc:供应商名称
  928. * @return name:supplier_logo type:string default:-- desc:供应商logo
  929. * @return name:recently_title type:string default:-- desc:上次观看商品
  930. */
  931. public function getFollowUpList()
  932. {
  933. $sel_where = [];
  934. $sel_where[] = ['p.user_id','=',$this->user_id];
  935. $sel_where[] = ['p.type','=',5];
  936. $sel_where[] = ['p.switch_value','=',1];
  937. $field = 'p.id,p.switch_id as supplier_id,p.create_at,a.title,a.logo supplier_logo,a.title supplier_name';
  938. $list = PlatformSwitch::field($field)->alias('p')
  939. ->leftJoin('Supplier a','p.switch_id = a.id')
  940. ->where($sel_where)->limit($this->off_set,$this->page_num)->order('p.id desc')
  941. ->select()->toArray();
  942. array_walk($list,function (&$v){
  943. $v['goods_num'] = SupplierGoods::getGoodsNum($v['supplier_id']);
  944. $v['recently_title'] = UserTrack::getRecentlyGoodsName($this->user_id,$v['supplier_id']);
  945. });
  946. $total_num= PlatformSwitch::where($sel_where)->alias('p')->leftJoin('Supplier a','p.switch_id = a.id')->count();
  947. $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
  948. }
  949. /**
  950. * @title 我的订阅消息
  951. * @desc 我的订阅消息
  952. * @author qc
  953. * @method GET
  954. * @url /api/Supplier/getFollowUpMessage
  955. * @header name:Authorization require:1 desc:Token
  956. * @param name:title type:int default:-- desc:搜索内容
  957. * @param name:page type:int default:-- desc:页数
  958. * @param name:page_num type:int default:-- desc:每页数
  959. * @return name:id type:int default:-- desc:记录id
  960. * @return name:title type:string default:-- desc:标题
  961. * @return name:content type:string default:-- desc:内容
  962. * @return name:create_at type:string default:-- desc:时间
  963. * @return name:is_read type:int default:-- desc:是否已读【0否1是】
  964. * @return name:supplier_id type:int default:-- desc:供应商id
  965. * @return name:goods_id type:int default:-- desc:产品id
  966. */
  967. public function getFollowUpMessage()
  968. {
  969. $title = input('title');
  970. $list = UserMessage::where(['m.user_id'=>$this->user_id,'m.is_deleted'=>0,'m.module'=>'supplier','m.type_id'=>5])
  971. ->alias('m')
  972. ->when($title,function ($query)use ($title){
  973. if($title) $query->where('m.content','like','%'.$title.'%');})
  974. ->field('m.id,v.create_at,m.title,m.is_read,m.children_id goods_id,m.content,m.relation_id supplier_id,m.module,v.title supplier_name')
  975. ->leftJoin('Supplier v','v.id= m.relation_id')
  976. ->limit($this->off_set,$this->page_num)
  977. ->order(['m.id'=>'desc'])
  978. ->select()->toArray();
  979. $total_num = UserMessage::where(['m.user_id'=>$this->user_id,'m.is_deleted'=>0,'m.module'=>'supplier','m.type_id'=>5])->alias('m')->leftJoin('Supplier v','v.id= m.relation_id')->count();
  980. $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
  981. }
  982. /**
  983. * @title 点赞我的--产品
  984. * @desc 点赞我的--产品
  985. * @author qc
  986. * @method GET
  987. * @url /api/Supplier/praiseGoodsList
  988. * @header name:Authorization require:1 desc:Token
  989. * @param name:page type:int default:-- desc:页数
  990. * @param name:page_num type:int default:-- desc:每页数
  991. * @return name:id type:int default:-- desc:记录id
  992. * @return name:name type:string default:-- desc:产品
  993. * @return name:create_at type:string default:-- desc:时间
  994. * @return name:user_name type:string default:-- desc:会员名称
  995. * @return name:headimg type:string default:-- desc:会员头像
  996. * @return name:supplier_logo type:string default:-- desc:供应商logo
  997. * @return name:supplier_name type:string default:-- desc:供应商名称
  998. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  999. */
  1000. public function praiseGoodsList()
  1001. {
  1002. $sel_where = [];
  1003. $sel_where[] = ['p.type', '=', 7];
  1004. $sel_where[] = ['g.user_id', '=', $this->user_id];
  1005. $sel_where[] = ['p.to_deleted', '=', 0];
  1006. $list = PlatformLike::where($sel_where)
  1007. ->field('p.*,g.id goods_id,g.name,g.read_num,u.name user_name,u.headimg,s.logo supplier_logo ,s.title supplier_name,g.cover')->alias('p')
  1008. ->leftJoin('SupplierGoods g', 'g.id = p.like_id')
  1009. ->leftJoin('Supplier s', 's.id = g.supplier_id')
  1010. ->leftJoin('StoreMember u', 'u.id = p.user_id')
  1011. ->order('p.id desc')
  1012. ->limit($this->off_set,$this->page_num)
  1013. ->select()->toArray();
  1014. array_walk($list,function (&$v){
  1015. $v['read_num'] = numTransform($v['read_num']);
  1016. $v['cover_arr'] = $v['cover']? explode('|',trim($v['cover'],'|')):null;
  1017. $v['is_normal'] = CheckPower::checkModulesPower($v['goods_id'],0,$this->request->controller());
  1018. });
  1019. $total_num = PlatformLike::where($sel_where)->alias('p')
  1020. ->leftJoin('SupplierGoods g', 'g.id = p.like_id')
  1021. ->leftJoin('Supplier s', 's.id = g.supplier_id')
  1022. ->leftJoin('StoreMember u', 'u.id = p.user_id')
  1023. ->count();
  1024. $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
  1025. }
  1026. /**
  1027. * @title 点赞我的--评论
  1028. * @desc 点赞我的
  1029. * @author qc
  1030. * @method GET
  1031. * @url /api/Supplier/praiseCommentList
  1032. * @header name:Authorization require:1 desc:Token
  1033. * @param name:page type:int default:-- desc:页数
  1034. * @param name:page_num type:int default:-- desc:每页数
  1035. * @return name:id type:int default:-- desc:记录id
  1036. * @return name:name type:string default:-- desc:产品
  1037. * @return name:create_at type:string default:-- desc:时间
  1038. * @return name:user_name type:string default:-- desc:会员名称
  1039. * @return name:headimg type:string default:-- desc:会员头像
  1040. * @return name:content type:string default:-- desc:评论内容
  1041. * @return name:supplier_logo type:string default:-- desc:供应商logo
  1042. * @return name:supplier_name type:string default:-- desc:供应商名称
  1043. * @return name:cover_arr type:array default:-- desc:图片
  1044. * @return name:goods_id type:int default:-- desc:产品id
  1045. * @return name:self_name type:string default:-- desc:自己昵称
  1046. * @return name:is_deleted type:int default:-- desc:评论是否删除(0未删除,1,2已删除)
  1047. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  1048. */
  1049. public function praiseCommentList()
  1050. {
  1051. $sel_where = [];
  1052. $sel_where[] = ['p.type', '=', 11];
  1053. $sel_where[] = ['c.user_id', '=', $this->user_id];
  1054. $sel_where[] = ['p.to_deleted', '=', 0];
  1055. $list = PlatformLike::where($sel_where) ->alias('p')
  1056. ->field('p.*,c.content,c.is_deleted,g.read_num,c.goods_id,u.name user_name,u.headimg,s.logo supplier_logo ,s.title supplier_name,g.cover,g.name')
  1057. ->leftJoin('SupplierComment c', 'c.id = p.like_id')
  1058. ->leftJoin('SupplierGoods g', 'g.id = c.goods_id')
  1059. ->leftJoin('Supplier s', 's.id = g.supplier_id')
  1060. ->leftJoin('StoreMember u', 'u.id = p.user_id')
  1061. ->order('p.id desc')
  1062. ->limit($this->off_set,$this->page_num)
  1063. ->select()->toArray();
  1064. array_walk($list,function (&$v){
  1065. $v['self_name'] = $this->user_info['name'];
  1066. $v['read_num'] = numTransform($v['read_num']);
  1067. $v['cover_arr'] = $v['cover']? explode('|',trim($v['cover'],'|')):null;
  1068. $v['is_normal'] = CheckPower::checkModulesPower($v['goods_id'],0,$this->request->controller());
  1069. });
  1070. $total_num = PlatformLike::where($sel_where) ->alias('p')->leftJoin('SupplierComment c', 'c.id = p.like_id')
  1071. ->leftJoin('SupplierGoods g', 'g.id = c.goods_id')
  1072. ->leftJoin('Supplier s', 's.id = g.supplier_id')
  1073. ->leftJoin('StoreMember u', 'u.id = p.user_id')->count();
  1074. $this->success('ok', ['list' => $list, 'total_count' => $total_num, 'page_num' => $this->page_num]);
  1075. }
  1076. /**
  1077. * @title 我的发布
  1078. * @desc 我的发布
  1079. * @author qc
  1080. * @method GET
  1081. * @url /api/Supplier/getMyGoodsList
  1082. * @header name:Authorization require:1 desc:Token
  1083. * @param name:page type:int default:-- desc:页数
  1084. * @param name:page_num type:int default:-- desc:每页数
  1085. * @param name:title type:string default:-- desc:关键词
  1086. * @return name:id type:int default:-- desc:产品id
  1087. * @return name:name type:string default:-- desc:产品
  1088. * @return name:create_at type:string default:-- desc:时间
  1089. * @return name:supplier_logo type:string default:-- desc:供应商logo
  1090. * @return name:supplier_name type:string default:-- desc:供应商名称
  1091. * @return name:cover_arr type:array default:-- desc:图片
  1092. */
  1093. public function getMyGoodsList()
  1094. {
  1095. $where = [];
  1096. $where[] = ['user_id','=',$this->user_id];
  1097. $where[] = ['is_deleted','=',0];
  1098. $where[] = ['status','=',1];
  1099. $title = input('get.title');
  1100. if ($title) $where[] = ['name', 'like', '%' . $title . '%'];
  1101. $list = SupplierGoods::where($where)
  1102. ->field('id,name,create_at,label,cover,read_num')
  1103. ->order('id desc')
  1104. ->limit($this->off_set,$this->page_num)
  1105. ->select()->toArray();
  1106. array_walk($list,function (&$v){
  1107. $v['label_name'] =$v['label'] ? explode(',',trim($v['label'],',')):null;
  1108. $v['cover_arr'] = $v['cover']? explode('|',trim($v['cover'],'|')):null;
  1109. });
  1110. $total_num = SupplierGoods::where($where)->count();
  1111. $this->success('ok', ['list' => $list, 'total_count' => $total_num, 'page_num' => $this->page_num]);
  1112. }
  1113. /**
  1114. * @title 评论我的
  1115. * @desc 评论我的
  1116. * @author qc
  1117. * @method GET
  1118. * @url /api/Supplier/commentOnMyGoods
  1119. * @header name:Authorization require:1 desc:Token
  1120. * @param name:title type:string default:-- desc:关键字
  1121. * @param name:page type:int default:-- desc:页数
  1122. * @param name:page_num type:int default:-- desc:每页数量
  1123. * @return name:create_at type:string default:-- desc:时间
  1124. * @return name:content type:string default:0 desc:评论内容
  1125. * @return name:user_name type:string default:-- desc:评论用户
  1126. * @return name:headimg type:string default:-- desc:评论用户头像
  1127. * @return name:is_deleted type:int default:-- desc:是否删除(0否1是)
  1128. * @return name:is_read type:int default:-- desc:是否已读(0未读1已读)
  1129. * @return name:is_top type:int default:-- desc:是否置顶(0否1是)
  1130. * @return name:cover_arr type:array default:-- desc:图片
  1131. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  1132. */
  1133. public function commentOnMyGoods()
  1134. {
  1135. $where = [];
  1136. $where[] = ['g.user_id', '=', $this->user_id];
  1137. $where[] = ['c.is_deleted', '=', 0];
  1138. $where[] = ['c.user_id', '<>', $this->user_id];
  1139. $where[] = ['c.to_deleted', '=', 0];
  1140. $where[] = ['c.pid','=',0];
  1141. if ($title = input('title')) $where[] = ['c.content', 'like', '%' . $title . '%'];
  1142. $list = SupplierComment::field('c.*,m.name user_name,m.headimg,g.name,s.logo supplier_logo ,s.title supplier_name,g.cover,g.read_num')
  1143. ->alias('c')->where($where)
  1144. ->leftJoin('store_member m', 'm.id = c.user_id')
  1145. ->leftJoin('SupplierGoods g', 'g.id = c.goods_id')
  1146. ->leftJoin('Supplier s', 's.id = g.supplier_id')
  1147. ->order('c.is_top desc,c.id desc')
  1148. ->limit($this->off_set, $this->page_num)
  1149. ->select()->toArray();
  1150. array_walk($list, function (&$v) {
  1151. // $v['is_read'] = $v['source_read'];
  1152. $v['is_normal'] = CheckPower::checkModulesPower($v['goods_id'], 0, $this->request->controller());
  1153. $v['cover_arr'] = $v['cover']? explode('|',trim($v['cover'],'|')):null;
  1154. $v['read_num'] = numTransform($v['read_num']);
  1155. });
  1156. $total_num = SupplierComment::where($where)->alias('c')
  1157. ->leftJoin('store_member m', 'm.id = c.user_id')
  1158. ->leftJoin('SupplierGoods g', 'g.id = c.goods_id')
  1159. ->leftJoin('Supplier s', 's.id = g.supplier_id')->count();
  1160. $this->success('ok', ['list' => $list, 'total_count' => $total_num, 'page_num' => $this->page_num]);
  1161. }
  1162. /**
  1163. * @title 回复我的
  1164. * @desc 回复我的
  1165. * @author qc
  1166. * @method GET
  1167. * @url /api/Supplier/getReplayComment
  1168. * @header name:Authorization require:1 desc:Token
  1169. * @param name:title type:string default:-- desc:标题
  1170. * @param name:page type:int default:0 desc:页数
  1171. * @param name:page_num type:int default:20 desc:每页数
  1172. * @return name:id type:int default:-- desc:记录id
  1173. * @return name:title type:string default:-- desc:问题标题
  1174. * @return name:create_at type:string default:-- desc:时间
  1175. * @return name:is_deleted type:int default:-- desc:回复内容是被删除【0否】
  1176. * @return name:user_name type:string default:-- desc:用户名【其他会员】
  1177. * @return name:headimg type:string default:-- desc:用户头像【其他会员】
  1178. * @return name:content type:string default:-- desc:回复内容
  1179. * @return name:is_read type:int default:-- desc:是否已读(0未读1已读)
  1180. * @return name:is_top type:int default:-- desc:是否置顶(0否1是)
  1181. * @return name:self_name type:string default:-- desc:自己昵称
  1182. * @return name:parent_comment type:array default:-- desc:你的评论内容【阴影部分】
  1183. * @return name:parent_comment.content type:string default:-- desc:内容
  1184. * @return name:parent_comment.is_normal type:int default:-- desc:能否跳转(0已删除或是已禁用1可以正常跳转详情)
  1185. * @return name:parent_comment.is_deleted type:int default:-- desc:被评论的内容是否删除
  1186. * @return name:parent_comment.read_num type:string default:-- desc:阅读量
  1187. * @return name:parent_comment.goods_name type:string default:-- desc:产品名称
  1188. * @return name:parent_comment.name type:string default:-- desc:你的会员名称
  1189. * @return name:parent_comment.headimg type:string default:-- desc:你的头像
  1190. * @return name:parent_comment.show_title type:string default:-- desc:展示的问题标题或答案内容
  1191. * @return name:parent_comment.reply_id type:int default:-- desc:答案id【值为0是问题类型,大于0是答案类型】
  1192. *
  1193. */
  1194. public function getReplayComment()
  1195. {
  1196. $all_comment = SupplierComment::where(['user_id'=> $this->user_id, 'is_deleted' => 0])->column('id');
  1197. if (empty($all_comment)) $this->success('ok', ['list' => null]);
  1198. $sel_where = [];
  1199. $title = input('get.title');
  1200. if ($title) $sel_where[] = ['t.content', 'like', '%' . $title . '%'];
  1201. $sel_where[] = ['t.to_deleted', '=', 0];
  1202. // $sel_where[] = ['t.user_id','<>',$this->user_id];
  1203. $sel_where[] = ['t.pid', 'in', implode(',', $all_comment)];
  1204. $list = SupplierComment::where($sel_where)
  1205. ->alias('t')
  1206. ->field('t.id,t.is_top,t.create_at,t.is_read,t.content,t.is_deleted,t.pid,goods_id,u.name user_name,u.headimg')
  1207. ->leftJoin('store_member u', 't.user_id = u.id')
  1208. ->order('t.is_top desc,t.id desc')
  1209. ->limit($this->off_set, $this->page_num)
  1210. ->select()->toArray();
  1211. array_walk($list,function (&$v){
  1212. $v['self_name'] = $this->user_info['name'];
  1213. $parent_comment = SupplierComment::where([['t.id', '=', $v['pid']]])
  1214. ->alias('t')
  1215. ->field('t.id,t.content,t.is_deleted,i.read_num,goods_id,i.name goods_name,s.logo supplier_logo ,s.title supplier_name,i.cover,u.name,u.headimg')
  1216. ->leftJoin('store_member u', 't.user_id = u.id')
  1217. ->leftJoin('SupplierGoods i', 't.goods_id = i.id')
  1218. ->leftJoin('Supplier s', 'i.supplier_id = s.id')
  1219. ->find()->toArray();
  1220. $parent_comment['cover_arr'] = $parent_comment['cover']? explode('|',trim($parent_comment['cover'],'|')):null;
  1221. $parent_comment['read_num'] = numTransform($parent_comment['read_num']);
  1222. $parent_comment['is_normal'] =CheckPower::checkModulesPower($parent_comment['goods_id'], 0, 'supplier');
  1223. $v['parent_comment'] = $parent_comment;
  1224. });
  1225. $total_num = SupplierComment::where($sel_where)->alias('t')
  1226. ->leftJoin('store_member u', 't.user_id = u.id')
  1227. ->count();
  1228. $this->success('ok', ['list' => $list, 'total_count' => $total_num, 'page_num' => $this->page_num]);
  1229. }
  1230. /**
  1231. * @title 获取角标数量
  1232. * @desc 获取角标数量
  1233. * @author qc
  1234. * @method GET
  1235. * @url /api/Supplier/getMarkNum
  1236. * @header name:Authorization require:1 desc:Token
  1237. * @return name:comment_num type:int default:-- desc:评论我的【总数量】
  1238. * @return name:reply_num type:int default:-- desc:回复我的【总数量】
  1239. * @return name:follow_num type:int default:-- desc:订阅
  1240. * @return name:praise_num type:int default:-- desc:点赞我的【包含产品点赞和评论点赞】
  1241. * @return name:total_num type:int default:-- desc:总数【comment_num+reply_num+follow_num】
  1242. */
  1243. public function getMarkNum()
  1244. {
  1245. // 评论我的
  1246. $comment_num = SupplierComment::where([['g.user_id', '=', $this->user_id],['c.is_deleted', '=', 0],['c.to_deleted', '=', 0],['c.is_read','=',0],['c.pid','=',0]])
  1247. ->alias('c') ->leftJoin('SupplierGoods g', 'g.id = c.goods_id')->count();
  1248. //回复我的
  1249. $all_comment = SupplierComment::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
  1250. $reply_num = $all_comment ? SupplierComment::where([['t.is_deleted','=',0],['t.to_deleted','=',0],['t.user_id','<>',$this->user_id],['t.is_read','=',0],['t.pid','in',implode(',',$all_comment)]])->alias('t')->count() :0;
  1251. //订阅
  1252. $follow_num = UserMessage::getUnreadNum($this->user_id,'supplier',5);
  1253. $total_num = $comment_num + $reply_num + $follow_num;
  1254. $praise_supplier = PlatformLike::where([['p.type', '=', 7],['f.user_id', '=', $this->user_id],['p.to_deleted', '=', 0],['p.is_read','=',0]])->alias('p') ->leftJoin('SupplierGoods f', 'f.id = p.like_id')->count();
  1255. $praise_comment = PlatformLike::where([['p.type', '=', 11],['c.user_id', '=', $this->user_id],['p.to_deleted', '=', 0],['p.is_read','=',0]])->alias('p')->leftJoin('SupplierComment c', 'c.id = p.like_id')->count();
  1256. $praise_num = $praise_supplier + $praise_comment;
  1257. $this->success('ok', compact([ 'comment_num','reply_num','follow_num','praise_num','total_num']));
  1258. }
  1259. /**
  1260. * @title 我的回复【我的回复--我回复过的评论】
  1261. * @desc 我的回复
  1262. * @author qc
  1263. * @method GET
  1264. * @url /api/Supplier/getReplyComment
  1265. * @header name:Authorization require:1 desc:Token
  1266. * @param name:title type:string default:-- desc:标题
  1267. * @param name:page type:int default:0 desc:页数
  1268. * @param name:page_num type:int default:20 desc:每页数
  1269. * @return name:create_at type:string default:-- desc:时间
  1270. * @return name:content type:string default:-- desc:回复内容
  1271. * @return name:user_name type:string default:-- desc:用户名【用户自己的】
  1272. * @return name:headimg type:string default:-- desc:用户头像【用户自己的】
  1273. *
  1274. * @return name:parent_comment type:array default:-- desc:上级评论内容【阴影部分--你回复的那个】
  1275. * @return name:parent_comment.content type:string default:-- desc:内容
  1276. * @return name:parent_comment.goods_name type:string default:-- desc:产品名称
  1277. * @return name:parent_comment.name type:string default:-- desc:会员名称【别人的】
  1278. * @return name:parent_comment.headimg type:string default:-- desc:会员头像【别人的】
  1279. * @return name:parent_comment.title type:string default:-- desc:标题
  1280. * @return name:parent_comment.goods_id type:int default:-- desc:商品id
  1281. * @return name:parent_comment.supplier_logo type:string default:-- desc:供应商logo
  1282. * @return name:parent_comment.supplier_name type:string default:-- desc:供应商名称
  1283. * @return name:parent_comment.is_deleted type:int default:-- desc:评论删除状态(0未删除)
  1284. * @return name:parent_comment.is_normal type:int default:-- desc:产品状态
  1285. * @return name:parent_comment.cover_arr type:array default:-- desc:产品封面
  1286. * @return name:parent_comment.read_num type:string default:-- desc:浏览量
  1287. */
  1288. public function getReplyComment()
  1289. {
  1290. $sel_where = [];
  1291. $title = input('get.title');
  1292. if($title) $sel_where[] = ['t.content','like','%'.$title.'%'];
  1293. $sel_where[] = ['t.user_id', '=', $this->user_id];
  1294. // $sel_where[] = ['c.user_id', '<>', $this->user_id];
  1295. $sel_where[] = ['t.to_deleted', '=', 0];
  1296. $sel_where[] = ['t.pid', '>', 0];
  1297. $list = SupplierComment::where($sel_where)->alias('t')
  1298. ->field('t.id,t.is_top,t.create_at,t.content,t.pid,t.goods_id,t.is_deleted')
  1299. ->leftJoin('SupplierComment c', 'c.id = t.pid')
  1300. ->order('t.id desc')
  1301. ->limit($this->off_set, $this->page_num)
  1302. ->select()->toArray();
  1303. array_walk($list,function (&$v){
  1304. $v['user_name'] = $this->user_info['name'];
  1305. $v['headimg'] = $this->user_info['headimg'];
  1306. $parent_comment = SupplierComment::where([['t.id', '=', $v['pid']]])
  1307. ->field('t.id,t.content,t.pid,t.goods_id,u.name,u.headimg,i.name goods_name,i.read_num,i.cover,i.is_deleted,s.logo supplier_logo ,s.title supplier_name')
  1308. ->alias('t')->leftJoin('SupplierGoods i', 't.goods_id = i.id')
  1309. ->leftJoin('Supplier s', 'i.supplier_id = s.id')
  1310. ->leftJoin('store_member u', 't.user_id = u.id')
  1311. ->find()->toArray();
  1312. $parent_comment['is_normal'] = CheckPower::checkModulesPower($v['goods_id'],0,$this->request->controller());
  1313. $parent_comment['read_num'] = numTransform($parent_comment['read_num']);
  1314. $parent_comment['cover_arr'] = $parent_comment['cover']? explode('|',trim($parent_comment['cover'],'|')):null;
  1315. $v['parent_comment'] = $parent_comment;
  1316. });
  1317. $total_num = SupplierComment::where($sel_where)->alias('t') ->leftJoin('SupplierComment c', 'c.id = t.pid')->count();
  1318. $this->success('ok', ['list' => $list, 'total_count' => $total_num, 'page_num' => $this->page_num]);
  1319. }
  1320. /**
  1321. * @title 我的评论
  1322. * @desc 我的评论
  1323. * @author qc
  1324. * @method GET
  1325. * @url /api/Supplier/myDiscuss
  1326. * @header name:Authorization require:1 desc:Token
  1327. * @param name:title type:string default:-- desc:关键字
  1328. * @param name:page type:int default:-- desc:页数
  1329. * @param name:page_num type:int default:-- desc:每页数量
  1330. * @return name:create_at type:string default:-- desc:时间
  1331. * @return name:goods_name type:string default:-- desc:产品名称
  1332. * @return name:content type:string default:0 desc:评论内容
  1333. * @return name:name type:string default:-- desc:用户名
  1334. * @return name:headimg type:string default:-- desc:头像
  1335. * @return name:supplier_logo type:string default:-- desc:供应商logo
  1336. * @return name:supplier_name type:string default:-- desc:供应商名称
  1337. * @return name:read_num type:string default:-- desc:阅读量
  1338. * @return name:cover_arr type:array default:-- desc:封面
  1339. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  1340. */
  1341. public function myDiscuss()
  1342. {
  1343. $where = [];
  1344. $where[] = ['c.is_deleted', '=', 0];
  1345. if ($title = input('title')) $where[] = ['c.content', 'like', '%' . $title . '%'];
  1346. $where[] = ['c.user_id', '=', $this->user_id];
  1347. $where[] = ['c.pid', '=', 0];
  1348. $where[] = ['c.is_deleted', '=', 0];
  1349. $list = SupplierComment::field('c.*,m.name,m.headimg,g.name goods_name,g.read_num,s.logo supplier_logo ,s.title supplier_name,g.cover')->alias('c')
  1350. ->where($where)
  1351. ->leftJoin('store_member m', 'm.id = c.user_id')
  1352. ->leftJoin('SupplierGoods g', 'g.id = c.goods_id')
  1353. ->leftJoin('Supplier s', 's.id = g.supplier_id')
  1354. ->order('c.is_top desc,c.id desc')
  1355. ->limit($this->off_set, $this->page_num)
  1356. ->select()->toArray();
  1357. array_walk($list, function (&$v) {
  1358. $v['read_num'] = numTransform($v['read_num']);
  1359. $v['is_normal'] = CheckPower::checkModulesPower($v['goods_id'],0,$this->request->controller());
  1360. $v['cover_arr'] = $v['cover']? explode('|',trim($v['cover'],'|')):null;
  1361. });
  1362. $total_num = SupplierComment::where($where)
  1363. ->alias('c')
  1364. ->leftJoin('store_member m', 'm.id = c.user_id')
  1365. ->leftJoin('SupplierGoods g', 'g.id = c.goods_id')
  1366. ->leftJoin('Supplier s', 's.id = g.supplier_id')->count();
  1367. $this->success('ok', ['list' => $list, 'total_count' => $total_num, 'page_num' => $this->page_num]);
  1368. }
  1369. /**
  1370. * @title 批量删除||批量取消
  1371. * @desc 删除||取消
  1372. * @author qc
  1373. * @method POST
  1374. * @url /api/Supplier/batchesDel
  1375. * @header name:Authorization require:1 desc:Token
  1376. * @param name:id type:string default:1 desc:记录id【多个用逗号隔开=>'1,2'】
  1377. * @param name:type type:string default:1 desc:消息类型【1我的评论,2评论我的,3我的回复,4订阅记录,5追番消息,6我的点赞-产品,7我的点赞-评论,8回复我的,9点赞我的--产品,10点赞我的--评论,11我的收藏】
  1378. */
  1379. public function batchesDel()
  1380. {
  1381. $type = input('post.type',1);
  1382. $del_where = [];
  1383. $del_where[] = ['id','in',input('post.id')];
  1384. if(in_array($type,[1,3,4,5,6,7])) $del_where[] = ['user_id','=',$this->user_id];
  1385. if(in_array($type,[1,3])) SupplierComment::where($del_where)->update(['is_deleted'=>1]);
  1386. if(in_array($type,[2])) SupplierComment::where($del_where)->update(['source_deleted'=>1,'source_read'=>1,'is_read'=>1]);
  1387. if(in_array($type,[4])) PlatformSwitch::where($del_where)->delete();
  1388. if(in_array($type,[5])) UserMessage::where($del_where)->update(['is_deleted'=>1]);
  1389. if(in_array($type,[6,7])) PlatformLike::where($del_where)->delete();
  1390. if(in_array($type,[8])) SupplierComment::where($del_where)->update(['to_deleted'=>1,'is_read'=>1]);
  1391. if(in_array($type,[9,10])) PlatformLike::where($del_where)->update(['to_deleted'=>1,'is_read'=>1]);
  1392. if(in_array($type,[11])) UserCollect::where($del_where)->delete();
  1393. $this->success('操作成功');
  1394. }
  1395. /**
  1396. * @title 消息已读&&未读变更
  1397. * @desc 支持批量选择
  1398. * @author qc
  1399. * @method POST
  1400. * @url /api/Supplier/unreadChange
  1401. * eadChange
  1402. * @header name:Authorization require:1 desc:Token
  1403. * @param name:id type:string default:-- desc:记录id(多个逗号隔开,不传修改全部])
  1404. * @param name:type type:string default:1 desc:消息类型【1评论我的,2回复我的,3订阅消息,4点赞我的】
  1405. * @param name:is_read type:int default:1 desc:变更类型【0消息变更为未读,1变更为已读】
  1406. */
  1407. public function unreadChange()
  1408. {
  1409. $type = input('post.type',1);
  1410. $id = input('post.id');
  1411. $is_read = input('post.is_read');
  1412. $where = [];
  1413. switch ($type) {
  1414. case 1:
  1415. SupplierComment::where([['i.user_id','=',$this->user_id]])
  1416. ->when($id ,function ($query)use ($id){
  1417. if($id) return $query->where('t.id','in',$id);
  1418. })->leftJoin('SupplierGoods i','t.goods_id = i.id')
  1419. ->alias('t') ->update(['source_read'=>$is_read,'is_read'=>$is_read]);
  1420. break;
  1421. case 2:
  1422. $all_comment = SupplierComment::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
  1423. SupplierComment::where([['t.pid','in',implode(',',$all_comment)]])
  1424. ->when($id ,function ($query)use ($id){
  1425. if($id) return $query->where('t.id','in',$id);
  1426. })->alias('t')->update(['is_read'=>$is_read]);
  1427. break;
  1428. case 3:
  1429. $where[] = ['user_id','=',$this->user_id];
  1430. if($id) $where[] = ['id','in',$id];
  1431. UserMessage::where($where)->update(['is_read'=>$is_read]);
  1432. break;
  1433. case 4:
  1434. PlatformLike::where([['p.type', '=', 7],['f.user_id', '=', $this->user_id],['p.to_deleted', '=', 0],['p.is_read','=',0]])->alias('p') ->leftJoin('SupplierGoods f', 'f.id = p.like_id')->update(['p.is_read'=>1]);
  1435. PlatformLike::where([['p.type', '=', 11],['c.user_id', '=', $this->user_id],['p.to_deleted', '=', 0],['p.is_read','=',0]])->alias('p')->leftJoin('SupplierComment c', 'c.id = p.like_id')->update(['p.is_read'=>1]);
  1436. break;
  1437. }
  1438. $this->success('消息变更成功');
  1439. }
  1440. }