完成表格参数项参数值获取

licp

2024-03-27 1cd0b6a91bda57e9f99fdbe2b5faff144d64a477

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

@@ -139,7 +139,7 @@
                :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}`">
                  <span v-if="n.v.ps===undefined || n.v.ps.value!='检验值'" :style="`font-family:${n.v.ff} !important;`">{{ n.v.v}}</span>
                           <input v-else class="table_input"/>
                           <el-input v-else class="table_input" v-model="n.v.v" @change="m=>changeInput(m,`${item.templateId}-${n.r}-${n.c}`)" />
                </div>
                </td>
              </tr>
@@ -187,6 +187,7 @@
</template>

<script>
import { number } from 'echarts';
  import ValueTable from '../../tool/value-table.vue'
   export default {
      props: ['sonLaboratory','orderId'],
@@ -244,6 +245,53 @@
               result: {}
            },
        currentKey:1,
        comparisonList:[
          {
            0:'0',
            1:'A',
          },
          {
            0:'1',
            1:'B',
          },
          {
            0:'2',
            1:'C',
          },
          {
            0:'3',
            1:'D',
          },
          {
            0:'4',
            1:'E',
          },
          {
            0:'5',
            1:'F',
          },
          {
            0:'6',
            1:'G',
          },
          {
            0:'7',
            1:'H',
          },
          {
            0:'8',
            1:'I',
          },
          {
            0:'9',
            1:'J',
          },
          {
            0:'10',
            1:'K',
          },
        ],
        excelMethodList:[]
         }
      },
      created() {
@@ -328,6 +376,7 @@
        row.index = rowIndex + 1;
      },
      handleTableData(){
        this.excelMethodList = []
        const mySet1 = new Set();
        this.tableList = JSON.parse(JSON.stringify(this.currentSample.insProduct)).filter(m=>{
          let num0 = mySet1.size;
@@ -392,6 +441,9 @@
               let set = new Set()
               a.template.forEach(b=>{
                  set.add(b.r)
            if(b.v.f){
              this.excelMethodList.push(b)
            }
               })
               set = Array.sort(set)
               set.forEach(b=>{
@@ -418,7 +470,63 @@
               })
               a.arr = arrs
            })
      }
      }
   }
        this.handleExcelMethod()
      },
      changeInput(m,code){
        console.log(m,'code:',code,this.excelMethodList)
        let r = code.split('-')[1]
        let c = code.split('-')[2]
        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}`)//改变最终值
          }
        })
      },
      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(':')){
              valueList = [];
              let r0 = null;
              let c0 = null;
              let r1 = null;
              let c1 = null;
              let mode = item.v.f.split('(')[1].split(')')[0];
              let start = mode.split(':')[0]
              let end = mode.split(':')[1]
              c0 = this.comparisonList.find(j=>j['1']==start.split('')[0])[`0`]
              r0 = start.split('')[1]-1
              c1 = this.comparisonList.find(j=>j['1']==end.split('')[0])[`0`]
              r1 = end.split('')[1]-1
              for (let i=Number(r0);i<=r1;i++){
                for(let u=c0;u<=c1;u++){
                  valueList.push({
                    r:i,
                    c:u
                  })
                }
              }
              item.valueList = valueList;
            }else{
              valueList = []
              let regex= /[\+\-\*\%\(\)\s]/g
              let mode = item.v.f.replace(regex, ' ').split(' ');
              mode.forEach(m=>{
                let r = m.split('')[1]-1
                let c = this.comparisonList.find(j=>j['1']==m.split('')[0])[`0`]
                valueList.push({c,r})
              })
            }
            return item;
          })
        }
        }
     },
}
</script>