云图扩展工具
// ==UserScript== // @name 服务商中心_团队管理 // @namespace http://tampermonkey.net/ // @version 1.1 // @description 云图扩展工具 // @author siji-Xian // @match *://yuntu.oceanengine.com/service_provider/team/all_brand_members // @icon https://lf3-static.bytednsdoc.com/obj/eden-cn/prhaeh7pxvhn/yuntu/yuntu-logo_default.svg // @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 https://greasyfork.org/scripts/404478-jsonexportexcel-min/code/JsonExportExcelmin.js?version=811266 // @require https://greasyfork.org/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: "white", background: "linear-gradient(90deg, rgba(0, 239, 253), rgba(64, 166, 254))", borderRadius: "5px", marginLeft: "10px", fontSize: "13px", padding: "0 10px", cursor: "pointer", fontWeight: "500", }); button.addEventListener("click", urlClick); //获取brand信息 let brand = localStorage.getItem("__Garfish__platform__yuntu_user") || ""; let brands = JSON.parse(brand); //获取service_provider_id let service_provider_id = null; (function listen() { var origin = { open: XMLHttpRequest.prototype.open, send: XMLHttpRequest.prototype.send, }; XMLHttpRequest.prototype.open = function (a, b) { this.addEventListener("load", replaceFn); origin.open.apply(this, arguments); }; XMLHttpRequest.prototype.send = function (a, b) { origin.send.apply(this, arguments); }; function replaceFn(obj) { if ( this?._url?.slice(0, 59) == "/service_provider/api/v1/team/query_service_provider_member" ) { service_provider_id = JSON.parse( obj?.target?.response ).data_list[0].service_provider_id; } } })(); //默认GET请求 const getRequestOptions = { method: "GET", redirect: "follow", }; //message.js let loadingMsg = null; function appendDoc() { const likeComment = document.querySelector(".left_YEVa"); if (likeComment) { likeComment.append(button); return; } setTimeout(appendDoc, 1000); } appendDoc(); async function fetchFun(url, data, requestOptions = getRequestOptions) { const params = new URLSearchParams(data).toString(); try { const response = await fetch(`${url}?${params}`, requestOptions); if (response.ok) { const result = await response.json(); return result; } else { throw new Error(`Fetch failed: ${response.status}`); } } catch (error) { loadingMsg.close(); Qmsg.error({ content: `网络请求错误: ${error.message}`, timeout: 5000, }); throw error; } } async function brandsRequest(e) { let bodyData = { service_provider_id: service_provider_id, page: e, fuzzy_word: "" }; let result = await fetchFun( "https://yuntu.oceanengine.com/service_provider/api/v1/team/query_service_provider_member", bodyData ); return result.data_list } function getRecordCount(text) { const recordCount = text.match(/\d+/)[0]; const count = parseInt(recordCount) const pages = Math.ceil(count/10) return pages; } function createNumberList(end) { const result = []; for (let i = 1; i <= end; i++) { result.push(i); } return result; } async function task_list() { loadingMsg = Qmsg.loading("正在导出,请勿重复点击!"); let countText = document.querySelector('.team-pager-record').innerHTML let count = 0 if (countText) { count = getRecordCount(countText); } else { count = 0; } let pages = createNumberList(count) let res = await Promise.all(pages.map(async v=>{ let result = await brandsRequest(v); return result; })) let flatResult = res.flat() expExcel(flatResult) } function expExcel(e) { let res = e.map(v=>{ return {...v, brinds:v.auth_brand_list.map(v=>v.brand_name)} }) let contrast = { 成员姓名: "user_name", 邮箱: "email", 手机号: "phone", 服务品牌: "brinds" }; let datas = { sheetName: '', sheetData: res, sheetHeader: Object.keys(contrast), sheetFilter: Object.values(contrast), columnWidths: [], // 列宽 }; let option = {}; option.fileName = "团队管理-所有成员"; //文件名 option.datas = [datas]; var toExcel = new ExportJsonExcel(option); toExcel.saveExcel(); loadingMsg.close(); } function urlClick() { task_list(); } })();