public RELabelSetupMainDetails loadLabelSetupMainDetails(String setupSeqId) throws Exception {
String FETCH_QRY =
"SELECT ID,SCREEN_ID,DESCRIPTION,JSP_NAME,VO_CLASS,HANDLER_CLASS, REMARKS, STATUS FROM SOFTWARE_SERVICES WHERE ID=?";
String LABEL_QUERY =
"SELECT LF.ID,LF.FIELD_ID, LF.LABEL_TYPE, LF.VO_FIELD_TYPE, LF.REMARKS, LF.STATUS, LF.VO_FIELD_NAME, "
+ "(SELECT T4.SHORTCUT_KEY FROM LABEL_FIELDS_SHORTCUTKEYS T4 WHERE T4.FIELD_ID = LF.ID AND ROWNUM = 1) SHORTCUT_KEY "
+ "FROM LABEL_FIELDS LF WHERE LF.SERVICE_ID=?";
Connection con = null;
PreparedStatement pstmt = null;
PreparedStatement labelpstmt = null;
ResultSet rs = null;
ResultSet labelRs = null;
RELabelSetupMainDetails mainDetails = null;
RELabelFields labelFields = null;
List<RELabelFields> labelList = null;
try {
con = TagLibConnectionUtil.getConnection();
labelFields = new RELabelFields();
mainDetails = new RELabelSetupMainDetails();
mainDetails.setLang("ENGLISH");
pstmt = con.prepareStatement(FETCH_QRY);
labelpstmt = con.prepareStatement(LABEL_QUERY);
pstmt.setString(1, setupSeqId);
rs = pstmt.executeQuery();
if (rs.next()) {
mainDetails.setSeqId(rs.getLong("ID"));
mainDetails.setScrnId(rs.getString("SCREEN_ID"));
mainDetails.setDesc(rs.getString("DESCRIPTION"));
mainDetails.setJspName(rs.getString("JSP_NAME"));
mainDetails.setVoClass(rs.getString("VO_CLASS"));
mainDetails.setHandlerClass(rs.getString("HANDLER_CLASS"));
mainDetails.setRemarks(rs.getString("REMARKS"));
mainDetails.setStatus(rs.getString("STATUS"));
labelpstmt.setString(1, setupSeqId);
labelRs = labelpstmt.executeQuery();
labelList = new ArrayList<RELabelFields>();
while (labelRs.next()) {
labelFields = new RELabelFields();
labelFields.setLabelSeqId(labelRs.getLong("ID"));
labelFields.setLabelId(labelRs.getString("FIELD_ID"));
labelFields.setLabelType(labelRs.getString("LABEL_TYPE"));
labelFields.setVoFieldName(labelRs.getString("VO_FIELD_NAME"));
labelFields.setVoFieldType(labelRs.getString("VO_FIELD_TYPE"));
labelFields.setShortCutKey(labelRs.getString("SHORTCUT_KEY"));
labelFields.setLabelType(labelRs.getString("LABEL_TYPE"));
;
labelFields.setStatus(labelRs.getString("STATUS"));
labelFields.setRemarks(labelRs.getString("REMARKS"));
labelList.add(labelFields);
}
if (CollectionUtils.isNullEmpty(labelList)) {
labelFields = new RELabelFields();
labelList.add(labelFields);
}
mainDetails.setFieldsList(labelList);
mainDetails.setLangWiseFieldDescMap(getLangWiseFieldDescMap(mainDetails.getSeqId(), con));
}
} finally {
TagLibConnectionUtil.closePreparedStatement(pstmt, rs);
TagLibConnectionUtil.closePreparedStatement(labelpstmt, labelRs);
TagLibConnectionUtil.closeConnection(con);
}
return mainDetails;
}
