File Manager

X7ROOT File Manager

Current Path: /home/mysptejz/public_html/billing/modules/reports

home / mysptejz / public_html / billing / modules / reports /

ðŸ“ ..
ðŸ“„ affiliates_overview.php(2.59 KB)
ðŸ“„ aging_invoices.php(4.57 KB)
ðŸ“„ annual_income_report.php(3.26 KB)
ðŸ“„ client.php(4.66 KB)
ðŸ“„ client_sources.php(4.58 KB)
ðŸ“„ client_statement.php(6.88 KB)
ðŸ“„ clients.php(5.8 KB)
ðŸ“„ clients_by_country.php(2.22 KB)
ðŸ“„ credits_reviewer.php(6.06 KB)
ðŸ“„ customer_retention_time.php(9.07 KB)
ðŸ“„ daily_performance.php(4.96 KB)
ðŸ“„ direct_debit_processing.php(2.95 KB)
ðŸ“„ disk_usage_summary.php(3.19 KB)
ðŸ“„ domain_renewal_emails.php(6.09 KB)
ðŸ“„ domains.php(8.4 KB)
ðŸ“„ income_by_product.php(8.92 KB)
ðŸ“„ income_forecast.php(4.26 KB)
ðŸ“„ index.php(42 B)
ðŸ“„ invoices.php(10.36 KB)
ðŸ“„ monthly_orders.php(3.45 KB)
ðŸ“„ monthly_transactions.php(4.05 KB)
ðŸ“„ new_customers.php(4.36 KB)
ðŸ“„ pdf_batch.php(4.43 KB)
ðŸ“„ product_suspensions.php(1.55 KB)
ðŸ“„ promotions_usage.php(3.53 KB)
ðŸ“„ sales_tax_liability.php(5.65 KB)
ðŸ“„ server_revenue_forecasts.php(3.63 KB)
ðŸ“„ services.php(9.7 KB)
ðŸ“„ smarty_compatibility.php(4.35 KB)
ðŸ“„ ssl_certificate_monitoring.php(7.92 KB)
ðŸ“„ support_ticket_replies.php(2.23 KB)
ðŸ“„ ticket_feedback_comments.php(5.31 KB)
ðŸ“„ ticket_feedback_scores.php(4.5 KB)
ðŸ“„ ticket_ratings_reviewer.php(4.11 KB)
ðŸ“„ ticket_tags.php(2.99 KB)
ðŸ“„ top_10_clients_by_income.php(2.36 KB)
ðŸ“„ transactions.php(7.08 KB)
ðŸ“„ vat_moss.php(6.98 KB)

Editing: disk_usage_summary.php

<?php

use WHMCS\Database\Capsule;

if (!defined("WHMCS")) {
    die("This file cannot be accessed directly");
}

$reportdata["title"] = "Disk Space & Bandwidth Usage Summary";
$reportdata["description"] = "This report shows the Disk Space & Bandwidth Usage Statistics for hosting accounts";

$reportdata["tableheadings"] = array("Client Name/Domain","Disk Usage","Disk Limit","% Used","BW Usage","BW Limit","% Used");

if ($_GET["action"]=="updatestats") {
    require("../includes/modulefunctions.php");
    ServerUsageUpdate();
}

$results = Capsule::table('tblservers')
 ->orderBy('name', 'asc')
 ->get()
 ->all();
foreach ($results as $result) {
 $serverid = $result->id;
 $name = $result->name;
 $ipaddress = $result->ipaddress;
 $reportdata["tablevalues"][] = ["**{$name} - {$ipaddress}"];

$services = Capsule::table('tblhosting')
        ->select(
            'tblhosting.domain',
            'tblhosting.diskusage',
            'tblhosting.disklimit',
            'tblhosting.bwlimit',
            'tblhosting.bwusage',
            'tblhosting.domainstatus',
            'tblclients.firstname',
            'tblclients.lastname',
            'tblclients.companyname',
            'tblhosting.lastupdate'
        )
        ->join('tblclients', 'tblclients.id', '=', 'tblhosting.userid')
        ->where('tblhosting.server', '=', (int) $serverid)
        ->where('tblhosting.lastupdate', '!=', '0000-00-00 00:00:00')
        ->whereIn('domainstatus', ['Active', 'Suspended'])
        ->orderBy('tblhosting.domain', 'asc')
        ->get()
        ->all();
    foreach ($services as $service) {
        $name = "{$service->firstname} {$service->lastname}";
        $companyname = $service->companyname;
        if ($companyname != "") {
            $name .= " ({$companyname})";
        }

$domain = $service->domain;
        $diskusage = $service->diskusage;
        $disklimit = $service->disklimit;
        $bwusage = $service->bwusage;
        $bwlimit = $service->bwlimit;
        $lastupdate = $service->lastupdate;

if ($disklimit == "0") {
            $percentused = "N/A";
        } else {
            @$percentused = number_format((($diskusage / $disklimit) * 100), 0, '.', '');
        }
        if ($disklimit=="0") {
            $disklimit="Unlimited";
        }
        if ($bwlimit == "0") {
            $bwpercentused = "N/A";
        } else {
            @$bwpercentused = number_format((($bwusage / $bwlimit) * 100), 0, '.', '');
        }
        if ($bwlimit == "0") {
            $bwlimit = "Unlimited";
        }
        if ($percentused != "N/A") {
            $percentused .= "%";
        }
        if ($bwpercentused != "N/A") {
            $bwpercentused .= "%";
        }

$reportdata["tablevalues"][] = [
 "{$name} {$domain}",
 "{$diskusage} MB",
 "{$disklimit} MB",
 "{$percentused}",
 "{$bwusage} MB",
 "{$bwlimit} MB",
 "{$bwpercentused}"
 ];
 }
}

$data["footertext"] = "Disk Space Usage Stats Last Updated at "
 . fromMySQLDate($lastupdate, "time")
 . " - <a href=\"{$_SERVER["PHP_SELF"]}?report={$_GET["report"]}&action=updatestats\">Update Now</a>";

X7ROOT File Manager

Editing: disk_usage_summary.php

Upload File

Create Folder