#acupoftea - frochicken.com

System	:	Linux ts5.whitelabelverse.com 5.14.0-570.23.1.el9_6.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Jun 24 11:27:16 EDT 2025 x86_64
Software	:	LiteSpeed
Server	:	103.163.247.115
Domains	:	Cant read /etc/named.conf
Permission	:	[ drwxr-xr-x ]
	:	/ home / ezzecare / try.logiq.digital / modules / reports /

216.73.216.80

Home

File domains.php

<?php

use WHMCS\Carbon;
use WHMCS\Database\Capsule;

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

$reportdata["title"] = "Domains";

$filterfields = [
    'id' => 'ID',
    'userid' => 'User ID',
    'clientname' => 'Client Name',
    'orderid' => 'Order ID',
    'type' => 'Reg Type',
    'domain' => 'Domain Name',
    'firstpaymentamount' => 'First Payment Amount',
    'recurringamount' => 'Recurring Amount',
    'registrationperiod' => 'Registration Period',
    'registrationdate' => 'Registration Date',
    'expirydate' => 'Expiry Date',
    'nextduedate' => 'Next Due Date',
    'registrar' => 'Registrar',
    'paymentmethod' => 'Payment Method',
    'status' => 'Status',
    'additionalnotes' => 'Notes'
];

$dateRangeFields = [
    'registrationdate' => 'Registration Date',
    'expirydate' => 'Expiry Date',
    'nextduedate' => 'Next Due Date',
];

$removedDateRangeFields = array_diff($filterfields, $dateRangeFields);

$reportdata["description"] = $reportdata["headertext"] = '';

$incfields = $whmcs->get_req_var('incfields');
$filterfield = $whmcs->get_req_var('filterfield');
$filtertype = $whmcs->get_req_var('filtertype');
$filterq = $whmcs->get_req_var('filterq');

$regDateRange = App::getFromRequest('regDateRange');
$expiryDateRange = App::getFromRequest('expiryDateRange');
$nextDueDateRange = App::getFromRequest('nextDueDateRange');

if (!is_array($incfields)) {
    $incfields = [];
}
if (!is_array($filterfield)) {
    $filterfield = [];
}
if (!is_array($filtertype)) {
    $filtertype = [];
}
if (!is_array($filterq)) {
    $filterq = [];
}

if (!$print) {
    $reportdata["description"] = "This report can be used to generate a custom export of domains"
        . " by applying up to 5 filters. CSV Export is available via the Tools menu to the right.";

$reportdata["headertext"] = '<form method="post" action="reports.php?report=' . $report . '">
<table class="form" width="100%" border="0" cellspacing="2" cellpadding="3">
<tr><td width="20%" class="fieldlabel">Fields to Include</td><td class="fieldarea"><table width="100%"><tr>';
    $i=0;
    foreach ($filterfields as $k => $v) {
        $reportdata["headertext"] .= '<td width="20%"><input type="checkbox" name="incfields[]" value="' . $k . '" id="fd' . $k . '"';
        if (in_array($k, $incfields)) {
            $reportdata["headertext"] .= ' checked';
        }
        $reportdata["headertext"] .= ' /> <label for="fd' . $k . '">'.$v.'</label></td>';
        $i++;
        if (($i%5)==0) {
            $reportdata["headertext"] .= '</tr><tr>';
        }
    }
    $reportdata["headertext"] .= '</tr></table></td></tr>';

for ($i = 1; $i <= 5; $i ++) {
        $reportdata["headertext"] .= '<tr><td width="20%" class="fieldlabel">Filter ' . $i . '</td><td class="fieldarea"><select name="filterfield[' . $i . ']" class="form-control select-inline"><option value="">None</option>';
        foreach ($removedDateRangeFields as $k => $v) {
            $reportdata["headertext"] .= '<option value="' . $k . '"';
            if (isset($filterfield[$i]) && $filterfield[$i] == $k) {
                $reportdata["headertext"] .= ' selected';
            }
            $reportdata["headertext"] .= '>'.$v.'</option>';
        }
        $reportdata["headertext"] .= '</select> <select name="filtertype[' . $i . ']" class="form-control select-inline">'
            . '<option value="=">Exact Match</option><option value="like"';
        if (isset($filtertype[$i]) && $filtertype[$i] == "like") {
            $reportdata["headertext"] .= ' selected';
        }
        $reportdata["headertext"] .= '>Containing</option></select>'
            . ' <input type="text" name="filterq[' . $i . ']" class="form-control select-inline input-250" value="' . (isset($filterq[$i]) ? $filterq[$i] : '') . '" /></td></tr>';
    }

$reportdata["headertext"] .= <<<HTML
        <tr>
            <td width="20%" class="fieldlabel">Registration Date Range</td>
            <td class="fieldarea">
                <div class="form-group date-picker-prepend-icon">
                    <label for="inputFilterDate" class="field-icon">
                        <i class="fal fa-calendar-alt"></i>
                    </label>
                    <input id="inputFilterDate"
                           type="text"
                           name="regDateRange"
                           value="{$regDateRange}"
                           class="form-control date-picker-search"
                    />
                </div>
            </td>
        </tr>
        <tr>
            <td width="20%" class="fieldlabel">Expiry Date Range</td>
            <td class="fieldarea">
                <div class="form-group date-picker-prepend-icon">
                    <label for="inputFilterDate" class="field-icon">
                        <i class="fal fa-calendar-alt"></i>
                    </label>
                    <input id="inputFilterDate"
                           type="text"
                           name="expiryDateRange"
                           value="{$expiryDateRange}"
                           class="form-control date-picker-search"
                    />
                </div>
            </td>
        </tr>
        <tr>
            <td width="20%" class="fieldlabel">Next Due Date Range</td>
            <td class="fieldarea">
                <div class="form-group date-picker-prepend-icon">
                    <label for="inputFilterDate" class="field-icon">
                        <i class="fal fa-calendar-alt"></i>
                    </label>
                    <input id="inputFilterDate"
                           type="text"
                           name="nextDueDateRange"
                           value="{$nextDueDateRange}"
                           class="form-control date-picker-search"
                    />
                </div>
            </td>
        </tr>
    </table>
    <p align="center"><input type="submit" value="Filter" class="btn btn-primary"/></p>
</form>
HTML;
}

if (count($incfields)) {
    $query = Capsule::table('tbldomains');

foreach ($filterfield as $i => $val) {
        if ($val && array_key_exists($val, $filterfields)) {
            if ($filtertype[$i] == 'like') {
                $filterq[$i] = "%{$filterq[$i]}%";
            }
            if ($val == 'clientname') {
                $query->whereRaw(
                    "concat(tblclients.firstname, ' ', tblclients.lastname) "
                    . "{$filtertype[$i]} '{$filterq[$i]}'"
                );
            } else {
                $query->where(
                    "tbldomains.{$filterfield[$i]}",
                    $filtertype[$i],
                    $filterq[$i]
                );
            }
        }
    }

foreach ($incfields as $fieldname) {
        if (array_key_exists($fieldname, $filterfields)) {
            $reportdata["tableheadings"][] = $filterfields[$fieldname];
            if ($fieldname=="clientname") {
                $query->addSelect(Capsule::raw("concat(tblclients.firstname, ' ', tblclients.lastname)"));
            } else {
                $query->addSelect("tbldomains.{$fieldname}");
            }
        }
    }

if ($regDateRange) {
        $dateRange = Carbon::parseDateRangeValue($regDateRange);
        $fromdate = $dateRange['from']->toDateTimeString();
        $todate = $dateRange['to']->toDateTimeString();
        $query->whereBetween('registrationdate', [$fromdate, $todate]);
    }

if ($expiryDateRange) {
        $dateRange = Carbon::parseDateRangeValue($expiryDateRange);
        $fromdate = $dateRange['from']->toDateTimeString();
        $todate = $dateRange['to']->toDateTimeString();
        $query->whereBetween('expirydate', [$fromdate, $todate]);
    }

if ($nextDueDateRange) {
        $dateRange = Carbon::parseDateRangeValue($nextDueDateRange);
        $fromdate = $dateRange['from']->toDateTimeString();
        $todate = $dateRange['to']->toDateTimeString();
        $query->whereBetween('nextduedate', [$fromdate, $todate]);
    }

$results = $query
        ->join('tblclients', 'tblclients.id', '=', 'tbldomains.userid')
        ->get()
        ->all();

foreach ($results as $result) {
        $result = (array) $result;
        if (isset($result['registrar'])) {
            $result['registrar'] = ucfirst($result['registrar']);
        }
        if (isset($result['paymentmethod'])) {
            $result['paymentmethod'] = $gateways->getDisplayName($result['paymentmethod']);
        }
        $reportdata["tablevalues"][] = $result;
    }
}

Name	Type	Size	Permission	Last Modified	Actions
.	DIR	-	drwxr-xr-x	2025-06-02 03:31:08
..	DIR	-	drwxrwxr-x	2025-06-27 06:36:52
affiliates_overview.php	text/x-php	2.59 KB	-rw-r--r--	2025-06-02 03:31:08
aging_invoices.php	text/x-php	4.57 KB	-rw-r--r--	2025-06-02 03:31:08
annual_income_report.php	text/x-php	3.26 KB	-rw-r--r--	2025-06-02 03:31:08
client.php	text/x-php	4.66 KB	-rw-r--r--	2025-06-02 03:31:08
client_sources.php	text/x-php	4.58 KB	-rw-r--r--	2025-06-02 03:31:08
client_statement.php	text/x-php	6.88 KB	-rw-r--r--	2025-06-02 03:31:08
clients.php	text/x-php	5.8 KB	-rw-r--r--	2025-06-02 03:31:08
clients_by_country.php	text/x-php	2.22 KB	-rw-r--r--	2025-06-02 03:31:08
credits_reviewer.php	text/x-php	6.06 KB	-rw-r--r--	2025-06-02 03:31:08
customer_retention_time.php	text/x-php	9.07 KB	-rw-r--r--	2025-06-02 03:31:08
daily_performance.php	text/x-php	4.96 KB	-rw-r--r--	2025-06-02 03:31:08
direct_debit_processing.php	text/x-php	2.95 KB	-rw-r--r--	2025-06-02 03:31:08
disk_usage_summary.php	text/x-php	3.19 KB	-rw-r--r--	2025-06-02 03:31:08
domain_renewal_emails.php	text/x-php	6.09 KB	-rw-r--r--	2025-06-02 03:31:08
domains.php	text/x-php	8.4 KB	-rw-r--r--	2025-06-02 03:31:08
income_by_product.php	text/x-php	8.92 KB	-rw-r--r--	2025-06-02 03:31:08
income_forecast.php	text/x-php	4.26 KB	-rw-r--r--	2025-06-02 03:31:08
index.php	text/x-php	42 B	-rw-r--r--	2025-06-02 03:31:08
invoices.php	text/x-php	10.36 KB	-rw-r--r--	2025-06-02 03:31:08
monthly_orders.php	text/x-php	3.45 KB	-rw-r--r--	2025-06-02 03:31:08
monthly_transactions.php	text/x-php	4.05 KB	-rw-r--r--	2025-06-02 03:31:08
new_customers.php	text/x-php	4.36 KB	-rw-r--r--	2025-06-02 03:31:08
pdf_batch.php	text/x-php	4.43 KB	-rw-r--r--	2025-06-02 03:31:08
product_suspensions.php	text/x-php	1.55 KB	-rw-r--r--	2025-06-02 03:31:08
promotions_usage.php	text/x-php	3.53 KB	-rw-r--r--	2025-06-02 03:31:08
sales_tax_liability.php	text/x-php	5.65 KB	-rw-r--r--	2025-06-02 03:31:08
server_revenue_forecasts.php	text/x-php	3.63 KB	-rw-r--r--	2025-06-02 03:31:08
services.php	text/x-php	9.7 KB	-rw-r--r--	2025-06-02 03:31:08
smarty_compatibility.php	text/x-php	4.35 KB	-rw-r--r--	2025-06-02 03:31:08
ssl_certificate_monitoring.php	text/x-php	7.92 KB	-rw-r--r--	2025-06-02 03:31:08
support_ticket_replies.php	text/x-php	2.23 KB	-rw-r--r--	2025-06-02 03:31:08
ticket_feedback_comments.php	text/x-php	5.31 KB	-rw-r--r--	2025-06-02 03:31:08
ticket_feedback_scores.php	text/x-php	4.5 KB	-rw-r--r--	2025-06-02 03:31:08
ticket_ratings_reviewer.php	text/x-php	4.11 KB	-rw-r--r--	2025-06-02 03:31:08
ticket_tags.php	text/x-php	2.99 KB	-rw-r--r--	2025-06-02 03:31:08
top_10_clients_by_income.php	text/x-php	2.36 KB	-rw-r--r--	2025-06-02 03:31:08
transactions.php	text/x-php	7.08 KB	-rw-r--r--	2025-06-02 03:31:08
vat_moss.php	text/x-php	6.98 KB	-rw-r--r--	2025-06-02 03:31:08

~ ACUPOFTEA - frochicken.com