Change Log

1. That when the list of invoices are selected to display in the flexigrid list on the primary invoice screen, the aging information does not have to be calculated thus improving performance.
2. Removal of the Large Dataset system preference option as this change eliminates need for its suppression of aging information calculation.

1. If line is in config.php but not custom.config.php, it will be added added to custom.config.php.
2. If line is in custom.config.php but not in config.php, it will be enclosed in a "Possibly deprecated" comment lines.
3. The version name and date will be set to the value in the config.php file.

• Extension now automatically adds the new parent_customer_id field to the si_customers table when the extension is enabled and the customer information is accessed.
• The credit card information is masked leaving the last four digits showing.

Removed old library from project. This included removing it as a sub-module and adding it as directly supported files. This was necessary as there is no ongoing maintenance for Zend Framework 1 on Github.

These changes implement a process that allows files that might be updated by multiple extensions to specify only the section that needs to be changed rather than having to replicate the entire file. This means there won't be competition between extensions having to consider whether or not another extension has been enabled and uses the same file. The following files were specifically enhanced to accommodate the likely use in multiple extensions:

• template/default/reports/index.tpl: Modified to contain section identifiers at which an extension can specify a menu entry is to be inserted. Use the extension/past_due_report/template/default/reports/index.tpl file as an example.
• templates/default/menu.tpl: Modified to contain section identifiers at which an extension can specify a menu entry is to be inserted. Use the extension/custom_flags/templates/default/menu.tpl file as an example.

If you use a start and end date that are positioned vertically, the popup for the start date covers the icon to access the popup for the stop date making it a two click process to get to the stop date when no change is made in the start date. This change positions the popup to the right so the icons aren't obscured and the stop date can be accessed directly.

This change include a report to show customer's with past due invoices. The report can optionally display which invoices are past due for each customer. Additionally, this extension adds a smarty template variable: $past_due_amount for use in the invoice template.

• Modified HTML document generation logic to render HTML 5 files. This includes removal of attributes such as, <table align="center" >.
• Modified all occurrences of <textarea> sections to use class="editor" and eliminate the nowrap attribute.
• Changed all instances of the text, SimpleInvoices to be SimpleInvoices consistent with the logo and name of this applications.
• Remove the class="buttons" values from all <table> tags. The class is commented out in the main.css file.

This is an important enhancement and is recommended for all users that have internet access to their SimpleInvoices system. New features with this enhancement are:

• Addition of a username field to the database that will contain the unique ID that will be used to log into SimpleInvoices. Initially this is set to the email currently used. It can and should be changed by each user when they first logon the system. Their email information is retained for informational purposes.
• Addition of password constraint options maintained in the si_system_defaults table. Based on the settings of these fields, a validation pattern is generated that will be used to verify user password compliance. The new database fields are:
  • password_min_length: Specifies the minimum length user passwords must be. It can be set from 6 to 16 and defaults to 8 when initially enabled.
  • password_upper: Specifies if the password should contain at least one upper case character. Set to true when extension is enabled.
  • password_lower: Specifies if the password should contain at least one lower case character. Set to true when extension is enabled.
  • password_number: Specifies if the password should contain at least one numeric character. Set to true when extension is enabled.
  • password_special: Specifies if the password should contain at least one special character. Set to true when extension is enabled.
• Enhanced the set up and maintenance of user records for customers and billers. This feature already exists and is enhanced by this change to display a dropdown list of available settings for the user_id and field help information to explain this feature.
• Changes to allow your company name to replace the setting in the lang.php file as well as specify your company's logo do display on the logon screen and any other place you wish to use it. New fields added to the si_system_defaults table are:
  • company_name_item: Company name to replace default value (typically SimpleInvoices. The new value will be used in all places where this language it is currently used.
  • company_logo: Name of your logo file. That file must reside in the extensions/user_security/images folder. This will be displayed on the SI logon screen.
• Addition of an option to specify in minutes, the time interval for which an inactive session will be terminated. Currently, all sessions terminate after 60 minutes of inactivity. This is too long for a secured system. The new option allows you to specify a different interval ranging from 15 to 999 minutes. New field added to the si_system_defaults table is:
  • session_timeout: Number of minutes that a user session will remain alive before being terminated for inactivity. The session expiration interval will be renewed with each screen submission (note that entering data in a field is not considered a submission).
• Addition of new image files for help and required help will be used to make them less prominent on the user screens. These images are stored in the extensions/user_security/images folder and can be replaced by the original images if desired.

• Added global statements modified files to eliminate undefined variable warnings for variables defined in other included files.
• Added a test that does nothing to eliminate unused variable warnings for variables that are referenced by other files included following this one. The form of the test is: if ($variable_name) {}
• Deleted unused source.
• Excluding HTMLPurifier cache file from git management.
• Provide error log information if email fails.
• Added missing css class to fix display issue on invoice quick view form.

Currently custom fields display and function whether they have a label defined of not. This change imposes a rule that a label must be defined to activate a custom field cleaning up the interface and removes confusion by imposition of this simple requirement.

This is a step towards replacement of existing database logic through use of a class that will properly format and execute all database requests through a common interface. This interface abstracts the underlying database from the application code. The class also supports the dynamic build of SQL database maintenance statements, INSERT, UPDATE and DELETE, from key/value information defined in the $_POST super global. This will allow extensions (or any code) that maintains a database table to perform the maintenance request without the need specify table fields to maintain in the PDO requests. This also eliminates the need to add table maintenance functions to the sql_queries.php file which complicated extension development.

• Patch 37: reset default invoice template to 'default' due to new invoice template
• Patch 38 & 39: Alter custom field table - field length now 255 for field label and name
• Patch 40 - 116: Alter database fields
• Patch 63: Introduce new system_defaults table
• Patch 116 - 122: Patches to convert defaults from the old table to the new si_system_defaults table

• Adding data to the custom fields table for invoice
• Adding custom fields to the invoices table

• UPDATE `si_custom_fields` SET `cf_custom_field` = 'product_cf4' WHERE `si_custom_fields`.`cf_id` =12 LIMIT 1 ;
• UPDATE `si_system_preferences` SET `def_inv_template` = 'default' WHERE `def_id` =1 LIMIT 1;

• PDF Print Preview: The border for the customer and biller details in print_preview.php doesn't show for the telephone fields
• Konqueror: Some of the javascript features don't work in Konqueror

• ALTER TABLE `si_customers` ADD `c_notes` TEXT NULL AFTER `c_email`
• ALTER TABLE `si_biller` ADD `b_notes` TEXT NULL AFTER `b_co_footer`
• ALTER TABLE `si_products` ADD `prod_notes` TEXT NOT NULL AFTER `prod_unit_price`

• CREATE TABLE `si_payment_types` (`pt_id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,`pt_description` VARCHAR( 250 ) NOT NULL ,`pt_enabled` VARCHAR( 1 ) NOT NULL DEFAULT '1');
• INSERT INTO `si_payment_types` ( `pt_id` , `pt_description` ) VALUES (NULL , 'Cash'), (NULL , 'Credit Card');
• ALTER TABLE `si_account_payments` ADD `ac_payment_type` INT( 10 ) NOT NULL DEFAULT '1';
• ALTER TABLE `si_system_preferences` ADD `def_payment_type` VARCHAR( 25 ) NOT NULL DEFAULT '1' ;

• In Manage Invoice/Manage Customer and Customer Details pages the fields "Total","Paid","owing" have been added to reflect the customers account summary
• A Process Payment feature has been added in Manage Invoice and Quick View to allow the recording of payments by clients for invoice

• ALTER TABLE `si_biller` ADD `b_enabled` varchar(1) NOT NULL default '1'
• ALTER TABLE `si_invoice_items` CHANGE `inv_it_quantity` `inv_it_quantity` FLOAT NOT NULL DEFAULT '0'
• CREATE TABLE `si_account_payments` ( `ac_id` INT(10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `ac_inv_id` VARCHAR( 10 ) NOT NULL , `ac_amount` DOUBLE( 25, 2 ) NOT NULL , `ac_notes` TEXT NOT NULL , `ac_date` DATETIME NOT NULL );

• ALTER TABLE si_biller ADD b_enabled varchar(1) NOT NULL default '1'
• ALTER TABLE si_customers ADD c_enabled varchar(1) NOT NULL default '1'
• ALTER TABLE si_preferences ADD pref_enabled varchar(1) NOT NULL default '1'
• ALTER TABLE si_products ADD prod_enabled varchar(1) NOT NULL default '1'
• ALTER TABLE si_tax ADD tax_enabled varchar(1) NOT NULL default '1'

• INSERT INTO si_invoice_type ( inv_ty_id , inv_ty_description ) VALUES (3, 'Consulting')

• Choosing default biller/customer/tax/preference now make invoice total and itemized default to the selected default

• ALTER TABLE si_tax CHANGE tax_description tax_description VARCHAR( 50 ) DEFAULT NULL
• ALTER TABLE si_system_preferences CHANGE def_inv_template def_inv_template VARCHAR( 50 ) DEFAULT NULL

• #update invoice no details to have a default currency sign of $
  • UPDATE `si_preferences` SET `pref_currency_sign` = '$', `pref_inv_detail_heading` = NULL WHERE `pref_id` =2 LIMIT 1 ;
• Add a row into the defaults table to handle the default number of line items
  • ALTER TABLE `si_system_preferences` ADD `def_number_line_items` INT( 25 ) NOT NULL ;
• Set the default number of line items to 5
  • UPDATE `si_system_preferences` SET `def_number_line_items` = '5' WHERE `def_id` =1 LIMIT 1 ;
• Create the sql patch manager table
  • CREATE TABLE `si_sql_patchmanager` ( `sql_id` INT NOT NULL AUTO_INCREMENT , `sql_patch_ref` VARCHAR( 50 ) NOT NULL , `sql_patch` VARCHAR( 50 ) NOT NULL , `sql_release` VARCHAR( 25 ) NOT NULL , 'sql_statement` TEXT NOT NULL , PRIMARY KEY ( `sql_id` ) );
• Add logo and invoice footer support to biller
  • ALTER TABLE `si_biller` ADD `b_co_logo` VARCHAR( 50 ) ,ADD `b_co_footer` TEXT;
• Add default invoice template option
  • ALTER TABLE `si_system_preferences` ADD `def_inv_template` VARCHAR( 25 ) DEFAULT 'print_preview.php' NOT NULL ;