Expedite.php 102 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906
  1. <?php
  2. namespace app\api\controller;
  3. use AlibabaCloud\Client\AlibabaCloud;
  4. use AlibabaCloud\Client\Exception\ClientException;
  5. use AlibabaCloud\Client\Exception\ServerException;
  6. use app\common\model\ArticleComment;
  7. use app\common\model\ArticleCommentLike;
  8. use app\common\model\ArticleIntro;
  9. use app\common\model\ArticleItem;
  10. use app\common\model\ArticleLike;
  11. use app\common\model\DatumComment;
  12. use app\common\model\DatumCommentLike;
  13. use app\common\model\DatumLike;
  14. use app\common\model\DatumUrl;
  15. use app\common\model\DemandComment;
  16. use app\common\model\ForumReply;
  17. use app\common\model\ForumReplyComment;
  18. use app\common\model\GoodsOrder;
  19. use app\common\model\PlatformDemand;
  20. use app\common\model\PlatformLike;
  21. use app\common\model\PressComment;
  22. use app\common\model\RecruitResume;
  23. use app\common\model\ShoppingTrolley;
  24. use app\common\model\StoreBanner;
  25. use app\common\model\StoreGoods;
  26. use app\common\model\StoreGoodsItem;
  27. use app\common\model\SupplierComment;
  28. use app\common\model\SupplierGoods;
  29. use app\common\model\TopSearch;
  30. use app\common\model\User;
  31. use app\common\model\UserCollect;
  32. use app\common\model\UserForum;
  33. use app\common\model\UserLevel;
  34. use app\common\model\UserLevelRank;
  35. use app\common\model\UserMessage;
  36. use app\common\model\UserSearch;
  37. use app\common\model\VideoCommentLike;
  38. use app\common\model\VideoIntro;
  39. use app\common\model\VideoUrl;
  40. use app\common\service\CheckPower;
  41. use app\common\service\Elastic;
  42. use app\common\service\UserSynth;
  43. use Dm\Request\V20151123 as Dm;
  44. use library\tools\Data;
  45. use think\cache\driver\Redis;
  46. use think\Db;
  47. use app\common\model\VideoComment;
  48. /**
  49. * @title 其他接口(不需要登录状态)【多模块共用】
  50. * @controller Expedite
  51. * @package app\api\controller
  52. */
  53. class Expedite extends Base
  54. {
  55. public function initialize(){
  56. parent::initialize();
  57. parent::setUid();
  58. }
  59. /**
  60. * @title 获取首页轮播图
  61. * @desc 获取首页轮播图
  62. * @author qc
  63. * @url /api/Expedite/getBanner
  64. * @method GET
  65. * @header name:Authorization require:1 desc:Token
  66. * @param name:num type:int default:5 desc:查询数量
  67. * @param name:is_pc type:int default:0 desc:是否是pc端用(0否1是)
  68. * @return name:cover type:string default:-- desc:图片路径
  69. * @return name:place type:string default:-- desc:跳转模块【video=>视频,article=>图文,datum=>资料,activity=>活动,demand=>需求,forum=>问答,press=>新闻,supplier=>供应商商品,recruit=>招聘,mall=>商城,service=>客服】
  70. * @return name:first_id type:int default:-- desc:详情id(视频、图文、资料为系列id)
  71. * @return name:second_id type:second_id default:-- desc:系列某详情id(视频、图文、资料)
  72. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  73. */
  74. public function getBanner()
  75. {
  76. $num = input('get.num',100);
  77. $is_pc = input('get.is_pc',0);
  78. $list = StoreBanner::field('id,cover,place,first_id,second_id')
  79. ->where(['is_deleted'=>0,'is_pc'=>$is_pc])
  80. ->limit(0,$num)
  81. ->order('sort desc ,id desc')->select()->toArray();
  82. foreach ($list as &$v){
  83. $v['is_normal'] = CheckPower::checkModulesPower($v['first_id'],$v['second_id'],$v['place']);
  84. }
  85. $this->success('ok',['list'=>$list]);
  86. }
  87. /**
  88. * @title 添加极光推送记录
  89. * @desc 添加极光推送记录
  90. * @author qc
  91. * @url /api/Expedite/clientLog
  92. * @method POST
  93. * @tag 编辑信息
  94. * @header name:Authorization require:1 desc:Token
  95. * @param name:type type:string default:1 desc:类型
  96. * @param name:log type:int default:-- desc:记录内容
  97. */
  98. public function clientLog()
  99. {
  100. $data = input();
  101. if($this->user_id){
  102. $data['user_id'] = $this->user_id;
  103. }
  104. $data['create_at'] = date('Y-m-d H:i:s');
  105. $client_log = Db::name('client_log')->insert($data);
  106. $this->success('添加成功',['detail'=>$client_log]);
  107. }
  108. /**
  109. * @title 推送查询
  110. * @desc 推送查询
  111. * @author qc
  112. * @url /api/Expedite/aliases
  113. * @method GET
  114. * @tag 环信
  115. * @param name:filename type:string default:-- desc:语音文件的名称
  116. * @param name:from type:string default:-- desc:发送方用户id
  117. * @param name:to type:string default:-- desc:接收方用户id
  118. * @param name:url type:string default:-- desc:语音文件的url地址
  119. * @return name:url type:string default:-- desc:语音文件的url地址
  120. */
  121. public function aliases(){
  122. $data = input();
  123. // if(!$data['url'] || !$data['from'] || !$data['to'] || !$data['url']){
  124. //
  125. // }
  126. $arr = [
  127. 'url'=>'https://device.jpush.cn/v3/aliases/479?new_format=true',
  128. 'AppKey'=>config('app.jiguang')['AppKey'],
  129. 'MasterSecret'=>config('app.jiguang')['MasterSecret'],
  130. ];
  131. // $hx_voice = hx_voice(24);
  132. // $url= $arr['url'].$arr['org_name'].'/'.$arr['app_name'].'/'.'messages/users';
  133. // $body['from'] = $data['form']; //'member2200'
  134. // $body['to'] = $data['to']; //worker1000
  135. // $body['type'] = 'audio';
  136. // $body['body'] = [
  137. // 'filename' => $data['filename'], //'testaudio.amr', //语音文件的名称
  138. // 'url' => $data['url'] //'http://tmp/bQo7Udv1FETr01c4bb0ecee3a2edb86b00a393176fcc.durationTime=2790.aac', //语音文件的url地址
  139. // ];
  140. $body = [
  141. // "registration_ids"=>[
  142. // "remove"=> ["100d85590840f4bd5b8"]
  143. // ]
  144. ];
  145. $options['type']="audio";
  146. $options['msg']='发送';
  147. $b=json_encode($body);
  148. // return $b;
  149. $str = $arr['AppKey'].':'.$arr['MasterSecret'];
  150. //$str = '7d431e42dfa6a6d693ac2d04:5e987ac6d2e04d95a9d8f0d1';
  151. $base64 = base64_encode($str);
  152. //$header=['Authorization' => ];
  153. $header = array("Authorization: Basic ".$base64);
  154. // return json($header);
  155. $result=$this->postCurl($arr['url'],$b,$header,'GET');
  156. // $result=$this->postCurl($url,$body,$header);
  157. //dump($result);
  158. return json($result);
  159. // return $hx_voice;
  160. }
  161. public function postCurl($url,$body,$header,$type="POST"){
  162. //1.创建一个curl资源
  163. $ch = curl_init();
  164. //2.设置URL和相应的选项
  165. curl_setopt($ch,CURLOPT_URL,$url);//设置url
  166. //1)设置请求头
  167. // array_push($header, 'Accept:application/json');
  168. // array_push($header,'Content-Type:application/json');
  169. // array_push($header, 'http:multipart/form-data');
  170. //设置为false,只会获得响应的正文(true的话会连响应头一并获取到)
  171. curl_setopt($ch,CURLOPT_HEADER,0);
  172. // curl_setopt ( $ch, CURLOPT_TIMEOUT,5); // 设置超时限制防止死循环
  173. //设置发起连接前的等待时间,如果设置为0,则无限等待。
  174. curl_setopt($ch,CURLOPT_CONNECTTIMEOUT,5);
  175. //将curl_exec()获取的信息以文件流的形式返回,而不是直接输出。
  176. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  177. //2)设备请求体
  178. if (strlen($body)>0) {
  179. //$b=json_encode($body,true);
  180. curl_setopt($ch, CURLOPT_POSTFIELDS, $body);//全部数据使用HTTP协议中的"POST"操作来发送。
  181. }
  182. //设置请求头
  183. // if(count($header)>0){
  184. // curl_setopt($ch,CURLOPT_HTTPHEADER,$header);
  185. // }
  186. curl_setopt($ch,CURLOPT_HTTPHEADER,$header);
  187. //上传文件相关设置
  188. curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);
  189. curl_setopt($ch, CURLOPT_MAXREDIRS, 3);
  190. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);// 对认证证书来源的检查
  191. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);// 从证书中检查SSL加密算
  192. //3)设置提交方式
  193. switch($type){
  194. case "GET":
  195. curl_setopt($ch,CURLOPT_HTTPGET,true);
  196. break;
  197. case "POST":
  198. curl_setopt($ch,CURLOPT_POST,true);
  199. break;
  200. case "PUT"://使用一个自定义的请求信息来代替"GET"或"HEAD"作为HTTP请求。这对于执行"DELETE" 或者其他更隐蔽的HTT
  201. curl_setopt($ch,CURLOPT_CUSTOMREQUEST,"PUT");
  202. break;
  203. case "DELETE":
  204. curl_setopt($ch,CURLOPT_CUSTOMREQUEST,"DELETE");
  205. break;
  206. }
  207. //4)在HTTP请求中包含一个"User-Agent: "头的字符串。-----必设
  208. // curl_setopt($ch, CURLOPT_USERAGENT, 'SSTS Browser/1.0');
  209. // curl_setopt($ch, CURLOPT_ENCODING, 'gzip');
  210. //curl_setopt ( $ch, CURLOPT_USERAGENT, 'Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0; Trident/4.0)' ); // 模拟用户使用的浏览器
  211. //5)
  212. //3.抓取URL并把它传递给浏览器
  213. $res=curl_exec($ch);
  214. $result=json_decode($res,true);
  215. //4.关闭curl资源,并且释放系统资源
  216. curl_close($ch);
  217. if(empty($result))
  218. return $res;
  219. else
  220. return $result;
  221. }
  222. /**
  223. * @title 获取会员等级设置
  224. * @desc 获取会员等级设置
  225. * @author qc
  226. * @url /api/Expedite/getUserLevelSet
  227. * @method GET
  228. * @header name:Authorization require:1 desc:Token
  229. * @return name:id type:int default:-- desc:等级id
  230. * @return name:name type:string default:-- desc:等级名称
  231. * @return name:logo type:string default:-- desc:图片
  232. * @return name:price type:array default:-- desc:价格设置【为空,,不能购买】
  233. * @return name:price.title type:string default:-- desc:标题
  234. * @return name:price.time type:string default:-- desc:时间(单位月)
  235. * @return name:price.price type:float default:-- desc:价格
  236. * @return name:price.renew type:int default:-- desc:续费价格
  237. * @return name:is_renew type:int default:-- desc:是否是续费会员【1是0否】
  238. */
  239. public function getUserLevelSet()
  240. {
  241. $list = UserLevel::field('id,logo,name,price')->where("price is not null and price != ''")->where('id',1)->select()->toArray();
  242. foreach ($list as &$v) {
  243. $v['price_arr'] = json_decode($v['price'],true);
  244. }
  245. $is_renew = \app\common\model\LevelOrder::where('user_id',$this->user_id)->where('status',1)->where('pay_state',1)->count();
  246. $this->success('ok',['list'=>$list,'is_renew'=>$is_renew ? 1:0]);
  247. }
  248. /**
  249. * @title 会员等级开关【IOS用】
  250. * @desc 会员等级开关
  251. * @author qc
  252. * @url /api/Expedite/levelSwitch
  253. * @method GET
  254. * @header name:Authorization require:1 desc:Token
  255. * @return name:value type:int default:-- desc:0关闭1开启
  256. */
  257. public function levelSwitch(){
  258. $this->success('ok',['value'=>sysconf('level_switch')]);
  259. }
  260. /**
  261. * @title 注销开关
  262. * @desc 注销开关
  263. * @author qc
  264. * @url /api/Expedite/logoutSwitch
  265. * @method GET
  266. * @header name:Authorization require:1 desc:Token
  267. * @return name:value type:int default:-- desc:0关闭1开启
  268. */
  269. public function logoutSwitch(){
  270. $this->success('ok',['value'=>sysconf('logout_switch')]);
  271. }
  272. /**
  273. * @title 获取热搜列表
  274. * @desc 获取热搜列表
  275. * @author qc
  276. * @url /api/Expedite/getTopSearch
  277. * @method GET
  278. * @param name:page type:int default:-- desc:页数
  279. * @param name:page_num type:int default:-- desc:每页数量
  280. * @param name:module type:string default:-- desc:模块,不传查全部的[video=>视频,article=>图文,datum=>资料,goods=>商城商品,press=>新闻,supplier_goods=>供应商商品,demand=>需求,recruit=>招聘,forum=>问答,activity=>活动]
  281. * @return name:title type:string default:-- desc:标题
  282. * @return name:hot_num type:int default:-- desc:热搜量
  283. * @return name:rel_id type:int default:-- desc:相关详情id【不是系列id】
  284. * @return name:series_id type:int default:-- desc:系列id【图文、视频、资料用】
  285. * @return name:module type:string default:-- desc:[video=>视频,article=>图文,datum=>资料,goods=>商城商品,press=>新闻,supplier_goods=>供应商商品,demand=>需求,recruit=>招聘,forum=>问答,activity=>活动]
  286. */
  287. public function getTopSearch()
  288. {
  289. $module = input('module');
  290. $data = input();
  291. if(isset($data['module'])){
  292. $most_num = 30;
  293. }else{
  294. $most_num = 60;
  295. }
  296. if(!isset($data['page_num'])){
  297. $data['page_num'] = 20;
  298. }
  299. if(!isset($data['page'])){
  300. $data['page'] = 1;
  301. }
  302. $total_num = (int)$data['page_num'] * (int)$data['page'];
  303. // return $total_num.'-'.$most_num;
  304. $page_num = $this->page_num;
  305. if($total_num > $most_num){
  306. $t_num = $total_num - $most_num;
  307. $l_num = $data['page_num'] - $t_num;
  308. //$this->page_num = $l_num;
  309. $page_num = $l_num;
  310. //$this->off_set = $l_num;
  311. // return $l_num;
  312. }
  313. $sel = [];
  314. $sel['is_deleted'] = 0;
  315. $sel['status'] = 1;
  316. if($module) $sel['module'] =$module;
  317. if($page_num <= 0){
  318. $list = [];
  319. }else{
  320. // if(){
  321. //$video_list = VideoUrl::field('a.id url_id,a.create_at,a.video_id,a.cover,a.title,a.is_vip,a.ali_vid,a.label,a.read_num,a.transmit_num,a.user_id,a.duration')->alias('a')
  322. // ->when($search_name,function ($query)use ($search_name,$search_time){
  323. // if($search_name) $query->where('a.title|a.label','like','%'.$search_name.'%');
  324. // if($search_time) $query->where('a.create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));
  325. // })->leftJoin('video_intro b','b.id = a.video_id')
  326. // ->where('a.status',1)->where('release_time','< time',date('Y-m-d H:i:s'))->where('a.is_deleted',0)
  327. // ->where('b.status',1)->where('b.is_deleted',0)->limit($this->off_set,$this->page_num)->order($order)
  328. // ->select()->toArray();
  329. // }
  330. $list = TopSearch::field('id,title,rel_id,module,hot_num,series_id')
  331. ->where($sel)
  332. ->order('hot_num desc')
  333. ->limit($this->off_set,$page_num)
  334. ->select()->toArray();
  335. }
  336. $total_num =TopSearch::where($sel)->count();
  337. if($total_num > $most_num){
  338. $total_num = $most_num;
  339. }
  340. $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
  341. }
  342. /**
  343. * @title 全局搜索【登录状态需要header需要传Authorization】
  344. * @desc 全局搜索
  345. * @author qc
  346. * @url /api/Expedite/globalSearch
  347. * @method GET
  348. * @param name:page type:int default:-- desc:页数
  349. * @param name:page_num type:int default:-- desc:每页数量
  350. * @param name:type type:string default:-- desc:搜索类型(不传查全部)[video=>视频,article=>图文,datum=>资料,goods=>商城商品,press=>新闻,supplier_goods=>供应商商品,demand=>需求,recruit=>招聘,forum=>问答,activity=>活动]
  351. * @param name:search_name type:string default:-- desc:搜索名称
  352. * @param name:search_time type:int default:-- desc:0不限,182半年,365一年
  353. * @param name:sort_type type:int default:1 desc:1默认2时间升序3时间降序 *
  354. * @return name:video_list type:array default:-- desc:视频列表【单个】
  355. * @return name:video_list.url_id type:int default:-- desc:url_id
  356. * @return name:video_list.video_id type:int default:-- desc:video_id
  357. * @return name:video_list.cover type:string default:-- desc:封面
  358. * @return name:video_list.title type:string default:-- desc:标题
  359. * @return name:video_list.is_vip type:int default:-- desc:是否是vip【0否1是】
  360. * @return name:video_list.ali_vid type:string default:-- desc:云点播视频id
  361. * @return name:video_list.read_num type:int default:-- desc:播放量
  362. * @return name:video_list.duration type:int default:-- desc:时长(单位:秒)
  363. * @return name:video_list.app_name type:string default:-- desc:平台名称
  364. * @return name:video_list.app_logo type:string default:-- desc:平台头像
  365. * @return name:video_list.create_at type:string default:-- desc:时间
  366. * @return name:article_list type:array default:-- desc:图文列表【单个】
  367. * @return name:article_list.title type:string default:-- desc:图文标题
  368. * @return name:article_list.is_vip type:int default:-- desc:是否是vip
  369. * @return name:article_list.desc type:int default:-- desc:简介【文本】
  370. * @return name:article_list.cover type:string default:-- desc:封面
  371. * @return name:article_list.images type:int default:-- desc:图片【多张|隔开】
  372. * @return name:article_list.images_arr type:array default:-- desc:图片
  373. * @return name:article_list.read_num type:int default:-- desc:阅读量
  374. * @return name:article_list.app_name type:string default:-- desc:平台名称
  375. * @return name:article_list.app_logo type:string default:-- desc:平台头像
  376. * @return name:article_list.create_at type:string default:-- desc:时间
  377. *
  378. * @return name:datum_list type:array default:-- desc:资料列表【单个】
  379. * @return name:datum_list.id type:int default:-- desc:资料的url_id
  380. * @return name:datum_list.title type:string default:-- desc:标题
  381. * @return name:datum_list.is_vip type:int default:-- desc:是否是vip
  382. *
  383. * @return name:press_list type:array default:-- desc:新闻列表
  384. * @return name:press_list.id type:int default:-- desc:新闻id
  385. * @return name:press_list.title type:string default:-- desc:标题
  386. * @return name:press_list.cover type:string default:-- desc:封面
  387. * @return name:press_list.images_arr type:array default:-- desc:图片
  388. * @return name:press_list.read_num type:int default:-- desc:阅读量
  389. * @return name:press_list.is_collect type:int default:-- desc:是否收藏(0否1是)
  390. * @return name:press_list.transmit_num type:int default:-- desc:转发量
  391. * @return name:press_list.collect_num type:int default:-- desc:收藏量
  392. * @return name:press_list.praise_num type:int default:-- desc:点赞量
  393. * @return name:press_list.is_praise type:int default:-- desc:是否点赞(0否1是)
  394. * @return name:press_list.comment_num type:int default:-- desc:评论量
  395. *
  396. *
  397. *
  398. *
  399. * @return name:recruit_list type:array default:-- desc:招聘列表
  400. * @return name:recruit_list.title type:string default:-- desc:标题
  401. * @return name:recruit_list.company type:string default:-- desc:公司名
  402. * @return name:recruit_list.cover type:string default:-- desc:公司logo
  403. * @return name:recruit_list.label_name type:array default:-- desc:标签
  404. * @return name:recruit_list.welfare_arr type:array default:-- desc:岗位福利
  405. * @return name:recruit_list.education type:string default:-- desc:学历
  406. * @return name:recruit_list.experience_min type:int default:0 desc:最低工作年限
  407. * @return name:recruit_list.experience_max type:int default:0 desc:最高工作年限
  408. * @return name:recruit_list.price_min type:int default:-- desc:最低薪资
  409. * @return name:recruit_list.price_max type:int default:-- desc:最高薪资
  410. * @return name:recruit_list.province type:string default:-- desc:省名
  411. * @return name:recruit_list.city type:string default:-- desc:市名
  412. * @return name:recruit_list.address type:string default:-- desc:地址
  413. * @return name:recruit_list.app_name type:string default:-- desc:发布人名称
  414. * @return name:recruit_list.app_logo type:string default:-- desc:发布人头像
  415. *
  416. * @return name:goods_list type:array default:-- desc:商城商品
  417. * @return name:goods_list.id type:int default:-- desc:d
  418. * @return name:goods_list.name type:string default:-- desc:商品名称
  419. * @return name:goods_list.cover type:string default:-- desc:封面
  420. * @return name:goods_list.low_price type:float default:-- desc:价格
  421. *
  422. * @return name:supplier_goods_list type:array default:-- desc:供应商商品
  423. * @return name:supplier_goods_list.id type:int default:-- desc:供应商商品d
  424. * @return name:supplier_goods_list.name type:string default:-- desc:商品名称
  425. * @return name:supplier_goods_list.cover_arr type:array default:-- desc:封面
  426. * @return name:supplier_goods_list.label_name type:array default:-- desc:标签
  427. * @return name:supplier_goods_list.label type:string default:-- desc:标签
  428. * @return name:supplier_goods_list.read_num type:int default:-- desc:浏览量
  429. * @return name:supplier_goods_list.supplier_name type:float default:-- desc:供应商名称
  430. *
  431. * @return name:demand_list type:array default:-- desc:需求
  432. * @return name:demand_list.title type:string default:-- desc:标题
  433. * @return name:demand_list.content type:string default:-- desc:内容
  434. * @return name:demand_list.cover type:array default:-- desc:封面
  435. * @return name:demand_list.money type:float default:-- desc:价格
  436. * @return name:demand_list.app_name type:string default:-- desc:发布方名称
  437. * @return name:demand_list.app_logo type:string default:-- desc:发布方头像
  438. * @return name:demand_list.is_over type:int default:-- desc:是否解决或开源【0否,1是,2开源】
  439. * @return name:demand_list.company type:string default:-- desc:公司名
  440. * @return name:demand_list.company_logo type:string default:-- desc:公司logo
  441. *
  442. *
  443. * @return name:forum_list type:array default:-- desc:问答
  444. * @return name:forum_list.id type:int default:-- desc:id
  445. * @return name:forum_list.title type:string default:-- desc:标题
  446. * @return name:forum_list.content type:string default:0 desc:内容
  447. * @return name:forum_list.level type:int default:-- desc:vip等级id
  448. * @return name:forum_list.label type:string default:-- desc:标签
  449. * @return name:forum_list.name type:string default:-- desc:发布用户
  450. * @return name:forum_list.headimg type:string default:-- desc:发布用户头像
  451. * @return name:forum_list.browse_num type:int default:-- desc:浏览量
  452. * @return name:forum_list.reply_num type:int default:-- desc:回答量
  453. *
  454. * @return name:activity_list type:array default:-- desc:活动
  455. * @return name:activity_list.id type:int default:-- desc:id
  456. * @return name:activity_list.address type:string default:-- desc:地址
  457. * @return name:activity_list.cover type:string default:-- desc:封面
  458. * @return name:activity_list.label_name type:array default:-- desc:标签
  459. * @return name:activity_list.start_time type:string default:-- desc:开始时间
  460. * @return name:activity_list.end_time type:string default:-- desc:结束时候
  461. * @return name:activity_list.end_time type:string default:-- desc:结束时间
  462. * @return name:activity_list.price type:string default:-- desc:价格
  463. */
  464. public function globalSearch()
  465. {
  466. $type = input('get.type');
  467. $search_name = input('get.search_name');
  468. $search_time = input('get.search_time');
  469. $sort_type = input('get.sort_type');
  470. $app_name = sysconf('app_name');
  471. $app_logo = sysconf('app_logo');
  472. $user_id = $this->user_id;
  473. switch ($sort_type) {
  474. case 1:
  475. $order = ['a.sort'=>'desc','a.id'=>'asc'];
  476. break;
  477. case 2:
  478. $order = ['a.id'=>'asc','a.sort'=>'desc'];
  479. break;
  480. case 3:
  481. $order = ['a.id'=>'desc','a.sort'=>'desc'];
  482. break;
  483. }
  484. if($this->user_id && $search_name) UserSearch::saveSearchTitle($this->user_id,$search_name,0);
  485. // 视频
  486. $video_list = VideoUrl::field('a.id url_id,a.create_at,a.video_id,a.cover,a.title,a.is_vip,a.ali_vid,a.label,a.read_num,a.transmit_num,a.user_id,a.duration')->alias('a')
  487. ->when($search_name,function ($query)use ($search_name,$search_time){
  488. if($search_name) $query->where('a.title|a.label','like','%'.$search_name.'%');
  489. if($search_time) $query->where('a.create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));
  490. })->leftJoin('video_intro b','b.id = a.video_id')
  491. ->where('a.status',1)->where('release_time','< time',date('Y-m-d H:i:s'))->where('a.is_deleted',0)
  492. ->where('b.status',1)->where('b.is_deleted',0)->limit($this->off_set,$this->page_num)->order($order)
  493. ->select()->toArray();
  494. array_walk($video_list,function (&$v,$k)use ($app_name,$app_logo){
  495. $v['label_name'] = $v['label'] ? explode(',',trim($v['label'],',')) : null;
  496. $video_auth = VideoUrl::getVideoAuth($v['user_id'],APPNAME,APPLOGO);
  497. $v['app_name'] = $video_auth['app_name'];
  498. $v['app_logo'] = $video_auth['app_logo'];
  499. });
  500. $video_num = VideoUrl::when($search_name,function ($query)use ($search_name,$search_time){
  501. if($search_name) $query->where('a.title|a.label','like','%'.$search_name.'%');
  502. if($search_time) $query->where('a.create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));
  503. })->alias('a')->leftJoin('video_intro b','b.id = a.video_id')->where('release_time','< time',date('Y-m-d H:i:s'))
  504. ->where('a.status',1)->where('a.is_deleted',0)->where('b.status',1)->where('b.is_deleted',0)->count();
  505. // 图文
  506. $article_list = ArticleItem::field('a.id item_id,a.user_id,a.create_at,a.article_id,a.cover,a.title,a.is_vip,a.images,a.read_num,a.desc')->alias('a')
  507. ->when($search_name,function ($query)use ($search_name,$search_time){
  508. if($search_name) $query->where('a.title|a.label','like','%'.$search_name.'%');
  509. if($search_time) $query->where('a.create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));
  510. })->leftJoin('article_intro b','a.article_id = b.id')
  511. ->where('a.status',1)->where('a.is_deleted',0)->where('b.status',1)->where('b.is_deleted',0) ->where('release_time','< time',date('Y-m-d H:i:s'))->order($order)
  512. ->limit($this->off_set,$this->page_num)->select()->toArray();
  513. array_walk($article_list,function (&$v,$k)use ($app_name,$app_logo){
  514. $article_auth = VideoUrl::getVideoAuth($v['user_id'],APPNAME,APPLOGO);
  515. $v['app_name'] = $article_auth['app_name'];
  516. $v['app_logo'] = $article_auth['app_logo'];
  517. });
  518. $article_num = ArticleItem::when($search_name,function ($query)use ($search_name,$search_time){
  519. if($search_name) $query->where('a.title|a.label','like','%'.$search_name.'%');
  520. if($search_time) $query->where('a.create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));
  521. })->leftJoin('article_intro b','a.article_id = b.id')->alias('a') ->where('release_time','< time',date('Y-m-d H:i:s'))
  522. ->where('a.status',1)->where('a.is_deleted',0)->where('b.status',1)->where('b.is_deleted',0)->count();
  523. // 资料
  524. $datum_list = DatumUrl::field('a.id,a.url,a.datum_id,a.title,a.is_vip,a.create_at')->alias('a')
  525. ->when($search_name,function ($query)use ($search_name,$search_time){
  526. if($search_name) $query->where('a.title|a.label','like','%'.$search_name.'%');
  527. if($search_time) $query->where('a.create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));
  528. })->leftJoin('datum_intro b','b.id = a.datum_id') ->where('release_time','< time',date('Y-m-d H:i:s'))
  529. ->where('a.status',1)->where('a.is_deleted',0)->where('b.status',1)->where('b.is_deleted',0) ->order($order)
  530. ->limit($this->off_set,$this->page_num)->select()->toArray();
  531. $datum_num = DatumUrl::alias('a')->when($search_name,function ($query)use ($search_name,$search_time){
  532. if($search_name) $query->where('a.title|a.label','like','%'.$search_name.'%');
  533. if($search_time) $query->where('a.create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));
  534. })->leftJoin('datum_intro b','b.id = a.datum_id')->where('a.status',1)->where('a.is_deleted',0)->where('b.status',1)
  535. ->where('release_time','< time',date('Y-m-d H:i:s'))->where('b.is_deleted',0)->count();
  536. //新闻
  537. $press_list = \app\common\model\Press::field('id,title,cover,images,read_num')->alias('a')
  538. ->when($search_name,function ($query)use ($search_name,$search_time){
  539. if($search_name) $query->where('title|label','like','%'.$search_name.'%');
  540. if($search_time) $query->where('create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));
  541. })->where('status',1)->where('is_deleted',0) ->where('release_time','< time',date('Y-m-d H:i:s'))->order($order)
  542. ->limit($this->off_set,$this->page_num)->select()->toArray();
  543. array_walk($press_list,function (&$v,$k){
  544. $v['comment_num'] = PressComment::where(['first_id'=>$v['id'],'type'=>1,'is_deleted'=>0])->count();
  545. $v['is_collect'] = UserCollect::checkCollectByType($this->user_id,4,$v['id']);
  546. $v['collect_num'] = UserCollect::getCollectNum(4,$v['id']);
  547. $v['is_praise'] = PlatformLike::checkTags($this->user_id,$v['id'],1);
  548. $v['praise_num'] = PlatformLike::getPraiseNum($v['id'],1);
  549. $v['images_arr'] = $v['images'] ? explode('|',$v['images']) : null;
  550. });
  551. $press_num = \app\common\model\Press::when($search_name,function ($query)use ($search_name,$search_time){
  552. if($search_name) $query->where('title|label','like','%'.$search_name.'%');
  553. if($search_time) $query->where('create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));
  554. })->where('status',1)->where('is_deleted',0) ->where('release_time','< time',date('Y-m-d H:i:s'))->count();
  555. //招聘
  556. $recruit_list = \app\common\model\Recruit::field('id,title,label,address,price_min,price_max,company,education,experience_min,experience_max,welfare,province,city,salary,user_id')
  557. ->alias('a')->when($search_name,function ($query)use ($search_name,$search_time){
  558. if($search_name) $query->where('title|label','like','%'.$search_name.'%');
  559. if($search_time) $query->where('create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));
  560. })->where('status',1)->where('is_deleted',0) ->where('release_time','< time',date('Y-m-d H:i:s'))->order($order)
  561. ->limit($this->off_set,$this->page_num)->select()->toArray();
  562. array_walk($recruit_list,function (&$v,$k)use ($app_logo,$app_name){
  563. $v['label_name'] = $v['label']? explode(',',trim($v['label'],',')) : null;
  564. $v['welfare_arr'] = explode(',',trim($v['welfare'],','));
  565. if(!$v['user_id']){
  566. $v['app_name'] = $app_name;
  567. $v['app_logo'] = $app_logo;
  568. }else{
  569. $user_info = User::where('id',$v['user_id'])->field('name,headimg')->find();
  570. $v['app_name'] = $user_info ? $user_info->name : '';
  571. $v['app_logo'] = $user_info ? $user_info->headimg : '';
  572. }
  573. });
  574. $recruit_num = \app\common\model\Recruit::when($search_name,function ($query)use ($search_name,$search_time){
  575. if($search_name) $query->where('title|label','like','%'.$search_name.'%');
  576. if($search_time) $query->where('create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));
  577. })->where('status',1)->where('is_deleted',0) ->where('release_time','< time',date('Y-m-d H:i:s'))->count();
  578. // 商品
  579. $goods_list = StoreGoods::field('id,name,cover,low_price')->alias('a')->when($search_name,function ($query)use ($search_name,$search_time){
  580. if($search_name) $query->where('name','like','%'.$search_name.'%');
  581. if($search_time) $query->where('create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));
  582. })->where('is_deleted',0)->where('status',1)->order($order)->limit($this->off_set,$this->page_num)->select()->toArray();
  583. $goods_num =StoreGoods::when($search_name,function ($query)use ($search_name,$search_time){
  584. if($search_name) $query->where('name','like','%'.$search_name.'%');
  585. if($search_time) $query->where('create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));
  586. })->where('is_deleted',0)->where('status',1) ->where('release_time','< time',date('Y-m-d H:i:s'))->count();
  587. // 供应商
  588. $supplier_goods_list =SupplierGoods::field('a.id,a.supplier_id,a.name,a.read_num,a.label,a.cover,s.title supplier_name,a.create_at')
  589. ->alias('a')->when($search_name,function ($query)use($search_name,$search_time){
  590. if($search_name) $query->where('a.name','like','%'.$search_name.'%');
  591. if($search_time) $query->where('a.create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));
  592. })->leftJoin('Supplier s','a.supplier_id = s.id')->where('a.status','=',1)->where('a.is_deleted','=',0)->where('s.status','=',1)->where('s.is_deleted','=',0)
  593. ->where('release_time','< time',date('Y-m-d H:i:s'))->limit($this->off_set,$this->page_num) ->order($order)->select()->toArray();
  594. array_walk($supplier_goods_list,function (&$v,$k){
  595. $v['label_name'] = $v['label']? explode(',',trim($v['label'],',')) : null;
  596. $v['cover_arr'] = explode('|',trim($v['cover'],'|'));
  597. });
  598. $supplier_goods_num = SupplierGoods::when($search_name,function ($query)use($search_name,$search_time){
  599. if($search_name) $query->where('g.name','like','%'.$search_name.'%');
  600. if($search_time) $query->where('g.create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));
  601. })->alias('g')->leftJoin('Supplier s','g.supplier_id = s.id')->where('g.status','=',1) ->where('g.release_time','< time',date('Y-m-d H:i:s'))
  602. ->where('g.is_deleted','=',0)->where('s.status','=',1)->where('s.is_deleted','=',0)->count();
  603. // 需求
  604. $demand_list = PlatformDemand::field('id,cover,money,user_id,label,title,cover,is_over,content,company,company_logo,a.create_at')->alias('a')
  605. ->when($search_name,function ($query)use ($search_name,$search_time){
  606. if($search_name) $query->where('title|label','like','%'.$search_name.'%');
  607. if($search_time) $query->where('create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));
  608. })->where('status',1)->where('is_deleted',0) ->where('release_time','< time',date('Y-m-d H:i:s'))
  609. ->limit($this->off_set,$this->page_num)->order($order)->select()->toArray();
  610. array_walk($demand_list,function (&$v,$k)use ($app_logo,$app_name){
  611. if(!$v['user_id']){
  612. $v['app_name'] = $app_name;
  613. $v['app_logo'] = $app_logo;
  614. }else{
  615. $user_info = User::where('id',$v['user_id'])->field('name,headimg')->find();
  616. $v['app_name'] = $user_info ? $user_info->name : '';
  617. $v['app_logo'] = $user_info ? $user_info->headimg : '';
  618. }
  619. $v['label_name'] = $v['label']? explode(',',trim($v['label'],',')) : null;
  620. $v['cover_arr'] = explode('|',trim($v['cover'],'|'));
  621. });
  622. $demand_num = PlatformDemand::when($search_name,function ($query)use ($search_name,$search_time){
  623. if($search_name) $query->where('title|label','like','%'.$search_name.'%');
  624. if($search_time) $query->where('create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));
  625. })->where('status',1)->where('is_deleted',0) ->where('release_time','< time',date('Y-m-d H:i:s'))->count();
  626. // 问答
  627. $forum_list = UserForum::field('a.id,a.title,a.content,a.label,a.level,a.browse_num,a.sort,a.create_at,u.name,u.headimg, IFNULL( (SELECT count(DISTINCT r.user_id) FROM dd_forum_reply as r WHERE a.id=r.forum_id),0 ) as reply_num')->alias('a')
  628. ->when($search_name,function ($query)use ($search_name,$search_time){
  629. if($search_name) $query->where('a.title|a.label','like','%'.$search_name.'%');
  630. if($search_time) $query->where('a.create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));
  631. })->leftJoin('store_member u','u.id = a.user_id') ->where('release_time','< time',date('Y-m-d H:i:s'))
  632. ->where('a.status',1)->where('a.is_deleted',0)->order($order)->limit($this->off_set,$this->page_num)->select()->toArray();
  633. $forum_num = UserForum::field('a.id')->alias('a')->when($search_name,function ($query)use ($search_name,$search_time){
  634. if($search_name) $query->where('a.title|a.label','like','%'.$search_name.'%');
  635. if($search_time) $query->where('a.create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));
  636. })->leftJoin('store_member u','u.id = a.user_id')
  637. ->where('a.status',1) ->where('release_time','< time',date('Y-m-d H:i:s'))
  638. ->where('a.is_deleted',0)->count();
  639. // 活动
  640. $activity_list = \app\common\model\Activity::field('id,cover,title,address,label,start_time,end_time,ladder,price,a.create_at')->alias('a')
  641. ->when($search_name,function ($query)use ($search_name,$search_time){
  642. if($search_name) $query->where('title|label','like','%'.$search_name.'%');
  643. if($search_time) $query->where('create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));
  644. })->where('status',1)->where('is_deleted',0)->order($order)->limit($this->off_set,$this->page_num) ->where('release_time','< time',date('Y-m-d H:i:s'))->select()->toArray();
  645. array_walk($activity_list,function (&$v,$k){
  646. $v['label_name'] = $v['label']? explode(',',trim($v['label'],',')) : null;
  647. $v['ladder'] = $v['ladder'] ? json_decode($v['ladder'],true):null;
  648. });
  649. $activity_num = \app\common\model\Activity::when($search_name,function ($query)use ($search_name,$search_time){
  650. if($search_name) $query->where('title|label','like','%'.$search_name.'%');
  651. if($search_time) $query->where('create_at','> time',date('Y-m-d H:i:s',strtotime('-'.$search_time.' days')));
  652. })->where('status',1)->where('is_deleted',0) ->where('release_time','< time',date('Y-m-d H:i:s'))->count();
  653. if(!$type) {
  654. $total_count = $video_num+$article_num+$datum_num+$demand_num+$press_num+$goods_num+$supplier_goods_num + $activity_num + $forum_num+$recruit_num;
  655. }else{
  656. $total_count = compact($type.'_num')[$type.'_num'];
  657. }
  658. $this->success('ok',$type ? compact([$type.'_list','total_count']): compact(['video_list','article_list','datum_list','goods_list','press_list','supplier_goods_list','demand_list','recruit_list','forum_list','activity_list','total_count']));
  659. }
  660. /**
  661. * @title 发送短信验证码
  662. * @desc 发送短信验证码
  663. * @author qc
  664. * @url /api/Expedite/sendSms
  665. * @method POST
  666. * @tag 短信验证码
  667. * @param name:phone type:int require:1 default:-- desc:要获取验证码的手机号
  668. * @param name:phone_pre type:int require:1 default:86 desc:手机号前缀
  669. * @return name:code type:string default:-- desc:验证码
  670. */
  671. public function sendSms(){
  672. $phone_pre = input('post.phone_pre',86);
  673. $phone = input('post.phone');
  674. $user_info = User::where('phone',$phone)
  675. ->where('phone_pre',$phone_pre)
  676. ->where('is_deleted',0)
  677. ->field('id,status,is_deleted')->find();
  678. if($user_info && (!$user_info->status || $user_info->is_deleted))$this ->error('用户被禁用,请联系官方');
  679. if(empty($phone)) $this ->error('参数错误');
  680. $code = rand(0,9).rand(0,9).rand(0,9).rand(0,9).rand(0,9).rand(0,9);
  681. AlibabaCloud::accessKeyClient('LTAI5tJ5p12drZegeWVG33xZ', '82UWAiY5e5wH8tSkRvMtqVoGO0h8SB')->regionId('cn-hangzhou')->asDefaultClient();
  682. try {
  683. $result = AlibabaCloud::rpc()
  684. ->product('Dysmsapi')
  685. ->version('2017-05-25')
  686. ->action('SendSms')
  687. ->method('POST')
  688. ->host('dysmsapi.aliyuncs.com')
  689. ->options([
  690. 'query' => [
  691. 'RegionId' => "cn-hangzhou",
  692. 'PhoneNumbers' => $phone_pre == '86' ? $phone :$phone_pre.$phone,
  693. 'SignName' => "搞一下汽车电子",
  694. 'TemplateCode' => $phone_pre == '86' ? "SMS_234397351" :'SMS_269485496',
  695. 'TemplateParam' => json_encode(array("code"=>$code)),
  696. ],
  697. ])->request();
  698. $result = $result->toArray();
  699. if($result['Code'] != "OK") $this->exception('发送失败');
  700. $sms_data = [
  701. 'phone'=>$phone,
  702. 'code'=>$code,
  703. 'phone_pre'=>$phone_pre,
  704. 'result'=>$result['Message']
  705. ];
  706. Db::name('store_member_sms')->insert($sms_data);
  707. } catch (ClientException $e) {
  708. $this->error($e->getErrorMessage().PHP_EOL);
  709. } catch (ServerException $e) {
  710. $this->error($e->getErrorMessage().PHP_EOL);
  711. }catch (\Exception $e){
  712. $this->error($e->getMessage());
  713. }
  714. $this->success('发送成功');
  715. }
  716. /**
  717. * @title 发送邮箱验证码
  718. * @desc 发送邮箱验证码
  719. * @author qc
  720. * @url /api/Expedite/emailSms
  721. * @method POST
  722. * @tag 邮箱验证码
  723. * @param name:email type:int require:1 default:-- desc:邮箱
  724. * @return name:code type:string default:-- desc:验证码
  725. */
  726. function emailSms(){
  727. $email = input('post.email');
  728. $user_info = User::where('email',$email)->where('is_deleted',0)->field('id,status')->find();
  729. if($user_info && $user_info['status'] == 0)$this ->error('用户被禁用,请联系官方');
  730. $code = rand(0,9).rand(0,9).rand(0,9).rand(0,9).rand(0,9).rand(0,9);
  731. require_once env('root_path').'/vendor/aliyunmail/aliyun-php-sdk-core/Config.php';
  732. $iClientProfile = \DefaultProfile::getProfile("cn-hangzhou", "LTAI5tJ5p12drZegeWVG33xZ", "82UWAiY5e5wH8tSkRvMtqVoGO0h8SB");
  733. $client = new \DefaultAcsClient($iClientProfile);
  734. $request = new Dm\SingleSendMailRequest();
  735. $request->setAccountName("gyx@yzm.gyxqcdz.com");
  736. $request->setFromAlias("[验证码]");
  737. $request->setAddressType(1);
  738. $request->setTagName("zonghuzhuche");
  739. $request->setReplyToAddress("true");
  740. $request->setToAddress($email);
  741. $request->setSubject("验证码");
  742. $img= "http://gaoyixia.hdlkeji.com/code/33.png";
  743. $img ="<img src='$img'/>";
  744. $html_body = '您的验证码'.$code.'有效时间5分钟';
  745. $request->setHtmlBody($html_body);
  746. try {
  747. $send_res = $client->getAcsResponse($request);
  748. $sms_data = array(
  749. 'phone'=>$email,
  750. 'code'=>$code,
  751. 'result'=>'OK'
  752. );
  753. Db::name('store_member_sms')->insert($sms_data);
  754. $this->success('发送成功');
  755. } catch (ClientException $e) {
  756. $this->error($e->getErrorMessage());
  757. // print_r($e->getErrorCode());
  758. // print_r($e->getErrorMessage());
  759. } catch (ServerException $e) {
  760. $this->error($e->getErrorMessage());
  761. // print_r($e->getErrorCode());
  762. // print_r($e->getErrorMessage());
  763. }
  764. }
  765. /**
  766. * @title 获取签名
  767. * @desc 获取签名
  768. * @url /api/Expedite/getWeChatSign
  769. * @method POST
  770. * @param name:url type:string default:-- desc:页面地址
  771. * @return name:appid type:string default:-- desc:appid
  772. * @return name:noncestr type:string default:-- desc:随机字符
  773. * @return name:timestamp type:string default:-- desc:时间戳
  774. * @return name:sign type:string default:-- desc:签名
  775. * @return name:ticket type:string default:-- desc:ticket
  776. **/
  777. public function getWeChatSign(){
  778. $urls = input('post.url');
  779. $appid = config('app.official_account')['appid'];
  780. $secret = config('app.official_account')['secret'];
  781. $redis = new Redis();
  782. $access_token = $redis->get('access_token');
  783. if (!$access_token){
  784. $access_token = '';
  785. $url = "https://api.weixin.qq.com/cgi-bin/token?grant_type=client_credential&appid=$appid&secret=$secret";
  786. $res= http_curl($url);
  787. if (isset($res['access_token'])){
  788. $redis->set('access_token',$res['access_token'],'7000');
  789. $access_token = $res['access_token'];
  790. }
  791. }
  792. $url2 ="https://api.weixin.qq.com/cgi-bin/ticket/getticket?access_token=".$access_token."&type=jsapi";
  793. $res2=http_curl($url2);
  794. //var_dump($res2);
  795. if (!isset($res2) || $res2['errcode']!=0) $this->error('获取ticket失败');
  796. $timestamp = time();
  797. $noncestr = get32Str(15);
  798. $string = "jsapi_ticket=".$res2['ticket']."&noncestr=$noncestr&timestamp=$timestamp&url=".$urls;
  799. $sign = sha1($string);
  800. $return = [
  801. 'appid'=>$appid,
  802. 'noncestr'=>$noncestr,
  803. 'timestamp'=>$timestamp,
  804. 'url'=>$urls,
  805. 'sign'=>$sign,
  806. 'ticket'=>$res2['ticket']
  807. ];
  808. $this->success('成功',$return);
  809. }
  810. /**
  811. * @title 获取分享链接
  812. * @desc 获取分享链接
  813. * @url /api/Expedite/getUrlScheme
  814. * @method POST
  815. * @return name:url type:string default:-- desc:url
  816. **/
  817. public function getUrlScheme()
  818. {
  819. $appid = config('app.mini_program')['app_id'];
  820. $secret = config('app.mini_program')['secret'];
  821. $url = "https://api.weixin.qq.com/cgi-bin/token?grant_type=client_credential&appid=$appid&secret=$secret";
  822. $res= http_curl($url);
  823. $access_token = $res['access_token'];
  824. $api_url = 'https://api.weixin.qq.com/wxa/generatescheme?access_token='.$access_token;
  825. $url_scheme = curl_post($api_url,[]);
  826. $this->success('ok',['url'=>$url_scheme['openlink']]);
  827. }
  828. /**
  829. * @title getUrlLink
  830. * @desc getUrlLink
  831. * @url /api/Expedite/getUrlLink
  832. * @method POST
  833. * @return name:url type:string default:-- desc:url
  834. **/
  835. public function getUrlLink()
  836. {
  837. $appid = config('app.mini_program')['app_id'];
  838. $secret = config('app.mini_program')['secret'];
  839. $url = "https://api.weixin.qq.com/cgi-bin/token?grant_type=client_credential&appid=$appid&secret=$secret";
  840. $res= http_curl($url);
  841. $access_token = $res['access_token'];
  842. $api_url = 'https://api.weixin.qq.com/wxa/generate_urllink?access_token='.$access_token;
  843. $url_link = curl_post($api_url,[]);
  844. $this->success('ok',['url'=>$url_link['url_link']]);
  845. }
  846. /**
  847. * @title 获取平台文案设置
  848. * @desc 获取平台文案设置
  849. * @author qc
  850. * @url /api/Expedite/getSysConfig
  851. * @method GET
  852. * @param name:search_name type:string default:-- desc:根据下面名称查(不传查全部的)
  853. * @return name:agreement type:string default:-- desc:用户协议
  854. * @return name:about_us type:string default:-- desc:关于我们
  855. * @return name:privacy type:string default:-- desc:隐私政策
  856. * @return name:user_equity type:string default:-- desc:会员权益
  857. * @return name:customer_service type:string default:-- desc:客服设置
  858. * @return name:original_pact type:string default:-- desc:原创公约
  859. * @return name:app_name type:string default:-- desc:平台名称
  860. * @return name:app_logo type:string default:-- desc:平台logo
  861. * @return name:app_version type:string default:-- desc:版本号
  862. * @return name:trade_image type:string default:-- desc:营业执照
  863. * @return name:resources_image type:string default:-- desc:人力资源服务许可证
  864. */
  865. public function getSysConfig(){
  866. $search_name = input('get.search_name');
  867. $con_name = $search_name? [$search_name] : ['agreement','about_us','privacy','user_equity','customer_service','original_pact','app_version','trade_image','resources_image'];
  868. $set = Db::name('system_config')->where('name','in',$con_name)->select();
  869. $ret = [];
  870. foreach ($set as $value) {
  871. // if($search_name == 'resources_image'){
  872. // $value['value'] = explode('|',$value['value']);
  873. // }
  874. $ret[$value['name']]=$value['value'];
  875. }
  876. $this->success('获取成功',$ret);
  877. }
  878. /**
  879. * @title 修改版本信息【安卓】
  880. * @desc 修改版本信息
  881. * @author qc
  882. * @method POST
  883. * @url /api/Expedite/changeVersion
  884. * @header name:Authorization require:1 desc:Token
  885. * @param name:app_version type:string default:1 desc:版本号
  886. * @param name:version_name type:string default:-- desc:版本名
  887. * @param name:version_title type:string default:-- desc:更新标题
  888. * @param name:version_content type:string default:-- desc:更新内容
  889. * @param name:version_url type:string default:-- desc:下载地址
  890. * @param name:version_compel type:string default:-- desc:是否强制更新
  891. */
  892. public function changeVersion()
  893. {
  894. if(input('app_version'))Data::save('system_config',['value'=>input('app_version'),'name'=>'app_version'],'name',['name'=>'app_version']);
  895. if(input('version_name')) Data::save('system_config',['value'=>input('version_name'),'name'=>'version_name'],'name',['name'=>'version_name']);
  896. if(input('version_title')) Data::save('system_config',['value'=>input('version_title'),'name'=>'version_title'],'name',['name'=>'version_title']);
  897. if(input('version_content')) Data::save('system_config',['value'=>input('version_content'),'name'=>'version_content'],'name',['name'=>'version_content']);
  898. if(input('version_url')) Data::save('system_config',['value'=>input('version_url'),'name'=>'version_url'],'name',['name'=>'version_url']);
  899. Data::save('system_config',['value'=>input('version_compel'),'name'=>'version_compel'],'name',['name'=>'version_compel']);
  900. $this->success('修改成功');
  901. }
  902. /**
  903. * @title 获取版本信息【安卓】
  904. * @desc 获取版本信息
  905. * @author qc
  906. * @method GET
  907. * @url /api/Expedite/getVersionInfo
  908. * @header name:Authorization require:1 desc:Token
  909. * @return name:app_version type:string default:1 desc:版本号
  910. * @return name:version_name type:string default:-- desc:版本名
  911. * @return name:version_title type:string default:-- desc:更新标题
  912. * @return name:version_content type:string default:-- desc:更新内容
  913. * @return name:version_url type:string default:-- desc:下载地址
  914. * @return name:version_compel type:string default:-- desc:是否强制更新
  915. */
  916. public function getVersionInfo()
  917. {
  918. $version_sel = ['app_version','version_name','version_title','version_content','version_url','version_compel'];
  919. $set = Db::name('system_config')->where('name','in',$version_sel)->column('value','name');
  920. $ret = [];
  921. foreach ($version_sel as $v) {
  922. $ret[$v] = isset($set[$v]) ? $set[$v] :null;
  923. if($v == 'app_version') $ret[$v] = intval($set[$v]);
  924. }
  925. $this->success('获取成功',$ret);
  926. }
  927. /**
  928. * @title 修改版本信息【IOS】
  929. * @desc 修改版本信息
  930. * @author qc
  931. * @method POST
  932. * @url /api/Expedite/changeIosVersion
  933. * @header name:Authorization require:1 desc:Token
  934. * @param name:app_version_ios type:string default:1 desc:版本号
  935. * @param name:version_name_ios type:string default:-- desc:版本名
  936. * @param name:version_compel_ios type:string default:-- desc:是否强制更新
  937. */
  938. public function changeIosVersion()
  939. {
  940. if(input('app_version_ios'))Data::save('system_config',['value'=>input('app_version_ios'),'name'=>'app_version_ios'],'name',['name'=>'app_version_ios']);
  941. if(input('version_name_ios')) Data::save('system_config',['value'=>input('version_name_ios'),'name'=>'version_name_ios'],'name',['name'=>'version_name_ios']);
  942. Data::save('system_config',['value'=>input('version_compel_ios'),'name'=>'version_compel_ios'],'name',['name'=>'version_compel_ios']);
  943. $this->success('修改成功');
  944. }
  945. /**
  946. * @title 获取版本信息【IOS】
  947. * @desc 获取版本信息
  948. * @author qc
  949. * @method GET
  950. * @url /api/Expedite/getIosVersionInfo
  951. * @header name:Authorization require:1 desc:Token
  952. * @return name:app_version_ios type:string default:1 desc:版本号
  953. * @return name:version_name_ios type:string default:-- desc:版本名
  954. * @return name:version_compel_ios type:string default:-- desc:是否强制更新
  955. */
  956. public function getIosVersionInfo()
  957. {
  958. $version_sel = ['app_version_ios','version_name_ios','version_compel_ios'];
  959. $set = Db::name('system_config')->where('name','in',$version_sel)->column('value','name');
  960. $ret = [];
  961. foreach ($version_sel as $v) {
  962. $ret[$v] = isset($set[$v]) ? $set[$v] :null;
  963. // if($v == 'app_version_ios') $ret[$v] = intval($set[$v]);
  964. }
  965. $this->success('获取成功',$ret);
  966. }
  967. /**
  968. * @title 获取APP启动页信息
  969. * @desc 获取APP启动页信息
  970. * @author qc
  971. * @method GET
  972. * @url /api/Expedite/getAppBootConfig
  973. * @header name:Authorization require:1 desc:Token
  974. * @return name:app_image type:string default:1 desc:启动图
  975. * @return name:app_place type:string default:-- desc:跳转模块【video=>视频,article=>图文,datum=>资料,activity=>活动,demand=>需求,forum=>问答,press=>新闻,supplier=>供应商商品,recruit=>招聘,mall=>商城】
  976. * @return name:first_id type:int default:-- desc:详情id(视频、图文、资料为系列id)
  977. * @return name:second_id type:second_id default:-- desc:系列某详情id(视频、图文、资料)
  978. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  979. */
  980. public function getAppBootConfig()
  981. {
  982. $version_sel = ['app_image','app_place','first_id','second_id'];
  983. $set = Db::name('system_config')->where('name','in',$version_sel)->column('value','name');
  984. $ret = [];
  985. foreach ($version_sel as $v) {
  986. $ret[$v] = isset($set[$v]) ? $set[$v] :null;
  987. $set[$v] = $ret[$v];
  988. }
  989. $ret['is_normal'] = CheckPower::checkModulesPower($set['first_id'],$set['second_id'],$set['app_place']);
  990. $this->success('获取成功',$ret);
  991. }
  992. /**
  993. * @title IOS获取链接
  994. * @desc GET方式获取POST修改
  995. * @author qc
  996. * @method GET||POST
  997. * @url /api/Expedite/iosUrl
  998. * @header name:Authorization require:1 desc:Token
  999. * @param name:ios_url type:string default:-- desc:链接地址
  1000. * @return name:ios_url type:string default:-- desc:链接地址
  1001. */
  1002. public function iosUrl()
  1003. {
  1004. if($this->request->isPost()) Data::save('system_config',['value'=>input('ios_url'),'name'=>'ios_url'],'name',['name'=>'ios_url']);
  1005. $url = Db::name('system_config')->where('name','ios_url')->value('value');
  1006. $this->success('获取成功',['ios_url'=>$url ? $url :'']);
  1007. }
  1008. /**
  1009. * @title 获取客服设置【平台的】
  1010. * @desc 获取客服设置【平台的】
  1011. * @author qc
  1012. * @url /api/Expedite/getServiceSet
  1013. * @method GET
  1014. * @return name:service_qr_code type:string default:-- desc:客服二维码
  1015. * @return name:service_phone type:string default:-- desc:客服电话
  1016. * @return name:service_email type:string default:-- desc:客服邮箱
  1017. */
  1018. public function getServiceSet(){
  1019. $con_name = ['service_qr_code','service_phone','service_email'];
  1020. $set = Db::name('system_config')->where('name','in',$con_name)->select();
  1021. $ret = [];
  1022. foreach ($set as $value) {
  1023. $ret[$value['name']]=$value['value'];
  1024. }
  1025. $this->success('获取成功',$ret);
  1026. }
  1027. /**
  1028. * @title 获取联系客服设置【模块的】[所有模块的联系我们都用这个接口]
  1029. * @desc 获取联系客服设置
  1030. * @author qc
  1031. * @url /api/Expedite/getContact
  1032. * @method GET
  1033. * @param name:tag type:string default:-- desc:标识【video=>视频,article=>图文,datum=>资料,activity=>活动,demand=>需求,forum=>问答,press=>新闻,supplier=>供应商,recruit=>招聘,mall=>商城】
  1034. * @return name:qrcode type:string default:-- desc:客服二维码
  1035. * @return name:phone type:string default:-- desc:客服电话
  1036. * @return name:email type:string default:-- desc:客服邮箱
  1037. * @return name:place type:string default:-- desc:归属模块
  1038. * @return name:tag type:string default:-- desc:归属标识【可以按照这个值查询或是区分所属模块】
  1039. */
  1040. public function getContact()
  1041. {
  1042. $tag = input('get.tag');
  1043. $sel_tag = $tag ? [$tag] : ['video','article','datum','activity','demand','forum','press','supplier','recruit','mall'];
  1044. $list = Db::name('contact')->where('tag','in',$sel_tag)->column('tag,qrcode,phone,email,tag,place','tag');
  1045. $this->success('ok',$list);
  1046. }
  1047. /**
  1048. * @title 获取模块封面
  1049. * @desc 获取模块封面
  1050. * @author qc
  1051. * @url /api/Expedite/getModulesCover
  1052. * @method GET
  1053. * @param name:tag type:string default:-- desc:标识【video=>视频,article=>图文,datum=>资料,activity=>活动,demand=>需求,forum=>问答,press=>新闻,supplier=>供应商,recruit=>招聘,mall=>商城,'search'=>热搜】
  1054. * @return name:cover type:string default:-- desc:封面
  1055. * @return name:place type:string default:-- desc:归属模块
  1056. * @return name:tag type:string default:-- desc:归属标识【可以按照这个值查询或是区分所属模块】
  1057. */
  1058. public function getModulesCover()
  1059. {
  1060. $tag = input('get.tag');
  1061. $sel_tag = $tag ? [$tag] : ['video','article','datum','activity','demand','forum','press','supplier','recruit','mall','search'];
  1062. $list = Db::name('cover')->where('tag','in',$sel_tag)->column('tag,cover,tag,place','tag');
  1063. $this->success('ok',$list);
  1064. }
  1065. /**
  1066. * @title 推送测试
  1067. * @desc 推送测试
  1068. * @author qc
  1069. * @url /api/Expedite/messagePush
  1070. * @method GET
  1071. * @param name:user_id type:int default:-- desc:会员id
  1072. * @param name:content type:string default:-- desc:推送内容
  1073. * @param name:module type:string default:-- desc:模块
  1074. * @param name:type type:类型 default:-- desc:推送类型
  1075. * @param name:rel_id type:类型 default:-- desc:关联id
  1076. */
  1077. public function messagePush()
  1078. {
  1079. $user_id= input('user_id');
  1080. $content= input('content');
  1081. $module= input('module');
  1082. $type= input('type');
  1083. $rel_id= input('rel_id');
  1084. $res = UserMessage::Jpush($user_id,$content,$module,$type,$rel_id);
  1085. $this->success('',['result'=>$res]);
  1086. }
  1087. /**
  1088. * @title 获取分享地址
  1089. * @desc 获取分享地址
  1090. * @author qc
  1091. * @url /api/Expedite/getShareUrl
  1092. * @method GET
  1093. * @param name:tag type:string default:-- desc:标识【video=>视频,article=>图文,datum=>资料,activity=>活动,demand=>需求,forum=>问答,press=>新闻,supplier=>供应商商品,recruit=>招聘,mall=>商城商品】
  1094. * @param name:first_id type:int default:-- desc:【视频系列id,图文系列id,资料系列id,活动id,需求id,问答id,新闻id,供应商商品id,招聘记录id,商城商品id】
  1095. * @param name:second_id type:string default:-- desc:【视频url_id,图文item_id,资料item_id,其他类型的不传】
  1096. * @return name:url type:string default:-- desc:跳转地址
  1097. */
  1098. public function getShareUrl()
  1099. {
  1100. $tag = input('get.tag');
  1101. if(!in_array($tag, ['video','article','datum','activity','demand','forum','press','supplier','recruit','mall'])) $this->error('类型标识错误');
  1102. $first_id = input('get.first_id');
  1103. $second_id = input('get.second_id');
  1104. $url_arr= [
  1105. 'video' =>$this->request->root(true) ."/dist/#/video-details?id=$first_id&videoArrId=$second_id",
  1106. 'article' =>$this->request->root(true) ."/dist/#/image-text-details?id=$first_id&item_id=$second_id",
  1107. 'datum' =>$this->request->root(true) ."/dist/#/information-details?id=$first_id&url_id=$second_id",
  1108. 'activity' =>$this->request->root(true) ."/dist/#/activity-sign-up?activity_id=$first_id",
  1109. 'demand' =>$this->request->root(true) ."/dist/#/demand-details?demand_id=$first_id",
  1110. 'forum' =>$this->request->root(true) ."/dist/#/forum-question-details?forum_id=$first_id",
  1111. 'press' =>$this->request->root(true) ."/dist/#/news-details?press_id=$first_id",
  1112. 'supplier' =>$this->request->root(true) ."/dist/#/supplier-details?id=$first_id",
  1113. 'recruit' =>$this->request->root(true) ."/dist/#/recruit-details?recruit_id=$first_id",
  1114. 'mall' =>$this->request->root(true) ."/dist/#/product-details?product_id=$first_id",
  1115. ];
  1116. $this->success('ok',['url'=>$url_arr[$tag]]);
  1117. }
  1118. /**
  1119. * @title 获取极光推送类型
  1120. * @desc module'=>[type=>['title'=>'视频投稿','is_push'=>0,'msg'=>['视频投稿成功请等待审核']]]
  1121. * @author qc
  1122. * @url /api/Expedite/getJiGuangPushType
  1123. * @method GET
  1124. * @return name:is_push type:string default:-- desc:模块类型下的消息是否有极光推送(1推送0不推送)
  1125. * @return name:exp type:string default:-- desc:module'=>[type=>['title'=>'视频投稿','is_push'=>0,'msg'=>['视频投稿成功请等待审核']]]
  1126. *
  1127. */
  1128. public function getJiGuangPushType()
  1129. {
  1130. $type_desc = [
  1131. 'video'=>[
  1132. 3=>['title'=>'视频评论回复【回复我的】','is_push'=>1,'msg'=>['有会员评论了您的回复']],
  1133. 4=>['title'=>'视频评论【评论我的】','is_push'=>1,'msg'=>['有会员评论了您的视频']],
  1134. ],// 视频
  1135. 'article'=>[
  1136. 3=>['title'=>'图文评论回复【回复我的】','is_push'=>1,'msg'=>['有会员评论了您的回复']],
  1137. 4=>['title'=>'图文评论【评论我的】','is_push'=>1,'msg'=>['有会员评论了您的图文']],
  1138. ],//图文
  1139. 'forum'=>[
  1140. 3=>['title'=>'回复的评论【评论我的】','is_push'=>1,'msg'=>['有会员评论了您的回复']],
  1141. 4=>['title'=>'评论的回复【回复我的】','is_push'=>1,'msg'=>['有会员回复了您的评论']],
  1142. 5=>['title'=>'问答回复【回答我的】','is_push'=>1,'msg'=>['有会员回复了您的问题']],
  1143. ],// 问答
  1144. 'press'=>[
  1145. 1=>['title'=>'评论回复【回复我的】','is_push'=>1,'msg'=>['有会员回复了您的评论']],
  1146. ],// 新闻
  1147. 'feedback'=>[
  1148. 1=>['title'=>'反馈内容回复','is_push'=>1,'msg'=>['平台回复了您的反馈']],
  1149. ],// 反馈
  1150. ];
  1151. $this->success('ok',$type_desc);
  1152. }
  1153. /**
  1154. * @title 获取模块总角标数量
  1155. * @desc 获取模块总角标数量
  1156. * @author qc
  1157. * @method GET
  1158. * @url /api/Expedite/getTotalMarkNum
  1159. * @header name:Authorization require:1 desc:Token
  1160. * @return name:video_num type:int default:-- desc:视频
  1161. * @return name:article_num type:int default:-- desc:图文
  1162. * @return name:press_num type:int default:-- desc:新闻
  1163. * @return name:demand_num type:int default:-- desc:需求
  1164. * @return name:forum_num type:int default:-- desc:问答
  1165. * @return name:sys_num type:int default:-- desc:系统消息
  1166. * @return name:datum_num type:int default:-- desc:资料
  1167. * @return name:supplier_num type:int default:-- desc:供应商
  1168. * @return name:activity_num type:int default:-- desc:活动
  1169. * @return name:mark_num type:int default:-- desc:商品
  1170. * @return name:recruit_num type:int default:-- desc:招聘
  1171. * @return name:total_num type:int default:-- desc:总计
  1172. */
  1173. public function getTotalMarkNum()
  1174. {
  1175. if(!$this->user_id) $this->success('ok',['video_num'=>0,'article_num'=>0,'press_num'=>0,'demand_num'=>0,'forum_num'=>0,'sys_num'=>0,'datum_num'=>0,'total_num'=>0]);
  1176. $video_all_comment = VideoComment::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
  1177. // 回复我的
  1178. $video_reply_num = VideoComment::where([['t.is_deleted','=',0],['t.to_deleted','=',0],['t.user_id','<>',$this->user_id],['t.lev','>=',2],['is_read','=',0],['t.pid','in',implode(',',$video_all_comment)]])->alias('t')->count();
  1179. // 评论我的
  1180. $video_comment_num = VideoComment::where([['t.is_deleted','=',0],['i.user_id','=',$this->user_id],['t.user_id','<>',$this->user_id],['t.is_read','=',0],['t.pid','=',0]])
  1181. ->leftJoin('VideoUrl i','t.url_id = i.id')
  1182. ->alias('t')->count();
  1183. // 追更
  1184. $video_follow_num = UserMessage::getUnreadNum($this->user_id,'video',5);
  1185. // 点赞我的
  1186. $all_video = VideoUrl::where('user_id',$this->user_id)->where('is_deleted',0)->column('id');
  1187. $video_praise_num = 0;//VideoCommentLike::where([['type','=',2],['is_read','=',0],['like_id','in',$all_video]])->count();
  1188. $comment_praise_num = 0 ;// VideoCommentLike::where([['type','=',1],['is_read','=',0],['like_id','in',$video_all_comment]])->count();
  1189. $video_num = $video_reply_num + $video_comment_num + $video_follow_num + $video_praise_num + $comment_praise_num;
  1190. // 回复我的
  1191. $article_all_comment = ArticleComment::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
  1192. $article_reply_num = ArticleComment::where([['t.is_deleted','=',0],['t.to_deleted','=',0],['t.user_id','<>',$this->user_id],['t.lev','>=',2],['is_read','=',0],['t.pid','in',implode(',',$article_all_comment)]])->alias('t')->count();
  1193. // 评论我的
  1194. $article_comment_num = ArticleComment::where([['t.is_deleted','=',0],['i.user_id','=',$this->user_id],['t.user_id','<>',$this->user_id],['t.is_read','=',0],['t.pid','=',0]])
  1195. ->leftJoin('ArticleItem i','t.item_id = i.id')
  1196. ->alias('t')->count();
  1197. // 追更
  1198. $article_follow_num = UserMessage::getUnreadNum($this->user_id,'article',5);
  1199. // 点赞我的
  1200. $all_article = ArticleItem::where('user_id',$this->user_id)->where('is_deleted',0)->column('id');
  1201. $article_praise_num = 0;//ArticleCommentLike::where([['is_read','=',0],['like_id','in',$all_article]])->count();
  1202. $comment_praise_num = 0;//ArticleLike::where([['is_read','=',0],['item_id','in',$article_all_comment]])->count();
  1203. $article_num = $article_reply_num + $article_comment_num + $article_follow_num + $article_praise_num + $comment_praise_num;
  1204. // 评论我的
  1205. $datum_comment_num = DatumComment::where([['t.is_deleted','=',0],['i.user_id','=',$this->user_id],['t.user_id','<>',$this->user_id],['is_read','=',0],['t.pid','=',0]])
  1206. ->leftJoin('DatumUrl i','t.url_id = i.id')
  1207. ->alias('t')->count();
  1208. // 回复我的
  1209. $datum_all_comment = DatumComment::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
  1210. $datum_reply_num = $datum_all_comment ? DatumComment::where([['t.is_deleted','=',0],['t.to_deleted','=',0],['t.user_id','<>',$this->user_id],['t.lev','>=',2],['is_read','=',0],['t.pid','in',implode(',',$datum_all_comment)]])->alias('t')->count() : 0;
  1211. // 点赞我的
  1212. $all_datum = DatumUrl::where('user_id',$this->user_id)->where('is_deleted',0)->column('id');
  1213. $datum_praise_num = DatumCommentLike::where([['is_read','=',0],['like_id','in',$datum_all_comment],['user_id','<>',$this->user_id]])->count();
  1214. $comment_praise_num = DatumLike::where([['is_read','=',0],['url_id','in',$all_datum],['user_id','<>',$this->user_id]])->count();
  1215. $praise_num = $datum_praise_num + $comment_praise_num;
  1216. $follow_num = UserMessage::getUnreadNum($this->user_id,'datum',5);
  1217. $datum_num =$datum_comment_num + $datum_reply_num +$datum_praise_num + $comment_praise_num +$follow_num;
  1218. // 回复我的
  1219. $press_all_comment = PressComment::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
  1220. $press_reply_num = PressComment::where([['t.is_deleted','=',0],['t.lev','>=',2],['t.user_id','<>',$this->user_id],['is_read','=',0],['t.pid','in',implode(',',$press_all_comment)]])->alias('t')->count();
  1221. // 评论我的
  1222. $press_comment_num = PressComment::where([['t.is_deleted','=',0],['t.pid','=',0],['i.user_id','=',$this->user_id],['t.is_read','=',0],['t.user_id','<>',$this->user_id]])
  1223. ->leftJoin('Press i','t.first_id = i.id')
  1224. ->alias('t')->count();
  1225. $press_num = $press_reply_num + $press_comment_num;
  1226. $demand_num = DemandComment::where([['t.is_deleted','=',0],['i.user_id','=',$this->user_id],['t.is_read','=',0],['t.user_id','<>',$this->user_id],['t.pid','=',0]])
  1227. ->leftJoin('PlatformDemand i','t.first_id = i.id')
  1228. ->alias('t')->count();
  1229. $all_comment = DemandComment::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
  1230. $reply_num = DemandComment::where([['t.is_deleted','=',0],['t.lev','>=',2],['is_read','=',0],['t.pid','in',implode(',',$all_comment)]])->alias('t')->count();
  1231. $demand_num = $demand_num + $reply_num;
  1232. //问答模块
  1233. //回答我的
  1234. // $answer_num = ForumReply::where([['r.issue_user','=',$this->user_id],['r.is_deleted','=',0],['r.is_read','=',0]])
  1235. // ->alias('r')->leftJoin('user_forum a','r.forum_id = a.id')->count();
  1236. $answer_num = ForumReply::where([['r.issue_user', '=', $this->user_id], ['r.is_deleted', '=', 0], ['r.is_read', '=', 0]])
  1237. ->alias('r')->leftJoin('user_forum f', 'r.forum_id = f.id')->count();
  1238. // 回复我的
  1239. // $forum_all_comment = ForumReplyComment::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
  1240. // $forum_reply_num = ForumReplyComment::where([['t.is_deleted','=',0],['t.user_id', '<>', $this->user_id],['t.is_read','=',0],['t.pid','in',implode(',',$forum_all_comment)]])->alias('t')->count();
  1241. // 回复我的
  1242. $forum_all_comment = ForumReplyComment::where(['user_id' => $this->user_id, 'is_deleted' => 0])->column('id');
  1243. if(count($forum_all_comment) < 1){
  1244. $forum_reply_num = 0;
  1245. $reply_answer = 0;
  1246. }else{
  1247. $forum_reply_num = ForumReplyComment::where([['t.is_deleted', '=', 0], ['t.user_id', '<>', $this->user_id], ['t.reply_id', '=', 0], ['t.is_read', '=', 0], ['t.pid', 'in', implode(',', $forum_all_comment)]])->alias('t')->count();
  1248. $reply_answer = ForumReplyComment::where([['t.is_deleted', '=', 0], ['t.user_id', '<>', $this->user_id], ['t.reply_id', '>', 0], ['t.is_read', '=', 0], ['t.pid', 'in', implode(',', $forum_all_comment)]])->alias('t')->count();
  1249. }
  1250. $forum_reply_num = $forum_reply_num +$reply_answer;
  1251. // 评论我的问题
  1252. $forum_comment = ForumReplyComment::alias('c')
  1253. ->where(['r.user_id' => $this->user_id, 'r.is_deleted' => 0, 'c.is_read' => 0,'c.reply_id'=>0,'c.pid'=>0,'c.to_deleted'=>0])
  1254. ->where('c.user_id','<>',$this->user_id)
  1255. ->leftJoin('UserForum r', 'c.forum_id = r.id')
  1256. ->count();
  1257. // 评论我的回答
  1258. $reply_comment = ForumReplyComment::alias('c')
  1259. ->where(['r.user_id' => $this->user_id, 'r.is_deleted' => 0, 'c.is_read' => 0,'c.pid'=>0,])
  1260. ->leftJoin('forum_reply r', 'c.reply_id = r.id')
  1261. ->count();
  1262. $forum_follow_num = UserMessage::getUnreadNum($this->user_id,'forum',6);
  1263. $forum_num = $answer_num+$forum_reply_num+$forum_comment+$reply_comment+ $forum_follow_num;
  1264. //问答模块end
  1265. $sys_num = 0;//UserMessage::where(['user_id'=>$this->user_id,'is_deleted'=>0])->where('is_read',0)->count();
  1266. // 供应商
  1267. $supplier_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]])
  1268. ->alias('c') ->leftJoin('SupplierGoods g', 'g.id = c.goods_id')->count();
  1269. //回复我的
  1270. $supplier_all_comment = SupplierComment::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
  1271. $supplier_reply_num = $supplier_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(',',$supplier_all_comment)]])->alias('t')->count() :0;
  1272. //订阅
  1273. $supplier_follow_num = UserMessage::getUnreadNum($this->user_id,'supplier',5);
  1274. $supplier_num = $supplier_comment_num + $supplier_reply_num + $supplier_follow_num;
  1275. // 活动
  1276. $activity_num = UserMessage::where(['m.user_id'=>$this->user_id,'m.is_deleted'=>0,'is_read'=>0])->where('m.module','in','activity,apply')->alias('m')->count();
  1277. // 商品
  1278. $trolley_num = ShoppingTrolley::where(['user_id'=>$this->user_id])->sum('num');
  1279. $no_pay_num = GoodsOrder::where(['user_id'=>$this->user_id,'is_deleted'=>0,'pay_state'=>0,'cancel_state'=>0,'status'=>0])->count();
  1280. $no_express_num = GoodsOrder::where(['user_id'=>$this->user_id,'is_deleted'=>0,'pay_state'=>1,'express_state'=>0,'cancel_state'=>0])
  1281. ->where('status',1)
  1282. ->where('refund_state','in','0')
  1283. ->count();
  1284. $express_num = GoodsOrder::where(['user_id'=>$this->user_id,'is_deleted'=>0,'pay_state'=>1,'express_state'=>1,'cancel_state'=>0])
  1285. ->where('refund_state','in','0,1,2')
  1286. ->count();
  1287. // $finish_num = GoodsOrder::where(['user_id'=>$this->user_id,'is_deleted'=>0,'pay_state'=>1,'express_state'=>2,'cancel_state'=>0])
  1288. // ->where('refund_state','in','0,1,2')
  1289. // ->count();
  1290. $finish_num = 0;
  1291. $refund_num = GoodsOrder::where(['o.user_id'=>$this->user_id,'o.is_deleted'=>0,'o.pay_state'=>1,'o.cancel_state'=>0])->alias('o')
  1292. ->leftJoin('StoreOrderRefund r','r.order_id = o.id')
  1293. ->where('o.refund_state','in','1,2,3')
  1294. ->where('r.status','in','0,1,2,4')
  1295. ->count();
  1296. $mark_num = $trolley_num + $no_pay_num + $no_express_num + $express_num + $finish_num + $finish_num + $refund_num;
  1297. //招聘
  1298. $praise_num = PlatformLike::where([['p.type', '=', 5],['f.user_id', '=', $this->user_id],['p.to_deleted', '=', 0],['p.is_read','=',0]])->alias('p') ->leftJoin('Recruit f', 'f.id = p.like_id')->count();
  1299. // $follow_num = UserMessage::where(['m.user_id'=>$this->user_id,'m.is_deleted'=>0,'m.module'=>'recruit','m.type_id'=>5,'is_read'=>0])->alias('m')->count();
  1300. $follow_num = UserMessage::where(['m.user_id'=>$this->user_id,'m.is_deleted'=>0,'m.module'=>'recruit','is_read'=>0])->where('m.type_id','in','4,5')->alias('m')->count();
  1301. $recruits = \app\common\model\Recruit::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
  1302. $resume_num = RecruitResume::where('recruit_id','in',$recruits)->where('is_deleted',0)->where('to_deleted',0)->where('is_read',0)->count();
  1303. $recruit_num = $praise_num + $follow_num + $resume_num;
  1304. $total_num = $video_num + $article_num + $datum_num + $press_num + $demand_num + $forum_num + $supplier_num + $activity_num + $mark_num + $recruit_num;
  1305. $this->success('ok',compact(['video_num','article_num','press_num','demand_num','forum_num','sys_num','datum_num','activity_num','supplier_num','mark_num','recruit_num','total_num']));
  1306. }
  1307. /**
  1308. * @title 以下接口为二期需求
  1309. * @desc 以下接口为二期需求
  1310. * @author qc
  1311. * @url /api/Expedite/secondPhase
  1312. * @method
  1313. * @return name:1 type:string default:-- desc:以下接口为二期需求
  1314. */
  1315. public function secondPhase(){}
  1316. /**
  1317. * @title 获取平台页面链接
  1318. * @desc 参数自定义!参数自定义!!参数自定义!!!
  1319. * @author qc
  1320. * @url /api/Expedite/getPlatformUrl
  1321. * @method GET
  1322. * @param name:module type:string default:-- desc:模块【video=>视频,article=>图文,datum=>资料,activity=>活动,demand=>需求,forum=>问答,press=>新闻,supplier=>供应商商品,recruit=>招聘,mall=>商城商品】
  1323. * @param name:tag type:string default:-- desc:页面标识【detail=>详情,list=>列表】
  1324. * @param name:from type:string default:-- desc:请求接口来源1:h5,2:ios,3:android
  1325. * @return name:url type:array default:-- desc:链接
  1326. * @return name:desc type:string default:-- desc:页面描述
  1327. * @return name:param type:string default:-- desc:页面参数拼接
  1328. */
  1329. public function getPlatformUrl()
  1330. {
  1331. $request_param = input('get.');
  1332. $module = input('module','activity');
  1333. $tag = input('tag','detail');
  1334. unset($request_param[$module]);
  1335. unset($request_param[$tag]);
  1336. $url = config('platform_url.'.$module)[$tag];
  1337. $this->success('ok',['url'=>$url,'params'=>http_build_query($request_param)]);
  1338. }
  1339. /**
  1340. * @title 获取手机号前缀
  1341. * @desc 获取手机号前缀
  1342. * @author qc
  1343. * @method GET
  1344. * @url /api/Expedite/getPhonePrefix
  1345. * @header name:Authorization require:1 desc:Token
  1346. * @return name:name type:string default:-- desc:名称
  1347. * @return name:code type:string default:-- desc:前缀
  1348. */
  1349. public function getPhonePrefix()
  1350. {
  1351. /*$prefix = [
  1352. ['name' => '中国大陆','code'=>'86'],
  1353. ['name' => '中国香港','code'=>'852'],
  1354. ['name' => '中国澳门','code'=>'853'],
  1355. ['name' => '中国台湾','code'=>'886'],
  1356. ['name' => '韩国','code'=>'82'],
  1357. ['name' => '日本','code'=>'81'],
  1358. ['name' => '美国','code'=>'1'],
  1359. ['name' => '加拿大','code'=>'1'],
  1360. ['name' => '新加坡','code'=>'65'],
  1361. ['name' => '马来西亚','code'=>'62'],
  1362. ['name' => '俄罗斯','code'=>'7'],
  1363. ['name' => '新西兰','code'=>'64'],
  1364. ['name' => '法国','code'=>'33'],
  1365. ['name' => '德国','code'=>'49'],
  1366. ];*/
  1367. $prefix = Db::name('phone_pre')->field('name,code')->where('is_deleted',0)->select();
  1368. $this->success('ok',$prefix);
  1369. }
  1370. /**
  1371. * @title ElasticSearch【登录状态需要header需要传Authorization】
  1372. * @desc ElasticSearch返回参数文档:https://www.elastic.co/guide/en/elasticsearch/reference/master/search-search.html
  1373. * @author qc
  1374. * @url /api/Expedite/ElasticSearch
  1375. * @method GET
  1376. * @param name:page type:int default:-- desc:页数
  1377. * @param name:page_num type:int default:-- desc:每页数量
  1378. * @param name:search type:string default:-- desc:搜索关键词
  1379. * @param name:sort_type type:int default:1 desc:1默认2发布时间正序3发布时间倒序
  1380. * @param name:is_over type:int default:-1 desc:-1全部0未解决1已解决2开源【需求模块用】
  1381. * @param name:city type:string default:-- desc:城市搜索【招聘模块用】
  1382. * @param name:module type:string default:-- desc:搜索类型(不传查全部)[video=>视频,article=>图文,datum=>资料,goods=>商城商品,press=>新闻,supplier_goods=>供应商商品,demand=>需求,recruit=>招聘,forum=>问答,activity=>活动]
  1383. * @return name:highlight type:array default:-- desc:高亮【目前设置三个字段:title、label、desc】
  1384. *
  1385. * @return name:module type:string default:-- desc:模块名
  1386. * @return name:release_time type:string default:-- desc:上架时间
  1387. * @return name:series_id type:int default:-- desc:系列id【视频、图文、资料用】
  1388. * @return name:id type:int default:-- desc:某个模块的详情id【不是系列id】
  1389. * @return name:title type:string default:-- desc:标题或名称
  1390. * @return name:label type:string default:-- desc:标签
  1391. * @return name:label_arr type:array default:-- desc:标签【数组】
  1392. * @return name:desc type:string default:-- desc:描述
  1393. * @return name:desc_text type:string default:-- desc:描述文本【搜索用的,页面展示忽略】
  1394. * @return name:content type:string default:-- desc:内容【富文本】
  1395. * @return name:detail type:string default:-- desc:详情【富文本】
  1396. * @return name:create_at type:string default:-- desc:时间
  1397. * @return name:app_name type:string default:-- desc:发布者
  1398. * @return name:app_logo type:string default:-- desc:发布者头像
  1399. * @return name:read_num type:int default:-- desc:阅读量||播放量【若模块用不到忽略】
  1400. * @return name:comment_num type:int default:-- desc:评论量【若模块用不到忽略】
  1401. * @return name:like_num type:int default:-- desc:点赞量【若模块用不到忽略】
  1402. * @return name:transmit_num type:int default:-- desc:转发量【若模块用不到忽略】
  1403. * @return name:collect_num type:int default:-- desc:收藏量【若模块用不到忽略】
  1404. * @return name:down_num type:int default:-- desc:下载量【若模块用不到忽略】
  1405. * @return name:cover type:string default:-- desc:封面【单张】
  1406. * @return name:is_vip type:int default:-- desc:是否是vip
  1407. *
  1408. * @return name:duration type:string default:-- desc:时长【视频模块】
  1409. * @return name:ali_vid type:int default:-- desc:云点播ID【视频模块】
  1410. *
  1411. * @return name:images_arr type:array default:-- desc:图片【图文】
  1412. * @return name:content_type type:int default:1 desc:1富文本2pdf【图文】
  1413. * @return name:content type:string default:-- desc:内容富文本【图文】
  1414. *
  1415. * @return name:url type:string default:-- desc:资料路径【资料】
  1416. * @return name:is_down type:int default:-- desc:是否允许下载【资料】
  1417. *
  1418. * @return name:browse_num type:string default:-- desc:浏览量【问答】
  1419. * @return name:reply_num type:string default:-- desc:回答量【问答】
  1420. * @return name:level type:string default:-- desc:vip等级id【问答】
  1421. *
  1422. * @return name:start_time type:string default:-- desc:开始时间【活动】
  1423. * @return name:end_time type:string default:-- desc:结束时间【活动】
  1424. *
  1425. * @return name:is_over type:int default:-- desc:0未解决1已解决2开源【需求模块用】
  1426. * @return name:money type:string default:-- desc:金额【需求模块用】
  1427. *
  1428. * @return name:company type:string default:-- desc:公司名称【招聘】
  1429. * @return name:company_intro type:string default:-- desc:公司简介【招聘】
  1430. * @return name:is_ss type:string default:-- desc:是否上市,1上市【招聘】
  1431. * @return name:scale type:string default:-- desc:公司规模(人数)【招聘】
  1432. * @return name:principal type:string default:-- desc:联系人【招聘】
  1433. * @return name:province type:string default:-- desc:省【招聘】
  1434. * @return name:city type:string default:-- desc:市【招聘】
  1435. * @return name:salary type:string default:-- desc:薪资【招聘】
  1436. * @return name:hr_headimg type:string default:-- desc:联系人头像【招聘】
  1437. *
  1438. *
  1439. * @return name:item_list type:array default:-- desc:商品规格详情【商城商品】
  1440. * @return name:min_price type:float default:-- desc:最低价格【商城商品】
  1441. * @return name:max_price type:float default:-- desc:最高价格【商城商品】
  1442. * @return name:sale_num type:int default:-- desc:销量【商城商品】
  1443. *
  1444. */
  1445. public function elasticSearch()
  1446. {
  1447. $index = input('index',config('text.es_index'));
  1448. $search = input('search','');
  1449. $module = input('module','');
  1450. $is_over = intval(input('is_over',-1));
  1451. $sort_type = input('sort_type',1);
  1452. $city = input('city');
  1453. //"全部",1=>'视频',2=>'资料',3=>'图文',4=>'新闻',5=>'问答',6=>'商品',7=>'活动',8=>'招聘',9=>'供应商',10=>'供应商商品',11=>'需求'
  1454. // video=>视频,article=>图文,datum=>资料,goods=>商城商品,press=>新闻,supplier_goods=>供应商商品,demand=>需求,recruit=>招聘,forum=>问答,activity=>活动]
  1455. $search_type = [
  1456. 'video'=>"1",
  1457. 'datum'=>"2",
  1458. 'article'=>"3",
  1459. 'press'=>"4",
  1460. 'forum'=>"5",
  1461. 'goods'=>"6",
  1462. 'activity'=>"7",
  1463. 'recruit'=>"8",
  1464. 'supplier'=>"9",
  1465. 'supplier_goods'=>"10",
  1466. 'demand'=>"11",
  1467. ];
  1468. if($search && $this->user_id) UserSearch::saveSearchTitle($this->user_id,$search,isset($search_type[$module]) ?$search_type[$module] :0 );
  1469. switch ($sort_type) {
  1470. case 1:
  1471. $order = $module ? [['_score'=>['order'=>'desc']],['id'=>['order'=>'desc']]] : [['_score'=>['order'=>'desc']], ['create_at'=>['order'=>'desc']]];
  1472. break;
  1473. case 2:
  1474. // $order = $module ? [['id'=>['order'=>'asc']]] : ['create_at'=>['order'=>'asc']];
  1475. $order = $module ? ['create_at'=>['order'=>'asc']] : ['create_at'=>['order'=>'asc']];
  1476. break;
  1477. case 3:
  1478. // $order = $module ? [['id'=>['order'=>'desc']]] : ['create_at'=>['order'=>'desc']];
  1479. $order = $module ? ['create_at'=>['order'=>'desc']] : ['create_at'=>['order'=>'desc']];
  1480. break;
  1481. }
  1482. $user_level = UserLevelRank::getUserVip($this->user_id);
  1483. $sel_level = $user_level ? $user_level : 1;
  1484. $where = [
  1485. 'index'=>$index,
  1486. 'from' => $this->off_set,
  1487. 'size' => $this->page_num,
  1488. 'body'=>[
  1489. 'sort' => $order,
  1490. 'query'=>[
  1491. 'bool'=>[
  1492. 'must'=> [
  1493. // ['match' => ['module'=> $module]],// module = module
  1494. ['match' => ['status'=>1]], // status !=0
  1495. ['match' => ['is_deleted'=> 0]],// is_deleted !=1
  1496. ['range' => ['release_time'=> ['lte'=>time()]]],//
  1497. // ['range' => ['level'=> ['lte'=>$sel_level]]],//
  1498. /* ['bool'=>[
  1499. 'should'=> [
  1500. 'multi_match' => [
  1501. 'fields'=> ['title','label','desc','content','detail'],
  1502. 'query'=> $search,
  1503. "fuzziness"=>"AUTO",
  1504. 'type'=> 'best_fields',
  1505. ]],
  1506. ]]*/
  1507. ],
  1508. ],
  1509. ],
  1510. 'highlight'=>[
  1511. "fields"=>[
  1512. 'title'=>[
  1513. 'pre_tags'=>["<span style='color:#FF6700'>"],
  1514. 'post_tags'=>["</span>"]
  1515. ],
  1516. 'label'=>[
  1517. 'pre_tags'=>["<span style='color:#FF6700'>"],
  1518. 'post_tags'=>["</span>"]
  1519. ],
  1520. 'desc'=>[
  1521. 'pre_tags'=>["<span style='color:#FF6700'>"],
  1522. 'post_tags'=>["</span>"]
  1523. ],
  1524. 'content'=>[
  1525. 'pre_tags'=>["<span style='color:#FF6700'>"],
  1526. 'post_tags'=>["</span>"]
  1527. ],
  1528. 'detail'=>[
  1529. 'pre_tags'=>["<span style='color:#FF6700'>"],
  1530. 'post_tags'=>["</span>"]
  1531. ],
  1532. 'desc_text'=>[
  1533. 'pre_tags'=>["<span style='color:#FF6700'>"],
  1534. 'post_tags'=>["</span>"]
  1535. ],
  1536. ]
  1537. ]
  1538. ]
  1539. ];
  1540. if($module) $where['body']['query']['bool']['must'][] = ['match' =>['module'=> $module]];
  1541. if($module == 'demand' && $is_over != -1 ) $where['body']['query']['bool']['must'][] = ['match' =>['is_over'=> $is_over]];
  1542. if($module == 'recruit' && $city ) $where['body']['query']['bool']['must'][] = ['match' =>['city'=> $city]];
  1543. if($search) $where['body']['query']['bool']['must'][] = ['bool' =>[
  1544. 'should'=> [
  1545. 'multi_match' => [
  1546. 'fields'=> ['title','label','desc','content','detail'],
  1547. 'query'=> $search,
  1548. "fuzziness"=>"AUTO",
  1549. 'type'=> 'best_fields',
  1550. ]]]];
  1551. // if($search) $where['body']['query']['bool']['must'][] = [
  1552. // 'bool' =>[
  1553. // 'should'=> [
  1554. // 'match_phrase'=>[
  1555. // 'title' => [
  1556. // 'query' => $search,
  1557. // 'slop' => 1
  1558. // ],
  1559. // ],
  1560. //
  1561. // ]
  1562. // ]
  1563. // ];
  1564. // return json($where);
  1565. $list = Elastic::select($index,$where);
  1566. $w_list = [];
  1567. $speak_list= $list['hits']['hits'];
  1568. foreach ($list['hits']['hits'] as $k => &$v)
  1569. {
  1570. $v['_source']['label_arr'] = $v['_source']['label'] ? explode(',',$v['_source']['label']):null;
  1571. $v['_source']['create_at'] = date("Y-m-d",$v['_source']['create_at']);
  1572. $v['_source']['release_time'] = date("Y-m-d",$v['_source']['release_time']);
  1573. $v['_source']['is_over'] = isset($v['_source']['is_over']) ? intval($v['_source']['is_over']) : 0;
  1574. switch ($v['_source']['module']) {
  1575. case "video":
  1576. $info = VideoUrl::field('is_vip,cover,duration,ali_vid,read_num,video_id')->where('id',$v['_source']['id'])->find()->toArray();
  1577. $url = VideoIntro::where('id',$info['video_id'])->find();
  1578. // $v = $url;
  1579. // unset($list['hits']['hits'][$k]);
  1580. if($url == null){
  1581. unset($list['hits']['hits'][$k]);
  1582. }else{
  1583. if($url['status'] == 1 && $url['is_deleted'] == 0){
  1584. $v['_source']['series_id'] = $info['video_id'];
  1585. $v['_source']['cover'] = $info['cover'];
  1586. $v['_source']['is_vip'] = $info['is_vip'];
  1587. $v['_source']['duration'] = $info['duration'];
  1588. $v['_source']['ali_vid'] = $info['ali_vid'];
  1589. $v['_source']['read_num'] = numTransform($info['read_num']);
  1590. $info_auth = VideoUrl::getVideoAuth($v['_source']['user_id'],APPNAME,APPLOGO);
  1591. $v['_source']['app_name'] = $info_auth['app_name'];
  1592. $v['_source']['app_logo'] = $info_auth['app_logo'];
  1593. $w_list[] = $v;
  1594. }
  1595. }
  1596. break;
  1597. case "article":
  1598. // var_dump($v['_source']['id']);
  1599. // var_dump($v);
  1600. $info = ArticleItem::field('images,is_vip,cover,read_num,article_id,pdf,content_type')
  1601. ->where('id',$v['_source']['id'])->find();
  1602. $info = $info->toArray();
  1603. $v['_source']['series_id'] = $info['article_id'];
  1604. $v['_source']['cover'] = $info['cover'];
  1605. $v['_source']['is_vip'] = $info['is_vip'];
  1606. $v['_source']['pdf'] = $info['pdf'];
  1607. $v['_source']['content_type'] = $info['content_type'];
  1608. $v['_source']['read_num'] = numTransform($info['read_num']);
  1609. $v['_source']['images_arr'] = $info['images']?explode('|',$info['images']):null;
  1610. $info_auth = ArticleItem::getArticleAuth($v['_source']['user_id'],APPNAME,APPLOGO);
  1611. $v['_source']['app_name'] = $info_auth['app_name'];
  1612. $v['_source']['app_logo'] = $info_auth['app_logo'];
  1613. unset($v['_source']['content']);
  1614. $w_list[] = $v;
  1615. break;
  1616. case "datum":
  1617. $info = DatumUrl::field('is_vip,read_num,down_num,url,is_down,datum_id')->where('id',$v['_source']['id'])->find()->toArray();
  1618. $v['_source']['series_id'] = $info['datum_id'];
  1619. $v['_source']['is_vip'] = $info['is_vip'];
  1620. $v['_source']['read_num'] = numTransform($info['read_num']);
  1621. $v['_source']['down_num'] = numTransform($info['down_num']);
  1622. $v['_source']['url'] = $info['url'];
  1623. $v['_source']['is_down'] = $info['is_down'];
  1624. $info_auth = DatumUrl::getDatumAuth($v['_source']['user_id'],APPNAME,APPLOGO);
  1625. $v['_source']['app_name'] = $info_auth['app_name'];
  1626. $v['_source']['app_logo'] = $info_auth['app_logo'];
  1627. $w_list[] = $v;
  1628. break;
  1629. case 'forum':
  1630. $info_auth = UserForum::getAuthInfo($v['_source']['user_id'],APPNAME,APPLOGO);
  1631. $v['_source']['app_name'] = $info_auth['app_name'];
  1632. $v['_source']['app_logo'] = $info_auth['app_logo'];
  1633. $reply_num = ForumReply::where('forum_id', $v['_source']['id'])->where('is_deleted', 0)->count();
  1634. $v['_source']['reply_num'] = numTransform( $reply_num);
  1635. $forum_info = UserForum::where('id',$v['_source']['id'])->find()->toArray();
  1636. $v['_source']['browse_num'] = numTransform( $forum_info['browse_num']);
  1637. $w_list[] = $v;
  1638. break;
  1639. case 'activity':
  1640. $auth_info = \app\common\model\Activity::getAuth($v['_source']['user_id'],APPNAME,APPLOGO);
  1641. $v['_source']['app_name'] = $auth_info['app_name'];
  1642. $v['_source']['app_logo'] = $auth_info['app_logo'];
  1643. $info = \app\common\model\Activity::where('id',$v['_source']['id'])->find()->toArray();
  1644. $v['_source']['start_time'] = $info['start_time'];
  1645. $v['_source']['end_time'] = $info['end_time'];
  1646. $v['_source']['cover'] = $info['cover'];
  1647. $v['_source']['read_num'] = numTransform($info['read_num']);
  1648. $w_list[] = $v;
  1649. break;
  1650. case 'supplier_goods':
  1651. $info = SupplierGoods::where('id',$v['_source']['id'])->find()->toArray();
  1652. // return json($info['supplier_id']);
  1653. $auth_info = SupplierGoods::getAuth($v['_source']['user_id'],APPNAME,APPLOGO);
  1654. $auth_info = \app\common\model\Supplier::where('id',$info['supplier_id'])->find();
  1655. if(!$auth_info){
  1656. $app_name = '';
  1657. $app_logo = '';
  1658. }else{
  1659. $app_name = $auth_info['title'];
  1660. $app_logo = $auth_info['logo'];
  1661. }
  1662. $v['_source']['app_name'] = $app_name;
  1663. $v['_source']['app_logo'] = $app_logo;
  1664. $v['_source']['read_num'] = numTransform($info['read_num']);
  1665. $v['_source']['cover'] = $info['cover'];
  1666. unset($v['_source']['content']);
  1667. $w_list[] = $v;
  1668. break;
  1669. case 'press':
  1670. $info = \app\common\model\Press::where('id',$v['_source']['id'])->find()->toArray();
  1671. $auth_info = SupplierGoods::getAuth($v['_source']['user_id'],APPNAME,APPLOGO);
  1672. $v['_source']['app_name'] = $auth_info['app_name'];
  1673. $v['_source']['app_logo'] = $auth_info['app_logo'];
  1674. $v['_source']['read_num'] = numTransform($info['read_num']);
  1675. $images_arr = $info['images'] ? explode('|',$info['images']) : null;
  1676. $v['_source']['cover'] = $images_arr ? $images_arr[0] : null;
  1677. unset($v['_source']['content']);
  1678. $w_list[] = $v;
  1679. break;
  1680. case 'demand':
  1681. $info = PlatformDemand::where('id',$v['_source']['id'])->find()->toArray();
  1682. $auth_info = PlatformDemand::getAuth($v['_source']['user_id'],APPNAME,APPLOGO);
  1683. $v['_source']['app_name'] = $auth_info['app_name'];
  1684. $v['_source']['app_logo'] = $auth_info['app_logo'];
  1685. $v['_source']['read_num'] = numTransform($info['read_num']);
  1686. $images_arr = $info['images'] ? explode('|',$info['images']) : null;
  1687. $v['_source']['cover'] = $info['cover'];
  1688. $v['_source']['money'] = $info['money'];
  1689. unset($v['_source']['content']);
  1690. $w_list[] = $v;
  1691. break;
  1692. case 'recruit':
  1693. $info = \app\common\model\Recruit::where('id',$v['_source']['id'])->find()->toArray();
  1694. $auth_info = \app\common\model\Recruit::getAuth($v['_source']['user_id'],APPNAME,APPLOGO);
  1695. $v['_source']['app_name'] = $auth_info['app_name'];
  1696. $v['_source']['app_logo'] = $auth_info['app_logo'];
  1697. $v['_source']['scale'] = $info['scale'];
  1698. $v['_source']['is_ss'] = $info['is_ss'];
  1699. $v['_source']['company'] = $info['company'];
  1700. $v['_source']['company_intro'] = $info['company_intro'];
  1701. $v['_source']['province'] = $info['province'];
  1702. $v['_source']['salary'] = $info['salary'];
  1703. $v['_source']['city'] = $info['city'];
  1704. $v['_source']['principal'] = $info['principal'];
  1705. $v['_source']['hr_headimg'] = $info['hr_headimg'];
  1706. unset($v['_source']['content']);
  1707. $w_list[] = $v;
  1708. break;
  1709. case 'goods':
  1710. $info = \app\common\model\StoreGoods::where('id',$v['_source']['id'])->find()->toArray();
  1711. $auth_info = \app\common\model\StoreGoods::getAuth($v['_source']['user_id'],APPNAME,APPLOGO);
  1712. $v['_source']['app_name'] = $auth_info['app_name'];
  1713. $v['_source']['app_logo'] = $auth_info['app_logo'];
  1714. $v['_source']['cover'] = $info['cover'];
  1715. $v['_source']['sale_num'] = $info['sale_num'];
  1716. $v['_source']['specs'] = json_decode($info['specs'],true);
  1717. $v['_source']['item_list'] = StoreGoodsItem::getGoodsSpec($info['id']);
  1718. $v['_source']['min_price'] = empty($v['_source']['item_list']) ? 0 : min(array_column($v['_source']['item_list'],'sell_price'));
  1719. $v['_source']['max_price'] = empty($v['_source']['item_list']) ? 0 : max(array_column($v['_source']['item_list'],'sell_price'));
  1720. unset($v['_source']['content']);
  1721. $w_list[] = $v;
  1722. break;
  1723. }
  1724. }
  1725. $list['hits']['hits'] = $w_list;
  1726. $this->success('ok',['list'=>$list,'total_count'=>$list['hits']['total']['value'],'page_num'=>$this->page_num]);
  1727. }
  1728. /**
  1729. * @title 获取DRM无法播放机型
  1730. * @desc 获取DRM无法播放机型
  1731. * @author qc
  1732. * @url /api/Expedite/getBanPhoneModel
  1733. * @method GET
  1734. */
  1735. public function getBanPhoneModel()
  1736. {
  1737. $list = Db::name('ban_phone_model')->where('is_deleted',0)->column('name');
  1738. $this->success('ok',$list);
  1739. }
  1740. /**
  1741. * @title 获取各个模分享图片
  1742. * @desc 获取各个模分享图片
  1743. * @author qc
  1744. * @url /api/Expedite/getModuleBgImages
  1745. * @method GET
  1746. * @return name:activity type:string default:-- desc:活动
  1747. * @return name:video type:string default:-- desc:视频
  1748. * @return name:datum type:string default:-- desc:资料
  1749. * @return name:forum type:string default:-- desc:问答
  1750. * @return name:article type:string default:-- desc:图文
  1751. * @return name:supplier type:string default:-- desc:供应商
  1752. * @return name:press type:string default:-- desc:新闻
  1753. * @return name:demand type:string default:-- desc:需求
  1754. * @return name:recruit type:string default:-- desc:招聘
  1755. * @return name:goods type:string default:-- desc:商品
  1756. */
  1757. public function getModuleBgImages()
  1758. {
  1759. $list = [
  1760. 'activity' => 'https://gaoyixia.oss-cn-hangzhou.aliyuncs.com/images/activity.png',// 活动
  1761. 'video' => 'https://gaoyixia.oss-cn-hangzhou.aliyuncs.com/images/video.png',// 视频
  1762. 'datum' => 'https://gaoyixia.oss-cn-hangzhou.aliyuncs.com/images/datum.png',//资料
  1763. 'forum' => 'https://gaoyixia.oss-cn-hangzhou.aliyuncs.com/images/forum.png',// 问答
  1764. 'article' => 'https://gaoyixia.oss-cn-hangzhou.aliyuncs.com/images/article.png',// 图文
  1765. 'supplier' => 'https://gaoyixia.oss-cn-hangzhou.aliyuncs.com/images/supplier.png',// 供应商
  1766. 'press' => 'https://gaoyixia.oss-cn-hangzhou.aliyuncs.com/images/press.png',//新闻
  1767. 'demand' => 'https://gaoyixia.oss-cn-hangzhou.aliyuncs.com/images/demand.png',// 需求
  1768. 'recruit' => 'https://gaoyixia.oss-cn-hangzhou.aliyuncs.com/images/recruit.png',// 招聘
  1769. 'goods' => 'https://gaoyixia.oss-cn-hangzhou.aliyuncs.com/images/goods.png',// 商品
  1770. ];
  1771. $this->success('ok',$list);
  1772. }
  1773. }