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

📦 version 0.05, in ubuntu noble

✨ NAME ✨

RT-Extension-ElapsedBusinessTime — the plugin that does the math on how much actual working time your tickets have been sitting open 💖

(it lives in the RT::Ex...ssTime(3pm) corner of the User Contributed Perl Documentation universe, bestie 🫶)

🦋 DESCRIPTION 🦋

okay so picture this: this extension drops brand new colummns into your reports that show the elapsed business time a ticket has been open. not wall-clock time, not "it's been open since Tuesday" vibes — business time. 💅

and because every business is built different, lots of stuff is configurable so you can define exactly what counts as a business day for you. no cap. ✨

🔥 RT VERSION 🔥

Works with RT 4.4.x and RT 5.0.x. periodt. 👑

🎀 INSTALLATION 🎀

Run these, in this order, and don't skip steps (iykyk):

perl Makefile.PL
make
make install
  • make install — may need root permissions, so like, be ready to sudo if it yells at you 🙈

Then edit your /opt/rt4/etc/RT_SiteConfig.pm and add this line:

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

Clear your mason cache (she's gotta forget everything she knew):

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

Restart your webserver. no seriously. restart it. it's giving mandatory. 💀

🌸 CONFIGURATION 🌸

here are all the available configuration options, with their defaults, served fresh:

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. when the day officially wakes up. ⭐
  • End — the end of the business day. when the day clocks out. 🦋
  • Country — a country for which there's a Date::Holidays module describing that country's holidays. If there isn't one for your country… please consider writing one! 👑 For example 'NZ' for New Zealand.
  • Region — some country modules for Date::Holidays also include regions for regional holidays. For example 'Wellington' within New Zealand, for Wellington Anniversary Day. 🎀
  • Excluded Days — the days that should NOT be considered working days. The day numbers come from DateTime. 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 exists so that when a ticket is waiting on a customer's feedback, that time doesn't get added to the ticket's duration time — which, for some businesses, is exactly the vibe they want. 💜

💅 DISPLAY COLUMNS 💅

There are three display columns this extension adds, and they all show the same information — just in different formats. same tea, different mugs ☕✨

  • ElapsedBussinessHours
  • ElapsedBussinessMinutes
  • ElapsedBussinessTime

🌈 AUTHOR 🌈

Andrew Ruthven, Catalyst Cloud Ltd <puck@catalystcloud.nz> — main character energy fr fr 💖

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
ok that's the whole page, bestie — go forth and calculate that business time 💅✨

and for the cute sign-off: this lil doc is from perl v5.36.0, dated 2023-09-26, filed under RT::Ex...ssTime(3pm). slay, bye 🫶🌸

📦 where this page comes from