通过创建excel批量上传表单
目前為
// ==UserScript==
// @name Firebase批量创建表单
// @namespace http://tampermonkey.net/
// @version 6.2
// @description 通过创建excel批量上传表单
// @author zjl
// @match https://console.firebase.google.com/project/*
// @icon https://www.gstatic.com/mobilesdk/160503_mobilesdk/logo/favicon.ic
// @require https://cdn.bootcdn.net/ajax/libs/jquery/3.6.4/jquery.js
// @require https://cdn.bootcdn.net/ajax/libs/xlsx/0.18.5/xlsx.core.min.js
// @grant GM_openInTab
// @grant GM_setValue
// @grant GM_getValue
// @grant unsafeWindow
// @license MIT
// ==/UserScript==
(async function() {
'use strict';
// Your code here...
var goLink
var result
var count=0
var rate=500
var url=window.location.href;
var index=0
var len=0
var diy
var user_choice
if (/index=(\d+)/.exec(url)){
index = /index=(\d+)/.exec(url)[1]
}
let results = await GM.getValue("excel", []);
len=results.length
result=results[index]
goLink=await GM.getValue("goLink", '');
diy=await GM.getValue("diy", []);
user_choice=await GM.getValue("user_choice", []);
if (
RegExp(
/https:\/\/console\.firebase\.google\.com\/project\/[\w-]+\/messaging/
).test(url)
) {
checkObj('.filter-chips-row', function (obj) {
const regex = /\/project\/(.+?)\//
const match = url.match(regex)
const projectId = match[1]
goLink = `https://console.firebase.google.com/project/${projectId}/notification/compose`
addExcel()
})
} else if (
RegExp(
/https:\/\/console\.firebase\.google\.com\/project\/[\w-]+\/notification\/compose/
).test(url)
) {
if (/campaignId=(\d+)/.exec(url)){
return
}else{
//执行函数
checkObj('.banner-content', function (obj) {
Do()
})
}
}
function sleep(ms) {
return new Promise(resolve => setTimeout(resolve, ms));
}
async function checkObj(selection, fn) {
while (true) {
// 每隔一段时间刷新页面
await sleep(1500);
let obj = $(selection).eq(0) //声明要查询的对象
if (obj&&obj.length>0) {
$('.mat-drawer-backdrop.mat-drawer-shown.ng-star-inserted').click()
//判断对象是否存在，存在则开始设置值
fn(obj)
break;
}
}
}
function padding(fn) {
count+=1
var timer = setTimeout(() => {
fn()
clearTimeout(timer)
}, count*rate)
}
function formatDate(serial, format) {
var utc_days = Math.floor(serial - 25569);
var utc_value = utc_days * 86400;
var date_info = new Date(utc_value * 1000);
var fractional_day = serial - Math.floor(serial) + 0.0000001;
var total_seconds = Math.floor(86400 * fractional_day);
var seconds = total_seconds % 60;
total_seconds -= seconds;
var hours = Math.floor(total_seconds / (60 * 60));
var minutes = Math.floor(total_seconds / 60) % 60;
var daytime = new Date(date_info.getFullYear(), date_info.getMonth(), date_info.getDate(), hours, minutes, seconds);
var returnDate = date_info.getFullYear();
returnDate += format + (date_info.getMonth() < 9 ? '0' + (date_info.getMonth() + 1) : (date_info.getMonth() + 1));
returnDate += format + date_info.getDate()
returnDate += " " + (daytime.getHours() < 10 ? '0' + daytime.getHours() : daytime.getHours());
returnDate += ":" + (daytime.getMinutes() < 10 ? '0' + daytime.getMinutes() : daytime.getMinutes());
return returnDate;
}
function step1() {
return new Promise(resolve => {
padding(() => {
$('.message-title').focus()
document.execCommand('inserttext', false, result['推送标题'])
})
padding(() => {
$('.message-text').focus()
document.execCommand('inserttext', false, result['推送文案'])
})
padding(() => {
if (result['推送资源名称']){
$('.message-label').focus()
document.execCommand('inserttext', false, result['推送资源名称'])
}
})
padding(()=>{
$('.notification-image-input').focus()
document.execCommand('inserttext', false, result['图片链接'])
})
padding(() => {
$('.mat-focus-indicator .mat-stepper-next').eq(0).click()
})
resolve()
});
}
function step2() {
return new Promise(resolve => {
checkObj('.mat-select-trigger', () => {
padding(() => {
$('.mat-select-trigger').eq(0).click()
})
padding(() => {
$(`.mat-option-text:contains(${result["定向应用"]})`).eq(0).click()
})
let value_index=1
let input_index=0
for(let i=0;i<user_choice.length;i+=3){
let index=i/3
if (result[user_choice[i]]){
let data1=result[user_choice[i]]
let data2=result[user_choice[i+1]]
let data3=result[user_choice[i+2]]
padding(() => {
$('.mat-focus-indicator.and-button.mat-button').eq(index).click()
})
padding(()=>{
$('.mat-focus-indicator.mat-menu-trigger.trigger.mat-button.mat-button-base')
.eq(index+1)
.click()
$(`option-title:contains(${data1})`).click()
})
padding(() => {
$('.mat-select-value').eq(value_index).click()
value_index+=1
$(`.mat-option-text:contains(${data2})`).click()
})
if (data1=="First open"||data1=="Last app engagement"){
if (data2=="Between"){
padding(()=>{
let inputElement=data3.split('/')
$('.ng-star-inserted input.compact').eq(input_index).focus()
document.execCommand('inserttext', false,inputElement[0])
$('.ng-star-inserted input.compact').eq(input_index+1).focus()
document.execCommand('inserttext', false,inputElement[1])
input_index+=2
})
}else{
padding(()=>{
$('.ng-star-inserted input.compact').eq(input_index).focus()
document.execCommand('inserttext', false,data3)
input_index+=1
})
}
}else{
padding(()=>{
$('.mat-select-value').eq(value_index).click()
value_index+=1
})
padding(()=>{
let clickElement=data3.split('/')
for(let i=0;i<clickElement.length;i++){
if(clickElement[i]=="Select all"){
$('.mat-checkbox-layout').eq(0).click()
}else{
$(`enumerated-option:contains(${clickElement[i]})`).click()
}
}
})
}
padding(()=>{
$('.cdk-overlay-backdrop-showing').eq(0).click()
})
}
}
padding(() => {
$('.mat-focus-indicator.mat-stepper-next').eq(1).click()
})
padding(()=>{
$('.cdk-overlay-backdrop-showing').eq(0).click()
})
resolve()
})
});
}
function step3() {
var monthEnglish=new Map()
monthEnglish.set("01","JAN")
monthEnglish.set("02","FEB")
monthEnglish.set("03","MAR")
monthEnglish.set("04","APR")
monthEnglish.set("05","MAY")
monthEnglish.set("06","JUN")
monthEnglish.set("07","JUL")
monthEnglish.set("08","AUG")
monthEnglish.set("09","SEP")
monthEnglish.set("10","OCT")
monthEnglish.set("11","NOV")
monthEnglish.set("12","DEC")
let PushDateTime=formatDate((result['推送日期']-0)+( result['推送时间']-0),'/')
let PushDate=PushDateTime.split(" ")[0]
let PushTime=PushDateTime.split(" ")[1]
var nowDay=PushDate.split('/')[2]
var nowMonth=PushDate.split('/')[1]
var nowMonthFlag= monthEnglish.get(`${nowMonth+''}`)
return new Promise(resolve => {
padding(() => {
$('.mat-menu-trigger.can-recur').click()
})
padding(() => {
$('.mat-focus-indicator.mat-menu-trigger.mat-menu-item').click()
})
padding(()=>{
for(let i=1;i<=12;i++){
if ($(`tr:contains(${nowMonthFlag})`).length>0){
break
}else{
$('.mat-calendar-next-button').eq(0).click()
}
}
})
padding(() => {
$(`.mat-calendar-body-cell-content.mat-focus-indicator:contains(${nowDay})`).eq(0).click()
})
padding(()=>{
$('.c5e-input-container.dense.ng-star-inserted').eq(0).children(':first-child').attr('type','text')
$('.c5e-input-container.dense.ng-star-inserted').eq(0).children(':first-child').val('')
$('.c5e-input-container.dense.ng-star-inserted').eq(0).children(':first-child').focus()
document.execCommand('inserttext', false, PushTime+'')
$('.mat-focus-indicator.mat-stepper-next').eq(2).click()
})
resolve()
});
}
function step4(){
return new Promise(resolve=>{
padding(()=>{
$('.c5e-input-element.trigger-btn').eq(0).click()
})
padding(()=>{
$(`button:contains(${result['转化事件']})`).eq(0).click()
$('.mat-focus-indicator.mat-stepper-next').eq(3).click()
})
resolve()
})
}
function step5() {
return new Promise(resolve=>{
padding(()=>{
let index=0
for(let i=0;i<diy.length;i+=2){
if (result[diy[i+1]]||result[diy[i+1]]=='0'){
console.log(typeof index)
$('.cdk-overlay-backdrop').remove()
$('.cdk-overlay-connected-position-bounding-box').remove()
document.querySelectorAll('.c5e-input-container.gcm-high-density-container.key')[index].childNodes[0].focus()
document.execCommand('inserttext', false, result[diy[i]])
document.querySelectorAll('.c5e-input-container.gcm-high-density-container.value')[index].childNodes[0].focus()
document.execCommand('inserttext', false, result[diy[i+1]])
index+=1
}
}
})
padding(()=>{
$('.cdk-overlay-backdrop').remove()
$('.cdk-overlay-connected-position-bounding-box').remove()
if ( $('label:contains(Apple badge)').length>0 ){
if (result['Apple Badge']){
$('.cdk-overlay-backdrop').remove()
$('.cdk-overlay-connected-position-bounding-box').remove()
$('label:contains(Apple badge)').next('mat-select').find('.mat-select-min-line').click()
$(`.mat-option:contains(${result['Apple Badge']})`).eq(0).click()
if (result['Apple Badge']==='Enabled'){
$('.cdk-overlay-backdrop').remove()
$('.cdk-overlay-connected-position-bounding-box').remove()
document.querySelectorAll('.badge-count-input')[0].value=''
document.querySelectorAll('.badge-count-input')[0].focus()
document.execCommand('inserttext', false, result['Badge Count'])
}
}
}
$('.cdk-overlay-backdrop').remove()
$('.cdk-overlay-connected-position-bounding-box').remove()
$('label:contains(Sound)').next('mat-select').find('.mat-select-min-line').click()
$(`.mat-option:contains(${result['声音']})`).eq(0).click()
$('.mat-vertical-stepper-content').eq(4).click()
$('.cdk-overlay-backdrop').remove()
$('.cdk-overlay-connected-position-bounding-box').remove()
let expires_time=result['过期时间1']
$('label:contains(Expires)').next('div').find('.mat-select-trigger').eq(0).click()
$('.mat-option-text').filter(`span:contains(${expires_time})`).eq(0).click()
$('.mat-vertical-stepper-content').eq(4).click()
$('.cdk-overlay-backdrop').remove()
$('.cdk-overlay-connected-position-bounding-box').remove()
let expires_day=result['过期时间2']
$('label:contains(Expires)').next('div').find('.mat-select-trigger').eq(0).click()
$('.mat-option-text').filter(`span:contains(${expires_day})`).eq(0).click()
$('.mat-vertical-stepper-content').eq(4).click()
resolve()
})
})
}
function step6(){
return new Promise(resolve=>{
$('button:contains(Review)').eq(0).click()
checkObj('button:contains(Publish)',function(){
$('button:contains(Publish)').eq(0).click()
if (parseInt(index)<len-1){
openTab(parseInt(index)+1)
}
resolve()
})
})
}
async function Do() {
await step1()
await step2()
await step3()
await step4()
await step5()
await step6()
}
function getHeaderRow(sheet) {
const headers = []
const range = XLSX.utils.decode_range(sheet['!ref'])
let C
const R = range.s.r
/* start in the first row */
for (C = range.s.c; C <= range.e.c; ++C) {
/* walk every column in the range */
const cell = sheet[XLSX.utils.encode_cell({ c: C, r: R })]
/* find the cell in the first row */
// let hdr = 'UNKNOWN ' + C // <-- replace with your desired default
if (cell && cell.t) {
let hdr = XLSX.utils.format_cell(cell)
headers.push(hdr)
}
}
return headers
}
function openTab(index) {
GM_openInTab(`${goLink}?index=${index}`,{active:true})
}
function getExcelData(rawFile) {
const reader = new FileReader()
reader.onload = async (e) => {
const data = e.target.result
const workbook = XLSX.read(data, { type: 'array' })
const firstSheetName = workbook.SheetNames[0]
const worksheet = workbook.Sheets[firstSheetName]
const header = getHeaderRow(worksheet)
const results = XLSX.utils.sheet_to_json(worksheet)
console.log(header, results)
let diy=header.filter(e=>{
return e.indexOf('自定义')!=-1
})
let user_choice=header.filter(e=>{
return e.indexOf('用户选择')!=-1
})
await GM.setValue("excel",results);
await GM.setValue("goLink",goLink);
await GM.setValue("diy",diy);
await GM.setValue("user_choice",user_choice);
if (results.length>0){
openTab(0)
}
}
reader.readAsArrayBuffer(rawFile)
}
function addExcel() {
if ($('#upExcel')) {
$('#upExcel').remove()
$('#upExcelLabel').remove()
}
var button = document.createElement('input')
button.setAttribute('type', 'file')
button.setAttribute('id', 'upExcel')
button.style.display = 'none'
button.textContent = '上传excel'
button.addEventListener('change', (event) => {
getExcelData(event.target.files[0])
})
var label = document.createElement('label')
label.setAttribute('for', 'upExcel')
label.setAttribute('id', 'upExcelLabel')
var conten = document.createElement('div')
conten.setAttribute('id', 'uploadContent')
conten.textContent = '上传Excel'
label.append(conten)
$('.ng-star-inserted').eq(0).prepend(label)
$('.ng-star-inserted').eq(0).prepend(button)
$('#uploadContent').css({
width: '80px',
'background-color': 'orange',
'text-align': 'center',
'font-size': '12px',
'border-radius': '5px',
padding: '5px 10px'
})
}
})();
QingJ © 2025
镜像随时可能失效，请加Q群300939539或关注我们的公众号极客氢云获取最新地址