爆品指数_竞争分析_流入流出总体分析

Greasy Fork is available in English.
爆品指数_竞争分析_流入流出总体分析

云图扩展工具
当前为 2023-10-10 提交的版本，查看最新版本。
换行
// ==UserScript==
// @name         爆品指数_竞争分析_流入流出总体分析
// @namespace    http://tampermonkey.net/
// @version      0.1
// @description  云图扩展工具
// @author       siji-Xian
// @match        *://yuntu.oceanengine.com/yuntu_ng/product/productOverview/productAnalysis/competition*
// @icon         https://www.google.com/s2/favicons?domain=oceanengine.com
// @grant        none
// @license      MIT
// @require      https://lf26-cdn-tos.bytecdntp.com/cdn/expire-1-M/jquery/3.2.1/jquery.min.js
// @require      https://cdn.bootcss.com/moment.js/2.20.1/moment.min.js
// @require      http://greasyfork.icu/scripts/404478-jsonexportexcel-min/code/JsonExportExcelmin.js?version=811266
// @require      http://greasyfork.icu/scripts/455576-qmsg/code/Qmsg.js?version=1122361
// ==/UserScript==

(function () {
  "use strict";
  var new_element = document.createElement("link");
  new_element.setAttribute("rel", "stylesheet");
  new_element.setAttribute("href", "https://qmsg.refrain.xyz/message.min.css");
  document.body.appendChild(new_element);

  const button = document.createElement("div");
  button.textContent = "导出画像";
  Object.assign(button.style, {
    height: "34px",
    lineHeight: "var(--line-height, 34px)",
    alignItems: "center",
    color: "#FFF",
    background: "linear-gradient(60deg, rgb(95, 240, 225), rgb(47, 132, 254))",
    borderRadius: "5px",
    marginLeft: "10px",
    fontSize: "13px",
    padding: "0 10px",
    cursor: "pointer",
    fontWeight: "500"
  });
  button.addEventListener("click", urlClick);

  let fetchList = [];

  window.au_fetch = window.fetch;
  window.fetch = async (...args) => {
    let [resource, config] = args;
    const response = await window.au_fetch(resource, config);
    if (
      response.url.slice(0, 79) ==
      "https://yuntu.oceanengine.com/product_node/api/graphql/?op=getProductCompetitor"
    ) {
      fetchList.push({ response, body: args[1].body });
    }
    return response;
  };

  function getQueryVariable(variable) {
    var query = window.location.search.substring(1);
    var vars = query.split("&");
    for (var i = 0; i < vars.length; i++) {
      var pair = vars[i].split("=");
      if (pair[0] == variable) {
        return pair[1];
      }
    }
    return false;
  }

  //获取aadvid
  const aadvid = getQueryVariable("aadvid");

  //message.js
  let loadingMsg = null;

  function appendDoc() {
    const likeComment = document.querySelectorAll(".right")[1];
    if (likeComment) {
      likeComment.append(button);
      return;
    }
    setTimeout(appendDoc, 1000);
  }
  appendDoc();

  async function getData() {

    let body = fetchList[fetchList.length - 1].body;
    var xhr = new XMLHttpRequest();
    xhr.withCredentials = true;

    xhr.addEventListener("readystatechange", function () {
      if (this.readyState === 4) {
        let _this = JSON.parse(this.responseText)
        console.log(_this)
        let data = _this.data.getProductCompetitor;
        expExcel(data);
      }
    });
    xhr.open("POST", fetchList[fetchList.length - 1].response.url);
    xhr.setRequestHeader("authority", "yuntu.oceanengine.com");
    xhr.setRequestHeader("accept", "*/*");
    xhr.setRequestHeader("accept-language", "zh-CN,zh;q=0.9");
    xhr.setRequestHeader("content-type", "application/json");

    xhr.send(body);
    return
  }

  function expExcel(e) {
    let data = e.map(v=>{
      return {...v.crowd,...v.product}
    })

    let contrast = {
      竞平名称: "name",
      ID: "id",
      到手价: "avgGmv",
      所属品牌: "brandName",
      共同点击人数: "commonClickUidCnt",
      占本品点击比例: "clickRatio",
      流入人数: "flowInUidCnt",
      流入占比: "flowInRatio",
      流出人数: "flowOutUidCnt",
      流出占比: "flowOutRatio",
      净流入比例: "dryFlowInRatio",
      都购买: "allBuyUidCnt",
      都未购买: "allNotBuyUidCnt",
    };
    let fileName = "爆品指数_竞争分析_流入流出总体分析";
    let option = {};
    option.fileName = fileName; //文件名
    option.datas = [{
      sheetName: '',
      sheetData: data,
      sheetHeader: Object.keys(contrast),
      sheetFilter: Object.values(contrast),
      columnWidths: [], // 列宽
    }]
    var toExcel = new ExportJsonExcel(option);
    toExcel.saveExcel();
    setTimeout(() => {
      loadingMsg.close();
    }, 1000);
  }

  function urlClick() {
    if (fetchList.length) {
      loadingMsg = Qmsg.loading("正在导出，请勿重复点击！");
      getData();
    } else {
      loadingMsg = Qmsg.error("数据加载失败，请重试");
    }
  }
})();