| | |
| | | ) |
| | | |
| | | type ( |
| | | // MonthStats 移动历史 |
| | | // MonthStats 月度统计 |
| | | MonthStats struct { |
| | | WmsModel |
| | | Id int `json:"id" gorm:"column:id;primary_key;AUTO_INCREMENT"` |
| | |
| | | } |
| | | |
| | | if slf.Keyword != "" { |
| | | db = db.Where("product_name like ?", fmt.Sprintf("%%%v%%", slf.Keyword)) |
| | | kw := fmt.Sprintf("%%%v%%", slf.Keyword) |
| | | db = db.Where("product_id like ? or product_name like ?", kw, kw) |
| | | } |
| | | |
| | | if slf.Date != "" { |
| | |
| | | } |
| | | return m |
| | | } |
| | | |
| | | func (slf *MonthStatsSearch) Count() (int64, error) { |
| | | var ( |
| | | total int64 |
| | | db = slf.build() |
| | | ) |
| | | err := db.Count(&total).Error |
| | | return total, err |
| | | } |