eta_mini_crm_ht/models/product_order.go

package models

import (
	"github.com/beego/beego/v2/client/orm"
	"time"
)

type OrderStatus string
type RefundStatus string
type PaymentWay string

const (
	//订单状态
	OrderStatusPending    OrderStatus = "pending"
	OrderStatusProcessing OrderStatus = "processing"
	OrderStatusPaid       OrderStatus = "paid"
	OrderStatusClosed     OrderStatus = "closed"
	OrderStatusRefund     OrderStatus = "refund"
	//退款状态
	RefundStatusSuccess    RefundStatus = "success"
	RefundStatusPending    RefundStatus = "pending"
	RefundStatusFailed     RefundStatus = "failed"
	RefundStatusProcessing RefundStatus = "processing"
	RefundStatusCanceled   RefundStatus = "canceled"
	WechatPayWay           PaymentWay   = "wechat"
	AliPayWay              PaymentWay   = "alipay"

	detailColumn = "id,order_id,user_id,template_user_id,product_id,status,created_time,updated_time,total_amount"
)

type ProductOrderView struct {
	OrderID          string
	RealName         string
	Mobile           string
	ProductType      string
	ProductName      string
	TotalAmount      string
	TradeNO          string
	RefundAmount     string
	PaymentWay       string
	PaymentTime      string
	Status           string
	RefundStatus     string
	RefundFinishTime string
	Remark           string
	CreatedTime      string
}
type ProductOrder struct {
	ID               int                 `gorm:"column:id;primaryKey;autoIncrement" json:"id"`
	OrderID          string              `gorm:"column:order_id;size:255;comment:'订单编号'" json:"order_id"`
	UserID           int                 `gorm:"column:user_id;default:null;comment:'用户id'" json:"user_id"`
	TemplateUserID   int                 `gorm:"column:template_user_id;default:null;comment:'临时用户id'" json:"template_user_id"`
	RealName         string              `gorm:"column:real_name;default:null;comment:'临时用户id'" json:"real_name"`
	AreaCode         string              `gorm:"column:area_code;default:null;comment:'临时用户id'" json:"area_code"`
	Mobile           string              `gorm:"column:mobile;default:null;comment:'临时用户id'" json:"mobile"`
	ProductID        int                 `gorm:"column:product_id;default:null;comment:'产品id'" json:"product_id"`
	ProductType      MerchantProductType `gorm:"column:product_type;default:null;comment:'产品类型'" json:"product_type"`
	ProductName      string              `gorm:"column:product_name;default:null;comment:'商品名称'" json:"product_name"`
	TotalAmount      string              `gorm:"column:total_amount;size:255;default:null;comment:'金额'" json:"total_amount"`
	TradeID          int                 `gorm:"column:trade_id;default:null;comment:'支付订单'" json:"trade_id"`
	TradeNO          string              `gorm:"column:trade_no;default:null;comment:'支付订单'" json:"trade_no"`
	RefundAmount     string              `gorm:"column:refund_amount;size:255;default:null;comment:'退款金额'" json:"refund_amount"`
	PaymentWay       PaymentWay          `gorm:"column:payment_way;enum('wechat','alipay');default:null;comment:'支付渠道'"`
	PaymentTime      time.Time           `gorm:"column:payment_time;default:null;comment:'支付时间'" json:"payment_time"`
	ExpiredTime      time.Time           `gorm:"column:expired_time;default:null;comment:'超时时间'" json:"expired_time"`
	Status           OrderStatus         `gorm:"column:status;type:enum('pending','processing','paid','closed','refund');default:'pending';comment:'订单状态'" json:"status"`
	RefundStatus     RefundStatus        `gorm:"column:refund_status;type:enum('pending','processing','failed','success');default:null;comment:'退款状态'" json:"refund_status"`
	RefundFinishTime time.Time           `gorm:"column:refund_finish_time;default:null;comment:'退款完成时间'" json:"refund_finish_time"`
	Remark           string              `gorm:"column:remark;size:255;default:null;comment:'备注'" json:"remark"`
	IsDeleted        int                 `gorm:"column:is_deleted;size:1;default:0;comment:'是否删除'" json:"is_deleted"`
	CreatedTime      time.Time           `gorm:"column:created_time;default:null;comment:'创建时间'" json:"created_time"`
	UpdatedTime      time.Time           `gorm:"column:updated_time;default:null;comment:'更新时间'" json:"updated_time"`
}

func (m *ProductOrder) TableName() string {
	return "product_orders"
}

func GetProductOrderByCondition(condition string, sortCondition string, startSize int, pageSize int) (list []*ProductOrder, err error) {
	o := orm.NewOrm()
	sql := `select * from product_orders where is_deleted=0`
	if condition != "" {
		sql += condition
	}
	if sortCondition != "" {
		sql += sortCondition
	}
	sql += ` LIMIT ?,?`
	_, err = o.Raw(sql, startSize, pageSize).QueryRows(&list)
	return
}

func GetProductOrderCountByCondition(condition string) (total int, err error) {
	o := orm.NewOrm()
	err = o.Raw("select count(*) from product_orders where is_deleted=0" + condition).QueryRow(&total)
	return
}

func GetProductOrderByID(orderNo string) (order *ProductOrder, err error) {
	o := orm.NewOrm()
	err = o.Raw("select * from product_orders where is_deleted=0 and order_id =?", orderNo).QueryRow(&order)
	return
}