feat: 台账SQL调整

cy

2023-11-22 279e16eab8872fc85c1dadc1302fbf04569fdaf9

 consum-base/src/main/java/com/consum/base/pojo/LWhFormInventoryParam.java

@@ -1,8 +1,13 @@
package com.consum.base.pojo;

import com.walker.web.param.ParamRequest;
import io.swagger.annotations.ApiModel;
import lombok.Data;

@Data
@ApiModel(value = "盘点单条件参数")
public class LWhFormInventoryParam extends ParamRequest {

    private Long id;
    /**
     * 盘点单号
@@ -17,95 +22,57 @@
     */
    private Long warehouseId;
    /**
     * 盘点人
     * 操作人
     */
    private Long operatorId;
    private Long operatorUserId;
    /**
     * 监盘人
     */
    private Integer operatorId2;
    /**
     * 备注
     */
    private String beiz1;
    private Long monitorUserId;

    /**
     * 盘点时间 开始
     */
    private Long inventoryDateStart;
    private Long startTime;
    /**
     * 盘点时间 结束
     */
    private Long inventoryDateEnd;
    private Long endTime;
    /**
     * 机构id
     */
    private Long agencyId;
    /**
     * 物品名称
     */
    private String goodsTemplateName;
    /**
     * 规格型号id
     */
    private Long baseGoodsModelsId;
    /**
     * 类型(出入库类型) 2=盘盈；3=盘亏
     */
    private Integer inventoryResult;
    /**
     * 出入库单号
     */
    private Long warehouseFormCode;
    /**
     * 盘点人
     */
    private String operatorName;
    /**
     * 时间(盘点结束时间) 开始
     */
    private Long stopTimeStart;
    /**
     * 时间(盘点结束时间) 结束
     */
    private Long stopTimeEnd;

    public Long getId() {
        return id;
    }
    private Integer pageSize = 10;
    private Integer pageNum = 1;

    public void setId(Long id) {
        this.id = id;
    }

    public String getBusinessFormCode() {
        return businessFormCode;
    }

    public void setBusinessFormCode(String businessFormCode) {
        this.businessFormCode = businessFormCode;
    }

    public String getBusinessFormName() {
        return businessFormName;
    }

    public void setBusinessFormName(String businessFormName) {
        this.businessFormName = businessFormName;
    }

    public Long getWarehouseId() {
        return warehouseId;
    }

    public void setWarehouseId(Long warehouseId) {
        this.warehouseId = warehouseId;
    }

    public Long getOperatorId() {
        return operatorId;
    }

    public void setOperatorId(Long operatorId) {
        this.operatorId = operatorId;
    }

    public Integer getOperatorId2() {
        return operatorId2;
    }

    public void setOperatorId2(Integer operatorId2) {
        this.operatorId2 = operatorId2;
    }

    public String getBeiz1() {
        return beiz1;
    }

    public void setBeiz1(String beiz1) {
        this.beiz1 = beiz1;
    }

    public Long getInventoryDateStart() {
        return inventoryDateStart;
    }

    public void setInventoryDateStart(Long inventoryDateStart) {
        this.inventoryDateStart = inventoryDateStart;
    }

    public Long getInventoryDateEnd() {
        return inventoryDateEnd;
    }

    public void setInventoryDateEnd(Long inventoryDateEnd) {
        this.inventoryDateEnd = inventoryDateEnd;
    }
}