EnterpriseApi.php 27 KB

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