DataList.html 42 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085
  1. <!DOCTYPE html>
  2. <html class="x-admin-sm">
  3. <head>
  4. <meta charset="UTF-8">
  5. <meta name="renderer" content="webkit">
  6. <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
  7. <meta name="viewport"
  8. content="width=device-width,user-scalable=yes, minimum-scale=0.4, initial-scale=0.8,target-densitydpi=low-dpi"/>
  9. <link rel="shortcut icon" href="/static/favicon.ico">
  10. <link rel="bookmark" href="/static/favicon.ico">
  11. <link rel="stylesheet" href="/static/css/font.css">
  12. <link rel="stylesheet" href="/static/css/xadmin.css">
  13. <script src="/static/js/jquery.min.js"></script>
  14. <script src="/static/js/jquery.cookie.min.js"></script>
  15. <script src="/static/lib/layui/layui.js" charset="utf-8"></script>
  16. <script type="text/javascript" src="/static/js/xadmin.js"></script>
  17. </head>
  18. <body>
  19. <div class="x-nav">
  20. <span class="layui-breadcrumb">
  21. <a href="">首页</a>
  22. <a><cite>数据展示</cite></a>
  23. </span>
  24. <a class="layui-btn layui-btn-normal" style="line-height:1.6em;margin-top:3px;float:right"
  25. onclick="location.reload()" title="刷新">
  26. <i class="layui-icon layui-icon-refresh" style="line-height:30px"></i>
  27. </a>
  28. </div>
  29. <div class="layui-fluid">
  30. <div class="layui-row" style="display: flex;">
  31. <!-- 传感器 选择 start-->
  32. <div style="width: 340px">
  33. <div class="layui-card">
  34. <div class="layui-card-body ">
  35. <form class="layui-form layui-col-space5" οnsubmit="return false;">
  36. <div class="layui-input-inline layui-show-xs-block">
  37. <input value="" type="text" id="D_T_sn" name="D_T_sn" placeholder="请输入 SN"
  38. autocomplete="off"
  39. class="layui-input"></div>
  40. <div class="layui-input-inline layui-show-xs-block">
  41. <input value="" type="text" id="D_Name" name="D_Name" placeholder="请输入 传感器名称"
  42. autocomplete="off"
  43. class="layui-input"></div>
  44. <div class="layui-input-inline layui-show-xs-block" style="width: 168px">
  45. <select id="Class_1" name="Class_1">
  46. <option value=0>所有分类</option>
  47. {{range $index, $elem := .Class_List}}
  48. <option value={{$elem.Id}}>{{$elem.T_name}}</option>
  49. {{end}}
  50. </select>
  51. </div>
  52. <div class="layui-input-inline layui-show-xs-block">
  53. <div class="layui-btn layui-btn-normal"
  54. onclick="get_DeviceSensor_list(0)">
  55. <i class="layui-icon">&#xe615;</i></div>
  56. </div>
  57. </form>
  58. <hr>
  59. </div>
  60. <div class="layui-card-body " style="margin-top: -20px">
  61. <div id="DeviceSensor_list" style="width: 98%; overflow: hidden;max-height: 616px;overflow-y: auto">
  62. <div style="color: #1E9FFF;text-align: center;font-size: 15px;margin-top: 150px">加载中...</div>
  63. </div>
  64. </div>
  65. <div class="layui-card-body ">
  66. <div style="height: 70px">
  67. <div class="layui-card-body " style="text-align: center">
  68. <div class="layui-input-inline layui-show-xs-block">
  69. <div class="layui-btn layui-btn-normal"
  70. onclick="Checkboxs_All()">
  71. <i class="layui-icon">全选择</i>
  72. </div>
  73. </div>
  74. <div class="layui-input-inline layui-show-xs-block">
  75. <div class="layui-btn layui-btn-normal"
  76. onclick="Checkboxs_Allno()">
  77. <i class="layui-icon">全取消</i>
  78. </div>
  79. </div>
  80. <div class="layui-input-inline layui-show-xs-block">
  81. <div class="layui-btn layui-btn-normal"
  82. onclick="Checkboxs_Allto()">
  83. <i class="layui-icon">反选</i>
  84. </div>
  85. </div>
  86. <div style="color: #1E9FFF;text-align: center" id="DeviceSensor_list_Pages_x"></div>
  87. </div>
  88. </div>
  89. </div>
  90. </div>
  91. </div>
  92. <!-- 传感器 选择 end-->
  93. <div style="padding-left: 15px; height: 100%;flex:1;">
  94. <div class="layui-card">
  95. <!-- 传感器数据时间选择 选择 start-->
  96. <div class="layui-card-body ">
  97. <div class="layui-form layui-col-space5" οnsubmit="return false;">
  98. <div class="layui-input-inline layui-show-xs-block">
  99. <div class="layui-btn layui-btn-normal"
  100. onclick="quick_1()">
  101. <i class="layui-icon">今天</i>
  102. </div>
  103. </div>
  104. <div class="layui-input-inline layui-show-xs-block">
  105. <div class="layui-btn layui-btn-normal"
  106. onclick="quick_2()">
  107. <i class="layui-icon">近一周</i>
  108. </div>
  109. </div>
  110. <div class="layui-input-inline layui-show-xs-block">
  111. <div class="layui-btn layui-btn-normal"
  112. onclick="quick_3()">
  113. <i class="layui-icon">近一月</i>
  114. </div>
  115. </div>
  116. <div class="layui-input-inline layui-show-xs-block">
  117. <div class="layui-btn layui-btn-normal"
  118. onclick="quick_4()">
  119. <i class="layui-icon">近一季度</i>
  120. </div>
  121. </div>
  122. <div class="layui-input-inline layui-show-xs-block">
  123. 自定义时间:
  124. </div>
  125. <div class="layui-inline layui-show-xs-block">
  126. <input class="layui-input" autocomplete="off" placeholder="开始日" name="Time_start"
  127. id="Time_start" lay-key="1"></div>
  128. <div class="layui-inline layui-show-xs-block">
  129. <input class="layui-input" autocomplete="off" placeholder="截止日" name="Time_end"
  130. id="Time_end" lay-key="2"></div>
  131. <div class="layui-input-inline layui-show-xs-block">
  132. <div class="layui-btn layui-btn-normal"
  133. onclick="get_DeviceSensor_data(0)">
  134. <i class="layui-icon">&#xe615;</i></div>
  135. </div>
  136. <div class="layui-input-inline layui-show-xs-block" style="float: right">
  137. <button class="layui-btn layui-btn-normal" id="importData">导入数据
  138. </button>
  139. <button class="layui-btn layui-btn-normal" onclick="F_moban()">导入模板说明</button>
  140. </div>
  141. </div>
  142. <hr>
  143. </div>
  144. <!-- 传感器数据时间选择 选择 end-->
  145. <div class="layui-card-body" >
  146. <table class="layui-table ">
  147. <colgroup>
  148. <col width="100">
  149. <col>
  150. <col>
  151. <col>
  152. <col>
  153. <col>
  154. <col>
  155. </colgroup>
  156. <thead>
  157. <tr>
  158. <th>选择</th>
  159. <th>采集时间</th>
  160. <th>温度℃</th>
  161. <th>湿度%</th>
  162. <th>GPS</th>
  163. <th>录入时间</th>
  164. <th>操作</th>
  165. </tr>
  166. </thead>
  167. <tbody id="DeviceSensor_data">
  168. </tbody>
  169. </table>
  170. </div>
  171. <div class="layui-card-body " style="display: flex;justify-content: space-between">
  172. <!--按钮部分 start-->
  173. <div>
  174. <button class="layui-btn layui-btn-normal" onclick="selectAll()">全选</button>
  175. <button class="layui-btn layui-btn-normal" onclick="reverseSelect()">反选</button>
  176. <button class="layui-btn layui-btn-normal" onclick="noSelect()">全不选</button>
  177. <button class="layui-btn layui-btn-danger" onclick="deleteSelect()">删除</button>
  178. </div>
  179. <!--按钮部分 end-->
  180. <!--分页部分 start-->
  181. <div id="pageTool">
  182. </div>
  183. <select id="perPageSelect">
  184. <option value="10">10条/页</option>
  185. <option value="100">100条/页</option>
  186. <option value="300">300条/页</option>
  187. <option value="500">500条/页</option>
  188. <option value="800">800条/页</option>
  189. <option value="1000">1000条/页</option>
  190. </select>
  191. <!-- <input type="number" id="perPageInput" min="1" value="10">-->
  192. <!--分页部分 end-->
  193. </div>
  194. </div>
  195. </div>
  196. </div>
  197. <!--数据记录展示-->
  198. <div id="recordShow" style="display: none">
  199. <table class="layui-table">
  200. <colgroup>
  201. <col width="20px">
  202. <col width="20px">
  203. <col>
  204. <col>
  205. <col>
  206. <col>
  207. </colgroup>
  208. <thead>
  209. <tr>
  210. <th>温度</th>
  211. <th>湿度</th>
  212. <th>GPS</th>
  213. <th>操作人</th>
  214. <th>录入时间</th>
  215. <th>操作</th>
  216. </tr>
  217. </thead>
  218. <tbody id="recordTableBody"></tbody>
  219. </table>
  220. </div>
  221. </div>
  222. </body>
  223. <script>
  224. let uploadInst
  225. //获取GET
  226. function getPar(par) {
  227. //获取当前URL
  228. var local_url = document.location.href;
  229. //获取要取得的get参数位置
  230. var get = local_url.indexOf(par + "=")
  231. ;
  232. if (get == -1) {
  233. return false;
  234. }
  235. //截取字符串
  236. //截取字符串
  237. var get_par = local_url.slice(par.length + get + 1);
  238. //判断截取后的字符串是否还有其他get参数
  239. var nextPar = get_par.indexOf("&")
  240. ;
  241. if (nextPar != -1) {
  242. get_par = get_par.slice(0, nextPar);
  243. }
  244. return get_par;
  245. }
  246. function ChangeDiv(e) {
  247. // var divs = document.getElementsByClassName("ChangeDiv");
  248. // var len = divs.length;
  249. // for(var i=0;i<len;i++){
  250. // divs[i].style.border = "1px solid #ffffff";
  251. // }
  252. // e.style.border = "1px solid #ed0000";
  253. }
  254. // 今天
  255. function quick_1() {
  256. var myDate = new Date();
  257. y = myDate.getFullYear(); //获取当前年份(2位)
  258. m = myDate.getMonth() + 1; //获取当前月份(0-11,0代表1月)
  259. d = myDate.getDate(); //获取当前日(1-31)
  260. console.log(y + "-" + m + "-" + d)
  261. Time_start = y + "-" + m + "-" + d + " 00:00:00"
  262. Time_end = y + "-" + m + "-" + d + " 23:59:59"
  263. $("#Time_start").val(Time_start)
  264. $("#Time_end").val(Time_end)
  265. get_DeviceSensor_data(0)
  266. }
  267. // 近一周
  268. function quick_2() {
  269. var myDate = new Date();
  270. y = myDate.getFullYear(); //获取当前年份(2位)
  271. m = myDate.getMonth() + 1; //获取当前月份(0-11,0代表1月)
  272. d = myDate.getDate(); //获取当前日(1-31)
  273. console.log(y + "-" + m + "-" + d)
  274. Time_end = y + "-" + m + "-" + d + " 23:59:59"
  275. $("#Time_end").val(Time_end)
  276. myDate = myDate.setDate(myDate.getDay() - 6);
  277. myDate = new Date(myDate);
  278. y = myDate.getFullYear(); //获取当前年份(2位)
  279. m = myDate.getMonth() + 1; //获取当前月份(0-11,0代表1月)
  280. d = myDate.getDate(); //获取当前日(1-31)
  281. Time_start = y + "-" + m + "-" + d + " 00:00:00"
  282. $("#Time_start").val(Time_start)
  283. get_DeviceSensor_data(0)
  284. }
  285. // 近一月
  286. function quick_3() {
  287. var myDate = new Date();
  288. y = myDate.getFullYear(); //获取当前年份(2位)
  289. m = myDate.getMonth() + 1; //获取当前月份(0-11,0代表1月)
  290. d = myDate.getDate(); //获取当前日(1-31)
  291. console.log(y + "-" + m + "-" + d)
  292. Time_end = y + "-" + m + "-" + d + " 23:59:59"
  293. $("#Time_end").val(Time_end)
  294. myDate = myDate.setDate(myDate.getDate() - 30);
  295. myDate = new Date(myDate);
  296. y = myDate.getFullYear(); //获取当前年份(2位)
  297. m = myDate.getMonth() + 1; //获取当前月份(0-11,0代表1月)
  298. d = myDate.getDate(); //获取当前日(1-31)
  299. Time_start = y + "-" + m + "-" + d + " 00:00:00"
  300. $("#Time_start").val(Time_start)
  301. get_DeviceSensor_data(0)
  302. }
  303. // 近一季度
  304. function quick_4() {
  305. var myDate = new Date();
  306. y = myDate.getFullYear(); //获取当前年份(2位)
  307. m = myDate.getMonth() + 1; //获取当前月份(0-11,0代表1月)
  308. d = myDate.getDate(); //获取当前日(1-31)
  309. console.log(y + "-" + m + "-" + d)
  310. Time_end = y + "-" + m + "-" + d + " 23:59:59"
  311. $("#Time_end").val(Time_end)
  312. myDate = myDate.setDate(myDate.getDate() - 30 * 3);
  313. myDate = new Date(myDate);
  314. y = myDate.getFullYear(); //获取当前年份(2位)
  315. m = myDate.getMonth() + 1; //获取当前月份(0-11,0代表1月)
  316. d = myDate.getDate(); //获取当前日(1-31)
  317. Time_start = y + "-" + m + "-" + d + " 00:00:00"
  318. $("#Time_start").val(Time_start)
  319. get_DeviceSensor_data(0)
  320. }
  321. layui.use(['laydate', 'form', 'element'],
  322. function () {
  323. var laydate = layui.laydate;
  324. //执行一个laydate实例
  325. laydate.render({
  326. elem: '#Time_start' //指定元素
  327. , type: 'datetime'
  328. });
  329. //执行一个laydate实例
  330. laydate.render({
  331. elem: '#Time_end' //指定元素
  332. , type: 'datetime'
  333. });
  334. var element = layui.element;
  335. element.length = 30
  336. });
  337. var T_name = ""
  338. var T_sn = ""
  339. var T_class_id = 0
  340. var T_id = 0
  341. var T_sn_T_id = ""
  342. var Time_start = ""
  343. var Time_end = ""
  344. var DeviceSensor_lite = []
  345. var DeviceSensor_data = []
  346. var DeviceSensor_snid_list = ""
  347. /// --------------- 传感器列表
  348. // 页面 加载完成后执行
  349. window.onload = function () {
  350. console.log("页面 加载完成后执行")
  351. quick_1()
  352. get_DeviceSensor_list(0)
  353. }
  354. //获取div中所有的复选框 .value
  355. var checkboxs = document.getElementsByClassName("checkboxxx");
  356. function Checkboxs_All() {
  357. for (var i = 0; i < checkboxs.length; i++) {
  358. checkboxs[i].checked = true
  359. }
  360. }
  361. function Checkboxs_Allno() {
  362. for (var i = 0; i < checkboxs.length; i++) {
  363. checkboxs[i].checked = false
  364. }
  365. }
  366. function Checkboxs_Allto() {
  367. for (var i = 0; i < checkboxs.length; i++) {
  368. if (checkboxs[i].checked) {
  369. checkboxs[i].checked = false
  370. } else {
  371. checkboxs[i].checked = true
  372. }
  373. }
  374. }
  375. function Checkboxs_GetAll() {
  376. DeviceSensor_snid_list = ""
  377. for (var i = 0; i < checkboxs.length; i++) {
  378. if (checkboxs[i].checked) {
  379. DeviceSensor_snid_list = DeviceSensor_snid_list + checkboxs[i].value + "|"
  380. }
  381. }
  382. }
  383. function get_DeviceSensor_list(page) {
  384. T_sn = $("#D_T_sn").val();
  385. T_name = $("#D_Name").val();
  386. T_class_id = $("#Class_1").val();
  387. $.ajax({
  388. type: 'POST',
  389. url: '/Data/Device_Sensor_List',//发送请求
  390. data: {
  391. User_tokey: $.cookie("User_tokey"),
  392. T_sn: T_sn,
  393. T_name: T_name,
  394. T_class_id: parseInt(T_class_id),
  395. page: page,
  396. page_z: 1000,
  397. },
  398. success: function (result) {
  399. console.log(result)
  400. if (result.Code == 200) {
  401. if (page == 0)
  402. $('#DeviceSensor_list').html("")
  403. // $('#DeviceSensor_list_Pages').html("")
  404. // $('#DeviceSensor_list_Pages_x').html("")
  405. DeviceSensor_lite = result.Data.DeviceSensor_lite
  406. if (DeviceSensor_lite.length == 0) {
  407. $('#DeviceSensor_list').html("<div style=\"color: #1E9FFF;text-align: center;font-size: 15px;margin-top: 150px\">没有设备</div>")
  408. return
  409. }
  410. Add_DeviceSensor_list(result.Data.DeviceSensor_lite) // 列表
  411. // Add_DeviceSensor_list_Pages(result.Data.Pages) // 分页
  412. $('#DeviceSensor_list_Pages_x').html(" 传感器 总数:" + result.Data.Num);
  413. if (result.Data.Page_size > result.Data.Page) {
  414. get_DeviceSensor_list(result.Data.Page + 1)
  415. }
  416. } else {
  417. }
  418. }
  419. });
  420. return false
  421. }
  422. //选择所有选择框
  423. let sensors = []
  424. function selectAll() {
  425. sensors = []
  426. $('#DeviceSensor_data > tr > td > input[type="checkbox"]').each((i, e) => {
  427. $(e).prop('checked', true)
  428. })
  429. }
  430. //反选
  431. function reverseSelect() {
  432. sensors = []
  433. $('#DeviceSensor_data > tr > td > input[type="checkbox"]').each((i, e) => {
  434. $(e).prop('checked', !$(e).prop('checked'))
  435. })
  436. }
  437. //全不选
  438. function noSelect() {
  439. sensors = []
  440. $('#DeviceSensor_data > tr > td > input[type="checkbox"]').each((i, e) => {
  441. $(e).prop('checked', false)
  442. })
  443. }
  444. //删除所选择的内容
  445. function deleteSelect() {
  446. //获取选择的行
  447. sensors = []
  448. $('#DeviceSensor_data > tr > td > input[type="checkbox"]').each((i, e) => {
  449. if ($(e).prop('checked')) {
  450. let t = {
  451. t_sn: $(e).attr('data-sn'),
  452. t_id: Number.parseInt($(e).attr('data-id')),
  453. t_t: Number.parseFloat($(e).attr('data-tt')),
  454. t_rh: Number.parseFloat($(e).attr('data-trh')),
  455. t_site: $(e).attr('data-site'),
  456. }
  457. sensors.push(t)
  458. }
  459. })
  460. console.log(sensors)
  461. if (sensors.length == 0) {
  462. layui.layer.msg('没有选中要删除的记录哦!')
  463. return
  464. }
  465. layui.layer.confirm(`是否删除选中${sensors.length}条记录`, {title: '删除记录'}, function (index) {
  466. $.ajax({
  467. type: "POST",
  468. url: '/Data/Device_Sensor_List_Delete',
  469. data: JSON.stringify(sensors),
  470. cookie: $.cookie("User_tokey"),
  471. contentType: 'application/json;charset=utf-8',
  472. success: function (rlt) {
  473. if (rlt.Code == 200) {
  474. layui.layer.msg(`删除${sensors.length}条数据成功!`)
  475. get_DeviceSensor_data(0)
  476. } else {
  477. layui.layer.msg(rlt.Msg)
  478. }
  479. }
  480. })
  481. layui.layer.close(index);
  482. });
  483. }
  484. //删除当前行,当当前行按钮被点击后
  485. function deleteOne(e) {
  486. e = $(e).parent().prevAll()
  487. e = e[e.length - 1]
  488. e = $(e).children()[0]
  489. console.log(e,"==============")
  490. let t = {
  491. t_sn: $(e).attr('data-sn'),
  492. t_id: Number.parseInt($(e).attr('data-id')),
  493. t_t: Number.parseFloat($(e).attr('data-tt')),
  494. t_rh: Number.parseFloat($(e).attr('data-trh')),
  495. t_site: $(e).attr('data-site'),
  496. User_tokey: $.cookie("User_tokey")
  497. }
  498. layui.layer.confirm(`是否删除选中 sn: ${t.t_sn} 1 条记录`, {title: '删除记录'}, function (index) {
  499. $.ajax({
  500. type: "POST",
  501. url: '/Data/Device_Sensor_List_Delete',
  502. data: JSON.stringify([t]),
  503. contentType: 'application/json;charset=utf-8',
  504. success: function (rlt) {
  505. if (rlt.Code == 200) {
  506. layui.layer.msg(`删除1条数据成功!`)
  507. get_DeviceSensor_data(0)
  508. } else {
  509. layui.layer.msg(rlt.Msg)
  510. }
  511. }
  512. })
  513. layui.layer.close(index);
  514. });
  515. }
  516. function Add_DeviceSensor_list(DS_lite) {
  517. for (let i = 0; i < DS_lite.length; i++) {
  518. if (T_id == 0) {
  519. T_id = DS_lite[i].T_id;
  520. T_sn_T_id = DS_lite[i].T_sn;
  521. get_DeviceSensor_data(0)
  522. }
  523. $('#DeviceSensor_list').append("" +
  524. "<div class=\"layui-col ChangeDiv\" onclick=\"ChangeDiv(this);T_id = " + DS_lite[i].T_id + ";T_sn_T_id = '" + DS_lite[i].T_sn + "';\" \n" +
  525. " style=\"border: 1px solid #ffffff;height: 52px;background-color: #fafafa;border-radius:5px;padding-top: 2px;margin-top: 6px;\">\n" +
  526. " <input type=\"checkbox\" name='checkboxxx' class='checkboxxx' value='" + DS_lite[i].T_sn + "," + DS_lite[i].T_id + "' style='float: left;width: 18px;height: 18px;margin-top: 16px;margin-left: 10px;'/>" +
  527. "<img style=\"float: left;width: 50px;margin: 0px 10px\" src=\"/static/images/温湿度传感器-1.png\"\n" +
  528. " height=\"50\"\n" +
  529. " width=\"40\"/>\n" +
  530. " <div style=\"float: left;\">\n" +
  531. " <div style=\"margin-top: 4px;font-size: 14px;height: 24px;\">" + DS_lite[i].T_name + "</div>\n" +
  532. " <div style=\"margin-top: -3px;font-size: 12px\">SN:" + DS_lite[i].T_sn + " [" + DS_lite[i].T_id + "]</div>\n" +
  533. " </div>\n" +
  534. " <div class=\"layui-card-header\"\n" +
  535. " style=\"float: right;padding-left: 0px;padding-top: 6px;color: #1E9FFF\">\n" +
  536. " \n" +
  537. " </div>\n" +
  538. " </div>")
  539. }
  540. }
  541. $('#perPageSelect').on('change', function() {
  542. let itemsPerPage = $(this).val();
  543. get_DeviceSensor_data(0, itemsPerPage); // 调用获取数据函数,传入新的每页条数
  544. });
  545. // 如果是输入框,则可能需要验证用户输入并做相应的处理
  546. $('#perPageInput').on('input', function() {
  547. let itemsPerPage = parseInt($(this).val());
  548. if (!isNaN(itemsPerPage)) {
  549. get_DeviceSensor_data(0, itemsPerPage);
  550. } else {
  551. alert('请输入有效的数字!');
  552. $(this).val('10'); // 重置为默认值
  553. }
  554. });
  555. function get_DeviceSensor_data(page,itemsPerPage) {
  556. if ($("#Time_start").val().length > 0) {
  557. Time_start = $("#Time_start").val();
  558. } else {
  559. Time_start = ""
  560. }
  561. if ($("#Time_end").val().length > 0) {
  562. Time_end = $("#Time_end").val();
  563. } else {
  564. Time_end = ""
  565. }
  566. Checkboxs_GetAll()
  567. var loading = layer.load(0, {
  568. shade: false,
  569. time: 99 * 1000
  570. });
  571. $.ajax({
  572. type: 'POST',
  573. url: 'Device_Sensor_Data_More',//发送请求
  574. data: {
  575. User_tokey: $.cookie("User_token"),
  576. Time_start: Time_start,
  577. Time_end: Time_end,
  578. T_snid: DeviceSensor_snid_list,
  579. page: page,
  580. page_z: itemsPerPage,
  581. },
  582. success: function (result) {
  583. console.log(result)
  584. layer.close(loading)
  585. if (result.Code == 200) {
  586. $('#DeviceSensor_data').html("")
  587. $('#DeviceSensor_data_Pages').html("")
  588. $('#DeviceSensor_data_Pages_x').html("")
  589. DeviceSensor_data = result.Data.list
  590. if (DeviceSensor_data.length == 0) {
  591. $('#DeviceSensor_data').html("<div style=\"color: #1E9FFF;text-align: center;font-size: 15px;margin-top: 150px\">没有数据</div>")
  592. return
  593. }
  594. addDeviceSensorData(result.Data.list)
  595. addDeviceSensorDataPage(result.Data,itemsPerPage)
  596. } else {
  597. }
  598. }
  599. });
  600. return false
  601. }
  602. function f_Device_Sensor_Data_Pu_data(Sn, tap, num, id) {
  603. $.ajax({
  604. type: 'POST',
  605. url: 'Device_Sensor_Data_Pu_data',//发送请求
  606. data: {
  607. Sn: Sn,
  608. tap: tap,
  609. num: num,
  610. id: id,
  611. },
  612. success: function (result) {
  613. if (result.Code != 200) {
  614. layer.msg(result.Msg);
  615. }
  616. }
  617. });
  618. }
  619. function f_Device_Sensor_Data_Del_data(Sn, id) {
  620. $.ajax({
  621. type: 'POST',
  622. url: 'Device_Sensor_Data_Del_data',//发送请求
  623. data: {
  624. Sn: Sn,
  625. id: id,
  626. },
  627. success: function (result) {
  628. if (result.Code != 200) {
  629. layer.msg(result.Msg);
  630. }
  631. get_DeviceSensor_data(0)
  632. }
  633. });
  634. }
  635. function ShowElement(element) {
  636. var oldhtml = element.innerHTML;
  637. var newobj = document.createElement('input');
  638. //创建新的input元素
  639. newobj.type = 'text';
  640. //为新增元素添加类型
  641. console.log(oldhtml)
  642. console.log(element.dataset.th)
  643. console.log(element.dataset.sn)
  644. console.log(element.dataset.id)
  645. newobj.value = oldhtml
  646. newobj.onblur = function () {
  647. console.log(this.value)
  648. element.innerHTML = this.value ? this.value : oldhtml;
  649. if (element.dataset.th == 1) {
  650. f_Device_Sensor_Data_Pu_data(element.dataset.sn, "t_t", this.value, element.dataset.id)
  651. } else {
  652. f_Device_Sensor_Data_Pu_data(element.dataset.sn, "t_rh", this.value, element.dataset.id)
  653. }
  654. //当触发时判断新增元素值是否为空,为空则不修改,并返回原有值
  655. }
  656. element.innerHTML = '';
  657. element.appendChild(newobj);
  658. newobj.focus();
  659. }
  660. //分页添加
  661. function addDeviceSensorDataPage(pageInfo,itemsPerPage) {
  662. let start, end
  663. start = pageInfo.currentPage - 5 < 1 ? 1 : pageInfo.currentPage - 5
  664. end = pageInfo.currentPage + 5 > pageInfo.totalPage ? pageInfo.totalPage : pageInfo.currentPage + 5
  665. end = end + Math.abs(end - start - 10) > pageInfo.totalPage ? pageInfo.totalPage : end + Math.abs(end - start - 10)
  666. $('#pageTool').html('')
  667. $('#pageTool').append(`<span style="padding: 0 10px;color: #0bace6">共${pageInfo.totalPage}页 / 当前${pageInfo.currentPage}页 共${pageInfo.totalCount}条数据</span>`)
  668. //上一页
  669. if (pageInfo.previousPage) {
  670. $('#pageTool').append(`<button class="layui-btn layui-btn-primary layui-btn-sm" onclick="get_DeviceSensor_data(${pageInfo.currentPage - 1},${itemsPerPage})">上一页</button>`)
  671. } else {
  672. $('#pageTool').append(`<button class="layui-btn layui-btn-disabled layui-btn-primary layui-btn-sm">上一页</button>`)
  673. }
  674. //页码
  675. for (; start <= end; start++) {
  676. if (start == pageInfo.currentPage) {
  677. $('#pageTool').append(`<button class="layui-btn layui-btn-disabled layui-btn-primary layui-btn-sm">${start}</button>`)
  678. } else {
  679. $('#pageTool').append(`<button class="layui-btn layui-btn-primary layui-btn-sm" onclick="get_DeviceSensor_data(${start},${itemsPerPage})">${start}</button>`)
  680. }
  681. }
  682. //下一页
  683. if (pageInfo.nextPage) {
  684. $('#pageTool').append(`<button class="layui-btn layui-btn-primary layui-btn-sm" onclick="get_DeviceSensor_data(${pageInfo.currentPage + 1},${itemsPerPage})">下一页</button>`)
  685. } else {
  686. $('#pageTool').append(`<button class="layui-btn layui-btn-disabled layui-btn-primary layui-btn-sm">下一页</button>`)
  687. }
  688. }
  689. //添加设备数据
  690. function addDeviceSensorData(list) {
  691. let style
  692. for (let v of list) {
  693. if (v.t_t < v.t_tl || v.t_rh < v.t_rhl) {
  694. style = 'style="background-color: #a8f7ff'
  695. }
  696. if (v.t_t > v.t_tu || v.t_rh > v.t_rhu) {
  697. style = 'style="background-color: #ff8585'
  698. }
  699. $('#DeviceSensor_data').append(`
  700. <tr>
  701. <td><input type="checkbox" class="layui-form-checkbox" data-sn="${v.t_sn}" data-id="${v.t_id}" data-tt="${v.t_t}" data-trh="${v.t_rh}" data-site="${v.t_site}" data-createTime="${v.create_time}"/></td>
  702. <td ondblclick="changeData(this)" data-type="t_time">${v.t_time}</td>
  703. <td ondblclick="changeData(this)" data-type="t_t">${v.t_t}</td>
  704. <td ondblclick="changeData(this)" data-type="t_rh">${v.t_rh}</td>
  705. <td ondblclick="changeData(this)" data-type="t_site">${v.t_site}</td>
  706. <td ondblclick="changeData(this)" data-type="create_time">${v.create_time}</td>
  707. <td>
  708. <button class="layui-btn layui-btn-danger layui-btn-sm" onclick="deleteOne(this)">删除</button>
  709. <button class="layui-btn layui-bg-blue layui-btn-sm" onclick="copyAndAdds(this, '${v.t_sn}', ${v.t_id}, ${v.t_t}, ${v.t_rh}, '${v.t_site}', '${v.create_time}')">复制添加</button>
  710. </td>
  711. </tr>
  712. `)
  713. /*
  714. <button class="layui-btn layui-btn-normal layui-btn-sm" onclick="showRecord(this)">记录</button>
  715. */
  716. }
  717. }
  718. // 新增copyAndAdd函数实现复制并添加新行
  719. function copyAndAdds(button, t_sn, t_id, t_t, t_rh, t_site, create_time) {
  720. // 准备发送给后端的数据对象
  721. let dataToSend = {
  722. t_sn: t_sn,
  723. t_id: t_id,
  724. t_t: t_t,
  725. t_rh: t_rh,
  726. t_site: t_site,
  727. createTime: create_time
  728. };
  729. // 提交数据到后端
  730. $.ajax({
  731. url: '/Device/Device_Copy', // 替换为你的后端接口地址
  732. type: 'POST',
  733. contentType: 'application/json',
  734. data: JSON.stringify(dataToSend),
  735. success: function(response) {
  736. console.log("数据提交成功,响应:", response.Data);
  737. // 假设后端返回了新行ID或者其他需要的数据,这里可以根据需要处理response
  738. let newRowId = response.id; // 假设后端返回了新行的唯一ID
  739. // 根据后端返回的数据(如果有的话)来构造新行的HTML
  740. let newRowHtml = `
  741. <tr class="new-row" data-id="${response.id}" style="background-color: #f0f8ff; border-left: 4px solid #007bff;">
  742. <td>
  743. <input
  744. type="checkbox"
  745. class="layui-form-checkbox"
  746. data-sn="${response.Data.t_sn}"
  747. data-id="${response.Data.t_id}"
  748. data-tt="${response.Data.t_t}"
  749. data-trh="${response.Data.t_rh}"
  750. data-site="${response.Data.t_site}"
  751. data-createTime="${response.Data.createTime}"
  752. />
  753. </td>
  754. <td ondblclick="changeData(this)" data-type="t_time" style="color: #007bff;">${response.Data.createTime}</td>
  755. <td ondblclick="changeData(this)" data-type="t_t" style="color: #007bff;">${response.Data.t_t}</td>
  756. <td ondblclick="changeData(this)" data-type="t_rh" style="color: #007bff;">${response.Data.t_rh}</td>
  757. <td ondblclick="changeData(this)" data-type="t_site" style="color: #007bff;">${response.Data.t_site}</td>
  758. <td ondblclick="changeData(this)" data-type="create_time" style="color: #007bff;">${response.Data.createTime}</td>
  759. <td>
  760. <button class="layui-btn layui-btn-danger layui-btn-sm" onclick="deleteOne(this)">删除</button>
  761. <button class="layui-btn layui-bg-blue layui-btn-sm" onclick="copyAndAdds(this, '${t_sn}', ${t_id}, ${t_t}, ${t_rh}, '${t_site}', '${create_time}')">复制添加</button>
  762. <!-- 注意:此处可能不需要再提供复制添加按钮,因为数据已持久化 -->
  763. </td>
  764. </tr>
  765. `;
  766. // 在当前行的下一行兄弟元素(下一行)之前插入新行
  767. $(button).closest('tr').after(newRowHtml);
  768. // 这里可以添加成功后的其他操作,如提示用户、更新界面等
  769. },
  770. error: function(jqXHR, textStatus, errorThrown) {
  771. console.error("数据提交失败:", textStatus, errorThrown);
  772. // 处理错误情况,比如提示用户
  773. alert("数据提交失败,请重试!");
  774. }
  775. });
  776. }
  777. function showRecord(e) {
  778. e = $(e).parent().prevAll()
  779. e = e[e.length - 1]
  780. e = $(e).children()[0]
  781. console.log(e)
  782. $.ajax({
  783. type: "post",
  784. url: "/Data/Device_Sensor_Record",
  785. data: {
  786. sn: $(e).attr('data-sn'),
  787. tId: $(e).attr('data-id'),
  788. createTime: $(e).attr('data-createTime')
  789. },
  790. success: function (rlt) {
  791. if (rlt.Code === 200) {
  792. if (rlt.Data == null) {
  793. layui.layer.msg("没有数据!")
  794. return
  795. }
  796. for (let v of rlt.Data) {
  797. $('#tableBody').append(`
  798. <tr>
  799. <td>${v.t_t}</td>
  800. <td>${v.t_rh}</td>
  801. <td>${v.t_site}</td>
  802. <td>${v.t_uuid}</tdj>
  803. <td>${v.create_time}</td>
  804. <td>
  805. <button class="layui-btn layui-btn-normal" onclick="">更新</button>
  806. </td>
  807. </tr>
  808. `)
  809. }
  810. layui.layer.open({
  811. type: 1,
  812. area: ['1200px', '800px'],
  813. content: $('#recordShow'),
  814. isOutAnim: true
  815. })
  816. }
  817. }
  818. })
  819. }
  820. //双击表格改变值
  821. function changeData(even) {
  822. let e = $(even).prevAll()
  823. console.log(e)
  824. e = $(e[e.length - 1]).children()[0]
  825. console.log(e)
  826. let t = {
  827. t_sn: $(e).attr('data-sn'),
  828. t_id: Number.parseInt($(e).attr('data-id')),
  829. t_t: Number.parseFloat($(e).attr('data-tt')),
  830. t_rh: Number.parseFloat($(e).attr('data-trh')),
  831. t_site: $(e).attr('data-site'),
  832. }
  833. let type = $(even).attr('data-type')
  834. console.log(t)
  835. let input = $(`<input class="layui-input" type="text" value="${even.innerText}">`)
  836. input[0].onblur = function () {
  837. t["type"] = type
  838. t["value"] = $(this).val()
  839. t["User_tokey"] = $.cookie("User_tokey")
  840. if (t[type] == t.value) {
  841. } else {
  842. $.ajax({
  843. type: "POST",
  844. url: "/Data/Device_Sensor_Update",
  845. data: t,
  846. cookie: $.cookie("User_token"),
  847. success: function (rlt) {
  848. console.log(rlt)
  849. }
  850. })
  851. }
  852. console.log(t)
  853. even.innerHTML = this.value
  854. $(e).attr(`data-${type}`, $(this).val())
  855. }
  856. $(even).html('')
  857. $(even).append(input)
  858. input.focus()
  859. }
  860. //点击上传按钮
  861. layui.use('upload', function () {
  862. let upload = layui.upload;
  863. //执行实例
  864. let uploadInst = upload.render({
  865. elem: '#importData',
  866. url: '/Data/importData' //上传接口
  867. , accept: 'file',
  868. data: {
  869. User_tokey: $.cookie("User_tokey"),
  870. }
  871. , field: 'file'
  872. , done: function (res) {
  873. layui.layer.msg(res.Msg)
  874. // layui.layer.close(index)
  875. }
  876. , error: function () {
  877. //请求异常回调
  878. layui.layer.msg('上传错误!')
  879. }
  880. })
  881. })
  882. //导出数据
  883. function exportData() {
  884. }
  885. function Add_DeviceSensor_data(DS_lite) {
  886. console.log(DS_lite)
  887. for (let i = 0; i < DS_lite.length; i++) {
  888. style_s = ""
  889. if (DS_lite[i].T_t < DS_lite[i].T_Tlower || DS_lite[i].T_rh < DS_lite[i].T_RHlower) {
  890. style_s = " style='background-color: #a8f7ff' "
  891. }
  892. if (DS_lite[i].T_t > DS_lite[i].T_Tupper || DS_lite[i].T_rh > DS_lite[i].T_RHupper) {
  893. style_s = " style='background-color: #ff8585' "
  894. }
  895. $('#DeviceSensor_data').append("" +
  896. "<tr " + style_s + ">\n" +
  897. // " <td>"+DS_lite[i].T_sn+"</td>\n" +
  898. " <td>" + DS_lite[i].T_name + " [" + DS_lite[i].T_id + "]</td>\n" +
  899. " <td ondblclick=\"ShowElement(this)\" data-th=1 data-sn=\"" + DS_lite[i].T_sn + "\" data-id=" + DS_lite[i].T_id + " >" + DS_lite[i].T_t + "</td>\n" +
  900. " <td ondblclick=\"ShowElement(this)\" data-th=2 data-sn=\"" + DS_lite[i].T_sn + "\" data-id=" + DS_lite[i].T_id + " >" + DS_lite[i].T_rh + "</td>\n" +
  901. " <td>" + DS_lite[i].T_tl + "~" + DS_lite[i].T_tu + "</td>\n" +
  902. " <td>" + DS_lite[i].T_rhl + "~" + DS_lite[i].T_rhu + "</td>\n" +
  903. " <td>" + DS_lite[i].T_time + "</td>\n" +
  904. " <td> <span class='layui-btn layui-btn-danger' onclick='f_Device_Sensor_Data_Del_data(\"" + DS_lite[i].T_sn + "\"," + DS_lite[i].ID + ")'>删除</span>" + `<span class='layui-btn layui-btn-normal'>记录</span>` + "</td>\n" +
  905. "</tr>")
  906. }
  907. }
  908. function Add_DeviceSensor_data_Pages(Pages) {
  909. for (let i = 0; i < Pages.length; i++) {
  910. elem = Pages[i]
  911. switch (elem.A) {
  912. case 1:
  913. $('#DeviceSensor_data_Pages').append("<a class=\"prev\" onclick='get_DeviceSensor_data(" + elem.V + ")' >&lt;&lt;</a>\n");
  914. break;
  915. case 2:
  916. $('#DeviceSensor_data_Pages').append("<a class=\"num\" onclick='get_DeviceSensor_data(" + elem.V + ")' >" + elem.V + "</a>\n");
  917. break;
  918. case 3:
  919. $('#DeviceSensor_data_Pages').append("<span class=\"current\">" + elem.V + "</span>\n");
  920. break;
  921. case 4:
  922. $('#DeviceSensor_data_Pages').append("<a class=\"num\" onclick='get_DeviceSensor_data(" + elem.V + ")' >" + elem.V + "</a>\n");
  923. break;
  924. case 5:
  925. $('#DeviceSensor_data_Pages').append("<a class=\"next\" onclick='get_DeviceSensor_data(" + elem.V + ")' >&gt;&gt;</a>\n");
  926. break;
  927. }
  928. }
  929. }
  930. function get_DeviceSensor_Excel() {
  931. if ($("#Time_start").val().length > 0) {
  932. Time_start = $("#Time_start").val();
  933. } else {
  934. Time_start = ""
  935. }
  936. if ($("#Time_end").val().length > 0) {
  937. Time_end = $("#Time_end").val();
  938. } else {
  939. Time_end = ""
  940. }
  941. Checkboxs_GetAll()
  942. var loading = layer.load(0, {
  943. shade: false,
  944. time: 99 * 1000
  945. });
  946. $.ajax({
  947. type: 'POST',
  948. url: 'Device_Sensor_Data_Excel',//发送请求
  949. data: {
  950. User_tokey: $.cookie("User_tokey"),
  951. Time_start: Time_start,
  952. Time_end: Time_end,
  953. T_snid: DeviceSensor_snid_list,
  954. },
  955. success: function (result) {
  956. console.log(result)
  957. layer.close(loading)
  958. if (result.Code != 200) {
  959. layer.msg(result.Msg);
  960. return
  961. }
  962. window.location.href = result.Data;
  963. }
  964. });
  965. return false
  966. }
  967. function F_moban() {
  968. layer.open({
  969. title: '导入模版'
  970. ,content: '1、根据模板格式 导入数据 <a href="/static/20240523140020.xlsx" style="color: #1E9FFF">点击下载模版</a><hr>'+
  971. '2、导入文件名为 SN编号,如 2024xxxxxxxxxx.xlsx <hr>'
  972. });
  973. }
  974. </script>
  975. </html>