天猫详情商品信息提取

天猫详情商品信息提取辅助，用于批量开票的信息辅助
Wrap lines
// ==UserScript==
// @name         天猫详情商品信息提取
// @namespace    http://tampermonkey.net/
// @homepage     https://einvoice.taobao.com/?source=qn#/invoice/compensate
// @version      1.1.0
// @description  天猫详情商品信息提取辅助，用于批量开票的信息辅助
// @author       You
// @match        https://trade.tmall.com/detail/orderDetail.htm*
// @match        https://myseller.taobao.com/home.htm*
// @match        https://einvoice.taobao.com/*
// @match        https://qn.taobao.com/home.htm/*
// @match        https://dppt.jiangsu.chinatax.gov.cn:8443/*
// @icon         https://icons.duckduckgo.com/ip2/tmall.com.ico
// @grant        GM_setClipboard
// @grant        GM_setValue
// @grant        GM_getValue
// @grant        GM_registerMenuCommand
// @grant        GM_listValues
// @grant        GM_deleteValue
// @license      MIT
// ==/UserScript==
 
(async function () {
    'use strict';
 
    /**
     * 新版天猫详情
     * @returns obj
     */
    async function get_order_obj() {
        const result = { hasRepeat: false }
        const products = []
        let finded = await el_find("div[class^=order-info_order-info] tr.order-item");
        if (!finded) {
            let msg = "页面加载超时/结构更新，未找到商品列表信息";
            alert(msg);
            throw msg;
        }
        const order_item = document.querySelectorAll("div[class^=order-info_order-info] tr.order-item");
 
        const titles = []
        for (let item of order_item) {
            const temp = get_detail(item)
            console.log("temp=", temp)
            if (temp !== null && temp.price !== '0.00') {
                if (titles.includes(temp.title)) {
                    result.hasRepeat = true
                    continue;
                }
                products.push(temp)
            }
        }
 
        function get_detail(item) {
            const tds = item.querySelectorAll('td');
            if (tds.length < 5) {
                return null
            }
            const details = {}
            // 标题
            details.title = tds[0].querySelector('a')?.innerText;
            // 商品编码
            const code = /[A-Z]{2,3}\d{6}-?[0-9A-Z]{0,5}/.exec(tds[0].innerText)
            details.code = code !== null ? code[0] : ''
            // 状态
            details.status = tds[2].innerText
            // 单价
            details.price = tds[3].innerText.replace('\n', '')
            // 数量
            details.count = tds[4].innerText
            return details;
        }
 
        const order_id_re = /订单编号:[1-9][0-9]*/.exec(document.querySelector("div[class^=misc-info_misc-info__]")?.innerText)
        if (order_id_re === null) {
            return null
        }
        result.id = order_id_re[0].replace('订单编号:', '')
        result.products = products
        return result
    }
 
    function getExportInvoiceInfo() {
        const values = prompt("请粘贴天猫发票平台导出数据")
        const list = [];
        for (let row of values.replace('\r\n', '\n').split('\n')) {
            const cells = row.split('\t');
            list.push(cells);
        }
        const T = {};
        const title = list[0];
        for (let i = 0; i < title.length; i++) {
            T[title[i]] = i;
        }
 
        const trades = {};
        for (let item of list) {
            const id = item[T['*订单编号']];
            if (id === '*订单编号') { continue; }
            let temp = trades[id] === void 0 ? { 'id': id, 'products': {}, 'company': {} } : trades[id];
            // 如果企业信息未空，则填充
            if (JSON.stringify(temp.company) === '{}') {
                temp.company.name = item[T['*发票抬头']] !== void 0 ? item[T['*发票抬头']] : '';
                temp.company.id = item[T['购方税号']] !== void 0 ? item[T['购方税号']] : '';
                temp.company.address = item[T['企业地址']] !== void 0 ? item[T['企业地址']] : '';
                temp.company.phone = item[T['企业电话']] !== void 0 ? item[T['企业电话']] : '';
                temp.company.bank = item[T['开户行']] !== void 0 ? item[T['开户行']] : '';
                temp.company.account = item[T['开户账号']] !== void 0 ? item[T['开户账号']] : '';
            }
            // 添加商品
            let name = item[T['货物名称']];
            temp.products[name] = {
                'price_invoice': item[T['商品金额']],
                'count': item[T['数量']]
            }
            // 重新写入trades
            trades[id] = temp;
        }
        return trades;
    }
 
    GM_registerMenuCommand("提取订单信息", () => {
        const trades = GM_listValues();
        for (let item of trades) {
            GM_deleteValue(item)
        }
        let ids = prompt("输入订单号");
        for (let k of ['\n', '\r', '\t', ' ', '，', ',,', ',,']) {
            ids = ids.replaceAll(k, ',')
        }
        const arr = ids.split(',');
        for (let id of arr) {
            GM_setValue(id, false);
        }
        if (arr.length > 0 && arr[0] !== '') {
            GM_setValue('running', true);
            GM_setValue('current', arr[0]);
            window.open(`https://trade.tmall.com/detail/orderDetail.htm?biz_order_id=${arr[0]}`)
        }
    })
 
    GM_registerMenuCommand("导入发票信息", () => {
        const trades = GM_listValues();
        const invoices = getExportInvoiceInfo();
        for (let item of trades) {
            // 用订单号查询存储结果，没有结果的设为激活的，下一次处理
            const trade = GM_getValue(item, false);
            console.log(typeof (trade), trade)
            const invoice = invoices[item]; // 从导入数据提取订单信息
            if (trade && invoice !== void 0) {
                const ps = invoice.products; // 天猫导出的数据
                const co = invoice.company; // 天猫导出的数据
                console.log("ps=", ps)
                console.log("co=", co)
                console.log("trade=", trade)
                const nps = [];
                for (let p of trade.products) {
                    if (!p.status.includes("退款成功")) {
                        const p1 = ps[p.title];
                        nps.push({
                            'title': p.title,
                            'code': p.code,
                            'price_invoice': p1.price_invoice,
                            'price_page': p.price_page,
                            'count': p1.count,
                            'status': p.status,
                        })
                    }
                }
                trade.products = nps;
                trade.company = co;
                GM_setValue(item, trade);
            }
        }
        alert("发票信息导入处理完成");
    })
 
    GM_registerMenuCommand("结果=>发票基本信息", () => {
        const trades = GM_listValues();
        let results = '';
        for (let item of trades) {
            // 用订单号查询存储结果，没有结果的设为激活的，下一次处理
            const trade = GM_getValue(item, false);
            if (trade.company !== void 0) {
                const id = trade.id;
                const co = trade.company;
                results += `${id}\t普通发票\t\t是\t\t${co.name}\t\t${co.id}\t${co.address}\t${co.phone}\t${co.bank}\t${co.account}\t${id}\n`;
            }
        }
        console.log(results);
        GM_setClipboard(results);
        alert("发票基本信息已复制")
    })
 
    GM_registerMenuCommand("结果=>发票明细信息", () => {
        const trades = GM_listValues();
        let results = '';
        for (let item of trades) {
            // 用订单号查询存储结果，没有结果的设为激活的，下一次处理
            const trade = GM_getValue(item, false);
            if (trade.company !== void 0) {
                const id = trade.id;
                const ps = trade.products;
                for (let p of ps) {
                    results += `${id}\t${p.code}\t\t\t件\t${p.count}\t\t${p.price_invoice}\t0.13\n`;
                }
            }
        }
        console.log(results);
        GM_setClipboard(results);
        alert("发票明细信息已复制")
    })
 
 
    GM_registerMenuCommand("屏蔽发票申请界面元素", () => {
        if (!document.URL.includes('merchant-invoice')) { return }
        const els = document.querySelectorAll("div[class*=SearchContent_search]");
        const keys = ["是否免赔", "开票倒计时"];
        for (let el of els) {
            for (let key of keys) {
                if (el.innerText.includes(key)) { el.style.display = "none"; }
            }
        }
    })
 
    /**
     * 
     * @param {string} selector 
     * @param {number} count 查找次数，默认10
     * @param {number} ms 查找间隔，默认500ms
     * @returns 
     */
    async function el_find(selector, count = 10, ms = 500) {
        let found = false
        for (let i = 0; i < count; i++) {
            console.log(`尝试${i + 1}/${count}次查找【${selector}】`)
            found = await new Promise((resolve) => {
                setTimeout(() => {
                    resolve(document.querySelector(selector) !== null);
                }, ms);
            })
            if (found) {
                console.log('got it ' + selector)
                break
            }
        }
        return found;
    }
 
    // 订单详情读取
 
    if (!document.URL.includes('https://qn.taobao.com/home.htm/trade-platform/tp/detail')) { return; }
 
    setTimeout(async () => {
        const current = GM_getValue('current', false);
        if (!current) { return; }
        if (document.URL.includes(current)) {
            const p = await get_order_obj()
            console.log(current, ":", p)
            if (p.hasRepeat) {
                console.log(current, '存在重复商品，跳过未统计')
            } else {
                GM_setValue(current, p);
                console.log(GM_getValue(current, `GM获取失败,${current}`));
            }
        }
        const running = GM_getValue('running', false);
        if (!running) { return; }
        const trades = GM_listValues();
        for (let item of trades) {
            // 用订单号查询存储结果，没有结果的设为激活的，下一次处理
            if (!GM_getValue(item, false)) {
                GM_setValue('current', item);
                window.location = `https://qn.taobao.com/home.htm/trade-platform/tp/detail?bizOrderId=${item}`
                return;
            }
        }
        GM_deleteValue('running');
        GM_deleteValue('current');
        alert("订单遍历完成");
    }, 3000);
})();
欢迎访问Greasy Fork镜像
