检验任务

李林

2024-03-27 704daaa5499c432a486c6961fa3f7f5531839126

 src/components/do/b1-inspect-order-plan/Inspection.vue

@@ -131,14 +131,14 @@
          <tbody>
              <tr v-for="(m,i) in item.arr" :key="i">
                <td
                        :id='item.templateId+"-"+n.r+"-"+n.c'
                        :id='item.templateId+"-"+n.i+"-"+n.r+"-"+n.c'
                v-for="(n,j) in m"
                :key="j"
                :colspan="n.v.mc&&n.v.mc.cs?n.v.mc.cs:1"
                :rowspan="n.v.mc&&n.v.mc.rs?n.v.mc.rs:1"
                :style="`background:${n.v.bg};color:${n.v.fc};font-size:${n.v.fs}px;width:${item.style.columnlen[n.c]}px;height:${item.style.rowlen[n.r]}px;font-wight:${n.v.bl?'bold':''};`">
                <div class="content" :class="`content-h-${n.v.ht} content-v-${n.v.vt}`">
                  <el-input v-if="n.v.ps!=undefined && n.v.ps.value==='检验值'" class="table_input" v-model="n.v.v" @change="m=>changeInput(m,`${item.templateId}-${n.r}-${n.c}`)" />
                  <el-input v-if="n.v.ps!=undefined && n.v.ps.value==='检验值'" class="table_input" v-model="n.v.v" @change="m=>changeInput(m,`${item.templateId}-${n.r}-${n.c}-${n.i}`)" />
                           <template v-else-if="n.v.ps!=undefined && n.v.ps.value==='结论'">
                              <span v-if="n.v.v===1" :style="`font-family:${n.v.ff} !important;color: green;`">合格</span>
                              <span v-else-if="n.v.v===0" :style="`font-family:${n.v.ff} !important;color: red;`">不合格</span>
@@ -420,6 +420,12 @@
            if (b.v.ps!=undefined&&b.v.ps.value==='检验值'){
                     b.v.v = ''
                  }
                  if (b.v.ps!=undefined&&b.v.ps.value==='计算值'){
                     b.v.v = ''
                  }
                  if (b.v.ps!=undefined&&b.v.ps.value==='最终值'){
                     b.v.v = ''
                  }
                  set.add(b.r)
            if(b.v.f){
              this.excelMethodList.push(b)
@@ -453,22 +459,72 @@
        this.handleExcelMethod()
      },
      changeInput(m,code){
        console.log(m,'code:',code,this.excelMethodList)
        let r = code.split('-')[1]
        let c = code.split('-')[2]
        // console.log(m,'code:',code,this.excelMethodList)
            let str = code.split('-')
        let r = str[1]
        let c = str[2]
            let id = str[0]
            var list = []
            for(let a in this.tableList){
               if(this.tableList[a].templateId == id){
                  list = this.tableList[a].arr
                  break
               }
            }
        this.excelMethodList.forEach(item=>{
          if(item.valueList.find(m=>m.r==r&&m.c==c)){
            console.log('当前的方法',item.methodName)
            console.log('当前的数据项',item.valueList)
            console.log('当前的数值项','r:',item.r,'c:',item.c)
            this.changeInput('计算的结果',`${code.split('-')[0]}-${item.r}-${item.c}`)//改变最终值
                  var comValue = {}
                  item.valueList.forEach(a=>{
                     list.forEach(b=>{
                        if(b[0].r==a.r){
                           b.forEach(c=>{
                              if(c.c==a.c){
                                 if(!isNaN(parseFloat(c.v.v))){
                                    var tableCode = ''
                                    for(var d in this.comparisonList){
                                       if(c.c == this.comparisonList[d].value){
                                          tableCode = this.comparisonList[d].label
                                          break
                                       }
                                    }
                                    comValue[(tableCode + c.r)] = parseFloat(c.v.v)
                                 }
                              }
                           })
                        }
                     })
                  })
                  // console.log('当前的方法',item.methodName)
                  let comResult = 0
                  switch(item.methodName){
                     case 'AVERAGE': 
                        let sum = 0
                        for(var a in comValue){
                           sum += comValue[a]
                        }
                        comResult = sum / Object.keys(comValue).length
                        break;
                     default:
                        break;
                  }
                  list.map(a=>{
                     if(a[0].r == item.r){
                        for(var b in a){
                           if(a[b].c == item.c){
                              a[b].v.v = comResult.toFixed(2)
                              break
                           }
                        }
                     }
                     return a
                  })
                  this.changeInput(comResult,`${code.split('-')[0]}-${item.r}-${item.c}-${id}`)//改变最终值
          }
        })
      },
      handleExcelMethod(){
        if(this.excelMethodList.length>0){
          this.excelMethodList.map(item=>{
            if(item.v.f.includes(':')){}
            item.methodName = item.v.f.split('=')[1].split('(')&&item.v.f.split('=')[1].split('(')[0]?item.v.f.split('=')[1].split('(')[0]:'自定义方法';
            let valueList = [];
            if(item.v.f.includes(':')){