get_req_var('action'); if( $action == 'edit' || $action == 'invtooltip' ) { $reqperm = "Manage Invoice"; } else { if( $action == 'createinvoice' ) { $reqperm = "Create Invoice"; } else { $reqperm = "List Invoices"; } } $aInt = new WHMCS_Admin($reqperm); if( $action == 'edit' ) { $pageicon = 'invoicesedit'; $pagetitle = $aInt->lang('fields', 'invoicenum') . $id; } else { $pageicon = 'invoices'; $pagetitle = $aInt->lang('invoices', 'title'); } $aInt->title = $pagetitle; $aInt->sidebar = 'billing'; $aInt->icon = $pageicon; $aInt->requiredFiles(array( 'clientfunctions', 'invoicefunctions', 'gatewayfunctions', 'processinvoices', 'ccfunctions' )); $invoiceid = (int) $whmcs->get_req_var('invoiceid'); $status = $whmcs->get_req_var('status'); if( !in_array($status, array( 'Unpaid', 'Overdue', 'Paid', 'Cancelled', 'Refunded', 'Collections' )) ) { $status = ''; } if( $action == 'invtooltip' ) { check_token("WHMCS.admin.default"); echo ""; $currency = getCurrency($userid); $result = select_query('tblinvoiceitems', '', array( 'invoiceid' => $id ), 'id', 'ASC'); while( $data = mysql_fetch_array($result) ) { $lineid = $data['id']; echo ""; } $data = get_query_vals('tblinvoices', 'subtotal,credit,tax,tax2,taxrate,taxrate2,total', array( 'id' => $id ), 'id', 'ASC'); echo ""; if( $CONFIG['TaxEnabled'] ) { if( 0 < $data['tax'] ) { echo ""; } if( 0 < $data['tax2'] ) { echo ""; } } echo ""; echo ""; echo "
" . $aInt->lang('fields', 'description') . "" . $aInt->lang('fields', 'amount') . "
" . nl2br($data['description']) . "" . formatCurrency($data['amount']) . "
" . $aInt->lang('fields', 'subtotal') . " " . formatCurrency($data['subtotal']) . "
" . $data['taxrate'] . "% " . $aInt->lang('fields', 'tax') . " " . formatCurrency($data['tax']) . "
" . $data['taxrate2'] . "% " . $aInt->lang('fields', 'tax') . " " . formatCurrency($data['tax2']) . "
" . $aInt->lang('fields', 'credit') . " " . formatCurrency($data['credit']) . "
" . $aInt->lang('fields', 'totaldue') . " " . formatCurrency($data['total']) . "
"; exit(); } if( $action == 'createinvoice' ) { check_token("WHMCS.admin.default"); if( !checkActiveGateway() ) { $aInt->gracefulExit($aInt->lang('gateways', 'nonesetup')); } $gateway = getClientsPaymentMethod($userid); if( $CONFIG['TaxEnabled'] == 'on' ) { $clientsdetails = getClientsDetails($userid); if( !$clientsdetails['taxexempt'] ) { $state = $clientsdetails['state']; $country = $clientsdetails['country']; $taxdata = getTaxRate(1, $state, $country); $taxdata2 = getTaxRate(2, $state, $country); $taxrate = $taxdata['rate']; $taxrate2 = $taxdata2['rate']; } } $duedate = date('Ymd', mktime(0, 0, 0, date('m'), date('d') + $CONFIG['CreateInvoiceDaysBefore'], date('Y'))); $invoiceid = insert_query('tblinvoices', array( 'date' => "now()", 'duedate' => $duedate, 'userid' => $userid, 'status' => 'Unpaid', 'paymentmethod' => $gateway, 'taxrate' => $taxrate, 'taxrate2' => $taxrate2 )); logActivity("Created Manual Invoice - Invoice ID: " . $invoiceid, $userid); WHMCS_Invoices::adjustincrementfornextinvoice($invoiceid); $invoiceArr = array( 'source' => 'adminarea', 'user' => WHMCS_Session::get('adminid'), 'invoiceid' => $invoiceid ); run_hook('InvoiceCreation', $invoiceArr); run_hook('InvoiceCreationAdminArea', $invoiceArr); redir("action=edit&id=" . $invoiceid); } $filters = new WHMCS_Filter(); if( $whmcs->get_req_var('markpaid') ) { check_token("WHMCS.admin.default"); checkPermission("Manage Invoice"); foreach( $selectedinvoices as $invid ) { $result2 = select_query('tblinvoices', 'paymentmethod', array( 'id' => $invid )); $data = mysql_fetch_array($result2); $paymentmethod = $data['paymentmethod']; addInvoicePayment($invid, '', '', '', $paymentmethod); } $filters->redir(); } if( $whmcs->get_req_var('markunpaid') ) { check_token("WHMCS.admin.default"); checkPermission("Manage Invoice"); foreach( $selectedinvoices as $invid ) { update_query('tblinvoices', array( 'status' => 'Unpaid', 'datepaid' => "0000-00-00 00:00:00" ), array( 'id' => $invid )); logActivity("Reactivated Invoice - Invoice ID: " . $invid); run_hook('InvoiceUnpaid', array( 'invoiceid' => $invid )); } $filters->redir(); } if( $whmcs->get_req_var('markcancelled') ) { check_token("WHMCS.admin.default"); checkPermission("Manage Invoice"); foreach( $selectedinvoices as $invid ) { update_query('tblinvoices', array( 'status' => 'Cancelled' ), array( 'id' => $invid )); logActivity("Cancelled Invoice - Invoice ID: " . $invid); run_hook('InvoiceCancelled', array( 'invoiceid' => $invid )); } $filters->redir(); } if( $whmcs->get_req_var('duplicateinvoice') ) { check_token("WHMCS.admin.default"); foreach( $selectedinvoices as $invid ) { $invoices = new WHMCS_Invoices(); $invoices->duplicate($invid); } $filters->redir(); } if( $whmcs->get_req_var('massdelete') ) { check_token("WHMCS.admin.default"); checkPermission("Delete Invoice"); foreach( $selectedinvoices as $invid ) { delete_query('tblinvoices', array( 'id' => $invid )); logActivity("Deleted Invoice - Invoice ID: " . $invid); } $filters->redir(); } if( $whmcs->get_req_var('paymentreminder') ) { check_token("WHMCS.admin.default"); foreach( $selectedinvoices as $invid ) { sendMessage("Invoice Payment Reminder", $invid); logActivity("Invoice Payment Reminder Sent - Invoice ID: " . $invid); } $filters->redir(); } if( $whmcs->get_req_var('delete') ) { check_token("WHMCS.admin.default"); checkPermission("Delete Invoice"); delete_query('tblinvoices', array( 'id' => $invoiceid )); logActivity("Deleted Invoice - Invoice ID: " . $invoiceid); $filters->redir(); } ob_start(); if( $action == '' ) { $aInt->deleteJSConfirm('doDelete', 'invoices', 'delete', $_SERVER['PHP_SELF'] . "?status=" . $status . "&delete=true&invoiceid="); $name = 'invoices'; $orderby = 'duedate'; $sort = 'DESC'; $pageObj = new WHMCS_Pagination($name, $orderby, $sort); $pageObj->digestCookieData(); $tbl = new WHMCS_ListTable($pageObj); $tbl->setColumns(array( 'checkall', array( 'id', $aInt->lang('fields', 'invoicenum') ), array( 'clientname', $aInt->lang('fields', 'clientname') ), array( 'date', $aInt->lang('fields', 'invoicedate') ), array( 'duedate', $aInt->lang('fields', 'duedate') ), array( 'total', $aInt->lang('fields', 'total') ), array( 'paymentmethod', $aInt->lang('fields', 'paymentmethod') ), array( 'status', $aInt->lang('fields', 'status') ), '', '' )); $invoicesModel = new WHMCS_Invoices($pageObj); if( checkPermission("View Income Totals", true) ) { $invoicetotals = $invoicesModel->getInvoiceTotals(); if( count($invoicetotals) ) { echo "
"; foreach( $invoicetotals as $vals ) { echo "" . $vals['currencycode'] . " " . $aInt->lang('status', 'paid') . ": " . $vals['paid'] . " " . $aInt->lang('status', 'unpaid') . ": " . $vals['unpaid'] . " " . $aInt->lang('status', 'overdue') . ": " . $vals['overdue'] . "
"; } echo "

"; } } echo $aInt->Tabs(array( $aInt->lang('global', 'searchfilter') ), true); $clientid = $filters->get('clientid'); $invoicenum = $filters->get('invoicenum'); echo "\n
\n
\n\n\n
getPhpSelf(); echo "\" method=\"post\">\n\n\n\n\n\n\n\n
"; echo $aInt->lang('fields', 'clientname'); echo "get('clientname'); echo "\">"; echo $aInt->lang('fields', 'invoicedate'); echo "get('invoicedate'); echo "\" class=\"datepick\">
"; echo $aInt->lang('fields', 'lineitem'); echo "get('lineitem'); echo "\">"; echo $aInt->lang('fields', 'duedate'); echo "get('duedate'); echo "\" class=\"datepick\">
"; echo $aInt->lang('fields', 'paymentmethod'); echo ""; $paymentmethod = $filters->get('paymentmethod'); echo paymentMethodsSelection($aInt->lang('global', 'any')); echo ""; echo $aInt->lang('fields', 'datepaid'); echo "get('datepaid'); echo "\" class=\"datepick\">
"; echo $aInt->lang('fields', 'status'); echo ""; echo $aInt->lang('fields', 'totaldue'); echo ""; echo $aInt->lang('filters', 'from'); echo " get('totalfrom'); echo "\"> "; echo $aInt->lang('filters', 'to'); echo " get('totalto'); echo "\">
\n\n
\n
lang('global', 'search'); echo "\" class=\"button\" />
\n\n
\n\n
\n
\n\n
\n\n\n\n"; $jquerycode = "\$(\".invtooltip\").tooltip({cssClass:\"invoicetooltip\"});"; $aInt->jquerycode = $jquerycode; $filters->store(); $criteria = array( 'clientid' => $clientid, 'clientname' => $clientname, 'invoicenum' => $invoicenum, 'lineitem' => $lineitem, 'paymentmethod' => $paymentmethod, 'invoicedate' => $invoicedate, 'duedate' => $duedate, 'datepaid' => $datepaid, 'totalfrom' => $totalfrom, 'totalto' => $totalto, 'status' => $status ); $invoicesModel->execute($criteria); $numresults = $pageObj->getNumResults(); if( $filters->isActive() && $numresults == 1 ) { $invoice = $pageObj->getOne(); redir("action=edit&id=" . $invoice['id'], "invoices.php"); } else { $invoicelist = $pageObj->getData(); foreach( $invoicelist as $invoice ) { $linkopen = ""; $linkclose = ""; $tbl->addRow(array( "", $linkopen . $invoice['invoicenum'] . $linkclose, $invoice['clientname'], $invoice['date'], $invoice['duedate'], "" . $invoice['totalformatted'] . "", $invoice['paymentmethod'], $invoice['statusformatted'], $linkopen . "\"Edit\"" . $linkclose, "\"Delete\"" )); } $tbl->setMassActionBtns("lang('invoices', 'markpaid') . "\" class=\"btn-success\" name=\"markpaid\" onclick=\"return confirm('" . $aInt->lang('invoices', 'markpaidconfirm', '1') . "')\" /> lang('invoices', 'markunpaid') . "\" name=\"markunpaid\" onclick=\"return confirm('" . $aInt->lang('invoices', 'markunpaidconfirm', '1') . "')\" /> lang('invoices', 'markcancelled') . "\" name=\"markcancelled\" onclick=\"return confirm('" . $aInt->lang('invoices', 'markcancelledconfirm', '1') . "')\" /> lang('invoices', 'duplicateinvoice') . "\" name=\"duplicateinvoice\" onclick=\"return confirm('" . $aInt->lang('invoices', 'duplicateinvoiceconfirm', '1') . "')\" /> lang('invoices', 'sendreminder') . "\" name=\"paymentreminder\" onclick=\"return confirm('" . $aInt->lang('invoices', 'sendreminderconfirm', '1') . "')\" /> lang('global', 'delete') . "\" class=\"btn-danger\" name=\"massdelete\" onclick=\"return confirm('" . $aInt->lang('invoices', 'massdeleteconfirm', '1') . "')\" />"); echo $tbl->output(); unset($clientlist); unset($invoicesModel); } } else { if( $action == 'edit' ) { $result = select_query('tblinvoices', 'userid,paymentmethod', array( 'id' => $id )); $data = mysql_fetch_array($result); $userid = $data[0]; $oldpaymentmethod = $data[1]; $aInt->assertClientBoundary($userid); if( $saveoptions ) { check_token("WHMCS.admin.default"); update_query('tblinvoices', array( 'date' => toMySQLDate($invoicedate), 'duedate' => toMySQLDate($datedue), 'paymentmethod' => $paymentmethod, 'invoicenum' => $invoicenum, 'taxrate' => $taxrate, 'taxrate2' => $taxrate2, 'status' => $status ), array( 'id' => $id )); updateInvoiceTotal($id); if( $oldpaymentmethod != $paymentmethod ) { run_hook('InvoiceChangeGateway', array( 'invoiceid' => $id, 'paymentmethod' => $paymentmethod )); } logActivity("Modified Invoice Options - Invoice ID: " . $id, $userid); redir("action=edit&id=" . $id); } if( $save == 'notes' ) { check_token("WHMCS.admin.default"); update_query('tblinvoices', array( 'notes' => $notes ), array( 'id' => $id )); logActivity("Modified Invoice Notes - Invoice ID: " . $id, $userid); redir("action=edit&id=" . $id); } if( $sub == 'statuscancelled' ) { check_token("WHMCS.admin.default"); $set = array( 'status' => 'Cancelled', 'datepaid' => "0000-00-00 00:00:00" ); $where = array( 'id' => $id ); update_query('tblinvoices', $set, $where); logActivity("Cancelled Invoice - Invoice ID: " . $id, $userid); run_hook('InvoiceCancelled', array( 'invoiceid' => $id )); redir("action=edit&id=" . $id); } if( $sub == 'statusunpaid' ) { check_token("WHMCS.admin.default"); $set = array( 'status' => 'Unpaid', 'datepaid' => "0000-00-00 00:00:00" ); $where = array( 'id' => $id ); update_query('tblinvoices', $set, $where); logActivity("Reactivated Invoice - Invoice ID: " . $id, $userid); run_hook('InvoiceUnpaid', array( 'invoiceid' => $id )); redir("action=edit&id=" . $id); } if( $sub == 'markpaid' ) { check_token("WHMCS.admin.default"); checkPermission("Add Transaction"); if( $sendconfirmation == 'on' ) { $sendconfirmation = ''; } else { $sendconfirmation = 'on'; } addInvoicePayment($id, $transid, $amount, $fees, $paymentmethod, $sendconfirmation, $date); redir("action=edit&id=" . $id); } if( $sub == 'save' ) { check_token("WHMCS.admin.default"); if( $description ) { foreach( $description as $lineid => $desc ) { update_query('tblinvoiceitems', array( 'description' => $desc, 'amount' => $amount[$lineid], 'taxed' => $taxed[$lineid] ), array( 'id' => $lineid )); } } if( $adddescription ) { insert_query('tblinvoiceitems', array( 'invoiceid' => $id, 'userid' => $userid, 'description' => $adddescription, 'amount' => $addamount, 'taxed' => $addtaxed )); } if( $selaction == 'delete' && is_array($itemids) ) { foreach( $itemids as $itemid ) { delete_query('tblinvoiceitems', array( 'id' => $itemid )); } } if( $selaction == 'split' && is_array($itemids) ) { $result = select_query('tblinvoices', 'userid,date,duedate,taxrate,taxrate2,paymentmethod', array( 'id' => $id )); $data = mysql_fetch_array($result); $userid = $data[0]; $date = $data[1]; $duedate = $data[2]; $taxrate = $data[3]; $taxrate2 = $data[4]; $paymentmethod = $data[5]; $result = select_query('tblinvoiceitems', "COUNT(*)", array( 'invoiceid' => $id )); $data = mysql_fetch_array($result); $totalitemscount = $data[0]; if( count($itemids) < $totalitemscount ) { $invoiceid = insert_query('tblinvoices', array( 'date' => $date, 'duedate' => $duedate, 'userid' => $userid, 'status' => 'Unpaid', 'paymentmethod' => $paymentmethod, 'taxrate' => $taxrate, 'taxrate2' => $taxrate2 )); WHMCS_Invoices::adjustincrementfornextinvoice($invoiceid); foreach( $itemids as $itemid ) { update_query('tblinvoiceitems', array( 'invoiceid' => $invoiceid ), array( 'id' => $itemid )); } updateInvoiceTotal($invoiceid); updateInvoiceTotal($id); logActivity("Split Invoice - Invoice ID: " . $id . " to Invoice ID: " . $invoiceid, $userid); $invoiceArr = array( 'source' => 'adminarea', 'user' => WHMCS_Session::get('adminid'), 'invoiceid' => $invoiceid ); run_hook('InvoiceCreation', $invoiceArr); run_hook('InvoiceCreationAdminArea', $invoiceArr); run_hook('InvoiceSplit', array( 'originalinvoiceid' => $id, 'newinvoiceid' => $invoiceid )); redir("action=edit&id=" . $invoiceid); } } updateInvoiceTotal($id); $result = select_query('tblinvoices', 'userid', array( 'id' => $id )); $data = mysql_fetch_array($result); $userid = $data[0]; logActivity("Modified Invoice - Invoice ID: " . $id, $userid); redir("action=edit&id=" . $id); } if( $addcredit != "0.00" && $addcredit ) { check_token("WHMCS.admin.default"); $result2 = select_query('tblinvoices', 'userid,subtotal,credit,total', array( 'id' => $id )); $data = mysql_fetch_array($result2); $userid = $data['userid']; $subtotal = $data['subtotal']; $credit = $data['credit']; $total = $data['total']; $result2 = select_query('tblaccounts', "SUM(amountin)-SUM(amountout)", array( 'invoiceid' => $id )); $data = mysql_fetch_array($result2); $amountpaid = $data[0]; $balance = $total - $amountpaid; if( $CONFIG['TaxType'] == 'Inclusive' ) { $subtotal = $total; } $addcredit = round($addcredit, 2); $balance = round($balance, 2); $result2 = select_query('tblclients', 'credit', array( 'id' => $userid )); $data = mysql_fetch_array($result2); $totalcredit = $data['credit']; if( $totalcredit < $addcredit ) { redir("action=edit&id=" . $id . "&creditapply=exceedbalance"); } else { if( $balance < $addcredit ) { redir("action=edit&id=" . $id . "&creditapply=exceedtotal"); } else { applyCredit($id, $userid, $addcredit); $currency = getCurrency($userid); redir("action=edit&id=" . $id . "&creditapply=success&amt=" . $addcredit); } } } if( $removecredit != "0.00" && $removecredit != '' ) { check_token("WHMCS.admin.default"); $result2 = select_query('tblinvoices', 'userid,subtotal,credit,total,status', array( 'id' => $id )); $data = mysql_fetch_array($result2); $userid = $data['userid']; $subtotal = $data['subtotal']; $credit = $data['credit']; $total = $data['total']; $status = $data['status']; if( $credit < $removecredit ) { redir("action=edit&id=" . $id . "&creditremove=exceedtotal"); } else { update_query('tblinvoices', array( 'credit' => "-=" . $removecredit ), array( 'id' => (int) $id )); updateInvoiceTotal($id); update_query('tblclients', array( 'credit' => "+=" . $removecredit ), array( 'id' => (int) $userid )); insert_query('tblcredit', array( 'clientid' => $userid, 'date' => "now()", 'description' => "Credit Removed from Invoice #" . $id, 'amount' => $removecredit )); logActivity("Credit Removed - Amount: " . $removecredit . " - Invoice ID: " . $id, $userid); if( $status == 'Paid' ) { update_query('tblinvoices', array( 'status' => 'Refunded' ), array( 'id' => $id )); } redir("action=edit&id=" . $id . "&creditremove=success&amt=" . $removecredit); } } if( $sub == 'delete' ) { check_token("WHMCS.admin.default"); delete_query('tblinvoiceitems', array( 'id' => $iid )); updateInvoiceTotal($id); redir("action=edit&id=" . $id); } $result = select_query('tblinvoices', "tblpaymentgateways.value", array( "tblpaymentgateways.setting" => 'type', "tblinvoices.id" => $id ), '', '', '', "tblclients ON tblclients.id=tblinvoices.userid INNER JOIN tblpaymentgateways ON tblpaymentgateways.gateway=tblinvoices.paymentmethod"); $data = mysql_fetch_array($result); $type = $data['value']; if( $tplname ) { check_token("WHMCS.admin.default"); sendMessage($tplname, $id, '', true); } if( $type == 'CC' ) { if( $sub == 'attemptpayment' ) { check_token("WHMCS.admin.default"); $data = get_query_vals('tblclients', 'cardtype,gatewayid', array( 'id' => $userid )); if( $data[0] || $data[1] ) { logActivity("Admin Initiated Payment Capture - Invoice ID: " . $id, $userid); if( captureCCPayment($id) ) { infoBox($aInt->lang('invoices', 'capturesuccessful'), $aInt->lang('invoices', 'capturesuccessfulmsg'), 'success'); } else { infoBox($aInt->lang('invoices', 'captureerror'), $aInt->lang('invoices', 'captureerrormsg'), 'error'); } } else { infoBox($aInt->lang('invoices', 'captureerror'), "No Credit Card Details are stored for this client so the capture could not be attempted", 'info'); } } if( $sub == 'initiatepayment' ) { check_token("WHMCS.admin.default"); $data = get_query_vals('tblclients', 'gatewayid', array( 'id' => $userid )); logActivity("Admin Initiated Payment Attempt - Invoice ID: " . $id, $userid); if( captureCCPayment($id) ) { infoBox($aInt->lang('invoices', 'initiatepaymentsuccessful'), $aInt->lang('invoices', 'initiatepaymentsuccessfulmsg'), 'success'); } else { infoBox($aInt->lang('invoices', 'initiatepaymenterror'), $aInt->lang('invoices', 'initiatepaymenterrormsg'), 'error'); } } } if( $sub == 'refund' && $transid ) { check_token("WHMCS.admin.default"); checkPermission("Refund Invoice Payments"); logActivity("Admin Initiated Refund - Invoice ID: " . $id . " - Transaction ID: " . $transid); if( $refundtype == 'sendtogateway' ) { $sendtogateway = true; } else { if( $refundtype == 'addascredit' ) { $addascredit = true; } } $result = refundInvoicePayment($transid, $amount, $sendtogateway, $addascredit, $sendemail, $refundtransid); redir("action=edit&id=" . $id . "&refundattempted=1&response=" . $result); } if( $sub == 'deletetrans' ) { check_token("WHMCS.admin.default"); checkPermission("Delete Transaction"); delete_query('tblaccounts', array( 'id' => $ide )); logActivity("Deleted Transaction - Transaction ID: " . $ide); redir("action=edit&id=" . $id); } $jscode = "function showrefundtransid() {\n var refundtype = \$(\"#refundtype\").val();\n if (refundtype != \"\") {\n \$(\"#refundtransid\").slideUp();\n } else {\n \$(\"#refundtransid\").slideDown();\n }\n}"; $aInt->jscode = $jscode; if( $refundattempted ) { if( $response == 'manual' ) { infoBox($aInt->lang('invoices', 'refundsuccess'), $aInt->lang('invoices', 'refundmanualsuccessmsg')); } else { if( $response == 'amounterror' ) { infoBox($aInt->lang('invoices', 'refundfailed'), $aInt->lang('invoices', 'refundamounterrormsg')); } else { if( $response == 'success' ) { infoBox($aInt->lang('invoices', 'refundsuccess'), $aInt->lang('invoices', 'refundsuccessmsg')); } else { if( $response == 'creditsuccess' ) { infoBox($aInt->lang('invoices', 'refundsuccess'), $aInt->lang('invoices', 'refundcreditmsg')); } else { infoBox($aInt->lang('invoices', 'refundfailed'), $aInt->lang('invoices', 'refundfailedmsg')); } } } } } if( $creditapply == 'exceedbalance' ) { infoBox($aInt->lang('global', 'erroroccurred'), $aInt->lang('invoices', 'exceedBalance'), 'error'); } if( $creditapply == 'exceedtotal' ) { infoBox($aInt->lang('global', 'erroroccurred'), $aInt->lang('invoices', 'exceedTotal'), 'error'); } if( $creditapply == 'success' ) { $clientCurrency = getCurrency($userid); infoBox($aInt->lang('global', 'success'), sprintf($aInt->lang('invoices', 'creditApplySuccess'), formatCurrency($amt, $clientCurrency['id'])), 'success'); } if( $creditremove == 'exceedtotal' ) { infoBox($aInt->lang('global', 'erroroccurred'), $aInt->lang('invoices', 'exceedTotalRemove'), 'error'); } if( $creditremove == 'success' ) { $clientCurrency = getCurrency($userid); infoBox($aInt->lang('global', 'success'), sprintf($aInt->lang('invoices', 'creditRemoveSuccess'), formatCurrency($amt, $clientCurrency['id'])), 'success'); } echo $infobox; $gatewaysarray = getGatewaysArray(); $result = select_query('tblinvoices', "tblinvoices.*,tblclients.firstname,tblclients.lastname,tblclients.companyname,tblclients.groupid,tblclients.state,tblclients.country", array( "tblinvoices.id" => $id ), '', '', '', "tblclients ON tblclients.id=tblinvoices.userid"); $data = mysql_fetch_array($result); $id = $data['id']; $invoicenum = $data['invoicenum']; $date = $data['date']; $duedate = $data['duedate']; $datepaid = $data['datepaid']; $subtotal = $data['subtotal']; $credit = $data['credit']; $tax = $data['tax']; $tax2 = $data['tax2']; $total = $data['total']; $taxrate = $data['taxrate']; $taxrate2 = $data['taxrate2']; $status = $data['status']; $paymentmethod = $data['paymentmethod']; $notes = $data['notes']; $userid = $data['userid']; $firstname = $data['firstname']; $lastname = $data['lastname']; $companyname = $data['companyname']; $groupid = $data['groupid']; $clientstate = $data['state']; $clientcountry = $data['country']; $date = fromMySQLDate($date); $duedate = fromMySQLDate($duedate); $datepaid = fromMySQLDate($datepaid, 'time'); if( !$id ) { $aInt->gracefulExit("Invoice ID Not Found"); } $currency = getCurrency($userid); $result = select_query('tblaccounts', "COUNT(id),SUM(amountin)-SUM(amountout)", array( 'invoiceid' => $id )); $data = mysql_fetch_array($result); $transcount = $data[0]; $amountpaid = $data[1]; $balance = $total - $amountpaid; $balance = $rawbalance = sprintf("%01.2f", $balance); loadGatewayModule($paymentmethod); if( $status == 'Unpaid' ) { $paymentmethodfriendly = $gatewaysarray[$paymentmethod]; } else { if( $transcount == 0 ) { $paymentmethodfriendly = $aInt->lang('invoices', 'notransapplied'); } else { $paymentmethodfriendly = $gatewaysarray[$paymentmethod]; } } if( 0 < $credit ) { if( $total == 0 ) { $paymentmethodfriendly = $aInt->lang('invoices', 'fullypaidcredit'); } else { $paymentmethodfriendly .= " + " . $aInt->lang('invoices', 'partialcredit'); } } $initiatevscapture = function_exists($paymentmethod . '_initiatepayment') ? true : false; if( function_exists($paymentmethod . '_adminstatusmsg') ) { $gatewaymsg = call_user_func($paymentmethod . '_adminstatusmsg', array( 'invoiceid' => $id, 'userid' => $userid, 'date' => $date, 'duedate' => $duedate, 'datepaid' => $datepaid, 'subtotal' => $subtotal, 'tax' => $tax, 'tax2' => $tax2, 'total' => $total, 'status' => $status )); if( is_array($gatewaymsg) ) { infoBox($gatewaymsg['title'], $gatewaymsg['msg'], $gatewaymsg['type']); echo $infobox; } } $aInt->deleteJSConfirm('doDelete', 'invoices', 'deletelineitem', "?action=edit&id=" . $id . "&sub=delete&iid="); $aInt->deleteJSConfirm('doDeleteTransaction', 'invoices', 'deletetransaction', "?action=edit&id=" . $id . "&sub=deletetrans&ide="); run_hook('ViewInvoiceDetailsPage', array( 'invoiceid' => $id )); echo $aInt->Tabs(array( $aInt->lang('invoices', 'summary'), $aInt->lang('invoices', 'addpayment'), $aInt->lang('invoices', 'options'), $aInt->lang('fields', 'credit'), $aInt->lang('invoices', 'refund'), $aInt->lang('fields', 'notes') )); echo "\n
\n
\n\n
\n\n\n\n"; if( $invoicenum ) { echo ""; } echo "\n\n\n\n
"; echo $aInt->lang('fields', 'clientname'); echo ""; echo $aInt->outputClientLink($userid, $firstname, $lastname, $companyname, $groupid); echo " ("; echo $aInt->lang('invoices', 'viewinvoices'); echo ")
"; echo $aInt->lang('fields', 'invoicenum'); echo ""; echo $invoicenum; echo "
"; echo $aInt->lang('fields', 'invoicedate'); echo ""; echo $date; echo "
"; echo $aInt->lang('fields', 'duedate'); echo ""; echo $duedate; echo "
"; echo $aInt->lang('fields', 'totaldue'); echo ""; echo formatCurrency($credit + $total); echo "
"; echo $aInt->lang('fields', 'balance'); echo ""; if( 0 < $rawbalance ) { echo "" . formatCurrency($balance) . ""; } else { echo "" . formatCurrency($balance) . ""; } echo "
\n\n		\n"; if( $status == 'Unpaid' ) { echo ""; echo $aInt->lang('status', 'unpaid'); echo ""; } else { if( $status == 'Paid' ) { echo ""; echo $aInt->lang('status', 'paid'); echo "
"; echo $datepaid; echo ""; } else { if( $status == 'Cancelled' ) { echo ""; echo $aInt->lang('status', 'cancelled'); echo ""; } else { if( $status == 'Refunded' ) { echo ""; echo $aInt->lang('status', 'refunded'); echo ""; } else { if( $status == 'Collections' ) { echo ""; echo $aInt->lang('status', 'collections'); echo ""; } } } } } echo "
"; echo $aInt->lang('fields', 'paymentmethod'); echo ": "; echo $paymentmethodfriendly; echo "\n

\n
\n lang('global', 'sendemail'); echo "\" />\n
\n
\nlang('invoices', 'initiatepayment') : $aInt->lang('invoices', 'attemptcapture'); echo "\" onClick=\"attemptpayment()\" class=\"button\""; if( $status == 'Paid' || $status == 'Cancelled' || !function_exists($paymentmethod . '_capture') ) { echo " disabled"; } echo " /> lang('invoices', 'markcancelled'); echo "\" class=\"button\" onClick=\"window.location='"; echo $whmcs->getPhpSelf(); echo "?action=edit&id="; echo $id; echo "&sub=statuscancelled"; echo generate_token('link'); echo "';\""; if( $status == 'Cancelled' ) { echo " disabled"; } echo "> lang('invoices', 'markunpaid'); echo "\" onClick=\"window.location='"; echo $whmcs->getPhpSelf(); echo "?action=edit&id="; echo $id; echo "&sub=statusunpaid"; echo generate_token('link'); echo "';\" class=\"button\""; if( $status == 'Unpaid' ) { echo " disabled"; } echo ">

\nlang('invoices', 'printableversion'); echo "\" class=\"button\" onclick=\"window.open('../viewinvoice.php?id="; echo $id; echo "','windowfrm','menubar=yes,toolbar=yes,scrollbars=yes,resizable=yes,width=750,height=600')\" /> lang('invoices', 'viewpdf'); echo "\" class=\"button\" onclick=\"window.open('../dl.php?type=i&id="; echo $id; echo "&viewpdf=1','pdfinv','')\" /> lang('invoices', 'downloadpdf'); echo "\" class=\"button\" onclick=\"window.location='../dl.php?type=i&id="; echo $id; echo "'\" />\n\n"; $addons_html = run_hook('AdminInvoicesControlsOutput', array( 'invoiceid' => $id, 'userid' => $userid, 'subtotal' => $subtotal, 'tax' => $tax, 'tax2' => $tax2, 'credit' => $credit, 'total' => $total, 'balance' => $balance, 'taxrate' => $taxrate, 'taxrate2' => $taxrate2, 'paymentmethod' => $paymentmethod )); foreach( $addons_html as $output ) { echo $output; } echo "\n
\n\n
\n
\n
\n
\n\n
getPhpSelf(); echo "\">\n\n\n\n\n"; if( $rawbalance <= 0 ) { infoBox($aInt->lang('invoices', 'paidstatuscredit'), $aInt->lang('invoices', 'paidstatuscreditdesc')); echo $infobox; } echo "\n\n\n\n\n
"; echo $aInt->lang('fields', 'date'); echo ""; echo $aInt->lang('fields', 'amount'); echo "
"; echo $aInt->lang('fields', 'paymentmethod'); echo ""; echo paymentMethodsSelection('None'); echo ""; echo $aInt->lang('fields', 'fees'); echo "
"; echo $aInt->lang('fields', 'transid'); echo ""; echo $aInt->lang('global', 'sendemail'); echo " "; echo $aInt->lang('invoices', 'ticksendconfirmation'); echo "
\n
\n
lang('invoices', 'addpayment'); echo "\" class=\"btn\" />
\n
\n\n
\n
\n
\n
\n\n
getPhpSelf(); echo "\">\n\n\n\n\n\n\n\n\n
"; echo $aInt->lang('fields', 'invoicedate'); echo ""; echo $aInt->lang('fields', 'duedate'); echo "
"; echo $aInt->lang('fields', 'paymentmethod'); echo ""; echo paymentMethodsSelection(); echo ""; echo $aInt->lang('fields', 'taxrate'); echo "1 %  -  2 %
"; echo $aInt->lang('fields', 'invoicenum'); echo ""; echo $aInt->lang('fields', 'status'); echo "
\n
\n
lang('global', 'savechanges'); echo "\" class=\"button\">
\n
\n\n
\n
\n
\n
\n\n"; $totalcredit = get_query_val('tblclients', 'credit', array( 'id' => $userid )); echo "\n\n\n\n
"; echo $aInt->lang('invoices', 'addcredit'); echo ""; echo $aInt->lang('invoices', 'removecredit'); echo "
"; echo formatCurrency($totalcredit); echo " "; echo $aInt->lang('invoices', 'creditavailable'); echo ""; echo formatCurrency($credit); echo " "; echo $aInt->lang('invoices', 'creditavailable'); echo "
getPhpSelf(); echo "\"> lang('global', 'go'); echo "\" class=\"btn"; if( $totalcredit == "0.00" ) { echo " disabled"; } echo "\""; if( $totalcredit == "0.00" ) { echo " disabled"; } echo ">
getPhpSelf(); echo "\"> lang('global', 'go'); echo "\" class=\"btn"; if( $credit == "0.00" ) { echo " disabled"; } echo "\""; if( $credit == "0.00" ) { echo " disabled"; } echo ">
\n\n\n
\n
\n
\n
\n"; $numtrans = get_query_vals('tblaccounts', "COUNT(id)", array( 'invoiceid' => $id, 'amountin' => array( 'sqltype' => ">", 'value' => '0' ) ), "date` ASC,`id", 'ASC'); $notransactions = $numtrans[0] == '0' ? true : false; echo "
getPhpSelf(); echo "\">\n\n\n\n\n\n\n\n\n\n\n
"; echo $aInt->lang('invoices', 'transactions'); echo "
"; echo $aInt->lang('fields', 'amount'); echo " Leave blank for full refund
"; echo $aInt->lang('invoices', 'refundtype'); echo "
"; echo $aInt->lang('fields', 'transid'); echo "
"; echo $aInt->lang('global', 'sendemail'); echo " "; echo $aInt->lang('invoices', 'ticksendconfirmation'); echo "
\n
\n
lang('invoices', 'refund'); echo "\" class=\"btn\""; if( $notransactions ) { echo " disabled"; } echo ">
\n
\n\n
\n
\n
\n
\n\n
getPhpSelf(); echo "?save=notes\">\n\n\n
\n
\n
lang('global', 'savechanges'); echo "\" class=\"button\">
\n
\n\n
\n
\n\n\n\n

"; echo $aInt->lang('invoices', 'items'); echo "

\n
getPhpSelf(); echo "\">\n\n\n\n\n\n
\n\n\n"; $result = select_query('tblinvoiceitems', '', array( 'invoiceid' => $id ), 'id', 'ASC'); while( $data = mysql_fetch_array($result) ) { $lineid = $data['id']; $description = $data['description']; $linecount = explode("\n", $description); $linecount = count($linecount); echo ""; } echo ""; echo "\n"; if( $CONFIG['TaxEnabled'] == 'on' ) { if( $taxrate != "0.00" ) { echo ""; } if( $taxrate2 != "0.00" ) { echo ""; } } echo "\n\n
"; echo $aInt->lang('fields', 'description'); echo ""; echo $aInt->lang('fields', 'amount'); echo ""; echo $aInt->lang('fields', 'taxed'); echo "
 
"; echo $aInt->lang('fields', 'subtotal'); echo ": 
"; echo formatCurrency($subtotal); echo "  
"; echo $taxrate; echo "% "; $taxdata = getTaxRate(1, $clientstate, $clientcountry); echo $taxdata['name'] ? $taxdata['name'] : $aInt->lang('invoices', 'taxdue'); echo ": "; echo formatCurrency($tax); echo "  
"; echo $taxrate2; echo "% "; $taxdata = getTaxRate(2, $clientstate, $clientcountry); echo $taxdata['name'] ? $taxdata['name'] : $aInt->lang('invoices', 'taxdue'); echo ": "; echo formatCurrency($tax2); echo "  
"; echo $aInt->lang('fields', 'credit'); echo ": "; echo formatCurrency($credit); echo "  
"; echo $aInt->lang('fields', 'totaldue'); echo ": "; echo formatCurrency($total); echo "
\n
\n

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

\n
\n\n

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

\n\n"; $aInt->sortableTableInit('nopagination'); $result = select_query('tblaccounts', '', array( 'invoiceid' => $id ), "date` ASC,`id", 'ASC'); while( $data = mysql_fetch_array($result) ) { $ide = $data['id']; $date = $data['date']; $date = fromMySQLDate($date); $gateway = $data['gateway']; $description = $data['description']; $amountin = $data['amountin']; $fees = $data['fees']; $amountout = $data['amountout']; $transid = $data['transid']; $invoiceid = $data['invoiceid']; $amount = formatCurrency($amountin - $amountout); $fees = formatCurrency($fees); if( $gateway ) { $result2 = select_query('tblpaymentgateways', '', array( 'gateway' => $gateway, 'setting' => 'name' )); $data = mysql_fetch_array($result2); $gateway = $data['value']; } else { $gateway = "No Gateway"; } $tabledata[] = array( $date, $gateway, $transid, $amount, $fees, "\"Delete\"" ); } echo $aInt->sortableTable(array( $aInt->lang('fields', 'date'), $aInt->lang('fields', 'paymentmethod'), $aInt->lang('fields', 'transid'), $aInt->lang('fields', 'amount'), $aInt->lang('fields', 'fees'), '' ), $tabledata); } } $content = ob_get_contents(); ob_end_clean(); $aInt->content = $content; $aInt->display();