| | |
|---|
| | | var pa []request.ProductAmount |
|---|
| | | search := models.NewOperationDetailsSearch() |
|---|
| | | search.Orm = search.Orm.Model(&models.OperationDetails{}). |
|---|
| | | Select("wms_operation_details.product_id, wms_operation_details.amount, wms_operation.to_location_id as to_location_id, " + |
|---|
| | | "wms_operation.from_location_id as from_location_id, wms_operation.base_operation_type"). |
|---|
| | | Select("wms_operation_details.product_id, wms_operation_details.amount, wms_operation_details.to_location_id as to_location_id, " + |
|---|
| | | "wms_operation_details.from_location_id as from_location_id, wms_operation.base_operation_type"). |
|---|
| | | Joins("left join wms_operation on wms_operation_details.operation_id = wms_operation.id") |
|---|
| | | if len(productIds) > 0 { |
|---|
| | | search.Orm.Where("wms_operation_details.product_id in (?)", productIds) |
|---|
| | | } |
|---|
| | | if len(toLocationIds) > 0 { |
|---|
| | | search.Orm.Where("wms_operation.to_location_id in (?)", toLocationIds) |
|---|
| | | search.Orm.Where("wms_operation_details.to_location_id in (?)", toLocationIds) |
|---|
| | | } |
|---|
| | | if len(fromLocationIds) > 0 { |
|---|
| | | search.Orm.Where("wms_operation.from_location_id in (?)", fromLocationIds) |
|---|
| | | search.Orm.Where("wms_operation_details.from_location_id in (?)", fromLocationIds) |
|---|
| | | } |
|---|
| | | if len(status) > 0 { |
|---|
| | | search.Orm.Where("wms_operation.status in (?)", status) |
|---|
| | |
|---|
| | | var details models.OperationDetails |
|---|
| | | details.ProductId = params.ProductId |
|---|
| | | details.Amount = params.OrderNumber |
|---|
| | | details.FromLocationID = 1 |
|---|
| | | details.ToLocationID = params.LocationId |
|---|
| | | operation.Details = append(operation.Details, &details) |
|---|
| | | operation.BaseOperationType = constvar.BaseOperationTypeIncoming |
|---|
| | | operation.Status = constvar.OperationStatus_Ready |
|---|
| | | operation.OperationTypeId = operationType.Id |
|---|
| | | operation.OperationTypeName = operationType.Name |
|---|
| | | operation.OperationDate = timex.TimeToString2(time.Now()) |
|---|
| | | //todo 供应商位置 |
|---|
| | | operation.FromLocationID = 1 |
|---|
| | | operation.LocationID = params.LocationId |
|---|
| | | operation.Number = strconv.FormatInt(time.Now().Unix(), 10) |
|---|
| | | operation.ToLocationID = params.LocationId |
|---|
| | | |
|---|
| | | operation.SourceNumber = SourceNumber |
|---|
| | | |
|---|
| | | err = models.WithTransaction(func(db *gorm.DB) error { |
|---|
