duoduo/models/mysql/order.go

package mysql

import orm "duoduo/database"

type Order struct {
	CreateTime            string `gorm:"column:create_time" json:"createTime"`
	GoodsName             string `gorm:"column:goods_name" json:"goodsName"`
	GoodsThumbnailURL     string `gorm:"column:goods_thumbnail_url" json:"goodsThumbnailUrl"`
	JSONData              string `gorm:"column:json_data" json:"jsonData"`
	OrderGroupSuccessTime string `gorm:"column:order_group_success_time" json:"orderGroupSuccessTime"`
	OrderID               string `gorm:"column:order_id" json:"orderId"`
	OrderStatus           int    `gorm:"column:order_status" json:"orderStatus"`
	OrderStatusDesc       string `gorm:"column:order_status_desc" json:"orderStatusDesc"`
	PID                   string `gorm:"column:p_id" json:"pId"`
	PromotionAmount       int    `gorm:"column:promotion_amount" json:"promotionAmount"`
	UpdateTime            string `gorm:"column:update_time" json:"updateTime"`
}

// TableName sets the insert table name for this struct type
func (o *Order) TableName() string {
	return "order"
}

func (o *Order) Create() (Order, error) {
	var doc Order
	result := orm.Eloquent.Table(o.TableName()).Create(&o)
	if result.Error != nil {
		err := result.Error
		return doc, err
	}
	doc = *o
	return doc, nil
}

func (o *Order) GetNum() int {
	var count int
	tableCount := orm.Eloquent.Table(o.TableName()).Where("order_id = ? ", o.OrderID)
	tableCount.Count(&count)
	return count
}

// 更新
func (o *Order) Update(orderId string) (update Order, err error) {
	if err = orm.Eloquent.Table(o.TableName()).Where("order_id = ?", orderId).First(&update).Error; err != nil {
		return
	}

	//参数1:是要修改的数据
	//参数2:是修改的数据
	if err = orm.Eloquent.Table(o.TableName()).Model(&update).Updates(&o).Error; err != nil {
		return
	}
	return
}