$default = "delete";
$description = $LANG['delete'];
$value = dropDown($array, $defaults['delete']);
}
else if ($_GET['submit'] == "logging") {
$array = array(0 => $LANG['disabled'], 1=>$LANG['enabled']);
$default = "logging";
$description = $LANG['logging'];
$value = dropDown($array, $defaults[$default]);
}
else if($_GET['submit'] == "language") {
$default = "language";
$languages = getLanguageList($include_dir . 'sys/lang/');
$system_defaults = new SimpleInvoices_Db_Table_SystemDefaults();
$lang = $system_defaults->findByName('language');
usort($languages,"compareNameIndex");
$description = $LANG['language'];
//print_r($languages);
$value = "<select name='value'>";
foreach($languages as $language) {
$selected = "";
if($language->shortname == $lang) {
$selected = " selected ";
}
$value .= "<option $selected value='".htmlsafe($language->shortname)."'>".htmlsafe("$language->name ($language->englishname) ($language->shortname)")."</option>";
}
$value .= "</select>";
function getData()
{
//echo "export - get data";
global $smarty;
global $siUrl;
global $include_dir;
$SI_BILLER = new SimpleInvoices_Db_Table_Biller();
$SI_CUSTOM_FIELDS = new SimpleInvoices_Db_Table_CustomFields();
$SI_PREFERENCES = new SimpleInvoices_Db_Table_Preferences();
switch ($this->module)
{
case "database":
{
$data = SimpleInvoices_Db::performBackup();
break;
}
case "statement":
{
$invoice = new invoice();
$invoice->biller = $this->biller_id;
$invoice->customer = $this->customer_id;
if ( $this->filter_by_date =="yes" )
{
if ( isset($this->start_date) )
{
$invoice->start_date = $this->start_date;
}
if ( isset($this->end_date) )
{
$invoice->end_date = $this->end_date;
}
if ( isset($this->start_date) AND isset($this->end_date) )
{
$invoice->having = "date_between";
}
$having_count = '1';
}
if ( $this->show_only_unpaid == "yes")
{
if ($having_count == '1')
{
$invoice->having_and = "money_owed";
$having_count = '2';
} else {
$invoice->having = "money_owed";
$having_count = '1';
}
}
if ( $this->show_only_real == "yes")
{
if ($having_count == '2')
{
$invoice->having_and2 = "real";
} elseif ($having_count == '1') {
$invoice->having_and = "real";
} else {
$invoice->having = "real";
}
}
$invoice_all = $invoice->select_all('count');
$invoices = $invoice_all->fetchAll();
foreach ($invoices as $i => $row) {
$statement['total'] = $statement['total'] + $row['invoice_total'];
$statement['owing'] = $statement['owing'] + $row['owing'] ;
$statement['paid'] = $statement['paid'] + $row['INV_PAID'];
}
// ToDo: THIS FILE IS MISSING!!
$templatePath = $include_dir . "sys/templates/default/statement/index.tpl";
$biller_details = $SI_BILLER->getBiller($this->biller_id);
$customer_details = customer::get($this->customer_id);
$this->file_name = "statement_".$this->biller_id."_".$this->customer_id."_".$invoice->start_date."_".$invoice->end_date;
$smarty -> assign('biller_id', $biller_id);
$smarty -> assign('biller_details', $biller_details);
$smarty -> assign('customer_id', $customer_id);
$smarty -> assign('customer_details', $customer_details);
$smarty -> assign('show_only_unpaid', $show_only_unpaid);
$smarty -> assign('show_only_real', $show_only_real);
$smarty -> assign('filter_by_date', $this->filter_by_date);
$smarty -> assign('invoices', $invoices);
$smarty -> assign('start_date', $this->start_date);
$smarty -> assign('end_date', $this->end_date);
$smarty -> assign('invoices',$invoices);
$smarty -> assign('statement',$statement);
$data = $smarty -> fetch(".".$templatePath);
break;
}
case "payment":
{
$customFieldLabels = $SI_CUSTOM_FIELDS->getLabels();
$payment = new SimpleInvoices_Payment($this->id);
$invoice = $payment->getInvoice();
$biller = $invoice->getBiller();
$logo = $biller->getLogo();
$logo = str_replace(" ", "%20", $logo);
$customer = $invoice->getCustomer();
$smarty -> assign("payment",$payment->toArray());
$smarty -> assign("invoice",$invoice->toArray());
$smarty -> assign("biller",$biller->toArray());
$smarty -> assign("logo",$logo);
$smarty -> assign("customer",$customer->toArray());
$smarty -> assign("invoiceType",$invoice->getType());
$smarty -> assign("paymentType",$payment->getType());
$smarty -> assign("preference",$invoice->getPreference());
$smarty -> assign("customFieldLabels",$customFieldLabels);
$smarty -> assign('pageActive', 'payment');
$smarty -> assign('active_tab', '#money');
$css = $siUrl."/sys/templates/invoices/default/style.css";
$smarty -> assign('css',$css);
$templatePath = $include_dir . "sys/templates/default/modules/payments/print.tpl";
$data = $smarty -> fetch($templatePath);
break;
}
case "invoice":
{
$SI_SYSTEM_DEFAULTS = new SimpleInvoices_Db_Table_SystemDefaults();
$invoice = invoice::select($this->id);
$invoice_number_of_taxes = numberOfTaxesForInvoice($this->id);
$customer = customer::get($invoice['customer_id']);
$biller = biller::select($invoice['biller_id']);
$preference = $SI_PREFERENCES->getPreferenceById($invoice['preference_id']);
$defaults = $SI_SYSTEM_DEFAULTS->fetchAll();
$logo = getLogo($biller);
$logo = str_replace(" ", "%20", $logo);
$invoiceItems = invoice::getInvoiceItems($this->id);
$spc2us_pref = str_replace(" ", "_", $invoice['index_name']);
$this->file_name = $spc2us_pref;
$customFieldLabels = $SI_CUSTOM_FIELDS->getLabels();
$customFieldDisplay = $SI_CUSTOM_FIELDS->getDisplay();
/*Set the template to the default*/
$template = $defaults['template'];
// Instead of appending the CSS we are going to inject it allowing
// a cleaner hierarchy tree while allowing public directories
$css_file = $include_dir ."/sys/templates/invoices/${template}/style.css";
if (file_exists($css_file)) {
$css = file_get_contents($css_file);
if ($css) {
// Create the tags
$css = '<style type="text/css" media="all">' . $css . '</style>';
}
} else {
$css = '';
}
$smarty->addTemplateDir($include_dir . "sys/templates/invoices/${template}/", 'Invoice_' . $template);
$smarty->addPluginsDir($include_dir ."sys/templates/invoices/${template}/plugins/");
$pageActive = "invoices";
$smarty->assign('pageActive', $pageActive);
if ($smarty->templateExists('file:[Invoice_' . $template . ']template.tpl')) {
$smarty -> assign('biller',$biller);
$smarty -> assign('customer',$customer);
$smarty -> assign('invoice',$invoice);
$smarty -> assign('invoice_number_of_taxes',$invoice_number_of_taxes);
$smarty -> assign('preference',$preference);
$smarty -> assign('logo',$logo);
$smarty -> assign('template',$template);
$smarty -> assign('invoiceItems',$invoiceItems);
$smarty -> assign('css',$css);
$smarty -> assign('customFieldLabels',$customFieldLabels);
$smarty -> assign('customFieldDisplay',$customFieldDisplay);
$data = $smarty->fetch('file:[Invoice_' . $template . ']template.tpl');
}
break;
}
}
return $data;
}
* 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_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();
<?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
$dbAdapter = Zend_Db::factory($config->resources->db->adapter, array(
'host' => $config->resources->db->params->host,
'username' => $config->resources->db->params->username,
'password' => $config->resources->db->params->password,
'dbname' => $config->resources->db->params->dbname)
);
*/
$errorMessage = '';
if (!empty($_POST['value'])) {
$cust_language = $_POST['value'];
$language = $cust_language;
$smarty -> assign("LANG",getLanguageArray());
}
// System defaults are needed in several places
$system_defaults = new SimpleInvoices_Db_Table_SystemDefaults();
if (!empty($_POST['user']) && !empty($_POST['pass']))
{
$errorMessage = $system_defaults->update('language', $language);
//// require_once 'Zend/Auth/Adapter/DbTable.php';
// Configure the instance with constructor parameters...
//$authAdapter = new Zend_Auth_Adapter_DbTable($dbAdapter, 'users', 'username', 'password');
// ...or configure the instance with setter methods
$authAdapter = new Zend_Auth_Adapter_DbTable(Zend_Db_Table::getDefaultAdapter());
//sql patch 161 changes user table name - need to accomodate
$user_table = (SimpleInvoices_Db_Table_SQLPatchManager::getNumberOfDoneSQLPatches() < "161") ? "users" : "user";
$user_email = (SimpleInvoices_Db_Table_SQLPatchManager::getNumberOfDoneSQLPatches() < "184") ? "user_email" : "email";
else $extension_name = NULL;
$action = $_GET['action'];
if (isset($_GET['description'])) $extension_desc = $_GET['description'];
else $extension_desc = NULL;
if ($extension_id == null) { // extension not yet registered
$count = 0;
} else {
$SI_EXTENSIONS = new SimpleInvoices_Db_Table_Extensions();
$info = $SI_EXTENSIONS->getExtensionById($extension_id);
$extension_name = $info['name'];
$extension_desc = $info['description'];
$system_defaults = new SimpleInvoices_Db_Table_SystemDefaults();
$extension_defaults = $system_defaults->fetchAllForExtension($extension_id);
$count = count($extension_defaults);
}
$smarty-> assign('id',$extension_id);
$smarty-> assign('action',$action);
$smarty-> assign('name',$extension_name);
$smarty-> assign('count',$count);
$smarty-> assign('description',$extension_desc);
$smarty-> assign('pageActive','extensions');
$smarty-> assign('active_tab','#settings');
?>
<?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_TAX = new SimpleInvoices_Db_Table_Tax();
$SI_CUSTOM_FIELDS = new SimpleInvoices_Db_Table_CustomFields();
#get custom field labels
$customFieldLabel = $SI_CUSTOM_FIELDS->getLabels();
$taxes = $SI_TAX->fetchAllActive();
//if valid then do save
if (array_key_exists('description', $_POST)) {
if ($_POST['description'] != "" ) {
include("sys/modules/products/save.php");
}
}
$smarty -> assign("defaults",$SI_SYSTEM_DEFAULTS->fetchAll());
$smarty -> assign('customFieldLabel',$customFieldLabel);
if (isset($save)) {
$smarty -> assign('save',$save);
} else {
$smarty -> assign('save','');
}
$smarty -> assign('taxes',$taxes);
$smarty -> assign('pageActive', 'product_add');
$smarty -> assign('active_tab', '#product');
<?php
checkLogin();
# Deal with op and add some basic sanity checking
error_log($_POST['name']." ".$_POST['value']);
$saved = false;
if (isset($_POST['op']) && $_POST['op'] == 'update_system_defaults' ) {
$system_defaults = new SimpleInvoices_Db_Table_SystemDefaults();
$saved = $system_defaults->update($_POST['name'], $_POST['value']);
}
$smarty -> assign("saved",$saved);
$smarty -> assign('pageActive', 'system_default');
$smarty -> assign('active_tab', '#setting');
