| | |
| | | |
| | | MiniDictSearch struct { |
| | | MiniDict |
| | | Keyword string |
| | | Order string |
| | | PageNum int |
| | | PageSize int |
| | |
| | | return slf |
| | | } |
| | | |
| | | func (slf *MiniDictSearch) SetKeyword(keyword string) *MiniDictSearch { |
| | | slf.Keyword = keyword |
| | | return slf |
| | | } |
| | | |
| | | func (slf *MiniDictSearch) build() *gorm.DB { |
| | | var db = slf.Orm.Table(slf.TableName()) |
| | | |
| | |
| | | |
| | | if slf.Value != "" { |
| | | db = db.Where("value = ?", slf.Value) |
| | | } |
| | | |
| | | if slf.Keyword != "" { |
| | | db = db.Where("name like ?", fmt.Sprintf("%%%s%%", slf.Keyword)) |
| | | } |
| | | |
| | | db.Where("1 = 1") |
| | |
| | | return records, nil |
| | | } |
| | | |
| | | func (slf *MiniDictSearch) MaxAutoIncr() (int, error) { |
| | | type Result struct { |
| | | Max int |
| | | } |
| | | |
| | | var ( |
| | | result Result |
| | | db = slf.build() |
| | | ) |
| | | |
| | | err := db.Select("COUNT(id) as max").Scan(&result).Error |
| | | if err != nil { |
| | | return result.Max, fmt.Errorf("max err: %v", err) |
| | | } |
| | | return result.Max, nil |
| | | } |
| | | |
| | | // InitDefaultData 初始化数据 |
| | | func (slf *MiniDictSearch) InitDefaultData() error { |
| | | var ( |
| | |
| | | return nil |
| | | } |
| | | dict := make([]*MiniDict, 0) |
| | | dict = append(dict, &MiniDict{Type: constvar.TransferType, Name: "内部调拨", Value: "1"}) |
| | | dict = append(dict, &MiniDict{Type: constvar.TransferType, Name: "外部调拨", Value: "2"}) |
| | | dict = append(dict, &MiniDict{Type: constvar.StorageType, Name: "采购", Value: "1"}) |
| | | dict = append(dict, &MiniDict{Type: constvar.StorageType, Name: "采购", Value: "1", IsDefault: true}) |
| | | dict = append(dict, &MiniDict{Type: constvar.StorageType, Name: "其他", Value: "99"}) |
| | | dict = append(dict, &MiniDict{Type: constvar.StockoutType, Name: "展厅", Value: "1"}) |
| | | dict = append(dict, &MiniDict{Type: constvar.StockoutType, Name: "经销商", Value: "2"}) |
| | | dict = append(dict, &MiniDict{Type: constvar.StockoutType, Name: "退库", Value: "9"}) |
| | | dict = append(dict, &MiniDict{Type: constvar.StockoutType, Name: "退库", Value: "9", IsDefault: true}) |
| | | dict = append(dict, &MiniDict{Type: constvar.StockoutType, Name: "其他", Value: "99"}) |
| | | dict = append(dict, &MiniDict{Type: constvar.TransferType, Name: "内部调拨", Value: "1", IsDefault: true}) |
| | | dict = append(dict, &MiniDict{Type: constvar.TransferType, Name: "外部调拨", Value: "2"}) |
| | | dict = append(dict, &MiniDict{Type: constvar.TakeStockType, Name: "其他", Value: "99"}) |
| | | dict = append(dict, &MiniDict{Type: constvar.DisuseType, Name: "其他", Value: "99"}) |
| | | err := slf.CreateBatch(dict) |
| | | return err |
| | | } |