/** * 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; } }
function select_or_insert_where() { global $auth_session; global $db; $domain_id = domain_id::get($this->domain_id); if($this->filter == "date") { $where = "and ap.ac_date between '$this->start_date' and '$this->end_date'"; } $sql = "SELECT pt_id, count(DISTINCT pt_id) as count from ".TB_PREFIX."payment_types WHERE pt_description = :pt_description AND domain_id = :domain_id GROUP BY pt_id;"; $sth = $db->query($sql,':pt_description',$this->type,':domain_id',$domain_id); $pt = $sth->fetch(); if($pt['count'] =="1") { return $pt['pt_id']; } //add new payment type if no Paypal type if($pt =="") { $SI_PAYMENT_TYPES = new SimpleInvoices_Db_Table_PaymentTypes(); $new_payment_type_data = array( 'pt_description' => $this->type, 'pt_enabled' => 1 ); $SI_PAYMENT_TYPES->insert($new_payment_type_data); $payment_type = new payment_type(); $payment_type->type = $this->type; $payment_type->domain_id = $domain_id; return $payment_type->select_or_insert_where(); } }
<?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']}";
<?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
<?php //stop the direct browsing to this file - let index.php handle which files get displayed checkLogin(); $SI_PAYMENT_TYPES = new SimpleInvoices_Db_Table_PaymentTypes(); $paymentTypes = $SI_PAYMENT_TYPES->fetchAll(); $smarty -> assign('paymentTypes',$paymentTypes); $smarty -> assign('pageActive', 'payment_type'); $smarty -> assign('active_tab', '#setting'); ?>
<?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_BILLER = new SimpleInvoices_Db_Table_Biller(); //$maxInvoice = maxInvoice(); jsBegin(); jsFormValidationBegin("frmpost"); #jsValidateifNum("ac_inv_id",$LANG['invoice_id']); #jsPaymentValidation("ac_inv_id",$LANG['invoice_id'],1,$maxInvoice['maxId']); jsValidateifNum("ac_amount",$LANG['amount']); jsValidateifNum("ac_date",$LANG['date']); jsFormValidationEnd(); jsEnd(); /* end validataion code */ $today = date("Y-m-d"); $invoice = null; if(!isset($_GET['id'])) { throw new SimpleInvoices_Exception('Invalid invoice identifier.'); }
$check_payment->filter='online_payment_id'; $check_payment->online_payment_id = $p->ipn_data['txn_id']; $check_payment->domain_id = $domain_id; $number_of_payments = $check_payment->count(); $logger->log('Paypal - number of times this payment is in the db: '.$number_of_payments, Zend_Log::INFO); if($number_of_payments > 0) { $xml_message .= 'Online payment '.$p->ipn_data['tnx_id'].' has already been entered into Simple Invoices - exiting for domain_id='.$domain_id; $logger->log($xml_message, Zend_Log::INFO); } if($number_of_payments == '0') { $SI_PAYMENTS = new SimpleInvoices_Db_Table_Payment(); $SI_PAYMENT_TYPES = new SimpleInvoices_Db_Table_PaymentTypes(); $payment_data = array( 'ac_inv_id' => $p->ipn_data['invoice'], 'ac_amount' => $p->ipn_data['mc_gross'], 'ac_notes' => $paypal_data, 'ac_date' => date( 'Y-m-d', strtotime($p->ipn_data['payment_date'])), 'online_payment_id' => $p->ipn_data['txn_id'] ); $payment_type = new payment_type(); $payment_type->type = "Paypal"; $payment_type->domain_id = $domain_id; $payment_type_data = array( 'type' => 'Paypal'
<?php //stop the direct browsing to this file - let index.php handle which files get displayed checkLogin(); $SI_PAYMENT_TYPES = new SimpleInvoices_Db_Table_PaymentTypes(); //TODO jsBegin(); jsFormValidationBegin("frmpost"); jsValidateRequired("pt_description",$LANG['payment_type_description']); jsFormValidationEnd(); jsEnd(); #get the invoice id $payment_type_id = $_GET['id']; $paymentType = $SI_PAYMENT_TYPES->getPaymentTypeById($payment_type_id); $smarty->assign('paymentType',$paymentType); $smarty -> assign('pageActive', 'payment_type'); $subPageActive = $_GET['action'] =="view" ? "payment_types_view" : "payment_types_edit" ; $smarty -> assign('subPageActive', $subPageActive); $smarty -> assign('active_tab', '#setting'); ?>
public function getType() { $paymentTypes = new SimpleInvoices_Db_Table_PaymentTypes(); return $paymentTypes->getPaymentTypeById($this->_data['ac_payment_type']); }