Minor bugfix in db_import()
[fa-stable.git] / CHANGELOG.txt
1 /**
2 * @version $Id$
3 * @package FrontAccounting
4 * @copyright (C) 2005 - 2007 FrontAccounting
5 * @license http://www.gnu.org/copyleft/gpl.html GNU/GPL
6 * FrontAccounting is Free Software
7 */
8
9 1. Changelog
10 ------------
11 This is a changelog for FrontAccounting All releases.
12
13 Legend:
14
15 # -> Bug Fix
16 + -> Addition
17 ! -> Change
18 - -> Removed
19 ! -> Note
20 $ -> Affected files
21
22 31-Jan-2008 Janusz Dobrowolski
23  # Minor bugfix in db_import()
24  $ /admin/db/maintenance_db.inc
25  
26 30-Jan-2008 Janusz Dobrowolski
27  # Minor display fix in tax_types.php
28  $ /taxes/tax_types.php
29  ! Format cleanup on some files.
30  $ /gl/includes/gl_db.inc
31    /gl/includes/gl_ui.inc
32    /applications/application.php
33    frontaccounting.php
34    index.php
35    
36 -------------------- 1.16 Stable Released ----------------------
37 28-Jan-2008 Joe Hunt
38  + Added a possibility to replace the normal listboxes for items, customer and/or suppliers with a search box.
39    The listboxes can only hold about 1000 items. New variables in config.php, $no_item_list, $no_customer_list 
40    and $no_supplier_list. Default is the normal behavior for all listboxes.
41  $ /includes/ui/ui_lists.inc
42    /sales/includes/ui/sales_orders_ui.inc
43    /purchases/includes/ui/po_ui.inc
44    /themes/default/images/locate.png (New file)
45    config.php
46
47  + Added ALTER TABLE possibility in db_import. For future releases.
48  $ /admin/db/maintenence_db.inc  
49
50  # Removed warnings 'Call-time pass-by-reference' in /includes/db/connect_db.inc and /includes/ui/ui_lists.inc
51  # Fixed File not found when loading local stylesheet.css (for other languages) in /includes/page/header.inc
52  $ /includes/db/connect_db.inc
53    /includes/ui/ui_lists.inc
54    /includes/page/header.inc
55    /access/login.php
56    
57 16-Jan-2008 Joe Hunt
58  # When login screen is displayed after session timeout page content is broken. It
59    is because of NOT using absolute paths in href attribute theme elements.
60  $ /access/login.php
61  
62 30-Dec-2007 Joe Hunt
63  # Minor adjustments in function db_export on line 325
64  $ /admin/db/maintenance_db.inc
65  
66 29-Dec-2007 Joe Hunt
67  + Added a variable, $print_invoice_no, in config.php for printing the invoice number instead of invoice reference.
68  $ config.php
69  
70  # Fixed a bug when exporting database. Exported NULL field values from NO to empty field (from mysql version 5.0.32).
71    Also fixed a unneccessary str_replace when importing sql scripts.
72  ! Changed the PDF presentation to deleting the Javascript cache before presentation.
73  $ /admin/db/maintenance_db.inc
74    /reporting/includes/pdf_report.inc
75    
76 13-Dec-2007 Joe Hunt
77  # Still bugs in trial balances and account inquiry on screen when selecting non balance accounts. Fixed.
78  $ /gl/inquiry/gl_trial_balance.php
79    /gl/inquiry/gl_account_inquiry.php
80
81 13-Dec-2007 Joe Hunt
82  # Fixed a bug when voiding a transaction (Journal Entry). An eventually underlying bank transfer was not voided.
83  $ /admin/db/voiding_db.inc
84  
85 06-Dec-2007 Joe Hunt
86  # Fixed a bug when adding lines during Payments to suppliers, the supplier was set back to the first.
87  $ /gl/gl_payment.php
88    /gl/includes/ui/gl_payment_ui.inc
89    
90  ! Changed $loc_notification to be set to 0 instead of 1.
91  $ config.php
92  
93 -------------------- 1.15 Stable Released ----------------------
94 05-Dec-2007 Joe Hunt
95  + Added email notification to stock location when available stock is below reorder level
96  $ config.php
97    /sales/includes/db/sales_order_db.inc
98    
99  # Fixed bugs in Open balances when account is not a balance account
100  $ /gl/inquiry/gl_trial_balance.php
101    /gl/inquiry/gl_account_inquiry.php
102    /reporting/rep704.php
103    /reporting/rep708.php
104    
105 -------------------- 1.14 Stable Released ----------------------
106 01-Oct-2007 Joe Hunt
107  ! Major change in the installation of modules to also accept an SQL-file for upload.
108  $ config.php
109    /admin/inst_module.php
110    /admin/db/maintenance_db.inc
111    
112 30-Sep-2007 Joe Hunt
113  # The following files were still vulnerable. Fixed
114  $ /access/login.php
115    /includes/lang/language.php
116
117 -------------------- 1.13 Stable Released ----------------------
118 14-Sep-2007 Joe Hunt
119  + Added optional link for electronic payment on invoices (PayPal). 
120  ! Better support for install/update languages.  
121  ! Minor adjustments
122  # Fixed a vulnerable item in config.php
123  $ config.php
124
125 14-Sep-2007 Joe Hunt
126  # We forgot to upload the PO file when installing new language. Used when GETTEXT is not installed on Server.
127  # config.php has been vulnerable. Fixed.
128  $ /admin/inst_lang.php
129  $ config.php
130  
131 10-Sep-2007 Joe Hunt
132  ! Changed Bank Address field from text to textarea (multirows)
133  $ /gl/manage/bank_accounts.php
134  
135 06-Sep-2007 Joe Hunt
136  + Added optional link for electronic payment on invoices (PayPal)
137  $ /reporting/reports_main.php
138    /reporting/rep107.php
139    /reporting/includes/report_classes.inc
140    /reporting/includes/pdf_report.inc
141    /reporting/includes/doc_text.inc
142    /reporting/includes/doc_text2.inc
143    
144 23-Aug-2007 Joe Hunt
145  # Unnecessary parameter ($db) in check_for_recursive_bom
146  $ /manufacturing/manage/bom_edit.php
147  
148 21-Aug-2007 Joe Hunt
149  # Bug in /includes/lang/gettext.php (249) affecting changing language!
150  $ /includes/lang/gettext.php
151  
152 08-Aug-2007 Joe Hunt
153  # Minor adjustments
154  $ config.php
155    /access/login.php
156    /admin/create_coy.php
157    /reporting/includes/pdf_report.inc
158    
159 04-Aug-2007 Joe Hunt
160  + Added a default fiscal year in the en_US-new.sql and start references.
161  $ /sql/en_US-new.sql
162  ! Changed some specific text strings in en_US.po (E.g. TAX instead of VAT)
163  $ /lang/en_US/LC_MESSAGES/en_US.mo
164  
165 03-Aug-2007 Joe Hunt
166  # A bug in Direct Invoicing (wrong Invoice Date) has been fixed.
167  $ /sales/includes/db/sales_order_db.inc
168  
169 23-Jul-2007 Joe Hunt
170  # Changed <? in front of 2 files to <?php.
171  $ /purchasing/includes/purchasing_ui.inc
172    /reporting/includes/class.mail.inc
173    
174 -------------------- 1.12 Stable Released ----------------------
175 21-Jul-2007 Joe Hunt
176  + Added option to handle Jalali and Islamic Calendars
177  ! Minor adjustments
178  $ config.php
179    /gl/includes/db/gl_db_trans.inc
180    /includes/date_functions.inc
181    /includes/ui/ui_input.inc
182    /includes/ui/ui_lists.inc
183    /includes/ui/ui_view.inc
184    /purchasing/po_receive_items.php
185    /purchasing/includes/ui/invoice_ui.inc
186    /purchasing/includes/ui/po_ui.inc
187    /reporting/rep705.php
188    /sales/includes/db/sales_order_db.inc
189    /sales/includes/ui/sales_order_ui.inc
190    
191 20-Jul-2007 Joe Hunt
192  ! Changed parameters on report Sales Order. Option to print as Quote.
193  $ /reporting/reports_main.php
194    /reporting/rep109.php
195    /reporting/includes/pdf_report.inc
196    /reporting/includes/doctext.inc
197    /reporting/includes/doctext2.inc
198  
199 19-Jul-2007 Joe Hunt
200  + Added Budget Entry in General Ledger. Includes Dimensions.
201  $ config.php
202    /applications/generalledger.php
203    /gl/gl_budget.php (New File!)
204    /gl/includes/db/gl_db_trans.inc
205    /includes/date_functions.inc
206    /reporting/report_classes.inc
207    
208 -------------------- 1.11 Stable Released ----------------------
209 04-Jul-2007 Joe Hunt
210  ! Option for using alpha numeric chart of accounts.
211  $ config.php
212    /gl/manage/gl_accounts.php
213    /gl/includes/db/gl_db_accounts.inc
214    /gl/includes/db/gl_db_bank_trans.inc
215    /gl/includes/db/gl_db_trans.inc
216    /gl/inquiry/gl_trial_balance.inc
217    /admin/db/company_db.inc
218    /inventory/includes/db/items_db.inc
219    /sales/manage/customer_branches.inc
220
221 04-Jul-2007 Joe Hunt
222  # Problems retrieving language texts for poEdit in long javascripts
223  $ /includes/ui/ui_view.inc
224  
225 04-May-2007 Joe Hunt
226  # Database error when updating more than one item row in Sales Orders.
227  $ /sales/includes/db/sales_order_db.inc
228  # Database error when inserting work order issues. Fixed.
229  $ /manufacturing/includes/db/work_order_issues_db.inc
230  
231 03-May-2007 Joe Hunt
232  # Multiple tables and JOIN's have syntax changes in MySQL 5.0.12. Need parentheses.
233  $ /includes/db/manufacturing_db.inc
234    /manufacturing/includes/db/work_order_requirements_db.inc
235
236 02-May-2007 Joe Hunt
237  # Missing details on Purchase Order when emailing and printing
238  $ /reporting/rep209.php
239  
240 -------------------- 1.1 Stable Released ----------------------
241 02-May-2007 Joe Hunt
242  + Enabled module addons and all the below bugfixes. No changes in database structure.
243  - Removed /sql/basic.sql (included in the other sql files)
244  - Removed /themes/default/images/left.gif and /themes/default/images/right.gif 
245    (not needed anymore).
246  + Addition of update.html  
247  $ /admin/inst_module.php (New file!)
248    /applications/customers.php
249    /applications/dimensions.php
250    /applications/generalledger.php
251    /applications/inventory.php
252    /applications/manufacturing.php
253    /applications/setup.php
254    /applications/suppliers.php
255    /install/index.php
256    /install/save.php
257    /modules/inst_modules.php (New folder and new file!)
258    /modules/index.php (New file!)
259    /sql/en_US-demo.sql
260    /sql/en_US-new.sql
261    install.html
262    update.html (New file!)
263    
264 01-May-2007 Joe Hunt
265  # Missing measure of units when printing sales orders
266  # Update of Sales People caused a database error
267  $ /sales/manage/sales_people.php
268    /reporting/rep109.php
269  
270 30-Apr-2007 Joe Hunt
271  + The selected menu tab is now shown with same background as hover color.
272  $ config.php (default tab line 77. Change if you want)
273    /includes/page/header.inc
274    
275 28-Apr-2007 Joe Hunt
276  # When saving work order entries a lot of debug boxes appeared. Fixed
277  # When clicking on the link, Issue, on work order inquires an empty screen appeared. Fixed
278  # When retrieving work centres id's there was a database error. Fixed by casting string to unsigned
279  $ /includes/db/manufacturing_db.inc
280    /manufacturing/work_order_entry.php
281    /manufacturing/includes/work_order_issue_ui.inc
282    /manufacturing/includes/db/work_order_requirements_db.inc
283    /manufacturing/includes/db/work_orders_quick_db.inc
284    /manufacturing/inquiry/where_used_inquiry.php
285    
286 25-Apr-2007 Joe Hunt
287  # Missing Date Picker
288  $ /sales/customer_invoice.php
289  # No JS popup window
290  $ /sales/view/view_invoice.php
291  
292 24-Apr-2007 Joe Hunt
293  ! New and better Date Picker, better cool theme.
294  $ /includes/ui/ui_input.inc
295    /includes/ui/ui_view.inc
296    /reporting/includes/reports_classes.inc
297    /themes/cool/default.css
298
299 -------------------- 1.0.1 Stable Released ----------------------
300 23-Apr-2007 Joe Hunt
301  ! Release 1.0.1 established on SourceForge, fixing the bugs and including a Date Picker,
302    the changes for selection lists customers/suppliers and the Audit Trail.
303
304 22-Apr-2007 Joe Hunt
305  ! Changed the two selection lists for customers/suppliers in reports to a single one with
306    No Filter
307  ! Changed the sort order in these selection lists from id to name.
308  + Added Audit Trail in GL trans. A switch in config.php, $use_audit_trail, must be set to 1.
309  $ /reporting/reports_main.php
310    /reporting/rep101.php
311    /reporting/rep102.php
312    /reporting/rep201.php
313    /reporting/rep202.php
314    /reporting/rep203.php
315    /reporting/rep204.php
316    /reporting/includes/reports_classes.inc
317    /includes/ui/ui_lists.inc
318    /gl/includes/db/gl_db_trans.inc
319    config.php
320    
321 22-Apr-2007 Joe Hunt
322  + Date Picker for all date fields.
323  $ config.php
324    /admin/fiscalyears.php
325    /admin/void_transaction.php
326    /includes/ui/ui_view.inc
327    /includes/ui/ui_input.inc
328    /dimensions/dimension_entry.php
329    /dimensions/inquiry/search_dimensions.php
330    /gl/gl_journal.php
331    /gl/gl_deposit.php
332    /gl/gl_payment.php
333    /gl/bank_transfer.php
334    /gl/inquiry/bank_inquiry.php
335    /gl/inquiry/gl_account_inquiry.php
336    /gl/inquiry/gl_trial_balance.php
337    /gl/manage/exchange_rates.php
338    /inventory/adjustments.php
339    /inventory/transfers.php
340    /inventory/inquiry/stock_movements.php
341    /inventory/manage/items.php
342    /manufacturing/work_order_add_finished.php
343    /manufacturing/work_order_entry.php
344    /manufacturing/work_order_issue.php
345    /manufacturing/work_order_release.php
346    /purchasing/supplier_payment.php
347    /purchasing/po_entry_items.php
348    /purchasing/po_receive_items.php
349    /purchasing/supplier_credit.php
350    /purchasing/supplier_credit_grns.php
351    /purchasing/supplier_invoice.php
352    /purchasing/supplier_invoice_grns.php
353    /purchasing/supplier_trans_gl.php
354    /purchasing/includes/ui/po_ui.inc
355    /purchasing/inquity/po_search.php
356    /purchasing/inquiry/po_search_completed.php
357    /purchasing/inquiry/supplier_allocation_inquiry.php
358    /purchasing/inquiry/supplier_inquiry.php
359    /reporting/reports_main.php
360    /reporting/includes/reports_classes.inc
361    /sales/credit_note_entry.php
362    /sales/customer_credit_invoice.php
363    /sales/customer_payments.php
364    /sales/sales_order_entry.php
365    /sales/includes/ui/sales_order_ui.inc
366    /sales/inquiry/customer_allocation_inquiry.php
367    /sales/inquiry/customer_inquiry.php
368    /sales/inquiry/sales_orders_view.php
369    New image files:
370    /themes/default/images/cal.gif
371    /themes/default/images/next.gif
372    /themes/default/images/prev.gif
373
374 19-Apr-2007 Joe Hunt
375  # Bug no 1703895, Account numbers are varchars, need quotes, fixed
376  # Bug no 1703891, Reserved MySQL words used as column names, fixed
377  $ /taxes/db/tax_types_db.inc
378
379  # Bug no 1703888, Apostrophes and other unescaped characters, fixed
380  $ /gl/manage/gl_accounts.php
381    /gl/includes/db/gl_db_accounts.inc
382    /includes/ui/ui_input.inc
383
384 18-Apr-2007 Joe Hunt
385  # Bug no 1702594, Logon Loop, fixed
386  $ config.php
387
388 -------------------- 1.0a Stable Released ----------------------
389 10-Apr-2007 Joe Hunt
390  ! Release 1.0a established on SourceForge, fixing the bugs.
391
392 11-Apr-2007 Joe Hunt
393  # Bug No 1698214, Creating Items, fixed
394  $ /includes/ui/ui_lists.inc
395  # Bug no 1698216, Item Movements, fixed
396  $ /inventory/manage/items.php
397
398 -------------------- 1.0 Stable Released ----------------------
399 10-Apr-2007 Joe Hunt
400  ! Release 1.0 established on SourceForge.
401
402 2. Copyright and disclaimer
403 ---------------------------
404 This application is opensource software released under the GPL.  Please
405 see source code and the LICENSE file