IntegralRecordApi.php 29 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551
  1. <?php
  2. namespace app\common\api;
  3. use app\common\api\DictApi;
  4. use app\admin\model\Enterprise;
  5. use think\facade\Db;
  6. use app\common\model\IntegralRecord;
  7. use app\common\state\IntegralState;
  8. /**
  9. * Description of IntegralRecordApi
  10. *
  11. * @author sgq
  12. */
  13. class IntegralRecordApi {
  14. public static function getOne($id) {
  15. $result = IntegralRecord::where("id", "=", $id)->find();
  16. $result["enterprise"] = EnterpriseApi::getOne($result["enterprise_id"]);
  17. $result["apply_year"] = BatchApi::getOne($result["batch_id"])["batch"];
  18. $result["enterprise"]["streetName"] = DictApi::findDictByCode($result["enterprise"]["street"])["name"];
  19. if ($result) {
  20. $result["items"] = $result->detail;
  21. }
  22. return $result;
  23. }
  24. public static function getList($params) {
  25. $order = $params["order"] ?: "desc";
  26. $offset = $params["offset"] ?: 0;
  27. $limit = $params["limit"] ?: 10;
  28. $where = [];
  29. $where[] = ["e.type", "=", session("user")["type"]];
  30. if (session("user")["usertype"] == 2) {
  31. $where[] = ["enterprise_id", "=", session("user")["uid"]];
  32. }
  33. $where[] = ["ir.delete", "=", 0];
  34. if ($params["apply_year"]) {
  35. $where[] = ["b.batch", "like", "%{$params['apply_year']}%"];
  36. }
  37. if ($params["name"]) {
  38. $where[] = ["ir.name", "like", "%{$params['name']}%"];
  39. }
  40. if ($params["card_number"]) {
  41. $where[] = ["ir.card_number", "like", "%{$params['card_number']}%"];
  42. }
  43. if ($params["phone"]) {
  44. $where[] = ["ir.phone", "like", "%{$params['phone']}%"];
  45. }
  46. if ($params["email"]) {
  47. $where[] = ["ir.email", "like", "%{$params['email']}%"];
  48. }
  49. if ($params["shareholder"]) {
  50. $where[] = ["ir.shareholder", "=", $params['shareholder']];
  51. }
  52. switch ($params["checkState"]) {
  53. case -1:
  54. $where[] = ["tl.state", "in", [IntegralState::VERIFY_FAIL, IntegralState::REVERIFY_FAIL, IntegralState::ZX_FAIL, IntegralState::ANNOUNCED_REVERIFY_FAIL, IntegralState::PUBLISH_FAIL]];
  55. break;
  56. case 1:
  57. $where[] = ["tl.state", "=", IntegralState::SAVE];
  58. break;
  59. case 2:
  60. $where[] = ["tl.state", "in", [IntegralState::VERIFY_REJECT, IntegralState::REVERIFY_REJECT]];
  61. break;
  62. case 3:
  63. $where[] = ["tl.state", "in", [IntegralState::SUBMIT, IntegralState::VERIFY_PASS]];
  64. break;
  65. case 4:
  66. $where[] = ["tl.state", ">=", IntegralState::REVERIFY_PASS];
  67. $where[] = ["tl.state", "not in", [IntegralState::REVERIFY_REJECT, IntegralState::REVERIFY_FAIL]];
  68. break;
  69. case 5:
  70. $where[] = ["tl.state", "=", IntegralState::SUCCESS];
  71. break;
  72. }
  73. $count = IntegralRecord::alias("ir")
  74. ->leftJoin("sys_batch b", "b.id=ir.batch_id")
  75. ->leftJoin("(select description,mainId,last_state,new_state,state,createTime from new_talent_checklog where md5(concat(createTime,mainId,`type`)) in (select md5(concat(max(createTime),mainId,`type`)) from `new_talent_checklog` where `type`=20 and `step` is null and active=1 and typeFileId is null group by mainId,`type`)) tl", "`tl`.`mainId`=ir.id")
  76. ->leftJoin("un_enterprise e", "e.id=ir.enterprise_id")->where($where)->count();
  77. $list = IntegralRecord::alias("ir")
  78. ->leftJoin("sys_batch b", "b.id=ir.batch_id")
  79. ->leftJoin("(select description,mainId,last_state,new_state,state,createTime from new_talent_checklog where md5(concat(createTime,mainId,`type`)) in (select md5(concat(max(createTime),mainId,`type`)) from `new_talent_checklog` where `type`=20 and `step` is null and active=1 and typeFileId is null group by mainId,`type`)) tl", "`tl`.`mainId`=ir.id")
  80. ->leftJoin("un_enterprise e", "e.id=ir.enterprise_id")->where($where)->field("ir.*,b.batch as apply_year,tl.state,tl.new_state,if(ir.updateTime is not null,ir.updateTime,ir.createTime) as orderTime")
  81. ->limit($offset, $limit)
  82. ->order("orderTime " . $order)
  83. ->select();
  84. foreach ($list as $key => $item) {
  85. $tmp_items = [];
  86. foreach ($item["detail"] as $_item) {
  87. $integral_item_info = getCacheById("IntegralItem", $_item["item_id"]);
  88. $tmp_items[] = sprintf("%s(%s%s)", $integral_item_info["name"], $_item["amount"], $integral_item_info["unit"]);
  89. }
  90. $list[$key]["details"] = implode(",", $tmp_items);
  91. $list[$key]["type"] = session("user")["type"];
  92. $last_log = TalentLogApi::getLastLog($item["id"], \app\common\state\ProjectState::INTEGRAL);
  93. $list[$key]["real_state"] = $last_log["state"];
  94. $list[$key]["last_state"] = $last_log["last_state"];
  95. }
  96. return ["total" => $count, "rows" => $list];
  97. }
  98. public static function getPublicList($params) {
  99. $order = $params["order"];
  100. $offset = $params["offset"];
  101. $limit = $params["limit"];
  102. $where = [];
  103. $where[] = ["e.type", "=", session("user")["type"]];
  104. if ($params["name"]) {
  105. $where[] = ["ir.name", "like", "%" . $params["name"] . "%"];
  106. }
  107. switch ($params["checkState"]) {
  108. case 1:
  109. $where[] = ["ir.checkState", "in", [IntegralState::REVERIFY_PASS, IntegralState::ZX_PASS, IntegralState::ANNOUNCED, IntegralState::ANNOUNCED_REVERIFY_PASS, IntegralState::PUBLISH_PASS]];
  110. break;
  111. case 2:
  112. $where[] = ["ir.checkState", "in", [IntegralState::REVERIFY_FAIL, IntegralState::ZX_FAIL, IntegralState::ANNOUNCED_REVERIFY_FAIL, IntegralState::PUBLISH_FAIL]];
  113. break;
  114. }
  115. $type = $params["type"];
  116. switch ($type) {
  117. case 1:
  118. case 2:
  119. $where[] = ["ir.checkState", "=", IntegralState::REVERIFY_PASS];
  120. break;
  121. case 3: //公示
  122. case 7: //公示预览
  123. $where[] = ["ir.checkState", "=", IntegralState::ZX_PASS];
  124. break;
  125. case 4: //公示通过
  126. $where[] = ["ir.checkState", "=", IntegralState::ANNOUNCED];
  127. break;
  128. case 5:
  129. case 8: //公布预览
  130. $where[] = ["ir.checkState", "=", IntegralState::ANNOUNCED_REVERIFY_PASS];
  131. break;
  132. case 6:
  133. $where[] = ["ir.checkState", "=", IntegralState::PUBLISH_PASS];
  134. break;
  135. }
  136. $count = IntegralRecord::alias("ir")->leftJoin("un_enterprise e", "e.id=ir.enterprise_id")->where($where)->count();
  137. $list = IntegralRecord::alias("ir")->leftJoin("un_enterprise e", "e.id=ir.enterprise_id")
  138. ->where($where)
  139. ->limit($offset, $limit)
  140. ->order("ir.createTime " . $order)->field("ir.*,e.name as enterpriseName,e.type as enterprise_type,enterpriseTag")->select()->toArray();
  141. foreach ($list as &$item) {
  142. $item["talent_type"] = $item["enterprise_type"] == 1 ? "晋江市现代产业体系人才" : "集成电路优秀人才";
  143. }unset($item);
  144. return ["total" => $count, "rows" => $list];
  145. }
  146. public static function getListByProcess($params) {
  147. $order = $params["order"] ?: "desc";
  148. $offset = $params["offset"] ?: 0;
  149. $limit = $params["limit"] ?: 10;
  150. $process = $params["process"] ?: 1;
  151. $where = [];
  152. $where[] = ["e.type", "=", session("user")["type"]];
  153. switch ($process) {
  154. case 1://初审阶段
  155. switch ($params["checkState"]) {
  156. case 1://待审核
  157. $where[] = ["ir.checkState", "=", IntegralState::SUBMIT];
  158. $where[] = ["tl.state", "=", IntegralState::SUBMIT];
  159. break;
  160. case 2://驳回
  161. $where[] = ["tl.new_state", "in", [IntegralState::SAVE]];
  162. $where[] = ["tl.state", "in", [IntegralState::VERIFY_REJECT]];
  163. break;
  164. case 3:
  165. //审核失败
  166. $where[] = ["ir.checkState", "in", [IntegralState::VERIFY_FAIL]];
  167. break;
  168. default:
  169. $where[] = ["tl.state", "in", [IntegralState::SUBMIT, IntegralState::VERIFY_REJECT, IntegralState::VERIFY_FAIL]];
  170. }
  171. break;
  172. case 2://复审阶段
  173. switch ($params["checkState"]) {
  174. case 1://待审核
  175. $where[] = ["tl.state", "=", IntegralState::VERIFY_PASS];
  176. break;
  177. case 3:
  178. //审核失败
  179. $where[] = ["tl.state", "in", [IntegralState::VERIFY_FAIL]];
  180. break;
  181. default:
  182. $where[] = ["tl.state", "in", [IntegralState::VERIFY_PASS, IntegralState::REVERIFY_FAIL]];
  183. }
  184. break;
  185. case 3://复审后征信公示等状态
  186. if ($params["checkState"]) {
  187. $where[] = ["ir.checkState", "=", $params["checkState"]];
  188. } else {
  189. $where[] = ["ir.checkState", "in", [IntegralState::REVERIFY_PASS, IntegralState::ZX_PASS, IntegralState::ZX_FAIL, IntegralState::ANNOUNCED, IntegralState::ANNOUNCED_REVERIFY_PASS, IntegralState::ANNOUNCED_REVERIFY_FAIL, IntegralState::PUBLISH_PASS, IntegralState::PUBLISH_FAIL, IntegralState::SUCCESS]];
  190. }
  191. break;
  192. case 4:
  193. return self::getLibraryList($params);
  194. case 5:
  195. $where[] = ["ir.checkState", "=", IntegralState::SUCCESS];
  196. break;
  197. }
  198. $where[] = ["ir.delete", "=", 0];
  199. if ($params["apply_year"]) {
  200. $where[] = ["b.batch", "like", "%{$params['apply_year']}%"];
  201. }
  202. if ($params["name"]) {
  203. $where[] = ["ir.name", "like", "%{$params['name']}%"];
  204. }
  205. if ($params["card_number"]) {
  206. $where[] = ["ir.card_number", "like", "%{$params['card_number']}%"];
  207. }
  208. if ($params["phone"]) {
  209. $where[] = ["ir.phone", "like", "%{$params['phone']}%"];
  210. }
  211. if ($params["email"]) {
  212. $where[] = ["ir.email", "like", "%{$params['email']}%"];
  213. }
  214. if ($params["enterprise_id"]) {
  215. $where[] = ["ir.enterprise_id", "=", $params['enterprise_id']];
  216. }
  217. if ($params["shareholder"]) {
  218. $where[] = ["ir.shareholder", "=", $params['shareholder']];
  219. }
  220. $count = IntegralRecord::alias("ir")->where($where)
  221. ->leftJoin("sys_batch b", "b.id=ir.batch_id")
  222. ->leftJoin("un_enterprise e", "e.id=ir.enterprise_id")
  223. ->leftJoin("(select description,mainId,last_state,new_state,state,createTime from new_talent_checklog where md5(concat(createTime,mainId,`type`)) in (select md5(concat(max(createTime),mainId,`type`)) from `new_talent_checklog` where `type`=20 and `step` is null and active=1 and typeFileId is null group by mainId,`type`)) tl", "`tl`.`mainId`=ir.id")
  224. ->count();
  225. $list = IntegralRecord::alias("ir")->where($where)
  226. ->leftJoin("sys_batch b", "b.id=ir.batch_id")
  227. ->leftJoin("un_enterprise e", "e.id=ir.enterprise_id")
  228. ->leftJoin("(select description,mainId,last_state,new_state,state,createTime from new_talent_checklog where md5(concat(createTime,mainId,`type`)) in (select md5(concat(max(createTime),mainId,`type`)) from `new_talent_checklog` where `type`=20 and `step` is null and active=1 and typeFileId is null group by mainId,`type`)) tl", "`tl`.`mainId`=ir.id")
  229. ->field("ir.*,e.name as enterpriseName,b.batch as apply_year,tl.state as real_state,tl.last_state")->limit($offset, $limit)->order("tl.createTime " . $order)->select();
  230. foreach ($list as $key => $item) {
  231. $tmp_items = [];
  232. foreach ($item["detail"] as $_item) {
  233. $integral_item_info = getCacheById("IntegralItem", $_item["item_id"]);
  234. $tmp_items[] = sprintf("%s(%s%s)", $integral_item_info["name"], $_item["amount"], $integral_item_info["unit"]);
  235. }
  236. $list[$key]["details"] = implode(";", $tmp_items);
  237. $list[$key]["type"] = session("user")["type"];
  238. //$last_log = TalentLogApi::getLastLog($item["id"], \app\common\state\ProjectState::INTEGRAL);
  239. //$list[$key]["real_state"] = $last_log["state"];
  240. //$list[$key]["last_state"] = $last_log["last_state"];
  241. }
  242. return ["total" => $count, "rows" => $list];
  243. }
  244. public static function getLibraryList($params) {
  245. $order = $params["order"] ?: "desc";
  246. $offset = $params["offset"] ?: 0;
  247. $limit = $params["limit"] ?: 10;
  248. $where = [];
  249. $where[] = ["e.type", "=", session("user")["type"]];
  250. $where[] = ["ir.checkState", "=", IntegralState::SUCCESS];
  251. $where[] = ["ir.delete", "=", 0];
  252. if ($params["name"]) {
  253. $where[] = ["ir.name", "like", "%{$params['name']}%"];
  254. }
  255. if ($params["card_number"]) {
  256. $where[] = ["ir.card_number", "like", "%{$params['card_number']}%"];
  257. }
  258. if ($params["enterprise_id"]) {
  259. $where[] = ["ir.enterprise_id", "=", $params['enterprise_id']];
  260. }
  261. if ($params["veto"]) {
  262. $having = "if(min_shareholder=1 and enterprise_veto = 1,true,false) or personal_veto = 1";
  263. } else {
  264. $having = "if(min_shareholder=1 and enterprise_veto = 1,false,true) and personal_veto = 0";
  265. }
  266. $count = IntegralRecord::alias("ir")->where($where)
  267. ->leftJoin("sys_batch b", "b.id=ir.batch_id")
  268. ->leftJoin("un_enterprise e", "e.id=ir.enterprise_id")
  269. ->leftJoin("new_integral_veto iv1", "iv1.enterprise_id=ir.enterprise_id")
  270. ->leftJoin("new_integral_veto iv2", "md5(concat(iv2.card_type,iv2.card_number))=md5(concat(ir.card_type,ir.card_number))")
  271. ->field("min(shareholder) as min_shareholder,if(iv1.`active`=1,iv1.`active`,0) as enterprise_veto,if(iv2.`active`=1,iv2.`active`,0) as personal_veto")
  272. ->group("concat(ir.card_type,ir.card_number)")
  273. ->having($having)
  274. ->count();
  275. $list = IntegralRecord::alias("ir")->where($where)
  276. ->leftJoin("sys_batch b", "b.id=ir.batch_id")
  277. ->leftJoin("un_enterprise e", "e.id=ir.enterprise_id")
  278. ->leftJoin("new_integral_veto iv1", "iv1.enterprise_id=ir.enterprise_id")
  279. ->leftJoin("new_integral_veto iv2", "md5(concat(iv2.card_type,iv2.card_number))=md5(concat(ir.card_type,ir.card_number))")
  280. ->group("concat(ir.card_type,ir.card_number)")
  281. ->having($having)
  282. ->field("min(shareholder) as min_shareholder,ir.name,ir.card_type,ir.card_number,ir.enterprise_id,sum(ir.totalPoints) as totalPoints,e.name as enterpriseName,if(iv1.`active`=1,iv1.`active`,0) as enterprise_veto,iv1.description as enterprise_veto_msg,if(iv2.`active`=1,iv2.`active`,0) as personal_veto,iv2.description as personal_veto_msg")->limit($offset, $limit)->order("b.batch " . $order)->select();
  283. return ["total" => $count, "rows" => $list];
  284. }
  285. public static function checkIsEditable($id) {
  286. $info = self::getOne($id);
  287. if (!$info || !in_array($info["checkState"], [0, IntegralState::SAVE]))
  288. return false;
  289. return true;
  290. }
  291. static public function chkIsOwner($id, $uid) {
  292. $info = self::getOne($id);
  293. if ($info["enterprise_id"] != $uid)
  294. return null;
  295. return $info;
  296. }
  297. /**
  298. * 导出
  299. * @param type $process
  300. * @param type $params
  301. * @return type
  302. */
  303. public static function getExportDatas($process, $params) {
  304. $where[] = [];
  305. //特殊字段处理
  306. $fields = [];
  307. $fields[] = "ir.id";
  308. foreach ($params as $param) {
  309. if (!in_array($param, ["enterpriseName", "street", "checkMsg", "project", "year"])) {
  310. $fields[] = "ir." . $param;
  311. }
  312. }
  313. $fields[] = "e.name as enterpriseName";
  314. $fields[] = "e.street";
  315. $fields[] = "tl.description as checkMsg";
  316. $fields[] = "b.batch as year";
  317. if (in_array("card_type", $params)) {
  318. $cardTypes = DictApi::selectByParentCode("card_type");
  319. }
  320. if (in_array("street", $params)) {
  321. $streets = DictApi::selectByParentCode("street");
  322. }
  323. $sex = [1 => "男", 2 => "女"];
  324. $where = [];
  325. $where[] = ["e.type", "=", session("user")["type"]];
  326. switch ($process) {
  327. case 1:
  328. $where = "ir.checkState in (" . IntegralState::SUBMIT . "," . IntegralState::VERIFY_FAIL . ")";
  329. break;
  330. case 2:
  331. $where = "ir.checkState in (" . IntegralState::VERIFY_PASS . "," . IntegralState::REVERIFY_FAIL . ")";
  332. break;
  333. case 3:
  334. $where = "ir.checkState >= " . IntegralState::REVERIFY_PASS;
  335. break;
  336. }
  337. $list = IntegralRecord::alias("ir")
  338. ->field($fields)
  339. ->leftJoin("un_enterprise e", "e.id=ir.enterprise_id")
  340. ->leftJoin("sys_batch b", "b.id=ir.batch_id")
  341. ->leftJoin("(select description,mainId,last_state,new_state,state,createTime from new_talent_checklog where md5(concat(createTime,mainId,`type`)) in (select md5(concat(max(createTime),mainId,`type`)) from `new_talent_checklog` where `type`=20 and `step` is null and active=1 and typeFileId is null group by mainId,`type`)) tl", "`tl`.`mainId`=ir.id")
  342. //->leftJoin("new_talent_checklog tl", "tl.mainId=ti.id and tl.id=(select id from new_talent_checklog where mainId=ti.id and `step` is null and active=1 and typeFileId is null order by createTime desc limit 1)")
  343. ->whereRaw($where)
  344. ->select()->toArray();
  345. foreach ($list as &$item) {
  346. $item["card_type"] = $cardTypes[$item["card_type"]];
  347. $item["street"] = $streets[$item["street"]];
  348. $item["sex"] = $sex[$item["sex"]];
  349. $item["checkState"] = IntegralState::getStateName($item["checkState"]);
  350. $detail = \app\common\model\IntegralDetail::where("record_id", $item["id"])->select();
  351. $tmp_items = [];
  352. foreach ($detail as $_item) {
  353. $integral_item_info = getCacheById("IntegralItem", $_item["item_id"]);
  354. $tmp_items[] = sprintf("%s(%s%s)", $integral_item_info["name"], $_item["amount"], $integral_item_info["unit"]);
  355. }
  356. $item["project"] = implode(";", $tmp_items);
  357. }unset($item);
  358. return $list;
  359. }
  360. public static function getListByIds($ids) {
  361. $where[] = ["id", "in", $ids];
  362. return IntegralRecord::where($where)->select()->toArray();
  363. }
  364. /**
  365. * 计算积分
  366. * @param type $enterpriseId 企业id
  367. * @param type $cardType 证件类型
  368. * @param type $cardNumber 证件号码
  369. * @param type $itemId 标准id
  370. * @param type $amount 达成数额
  371. * @return \stdClass 完整积分记录对象
  372. */
  373. public static function calIntegral($enterprise_id, $cardType, $cardNumber, $itemId, $amount) {
  374. $returnObj = new \stdClass();
  375. $returnObj->amount = $amount;
  376. $item = getCacheById("IntegralItem", $itemId);
  377. $projectRemainderPoints = 0; //项目剩余总上限
  378. $itemRemainderPoints = 0; //标准剩余总上限
  379. $points = 0; //当前可获得积分
  380. if ($item) {
  381. $project = getCacheById("IntegralProject", $item["projectId"]);
  382. $projectRemainderPoints = $project["max"]; //初始化项目可获得剩余积分
  383. $itemRemainderPoints = $item["max"]; //初始化标准可获得剩余积分
  384. if ($project["limit"] == 1) {
  385. //项目下所有规则总上限
  386. $where = [];
  387. $where[] = ["r.enterprise_id", "=", $enterprise_id];
  388. $where[] = ["r.card_type", "=", $cardType];
  389. $where[] = ["r.card_number", "=", $cardNumber];
  390. $where[] = ["r.checkState", ">=", IntegralState::SUCCESS];
  391. $where[] = ["i.projectId", "=", $project["id"]];
  392. if ($project["yearly"] == 1) {
  393. //年度重置只算当年度
  394. $startTime = date("Y-01-01 00:00:00");
  395. $endTime = date("Y-12-31 23:59:59");
  396. $where[] = ["r.createTime", "between", [$startTime, $endTime]];
  397. $returnObj->projectYearly = 1;
  398. }
  399. $totalPoints = Db::table("new_integral_detail")->alias("d")->leftJoin("new_integral_record r", "r.id=d.record_id")->leftJoin("new_integral_item i", "i.id=d.item_id")->where($where)->sum("d.point");
  400. $projectRemainderPoints -= $totalPoints;
  401. $returnObj->projectMaxPoints = $project["max"];
  402. $returnObj->projectRemainderPoints = $projectRemainderPoints;
  403. }
  404. if ($item["limit"] == 1) {
  405. //规则上限
  406. $where = [];
  407. $where[] = ["r.enterprise_id", "=", $enterprise_id];
  408. $where[] = ["r.card_type", "=", $cardType];
  409. $where[] = ["r.card_number", "=", $cardNumber];
  410. $where[] = ["r.checkState", ">=", IntegralState::SUCCESS];
  411. $where[] = ["d.item_id", "=", $itemId];
  412. if ($item["yearly"] == 1) {
  413. //年度重置只算当年度
  414. $startTime = date("Y-01-01 00:00:00");
  415. $endTime = date("Y-12-31 23:59:59");
  416. $where[] = ["r.createTime", "between", [$startTime, $endTime]];
  417. $returnObj->itemYearly = 1;
  418. }
  419. $totalPoints = Db::table("new_integral_detail")->alias("d")->leftJoin("new_integral_record r", "r.id=d.record_id")->where($where)->sum("d.point");
  420. $itemRemainderPoints -= $totalPoints;
  421. $returnObj->itemMaxPoints = $item["max"];
  422. $returnObj->itemRemainderPoints = $itemRemainderPoints;
  423. }
  424. $where = [];
  425. $where[] = ["r.enterprise_id", "=", $enterprise_id];
  426. $where[] = ["r.card_type", "=", $cardType];
  427. $where[] = ["r.card_number", "=", $cardNumber];
  428. $where[] = ["r.checkState", ">=", IntegralState::SUCCESS];
  429. $where[] = ["d.item_id", "=", $itemId];
  430. $fstGain = Db::table("new_integral_detail")->alias("d")->leftJoin("new_integral_record r", "r.id=d.record_id")->where($where)->field("d.*")->order("createTime asc")->find();
  431. if ($item["stepNeedAmount"] && $item["stepGainPoints"]) {
  432. $returnObj->stepNeedAmount = $item["stepNeedAmount"];
  433. $returnObj->stepGainPoints = $item["stepGainPoints"];
  434. if ($fstGain) {
  435. $returnObj->fstGainRecordId = $fstGain["record_id"];
  436. $returnObj->fstGainDetailId = $fstGain["id"];
  437. //有配置增量积分
  438. if ($item["stepIsYear"] == 1) {
  439. //较上年度增量
  440. $where = [];
  441. $where[] = ["r.enterprise_id", "=", $enterprise_id];
  442. $where[] = ["r.card_type", "=", $cardType];
  443. $where[] = ["r.card_number", "=", $cardNumber];
  444. $where[] = ["r.checkState", ">=", IntegralState::SUCCESS];
  445. $where[] = ["d.item_id", "=", $itemId];
  446. $startTime = date("Y-m-d 00:00:00", strtotime("first day of last year"));
  447. $endTime = date("Y-12-31 23:59:59", strtotime("last day of last year"));
  448. $where[] = ["r.createTime", "between", [$startTime, $endTime]];
  449. $lastYearTotalAmount = Db::table("new_integral_detail")->alias("d")->leftJoin("new_integral_record r", "r.id=d.record_id")->where($where)->sum("d.amount");
  450. $newGainAmount = $amount - $lastYearTotalAmount;
  451. $times = floor($newGainAmount / $item["stepNeedAmount"]);
  452. $returnObj->stepIsYear = 1;
  453. $returnObj->lastYearTotalAmount = $lastYearTotalAmount;
  454. $returnObj->newGainAmount = $newGainAmount;
  455. } else {
  456. $times = floor($amount / $item["stepNeedAmount"]);
  457. $returnObj->stepAmount = $amount;
  458. }
  459. $points = $item["stepGainPoints"] * $times;
  460. $returnObj->times = $times;
  461. $returnObj->points = $returnObj->stepPoints = $points;
  462. } else {
  463. //首次
  464. $returnObj->fstNeedAmount = $item["fstNeedAmount"];
  465. $returnObj->fstGainPoints = $item["fstGainPoints"];
  466. $returnObj->fstAmount = $amount >= $item["fstNeedAmount"] ? $item["fstNeedAmount"] : $amount;
  467. $returnObj->fstPoints = $amount >= $item["fstNeedAmount"] ? $item["fstGainPoints"] : 0;
  468. if ($item["stepIsYear"] != 1) {
  469. //未设置较上年度增量时,首次还需计算增量部分
  470. $stepAmount = $amount - $item["fstNeedAmount"];
  471. if ($stepAmount > 0) {
  472. $times = floor($stepAmount / $item["stepNeedAmount"]);
  473. $returnObj->stepAmount = $stepAmount;
  474. $returnObj->times = $times;
  475. $returnObj->stepPoints = $item["stepGainPoints"] * $times;
  476. }
  477. } else {
  478. $returnObj->stepIsYear = 1;
  479. }
  480. $returnObj->points = $returnObj->stepPoints ? $returnObj->fstPoints + $returnObj->stepPoints : $returnObj->fstPoints;
  481. }
  482. } else {
  483. //仅首次可得积分
  484. if ($fstGain) {
  485. $returnObj->points = 0;
  486. $returnObj->msg = "仅首次能获得积分";
  487. } else {
  488. $returnObj->fstNeedAmount = $item["fstNeedAmount"];
  489. $returnObj->fstGainPoints = $item["fstGainPoints"];
  490. $returnObj->fstAmount = $amount >= $item["fstNeedAmount"] ? $item["fstNeedAmount"] : $amount;
  491. $returnObj->points = $returnObj->fstPoints = $amount >= $item["fstNeedAmount"] ? $item["fstGainPoints"] : 0;
  492. }
  493. }
  494. $point1 = $project["limit"] == 1 ? ($returnObj->projectRemainderPoints > $returnObj->points ? $returnObj->points : $returnObj->projectRemainderPoints) : $returnObj->points;
  495. $point2 = $item["limit"] == 1 ? ($returnObj->itemRemainderPoints > $returnObj->points ? $returnObj->points : $returnObj->itemRemainderPoints) : $returnObj->points;
  496. $returnObj->theoretical = $returnObj->points; //理论值
  497. $returnObj->points = $point1 > $point2 ? $point2 : $point1; //实际值,当有限额时,会与理论值有偏差
  498. }
  499. return $returnObj;
  500. }
  501. public static function setPublic($mainId, $state, $msg, $batch = null) {
  502. $data["id"] = $mainId;
  503. $data["checkState"] = $state;
  504. switch ($state) {
  505. case IntegralState::ZX_PASS:
  506. case IntegralState::ZX_FAIL:
  507. $data["isPublic"] = 2;
  508. break;
  509. case IntegralState::ANNOUNCED:
  510. $data["isPublic"] = 3;
  511. $data["publicBatch"] = $batch;
  512. break;
  513. case IntegralState::ANNOUNCED_REVERIFY_PASS:
  514. case IntegralState::ANNOUNCED_REVERIFY_FAIL:
  515. $data["isPublic"] = 3;
  516. break;
  517. case IntegralState::PUBLISH_PASS:
  518. $data["getTime"] = $batch;
  519. $data["isPublic"] = 4;
  520. break;
  521. case IntegralState::PUBLISH_FAIL:
  522. $data["isPublic"] = 4;
  523. break;
  524. }
  525. if (IntegralRecord::update($data)) {
  526. TalentLogApi::write(\app\common\state\ProjectState::INTEGRAL, $mainId, $state, $msg, 1);
  527. return true;
  528. }
  529. return false;
  530. }
  531. }