成绩管理可以按天导出成绩，保安员批量导入，个人照片批量导入修改

Administrator

2021-10-19 d56d2182f0f886f748130d39a24d69028e8bd960

 src/views/trainExam/performance.vue

@@ -75,6 +75,15 @@
                @click="handleImport"
                >实操成绩导入
              </el-button>
              <el-button
                type="warning"
                size="small"
                plain
                icon="el-icon-download"
                v-if="permission.trainExam_performance_export"
                @click="handleExport"
                >成绩导出
              </el-button>
            </template>

            <template slot-scope="{ type, size, row }" slot="menu">
@@ -146,8 +155,8 @@
        addBtn: false,
        selection: false,
        // 导出按钮
        excelBtn: true,
        excelBtnText: "成绩导出",
        // excelBtn: true,
        // excelBtnText: "成绩导出",
        viewBtn: true,
        // title: '成绩',
        align: "center",
@@ -167,10 +176,35 @@

        column: [
          {
            label: "考试时间",
            prop: "examDate",
            type: "date",
            hide: true,
            format: "yyyy-MM-dd",
            valueFormat: "yyyy-MM-dd",
            width: 140,
            slot: true,
            search:true,
            searchSpan:4,
            // 表单新增时是否禁止
            addDisabled: false,
            // 表单新增时是否可见
            addDisplay: false,
            // 表单新增时是否为查看模式
            addDetail: false,
            // 表单编辑时是否禁止
            editDisabled: false,
            // 表单编辑时是否可见
            editDisplay: false,
            // 表单编辑时是否为查看模式
            editDetail: false,
            viewDisplay:false
          },
          {
            label: "考试名称",
            prop: "examName",
            search: true,
            searchSpan: 4,
            // search: true,
            // searchSpan: 4,
            slot: true,
            viewDisplay: true,
            // 表单新增时是否禁止
@@ -474,6 +508,7 @@
              },
            ],
          },
          
        ],
      },
      questionBankSearch: {},
@@ -680,6 +715,31 @@
    refreshChange() {
      this.questionBankOnLoad(this.questionBankPage, this.questionBankQuery);
    },
    //成绩导出
    handleExport() {
      this.$confirm("是否导出成绩数据?", "提示", {
        confirmButtonText: "确定",
        cancelButtonText: "取消",
        type: "warning",
      }).then(() => {
        //获取查询条件
        console.log(this.questionBankSearch,456);
        //导出
        const account = this.questionBankSearch.account;
        const companyName = this.questionBankSearch.companyName;
        const examDate = this.questionBankSearch.examDate;
        const isExam = this.questionBankSearch.isExam;
        const qualified = this.questionBankSearch.qualified;
        const securityName = this.questionBankSearch.securityName;
        window.open(
          `/api/examScore/export-examScore?examDate=`+ examDate +"&account="+account+
          "&companyName="+companyName+
          "&isExam="+isExam+
          "&qualified="+qualified+
          "&securityName="+securityName
        );
      });
    },
  },
};
</script>