前端页面定时刷新某个方法 mounted(){ if(this.timer){ //清除页面刷新 clearInterval(this.timer); }else{ //页面刷新 () => 必须用这个 this.timer = setInterval(() => { this.drawPipeAndPoint(); }, 60000); } }使用setInterval时this指向的问题。如果我们直接this.timer = setInterval(function(){要触发的函数}) 是会报错的。因为这样的话this的指向为window，但是我们要触发的函数是挂载在vm实例上面的。所以这个时候就是箭头函数发挥用处的时候了。我们可以直接这样写this.timer = setInterval(() => {要触发的函数}).使用mouted，beforeDestory时注意他们是和method平级的。

初学者 Vue v-bind缩写 ':' v-on 缩写 '@' 缩写 v-bind 缩写 Vue.js 为两个最为常用的指令提供了特别的缩写： <!-- 完整语法 --> <a v-bind:href="url"></a> <!-- 缩写 --> <a :href="url"></a> v-on 缩写 <!-- 完整语法 --> <a v-on:click="doSomething"></a> <!-- 缩写 --> <a @click="doSomething"></a>

前端table导出excel function putOutExcel() { let table = document.getElementById('tableExcel_Day'); var fileName =new Date().Format("yyyyMMddhhmmss"); let sheet = XLSX.utils.table_to_sheet(table);//将一个table对象转换成一个sheet对象 sheet['!cols']=[{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100},{wpx: 100}]; openDownloadDialog(sheet2blob(sheet), fileName+'.xlsx'); } //导出Excel // 将一个sheet转成最终的excel文件的blob对象，然后利用URL.createObjectURL下载 function sheet2blob(sheet, sheetName) { sheetName = sheetName || 'sheet1'; var workbook = { SheetNames: [sheetName], Sheets: {} }; workbook.Sheets[sheetName] = sheet; // 生成excel的配置项 var wopts = { bookType: 'xlsx', // 要生成的文件类型 bookSST: false, // 是否生成Shared String Table，官方解释是，如果开启生成速度会下降，但在低版本IOS设备上有更好的兼容性 type: 'binary' }; var wbout = XLSX.write(workbook, wopts); var blob = new Blob([s2ab(wbout)], { type: "application/octet-stream" }); // 字符串转ArrayBuffer function s2ab(s) { var buf = new ArrayBuffer(s.length); var view = new Uint8Array(buf); for (var i = 0; i != s.length; ++i) view[i] = s.charCodeAt(i) & 0xFF; return buf; } return blob; } function openDownloadDialog(url, saveName) { if (typeof url == 'object' && url instanceof Blob) { url = URL.createObjectURL(url); // 创建blob地址 } var aLink = document.createElement('a'); aLink.href = url; aLink.download = saveName || ''; // HTML5新增的属性，指定保存文件名，可以不要后缀，注意，file:///模式下不会生效 var event; if (window.MouseEvent) event = new MouseEvent('click'); else { event = document.createEvent('MouseEvents'); event.initMouseEvent('click', true, false, window, 0, 0, 0, 0, 0, false, false, false, false, 0, null); } aLink.dispatchEvent(event); }

mysql 批量删除指定行数语句 delete from pns_tendency_config where id in(select t.id from (select id from pns_tendency_config Limit 1091,18)as t)

js下载后端发送过来的数据 //下载导出Excel function downloadExcel() { var url = projectName+'/sys/orgUser/admin/getAllUserDownloadExcel'; // //所带参数 可以不带 // var NameLike = document.getElementById("userName").value; // var startTime = $('#startTime').datetimebox('getValue'); // var endTime = $('#endTime').datetimebox('getValue'); // if(endTime==""){ // endTime=new Date(); // $('#endTime').datetimebox('setValue', GMTToStr(endTime)); // } // if(startTime==""){ // startTime=new Date(endTime); // startTime.setDate(startTime.getDate()-1); // $('#startTime').datetimebox('setValue', GMTToStr(startTime)); // } // endTime=GMTToStr(endTime); // startTime=GMTToStr(startTime); // NameLike = encodeURI(NameLike); // // var queryParams = { // NameLike: NameLike, // endTime:endTime, // startTime:startTime // }; // //清空原来网格数据 //$("#logInfo").datagrid("loadData", { total: 0, rows: [] }); var excelDiv = document.createElement("table"); excelDiv.setAttribute("id","excelDiv"); excelDiv.style.visibility='visible'; var datagridDiv = document.getElementById("datagridDiv"); datagridDiv.appendChild(excelDiv); InventedDataGrid(url); } function InventedDataGrid(url) { $('#excelDiv').datagrid({ method: 'get', url: url, // queryParams:queryParams, pagination: true, pageSize: 30, pageList: [10, 20, 30, 40, 50], fit: true, fitColumns: false, nowrap: false, border: false, singleSelect: true, rownumbers: true, remoteSort: true, sortName:'time', sortOrder:'desc', toolbar: [], onLoadSuccess:function(data){ var logData = data.rows; for (var index in logData){ delete logData[index].id; delete logData[index].sessionId; } var Table=document.createElement('table'); Table.setAttribute("id","tableData"); Table.style.display ="none"; if (logData.length>0){ var lRow=document.createElement('tr'); var tr = logData[0]; for(var k in tr){ var sheetName = ""; if (k=="realName"){ sheetName = "用户姓名"; }else if (k=="userName"){ sheetName = "账号"; }else if(k=="mobilePhone"){ sheetName = "电话"; }else if (k=="email"){ sheetName = "电子邮箱"; }else if(k=="orgName"){ sheetName = "所属部门"; }else if (k=="status"){ sheetName = "状态"; }else if (k=="createTime"){ sheetName = "创建日期"; }else { continue; } var textNode=document.createTextNode(sheetName); var lLine=document.createElement('td'); lLine.appendChild(textNode); lRow.appendChild(lLine); } Table.appendChild(lRow); } for(var i=0;i<logData.length;i++){ var lRow=document.createElement('tr'); var tr = logData[i]; for(var j in tr){ if (j=="id"||j=="sessionId"){ continue; } var textNode=document.createTextNode(tr[j]); var lLine=document.createElement('td'); lLine.appendChild(textNode); lRow.appendChild(lLine); } Table.appendChild(lRow); } //let table = document.getElementById("excelDiv"); var datagridDiv = document.getElementById("datagridDiv"); datagridDiv.appendChild(Table); // var json=$('#tableData').tableToJSON(); //展示的顺序，把data中对象的属性按照你想要的顺序排放就可以了，我这里把id移到了第一列展示 const header = ["realName","userName","mobilePhone","email","orgName","status","createTime"]; // const header1 = ["用户名","账号","电话","电子邮箱", "所属部门","状态","创建日期","创建日期"]; //展示的名称 const headerDisplay = {realName:"用户姓名",userName:"账号", mobilePhone:"电话",email:"电子邮箱", orgName:"所属部门", status:"状态", createTime:"创建日期"}; //将表头放到原始数据里面去，要保证表头在数组的最前面 logData.unshift(headerDisplay); //const newData = [headerDisplay, ...data]; //加了一句skipHeader:true，这样就会忽略原来的表头 var worksheet = XLSX.utils.json_to_sheet(logData, {header:header, skipHeader:true}); //let sheet = XLSX.utils.json_to_sheet(logData, {header:header});//将一个table对象转换成一个sheet对象 openDownloadDialog(sheet2blob(worksheet), "用户信息" + new Date().Format("yyyyMMddhhmmss")+'.xlsx'); }, frozenColumns: [[ { field: 'id', title: '序号', align: 'center', hidden: true, }, { title: '用户姓名', field: 'realName', align: 'center', width: 100 }, { title: '账号', field: 'userName', align: 'center', width: 100 }, { title: '电话', field: 'mobilePhone', align: 'center', sortable:true, width: 100 },{ title: '电子邮箱', field: 'email', align: 'center', sortable:true, width: 100 }, { title: '所属部门', field: 'orgName', align: 'center', width: 100 }, { title : '状态', field : 'status', align:'center', sortable:true, formatter:function(value,row,index){ if(row.status == 0)return '<font color=red>是</font>'; if(row.status == 1) return '<font color=green>否</font>';}, width : 50 }, { title: '创建日期', field: 'createTime', align: 'center', sortable:true, width: 100 } ]], }); } function openDownloadDialog(url, saveName) { if (typeof url == 'object' && url instanceof Blob) { url = URL.createObjectURL(url); // 创建blob地址 } var aLink = document.createElement('a'); aLink.href = url; aLink.download = saveName || ''; // HTML5新增的属性，指定保存文件名，可以不要后缀，注意，file:///模式下不会生效 var event; if (window.MouseEvent) event = new MouseEvent('click'); else { event = document.createEvent('MouseEvents'); event.initMouseEvent('click', true, false, window, 0, 0, 0, 0, 0, false, false, false, false, 0, null); } aLink.dispatchEvent(event); } //导出Excel // 将一个sheet转成最终的excel文件的blob对象，然后利用URL.createObjectURL下载 function sheet2blob(sheet, sheetName) { sheetName = sheetName || 'sheet1'; var workbook = { SheetNames: [sheetName], Sheets: {} }; workbook.Sheets[sheetName] = sheet; // 生成excel的配置项 var wopts = { bookType: 'xlsx', // 要生成的文件类型 bookSST: false, // 是否生成Shared String Table，官方解释是，如果开启生成速度会下降，但在低版本IOS设备上有更好的兼容性 type: 'binary' }; var wbout = XLSX.write(workbook, wopts); var blob = new Blob([s2ab(wbout)], { type: "application/octet-stream" }); // 字符串转ArrayBuffer function s2ab(s) { var buf = new ArrayBuffer(s.length); var view = new Uint8Array(buf); for (var i = 0; i != s.length; ++i) view[i] = s.charCodeAt(i) & 0xFF; return buf; } return blob; }