package model

import (
	"gitee.com/lzzandlyx/orders/db/mysql"
	"gitee.com/lzzandlyx/orders/internal/svc"
	"gorm.io/gorm"
)

type OrderItem struct {
	gorm.Model
	OrderId    int64  `json:"order_id"    gorm:"type:int(11);not null;comment:订单id"`
	OrderSn    string `json:"order_sn"    gorm:"type:char(36);comment:订单编号"`
	GoodsId    int64  `json:"goods_id"    gorm:"type:int(11);index;not null;comment:商品id"`
	Quantity   int64  `json:"quantity"    gorm:"type:int(11);comment:购买商品数量"`
	GoodsTitle string `json:"goods_title" gorm:"type:varchar(255);comment:商品名称"`
	GoodsPrice string `json:"goods_price" gorm:"type:decimal(10,2);comment:商品价格"`
	Img        string `json:"img"         gorm:"type:varchar(255);comment:商品图片"`
}

func GetOrderItem(svc *svc.ServiceContext, orderId int64) (items []OrderItem, err error) {
	err = mysql.WithMySQLClient(svc, func(db *gorm.DB) error {
		return db.Debug().Where("order_id = ?", orderId).Find(&items).Error
	})
	return
}

func GetOrderItems(svc *svc.ServiceContext, orderIds []uint) (items []OrderItem, err error) {
	err = mysql.WithMySQLClient(svc, func(db *gorm.DB) error {
		db = db.Debug()
		return db.Select("order_id,goods_id, quantity, goods_title, goods_price, img").
			Where("order_id in ?", orderIds).
			Find(&items).Error
	})
	return
}