<div class="twelve columns">
<div class="element nopadding">
<h5>Overzicht facturen</h5>
<table class="table table-cp" id="invoices-table">
<thead>
<tr>
<th><i class="fa fa-check payed"></i></th>
<th>Nummer</th>
<th>Klant</th>
<th>Betaling</th>
<th>Totaal</th>
</tr>
</thead>
<tbody>
<?php
foreach (getInvoices('', $_GET['id']) as $invoices) {
$totalAmount = number_format($invoices['invoice_total'], 2, ',', '.');
$invoiceStatus = getInvoiceStatus($invoices['invoice_status']);
echo "<tr>";
echo "<th><a class='invoice status' href='/admin/invoices/{$invoices['invoice_number']}'>{$invoiceStatus}</a></th>";
echo "<th><a class='invoice number' href='/admin/invoices/{$invoices['invoice_number']}'>{$invoices['invoice_number']}</a></th>";
echo "<th><a class='invoice customer' target='_blank' href='/admin/users/{$invoices['invoice_recipient']}'>{$invoices['invoice_recipient']}</a></th>";
echo "<th><a class='invoice number' href='/admin/invoices/{$invoices['invoice_number']}'>{$invoices['invoice_number']}</a></th>";
echo "<th><a class='invoice total' href='/admin/invoices/{$invoices['invoice_number']}'>€ {$totalAmount}</a></th>";
echo '<tr>';
}
?>
</tbody>
</table>
</div>
</div>
//if this page has error with auth remove the above line and figure out how to do it right
$SI_INVOICE_TYPE = new SimpleInvoices_Db_Table_InvoiceType();
$domain_id = domain_id::get();
#$sql = "SELECT * FROM ".TB_PREFIX."invoices where domain_id = ".$domain_id;
#global $dbh;
#$sth = dbQuery($sql) or die(htmlsafe(end($dbh->errorInfo())));
//$sql = "SELECT * FROM ".TB_PREFIX."invoices LIMIT $start, $limit";
$invoice = new invoice();
$sth = $invoice->select_all();
$q = strtolower($_GET["q"]);
if (!$q) return;
while ($invoice = getInvoices($sth)) {
$invoiceType = $SI_INVOICE_TYPE->getInvoiceType($invoice['type_id']);
if (strpos(strtolower($invoice['index_id']), $q) !== false) {
$invoice['id'] = htmlsafe($invoice['id']);
$invoice['total'] = htmlsafe(number_format($invoice['total'],2));
$invoice['paid'] = htmlsafe(number_format($invoice['paid'],2));
$invoice['owing'] = htmlsafe(number_format($invoice['owing'],2));
echo "$invoice[id]|<table><tr><td class='details_screen'>$invoice[preference]:</td><td>$invoice[index_id]</td><td class='details_screen'>Total: </td><td>$invoice[total] </td></tr><tr><td class='details_screen'>Biller: </td><td>$invoice[biller] </td><td class='details_screen'>Paid: </td><td>$invoice[paid] </td></tr><tr><td class='details_screen'>Customer: </td><td>$invoice[customer] </td><td class='details_screen'>Owing: </td><td><u>$invoice[owing]</u></td></tr></table>\n";
}
}
<Br>
<div class="element nopadding">
<h5>Betaalde facturen</h5>
<table class="table table-cp" id="invoices-table">
<thead>
<tr>
<th><i class="fa fa-check payed"></i></th>
<th>Nummer</th>
<th>Klant</th>
<th>Betaling</th>
<th>Totaal</th>
</tr>
</thead>
<tbody>
<?php
foreach (getInvoices() as $invoices) {
$totalAmount = number_format($invoices['invoice_total'], 2, ',', '.');
$invoiceStatus = getInvoiceStatus($invoices['invoice_status']);
echo "<tr>";
echo "<th><a class='invoice status' href='/admin/invoices/{$invoices['invoice_number']}'>{$invoiceStatus}</a></th>";
echo "<th><a class='invoice number' href='/admin/invoices/{$invoices['invoice_number']}'>{$invoices['invoice_number']}</a></th>";
echo "<th><a class='invoice customer' target='_blank' href='/admin/users/{$invoices['invoice_recipient']}'>{$invoices['invoice_recipient']}</a></th>";
echo "<th><a class='invoice number' href='/admin/invoices/{$invoices['invoice_number']}'>{$invoices['invoice_number']}</a></th>";
echo "<th><a class='invoice total' href='/admin/invoices/{$invoices['invoice_number']}'>€ {$totalAmount}</a></th>";
echo '<tr>';
}
?>
</tbody>
</table>
</div>
</div>
?>
<div id="main-content">
<div id="guts">
<div class="leftwrapper">
<div class="element nopadding">
<table class="table table-cp" id="invoices-table">
<thead>
<tr>
<th><i class="fa fa-check"></i></th>
<th>Nummer</th>
<th>Totaal</th>
</tr>
</thead>
<tbody>
<?php
foreach (getInvoices($_SESSION['user_num']) as $invoices) {
$totalAmount = number_format($invoices['invoice_total'], 2, ',', '.');
$invoiceStatus = getInvoiceStatus($invoices['invoice_status']);
echo "<tr>";
echo "<th><a class='invoice status' href='/invoice/{$invoices['invoice_number']}'>{$invoiceStatus}</a></th>";
echo "<th><a class='invoice number' href='/invoice/{$invoices['invoice_number']}'>{$invoices['invoice_number']}</a></th>";
echo "<th><a class='invoice total' href='/invoice/{$invoices['invoice_number']}'>€ {$totalAmount}</a></th>";
echo '<tr>';
}
?>
</tbody>
</table>
</div>
</div>
<div class="container">
#API access username goes here
define('WHMCS_API_PASSWORD', 'test123');
#API access password goes here
define('AUTO_AUTH_KEY', 'abcXYZ123');
define('FRESHDESK_DOMAIN', 'http://mycompany.freshdesk.com');
define('WHMCS_API_ACCESS_KEY', 'abc123');
#Specify the apiaccesskey or whitelist the access machines ips for api calls in WHMCS app.
header('Access-Control-Allow-Origin: ' . FRESHDESK_DOMAIN);
header('Access-Control-Allow-Headers: ' . 'x-csrf-token');
header('Content-Type: application/json; charset=utf-8');
check_proper_request();
define('AGENT_EMAIL', trim($_REQUEST['agent']));
define('REQ_EMAIL', trim($_REQUEST['email']));
$client = getClientDetails();
if (isset($client->result) && $client->result == 'success') {
$result = array('client' => $client, 'products' => getProducts($client)->products, 'domains' => getDomain($client)->domains, 'invoices' => getInvoices($client)->invoices, 'sso_url' => sso_url());
header('HTTP 1.0 200 OK');
echo json_encode($result);
} else {
header('HTTP 1.0 502 Bad Gateway');
echo json_encode($client);
}
function check_proper_request()
{
if (!array_key_exists('app_key', $_REQUEST) || $_REQUEST['app_key'] != APP_KEY) {
header('HTTP/1.0 401 Unauthorized');
echo '{ "error": "Invalid App key" }';
exit(0);
}
if (!array_key_exists('email', $_REQUEST) || !array_key_exists('agent', $_REQUEST)) {
header('HTTP/1.0 400 Bad Request');
<!--<input type="submit" name="update" value="Update" /><input type="submit" name="delete" value="Delete" />-->
<table id="tablesorter-demo" class="tablesorter" border="0" cellpadding="0" cellspacing="1">
<thead>
<tr class="table-header"><th width="10"><input type="checkbox" name"all"> </th>
<th>Invoice Number</th>
<th>Status</th>
<th>Date Issued</th>
<th>Amount Paid</th>
<th>Balance</th>
<th>Total Amount</th>
<th>Actions</th></tr>
</thead>
<tbody>
<?php
$numrows = count(getInvoices());
// number of rows to show per page
// find out total pages
$totalpages = ceil($numrows / $rowsperpage);
// get the current page or set a default
if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) {
// cast var as int
$currentpage = (int) $_GET['currentpage'];
} else {
// default page num
$currentpage = 1;
}
// end if
// if current page is greater than total pages...
if ($currentpage > $totalpages) {
// set current page to last page
$customer = getCustomers();
foreach ($customer as $value) {
?>
<option value="<?php
echo $value['cust_id'];
?>
"><?php
echo $value['cust_name'];
?>
</option>
<?php
}
?>
</select>
<label>Invoice Number </label><input type="text" name="name" value="<?php
echo count(getInvoices()) + 1;
?>
" disabled>
<label>Date issued </label> <select name="room_type" class="select" ><?php
$type = getRoomType();
foreach ($type as $value) {
?>
<option value="<?php
echo $value['cat_id'];
?>
"><?php
echo $value['category'];
?>
</option>
<?php
}
