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