Nofile Routine to get total balance from all account of selected customer using ENQUIRY
Last updated: 2023-11-16
Nofile Routine to get total balance from all account of selected customer using ENQUIRY
package com.temenos.t24;
import java.util.ArrayList;
import java.util.List;
import com.temenos.api.TStructure;
import com.temenos.api.exceptions.T24CoreException;
import com.temenos.t24.api.complex.eb.enquiryhook.EnquiryContext;
import com.temenos.t24.api.complex.eb.enquiryhook.FilterCriteria;
import com.temenos.t24.api.hook.system.Enquiry;
import com.temenos.t24.api.party.Customer;
import com.temenos.t24.api.records.account.AccountRecord;
import com.temenos.t24.api.system.DataAccess;
/**
* @author Danish The Techie
*/
public class NoFileEnquiryDemo extends Enquiry {
@Override
public List<String> setIds(List<FilterCriteria> filterCriteria, EnquiryContext enquiryContext) {
Customer cusrec = new Customer(this);
DataAccess da = new DataAccess(this);
//filter criteria
String s1 = filterCriteria.get(0).getFieldname();
String s3 = filterCriteria.get(0).getValue();
List<String> retId = new ArrayList<String>();
Double consAmt = 0.0;
if(s1.equals("CUSTOMER")){
if(!s3.equals("")){
cusrec.setCustomerId(s3);
List<String> accNum = null;
try{
accNum = cusrec.getAccountNumbers();
for(String acNum : accNum){
AccountRecord ar = new AccountRecord(da.getRecord("ACCOUNT", acNum));
String amt = ar.getWorkingBalance().getValue();
if(amt.isEmpty() || amt.equals("")){
continue;
}else{
double amt1 = Double.valueOf(amt);
consAmt += amt1;
}
}
}catch(Exception e){
throw new T24CoreException("",e.getMessage());
}
retId.add(Double.toString(consAmt));
}
}
return retId;
}
}