From 1cd1206c18ed14dd9ebf2baf477f46c847a271b0 Mon Sep 17 00:00:00 2001
From: zhangqian <zhangqian@123.com>
Date: 星期五, 15 三月 2024 16:39:19 +0800
Subject: [PATCH] merge
---
model/deliveryOrder.go | 90 +++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 90 insertions(+), 0 deletions(-)
diff --git a/model/deliveryOrder.go b/model/deliveryOrder.go
new file mode 100644
index 0000000..3b9db3a
--- /dev/null
+++ b/model/deliveryOrder.go
@@ -0,0 +1,90 @@
+package model
+
+import (
+ "aps_crm/pkg/mysqlx"
+ "github.com/shopspring/decimal"
+ "gorm.io/gorm"
+)
+
+type (
+ DeliveryOrder struct {
+ Id int `json:"id" gorm:"column:id;primary_key;AUTO_INCREMENT"`
+ MemberId int `json:"memberId" gorm:"column:member_id;type:int;comment:鏈嶅姟浜哄憳id"`
+ SalesDetailsId int `json:"salesDetailsId" gorm:"column:sales_details_id;type:int;comment:閿�鍞槑缁唅d"`
+ ProductID uint `json:"productID" gorm:"column:product_id"`
+ Name string `json:"name" gorm:"column:name;type:varchar(255);comment:浜у搧鍚嶇О"`
+ Number string `json:"number" gorm:"column:number;type:varchar(255);comment:浜у搧缂栧彿"` //浜у搧缂栧彿
+ Amount decimal.Decimal `json:"amount" gorm:"column:amount;type:decimal(12,2);comment:浜у搧鏁伴噺"` //璁㈠崟鏁伴噺
+ FinishAmount decimal.Decimal `json:"finishAmount" gorm:"-"` //璁㈠崟瀹屾垚鏁伴噺
+ AvailableAmount decimal.Decimal `json:"availableAmount" gorm:"-"` //鍙敤搴撳瓨
+ DeliveryAmount decimal.Decimal `json:"deliveryAmount" gorm:"-"` //鏈鍙戣揣鏁伴噺
+ LeftAmount decimal.Decimal `json:"leftAmount" gorm:"column:left_amount;type:decimal(12,2);comment:鍓╀綑鍙戣揣鏁伴噺"`
+ gorm.Model `json:"-"`
+ }
+
+ DeliveryOrderSearch struct {
+ DeliveryOrder
+ Orm *gorm.DB
+ }
+)
+
+func (DeliveryOrder) TableName() string {
+ return "delivery_order"
+}
+
+func NewDeliveryOrderSearch() *DeliveryOrderSearch {
+ return &DeliveryOrderSearch{
+ Orm: mysqlx.GetDB(),
+ }
+}
+
+func (css *DeliveryOrderSearch) build() *gorm.DB {
+ var db = css.Orm.Model(&DeliveryOrder{})
+ if css.Id != 0 {
+ db = db.Where("id = ?", css.Id)
+ }
+ if css.SalesDetailsId != 0 {
+ db = db.Where("sales_details_id = ?", css.SalesDetailsId)
+ }
+
+ return db
+}
+
+func (css *DeliveryOrderSearch) Create(record *DeliveryOrder) error {
+ var db = css.build()
+ return db.Create(record).Error
+}
+
+func (css *DeliveryOrderSearch) Update(record *DeliveryOrder) error {
+ var db = css.build()
+ return db.Updates(record).Error
+}
+
+func (css *DeliveryOrderSearch) Delete() error {
+ var db = css.build()
+ return db.Delete(&DeliveryOrder{}).Error
+}
+
+func (css *DeliveryOrderSearch) Find() (*DeliveryOrder, error) {
+ var db = css.build()
+ var record = &DeliveryOrder{}
+ err := db.First(record).Error
+ return record, err
+}
+
+func (css *DeliveryOrderSearch) FindAll() ([]*DeliveryOrder, error) {
+ var db = css.build()
+ var records = make([]*DeliveryOrder, 0)
+ err := db.Find(&records).Error
+ return records, err
+}
+
+func (css *DeliveryOrderSearch) SetId(id int) *DeliveryOrderSearch {
+ css.Id = id
+ return css
+}
+
+func (css *DeliveryOrderSearch) SetSalesDetailsID(id int) *DeliveryOrderSearch {
+ css.SalesDetailsId = id
+ return css
+}
--
Gitblit v1.8.0