SimpleInvoices - Change Log

2023-09-09 - 2023.0.7
- Fix gitignore from excluding css files needed by node modules.
2023-07-19 - 2023.0.6
- Test for session variable "role_name" not set when using non-authentication mode to change a user's password (typically the admin's password) when it has been forgotten.
2023-07-18 - 2023.0.5
- Check that session role name is set before checking for a value.
- Fix issue with database transaction logic reporting an error when there was none.
- Add SQL patch to assure si_log id variable characteristics is consistently defined.
- Fix issues with loading essential data when database created from scratch.
2023-05-08 - 2023.0.4
- Modify reports to work in line with user access role.
- Disabled customer dropdown for invoice edit when it is default for the assigned customer.
- Modified customer dropdown for users with customer role to only present enabled customers.
2023-04-28 - 2023.0.3
- Modify CRON delete logic to remove invoice item records.
- Fix issue with payment process screen customer_id field.
2023-04-26 - 2023.0.2
- Fixed multiple issues emanating from merge of globalization logic with 2023 version.
2023-04-20 - 2023.0.1
- Fixed multiple issues emanating from merge of globalization logic with 2023 version.
2023-04-20 - 2023.0.0
- Updated to run on PHP 8.1 and above. This is a requirement.
- Added template function for International Dates. See Template Date Formatting topic on SimpleInvoice.group forum.
2023-04-20 - 2020.4.10
- Use globalization for client side number formatting and verification.
- Check for payment owing before allowing payment screen display.
- Add logic to get inventory cost from product.
- Added logic to delete expense records.
2023-03-10 - 2020.4.8
- Fixed invoice line item deletion failure to remove associated taxes.
2023-02-07 - 2020.4.7
- Updated to use HTMLPurifier library maintained via composer.
- Update composer vendor files to current versions.
2022-12-20 - 2020.4.6
- Added need to verify db user's access to server in "Initial setup" message.
2022-11-18 - 2020.4.5
- Modified system defaults get functions to force int type value returned when appropriate.
2022-11-10 - 2020.4.4
- Add invoice display days SI Defaults option for invoice display screen.
2022-11-08 - 2020.4.3
- Add payment warehouse feature to SI.
- Fix issue with update from 2019.2 to 2020.x
- Update files for structure and full database update.
- Replace jquery alert dialogs with Alertify.js alerts.
- Enhance add payments to fill fields based on payment selection.
- Allow payments to be deleted based on delete days option in SI Defaults.
- Changed to use node jquery-ui library for ongoing maintenance.
2022-09-30 - 2020.4.2
- Make invoice_item_id a key field in the si_invoice_item_tax table.
- Add logic to support new invoice items for next new, cron generated, itemized invoice.
2022-08-29 - 2020.4.1
- Updated node library files.
- Fixed logic for user screen change of user role to properly set list.
- Miscellaneous clean up of function parameter declarations and comment syntax. No functional change.
2022-08-10 - 2020.4.0
- Updated to the latest version of Smarty template engine.
- Correct logic that set invoice unity price when product changes.
2022-07-22 - 2020.3.22
- Update trix library to resolve security issues.
2022-07-19 - 2020.3.21
- Add Jewish holidays to holiday logos. See How To ... topic for use.
2022-07-16 - 2020.3.20
- Fix issue with PDF invoice export not showing logo by:
  1. Make logo a relative path rather than absolute.
  2. Make holiday_logo function a UTIL function and set export logo via it.
  3. Update mPDF version to most current.
  4. Modify all invoice templates to use logo url directly from export.
  5. Modify payment print logic to generate holiday logo for template.
  6. Make smarty plugin, function.holiday_logo.php deprecated and made to do nothing.
2022-04-20 - 2020.3.19
- Update to version 1.13.1 of jquery-ui with Smoothness theme.
2022-04-16 - 2020.3.18
- Fix test for template directory existing to use the relative path.
- Add dueAmount to variables available for use on the template. This is the amount due for the client whose invoice is being generated, less the amount due for the actual invoice being reported.
2022-04-07 - 2020.3.17
- Logic to detect multiple payments to the same invoice fixed.
2022-04-06 - 2020.3.16
- Update npm and composer libraries.
2022-03-24 - 2020.3.15
- Changes from redcullin were added to the master branch. They address conversion of data in the json tables for DataTables to properly handle UTF-8 data from the database.
2022-02-20 - 2020.3.14
- Fixed issue with upgrade from master_2019.2 to master_2020 not working correctly. It was not detecting that updates from the 319 patch were needed and kept trying to install the essential data.
2021-11-04 - 2020.3.13
- Composer vendor libraries update.
2021-11-02 - 2020.3.12
- Modified default template to render foreign currency sign correctly on all fields.
- Add non-blank space to print_if_not_empty function following colon on label field. This preserves space if right justifying the text.
2021-10-16 - 2020.3.11
- Fixed logic the adds new items to the invoice edit item list.
2021-10-14 - 2020.3.10
- Updated composer and node library files.
2021-10-11 - 2020.3.09
- Fix issue with null parent id in customer record not processing on view screen.
- Move about version information to the "About SimpleInvoices" screen.
2021-10-05 - 2020.3.08
- Fix issue with "Filters" not working on invoice management page.
2021-09-30 - 2020.3.07
- Add option to display department field on customer manage screen. If not set, the customer's mobile phone will be displayed unless empty in which case the phone field will be displayed.
2021-09-29 - 2020.3.06
- Update node modules in particular DataTables to install a security update.
2021-09-23 - 2020.3.05
- Update field label alignment in forms. Right justify for better appearance and understandability.
2021-09-17 - 2020.3.04
- Modified to use jQuery validate npm module for form validation. This replaces the jQuery Validation Engine which is no longer updated save for user submitted fixes.
- Modified to use ToolTipster npm module for display of field help. Primary advantage is that you hover help icon to view help and the disappears automatically when you move it off the icon. This replaces the cluetip library previously used.
- Added PLACEHOLDERS array to $LANG file to provide field entry hints. Values such as "country", should be customized to $LANG files other than en_US. Note that these are just hints, they to not impose when the user enters.
2021-08-13 - 2020.3.03
- Fix issue with multiple, semicolon separated email addresses.
2021-08-09 - 2020.3.02
- Fixed issue with TOTAL STYLE invoice delete.
- Changes to use new PHP features such as null coalescing operator, unhandled error THROWS, etc.
- Changes all occurrences of die to exit just to be consistent.
- Fixed customer credit card handling logic to both set and clear the field.
2021-07-08 - 2020.3.01
- Removed unused items, emailhost, emailpassword, emailusername, pdfbottommargin, pdfleftmargin, pdfpapersize, pdfrightmargin, pdfscreensize, pdftopmargin, spreadsheet and wordprocessor, from the si_system_defaults table and associated setup files.
- Removed "company_name" from si_system_defaults table and from LANG files. Also removed "helpCompanyName" from LANG files. The only reference to this was in the templates/default/header.tpl file for the <title> tag. This tag now references the "company_name_item" field from the si_system_defaults table.
- Cleaned up display of description fields on invoices and tax functionality on Total style invoices.
- Cleaned up use of spelling for "itemized"/"itemised" settling on "itemized".
- Eliminated all references to consulting and consulting language elements.
- Modified create, edit, view and delete screens to use grid layout. Changes made for: billers, cron, custom_field, custom_flags, customers, expense, system_defaults
- Added cell-border property to all DataTables table class list.
- Modified customers view screen to use DataTables in the Customer Invoice Listing tab and changed tab heading to Customer Invoices. Also removed the Unpaid Invoices tab as the Customer Invoices table contains them, and they can be sorted to the top.
- Fixed issue of expense edit duplicating si_expense_item_tax records.
- All reports converted to use grid layout in selection criteria form.
- Moved Statement Of Invoices report to the standard reports category.
2021-06-14 - 2020.3.00
- Changed all invoices screens except manage, to use grid layout in place of tables.
- Changed throughout to reference Product Attribute Values instead of Product Values to better reflect the content being managed.
- Renamed si_products_values table to si_products_attributes_values.
- Modified generation of product attributes for invoice items on the edit invoice screen and display of selected values on the quick_view screen.
- Removed Consulting style invoice as upon further inspection found it was a non-functional type of the Itemized style invoice.
- Modified new setup menu to use grid layout and new verbiage.
- Shortened text in invoice print, payment, PDF, etc. buttons to make smaller.
2021-05-25 - 2020.2.00
- Converted main.css file into multiple scss files. Includes logic to build a compressed version of the main.css file for improved load times.
- Updated to use grid layout for quick_view invoice. Includes display enhancements for invoice item tables.
- Added Consulting type invoice to the types available when adding a new invoice. Logic was always there, just wasn't an option to switch to it.
- Updated npm and composer libraries for current versions.
- Added responsive settings to all DataTables implemented on manage screens.
- Updated reports to have standard background formatting for the run report criteria sections.
2021-05-10 - 2020.1.00
- Css updates to move to a responsive layout. Tabs and body of screens updated.
- Updates made to use responsive DataTables.
- Additional changes to implement DataTables via Ajax in files using DataTables.
- Vendor and node libraries updated.
- Login screen updated for new effects.
- Modified smarty functions empty and null to handle array parameters.
- Smarty function merge address updated to support street parameter for output.
2021-04-28 - 2020.0.21
- Updated smarty functions not empty vs not null to explain the difference.
2021-04-28 - 2020.0.20
- Modified to stop display of menu tabs before screen is rendered.
- Modified remaining management lists to use ajax to get list data.
2021-04-27 - 2020.0.19
- Remove standard library duplicate template invoice plugins.
2021-04-22 - 2020.0.18
- Change the Customer::managerTableInfo() function to specify return type.
- Change http references to https in lang.php files.
2021-04-22 - 2020.0.17
- Fix si_system_defaults management screen to display the selected value.
2021-04-13 - 2020.0.16
- Add system defaults option, "Invoice Description Open" for state when entering the new and edit invoice screens.
2021-03-26 - 2020.0.15
- Remove all language specific directories under documentation leaving only a general directory. The information in the deleted files exists in the topics in the SimpleInvoices.group forum.
- Clean up non-HTML5 code in files in the extras directory and deleted the invoice_grouped example as out of date and example is actually incorporated as the Product Groups options in SI. Also standardized name of default_templates directory to defaultTemplates.
- Change to "subTotal" and "login" langauge items to be single words, Subtotal and Login.
- Added generic font-family name to css usages.
- Added Cancel buttons to products and tax_rates view screens.
2021-03-20 - 2020.0.14
- Update node libraries
2021-03-19 - 2020.0.13
- Check for error return from parse_ini_file while loading custom.config.php
2021-01-28 - 2020.0.12
- Fix default payment type empty test.
- Add support to build si_index record for new si_preferences (aka Inv Prefs) records.
- Fix issue of field names not displaying on system_defaults edit screens.
- Alter order of invoices on the manage list screen to sort by index_id within date. This allows invoices in various numbering schemes to show up.
2020-12-23 - 2020.0.11
- Standardize date display format for yyyy-mm-dd in payment & expense view and invoice quick view screens.
2020-12-17 - 2020.0.10
- Fix customer create template for parent id field default value.
- Update libraries to current versions for datatables security issue.
2020-12-04 - 2020.0.09
- Fix phpunit tests to pass full run.
2020-12-03 - 2020.0.08
- Fix setting for system_defaults "delete" record to 0 rather than N.
- Add additional phpunit tests.
2020-12-01 - 2020.0.07
- Add updated nebraska invoice template and new cleverit template.
- Add additional phpunit tests.
2020-11-09 - 2020.0.06
- Remove duplicate config.ini parsing logic to allow .ini file values to be enclosed within double quotes so special characters can be used.
- Update vendor libraries to current versions
- Update phpunit tests
- Fixed smarty_function_do_tr naming issue that caused product custom fields error in invoice templates.
2020-11-04 - 2020.0.05
- Update formatting of Log output.
- Get shell scripts in lang directory working.
2020-11-03 - 2020.0.04
- Set correct path for tpl images.
2020-10-26 - 2020.0.03
- Fix cron api issues.
- Remove unused product_consulting.tpl, add_invoice_item.tpl and add_invoice_item.php.
2020-10-22 - 2020.0.02
- Fix quantity on invoice items not allowing a fraction (ie: 1.5)
2020-10-16 - 2020.0.01
- Add extension check for report template path.
- Fix issue with emailing invoice pdfs.
2020-10-15 - 2020.0.00
- New master branch based on PHP 7.4 standard.
- Removed mini and measurement extensions. Mini didn't work and measurement is a template type, not an extension.
- Incorporated the sub-customer and invoice-grouped (aka product-groups) into the standard program. See options in SI Defaults.
- Removed flexigrid images and moved used images to the images directory.
- Converted config.php and custom.config.php file to config.ini and custom.config.ini files respectively.
- Added program to perform one time conversion of the custom.config.php file on existing installations into the new custom.config.ini format file.
- Updated all reports to use new framework that provides print, export and email options.
2020-08-05 - 2019.2.30
- Change PdoDb class to handle information_schema column and table names to force them to be lower case. This is for UNIX like systems that enforce file name case sensitivity.
- Modified all manage.tpl templates the use DataTables to set the deferred render to enhance performance with larger tables.
2020-07-15 - 2019.2.29
- Fixed display of status in Pymt Types view screen.
2020-07-13 - 2019.2.28
- Use dbStd function to convert amount input on invoice items or total input for Total style invoices to fix issue of amounts not storing correctly in the database.
- Corrected new Total Style invoice handling of more than one tax item for the invoice.
2020-06-24 - 2019.2.27
- Modified to correctly generate pdf, xls and doc files for invoices.
- Update vendor libraries to current versions for PHP 7.2x and above.
2020-06-16 - 2019.2.26
- Modified code to handle multiple TO and BCC email addresses using a semicolon, ";", to separate each address.
- Added logic to report invalid email addresses in the FROM, TO and BCC fields as errors to the user rather than throwing an error that never displayed.
2020-06-03 - 2019.2.25
- Modified the table lists for all screens to use formatting in javascript rather than php code to enhance performance.
- Added "local.currency" code field to the config file to support properly formatting currency fields for non-invoice items such as costs for customers, and unit price for products. Note that invoice and payment tables get currency formatting information from the "Inv Prefs" link in the Settings tab.
2020-05-16 - 2019.2.24
- Updated the Dutch (nl_NL) language files using changes made by an SI user.
2020-05-06 - 2019.2.23
- Cleaned up the total style invoice edit screen input and display logic.
2020-04-01 - 2019.2.22
- Fixed logic for adding and deleting invoice item lines, and to fill in the unit price field when a new product is selected.
- Cleaned up the expense handling and display logic.
2020-03-09 - 2019.2.21
- Fixed issue of adding tax rate didn't return to correct screen.
2020-02-16 - 2019.2.20
- Modified Net Income Report to add customer selection feature.
2020-02-07 - 2019.2.19
- Modified getCustomerPastDue() function to add option to include or exclude a specified invoice.
2020-01-26 - 2019.2.18
- Fix error of set_aging setting not being read properly from database resulting in no aging information appearing on the invoice table.
2020-01-26 - 2019.2.17
- Added domain name to top bar in addition to domain id currently shown when logged in as a user for a domain other than 1.
2020-01-26 - 2019.2.16
- Fixed issue with adding a new user.
2020-01-23 - 2019.2.15
- Added set_aging field to the si_preferences table to control setting of aging information on invoices. Previously, aging information was updated only if the si_preferences pref_id was 1.
2020-01-14 - 2019.2.14
- Fixed Add new row in invoice edit to leave detail description showing or hidden per the state of the other rows.
- Fixed invoice view templates and invoice output templates to correctly display currency system enter using HTML code (aka Pound and Euro)
2019-12-10 - 2019.2.13
- To include nebraska invoice template in the standard application.
2019-11-28 - 2019.2.12
- Fix the templates/default/cron/add.tpl file domain_id hidden field.
2019-11-25 - 2019.2.11
- Set customer default_invoice empty value to 0 so matched field type.
2019-10-15 - 2019.2.10
- Add logic to clean up DataTables json file if present.
2019-10-08 - 2019.2.9
- Allow equal sign (=) in the config.ini value.
2019-10-07 - 2019.2.8
- Add pref_id field to the Inv Prefs screens.
2019-10-06 - 2019.2.7
- Add email secure parameter to Swift Mailer transport class.
2019-09-29 - 2019.2.6
- Add LOG messages to better follow email requests.
- Report thrown exceptions from Email methods.
2019-09-16 - 2019.2.5
- Fix prePatch308() result test to allow si_invoice_item_attachments creation if not present.
2019-09-16 - 2019.2.4
- Fix setting of no default tax on new product to NULL.
2019-09-13 - 2019.2.3
- Modify sql patch 317 to set auto increment on si_payment_types table.
- Update database structure and full definition files to reflect current settings.
2019-09-08 - 2019.2.2
- Modify patch management to add si_invoice_item_attachments to database if it doesn't exist.
2019-07-18 - 2019.2.1
- Fix issue of Invoice of getAllHavings selection logic.
- Fix date range logic in Sales Report By Period.
2019-07-02 - 2019.2.1
- Fix payment to update invoice aging info and remove debug stmt from pdf.
2019-06-15 - 2019.2.1
- Modified english email filter to allow multiple emails separated by a semicolon.
2019-06-13 - 2019.2.1
- Changed to format amounts in lists per localLocale setting in the custom.config.ini file.
2019-05-31 - 2019.2.1
- Fixed logic for cron when both the email biller and customer options are set to yes.
2019-05-21 - 2019.2.1
- Fixed to set domain_id for invoice created by recurrence to value from original invoice.
- Fixed setting of updated aging fields that array_merge() missed.
- Remove Invoice::getInvoice() method so new standard method Invoice::getOne() is used.
2019-05-11 - 2019.2.1
- Changed to use ZendFramework1 from composer, not library.
2019-04-24 - 2019.2.0
- Converted all DB tables to InnoDB using utf8 charset and uft8_unicode_ci collation.
- Add foreign keys to si_invoices.
- Remove foreign key checks in code as they will now occur automatically.
- Modified si_cron delete to also delete associated si_cron_log history records.
- Modified Customer manage page to only show default invoice button if customer is enabled.
- Modified empty database setup - 20190507
2019-03-21 - 2019.1.1
- Remove last use of ZendDb ($zendDb), replacing it with PdoDb.
- Use ajax for customer and product tables.
- Update Symphony and related files.
2019-02-21 - 2019.1.0
- Major update. Email with PDF attachment replaced with SwiftMailer.
2019-02-17 - 2019.0.2
- Correct cron api generation of new invoices copied in total from old invoice.
2019-02-15 - 2019.0.1
- Fixed issue where adding item to invoice does not blank the description field.
- Order product list to show enabled products before disabled.
2019-02-11 - 2019.0.0
- Renamed namespace_autoload branch to master_2019
2019-02-07 - 2018.3.5
- Changed submit button name in tpl files to NOT be 'id'. They are now named 'submit'. The name 'id' should be reserved across the board for an actual field name of 'id' (typically not present or hidden). Otherwise, it can trip PdoDb logic that by default builds commands from screen fields. In the case of add templates, this means the value of the submit button was being used for the auto-increment 'id' field.
- Fixed user maintenance logic to use correct domain that was preventing updates.
- Change all occurrences of redirect_redirect to refresh_redirect for consistency.
2019-01-25 - 2018.3.4
- Fixed display of customer invoices and invoices owing on Customer view screen.
2019-01-18 - 2018.3.3
- Fixed the export button (aka acrobat button) in the invoices list action column. It wasn't displaying update the export option list when selected.
- Fixed the section show hide options on the invoice quick view, itemized entry and details edit screens.
2018-12-30 - 2018.3.2
- Modified invoices and payments datatables to use ajax to speed it up.
2018-12-26 - 2018.3.1
- Modified to use current version of jquery and jquery-ui files. Using NPM to obtain current version of jquery.
- Replaced Flexigrid tables with Datatables. Datatables version is maintained via NPM. NOTE: The table logic is not yet tuned for performance. This means the process is noticeably slower the more records it has to load. In the future, large tables will be converted to use ajax to load a page of records at a time in much the same way flexigrid tables worked.
- Replaced out of date WYSIWYG rich text editor with the trix-master rich text editor.
- Modified labels in Settings menu to stop wrap around when enhancements displayed "System Preferences" to "SI Defaults", "Invoice Preferences" to "Inv Preferences", "Payment Types" to "Pymt Types", and "Backup Database" to "DB Backup".
- Eliminated dynamic javascript for field validation (validation.php) and replaced with use of jQueryValidationEngine logic throughout.
2018-12-03 - 2018.3.0
- Modified templates using a <button ...> tag to cancel so that it uses an anchor tag to exit the page. This makes all maintenance template use the same means to cancel the update/add/delete.
- Cleaned up all PDF and SI errors and warnings issued when E_ALL error mode is set. There is an exceptions for Smarty OPTIONS and CYCLE commands (and possibly others) that attempt to find these functions in the compiled (sysplugins) directory, but they are not compiled and are in the plugins directory. This warning is issued when the template using them is first accessed and compiled. Subsequent access does not report an error. Issue reported to Smarty team for hopeful cleanup in a future version.
- Changed to use namespace for class autoloading and add phpunit test support.
- Eliminated "htmlout" template function. Use "outHtml" instead.
- Moved all global functions to classes. Many are in the Util class.
2018-11-12 - 2018.2.6
- Added options to the "type" parameter of the Invoices::select_all() method to provide a total owing by itself or combined with the count of invoices. The combined feature is to minimize the data access overhead.
2018-10-27 - 2018.2.5
- Fixed issue of default invoice values not populating the new invoice.
2018-10-20 - 2018.2.4
- Move the default invoice extension to the main application. This includes adding default_invoice field to the customer file. When the patch is loaded and the module is enabled, the content of custom_field4 will be copied to the new field.
- Moved CustomField.php and BackupDb.php files to the include/class directory.
- Add help information to all the fields on the System Preferences screen. Also modified toggle field to show Enabled/Disabled text rather than 1/0 on the list screen.
- Deleted the text_ui extension as not needed, wasn't working and unmaintained.
2018-10-19 - 2018.2.3
- Add sales_representative field to the invoices table and add maintenance support for it. If the inv_custom_field_report extension is enabled, copy the content of the invoice custom_field3 to the new sales_representative field and move the inv_custom_field_report extension to the standard application as Sales by Representative.
- Added Custom Flags button to System Settings screen.
2018-10-17 - 2018.2.2
- Added owing to "invoices" table to fix aging issue.
- Fix inventory sales profit report selection logic.
2018-10-16 - 2018.2.1
- Modified templates using obsolete number_formatted function to use the updated siLocal_number function. This change fixes display of numbers formatted for the locale set in the custom.config.ini file.
2018-10-15 - 2018.2.0
- Added interactive calculation of invoice aging. This means:
  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.
2018-10-12 - 2018.1.3
- Added logic to create and/or update the custom.config.ini file. If the file doesn't exist, it will be created by making a copy from the config.ini. If it does exist, it will be updated as follows:
  1. If line is in config.ini but not custom.config.ini, it will be added to custom.config.ini.
  2. If line is in custom.config.ini but not in config.ini, 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.ini file.
2018-10-04 - 2018.1.2
- 2018-10-06 - Minor fix. Modified new installations to go to Start Working screen after required biller, customer and product have been set up. Previously went to the list screen of the last of the required items set up (typically Products).
- Moved SQL patch management logic into a new SqlPatchManager class. This change deprecates the sql_patches.php file which is left as an empty file to force it to overload the previous version of the file.
- Used addslashes() to fix issue where single quotes in essential_data.json file sql_statement entries stopped data from being loaded.
2018-10-03 - 2018.1.1
- Moved the payments extension into the standard code. This adds a check number field to the payment table. It also changes the logic to return to the invoice management page after a payment is entered.
- Fixed logic supporting department field in the customer table.
- Added last_invoice language index for the default_invoice module.
2018-09-25 - 2018.1.0
- Production Release User Security extension merged into the standard application. This implements username functionality for logins, password pattern rules maintained in System Preferences and a Session Timeout setting also in System Preferences that allows the minutes a session remains inactive to timeout. It also includes upgrade of the password hash to SHA256 from MD5.
- Documentation extension merged into the standard application to provide custom help message support via the "help" keyword.
  Ex:
  <a class="cluetip" href="#" rel="index.php?module=documentation&view=view&help={$cflg.field_help}" title="{$LANG.customFlagsUc}"><img src="{$helpImagePath}help-small.png" alt="" /></a>
- Created SystemDefaults class to consolidate function from sql_queries.php.
2018-09-22 - 2018.0.0
- Production Release Code brought current with PHP 7.2x requirements and all references to the SimpleInvoices forum and wiki have been updated to access the new SimpleInvoices Group website and Fearless359 SimpleInvoices Google+ forum.
- Added a signature field to the si_biller table along with maintenance support to provide text that will be automatically included in invoice and statement emails. This was an extension and that extension has been removed.
- Moved the Net Income Report extension to be a standard part of the application.
- Moved the Past Due Report extension to be a standard part of the application.
2018-09-12 - 2017.4.0
- Production Release Removed all deprecated uses of class name for the constructor and updated links for SI documentation to reference the new wiki site.
2018-09-12 - 2017.3.0
- Production Release Updated to support localLocale setting in the custom.config.ini (aka config.ini) files that use non-english number formats in templates. Also changed Help link in the header to reference the new SimpleInvoices.group site which will be updated to replace the SimpleInvoices.group site that is no longer available.
2017-12-20 - 2017.2.0
- Production Release Verified SI working with PHP 7.2
2016-12-27 - 2016.1.001
- Production Release Verified that this fork of SI will NOT be incorporated into the master stream. The reason is that modifications in this stream involve reformatting of code which obfuscates changes to the reviewers. Given the amount of work to bring this software to the point where it uses the current version of PHP, Zend, Smarty, etc. requires restructuring on a large scale, and therefore these changes will be retained.
- Merged Smarty 3 changes into this standard stream.
- Added Information link to the SI banner line between Help and Log out. This link displays information about the SI implementation including this change log and other useful files stored in the documentation/en-us/general folder.

2016-12-09 - 2016.1.beta.1
- Update to Smarty v3.1.30: Modifed numerous files to work with updated Smarty version.
- Smarty Plugins in extensions. Added ability to specify plugins for extensions in the extensions/EXTNAME/include/smarty_plugins directory. Plugin name must be unique, so it is recommended that the EXTNAME be part of the name.

2016-08-08 - 2016.0.beta.2
- General Cleanup Modifed numerous files to correct issues of undefined or uninitialized variables and other execution time warnings when strict mode set.
- Cron Logic Added delete feature.
- Default Invoice extension update to eliminate PHP errors and warnings. Also modified to always display detail list with enabled customers first.
- Sub-Customers extension enhancements. Changes made are:
  - 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.
- Fixed issue causing standard si_customers to fail when adding new records.
- Added logic to prevent addition of new si_customers record with the same name as an existing record.
- Fixed issue with undefined variable issue causing new product records to not post.
2016-07-25 - 2016.0.beta.1
- Zend library updated to version 1.12.18
  - 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.
- Enhancements for extension development
  - 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 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.
- Modified to move popup calendar to move it over a bit.
  - 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.
- Added Past Due Report extension.
  - 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.
- Add user definable documentation support. This was added for use by the custom_flags extension. This allows the help field text to be accessed from the database and therefore can be tailored to field use on each system.
- Change to show user defined field label in help dialog.
- Clean up FAQ document
- General changes to support HTML5:
  - Modified HTML document generation logic to render HTML5 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.
- Changed to minimize maintenance of extension language files. Typically the en_US and en_US are both defined in extensions and have the same content. To eliminate this doubling of maintenance, the en_US/lang.php file simply includes the content of the en_US/lang.php file.
- Formalized the hooks feature so that they will work within extensions. The existing custom/hooks.tpl file contains complete documentation on this feature including the necessary cautions concerning the drawback of over using them. Basically, extensions should be used rather than hooks.
- Fix missing $patchCount and query syntax error in getSystemDefaults() method.
- Enhanced install from scratch process to better handle case of no database matching the name in the config.ini or if present, the custom.config.ini file. Also cleaned up formatting of screens and added additional information to the screen instructions to better assist users with setting SimpleInvoices up.
- Added User Security extension.
  - 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 log on to 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 setup 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.
  - Several housekeeping changes:
    - 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.
  - Modified logic to only display Custom Fields if their associated label is defined.
  - Added new PdoDb class and supporting classes.
    - 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.
  - Fixed payments to show actual Invoice # rather than the Invoice ID.
  - Remove warnings for BROWSE constant redefinition warnings by testing if already defined.
- 2008-05-12
  - templates\default\preferences\manage.tpl // Apostrophe display fixes// -Dimante
  - templates\default\billers\manage.tpl // Apostrophe display fixes// -Dimante
  - templates\default\billers\details.tpl // Apostrophe display fixes// -Dimante
  - templates\default\payment_types\manage.tpl // Apostrophe display fixes// -Dimante
  - templates\default\payment_types\details.tpl // Apostrophe display fixes// -Dimante
  - templates\default\customers\manage.tpl // Apostrophe display fixes// -Dimante
  - templates\default\customers\details.tpl // Apostrophe display fixes// -Dimante
- 2008-05-11
  - modules\payment_types\save.php // Added domain_id to insert SQL // -Dimante
  - modules\sql_queries.php // Added domain_id to insert SQL for Add Biller // -Dimante
- 2008-05-05
  - modules/preferences/save.php // Added domain_id to parameters // -Dimante
  - templates/default/preferences/details.tpl // Added coding to prevent \' in text rendering for lines with apostrophes. // -Dimante
  - Renamed database_backup.tpl to database_backup.tpl so that the backup function would work. // -Dimante
- 2008-04-xx
  - Fixed minor code error in /templates/default/preferences/details.tpl - Dimante
  - Greek translation added
  - Albanian translation added
- NR +1 2008-02
  - Favicon.ico added
  - Port removed from the PDF url code as HTTP_HOST was already returning the port
  - Quick view page - Customer accounts section now calculating correctly
  - Slovak translation added
  - Latvian translation added
  - Reports on WAMP problem fixed - https://simpleinvoices.group/forum/topic-449.html
  - DB Upgrade SQL Patcher extra text output error and html syntax errors fixed
  - Enabled Gross Total in Export formats too.
  - Norwegian, Slovenian, Danish lang.php corrected by removing leading hex EF BB BF in file - now authentication works for them too.
  - Quantity Format in invoice quick view set to number_format:2
  - System Default Invoice Preference now gets saved correctly
  - Zero Owing Fully Paid Invoices now have 0 Age and blank Aging in Manage Invoices page
  - Enabled Gross Total in all invoices with local template variable: gross_total = total - total_tax
  - Migrated PDF to library and a new pdfmaker.php that takes only Invoice ID in URL
  - Removed Type ID from URLs in manage invoices
  - Introduced user_group table patch
  - domain_id and group_id field changes in users table and dropping of old defaults and auth_challenges table
  - Migrated PHPReports to library/phpreports and modified the existing reports to use it
  - Corrected SQL in reportProductsSoldByCustomer
  - Corrected Spanish translation file for correct encoding and double quote typo
  - Fixed email.php with new location of pdf cache folder - ./cache - no need for out symlink
  - Fix for undefined $title in invoice output templates and html syntax fixes
  - Right side border lines now display correctly in print preview of invoices
  - Mobile Phone of Biller and Customer now prints and displays correctly
  - Removed duplicates in all lang files (insert_biller, insert_customer, insert_product)
  - Synced all language files alphabetically with new variables to that in en-gb with 0 attribute and same as in stable version
  - Patch 141: sql_patchmanager.sql_patch_ref field changed to INT
  - Some more NULL replacements in various save.php files
  - Some more TB_PREFIX replacements in various php files
  - Ported the DB Upgrade click fix (when all upgrades are over)
  - Ported the INSERT NULL (primary key) and TB_PREFIX from NextRelease into sql_patches, sql_queries and the MySQL Dumps - Postgres Dump need to be updated
  - Alphabetically arranged lang/en-gb/lang.php and removed unused and duplicated system_prefs element
  - Uploaded missing header_bg.gif and g_close.gif files in /modules/include/js - this was causing GET errors in the Apache Log files
  - PDF cache is the main smarty cache folder itself - no more symlinks - hence removed the /include/pdf/temp and /include/pdf/out symlinks - the /include/pdf/cache symlink was removed earlier
  - Fixed typo templates to templates in /templates/default/header.tpl on line 57
  - Fixed correct location of iehacks.css in the code in include/functions.php line 323
  - PHPReports DARWIN OS - $ipsep extended
  - PHPReports PHP5 deprecated use of array_push issue fixed
  - Invoice PDF and EMail now support spaces in Biller Logo file name
  - Invoice PDF EMail now supports spaces in Invoice Preference Name
  - Invoice PDF EMail (Boolean variable in config.ini) now supports Confirm Reading Receipt to Sender
  - screen.css now has th.sortable_rt class - useful for right align for numeric fields - available in the modules/module-name/manage.php files
  - General Code cleanup
  - Increased limit from 100 to 1000000 billers / clients / inv_prefs - look in modules/invoices/total.php, itemized.php, consulting.php
  - Changes in config/config.ini made backwards compatible for use with older config.ini
  - Invoice PDF EMail now supports SecureSMTP and user configurable SMTP Port
  - Updated PHPMailer to v2.10 Beta 1 for PHP5
  - lang/en-gb/lang.php capitalised correctly
  - Default Customer now shows up correctly on all add new invoice pages
  - Editing invoice with custom date format issue fixed
- 2007-11-16
  - Security patch to fix issue with the login system - could be bypassed by disabling javascript support
  - Documentation and docs.php updates
  - Default language on upgrade from older version, refer: https://simpleinvoices.group/forum/topic-359.html
- 2007-10-02 aka AFL Grand Final celebration release
  - PHP5 and above only - SimpleInvoices will no longer work on PHP4 servers
  - Invoices now can be deleted - This is can be enabled via the System Preferences page
  - Adding more items to an existing invoice via the edit page it now possible
  - New javascript menu included - now works in IEs,FF and Opera
  - New language select system - system language can now be changed via the System Preferences page
  - All pages move to the smarty templating system
  - Updated UI - were slowly moving away from our 37signals style UI to a more unique UI
  - PDF system modified - $installation_path no longer required
  - Authentication sql table added to the default install - so you now longer have to manually run the login sql to get authentication working
  - How total invoices are stored in the DB has changed - now a total invoices gets stored as a product in the products table but set to not visible via the Manage Products page
  - System Defaults renamed to System Preferences
  - Authentication can now be set via the config.ini file - no need to adjust include_auth.php anymore
  - Customer add template fixed for if no name entered
  - Issue 106Edit tax rates bug fixed
  - Report: Debtors owing by customer sql fixed
  - SQL patch to alter tax rate to 3 decimal places
- 2007-08-29
  - Security patch release: fix md5 javascript login error
- 2007-05-25
  - Error in export template fixed
  - Turn logging off by default
- 2007-05-23
  - Email function added, you can now email an invoice as PDF in SimpleInvoices
  - Moved to smarty for templating system
  - Major rewrite (refactoring) of backend code by aplsyia to simplify and make sane
  - Replace the javascript validation with a purely php validation system
  - Table prefix configuration option added
  - Corrected <? ... ?> Syntax to <?php ... ?> Syntax
  - Lots of small optimizations
  - Introduced XHTML header
  - Czech translation added
  - Issue 75 Stop browsing to the source .php files
  - Issue 90 Translation update: save button updates
  - Issue 84 File cleanup for live grid
  - Issue 93 Translation: make the redirect pages (ie save.php) translatable
  - Old invoice templates (old_lco and old_original) retired, sorry Gaelyne, we moved to a new template system and these didn't make it
  - ibox replaced with greybox as the ajax alert box of choice
  - PDF name now 'Wording for invoice'.'Invoice ID'.pdf (ie. Invoice12.pdf or Estimate8.pdf)
  - Moved a lot of the templates to smarty - still an ongoing project
  - Language file cleanup - duplicates and old style variables removed
  - Logo directory moved from images/logos to templates/invoices/logos
  - css update by lionel
  - MySQL connect - pretty info messages instead of errors all over the page
  - SQL Patches: system changes - manage screen made all nice and if are patches to be applied you have to apply them before using SimpleInvoices
  - System defaults: moved to a new db format to be sane
  - Documentation system altered
  - Reports: If report runs OK you no longer see the did you get an OOPS error message
  - SQL Patches
    - 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
- 2007-03-05
  - New live grid ajax (Live Grid Plus + OpenRico) used to manage the display of all the table info in the 'manage' pages. The old tablesorter and filtering has been removed.
  - Issue 79Custom field extended to support be in invoices
  - Issue 78The ajax info page/alert boxes moved from jQuery thickbox to ibox to work with the new open rico live grid
  - Issue 81New info page for Custom Fields in voices
  - Issue 80New info detailing what custom fields are
  - Issue 74Standardised on using English Number system throughout (ie, 2,400.00 instead of 2400)
  - Issue 86Live grid modified to work with IT
  - Romanian translation added
- 2007-02-06
  - Manage Customer amount owed calculation updated
  - Issue 35PDF security issues fixed
  - Issue 50Process Payment: Auto populate the amount field with the owed value
  - Issue 58Date format woes fixed
  - Issue 65Invoice date: make editable
  - Issue 72Sort not working correctly - fixed
  - Note: If you're using authentication please read: SimpleInvoices Knowledge Base HowTo Page as there have been changes
  - SQL Patches
    - Adding data to the "custom fields" table for invoice
    - Adding custom fields to the invoices table
- 2007-02-02
  - Issue 73Security: Controller.php doesn't validate the $_GET input
  - Issue 71Null Invoice: Consulting style issue
  - Manage tables font size reduction
  - Known Issue: Issue 72Sort not working correctly for numbers
- 2007-01-25
  - Issue 68File structure modified
  - Issue 69Controller script added and urls system modified
  - Issue 70Invoice templates names changed and system modified
  - Issue 63MySQL password format changed to MD5
  - Issue 66New user interface added
  - Issue 64Authentication: Headers already sent drama resolved
  - Manage Invoices: some unneeded filters removed
  - Jquery greybox replace with Jquery thickbox as the ajax popup window javascript
  - Menus structure modification - Manage then Add
  - Numbers - all formatted to 2 decimal places
  - SQL Patches
    - 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;
- 2006-12-11
  - Issue 55 Custom Fields added to billers, customers, and products
  - Issue 30 Issue with blank fields and commas being displayed on the invoice has been fixed, now only fields which are not null get displayed and the commas appear in the right places
  - Invoice templates updated to enable custom fields and moved to a more css base
  - Language files updated
  - More of SimpleInvoices made translatable
  - Manage Custom Fields page added
  - Quick View: updated with show/hide buttons to toggle the amount of info displayed on screen, and alter for the Custom Fields
  - Customer details page tab feature revamped to include an updated style
  - Index page updated, icons added and layout cleaned up
  - Index page: warning added for MySQL4, IE, Konqueror, and Safari users
  - Index page: warning added to notified if database patches are required to be run
  - Database Upgrade Manager: updated to display the number of patches that need to be displayed
  - Issue 43 Street address 2 field added to customers and billers
  - Issue 32 Add amount owed on the invoice print out
  - Issue 53 MySQL 4 sql file: auto-increment added even though phpMyAdmin doesn't include it in the export (using MySQL 4 comparability)
  - Mobile phone field added to customers
  - 8 sql patches added (number 25 to number 23)
  - Known issues with this release:
    - PDF Print Preview: The border for the customer and biller details in print_preview.php doesn't show for the telephone fields
    - Konqueror: Some javascript features don't work in Konqueror
- 2006-10-27
  - Issue 29 fixed: Drop down lists now sorted alphabetically
  - Issue 31 notes field added to products, billers, and customers
  - Customer details page revamped to include a tabbed interface for the notes and invoice listing
  - Issue 34 The php include() system has had a cleanup and files can be included in all pages by editing ./include/include_main.php
  - Issue 21 More pages have been made translatable
  - SQL Patches
    - 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`
- 2006-10-14
  - Index.php - home page renovated - green buttons removed - jQuery accordion menu added
  - Issue 25: IE print_preview.ph borders fixed
  - Exporting to xls and doc fixed
  - German translation added
  - Menu text made more easily translatable
  - Documentation upgraded to include FAQs
  - Creation of a new cache directory to make it easier to set up SimpleInvoices
- 2006-10-06
  - New invoice template added
  - The previous default invoice template 'print_preview.php' has been renamed 'print_preview_basic.php'
  - Updating of the invoice templates to resolve Issue 20 - https://code.google.com/p/simpleinvoices/issues/detail?id=20&can=2&q=
  - Italian tax rate - ITA of 20% added
  - German tax rate - MWSt (DE) of 16% added
- 2006-09-28
  - Invoices are now editable!!
  - Invoice - consulting now includes an optional notes section - similar to the other 2 invoice styles
  - Authentication work started
- 2006-09-25
  - Adding TinyMCE support for all the text box fields - a javascript html editor
  - Minor reports updated
  - Options menu now points to index.php instead of the nonexistent options.php
- 2006-09-18
  - Aging column add to the Mange Invoices page
  - Age field added to the print preview page
  - Debtors reports section added
  - Report "Debtors_by_amount" added
  - Report "Debtors by Aging periods" added
  - Report "Total owed per customer" added
  - Report "Total by Aging periods" added
- 2006-09-13
  - Process payments modified to include auto-complete in the invoice id field as well as the details box being auto updated with the selected invoices information
  - Validation updated for the process payment page and other small changes to cover various other pages
  - Print Preview - small bug fix to make the click through to the various customer account screens work correctly
- 2006-09-09
  - Payment menu added
  - Manage Payments page added
  - Process Payment page modify to be able to select an invoice
  - Process Payment page modify to be able to select from a calendar the date of the payment
  - Process Payment page modify to be able to select Payment Type
  - Manage Payment Types page added
  - Insert Payment Type page added
  - System Defaults modified to be able to select default payment type
  - Print Preview modified to be able to 'click through' to the Manage Payments filtered by invoice or customer
  - The 'Manage' pages have been modified to include a header and be able to create a New Item button
  - Ticket 45PDF printing issues fixed
  - Ticket 23'Add' button it the Manage pages done
  - Client Accounts Stage 2 : implemented
  - SQL Patches
    - 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' ;
- 2006-08-25
  - Client Accounts added: Stage 1 : complete
    - 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
  - Ticket 25:Blank Biller/Customer bug fixed
  - Ticket 39:A tax_id field has been added to the items table to aid reporting
  - 5 new themes added
  - SQL Patches
    - 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 );
- 2006-08-15
  - New menu system that works in all major browsers
  - Billers,customers,products,tax rates and preferences can now be enabled/disabled
  - SQL Patches to add enabled/disabled
    - 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'
- 2006-07-28
  - Fix minor issues with previous release - nifty corners location and UFT-8
- 2006-07-27
  - Manage pages now sortable and filterable
  - Translation framework added
  - Portuguese translation added
  - Reports added
- 2006-07-20
  - Live search aka search as you type added into the 'Manage' screens
- 2006-06-16
  - The manage invoices page had the actions pdf,xls,doc changed to icons
  - pdf configs now moved into config/config.ini
- 2006-06-15
  - The 'Manage' pages received some css love
  - The manage invoices page had the actions pdf,xls,doc added
  - The quick view page had the Export to PDF changed from a button to a link
- 2006-06-10
  - Export to PDF now works!!! :)
  - Export to Excel/Word/OPenDocument format now works!!! :)
  - Invoice Itemized now has an optional invoice note feature
- 2006-05-31
  - Database Backup - this now works, so the user can back up the SimpleInvoices database at will through SimpleInvoices
  - Invoice - Consulting: new invoice type added, this is a cross between and total and an itemized invoice. It allows the user to create an invoice with multiple line items and editable item descriptions; similar to how a consulting firm creates invoices
  - SQL Patches
    - INSERT INTO si_invoice_type ( inv_ty_id , inv_ty_description ) VALUES (3, 'Consulting')
- 2006-05-27
  - Biller logo now a drop-down list
  - Default invoice template now a drop-down list
  - System defaults page all option have been enabled
  - System defaults actually work :)
    - Choosing default biller/customer/tax/preference now make invoice total and itemized default to the selected default
  - Print_preview_slick.php modified to work with multi line invoices
  - Ajax text modifed
  - Raymond's php/mysql sanity patches applied
  - Tax description and default invoice template fields increased to 50 characters
  - SQL Patches
    - 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
- 2006-05-19
  - Remove the original lightbox 'ajax alert windows' and add ParticleTrees lightbox ajax alerts
- 2006-05-15
  - Fix a bug where Internet Explorer prints out code that was commented out
- 2006-05-14
  - Multiple line items now supported in the Itemized Invoice
  - License page added to the About Menu
  - Credits page added to the About Menu
  - FAQs page added to the Instruction Menu
  - Logo support added
  - /logo directory created -
  - Invoice template theme support added
  - /invoice_templates directory created. Print_preview.php has been moved to this directory
  - 2 new fields have been added to the biller, biller logo file and invoice footer
  - A new invoice template contributed by Dave Holden called print_preview_slick.php has been added to the /invoice_templates directory
  - print_view_manual.php has been renamed to print_quick_view.php
  - Add lightbox text popups
  - Add input validation
  - SQL PatchManager (Upgrade Database in the Option menu) has been added, this allows for the upgrade of the SimpleInvoices database from within SimpleInvoices, so the user no longer has to manually run sql scripts when SimpleInvoices is upgraded.
  - SQL Patches
    - #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 ;
- 2006-05-03
  - SQL file fix - SimpleInvoiceDatabase-MySQL4_0.sql added to enable the installation of the SimpleInvoices database in MySQL 4.0. SimpleInvoicesDatabase.sql works with MySQL 4.1 and above
- 2006-04-30
  - Tax calculation - 0% tax rate is now allowed - a Tax Rate with 0% has to be setup
  - Tax Rate: a 'No Tax' rate has been added to the 2 .sql files
  - Insert_action.php - change 5 seconds to 2 and alter text
  - Add Instructions into the Options menu - this links to the ReadMe.html file
  - Add About sub-menu in the Options menu - which reads from the ChangeLog.html and RoadMap.html files
- 2006-04-29
  - Invoice Itemized - fix - the unit price was reporting the current unit price when it should have been showing the value of the unit at the time of sale
  - Remove unnecessary files
- 2006-04-28
  - Bug fix release
  - Tax calculation - fix tax calculation issue as per Jestered's email
- 2006-04-26
  - Bug fix release
  - Invoice - duplicate fields bug fixed
  - Invoice - Not redirecting to Quick View issue fixed
  - Menus - menus now working in Opera and IE
- 2006-04-25
  - Initial release