Optimized database indexes.
[fa-stable.git] / CHANGELOG.txt
index 8fe90ab027b1671dc19909f8e0826fd2835da23e..7f857820ee47c4dba75be72a511a10a7473424b7 100644 (file)
@@ -19,6 +19,197 @@ Legend:
 ! -> Note
 $ -> Affected files
 
+11-Jan-2010 Janusz Dobrowolski
+! Optimized database indexes.
+$ /sql/alter2.3.sql
+  /sql/en_US-demo.sql
+  /sql/en_US-new.sql
+
+27-Dec-2009 Janusz Dobrowolski
++ Remote packages repository support for extensions and languages
+$ /config.default.php
+  /frontaccounting.php
+  /admin/inst_lang.php
+  /admin/inst_module.php
+  /includes/access_levels.inc
+  /includes/ui/ui_lists.inc
+  /sql/alter2.3.php
+# Small fix in handle_submit
+$ /admin/create_coy.php
+! Using var_dump function for storing variables in config files.
+$ /admin/db/maintenance_db.inc
++ Added copy_file(), check_write() helper functions.
+$ /includes/main.inc
++ Aded array_search_key() helper.
+$ /includes/lang/gettext.php
++ Added helper for checking langauge support.
+$ /includes/current_user.inc
++ Added helper for radio buttons.
+$ /includes/ui/ui_input.inc
+! Extension links support moved to application class.
+$ /applications/application.php
+  /applications/customers.php
+  /applications/dimensions.php
+  /applications/generalledger.php
+  /applications/inventory.php
+  /applications/manufacturing.php
+  /applications/setup.php
+  /applications/suppliers.php
+  /includes/archive.inc (new)
+  /includes/packages.inc (new)
++ Support for popup buttons
+$ /js/inserts.js
+
+24-Dec-2009 Merged changes from main trunk 2.2.1-2.2.2 as follows
+! Release 2.2.2
+$ /update.html
+! Changed so Printed Sales Order (Quotation) shows TOTAL VAT INCL. if it is.
+$ /reporting/rep109.php
+  /reporting/rep111.php
+  /reporting/includes/doctext.inc
+  /reporting/includes/doctext2.inc
+# Restoring journal entry sql to previous without join with bank_trans
+  due to error in joins. Tom Hallman works on it until 2.2.3
+$ /gl/inquiry/journal_inquiry.php  
+! Replaced all deprecated functions so FA runs in php >= 5.3.0 as well.
+$ /admin/db/maintenance_db.inc
+  /gl/gl_bank.php
+  /includes/db_pager.inc
+  /includes/session.inc
+  /includes/lang/language.php
+  /includes/page/header.inc
+  /install/save.php
+  /inventory/adjustments.php
+  /inventory/transfers.php
+  /purchasing/supplier_invoice.php
+  /purchasing/allocations/supplier_allocate.php
+  /purchasing/includes/ui/po_ui.inc
+  /reporting/includes/class.graphic.inc
+  /reporting/includes/tcpdf.php
+  /reporting/includes/Workbook.php
+  /sales/allocations/customer_allocate.php
+  
+22-Dec-2009 Joe Hunt
+! Some additional changes in pdf_report.inc for supporting report extensions.
+$ /reporting/includes/pdf_report.inc
+  /reporting/includes/excel_report.inc
+
+21-Dec-2009 Chaitanya/Janusz Dobrowolski
+# [0000184] Bad source document quantities update and invalid qtys during
+       derivative document entry.
+$ /sales/includes/cart_class.inc
+  /sales/includes/sales_db.inc
+# Fixed quantity columns descriptions in delivery edition.
+$ /sales/customer_delivery.php
+
+21-Dec-2009 Joe Hunt
+# Function money_format function doesn't exist in OS Win. Fix in current_user.inc
+  Some errors in header3() in pdf_report.inc.
+$ /includes/current_user.inc
+  /reporting/includes/pdf_report.inc
+
+18-Dec-2009 Joe Hunt
+# Allowing a quantity of 0 in a PO item line when modifying caused strange result.
+  Fixed depending on the decimals in the stock item to not allow less than minimum.
+$ /purchasing/po_entry_items.php
+
+12-Dec-2009 Joe Hunt
+! Implemented search on categories as well in sales_items_list...
+$ /includes/ui/ui_lists.inc
+
+09-Dec-2009 Janusz Dobrowolski
++ Added system diagnostics page
+$ /admin/system_diagnostics.php
+  /applications/setup.php
+
+08-Dec-2009 Tom Hallman/Joe Hunt
++ Extended the Report Engine to better support own reports
+$ /reporting/includes/class.pdf.inc
+  /reporting/includes/excel_report.inc
+  /reporting/includes/pdf_report.inc
+  /reporting/includes/tcpdf.php
+  /reporting/fonts/courier.php (new file)
+  /reporting/fonts/times.php (new file)
+  /reporting/fonts/timesb.php (new file)
+  /reporting/fonts/timesbi.php (new file)
+  /reporting/fonts/timesi.php (new file)
+  /reporting/fonts/symbol.php (new file)
+  /reporting/fonts/zapfdingbats.php (new file)
+  
+07-Dec-2009 Joe Hunt
+! Providing use of alternative providers for exchange rates.
+$ /gl/includes/db/gl_db_rates.inc
+
+06-Dec-2009 Janusz Dobrowolski
+# Safer algorithm for company removal, additional prefix check on company add.
+$ /admin/create_coy.php
+  /admin/db/maintenance_db.inc
+
+04-Dec-2009 Janusz Dobrowolski
+# [0000179] Cannot allocate ST_BANKPAYMENT type payments
+$ /includes/ui/allocation_cart.inc
+# False currency rate error on first opening of sales order page when customer_list is off.
+$ /sales/includes/cart_class.inc
+
+04-Dec-2009 Joe Hunt
+# Print Statement prints balances in wrong place.
+$ /reporting/rep108.php
+! Better date2sql in date_functions.inc
+$ /includes/date_functions.inc
+
+03-Dec-2009 Janusz Dobrowolski
+# Fixed bug [0000178] data error in supplier allocations
+$ /includes/ui/allocation_cart.inc
+
+---------- End of changes from main trunk 2.2.1-2.2.2
+
+10-Dec-2009 Joe Hunt
++ Enhanced Quick Entries to also support Balance Based source amount. Monthly or Yearly (all)
+  Only works with type Journal Entry.
+$ /gl/manage/gl_quick_entries.php
+  /gl/includes/ui/gl_journal_ui.inc
+  /includes/ui/ui_view.inc
+  /sql/alter2.3.sql
+  /sql/en_US-new.sql
+  /sql/en_US-demo.sql
+  .
+05-Dec-2009 Joe Hunt
+! Moved all SQL statements from PHP files into relevant *_db.inc files.
+  All folders done, except reporting/repXXX.php and reporting/includes/reports_classes.inc
+  Awaiting change in report mechanism
+$ /includes/ui/allocation_cart.inc
+  /reporting/includes/header2.inc
+  /reporting/includes/reports_classes.inc (partly)
+  /sales/create_recurrent_invoices.php
+  /sales/customer_payments.php
+  /sales/allocations/customer_allocate.php
+  /sales/includes/sales_db.inc
+  /sales/includes/db/branches_db.inc
+  /sales/includes/db/custalloc_db.inc
+  /sales/includes/db/customers_db.inc
+  /sales/includes/db/cust_trans_db.inc
+  /sales/includes/db/recurrent_invoices_db.inc (new file)
+  /sales/includes/db/sales_groups_db.inc (new file)
+  /sales/includes/db/sales_order_db.inc
+  /sales/inquiry/customer_allocation_inquiry.php
+  /sales/inquiry/customer_inquiry.php
+  /sales/inquiry/sales_deliveries_view.php
+  /sales/inquiry/sales_orders_view.php
+  /sales/manage/credit_status.php
+  /sales/manage/customers.php
+  /sales/manage/customer_branches.php
+  /sales/manage/recurrent_invoices.php
+  /sales/manage/sales_areas.php
+  /sales/manage/sales_groups.php
+  /sales/manage/sales_people.php
+  /sales/manage/sales_points.php
+  /sales/manage/sales_types.php
+  /sales/view/view_sales_order.php
+  /taxes/item_tax_types.php
+  /taxes/tax_groups.php
+  /taxes/tax_types.php
+  /taxes/db/tax_types_db.inc
+
 04-Dec-2009 Janusz Dobrowolski
 + Next release upgrade skeleton files.
 $ /sql/alter2.3.php (new)