Project

General

Profile

Feature #1664

BS历史报警下载打印功能

Added by yanwei li about 3 years ago. Updated about 3 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
yanwei li
Target version:
3.0_web
Start date:
09/23/2021
Due date:
10/12/2021
% Done:

100%

Estimated time:
16.00 h
Defect version:

Description

新增三个接口
1、根据查询参数查询出对应历史数据并生成对应的Excel表格，将Excel表格的文件名返回给前端
2、前端根据文件名查询该文件是否生成完毕
3、得知生成完毕后，根据下载地址下载该Excel表

History

#1

Updated by yanwei li about 3 years ago

  • Status changed from New to Resolved
#2

Updated by yanwei li about 3 years ago

当需要导入的数据量过大时，需要将生成的Excel表分表

#3

Updated by yanwei li about 3 years ago

  • Due date changed from 09/26/2021 to 10/12/2021

改动：
优化生成的Excel表格，当查询数量过大时，会生成多个sheet；
在一级、二级、三级报警上增加了背景颜色加以区分；
当下载失败时（查询数量为空或生成表格失败），响应给客户端失败结果；

#4

Updated by yanwei li about 3 years ago

测试数据：{"dateFrom":"1616981503","dateTo":"1627799381","Page":"","num":"200","almPrio":[],"appSysId":"","groupName":"","devType":"","almClass":[]}
数量共有418386条，查询耗时20s，翻译约1s，生成Excel表格并填充数据且增加背景色以及修改单元格宽度耗时约40s，总耗时约60s。
目前去掉修改单元格宽度处理，总耗时减少约15s

Also available in: Atom PDF