| | |
|---|
| | | @SqlParser(filter=true) |
|---|
| | | IPage<EmpBaseInfo> clbaseInfoList(@Param("page")Page<EmpBaseInfo> page,@Param("index") String index,@Param("btime") String btime,@Param("etime") String etime,@Param("name") String name,@Param("manOld") String manOld,@Param("womanOld") String womanOld,@Param("list") List<String> lists); |
|---|
| | | |
|---|
| | | |
|---|
| | | @Update("<script> " + |
|---|
| | | " UPDATE t_emp_baseinfo SET seniority = CONCAT(FLOOR(TimeStampDiff(MONTH, entryDate, NOW()) / 12), '年',MOD(TimeStampDiff(MONTH, entryDate, NOW()),12),'月'),\n" + |
|---|
| | | " modifyTime = NOW() \n" + |
|---|
| | | " WHERE empStatus =0; \n" + |
|---|
| | | "</script>") |
|---|
| | | int updateSeniority(); |
|---|
| | | |
|---|
| | | |
|---|
| | | } |
|---|
