| | |
|---|
| | | //wms_operation_details.amount as adjust_amount,wms_operation.id as operation_id,wms_operation.status |
|---|
| | | search.Orm = search.Orm. |
|---|
| | | Table("wms_location_product_amount"). |
|---|
| | | Select(`wms_location_product_amount.id as location_product_amount_id,wms_location.id as location_id,wms_location.name as location_name,material.id as product_id,material.name as product_name,wms_location_product_amount.amount,material.unit,wms_location_product_amount.create_date`). |
|---|
| | | Select(`wms_location_product_amount.id as location_product_amount_id,wms_location.id as location_id,wms_location.name as location_name, |
|---|
| | | material.id as product_id,material.name as product_name,wms_location_product_amount.amount,material.unit, |
|---|
| | | wms_location_product_amount.create_date,material.weight`). |
|---|
| | | InnerJoins("inner join material on material.id=wms_location_product_amount.product_id"). |
|---|
| | | InnerJoins("inner join wms_location on wms_location.id=wms_location_product_amount.location_id") |
|---|
| | | |
|---|
| | |
|---|
| | | Comment: "库存盘点", |
|---|
| | | BaseOperationType: constvar.BaseOperationTypeAdjust, |
|---|
| | | Details: []*models.OperationDetails{detail}, |
|---|
| | | LocationID: location.Id, |
|---|
| | | } |
|---|
| | | |
|---|
| | | if err := models.WithTransaction(func(tx *gorm.DB) error { |
|---|
