/** * Get a system default value * * @param mixed $name * @return mixed */ public function findByName($name) { switch ($name) { case 'biller': $SI_BILLER = new SimpleInvoices_Db_Table_Biller(); return $SI_BILLER->getDefault(); break; case 'customer': $SI_CUSTOMERS = new SimpleInvoices_Db_Table_Customers(); return $SI_CUSTOMERS->getDefault(); break; case 'payment_type': $SI_PAYMENT_TYPES = new SimpleInvoices_Db_Table_PaymentTypes(); return $SI_PAYMENT_TYPES->getDefault(); break; case 'preference': $SI_PREFERENCES = new SimpleInvoices_Db_Table_Preferences(); return $SI_PREFERENCES->getDefault(); break; case 'tax': $SI_TAX = new SimpleInvoices_Db_Table_Tax(); return $SI_TAX->getDefault(); break; default: $auth_session = Zend_Registry::get('auth_session'); $select = $this->select(); $select->where('name = ?', $name); $select->where('domain_id = ?', $auth_session->domain_id); $result = $this->getAdapter()->fetchRow($select); return $result['value']; break; } }
<?php //stop the direct browsing to this file - let index.php handle which files get displayed checkLogin(); $SI_SYSTEM_DEFAULTS = new SimpleInvoices_Db_Table_SystemDefaults(); $SI_PAYMENT_TYPES = new SimpleInvoices_Db_Table_PaymentTypes(); $SI_CUSTOMERS = new SimpleInvoices_Db_Table_Customers(); $SI_TAX = new SimpleInvoices_Db_Table_Tax(); $SI_BILLER = new SimpleInvoices_Db_Table_Biller(); $SI_PREFERENCES = new SimpleInvoices_Db_Table_Preferences(); #system defaults query $defaults = $SI_SYSTEM_DEFAULTS->fetchAll(); if ($_GET["submit"] == "line_items") { jsBegin(); jsFormValidationBegin("frmpost"); jsValidateifNum("def_num_line_items","Default number of line items"); jsFormValidationEnd(); jsEnd(); $default = "line_items"; $escaped = htmlsafe($defaults[line_items]); $value = <<<EOD <input type="text" size="25" name="value" value="$escaped"> EOD; $description = "{$LANG['default_number_items']}";
* * Last edited: * 2007-07-19 * * 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(); $SI_PRODUCTS = new SimpleInvoices_Db_Table_Products(); $SI_SYSTEM_DEFAULTS = new SimpleInvoices_Db_Table_SystemDefaults(); $SI_CUSTOMERS = new SimpleInvoices_Db_Table_Customers(); $SI_TAX = new SimpleInvoices_Db_Table_Tax(); $SI_BILLER = new SimpleInvoices_Db_Table_Biller(); $SI_PREFERENCES = new SimpleInvoices_Db_Table_Preferences(); $billers = $SI_BILLER->fetchAllActive(); $customers = $SI_CUSTOMERS->fetchAllActive(); $taxes = $SI_TAX->fetchAllActive(); $products = $SI_PRODUCTS->findActive(); $preferences = $SI_PREFERENCES->fetchAllActive(); $defaults = $SI_SYSTEM_DEFAULTS->fetchAll(); $defaultBiller = $SI_BILLER->getDefault(); $defaultCustomerID = (isset($_GET['customer_id'])) ? $_GET['customer_id'] : $SI_CUSTOMERS->getDefault(); $defaultTax = $SI_TAX->getDefault();
<?php //stop the direct browsing to this file - let index.php handle which files get displayed checkLogin(); //gets the long language name out of the short name $SI_SYSTEM_DEFAULTS = new SimpleInvoices_Db_Table_SystemDefaults(); $SI_PAYMENT_TYPES = new SimpleInvoices_Db_Table_PaymentTypes(); $SI_CUSTOMERS = new SimpleInvoices_Db_Table_Customers(); $SI_BILLER = new SimpleInvoices_Db_Table_Biller(); $SI_TAX = new SimpleInvoices_Db_Table_Tax(); $SI_PREFERENCES = new SimpleInvoices_Db_Table_Preferences(); $lang = $SI_SYSTEM_DEFAULTS->findByName('language'); $languages = getLanguageList($include_dir . 'sys/lang/'); foreach($languages as $language) { if($language->shortname == $lang) { $lang = $language->name; break; } } // Default delete $defaults['delete'] = $system_defaults->findByName('delete'); $defaults['delete'] = $defaults['delete']==1?$LANG['enabled']:$LANG['disabled']; // Default Logging $defaults['logging'] = $system_defaults->findByName('logging'); $defaults['logging'] = $defaults['logging']==1?$LANG['enabled']:$LANG['disabled']; // Default inventory
* Justin Kelly, Nicolas Ruflin * * Last edited: * 2007-07-19 * * 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(); $SI_CUSTOMERS = new SimpleInvoices_Db_Table_Customers(); # Deal with op and add some basic sanity checking $op = !empty( $_POST['op'] ) ? addslashes( $_POST['op'] ) : NULL; #insert customer $saved = false; if (($op === "insert_customer") || ($op === 'edit_customer')) { $customer_data = array( 'attention' => $_POST['attention'], 'name' => $_POST['name'], 'tax_id' => $_POST['tax_id'], 'street_address' => $_POST['street_address'],
* Justin Kelly, Nicolas Ruflin, Ap.Muthu * * Last edited: * 2008-01-03 * * License: * GPL v2 or above * * Website: * http://www.simpleinvoices.or */ checkLogin(); $SI_SYSTEM_DEFAULTS = new SimpleInvoices_Db_Table_SystemDefaults(); $SI_CUSTOMERS = new SimpleInvoices_Db_Table_Customers(); $SI_INVOICE_TYPE = new SimpleInvoices_Db_Table_InvoiceType(); $SI_BILLER = new SimpleInvoices_Db_Table_Biller(); $SI_PREFERENCES = new SimpleInvoices_Db_Table_Preferences(); $SI_CUSTOM_FIELDS = new SimpleInvoices_Db_Table_CustomFields(); #get the invoice id $invoice_id = $_GET['invoice']; $invoice = getInvoice($invoice_id); $invoice_type = $SI_INVOICE_TYPE->getInvoiceType($invoice['type_id']); $customer = $SI_CUSTOMERS->getCustomerById($invoice['customer_id']); $biller = $SI_BILLER->getBiller($invoice['biller_id']); $preference = $SI_PREFERENCES->getPreferenceById($invoice['preference_id']); $defaults = $SI_SYSTEM_DEFAULTS->fetchAll();
* Authors: * Justin Kelly * * Last edited: * 2008-05-13 * * License: * GPL v3 * * Website: * http://www.simpleinvoices.org */ checkLogin(); $SI_CUSTOMERS = new SimpleInvoices_Db_Table_Customers(); $SI_BILLER = new SimpleInvoices_Db_Table_Biller(); #$menu =false; function firstOfMonth() { return date("Y-m-d", strtotime('01-01-'.date('Y').' 00:00:00')); } function lastOfMonth() { return date("Y-m-d", strtotime('31-12-'.date('Y').' 00:00:00')); } isset($_POST['start_date']) ? $start_date = $_POST['start_date'] : $start_date = firstOfMonth() ;
/** * Initializes invoice data. * This method is equivalent to the old getInvoice() */ protected function _initData() { $customers = new SimpleInvoices_Db_Table_Customers(); $this->_data = $customers->getCustomerById($this->_id); unset($this->_data['id']); }
* Contributors: * Matt West * * Last edited: * 2010-07-29 * * License: * GPL v3 * * Website: * http://www.simpleinvoices.org */ checkLogin(); $SI_CUSTOMERS = new SimpleInvoices_Db_Table_Customers(); $SI_BILLER = new SimpleInvoices_Db_Table_Biller(); #$menu =false; function firstOfMonth() { return date("Y-m-d", strtotime('01-01-'.date('Y').' 00:00:00')); } function lastOfMonth() { return date("Y-m-d", strtotime('31-12-'.date('Y').' 00:00:00')); }
* Last edited: * 2009-02-08 * * License: * GPL v2 or above * * Website: * http://www.simpleinvoices.org */ #table //stop the direct browsing to this file - let index.php handle which files get displayed checkLogin(); $SI_SYSTEM_DEFAULTS = new SimpleInvoices_Db_Table_SystemDefaults(); $SI_CUSTOMERS = new SimpleInvoices_Db_Table_Customers(); #get the invoice id $defaults = $SI_SYSTEM_DEFAULTS->fetchAll(); $master_customer_id = $_GET['customer_id']; $customer = $SI_CUSTOMERS->getCustomerById($master_customer_id); if ($_GET['action'] == 'update_template') { /* update default template for customer */ $sql = "UPDATE ".TB_PREFIX."customers SET custom_field4 = :cf4 WHERE id = :id"; dbQuery($sql, ':cf4', $_GET['id'], ':id', $master_customer_id ); $smarty -> assign("view","quick_view");
function getCustomers() { global $LANG; $SI_CUSTOMERS = new SimpleInvoices_Db_Table_Customers(); $result = $SI_CUSTOMERS->fetchAll(); $customers = array(); foreach($result as $customer) { if ($customer['enabled'] == 1) { $customer['enabled'] = $LANG['enabled']; } else { $customer['enabled'] = $LANG['disabled']; } #invoice total calc - start $customer['total'] = calc_customer_total($customer['id']); #invoice total calc - end #amount paid calc - start $customer['paid'] = calc_customer_paid($customer['id']); #amount paid calc - end #amount owing calc - start $customer['owing'] = $customer['total'] - $customer['paid']; #amount owing calc - end $customers[] = $customer; } return $customers; }