Greasy Fork is available in English.

GTA导出

云图扩展工具

// ==UserScript==
// @name         GTA导出
// @namespace    http://tampermonkey.net/
// @license      MIT
// @version      0.8
// @description  云图扩展工具
// @author       siji-Xian
// @match        *://yuntu.oceanengine.com/yuntu_ng/assets/crowd/monitoring?*
// @icon         https://www.google.com/s2/favicons?domain=oceanengine.com
// @grant        none
// @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      https://greasyfork.org/scripts/404478-jsonexportexcel-min/code/JsonExportExcelmin.js?version=811266
// @require      https://greasyfork.org/scripts/463728-lodash-js/code/lodashjs.js?version=1174104
// @require      https://greasyfork.org/scripts/455576-qmsg/code/Qmsg.js?version=1122361
// ==/UserScript==

(function () {
  "use strict";
  var analysis_type = 1, //0是蓄水期, 1是活动期
    gta_type = 1; //1是新客蓄水期 ,2是新客活动期 ,4是老客   //analysis_type = 0 不用管这个

  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);

  var button1_1 = document.createElement("button"); //创建一个按钮
  button1_1.textContent = "进行中蓄水"; //按钮内容
  button1_1.style.height = "32px"; //高
  button1_1.style.lineHeight = "32px"; //行高
  button1_1.style.align = "center"; //文本居中
  button1_1.style.color = "white"; //按钮文字颜色
  button1_1.style.background = "#1f4bd9"; //按钮底色
  button1_1.style.border = "0px"; //边框属性
  button1_1.style.borderRadius = "0px"; //按钮四个角弧度
  button1_1.style.marginLeft = "10px";
  button1_1.style.fontSize = "12px";
  button1_1.style.padding = "0 5px";
  button1_1.addEventListener("click", urlClick1_1); //监听按钮点击事件

  var button1_2 = document.createElement("button"); //创建一个按钮
  button1_2.textContent = "进行中新客蓄水"; //按钮内容
  button1_2.style.height = "32px"; //高
  button1_2.style.lineHeight = "32px"; //行高
  button1_2.style.align = "center"; //文本居中
  button1_2.style.color = "white"; //按钮文字颜色
  button1_2.style.background = "#1f4bd9"; //按钮底色
  button1_2.style.border = "0px"; //边框属性
  button1_2.style.borderRadius = "0px"; //按钮四个角弧度
  button1_2.style.marginLeft = "10px";
  button1_2.style.fontSize = "12px";
  button1_2.style.padding = "0 5px";
  button1_2.addEventListener("click", urlClick1_2); //监听按钮点击事件

  var button1_3 = document.createElement("button"); //创建一个按钮
  button1_3.textContent = "进行中活动新增"; //按钮内容
  button1_3.style.height = "32px"; //高
  button1_3.style.lineHeight = "32px"; //行高
  button1_3.style.align = "center"; //文本居中
  button1_3.style.color = "white"; //按钮文字颜色
  button1_3.style.background = "#1f4bd9"; //按钮底色
  button1_3.style.border = "0px"; //边框属性
  button1_3.style.borderRadius = "0px"; //按钮四个角弧度
  button1_3.style.marginLeft = "10px";
  button1_3.style.fontSize = "12px";
  button1_3.style.padding = "0 5px";
  button1_3.addEventListener("click", urlClick1_3); //监听按钮点击事件

  var button1_4 = document.createElement("button"); //创建一个按钮
  button1_4.textContent = "进行中老客转化"; //按钮内容
  button1_4.style.height = "32px"; //高
  button1_4.style.lineHeight = "32px"; //行高
  button1_4.style.align = "center"; //文本居中
  button1_4.style.color = "white"; //按钮文字颜色
  button1_4.style.background = "#1f4bd9"; //按钮底色
  button1_4.style.border = "0px"; //边框属性
  button1_4.style.borderRadius = "0px"; //按钮四个角弧度
  button1_4.style.marginLeft = "10px";
  button1_4.style.fontSize = "12px";
  button1_4.style.padding = "0 5px";
  button1_4.addEventListener("click", urlClick1_4); //监听按钮点击事件

  var button = document.createElement("button"); //创建一个按钮
  button.textContent = "进行中成交概览"; //按钮内容
  button.style.height = "32px"; //高
  button.style.lineHeight = "32px"; //行高
  button.style.align = "center"; //文本居中
  button.style.color = "white"; //按钮文字颜色
  button.style.background = "#1f4bd9"; //按钮底色
  button.style.border = "0px"; //边框属性
  button.style.borderRadius = "0px"; //按钮四个角弧度
  button.style.marginLeft = "10px";
  button.style.fontSize = "12px";
  button.style.padding = "0 5px";
  button.addEventListener("click", urlClick); //监听按钮点击事件

  var button2_1 = document.createElement("button"); //创建一个按钮
  button2_1.textContent = "历史蓄水"; //按钮内容
  button2_1.style.height = "32px"; //高
  button2_1.style.lineHeight = "32px"; //行高
  button2_1.style.align = "center"; //文本居中
  button2_1.style.color = "white"; //按钮文字颜色
  button2_1.style.background = "#1f4bd9"; //按钮底色
  button2_1.style.border = "0px"; //边框属性
  button2_1.style.borderRadius = "0px"; //按钮四个角弧度
  button2_1.style.marginLeft = "10px";
  button2_1.style.fontSize = "12px";
  button2_1.style.padding = "0 5px";
  button2_1.addEventListener("click", urlClick2_1); //监听按钮点击事件

  var button2_2 = document.createElement("button"); //创建一个按钮
  button2_2.textContent = "历史新客蓄水"; //按钮内容
  button2_2.style.height = "32px"; //高
  button2_2.style.lineHeight = "32px"; //行高
  button2_2.style.align = "center"; //文本居中
  button2_2.style.color = "white"; //按钮文字颜色
  button2_2.style.background = "#1f4bd9"; //按钮底色
  button2_2.style.border = "0px"; //边框属性
  button2_2.style.borderRadius = "0px"; //按钮四个角弧度
  button2_2.style.marginLeft = "10px";
  button2_2.style.fontSize = "12px";
  button2_2.style.padding = "0 5px";
  button2_2.addEventListener("click", urlClick2_2); //监听按钮点击事件

  var button2_3 = document.createElement("button"); //创建一个按钮
  button2_3.textContent = "历史新客新增"; //按钮内容
  button2_3.style.height = "32px"; //高
  button2_3.style.lineHeight = "32px"; //行高
  button2_3.style.align = "center"; //文本居中
  button2_3.style.color = "white"; //按钮文字颜色
  button2_3.style.background = "#1f4bd9"; //按钮底色
  button2_3.style.border = "0px"; //边框属性
  button2_3.style.borderRadius = "0px"; //按钮四个角弧度
  button2_3.style.marginLeft = "10px";
  button2_3.style.fontSize = "12px";
  button2_3.style.padding = "0 5px";
  button2_3.addEventListener("click", urlClick2_3); //监听按钮点击事件

  var button2_4 = document.createElement("button"); //创建一个按钮
  button2_4.textContent = "历史老客转化"; //按钮内容
  button2_4.style.height = "32px"; //高
  button2_4.style.lineHeight = "32px"; //行高
  button2_4.style.align = "center"; //文本居中
  button2_4.style.color = "white"; //按钮文字颜色
  button2_4.style.background = "#1f4bd9"; //按钮底色
  button2_4.style.border = "0px"; //边框属性
  button2_4.style.borderRadius = "0px"; //按钮四个角弧度
  button2_4.style.marginLeft = "10px";
  button2_4.style.fontSize = "12px";
  button2_4.style.padding = "0 5px";
  button2_4.addEventListener("click", urlClick2_4); //监听按钮点击事件

  var button3_1 = document.createElement("button"); //创建一个按钮
  button3_1.textContent = "自定义蓄水"; //按钮内容
  button3_1.style.height = "32px"; //高
  button3_1.style.lineHeight = "32px"; //行高
  button3_1.style.align = "center"; //文本居中
  button3_1.style.color = "white"; //按钮文字颜色
  button3_1.style.background = "#1f4bd9"; //按钮底色
  button3_1.style.border = "0px"; //边框属性
  button3_1.style.borderRadius = "0px"; //按钮四个角弧度
  button3_1.style.marginLeft = "10px";
  button3_1.style.fontSize = "12px";
  button3_1.style.padding = "0 5px";
  button3_1.addEventListener("click", urlClick3_1); //监听按钮点击事件

  var button3_2 = document.createElement("button"); //创建一个按钮
  button3_2.textContent = "自定义新客蓄水"; //按钮内容
  button3_2.style.height = "32px"; //高
  button3_2.style.lineHeight = "32px"; //行高
  button3_2.style.align = "center"; //文本居中
  button3_2.style.color = "white"; //按钮文字颜色
  button3_2.style.background = "#1f4bd9"; //按钮底色
  button3_2.style.border = "0px"; //边框属性
  button3_2.style.borderRadius = "0px"; //按钮四个角弧度
  button3_2.style.marginLeft = "10px";
  button3_2.style.fontSize = "12px";
  button3_2.style.padding = "0 5px";
  button3_2.addEventListener("click", urlClick3_2); //监听按钮点击事件

  var button3_3 = document.createElement("button"); //创建一个按钮
  button3_3.textContent = "自定义新客新增"; //按钮内容
  button3_3.style.height = "32px"; //高
  button3_3.style.lineHeight = "32px"; //行高
  button3_3.style.align = "center"; //文本居中
  button3_3.style.color = "white"; //按钮文字颜色
  button3_3.style.background = "#1f4bd9"; //按钮底色
  button3_3.style.border = "0px"; //边框属性
  button3_3.style.borderRadius = "0px"; //按钮四个角弧度
  button3_3.style.marginLeft = "10px";
  button3_3.style.fontSize = "12px";
  button3_3.style.padding = "0 5px";
  button3_3.addEventListener("click", urlClick3_3); //监听按钮点击事件

  var button3_4 = document.createElement("button"); //创建一个按钮
  button3_4.textContent = "自定义老客转化"; //按钮内容
  button3_4.style.height = "32px"; //高
  button3_4.style.lineHeight = "32px"; //行高
  button3_4.style.align = "center"; //文本居中
  button3_4.style.color = "white"; //按钮文字颜色
  button3_4.style.background = "#1f4bd9"; //按钮底色
  button3_4.style.border = "0px"; //边框属性
  button3_4.style.borderRadius = "0px"; //按钮四个角弧度
  button3_4.style.marginLeft = "10px";
  button3_4.style.fontSize = "12px";
  button3_4.style.padding = "0 5px";
  button3_4.addEventListener("click", urlClick3_4); //监听按钮点击事件

  var button3 = document.createElement("button"); //创建一个按钮
  button3.textContent = "自定义成交概览"; //按钮内容
  button3.style.height = "32px"; //高
  button3.style.lineHeight = "32px"; //行高
  button3.style.align = "center"; //文本居中
  button3.style.color = "white"; //按钮文字颜色
  button3.style.background = "#1f4bd9"; //按钮底色
  button3.style.border = "0px"; //边框属性
  button3.style.borderRadius = "0px"; //按钮四个角弧度
  button3.style.marginLeft = "10px";
  button3.style.fontSize = "12px";
  button3.style.padding = "0 5px";
  button3.addEventListener("click", urlClick3); //监听按钮点击事件

  //品牌
  let brandObj = {
    1672744273970184: "沙宣",
    1713035740313614: "海昌",
    1672744301182989: "潘婷",
    1713573417704462: "SSS",
    1716472555224075: "奶糖派NTP",
    1718566610217988: "南国食品旗舰店",
    1718731435013124: "beautigo",
    1726899190084611: "Kate Somerville海外旗舰店",
    1729546814550019: "让缇丝Jean d'estrées",
    1730713495040007: "科施佳官方旗舰店",
    1732519757634573: "[email protected]",
    1733594070401032: "Sepai",
    1736238360556548: "杭州天萃诗化妆品有限公司",
    1739400043457611: "瑞斐时天津碧捷",
    1744999758913544: "HORMETA欧米达",
    1648829120397320: "Filorga/菲洛嘉",
    1696356811251726: "HADAY/海天",
    1648829117571079: "Nivea/妮维雅",
    1648829118742542: "HomeFacialPro",
    1672744346769421: "Mionsoo/棉上",
    1702602772284429: "AUX/奥克斯",
    1696356998849550: "Bear/小熊",
    1672744362622983: "Baby elephant/红色小象",
    1657598035549197: "OLAY/玉兰油",
    1657598044429383: "BIOHYALUX/润百颜",
    1672744296373261: "a2/至初",
    1672744348379143: "最生活",
    1672744376680456: "MANTING/满婷",
    1672744368166926: "pwu/朴物大美",
    1703060893535310: "UNISKIN/优时颜",
    1679081331241997: "ClorisLand/花皙蔻",
    1710507460462600: "Bb LABORATORIES/苾莱宝",
    1702602792209421: "BRITA/碧然德",
    1696356993701902: "FLYCO/飞科",
    1696356967609421: "PMPM",
    1703060791743559: "RELLET/颐莲",
    1708581408431111: "timage/彩棠",
    1715399324706823: "Dermalogica/德美乐嘉",
    1713035750084616: "肌肉科技",
    1696356873768974: "官栈",
    1713035741929479: "MOODY",
    1713035776524360: "猎聘",
    1703060860826648: "Prof.Ling/凌博士",
    1696356964662285: "LUONENG/罗能",
    1696356991309896: "Ulike",
    1702602808232974: "JINKAIRUI/金凯瑞",
    1713035768359943: "Zhong An Insurance/众安保险",
    1726246245022727: "书亦烧仙草",
    1726246207527048: "可复美",
    1728619073817672: "BeautiGO",
    1728619134274567: "奶糖派",
    1731407696747534: "MURAD",
    1731407714116622: "OVF",
    1737060287995918: "JEAND'ESTREES/让缇丝",
  };
  //message.js
  let loadingMsg = null;

  // //导出文件名
  let fileName = "";

  //默认GET请求
  const getRequestOptions = {
    method: "GET",
    redirect: "follow",
  };

  // const htmlModel = `<div style="display: flex;flex: 1;">
  //         <button id='' style="height:32px;line-height:32px;border: 0;background-color: #1f4bd9;color: #fff; padding: 0 5px;border-radius: 3px;">自定义成交概览</button>
  //     </div>`

  function appendDoc() {
    let like_comment;
    setTimeout(() => {
      like_comment = document.getElementsByClassName(
        "index__container--QOzF4"
      )[0];
      if (like_comment && urlClick3_4) {
        like_comment.append(button1_2); //把按钮加入到 x 的子节点中
        like_comment.append(button1_3); //把按钮加入到 x 的子节点中
        like_comment.append(button1_4); //把按钮加入到 x 的子节点中
        like_comment.append(button);
        // like_comment.append(button2_1); //把按钮加入到 x 的子节点中
        // like_comment.append(button2_2); //把按钮加入到 x 的子节点中
        // like_comment.append(button2_3); //把按钮加入到 x 的子节点中
        // like_comment.append(button2_4); //把按钮加入到 x 的子节点中
        like_comment.append(button3_1); //把按钮加入到 x 的子节点中
        like_comment.append(button3_2); //把按钮加入到 x 的子节点中
        like_comment.append(button3_3); //把按钮加入到 x 的子节点中
        like_comment.append(button3_4); //把按钮加入到 x 的子节点中
        like_comment.append(button3); //把按钮加入到 x 的子节点中
        return;
      }
      appendDoc();
    }, 1000);
  }
  appendDoc();

  //导出(防抖)
  var debounce;

  //导出数据
  let sheetArr = [];
  let sheetArr1 = [];

  //query参数获取
  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;
  }
  //获取brand信息
  let brand = localStorage.getItem("__Garfish__platform__yuntu_user") || "";
  let brands = JSON.parse(brand);

  //封装网络请求(带导出)
  function fetchFun(url, data = {}, requestOptions = getRequestOptions) {
    const urlData = Object.keys(data)
      .map((v) => `${v}=${data[v]}`)
      .join("&");
    return fetch(`${url}?${urlData}`, requestOptions)
      .then((response) => response.text())
      .then((result) => {
        debounce();
        return JSON.parse(result);
      })
      .catch((error) => console.log("error", error));
  }
  function fetchFun2(url, data = {}, requestOptions = getRequestOptions) {
    const urlData = Object.keys(data)
      .map((v) => `${v}=${data[v]}`)
      .join("&");
    return fetch(`${url}?${urlData}`, requestOptions)
      .then((response) => response.text())
      .then((result) => {
        return JSON.parse(result);
      })
      .catch((error) => console.log("error", error));
  }
  //获取行业id
  async function getIndustryId() {
    let industry_id_url = `https://yuntu.oceanengine.com/yuntu_ng/api/v1/get_user_info`;
    let res = await fetchFun2(industry_id_url, {
      aadvid: getQueryVariable("aadvid"),
    });
    let industryValue = document
      .getElementsByClassName("byted-input-size-md")[0]
      .value.split("/")[
      document.getElementsByClassName("byted-input-size-md")[0].value.split("/")
        .length - 1
    ];
    let data = res;
    let a = data?.data?.brandMetadata?.filter((e) => {
      return e?.industry_name == industryValue;
    })[0];
    return a.industry_id;
  }

  //活动类型记录获取
  async function getQueryType(e) {
    let industry_id = await getIndustryId();

    let data = {
      report_name: "",
      page_index: 1,
      page_size: 1,
      query_type: e, //1:进行中活动,2:历史活动 3:自定义
      report_status: 0,
      aadvid: getQueryVariable("aadvid"),
      brand_id: brands.brand_id,
      industry_id,
    };
    let requestData1 = await fetchFun2(
      "https://yuntu.oceanengine.com/yuntu_ng/api/v1/AudienceGtaReportQueryList",
      data
    );
    data.page_size = requestData1.data.total;
    let requestData = await fetchFun2(
      "https://yuntu.oceanengine.com/yuntu_ng/api/v1/AudienceGtaReportQueryList",
      data
    );
    let titleValue =
      document.getElementsByClassName("index__name--yem7b")[0]?.innerText;
    if (titleValue) {
      let arrList = requestData.data.reports.filter(
        (v) => v.report_name === titleValue
      );
      arrList.forEach((v) => {
        getTermTabsItem(
          v.report_name,
          v.impound_begin_date,
          v.impound_end_date,
          v.harvest_begin_date,
          v.harvest_end_date,
          v.report_id,
          arrList.length
        ); //这是活动期转化分析
      });
    } else {
        if (!requestData.data.reports.length){
            Qmsg.error('暂无数据'); 
            loadingMsg.close(); 
            return ;
        } 
      requestData.data.reports.forEach((v) => {
        getTermTabsItem(
          v.report_name,
          v.impound_begin_date,
          v.impound_end_date,
          v.harvest_begin_date,
          v.harvest_end_date,
          v.report_id,
          requestData.data.reports.length
        ); //这是活动期转化分析
      });
    }
  }

  
  //活动类型记录获取
  async function getQueryType1(e) {
    let industry_id = await getIndustryId();

    let data = {
      report_name: "",
      page_index: 1,
      page_size: 1,
      query_type: e, //1:进行中活动,2:历史活动 3:自定义
      report_status: 0,
      aadvid: getQueryVariable("aadvid"),
      brand_id: brands.brand_id,
      industry_id,
    };
    let requestData1 = await fetchFun2(
      "https://yuntu.oceanengine.com/yuntu_ng/api/v1/AudienceGtaReportQueryList",
      data
    );
    data.page_size = requestData1.data.total;
    let requestData = await fetchFun2(
      "https://yuntu.oceanengine.com/yuntu_ng/api/v1/AudienceGtaReportQueryList",
      data
    );
    let titleValue =
      document.getElementsByClassName("index__name--yem7b")[0]?.innerText;
    if (titleValue) {
      let arrList = requestData.data.reports.filter(
        (v) => v.report_name === titleValue
      );
      arrList.forEach((v) => {
        getTabsData(
          v.report_name,
          v.impound_begin_date,
          v.impound_end_date,
          v.harvest_begin_date,
          v.harvest_end_date,
          v.report_id,
          v.report_name,
          arrList.length
        ); //这是上面的取数
      });
    } else {
        if (!requestData.data.reports.length){
            Qmsg.error('暂无数据'); 
            loadingMsg.close(); 
            return ;
        } 
      requestData.data.reports.forEach((v) => {
        getTabsData(
          v.report_name,
          v.impound_begin_date,
          v.impound_end_date,
          v.harvest_begin_date,
          v.harvest_end_date,
          v.report_id,
          v.report_name,
          requestData.data.reports.length
        ); //这是上面的取数
      });
    }
    // requestData.data.reports.forEach(v => {
    //     getTabsData(v.impound_begin_date,v.impound_end_date,v.harvest_begin_date,v.harvest_end_date,v.report_id,v.report_name,requestData.data.reports.length)  //这是上面的取数
    // });
  }

  //活动数据获取
  async function getTabsData(
    sheetName,
    impound_begin_date,
    impound_end_date,
    harvest_begin_date,
    harvest_end_date,
    report_id,
    report_name
  ) {
    let industry_id = await getIndustryId();

    let contrast = {
      sheetName: "sheetName",
      蓄水期开始时间: "impound_begin_date",
      蓄水期结束时间: "impound_end_date",
      活动期开始时间: "harvest_begin_date",
      活动期结束时间: "harvest_end_date",
      新客人数: "old_gmv_deal_cnt",
      新客GMV: "old_gmv_gmv",
      新客客单价: "old_gmv_unit_price",
      老客人数: "old_deal_cnt",
      存量购买人数: "old_a4_cover_num",
      存量购买转化率: "old_a4_rate",
      老客GMV: "old_gmv",
      老客客单价: "old_unit_price",
      活动期成交人数: "cover_num",
      活动期gmv: "gmv",
      活动期客单价: "unit_price",
      gmv目标完成度: "gmv_process",
      最新日期: "latest_date",
      新增A1规模: "new_A1_cover_num",
      新增A1贡献新客人数: "new_A1_deal_cnt",
      新增A1贡献占比: "new_A1_deal_rate",
      新增A1转化率: "new_A1_flow_rate",
      新增A2规模: "new_A2_cover_num",
      新增A2贡献新客人数: "new_A2_deal_cnt",
      新增A2贡献占比: "new_A2_deal_rate",
      新增A2转化率: "new_A2_flow_rate",
      新增A3规模: "new_A3_cover_num",
      新增A3贡献新客人数: "new_A3_deal_cnt",
      新增A3贡献占比: "new_A3_deal_rate",
      新增A3转化率: "new_A3_flow_rate",
      存量A1规模: "old_A1_cover_num",
      存量A1贡献新客人数: "old_A1_deal_cnt",
      存量A1贡献占比: "old_A1_deal_rate",
      存量A1转化率: "old_A1_flow_rate",
      存量A2规模: "old_A2_cover_num",
      存量A2贡献新客人数: "old_A2_deal_cnt",
      存量A2贡献占比: "old_A2_deal_rate",
      存量A2转化率: "old_A2_flow_rate",
      存量A3规模: "old_A3_cover_num",
      存量A3贡献新客人数: "old_A3_deal_cnt",
      存量A3贡献占比: "old_A3_deal_rate",
      存量A3转化率: "old_A3_flow_rate",
      o人群贡献占比: "o_rate",
    };

    let data = {
      industry_id,
      aadvid: getQueryVariable("aadvid"),
      brand_id: brands.brand_id,
      report_id,
    };
    let requestData = await fetchFun(
      "https://yuntu.oceanengine.com/yuntu_ng/api/v1/AudienceGtaHarvestGmvProfile",
      data
    );
    let res = requestData?.data?.profiles || requestData?.data?.profile;

    let new_gmv = {};
    Object.keys(res.new_gmv).forEach((v) => {
      new_gmv[`old_gmv_${v}`] = res.new_gmv[v];
    });
    let new_gmv_new_analysis = {};
    res.new_gmv.new_analysis.map((v, i) => {
      let name = i == 0 ? "old" : i == 1 ? "new" : "o";
      Object.keys(v).forEach((res) => {
        new_gmv_new_analysis[`${name}_${res}`] = v[res];
      });
    });

    let new_gmv_new_analysis_details = {};
    new_gmv_new_analysis.new_details.map((v, i) => {
      let name = i == 0 ? "new_A1" : i == 1 ? "new_A2" : "new_A3";
      Object.keys(v).forEach((res) => {
        new_gmv_new_analysis_details[`${name}_${res}`] = v[res];
      });
    });
    new_gmv_new_analysis.old_details.map((v, i) => {
      let name = i == 0 ? "old_A1" : i == 1 ? "old_A2" : "old_A3";
      Object.keys(v).forEach((res) => {
        new_gmv_new_analysis_details[`${name}_${res}`] = v[res];
      });
    });

    let old_gmv = {};
    Object.keys(res.old_gmv).forEach((v) => {
      old_gmv[`old_${v}`] = res.old_gmv[v];
    });
    let sheetData = {
      sheetName,
      impound_begin_date,
      impound_end_date,
      harvest_begin_date,
      harvest_end_date,
      ...res,
      ...new_gmv,
      ...old_gmv,
      ...new_gmv_new_analysis,
      ...new_gmv_new_analysis_details,
    };
    let datas = {
      sheetName: `(${report_id})`,
      sheetData,
      sheetHeader: Object.keys(contrast),
      sheetFilter: Object.values(contrast),
      columnWidths: [], // 列宽
    };
    sheetArr1.push(sheetData);
  }
  let expDatas = [];
  //活动期转化Item获取
  async function getTermTabsItem(
    report_name,
    impound_begin_date,
    impound_end_date,
    harvest_begin_date,
    harvest_end_date,
    report_id,
    i
  ) {
    let contrast =
      analysis_type === 0
        ? {
            蓄水期开始时间: "impound_begin_date",
            蓄水期结束时间: "impound_end_date",
            触点: "trigger_point_name",
            ID: "trigger_point_id",
            曝光次数: "show_cnt",
            曝光人数: "show_uv",
            曝光人数: "show_uv",
            人均曝光次数: "show_avg",
            流转规模: "to_a3_cnt",
            流转率: "to_a3_rate",
          }
        : {
            活动期开始时间: "harvest_begin_date",
            活动期结束时间: "harvest_end_date",
            触点: "trigger_point_name",
            ID: "trigger_point_id",
            曝光次数: "show_cnt",
            曝光人数: "show_uv",
            曝光人数: "show_uv",
            人均曝光次数: "show_avg",
            存量转化人数: "to_a4_cnt",
            存量转化率: "to_a4_rate",
          };
    let industry_id = await getIndustryId();
    let data = {
      aadvid: getQueryVariable("aadvid"),
      industry_id,
      brand_id: brands.brand_id,
      report_id,
      gta_type: gta_type,
    };
    let requestData = await fetchFun2(
      "https://yuntu.oceanengine.com/yuntu_ng/api/v1/AudienceGtaHarvestAnalysisProfile",
      data
    );
    let res =
      requestData?.data?.profiles || requestData?.data?.profile?.analysis;
    let expExcel2Data = await Promise.all(
      res.map(async (v) => {
        let a = await getTermTabsData(report_id, report_name, v.card);
        return a;
      })
    );
    let arrData = [
      {
        impound_begin_date,
        impound_end_date,
        harvest_begin_date,
        harvest_end_date,
      },
    ];
    expExcel2Data.forEach((v) => {
      arrData.push(...v.sheetData);
    });

    expDatas.push({
      sheetName: `(${report_id})${report_name}`,
      sheetData: arrData.length ? arrData : [{}],
      sheetHeader: Object.keys(contrast),
      sheetFilter: Object.values(contrast),
      columnWidths: [], // 列宽
    });

    if (expDatas.length === i) {
      expExcel2(
        `${brandObj[getQueryVariable("aadvid")]}${fileName}${moment().format(
          "YYYYMMDDHHmmss"
        )}GTA数据`,
        expDatas
      );
    }
  }
  //活动期转化数据获取
  async function getTermTabsData(report_id, report_name, card) {
    let contrast =
      analysis_type === 0
        ? {
            触点: "trigger_point_name",
            ID: "trigger_point_id",
            曝光次数: "show_cnt",
            曝光人数: "show_uv",
            曝光人数: "show_uv",
            人均曝光次数: "show_avg",
            流转规模: "to_a3_cnt",
            流转率: "to_a3_rate",
          }
        : {
            触点: "trigger_point_name",
            ID: "trigger_point_id",
            曝光次数: "show_cnt",
            曝光人数: "show_uv",
            曝光人数: "show_uv",
            人均曝光次数: "show_avg",
            存量转化人数: "to_a4_cnt",
            存量转化率: "to_a4_rate",
          };
    let baseUrl =
      analysis_type === 0
        ? "https://yuntu.oceanengine.com/yuntu_ng/api/v1/AudienceGtaImpoundAnalysis"
        : "https://yuntu.oceanengine.com/yuntu_ng/api/v1/AudienceGtaHarvestAnalysis";
    let industry_id = await getIndustryId();
    let data = {
      aadvid: getQueryVariable("aadvid"),
      industry_id,
      brand_id: brands.brand_id,
      report_id,
      gta_type: gta_type,
      analysis_type: 1,
      card,
    };
    let requestData = await fetchFun2(baseUrl, data);
    let res = requestData.data.ax_analysis.tps;
    let res2 = res.map((v) => {
      return {
        ...v,
        trigger_point_name: `A${card}${v.trigger_point_name}`,
      };
    });
    return {
      sheetName: `${report_name}_A${card}`,
      sheetData: res2,
      sheetHeader: Object.keys(contrast),
      sheetFilter: Object.values(contrast),
      columnWidths: [], // 列宽
    };
  }

  function expExcel() {
    let option = {};
    option.fileName = fileName; //文件名
    option.datas = sheetArr;
    var toExcel = new ExportJsonExcel(option);
    toExcel.saveExcel();
    loadingMsg.close();
  }

  function expExcel1() {
    let contrast = {
      sheetName: "sheetName",
      蓄水期开始时间: "impound_begin_date",
      蓄水期结束时间: "impound_end_date",
      活动期开始时间: "harvest_begin_date",
      活动期结束时间: "harvest_end_date",
      新客人数: "old_gmv_deal_cnt",
      新客GMV: "old_gmv_gmv",
      新客客单价: "old_gmv_unit_price",
      老客人数: "old_deal_cnt",
      存量购买人数: "old_a4_cover_num",
      存量购买转化率: "old_a4_rate",
      老客GMV: "old_gmv",
      老客客单价: "old_unit_price",
      活动期成交人数: "cover_num",
      活动期gmv: "gmv",
      活动期客单价: "unit_price",
      gmv目标完成度: "gmv_process",
      最新日期: "latest_date",
      新增A1规模: "new_A1_cover_num",
      新增A1贡献新客人数: "new_A1_deal_cnt",
      新增A1贡献占比: "new_A1_deal_rate",
      新增A1转化率: "new_A1_flow_rate",
      新增A2规模: "new_A2_cover_num",
      新增A2贡献新客人数: "new_A2_deal_cnt",
      新增A2贡献占比: "new_A2_deal_rate",
      新增A2转化率: "new_A2_flow_rate",
      新增A3规模: "new_A3_cover_num",
      新增A3贡献新客人数: "new_A3_deal_cnt",
      新增A3贡献占比: "new_A3_deal_rate",
      新增A3转化率: "new_A3_flow_rate",
      存量A1规模: "old_A1_cover_num",
      存量A1贡献新客人数: "old_A1_deal_cnt",
      存量A1贡献占比: "old_A1_deal_rate",
      存量A1转化率: "old_A1_flow_rate",
      存量A2规模: "old_A2_cover_num",
      存量A2贡献新客人数: "old_A2_deal_cnt",
      存量A2贡献占比: "old_A2_deal_rate",
      存量A2转化率: "old_A2_flow_rate",
      存量A3规模: "old_A3_cover_num",
      存量A3贡献新客人数: "old_A3_deal_cnt",
      存量A3贡献占比: "old_A3_deal_rate",
      存量A3转化率: "old_A3_flow_rate",
      o人群贡献占比: "o_rate",
    };
    let option = {};
    option.fileName = fileName; //文件名
    option.datas = [
      {
        sheetName: "sheet1",
        sheetData: sheetArr1,
        sheetHeader: Object.keys(contrast),
        sheetFilter: Object.values(contrast),
        columnWidths: [], // 列宽
      },
    ];

    var toExcel = new ExportJsonExcel(option);
    toExcel.saveExcel();
    loadingMsg.close();
    sheetArr1 = []
  }

  function expExcel2(e, data) {
    let option = {};
    option.fileName = e; //文件名
    option.datas = data;
    // setdata_mgdb(data)
    var toExcel = new ExportJsonExcel(option);
    toExcel.saveExcel();
    loadingMsg.close();
    expDatas = [];
  }

  function urlClick1_1() {
    analysis_type = 0;
    fileName = "进行中蓄水";
    debounce = _.debounce(expExcel, 5000);
    loadingMsg = Qmsg.loading("正在导出,请勿重复点击!");
    getQueryType(1);
  }
  function urlClick1_2() {
    analysis_type = 1;
    fileName = "进行中新客蓄水";
    gta_type = 1;
    debounce = _.debounce(expExcel, 5000);
    loadingMsg = Qmsg.loading("正在导出,请勿重复点击!");
    getQueryType(1);
  }
  function urlClick1_3() {
    analysis_type = 1;
    gta_type = 2;
    fileName = "进行中新客新增";
    debounce = _.debounce(expExcel, 5000);
    loadingMsg = Qmsg.loading("正在导出,请勿重复点击!");
    getQueryType(1);
  }
  function urlClick1_4() {
    analysis_type = 1;
    gta_type = 4;
    fileName = "进行中老客转化";
    debounce = _.debounce(expExcel, 5000);
    loadingMsg = Qmsg.loading("正在导出,请勿重复点击!");
    getQueryType(1);
  }

  function urlClick() {
    fileName = `${brandObj[getQueryVariable("aadvid")]}进行中成交概览数据`;
    debounce = _.debounce(expExcel1, 5000);
    loadingMsg = Qmsg.loading("正在导出,请勿重复点击!");
    getQueryType1(1);
  }

  function urlClick3() {
    fileName = `${brandObj[getQueryVariable("aadvid")]}自定义成交概览数据`;
    debounce = _.debounce(expExcel1, 5000);
    loadingMsg = Qmsg.loading("正在导出,请勿重复点击!");
    getQueryType1(3);
  }

  function urlClick2_1() {
    analysis_type = 0;
    fileName = "GTA历史活动蓄水期数据";
    debounce = _.debounce(expExcel, 5000);
    loadingMsg = Qmsg.loading("正在导出,请勿重复点击!");
    getQueryType(2);
  }
  function urlClick2_2() {
    analysis_type = 1;
    gta_type = 1;
    fileName = "GTA历史活动新客蓄水期数据";
    debounce = _.debounce(expExcel, 5000);
    loadingMsg = Qmsg.loading("正在导出,请勿重复点击!");
    getQueryType(2);
  }
  function urlClick2_3() {
    analysis_type = 1;
    gta_type = 2;
    analysis_type = 0;
    fileName = "GTA历史活动新客活动期数据";
    debounce = _.debounce(expExcel, 5000);
    loadingMsg = Qmsg.loading("正在导出,请勿重复点击!");
    getQueryType(2);
  }
  function urlClick2_4() {
    analysis_type = 1;
    gta_type = 4;
    fileName = "GTA历史活动老客转化数据";
    debounce = _.debounce(expExcel, 5000);
    loadingMsg = Qmsg.loading("正在导出,请勿重复点击!");
    getQueryType(2);
  }

  function urlClick3_1() {
    analysis_type = 0;
    fileName = "进行中蓄水";
    debounce = _.debounce(expExcel, 5000);
    loadingMsg = Qmsg.loading("正在导出,请勿重复点击!");
    getQueryType(3);
  }
  function urlClick3_2() {
    analysis_type = 1;
    gta_type = 1;
    fileName = "进行中新客蓄水";
    debounce = _.debounce(expExcel, 5000);
    loadingMsg = Qmsg.loading("正在导出,请勿重复点击!");
    getQueryType(3);
  }
  function urlClick3_3() {
    analysis_type = 1;
    gta_type = 2;
    fileName = "进行中新客新增";
    debounce = _.debounce(expExcel, 5000);
    loadingMsg = Qmsg.loading("正在导出,请勿重复点击!");
    getQueryType(3);
  }
  function urlClick3_4() {
    analysis_type = 1;
    gta_type = 4;
    fileName = "进行中老客转化";
    debounce = _.debounce(expExcel, 5000);
    loadingMsg = Qmsg.loading("正在导出,请勿重复点击!");
    getQueryType(3);
  }
})();