src/main/resources/mapper/collaborativeApproval/StaffContactsPersonalMapper.xml
@@ -17,7 +17,7 @@ sjlr.phone, scp.create_time FROM staff_contacts_personal scp LEFT JOIN (select * from staff_join_leave_record WHERE staff_state = 1) sjlr ON scp.contact_id=sjlr.id LEFT JOIN (select * from staff_on_job WHERE staff_state = 1) sjlr ON scp.contact_id=sjlr.id where 1=1 <if test="staffContactsPersonalDTO.staffName != null and staffContactsPersonalDTO.staffName != ''"> and sjlr.staff_name like concat('%',#{staffContactsPersonalDTO.staffName},'%') src/main/resources/mapper/lavorissue/LavorIssueMapper.xml
@@ -10,7 +10,7 @@ t3.dict_label as dictName, t4.dict_label as dictTypeName from labor_issue t1 left join staff_join_leave_record t2 on t1.staff_id = t2.id left join staff_on_job t2 on t1.staff_id = t2.id left join sys_dict_data t3 on t1.dict_id = t3.dict_value left join sys_dict_data t4 on t1.dict_type = t4.dict_value <where> @@ -45,7 +45,7 @@ t3.dict_label as dictName, t4.dict_label as dictTypeName from labor_issue t1 left join staff_join_leave_record t2 on t1.staff_id = t2.id left join staff_on_job t2 on t1.staff_id = t2.id left join sys_dict_data t3 on t1.dict_id = t3.dict_value left join sys_dict_data t4 on t1.dict_type = t4.dict_value <where>
