1.改名

jiangshuai

2023-09-28 a21d2184eae304ae80f32353c8a49b64a7618d22

 controllers/location_product_amount.go

@@ -42,6 +42,7 @@
   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,
@@ -50,14 +51,13 @@
               material.unit,
               wms_location_product_amount.create_date,
               wms_operation_details.amount as adjust_amount,
               wms_operation.id as operation_id`).
               wms_operation.id as operation_id,
               wms_operation.status`).
      InnerJoins("inner join wms_location_product on wms_location_product.id=wms_location_product_amount.location_product_id").
      InnerJoins("inner join material on material.id=wms_location_product.product_id").
      InnerJoins("inner join wms_location on wms_location.id=wms_location_product.location_id").
      InnerJoins("inner join wms_operation_details on wms_operation_details.product_id=wms_location_product.product_id").
      InnerJoins("inner join material on material.id=wms_operation_details.product_id").
      InnerJoins("inner join wms_operation on wms_operation.id=wms_operation_details.operation_id").
      Where("wms_operation.base_operation_type=?", constvar.BaseOperationTypeAdjust)

      Joins("left join wms_operation_details on wms_operation_details.product_id=wms_location_product.product_id").
      Joins("left join wms_operation on wms_operation.id=wms_operation_details.operation_id and wms_operation.base_operation_type=? and wms_operation.status=?", constvar.BaseOperationTypeAdjust, constvar.OperationStatus_Ready)
   var (
      records = make([]*models.LocationProductAmountWithOperation, 0)
      total   int64
@@ -76,7 +76,9 @@
      return
   }
   for k, v := range records {
      records[k].DifferenceAmount = v.Amount.Sub(v.AdjustAmount)
      if v.OperationId != 0 {
         records[k].DifferenceAmount = v.Amount.Add(v.AdjustAmount)
      }
   }
   util.ResponseFormatListWithPage(c, code.Success, records, int(total), params.Page, params.PageSize)
}
@@ -199,7 +201,7 @@
   util.ResponseFormat(c, code.Success, ruleList)
}

// Add
// Update
// @Tags      库存盘点
// @Summary   修改库存盘点信息
// @Produce   application/json
@@ -230,3 +232,64 @@

   util.ResponseFormat(c, code.Success, "修改成功")
}

// finish
//
//   @Tags      库存盘点
//   @Summary   应用、验证
//   @Produce   application/json
//   @Param      object  body  request.FinishLocationProductAmount true  "入参"
//   @Success   200   {object}   util.Response   "成功"
//   @Router      /api-wms/v1/locationProductAmount/finish [post]
func (slf LocationProductAmountController) Finish(c *gin.Context) {
   var reqParams request.FinishLocationProductAmount
   if err := c.BindJSON(&reqParams); err != nil {
      util.ResponseFormat(c, code.RequestParamError, "参数解析失败，数据类型错误")
      return
   }
   if reqParams.LocationProductAmountId == 0 {
      util.ResponseFormat(c, code.RequestParamError, "locationProductAmountId为0")
      return
   }
   if reqParams.OperationId == 0 {
      util.ResponseFormat(c, code.RequestParamError, "operationId为0")
      return
   }
   operationSearch := models.NewOperationSearch().SetPreload(true)
   operationSearch.SetOrm(operationSearch.Orm.InnerJoins("inner join wms_operation_details on wms_operation_details.operation_id=wms_operation.id").Where("wms_operation_details.product_id=? and wms_operation.id=?", reqParams.ProductId, reqParams.OperationId))
   operation, err := operationSearch.First()
   if err != nil {
      util.ResponseFormat(c, code.RequestParamError, "未找到相关信息:"+err.Error())
      return
   }
   if operation.Status != constvar.OperationStatus_Ready {
      util.ResponseFormat(c, code.RequestError, "该验证无法完成")
      return
   }
   material, err := models.NewMaterialSearch().SetID(reqParams.ProductId).First()
   if err != nil {
      util.ResponseFormat(c, code.RequestError, err.Error())
      return
   }
   locProdtAmount, err := models.NewLocationProductAmountSearch().SetID(reqParams.LocationProductAmountId).First()
   if err != nil {
      util.ResponseFormat(c, code.RequestError, err.Error())
      return
   }
   if err := models.WithTransaction(func(tx *gorm.DB) error {
      if err := models.NewOperationSearch().SetOrm(tx).SetID(reqParams.OperationId).Update(&models.Operation{Status: constvar.OperationStatus_Finish}); err != nil {
         return err
      }
      if err := models.NewMaterialSearch().SetOrm(tx).SetID(reqParams.ProductId).Update(&models.Material{Amount: material.Amount.Add(operation.Details[0].Amount)}); err != nil {
         return err
      }
      if err := models.NewLocationProductAmountSearch().SetOrm(tx).SetID(reqParams.LocationProductAmountId).Update(&models.LocationProductAmount{Amount: locProdtAmount.Amount.Add(operation.Details[0].Amount)}); err != nil {
         return err
      }
      return nil
   }); err != nil {
      util.ResponseFormat(c, code.RequestError, err.Error())
      return
   }
   util.ResponseFormat(c, code.Success, "操作成功")
}