☰

PYS++

Display green cards for valid TACE

// ==UserScript==
// @name         PYS++
// @license      MIT
// @namespace    http://tampermonkey.net/
// @version      1.8
// @description  Display green cards for valid TACE
// @author       Matthieu Auger
// @match        https://app.pickyourskills.com/reporting/staffing_dashboard?view=user
// @match        https://app.pickyourskills.com/reporting/staffing_dashboard?view=user&tribe=lyon
// @match        https://app.pickyourskills.com/reporting/staffing_dashboard?view=user&tribe=kumo
// @icon         https://www.google.com/s2/favicons?domain=pickyourskills.com
// @grant        none
// @require      https://code.jquery.com/jquery-3.6.0.min.js
// @require      https://greasyfork.org/scripts/383527-wait-for-key-elements/code/Wait_for_key_elements.js?version=701631
// ==/UserScript==

(function() {
    'use strict';

    var $ = window.jQuery;
    var currentWeekNumber = getCurrentWeekNumber();
    var currentYear = new Date().getFullYear();

    var displayExceedingTacesInOrange = false;
    var displayWeekStandard = false;
    var defaultTaces = {
        Dev: 100,
        Sales: 0,
        'Growth Team': 0,
        Architecte: 90,
        'Head of Tribe': 0,
        'VP Tech': 50,
        'CA / PO': 100,
        'DP / PM / AM': 100,
        'Externe': 0
    }

    var tacesByTribe = {
        'Theodo Lyon': {
            ...defaultTaces,
            'Head of Tribe': 50,
            'CA / PO': 50,
            'DP / PM / AM': 50
        },
        'Kumo': {
            ...defaultTaces,
            Dev: 90,
            Architecte: 80
        }
    }

    var defaultWeekStandard = 9;
    var weekStandardByTribe = {
        'Theodo Lyon': 9,
        'Kumo': 3,
    }

    const urlParams = new URLSearchParams(window.location.search);
    if (urlParams.get('tribe') === 'kumo') {
        displayExceedingTacesInOrange = true;
        displayWeekStandard = true;
    }

    if (urlParams.get('tribe') === 'lyon') {
        displayWeekStandard = true;
    }



    function colorizeRowBasedOnStaffingAndTace(jNode) {
        var role = jNode.find('[label=Position]').text();
        var tribe = jNode.find('[label=Tribe]').text();

        jNode.find('div.cell.main_cell[width=85] > div > div').each(function(jNode) {
            var staffing = $(this).text();

            if (staffing.endsWith('%')) {
                var staffingNumber = parseInt(staffing.slice(0, -1));

                var taces = defaultTaces;
                if (tribe in tacesByTribe) {
                    taces = tacesByTribe[tribe];
                }

                if (staffingNumber === taces[role]) {
                    displayGreen($(this));
                } else if (staffingNumber > taces[role]) {
                    if (displayExceedingTacesInOrange) {
                        displayOrange($(this));
                    } else {
                        displayGreen($(this));
                    }
                } else {
                    displayRed($(this));
                }
            }

            if (displayWeekStandard) {
                // we want to add a border x weeks after current and works even with new years, hence the modulo
                var weekStandard = defaultWeekStandard;
                if (tribe in weekStandardByTribe) {
                    weekStandard = weekStandardByTribe[tribe];
                }
                var weekNumberInStandard = currentWeekNumber + weekStandard;

                var yearNumberInStandard = currentYear;
                if (weekNumberInStandard > 52) {
                    weekNumberInStandard = weekNumberInStandard % 52;
                    yearNumberInStandard++
                }

                var twoDigitsWeekStandard = ("0" + weekNumberInStandard).slice(-2);

                if ($(this).parent().data('cy') === 'date-' + yearNumberInStandard + '-W' + twoDigitsWeekStandard) {
                    $(this).parent().css('border-right', '3px solid orange');
                }
            }
        });

    }

    function getCurrentWeekNumber() {
        var today = new Date();
        var d = new Date(Date.UTC(today.getFullYear(), today.getMonth(), today.getDate()));
        var dayNum = d.getUTCDay() || 7;
        d.setUTCDate(d.getUTCDate() + 4 - dayNum);
        var yearStart = new Date(Date.UTC(d.getUTCFullYear(),0,1));
        return Math.ceil((((d - yearStart) / 86400000) + 1)/7)
    }

    function displayGreen(_this) {
        _this.css('color', 'rgb(112, 215, 98)');
        _this.css('background-color', 'rgba(112, 215, 98, 0.1)');
    }

    function displayOrange(_this) {
        _this.css('color', 'rgb(255, 165, 0)');
        _this.css('background-color', 'rgba(255, 165, 0, 0.1)');
    }

    function displayRed(_this) {
        _this.css('color', 'rgb(219, 40, 40)');
        _this.css('background-color', 'rgba(219, 40, 40, 0.1)');
    }

    waitForKeyElements("#individual_staffing_reporting_table_export .row", colorizeRowBasedOnStaffingAndTace);
})();