// ----------------------------------------------------------------------------
public String ToHtml(HttpSession Sess) {
String CadHtml = " <ul class=\"Showed\">";
for (int i = 0; i < ListRows.size(); i++) {
CadHtml += ((Branch) ListRows.get(i)).HtmlPropio("RefreshDocs", "MainFrame");
}
return (CadHtml + "</ul>");
}
public void removePhaseListener(PhaseListener listener) {
if (listener == null) throw new NullPointerException();
synchronized (_phaseList) {
_phaseList.remove(listener);
_phaseListeners = new PhaseListener[_phaseList.size()];
_phaseList.toArray(_phaseListeners);
}
}
static void returnOembed(HttpServletRequest request, HttpServletResponse response)
throws Exception {
String url = request.getParameter("url");
if (url == null) throw new Exception("No subject URL found.");
String retUrl = request.getParameter(S3Servlet.URL_PARAM);
if (retUrl == null && !S3Servlet.testing)
throw new Exception("Recieved no launch presentation return url");
Enumeration<String> en = request.getParameterNames();
ArrayList<String> keys = new ArrayList<String>(), vals = new ArrayList<String>();
String key, value;
while (en.hasMoreElements()) {
key = en.nextElement();
if ("action".equals(key)) continue;
if ("launch_presentation_return_url".equals(key)) continue;
if ("url".equals(key)) continue;
if ((value = request.getParameter(key)) != null) {
keys.add(key);
vals.add(value);
} // if//
} // while//
String endpoint =
S3Servlet.makeUrl(
S3Servlet.server + S3Servlet.prefix + "/" + S3Action.oembed,
keys.toArray(new String[keys.size()]),
vals.toArray(new String[vals.size()]));
String oembedUrl =
S3Servlet.makeUrl(
retUrl,
new String[] {"embed_type", "endpoint", "url"},
new String[] {"oembed", endpoint, url});
response.reset();
response.sendRedirect(oembedUrl);
} // returnOembed//
/** Business logic to execute. */
public final Response executeCommand(
Object inputPar,
UserSessionParameters userSessionPars,
HttpServletRequest request,
HttpServletResponse response,
HttpSession userSession,
ServletContext context) {
String serverLanguageId = ((JAIOUserSessionParameters) userSessionPars).getServerLanguageId();
Connection conn = null;
PreparedStatement pstmt = null;
try {
conn = ConnectionManager.getConnection(context);
// fires the GenericEvent.CONNECTION_CREATED event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.CONNECTION_CREATED,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
null));
ArrayList oldVOs = ((ArrayList[]) inputPar)[0];
ArrayList newVOs = ((ArrayList[]) inputPar)[1];
RoleFunctionCompanyVO oldVO = null;
RoleFunctionCompanyVO newVO = null;
Response res = null;
for (int i = 0; i < oldVOs.size(); i++) {
oldVO = (RoleFunctionCompanyVO) oldVOs.get(i);
newVO = (RoleFunctionCompanyVO) newVOs.get(i);
if (!oldVO.getCanView().booleanValue()) {
// no record in SYS02 yet...
if (newVO.getCanView().booleanValue()) {
pstmt =
conn.prepareStatement(
"insert into SYS02_COMPANIES_ACCESS(PROGRESSIVE_SYS04,FUNCTION_CODE_SYS06,CAN_INS,CAN_UPD,CAN_DEL,COMPANY_CODE_SYS01) "
+ "values(?,?,?,?,?,?)");
pstmt.setBigDecimal(1, newVO.getProgressiveSys04SYS02());
pstmt.setString(2, newVO.getFunctionCodeSys06SYS02());
pstmt.setString(3, newVO.getCanInsSYS02().booleanValue() ? "Y" : "N");
pstmt.setString(4, newVO.getCanUpdSYS02().booleanValue() ? "Y" : "N");
pstmt.setString(5, newVO.getCanDelSYS02().booleanValue() ? "Y" : "N");
pstmt.setString(6, newVO.getCompanyCodeSys01SYS02());
pstmt.execute();
}
} else {
// record already exists in SYS02...
if (newVO.getCanView().booleanValue()) {
// record in SYS02 will be updated...
pstmt =
conn.prepareStatement(
"update SYS02_COMPANIES_ACCESS set CAN_INS=?,CAN_UPD=?,CAN_DEL=? where "
+ "PROGRESSIVE_SYS04=? and FUNCTION_CODE_SYS06=? and COMPANY_CODE_SYS01=? ");
pstmt.setString(1, newVO.getCanInsSYS02().booleanValue() ? "Y" : "N");
pstmt.setString(2, newVO.getCanUpdSYS02().booleanValue() ? "Y" : "N");
pstmt.setString(3, newVO.getCanDelSYS02().booleanValue() ? "Y" : "N");
pstmt.setBigDecimal(4, newVO.getProgressiveSys04SYS02());
pstmt.setString(5, newVO.getFunctionCodeSys06SYS02());
pstmt.setString(6, newVO.getCompanyCodeSys01SYS02());
pstmt.execute();
} else {
// delete record from SYS02...
pstmt =
conn.prepareStatement(
"delete from SYS02_COMPANIES_ACCESS where PROGRESSIVE_SYS04=? and FUNCTION_CODE_SYS06=? and COMPANY_CODE_SYS01=?");
pstmt.setBigDecimal(1, newVO.getProgressiveSys04SYS02());
pstmt.setString(2, newVO.getFunctionCodeSys06SYS02());
pstmt.setString(3, newVO.getCompanyCodeSys01SYS02());
pstmt.execute();
}
}
}
Response answer = new VOListResponse(newVOs, false, newVOs.size());
// fires the GenericEvent.BEFORE_COMMIT event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.BEFORE_COMMIT,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
answer));
conn.commit();
// fires the GenericEvent.AFTER_COMMIT event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.AFTER_COMMIT,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
answer));
return answer;
} catch (Throwable ex) {
Logger.error(
userSessionPars.getUsername(),
this.getClass().getName(),
"executeCommand",
"Error while updating company-role-function settings",
ex);
try {
pstmt.close();
} catch (Exception ex2) {
}
try {
conn.rollback();
} catch (Exception ex3) {
}
return new ErrorResponse(ex.getMessage());
} finally {
try {
ConnectionManager.releaseConnection(conn, context);
} catch (Exception ex1) {
}
}
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<br><h4>we are getting data</h4>");
String code = request.getParameter("code");
out.println("<br>code: " + code);
out.println("<br>");
try {
OAuthClientRequest requestOAuth =
OAuthClientRequest.tokenLocation("https://graph.facebook.com/oauth/access_token")
.setGrantType(GrantType.AUTHORIZATION_CODE)
.setClientId(apiKey)
.setClientSecret(secretKey)
.setRedirectURI(redirectUri)
.setCode(code)
.buildBodyMessage();
OAuthClient oAuthClient = new OAuthClient(new URLConnectionClient());
GitHubTokenResponse oAuthResponse =
oAuthClient.accessToken(requestOAuth, GitHubTokenResponse.class);
accessToken = oAuthResponse.getAccessToken();
expiresIn = oAuthResponse.getExpiresIn();
} catch (OAuthSystemException ae) {
ae.printStackTrace();
} catch (OAuthProblemException pe) {
pe.printStackTrace();
}
// out.println("<br>Access Token: " + accessToken);
// out.println("<br>Expires In: " + expiresIn);
try {
FacebookClient facebookClient = new DefaultFacebookClient(accessToken);
myFriends = facebookClient.fetchConnection("me/friends", User.class);
myFeeds = facebookClient.fetchConnection("me/home", Post.class);
for (User myFriend : myFriends.getData()) {
f.add(myFriend.getName());
out.println("<br>id: " + myFriend.getId() + " Name: " + myFriend.getName());
}
// out.println("<br>");
out.println("<br>f count: " + f.size());
} catch (FacebookException e) {
e.printStackTrace();
}
facebookDataBean fdb = new facebookDataBean();
fdb.setName("zishan ali khan");
HttpSession session = request.getSession();
if (session != null) {
session.setAttribute("myfdb", fdb);
session.setAttribute("yourFriends", f);
session.setAttribute("feeds", myFeeds);
RequestDispatcher view = request.getRequestDispatcher("result.jsp");
view.forward(request, response);
f.clear();
// out.println("<br>I am in");
} else {
// out.println("<br>Session Over");
}
}
/**
* Check if components required by specified products are available.
*
* @param products list of ProdOrderProductVO objects
* @params compAltComps collection of <component item code,HashSet of alternative component item
* codes>; filled by this method (and given back by reference)
* @return VOListResponse of ProdOrderComponentVO objects
*/
public final Response checkComponentsAvailability(
Connection conn,
Hashtable compAltComps,
ArrayList products,
UserSessionParameters userSessionPars,
HttpServletRequest request,
HttpServletResponse response,
HttpSession userSession,
ServletContext context) {
String serverLanguageId = ((JAIOUserSessionParameters) userSessionPars).getServerLanguageId();
try {
// retrieve internationalization settings (Resources object)...
ServerResourcesFactory factory =
(ServerResourcesFactory) context.getAttribute(Controller.RESOURCES_FACTORY);
Resources resources = factory.getResources(userSessionPars.getLanguageId());
if (products.size() == 0) {
return new VOListResponse(new ArrayList(), false, 0);
}
// fill in comps hashtable with the collection of required components...
ItemPK pk = null;
ProdOrderProductVO prodVO = null;
ArrayList components = null;
MaterialVO compVO = null;
Response res = null;
ProdOrderComponentVO componentVO = null;
Hashtable comps =
new Hashtable(); // collection of <component item code,ProdOrderComponentVO object>
for (int i = 0; i < products.size(); i++) {
// retrieve bill of materials for each product...
prodVO = (ProdOrderProductVO) products.get(i);
pk = new ItemPK(prodVO.getCompanyCodeSys01DOC23(), prodVO.getItemCodeItm01DOC23());
res =
bean.getBillOfMaterials(
conn, pk, userSessionPars, request, response, userSession, context);
if (res.isError()) {
return res;
}
// extract components only (leaf nodes)...
components =
getComponents(
(DefaultMutableTreeNode) ((TreeModel) ((VOResponse) res).getVo()).getRoot());
for (int j = 0; j < components.size(); j++) {
compVO = (MaterialVO) components.get(j);
componentVO = (ProdOrderComponentVO) comps.get(compVO.getItemCodeItm01ITM03());
if (componentVO == null) {
componentVO = new ProdOrderComponentVO();
comps.put(compVO.getItemCodeItm01ITM03(), componentVO);
componentVO.setAvailableQty(new BigDecimal(0));
componentVO.setCompanyCodeSys01DOC24(compVO.getCompanyCodeSys01ITM03());
componentVO.setDescriptionSYS10(compVO.getDescriptionSYS10());
componentVO.setDocNumberDOC24(prodVO.getDocNumberDOC23());
componentVO.setDocYearDOC24(prodVO.getDocYearDOC23());
componentVO.setItemCodeItm01DOC24(compVO.getItemCodeItm01ITM03());
componentVO.setMinSellingQtyUmCodeReg02ITM01(compVO.getMinSellingQtyUmCodeReg02ITM01());
componentVO.setQtyDOC24(new BigDecimal(0));
}
componentVO.setQtyDOC24(
componentVO.getQtyDOC24().add(compVO.getQtyITM03().multiply(prodVO.getQtyDOC23())));
}
}
// check components availability in the specified warehouse...
Enumeration en = comps.keys();
GridParams gridParams = new GridParams();
gridParams
.getOtherGridParams()
.put(ApplicationConsts.COMPANY_CODE_SYS01, prodVO.getCompanyCodeSys01DOC23());
gridParams
.getOtherGridParams()
.put(ApplicationConsts.WAREHOUSE_CODE, prodVO.getWarehouseCodeWar01DOC22());
gridParams.getOtherGridParams().put(ApplicationConsts.LOAD_ALL, Boolean.TRUE);
ItemAvailabilityVO availVO = null;
BigDecimal availability, altAvailability, delta;
String itemCode = null;
ArrayList list, availList;
AltComponentVO altVO = null;
ArrayList alternativeComps = new ArrayList();
ArrayList compsToRemove = new ArrayList();
ProdOrderComponentVO altComponentVO = null;
HashSet altCodes = null; // list of alternative component item codes...
BigDecimal altQty = null;
while (en.hasMoreElements()) {
itemCode = en.nextElement().toString();
componentVO = (ProdOrderComponentVO) comps.get(itemCode);
gridParams
.getOtherGridParams()
.put(
ApplicationConsts.ITEM_PK, new ItemPK(prodVO.getCompanyCodeSys01DOC23(), itemCode));
res =
avail.executeCommand(
gridParams, userSessionPars, request, response, userSession, context);
if (res.isError()) return res;
availList = ((VOListResponse) res).getRows();
componentVO.setAvailabilities(availList);
availability = new BigDecimal(0);
for (int i = 0; i < availList.size(); i++) {
availVO = (ItemAvailabilityVO) availList.get(i);
availability = availability.add(availVO.getAvailableQtyWAR03());
}
componentVO.setAvailableQty(availability);
if (componentVO.getQtyDOC24().doubleValue() > componentVO.getAvailableQty().doubleValue()) {
// check if there exist some alternative component...
res =
altComps.executeCommand(
gridParams, userSessionPars, request, response, userSession, context);
if (res.isError()) return res;
list = ((VOListResponse) res).getRows();
for (int i = 0; i < list.size(); i++) {
altVO = (AltComponentVO) list.get(i);
gridParams
.getOtherGridParams()
.put(
ApplicationConsts.ITEM_PK,
new ItemPK(prodVO.getCompanyCodeSys01DOC23(), altVO.getItemCodeItm01ITM04()));
res =
avail.executeCommand(
gridParams, userSessionPars, request, response, userSession, context);
if (res.isError()) return res;
availList = ((VOListResponse) res).getRows();
altAvailability = new BigDecimal(0);
for (int j = 0; j < availList.size(); j++) {
availVO = (ItemAvailabilityVO) availList.get(j);
altAvailability = altAvailability.add(availVO.getAvailableQtyWAR03());
}
if (altAvailability.doubleValue() > 0) {
altComponentVO = new ProdOrderComponentVO();
altComponentVO.setAvailabilities(availList);
altComponentVO.setAvailableQty(altAvailability);
altComponentVO.setCompanyCodeSys01DOC24(altVO.getCompanyCodeSys01ITM04());
altComponentVO.setDescriptionSYS10(altVO.getDescriptionSYS10());
altComponentVO.setDocNumberDOC24(prodVO.getDocNumberDOC23());
altComponentVO.setDocYearDOC24(prodVO.getDocYearDOC23());
altComponentVO.setItemCodeItm01DOC24(altVO.getItemCodeItm01ITM04());
altComponentVO.setMinSellingQtyUmCodeReg02ITM01(
altVO.getMinSellingQtyUmCodeReg02ITM01());
altQty =
conv.convertQty(
altVO.getMinSellingQtyUmCodeReg02ITM01(),
componentVO.getMinSellingQtyUmCodeReg02ITM01(),
altAvailability,
userSessionPars,
request,
response,
userSession,
context);
if (componentVO.getQtyDOC24().subtract(availability).doubleValue()
> altQty.doubleValue()) {
delta = altQty;
altComponentVO.setQtyDOC24(altAvailability);
} else {
delta = componentVO.getQtyDOC24();
altComponentVO.setQtyDOC24(
conv.convertQty(
componentVO.getMinSellingQtyUmCodeReg02ITM01(),
altVO.getMinSellingQtyUmCodeReg02ITM01(),
delta,
userSessionPars,
request,
response,
userSession,
context));
}
componentVO.setQtyDOC24(componentVO.getQtyDOC24().subtract(delta));
alternativeComps.add(altComponentVO);
altCodes = (HashSet) compAltComps.get(itemCode);
if (altCodes == null) {
altCodes = new HashSet();
compAltComps.put(itemCode, altCodes);
}
altCodes.add(altVO.getItemCodeItm01ITM04());
if (componentVO.getQtyDOC24().doubleValue() == 0) {
compsToRemove.add(componentVO);
break;
}
if (componentVO.getQtyDOC24().subtract(availability).doubleValue() == 0) break;
}
}
}
}
list = new ArrayList(comps.values());
list.addAll(alternativeComps);
list.removeAll(compsToRemove);
return new VOListResponse(list, false, list.size());
} catch (Throwable ex) {
Logger.error(
userSessionPars.getUsername(),
this.getClass().getName(),
"checkComponentsAvailability",
"Error while retrieving components availability for the specified production order",
ex);
return new ErrorResponse(ex.getMessage());
}
}
/**
* ]
*
* @param aWebForm AddForm
* @param request HttpServletRequest
* @param response HttpServletResponse
* @throws CDealException
* @throws Exception
*/
public static void setEdit1(
EditForm aWebForm, HttpServletRequest request, HttpServletResponse response)
throws CDealException, Exception {
EditForm aWebForm1 = (EditForm) aWebForm;
Connection mConn = null;
PreparedStatement pstmt = null;
String str = ""; // 要返回的 string
String sKey = ""; // 取出的TREEMAP的KEY
String sValue = ""; // 取出的TREEMAP的value
TreeMap itemtype;
// 初始化页面,初始化事项类别下拉菜单
// 初始化页面,初始化投诉形式下拉菜单
TreeMap COMPLAINVERSIONListName2 = new TreeMap(); // 取出aWebForm
COMPLAINVERSIONListName2 = CCodeMap.getMapByType("行政过错职级");
aWebForm.setCOMPLAINEDGRADELIST(COMPLAINVERSIONListName2);
TreeMap COMPLAINVERSIONListName3 = new TreeMap(); // 取出aWebForm
COMPLAINVERSIONListName3 = CCodeMap.getMapByType("行政管理分类");
aWebForm.setXZGLFLList(COMPLAINVERSIONListName3);
TreeMap COMPLAINVERSIONListName4 = new TreeMap(); // 取出aWebForm
COMPLAINVERSIONListName4 = CCodeMap.getMapByType("行政过错表现形式");
aWebForm.setXZGCBXXSList(COMPLAINVERSIONListName4);
try {
// 从CODEMAP表里取 来源分类 菜单
ArrayList comeList = CCodeMap.getSortedMap("行政过错行为分类");
// 从CODEMAP表里取 本级政府任务督办 菜单
ArrayList localList = CCodeMap.getSortedMap("违反规定履行社会管理职责");
// 从CODEMAP表里取 上级任务督办 菜单
ArrayList upList = CCodeMap.getSortedMap("违反内部管理制度");
// 从CODEMAP表里取 上级任务督办 菜单
ArrayList lbList = CCodeMap.getSortedMap("其他贻误行政管理工作");
// 添加 来源分类 到一个数组里面去.然后统一输出到页面
str = "var XZGCXYFL=new Array('','全部'";
int k = 0;
for (; k < comeList.size(); k++) {
LabelValueBean aLabelValueBean = (LabelValueBean) comeList.get(k);
sKey = aLabelValueBean.getValue(); // 名字
str += ",'" + sKey + "',"; // 取出的TREEMAP的KEY
sValue = aLabelValueBean.getLabel(); // 值
str += "'" + sValue + "'\n"; // 取出的TREEMAP的value
}
// CLog.println(str);
str += ");\n";
str += " var permissionitem = new Array (" + k + ");\n";
str += "permissionitem[0]=new Array('','全部');\n";
// 添加 违反规定履行社会管理职责
int j = 1;
str += "permissionitem[" + j + "]=new Array('','全部'";
for (int i = 0; i < localList.size(); i++) {
LabelValueBean aLabelValueBean = (LabelValueBean) localList.get(i);
sKey = aLabelValueBean.getValue(); // 值
// 添加每个部门对应的事项类别列表
str += ",'" + sKey + "',"; // 取出的TREEMAP的KEY
sValue = aLabelValueBean.getLabel(); // 名字
str += "'" + sValue + "'\n"; // 取出的TREEMAP的value
}
str += ");\n";
// 添加 违反内部管理制度
j = 2;
str += "permissionitem[" + j + "]=new Array('','全部'";
for (int i = 0; i < upList.size(); i++) {
LabelValueBean aLabelValueBean = (LabelValueBean) upList.get(i);
sKey = aLabelValueBean.getValue(); // 值
// 添加每个部门对应的事项类别列表
str += ",'" + sKey + "',"; // 取出的TREEMAP的KEY
sValue = aLabelValueBean.getLabel(); // 名字
str += "'" + sValue + "'\n"; // 取出的TREEMAP的value
}
str += ");\n";
// 添加 其他贻误行政管理工作
j = 3;
str += "permissionitem[" + j + "]=new Array('','全部'";
for (int i = 0; i < lbList.size(); i++) {
LabelValueBean aLabelValueBean = (LabelValueBean) lbList.get(i);
sKey = aLabelValueBean.getValue(); // 值
// 添加每个部门对应的事项类别列表
str += ",'" + sKey + "',"; // 取出的TREEMAP的KEY
sValue = aLabelValueBean.getLabel(); // 名字
str += "'" + sValue + "'\n"; // 取出的TREEMAP的value
}
str += ");\n";
// 把部门数组和许可事项输出到页面上
aWebForm1.setPrintSql(str);
} catch (Exception e) {
throw new CDealException("设置进入时限监察查询处理的初始值时失败。", e);
} finally {
if (pstmt != null) {
try {
pstmt.close();
} catch (Exception e) {
}
;
}
if (mConn != null) {
try {
mConn.close();
} catch (Exception e) {
}
;
}
}
}
/** Business logic to execute. */
public final Response executeCommand(
Object inputPar,
UserSessionParameters userSessionPars,
HttpServletRequest request,
HttpServletResponse response,
HttpSession userSession,
ServletContext context) {
Connection conn = null;
try {
conn = ConnectionManager.getConnection(context);
// fires the GenericEvent.CONNECTION_CREATED event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.CONNECTION_CREATED,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
null));
CallOutTaskVO vo = null;
ArrayList list = (ArrayList) inputPar;
Map attribute2dbField = new HashMap();
attribute2dbField.put("callOutCodeSch10SCH12", "CALL_OUT_CODE_SCH10");
attribute2dbField.put("companyCodeSys01SCH12", "COMPANY_CODE_SYS01");
attribute2dbField.put("taskCodeReg07SCH12", "TASK_CODE_REG07");
Response res = null;
for (int i = 0; i < list.size(); i++) {
vo = (CallOutTaskVO) list.get(i);
// insert into SCH12...
res =
QueryUtil.insertTable(
conn,
userSessionPars,
vo,
"SCH12_CALL_OUT_TASKS",
attribute2dbField,
"Y",
"N",
context,
true);
if (res.isError()) {
conn.rollback();
return res;
}
}
Response answer = new VOListResponse(list, false, list.size());
// fires the GenericEvent.BEFORE_COMMIT event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.BEFORE_COMMIT,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
answer));
conn.commit();
// fires the GenericEvent.AFTER_COMMIT event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.AFTER_COMMIT,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
answer));
return answer;
} catch (Throwable ex) {
Logger.error(
userSessionPars.getUsername(),
this.getClass().getName(),
"executeCommand",
"Error while inserting new call-out tasks",
ex);
try {
conn.rollback();
} catch (Exception ex3) {
}
return new ErrorResponse(ex.getMessage());
} finally {
try {
ConnectionManager.releaseConnection(conn, context);
} catch (Exception ex1) {
}
}
}
/** Business logic to execute. */
public final Response executeCommand(
Object inputPar,
UserSessionParameters userSessionPars,
HttpServletRequest request,
HttpServletResponse response,
HttpSession userSession,
ServletContext context) {
String serverLanguageId = ((JAIOUserSessionParameters) userSessionPars).getServerLanguageId();
Connection conn = null;
PreparedStatement pstmt = null;
try {
conn = ConnectionManager.getConnection(context);
// fires the GenericEvent.CONNECTION_CREATED event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.CONNECTION_CREATED,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
null));
// retrieve companies list...
GridParams gridParams = (GridParams) inputPar;
String companies =
(String)
gridParams
.getOtherGridParams()
.get(ApplicationConsts.COMPANY_CODE_SYS01); // used in lookup grid...
if (companies == null) {
ArrayList companiesList =
((JAIOUserSessionParameters) userSessionPars).getCompanyBa().getCompaniesList("SAL06");
companies = "";
for (int i = 0; i < companiesList.size(); i++)
companies += "'" + companiesList.get(i).toString() + "',";
companies = companies.substring(0, companies.length() - 1);
} else companies = "'" + companies + "'";
String sql =
"select SAL06_CHARGES.COMPANY_CODE_SYS01,SAL06_CHARGES.CHARGE_CODE,SAL06_CHARGES.PROGRESSIVE_SYS10,"
+ "SYS10_TRANSLATIONS.DESCRIPTION,SAL06_CHARGES.VALUE,SAL06_CHARGES.PERC,SAL06_CHARGES.VAT_CODE_REG01,"
+ "SAL06_CHARGES.CURRENCY_CODE_REG03,SAL06_CHARGES.ENABLED"
+ " from SAL06_CHARGES,SYS10_TRANSLATIONS where "
+ "SAL06_CHARGES.PROGRESSIVE_SYS10=SYS10_TRANSLATIONS.PROGRESSIVE and "
+ "SYS10_TRANSLATIONS.LANGUAGE_CODE=? and "
+ "SAL06_CHARGES.ENABLED='Y' and "
+ "SAL06_CHARGES.COMPANY_CODE_SYS01 in ("
+ companies
+ ")";
Map attribute2dbField = new HashMap();
attribute2dbField.put("companyCodeSys01SAL06", "SAL06_CHARGES.COMPANY_CODE_SYS01");
attribute2dbField.put("chargeCodeSAL06", "SAL06_CHARGES.CHARGE_CODE");
attribute2dbField.put("descriptionSYS10", "SYS10_TRANSLATIONS.DESCRIPTION");
attribute2dbField.put("progressiveSys10SAL06", "SAL06_CHARGES.PROGRESSIVE_SYS10");
attribute2dbField.put("valueSAL06", "SAL06_CHARGES.VALUE");
attribute2dbField.put("percSAL06", "SAL06_CHARGES.PERC");
attribute2dbField.put("vatCodeReg01SAL06", "SAL06_CHARGES.VAT_CODE_REG01");
attribute2dbField.put("currencyCodeReg03SAL06", "SAL06_CHARGES.CURRENCY_CODE_REG03");
attribute2dbField.put("enabledSAL06", "SAL06_CHARGES.ENABLED");
ArrayList values = new ArrayList();
values.add(serverLanguageId);
// read from SAL06 table...
Response res =
CustomizeQueryUtil.getQuery(
conn,
userSessionPars,
sql,
values,
attribute2dbField,
ChargeVO.class,
"Y",
"N",
context,
gridParams,
50,
true,
new BigDecimal(292) // window identifier...
);
if (res.isError()) return res;
ArrayList list = ((VOListResponse) res).getRows();
ChargeVO vo = null;
sql =
"select SYS10_TRANSLATIONS.DESCRIPTION,REG01_VATS.VALUE,REG01_VATS.DEDUCTIBLE "
+ "from SYS10_TRANSLATIONS,REG01_VATS where "
+ "REG01_VATS.PROGRESSIVE_SYS10=SYS10_TRANSLATIONS.PROGRESSIVE and "
+ "SYS10_TRANSLATIONS.LANGUAGE_CODE=? and "
+ "REG01_VATS.VAT_CODE=?";
pstmt = conn.prepareStatement(sql);
ResultSet rset = null;
for (int i = 0; i < list.size(); i++) {
vo = (ChargeVO) list.get(i);
if (vo.getVatCodeReg01SAL06() != null) {
// retrieve vat data from REG01...
pstmt.setString(1, serverLanguageId);
pstmt.setString(2, vo.getVatCodeReg01SAL06());
rset = pstmt.executeQuery();
if (rset.next()) {
vo.setVatDescriptionSYS10(rset.getString(1));
vo.setVatValueREG01(rset.getBigDecimal(2));
vo.setVatDeductibleREG01(rset.getBigDecimal(3));
}
rset.close();
}
}
Response answer = res;
// fires the GenericEvent.BEFORE_COMMIT event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.BEFORE_COMMIT,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
answer));
return answer;
} catch (Throwable ex) {
Logger.error(
userSessionPars.getUsername(),
this.getClass().getName(),
"executeCommand",
"Error while fetching charges list",
ex);
return new ErrorResponse(ex.getMessage());
} finally {
try {
pstmt.close();
} catch (Exception ex2) {
}
try {
ConnectionManager.releaseConnection(conn, context);
} catch (Exception ex1) {
}
}
}
/** Business logic to execute. */
public final Response executeCommand(
Object inputPar,
UserSessionParameters userSessionPars,
HttpServletRequest request,
HttpServletResponse response,
HttpSession userSession,
ServletContext context) {
String serverLanguageId = ((JAIOUserSessionParameters) userSessionPars).getServerLanguageId();
PreparedStatement pstmt = null;
Connection conn = null;
try {
conn = ConnectionManager.getConnection(context);
// fires the GenericEvent.CONNECTION_CREATED event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.CONNECTION_CREATED,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
null));
GridParams pars = (GridParams) inputPar;
BigDecimal rootProgressiveHIE01 =
(BigDecimal) pars.getOtherGridParams().get(ApplicationConsts.ROOT_PROGRESSIVE_HIE01);
BigDecimal progressiveHIE01 =
(BigDecimal) pars.getOtherGridParams().get(ApplicationConsts.PROGRESSIVE_HIE01);
BigDecimal progressiveHIE02 =
(BigDecimal) pars.getOtherGridParams().get(ApplicationConsts.PROGRESSIVE_HIE02);
Boolean productsOnly =
(Boolean) pars.getOtherGridParams().get(ApplicationConsts.PRODUCTS_ONLY);
Boolean compsOnly =
(Boolean) pars.getOtherGridParams().get(ApplicationConsts.COMPONENTS_ONLY);
HierarchyLevelVO vo =
(HierarchyLevelVO) pars.getOtherGridParams().get(ApplicationConsts.TREE_FILTER);
if (vo != null) {
progressiveHIE01 = vo.getProgressiveHIE01();
progressiveHIE02 = vo.getProgressiveHie02HIE01();
}
// retrieve companies list...
ArrayList companiesList =
((JAIOUserSessionParameters) userSessionPars).getCompanyBa().getCompaniesList("ITM01");
String companies = "";
for (int i = 0; i < companiesList.size(); i++)
companies += "'" + companiesList.get(i).toString() + "',";
companies = companies.substring(0, companies.length() - 1);
String sql =
"select ITM01_ITEMS.COMPANY_CODE_SYS01,ITM01_ITEMS.ITEM_CODE,SYS10_TRANSLATIONS.DESCRIPTION,ITM01_ITEMS.PROGRESSIVE_HIE02,ITM01_ITEMS.MIN_SELLING_QTY_UM_CODE_REG02,"
+ "ITM01_ITEMS.PROGRESSIVE_HIE01,ITM01_ITEMS.SERIAL_NUMBER_REQUIRED,REG02_MEASURE_UNITS.DECIMALS "
+ " from ITM01_ITEMS,SYS10_TRANSLATIONS,REG02_MEASURE_UNITS where "
+ "ITM01_ITEMS.PROGRESSIVE_HIE02=? and "
+ "ITM01_ITEMS.PROGRESSIVE_SYS10=SYS10_TRANSLATIONS.PROGRESSIVE and "
+ "SYS10_TRANSLATIONS.LANGUAGE_CODE=? and "
+ "ITM01_ITEMS.COMPANY_CODE_SYS01 in ("
+ companies
+ ") and "
+ "ITM01_ITEMS.ENABLED='Y' and "
+ "ITM01_ITEMS.MIN_SELLING_QTY_UM_CODE_REG02=REG02_MEASURE_UNITS.UM_CODE ";
if (productsOnly != null && productsOnly.booleanValue())
sql += " and ITM01_ITEMS.MANUFACTURE_CODE_PRO01 is not null ";
if (compsOnly != null && compsOnly.booleanValue())
sql += " and ITM01_ITEMS.MANUFACTURE_CODE_PRO01 is null ";
if (rootProgressiveHIE01 == null || !rootProgressiveHIE01.equals(progressiveHIE01)) {
// retrieve all subnodes of the specified node...
pstmt =
conn.prepareStatement(
"select HIE01_LEVELS.PROGRESSIVE,HIE01_LEVELS.PROGRESSIVE_HIE01,HIE01_LEVELS.LEV from HIE01_LEVELS "
+ "where ENABLED='Y' and PROGRESSIVE_HIE02=? and PROGRESSIVE>=? "
+ "order by LEV,PROGRESSIVE_HIE01,PROGRESSIVE");
pstmt.setBigDecimal(1, progressiveHIE02);
pstmt.setBigDecimal(2, progressiveHIE01);
ResultSet rset = pstmt.executeQuery();
HashSet currentLevelNodes = new HashSet();
HashSet newLevelNodes = new HashSet();
String nodes = "";
int currentLevel = -1;
while (rset.next()) {
if (currentLevel != rset.getInt(3)) {
// next level...
currentLevel = rset.getInt(3);
currentLevelNodes = newLevelNodes;
newLevelNodes = new HashSet();
}
if (rset.getBigDecimal(1).equals(progressiveHIE01)) {
newLevelNodes.add(rset.getBigDecimal(1));
nodes += rset.getBigDecimal(1) + ",";
} else if (currentLevelNodes.contains(rset.getBigDecimal(2))) {
newLevelNodes.add(rset.getBigDecimal(1));
nodes += rset.getBigDecimal(1) + ",";
}
}
rset.close();
pstmt.close();
if (nodes.length() > 0) nodes = nodes.substring(0, nodes.length() - 1);
sql += " and PROGRESSIVE_HIE01 in (" + nodes + ")";
}
Map attribute2dbField = new HashMap();
attribute2dbField.put("companyCodeSys01ITM01", "ITM01_ITEMS.COMPANY_CODE_SYS01");
attribute2dbField.put("itemCodeITM01", "ITM01_ITEMS.ITEM_CODE");
attribute2dbField.put("descriptionSYS10", "SYS10_TRANSLATIONS.DESCRIPTION");
attribute2dbField.put("progressiveHie02ITM01", "ITM01_ITEMS.PROGRESSIVE_HIE02");
attribute2dbField.put(
"minSellingQtyUmCodeReg02ITM01", "ITM01_ITEMS.MIN_SELLING_QTY_UM_CODE_REG02");
attribute2dbField.put("progressiveHie01ITM01", "ITM01_ITEMS.PROGRESSIVE_HIE01");
attribute2dbField.put("serialNumberRequiredITM01", "ITM01_ITEMS.SERIAL_NUMBER_REQUIRED");
attribute2dbField.put("decimalsREG02", "REG02_MEASURE_UNITS.DECIMALS");
ArrayList values = new ArrayList();
values.add(progressiveHIE02);
values.add(serverLanguageId);
// read from ITM01 table...
Response answer =
QueryUtil.getQuery(
conn,
userSessionPars,
sql,
values,
attribute2dbField,
GridItemVO.class,
"Y",
"N",
context,
pars,
50,
true);
// fires the GenericEvent.BEFORE_COMMIT event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.BEFORE_COMMIT,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
answer));
return answer;
} catch (Throwable ex) {
Logger.error(
userSessionPars.getUsername(),
this.getClass().getName(),
"executeCommand",
"Error while fetching items list",
ex);
return new ErrorResponse(ex.getMessage());
} finally {
try {
pstmt.close();
} catch (Exception ex2) {
}
try {
ConnectionManager.releaseConnection(conn, context);
} catch (Exception ex1) {
}
}
}
/** Business logic to execute. */
public final Response executeCommand(
Object inputPar,
UserSessionParameters userSessionPars,
HttpServletRequest request,
HttpServletResponse response,
HttpSession userSession,
ServletContext context) {
String serverLanguageId = ((JAIOUserSessionParameters) userSessionPars).getServerLanguageId();
Connection conn = null;
try {
conn = ConnectionManager.getConnection(context);
// fires the GenericEvent.CONNECTION_CREATED event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.CONNECTION_CREATED,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
null));
String sql =
"select SCH01_EMPLOYEES.COMPANY_CODE_SYS01,SCH01_EMPLOYEES.PROGRESSIVE_REG04,SCH01_EMPLOYEES.EMPLOYEE_CODE,"
+ "REG07_TASKS.TASK_CODE,REG04_SUBJECTS.NAME_1,REG04_SUBJECTS.NAME_2,SYS10_TRANSLATIONS.DESCRIPTION,SCH01_EMPLOYEES.PHONE_NUMBER,SCH01_EMPLOYEES.OFFICE "
+ "from SCH01_EMPLOYEES,SYS10_TRANSLATIONS,REG07_TASKS,REG04_SUBJECTS where "
+ "SCH01_EMPLOYEES.COMPANY_CODE_SYS01=REG07_TASKS.COMPANY_CODE_SYS01 and "
+ "SCH01_EMPLOYEES.TASK_CODE_REG07=REG07_TASKS.TASK_CODE and "
+ "REG07_TASKS.PROGRESSIVE_SYS10=SYS10_TRANSLATIONS.PROGRESSIVE and "
+ "SYS10_TRANSLATIONS.LANGUAGE_CODE=? and "
+ "SCH01_EMPLOYEES.COMPANY_CODE_SYS01=REG04_SUBJECTS.COMPANY_CODE_SYS01 and "
+ "SCH01_EMPLOYEES.PROGRESSIVE_REG04=REG04_SUBJECTS.PROGRESSIVE and "
+ "SCH01_EMPLOYEES.ENABLED='Y'";
GridParams gridParams = (GridParams) inputPar;
if (gridParams.getOtherGridParams().get(ApplicationConsts.COMPANY_CODE_SYS01) != null) {
sql +=
" and SCH01_EMPLOYEES.COMPANY_CODE_SYS01='"
+ gridParams.getOtherGridParams().get(ApplicationConsts.COMPANY_CODE_SYS01)
+ "'";
} else {
// retrieve companies list...
ArrayList companiesList =
((JAIOUserSessionParameters) userSessionPars).getCompanyBa().getCompaniesList("SCH01");
String companies = "";
for (int i = 0; i < companiesList.size(); i++)
companies += "'" + companiesList.get(i).toString() + "',";
companies = companies.substring(0, companies.length() - 1);
sql += " and SCH01_EMPLOYEES.COMPANY_CODE_SYS01 in (" + companies + ")";
}
Map attribute2dbField = new HashMap();
attribute2dbField.put("companyCodeSys01SCH01", "SCH01_EMPLOYEES.COMPANY_CODE_SYS01");
attribute2dbField.put("progressiveReg04SCH01", "SCH01_EMPLOYEES.PROGRESSIVE_REG04");
attribute2dbField.put("name_1REG04", "REG04_SUBJECTS.NAME_1");
attribute2dbField.put("name_2REG04", "REG04_SUBJECTS.NAME_2");
attribute2dbField.put("phoneNumberSCH01", "SCH01_EMPLOYEES.PHONE_NUMBER");
attribute2dbField.put("officeSCH01", "SCH01_EMPLOYEES.OFFICE");
attribute2dbField.put("employeeCodeSCH01", "SCH01_EMPLOYEES.EMPLOYEE_CODE");
attribute2dbField.put("descriptionSYS10", "SYS10_TRANSLATIONS.DESCRIPTION");
attribute2dbField.put("taskCodeReg07SCH01", "REG07_TASKS.TASK_CODE");
ArrayList values = new ArrayList();
values.add(serverLanguageId);
if (gridParams.getOtherGridParams().get(ApplicationConsts.TASK_CODE_REG07) != null) {
sql +=
" and SCH01_EMPLOYEES.TASK_CODE_REG07='"
+ gridParams.getOtherGridParams().get(ApplicationConsts.TASK_CODE_REG07)
+ "'";
}
// read from SCH01 table...
Response answer =
QueryUtil.getQuery(
conn,
userSessionPars,
sql,
values,
attribute2dbField,
GridEmployeeVO.class,
"Y",
"N",
context,
gridParams,
50,
true);
// fires the GenericEvent.BEFORE_COMMIT event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.BEFORE_COMMIT,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
answer));
return answer;
} catch (Throwable ex) {
Logger.error(
userSessionPars.getUsername(),
this.getClass().getName(),
"executeCommand",
"Error while fetching employees list",
ex);
return new ErrorResponse(ex.getMessage());
} finally {
try {
ConnectionManager.releaseConnection(conn, context);
} catch (Exception ex1) {
}
}
}
/** Business logic to execute. */
public final Response executeCommand(
Object inputPar,
UserSessionParameters userSessionPars,
HttpServletRequest request,
HttpServletResponse response,
HttpSession userSession,
ServletContext context) {
Connection conn = null;
PreparedStatement pstmt = null;
try {
String serverLanguageId = ((JAIOUserSessionParameters) userSessionPars).getServerLanguageId();
conn = ConnectionManager.getConnection(context);
// fires the GenericEvent.CONNECTION_CREATED event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.CONNECTION_CREATED,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
null));
ArrayList oldVOs = ((ArrayList[]) inputPar)[0];
ArrayList newVOs = ((ArrayList[]) inputPar)[1];
Map attribute2dbField = new HashMap();
attribute2dbField.put("companyCodeSys01DOC20", "COMPANY_CODE_SYS01");
attribute2dbField.put("progressiveDoc14DOC20", "PROGRESSIVE_DOC14");
attribute2dbField.put("progressiveSys10DOC20", "PROGRESSIVE_SYS10");
attribute2dbField.put("textValueDOC20", "TEXT_VALUE");
attribute2dbField.put("numValueDOC20", "NUM_VALUE");
attribute2dbField.put("dateValueDOC20", "DATE_VALUE");
HashSet pkAttributes = new HashSet();
pkAttributes.add("companyCodeSys01DOC20");
pkAttributes.add("progressiveDoc14DOC20");
pkAttributes.add("progressiveSys10DOC20");
Response res = null;
DocPropertyVO oldVO = null;
DocPropertyVO newVO = null;
pstmt =
conn.prepareStatement(
"select PROGRESSIVE_DOC14 from DOC20_DOC_PROPERTIES where "
+ "COMPANY_CODE_SYS01=? and PROGRESSIVE_DOC14=? and PROGRESSIVE_SYS10=?");
ResultSet rset = null;
for (int i = 0; i < oldVOs.size(); i++) {
oldVO = (DocPropertyVO) oldVOs.get(i);
newVO = (DocPropertyVO) newVOs.get(i);
// check if the record already exists: if it does not exist, then insert it...
pstmt.setString(1, newVO.getCompanyCodeSys01DOC20());
pstmt.setBigDecimal(2, newVO.getProgressiveDoc14DOC20());
pstmt.setBigDecimal(3, newVO.getProgressiveSys10DOC20());
rset = pstmt.executeQuery();
if (rset.next()) {
// the record exixts: it will be updated...
res =
QueryUtil.updateTable(
conn,
userSessionPars,
pkAttributes,
oldVO,
newVO,
"DOC20_DOC_PROPERTIES",
attribute2dbField,
"Y",
"N",
context,
true);
if (res.isError()) {
conn.rollback();
return res;
}
} else {
// the record does not exixt: it will be inserted...
res =
QueryUtil.insertTable(
conn,
userSessionPars,
newVO,
"DOC20_DOC_PROPERTIES",
attribute2dbField,
"Y",
"N",
context,
true);
if (res.isError()) {
conn.rollback();
return res;
}
}
rset.close();
}
Response answer = new VOListResponse(newVOs, false, newVOs.size());
// fires the GenericEvent.BEFORE_COMMIT event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.BEFORE_COMMIT,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
answer));
conn.commit();
// fires the GenericEvent.AFTER_COMMIT event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.AFTER_COMMIT,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
answer));
return answer;
} catch (Throwable ex) {
Logger.error(
userSessionPars.getUsername(),
this.getClass().getName(),
"executeCommand",
"Error while updating property values for the specified document",
ex);
try {
conn.rollback();
} catch (Exception ex3) {
}
return new ErrorResponse(ex.getMessage());
} finally {
try {
pstmt.close();
} catch (Exception ex2) {
}
try {
ConnectionManager.releaseConnection(conn, context);
} catch (Exception ex1) {
}
}
}
/** Business logic to execute. */
public final Response executeCommand(
Object inputPar,
UserSessionParameters userSessionPars,
HttpServletRequest request,
HttpServletResponse response,
HttpSession userSession,
ServletContext context) {
String serverLanguageId = ((JAIOUserSessionParameters) userSessionPars).getServerLanguageId();
String username = ((JAIOUserSessionParameters) userSessionPars).getUsername();
Connection conn = null;
Statement stmt = null;
try {
conn = ConnectionManager.getConnection(context);
// fires the GenericEvent.CONNECTION_CREATED event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.CONNECTION_CREATED,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
null));
stmt = conn.createStatement();
ResultSet rset =
stmt.executeQuery(
"select SYS04_ROLES.PROGRESSIVE,SYS04_ROLES.PROGRESSIVE_SYS10,SYS10_TRANSLATIONS.DESCRIPTION from "
+ "SYS14_USER_ROLES,SYS04_ROLES,SYS10_TRANSLATIONS where "
+ "SYS14_USER_ROLES.PROGRESSIVE_SYS04=SYS04_ROLES.PROGRESSIVE and "
+ "SYS04_ROLES.PROGRESSIVE_SYS10=SYS10_TRANSLATIONS.PROGRESSIVE and "
+ "SYS10_TRANSLATIONS.LANGUAGE_CODE='"
+ serverLanguageId
+ "' and "
+ "SYS14_USER_ROLES.USERNAME_SYS03='"
+ username
+ "' and "
+ "SYS04_ROLES.ENABLED='Y'");
RoleVO vo = null;
ArrayList list = new ArrayList();
while (rset.next()) {
vo = new RoleVO();
vo.setDescriptionSYS10(rset.getString(3));
vo.setEnabledSYS04("Y");
vo.setProgressiveSYS04(rset.getBigDecimal(1));
vo.setProgressiveSys10SYS04(rset.getBigDecimal(2));
list.add(vo);
}
rset.close();
Response answer = new VOListResponse(list, false, list.size());
// fires the GenericEvent.BEFORE_COMMIT event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.BEFORE_COMMIT,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
answer));
return answer;
} catch (Throwable ex) {
Logger.error(
userSessionPars.getUsername(),
this.getClass().getName(),
"executeCommand",
"Error while fetching user roles list",
ex);
return new ErrorResponse(ex.getMessage());
} finally {
try {
stmt.close();
} catch (Exception ex2) {
}
try {
ConnectionManager.releaseConnection(conn, context);
} catch (Exception ex1) {
}
}
}