获取指定单元格数据(2.0)
<p>[TOC]</p>
<h5>简要描述</h5>
<ul>
<li>获取指定单元格数据</li>
</ul>
<h5>请求URL</h5>
<ul>
<li><code>http://47.111.70.10:8091/collector-siot-smb/api/smb/selectCellData</code></li>
</ul>
<h5>请求方式</h5>
<ul>
<li>POST </li>
</ul>
<h5>参数</h5>
<table>
<thead>
<tr>
<th style="text-align: left;">参数名</th>
<th style="text-align: left;">类型</th>
<th>是否必须</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align: left;">id</td>
<td style="text-align: left;">Long</td>
<td>是</td>
<td>策略id</td>
</tr>
<tr>
<td style="text-align: left;">smbCode</td>
<td style="text-align: left;">String</td>
<td>是</td>
<td>棒料编号</td>
</tr>
<tr>
<td style="text-align: left;">deviceId</td>
<td style="text-align: left;">Long</td>
<td>是</td>
<td>检测设备id</td>
</tr>
<tr>
<td style="text-align: left;">cell</td>
<td style="text-align: left;">String</td>
<td>是</td>
<td>单元格名称，例（A）</td>
</tr>
<tr>
<td style="text-align: left;">value</td>
<td style="text-align: left;">Long</td>
<td>是</td>
<td>时间段对应的value值,例(1)</td>
</tr>
</tbody>
</table>
<h5>返回示例</h5>
<pre><code>{
"msg": "操作成功",
"code": 200,
"data": {
"id": null,
"smbCode": null,
"batchId": null,
"deviceId": null,
"checkStatus": null,
"checkTime": null,
"createTime": null,
"createUserId": null,
"updateTime": null,
"updateUserId": null,
"isDeleted": null,
"pageIndex": 0,
"pageSize": 0,
"contrastSmbItems": null,
"batchCode": null,
"deviceName": null,
"name": null,
"tacticsId": null,
"tacticsIds": null,
"tacticsItems": null,
"voltage": null,
"current": null,
"record": null,
"cellList": [
{
"cell": "A",
"r": 0.005,
"q": 150,
"u": 0.05,
"qw": 0,
"i": 10
},
{
"cell": "B",
"r": 0.005,
"q": 150,
"u": 0.05,
"qw": 0,
"i": 10
},
{
"cell": "C",
"r": 0.005,
"q": 150,
"u": 0.05,
"qw": 0,
"i": 10
}
],
"potentialVoltageList": {
"id": 1,
"isEnable": 1,
"name": "全点位测试",
"cycle": 500,
"deviationValue": 30,
"sort": 1,
"remarks": "检测策略001",
"createTime": "2022-06-13 17:26:44",
"createUserId": 1,
"updateTime": "2022-08-11 11:35:42",
"updateUserId": 2,
"isDeleted": 1,
"pageIndex": 0,
"pageSize": 0,
"items": [
{
"id": 254,
"tacticsId": 1,
"sort": 1,
"coordinateId1": 1,
"coordinateName1": "1",
"coordinateId2": 9,
"coordinateName2": "9",
"threshold": 30,
"isDeleted": 1,
"coordinateCell1": "A-1",
"coordinateCell2": "B-1",
"cell": "A",
"ids": null,
"smbCode": null,
"line": null,
"coordinateName": null,
"parentSmbCode": null,
"dataValue": 0.041,
"deviationRate": 0,
"deviationValue": 30
},
{
"id": 255,
"tacticsId": 1,
"sort": 2,
"coordinateId1": 1,
"coordinateName1": "1",
"coordinateId2": 10,
"coordinateName2": "10",
"threshold": 30,
"isDeleted": 1,
"coordinateCell1": "A-1",
"coordinateCell2": "B-2",
"cell": "A",
"ids": null,
"smbCode": null,
"line": null,
"coordinateName": null,
"parentSmbCode": null,
"dataValue": 0.041,
"deviationRate": 0,
"deviationValue": 30
},
{
"id": 256,
"tacticsId": 1,
"sort": 3,
"coordinateId1": 1,
"coordinateName1": "1",
"coordinateId2": 11,
"coordinateName2": "11",
"threshold": 30,
"isDeleted": 1,
"coordinateCell1": "A-1",
"coordinateCell2": "B-3",
"cell": "A",
"ids": null,
"smbCode": null,
"line": null,
"coordinateName": null,
"parentSmbCode": null,
"dataValue": 0.041,
"deviationRate": 0,
"deviationValue": 30
},
{
"id": 257,
"tacticsId": 1,
"sort": 4,
"coordinateId1": 1,
"coordinateName1": "1",
"coordinateId2": 12,
"coordinateName2": "12",
"threshold": 30,
"isDeleted": 1,
"coordinateCell1": "A-1",
"coordinateCell2": "B-4",
"cell": "A",
"ids": null,
"smbCode": null,
"line": null,
"coordinateName": null,
"parentSmbCode": null,
"dataValue": 0.041,
"deviationRate": 0,
"deviationValue": 30
},
{
"id": 258,
"tacticsId": 1,
"sort": 5,
"coordinateId1": 1,
"coordinateName1": "1",
"coordinateId2": 13,
"coordinateName2": "13",
"threshold": 30,
"isDeleted": 1,
"coordinateCell1": "A-1",
"coordinateCell2": "B-5",
"cell": "A",
"ids": null,
"smbCode": null,
"line": null,
"coordinateName": null,
"parentSmbCode": null,
"dataValue": 0.041,
"deviationRate": 0,
"deviationValue": 30
},
{
"id": 259,
"tacticsId": 1,
"sort": 6,
"coordinateId1": 1,
"coordinateName1": "1",
"coordinateId2": 14,
"coordinateName2": "14",
"threshold": 30,
"isDeleted": 1,
"coordinateCell1": "A-1",
"coordinateCell2": "B-6",
"cell": "A",
"ids": null,
"smbCode": null,
"line": null,
"coordinateName": null,
"parentSmbCode": null,
"dataValue": 0.041,
"deviationRate": 0,
"deviationValue": 30
},
{
"id": 260,
"tacticsId": 1,
"sort": 7,
"coordinateId1": 1,
"coordinateName1": "1",
"coordinateId2": 15,
"coordinateName2": "15",
"threshold": 30,
"isDeleted": 1,
"coordinateCell1": "A-1",
"coordinateCell2": "B-7",
"cell": "A",
"ids": null,
"smbCode": null,
"line": null,
"coordinateName": null,
"parentSmbCode": null,
"dataValue": 0.041,
"deviationRate": 0,
"deviationValue": 30
},
{
"id": 261,
"tacticsId": 1,
"sort": 8,
"coordinateId1": 1,
"coordinateName1": "1",
"coordinateId2": 16,
"coordinateName2": "16",
"threshold": 30,
"isDeleted": 1,
"coordinateCell1": "A-1",
"coordinateCell2": "B-8",
"cell": "A",
"ids": null,
"smbCode": null,
"line": null,
"coordinateName": null,
"parentSmbCode": null,
"dataValue": 0.041,
"deviationRate": 0,
"deviationValue": 30
},
{
"id": 262,
"tacticsId": 1,
"sort": 9,
"coordinateId1": 2,
"coordinateName1": "2",
"coordinateId2": 9,
"coordinateName2": "9",
"threshold": 30,
"isDeleted": 1,
"coordinateCell1": "A-2",
"coordinateCell2": "B-1",
"cell": "A",
"ids": null,
"smbCode": null,
"line": null,
"coordinateName": null,
"parentSmbCode": null,
"dataValue": 0.041,
"deviationRate": 0,
"deviationValue": 30
},
{
"id": 263,
"tacticsId": 1,
"sort": 10,
"coordinateId1": 2,
"coordinateName1": "2",
"coordinateId2": 10,
"coordinateName2": "10",
"threshold": 30,
"isDeleted": 1,
"coordinateCell1": "A-2",
"coordinateCell2": "B-2",
"cell": "A",
"ids": null,
"smbCode": null,
"line": null,
"coordinateName": null,
"parentSmbCode": null,
"dataValue": 0.041,
"deviationRate": 0,
"deviationValue": 30
},
{
"id": 264,
"tacticsId": 1,
"sort": 11,
"coordinateId1": 2,
"coordinateName1": "2",
"coordinateId2": 11,
"coordinateName2": "11",
"threshold": 30,
"isDeleted": 1,
"coordinateCell1": "A-2",
"coordinateCell2": "B-3",
"cell": "A",
"ids": null,
"smbCode": null,
"line": null,
"coordinateName": null,
"parentSmbCode": null,
"dataValue": 0.041,
"deviationRate": 0,
"deviationValue": 30
},
{
"id": 265,
"tacticsId": 1,
"sort": 12,
"coordinateId1": 2,
"coordinateName1": "2",
"coordinateId2": 12,
"coordinateName2": "12",
"threshold": 30,
"isDeleted": 1,
"coordinateCell1": "A-2",
"coordinateCell2": "B-4",
"cell": "A",
"ids": null,
"smbCode": null,
"line": null,
"coordinateName": null,
"parentSmbCode": null,
"dataValue": 0.041,
"deviationRate": 0,
"deviationValue": 30
},
{
"id": 266,
"tacticsId": 1,
"sort": 13,
"coordinateId1": 2,
"coordinateName1": "2",
"coordinateId2": 13,
"coordinateName2": "13",
"threshold": 30,
"isDeleted": 1,
"coordinateCell1": "A-2",
"coordinateCell2": "B-5",
"cell": "A",
"ids": null,
"smbCode": null,
"line": null,
"coordinateName": null,
"parentSmbCode": null,
"dataValue": 0.041,
"deviationRate": 0,
"deviationValue": 30
},
{
"id": 267,
"tacticsId": 1,
"sort": 14,
"coordinateId1": 2,
"coordinateName1": "2",
"coordinateId2": 14,
"coordinateName2": "14",
"threshold": 30,
"isDeleted": 1,
"coordinateCell1": "A-2",
"coordinateCell2": "B-6",
"cell": "A",
"ids": null,
"smbCode": null,
"line": null,
"coordinateName": null,
"parentSmbCode": null,
"dataValue": 0.041,
"deviationRate": 0,
"deviationValue": 30
},
{
"id": 268,
"tacticsId": 1,
"sort": 15,
"coordinateId1": 2,
"coordinateName1": "2",
"coordinateId2": 15,
"coordinateName2": "15",
"threshold": 30,
"isDeleted": 1,
"coordinateCell1": "A-2",
"coordinateCell2": "B-7",
"cell": "A",
"ids": null,
"smbCode": null,
"line": null,
"coordinateName": null,
"parentSmbCode": null,
"dataValue": 0.041,
"deviationRate": 0,
"deviationValue": 30
},
{
"id": 269,
"tacticsId": 1,
"sort": 16,
"coordinateId1": 2,
"coordinateName1": "2",
"coordinateId2": 16,
"coordinateName2": "16",
"threshold": 30,
"isDeleted": 1,
"coordinateCell1": "A-2",
"coordinateCell2": "B-8",
"cell": "A",
"ids": null,
"smbCode": null,
"line": null,
"coordinateName": null,
"parentSmbCode": null,
"dataValue": 0.041,
"deviationRate": 0,
"deviationValue": 30
}
],
"deviceId": null,
"contrastData": null,
"runningStatus": null,
"smbCode": null,
"cell": null,
"value": null
},
"timingList": [
"2022-08-18 15:51:24",
"2022-08-18 15:52:35",
"2022-08-18 15:53:33"
],
"dataList": [
{
"cell": "A",
"r": 0.004,
"q": 120,
"u": 0.04,
"qw": 0,
"i": 10
},
{
"cell": "A",
"r": 0.005,
"q": 150,
"u": 0.05,
"qw": 0,
"i": 10
},
{
"cell": "A",
"r": 0.005,
"q": 150,
"u": 0.05,
"qw": 0,
"i": 10
}
]
},
"isSuccess": true
}</code></pre>
<h5>返回data参数说明</h5>
<table>
<thead>
<tr>
<th style="text-align: left;">参数名</th>
<th style="text-align: left;">类型</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align: left;">cellList</td>
<td style="text-align: left;">List</td>
<td>所有单元格集合</td>
</tr>
<tr>
<td style="text-align: left;">potentialVoltageList</td>
<td style="text-align: left;">对象</td>
<td>点位电压集合</td>
</tr>
<tr>
<td style="text-align: left;">timingList</td>
<td style="text-align: left;">Array</td>
<td>x轴时间段数组例:["2022-08-18","2022-08-19"]</td>
</tr>
<tr>
<td style="text-align: left;">dataList</td>
<td style="text-align: left;">List</td>
<td>y轴数据集合</td>
</tr>
</tbody>
</table>
<h5>返回potentialVoltageList中items集合的参数说明</h5>
<table>
<thead>
<tr>
<th style="text-align: left;">参数名</th>
<th style="text-align: left;">类型</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align: left;">id</td>
<td style="text-align: left;">Long</td>
<td>点位id</td>
</tr>
<tr>
<td style="text-align: left;">Long</td>
<td style="text-align: left;">long</td>
<td>策略id</td>
</tr>
<tr>
<td style="text-align: left;">dataValue</td>
<td style="text-align: left;">BigDecimal</td>
<td>电压值</td>
</tr>
<tr>
<td style="text-align: left;">threshold</td>
<td style="text-align: left;">BigDecimal</td>
<td>阈值</td>
</tr>
<tr>
<td style="text-align: left;">deviationRate</td>
<td style="text-align: left;">BigDecimal</td>
<td>实际偏差率(单位%)</td>
</tr>
<tr>
<td style="text-align: left;">deviationValue</td>
<td style="text-align: left;">BigDecimal</td>
<td>允许偏差率(单位%)</td>
</tr>
<tr>
<td style="text-align: left;">coordinateCell1</td>
<td style="text-align: left;">String</td>
<td>点位1</td>
</tr>
<tr>
<td style="text-align: left;">coordinateCell2</td>
<td style="text-align: left;">String</td>
<td>点位2</td>
</tr>
</tbody>
</table>
<h5>返回cellList参数说明</h5>
<table>
<thead>
<tr>
<th style="text-align: left;">参数名</th>
<th style="text-align: left;">类型</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align: left;">cell</td>
<td style="text-align: left;">String</td>
<td>单元格名称</td>
</tr>
<tr>
<td style="text-align: left;">U</td>
<td style="text-align: left;">BigDecimal</td>
<td>电压</td>
</tr>
<tr>
<td style="text-align: left;">I</td>
<td style="text-align: left;">BigDecimal</td>
<td>电流</td>
</tr>
<tr>
<td style="text-align: left;">R</td>
<td style="text-align: left;">BigDecimal</td>
<td>电阻</td>
</tr>
<tr>
<td style="text-align: left;">Q</td>
<td style="text-align: left;">BigDecimal</td>
<td>热值</td>
</tr>
<tr>
<td style="text-align: left;">Qw</td>
<td style="text-align: left;">BigDecimal</td>
<td>热值/功率(Q/W)</td>
</tr>
</tbody>
</table>
<h5>返回dataList参数说明</h5>
<table>
<thead>
<tr>
<th style="text-align: left;">参数名</th>
<th style="text-align: left;">类型</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align: left;">cell</td>
<td style="text-align: left;">String</td>
<td>单元格名称</td>
</tr>
<tr>
<td style="text-align: left;">U</td>
<td style="text-align: left;">BigDecimal</td>
<td>电压</td>
</tr>
<tr>
<td style="text-align: left;">I</td>
<td style="text-align: left;">BigDecimal</td>
<td>电流</td>
</tr>
<tr>
<td style="text-align: left;">R</td>
<td style="text-align: left;">BigDecimal</td>
<td>电阻</td>
</tr>
<tr>
<td style="text-align: left;">Q</td>
<td style="text-align: left;">BigDecimal</td>
<td>热值</td>
</tr>
<tr>
<td style="text-align: left;">Qw</td>
<td style="text-align: left;">BigDecimal</td>
<td>热值/功率(Q/W)</td>
</tr>
</tbody>
</table>
<h5>备注</h5>
<ul>
<li>更多返回错误代码请看首页的错误代码描述</li>
</ul>