导出微信公众号的所有会员卡信息,保存为csv格式
当前为
// ==UserScript==
// @name 微信公众号会员信息导出[Wechat_offical_account_VIP_info_export]
// @namespace http://tampermonkey.net/
// @version 0.8
// @description 导出微信公众号的所有会员卡信息,保存为csv格式
// @author Xiaoxx
// @match https://mp.weixin.qq.com/merchant/membercardmgr?*
// @grant none
// ==/UserScript==
(function() {
'use strict';
function getCookie(c_name) {
if (document.cookie.length > 0) {
var c_start = document.cookie.indexOf(c_name + "=")
if (c_start != -1) {
c_start = c_start + c_name.length + 1
var c_end = document.cookie.indexOf(";", c_start)
if (c_end == -1) c_end = document.cookie.length
return unescape(document.cookie.substring(c_start, c_end))
}
}
return ""
}
function setCookie(c_name,value) {
var expiredays = 365
var exdate = new Date()
exdate.setDate(exdate.getDate() + expiredays)
document.cookie = c_name + "=" + escape(value) +
((expiredays == null) ? "" : ";expires=" + exdate.toGMTString())
}
function read_info(){
var info = document.getElementsByClassName("msg_pre_view")[0].innerText
var info_array = info.split("\n")//转换信息为数组
info_array[1] = info_array[1].replace(" ","")//删掉会员名后面小笔的图标
var info_es = []
var info_head = []
for (var i=0;i<8;i++){
info_head[i]=info_array.splice(0,1)[0];//偶数行为head
info_es[i]=info_array.splice(0,1)[0]; //奇数行为内容
}
var card_no = document.getElementsByClassName("msg_pre_view")[1].getElementsByTagName("span")[1].innerText
var card_point = parseInt(document.getElementsByClassName("msg_pre_view")[1].getElementsByTagName("span")[2].innerText)
info_head.push("会员号","积分")
info_es.push(card_no,card_point)
var csv = info_es.join(",")
return csv
}
window.addEventListener('load', function() {
var step = parseInt(getCookie("step"))
if(window.location.search.has("action=user_list")){//分支1:在会员列表页
if (getCookie("step")==""){
setCookie("step","1");
step = 1;
}
if(step>10){
step=1
setCookie("step",step)
try {
document.getElementById("js_next_page").click()//去往下一页
}
catch(err) {
alert("导出完成,下载csv文件")
var csv = localStorage.getItem("csv")
csv = "会员,地区,姓名,手机,生日,状态,是否关注,标签,会员号,积分\n"+csv
window.open("data:text/csv;charset=utf-8,"+csv)
}
console.log("next page")
return//这个return必须要否则下一页的点击速度赶不上去详情页的速度
}
console.log("step:"+step)
setCookie("back_url",window.location.href)
window.location.href=document.getElementsByClassName("tbody")[0].getElementsByTagName("a")[step*2-1].href//去往详情页
return
}
if(window.location.search.has("action=user_detail")){//分支2:在会员详情页
step++;
setCookie("step",step)
/*在这里做事情*/
var csv = localStorage.getItem("csv")
if (csv == null){
csv = ""
localStorage.setItem("csv",csv)
}
csv = csv+"\n"+read_info()
localStorage.setItem("csv",csv)//用localstorage存储csv
console.log("back")
window.location.href=getCookie("back_url")
//window.history.back();//后退
//return
}
}, false);
}
)();