liujiandao
2023-10-23 b9a62531fb93aba42d13e62fd1b03d8dba112fa6
controllers/report_forms_controller.go
@@ -69,11 +69,11 @@
   dbIn := models.NewOperationDetailsSearch().Orm.Model(&models.OperationDetails{}).
      Joins("left join wms_operation ON wms_operation_details.operation_id=wms_operation.id").
      Where("wms_operation.base_operation_type=?", constvar.BaseOperationTypeIncoming).
      Where("wms_operation.status in (?)", []int{3, 4})
      Where("wms_operation.status = ?", constvar.OperationStatus_Finish)
   dbOut := models.NewOperationDetailsSearch().Orm.Model(&models.OperationDetails{}).
      Joins("left join wms_operation ON wms_operation_details.operation_id=wms_operation.id").
      Where("wms_operation.base_operation_type=?", constvar.BaseOperationTypeOutgoing).
      Where("wms_operation.status in (?)", []int{3, 4})
      Where("wms_operation.base_operation_type in (?)", []int{2, 4}).
      Where("wms_operation.status = ?", constvar.OperationStatus_Finish)
   if len(locationIds) > 0 {
      dbIn.Where("wms_operation.to_location_id in (?)", locationIds)
      dbOut.Where("wms_operation.from_location_id in (?)", locationIds)
@@ -142,7 +142,8 @@
      operationIds = append(operationIds, detail.OperationID)
   }
   //获取已完成的操作记录
   operations, total, err := models.NewOperationSearch().SetIds(operationIds).SetStatus(constvar.OperationStatus_Finish).Find()
   operations, total, err := models.NewOperationSearch().SetIds(operationIds).SetBaseOperationType(params.BaseOperationType).
      SetStatus(constvar.OperationStatus_Finish).Find()
   if err != nil {
      util.ResponseFormat(c, code.RequestParamError, "查询操作记录失败")
      return