public function select($id, $domain_id = '')
{
global $logger;
if (!empty($domain_id)) {
$this->domain_id = $domain_id;
}
$sql = "SELECT \n i.*,\n\t\t i.date as date_original, \n (SELECT CONCAT(p.pref_inv_wording,' ',i.index_id)) as index_name,\n p.pref_inv_wording AS preference,\n p.status\n FROM \n " . TB_PREFIX . "invoices i LEFT JOIN \n\t\t\t\t\t" . TB_PREFIX . "preferences p \n\t\t\t\t\t\tON (i.preference_id = p.pref_id AND i.domain_id = p.domain_id)\n WHERE \n i.domain_id = :domain_id \n AND \n\t\t\t\t\ti.id = :id";
$sth = dbQuery($sql, ':id', $id, ':domain_id', $this->domain_id);
$invoice = $sth->fetch();
$invoice['calc_date'] = date('Y-m-d', strtotime($invoice['date']));
$invoice['date'] = siLocal::date($invoice['date']);
$invoice['total'] = getInvoiceTotal($invoice['id'], $domain_id);
$invoice['gross'] = $this->getInvoiceGross($invoice['id'], $this->domain_id);
$invoice['paid'] = calc_invoice_paid($invoice['id'], $domain_id);
$invoice['owing'] = $invoice['total'] - $invoice['paid'];
$invoice['invoice_items'] = $this->getInvoiceItems($id, $this->domain_id);
#invoice total tax
$sql2 = "SELECT SUM(tax_amount) AS total_tax, SUM(total) AS total FROM " . TB_PREFIX . "invoice_items WHERE invoice_id = :id AND domain_id = :domain_id";
$sth2 = dbQuery($sql2, ':id', $id, ':domain_id', $this->domain_id);
$result2 = $sth2->fetch();
//$invoice['total'] = number_format($result['total'],2);
$invoice['total_tax'] = $result2['total_tax'];
$invoice['tax_grouped'] = taxesGroupedForInvoice($id);
return $invoice;
}
public static function select($id)
{
global $logger;
global $db;
global $auth_session;
$sql = "SELECT \n i.*,\n\t\t i.date as date_original, \n (SELECT CONCAT(p.pref_inv_wording,' ',i.index_id)) as index_name,\n p.pref_inv_wording AS preference,\n p.status\n FROM \n " . TB_PREFIX . "invoices i, \n " . TB_PREFIX . "preferences p \n WHERE \n i.domain_id = :domain_id \n and\n i.preference_id = p.pref_id\n and \n i.id = :id";
$sth = $db->query($sql, ':id', $id, ':domain_id', $auth_session->domain_id);
$invoice = $sth->fetch();
$invoice['calc_date'] = date('Y-m-d', strtotime($invoice['date']));
$invoice['date'] = siLocal::date($invoice['date']);
$invoice['total'] = getInvoiceTotal($invoice['id']);
$invoice['gross'] = invoice::getInvoiceGross($invoice['id']);
$invoice['paid'] = calc_invoice_paid($invoice['id']);
$invoice['owing'] = $invoice['total'] - $invoice['paid'];
$invoice['invoice_items'] = invoice::getInvoiceItems($id);
#invoice total tax
$sql2 = "SELECT SUM(tax_amount) AS total_tax, SUM(total) AS total FROM " . TB_PREFIX . "invoice_items WHERE invoice_id = :id";
$sth2 = dbQuery($sql2, ':id', $id) or die(htmlsafe(end($dbh->errorInfo())));
$result2 = $sth2->fetch();
//$invoice['total'] = number_format($result['total'],2);
$invoice['total_tax'] = $result2['total_tax'];
$invoice['tax_grouped'] = taxesGroupedForInvoice($id);
return $invoice;
}
* 2007-07-27
*
* License:
* GPL v2 or above
*
* Website:
* http://www.simpleinvoices.org
*/
//stop the direct browsing to this file - let index.php handle which files get displayed
checkLogin();
#get the invoice id
$invoice_id = $_GET['id'];
$invoice = getInvoice($invoice_id);
$preference = getPreference($invoice['preference_id']);
$defaults = getSystemDefaults();
$invoicePaid = calc_invoice_paid($invoice_id);
$invoiceItems = invoice::getInvoiceItems($invoice_id);
$smarty->assign("invoice", $invoice);
$smarty->assign("preference", $preference);
$smarty->assign("defaults", $defaults);
$smarty->assign("invoicePaid", $invoicePaid);
$smarty->assign("invoiceItems", $invoiceItems);
/*If delete is disabled - dont allow people to view this page*/
if ($defaults['delete'] == 'N') {
die('Invoice deletion has been disabled, you are not supposed to be here');
}
if ($_GET['stage'] == 2 and $_POST['doDelete'] == 'y') {
global $dbh;
$dbh->beginTransaction();
$error = false;
//delete line item taxes
function getInvoices(&$sth)
{
global $config;
$invoice = null;
if ($invoice = $sth->fetch()) {
$invoice['calc_date'] = date('Y-m-d', strtotime($invoice['date']));
$invoice['date'] = siLocal::date($invoice['date']);
#invoice total total - start
$invoice['total'] = getInvoiceTotal($invoice['id']);
#invoice total total - end
#amount paid calc - start
$invoice['paid'] = calc_invoice_paid($invoice['id']);
#amount paid calc - end
#amount owing calc - start
$invoice['owing'] = $invoice['total'] - $invoice['paid'];
#amount owing calc - end
}
return $invoice;
}
function getInvoices(&$sth) {
global $config;
$invoice = null;
$SI_INVOICE_ITEMS = new SimpleInvoices_Db_Table_InvoiceItems();
if($invoice = $sth->fetch()) {
$invoice['calc_date'] = date( 'Y-m-d', strtotime( $invoice['date'] ) );
$invoice['date'] = siLocal::date($invoice['date']);
#invoice total total - start
$invoice['total'] = $SI_INVOICE_ITEMS->getInvoiceTotal($invoice['id']);
#invoice total total - end
#amount paid calc - start
$invoice['paid'] = calc_invoice_paid($invoice['id']);
#amount paid calc - end
#amount owing calc - start
$invoice['owing'] = $invoice['total'] - $invoice['paid'];
#amount owing calc - end
}
return $invoice;
}
