| | |
| | | records = make([]*OperationTypeByStatus, 0) |
| | | db = slf.Orm |
| | | ) |
| | | db = db.Table("wms_job_type").Select("wms_job_type.id,wms_operation.status,count(wms_operation.id) as count").InnerJoins("inner join wms_operation on wms_operation.operation_type_id=wms_job_type.id").Group("wms_job_type.id,wms_operation.status") |
| | | db = db.Table("wms_job_type").Select("wms_job_type.id,wms_operation.status,count(wms_operation.id) as count").InnerJoins("inner join wms_operation on wms_operation.operation_type_id=wms_job_type.id").Where("wms_operation.deleted_at is null"). |
| | | Group("wms_job_type.id,wms_operation.status") |
| | | if len(idList) > 0 { |
| | | db = db.Where("wms_job_type.id IN ?", idList) |
| | | } |