Recruit.php 51 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007
  1. <?php
  2. namespace app\api\controller;
  3. use AlibabaCloud\SDK\Vod\V20170321\Models\GetMediaDNAResultResponseBody\DNAResult\videoDNA\detail\input;
  4. use app\common\model\PlatformLike;
  5. use app\common\model\PlatformSwitch;
  6. use app\common\model\RecruitCate;
  7. use app\common\model\RecruitResume;
  8. use app\common\model\Recruit as RecruitModel;
  9. use app\common\model\TopSearch;
  10. use app\common\model\User;
  11. use app\common\model\UserCollect;
  12. use app\common\model\UserMessage;
  13. use app\common\model\UserSearch;
  14. use app\common\model\UserTrack;
  15. use app\common\service\CheckPower;
  16. use app\common\service\UserSynth;
  17. use library\tools\Data;
  18. use think\Db;
  19. /**
  20. * @title 招聘
  21. * @controller Recruit
  22. * @group base
  23. */
  24. class Recruit extends Base
  25. {
  26. // 需要登录的
  27. protected $need_login = [
  28. 'sendResume',
  29. 'recruitTags',
  30. 'recruitCollect',
  31. 'recruitTransmit',
  32. 'getTagsRecruit',
  33. 'resumeToRecruits',
  34. 'getRecruitResumeList',
  35. 'getOwnRecruitList',
  36. 'getBrowseList',
  37. 'getRecruitCollect',
  38. 'getFollowUpList',
  39. 'getFollowUpMessage',
  40. 'batchesDel',
  41. 'unreadChange',
  42. ];
  43. public function initialize()
  44. {
  45. parent::initialize();
  46. parent::setUid();
  47. }
  48. /**
  49. * @title 招聘接口说明
  50. * @desc 招聘接口说明
  51. * @author qc
  52. * @url /api/Recruit/classIntro
  53. * @method GET
  54. * @return name:1 type:string default:-- desc:--
  55. */
  56. public function classIntro(){}
  57. /**
  58. * @title 获取招聘分类
  59. * @desc 三级分类
  60. * @author qc
  61. * @url /api/Recruit/getRecruitCate
  62. * @method GET
  63. * @header name:Authorization require:1 desc:Token
  64. * @return name:id type:int default:-- desc:分类id
  65. * @return name:title type:string default:0 desc:分类名称
  66. * @return name:children type:array default:0 desc:下级分类
  67. */
  68. public function getRecruitCate()
  69. {
  70. $list = RecruitCate::where(['is_deleted'=>0])->field('id,title,pid')->order('sort desc,id asc')->select()->toArray();
  71. $list = make_tree($list);
  72. $this->success('ok',['list'=>$list]);
  73. }
  74. /**
  75. * @title 获取第三级分类
  76. * @desc 获取第三级分类
  77. * @author qc
  78. * @url /api/Recruit/getThirdCate
  79. * @method GET
  80. * @header name:Authorization require:1 desc:Token
  81. * @param name:fid type:int default:-- desc:一级分类id
  82. * @param name:pid type:int default:-- desc:二级分类id【不传查一级分类下全部的三级分类】
  83. * @return name:id type:int default:-- desc:分类id
  84. * @return name:title type:string default:0 desc:分类名称
  85. * @return name:lev type:int default:0 desc:分类等级
  86. * @return name:children type:array default:0 desc:下级分类
  87. *
  88. */
  89. public function getThirdCate()
  90. {
  91. $where = [];
  92. $where[]=['is_deleted','=',0];
  93. $where[]=['pid','=',input('fid')];
  94. if(input('pid')) $where[] = ['id','=',input('pid')];
  95. $list = RecruitCate::where($where)->field('id,title,pid,lev')->order('sort desc,id asc')->select()->toArray();
  96. foreach ($list as &$v) {
  97. $v['children'] = RecruitCate::where([['is_deleted','=',0],['pid','=',$v['id']]])->field('id,title,pid,lev')->order('sort desc,id asc')->select()->toArray();
  98. foreach ($v['children'] as $key => $val){
  99. //third_classify
  100. $v['children'][$key]['recruit'] = RecruitModel::where('third_classify',$val['id'])->limit(2)->select();
  101. }
  102. }
  103. $this->success('ok',['list'=>$list]);
  104. }
  105. /**
  106. * @title 投递简历
  107. * @desc 投递简历
  108. * @author qc
  109. * @url /api/Recruit/sendResume
  110. * @method POST
  111. * @header name:Authorization require:1 desc:Token
  112. * @param name:recruit_id type:int default:-- desc:招聘记录id
  113. * @param name:type type:int default:0 desc:类型0图片1pdf
  114. * @param name:images type:string default:0 desc:pdf||图片(多张|隔开)
  115. */
  116. public function sendResume()
  117. {
  118. $images = input('post.images');
  119. $type = input('post.type',0);
  120. if(empty($images)) $this->error('请上传文件');
  121. $Resume = RecruitResume::create([
  122. 'user_id'=>$this->user_id,
  123. 'recruit_id'=>input('post.recruit_id'),
  124. 'images'=>$images,
  125. 'type'=>$type,
  126. ]);
  127. $detail = \app\common\model\Recruit::field('id,phone,email,hr_code,principal,user_id')->where('id',input('post.recruit_id'))->find()->toArray();
  128. UserMessage::sendUserMessage($detail['user_id'],'recruit',4,0,0,$Resume->id,'有人投递简历',$Resume->id);
  129. $this->success('投递成功');
  130. }
  131. /**
  132. * @title 获取简历详情
  133. * @desc 获取简历详情
  134. * @author qc
  135. * @url /api/Recruit/getResumeInfo
  136. * @method GET
  137. * @header name:Authorization require:1 desc:Token
  138. * @param name:resume_id type:int default:-- desc:简历记录id
  139. * @return name:images type:string default:-- desc:图片||pdf
  140. * @return name:images_arr type:array default:-- desc:数组
  141. * @return name:type type:int default:0 desc:类型0图片1pdf
  142. */
  143. public function getResumeInfo()
  144. {
  145. $info = RecruitResume::field('r.id,user_id,r.images,r.create_at,r.type,m.name')->alias('r')
  146. ->leftJoin('StoreMember m','m.id = r.user_id')
  147. ->where('r.id',input('get.resume_id'))->where(['r.is_deleted'=>0])->find();
  148. if(!$info) $this->error('简历详情不存在');
  149. $info = $info->toArray();
  150. $info['images_arr'] = explode('|',$info['images']);
  151. $this->success('ok',$info);
  152. }
  153. /**
  154. * @title 联系我们【两个二维码】(招聘详情内部)
  155. * @desc 联系HR
  156. * @author qc
  157. * @method GET
  158. * @url /api/Recruit/getRecruitContact
  159. * @header name:Authorization require:1 desc:Token
  160. * @param name:id type:int default:-- desc:招聘记录id
  161. * @return name:phone type:string default:-- desc:招聘电话
  162. * @return name:email type:string default:-- desc:招聘email
  163. * @return name:hr_code type:int default:-- desc:招聘二维码
  164. * @return name:principal type:string default:-- desc:招聘联系人
  165. * @return name:qrcode type:string default:-- desc:平台二维码
  166. * @return name:contact_phone type:string default:-- desc:平台电话
  167. * @return name:contact_email type:string default:-- desc:平台邮箱
  168. */
  169. public function getRecruitContact()
  170. {
  171. $sel_where[] = ['id','=',input('get.id')];
  172. $detail = \app\common\model\Recruit::field('id,phone,email,hr_code,principal')->where($sel_where)->find()->toArray();
  173. $contact = Db::name('contact')->where('tag','recruit')->field('qrcode,phone contact_phone,email contact_email')->find();
  174. $contact['phone'] = $detail['phone'];
  175. $contact['email'] = $detail['email'];
  176. $contact['hr_code'] = $detail['hr_code'];
  177. $contact['principal'] = $detail['principal'];
  178. $this->success('ok',$contact);
  179. }
  180. /**
  181. * @title 招聘推荐
  182. * @desc 招聘推荐
  183. * @author qc
  184. * @method GET
  185. * @url /api/Recruit/getRecommendList
  186. * @header name:Authorization require:1 desc:Token
  187. * @param name:page type:int default:0 desc:页数
  188. * @param name:page_num type:int default:20 desc:每页数
  189. * @param name:is_over type:int default:20 desc:每页数
  190. * @param name:rand_user type:string default:-- desc:随机id(非登录状态必传,page=1时生成(a123),其他页数(a123),一直查询到没有数据)
  191. * @param name:city type:string default:1 desc:城市名称
  192. * @param name:education type:string default:1 desc:学历
  193. * @return name:id type:int default:-- desc:记录ID
  194. * @return name:title type:string default:-- desc:标题
  195. * @return name:company type:string default:-- desc:公司名
  196. * @return name:principal type:string default:-- desc:联系人
  197. * @return name:hr_headimg type:string default:-- desc:hr头像
  198. * @return name:cover type:string default:-- desc:公司logo
  199. * @return name:label_name type:array default:-- desc:标签
  200. * @return name:welfare_arr type:array default:-- desc:岗位福利
  201. * @return name:education type:string default:-- desc:学历
  202. * @return name:experience_min type:int default:0 desc:最低工作年限
  203. * @return name:experience_max type:int default:0 desc:最高工作年限
  204. * @return name:price_min type:int default:-- desc:最低薪资[弃用]
  205. * @return name:price_max type:int default:-- desc:最高薪资[弃用]
  206. * @return name:salary type:int default:-- desc:薪资【文本】
  207. * @return name:work_hours type:string default:-- desc:兼职、全职或具体时长
  208. * @return name:province type:string default:-- desc:省名
  209. * @return name:city type:string default:-- desc:市名
  210. * @return name:county type:string default:-- desc:县区
  211. * @return name:address type:string default:-- desc:地址
  212. * @return name:app_name type:string default:-- desc:发布方名称
  213. * @return name:app_logo type:string default:-- desc:发布方头像
  214. * @return name:release_time type:string default:-- desc:上架时间
  215. * @return name:company_intro type:string default:-- desc:公司简介
  216. * @return name:is_ss type:string default:-- desc:是否上市,1上市0未上市
  217. * @return name:scale type:string default:-- desc:公司规模(人数)
  218. */
  219. public function getRecommendList()
  220. {
  221. $user_id = $this->user_id ? $this->user_id : input('rand_user');
  222. if(!$user_id) $this->error('参数错误');
  223. $list = UserSynth::getRecommendList($user_id,'recruit',$this->page,$this->page_num,['city'=>input('city'),'education'=>input('education')]);
  224. if($list['code'] != 200) $this->error($list['msg']);
  225. $this->success('ok',$list);
  226. $data = input();
  227. $search_log = UserSearch::getSearchTitle($this->user_id,8);
  228. $search_arr = [];
  229. $where_str = 'b.id > 0';
  230. foreach ($search_log as $t){
  231. $search_arr[] = " b.title like '".'%'.$t."%'" .' ';
  232. $search_arr[] = " b.label like '".'%'.$t."%'" .' ';
  233. }
  234. if(!empty($search_arr)) $where_str = implode(' OR ',$search_arr);
  235. $field = 'a.id,title,a.user_id,label,salary,work_hours,principal,hr_headimg,address,price_min,price_max,company,education,experience_min,experience_max,welfare,province,city,county,IFNULL(is_recommend,0) is_recommend ';
  236. $table = 'dd_recruit';
  237. $order_by_two = 'a.id';
  238. $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}";
  239. $list = Db::query($sql);
  240. $list = dispose_recommend($list);
  241. array_walk($list,function (&$v,$k){
  242. $auth_info = \app\common\model\Recruit::getAuth($v['user_id'],APPNAME,APPLOGO);
  243. $v['app_name'] = $auth_info['app_name'];
  244. $v['app_logo'] = $auth_info['app_logo'];
  245. $v['label_name'] = $v['label']? explode(',',trim($v['label'],',')) : null;
  246. $v['welfare_arr'] = explode(',',trim($v['welfare'],','));
  247. });
  248. $sql2 = "SELECT count(a.id) num FROM " .$table . " a LEFT JOIN ( SELECT id,IF(id,1,1) is_recommend FROM $table b WHERE ( $where_str )) AS c ON c.id = a.id 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}";
  249. $total = Db::query($sql2);
  250. $this->success('ok',['list'=>$list,'total_count'=>$total[0]['num'],'page_num'=>$this->page_num]);
  251. }
  252. /**
  253. * @title 合集列表
  254. * @desc 合集列表
  255. * @author qc
  256. * @method GET
  257. * @url /api/Recruit/getRecruitList
  258. * @header name:Authorization require:1 desc:Token
  259. * @param name:page type:int default:0 desc:页数
  260. * @param name:page_num type:int default:20 desc:每页数
  261. * @param name:sort_type type:int default:1 desc:1默认2时间升序3时间降序
  262. * @param name:city type:string default:1 desc:城市名称
  263. * @param name:education type:int default:0 desc:学历
  264. * @param name:first_classify type:int default:0 desc:一级分类id
  265. * @param name:second_classify type:int default:0 desc:二级分类id
  266. * @param name:third_classify type:int default:0 desc:三级分类id
  267. *
  268. * @return name:title type:string default:-- desc:标题
  269. * @return name:company type:string default:-- desc:公司名
  270. * @return name:cover type:string default:-- desc:公司logo
  271. * @return name:salary type:int default:-- desc:薪资【文本】
  272. * @return name:work_hours type:string default:-- desc:兼职、全职或具体时长s
  273. * @return name:phone type:string default:-- desc:电话
  274. * @return name:email type:string default:-- desc:email
  275. * @return name:label_name type:array default:-- desc:标签
  276. * @return name:welfare_arr type:array default:-- desc:岗位福利
  277. * @return name:principal type:string default:-- desc:HR
  278. * @return name:hr_headimg type:string default:-- desc:HR头像
  279. * @return name:province type:string default:-- desc:省名
  280. * @return name:city type:string default:-- desc:市名
  281. * @return name:county type:string default:-- desc:县区
  282. * @return name:address type:string default:-- desc:地址
  283. * @return name:num type:int default:-- desc:招聘人数
  284. * @return name:app_name type:string default:-- desc:发布方名称
  285. * @return name:app_logo type:string default:-- desc:发布方头像
  286. * @return name:release_time type:string default:-- desc:上架时间
  287. * @return name:follow_switch type:int default:-- desc:订阅开关状态【0关闭1开启】
  288. * @return name:third_title type:string default:-- desc:第三级分类名称
  289. * @return name:company_intro type:string default:-- desc:公司简介
  290. * @return name:is_ss type:string default:-- desc:是否上市,1上市0未上市
  291. * @return name:scale type:string default:-- desc:公司规模(人数)
  292. */
  293. public function getRecruitList(){
  294. $sort_type = input('get.sort_type',1);
  295. $first_classify = input('get.first_classify');
  296. $second_classify = input('get.second_classify');
  297. $third_classify = input('get.third_classify');
  298. $education = input('get.education');
  299. $city = input('get.city');
  300. switch ($sort_type) {
  301. case 1:
  302. $order = ['sort'=>'desc','read_num'=>'desc'];
  303. break;
  304. case 2:
  305. $order = ['id'=>'asc','sort'=>'desc'];
  306. break;
  307. case 3:
  308. $order = ['id'=>'desc','sort'=>'desc'];
  309. break;
  310. }
  311. $sel_where = [];
  312. $sel_where[] = ['is_deleted','=',0];
  313. $sel_where[] = ['status','=',1];
  314. if($first_classify) $sel_where[] = ['first_classify','=',$first_classify];
  315. if($second_classify) $sel_where[] = ['second_classify','=',$second_classify];
  316. if($third_classify) $sel_where[] = ['third_classify','=',$third_classify];
  317. if($city) $sel_where[] = ['city','like','%'.$city.'%'];
  318. if($education) $sel_where[] = ['education','=',$education];
  319. $field = "id,title,num,province,education,city,county,address,user_id,principal,hr_headimg,label,welfare,salary,work_hours,release_time,company,company_intro,is_ss,scale";
  320. $list = \app\common\model\Recruit::field($field)->where($sel_where)->order($order)->limit($this->off_set,$this->page_num)->select()->toArray();
  321. $third_title = RecruitCate::where('id',$third_classify)->value('title');
  322. foreach ($list as &$v) {
  323. $v['label_name'] = $v['label']? explode(',',trim($v['label'],',')) : null;
  324. $v['welfare_arr'] = explode(',',trim($v['welfare'],','));
  325. $auth_info = \app\common\model\Recruit::getAuth($v['user_id'],APPNAME,APPLOGO);
  326. $v['app_name'] = $auth_info['app_name'];
  327. $v['app_logo'] = $auth_info['app_logo'];
  328. }
  329. $total_num = \app\common\model\Recruit::where($sel_where)->count();
  330. $follow_switch = PlatformSwitch::checkSwitch($this->user_id,$third_classify,6);
  331. $this->success('ok',['list'=>$list,'third_title'=>$third_title,'follow_switch'=>$follow_switch,'total_num'=>$total_num,'total_count'=>$total_num,'page_num'=>$this->page_num]);
  332. }
  333. /**
  334. * @title 获取招聘详情
  335. * @desc 获取招聘详情
  336. * @author qc
  337. * @method GET
  338. * @url /api/Recruit/getRecruitDetail
  339. * @header name:Authorization require:1 desc:Token
  340. * @param name:id type:int default:-- desc:招聘记录id
  341. * @return name:title type:string default:-- desc:标题
  342. * @return name:company type:string default:-- desc:公司名
  343. * @return name:cover type:string default:-- desc:公司logo
  344. * @return name:company_label type:array default:-- desc:公司标签
  345. * @return name:principal type:string default:-- desc:RH
  346. * @return name:hr_headimg type:string default:-- desc:RH头像
  347. * @return name:phone type:string default:-- desc:电话
  348. * @return name:email type:string default:-- desc:email
  349. * @return name:label_name type:array default:-- desc:标签
  350. * @return name:welfare_arr type:array default:-- desc:岗位福利
  351. * @return name:education type:string default:-- desc:学历
  352. * @return name:experience_min type:int default:0 desc:最低工作年限
  353. * @return name:experience_max type:int default:0 desc:最高工作年限
  354. * @return name:salary type:string:-- desc:薪资【文本】
  355. * @return name:work_hours type:string default:-- desc:兼职、全职或具体时长
  356. * @return name:content type:string default:-- desc:招聘详情
  357. * @return name:create_at type:string default:-- desc:发布时间
  358. * @return name:praise_num type:int default:-- desc:点赞量
  359. * @return name:is_praise type:int default:-- desc:是否点赞【0否1是】
  360. * @return name:is_collect type:int default:-- desc:是否收藏【0否1是】
  361. * @return name:collect_num type:int default:-- desc:收藏量
  362. * @return name:transmit_num type:int default:-- desc:转发量
  363. * @return name:read_num type:int default:-- desc:阅读量
  364. * @return name:province type:string default:-- desc:省名
  365. * @return name:city type:string default:-- desc:市名
  366. * @return name:county type:string default:-- desc:县区
  367. * @return name:address type:string default:-- desc:地址
  368. * @return name:longitude type:string default:-- desc:经度
  369. * @return name:latitude type:string default:-- desc:纬度
  370. * @return name:num type:int default:-- desc:招聘人数
  371. * @return name:hr_code type:int default:-- desc:二维码
  372. * @return name:release_time type:string default:-- desc:上架时间
  373. * @return name:follow_switch type:int default:-- desc:订阅开关状态【0关闭1开启】
  374. * @return name:company_intro type:string default:-- desc:公司简介
  375. * @return name:is_ss type:string default:-- desc:是否上市,1上市0未上市
  376. * @return name:scale type:string default:-- desc:公司规模(人数)
  377. *
  378. */
  379. public function getRecruitDetail()
  380. {
  381. $sel_where[] = ['id','=',input('get.id')];
  382. $detail = \app\common\model\Recruit::where($sel_where)->find()->toArray();
  383. if($detail['is_deleted'] == 1 || $detail['status'] == 0) $this->error('该招聘信息已取消');
  384. $detail['label_name'] = explode(',',trim($detail['label'],','));
  385. $detail['welfare_arr'] = explode(',',trim($detail['welfare'],','));
  386. $detail['company_label'] = explode(',',trim($detail['company_label'],','));
  387. $detail['is_praise'] = PlatformLike::checkTags($this->user_id,$detail['id'],5);
  388. $detail['praise_num'] = PlatformLike::getPraiseNum($detail['id'],5);
  389. $detail['is_collect'] = UserCollect::checkCollectByType($this->user_id,8,$detail['id']);
  390. $detail['collect_num'] = UserCollect::getCollectNum(8,$detail['id']);
  391. $detail['transmit_num'] = numTransform($detail['transmit_num']);
  392. \app\common\model\Recruit::where('id',$detail['id'])->setInc('read_num');
  393. UserTrack::crateTrack($this->user_id,8,input('get.id'),0);
  394. if($this->user_id){
  395. TopSearch::seIncHotNum($detail['id'],$this->request->controller());
  396. }
  397. $this->success('ok',['detail'=>$detail]);
  398. }
  399. /**
  400. * @title 点赞||取消点赞
  401. * @desc 点赞||取消点赞
  402. * @author qc
  403. * @method POST
  404. * @url /api/Recruit/recruitTags
  405. * @header name:Authorization require:1 desc:Token
  406. * @param name:id type:int default:1 desc:招聘记录id
  407. * @return name:tags type:int default:1 desc:0取消成功,1点赞成功
  408. */
  409. public function recruitTags()
  410. {
  411. $ret_val = PlatformLike::userTags($this->user_id,input('post.id'),5);
  412. $this->success($ret_val == 1 ?'点赞成功':'取消成功',['tags'=>$ret_val]);
  413. }
  414. /**
  415. * @title 收藏||取消收藏
  416. * @desc 用户收藏
  417. * @author qc
  418. * @method POST
  419. * @url /api/Recruit/recruitCollect
  420. * @header name:Authorization require:1 desc:Token
  421. * @param name:id type:int require:1 default:-- desc:招聘记录id
  422. * @param name:status type:int default:0 desc:收藏状态(0取消收藏【未收藏】,1收藏)
  423. */
  424. public function recruitCollect(){
  425. $coll_status = UserCollect::plateCollect($this->user_id,8,input('post.id',0));
  426. $coll_status ? $this->success('收藏成功',['status'=>1]) : $this->success('取消收藏成功',['status'=>0]);
  427. }
  428. /**
  429. * @title 转发(转发数量统计)
  430. * @desc 转发成功后调用
  431. * @author qc
  432. * @method POST
  433. * @url /api/Recruit/recruitTransmit
  434. * @header name:Authorization require:1 desc:Token
  435. * @param name:id type:int default:-- desc:招聘记录id
  436. */
  437. public function recruitTransmit()
  438. {
  439. $id = input('post.id',0);
  440. \app\common\model\Recruit::where('id',$id)->setInc('transmit_num');
  441. $this->success('ok');
  442. }
  443. /**
  444. * @title 点赞我的
  445. * @desc 点赞我的
  446. * @author qc
  447. * @method GET
  448. * @url /api/Recruit/praiseRecruitList
  449. * @header name:Authorization require:1 desc:Token
  450. * @param name:page type:int default:-- desc:页数
  451. * @param name:page_num type:int default:-- desc:每页数
  452. * @return name:id type:int default:-- desc:记录id
  453. * @return name:label_name type:array default:-- desc:标签
  454. * @return name:recruit_id type:array default:-- desc:招聘id
  455. * @return name:create_at type:string default:-- desc:时间
  456. * @return name:user_name type:string default:-- desc:会员名称
  457. * @return name:headimg type:string default:-- desc:会员头像
  458. * @return name:salary type:int default:-- desc:薪资【文本】
  459. * @return name:work_hours type:string default:-- desc:兼职、全职或具体时长
  460. * @return name:company type:string default:-- desc:公司名
  461. * @return name:education type:string default:-- desc:学历
  462. * @return name:experience_min type:int default:0 desc:最低工作年限
  463. * @return name:experience_max type:int default:0 desc:最高工作年限
  464. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  465. * @return name:company_intro type:string default:-- desc:公司简介
  466. * @return name:is_ss type:string default:-- desc:是否上市,1上市0未上市
  467. * @return name:scale type:string default:-- desc:公司规模(人数)
  468. */
  469. public function praiseRecruitList()
  470. {
  471. $sel_where = [];
  472. $sel_where[] = ['p.type', '=', 5];
  473. $sel_where[] = ['f.user_id', '=', $this->user_id];
  474. $sel_where[] = ['p.user_id', '<>', $this->user_id];
  475. $sel_where[] = ['p.to_deleted', '=', 0];
  476. $list = PlatformLike::where($sel_where)
  477. ->field('p.id,p.like_id,f.title,u.name user_name,u.headimg,f.title,f.id recruit_id,f.label,salary,work_hours,f.company,f.company_intro,f.is_ss,f.scale,education,experience_min,experience_max,p.create_at,f.cover,f.hr_headimg,f.principal')
  478. ->alias('p')
  479. ->leftJoin('Recruit f', 'f.id = p.like_id')
  480. ->leftJoin('StoreMember u', 'u.id = p.user_id')
  481. ->limit($this->off_set,$this->page_num)
  482. ->select()->toArray();
  483. array_walk($list,function (&$v){
  484. $v['label_name'] = $v['label']? explode(',',trim($v['label'],',')) : null;
  485. $v['is_normal'] = CheckPower::checkModulesPower($v['like_id'], 0, $this->request->controller());
  486. });
  487. $total_num = PlatformLike::where($sel_where)->alias('p')->leftJoin('Recruit f', 'f.id = p.like_id')->leftJoin('StoreMember u', 'u.id = p.user_id')->count();
  488. $this->success('ok', ['list' => $list, 'total_count' => $total_num, 'page_num' => $this->page_num]);
  489. }
  490. /**
  491. * @title 我的点赞
  492. * @desc 我的点赞
  493. * @author qc
  494. * @method GET
  495. * @url /api/Recruit/getTagsRecruit
  496. * @header name:Authorization require:1 desc:Token
  497. * @param name:page type:int default:-- desc:页数
  498. * @param name:page_num type:int default:-- desc:每页数
  499. * @return name:id type:int default:-- desc:记录id
  500. * @return name:label_name type:array default:-- desc:标签
  501. * @return name:recruit_id type:array default:-- desc:招聘id
  502. * @return name:create_at type:string default:-- desc:时间
  503. * @return name:user_name type:string default:-- desc:会员名称
  504. * @return name:headimg type:string default:-- desc:会员头像
  505. * @return name:salary type:int default:-- desc:薪资【文本】
  506. * @return name:work_hours type:string default:-- desc:兼职、全职或具体时长
  507. * @return name:company type:string default:-- desc:公司名
  508. * @return name:education type:string default:-- desc:学历
  509. * @return name:experience_min type:int default:0 desc:最低工作年限
  510. * @return name:experience_max type:int default:0 desc:最高工作年限
  511. * @return name:principal type:string default:-- desc:联系人
  512. * @return name:hr_headimg type:string default:-- desc:联系人头像
  513. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  514. * @return name:company_intro type:string default:-- desc:公司简介
  515. * @return name:is_ss type:string default:-- desc:是否上市,1上市0未上市
  516. * @return name:scale type:string default:-- desc:公司规模(人数)
  517. */
  518. public function getTagsRecruit()
  519. {
  520. $sel_where = [];
  521. $sel_where[] = ['p.type', '=', 5];
  522. $sel_where[] = ['p.user_id', '=', $this->user_id];
  523. $sel_where[] = ['f.user_id', '<>', $this->user_id];
  524. $sel_where[] = ['p.to_deleted', '=', 0];
  525. $list = PlatformLike::where($sel_where)
  526. ->field('p.id,p.like_id,f.title,u.name user_name,u.headimg,f.title,f.id recruit_id,f.label,salary,work_hours,f.company,f.company_intro,f.is_ss,f.scale,education,experience_min,experience_max,principal,hr_headimg,f.cover,f.hr_headimg,f.principal')
  527. ->alias('p')
  528. ->leftJoin('Recruit f', 'f.id = p.like_id')
  529. ->leftJoin('StoreMember u', 'u.id = p.user_id')
  530. ->limit($this->off_set,$this->page_num)
  531. ->select()->toArray();
  532. array_walk($list,function (&$v){
  533. $v['label_name'] = $v['label']? explode(',',trim($v['label'],',')) : null;
  534. $v['is_normal'] = CheckPower::checkModulesPower($v['like_id'], 0, $this->request->controller());
  535. });
  536. $total_num = PlatformLike::where($sel_where)->alias('p')->leftJoin('Recruit f', 'f.id = p.like_id')->leftJoin('StoreMember u', 'u.id = p.user_id')->count();
  537. $this->success('ok', ['list' => $list, 'total_count' => $total_num, 'page_num' => $this->page_num]);
  538. }
  539. /**
  540. * @title 给我投的
  541. * @desc 给我投的
  542. * @author qc
  543. * @method GET
  544. * @url /api/Recruit/resumeToRecruits
  545. * @header name:Authorization require:1 desc:Token
  546. * @param name:page type:int default:-- desc:页数
  547. * @param name:page_num type:int default:-- desc:每页数
  548. * @return name:id type:int default:-- desc:招聘记录id
  549. * @return name:work_hours type:string default:-- desc:兼职、全职或具体时长
  550. * @return name:salary type:string default:-- desc:薪资
  551. * @return name:unread_num type:string default:-- desc:未读量
  552. * @return name:time_str type:string default:-- desc:时间
  553. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  554. */
  555. public function resumeToRecruits()
  556. {
  557. $recruits = \app\common\model\Recruit::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
  558. $recruit_ids = RecruitResume::where('recruit_id','in',$recruits)->where('is_deleted',0)->where('to_deleted',0)->group('recruit_id')->column('recruit_id');
  559. $ids_str = implode(',',$recruit_ids);
  560. $list = \app\common\model\Recruit::where(['r.user_id'=>$this->user_id,'r.is_deleted'=>0,]) ->alias('r')
  561. ->where('r.id','in',$ids_str)
  562. //->field('r.id,IFNULL( (SELECT count( s.id) FROM dd_recruit_resume as s WHERE r.id=s.recruit_id ),0) as re_num,IFNULL( (SELECT max(y.id) FROM dd_recruit_resume as y WHERE r.id=y.recruit_id ),0) as max_id')
  563. ->field('r.id,r.title,r.salary,work_hours,IFNULL( (SELECT count( s.id) FROM dd_recruit_resume as s WHERE r.id=s.recruit_id ),0) as re_num')
  564. ->order('r.id desc')
  565. ->limit($this->off_set,$this->page_num)
  566. ->select()->toArray();
  567. array_walk($list,function (&$v){
  568. $v['unread_num'] = RecruitResume::getUnreadNum($v['id']);
  569. $new_info = RecruitResume::where(['recruit_id'=>$v['id'],'is_deleted'=>0,'is_read'=>0])->order('id desc')->find();
  570. $v['time_str'] = $new_info ? timeTransform($new_info->create_at) :null;
  571. $v['is_normal'] = CheckPower::checkModulesPower($v['id'],0,$this->request->controller());
  572. });
  573. $total_num = \app\common\model\Recruit::where(['r.user_id'=>$this->user_id,'r.is_deleted'=>0,]) ->alias('r') ->where('r.id','in',$ids_str)
  574. ->field('r.id,IFNULL( (SELECT count( s.id) FROM dd_recruit_resume as s WHERE r.id=s.recruit_id ),0) as re_num')
  575. ->order('r.id desc')->count();
  576. $this->success('ok', ['list' => $list, 'total_count' => $total_num, 'page_num' => $this->page_num]);
  577. }
  578. /**
  579. * @title 给我投的--简历列表
  580. * @desc 给我投的--简历列表
  581. * @author qc
  582. * @method GET
  583. * @url /api/Recruit/getRecruitResumeList
  584. * @header name:Authorization require:1 desc:Token
  585. * @param name:page type:int default:-- desc:页数
  586. * @param name:page_num type:int default:-- desc:每页数
  587. * @param name:recruit_id type:int default:-- desc:招聘记录id
  588. * @return name:images type:string default:-- desc:图片
  589. * @return name:images_arr type:array default:-- desc:数组
  590. * @return name:name type:string default:-- desc:名称
  591. * @return name:headimg type:string default:-- desc:头像
  592. * @return name:create_at type:string default:-- desc:时间
  593. * @return name:type type:int default:0 desc:类型0图片1pdf
  594. * @return name:is_read type:int default:-- desc:是否已读(0未读1已读)
  595. */
  596. public function getRecruitResumeList()
  597. {
  598. $list = RecruitResume::where(['r.recruit_id'=>input('get.recruit_id'),'r.is_deleted'=>0,'r.to_deleted'=>0])->alias('r')
  599. ->field('r.id,r.recruit_id,u.name,u.headimg,images,r.create_at,r.is_read,r.type')
  600. ->leftJoin('StoreMember u','u.id = r.user_id')
  601. ->limit($this->off_set,$this->page_num)
  602. ->order('r.id desc')
  603. ->select()->toArray();
  604. array_walk($list,function (&$v){
  605. $v['images_arr'] = explode('|',$v['images']);
  606. $v['create_at'] = substr($v['create_at'],0,10);
  607. });
  608. $total_num = RecruitResume::where(['r.recruit_id'=>input('get.recruit_id'),'r.is_deleted'=>0,'r.to_deleted'=>0])->alias('r')
  609. ->leftJoin('StoreMember u','u.id = r.user_id')->count();
  610. $this->success('ok', ['list' => $list, 'total_count' => $total_num, 'page_num' => $this->page_num]);
  611. }
  612. /**
  613. * @title 我的发布【招聘】
  614. * @desc 我的发布【招聘】
  615. * @author qc
  616. * @method GET
  617. * @url /api/Recruit/getOwnRecruitList
  618. * @header name:Authorization require:1 desc:Token
  619. * @param name:title type:string default:-- desc:标题
  620. * @param name:page type:int default:0 desc:页数
  621. * @param name:page_num type:int default:20 desc:每页数
  622. * @return name:title type:string default:-- desc:标题
  623. * @return name:company type:string default:-- desc:公司名
  624. * @return name:cover type:string default:-- desc:公司logo
  625. * @return name:label_name type:array default:-- desc:标签
  626. * @return name:welfare_arr type:array default:-- desc:岗位福利
  627. * @return name:education type:string default:-- desc:学历
  628. * @return name:experience_min type:int default:0 desc:最低工作年限
  629. * @return name:experience_max type:int default:0 desc:最高工作年限
  630. * @return name:price_min type:int default:-- desc:最低薪资[弃用]
  631. * @return name:price_max type:int default:-- desc:最高薪资[弃用]
  632. * @return name:salary type:int default:-- desc:薪资【文本】
  633. * @return name:work_hours type:string default:-- desc:兼职、全职或具体时长
  634. * @return name:create_at type:string default:-- desc:发布时间
  635. * @return name:num type:int default:-- desc:招聘人数
  636. * @return name:principal type:string default:-- desc:联系人
  637. * @return name:hr_headimg type:string default:-- desc:联系人头像
  638. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  639. * @return name:company_intro type:string default:-- desc:公司简介
  640. * @return name:is_ss type:string default:-- desc:是否上市,1上市0未上市
  641. * @return name:scale type:string default:-- desc:公司规模(人数)
  642. */
  643. public function getOwnRecruitList()
  644. {
  645. $title = input('get.title');
  646. $sel_where = [];
  647. $sel_where[] = ['is_deleted','=',0];
  648. $sel_where[] = ['status','=',1];
  649. $sel_where[] = ['user_id','=',$this->user_id];
  650. $list = \app\common\model\Recruit::where($sel_where)
  651. ->field('id,title,company,company_intro,work_hours,is_ss,scale,label,welfare,education,experience_min,salary,experience_max,price_min,price_max,create_at,num,principal,hr_headimg,province,city,county')
  652. ->when($title,function ($query)use($title){
  653. if($title) $query->where('title|label','like','%'.$title.'%');
  654. })->order(['id'=>'asc'])
  655. ->limit($this->off_set,$this->page_num)
  656. ->select()->toArray();
  657. $user_info = $this->userInfo('name,headimg');
  658. foreach ($list as &$v) {
  659. $v['label_name'] = $v['label']? explode(',',trim($v['label'],',')) : null;
  660. $v['welfare_arr'] = explode(',',trim($v['welfare'],','));
  661. $v['is_normal'] = CheckPower::checkModulesPower($v['id'],0,$this->request->controller());
  662. $v['app_name'] = $user_info['name'];
  663. $v['app_logo'] = $user_info['headimg'];
  664. }
  665. $total_num = \app\common\model\Recruit::where($sel_where)
  666. ->when($title,function ($query)use($title){
  667. if($title) $query->where('title|label','like','%'.$title.'%');
  668. })->count();
  669. $this->success('ok', ['list' => $list, 'total_count' => $total_num, 'page_num' => $this->page_num]);
  670. }
  671. /**
  672. * @title 浏览记录【招聘】
  673. * @desc 浏览记录【招聘】
  674. * @author qc
  675. * @method GET
  676. * @url /api/Recruit/getBrowseList
  677. * @header name:Authorization require:1 desc:Token
  678. * @param name:title type:string default:-- desc:标题
  679. * @param name:page type:int default:0 desc:页数
  680. * @param name:page_num type:int default:20 desc:每页数
  681. * @return name:id type:int default:-- desc:浏览记录id
  682. * @return name:title type:string default:-- desc:标题
  683. * @return name:recruit_id type:int default:-- desc:招聘记录id
  684. * @return name:company type:string default:-- desc:公司名
  685. * @return name:label_name type:array default:-- desc:标签
  686. * @return name:welfare_arr type:array default:-- desc:岗位福利
  687. * @return name:education type:string default:-- desc:学历
  688. * @return name:experience_min type:int default:0 desc:最低工作年限
  689. * @return name:experience_max type:int default:0 desc:最高工作年限
  690. * @return name:salary type:int default:-- desc:薪资【文本】
  691. * @return name:work_hours type:string default:-- desc:兼职、全职或具体时长
  692. * @return name:num type:int default:-- desc:招聘人数
  693. * @return name:time type:string default:-- desc:浏览时间
  694. * @return name:principal type:string default:-- desc:HR
  695. * @return name:hr_headimg type:string default:-- desc:HR头像
  696. * @return name:app_name type:string default:-- desc:发布人名称
  697. * @return name:app_logo type:string default:-- desc:发布人头像
  698. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  699. * @return name:company_intro type:string default:-- desc:公司简介
  700. * @return name:is_ss type:string default:-- desc:是否上市,1上市0未上市
  701. * @return name:scale type:string default:-- desc:公司规模(人数)
  702. */
  703. public function getBrowseList()
  704. {
  705. $sel_where = [];
  706. $sel_where[] = ['t.user_id','=',$this->user_id];
  707. $sel_where[] = ['t.type','=',8];
  708. $title = input('get.title');
  709. if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
  710. $list = UserTrack::where($sel_where)
  711. ->alias('t')
  712. ->field('t.id,t.update_int,t.first_id recruit_id,i.salary,work_hours,i.title,i.price_max,i.company,i.company_intro,i.is_ss,i.scale,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,i.cover,i.hr_headimg,i.principal')
  713. ->leftJoin('Recruit i','t.first_id = i.id')
  714. ->order('update_int desc')
  715. ->limit($this->off_set,$this->page_num)
  716. ->select()->toArray();
  717. foreach ($list as &$v) {
  718. $v['time'] = date("Y-m-d H:i:s",$v['update_int']);
  719. $v['label_name'] = $v['label']? explode(',',trim($v['label'],',')) : null;
  720. $v['welfare_arr'] = explode(',',trim($v['welfare'],','));
  721. $v['is_normal'] = CheckPower::checkModulesPower($v['recruit_id'],0,$this->request->controller());
  722. $auth_info = \app\common\model\Recruit::getAuth($v['user_id'],APPNAME,APPLOGO);
  723. $v['app_name'] = $auth_info['app_name'];
  724. $v['app_logo'] = $auth_info['app_logo'];
  725. }
  726. $total_num = UserTrack::where($sel_where)->alias('t')->leftJoin('Recruit i','t.first_id = i.id')->count();
  727. $this->success('ok', ['list' => $list, 'total_count' => $total_num, 'page_num' => $this->page_num]);
  728. }
  729. /**
  730. * @title 收藏记录【招聘】
  731. * @desc 收藏记录【招聘】
  732. * @author qc
  733. * @method GET
  734. * @url /api/Recruit/getRecruitCollect
  735. * @header name:Authorization require:1 desc:Token
  736. * @param name:title type:string default:-- desc:标题
  737. * @param name:page type:int default:0 desc:页数
  738. * @param name:page_num type:int default:20 desc:每页数
  739. * @return name:id type:int default:-- desc:收藏记录id
  740. * @return name:title type:string default:-- desc:标题
  741. * @return name:recruit_id type:int default:-- desc:招聘记录id
  742. * @return name:company type:string default:-- desc:公司名
  743. * @return name:cover type:string default:-- desc:公司logo
  744. * @return name:label_name type:array default:-- desc:标签
  745. * @return name:welfare_arr type:array default:-- desc:岗位福利
  746. * @return name:education type:string default:-- desc:学历
  747. * @return name:experience_min type:int default:0 desc:最低工作年限
  748. * @return name:experience_max type:int default:0 desc:最高工作年限
  749. * @return name:price_min type:int default:-- desc:最低薪资[弃用]
  750. * @return name:price_max type:int default:-- desc:最高薪资[弃用]
  751. * @return name:salary type:string default:-- desc:薪资【文本】
  752. * @return name:work_hours type:string default:-- desc:兼职、全职或具体时长
  753. * @return name:num type:int default:-- desc:招聘人数
  754. * @return name:time type:string default:-- desc:浏览时间
  755. * @return name:principal type:string default:-- desc:联系人
  756. * @return name:hr_headimg type:string default:-- desc:联系人头像
  757. * @return name:app_name type:string default:-- desc:发布人名称
  758. * @return name:app_logo type:string default:-- desc:发布人头像
  759. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  760. * @return name:company_intro type:string default:-- desc:公司简介
  761. * @return name:is_ss type:string default:-- desc:是否上市,1上市0未上市
  762. * @return name:scale type:string default:-- desc:公司规模(人数)
  763. */
  764. public function getRecruitCollect()
  765. {
  766. $sel_where = [];
  767. $title = input('get.title');
  768. if($title) $sel_where[] = ['i.title|i.label','like','%'.$title.'%'];
  769. $sel_where[] = ['t.user_id','=',$this->user_id];
  770. $sel_where[] = ['t.coll_type','=',8];
  771. $list = UserCollect::where($sel_where)
  772. ->alias('t')
  773. ->field('t.id,t.create_at,t.coll_id recruit_id,i.title,i.company,i.company_intro,i.is_ss,i.scale,i.label,i.salary,work_hours,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,i.cover,i.hr_headimg,i.principal')
  774. ->leftJoin('Recruit i','t.coll_id = i.id')
  775. ->order('id desc')
  776. ->limit($this->off_set,$this->page_num)
  777. ->select()->toArray();
  778. foreach ($list as &$v) {
  779. $v['label_name'] = $v['label']? explode(',',trim($v['label'],',')) : null;
  780. $v['welfare_arr'] = explode(',',trim($v['welfare'],','));
  781. $v['is_normal'] = CheckPower::checkModulesPower($v['recruit_id'],0,$this->request->controller());
  782. $auth_info = \app\common\model\Recruit::getAuth($v['user_id'],APPNAME,APPLOGO);
  783. $v['app_name'] = $auth_info['app_name'];
  784. $v['app_logo'] = $auth_info['app_logo'];
  785. }
  786. $total_num = UserCollect::where($sel_where)->alias('t')->leftJoin('Recruit i','t.coll_id = i.id')->count();
  787. $this->success('ok', ['list' => $list, 'total_count' => $total_num, 'page_num' => $this->page_num]);
  788. }
  789. /**
  790. * @title 我的订阅
  791. * @desc 我的订阅
  792. * @author qc
  793. * @method GET
  794. * @url /api/Recruit/getFollowUpList
  795. * @header name:Authorization require:1 desc:Token
  796. * @param name:title type:string default:-- desc:标题
  797. * @param name:page type:int default:0 desc:页数
  798. * @param name:page_num type:int default:20 desc:每页数
  799. * @return name:create_at type:string default:-- desc:追更设置时间
  800. * @return name:cate_id type:int default:-- desc:招聘分类id
  801. * @return name:title type:string default:-- desc:标题
  802. * @return name:logo type:string default:-- desc:分类图片
  803. */
  804. public function getFollowUpList()
  805. {
  806. $sel_where = [];
  807. $sel_where[] = ['p.user_id','=',$this->user_id];
  808. $sel_where[] = ['p.type','=',6];
  809. $sel_where[] = ['p.switch_value','=',1];
  810. $field = 'p.id,p.switch_id as cate_id,p.create_at,a.title,a.logo';
  811. $list = PlatformSwitch::field($field)
  812. ->alias('p')
  813. ->leftJoin('RecruitCate a','p.switch_id = a.id')
  814. ->where($sel_where)
  815. ->limit($this->off_set,$this->page_num)
  816. ->order('p.id desc')
  817. ->select()->toArray();
  818. $total_num = PlatformSwitch::alias('p')->leftJoin('RecruitCate a','p.switch_id = a.id') ->where($sel_where)->count();
  819. $this->success('ok', ['list' => $list, 'total_count' => $total_num, 'page_num' => $this->page_num]);
  820. }
  821. /**
  822. * @title 订阅消息
  823. * @desc 订阅消息
  824. * @author qc
  825. * @method GET
  826. * @url /api/Recruit/getFollowUpMessage
  827. * @header name:Authorization require:1 desc:Token
  828. * @param name:page type:int default:-- desc:页数
  829. * @param name:page_num type:int default:-- desc:每页数
  830. * @return name:id type:int default:-- desc:记录id
  831. * @return name:title type:string default:-- desc:标题
  832. * @return name:content type:string default:-- desc:内容
  833. * @return name:create_at type:string default:-- desc:时间
  834. * @return name:is_read type:int default:-- desc:是否已读【0否1是】
  835. * @return name:is_normal type:int default:-- desc:是否是正常记录(0已删除或是已禁用1可以正常跳转详情)
  836. */
  837. public function getFollowUpMessage()
  838. {
  839. $list = UserMessage::where(['m.user_id'=>$this->user_id,'m.is_deleted'=>0,'m.module'=>'recruit'])->where('m.type_id','in','4,5')->alias('m')
  840. ->field('m.id,m.create_at,m.is_read,m.children_id recruit_id,m.content,m.type_id')
  841. ->limit($this->off_set,$this->page_num)
  842. ->order(['m.id'=>'desc'])
  843. ->select()->toArray();
  844. array_walk($list,function (&$v){
  845. $v['is_normal'] = CheckPower::checkModulesPower($v['recruit_id'], 0, $this->request->controller(),$v['type_id']);
  846. });
  847. $total_num = UserMessage::where(['m.user_id'=>$this->user_id,'m.is_deleted'=>0,'m.module'=>'recruit'])->where('m.type_id','in','4,5')->alias('m')->count();
  848. $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
  849. }
  850. /**
  851. * @title 获取角标数量
  852. * @desc 获取角标数量
  853. * @author qc
  854. * @method GET
  855. * @url /api/Recruit/getMarkNum
  856. * @header name:Authorization require:1 desc:Token
  857. * @return name:praise_num type:int default:-- desc:点赞我的
  858. * @return name:follow_num type:int default:-- desc:我的订阅
  859. * @return name:resume_num type:int default:-- desc:给我投的
  860. * @return name:total_num type:int default:-- desc:总数
  861. */
  862. public function getMarkNum()
  863. {
  864. $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();
  865. $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();
  866. //1.返回一下给我投的角标数量
  867. $recruits = \app\common\model\Recruit::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
  868. $resume_num = RecruitResume::where('recruit_id','in',$recruits)->where('is_deleted',0)->where('to_deleted',0)->where('is_read',0)->count();
  869. // $ids_str = implode(',',$recruit_ids);
  870. // $resume_num = \app\common\model\Recruit::where(['r.user_id'=>$this->user_id,'r.is_deleted'=>0,]) ->alias('r') ->where('r.id','in',$ids_str)
  871. // ->field('r.id,IFNULL( (SELECT count( s.id) FROM dd_recruit_resume as s WHERE r.id=s.recruit_id ),0) as re_num')
  872. // ->order('r.id desc')->count();
  873. $total_num = $praise_num + $follow_num + $resume_num;
  874. $this->success('ok',compact(['praise_num','follow_num','resume_num','total_num']));
  875. }
  876. /**
  877. * @title 批量删除||批量取消
  878. * @desc 删除||取消
  879. * @author qc
  880. * @method POST
  881. * @url /api/Recruit/batchesDel
  882. * @header name:Authorization require:1 desc:Token
  883. * @param name:id type:string default:1 desc:记录id【多个用逗号隔开=>'1,2'】
  884. * @param name:type type:string default:1 desc:消息类型【1点赞我的,2我的点赞,3我的收藏,4给我投的--简历列表,5订阅消息,6我的订阅】
  885. */
  886. public function batchesDel()
  887. {
  888. $type = input('post.type',1);
  889. $id = input('post.id');
  890. if(!$id) $this->error('请选择要删除的记录');
  891. $del_where = [];
  892. $del_where[] = ['id','in',$id];
  893. if(in_array($type,[2,3,5,6])) $del_where[] = ['user_id','=',$this->user_id];
  894. if(in_array($type,[1])) PlatformLike::where($del_where)->update(['to_deleted'=>1,'is_read'=>1]);
  895. if(in_array($type,[2])) PlatformLike::where($del_where)->where('user_id',$this->user_id)->delete();
  896. if(in_array($type,[3])) UserCollect::where($del_where)->where('user_id',$this->user_id)->where('coll_type',8)->delete();
  897. if(in_array($type,[4])) RecruitResume::where($del_where)->update(['to_deleted'=>1,'is_read'=>1]);
  898. if(in_array($type,[5])) UserMessage::where($del_where)->update(['is_deleted'=>1]);
  899. if(in_array($type,[6])) PlatformSwitch::where($del_where)->delete();
  900. $this->success('操作成功');
  901. }
  902. /**
  903. * @title 消息已读未读变更
  904. * @desc 消息已读
  905. * @author qc
  906. * @method POST
  907. * @url /api/Recruit/unreadChange
  908. * @header name:Authorization require:1 desc:Token
  909. * @param name:id type:string default:-- desc:记录id(多个逗号隔开,不传修改全部])
  910. * @param name:type type:string default:1 desc:消息类型【1给我投的--简历列表,2订阅消息,3点赞我的】
  911. * @param name:is_read type:int default:1 desc:变更类型【0消息变更为未读,1变更为已读】
  912. */
  913. public function unreadChange()
  914. {
  915. $type = input('post.type',1);
  916. $id = input('post.id');
  917. $is_read = input('post.is_read');
  918. switch ($type) {
  919. case 1:
  920. $recruit_ids = \app\common\model\Recruit::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
  921. RecruitResume::where(['r.is_deleted'=>0,'r.to_deleted'=>0])
  922. ->where('r.recruit_id','in',$recruit_ids)
  923. ->alias('r')
  924. ->when($id ,function ($query)use ($id){
  925. if($id) return $query->where('r.id','in',$id);
  926. })->update(['is_read'=>$is_read]);
  927. break;
  928. case 2:
  929. $where[] = ['user_id','=',$this->user_id];
  930. $where[] = ['module','=','recruit'];
  931. if($id) $where[] = ['id','in',$id];
  932. UserMessage::where($where)->update(['is_read'=>$is_read]);
  933. break;
  934. case 3:
  935. PlatformLike::where([['p.type', '=', 5],['f.user_id', '=', $this->user_id]])
  936. ->alias('p') ->leftJoin('Recruit f', 'f.id = p.like_id')->update(['p.is_read'=>$is_read]);
  937. break;
  938. }
  939. $this->success('操作成功');
  940. }
  941. }