根据规格查找标准改成范围查询

zhangqian

2024-04-30 7ec7452f149996790234803f7a7c12a48a36c498

 service/fineness.go

@@ -10,67 +10,55 @@
   "sort"
)

func FinenessCheck(finenessRegister *models.FinenessRegister) (err error) {
   standardMap, err := GetSilkRankStandard()
   if err != nil {
      return err
   }
func FinenessCheck(finenessRegister *models.FinenessRegister, standardMap map[string]*Standard, endCarMap map[int]bool, isNew bool) (err error) {
   finenessCheckItems := make([]*models.FinenessCheckItem, 0)
   var lastCarNo int
   var roundingItemMap map[float32]*models.FinenessRoundingItem
   var allFinenessList []decimal.Decimal
   var personFinenessList []decimal.Decimal
   var carCheckNumber = 0 //单个car已检查样本数
   endCarMap, err := GetWorkshopEndCarMap(finenessRegister.Workshop, finenessRegister.WorkshopGroup)
   if err != nil {
      return err
   }
   var item *models.FinenessCheckItem
   var deviation decimal.Decimal
   var finenessGrade string
   for _, finenessItem := range finenessRegister.FinenessList {
      roundedHalfFineness := ToRoundedHalfFineness(finenessItem.Fineness)
      fineness := decimal.NewFromFloat32(roundedHalfFineness)
      allFinenessList = append(allFinenessList, fineness)
      personFinenessList = append(personFinenessList, fineness)
      carCheckNumber++
      if carCheckNumber == constvar.EveryPersonCarCheckNumber {
         carCheckNumber = 0
         if endCarMap[finenessItem.Position] { //走到了某个人最后的车号,每人算一次偏差和等级
            deviation = utils.Deviation(personFinenessList)
            finenessGrade = CalcFinenessGrade(item.Deviation, item.TotalDeviation, item.Cleanliness, item.Purity, item.TwiceChange, standardMap)
            personFinenessList = personFinenessList[:0]
         }
      }
      if lastCarNo != finenessItem.Position { //每个车号存一个models.FinenessCheckItem
         roundingItems := make([]*models.FinenessRoundingItem, 0, len(roundingItemMap))
         for _, v := range roundingItemMap {
            roundingItems = append(roundingItems, &models.FinenessRoundingItem{
               Fineness: v.Fineness,
               Quantity: v.Quantity,
            })
         }
         item = &models.FinenessCheckItem{
            FinenessRegisterID:    finenessRegister.ID,
            Position:              lastCarNo,
            FinenessRoundingItems: roundingItems,
            Deviation:             deviation,
            FinenessGrade:         finenessGrade,
            Remark:                "",
         }

         finenessCheckItems = append(finenessCheckItems, item)
   var item *models.FinenessCheckItem
   var deviation, totalDeviation decimal.Decimal
   var finenessGrade string
   var roundingItemMap = make(map[float32]*models.FinenessRoundingItem, 0)
   lastCarNo = finenessRegister.FinenessList[0].Position
   for _, finenessItem := range finenessRegister.FinenessList {
      if lastCarNo != finenessItem.Position { //每个车号存一个models.FinenessCheckItem
         carCheckNumber = 0
         lastCarNo = finenessItem.Position
         roundingItemMap = make(map[float32]*models.FinenessRoundingItem, 0)
      }
      roundedHalfFineness := ToRoundedHalfFineness(finenessItem.Fineness) //类似四舍五入
      fineness := decimal.NewFromFloat32(roundedHalfFineness)
      for i := 0; i < finenessItem.Quantity; i++ {
         allFinenessList = append(allFinenessList, fineness)
         personFinenessList = append(personFinenessList, fineness)
      }

      if roundingItemMap[roundedHalfFineness] == nil {
         roundingItemMap[roundedHalfFineness] = &models.FinenessRoundingItem{
            Fineness: fineness,
            Quantity: 1,
            Quantity: finenessItem.Quantity,
         }
      } else {
         roundingItemMap[roundedHalfFineness].Quantity++
         roundingItemMap[roundedHalfFineness].Quantity += finenessItem.Quantity
      }

      carCheckNumber++
      if carCheckNumber == constvar.EveryPersonCarCheckNumber {
         carCheckNumber = 0
         if endCarMap[finenessItem.Position] { //走到了某个人最后的车号,每人算一次偏差和等级
            deviation = utils.Deviation(personFinenessList)
            totalDeviation = TotalDeviation(personFinenessList, utils.Average(personFinenessList))
            finenessGrade = CalcFinenessGrade(deviation, totalDeviation, decimal.Zero, decimal.Zero, decimal.Zero, standardMap)
            personFinenessList = personFinenessList[:0]
         } else {
            deviation = decimal.Zero
            totalDeviation = decimal.Zero
            finenessGrade = ""
         }
         item = MakeFinenessCheckItem(roundingItemMap, finenessRegister.ID, lastCarNo, deviation, totalDeviation, finenessGrade)
         finenessCheckItems = append(finenessCheckItems, item)
         roundingItemMap = make(map[float32]*models.FinenessRoundingItem, 0) //重置
      }
   }

@@ -85,16 +73,58 @@
      MarketProcessOrderNumber: "",
      Inspector:                "",
   }
   finenessCheck.TotalDeviation = TotalDeviation(allFinenessList, finenessCheck.AverageFineness)
   finenessCheck.FinenessGrade = CalcFinenessGrade(finenessCheck.Deviation, finenessCheck.TotalDeviation, finenessCheck.Cleanliness, finenessCheck.Purity, finenessCheck.TwiceChange, standardMap)

   err = models.WithTransaction(func(db *gorm.DB) error {
      if !isNew {
         err = models.NewFinenessCheckSearch().SetOrm(db).SetFinenessRegisterID(finenessRegister.ID).Delete()
         if err != nil {
            return err
         }
         err = models.NewFinenessCheckItemSearch().SetOrm(db).SetFinenessRegisterID(finenessRegister.ID).Delete()
         if err != nil {
            return err
         }
      }
      err := models.NewFinenessCheckSearch().SetOrm(db).Create(&finenessCheck)
      if err != nil {
         return err
      }
      return models.NewFinenessCheckItemSearch().SetOrm(db).CreateBatch(finenessCheckItems)
      if len(finenessCheckItems) > 0 {
         for _, v := range finenessCheckItems {
            v.FinenessCheckID = finenessCheck.ID
         }
         err = models.NewFinenessCheckItemSearch().SetOrm(db).CreateBatch(finenessCheckItems)
         if err != nil {
            return err
         }
      }

      return models.NewFinenessRegisterSearch().SetOrm(db).SetID(finenessRegister.ID).UpdateByMap(map[string]interface{}{"fineness_check_id": finenessCheck.ID})
   })
   return err
}

func MakeFinenessCheckItem(roundingItemMap map[float32]*models.FinenessRoundingItem, finenessRegisterID uint, position int, deviation, totalDeviation decimal.Decimal, finenessGrade string) *models.FinenessCheckItem {
   roundingItems := make([]*models.FinenessRoundingItem, 0, len(roundingItemMap))
   for _, v := range roundingItemMap {
      roundingItems = append(roundingItems, &models.FinenessRoundingItem{
         Fineness: v.Fineness,
         Quantity: v.Quantity,
      })
   }
   item := &models.FinenessCheckItem{
      FinenessRegisterID:    finenessRegisterID,
      Position:              position,
      FinenessRoundingItems: roundingItems,
      Deviation:             deviation,
      TotalDeviation:        totalDeviation,
      FinenessGrade:         finenessGrade,
      Remark:                "",
   }

   return item
}

type gradeRank struct {
@@ -106,14 +136,11 @@
   checkItemGradeMap := make(map[constvar.CheckItem]string, 5)
   gradeRanks := make([]gradeRank, 0)
   for _, st := range standardMap {
      if st.StartFineness.GreaterThan(deviation) || st.EndFineness.LessThan(deviation) {
         continue
      }
      grade := ""
      for _, pair := range st.ValueList {
         switch st.CheckItem {
         case constvar.CheckItemDeviation:
            if st.SortType == SortTypeAsc {
            if st.SortType == ValueTypeSmallerBetter {
               if deviation.LessThanOrEqual(pair.RankValue) {
                  grade = pair.RankName
               }
@@ -123,7 +150,7 @@
               }
            }
         case constvar.CheckItemMaxDeviation:
            if st.SortType == SortTypeAsc {
            if st.SortType == ValueTypeSmallerBetter {
               if totalDeviation.LessThanOrEqual(pair.RankValue) {
                  grade = pair.RankName
               }
@@ -133,7 +160,7 @@
               }
            }
         case constvar.CheckItemTwiceChange:
            if st.SortType == SortTypeAsc {
            if st.SortType == ValueTypeSmallerBetter {
               if twiceChange.LessThanOrEqual(pair.RankValue) {
                  grade = pair.RankName
               }
@@ -143,7 +170,7 @@
               }
            }
         case constvar.CheckItemCleanliness:
            if st.SortType == SortTypeAsc {
            if st.SortType == ValueTypeSmallerBetter {
               if cleanliness.LessThanOrEqual(pair.RankValue) {
                  grade = pair.RankName
               }
@@ -153,7 +180,7 @@
               }
            }
         case constvar.CheckItemPurity:
            if st.SortType == SortTypeAsc {
            if st.SortType == ValueTypeSmallerBetter {
               if purity.LessThanOrEqual(pair.RankValue) {
                  grade = pair.RankName
               }
@@ -167,13 +194,14 @@
            break
         }
      }
      if grade != "" {
         checkItemGradeMap[st.CheckItem] = grade
         gradeRanks = append(gradeRanks, gradeRank{
            gradeName: grade,
            gradeRank: st.GradeRank[grade],
         })
      if grade == "" {
         grade = constvar.BadFinenessGradeC
      }
      checkItemGradeMap[st.CheckItem] = grade
      gradeRanks = append(gradeRanks, gradeRank{
         gradeName: grade,
         gradeRank: st.GradeRank[grade],
      })
   }
   if len(gradeRanks) == 0 {
      return ""
@@ -202,3 +230,31 @@
   result = float32(math.Round(float64(result)*10) / 10)
   return result
}

func TotalDeviation(numbers []decimal.Decimal, average decimal.Decimal) decimal.Decimal {
   if len(numbers) < 2 {
      return decimal.Zero
   }

   n := len(numbers)
   ratio := decimal.NewFromFloat(0.02)
   length := decimal.NewFromInt(int64(n)).Mul(ratio).Ceil().IntPart()
   if length >= int64(n) {
      return decimal.Zero
   }

   sort.Slice(numbers, func(i, j int) bool {
      return numbers[i].LessThan(numbers[j])
   })

   minPart := numbers[:length-1]
   maxPart := numbers[length:]

   minAverage := utils.Average(minPart)
   maxAverage := utils.Average(maxPart)

   minDiff := minAverage.Sub(average).Abs()
   maxDiff := maxAverage.Sub(average).Abs()

   return decimal.Max(minDiff, maxDiff)
}