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