GitLab estimated time extractor.user.js

// ==UserScript==
// https://github.com/hannsen/userscripts
// @name         GitLab estimated time extractor
// @namespace    http://tampermonkey.net/
// @version      1.9
// @description  Extract time estimations from gitlab issues to the issue list, also copyable to Excel
// @author       hannsen
// @match        *://git04.quodata.de/*/*/issues*
// @match        *://git04.quodata.de/dashboard/issues*
// @require      https://code.jquery.com/jquery-3.1.1.min.js
// @downloadURL  https://git04.quodata.de/quodata/userscripts/-/raw/master/GitLab%20estimated%20time%20extractor.user.js
// @updateURL    https://git04.quodata.de/quodata/userscripts/-/raw/master/GitLab%20estimated%20time%20extractor.user.js
// @grant        none
// ==/UserScript==



(function() {
    'use strict';
    var header = ["Name","Assigned","Description","Time estimate","Milestone",
                  "Milestone start","Milestone due","URL","Due date","Labels", "Last updated", "Created at"];
    var toExportes = header.join("\t") + "\n";
    var hrefs = [];
    var pattIssue = /.*\/issues\/\d*$/i;
    $('.issues-list').find('a').each(function(){
        if($(this).attr('href').match(pattIssue)){
            $.ajax({
                url: $(this).attr('href'),
            }).done(function( data ) {

                var $data_json = $(data).find('div[data-noteable-data]').attr('data-noteable-data');
                var $json = JSON.parse($data_json);
                var time_estimate =  $json.human_time_estimate;

                var toExport = "";
                // title
                toExport += $json.title  + "\t";
                // assignee
                var assignee_name = $json.assignees[0] ? $json.assignees[0].name : "";
                toExport += assignee_name + "\t";
                //description
                var desc = $json.description;
                desc = desc.replace(/[\r\n]+/g, " ");
                desc = desc.replace(/\t/g, " ");
                toExport += desc + "\t";

                //time estimate
                toExport += (time_estimate || "") + "\t";
                // milestone name
                var milestone = $json.milestone ? $json.milestone.title : "";
                toExport += milestone + "\t";
                //milestone start
                toExport += ($json.milestone ? $json.milestone.start_date || "" : "" ) + "\t";
                //milestone due
                toExport += ($json.milestone ? $json.milestone.due_date || "" : "" ) + "\t";
                //url
                toExport += 'https://' + window.location.hostname + this.url + "\t";
                //due date
                toExport += ($json.due_date ? $json.due_date : '') + "\t";
                // labels
                var labelnames = [];
                for(var labelname in $json.labels){
                   labelnames.push( $json['labels'][labelname]['title']);
                }
                toExport += labelnames.join(', ') + "\t";
                // Last updated
                toExport += ($json.updated_at ? $json.updated_at : '') + "\t";
                // created_at
                toExport += ($json.created_at ? $json.created_at : '') + "\t";

                toExport += "\n";
                toExportes += toExport;
            });
        }
    });

    var $swipeButton = $('.btn.btn-default.has-tooltip').clone();
    $swipeButton.removeAttr('href').click( function(){
        copyToClipboard(toExportes); alert('Copied to clipboard, paste to Excel'); });
    $swipeButton.text('Copy issue info');
    $swipeButton.insertAfter('.btn.btn-default.has-tooltip');

    var copyToClipboard = str => {
        const el = document.createElement('textarea');
        el.value = str;
        document.body.appendChild(el);
        el.select();
        document.execCommand('copy');
        document.body.removeChild(el);
    };
})();