表格坐标转换

licp

2024-03-27 2514ee4fe0471be59f67723a85a64dee88db8c67

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

@@ -7,13 +7,11 @@
   .search {
      width: 100%;
      margin-bottom: 10px;
      height: 140px;
      background-color: #fff;
      border-radius: 3px;
   }

   .search .form-inline {
      height: 50px;
      padding-top: 20px;
      padding-left: 50px;
   }
@@ -24,33 +22,14 @@
      background-color: #fff;
      border-radius: 3px;
      padding: 20px;
   }
</style>
<style>
   .el-form-item__label{
      color: #000;
   }
  .el-drawer__header::before {
    content: "";
    display: inline-block;
    width: 4px;
    height: 30.24px;
    background: #3A7BFA;
    border-radius: 10px;
    margin-left: 32px;
    margin-right: 8.5px;
  }
  .el-drawer__header{
    color: #303133;
  }
  .center{
    display: flex;
    align-items: center;
    justify-content: center;
    flex-wrap: wrap;
  }
   }
  .tables{
    width: 800px;
    /* width: 800px; */
    margin-bottom: 16px;
  }
  .tables td{
    height: 40px;
@@ -64,7 +43,7 @@
    height: 100%;
    align-items: center;
    justify-content: left;
    padding: 2px;
    padding: 5px;
    box-sizing: border-box;
  }
  .content-h-0{
@@ -85,9 +64,32 @@
  .content-v-2{
    align-items: end;
  }

   .table_input{
      width: 100%;
      height: 100%;
   }
</style>
<style>
   .el-form-item__label{
      color: #000;
   }
  .el-drawer__header::before {
    content: "";
    display: inline-block;
    width: 4px;
    height: 30.24px;
    background: #3A7BFA;
    border-radius: 10px;
    margin-left: 32px;
    margin-right: 8.5px;
  }
  .el-drawer__header{
    color: #303133;
  }
</style>
<template>
   <div>
   <div v-loading="loading">
      <el-row class="title">
               <el-col :span="12" style="padding-left: 20px;">检验单详情</el-col>
               <el-col :span="12" style="text-align: right;">
@@ -120,7 +122,7 @@
               <el-input clearable v-model="insOrder.appointed" disabled size="small" placeholder="请输入"></el-input>
            </el-form-item>
        <el-form-item label="当前样品位数:" >
          <span v-if="currentSample.index">{{ `NO.${currentSample.index}` }}</span>
          <el-tag v-if="currentSample.index">{{ `NO.${currentSample.index}` }}</el-tag>
        </el-form-item>
         </el-form>
      </div>
@@ -129,13 +131,20 @@
          <tbody>
              <tr v-for="(m,i) in item.arr" :key="i">
                <td
                        :id='item.templateId+"-"+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};font-family:${n.v.ff};color:${n.v.fc};font-size:${n.v.fs}px;width:${item.style.columnlen['0']}px;height:${item.style.rowlen[i]}px;font-wight:${n.v.bl?'bold':''};`">
                :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>{{ n.v.v}}</span>
                  <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}`)" />
                           <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>
                              <span v-else :style="`font-family:${n.v.ff} !important;`">待定</span>
                           </template>
                           <span v-else :style="`font-family:${n.v.ff} !important;`">{{n.v.v}}</span>
                </div>
                </td>
              </tr>
@@ -145,20 +154,22 @@
    <el-drawer
      title="样品切换"
      :visible.sync="sampleVisible"
      size="50%">
      <el-table class="el-table" ref="productTable" :data="sampleProduct" height="100%" tooltip-effect="dark" border highlight-current-row @row-click="handleChangeSample" :row-class-name="tableRowClassName">
      :size="500">
      <el-table class="el-table" ref="productTable" :data="sampleProduct" height="100%" tooltip-effect="dark" border highlight-current-row @row-click="handleChangeSample" :row-class-name="tableRowClassName"
      :current-row-key="currentKey" :row-key="record=>record.index"
      v-if="sampleVisible">
            <el-table-column type="index" align="center" label="序号" width="70px" :key="Math.random()">
            </el-table-column>
            <el-table-column prop="sampleCode" label="样品编号" min-width="100px"
               show-overflow-tooltip></el-table-column>
        <el-table-column prop="model" label="样品型号" min-width="100px" show-overflow-tooltip></el-table-column>
            <el-table-column prop="insState" label="检测状态" min-width="100px" show-overflow-tooltip>
            <el-table-column prop="insState" label="检测状态" width="95px" show-overflow-tooltip>
          <template slot-scope="scope">
            <el-tag v-for="(item, i) in typeList" :key="i" v-if="item.value == scope.row.insState"
                              :type="item.type" size="medium" style="margin-right: 5px;">{{item.label}}</el-tag>
          </template>
        </el-table-column>
            <el-table-column prop="isLeave" label="是否留样" min-width="100px" show-overflow-tooltip>
            <el-table-column prop="isLeave" label="是否留样" width="95px" show-overflow-tooltip align="center">
          <template slot-scope="scope">
            <span>{{ scope.row.isLeave==0?'否':'是' }}</span>
          </template>
@@ -172,7 +183,7 @@
    <el-drawer
      title="任务切换"
      :visible.sync="taskVisible"
      size="45%">
      :size="500">
      <ValueTable class="value-table" ref="insOrderPlan"
               :url="$api.insOrderPlan.selectInsOrderPlanList" :componentData="componentData"
               :key="upIndex"/>
@@ -201,8 +212,8 @@
                  sonLaboratory: null,
                  userId: 0
               },
               isIndex: true,
               showSelect: true,
               isIndex: false,
               showSelect: false,
               select: false,
          selectMethod:'handleChangeTask',
               sort: false,
@@ -217,6 +228,7 @@
                     select: []
                  },
          },
          currentId:'',
               selectField: {},
               requiredAdd: [],
               requiredUp: []
@@ -228,6 +240,17 @@
        urgentList:[],
        currentSample:{},//当前样品信息
        tableList:[],
        loading: false,
            ps: {},
            param: {
               insValue:{},
               comValue: {},
               bestValue: {},
               result: {}
            },
        currentKey:1,
        comparisonList:[],
        excelMethodList:[]
         }
      },
      created() {
@@ -237,9 +260,11 @@
      mounted() {
      this.getTypeDicts()
      this.getInsStateDicts()
      this.getComparisonList()
      },
      watch:{
         id(val){
            this.loading = true
            this.$axios.post(this.$api.insOrderPlan.doInsOrder,{
               id: val
            }).then(res=>{
@@ -251,7 +276,11 @@
          })
               this.sampleProduct = res.data.sampleProduct
          this.currentSample = this.sampleProduct[0]
               if(this.currentSample.index==undefined)this.currentSample['index'] = 1
               this.loading = false
          this.handleTableData()
          this.componentData.currentId = val;
          this.currentKey = 1;
            })
         }
      },
@@ -260,9 +289,10 @@
        this.currentSample = row;
        this.handleTableData()
        this.sampleVisible = false;
        this.currentKey=row.index
      },
      handleChangeTask(row){
        this.id = row[0].id;
            if(row.length > 0)this.id = row[0].id;
        this.taskVisible = false;
      },
      getTypeDicts() {
@@ -302,10 +332,19 @@
               this.componentData.tagField.insState.select = data
            })
         },
      getComparisonList(){
        this.$axios.post(this.$api.enums.selectEnumByCategory, {
               category: "表格坐标转换"
            }).then(res => {
               let data = res.data
          this.comparisonList = data;
        })
      },
      tableRowClassName({ row, rowIndex }){
        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;
@@ -318,41 +357,156 @@
            return m
          }
        })
        this.tableList.map(item=>{
          const mySet0 = new Set();
          let arr = [];
          let arrItem = [];
          item.template.forEach((m,i)=>{
            let num0 = mySet0.size;
            mySet0.add(m.r)
            let num1 = mySet0.size;
            if(num0<num1){
              if(arrItem.length>0){
                arr.push(arrItem)
                arrItem = []
              }
              if(m.v.mc){
                if(m.v.mc.rs||m.v.mc.cs){
                  arrItem.push(m)
                }
              }else{
                arrItem.push(m)
              }
            }else{
              if(m.v.mc){
                if(m.v.mc.rs||m.v.mc.cs){
                  arrItem.push(m)
                }
              }else{
                arrItem.push(m)
              }
            this.tableList.forEach(a=>{
               let dels = []
               let ids = []
               a.template.forEach(b=>{
                  if (b.v.ps!=undefined&&b.v.ps.value==='检验子项'){
                     let count = 0
                     for(let i in this.currentSample.insProduct){
                        if(this.currentSample.insProduct[i].inspectionItemSubclass === b.v.v && this.currentSample.insProduct[i].templateId === a.templateId){
                           ids.push({
                              r: b.r,
                              id: this.currentSample.insProduct[i].id,
                              product: this.currentSample.insProduct[i]
                           })
                           break
                        }
                        count++
                     }
                     if(count === this.currentSample.insProduct.length){
                        dels.push(b)
                     }
                  }
               })
               dels.forEach(del=>{
                  for(let b=0;b<a.template.length;b++){
                     if(a.template[b].r === del.r){
                        if(a.template[b].v.mc!=undefined){
                           if(a.template[b].v.mc.rs!=undefined&&a.template[b].v.mc.rs>1){
                              if(a.template[b].r === a.template[b].v.mc.r){
                                 a.template[b].r += 1
                                 a.template[b].v.mc.r += 1
                                 a.template[b].v.mc.rs -= 1
                                 continue
                              }
                           }
                        }
                        a.template.splice(b, 1)
                        b-=1
                     }
                  }
               })
               ids.forEach(id=>{
                  for(let b=0;b<a.template.length;b++){
                     if(a.template[b].r === id.r){
                        a.template[b].i = id.id
                        if (a.template[b].v.ps!=undefined&&a.template[b].v.ps.value==='单位'){
                           a.template[b].v.v = id.product.unit
                        }
                     }
                  }
               })
            })
            this.tableList.forEach(a=>{
               let arrs = []
               let set = new Set()
               let count1 = 0
               a.template.forEach(b=>{
                  if (b.v.ps!=undefined&&b.v.ps.value==='序号'){
                     count1++
                     b.v.v = count1
                  }
            if (b.v.ps!=undefined&&b.v.ps.value==='检验值'){
                     b.v.v = ''
                  }
                  set.add(b.r)
            if(b.v.f){
              this.excelMethodList.push(b)
            }
          })
          arr.push(arrItem)
          item.arr = arr;
          return item
               })
               set = Array.sort(set)
               set.forEach(b=>{
                  let arr = []
                  a.template.forEach(c=>{
                     if(c.r === b){
                        if(arr.length===0){
                           if(c.v.mc==undefined||Object.keys(c.v.mc).length==4) arr.push(c)
                        }else{
                           for(let d=0;d<arr.length;d++){
                              if(c.c<arr[d].c){
                                 if(c.v.mc==undefined||Object.keys(c.v.mc).length==4) arr.splice(d, 0, c)
                                 break
                              }
                              if(d === arr.length-1){
                                 if(c.v.mc==undefined||Object.keys(c.v.mc).length==4) arr.push(c)
                                 break
                              }
                           }
                        }
                     }
                  })
                  arrs.push(arr)
               })
               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.label==start.split('')[0]).value
              r0 = start.split('')[1]-1
              c1 = this.comparisonList.find(j=>j.label==end.split('')[0]).value
              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.label==m.split('')[0]).value
                valueList.push({c,r})
              })
            }
            return item;
          })
        }
        }
     },
}
</script>