库存盘点列表bug

jiangshuai

2023-12-15 fda60dd56911c03330eb7330ebabd5d46e9d7622

 controllers/location_product_amount.go

@@ -12,6 +12,7 @@
   "wms/extend/code"
   "wms/extend/util"
   "wms/models"
   "wms/pkg/mysqlx"
   "wms/request"
   "wms/response"
   "wms/service"
@@ -67,7 +68,7 @@
   }
   var operation models.Operation
   for k, v := range records {
      if res := models.NewOperationSearch().Orm.Preload("Details", "product_id=?", v.ProductId).Where("wms_operation.base_operation_type=? and wms_operation.status=? and wms_operation.to_location_id=?", constvar.BaseOperationTypeAdjust, constvar.OperationStatus_Ready, v.LocationId).First(&operation); res.Error != nil {
      if res := mysqlx.GetDB().Table("wms_operation").InnerJoins("inner join wms_operation_details on wms_operation_details.operation_id=wms_operation.id").Where("wms_operation.base_operation_type=? and wms_operation.status=? and wms_operation.to_location_id=? and wms_operation_details.product_id=?", constvar.BaseOperationTypeAdjust, constvar.OperationStatus_Ready, v.LocationId, v.ProductId).First(&operation); res.Error != nil {
         if errors.Is(res.Error, gorm.ErrRecordNotFound) {
            records[k].Status = constvar.OperationStatus_Finish
            records[k].BaseOperationType = constvar.BaseOperationTypeAdjust