layui定時刷新數據表格 · php開發筆記

``` <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>配件提示刷新功能</title> <script src="../assets/js/jquery/jquery-3.2.1.min.js"></script> <link rel="stylesheet" href="layui/lib/layui-v2.5.4/css/layui.css" media="all"> </head> <body>  <table id="dataTable" lay-filter="dataTable"></table> <script src="layui/lib/jquery-3.4.1/jquery-3.4.1.min.js" charset="utf-8"></script> <script src="layui/lib/layui-v2.5.4/layui.js" charset="utf-8"></script> <script src="layui/lib/jq-module/jquery.particleground.min.js" charset="utf-8"></script> <script> layui.use(['layer', 'form', 'table'], function () { var $ = layui.jquery; var layer = layui.layer; var form = layui.form; var table = layui.table; /* 渲染表格 */ var cols = [ {field: 'docNo',width:180, title: '單號', align: 'left'}, {field: 'createName',width:120, title: '需求人', align: 'left'}, {field: 'supName', title: '客戶', align: 'left'}, {field: 'whName',width:200, title: '倉庫', align: 'left'}, {field: 'whArea',width:60, title: '區域', align: 'left'}, {field: 'createTime',width:200, title: '時間', align: 'left'}, { field: 'docStatus',width:200, title: '單據狀態', align: 'left', templet: function (d) { if (d.docStatus === '0') { return "<span style='color: #bf81f5;'>待倉庫確認</span>"; } else if (d.docStatus === '1') { return "<span style='color: #81f5e4;'>倉庫已確認，正在揀貨中</span>"; } else if (d.docStatus === '2') { return "<span style='color: #81f58d;'>倉庫揀貨完成</span>"; } else if (d.docStatus === '4') { return "<span style='color: #f581b1;'>該位置無負責人揀貨</span>"; } else { return ""; } } }, {field: 'pickName',width:120, title: '揀貨員', align: 'left'}, ]; let whCode = getUrlParam("whCode"); var nowCurr=0; var nowCount=0; var insTb = table.render({ elem: '#dataTable', url: '/a/api/ship/getShipPatrsAllData?whCode=' + whCode, page: true, toolbar: false, cellMinWidth: 100, limits: [10, 11, 12, 13, 14, 18, 19, 20, 50], limit:17, cols: [cols], done: function (res, curr, count) { //隱藏下面的分頁 $(".layui-table-page").css("display","none"); //拿到當前每頁的分頁總數 let limitCount = insTb.config.limit; //總數除以每頁要顯示的數據可以拿到要分多少次頁 let result=Math.ceil(count/limitCount); nowCurr=curr+1; nowCount=count; //如果大于最大的分頁，則直接把分頁重新設置為1，則從第一頁重新開始刷新 if (result<nowCurr){ nowCurr=1; } } }); var time = setInterval(function() { if (nowCount>0){ insTb.reload({page: {curr: nowCurr}}); } }, 120000); }); function getUrlParam(name) { var reg = new RegExp("(^|&)" + name + "=([^&]*)(&|$)"); var r = window.location.search.substr(1).match(reg); if (r != null) { return decodeURI(r[2]); } else { return null; } } </script> </body> </html> ```