title = $aInt->lang('transactions', 'title'); $aInt->sidebar = 'billing'; $aInt->icon = 'transactions'; $aInt->requiredFiles(array( 'gatewayfunctions', 'invoicefunctions' )); $jquerycode = ''; if( $action == 'add' ) { check_token("WHMCS.admin.default"); checkPermission("Add Transaction"); if( $client ) { $currency = 0; } $cleanedInvoiceIDs = array( ); $userInputInvoiceIDs = trim($whmcs->get_req_var('invoiceids')); if( $userInputInvoiceIDs ) { $userInputInvoiceIDs = explode(',', $userInputInvoiceIDs); foreach( $userInputInvoiceIDs as $tmpInvID ) { $tmpInvID = trim($tmpInvID); if( is_numeric($tmpInvID) ) { $cleanedInvoiceIDs[] = (int) $tmpInvID; } } } if( count($cleanedInvoiceIDs) <= 1 ) { $invoiceid = count($cleanedInvoiceIDs) ? $cleanedInvoiceIDs[0] : ''; if( $transid && !isUniqueTransactionID($transid, $paymentmethod) ) { WHMCS_Cookie::set('DuplicateTransaction', array( 'invoiceid' => $invoiceid, 'transid' => $transid, 'amountin' => $amountin, 'fees' => $fees, 'paymentmethod' => $paymentmethod, 'date' => $date, 'amountout' => $amountout, 'description' => $description, 'addcredit' => $addcredit, 'userid' => $client, 'currency' => $currency )); redir(array( 'duplicate' => true, 'tab' => 1 )); } addTransaction($client, $currency, $description, $amountin, $fees, $amountout, $paymentmethod, $transid, $invoiceid, $date); if( $client && $addcredit && (!is_int($invoiceid) || $invoiceid == 0) ) { if( $transid ) { $description .= " (" . $aInt->lang('transactions', 'transid') . ": " . $transid . ")"; } insert_query('tblcredit', array( 'clientid' => $client, 'date' => toMySQLDate($date), 'description' => $description, 'amount' => $amountin )); update_query('tblclients', array( 'credit' => "+=" . $amountin ), array( 'id' => (int) $client )); } if( is_int($invoiceid) ) { $totalPaid = get_query_val('tblaccounts', "SUM(amountin)-SUM(amountout)", array( 'invoiceid' => $invoiceid )); $invoiceData = get_query_vals('tblinvoices', "status, total", array( 'id' => $invoiceid )); $balance = $invoiceData['total'] - $totalPaid; if( $balance <= 0 && $invoiceData['status'] == 'Unpaid' ) { processPaidInvoice($invoiceid, '', $date); } } } else { if( 1 < count($cleanedInvoiceIDs) ) { $query = select_query('tblinvoices', "SUM(total)", array( 'id' => array( 'sqltype' => 'IN', 'values' => $cleanedInvoiceIDs ) )); $data = mysql_fetch_assoc($query); $invoicestotal = $data[0]; $totalleft = $amountin; $fees = round($fees / count($invoices), 2); foreach( $cleanedInvoiceIDs as $invoiceid ) { if( 0 < $totalleft ) { $result = select_query('tblinvoices', 'total', array( 'id' => $invoiceid )); $data = mysql_fetch_array($result); $invoicetotal = $data[0]; $result2 = select_query('tblaccounts', "SUM(amountin)", array( 'invoiceid' => $invoiceid )); $data = mysql_fetch_array($result2); $totalin = $data[0]; $paymentdue = $invoicetotal - $totalin; if( $paymentdue < $totalleft ) { addInvoicePayment($invoiceid, $transid, $paymentdue, $fees, $paymentmethod, '', $date); $totalleft -= $paymentdue; } else { addInvoicePayment($invoiceid, $transid, $totalleft, $fees, $paymentmethod, '', $date); $totalleft = 0; } } } if( $totalleft ) { addInvoicePayment($invoiceid, $transid, $totalleft, $fees, $paymentmethod, '', $date); } } } redir("added=true"); } if( $action == 'save' ) { check_token("WHMCS.admin.default"); checkPermission("Edit Transaction"); if( $client ) { $currency = 0; } $date = toMySQLDate($date); update_query('tblaccounts', array( 'userid' => $client, 'currency' => $currency, 'date' => $date, 'description' => $description, 'amountin' => $amountin, 'fees' => $fees, 'amountout' => $amountout, 'gateway' => $paymentmethod, 'transid' => $transid, 'invoiceid' => $invoiceid ), array( 'id' => $id )); logActivity("Modified Transaction - Transaction ID: " . $id); redir("saved=true"); } if( $action == 'delete' ) { check_token("WHMCS.admin.default"); checkPermission("Delete Transaction"); delete_query('tblaccounts', array( 'id' => $id )); logActivity("Deleted Transaction - Transaction ID: " . $id); redir("deleted=true"); } ob_start(); if( !$action ) { if( $added ) { infoBox($aInt->lang('transactions', 'transactionadded'), $aInt->lang('transactions', 'transactionaddedinfo')); } if( $saved ) { infoBox($aInt->lang('transactions', 'transactionupdated'), $aInt->lang('transactions', 'transactionupdatedinfo')); } if( $deleted ) { infoBox($aInt->lang('transactions', 'transactiondeleted'), $aInt->lang('transactions', 'transactiondeletedinfo')); } if( $duplicate ) { infobox($aInt->lang('transactions', 'duplicate'), $aInt->lang('transactions', 'requireUniqueTransaction'), 'error'); $repopulateData = WHMCS_Cookie::get('DuplicateTransaction', true); $invoiceid = $repopulateData['invoiceid'] ? WHMCS_Input_Sanitize::makesafeforoutput($repopulateData['invoiceid']) : ''; $transid = WHMCS_Input_Sanitize::makesafeforoutput($repopulateData['transid']); $amountin = $repopulateData['amountin'] ? WHMCS_Input_Sanitize::makesafeforoutput($repopulateData['amountin']) : "0.00"; $fees = $repopulateData['fees'] ? WHMCS_Input_Sanitize::makesafeforoutput($repopulateData['fees']) : "0.00"; $paymentmethod = WHMCS_Input_Sanitize::makesafeforoutput($repopulateData['paymentmethod']); $date2 = WHMCS_Input_Sanitize::makesafeforoutput($repopulateData['date']); $amountout = $repopulateData['amountout'] ? WHMCS_Input_Sanitize::makesafeforoutput($repopulateData['amountout']) : "0.00"; $description = WHMCS_Input_Sanitize::makesafeforoutput($repopulateData['description']); $addcredit = $repopulateData['addcredit'] ? " CHECKED" : ''; $userid = $repopulateData['userid'] ? WHMCS_Input_Sanitize::makesafeforoutput($repopulateData['userid']) : ''; $currency = $repopulateData['currency'] ? WHMCS_Input_Sanitize::makesafeforoutput($repopulateData['currency']) : ''; WHMCS_Cookie::delete('DuplicateTransaction'); } echo $infobox; $aInt->deleteJSConfirm('doDelete', 'transactions', 'deletesure', "?action=delete&id="); echo $aInt->Tabs(array( $aInt->lang('global', 'searchfilter'), $aInt->lang('transactions', 'add') ), true); if( !count($_REQUEST) ) { $_REQUEST['within'] = 'month'; $within = $_REQUEST['within']; } $jquerycode .= "\n\$( \"select[name='within']\" ).change(function() {\n if (\$( this ).val() != 'Custom Date Range') {\n \$( \"input[name='startdate']\" ).val('');\n \$( \"input[name='enddate']\" ).val('');\n }\n});\n\n\$( \"input[name='startdate']\" ).keyup(function() {\n \$( \"select[name='within']\" ).val('Custom Date Range');\n});\n\n\$( \"input[name='enddate']\" ).keyup(function() {\n \$( \"select[name='within']\" ).val('Custom Date Range');\n});\n\n\$( \"input[name='startdate']\" ).change(function() {\n \$( \"select[name='within']\" ).val('Custom Date Range');\n});\n\n\$( \"input[name='enddate']\" ).change(function() {\n \$( \"select[name='within']\" ).val('Custom Date Range');\n});"; echo "\n
\n
\n\n
\n\n\n\n\n\n\n
"; echo $aInt->lang('transactions', 'show'); echo ""; echo $aInt->lang('transactions', 'within'); echo "
"; echo $aInt->lang('fields', 'description'); echo ""; echo $aInt->lang('fields', 'startdate'); echo "
"; echo $aInt->lang('fields', 'transid'); echo ""; echo $aInt->lang('transactions', 'todate'); echo "
"; echo $aInt->lang('fields', 'paymentmethod'); echo ""; echo paymentMethodsSelection($aInt->lang('global', 'any')); echo ""; echo $aInt->lang('fields', 'amount'); echo "
\n\n
\n
lang('global', 'searchfilter'); echo "\" class=\"button\">
\n\n
\n\n
\n
\n
\n
\n\n"; $date2 = getTodaysDate(); echo "
getPhpSelf(); echo "?action=add\" name=\"calendarfrm\">\n\n\n\n\n \n \n \n \n\n\n \n \n \n \n\n\n \n \n \n \n\n\n \n \n \n \n\n\n \n \n \n\n
"; echo $aInt->lang('fields', 'date'); echo ""; echo $aInt->lang('currencies', 'currency'); echo " ("; echo $aInt->lang('transactions', 'nonclientonly'); echo ")
"; echo $aInt->lang('transactions', 'relclient'); echo ""; echo $aInt->clientsDropDown($userid, '', 'client', true); echo ""; echo $aInt->lang('transactions', 'amountin'); echo "
"; echo $aInt->lang('fields', 'description'); echo ""; echo $aInt->lang('transactions', 'fees'); echo "
"; echo $aInt->lang('fields', 'transid'); echo ""; echo $aInt->lang('transactions', 'amountout'); echo "
"; echo $aInt->lang('transactions', 'invoiceids'); echo "\n \n "; echo $aInt->lang('transactions', 'commaseparated'); echo " "; echo $aInt->lang('fields', 'credit'); echo "\n \n "; echo $aInt->lang('invoices', 'refundtypecredit'); echo "
"; echo $aInt->lang('fields', 'paymentmethod'); echo ""; echo paymentMethodsSelection($aInt->lang('global', 'none')); echo "
\n\n
\n
lang('transactions', 'add'); echo "\" class=\"button\">
\n
\n\n
\n
\n\n
\n\n"; $aInt->sortableTableInit('date', 'DESC'); $query = ''; $where = array( ); if( $show == 'received' ) { $where[] = "tblaccounts.amountin>0"; } else { if( $show == 'sent' ) { $where[] = "tblaccounts.amountout>0"; } } if( $amount ) { $where[] = "(tblaccounts.amountin='" . db_escape_string($amount) . "' OR tblaccounts.amountout='" . db_escape_string($amount) . "')"; } if( $startdate ) { $where[] = "tblaccounts.date>='" . toMySQLDate($startdate) . " 00:00:00'"; } if( $enddate ) { $where[] = "tblaccounts.date<='" . toMySQLDate($enddate) . " 23:59:59'"; } if( !$startdate && !$enddate ) { if( $within == 'week' ) { $lastweek = date('Ymd', mktime(0, 0, 0, date('m'), date('d') - 7, date('Y'))); $where[] = "tblaccounts.date>=" . $lastweek; } else { if( $within == 'month' ) { $lastmonth = date('Ymd', mktime(0, 0, 0, date('m') - 1, date('d'), date('Y'))); $where[] = "tblaccounts.date>=" . $lastmonth; } else { if( $within == 'year' ) { $lastyear = date('Ymd', mktime(0, 0, 0, date('m'), date('d'), date('Y') - 1)); $where[] = "tblaccounts.date>=" . $lastyear; } } } } if( $filtertransid ) { $where[] = "tblaccounts.transid='" . db_escape_string($filtertransid) . "'"; } if( $paymentmethod ) { $where[] = "tblaccounts.gateway='" . db_escape_string($paymentmethod) . "'"; } if( $filterdescription ) { $where[] = "tblaccounts.description LIKE '%" . db_escape_string($filterdescription) . "%'"; } if( count($where) ) { $query .= " WHERE " . implode(" AND ", $where); } $totals = array( ); $fullquery = "SELECT tblclients.currency,SUM(amountin),SUM(fees),SUM(amountout),SUM(amountin-fees-amountout) FROM tblaccounts,tblclients " . ($query ? $query . " AND" : 'WHERE') . " tblclients.id=tblaccounts.userid GROUP BY tblclients.currency"; $result = full_query($fullquery); while( $data = mysql_fetch_array($result) ) { $currency = $data['currency']; $totalin = $data[1]; $totalfees = $data[2]; $totalout = $data[3]; $total = $data[4]; $totals[$currency] = array( 'in' => $totalin, 'fees' => $totalfees, 'out' => $totalout, 'total' => $total ); } $fullquery = "SELECT currency,SUM(amountin),SUM(fees),SUM(amountout),SUM(amountin-fees-amountout) FROM tblaccounts " . ($query ? $query . " AND" : 'WHERE') . " userid=0 GROUP BY currency"; $result = full_query($fullquery); while( $data = mysql_fetch_array($result) ) { $currency = $data['currency']; $totalin = $data[1]; $totalfees = $data[2]; $totalout = $data[3]; $total = $data[4]; $totals[$currency]['in'] += $totalin; $totals[$currency]['fees'] += $totalfees; $totals[$currency]['out'] += $totalout; $totals[$currency]['total'] += $total; } $gatewaysarray = getGatewaysArray(); $query .= " ORDER BY tblaccounts.date DESC,tblaccounts.id DESC"; $result = full_query("SELECT COUNT(*) FROM tblaccounts" . $query); $data = mysql_fetch_array($result); $numrows = $data[0]; $query = "SELECT tblaccounts.*,tblclients.firstname,tblclients.lastname,tblclients.companyname,tblclients.groupid,tblclients.currency AS currencyid FROM tblaccounts LEFT JOIN tblclients ON tblclients.id=tblaccounts.userid" . $query . " LIMIT " . (int) ($page * $limit) . ',' . (int) $limit; $result = full_query($query); while( $data = mysql_fetch_array($result) ) { $id = $data['id']; $userid = $data['userid']; $currency = $data['currency']; $date = $data['date']; $date = fromMySQLDate($date); $description = $data['description']; $amountin = $data['amountin']; $fees = $data['fees']; $amountout = $data['amountout']; $gateway = $data['gateway']; $transid = $data['transid']; $invoiceid = $data['invoiceid']; $firstname = $data['firstname']; $lastname = $data['lastname']; $companyname = $data['companyname']; $groupid = $data['groupid']; $currencyid = $data['currencyid']; $clientlink = $userid ? $aInt->outputClientLink($userid, $firstname, $lastname, $companyname, $groupid) : '-'; $currency = $userid ? getCurrency('', $currencyid) : getCurrency('', $currency); $amountin = formatCurrency($amountin); $fees = formatCurrency($fees); $amountout = formatCurrency($amountout); if( $invoiceid != '0' ) { $description .= " (#" . $invoiceid . ")"; } if( $transid != '' ) { $description .= "
Trans ID: " . $transid; } $gateway = $gatewaysarray[$gateway]; $tabledata[] = array( $clientlink, $date, $gateway, $description, $amountin, $fees, $amountout, "\""lang('global', 'edit') . "\">", "\""lang('global', 'delete') . "\">" ); } echo $aInt->sortableTable(array( $aInt->lang('fields', 'clientname'), $aInt->lang('fields', 'date'), $aInt->lang('fields', 'paymentmethod'), $aInt->lang('fields', 'description'), $aInt->lang('transactions', 'amountin'), $aInt->lang('transactions', 'fees'), $aInt->lang('transactions', 'amountout'), '', '' ), $tabledata, $tableformurl, $tableformbuttons); if( checkPermission("View Income Totals", true) ) { echo "\n\n\n"; foreach( $totals as $currency => $values ) { $currency = getCurrency('', $currency); echo ""; } if( !count($totals) ) { echo ""; } echo "
"; echo $aInt->lang('transactions', 'totalincome'); echo ""; echo $aInt->lang('transactions', 'totalfees'); echo ""; echo $aInt->lang('transactions', 'totalexpenditure'); echo ""; echo $aInt->lang('transactions', 'totalbalance'); echo "
" . $currency['code'] . "" . formatCurrency($values['in']) . "" . formatCurrency($values['fees']) . "" . formatCurrency($values['out']) . "" . formatCurrency($values['total']) . "
" . $aInt->lang('transactions', 'nototals') . "
\n\n"; } } else { if( $action == 'edit' ) { $result = select_query('tblaccounts', '', array( 'id' => $id )); $data = mysql_fetch_array($result); $id = $data['id']; $userid = $data['userid']; $date = $data['date']; $date = fromMySQLDate($date); $description = $data['description']; $amountin = $data['amountin']; $fees = $data['fees']; $amountout = $data['amountout']; $paymentmethod = $data['gateway']; $transid = $data['transid']; $invoiceid = $data['invoiceid']; if( !$id ) { $aInt->gracefulExit($aInt->lang('transactions', 'notfound')); } echo "\n

"; echo $aInt->lang('transactions', 'edit'); echo "

\n\n
getPhpSelf(); echo "?action=save&id="; echo $id; echo "\" name=\"calendarfrm\">\n\n\n\n\n\n\n\n
"; echo $aInt->lang('transactions', 'relclient'); echo ""; echo $aInt->clientsDropDown($userid, '', 'client', true); echo ""; echo $aInt->lang('fields', 'transid'); echo "
"; echo $aInt->lang('fields', 'date'); echo ""; echo $aInt->lang('transactions', 'amountin'); echo "
"; echo $aInt->lang('fields', 'paymentmethod'); echo ""; echo paymentMethodsSelection($aInt->lang('global', 'none')); echo ""; echo $aInt->lang('transactions', 'fees'); echo "
"; echo $aInt->lang('fields', 'description'); echo ""; echo $aInt->lang('transactions', 'amountout'); echo "
"; echo $aInt->lang('fields', 'invoiceid'); echo "
\n\n

lang('global', 'savechanges'); echo "\" class=\"button\" />

\n\n
\n\n"; } } $content = ob_get_contents(); ob_end_clean(); $aInt->content = $content; $aInt->jquerycode = $jquerycode; $aInt->jscode = $jscode; $aInt->display();