查询条件

YJ

2021-05-14 a8178b55132921c08f1eb720dfad2c45cad90589

查询条件

 service-lijin/src/main/java/com/ks/lijin/query/ExpendRecordQuery.java

@@ -1,21 +1,23 @@
package com.ks.lijin.query;


import java.math.BigDecimal;

public class ExpendRecordQuery extends BaseDaoQuery {

    //状态
    public Long id;
    public String uid;

    // 关键词
    public String keyword;
    public Long accountId;

    public String goodsId;

    private Boolean read;
    public BigDecimal money;

    //状态
    public Integer state;
    public Integer num;

    public String title;

    public String rightsId;


}

 service-lijin/src/main/java/com/ks/lijin/service/remote/LiJinExpendRecordServiceImpl.java

@@ -46,8 +46,12 @@
    @Override
    public long count(LiJinExpendRecord obj) {
        ExpendRecordQuery query = new ExpendRecordQuery();
//        query.appId = appId;
//        query.uid = uid;
        query.uid = obj.getUid();
        query.accountId = obj.getAccountId();
        query.goodsId = obj.getGoodsId();
        query.money = obj.getMoney();
        query.title = obj.getTitle();
        query.rightsId = obj.getRightsId();
        return liJinExpendRecordMapper.count(query);
    }

@@ -55,9 +59,12 @@
    @Override
    public List<LiJinExpendRecord> listByPage(int page, int pageSize, LiJinExpendRecord obj) {
        ExpendRecordQuery query = new ExpendRecordQuery();
//        query.appId = appId;
//        query.uid = uid;
//        query.drawStateList = Arrays.asList(new Integer[]{LuckyActivityJoinRecord.DRAW_STATE_UNOPEN});
        query.uid = obj.getUid();
        query.accountId = obj.getAccountId();
        query.goodsId = obj.getGoodsId();
        query.money = obj.getMoney();
        query.title = obj.getTitle();
        query.rightsId = obj.getRightsId();
        query.start = (page - 1) * pageSize;
        query.count = pageSize;
        return liJinExpendRecordMapper.listByPage(query);

 service-lijin/src/main/resources/mapper/LiJinExpendRecordMapper.xml

@@ -107,8 +107,13 @@

  <!-- 非模板 -->
  <sql id="listWhere">
    <if test="query.id!=null">and rd_id=#{query.id}</if>
 <!--   <if test="query.state!=null">and ne_state=#{query.state}</if>-->
    <if test="query.uid!=null">and rd_uid=#{query.uid}</if>
    <if test="query.accountId!=null">and rd_account_id=#{query.accountId}</if>
    <if test="query.goodsId!=null">and rd_goods_id=#{query.goodsId}</if>
    <if test="query.money!=null">and rd_money=#{query.money}</if>
    <if test="query.num!=null">and rd_num=#{query.num}</if>
    <if test="query.title!=null">and rd_title=#{query.title}</if>
    <if test="query.rightsId!=null">and rd_rights_id=#{query.rightsId}</if>
  </sql>