// ==UserScript==
// @name walmart 绩效快速统计
// @namespace http://tampermonkey.net/
// @version 1.3
// @description 用在沃尔玛运营时候简化一部分操作用 私人脚本
// @author w1w
// @match *://seller.walmart.com/partner-analytics/performance/financials*
// @require http://libs.baidu.com/jquery/2.0.0/jquery.min.js
// @require https://cdn.bootcdn.net/ajax/libs/noty/3.1.4/noty.min.js
// @icon https://www.google.com/s2/favicons?domain=walmart.com
// @grant none
// @license MIT
// @downloadURL none
// ==/UserScript==
//缝缝补补用三年 简化下沃尔玛后台的运营操作。
window.hide = (el, showtime, time) => {
    let alpha = 100;
    el.style.opacity = alpha/100;
    setTimeout(() => {
        let a = setInterval(() => {
            //console.log(alpha)
            el.style.opacity = alpha / 100; alpha -= 2; if
                (alpha <= 15) {el.style.opacity =0; clearInterval(a) }
        }, time / 50)
        }, showtime)
}
window.copy=()=> {
    let transfer = document.querySelector('#textarea22588');
    transfer.style.display = ""
    transfer.value = copyData;  // 这里表示想要复制的内容
    transfer.focus();
    transfer.select();
    //alert("复制完成");
    hide(document.querySelector('artDilog'), 1.6e3,1.6e3)
    if (document.execCommand('copy')) {
        document.execCommand('copy');
    }
    transfer.blur();
    transfer.style.display = "none"
    console.log('复制成功');

    //document.body.removeChild(transfer);
}
window.todayValue = function() {
    var d = new Date();
    var todayValue = d.getFullYear() + '-' + (d.getMonth() + 1) + '-' + d.getDate();
    return todayValue;
}
window.addZero = function(data) {
    if (data.length < 2) {
        return '0' + data
    } else {
        return data
    }
}
window.id = 'tab' + Date.now();
window.timeIsRight = 1;
var tem =
    ` <form class="newSearch" style="text-align:center;">

    <input type="text" id="nowTime" value=""/>
                            <span>开始时间:</span><input type="text" id="stt" value="2021-10-1"/>
                            <span>结束时间：</span><input type="text" id="ent" value="2021-10-1"/>
                            <!--<input type="button" id='today' value="数据直到今天" />--!>
                            <input type="button" id = 'TDay' value="最近三天" />
                            <input type="button" id = 'SDay' value="最近七天" />
                            <input type="button" id = 'sameDay' value="同一天" />
                            <input type="button" id = 'go' value="开始" />
                            <input type="button" id = 'copyData' value="复制" />
                        <span>请不要一下子搜索太长时间跨度单次上限100天（不要改系统时区，时间计算会出错的）</span></form>
                        <tab id="` + id + `"><br/></tab><textarea id = "textarea22588" style = "display:none"></textarea>

                            <artDilog style="opacity: 0;">
        <div
            style="z-index:2147483646;min-width:200px;display:flex; align-items :center;justify-content: center; max-width: 270px; width: 15%; background-color: #fee; box-shadow: 3px 4px 4px #c2c2c2; border-radius: 10px; height: 100px; box-sizing: border-box; padding: 25px 36px; position: fixed; right: 66px; top: 66px;">
            <svg width="30" height="30" t="1646120175810" class="icon"
                    viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="2065">
                    <path
                        d="M512 0C229.2 0 0 229.2 0 512s229.2 512 512 512 512-229.2 512-512S794.8 0 512 0z m-32 769V353c0-17.7 14.3-32 32-32s32 14.3 32 32v416c0 8.8-3.6 16.8-9.4 22.6-5.8 5.8-13.8 9.4-22.6 9.4-17.7 0-32-14.3-32-32z m64-543.5c0 8.8-3.6 16.8-9.4 22.6-5.8 5.8-13.8 9.4-22.6 9.4-17.7 0-32-14.3-32-32v-1c0-17.7 14.3-32 32-32s32 14.3 32 32v1z"
                        p-id="2066" fill="#72dcfc"></path>
                </svg>
            <div style="display: inline;font-size: 20px;padding-left: 10px;">复制成功</div>
        </div>

    </artDilog>

                        `;
window.templete = `<tr>
            <td class='newT'> Data</td>
            <td class='newT'> ITEM ID</td>
            <td class='newT'> DEPARTMENT</td>
            <td class='newT'> BRAND</td>
            <td class='newT'> GMV</td>
            <td class='newT'> COMMISSION</td>
            <td class='newT'> GMV - COMMISSION</td>
            <td class='newT'> AUR</td>
            <td class='newT'> TOTAL UNITS SOLD</td>
            <td class='newT'> CANCELLED UNITS</td>
            <td class='newT'> CANCELLED SALES</td>
            <td class='newT'> CANCELLED SALES %</td>
            <td class='newT'> CANCELLED UNITS %</td>
            <td class='newT'> ITEM CONVERSION RATE</td>
            <td class='newT'> BASE ITEM ID</td>
            <td class='newT'> SKU</td>
            <td class='newT'> TOTAL PRODUCT VISITS</td>
        </tr>`;
window.getDayilyData = (dateTime)=> {
    var getXToken =()=>{
        var r = new RegExp('XSRF-TOKEN=(.*?);')
        var xtoken = document.cookie.match(r)[1].toString();
        //console.log(xtoken);
        return xtoken;
    }
    window.tempVal = [];
    let offsetTime = new Date(dateTime);
    offsetTime = offsetTime.getTime() - 86400000 * 1
    offsetTime = new Date(offsetTime)
    offsetTime = offsetTime.getFullYear() + '-' + addZero('' + (offsetTime.getMonth() + 1)) + '-' +
        addZero('' + offsetTime.getDate())
    $.ajax({
        url: 'https://seller.walmart.com/api/aurora/financial/getItemSales',
        type: 'POST',
        async: false,
        contentType: 'application/json',
        dataType: 'json',
        tryCount : 0,
        retryLimit : 5,
        headers: {
            Accept: "application/json",
            'x-xsrf-token': getXToken()
        },
        data: '{"filter":{"filterBy":{"duration":["' + offsetTime + '","' + offsetTime +
        '"],"program":"ALL"},"sortBy":{}},"pagination":{"pageNumber":1,"pageSize":25}}',
        success(e) {
            console.log('seccucs...')
            allDate.push(e['data']);
            tempVal.push(e)
        },
        error (xhr, textStatus, errorThrown ) {
            this.tryCount++;
            if (this.tryCount <= this.retryLimit) {
                //try again
                $.ajax(this);
                return;
            }
        },})
};
window.getDaily = function() {
    window.allDate = [];
    window.tableData = '';
    window.timeList = [];
    let stt = $('#stt').val();
    let ent = $('#ent').val();
    stt = new Date(stt);
    ent = new Date(ent);
    if(stt=="Invalid Date" || ent =="Invalid Date"){
        alert("请输入正确时间格式！");
        timeIsRight = 0;
        return 0
    }
    var stt_T = stt.getTime()
    var ent_T = ent.getTime()
    if (stt_T > ent_T){
        alert("请输入正确时间顺序！");
        timeIsRight = 0;
        return 0
    }else{
        timeIsRight =1 ;
    }
    ent = (ent.getFullYear() + '-' + addZero('' + (ent.getMonth() + 1)) + '-' + addZero('' + ent.getDate()))
    var iii = 100    //单次搜索上限
    let temp = stt.getFullYear() + '-' + addZero('' + (stt.getMonth() + 1)) + '-' + addZero('' + stt.getDate())
    timeList.push(temp)
    if (temp != ent) {
        while (iii > 0) {
            stt_T = 86400000 + stt_T;
            let temDate = new Date(stt_T)
            temp = temDate.getFullYear() + '-' + addZero('' + (temDate.getMonth() + 1)) + '-' + addZero('' + temDate.getDate())
            timeList.push(temp)
            if (temp == ent) {
                break
            } else {
                iii--
            }
        }
    }

    return 0
};

window.mainLunch = function() {
    console.log("点击开始运行");
    getDaily();
    if (timeIsRight == 0){
        return 0
    }
    console.log(timeList.length);
    for (var i = 0; i < timeList.length; i++) {
        getDayilyData(timeList[i])
    };
    formatTable();
    clearTable();
    insertTable();
    //setTimeout(copy,2333);
    $('#copyData')[0].style.background='#f99'
};
window.clearTable = function() {
    if ($('#' + id).children().length > 1) {
        $('#' + id).children()[0].remove();
    }
}
window.insertTable = function() {
    window.allTable = window.templete + window.tableData;
    window.div_tab = document.createElement('table');
    div_tab.innerHTML = allTable
    $('#' + id).children()[0].before(div_tab);
    $('#' + id).children()[0].style.fontSize = '6px';
    $('#' + id).children()[0].style.border = '1px solid';
    $('#' + id).children()[0].style.textAlign = 'center';
};

window.formatTable = function() {




    window.copyData="";
    for (var i = 0; i < allDate.length; i++) {
        let temp = allDate[i]
        if (temp == []) {
            continue
        } else {
            for (var ii = 0; ii < temp.length; ii++) {
                var tempDate = temp[ii]
                window.copyData+= (timeList[i] +"\t"+
                                   tempDate['catlgItemId'] +"\t"+
                                   tempDate['department'] +"\t"+
                                   tempDate['brandName'] +"\t"+
                                   tempDate['TotalGMV'] +"\t"+
                                   tempDate['TotalCommissions'] +"\t"+
                                   (tempDate['TotalGMV'] - tempDate['TotalCommissions']) +"\t"+
                                   tempDate['AuthAUR'] +"\t"+
                                   tempDate['TotalUnits'] +"\t"+
                                   tempDate['TotalCancelUnits'] +"\t"+
                                   tempDate['TotalCancelAmt'] +"\t"+
                                   (tempDate['TotalCancelAmt'] / tempDate['TotalAuthAmt']) +"\t"+
                                   (tempDate['TotalCancelUnits'] / tempDate['TotalAuthUnits']) +"\t"+
                                   tempDate['Conversion'] +"\t"+
                                   tempDate['baseItemId'] +"\t"+
                                   tempDate['skuId'] +"\t"+
                                   tempDate['TotalProductVisits'] +"\r\n")
                window.tableData = window.tableData +
                    "<tr><td class= 'newT'>" + timeList[i] +
                    "</td><td class= 'newT'>" + tempDate['catlgItemId'] +
                    "</td><td class= 'newT'>" + tempDate['department'] +
                    "</td><td class= 'newT'>" + tempDate['brandName'] +
                    "</td><td class= 'newT'>" + tempDate['TotalGMV'] +
                    "</td><td class= 'newT'>" + tempDate['TotalCommissions'] +
                    "</td><td class= 'newT'>" + (tempDate['TotalGMV'] - tempDate['TotalCommissions']) +
                    "</td><td class= 'newT'>" + tempDate['AuthAUR'] +
                    "</td><td class= 'newT'>" + tempDate['TotalUnits'] +
                    "</td><td class= 'newT'>" + tempDate['TotalCancelUnits'] +
                    "</td><td class= 'newT'>" + tempDate['TotalCancelAmt'] +
                    "</td><td class= 'newT'>" + (tempDate['TotalCancelAmt'] / tempDate['TotalAuthAmt']) +
                    "</td><td class= 'newT'>" + (tempDate['TotalCancelUnits'] / tempDate['TotalAuthUnits']) +
                    "</td><td class= 'newT'>" + tempDate['Conversion'] +
                    "</td><td class= 'newT'>" + tempDate['baseItemId'] +
                    "</td><td class= 'newT'>" + tempDate['skuId'] +
                    "</td><td class= 'newT'>" + tempDate['TotalProductVisits'] +
                    "</td></tr>";
            }
        }
    }
};

$().ready(function() {
    let date =new Date();
    date = date.getTime()
    let div_section = document.createElement('section')
    let tempDate;
    div_section.innerHTML = tem
    setTimeout(()=>{document.querySelector("#subapp-main-0 > div > div:nth-child(1) > div > div:nth-child(3) > div").before(div_section)
                    tempDate = date-86400000*5;
                    tempDate = new Date(tempDate);
                    $("#ent").val(todayValue());
                    $("#stt").val(tempDate.getFullYear() + '-' + addZero('' + (tempDate.getMonth() + 1)) + '-' + addZero('' + tempDate.getDate()));
                    $("#sameDay").bind('click', function() {
                        $("#ent").val($("#stt").val());
                    });
                    $("#TDay").bind('click', function() {
                        $("#ent").val(todayValue());
                        tempDate = date-86400000*3;
                        tempDate = new Date(tempDate);
                        $("#stt").val(tempDate.getFullYear() + '-' + addZero('' + (tempDate.getMonth() + 1)) + '-' + addZero('' + tempDate.getDate()));
                    });
                    $("#SDay").bind('click', function() {
                        $("#ent").val(todayValue());
                        tempDate = date-86400000*7;
                        tempDate = new Date(tempDate);
                        $("#stt").val(tempDate.getFullYear() + '-' + addZero('' + (tempDate.getMonth() + 1)) + '-' + addZero('' + tempDate.getDate()));
                    });
                    $("#go").bind('click', function() {
                        mainLunch()
                    });
                    $("#today").bind('click', function() {
                        $("#ent").val(todayValue())
                    });
                    $("#copyData").bind('click', function() {
                        copy()
                    });
                  var nowTime = () => {
                        let d = new Date()
                        $('#nowTime').val('' + d.getHours() + ':' + addZero('' + d.getMinutes()) + ':' + addZero('' + d.getSeconds()))
                    }
                    setInterval(nowTime, 500)},1500)
})