<script setup>
|
|
import request from "@/utils/request"
|
import {ElDatePicker, ElMessage} from "element-plus"
|
import {nextTick, onMounted, onUnmounted, reactive, ref, watch} from "vue"
|
import {Search} from "@element-plus/icons-vue"
|
import {useRoute, useRouter} from 'vue-router'
|
import {changeFilterEvent, filterChanged} from "@/hook"
|
|
import { useI18n } from 'vue-i18n'
|
import footSum from "@/hook/footSum";
|
//语言获取
|
const { t } = useI18n()
|
let router=useRouter()
|
const route = useRoute()
|
|
let props = defineProps({
|
orderId:null
|
})
|
onMounted(()=>{
|
if(props.orderId===null || props.orderId===undefined || props.orderId===''){
|
|
}else{
|
form.orderId = props.orderId
|
getWorkOrder()
|
}
|
if(route.query.orderId===null || route.query.orderId===undefined || route.query.orderId===''){
|
|
}else {
|
form.orderId = route.query.orderId
|
getWorkOrder()
|
}
|
|
})
|
|
|
//表尾求和
|
const sumNum = (list, field) => {
|
let count = 0
|
list.forEach(item => {
|
count += Number(item[field])
|
})
|
return count.toFixed(2)
|
}
|
|
|
//筛选条件，有外键需要先定义明细里面的数据
|
let filterData = ref({
|
order: {
|
project: ''
|
},
|
orderDetail: {
|
productId: '',
|
productName: '',
|
computeGrossArea: '',
|
processingNote: '',
|
}
|
})
|
|
|
//需要合并的列
|
let column = [1,3,8]
|
//点击查询
|
const getWorkOrder = () => {
|
gridOptions.columns = gridOptions.columns.slice(0, 11); //清除动态生成的列重新查询
|
request.post(`/report/processCardProgressReport/${form.orderId}`, column).then((res) => {
|
if (res.code == 200) {
|
if (res.data.data.length === 0) {
|
ElMessage.warning(t('report.noDataFoundForThisOrder'))
|
return
|
}
|
|
// 动态添加列
|
res.data.title.forEach((item, index) => {
|
let column = {
|
slots: { default: 'quantitySum' },
|
width: 150,
|
title: item.process,
|
field: `dynamicColumn${index}` // 为动态列添加唯一的 field
|
}
|
gridOptions.columns.push(column)
|
})
|
res.data.data.forEach(item => {
|
item.reportWorkQuantity=JSON.parse(item.reportWorkQuantity)
|
item.reportWorkQuantityCount=JSON.parse(item.reportWorkQuantityCount)
|
item.reportWorkQuantityShow=JSON.parse(item.reportWorkQuantityShow)
|
})
|
mergeCells.value = res.data.mergeCell
|
xGrid.value.loadData(res.data.data)
|
} else {
|
ElMessage.warning(res.msg)
|
}
|
})
|
}
|
|
const footSumDynamic = (data, columnTitle) => {
|
let sum = 0;
|
data.forEach(item => {
|
const value = Number(item.reportWorkQuantity[columnTitle]) || 0; // 从 reportWorkQuantity 中提取值并转换为数字
|
sum += value;
|
});
|
return sum.toFixed(2);
|
}
|
|
const quantitySum = ( row,column )=>{
|
const reportWorkQuantityCount = row.reportWorkQuantityCount[column.title] || ''
|
const reportWorkQuantityShow = row.reportWorkQuantityShow[column.title] || ''
|
if(reportWorkQuantityShow === reportWorkQuantityCount ){
|
return reportWorkQuantityShow
|
}
|
|
return (reportWorkQuantityShow
|
+'('
|
+reportWorkQuantityCount
|
+')' )
|
}
|
|
|
/*后端返回结果多层嵌套展示*/
|
const hasDecimal = (value) => {
|
const regex = /\./; // 定义正则表达式，查找小数点
|
return regex.test(value); // 返回true/false
|
}
|
|
const xGrid = ref()
|
const gridOptions = reactive({
|
border: "full",//表格加边框
|
keepSource: true,//保持源数据
|
align: 'center',//文字居中
|
stripe:true,//斑马纹
|
rowConfig: {isCurrent: true, isHover: true,height: 30},//鼠标移动或选择高亮
|
id: 'ProcessCardProgress',
|
showFooter: true,//显示脚
|
printConfig: {},
|
importConfig: {},
|
exportConfig: {},
|
scrollY:{ enabled: true },//开启虚拟滚动
|
showOverflow:true,
|
columnConfig: {
|
resizable: true,
|
useKey: true
|
},
|
filterConfig: { //筛选配置项
|
// remote: true
|
},
|
customConfig: {
|
storage: true
|
},
|
editConfig: {
|
trigger: 'click',
|
mode: 'row',
|
showStatus: true
|
},//表头参数
|
columns : [
|
// {type:'expand',fixed:"left",slots: { content:'content' },width: 50},
|
{field: 'product_name', width: 150,
|
title: t('order.product'),
|
filters: [{data: ''}],
|
slots: {filter: 'num1_filter'},
|
filterMethod: filterChanged},
|
{field: 'glass_child',width: 130, title: t('reportingWorks.glassChild') ,filters: [{data: ''}],
|
slots: {filter: 'num1_filter'},
|
filterMethod: filterChanged},
|
{field: 'order_type', width: 120,title: t('order.orderType'),filters: [{data: ''}],
|
slots: {filter: 'num1_filter'},
|
filterMethod: filterChanged},
|
{field: 'process_id',width: 150, title: t('processCard.processId'),filters: [{data: ''}],
|
slots: {filter: 'num1_filter'},
|
filterMethod: filterChanged},
|
{field: 'order_number', width: 100,title: t('order.OrderNum'),showOverflow:"ellipsis",filters: [{data: ''}],
|
slots: {filter: 'num1_filter'},
|
filterMethod: filterChanged},
|
{field: 'glassNumber', width: 110,title: t('reportingWorks.glassNumber'),showOverflow:"ellipsis",filters: [{data: ''}],
|
slots: {filter: 'num1_filter'},
|
filterMethod: filterChanged},
|
{field: 'technology_number', width: 110,title: t('processCard.technologyNumber'),showOverflow:"ellipsis",filters: [{data: ''}],
|
slots: {filter: 'num1_filter'},
|
filterMethod: filterChanged},
|
{field: 'quantity', width: 90,title: t('order.quantity')},
|
{field: 'grossArea', width: 90,title: t('order.area')},
|
{field: 'broken_num',width: 90, title: t('reportingWorks.quantityBroken')},
|
// {field: 'shippedQuantity',width: 120, title: t('report.shippedQuantity')},
|
{field: 'Storage',width: 120, title: t('report.inventoryNum')},
|
{field: 'StorageAreaShow',width: 120, title: t('report.inventoryArea')},
|
],
|
|
toolbarConfig: {
|
// buttons: [{
|
//
|
// }],
|
// import: false,
|
// export: true,
|
// print: true,
|
zoom: true,
|
custom: true
|
},
|
data: [
|
],//table body实际数据
|
//脚部求和
|
footerMethod ({ columns, data }) {
|
return [
|
columns.map((column, columnIndex) => {
|
if (columnIndex === 0) {
|
return t('basicData.total')
|
}
|
const List = ["quantity", "broken_num", "inventory", "inventoryArea","gross_area"]; // 静态列的求和
|
if (List.includes(column.field)) {
|
return footSum(data, column.field)
|
}
|
// 动态列的求和
|
if (column.field && column.field.startsWith('dynamicColumn')) {
|
return footSumDynamic(data, column.title)
|
}
|
return ''
|
})
|
]
|
}
|
})
|
|
|
|
const form = reactive({
|
orderId: '',
|
|
})
|
|
const mergeCells = ref([
|
|
])
|
|
|
|
</script>
|
|
<template>
|
<div style="width: 100%;height: 100%">
|
<div class="head">
|
<el-input
|
v-model="form.orderId"
|
clearable
|
:disabled="props.orderId"
|
:placeholder="$t('order.orderId')"
|
style="width: 140px"></el-input>
|
|
<el-button
|
:disabled="props.orderId"
|
@click="getWorkOrder"
|
id="select"
|
type="primary" :icon="Search">{{$t('basicData.search')}}
|
|
</el-button>
|
|
</div>
|
<div class="main-table">
|
<vxe-grid
|
height="100%"
|
class="mytable-scrollbar"
|
ref="xGrid"
|
v-bind="gridOptions"
|
:merge-cells="mergeCells"
|
|
>
|
<!-- @toolbar-button-click="toolbarButtonClickEvent"-->
|
<!-- 下拉显示所有信息插槽-->
|
<template #content="{ row }">
|
<ul class="expand-wrapper">
|
<li v-for="(item,index) in gridOptions.columns" v-show="item.field!=undefined ">
|
<span style="font-weight: bold">{{item.title+': '}}</span>
|
<span>{{ row[item.field] }}</span>
|
</li>
|
</ul>
|
</template>
|
|
|
|
<template #num1_filter="{ column, $panel }">
|
<div>
|
<div v-for="(option, index) in column.filters" :key="index">
|
<input v-model="option.data"
|
type="text"
|
@keyup.enter.native="$panel.confirmFilter()"
|
@input="changeFilterEvent($event, option, $panel)"/>
|
</div>
|
</div>
|
</template>
|
|
<template #quantitySum="{ row,column }">
|
<span>{{ quantitySum(row,column) }} </span>
|
</template>
|
|
|
</vxe-grid>
|
</div>
|
</div>
|
</template>
|
|
<style scoped>
|
.head{
|
width: 100%;
|
height: 35px;
|
}
|
|
.main-table{
|
width: 100%;
|
height: calc(100% - 35px);
|
}
|
</style>
|
