public void setContactAddPageDataFields() {
try {
CommonOperInterface cbt = new CommonConFactory().createInterface();
List<GridDataPropertyView> gridFields =
Configuration.getConfigurationData(
"mapped_common_contact_configuration",
accountID,
connectionSpace,
"",
0,
"table_name",
"common_contact_configuration");
if (gridFields != null) {
contactDD = new ArrayList<ConfigurationUtilBean>();
for (GridDataPropertyView gdp : gridFields) {
ConfigurationUtilBean objdata = new ConfigurationUtilBean();
if (gdp.getColType().trim().equalsIgnoreCase("D")) {
objdata.setKey(gdp.getColomnName());
objdata.setValue(gdp.getHeadingName());
objdata.setColType(gdp.getColType());
objdata.setValidationType(gdp.getValidationType());
if (gdp.getMandatroy() == null) objdata.setMandatory(false);
else if (gdp.getMandatroy().equalsIgnoreCase("0")) objdata.setMandatory(false);
else if (gdp.getMandatroy().equalsIgnoreCase("1")) objdata.setMandatory(true);
contactDD.add(objdata);
if (gdp.getColomnName().equalsIgnoreCase("regLevel")) {
officeMap = new HashMap<Integer, String>();
List data =
cbt.executeAllSelectQuery(
" select levelName from mapped_orgleinfo_level ", connectionSpace);
if (data != null && data.size() > 0 && data.get(0) != null) {
String arr[] = data.get(0).toString().split("#");
for (int i = 0; i < arr.length; i++) {
officeMap.put(i + 1, arr[i].toString());
}
}
}
}
}
}
} catch (Exception e) {
e.printStackTrace();
}
}
@SuppressWarnings("rawtypes")
public void setContactDataFieldsToAdd(String mappedTable, String configTable) {
try {
CommonOperInterface cbt = new CommonConFactory().createInterface();
List<GridDataPropertyView> gridFields =
Configuration.getConfigurationData(
mappedTable, accountID, connectionSpace, "", 0, "table_name", configTable);
if (gridFields != null) {
deptMap = new HashMap<Integer, String>();
contactFormDDBox = new ArrayList<ConfigurationUtilBean>();
contactTextBox = new ArrayList<ConfigurationUtilBean>();
industryMap = new HashMap<Integer, String>();
contactFileBox = new ArrayList<ConfigurationUtilBean>();
contactDateTimeBox = new ArrayList<ConfigurationUtilBean>();
for (GridDataPropertyView gdp : gridFields) {
ConfigurationUtilBean objdata = new ConfigurationUtilBean();
if (gdp.getColType().trim().equalsIgnoreCase("T")
&& !gdp.getColomnName().equalsIgnoreCase("userName")
&& !gdp.getColomnName().equalsIgnoreCase("createdDate")
&& !gdp.getColomnName().equalsIgnoreCase("createdAt")
&& !gdp.getColomnName().equalsIgnoreCase("userAccountId")
&& !gdp.getColomnName().equalsIgnoreCase("flag")) {
objdata.setKey(gdp.getColomnName());
objdata.setValue(gdp.getHeadingName());
objdata.setColType(gdp.getColType());
objdata.setValidationType(gdp.getValidationType());
if (gdp.getMandatroy() == null) objdata.setMandatory(false);
else if (gdp.getMandatroy().equalsIgnoreCase("0")) objdata.setMandatory(false);
else if (gdp.getMandatroy().equalsIgnoreCase("1")) objdata.setMandatory(true);
contactTextBox.add(objdata);
} else if (gdp.getColType().trim().equalsIgnoreCase("F")
&& !gdp.getColomnName().equalsIgnoreCase("userName")
&& !gdp.getColomnName().equalsIgnoreCase("createdDate")
&& !gdp.getColomnName().equalsIgnoreCase("createdAt")) {
objdata.setKey(gdp.getColomnName());
objdata.setValue(gdp.getHeadingName());
objdata.setColType(gdp.getColType());
objdata.setValidationType(gdp.getValidationType());
if (gdp.getMandatroy() == null) objdata.setMandatory(false);
else if (gdp.getMandatroy().equalsIgnoreCase("0")) objdata.setMandatory(false);
else if (gdp.getMandatroy().equalsIgnoreCase("1")) objdata.setMandatory(true);
contactFileBox.add(objdata);
} else if (gdp.getColType().trim().equalsIgnoreCase("date")) {
objdata.setKey(gdp.getColomnName());
objdata.setValue(gdp.getHeadingName());
objdata.setColType(gdp.getColType());
objdata.setValidationType(gdp.getValidationType());
if (gdp.getMandatroy() == null) objdata.setMandatory(false);
else if (gdp.getMandatroy().equalsIgnoreCase("0")) objdata.setMandatory(false);
else if (gdp.getMandatroy().equalsIgnoreCase("1")) objdata.setMandatory(true);
contactDateTimeBox.add(objdata);
} else if (gdp.getColType().trim().equalsIgnoreCase("D")) {
objdata.setKey(gdp.getColomnName());
objdata.setValue(gdp.getHeadingName());
objdata.setColType(gdp.getColType());
objdata.setValidationType(gdp.getValidationType());
if (gdp.getMandatroy() == null) objdata.setMandatory(false);
else if (gdp.getMandatroy().equalsIgnoreCase("0")) objdata.setMandatory(false);
else if (gdp.getMandatroy().equalsIgnoreCase("1")) objdata.setMandatory(true);
contactFormDDBox.add(objdata);
if (gdp.getColomnName().equalsIgnoreCase("industry")) {
List data =
cbt.executeAllSelectQuery(
"select id,industry from industrydatalevel1", connectionSpace);
if (data != null && data.size() > 0) {
for (Iterator iterator = data.iterator(); iterator.hasNext(); ) {
Object[] object = (Object[]) iterator.next();
if (object[0] != null && object[1] != null) {
industryMap.put(Integer.parseInt(object[0].toString()), object[1].toString());
}
}
}
} /*else if (getRegLevel() != null) {
List data = cbt.executeAllSelectQuery(
"select id,deptName from department where mappedOrgnztnId='"
+ getRegLevel() + "'",
connectionSpace);
if (data != null && data.size() > 0) {
for (Iterator iterator = data.iterator(); iterator
.hasNext();) {
Object[] object = (Object[]) iterator
.next();
if (object[0] != null && object[1] != null) {
deptMap.put(Integer.parseInt(object[0]
.toString()), object[1]
.toString());
}
}
}
}*/
}
}
}
} catch (Exception e) {
e.printStackTrace();
}
}
public void setViewPageProps() {
try {
if (empForAddBasic == 1) {
setContactAddPageDataFields();
setContactDataFieldsToAdd("mapped_emp_contact_configuration", "emp_contact_configuration");
}
if (empForAddPrsl == 1) {
List<GridDataPropertyView> empPer =
Configuration.getConfigurationData(
"mapped_employee_basic_configuration",
accountID,
connectionSpace,
"",
0,
"table_name",
"employee_personal_configuration");
ConfigurationUtilBean objEjb = null;
if (empPer != null) {
empPerFileBox = new ArrayList<ConfigurationUtilBean>();
for (GridDataPropertyView gdp : empPer) {
objEjb = new ConfigurationUtilBean();
if (gdp.getColType().equalsIgnoreCase("T")) {
if (!gdp.getColomnName().equalsIgnoreCase("userName")
&& !gdp.getColomnName().equalsIgnoreCase("date")
&& !gdp.getColomnName().equalsIgnoreCase("time")) {
objEjb.setKey(gdp.getColomnName());
objEjb.setValue(gdp.getHeadingName());
objEjb.setColType(gdp.getColType());
objEjb.setValidationType(gdp.getValidationType());
if (gdp.getMandatroy() == null) objEjb.setMandatory(false);
else if (gdp.getMandatroy().equalsIgnoreCase("0")) objEjb.setMandatory(false);
else if (gdp.getMandatroy().equalsIgnoreCase("1")) objEjb.setMandatory(true);
empPerLevels.add(objEjb);
}
}
if (gdp.getColType().trim().equalsIgnoreCase("F")
&& !gdp.getColomnName().equalsIgnoreCase("userName")
&& !gdp.getColomnName().equalsIgnoreCase("date")
&& !gdp.getColomnName().equalsIgnoreCase("time")) {
objEjb.setKey(gdp.getColomnName());
objEjb.setValue(gdp.getHeadingName());
objEjb.setColType(gdp.getColType());
objEjb.setValidationType(gdp.getValidationType());
if (gdp.getMandatroy() == null) objEjb.setMandatory(false);
else if (gdp.getMandatroy().equalsIgnoreCase("0")) objEjb.setMandatory(false);
else if (gdp.getMandatroy().equalsIgnoreCase("1")) objEjb.setMandatory(true);
empPerFileBox.add(objEjb);
// System.out.println("empPerFileBox" +empPerFileBox.size());
} else if (gdp.getColType().equalsIgnoreCase("Time")) {
objEjb.setKey(gdp.getColomnName());
objEjb.setValue(gdp.getHeadingName());
objEjb.setColType(gdp.getColType());
objEjb.setValidationType(gdp.getValidationType());
if (gdp.getMandatroy() == null) objEjb.setMandatory(false);
else if (gdp.getMandatroy().equalsIgnoreCase("0")) objEjb.setMandatory(false);
else if (gdp.getMandatroy().equalsIgnoreCase("1")) objEjb.setMandatory(true);
empPerCalendr.add(objEjb);
} else if (gdp.getColType().equalsIgnoreCase("D"))
empNameForOther = gdp.getHeadingName();
}
}
}
if (empForAddWorkQua == 1) {
List<GridDataPropertyView> empQua =
Configuration.getConfigurationData(
"mapped_employee_basic_configuration",
accountID,
connectionSpace,
"",
0,
"table_name",
"employee_work_exprience_configuration");
ConfigurationUtilBean objEjb = null;
if (empQua != null) {
empWorkExpFileBox = new ArrayList<ConfigurationUtilBean>();
for (GridDataPropertyView gdp : empQua) {
objEjb = new ConfigurationUtilBean();
if (gdp.getColType().equalsIgnoreCase("T")) {
if (!gdp.getColomnName().equalsIgnoreCase("userName")
&& !gdp.getColomnName().equalsIgnoreCase("date")
&& !gdp.getColomnName().equalsIgnoreCase("time")) {
objEjb.setKey(gdp.getColomnName());
objEjb.setValue(gdp.getHeadingName());
objEjb.setColType(gdp.getColType());
objEjb.setValidationType(gdp.getValidationType());
if (gdp.getMandatroy() == null) objEjb.setMandatory(false);
else if (gdp.getMandatroy().equalsIgnoreCase("0")) objEjb.setMandatory(false);
else if (gdp.getMandatroy().equalsIgnoreCase("1")) objEjb.setMandatory(true);
empWorkExpLevels.add(objEjb);
}
} else if (gdp.getColType().equalsIgnoreCase("Time")) {
objEjb.setKey(gdp.getColomnName());
objEjb.setValue(gdp.getHeadingName());
objEjb.setColType(gdp.getColType());
objEjb.setValidationType(gdp.getValidationType());
if (gdp.getMandatroy() == null) objEjb.setMandatory(false);
else if (gdp.getMandatroy().equalsIgnoreCase("0")) objEjb.setMandatory(false);
else if (gdp.getMandatroy().equalsIgnoreCase("1")) objEjb.setMandatory(true);
empWorkExpCalendr.add(objEjb);
}
if (gdp.getColType().trim().equalsIgnoreCase("F")
&& !gdp.getColomnName().equalsIgnoreCase("userName")
&& !gdp.getColomnName().equalsIgnoreCase("date")
&& !gdp.getColomnName().equalsIgnoreCase("time")) {
objEjb.setKey(gdp.getColomnName());
objEjb.setValue(gdp.getHeadingName());
objEjb.setColType(gdp.getColType());
objEjb.setValidationType(gdp.getValidationType());
if (gdp.getMandatroy() == null) objEjb.setMandatory(false);
else if (gdp.getMandatroy().equalsIgnoreCase("0")) objEjb.setMandatory(false);
else if (gdp.getMandatroy().equalsIgnoreCase("1")) objEjb.setMandatory(true);
empWorkExpFileBox.add(objEjb);
// System.out.println("empWorkExpFileBox" +empWorkExpFileBox.size());
} else if (gdp.getColType().equalsIgnoreCase("D"))
empNameForOther = gdp.getHeadingName();
}
}
}
// System.out.println("empForAddWorkExpirence" +empForAddWorkExpirence);
if (empForAddWorkExpirence == 1) {
// System.out.println("empForAddWorkExpirence" +empForAddWorkExpirence);
List<GridDataPropertyView> empQua =
Configuration.getConfigurationData(
"mapped_employee_basic_configuration",
accountID,
connectionSpace,
"",
0,
"table_name",
"employee_work_exprience_configuration");
ConfigurationUtilBean objEjb = null;
if (empQua != null) {
bankFileBox = new ArrayList<ConfigurationUtilBean>();
for (GridDataPropertyView gdp : empQua) {
objEjb = new ConfigurationUtilBean();
if (gdp.getColType().equalsIgnoreCase("T")) {
if (!gdp.getColomnName().equalsIgnoreCase("userName")
&& !gdp.getColomnName().equalsIgnoreCase("date")
&& !gdp.getColomnName().equalsIgnoreCase("time")) {
objEjb.setKey(gdp.getColomnName());
objEjb.setValue(gdp.getHeadingName());
objEjb.setColType(gdp.getColType());
objEjb.setValidationType(gdp.getValidationType());
if (gdp.getMandatroy() == null) objEjb.setMandatory(false);
else if (gdp.getMandatroy().equalsIgnoreCase("0")) objEjb.setMandatory(false);
else if (gdp.getMandatroy().equalsIgnoreCase("1")) objEjb.setMandatory(true);
empWorkExpLevels.add(objEjb);
}
} else if (gdp.getColType().equalsIgnoreCase("Time")) {
objEjb.setKey(gdp.getColomnName());
objEjb.setValue(gdp.getHeadingName());
objEjb.setColType(gdp.getColType());
objEjb.setValidationType(gdp.getValidationType());
if (gdp.getMandatroy() == null) objEjb.setMandatory(false);
else if (gdp.getMandatroy().equalsIgnoreCase("0")) objEjb.setMandatory(false);
else if (gdp.getMandatroy().equalsIgnoreCase("1")) objEjb.setMandatory(true);
empWorkExpCalendr.add(objEjb);
} else if (gdp.getColType().equalsIgnoreCase("D"))
empNameForOther = gdp.getHeadingName();
}
}
}
if (empForAddBaank == 1) {
// for bank details
List<GridDataPropertyView> empBank =
Configuration.getConfigurationData(
"mapped_employee_basic_configuration",
accountID,
connectionSpace,
"",
0,
"table_name",
"employee_bank_details_configuration");
ConfigurationUtilBean objEjb = null;
if (empBank != null) {
bankFileBox = new ArrayList<ConfigurationUtilBean>();
for (GridDataPropertyView gdp : empBank) {
objEjb = new ConfigurationUtilBean();
if (gdp.getColType().equalsIgnoreCase("T")) {
if (!gdp.getColomnName().equalsIgnoreCase("userName")
&& !gdp.getColomnName().equalsIgnoreCase("date")
&& !gdp.getColomnName().equalsIgnoreCase("time")) {
objEjb.setKey(gdp.getColomnName());
objEjb.setValue(gdp.getHeadingName());
objEjb.setColType(gdp.getColType());
objEjb.setValidationType(gdp.getValidationType());
if (gdp.getMandatroy() == null) objEjb.setMandatory(false);
else if (gdp.getMandatroy().equalsIgnoreCase("0")) objEjb.setMandatory(false);
else if (gdp.getMandatroy().equalsIgnoreCase("1")) objEjb.setMandatory(true);
empBankLevels.add(objEjb);
}
}
// System.out.println("getColomnName" +gdp.getColomnName());
if (gdp.getColType().trim().equalsIgnoreCase("F")
&& !gdp.getColomnName().equalsIgnoreCase("userName")
&& !gdp.getColomnName().equalsIgnoreCase("date")
&& !gdp.getColomnName().equalsIgnoreCase("time")) {
objEjb.setKey(gdp.getColomnName());
objEjb.setValue(gdp.getHeadingName());
objEjb.setColType(gdp.getColType());
objEjb.setValidationType(gdp.getValidationType());
if (gdp.getMandatroy() == null) objEjb.setMandatory(false);
else if (gdp.getMandatroy().equalsIgnoreCase("0")) objEjb.setMandatory(false);
else if (gdp.getMandatroy().equalsIgnoreCase("1")) objEjb.setMandatory(true);
bankFileBox.add(objEjb);
// System.out.println("bankFileBox" +bankFileBox.size());
} else if (gdp.getColType().equalsIgnoreCase("D")
&& gdp.getColomnName().equalsIgnoreCase("empName"))
empNameForOther = gdp.getHeadingName();
else if (gdp.getColType().equalsIgnoreCase("D"))
accountTypeLevel = gdp.getHeadingName();
}
}
}
} catch (Exception me) {
me.printStackTrace();
}
}
public void setReportViewProp() {
try {
String accountID = (String) session.get("accountid");
SessionFactory connectionSpace = (SessionFactory) session.get("connectionSpace");
reportViewProp = new ArrayList<GridDataPropertyView>();
GridDataPropertyView gpv = new GridDataPropertyView();
gpv.setColomnName("id");
gpv.setHeadingName("Id");
gpv.setHideOrShow("true");
reportViewProp.add(gpv);
List<GridDataPropertyView> statusColName =
Configuration.getConfigurationData(
"mapped_dar_configuration",
accountID,
connectionSpace,
"",
0,
"table_name",
"dar_configuration");
if (statusColName != null && statusColName.size() > 0) {
for (GridDataPropertyView gdp : statusColName) {
if (!gdp.getColomnName().equalsIgnoreCase("userName")
&& !gdp.getColomnName().equalsIgnoreCase("date")
&& !gdp.getColomnName().equalsIgnoreCase("time")) {
gpv = new GridDataPropertyView();
gpv.setColomnName(gdp.getColomnName());
gpv.setHeadingName(gdp.getHeadingName());
gpv.setEditable(gdp.getEditable());
gpv.setSearch(gdp.getSearch());
gpv.setHideOrShow(gdp.getHideOrShow());
gpv.setWidth(gdp.getWidth());
/*if(gdp.getColomnName().equalsIgnoreCase("attachment"))
{
gpv.setFormatter(gdp.getFormatter());
}*/
reportViewProp.add(gpv);
}
}
}
List<GridDataPropertyView> darSubmitColName =
Configuration.getConfigurationData(
"mapped_dar_configuration",
accountID,
connectionSpace,
"",
0,
"table_name",
"dar_submission_configuration");
if (darSubmitColName != null && darSubmitColName.size() > 0) {
for (GridDataPropertyView gdp : darSubmitColName) {
if (!gdp.getColomnName().equalsIgnoreCase("taskname")
&& !gdp.getColomnName().equalsIgnoreCase("userName")) {
gpv = new GridDataPropertyView();
gpv.setColomnName(gdp.getColomnName());
gpv.setHeadingName(gdp.getHeadingName());
gpv.setEditable(gdp.getEditable());
gpv.setSearch(gdp.getSearch());
gpv.setHideOrShow(gdp.getHideOrShow());
gpv.setWidth(gdp.getWidth());
/*if(gdp.getColomnName().equalsIgnoreCase("attachmentt"))
{
gpv.setFormatter(gdp.getFormatter());
}*/
reportViewProp.add(gpv);
}
}
}
} catch (Exception e) {
e.printStackTrace();
}
}