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; }