<?php
/**
*
* @	This file is created by http://DeZender.Net
* @	deZender (PHP5 Decoder for ionCube Encoder)
*
* @	Version			:	3.0.8.0
* @	Author			:	DeZender
* @	Release on		:	25.09.2017
* @	Official site	:	http://DeZender.Net
*
*/

function getClientsDetails($userid = '', $contactid = '')
{
	if (!($userid)) {
		$userid = $_SESSION['uid'];
	}

	$client = new \WHMCS\Client( $userid );
	$details = $client->getDetails( $contactid );
	return $details;
}

function getClientsStats($userid)
{
	global $CONFIG;
	global $currency;
	$currency = getCurrency( $userid );
	$stats = array(  );
	$result = full_query( 'SELECT COUNT(*),SUM(total)-COALESCE(SUM((SELECT SUM(amountin)-SUM(amountout) FROM tblaccounts WHERE tblaccounts.invoiceid=tblinvoices.id)),0),(SELECT SUM(amountin-fees-amountout) FROM tblaccounts WHERE userid=' . (int) $userid . '),(SELECT credit FROM tblclients WHERE id=' . (int) $userid . ') FROM tblinvoices WHERE userid=' . (int) $userid . ' AND status=\'Unpaid\' AND (select count(id) from tblinvoiceitems where invoiceid=tblinvoices.id and type=\'Invoice\')<=0' );
	$data = mysql_fetch_array( $result );
	$stats['numdueinvoices'] = $data[0];
	$stats['dueinvoicesbalance'] = formatCurrency( $data[1] );
	$stats['income'] = formatCurrency( $data[2] );
	$stats['incredit'] = ((0 < $data[3] ? true : false));
	$stats['creditbalance'] = formatCurrency( $data[3] );
	$result = full_query( 'SELECT COUNT(*),SUM(total)-COALESCE(SUM((SELECT SUM(amountin)-SUM(amountout) FROM tblaccounts WHERE tblaccounts.invoiceid=tblinvoices.id)),0) FROM tblinvoices WHERE userid=' . (int) $userid . ' AND status=\'Unpaid\' AND duedate<' . date( 'Ymd' ) . ' AND (select count(id) from tblinvoiceitems where invoiceid=tblinvoices.id and type=\'Invoice\')<=0' );
	$data = mysql_fetch_array( $result );
	$stats['numoverdueinvoices'] = $data[0];
	$stats['overdueinvoicesbalance'] = formatCurrency( $data[1] );
	$draftInvoices = \WHMCS\Database\Capsule::table( 'tblinvoices' )->selectRaw( 'COUNT(\'id\') as invoice_count,' . "\n" . '        SUM(total) - COALESCE(' . "\n" . '            SUM(' . "\n" . '                (' . "\n" . '                    SELECT SUM(amountin)-SUM(amountout) FROM tblaccounts WHERE tblaccounts.invoiceid=tblinvoices.id' . "\n" . '                )' . "\n" . '            ),' . "\n" . '            0' . "\n" . '        ) as balance' )->where( 'userid', '=', $userid )->where( 'status', '=', 'Draft' )->first(  );
	$stats['numDraftInvoices'] = $draftInvoices->invoice_count;
	$stats['draftInvoicesBalance'] = formatCurrency( $draftInvoices->balance );
	$invoicestats = array(  );
	$result = select_query( 'tblinvoices', 'status,COUNT(*),SUM(total)', 'userid=' . (int) $userid . ' GROUP BY status' );

	while ($data = mysql_fetch_array( $result )) {
		$invoicestats[$data[0]] = $data;
	}

	$stats['numpaidinvoices'] = ((isset( $invoicestats['Paid'][1] ) ? $invoicestats['Paid'][1] : 0));
	$stats['paidinvoicesamount'] = ((isset( $invoicestats['Paid'][2] ) ? formatCurrency( $invoicestats['Paid'][2] ) : formatCurrency( 0 )));
	$stats['numunpaidinvoices'] = ((isset( $invoicestats['Unpaid'][1] ) ? $invoicestats['Unpaid'][1] : 0));
	$stats['unpaidinvoicesamount'] = ((isset( $invoicestats['Unpaid'][2] ) ? formatCurrency( $invoicestats['Unpaid'][2] ) : formatCurrency( 0 )));
	$stats['numcancelledinvoices'] = ((isset( $invoicestats['Cancelled'][1] ) ? $invoicestats['Cancelled'][1] : 0));
	$stats['cancelledinvoicesamount'] = ((isset( $invoicestats['Cancelled'][2] ) ? formatCurrency( $invoicestats['Cancelled'][2] ) : formatCurrency( 0 )));
	$stats['numrefundedinvoices'] = ((isset( $invoicestats['Refunded'][1] ) ? $invoicestats['Refunded'][1] : 0));
	$stats['refundedinvoicesamount'] = ((isset( $invoicestats['Refunded'][2] ) ? formatCurrency( $invoicestats['Refunded'][2] ) : formatCurrency( 0 )));
	$stats['numcollectionsinvoices'] = ((isset( $invoicestats['Collections'][1] ) ? $invoicestats['Collections'][1] : 0));
	$stats['collectionsinvoicesamount'] = ((isset( $invoicestats['Collections'][2] ) ? formatCurrency( $invoicestats['Collections'][2] ) : formatCurrency( 0 )));
	$productstats = array(  );
	$result = full_query( 'SELECT tblproducts.type,domainstatus,COUNT(*) FROM tblhosting INNER JOIN tblproducts ON tblhosting.packageid=tblproducts.id WHERE tblhosting.userid=' . (int) $userid . ' GROUP BY domainstatus,tblproducts.type' );

	while ($data = mysql_fetch_array( $result )) {
		$productstats[$data[0]][$data[1]] = $data[2];
	}

	$stats['productsnumactivehosting'] = ((isset( $productstats['hostingaccount']['Active'] ) ? $productstats['hostingaccount']['Active'] : 0));
	$stats['productsnumhosting'] = 0;
	if (array_key_exists( 'hostingaccount', $productstats ) && is_array( $productstats['hostingaccount'] )) {
		foreach ($productstats['hostingaccount'] as $status => $count) {
			$stats['productsnumhosting'] += $count;
		}
	}

	$stats['productsnumactivereseller'] = ((isset( $productstats['reselleraccount']['Active'] ) ? $productstats['reselleraccount']['Active'] : 0));
	$stats['productsnumreseller'] = 0;
	if (array_key_exists( 'reselleraccount', $productstats ) && is_array( $productstats['reselleraccount'] )) {
		foreach ($productstats['reselleraccount'] as $status => $count) {
			$stats['productsnumreseller'] += $count;
		}
	}

	$stats['productsnumactiveservers'] = ((isset( $productstats['server']['Active'] ) ? $productstats['server']['Active'] : 0));
	$stats['productsnumservers'] = 0;
	if (array_key_exists( 'server', $productstats ) && is_array( $productstats['server'] )) {
		foreach ($productstats['server'] as $status => $count) {
			$stats['productsnumservers'] += $count;
		}
	}

	$stats['productsnumactiveother'] = ((isset( $productstats['other']['Active'] ) ? $productstats['other']['Active'] : 0));
	$stats['productsnumother'] = 0;
	if (array_key_exists( 'other', $productstats ) && is_array( $productstats['other'] )) {
		foreach ($productstats['other'] as $status => $count) {
			$stats['productsnumother'] += $count;
		}
	}

	$stats['productsnumactive'] = $stats['productsnumactivehosting'] + $stats['productsnumactivereseller'] + $stats['productsnumactiveservers'] + $stats['productsnumactiveother'];
	$stats['productsnumtotal'] = $stats['productsnumhosting'] + $stats['productsnumreseller'] + $stats['productsnumservers'] + $stats['productsnumother'];
	$domainstats = array(  );
	$result = select_query( 'tbldomains', 'status,COUNT(*)', 'userid=' . (int) $userid . ' GROUP BY status' );

	while ($data = mysql_fetch_array( $result )) {
		$domainstats[$data[0]] = $data[1];
	}

	$stats['numactivedomains'] = ((isset( $domainstats['Active'] ) ? $domainstats['Active'] : 0));
	$stats['numdomains'] = 0;

	foreach ($domainstats as $count) {
		$stats['numdomains'] += $count;
	}

	$quotestats = array(  );
	$result = select_query( 'tblquotes', 'stage,COUNT(*)', 'userid=' . (int) $userid . ' GROUP BY stage' );

	while ($data = mysql_fetch_array( $result )) {
		$quotestats[$data[0]] = $data[1];
	}

	$stats['numacceptedquotes'] = ((isset( $quotestats['Accepted'] ) ? $quotestats['Accepted'] : 0));
	$stats['numquotes'] = 0;

	foreach ($quotestats as $count) {
		$stats['numquotes'] += $count;
	}

	$statusfilter = array(  );
	$result = select_query( 'tblticketstatuses', 'title', array( 'showactive' => '1' ) );

	while ($data = mysql_fetch_array( $result )) {
		$statusfilter[] = $data[0];
	}

	$ticketstats = array(  );
	$result = select_query( 'tbltickets', 'status,COUNT(*)', 'userid=' . (int) $userid . ' AND merged_ticket_id = 0 GROUP BY status' );

	while ($data = mysql_fetch_array( $result )) {
		$ticketstats[$data[0]] = $data[1];
	}

	$stats['numactivetickets'] = $stats['numtickets'] = 0;

	foreach ($ticketstats as $status => $count) {
		if (in_array( $status, $statusfilter )) {
			$stats['numactivetickets'] += $count;
		}

		$stats['numtickets'] += $count;
	}

	$result = select_query( 'tblaffiliatesaccounts', 'COUNT(*)', array( 'clientid' => $userid ), '', '', '', 'tblaffiliates ON tblaffiliatesaccounts.affiliateid=tblaffiliates.id' );
	$data = mysql_fetch_array( $result );
	$stats['numaffiliatesignups'] = $data[0];
	$stats['isAffiliate'] = ((get_query_val( 'tblaffiliates', 'id', array( 'clientid' => (int) $userid ) ) ? true : false));
	return $stats;
}

/**
 * Creates a dropdown list of available countries.
 *
 * @param string $selected
 * @param string $fieldname
 * @param int $tabindex
 * @param bool $selectInline
 * @param bool $disable
 *
 * @return string
 */
function getCountriesDropDown($selected = '', $fieldname = '', $tabindex = '', $selectInline = true, $disable = false)
{
	global $CONFIG;
	global $_LANG;

	if (!($selected)) {
		$selected = $CONFIG['DefaultCountry'];
	}

	if (!($fieldname)) {
		$fieldname = 'country';
	}
	if ($tabindex) {
		$tabindex = ' tabindex="' . $tabindex . '"';
	}
	if ($disable) {
		$disable = ' disabled';
	}
	 else {
		$disable = '';
............................................................
................................
.............