gobackend-qingma/entity/order.go

package entity

import "gopkg.in/guregu/null.v3"

type Order struct {
	Id              string         `db:"id"`     //订单编号
	Name            string         `db:"name"`   //客户姓名
	Gender          int            `db:"gender"` //姓名
	Age             int            `db:"age"`    //年龄
	Birthday        string         `db:"birthday"`
	Address         string         `db:"address"`           //上门地址
	DetailAddress   string         `db:"detail_address"`    //详细地址
	VisitDate       string         `db:"visit_date"`        //上门日期
	VisitTimeRange  string         `db:"visit_time_range"`  //上门时间段
	Source          string         `db:"source"`            //订单来源
	Status          int            `db:"status"`            //订单状态(1待支付，2待接单-匹配客户经理以及护士，3待上门，4待上传化验结果，5已完成)
	WorkFee         int            `db:"work_fee,positive"` //上门费
	FreeFee         int            `db:"free_fee"`          //优惠费用
	RepeatItemFee   int            `db:"repeat_item_fee"`   //重复项减免费用
	Payment         int            `db:"payment,positive"`  //订单需支付金额
	OnlinePayment   int            `db:"online_payment,positive"`
	ActualPayment   int            `db:"actual_payment"` //实际支付金额
	VActualPayment  int            `db:"v_actual_payment"`
	PaymentTime     string         `db:"payment_time,omitempty"`      //支付时间
	PayType         int            `db:"pay_type,omitempty"`          //支付类型
	PayNo           string         `db:"pay_no,omitempty"`            //支付流水号
	CustomManagerId string         `db:"cm_id,omitempty" json:"CmId"` //客户经理id 20210331 用于保存json 字段，查看是否点击扣减活动
	NourseId        string         `db:"nurse_id,omitempty"`          //护士id
	IsOthers        int            `db:"is_others"`                   //是否为替他人下单
	IsMerged        int            `db:"is_merged"`                   //是否被合并
	BloodCodes      string         `db:"blood_codes,omitempty"`       //血检条码
	AssayTime       string         `db:"assay_time,omitempty"`        //上门时间
	CustomId        int            `db:"custom_id"`
	CustomMobile    string         `db:"custom_mobile"` //下单人电话
	Mobile          string         `db:"mobile"`        //被下单人电话
	MaterialId      int            `db:"m_id"`          //占用产能id
	Remark          string         `db:"remark,omitempty"`
	AdminRemark     string         `db:"admin_remark"`
	UpdatedAt       string         `db:"updated_at"`
	CreatedAt       string         `db:"created_at"`
	IsViewReport    string         `db:"is_view_report"`
	ShareCode       string         `db:"share_code"`
	IsAgent         uint           `db:"isagent"`
	Type            string         `db:"type"` //集采类型
	BloodTestId     string         `db:"null"`
	OpenId          string         `db:"null"`
	Relationship    string         `db:"null"`
	IsYunxue        int            `db:"null"`
	IsDfguomin      int            `db:"null"`
	ProductIds      []OrderProduct `db:"null"`
	ItemIds         []int          `db:"null"`
	Coupons         []int          `db:"null"`
	IsNeedPay       string         `db:"null"`
	LinkerId        int            `db:"linker_id"`
	CreatedBy       string         `db:"created_by"`
	PTId            int            `db:"null"`
	ToOpenID        string         `db:"null",json:"toopenid"`
	IdNum           string         `db:"id_num",json:"IdNum"`
	NurseId         string         `db:"null",json:"NurseId"`
	ServiceRemark   string         `db:"service_remark"`
	JdOrderId       string         `db:"jd_order_id",json:"JdOrderId"`    //20210225 微医 扩展字段，占用 京东订单号
	Zone            string         `db:"zone" json:"zone"`                //20210324 增加json存储省市区字段
	Coordinates     string         `db:"coordinates" json:"Coordinates"`  //20210922 添加订单坐标
	PreOrderId      string         `db:"pre_order_id" json:"PreOrderId"`  //20211112 主单id，订单变为服务单
	ShareSource     string         `db:"share_source" json:"ShareSource"` //20220428 增加保存json 字段
	IsZFB           bool           `db:"null"`
	AccountType     string         `db:"account_type" json:"AccountType"` //20230904 增加微信支付账户类型  主要分博德，云动脉等
}

type OrderDB struct {
	Id              string      `db:"id"`     //订单编号
	Name            string      `db:"name"`   //客户姓名
	Gender          int         `db:"gender"` //姓名
	Age             int         `db:"age"`    //年龄
	Birthday        string      `db:"birthday"`
	Address         string      `db:"address"`          //上门地址
	DetailAddress   string      `db:"detail_address"`   //详细地址
	VisitDate       null.String `db:"visit_date"`       //上门日期
	VisitTimeRange  null.String `db:"visit_time_range"` //上门时间段
	Source          string      `db:"source"`           //订单来源
	Status          int         `db:"status"`           //订单状态(1待支付，2待接单-匹配客户经理以及护士，3待上门，4待上传化验结果，5已完成)
	WorkFee         null.Int    `db:"work_fee"`         //上门费
	FreeFee         int         `db:"free_fee"`         //优惠费用
	RepeatItemFee   int         `db:"repeat_item_fee"`  //重复项减免费用
	Payment         int         `db:"payment"`          //订单需支付金额
	OnlinePayment   int         `db:"online_payment"`
	ActualPayment   null.Int    `db:"actual_payment"`   //实际支付金额
	VActualPayment  int         `db:"v_actual_payment"` //拆单时用
	PaymentTime     null.String `db:"payment_time"`     //支付时间
	PayType         null.Int    `db:"pay_type"`         //支付类型
	PayNo           null.String `db:"pay_no"`
	CustomManagerId null.String `db:"cm_id"`       //客户经理id
	NourseId        null.String `db:"nurse_id"`    //护士id
	IsOthers        int         `db:"is_others"`   //是否为替他人下单
	IsMerged        int         `db:"is_merged"`   //是否被合并
	BloodCodes      null.String `db:"blood_codes"` //血检条码
	AssayTime       null.String `db:"assay_time"`  //上门时间
	CustomId        null.Int    `db:"custom_id"`
	CustomMobile    string      `db:"custom_mobile"` //下单人电话
	Mobile          string      `db:"mobile"`        //被下单人电话
	MaterialId      int         `db:"m_id"`          //占用产能id
	ReportPicture   string      `db:"report_picture"`
	IsViewReport    string      `db:"is_view_report"`
	Remark          null.String `db:"remark"`
	UpdatedAt       string      `db:"updated_at"`
	CreatedAt       string      `db:"created_at,omitempty"`
	IsNotice        string      `db:"is_notice"`
	ThirdPayNo      null.String `db:"third_pay_no" json:"-"`
	DelayDeadtime   uint        `db:"delay_deadtime" json:"delay_deadtime"` //订单失效时间延迟时长
	Relationship    null.String `db:"relationship"`
	RelId           null.Int    `db:"rel_id"`
	IsYunxue        null.Int    `db:"is_yunxue"`
	IsDfguomin      null.Int    `db:"is_dfguomin"`
	Type            string      `db:"type" json:"type"` //订单类型
	BloodTestId     null.String `db:"bloodtest_id" json:"bloodtest_id"`
	NeedEmptiness   null.Int    `db:"need_emptiness"`
	ReportPeriod    null.String `db:"report_period"`
	PressurePipe    null.String `db:"pressure_pipe"`
	BloodAddress    null.String `db:"blood_address"`
	Notice          null.String `db:"notice"`
	IsFetchData     int         `db:"is_fetch_data"`
	NurseRemark     null.String `db:"nurse_remark"`
	ServiceRemark   null.String `db:"service_remark"`
	OriginalReport  null.String `db:"original_report"`
	JdOrderId       null.String `db:"jd_order_id"`
	Zone            null.String `db:"zone" json:"zone"`               //20210324 增加json存储省市区字段
	Coordinates     null.String `db:"coordinates" json:"coordinates"` //20210324 增加json存储省市区字段
	IdNum           null.String `db:"id_num",json:"IdNum"`            //20220208 增加身份证id
	PreOrderId      string      `db:"pre_order_id" json:"PreOrderId"` //20211112 主单id，订单变为服务单
	ShareSource     null.String `db:"share_source" `                  //20220428 增加保存json 字段
}

// order/add 用 20200814 qz add
type AgentEntity struct {
	Id           string      `db:"id"`
	OpenId       string      `db:"openid"`
	CreateTime   string      `db:"createtime"`
	UpdateTime   string      `db:"updatetime"`
	UserParentId null.String `db:"userparentid"`
	AgentType    null.Int    `db:"type"`
	RedPacket    null.Int    `db:"redpacket"`
}

// qz 检测项录入 传参 20200826
type DetectInfoParam struct {
	OrderId      string `json:"order_no"`
	DetectItemID int    `json:"detect_item_id"`
	Final        string `json:"final"`
	Unit         string `json:"unit"`
	RefValue     string `json:"refValue"`
	Status       int    `json:"final_status"`
	CreatedAt    string `json:"createdAt"`
	IsSelf       int    `json:"is_self"`
}

// qz 检测项录入 DB数据 20200826
type DetectInfoDB struct {
	OrderId      string      `db:"order_no"`
	DetectItemID int         `db:"detect_item_id"`
	Final        string      `db:"final"`
	Unit         string      `db:"unit"`
	RefValue     null.String `db:"refValue"`
	Age          null.String `db:"age"`
	Gender       null.String `db:"gender"`
	Checker      null.String `db:"checker"`
	Approver     null.String `db:"approver"`
	CheckTime    null.String `db:"checkTime"`
	CreatedAt    string      `db:"createdAt"`
	IsSelf       int         `db:"is_self"`
	FinalStatus  int         `db:"final_status"`
	FinalTip     null.String `db:"final_tip"`
	Extra        null.String `db:"extra"`
}