// ==UserScript==
// @name 淘宝买家订单数据导出
// @namespace https://github.com/Sky-seeker/BuyerOrdersExport
// @version 1.3.1
// @description “淘宝买家订单数据导出”最初基于“淘宝买家订单导出-颜色分类”添加了“商品主图”，修改和修复了一些细节问题，当前版本与之前已经有了较大的变动。导出的项目包括下单日期、订单编号、子订单编号、店铺名称、商品名称、快照商品名称、商品颜色分类、商品主图链接、商品链接、商品交易快照链接、单价、数量、订单实付款、退款状态、订单交易状态、订单详情链接。导出的订单数据为CSV文件。在导出淘宝买家订单数据时，支持一些可选功能，如商品名称和店铺名称黑名单关键字过滤，快照商品名称获取以及获取时的随机延时，Excel 数据格式适配，订单详情链接一致化。支持项目标题次序自定义，支持图片链接尺寸选择，支持项目标题和黑名单列表的数据的本地存储。使用的过程中会有反馈，如按钮的可用状态和颜色变化，以及窗口右下角的气泡通知等。
// @author 梦幻之心星
// @match https://buyertrade.taobao.com/trade/*
// @require https://cdnjs.cloudflare.com/ajax/libs/lodash.js/4.17.15/lodash.min.js
// @grant none
// @license MIT
// @supportURL https://github.com/Sky-seeker/BuyerOrdersExport
// ==/UserScript==
var orderList = {};
var orderHeader = [];
var blackList = [];
var imageDimensionsIndex = 0;
const fileNamePrefix = "淘宝买家订单数据导出_";
const fileNameSuffix = "";
var defaultOrderHeader = [
"下单日期",
"订单编号",
"子订单编号",
"店铺名称",
"商品名称",
"快照商品名称",
"商品分类",
"商品主图",
"商品链接",
"交易快照",
"单价",
"数量",
"实付款",
"退款状态",
"交易状态",
"订单详情链接",
];
var defaultBlackList = ["保险服务", "增值服务", "买家秀"];
var imageDimensionsList = ["80x80", "100x100", "160x160", "200x200", "240x240", "300x300", "320x320", "400x400", "480x480", "560x560", "600x600", "640x640", "720x720", "800x800"];
//通知气泡默认属性
function createToast() {
let Toast = document.createElement("div");
let ToastText = document.createTextNode("通知气泡");
Toast.id = "Toast";
Toast.style.visibility = "hidden";
Toast.style.position = "fixed";
Toast.style.bottom = "0px";
Toast.style.fontSize = "17px";
Toast.style.minWidth = "200px";
Toast.style.backgroundColor = "#4CAF50";
Toast.style.color = "white";
Toast.style.textAlign = "center";
Toast.style.borderRadius = "10px";
Toast.style.padding = "10px";
Toast.style.zIndex = 1;
Toast.style.right = "1%";
Toast.appendChild(ToastText);
document.getElementById("page").appendChild(Toast);
}
//调用通知气泡
function Toast(toastTextContent, alwaysShow = false) {
let Toast = document.getElementById("Toast");
Toast.style.visibility = "visible";
Toast.textContent = toastTextContent;
if (alwaysShow === false) {
setTimeout(function () {
Toast.style.visibility = "hidden";
}, 3000);
}
}
//文本区域默认属性
function createTextarea(element, onchangeFunc, text, id, width, rows) {
let Textarea = document.createElement("TEXTAREA");
let TextareaTitle = document.createElement("p");
Textarea.id = id;
Textarea.rows = rows;
Textarea.cols = 30;
Textarea.placeholder = "每行一条。";
Textarea.style.width = width;
Textarea.style.height = "140px";
Textarea.style.padding = "5px";
TextareaTitle.textContent = text;
TextareaTitle.style.fontSize = "15px";
TextareaTitle.style.fontWeight = 700;
Textarea.onchange = function () {
onchangeFunc();
};
element.appendChild(TextareaTitle);
element.appendChild(Textarea);
}
//单选按钮默认属性
function addRadio(element, onchangeFunc, text, id, value) {
const radio = document.createElement("input");
const radioText = document.createTextNode(text);
radio.id = id;
radio.value = value;
radio.type = "radio";
radio.name = "imageDimensions";
radio.style.verticalAlign = "middle";
radio.style.marginLeft = "30px";
radio.style.marginRight = "5px";
radio.onchange = function () {
onchangeFunc();
};
element.appendChild(radio);
element.appendChild(radioText);
}
//下拉列表默认属性
function addSelect(element, text, value) {
const ListSelectOption = document.createElement("option");
ListSelectOption.text = text;
ListSelectOption.value = value;
element.add(ListSelectOption);
}
//复选框默认属性
function addCheckbox(element, onchangeFunc, text, id) {
const checkbox = document.createElement("input");
const checkboxText = document.createTextNode(text);
checkbox.id = id;
checkbox.type = "checkbox";
checkbox.defaultChecked = true;
checkbox.style.verticalAlign = "middle";
checkbox.style.marginLeft = "22px";
checkbox.style.marginRight = "5px";
checkbox.onchange = function () {
onchangeFunc();
};
element.appendChild(checkbox);
element.appendChild(checkboxText);
}
//按钮默认属性
function addButton(element, onclickFunc, text, id, width, marginLeft) {
const button = document.createElement("input");
button.id = id;
button.type = "button";
button.value = text;
button.style.height = "50px";
button.style.width = width;
button.style.align = "center";
button.style.marginLeft = marginLeft;
button.style.marginBottom = "20px";
button.style.color = "white";
button.style.background = "#409EFF";
button.style.border = "1px solid #409EFF";
button.style.fontSize = "16px";
button.onclick = function () {
onclickFunc();
};
element.appendChild(button);
}
//图片尺寸选择默认属性
function createImageDimensionsListSelect(element) {
let ListTitle = document.createElement("p");
let ListSelect = document.createElement("select");
ListTitle.id = "imageDimensionsListTitle";
ListTitle.textContent = "图片尺寸：";
ListSelect.id = "imageDimensionsListSelect";
ListSelect.name = "imageDimensions";
ListTitle.style.float = "left";
ListTitle.style.fontSize = "15px";
ListTitle.style.fontWeight = 700;
ListSelect.style.width = "65px";
ListSelect.style.marginLeft = "5px";
//ListSelect.style.marginRight = "5px";
//添加下拉列表项
for (let index = 0; index < imageDimensionsList.length; index++) {
addSelect(ListSelect, imageDimensionsList[index], imageDimensionsList[index]);
}
ListSelect.onchange = function () {
choseImageDimensions();
};
element.appendChild(ListTitle);
//var imageDimensionsList = ["80x80", "100x100", "160x160", "200x200", "240x240","300x300","320x320",
// "400x400","480x480", "560x560", "600x600","640x640", "720x720","800x800"];
//添加单选项：常用值
addRadio(element, changeImageDimensions, "80x80", "80x80", "80x80");
addRadio(element, changeImageDimensions, "300x300", "300x300", "300x300");
addRadio(element, changeImageDimensions, "560x560", "560x560", "560x560");
addRadio(element, changeImageDimensions, "800x800", "800x800", "800x800");
addRadio(element, changeImageDimensions, "其它", "otherImageDimensions", "otherImageDimensions");
element.appendChild(ListSelect);
}
//在订单数据页面添加控件
const orderListPage = /(http|https):\/\/buyertrade\.taobao.*?\/trade/g;
if (orderListPage.exec(document.URL)) {
const orderListMain = document.getElementById("J_bought_main");
const userMain = document.createElement("div");
const userMainText = document.createElement("span");
const userMainList = document.createElement("ul");
const userMainTextCol1 = document.createElement("div");
const userMainTextCol2 = document.createElement("div");
const userMainListRow0 = document.createElement("li");
const userMainListRow1 = document.createElement("li");
const userMainListRow2 = document.createElement("li");
const userMainListRow3 = document.createElement("li");
const userMainListRow0Form = document.createElement("form");
const userMainListRow1Form = document.createElement("form");
userMain.id = "userMain";
userMainText.id = "userMainText";
userMainList.id = "userMainList";
userMainTextCol1.id = "userMainTextCol1";
userMainTextCol2.id = "userMainTextCol2";
userMainListRow0.id = "userMainListRow0";
userMainListRow1.id = "userMainListRow1";
userMainListRow2.id = "userMainListRow2";
userMainListRow3.id = "userMainListRow3";
userMainListRow0Form.id = "userMainListRow0Form";
userMainListRow1Form.id = "userMainListRow1Form";
orderListMain.insertBefore(userMain, orderListMain.childNodes[0]);
userMain.appendChild(userMainText);
userMain.appendChild(userMainList);
userMainText.appendChild(userMainTextCol1);
userMainText.appendChild(userMainTextCol2);
userMainList.appendChild(userMainListRow0);
userMainList.appendChild(userMainListRow1);
userMainList.appendChild(userMainListRow2);
userMainList.appendChild(userMainListRow3);
userMainListRow0.appendChild(userMainListRow0Form);
userMainListRow1.appendChild(userMainListRow1Form);
createToast();
createTextarea(userMainTextCol1, changeOrderDataItemTitle, "项目标题", "OrderDataItemTitle", "100px", 20);
createTextarea(userMainTextCol2, changeBlackList, "黑名单关键词", "BlackListKey", "120px", 8);
createImageDimensionsListSelect(userMainListRow0Form);
addCheckbox(userMainListRow1Form, changeBlackListStatus, "黑名单过滤", "BlackListStatus");
addCheckbox(userMainListRow1Form, changeDelayStatus, "快照获取延时", "DelayStatus");
addCheckbox(userMainListRow1Form, changeSnapProductNameStatus, "快照名称获取", "SnapProductNameStatus");
addCheckbox(userMainListRow1Form, changeDataFormatAdaptationStatus, "Excel 格式适配", "DataFormatAdaptationStatus");
addCheckbox(userMainListRow1Form, changeUrlUniformizationStatus, "链接一致化", "UrlUniformizationStatus");
addButton(userMainListRow2, resetBlackList, "重置黑名单列表", "resetBlackList", "130px", "20px");
addButton(userMainListRow2, resetOrderDataItemTitle, "重置项目标题", "resetOrderDataItemTitle", "130px", "20px");
addButton(userMainListRow2, readLocalStorageData, "读取本地存储", "readLocalStorageData", "130px", "20px");
addButton(userMainListRow2, writeLocalStorageData, "写入本地存储", "writeLocalStorageData", "130px", "20px");
addButton(userMainListRow3, cleanOrdersList, "清空订单数据", "cleanOrdersList", "170px", "35px");
addButton(userMainListRow3, exportOrdersList, "导出订单数据", "exportOrdersList", "170px", "35px");
addButton(userMainListRow3, addCurrentPageOrdersToList, "添加本页订单", "addOrdersList", "170px", "35px");
document.getElementById("exportOrdersList").disabled = true;
document.getElementById("exportOrdersList").style.opacity = 0.6;
document.getElementById("cleanOrdersList").disabled = true;
document.getElementById("cleanOrdersList").style.opacity = 0.6;
setElementStyle();
resetOrderDataItemTitle();
resetBlackList();
console.info("在订单数据页面添加按钮!");
}
//设置元素样式
function setElementStyle() {
const userMain = document.getElementById("userMain");
const userMainText = document.getElementById("userMainText");
const userMainList = document.getElementById("userMainList");
const userMainTextCol1 = document.getElementById("userMainTextCol1");
const userMainTextCol2 = document.getElementById("userMainTextCol2");
const userMainListRow0 = document.getElementById("userMainListRow0");
const userMainListRow1 = document.getElementById("userMainListRow1");
const userMainListRow2 = document.getElementById("userMainListRow2");
const userMainListRow3 = document.getElementById("userMainListRow3");
const imageDimensionsListTitle = document.getElementById("imageDimensionsListTitle");
userMain.style.height = "180px";
userMainText.style.float = "left";
userMainText.style.width = "260px";
userMainText.style.marginLeft = "0px";
userMainText.style.display = "inline-block";
userMainList.style.float = "left";
userMainList.style.width = "580px";
userMainList.style.marginLeft = "30px";
userMainTextCol1.style.float = "left";
userMainTextCol1.style.width = "110px";
userMainTextCol1.style.marginLeft = "0px";
userMainTextCol2.style.float = "left";
userMainTextCol2.style.width = "130px";
userMainTextCol2.style.marginLeft = "20px";
userMainListRow0.style.fontSize = "14px";
userMainListRow1.style.fontSize = "14px";
userMainListRow0.style.height = "20px";
userMainListRow1.style.height = "20px";
userMainListRow0.style.marginBottom = "5px";
userMainListRow1.style.marginBottom = "10px";
//设置首列元素左边距为零
document.getElementById("userMainListRow0Form").elements[0].style.marginLeft = "0";
document.getElementById("userMainListRow1Form").elements[0].style.marginLeft = "0";
userMainListRow2.children[0].style.marginLeft = "0";
userMainListRow3.children[0].style.marginLeft = "0";
//设置默认图片尺寸
document.getElementById("800x800").checked = true;
imageDimensionsIndex = imageDimensionsList.indexOf("800x800");
}
//重置按钮状态
function ResetButtonStatus() {
document.getElementById("addOrdersList").style.background = "#409EFF";
document.getElementById("tp-bought-root").removeEventListener("click", ResetButtonStatus);
}
//数据转为csv文本文件
function toCsv(header, data, filename) {
let rows = "";
let row = header.join(",");
rows += row + "\n";
_.forEach(data, (value) => {
rows += value.join(",") + "\n";
});
let blob = new Blob(["\ufeff" + rows], { type: "text/csv;charset=utf-8;" });
let encodedUrl = URL.createObjectURL(blob);
let url = document.createElement("a");
url.setAttribute("href", encodedUrl);
url.setAttribute("download", filename + ".csv");
document.body.appendChild(url);
url.click();
}
var currentPageOrdersData = {};
//添加本页订单数据
function addCurrentPageOrdersToList() {
const mainOrders = document.getElementsByClassName("js-order-container");
var isEnableSnapProductName = document.getElementById("SnapProductNameStatus").checked;
document.getElementById("addOrdersList").style.background = "#ff9800";
currentPageOrdersData = {};
//遍历每条订单记录
for (let order of mainOrders) {
let items = processOrderList(order);
if (!items) {
continue;
}
_.forEach(items, (value, key) => {
orderList[key] = value;
if (isEnableSnapProductName === false) {
currentPageOrdersData[key] = value;
}
});
//break; //TODO:测试单条订单记录
}
if (isEnableSnapProductName === false) {
document.getElementById("addOrdersList").style.background = "#4CAF50";
document.getElementById("tp-bought-root").addEventListener("click", ResetButtonStatus);
Toast("添加 " + Object.keys(currentPageOrdersData).length + " 条订单,已添加 " + Object.keys(orderList).length + " 条订单。");
console.info("添加 " + Object.keys(currentPageOrdersData).length + " 条订单,已添加 " + Object.keys(orderList).length + " 条订单。");
console.info("本页订单数据:");
console.info(currentPageOrdersData);
}
document.getElementById("exportOrdersList").disabled = false;
document.getElementById("exportOrdersList").style.opacity = 1;
document.getElementById("cleanOrdersList").disabled = false;
document.getElementById("cleanOrdersList").style.opacity = 1;
}
//导出订单数据
function exportOrdersList() {
if (getSnapShotProductNameCount !== 0) {
alert("请等待添加成功后再导出！");
return;
}
var dateTimeStr = "";
var dateTime = new Date(); //获取当前日期
dateTime.setUTCHours(dateTime.getHours()); //修正本地时与世界时之间的时差
dateTimeStr = dateTime.toISOString(); //格式为: YYYY-MM-DDTHH:mm:ss.sssZ
dateTimeStr = dateTimeStr.replace(/T/, "_");
dateTimeStr = dateTimeStr.replace(/:/g, "-");
dateTimeStr = dateTimeStr.replace(/\.\d{3}Z$/, "");
const fileName = fileNamePrefix + dateTimeStr + fileNameSuffix;
toCsv(orderHeader, orderList, fileName);
}
//清空订单数据
function cleanOrdersList() {
let count = Object.keys(orderList).length;
orderList = {};
Toast("清空了: " + count + " 条订单数据!");
console.info("清空了: " + count + " 条订单数据!");
}
//写入本地存储: 项目标题 + 黑名单列表
function writeLocalStorageData() {
var orderHeaderDataString = "";
var blackListDataString = "";
if (typeof Storage !== "undefined") {
//localStorage.clear();
orderHeaderDataString = orderHeader.join("\n");
blackListDataString = blackList.join("\n");
localStorage.setItem("orderHeader", orderHeaderDataString);
localStorage.setItem("blackList", blackListDataString);
Toast("存储数据到本地！");
console.info("存储数据到本地！");
console.info("orderHeader" + "[" + orderHeader.length + "]:" + orderHeader);
console.info("blackList" + "[" + blackList.length + "]:" + blackList);
console.info("localStorage" + "[" + localStorage.length + "]:");
console.info(localStorage);
} else {
Toast("你的浏览器不支持网页存储！");
console.info("你的浏览器不支持网页存储！");
alert("你的浏览器不支持网页存储！");
}
}
//读取本地存储: 项目标题 + 黑名单列表
function readLocalStorageData() {
if (typeof Storage !== "undefined") {
var orderHeaderDatalength = 0;
var blackListDatalength = 0;
var orderHeaderDataString = "";
var blackListDataString = "";
orderHeaderDataString = localStorage.getItem("orderHeader");
blackListDataString = localStorage.getItem("blackList");
if (orderHeaderDataString !== null) {
orderHeader = orderHeaderDataString.split("\n");
document.getElementById("OrderDataItemTitle").value = orderHeader.join("\n") + "\n";
} else {
Toast("本地存储的项目标题为空！");
console.info("本地存储的项目标题为空！");
alert("本地存储的项目标题为空！");
}
if (blackListDataString !== null) {
blackList = blackListDataString.split("\n");
document.getElementById("BlackListKey").value = blackList.join("\n") + "\n";
} else {
Toast("本地存储的黑名单列表为空！");
console.info("本地存储的黑名单列表为空！");
alert("本地存储的黑名单列表为空！");
}
if (orderHeaderDataString !== null || blackListDataString !== null) {
Toast("读取数据到脚本！");
console.info("读取数据到脚本！");
console.info("orderHeader" + "[" + orderHeader.length + "]:" + orderHeader);
console.info("blackList" + "[" + blackList.length + "]:" + blackList);
console.info("localStorage" + "[" + localStorage.length + "]:");
console.info(localStorage);
}
} else {
Toast("你的浏览器不支持网页存储！");
console.info("你的浏览器不支持网页存储！");
alert("你的浏览器不支持网页存储！");
}
}
//改变项目标题
function changeOrderDataItemTitle() {
var textareaContent = document.getElementById("OrderDataItemTitle").value;
var OrderDataItemTitleList = null;
if (textareaContent.search(/\S/) === -1) {
textareaContent = "";
for (let index = 0; index < orderHeader.length; index++) {
textareaContent = textareaContent + orderHeader[index] + "\n";
}
document.getElementById("OrderDataItemTitle").value = textareaContent;
Toast("项目标题不能为空!");
console.info("项目标题不能为空!");
alert("项目标题不能为空！");
} else {
orderHeader = [];
textareaContent = textareaContent + "\n";
OrderDataItemTitleList = textareaContent.match(/\S+\n/g);
textareaContent = "";
for (let index = 0; index < OrderDataItemTitleList.length; index++) {
orderHeader[index] = OrderDataItemTitleList[index].replace("\n", "");
textareaContent = textareaContent + OrderDataItemTitleList[index];
}
document.getElementById("OrderDataItemTitle").value = textareaContent;
Toast("修改项目标题!");
console.info("修改项目标题!");
console.info("orderHeader[" + OrderDataItemTitleList.length + "]:" + orderHeader);
}
}
//重置项目标题
function resetOrderDataItemTitle() {
document.getElementById("OrderDataItemTitle").value = "";
var textareaContent = "";
orderHeader = [];
for (let index = 0; index < defaultOrderHeader.length; index++) {
orderHeader[index] = defaultOrderHeader[index];
textareaContent = textareaContent + defaultOrderHeader[index] + "\n";
}
document.getElementById("OrderDataItemTitle").value = textareaContent;
Toast("重置项目标题!");
console.info("重置项目标题!");
console.info("orderHeader[" + orderHeader.length + "]:" + orderHeader);
}
//改变黑名单列表
function changeBlackList() {
var textareaContent = document.getElementById("BlackListKey").value;
var blackListTemp = null;
if (textareaContent.search(/\S/) === -1) {
document.getElementById("BlackListKey").value = "";
blackList = [];
Toast("清空黑名单列表!");
console.info("清空黑名单列表!");
console.info("blackList:" + blackList);
} else {
blackList = [];
textareaContent = textareaContent + "\n";
blackListTemp = textareaContent.match(/\S+\n/g);
textareaContent = "";
for (let index = 0; index < blackListTemp.length; index++) {
blackList[index] = blackListTemp[index].replace("\n", "");
textareaContent = textareaContent + blackListTemp[index];
}
document.getElementById("BlackListKey").value = textareaContent;
Toast("设置黑名单列表!");
console.info("设置黑名单列表!");
console.info("blackList[" + blackList.length + "]:" + blackList);
}
}
//重置黑名单列表
function resetBlackList() {
document.getElementById("BlackListKey").value = "";
var textareaContent = "";
blackList = [];
for (let index = 0; index < defaultBlackList.length; index++) {
blackList[index] = defaultBlackList[index];
textareaContent = textareaContent + defaultBlackList[index] + "\n";
}
document.getElementById("BlackListKey").value = textareaContent;
Toast("重置黑名单列表!");
console.info("重置黑名单列表!");
console.info("blackList[" + blackList.length + "]:" + blackList);
}
//启用/禁用 商品名黑名单过滤
function changeBlackListStatus() {
let BlackListStatus = document.getElementById("BlackListStatus").checked;
if (BlackListStatus === true) {
document.getElementById("cleanBlackList").disabled = false;
document.getElementById("cleanBlackList").style.opacity = 1;
document.getElementById("resetBlackList").disabled = false;
document.getElementById("resetBlackList").style.opacity = 1;
document.getElementById("setBlackList").disabled = false;
document.getElementById("setBlackList").style.opacity = 1;
Toast("启用商品名黑名单过滤!");
console.info("启用商品名黑名单过滤!");
} else {
document.getElementById("cleanBlackList").disabled = true;
document.getElementById("cleanBlackList").style.opacity = 0.6;
document.getElementById("resetBlackList").disabled = true;
document.getElementById("resetBlackList").style.opacity = 0.6;
document.getElementById("setBlackList").disabled = true;
document.getElementById("setBlackList").style.opacity = 0.6;
Toast("禁用商品名黑名单过滤!");
console.info("禁用商品名黑名单过滤!");
}
}
//启用/禁用 快照获取随机延时
function changeDelayStatus() {
let DelayStatus = document.getElementById("DelayStatus").checked;
if (DelayStatus === true) {
Toast("启用快照获取随机延时1.0~3.0S!");
console.info("启用快照获取随机延时1.0~3.0S!");
} else {
Toast("禁用快照获取随机延时!");
console.info("禁用快照获取随机延时!");
}
}
//启用/禁用 快照商品名称获取
function changeSnapProductNameStatus() {
let SnapProductNameStatus = document.getElementById("SnapProductNameStatus").checked;
if (SnapProductNameStatus === true) {
Toast("启用快照商品名称获取!");
console.info("启用快照商品名称获取!");
} else {
Toast("禁用快照商品名称获取!");
console.info("禁用快照商品名称获取!");
}
}
//启用/禁用 Excel数据格式适配
function changeDataFormatAdaptationStatus() {
let DataFormatAdaptationStatus = document.getElementById("DataFormatAdaptationStatus").checked;
if (DataFormatAdaptationStatus === true) {
Toast("启用Excel数据格式适配!");
console.info("启用Excel数据格式适配!");
} else {
Toast("禁用Excel数据格式适配!");
console.info("禁用Excel数据格式适配!");
}
}
//启用/禁用 订单详情链接一致化
function changeUrlUniformizationStatus() {
let UrlUniformizationStatus = document.getElementById("UrlUniformizationStatus").checked;
if (UrlUniformizationStatus === true) {
Toast("启用订单详情链接一致化!");
console.info("启用订单详情链接一致化!");
} else {
Toast("禁用订单详情链接一致化!");
console.info("禁用订单详情链接一致化!");
}
}
// 改变图片尺寸大小
function changeImageDimensions() {
var radios = document.getElementsByName("imageDimensions");
for (let index = 0; index < radios.length; index++) {
if (radios[index].checked) {
var imageDimensionsListIndex = imageDimensionsList.indexOf(radios[index].value);
var ListSelect = document.getElementById("imageDimensionsListSelect");
if (radios[index].value !== "otherImageDimensions") {
if (imageDimensionsListIndex !== -1) {
imageDimensionsIndex = imageDimensionsListIndex;
}
} else {
imageDimensionsIndex = ListSelect.selectedIndex;
}
console.log("radios index: " + index + "; radios value: " + radios[index].value);
console.log("Selected Value: " + ListSelect.value + "; Selected Text: " + ListSelect.options[ListSelect.selectedIndex].text);
console.log("imageDimensions index: " + imageDimensionsIndex + " image dimensions: " + imageDimensionsList[imageDimensionsIndex]);
break;
}
}
}
// 监听下拉列表的变化，改变图片尺寸大小
function choseImageDimensions() {
var ListSelect = document.getElementById("imageDimensionsListSelect");
if (document.getElementById("otherImageDimensions").checked === true) {
imageDimensionsIndex = ListSelect.selectedIndex;
}
var selectedValue = ListSelect.value; // 获取选中的值
var selectedText = ListSelect.options[ListSelect.selectedIndex].text; // 获取选中的文本
console.log("Selected Value: " + selectedValue + "; Selected Text: " + selectedText);
console.log("imageDimensions index: " + imageDimensionsIndex + " image dimensions: " + imageDimensionsList[imageDimensionsIndex]);
}
var orderDataIndexListCount = 0;
var orderDataIndexList = [];
var getSnapShotProductNameCount = 0;
var orderListSnapShotProductName = {};
//获取快照商品名称
function getSnapShotProductName(snapShotUrl, orderDataIndex) {
var randomTimeout = 0;
var isenableDelay = document.getElementById("DelayStatus").checked;
var orderDataItemIndex = orderHeader.indexOf("快照商品名称");
if (isenableDelay === true) {
let min = 1000; //毫秒
let max = 3000; //毫秒
randomTimeout = Math.round(Math.random() * (max - min)) + min;
}
orderDataIndexList[orderDataIndexListCount] = orderDataIndex;
orderDataIndexListCount++;
Toast("正在获取快照商品名称...", true);
console.info("正在获取快照商品名称...");
setTimeout(function () {
const xhttp = new XMLHttpRequest();
xhttp.onreadystatechange = function () {
if (this.readyState == 4 && this.status == 200) {
orderListSnapShotProductName[orderDataIndex] = this.responseText.match(/<title>(.*)<\/title>/)[1];
getSnapShotProductNameCount--;
//console.info("快照商品名称:" + orderListSnapShotProductName[orderDataIndex]);
if (getSnapShotProductNameCount === 0) {
document.getElementById("addOrdersList").style.background = "#4CAF50";
document.getElementById("tp-bought-root").addEventListener("click", ResetButtonStatus);
let element = document.createElement("span");
_.forEach(orderListSnapShotProductName, (value, index) => {
element.innerHTML = value;
element.innerHTML = element.innerHTML.replace(/&([a-zA-Z]*)/g, "&$1");
element.innerHTML = element.innerHTML.replace(/,/g, "，");
orderListSnapShotProductName[index] = element.innerText;
orderList[index][orderDataItemIndex] = orderListSnapShotProductName[index];
});
element.remove();
_.forEach(orderDataIndexList, (value) => {
currentPageOrdersData[value] = orderList[value];
});
orderDataIndexListCount = 0;
orderDataIndexList = [];
Toast("添加 " + Object.keys(currentPageOrdersData).length + " 条订单,已添加 " + Object.keys(orderList).length + " 条订单。");
console.info("添加 " + Object.keys(currentPageOrdersData).length + " 条订单,已添加 " + Object.keys(orderList).length + " 条订单。");
console.info("本页订单数据:");
console.info(currentPageOrdersData);
}
}
};
xhttp.open("GET", snapShotUrl);
xhttp.send();
}, randomTimeout);
}
//处理订单数据
function processOrderList(order) {
let orderData = {};
let textContent = order.textContent;
let pattern = /(\d{4}-\d{2}-\d{2})订单号: ()/;
let isExist = pattern.exec(textContent);
if (!isExist) {
console.info("暂未发现订单！");
} else {
const date = isExist[1];
const id = order.querySelector("div[data-id]").getAttribute("data-id");
var index = 0;
var ShopNameQuery = null;
var picUrlQuery = null;
var ProductUrlQuery = null;
var ProductNameQuery = null;
var snapshotUrlQuery = null;
var SKUNameQuery = null;
var RealPriceQuery = null;
var countQuery = null;
var refundQuery = null;
var actualFeeQuery = null;
var statusQuery = null;
var DetailUrlQuery1 = null;
var DetailUrlQuery2 = null;
while (true) {
if (index === 0) {
ShopNameQuery = order.querySelector("a[data-reactid='.0.7:$order-" + id + ".$" + id + ".0.1:0.0.1.0.1']");
actualFeeQuery = order.querySelector("span[data-reactid='.0.7:$order-" + id + ".$" + id + ".0.1:1:0.$" + index + ".$4.0.0.2.0.1']");
statusQuery = order.querySelector("span[data-reactid='.0.7:$order-" + id + ".$" + id + ".0.1:1:0.$" + index + ".$5.0.0.0.0']");
DetailUrlQuery1 = order.querySelector("a[data-reactid='.0.7:$order-" + id + ".$" + id + ".0.1:1:0.$" + index + ".$5.0.1.$0.0.0']");
DetailUrlQuery2 = order.querySelector("a[data-reactid='.0.7:$order-" + id + ".$" + id + ".0.1:1:0.$" + index + ".$5.0.1.$1.0.0']");
}
picUrlQuery = order.querySelector("img[data-reactid='.0.7:$order-" + id + ".$" + id + ".0.1:1:0.$" + index + ".$0.0.0.0.0.0']");
ProductUrlQuery = order.querySelector("a[data-reactid='.0.7:$order-" + id + ".$" + id + ".0.1:1:0.$" + index + ".$0.0.1.0.0']");
ProductNameQuery = order.querySelector("span[data-reactid='.0.7:$order-" + id + ".$" + id + ".0.1:1:0.$" + index + ".$0.0.1.0.0.1']");
snapshotUrlQuery = order.querySelector("a[data-reactid='.0.7:$order-" + id + ".$" + id + ".0.1:1:0.$" + index + ".$0.0.1.0.1']");
SKUNameQuery = order.querySelector("p[data-reactid='.0.7:$order-" + id + ".$" + id + ".0.1:1:0.$" + index + ".$0.0.1.1']");
RealPriceQuery = order.querySelector("span[data-reactid='.0.7:$order-" + id + ".$" + id + ".0.1:1:0.$" + index + ".$1.0.1.1']");
countQuery = order.querySelector("p[data-reactid='.0.7:$order-" + id + ".$" + id + ".0.1:1:0.$" + index + ".$2.0.0']");
refundQuery = order.querySelector("span[data-reactid='.0.7:$order-" + id + ".$" + id + ".0.1:1:0.$" + index + ".$3.0.$0.0.0.$text']");
index++;
let orderDataIndex = id + index;
if (ProductNameQuery === null) {
break;
}
//过滤黑名单项：如"保险服务"、"增值服务"、"买家秀"等;
var isEnableBlackList = document.getElementById("BlackListStatus").checked;
if (isEnableBlackList === true && blackList.length > 0) {
var searchResult = false;
for (let item of blackList) {
if (ProductNameQuery.textContent.search(item) !== -1) {
searchResult = true;
break;
}
if (ShopNameQuery.innerText.search(item) !== -1) {
searchResult = true;
break;
}
}
if (searchResult === true) {
continue;
}
}
//修复淘宝订单页面中的字符实体显示错误和英文逗号导致的CSV导入Excel后数据错行；
ProductNameQuery.innerHTML = ProductNameQuery.innerHTML.replace(/&([a-zA-Z]*)/g, "&$1");
ProductNameQuery.innerHTML = ProductNameQuery.innerHTML.replace(/,/g, "，");
if (SKUNameQuery !== null) {
SKUNameQuery.innerHTML = SKUNameQuery.innerHTML.replace(/&([a-zA-Z]*).*?：/g, "&$1;");
SKUNameQuery.innerHTML = SKUNameQuery.innerHTML.replace(/,/g, "，");
}
var orderInfoId = id;
var orderInfoDate = date;
var sellerInfoShopName = ShopNameQuery === null ? "" : ShopNameQuery.innerText;
var subOrdersIteminfoId = orderDataIndex;
var subOrdersIteminfoPicUrl = picUrlQuery === null ? "" : picUrlQuery.src;
var subOrdersIteminfoProductUrl = ProductUrlQuery === null ? "" : ProductUrlQuery.href;
var subOrdersIteminfoProductName = ProductNameQuery.textContent;
var subOrdersIteminfoSnapUrl = snapshotUrlQuery === null ? "" : snapshotUrlQuery.href;
var subOrdersIteminfoSKUName = SKUNameQuery === null ? "" : SKUNameQuery.innerText;
var subOrdersPriceinfoRealPrice = RealPriceQuery === null ? "" : RealPriceQuery.textContent;
var subOrdersQuantityCount = countQuery === null ? "" : countQuery.textContent;
var subOrdersRefund = refundQuery === null ? "" : refundQuery.innerText === "查看退款" ? "退款" : "";
var payInfoActualFee = actualFeeQuery === null ? "" : actualFeeQuery.textContent;
var statusInfoStatus = statusQuery === null ? "" : statusQuery.textContent;
var statusInfoDetailUrl = DetailUrlQuery1 === null ? (DetailUrlQuery2 === null ? "" : DetailUrlQuery2.href) : DetailUrlQuery1.href;
var subOrdersSnapshotProductName = null;
//选择图片尺寸
if (imageDimensionsList[imageDimensionsIndex] === "800x800") {
subOrdersIteminfoPicUrl = subOrdersIteminfoPicUrl.replace(/_80x80.(jpg|png)/, "");
} else {
subOrdersIteminfoPicUrl = subOrdersIteminfoPicUrl.replace(/\d*x\d*(?=.(jpg|png))/, imageDimensionsList[imageDimensionsIndex]);
}
//Excel数据格式适配
var isEnableDataFormatAdaptation = document.getElementById("DataFormatAdaptationStatus").checked;
if (isEnableDataFormatAdaptation === true) {
orderInfoId = '"' + orderInfoId + '\t"';
subOrdersIteminfoId = '"' + subOrdersIteminfoId + '\t"';
}
//订单详情链接一致化
var isEnableUrlUniformization = document.getElementById("UrlUniformizationStatus").checked;
if (isEnableUrlUniformization === true) {
//过去的淘宝和天猫订单详情链接为：https://tradearchive.taobao.com/trade/detail/trade_item_detail.htm?bizOrderId=<id>
var recentTaoBaoOrderDetailUrlPrefix = "buyertrade.taobao.com/trade/detail/trade_item_detail"; //最近的淘宝订单详情链接前缀
var recentTmallOrderDetailUrlPrefix = "trade.tmall.com/detail/orderDetail"; //最近的天猫订单详情链接前缀
var passedOrderDetailUrlPrefix = "tradearchive.taobao.com/trade/detail/trade_item_detail"; //过去的淘宝和天猫订单详情链接前缀
statusInfoDetailUrl = statusInfoDetailUrl.replace(recentTaoBaoOrderDetailUrlPrefix, passedOrderDetailUrlPrefix);
statusInfoDetailUrl = statusInfoDetailUrl.replace(recentTmallOrderDetailUrlPrefix, passedOrderDetailUrlPrefix);
}
//获取快照商品名称
var isEnableSnapProductName = document.getElementById("SnapProductNameStatus").checked;
if (isEnableSnapProductName === true) {
getSnapShotProductNameCount++;
getSnapShotProductName(subOrdersIteminfoSnapUrl, orderDataIndex);
} else {
subOrdersSnapshotProductName = "";
}
//精简数据
subOrdersIteminfoProductUrl = subOrdersIteminfoProductUrl.replace(/&_u=\w*/, "");
//subOrdersIteminfoSnapUrl = subOrdersIteminfoSnapUrl.replace(/&snapShot=true/, "");
subOrdersIteminfoSKUName = subOrdersIteminfoSKUName.replace(/颜色分类：?/, " ");
statusInfoDetailUrl = statusInfoDetailUrl.replace(/&route_to=tm1/, "");
//项目标题在序列中的位置自动同步到项目数据在序列中的位置
var orderDataItemData = [];
orderDataItemData[orderHeader.indexOf("下单日期")] = orderInfoDate;
orderDataItemData[orderHeader.indexOf("订单编号")] = orderInfoId;
orderDataItemData[orderHeader.indexOf("子订单编号")] = subOrdersIteminfoId;
orderDataItemData[orderHeader.indexOf("店铺名称")] = sellerInfoShopName;
orderDataItemData[orderHeader.indexOf("商品名称")] = subOrdersIteminfoProductName;
orderDataItemData[orderHeader.indexOf("快照商品名称")] = subOrdersSnapshotProductName;
orderDataItemData[orderHeader.indexOf("商品分类")] = subOrdersIteminfoSKUName;
orderDataItemData[orderHeader.indexOf("商品主图")] = subOrdersIteminfoPicUrl;
orderDataItemData[orderHeader.indexOf("商品链接")] = subOrdersIteminfoProductUrl;
orderDataItemData[orderHeader.indexOf("交易快照")] = subOrdersIteminfoSnapUrl;
orderDataItemData[orderHeader.indexOf("单价")] = subOrdersPriceinfoRealPrice;
orderDataItemData[orderHeader.indexOf("数量")] = subOrdersQuantityCount;
orderDataItemData[orderHeader.indexOf("实付款")] = payInfoActualFee;
orderDataItemData[orderHeader.indexOf("退款状态")] = subOrdersRefund;
orderDataItemData[orderHeader.indexOf("交易状态")] = statusInfoStatus;
orderDataItemData[orderHeader.indexOf("订单详情链接")] = statusInfoDetailUrl;
orderData[orderDataIndex] = orderDataItemData;
}
}
return orderData;
}
