Api.php 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706
  1. <?php
  2. namespace app\common\controller;
  3. use app\BaseController;
  4. use app\common\api\EnterpriseApi;
  5. use app\common\middleware\Auth;
  6. use app\common\model\TalentChecklog;
  7. use app\common\validate\Enterprise;
  8. use think\exception\ValidateException;
  9. use think\facade\Db;
  10. use app\enterprise\api\TalentApi;
  11. use app\common\api\TalentLogApi;
  12. use app\common\api\DictApi;
  13. use app\common\model\CurrentcyFileType;
  14. use app\common\model\TalentCommonFile;
  15. use app\common\api\UploadApi;
  16. use app\common\api\TalentConditionApi;
  17. use app\common\api\CompanyApi;
  18. use app\common\api\TalentState;
  19. /**
  20. * 需要权限的公共方法放这
  21. * Description of Tool
  22. *
  23. * @author sgq
  24. */
  25. class Api extends BaseController {
  26. protected $middleware = [Auth::class];
  27. protected $user;
  28. public function __construct(\think\App $app) {
  29. parent::__construct($app);
  30. $this->user = session("user");
  31. }
  32. public function findIdentifyConditionByLevel() {
  33. $params = $this->request->param();
  34. $id = $params["id"];
  35. if ($this->user["usertype"] == 2) {
  36. $type = $this->user["type"];
  37. } else {
  38. $talentInfo = TalentApi::getOne($id);
  39. $enterprise = \app\common\model\Enterprise::findOrEmpty($talentInfo["enterprise_id"]);
  40. $type = $enterprise["type"];
  41. }
  42. $list = TalentConditionApi::getList($params["level"], $type, $params["cat"]);
  43. return json($list, 200);
  44. }
  45. public function getTalentCondtionUploadFile() {
  46. $param = $this->request->param();
  47. $id = $param["mainId"];
  48. $order = $param["order"];
  49. $project = $param["project"];
  50. $type = $param["type"];
  51. $talent_condition = $param["talent_condition"];
  52. $condition_info = Db::table("new_talent_condition")->findOrEmpty($talent_condition);
  53. if (!$condition_info["bindFileTypes"])
  54. return json(["rows" => null]);
  55. $whr[] = ["id", "in", $condition_info["bindFileTypes"]];
  56. $whr[] = ["active", "=", 1];
  57. $whr[] = ["delete", "=", 0];
  58. $rows = Db::table("new_common_filetype")->where($whr)->order("sn " . $order)->select()->toArray();
  59. if ($id) {
  60. foreach ($rows as $key => $row) {
  61. $where = [];
  62. $where[] = ["mainId", "=", $id];
  63. $where[] = ["typeId", "=", $row["id"]];
  64. $files = Db::table("new_talent_file")->where($where)->field("id,typeId,orignName,url")->order("sn asc")->select()->toArray();
  65. foreach ($files as &$file) {
  66. $file["ext"] = pathinfo($file["url"])["extension"];
  67. $file["url"] = getStoragePath($file["url"]);
  68. }
  69. $rows[$key]["files"] = $files;
  70. }
  71. }
  72. return json(["rows" => $rows, "info" => $condition_info]);
  73. }
  74. public function getCheckLog() {
  75. $params = $this->request->param();
  76. $mainId = $params["mainId"];
  77. $enterpriseId = $params["enterpriseId"];
  78. $type = $params["type"];
  79. /* $talentInfo = TalentApi::getOne($mainId);
  80. $condition = TalentConditionApi::getOne($talentInfo["talent_condition"]);
  81. $needDeptVerify = false;
  82. if ($condition["companyIds"] && $talentInfo["pass_dept_check"] != 1)
  83. $needDeptVerify = true; */
  84. $list = [];
  85. switch ($type) {
  86. case 1:
  87. case 20:
  88. $list = TalentLogApi::getList($type, $mainId);
  89. break;
  90. case 10:
  91. if ($enterpriseId) {
  92. $where[] = ["mainId", "=", $enterpriseId];
  93. $ids = \app\enterprise\model\EnterpriseRecord::where($where)->column("id");
  94. $ids[] = $enterpriseId;
  95. $where = [];
  96. $where[] = ["type", "=", $type];
  97. $where[] = ["active", "=", 1];
  98. $where[] = ["mainId", "in", $ids];
  99. $list = TalentChecklog::where($where)->order("createTime desc")->select();
  100. } else {
  101. $list = TalentLogApi::getList($type, $mainId);
  102. }
  103. break;
  104. }
  105. $new_list = [];
  106. foreach ($list as $key => $item) {
  107. switch ($item['type']) {
  108. case 10:
  109. if ($item["category"] == "enterprise_change") {
  110. switch ($item['step']) {
  111. case 100:
  112. $new_item["stepName"] = "<span class='label'>用户操作</span>";
  113. break;
  114. case 101:
  115. $new_item["stepName"] = "<span class='label label-primary'>审核</span>";
  116. break;
  117. case 102:
  118. $new_item["stepName"] = "<span class='label label-danger'>设置冻结</span>";
  119. break;
  120. case 103:
  121. $new_item["stepName"] = "<span class='label label-info'>重置密码</span>";
  122. break;
  123. }
  124. switch ($item['state']) {
  125. case 1:
  126. if ($item["stateChange"]) {
  127. $new_item["stateName"] = "<span class='label label-success'>待提交</span>";
  128. } else {
  129. $item['stateChange'] = "修改密码";
  130. }
  131. break;
  132. case 2:
  133. $new_item["stateName"] = "<span class='label label-success'>待审核</span>";
  134. break;
  135. case 3:
  136. $new_item["stateName"] = "<span class='label label-danger'>审核驳回</span>";
  137. break;
  138. case 4:
  139. $new_item["stateName"] = "<span class='label label-primary'>审核通过</span>";
  140. break;
  141. case 5:
  142. $new_item["stateName"] = "<span class='label label-warm'>重新提交</span>";
  143. break;
  144. }
  145. $new_item["stateChange"] = $item['stateChange'];
  146. } else {
  147. switch ($item['step']) {
  148. case 100:
  149. $new_item["stepName"] = "<span class='label'>用户操作</span>";
  150. break;
  151. case 101:
  152. $new_item["stepName"] = "<span class='label label-primary'>注册审核</span>";
  153. break;
  154. case 102:
  155. $new_item["stepName"] = "<span class='label label-danger'>设置冻结</span>";
  156. break;
  157. case 103:
  158. $new_item["stepName"] = "<span class='label label-info'>重置密码</span>";
  159. break;
  160. }
  161. switch ($item['state']) {
  162. case 1:
  163. $new_item["stateName"] = "<span class='label label-success'>待审核</span>";
  164. break;
  165. case 2:
  166. $new_item["stateName"] = "<span class='label label-danger'>审核驳回</span>";
  167. break;
  168. case 3:
  169. $new_item["stateName"] = "<span class='label label-primary'>审核通过</span>";
  170. break;
  171. default:
  172. break;
  173. }
  174. $new_item["stateChange"] = $item['stateChange'];
  175. }
  176. break;
  177. case 1:
  178. $new_item["stepName"] = DictApi::getCheckLogStepName($item["state"], $item["step"]);
  179. if (in_array($item["state"], [TalentState::REVERIFY_FAIL, TalentState::ZX_FAIL, TalentState::ANNOUNCED_REVERIFY_FAIL, TalentState::PUBLISH_FAIL])) {
  180. $new_item["stateName"] = '<span class="label label-danger">审核不通过</span>';
  181. } else if (in_array($item["state"], [TalentState::BASE_VERIFY_PASS, TalentState::BASE_REVERIFY_PASS, TalentState::FST_VERIFY_PASS, TalentState::DEPT_VERIFY_PASS, TalentState::REVERIFY_PASS])) {
  182. if ($item["step"] == 3) {
  183. if ($item["new_state"] == TalentState::SCND_SUBMIT) {
  184. $new_item["stateName"] = '<span class="label label-danger">审核驳回</span>';
  185. } else if ($item["new_state"] == TalentState::DEPT_VERIFY_PASS) {
  186. $new_item["stateName"] = '<span class="label label-primary">审核通过</span>';
  187. } else {
  188. $new_item["stateName"] = '<span class="label label-success">待审核</span>';
  189. }
  190. } else {
  191. $new_item["stateName"] = '<span class="label label-primary">审核通过</span>';
  192. }
  193. } else if (in_array($item["state"], [TalentState::BASE_REJECT, TalentState::BASE_REVERIFY_REJECT, TalentState::FST_VERIFY_REJECT, TalentState::DEPT_VERIFY_REJECT, TalentState::REVERIFY_REJECT])) {
  194. $new_item["stateName"] = '<span class="label label-danger">审核驳回</span>';
  195. } else if (in_array($item["state"], [TalentState::ZX_PASS, TalentState::ANNOUNCED, TalentState::ANNOUNCED_REVERIFY_PASS, TalentState::PUBLISH_PASS, TalentState::CERTIFICATED])) {
  196. $new_item["stateName"] = '<span class="label label-primary">审核通过</span>';
  197. } else if (in_array($item["state"], [TalentState::FST_SAVE, TalentState::SCND_SAVE])) {
  198. $new_item["stateName"] = '<span class="label">保存未提交</span>';
  199. } else if ($item["state"] == 0) {
  200. $new_item["stateName"] = '<span class="label">添加附件</span>';
  201. } else {
  202. if (($item["last_state"] == TalentState::BASE_REJECT && $item["state"] == TalentState::FST_SUBMIT) || ($item["last_state"] == TalentState::FST_VERIFY_REJECT && $item["state"] == TalentState::SCND_SUBMIT)) {
  203. $new_item["stateName"] = '<span class="label label-success">待审核(重新提交)</span>';
  204. } else {
  205. $new_item["stateName"] = '<span class="label label-success">待审核</span>';
  206. }
  207. }
  208. if ($item["step"] == 3) {
  209. $company = CompanyApi::getOne($item["companyId"]);
  210. if ($item["active"] == 0) {
  211. $new_item["stateChange"] = str_replace("部门", '"' . $company["name"] . '"', DictApi::getTalentInfoStateName($item["state"], $item["step"]));
  212. } else {
  213. $new_item["stateChange"] = sprintf("%s -> %s", str_replace("部门", '"' . $company["name"] . '"', DictApi::getTalentInfoStateName($item["state"], $item["step"])), DictApi::getTalentInfoStateName($item["new_state"], $item["step"]));
  214. }
  215. } else {
  216. if ($item["last_state"] && $item["new_state"]) {
  217. $new_item["stateChange"] = sprintf("%s -> %s", DictApi::getTalentInfoStateName($item["last_state"], $list[$key + 1]["step"]), DictApi::getTalentInfoStateName($item["new_state"], $list[$key - 1]["step"], $item["last_state"]));
  218. } else {
  219. $new_item["stateChange"] = "";
  220. }
  221. }
  222. break;
  223. }
  224. $new_item["description"] = $item["description"];
  225. $new_item["createUser"] = $item["updateUser"] ?: $item["createUser"];
  226. $new_item["createTime"] = $item["updateTime"] ?: $item["createTime"];
  227. $new_list[] = $new_item;
  228. }
  229. return json(["rows" => $new_list]);
  230. }
  231. public function findCommonFileType() {
  232. $param = $this->request->param();
  233. $id = $param["mainId"];
  234. $source = $param["source"];
  235. $order = $param["order"];
  236. $project = $param["project"];
  237. $type = $param["type"];
  238. $checkState = $param["checkState"];
  239. $isMix = $param["isMix"] ?: 0;
  240. $talent_condition = $param["talent_condition"];
  241. $where[] = ["project", "=", $project];
  242. $where[] = ["active", "=", 1];
  243. $where[] = ["delete", "=", 0];
  244. $where[] = ["type", "=", $type];
  245. switch ($project) {
  246. case 1:
  247. if (in_array($checkState, [TalentState::BASE_VERIFY_FAIL, 0, TalentState::FST_SAVE, TalentState::FST_SUBMIT, TalentState::BASE_VERIFY_PASS]) && $isMix != 1) {
  248. $where[] = ["step", "=", 1]; //只查找人才第一步所需文件
  249. } else {
  250. $where[] = ["isConditionFile", "<>", 1]; //排除人才条件上传文件
  251. }
  252. if ($talent_condition && $source == 5) {
  253. $condition_info = Db::table("new_talent_condition")->findOrEmpty($talent_condition);
  254. if ($condition_info["bindFileTypes"]) {
  255. $whr[] = ["id", "in", $condition_info["bindFileTypes"]];
  256. }
  257. }
  258. break;
  259. case 20:
  260. $itemId = $param["itemId"];
  261. $integral_item = \app\common\api\IntegralItemApi::getOne($itemId);
  262. if ($integral_item && $integral_item["fileTypeId"]) {
  263. $where[] = ["id", "in", explode(',', $integral_item["fileTypeId"])];
  264. } else {
  265. return json([]);
  266. }
  267. break;
  268. }
  269. if ($whr) {
  270. $rows = Db::table("new_common_filetype")->whereOr([$where, $whr])->order("must asc")->order("sn " . $order)->select()->toArray();
  271. } else {
  272. $rows = Db::table("new_common_filetype")->where($where)->order("must asc")->order("sn " . $order)->select()->toArray();
  273. }
  274. if ($id) {
  275. foreach ($rows as $key => $row) {
  276. $where = [];
  277. $where[] = ["mainId", "=", $id];
  278. $where[] = ["typeId", "=", $row["id"]];
  279. $files = Db::table("new_talent_file")->where($where)->field("id,typeId,orignName,url")->order("sn asc")->select()->toArray();
  280. foreach ($files as &$file) {
  281. $file["ext"] = pathinfo($file["url"])["extension"];
  282. $file["url"] = getStoragePath($file["url"]);
  283. }
  284. $rows[$key]["files"] = $files;
  285. }
  286. }
  287. return json(["rows" => $rows]);
  288. }
  289. public function listTalentFile() {
  290. $param = $this->request->param();
  291. $mainId = $param["mainId"];
  292. $typeId = $param["fileTypeId"];
  293. $where = [["mainId", "=", $mainId], ["typeId", "=", $typeId]];
  294. $list = Db::table("new_talent_file")->where($where)->select()->toArray();
  295. foreach ($list as $key => $item) {
  296. $list[$key]["url"] = getStoragePath($item["url"]);
  297. }
  298. return json($list);
  299. }
  300. public function addTalentFile() {
  301. $backName = $this->request->param("backName");
  302. $fileId = $this->request->param("fileId");
  303. $mainId = $this->request->param("mainId");
  304. $fileTypeId = $this->request->param("fileTypeId");
  305. $index = $this->request->param("index");
  306. $type = $this->request->param("type");
  307. $upload = new \app\common\api\UploadApi();
  308. $file = $this->request->file("fileUrl");
  309. if (!TalentApi::checkIsEditable($mainId)) {
  310. $res = ["msg" => "当前状态不能修改附件", "obj" => $index];
  311. echo sprintf("<script>parent.%s(%s);</script>", $backName, json_encode($res));
  312. exit();
  313. }
  314. $mime = $file->getMime();
  315. switch ($mime) {
  316. case "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"://xlsx
  317. case "application/pdf"://pdf
  318. case "application/vnd.ms-excel"://xls
  319. $filestd = $upload->uploadOne($file, "file", "talent_files");
  320. break;
  321. case "image/jpg":
  322. case "image/jpeg":
  323. case "image/png":
  324. case "image/gif":
  325. $filestd = $upload->uploadOne($file, "image", "talent_files");
  326. break;
  327. default:
  328. $res = ["msg" => "不支持的附件类型", "obj" => $index];
  329. echo sprintf("<script>parent.%s(%s);</script>", $backName, json_encode($res));
  330. exit();
  331. break;
  332. }
  333. $change = false;
  334. if ($fileId) {
  335. if (!$this->chkIsFileOwner($mainId, $type)) {
  336. $res = ["msg" => "删除失败", "obj" => $index];
  337. echo sprintf("<script>parent.%s(%s);</script>", $backName, json_encode($res));
  338. exit();
  339. }
  340. $old = Db::table("new_talent_file")->findOrEmpty($fileId);
  341. $old_filepath = "storage/" . $old["url"];
  342. if (file_exists($old_filepath))
  343. unlink($old_filepath);
  344. $data["id"] = $fileId;
  345. $change = true;
  346. }
  347. $data["mainId"] = $mainId;
  348. $data["type"] = $type;
  349. $data["typeId"] = $fileTypeId;
  350. $data["orignName"] = $file->getOriginalName();
  351. $data["url"] = $filestd->filepath;
  352. $data["sn"] = $index;
  353. $data["createTime"] = time();
  354. if ($fileId) {
  355. Db::table("new_talent_file")->save($data);
  356. } else {
  357. $fileId = Db::table("new_talent_file")->insertGetId($data);
  358. }
  359. $ext = pathinfo($filestd->filepath)["extension"];
  360. TalentLogApi::write($type, $mainId, 0, sprintf("%s附件,附件名为:%s", $change ? "修改" : "添加", $data["orignName"]), 1, $fileTypeId, $fileId);
  361. $res = ["code" => 200, "msg" => "上传附件成功", "obj" => $index, "ext" => $ext, "info" => getStoragePath($filestd->filepath), "typeId" => $fileTypeId, "id" => $fileId, "orignName" => $data["orignName"]];
  362. echo sprintf("<script>parent.%s(%s);</script>", $backName, json_encode($res));
  363. }
  364. public function deleteFile() {
  365. $param = $this->request->param();
  366. $where = [["id", "=", $param["id"]]];
  367. $file = Db::table("new_talent_file")->where($where)->findOrEmpty();
  368. if (!TalentApi::checkIsEditable($file["mainId"]))
  369. return json(["msg" => "当前状态不能删除"]);
  370. if ($this->chkIsFileOwner($file["mainId"], $file["type"])) {
  371. $filepath = "storage/" . $file["url"];
  372. if (file_exists($filepath)) {
  373. unlink($filepath);
  374. }
  375. Db::table("new_talent_file")->delete($file["id"]);
  376. TalentLogApi::write($file["type"], $file["mainId"], 0, sprintf("删除附件,附件名为:%s", $file["orignName"]), 1, $file["typeId"], $param["id"]);
  377. return json(["code" => 200, "msg" => "删除成功"]);
  378. }
  379. return json(["msg" => "不能删除"]);
  380. }
  381. public function deleteTalentCommonFile() {
  382. $param = $this->request->param();
  383. $where = [["id", "=", $param["id"]]];
  384. $file = Db::table("new_talent_common_file")->where($where)->findOrEmpty();
  385. $filepath = "storage/" . $file["url"];
  386. if (file_exists($filepath)) {
  387. unlink($filepath);
  388. }
  389. Db::table("new_talent_common_file")->delete($file["id"]);
  390. //TalentLogApi::write($file["type"], $file["mainId"], 0, sprintf("删除附件,附件名为:%s", $file["orignName"]), 1, $file["typeId"], $param["id"]);
  391. return json(["code" => 200, "msg" => "删除成功"]);
  392. return json(["msg" => "不能删除"]);
  393. }
  394. /**
  395. * 下载文件
  396. */
  397. public function downloadFile() {
  398. $param = $this->request->param();
  399. $type = $param["type"];
  400. $id = $param["id"];
  401. $where = [];
  402. $where[] = ["id", "=", $id];
  403. $url = "";
  404. switch ($type) {
  405. case 1:
  406. $fileinfo = Db::table("new_talent_file")->where($where)->findOrEmpty();
  407. $filename = $fileinfo["orignName"];
  408. $url = $fileinfo["url"];
  409. break;
  410. case 2:
  411. $fileinfo = Db::table("new_talent_common_file")->where($where)->findOrEmpty();
  412. $filename = $fileinfo["orignName"];
  413. $url = $fileinfo["url"];
  414. break;
  415. case 3:
  416. $fileinfo = Db::table("new_currency_filetype")->where($where)->findOrEmpty();
  417. $filename = $fileinfo["templateUrl"];
  418. $url = $fileinfo["templateUrl"];
  419. break;
  420. case 4:
  421. $fileinfo = Db::table("sys_common_file")->where($where)->findOrEmpty();
  422. $filename = $fileinfo["orignName"];
  423. $url = $fileinfo["url"];
  424. break;
  425. }
  426. $filepath = "storage/" . $url; // 下载文件名
  427. if (!file_exists($filepath)) {
  428. header('HTTP/1.1 404 NOT FOUND');
  429. } else {
  430. $file = fopen($filepath, "rb");
  431. Header("Content-type: application/octet-stream");
  432. Header("Accept-Ranges: bytes");
  433. Header("Accept-Length: " . filesize($filepath));
  434. Header("Content-Disposition: attachment; filename=" . $filename);
  435. echo fread($file, filesize($filepath));
  436. fclose($file);
  437. exit();
  438. }
  439. }
  440. /**
  441. * 打包下载人才申请附件
  442. */
  443. public function downloadZip() {
  444. $param = $this->request->param();
  445. $type = $param["type"];
  446. $id = $param["id"];
  447. $where = [];
  448. $where[] = ["mainId", "=", $id];
  449. $where[] = ["type", "=", $type];
  450. $files = Db::table("new_talent_file")->where($where)->select()->toArray();
  451. if (!$files)
  452. die("没有附件不能打包下载");
  453. $talent_info = \app\enterprise\model\Talent::findOrEmpty($id);
  454. $enterprise_info = \app\common\model\Enterprise::findOrEmpty($talent_info["enterprise_id"]);
  455. $zip_filename = sprintf("%s(%s)人才申报材料.zip", $talent_info["name"], $enterprise_info["name"]);
  456. $tmp_path = "storage/temp/";
  457. $tmp_file_path = $tmp_path . $zip_filename;
  458. if (!file_exists($tmp_path)) {
  459. mkdir($tmp_path);
  460. }
  461. $zip = new \ZipArchive();
  462. if (!$zip->open($tmp_file_path, \ZipArchive::CREATE | \ZipArchive::OVERWRITE)) {
  463. header('HTTP/1.1 404 NOT FOUND');
  464. }
  465. foreach ($files as $file) {
  466. $filepath = "storage/" . $file["url"];
  467. $filename = $file["orignName"];
  468. $zip->addFile($filepath, $filename);
  469. }
  470. $zip->close();
  471. if (file_exists($tmp_file_path)) {
  472. header("Cache-Control: public");
  473. header("Content-Description: File Transfer");
  474. header('Content-disposition: attachment; filename=' . $zip_filename); //文件名
  475. header("Content-Type: application/octet-stream;charset=utf-8"); //zip格式的
  476. header("Content-Transfer-Encoding: binary"); //告诉浏览器,这是二进制文件
  477. header('Content-Length: ' . filesize($tmp_file_path)); //告诉浏览器,文件大小
  478. @readfile($tmp_file_path);
  479. }
  480. //删除临时文件
  481. @unlink($tmp_file_path);
  482. }
  483. private function chkIsFileOwner($mainId, $type) {
  484. if (!$mainId)
  485. return true;
  486. switch ($type) {
  487. case 1:
  488. if ($this->user["usertype"] == 2) {
  489. $user_id = $this->user["uid"];
  490. $talent_info = Db::table("new_talent_info")->findOrEmpty($mainId);
  491. if ($user_id == $talent_info["enterprise_id"])
  492. return true;
  493. }
  494. break;
  495. }
  496. return false;
  497. }
  498. public function getCompanyKvs() {
  499. $companys = \app\common\model\Company::field("name,id")->select();
  500. return json($companys);
  501. }
  502. public function getLayerCatsByLayer() {
  503. $lv = $this->request->param("level");
  504. return json(DictApi::getLayerCatsByLayer($lv));
  505. }
  506. /**
  507. * 通过人才类别查找人才认定第二步骤支持的所有文件类型
  508. * 默认人才认定第二步骤,当前只有人才认定分了两步,所以此方法目前默认参数高度匹配人才认定第二阶段附件的查找
  509. */
  510. public function getConditionFileTypesByType() {
  511. $params = $this->request->param();
  512. $type = $params["type"]; //人才类型不默认,需要传
  513. $declare_type = $params["project"] ?: 1; //默认人才认定
  514. $active = $params["active"] ?: 1; //默认查找启用的附件
  515. $where[] = ["type", "=", $type];
  516. $where[] = ["project", "=", $declare_type];
  517. $where[] = ["active", "=", $active];
  518. $where[] = ["delete", "=", 0];
  519. $where[] = ["isConditionFile", "=", 1];
  520. $list = Db::table("new_common_filetype")->where($where)->order("sn " . $order)->select()->toArray();
  521. return json($list);
  522. }
  523. public function listCurrencyFileType() {
  524. $where = [
  525. 'type' => $this->request['type'],
  526. 'active' => 1
  527. ];
  528. $rows = CurrentcyFileType::where($where)->select();
  529. return json(["rows" => $rows, 'total' => count($rows)]);
  530. }
  531. public function listTalentCommonFile() {
  532. $where = [];
  533. if (\StrUtil::isNotEmpAndNull($this->request['mainId'])) {
  534. $where[] = ['mainId', '=', $this->request['mainId']];
  535. }
  536. if (\StrUtil::isNotEmpAndNull($this->request['typeId'])) {
  537. $where[] = ['typeId', '=', $this->request['typeId']];
  538. }
  539. $res = TalentCommonFile::where($where)->order('sn')->select();
  540. if ($res) {
  541. foreach ($res as $k => &$v) {
  542. $v["ext"] = pathinfo($v["url"])["extension"];
  543. $v['url'] = getStoragePath($v['url']);
  544. }
  545. }
  546. return json($res);
  547. }
  548. public function addTalentCommonFile() {
  549. $backName = \StrUtil::getRequestDecodeParam($this->request, 'backName');
  550. $id = \StrUtil::getRequestDecodeParam($this->request, "fileId");
  551. $mainId = \StrUtil::getRequestDecodeParam($this->request, "mainId");
  552. $typeId = \StrUtil::getRequestDecodeParam($this->request, "typeId");
  553. $index = \StrUtil::getRequestDecodeParam($this->request, "index");
  554. if ($backName == "EpChangeEdit.callBack") {
  555. $type = 1;
  556. $error = "文件格式不正确,只能上传图片";
  557. } else {
  558. $type = 4;
  559. $error = "文件格式不正确,只能上传pdf和图片";
  560. }
  561. $uploadapi = new UploadApi();
  562. $file_check_res = $uploadapi->uploadOne($this->request->file('fileUrl'), 'system');
  563. if ($file_check_res->code == 500) {
  564. $file_check_res->obj = $index;
  565. return \StrUtil::back($file_check_res, $backName);
  566. }
  567. $file_data = [
  568. 'id' => getStringId(),
  569. 'mainId' => $mainId,
  570. 'typeId' => $typeId,
  571. 'orignName' => $this->request->file('fileUrl')->getOriginalName(),
  572. 'url' => $file_check_res->filepath
  573. ];
  574. if (\StrUtil::isEmpOrNull($id)) {
  575. $tc = TalentCommonFile::where('mainId', $mainId)->where('typeId', $typeId)->order('sn', 'desc')->findOrEmpty();
  576. if ($tc) {
  577. $file_data['sn'] = $tc['sn'] + 1;
  578. } else {
  579. $file_data['sn'] = 1;
  580. }
  581. $file_data['createTime'] = date("Y-m-d H:i:s");
  582. TalentCommonFile::create($file_data);
  583. $response_object = new \StdClass();
  584. $response_object->code = 200;
  585. $response_object->msg = "附件上传成功!";
  586. $response_object->obj = $index;
  587. return \StrUtil::back($response_object, $backName);
  588. } else {
  589. $tf = TalentCommonFile::findOrEmpty($id);
  590. $tf->originalName = $file_data['orignName'];
  591. $tf->updateTime = date("Y-m-d H:i:s");
  592. $tf->url = $file_check_res->filepath;
  593. $tf->save();
  594. $response_object = new \StdClass();
  595. $response_object->code = 200;
  596. $response_object->msg = "附件修改成功!";
  597. $response_object->obj = $index;
  598. return \StrUtil::back($response_object, $backName);
  599. }
  600. }
  601. public function changePwd() {
  602. $password = \StrUtil::getRequestDecodeParam($this->request, 'password');
  603. $newPassword = \StrUtil::getRequestDecodeParam($this->request, 'newPassword');
  604. //数据校验(原密码与新密码不能为空)
  605. if (\StrUtil::isEmpOrNull($password)) {
  606. return json(['code' => 500, 'msg' => "请填写原密码!"]);
  607. }
  608. if (\StrUtil::isEmpOrNull($newPassword)) {
  609. return json(['code' => 500, 'msg' => "请填写新密码!"]);
  610. }
  611. try {
  612. validate(Enterprise::class)->batch(true)->scene('changePwd')->check(['password' => $password, 'password' => $newPassword]);
  613. $ep = EnterpriseApi::getOne(session("user")['uid']);
  614. if (!$ep) {
  615. return json(['code' => 500, 'msg' => "请刷新页面后重试!"]);
  616. }
  617. if ($ep->password != hash('md5', $password)) {
  618. return json(['code' => 500, 'msg' => "旧密码不正确!"]);
  619. }
  620. $ep->password = hash('md5', $newPassword);
  621. $ep->updateUser = session("user")['uid'];
  622. $ep->updateTime = date("Y-m-d H:i:s");
  623. $ep->save();
  624. TalentChecklog::create([
  625. 'id' => getStringId(),
  626. 'category' => 'enterprise_change',
  627. 'mainId' => $ep->id,
  628. 'type' => 10,
  629. 'typeField' => null,
  630. 'active' => 1,
  631. 'state' => 1,
  632. 'step' => 100,
  633. 'stateChange' => null,
  634. 'description' => '用户修改密码',
  635. 'createTime' => date("Y-m-d H:i:s", time()),
  636. 'createUser' => '用户'
  637. ]);
  638. return json(['code' => 200, 'msg' => "修改成功!"]);
  639. } catch (ValidateException $e) {
  640. $error = $e->getError();
  641. return json(['code' => 500, 'msg' => array_pop($error)]);
  642. }
  643. }
  644. function getIntegralProjectsByType() {
  645. $projectType = $this->request->param("projectType") ?: 0;
  646. if (session("user")["usertype"] == 2) {
  647. $where[] = ["type", "=", 2];
  648. } else {
  649. $type = $this->request->param("type") ?: 0;
  650. $where[] = ["type", "=", $type];
  651. }
  652. $where[] = ["projectType", "=", $projectType];
  653. $where[] = ["active", "=", 1];
  654. $list = \app\common\api\IntegralProjectApi::getAll($where);
  655. return json($list);
  656. }
  657. public function getIntegralItemsByProject() {
  658. $projectId = $this->request->param("projectId") ?: 0;
  659. $where[] = ["projectId", "=", $projectId];
  660. $where[] = ["active", "=", 1];
  661. $list = \app\common\api\IntegralItemApi::getAll($where);
  662. return json($list);
  663. }
  664. }