多条件查询-分页

多条件查询-分页

复杂多条件查询-分页

实体类

@Data
public class KqLocationParam {
   

    private Integer groupId;

    private String mapName;

    // 员工工号
    private String userNo;

    // 员工姓名
    private String userLname;


    private String userNoOrName;

    private Integer pageIndex=1;


    private Integer pageSize=10;

}

mapper

IPage<UserVacation> getPersonsByGroupIdList(Page<KqLocationParam> page, @Param("query") KqLocationParam query);

mapperXML

<select id="getPersonsByGroupIdList" resultType="com.bd.scm.domain.models.user.UserVacation">
        select u.user_no,u.user_lname,u.user_depname,u.user_serial from bd_kq_location_group_person as g
        inner join dt_user as u on g.person_id =u.user_serial where g.group_id=