package com.hz.his.vo.bi.revenue;
|
|
import com.fasterxml.jackson.annotation.JsonFormat;
|
import com.gitee.sunchenbin.mybatis.actable.annotation.Column;
|
import com.gitee.sunchenbin.mybatis.actable.annotation.Index;
|
import com.gitee.sunchenbin.mybatis.actable.constants.MySqlTypeConstant;
|
import lombok.Data;
|
import org.springframework.format.annotation.DateTimeFormat;
|
|
import java.math.BigDecimal;
|
import java.util.Date;
|
|
/**
|
*收入确认表查询
|
* @author CJH
|
*/
|
@Data
|
public class RevenueQuery{
|
|
/**其他查询*/
|
private String KeyWord;
|
/**用户CIQ*/
|
private String CIQ;
|
/**是否划扣*/
|
private Integer isDeduction;
|
/**分类名称(同时搜索一级二级)*/
|
private String orderLevelTypeName;
|
/**关联编号*/
|
private String associationNo;
|
/**下单日期*/
|
private Date startOrderTime;
|
/**下单日期*/
|
private Date endOrderTime;
|
/**执行日期*/
|
private Date startDeductionTime;
|
/**执行日期*/
|
private Date endDeductionTime;
|
/**创建日期*/
|
private Date startCreateTime;
|
/**创建日期*/
|
private Date endCreateTime;
|
/**是否过滤测试账号*/
|
private Integer isFilterTestAccount;
|
|
/**请求操作人*/
|
private String operatorId;
|
/**请求操作人*/
|
private String operatorName;
|
|
@Column(comment = "来源类型", length = 2, type = MySqlTypeConstant.INT, isNull = false)
|
private Integer sourceType;
|
@Column(comment = "来源类型名称", type = MySqlTypeConstant.VARCHAR, length = 10)
|
private String sourceTypeName;
|
@Index
|
@Column(comment = "来源标识(根据来源类型存储标识)", type = MySqlTypeConstant.VARCHAR, length = 32, isNull = false)
|
private String sourceId;
|
@Column(comment = "来源编号(根据来源类型存储编号(例:单号、划扣号)", type = MySqlTypeConstant.VARCHAR, length = 64)
|
private String sourceNo;
|
@Index
|
@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
|
@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
|
@Column(comment = "来源业绩时间", type = MySqlTypeConstant.DATETIME, isNull = false)
|
private Date sourceTime;
|
@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
|
@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
|
@Column(comment = "来源创建时间", type = MySqlTypeConstant.DATETIME, isNull = false)
|
private Date sourceCreateTime;
|
|
@Column(comment = "来源总标识(根据来源类型存储标识)", type = MySqlTypeConstant.VARCHAR, length = 32)
|
private String sourceGeneralId;
|
@Column(comment = "来源总编号(根据来源类型存储编号(例:单号、划扣号)", type = MySqlTypeConstant.VARCHAR, length = 64)
|
private String sourceGeneralNo;
|
|
@Column(comment = "营销分类(OrderItemConstants)", length = 64, type = MySqlTypeConstant.VARCHAR, isNull = false)
|
private String marketingType;
|
@Column(comment = "营销分类名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String marketingTypeName;
|
|
@Column(comment = "营销名称", type = MySqlTypeConstant.VARCHAR,length = 128)
|
private String marketingName;
|
|
@Column(comment = "基础分类(OrderItemConstants)", length = 64, type = MySqlTypeConstant.VARCHAR, isNull = false)
|
private String basicType;
|
@Column(comment = "基础分类名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String basicTypeName;
|
|
@Column(comment = "一级分类(OrderItemConstants)", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String firstLevelType;
|
@Column(comment = "一级分类名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String firstLevelTypeName;
|
@Column(comment = "二级分类(OrderItemConstants)", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String secondLevelType;
|
@Column(comment = "二级分类名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String secondLevelTypeName;
|
@Column(comment = "分类父类包括自己JSON，格式:[{\"id\":\"渠道标识\",\"name\":\"渠道名称\",\"parentId\":\"父类标识\"}]", type = MySqlTypeConstant.TEXT,isNull = false)
|
private String classifyJson = "[]";
|
|
@Index
|
@Column(comment = "项目id/商品id（公用标识）", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String commonId;
|
@Column(comment = "项目编号/商品编码", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String commonNo;
|
@Column(comment = "项目名称/商品名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String commonName;
|
|
@Column(comment = "规格", length = 128, type = MySqlTypeConstant.VARCHAR)
|
private String specification;
|
@Column(comment = "资质", length = 128, type = MySqlTypeConstant.VARCHAR)
|
private String qualification;
|
@Column(comment = "项目单位", length = 128, type = MySqlTypeConstant.VARCHAR)
|
private String unit;
|
|
@Column(comment = "科室编号", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String departmentCode;
|
@Column(comment = "科室名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String departmentName;
|
|
@Column(comment = "价格标签", length = 128, type = MySqlTypeConstant.VARCHAR)
|
private String priceTag;
|
|
@Index
|
@Column(comment = "收费订单id", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String payOrderId;
|
@Column(comment = "收费单号", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String payOrderNo;
|
|
@DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
|
@JsonFormat(pattern="yyyy-MM-dd HH:mm:ss",timezone="GMT+8")
|
@Column(comment="结算时间(收费日期)",type = MySqlTypeConstant.DATETIME)
|
private Date orderTime;
|
@DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
|
@JsonFormat(pattern="yyyy-MM-dd HH:mm:ss",timezone="GMT+8")
|
@Column(comment="执行日期",type = MySqlTypeConstant.DATETIME)
|
private Date deductionTime;
|
|
@Column(comment = "业务类型(PerformanceInfoEnum)", type = MySqlTypeConstant.VARCHAR, length = 64)
|
private String businessType;
|
@Column(comment = "业务类型名称", type = MySqlTypeConstant.VARCHAR, length = 64)
|
private String businessTypeName;
|
|
@Index
|
@Column(comment = "用户id", length = 64, type = MySqlTypeConstant.VARCHAR, isNull = false)
|
private String userId;
|
@Column(comment = "会员号(用户编号)", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String memberNO;
|
@Column(comment = "CIQ", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String memberCIQ;
|
@Column(comment = "病例号", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String memberCaseNo;
|
@Column(comment = "客户类别", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String userClass;
|
@Column(comment="是否首次执行", length = 1, type = MySqlTypeConstant.INT)
|
private Integer isFirstDeduction;
|
@Column(comment="会员等级", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String userLevel;
|
@Column(comment="用户名称", type = MySqlTypeConstant.VARCHAR)
|
private String userName;
|
@Column(comment="共享客户", length = 1, type = MySqlTypeConstant.TINYINT)
|
private Integer shareCustomer;
|
@Column(comment = "客户类型", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String userType;
|
|
@Column(comment = "登记人类型", length = 1, type = MySqlTypeConstant.TINYINT)
|
private Integer registrantType;
|
@Index
|
@Column(comment = "登记人Id", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String registrantId;
|
@Column(comment = "登记人名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String registrantName;
|
|
@Index
|
@Column(comment = "执行医生Id(Employee id)", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String deductionDoctorId;
|
@Column(comment = "执行医生名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String deductionDoctorName;
|
|
@Index
|
@Column(comment = "助理医生Id(Employee id)", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String assistantDoctorId;
|
@Column(comment = "助理医生名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String assistantDoctorName;
|
|
@Index
|
@Column(comment = "美容师Id(Employee id)", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String beauticianId;
|
@Column(comment = "美容师名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String beauticianName;
|
|
@Index
|
@Column(comment = "订单id", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String orderId;
|
@Column(comment = "订单编号", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String orderNo;
|
|
@Index
|
@Column(comment = "订单条码id", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String orderItemId;
|
@Column(comment = "订单条码编号", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String orderItemNo;
|
|
@Column(comment = "开单人类型", length = 1, type = MySqlTypeConstant.TINYINT)
|
private Integer orderOpType;
|
@Index
|
@Column(comment = "开单人Id", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String orderOpId;
|
@Column(comment = "开单人名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String orderOpName;
|
|
|
@Column(comment = "开发人类型", length = 1, type = MySqlTypeConstant.TINYINT)
|
private Integer developOpType;
|
@Column(comment = "开发人Id", type = MySqlTypeConstant.VARCHAR)
|
private String developOpId;
|
@Column(comment = "开发人名称", type = MySqlTypeConstant.VARCHAR)
|
private String developOpName;
|
|
@Column(comment = "开发人门店标识", type = MySqlTypeConstant.VARCHAR,length = 64)
|
private String developShopId;
|
@Column(comment = "开发人门店名称", type = MySqlTypeConstant.VARCHAR,length = 64)
|
private String developShopName;
|
|
@Column(comment = "所属咨询师类型", length = 1, type = MySqlTypeConstant.TINYINT)
|
private Integer belongConsultantType;
|
@Index
|
@Column(comment = "用户所属咨询师id(Employee id) 用户划扣时的所属咨询师", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String belongConsultantId;
|
@Column(comment = "用户所属咨询师名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String belongConsultantName;
|
|
@Column(comment = "用户所属咨询师所属门店信息", type = MySqlTypeConstant.LONGTEXT)
|
private String belongConsultantShopInfo;
|
|
@Column(comment = "开单咨询师类型", length = 1, type = MySqlTypeConstant.TINYINT)
|
private Integer orderConsultantType;
|
@Index
|
@Column(comment = "开单咨询师id(Employee id)", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String orderConsultantId;
|
@Column(comment = "开单咨询师名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String orderConsultantName;
|
|
@Column(comment = "收银咨询师类型", length = 1, type = MySqlTypeConstant.TINYINT)
|
private Integer cashierConsultantType;
|
@Index
|
@Column(comment = "收银咨询师id(Employee id)", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String cashierConsultantId;
|
@Column(comment = "收银咨询师名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String cashierConsultantName;
|
|
@Column(comment = "接诊咨询师名称类型", length = 1, type = MySqlTypeConstant.TINYINT)
|
private Integer receptionConsultantType;
|
@Index
|
@Column(comment = "接诊咨询师id(Employee id)", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String receptionConsultantId;
|
@Column(comment = "接诊咨询师名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String receptionConsultantName;
|
|
@Column(comment = "执行咨询师类型", length = 1, type = MySqlTypeConstant.TINYINT)
|
private Integer deductionConsultantType;
|
@Index
|
@Column(comment = "执行咨询师id(Employee id)", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String deductionConsultantId;
|
@Column(comment = "执行咨询师名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String deductionConsultantName;
|
|
@Column(comment = "收入计入", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String revenueRecordedType;
|
@Column(comment = "收入计入名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String revenueRecordedName;
|
|
@Column(comment = "收入主体", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String revenueSubjectType;
|
@Column(comment = "收入主体名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String revenueSubjectName;
|
|
@Column(comment = "原单价", length = 28, type = MySqlTypeConstant.DECIMAL)
|
private BigDecimal originalPrice = BigDecimal.ZERO;
|
@Column(comment = "数量", type = MySqlTypeConstant.INT,length = 11)
|
private Integer quantity;
|
@Column(comment = "未执行次数", type = MySqlTypeConstant.INT)
|
private Integer notUsedNum;
|
|
@Column(comment = "折扣", length = 28, type = MySqlTypeConstant.DECIMAL)
|
private BigDecimal discount = BigDecimal.ZERO;
|
@Column(comment = "折后金额", length = 28, type = MySqlTypeConstant.DECIMAL)
|
private BigDecimal discountAmount = BigDecimal.ZERO;
|
@Column(comment = "收银金额", length = 28, type = MySqlTypeConstant.DECIMAL)
|
private BigDecimal cashierAmount = BigDecimal.ZERO;
|
|
@Column(comment="是否欠费", length = 1, type = MySqlTypeConstant.INT)
|
private Integer isArrears;
|
@Column(comment = "预定金", length = 28, type = MySqlTypeConstant.DECIMAL)
|
private BigDecimal deposit = BigDecimal.ZERO;
|
@Column(comment = "储值金", length = 28, type = MySqlTypeConstant.DECIMAL)
|
private BigDecimal storedValueFund = BigDecimal.ZERO;
|
@Column(comment = "增值金", length = 28, type = MySqlTypeConstant.DECIMAL)
|
private BigDecimal valueAddedFund = BigDecimal.ZERO;
|
@Column(comment = "积分", length = 28, type = MySqlTypeConstant.DECIMAL)
|
private BigDecimal integral = BigDecimal.ZERO;
|
@Column(comment = "积分金额", length = 28, type = MySqlTypeConstant.DECIMAL)
|
private BigDecimal integralAmount = BigDecimal.ZERO;
|
@Column(comment = "虚拟金额", length = 28, type = MySqlTypeConstant.DECIMAL)
|
private BigDecimal virtualAmount = BigDecimal.ZERO;
|
|
@Column(comment = "业绩总额", length = 28, type = MySqlTypeConstant.DECIMAL)
|
private BigDecimal performanceTotal = BigDecimal.ZERO;
|
@Column(comment = "业绩不含税", length = 28, type = MySqlTypeConstant.DECIMAL)
|
private BigDecimal performanceNotHasTax;
|
@Column(comment = "税额", length = 28, type = MySqlTypeConstant.DECIMAL)
|
private BigDecimal taxAmount;
|
|
@Column(comment = "标准耗材成本", length = 28, type = MySqlTypeConstant.DECIMAL)
|
private BigDecimal standardConsumablesCost = BigDecimal.ZERO;
|
@Column(comment = "实际耗材成本", length = 28, type = MySqlTypeConstant.DECIMAL)
|
private BigDecimal actualConsumablesCost = BigDecimal.ZERO;
|
|
@Column(comment = "渠道分类标识(ChannelsType)(必填，代码判断)", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String channelsTypeId;
|
@Column(comment = "渠道分类名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String channelsTypeName;
|
@Column(comment = "渠道标识", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String channelId;
|
@Column(comment = "渠道名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String channelName;
|
|
@Column(comment = "渠道联系人类型", length = 4, type = MySqlTypeConstant.TINYINT)
|
private Integer channelContactType;
|
@Index
|
@Column(comment = "渠道联系人Id", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String channelContactId;
|
@Column(comment = "渠道联系人名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String channelContactName;
|
|
@Column(comment = "渠道合作人类型", length = 1, type = MySqlTypeConstant.TINYINT)
|
private Integer channelPartnerType;
|
@Index
|
@Column(comment = "渠道合作人Id", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String channelPartnerId;
|
@Column(comment = "渠道合作人名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String channelPartnerName;
|
|
@Column(comment = "诊所内部联络人类型", length = 1, type = MySqlTypeConstant.TINYINT)
|
private Integer internalContactType;
|
@Index
|
@Column(comment = "诊所内部联络人Id", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String internalContactId;
|
@Column(comment = "诊所内部联络人名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String internalContactName;
|
|
@Column(comment = "电网咨询师id(Employee id)", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String tmkServiceId;
|
@Column(comment = "电网咨询师名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String tmkServiceName;
|
|
@Column(comment = "客服id(Employee id)", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String chatCorpUserId;
|
@Column(comment = "客服名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String chatCorpUserName;
|
|
@Column(comment = "护士id(Employee id)", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String nurseCorpUserId;
|
@Column(comment = "护士名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String nurseCorpUserName;
|
|
@Column(comment = "洗手护士id(Employee id)", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String handWashNurseId;
|
@Column(comment = "洗手护士名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String handWashNurseName;
|
|
@Column(comment = "巡回护士id(Employee id)", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String circuitingNurseId;
|
@Column(comment = "巡回护士名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String circuitingNurseName;
|
|
@Column(comment = "配台护士id(Employee id)", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String tableNurseId;
|
@Column(comment = "配台护士名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String tableNurseName;
|
|
@Column(comment = "麻醉师id(Employee id)", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String anesthesiologistId;
|
@Column(comment = "麻醉师名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String anesthesiologistName;
|
|
@Column(comment = "疗程总额", length = 28, type = MySqlTypeConstant.DECIMAL)
|
private BigDecimal treatmentTotal;
|
|
@Column(comment = "TMK登记人id(Employee id)", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String tmkRegistrantId;
|
@Column(comment = "TMK登记人名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String tmkRegistrantName;
|
|
@Column(comment = "收费员id(Employee id)", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String chargeId;
|
@Column(comment = "收费员名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String chargeName;
|
|
@Column(comment = "服务门店id", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String serviceShopId;
|
@Column(comment = "服务门店名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String serviceShopName;
|
|
@Column(comment = "用户所属门店id", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String belongShopId;
|
@Column(comment = "用户所属门店名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String belongShopName;
|
|
@Column(comment = "下单门店id", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String orderShopId;
|
@Column(comment = "下单门店名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String orderShopName;
|
|
@Column(comment = "收银门店id", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String cashierShopId;
|
@Column(comment = "收银门店名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String cashierShopName;
|
|
@Column(comment = "收费备注", type = MySqlTypeConstant.TEXT)
|
private String chargeRemark;
|
|
@Column(comment = "营销标签", type = MySqlTypeConstant.TEXT)
|
private String marketingTag;
|
|
@Column(comment="是否转诊转疗", length = 1, type = MySqlTypeConstant.INT)
|
private Integer isTurn;
|
@Column(comment="是否可执行项目", length = 1, type = MySqlTypeConstant.INT)
|
private Integer isDeductionProject;
|
@Column(comment="是否疗程项目", length = 1, type = MySqlTypeConstant.INT)
|
private Integer isTreatmentProject;
|
|
@Column(comment = "购买数量", type = MySqlTypeConstant.INT,length = 11)
|
private Integer buyNum;
|
@Column(comment = "疗程次数", type = MySqlTypeConstant.INT,length = 11)
|
private Integer treatmentNum;
|
@Column(comment = "疗程总数", type = MySqlTypeConstant.INT,length = 11)
|
private Integer treatmentTotality;
|
@Column(comment = "疗程序号", type = MySqlTypeConstant.INT,length = 11)
|
private Integer treatmentNo;
|
|
@Column(comment = "划扣备注", type = MySqlTypeConstant.TEXT)
|
private String deductionRemark;
|
@Column(comment = "免单原因", type = MySqlTypeConstant.TEXT)
|
private String freeReason;
|
|
@Column(comment = "业绩类别(PerformanceInfoEnum)", type = MySqlTypeConstant.VARCHAR, isNull = false)
|
private String performanceCategory;
|
@Column(comment = "业绩类别名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String performanceCategoryName;
|
|
@Column(comment = "订单类型(OrderItemConstants)", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String orderType;
|
@Column(comment = "订单类型名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String orderTypeName;
|
|
@Column(comment = "订单分类(OrderItemConstants)", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private int orderClassify;
|
@Column(comment = "订单类型名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String orderClassifyName;
|
|
@Column(comment = "客户成交标签", type = MySqlTypeConstant.TEXT)
|
private String customerTransactionTag;
|
|
@Column(comment = "订单渠道分类名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String orderChannelsTypeName;
|
|
@Column(comment = "订单一级分类(OrderItemConstants) 渠道为一级渠道id 会员填写空", type = MySqlTypeConstant.VARCHAR, length = 64)
|
private String orderFirstLevelType;
|
@Column(comment = "订单一级分类名称", type = MySqlTypeConstant.VARCHAR, length = 64)
|
private String orderFirstLevelTypeName;
|
@Column(comment = "订单渠道的json，所有父类包括自己:[{\"id\":\"渠道标识\",\"parentId\":\"父类渠道标识\",\"name\":\"渠道名称\"}]", type = MySqlTypeConstant.TEXT)
|
private String orderChannelJson = "[]";
|
@Column(comment = "订单渠道一级编号", type = MySqlTypeConstant.VARCHAR, length = 32)
|
private String orderChannel1No;
|
@Column(comment = "订单渠道一级的分类标识", type = MySqlTypeConstant.VARCHAR, length = 32)
|
private String orderChannel1TypeId;
|
@Column(comment = "订单渠道一级的分类编号", type = MySqlTypeConstant.VARCHAR, length = 32)
|
private String orderChannel1TypeNo;
|
@Column(comment = "订单渠道一级的分类名称", type = MySqlTypeConstant.VARCHAR, length = 50)
|
private String orderChannel1TypeName;
|
|
@Column(comment = "订单二级分类(OrderItemConstants) 渠道为二级渠道id", type = MySqlTypeConstant.VARCHAR, length = 64)
|
private String orderSecondLevelType;
|
@Column(comment = "订单二级分类名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String orderSecondLevelTypeName;
|
@Column(comment = "订单渠道二级编号", type = MySqlTypeConstant.VARCHAR, length = 32)
|
private String orderChannel2No;
|
@Column(comment = "订单渠道二级的联系人名称", length = 50, type = MySqlTypeConstant.VARCHAR)
|
private String orderChannel2Contacts;
|
@Column(comment = "订单渠道二级的部门标识", type = MySqlTypeConstant.VARCHAR, length = 32)
|
private String orderChannel2Depart;
|
@Column(comment = "订单渠道二级的部门名称", type = MySqlTypeConstant.VARCHAR, length = 32)
|
private String orderChannel2DepartName;
|
@Column(comment = "订单渠道二级的分类标识", type = MySqlTypeConstant.VARCHAR, length = 32)
|
private String orderChannel2TypeId;
|
@Column(comment = "订单渠道二级的分类编号", type = MySqlTypeConstant.VARCHAR, length = 32)
|
private String orderChannel2TypeNo;
|
@Column(comment = "订单渠道二级的分类名称", type = MySqlTypeConstant.VARCHAR, length = 50)
|
private String orderChannel2TypeName;
|
@Column(comment = "订单渠道合作人Id", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String orderChannelPartnerId;
|
@Column(comment = "订单渠道合作人名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String orderChannelPartnerName;
|
|
@Column(comment = "客户推荐人分类标识",length = 32, type = MySqlTypeConstant.VARCHAR)
|
private String inviteeTypeId;
|
@Column(comment = "客户推荐人分类名称",length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String inviteeTypeName;
|
@Column(comment = "客户推荐人标识",length = 32, type = MySqlTypeConstant.VARCHAR)
|
private String inviteeId;
|
@Column(comment = "客户推荐人编号",length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String inviteeNo;
|
@Column(comment = "邀请人编号", type = MySqlTypeConstant.VARCHAR, length = 32)
|
private String inviteeCIQ;
|
@Column(comment = "客户推荐人名称",length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String inviteeName;
|
|
@Column(comment = "订单推荐人类型", length = 32, type = MySqlTypeConstant.VARCHAR)
|
private String orderInviteeType;
|
@Column(comment = "订单推荐人名称",length = 32, type = MySqlTypeConstant.VARCHAR)
|
private String orderInviteeTypeName;
|
@Column(comment = "订单推荐人标识",length = 32, type = MySqlTypeConstant.VARCHAR)
|
private String orderInviteeId;
|
@Column(comment = "客户推荐人编号",length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String orderInviteeNo;
|
@Column(comment = "邀请人编号", type = MySqlTypeConstant.VARCHAR, length = 32)
|
private String orderInviteeCIQ;
|
@Column(comment = "订单推荐人名称",length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String orderInviteeName;
|
@Column(comment = "订单推荐人角色信息",length = 128, type = MySqlTypeConstant.VARCHAR)
|
private String orderInviteeRoleInfo;
|
|
@Index
|
@Column(comment = "会员主诊医生Id(Employee id)", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String attendingDoctorId;
|
@Column(comment = "会员主诊医生名称", length = 64, type = MySqlTypeConstant.VARCHAR)
|
private String attendingDoctorName;
|
|
@Column(comment = "治疗单类型（OrderTotalConstants）", length = 2, type = MySqlTypeConstant.INT, isNull = false, defaultValue = "0")
|
private Integer treatOrderClassify;
|
@Column(comment = "治疗单类型（OrderTotalConstants）", length = 32, type = MySqlTypeConstant.VARCHAR)
|
private String treatOrderClassifyName;
|
|
@Column(comment = "优惠券发放人" ,type = MySqlTypeConstant.LONGTEXT)
|
private String couponIssuer;
|
@Column(comment = "优惠券发放人角色" ,type = MySqlTypeConstant.LONGTEXT)
|
private String couponIssuerRole;
|
@Column(comment = "优惠券名称" ,type = MySqlTypeConstant.LONGTEXT)
|
private String couponName;
|
|
@Column(comment = "主渠道" ,type = MySqlTypeConstant.LONGTEXT)
|
private String mainChannelName;
|
@Column(comment = "执行部位" ,type = MySqlTypeConstant.LONGTEXT)
|
private String deductionBodyPartInfo;
|
|
/**页数*/
|
private Integer pageNum;
|
/**条数*/
|
private Integer pageSize;
|
|
public Integer getPageNum() {
|
if(pageNum == null){
|
pageNum = 1;
|
}
|
return pageNum;
|
}
|
|
public void setPageNum(Integer pageNum) {
|
this.pageNum = pageNum;
|
}
|
|
public Integer getPageSize() {
|
if(pageSize == null || pageSize > 500){
|
pageSize = 20;
|
}
|
return pageSize;
|
}
|
|
public void setPageSize(Integer pageSize) {
|
this.pageSize = pageSize;
|
}
|
}
|
