Esempi in PHP per SimpleInvoices_Db_Table_Customers

Esempio n. 1

File: SystemDefaults.php Progetto: CalhounGaming/simpleinvoices

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

Esempio n. 2

File: edit.php Progetto: CalhounGaming/simpleinvoices

<?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']}";

Esempio n. 3

File: invoice.php Progetto: CalhounGaming/simpleinvoices

*
* 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();

Esempio n. 4

File: manage.php Progetto: CalhounGaming/simpleinvoices

<?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

Esempio n. 5

File: save.php Progetto: CalhounGaming/simpleinvoices

*	 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'],

Esempio n. 6

File: quick_view.php Progetto: CalhounGaming/simpleinvoices

*	 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();

Esempio n. 7

File: custom_field_3.php Progetto: CalhounGaming/simpleinvoices

* 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() ;

Esempio n. 8

File: Customer.php Progetto: CalhounGaming/simpleinvoices

 /**
  * 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']);
 }

Esempio n. 9

File: index.php Progetto: CalhounGaming/simpleinvoices

* 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'));

}

Esempio n. 10

File: usedefault.php Progetto: CalhounGaming/simpleinvoices

* 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");

Esempio n. 11

File: sql_queries.php Progetto: CalhounGaming/simpleinvoices

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