| | |
| | | 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; |
| | | import java.util.List; |
| | | |
| | | /** |
| | | *收入确认表查询 |
| | |
| | | */ |
| | | @Data |
| | | public class RevenueQuery{ |
| | | |
| | | /**页数*/ |
| | | private Integer pageNum; |
| | | /**条数*/ |
| | | private Integer pageSize; |
| | | /**其他查询*/ |
| | | private String KeyWord; |
| | | /**用户CIQ*/ |
| | |
| | | private Date startCreateTime; |
| | | /**创建日期*/ |
| | | private Date endCreateTime; |
| | | /**是否过滤测试账号*/ |
| | | private Integer isFilterTestAccount; |
| | | /**是否过滤对冲数据*/ |
| | | private Integer isHedging; |
| | | /**业绩类型*/ |
| | | private List<Integer> sourceTypeList; |
| | | |
| | | /**请求操作人*/ |
| | | 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) |
| | | /**分类父类包括自己JSON*/ |
| | | private String classifyJson = "[]"; |
| | | |
| | | @Index |
| | | @Column(comment = "项目id/商品id(公用标识)", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**项目id*/ |
| | | 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) |
| | | /**收费订单id*/ |
| | | 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) |
| | | /**用户id*/ |
| | | 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) |
| | | /**登记人Id*/ |
| | | private String registrantId; |
| | | @Column(comment = "登记人名称", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**登记人名称*/ |
| | | private String registrantName; |
| | | |
| | | @Index |
| | | @Column(comment = "执行医生Id(Employee id)", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**执行医生Id*/ |
| | | private String deductionDoctorId; |
| | | @Column(comment = "执行医生名称", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**执行医生名称*/ |
| | | private String deductionDoctorName; |
| | | |
| | | @Index |
| | | @Column(comment = "助理医生Id(Employee id)", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**助理医生Id*/ |
| | | private String assistantDoctorId; |
| | | @Column(comment = "助理医生名称", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**助理医生名称*/ |
| | | private String assistantDoctorName; |
| | | |
| | | @Index |
| | | @Column(comment = "美容师Id(Employee id)", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**美容师Id*/ |
| | | private String beauticianId; |
| | | @Column(comment = "美容师名称", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**美容师名称*/ |
| | | private String beauticianName; |
| | | |
| | | @Index |
| | | @Column(comment = "订单id", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**订单id*/ |
| | | private String orderId; |
| | | @Column(comment = "订单编号", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**订单编号*/ |
| | | private String orderNo; |
| | | |
| | | @Index |
| | | @Column(comment = "订单条码id", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**订单条码id*/ |
| | | 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) |
| | | /**开单人Id*/ |
| | | 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) |
| | | /**开发人Id*/ |
| | | 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) |
| | | /**用户所属咨询师id(Employee id) 用户划扣时的所属咨询师*/ |
| | | 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) |
| | | /**开单咨询师id*/ |
| | | 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) |
| | | /**收银咨询师id*/ |
| | | 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) |
| | | /**接诊咨询师id*/ |
| | | 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) |
| | | /**执行咨询师id*/ |
| | | 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) |
| | | /**渠道联系人Id*/ |
| | | 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) |
| | | /**渠道合作人Id*/ |
| | | 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) |
| | | /**诊所内部联络人Id*/ |
| | | private String internalContactId; |
| | | @Column(comment = "诊所内部联络人名称", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**诊所内部联络人名称*/ |
| | | private String internalContactName; |
| | | |
| | | @Column(comment = "电网咨询师id(Employee id)", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**电网咨询师id*/ |
| | | private String tmkServiceId; |
| | | @Column(comment = "电网咨询师名称", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**电网咨询师名称*/ |
| | | private String tmkServiceName; |
| | | |
| | | @Column(comment = "客服id(Employee id)", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**客服id*/ |
| | | private String chatCorpUserId; |
| | | @Column(comment = "客服名称", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**客服名称*/ |
| | | private String chatCorpUserName; |
| | | |
| | | @Column(comment = "护士id(Employee id)", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**护士id*/ |
| | | private String nurseCorpUserId; |
| | | @Column(comment = "护士名称", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**护士名称*/ |
| | | private String nurseCorpUserName; |
| | | |
| | | @Column(comment = "洗手护士id(Employee id)", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**洗手护士id*/ |
| | | private String handWashNurseId; |
| | | @Column(comment = "洗手护士名称", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**洗手护士名称*/ |
| | | private String handWashNurseName; |
| | | |
| | | @Column(comment = "巡回护士id(Employee id)", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**巡回护士id*/ |
| | | private String circuitingNurseId; |
| | | @Column(comment = "巡回护士名称", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**巡回护士名称*/ |
| | | private String circuitingNurseName; |
| | | |
| | | @Column(comment = "配台护士id(Employee id)", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**配台护士id*/ |
| | | private String tableNurseId; |
| | | @Column(comment = "配台护士名称", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**配台护士名称*/ |
| | | private String tableNurseName; |
| | | |
| | | @Column(comment = "麻醉师id(Employee id)", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**麻醉师id*/ |
| | | 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) |
| | | /**TMK登记人id*/ |
| | | private String tmkRegistrantId; |
| | | @Column(comment = "TMK登记人名称", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**TMK登记人名称*/ |
| | | private String tmkRegistrantName; |
| | | |
| | | @Column(comment = "收费员id(Employee id)", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**收费员id*/ |
| | | private String chargeId; |
| | | @Column(comment = "收费员名称", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**收费员名称*/ |
| | | private String chargeName; |
| | | |
| | | @Column(comment = "服务门店id", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**服务门店id*/ |
| | | private String serviceShopId; |
| | | @Column(comment = "服务门店名称", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**服务门店名称*/ |
| | | private String serviceShopName; |
| | | |
| | | @Column(comment = "用户所属门店id", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**用户所属门店id*/ |
| | | private String belongShopId; |
| | | @Column(comment = "用户所属门店名称", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**用户所属门店名称*/ |
| | | private String belongShopName; |
| | | |
| | | @Column(comment = "下单门店id", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**下单门店id*/ |
| | | private String orderShopId; |
| | | @Column(comment = "下单门店名称", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**下单门店名称*/ |
| | | private String orderShopName; |
| | | |
| | | @Column(comment = "收银门店id", length = 64, type = MySqlTypeConstant.VARCHAR) |
| | | /**收银门店id*/ |
| | | 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) |
| | | /**订单渠道的json*/ |
| | | 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) |
| | | /**订单渠道合作人Id*/ |
| | | 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) |
| | | /**会员主诊医生Id*/ |
| | | 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 String exportVersion = EXPORT_VERSION_V1; |
| | | |
| | | /**页数*/ |
| | | private Integer pageNum; |
| | | /**条数*/ |
| | | private Integer pageSize; |
| | | /**导出版本-v1*/ |
| | | public static final String EXPORT_VERSION_V1 = "v1"; |
| | | /**导出版本-v2*/ |
| | | public static final String EXPORT_VERSION_V2 = "v2"; |
| | | |
| | | public Integer getPageNum() { |
| | | if(pageNum == null){ |
| | |
| | | public void setPageSize(Integer pageSize) { |
| | | this.pageSize = pageSize; |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | } |