| | |
| | | <if test="staffJoinLeaveRecord.staffName != null and staffJoinLeaveRecord.staffName != '' "> |
| | | AND t1.staff_name LIKE CONCAT('%',#{staffJoinLeaveRecord.staffName},'%') |
| | | </if> |
| | | <if test="staffOnJob.deptPositionId != null"> |
| | | AND t1.dept_position_id = #{staffOnJob.deptPositionId} |
| | | <if test="staffJoinLeaveRecord.deptPositionId != null"> |
| | | AND t1.dept_position_id = #{staffJoinLeaveRecord.deptPositionId} |
| | | </if> |
| | | <if test="staffJoinLeaveRecord.entryDateStart != null and staffJoinLeaveRecord.entryDateStart != '' "> |
| | | and t1.contract_start_time like concat('%',#{staffJoinLeaveRecord.entryDateStart},'%') |