轻流QingFlow应用自动超级字段插件
目前为
// ==UserScript==
// @name 轻流QingFlow超级插件(Tampermonkey版本)
// @namespace http://tampermonkey.net/
// @version 2.0.7
// @description 轻流QingFlow应用自动超级字段插件
// @author Mr.Dragon King
// @license Mr.Dragon King
// @match *://*.qingflow.com/*
// @match *://*.qingflow.com/f/*
// @match *://*.app4355.eapps.dingtalkcloud.com/*
// @icon https://676f-gokuschool-3gl85srrc0c313c4-1304791592.tcb.qcloud.la/cloudbase-cms/upload/2023-04-02/yjlt71g0vrigl6zfc3uqsbp07tqhwbva_.png?sign=53185619797eaa353abb92acd4385140&t=1680367639
// @require https://cdn.bootcss.com/jquery/3.3.1/jquery.js
// @grant GM_log
// @grant GM_xmlhttpRequest
// ==/UserScript==
//消息推送
var MessagePushState = false;//是否开启消息推送
var QW_QrobotHook = "";//企业微信群机器人Hook
//按钮配色方案(皮肤方案)
var ButtonColorOpen = true;//开启在线皮肤方案
var ButtonColorTypeID = "1c84acb963dcc9020006fe99629907d8";//输入皮肤ID
//@Data
var fieldUN = "未同步！！！";//字段数量
var PageOptimizationOpen = false;
//@注册基础元素-字段
var field_Textfield = "/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[1]/div/div/div[1]";//单行文字
var field_Textarea = "/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[1]/div/div/div[2]";//多行文字
var field_Number = "/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[1]/div/div/div[3]";//数字
var field_Link = "/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[1]/div/div/div[4]";//链接
var field_Date = "/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[1]/div/div/div[5]";//日期
var field_StartStopTime = "/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[1]/div/div/div[6]";//起止时间
var field_Phone = "/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[1]/div/div/div[7]";//电话
var field_Mailbox = "/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[1]/div/div/div[8]";//邮箱
var field_AloneChoice = "/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[1]/div/div/div[9]";//单项选择
var field_DropDownChoice = "/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[1]/div/div/div[10]";//下拉选择
var field_MultipleChoice = "/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[1]/div/div/div[11]";//多项选择
var field_ImagesChoice = "/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[1]/div/div/div[12]";//图片选择
var field_FileUpload = "/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[1]/div/div/div[13]";//附件上传
var field_Address = "/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[1]/div/div/div[14]";//地址
//@注册基础元素-字段基础参数
var field_Title = "/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[3]/qf-edit-area/div/qf-function-lock/qf-title-and-hint/div[2]/input";//字段标题
var fieldParameter_Required = "/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[3]/qf-edit-area/div/qf-function-lock/div[1]/label";//必填
var fieldParameter_QRCode = "/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[3]/qf-edit-area/div/qf-function-lock/div[2]/label";//扫码（默认二维码）
var fieldParameter_BarCode = "/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[3]/qf-edit-area/div/qf-function-lock/div[2]/qf-radio-group/label[2]";//扫码-条形码
var fieldParameter_NotDuplicateValue = "/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[3]/qf-edit-area/div/qf-function-lock/div[3]/label"//不允许重复值
//@注册基础元素-字段高级参数
var fieldParameter_AssociateExistingData = "";//关联已有数据
var fieldParameter_LimitWords = "";//限制字数
var fieldParameter_DecimalsAllowed = "";//允许小数
var fieldParameter_DisplayAmount = ""//显示金额
var fieldParameter_TimeFormat = "";//时间格式
var fieldParameter_TimeOverlapNotAllowed = "";//不允许时间重叠
var fieldParameter_FixedTelephone = "";//支持固定电话
var fieldParameter_SMSVerification = "";//短信验证
var fieldParameter_OptionContent = "";//选项内容
//@Excel表头导入字段关键字识别-匹配字段类型并设置字段参数
var fieldData_type_testData = [
{
RegExp: "金额",//关键词【字符串】
fieldData_type: "【数字】",//字段类型【字符串】
fieldData_parameter: [],//字段参数【数组】
},
{
RegExp: "日期",//关键词【字符串】
fieldData_type: "【日期】",//字段类型【字符串】
fieldData_parameter: [],//字段参数【数组】
},
{
RegExp: "单价",//关键词【字符串】
fieldData_type: "【数字】",//字段类型【字符串】
fieldData_parameter: [],//字段参数【数组】
},
{
RegExp: "资本",//关键词【字符串】
fieldData_type: "【数字】",//字段类型【字符串】
fieldData_parameter: [],//字段参数【数组】
},
{
RegExp: "编号",//关键词【字符串】
fieldData_type: "【单行文本】",//字段类型【字符串】
fieldData_parameter: [{ type: "必填" }],//字段参数【数组】
}
]
//打印控制台版本信息
console.log("=====================================================================")
console.log("|| @name QingFlow Dragon King Super Tools")
console.log("|| @version 体验版本0.1")
console.log("|| @description 轻流QingFlow应用自动超级字段插件")
console.log("|| @author Mr.Dragon King")
console.log("|| @license Mr.Dragon King")
console.log("=====================================================================")
console.log("Hello,欢迎使用【QingFlow Dragon King Super Tools】\n轻流QingFlow应用自动超级字段插件🐲\n\n@author Mr.Dragon King \n@version 0.2\n\n使用帮助：\nhttps://www.yuque.com/g/mrscott-prexr/bgia0r/hfwq3pdgm0y7m50i/collaborator/join?token=Je5Br7K9hrV1R8FE# 《QingFlow Dragon King Super Tools使用帮助》\n\n更多信息可联系作者");
//@jquery库
function jquery() {
var myScript = document.createElement('script');
myScript.src = 'https://cdn.bootcss.com/jquery/3.3.1/jquery.js';
document.getElementsByTagName('head')[0].appendChild(myScript);
}
//@XPath方法
function $x(STR_XPATH) {
var xresult = document.evaluate(STR_XPATH, document, null, XPathResult.ANY_TYPE, null);
var xnodes = [];
var xres;
while (xres = xresult.iterateNext()) {
xnodes.push(xres);
}
return xnodes;
}
//@xlsx库
function xlsx() {
var myScript = document.createElement('script');
myScript.src = 'https://cdn.bootcss.com/xlsx/0.11.5/xlsx.core.min.js';
document.getElementsByTagName('head')[0].appendChild(myScript);
}
//@页面启动
(function () {
//加载库
setTimeout(function () {
jquery();
Menu();
xlsx();
ButtonColorScheme()
//alert("Hello,欢迎使用【QingFlow Dragon King Super Tools】\n轻流QingFlow应用自动超级字段插件🐲\n\n@author Mr.Dragon King \n@version 0.2\n\n使用帮助：\nhttps://www.yuque.com/g/mrscott-prexr/bgia0r/hfwq3pdgm0y7m50i/collaborator/join?token=Je5Br7K9hrV1R8FE# 《QingFlow Dragon King Super Tools使用帮助》\n\n更多信息可联系作者");
}, 2000);
})();
$(function () {
$(document).on("click", "#a", function () {
console.log("优化界面完成")
});
});
//=================================功能菜单=================================
//@菜单menu
function Menu() {
setInterval(function () {
if (window.location.href.slice(0, 23) == "https://qingflow.com/f/" && $x("/html/body/qf-root/qf-pages/qf-app-item/qf-creation/qf-header-edit/div").length <= 0) {
var BatchAddFields = "<button id='BatchAddFields' style='height: 36px;margin-left:20px; margin-bottom:20px; margin-top: 20px; border: 1px solid #e6eaf0; border-radius: 4px; border-radius: 4px; color: #494f57;cursor: pointer; background: #F9FAFC;'><img src='https://676f-gokuschool-3gl85srrc0c313c4-1304791592.tcb.qcloud.la/cmsReminderServiceResources/%E6%9C%BA%E5%99%A8%E4%BA%BA.svg?sign=1727c41556cebb66a63fe2dc66ffbdcf&t=1670171513' width='20' height='20'><text style='margin-left:6px;'>批量添加字段</text></button>";//批量添加字段按钮
var Help = "<button id='Help' style='height: 36px;margin-left:20px; margin-bottom:20px; margin-top: 20px; border: 1px solid #e6eaf0; border-radius: 4px; border-radius: 4px; color: #494f57;cursor: pointer; background: #F9FAFC;'><img src='https://676f-gokuschool-3gl85srrc0c313c4-1304791592.tcb.qcloud.la/cmsReminderServiceResources/%E5%BD%A9%E8%89%B2-%E7%81%AF%E6%B3%A1.svg?sign=f387acd6cb69645382da1fe9df239091&t=1670173993' width='20' height='20'><text style='margin-left:6px;'>插件使用帮助</text></button>";//插件使用帮助按钮
var SystemDesignDrawing = "<button id='SystemDesignDrawing' style='height: 36px;margin-left:20px; margin-bottom:20px; margin-top: 20px; border: 1px solid #e6eaf0; border-radius: 4px; border-radius: 4px; color: #494f57;cursor: pointer; background: #F9FAFC;'><img src='https://dss0.bdstatic.com/-0U0bXSm1A5BphGlnYG/tam-ogel/1208056450_-1268512460_88_88.png' width='20' height='20'><text style='margin-left:6px;border-radius:20px'>QingFlow系统设计图</text></button>";//系统设计图
var PageOptimization = "<button id='PageOptimization' style='height: 36px;margin-left:20px; margin-bottom:20px; margin-top: 20px; border: 1px solid #e6eaf0; border-radius: 4px; border-radius: 4px; color: #494f57;cursor: pointer; background: #F9FAFC;'><img src='https://676f-gokuschool-3gl85srrc0c313c4-1304791592.tcb.qcloud.la/cmsReminderServiceResources/%E4%BC%98%E5%8C%962.svg?sign=53206c2ccaab27ae4ee1a624db4574d5&t=1670356354' width='20' height='20'><text style='margin-left:6px;border-radius:20px'>面板界面优化</text></button>";//界面优化
var ExcelImport = "<input type='file' id='excel-file' style='height: 36px;margin-left:20px; margin-bottom:20px; margin-top: 20px; border: 1px solid #e6eaf0; border-radius: 4px; border-radius: 4px; color: #494f57;cursor: pointer; background: #F9FAFC;'>";//Excel导入
$("body > qf-root > qf-pages > qf-app-item > qf-creation > qf-header-edit > header").before("<div style='z-index:999'>" + BatchAddFields + PageOptimization + Help + SystemDesignDrawing + ExcelImport + "</div>");
}
}, 2000);
}
//=================================插件使用帮助=================================
//@插件使用帮助Help
$(function () {
$(document).on("click", "#Help", function () {
window.open("https://exiao.yuque.com/pc5k40/ngqg4r/lv64cgq5rdy4xvtn?singleDoc# 《QingFLow浏览器插件工具介绍》", "_blank");
});
});
//=================================轻流系统设计图=================================
//@轻流系统设计图SystemDesignDrawing
$(function () {
$(document).on("click", "#SystemDesignDrawing", function () {
window.open("https://exiao.yuque.com/pc5k40/ngqg4r/oucgap?singleDoc", "_blank");
});
});
//=================================面板界面优化=================================
//@面板界面优化PageOptimization
$(function () {
$(document).on("click", "#PageOptimization", function () {
PageOptimizationOpen = true;
setTimeout(() => {
$x("/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[3]")[0].style.cssText = "width:750px";
console.log("优化界面完成")
}, 1000)
});
});
//=================================按钮配色优化方案=================================
function ButtonColorScheme() {
if (ButtonColorOpen) {
var a = $x("/html/body/qf-root/qf-pages/qf-new-index/div/div[1]/qf-index-sidebar/div");
if (a.length > 0) {
var attrs = a[0].attributes;
for (var i = 0; i < attrs.length; i++) {
var attrName = attrs[i].name;
var match = attrName.match(/_ngcontent-0-c(\d+)/);
if (match) {
var num = match[1];
console.log(num);
var ButtonColorURL = `https://gokuschool-3gl85srrc0c313c4-1304791592.ap-shanghai.service.tcloudbase.com/gokuschool/v1.0/QF_SkinColour/${ButtonColorTypeID}`
console.log("获取在线皮肤方案")
GM_xmlhttpRequest({
method: "GET",
headers: {
"Content-Type": "application/json"
},
url: ButtonColorURL,
onload: function (res) {
console.log("返回", JSON.parse(res.response));
let styleData = replaceString(JSON.parse(res.response).data.style, num);
$(`<style>${styleData}</style>`).appendTo('head');
}
});
}
}
} else {
console.log("没有找到匹配的元素");
}
}
}
function replaceString(str, replaceStr) {
// 使用正则表达式 / \$\$\$/g 来匹配所有的 "$$$"，并用 replaceStr 替换它们
return str.replace(/\$\$\$/g, replaceStr);
}
//=================================设计图添加=================================
//@批量添加字段BatchAddFields
$(function () {
$(document).on("click", "#BatchAddFields", function () {
BatchAddFields();
});
});
//@触发批量添加字段BatchAddFields
function BatchAddFields() {
var InputValue = prompt("Hello,欢迎使用【QingFlow Dragon King Super Tools】\n轻流QingFlow应用自动超级字段插件🐲\n@author Mr.Dragon King \n@version 0.2\n\n请批量输入字段信息", "【单行文本】字段名称");
if (InputValue != null && InputValue != "") {
AnalysisOfConstructionContent(InputValue)
}
}
//@解析文字算法AnalysisOfConstructionContent
function AnalysisOfConstructionContent(InputData) {
InputData = InputData.replace(/\ +/g, "");
InputData = InputData.replace(/[\r\n]/g, "");
var FieldAnalysisData = [];//解析结果
// 定义识别类型
const DistinguishType = {
FieldType: 1,
FieldTitle: 2,
FieldParameter: 3
}
var fieldData = {//字段数据
type: "",//字段类型
title: "",//字段标题
parameter: [],//字段参数
};
var fieldData_parameter_textData = "";//解析参数字段内容 二次解析内容
var distinguishType = DistinguishType.FieldType;//默认为1，即字段类型
for (let textLengthIndex = 0; InputData.length > textLengthIndex; textLengthIndex++) {
// 校验字段类型添加
if (InputData[textLengthIndex].match(/\【/)) {
// 识别上个字段内容并添加到字段信息中
if (fieldData.type.length != 0) {
FieldAnalysisData.push(fieldData);
// 初始化值
fieldData = {
type: "",
title: "",
parameter: []
};
fieldData_parameter_textData = "";
}
// 转换识别类型为1，即字段类型
distinguishType = DistinguishType.FieldType;
}
// 校验字段类型添加结束，添加字段标题
if (InputData[textLengthIndex].match(/\】/)) {
fieldData.type = `${fieldData.type}${InputData[textLengthIndex]}`;
distinguishType = DistinguishType.FieldTitle;
}
// 校验字段标题添加结束，添加字段参数
if (InputData[textLengthIndex].match(/\(/) || InputData[textLengthIndex].match(/（/)) {
distinguishType = DistinguishType.FieldParameter;
}
if (distinguishType === DistinguishType.FieldType) {
fieldData.type = `${fieldData.type}${InputData[textLengthIndex]}`;
}
if (distinguishType === DistinguishType.FieldTitle) {
if (InputData[textLengthIndex] != "】") {
fieldData.title = `${fieldData.title}${InputData[textLengthIndex]}`;
}
}
if (distinguishType === DistinguishType.FieldParameter) {
if (InputData[textLengthIndex] != "(" && InputData[textLengthIndex] != "（") {
if (InputData[textLengthIndex].match(/\)/) || InputData[textLengthIndex].match(/）/)) {
if (fieldData_parameter_textData.length == 0) {
} else {
let outfieldData_parameter_textData = ResolveFieldParameters(fieldData_parameter_textData);
if (outfieldData_parameter_textData.type == "非注册参数") {
alert(`Hello,欢迎使用【QingFlow Dragon King Super Tools】\n轻流QingFlow应用自动超级字段插件🐲\n\n@author Mr.Dragon King
\n@version 0.2\n\n【非注册参数】\n发现未注册的字段参数，错误参数将无法进行添加到字段中！！！\n\n${fieldData.type}${fieldData.title}(${fieldData_parameter_textData})\n\n如有疑问可仔细查阅插件帮助文档，更多信息可联系作者！`);
fieldData_parameter_textData = "";
} else {
fieldData.parameter.push(outfieldData_parameter_textData);
fieldData_parameter_textData = "";
}
}
} else {
if (InputData[textLengthIndex].match(/;/) || InputData[textLengthIndex].match(/；/)) {
let outfieldData_parameter_textData = ResolveFieldParameters(fieldData_parameter_textData);
if (outfieldData_parameter_textData.type == "非注册参数") {
alert(`Hello,欢迎使用【QingFlow Dragon King Super Tools】\n轻流QingFlow应用自动超级字段插件🐲\n\n@author Mr.Dragon King
\n@version 0.2\n\n【非注册参数】\n发现未注册的字段参数，错误参数将无法进行添加到字段中！！！\n\n${fieldData.type}${fieldData.title}(${fieldData_parameter_textData})\n\n如有疑问可仔细查阅插件帮助文档，更多信息可联系作者！`);
fieldData_parameter_textData = "";
} else {
fieldData.parameter.push(outfieldData_parameter_textData);
fieldData_parameter_textData = "";
}
} else {
fieldData_parameter_textData = `${fieldData_parameter_textData}${InputData[textLengthIndex]}`;
}
}
}
}
if (textLengthIndex == InputData.length - 1) {
console.log("字段校验完成判断是否存在fieldData数据...");
if (fieldData.type.length != 0) {
console.log("存在fieldData数据，添加到FieldAnalysisData");
FieldAnalysisData.push(fieldData);
console.log("添加到FieldAnalysisData完成");
} else {
console.log("不存在fieldData数据,添加到FieldAnalysisData");
}
//初始化值
fieldData = {//字段数据
type: "",//字段类型
title: "",//字段标题
parameter: [],//字段参数
}
fieldData_parameter_textData = "";//解析参数字段内容 二次解析内容
console.log("【QingFlow Dragon King Super Tools】-->字段解析完成:", FieldAnalysisData);
AddField(FieldAnalysisData);
}
}
}
//@解析字段参数算法ResolveFieldParameters
function ResolveFieldParameters(fieldData_parameter_textData) {
fieldData_parameter_textData = fieldData_parameter_textData.replace(/\ +/g, "");
fieldData_parameter_textData = fieldData_parameter_textData.replace(/[\r\n]/g, "");
var fieldData_parameter = {
type: "",//参数类型
};//缓存字段参数
switch (fieldData_parameter_textData) {
case "必填": {
fieldData_parameter.type = "必填";
}
break;
case "二维码": {
fieldData_parameter.type = "二维码";
}
break;
case "条形码": {
fieldData_parameter.type = "条形码";
}
break;
case "不允许重复值": {
fieldData_parameter.type = "不允许重复值";
}
break;
case "金额￥": {
fieldData_parameter.type = "金额￥";
}
break;
case "金额$": {
fieldData_parameter.type = "金额$";
}
case "不允许时间重叠": {
fieldData_parameter.type = "不允许时间重叠";
}
break;
case "年": {
fieldData_parameter.type = "年";
}
break;
case "年月": {
fieldData_parameter.type = "年月";
}
break;
case "年月日": {
fieldData_parameter.type = "年月日";
}
break;
case "年月日时分": {
fieldData_parameter.type = "年月日时分";
}
break;
case "年月日时分秒": {
fieldData_parameter.type = "年月日时分秒";
}
case "固定电话": {
fieldData_parameter.type = "年月日时分秒";
}
break;
case "短信验证": {
fieldData_parameter.type = "年月日时分秒";
}
break;
default: {
if (fieldData_parameter_textData.slice(1, 7) == "关联已有数据") {
fieldData_parameter.type = "关联已有数据";
var DataType = 1
var AssociateExistingData = {
"app": "",
"field": "",
}
for (let index = 8; index < fieldData_parameter_textData.length; index++) {
if (DataType == 1) {
if (fieldData_parameter_textData[index] != "-") {
AssociateExistingData.app = `${AssociateExistingData.app}${fieldData_parameter_textData[index]}`
} else {
DataType = 2;
}
}
if (DataType == 2) {
if (fieldData_parameter_textData[index] != "/" && fieldData_parameter_textData[index] != "-") {
AssociateExistingData.field = `${AssociateExistingData.field}${fieldData_parameter_textData[index]}`
}
}
}
fieldData_parameter["AssociateExistingData"] = AssociateExistingData;
} else {
fieldData_parameter.type = "非注册参数";
}
}
}
return fieldData_parameter;
}
//=================================添加字段算法=================================
var fieldloopIndex = 0;
//@添加字段AddField
async function AddField(FieldAnalysisData) {
switch (FieldAnalysisData[fieldloopIndex].type) {
case "【单行文本】": {
await Add_field_click(field_Textfield);//添加单行文本字段
await InputData(field_Title, FieldAnalysisData[fieldloopIndex].title);//设置字段标题
//设置字段参数
for (let Parameter_index = 0; Parameter_index < FieldAnalysisData[fieldloopIndex].parameter.length; Parameter_index++) {
if (FieldAnalysisData[fieldloopIndex].parameter[Parameter_index].type == "关联已有数据") {
await ToggleDefault();//切换默认内容选择
await Choice_AssociateExistingData();//选择元素2-关联已有数据
await Choice_AssociateExistingData_App();//触发关联已有数据的应用
await Choice_AssociateExistingData_AppInput(FieldAnalysisData[fieldloopIndex].parameter[Parameter_index].AssociateExistingData.app);//关联已有数据的应用名称输入
await Choice_AssociateExistingData_AppChoice(FieldAnalysisData[fieldloopIndex].parameter[Parameter_index].AssociateExistingData.app);//关联已有数据的应用选择
await Choice_AssociateExistingData_Field();//触发关联已有数据的字段
await Choice_AssociateExistingData_FieldInput(FieldAnalysisData[fieldloopIndex].parameter[Parameter_index].AssociateExistingData.field);//关联已有数据的字段名称输入
await Choice_AssociateExistingData_FieldChoice(FieldAnalysisData[fieldloopIndex].parameter[Parameter_index].AssociateExistingData.field);//关联已有数据的字段选择
} else {
await Textfield_Parameter(FieldAnalysisData[fieldloopIndex].parameter[Parameter_index])
}
}
}
break;
case "【多行文本】": {
await Add_field_click(field_Textarea);//添加多行文本字段
await InputData(field_Title, FieldAnalysisData[fieldloopIndex].title);//设置字段标题
for (let Parameter_index = 0; Parameter_index < FieldAnalysisData[fieldloopIndex].parameter.length; Parameter_index++) {
if (FieldAnalysisData[fieldloopIndex].parameter[Parameter_index].type == "关联已有数据") {
await ToggleDefault();//切换默认内容选择
await Choice_AssociateExistingData();//选择元素2-关联已有数据
await Choice_AssociateExistingData_App();//触发关联已有数据的应用
await Choice_AssociateExistingData_AppInput(FieldAnalysisData[fieldloopIndex].parameter[Parameter_index].AssociateExistingData.app);//关联已有数据的应用名称输入
await Choice_AssociateExistingData_AppChoice(FieldAnalysisData[fieldloopIndex].parameter[Parameter_index].AssociateExistingData.app);//关联已有数据的应用选择
await Choice_AssociateExistingData_Field();//触发关联已有数据的字段
await Choice_AssociateExistingData_FieldInput(FieldAnalysisData[fieldloopIndex].parameter[Parameter_index].AssociateExistingData.field);//关联已有数据的字段名称输入
await Choice_AssociateExistingData_FieldChoice(FieldAnalysisData[fieldloopIndex].parameter[Parameter_index].AssociateExistingData.field);//关联已有数据的字段选择
} else {
await Textarea_Parameter(FieldAnalysisData[fieldloopIndex].parameter[Parameter_index])
}
}
}
break;
case "【数字】": {
await Add_field_click(field_Number);//添加数字字段
await InputData(field_Title, FieldAnalysisData[fieldloopIndex].title);//设置字段标题
}
break;
case "【链接】": {
await Add_field_click(field_Link);//添加链接字段
await InputData(field_Title, FieldAnalysisData[fieldloopIndex].title);//设置字段标题
}
break;
case "【日期】": {
await Add_field_click(field_Date);//添加日期字段
await InputData(field_Title, FieldAnalysisData[fieldloopIndex].title);//设置字段标题
}
break;
case "【起止时间】": {
await Add_field_click(field_StartStopTime);//添加起止时间字段
await InputData(field_Title, FieldAnalysisData[fieldloopIndex].title);//设置字段标题
}
break;
case "【电话】": {
await Add_field_click(field_Phone);//添加电话字段
await InputData(field_Title, FieldAnalysisData[fieldloopIndex].title);//设置字段标题
}
break;
case "【邮箱】": {
await Add_field_click(field_Mailbox);//添加邮箱字段
await InputData(field_Title, FieldAnalysisData[fieldloopIndex].title);//设置字段标题
}
break;
case "【单项选择】": {
await Add_field_click(field_AloneChoice);//添加单项选择字段
await InputData(field_Title, FieldAnalysisData[fieldloopIndex].title);//设置字段标题
}
break;
case "【下拉选择】": {
await Add_field_click(field_DropDownChoice);//添加下拉选择字段
await InputData(field_Title, FieldAnalysisData[fieldloopIndex].title);//设置字段标题
}
break;
case "【多项选择】": {
await Add_field_click(field_MultipleChoice);//添加多项选择字段
await InputData(field_Title, FieldAnalysisData[fieldloopIndex].title);//设置字段标题
}
break;
case "【图片选择】": {
await Add_field_click(field_ImagesChoice);//添加图片选择字段
await InputData(field_Title, FieldAnalysisData[fieldloopIndex].title);//设置字段标题
}
break;
case "【附件上传】": {
await Add_field_click(field_FileUpload);//添加附件上传字段
await InputData(field_Title, FieldAnalysisData[fieldloopIndex].title);//设置字段标题
}
break
case "【地址】": {
await Add_field_click(field_Address);//添加地址字段
await InputData(field_Title, FieldAnalysisData[fieldloopIndex].title);//设置字段标题
}
break
default: {
console.log("未注册字段", FieldAnalysisData[fieldloopIndex].type)
}
}
fieldloopIndex = fieldloopIndex + 1;
if (fieldloopIndex < FieldAnalysisData.length) {
AddField(FieldAnalysisData)
} else {
fieldloopIndex = 0;
//字段添加任务完完成进行消息推送
if (MessagePushState == true) {
MessagePush(QW_QrobotHook, "字段添加任务", "当前字段任务已经完成，请注意检查查看！")
}
setTimeout(() => {
alert("【QingFlow Dragon King Super Tools】\n轻流QingFlow应用自动超级字段插件🐲\n字段批量添加任务已经完成😀")
}, 1000)
}
}
//===========================================================================================
//====================================方法事件【添加字段】===================================
//@添加字段方法 Add_field_click(field)
function Add_field_click(field) {
return new Promise(resolve => {
setTimeout(() => {
$x(field)[0].click();
resolve()//成功态
}, 500)
})
}
//===========================================================================================
//=================================方法事件【输入&输入结束】=================================
//@输入内容 InputData
function InputData(element, data) {
return new Promise(resolve => {
setTimeout(() => {
$x(element)[0].value = data;
InputEnd(element);
resolve()//成功态
}, 500)
})
}
//@输入结束 InputEvent
function InputEnd(data) {
return new Promise(resolve => {
$x(data)[0].dispatchEvent(new InputEvent("input"));
resolve()//成功态
})
}
//===========================================================================================
//====================================字段参数===============================================
//=================================字段参数【单行文本参数】==================================
//@添加单行文本参数Textfield_Parameter
async function Textfield_Parameter(parameter) {
return new Promise(resolve => {
setTimeout(() => {
switch (parameter.type) {
case "必填": {
if ($x(fieldParameter_Required).length == 1) {
$x(fieldParameter_Required)[0].click()
}
}
break;
case "二维码": {
if ($x(fieldParameter_QRCode).length == 1) {
$x(fieldParameter_QRCode)[0].click()
}
}
break;
case "条形码": {
if ($x(fieldParameter_QRCode).length == 1) {
$x(fieldParameter_QRCode)[0].click()
setTimeout(() => {
if ($x(fieldParameter_BarCode).length == 1) {
$x(fieldParameter_BarCode)[0].click()
}
}, 200)
}
}
break;
case "不允许重复值": {
if ($x(fieldParameter_NotDuplicateValue).length == 1) {
$x(fieldParameter_NotDuplicateValue)[0].click()
}
}
break;
default: {
console.log("未注册字段参数")
}
}
resolve()//成功态
}, 500)
})
}
//=================================字段参数【多行文本参数】=================================
//@添加多行文本参数Textarea_Parameter
async function Textarea_Parameter(parameter) {
return new Promise(resolve => {
setTimeout(() => {
switch (parameter.type) {
case "必填": {
$x("/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[3]/qf-edit-area/div/qf-function-lock/div[1]/label")[0].click()
}
break;
case "不允许重复值": {
$x("/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[3]/qf-edit-area/div/qf-function-lock/div[3]/label")[0].click()
}
break;
default: {
console.log("未注册字段参数")
}
}
resolve()//成功态
}, 500)
})
}
//=================================特殊参数【关联已有数据】=================================
//@切换默认 ToggleDefault
function ToggleDefault() {
return new Promise(resolve => {
setTimeout(() => {
var openType = true
for (let index = 0; index < 99 && openType == true; index++) {
if ($x(`/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[${index}]/qf-edit-area/div/qf-function-lock/qf-dft-val-edit/div/qf-select/qf-select-top-control/qf-select-item`).length == 1) {
$x(`/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[${index}]/qf-edit-area/div/qf-function-lock/qf-dft-val-edit/div/qf-select/qf-select-top-control/qf-select-item`)[0].click();
openType = false;
}
}
resolve()//成功态
}, 200)
})
}
//@切换关联已有数据 Choice_AssociateExistingData
function Choice_AssociateExistingData() {
return new Promise(resolve => {
setTimeout(() => {
var openType = true
for (let index = 0; index < 99 && openType == true; index++) {
for (let index_1 = 0; index_1 < 99 && openType == true; index_1++) {
if ($x(`/html/body/div[${index}]/div[${index_1}]/div/qf-option-container/div[2]/cdk-virtual-scroll-viewport/div[1]/div/qf-option-item[2]`).length == 1) {
$x(`/html/body/div[${index}]/div[${index_1}]/div/qf-option-container/div[2]/cdk-virtual-scroll-viewport/div[1]/div/qf-option-item[2]`)[0].click();
openType = false;
}
}
}
resolve()//成功态
}, 200)
})
}
//@触发关联已有数据的应用 Choice_AssociateExistingData_App
function Choice_AssociateExistingData_App() {
return new Promise(resolve => {
setTimeout(() => {
var openType = true
for (let index = 0; index < 99 && openType == true; index++) {
if ($x(`/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[${index}]/qf-edit-area/div/qf-function-lock/qf-dft-val-edit/div/qf-function-lock/qf-dft-associate-data/div[1]/qf-select[1]/qf-select-top-control/div[1]/input`).length == 1) {
$x(`/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[${index}]/qf-edit-area/div/qf-function-lock/qf-dft-val-edit/div/qf-function-lock/qf-dft-associate-data/div[1]/qf-select[1]/qf-select-top-control/div[1]/input`)[0].click();
openType = false;
}
}
resolve()//成功态
}, 200)
})
}
//@关联已有数据的应用名称输入 Choice_AssociateExistingData_AppInput
function Choice_AssociateExistingData_AppInput(appName) {
return new Promise(resolve => {
setTimeout(() => {
var openType = true
for (let index = 0; index < 99 && openType == true; index++) {
if ($x(`/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[${index}]/qf-edit-area/div/qf-function-lock/qf-dft-val-edit/div/qf-function-lock/qf-dft-associate-data/div[1]/qf-select[1]/qf-select-top-control/div[1]/input`).length == 1) {
$x(`/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[${index}]/qf-edit-area/div/qf-function-lock/qf-dft-val-edit/div/qf-function-lock/qf-dft-associate-data/div[1]/qf-select[1]/qf-select-top-control/div[1]/input`)[0].value = appName;
InputEnd(`/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[${index}]/qf-edit-area/div/qf-function-lock/qf-dft-val-edit/div/qf-function-lock/qf-dft-associate-data/div[1]/qf-select[1]/qf-select-top-control/div[1]/input`);
openType = false;
}
}
resolve()//成功态
}, 200)
})
}
//@关联已有数据的应用选择 Choice_AssociateExistingData_AppChoice
function Choice_AssociateExistingData_AppChoice(appName) {
return new Promise(resolve => {
setTimeout(() => {
var openType = true
for (let index = 0; index < 99 && openType == true; index++) {
for (let index_1 = 0; index_1 < 99 && openType == true; index_1++) {
if ($x(`/html/body/div[${index}]/div[${index_1}]/div/qf-option-container/div[2]/cdk-virtual-scroll-viewport/div[1]/div/qf-option-item`).length > 0) {
for (let index_2 = 0; index_2 < $x(`/html/body/div[${index}]/div[${index_1}]/div/qf-option-container/div[2]/cdk-virtual-scroll-viewport/div[1]/div/qf-option-item`).length; index_2++) {
let index_3 = index_2 + 1;
if ($x(`/html/body/div[${index}]/div[${index_1}]/div/qf-option-container/div[2]/cdk-virtual-scroll-viewport/div[1]/div/qf-option-item[${index_3}]/div`)[0].innerText == appName) {
$x(`/html/body/div[${index}]/div[${index_1}]/div/qf-option-container/div[2]/cdk-virtual-scroll-viewport/div[1]/div/qf-option-item`)[`${index_2}`].click();
openType = false;
}
}
}
}
}
resolve()//成功态
}, 200)
})
}
//@触发关联已有数据的字段 Choice_AssociateExistingData_Field
function Choice_AssociateExistingData_Field() {
return new Promise(resolve => {
setTimeout(() => {
var openType = true
for (let index = 0; index < 99 && openType == true; index++) {
if ($x(`/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[${index}]/qf-edit-area/div/qf-function-lock/qf-dft-val-edit/div/qf-function-lock/qf-dft-associate-data/div[1]/qf-select[2]/qf-select-top-control/div[1]/input`).length == 1) {
$x(`/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[${index}]/qf-edit-area/div/qf-function-lock/qf-dft-val-edit/div/qf-function-lock/qf-dft-associate-data/div[1]/qf-select[2]/qf-select-top-control/div[1]/input`)[0].click();
openType = false;
}
}
resolve()//成功态
}, 200)
})
}
//@关联已有数据的字段名称输入 Choice_AssociateExistingData_FieldInput
function Choice_AssociateExistingData_FieldInput(fieldName) {
return new Promise(resolve => {
setTimeout(() => {
var openType = true
for (let index = 0; index < 99 && openType == true; index++) {
if ($x(`/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[${index}]/qf-edit-area/div/qf-function-lock/qf-dft-val-edit/div/qf-function-lock/qf-dft-associate-data/div[1]/qf-select[2]/qf-select-top-control/div[1]/input`).length == 1) {
$x(`/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[${index}]/qf-edit-area/div/qf-function-lock/qf-dft-val-edit/div/qf-function-lock/qf-dft-associate-data/div[1]/qf-select[2]/qf-select-top-control/div[1]/input`)[0].value = fieldName;;
InputEnd(`/html/body/qf-root/qf-pages/qf-app-item/qf-creation/div/div[${index}]/qf-edit-area/div/qf-function-lock/qf-dft-val-edit/div/qf-function-lock/qf-dft-associate-data/div[1]/qf-select[2]/qf-select-top-control/div[1]/input`);
openType = false;
}
}
resolve()//成功态
}, 200)
})
}
//@关联已有数据的字段选择Choice_AssociateExistingData_FieldChoice
function Choice_AssociateExistingData_FieldChoice(fieldName) {
return new Promise(resolve => {
setTimeout(() => {
var openType = true
for (let index = 0; index < 99 && openType == true; index++) {
for (let index_1 = 0; index_1 < 99 && openType == true; index_1++) {
if ($x(`/html/body/div[${index}]/div[${index_1}]/div/qf-option-container/div[2]/cdk-virtual-scroll-viewport/div[1]/div/qf-option-item`).length > 0) {
for (let index_2 = 0; index_2 < $x(`/html/body/div[${index}]/div[${index_1}]/div/qf-option-container/div[2]/cdk-virtual-scroll-viewport/div[1]/div/qf-option-item`).length; index_2++) {
let index_3 = index_2 + 1;
if ($x(`/html/body/div[${index}]/div[${index_1}]/div/qf-option-container/div[2]/cdk-virtual-scroll-viewport/div[1]/div/qf-option-item[${index_3}]/div`)[0].innerText == fieldName) {
$x(`/html/body/div[${index}]/div[${index_1}]/div/qf-option-container/div[2]/cdk-virtual-scroll-viewport/div[1]/div/qf-option-item`)[`${index_2}`].click();
openType = false;
}
}
}
}
}
resolve()//成功态
}, 200)
})
}
//=========================================================================================
//=======================================Excel字段导入【Excel】============================
$(function () {
$(document).on("change", "#excel-file", function (e) {
var files = e.target.files;
var fileReader = new FileReader();
fileReader.onload = function (ev) {
try {
var data = ev.target.result
var workbook = XLSX.read(data, {
type: 'binary'
}) // 以二进制流方式读取得到整份excel表格对象
var persons = []; // 存储获取到的数据
} catch (e) {
console.log('文件类型不正确');
return;
}
// 表格的表格范围，可用于判断表头是否数量是否正确
var fromTo = '';
// 遍历每张表读取
for (var sheet in workbook.Sheets) {
if (workbook.Sheets.hasOwnProperty(sheet)) {
fromTo = workbook.Sheets[sheet]['!ref'];
persons = persons.concat(XLSX.utils.sheet_to_json(workbook.Sheets[sheet]));
let FieldAnalysisData = EXCEL_FieldAnalysisData(workbook.Sheets[sheet])
console.log("【QingFlow Dragon King Super Tools】-->Excel字段导入解析完成:", FieldAnalysisData)
AddField(FieldAnalysisData);
break; // 如果只取第一张表，就取消注释这行
}
}
var index = 0;
for (var i in persons) {
var prjid = persons[i].prjid;
var parentid = persons[i].parentid;
var subject = persons[i].subject;
var hrmid = persons[i].hrmid;
var begindate = persons[i].begindate;
begindate = new Date(begindate).toLocaleDateString().replace(/\//g, '-');
var enddate = persons[i].enddate;
enddate = new Date(enddate).toLocaleDateString().replace(/\//g, '-');
var actualbegindate = persons[i].actualbegindate;
actualbegindate = new Date(actualbegindate).toLocaleDateString().replace(/\//g, '-');
var actualenddate = persons[i].actualenddate;
actualenddate = new Date(actualenddate).toLocaleDateString().replace(/\//g, '-');
var stageid = persons[i].stageid;
var finish = persons[i].finish;
}
//在控制台打印出来表格中的数据
};
// 以二进制方式打开文件
fileReader.readAsBinaryString(files[0]);
console.log(files);
});
});
function EXCEL_FieldAnalysisData(sheet) {
const FieldAnalysisData = [];//解析结果
/* sheet['!ref']表示所有单元格的范围，例如从A1到F8则记录为 A1:F8*/
const range = XLSX.utils.decode_range(sheet['!ref'])
let C,
R = range.s.r + 0 /* 从第一行开始 */
/* 按列进行数据遍历 */
for (C = range.s.c; C <= range.e.c; ++C) {
/* 查找第一行中的单元格 */
const cell = sheet[XLSX.utils.encode_cell({ c: C, r: R })]
let title = 'UNKNOWN ' + C // <-- 进行默认值设置
if (cell && cell.t) title = XLSX.utils.format_cell(cell)
//格式化数据格式
var fieldData_type = "【单行文本】";//默认字段类型
var fieldData_parameter = [];//默认字段参数
for (let index = 0; index < fieldData_type_testData.length; index++) {
//let key = RegExp(fieldData_type_testData[index].RegExp)
if (RegExp(fieldData_type_testData[index].RegExp).test(title)) {
fieldData_type = fieldData_type_testData[index].fieldData_type;
fieldData_parameter = fieldData_type_testData[index].fieldData_parameter;
}
}
var fieldData = {//字段数据
type: fieldData_type,//字段类型
title: title,//字段标题
parameter: fieldData_parameter,//字段参数
}
FieldAnalysisData.push(fieldData)
}
return FieldAnalysisData
};
//===========================================================================
//=======================================消息推送============================
function MessagePush(QW_QrobotHook, title, quote_text) {
var data = {
QW_QrobotHook: QW_QrobotHook,
title: title,
quote_text: quote_text
};
GM_xmlhttpRequest({
method: "post",
headers: {
"Content-Type": "application/json"
},
url: "https://api.hiflow.tencent.com/engine/webhook/31/1619964372965879810",
data: JSON.stringify(data),
onload: function (res) {
// code
console.log("返回", res);
}
});
}
//===========================================================================