tx-lims-before.git

			@@ -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}`">
			<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>
			@@ -249,52 +249,7 @@
			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',
			},
			],
			comparisonList:[],
			excelMethodList:[]
			}
			},
			@@ -305,6 +260,7 @@
			mounted() {
			this.getTypeDicts()
			this.getInsStateDicts()
			this.getComparisonList()
			},
			watch:{
			id(val){
			@@ -376,6 +332,14 @@
			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;
			},
			@@ -453,6 +417,15 @@
			count1++
			b.v.v = count1
			}
			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)
			@@ -486,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(':')){
			@@ -513,9 +536,9 @@
			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`]
			c0 = this.comparisonList.find(j=>j.label==start.split('')[0]).value
			r0 = start.split('')[1]-1
			c1 = this.comparisonList.find(j=>j['1']==end.split('')[0])[`0`]
			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++){
			@@ -532,7 +555,7 @@
			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`]
			let c = this.comparisonList.find(j=>j.label==m.split('')[0]).value
			valueList.push({c,r})
			})
			}