Recruit.php 28 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593
  1. <?php
  2. namespace app\api\controller;
  3. use app\common\model\PlatformLike;
  4. use app\common\model\PlatformSwitch;
  5. use app\common\model\RecruitCate;
  6. use app\common\model\User;
  7. use app\common\model\UserCollect;
  8. use app\common\model\UserSearch;
  9. use app\common\model\UserTrack;
  10. use app\common\service\CheckPower;
  11. use library\tools\Data;
  12. use think\Db;
  13. /**
  14. * @title 招聘
  15. * @controller Recruit
  16. * @group base
  17. */
  18. class Recruit extends Base
  19. {
  20. // 需要登录的
  21. protected $need_login = [
  22. 'recruitTags',
  23. 'recruitCollect',
  24. 'recruitTransmit',
  25. 'getOwnRecruitList',
  26. 'getBrowseList',
  27. 'getRecruitCollect',
  28. 'getFollowUpList',
  29. ];
  30. public function initialize()
  31. {
  32. parent::initialize();
  33. parent::setUid();
  34. }
  35. /**
  36. * @title 招聘接口说明
  37. * @desc 招聘接口说明
  38. * @author qc
  39. * @url /api/Recruit/classIntro
  40. * @method GET
  41. * @return name:1 type:string default:-- desc:--
  42. */
  43. public function classIntro(){}
  44. /**
  45. * @title 获取招聘分类
  46. * @desc 两级分类
  47. * @author qc
  48. * @url /api/Recruit/getRecruitCate
  49. * @method GET
  50. * @header name:Authorization require:1 desc:Token
  51. * @return name:id type:int default:-- desc:分类id
  52. * @return name:title type:string default:0 desc:分类名称
  53. * @return name:children type:array default:0 desc:下级分类
  54. */
  55. public function getRecruitCate()
  56. {
  57. $list = RecruitCate::where(['is_deleted'=>0])->field('id,title,pid')->order('sort desc,id asc')->select()->toArray();
  58. $list = make_tree($list);
  59. $this->success('ok',['list'=>$list]);
  60. }
  61. /**
  62. * @title 联系我们【两个二维码】(招聘详情内部)
  63. * @desc 联系HR
  64. * @author qc
  65. * @method GET
  66. * @url /api/Recruit/getRecruitContact
  67. * @header name:Authorization require:1 desc:Token
  68. * @param name:id type:int default:-- desc:招聘记录id
  69. * @return name:phone type:string default:-- desc:招聘电话
  70. * @return name:email type:string default:-- desc:招聘email
  71. * @return name:hr_code type:int default:-- desc:招聘二维码
  72. * @return name:principal type:string default:-- desc:招聘联系人
  73. * @return name:qrcode type:string default:-- desc:平台二维码
  74. * @return name:contact_phone type:string default:-- desc:平台电话
  75. * @return name:contact_email type:string default:-- desc:平台邮箱
  76. */
  77. public function getRecruitContact()
  78. {
  79. $sel_where[] = ['id','=',input('get.id')];
  80. $detail = \app\common\model\Recruit::field('id,phone,email,hr_code,principal')->where($sel_where)->find()->toArray();
  81. $contact = Db::name('contact')->where('tag','recruit')->field('qrcode,phone contact_phone,email contact_email')->find();
  82. $contact['phone'] = $detail['phone'];
  83. $contact['email'] = $detail['email'];
  84. $contact['hr_code'] = $detail['hr_code'];
  85. $contact['principal'] = $detail['principal'];
  86. $this->success('ok',$contact);
  87. }
  88. /**
  89. * @title 招聘推荐
  90. * @desc 招聘推荐
  91. * @author qc
  92. * @method GET
  93. * @url /api/Recruit/getRecommendList
  94. * @header name:Authorization require:1 desc:Token
  95. * @param name:page type:int default:0 desc:页数
  96. * @param name:page_num type:int default:20 desc:每页数
  97. * @return name:id type:int default:-- desc:记录ID
  98. * @return name:title type:string default:-- desc:标题
  99. * @return name:company type:string default:-- desc:公司名
  100. * @return name:principal type:string default:-- desc:联系人
  101. * @return name:hr_headimg type:string default:-- desc:hr头像
  102. * @return name:cover type:string default:-- desc:公司logo
  103. * @return name:label_name type:array default:-- desc:标签
  104. * @return name:welfare_arr type:array default:-- desc:岗位福利
  105. * @return name:education type:string default:-- desc:学历
  106. * @return name:experience_min type:int default:0 desc:最低工作年限
  107. * @return name:experience_max type:int default:0 desc:最高工作年限
  108. * @return name:price_min type:int default:-- desc:最低薪资[弃用]
  109. * @return name:price_max type:int default:-- desc:最高薪资[弃用]
  110. * @return name:salary type:int default:-- desc:薪资【文本】
  111. * @return name:province type:string default:-- desc:省名
  112. * @return name:city type:string default:-- desc:市名
  113. * @return name:county type:string default:-- desc:县区
  114. * @return name:address type:string default:-- desc:地址
  115. * @return name:app_name type:string default:-- desc:发布方名称
  116. * @return name:app_logo type:string default:-- desc:发布方头像
  117. */
  118. public function getRecommendList()
  119. {
  120. $app_name = sysconf('app_name');
  121. $app_logo = sysconf('app_logo');
  122. $search_log = UserSearch::getSearchTitle($this->user_id,8);
  123. $search_arr = [];
  124. $where_str = 'b.id > 0';
  125. foreach ($search_log as $t){
  126. $search_arr[] = " b.title like '".'%'.$t."%'" .' ';
  127. $search_arr[] = " b.label like '".'%'.$t."%'" .' ';
  128. }
  129. if(!empty($search_arr)) $where_str = implode(' OR ',$search_arr);
  130. $field = 'a.id,title,a.user_id,label,salary,principal,hr_headimg,address,price_min,price_max,company,education,experience_min,experience_max,welfare,province,city,county,IFNULL(is_recommend,0) is_recommend ';
  131. $table = 'dd_recruit';
  132. $order_by_two = 'a.id';
  133. $sql = "SELECT $field FROM " .$table . " a LEFT JOIN ( SELECT id,IF(id,1,1) is_recommend FROM $table b WHERE ( $where_str )) AS c ON c.id = a.id WHERE a.status = 1 AND a.is_deleted = 0 ORDER BY is_recommend DESC , $order_by_two desc LIMIT {$this->off_set},{$this->page_num}";
  134. $list = Db::query($sql);
  135. $list = dispose_recommend($list);
  136. array_walk($list,function (&$v,$k)use ($app_name,$app_logo){
  137. if(!$v['user_id']){
  138. $v['app_name'] = $app_name;
  139. $v['app_logo'] = $app_logo;
  140. }else{
  141. $user_info = User::where('id',$v['user_id'])->field('name,headimg')->find();
  142. $v['app_name'] = $user_info ? $user_info->name : '';
  143. $v['app_logo'] = $user_info ? $user_info->headimg : '';
  144. }
  145. $v['label_name'] = $v['label']? explode(',',trim($v['label'],',')) : null;
  146. $v['welfare_arr'] = explode(',',trim($v['welfare'],','));
  147. });
  148. $this->success('ok',['list'=>$list]);
  149. }
  150. /**
  151. * @title 获取招聘列表
  152. * @desc 获取招聘列表
  153. * @author qc
  154. * @method GET
  155. * @url /api/Recruit/getRecruitList
  156. * @header name:Authorization require:1 desc:Token
  157. * @param name:title type:string default:-- desc:标题
  158. * @param name:page type:int default:0 desc:页数
  159. * @param name:page_num type:int default:20 desc:每页数
  160. * @param name:sort_type type:int default:1 desc:1默认2时间升序3时间降序
  161. * @param name:first_classify type:int default:0 desc:一级分类id
  162. * @param name:second_classify type:int default:0 desc:二级分类id
  163. *
  164. * @return name:title type:string default:-- desc:标题
  165. * @return name:company type:string default:-- desc:公司名
  166. * @return name:cover type:string default:-- desc:公司logo
  167. * @return name:phone type:string default:-- desc:电话
  168. * @return name:email type:string default:-- desc:email
  169. * @return name:label_name type:array default:-- desc:标签
  170. * @return name:welfare_arr type:array default:-- desc:岗位福利
  171. * @return name:education type:string default:-- desc:学历
  172. * @return name:experience_min type:int default:0 desc:最低工作年限
  173. * @return name:experience_max type:int default:0 desc:最高工作年限
  174. * @return name:price_min type:int default:-- desc:最低薪资[弃用]
  175. * @return name:price_max type:int default:-- desc:最高薪资[弃用]
  176. * @return name:salary type:int default:-- desc:薪资【文本】
  177. * @return name:content type:string default:-- desc:招聘详情
  178. * @return name:create_at type:string default:-- desc:发布时间
  179. * @return name:first_classify type:int default:-- desc:一级分类id
  180. * @return name:second_classify type:int default:-- desc:二级分类id
  181. * @return name:province type:string default:-- desc:省名
  182. * @return name:city type:string default:-- desc:市名
  183. * @return name:county type:string default:-- desc:县区
  184. * @return name:address type:string default:-- desc:地址
  185. * @return name:longitude type:string default:-- desc:经度
  186. * @return name:latitude type:string default:-- desc:纬度
  187. * @return name:num type:int default:-- desc:招聘人数
  188. * @return name:app_name type:string default:-- desc:发布方名称
  189. * @return name:app_logo type:string default:-- desc:发布方头像
  190. */
  191. public function getRecruitList(){
  192. $title = input('get.title');
  193. $sort_type = input('get.sort_type',1);
  194. $first_classify = input('get.first_classify');
  195. $second_classify = input('get.second_classify');
  196. $app_name = sysconf('app_name');
  197. $app_logo = sysconf('app_logo');
  198. switch ($sort_type) {
  199. case 1:
  200. $order = ['sort'=>'desc','read_num'=>'desc'];
  201. break;
  202. case 2:
  203. $order = ['id'=>'asc','sort'=>'desc'];
  204. break;
  205. case 3:
  206. $order = ['id'=>'desc','sort'=>'desc'];
  207. break;
  208. }
  209. $sel_where = [];
  210. $sel_where[] = ['is_deleted','=',0];
  211. $sel_where[] = ['status','=',1];
  212. if($first_classify) $sel_where[] = ['first_classify','=',$first_classify];
  213. if($second_classify) $sel_where[] = ['second_classify','=',$second_classify];
  214. if($title && $this->user_id) UserSearch::saveSearchTitle($this->user_id,$title,8);
  215. $list = \app\common\model\Recruit::where($sel_where)
  216. ->when($title,function ($query)use($title){
  217. if($title) $query->where('title|label','like','%'.$title.'%');
  218. })->order($order)->limit($this->off_set,$this->page_num)->select()->toArray();
  219. foreach ($list as &$v) {
  220. $v['label_name'] = $v['label']? explode(',',trim($v['label'],',')) : null;
  221. $v['welfare_arr'] = explode(',',trim($v['welfare'],','));
  222. if(!$v['user_id']){
  223. $v['app_name'] = $app_name;
  224. $v['app_logo'] = $app_logo;
  225. }else{
  226. $user_info = User::where('id',$v['user_id'])->field('name,headimg')->find();
  227. $v['app_name'] = $user_info ? $user_info->name : '';
  228. $v['app_logo'] = $user_info ? $user_info->headimg : '';
  229. }
  230. }
  231. $total_num = \app\common\model\Recruit::where($sel_where)
  232. ->when($title,function ($query)use($title){
  233. if($title) $query->where('title|label','like','%'.$title.'%');
  234. })->count();
  235. $this->success('ok',['list'=>$list,'total_num'=>$total_num]);
  236. }
  237. /**
  238. * @title 获取招聘详情
  239. * @desc 获取招聘详情
  240. * @author qc
  241. * @method GET
  242. * @url /api/Recruit/getRecruitDetail
  243. * @header name:Authorization require:1 desc:Token
  244. * @param name:id type:int default:-- desc:招聘记录id
  245. * @return name:title type:string default:-- desc:标题
  246. * @return name:company type:string default:-- desc:公司名
  247. * @return name:cover type:string default:-- desc:公司logo
  248. * @return name:company_label type:array default:-- desc:公司标签
  249. * @return name:principal type:string default:-- desc:联系人
  250. * @return name:hr_headimg type:string default:-- desc:联系人头像
  251. * @return name:phone type:string default:-- desc:电话
  252. * @return name:email type:string default:-- desc:email
  253. * @return name:label_name type:array default:-- desc:标签
  254. * @return name:welfare_arr type:array default:-- desc:岗位福利
  255. * @return name:education type:string default:-- desc:学历
  256. * @return name:experience_min type:int default:0 desc:最低工作年限
  257. * @return name:experience_max type:int default:0 desc:最高工作年限
  258. * @return name:price_min type:int default:-- desc:最低薪资[弃用]
  259. * @return name:price_max type:int default:-- desc:最高薪资[弃用]
  260. * @return name:salary type:int default:-- desc:薪资【文本】
  261. * @return name:content type:string default:-- desc:招聘详情
  262. * @return name:create_at type:string default:-- desc:发布时间
  263. * @return name:first_classify type:int default:-- desc:一级分类id
  264. * @return name:second_classify type:int default:-- desc:二级分类id
  265. * @return name:praise_num type:int default:-- desc:点赞量
  266. * @return name:is_praise type:int default:-- desc:是否点赞【0否1是】
  267. * @return name:is_collect type:int default:-- desc:是否收藏【0否1是】
  268. * @return name:collect_num type:int default:-- desc:收藏量
  269. * @return name:transmit_num type:int default:-- desc:转发量
  270. * @return name:province type:string default:-- desc:省名
  271. * @return name:city type:string default:-- desc:市名
  272. * @return name:county type:string default:-- desc:县区
  273. * @return name:address type:string default:-- desc:地址
  274. * @return name:longitude type:string default:-- desc:经度
  275. * @return name:latitude type:string default:-- desc:纬度
  276. * @return name:num type:int default:-- desc:招聘人数
  277. * @return name:hr_code type:int default:-- desc:二维码
  278. */
  279. public function getRecruitDetail()
  280. {
  281. $sel_where[] = ['id','=',input('get.id')];
  282. $detail = \app\common\model\Recruit::where($sel_where)->find()->toArray();
  283. if($detail['is_deleted'] == 1 || $detail['status'] == 0) $this->error('该招聘信息已取消');
  284. $detail['label_name'] = explode(',',trim($detail['label'],','));
  285. $detail['welfare_arr'] = explode(',',trim($detail['welfare'],','));
  286. $detail['company_label'] = explode(',',trim($detail['company_label'],','));
  287. $detail['is_praise'] = PlatformLike::checkTags($this->user_id,$detail['id'],5);
  288. $detail['praise_num'] = PlatformLike::getPraiseNum($detail['id'],5);
  289. $detail['is_collect'] = UserCollect::checkCollectByType($this->user_id,8,$detail['id']);
  290. $detail['collect_num'] = UserCollect::getCollectNum(8,$detail['id']);
  291. $detail['transmit_num'] = numTransform($detail['transmit_num']);
  292. \app\common\model\Recruit::where('id',$detail['id'])->setInc('read_num');
  293. UserTrack::crateTrack($this->user_id,8,input('get.id'),0);
  294. $this->success('ok',['detail'=>$detail]);
  295. }
  296. /**
  297. * @title 以下接口调用验证登录【需要header传Authorization】
  298. * @desc 以下接口调用验证登录
  299. * @author qc
  300. * @method
  301. * @url /api/Recruit/needLogin()
  302. */
  303. public function needLogin(){}
  304. /**
  305. * @title 点赞||取消点赞
  306. * @desc 点赞||取消点赞
  307. * @author qc
  308. * @method POST
  309. * @url /api/Recruit/recruitTags
  310. * @header name:Authorization require:1 desc:Token
  311. * @param name:id type:int default:1 desc:招聘记录id
  312. * @return name:tags type:int default:1 desc:0取消成功,1点赞成功
  313. */
  314. public function recruitTags()
  315. {
  316. $ret_val = PlatformLike::userTags($this->user_id,input('post.id'),5);
  317. $this->success($ret_val == 1 ?'点赞成功':'取消成功',['tags'=>$ret_val]);
  318. }
  319. /**
  320. * @title 收藏||取消收藏
  321. * @desc 用户收藏
  322. * @author qc
  323. * @method POST
  324. * @url /api/Recruit/recruitCollect
  325. * @header name:Authorization require:1 desc:Token
  326. * @param name:id type:int require:1 default:-- desc:招聘记录id
  327. * @param name:status type:int default:0 desc:收藏状态(0取消收藏【未收藏】,1收藏)
  328. */
  329. public function recruitCollect(){
  330. $coll_status = UserCollect::plateCollect($this->user_id,8,input('post.id',0));
  331. $coll_status ? $this->success('收藏成功',['status'=>1]) : $this->success('取消收藏成功',['status'=>0]);
  332. }
  333. /**
  334. * @title 转发(转发数量统计)
  335. * @desc 转发成功后调用
  336. * @author qc
  337. * @method POST
  338. * @url /api/Recruit/recruitTransmit
  339. * @header name:Authorization require:1 desc:Token
  340. * @param name:id type:int default:-- desc:招聘记录id
  341. */
  342. public function recruitTransmit()
  343. {
  344. $id = input('post.id',0);
  345. \app\common\model\Recruit::where('id',$id)->setInc('transmit_num');
  346. $this->success('ok');
  347. }
  348. /**
  349. * @title 我的发布【招聘】
  350. * @desc 我的发布【招聘】
  351. * @author qc
  352. * @method GET
  353. * @url /api/Recruit/getOwnRecruitList
  354. * @header name:Authorization require:1 desc:Token
  355. * @param name:title type:string default:-- desc:标题
  356. * @param name:page type:int default:0 desc:页数
  357. * @param name:page_num type:int default:20 desc:每页数
  358. * @return name:title type:string default:-- desc:标题
  359. * @return name:company type:string default:-- desc:公司名
  360. * @return name:cover type:string default:-- desc:公司logo
  361. * @return name:label_name type:array default:-- desc:标签
  362. * @return name:welfare_arr type:array default:-- desc:岗位福利
  363. * @return name:education type:string default:-- desc:学历
  364. * @return name:experience_min type:int default:0 desc:最低工作年限
  365. * @return name:experience_max type:int default:0 desc:最高工作年限
  366. * @return name:price_min type:int default:-- desc:最低薪资[弃用]
  367. * @return name:price_max type:int default:-- desc:最高薪资[弃用]
  368. * @return name:salary type:int default:-- desc:薪资【文本】
  369. * @return name:create_at type:string default:-- desc:发布时间
  370. * @return name:num type:int default:-- desc:招聘人数
  371. * @return name:principal type:string default:-- desc:联系人
  372. * @return name:hr_headimg type:string default:-- desc:联系人头像
  373. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  374. */
  375. public function getOwnRecruitList()
  376. {
  377. $title = input('get.title');
  378. $sel_where = [];
  379. $sel_where[] = ['is_deleted','=',0];
  380. $sel_where[] = ['status','=',1];
  381. $sel_where[] = ['user_id','=',$this->user_id];
  382. $list = \app\common\model\Recruit::where($sel_where)
  383. ->field('id,title,company,label,welfare,education,experience_min,salary,experience_max,price_min,price_max,create_at,num,principal,hr_headimg,province,city,county')
  384. ->when($title,function ($query)use($title){
  385. if($title) $query->where('title|label','like','%'.$title.'%');
  386. })->order(['id'=>'asc'])
  387. ->limit($this->off_set,$this->page_num)
  388. ->select()->toArray();
  389. $user_info = $this->userInfo('name,headimg');
  390. foreach ($list as &$v) {
  391. $v['label_name'] = $v['label']? explode(',',trim($v['label'],',')) : null;
  392. $v['welfare_arr'] = explode(',',trim($v['welfare'],','));
  393. $v['is_normal'] = CheckPower::checkModulesPower($v['id'],0,$this->request->controller());
  394. $v['app_name'] = $user_info['name'];
  395. $v['app_logo'] = $user_info['headimg'];
  396. }
  397. $this->success('ok',['list'=>$list]);
  398. }
  399. /**
  400. * @title 浏览记录【招聘】
  401. * @desc 浏览记录【招聘】
  402. * @author qc
  403. * @method GET
  404. * @url /api/Recruit/getBrowseList
  405. * @header name:Authorization require:1 desc:Token
  406. * @param name:title type:string default:-- desc:标题
  407. * @param name:page type:int default:0 desc:页数
  408. * @param name:page_num type:int default:20 desc:每页数
  409. * @return name:id type:int default:-- desc:浏览记录id
  410. * @return name:title type:string default:-- desc:标题
  411. * @return name:recruit_id type:int default:-- desc:招聘记录id
  412. * @return name:company type:string default:-- desc:公司名
  413. * @return name:cover type:string default:-- desc:公司logo
  414. * @return name:label_name type:array default:-- desc:标签
  415. * @return name:welfare_arr type:array default:-- desc:岗位福利
  416. * @return name:education type:string default:-- desc:学历
  417. * @return name:experience_min type:int default:0 desc:最低工作年限
  418. * @return name:experience_max type:int default:0 desc:最高工作年限
  419. * @return name:price_min type:int default:-- desc:最低薪资[弃用]
  420. * @return name:price_max type:int default:-- desc:最高薪资[弃用]
  421. * @return name:salary type:int default:-- desc:薪资【文本】
  422. * @return name:num type:int default:-- desc:招聘人数
  423. * @return name:time type:string default:-- desc:浏览时间
  424. * @return name:principal type:string default:-- desc:联系人
  425. * @return name:hr_headimg type:string default:-- desc:联系人头像
  426. * @return name:app_name type:string default:-- desc:发布人名称
  427. * @return name:app_logo type:string default:-- desc:发布人头像
  428. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  429. */
  430. public function getBrowseList()
  431. {
  432. $sel_where = [];
  433. $sel_where[] = ['t.user_id','=',$this->user_id];
  434. $sel_where[] = ['t.type','=',8];
  435. $title = input('get.title');
  436. if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
  437. $list = UserTrack::where($sel_where)
  438. ->alias('t')
  439. ->field('t.id,t.update_int,t.first_id recruit_id,i.salary,i.title,i.price_max,i.company,i.label,province,city,county,i.welfare,i.education,i.experience_min,i.experience_max,price_min,price_max,i.num,principal,hr_headimg,i.user_id')
  440. ->leftJoin('Recruit i','t.first_id = i.id')
  441. ->order('update_int desc')
  442. ->limit($this->off_set,$this->page_num)
  443. ->select()->toArray();
  444. $app_name = sysconf('app_name');
  445. $app_logo = sysconf('app_logo');
  446. foreach ($list as &$v) {
  447. $v['time'] = date("Y-m-d H:i:s",$v['update_int']);
  448. $v['label_name'] = $v['label']? explode(',',trim($v['label'],',')) : null;
  449. $v['welfare_arr'] = explode(',',trim($v['welfare'],','));
  450. $v['is_normal'] = CheckPower::checkModulesPower($v['recruit_id'],0,$this->request->controller());
  451. if(!$v['user_id']){
  452. $v['app_name'] = $app_name;
  453. $v['app_logo'] = $app_logo;
  454. }else{
  455. $user_info = User::where('id',$v['user_id'])->field('name,headimg')->find();
  456. $v['app_name'] = $user_info ? $user_info->name : '';
  457. $v['app_logo'] = $user_info ? $user_info->headimg : '';
  458. }
  459. }
  460. $this->success('ok',['list'=>$list]);
  461. }
  462. /**
  463. * @title 收藏记录【招聘】
  464. * @desc 收藏记录【招聘】
  465. * @author qc
  466. * @method GET
  467. * @url /api/Recruit/getRecruitCollect
  468. * @header name:Authorization require:1 desc:Token
  469. * @param name:title type:string default:-- desc:标题
  470. * @param name:page type:int default:0 desc:页数
  471. * @param name:page_num type:int default:20 desc:每页数
  472. * @return name:id type:int default:-- desc:收藏记录id
  473. * @return name:title type:string default:-- desc:标题
  474. * @return name:recruit_id type:int default:-- desc:招聘记录id
  475. * @return name:company type:string default:-- desc:公司名
  476. * @return name:cover type:string default:-- desc:公司logo
  477. * @return name:label_name type:array default:-- desc:标签
  478. * @return name:welfare_arr type:array default:-- desc:岗位福利
  479. * @return name:education type:string default:-- desc:学历
  480. * @return name:experience_min type:int default:0 desc:最低工作年限
  481. * @return name:experience_max type:int default:0 desc:最高工作年限
  482. * @return name:price_min type:int default:-- desc:最低薪资[弃用]
  483. * @return name:price_max type:int default:-- desc:最高薪资[弃用]
  484. * @return name:, type:int default:-- desc:薪资【文本】
  485. * @return name:num type:int default:-- desc:招聘人数
  486. * @return name:time type:string default:-- desc:浏览时间
  487. * @return name:principal type:string default:-- desc:联系人
  488. * @return name:hr_headimg type:string default:-- desc:联系人头像
  489. * @return name:app_name type:string default:-- desc:发布人名称
  490. * @return name:app_logo type:string default:-- desc:发布人头像
  491. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  492. */
  493. public function getRecruitCollect()
  494. {
  495. $sel_where = [];
  496. $title = input('get.title');
  497. if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
  498. $sel_where[] = ['t.user_id','=',$this->user_id];
  499. $sel_where[] = ['t.coll_type','=',8];
  500. $list = UserCollect::where($sel_where)
  501. ->alias('t')
  502. ->field('t.id,t.create_at,t.coll_id recruit_id,i.title,i.company,i.label,i.salary,i.welfare,i.education,i.experience_min,i.experience_max,price_min,price_max,i.num,principal,hr_headimg,province,city,county,i.user_id')
  503. ->leftJoin('Recruit i','t.coll_id = i.id')
  504. ->order('id desc')
  505. ->limit($this->off_set,$this->page_num)
  506. ->select()->toArray();
  507. $app_name = sysconf('app_name');
  508. $app_logo = sysconf('app_logo');
  509. foreach ($list as &$v) {
  510. $v['label_name'] = $v['label']? explode(',',trim($v['label'],',')) : null;
  511. $v['welfare_arr'] = explode(',',trim($v['welfare'],','));
  512. $v['is_normal'] = CheckPower::checkModulesPower($v['recruit_id'],0,$this->request->controller());
  513. if(!$v['user_id']){
  514. $v['app_name'] = $app_name;
  515. $v['app_logo'] = $app_logo;
  516. }else{
  517. $user_info = User::where('id',$v['user_id'])->field('name,headimg')->find();
  518. $v['app_name'] = $user_info ? $user_info->name : '';
  519. $v['app_logo'] = $user_info ? $user_info->headimg : '';
  520. }
  521. }
  522. $this->success('ok',['list'=>$list]);
  523. }
  524. /**
  525. * @title 以下接口为二期需求
  526. * @desc 以下接口为二期需求
  527. * @author qc
  528. * @url /api/Recruit/secondPhase
  529. * @method
  530. * @return name:1 type:string default:-- desc:以下接口为二期需求
  531. */
  532. public function secondPhase(){}
  533. /**
  534. * @title 我的追更列表
  535. * @desc 我的追更列表
  536. * @author qc
  537. * @method GET
  538. * @url /api/Recruit/getFollowUpList
  539. * @header name:Authorization require:1 desc:Token
  540. * @param name:title type:string default:-- desc:标题
  541. * @param name:page type:int default:0 desc:页数
  542. * @param name:page_num type:int default:20 desc:每页数
  543. * @return name:create_at type:string default:-- desc:追更设置时间
  544. * @return name:recruit_id type:int default:-- desc:招聘id
  545. * @return name:title type:string default:-- desc:标题
  546. * @return name:company type:string default:-- desc:公司名
  547. * @return name:cover type:string default:-- desc:公司logo
  548. */
  549. public function getFollowUpList()
  550. {
  551. $sel_where = [];
  552. $sel_where[] = ['p.user_id','=',$this->user_id];
  553. $sel_where[] = ['p.type','=',6];
  554. $sel_where[] = ['p.switch_id','=',1];
  555. $field = 'p.id,p.switch_id as article_id,p.create_at,a.title,a.company,a.cover';
  556. $list = PlatformSwitch::field($field)
  557. ->alias('p')
  558. ->leftJoin('Recruit a','p.switch_id = a.id')
  559. ->where($sel_where)
  560. ->limit($this->off_set,$this->page_num)
  561. ->order('p.id desc')
  562. ->select()->toArray();
  563. $this->success('ok',['list'=>$list]);
  564. }
  565. }