// ==UserScript==
// @name         邦供云辅助
// @namespace    http://tampermonkey.net/
// @version      1.0.3
// @description  注入外置代码，增加自定义功能
// @author       empyrealtear
// @match        http://bgy.zhengbang.com/
// @icon         https://www.google.com/s2/favicons?sz=64&domain=zhengbang.com
// @require      https://cdn.bootcdn.net/ajax/libs/jquery/3.7.1/jquery.js
// @require      https://cdn.sheetjs.com/xlsx-0.20.1/package/dist/xlsx.full.min.js
// @require      https://cdn.bootcdn.net/ajax/libs/FileSaver.js/2.0.5/FileSaver.min.js
// @require      https://cdn.bootcdn.net/ajax/libs/nanobar/0.4.2/nanobar.min.js
// @run-at       document-end
// @grant        unsafeWindow
// @grant        GM_xmlhttpRequest
// @grant        GM_setClipboard
// @grant        GM_setValue
// @grant        GM_getValue
// @grant        GM_openInTab
// @grant        GM_info
// @grant        GM_registerMenuCommand
// @grant        GM_unregisterMenuCommand
// @grant        GM_cookie
// @license      MIT
// ==/UserScript==

(function () {
    'use strict';

    const config = {
        url: {
            '产品管理': "http://bgy.zhengbang.com/blade-base/blade-product/product/page",
            '采购目录': "http://bgy.zhengbang.com/blade-pur/catalog/list",
            '采购计划': "http://bgy.zhengbang.com/blade-pur/plan/page",
            '采购计划明细': "http://bgy.zhengbang.com/blade-pur/plan/selectPlanById",
            '采购合同': "http://bgy.zhengbang.com/blade-pur/contract/page",
            '合同关联查询': "http://bgy.zhengbang.com/blade-pur/contract/getCascadList",
            '采购合同明细': "http://bgy.zhengbang.com/blade-pur/contract/selectContractDetail",
            '项目档案': "http://bgy.zhengbang.com/blade-pur/projectArchive/list",
            '到货验收': "http://bgy.zhengbang.com/blade-pur/blade-pur_arrival/arrival/page",
            '到货验收明细': "http://bgy.zhengbang.com/blade-pur/blade-pur_arrival/arrival/detail",
            '安装验收': "http://bgy.zhengbang.com/blade-pur/install/page",
            '安装验收明细': "http://bgy.zhengbang.com/blade-pur/install/selectInstall",
            '结算验收': "http://bgy.zhengbang.com/blade-fin/balance/page",
            '结算验收明细': "http://bgy.zhengbang.com/blade-fin/balance/selectBalanceDetail",
            '付款申请': "http://bgy.zhengbang.com/blade-fin/payApply/page",
            '付款申请明细': "http://bgy.zhengbang.com/blade-fin/payApply/selectPayApplyDetail",
            '财务付款': "http://bgy.zhengbang.com/blade-fin/pay/page",
            '财务付款待办': "http://bgy.zhengbang.com/blade-fin/payApply/selectUpcomingPay",
            '财务付款明细': "http://bgy.zhengbang.com/blade-fin/pay/selectPayDetail",
            '收款单': "http://bgy.zhengbang.com/blade-fin/receipt/list",
            '付款方式': "http://bgy.zhengbang.com/blade-base/payment/page",
            '履约保证金': "http://bgy.zhengbang.com/blade-pur/bzj/page"
        }
    }
    const utils = {
        readCookie: (key) => new RegExp(`${key}=(?<key>[^;]+)`).exec(document.cookie)?.groups?.key,
        page: (url, current = 1, size = 500, israw = true) => {
            var res
            jQuery.ajax({
                url: url + `?tenantCode=XMGC&current=${current}&size=${size}`,
                method: 'GET',
                headers: {
                    'Accept': 'application/json, text/plain, */*',
                    'Authorization': 'Basic eG1nYzp4bWdjX3NlY3JldA==',
                    'blade-auth': "bearer " + utils.readCookie('saber-access-token')
                },
                async: false,
                success: (e) => {
                    res = israw ? e : e['data']
                }
            })
            return res
        },
        pages: (url) => {
            var arr = []
            var total = utils.page(url, 1, 0)['data']['total']
            var cur = 1
            do {
                var res = utils.page(url, cur)
                if (res.code == 200) {
                    arr = arr.concat(res.data['records'])
                    cur += 1
                }
            } while (arr.length < total)
            return arr
        },
        detail: (url, id, isquery = true, israw = true) => {
            var res
            jQuery.ajax({
                url: url + (isquery ? `/${id}` : `?id=${id}`),
                method: 'GET',
                headers: {
                    'Accept': 'application/json, text/plain, */*',
                    'Authorization': 'Basic eG1nYzp4bWdjX3NlY3JldA==',
                    'blade-auth': "bearer " + utils.readCookie('saber-access-token')
                },
                async: false,
                success: (e) => {
                    res = israw ? e : e['data']
                }
            })
            return res
        },
        detailAsync: (url, id, isquery = true) => {
            return unsafeWindow.axios({
                url: url + (isquery ? `/${id}` : `?id=${id}`),
                method: 'GET',
                headers: {
                    'Accept': 'application/json, text/plain, */*',
                    'Authorization': 'Basic eG1nYzp4bWdjX3NlY3JldA==',
                    'blade-auth': "bearer " + utils.readCookie('saber-access-token')
                },
            })
        },
        asyncPool: async (arr, delegate, start = (v) => v, end = (v) => v, poolLimit = 10) => {
            const ret = []
            const executing = new Set()
            let arr_res = new Array(arr.length)
            let cur = 0
            let completeCount = 0

            var nanobar = new Nanobar({ id: 'nanobar', target: document.body })
            jQuery("#nanobar").css('background', '#BEE7E9')
            jQuery("#nanobar .bar").css('background', '#F4606C')

            arr = start(arr)
            for (const item of arr) {
                const p = Promise.resolve().then(async () => {
                    try {
                        var res = await delegate(item, arr)
                        arr_res[cur] = res
                    } catch (err) {
                        console.warn(err)
                        arr_res[cur] = err
                    }
                    return
                }).finally(() => {
                    nanobar.go((++completeCount) / arr.length * 100)
                    cur++
                })
                ret.push(p)
                executing.add(p)
                const clean = () => executing.delete(p)
                p.then(clean).catch(clean)
                if (executing.size >= poolLimit) {
                    await Promise.race(executing)
                }
            }
            return Promise.all(ret).then(() => {
                jQuery("#nanobar").remove()
                console.log(arr_res)
                console.log(completeCount)
                return end(arr_res)
            })
        },
        s2ab: (s) => {
            let buf = new ArrayBuffer(s.length)
            let view = new Uint8Array(buf)
            for (let i = 0; i != s.length; ++i) view[i] = s.charCodeAt(i) & 0xff
            return buf
        }
    }
    const export_module = {
        '采购合同': (v) => {
            try {
                var parity = jQuery.map(v['contractParitys'], x => {
                    if (x['isBid'] == '1')
                        return x
                })[0]
                var details = jQuery.map(v['contractDetails'], x => {
                    return {
                        '明细id': x['id'],
                        '计划id': x['planId'],
                        '计划名称': x['planName'],
                        '物料id': x['productId'],
                        '物料编码': x['productCode'],
                        '物料分类（设备名称）': x['productName'],
                        '物料名称（设备二级分类）': x['productTypeName'],
                        '规格型号': x['productSpec'],
                        '单位': x['masterUnitName'],
                        '采购数量': x['purQuantity'],
                        '单价': x['purPrice'],
                        '设备金额': x['purAmount'],
                    }
                })
                return {
                    '合同id': v['id'],
                    '采购主体': v['companyName'],
                    '项目名称': v['projectName'],
                    '供应商名称': v['supplyName'],
                    '合同明细': details,
                    '比价id': parity['id'],
                    '设备总金额': parity['productTotalAmount'],
                    '设备税率': parity['equipmentTaxRate'],
                    '运费': parity['transportAmount'],
                    '运距': parity['transportDistance'],
                    '运费标准': parity['freightStandard'],
                    '安装费': parity['installAmount'],
                    '安装标准': parity['installStandard'],
                    '优惠金额': parity['discountAmount'],
                    '明细总金额（表单）': parity['totalAmount'],
                    '合同总金额（列表）': v['totalAmount'],
                    '合同编号': v['contractCode'],
                    '合同标题': v['contractName'],
                    '签订日期': v['contractDate'],
                    '合同签订人': v['createName'],
                    '审批状态': v['status']
                }
            } catch(err) {
                console.warn(err)
                return {
                    '合同id': v['id'],
                    '采购主体': v['companyName'],
                    '项目名称': v['projectName'],
                    '供应商名称': v['supplyName'],
                    '合同明细': [],
                    '比价id': null,
                    '设备总金额': null,
                    '设备税率': null,
                    '运费': null,
                    '运距': null,
                    '运费标准': null,
                    '安装费': null,
                    '安装标准': null,
                    '优惠金额': null,
                    '明细总金额（表单）': null,
                    '合同总金额（列表）': v['totalAmount'],
                    '合同编号': v['contractCode'],
                    '合同标题': v['contractName'],
                    '签订日期': v['contractDate'],
                    '合同签订人': v['createName'],
                    '审批状态': v['status']
                }
            }
        }
    }

    unsafeWindow.jQuery = jQuery
    unsafeWindow.config = config
    unsafeWindow.utils = utils
    // unsafeWindow.export_module = export_module
    // unsafeWindow.XLSX = XLSX
    // unsafeWindow.Nanobar = Nanobar

    function downloadList() {
        //var arr = utils.page(config.url['采购合同'], 1, 200, false)['records']
        var arr = utils.pages(config.url['采购合同'])
        console.log(arr.length)
        //var mid = Math.ceil(arr.length / 2)
        //arr = arr.slice(0, mid)
        //arr = arr.slice(mid + 1, arr.length)
        var details = utils.asyncPool(arr, async (v) => {
            await utils.detailAsync(config.url['采购合同明细'], v.id).then(e => {
                var res = e['data']
                v['contractDetails'] = res['contractDetails']
                v['contractParitys'] = res['contractParitys']
                v['contractAtts'] = res['contractAtts']
                return v
            })
            return v
        }, (v) => v, v => {
            var arr = jQuery.map(v, i => {
                try {
                    return export_module['采购合同'](i)
                } catch(error) {
                    console.log(i)
                }
            })
            var ext = jQuery.map(arr, i => {
                for (let k in i) {
                    if (k != '合同明细')
                        jQuery.map(i['合同明细'], dts => {
                            dts[k] = i[k]
                        })
                }
                return i['合同明细']
            })
            var workbook = XLSX.utils.book_new()
            XLSX.utils.book_append_sheet(workbook, XLSX.utils.json_to_sheet(arr, {
                header: [
                    '合同id', '采购主体', '项目名称', '供应商名称', '明细id', '计划id', '计划名称', '比价id',
                    '设备总金额', '设备税率', '运费', '运距', '运费标准', '安装费', '安装标准', '优惠金额',
                    '明细总金额（表单）', '合同总金额（列表）', '合同编号', '合同标题', '签订日期', '合同签订人']
            }), '采购订单')
            XLSX.utils.book_append_sheet(workbook, XLSX.utils.json_to_sheet(ext, {
                header: [
                    '合同id', '采购主体', '项目名称', '供应商名称', '明细id', '计划id', '计划名称',
                    '物料id', '物料编码', '物料分类（设备名称）', '物料名称（设备二级分类）', '规格型号',
                    '单位', '采购数量', '单价', '设备金额', '比价id', '设备总金额', '设备税率', '运费',
                    '运距', '运费标准', '安装费', '安装标准', '优惠金额', '明细总金额（表单）', '合同总金额（列表）',
                    '合同编号', '合同标题', '签订日期', '合同签订人']
            }), '订单明细')
            //console.log(v, arr, ext)
            let wbout = XLSX.write(workbook, { bookType: 'xlsx', type: 'binary' });
            saveAs(new Blob([utils.s2ab(wbout)], { type: 'application/octet-stream' }), '采购订单明细.xlsx')
        })
    }

    GM_registerMenuCommand("遍历合同列表", downloadList)
})();