• 2007-02-02
    • 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
  • 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 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;
  • 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 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
  • 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 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
  • 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 - 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
  • 2006-09-28
    • Invoices are now editable!!
    • Invoice - consulting now includes an optional notes section - similar to the other 2 invoice styles
    • Authentification work started
  • 2006-09-25
    • 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
  • 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 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
  • 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
    • 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' ;
  • 2006-08-25
    • 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 );
  • 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 - niftycorners location and UFT-8
  • 2006-07-27
    • Manage pages now sortable and filterable
    • Translation framework added
    • Portugueuse 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.php
  • 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 Itemised now has an optional invoice note feature
  • 2006-05-31
    • 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')
  • 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 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
  • 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 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 ;
  • 2006-05-03
    • 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
  • 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-meun in the Options menu - which reads from the ChangeLog.html and RoadMap.html files
  • 2006-04-29
    • 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
  • 2006-04-28
    • Bug fix release
    • Tax caluation - fix tax calculation issue as per Jestered email
  • 2006-04-26
    • Bug fix release
    • Invoice - duplicate fields bug fixed
    • Invoice - Not erdirecting to Quick View issue fixed
    • Menus - menus now working in Opera and IE
  • 2006-04-25
    • Initial release