title = $aInt->lang('offlineccp', 'title'); $aInt->sidebar = 'billing'; $aInt->icon = 'offlinecc'; $aInt->requiredFiles(array( 'clientfunctions', 'invoicefunctions', 'gatewayfunctions', 'ccfunctions' )); if( $processwindow ) { check_token("WHMCS.admin.default"); $result = select_query('tblinvoices', '', array( 'id' => $id )); $data = mysql_fetch_array($result); $id = $data['id']; $userid = $data['userid']; $date = $data['date']; $duedate = $data['duedate']; $subtotal = $data['subtotal']; $credit = $data['credit']; $tax = $data['tax']; $total = $data['total']; $paymentmethod = $data['value']; $date = fromMySQLDate($date); $duedate = fromMySQLDate($duedate); $currency = getCurrency($userid); $clientsdetails = getClientsDetails($userid); ob_start(); echo "\n\n\n

\n\n

"; echo $aInt->lang('emailtpls', 'typeinvoice'); echo " #"; echo $id; echo "
\n"; echo $aInt->lang('mergefields', 'datecreated'); echo ": "; echo $date; echo "
\n"; echo $aInt->lang('fields', 'duedate'); echo ": "; echo $duedate; echo "
\n"; echo $aInt->lang('fields', 'subtotal'); echo ": "; echo $subtotal; echo "
\n"; echo $aInt->lang('general', 'tabcredit'); echo ": "; echo $credit; echo "
\n"; echo $aInt->lang('fields', 'tax'); echo ": "; echo $tax; echo "
\n"; echo $aInt->lang('fields', 'total'); echo ": "; echo $total; echo "

\n\n

"; echo $aInt->lang('clientsummary', 'clientdetails'); echo "
\n"; echo $clientsdetails['firstname'] . " " . $clientsdetails['lastname']; if( $clientsdetails['companyname'] != '' ) { echo " (" . $clientsdetails['companyname'] . ")"; } echo "
\n"; echo $clientsdetails['email']; echo "
\n"; echo $clientsdetails['address1']; echo ", "; echo $clientsdetails['address2']; echo "
\n"; echo $clientsdetails['city']; echo ", "; echo $clientsdetails['state']; echo ", "; echo $clientsdetails['postcode']; echo "
\n"; include("../includes/countries.php"); echo $countries[$clientsdetails['country']]; echo "
\n"; echo $clientsdetails['phonenumber']; echo "

\n\n

"; echo $aInt->lang('clientsummary', 'ccdetails'); echo "

\n"; if( $cchash == '' ) { echo "

"; echo $aInt->lang('offlineccp', 'entercchashmsg'); echo "

\n\n"; } else { check_token("WHMCS.admin.default"); $referrer = $_SERVER['HTTP_REFERER']; $pos = strpos($referrer, "?"); if( $pos ) { $referrer = substr($referrer, 0, $pos); } $adminfolder = $whmcs->get_admin_folder_name(); if( $CONFIG['SystemURL'] . '/' . $adminfolder . "/offlineccprocessing.php" != $referrer && $CONFIG['SystemSSLURL'] . '/' . $adminfolder . "/offlineccprocessing.php" != $referrer ) { echo "

" . $aInt->lang('global', 'invalidaccessattempt') . "

"; exit(); } if( $cchash != $cc_encryption_hash ) { echo $aInt->lang('offlineccp', 'entercchashdie'); } else { logActivity("Viewed Decrypted Credit Card Number for User ID " . $userid); if( $successful == 'true' ) { addInvoicePayment($id, $transid, '', '', 'offlinecc'); echo "

" . $aInt->lang('addons', 'closewindow') . "

"; exit(); } if( $failed == 'true' ) { sendMessage("Credit Card Payment Failed", $id); echo "

" . $aInt->lang('addons', 'closewindow') . "

"; exit(); } $data = getCCDetails($userid); $cardtype = $data['cardtype']; $cardnum = $data['fullcardnum']; $cardexp = $data['expdate']; $cardissuenum = $data['issuenumber']; $cardstart = $data['startdate']; echo $aInt->lang('fields', 'cardtype') . ": " . $cardtype . "
" . $aInt->lang('fields', 'cardnum') . ": " . $cardnum . "
" . $aInt->lang('fields', 'expdate') . ": " . $cardexp . " (MMYY)"; if( $cardissuenum ) { echo "
" . $aInt->lang('fields', 'issueno') . ": " . $cardissuenum; } if( $cardstart ) { echo "
" . $aInt->lang('fields', 'startdate') . ": " . $cardstart; } echo "

\n\n"; echo $aInt->lang('offlineccp', 'transresult'); echo "
\n

\n\n

\n\n"; } } $content = ob_get_contents(); ob_end_clean(); $aInt->content = $content; $aInt->displayPopUp(); exit(); } ob_start(); $jscode = "function openCCDetails(id) {\nvar winl = (screen.width - 500) / 2;\nvar wint = (screen.height - 400) / 2;\nwinprops = 'height=400,width=500,top='+wint+',left='+winl+',scrollbars=no'\nwin = window.open('" . $_SERVER['PHP_SELF'] . "?processwindow=true" . generate_token('link') . "&id='+id, 'ccdetails', winprops)\nif (parseInt(navigator.appVersion) >= 4) { win.window.focus(); }\n}"; $aInt->sortableTableInit('duedate', 'ASC'); $gatewaysarray = getGatewaysArray(); $query = "SELECT tblinvoices.*,tblclients.firstname,tblclients.lastname,tblclients.companyname,tblclients.groupid FROM tblinvoices INNER JOIN tblclients ON tblclients.id=tblinvoices.userid WHERE paymentmethod='offlinecc' AND tblinvoices.status='Unpaid' ORDER BY "; if( $orderby == 'clientname' ) { $query .= "firstname " . db_escape_string($order) . ", lastname"; } else { $query .= db_escape_string($orderby); } $query .= " " . db_escape_string($order); $numresults = full_query($query); $numrows = mysql_num_rows($numresults); $query .= " LIMIT " . (int) ($page * $limit) . ',' . (int) $limit; $result = full_query($query); while( $data = mysql_fetch_array($result) ) { $id = $data['id']; $userid = $data['userid']; $date = $data['date']; $duedate = $data['duedate']; $total = $data['total']; $paymentmethod = $data['paymentmethod']; $paymentmethod = $gatewaysarray[$paymentmethod]; $date = fromMySQLDate($date); $duedate = fromMySQLDate($duedate); $firstname = $data['firstname']; $lastname = $data['lastname']; $companyname = $data['companyname']; $groupid = $data['groupid']; $currency = getCurrency($userid); $total = formatCurrency($total); $tabledata[] = array( "" . $id . "", $aInt->outputClientLink($userid, $firstname, $lastname, $companyname, $groupid), $date, $duedate, $total, "" ); } echo $aInt->sortableTable(array( array( 'id', $aInt->lang('fields', 'id') ), array( 'clientname', $aInt->lang('fields', 'clientname') ), array( 'date', $aInt->lang('fields', 'invoicedate') ), array( 'duedate', $aInt->lang('fields', 'duedate') ), array( 'total', $aInt->lang('fields', 'total') ), $aInt->lang('supportticketescalations', 'actions') ), $tabledata); $content = ob_get_contents(); ob_end_clean(); $aInt->content = $content; $aInt->jscode = $jscode; $aInt->display();