updateEditorProgress

for each discord editor in your region's channel, this script will open the associated editor's profile, capture relevant information, and download that information into

目前為 2018-08-26 提交的版本,檢視 最新版本

// ==UserScript==
// @name         updateEditorProgress
// @namespace    http://tampermonkey.net/
// @version      2018.08.26.02
// @description  for each discord editor in your region's channel, this script will open the associated editor's profile, capture relevant information, and download that information into
// @description  comma separated value (CSV) file.  The contents of the file can then be programmaticaly added to a google sheet (using a separate script)
// @description  With the script installed, open any WME editor profile page to execute the script.
// @author       ramblinwreck_81
// @match        https://www.waze.com/user/editor*
// @require      https://gf.qytechs.cn/scripts/24851-wazewrap/code/WazeWrap.js?version=229392
// @grant        none
// ==/UserScript==


// TO DO:
// filter out >R4
// add code that removes editors based on inactivity

// fix bot code to remove duplicates
// fix bot code to avoid editor name errors



(function() {
  'use strict';
  var discordEditors = [];
  var API_KEY ='AIzaSyDOdMtqjg0CUHMeFt29GeQzrR0__0hr5YQ'
  var CLIENT_ID = '533057355164-2m80uia4u5pedq0dteiia47k3ff6als8.apps.googleusercontent.com'
  var DISCOVERY_DOCS = ["https://sheets.googleapis.com/$discovery/rest?version=v4"];
  var SCOPES = "https://www.googleapis.com/auth/spreadsheets.readonly";
  var spreadsheetId = '15TYXaO7iYRNNDUkkavG-2X75yP6iPobPV-VNBGhVjIU';
  var ssRange = 'discordEditors!A:A';
  var authorizeButton;
  var signoutButton;
  function bootstrap(tries) {
      //console.log(tries);
      tries = tries || 1;
     // console.log(tries);
     // console.log(W,W.Map,W.Model,$);

      if (W && W.Map &&
          W.Model  &&
          $ ) {
         // console.log('passed load check');
          init();
      } else if (tries < 100) {
          setTimeout(function () {
          tries += 1;
          bootstrap(tries);}, 200);
      }
  } // end of bootstrap

  function init()
  {
      console.log("initializing editor progress script");
      createUploadElements();

      function createUploadElements() {
//          $('body').append('<script async defer src="https://apis.google.com/js/api.js" onload="this.onload=function(){};handleClientLoad()" onreadystatechange="if (this.readyState === complete) this.onload()"></script>');
          var y=document.createElement("div");
          y.setAttribute("id", "csv-info");
          document.getElementsByClassName("user-headline")[0].appendChild(y);
//           var x = document.createElement("INPUT");
//           x.setAttribute("type", "file");
//           x.setAttribute("id","fileUpload");
//           document.getElementById("csv-info").appendChild(x);
             var z=document.createElement("button");
             z.setAttribute("type", "button");
             z.setAttribute("value", "Run");
             z.setAttribute("id","run-editor-update");
             var aa=document.createTextNode("Run");
             z.appendChild(aa);
             document.getElementById("csv-info").appendChild(z);
            document.getElementById("run-editor-update").style.height="20px";
            document.getElementById("run-editor-update").style.width="100px";
          $('#csv-info').append('<button id="authorize_button" style="display: none;">Authorize</button><button id="signout_button" style="display: none;">Sign Out</button>');
   authorizeButton = document.getElementById('authorize_button');
   signoutButton = document.getElementById('signout_button');
      } // end of createUploadElements
      document.getElementById("run-editor-update").addEventListener("click",handleClientLoad,false);
  } // end of init
//  var authorizeButton = document.getElementById('authorize_button');
//  var signoutButton = document.getElementById('signout_button');
  function handleClientLoad() {
//      console.log('here');
      gapi.load('client:auth2', initClient);
  }
  function initClient() {
        gapi.client.init({
          //apiKey: API_KEY,
          clientId: CLIENT_ID,
          discoveryDocs: DISCOVERY_DOCS,
          scope: SCOPES
        }).then(function () {
          // Listen for sign-in state changes.
          gapi.auth2.getAuthInstance().isSignedIn.listen(updateSigninStatus);

          // Handle the initial sign-in state.
          updateSigninStatus(gapi.auth2.getAuthInstance().isSignedIn.get());
          authorizeButton.onclick = handleAuthClick;
          signoutButton.onclick = handleSignoutClick;
        });
  }
  function updateSigninStatus(isSignedIn) {
        if (isSignedIn) {
          authorizeButton.style.display = 'none';
          signoutButton.style.display = 'block';
          executionSequence();
        } else {
          authorizeButton.style.display = 'block';
          signoutButton.style.display = 'none';
        }
  }
  function handleAuthClick(event) {
        gapi.auth2.getAuthInstance().signIn();
  }

      /**
       *  Sign out the user upon button click.
       */
  function handleSignoutClick(event) {
        gapi.auth2.getAuthInstance().signOut();
  }

  $('body').append('<script async defer src="https://apis.google.com/js/api.js" onload="this.onload=function(){};handleClientLoad()" onreadystatechange="if (this.readyState === complete) this.onload()"></script>');
  // ********************************************************upload function no longer used.
    function upload()
  {
    var blnKeepWaiting = true;
    var fileTimer;
//    console.log('uploading');
    var fileUpload = document.getElementById("fileUpload");
    var regex = /^([a-zA-Z0-9\s_\\.\-:])+(.csv|.txt)$/;
    if (regex.test(fileUpload.value.toLowerCase())) {
        if (typeof (FileReader) !== "undefined") {
//          console.log('fileReader!==undefined');
          var reader = new FileReader();
          reader.onload = function (e) {
            if (fileTimer !==undefined) {
              clearInterval(fileTimer);
              var editorStr = reader.result;
//get rid of duplicate editor names...
              var dups = editorStr.split(',');
//              console.log('editor array length ' + dups.length);
              var modDups = dups.forEach(function(element, index, array) {
                array[index] = array[index].toLowerCase().trim();
              });
              //console.log(dups);
              discordEditors = dups.reduce(function(a,currentValue) {
                if (a.indexOf(currentValue) <0){
                  a.push(currentValue);
                }
                return a;
              }, []);
//              console.log('editor array length after no dups ' + discordEditors.length);
//              console.log('discordEditors: ' + discordEditors);
              executionSequence();
            }
            blnKeepWaiting=false;
           };
          reader.readAsText(fileUpload.files[0]);
          //console.log('file uploaded');
          fileTimer=setInterval(checkAgain,40);
        } else {
            alert("This browser does not support HTML5.");
        }
    } else {
        alert("Please upload a valid CSV file.");
    }
  } // end of upload
// ***************************************************************************************************************

  function checkAgain()
  {
    if (blnKeepWaiting===false) {
    } else {
//        console.log("still waiting for file upload...");
    }
  } //end of checkAgain
//*********************************checkagain was part of upload sequence and is no longer used ****************************
  function executionSequence() {
    let lockedArray = localStorage.getItem('lockedEditors') ? JSON.parse(localStorage.getItem('lockedEditors')) : [];
    var validatedProfileCount = 0;
    var profilePageErrors =0;
    var editors =[];
    var rangeLength = 0;
    var seniorEditor = 0;
    var inactiveEditors = 0;
    var L1Editors = 0;
    var L2Editors = 0;
    var L3Editors = 0;
    var L4Editors = 0;
    var L5Editors = 0;
    var totalEditors = 0;
    var L1Edits = 0;
    var L2Edits = 0;
    var L3Edits =0;
    var L4Edits = 0;
    var L5Edits = 0;

    //upload();
    connectGoogleAPI();
    function connectGoogleAPI() {
      var params = {
        // The ID of the spreadsheet to retrieve data from.
        spreadsheetId: spreadsheetId, //TODO: Update placeholder value.

        // The A1 notation of the values to retrieve.
        ranges: ssRange,

        // How values should be represented in the output.
        // The default render option is ValueRenderOption.FORMATTED_VALUE.
        valueRenderOption: 'UNFORMATTED_VALUE',  // TODO: Update placeholder value.

        // How dates, times, and durations should be represented in the output.
        // This is ignored if value_render_option is
        // FORMATTED_VALUE.
        // The default dateTime render option is [DateTimeRenderOption.SERIAL_NUMBER].
        dateTimeRenderOption: 'FORMATTED_STRING',  // TODO: Update placeholder value.
      };

      var request = gapi.client.sheets.spreadsheets.values.batchGet(params);
      request.then(function(response) {
        var apiEditors = response.result.valueRanges[0].values
       // debugger;
        rangeLength = response.result.valueRanges[0].values.length;
        apiEditors.forEach(function(element,index,array){
            discordEditors.push(array[index][0]);
        });
      }, function(reason) {
        console.error('error: ' + reason.result.error.message);
      });
    }
//      console.log(discordEditors.length + ' is discordeditor length');
      var timeoutCounter=0;
    c();
    function c() {
        var waitTime=400;

        var g_Wait;
        if(discordEditors.length === rangeLength && rangeLength > 300) {
//            console.log('total delay was ' + waitTime * timeoutCounter + ' ms. Going to connectWazeAPI');
            clearTimeout(g_Wait);
//            console.log('rangeLength is ' + rangeLength, 'discordEditors.length is ' + discordEditors.length + ' going to connectWazeAPI');
          //  debugger;
            connectWazeAPI();
        } else {
            timeoutCounter += 1;
            g_Wait = setTimeout(function d() {
            c();},400);
        }
    }

   // console.log('profilepageErrors: ' + profilePageErrors + 'validatedProfileCount: ' + validatedProfileCount);
    timeoutCounter =0;
    a();
    function a() {
      var wait;
      var waitTime=1000;
//        console.log('profilePageErrors is ' + profilePageErrors + '.  validatedProfileCount is ' + validatedProfileCount + '.  discordEditors.length is ' + discordEditors.length);
      if (profilePageErrors + validatedProfileCount + seniorEditor + inactiveEditors === discordEditors.length && discordEditors.length > 0) {
        clearTimeout(wait);
//        console.log('total delay was ' + waitTime * timeoutCounter + ' ms. Going to function buildWebDisplay');
        buildWebDisplay();
      } else {
          wait = setTimeout(function b() {
          timeoutCounter += 1;
//          console.log('not ready to build web display');
          a();}, 1000);
      }
    }
    function connectWazeAPI() {
      function Editor(name, rank, firstEditDate, totalEdits,editHistory, milestone, rate, lastEditDate, milliFirstEditDate, sevenDayEdits)
        {
          this.name = name;
          this.rank = rank;
          this.firstEditDate = firstEditDate;
          this.totalEdits = totalEdits;
          this.editHistory = editHistory;
          this.sevenDayEdits = sevenDayEdits;
          this.milestone = milestone;
          this.rate = rate;
          this.lastEditDate = lastEditDate;
          this.milliFirstEditDate = milliFirstEditDate;
        }
      function pullEditorInfo(element, index, array) {

        var wazeURL = 'https://www.waze.com/user/editor/';
        $.ajax({
          url: wazeURL + element,
          success: function (data, status, xhr) {
            var $result = $.parseHTML(xhr.responseText,true)[9].text;
            var cdata = JSON.parse($result.split(";")[1].replace("gon.data=",""));
//              console.log(cdata);
            var userdata = "\nUsername: " + cdata.username + "\nRank: " + parseInt(cdata.rank + 1) + "\nEdits: " + cdata.edits + "\nFirst Edit Date: " + cdata.firstEditDate;
//            console.log("CDATA Section:" + $result,"\ngon.data: " + JSON.stringify(cdata), "\n\nUser Data: " + userdata, "\n\nUrl is " + wazeURL + element);
            if(cdata.firstEditDate === undefined) {
                profilePageErrors += 1;
                console.log(`${cdata.username} has no valid date.`);
                //debugger;
                return;
            }
//             if(parseInt(cdata.rank + 1) > 4 ){
//                 seniorEditor += 1;
//                 return;
//             }
            editors[validatedProfileCount] = new Editor(cdata.username, parseInt(cdata.rank + 1), cdata.firstEditDate, cdata.edits, cdata.editingActivity);
//            console.log('current editor is ' + editors[validatedProfileCount].name + ' editHistory: ' + editors[validatedProfileCount].editHistory);
            var active = -1;
            editors[validatedProfileCount].lastEditDate = findLastEditDate(editors[validatedProfileCount]);
            editors[validatedProfileCount].milliFirstEditDate = cdata.firstEditDate;
 //           console.log('editor last edit date is ' + editors[validatedProfileCount].lastEditDate);
            function findLastEditDate(curEditor){
              var arr = curEditor.editHistory;
              var foundFirst = false;
              var lastDay;
              arr = arr.reverse();
              arr.forEach(function(element, index, array) {
                if((array[index]>0) && (foundFirst === false)) {
                  foundFirst = true;
     //             console.log('index is ' + index + ' and edits were ' + array[index]);
                  active = index;
                }
              });
              var today = new Date();
 //              console.log('today is ' + today);
              var lastDayMS = 0;
              if (active > -1) {
                  lastDayMS = active * 24 * 60 * 60 * 1000;
              } else {
                  lastDayMS = 92 * 24 * 60 * 60 * 1000;
                  inactiveEditors += 1;
              }
              var lastDate = new Date(today - lastDayMS);
                //              console.log('last edit date is ' + lastDate);
              return lastDate.toLocaleDateString();

            } // end of findLastEditDate
            if (active > -1) {
                validatedProfileCount += 1;
                switch (parseInt(cdata.rank + 1)) {
                    case 1:
                        L1Editors += 1;
                        L1Edits += cdata.editingActivity.reduce(reducer);
                        break;
                    case 2:
                        L2Editors += 1;
                        L2Edits += cdata.editingActivity.reduce(reducer, 0);
                        break;
                    case 3:
                        L3Editors += 1;
                        L3Edits += cdata.editingActivity.reduce(reducer, 0);
                        break;
                    case 4:
                        L4Editors +=1;
                        L4Edits += cdata.editingActivity.reduce(reducer, 0);
                        break;
                    case 5:
                        L5Editors +=1;
                        L5Edits += cdata.editingActivity.reduce(reducer, 0);
                        return;
                        break;
                    case 6:
                    case 7:
                        return;
                        break;
                }
                function reducer(accumulator, value) {
                    return accumulator + value;
                }
                totalEditors = L1Editors + L2Editors + L3Editors + L4Editors + L5Editors;
            console.log(L1Edits, L2Edits, L3Edits,L4Edits,L5Edits);
            }
          },
          error: function(XMLHttpRequest, textStatus, errorThrown) {
            console.log(element + " Status: " + textStatus + " and Error: " + errorThrown);
            profilePageErrors += 1;
            //validatedProfileCount += -1;
          }
        }); // end of ajax

      } // end of pullEditorInfo
      discordEditors.forEach(pullEditorInfo);
    } // end of connectWazeAPI

    function buildWebDisplay()
    {
      var editorHTML='';
      var regionEditorsHTML = '<div class = "table-area1"><button  type = "button" id = "save-locked">Save Locked Editors</button><div id = "total-editors"></div><div id = regions-edits></div><table id= "region-table">'
      + '<thead id = "the-head"><tr><th id= "name" class = "col1 columz"><button type="button" id="sort-name" '
      + '>Name</button></th><th id="level" class = "col2 columz"><button type = "button" id = "sort-level">Level</button></th><th id= "locked" class = '
      + '"col3 columz"><button type = "button" id = "sort-locked">Locked</button></th><th id="began" class = "col4 columz">'
      + '<button type = "button" id= "sort-began">Editing Since</button>'
      + '</th><th id="total-edits" class = "col5 columz"><button type = "button" id= "sort-edits">Total Edits</button>'
      + '</th><th id="milestone" class = "col6 columz"><button type = "button" id = "sort-milestone">Milestone</button></th><th id="rate" '
      + 'class = "col7 columz"><button type = "button" id = "sort-rate">Edits (L1 is past 7 days, >L1 is past 30 days)</button></th>'
      + '<th id = "milliDate" class = "col8 columz">msDate</tr></thead><tbody id = "theTable-body">';

      editors.forEach(addStatsToTable);
      function addStatsToTable(element, index, array)
      {
        function convertSecondsToDate(sec) {
          var a = new Date(sec).toLocaleDateString();
          if (array[index].firstEditDate !== NaN){
              array[index].firstEditDate = a;
              return a;
          } else {
              console.log( `array[index] first edit date is not a number. array[index].name`);

          }
        }
        var startDate = convertSecondsToDate(editors[index].firstEditDate);
        //editors[index].firstEditDate = startDate;
        var rate = editRate(editors[index]);
 //       console.log('rate is ' + rate, 'editor is ' + editors[index].name);
        function editRate(rateEditor)
        {
          var period;
          if (rateEditor.rank !== NaN) {
              if (rateEditor.rank=== 1) {
                  period = 7;
              } else if (rateEditor.rank >= 2) {
                  period = 30;
              }
          } else {
              console.log(rateEditor.name + ' does not have a valid rank.');
          }
          function sumEdits(accumulator, currentValue) {
            return accumulator + currentValue;
          }
          if (rateEditor.editHistory.length === 0) {
              console.log(rateEditor.name + 'does not have a valid edit history. ' );
          } else {
              var a = rateEditor.editHistory.slice(rateEditor.editHistory.length - period);
              console.log(rateEditor.name, rateEditor.editHistory.length, "period: " + period, rateEditor.editHistory.length-period);
              //         console.log('rate editor is ' + rateEditor + ' and edit history length - period is ' + rateEditor.editHistory.length - period);
              //         console.log('applicable edit history is ' + a);
              var b = a.reduce(sumEdits);
              console.log('edit rate is ' + b);
              rateEditor.rate = b;
              return b;
          }
        } // end of editRate function
        var mileStr = milestone(editors[index]);
//        console.log('mileStr is ' + mileStr, 'editor is ' + editors[index].name);
        function milestone(curEditor)
        {
          switch (curEditor.rank) {
            case 1:
              if(curEditor.totalEdits > 1000) {
                return curEditor.milestone = 'true, total edits';
              } else if ((curEditor.totalEdits + rate)>3000) {
                return curEditor.milestone = 'true, edit rate';
              } else if (rate > 1000) {
                return curEditor.milestone = 'true, edit rate';
              } else if (curEditor.totalEdits > 400) {
                  return curEditor.milestone = 'initial review required';
              } else {
                return curEditor.milestone = 'false';
              }
            break;
            case 2:
              if (curEditor.totalEdits>20000) {
                return curEditor.milestone = 'true, edits';
              } else if ((curEditor.totalEdits + rate)>25000) {
                return curEditor.milestone = 'true, 30 day edit rate'
              } else {
                return curEditor.milestone = 'false';
              }

            break;
            default:
              return curEditor.milestone = 'false';

          }

        }  // end of milestone function
        console.log(editors[index]);
        editorHTML += '<tr class = "table-rows"><td headers= "name" class = "col1 all-cells"><a class= tbl-link href=https://www.waze.com/user/editor/'
        + editors[index].name + '>' + editors[index].name + "</a>" + '</td><td headers = "level" class = "col2">' + editors[index].rank
         + '</td><td headers = "locked" class = "col3"><input type = "checkbox" /><td headers="began" class = "col4">' + startDate + '</td><td headers="total-edits" '
         + 'class = "col5">' + editors[index].totalEdits
         + '</td>' + '<td headers="milestone" class = "col6">' + mileStr + '</td><td headers="rate" class = "col7">' + rate + '</td>'
         + '<td headers="msDate" class = "col8">' + editors[index].milliFirstEditDate + '</td></tr>';
console.log('editor HTML follows:')
          console.log(`<tr class = "table-rows"><td headers= "name" class = "col1 all-cells"><a class= tbl-link href=https://www.waze.com/user/editor/
${editors[index].name} >  ${editors[index].name}  "</a>"  </td><td headers = "level" class = "col2"> ${editors[index].rank}
</td><td headers = "locked" class = "col3"><input type = "checkbox" /><td headers="began" class = "col4"> ${startDate} </td><td headers="total-edits"
class = "col5"> ${editors[index].totalEdits}
</td><td headers="milestone" class = "col6"> ${mileStr} </td><td headers="rate" class = "col7"> ${rate}  </td>
`);
      } // end of addStatsToTable

      var closingHTML ='</tbody></table></div>';
console.log('regionEditorsHTML is ' + regionEditorsHTML);
        console.log('editorHTML is ' + editorHTML);
        console.log('closingHTML is ' + closingHTML);
      $('#editing-activity').append(regionEditorsHTML + editorHTML + closingHTML);
 //     $('#header').after(regionEditorsHTML + editorHTML + closingHTML);
      $('.tbl-link').attr('target', '_blank');
      $('.table-area1').css({"display": "inline-block", "max-height": "500px", "overflow": "auto"});
      $('#the-head').css({"max-height": "50px","display":"table-header-group","margin-bottom":"5px"});
      $('#theTable-body').css({"max-height":  "500px","margin-bottom":"50px"});
      $('#region-table').css({"table-layout": "fixed", "width": "100%","white-space": "nowrap", "border": "3","border-style": "solid","border-collapse": "collapse"});
      $('.all-cells').css({"white-space": "nowrap", "overflow": "hidden", "text-overflow": "ellipsis"});
       $('.col1').css({"width":"20px"});
       $('.col2').css({"width":"25px"});
       $('.col3').css({"width":"25px"});
       $('.col4').css({"width":"30px"});
       $('.col5').css({"width":"35px"});
       $('.col6').css({"width":"30px"});
       $('.col7').css({"width":"30px"});
       $('.col8').css({"width":"20px", "display": "none"});
       $('.table-rows').css({"border": "solid thin"});
       $('.columz').attr('title', 'Click to sort.  After the sort is complete, a second click will sort in reverse order.');
       $('#total-editors').html(`Total Editors: ${totalEditors} (L1: ${L1Editors}, L2: ${L2Editors}, L3: ${L3Editors}, L4: ${L4Editors}, L5: ${L5Editors})`);
       $('#regions-edits').html(`Total Edits last 90 days... (L1: ${L1Edits.toLocaleString()}, L2: ${L2Edits.toLocaleString()}, L3: ${L3Edits.toLocaleString()}, L4: ${L4Edits.toLocaleString()}, L5: ${L5Edits.toLocaleString()})`);
//        console.log('getting rid of undefinedNaN');
    //   var goodText = document.getElementsByClassName('table-area1')[0].textContent.replace('undefinedNaN','');
    //   document.getElementsByClassName('table-area1')[0].textContent = goodText;
     //  console.log("first discord editor name is " + discordEditors[0]);
    //  console.log('finished building table');
      var nameAscending = false;
      var levelAscending = false;
      var startAscending = false;
      var totalAscending = false;
      var milestoneAscending = false;
      var rateAscending = false;
      var lockedAscending = false;
      //document.getElementById("save-locked").disabled = true;
      document.getElementById("name").addEventListener("click",function() {
        if (nameAscending) {
          nameAscending = false;
        } else {
          nameAscending = true;
        }
        sort(nameAscending,'col1','region-table');
      },false);
      document.getElementById("level").addEventListener("click",function() {
        if (levelAscending) {
          levelAscending = false;
        } else {
          levelAscending = true;
        }
        sort(levelAscending, 'col2', 'region-table');
      },false);
      document.getElementById("began").addEventListener("click",function() {
        if (startAscending) {
          startAscending = false;
        } else {
          startAscending = true;
        }
        sort(startAscending, 'col8','region-table');
      },false);
      document.getElementById("sort-locked").addEventListener("click", function() {
          if (lockedAscending) {
              lockedAscending = false;
          } else {
              lockedAscending = true;
          }
          sort(startAscending, 'col3', 'region-table');
      }, false);
      document.getElementById("total-edits").addEventListener("click",function() {
        if (totalAscending) {
          totalAscending = false;
        } else {
          totalAscending = true;
        }
        sort(totalAscending,'col5','region-table');
      },false);
      document.getElementById("milestone").addEventListener("click",function() {
        if(milestoneAscending) {
          milestoneAscending = false;
        } else {
          milestoneAscending = true;
        }
        sort(milestoneAscending, 'col6', 'region-table');
      },false);
      document.getElementById("rate").addEventListener("click",function(){
        if (rateAscending) {
          rateAscending = false;
        } else {
          rateAscending = true;
        }
        sort(rateAscending, 'col7', 'region-table');
      },false);
      function sort(ascending, columnClassName, tableId)
      {
          var tbody = document.getElementById(tableId).getElementsByTagName(
                  "tbody")[0];
          var rows = tbody.getElementsByTagName("tr");

          var unsorted = true;

          while (unsorted) {
              unsorted = false;

              for (var r = 0; r < rows.length - 1; r++) {
                  var row = rows[r];
                  var nextRow = rows[r + 1];
                  if(columnClassName !== 'col3') {
                      var value = row.getElementsByClassName(columnClassName)[0].innerHTML;
                      var nextValue = nextRow.getElementsByClassName(columnClassName)[0].innerHTML;

                      value = value.replace(',', '.'); // in case a comma is used in float number
                      nextValue = nextValue.replace(',', '.');

                      if (!isNaN(value)) {
                          value = parseFloat(value);
                          nextValue = parseFloat(nextValue);
                      }
                  } else { // element is a checkbox
                      var chk= row.getElementsByClassName(columnClassName)[0];
                      var nextChk = nextRow.getElementsByClassName(columnClassName)[0];
                      if(chk.querySelector("input[type=checkbox]") !== null) { // checkbox case
                          value = chk.querySelector('input[type=checkbox]');
                          nextValue = nextChk.querySelector("input[type=checkbox]").checked;
                      }
                  }

                  if (ascending ? value > nextValue : value < nextValue) {
                      tbody.insertBefore(nextRow, row);
                      unsorted = true;
                  }
              } // end of for
          } // end of while
      } //end of sort function

        document.getElementById("save-locked").addEventListener("click",storageSave);

        function storageSave()
        {
            lockedArray = [];
            localStorage.setItem('lockedEditors', JSON.stringify(lockedArray));
            var a = $('.col3 input:checked').map(function() {
                return $(this).closest('tr').find('td:eq(0)').text();
            }).get();
            if (a.length>0) {
                a.forEach(function (element, index, array) {
                    lockedArray.push(array[index]);
                });
            }
            localStorage.setItem('lockedEditors', JSON.stringify(lockedArray));
        } // end of storageSave
        addLockedEditors();
        function addLockedEditors()
        {
            if(lockedArray.length > 0) {
                lockedArray.forEach(function (element, index, array) {
 //                   console.log(array[index]);
                    var $chkbox = $($('#region-table tr').filter(function(){
                        return $.trim($('td', this).eq(0).text())== array[index];
                    }).find('input[type="checkbox"]'))
                    $chkbox[0].checked = true;
                });
            }
        }
    } // end of buildWebDisplay

      // NO LONGER USED:**********************************************************
    function makeCSV(arr)
    {
//console.log('array length for download file is ' + arr.length);
      var csvContent="";
      arr.forEach(function(element, index, array) {
          if (csvContent !== '') {
            csvContent += '\n';
          }

          csvContent += array[index].name + ',' + new Date(array[index].firstEditDate)+ ',' + array[index].lastEditDate + ','
          + array[index].rank + ',' + array[index].totalEdits + ',' + 'none';
      });
      var linkElement= document.createElement('a');
      linkElement.setAttribute("id", "csv-download");
      var encodedUri=encodeURI(csvContent);
      linkElement.setAttribute('href', "data:text/csv;charset=utf-8," + encodedUri);
      linkElement.innerHTML= "Download SER Editor CSV file";
      document.getElementById("csv-info").appendChild(linkElement);
      document.getElementById("import-csv").disabled = true;
    }



  } // end of executionSequence





bootstrap();
})();

QingJ © 2025

镜像随时可能失效,请加Q群300939539或关注我们的公众号极客氢云获取最新地址