From 65f900c88f0f90ee3b29e9b985723b8f94aaeb0b Mon Sep 17 00:00:00 2001 From: jiangshuai <291802688@qq.com> Date: 星期三, 27 九月 2023 14:14:35 +0800 Subject: [PATCH] 1.修改上架规则列表bug --- models/location.go | 43 ++++++++++++++++++++++++------------------- 1 files changed, 24 insertions(+), 19 deletions(-) diff --git a/models/location.go b/models/location.go index a11b1a9..db96855 100644 --- a/models/location.go +++ b/models/location.go @@ -11,16 +11,21 @@ // Location 浣嶇疆 Location struct { WmsModel - Id int `json:"id" gorm:"column:id;primary_key;AUTO_INCREMENT"` - Name string `json:"name" gorm:"index;type:varchar(255);not null;comment:浣嶇疆鍚嶇О"` //浣嶇疆鍚嶇О - ParentId string `json:"parentId" gorm:"type:varchar(255)"` //涓婄骇id - CompanyId int `json:"companyId" gorm:"type:int"` //鍏徃id - Company Company `json:"company" gorm:"foreignKey:CompanyId"` //鍏徃 - Type constvar.LocationType `json:"type" gorm:"type:int(11);comment:浣嶇疆绫诲瀷"` //浣嶇疆绫诲瀷 - CountFrequency int `json:"countFrequency" gorm:"type:tinyint;comment:鐩樼偣棰戠巼锛堝ぉ锛�"` //鐩樼偣棰戠巼锛堝ぉ锛� - IsScrapLocation bool `json:"isScrapLocation" gorm:"type:tinyint;comment:鏄惁鎶ュ簾浣嶇疆"` //鏄惁鎶ュ簾浣嶇疆 - IsReturnLocation bool `json:"isReturnLocation" gorm:"type:tinyint;comment:鏄惁閫�璐т綅缃�"` //鏄惁閫�璐т綅缃� - ReplenishLocation bool `json:"replenishLocation" gorm:"type:tinyint;comment:鏄惁琛ュ厖浣嶇疆"` //鏄惁琛ュ厖浣嶇疆 + Id int `json:"id" gorm:"column:id;primary_key;AUTO_INCREMENT"` + Name string `json:"name" gorm:"index;type:varchar(255);not null;comment:浣嶇疆鍚嶇О"` //浣嶇疆鍚嶇О + ParentId int `json:"parentId" gorm:"type:int;comment:涓婄骇id"` //涓婄骇id + CompanyId int `json:"companyId" gorm:"type:int"` //鍏徃id + //Company Company `json:"company" gorm:"foreignKey:CompanyId"` //鍏徃 + Type constvar.LocationType `json:"type" gorm:"type:int(11);comment:浣嶇疆绫诲瀷"` //浣嶇疆绫诲瀷 + CountFrequency int `json:"countFrequency" gorm:"type:tinyint;comment:鐩樼偣棰戠巼锛堝ぉ锛�"` //鐩樼偣棰戠巼锛堝ぉ锛� + IsScrapLocation bool `json:"isScrapLocation" gorm:"type:tinyint;comment:鏄惁鎶ュ簾浣嶇疆"` //鏄惁鎶ュ簾浣嶇疆 + IsReturnLocation bool `json:"isReturnLocation" gorm:"type:tinyint;comment:鏄惁閫�璐т綅缃�"` //鏄惁閫�璐т綅缃� + ReplenishLocation bool `json:"replenishLocation" gorm:"type:tinyint;comment:鏄惁琛ュ厖浣嶇疆"` //鏄惁琛ュ厖浣嶇疆 + ForceRemovalStrategy constvar.ForceRemovalStrategy `json:"forceRemovalStrategy" gorm:"type:tinyint;comment:涓嬫灦绛栫暐"` //涓嬫灦绛栫暐 + Notes string `json:"notes" gorm:"type:varchar(255);comment:澶栭儴澶囨敞"` //澶栭儴澶囨敞 + RecentlyCount string `json:"recentlyCount" gorm:"type:varchar(255);comment:鏈�杩戠洏鐐�"` //鏈�杩戠洏鐐� + NextCount string `json:"nextCount" gorm:"type:varchar(255);comment:涓嬫鐩樼偣"` //涓嬫鐩樼偣 + JointName string `json:"jointName" gorm:"type:varchar(255);comment:鎷兼帴鍚嶇О"` //鎷兼帴鍚嶇О } LocationSearch struct { @@ -31,7 +36,7 @@ Keyword string Orm *gorm.DB Preload bool - Parents []string + Codes []string } ) @@ -58,12 +63,12 @@ return slf } -func (slf *LocationSearch) SetID(id int) *LocationSearch { - slf.Id = id +func (slf *LocationSearch) SetID(ID int) *LocationSearch { + slf.Id = ID return slf } -func (slf *LocationSearch) SetParents(ids []string) *LocationSearch { - slf.Parents = ids +func (slf *LocationSearch) SetCodes(ids []string) *LocationSearch { + slf.Codes = ids return slf } @@ -87,7 +92,7 @@ return slf } -func (slf *LocationSearch) SetParentId(parentId string) *LocationSearch { +func (slf *LocationSearch) SetParentId(parentId int) *LocationSearch { slf.ParentId = parentId return slf } @@ -120,14 +125,14 @@ db = db.Where("type=?", slf.Type) } - if slf.ParentId != "" { + if slf.ParentId > 0 { db = db.Where("parent_id=?", slf.ParentId) } if slf.CompanyId != 0 { db = db.Where("company_id=?", slf.CompanyId) } - if len(slf.Parents) != 0 { - db = db.Where("parent_id in (?)", slf.Parents) + if len(slf.Codes) != 0 { + db = db.Where("warehouse_code in (?)", slf.Codes) } return db -- Gitblit v1.8.0