Comjobs.php 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645
  1. <?php
  2. namespace app\admin\controller;
  3. use app\admin\BaseController;
  4. use app\common\model\RensheCode;
  5. use app\common\model\Worker as WorkerModel;
  6. use app\common\model\Comjobs as ComjobsModel;
  7. use app\common\model\ComjobsCate as ComjobsCateModel;
  8. use app\common\model\ComjobsLog as ComjobsLogModel;
  9. use app\common\model\ComjobsStar as ComjobsStarModel;
  10. use app\common\model\ComjobsShare as ComjobsShareModel;
  11. use app\common\service\RensheService;
  12. use app\common\validate\Comjobs as ComjobsValidate;
  13. use think\exception\ValidateException;
  14. use think\facade\Db;
  15. use think\facade\Log;
  16. class Comjobs extends BaseController
  17. {
  18. // 报名记录
  19. public function logList()
  20. {
  21. $workerlist = WorkerModel::with('comjobs')->order(['id' => 'desc'])->select();
  22. return view('comjobs/loglist', [
  23. 'workerlist' => $workerlist,
  24. ]);
  25. }
  26. public function delLog()
  27. {
  28. $idarr = input('idarr/a');
  29. $log = ComjobsLogModel::whereIn('id', $idarr)->select();
  30. $result = $log->delete();
  31. if ($result) {
  32. exit(json_encode([
  33. 'code' => 0,
  34. 'msg' => "",
  35. ]));
  36. }
  37. exit(json_encode([
  38. 'code' => 1,
  39. 'msg' => "删除失败,请稍后重试",
  40. ]));
  41. }
  42. public function fieldLog()
  43. {
  44. $id = input('id/d', 0);
  45. $log = ComjobsLogModel::findOrEmpty($id);
  46. if ($log->isEmpty()) {
  47. exit(json_encode([
  48. 'code' => 1,
  49. 'msg' => "信息不存在",
  50. ]));
  51. } else {
  52. $log->save([
  53. input('field/s') => input('value'),
  54. ]);
  55. }
  56. exit(json_encode([
  57. 'code' => 0,
  58. ]));
  59. }
  60. public function listLog()
  61. {
  62. $limit = input('limit/d', 20);
  63. $page = input('page/d', 1);
  64. $map = [];
  65. $workercomjobsarr = explode(",", input('workercomjobs/s'));
  66. $workerid = isset($workercomjobsarr[0]) ? $workercomjobsarr[0] : 0;
  67. $comjobsid = isset($workercomjobsarr[1]) ? $workercomjobsarr[1] : 0;
  68. if (!empty($workerid)) {
  69. $map[] = ['workerid', '=', $workerid];
  70. }
  71. if (!empty($comjobsid)) {
  72. $map[] = ['comjobsid', '=', $comjobsid];
  73. }
  74. $status = input('status/d', 0);
  75. if (!empty($status)) {
  76. $map[] = ['status', '=', $status];
  77. }
  78. $list = ComjobsLogModel::with(['user', 'worker', 'comjobs'])->where($map)->order('id', 'DESC')->limit($limit)->page($page)->append(['status_text'])->select();
  79. $count = ComjobsLogModel::where($map)->count();
  80. if ($count == 0) {
  81. exit(json_encode([
  82. 'code' => 1,
  83. 'msg' => "未查询到数据",
  84. ]));
  85. }
  86. exit(json_encode([
  87. 'code' => 0,
  88. 'msg' => "",
  89. 'count' => $count,
  90. 'data' => $list,
  91. ]));
  92. }
  93. public function exportLog()
  94. {
  95. $map = [];
  96. $workercomjobsarr = explode(",", input('workercomjobs/s'));
  97. $workerid = isset($workercomjobsarr[0]) ? $workercomjobsarr[0] : 0;
  98. $comjobsid = isset($workercomjobsarr[1]) ? $workercomjobsarr[1] : 0;
  99. if (!empty($workerid)) {
  100. $map[] = ['workerid', '=', $workerid];
  101. }
  102. if (!empty($comjobsid)) {
  103. $map[] = ['comjobsid', '=', $comjobsid];
  104. }
  105. $status = input('status/d', 0);
  106. if (!empty($status)) {
  107. $map[] = ['status', '=', $status];
  108. }
  109. $xlsData = ComjobsLogModel::with(['user', 'worker', 'comjobs'])->where($map)->order('id', 'DESC')->append(['status_text'])->select()->toArray();
  110. $xlsCell = [
  111. ['id', '表ID'],
  112. ['user.nickname', '昵称'],
  113. ['user.realname', '姓名'],
  114. ['user.mobile', '手机号'],
  115. ['worker.title', '劳务公司'],
  116. ['comjobs.title', '招聘标题'],
  117. ['status_text', '公司反馈'],
  118. ['remark', '反馈备注'],
  119. ['createtime', '报名时间'],
  120. ];
  121. export_excel("招聘报名记录", $xlsCell, $xlsData);
  122. }
  123. // 企业招聘
  124. public function comjobsList()
  125. {
  126. $workerlist = WorkerModel::order(['id' => 'desc'])->select();
  127. $catelist = ComjobsCateModel::order(['priority' => 'desc', 'id' => 'desc'])->select();
  128. return view('comjobs/comjobslist', [
  129. 'workerlist' => $workerlist,
  130. 'catelist' => $catelist,
  131. ]);
  132. }
  133. public function comjobsForm()
  134. {
  135. $id = input('id/d, 0');
  136. $comjobs = ComjobsModel::findOrEmpty($id);
  137. $workerlist = WorkerModel::order(['id' => 'desc'])->select();
  138. $catelist = ComjobsCateModel::order(['priority' => 'desc', 'id' => 'desc'])->select();
  139. $communitylist = RensheCode::getList('community');
  140. $agelist = RensheCode::getList('age');
  141. $educationlist = RensheCode::getList('education');
  142. $emptimelist = RensheCode::getList('emp_time');
  143. $welfarelist = RensheCode::getList('welfare');
  144. return view('comjobs/comjobsform', [
  145. 'catelist' => $catelist,
  146. 'workerlist' => $workerlist,
  147. 'communitylist' => $communitylist,
  148. 'agelist' => $agelist,
  149. 'educationlist' => $educationlist,
  150. 'emptimelist' => $emptimelist,
  151. 'welfarelist' => $welfarelist,
  152. 'comjobs' => $comjobs,
  153. ]);
  154. }
  155. public function editComjobs()
  156. {
  157. $id = input('id/d', 0);
  158. $wtype = input('wtype/d', 1);
  159. $zwagall = $wtype == 1 ? input('zwagall/s', "") : '';
  160. $data = [
  161. 'workerid' => input('workerid/d', 0),
  162. 'title' => input('title/s', ""),
  163. 'cateid' => input('cateid/d', 0),
  164. 'province' => input('province/s', ""),
  165. 'city' => input('city/s', ""),
  166. 'district' => input('district/s', ""),
  167. 'agegroup' => input('agegroup/s', ""),
  168. 'tags' => array_values(input('tags/a', [])),
  169. 'enddate' => input('enddate/s', ""),
  170. 'requirement' => input('requirement/s', ""),
  171. 'comdetails' => input('comdetails/s', ""),
  172. 'companydetails' => input('companydetails/s', ""),
  173. 'retmoney' => input('retmoney/d', ""),
  174. 'picall' => input('picall/a', []),
  175. 'recruit_num' => input('recruit_num/d', 1),
  176. 'wtype' => $wtype,
  177. 'bwagall' => input('bwagall/s', ""),
  178. 'zwagall' => $zwagall,
  179. 'fwagall' => input('fwagall/s', ""),
  180. 'telephone' => input('telephone/s', ""),
  181. 'remark' => input('remark/s', ""),
  182. 'status' => input('status/d', 1),
  183. 'priority' => input('priority/d', 0),
  184. 'updatetime' => input('updatetime/s', ""),
  185. 'createtime' => input('createtime/s', ""),
  186. 'volume' => input('volume/d', 0),
  187. 'recruitment_cate' => input('recruitment_cate/d', 1),
  188. 'latitude' => input('latitude/f', 0),
  189. 'longitude' => input('longitude/f', 0),
  190. 'address' => input('address/s', ''),
  191. 'community' => input('community/s', ''),
  192. 'is_worry' => input('is_worry/d', 0),
  193. 'education' => input('education/s', ''),
  194. 'emp_time' => array_values(input('emp_time/a', [])),
  195. ];
  196. try {
  197. validate(ComjobsValidate::class)->check($data);
  198. } catch (ValidateException $e) {
  199. exit(json_encode([
  200. 'code' => 1,
  201. 'msg' => $e->getError(),
  202. ]));
  203. }
  204. if (empty($id)) {
  205. $data['video'] = input('new_video/s', "");
  206. ComjobsModel::create($data);
  207. } else {
  208. $old_video = input('old_video/s', '');
  209. $new_video = input('new_video/s', '');
  210. if (!empty($new_video)) {
  211. $data['video'] = $new_video;
  212. } else {
  213. if (!empty($old_video)) {
  214. $data['video'] = $old_video;
  215. }
  216. }
  217. $comjobs = ComjobsModel::find($id);
  218. ComjobsLogModel::update(['workerid' => input('workerid/d', 0)], ['comjobsid' => $comjobs->id]);
  219. $comjobs->save($data);
  220. }
  221. exit(json_encode([
  222. 'code' => 0,
  223. ]));
  224. }
  225. public function fieldComjobs()
  226. {
  227. $id = input('id/d', 0);
  228. $comjobs = ComjobsModel::findOrEmpty($id);
  229. if ($comjobs->isEmpty()) {
  230. exit(json_encode([
  231. 'code' => 1,
  232. 'msg' => "信息不存在",
  233. ]));
  234. } else {
  235. $comjobs->save([
  236. input('field/s') => input('value'),
  237. ]);
  238. }
  239. exit(json_encode([
  240. 'code' => 0,
  241. ]));
  242. }
  243. public function delComjobs()
  244. {
  245. $idarr = input('idarr/a');
  246. ComjobsLogModel::whereIn('comjobsid', $idarr)->delete();
  247. ComjobsStarModel::whereIn('comjobsid', $idarr)->delete();
  248. $result = Db::name('comjobs')->whereIn('id', $idarr)->update(['deletetime' => time()]);
  249. if ($result) {
  250. exit(json_encode([
  251. 'code' => 0,
  252. 'msg' => "",
  253. ]));
  254. }
  255. exit(json_encode([
  256. 'code' => 1,
  257. 'msg' => "删除失败,请稍后重试",
  258. ]));
  259. }
  260. public function listComjobs()
  261. {
  262. $limit = input('limit/d', 20);
  263. $page = input('page/d', 1);
  264. $map = [];
  265. $keywords = input('keywords/s', "");
  266. if (!empty($keywords)) {
  267. $map[] = ['title', 'like', '%' . $keywords . '%'];
  268. }
  269. $workerid = input('workerid/d', 0);
  270. if (!empty($workerid)) {
  271. $map[] = ['workerid', '=', $workerid];
  272. }
  273. $cateid = input('cateid/d', 0);
  274. if (!empty($cateid)) {
  275. $map[] = ['cateid', '=', $cateid];
  276. }
  277. $wtype = input('wtype/d');
  278. if (!empty($wtype)) {
  279. $map[] = ['wtype', '=', $wtype];
  280. }
  281. $status = input('status/d');
  282. if (!empty($status)) {
  283. $map[] = ['status', '=', $status];
  284. }
  285. $daterange = input('daterange/s', "");
  286. if (!empty($daterange)) {
  287. $daterangearr = explode("~", $daterange);
  288. $map[] = ['createtime', '>= time', trim($daterangearr[0])];
  289. $map[] = ['createtime', '<= time', trim($daterangearr[1])];
  290. }
  291. $list = ComjobsModel::with(['worker', 'comjobsCate'])->withCount(['comjobsLog'])->where($map)->order(['priority' => 'desc', 'id' => 'desc',])->limit($limit)->page($page)->append(['wtype_text', 'status_text'])->select();
  292. $count = ComjobsModel::where($map)->count();
  293. foreach ($list as $v) {
  294. if (!empty($v['company_name'])) {
  295. $v['worker']['title'] = $v['company_name'];
  296. }
  297. }
  298. if ($count == 0) {
  299. exit(json_encode([
  300. 'code' => 1,
  301. 'msg' => "未查询到数据",
  302. ]));
  303. }
  304. exit(json_encode([
  305. 'code' => 0,
  306. 'msg' => "",
  307. 'count' => $count,
  308. 'data' => $list,
  309. ]));
  310. }
  311. // 岗位类型
  312. public function cateList()
  313. {
  314. return view('comjobs/catelist');
  315. }
  316. public function cateForm()
  317. {
  318. $id = input('id/d', 0);
  319. $cate = ComjobsCateModel::findOrEmpty($id);
  320. return view('comjobs/cateform', [
  321. 'cate' => $cate,
  322. ]);
  323. }
  324. public function listCate()
  325. {
  326. $limit = input('limit');
  327. $page = input('page');
  328. $list = ComjobsCateModel::order(['priority' => 'desc', 'id' => 'desc'])->limit($limit)->page($page)->select();
  329. $count = ComjobsCateModel::count();
  330. if ($count == 0) {
  331. exit(json_encode([
  332. 'code' => 1,
  333. 'msg' => "未查询到数据",
  334. ]));
  335. }
  336. exit(json_encode([
  337. 'code' => 0,
  338. 'msg' => "",
  339. 'count' => $count,
  340. 'data' => $list,
  341. ]));
  342. }
  343. public function fieldCate()
  344. {
  345. $id = input('id/d', 0);
  346. $info = ComjobsCateModel::find($id);
  347. $info->save([
  348. input('field/s') => input('value/s', ""),
  349. ]);
  350. exit(json_encode([
  351. 'code' => 0,
  352. ]));
  353. }
  354. public function editCate()
  355. {
  356. $id = input('id/d');
  357. if (empty($id)) {
  358. $cate = ComjobsCateModel::create([
  359. 'title' => input('title/s', ""),
  360. 'priority' => input('priority/d', 0),
  361. ]);
  362. } else {
  363. $cate = ComjobsCateModel::find($id);
  364. $cate->save([
  365. 'title' => input('title/s', ""),
  366. 'priority' => input('priority/d', 0),
  367. ]);
  368. }
  369. exit(json_encode([
  370. 'code' => 0,
  371. ]));
  372. }
  373. public function delCate()
  374. {
  375. $id = input('id/d');
  376. $cate = ComjobsCateModel::where('id', $id)->select();
  377. $result = $cate->delete();
  378. if ($result) {
  379. exit(json_encode([
  380. 'code' => 0,
  381. 'msg' => "",
  382. ]));
  383. }
  384. exit(json_encode([
  385. 'code' => 1,
  386. 'msg' => "删除失败,请稍后重试",
  387. ]));
  388. }
  389. // 推广海报
  390. public function shareList()
  391. {
  392. return view('comjobs/sharelist', []);
  393. }
  394. public function shareForm()
  395. {
  396. $id = input('id/d', 0);
  397. $share = ComjobsShareModel::findOrEmpty($id);
  398. return view('comjobs/shareform', [
  399. 'share' => $share,
  400. ]);
  401. }
  402. public function editShare()
  403. {
  404. $id = input('id/d', 0);
  405. $data = [
  406. 'title' => input('title/s', ""),
  407. 'tilpic' => input('tilpic/s', ""),
  408. 'status' => input('status/d', 1),
  409. 'priority' => input('priority/d', 0),
  410. ];
  411. if (empty($id)) {
  412. $share = ComjobsShareModel::create($data);
  413. } else {
  414. $share = ComjobsShareModel::find($id);
  415. $share->save($data);
  416. }
  417. exit(json_encode([
  418. 'code' => 0,
  419. ]));
  420. }
  421. public function listShare()
  422. {
  423. $limit = input('limit');
  424. $page = input('page');
  425. $map = [];
  426. $status = input('status/d', 0);
  427. if (!empty($status)) {
  428. $map[] = ['status', '=', $status];
  429. }
  430. $list = ComjobsShareModel::where($map)->order(['priority' => 'desc', 'id' => 'desc'])->limit($limit)->page($page)->append(['status_text'])->select();
  431. $count = ComjobsShareModel::where($map)->count();
  432. if ($count == 0) {
  433. exit(json_encode([
  434. 'code' => 1,
  435. 'msg' => "未查询到数据",
  436. ]));
  437. }
  438. exit(json_encode([
  439. 'code' => 0,
  440. 'msg' => "",
  441. 'count' => $count,
  442. 'data' => $list,
  443. ]));
  444. }
  445. public function fieldShare()
  446. {
  447. $id = input('id/d', 0);
  448. $info = ComjobsShareModel::find($id);
  449. $info->save([
  450. input('field/s') => input('value/s', ""),
  451. ]);
  452. exit(json_encode([
  453. 'code' => 0,
  454. ]));
  455. }
  456. public function delShare()
  457. {
  458. $id = input('id/d', 0);
  459. $share = ComjobsShareModel::where('id', $id)->select();
  460. $result = $share->delete();
  461. if ($result) {
  462. exit(json_encode([
  463. 'code' => 0,
  464. 'msg' => "",
  465. ]));
  466. }
  467. exit(json_encode([
  468. 'code' => 1,
  469. 'msg' => "删除失败,请稍后重试",
  470. ]));
  471. }
  472. public function synRenshe()
  473. {
  474. //获取数据
  475. $id = input('id/d', 0);
  476. $info = ComjobsModel::with([
  477. 'worker',
  478. 'comjobsCate',
  479. 'worker',
  480. 'ageCode' => function ($query) {
  481. $query->where('type', 'age');
  482. }, 'educationCode' => function ($query) {
  483. $query->where('type', 'education');
  484. }])->find($id);
  485. //数据重组
  486. $list = $item = [];
  487. $item['baz367'] = $info['id'];
  488. if (!empty($info['comjobsCate']['code'])) {
  489. $item['aca111'] = $info['comjobsCate']['code'];
  490. }
  491. $item['aca112'] = $info['title'];
  492. $item['bcz002'] = $info['wtype'];
  493. $item['bcz017'] = $info['zwagall'];
  494. $item['cae006'] = $info['community'];
  495. $item['cae007'] = $info['province'] . $info['city'] . $info['district'] . $info['address'];
  496. if (!empty($info['educationCode']['code'])) {
  497. $item['aac011'] = $info['educationCode']['code'];
  498. }
  499. if (!empty($info['ageCode']['code'])) {
  500. $item['bcz006'] = $info['ageCode']['code'];
  501. }
  502. $item['bcz019'] = implode(',', $info['tags']);
  503. // $item['caa004s'] = $info['tags_code'];
  504. $item['bcz007'] = $info['comdetails'];
  505. $item['bcz008'] = $info['requirement'];
  506. $item['bcz009'] = $info['worker']['wtype'];
  507. if (!empty($info['company_name'])) {
  508. $item['aab069'] = $info['company_name'];
  509. $item['aae004'] = $info['contact'];
  510. $item['aae006'] = $info['province'] . $info['city'] . $info['district'] . $info['address'];
  511. } else {
  512. $item['aab069'] = $info['worker']['title'];
  513. $item['aae004'] = $info['worker']['realname'];
  514. $item['aae006'] = $info['worker']['province'] . $info['worker']['city'] . $info['worker']['district'] . $info['worker']['address'];
  515. }
  516. $item['aae005'] = $info['telephone'];
  517. $item['bcz018'] = $info['emp_code'];
  518. $item['bcz011'] = $info['is_worry'];
  519. $item['bcz015'] = $info['longitude'];
  520. $item['bcz016'] = $info['latitude'];
  521. $item['bye002'] = $info['updatetime'];
  522. $item = array_filter($item);
  523. $item['aae100'] = $info['status'] == 3 ? 1 : 0;
  524. $list[] = $item;
  525. $send['list'] = $list;
  526. //发送数据
  527. Log::info('同步人社数据:' . json_encode($send));
  528. $service = new RensheService($send);
  529. $res = $service->JobInfo();
  530. Log::error('同步人社返回数据:' . json_encode($res));
  531. if ($res['code'] == 200) {
  532. return json(['code' => 0]);
  533. } else {
  534. return json([
  535. 'code' => 1,
  536. 'msg' => '网络异常,请重试',
  537. ]);
  538. }
  539. }
  540. public function import()
  541. {
  542. $data = ['cate', 'title', 'type', 'zwagall', 'community', 'province', 'city', 'district', 'education', 'agegroup', 'tags', 'comdetails', 'requirement',
  543. 'worker', 'telephone', 'name', 'address', 'time', 'emp_time', 'is_worry'];
  544. $list = importExecl('21.xlsx', $data, 2);
  545. $data = [];
  546. $wtype = ['按月' => 1, '按时' => 2, '按件' => 3, '按项目' => 4, '面议' => 5];
  547. $rensheCode = RensheCode::select();
  548. $renshe = [];
  549. foreach ($rensheCode as $v) {
  550. $renshe[$v['type']][$v['name']] = $v['code'];
  551. }
  552. $cateList = ComjobsCateModel::column('id', 'title');
  553. foreach ($list as $v) {
  554. if (empty($v['cate'])) {
  555. continue;
  556. }
  557. $item = [];
  558. if (empty($cateList[$v['cate']])) {
  559. halt($cateList, $v);
  560. }
  561. $item['cateid'] = $cateList[$v['cate']];
  562. $item['title'] = $v['title'];
  563. $item['wtype'] = $wtype[$v['type']];
  564. $item['zwagall'] = $v['zwagall'];
  565. if (!empty($renshe['community'][$v['community']])) {
  566. $item['community'] = $renshe['community'][$v['community']];
  567. }
  568. $item['province'] = $v['province'];
  569. $item['city'] = $v['city'];
  570. $item['district'] = $v['district'];
  571. if (!empty($renshe['education'][$v['education']])) {
  572. $item['education'] = $v['education'];
  573. }
  574. if (!empty($renshe['age'][$v['agegroup']])) {
  575. $item['agegroup'] = $v['agegroup'];
  576. }
  577. $tags = explode(',', $v['tags']);
  578. if (empty($tags[0])) {
  579. $tags = [];
  580. }
  581. $item['tags'] = $tags;
  582. $item['comdetails'] = $v['comdetails'];
  583. $item['requirement'] = $v['requirement'];
  584. $item['workerid'] = 8;
  585. $item['telephone'] = (string)$v['telephone'];
  586. $item['address'] = (string)$v['address'];
  587. $emp_time = explode(',', $v['emp_time']);
  588. if (empty($emp_time[0])) {
  589. $emp_time = [];
  590. }
  591. $item['emp_time'] = $emp_time;
  592. $item['is_worry'] = $v['is_worry'] ? $v['is_worry'] : 0;
  593. $item['priority'] = 0;
  594. $item['status'] = 3;
  595. $item['createtime'] = $item['updatetime'] = time();
  596. $data[] = $item;
  597. }
  598. foreach ($data as $v) {
  599. ComjobsModel::create($v);
  600. }
  601. }
  602. }