| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270 |
- <template>
- <basic-container>
- <avue-crud
- v-bind="bindVal"
- v-on="onEvent"
- v-model="form"
- :page.sync="page"
- :before-open="handleBeforeOpen"
- :permission="permissionList"
- :header-cell-style="headerCellStyle"
- >
- <template slot="menuLeft">
- <el-button
- type="danger"
- size="small"
- icon="el-icon-delete"
- plain
- @click="handleDelete"
- >
- 清除工时数据
- </el-button>
- <el-button
- type="success"
- size="small"
- plain
- icon="el-icon-upload2"
- @click="handleImport"
- >
- 导入
- </el-button>
- <el-button
- type="warning"
- size="small"
- plain
- icon="el-icon-download"
- @click="handleExport"
- >
- 导出
- </el-button>
- <!-- <print-table-btn @click="printTable" /> -->
-
- <div style="display: flex; align-items: center;">
- <year-month-select v-model="params.yearAndMonth" :showAllYear="false"></year-month-select>
- </div>
- </template>
- <!-- <template slot="monthlyHoursSearch">
- <div style="display: flex; align-items: center;">
- <span>使用工时/小时:</span>
- <avue-input-number v-model="params.monthlyHoursStart" :min="0" style="width: 100px !important;"></avue-input-number>
- <span style="width: 20px; text-align: center;">至</span>
- <avue-input-number v-model="params.monthlyHoursEnd" :min="0" style="width: 100px !important;"></avue-input-number>
- </div>
- </template> -->
-
- </avue-crud>
- <upload-excel-dialog ref="uploadExcelDialog" :uploadAfter="uploadAfter"/>
- <WideTablePrinter
- ref="printWideTable"
- :columns="wideTableColumns"
- :data="data"
- :print-title="printTitle"
- :rows-per-page="30"
- :default-landscape="true"
- />
- </basic-container>
- </template>
- <script>
- import YearMonthSelect from "@/components/year-month-select";
- import UploadExcelDialog from "@/components/upload-excel-dialog";
- import {exportBlob} from "@/api/common";
- import {getToken} from "@/util/auth";
- import {downloadXls} from "@/util/util";
- import { deepClone, getMonthDatesWithMarkers } from "@/util/util";
- import moment from "moment";
- import ChineseHoliday from "@chnlib/chinese-holiday";
- export default window.$crudCommon({
- components: {
- YearMonthSelect,
- UploadExcelDialog,
- },
- data() {
- return {
- params: {
- yearAndMonth: moment(new Date()).format('YYYYMM'),
- },
- defaultColumns: [],
- oldMonthData: [],
- wideTableColumns: [],
- printTitle: "",
- };
- },
- watch: {
- 'params.yearAndMonth'(newVal) {
- this.refreshTableCol(newVal);
- this.page.currentPage = 1;
- this.getList(this.page);
- }
- },
- async created() {
- this.defaultColumns = deepClone(this.option.column);
- this.refreshTableCol(this.params.yearAndMonth);
- },
- beforeDestroy() {
- this.option.column = deepClone(this.defaultColumns);
- },
- methods: {
- handleBeforeOpen(done, type) {
- this.oldMonthData = this.form.dailyAttendances || [];
- done();
- },
- refreshTableCol(yearAndMonth) {
- let yearMonth = moment(yearAndMonth).format("YYYY-MM").split("-");
- const monthDays = getMonthDatesWithMarkers(Number(yearMonth[0]), Number(yearMonth[1]));
- let newColumns = deepClone(this.defaultColumns);
- monthDays.forEach(item => {
- let col = {
- prop: moment(item.dateString).format('yyyyMMDD'),
- label: item.dayName + "" + item.day.toString(),
- type: 'number',
- precision: 1,
- min: 0,
- width: 45,
- align: 'center',
- isWorkDay: ChineseHoliday.isWorkday(item.dateString),
- showOverflowTooltip: true,
- };
- if (!ChineseHoliday.isWorkday(item.dateString)) {
- col.labelClassName = 'red';
- col.labelClassName = 'red';
- }
- newColumns.push(col);
- });
- // newColumns.push({
- // prop: "monthlyHours",
- // label: "研发出勤/小时",
- // type: 'number',
- // precision: 1,
- // min: 0,
- // width: 70,
- // align: 'center',
- // showOverflowTooltip: true,
- // display: false,
- // search: true,
- // }, {
- // prop: "monthlyDays",
- // label: "研发出勤/天",
- // type: 'number',
- // precision: 1,
- // min: 0,
- // width: 70,
- // align: 'center',
- // showOverflowTooltip: true,
- // display: false,
- // });
- this.option.column = newColumns;
- },
- handleImport() {
- let excelParams = { yearAndMonth: this.params.yearAndMonth };
- this.$refs.uploadExcelDialog.open('/api/kd-scientific/xm/technician/hours/import', excelParams);
- },
- uploadAfter() {
- this.page.currentPage = 1;
- this.getList(this.page);
- },
- getFormData() {
- const newFormData = { ...this.form, yearAndMonth: this.params.yearAndMonth };
- let dailyAttendances = [];
- let _oldMonthData = this.oldMonthData;
- Object.keys(this.form).forEach(key => {
- if (key.indexOf(this.params.yearAndMonth) > -1) {
- let oldObj = _oldMonthData.find(old => old.workDate == key) || {};
- if (this.form[key] || oldObj.workHours || oldObj.workHours === 0) {
- let workHours = this.form[key];
- if (workHours === undefined || workHours === null || workHours === '') {
- workHours = null;
- }
- dailyAttendances.push({
- workDate: key,
- workHours
- });
- }
- delete newFormData[key];
- }
- });
- // 获取最新修改过的数据
- let updatedMonthData = [];
- dailyAttendances.forEach(item => {
- let oldObj = _oldMonthData.find(old => item.workDate === old.workDate);
- if (!!oldObj && item.workHours !== oldObj.workHours) {
- updatedMonthData.push(item);
- } else if (!oldObj) {
- updatedMonthData.push(item);
- }
- })
- newFormData.dailyAttendances = updatedMonthData;
- return newFormData;
- },
- getDelParams(row) {
- return { yearAndMonth: this.params.yearAndMonth, xmAndUnicodeList: [{ xmId: row.xmId, unicode: row.unicode }] };
- },
- getBatchDelParams() {
- let xmAndUnicodeList = [];
- this.data.forEach(item => {
- if (this.ids.indexOf(item.id) > -1) {
- xmAndUnicodeList.push({ xmId: item.xmId, unicode: item.unicode });
- }
- });
- return { yearAndMonth: this.params.yearAndMonth, xmAndUnicodeList };
- },
- handleExport() {
- exportBlob(`/api/kd-scientific/xm/technician/hours/export?${this.website.tokenHeader}=${getToken()}`, this.params).then(res => {
- downloadXls(res.data, `${this.params.yearAndMonth}研发人员工时记录表.xlsx`);
- });
- },
- /**
- * 打印表格
- * @param isLandscape 是否横向打印
- */
- printTable(isLandscape) {
- this.wideTableColumns = this.$refs.crud.columnOption;
- this.printTitle = `${this.params.yearAndMonth}研发人员工时记录表`;
- this.$nextTick(() => {
- this.$refs.printWideTable.printTable(isLandscape);
- })
- },
- headerCellStyle ({ column }) {
- let color = column.labelClassName ? 'red' : 'rgba(0,0,0,.85)';
- return {
- color
- }
- }
- },
- }, {
- // 模块路径
- name: 'yfCostManage/basicDataSetting/workHoursRecords',
- res: ({ data }) => {
- let newList = [];
- data.records.forEach((item) => {
- let objData = {
- ...item,
- id: item.unicode+'_'+item.xmId,
- monthlyHours: (item.monthlyHours || 0).toFixed(1),
- monthlyDays: (item.monthlyDays || 0).toFixed(1)
- };
- item.dailyAttendances.forEach(hourItem => {
- objData[hourItem.workDate] = (hourItem.workHours || 0).toFixed(1);
- });
- newList.push(objData);
- });
- data.records = newList;
- return data;
- },
- });
- </script>
|