Provide a few tweaks including a role compliance report to the Scouts Website
// ==UserScript== // @name Scouts Membership System (UK) Tweaks // @description Provide a few tweaks including a role compliance report to the Scouts Website // @namespace http://tampermonkey.net/ // @version 100000042 // @author David Breakwell // @match https://membership.scouts.org.uk/* // @icon https://www.google.com/s2/favicons?sz=64&domain=scouts.org.uk // @grant GM_xmlhttpRequest // @grant GM_getResourceURL // @grant GM_getResourceText // @grant GM_addStyle // @grant GM_notification // @grant GM_log // @grant GM_setValue // @grant GM_getValue // @grant GM_getResourceURL // @run-at document-idle // @require http://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js // @require http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/jquery-ui.min.js // @require https://cdnjs.cloudflare.com/ajax/libs/gojs/3.0.17/go.js // @require https://unpkg.com/[email protected]/dist/leaflet.js // @require https://cdn.jsdelivr.net/npm/[email protected]/dist/xlsx.min.js // @require https://unpkg.com/[email protected]/dist/js/tabulator.min.js // @require https://cdn.jsdelivr.net/npm/[email protected]/build/global/luxon.min.js // @resource jqUI_CSS http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/themes/base/jquery-ui.css // @resource leaf https://unpkg.com/[email protected]/dist/leaflet.css // @resource IconSet1 http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/themes/base/images/ui-icons_222222_256x240.png // @resource IconSet2 http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/themes/base/images/ui-icons_454545_256x240.png // @resource LeafletPin https://unpkg.com/[email protected]/dist/images/marker-icon.png // @resource LeafletShadow https://unpkg.com/[email protected]/dist/images/marker-shadow.png // @resource tabulator https://unpkg.com/[email protected]/dist/css/tabulator.min.css // @connect tsa-memportal-prod-fun01.azurewebsites.net // @connect tsauksprodasa001.blob.core.windows.net // @connect tsauksprodasa001.table.core.windows.net // @connect api.postcodes.io // @connect learn.scouts.org.uk // @license MIT // ==/UserScript== // https://cdn.sheetjs.com/xlsx-0.20.3/package/dist/xlsx.full.min.js var code_version = "100000042"; var mem = [{}]; var mems= []; var mapmems= []; var memsunique = []; var roles = []; var role_detail = []; var dbs_detail = []; var mem_learning= []; var learn = []; var mem_lcount; var role_max_count; var respond = false; var end = false; var un=""; var debug = false; var keepalive = null; var orgcounter = 0; var myDiagram; var postcode_regex = new RegExp("[A-Za-z]{1,2}[0-9Rr][0-9A-Za-z]? ?[0-9][ABD-HJLNP-UW-Zabd-hjlnp-uw-z]{2}") var mappin = {}; var map = {}; var mapunits = []; var postcodes = []; var defcolors=['#fafad2','#ffe4b5','#ffa07a','#ff6347']; var defcolorsT=['#000000','#000000','#000000','#000000']; var colors=['#fafad2','#ffe4b5','#ffa07a','#ff6347']; var colorsT=['#000000','#000000','#000000','#000000']; var colormeanings = ["90 Days","60 Days","30 Days","Expired"]; var daylimits = [90,60,30,0,-9999999]; var tabletabulator var added_css = false; var added_default = false; var roles_count = 0; (function() { 'use strict'; function do_move() { console.log(document.getElementById("member-nav").value); } function dopage() { // if(window.location.href.indexOf("subunitsau")!=-1) { setTimeout(function() { console.log("After Wait"); console.log(window.location.href ); if ((window.location.href == "https://membership.scouts.org.uk/")||(window.location.href == "https://membership.scouts.org.uk/#/")) { console.log("Homepage"); if (document.getElementById("member-nav-list")==null){ var gotolist="<datalist id='member-nav-list'><option value='Add a New Member'></option>"; gotolist+="<option value='My Units'></option>"; gotolist+="</datalist>"; gotolist ='<label for="member-nav" style="font-size: 1.5em;font-weight: 600">What do you want to do? </label>' + gotolist; gotolist += '<input style="width: 50%; font-size: 1.5em "list="member-nav-list" id="member-nav" name="member-nav-choice" onchange="do_move"/>'; if( document.getElementById("title")!=null) { if (document.getElementById("quick_nav")==null) { gotolist = '<div id="quick_nav">'+gotolist+'</div>'; // document.getElementById("title").outerHTML += (gotolist); } else { // document.getElementById("quick_nav").innerHTML = (gotolist); } } // title } // already dispalyed } if (window.location.href.indexOf("subunitsau") != -1) { //document.body.appendChild(button); var htmlToInsert; htmlToInsert = '<span id="DavesnewText"><p>There are <a href="'; htmlToInsert += window.location.href.substring(0, window.location.href.indexOf("subunitsau")); htmlToInsert += 'teamsau"><span id="teamcounter"></span></a> Teams at this level</p><span><span id="DavesList"><span>'; //console.log(document.getElementById("header-main-title-all-units-grid")); GM_xmlhttpRequest({ method: "POST", url: "https://tsa-memportal-prod-fun01.azurewebsites.net/api/UnitTeamsAndRolesListingAsync", data: '{"unitId" : "' + window.location.href.substring(window.location.href.indexOf("allunits/") + 9, window.location.href.indexOf("subunitsau") - 1) + '", "type" : "team"}', headers: { "Content-Type": "application/json", "Authorization": "Bearer " + JSON.parse(localStorage.getItem("authInfo")).idToken, "Accept": "application/json, text/plain, */*" }, onload: function(response) { // console.log("gut response"); // console.log(response.responseText); // console.log(JSON.parse(response.responseText)); if (JSON.parse(response.responseText).teams.length > 1) { document.getElementById("teamcounter").innerHTML = JSON.parse(response.responseText).teams.length; } else { htmlToInsert = '<p>There is <a href="'; htmlToInsert += window.location.href.substring(0, window.location.href.indexOf("subunitsau")); htmlToInsert += 'teamsau/' + JSON.parse(response.responseText).teams[0].teamId + "/teamdashboardaut"; htmlToInsert += '"><span id="teamcounter">1</span></a> Team at this level</p>'; document.getElementById("DavesnewText").innerHTML = (htmlToInsert); } var elements = document.querySelectorAll('[id^=grid-unit]'); var elements2 = document.querySelectorAll('[id^=grid-parentUnit]'); for (var loop = 0; loop < elements.length; loop++) { var htmlToInsert2 = '<a href="'; htmlToInsert2 += elements[loop].href.substring(0, elements[loop].href.indexOf("subunitsau")); htmlToInsert2 += 'teamsau"> <strong style=" display: inline-block; width: 40px; height: 40px;line-height: 40px;text-align: center; background-color: #007bff; cursor:pointer; color: white; border-color: #007bff; border-radius: 50%;font-size: 20px;font-weight: bold;">T</strong></a>'; elements2[loop].outerHTML += htmlToInsert2; } } }); // End of request document.getElementById("header-main-title-all-units-grid").innerHTML += (htmlToInsert); var button = document.createElement("Button"); button.innerHTML = "Add a Member"; button.onclick = () => { window.open(window.location.href.substring(0, window.location.href.indexOf("subunitsau")) + "unitdetailsau/addmemberau", "_self"); }; button.style = "background: rgb(0, 97, 205);font-weight: 700;font-family: 'Nunito Sans';font-size: 20px;line-height: 1.5;color: white;min-height: 46px;max-width: 215px; cursor:pointer;vertical-align: middle;padding: 8px 24px;border-color: #007bff;"; document.getElementById("header-main-title-all-units-grid").appendChild(button); } }) if (window.location.href.indexOf("teamdashboardaut") != -1) { setTimeout(function() { var button = document.createElement("Button"); button.innerHTML = "Add a Member"; button.onclick = () => { window.open(window.location.href.substring(0, window.location.href.indexOf("teamsau")) + "unitdetailsau/addmemberau", "_self"); }; button.style = "background: rgb(0, 97, 205);font-weight: 700;font-family: 'Nunito Sans';font-size: 20px;line-height: 1.5;color: white;min-height: 46px;max-width: 215px;vertical-align: middle;padding: 8px 24px;border: none; cursor:pointer;"; document.getElementById("header-button-wrapper-action-list").appendChild(button); }, 1000); } } // dopage function addButton(text, onclick, cssObj,pos) { if (pos=="T") { cssObj = cssObj || {position: 'absolute', top: '63px', left:'50%', 'z-index': 3} } if (pos=="B") { cssObj = cssObj || {position: 'absolute', top: '30px', left:'50%', 'z-index': 3} } if (pos=="C") { cssObj = cssObj || {position: 'absolute', top: '30px', left:'40%', 'z-index': 3} } if (pos=="D") { cssObj = cssObj || {position: 'absolute', top: '63px', left:'40%', 'z-index': 3} } let button = document.createElement('button'), btnStyle = button.style document.body.appendChild(button) button.innerHTML = text button.onclick = onclick btnStyle.position = 'absolute' Object.keys(cssObj).forEach(key => btnStyle[key] = cssObj[key]) return button } function get_data(count){ var datapass; var max = 50; un = document.getElementById("gmunitname").value; document.getElementById("gmUnit").innerHTML = un; $("#gmState")[0].innerText = "Requesting Members for "+un+" ("+count+")"+"Total read "+mems.length; if (debug) {GM_log("get_data :Version "+code_version);} if (debug) {GM_log("get_data : Collection for Report");} if (debug) {GM_log("Unit Request for "+un+" Count "+count);} if (debug) { GM_log("Unit Request for "+un+" :"+ JSON.parse(localStorage.getItem("authInfo")).idToken.substring(1,50)); var tokexpDate = new Date( JSON.parse(localStorage.getItem("authInfo")).account.idTokenClaims.exp *1000); GM_log("Token expires :"+ tokexpDate.toGMTString()); } // document.getElementById("gmState").innerText = "Hello World"; datapass = '{"pagesize":'+max+',"nexttoken":'+count+',"filter":{"global":"","globaland":false,"fieldand":true,"filterfields":[{"field":"unitName","value":"'+un+'"}]},"isSuspended":false}'; // console.log(datapass); if (debug) {GM_log("Counter for get_data "+count);} GM_xmlhttpRequest({ method: "POST", context: count, url: "https://tsa-memportal-prod-fun01.azurewebsites.net/api/MemberListingAsync", data: datapass, // synchronous: true, headers: { "Content-Type": "application/json", "Authorization": "Bearer " + JSON.parse(localStorage.getItem("authInfo")).idToken, "Accept": "application/json, text/plain, */*" }, onload: function(response) { // console.log(response);console.log(count); if (debug) {GM_log("Counter Recieved "+response.context)} // console.log(JSON.parse(response.responseText).data[1]); var mem = null; try { mem=JSON.parse(response.responseText).data} catch {console.log("JSON Error "+response.responseText);} // mem =(JSON.parse(response.responseText).data); if (mem!=null) { if (debug) { for (var debugloop=0;debugloop<mem.length;debugloop++){ GM_log("Member "+mem[debugloop].firstname+" "+mem[debugloop].unitName+mem[debugloop].Role); } } } if ((mem==null)&&(debug)) { GM_log("GetData: We got an error collecting data for mems page"+response.context); } if (mem!=null) { mems = mems.concat(mem); } if (debug) {GM_log("mems now has length "+mems.length);} // console.log(mem.length); // console.log(JSON.parse(response.responseText).data); if (response.status!=200) {GM_log("HTTP error "+response.status); GM_log(JSON.stringify(response));} // console.log(mem); // console.log(JSON.parse(response.responseText).data.length); $("#gmState")[0].innerText = "Reading Members for "+un+" ("+response.context+") "+"Total read "+mems.length+"("+mem.length+")"; if ( JSON.parse(response.responseText).data.length ==50) {get_data(count+1); } else {roles_count = 0;report2()};}, onerror: function(response) { GM_log("ON Error");GM_log(JSON.stringify(response))}, onabort: function(response) { GM_log("ON Abort");GM_log(JSON.stringify(response))} }); } function clear_mems(){ //if (1!=1){ if (debug) {GM_log("Clear Mems entry: mems now has length "+mems.length);} if(document.getElementById("gmmissing").checked) { var onlymems = []; var onlymemsu = []; var act = ['managerDisclosureCheck','dataProtectionTrainingComplete','signDeclaration','updateMemberProfile','referenceRequest','safeguardconfidentialEnquiryCheck','managerWelcomeConversation','coreLearning','managerTrusteeCheck']; for (var i = 0; i < role_detail.length; i++) { var displine=true; if (document.getElementById("gmmissing").checked) { var any_missing = false; for (var j = 0; j < act.length; j++) { if (role_detail[i].actions.find((element)=>element.typeid==act[j])) { var value = role_detail[i].actions.find((element)=>element.typeid==act[j]).status; if ((value!="Satisfactory")&&(value!="Completed")&&(value!="Held - Satisfactory")){ any_missing=true;} } } if (any_missing==false) {displine=false} } if (displine) { var memobj = new Object(); memobj = mems.find((element) => element.id == roles.find((element) => element.Id==role_detail[i].roleApprovalMemberShipId).ContactId); onlymems.push(memobj); } } //roles.find((element) => element.Id==role_detail[i].roleApprovalMemberShipId).RoleName) // mems = mems.filter( function(v) {return v.id == onlymems.find((element)=>element.id== v.id)}) mems = onlymems; for(i=0;i<memsunique.length;i++) { if (mems.findIndex(e=>e.id==memsunique[i].id)>-1) { onlymemsu.push(memsunique[i]); } } memsunique = onlymemsu; if (debug) {GM_log("Clear Mems exit: mems now has length "+mems.length);} } // } if (mems.length==0) { alert('The report will not be generated as your filters have resulted in no members being selected')} } function report2() { // console.log(mem[1]); // console.log(mems); if (debug) {GM_log("report2 : Collection for Report");} if (debug) {GM_log("report2 : Number of Members"+mems.length);} if (document.getElementById("gmwelcome").checked) { if (document.getElementById("gmhelper").checked) { mems = mems.filter( function(v) {return v.Role!="Non Member - Needs disclosure";}) mems = mems.filter( function(v) {return v.Role!="Holding";}) if (debug) {GM_log("Report 2: Remove Helpers roles now has length "+roles.length);} } } if (debug) {GM_log("mems now has length "+mems.length);} if (document.getElementById("gmteamname").value !=""){ if (debug) {GM_log("Match team "+document.getElementById("gmteamname").value);} mems = mems.filter( function(v) {return v.Team.includes(document.getElementById("gmteamname").value);}) if (debug) {GM_log("mems now has length "+mems.length);} } if(document.getElementById("gmexact").checked) { //gmexact if (debug) {GM_log("Match team "+document.getElementById("gmteamname").value);} mems = mems.filter( function(v) {return v.unitName == document.getElementById("gmunitname").value;}) if (debug) {GM_log("mems now has length "+mems.length);} } if (document.getElementById("gmpersonname").value !=""){ if (debug) {GM_log("Match Names "+document.getElementById("gmpersonname").value);} mems = mems.filter( function(v) {return v.fullname.toLowerCase().includes(document.getElementById("gmpersonname").value.toLowerCase());}) if (debug) {GM_log("mems now has length "+mems.length);} } if (mems.length==0) { alert('The report will not be generated as your filters have resulted in no members being selected')} if (debug) {GM_log("Check for Duplicates ");} var seen = {}; var out = []; var len = mems.length; var j = 0; for(var i = 0; i < len; i++) { var item = mems[i]; if(seen[item.id] !== 1) { seen[item.id] = 1; out[j++] = item; } } // if (!document.getElementById("gmwelcome").checked) { mems = out; // } memsunique = out; if (document.getElementById("gmwelcome").checked) { if (document.getElementById("gmhelper").checked) { mems = mems.filter( function(v) {return v.Role!="Non Member - Needs disclosure";}) mems = mems.filter( function(v) {return v.Role!="Holding";}) if (debug) {GM_log("Report 2: Remove Helpers roles now has length "+roles.length);} } mem_lcount = 0; clear_mems(); report5() } else { if (mems.length==0) { alert('The report will not be generated as your filters have resulted in no members being selected')} $("#gmState")[0].innerText = "Number of Members "+mems.length; GM_log("Number of Members "+mems.length); GM_log("Number of Unique Members "+memsunique.length); for(var loop = 0;loop<memsunique.length; loop++) { if (debug) {GM_log("Request Roles for "+loop+" "+memsunique[loop].firstname+" "+memsunique[loop].unitName);} GM_xmlhttpRequest({ method: "POST", context: loop+1, url: "https://tsa-memportal-prod-fun01.azurewebsites.net/api/GetMemberRolesAsync", data: '{"contactId": "'+memsunique[loop].id+'"}', headers: { "Content-Type": "application/json", "Authorization": "Bearer " + JSON.parse(localStorage.getItem("authInfo")).idToken, "Accept": "application/json, text/plain, */*" }, onload: function(response) {//console.log(response.context); roles_count +=1; $("#gmState")[0].innerText = "Number of Members "+memsunique.length+" reading roles for number "+response.context; // console.log(mems.length); if (response.status!=200) {GM_log("HTTP error "+response.status); GM_log(JSON.stringify(response));} if (debug) {GM_log("Request Roles received for "+response.context+" "+memsunique[response.context-1].firstname+" "+memsunique[response.context-1].unitName);} var jrole= null; try { jrole=JSON.parse(response.responseText).data} catch {console.log("JSON Error "+response.responseText);} if (jrole!=null) { roles=roles.concat(jrole); } if ((jrole==null)&&(debug)) { GM_log("GetData: We got an error collecting roles for member "+response.context+mems[response.context-1].firstname); } if (debug) {GM_log("Context "+response.context+" mems length "+memsunique.length+" "+response.context+" "+mems[response.context-1].firstname+" "+(response.context-1==memsunique.length-1)+" Roles Count "+(roles_count))} // console.log(JSON.parse(response.responseText)); // GM_log("Context "+response.context+ " "+ response.context-1 + "Unique "+memsunique.length if (roles_count==memsunique.length){console.log("Exit");console.log(roles);console.log(mems);report3();} }, onerror: function(response) { GM_log("ON Error");GM_log(JSON.stringify(response))}, onabort: function(response) { GM_log("ON Abort");GM_log(JSON.stringify(response))} }); }; } } function report3() { console.log(roles); if (debug) {GM_log("Report 3: mems now has length "+mems.length);} if (debug) {GM_log("Report 3: roles now has length "+roles.length);} if (document.getElementById("gmhelper").checked) { roles = roles.filter( function(v) {return !v.RoleName.includes("Non Member - Needs disclosure");}) roles = roles.filter( function(v) {return !v.RoleName.includes("Holding");}) if (debug) {GM_log("Report 3: Remove Helpers roles now has length "+roles.length);} } if (document.getElementById("gmclosed").checked) { roles = roles.filter( function(v) {return v.Closed}); roles = roles.filter( function(v) {return v.EndDate==null}); roles = roles.filter( function(v) {return !v.IsSecondaryLevel}); if (debug) {GM_log("Report 3: Remove Closed roles now has length "+roles.length);} console.log(roles); } if (document.getElementById("gmteamname").value !=""){ roles = roles.filter( function(v) {if( v.Team==null){return false} else {return v.Team.includes(document.getElementById("gmteamname").value);}}) if (roles.length==0) { alert('There were no roles in Units matching the Unit Name maybe check you have a % at the end to get all the sub Units')} if (debug) {GM_log("Report 3: Filter by Team roles now has length "+roles.length);} } if (document.getElementById("gmteamonly").checked){ var filter = document.getElementById("gmunitname").value.replaceAll("%", "*"); let w = filter.replace(/[.+^${}()|[\]\\]/g, '\\$&'); // regexp escape const re = new RegExp(`^${w.replace(/\*/g,'.*').replace(/\?/g,'.')}$`,'i'); roles = roles.filter( function(v) {return re.test(v.UnitId)}); if (debug) {GM_log("Report 3: Filter by for Unit only roles now has length "+roles.length);} } var xml = 0; var nullc=0; if (roles.length==0) { alert('The report will not be generated as your filters have resulted in no roles being selected')} for(var loop=0;loop<roles.length;loop++) { if (debug) {GM_log("Report 3: Roles Loop request for "+roles[loop].RoleName+" "+roles[loop].Team+" "+loop);} // console.log(roles[loop].EndDate); $("#gmState")[0].innerText = "Checking Role "+loop+" of "+roles.length; if ((roles[loop].EndDate==null)||(roles[loop].Status!=null)) { // console.log("OK"); role_max_count = loop; GM_xmlhttpRequest({ method: "POST", context: loop+1, url: "https://tsa-memportal-prod-fun01.azurewebsites.net/api/GenerateSASTokenAsync", data: '{container: "contacts", permissions: "R", file: "'+roles[loop].ContactId+'/membership/'+roles[loop].Id+'/audit/data.json"}', // synchronous: true, headers: { "Content-Type": "application/json", "Authorization": "Bearer " + JSON.parse(localStorage.getItem("authInfo")).idToken, "Accept": "application/json, text/plain, */*" }, onload: function(response) { if (debug) {GM_log("Report 3: Roles Blob request for "+response.context+" ")} if (debug) {GM_log("Report 3: Roles Blob request for "+(response.context-1)+" "+roles[response.context-1].RoleName+" "+roles[response.context-1].Team);} $("#gmState")[0].innerText = "Fetching Role "+response.context+" of "+roles.length; GM_xmlhttpRequest({ method: "GET", Accept: "application/json;odata=minimalmetadata", context: response.context+1, url: JSON.parse(response.responseText).token, onload: function(response) { // console.log(response.responseText); // console.log(JSON.parse(response.responseText)); // console.log("Total"+(role_detail.length + nullc + xml)); // console.log("Aim"+(roles.length-1)); if (debug) {GM_log("Report 3: Roles Loop received for "+(response.context-2)+" "+roles[response.context-2].RoleName+" "+roles[response.context-2].Team);} if (response.status!=200) {GM_log("HTTP error "+response.status); GM_log(JSON.stringify(response));} $("#gmState")[0].innerText = "Checking Role "+response.context; if(!response.responseText.includes("xml")) { role_detail.push(JSON.parse(response.responseText));} else {xml++; console.log("XML for "+response.context)}; if (debug) {GM_log("Report 3: role_detail.length : " +role_detail.length+" XML "+xml+" nullc "+nullc + " roles "+roles.length);} if ((role_detail.length+nullc+xml)>=roles.length){console.log("Finish REport 3");console.log(role_detail); mem_lcount = 0;clear_mems();report5()}}, onerror: function(response) { GM_log("Report 3 ON Error");GM_log(JSON.stringify(response))}, onabort: function(response) { GM_log("Report ON Abort");GM_log(JSON.stringify(response))} }) }, onerror: function(response) { GM_log("Report 3 Outer ON Error");GM_log(JSON.stringify(response))}, onabort: function(response) { GM_log("Report 3 Outer ON Abort");GM_log(JSON.stringify(response))} }); } else { nullc++} } } function report5() { if (document.getElementById("gmlearning").checked) { if (debug) {GM_log("Report 5: Get Learning for "+memsunique[mem_lcount].firstname+" "+memsunique[mem_lcount].Team)+" "+mem_lcount;} GM_xmlhttpRequest({ method: "POST", url: "https://tsa-memportal-prod-fun01.azurewebsites.net/api/GetLmsDetailsAsync", data: '{"contactId": "'+memsunique[mem_lcount].id+'"}', context: mem_lcount+1, headers: { "Content-Type": "application/json", "Authorization": "Bearer " + JSON.parse(localStorage.getItem("authInfo")).idToken, "Accept": "application/json, text/plain, */*" }, onload: function(response) { $("#gmState")[0].innerText = "Number of Members "+memsunique.length+" reading learning for number "+mem_lcount; if (debug) {GM_log("Report 5: Learning received for "+(response.context-1));} var l = new Object; l.id = memsunique[ mem_lcount].id; l.learn = []; try { l.learn=JSON.parse(response.responseText)} catch {console.log("JSON Error "+response.responseText);} mem_learning[mem_lcount] = l; // console.log(JSON.parse(response.responseText)); if ( mem_lcount==memsunique.length-1){console.log(mem_learning);report6();}else{ mem_lcount++;report5()}}, onerror: function(response) { GM_log("ON Error");GM_log(JSON.stringify(response))}, onabort: function(response) { GM_log("ON Abort");GM_log(JSON.stringify(response))} }); } else {report6() } } function xmlToJson(xml) { // Create the return object var obj = {}; if (xml.nodeType == 1) { // element // do attributes if (xml.attributes.length > 0) { obj["@attributes"] = {}; for (var j = 0; j < xml.attributes.length; j++) { var attribute = xml.attributes.item(j); obj["@attributes"][attribute.nodeName] = attribute.nodeValue; } } } else if (xml.nodeType == 3) { // text obj = xml.nodeValue; } // do children // If all text nodes inside, get concatenated text from them. var textNodes = [].slice.call(xml.childNodes).filter(function(node) { return node.nodeType === 3; }); if (xml.hasChildNodes() && xml.childNodes.length === textNodes.length) { obj = [].slice.call(xml.childNodes).reduce(function(text, node) { return text + node.nodeValue; }, ""); } else if (xml.hasChildNodes()) { for (var i = 0; i < xml.childNodes.length; i++) { var item = xml.childNodes.item(i); var nodeName = item.nodeName; // if (nodeName=="m:properties") {nodeName = "m_properties"} if (nodeName[1]==":") {nodeName = nodeName.replace(":", "_")}; if (typeof obj[nodeName] == "undefined") { obj[nodeName] = xmlToJson(item); } else { if (typeof obj[nodeName].push == "undefined") { var old = obj[nodeName]; obj[nodeName] = []; obj[nodeName].push(old); } obj[nodeName].push(xmlToJson(item)); } } } return obj; } function report6() { var xmlURL =""; var xml = 0; var nullc=0; if (document.getElementById("gmdbs").checked) { for(var loop=0;loop<memsunique.length;loop++) { if (debug) {GM_log("Report 6: DBS requested for "+loop+" "+memsunique[loop].firstname);} // console.log(roles[loop].EndDate); $("#gmState")[0].innerText = "Checking Disclosure "+loop+" of "+memsunique.length; GM_xmlhttpRequest({ method: "POST", context: loop+1, url: "https://tsa-memportal-prod-fun01.azurewebsites.net/api/GenerateSASTokenAsync", data: '{"table": "Disclosures", "permissions": "R", "partitionkey" : "'+memsunique[loop].id+'"}', synchronous: true, headers: { "Content-Type": "application/json", "Type" : "table", "accept-language" : "en-GB,en;q=0.9", "sec-fetch-site" : "cross-site", "Origin" : "https://membership.scouts.org.uk", "content-encoding" : "gzip", "Authorization": "Bearer " + JSON.parse(localStorage.getItem("authInfo")).idToken, "Accept": "application/json, text/plain, */*" }, onload: function(response) { xmlURL = ""; if (debug) {GM_log("Report 6: DBS Blob URL Received for "+(response.context-1)+" "+memsunique[response.context-1].firstname);} try { xmlURL = JSON.parse(response.responseText) } catch {console.log(response.responseText)}; if (xmlURL=="") { if (debug) {GM_log("Report 6: DBS Blob URL JSON Error " +response.responseText);} } if (xmlURL!="") { $("#gmState")[0].innerText = "Fetching DBS "+response.context+" of "+memsunique.length; GM_xmlhttpRequest({ method: "GET", context: response.context, url: JSON.parse(response.responseText).token, onload: function(response) { if (debug) {GM_log("Report 6: DBS received for "+(response.context-1)+" "+memsunique[response.context-1].firstname);} if (response.status!=200) {GM_log("HTTP error "+response.status); GM_log(JSON.stringify(response));} $("#gmState")[0].innerText = "Checking DBS "+response.context; if(response.responseText.includes("xml")) { var XmlNode = new DOMParser().parseFromString(response.responseText, 'text/xml'); var dbsxml = xmlToJson(XmlNode); dbsxml.id = memsunique[response.context-1].id; dbsxml.firstname = memsunique[response.context-1].firstname; dbs_detail.push(dbsxml);} else {xml++}; if (dbs_detail.length+xml>=memsunique.length){console.log(dbs_detail); report4()}}, onerror: function(response) { GM_log("ON Error");GM_log(JSON.stringify(response))}, onabort: function(response) { GM_log("ON Abort");GM_log(JSON.stringify(response))} }) } else {xml++; if (dbs_detail.length+xml>=memsunique.length){console.log(dbs_detail); report4()}} } }); } } else {report4()} } function report_headers(table) { var expirytext = "Expiry"; var expirytextdays = "Expiry Days"; var act = ['managerDisclosureCheck','dataProtectionTrainingComplete','signDeclaration','updateMemberProfile','referenceRequest','safeguardconfidentialEnquiryCheck','managerWelcomeConversation','coreLearning','managerTrusteeCheck']; var title = ['Role','Unit','Team','Name','Number','Status','Start Date','Days','Disclosure','GDPR','Declaration','Profile','References','CE Check','Welcome','Learning','Trustee']; var learn = ['Creating Inclusion','Data Protection in Scouts','Who We Are and What We Do','Safeguarding','Safety','First Response','Delivering a Great Programme','Being a Trustee in Scouts','Leading Scout Volunteers']; var tr = document.createElement('TR'); table.appendChild(tr); for (var i=0; i<title.length;i++){ var td = document.createElement('TH'); if (i>7) { td.style.writingMode = "vertical-lr"; td.style.backgroundColor='lightcyan';} // td.style.writingmode = 'vertical-lr'; td.appendChild(document.createTextNode(title[i])); var visible = true; if ((i>4)&&(document.getElementById("gmwelcome").checked)){visible=false}; if ((i==4)&&(!document.getElementById("gmnumber").checked)){visible=false}; if (visible) { tr.appendChild(td); } } if (document.getElementById("gmlearning").checked) { for ( i=0; i<learn.length;i++){ td = document.createElement('TH'); td.style.writingMode = "vertical-lr"; td.style.backgroundColor = 'LightGray'; td.appendChild(document.createTextNode(learn[i])); tr.appendChild(td); if (((i==3)||(i==4)||(i==5))&&(document.getElementById("gmdates").checked)) { td = document.createElement('TH'); td.style.writingMode = "vertical-lr"; td.style.backgroundColor = 'LightGray'; td.appendChild(document.createTextNode(learn[i]+" "+expirytext)); tr.appendChild(td); } if (((i==3)||(i==4)||(i==5))&&(document.getElementById("gmdays").checked)) { td = document.createElement('TH'); td.style.writingMode = "vertical-lr"; td.style.backgroundColor = 'LightGray'; td.appendChild(document.createTextNode(learn[i]+" "+expirytextdays)); tr.appendChild(td); } } } if (document.getElementById("gmdbs").checked) { td = document.createElement('TH'); td.style.backgroundColor = 'LightGray'; td.appendChild(document.createTextNode("DBS Expiry")); tr.appendChild(td); td = document.createElement('TH'); td.style.writingMode = "vertical-lr"; td.style.backgroundColor = 'LightGray'; td.appendChild(document.createTextNode("DBS Days Remaining")); tr.appendChild(td); if (document.getElementById("gmdbsip").checked){ td = document.createElement('TH'); td.style.backgroundColor = 'LightGray'; td.appendChild(document.createTextNode("DBS Status")); tr.appendChild(td); } } } function tabulator_id_url() { } var headerMenu = function(){ var menu = []; var columns = this.getColumns(); for(let column of columns){ //create checkbox element using font awesome icons let icon = document.createElement("span"); icon.classList.add("fas"); icon.classList.add(column.isVisible() ? "fa-check-square" : "fa-square"); //build label let label = document.createElement("span"); let title = document.createElement("span"); title.textContent = " " + column.getDefinition().title; label.appendChild(icon); label.appendChild(title); //create menu item menu.push({ label:label, action:function(e){ //prevent menu closing e.stopPropagation(); //toggle current column visibility column.toggle(); //change menu item icon if(column.isVisible()){ icon.classList.remove("fa-square"); icon.classList.add("fa-check-square"); }else{ icon.classList.remove("fa-check-square"); icon.classList.add("fa-square"); } } }); } return menu; }; function report_headers_tabulator() { var expirytext = "Expiry"; var expirytextdays = "Expiry Days"; var act = ['managerDisclosureCheck','dataProtectionTrainingComplete','signDeclaration','updateMemberProfile','referenceRequest','safeguardconfidentialEnquiryCheck','managerWelcomeConversation','coreLearning','managerTrusteeCheck']; var title = ['Name','Role','Unit','Team','Number','Status','Start Date','Days','Disclosure','GDPR','Declaration','Profile','References','CE Check','Welcome','Growing Roots Learning','Trustee Check']; var learn = ['Creating Inclusion','Data Protection in Scouts','Who We Are and What We Do','Safeguarding','Safety','First Response','Delivering a Great Programme','Being a Trustee in Scouts','Leading Scout Volunteers']; var titlefieldnames = ['name','role','unit','team','number','status','start','days','disclosure','gdpr','declaration','profile','references','ce','welcome','learning','trustee']; var learnfieldnames = ['inclusion','datap','who','safeguarding','safety','firstresponse','programme','trustee2','leading']; var dbs = ['DBS','DBS Expiry','DBS Days','DBS Status']; var dbsfieldnames = ['dbs','dbs_expiry','dbs_expirydays','dbsstatus']; var headers = []; var color_formatter = function testFormatter(cell, formatterParams) { var days = cell.getValue(); if(document.getElementById("gmcolor").checked) { var fv = cell.getData()[cell.getField().substr(0,cell.getField().indexOf("_"))]; if ("✅❌✔⚡".includes(fv)) { for(cloop=0;cloop<4;cloop++) { if ((days<=daylimits[cloop])&&(days>daylimits[cloop+1])) { cell.getElement().style.backgroundColor = colors[cloop]; cell.getElement().style.color = colorsT[cloop]; }}} } return days} var color_formatter_date = function testFormatter(cell, formatterParams) { if(document.getElementById("gmcolor").checked) { var fv = cell.getData()[cell.getField().substr(0,cell.getField().indexOf("_"))]; if ("✅❌✔⚡".includes(fv)) { var days = cell.getData()[cell.getField()+"days"]; for(cloop=0;cloop<4;cloop++) { if ((days<=daylimits[cloop])&&(days>daylimits[cloop+1])) { cell.getElement().style.backgroundColor = colors[cloop]; cell.getElement().style.color = colorsT[cloop]; }}}} return cell.getValue()} // for (var i=0; i<title.length;i++){ var group = new Object; var visible = true; group.columns = []; group.title = ""; group.frozen = true; var head = new Object; head.title = title[0]; head.field = titlefieldnames[0]; head.headerFilter = "input"; head.formatterParams = new Object; head.formatter="link"; head.formatterParams.urlField = "memberURL";head.formatterParams.target = "_blank" head.headerMenu = headerMenu; group.columns.push(head); headers.push(group); group = new Object; group.columns = []; group.title = ""; for (var i=1; i<8;i++){ visible = true; if (((i>4))&&(document.getElementById("gmwelcome").checked)){visible=false}; // if ((i==4)&&(!document.getElementById("gmnumber").checked)){visible=false}; if (visible) { head = new Object; head.title = title[i]; head.field = titlefieldnames[i]; head.headerFilter = "input"; if (i==6) { head.sorter = "date";} if (i==7) { head.sorter = "number"; head.headerFilterPlaceholder = "less than" ; head.headerFilterFunc = "<"; head.headerFilter = "number";} if (i==0) { head.frozen = true;} head.formatterParams = new Object; if (i==0){head.formatter="link"; head.formatterParams.urlField = "memberURL";head.formatterParams.target = "_blank"} if (i>7) { head.headerVertical = true;} head.headerMenu = headerMenu; group.columns.push(head); } } headers.push(group); group = new Object; if (!document.getElementById("gmwelcome").checked) { group.columns = []; group.title = "Welcome Activities"; // group.cssClass = "blue-background"; for (i=8; i<title.length;i++){ visible = true; if ((i>7)&&(document.getElementById("gmwelcome").checked)){visible=false}; if (visible) { head = new Object; head.title = title[i]; head.field = titlefieldnames[i]; head.cssClass = "blue-background"; head.formatterParams = new Object; if (i>7) { head.headerVertical = true;} head.headerFilter = "list"; head.headerFilterParams = { valuesLookup:"active" } group.columns.push(head); } } headers.push(group); } group = new Object; if (document.getElementById("gmlearning").checked) { group.columns = []; group.title = "Learning"; // group.cssClass = "yellow-background"; for ( i=0; i<learn.length;i++){ head = new Object; head.title = learn[i]; head.field = learnfieldnames[i]; head.headerVertical = true; head.cssClass = "yellow-background"; head.headerFilter = "list"; head.headerFilterParams = { valuesLookup:"active" } group.columns.push(head); if (((i==3)||(i==4)||(i==5))) { head = new Object; head.title = learn[i]+" "+expirytext; head.field = learnfieldnames[i]+"_expiry"; head.sorter = "date"; head.headerVertical = true; head.formatter = color_formatter_date; head.cssClass = "yellow-background"; head.headerFilter = "input"; group.columns.push(head); } if (((i==3)||(i==4)||(i==5))) { head = new Object; head.title = learn[i]+" "+expirytextdays; head.field = learnfieldnames[i]+"_expirydays"; head.sorter = "number"; head.headerVertical = true; head.formatter = color_formatter; head.cssClass = "yellow-background"; head.headerFilterPlaceholder = "less than", head.headerFilterFunc = "<" head.headerFilter = "number"; group.columns.push(head); } } headers.push(group); } group = new Object; if (document.getElementById("gmdbs").checked) { group.columns = []; group.title = "DBS"; // group.cssClass = "orange-background"; for ( i=0; i<dbs.length-1;i++){ head = new Object; head.title = dbs[i]; head.field = dbsfieldnames[i]; head.cssClass = "orange-background"; if (i==0) { head.headerFilter = "list"; head.headerFilterParams = { valuesLookup:"active" } } else { head.headerFilter = "input"; } if (i==0) { head.headerVertical = true;} if (i==2) { head.sorter = "number"; head.formatter = color_formatter; head.headerFilterPlaceholder = "less than" ; head.headerFilterFunc = "<"; head.headerFilter = "number";} if (i==1) { head.sorter = "date"; head.formatter = color_formatter_date;} group.columns.push(head); } // if (document.getElementById("gmdbsip").checked){ head = new Object; head.title = dbs[3]; head.field = dbsfieldnames[3]; head.cssClass = "orange-background"; head.headerFilter = "input"; group.columns.push(head); headers.push(group); // } } return headers; } function report4() { if (debug) {GM_log("Report 4 : Data Collected - generate report ");} if (debug) {GM_log("Report 4 : Roles Detail "+role_detail.length);} if (debug) {GM_log("Report 4 : Mems "+mems.length);} if (debug) {GM_log("Report 4 : Roles "+roles.length);} if (debug) {GM_log("Report 4 : Learning "+mem_learning.length);} if (debug) {GM_log("Report 4 : DBS "+ dbs_detail.length);} var expirytext = "Expiry"; var expirytextdays = "Expiry Days"; var act = ['managerDisclosureCheck','dataProtectionTrainingComplete','signDeclaration','updateMemberProfile','referenceRequest','safeguardconfidentialEnquiryCheck','managerWelcomeConversation','coreLearning','managerTrusteeCheck']; var title = ['Role','Unit','Team','Name','Status','Start Date','Days','Disclosure','GDPR','Declaration','Profile','References','CE Check','Welcome','Learning','Trustee']; var learn = ['Creating Inclusion','Data Protection in Scouts','Who We Are and What We Do','Safeguarding','Safety','First Response','Delivering a Great Programme','Being a Trustee in Scouts','Leading Scout Volunteers']; $("#gmState")[0].innerText = "Data Collection Completed"; var myTableDiv = document.getElementById("gmTable"); var table = document.createElement('TABLE'); table.border = '1'; table.id = "GMourreport"; var tableBody = document.createElement('THEAD'); table.appendChild(tableBody); // var tr = document.createElement('TR'); // tableBody.appendChild(tr); report_headers(tableBody); tableBody = document.createElement('TBODY'); table.appendChild(tableBody); var tablines = []; var tr = document.createElement('TR'); if (!(document.getElementById("gmwelcome").checked)) { for (i = 0; i < role_detail.length; i++) { var displine=true; if (document.getElementById("gmmissing").checked) { var any_missing = false; for (var j = 0; j < act.length; j++) { if (role_detail[i].actions.find((element)=>element.typeid==act[j])) { var value = role_detail[i].actions.find((element)=>element.typeid==act[j]).status; if ((value!="Satisfactory")&&(value!="Completed")&&(value!="Held - Satisfactory")){ any_missing=true;} } } if (any_missing==false) {displine=false} } if (displine) { // tr = document.createElement('TR'); // tableBody.appendChild(tr); output_report_line(tableBody,i,mems.findIndex( (element) => element.id == roles.find( (element) => element.Id == role_detail[i].roleApprovalMemberShipId).ContactId)); tablines.push(report_line_tabulator(i,mems.findIndex( (element) => element.id == roles.find( (element) => element.Id == role_detail[i].roleApprovalMemberShipId).ContactId))); } } } else { for (var i = 0; i < mems.length; i++) { if (mems[i].Role!=null) { output_report_line(tableBody,-1,i); tablines.push( report_line_tabulator(-1,i)) } } } table.style.fontSize = "10pt"; document.getElementById("gmTable").innerHTML=""; // myTableDiv.appendChild(table); // console.log(hasStyleRule("tabulator-col.tabulator-sortable.tabulator-col-sorter-element.orange-background")); if (!added_css) { added_css=true; GM_addStyle ('.fa-check-square:before { content: "✅"; }' ); GM_addStyle ('.fa-square:before { content: "🟩"; }' ); GM_addStyle('.tabulator-col.tabulator-col-vertical.tabulator-sortable.tabulator-col-sorter-element.blue-background {background : #ADD8E6 }'); GM_addStyle('.tabulator-col.tabulator-col-vertical.tabulator-sortable.tabulator-col-sorter-element.yellow-background {background : #FFFFE0 }'); GM_addStyle('.tabulator-col.tabulator-sortable.tabulator-col-sorter-element.orange-background {background : #FFDAB9 }'); GM_addStyle('th.blue-background { writing-mode: vertical-lr; background-color: lightcyan; }'); GM_addStyle('th.yellow-background { writing-mode: vertical-lr; background-color: lightgoldenrodyellow; }'); GM_addStyle('th.orange-background { writing-mode: vertical-lr; background-color: salmon; }'); GM_addStyle('table.tabulator-print-table, tr, th, td { border: solid;}'); } tabletabulator = new Tabulator("#gmTabulator", {data: tablines, printAsHtml:true, columnHeaderVertAlign :"bottom", maxHeight:"100%", columns: report_headers_tabulator(), movableColumns: true, dependencies:{ DateTime:luxon.DateTime, }, downloadEncoder:function(fileContents, mimeType){ var b = new Blob([fileContents], {type:mimeType}); var url = URL.createObjectURL(b); url = window.URL.createObjectURL(b); var filename = 'myBlobFile.xlsx'; var a = document.createElement('a'); a.style = 'display: none'; a.href = url; a.download = filename; // IE 11 if (window.navigator.msSaveBlob !== undefined) { window.navigator.msSaveBlob(b, filename); return; } document.body.appendChild(a); var e = new MouseEvent ("click"); a.dispatchEvent (e); window.URL.revokeObjectURL(url); document.body.removeChild(a); // }); } }); // tabulator tabletabulator.on("tableBuilt", function(){ if (!document.getElementById("gmnumber").checked) { tabletabulator.hideColumn("number") } if (!document.getElementById("gmdates").checked) { tabletabulator.hideColumn("safeguarding_expiry");tabletabulator.hideColumn("firstresponse_expiry");tabletabulator.hideColumn("safety_expiry") } if (!document.getElementById("gmdays").checked) { tabletabulator.hideColumn("safeguarding_expirydays");tabletabulator.hideColumn("firstresponse_expirydays");tabletabulator.hideColumn("safety_expirydays") } if (!document.getElementById("gmdbsip").checked) { tabletabulator.hideColumn("dbsstatus") } }); } var trustee_roles = ['Lead Volunteer','Trustee','Treasurer','Youth Lead','Chair']; function is_trustee(rolename) { if (trustee_roles.findIndex(e=>e == rolename)>-1) {return true} if (rolename.includes(trustee_roles[0])) {return true} return false; } var no_dbs = ['President','Vice President','Holding','Retired Member','Nations Staff Member','Council Member','Network Member','Locally Employed Staff','National Staff member','National Staff team leader','Trustee Board Sub-Team Member']; function needs_dbs(rolename) { if (no_dbs.findIndex(e=>e == rolename)>-1) {return false} else {return true}; } var no_training = ['President','Vice President','Holding','Retired Member','Non Member - Needs disclosure','Council Member','Network Member','Designated Carers']; function needs_training(rolename) { if (no_training.findIndex(e=>e == rolename)>-1) {return false} else {return true}; } function is_section(unit_type) { if ((unit_type=='Group Section')||(unit_type=='District Section')||(unit_type=='County Section')) {return true} else {return false} } var mainteams = ['Leadership Team','Volunteering Development Team','Support Team','Programme Team','14-24 Team']; function is_mainteam(team_name) { if (mainteams.findIndex((element)=>element==team_name>-1)) {return true} else {return false} } function is_teamleader(rolename,unit_type,ParentTeamId,team_name) { // if ((roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).RoleName.includes('Lead Volunteer'))||(roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).RoleName=='Team Leader')&&((roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).UnitType!='Group Section')&&(roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).UnitType!='District Section'))) { if (rolename.includes('Lead Volunteer')) { return true;} if (rolename.includes('Youth Lead')) { return true;} if (ParentTeamId!=null) {return false} // Is a Sub team if (!is_mainteam(team_name)) {return false} if ((rolename=='Team Leader')&&!is_section(unit_type)) {return true} return false; } function is_firstresponse(unit_type,role_name,team_name) { if (is_section(unit_type)) {return true} if (role_name=="Group Lead Volunteer") {return true} if ((team_name=='14-24 Team')&&(role_name=="Team Leader")) {return true} return false; } // ***************************************************************** /// This is used for the refresh but no new data /// ***************************************************************** function output_report_line(table,role_index,mem_index) { var act = ['managerDisclosureCheck','dataProtectionTrainingComplete','signDeclaration','updateMemberProfile','referenceRequest','safeguardconfidentialEnquiryCheck','managerWelcomeConversation','coreLearning','managerTrusteeCheck']; var title = ['Role','Unit','Team','Name','Status','Start Date','Days','Disclosure','GDPR','Declaration','Profile','References','CE Check','Welcome','Learning','Trustee']; var learn = ['Creating Inclusion','Data Protection in Scouts','Who We Are and What We Do','Safeguarding','Safety','First Response','Delivering a Great Programme','Being a Trustee in Scouts','Leading Scout Volunteers']; var tr = document.createElement('TR'); table.appendChild(tr); // Name if (role_index>=0) { var td = document.createElement('TD'); td.appendChild(document.createTextNode(roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).RoleName)); tr.appendChild(td); td = document.createElement('TD'); td.appendChild(document.createTextNode(roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).UnitId)); tr.appendChild(td); td = document.createElement('TD'); td.appendChild(document.createTextNode(roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).Team)); tr.appendChild(td); } else { td = document.createElement('TD'); td.appendChild(document.createTextNode(mems[mem_index].Role)); tr.appendChild(td); td = document.createElement('TD'); td.appendChild(document.createTextNode(mems[mem_index].unitName)); tr.appendChild(td); td = document.createElement('TD'); td.appendChild(document.createTextNode(mems[mem_index].Team)); tr.appendChild(td); } td = document.createElement('TD'); var fullname = mems[mem_index].fullname; // var nameid = mems.find((element) => element.id == roles.find((element) => element.Id==role_detail[i].roleApprovalMemberShipId).ContactId).id; var nameid = mems[mem_index].id; var memhtml = '<a href="https://membership.scouts.org.uk/#/membersearch/'+nameid+'/viewmember" target="_blank">'+fullname+'</a>'; tr.appendChild(td); td.innerHTML=(memhtml); if (document.getElementById("gmnumber").checked) { td = document.createElement('TD'); td.appendChild(document.createTextNode(mems[mem_index].membershipnumber)); tr.appendChild(td); }; if (role_index>=0) { // Role td = document.createElement('TD'); td.appendChild(document.createTextNode(role_detail[role_index].rolestatus)); tr.appendChild(td); td = document.createElement('TD'); var sdate = new Date(roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).StartDate); td.appendChild(document.createTextNode(sdate.toLocaleDateString('en-GB'))); var days = Math.round((new Date() - sdate) / (1000 * 60 * 60 * 24)); tr.appendChild(td); td = document.createElement('TD'); td.appendChild(document.createTextNode(days)); tr.appendChild(td); for (var j = 0; j < act.length; j++) { td = document.createElement('TD'); // td.width = '75'; if (role_detail[role_index].actions.find((element)=>element.typeid==act[j])) { var state= 0x274C; var value = role_detail[role_index].actions.find((element)=>element.typeid==act[j]).status; if ((value=="Satisfactory")||(value=="Completed")||(value=="Held - Satisfactory")){state= 0x2705;} // td.appendChild(document.createTextNode(role_detail[i].actions.find((element)=>element.typeid==act[j]).status+String.fromCodePoint(state))); td.appendChild(document.createTextNode(String.fromCodePoint(state))); // td.appendChild(document.createTextNode(String.fromCodePoint(state))); } else { // Deal with bug in API that means this can be missing..... if(j==3) { state= 0x274C; td.appendChild(document.createTextNode(String.fromCodePoint(state))); } else { td.appendChild(document.createTextNode(" ")) } } td.style.backgroundColor='lightcyan'; tr.appendChild(td); } } else { } // Learning if (document.getElementById("gmlearning").checked) { for ( j = 0; j < learn.length; j++) { td = document.createElement('TD'); state= 0x274C; var lr = mem_learning.find((element) => element.id == mems[mem_index].id); if (lr.learn.find((object)=>object.title==learn[j])){ state= 0x2705; } // Check Expiry x26A1 if (lr.learn.find((object)=>object.title==learn[j])){ if (lr.learn.find( (object) => object.title == learn[j]).expiryDate !=null) { sdate = new Date(lr.learn.find((object)=>object.title==learn[j]).expiryDate); days = Math.round((sdate - new Date()) / (1000 * 60 * 60 * 24)); if (days<=90) {state = 0x26A1; } } else {days=0;sdate = new Date("1977-01-01T00:00:01Z") ;} } else {days=0;sdate = new Date("1977-01-01T00:00:01Z") ;} if (role_index>=0) { var role_find = {}; role_find = roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId); if (j==7) { // Trustee // if ((!roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).RoleName.includes('Lead Volunteer'))&&(roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).RoleName!='Trustee')) { if (!is_trustee(role_find.RoleName)) { if(state==0x2705) {state=0x2714;} else { state = 0x0020; } } } if (j==8) { // Team Lead is_teamleader(rolename,unit_type,ParentTeamId,team_name) // if ((roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).RoleName.includes('Lead Volunteer'))||(roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).RoleName=='Team Leader')&&((roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).UnitType!='Group Section')&&(roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).UnitType!='District Section'))) { if (is_teamleader(role_find.RoleName,role_find.UnitType,role_find.ParentTeamId,role_find.Team)) { } else {if(state==0x2705) { state=0x2714;} else { state = 0x0020; }} } /* if (j==8) { // Team Lead of Subteam means no training... Parent being null means this isn't a subteam if ((roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).ParentTeamId==null)) { } else {if((state==0x2705)||(state == 0x2714)) { state=0x2714;} else { state = 0x0020; }} }*/ if (j==6) { // programme - only section roles // if ((roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).UnitType!='Group Section')&&(roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).UnitType!='District Section')) { if (!is_section(role_find.UnitType) ) if(state==0x2705) { state=0x2714;} else { state = 0x0020; } } if (j==5) { // First Response // if ((roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).UnitType=='Group Section')||(roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).UnitType=='District Section')||(roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).RoleName=='Group Lead Volunteer')||((roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).RoleName=='Team Leader'))&&(roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).Team=='14-24 Team')) { if (is_firstresponse(role_find.UnitType,role_find.RoleName,role_find.Team)) { } else { if(state==0x2705) { state=0x2714;} else { state = 0x0020; } } } // Check for those not needing training // var rn = roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).RoleName; // if ((rn=='Non Member - Needs disclosure')||(rn=='President')||(rn=='Vice President')||(rn=='Holding')||(rn=='Retired Member')) { if (!needs_training(role_find.RoleName)) { if ((state == 0x26A1)||(state == 0x2705)||(state == 0x2714)) { state=0x2714;} else { state = 0x0020; } } } else { if ((j==7)&&(mems[mem_index].Role!=null)) { // Trustee if (!is_trustee(mems[mem_index].Role)) { // if ((!mems[mem_index].Role.includes('Lead Volunteer'))&&(mems[mem_index].RoleName!='Trustee')) { if(state==0x2705) { state=0x2714;} else { state = 0x0020; } } } if ((j==8)&&(mems[mem_index].Role!=null)) { // Team Lead if (is_teamleader(mems[mem_index].Role,mems[mem_index].unittype,null,mems[mem_index].Team)) { // if ((mems[mem_index].Role.includes('Lead Volunteer'))||(mems[mem_index].Role=='Team Leader')&&((mems[mem_index].unittype!='Group Section')&&(mems[mem_index].unittype!='District Section'))) { } else {if(state==0x2705) { state=0x2714;} else { state = 0x0020; }} } /* if (j==8) { var mainteams = ['Leadership Team','Volunteering Development Team','Support Team','Programme Team','14-24 Team']; // Team Lead for Sub teams if (mainteams.find((element)=>element==mems[mem_index].Team!=undefined) ) { } else {if((state==0x2705)||(state == 0x2714)) { state=0x2714;} else { state = 0x0020; }} }*/ if (j==6) { // programme - only section roles if (!is_section(mems[mem_index].unittype) ){ // if ((mems[mem_index].unittype!='Group Section')&&(mems[mem_index].unittype!='District Section')) { if(state==0x2705) { state=0x2714;} else { state = 0x0020; } } } if ((j==5)&&(mems[mem_index].Role!=null)) { // First Response // if ((mems[mem_index].unittype=='Group Section')||(mems[mem_index].unittype=='District Section')||(mems[mem_index].Role=='Group Lead Volunteer')||((mems[mem_index].Role=='Team Leader'))&&(mems[mem_index].Team=='14-24 Team')) { if (is_firstresponse(mems[mem_index].unittype,mems[mem_index].Role,mems[mem_index].Team)) { } else { if(state==0x2705) { state=0x2714;} else { state = 0x0020; } } } // Check for those not needing training var rn = mems[mem_index].Role; if (rn!=null) { if (!needs_training(mems[mem_index].Role)) { if ((state == 0x26A1)||(state == 0x2705)||(state == 0x2714)) { state=0x2714;} else { state = 0x0020; } } } } td.appendChild(document.createTextNode(String.fromCodePoint(state))); td.style.backgroundColor = 'LightGray'; tr.appendChild(td); var blankdate = new Date("1977-01-01T00:00:01Z"); if ((document.getElementById("gmdates").checked)&&((j==3)||(j==4)||(j==5))) { td = document.createElement('TD'); if (lr.learn.find( (object) => object.title == learn[j])) { if (sdate.getTime()!= blankdate.getTime()) { td.style.backgroundColor = 'LightGray'; if (( state != 0x0020)&&(document.getElementById("gmcolor").checked)){ for(var cloop=0;cloop<4;cloop++) { if ((days<=daylimits[cloop])&&(days>daylimits[cloop+1])) { td.style.backgroundColor = colors[cloop]; td.style.textColor = colorsT[cloop]; }}} td.appendChild(document.createTextNode(sdate.toLocaleDateString('en-GB'))); } } else { if (( state != 0x0020)&&(document.getElementById("gmcolor").checked)){ for(cloop=0;cloop<4;cloop++) { if ((days<=daylimits[cloop])&&(days>daylimits[cloop+1])) { td.style.backgroundColor = colors[cloop]; td.style.textColor = colorsT[cloop]; }}} } tr.appendChild(td); } if (((j==3)||(j==4)||(j==5))&&(document.getElementById("gmdays").checked)) { td = document.createElement('TD'); td.style.backgroundColor = 'LightGray'; if (!document.getElementById("gmwelcome").checked) { if ((j!=3)||(((roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).UnitType=='Group Section')||(roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).UnitType=='District Section')||(roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).RoleName=='Group Lead Volunteer')||((roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).RoleName=='Team Leader'))&&(roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).Team=='14-24 Team'))&&j==3)) { if (sdate!= new Date("1000-01-01T00:00:01Z")) { td.appendChild(document.createTextNode(days)); } } } else { if (sdate!= new Date("1000-01-01T00:00:01Z")) { td.appendChild(document.createTextNode(days)); }} if (( state != 0x0020)&&(document.getElementById("gmcolor").checked)){ for(cloop=0;cloop<4;cloop++) { if ((days<=daylimits[cloop])&&(days>daylimits[cloop+1])) { td.style.backgroundColor = colors[cloop]; td.style.textColor = colorsT[cloop]; }}} tr.appendChild(td); } } } if (document.getElementById("gmdbs").checked) { if (role_index>=0) { rn = roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).RoleName; } else { rn=mems[mem_index].Role;} // if ((rn=='President')||(rn=='Vice President')||(rn=='Holding')||(rn=='Retired Member')) { if (!needs_dbs(rn)) { // No DBS Needed td = document.createElement('TD'); tr.appendChild(td); td = document.createElement('TD'); tr.appendChild(td); } else { var mindex = dbs_detail.findIndex((element)=> element.id == mems[mem_index].id) if (mindex>=0) { var time = new Date("1000-01-01T00:00:01Z") ; var timel = new Date("1000-01-01T00:00:01Z") ; var dbs_status = ""; if (dbs_detail[mindex].feed.entry != undefined) { if ( dbs_detail[mindex].feed.entry.length != undefined ) { for(var dbsloop=0;dbsloop<dbs_detail[mindex].feed.entry.length;dbsloop++) { sdate = new Date(dbs_detail[mindex].feed.entry[dbsloop].content.m_properties.d_ExpiryDate); if (sdate>time) { time = sdate;} sdate = new Date(dbs_detail[mindex].feed.entry[dbsloop].content.m_properties.d_IssuedDate); if (sdate>timel) { timel = sdate;dbs_status=dbs_detail[mindex].feed.entry[dbsloop].content.m_properties.d_Status; if (dbs_status!="Disclosure issued"){dbs_status+=" "+timel.toLocaleDateString('en-GB')}} } } if (dbs_detail[mindex].feed.entry.length == undefined) { // Single DBS sdate = new Date(dbs_detail[mindex].feed.entry.content.m_properties.d_ExpiryDate); if (sdate>time) { time = sdate;} sdate = new Date(dbs_detail[mindex].feed.entry.content.m_properties.d_DateModified); dbs_status=dbs_detail[mindex].feed.entry.content.m_properties.d_Status; if (dbs_status!="Disclosure issued"){dbs_status+=" "+sdate.toLocaleDateString('en-GB')} } } td = document.createElement('TD'); var dbsdatedisp = time.toLocaleDateString('en-GB'); if (time<new Date()) {dbsdatedisp=String.fromCodePoint(0x274C)}; var expdays = Math.round((time-new Date()) / (1000 * 60 * 60 * 24)); if ((expdays<=90)&&(expdays>0)) {dbsdatedisp+=String.fromCodePoint(0x26A1)} if ((document.getElementById("gmcolor").checked)){ for(cloop=0;cloop<4;cloop++) { if ((expdays<=daylimits[cloop])&&(expdays>daylimits[cloop+1])) { td.style.backgroundColor = colors[cloop]; td.style.textColor = colorsT[cloop]; }}} td.appendChild(document.createTextNode(dbsdatedisp)); tr.appendChild(td); td = document.createElement('TD'); if ((document.getElementById("gmcolor").checked)){ for(cloop=0;cloop<4;cloop++) { if ((expdays<=daylimits[cloop])&&(expdays>daylimits[cloop+1])) { td.style.backgroundColor = colors[cloop]; td.style.textColor = colorsT[cloop]; }}} if(expdays>0) { td.appendChild(document.createTextNode(expdays)); } tr.appendChild(td); if (document.getElementById("gmdbsip").checked){ td = document.createElement('TD'); td.appendChild(document.createTextNode(dbs_status)); tr.appendChild(td); } } else {td = document.createElement('TD');td.appendChild(document.createTextNode(String.fromCodePoint(0x274C))); tr.appendChild(td);td = document.createElement('TD');tr.appendChild(td); if (document.getElementById("gmdbsip").checked) { td = document.createElement('TD');tr.appendChild(td); } } } } } function report_line_tabulator(role_index,mem_index) { var act = ['managerDisclosureCheck','dataProtectionTrainingComplete','signDeclaration','updateMemberProfile','referenceRequest','safeguardconfidentialEnquiryCheck','managerWelcomeConversation','coreLearning','managerTrusteeCheck']; var title = ['Role','Unit','Team','Name','Number','Status','Start Date','Days','Disclosure','GDPR','Declaration','Profile','References','CE Check','Welcome','Learning','Trustee']; var learn = ['Creating Inclusion','Data Protection in Scouts','Who We Are and What We Do','Safeguarding','Safety','First Response','Delivering a Great Programme','Being a Trustee in Scouts','Leading Scout Volunteers']; var titlefieldnames = ['role','unit','team','name','number','status','start','days','disclosure','gdpr','declaration','profile','references','ce','welcome','learning','trustee']; var learnfieldnames = ['inclusion','datap','who','safeguarding','safety','firstresponse','programme','trustee2','leading']; var dbs = ['DBS Expiry','DBS Days','DBS Status']; var dbsfieldnames = ['dbs','dbs_expiry','dbs_expirydays','dbsstatus']; var line = new Object; // Name if (role_index>=0) { line.role = roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).RoleName; line.unit = roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).UnitId; line.team = roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).Team; line.memberURL = 'https://membership.scouts.org.uk/#/membersearch/'+roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).ContactId+"/viewmember"; } else { line.role = mems[mem_index].Role; line.unit = mems[mem_index].unitName; line.team = mems[mem_index].Team; line.memberUrl = 'https://membership.scouts.org.uk/#/membersearch/'+mems[mem_index].id+"/viewmember"; } line.name = mems[mem_index].fullname; // var nameid = mems.find((element) => element.id == roles.find((element) => element.Id==role_detail[i].roleApprovalMemberShipId).ContactId).id; var nameid = mems[mem_index].id; // line.memberURL = 'https://membership.scouts.org.uk/#/membersearch/'+mems.find((element) => element.id == roles.find((element) => element.Id==role_detail[i].roleApprovalMemberShipId).ContactId).id+"/viewmember"; // var memhtml = '<a href="https://membership.scouts.org.uk/#/membersearch/'+nameid+'/viewmember" target="_blank">'+fullname+'</a>'; // if (document.getElementById("gmnumber").checked) { line.number = mems[mem_index].membershipnumber; // }; if (role_index>=0) { line.status = role_detail[role_index].rolestatus; var sdate = new Date(roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).StartDate); line.start = sdate.toLocaleDateString('en-GB').toString(); var days = Math.round((new Date() - sdate) / (1000 * 60 * 60 * 24)); line.days = days; for (var j = 0; j < act.length; j++) { if (role_detail[role_index].actions.find((element)=>element.typeid==act[j])) { var state= 0x274C; var value = role_detail[role_index].actions.find((element)=>element.typeid==act[j]).status; if ((value=="Satisfactory")||(value=="Completed")||(value=="Held - Satisfactory")){state= 0x2705;} line[titlefieldnames[j+8]] = String.fromCodePoint(state); } else { // Deal with bug in API that means this can be missing..... if(j==3) { state= 0x274C; line[titlefieldnames[j+8]] = String.fromCodePoint(state); } else { line[titlefieldnames[j+8]] = ""; } } } } else { } // Learning if (document.getElementById("gmlearning").checked) { for ( j = 0; j < learn.length; j++) { state= 0x274C; // Red Cross 10060 var lr = mem_learning.find((element) => element.id == mems[mem_index].id); if (lr.learn.find((object)=>object.title==learn[j])){ state= 0x2705; // Green Tick 9989 } // Check Expiry var has_expiry = false; if (lr.learn.find((object)=>object.title==learn[j])){ if (lr.learn.find( (object) => object.title == learn[j]).expiryDate !=null) { sdate = new Date(lr.learn.find((object)=>object.title==learn[j]).expiryDate); days = Math.round((sdate - new Date()) / (1000 * 60 * 60 * 24)); has_expiry = true; if (days<=90) {state = 0x26A1; } // Flash 9889 if (days<0) {state = 0x274C;} // Red Cross 10060 } else {days=0;sdate = new Date("1977-01-01T00:00:01Z") ;} } else {days=0;sdate = new Date("1977-01-01T00:00:01Z") ;} if (role_index>=0) { var role_find = {}; role_find = roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId); if (j==7) { // Trustee // if ((!roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).RoleName.includes('Lead Volunteer'))&&(roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).RoleName!='Trustee')) { if (!is_trustee(role_find.RoleName)) { if(state==0x2705) {state=0x2714;} // Black Tick else { state = 0x0020; } } } if (j==8) { // Team Lead is_teamleader(rolename,unit_type,ParentTeamId,team_name) // if ((roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).RoleName.includes('Lead Volunteer'))||(roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).RoleName=='Team Leader')&&((roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).UnitType!='Group Section')&&(roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).UnitType!='District Section'))) { if (is_teamleader(role_find.RoleName,role_find.UnitType,role_find.ParentTeamId,role_find.Team)) { } else {if(state==0x2705) { state=0x2714;} else { state = 0x0020; }} } if (j==6) { // programme - only section roles // if ((roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).UnitType!='Group Section')&&(roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).UnitType!='District Section')) { if (!is_section(role_find.UnitType) ) if(state==0x2705) { state=0x2714;} else { state = 0x0020; } } if (j==5) { if ((!has_expiry)&&(state== 0x2705)) { state= 0x274C; } // Set to Expired.... // First Response // if ((roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).UnitType=='Group Section')||(roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).UnitType=='District Section')||(roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).RoleName=='Group Lead Volunteer')||((roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).RoleName=='Team Leader'))&&(roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).Team=='14-24 Team')) { if (is_firstresponse(role_find.UnitType,role_find.RoleName,role_find.Team)) { } else { if((!has_expiry)&&(state==0x274C)) {state=0x0020;} if(state==0x2705) { // Green state=0x2714;} // Black Tick else if (state==0x26A1) {} // Flash else if (state==0x274C) {state=0x2716;} // Cross else { state = 0x0020; } } } // Check for those not needing training // var rn = roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).RoleName; // if ((rn=='Non Member - Needs disclosure')||(rn=='President')||(rn=='Vice President')||(rn=='Holding')||(rn=='Retired Member')) { if (!needs_training(role_find.RoleName)) { if ((state == 0x26A1)||(state == 0x2705)||(state == 0x2714)) { state=0x2714;} // Black Tick else if (state==0x2716) {} // Black Cross else { state = 0x0020; } } } else { if ((j==7)&&(mems[mem_index].Role!=null)) { // Trustee if (!is_trustee(mems[mem_index].Role)) { // if ((!mems[mem_index].Role.includes('Lead Volunteer'))&&(mems[mem_index].RoleName!='Trustee')) { if(state==0x2705) { state=0x2714;} else { state = 0x0020; } } } if ((j==8)&&(mems[mem_index].Role!=null)) { // Team Lead if (is_teamleader(mems[mem_index].Role,mems[mem_index].unittype,null,mems[mem_index].Team)) { // if ((mems[mem_index].Role.includes('Lead Volunteer'))||(mems[mem_index].Role=='Team Leader')&&((mems[mem_index].unittype!='Group Section')&&(mems[mem_index].unittype!='District Section'))) { } else {if(state==0x2705) { state=0x2714;} else { state = 0x0020; }} } if (j==6) { // programme - only section roles if (!is_section(mems[mem_index].unittype) ){ // if ((mems[mem_index].unittype!='Group Section')&&(mems[mem_index].unittype!='District Section')) { if(state==0x2705) { state=0x2714;} else { state = 0x0020; } } } if ((j==5)&&(mems[mem_index].Role!=null)) { // First Response // if ((mems[mem_index].unittype=='Group Section')||(mems[mem_index].unittype=='District Section')||(mems[mem_index].Role=='Group Lead Volunteer')||((mems[mem_index].Role=='Team Leader'))&&(mems[mem_index].Team=='14-24 Team')) { if (is_firstresponse(mems[mem_index].unittype,mems[mem_index].Role,mems[mem_index].Team)) { } else { if(state==0x2705) { // Green state=0x2714;} // Black Tick else if (state==0x26A1) {} // Flash else if (state==0x274C) {state=0x1F7A6;} // Cross else { state = 0x0020; } } } // Check for those not needing training var rn = mems[mem_index].Role; if (rn!=null) { if (!needs_training(mems[mem_index].Role)) { if ((state == 0x26A1)||(state == 0x2705)||(state == 0x2714)) { state=0x2714;} else if (state==0x1F7A6) {} else { state = 0x0020; } } } } line[learnfieldnames[j]] = String.fromCodePoint(state); var blankdate = new Date("1977-01-01T00:00:01Z"); if (((j==3)||(j==4)||(j==5))) { if (lr.learn.find( (object) => object.title == learn[j])) { // if (sdate.getTime()!= blankdate.getTime()) { line[learnfieldnames[j]+'_expiry'] = sdate.toLocaleDateString('en-GB'); } else { line[learnfieldnames[j]+'_expiry'] = ""; } } else { line[learnfieldnames[j]+'_expiry'] = ""; } if (((j==3)||(j==4)||(j==5))) { if (!document.getElementById("gmwelcome").checked) { // if ((j!=5)||(((roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).UnitType=='Group Section')||(roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).UnitType=='District Section')||(roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).RoleName=='Group Lead Volunteer')||((roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).RoleName=='Team Leader'))&&(roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).Team=='14-24 Team'))&&j==5)) { // if (sdate!= new Date("1000-01-01T00:00:01Z")) { if (has_expiry) { line[learnfieldnames[j]+'_expirydays'] = days; } else { line[learnfieldnames[j]+'_expirydays'] = ""} // } } else {if (sdate!= new Date("1000-01-01T00:00:01Z")) { line[learnfieldnames[j]+'_expirydays'] = days; }} } } } if (document.getElementById("gmdbs").checked) { if (role_index>=0) { rn = roles.find((element) => element.Id==role_detail[role_index].roleApprovalMemberShipId).RoleName; } else { rn=mems[mem_index].Role;} if (!needs_dbs(rn)) { // No DBS Needed line.dbs_expiry = ""; line.dbs_expirydays = ""; line.dbsstatus = ""; line.dbs =" "; } else { var mindex = dbs_detail.findIndex((element)=> element.id == mems[mem_index].id) if (mindex>=0) { var time = new Date("1000-01-01T00:00:01Z") ; var timel = new Date("1000-01-01T00:00:01Z") ; var dbs_status = ""; if (dbs_detail[mindex].feed.entry != undefined) { if ( dbs_detail[mindex].feed.entry.length != undefined ) { for(var dbsloop=0;dbsloop<dbs_detail[mindex].feed.entry.length;dbsloop++) { sdate = new Date(dbs_detail[mindex].feed.entry[dbsloop].content.m_properties.d_ExpiryDate); if (sdate>time) { time = sdate;} sdate = new Date(dbs_detail[mindex].feed.entry[dbsloop].content.m_properties.d_IssuedDate); if (sdate>timel) { timel = sdate;dbs_status=dbs_detail[mindex].feed.entry[dbsloop].content.m_properties.d_Status; if (dbs_status!="Disclosure issued"){dbs_status+=" "+timel.toLocaleDateString('en-GB')}} } } if (dbs_detail[mindex].feed.entry.length == undefined) { // Single DBS sdate = new Date(dbs_detail[mindex].feed.entry.content.m_properties.d_ExpiryDate); if (sdate>time) { time = sdate;} sdate = new Date(dbs_detail[mindex].feed.entry.content.m_properties.d_DateModified); dbs_status=dbs_detail[mindex].feed.entry.content.m_properties.d_Status; if (dbs_status!="Disclosure issued"){dbs_status+=" "+sdate.toLocaleDateString('en-GB')} } } line.dbs = ""; var dbsdatedisp = time.toLocaleDateString('en-GB'); if (time<new Date()) {dbsdatedisp=String.fromCodePoint(0x274C)}; var expdays = Math.round((time-new Date()) / (1000 * 60 * 60 * 24)); if ((expdays<=90)&&(expdays>0)) { // dbsdatedisp+=String.fromCodePoint(0x26A1); line.dbs = String.fromCodePoint(0x26A1); } line.dbs_expiry =dbsdatedisp; line.dbsstatus = ""; if (expdays<0) { line.dbs = String.fromCodePoint(0x274C); }; if (expdays>90) { line.dbs = String.fromCodePoint(0x2705); }; line.dbsstatus = dbs_status; line.dbs_expirydays = expdays; } else { line.dbsexpiry = String.fromCodePoint(0x274C); line.dbs = String.fromCodePoint(0x274C); line.dbsexpirydays = ""; line.dbsstatus= ""; } } } return line; } function report_filter() { if (!document.getElementById("gmnumber").checked) { tabletabulator.hideColumn("number") } else { tabletabulator.showColumn("number") } if (!document.getElementById("gmdates").checked) { tabletabulator.hideColumn("safeguarding_expiry");tabletabulator.hideColumn("firstresponse_expiry");tabletabulator.hideColumn("safety_expiry") } else { tabletabulator.showColumn("safeguarding_expiry");tabletabulator.showColumn("firstresponse_expiry");tabletabulator.showColumn("safety_expiry") } if (!document.getElementById("gmdays").checked) { tabletabulator.hideColumn("safeguarding_expirydays");tabletabulator.hideColumn("firstresponse_expirydays");tabletabulator.hideColumn("safety_expirydays") } else { tabletabulator.showColumn("safeguarding_expirydays");tabletabulator.showColumn("firstresponse_expirydays");tabletabulator.showColumn("safety_expirydays") } if (!document.getElementById("gmdbsip").checked) { tabletabulator.hideColumn("dbsstatus") } else { tabletabulator.showColumn("dbsstatus") } var titlefieldnames = ['disclosure','gdpr','declaration','profile','references','ce','welcome','learning','trustee']; if (document.getElementById("gmwelcome").checked) { for(var i=0; i<titlefieldnames.length;i++) { tabletabulator.hideColumn(titlefieldnames[i]) } } else { for( i=0; i<titlefieldnames.length;i++) { tabletabulator.showColumn(titlefieldnames[i]) } } var learnfieldnames = ['inclusion','datap','who','safeguarding','safety','firstresponse','programme','trustee2','leading']; if (!document.getElementById("gmlearning").checked) { for(i=0; i<learnfieldnames.length;i++) { tabletabulator.hideColumn(learnfieldnames[i]) if ((i>=3)&&(i<=5)) { tabletabulator.hideColumn(learnfieldnames[i]+"_expiry") tabletabulator.hideColumn(learnfieldnames[i]+"_expirydays") } } } else { for( i=0; i<learnfieldnames.length;i++) { tabletabulator.showColumn(learnfieldnames[i]) if ((i>=3)&&(i<=5)) { tabletabulator.showColumn(learnfieldnames[i]+"_expiry") tabletabulator.showColumn(learnfieldnames[i]+"_expirydays") } } } var dbsfieldnames = ['dbs','dbs_expiry','dbs_expirydays','dbsstatus']; if (!document.getElementById("gmdbs").checked) { for(i=0; i<dbsfieldnames.length;i++) { tabletabulator.hideColumn(dbsfieldnames[i]) } } else { for(i=0; i<dbsfieldnames.length;i++) { tabletabulator.showColumn(dbsfieldnames[i]) } } if (!document.getElementById("gmdates").checked) { tabletabulator.hideColumn("safeguarding_expiry");tabletabulator.hideColumn("firstresponse_expiry");tabletabulator.hideColumn("safety_expiry") } else { tabletabulator.showColumn("safeguarding_expiry");tabletabulator.showColumn("firstresponse_expiry");tabletabulator.showColumn("safety_expiry") } if (!document.getElementById("gmdays").checked) { tabletabulator.hideColumn("safeguarding_expirydays");tabletabulator.hideColumn("firstresponse_expirydays");tabletabulator.hideColumn("safety_expirydays") } else { tabletabulator.showColumn("safeguarding_expirydays");tabletabulator.showColumn("firstresponse_expirydays");tabletabulator.showColumn("safety_expirydays") } if (!document.getElementById("gmdbsip").checked) { tabletabulator.hideColumn("dbsstatus") } else { tabletabulator.showColumn("dbsstatus") } tabletabulator.setFilter([{field : "name",type: "like", value: document.getElementById("gmpersonname").value}, {field: "team", type: "like", value: document.getElementById("gmteamname").value}]); tabletabulator.redraw(true); } function report_filter2() { var expirytext = "Expiry"; var expirytextdays = "Expiry Days"; var act = ['managerDisclosureCheck','dataProtectionTrainingComplete','signDeclaration','updateMemberProfile','referenceRequest','safeguardconfidentialEnquiryCheck','managerWelcomeConversation','coreLearning','managerTrusteeCheck']; var title = ['Role','Unit','Team','Name','Status','Start Date','Days','Disclosure','GDPR','Declaration','Profile','References','CE Check','Welcome','Learning','Trustee']; var learn = ['Creating Inclusion','Data Protection in Scouts','Who We Are and What We Do','Safeguarding','Safety','First Response','Delivering a Great Programme','Being a Trustee in Scouts','Leading Scout Volunteers']; $("#gmState")[0].innerText = "Data Collection Completed"; var myTableDiv = document.getElementById("gmTable"); var table = document.createElement('TABLE'); table.border = '1'; table.id = "GMourreport"; var tableBody = document.createElement('TBODY'); table.appendChild(tableBody); var tr = document.createElement('TR'); tableBody.appendChild(tr); report_headers(tableBody); if (!(document.getElementById("gmwelcome").checked)) { for (i = 0; i < role_detail.length; i++) { var displine=true; if (document.getElementById("gmmissing").checked) { var any_missing = false; for (var j = 0; j < act.length; j++) { if (role_detail[i].actions.find((element)=>element.typeid==act[j])) { var value = role_detail[i].actions.find((element)=>element.typeid==act[j]).status; if ((value!="Satisfactory")&&(value!="Completed")&&(value!="Held - Satisfactory")){ any_missing=true;} } } if (any_missing==false) {displine=false} } // if (document.getElementById("gmteamonly").checked) { var filter = document.getElementById("gmunitname").value.replaceAll("%", "*"); let w = filter.replace(/[.+^${}()|[\]\\]/g, '\\$&'); // regexp escape const re = new RegExp(`^${w.replace(/\*/g,'.*').replace(/\?/g,'.')}$`,'i'); if(!re.test(roles.find((element) => element.Id==role_detail[i].roleApprovalMemberShipId).UnitId)){displine=false} } if (mems.find((element) => element.id == roles.find((element) => element.Id==role_detail[i].roleApprovalMemberShipId).ContactId)!=undefined){ var fullname = mems.find((element) => element.id == roles.find((element) => element.Id==role_detail[i].roleApprovalMemberShipId).ContactId).fullname; if (document.getElementById("gmpersonname").value!="") { if(!fullname.toLowerCase().includes(document.getElementById("gmpersonname").value.toLowerCase())){displine=false} } } else {displine=false;} if (document.getElementById("gmteamname").value!="") { if (!roles.find((element) => element.Id==role_detail[i].roleApprovalMemberShipId).Team.toLowerCase().includes(document.getElementById("gmteamname").value.toLowerCase())){displine=false} } if (document.getElementById("gmhelper").checked) { var rolename = roles.find((element) => element.Id==role_detail[i].roleApprovalMemberShipId).RoleName; if (rolename.includes("Non Member - Needs disclosure")) {displine=false;} if (rolename.includes("Holding")) {displine=false;} } if (displine) { output_report_line(tableBody,i,mems.findIndex( (element) => element.id == roles.find( (element) => element.Id == role_detail[i].roleApprovalMemberShipId).ContactId)); } } } else { for (var i = 0; i < mems.length; i++) { displine = true; fullname = mems[i].fullname; if (document.getElementById("gmpersonname").value!="") { if(!fullname.toLowerCase().includes(document.getElementById("gmpersonname").value.toLowerCase())){displine=false} } if (mems[i].Role==null) { displine=false} if (displine) { output_report_line(tableBody,-1,i); } } } table.style.fontSize = "10pt"; document.getElementById("gmTable").innerHTML=""; myTableDiv.appendChild(table); //var tf = new TableFilter('GMourreport',filtersConfig ); //t } // var level_de = "e5b6ecb0-0360-9cde-f269-7660a2afb0fb"; var level_de = "89d2f00e-6d57-8032-be02-47393fcf0556"; var learning_json = {}; var welcome = {}; function get_dedata6() { console.log(mems); console.log(role_detail); console.log(roles); console.log(learning_json); console.log(welcome); } function get_dedata5() { var report = { WhereClause: null, aggregateField: "MembershipNumber", aggregateFunction: "COUNT", distinct: true, emailId: null, isDashboardQuery: false, isHierarchy: true, orderby: "", pageNo: 1, pageSize: 50000, query: "", selectFields: ["PreferredName","LastName","MembershipNumber","Role","CompletedDate","OwnerName","ActionTypeName","ActionType","OnBoardingActionStatusId","Status","ActionListId","LocationDistrict","OnBoardingActionStatus","ActionList","County","CategoryKey","Team","StatusId","LocationGroup"], table: "InProgressActionDashboardView", teamId: "", unitId: level_de, // unitId:"89d2f00e-6d57-8032-be02-47393fcf0556", // treeVal:{"type":"group","id":"cca1f1b8-25e9-4b2f-a0f4-4f141d5ab86f"}, userId: null, viewQueryAction: "data" } console.log("role"); console.log(roles); for (var i=0;i<role_detail.data.length;i++) { // We could play with team name here as well - we know the ID => Name for the standard teams var r = roles.data.find(e=> e["First name"]+" "+e["Surname"]==role_detail.data[i].FullName&e["Role"]==role_detail.data[i].Role&&e["Unit Name"]==role_detail.data[i].UnitName); if (r === undefined) { r = roles.data.find(e=> e["First name"]+" "+e["Surname"]==role_detail.data[i].FullName); } console.log(role_detail.data[i].FullName); role_detail.data[i].membershipid = r["Membership Number"]; role_detail.data[i].teamname = r["Team"]; console.log(r["Membership Number"]+" "+r["First name"]+" "+r["Surname"]+" "+role_detail.data[i].FullName); } //152688 Welcome Convo //116408 Safeguarding //116407 safety //120015 Trustee //116401 Trustee //116406 Who we are //116405 Leading Scout Volunteers 10613435 (WB) // 116402 Inclusion 10613429 WB // 119993 GDPR // 149144 First Response 152687 // 153014 Suspension Lead GM_xmlhttpRequest({ method: "GET", context: 1, url: "https://learn.scouts.org.uk/ilp/restapi/lms/dashboards/8/panels/121/results/table?exportAggregations=false&skill=152688,116405,10613435,116408,116407,120015,116401,116406,116402,10613429,119993,149144,152687&assessmentType=0", // data: datapass, headers: { "Content-Type": "application/json", "Authorization": "Bearer " + JSON.parse(localStorage.getItem("authInfo")).idToken, "Accept": "application/json, text/plain, */*" }, onload: function(response) { // console.log(response);console.log(count); console.log(response); // console.log(xmlToJson(response.responseText)); console.log(JSON.parse(response.responseText)); learning_json = JSON.parse(response.responseText); GM_xmlhttpRequest({ method: "POST", url: "https://tsa-memportal-prod-fun01.azurewebsites.net/api/DataExplorer/GetResultsAsync", data: JSON.stringify(report), headers: { "Content-Type": "application/json;odata=minimalmetadata", "Authorization": "Bearer " + JSON.parse(localStorage.getItem("authInfo")).idToken, "Accept": "application/json, text/plain, */*", "Type": "table" }, onload: function(response) { // console.log(response);console.log(count); console.log("report"); // console.log(JSON.parse(response.responseText)); welcome = JSON.parse(response.responseText); get_dedata6() }, onerror: function(response) { GM_log("ON Error");GM_log(JSON.stringify(response))}, onabort: function(response) { GM_log("ON Abort");GM_log(JSON.stringify(response))} }); }, onerror: function(response) { GM_log("ON Error");GM_log(JSON.stringify(response))}, onabort: function(response) { GM_log("ON Abort");GM_log(JSON.stringify(response))} }); } function get_dedata4() { console.log("mems"); console.log(mems); console.log("role_detail"); console.log(role_detail); var report = { WhereClause: null, aggregateField: "*", aggregateFunction: "COUNT", distinct: true, emailId: null, isDashboardQuery: false, isHierarchy: true, orderby: "", pageNo: 1, pageSize: 50000, query: "", selectContactFields: null, selectFields: ["FirstName","LastName","MembershipNumber","Role","Team","CountyName","DistrictName","GroupName","Telephone"], table: "PreloadedAwardsDashboardView", teamId: "", unitId: level_de, // unitId:"89d2f00e-6d57-8032-be02-47393fcf0556", // treeVal:{"type":"group","id":"cca1f1b8-25e9-4b2f-a0f4-4f141d5ab86f"}, userId: null, viewQueryAction: "data" } var report2 = { WhereClause: null, aggregateField: "*", aggregateFunction: "COUNT", distinct: true, emailId: null, isDashboardQuery: false, isHierarchy: true, orderby: "", pageNo: 1, pageSize: 5000, query: "", selectContactFields: null, selectFields: ["FirstName","LastName","MembershipNumber","EmailAddress","Telephone","DistrictName","County","Role","Team","unitName","Line2","PostalCode","Country","Town","GroupName","CountyName","Line1"], table: "PreloadedAwardsDashboardView", teamId: "", unitId: level_de, // unitId:"89d2f00e-6d57-8032-be02-47393fcf0556", // treeVal:{"type":"group","id":"cca1f1b8-25e9-4b2f-a0f4-4f141d5ab86f"}, userId: null, viewQueryAction: "data" } GM_xmlhttpRequest({ method: "POST", url: "https://tsa-memportal-prod-fun01.azurewebsites.net/api/DataExplorer/GetResultsAsync", data: JSON.stringify(report2), headers: { "Content-Type": "application/json;odata=minimalmetadata", "Authorization": "Bearer " + JSON.parse(localStorage.getItem("authInfo")).idToken, "Accept": "application/json, text/plain, */*", "Type": "table" }, onload: function(response) { // console.log(response);console.log(count); console.log("report"); // console.log(JSON.parse(response.responseText)); roles = JSON.parse(response.responseText); get_dedata5() }, onerror: function(response) { GM_log("ON Error");GM_log(JSON.stringify(response))}, onabort: function(response) { GM_log("ON Abort");GM_log(JSON.stringify(response))} }); } function get_dedata3() { var q = ""; for (var i=0;i<mems.length;i++) { q+="unitid='"+mems[i].id+"' "; if (i!=mems.length-1) { q+=" OR ";} } var report2 = { contactId: "", distinct: true, id: "", isHierarchy: true, isDashboardQuery: false, name: "", order: "asc", orderBy: "Lastname", pageNo: 1, pageSize: 5000, // query: `unitid='e5b6ecb0-0360-9cde-f269-7660a2afb0fb'`, query: q, // query: `unitid='89d2f00e-6d57-8032-be02-47393fcf0556'`, Runnymede selectFields: ["Id", "PreferredName", "FullName", "Firstname", "Lastname", "RoleStatusName", "Role", "unitid", "TeamId", "ParentTeamId", "UnitPrefix", "Unitname","ContactMembershipId", "UnitTypeId"], // "RoleStatusName", "Role" // ], //selectFields: ["Id"], table: "TeamMembersView" }; GM_xmlhttpRequest({ method: "POST", url: "https://tsa-memportal-prod-fun01.azurewebsites.net/api/DataExplorer/GetResultsAsync", data: JSON.stringify(report2), headers: { "Content-Type": "application/json;odata=minimalmetadata", "Authorization": "Bearer " + JSON.parse(localStorage.getItem("authInfo")).idToken, "Accept": "application/json, text/plain, */*", "Type": "table" }, onload: function(response) { // console.log(response);console.log(count); console.log("report2"); console.log(JSON.parse(response.responseText)); role_detail = JSON.parse(response.responseText); get_dedata4(); }, onerror: function(response) { GM_log("ON Error");GM_log(JSON.stringify(response))}, onabort: function(response) { GM_log("ON Abort");GM_log(JSON.stringify(response))} }); } function get_dedata2(oc) { // Get the Tree var max=50; var datapass = '{"pagesize":'+max+',"nexttoken":'+oc+',"filter":{"global" : "","globaland":false,"fieldand":true},"unitId":"'+level_de+'"}'; // console.log(datapass); if (debug) {GM_log("Counter for get_Sub Unit "+oc);} GM_xmlhttpRequest({ method: "POST", context: oc+1, url: "https://tsa-memportal-prod-fun01.azurewebsites.net/api/UnitListingAsync", data: datapass, headers: { "Content-Type": "application/json", "Authorization": "Bearer " + JSON.parse(localStorage.getItem("authInfo")).idToken, "Accept": "application/json, text/plain, */*" }, onload: function(response) { // console.log(response);console.log(count); if (debug) {GM_log("Counter Received "+response.context)} // console.log(JSON.parse(response.responseText).data[1]); var mem = null; try { mem=JSON.parse(response.responseText).data} catch {console.log("JSON Error "+response.responseText);} // mem =(JSON.parse(response.responseText).data); if (mem.length>0) { if (debug) { } } if ((mem.length==0)&&(debug)) { GM_log("GetData: We got an error collecting data for Sub mems page"+response.context); } if (mem.length!=0) { mems = mems.concat(mem); } $("#gmorgstatus")[0].innerHTML = mems.length+" Units read"; if (debug) {GM_log("Sub Units mems now has length "+mems.length);} if (debug) {GM_log("Sub Units mem now has length "+mem.length);} if (response.status!=200) {GM_log("HTTP error "+response.status); GM_log(JSON.stringify(response));} if ( mem.length ==50) {get_dedata2(oc+1); } else {missed = 0; get_dedata3()};}, onerror: function(response) { GM_log("ON Error");GM_log(JSON.stringify(response))}, onabort: function(response) { GM_log("ON Abort");GM_log(JSON.stringify(response))} }); } function get_data_de() { mems =[]; mems.push({id: level_de}); get_dedata2(0); } function get_data_deold() { var report = { WhereClause: null, aggregateField: "*", aggregateFunction: "COUNT", distinct: true, emailId: null, isDashboardQuery: false, isHierarchy: true, orderby: "", pageNo: 1, pageSize: 5000, query: "", selectContactFields: null, selectFields: ["FirstName","LastName","MembershipNumber","Role","Team","CountyName","DistrictName","GroupName","Telephone"], table: "PreloadedAwardsDashboardView", teamId: "", // unitId:"e5b6ecb0-0360-9cde-f269-7660a2afb0fb", unitId:"89d2f00e-6d57-8032-be02-47393fcf0556", // treeVal:{"type":"group","id":"cca1f1b8-25e9-4b2f-a0f4-4f141d5ab86f"}, userId: null, viewQueryAction: "data" } //e5b6ecb0-0360-9cde-f269-7660a2afb0fb var report2 = { contactId: "", distinct: true, id: "", isHierarchy: true, isDashboardQuery: false, name: "", order: "asc", orderBy: "Lastname", pageNo: 1, pageSize: 5000, query: `unitid='e5b6ecb0-0360-9cde-f269-7660a2afb0fb'`, // query: `unitid='89d2f00e-6d57-8032-be02-47393fcf0556'`, Runnymede selectFields: ["Id", "PreferredName", "FullName", "Firstname", "Lastname", "RoleStatusName", "Role", "unitid", "TeamId", "ParentTeamId", "UnitPrefix", "Unitname","ContactMembershipId", "UnitTypeId"], // "RoleStatusName", "Role" // ], //selectFields: ["Id"], table: "TeamMembersView" }; var report3 = { contactId: "", id: "", name: "", // query: "ContactId ='".concat(l, "' AND IsNANUnit = 0"), // query: `unitid='89d2f00e-6d57-8032-be02-47393fcf0556'`, query: `unitid='e5b6ecb0-0360-9cde-f269-7660a2afb0fb'`, table: "ContactUnitsView", order: "asc", orderBy: "Team", isHierarchy: true, selectFields: ["TeamId", "Team", "UnitName", "unitid", "ParentTeam", "ParentTeamId", "unitType", "unitTypeId", "AllowSubTeam", "unitPrefix"], distinct: !0, isDashboardQuery: !1 }; GM_xmlhttpRequest({ method: "POST", url: "https://tsa-memportal-prod-fun01.azurewebsites.net/api/DataExplorer/GetResultsAsync", data: JSON.stringify(report), headers: { "Content-Type": "application/json;odata=minimalmetadata", "Authorization": "Bearer " + JSON.parse(localStorage.getItem("authInfo")).idToken, "Accept": "application/json, text/plain, */*", "Type": "table" }, onload: function(response) { // console.log(response);console.log(count); console.log("report"); console.log(JSON.parse(response.responseText)); }, onerror: function(response) { GM_log("ON Error");GM_log(JSON.stringify(response))}, onabort: function(response) { GM_log("ON Abort");GM_log(JSON.stringify(response))} }); GM_xmlhttpRequest({ method: "POST", url: "https://tsa-memportal-prod-fun01.azurewebsites.net/api/DataExplorer/GetResultsAsync", data: JSON.stringify(report3), headers: { "Content-Type": "application/json;odata=minimalmetadata", "Authorization": "Bearer " + JSON.parse(localStorage.getItem("authInfo")).idToken, "Accept": "application/json, text/plain, */*", "Type": "table" }, onload: function(response) { // console.log(response);console.log(count); console.log("report3"); console.log(JSON.parse(response.responseText)); }, onerror: function(response) { GM_log("ON Error");GM_log(JSON.stringify(response))}, onabort: function(response) { GM_log("ON Abort");GM_log(JSON.stringify(response))} }); GM_xmlhttpRequest({ method: "POST", url: "https://tsa-memportal-prod-fun01.azurewebsites.net/api/DataExplorer/GetResultsAsync", data: JSON.stringify(report2), headers: { "Content-Type": "application/json;odata=minimalmetadata", "Authorization": "Bearer " + JSON.parse(localStorage.getItem("authInfo")).idToken, "Accept": "application/json, text/plain, */*", "Type": "table" }, onload: function(response) { // console.log(response);console.log(count); console.log("report2"); console.log(JSON.parse(response.responseText)); }, onerror: function(response) { GM_log("ON Error");GM_log(JSON.stringify(response))}, onabort: function(response) { GM_log("ON Abort");GM_log(JSON.stringify(response))} }); } function report_onclick() { // RUn Report // console.log("Report"); if (document.getElementById("gmdebug").checked) { debug = true; } var count = 1; mem=""; // $("#gmpopup").dialog ( {modal: true, height: 500, width: "100%"} ); mems = []; role_detail=[]; roles=[]; document.getElementById("gmTable").innerHTML="Table will appear here...."; // document.getElementById("gmUnit").innerHTML = "UKJDKJD"; var responsetext = ""; var datapass; mem_learning= []; learn = []; dbs_detail=[]; var tokexpDate = new Date( JSON.parse(localStorage.getItem("authInfo")).account.idTokenClaims.exp *1000); if(document.getElementById("gmexplorer").checked) { get_data_de(count); } else { get_data(count); } } function report_onclick2() { // Open Dialog console.log("Report"); var count = 1; mem=""; var h = $( window ).height(); $("#gmpopup").dialog ( {modal: true, height: (h*0.75), width: "100%"} ); mems = []; role_detail=[]; roles=[]; memsunique=[]; // document.getElementById("gmTable").innerHTML="Table will appear here...."; var responsetext = ""; var datapass; mem_learning= []; keepalive = window.setInterval(function () { if (window.location.href=='https://membership.scouts.org.uk/#/learning') { var ul = document.getElementById('menu-list-item-left-nav-homePageTile'); ul.click(); } else { ul = document.getElementById('menu-list-item-left-nav-learning'); ul.click(); } console.log("Keep Alive Active"); }, 25000); //5000 is 5 Seconds $('#gmpopup').on('dialogclose', function(event) { // alert('closed'); clearInterval(keepalive); console.log("Keep Alive Cancelled"); }); datapass = '{"pagesize":50,"sort":{"field":"unitName","type":"asc"},"contactId":"'+JSON.parse(localStorage.getItem("authInfo")).idTokenClaims.extension_ContactId+'"}'; GM_xmlhttpRequest({ method: "POST", url: "https://tsa-memportal-prod-fun01.azurewebsites.net/api/MyUnitsAsync", data: datapass, headers: { "Content-Type": "application/json", "Authorization": "Bearer " + JSON.parse(localStorage.getItem("authInfo")).idToken, "Accept": "application/json, text/plain, */*" }, onload: function(response) { // console.log(response);console.log(count); var myUnits = JSON.parse(response.responseText); for (var i=0;i<myUnits.data.length;i++) { document.getElementById("myUnits").innerHTML+= '<option value="'+myUnits.data[i].unitName+'">'; } }, onerror: function(response) { GM_log("ON Error");GM_log(JSON.stringify(response))}, onabort: function(response) { GM_log("ON Abort");GM_log(JSON.stringify(response))} }); } function report_print() { // var prtContent = document.getElementById("GMourreport"); // var prtContent = (tabletabulator.getHtml()); var WinPrint = window.open('', '', 'left=0,top=0,width=800,height=900,toolbar=0,scrollbars=0,status=0'); WinPrint.document.body.innerHTML = tabletabulator.getHtml(); WinPrint.document.head.innerHTML += '<style> th.blue-background { writing-mode: vertical-lr; background-color: lightcyan; } \ th.yellow-background { writing-mode: vertical-lr; background-color: lightgoldenrodyellow; } th.orange-background { writing-mode: vertical-lr; background-color: salmon; } \ table.tabulator-print-table, tr, th, td { border: solid;font-family: sans-serif;}</style>'; // WinPrint.document.close(); WinPrint.focus(); WinPrint.print(); WinPrint.close(); } function savecolors() { GM_setValue("colors", JSON.stringify(colors)); GM_setValue("colorsT", JSON.stringify(colorsT)); } function resetcolors() { colors = defcolors; colorsT = defcolorsT; for(cloop=0; cloop<colors.length;cloop++){ document.getElementById("cpreview"+cloop).style.backgroundColor = colors[cloop]; document.getElementById("cpreview"+cloop).style.color = colorsT[cloop]; document.getElementById("back"+cloop).value = colors[cloop]; document.getElementById("fore"+cloop).value = colorsT[cloop]; } } function updateFirstC(event) { console.log("Update First"); if (event.target.name.includes("back")) { document.getElementById("cpreview"+event.target.name[4]).style.backgroundColor = event.target.value; colors[event.target.name[4]] = event.target.value; } if (event.target.name.includes("fore")) { document.getElementById("cpreview"+event.target.name[4]).style.color = event.target.value; colorsT[event.target.name[4]] = event.target.value; } console.log(event); } function watchColorPicker(event) { console.log("Watch CP"); console.log(event); } var unitsearchvalues = ["866060008","866060006","866060005","866060004","866060007","866060003","866060002","866060001","866060000"]; var unitsearchtypes = ["Organisation","Country","Region","County","County Section","District","District Section","Group","Group Section"]; var unitcount = []; var orglevel = 0; var teams = []; var subteams = []; var maxsubteam = 0; function get_orgdata(oc,ol) { // Find the root var max = 50; teams = []; subteams = []; maxsubteam = 0; un = document.getElementById("gmunitnameo").value; var unt= unitsearchvalues[ol]; if (debug) {GM_log("Unit Request for "+un+" Count "+oc+"/"+ol);} if (debug) { GM_log("Unit Request for "+un+" :"+ JSON.parse(localStorage.getItem("authInfo")).idToken.substring(1,50)); var tokexpDate = new Date( JSON.parse(localStorage.getItem("authInfo")).account.idTokenClaims.exp *1000); } $("#gmorgstatus")[0].innerHTML = "Checking for "+unitsearchtypes[ol]+" "+un; var datapass = '{"pagesize":'+max+',"nexttoken":'+oc+',"filter":{"global" : "","globaland":false,"fieldand":true,filterfields:[{ "field" : "'+unt+'", "value": "'+un+'"}]},"unitId":""}'; if (debug) {GM_log("Counter for get_data "+oc);} GM_xmlhttpRequest({ method: "POST", context: oc+1, url: "https://tsa-memportal-prod-fun01.azurewebsites.net/api/UnitListingAsync", data: datapass, headers: { "Content-Type": "application/json", "Authorization": "Bearer " + JSON.parse(localStorage.getItem("authInfo")).idToken, "Accept": "application/json, text/plain, */*" }, onload: function(response) { // console.log(response);console.log(count); if (debug) {GM_log("Counter Recieved "+response.context)} // console.log(JSON.parse(response.responseText).data[1]); var mem = null; try { mem=JSON.parse(response.responseText).data} catch {console.log("JSON Error "+response.responseText);} // mem =(JSON.parse(response.responseText).data); if (mem.length>0) { if (debug) { } } if ((mem.length==0)&&(debug)) { GM_log("GetData: We got an error collecting data for mems page"+response.context); } if (mem.length!=0) { mems = mems.concat(mem); } if (debug) {GM_log("mems now has length "+mems.length);} if (response.status!=200) {GM_log("HTTP error "+response.status); GM_log(JSON.stringify(response));} $("#gmorgstatus")[0].innerHTML = "Checking for "+unitsearchtypes[response.context]+" "+un; if ((ol<unitsearchvalues.length)&&( mems.length==0)) {get_orgdata(oc,ol+1); } else { var filter = document.getElementById("gmunitnameo").value.replaceAll("%", "*"); let w = filter.replace(/[.+^${}()|[\]\\]/g, '\\$&'); // regexp escape const re = new RegExp(`^${w.replace(/\*/g,'.*').replace(/\?/g,'.')}$`,'i'); mems = mems.filter( function(v) {return re.test(v.unitName)}); // if (debug) {GM_log("Re: Filter by for Unit only roles now has length "+roles.length);} get_orgdata2(0)}; }, onerror: function(response) { GM_log("ON Error");GM_log(JSON.stringify(response))}, onabort: function(response) { GM_log("ON Abort");GM_log(JSON.stringify(response))} }); } var tealgrad = new go.Brush('Linear', { 0: 'rgb(32, 178, 170)', 1: 'rgb(0,128,128)' }); var greengrad = new go.Brush('Linear', { 0: 'rgb(154, 205, 50)', 1: 'rgb(34, 139, 34)' }); var bluegrad = new go.Brush('Linear', { 0: 'rgb(135, 206, 235)', 1: 'rgb(0, 191, 255)' }); var redgrad = new go.Brush('Linear', { 0: 'rgb(220, 20, 60)', 1: 'rgb(255, 0, 0)' }); var browngrad = new go.Brush('Linear', { 0: 'rgb(218, 160, 109)', 1: 'rgb(149, 69, 53 )' }); var blackgrad = new go.Brush('Linear', { 0: 'rgb(0,0,0)', 1: 'rgb(0,0,0 )' }); var pinkgrad = new go.Brush('Linear', { 0: 'rgb(128,0,0)', 1: 'rgb(200,0,0 )' }); var greygrad = new go.Brush('Linear', { 0: 'rgb(128,128,128)', 1: 'rgb(200,200,200 )' }); var purplegrad = new go.Brush('Linear', { 0: 'rgb(138,43,226)', 1: 'rgb(147,112,219 )' }); function sectionBrushConverter(node) { if (node.unitType === "Group Section") { if (node.unitName.includes("Cub")) { return greengrad} if (node.unitName.includes("Pack")) { return greengrad} if (node.unitName.includes("Squirrel")) { return redgrad} if (node.unitName.includes("Drey")) { return redgrad} if (node.unitName.includes("Beaver")) { return bluegrad} if (node.unitName.includes("Colony")) { return bluegrad} return tealgrad; } if (node.unitType === "District Section") { return browngrad; } if (node.unitType === "Group") { return pinkgrad; } if (node.unitType === "District") { return blackgrad; } if (node.unitType === "Team") { return purplegrad; } if (node.unitType === "Sub Team") { return greygrad; } return "#44CCFF" // if (gender === "F") return pinkgrad; } var missed = 0; function get_orgdata2(oc) { // Get the Tree if (mems.length==0) { $("#gmorgstatus")[0].innerHTML = "No Units found";} var max=50; var datapass = '{"pagesize":'+max+',"nexttoken":'+oc+',"filter":{"global" : "","globaland":false,"fieldand":true},"unitId":"'+mems[0].id+'"}'; // console.log(datapass); if (debug) {GM_log("Counter for get_Sub Unit "+oc);} GM_xmlhttpRequest({ method: "POST", context: oc+1, url: "https://tsa-memportal-prod-fun01.azurewebsites.net/api/UnitListingAsync", data: datapass, headers: { "Content-Type": "application/json", "Authorization": "Bearer " + JSON.parse(localStorage.getItem("authInfo")).idToken, "Accept": "application/json, text/plain, */*" }, onload: function(response) { // console.log(response);console.log(count); if (debug) {GM_log("Counter Received "+response.context)} // console.log(JSON.parse(response.responseText).data[1]); var mem = null; try { mem=JSON.parse(response.responseText).data} catch {console.log("JSON Error "+response.responseText);} // mem =(JSON.parse(response.responseText).data); if (mem.length>0) { if (debug) { } } if ((mem.length==0)&&(debug)) { GM_log("GetData: We got an error collecting data for Sub mems page"+response.context); } if (mem.length!=0) { mems = mems.concat(mem); } $("#gmorgstatus")[0].innerHTML = mems.length+" Units read"; if (debug) {GM_log("Sub Units mems now has length "+mems.length);} if (debug) {GM_log("Sub Units mem now has length "+mem.length);} if (response.status!=200) {GM_log("HTTP error "+response.status); GM_log(JSON.stringify(response));} if ( mem.length ==50) {get_orgdata2(oc+1); } else {missed = 0; get_orgdata5()};}, onerror: function(response) { GM_log("ON Error");GM_log(JSON.stringify(response))}, onabort: function(response) { GM_log("ON Abort");GM_log(JSON.stringify(response))} }); } function get_orgdata5() { // Get Teams var minlevel = $("#gmorglevel").val(); mems = mems.filter(function(n) {return n.UnitLevel>=minlevel}); if (mems.length==0) { $("#gmorgstatus")[0].innerHTML = "No Units found";} // $("#gmorgstatus")[0].innerHTML = response.context+" sub teams read"; var exclude_section_teams = document.getElementById("gmnosteams").checked; var exclude_all_teams = document.getElementById("gmnoteams").checked; if (!exclude_all_teams) { for(var i=0;i<mems.length;i++) { //(b.unitType === "Group Section")&&(a.unitType === "Group Section") if ((exclude_section_teams)&&((mems[i].unitType === "Group Section")||(mems[i].unitType === "District Section"))) { missed+=1; } else { var datapass = '{"unitId":"'+mems[i].id+'","type":"team"}'; GM_xmlhttpRequest({ method: "POST", context: i+1, url: "https://tsa-memportal-prod-fun01.azurewebsites.net/api/UnitTeamsAndRolesListingAsync", data: datapass, headers: { "Content-Type": "application/json", "Authorization": "Bearer " + JSON.parse(localStorage.getItem("authInfo")).idToken, "Accept": "application/json, text/plain, */*" }, onload: function(response) { // console.log(response);console.log(count); if (debug) {GM_log("Counter Recieved "+response.context)} // console.log(JSON.parse(response.responseText).data[1]); var mem = null; try { mem=JSON.parse(response.responseText)} catch {console.log("JSON Error "+response.responseText);} // mem =(JSON.parse(response.responseText).data); $("#gmorgstatus")[0].innerHTML = response.context+" teams read"; teams.push(mem); //console.log(mem); // $("#gmorgstatus")[0].innerHTML = mems.length+" Units read"; if (response.status!=200) {GM_log("HTTP error "+response.status); GM_log(JSON.stringify(response));} $("#gmState")[0].innerText = "Reading Sub Units for "+un+" ("+response.context+") "+"Total read "+mems.length; if ( teams.length+missed== mems.length) {subteams = []; maxsubteam=0; get_orgdata6();}}, onerror: function(response) { GM_log("ON Error");GM_log(JSON.stringify(response))}, onabort: function(response) { GM_log("ON Abort");GM_log(JSON.stringify(response))} }); } }} else {get_orgdata3(false)} } function get_orgdata6() { for(var i=0;i<teams.length;i++) { for (var j=0;j<teams[i].teams.length;j++) { if (teams[i].teams[j].allowSubTeam){ maxsubteam +=1; var datapass = '{"unitId":"'+teams[i].unitId+'","type":"subteam","teamId" :"'+teams[i].teams[j].teamId+'"}'; GM_xmlhttpRequest({ method: "POST", context: maxsubteam, url: "https://tsa-memportal-prod-fun01.azurewebsites.net/api/UnitTeamsAndRolesListingAsync", data: datapass, headers: { "Content-Type": "application/json", "Authorization": "Bearer " + JSON.parse(localStorage.getItem("authInfo")).idToken, "Accept": "application/json, text/plain, */*" }, onload: function(response) { // console.log(response);console.log(count); if (debug) {GM_log("Counter Recieved "+response.context)} // console.log(JSON.parse(response.responseText).data[1]); var mem = null; try { mem=JSON.parse(response.responseText)} catch {console.log("JSON Error "+response.responseText);} // mem =(JSON.parse(response.responseText).data); subteams.push(mem); //console.log(mem); // $("#gmorgstatus")[0].innerHTML = mems.length+" Units read"; $("#gmorgstatus")[0].innerHTML = response.context+" sub teams read"; if (response.status!=200) {GM_log("HTTP error "+response.status); GM_log(JSON.stringify(response));} $("#gmState")[0].innerText = "Reading Sub Units for "+un+" ("+response.context+") "+"Total read "+mems.length; if ( response.context == maxsubteam) {get_orgdata3(false);}}, onerror: function(response) { GM_log("ON Error");GM_log(JSON.stringify(response))}, onabort: function(response) { GM_log("ON Abort");GM_log(JSON.stringify(response))} }); } } } } function section_sort(a,b) { if (a.UnitLevel!=b.UnitLevel) { if (a.UnitLevel<b.UnitLevel) {return -1} if (a.UnitLevel==b.UnitLevel) {return 0} if (a.UnitLevel>b.UnitLevel) {return 1} } if ((a.UnitLevel==b.UnitLevel)&&(a.UnitLevel!=1)) { if (a.unitName<b.unitName) {return -1} if (a.unitName==b.unitName) {return 0} if (a.unitName>b.unitName) {return 1} } if ((b.unitType === "Group Section")&&(a.unitType === "Group Section")) { var asection = 4; if (a.unitName.includes("Cub")) {asection = 3;} if (a.unitName.includes("Pack")) { asection = 3;} if (a.unitName.includes("Drey")) { asection = 1;} if (a.unitName.includes("Squirrel")) { asection = 1;} if (a.unitName.includes("Beaver")) {asection = 2;} if (a.unitName.includes("Colony")) { asection = 2;} var bsection = 4; if (b.unitName.includes("Cub")) {bsection = 3;} if (b.unitName.includes("Pack")) { bsection = 3;} if (b.unitName.includes("Drey")) { bsection = 1;} if (b.unitName.includes("Squirrel")) { bsection = 1;} if (b.unitName.includes("Beaver")) {bsection = 2;} if (b.unitName.includes("Colony")) { bsection = 2;} if (asection<bsection) {return -1} if (asection==bsection) {return 0} if (asection>bsection) {return 1} } return 0 } function section_sort2(a,b) { var c= section_sort(a,b) ; // console.log(a.unitType +" "+a.unitName+" "+b.unitType +" "+b.unitName+" "+c); return c; } function get_orgdata3(justdisplay) { if (!justdisplay) { // Add in Teams for (var i=0; i<teams.length;i++) { for (var j=0; j<teams[i].teams.length; j++) { var mem = new Object; mem.parentUnitId = teams[i].unitId; mem.id = teams[i].teams[j].teamId+teams[i].unitId; mem.unitName = teams[i].teams[j].teamName; mem.UnitLevel = 98; mem.unitType = "Team"; mem.teamunitId = teams[i].unitId; mems.push(mem); } } for (i=0;i<subteams.length; i++) { if (subteams[i].teams!=null) { for ( j=0; j<subteams[i].teams.length; j++) { mem = new Object; mem.parentUnitId = subteams[i].teams[j].parentTeamId+ subteams[i].unitId; mem.id = subteams[i].teams[j].teamId; mem.unitName = subteams[i].teams[j].teamName; mem.UnitLevel = 99; mem.unitType = "Sub Team"; mem.teamunitId = subteams[i].unitId; mems.push(mem); }}} mems.sort(section_sort2); console.log(mems); console.log("teams"); console.log(teams); console.log("Subteams"); console.log(subteams); } myDiagram.nodeTemplate = new go.Node("Horizontal", { background: "#44CCFF" }).bind('background', '', sectionBrushConverter) .add( // new go.Picture({ margin: 10, width: 50, height: 50, background: "red" }) // .bind("source"), new go.TextBlock("Default Text", { margin: 8, stroke: "white", font: "bold 12px sans-serif" }) .bind("text", "unitName") ); myDiagram.linkTemplate = new go.Link( // default routing is go.Routing.Normal // default corner is 0 { routing: go.Routing.Orthogonal, corner: 5 }) .add( // the link path, a Shape new go.Shape({ strokeWidth: 3, stroke: "#555" }), // if we wanted an arrowhead we would also add another Shape with toArrow defined: //new go.Shape({ toArrow: "Standard", stroke: null }) ); myDiagram.addDiagramListener("ObjectSingleClicked", e => { // console.log(e.hm.nl.ii); var gotourl = "https://membership.scouts.org.uk/#/teams/allunits/"; if (e.hm.nl.ii.UnitLevel>97) { gotourl+=e.hm.nl.ii.teamunitId } else {gotourl+=e.hm.nl.ii.id.substring(0,36);} if (e.hm.nl.ii.UnitLevel<20) { gotourl+="/unitdetailsau"; } if (e.hm.nl.ii.UnitLevel>97) { gotourl+="/teamsau/"; } if (e.hm.nl.ii.UnitLevel==99) { gotourl+=(e.hm.nl.ii.parentUnitId).substring(0,36); } if (e.hm.nl.ii.UnitLevel==98) { gotourl+=(e.hm.nl.ii.id).substring(0,36); } if (e.hm.nl.ii.UnitLevel>97) { gotourl+="/teamdashboardaut"; } if (e.hm.nl.ii.UnitLevel==99) { gotourl+="/"+(e.hm.nl.ii.id).substring(0,36)+"/subteamdashboardaust"; } window.location.assign(gotourl); }); myDiagram.model = new go.TreeModel( { nodeParentKeyProperty: "parentUnitId", // this property refers to the parent node data nodeKeyProperty : "id", nodeDataArray: mems, angle: 90, arrangement: true, scale: 0.25, initialDocumentSpot: go.Spot.Top, initialViewportSpot: go.Spot.Top}); } // var map = {}; function show_organogram() { var h = $( window ).height(); $("#gmorganogram").dialog ( {modal: false, height: (h*0.75), width: "80%"} ); try { myDiagram = new go.Diagram("myDiagramDiv",{ "undoManager.isEnabled": true, layout: new go.TreeLayout({ angle: 0, layerSpacing: 35, scale: 0.25 }) // initialAutoScale: go.AutoScale.UniformToFill }) });} catch {} myDiagram.addDiagramListener('InitialLayoutCompleted', function(e) { var dia = e.diagram; // add height for horizontal scrollbar dia.div.style.width = (dia.documentBounds.width + 24) + "px"; if (( (dia.documentBounds.height + 24) * (dia.documentBounds.width))< 20000000 ) { dia.div.style.height = (dia.documentBounds.height + 24) + "px"; } else { dia.div.style.height = "25000px";} }); orgcounter = 0; mems=[]; orglevel = 0; // debug = true; mems = GM_getValue("orgmems", []); get_orgdata3(true); // get_orgdata(orgcounter,orglevel); } var locations = []; function get_mapdata5() { var errors = []; for (var i=1; i<mapunits.length; i++) { if (mapunits[i].unitType=="Group") { var postcode =""; if (mapunits[i].contactDetails.meetingPlaceAddress.postcode !="") { postcode = mapunits[i].contactDetails.meetingPlaceAddress.postcode } else { if (mapunits[i].contactDetails.correspondenceAddress.postcode !="") { postcode = mapunits[i].contactDetails.correspondenceAddress.postcode } } if (postcode!="") { var loc = locations.find(e=>e.query == postcode); if (loc.result!=null){ var marker = L.marker([loc.result.latitude,loc.result.longitude],{icon: mappin}).addTo(map).bindPopup(mapunits[i].name).openPopup(); } else { errors.push("Invalid postcode for "+mapunits[i].name+" "+postcode);} } else { errors.push("No postcode for "+mapunits[i].name);} } } $("#gmerrors")[0].innerHTML =""; for (i=0;i<errors.length;i++) { $("#gmerrors")[0].innerHTML += errors[i]+"<br>"; } } function get_postcodes(index) { var subpostcodes = []; for(var i=index*100;i<(index*100+100)&&i<postcodes.length;i++) { subpostcodes.push(postcodes[i]); } console.log(subpostcodes); var pi = {}; pi.postcodes = subpostcodes; var datapass = JSON.stringify(pi); GM_xmlhttpRequest({ method: "POST", context: index+1, url: "https://api.postcodes.io/postcodes?filter=postcode,longitude,latitude", data: datapass, headers: { "Content-Type": "application/json", "Authorization": "Bearer " + JSON.parse(localStorage.getItem("authInfo")).idToken, "Accept": "application/json, text/plain, */*" }, onload: function(response) { // console.log(response);console.log(count); // console.log(response.responseText); locations = locations.concat(JSON.parse(response.responseText).result); $("#gmmapstatus")[0].innerHTML = locations.length+" Postcodes read of "+postcodes.length; if ((response.context)*100<postcodes.length) {get_postcodes(response.context)} else {get_mapdata5()}; }, onerror: function(response) { GM_log("ON Error");GM_log(JSON.stringify(response))}, onabort: function(response) { GM_log("ON Abort");GM_log(JSON.stringify(response))} }); } function get_mapdata4() { console.log(mapunits); postcodes=[]; for (var i=0;i<mapunits.length;i++) { if (mapunits[i].contactDetails.meetingPlaceAddress.postcode !="") { postcodes.push(mapunits[i].contactDetails.meetingPlaceAddress.postcode) } else { if (mapunits[i].contactDetails.correspondenceAddress.postcode !="") {postcodes.push(mapunits[i].contactDetails.correspondenceAddress.postcode) } } } get_postcodes(0); } function get_mapdata3() { debug = true; // Remove verything but sections console.log(mapmems); mapunits = []; //https://tsa-memportal-prod-fun01.azurewebsites.net/api/GetUnitDetailAsync //unitId: "8942fe62-d032-4651-9317-7a9b929e710d" for (var i=1; i<mapmems.length; i++) { if (mapmems[i].unitType=="Group") { console.log("Unit "+i+" "+mapmems[i].unitName); var datapass = '{"unitId": "'+mapmems[i].id+'"}'; GM_xmlhttpRequest({ method: "POST", context: i+1, url: "https://tsa-memportal-prod-fun01.azurewebsites.net/api/GetUnitDetailAsync", data: datapass, headers: { "Content-Type": "application/json", "Authorization": "Bearer " + JSON.parse(localStorage.getItem("authInfo")).idToken, "Accept": "application/json, text/plain, */*" }, onload: function(response) { // console.log(response);console.log(count); if (debug) {GM_log("Counter Received "+response.context)} // console.log(JSON.parse(response.responseText).data[1]); var mem = null; try { mem = JSON.parse(response.responseText)} catch {console.log("JSON Error "+response.responseText);} // mem =(JSON.parse(response.responseText).data); mapunits.push(mem); // console.log(mapunits); if (mapunits.length==mapmems.filter(e=>e.unitType=="Group").length) { get_mapdata4(); } $("#gmmapstatus")[0].innerHTML = mapunits.length+" Groups read of "+mapmems.filter(e=>e.unitType=="Group").length; if (debug) {GM_log("Units mems now has length "+mapmems.length);} if (response.status!=200) {GM_log("HTTP error "+response.status); GM_log(JSON.stringify(response));} }, onerror: function(response) { GM_log("ON Error");GM_log(JSON.stringify(response))}, onabort: function(response) { GM_log("ON Abort");GM_log(JSON.stringify(response))} }); }} } function get_mapdata2(oc) { // Get the Tree if (mems.length==0) { $("#gmorgstatus")[0].innerHTML = "No Units found";} var max=50; var datapass = '{"pagesize":'+max+',"nexttoken":'+oc+',"filter":{"global" : "","globaland":false,"fieldand":true},"unitId":"'+mapmems[0].id+'"}'; // console.log(datapass); if (debug) {GM_log("Counter for get_Sub Unit "+oc);} GM_xmlhttpRequest({ method: "POST", context: oc+1, url: "https://tsa-memportal-prod-fun01.azurewebsites.net/api/UnitListingAsync", data: datapass, headers: { "Content-Type": "application/json", "Authorization": "Bearer " + JSON.parse(localStorage.getItem("authInfo")).idToken, "Accept": "application/json, text/plain, */*" }, onload: function(response) { // console.log(response);console.log(count); if (debug) {GM_log("Counter Received "+response.context)} // console.log(JSON.parse(response.responseText).data[1]); var mem = null; try { mem=JSON.parse(response.responseText).data} catch {console.log("JSON Error "+response.responseText);} // mem =(JSON.parse(response.responseText).data); if (mem.length>0) { if (debug) { } } if ((mem.length==0)&&(debug)) { GM_log("GetData: We got an error collecting data for Sub mems page"+response.context); } if (mem.length!=0) { mapmems = mapmems.concat(mem); } $("#gmmapstatus")[0].innerHTML = mapmems.length+" Units read"; if (debug) {GM_log("Units mems now has length "+mapmems.length);} if (response.status!=200) {GM_log("HTTP error "+response.status); GM_log(JSON.stringify(response));} if ( mem.length ==50) {get_mapdata2(oc+1); } else {missed = 0; mapunits=[]; get_mapdata3()};}, onerror: function(response) { GM_log("ON Error");GM_log(JSON.stringify(response))}, onabort: function(response) { GM_log("ON Abort");GM_log(JSON.stringify(response))} }); } function get_mapdata(oc,ol) { // Find the root var max = 50; un = document.getElementById("gmunitnamem").value; var unt= unitsearchvalues[ol]; if (debug) {GM_log("Unit Request for "+un+" Count "+oc+"/"+ol);} if (debug) { GM_log("Unit Request for "+un+" :"+ JSON.parse(localStorage.getItem("authInfo")).idToken.substring(1,50)); var tokexpDate = new Date( JSON.parse(localStorage.getItem("authInfo")).account.idTokenClaims.exp *1000); } $("#gmmapstatus")[0].innerHTML = "Checking for "+unitsearchtypes[ol]+" "+un; var datapass = '{"pagesize":'+max+',"nexttoken":'+oc+',"filter":{"global" : "","globaland":false,"fieldand":true,filterfields:[{ "field" : "'+unt+'", "value": "'+un+'"}]},"unitId":""}'; if (debug) {GM_log("Counter for get_data "+oc);} GM_xmlhttpRequest({ method: "POST", context: ol+1, url: "https://tsa-memportal-prod-fun01.azurewebsites.net/api/UnitListingAsync", data: datapass, headers: { "Content-Type": "application/json", "Authorization": "Bearer " + JSON.parse(localStorage.getItem("authInfo")).idToken, "Accept": "application/json, text/plain, */*" }, onload: function(response) { // console.log(response);console.log(count); if (debug) {GM_log("Counter Recieved "+response.context)} // console.log(JSON.parse(response.responseText).data[1]); var mem = null; try { mem=JSON.parse(response.responseText).data} catch {console.log("JSON Error "+response.responseText);} // mem =(JSON.parse(response.responseText).data); if (mem.length>0) { if (debug) { } } if ((mem.length==0)&&(debug)) { GM_log("GetData: We got an error collecting data for map mems page"+response.context); } if (mem.length!=0) { mapmems = mapmems.concat(mem); } if (debug) {GM_log("map mems now has length "+mapmems.length);} if (response.status!=200) {GM_log("HTTP error "+response.status); GM_log(JSON.stringify(response));} $("#gmmapstatus")[0].innerHTML = "Checking for "+unitsearchtypes[response.context-1]+" "+un; if ((ol<unitsearchvalues.length)&&( mapmems.length==0)) {get_mapdata(oc,response.context); } else { var filter = document.getElementById("gmunitnamem").value.replaceAll("%", "*"); let w = filter.replace(/[.+^${}()|[\]\\]/g, '\\$&'); // regexp escape const re = new RegExp(`^${w.replace(/\*/g,'.*').replace(/\?/g,'.')}$`,'i'); mapmems = mapmems.filter( function(v) {return re.test(v.unitName)}); get_mapdata2(0)}; }, onerror: function(response) { GM_log("ON Error");GM_log(JSON.stringify(response))}, onabort: function(response) { GM_log("ON Abort");GM_log(JSON.stringify(response))} }); } function show_map() { var h = $( window ).height(); $("#gmmap").dialog ( {modal: false, height: (h*0.75), width: "80%"} ); try { map = L.map('gmmapdiv').setView([51.505, -0.09], 13); } catch {} L.tileLayer('https://tile.openstreetmap.org/{z}/{x}/{y}.png', { maxZoom: 19, attribution: '© <a href="http://www.openstreetmap.org/copyright">OpenStreetMap</a>' }).addTo(map); mappin = L.icon({ iconUrl: GM_getResourceURL("LeafletPin"), shadowUrl: GM_getResourceURL("LeafletShadow"), iconSize: [25, 41], // size of the icon shadowSize: [41, 41], // size of the shadow iconAnchor: [12, 0], // point of the icon which will correspond to marker's location shadowAnchor: [0, 0], // the same for the shadow popupAnchor: [-3, -41] // point from which the popup should open relative to the iconAnchor }); orgcounter = 0; mapmems=[]; orglevel = 0; // debug = true; // mems = GM_getValue("orgmems", []); // get_mapdata3(true); // get_orgdata(orgcounter,orglevel); } function myCallback(blob) { var url = window.URL.createObjectURL(blob); var filename = 'myBlobFile.png'; var a = document.createElement('a'); a.style = 'display: none'; a.href = url; a.download = filename; // IE 11 if (window.navigator.msSaveBlob !== undefined) { window.navigator.msSaveBlob(blob, filename); return; } document.body.appendChild(a); requestAnimationFrame(() => { a.click(); window.URL.revokeObjectURL(url); document.body.removeChild(a); }); } function down_organogram() { var blob = myDiagram.makeImageData({ background: 'white', returnType: 'blob', callback: myCallback, size: new go.Size(NaN,NaN) }); console.log(myDiagram.documentBounds.height); console.log(myDiagram.documentBounds.width); } function save_organogram() { GM_setValue("orgmems", mems); $("#gmorgstatus")[0].innerHTML = "Hierarchy saved for instant recall"; } function run_organogram() { orgcounter = 0; mems=[]; orglevel = 0; orglevel = +document.getElementById("gmsorglevel").value; // debug = true; get_orgdata(orgcounter,orglevel); } function run_map() { orgcounter = 0; mapmems=[]; orglevel = 0; orglevel = +document.getElementById("gmsmaplevel").value; get_mapdata(orgcounter,orglevel); } function clear_cookies() { var cookies = document.cookie.split("; "); for (var c = 0; c < cookies.length; c++) { var d = window.location.hostname.split("."); while (d.length > 0) { var cookieBase = encodeURIComponent(cookies[c].split(";")[0].split("=")[0]) + '=; expires=Thu, 01-Jan-1970 00:00:01 GMT; domain=' + d.join('.') + ' ;path='; var p = location.pathname.split('/'); document.cookie = cookieBase + '/'; while (p.length > 0) { document.cookie = cookieBase + p.join('/'); p.pop(); }; d.shift(); } } } function run_learn() { GM_xmlhttpRequest({ method: "GET", context: 1, url: "https://learn.scouts.org.uk/ilp/restapi/lms/dashboards/8/panels/121/results/table?exportAggregations=false&skill=152688,149148,149147,153014,7804027,7802399,116405,10613435&assessmentType=0", // data: datapass, headers: { "Content-Type": "application/json", "Authorization": "Bearer " + JSON.parse(localStorage.getItem("authInfo")).idToken, "Accept": "application/json, text/plain, */*" }, onload: function(response) { // console.log(response);console.log(count); console.log(response); console.log(xmlToJson(response.responseText)); console.log(JSON.parse(xmlToJson(response.responseText)));_ }, onerror: function(response) { GM_log("ON Error");GM_log(JSON.stringify(response))}, onabort: function(response) { GM_log("ON Abort");GM_log(JSON.stringify(response))} }); } function report_saveXLS() { // document.getElementById("gmTabulator2").innerHTML = (tabletabulator.getHtml()); tabletabulator.download("xlsx", "data.xlsx", {sheetName:"My Data",documentProcessing: function(wb) { /* create a new worksheet */ var ws = XLSX.utils.aoa_to_sheet([ ["Data Extracted from Scout Membership system"], ["Export Date:", new Date()] ]); /* add to workbook */ //https://github.com/gitbrent/xlsx-js-style XLSX.utils.book_append_sheet(wb, ws, "Extract Information"); // wb.Sheets['My Data']['A1'].s = { font: { bold: true, color: { rgb: "FF0000" } } } for(var i=7;i<16;i++) { // wb.Sheets['My Data'][XLSX.utils.encode_cell({r:1, c:i})].s = { alignment: { textRotation: 180 } } } var cw = tabletabulator.getColumnLayout(); var wc = []; var cnames = []; var cc = 0; // Headers for (i=0; i<cw.length;i++) { if (cw[i].hasOwnProperty("columns")) { var group_visible = false; var group_start = cc; for (var j=0; j<cw[i].columns.length;j++) { if (cw[i].columns[j].visible) { group_visible = true; // if ( wb.Sheets['My Data'].hasOwnProperty(XLSX.utils.encode_cell({r:1, c:cc}))) { wb.Sheets['My Data'][XLSX.utils.encode_cell({r:1, c:cc})].s = { font: { bold: true}}; if(cw[i].columns[j].hasOwnProperty("headerVertical")) { wb.Sheets['My Data'][XLSX.utils.encode_cell({r:1, c:cc})].s.alignment = { textRotation: 180, vertical: "top", horizontal: "center" } ; } else { wb.Sheets['My Data'][XLSX.utils.encode_cell({r:1, c:cc})].s.alignment = { vertical: "top" } ;} if(cw[i].columns[j].hasOwnProperty("cssClass")) { switch(cw[i].columns[j].cssClass) { case 'blue-background': wb.Sheets['My Data'][XLSX.utils.encode_cell({r:1, c:cc})].s.fill = { fgColor: { rgb: "ADD8E6" } }; break; case 'yellow-background': wb.Sheets['My Data'][XLSX.utils.encode_cell({r:1, c:cc})].s.fill = { fgColor: { rgb: "FFFFE0" } }; break; case 'orange-background': wb.Sheets['My Data'][XLSX.utils.encode_cell({r:1, c:cc})].s.fill = { fgColor: { rgb: "FFDAB9" } }; break; } } wb.Sheets['My Data'][XLSX.utils.encode_cell({r:1, c:cc})].s.border = { top: {style: "thin", color: { rgb: "000000" }}} wb.Sheets['My Data'][XLSX.utils.encode_cell({r:1, c:cc})].s.border.bottom = {style: "thin", color: { rgb: "000000" }} wb.Sheets['My Data'][XLSX.utils.encode_cell({r:1, c:cc})].s.border.left = {style: "thin", color: { rgb: "000000" }} wb.Sheets['My Data'][XLSX.utils.encode_cell({r:1, c:cc})].s.border.right = {style: "thin", color: { rgb: "000000" }} wc.push({width: cw[i].columns[j].width*.15}); cnames.push(cw[i].columns[j].field); cc++; // } } if ((group_visible)&&(wb.Sheets['My Data'].hasOwnProperty(XLSX.utils.encode_cell({r:0, c:group_start})))) { // Group Header wb.Sheets['My Data'][XLSX.utils.encode_cell({r:0, c:group_start})].s = { font: { bold: true}}; wb.Sheets['My Data'][XLSX.utils.encode_cell({r:0, c:group_start})].s.fill = { fgColor: { rgb: "DCDCDC" } }; } } } else { if (cw[i].visible){ wc.push({width: cw[i].width*.15}); cnames.push(cw[i].field); wb.Sheets['My Data'][XLSX.utils.encode_cell({r:0, c:cc})].s = { font: { bold: true}, alignment: {vertical:"top"}}; wb.Sheets['My Data'][XLSX.utils.encode_cell({r:1, c:cc})].s = { font: { bold: true}, alignment: {vertical:"top"}}; wb.Sheets['My Data'][XLSX.utils.encode_cell({r:0, c:cc})].s.border = { top: {style: "thin", color: { rgb: "000000" }}} wb.Sheets['My Data'][XLSX.utils.encode_cell({r:0, c:cc})].s.border.bottom = {style: "thin", color: { rgb: "000000" }} wb.Sheets['My Data'][XLSX.utils.encode_cell({r:0, c:cc})].s.border.left = {style: "thin", color: { rgb: "000000" }} wb.Sheets['My Data'][XLSX.utils.encode_cell({r:0, c:cc})].s.border.right = {style: "thin", color: { rgb: "000000" }} wb.Sheets['My Data'][XLSX.utils.encode_cell({r:1, c:cc})].s.border = { top: {style: "thin", color: { rgb: "000000" }}} wb.Sheets['My Data'][XLSX.utils.encode_cell({r:1, c:cc})].s.border.bottom = {style: "thin", color: { rgb: "000000" }} wb.Sheets['My Data'][XLSX.utils.encode_cell({r:1, c:cc})].s.border.left = {style: "thin", color: { rgb: "000000" }} wb.Sheets['My Data'][XLSX.utils.encode_cell({r:1, c:cc})].s.border.right = {style: "thin", color: { rgb: "000000" }} cc++; } } // cc++; } wb.Sheets['My Data']["!cols"]= wc; // Color Cells for ticks etc for (i=0;i<tabletabulator.getRows().length;i++) { for (j=0; j<wc.length; j++) { if (wb.Sheets['My Data'].hasOwnProperty(XLSX.utils.encode_cell({r:i+2, c:j}))) { wb.Sheets['My Data'][XLSX.utils.encode_cell({r:i+2, c:j})].s = {}; if (wb.Sheets['My Data'][XLSX.utils.encode_cell({r:i+2, c:j})].hasOwnProperty("v")){ if(wb.Sheets['My Data'][XLSX.utils.encode_cell({r:i+2, c:j})].v=="✅") { wb.Sheets['My Data'][XLSX.utils.encode_cell({r:i+2, c:j})].s = { font: {color: { rgb: "00FF00" } }, alignment: { horizontal: "center" } } } if(wb.Sheets['My Data'][XLSX.utils.encode_cell({r:i+2, c:j})].v=="❌") { wb.Sheets['My Data'][XLSX.utils.encode_cell({r:i+2, c:j})].s = { font: {color: { rgb: "FF0000" } }, alignment: { horizontal: "center" } } } if(wb.Sheets['My Data'][XLSX.utils.encode_cell({r:i+2, c:j})].v=="✖") { wb.Sheets['My Data'][XLSX.utils.encode_cell({r:i+2, c:j})].s = { font: {color: { rgb: "000000" } }, alignment: { horizontal: "center" } } } if(wb.Sheets['My Data'][XLSX.utils.encode_cell({r:i+2, c:j})].v=="✔") { wb.Sheets['My Data'][XLSX.utils.encode_cell({r:i+2, c:j})].s = { font: {color: { rgb: "000000" } }, alignment: { horizontal: "center" } } } if(wb.Sheets['My Data'][XLSX.utils.encode_cell({r:i+2, c:j})].v=="⚡") { wb.Sheets['My Data'][XLSX.utils.encode_cell({r:i+2, c:j})].s = { font: {color: { rgb: "FFA500" } }, alignment: { horizontal: "center" } } } if ((cnames[j].indexOf("dbs")==0)||(cnames[j].indexOf("safeguarding")==0)||(cnames[j].indexOf("safety")==0)||(cnames[j].indexOf("firstresponse")==0)) { var ci =-1; if (cnames[j].indexOf("_")==-1) { ci = cnames.findIndex(e=>e==cnames[j]+"_expirydays"); ci = -1; // No colour for Icon column... } else { ci = cnames.findIndex(e=>e== cnames[j].substring(0, cnames[j].indexOf("_"))+"_expirydays");} var expdays = -1; if (ci>-1) { var cs = cnames.findIndex(e=>e== cnames[j].substring(0, cnames[j].indexOf("_"))); var css = wb.Sheets['My Data'][XLSX.utils.encode_cell({r:i+2,c:cs})]; if ("✅❌✔⚡✖".includes(css.v)) { if (wb.Sheets['My Data'].hasOwnProperty(XLSX.utils.encode_cell({r:i+2, c:ci}))) { if (wb.Sheets['My Data'][XLSX.utils.encode_cell({r:i+2, c:ci})].hasOwnProperty("v")) { expdays = wb.Sheets['My Data'][XLSX.utils.encode_cell({r:i+2, c:ci})].v; } } if(document.getElementById("gmcolor").checked) { for(cloop=0;cloop<4;cloop++) { if ((expdays<=daylimits[cloop])&&(expdays>daylimits[cloop+1])) { wb.Sheets['My Data'][XLSX.utils.encode_cell({r:i+2, c:j})].s.fill = {fgColor: { rgb: colors[cloop].substring(1,7) }} // td.style.backgroundColor = colors[cloop]; // td.style.textColor = colorsT[cloop]; }}} }} } } wb.Sheets['My Data'][XLSX.utils.encode_cell({r:i+2, c:j})].s.border = { top: {style: "thin", color: { rgb: "000000" }}} wb.Sheets['My Data'][XLSX.utils.encode_cell({r:i+2, c:j})].s.border.bottom = {style: "thin", color: { rgb: "000000" }} wb.Sheets['My Data'][XLSX.utils.encode_cell({r:i+2, c:j})].s.border.left = {style: "thin", color: { rgb: "000000" }} wb.Sheets['My Data'][XLSX.utils.encode_cell({r:i+2, c:j})].s.border.right ={style: "thin", color: { rgb: "000000" }} }} } return wb; }}); } function report_download() { tabletabulator.getHtml(); // const clipboardItem = new ClipboardItem({ // 'text/html': new Blob([document.getElementById("GMourreport").outerHTML], { type: 'text/html' }), // 'text/plain': new Blob([document.getElementById("GMourreport").innerText], { type: 'text/plain' }) // }); const clipboardItem = new ClipboardItem({ 'text/html': new Blob([tabletabulator.getHtml()], { type: 'text/html' }), 'text/plain': new Blob([tabletabulator.getHtml().innerText], { type: 'text/plain' }) }); navigator.clipboard.write([clipboardItem]); } // Navigation Watcher /* navigation.addEventListener("navigate", e => { console.log("EventLstener"); console.log(e); if (document.getElementById("quick_nav")!=null){console.log("remove");document.getElementById("quick_nav").innerHTML ="";} setTimeout(function() { }, 2000); }) // Event listener */ /* setTimeout(function() { console.log("New Page"); // dopage(); Deactive Unit/Teams }, 2000); */ // Your code here... var newHTML = document.createElement ('div'); // <p>Exclude Welcome Information <input type="checkbox" id="gmexc" name="gmtexc" /><p> \ //<p><input type="checkbox" id="gmtraffic" name="gmtraffic" /> Show 90 Day Traffic LIghts \ newHTML.innerHTML = ' \ <div id="gmpopup" title="Roles Report"> \ <p> \ Unit <input type="text" list="myUnits" id="gmunitname" size=30 name="gmunitname" placeholder="Enter Unit Name (% =wildcard)"/><datalist id="myUnits"></datalist> <button id="gmRunReport">Run Report</button> <button id="gmFilterReport">Refresh Display</button></p> \ <p>Include Roles for matching Unit Only <input type="checkbox" id="gmteamonly" name="gmteamonly" /> Exact Match <input type="checkbox" id="gmexact" name="gmexact" /> <p> \ <p>Name Filter <input type="text" id="gmpersonname" name="gmpersonname" /> Team Filter <input type="text" id="gmteamname" name="gmteamname" /><p> \ <input type="checkbox" id="gmmissing" name="gmmissing" /> Show volunteers missing Welcome elements only \ <p><input type="checkbox" id="gmwelcome" name="gmwelcome" /> Exclude Role Audit</p> \ <p> <input type="checkbox" id="gmhelper" name="gmhelper" /> Exclude Helpers/Holding Roles <input type="checkbox" id="gmclosed" name="gmclosed" checked/> Exclude Closed Roles <p> \ <p><input type="checkbox" id="gmlearning" name="gmlearning" /> Show Detailed learning \ <input type="checkbox" id="gmdates" name="gmdates" /> Show Expiry Dates \ <input type="checkbox" id="gmdays" name="gmdays" /> Show Days to Expiry </p> \ <p><input type="checkbox" id="gmdbs" name="gmdbs" /> Show DBS Information <input type="checkbox" id="gmdbsip" name="gmdbsip" /> Show DBS Status</p> \ <p><input type="checkbox" id="gmnumber" name="gmnumber" /> Show Membership Number<input type="checkbox" id="gmcolor" name="gmcolor" /> Use Color</p>\ <strongb>Run Status : </strong> <span id="gmState">Enter Unit Name above (can include % wildcard) and run report</span> \ <p>Showing All Roles for members of <span id="gmUnit"></span></p> \ <span id="gmTablex"><button id="gmXLS">Copy to Clipboard</button></span> \ <span id="gmTablep"><button id="gmPrint">Print</button></span> \ <span id="gmTablex2"><button id="gmSaveReport">Save XLS</button></span> \ <span id="gmTable">Report will appear here!</span> \ <div id="gmTabulator"></div> \ <div id="gmTabulator2"><p>Key: ✅ Required and complete ❌ Required ⚡Complete but near expiry ✔ Not required but complete ✖ Not required but expired </p></div> \ <p><input type="checkbox" id="gmdebug" name="gmdebug" /> Debug Info - usually this should be off</p> \ <p style="display:none"><input type="checkbox" id="gmexplorer" name="gmexplorer" /> Experimental Data Collection</p> \ <p><button id="gmsavecolors">Save Colors</button> <button id="gmresetcolors">Reset Colors</button></p> \ <div id="htmlset" style=""></div> \ </div> '; //<p><input type="checkbox" id="gmexplorer" name="gmexplorer" /> Experimental Data Collection</p> \ // Add Color Selectors document.body.appendChild (newHTML); var colors_JSON = GM_getValue("colors", JSON.stringify(defcolors)); var colorsT_JSON = GM_getValue("colorsT", JSON.stringify(defcolorsT)); colors = JSON.parse(colors_JSON); colorsT = JSON.parse(colorsT_JSON); var HTMLSettings = document.createElement ('div'); for (var cloop=0;cloop<4;cloop+=1){ HTMLSettings.innerHTML += '<p><span style="display: inline-block; width :75px">'+colormeanings[cloop]+'</span> '+'<input type="color" id="back'+cloop+'" name="back'+cloop+'" value="'+colors[cloop]+'" />'+'<span> <input type="color" id="fore'+cloop+'" name="fore'+cloop+'" value="'+colorsT[cloop]+'" /></span> <span id="cpreview'+cloop+'">1000</span></p>'; } document.getElementById("htmlset").appendChild (HTMLSettings); for (cloop=0;cloop<4;cloop+=1){ document.getElementById("back"+cloop).addEventListener("input", updateFirstC, false); document.getElementById("back"+cloop).addEventListener("change", watchColorPicker, false); document.getElementById("fore"+cloop).addEventListener("input", updateFirstC, false); document.getElementById("fore"+cloop).addEventListener("change", watchColorPicker, false); document.getElementById("cpreview"+cloop).style.backgroundColor = colors[cloop]; document.getElementById("cpreview"+cloop).style.color = colorsT[cloop]; document.getElementById("cpreview"+cloop).style.padding = "10px"; } $("#gmpopup").hide(); newHTML = document.createElement ('div'); newHTML.innerHTML = ' \ <div id="gmorganogram" title="Organogram">Unit <input type="text" id="gmunitnameo" size=30 name="gmunitnameo" placeholder="Enter Unit Name (% =wildcard)"/> \ Start At <select id="gmsorglevel" name="gmsorglevel" /><option value="0">Organisation</option><option value="1">Country</option><option value="2">Region</option><option value="3">County</option><option value="4">County Sections</option> <option value="5">District</option><option value="6">District Sections</option><option value="7">Group</option><option value="8">Group Section</option></select> \ <button id="gmRunOrg">Chart Data</button><button id="gmSaveOrg">Save</button> <button id="gmDownOrg">Download</button>\ <p><input type="checkbox" id="gmnoteams" name="gmnoteams" /> Show Units Only <input type="checkbox" id="gmnosteams" name="gmnosteams" /> Exclude section Teams</p> \ <p>Display down to: <select id="gmorglevel" name="gmorglevel" /> <option value="1">Group Section</option><option value="2">Group</option><option value="3">District Sections</option><option value="4">District</option><option value="5">County Sections</option><option value="6">County</option><option value="7">Region</option><option value="8">Country</option><option value="9">Organisation</option></select> \ <p> Status : <span id="gmorgstatus"></span></P> \ <div id="myDiagramDiv" style="width:1000px; height:40000px; background-color: #DAE4E4;"></div><p> <div style="height:1000px;display:none" id="map"></div> </p></div> \ '; document.body.appendChild (newHTML); $("#gmorganogram").hide(); newHTML = document.createElement ('div'); newHTML.innerHTML = ' \ <div id="gmmap" title="Map">Unit <input type="text" id="gmunitnamem" size=30 name="gmunitnamem" placeholder="Enter Unit Name (% =wildcard)"/> \ Start At <select id="gmsmaplevel" name="gmsmaplevel" /><option value="0">Organisation</option><option value="1">Country</option><option value="2">Region</option><option value="3">County</option><option value="4">County Sections</option> <option value="5">District</option><option value="6">District Sections</option><option value="7">Group</option><option value="8">Group Section</option></select> \ <button id="gmRunMap">Map Data</button>\ <p> Status : <span id="gmmapstatus"></span></P> \ <p> <div style="height:1000px" id="gmmapdiv"></div> </p><p>Errors</p><p><div id="gmerrors"></div><div>Key</div><div id="gmkey"></div>\ </div> \ '; document.body.appendChild (newHTML); $("#gmmap").hide(); var iconSet1 = GM_getResourceURL ("IconSet1"); var iconSet2 = GM_getResourceURL ("IconSet2"); // var iconSet3 = GM_getResourceURL ("LeafletPin"); // var iconSet4 = GM_getResourceURL ("LeafletShadow"); var jqUI_CssSrc = GM_getResourceText ("jqUI_CSS"); var leaf_Css = GM_getResourceText("leaf"); var tabulator_css = GM_getResourceText("tabulator"); jqUI_CssSrc = jqUI_CssSrc.replace (/url\(images\/ui\-bg_.*00\.png\)/g, ""); jqUI_CssSrc = jqUI_CssSrc.replace (/images\/ui-icons_222222_256x240\.png/g, iconSet1); jqUI_CssSrc = jqUI_CssSrc.replace (/images\/ui-icons_454545_256x240\.png/g, iconSet2); // var testing = GM_info(); GM_addStyle (jqUI_CssSrc); GM_addStyle (leaf_Css); GM_addStyle (tabulator_css ); addButton("Role Report", report_onclick2, "","T"); addButton("Clear Cookies", clear_cookies,"", "B"); addButton("Organogram", show_organogram,"", "C"); // addButton("Map Groups", run_map,"", "D"); document.getElementById("gmRunReport").onclick = report_onclick; document.getElementById("gmFilterReport").onclick = report_filter; document.getElementById("gmSaveReport").onclick = report_saveXLS; document.getElementById("gmsavecolors").onclick = savecolors; document.getElementById("gmresetcolors").onclick = resetcolors; document.getElementById("gmXLS").onclick = report_download; document.getElementById("gmPrint").onclick = report_print; document.getElementById("gmunitname").value = un; document.getElementById("gmpopup").style.fontSize = "10pt"; document.getElementById("gmorganogram").style.fontSize = "10pt"; document.getElementById("gmmap").style.fontSize = "10pt"; document.getElementById("gmRunOrg").onclick = run_organogram; document.getElementById("gmSaveOrg").onclick = save_organogram; document.getElementById("gmDownOrg").onclick = down_organogram; document.getElementById("gmRunMap").onclick = run_map; var blkrs = GM_info.script.options.override.use_blockers; if (blkrs.length>0) { var clicked = GM_notification({ text: "There maybe an issue with your XHR blacklist this may stop things running - check the plugin settings", title: "Scout Membership Plugin", url: 'https:/example.com/', onclick: (event) => { //The userscript is still running, so don't open example.com event.preventDefault(); // Display an alert message instead // alert('I was clicked!') } }); } // Get MyUnits // https://tsa-memportal-prod-fun01.azurewebsites.net/api/MyUnitsAsync // var datapass = '{"pagesize":100,"sort":{"field":"unitName","type":"asc"}}'; GM_addStyle ('.fa-check-square:before { content: "✅"; }' ); GM_addStyle ('.fa-square:before { content: "🟩"; }' ); GM_addStyle('.tabulator-col.tabulator-col-vertical.tabulator-sortable.tabulator-col-sorter-element.blue-background {background : #ADD8E6 }'); GM_addStyle('.tabulator-col.tabulator-col-vertical.tabulator-sortable.tabulator-col-sorter-element.yellow-background {background : #FFFFE0 }'); GM_addStyle('.tabulator-col.tabulator-sortable.tabulator-col-sorter-element.orange-background {background : #FFDAB9 }'); GM_addStyle('th.blue-background { writing-mode: vertical-lr; background-color: lightcyan; }'); GM_addStyle('th.yellow-background { writing-mode: vertical-lr; background-color: lightgoldenrodyellow; }'); GM_addStyle('th.orange-background { writing-mode: vertical-lr; background-color: salmon; }'); GM_addStyle('table.tabulator-print-table, tr, th, td { border: solid;}'); })();
QingJ © 2025
镜像随时可能失效，请加Q群300939539或关注我们的公众号极客氢云获取最新地址
