pm/services/material/item/option.go

package item

import (
	"zhiyuan/models"
	"zhiyuan/pkg/app"
	"zhiyuan/pkg/db"
)

var MatItemOption models.MatItemOption

func GetOptionList(where map[string]interface{}, fields []string, page app.Page, retVal interface{}) ([]*models.MatItemOption, error) {
	if page.PageNum > 0 && page.PageSize > 0 {
		where["_limit"] = db.GetOffset(uint(page.PageNum), uint(page.PageSize))
	}
	return MatItemOption.GetMulti(where, fields, retVal)
}

func CountOption(where map[string]interface{}) (int64, error) {
	return db.Count(MatItemOption.TableName(), where)
}

func GetOneOption(where map[string]interface{}, fields []string, dest interface{}) (*models.MatItemOption, error) {
	return MatItemOption.GetOne(where, fields, dest)
}

func DelOptionsByItem(itemID int) (int64, error) {
	return db.Delete(MatItemOption.TableName(), map[string]interface{}{"item_id": itemID})
}

func BatchAdd(options []string, itemID int) (int64, error) {
	optionMap := make([]map[string]interface{}, 0)
	for _, v := range options {
		optionMap = append(optionMap, map[string]interface{}{
			"option_name": v,
			"item_id":     itemID,
		})
	}
	return db.Insert(MatItemOption.TableName(), optionMap)
}