EnterpriseApi.php 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562
  1. <?php
  2. namespace app\common\api;
  3. use app\admin\controller\EnterpriseChangeRecord;
  4. use app\common\api\CompanyApi;
  5. use app\enterprise\model\EnterpriseRecord;
  6. use think\facade\Db;
  7. use app\admin\model\Enterprise;
  8. class EnterpriseApi {
  9. public static function getOne($id) {
  10. $ep = Enterprise::findOrEmpty($id);
  11. if ($ep->delete == 1) {
  12. return null;
  13. }
  14. return $ep;
  15. }
  16. public static function getSimpleList() {
  17. $where[] = ["active", "=", 1];
  18. $where[] = ["delete", "=", 0];
  19. return $list = Enterprise::where($where)->order("name", 'asc')->field("name,id")->select()->toArray();
  20. }
  21. public static function getList($request, $isExport = false) {
  22. $companyId = session('user')['companyId'];
  23. $company_info = CompanyApi::getOne($companyId);
  24. $where = [];
  25. $whereRaw = "";
  26. $where[] = ['type', '=', session('user')['type']];
  27. if ($company_info['code'] != 'super' && !self::chkUserInSuperusers()) {
  28. if (session('user')['type'] == 1) {
  29. $whr[] = ["companyId", "=", $companyId];
  30. $whr[] = ["delete", "=", 0];
  31. $list = \app\common\model\EnterpriseVerifyMgr::where($whr)->select()->toArray();
  32. $talentType = []; //查找单位对应标签
  33. $org = [];
  34. $ins = [];
  35. $uniCodes = []; //查找单位对应例外
  36. foreach ($list as $k => $v) {
  37. if (!empty($v['enterpriseTag'])) {
  38. array_push($talentType, $v['enterpriseTag']);
  39. }
  40. if (!empty($v['organizationTag'])) {
  41. array_push($org, $v['organizationTag']);
  42. }
  43. if (!empty($v['institutionTag'])) {
  44. array_push($ins, $v['institutionTag']);
  45. }
  46. if (!empty($v["uniCode"])) {
  47. $codes = explode(",", $v["uniCode"]);
  48. $uniCodes = array_merge($uniCodes, (array) $codes);
  49. }
  50. }
  51. $_whr[] = ["uniCode", "<>", ""];
  52. $_whr[] = ["delete", "=", 0];
  53. $_whr[] = ["companyId", "<>", $companyId];
  54. $_list = \app\common\model\EnterpriseVerifyMgr::where($_whr)->select()->toArray();
  55. $expUniCodes = []; //排除其它单位的例外
  56. foreach ($_list as $_v) {
  57. $codes = explode(",", $_v["uniCode"]);
  58. $expUniCodes = array_merge($expUniCodes, (array) $codes);
  59. }
  60. if (($talentType || $org || $ins) && $uniCodes) {
  61. if ($expUniCodes) {
  62. $whereRaw = sprintf('(enterpriseTag in ("%s") or organizationTag in ("%s") or institutionTag in ("%s") and idCard not in ("%s")) or idCard in ("%s")', implode('","', $talentType), implode('","', $org), implode('","', $ins), implode('","', $expUniCodes), implode('","', $uniCodes));
  63. } else {
  64. $whereRaw = sprintf('enterpriseTag in ("%s") or organizationTag in ("%s") or institutionTag in ("%s") or idCard in ("%s")', implode('","', $talentType), implode('","', $org), implode('","', $ins), implode('","', $uniCodes));
  65. }
  66. }
  67. if (($talentType || $org || $ins) && !$uniCodes) {
  68. if ($expUniCodes) {
  69. $whereRaw = sprintf('enterpriseTag in ("%s") or organizationTag in ("%s") or institutionTag in ("%s") and idCard not in ("%s")', implode('","', $talentType), implode('","', $org), implode('","', $ins), implode('","', $expUniCodes));
  70. } else {
  71. $whereRaw = sprintf('enterpriseTag in ("%s") or organizationTag in ("%s") or institutionTag in ("%s") ', implode('","', $talentType), implode('","', $org), implode('","', $ins));
  72. }
  73. }
  74. if (!$talentType && !$org && !$ins && $uniCodes) {
  75. $where[] = ["idCard", "in", $uniCodes];
  76. }
  77. }
  78. }
  79. $offset = trim($request->param("offset")) ?: 0;
  80. $limit = trim($request->param("limit")) ?: 10;
  81. $name = urldecode(trim($request->param("name")));
  82. $idCard = urldecode(trim($request->param("idCard")));
  83. $legal = urldecode(trim($request->param("legal")));
  84. $ephone = urldecode(trim($request->param("ephone")));
  85. $agentName = urldecode(trim($request->param("agentName")));
  86. $agentPhone = urldecode(trim($request->param("agentPhone")));
  87. $checkState = urldecode(trim($request->param("checkState")));
  88. $active = urldecode(trim($request->param("active")));
  89. $street = urldecode(trim($request->param("street")));
  90. $special = urldecode(trim($request->param("special")));
  91. $agencyType = urldecode(trim($request->param("agencyType")));
  92. $industryFieldNew = urldecode(trim($request->param("industryFieldNew")));
  93. $industryFieldOld = urldecode(trim($request->param("industryFieldOld")));
  94. $enterpriseTag = urldecode(trim($request->param("enterpriseTag")));
  95. $enterpriseType = urldecode(trim($request->param("enterpriseType")));
  96. $where[] = ["delete", "=", 0];
  97. if ($name) {
  98. $where[] = ["name", "like", "%{$name}%"];
  99. }
  100. if ($idCard) {
  101. $where[] = ["idCard", "like", "%{$idCard}%"];
  102. }
  103. if ($legal) {
  104. $where[] = ["legal", "like", "%{$legal}%"];
  105. }
  106. if ($ephone) {
  107. $where[] = ["ephone", "like", "%{$ephone}%"];
  108. }
  109. if ($agentName) {
  110. $where[] = ["agentName", "like", "%{$agentName}%"];
  111. }
  112. if ($agentPhone) {
  113. $where[] = ["agentPhone", "like", "%{$agentPhone}%"];
  114. }
  115. if ($checkState) {
  116. $where[] = ["checkState", "=", "{$checkState}"];
  117. }
  118. if ($active) {
  119. $where[] = ["active", "=", "{$active}"];
  120. }
  121. if ($street) {
  122. $where[] = ["street", "=", "{$street}"];
  123. }
  124. if ($special !== "") {
  125. $where[] = ["special", "=", "{$special}"];
  126. }
  127. if ($agencyType) {
  128. $where[] = ["agencyType", "=", "{$agencyType}"];
  129. }
  130. if ($industryFieldNew) {
  131. $where[] = ["industryFieldNew", "=", "{$industryFieldNew}"];
  132. }
  133. if ($industryFieldOld) {
  134. $where[] = ["industryFieldOld", "=", "{$industryFieldOld}"];
  135. }
  136. if ($enterpriseTag) {
  137. if ($special == 1) {
  138. $where[] = ["institutionTag", "=", "{$enterpriseTag}"];
  139. } else if ($special == 3) {
  140. $where[] = ["organizationTag", "=", "{$enterpriseTag}"];
  141. } else {
  142. $where[] = ["enterpriseTag", "=", "{$enterpriseTag}"];
  143. }
  144. }
  145. if ($enterpriseType) {
  146. $where[] = ["enterpriseType", "=", "{$enterpriseType}"];
  147. }
  148. if ($whereRaw) {
  149. $count = Enterprise::where($where)->whereRaw($whereRaw)->count();
  150. } else {
  151. $count = Enterprise::where($where)->count();
  152. }
  153. if ($count > 0) {
  154. $talentTypeList = DictApi::selectByParentCode("enterprise_tag");
  155. $orgList = DictApi::selectByParentCode("organization_tag");
  156. $insList = DictApi::selectByParentCode("institution_tag");
  157. $industryFieldNewList = DictApi::selectByParentCode("industry_field");
  158. $streetList = DictApi::selectByParentCode("street");
  159. //dd($talentTypeList);
  160. if ($whereRaw) {
  161. if ($isExport) {
  162. $list = Enterprise::where($where)->whereRaw($whereRaw)->order("createTime", 'desc')->select()->toArray();
  163. } else {
  164. $list = Enterprise::where($where)->whereRaw($whereRaw)->limit($offset, $limit)->order("createTime", 'desc')->select()->toArray();
  165. }
  166. } else {
  167. if ($isExport) {
  168. $list = Enterprise::where($where)->order("createTime", 'desc')->select()->toArray();
  169. } else {
  170. $list = Enterprise::where($where)->limit($offset, $limit)->order("createTime", 'desc')->select()->toArray();
  171. }
  172. }
  173. foreach ($list as $k => &$v) {
  174. unset($v['password']);
  175. $v['enterpriseTagName'] = array_key_exists($v['enterpriseTag'], $talentTypeList) ? $talentTypeList[$v['enterpriseTag']] : ''; //此处旧字段为talentType,新字段为enterpriseTag,为防止数据污染与丢失,因而这样写
  176. $v['organizationTagName'] = array_key_exists($v['organizationTag'], $orgList) ? $orgList[$v['organizationTag']] : '';
  177. $v['institutionTagName'] = array_key_exists($v['institutionTag'], $orgList) ? $orgList[$v['institutionTag']] : '';
  178. $v['industryFieldNewName'] = $industryFieldNewList[$v['industryFieldNew']];
  179. $v['streetName'] = $streetList[$v['street']];
  180. }
  181. } else {
  182. $list = [];
  183. }
  184. return ["total" => $count, "rows" => $list];
  185. }
  186. public static function getRecordList($request) {
  187. $companyId = session('user')['companyId'];
  188. $company_info = CompanyApi::getOne($companyId);
  189. $where = [];
  190. $whereRaw = "";
  191. $where[] = ['r.type', '=', session('user')['type']];
  192. if ($company_info['code'] != 'super' && !self::chkUserInSuperusers()) {
  193. if (session('user')['type'] == 1) {
  194. $whr[] = ["companyId", "=", $companyId];
  195. $whr[] = ["delete", "=", 0];
  196. $list = \app\common\model\EnterpriseVerifyMgr::where($whr)->select()->toArray();
  197. $talentType = []; //查找单位对应标签
  198. $org = [];
  199. $ins = [];
  200. $uniCodes = [];
  201. foreach ($list as $k => $v) {
  202. if (!empty($v['enterpriseTag'])) {
  203. array_push($talentType, $v['enterpriseTag']);
  204. }
  205. if (!empty($v['organizationTag'])) {
  206. array_push($org, $v['organizationTag']);
  207. }
  208. if (!empty($v['institutionTag'])) {
  209. array_push($ins, $v['institutionTag']);
  210. }
  211. if (!empty($v["uniCode"])) {
  212. $codes = explode(",", $v["uniCode"]);
  213. $uniCodes = array_merge($uniCodes, (array) $codes);
  214. }
  215. }
  216. $_whr[] = ["uniCode", "<>", ""];
  217. $_whr[] = ["delete", "=", 0];
  218. $_whr[] = ["companyId", "<>", $companyId];
  219. $_list = \app\common\model\EnterpriseVerifyMgr::where($_whr)->select()->toArray();
  220. $expUniCodes = []; //排除其它单位的例外
  221. foreach ($_list as $_v) {
  222. $codes = explode(",", $_v["uniCode"]);
  223. $expUniCodes = array_merge($expUniCodes, (array) $codes);
  224. }
  225. if (($talentType || $org || $ins) && $uniCodes) {
  226. if ($expUniCodes) {
  227. $whereRaw = sprintf('(newEnterpriseTag in ("%s") or newOrganizationTag in ("%s") or newInstitutionTag in ("%s") and newIdCard not in ("%s")) or newIdCard in ("%s")', implode('","', $talentType), implode('","', $org), implode('","', $ins), implode('","', $expUniCodes), implode('","', $uniCodes));
  228. } else {
  229. $whereRaw = sprintf('newEnterpriseTag in ("%s") or newOrganizationTag in ("%s") or newInstitutionTag in ("%s") or newIdCard in ("%s")', implode('","', $talentType), implode('","', $org), implode('","', $ins), implode('","', $uniCodes));
  230. }
  231. }
  232. if (($talentType || $org || $ins) && !$uniCodes) {
  233. if ($expUniCodes) {
  234. $whereRaw = sprintf('newEnterpriseTag in ("%s") or newOrganizationTag in ("%s") or newInstitutionTag in ("%s") and newIdCard not in ("%s")', implode('","', $talentType), implode('","', $org), implode('","', $ins), implode('","', $expUniCodes));
  235. } else {
  236. $whereRaw = sprintf('newEnterpriseTag in ("%s") or newOrganizationTag in ("%s") or newInstitutionTag in ("%s") ', implode('","', $talentType), implode('","', $org), implode('","', $ins));
  237. }
  238. }
  239. }
  240. }
  241. $offset = trim($request->param("offset")) ?: 0;
  242. $limit = trim($request->param("limit")) ?: 10;
  243. $oldName = trim($request->param("oldName"));
  244. $oldIdCard = trim($request->param("oldIdCard"));
  245. $oldLegal = trim($request->param("oldLegal"));
  246. $oldStreet = trim($request->param("oldStreet"));
  247. $oldEnterpriseTag = trim($request->param("oldEnterpriseTag"));
  248. $oldIndustryFieldNew = trim($request->param("oldIndustryFieldNew"));
  249. $newName = trim($request->param("newName"));
  250. $newIdCard = trim($request->param("newIdCard"));
  251. $newAgentName = trim($request->param("newAgentName"));
  252. $newStreet = trim($request->param("newStreet"));
  253. $newEnterpriseTag = trim($request->param("newEnterpriseTag"));
  254. $newIndustryFieldNew = trim($request->param("newIndustryFieldNew"));
  255. $checkState = trim($request->param("checkState"));
  256. if ($oldName) {
  257. $where[] = ["r.oldName", "like", "%{$oldName}%"];
  258. }
  259. if ($oldIdCard) {
  260. $where[] = ["r.oldIdCard", "like", "%{$oldIdCard}%"];
  261. }
  262. if ($oldLegal) {
  263. $where[] = ["r.oldLegal", "like", "%{$oldLegal}%"];
  264. }
  265. if ($oldStreet) {
  266. $where[] = ["r.oldStreet", "=", "{$oldStreet}"];
  267. }
  268. if ($oldEnterpriseTag) {
  269. $where[] = ["r.oldEnterpriseTag", "=", "{$oldEnterpriseTag}"];
  270. }
  271. if ($oldIndustryFieldNew) {
  272. $where[] = ["r.oldIndustryFieldNew", "=", "{$oldIndustryFieldNew}"];
  273. }
  274. if ($newName) {
  275. $where[] = ["r.newName", "like", "%{$newName}%"];
  276. }
  277. if ($newIdCard) {
  278. $where[] = ["r.newIdCard", "like", "%{$newIdCard}%"];
  279. }
  280. if ($newAgentName) {
  281. $where[] = ["r.newAgentName", "like", "%{$newAgentName}%"];
  282. }
  283. if ($checkState) {
  284. $where[] = ["r.checkState", "=", "{$checkState}"];
  285. } else {
  286. $where[] = ['r.checkState', '>', 1];
  287. }
  288. if ($newStreet) {
  289. $where[] = ["r.newStreet", "=", "{$newStreet}"];
  290. }
  291. if ($newEnterpriseTag) {
  292. $where[] = ["r.newEnterpriseTag", "=", "{$newEnterpriseTag}"];
  293. }
  294. if ($newIndustryFieldNew) {
  295. $where[] = ["r.newIndustryFieldNew", "=", "{$newIndustryFieldNew}"];
  296. }
  297. $where[] = ["e.delete", "=", 0];
  298. if ($whereRaw) {
  299. $count = EnterpriseRecord::alias("r")->leftJoin("un_enterprise e", "e.id=r.mainId")->where($where)->whereRaw($whereRaw)->count();
  300. } else {
  301. $count = EnterpriseRecord::alias("r")->leftJoin("un_enterprise e", "e.id=r.mainId")->where($where)->count();
  302. }
  303. if ($count > 0) {
  304. $talentTypeList = DictApi::selectByParentCode("enterprise_tag");
  305. $industryFieldNewList = DictApi::selectByParentCode("industry_field");
  306. $streetList = DictApi::selectByParentCode("street");
  307. if ($whereRaw) {
  308. $list = EnterpriseRecord::alias("r")->leftJoin("un_enterprise e", "e.id=r.mainId")->field("r.*")->where($where)->whereRaw($whereRaw)->limit($offset, $limit)->order("r.createTime", 'desc')->select()->toArray();
  309. } else {
  310. $list = EnterpriseRecord::alias("r")->leftJoin("un_enterprise e", "e.id=r.mainId")->field("r.*")->where($where)->limit($offset, $limit)->order("r.createTime", 'desc')->select()->toArray();
  311. }
  312. foreach ($list as $k => &$v) {
  313. $v['oldStreetName'] = $streetList[$v['oldStreet']];
  314. $v['newStreetName'] = $streetList[$v['newStreet']];
  315. $v['oldEnterpriseTagName'] = $talentTypeList[$v['oldEnterpriseTag']];
  316. $v['newEnterpriseTagName'] = $talentTypeList[$v['newEnterpriseTag']]; //此处旧字段为talentType,新字段为enterpriseTag,为防止数据污染与丢失,因而这样写
  317. $v['oldIndustryFieldNewName'] = $industryFieldNewList[$v['oldIndustryFieldNew']];
  318. $v['newIndustryFieldNewName'] = $industryFieldNewList[$v['newIndustryFieldNew']];
  319. }
  320. } else {
  321. $list = [];
  322. }
  323. return ["total" => $count, "rows" => $list];
  324. }
  325. public static function getExportList($request) {
  326. $companyId = session('user')['companyId'];
  327. $company_info = CompanyApi::getOne($companyId);
  328. $where = [];
  329. $whereRaw = "";
  330. $where[] = ['r.type', '=', session('user')['type']];
  331. if ($company_info['code'] != 'super' && !self::chkUserInSuperusers()) {
  332. if (session('user')['type'] == 1) {
  333. $whr[] = ["companyId", "=", $companyId];
  334. $whr[] = ["delete", "=", 0];
  335. $list = \app\common\model\EnterpriseVerifyMgr::where($whr)->select()->toArray();
  336. $talentType = []; //查找单位对应标签
  337. $org = [];
  338. $ins = [];
  339. $uniCodes = [];
  340. foreach ($list as $k => $v) {
  341. if (!empty($v['enterpriseTag'])) {
  342. array_push($talentType, $v['enterpriseTag']);
  343. }
  344. if (!empty($v['organizationTag'])) {
  345. array_push($org, $v['organizationTag']);
  346. }
  347. if (!empty($v['institutionTag'])) {
  348. array_push($ins, $v['institutionTag']);
  349. }
  350. if (!empty($v["uniCode"])) {
  351. $codes = explode(",", $v["uniCode"]);
  352. $uniCodes = array_merge($uniCodes, (array) $codes);
  353. }
  354. }
  355. $_whr[] = ["uniCode", "<>", ""];
  356. $_whr[] = ["delete", "=", 0];
  357. $_whr[] = ["companyId", "<>", $companyId];
  358. $_list = \app\common\model\EnterpriseVerifyMgr::where($_whr)->select()->toArray();
  359. $expUniCodes = []; //排除其它单位的例外
  360. foreach ($_list as $_v) {
  361. $codes = explode(",", $_v["uniCode"]);
  362. $expUniCodes = array_merge($expUniCodes, (array) $codes);
  363. }
  364. if (($talentType || $org || $ins) && $uniCodes) {
  365. if ($expUniCodes) {
  366. $whereRaw = sprintf('(newEnterpriseTag in ("%s") or newOrganizationTag in ("%s") or newInstitutionTag in ("%s") and newIdCard not in ("%s")) or newIdCard in ("%s")', implode('","', $talentType), implode('","', $org), implode('","', $ins), implode('","', $expUniCodes), implode('","', $uniCodes));
  367. } else {
  368. $whereRaw = sprintf('newEnterpriseTag in ("%s") or newOrganizationTag in ("%s") or newInstitutionTag in ("%s") or newIdCard in ("%s")', implode('","', $talentType), implode('","', $org), implode('","', $ins), implode('","', $uniCodes));
  369. }
  370. }
  371. if (($talentType || $org || $ins) && !$uniCodes) {
  372. if ($expUniCodes) {
  373. $whereRaw = sprintf('newEnterpriseTag in ("%s") or newOrganizationTag in ("%s") or newInstitutionTag in ("%s") and newIdCard not in ("%s")', implode('","', $talentType), implode('","', $org), implode('","', $ins), implode('","', $expUniCodes));
  374. } else {
  375. $whereRaw = sprintf('newEnterpriseTag in ("%s") or newOrganizationTag in ("%s") or newInstitutionTag in ("%s") ', implode('","', $talentType), implode('","', $org), implode('","', $ins));
  376. }
  377. }
  378. }
  379. }
  380. $offset = trim($request->param("offset")) ?: 0;
  381. $limit = trim($request->param("limit")) ?: 10;
  382. $oldName = urldecode(trim($request->param("oldName")));
  383. $oldIdCard = urldecode(trim($request->param("oldIdCard")));
  384. $oldLegal = urldecode(trim($request->param("oldLegal")));
  385. $oldStreet = urldecode(trim($request->param("oldStreet")));
  386. $oldEnterpriseTag = urldecode(trim($request->param("oldEnterpriseTag")));
  387. $oldIndustryFieldNew = urldecode(trim($request->param("oldIndustryFieldNew")));
  388. $newName = urldecode(trim($request->param("newName")));
  389. $newIdCard = urldecode(trim($request->param("newIdCard")));
  390. $newAgentName = urldecode(trim($request->param("newAgentName")));
  391. $newStreet = urldecode(trim($request->param("newStreet")));
  392. $newEnterpriseTag = urldecode(trim($request->param("newEnterpriseTag")));
  393. $newIndustryFieldNew = urldecode(trim($request->param("newIndustryFieldNew")));
  394. $checkState = urldecode(trim($request->param("checkState")));
  395. if ($oldName) {
  396. $where[] = ["oldName", "like", "%{$oldName}%"];
  397. }
  398. if ($oldIdCard) {
  399. $where[] = ["oldIdCard", "like", "%{$oldIdCard}%"];
  400. }
  401. if ($oldLegal) {
  402. $where[] = ["oldLegal", "like", "%{$oldLegal}%"];
  403. }
  404. if ($oldStreet) {
  405. $where[] = ["oldStreet", "=", "{$oldStreet}"];
  406. }
  407. if ($oldEnterpriseTag) {
  408. $where[] = ["oldEnterpriseTag", "=", "{$oldEnterpriseTag}"];
  409. }
  410. if ($oldIndustryFieldNew) {
  411. $where[] = ["oldIndustryFieldNew", "=", "{$oldIndustryFieldNew}"];
  412. }
  413. if ($newName) {
  414. $where[] = ["newName", "like", "%{$newName}%"];
  415. }
  416. if ($newIdCard) {
  417. $where[] = ["newIdCard", "like", "%{$newIdCard}%"];
  418. }
  419. if ($newAgentName) {
  420. $where[] = ["newAgentName", "like", "%{$newAgentName}%"];
  421. }
  422. if ($checkState) {
  423. $where[] = ["r.checkState", "=", "{$checkState}"];
  424. } else {
  425. $where[] = ['r.checkState', '>', 1];
  426. }
  427. if ($newStreet) {
  428. $where[] = ["newStreet", "=", "{$newStreet}"];
  429. }
  430. if ($newEnterpriseTag) {
  431. $where[] = ["newEnterpriseTag", "=", "{$newEnterpriseTag}"];
  432. }
  433. if ($newIndustryFieldNew) {
  434. $where[] = ["newIndustryFieldNew", "=", "{$newIndustryFieldNew}"];
  435. }
  436. $where[] = ["e.delete", "=", 0];
  437. if ($whereRaw) {
  438. $count = EnterpriseRecord::alias("r")->leftJoin("un_enterprise e", "e.id=r.mainId")->where($where)->whereRaw($whereRaw)->count();
  439. } else {
  440. $count = EnterpriseRecord::alias("r")->leftJoin("un_enterprise e", "e.id=r.mainId")->where($where)->count();
  441. }
  442. if ($count > 0) {
  443. $organizationTagList = DictApi::selectByParentCode("organization_tag");
  444. $institutionTag = DictApi::selectByParentCode("institution_tag");
  445. $talentTypeList = DictApi::selectByParentCode("enterprise_tag");
  446. $enterpriseTypeList = DictApi::selectByParentCode("enterprise_type");
  447. $industryFieldNewList = DictApi::selectByParentCode("industry_field");
  448. $streetList = DictApi::selectByParentCode("street");
  449. $agencyTypeList = DictApi::selectByParentCode("agency_type");
  450. if ($whereRaw) {
  451. $list = EnterpriseRecord::alias("r")->leftJoin("un_enterprise e", "e.id=r.mainId")->field("r.*")->where($where)->whereRaw($whereRaw)->order("createTime", 'desc')->select()->toArray();
  452. } else {
  453. $list = EnterpriseRecord::alias("r")->leftJoin("un_enterprise e", "e.id=r.mainId")->field("r.*")->where($where)->order("createTime", 'desc')->select()->toArray();
  454. }
  455. foreach ($list as $k => &$v) {
  456. if ($v["special"] == 1) {
  457. $v["typeName"] = "事业单位";
  458. $v["oldAgencyTagName"] = $institutionTag[$v["oldInstitutionTag"]];
  459. $v["newAgencyTagName"] = $institutionTag[$v["newInstitutionTag"]];
  460. } else if ($v["special"] == 2) {
  461. $v["typeName"] = "民办非企业";
  462. $v["oldAgencyTagName"] = $organizationTagList[$v["oldOrganizationTag"]];
  463. $v["newAgencyTagName"] = $organizationTagList[$v["newOrganizationTag"]];
  464. } else {
  465. $v["typeName"] = "企业用户";
  466. if ($v["type"] == 1) {
  467. $v["typeName"] .= "(晋江市现代产业体系人才)";
  468. } else if ($v["type"] == 2) {
  469. $v["typeName"] .= "(集成电路优秀人才)";
  470. }
  471. }
  472. $v['oldStreetName'] = $streetList[$v['oldStreet']];
  473. $v['newStreetName'] = $streetList[$v['newStreet']];
  474. $v['oldEnterpriseTagName'] = $talentTypeList[$v['oldEnterpriseTag']];
  475. $v['newEnterpriseTagName'] = $talentTypeList[$v['newEnterpriseTag']]; //此处旧字段为talentType,新字段为enterpriseTag,为防止数据污染与丢失,因而这样写
  476. $v['oldIndustryFieldNewName'] = $industryFieldNewList[$v['oldIndustryFieldNew']];
  477. $v['newIndustryFieldNewName'] = $industryFieldNewList[$v['newIndustryFieldNew']];
  478. $v["oldIndustryFieldOldName"] = DictApi::findDictByCode($v['oldIndustryFieldOld'])["name"];
  479. $v["newIndustryFieldOldName"] = DictApi::findDictByCode($v['newIndustryFieldOld'])["name"];
  480. $v["oldEnterpriseTypeName"] = $enterpriseTypeList[$v["oldEnterpriseType"]];
  481. $v["newEnterpriseTypeName"] = $enterpriseTypeList[$v["newEnterpriseType"]];
  482. $v["oldAgencyTypeName"] = $agencyTypeList[$v["oldAgencyType"]];
  483. $v["newAgencyTypeName"] = $agencyTypeList[$v["newAgencyType"]];
  484. switch ($v["checkState"]) {
  485. case 1:
  486. $v['checkStateName'] = '保存未提交审核';
  487. break;
  488. case 2:
  489. $v['checkStateName'] = '待审核';
  490. break;
  491. case 3:
  492. $v['checkStateName'] = "审核驳回";
  493. break;
  494. case 4:
  495. $v['checkStateName'] = "审核通过";
  496. break;
  497. case 5:
  498. $v['checkStateName'] = '重新提交';
  499. break;
  500. case 6:
  501. $v['checkStateName'] = '初审驳回';
  502. break;
  503. case 7:
  504. $v['checkStateName'] = '初审通过';
  505. break;
  506. }
  507. }
  508. } else {
  509. $list = [];
  510. }
  511. return $list;
  512. }
  513. public static function updateById($data) {
  514. return Enterprise::update($data);
  515. }
  516. public static function getOneRecord($id) {
  517. return EnterpriseRecord::findOrEmpty($id);
  518. }
  519. private static function getSuperusersForEnterprise() {
  520. $superusers = getJsonConfig("../sys_config.json", "super_users_for_enterprise");
  521. return $superusers;
  522. }
  523. public static function chkUserInSuperusers() {
  524. $superusers = self::getSuperusersForEnterprise();
  525. $account = session("user")["account"];
  526. return in_array($account, $superusers);
  527. }
  528. }