action hook Admin Stats for WHMCS v8

[Kian]

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.

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]

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]

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]

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;
});