action hook Admin Stats for WHMCS v8

Kian · October 7, 2020

As you probably know WHMCS v8 no longer provides statistics on top of the page about pending orders, overdue invoices and tickets awaiting reply. This action hook adds them back to interface as you can see from the following screenshot.

whmcs-admin-bar-stats-navbar.png.1f7385f7ff0db01d926957803630be29.png

whmcs-admin-bar-stats-sidebar.png.ffdcd9881207925aea2ea5487650eaab.png

This badge is fully responsive and appears if there's at least one pending order, overdue invoice or ticket awaiting reply. If there's nothing to show it disappears. To avoid any possibility of confusion, the hook automatically detects if you're running v8.

Get the Code »

volex · December 30, 2020

Thanks, this is very useful, I just updated to v8 and was disappointed to see that the pending orders/tickets had been hidden making it more work for admins!

I wondered if there was a way to change it so that it doesn't show the Overdue Invoices just keeps the Pending Orders and Tickets?

I did have a go at this but ended up with some whitespace left over.

Easy Green Hosting · March 1, 2025

Hi there. That script is very useful! Thanks.

I've added a little modification.
This script will not show a notification for the invoices that are due the same day, but not expired yet.
All the best

<?php

/**
 * Admin Stats for WHMCS v8
 *
 * @package     WHMCS
 * @copyright   Katamaze
 * @link        https://katamaze.com
 * @author      Davide Mantenuto <info@katamaze.com>
 */

use WHMCS\Database\Capsule;

add_hook('AdminAreaHeaderOutput', 1, function($vars)
{
    $v8 = Capsule::select(Capsule::raw('SELECT value FROM tblconfiguration WHERE setting = "Version" LIMIT 1'))[0]->value;
    if (explode('.', $v8)[0] != '8'): return; endif;
    $showZero = true;

    $ordersTotal = Capsule::select(Capsule::raw('SELECT COUNT(t1.id) AS total FROM tblorders AS t1 LEFT JOIN tblorderstatuses AS t2 ON t1.status = t2.title WHERE t2.showpending = "1"'))[0]->total;
$invoicesTotal = Capsule::select(Capsule::raw('
    SELECT COUNT(id) AS total 
    FROM tblinvoices 
    WHERE status = "Unpaid" 
    AND duedate < CURDATE()
'))[0]->total;
    $ticketsTotal = Capsule::select(Capsule::raw('SELECT COUNT(t1.id) AS total FROM tbltickets AS t1 LEFT JOIN tblticketstatuses AS t2 ON t1.status = t2.title WHERE t2.showawaiting = "1" AND merged_ticket_id = "0"'))[0]->total;
    if (!$ordersTotal AND !$invoicesTotal AND !$ticketsTotal): return; endif;
    $notificationsLabel = AdminLang::trans('setup.notifications');
    $orderText = AdminLang::trans('stats.pendingorders');
    $invoiceText = AdminLang::trans('stats.overdueinvoices');
    $ticketText = AdminLang::trans('stats.ticketsawaitingreply');

    if ($ordersTotal OR $showZero)
    {
        $pendingOrdersJS = <<<HTML
        $('#v8fallback').next('ul').append('<li><a href="orders.php?status=Pending" data-toggle="tooltip" data-placement="bottom" title="{$orderText}" data-original-title="{$orderText}" style="word-wrap:break-word"><small><span class="ico-container"><i class="fad fa-shopping-cart"></i></span><span class="v8fallback">{$ordersTotal}</span> {$orderText}</small></a></li>');
HTML;
    }

    if ($invoicesTotal OR $showZero)
    {
        $overdueInvoicesJS = <<<HTML
        $('#v8fallback').next('ul').append('<li><a href="invoices.php?status=Overdue" data-toggle="tooltip" data-placement="bottom" title="{$invoiceText}" data-original-title="{$invoiceText}" style="word-wrap:break-word"><small><span class="ico-container"><i class="fad fa-sack-dollar"></i></span><span class="v8fallback">{$invoicesTotal}</span> {$invoiceText}</small></a></li>');
HTML;
    }

    if ($ticketsTotal OR $showZero)
    {
        $awaitingTicketsJS = <<<HTML
        $('#v8fallback').next('ul').append('<li><a href="supporttickets.php" data-toggle="tooltip" data-placement="bottom" title="{$ticketText}" data-original-title="{$ticketText}" style="word-wrap:break-word"><small><span class="ico-container"><i class="fad fa-question-circle"></i></span><span class="v8fallback">{$ticketsTotal}</span> {$ticketText}</small></a></li>');
HTML;
    }

    return <<<HTML
<script type="text/javascript">
$(document).on('ready', function() {
    $('ul.right-nav').first('li').prepend('<li class="bt has-dropdown"><a id="v8fallback" href="#"><div class="badge-container"><i class="fas fa-exclamation-triangle always"></i><span class="badge"><span class="fas fa-times"></span></span></div><span class="visible-sidebar">&nbsp;{$notificationsLabel}</span></a><ul class="drop-icons"></ul></li>');
    $("*[id=\'v8fallback\']").on("click", function(e) {
        e.preventDefault();
        $(e.currentTarget).parent("li").toggleClass("expanded");
    });
    {$pendingOrdersJS}
    {$overdueInvoicesJS}
    {$awaitingTicketsJS}
    $('#v8fallback').next('ul').css({"width": "340px", "left": "-134px"});
    $('span.v8fallback').css({"font-weight": "700"});
});
</script>
HTML;
});

Easy Green Hosting · February 26

just updated for whmcs 9

<?php

use WHMCS\Database\Capsule;

add_hook('AdminAreaHeaderOutput', 1, function ($vars) {

    $version = Capsule::table('tblconfiguration')
        ->where('setting', 'Version')
        ->value('value');

    $major = (int) explode('.', (string) $version)[0];

    if ($major < 8 || $major > 9) {
        return;
    }

    $showZero = true;

    $ordersTotal = (int) Capsule::selectOne(
        'SELECT COUNT(t1.id) AS total
         FROM tblorders AS t1
         LEFT JOIN tblorderstatuses AS t2 ON t1.status = t2.title
         WHERE t2.showpending = "1"'
    )->total;

    $invoicesTotal = (int) Capsule::selectOne(
        'SELECT COUNT(id) AS total
         FROM tblinvoices
         WHERE status = "Unpaid"
         AND duedate < CURDATE()'
    )->total;

    $ticketsTotal = (int) Capsule::selectOne(
        'SELECT COUNT(t1.id) AS total
         FROM tbltickets AS t1
         LEFT JOIN tblticketstatuses AS t2 ON t1.status = t2.title
         WHERE t2.showawaiting = "1"
         AND merged_ticket_id = "0"'
    )->total;

    if (!$ordersTotal && !$invoicesTotal && !$ticketsTotal) {
        return;
    }

    $notificationsLabel = AdminLang::trans('setup.notifications');
    $orderText = AdminLang::trans('stats.pendingorders');
    $invoiceText = AdminLang::trans('stats.overdueinvoices');
    $ticketText = AdminLang::trans('stats.ticketsawaitingreply');

    $pendingOrdersJS = '';
    $overdueInvoicesJS = '';
    $awaitingTicketsJS = '';

    if ($ordersTotal || $showZero) {
        $pendingOrdersJS = "\n$('#v8fallback').next('ul').append('<li><a href=\"orders.php?status=Pending\" data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"{$orderText}\" data-original-title=\"{$orderText}\" style=\"word-wrap:break-word\"><small><span class=\"ico-container\"><i class=\"fad fa-shopping-cart\"></i></span><span class=\"v8fallback\">{$ordersTotal}</span> {$orderText}</small></a></li>');\n";
    }

    if ($invoicesTotal || $showZero) {
        $overdueInvoicesJS = "\n$('#v8fallback').next('ul').append('<li><a href=\"invoices.php?status=Overdue\" data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"{$invoiceText}\" data-original-title=\"{$invoiceText}\" style=\"word-wrap:break-word\"><small><span class=\"ico-container\"><i class=\"fad fa-sack-dollar\"></i></span><span class=\"v8fallback\">{$invoicesTotal}</span> {$invoiceText}</small></a></li>');\n";
    }

    if ($ticketsTotal || $showZero) {
        $awaitingTicketsJS = "\n$('#v8fallback').next('ul').append('<li><a href=\"supporttickets.php\" data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"{$ticketText}\" data-original-title=\"{$ticketText}\" style=\"word-wrap:break-word\"><small><span class=\"ico-container\"><i class=\"fad fa-question-circle\"></i></span><span class=\"v8fallback\">{$ticketsTotal}</span> {$ticketText}</small></a></li>');\n";
    }

    return <<<HTML
<script>
(function($){
  $(function() {

    var \$rightNav = $('ul.right-nav').first();
    if (!\$rightNav.length) {
      return;
    }

    \$rightNav.prepend(
      '<li class="bt has-dropdown">' +
        '<a id="v8fallback" href="#">' +
          '<div class="badge-container">' +
            '<i class="fas fa-exclamation-triangle always"></i>' +
            '<span class="badge"><span class="fas fa-times"></span></span>' +
          '</div>' +
          '<span class="visible-sidebar">&nbsp;{$notificationsLabel}</span>' +
        '</a>' +
        '<ul class="drop-icons"></ul>' +
      '</li>'
    );

    $("#v8fallback").on("click", function(e) {
      e.preventDefault();
      $(e.currentTarget).parent("li").toggleClass("expanded");
    });

    {$pendingOrdersJS}
    {$overdueInvoicesJS}
    {$awaitingTicketsJS}

    $('#v8fallback').next('ul').css({"width":"340px","left":"-134px"});
    $('span.v8fallback').css({"font-weight":"700"});
  });
})(jQuery);
</script>
HTML;
});

Sign In

Katamaze

action hook Admin Stats for WHMCS v8

Recommended Posts

Kian

Link to comment

Share on other sites

volex

Link to comment

Share on other sites

Easy Green Hosting

Link to comment

Share on other sites

Easy Green Hosting

Link to comment

Share on other sites

Similar Content

Add Custom Field Automatically after Add Product

Add to invoice template a new table section

Can anyone help me use hcaptcha instead of recaptcha

action hook Conditional Support Departments

action hook Client Group Color in Ticket View for WHMCS v8

Recently Browsing 0 members

Browse

Latest Activity

Blog

Technical Support

Important Information