位置修改

liujiandao

2023-10-23 b9a62531fb93aba42d13e62fd1b03d8dba112fa6

 controllers/product_controller.go

@@ -38,10 +38,6 @@
      util.ResponseFormat(c, code.RequestParamError, "产品名称不能为空")
      return
   }
   if params.SalePrice.IntPart() <= 0 {
      util.ResponseFormat(c, code.RequestParamError, "产品售价不能小于等于零")
      return
   }
   if params.Model == "" {
      util.ResponseFormat(c, code.RequestParamError, "物料类型不能为空")
      return
@@ -137,10 +133,6 @@
   }
   if params.Name == "" {
      util.ResponseFormat(c, code.RequestParamError, "产品名称不能为空")
      return
   }
   if params.SalePrice.IntPart() <= 0 {
      util.ResponseFormat(c, code.RequestParamError, "产品售价不能小于等于零")
      return
   }
   if params.Model == "" {
@@ -404,7 +396,7 @@
   db := models.NewOperationSearch().Orm.Table("wms_operation").Select("wms_operation.id,wms_operation.number,wms_operation.source_number,wms_operation.status,wms_operation.from_location_id,wms_operation.to_location_id,wms_operation.operation_date,wms_operation.contacter_id,wms_operation.contacter_name,wms_operation.company_id,wms_operation.company_name,wms_operation.comment,wms_operation_details.product_id,material.name as product_name,material.unit,wms_operation_details.amount").InnerJoins("inner join wms_operation_details on wms_operation_details.operation_id=wms_operation.id").InnerJoins("inner join material on material.id=wms_operation_details.product_id")

   if params.Number != "" {
      db = db.Where("wms_operation.number like ? or wms_operation.source_number like ?", fmt.Sprintf("%%%v%%", params.Number), fmt.Sprintf("%%%v%%", params.Number))
      db = db.Where("wms_operation.number like ? or wms_operation.source_number like ? or material.name like ?", fmt.Sprintf("%%%v%%", params.Number), fmt.Sprintf("%%%v%%", params.Number), fmt.Sprintf("%%%v%%", params.Number))
   }
   db = db.Where("wms_operation.operation_type_id=?", 0)
   var (
@@ -485,6 +477,21 @@
            if err := tx.Save(listProdt[k]).Error; err != nil {
               return err
            }
            var locAmount models.LocationProductAmount
            if err := models.NewLocationProductAmountSearch().Orm.
               Table("wms_location_product_amount").
               Joins("inner join wms_location_product on wms_location_product.id=wms_location_product_amount.location_product_id").
               Where("wms_location_product.product_id=? and wms_location_product.location_id=?", v.ID, operation.FromLocationID).
               First(&locAmount).Error; err != nil {
               return err
            }
            if locAmount.Amount.LessThan(value) {
               return errors.New(fmt.Sprintf("产品：%v,库存：%v,出库：%v,数量不够，无法完成出库操作", v.Name, v.Amount.String(), value.String()))
            }
            locAmount.Amount = locAmount.Amount.Sub(value)
            if err := models.NewLocationProductAmountSearch().SetID(locAmount.Id).Update(&locAmount); err != nil {
               return err
            }
         }
      }
      return nil
@@ -528,6 +535,10 @@
      util.ResponseFormat(c, code.RequestParamError, "该信息无法修改")
      return
   }
   if params.ProductId == "" {
      util.ResponseFormat(c, code.RequestParamError, "请选择报废产品")
      return
   }
   detail := &models.OperationDetails{
      ProductId: params.ProductId,
      //ProductName: params.ProductName,
@@ -535,15 +546,16 @@
      //Unit:        params.Unit,
   }
   operation := models.Operation{
      Id:              params.Id,
      Number:          params.Number,
      SourceNumber:    params.SourceNumber,
      OperationTypeId: 0,
      Status:          params.Status,
      FromLocationID:  params.FromLocationId,
      ToLocationID:    params.ToLocationId,
      OperationDate:   params.OperationDate,
      Details:         []*models.OperationDetails{detail},
      Id:                params.Id,
      Number:            params.Number,
      SourceNumber:      params.SourceNumber,
      OperationTypeId:   0,
      Status:            params.Status,
      FromLocationID:    params.FromLocationId,
      ToLocationID:      params.ToLocationId,
      OperationDate:     params.OperationDate,
      Details:           []*models.OperationDetails{detail},
      BaseOperationType: params.BaseOperationType,
   }
   if err := models.WithTransaction(func(tx *gorm.DB) error {
      if err := models.NewOperationDetailsSearch().SetOrm(tx).SetOperationId(params.Id).Delete(); err != nil {