Changed db_escape to seal the system against XSS atacks
[fa-stable.git] / CHANGELOG.txt
1 /**
2 * @version $Id$
3 * @package FrontAccounting
4 * @copyright (C) 2005 - 2008 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 18-Apr-08 Janusz Dobrwolski
23 ! Changed db_escape function to avoid XSS atacks via js db injection
24 $ /includes/db/connect_db.inc
25 # Database inserts/updates secured against js injection
26 $ /admin/db/maintenance_db.inc
27   /gl/includes/db/gl_db_accounts.inc
28   /purchasing/includes/db/po_db.inc
29   /sales/sales_order_entry.php
30   /sales/includes/db/sales_order_db.inc
31
32 16-Apr-2008 Joe Hunt
33 # Bug in /includes/ui/ui_lists.inc:914. Sql clause was cut.
34 $ /includes/ui/ui_lists.inc
35
36 09-Apr-2008 Janusz Dobrowolski
37 # Fixed number formatting bug in standard cost update.
38 $ /inventory/cost_update.php
39
40 -------------------- 2,0 Beta - released ----------------------------
41
42 06-Apr-2008 Joe Hunt
43 ! Changed install.html and update.html to fit the new unstable release 2.0
44 ! Changed demo sql script to fit the 2.0 unstable.
45 $ install.html
46   update.html
47   /sql/en_US-demo.sql
48   
49 06-Apr-2008 Janusz Dobrowolski
50 # Sales invoice edition denied for documents created in FA 1.xx because of nonportable differences in gl posting/db schema.
51   /sales/customer_invoice.php
52 # Fixed typo causing error while adding new tax type.
53   /taxes/tax_types.php
54   
55 05-Apr-2008 Joe Hunt
56 # Fixed a bug when creating subfolder for new companies. Should be company id and not the table pref counter.
57 $ /admin/create_coy.php
58
59 05-Apr-2008 Joe Hunt
60 # Removed annoying warnings in several reports. 
61 $ config.php 
62   /reporting/rep102.php
63   /reporting/rep104.php
64   /reporting/rep201.php
65   /reporting/rep203.php
66   /reporting/rep705.php
67   /reporting/rep706.php
68   /reporting/rep707.php
69   /reporting/rep709.php
70   /reporting/reports_main.php
71   /reporting/includes/pdf_report.inc
72   
73 04-Apr-2008 Janusz Dobrowolski
74 # Javascript bugfix in selecting orders for template.
75 $ /sales/inquiry/sales_orders_view.php
76
77 04-Apr-2008 Joe Hunt
78 ! Updated chart of accounts for release 2.0 unstable. Set the status to 2.0 Beta in config.php. Minor changes in update.html
79 + Preparing for download of release 2.0b on SourceForge.
80 $ config.php
81   update.html
82   /sql/en_US-new.sql
83   /sql/en_US-demo.sql
84   
85 02-Apr-2008 Janusz Dobrowolski
86 # Removed selector expansion on space key for multi-line selectors
87 $ /js/inserts.js
88 ! Hiding search button in combo selectors for javascript enabled browsers
89 $ /includes/ui/ui_lists.inc
90   /js/inserts.js
91 + Focus set to invalid form field after submit check fail
92 $ /admin/company_preferences.php
93   /admin/fiscalyears.php
94   /admin/gl_setup.php
95   /admin/payment_terms.php
96   /admin/shipping_companies.php
97   /admin/users.php
98   /admin/void_transaction.php
99   /dimensions/dimension_entry.php
100   /gl/bank_transfer.php
101   /gl/gl_deposit.php
102   /gl/gl_journal.php
103   /gl/gl_payment.php
104   /gl/manage/bank_accounts.php
105   /gl/manage/bank_trans_types.php
106   /gl/manage/currencies.php
107   /gl/manage/exchange_rates.php
108   /gl/manage/gl_account_classes.php
109   /gl/manage/gl_account_types.php
110   /gl/manage/gl_accounts.php
111   /inventory/adjustments.php
112   /inventory/cost_update.php
113   /inventory/prices.php
114   /inventory/purchasing_data.php
115   /inventory/transfers.php
116   /inventory/manage/item_categories.php
117   /inventory/manage/item_units.php
118   /inventory/manage/items.php
119   /inventory/manage/locations.php
120   /inventory/manage/movement_types.php
121   /manufacturing/work_order_add_finished.php
122   /manufacturing/work_order_entry.php
123   /manufacturing/work_order_issue.php
124   /manufacturing/work_order_release.php
125   /manufacturing/manage/bom_edit.php
126   /manufacturing/manage/work_centres.php
127   /purchasing/po_entry_items.php
128   /purchasing/po_receive_items.php
129   /purchasing/supplier_credit.php
130   /purchasing/supplier_credit_grns.php
131   /purchasing/supplier_invoice.php
132   /purchasing/supplier_invoice_grns.php
133   /purchasing/supplier_payment.php
134   /purchasing/supplier_trans_gl.php
135   /purchasing/allocations/supplier_allocate.php
136   /purchasing/manage/suppliers.php
137   /sales/credit_note_entry.php
138   /sales/customer_credit_invoice.php
139   /sales/customer_delivery.php
140   /sales/customer_invoice.php
141   /sales/customer_payments.php
142   /sales/sales_order_entry.php
143   /sales/allocations/customer_allocate.php
144   /taxes/item_tax_types.php
145   /taxes/tax_groups.php
146   /taxes/tax_types.php
147 # Set default focus in update_db.php
148 $ /admin/backups.php
149
150 29-Mar-2008 Janusz Dobrowolski
151 # Changed gl_all_accounts_list() API
152 $ /includes/ui/ui_lists.inc
153 + Enhanced list accessability in kbd usage via space key
154 $ js/inserts.js
155
156 28-Mar-2008 Janusz Dobrowolski
157 # Fixed headers for various display mode
158 $ /sales/inquiry/sales_orders_view.php
159
160 28-Mar-2008 Joe Hunt
161 + Added print document options in inquiries.
162 $ /sales/inquiry/customer_inquiry.php
163   /sales/inquiry/sales_orders_view.php
164   /sales/inquiry/sales_deliveries_view.php
165   /purchasing/inquiry/po_search.php
166   /purchasing/inquiry/po_search_completed.php
167   
168 28-Mar-2008 Joe Hunt
169 # Fixed a minor bug in customers_db.inc (should include type == 2 - Bank Deposits)
170 $ /sales/includes/db/customers_db.inc
171 # Fixed a PHP vers. 5.xx bug. No need for & operator in function calls, only in declaration. Gives a warning.
172 $ /sales/includes/db/sales_credit_db.inc
173 # Fixed a wrong variabel declaration doc_Document_no to doc_Invoice_no
174 $ /reporting/includes/doctext.inc
175   /reporting/includes/doctext2.inc
176 # Fixed so Customer Balances and Aged Customer Analysis reports presents correct sign.  
177 $ /reporting/rep101.php
178   /reporting/rep102.php
179
180 28-Mar-2008 Janusz Dobrowolski
181 # Layout/focus fixes for no_[customer/supplier/item]_list option on
182 $  /includes/ui/ui_lists.inc
183    /purchasing/includes/ui/po_ui.inc
184    /sales/credit_note_entry.php
185    /sales/sales_order_entry.php
186    /sales/includes/ui/sales_credit_ui.inc
187    /sales/includes/ui/sales_order_ui.inc
188
189 27-Mar-2008 Janusz Dobrowolski
190 + Automatic first field focus on page start, focus order preserved between form updates
191 $  /gl/inquiry/gl_account_inquiry.php
192    /includes/page/footer.inc
193    /includes/ui/ui_controls.inc
194    /includes/ui/ui_input.inc
195    /includes/ui/ui_lists.inc
196    /includes/ui/ui_view.inc
197    /js/inserts.js
198    /sales/sales_order_entry.php
199    /sales/credit_note_entry.php
200    /sales/includes/ui/sales_credit_ui.inc
201    /sales/includes/ui/sales_order_ui.inc
202 + Data picker omitted in keyboard tabbing sequence (FF,IE, not old mozilla)
203 $  /includes/ui/ui_input.inc
204 ! Javascript recalcAccount() superseded by class='combo' behaviour binding
205 $  /gl/gl_deposit.php
206    /gl/gl_journal.php
207    /gl/gl_payment.php
208    /gl/includes/ui/gl_deposit_ui.inc
209    /gl/includes/ui/gl_journal_ui.inc
210    /gl/includes/ui/gl_payment_ui.inc
211    /includes/ui/ui_view.inc
212    /purchasing/po_entry_items.php
213    /purchasing/includes/ui/po_ui.inc
214    /sales/sales_order_entry.php
215    /sales/includes/ui/sales_credit_ui.inc
216    /sales/includes/ui/sales_order_ui.inc
217    /js/inserts.js
218 ! get_js_set_focus moved from ui_view (this is only standalone form).
219    /update_db.php
220 # Fixed debit/credit entry check 
221 $  /gl/gl_journal.php
222 # Restored GET/POST security check on path_to_root
223 $  /config.php
224
225 26-Mar-2008 Janusz Dobrowolski
226 # Bug fixes in purchase module related to tax structure changes.
227 $  /purchasing/includes/supp_trans_class.inc
228    /purchasing/includes/db/invoice_db.inc
229    /purchasing/includes/db/invoice_items_db.inc
230    /purchasing/includes/ui/invoice_ui.inc
231    /reporting/rep105.php
232
233 25-Mar-2008 Janusz Dobrowolski
234 ! Per company pdf, backup and graphics directories in 'company' dir.
235 $  /company (new dir)
236    /company/0 (new dir)
237    /company/0/images/ (new dir)
238    /company/0/images/102.jpg    (moved from inventory/manage/image)
239    /company/0/images/103.jpg    (moved from inventory/manage/image)
240    /company/0/images/104.jpg    (moved from inventory/manage/image)
241    /company/0/images/logo_frontaccounting.jpg   (moved from themes/default/images)
242    /company/0/images/logo_frontaccounting.png   (moved from themes/default/images)
243    /admin/backups.php
244    /admin/create_coy.php
245    /admin/db/maintenance_db.inc
246    /install/index.php
247    /reporting/rep102.php
248    /reporting/rep104.php
249    /reporting/rep202.php
250    /reporting/rep303.php
251    /reporting/rep706.php
252    /reporting/rep707.php
253    /reporting/includes/pdf_report.inc
254    /inventory/manage/items.php
255
256 + jscript component caching (enables browser caching and future compression)
257 $  /includes/session.inc
258    /includes/main.inc
259    /includes/page/header.inc
260    /includes/ui/ui_view.inc
261    /admin/display_prefs.php
262    /config.php
263
264 - Removed obsolete file
265 $  /sales/includes/ui/print_invoice.inc
266
267 21-Mar-2008 Janusz Dobrowolski
268 ! Total Allocation/Left to Allocate update without page submit.
269 $  /includes/ui/ui_view.inc
270    /purchasing/allocations/supplier_allocate.php
271    /sales/allocations/customer_allocate.php
272 # Fixed unvisable under IE editbutton
273 $  /themes/aqua/default.css
274    /themes/cool/default.css
275    /themes/default/default.css
276
277 20-Mar-2008 Janusz Dobrowolski
278 # Excluding delivery notes from Customer Balances, removed warnings. 
279 $  /reporting/rep101.php 
280 # Divide by zero fix on order_price==0 in new supplier invoice
281 $  /purchasing/supplier_invoice_grns.php
282 # Database bug fix in new customer entry
283 $  /sales/manage/customers.php
284 # Small bug fix (warnings) in is_date() function.
285 $  /includes/date_functions.inc
286
287 18-Mar-2008 Janusz Dobrowolski
288 # Line items editor uses POST method - no disappearing shippment info.
289 $  /sales/credit_note_entry.php
290    /sales/sales_order_entry.php
291    /sales/includes/ui/sales_credit_ui.inc
292    /sales/includes/ui/sales_order_ui.inc
293 + Added edit_button_cell() function
294 $  /includes/ui/ui_controls.inc
295 + Helper function for finding indexed submit $_POST vars.
296 $  /includes/ui/ui_input.inc
297 + New class .editbutton for buttons. Default view is link alike.
298 $  /themes/aqua/default.css
299    /themes/cool/default.css
300    /themes/default/default.css
301
302 17-Mar-2008 Janusz Dobrowolski
303 # Added rounding when needed to avoid document non cosistent documents.
304 $  /includes/banking.inc
305    /purchasing/supplier_credit_grns.php
306    /purchasing/supplier_invoice_grns.php
307    /purchasing/includes/supp_trans_class.inc
308    /purchasing/includes/ui/invoice_ui.inc
309    /purchasing/includes/ui/po_ui.inc
310    /reporting/rep107.php
311    /reporting/rep109.php
312    /reporting/rep110.php
313    /reporting/rep209.php
314    /sales/includes/cart_class.inc
315    /sales/includes/ui/sales_credit_ui.inc
316    /sales/includes/ui/sales_order_ui.inc
317    /sales/view/view_credit.php
318    /sales/view/view_dispatch.php
319    /sales/view/view_invoice.php
320    /sales/view/view_sales_order.php
321    /taxes/tax_calc.inc
322 # Sign bug for customer transactions
323 $  /reporting/rep709.php
324 # Include file conflict fix
325 $ /purchasing/includes/ui/invoice_ui.inc
326   /gl/manage/bank_accounts.php
327   /manufacturing/inquiry/where_used_inquiry.php
328   /purchasing/manage/suppliers.php
329   
330 16-Mar-2008 Janusz Dobrowolski
331 + Added javascript add-on for unobtrusive apply javascript handlers to html elements.
332 $  /js/behaviour.js
333    /js/inserts.js
334 + Added javascript source collecting functions
335 $  /includes/main.inc
336 ! Moved check_page_security(); for safe start in case of broken wa_current_user var.
337 + Added global js code collecting arrays  $js_lib, $js_static
338 $  /includes/session.inc
339 ! Changed get_js_user num to add_js_user_num; extended for percent/qty/price formatting
340 $  /includes/ui/ui_view.inc
341 + Added including javascript source colections from $js_lib, $js_static; conditional display for ajax calls
342 $  /includes/page/footer.inc
343    /includes/page/header.inc
344 ! Added including of data_checks.inc
345 $  /includes/ui.inc
346 + User side percent/exrate/qty/price input formatting via onblur handler.
347 $  /admin/gl_setup.php
348    /gl/gl_budget.php
349    /gl/manage/exchange_rates.php
350    /includes/ui/ui_input.inc
351    /inventory/purchasing_data.php
352    /inventory/reorder_level.php
353    /inventory/includes/item_adjustments_ui.inc
354    /inventory/includes/stock_transfers_ui.inc
355    /manufacturing/work_order_entry.php
356    /manufacturing/manage/bom_edit.php
357    /purchasing/po_entry_items.php
358    /purchasing/po_receive_items.php
359    /purchasing/supplier_credit.php
360    /purchasing/supplier_credit_grns.php
361    /purchasing/supplier_invoice_grns.php
362    /purchasing/supplier_trans_gl.php
363    /purchasing/allocations/supplier_allocate.php
364    /purchasing/includes/ui/po_ui.inc
365    /sales/customer_delivery.php
366    /sales/customer_invoice.php
367    /sales/allocations/customer_allocate.php
368    /sales/includes/ui/sales_credit_ui.inc
369    /sales/includes/ui/sales_order_ui.inc
370    /taxes/tax_groups.php
371    /taxes/tax_types.php
372
373 14-Mar-2008 Janusz Dobrowolski
374  + All forms fixed to accept user native numeric format.
375  $ /admin/gl_setup.php
376    /gl/bank_transfer.php
377    /gl/gl_budget.php
378    /gl/gl_deposit.php
379    /gl/gl_journal.php
380    /gl/gl_payment.php
381    /gl/includes/db/gl_db_banking.inc
382    /gl/includes/ui/gl_deposit_ui.inc
383    /gl/includes/ui/gl_journal_ui.inc
384    /gl/includes/ui/gl_payment_ui.inc
385    /gl/manage/exchange_rates.php
386    /inventory/adjustments.php
387    /inventory/cost_update.php
388    /inventory/prices.php
389    /inventory/purchasing_data.php
390    /inventory/reorder_level.php
391    /inventory/transfers.php
392    /inventory/includes/item_adjustments_ui.inc
393    /inventory/includes/stock_transfers_ui.inc
394    /inventory/manage/item_units.php
395    /manufacturing/work_order_entry.php
396    /manufacturing/inquiry/where_used_inquiry.php
397    /manufacturing/manage/bom_edit.php
398    /purchasing/po_entry_items.php
399    /purchasing/po_receive_items.php
400    /purchasing/supplier_credit_grns.php
401    /purchasing/supplier_invoice_grns.php
402    /purchasing/supplier_payment.php
403    /purchasing/supplier_trans_gl.php
404    /purchasing/allocations/supplier_allocate.php
405    /purchasing/includes/ui/po_ui.inc
406    /purchasing/inquiry/po_search.php
407    /sales/credit_note_entry.php
408    /sales/customer_credit_invoice.php
409    /sales/customer_delivery.php
410    /sales/customer_invoice.php
411    /sales/customer_payments.php
412    /sales/sales_order_entry.php
413    /sales/allocations/customer_allocate.php
414    /sales/includes/ui/sales_credit_ui.inc
415    /sales/includes/ui/sales_order_ui.inc
416    /sales/manage/customers.php
417    /sales/manage/sales_people.php
418    /sales/view/view_credit.php
419    /sales/view/view_dispatch.php
420    /sales/view/view_invoice.php
421    /sales/view/view_receipt.php
422    /sales/view/view_sales_order.php
423    /taxes/item_tax_types.php
424    /taxes/tax_groups.php
425    /taxes/tax_types.php
426  + User format functions for percent/price/exrate amounts display.
427  $ /includes/current_user.inc
428  + Input checking functions for numeric input fields in user native format
429  $ /includes/data_checks.inc
430  + Numeric input fields in user native format
431  $ /includes/ui/ui_input.inc
432  + Javascript function for conversion to/from user native numeric format.
433  $ /includes/ui/ui_view.inc
434  + New class amount for numeric input
435  $ /themes/aqua/default.css
436    /themes/cool/default.css
437    /themes/default/default.css
438  # Removed warning on adding component
439    /manufacturing/manage/bom_edit.php
440  # Quantity display correction
441    /manufacturing/inquiry/where_used_inquiry.php
442  # Fixed add_customer_trans() call
443    /gl/includes/db/gl_db_banking.inc
444
445 12-Mar-2008 Joe Hung
446  + Added update of Units of Measure and converting of deptor_trans records from release 1.XX
447  - Removed default insertion of Units of Measure. Not neccessary.
448  $ /sql/alter.sql
449    /admin/db/maintenance_db.inc (added support for update)
450
451 11-Mar-2008 Janusz Dobrowolski
452  + Table of measure moved into new table item_units
453  ! Removed $themes[] from config.php, theme list based on directory structure
454  $ /config.php
455    /includes/ui/ui_lists.inc
456    /applications/inventory.php
457    /inventory/includes/inventory_db.inc
458    /inventory/includes/db/items_units_db.inc
459    /inventory/manage/item_units.php
460    /inventory/manage/items.php
461    /sql/alter.sql
462
463 11-Mar-2008 Joe Hunt
464  # Small fix for alignment of date and due date label fields in customer_invoice.php and customer_delivery.php
465  $ /sales/customer_invoice.php
466    /sales/customer_delivery.php
467  
468 10-Mar-2008 Joe Hunt
469  # Small fix for Template Invoice in sales_order_entry.php on line 363 (duedate for Invoice).
470  $ /sales/sales_order_entry.php
471  
472 10-Mar-2008 Janusz Dobrowolski
473  + Added price list selector to sales entry (debtor_master gives only default one)
474  + Added optional submit_on_change parameter to sales ui lists
475  $ /includes/ui/ui_lists.inc
476    /sales/sales_order_entry.php
477    /sales/includes/ui/sales_credit_ui.inc
478    /sales/includes/ui/sales_order_ui.inc
479  # Additional PHP5 fixes, do_clone superseded by local ? : constructs
480  $ /sales/includes/cart_class.inc
481    /includes/ui/ui_view.inc
482    /sales/includes/sales_db.inc
483  # Fixed bogus sales_type lists in edition mode
484  $ /sales/customer_delivery.php
485    /sales/customer_invoice.php
486  # Smaller fixes, cart_class.sales_type name change
487  $ /sales/includes/ui/sales_credit_db.inc
488    /sales/credit_note_entry.php
489    /sales/customer_credit_invoice.php
490    /sales/includes/cart_class.inc
491    /sales/includes/db/sales_credit_db.inc
492    /sales/includes/db/sales_delivery_db.inc
493    /sales/includes/db/sales_invoice_db.inc
494    /sales/includes/db/sales_order_db.inc
495    /sales/includes/ui/sales_credit_ui.inc
496  # One another pmWiki name conflict removed
497  $ /admin/display_prefs.php
498  
499 09-Mar-2008 Joe Hunt
500  - Removed redundant form_types functions and the file /reporting/includes/form_types.inc. Removed table form_items
501  $ /dimensions/includes/dimensions_db.inc
502    /gl/includes/db/gl_db_banking.inc
503    /includes/main.inc
504    /inventory/includes/db/items_adjust_db.inc
505    /manufacturing/includes/db/work_order_issues_db.inc
506    /manufacturing/includes/db/work_order_produce_items_db.inc
507    /manufacturing/includes/db/work_orders_db.inc
508    /manufacturing/includes/db/work_orders_quick_db.inc
509    /purchasing/includes/db/grn_db.inc
510    /purchasing/includes/db/po_db.inc
511    /purchasing/includes/db/supp_payment_db.inc
512    /reporting/includes/form_types.inc (File removed)
513    /sales/includes/db/sales_delivery_db.inc
514    /sales/includes/db/sales_invoice_db.inc
515    /sales/includes/db/sales_order_db.inc
516    /sql/alter.sql
517  # Bug in calculating exchange rates in Reports Supplier Balances and Customer Balances
518  $ /reporting/rep101.php
519    /reporting/rep201.php
520  # clone replacement do_clone() for both PHP 4 and PHP 5.
521  $ /includes/ui/ui_view.inc (at the very bottom)
522    /sales/includes/cart_class.inc
523    
524 07-Mar-2008 Janusz Dobrowolski
525  ! Changed name tax type uniqueness constraint to (name, rate)
526  $ /includes/ui/ui_lists.inc
527    /taxes/items_tax_types.php
528  ! Tax included option moved from tax_group to sales_types table
529  $ includes/ui/ui_view.inc
530    /purchasing/includes/ui/invoice_ui.inc
531    /taxes/tax_calc.inc
532    /taxes/tax_groups.php
533    /taxes/db/tax_groups_db.inc
534    /sql/alter.sql
535  # Final rewriting of sales module, a lot of bugfixes.
536  + Template delivery/invoicing
537  + Concurrent document editing control on sql level
538  + Most of sales documents are now editable
539  + Some links to print documents after entry
540  ! Changed javascript helper function for customer allocations
541  $ /applications/customers.php
542    /includes/ui/ui_input.inc
543    /reporting/rep107.php
544    /reporting/rep109.php
545    /reporting/rep110.php
546    /sales/credit_note_entry.php
547    /sales/customer_credit_invoice.php
548    /sales/customer_delivery.php
549    /sales/customer_invoice.php
550    /sales/customer_payments.php
551    /sales/sales_order_entry.php
552    /sales/allocations/customer_allocate.php
553    /sales/allocations/customer_allocation_main.php
554    /sales/includes/cart_class.inc
555    /sales/includes/sales_db.inc
556    /sales/includes/sales_ui.inc
557    /sales/includes/db/cust_trans_db.inc
558    /sales/includes/db/cust_trans_details_db.inc
559    /sales/includes/db/custalloc_db.inc
560    /sales/includes/db/customers_db.inc
561    /sales/includes/db/payment_db.inc
562    /sales/includes/db/sales_credit_db.inc
563    /sales/includes/db/sales_delivery_db.inc
564    /sales/includes/db/sales_invoice_db.inc
565    /sales/includes/db/sales_order_db.inc
566    /sales/includes/db/sales_types_db.inc
567    /sales/includes/ui/print_invoice.inc
568    /sales/includes/ui/sales_credit_ui.inc
569    /sales/includes/ui/sales_order_ui.inc
570    /sales/inquiry/customer_allocation_inquiry.php
571    /sales/inquiry/customer_inquiry.php
572    /sales/inquiry/sales_deliveries_view.php
573    /sales/inquiry/sales_orders_view.php
574    /sales/manage/credit_status.php
575    /sales/manage/sales_types.php
576    /sales/view/view_credit.php
577    /sales/view/view_dispatch.php
578    /sales/view/view_invoice.php
579    /sales/view/view_receipt.php
580    /sales/view/view_sales_order.php
581 # Removed function name conflict with wiki help system
582    /includes/lang/language.php
583    
584 06-Mar-2008 Janusz Dobrowolski
585  + Wiki help links integration
586  $ /config.php
587    /includes/page/header.inc
588    /includes/lang/language.php
589  + Optional debuging with xdebug module
590  $ /index.php
591    /includes/db/connect_db.inc
592  ! Concurrent edition fix
593  $  /includes/systypes.inc
594  # Table header fix
595  $  /manufacturing/manage/bom_edit.php
596  # Menu layout fixes
597  $ /themes/aqua/renderer.php
598    /themes/cool/renderer.php
599    /themes/default/renderer.php
600  # Removed warning about nonexistent $_GET variable
601  $ /dimensions/inquiry/search_dimensions.php
602  # MySQL 3.xx CAST bug fix
603  $ /includes/db/manufacturing_db.inc
604    /manufacturing/includes/db/work_order_requirements_db.inc
605    /manufacturing/inquiry/where_used_inquiry.php
606
607 04-Mar-2008 Joe Hunt
608  ! Changed so that average item material price is automatic updated whenever a PO Delivery is received.
609    Changed so that a Bill of Materiel, Parent's material price, is automatic updated from underlying items.
610  $ /inventory/cost_update.php
611    /purchasing/includes/db/grn_db.inc and
612    /manufacturing/manage/bom_edit.php. 
613    /manufacturing/includes/db/work_orders_db.inc
614    /manufacturing/includes/db/work_orders_quick_db.inc
615    /manufacturing/work_order_entry.php
616   
617 21-Feb-2008 Joe Hunt
618  + Added Print for documents in /admin/view_print_transaction.php (according to our new routines).
619  $ /admin/view_print_transaction.php
620    /applications/setup.php
621   
622 17-Feb-2008 Joe Hunt
623  ! Minor change in menu and function in view_print_transaction.php
624  $ /admin/view_print_transaction.php
625    /application/setup.php
626  + Preparing for print of single documents
627  $ /reporting/includes/reporting.inc
628  ! Removing 'out' field in table tax_types
629  $ /sql/alter.sql
630    /taxes/tax_types.php
631    /taxes/db/tax_types_db.inc
632  + Added 2 functions in ui_input.inc, button and button_cell
633    /includes/ui/ui_input.inc
634
635 11-Feb-2008 Joe Hunt
636  + Added file, update_db.php, for updating company databases from an SQL script.
637  $ update_db.php (New file)
638    update.html
639   
640 06-Fef-2008 Joe Hunt
641  + Added Report, Salesman Listing, rep106.php. 
642  $ /reporting/reports_main.php
643    /reporting/rep106.php
644   
645 06-Feb-2008 Janusz Dobrowolski
646  + Separation of customer invoice issue and goods delivery.
647  + Batch invoicing for more than one delivery
648  # Corrected inadequate shipping tax calculations.
649  ! Default debugging status changed to off.
650  $ /taxes/tax_calc.inc
651    /taxes/db/tax_groups_db.inc
652    /admin/db/voiding_db.inc
653    /applications/customers.php
654    /includes/systypes.inc
655    /includes/types.inc
656    /includes/ui/ui_controls.inc
657    /includes/ui/ui_lists.inc
658    /includes/ui/ui_view.inc
659    /inventory/inquiry/stock_status.php
660    /reporting/rep105.php
661    /reporting/rep107.php
662    /reporting/rep109.php
663    /reporting/rep110.php 
664    /reporting/rep209.php
665    /reporting/reports_main.php
666    /reporting/includes/doctext.inc
667    /reporting/includes/doctext2.inc
668    /reporting/includes/form_types.inc
669    /reporting/includes/pdf_report.inc
670    /reporting/includes/reports_classes.inc
671    /sales/customer_credit_invoice.php
672    /sales/customer_invoice.php
673    /sales/sales_order_entry.php
674    /sales/customer_delivery.php 
675    /sales/includes/db/sales_delivery_db.inc 
676    /sales/includes/ui/print_invoice.inc 
677    /sales/includes/cart_class.inc
678    /sales/includes/sales_db.inc
679    /sales/includes/db/cust_trans_db.inc
680    /sales/includes/db/cust_trans_details_db.inc
681    /sales/includes/db/sales_credit_db.inc
682    /sales/includes/db/sales_invoice_db.inc
683    /sales/includes/db/sales_order_db.inc
684    /sales/includes/ui/sales_order_ui.inc
685    /sales/inquiry/customer_allocation_inquiry.php
686    /sales/inquiry/customer_inquiry.php
687    /sales/inquiry/sales_orders_view.php
688    /sales/inquiry/sales_deliveries_view.php 
689    /sales/view/view_dispatch.php
690    /sales/view/view_invoice.php
691    /sales/view/view_sales_order.php
692    /sql/alter.sql
693    config.php
694   
695 01-Feb-2008 Joe Hunt
696  ! Changed so sales orders can have more than one row with the same stock_id. In alter.sql.
697  $ /sales/includes/cart_class.inc
698    /sales/includes/db/sales_credit_db.inc
699    /sales/includes/db/sales_invoice_db.inc
700    /sales/includes/db/sales_order_db.inc
701    /sales/includes/db/cust_trans_details_db.inc
702    /sales/includes/ui/sales_order_ui.inc
703    /sales/includes/ui/sales_credit_ui.inc
704    /sales/credit_note_entry.php
705    /sales/customer_credit_invoice.php
706    /sales/sales_order_entry.php
707    /sales/customer_invoice.php
708
709 31-Jan-2008 Joe Hunt
710  ! New Release 2.0 Pre Alpha
711  $ config.php
712  # Fixed a release 2 related bug in create_coy.php
713  $ /admin/create_coy.php
714  + An alter.sql file to use for updating databases. Until the update_db.php is ready, you can use the install/update companies
715    and select the companies one by one and upload the alter.sql file to all companies. You can still run the release 2
716    with these databases changes without any new files. They are coming as soon as possible.
717  $ /sql/alter.sql (New file)  
718  # Fixed a release 2 related bug. A field in supp_trans_items were declared as integer(11). Changed to VARCHAR(11) in alter.sql
719    and 2 related files
720  $ /purchasing/supplier_trans_gl.php
721    /purchasing/includes/db/invoice_items_db.inc
722  ! Moved variables $no_item_list, $no_customer_list and $no_supplier_list in config.php to company table
723  $ /includes/ui/ui_lists.inc
724    /purchasing/includes/ui/po_ui.inc
725    /sales/includes/ui/sales_order_ui.inc
726    /admin/company_preferences.php
727    /admin/db/company_db.inc
728    config.php
729  + Created 3 new fields in salesman table for provision, break point and provision2. Included in alter.sql. 
730    Update sales_people.php.Preparing for a new Salesman report with provision etc. Selected with time range. Should be very good.
731  $ /sales/manage/sales_people.php
732    /includes/ui/ui_input.inc
733  
734 -------------------- 2,0 Pre Alpha - above ----------------------------
735 31-Jan-2008 Janusz Dobrowolski
736  # Minor bugfix in db_import()
737  $ /admin/db/maintenance_db.inc
738  
739 30-Jan-2008 Janusz Dobrowolski
740  # Minor display fix in tax_types.php
741  $ /taxes/tax_types.php
742  ! Format cleanup on some files.
743  $ /gl/includes/gl_db.inc
744    /gl/includes/gl_ui.inc
745    /applications/application.php
746    frontaccounting.php
747    index.php
748    
749 -------------------- 1.16 Stable Released ----------------------
750 28-Jan-2008 Joe Hunt
751  + Added a possibility to replace the normal listboxes for items, customer and/or suppliers with a search box.
752    The listboxes can only hold about 1000 items. New variables in config.php, $no_item_list, $no_customer_list 
753    and $no_supplier_list. Default is the normal behavior for all listboxes.
754  $ /includes/ui/ui_lists.inc
755    /sales/includes/ui/sales_orders_ui.inc
756    /purchases/includes/ui/po_ui.inc
757    /themes/default/images/locate.png (New file)
758    config.php
759
760  + Added ALTER TABLE possibility in db_import. For future releases.
761  $ /admin/db/maintenence_db.inc  
762
763  # Removed warnings 'Call-time pass-by-reference' in /includes/db/connect_db.inc and /includes/ui/ui_lists.inc
764  # Fixed File not found when loading local stylesheet.css (for other languages) in /includes/page/header.inc
765  $ /includes/db/connect_db.inc
766    /includes/ui/ui_lists.inc
767    /includes/page/header.inc
768    /access/login.php
769    
770 16-Jan-2008 Joe Hunt
771  # When login screen is displayed after session timeout page content is broken. It
772    is because of NOT using absolute paths in href attribute theme elements.
773  $ /access/login.php
774  
775 30-Dec-2007 Joe Hunt
776  # Minor adjustments in function db_export on line 325
777  $ /admin/db/maintenance_db.inc
778  
779 29-Dec-2007 Joe Hunt
780  + Added a variable, $print_invoice_no, in config.php for printing the invoice number instead of invoice reference.
781  $ config.php
782  
783  # Fixed a bug when exporting database. Exported NULL field values from NO to empty field (from mysql version 5.0.32).
784    Also fixed a unneccessary str_replace when importing sql scripts.
785  ! Changed the PDF presentation to deleting the Javascript cache before presentation.
786  $ /admin/db/maintenance_db.inc
787    /reporting/includes/pdf_report.inc
788    
789 13-Dec-2007 Joe Hunt
790  # Still bugs in trial balances and account inquiry on screen when selecting non balance accounts. Fixed.
791  $ /gl/inquiry/gl_trial_balance.php
792    /gl/inquiry/gl_account_inquiry.php
793
794 13-Dec-2007 Joe Hunt
795  # Fixed a bug when voiding a transaction (Journal Entry). An eventually underlying bank transfer was not voided.
796  $ /admin/db/voiding_db.inc
797  
798 06-Dec-2007 Joe Hunt
799  # Fixed a bug when adding lines during Payments to suppliers, the supplier was set back to the first.
800  $ /gl/gl_payment.php
801    /gl/includes/ui/gl_payment_ui.inc
802    
803  ! Changed $loc_notification to be set to 0 instead of 1.
804  $ config.php
805  
806 -------------------- 1.15 Stable Released ----------------------
807 05-Dec-2007 Joe Hunt
808  + Added email notification to stock location when available stock is below reorder level
809  $ config.php
810    /sales/includes/db/sales_order_db.inc
811    
812  # Fixed bugs in Open balances when account is not a balance account
813  $ /gl/inquiry/gl_trial_balance.php
814    /gl/inquiry/gl_account_inquiry.php
815    /reporting/rep704.php
816    /reporting/rep708.php
817    
818 -------------------- 1.14 Stable Released ----------------------
819 01-Oct-2007 Joe Hunt
820  ! Major change in the installation of modules to also accept an SQL-file for upload.
821  $ config.php
822    /admin/inst_module.php
823    /admin/db/maintenance_db.inc
824    
825 30-Sep-2007 Joe Hunt
826  # The following files were still vulnerable. Fixed
827  $ /access/login.php
828    /includes/lang/language.php
829
830 -------------------- 1.13 Stable Released ----------------------
831 14-Sep-2007 Joe Hunt
832  + Added optional link for electronic payment on invoices (PayPal). 
833  ! Better support for install/update languages.  
834  ! Minor adjustments
835  # Fixed a vulnerable item in config.php
836  $ config.php
837
838 14-Sep-2007 Joe Hunt
839  # We forgot to upload the PO file when installing new language. Used when GETTEXT is not installed on Server.
840  # config.php has been vulnerable. Fixed.
841  $ /admin/inst_lang.php
842  $ config.php
843  
844 10-Sep-2007 Joe Hunt
845  ! Changed Bank Address field from text to textarea (multirows)
846  $ /gl/manage/bank_accounts.php
847  
848 06-Sep-2007 Joe Hunt
849  + Added optional link for electronic payment on invoices (PayPal)
850  $ /reporting/reports_main.php
851    /reporting/rep107.php
852    /reporting/includes/report_classes.inc
853    /reporting/includes/pdf_report.inc
854    /reporting/includes/doc_text.inc
855    /reporting/includes/doc_text2.inc
856    
857 23-Aug-2007 Joe Hunt
858  # Unnecessary parameter ($db) in check_for_recursive_bom
859  $ /manufacturing/manage/bom_edit.php
860  
861 21-Aug-2007 Joe Hunt
862  # Bug in /includes/lang/gettext.php (249) affecting changing language!
863  $ /includes/lang/gettext.php
864  
865 08-Aug-2007 Joe Hunt
866  # Minor adjustments
867  $ config.php
868    /access/login.php
869    /admin/create_coy.php
870    /reporting/includes/pdf_report.inc
871    
872 04-Aug-2007 Joe Hunt
873  + Added a default fiscal year in the en_US-new.sql and start references.
874  $ /sql/en_US-new.sql
875  ! Changed some specific text strings in en_US.po (E.g. TAX instead of VAT)
876  $ /lang/en_US/LC_MESSAGES/en_US.mo
877  
878 03-Aug-2007 Joe Hunt
879  # A bug in Direct Invoicing (wrong Invoice Date) has been fixed.
880  $ /sales/includes/db/sales_order_db.inc
881  
882 23-Jul-2007 Joe Hunt
883  # Changed <? in front of 2 files to <?php.
884  $ /purchasing/includes/purchasing_ui.inc
885    /reporting/includes/class.mail.inc
886    
887 -------------------- 1.12 Stable Released ----------------------
888 21-Jul-2007 Joe Hunt
889  + Added option to handle Jalali and Islamic Calendars
890  ! Minor adjustments
891  $ config.php
892    /gl/includes/db/gl_db_trans.inc
893    /includes/date_functions.inc
894    /includes/ui/ui_input.inc
895    /includes/ui/ui_lists.inc
896    /includes/ui/ui_view.inc
897    /purchasing/po_receive_items.php
898    /purchasing/includes/ui/invoice_ui.inc
899    /purchasing/includes/ui/po_ui.inc
900    /reporting/rep705.php
901    /sales/includes/db/sales_order_db.inc
902    /sales/includes/ui/sales_order_ui.inc
903    
904 20-Jul-2007 Joe Hunt
905  ! Changed parameters on report Sales Order. Option to print as Quote.
906  $ /reporting/reports_main.php
907    /reporting/rep109.php
908    /reporting/includes/pdf_report.inc
909    /reporting/includes/doctext.inc
910    /reporting/includes/doctext2.inc
911  
912 19-Jul-2007 Joe Hunt
913  + Added Budget Entry in General Ledger. Includes Dimensions.
914  $ config.php
915    /applications/generalledger.php
916    /gl/gl_budget.php (New File!)
917    /gl/includes/db/gl_db_trans.inc
918    /includes/date_functions.inc
919    /reporting/report_classes.inc
920    
921 -------------------- 1.11 Stable Released ----------------------
922 04-Jul-2007 Joe Hunt
923  ! Option for using alpha numeric chart of accounts.
924  $ config.php
925    /gl/manage/gl_accounts.php
926    /gl/includes/db/gl_db_accounts.inc
927    /gl/includes/db/gl_db_bank_trans.inc
928    /gl/includes/db/gl_db_trans.inc
929    /gl/inquiry/gl_trial_balance.inc
930    /admin/db/company_db.inc
931    /inventory/includes/db/items_db.inc
932    /sales/manage/customer_branches.inc
933
934 04-Jul-2007 Joe Hunt
935  # Problems retrieving language texts for poEdit in long javascripts
936  $ /includes/ui/ui_view.inc
937  
938 04-May-2007 Joe Hunt
939  # Database error when updating more than one item row in Sales Orders.
940  $ /sales/includes/db/sales_order_db.inc
941  # Database error when inserting work order issues. Fixed.
942  $ /manufacturing/includes/db/work_order_issues_db.inc
943  
944 03-May-2007 Joe Hunt
945  # Multiple tables and JOIN's have syntax changes in MySQL 5.0.12. Need parentheses.
946  $ /includes/db/manufacturing_db.inc
947    /manufacturing/includes/db/work_order_requirements_db.inc
948
949 02-May-2007 Joe Hunt
950  # Missing details on Purchase Order when emailing and printing
951  $ /reporting/rep209.php
952  
953 -------------------- 1.1 Stable Released ----------------------
954 02-May-2007 Joe Hunt
955  + Enabled module addons and all the below bugfixes. No changes in database structure.
956  - Removed /sql/basic.sql (included in the other sql files)
957  - Removed /themes/default/images/left.gif and /themes/default/images/right.gif 
958    (not needed anymore).
959  + Addition of update.html  
960  $ /admin/inst_module.php (New file!)
961    /applications/customers.php
962    /applications/dimensions.php
963    /applications/generalledger.php
964    /applications/inventory.php
965    /applications/manufacturing.php
966    /applications/setup.php
967    /applications/suppliers.php
968    /install/index.php
969    /install/save.php
970    /modules/inst_modules.php (New folder and new file!)
971    /modules/index.php (New file!)
972    /sql/en_US-demo.sql
973    /sql/en_US-new.sql
974    install.html
975    update.html (New file!)
976    
977 01-May-2007 Joe Hunt
978  # Missing measure of units when printing sales orders
979  # Update of Sales People caused a database error
980  $ /sales/manage/sales_people.php
981    /reporting/rep109.php
982  
983 30-Apr-2007 Joe Hunt
984  + The selected menu tab is now shown with same background as hover color.
985  $ config.php (default tab line 77. Change if you want)
986    /includes/page/header.inc
987    
988 28-Apr-2007 Joe Hunt
989  # When saving work order entries a lot of debug boxes appeared. Fixed
990  # When clicking on the link, Issue, on work order inquires an empty screen appeared. Fixed
991  # When retrieving work centres id's there was a database error. Fixed by casting string to unsigned
992  $ /includes/db/manufacturing_db.inc
993    /manufacturing/work_order_entry.php
994    /manufacturing/includes/work_order_issue_ui.inc
995    /manufacturing/includes/db/work_order_requirements_db.inc
996    /manufacturing/includes/db/work_orders_quick_db.inc
997    /manufacturing/inquiry/where_used_inquiry.php
998    
999 25-Apr-2007 Joe Hunt
1000  # Missing Date Picker
1001  $ /sales/customer_invoice.php
1002  # No JS popup window
1003  $ /sales/view/view_invoice.php
1004  
1005 24-Apr-2007 Joe Hunt
1006  ! New and better Date Picker, better cool theme.
1007  $ /includes/ui/ui_input.inc
1008    /includes/ui/ui_view.inc
1009    /reporting/includes/reports_classes.inc
1010    /themes/cool/default.css
1011
1012 -------------------- 1.0.1 Stable Released ----------------------
1013 23-Apr-2007 Joe Hunt
1014  ! Release 1.0.1 established on SourceForge, fixing the bugs and including a Date Picker,
1015    the changes for selection lists customers/suppliers and the Audit Trail.
1016
1017 22-Apr-2007 Joe Hunt
1018  ! Changed the two selection lists for customers/suppliers in reports to a single one with
1019    No Filter
1020  ! Changed the sort order in these selection lists from id to name.
1021  + Added Audit Trail in GL trans. A switch in config.php, $use_audit_trail, must be set to 1.
1022  $ /reporting/reports_main.php
1023    /reporting/rep101.php
1024    /reporting/rep102.php
1025    /reporting/rep201.php
1026    /reporting/rep202.php
1027    /reporting/rep203.php
1028    /reporting/rep204.php
1029    /reporting/includes/reports_classes.inc
1030    /includes/ui/ui_lists.inc
1031    /gl/includes/db/gl_db_trans.inc
1032    config.php
1033    
1034 22-Apr-2007 Joe Hunt
1035  + Date Picker for all date fields.
1036  $ config.php
1037    /admin/fiscalyears.php
1038    /admin/void_transaction.php
1039    /includes/ui/ui_view.inc
1040    /includes/ui/ui_input.inc
1041    /dimensions/dimension_entry.php
1042    /dimensions/inquiry/search_dimensions.php
1043    /gl/gl_journal.php
1044    /gl/gl_deposit.php
1045    /gl/gl_payment.php
1046    /gl/bank_transfer.php
1047    /gl/inquiry/bank_inquiry.php
1048    /gl/inquiry/gl_account_inquiry.php
1049    /gl/inquiry/gl_trial_balance.php
1050    /gl/manage/exchange_rates.php
1051    /inventory/adjustments.php
1052    /inventory/transfers.php
1053    /inventory/inquiry/stock_movements.php
1054    /inventory/manage/items.php
1055    /manufacturing/work_order_add_finished.php
1056    /manufacturing/work_order_entry.php
1057    /manufacturing/work_order_issue.php
1058    /manufacturing/work_order_release.php
1059    /purchasing/supplier_payment.php
1060    /purchasing/po_entry_items.php
1061    /purchasing/po_receive_items.php
1062    /purchasing/supplier_credit.php
1063    /purchasing/supplier_credit_grns.php
1064    /purchasing/supplier_invoice.php
1065    /purchasing/supplier_invoice_grns.php
1066    /purchasing/supplier_trans_gl.php
1067    /purchasing/includes/ui/po_ui.inc
1068    /purchasing/inquity/po_search.php
1069    /purchasing/inquiry/po_search_completed.php
1070    /purchasing/inquiry/supplier_allocation_inquiry.php
1071    /purchasing/inquiry/supplier_inquiry.php
1072    /reporting/reports_main.php
1073    /reporting/includes/reports_classes.inc
1074    /sales/credit_note_entry.php
1075    /sales/customer_credit_invoice.php
1076    /sales/customer_payments.php
1077    /sales/sales_order_entry.php
1078    /sales/includes/ui/sales_order_ui.inc
1079    /sales/inquiry/customer_allocation_inquiry.php
1080    /sales/inquiry/customer_inquiry.php
1081    /sales/inquiry/sales_orders_view.php
1082    New image files:
1083    /themes/default/images/cal.gif
1084    /themes/default/images/next.gif
1085    /themes/default/images/prev.gif
1086
1087 19-Apr-2007 Joe Hunt
1088  # Bug no 1703895, Account numbers are varchars, need quotes, fixed
1089  # Bug no 1703891, Reserved MySQL words used as column names, fixed
1090  $ /taxes/db/tax_types_db.inc
1091
1092  # Bug no 1703888, Apostrophes and other unescaped characters, fixed
1093  $ /gl/manage/gl_accounts.php
1094    /gl/includes/db/gl_db_accounts.inc
1095    /includes/ui/ui_input.inc
1096
1097 18-Apr-2007 Joe Hunt
1098  # Bug no 1702594, Logon Loop, fixed
1099  $ config.php
1100
1101 -------------------- 1.0a Stable Released ----------------------
1102 10-Apr-2007 Joe Hunt
1103  ! Release 1.0a established on SourceForge, fixing the bugs.
1104
1105 11-Apr-2007 Joe Hunt
1106  # Bug No 1698214, Creating Items, fixed
1107  $ /includes/ui/ui_lists.inc
1108  # Bug no 1698216, Item Movements, fixed
1109  $ /inventory/manage/items.php
1110
1111 -------------------- 1.0 Stable Released ----------------------
1112 10-Apr-2007 Joe Hunt
1113  ! Release 1.0 established on SourceForge.
1114
1115 2. Copyright and disclaimer
1116 ---------------------------
1117 This application is opensource software released under the GPL.  Please
1118 see source code and the LICENSE file