Versions Compared

Version Old Version 9 New Version 10
Changes made by

Adam Chang

Adam Chang

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustom();

System.out.println("\n=======================================isValidKFSSubObjects()================================");
List<SubObjectValidation> resultList22 = myBean.isValidKFSSubObjects(new String[][] {{"2012","IR","1000211","4400","BRM1"},{"2012","IR","1000211","4400","ITM1"},{"2012","IR","1000211","0000","XXXX"}});
if (resultList22 != null) {
	for (Iterator i = resultList22.iterator(); i.hasNext();) {
		SubObjectValidation element = (SubObjectValidation)i.next();
		System.out.println("SERVER UNIT TEST-Result List22: " + element.toString());
	}
} else {
	System.out.println("something bad happened...please check your query");
}

 

getValidKFSSubObjects

Input Specifications

IndexParameterDescriptionRequired?Data Type (max length)Example
0kfsFiscalYearKFS Fiscal Year (e.g. 2013)YesString (4) 
1kfsChartCodeKFS Chart CodeYesString (2) 
2kfsAcctNumberKFS Account NumberYesString (7)'1234567'
3kfsObjectCodeKFS Object CodeYesString (4) 
4kfsSubObjectCodeKFS SubObject CodeYesString (4) 

DB Query

Code Block
SELECT 
CONVERT(varchar(4), a.univ_fiscal_yr) AS UNIV_FISCAL_YR,
a.fin_coa_cd, 
a.account_nbr, 
a.fin_object_cd, 
b.fin_obj_cd_nm, 
a.fin_sub_obj_cd, 
a.fin_sub_obj_cd_nm 
FROM CA_SUB_OBJECT_CD_T a, CA_OBJECT_CODE_T b 
WHERE a.fin_object_cd = b.fin_object_cd AND a.FIN_SUBOBJ_ACTV_CD <> 'N' AND
(
 (a.univ_fiscal_yr = '2012' AND 
  a.fin_coa_cd='IR' AND 
  a.account_nbr='1000211' AND 
  a.fin_object_cd = '4400' AND 
  a.fin_sub_obj_cd = 'BRM1') OR 
 (a.univ_fiscal_yr = '2012' AND 
  a.fin_coa_cd='IR' AND 
  a.account_nbr='1000211' AND 
  a.fin_object_cd = '4400' AND 
nWSClient-isValidKFSSubObjects()");
StringArray sa220 = new StringArray();
sa220.getItem().add("2012");
sa220.getItem().add("IR");
sa220.getItem().add("1000211");
sa220.getItem().add("4400");
sa220.getItem().add("BRM1");
StringArray sa221 = new StringArray();
sa221.getItem().add("2012");
sa221.getItem().add("IR");
sa221.getItem().add("1000211");
sa221.getItem().add("4400");
sa221.getItem().add("ITM1");
StringArray sa222 = new StringArray();
sa221.getItem().add("2012");
sa221.getItem().add("IR");
sa221.getItem().add("1000211");
sa221.getItem().add("0000");
sa221.getItem().add("XXXX");
List<SubObjectValidation> resultList22 = ds.isValidKFSSubObjects(Arrays.asList(sa220, sa221, sa222));
if (resultList22 != null) {
	for (Iterator i = resultList22.iterator(); i.hasNext();) {
		SubObjectValidation element = (SubObjectValidation)i.next();
		System.out.println("\t" + element.getKfsFiscalYear() + "/" + element.getKfsChartCode() + "/" + element.getKfsAcctNumber() + "/" + element.getKfsObjCode() + "/" + element.getKfsSubObjCode() + " : " + element.isValid());
	}
} else {
	System.out.println("something bad happened...please check your query");
}

 

...

getValidKFSSubObjects

Input Specifications

IndexParameterDescriptionRequired?Data Type (max length)Example
0kfsFiscalYearKFS Fiscal Year (e.g. 2013)YesString (4) 
1kfsChartCodeKFS Chart CodeYesString (2) 
2kfsAcctNumberKFS Account NumberYesString (7)'1234567'
3kfsObjectCodeKFS Object CodeYesString (4) 
4kfsSubObjectCodeKFS SubObject CodeYesString (4) 

DB Query

Code Block
SELECT 
CONVERT(varchar(4), a.univ_fiscal_yr) AS UNIV_FISCAL_YR,
a.fin_coa_cd, 
a.account_nbr, 
a.fin_object_cd, 
b.fin_obj_cd_nm, 
a.fin_sub_obj_cd = 'ITM1') OR
 (, 
a.univfin_fiscal_yr = '2012' AND
  a.fin_coa_cd='IR' AND 
  a.account_nbr='1000211' AND 
  asub_obj_cd_nm 
FROM CA_SUB_OBJECT_CD_T a, CA_OBJECT_CODE_T b 
WHERE a.fin_object_cd = b.fin_object_cd = '0000AND a.FIN_SUBOBJ_ACTV_CD <> 'N' AND
(
 (a.univ_fiscal_yr = '2012' AND 
  a.fin_sub_objcoa_cd='IR' AND 
  a.account_nbr= 'XXXX1000211')
);

Result Schema: A list of following elements (SubObjectDetails.java)

DB ParameterJava ParameterDescriptionData Type 
UNIV_FISCAL_YR
kfsFiscalYearKFS Fiscal YearString (4)2012
FIN_COA_CD
kfsChartCodeKFS Chart CodeString (2)'IR'
ACCOUNT_NBM
kfsAcctNumberKFS Account NumberString (7)

'1234567'

FIN_OBJECT_CD
kfsObjCodeKFS Object CodeString (4)'CASH'
FIN_OBJ_CD_NM
kfsObjCodeNameKFS Object Code NameString (40) 
FIN_SUB_OBJ_CD
kfsSubObjCodeKFS SubObject CodeString (4)'CASH'
FIN_SUB_OBJ_CD_NM
kfsSubObjCodeNameKFS SubObject Code NameString (40) 

WS Example

Request
Code Block
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
   <soapenv:Header/>
   <soapenv:Body>
      <adc:getValidKFSSubObjects>
         <kfsSubObjectList>
            <item>2012</item> AND 
  a.fin_object_cd = '4400' AND 
  a.fin_sub_obj_cd = 'BRM1') OR 
 (a.univ_fiscal_yr = '2012' AND 
  a.fin_coa_cd='IR' AND 
  a.account_nbr='1000211' AND 
  a.fin_object_cd = '4400' AND 
  a.fin_sub_obj_cd = 'ITM1') OR
 (a.univ_fiscal_yr = '2012' AND
  a.fin_coa_cd='IR' AND 
  a.account_nbr='1000211' AND 
  a.fin_object_cd = '0000' AND 
  a.fin_sub_obj_cd = 'XXXX')
);

Result Schema: A list of following elements (SubObjectDetails.java)

DB ParameterJava ParameterDescriptionData Type 
UNIV_FISCAL_YR
kfsFiscalYearKFS Fiscal YearString (4)2012
FIN_COA_CD
kfsChartCodeKFS Chart CodeString (2)'IR'
ACCOUNT_NBM
kfsAcctNumberKFS Account NumberString (7)

'1234567'

FIN_OBJECT_CD
kfsObjCodeKFS Object CodeString (4)'CASH'
FIN_OBJ_CD_NM
kfsObjCodeNameKFS Object Code NameString (40) 
FIN_SUB_OBJ_CD
kfsSubObjCodeKFS SubObject CodeString (4)'CASH'
FIN_SUB_OBJ_CD_NM
kfsSubObjCodeNameKFS SubObject Code NameString (40) 

WS Example

Request
Code Block
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
   <soapenv:Header/>
   <soapenv:Body>
      <adc:getValidKFSSubObjects>
         <kfsSubObjectList>
            <item>2012</item>
            <item>IR</item>
            <item>1000211</item>
            <item>4400</item>
            <item>BRM1</item>
         </kfsSubObjectList>
         <kfsSubObjectList>
            <item>2012</item>
            <item>IR</item>
            <item>1000211</item>
            <item>4400</item>
            <item>ITM1</item>
         </kfsSubObjectList>
         <kfsSubObjectList>
            <item>2012</item>
            <item>IR</item>
            <item>1000211</item>
            <item>0000</item>
            <item>XXXX</item>
         </kfsSubObjectList>      
      </adc:getValidKFSSubObjects>
   </soapenv:Body>
</soapenv:Envelope>

...

Code Block
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:getValidKFSSubObjectsResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <kfsAcctNumber>1000211</kfsAcctNumber>
            <kfsChartCode>IR</kfsChartCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsObjCode>4400</kfsObjCode>
            <kfsObjCodeName>METERED MAIL</kfsObjCodeName>
            <kfsSubObjCode>BRM1</kfsSubObjCode>
            <kfsSubObjCodeName>BUSINESS REPLY MAIL</kfsSubObjCodeName>
         </return>
         <return>
            <kfsAcctNumber>1000211</kfsAcctNumber>
            <kfsChartCode>IR</kfsChartCode>
            <kfsFiscalYear>2012</kfsFiscalYear>
            <kfsObjCode>4400</kfsObjCode>
            <kfsObjCodeName>METERED MAIL</kfsObjCodeName>
            <kfsSubObjCode>ITM1</kfsSubObjCode>
            <kfsSubObjCode>ITM1</kfsSubObjCode><kfsSubObjCodeName>INTERNATIONAL MAIL</kfsSubObjCodeName>
         </return>
      </ns2:getValidKFSSubObjectsResponse>
   </soap:Body>
 <kfsSubObjCodeName>INTERNATIONAL MAIL</kfsSubObjCodeName>
         </return>
      </ns2:getValidKFSSubObjectsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block
DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustom();

System.out.println("\n=======================================getValidKFSSubObjects()================================");
List<SubObjectDetails> resultList23 = myBean.getValidKFSSubObjects(new String[][]{{"2012","IR","1000211","4400","BRM1"},{"2012","IR","1000211","4400","ITM1"},{"2012","IR","1000211","0000","XXXX"}});
if (resultList23 != null) {
	for (Iterator i = resultList23.iterator(); i.hasNext();) {
		SubObjectDetails element = (SubObjectDetails)i.next();
		System.out.println("SERVER UNIT TEST-Result List23</soap:Envelope>

Java Client Example

Code Block
DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustom();

System.out.println("\nWSClient-getValidKFSSubObjects()");
StringArray sa230 = new StringArray();
sa230.getItem().add("2012");
sa230.getItem().add("IR");
sa230.getItem().add("1000211");
sa230.getItem().add("4400");
sa230.getItem().add("BRM1");
StringArray sa231 = new StringArray();
sa231.getItem().add("2012");
sa231.getItem().add("IR");
sa231.getItem().add("1000211");
sa231.getItem().add("4400");
sa231.getItem().add("ITM1");
StringArray sa232 = new StringArray();
sa232.getItem().add("2012");
sa232.getItem().add("IR");
sa232.getItem().add("1000211");
sa232.getItem().add("0000");
sa232.getItem().add("XXXX");
List<SubObjectDetails> resultList23 = ds.getValidKFSSubObjects(Arrays.asList(sa230, sa231, sa232));
if (resultList23 != null) {
	for (Iterator i = resultList23.iterator(); i.hasNext();) {
		SubObjectDetails element = (SubObjectDetails)i.next();
		System.out.println("\t" + element.getKfsFiscalYear() + "/" + element.getKfsChartCode() + "/" + element.getKfsAcctNumber() + "/" + element.getKfsObjCode() + "/" + element.getKfsSubObjCode() + " : " + element.toStringgetKfsSubObjCodeName());
	}
} else {
	System.out.println("something bad happened...please check your query");
}

...