模糊查询

模糊查询

log-list.html

// 获取查询条件参数
getSearchParam: function () {
    var _this = this;
    var title = $("input[name='title']").val();
    var createBy = $("input[name='createBy']").val();
    var type = $("select[name='type']").val();
    var beginDate = $("input[name='beginDate']").val();
    var endDate = $("input[name='endDate']").val();
    if (beginDate && endDate) {
        if (Date.parse(beginDate) > Date.parse(endDate)) {
            return "开始日期不能大于结束日期"
        }
    }
    var data = {
        'title': title,
        'type': type,
        'createBy': createBy,
        'beginDate': beginDate,
        'endDate': endDate
    };
    return data;
},

ServiceImpl:

@Override
public PageInfo<SysLog> findPage(Integer pageNum, Integer pageSize, SysLog log) {
    PageHelper.startPage(pageNum, pageSize);

    Example example = new Example(SysLog.class);
    example.setOrderByClause("create_time DESC");
    Example.Criteria criteria = example.createCriteria();
    if (StrUtil.isNotBlank(log.getTitle())) {
        criteria.andLike("title", "%" + log.getTitle() + "%");
    }
    if (StrUtil.isNotBlank(log.getCreateBy())) {
        criteria.andLike("createBy", "%"+log.getCreateBy()+"%");
    }
    if (null != log.getType()) {
        criteria.andEqualTo("type", log.getType());
    }
    if (null != log.getBeginDate()) {
        criteria.andGreaterThanOrEqualTo("createTime", log.getBeginDate());
    }
    if (null != log.getEndDate()) {
        criteria.andLessThanOrEqualTo("createTime", log.getEndDate());
    }
    PageInfo<SysLog> pageInfo = new PageInfo<>(sysLogMapper.selectByExample(example));
    return pageInfo;
}

页面：

杨某：

@Override
public PageInfo findPage(Integer pageNum, Integer pageSize, SysClientExpense sysClientExpense) {
    PageHelper.startPage(pageNum, pageSize);
    Example example = new Example(SysClientExpense.class);
    Example.Criteria criteria = example.createCriteria();
    //模糊查询条件
    if (!StringUtils.isEmpty(sysClientExpense.getDetails())) {
        criteria.orLike("clientName", "%" + sysClientExpense.getDetails() + "%");
    }
    //类型筛选条件
    if (null != sysClientExpense.getType()) {
        Example.Criteria addCriteria = example.createCriteria();
        addCriteria.andEqualTo("type", sysClientExpense.getType());
        example.and(addCriteria);
    }
    //时间区间筛选条件
    if ((sysClientExpense.getTime() != null) && (sysClientExpense.getTimeSearch() != null)) {
        Example.Criteria addCriteria = example.createCriteria();
        Example.Criteria time = addCriteria.andBetween("time", sysClientExpense.getTime(), sysClientExpense.getTimeSearch());
        example.and(addCriteria);
    }
    example.orderBy("id").desc();
    return new PageInfo(sysClientExpenseMapper.selectByExample(example));
}