sensor_chart_D.html 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685
  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4. <meta charset="UTF-8">
  5. <title>{{ title }}</title>
  6. <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  7. <!-- 新 Bootstrap4 核心 CSS 文件 -->
  8. <link rel="stylesheet" href="https://cdn.bootcss.com/bootstrap/4.1.0/css/bootstrap.min.css">
  9. <!-- jQuery文件。务必在bootstrap.min.js 之前引入 -->
  10. <script src="https://cdn.bootcss.com/jquery/3.2.1/jquery.min.js"></script>
  11. <!-- popper.min.js 用于弹窗、提示、下拉菜单 -->
  12. <script src="https://cdn.bootcss.com/popper.js/1.12.5/umd/popper.min.js"></script>
  13. <!-- 最新的 Bootstrap4 核心 JavaScript 文件 -->
  14. <script src="https://cdn.bootcss.com/bootstrap/4.1.0/js/bootstrap.min.js"></script>
  15. <!--
  16. <script src="../static/js/sign_in.js"></script>
  17. <link rel="stylesheet" href="../static/css/sign_in.css">
  18. -->
  19. <!--引入 echarts.js -->
  20. <script src="https://cdn.staticfile.org/echarts/4.3.0/echarts.min.js"></script>
  21. <script src='https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.5.0/Chart.min.js'></script>
  22. <script src='https://cdnjs.cloudflare.com/ajax/libs/hammer.js/2.0.8/hammer.js'></script>
  23. <script src="https://cdnjs.cloudflare.com/ajax/libs/chartjs-plugin-zoom/0.3.0/Chart.Zoom.min.js"></script>
  24. <script language="JavaScript">
  25. var tank = '{{tank}}';
  26. var sensor_name = '{{sensor_name}}';
  27. var tid = '{{tid}}';
  28. $(document).ready(function(){
  29. $("#coffee_title").text(tank + tid + ' 乾燥槽感測器圖表');
  30. });
  31. </script>
  32. </head>
  33. <body>
  34. <div id="wrapper">
  35. <div id="coffee_header">
  36. <!-- 匯入共同使用的 header.html 內容 -->
  37. {% include 'header.html' %}
  38. </div>
  39. <!--
  40. <a href="/dry">返回乾燥槽介面</a>
  41. <div style="text-align: center; margin-top:0px; font-size: 24px;">
  42. Smart Coffee
  43. </div>
  44. <form action="/chart/SHT11_Temp/{{tid}}" method="post">
  45. <div class="form-group" style="margin-top: 30px; text-align: center;">
  46. -->
  47. <table style="margin: auto; border:3px gray solid; width: 80%; text-align: center;" cellpadding="6" rules='ALL'>
  48. <tr>
  49. <td>
  50. {% if tid == '2'%}
  51. <select id="tank_num">
  52. <option value="D1">乾燥槽_1</option>
  53. <option value="D2" selected>乾燥槽_2</option>
  54. <option value="D3">乾燥槽_3</option>
  55. <option value="D4">乾燥槽_4</option>
  56. <option value="D5">乾燥槽_5</option>
  57. <option value="D6">乾燥槽_6</option>
  58. <option value="D7">乾燥槽_7</option>
  59. <option value="D8">乾燥槽_8</option>
  60. <option value="D9">乾燥槽_9</option>
  61. <option value="D10">乾燥槽_10</option>
  62. <option value="D11">乾燥槽_11</option>
  63. <option value="D12">乾燥槽_12</option>
  64. </select>
  65. {% elif tid == '3'%}
  66. <select id="tank_num">
  67. <option value="D1">乾燥槽_1</option>
  68. <option value="D2">乾燥槽_2</option>
  69. <option value="D3" selected>乾燥槽_3</option>
  70. <option value="D4">乾燥槽_4</option>
  71. <option value="D5">乾燥槽_5</option>
  72. <option value="D6">乾燥槽_6</option>
  73. <option value="D7">乾燥槽_7</option>
  74. <option value="D8">乾燥槽_8</option>
  75. <option value="D9">乾燥槽_9</option>
  76. <option value="D10">乾燥槽_10</option>
  77. <option value="D11">乾燥槽_11</option>
  78. <option value="D12">乾燥槽_12</option>
  79. </select>
  80. {% elif tid == '4'%}
  81. <select id="tank_num">
  82. <option value="D1">乾燥槽_1</option>
  83. <option value="D2">乾燥槽_2</option>
  84. <option value="D3">乾燥槽_3</option>
  85. <option value="D4" selected>乾燥槽_4</option>
  86. <option value="D5">乾燥槽_5</option>
  87. <option value="D6">乾燥槽_6</option>
  88. <option value="D7">乾燥槽_7</option>
  89. <option value="D8">乾燥槽_8</option>
  90. <option value="D9">乾燥槽_9</option>
  91. <option value="D10">乾燥槽_10</option>
  92. <option value="D11">乾燥槽_11</option>
  93. <option value="D12">乾燥槽_12</option>
  94. </select>
  95. {% elif tid == '5'%}
  96. <select id="tank_num">
  97. <option value="D1">乾燥槽_1</option>
  98. <option value="D2">乾燥槽_2</option>
  99. <option value="D3">乾燥槽_3</option>
  100. <option value="D4">乾燥槽_4</option>
  101. <option value="D5" selected>乾燥槽_5</option>
  102. <option value="D6">乾燥槽_6</option>
  103. <option value="D7">乾燥槽_7</option>
  104. <option value="D8">乾燥槽_8</option>
  105. <option value="D9">乾燥槽_9</option>
  106. <option value="D10">乾燥槽_10</option>
  107. <option value="D11">乾燥槽_11</option>
  108. <option value="D12">乾燥槽_12</option>
  109. </select>
  110. {% elif tid == '6'%}
  111. <select id="tank_num">
  112. <option value="D1">乾燥槽_1</option>
  113. <option value="D2">乾燥槽_2</option>
  114. <option value="D3">乾燥槽_3</option>
  115. <option value="D4">乾燥槽_4</option>
  116. <option value="D5">乾燥槽_5</option>
  117. <option value="D6" selected>乾燥槽_6</option>
  118. <option value="D7">乾燥槽_7</option>
  119. <option value="D8">乾燥槽_8</option>
  120. <option value="D9">乾燥槽_9</option>
  121. <option value="D10">乾燥槽_10</option>
  122. <option value="D11">乾燥槽_11</option>
  123. <option value="D12">乾燥槽_12</option>
  124. </select>
  125. {% elif tid == '7'%}
  126. <select id="tank_num">
  127. <option value="D1">乾燥槽_1</option>
  128. <option value="D2">乾燥槽_2</option>
  129. <option value="D3">乾燥槽_3</option>
  130. <option value="D4">乾燥槽_4</option>
  131. <option value="D5">乾燥槽_5</option>
  132. <option value="D6">乾燥槽_6</option>
  133. <option value="D7" selected>乾燥槽_7</option>
  134. <option value="D8">乾燥槽_8</option>
  135. <option value="D9">乾燥槽_9</option>
  136. <option value="D10">乾燥槽_10</option>
  137. <option value="D11">乾燥槽_11</option>
  138. <option value="D12">乾燥槽_12</option>
  139. </select>
  140. {% elif tid == '8'%}
  141. <select id="tank_num">
  142. <option value="D1">乾燥槽_1</option>
  143. <option value="D2">乾燥槽_2</option>
  144. <option value="D3">乾燥槽_3</option>
  145. <option value="D4">乾燥槽_4</option>
  146. <option value="D5">乾燥槽_5</option>
  147. <option value="D6">乾燥槽_6</option>
  148. <option value="D7">乾燥槽_7</option>
  149. <option value="D8" selected>乾燥槽_8</option>
  150. <option value="D9">乾燥槽_9</option>
  151. <option value="D10">乾燥槽_10</option>
  152. <option value="D11">乾燥槽_11</option>
  153. <option value="D12">乾燥槽_12</option>
  154. </select>
  155. {% elif tid == '9'%}
  156. <select id="tank_num">
  157. <option value="D1">乾燥槽_1</option>
  158. <option value="D2">乾燥槽_2</option>
  159. <option value="D3">乾燥槽_3</option>
  160. <option value="D4">乾燥槽_4</option>
  161. <option value="D5">乾燥槽_5</option>
  162. <option value="D6">乾燥槽_6</option>
  163. <option value="D7">乾燥槽_7</option>
  164. <option value="D8">乾燥槽_8</option>
  165. <option value="D9" selected>乾燥槽_9</option>
  166. <option value="D10">乾燥槽_10</option>
  167. <option value="D11">乾燥槽_11</option>
  168. <option value="D12">乾燥槽_12</option>
  169. </select>
  170. {% elif tid == '10'%}
  171. <select id="tank_num">
  172. <option value="D1">乾燥槽_1</option>
  173. <option value="D2">乾燥槽_2</option>
  174. <option value="D3">乾燥槽_3</option>
  175. <option value="D4">乾燥槽_4</option>
  176. <option value="D5">乾燥槽_5</option>
  177. <option value="D6">乾燥槽_6</option>
  178. <option value="D7">乾燥槽_7</option>
  179. <option value="D8">乾燥槽_8</option>
  180. <option value="D9">乾燥槽_9</option>
  181. <option value="D10" selected>乾燥槽_10</option>
  182. <option value="D11">乾燥槽_11</option>
  183. <option value="D12">乾燥槽_12</option>
  184. </select>
  185. {% elif tid == '11'%}
  186. <select id="tank_num">
  187. <option value="D1">乾燥槽_1</option>
  188. <option value="D2">乾燥槽_2</option>
  189. <option value="D3">乾燥槽_3</option>
  190. <option value="D4">乾燥槽_4</option>
  191. <option value="D5">乾燥槽_5</option>
  192. <option value="D6">乾燥槽_6</option>
  193. <option value="D7">乾燥槽_7</option>
  194. <option value="D8">乾燥槽_8</option>
  195. <option value="D9">乾燥槽_9</option>
  196. <option value="D10">乾燥槽_10</option>
  197. <option value="D11" selected>乾燥槽_11</option>
  198. <option value="D12">乾燥槽_12</option>
  199. </select>
  200. {% elif tid == '12'%}
  201. <select id="tank_num">
  202. <option value="D1">乾燥槽_1</option>
  203. <option value="D2">乾燥槽_2</option>
  204. <option value="D3">乾燥槽_3</option>
  205. <option value="D4">乾燥槽_4</option>
  206. <option value="D5">乾燥槽_5</option>
  207. <option value="D6">乾燥槽_6</option>
  208. <option value="D7">乾燥槽_7</option>
  209. <option value="D8">乾燥槽_8</option>
  210. <option value="D9">乾燥槽_9</option>
  211. <option value="D10">乾燥槽_10</option>
  212. <option value="D11">乾燥槽_11</option>
  213. <option value="D12" selected>乾燥槽_12</option>
  214. </select>
  215. {% else %}
  216. <select id="tank_num">
  217. <option value="D1" selected>乾燥槽_1</option>
  218. <option value="D2">乾燥槽_2</option>
  219. <option value="D3">乾燥槽_3</option>
  220. <option value="D4">乾燥槽_4</option>
  221. <option value="D5">乾燥槽_5</option>
  222. <option value="D6">乾燥槽_6</option>
  223. <option value="D7">乾燥槽_7</option>
  224. <option value="D8">乾燥槽_8</option>
  225. <option value="D9">乾燥槽_9</option>
  226. <option value="D10">乾燥槽_10</option>
  227. <option value="D11">乾燥槽_11</option>
  228. <option value="D12">乾燥槽_12</option>
  229. </select>
  230. {% endif %}
  231. {% if sensor_name=='SHT11_Humidity' %}
  232. <select id="sensors">
  233. <option value="SHT11_Temp">乾燥槽桶內溫度</option>
  234. <option value="SHT11_Humidity" selected>乾燥槽桶內濕度</option>
  235. <option value="UltraSonic">乾燥槽桶內咖啡生豆高度</option>
  236. <option value="PA">乾燥槽桶內壓力</option>
  237. <option value="soil_Temp">乾燥槽咖啡生豆溫度</option>
  238. <option value="soil_Humidity">乾燥槽咖啡生豆濕度</option>
  239. <option value="soil_EC">乾燥槽咖啡生豆 EC</option>
  240. </select>
  241. {% elif sensor_name=='UltraSonic' %}
  242. <select id="sensors">
  243. <option value="SHT11_Temp">乾燥槽桶內溫度</option>
  244. <option value="SHT11_Humidity">乾燥槽桶內濕度</option>
  245. <option value="UltraSonic" selected>乾燥槽桶內咖啡生豆高度</option>
  246. <option value="PA">乾燥槽桶內壓力</option>
  247. <option value="soil_Temp">乾燥槽咖啡生豆溫度</option>
  248. <option value="soil_Humidity">乾燥槽咖啡生豆濕度</option>
  249. <option value="soil_EC">乾燥槽咖啡生豆 EC</option>
  250. </select>
  251. {% elif sensor_name=='PA' %}
  252. <select id="sensors">
  253. <option value="SHT11_Temp">乾燥槽桶內溫度</option>
  254. <option value="SHT11_Humidity">乾燥槽桶內濕度</option>
  255. <option value="UltraSonic">乾燥槽桶內咖啡生豆高度</option>
  256. <option value="PA" selected>乾燥槽桶內壓力</option>
  257. <option value="soil_Temp">乾燥槽咖啡生豆溫度</option>
  258. <option value="soil_Humidity">乾燥槽咖啡生豆濕度</option>
  259. <option value="soil_EC">乾燥槽咖啡生豆 EC</option>
  260. </select>
  261. {% elif sensor_name=='soil_Temp' %}
  262. <select id="sensors">
  263. <option value="SHT11_Temp">乾燥槽桶內溫度</option>
  264. <option value="SHT11_Humidity">乾燥槽桶內濕度</option>
  265. <option value="UltraSonic">乾燥槽桶內咖啡生豆高度</option>
  266. <option value="PA">乾燥槽桶內壓力</option>
  267. <option value="soil_Temp" selected>乾燥槽咖啡生豆溫度</option>
  268. <option value="soil_Humidity">乾燥槽咖啡生豆濕度</option>
  269. <option value="soil_EC">乾燥槽咖啡生豆 EC</option>
  270. </select>
  271. {% elif sensor_name=='soil_Humidity' %}
  272. <select id="sensors">
  273. <option value="SHT11_Temp">乾燥槽桶內溫度</option>
  274. <option value="SHT11_Humidity">乾燥槽桶內濕度</option>
  275. <option value="UltraSonic">乾燥槽桶內咖啡生豆高度</option>
  276. <option value="PA">乾燥槽桶內壓力</option>
  277. <option value="soil_Temp">乾燥槽咖啡生豆溫度</option>
  278. <option value="soil_Humidity" selected>乾燥槽咖啡生豆濕度</option>
  279. <option value="soil_EC">乾燥槽咖啡生豆 EC</option>
  280. </select>
  281. {% elif sensor_name=='soil_EC' %}
  282. <select id="sensors">
  283. <option value="SHT11_Temp">乾燥槽桶內溫度</option>
  284. <option value="SHT11_Humidity">乾燥槽桶內濕度</option>
  285. <option value="UltraSonic">乾燥槽桶內咖啡生豆高度</option>
  286. <option value="PA">乾燥槽桶內壓力</option>
  287. <option value="soil_Temp">乾燥槽咖啡生豆溫度</option>
  288. <option value="soil_Humidity">乾燥槽咖啡生豆濕度</option>
  289. <option value="soil_EC" selected>乾燥槽咖啡生豆 EC</option>
  290. </select>
  291. {% else %}
  292. <select id="sensors">
  293. <option value="SHT11_Temp" selected>乾燥槽桶內溫度</option>
  294. <option value="SHT11_Humidity">乾燥槽桶內濕度</option>
  295. <option value="UltraSonic">乾燥槽桶內咖啡生豆高度</option>
  296. <option value="PA">乾燥槽桶內壓力</option>
  297. <option value="soil_Temp">乾燥槽咖啡生豆溫度</option>
  298. <option value="soil_Humidity">乾燥槽咖啡生豆濕度</option>
  299. <option value="soil_EC">乾燥槽咖啡生豆 EC</option>
  300. </select>
  301. {% endif %}
  302. </td>
  303. </tr>
  304. <tr>
  305. <td>
  306. 時間間隔:
  307. <select name="time-interval" class="text-right">
  308. <option value="month">逐月</option>
  309. <option value="day">逐日</option>
  310. <option value="hour">逐時</option>
  311. </select>
  312. &nbsp;
  313. <!--
  314. 從&nbsp;
  315. <input type="datetime-local" name="sensor_starttime" id="sensor_starttime" value={{starttime}}>
  316. &nbsp;到&nbsp;
  317. <input type="datetime-local" name="sensor_endtime" id="sensor_endtime" value={{endtime}}>
  318. &nbsp;為止
  319. -->
  320. <span>從</span>
  321. <label for="querydate-start"></label><input id="querydate-start" type="date">
  322. <span>到</span>
  323. <label for="querydate-end"></label><input id="querydate-end" type="date">
  324. <span>為止</span>
  325. </td>
  326. </tr>
  327. <tr>
  328. <td>
  329. 資料類型:
  330. <label><input type="checkbox" name="data-type" value="max">最大值</label>
  331. <label><input type="checkbox" name="data-type" value="avg">平均值</label>
  332. <label><input type="checkbox" name="data-type" value="min">最小值</label>
  333. <br>
  334. </td>
  335. </tr>
  336. <tr>
  337. <td>
  338. <!--
  339. <button type="submit" name="charting">繪製圖表</button>
  340. <button type="submit" onclick="" id="btn_save_chart" style="display: none;">儲存圖表</button>
  341. -->
  342. <input type="button" value="查詢" onclick="ShowInfo()">
  343. <input type="button" value="匯出" onclick="downloadFile()">
  344. <input type="button" value="刪除" onclick="">
  345. <script>
  346. function ShowInfo() {
  347. // 取得桶號、感測器名稱
  348. tid = document.getElementById("tank_num").value
  349. console.log('tid: ' + tid)
  350. sensor_name = document.getElementById("sensors").value
  351. console.log('sensor_name: ' + sensor_name)
  352. // 數據整理
  353. Echart(sensor_name, tid)
  354. // 顯示圖表
  355. };
  356. function downloadFile() {
  357. tid = document.getElementById("tank_num").value
  358. sensor_name = document.getElementById("sensors").value
  359. //藉型別陣列建構的 blob 來建立 URL
  360. let fileName = "ChartData_" + tid + "_" + sensor_name + ".csv";
  361. //"\ufeff"解決打開CSV中文亂碼問題
  362. const data = "\ufeff" + getData();
  363. let blob = new Blob([data], {
  364. type: 'text/csv,charset=UTF-8'
  365. });
  366. var href = URL.createObjectURL(blob);
  367. // 從 Blob 取出資料
  368. var link = document.createElement("a");
  369. document.body.appendChild(link);
  370. link.href = href;
  371. link.download = fileName;
  372. link.click();
  373. };
  374. //所有資料函數
  375. function getData() {
  376. var header = "日期," + data_name + "\n";
  377. var data = "";
  378. var length = all_datetime.length;
  379. for (var i = 0; i < length; i++) {
  380. data = data + all_datetime[i] + ',' + all_data[i] + '\n';
  381. };
  382. return header + data;
  383. };
  384. //最大最小平均資料函數
  385. function getData() {
  386. var header = data_name + "\n日期,";
  387. if (max_data) {
  388. console.log(max_data);
  389. header = header + "最大值,";
  390. };
  391. if (avg_data) {
  392. header = header + "平均值,";
  393. };
  394. if (min_data) {
  395. header = header + "最小值,";
  396. };
  397. header = header + "\n";
  398. var data = "";
  399. var length = xAxis_data.length;
  400. for (var i = 0; i < length; i++) {
  401. data = data + xAxis_data[i] + ',';
  402. if (max_data) {
  403. data = data + max_data[i] + ',';
  404. };
  405. if (avg_data) {
  406. data = data + avg_data[i] + ',';
  407. };
  408. if (min_data) {
  409. data = data + min_data[i] + ',';
  410. };
  411. data = data + '\n';
  412. };
  413. return header + data;
  414. };
  415. </script>
  416. </td>
  417. </tr>
  418. <tr>
  419. <td>
  420. <!--
  421. <img src={{ url }}>
  422. -->
  423. <div id="" class="show-info" style="text-align: center;">
  424. <center>
  425. <div class="show-chart" style="height: 420px; width: 100%; text-align: center;">
  426. 圖表
  427. </div>
  428. </center>
  429. </div>
  430. </td>
  431. </tr>
  432. </table>
  433. <br>
  434. <br>
  435. <!--
  436. </div>
  437. </form>
  438. -->
  439. <div id="coffee_footer">
  440. <!-- 匯入共同使用的 footer.html 內容 -->
  441. {% include 'footer.html' %}
  442. </div>
  443. </div>
  444. </body>
  445. <script>
  446. var all_datetime = 0; // 所有資料時間 ?
  447. var all_data = 0; // 所有感測器數據 ?
  448. var data_name = 0; // 感測器名稱 // "溫溼度"
  449. var xAxis_data = 0; // x 軸資料
  450. var max_data = 0; //
  451. var min_data = 0; //
  452. var avg_data = 0; //
  453. function Echart(sensor_name, tid) {
  454. // Echart(sensor_name, tid)
  455. //將echarts圖形銷毀
  456. $(".show-chart").removeAttr("_echarts_instance_").empty();
  457. // Rita:sensor 與 data_name 重複
  458. // var sensor = evt.substring(2);
  459. if (!$("input[value=avg]").prop('checked') && !$("input[value=min]").prop('checked') && !$("input[value=max]").prop('checked')) {
  460. alert("請至少選擇一種資料類型!");
  461. return false;
  462. };
  463. if ($("#querydate-start").val() == '' || $("#querydate-end").val() == '') {
  464. alert("請選擇日期範圍!");
  465. return false;
  466. };
  467. //基於準備好的dom,初始化echarts例項
  468. var myChart = echarts.init(document.getElementsByClassName('show-chart')[0]); // class="col-10 show-chart"
  469. var date_start = $("#querydate-start").val();
  470. var date_end = $("#querydate-end").val();
  471. var avg = 0;
  472. var max = 0;
  473. var min = 0;
  474. var time_interval = $("select[name=time-interval]").val();
  475. var legend = new Array();
  476. var color = new Array();
  477. var series = new Array();
  478. if ($("input[value=max]").prop('checked')) {
  479. max = 1;
  480. legend.push("最大值");
  481. color.push("#1e88e5"); // 水藍色
  482. };
  483. if ($("input[value=avg]").prop('checked')) {
  484. avg = 1;
  485. legend.push("平均值");
  486. color.push("#43a047"); // 草綠色
  487. };
  488. if ($("input[value=min]").prop('checked')) {
  489. min = 1;
  490. legend.push("最小值");
  491. color.push("#e64a19"); // 橘紅色
  492. };
  493. var json = {
  494. 'tid': tid,
  495. 'sensor_name': sensor_name,
  496. 'avg': avg,
  497. 'max': max,
  498. 'min': min,
  499. 'time-interval': time_interval,
  500. 'date-start': date_start,
  501. 'date-end': date_end
  502. };
  503. console.log('json___' +
  504. 'tid: ' + tid +
  505. 'sensor_name: ' + sensor_name +
  506. 'avg: ' + avg +
  507. 'max: ' + max +
  508. 'min: ' + min +
  509. 'time-interval: ' + time_interval +
  510. 'date-start: ' + date_start +
  511. 'date-end: ' + date_end
  512. )
  513. $.get('/history_data_new', json, function (resText) {
  514. if (resText.max) {
  515. var max_series = {
  516. 'name': '最大值',
  517. 'type': 'scatter',
  518. 'data': resText.max.map(function (item) { return item[1]; }),
  519. 'itemStyle': { 'normal': { 'lineStyle': { 'color': '#1e88e5' } } },
  520. };
  521. series.push(max_series); // 把上面的 dict 加入 series array 內
  522. xAxis_data = resText.max.map(function (item) { return item[0]; });
  523. max_data = resText.max.map(function (item) { return item[1]; });
  524. };
  525. if (resText.avg) {
  526. var avg_series = { 'name': '平均值', 'type': 'scatter', 'data': resText.avg.map(function (item) { return item[1]; }), 'itemStyle': { 'normal': { 'lineStyle': { 'color': '#43a047' } } }, };
  527. series.push(avg_series);
  528. xAxis_data = resText.avg.map(function (item) { return item[0]; });
  529. console.log('xAxis_data' + xAxis_data) // 2021-07-09 10:00:00,2021-07-20 09:00:00,2021-07-22 15:00:00,2021-07-26 15:00:00,2021-07-26 16:00:00
  530. avg_data = resText.avg.map(function (item) { return item[1]; });
  531. console.log('avg_data' + avg_data) // 91.0,98.0,11.0,15.2,30.5
  532. };
  533. if (resText.min) {
  534. var min_series = { 'name': '最小值', 'type': 'scatter', 'data': resText.min.map(function (item) { return item[1]; }), 'itemStyle': { 'normal': { 'lineStyle': { 'color': '#e64a19' } } }, };
  535. series.push(min_series);
  536. xAxis_data = resText.min.map(function (item) { return item[0]; }); // all
  537. min_data = resText.min.map(function (item) { return item[1]; }); // min
  538. };
  539. //獲取日期內所有數據
  540. all_datetime = resText.all.map(function (item) { return item[0]; }); // all
  541. all_data = resText.all.map(function (item) { return item[1]; });
  542. //指定圖表的配置項和資料
  543. option = {
  544. title: {
  545. text: '', // 'Data History'
  546. left: '1%'
  547. },
  548. tooltip: {
  549. trigger: 'axis'
  550. },
  551. color: color,
  552. legend: {
  553. data: legend,
  554. },
  555. xAxis: {
  556. data: xAxis_data,
  557. },
  558. yAxis: {
  559. splitLine: {
  560. show: true,
  561. lineStyle: {
  562. color: ''
  563. }
  564. }
  565. },
  566. toolbox: {
  567. show: true,
  568. feature: {
  569. dataZoom: {
  570. yAxisIndex: 'none'
  571. },
  572. dataView: { readOnly: false },
  573. magicType: { type: ['line', 'bar'] },
  574. restore: {},
  575. saveAsImage: {}
  576. }
  577. },
  578. dataZoom: [{
  579. startValue: '2021-01-01'
  580. }, {
  581. type: 'inside'
  582. }],
  583. series: series,
  584. /*
  585. series: [
  586. {
  587. name: '最大值',
  588. type: 'line',
  589. data: resText.max.map(function (item) {
  590. return item[1];
  591. }),
  592. itemStyle: {
  593. normal: {
  594. lineStyle: {
  595. color: '#1e88e5'
  596. }
  597. }
  598. },
  599. },
  600. {
  601. name: '平均值',
  602. type: 'line',
  603. data: [20.0, 20.0, 20.0, 20.0, 20.0, 20.0],
  604. itemStyle: {
  605. normal: {
  606. lineStyle: {
  607. color: '#43a047'
  608. }
  609. }
  610. },
  611. },
  612. {
  613. name: '最小值',
  614. type: 'line',
  615. data: [15.0, 15.0, 15.0, 15.0, 15.0, 15.0],
  616. itemStyle: {
  617. normal: {
  618. lineStyle: {
  619. color: '#e64a19'
  620. }
  621. }
  622. }
  623. },
  624. ]
  625. */
  626. };
  627. console.log('SHOW myChart')
  628. //使用剛指定的配置項和資料顯示圖表
  629. myChart.setOption(option);
  630. }, 'json');
  631. } // Echart(sensor_name, tid)
  632. </script>
  633. </html>