fa-stable.git
14 years agoMoved all SQL statements from PHP files into relevant *_db.inc files.
Joe Hunt [Tue, 1 Dec 2009 16:55:24 +0000 (16:55 +0000)]
Moved all SQL statements from PHP files into relevant *_db.inc files.
  included gl folder

14 years agoMoved all SQL statements from PHP files into relevant *_db.inc files.
Joe Hunt [Mon, 30 Nov 2009 09:02:32 +0000 (09:02 +0000)]
Moved all SQL statements from PHP files into relevant *_db.inc files.

14 years agoFixed side bug after last sql update.
Janusz Dobrowolski [Wed, 18 Nov 2009 13:08:59 +0000 (13:08 +0000)]
Fixed side bug after last sql update.

14 years agoAllow null references in trans to show up in gl_trans_view
Joe Hunt [Wed, 18 Nov 2009 09:54:04 +0000 (09:54 +0000)]
Allow null references in trans to show up in gl_trans_view

14 years agoRelease 2.2
Joe Hunt [Wed, 18 Nov 2009 07:53:51 +0000 (07:53 +0000)]
Release 2.2

14 years agoChanged rep705 to show fiscal year instead of year
Joe Hunt [Tue, 17 Nov 2009 22:34:39 +0000 (22:34 +0000)]
Changed rep705 to show fiscal year instead of year

14 years agoMoved payment terms in documents for better view. Increased space for legal text.
Joe Hunt [Tue, 17 Nov 2009 21:09:54 +0000 (21:09 +0000)]
Moved payment terms in documents for better view. Increased space for legal text.
Changed sorting in get_gl_transactions to sort by tran_date, counter
Changed period in Journal Entries to one month instead of one year.

14 years agoVariable ctrl_handlers moved to BoxReports.
Janusz Dobrowolski [Sun, 15 Nov 2009 22:07:14 +0000 (22:07 +0000)]
Variable ctrl_handlers moved to BoxReports.

14 years agoAdded integrtion ofcustom and extended reports to reporting menu; ui_list cleanup.
Janusz Dobrowolski [Sun, 15 Nov 2009 21:00:09 +0000 (21:00 +0000)]
Added integrtion ofcustom and extended reports to reporting menu; ui_list cleanup.

14 years agoAll *_list() functions now does not display html directly - added echo when needed.
Janusz Dobrowolski [Sun, 15 Nov 2009 20:58:54 +0000 (20:58 +0000)]
All *_list() functions now does not display html directly - added echo when needed.

14 years agoAdde integration of custom/extended reports; optimizations.
Janusz Dobrowolski [Sun, 15 Nov 2009 20:55:06 +0000 (20:55 +0000)]
Adde integration of custom/extended reports; optimizations.

14 years agoAll *_list() functions now return html code instead direct display, *_list_cells...
Janusz Dobrowolski [Sun, 15 Nov 2009 20:53:57 +0000 (20:53 +0000)]
All *_list() functions now return html code instead direct display, *_list_cells() and
*_list_row() work as before.

14 years agoAllow editing account when editing a row in GL Bank and GL Journal Entry
Joe Hunt [Fri, 13 Nov 2009 15:50:27 +0000 (15:50 +0000)]
Allow editing account when editing a row in GL Bank and GL Journal Entry
Transaction bug in void_journal_trans()

14 years agoCleaning CHANGELOG.txt and small fix in references.inc
Joe Hunt [Fri, 13 Nov 2009 13:45:21 +0000 (13:45 +0000)]
Cleaning CHANGELOG.txt and small fix in references.inc

14 years agoChanged to allow change of reference in GL modifying
Joe Hunt [Thu, 12 Nov 2009 21:11:21 +0000 (21:11 +0000)]
Changed to allow change of reference in GL modifying
Added reference in gl_trans_view.php

14 years agoFixed maksimum length of memo for gl postings in entry forms.
Janusz Dobrowolski [Thu, 12 Nov 2009 20:33:20 +0000 (20:33 +0000)]
Fixed maksimum length of memo for gl postings in entry forms.

14 years agoAdded amount range in gl inquires.
Janusz Dobrowolski [Thu, 12 Nov 2009 10:36:27 +0000 (10:36 +0000)]
Added amount range in gl inquires.

14 years agoFixed typo
Janusz Dobrowolski [Thu, 12 Nov 2009 10:35:26 +0000 (10:35 +0000)]
Fixed typo

14 years agoChanged menu option text for GL inquiry.
Janusz Dobrowolski [Thu, 12 Nov 2009 10:35:03 +0000 (10:35 +0000)]
Changed menu option text for GL inquiry.

14 years agoChanged Journal Inquiries so it shows the Bank Deposit/Payment amount instead of...
Joe Hunt [Thu, 12 Nov 2009 10:29:43 +0000 (10:29 +0000)]
Changed Journal Inquiries so it shows the Bank Deposit/Payment amount instead of sum of positive transaction.

14 years agotype warning in dimension tags
Joe Hunt [Tue, 10 Nov 2009 22:58:30 +0000 (22:58 +0000)]
type warning in dimension tags

14 years agoFixed value for SA_SUPPBULKREP access area.
Janusz Dobrowolski [Tue, 10 Nov 2009 22:02:15 +0000 (22:02 +0000)]
Fixed value for SA_SUPPBULKREP access area.

14 years agodisallow bank accounts in accounts list in Bank Deposits/Payments.
Joe Hunt [Tue, 10 Nov 2009 00:23:28 +0000 (00:23 +0000)]
disallow bank accounts in accounts list in Bank Deposits/Payments.
It produces double records in bank inquiry otherwise.

14 years agoFixed help link generation to clean page context string.
Janusz Dobrowolski [Mon, 9 Nov 2009 11:00:04 +0000 (11:00 +0000)]
Fixed help link generation to clean page context string.

14 years agoChanged the Running Balance column in Customer Transaction to only show when the...
Joe Hunt [Sun, 8 Nov 2009 14:29:58 +0000 (14:29 +0000)]
Changed the Running Balance column in Customer Transaction  to only show when the type is selected. The order is not good before sorting in date order

14 years agoBug in adding freight cost to sales order/quotation
Joe Hunt [Sun, 8 Nov 2009 10:54:57 +0000 (10:54 +0000)]
Bug in adding freight cost to sales order/quotation
Additional improvements on layout display

14 years agoAdded mising help context in sales inquires.
Janusz Dobrowolski [Sat, 7 Nov 2009 15:35:15 +0000 (15:35 +0000)]
Added mising help context in sales inquires.

14 years agoAdded missing help_context
Janusz Dobrowolski [Sat, 7 Nov 2009 15:34:04 +0000 (15:34 +0000)]
Added missing help_context

14 years agoMore improvements on layout display.
Joe Hunt [Sat, 7 Nov 2009 10:45:06 +0000 (10:45 +0000)]
More improvements on layout display.

14 years agoImproved layout in the new tax info display. Also old ones.
Joe Hunt [Fri, 6 Nov 2009 11:01:43 +0000 (11:01 +0000)]
Improved layout in the new tax info display. Also old ones.

14 years agoFixed include file sequence.
Janusz Dobrowolski [Fri, 6 Nov 2009 09:27:36 +0000 (09:27 +0000)]
Fixed include file sequence.

14 years agoBug on line 215 in /sales/customer_delivery.php
Joe Hunt [Thu, 5 Nov 2009 09:57:14 +0000 (09:57 +0000)]
Bug on line 215 in /sales/customer_delivery.php

14 years agoRerun. Modifying need an extra column.
Joe Hunt [Thu, 5 Nov 2009 09:32:35 +0000 (09:32 +0000)]
Rerun. Modifying need an extra column.

14 years agoRerun. Update button for change of shipping
Joe Hunt [Thu, 5 Nov 2009 09:20:45 +0000 (09:20 +0000)]
Rerun. Update button for change of shipping

14 years agoInclude freight_cost in Sales Quotations, Orders in inquiries.
Joe Hunt [Thu, 5 Nov 2009 00:40:23 +0000 (00:40 +0000)]
Include freight_cost in Sales Quotations, Orders in inquiries.

14 years agoDisplay tax info in Sales Quotation, Order, Direct Delivery and Invoice.
Joe Hunt [Thu, 5 Nov 2009 00:12:26 +0000 (00:12 +0000)]
Display tax info in Sales Quotation, Order, Direct Delivery and Invoice.

14 years agoIncluded dimension(s) in Bank Deposit/Payment View and correct signs.
Joe Hunt [Wed, 4 Nov 2009 23:02:34 +0000 (23:02 +0000)]
Included dimension(s) in Bank Deposit/Payment View and correct signs.

14 years agoFixed bug in printer selection introduced during security update and
Janusz Dobrowolski [Wed, 4 Nov 2009 14:28:39 +0000 (14:28 +0000)]
Fixed bug in printer selection introduced during security update and
merged from main trunk.

14 years agoChanged so reference no in QUOTE/SO/INV/CRE/PO is printed instead of trans_no
Joe Hunt [Tue, 3 Nov 2009 16:29:15 +0000 (16:29 +0000)]
Changed so reference no in QUOTE/SO/INV/CRE/PO is printed instead of trans_no
if global variable in config.php, $print_invoice_no = 0 (default).

14 years agoFixed js bug on logout screen, optional transactions support in
Janusz Dobrowolski [Tue, 3 Nov 2009 15:34:04 +0000 (15:34 +0000)]
Fixed js bug on logout screen, optional transactions support in
add_bank_transaction

14 years agoAdded optional parameter in add_bank_transaction
Janusz Dobrowolski [Tue, 3 Nov 2009 15:32:51 +0000 (15:32 +0000)]
Added optional parameter in add_bank_transaction

14 years agoFixed missing defualt for price_dec setting.
Janusz Dobrowolski [Tue, 3 Nov 2009 15:32:00 +0000 (15:32 +0000)]
Fixed missing defualt for price_dec setting.

14 years agoWrong presentation on reference and order in Customer Allocation Inquiry
Joe Hunt [Tue, 3 Nov 2009 10:37:12 +0000 (10:37 +0000)]
Wrong presentation on reference and order in Customer Allocation Inquiry

14 years agoBad debit account when debiting service items.
Joe Hunt [Tue, 3 Nov 2009 00:43:27 +0000 (00:43 +0000)]
Bad debit account when debiting service items.
Removed unneeded reference to $result in db_num_rows. Gave warnings
Better formatting of update.html

14 years agoBad value for COGS acount retrieved from category for new service type
Janusz Dobrowolski [Mon, 2 Nov 2009 16:06:54 +0000 (16:06 +0000)]
Bad value for COGS acount retrieved from category for new service type
item entry.

14 years agoAdded default date format used before login.
Janusz Dobrowolski [Sun, 1 Nov 2009 22:42:22 +0000 (22:42 +0000)]
Added default date format used before login.

14 years agoBugs in function show_users_online in users_db.inc
Joe Hunt [Sun, 1 Nov 2009 10:50:03 +0000 (10:50 +0000)]
Bugs in function show_users_online in users_db.inc
Small sideeffect in date_functions after correction of $date_system

14 years agoChanged $date_system value of 3 to be traditional, but non-workday is Friday and...
Joe Hunt [Sun, 1 Nov 2009 08:22:39 +0000 (08:22 +0000)]
Changed $date_system value of 3 to be traditional, but non-workday is Friday  and start of week is Saturday. For DatePicker.

14 years agoFixed non-default company selection bug on login.
Janusz Dobrowolski [Fri, 30 Oct 2009 13:23:44 +0000 (13:23 +0000)]
Fixed non-default company selection bug on login.

14 years agoCode cleanup.
Janusz Dobrowolski [Fri, 30 Oct 2009 13:22:39 +0000 (13:22 +0000)]
Code cleanup.

14 years agoChanged name on folder for global help url to fawiki.
Joe Hunt [Fri, 30 Oct 2009 08:28:51 +0000 (08:28 +0000)]
Changed name on folder for global help url to fawiki.

14 years agoChanged context help system organization to enable use of central multilanguage wiki.
Janusz Dobrowolski [Thu, 29 Oct 2009 22:11:00 +0000 (22:11 +0000)]
Changed context help system organization to enable use of central multilanguage wiki.

14 years agoChanged context help organization to enable use of central, multilanguage wiki.
Janusz Dobrowolski [Thu, 29 Oct 2009 22:05:40 +0000 (22:05 +0000)]
Changed context help organization to enable use of central, multilanguage wiki.

14 years agoChanged report Annual Expense Breakdown to follow the fiscal year instead of
Joe Hunt [Wed, 28 Oct 2009 11:11:41 +0000 (11:11 +0000)]
Changed report Annual Expense Breakdown to follow the fiscal year instead of
calendar year. The year selector selects the start of the fiscal year.
Only the last 12 months are shown.

14 years agoDatabase error when updating item.
Joe Hunt [Tue, 27 Oct 2009 13:53:49 +0000 (13:53 +0000)]
Database error when updating item.

14 years agoRemoved unneeded double forms in scripts with db_pager. Missing $_POST variables.
Joe Hunt [Tue, 27 Oct 2009 13:44:24 +0000 (13:44 +0000)]
Removed unneeded double forms in scripts with db_pager. Missing $_POST variables.

14 years agoFixed error during gl class update [0000177]
Janusz Dobrowolski [Mon, 26 Oct 2009 16:54:35 +0000 (16:54 +0000)]
Fixed error during gl class update [0000177]

14 years agoFixed another compatibility issue with MySQL 3.xx (DATE)
Joe Hunt [Mon, 26 Oct 2009 15:43:10 +0000 (15:43 +0000)]
Fixed another compatibility issue with MySQL 3.xx (DATE)
Late language changes

14 years agoFixed compatibility issue with MySQL 3.xx
Janusz Dobrowolski [Sun, 25 Oct 2009 12:27:15 +0000 (12:27 +0000)]
Fixed compatibility issue with MySQL 3.xx

14 years agoFixed ajax support for multiply selects, obsoleted #tags array some other small fixes
Janusz Dobrowolski [Sat, 24 Oct 2009 20:01:29 +0000 (20:01 +0000)]
Fixed ajax support for multiply selects, obsoleted #tags array some other small fixes

14 years agoRemoved obsolete $tabs global array, tab ids retrieved from $_SESSION['App']
Janusz Dobrowolski [Sat, 24 Oct 2009 19:59:38 +0000 (19:59 +0000)]
Removed obsolete $tabs global array, tab ids retrieved from $_SESSION['App']

14 years agoDefualt add/update button, ajax page update.
Janusz Dobrowolski [Sat, 24 Oct 2009 19:58:23 +0000 (19:58 +0000)]
Defualt add/update button, ajax page update.

14 years agoFixed ajax support for multiply selects.
Janusz Dobrowolski [Sat, 24 Oct 2009 19:57:31 +0000 (19:57 +0000)]
Fixed ajax support for multiply selects.

14 years agoFixed buggy php behaviour when foreach is used on global array.
Janusz Dobrowolski [Sat, 24 Oct 2009 19:56:53 +0000 (19:56 +0000)]
Fixed buggy php behaviour when foreach is used on global array.

14 years agoCleanup of not important error log messages.
Janusz Dobrowolski [Sat, 24 Oct 2009 13:22:57 +0000 (13:22 +0000)]
Cleanup of not important error log messages.

14 years agoFixed error log warning (missing installed_extensions.inc) during upgrade to 2.2.
Janusz Dobrowolski [Sat, 24 Oct 2009 13:21:22 +0000 (13:21 +0000)]
Fixed error log warning (missing installed_extensions.inc) during upgrade to 2.2.

14 years agoCVS folders excluded from flush_dir to avoid unwanted messages in error log on devel...
Janusz Dobrowolski [Sat, 24 Oct 2009 13:20:16 +0000 (13:20 +0000)]
CVS folders excluded from flush_dir to avoid unwanted messages in error log on devel boxes.

14 years ago*** empty log message ***
Joe Hunt [Sat, 24 Oct 2009 09:05:03 +0000 (09:05 +0000)]
*** empty log message ***

14 years agoFixed table selection query in sanitize_database().
Janusz Dobrowolski [Sat, 24 Oct 2009 09:04:33 +0000 (09:04 +0000)]
Fixed table selection query in sanitize_database().

14 years agoBetter format.
Joe Hunt [Fri, 23 Oct 2009 23:31:31 +0000 (23:31 +0000)]
Better format.

14 years agoAdded text fields sanitization on upgrdae to 2.2.
Janusz Dobrowolski [Fri, 23 Oct 2009 22:46:44 +0000 (22:46 +0000)]
Added text fields sanitization on upgrdae to 2.2.

14 years agoChanged so -1 as parameters to dimensions in get_transactions db routines only fetch...
Joe Hunt [Fri, 23 Oct 2009 22:41:48 +0000 (22:41 +0000)]
Changed so -1 as parameters to dimensions in get_transactions db routines only  fetches NO dimensions.

14 years agoFixed extension module update and deletion.
Janusz Dobrowolski [Fri, 23 Oct 2009 20:32:42 +0000 (20:32 +0000)]
Fixed extension module update and deletion.

14 years agoFixed check_table to avoid errors in log file.
Janusz Dobrowolski [Fri, 23 Oct 2009 14:22:14 +0000 (14:22 +0000)]
Fixed check_table to avoid errors in log file.

14 years agoAdditional update instructions
Joe Hunt [Fri, 23 Oct 2009 13:46:40 +0000 (13:46 +0000)]
Additional update instructions

14 years agoFixed pre_check.
Janusz Dobrowolski [Fri, 23 Oct 2009 09:50:03 +0000 (09:50 +0000)]
Fixed pre_check.

14 years agoMore sql security fixes, two issues in upgrade fixed.
Janusz Dobrowolski [Thu, 22 Oct 2009 17:14:55 +0000 (17:14 +0000)]
More sql security fixes, two issues in upgrade fixed.

14 years agoInitial value for next_extension_id added.
Janusz Dobrowolski [Thu, 22 Oct 2009 17:13:46 +0000 (17:13 +0000)]
Initial value for next_extension_id added.

14 years agoAdditional security fixes in sql statements.
Janusz Dobrowolski [Thu, 22 Oct 2009 17:11:03 +0000 (17:11 +0000)]
Additional security fixes in sql statements.

14 years agoAdded fixing special chars in refs table during upgrade.
Janusz Dobrowolski [Thu, 22 Oct 2009 17:10:17 +0000 (17:10 +0000)]
Added fixing special chars in refs table during upgrade.

14 years agoAdded initial value for $next_extension_id
Janusz Dobrowolski [Thu, 22 Oct 2009 17:08:47 +0000 (17:08 +0000)]
Added initial value for $next_extension_id

14 years agoFixed error on add/update with no tags selected.
Janusz Dobrowolski [Thu, 22 Oct 2009 12:01:34 +0000 (12:01 +0000)]
Fixed error on add/update with no tags selected.

14 years ago*** empty log message ***
Janusz Dobrowolski [Thu, 22 Oct 2009 11:47:01 +0000 (11:47 +0000)]
*** empty log message ***

14 years agoFixed double db_escape in add/update.
Janusz Dobrowolski [Thu, 22 Oct 2009 11:32:33 +0000 (11:32 +0000)]
Fixed double db_escape in add/update.

14 years agoFixed default value for systypes slector.
Janusz Dobrowolski [Thu, 22 Oct 2009 11:29:13 +0000 (11:29 +0000)]
Fixed default value for systypes slector.

14 years agoFixed double escaping on dimensions.
Janusz Dobrowolski [Thu, 22 Oct 2009 11:26:30 +0000 (11:26 +0000)]
Fixed double escaping on dimensions.

14 years agoFixed include order.
Janusz Dobrowolski [Thu, 22 Oct 2009 11:25:46 +0000 (11:25 +0000)]
Fixed include order.

14 years agoRemoved debug code.
Janusz Dobrowolski [Thu, 22 Oct 2009 11:24:46 +0000 (11:24 +0000)]
Removed debug code.

14 years agoAdded tags support, fixed bug in array_selector.
Janusz Dobrowolski [Thu, 22 Oct 2009 10:35:11 +0000 (10:35 +0000)]
Added tags support, fixed bug in array_selector.

14 years agoAdded generic tags support; tags for dimensions/gl accounts.
Janusz Dobrowolski [Thu, 22 Oct 2009 10:34:22 +0000 (10:34 +0000)]
Added generic tags support; tags for dimensions/gl accounts.

14 years agoFixed bug in default selection in array selector, added tags lists.
Janusz Dobrowolski [Thu, 22 Oct 2009 10:32:18 +0000 (10:32 +0000)]
Fixed bug in default selection in array selector, added tags lists.

14 years agoFixed help link generation and upgrade of refs table.
Janusz Dobrowolski [Wed, 21 Oct 2009 16:28:09 +0000 (16:28 +0000)]
Fixed help link generation and upgrade of refs table.

14 years agoFixed refs table upgrade to avoid duplicate record errors.
Janusz Dobrowolski [Wed, 21 Oct 2009 16:27:05 +0000 (16:27 +0000)]
Fixed refs table upgrade to avoid duplicate record errors.

14 years agoFixed help link generation.
Janusz Dobrowolski [Wed, 21 Oct 2009 16:26:22 +0000 (16:26 +0000)]
Fixed help link generation.

14 years agoA couple of new strings from upgrade...
Joe Hunt [Wed, 21 Oct 2009 14:06:11 +0000 (14:06 +0000)]
A couple of new strings from upgrade...

14 years agoEnabled a global flag in config.default.php (config.php), $show_users_online = 0.
Joe Hunt [Wed, 21 Oct 2009 13:49:43 +0000 (13:49 +0000)]
Enabled a global flag in config.default.php (config.php), $show_users_online = 0.
If this flag is set to 1 FA will show discretely the users online in the footer.

14 years agoMissing argument in pre_check call.
Janusz Dobrowolski [Wed, 21 Oct 2009 12:20:47 +0000 (12:20 +0000)]
Missing argument in pre_check call.

14 years agoAdditional fixes to upgrade scripts.
Janusz Dobrowolski [Wed, 21 Oct 2009 11:44:55 +0000 (11:44 +0000)]
Additional fixes to upgrade scripts.

14 years agoUpgrade scripts modified to be used with FA 2.1 and 2.2beta
Janusz Dobrowolski [Wed, 21 Oct 2009 11:07:16 +0000 (11:07 +0000)]
Upgrade scripts modified to be used with FA 2.1 and 2.2beta

14 years agoUpgrade script from 2.2beta to 2.2RC/final.
Janusz Dobrowolski [Wed, 21 Oct 2009 11:06:14 +0000 (11:06 +0000)]
Upgrade script from 2.2beta to 2.2RC/final.