tx-lims-before.git

			@@ -26,6 +26,7 @@
			align-items: center;
			justify-content: center;
			flex-wrap: wrap;
			overflow-y: auto;
			}
			.tables{
			/* width: 800px; */
			@@ -131,15 +132,28 @@
			<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}`">
			<span v-if="n.v.ps===undefined \|\| n.v.ps.value!='检验值'" :style="`font-family:${n.v.ff} !important;`">{{ n.v.v}}</span>
			<el-input v-else class="table_input" v-model="n.v.v" @change="m=>changeInput(m,`${item.templateId}-${n.r}-${n.c}`)" />
			<template v-if="n.v.ps!=undefined && n.v.ps.value==='检验值'">
			<el-input v-if="item.inspectionValueType == 1" class="table_input" v-model="n.v.v" @change="m=>changeInput(m,`${item.templateId}-${n.r}-${n.c}-${n.i}`)" />
			<el-input v-else-if="item.inspectionValueType == 2" class="table_input" type="textarea" :autosize="{ minRows: 1}" v-model="n.v.v"/>
			<el-select v-else-if="item.inspectionValueType == 5" class="table_input" v-model="n.v.v">
			<el-option label="是" value="是"></el-option>
			<el-option label="否" value="否"></el-option>
			</el-select>
			<span v-else-if="item.inspectionValueType == 4" class="table_input">/</span>
			</template>
			<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>
			@@ -187,7 +201,6 @@
			</template>

			<script>
			import { number } from 'echarts';
			import ValueTable from '../../tool/value-table.vue'
			export default {
			props: ['sonLaboratory','orderId'],
			@@ -238,59 +251,9 @@
			tableList:[],
			loading: false,
			ps: {},
			param: {
			insValue:{},
			comValue: {},
			bestValue: {},
			result: {}
			},
			param: {},
			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:[]
			}
			},
			@@ -301,6 +264,7 @@
			mounted() {
			this.getTypeDicts()
			this.getInsStateDicts()
			this.getComparisonList()
			},
			watch:{
			id(val){
			@@ -316,6 +280,13 @@
			})
			this.sampleProduct = res.data.sampleProduct
			this.currentSample = this.sampleProduct[0]
			this.currentSample.insProduct.forEach(a=>{
			this.param[a.id] = {
			insValue: [],
			comValue: [],
			resValue: []
			}
			})
			if(this.currentSample.index==undefined)this.currentSample['index'] = 1
			this.loading = false
			this.handleTableData()
			@@ -327,6 +298,13 @@
			methods: {
			handleChangeSample(row, column, event){
			this.currentSample = row;
			this.currentSample.insProduct.forEach(a=>{
			this.param[a.id] = {
			insValue: [],
			comValue: [],
			resValue: []
			}
			})
			this.handleTableData()
			this.sampleVisible = false;
			this.currentKey=row.index
			@@ -372,6 +350,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;
			},
			@@ -393,13 +379,14 @@
			let dels = []
			let ids = []
			a.template.forEach(b=>{
			if(b.v.ps!=undefined&&b.v.ps.value==='检验子项'){
			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
			id: this.currentSample.insProduct[i].id,
			product: this.currentSample.insProduct[i]
			})
			break
			}
			@@ -432,6 +419,9 @@
			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
			}
			}
			}
			})
			@@ -439,7 +429,41 @@
			this.tableList.forEach(a=>{
			let arrs = []
			let set = new Set()
			let count1 = 0
			let conclusionList=[];//结论列表
			let finalList = [];//最终值列表
			conclusionList = a.template.filter(n=>n.v.ps!=undefined&&n.v.ps.value==='结论')
			finalList = a.template.filter(n=>n.v.ps!=undefined&&n.v.ps.value==='最终值')
			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 = ''
			this.param[b.i].insValue.push(b)
			}
			if (b.v.ps!=undefined&&b.v.ps.value==='计算值'){
			b.v.v = ''
			this.param[b.i].comValue.push(b)
			}
			if (b.v.ps!=undefined&&b.v.ps.value==='最终值'){
			b.v.v = ''
			if(b.i===undefined){
			for(var c in this.param){
			this.param[c].resValue.push(b)
			}
			}else{
			this.param[b.i].resValue.push(b)
			}
			}
			if (b.v.ps!=undefined&&b.v.ps.value==='结论'){
			conclusionList.forEach((n,i)=>{
			if(n.r==b.r&&n.c==b.c){
			b.v.f = `(${this.comparisonList.find(j=>j.value==(finalList[i].r-1)).label}${finalList[i].r+1})`
			}
			})
			}
			set.add(b.r)
			if(b.v.f){
			this.excelMethodList.push(b)
			@@ -470,26 +494,109 @@
			})
			a.arr = arrs
			})
			/* this.currentSample.insProduct.forEach(a=>{
			for(var i=0;i<a.param.comValue.length;i++){
			this.param[a.id].comValue[i].v.v = a.param.comValue[i].v.v
			}
			}) */
			this.handleExcelMethod()
			},
			changeInput(m,code){
			console.log(m,'code:',code,this.excelMethodList)
			let r = code.split('-')[1]
			let c = code.split('-')[2]
			let str = code.split('-')
			let r = str[1]
			let c = str[2]
			let id = str[0]
			let pId = str[3]
			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)
			if(item.methodName=='自定义方法'&&item.v.ps&&item.v.ps.value=='结论'){
			if(this.tableList.find(m=>m.id==item.i)){
			let ask = this.tableList.find(m=>m.id==item.i).ask.split('&');
			let res = Object.values(comValue)[0]
			let comp = ask.map((m,i)=>{
			if(m.includes('=')){
			return res == m.split('=')[1]
			}
			if(m.includes('≥')){
			return res >= m.split('≥')[1]
			}
			if(m.includes('≤')){
			return res <= m.split('≤')[1]
			}
			if(m.includes('<')){
			return res < m.split('<')[1]
			}
			if(m.includes('>')){
			return res > m.split('>')[1]
			}
			})
			if(comp.every(m=>m)){
			item.v.v = 1
			}else{
			item.v.v = 0
			}
			}
			}else{
			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.forEach(a=>{
			if(a[0].r == item.r){
			for(var b in a){
			if(a[b].c == item.c){
			a[b].v.v = parseFloat(comResult.toFixed(2))
			break
			}
			}
			}
			})
			this.changeInput(comResult,`${code.split('-')[0]}-${item.r}-${item.c}-${pId}`)//改变最终值
			}
			}
			})
			},
			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]:'自定义方法';
			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 = [];
			@@ -500,9 +607,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++){
			@@ -515,18 +622,19 @@
			item.valueList = valueList;
			}else{
			valueList = []
			let regex= /[\+\-\*\%\s]/g
			let regex= /[=\+\-\*\%\s]/g
			let mode = item.v.f.replace(regex, ' ').split(' ');
			mode.forEach(m=>{
			mode.filter(m=>m).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})
			})
			}
			item.valueList = valueList;
			return item;
			})
			}
			}
			},
			}
			}
			</script>