User:Enterprisey/Tenures at RfA

// use on [[Wikipedia:Requests for adminship by year]]
$(function(){
    $('div.navbox,div#toc').remove();
    $('#mw-content-text ul').first().remove();
    $('#mw-content-text h2').first().remove();
    $('#mw-content-text h2').first().remove();
    $('#mw-content-text p').first().remove();
    $('#mw-content-text div.thumb').first().remove();
    $('thead').remove();
    $('th sup').each(function(_i,e){
        $(e).remove();//$(e).replaceWith('#'+e.textContent);
    });
    $('a.mw-collapsible-text').click();
    $('table.mw-collapsible > tbody > tr > th').parent().remove();
    $('table.wikitable tr').each(function(_i,e){
        if(!e.textContent.includes('Successful'))$(e).remove();
    });
    var rfaDates = {};
    var usernames = $('table.wikitable').slice(0,6).find('tr').map(function(_i,e){
        var username = $(e).find('th').get(0).textContent.trim();
        if(rfaDates[username]){
            // dupe...
            console.log(e);
            throw(username + ',' + rfaDates[username] + ',');
        }
        rfaDates[username]=$(e).find('td').get(2).textContent.trim();
    }).get();
    console.log(rfaDates.length);
    var graphData = [];
    new mw.Api().get({
        action:'query',
        list:'users',
        usprop:'registration',
        ususers:Object.keys(rfaDates).join('|')
    }).then(function(data){
        data.query.users.forEach(function(user){
            var rfaDate = rfaDates[user.name];
            var regDate;
            if(!user.registration){
                if(user.name==='Ashleyyoursmile'){
                    regDate = '2019-12-13';
                }else if(user.name==='Creffett'){// -> GeneralNotability
                    regDate='2018-11-28';
                }else if(user.name==='Money emoji'){// -> Moneytrees
                    regDate='2018-03-16';
                }else if(user.name==='Muboshgu'){// too old to have a registration date. scary...
                    regDate='2005-11-22';
                }else{
                    throw new Error(user.name);
                }
            }else{
                regDate = user.registration.substring(0,10);
            }
            var diff=(Date.parse(rfaDate)-Date.parse(regDate))/(1000*60*60*24*365.25);
            graphData.push([rfaDate,diff]);
            console.log(user.name+','+regDate+','+rfaDate+','+diff);
        });
        console.log(JSON.stringify(graphData));
    });
});