mapper
/**
* 分页获取行程信息
*
* @param page
* @param queryWrapper
* @return
*/
@Select("SELECT trip.*,plan.plan_name,plan.state plan_state FROM t_biz_person_trip trip \r\n"
+ " INNER JOIN t_biz_person_base base ON trip.person_id=base.id \r\n"
+ " INNER JOIN t_biz_control_plan plan ON plan.id= trip.control_plan_id ${ew.customSqlSegment}")
public IPage<BizPersonTrip> getPersonTripPageList(IPage page,
@Param(Constants.WRAPPER) QueryWrapper<BizPersonTrip> queryWrapper);
controller
QueryWrapper<BizPersonTrip> queryWrapper = new QueryWrapper<>();
if (StringUtils.isNotBlank(getPersonTripPageListParam.getPersonCate())) {
queryWrapper.eq("trip.person_cate", getPersonTripPageListParam.getPersonCate());
}
IPage<BizPersonTrip> page = tripMapper.getPersonTripPageList(
new Page(getPersonTripPageListParam.getPageNo(), getPersonTripPageListParam.getPageSize()),
queryWrapper);