Comjobsreport.php 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424
  1. <?php
  2. namespace app\worker\controller;
  3. use app\common\service\ComjobsService;
  4. use app\common\service\IncomeService;
  5. use app\worker\BaseController;
  6. use app\common\model\ComjobsReport as ComjobsReportModel;
  7. use app\common\model\ReportLog as ReportLogModel;
  8. use app\common\model\Comjobs as ComjobsModel;
  9. use app\common\model\Agent as AgentModel;
  10. use app\common\validate\Report as ReportValidate;
  11. use think\exception\ValidateException;
  12. use think\facade\Db;
  13. class Comjobsreport extends BaseController
  14. {
  15. // 报备记录
  16. public function reportList()
  17. {
  18. $workerid = $this->access_worker['id'];
  19. $comjobslist = ComjobsModel::where('workerid', $workerid)->select();
  20. $agentlist = Db::name('agent')
  21. ->alias('a')
  22. ->field('a.id,a.title')
  23. ->join('worker b', 'b.id = a.workerid', 'LEFT')
  24. ->where('a.workerid', $workerid)
  25. ->select()
  26. ->toArray();
  27. $statusarr = [1 => '待审核', 2 => '待面试', 3 => '已入职', 4 => '无效报备'];
  28. return view('comjobsreport/reportlist', [
  29. 'comjobslist' => $comjobslist,
  30. 'agentlist' => $agentlist,
  31. 'statusarr' => $statusarr,
  32. ]);
  33. }
  34. // 报备记录(待审核)
  35. public function reportExamine()
  36. {
  37. $workerid = $this->access_worker['id'];
  38. $comjobslist = ComjobsModel::where('workerid', $workerid)->select();
  39. $agentlist = Db::name('agent')
  40. ->alias('a')
  41. ->field('a.id,a.title')
  42. ->join('worker b', 'b.id = a.workerid', 'LEFT')
  43. ->where('a.workerid', $workerid)
  44. ->select()
  45. ->toArray();
  46. $statusarr = [1 => '待审核', 2 => '待面试', 3 => '已入职', 4 => '无效报备'];
  47. return view('comjobsreport/reportexamine', [
  48. 'comjobslist' => $comjobslist,
  49. 'agentlist' => $agentlist,
  50. 'statusarr' => $statusarr,
  51. ]);
  52. }
  53. public function listReport()
  54. {
  55. $limit = input('limit/d', 20);
  56. $page = input('page/d', 1);
  57. $workerid = $this->access_worker['id'];
  58. $map = [];
  59. $map[] = ['workerid', '=', $workerid];
  60. $date6 = input('date6');
  61. if (!empty($date6)) {
  62. $date6 = explode('~', $date6);
  63. $startTime = strtotime($date6[0]);
  64. $endTime = strtotime($date6[1]);
  65. $map[] = ['createtime', 'between', [$startTime, $endTime]];
  66. }
  67. $comjobsid = input('comjobsid/d', 0);
  68. if (!empty($comjobsid)) {
  69. $map[] = ['comjobsid', '=', $comjobsid];
  70. }
  71. $agentid = input('agentid/s', "");
  72. if ($agentid != "") {
  73. $map[] = ['agentid', '=', intval($agentid)];
  74. }
  75. $status = input('status/d', 0);
  76. if (!empty($status)) {
  77. $map[] = ['status', '=', $status];
  78. }
  79. $count = ComjobsReportModel::where($map)->count();
  80. if ($count == 0) {
  81. exit(json_encode([
  82. 'code' => 1,
  83. 'msg' => "未查询到数据",
  84. ]));
  85. }
  86. $list = ComjobsReportModel::with(['comjobs','agent','broker'])
  87. ->where($map)
  88. ->order('id', 'DESC')
  89. ->limit($limit)
  90. ->page($page)
  91. ->append(['status_text'])
  92. ->select();
  93. foreach ($list as $v) {
  94. $v['comjob_title'] = $v['comjobs']['title'];
  95. $v['agent_title'] = $v['agent']['title'];
  96. $v['broker_title'] = $v['broker']['title'];
  97. }
  98. exit(json_encode([
  99. 'code' => 0,
  100. 'msg' => "",
  101. 'count' => $count,
  102. 'data' => $list,
  103. ]));
  104. }
  105. public function exportReport()
  106. {
  107. $map = [];
  108. $comjobsid = input('comjobsid/d', 0);
  109. if (!empty($comjobsid)) {
  110. $map[] = ['comjobsid', '=', $comjobsid];
  111. }
  112. $agentid = input('agentid/d', 0);
  113. if (!empty($agentid)) {
  114. $map[] = ['agentid', '=', $agentid];
  115. }
  116. $status = input('status/d', 0);
  117. if (!empty($status)) {
  118. $map[] = ['status', '=', $status];
  119. }
  120. $xlsData = ComjobsReportModel::with(['comjobs', 'agent', 'broker'])->where($map)->order('id', 'DESC')->append(['status_text'])->select()->toArray();
  121. $xlsCell = [
  122. ['id', '表ID'],
  123. ['comjobs.title', '招聘标题'],
  124. ['agent.title', '代理门店'],
  125. ['broker.title', '经纪人'],
  126. ['realname', '姓名'],
  127. ['mobile', '手机号'],
  128. ['idcard', '身份证号'],
  129. ['arrivetime', '预计到达时间'],
  130. ['remark', '报名备注'],
  131. ['status_text', '状态'],
  132. ['createtime', '接单时间'],
  133. ];
  134. export_excel("报备记录", $xlsCell, $xlsData);
  135. }
  136. public function setComtype()
  137. {
  138. $idarr = input('idarr/a');
  139. $comjobsid = input('comjobsid/d', 0);
  140. $comjobs = ComjobsModel::with(['company'])->findOrEmpty($comjobsid);
  141. if ($comjobs->isEmpty()) {
  142. exit(json_encode([
  143. 'code' => 1,
  144. 'msg' => "请选择招聘信息和代理门店",
  145. ]));
  146. }
  147. $data = [
  148. 'comjobsid' => $comjobs->id,
  149. 'comtype' => input('comtype/s', ""),
  150. 'comprice' => input('comprice/s', ""),
  151. 'comremark' => input('comremark/s', ""),
  152. 'updatetime' => input('updatetime/s', date("Y-m-d H:i")),
  153. ];
  154. ComjobsReportModel::whereIn('id', $idarr)->update($data);
  155. $reportall = ComjobsReportModel::whereIn('id', $idarr)->select()->toArray();
  156. $logdata = [];
  157. $statusarr = [1 => '待审核', 2 => '待面试', 3 => '已入职', 4 => '无效报备'];
  158. $agentall = AgentModel::column('realname', 'id');
  159. foreach ($reportall as $key => $item) {
  160. $logdata[] = [
  161. 'reportid' => $item['id'],
  162. 'logstatus' => $statusarr[$item['status']],
  163. 'editrealname' => "管理员",
  164. 'comjobstil' => $comjobs->isEmpty() ? "" : $comjobs->title,
  165. 'agenttil' => empty($agentall[$item['agentid']]) ? "未报备" : $agentall[$item['agentid']],
  166. 'realname' => $item['realname'],
  167. 'mobile' => $item['mobile'],
  168. 'idcard' => $item['idcard'],
  169. 'comtype' => input('comtype/s', ""),
  170. 'comprice' => input('comprice/s', ""),
  171. 'comremark' => input('comremark/s', ""),
  172. 'arrivetime' => $item['arrivetime'],
  173. 'remark' => $item['remark'],
  174. 'createtime' => date("Y-m-d H:i"),
  175. ];
  176. }
  177. $reportlog = new ReportLogModel;
  178. $reportlog->saveAll($logdata);
  179. exit(json_encode([
  180. 'code' => 0,
  181. 'msg' => "",
  182. ]));
  183. }
  184. public function setStatus()
  185. {
  186. $idarr = input('idarr/a');
  187. $status = input('status/d', 1);
  188. ComjobsReportModel::whereIn('id', $idarr)->update(['status' => $status]);
  189. exit(json_encode([
  190. 'code' => 0,
  191. 'msg' => "",
  192. ]));
  193. }
  194. public function delReport()
  195. {
  196. $idarr = input('idarr/a');
  197. $ComjobsReport = ComjobsReportModel::whereIn('id', $idarr)->select();
  198. $result = $ComjobsReport->delete();
  199. if ($result) {
  200. exit(json_encode([
  201. 'code' => 0,
  202. 'msg' => "",
  203. ]));
  204. }
  205. exit(json_encode([
  206. 'code' => 1,
  207. 'msg' => "删除失败,请稍后重试",
  208. ]));
  209. }
  210. public function reportImport()
  211. {
  212. $id = input('id/d, 0');
  213. $comjobslist = ComjobsModel::with(['comjobsRefund.agentGroups'])->order(['id' => 'desc'])->select();
  214. $agentlist = AgentModel::order(['id' => 'asc'])->select();
  215. return view('comjobsreport/reportimport', [
  216. 'comjobslist' => $comjobslist,
  217. 'agentlist' => $agentlist,
  218. ]);
  219. }
  220. public function importReport()
  221. {
  222. $execlfile = input('execlfile/s', "");
  223. if (empty($execlfile)) {
  224. exit(json_encode([
  225. 'code' => 1,
  226. 'msg' => "请上传导入文件",
  227. ]));
  228. }
  229. $comjobsid = input('comjobsid/d', 0);
  230. $comjobs = ComjobsModel::findOrEmpty($comjobsid);
  231. $agentid = input('agentid/d', 0);
  232. $agent = AgentModel::findOrEmpty($agentid);
  233. $filedata = read_excel($execlfile);
  234. $sucnumber = 0;
  235. $errnumber = 0;
  236. $errarr = "";
  237. $statusarr = [1 => '待审核', 2 => '待面试', 3 => '已入职', 4 => '无效报备'];
  238. foreach ($filedata as $k => $v) {
  239. $tabcomjobsid = intval($v[1]);
  240. if (empty($tabcomjobsid)) {
  241. $tabcomjobs = $comjobs;
  242. } else {
  243. $tabcomjobs = ComjobsModel::findOrEmpty($tabcomjobsid);
  244. }
  245. $tabagentid = intval($v[2]);
  246. if (empty($tabagentid)) {
  247. $tabagent = $agent;
  248. } else {
  249. $tabagent = AgentModel::findOrEmpty($tabagentid);
  250. }
  251. if ($tabcomjobs->isEmpty()) {
  252. $errarr .= $v[0] . ",";
  253. $errnumber++;
  254. continue;
  255. } else {
  256. $data = [
  257. 'comjobsid' => $tabcomjobs->id,
  258. 'agentid' => $tabagent->isEmpty() ? 0 : $tabagent->id,
  259. 'brokerid' => 0,
  260. 'realname' => trim($v[3]),
  261. 'mobile' => trim($v[4]),
  262. 'idcard' => trim($v[5]),
  263. 'gender' => trim($v[6]) == '男' ? 1 : 2,
  264. 'comtype' => empty(trim($v[7])) ? trim($v[7]) : input('comtype/s', ""),
  265. 'comprice' => empty(trim($v[8])) ? trim($v[8]) : input('comprice/s', ""),
  266. 'comremark' => empty(trim($v[9])) ? trim($v[9]) : input('comremark/s', ""),
  267. 'arrivetime' => trim($v[10]),
  268. 'remark' => trim($v[11]),
  269. 'status' => intval($v[12]),
  270. 'updatetime' => date("Y-m-d H:i"),
  271. 'createtime' => date("Y-m-d H:i"),
  272. ];
  273. try {
  274. validate(ReportValidate::class)->check($data);
  275. } catch (ValidateException $e) {
  276. $errarr .= $v[0] . ",";
  277. $errnumber++;
  278. continue;
  279. }
  280. $report = new ComjobsReportModel;
  281. $report->save($data);
  282. $logdata = [
  283. 'reportid' => $report->id,
  284. 'logstatus' => $statusarr[$report->status],
  285. 'editrealname' => "管理员",
  286. 'comjobstil' => $tabcomjobs->title,
  287. 'agenttil' => $tabagent->isEmpty() ? "未报备" : $tabagent->title,
  288. 'realname' => trim($v[3]),
  289. 'mobile' => trim($v[4]),
  290. 'idcard' => trim($v[5]),
  291. 'comtype' => empty(trim($v[7])) ? trim($v[7]) : input('comtype/s', ""),
  292. 'comprice' => empty(trim($v[8])) ? trim($v[8]) : input('comprice/s', ""),
  293. 'comremark' => empty(trim($v[9])) ? trim($v[9]) : input('comremark/s', ""),
  294. 'arrivetime' => trim($v[10]),
  295. 'remark' => trim($v[11]),
  296. 'createtime' => date("Y-m-d H:i"),
  297. ];
  298. ReportLogModel::create($logdata);
  299. $sucnumber++;
  300. }
  301. }
  302. exit(json_encode([
  303. 'code' => 0,
  304. 'sucnumber' => $sucnumber,
  305. 'errnumber' => $errnumber,
  306. 'errarr' => $errarr,
  307. ]));
  308. }
  309. public function reportForm()
  310. {
  311. $id = input('id/d, 0');
  312. $report = Db::name('comjobs_report')
  313. ->alias('a')
  314. ->field('a.id,a.realname,a.mobile,a.idcard,a.status,a.remark,a.retremark,b.title')
  315. ->join('comjobs b', 'b.id = a.comjobsid', 'LEFT')
  316. ->where('a.id', $id)
  317. ->find();
  318. $statusarr = [1 => '待审核', 2 => '待面试', 3 => '已入职', 4 => '无效报备'];
  319. return view('comjobsreport/reportform', [
  320. 'report' => $report,
  321. 'title' => $this->access_worker['title'],
  322. 'statusarr' => $statusarr,
  323. ]);
  324. }
  325. public function editReport()
  326. {
  327. $id = input('id/d', 0);
  328. $workerid = $this->access_worker['id'];
  329. $data = [
  330. 'retremark' => input('retremark/s', ""),
  331. 'status' => input('status/d', 1),
  332. 'updatetime' => time(),
  333. ];
  334. if (empty($id)) {
  335. $report = new ComjobsReportModel;
  336. $report->save($data);
  337. } else {
  338. $report = ComjobsReportModel::with('comjobs')->find($id);
  339. if ($data['status'] < $report['status']) {
  340. exit(json_encode([
  341. 'code' => 1,
  342. 'msg' => "状态只能往后选",
  343. ]));
  344. }
  345. //悬赏金
  346. if ($report['status'] != 3 && $data['status'] == 3) {
  347. $comjobsService = new ComjobsService();
  348. $comjobsService->dealCommission($report['brokerid'], $report['comjobs']['retmoney']);
  349. }
  350. $report->save($data);
  351. }
  352. exit(json_encode([
  353. 'code' => 0,
  354. ]));
  355. }
  356. // 记录
  357. public function logList()
  358. {
  359. $reportid = input('reportid/d', 0);
  360. $report = ComjobsReportModel::findOrEmpty($reportid);
  361. return view('comjobsreport/loglist', [
  362. 'reportid' => $reportid,
  363. 'report' => $report,
  364. ]);
  365. }
  366. public function listLog()
  367. {
  368. $limit = input('limit/d', 50);
  369. $page = input('page/d', 1);
  370. $map = [];
  371. $map[] = ['reportid', '=', input('reportid/d', 0)];
  372. $map[] = ['delstatus', '<>', 2];
  373. $list = ReportLogModel::with(['report'])->where($map)->order(['id' => 'desc'])->limit($limit)->page($page)->select();
  374. $count = ReportLogModel::where($map)->count();
  375. if ($count == 0) {
  376. exit(json_encode([
  377. 'code' => 1,
  378. 'msg' => "未查询到数据",
  379. ]));
  380. }
  381. exit(json_encode([
  382. 'code' => 0,
  383. 'msg' => "",
  384. 'count' => $count,
  385. 'data' => $list,
  386. ]));
  387. }
  388. }