details: /erp/erp/devel/pi/rev/ab3da41841b1
changeset: 4833:ab3da41841b1
user: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
date: Fri Aug 28 13:03:32 2009 +0200
summary: Fix issue 10265. Core enhancement to enable the posting of new
tables.
diffstat:
src-db/database/model/tables/AD_TABLE.xml | 11 +
src-db/database/sourcedata/AD_COLUMN.xml | 61 +++
src-db/database/sourcedata/AD_ELEMENT.xml | 24 +
src-db/database/sourcedata/AD_FIELD.xml | 44 ++
src-db/database/sourcedata/AD_REFERENCE.xml | 10 +
src-db/database/sourcedata/AD_REF_TABLE.xml | 13 +
src/org/openbravo/erpCommon/ad_forms/AcctServer.java | 333
++++++++++--------
src/org/openbravo/erpCommon/ad_forms/AcctServer_data.xsql | 13 +-
8 files changed, 359 insertions(+), 150 deletions(-)
diffs (truncated from 751 to 300 lines):
diff -r b837eba0d718 -r ab3da41841b1 src-db/database/model/tables/AD_TABLE.xml
--- a/src-db/database/model/tables/AD_TABLE.xml Fri Aug 28 09:11:02 2009 +0200
+++ b/src-db/database/model/tables/AD_TABLE.xml Fri Aug 28 13:03:32 2009 +0200
@@ -109,6 +109,17 @@
<default/>
<onCreateDefault/>
</column>
+ <column name="ACCTDATE_COLUMN_ID" primaryKey="false" required="false"
type="VARCHAR" size="32" autoIncrement="false">
+ <default/>
+ <onCreateDefault/>
+ </column>
+ <column name="ACCTCLASSNAME" primaryKey="false" required="false"
type="VARCHAR" size="1000" autoIncrement="false">
+ <default/>
+ <onCreateDefault/>
+ </column>
+ <foreign-key foreignTable="AD_COLUMN" name="AD_COLUMN_TABLE">
+ <reference local="ACCTDATE_COLUMN_ID" foreign="AD_COLUMN_ID"/>
+ </foreign-key>
<foreign-key foreignTable="AD_PACKAGE" name="AD_PACKAGE_TABLE">
<reference local="AD_PACKAGE_ID" foreign="AD_PACKAGE_ID"/>
</foreign-key>
diff -r b837eba0d718 -r ab3da41841b1 src-db/database/sourcedata/AD_COLUMN.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml Fri Aug 28 09:11:02 2009 +0200
+++ b/src-db/database/sourcedata/AD_COLUMN.xml Fri Aug 28 13:03:32 2009 +0200
@@ -266045,6 +266045,67 @@
<!--7079E2FD4AA7799EE040007F010104AD-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
<!--7079E2FD4AA7799EE040007F010104AD--></AD_COLUMN>
+<!--722EE1A3B4A2660EE040007F01001A37--><AD_COLUMN>
+<!--722EE1A3B4A2660EE040007F01001A37-->
<AD_COLUMN_ID><![CDATA[722EE1A3B4A2660EE040007F01001A37]]></AD_COLUMN_ID>
+<!--722EE1A3B4A2660EE040007F01001A37-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--722EE1A3B4A2660EE040007F01001A37--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--722EE1A3B4A2660EE040007F01001A37--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--722EE1A3B4A2660EE040007F01001A37-->
<NAME><![CDATA[Acctdate_Column_ID]]></NAME>
+<!--722EE1A3B4A2660EE040007F01001A37--> <HELP><![CDATA[Date reference column
where is stored the accounting date]]></HELP>
+<!--722EE1A3B4A2660EE040007F01001A37-->
<COLUMNNAME><![CDATA[Acctdate_Column_ID]]></COLUMNNAME>
+<!--722EE1A3B4A2660EE040007F01001A37-->
<AD_TABLE_ID><![CDATA[100]]></AD_TABLE_ID>
+<!--722EE1A3B4A2660EE040007F01001A37-->
<AD_REFERENCE_ID><![CDATA[18]]></AD_REFERENCE_ID>
+<!--722EE1A3B4A2660EE040007F01001A37-->
<AD_REFERENCE_VALUE_ID><![CDATA[F4175D3FED5949AAAA9C04A281E60866]]></AD_REFERENCE_VALUE_ID>
+<!--722EE1A3B4A2660EE040007F01001A37-->
<FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--722EE1A3B4A2660EE040007F01001A37--> <ISKEY><![CDATA[N]]></ISKEY>
+<!--722EE1A3B4A2660EE040007F01001A37--> <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--722EE1A3B4A2660EE040007F01001A37-->
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--722EE1A3B4A2660EE040007F01001A37-->
<ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--722EE1A3B4A2660EE040007F01001A37-->
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--722EE1A3B4A2660EE040007F01001A37--> <SEQNO><![CDATA[81]]></SEQNO>
+<!--722EE1A3B4A2660EE040007F01001A37-->
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--722EE1A3B4A2660EE040007F01001A37-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--722EE1A3B4A2660EE040007F01001A37-->
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--722EE1A3B4A2660EE040007F01001A37-->
<AD_ELEMENT_ID><![CDATA[722EE1A3B4A5660EE040007F01001A37]]></AD_ELEMENT_ID>
+<!--722EE1A3B4A2660EE040007F01001A37-->
<ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--722EE1A3B4A2660EE040007F01001A37-->
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--722EE1A3B4A2660EE040007F01001A37-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--722EE1A3B4A2660EE040007F01001A37-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--722EE1A3B4A2660EE040007F01001A37-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--722EE1A3B4A2660EE040007F01001A37--> <POSITION><![CDATA[28]]></POSITION>
+<!--722EE1A3B4A2660EE040007F01001A37-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--722EE1A3B4A2660EE040007F01001A37--></AD_COLUMN>
+
+<!--722EE1A3B4A3660EE040007F01001A37--><AD_COLUMN>
+<!--722EE1A3B4A3660EE040007F01001A37-->
<AD_COLUMN_ID><![CDATA[722EE1A3B4A3660EE040007F01001A37]]></AD_COLUMN_ID>
+<!--722EE1A3B4A3660EE040007F01001A37-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--722EE1A3B4A3660EE040007F01001A37--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--722EE1A3B4A3660EE040007F01001A37--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--722EE1A3B4A3660EE040007F01001A37--> <NAME><![CDATA[Acctclassname]]></NAME>
+<!--722EE1A3B4A3660EE040007F01001A37--> <HELP><![CDATA[Java class name where
the posting of table is developed]]></HELP>
+<!--722EE1A3B4A3660EE040007F01001A37-->
<COLUMNNAME><![CDATA[Acctclassname]]></COLUMNNAME>
+<!--722EE1A3B4A3660EE040007F01001A37-->
<AD_TABLE_ID><![CDATA[100]]></AD_TABLE_ID>
+<!--722EE1A3B4A3660EE040007F01001A37-->
<AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--722EE1A3B4A3660EE040007F01001A37-->
<FIELDLENGTH><![CDATA[1000]]></FIELDLENGTH>
+<!--722EE1A3B4A3660EE040007F01001A37--> <ISKEY><![CDATA[N]]></ISKEY>
+<!--722EE1A3B4A3660EE040007F01001A37--> <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--722EE1A3B4A3660EE040007F01001A37-->
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--722EE1A3B4A3660EE040007F01001A37-->
<ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--722EE1A3B4A3660EE040007F01001A37-->
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--722EE1A3B4A3660EE040007F01001A37--> <SEQNO><![CDATA[91]]></SEQNO>
+<!--722EE1A3B4A3660EE040007F01001A37-->
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--722EE1A3B4A3660EE040007F01001A37-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--722EE1A3B4A3660EE040007F01001A37-->
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--722EE1A3B4A3660EE040007F01001A37-->
<AD_ELEMENT_ID><![CDATA[722EE1A3B4A4660EE040007F01001A37]]></AD_ELEMENT_ID>
+<!--722EE1A3B4A3660EE040007F01001A37-->
<ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--722EE1A3B4A3660EE040007F01001A37-->
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--722EE1A3B4A3660EE040007F01001A37-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--722EE1A3B4A3660EE040007F01001A37-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--722EE1A3B4A3660EE040007F01001A37-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--722EE1A3B4A3660EE040007F01001A37--> <POSITION><![CDATA[29]]></POSITION>
+<!--722EE1A3B4A3660EE040007F01001A37-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--722EE1A3B4A3660EE040007F01001A37--></AD_COLUMN>
+
<!--7AD1D1A49C5D11DD9476001B388C05F0--><AD_COLUMN>
<!--7AD1D1A49C5D11DD9476001B388C05F0-->
<AD_COLUMN_ID><![CDATA[7AD1D1A49C5D11DD9476001B388C05F0]]></AD_COLUMN_ID>
<!--7AD1D1A49C5D11DD9476001B388C05F0-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff -r b837eba0d718 -r ab3da41841b1 src-db/database/sourcedata/AD_ELEMENT.xml
--- a/src-db/database/sourcedata/AD_ELEMENT.xml Fri Aug 28 09:11:02 2009 +0200
+++ b/src-db/database/sourcedata/AD_ELEMENT.xml Fri Aug 28 13:03:32 2009 +0200
@@ -24650,6 +24650,30 @@
<!--7079E2FD4AA8799EE040007F010104AD-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--7079E2FD4AA8799EE040007F010104AD--></AD_ELEMENT>
+<!--722EE1A3B4A4660EE040007F01001A37--><AD_ELEMENT>
+<!--722EE1A3B4A4660EE040007F01001A37-->
<AD_ELEMENT_ID><![CDATA[722EE1A3B4A4660EE040007F01001A37]]></AD_ELEMENT_ID>
+<!--722EE1A3B4A4660EE040007F01001A37-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--722EE1A3B4A4660EE040007F01001A37--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--722EE1A3B4A4660EE040007F01001A37--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--722EE1A3B4A4660EE040007F01001A37-->
<COLUMNNAME><![CDATA[Acctclassname]]></COLUMNNAME>
+<!--722EE1A3B4A4660EE040007F01001A37--> <NAME><![CDATA[Acct class
name]]></NAME>
+<!--722EE1A3B4A4660EE040007F01001A37--> <PRINTNAME><![CDATA[Acct class
name]]></PRINTNAME>
+<!--722EE1A3B4A4660EE040007F01001A37--> <HELP><![CDATA[Java class name where
the posting of table is developed]]></HELP>
+<!--722EE1A3B4A4660EE040007F01001A37-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--722EE1A3B4A4660EE040007F01001A37--></AD_ELEMENT>
+
+<!--722EE1A3B4A5660EE040007F01001A37--><AD_ELEMENT>
+<!--722EE1A3B4A5660EE040007F01001A37-->
<AD_ELEMENT_ID><![CDATA[722EE1A3B4A5660EE040007F01001A37]]></AD_ELEMENT_ID>
+<!--722EE1A3B4A5660EE040007F01001A37-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--722EE1A3B4A5660EE040007F01001A37--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--722EE1A3B4A5660EE040007F01001A37--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--722EE1A3B4A5660EE040007F01001A37-->
<COLUMNNAME><![CDATA[Acctdate_Column_ID]]></COLUMNNAME>
+<!--722EE1A3B4A5660EE040007F01001A37--> <NAME><![CDATA[Acct date
column]]></NAME>
+<!--722EE1A3B4A5660EE040007F01001A37--> <PRINTNAME><![CDATA[Acct date
column]]></PRINTNAME>
+<!--722EE1A3B4A5660EE040007F01001A37--> <HELP><![CDATA[Date reference column
where is stored the accounting date]]></HELP>
+<!--722EE1A3B4A5660EE040007F01001A37-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--722EE1A3B4A5660EE040007F01001A37--></AD_ELEMENT>
+
<!--80044AA0505611DEBC12001CC0B8EF99--><AD_ELEMENT>
<!--80044AA0505611DEBC12001CC0B8EF99-->
<AD_ELEMENT_ID><![CDATA[80044AA0505611DEBC12001CC0B8EF99]]></AD_ELEMENT_ID>
<!--80044AA0505611DEBC12001CC0B8EF99-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff -r b837eba0d718 -r ab3da41841b1 src-db/database/sourcedata/AD_FIELD.xml
--- a/src-db/database/sourcedata/AD_FIELD.xml Fri Aug 28 09:11:02 2009 +0200
+++ b/src-db/database/sourcedata/AD_FIELD.xml Fri Aug 28 13:03:32 2009 +0200
@@ -191603,6 +191603,50 @@
<!--7079E2FD4AA9799EE040007F010104AD-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--7079E2FD4AA9799EE040007F010104AD--></AD_FIELD>
+<!--7230136F97575746E040007F01001A4E--><AD_FIELD>
+<!--7230136F97575746E040007F01001A4E-->
<AD_FIELD_ID><![CDATA[7230136F97575746E040007F01001A4E]]></AD_FIELD_ID>
+<!--7230136F97575746E040007F01001A4E-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--7230136F97575746E040007F01001A4E--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--7230136F97575746E040007F01001A4E--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--7230136F97575746E040007F01001A4E--> <NAME><![CDATA[Acct class
name]]></NAME>
+<!--7230136F97575746E040007F01001A4E--> <HELP><![CDATA[Java class name where
the posting of table is developed]]></HELP>
+<!--7230136F97575746E040007F01001A4E-->
<ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--7230136F97575746E040007F01001A4E--> <AD_TAB_ID><![CDATA[100]]></AD_TAB_ID>
+<!--7230136F97575746E040007F01001A4E-->
<AD_COLUMN_ID><![CDATA[722EE1A3B4A3660EE040007F01001A37]]></AD_COLUMN_ID>
+<!--7230136F97575746E040007F01001A4E-->
<ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--7230136F97575746E040007F01001A4E-->
<DISPLAYLENGTH><![CDATA[1000]]></DISPLAYLENGTH>
+<!--7230136F97575746E040007F01001A4E--> <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--7230136F97575746E040007F01001A4E--> <SEQNO><![CDATA[210]]></SEQNO>
+<!--7230136F97575746E040007F01001A4E--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--7230136F97575746E040007F01001A4E-->
<ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--7230136F97575746E040007F01001A4E-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--7230136F97575746E040007F01001A4E-->
<SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--7230136F97575746E040007F01001A4E-->
<ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--7230136F97575746E040007F01001A4E-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--7230136F97575746E040007F01001A4E--></AD_FIELD>
+
+<!--7230136F97585746E040007F01001A4E--><AD_FIELD>
+<!--7230136F97585746E040007F01001A4E-->
<AD_FIELD_ID><![CDATA[7230136F97585746E040007F01001A4E]]></AD_FIELD_ID>
+<!--7230136F97585746E040007F01001A4E-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--7230136F97585746E040007F01001A4E--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--7230136F97585746E040007F01001A4E--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--7230136F97585746E040007F01001A4E--> <NAME><![CDATA[Acct date
column]]></NAME>
+<!--7230136F97585746E040007F01001A4E--> <HELP><![CDATA[Date reference column
where is stored the accounting date]]></HELP>
+<!--7230136F97585746E040007F01001A4E-->
<ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--7230136F97585746E040007F01001A4E--> <AD_TAB_ID><![CDATA[100]]></AD_TAB_ID>
+<!--7230136F97585746E040007F01001A4E-->
<AD_COLUMN_ID><![CDATA[722EE1A3B4A2660EE040007F01001A37]]></AD_COLUMN_ID>
+<!--7230136F97585746E040007F01001A4E-->
<ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--7230136F97585746E040007F01001A4E-->
<DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
+<!--7230136F97585746E040007F01001A4E--> <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--7230136F97585746E040007F01001A4E--> <SEQNO><![CDATA[200]]></SEQNO>
+<!--7230136F97585746E040007F01001A4E--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--7230136F97585746E040007F01001A4E-->
<ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--7230136F97585746E040007F01001A4E-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--7230136F97585746E040007F01001A4E-->
<SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--7230136F97585746E040007F01001A4E-->
<ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--7230136F97585746E040007F01001A4E-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--7230136F97585746E040007F01001A4E--></AD_FIELD>
+
<!--739F4C68F44B11DD9B7A0016D4EE9DB3--><AD_FIELD>
<!--739F4C68F44B11DD9B7A0016D4EE9DB3-->
<AD_FIELD_ID><![CDATA[739F4C68F44B11DD9B7A0016D4EE9DB3]]></AD_FIELD_ID>
<!--739F4C68F44B11DD9B7A0016D4EE9DB3-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff -r b837eba0d718 -r ab3da41841b1 src-db/database/sourcedata/AD_REFERENCE.xml
--- a/src-db/database/sourcedata/AD_REFERENCE.xml Fri Aug 28 09:11:02
2009 +0200
+++ b/src-db/database/sourcedata/AD_REFERENCE.xml Fri Aug 28 13:03:32
2009 +0200
@@ -3555,6 +3555,16 @@
<!--F19E4A390AAB4A02B3D3CC944F091598-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--F19E4A390AAB4A02B3D3CC944F091598--></AD_REFERENCE>
+<!--F4175D3FED5949AAAA9C04A281E60866--><AD_REFERENCE>
+<!--F4175D3FED5949AAAA9C04A281E60866-->
<AD_REFERENCE_ID><![CDATA[F4175D3FED5949AAAA9C04A281E60866]]></AD_REFERENCE_ID>
+<!--F4175D3FED5949AAAA9C04A281E60866-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--F4175D3FED5949AAAA9C04A281E60866--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--F4175D3FED5949AAAA9C04A281E60866--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--F4175D3FED5949AAAA9C04A281E60866--> <NAME><![CDATA[AD_Column date
column]]></NAME>
+<!--F4175D3FED5949AAAA9C04A281E60866-->
<VALIDATIONTYPE><![CDATA[T]]></VALIDATIONTYPE>
+<!--F4175D3FED5949AAAA9C04A281E60866-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--F4175D3FED5949AAAA9C04A281E60866--></AD_REFERENCE>
+
<!--F909D710BC084C92BC740A4FD498C99D--><AD_REFERENCE>
<!--F909D710BC084C92BC740A4FD498C99D-->
<AD_REFERENCE_ID><![CDATA[F909D710BC084C92BC740A4FD498C99D]]></AD_REFERENCE_ID>
<!--F909D710BC084C92BC740A4FD498C99D-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff -r b837eba0d718 -r ab3da41841b1 src-db/database/sourcedata/AD_REF_TABLE.xml
--- a/src-db/database/sourcedata/AD_REF_TABLE.xml Fri Aug 28 09:11:02
2009 +0200
+++ b/src-db/database/sourcedata/AD_REF_TABLE.xml Fri Aug 28 13:03:32
2009 +0200
@@ -1167,4 +1167,17 @@
<!--DE78D015D6AD4F9E8DB9A120C6227FF7-->
<ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
<!--DE78D015D6AD4F9E8DB9A120C6227FF7--></AD_REF_TABLE>
+<!--F4175D3FED5949AAAA9C04A281E60866--><AD_REF_TABLE>
+<!--F4175D3FED5949AAAA9C04A281E60866-->
<AD_REFERENCE_ID><![CDATA[F4175D3FED5949AAAA9C04A281E60866]]></AD_REFERENCE_ID>
+<!--F4175D3FED5949AAAA9C04A281E60866-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--F4175D3FED5949AAAA9C04A281E60866--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--F4175D3FED5949AAAA9C04A281E60866--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--F4175D3FED5949AAAA9C04A281E60866-->
<AD_TABLE_ID><![CDATA[101]]></AD_TABLE_ID>
+<!--F4175D3FED5949AAAA9C04A281E60866--> <AD_KEY><![CDATA[109]]></AD_KEY>
+<!--F4175D3FED5949AAAA9C04A281E60866-->
<AD_DISPLAY><![CDATA[116]]></AD_DISPLAY>
+<!--F4175D3FED5949AAAA9C04A281E60866-->
<ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
+<!--F4175D3FED5949AAAA9C04A281E60866-->
<WHERECLAUSE><![CDATA[AD_Column.AD_Reference_ID IN ('16', '15') AND
ad_column.ad_table_...@ad_table_id@]]></WHERECLAUSE>
+<!--F4175D3FED5949AAAA9C04A281E60866-->
<ORDERBYCLAUSE><![CDATA[AD_Column.Columnname]]></ORDERBYCLAUSE>
+<!--F4175D3FED5949AAAA9C04A281E60866--></AD_REF_TABLE>
+
</data>
diff -r b837eba0d718 -r ab3da41841b1
src/org/openbravo/erpCommon/ad_forms/AcctServer.java
--- a/src/org/openbravo/erpCommon/ad_forms/AcctServer.java Fri Aug 28
09:11:02 2009 +0200
+++ b/src/org/openbravo/erpCommon/ad_forms/AcctServer.java Fri Aug 28
13:03:32 2009 +0200
@@ -236,7 +236,7 @@
/**
* Cosntructor
- *
+ *
* @param m_AD_Client_ID
* Client ID of these Documents
* @param connectionProvider
@@ -291,7 +291,7 @@
/**
* Factory - Create Posting document
- *
+ *
* @param AD_Table_ID
* Table ID of Documents
* @param AD_Client_ID
@@ -305,108 +305,129 @@
AcctServer acct = null;
if (log4j.isDebugEnabled())
log4j.debug("get - table: " + AD_Table_ID);
- switch (Integer.parseInt(AD_Table_ID)) {
- case 318:
- acct = new DocInvoice(AD_Client_ID, AD_Org_ID, connectionProvider);
- acct.tableName = "C_Invoice";
- acct.AD_Table_ID = "318";
- acct.strDateColumn = "DateAcct";
- acct.reloadAcctSchemaArray();
- acct.groupLines =
AcctServerData.selectGroupLines(acct.connectionProvider, AD_Client_ID);
- break;
- /*
- * case 390: acct = new DocAllocation (AD_Client_ID); acct.strDateColumn =
""; acct.AD_Table_ID
- * = "390"; acct.reloadAcctSchemaArray(); acct.break;
- */
- case 800060:
- acct = new DocAmortization(AD_Client_ID, AD_Org_ID, connectionProvider);
- acct.tableName = "A_Amortization";
- acct.AD_Table_ID = "800060";
- acct.strDateColumn = "DateAcct";
- acct.reloadAcctSchemaArray();
- break;
+ if (AD_Table_ID.equals("318") || AD_Table_ID.equals("800060") ||
AD_Table_ID.equals("800176")
+ || AD_Table_ID.equals("407") || AD_Table_ID.equals("392") ||
AD_Table_ID.equals("259")
+ || AD_Table_ID.equals("800019") || AD_Table_ID.equals("319") ||
AD_Table_ID.equals("321")
+ || AD_Table_ID.equals("323") || AD_Table_ID.equals("325") ||
AD_Table_ID.equals("224")) {
+ switch (Integer.parseInt(AD_Table_ID)) {
+ case 318:
+ acct = new DocInvoice(AD_Client_ID, AD_Org_ID, connectionProvider);
+ acct.tableName = "C_Invoice";
+ acct.AD_Table_ID = "318";
+ acct.strDateColumn = "DateAcct";
+ acct.reloadAcctSchemaArray();
+ acct.groupLines =
AcctServerData.selectGroupLines(acct.connectionProvider, AD_Client_ID);
+ break;
+ /*
+ * case 390: acct = new DocAllocation (AD_Client_ID); acct.strDateColumn
= "";
+ * acct.AD_Table_ID = "390"; acct.reloadAcctSchemaArray(); acct.break;
+ */
+ case 800060:
+ acct = new DocAmortization(AD_Client_ID, AD_Org_ID,
connectionProvider);
+ acct.tableName = "A_Amortization";
+ acct.AD_Table_ID = "800060";
+ acct.strDateColumn = "DateAcct";
+ acct.reloadAcctSchemaArray();
+ break;
- case 800176:
- if (log4j.isDebugEnabled())
- log4j.debug("AcctServer - Get DPM");
- acct = new DocDPManagement(AD_Client_ID, AD_Org_ID, connectionProvider);
- acct.tableName = "C_DP_Management";
- acct.AD_Table_ID = "800176";
- acct.strDateColumn = "DateAcct";
- acct.reloadAcctSchemaArray();
- break;
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
