Change Log

The Simple Invoices change log is now available at:
http://code.google.com/p/simpleinvoices/wiki/done

• Add item in edit view of invoice bug fixed

aka Mothers Day release

aka the Big V shines again release

• refer:
  • http://en.wikipedia.org/wiki/Interstate_matches_in_Australian_rules_football
  • http://en.wikipedia.org/wiki/AFL_Hall_of_Fame_Tribute_Match

• Simple Invoices extension system added refer: http://www.simpleinvoices.org/wiki/extensions
• Initial work to move the code to object orientated style
• Fixed minor code error in /templates/default/preferences/details.tpl - Dimante
• Greek translation added
• Albanian translation added
• Latvian translation added
• Danish translation added

• Edit Products fix - refer: http://simpleinvoices.org/forum/topic-484.html

• Favicon.ico added
• Port removed from the PDF url code as HTTP_HOST was already returning the port - Refer: http://simpleinvoices.org/forum/topic-post2339.html#post2339
• Quick view page - Customer accounts section now calculting corrently
• Slovak translation added
• Latvian translation added
• Reports on WAMP problem fixed - http://simpleinvoices.org/forum/topic-449.html
• Enabled Gross Total in Export formats too.
• Norwegian, Slovenian lang.php corrected by removing leading hex EF BB BF in file - now authentication works for them too.
• All Quantity now formatted in Smarty with number_format:2
• Fixed: Login now does not display in the menu when Auth is Off
• System Default Invoice Preference now saves correctly
• Manage Invoices now shows Zero Owing Invoices Aging as blank
• 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
• Corrected PDF link to show full file name from manage page
• Patches 115 to 122 code to run only where needed and can now safely remove old defaults and auth_challenges tables
• Invoice Quick View shows the “Customer:” label annd correctly aligns the Show Details link
• Misc syntax corrections

• Email read receipts now supported in Invoice PDF EMail (Boolean variable in config.php)
• PDF cache is the main smarty cache folder itself - no more symlinks - hence removed the /include/pdf/out and /include/pdf/cache symlinks
• 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 now supports SecureSMTP and user configurable SMTP Port
• Editing invoice with custom date format issue fixed : http://simpleinvoices.org/forum/topic-424.html
• Right side border lines now display correctly in PDF view of invoices
• All fields in Customer Invoices tab in View Customer work now
• Transferred number_format to smarty from functions and queries
• Corrected Spanish translation file for correct encoding and double quote typo
• Fixed 'over' footer issue with new reports and report_debtors_by_amount now shows all invoices
• Substituted number_format() to round() in sql_queries.php as fix for extra comma(s) in numeric fields breaking editing a Total style invoice
• Fixed rel-gb syntax js error in invoice detail template
• Optimised the manage invoices page and template to work from a single SQL extraction
• Removed redundant check for getSystemDefaults() from loop and Customer now sortable in manage invoices
• Fixed the datePicker JS Error that appeared on all manage pages using alternate header sans unused js includes
• Back Ported Tentra's fix for minimum sql-patching check and run
• Created fresh modularised reports from existing ones - also optimised SQL in them
• Updated PHPReports to v0.4.9 and migrated it to the new libs folder
• Back Ported the redundant language check
• Fixed email.php with new location of pdf cache folder - ./cache
• Fix for undefined $title in invoice output templates and html syntax fixes
• Mobile Phone of Biller and Customer now prints and displays correctly
• Removed duplicates in all lang files (insert_biller, insert_customer, insert_product)
• Synched all language files alphabetically with new variables to that in en-gb with 0 attribute
• Cleaned up getInvoiceItems function
• Optimised Payments querying replaced progressPayments function with generic sql2array function
• Fixed Manage Payments to display customer and biller fields correctly
• Removed extra <a> in templates/default/invoices/manage.tpl
• Optimised and corrected the queries in home.php - ORDER BY was missing and GROUP BY was wrong
• Alphabetically arranged lang/en-gb/lang.php and put in missing ”//1” for “disabled” string
• donePatches function to prevent a blank screen when choosing to upgrade the database when it is already uptodate.
• Corrected Typos and updated the SQL dumps to reflect the TB_PREFIX and patch truncation fix for sql_patchmanager on creation
• Completed all TB_PREFIX replacements for the default table prefix si_. The MySQL dump files still have the default si_ prefix in place.
• Malformed SQL INSERT Query Issue Fixed - Replaced all , in INSERT INTO table (id … ) VALUES (, …) with NULL
• Manage Invoices template - Add New Invoice - set link on style - fits menu on single line
• Manage Invoice Preferences template - Whats all this Invoice Preferences about - set on top for consistency - Included the string in the lang.php file
• Fixed Manage Payments template - Wheres the Edit Button - Now works as popup correctly and on top for consistency - Included the string in the lang.php file
• Uploaded missing header_bg.gif and g_close.gif files in /modules/include/js - this was causing GET errors in the Apache Log files
• Fixed typo temlates to templates in /templates/default/header.tpl on line 40
• Fixed correct location of iehacks.css in the code in include/functions.php line 320
• PHPReports DARWIN OS - $ipsep extended
• PHPReports PHP5 deprecated use of array_push issue fixed
• 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, itemised.php, consulting.php
• 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

• Security patch to fix issue with the login system - could be bypassed by disabling javascript support
• Documentation and docs.php udpates
• Default language on upgrade from older version, refer: http://simpleinvoices.org/forum/topic-359.html

• PHP5 and above only - Simple Invoices 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 unqiue 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 Defautls renamed to System Preferences
• Authentication can now be set via the config.php 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

• Security patch release: fix md5 javascript login error

• Error in export template fixed
• Turn logging off by default

• Email function added, you can now email an invoice as PDF in Simple Invoices
• 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 <? … ?> Sytax to <?php … ?> Syntax
• Lots of small optimizations
• Introduced XHTML header
• Czech translation added
• Issue 75Stop browsing to the source .php files
• Issue 90Translation update: save button updates
• Issue 84File cleanup for live grid
• Issue 93Translation: 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 didnt 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 alot 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 Pathces: system changes - manage screen made all nice and if are patches to be applied you have to apply them before using Simple Invoices
• 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

• 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 so as 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 Engligh Number system throughout (ie, 2,400.00 instead of 2400)
• Issue 86Live grid modified to work with IT
• Romanian translation added

• 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 your using authentification please read: http://simpleinvoices.org/wiki/how_do_i_enable_authentification_ie_a_login_system_in_simple_invoices as there have been changes
• SQL Patches
  • Adding data to the custom fields table for invoice
  • Adding custom fields to the invoices table

• Issue 73Security: Controller.php doesnt validate the $_GET input
• Issue 71Null Invoice: Consulting style issue
• Manage tables font size reduction
• Known Issue: Issue 72Sort not working correctly for numbers

• 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 64Authentification: 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_defaults` SET `def_inv_template` = 'default' WHERE `def_id` =1 LIMIT 1;

• 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 appera in the right places
• Invoice templates updated to enable custom fields and moved to a more css base
• Language files updated
• More of Simple Invoices 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 doesnt include it in the export (using MySQL 4 compatability)
• 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 of the javascript features don't work in Konqueror

• 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`

• Index.php - home page renovated - green buttons removed - jQuery accordian menu added
• Issue 25: IE print_preview.ph borders fixed
• Exporting to xls and doc fixed
• German translation added
• Menu text made more easilty translatable
• Documentation upgraded to include FAQs
• Creation of a new cache directory to make it easier to setup Simple Invoices

• 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 - http://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

• Invoices are now editable!
• Invoice - consulting now includes an optional notes section - similar to the other 2 invoice styles
• Authentification work started

• Adding TinyMCE support for all the text box fields - a javascipt html editor
• Minor reports updated
• Options menu now points to index.php instead of the nonexistent options.php

• 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

• Process payments modified to include auto-complete in the invoice id field aswell 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

• 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
• Clent AccountsStage 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_defaults` ADD `def_payment_type` VARCHAR( 25 ) NOT NULL DEFAULT '1' ;

• Clent Accounts added: Stage 1 :complete
  • In Manage Invoice/Manage Customer and Customer Details pages the fields “Total”,”Piad”,”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 );

• 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'

• Fix minor issues with previous release - niftycorners location and UFT-8

• Manage pages now sortable and filterable
• Translation framework added
• Portugueuse translation added
• Reports added

• Live search aka search as you type added into the 'Manage' screens

• The manage invoices page had the actions pdf,xls,doc changed to icons
• pdf configs now moved into config/config.php

• 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

• Export to PDF now works! :) * Export to Excel/Word/OPenDocument format now works! :)
• Invoice Itemised now has an optional invoice note feature

• Database Backup - this now works, so the user can backup the Simple Invoices database at will through Simple Invoices
• Invoice - Consulting: new invoice type added, this is a cross between and total and an itemised invoice, allowing the user to create an invoice with multiple 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')

• 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 itemised default to the selected default
• Print_preview_slick.php modified to work with multi line invoices
• Ajax text modifed
• Raymonds php/mysql sanity patches applied
• Tax description and default invoce template fields increased to 50 characters
• SQL Patches
  • ALTER TABLE si_tax CHANGE tax_description tax_description VARCHAR( 50 ) DEFAULT NULL
  • ALTER TABLE si_defaults CHANGE def_inv_template def_inv_template VARCHAR( 50 ) DEFAULT NULL

• Remove the original lightbox 'ajax alert windows' and add ParticleTrees lightbox ajax alerts

• Fix a bug where Internet Explorer prints out code that was commented out

• Multiple line items now supported in the Itemised 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 invocie 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 leightbox text popups
• Add input validation
• SQL PatchManager (Upgrade Database in the Option menu) has been added, this allows for the upgrade of the Simple Invoices database from within Simple Invoices, so the user no longer has to manually run sql sripts when Simple Invoices 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_defaults` ADD `def_number_line_items` INT( 25 ) NOT NULL ;
  • Set the default number of line items to 5
    • UPDATE `si_defaults` 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_defaults` ADD `def_inv_template` VARCHAR( 25 ) DEFAULT 'print_preview.php' NOT NULL ;

• SQL file fix - SimpleInvoiceDatabase-MySQL4_0.sql added to enable the installation of the Simple Invoices database in MySQL 4.0. SimpleInvoicesDatabase.sql works with MySQL 4.1 and above

• 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-meun in the Options menu - which reads from the ChangeLog.html and RoadMap.html files

• Invoice Itemised - fix - the unit price was reporting the current unit price when it should of been showing the value of the unit at the time of sale
• Remove unnecessary files

• Bug fix release
• Tax caluation - fix tax calculation issue as per Jestered email

• Bug fix release
• Invoice - duplicate fields bug fixed
• Invoice - Not erdirecting to Quick View issue fixed
• Menus - menus now working in Opera and IE

• Initial release