| | |
| | | @Update("<script> " + |
| | | " UPDATE t_emp_contractinfo SET contractStatus='4',\n" + |
| | | " empStatus='1',\n" + |
| | | " remindFlag=1,\n" + |
| | | " modifyTime = NOW(),\n" + |
| | | " modifier = #{operatorId}, \n" + |
| | | " version = version+1 \n" + |
| | | " WHERE TO_DAYS(t_emp_contractinfo.endDate) = TO_DAYS(NOW()) " + |
| | | "</script>") |
| | | int autoStopContract(@Param("operatorId") String operatorId); |
| | | |
| | | @Update("<script>" + |
| | | " UPDATE t_emp_contractinfo SET diffDay=DATEDIFF(endDate, NOW())\n" + |
| | | " WHERE endDate>=now()" + |
| | | "</script>") |
| | | int updateContractRemindDay(); |
| | | |
| | | @Update("<script>" + |
| | | " UPDATE t_emp_contractinfo SET remindFlag=1\n" + |
| | | " WHERE contractId=#{contractId}" + |
| | | "</script>") |
| | | int updateEmpContractRemind(@Param("contractId") Long contractId); |
| | | } |