From a0b1fdec2bc5ddad11e981936b80d0fdf1e4bc69 Mon Sep 17 00:00:00 2001
From: licp <lichunping@guanfang.com.cn>
Date: 星期三, 03 七月 2024 09:25:06 +0800
Subject: [PATCH] Merge branch 'master' of http://114.132.189.42:9002/r/center-lims-before into master

---
 src/components/do/b1-inspect-order-plan/Inspection.vue |  625 ++++++++++++++++++++++++++++++++++++++++++--------------
 1 files changed, 467 insertions(+), 158 deletions(-)

diff --git a/src/components/do/b1-inspect-order-plan/Inspection.vue b/src/components/do/b1-inspect-order-plan/Inspection.vue
index 489bd8d..3acbdfe 100644
--- a/src/components/do/b1-inspect-order-plan/Inspection.vue
+++ b/src/components/do/b1-inspect-order-plan/Inspection.vue
@@ -60,6 +60,8 @@
     width: 100px;
     text-align: center;
     font-size: 14px;
+    word-wrap: break-word;
+    white-space: normal;
   }
 
   .content {
@@ -133,6 +135,18 @@
   .table_caret:active{
     opacity: .8;
   }
+  >>>input::-webkit-inner-spin-button {
+    -webkit-appearance: none !important;  /* 闅愯棌寰皟鎸夐挳 */
+    margin: 0 !important;  /* 绉婚櫎寰皟鎸夐挳鐨勮竟璺� */
+  }
+
+  >>>input[type=number] {
+      -moz-appearance: textfield !important;  /* 閽堝 Firefox */
+  }
+  >>>.el-form-item__content{
+    display: inline-flex;
+    align-items: center;
+  }
 </style>
 <style>
   .inspection .el-form-item__label {
@@ -194,15 +208,15 @@
 <template>
   <div v-loading="loading" class="inspection">
     <el-row class="title">
-      <el-col :span="12" style="padding-left: 20px;">妫�楠屽崟璇︽儏
-        <span style="color: #3A7BFA;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;鏍峰搧</span>
+      <el-col :span="12" style="padding-left: 20px;text-align: left;">妫�楠屽崟璇︽儏
+        <!-- <span style="color: #3A7BFA;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;鏍峰搧</span>
         <span v-if="currentFiberOpticTape" style="color: #3A7BFA;"> - 鍏夌氦甯�</span>
-        <span v-if="currentFiberOptic" style="color: #3A7BFA;"> - 鍏夌氦</span>
+        <span v-if="currentFiberOptic" style="color: #3A7BFA;"> - 鍏夌氦</span> -->
       </el-col>
       <el-col :span="12" style="text-align: right;">
-        <el-button size="small" type="primary" @click="fiberOpticVisible=true" v-if="fiberOptic.length>0">鍏夌氦鍒囨崲</el-button>
+        <!-- <el-button size="small" type="primary" @click="fiberOpticVisible=true" v-if="fiberOptic.length>0">鍏夌氦鍒囨崲</el-button>
         <el-button size="small" type="primary" @click="fiberOpticTapeVisible=true" v-if="fiberOpticTape.length>0">鍏夌氦甯﹀垏鎹�</el-button>
-        <el-button size="small" type="primary" @click="bushingVisible=true" v-if="bushing.length>0">濂楃鍒囨崲</el-button>
+        <el-button size="small" type="primary" @click="bushingVisible=true" v-if="bushing.length>0">濂楃鍒囨崲</el-button> -->
         <el-button size="small" type="primary" @click="sampleVisible=true">鏍峰搧鍒囨崲</el-button>
         <el-button size="small" type="primary" @click="taskVisible=true">浠诲姟鍒囨崲</el-button>
         <el-button size="small" type="primary" @click="addVerifyDia = true" v-show="state==1"
@@ -243,26 +257,51 @@
       </el-form>
     </div>
     <div class="center">
-      <div class="search">
-        <el-radio-group v-model="currentTable" size="small">
-          <el-radio-button :label="item.templateId" v-for="(item,index) in tableLists" :key="index"
-            size="small">{{ item.templateName }}</el-radio-button>
-        </el-radio-group>
+      <div class="search" style="text-align: left;display: flex;align-items: center;justify-content: space-between;">
+        <div style="display: flex;align-items: center;">
+          <span v-if="tableList.length>0">妫�楠屾ā鏉匡細</span>
+          <el-radio-group v-model="currentTable" size="small">
+            <el-radio-button :label="item.templateId" v-for="(item,index) in tableLists" :key="index"
+              size="small">{{ item.templateName }}</el-radio-button>
+          </el-radio-group>
+        </div>
+        <div>
+          <span v-if="fibers.length>0">&nbsp;&nbsp;鍏夌氦甯︼細</span>
+          <el-radio-group v-model="currentTab" size="small" v-if="fibers.length>0" @input="m=>handleChange(m,1)">
+            <el-radio-button :label="item.id" v-for="(item,index) in fibers" :key="index"
+              size="small">{{ item.code }}</el-radio-button>
+          </el-radio-group>
+          <span v-if="fiber.length>0">&nbsp;&nbsp;鍏夌氦锛�</span>
+          <el-radio-group v-model="currentTab" size="small" v-if="fiber.length>0" @input="m=>handleChange(m,2)">
+            <el-radio-button :label="item.id" v-for="(item,index) in fiber" :key="index"
+              size="small">{{ item.color }}</el-radio-button>
+          </el-radio-group>
+          <el-form :inline="true" :model="otherForm" class="form-inline" label-width="50px">
+            <el-form-item label="娓╁害:" style="margin-bottom: 0;">
+              <el-input clearable v-model="otherForm.temperature" size="small" placeholder="" style="width: 70px;" @change="m=>subOtherForm(m,'temperature')"></el-input>
+              <span style="margin-left: 4px;">鈩�</span>
+            </el-form-item>
+            <el-form-item label="婀垮害:" style="margin-bottom: 0;">
+              <el-input clearable v-model="otherForm.humidity" size="small" placeholder="" style="width: 70px;" @change="m=>subOtherForm(m,'humidity')"></el-input>
+              <span style="margin-left: 4px;">%</span>
+            </el-form-item>
+          </el-form>
+        </div>
       </div>
-      <div class="center-box" id="nav" v-loading="tableLoading">
+      <div class="center-box" id="nav" v-loading="tableLoading" v-if="!tableLists.find(m=>m.templateId==currentTable)||tableLists.find(m=>m.templateId==currentTable).templateName!='娓╁害寰幆妫�楠屽師濮嬭褰�'">
         <table border="1" class="tables" cellpadding="10" v-for="(item,index) in tableList" :key="index">
           <tbody>
             <tr v-for="(m,i) in item.arr" :key="i">
               <td :id='item.templateId+"-"+n.i+"-"+n.r+"-"+n.c' v-for="(n,j) in m" :key="j"
                 v-if="n.v.mc==undefined || Object.keys(n.v.mc).length === 4" :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:${handleWidth(n)}px !important;height:${item.style.rowlen[n.r]}px;font-wight:${n.v.bl?'bold':''};`">
+                :style="`background:${n.v.bg?n.v.bg:''};color:${n.v.fc};font-size:${n.v.fs}px;width:${handleWidth(n)}px !important;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}`"
-                  :style="`width:${handleWidth(n)}px !important;min-height:${item.style.rowlen[n.r]}px;background:${n.v.bg};`">
+                  :style="`width:${handleWidth(n)}px !important;min-height:${item.style.rowlen[n.r]}px;`">
                   <template v-if="n.v.ps!=undefined && n.v.ps.value==='妫�楠屽��' && state==1">
                     <el-input v-if="getInspectionValueType(n.i) == 1" class="table_input" v-model="n.v.v"
                       :disabled="getInspectionItemType(n.i) == 1 || (n.u != userId && n.u != undefined && n.u != '')"
-                      @change="m=>changeInput(m,`${item.templateId}-${n.r}-${n.c}-${n.i}`)">
+                      @change="m=>changeInput(m,`${item.templateId}-${n.r}-${n.c}-${n.i}`)" type="number" @mousewheel.native.prevent :key="'abc-'+'000'+index+'000'+i+'000'+j">
                       <el-button slot="append" type="primary" icon="el-icon-edit" size="mini"
                         v-if="getInspectionItemType(n.i) == 1" @click="getSystemValue(n)"></el-button>
                     </el-input>
@@ -279,12 +318,12 @@
                       v-else-if="getInspectionValueType(n.i) == 4">/</span>
                   </template>
                   <template v-else-if="n.v.ps!=undefined && n.v.ps.value==='缁撹'">
-                    <el-select v-if="(getInspectionValueType(n.i) == 2 || getInspectionValueType(n.i) == 5) && state==1"
+                    <!-- <el-select v-if="(getInspectionValueType(n.i) == 2 || getInspectionValueType(n.i) == 5) && state==1"
                       class="table_input" v-model="n.v.v" @change="saveInsContext()">
                       <el-option label="鍚堟牸" :value="1"></el-option>
                       <el-option label="涓嶅悎鏍�" :value="0"></el-option>
-                    </el-select>
-                    <template v-else>
+                    </el-select> -->
+                    <template>
                       <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>
@@ -308,7 +347,7 @@
                       :disabled="state>1" @visible-change="e=>getDic(e,n.i)" @change="saveInsContext()">
                       <el-option v-for="(e, i) in enumList" :key="i" :label="e.label" :value="e.value"></el-option>
                     </el-select> -->
-                    <span :style="`font-family:${n.v.ff} !important;`">{{n.v.v}}</span>
+                    <span :style="`font-family:${n.v.ff} !important;`">{{ toFixed(n.v.v,n.v.ct) }}</span>
                   </template>
                   <template v-else-if="n.v.ps!=undefined && n.v.ps.value==='鏍峰搧缂栧彿'">
                     <div style="display: flex;flex-wrap: nowrap;align-items: center;width: 100%" :title="currentSample.sampleCode">
@@ -348,12 +387,148 @@
                       v-if="currentFiberOptic" class="el-icon-caret-right table_caret" @click="caretOptic(1)"></i>
                     </div>
                   </template>
-                  <span v-else :style="`font-family:${n.v.ff} !important;`">{{n.v.v}}</span>
+                  <span v-else :style="`font-family:${n.v.ff} !important;`" v-html="getValue(n.v)" ></span>
                 </div>
               </td>
             </tr>
           </tbody>
         </table>
+      </div>
+      <div class="center-box" v-loading="tableLoading" v-else>
+        <!-- <el-divider></el-divider> -->
+        <h4 style="margin-bottom: 20px;">娓╁害寰幆妫�楠屽師濮嬭褰�</h4>
+        <el-form :inline="true" :model="wareForm" class="form-inline" label-width="100px">
+        <el-form-item label="鍨嬪彿:" style="margin-bottom: 0;">
+          <el-input clearable v-model="wareForm.entrustCode" disabled size="small" placeholder=""></el-input>
+        </el-form-item>
+        <el-form-item label="璇曢獙鏂规硶:" style="margin-bottom: 0;">
+          <el-input clearable v-model="wareForm.sampleCode" disabled size="small" placeholder=""></el-input>
+        </el-form-item>
+        <el-form-item label="妫�娴嬩緷鎹�:" style="margin-bottom: 0;">
+          <el-input clearable v-model="wareForm.sample" disabled size="small" placeholder=""></el-input>
+        </el-form-item>
+        <el-form-item label="寰幆娆℃暟:" style="margin-bottom: 0;">
+          <el-select v-model="wareForm.value" placeholder="璇烽�夋嫨" size="small">
+            <el-option
+              v-for="item in numOptions"
+              :key="item.value"
+              :label="item.label"
+              :value="item.value">
+            </el-option>
+          </el-select>
+        </el-form-item>
+        <el-form-item label="娓╁害:" style="margin-bottom: 0;">
+          <el-select v-model="wareForm.value" placeholder="璇烽�夋嫨" size="small">
+            <el-option
+              v-for="item in temperatureOptions"
+              :key="item.value"
+              :label="item.label"
+              :value="item.value">
+            </el-option>
+          </el-select>
+          <span style="margin-left: 4px;">鈩�</span>
+        </el-form-item>
+        </el-form>
+        <el-divider></el-divider>
+        <el-form :inline="true" :model="wareForm" label-width="100px" style="justify-content: flex-start;display: flex;align-items: center;width: 100%;">
+          <el-form-item label="浠櫒鍚嶇О:">
+            <el-select v-model="wareForm.value" placeholder="璇烽�夋嫨" size="small">
+              <el-option
+                v-for="item in temperatureOptions"
+                :key="item.value"
+                :label="item.label"
+                :value="item.value">
+              </el-option>
+            </el-select>
+          </el-form-item>
+          <el-form-item label="浠櫒缂栧彿:">
+            <el-select v-model="wareForm.value" placeholder="璇烽�夋嫨" size="small">
+              <el-option
+                v-for="item in temperatureOptions"
+                :key="item.value"
+                :label="item.label"
+                :value="item.value">
+              </el-option>
+            </el-select>
+          </el-form-item>
+          <el-form-item label="浠櫒鍚嶇О:" style="margin-left: 80px;">
+            <el-select v-model="wareForm.value" placeholder="璇烽�夋嫨" size="small">
+              <el-option
+                v-for="item in temperatureOptions"
+                :key="item.value"
+                :label="item.label"
+                :value="item.value">
+              </el-option>
+            </el-select>
+          </el-form-item>
+          <el-form-item label="浠櫒缂栧彿:">
+            <el-select v-model="wareForm.value" placeholder="璇烽�夋嫨" size="small">
+              <el-option
+                v-for="item in temperatureOptions"
+                :key="item.value"
+                :label="item.label"
+                :value="item.value">
+              </el-option>
+            </el-select>
+          </el-form-item>
+        </el-form>
+        <el-table
+          :data="wareTableData"
+          border
+          style="width: 100%;margin-bottom: 30px;" align="center">
+          <el-table-column
+            label="搴忓彿"
+            type="index"
+            width="65"
+            >
+          </el-table-column>
+          <el-table-column
+            prop="date"
+            label="绠¤壊鏍�"
+            width="150">
+          </el-table-column>
+          <el-table-column
+            prop="name"
+            label="鍏夌氦甯︾紪鍙�"
+            width="180">
+          </el-table-column>
+          <el-table-column
+            prop="province"
+            label="鍏夌氦鑹叉爣"
+            width="150">
+          </el-table-column>
+          <el-table-column
+            prop="city"
+            label="澶栫"
+            width="150">
+            <template slot-scope="scope">
+              <el-input size="small" v-model="scope.row.input" placeholder="璇疯緭鍏ュ唴瀹�"></el-input>
+            </template>
+          </el-table-column>
+          <el-table-column
+            prop="address"
+            label="鍐呯"
+            width="150">
+            <template slot-scope="scope">
+              <el-input size="small" v-model="scope.row.input" placeholder="璇疯緭鍏ュ唴瀹�"></el-input>
+            </template>
+          </el-table-column>
+          <el-table-column
+            prop="zip"
+            label="骞冲潎鍊�"
+            min-width="150">
+          </el-table-column>
+          <el-table-column
+            prop="zip"
+            label="琛板噺宸�"
+            min-width="150">
+          </el-table-column>
+          <el-table-column
+            prop="zip"
+            label="妫�娴嬩汉"
+            min-width="150">
+          </el-table-column>
+        </el-table>
       </div>
       <el-upload :action="action"
       :data="{
@@ -472,6 +647,7 @@
 <script>
   import ValueTable from '../../tool/value-table.vue'
   import file from '../../../util/file'
+  import excelFunction from '../../../util/excelFountion'
   export default {
     props: ['sonLaboratory', 'orderId', 'state'],
     components: {
@@ -599,7 +775,21 @@
         currentFiberOptic:null,//褰撳墠鍏夌氦
         currentBushing:null,//褰撳墠濂楃
         tableLoading:false,
-        upLoading:false
+        upLoading:false,
+        temptList:null,
+        fiber:[],
+        fibers:[],
+        currentTab:null,
+        wareForm:{},
+        numOptions:[],
+        temperatureOptions:[],
+        wareTableData:[
+          {}
+        ],
+        otherForm:{
+          humidity:null,
+          temperature:null,
+        }
       }
     },
     computed: {
@@ -646,8 +836,17 @@
           }
           this.sampleProduct = res.data.sampleProduct
           this.currentSample = this.HaveJson(this.sampleProduct[0])
+          let insProduct = this.HaveJson(this.currentSample.insProduct)
+          if(insProduct&&insProduct.length>0){
+            let {temperature,humidity} = insProduct[0];
+            this.otherForm = {
+              temperature:temperature?temperature:null,
+              humidity:humidity?humidity:null,
+            }
+          }
           let list = await this.getCurrentProduct(this.currentSample.id,0)
           this.currentSample.insProduct = this.HaveJson(list)
+          console.log(this.currentSample)
           this.currentSample.insProduct.forEach(a => {
             this.param[a.id] = {
               insValue: [],
@@ -658,9 +857,9 @@
               insResult: null
             }
           })
+          this.getReportModel(this.currentSample.id)
           if (this.currentSample.index == undefined) this.currentSample['index'] = 1
           let bushing = this.currentSample.bushing
-          // this.handleTableData()
           this.getTableLists();
           this.componentData.currentId = val;
           this.currentKey = 1;
@@ -672,6 +871,7 @@
           this.currentFiberOptic = null;
           this.bushing = []
           this.currentBushing = null;
+          this.currentTab = null;
           if(bushing&&bushing.length>0){
             this.bushing = bushing
           }
@@ -687,9 +887,27 @@
             }
           })
         }
-      }
+      },
     },
     methods: {
+      subOtherForm(m,type){
+        let ids = []
+        for (let i in this.param) {
+          ids.push(i)
+        }
+        this.$axios.post(this.$api.insOrderPlan.write,{
+          [type]:Number(m),
+          ids
+        }, {
+          headers: {
+            'Content-Type': 'application/json'
+          },
+          noQs:true
+        }).then(res => {
+          if (res.code == 201) return
+          this.$message.success('淇濆瓨鎴愬姛')
+        })
+      },
       getPower(){
         let power = JSON.parse(sessionStorage.getItem('power'))
         let fileDel = false
@@ -793,6 +1011,7 @@
             insResult: null
           }
         })
+        this.getReportModel(row.id)
         let bushing = this.currentSample.bushing
         if(bushing&&bushing.length>0){
           this.bushing = bushing
@@ -800,6 +1019,35 @@
         // this.handleTableData()
         this.getTableLists();
         this.currentKey = row.index
+        this.currentTab = null;
+      },
+      getReportModel(id){
+        this.$axios.post(this.$api.insOrderPlan.getReportModel+'?sampleId='+id, {}).then(res => {
+          this.fibers = res.data['鍏夌氦甯�']
+          this.fiber = res.data['鍏夌氦']
+        })
+      },
+      async handleChange(m,type){
+        if(m){
+          let list = await this.getCurrentProduct(m,type)
+          if(list.length>0){
+            list.forEach(a => {
+              this.param[a.id] = {
+                insValue: [],
+                comValue: [],
+                resValue: null,
+                equipValue: [],
+                equipName: [],
+                insResult: null
+              }
+            })
+            this.getTableLists0(list)
+          }else{
+            this.tableLists = []
+            this.tableList = []
+            this.$message.error('妫�楠岄」涓虹┖')
+          }
+        }
       },
       handleChangeTask(row) {
         if (row.length > 0) this.id = row[0].id;
@@ -944,6 +1192,7 @@
             count++
           })
         })
+        // 闂寮�濮�
         this.tableList.forEach(a => {
           let dels = new Set()
           let ids = []
@@ -1000,6 +1249,8 @@
               }
             }
           })
+          console.log(5555,a.template)
+          return
           ids.forEach(id => {
             for (let b = 0; b < a.template.length; b++) {
               if (a.template[b].r === id.r) {
@@ -1034,6 +1285,7 @@
             }
           })
         })
+        // 闂缁撴潫
         this.tableList.forEach(a => {
           let arrs = []
           let set = new Set()
@@ -1077,12 +1329,12 @@
               } else {
                 this.param[b.i].resValue = b
               } */
-              if (b.i !== undefined) {
+              if (b.i !== undefined&&!this.param[b.i].resValue) {
                 this.param[b.i].resValue = b
               }
             }
             if (b.v.ps != undefined && b.v.ps.value === '缁撹') {
-              if (b.i !== undefined) {
+              if (b.i !== undefined&&!this.param[b.i].insResult) {
                 this.param[b.i].insResult = b
                 conclusionList.forEach((n, i) => {
                   if (n.r == b.r && n.c == b.c) {
@@ -1153,6 +1405,7 @@
         let id = str[0]
         let pId = str[3]
         var list = []
+        // console.log(id, 'r', r , 'c',c,this.tableList)
         for (let a in this.tableList) {
           if (this.tableList[a].templateId == id) {
             list = this.tableList[a].arr
@@ -1161,7 +1414,6 @@
         }
         this.excelMethodList.forEach(item => {
           if (item.valueList.find(m => m.r == r && m.c == c)) {
-            console.log(item)
             var comValue = {}
             item.valueList.forEach(a => {
               list.forEach(b => {
@@ -1187,36 +1439,48 @@
                 }
               })
             })
-            if (item.methodName == '鑷畾涔夋柟娉�' && item.v.ps != undefined && item.v.ps.value == '缁撹') {
-              if (this.currentSample.insProduct.find(m => m.id == item.i)) {
+            if (item.v.ps != undefined && item.v.ps.value == '缁撹') {
+              try {
+                if (this.currentSample.insProduct.find(m => m.id == item.i)) {
                 let ask = this.currentSample.insProduct.find(m => m.id == item.i).ask?this.currentSample.insProduct.find(m => m.id == item.i).ask.split('&'):null;
                 let res = Object.values(comValue)[0]
                 let comp = []
-                if(ask){
-                  comp = ask.map((m, i) => {
-                  if (m.includes('=')) {
-                    return res == m.split('=')[1]
-                  } else if (m.includes('鈮�')) {
-                    return res >= m.split('鈮�')[1]
-                  }else if (m.includes('鈮�')) {
-                    return res <= m.split('鈮�')[1]
-                  }else if (m.includes('<')) {
-                    return res < m.split('<')[1]
-                  }else if (m.includes('>')) {
-                    return res > m.split('>')[1]
-                  }else if (m.includes('~')) {
-                    let k = m.split('~')
-                    return res >= k[0] && res <= k[1]
-                  }else if(m.includes('-')){
-                    let k = m.split('-')
-                    return res >= k[0] && res <= k[1]
-                  }else if(m.includes('卤')){
-                    let k = m.split('卤')
-                    return res >= (k[0] - k[1]) && res <= (k[0] + k[1])
+                if(res==''||res==null||res==undefined||res=='Infinity'){
+                  item.v.v = ''
+                }else{
+                  if(ask){
+                    comp = ask.map((m, i) => {
+                      if (m.includes('=')) {
+                        let str = m.split('=')[1]
+                        if(typeof res == 'string'&&typeof str == 'string'){
+                          return  res.trim() == str.trim()
+                        }else{
+                          return  eval(res) == eval(str)
+                        }
+                      } else if (m.includes('鈮�')) {
+                        return eval(res) >= eval(m.split('鈮�')[1])
+                      }else if (m.includes('鈮�')) {
+                        return eval(res) <= eval(m.split('鈮�')[1])
+                      }else if (m.includes('<')) {
+                        return  eval(res) < eval(m.split('<')[1])
+                      }else if (m.includes('>')) {
+                        return  eval(res) > eval(m.split('>')[1])
+                      }else if (m.includes('~')) {
+                        let k = m.split('~')
+                        return  eval(res) >= eval(k[0]) && eval(res) <= eval(k[1])
+                      }else if(m.includes('-')){
+                        let k = m.split('-')
+                        return  eval(res) >= eval(k[0]) && eval(res) <= eval(k[1])
+                      }else if(m.includes('卤')){
+                        let k = m.split('卤')
+                        return  eval(res) >= eval((k[0] - k[1])) && eval(res) <= eval((k[0] + k[1]))
+                      }else if(m.includes('锛�')){
+                        return  eval(res) > eval(m.split('锛�')[1])
+                      }else if(m.includes('锛�')){
+                        return  eval(res) < eval(m.split('锛�')[1])
+                      }
+                    })
                   }
-                })
-                }
-                if(this.getInspectionValueType(item.i)==1){
                   if (comp.every(m => m)) {
                     item.v.v = 1
                   } else {
@@ -1225,38 +1489,16 @@
                 }
                 this.saveInsContext()
               }
+              } catch (error) {
+
+              }
+
             } else {
-              let comResult = 0;
-              switch (item.methodName) {
-                case 'AVERAGE':
-                  let num = 0
-                  for (var a in comValue) {
-                    num += comValue[a]
-                  }
-                  comResult = num / Object.keys(comValue).length
-                  break;
-                case 'SUM':
-                  let sum = 0
-                  for (var a in comValue) {
-                    sum += comValue[a]
-                  }
-                  comResult = sum
-                  break;
-                case 'MEDIAN':
-                  let arr = []
-                  for (var a in comValue) {
-                    arr.push(comValue[a])
-                  }
-                  comResult = this.median(arr)
-                  break;
-                case 'APS':
-                  let arr0 = []
-                  for (var a in comValue) {
-                    arr0.push(comValue[a])
-                  }
-                  comResult = Math.abs(arr[0])
-                  break;
-                default:
+              let comResult = ''
+              try {
+                if(this.getInspectionValueType(item.i)==1){
+                  comResult = excelFunction.compute(item.v.f.replace(/=/g, ' '),comValue)
+                }else{
                   let valueList = [];
                   item.valueList.forEach(a => {
                     valueList.push({
@@ -1271,42 +1513,120 @@
                       }
                     })
                   }
-                  let str = item.v.f.replace(/=/g, ' ');
+                  let str = item.v.f.replace(/=/g, ' ')
                   valueList.forEach(b => {
                     str = str.replace(b.name, b.value)
                   })
-                  try {
-                    if(this.getInspectionValueType(item.i)==1){
-                      comResult = eval(str)
-                    }else{
-                      comResult = str
-                    }
-                  } catch (error) {
-
-                  }
-                  break;
-              }
-              console.log(comResult)
-              list.forEach(a => {
-                if (a[0].r == item.r && comResult != '') {
-                  for (var b in a) {
-                    if (a[b].c == item.c) {
-                      try{
-                        let val = parseFloat(comResult.toFixed(3))
-                        a[b].v.v = isNaN(val) ? '' : val
-                      }catch(e){
-                        a[b].v.v = comResult
-                      }
-                      break
-                    }
-                  }
+                  comResult = str
                 }
-              })
-              this.changeInput(comResult, `${id}-${item.r}-${item.c}-${pId}`) //鏀瑰彉鏈�缁堝��
+              } catch (error) {
+
+              }
+              // comResult = excelFunction.compute(item.v.f.replace(/=/g, ' '),comValue);
+              // switch (item.methodName) {
+              //   case 'AVERAGE':
+              //     let num = 0
+              //     for (var a in comValue) {
+              //       num += comValue[a]
+              //     }
+              //     comResult = num / Object.keys(comValue).length
+              //     break;
+              //   case 'SUM':
+              //     let sum = 0
+              //     for (var a in comValue) {
+              //       sum += comValue[a]
+              //     }
+              //     comResult = sum
+              //     break;
+              //   case 'MEDIAN':
+              //     let arr = []
+              //     for (var a in comValue) {
+              //       arr.push(comValue[a])
+              //     }
+              //     comResult = this.median(arr)
+              //     break;
+              //   case 'APS':
+              //     let arr0 = []
+              //     for (var a in comValue) {
+              //       arr0.push(comValue[a])
+              //     }
+              //     comResult = Math.abs(arr0[0])
+              //     break;
+              //   // case 'MAX':
+              //   //   let arr1 = []
+              //   //   for (var a in comValue) {
+              //   //     arr1.push(eval(comValue[a]))
+              //   //   }
+              //   //   comResult = Math.max(...arr1)
+              //   //   break;
+              //   // case 'MIN':
+              //   //   let arr2 = []
+              //   //   for (var a in comValue) {
+              //   //     arr2.push(eval(comValue[a]))
+              //   //   }
+              //   //   comResult = Math.median(...arr2)
+              //   //   break;
+              //   default:
+              //     let valueList = [];
+              //     item.valueList.forEach(a => {
+              //       valueList.push({
+              //         name: `${this.comparisonList.find(e=>e.value==a.c).label}${a.r+1}`,
+              //         value: 0,
+              //       })
+              //     })
+              //     for (var a in comValue) {
+              //       valueList.forEach(b => {
+              //         if (b.name == a) {
+              //           b.value = comValue[a]
+              //         }
+              //       })
+              //     }
+              //     let str = item.v.f.replace(/=/g, ' ');
+              //     valueList.forEach(b => {
+              //       str = str.replace(b.name, b.value)
+              //     })
+              //     str = str.replaceAll('MAX', 'Math.max')
+              //     str = str.replaceAll('MIN', 'Math.min')
+              //     str = str.replaceAll('锛�', ',')
+              //     try {
+              //       if(this.getInspectionValueType(item.i)==1){
+              //         comResult = eval(str)
+              //       }else{
+              //         comResult = str
+              //       }
+              //     } catch (error) {
+
+              //     }
+              //     break;
+              // }
+              try {
+                list.forEach(a => {
+                  if (a[0].r == item.r && comResult !== '') {
+                    for (var b in a) {
+                      if (a[b].c == item.c) {
+                        try{
+                          let val = parseFloat(comResult.toFixed(3))
+                          a[b].v.v = isNaN(val) ? '' : val
+                        }catch(e){
+                          a[b].v.v = comResult
+                        }
+                        break
+                      }
+                    }
+                  }
+                })
+                this.changeInput(comResult, `${id}-${item.r}-${item.c}-${pId}`) //鏀瑰彉鏈�缁堝��
+              } catch (error) {
+
+              }
             }
           }
         })
-        this.getCurrentInsProduct(pId)
+        try {
+          this.getCurrentInsProduct(pId)
+        } catch (error) {
+
+        }
       },
       getCurrentInsProduct(pId) {
         if (!this.tableList[0].insProductResult) {
@@ -1376,44 +1696,7 @@
       handleExcelMethod() {
         if (this.excelMethodList.length > 0) {
           this.excelMethodList.map(item => {
-            item.methodName = item.v.f.split('=').length > 1 && 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.replace(/[a-zA-Z]/g, "") - 1
-              c1 = this.comparisonList.find(j => j.label == end.split('')[0]).value
-              r1 = end.replace(/[a-zA-Z]/g, "") - 1
-              for (let i = Number(r0); i <= Number(r1); i++) {
-                for (let u = Number(c0); u <= Number(c1); u++) {
-                  valueList.push({
-                    r: i,
-                    c: u
-                  })
-                }
-              }
-            } else {
-              valueList = []
-              let regex = /[=\+\-\*\%\(\)\/\^\s]/g
-              let mode = item.v.f.replace(regex, ' ').split(' ');
-              mode.filter(m => m && !Number(m)).forEach(m => {
-                let r = m.replace(/[a-zA-Z]/g, "") - 1
-                let c = this.comparisonList.find(j => j.label == m.split('')[0]).value
-                valueList.push({
-                  c,
-                  r
-                })
-              })
-            }
-            item.valueList = valueList;
+            item.valueList = excelFunction.changeParameter(item.v.f);
             return item;
           })
         }
@@ -1431,6 +1714,10 @@
               // 鍋舵暟浣嶇疆鐨勫钩鍧囧��
               return (sortedArr[half - 1] + sortedArr[half]) / 2;
           }
+      },
+      getValue(v){
+        let str = v.v?v.v:(v.ct&&v.ct.s?v.ct.s.length>0&&v.ct.s[0].v:'').replaceAll('\n','<br/>')
+        return str
       },
       getInspectionValueType(id) {
         for (var a in this.currentSample.insProduct) {
@@ -1654,15 +1941,17 @@
         return
       },
       saveInsContext() {
-        this.$axios.post(this.$api.insOrderPlan.saveInsContext, {
-          param: JSON.stringify(this.param)
-        }).then(res => {
-          if (res.code == 201) {
-            this.$message.error('淇濆瓨澶辫触')
-            return
-          }
-          this.$message.success('宸蹭繚瀛�')
-        })
+        if(this.param){
+          this.$axios.post(this.$api.insOrderPlan.saveInsContext, {
+            param: JSON.stringify(this.param)
+          }).then(res => {
+            if (res.code == 201) {
+              this.$message.error('淇濆瓨澶辫触')
+              return
+            }
+            this.$message.success('宸蹭繚瀛�')
+          })
+        }
       },
       changeEquip(val, n) {
         for (let i in this.equipOptions) {
@@ -1860,6 +2149,26 @@
         }).catch(error => {
 
         })
+      },
+      /**
+       * 灏嗘暟鍊紇淇濈暀ct.fa涓�'##'鍚庣殑鎸囧畾灏忔暟浣嶆暟锛屽苟杩斿洖鏍煎紡鍖栧悗鐨勫瓧绗︿覆銆�
+       *
+       * @param v 瑕佹牸寮忓寲鐨勬暟鍊�
+       * @param ct 鍖呭惈鏍煎紡鍖栭厤缃殑瀵硅薄
+       * @param ct.fa 鏍煎紡鍖栭厤缃瓧绗︿覆锛岃嫢鍖呭惈'##'鍒欐寜鐓у叾鍚庣殑鍐呭纭畾灏忔暟浣嶆暟
+       * @returns 鏍煎紡鍖栧悗鐨勫瓧绗︿覆鎴栧師濮嬫暟鍊硷紙鑻ラ厤缃笉绗﹀悎瑕佹眰锛�
+       */
+      toFixed(v,ct){
+        if(v&&ct&&ct.fa&&ct.fa.includes('##')){
+          if(ct.fa.includes('.')){
+            let num = ct.fa.slice(4).length
+            return Number(v).toFixed(num)
+          }else{
+            return Number(v).toFixed(0)
+          }
+        }else{
+          return v
+        }
       }
     }
   }

--
Gitblit v1.9.3