requiredFiles(array( 'gatewayfunctions', 'invoicefunctions', 'processinvoices' )); $aInt->inClientsProfile = true; if($delete || $massdelete) { checkPermission("Delete Invoice"); } if($markpaid || $markunpaid || $markcancelled) { checkPermission("Manage Invoice"); } $aInt->valUserID($userid); $aInt->assertClientBoundary($userid); if($markpaid) { check_token("WHMCS.admin.default"); foreach($selectedinvoices as $invid) { $result2 = select_query('tblinvoices', 'paymentmethod', array( 'id' => $invid )); $data = mysql_fetch_array($result2); $paymentmethod = $data['paymentmethod']; addInvoicePayment($invid, '', '', '', $paymentmethod); } if($page) { $userid .= "&page=" . $page; } redir("userid=" . $userid . "&filter=1"); } if($markunpaid) { check_token("WHMCS.admin.default"); 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, $userid); run_hook('InvoiceUnpaid', array( 'invoiceid' => $invid )); } if($page) { $userid .= "&page=" . $page; } redir("userid=" . $userid . "&filter=1"); } if($markcancelled) { check_token("WHMCS.admin.default"); foreach($selectedinvoices as $invid) { update_query('tblinvoices', array( 'status' => 'Cancelled' ), array( 'id' => $invid )); logActivity("Cancelled Invoice - Invoice ID: " . $invid, $userid); run_hook('InvoiceCancelled', array( 'invoiceid' => $invid )); } if($page) { $userid .= "&page=" . $page; } redir("userid=" . $userid . "&filter=1"); } if($duplicateinvoice) { check_token("WHMCS.admin.default"); foreach($selectedinvoices as $invid) { $invoices = new WHMCS_Invoices(); $invoices->duplicate($invid); } if($page) { $userid .= "&page=" . $page; } redir("userid=" . $userid . "&filter=1"); } if($massdelete) { check_token("WHMCS.admin.default"); foreach($selectedinvoices as $invid) { delete_query('tblinvoices', array( 'id' => $invid )); logActivity("Deleted Invoice - Invoice ID: " . $invid, $userid); } if($page) { $userid .= "&page=" . $page; } redir("userid=" . $userid . "&filter=1"); } if($paymentreminder) { check_token("WHMCS.admin.default"); foreach($selectedinvoices as $invid) { sendMessage("Invoice Payment Reminder", $invid); logActivity("Invoice Payment Reminder Sent - Invoice ID: " . $invid, $userid); } if($page) { $userid .= "&page=" . $page; } redir("userid=" . $userid . "&filter=1"); } if($merge) { check_token("WHMCS.admin.default"); checkPermission("Manage Invoice"); if(count($selectedinvoices) < 2) { if($page) { $userid .= "&page=" . $page; } redir("userid=" . $userid . "&mergeerr=1"); } $selectedinvoices = db_escape_numarray($selectedinvoices); sort($selectedinvoices); $endinvoiceid = end($selectedinvoices); update_query('tblinvoiceitems', array( 'invoiceid' => $endinvoiceid ), "invoiceid IN (" . db_build_in_array($selectedinvoices) . ")"); update_query('tblaccounts', array( 'invoiceid' => $endinvoiceid ), "invoiceid IN (" . db_build_in_array($selectedinvoices) . ")"); update_query('tblorders', array( 'invoiceid' => $endinvoiceid ), "invoiceid IN (" . db_build_in_array($selectedinvoices) . ")"); $result = select_query('tblinvoices', "SUM(credit)", "id IN (" . db_build_in_array($selectedinvoices) . ")"); $data = mysql_fetch_array($result); $totalcredit = $data[0]; update_query('tblinvoices', array( 'credit' => $totalcredit ), array( 'id' => $endinvoiceid )); unset($selectedinvoices[count($selectedinvoices) - 1]); delete_query('tblinvoices', "id IN (" . db_build_in_array($selectedinvoices) . ")"); updateInvoiceTotal($endinvoiceid); logActivity("Merged Invoice IDs " . db_build_in_array($selectedinvoices) . " to Invoice ID: " . $endinvoiceid, $userid); if($page) { $userid .= "&page=" . $page; } redir("userid=" . $userid . "&filter=1"); } if($masspay) { check_token("WHMCS.admin.default"); if(count($selectedinvoices) < 2) { if($page) { $userid .= "&page=" . $page; } redir("userid=" . $userid . "&masspayerr=1"); } $invoiceid = createInvoices($userid); $paymentmethod = getClientsPaymentMethod($userid); $invoiceitems = array(); foreach($selectedinvoices as $invoiceid) { $result = select_query('tblinvoices', '', array( 'id' => $invoiceid )); $data = mysql_fetch_array($result); $subtotal += $data['subtotal']; $credit += $data['credit']; $tax += $data['tax']; $tax2 += $data['tax2']; $thistotal = $data['total']; $result = select_query('tblaccounts', "SUM(amountin)", array( 'invoiceid' => $invoiceid )); $data = mysql_fetch_array($result); $thispayments = $data[0]; $thistotal = $thistotal - $thispayments; insert_query('tblinvoiceitems', array( 'userid' => $userid, 'type' => 'Invoice', 'relid' => $invoiceid, 'description' => $_LANG['invoicenumber'] . $invoiceid, 'amount' => $thistotal, 'duedate' => "now()", 'paymentmethod' => $paymentmethod )); } $invoiceid = createInvoices($userid, true, true, array( 'invoices' => $selectedinvoices )); redir("userid=" . $userid . "&masspayid=" . $invoiceid . "&filter=1"); } if($delete) { check_token("WHMCS.admin.default"); checkPermission("Delete Invoice"); delete_query('tblinvoices', array( 'id' => $invoiceid )); logActivity("Deleted Invoice - Invoice ID: " . $invoiceid, $userid); if($page) { $userid .= "&page=" . $page; } redir("userid=" . $userid . "&filter=1"); } ob_start(); $aInt->deleteJSConfirm('doDelete', 'invoices', 'delete', "clientsinvoices.php?userid=" . $userid . "&delete=true&invoiceid="); $jquerycode .= "\$(\".invtooltip\").tooltip({cssClass:\"invoicetooltip\"});"; if($mergeerr) { infoBox($aInt->lang('invoices', 'mergeerror'), $aInt->lang('invoices', 'mergeerrordesc')); } if($masspayerr) { infoBox($aInt->lang('invoices', 'masspay'), $aInt->lang('invoices', 'mergeerrordesc')); } if($masspayid) { infoBox($aInt->lang('invoices', 'masspay'), $aInt->lang('invoices', 'masspaysuccess') . " - " . $aInt->lang('fields', 'invoicenum') . $masspayid . ""); } echo $infobox; $filt = new WHMCS_Filter('clinv'); $filterops = array( 'serviceid', 'addonid', 'domainid', 'clientname', 'invoicenum', 'lineitem', 'paymentmethod', 'invoicedate', 'duedate', 'datepaid', 'totalfrom', 'totalto', 'status' ); $filt->setAllowedVars($filterops); $filters = array(); $filters[] = "userid='" . (int) $userid . "'"; if($serviceid = $filt->get('serviceid')) { $filters[] = "id IN (SELECT invoiceid FROM tblinvoiceitems WHERE type='Hosting' AND relid='" . (int) $serviceid . "')"; } if($addonid = $filt->get('addonid')) { $filters[] = "id IN (SELECT invoiceid FROM tblinvoiceitems WHERE type='Addon' AND relid='" . (int) $addonid . "')"; } if($domainid = $filt->get('domainid')) { $filters[] = "id IN (SELECT invoiceid FROM tblinvoiceitems WHERE type IN ('DomainRegister','DomainTransfer','Domain') AND relid='" . (int) $domainid . "')"; } if($clientname = $filt->get('clientname')) { $filters[] = "concat(firstname,' ',lastname) LIKE '%" . db_escape_string($clientname) . "%'"; } if($invoicenum = $filt->get('invoicenum')) { $filters[] = "(tblinvoices.id='" . db_escape_string($invoicenum) . "' OR tblinvoices.invoicenum='" . db_escape_string($invoicenum) . "')"; } if($lineitem = $filt->get('lineitem')) { $filters[] = "tblinvoices.id IN (SELECT invoiceid FROM tblinvoiceitems WHERE userid=" . (int) $userid . " AND description LIKE '%" . db_escape_string($lineitem) . "%')"; } if($paymentmethod = $filt->get('paymentmethod')) { $filters[] = "tblinvoices.paymentmethod='" . db_escape_string($paymentmethod) . "'"; } if($invoicedate = $filt->get('invoicedate')) { $filters[] = "tblinvoices.date='" . toMySQLDate($invoicedate) . "'"; } if($duedate = $filt->get('duedate')) { $filters[] = "tblinvoices.duedate='" . toMySQLDate($duedate) . "'"; } if($datepaid = $filt->get('datepaid')) { $filters[] = "tblinvoices.datepaid>='" . toMySQLDate($datepaid) . "' AND tblinvoices.datepaid<='" . toMySQLDate($datepaid) . " 23:59:59'"; } if($totalfrom = $filt->get('totalfrom')) { $filters[] = "tblinvoices.total>='" . db_escape_string($totalfrom) . "'"; } if($totalto = $filt->get('totalto')) { $filters[] = "tblinvoices.total<='" . db_escape_string($totalto) . "'"; } if($status = $filt->get('status')) { if($status == 'Overdue') { $filters[] = "tblinvoices.status='Unpaid' AND tblinvoices.duedate<'" . date('Ymd') . "'"; } else { $filters[] = "tblinvoices.status='" . db_escape_string($status) . "'"; } } $filt->store(); WHMCS_Session::release(); echo "
getPhpSelf(); echo "?userid="; echo $userid; echo "\" method=\"post\">
"; echo $aInt->lang('fields', 'invoicenum'); echo ""; echo $aInt->lang('fields', 'invoicedate'); echo "
"; echo $aInt->lang('fields', 'lineitem'); echo ""; echo $aInt->lang('fields', 'duedate'); echo "
"; echo $aInt->lang('fields', 'paymentmethod'); echo ""; echo paymentMethodsSelection($aInt->lang('global', 'any')); echo ""; echo $aInt->lang('fields', 'datepaid'); echo "
"; echo $aInt->lang('fields', 'status'); echo ""; echo $aInt->lang('fields', 'totaldue'); echo ""; echo $aInt->lang('filters', 'from'); echo " "; echo $aInt->lang('filters', 'to'); echo "

lang('global', 'search'); echo "\" class=\"button\" /> lang('invoices', 'create'); echo "\" class=\"button\" onClick=\"window.location='invoices.php?action=createinvoice&userid="; echo $userid . generate_token('link'); echo "'\" class=\"btn-success\" />
"; $currency = getCurrency($userid); $gatewaysarray = getGatewaysArray(); $aInt->sortableTableInit('duedate', 'DESC'); $result = select_query('tblinvoices', "COUNT(*)", implode(" AND ", $filters)); $data = mysql_fetch_array($result); $numrows = $data[0]; $qryorderby = $orderby; if($qryorderby == 'id') { $qryorderby = "tblinvoices`.`invoicenum` " . $order . ",`tblinvoices`.`id"; } $result = select_query('tblinvoices', '', implode(" AND ", $filters), $qryorderby, $order, $page * $limit . ',' . $limit); while($data = mysql_fetch_array($result)) { $id = $data['id']; $invoicenum = $data['invoicenum']; $date = $data['date']; $duedate = $data['duedate']; $datepaid = $data['datepaid']; $credit = $data['credit']; $total = $data['total']; $paymentmethod = $data['paymentmethod']; $paymentmethod = $gatewaysarray[$paymentmethod]; $status = $data['status']; $status = getInvoiceStatusColour($status, false); $date = fromMySQLDate($date); $duedate = fromMySQLDate($duedate); $datepaid = $datepaid == "0000-00-00 00:00:00" ? '-' : fromMySQLDate($datepaid); $total = formatCurrency($credit + $total); if(!$invoicenum) { $invoicenum = $id; } $tabledata[] = array( "", "" . $invoicenum . "", $date, $duedate, $datepaid, "" . $total . "", $paymentmethod, $status, "\""lang('global', 'edit') . "\">", "\""lang('global', 'delete') . "\">" ); } $tableformurl = $_SERVER['PHP_SELF'] . "?userid=" . $userid . "&filter=1"; if($page) { $tableformurl .= "&page=" . $page; } $tableformbuttons = "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('invoices', 'merge') . "\" name=\"merge\" onclick=\"return confirm('" . $aInt->lang('invoices', 'mergeconfirm', '1') . "')\" /> lang('invoices', 'masspay') . "\" name=\"masspay\" onclick=\"return confirm('" . $aInt->lang('invoices', 'masspayconfirm', '1') . "')\" /> lang('global', 'delete') . "\" class=\"btn-danger\" name=\"massdelete\" onclick=\"return confirm('" . $aInt->lang('invoices', 'massdeleteconfirm', '1') . "')\" />"; echo $aInt->sortableTable(array( 'checkall', array( 'id', $aInt->lang('fields', 'invoicenum') ), array( 'date', $aInt->lang('fields', 'invoicedate') ), array( 'duedate', $aInt->lang('fields', 'duedate') ), array( 'datepaid', $aInt->lang('fields', 'datepaid') ), array( 'total', $aInt->lang('fields', 'total') ), array( 'paymentmethod', $aInt->lang('fields', 'paymentmethod') ), array( 'status', $aInt->lang('fields', 'status') ), '', '' ), $tabledata, $tableformurl, $tableformbuttons); $content = ob_get_contents(); ob_end_clean(); $aInt->content = $content; $aInt->jquerycode = $jquerycode; $aInt->jscode = $jscode; $aInt->display();