库存盘点列表bug

jiangshuai

2023-12-15 fda60dd56911c03330eb7330ebabd5d46e9d7622

库存盘点列表bug

 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