Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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 = '';
- ............................................................
- ................................
- .............
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement