lc_finance/server/dao/purchase.go

package dao

import (
	"github.com/shopspring/decimal"
	"server/global"
)

type Purchase struct {
	global.GVA_MODEL
	ProjectCode string          `json:"projectCode" form:"projectCode" gorm:"comment:项目编码"`
	Name        string          `json:"name" form:"name" gorm:"comment:名称"`
	Quantity    int             `json:"quantity" form:"quantity" gorm:"comment:数量"`
	Company     string          `json:"company" form:"company" gorm:"comment:规格(单位)"`
	Origin      string          `json:"origin" form:"origin" gorm:"comment:产地"`
	Price       decimal.Decimal `json:"price" form:"price" gorm:"type:decimal(10,2);not null;"`
	Amount      decimal.Decimal `json:"amount" form:"amount" gorm:"type:decimal(10,2);not null;"`
	Method      string          `json:"method" form:"method" gorm:"comment:付款方式"`
}

func (Purchase) TableName() string {
	return "purchase"
}

// TODO:采购查询

// QueryPurchase 查询采购
func QueryPurchase(code string) (purchase []Purchase, err error) {
	err = global.GVA_DB.Model(&Purchase{}).Where("project_code = ?", code).Find(&purchase).Error
	return purchase, err
}

func QueryPurchaseList(limit, offset int) (purchase []Purchase, total int64, err error) {
	// 创建db
	db := global.GVA_DB.Model(&Purchase{})
	// 如果有条件搜索 下方会自动创建搜索语句

	err = db.Count(&total).Error
	if err != nil {
		return
	}
	err = db.Order("id desc").Limit(limit).Offset(offset).Find(&purchase).Error
	return purchase, total, err
}

// TODO:采购新增

// CreatePurchase 新建采购
func (p Purchase) CreatePurchase() error {
	return global.GVA_DB.Create(&p).Error
}

// TODO:采购修改

// UpdatePurchase 修改采购
func (p Purchase) UpdatePurchase() error {
	return global.GVA_DB.Model(&p).Where("id = ?", p.ID).Updates(&p).Error
}

// TODO:采购删除

// DeletePurchase 删除采购
func (p Purchase) DeletePurchase() error {
	return global.GVA_DB.Unscoped().Delete(&p).Error
}