| | |
| | | return slf |
| | | } |
| | | |
| | | func (slf *LocationSearch) SetWarehouseId(warehouseId int) *LocationSearch { |
| | | slf.WarehouseId = warehouseId |
| | | return slf |
| | | } |
| | | |
| | | func (slf *LocationSearch) build() *gorm.DB { |
| | | var db = slf.Orm.Table(slf.TableName()) |
| | | |
| | |
| | | db = db.Where("company_id=?", slf.CompanyId) |
| | | } |
| | | if slf.JointName != "" { |
| | | //slf.JointName += "/" |
| | | db = db.Where("joint_name like ?", slf.JointName+"%") |
| | | } |
| | | if len(slf.JointNames) != 0 { |
| | |
| | | db = db.Preload("Warehouse") |
| | | } |
| | | |
| | | if slf.WarehouseId != 0 { |
| | | db = db.Where("warehouse_id = ?", slf.WarehouseId) |
| | | } |
| | | |
| | | return db |
| | | } |
| | | |