Moved all SQL statements from PHP files into relevant *_db.inc files.
[fa-stable.git] / CHANGELOG.txt
index 7f3d3d8acdfecf94a84ba03aa4dcfbb17058ffa9..d719aef30babf85045cfd9cdc5cb185ee5b240e9 100644 (file)
@@ -19,6 +19,377 @@ Legend:
 ! -> Note
 $ -> Affected files
 
+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)
+  /sql/alter2.3.sql (new)
+
+04-Dec-2009 Tom Hallman
+# Added key on type, id in comments to improve performance
+$ /sql/en_US-demo.sql
+  /sql/en_US-new.sql
+
+04-Dec-2009 Joe Hunt
+! Moved all SQL statements from PHP files into relevant *_db.inc files.
+  Included purchasing folder
+$ /includes/db/manufacturing_db.inc
+  /manufacturing/search_work_orders.php
+  /manufacturing/work_order_costs.php
+  /manufacturing/includes/db/work_orders_db.inc
+  /manufacturing/inquiry/where_used_inquiry.php
+  /manufacturing/manage/bom_edit.php
+  /manufacturing/manage/work_centres.php
+  /purchasing/po_entry_items.php
+  /purchasing/supplier_credit.php
+  /purchasing/supplier_invoice.php
+  /purchasing/includes/db/invoice_db.inc
+  /purchasing/includes/db/po_db.inc
+  /purchasing/includes/db/suppalloc_db.inc
+  /purchasing/includes/db/supp_trans_db.inc
+  /purchasing/inquiry/po_search.php
+  /purchasing/inquiry/po_search_completed.php
+  /purchasing/inquiry/supplier_allocations_inquiry.php
+  /purchasing/inquiry/supplier_inquiry.php
+  /purchasing/manage/suppliers.php
+
+03-Dec-2009 Joe Hunt
+! Moved all SQL statements from PHP files into relevant *_db.inc files.
+  Included inventory folder
+$ /admin/payment_terms.php
+  /admin/printers.php
+  /admin/print_profiles.php
+  /admin/shipping_companies.php
+  /admin/db/company_db.inc
+  /admin/db/printers_db.inc
+  /admin/db/shipping_db.inc
+  /dimensions/includes/dimens_db.inc
+  /gl/gl_bank.php
+  /gl/includes/db/gl_db_accounts.inc
+  /gl/includes/db/gl_db_account_types.inc
+  /gl/includes/db/gl_db_bank_accounts.inc
+  /gl/includes/db/gl_db_curriencies.inc
+  /gl/manage/bank_accounts.php
+  /gl/manage/currencies.php
+  /gl/manage/gl_accounts.php
+  /gl/manage/gl_account_classes.php
+  /gl/manage/gl_account_types.php
+  /inventory/purchasing_data.php
+  /inventory/includes/inventory_db.inc
+  /inventory/includes/db/items_category_db.inc
+  /inventory/includes/db/items_db.inc
+  /inventory/includes/db/items_locations_db.inc
+  /inventory/includes/db/items_purchases_db.inc (New file)
+  /inventory/includes/db/movement_types_db.inc
+  /inventory/inquiry/stock_movements.php
+  /inventory/manage/items_php
+  /inventory/manage/item_categories.php
+  /inventory/manage/locations.php
+  /inventory/manage/movement_types.php
+  
+02-Dec-2009 Janusz Dobrowolski
+! Merged changed from trunk up to 2.2.1 ---------------------------------------
+
+$ /sql/en_US-demo.sql
+# Fixed to store default null values on export
+$ /admin/db/maintenance_db.inc
+! Display sql in case of duplicate data error when go_debug=1 - redone
+$ /includes/errors.inc
+# Display settings are restored in every login in demo mode.
+$ /admin/display_prefs.php
+  /includes/current_user.inc
+# Fixed view/download backup
+$ /admin/backups.php
+
+$ config.default.php
+  /lang/new_language_template/LC_MESSAGES/empty.po
+  /lang/en_US/LC_MESSAGES/en_US.mo
+# More restrictions on deleting gl_accounts
+$ /gl/manage/gl_accounts.php
+! Changed 'delete' to 'deldump' in backups.php to better satisfy IE8 (Yes!)
+$ /admin/backups.php
+
+01-Dec-2009 Janusz Dobrowolski
+# Removing config.php after error during install. Otherwise misleading message is displayed.
+$ /install/save.php
+! Display sql in case of duplicate data error when go_debug=1.
+$ /includes/errors.inc
+! Next transaction numbers retrieved from transaction table instead of sys_types
+$ /includes/systypes.inc
+
+29-Nov-2009 Janusz Dobrowolski
+# Fixed change of language in display preferences. Removed sparse $_SESSION['languages'] variable
+$ /includes/lang/language.php
+  /includes/session.inc
+! Array helpers moved to current_user. Added array_search_key and array_search_key helpers.
+$ /includes/current_user.inc
+  /includes/main.inc
+
+28-Nov-2009 Chaitanya/Joe Hunt
+# Missing ajax trigger in stock_purchasable_items_list_cells. Prices not updated instantly.
+$ /purchasing/includes/ui/po_ui.inc
+
+26-Nov-2009 Joe Hunt
+# Round to nearest value of 0 produced a division by zero error
+$ /admin/company_preferences.php
+# When printing reference numbers instead of internal numbers on documents
+  it should also refer to reference numbers in deliveries and orders.
+$ /reporting/includes/header2.inc
+
+25-Nov-2009 Joe Hunt/Tom Hallman
+# Fixed so total amount cannot be 0 in Bank Payments/Deposits
+$ /gl/gl_bank.php
+
+21-Nov-2009 Janusz Dobrowolski
+# Fixed bug [0000178] data error in supplier allocations
+$ /includes/ui/allocation_cart.inc
+! Fixed type constant usage.
+$ /purchasing/includes/db/supp_trans_db.inc
+
+--------------
+
+01-Dec-2009 Joe Hunt
+! Moved all SQL statements from PHP files into relevant *_db.inc files.
+  included gl folder
+$ /dimensions/includes/dimensions_db.inc
+  /dimensions/includes/dimensions_ui.inc
+  /dimensions/inquiry/search_dimensions.php
+  /gl/bank_account_reconcile.pph
+  /gl/gl_budget.php
+  /gl/includes/db/gl_db_accounts.inc
+  /gl/includes/db/gl_db_account_types.inc
+  /gl/includes/db/gl_db_bank_accounts.inc
+  /gl/includes/db/gl_db_bank_trans.inc
+  /gl/includes/db/gl_db_currencies.inc
+  /gl/includes/db/gl_db_rates.inc
+  /gl/includes/db/gl_db_trans.inc
+  /gl/inquiry/bank_inquiry.php
+  /gl/inquiry/journal_inquiry.php
+  /gl/manage/bank_accounts.php
+  /gl/manage/currencies.php
+  /gl/manage/exchange_rates.php
+  /gl/manage/gl_accounts.php
+  /gl/manage/gl_account_classes.php
+  /gl/manage/gl_account_types.php
+  /gl/view/gl_trans_view.php
+  
+30-Nov-2009 Joe Hunt
+! Moved all SQL statements from PHP files into relevant *_db.inc files.
+  admin folder
+$ /admin/attachments.php
+  /admin/create_coy.php
+  /admin/fiscalyears.php
+  /admin/gl_setup.php
+  /admin/payment_terms.php
+  /admin/printers.php
+  /admin/shipping_companies.php
+  /admin/view_print_transaction.php
+  /admin/db/attachments_db.inc (New file)
+  /admin/db/company_db.inc
+  /admin/db/fiscalyears_db.inc (New file)
+  /admin/db/maintenance_db.inc
+  /admin/db/printers_db.inc
+  /admin/db/shipping_db.inc (New file)
+  /admin/db/transactions_db.inc (New file)
+  /includes/date_functions.inc
+  /reporting/includes/excel_report.inc
+  /reporting/includes/pdf_report.inc
+
+------------------------------- Release 2.2 ----------------------------------
+18-Nov-2009 Joe Hunt
+! Release 2.2
+$ config.default.php
+# Allow null references in trans to show up in gl_trans_view
+$ /gl/view/gl_trans_view.php
+# Fixed side bug after last sql update.
+$ /gl/bank_account_reconcile.php
+
+17-Nov-2009 Joe Hunt/Tom Hallman
+! Moved payment terms in documents for better view. Increased
+  space for legal text.
+$ /reporting/includes/header2.inc
+  /reporting/includes/pdf_report.inc
+! Changed sorting in get_gl_transactions to sort by tran_date, counter
+  Changed period in Journal Entries to one month instead of one year.
+$ /gl/includes/db/gl_db_trans.inc
+  /gl/inquiry/journal_inquiry.php
+! Changed rep705 to show fiscal year instead of year
+$ /reporting/rep705.php
+  /reporting/includes/reports_classes.inc
+! updated fles
+$ update.html
+  /lang/new_language_template/LC_MESSAGES/empty.po
+  
+15-Nov-2009 Janusz Dobrowolski
++ Added integration of custom and extended reports into reporting module; optimizations.
+$ /reporting/prn_redirect.php
+  /reporting/reports_main.php
+  /reporting/includes/reports_classes.inc
+! All *_list() helper functions now return html code, while *_list_cells/*_list_row() display the controls directly.
+$ /includes/ui/ui_lists.inc
+  /admin/backups.php
+  /admin/inst_module.php
+  /admin/print_profiles.php
+  /gl/includes/ui/gl_bank_ui.inc
+  /gl/includes/ui/gl_journal_ui.inc
+  /gl/manage/exchange_rates.php
+  /includes/ui/ui_input.inc
+  /inventory/cost_update.php
+  /inventory/prices.php
+  /inventory/purchasing_data.php
+  /inventory/reorder_level.php
+  /inventory/inquiry/stock_status.php
+  /inventory/manage/item_codes.php
+  /inventory/manage/items.php
+  /inventory/manage/sales_kits.php
+  /manufacturing/inquiry/where_used_inquiry.php
+  /manufacturing/manage/bom_edit.php
+  /purchasing/allocations/supplier_allocation_main.php
+  /purchasing/includes/ui/invoice_ui.inc
+  /purchasing/includes/ui/po_ui.inc
+  /sales/allocations/customer_allocation_main.php
+  /sales/manage/customer_branches.php
+
+13-Nov-2009 Tom Hallman/Joe Hunt
+! Allow editing account when editing a row in GL Bank and GL Journal Entry
+$ /gl/gl_bank.php
+  /gl/gl_journal.php
+  /gl/includes/ui/gl_bank_ui.inc
+  /gl/includes/ui/gl_journal_ui.inc
+  /includes/ui/items_cart.inc
+# Transaction bug in void_journal_trans()
+$ /gl/includes/db/gl_db_trans.inc
+
+12-Nov-2009 Tom Hallman/Joe Hunt
+! Cleaning the CHANGELOG.txt file
+! Changed to allow change of reference in GL modifying
+$ /gl/includes/db/gl_db_trans.inc
+  /gl/gl_journal.php
+  /gl/includes/ui/bl_journal_ui.inc
+  /gl/view/gl_trans_view.php
+  /includes/references.inc
+  /includes/db/references_db.inc
+  
+12-Nov-2009 Tom Hallman/Janusz Dobrowolski
++ Added amount range in gl inquires.
+$ /gl/includes/db/gl_db_trans.inc
+  /gl/inquiry/gl_account_inquiry.php
+! Changed menu option text for GL inquiry
+$ /applications/generalledger.php
+# Fixed typo
+$ /doc/access_levels.txt
+# Fixed maximal memo line length.
+$ /gl/includes/ui/gl_bank_ui.inc
+  /gl/includes/ui/gl_journal_ui.inc
+
+12-Nov-2009 Tom Hallman/Joe Hunt
+! Changed Journal Inquiries so it shows the Bank Deposit/Payment amount
+  instead of sum of positive transaction.
+$ /gl/inquiry/journal_inquiry.php
+
+10-Nov-2009 Janusz Dobrowolski
+# Fixed value for SA_SUPPBULKREP access area.
+$ /includes/access_levels.inc
+  /sql/en_US-demo.sql
+  /sql/en_US-new.sql
+
+10-Nov-2009 Joe Hunt
+# disallow bank accounts in accounts list in Bank Deposits/Payments.
+  It produces double records in bank inquiry otherwise..
+$ /gl/includes/ui/gl_bank_ui.inc
+# disallow bank accounts in accounts list when type is Bank Deposits
+  or Payments. See above.
+$ /gl/manage/gl_quick_entries.php
+# type warning in dimension tags
+$ /admin/tags.php
+
+09-Nov-2009 Janusz Dobrowolski
+! Fixed help link to provide ctxhelp switch and clean the page context string.
+$ /includes/page/header.inc
+
+08-Nov-2009 Joe Hunt
+# Bug in adding freight cost to sales order/quotation
+$ /sales/inquiry/sales_orders_view.php
+! Additional improvements on layout display
+$ /purchasing/includes/ui/invoice_ui.inc
+  /purchasing/view/view_po.php
+  /sales/view/view_sales_order.php
+! Changed the Running Balance column in Customer Transaction
+  to only show when the type is selected. The order is not
+  good before sorting in date order
+$ /sales/inquiry/customer_inquiry.php  
+
+07-Nov-2009 Janusz Dobrowolski
+# Added missing help_context
+$ /sales/inquiry/sales_orders_view.php
+
+07-Nov-2009 Joe Hunt
+! More improvements on layout display.
+$ /purchases/includes/ui/po_ui.inc
+  /inventory/includes/item_adjustments_ui.inc
+
+06-Nov-2009 Janusz Dobrowolski
+# Include sequence fixed.
+$ /admin/tags.php
+  
+06-Nov-2009 Joe Hunt
+! Improved layout in the new tax info display. Also old ones.
+$ /sales/credit_invoice.php
+  /sales/customer_delivery.php
+  /sales/customer_invoice.php
+  /sales/includes/ui/sales_credit_ui.inc
+  /sales/includes/ui/sales_order_ui.inc
+
+05-Nov-2009 Joe Hunt
+! Display tax info in Sales Quotation, Order, Direct Delivery and Invoice.
+$ /sales/includes/ui/sales_order_ui.inc
+  /sales/sales_order_entry.php
+! Include freight_cost in Sales Quotations, Orders in inquiries.
+$ /sales/inquiry/sales_orders_view.php
+# Bug on line 215 in /sales/customer_delivery.php
+$ /sales/customer_delivery.php
+
+04-Nov-2009 Tom Hallman/Joe Hunt
+! Included dimension(s) in Bank Deposit/Payment View and correct signs.
+$ /gl/view/gl_deposit_view.php
+  /gl/view/gl_payment_view.php
+  
 04-Nov-2009 Janusz Dobrowolski
 # Fixed bug introduced during security update and merged from main trunk.
 $ /admin/db/printers_db.inc
@@ -69,7 +440,7 @@ $ /includes/db/connect_db.inc
 
 30-Oct-2009 Joe Hunt
 ! Changed name on folder for global help url to fawiki.
-$ config.default.php
+$ /config.default.php
 
 29-Oct-2009 Janusz Dobrowolski
 ! Changed context help organization to enable use of central multilanguage wiki.