<template>
|
<BasicModal width="1200px" :height=600 v-bind="$attrs" ok-text="保存" @register="register" :title="t('导入工单料站表')"
|
@ok="handleSubmit">
|
<a-button style="position:relative;left: 100px;" @click="aoaToExcel" class="m-3"> 模板 </a-button>
|
<ImpExcel style="width: 100px; position: relative; top:-56px" @success="loadDataSuccess" dateFormat="YYYY-MM-DD">
|
<a-button class="m-3"> 导入Excel </a-button>
|
</ImpExcel>
|
|
<p style="color: red;" v-text="err"></p>
|
<a-card style="position: relative;top:-55px" :title="t('列表')" :bordered="false">
|
<!-- :columns="dtlColumns"
|
:dataSource="data" -->
|
<PageWrapper dense contentClass="flex">
|
<BasicTable :maxHeight="200" v-for="(table, index) in tableListRef" :key="index" :title="table.title" :columns="table.columns"
|
:dataSource="table.dataSource" />
|
</PageWrapper>
|
</a-card>
|
</BasicModal>
|
</template>
|
<script lang="ts">
|
import { defineComponent, ref, nextTick, unref,h } from 'vue';
|
import { Tag ,Tooltip} from 'ant-design-vue';
|
import { BasicModal, useModalInner } from '/@/components/Modal';
|
import { BasicForm, FormSchema, useForm } from '/@/components/Form/index';
|
import { SaveSmttable, ExportTable,SaveExportTable } from '/@/api/tigerapi/mes/smt/smttable';
|
import { useI18n } from '/@/hooks/web/useI18n';
|
import { aoaToSheetXlsx } from '/@/components/Excel';
|
import { useMessage } from '/@/hooks/web/useMessage';
|
import { useLocale } from '/@/locales/useLocale';
|
import { PageWrapper } from '/@/components/Page';
|
import { ImpExcel, ExcelData } from '/@/components/Excel';
|
import { BasicTable, BasicColumn } from '/@/components/Table';
|
|
const { getLocale } = useLocale();
|
|
const { t } = useI18n('');
|
const { createMessage,createConfirm } = useMessage();
|
export default defineComponent({
|
components: { BasicModal, BasicForm, PageWrapper, ImpExcel,BasicTable },
|
props: {
|
userData: { type: Object },
|
},
|
emit: ['success', 'register'],
|
setup(_, { emit }) {
|
const modelRef = ref({});
|
const tableListRef = ref<
|
{
|
title: string;
|
columns?: any[];
|
dataSource?: any[];
|
}[]
|
>([]);
|
|
const tableListRef2 = ref<
|
{
|
title: string;
|
columns?: any[];
|
dataSource?: any[];
|
}[]
|
>([]);
|
|
const [register, { setModalProps, closeModal }] = useModalInner((data) => {
|
setModalProps({ confirmLoading: false });
|
tableListRef.value = [];
|
});
|
var err=ref('');
|
async function loadDataSuccess(excelDataList: ExcelData[]) {
|
tableListRef.value = [];
|
|
for (const excelData of excelDataList) {
|
const {
|
header,
|
results,
|
meta: { sheetName },
|
} = excelData;
|
const columns: BasicColumn[] = [];
|
columns.push({title:"处理方式",dataIndex:"处理方式",customRender: ({ record }) => {
|
const status = record.处理方式;
|
var text = '';
|
var color = '';
|
if(status=='数据异常'){
|
color='red'
|
text=status
|
}else if(status=='修改'){
|
color='yellow'
|
text=status
|
}
|
else{
|
text=status
|
}
|
return h(Tooltip, { title: 'xxxxxx' }, () => h(Tag, { color: color }, () => text));
|
},});
|
columns.push({title:'原因',dataIndex:'原因',width:300,resizable:true})
|
for (const title of header) {
|
columns.push({ title, dataIndex: title });
|
}
|
tableListRef.value.push({ title: sheetName, dataSource: results, columns });
|
|
}
|
console.log('console.log(tableListRef.value);',tableListRef.value);
|
var res=await ExportTable(tableListRef.value)
|
if(res.IsSuccessed){
|
tableListRef.value[0].dataSource=res.Data
|
err.value='';
|
}else{
|
tableListRef.value = [];
|
createMessage.error('导入失败'+res.Message);
|
err.value=res.Message;
|
}
|
|
}
|
|
// function handleVisibleChange(v) {
|
// v && props.userData && nextTick(() => onDataReceive(props.userData));
|
// }
|
//导出
|
function aoaToExcel() {
|
const arrHeader = ["关联工单号","产品编码","物料编码","替代料","单位","单位用量","产线编码",
|
"贴片机编码","贴片机编码","钢网编码","站位号","贴片位置","飞达编码","飞达类型","加工面","上料顺序",
|
"创建人","创建时间"];
|
aoaToSheetXlsx({
|
data: '',
|
header: arrHeader,
|
filename: '工单料站表信息.xlsx',
|
});
|
}
|
async function handleSubmit() {
|
try {
|
const values = tableListRef.value;
|
setModalProps({ confirmLoading: true });
|
// TODO custom api
|
//添加锡膏胶水记录
|
createConfirm({
|
iconType: 'warning',
|
title: () => h('span', t('导入料站表信息')),
|
content: () => h('span', t('确认有修改的数据是否正确，有异常的数据无法导入')),
|
onOk: async () => {
|
const apiAction = SaveExportTable(tableListRef.value);
|
apiAction.then((action) => {
|
if (action) {
|
if (action.IsSuccessed) {
|
closeModal();
|
createMessage.success(t('导入成功'));
|
emit('success', {
|
isUpdate: unref(false),
|
values: { ...values, id: 0 },
|
});
|
}
|
} else {
|
createMessage.error(t('导入失败,代码已使用'));
|
}
|
});
|
}
|
});
|
|
} finally {
|
setModalProps({ confirmLoading: false });
|
}
|
}
|
|
return { register, model: modelRef, handleSubmit, loadDataSuccess, tableListRef,err,t,aoaToExcel };
|
},
|
});
|
</script>
|
