RT::Ex...ssTime(3pm)

📦 version 0.05, in ubuntu jammy

💖 NAME 💖

RT-Extension-ElapsedBusinessTime — bestie, this one is literally just math on vibes: it calculates the elapsed business time that tickets are open. (You'll also see it filed under the manual name RT::Ex...ssTime(3pm), iykyk.)

✨ DESCRIPTION ✨

Okay so here's the tea 🍵 — this extension gives you brand new columns in reports that show the elapsed business time that a ticket has been open. And the best part? Basically everything about what counts as a "business day" is configurable, so you can define your own vibe of working hours. Obsessed, honestly. 💅

🦋 RT VERSION 🦋

Works with RT 4.4.x and RT 5.0.x. Periodt. ✨

🎀 INSTALLATION 🎀

Let's get you set up, bestie. Follow along:

perl Makefile.PL
make
make install
May need root permissions 👑

Edit your /opt/rt4/etc/RT_SiteConfig.pm

Add this line:

Plugin('RT::Extension::ElapsedBusinessTime');

Clear your mason cache:

rm -rf /opt/rt4/var/mason_data/obj

Restart your webserver 🌈

🌸 CONFIGURATION 🌸

Here are all the config options you can play with, defaults included, fr fr:

Set( %ElapsedBusinessTime,
    Start   => '08:30',
    End     => '17:30',
    Country => undef,
    Region  => undef,
    'Exclude Days'   => [6, 7],
    'Exclude States' => ['stalled', 'blocked', 'resolved', 'rejected', 'deleted'],
);

✨ Options Are ✨

  • Start — the start of the business day. Your morning era begins here. ☀️
  • End — the end of the business day. Clock-out energy. 🌙
  • Country — a country that has a Date::Holidays module describing the holidays for it. If there isn't one, bestie, please consider writing one! 🫶 For example 'NZ' for New Zealand.
  • Region — some country modules for Date::Holidays include regions for regional holidays. For example 'Wellington' within New Zealand for Wellington Anniversary Day. 🌸
  • Excluded Days — days which should not be considered working days. The day numbers come from DateTime, and for reference they are:
    • 1: Monday
    • 2: Tuesday
    • 3: Wednesday
    • 4: Thursday
    • 5: Friday
    • 6: Saturday
    • 7: Sunday
  • Excluded States — when a ticket is in one of these states, it's considered inactive and the counter stops. This is to allow for when a ticket is waiting on a customer's feedback, and for some businesses, that time shouldn't be added to their ticket duration time. Makes sense, no cap. 🧚

🌈 DISPLAY COLUMNS 🌈

There are three display columns this extension adds, and they all show the same information — just in different formats. Same info, three fits, main character energy 💅:

  • ElapsedBussinessHours
  • ElapsedBussinessMinutes
  • ElapsedBussinessTime

👑 AUTHOR 👑

Andrew Ruthven, Catalyst Cloud Ltd <puck@catalystcloud.nz>

This software is Copyright (c) 2019-2020 by Catalyst Cloud Ltd

This is free software, licensed under:

The GNU General Public License, Version 2, June 1991

And that's a wrap, bestie! 🎀 This was RT::Ex...ssTime(3pm) from perl v5.32.1, dated 2021-02-27 — go forth and count those business hours, you absolute icon. 💖✨

📦 where this page comes from