-
Notifications
You must be signed in to change notification settings - Fork 0
/
infinity_export_excel.js
192 lines (174 loc) · 8.82 KB
/
infinity_export_excel.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
/* 本脚本仅供个人学习交流使用，请勿商用!!!
*
* 作者：曦源 QQ: 1724464648
* 版本：v1.0.0
* 时间：2021/11/5
* 功能：将用户网站数据生成并导出 excel表功能
*
*
* 准备工作说明：
* 1. 确保数据处于最新状态，请手动备份同步数据
*
*
* 导出Excel文件说明：
* 1. 在浏览器新标签页，打开浏览器开发者工具，键盘快捷按键 F12，并点击Console, 打开控制台
* 2. 全选本脚本，快捷键 Ctrl + A, 然后复制本脚本 快捷键 Ctrl + C, 然后到浏览器控制台，粘贴脚本代码，快捷键 Crtl + V，最后按回车 Enter ,即可导出备份文件
*
*
*/
var tb_count = 0;//网站数量
//获取用户的网站信息
function GetWebInfoV2() {
//表头
var tableHtml = '<div id="z_wrapper" style="z-index: 999999;position: absolute;background-color: white;width: 1000px;height: 500px;margin-left: 150px;margin-top:50px;overflow-y: scroll;padding:8px;filter:alpha(Opacity=80);-moz-opacity:0.5;opacity: 0.8;border-radius: 15px;">' +
'<table id="z_table" style="border-collapse: collapse;text-align:center;">' +
'<tr>' +
'<th style="border: 1px solid #ccc;padding:5px;width:500px;height:40px;">名称</th>' +
'<th style="border: 1px solid #ccc;padding:5px;width:500px;height:40px;">网址</th>' +
'<th style="border: 1px solid #ccc;padding:5px;width:100px;height:40px;">分类</th>' +
'</tr>';
//获取 window.localStorage
var storage = window.localStorage;
if (!storage) {
alert("浏览器不支持LocalStorage");
return;
}
//用户收藏的网站json字符串
var store_site = storage["store-site"];
if (!store_site) {
alert("请检查登录状态，并检查是否将数据同步到本地，确认无误后再执行此脚本");
return;
}
//字符串 转 ToJson对象
var u_list = JSON.parse(store_site).sites;
//遍历 - 每页
for (let i = 0; i < u_list.length; i++) {
var page_list = u_list[i]; //某一页
for (let j = 0; j < page_list.length; j++) {
var unit_list = page_list[j]; //某个单元格
var image_type = unit_list.bgType;
//判断是 单个网站 还是文件夹 image / folder
if (image_type == "image" || image_type == "color") {
//单个网站 纯色
//网站
var url = unit_list.target;
//过滤 infinity:// 开头的官方应用
var fdStart = url.indexOf("infinity://");
if (fdStart == 0) continue;
//名称
var name = unit_list.name;
tableHtml += '<tr>' +
'<td style="border: 1px solid #ccc;padding:5px;height:25px;" align="center">' + name + '</td>' +
'<td style="border: 1px solid #ccc;padding:5px;height:25px;"><a href="' + url + '" target="_blank">' + url + '</a></td>' +
'<td style="border: 1px solid #ccc;padding:5px;height:25px;" align="center"></td>' +
'</tr>';
tb_count++;
} else if (image_type == undefined) {
//文件夹
//文件夹名称
var folder_name = unit_list.name;
//文件夹子项集合
var folder_list = unit_list.children;
//只要用户自定义的网站集合
var item_user_disposed = new Array();
for (let k = 0; k < folder_list.length; k++) {
var url = folder_list[k].target;
var fdStart = url.indexOf("infinity://");
if (fdStart == 0) continue;
item_user_disposed.push({ url: url, name: folder_list[k].name });
}
//组成table
if (!item_user_disposed.length) continue;
for (let m = 0; m < item_user_disposed.length; m++) {
if (m == 0) {
tableHtml += '<tr>' +
'<td style="border: 1px solid #ccc;padding:5px;height:25px;" align="center">' + item_user_disposed[m].name + '</td>' +
'<td style="border: 1px solid #ccc;padding:5px;height:25px;"><a href="' + item_user_disposed[m].url + '" target="_blank">' + item_user_disposed[m].url + '</a></td>' +
'<td style="border: 1px solid #ccc;padding:5px;height:25px;" align="center" rowspan="' + item_user_disposed.length + '">' + folder_name + '</td>' +
'</tr>';
} else {
tableHtml += '<tr>' +
'<td style="border: 1px solid #ccc;padding:5px;height:25px;" align="center">' + item_user_disposed[m].name + '</td>' +
'<td style="border: 1px solid #ccc;padding:5px;height:25px;"><a href="' + item_user_disposed[m].url + '" target="_blank">' + item_user_disposed[m].url + '</a></td>' +
'</tr>';
}
}
tb_count += item_user_disposed.length;
}
}
}
tableHtml += '</table></div><a id="dlink" style="display:none;"></a><input type="button" onclick="tableToExcel(\'tablename\', \'name\', \'myfile.xlsx\')" value="Export to Excel">';
var div_table = document.createElement("div");
div_table.id = 'temp_div';
div_table.innerHTML = tableHtml;
document.body.appendChild(div_table);
console.log("网站个数：", tb_count);
// tableToExcel('z_table', " 累计 " + tb_count + " 个网站"); //直接下载
var userInfo = storage["store-user"];
if (!userInfo) {
tableToExcel('z_table', "累计 " + tb_count + " 个网站", "InfinityPro " + getCurrentDate(2));
} else {
var user_info = JSON.parse(userInfo).userInfo;
if(user_info.name){
var space = " ";
tableToExcel('z_table', "用户：" + user_info.name + space + "共收藏 " + tb_count + " 个网站", "InfinityPro " + getCurrentDate(2));
}
else{
tableToExcel('z_table', "累计 " + tb_count + " 个网站", "InfinityPro " + getCurrentDate(2));
}
}
//销毁table
document.getElementById("temp_div").remove();
}
//时间类
function getCurrentDate(format) {
var now = new Date();
var year = now.getFullYear(); //年份
var month = now.getMonth();//月份
var date = now.getDate();//日期
var day = now.getDay();//周几
var hour = now.getHours();//小时
var minu = now.getMinutes();//分钟
var sec = now.getSeconds();//秒
month = month + 1;
if (month < 10) month = "0" + month;
if (date < 10) date = "0" + date;
if (hour < 10) hour = "0" + hour;
if (minu < 10) minu = "0" + minu;
if (sec < 10) sec = "0" + sec;
var time = "";
//精确到天
if (format == 1) {
time = year + "-" + month + "-" + date;
}
//精确到分
else if (format == 2) {
time = year + "/" + month + "/" + date + " " + hour + ":" + minu + ":" + sec;
}
return time;
}
//导出excel
var tableToExcel = (function () {
var uri = 'data:application/vnd.ms-excel;base64,',
template = '<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head><!--[if gte mso 9]><?xml version="1.0" encoding="UTF-8" standalone="yes"?><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head><body><table>{table}</table></body></html>',
base64 = function (s) { return window.btoa(unescape(encodeURIComponent(s))) },
format = function (s, c) {
return s.replace(/{(\w+)}/g,
function (m, p) { return c[p]; })
}
// 直接下载
// return function (table, name) {
// if (!table.nodeType) table = document.getElementById(table)
// var ctx = { worksheet: name || 'Worksheet', table: table.innerHTML }
// window.location.href = uri + base64(format(template, ctx))
// }
// 重命名下载文件
return function (table, name, filename) {
if (!table.nodeType) table = document.getElementById(table)
var ctx = { worksheet: name || 'Worksheet', table: table.innerHTML }
document.getElementById("dlink").href = uri + base64(format(template, ctx));
document.getElementById("dlink").download = filename;//这里是关键所在,当点击之后,设置a标签的属性,这样就可以更改标签的标题了
document.getElementById("dlink").click();
}
})()
GetWebInfoV2();