#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 / x.logiq.digital / modules / reports /

216.73.216.80

Home

File domain_renewal_emails.php

<?php

use WHMCS\Carbon;
use WHMCS\Database\Capsule;
use WHMCS\Input\Sanitize;

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

if (!function_exists('getRegistrarsDropdownMenu')) {
    require(ROOTDIR . '/includes/registrarfunctions.php');
}

$reportdata["title"] = $aInt->lang('reports', 'domainRenewalEmailsTitle');

$userID = App::getFromRequest('userid');
$domain = App::getFromRequest('domain');
$range = App::getFromRequest('range');
$registrar = App::getFromRequest('registrar');
$print = App::getFromRequest('print');
/**
 * Replace the "None" string with the "Any" string
 */
$registrarList = str_replace(
    [
        $aInt->lang('global', 'none'),
    ],
    [
        $aInt->lang('global', 'any'),
    ],
    getRegistrarsDropdownMenu($registrar)
);
$registrarList = str_replace(' select-inline', '', $registrarList);

$reportdata["description"] = $aInt->lang('reports', 'domainRenewalEmailsDescription');

$reportHeader = '';
if (!$print) {
    $reportHeader = <<<REPORT_HEADER
<form method="post" action="reports.php?report={$report}">
    <div class="report-filters-wrapper">
        <div class="inner-container">
            <h3>Filters</h3>
            <div class="row">
                <div class="col-md-3 col-sm-6">
                    <div class="form-group">
                        <label for="inputFilterClient">{$aInt->lang('fields', 'client')}</label>
                        {$aInt->clientsDropDown($userID, '', 'userid', true)}
                    </div>
                </div>
                <div class="col-md-3 col-sm-6">
                    <div class="form-group">
                        <label for="inputFilterRegistrar">{$aInt->lang('fields', 'registrar')}</label>
                        {$registrarList}
                    </div>
                </div>
                <div class="col-md-3 col-sm-6">
                    <div class="form-group">
                        <label for="inputFilterDomain">{$aInt->lang('fields', 'domain')}</label>
                        <input type="text" name="domain" value="{$domain}" class="form-control" id="inputFilterDomain" placeholder="{$optionalText}">
                    </div>
                </div>
                <div class="col-md-3 col-sm-6">
                    <div class="form-group">
                        <label for="inputFilterDate">{$dateRangeText}</label>
                        <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="range"
                                   value="{$range}"
                                   class="form-control date-picker-search"
                                   data-opens="left"
                                   placeholder="{$optionalText}"
                            />
                        </div>
                    </div>
                </div>
            </div>
            <button type="submit" class="btn btn-primary">
                {$aInt->lang('global', 'apply')}
            </button>
        </div>
    </div>
</form>
REPORT_HEADER;
}
$reportdata["headertext"] = $reportHeader;

$reportdata["tableheadings"] = array(
    $aInt->lang('fields', 'client'),
    $aInt->lang('fields', 'domain'),
    $aInt->lang('fields', 'dateSent'),
    $aInt->lang('domains', 'reminder'),
    $aInt->lang('emails', 'recipients'),
    $aInt->lang('domains', 'sent'),
);

$typeMap = array(
    1 => $aInt->lang('domains', 'firstReminder'),
    2 => $aInt->lang('domains', 'secondReminder'),
    3 => $aInt->lang('domains', 'thirdReminder'),
    4 => $aInt->lang('domains', 'fourthReminder'),
    5 => $aInt->lang('domains', 'fifthReminder'),
);

# Report Footer Text - this gets displayed below the report table of data
$data["footertext"] = "";

$query = Capsule::table('tbldomainreminders')
    ->join(
        'tbldomains',
        'tbldomains.id',
        '=',
        'tbldomainreminders.domain_id'
    )
    ->join(
        'tblclients',
        'tblclients.id',
        '=',
        'tbldomains.userid'
    )
    ->select(
        [
            'tbldomainreminders.id AS reminder_id',
            'tbldomainreminders.date',
            'tbldomainreminders.type',
            'tbldomainreminders.days_before_expiry',
            'tbldomainreminders.recipients',
            'tblclients.firstname',
            'tblclients.lastname',
            'tblclients.companyname',
            'tbldomains.domain',
        ]
    )
    ->orderBy('reminder_id', 'desc');

$where = array();
if ($userID) {
    $query->where('tblclients.id', (int) $userID);
}
if ($domain) {
    $query->where('tbldomains.domain', Sanitize::encode($domain));
}
if ($range) {
    $dateRange = Carbon::parseDateRangeValue($range);
    $dateFrom = $dateRange['from']->toDateTimeString();
    $dateTo = $dateRange['to']->toDateTimeString();
    $query->whereBetween(
        'tbldomainreminders.date',
        [
            $dateFrom,
            $dateTo,
        ]
    );
}
if ($registrar) {
    $query->where('tbldomains.registrar', $registrar);
}

foreach ($query->get() as $data) {
    $data = (array) $data;
    $companyName = '';
    if ($data['companyname']) {
        $companyName = ' ' . $data['companyname'];
    }
    $client = sprintf(
        '%s %s%s',
        $data['firstname'],
        $data['lastname'],
        $companyName
    );
    $domain = $data['domain'];
    $date = $data['date'];
    $type = $typeMap[$data['type']];
    $recipients = $data['recipients'];
    $days_before_expiry = sprintf(
        $aInt->lang('domains', 'beforeExpiry'),
        $data['days_before_expiry']
    );
    if ($data['days_before_expiry'] < 0) {
        $days_before_expiry = sprintf(
            $aInt->lang('domains', 'afterExpiry'),
            ($data['days_before_expiry'] * -1)
        );
    }
    $reportdata["tablevalues"][] = array(
        $client,
        $domain,
        $date,
        $type,
        $recipients,
        $days_before_expiry
    );
}

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

~ ACUPOFTEA - frochicken.com