Replaced the Excel Writer engine with XLS driver (the XML driver can later be downloaded)
[fa-stable.git] / CHANGELOG.txt
index fb0877f3e8b35671e9449eda2ae1d52fd9b648a8..1f42786aacd35b02b53c20f8b677b56aaacf4f3a 100644 (file)
@@ -1,8 +1,8 @@
 /**
 * @version $Id$
 * @package FrontAccounting
-* @copyright (C) 2005 - 2009 FrontAccounting
-* @license http://www.gnu.org/copyleft/agpl-3.0.html GNU/AGPL
+* @copyright (C) 2005 - 2009 FrontAccounting, LLC
+* @license http://www.gnu.org/copyleft/gpl-3.0.html GNU/GPL
 * FrontAccounting is Free Software
 */
 
@@ -19,10 +19,354 @@ Legend:
 ! -> Note
 $ -> Affected files
 
+05-Mar-2009 Joe Hunt
+! Replaced the Excel Writer engine with XLS driver (the XML driver can later be downloaded)
+$ /reporting/includes/ExcelWriterXML.php, ExcelWriterXML_Sheet.php and ExcelWriterXM__Style.php removed.
+  /reporting/includes/Workbook.php (new file)
+  /reporting/excel_report.inc
+  /reporting/pdf_report.inc
+  /reporting/prn_redirect.php
+  /reporting all repXXX.php files
+  
+03-Mar-2009 Joe Hunt/Janusz Dobrowolski
++ Preparation for Excel Writer continued
+$ /reporting/includes/ExcelWriterXML.php
+  /reporting/includes/ExcelWriterXML_Sheet.php
+  /reporting/includes/ExcelWriterXML_Style.php
+  /reporting/includes/excel_report.inc
+  /reporting all repXXX.php that are not documents
+  
+02-Mar-2009 Joe Hunt
++ Preparation for report destination PDF/Printer and Excel (and Open Office Calc)
+$ /reporting/includes/reports_classes.inc
+  /reporting/includes/pdf_report.inc
+  /reporting/includes/ExcelWriterXML.php (new file)
+  /reporting/includes/ExcelWriterXML_Sheet.php (new file)
+  /reporting/includes/ExcelWriterXM__Style (new file)
+  /reporting/includes/excel_report.inc (new file)
+  /reporting/reports_main.php
+  /reporting/rep701.php
+  /reporting/rep705.php
+  /reporting/rep706.php
+  /reporting/rep707.php
+  
+01-Mar-2009 Janusz Dobrowolski
+# Setting magic_quotes_gpc and register_globals to off in htaccess file
+$ /.htaccess (new)
+
+28-Feb-2009 Joe Hunt
+! Improved layout in standard themes (graphics)
+$ /themes/aqua/renderer.php
+  /themes/aqua/help.gif (new file)
+  /themes/aqua/login.gif (new file)
+  /themes/aqua/right.gif (new file)
+  /themes/cool/renderer.php
+  /themes/cool/help.gif (new file)
+  /themes/cool/login.gif (new file)
+  /themes/cool/right.gif (new file)
+  /themes/default/renderer.php
+  /themes/default/help.gif (new file)
+  /themes/default/login.gif (new file)
+  /themes/default/right.gif (new file)
+  /themes/themes/login.css
+    
+27-Feb-2009 Janusz Dobrowolski
+# Security fix to my last commit.
+$ /frontaccounting.php
+  /includes/lang/language.php
+
+25-Feb-2009 Joe Hunt
+! Improved layout
+$ /inventory/prices.php
+  /inventory/reorder_level.php
+  /inventory/inquiry/stock_status.php
+  
+24-Feb-2009 Janusz Dobrowolski
+# Cleaning startup code
+$ /index.php
+  /frontaccounting.php
+  /includes/session.inc
+  /includes/db/connect_db.inc
+  /includes/lang/gettext.php
+  /includes/lang/language.php
+# Language changed on display prefs page stored to database.
+$ /admin/display_prefs.php
+  /admin/db/users_db.inc
+  /includes/current_user.inc
+# Fixed tab hot keys
+$ /applications/customers.php
+  /applications/dimensions.php
+  /applications/generalledger.php
+  /applications/inventory.php
+  /applications/manufacturing.php
+  /applications/setup.php
+  /applications/suppliers.php
+
+23-Feb-2009 Joe Hunt
+! Changed extension include to be outside function. Didn't work in submenus.
+$ frontaccounting.php
+  /includes/main.inc
+! Better color in data picker
+$ /themes/aqua/default.css
+  /themes/cool/default.css
+  /themes/default/default.css
+  
+22-Feb-2009 Janusz Dobrowolski
+! Application startup code cleanup.
+$ /frontaccounting.php
+  /index.php
+  /applications/customers.php
+  /applications/dimensions.php
+  /applications/generalledger.php
+  /applications/inventory.php
+  /applications/manufacturing.php
+  /applications/setup.php
+  /applications/suppliers.php
+  /includes/session.inc
+  /includes/lang/language.php
+  /themes/default/renderer.php
+  /themes/aqua/renderer.php
+  /themes/cool/renderer.php
+! Removed obsolete $applications array.
+$ /config.php
+! Cosmetic cleanup
+$ /includes/main.inc
+! Calendar style moved to theme default.css
+$ /includes/ui/ui_view.inc
+  /themes/aqua/default.css
+  /themes/cool/default.css
+  /themes/default/default.css
+# Fixed charset selection on login screen
+$ /access/login.php
+# Blocked password changes in demo mode
+$ /admin/change_current_user_password.php
+! Default theme and language set for not logged user
+$ /includes/current_user.inc
+  /includes/prefs/userprefs.inc
+# Fixed initial query order.
+$ /purchasing/inquiry/po_search.php
+
+21-Feb-2009 Joe Hunt
+! Added nowrap for date type fields in db_pager_view.inc. Problems with (-) sep.
+$ /includes/ui/db_pager_view.inc
+! Better layout in stock_movements.php
+$ /inventory/inquiry/stock_movements.php
+
+18-Feb-2009 Joe Hunt
+! Better layout in Items form.
+$ /inventory/manage/items.php
+
+16-Feb-2009 Joe Hunt
+# Instruction in update.html should include switch to standard theme before upgrade
+$ update.html
+# Bug in function get_ecb_rate when no function curl_init (missing url part)
+$ /gl/includes/db/gl_db_rates.inc
+
+------------------------------- Release 2.1.0 beta 2 -------------------------------------------
+15-Feb-2009 Joe Hunt
+! Release 2.1.0 beta 2
+$ config.php
+
+14-Feb-2009 Janusz Dobrowolski
+# Removed obsolete bank_trans field
+$ /sql/alter2.1.sql
+  /sql/en_US-demo.sql
+  /sql/en_US-new.sql
+# Drop column queries executed also in not forced upgrade install 
+$ /admin/db/maintenance_db.inc
+
+13-Feb-2009 Janusz Dobrowolski
+! Added login page language setting
+$ /access/login.php
+  /admin/inst_lang.php
+  /includes/lang/language.php
+  /lang/installed_languages.inc
+# Message typo fixed
+$ /admin/display_prefs.php
+# Unified display_error function name in install wizard and main code
+$ /install/save.php
+
+13-Feb-2009 Joe Hunt
+# Minor bug fix in Quick Entry tax account choice for Journal Entry.
+$ /includes/ui/ui_view.inc
+
+12-Feb-2009 Janusz Dobrowolski
+! Changed extension menu file placement, added support for gettext in extensions.
+$ /frontaccounting.php
+# Fix for some buggy curl versions.
+$ /gl/includes/db/gl_db_rates.inc
+  /gl/manage/exchange_rates.php
+# Fixed get_amount() to return 0 for invalid input.
+$ /js/utils.js
+  /js/budget.js
+
+------------------------------- Release 2.1.0 beta --------------------------------------------
+
+08-Feb-2009 Janusz Dobrowolski
+# Fixed division by zero bug in empty pager
+$ includes/db_pager.inc
+# Fixed special char display issue in item name [0000116]
+$ sales/includes/cart_class.inc
+
+08-Feb-2009 Joe Hunt
+! Changed license type to GNU GPLv3. Stamped headers changed.
+$ all appropriate source files
+
+04-Feb-2009 Joe Hunt
+! Removed ALTER TABLE DROP columns
+$ /sql/alter2.1.sql
+! Removed files from CVS
+/company/0/images/logo_frontaccounting.png
+/reporting/fonts/vera.afm
++ Added files to CVS
+/doc/2.1_Beta.txt
+/doc/extensions.txt
+/themes/default/images/escape.png
+
+04-Feb-2009 Joe Hunt
+# Software Upgrade (re-read of current user needed)
+$ /admin/inst_upgrade.php
+
+03-Feb-2009 Joe Hunt
+! install/index.php link to AGPL license
+$ /install/index.php
+
+03-Feb-2009 Janusz Dobrowolski
+! Merging bugfixes since 2.0.6 from main trunk (see below)
+$ /config.php
+  /gl/includes/db/gl_db_banking.inc
+  /gl/manage/gl_account_classes.php
+  /includes/ui/items_cart.inc
+  /includes/ui/ui_view.inc
+  /purchasing/includes/db/invoice_db.inc
+  /reporting/rep101.php
+  /reporting/rep201.php
+  /reporting/includes/class.pdf.inc
+  /sales/credit_note_entry.php
+  /sales/customer_credit_invoice.php
+  /sales/customer_delivery.php
+  /sales/customer_invoice.php
+  /sales/includes/db/payment_db.inc
+  /sales/includes/db/sales_credit_db.inc
+  /sales/includes/db/sales_delivery_db.inc
+  /sales/includes/db/sales_invoice_db.inc
+  /sales/includes/ui/sales_order_ui.inc
+  /sales/view/view_credit.php
+# Due date display finally fixed.
+$ /purchasing/inquiry/supplier_inquiry.php
+  /sales/inquiry/customer_inquiry.php
+
+------------------------------- Release 2.0.7 --------------------------------------------
+03-Feb-2009 Joe Hunt
+! New release 2.0.7
+$ config.php
+
+22-Jan-2009 Joe Hunt
+# Bug [0000112] It shows invoices as overdue still (in red), even though its been payed and allocated. 
+$ /sales/inquiry/customer_inquiry.php
+
+13-Jan-2009 Joe Hunt
+# Bug [0000111] Accounts on Credit Hold can still process delivery notes on sales order and invoicing.
+$ /sales/customer_delivery.php
+  /sales/customer_invoice.php
+  /sales/includes/ui/sales_order_ui.inc
+  
+08-Jan-2009 Janusz Dobrowolski
+# Numeric check on class id added.
+$ /gl/manage/gl_account_classes.php
+
+02-Jan-2009 Joe Hunt
+# [0000104] minor language updates in a few sales files 
+$ /sales/customer_invoice.php
+
+23-Dec-2008 Joe Hunt
+# Fixed an accounting sync in GL when adding bank account transactions (no customer/supplier trans)
+$ /gl/includes/db/gl_db_banking.inc
+
+22-Dec-2008 Janusz Dobrowolski
+# [0000102] Credit note was stored without entered shippment cost and comment.
+$ /sales/credit_note_entry.php
+# [0000103] Error during save of modified freehand credit note.
+$ /sales/includes/db/cust_trans_db.inc
+
+18-Dec-2008 Joe Hunt
+# [0000101] Roll back of yeasterday issues
+$ /purchasing/includes/db/invoice_db.inc
+  /purchasing/includes/db/supp_payment_db.inc
+  /sales/includes/db/payment_db.inc
+  /sales/includes/db/sales_credit_db.inc
+  /sales/includes/db/sales_invoice_db.inc
+
+17-Dec-2008 Joe Hunt
+# [0000101] More wonderful rounding issues 
+$ /includes/ui/ui_view.inc
+  /purchasing/includes/db/invoice_db.inc
+  /purchasing/includes/db/supp_payment_db.inc
+  /sales/includes/db/payment_db.inc
+  /sales/includes/db/sales_credit_db.inc
+  /sales/includes/db/sales_delivery_db.inc
+  /sales/includes/db/sales_invoice_db.inc
+  
+16-Dec-2008 Joe Hunt
+# [0000100] Keep getting left allocated weird results (rounding problems).
+$ /includes/ui/ui_view.inc
+  /purchasing/inquiry/supplier_allocation_inquiry.php
+  /reporting/rep101.php
+  /reporting/rep201.php
+  /sales/inquiry/customer_allocation_inquiry.php
+
+10-Dec-2008 Janusz Dobrowolski
+# [0000099] New line added to inventory transfer/adjustment sometimes overwrites old one.
+$ /includes/ui/items_cart.inc
+
+09-Dec-2008 Janusz Dobrowolski
+# [0000098] Unable issue of credit note for invoice with removed item lines.
+$ /sales/customer_credit_invoice.php
+# [0000097] Can't void freehand customer credit note.
+$ /sales/includes/db/sales_invoice_db.inc
+# Fixed to hide empty credit note lines.
+$ /sales/view/view_credit.php
+-------------------------------------------------------------------------------
+
+03-Feb-2009 Janusz Dobrowolski
+# sql2date around row[date] in due date.
+$ /purchasing/inquiry/supplier_inquiry.php
+# Bugfix [0000115] once again.
+$ /sales/inquiry/sales_orders_view.php
+# Division by zero avoided in db_pager
+$ /includes/db_pager.inc
+
+02-Feb-2009 Joe Hunt
+! Better layout in Form setup
+$ /admin/forms_setup.php
+# sql2date around row[date] in due date.
+$ /sales/inquiry/customer_inquiry.php
+
+02-Feb-2009 Janusz Dobrowolski
+# Fixed initial sort order in pagers
+$ /dimensions/inquiry/search_dimensions.php
+  /includes/db_pager.inc
+  /purchasing/allocations/supplier_allocation_main.php
+  /purchasing/inquiry/po_search_completed.php
+  /purchasing/inquiry/supplier_allocation_inquiry.php
+  /purchasing/inquiry/supplier_inquiry.php
+  /sales/allocations/customer_allocation_main.php
+  /sales/inquiry/customer_allocation_inquiry.php
+  /sales/inquiry/customer_inquiry.php
+# Fixed due date display for invoices.
+$ /sales/inquiry/customer_inquiry.php
+# Bugfix [0000115] - error on empty table update in fallback mode.
+$ /sales/inquiry/customer_allocation_inquiry.php
+
 30-Jan-2009 Joe Hunt
 + Outputs/Inputs on tax inquiry as well (why not)
-$ /gl/inquiry/tax_inquiry.php
-
+$ /gl/includes/db/gl_db_trans.inc
+  /gl/inquiry/tax_inquiry.php
+! Updated en_US-demo.sql, en_US-new.sql and alter2.1.sql
+$ /sql/alter2.1.sql
+  /sql/en_US-demo.sql
+  /sql/en_US-new.sql
+  
 29-Jan-2009 Joe Hunt
 # A few minor fixes to get the tax report and inquiry right and syncronized
 $ /gl/includes/db/gl_db_trans.inc
@@ -3906,5 +4250,5 @@ $  /admin/gl_setup.php
 
 2. Copyright and disclaimer
 ---------------------------
-This application is opensource software released under the AGPL.  Please
+This application is opensource software released under the GPL.  Please
 see source code and the LICENSE file
\ No newline at end of file