列表导出功能

前端

  handleExport() {
      let downloadUrl = `/elecSaleNet/export?${this.website.tokenHeader}=${getToken()}`;
      const {} = this.query;
      let values = {
        "ids":this.ids
      };
      this.$confirm("是否导出数据?", "提示", {
        confirmButtonText: "确定",
        cancelButtonText: "取消",
        type: "warning"
      }).then(() => {
        NProgress.start();
        exportBlob(downloadUrl, values).then(res => {
          downloadXls(res.data, `电费销售（上网）开票通知单${dateNow()}.xlsx`);
          NProgress.done();
        })
      });
    },

后端

/**
	 * 导出数据
	 *
	 * @param ids 电费销售上网主键集合
	 */
	@GetMapping("/export")
	public void export(@RequestParam String ids, HttpServletResponse response) {
		try {
			List<TpElecSaleNetExcel> list = this.elecSaleNetService.export(Func.toLongList(ids));
			IOUtils.exportExcel(response, "电费销售上网"
					+ DateUtils.getCurrentDateStrByFormat(DateFormat.Y_M_D_HMS),
				"电费销售上网表", TpElecSaleNetExcel.class, list);
		} catch (IOException e) {
			LOGGER.error("导出数据异常", e);
		}
	}


	/**
	 * 导出模板
	 * @param response
	 */
	@GetMapping("export-template")
	@ApiOperationSupport(order = 14)
	@ApiOperation(value = "导出模板")
	public void exportUser(HttpServletResponse response) {
		List<TpElecSaleNetExcel> list = new ArrayList<>();
		ExcelUtil.export(response, "电费销售上网模板", "电费销售上网表", list, TpElecSaleNetExcel.class);
	}