文档
测试

导入日报表分析数据

POST
htt://127.0.0.1:8080/monitorAndAnalysis/importDailyReportData

接口描述

导入日报表分析数据

请求参数

参数名
类型
描述
必填
files
MultipartFile[]
日报表excel文件
必填
deviationAmount
Double
日偏差量
必填

响应参数

参数名
类型
描述
必填
code
Integer
200成功,其余失败
必填
msg
String
操作描述
必填
data
Json
数据集
必填
dailyDeviationDataByCQList
List
重庆气矿数据集
必填
workAreaName
String
作业区
必填
gasFieldName
String
气田
必填
wellName
String
气井
必填
todayProduct
Double
今日产量
必填
yesterdayProduct
Double
昨日产量
必填
compareProduct
Double
较昨日气量
必填
dailyDeviationDataByCDBList
List
川东北数据集
必填
workAreaName
String
作业区
必填
gasFieldName
String
气田
必填
wellName
String
气井
必填
todayProduct
Double
今日产量
必填
yesterdayProduct
Double
昨日产量
必填
compareProduct
Double
较昨日气量
必填
message
String
消息概括
必填

说明 / 示例

响应示例: { "msg": "操作成功", "code": 200, "data": { "dailyDeviationDataByCQList": [ { "workAreaName": "万州作业区", "gasFieldName": "大猫坪", "wellName": "云安012-X7", "todayProduct": 357275.0, "yesterdayProduct": 352423.0, "compareProduct": 4852.0, "deviationReason": null }, { "workAreaName": "万州作业区", "gasFieldName": "大猫坪", "wellName": "云安012-6", "todayProduct": 203741.0, "yesterdayProduct": 204419.0, "compareProduct": -678.0, "deviationReason": null }, { "workAreaName": "万州作业区", "gasFieldName": "大猫坪", "wellName": "云安012-2", "todayProduct": 169913.0, "yesterdayProduct": 171124.0, "compareProduct": -1211.0, "deviationReason": null }, { "workAreaName": "万州作业区", "gasFieldName": "大猫坪", "wellName": "云安012-1", "todayProduct": 356046.0, "yesterdayProduct": 359371.0, "compareProduct": -3325.0, "deviationReason": null }, { "workAreaName": "万州作业区", "gasFieldName": "大猫坪", "wellName": "云安012-X8", "todayProduct": 214220.0, "yesterdayProduct": 241053.0, "compareProduct": -26833.0, "deviationReason": null }, { "workAreaName": "万州作业区", "gasFieldName": "大猫坪", "wellName": "云安012-X16", "todayProduct": 389886.0, "yesterdayProduct": 344965.0, "compareProduct": 44921.0, "deviationReason": null }, { "workAreaName": "万州作业区", "gasFieldName": "大猫坪", "wellName": "云安012-12", "todayProduct": 0.0, "yesterdayProduct": 0.0, "compareProduct": 0.0, "deviationReason": null }, { "workAreaName": "开州作业区", "gasFieldName": "檀木场", "wellName": "七里013-H1", "todayProduct": 29876.0, "yesterdayProduct": 0.0, "compareProduct": 29876.0, "deviationReason": null }, { "workAreaName": "开州作业区", "gasFieldName": "檀木场", "wellName": "七里13", "todayProduct": 8004.0, "yesterdayProduct": 8818.0, "compareProduct": -814.0, "deviationReason": null }, { "workAreaName": "开州作业区", "gasFieldName": "檀木场", "wellName": "七里28", "todayProduct": 22137.0, "yesterdayProduct": 22491.0, "compareProduct": -354.0, "deviationReason": null }, { "workAreaName": "开州作业区", "gasFieldName": "檀木场", "wellName": "七里49", "todayProduct": 36154.0, "yesterdayProduct": 35714.0, "compareProduct": 440.0, "deviationReason": null }, { "workAreaName": "开州作业区", "gasFieldName": "檀木场", "wellName": "七里028-X1", "todayProduct": 0.0, "yesterdayProduct": 0.0, "compareProduct": 0.0, "deviationReason": null }, { "workAreaName": "开州作业区", "gasFieldName": "檀木场", "wellName": "七里53", "todayProduct": 4968.0, "yesterdayProduct": 4893.0, "compareProduct": 75.0, "deviationReason": null }, { "workAreaName": "开州作业区", "gasFieldName": "檀木场", "wellName": "五探1", "todayProduct": 0.0, "yesterdayProduct": 0.0, "compareProduct": 0.0, "deviationReason": null }, { "workAreaName": "开州作业区", "gasFieldName": "檀木场", "wellName": "七里50", "todayProduct": 0.0, "yesterdayProduct": 0.0, "compareProduct": 0.0, "deviationReason": null }, { "workAreaName": "梁平作业区", "gasFieldName": "龙门场", "wellName": "天东9", "todayProduct": 25967.0, "yesterdayProduct": 10482.0, "compareProduct": 15485.0, "deviationReason": null }, { "workAreaName": "梁平作业区", "gasFieldName": "龙门场", "wellName": "天东012-H1", "todayProduct": 0.0, "yesterdayProduct": 0.0, "compareProduct": 0.0, "deviationReason": null }, { "workAreaName": "梁平作业区", "gasFieldName": "龙门场", "wellName": "天东106", "todayProduct": 13343.0, "yesterdayProduct": 14025.0, "compareProduct": -682.0, "deviationReason": null }, { "workAreaName": "梁平作业区", "gasFieldName": "龙门场", "wellName": "天东55", "todayProduct": 17163.0, "yesterdayProduct": 16946.0, "compareProduct": 217.0, "deviationReason": null }, { "workAreaName": "梁平作业区", "gasFieldName": "龙门场", "wellName": "天东108", "todayProduct": 37188.0, "yesterdayProduct": 37151.0, "compareProduct": 37.0, "deviationReason": null }, { "workAreaName": "梁平作业区", "gasFieldName": "龙门场", "wellName": "天东19", "todayProduct": 22182.0, "yesterdayProduct": 22306.0, "compareProduct": -124.0, "deviationReason": null }, { "workAreaName": "梁平作业区", "gasFieldName": "龙门场", "wellName": "天东57", "todayProduct": 0.0, "yesterdayProduct": 0.0, "compareProduct": 0.0, "deviationReason": null }, { "workAreaName": "梁平作业区", "gasFieldName": "龙门场", "wellName": "天东009-2", "todayProduct": 27381.0, "yesterdayProduct": 28593.0, "compareProduct": -1212.0, "deviationReason": null }, { "workAreaName": "梁平作业区", "gasFieldName": "龙门场", "wellName": "天东018-H1", "todayProduct": 16707.0, "yesterdayProduct": 16691.0, "compareProduct": 16.0, "deviationReason": null }, { "workAreaName": "梁平作业区", "gasFieldName": "龙门场", "wellName": "天东004-H2", "todayProduct": 6983.0, "yesterdayProduct": 0.0, "compareProduct": 6983.0, "deviationReason": null }, { "workAreaName": "梁平作业区", "gasFieldName": "龙门场", "wellName": "天东12", "todayProduct": 7100.0, "yesterdayProduct": 6925.0, "compareProduct": 175.0, "deviationReason": null }, { "workAreaName": "梁平作业区", "gasFieldName": "龙门场", "wellName": "天东18", "todayProduct": 16953.0, "yesterdayProduct": 16916.0, "compareProduct": 37.0, "deviationReason": null }, { "workAreaName": "梁平作业区", "gasFieldName": "龙门场", "wellName": "天东56", "todayProduct": 0.0, "yesterdayProduct": 0.0, "compareProduct": 0.0, "deviationReason": null }, { "workAreaName": "梁平作业区", "gasFieldName": "龙门场", "wellName": "天东110", "todayProduct": 383957.0, "yesterdayProduct": 384185.0, "compareProduct": -228.0, "deviationReason": null }, { "workAreaName": "梁平作业区", "gasFieldName": "龙门场", "wellName": "天东5-1", "todayProduct": 83755.0, "yesterdayProduct": 80558.0, "compareProduct": 3197.0, "deviationReason": null }, { "workAreaName": "梁平作业区", "gasFieldName": "龙门场", "wellName": "天东109", "todayProduct": 0.0, "yesterdayProduct": 0.0, "compareProduct": 0.0, "deviationReason": null } ], "dailyDeviationDataByCDBList": [ { "workAreaName": "川东北作业区", "gasFieldName": "黄龙场", "wellName": "黄龙004-X4", "todayProduct": 9164.0, "yesterdayProduct": 9683.0, "compareProduct": -519.0, "deviationReason": null }, { "workAreaName": "川东北作业区", "gasFieldName": "黄龙场", "wellName": "黄龙009-H1", "todayProduct": 303000.0, "yesterdayProduct": 268677.0, "compareProduct": 34323.0, "deviationReason": null }, { "workAreaName": "川东北作业区", "gasFieldName": "黄龙场", "wellName": "黄龙009-H2", "todayProduct": 0.0, "yesterdayProduct": 0.0, "compareProduct": 0.0, "deviationReason": null }, { "workAreaName": "川东北作业区", "gasFieldName": "黄龙场", "wellName": "黄龙1", "todayProduct": 24659.0, "yesterdayProduct": 24623.0, "compareProduct": 36.0, "deviationReason": null }, { "workAreaName": "川东北作业区", "gasFieldName": "黄龙场", "wellName": "黄龙001-X1", "todayProduct": 0.0, "yesterdayProduct": 0.0, "compareProduct": 0.0, "deviationReason": null }, { "workAreaName": "川东北作业区", "gasFieldName": "黄龙场", "wellName": "黄龙001-X2", "todayProduct": 0.0, "yesterdayProduct": 0.0, "compareProduct": 0.0, "deviationReason": null }, { "workAreaName": "川东北作业区", "gasFieldName": "黄龙场", "wellName": "黄龙4", "todayProduct": 23495.0, "yesterdayProduct": 5087.0, "compareProduct": 18408.0, "deviationReason": null }, { "workAreaName": "川东北作业区", "gasFieldName": "黄龙场", "wellName": "黄龙004-X1", "todayProduct": 20823.0, "yesterdayProduct": 15749.0, "compareProduct": 5074.0, "deviationReason": null }, { "workAreaName": "川东北作业区", "gasFieldName": "黄龙场", "wellName": "黄龙004-2", "todayProduct": 34125.0, "yesterdayProduct": 34694.0, "compareProduct": -569.0, "deviationReason": null }, { "workAreaName": "川东北作业区", "gasFieldName": "黄龙场", "wellName": "黄龙004-X3", "todayProduct": 0.0, "yesterdayProduct": 0.0, "compareProduct": 0.0, "deviationReason": null }, { "workAreaName": "川东北作业区", "gasFieldName": "黄龙场", "wellName": "黄龙8(油管)", "todayProduct": 5659.0, "yesterdayProduct": 5684.0, "compareProduct": -25.0, "deviationReason": null }, { "workAreaName": "川东北作业区", "gasFieldName": "黄龙场", "wellName": "黄龙10", "todayProduct": 55201.0, "yesterdayProduct": 55388.0, "compareProduct": -187.0, "deviationReason": null }, { "workAreaName": "川东北作业区", "gasFieldName": "铁山", "wellName": "铁山5", "todayProduct": 36954.0, "yesterdayProduct": 35689.0, "compareProduct": 1265.0, "deviationReason": null }, { "workAreaName": "川东北作业区", "gasFieldName": "铁山", "wellName": "铁山11", "todayProduct": 42221.0, "yesterdayProduct": 42846.0, "compareProduct": -625.0, "deviationReason": null }, { "workAreaName": "川东北作业区", "gasFieldName": "铁山", "wellName": "铁山13", "todayProduct": 78096.0, "yesterdayProduct": 78416.0, "compareProduct": -320.0, "deviationReason": null }, { "workAreaName": "川东北作业区", "gasFieldName": "铁山", "wellName": "铁山21(套)", "todayProduct": 14196.0, "yesterdayProduct": 11401.0, "compareProduct": 2795.0, "deviationReason": null }, { "workAreaName": "川东北作业区", "gasFieldName": "铁山", "wellName": "铁山14", "todayProduct": 41216.0, "yesterdayProduct": 38331.0, "compareProduct": 2885.0, "deviationReason": null }, { "workAreaName": "川东北作业区", "gasFieldName": "铁山", "wellName": "铁山21(油)", "todayProduct": 25237.0, "yesterdayProduct": 15879.0, "compareProduct": 9358.0, "deviationReason": null }, { "workAreaName": "川东北作业区", "gasFieldName": "铁山", "wellName": "铁山4", "todayProduct": 19653.0, "yesterdayProduct": 20566.0, "compareProduct": -913.0, "deviationReason": null }, { "workAreaName": "川东北作业区", "gasFieldName": "铁山", "wellName": "铁山12", "todayProduct": 0.0, "yesterdayProduct": 0.0, "compareProduct": 0.0, "deviationReason": null }, { "workAreaName": "川东北作业区", "gasFieldName": "铁山", "wellName": "铁山22", "todayProduct": 59140.0, "yesterdayProduct": 59096.0, "compareProduct": 44.0, "deviationReason": null }, { "workAreaName": "川东北作业区", "gasFieldName": "铁山北", "wellName": "铁山北1", "todayProduct": 67563.0, "yesterdayProduct": 67138.0, "compareProduct": 425.0, "deviationReason": null }, { "workAreaName": "川东北作业区", "gasFieldName": "铁山北", "wellName": "铁北101", "todayProduct": 55857.0, "yesterdayProduct": 56523.0, "compareProduct": -666.0, "deviationReason": null }, { "workAreaName": "川东北作业区", "gasFieldName": "铁山北", "wellName": "铁北101-X1", "todayProduct": 52552.0, "yesterdayProduct": 62560.0, "compareProduct": -10008.0, "deviationReason": null }, { "workAreaName": "川东北作业区", "gasFieldName": "铁山北", "wellName": "铁北101-X2", "todayProduct": 3775.0, "yesterdayProduct": 3728.0, "compareProduct": 47.0, "deviationReason": null }, { "workAreaName": "川东北作业区", "gasFieldName": "铁山北", "wellName": "铁北101-H3", "todayProduct": 30865.0, "yesterdayProduct": 35221.0, "compareProduct": -4356.0, "deviationReason": null } ] } }