| '.$_ADMINLANG['fields']['invoicenum'].' | '.$_ADMINLANG['fields']['clientname'].' | '.$_ADMINLANG['fields']['invoicedate'].' | '.$_ADMINLANG['fields']['duedate'].' | '.$_ADMINLANG['fields']['totaldue'].' | '.$_ADMINLANG['fields']['paymentmethod'].' | |
';
$id = '';
$query = "SELECT tblinvoices.*,tblinvoices.total-COALESCE((SELECT SUM(amountin) FROM tblaccounts WHERE tblaccounts.invoiceid=tblinvoices.id),0) AS invoicebalance,tblclients.firstname,tblclients.lastname FROM tblinvoices INNER JOIN tblclients ON tblclients.id=tblinvoices.userid WHERE tblinvoices.status='Unpaid' ORDER BY duedate,date ASC LIMIT 0,5";
$result = full_query($query);
while ($data = mysql_fetch_array($result)) {
$id = $data["id"];
$invoicenum = $data["invoicenum"];
$userid = $data["userid"];
$firstname = $data["firstname"];
$lastname = $data["lastname"];
$date = $data["date"];
$duedate = $data["duedate"];
$total = $data["total"];
$invoicebalance = $data["invoicebalance"];
$paymentmethod = $data["paymentmethod"];
$paymentmethod = $gatewaysarray[$paymentmethod];
$date = fromMySQLDate($date);
$duedate = fromMySQLDate($duedate);
$currency = getCurrency($userid);
if (!$invoicenum) $invoicenum = $id;
$content .= '| '.$invoicenum.' | '.$firstname.' '.$lastname.' | '.$date.' | '.$duedate.' | '.formatCurrency($total).' | '.$paymentmethod.' |  |
';
}
if (!$id) $content .= '| '.$_ADMINLANG['global']['norecordsfound'].' |
';
$content .= '
';
return array('title'=>$title,'content'=>$content);
}
add_hook("AdminHomeWidgets",1,"widget_open_invoices");
?>