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: client_sources.php

<?php

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

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

$reportdata["title"] = "Client Sources";
$reportdata["description"] = "This report provides a summary of the answers clients have given to the How Did You Find Us? or Where did you hear about us? custom field signup question";

$range = App::getFromRequest('range');
if (!$range) {
    $today = Carbon::today()->endOfDay();
    $lastWeek = Carbon::today()->subDays(6)->startOfDay();
    $range = $lastWeek->toAdminDateFormat() . ' - ' . $today->toAdminDateFormat();
}

$customfieldid = get_query_val("tblcustomfields","id",array("type"=>"client","fieldname"=>"How did you find us?"));
if (!$customfieldid) $customfieldid = get_query_val("tblcustomfields","id",array("type"=>"client","fieldname"=>"Where did you hear about us?"));

if (!$customfieldid && isset($_REQUEST['fieldname']) && isset($_REQUEST['options'])) {
    check_token('WHMCS.admin.default');
    $customfieldid = insert_query("tblcustomfields",array("type"=>"client","fieldname"=>$_REQUEST['fieldname'],"fieldtype"=>"dropdown","fieldoptions"=>$_REQUEST['options'],"showorder"=>"on"));
}

if (!$customfieldid) $reportdata["headertext"] = '<div style="margin:50px auto;width:50%;padding:15px;border:1px dashed #ccc;text-align:center;font-size:14px;">This report requires you to setup a custom field shown during the signup process with a name of "How Did You Find Us?" or "Where did you hear about us?" in order to collect this data from customers.<br /><br />You don\'t appear to have the custom field setup yet so we can do this now:<br /><br /><form method="post" action="reports.php?report=client_sources">Field Name: <select name="fieldname"><option>How did you find us?</option><option>Where did you hear about us?</option></select><br />Options: <input type="text" name="options" value="Google,Bing,Other Search Engine,Web Hosting Talk,Friend,Advertisement,Other" style="width:70%;" /><br /><br /><input type="submit" value="Create &raquo;" class="btn btn-primary" /></form></div>';
else {
    $reportdata['headertext'] = '';
    if (!$print) {
        $reportdata['headertext'] = <<<HTML
<form method="post" action="?report={$report}&currencyid={$currencyid}&calculate=true">
    <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="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"
                            />
                        </div>
                    </div>
                </div>
            </div>
            <button type="submit" class="btn btn-primary">
                {$aInt->lang('reports', 'generateReport')}
            </button>
        </div>
    </div>
</form>
HTML;
    }
}

$reportdata["tableheadings"][] = "Referral Location";
$reportdata["tableheadings"][] = "Count";

$dateRange = Carbon::parseDateRangeValue($range);
$fromdate = $dateRange['from']->toDateTimeString();
$todate = $dateRange['to']->toDateTimeString();

$results = Capsule::table('tblcustomfieldsvalues')
    ->select(Capsule::raw('tblcustomfieldsvalues.value, count(*) as `rows`'))
    ->join('tblclients', 'tblclients.id', '=', 'tblcustomfieldsvalues.relid')
    ->where('fieldid', '=', (int) $customfieldid)
    ->whereBetween(
        'datecreated',
        [
            $fromdate,
            $todate,
        ]
    )
    ->orderBy('value', 'asc')
    ->groupBy('value')
    ->get()
    ->all();

foreach ($results as $result) {
    $reportdata["tablevalues"][] = [$result->value, $result->rows];
    $chartdata['rows'][] = [
        'c' => [
            ['v' => $result->value],
            ['v' => $result->rows, 'f' => $result->rows],
        ],
    ];
}

$chartdata['cols'][] = array('label'=>'Referral Location','type'=>'string');
$chartdata['cols'][] = array('label'=>'Count','type'=>'number');

$args = array();
$args['legendpos'] = 'right';

if ($customfieldid) $reportdata["footertext"] = $chart->drawChart('Pie',$chartdata,$args,'300px');

X7ROOT File Manager

Editing: client_sources.php

Upload File

Create Folder