var table = $("#tableList"); $(document).ready(function () { initTable(); laydate.skin('blue'); laydate({ elem: '#starttime', event: 'focus', istime: true, format: 'YYYY-MM-DD hh:mm:ss' }); laydate({ elem: '#endtime', event: 'focus', istime: true, format: 'YYYY-MM-DD hh:mm:ss' }); }); function initTable(action, isPass) { //先销毁表格 table.bootstrapTable("destroy"); //初始化表格,动态从服务器加载数据 table.bootstrapTable({ method: "get", //使用get请求到服务器获取数据 url: huayi.config.callcenter_url + "Policy/GetList", //获取数据的Servlet地址 contentType: "application/x-www-form-urlencoded", striped: true, //表格显示条纹 pagination: true, //启动分页 pageSize: 10, //每页显示的记录数 pageNumber: 1, //当前第几页 pageList: [10, 20, 50, 100], //记录数可选列表 search: false, //是否启用查询 showColumns: false, //显示下拉框勾选要显示的列 showRefresh: false, //显示刷新按钮 sidePagination: "server", //表示服务端请求 //设置为undefined可以获取pageNumber,pageSize,searchText,sortName,sortOrder //设置为limit可以获取limit, offset, search, sort, order queryParamsType: "undefined", queryParams: function queryParams(params) { //设置查询参数 var param = { page: params.pageNumber, pagesize: params.pageSize, token: $.cookie("token"), keyvalue: $("#keyvalue").val(), key: $("#keyId").val(), stime: $("#starttime").val(), etime: $("#endtime").val(), }; return param; }, onLoadSuccess: function () { //加载成功时执行 //layer.msg("加载成功"); }, onLoadError: function () { //加载失败时执行 //layer.msg("加载数据失败", { time: 1500, icon: 2 }); }, }); } function setCode(val, row, index) { return index + 1; } function operation(val, row) { return ( '
' + '详情' + '编辑' + '
' + '删除' + "
" ); } $(".searchGo").click(function () { initTable(); }); $(".addBtn").click(function () { layer.open({ type: 2, content: "./addOrEditZhiShiKuPoliciesRegulations.html", //iframe的url,no代表不显示滚动条 title: "政策法规", area: ["80%", "80%"], //宽高 }); }); function editBtn(id) { layer.open({ type: 2, content: "./addOrEditZhiShiKuPoliciesRegulations.html?id=" + id, //iframe的url,no代表不显示滚动条 title: "政策法规", area: ["80%", "80%"], //宽高 }); } function deleteBtn(id) { layer.confirm('确定删除吗?', { btn: ['是', '否'] //按钮 }, function () { $.post(huayi.config.callcenter_url + "Policy/DelModel", { ids: id, token: $.cookie("token") }, function (result) { result = JSON.parse(result); if (result.state.toLowerCase() == "success") { layer.msg("删除成功"); initTable() } }) }); } function detailBtn(id) { layer.open({ type: 2, content: "./detaileZhiShiKuPoliciesRegulations.html?id=" + id, //iframe的url,no代表不显示滚动条 title: "政策法规", area: ["80%", "80%"], //宽高 }); } $(".exportFile").click(function() { var keyvalue = $("#keyvalue").val(); var stime = $("#starttime").val(); var etime = $("#endtime").val(); var key = $("#keyId").val(); var url = huayi.config.callcenter_url + "Policy/GetList?token=" + $.cookie("token"); url += "&keyvalue=" + keyvalue + "&stime=" + stime + "&etime=" + etime + "&key=" + key + "&isdc=1" window.location.href = url; }) $(".importFile").click(function () { $("#upFile").trigger("click"); }); $("#upFile").change(function () { upload(); }); function upload() { if (document.getElementById("upFile").files.length > 0) { var formData = new FormData(); formData.append("upFile", document.getElementById("upFile").files[0]); formData.append("token", $.cookie("token")); $.ajax({ url: huayi.config.callcenter_url + "Policy/ImportExcel", type: "POST", data: formData, contentType: false, processData: false, success: function (result) { $("#upFile").change(function () { upload(); }); var r = $.parseJSON(result); if (r.state.toLowerCase() == "success") { layer.msg("导入成功"); initTable(); } }, }); } else { layer.confirm("请上传文件!", { btn: ["确定"], }); } } $(".exportTemplate").click(function () { var a = document.createElement("a"); a.style.display = "none"; a.download = "政策法规模板.xlsx"; a.href = "../static/xls/政策法规模板.xlsx"; document.body.appendChild(a); a.click(); document.body.removeChild(a); });