Index: openacs-4/packages/accounts-desk/accounts-desk.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/accounts-desk/accounts-desk.info,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/accounts-desk/accounts-desk.info 3 Jul 2006 19:11:48 -0000 1.1
@@ -0,0 +1,28 @@
+
+
+
+
+ Accounts Desk
+ Accounts Desks
+ f
+ f
+
+
+ Torben Brosten
+ OpenACS community
+ A revised port of sql-ledger for OpenACS
+ Dekka Corp of Oregon
+ Accounts Desk is based on a port of sql-ledger, taking advantage of the many features that are available with the OpenACS toolkit
+ 0
+
+
+
+
+
+
+
+
+
+
+
+
Index: openacs-4/packages/accounts-desk/sql/postgresql/accounts-desk-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/accounts-desk/sql/postgresql/accounts-desk-create.sql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/accounts-desk/sql/postgresql/accounts-desk-create.sql 3 Jul 2006 19:11:49 -0000 1.1
@@ -0,0 +1,42 @@
+-- accounts-desk-create.sql
+--
+-- @porting by Dekka Corp.
+-- @copyright Copyright (c) 1999 - 2005, DWS Systems Inc.
+-- @license GNU GENERAL PUBLIC LICENSE, Version 2, June 1991
+-- @cvs-id
+
+
+
+CREATE FUNCTION qad_avgcost(int) RETURNS FLOAT AS '
+
+DECLARE
+
+v_cost float;
+v_qty float;
+v_parts_id alias for $1;
+
+BEGIN
+
+ SELECT INTO v_cost, v_qty SUM(i.sellprice * i.qty), SUM(i.qty)
+ FROM qar_invoice i
+ JOIN qap_ap a ON (a.id = i.trans_id)
+ WHERE i.parts_id = v_parts_id;
+
+ IF NOT v_qty IS NULL THEN
+ v_cost := v_cost/v_qty;
+ END IF;
+
+ IF v_cost IS NULL THEN
+ v_cost := 0;
+ END IF;
+
+RETURN v_cost;
+
+END;
+' language 'plpgsql';
+-- end function
+
+
+-- following requires both AR and AP packages installed
+
+CREATE TRIGGER qar_del_recurring AFTER DELETE ON qap_ap FOR EACH ROW EXECUTE PROCEDURE qar_del_recurring();
Index: openacs-4/packages/accounts-desk/sql/postgresql/accounts-desk-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/accounts-desk/sql/postgresql/accounts-desk-drop.sql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/accounts-desk/sql/postgresql/accounts-desk-drop.sql 3 Jul 2006 19:11:49 -0000 1.1
@@ -0,0 +1,9 @@
+-- accounts-desk-drop.sql
+--
+-- @porting by Dekka Corp.
+-- @copyright Copyright (c) 1999 - 2005, DWS Systems Inc.
+-- @license GNU GENERAL PUBLIC LICENSE, Version 2, June 1991
+-- @cvs-id
+
+
+drop function qad_avgcost();
Index: openacs-4/packages/accounts-finance/accounts-finance.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/accounts-finance/accounts-finance.info,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/accounts-finance/accounts-finance.info 3 Jul 2006 19:20:10 -0000 1.1
@@ -0,0 +1,27 @@
+
+
+
+
+ Finance
+ Finances
+ f
+ f
+
+
+ Torben Brosten
+ OpenACS community
+ Finance package provides limited set of tools for long-term debts, fixed assets, forecasting.
+ Dekka Corp of Oregon
+ Finance package provides some tools for long-term debts, fixed assets, capital, stock holding, dividends, forecasting and reporting. Integrates with general-ledger etc.
+ 0
+
+
+
+
+
+
+
+
+
+
+
Index: openacs-4/packages/accounts-finance/www/doc/index.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/accounts-finance/www/doc/index.adp,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/accounts-finance/www/doc/index.adp 3 Jul 2006 19:20:11 -0000 1.1
@@ -0,0 +1,4 @@
+
+
+will be porting in sql-ledger RP.pm and rp.pl
+