检验任务

李林

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>
@@ -417,7 +417,13 @@
                            count1++
                            b.v.v = count1
                        }
            if (b.v.ps!=undefined&&b.v.ps.value==='检验值'){
                        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)
@@ -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(':')){