| New file |
| | |
|---|
| | | <script setup> |
|---|
| | | |
|---|
| | | import {reactive, ref} from "vue"; |
|---|
| | | import {useRouter} from 'vue-router' |
|---|
| | | import request from "@/utils/request"; |
|---|
| | | import deepClone from "@/utils/deepClone"; |
|---|
| | | import {ElDatePicker, ElMessage} from "element-plus"; |
|---|
| | | import {useI18n} from 'vue-i18n' |
|---|
| | | import {changeFilterEvent, filterChanged} from "@/hook" |
|---|
| | | import footSum from "@/hook/footSum" |
|---|
| | | import dayjs from 'dayjs' |
|---|
| | | //语言获取 |
|---|
| | | const {t} = useI18n() |
|---|
| | | let router = useRouter() |
|---|
| | | let filterData = ref({}) |
|---|
| | | //提交的表单 |
|---|
| | | const form = reactive({ |
|---|
| | | date1: '', |
|---|
| | | orderId: '', |
|---|
| | | project: '' |
|---|
| | | }) |
|---|
| | | |
|---|
| | | //工序 |
|---|
| | | const value = ref('磨边') |
|---|
| | | |
|---|
| | | //表尾求和 |
|---|
| | | const sumNum = (list, field) => { |
|---|
| | | let count = 0 |
|---|
| | | list.forEach(item => { |
|---|
| | | count += Number(item[field]) |
|---|
| | | }) |
|---|
| | | return count.toFixed(2) |
|---|
| | | } |
|---|
| | | |
|---|
| | | //定义滚动条高度 |
|---|
| | | let scrollTop = ref(null) |
|---|
| | | let scrollHeight = ref(null) |
|---|
| | | let clientHeight = ref(null) |
|---|
| | | const scrollEvnt = (row) => { |
|---|
| | | // 内容高度 |
|---|
| | | scrollTop.value = row.$event.target.scrollTop |
|---|
| | | scrollHeight.value = row.$event.target.scrollHeight |
|---|
| | | clientHeight.value = row.$event.target.clientHeight |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | //定义页面总页数 |
|---|
| | | let pageTotal = ref('') |
|---|
| | | //定义数据返回结果 |
|---|
| | | let produceList = ref([]) |
|---|
| | | //定义当前页数 |
|---|
| | | let pageNum = ref(1) |
|---|
| | | let pageState = null |
|---|
| | | |
|---|
| | | //获取七天前到当前时间 |
|---|
| | | function getNowTime() { |
|---|
| | | const pad = (n) => n.toString().padStart(2, '0'); |
|---|
| | | |
|---|
| | | const formatDate = (date) => { |
|---|
| | | const year = date.getFullYear(); |
|---|
| | | const month = pad(date.getMonth() + 1); |
|---|
| | | const day = pad(date.getDate()); |
|---|
| | | return `${year}-${month}-${day} 08:00:00`; |
|---|
| | | }; |
|---|
| | | |
|---|
| | | const now = new Date(); |
|---|
| | | const startDate = new Date(now.getTime() - 3600 * 1000 * 24 * 3); // 三天前 |
|---|
| | | const start = formatDate(startDate); |
|---|
| | | const end = formatDate(now); |
|---|
| | | |
|---|
| | | return [start, end]; |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | //第一次加载获取近七天时间和默认状态 |
|---|
| | | form.date1 = getNowTime() |
|---|
| | | let startTime = form.date1[0] |
|---|
| | | let endTime = form.date1[1] |
|---|
| | | let date = new Date(endTime); // 将日期字符串转为 Date 对象 |
|---|
| | | |
|---|
| | | // 使用 setDate 方法加一天 |
|---|
| | | date.setDate(date.getDate() + 1); |
|---|
| | | const pad = (n) => n.toString().padStart(2, '0'); |
|---|
| | | let year = date.getFullYear(); |
|---|
| | | let month = pad(date.getMonth() + 1); |
|---|
| | | let day = pad(date.getDate()); |
|---|
| | | let newEndTime = `${year}-${month}-${day} 08:00:00`; |
|---|
| | | let selectProcesses = value.value |
|---|
| | | let total = reactive({ |
|---|
| | | pageTotal: 0, |
|---|
| | | dataTotal: 0, |
|---|
| | | pageSize: 100 |
|---|
| | | }) |
|---|
| | | //定义接收加载表头下拉数据 |
|---|
| | | const titleSelectJson = ref({ |
|---|
| | | processType: [], |
|---|
| | | }) |
|---|
| | | //第一次加载数据 |
|---|
| | | request.post(`/report/yieldProcess/${startTime}/${newEndTime}`, filterData.value).then((res) => { |
|---|
| | | |
|---|
| | | if (res.code == 200) { |
|---|
| | | // total.dataTotal = res.data.total.total*1 |
|---|
| | | // total.pageTotal= res.data.total.pageTotal |
|---|
| | | // pageTotal.value = res.data.total |
|---|
| | | produceList = produceList.value.concat(deepClone(res.data.data)) |
|---|
| | | titleSelectJson.value.processType = res.data.process |
|---|
| | | xGrid.value.reloadData(produceList) |
|---|
| | | gridOptions.loading = false |
|---|
| | | } else { |
|---|
| | | ElMessage.warning(res.msg) |
|---|
| | | } |
|---|
| | | }) |
|---|
| | | |
|---|
| | | //页脚翻页查询 |
|---|
| | | const selectPageList = () => { |
|---|
| | | let startTime = form.date1[0] |
|---|
| | | let endTime = form.date1[1] |
|---|
| | | |
|---|
| | | request.post(`/report/yield/${pageNum.value}/${total.pageSize}/${startTime}/${endTime}/${inputVal}`, filterData.value).then((res) => { |
|---|
| | | if (res.code == 200) { |
|---|
| | | |
|---|
| | | |
|---|
| | | produceList = deepClone(res.data.data) |
|---|
| | | xGrid.value.reloadData(produceList) |
|---|
| | | } else { |
|---|
| | | ElMessage.warning(res.msg) |
|---|
| | | } |
|---|
| | | }) |
|---|
| | | } |
|---|
| | | |
|---|
| | | //点击查询 |
|---|
| | | const getWorkOrder = () => { |
|---|
| | | gridOptions.loading = true |
|---|
| | | // 原始 form.date1 是日期对象数组 |
|---|
| | | const rawStart = new Date(form.date1[0]); |
|---|
| | | const rawEnd = new Date(form.date1[1]); |
|---|
| | | // 如果时间部分是 00:00，则设置为 08:00 |
|---|
| | | if (rawStart.getHours() === 8 || rawStart.getHours() === 0) { |
|---|
| | | rawStart.setHours(8, 0, 0, 0); |
|---|
| | | } |
|---|
| | | if (rawEnd.getHours() === 8 || rawEnd.getHours() === 0) { |
|---|
| | | rawEnd.setHours(8, 0, 0, 0); |
|---|
| | | } |
|---|
| | | |
|---|
| | | const startTime = formatDateTime(rawStart); |
|---|
| | | const endPlusOne = new Date(rawEnd); |
|---|
| | | endPlusOne.setDate(endPlusOne.getDate()); |
|---|
| | | const newEndTime = formatDateTime(endPlusOne); |
|---|
| | | form.date1 = [startTime, newEndTime]; |
|---|
| | | let selectProcesses = value.value |
|---|
| | | request.post(`/report/yieldProcess/${startTime}/${newEndTime}`, filterData.value).then((res) => { |
|---|
| | | |
|---|
| | | if (res.code == 200) { |
|---|
| | | // total.dataTotal = res.data.total.total*1 |
|---|
| | | // total.pageTotal= res.data.total.pageTotal |
|---|
| | | // pageTotal.value = res.data.total |
|---|
| | | produceList = deepClone(res.data.data) |
|---|
| | | xGrid.value.reloadData(produceList) |
|---|
| | | gridOptions.loading = false |
|---|
| | | } else { |
|---|
| | | ElMessage.warning(res.msg) |
|---|
| | | } |
|---|
| | | }) |
|---|
| | | } |
|---|
| | | |
|---|
| | | const formatDateTime = (date) => { |
|---|
| | | const year = date.getFullYear(); |
|---|
| | | const month = pad(date.getMonth() + 1); |
|---|
| | | const day = pad(date.getDate()); |
|---|
| | | const hour = pad(date.getHours()); |
|---|
| | | const minute = pad(date.getMinutes()); |
|---|
| | | return `${year}-${month}-${day} ${hour}:${minute}:00`; |
|---|
| | | }; |
|---|
| | | |
|---|
| | | //页脚跳转 |
|---|
| | | const handlePageChange = ({currentPage, pageSize}) => { |
|---|
| | | pageNum.value = currentPage |
|---|
| | | total.pageTotal = pageSize |
|---|
| | | selectPageList() |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | /*使用筛选，后端获取数据*/ |
|---|
| | | // const changeFilterEvent = (event, option, $panel,) => { |
|---|
| | | // // 手动触发筛选 |
|---|
| | | // $panel.changeOption(event, !!option.data, option) |
|---|
| | | // } |
|---|
| | | |
|---|
| | | // function filterChanged(column){ |
|---|
| | | // //gridOptions.loading=true |
|---|
| | | // //筛选条件发生变化条件发生变化 |
|---|
| | | // let value = column.datas[0]!=undefined?column.datas[0]:'' |
|---|
| | | // value = value.trim() |
|---|
| | | // //判断是否存在外键 |
|---|
| | | // if (column.property.indexOf('.')>-1){ |
|---|
| | | // const columnArr = column.property.split('.') |
|---|
| | | // filterData.value[columnArr[0]] = { |
|---|
| | | // [columnArr[1]]:value |
|---|
| | | // } |
|---|
| | | // }else{ |
|---|
| | | // filterData.value[column.property] = value |
|---|
| | | // } |
|---|
| | | // |
|---|
| | | // gridOptions.loading = true |
|---|
| | | // |
|---|
| | | // } |
|---|
| | | |
|---|
| | | /*后端返回结果多层嵌套展示*/ |
|---|
| | | 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: 'Yield', |
|---|
| | | 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}, |
|---|
| | | {type: 'seq', fixed: "left", title: t('basicData.Number'), width: 50}, |
|---|
| | | { |
|---|
| | | field: 'process', title: t('report.workingProcedure'), filters: [{data: ''}], |
|---|
| | | slots: {filter: 'num1_filter'}, |
|---|
| | | filterMethod: filterChanged |
|---|
| | | }, |
|---|
| | | {field: 'completedQuantity', title: t('reportingWorks.completedQuantity')}, |
|---|
| | | {field: 'completedArea', title: t('reportingWorks.completedArea')}, |
|---|
| | | {field: 'breakageQuantity', title: t('reportingWorks.quantityBroken')}, |
|---|
| | | {field: 'breakageArea', title: t('reportingWorks.wornArea')}, |
|---|
| | | {field: 'finished', title: t('report.finished')}, |
|---|
| | | ],//表头按钮 |
|---|
| | | |
|---|
| | | toolbarConfig: { |
|---|
| | | // buttons: [{ |
|---|
| | | // |
|---|
| | | // }], |
|---|
| | | slots: { |
|---|
| | | tools: 'toolbar_buttons' |
|---|
| | | }, |
|---|
| | | zoom: true, |
|---|
| | | custom: true |
|---|
| | | }, |
|---|
| | | data: [],//table body实际数据 |
|---|
| | | //脚部求和 |
|---|
| | | footerMethod ({ columns, data }) {//页脚函数 |
|---|
| | | return[ |
|---|
| | | columns.map((column, columnIndex) => { |
|---|
| | | if (columnIndex === 0) { |
|---|
| | | return t('basicData.total') |
|---|
| | | } |
|---|
| | | const List = ["completedQuantity",'completedArea','breakageQuantity','breakageArea'] |
|---|
| | | if (List.includes(column.field)) { |
|---|
| | | return footSum(data, column.field) |
|---|
| | | } |
|---|
| | | return '' |
|---|
| | | }) |
|---|
| | | ] |
|---|
| | | } |
|---|
| | | |
|---|
| | | }) |
|---|
| | | |
|---|
| | | function exportExcel(url, fileName,date) { |
|---|
| | | let processes = value.value |
|---|
| | | |
|---|
| | | if(date===null){ |
|---|
| | | ElMessage.warning(t('report.pleaseSelectADateFirst')) |
|---|
| | | return |
|---|
| | | } |
|---|
| | | |
|---|
| | | if(processes===null){ |
|---|
| | | ElMessage.warning(t('report.pleaseSelectAProcessFirst')) |
|---|
| | | return |
|---|
| | | } |
|---|
| | | |
|---|
| | | const date1 = new Date(date[0]); |
|---|
| | | const date2 = new Date(date[1]); |
|---|
| | | const timeDiff = Math.abs(date2.getTime() - date1.getTime()); |
|---|
| | | const daysDiff = timeDiff / (1000 * 3600 * 24); |
|---|
| | | if(Math.floor(daysDiff)>180){ |
|---|
| | | ElMessage.warning(t('report.theFilteringTimeForExportCannotExceed180Days')) |
|---|
| | | return |
|---|
| | | } |
|---|
| | | let dataMp = ref({ |
|---|
| | | date: date, |
|---|
| | | processes: processes, |
|---|
| | | }) |
|---|
| | | request.post(url,dataMp.value,{responseType :'blob'}).then(res => { |
|---|
| | | const blob = new Blob([res]) |
|---|
| | | if ('download' in document.createElement('a')) { // 非IE下载 |
|---|
| | | const elink = document.createElement('a') |
|---|
| | | elink.download = `${fileName}.xlsx` |
|---|
| | | elink.style.display = 'none' |
|---|
| | | elink.href = URL.createObjectURL(blob) |
|---|
| | | document.body.appendChild(elink) |
|---|
| | | elink.click() |
|---|
| | | URL.revokeObjectURL(elink.href) // 释放URL 对象 |
|---|
| | | document.body.removeChild(elink) |
|---|
| | | } else { // IE10+下载 |
|---|
| | | navigator.msSaveBlob(blob, fileName) |
|---|
| | | } |
|---|
| | | |
|---|
| | | }) |
|---|
| | | } |
|---|
| | | </script> |
|---|
| | | |
|---|
| | | <template> |
|---|
| | | <div style="width: 100%;height: 100%"> |
|---|
| | | <div class="head"> |
|---|
| | | <el-date-picker |
|---|
| | | v-model="form.date1" |
|---|
| | | :start-placeholder="$t('basicData.startDate')" |
|---|
| | | :end-placeholder="$t('basicData.endDate')" |
|---|
| | | format="YYYY/MM/DD HH:mm" |
|---|
| | | style="width: 350px" |
|---|
| | | type="daterange" |
|---|
| | | value-format="YYYY/MM/DD HH:mm" |
|---|
| | | /> |
|---|
| | | |
|---|
| | | |
|---|
| | | <el-button type="primary" @click="getWorkOrder">{{$t('basicData.search')}}</el-button> |
|---|
| | | |
|---|
| | | </div> |
|---|
| | | <div class="main-table"> |
|---|
| | | <vxe-grid |
|---|
| | | ref="xGrid" |
|---|
| | | class="mytable-scrollbar" |
|---|
| | | height="100%" |
|---|
| | | v-bind="gridOptions" |
|---|
| | | |
|---|
| | | > |
|---|
| | | <!-- @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 #toolbar_buttons> |
|---|
| | | <vxe-button style="margin-right: 0.5rem" |
|---|
| | | @click="exportExcel('/report/exportYield', |
|---|
| | | t('report.yieldReport'), |
|---|
| | | form.date1)"> |
|---|
| | | {{t('basicData.export')}}</vxe-button> |
|---|
| | | </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> |
|---|
| | | |
|---|
| | | |
|---|
| | | </vxe-grid> |
|---|
| | | </div> |
|---|
| | | </div> |
|---|
| | | </template> |
|---|
| | | |
|---|
| | | <style scoped> |
|---|
| | | .head{ |
|---|
| | | width: 100%; |
|---|
| | | height: 35px; |
|---|
| | | } |
|---|
| | | |
|---|
| | | .main-table{ |
|---|
| | | width: 100%; |
|---|
| | | height: calc(100% - 35px); |
|---|
| | | } |
|---|
| | | </style> |
|---|
