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();
    }
  }
  @SuppressWarnings({"rawtypes", "unchecked"})
  public String viewDARReportData() {
    if (ValidateSession.checkSession()) {
      try {
        SessionFactory connectionSpace = (SessionFactory) session.get("connectionSpace");
        CommonOperInterface cbt = new CommonConFactory().createInterface();
        String accountID = (String) session.get("accountid");
        String userName = (String) session.get("uName");
        DARReportHelper DRH = new DARReportHelper();
        TaskRegistrationHelper TRH = new TaskRegistrationHelper();
        StringBuilder query = new StringBuilder("");
        query.append("select count(*) from task_registration");
        List dataCount = cbt.executeAllSelectQuery(query.toString(), connectionSpace);
        if (dataCount != null) {
          BigInteger count = new BigInteger("3");
          Object obdata = null;
          for (Iterator it = dataCount.iterator(); it.hasNext(); ) {
            obdata = (Object) it.next();
            count = (BigInteger) obdata;
          }
          setRecords(count.intValue());
          int to = (getRows() * getPage());
          if (to > getRecords()) to = getRecords();
          String userEmpID = null;
          String alltedTo = null;
          String empIdofuser = (String) session.get("empIdofuser");
          if (empIdofuser == null || empIdofuser.split("-")[1].trim().equals("")) return ERROR;
          userEmpID = empIdofuser.split("-")[1].trim();
          String userContID = null;
          userContID = TRH.getEmpDetailsByUserName("DAR", userName, connectionSpace)[0];
          alltedTo = TRH.getContactListForReports(userEmpID, userContID, connectionSpace);

          // System.out.println(">>>>>> FINAL CONTACT LIST IS AS ::::  "+alltedTo);
          query.setLength(0);
          query.append("SELECT  ");
          List fieldNames =
              Configuration.getColomnList(
                  "mapped_dar_configuration", accountID, connectionSpace, "dar_configuration");
          List<Object> Listhb = new ArrayList<Object>();
          int i = 0;
          for (Iterator it = fieldNames.iterator(); it.hasNext(); ) {
            obdata = (Object) it.next();
            if (obdata != null) {
              if (!obdata.toString().equalsIgnoreCase("userName")
                  && !obdata.toString().equalsIgnoreCase("date")
                  && !obdata.toString().equalsIgnoreCase("time")) {
                if (obdata.toString().equalsIgnoreCase("tasktype")) {
                  query.append("ty.tasktype" + ",");
                } else if (obdata.toString().equalsIgnoreCase("allotedto")) {
                  query.append("emp1.empName as allotedto,");
                } else if (obdata.toString().equalsIgnoreCase("allotedby")) {
                  query.append("emp2.empName as allotedby,");
                } else if (obdata.toString().equalsIgnoreCase("validate_By_2")) {
                  query.append("emp3.empName as val2,");
                } else if (obdata.toString().equalsIgnoreCase("validate_By_1")) {
                  query.append("emp4.empName as val1,");
                } else if (obdata.toString().equalsIgnoreCase("guidance")) {
                  query.append("emp5.empName as guidance,");
                } else {
                  query.append("tr." + obdata.toString() + ",");
                }
              }
            }
            i++;
          }
          fieldNames.remove("userName");
          fieldNames.remove("date");
          fieldNames.remove("time");

          i = 0;
          List gridFields = new ArrayList();
          List fieldNames1 =
              Configuration.getColomnList(
                  "mapped_dar_configuration",
                  accountID,
                  connectionSpace,
                  "dar_submission_configuration");
          for (Iterator it = fieldNames1.iterator(); it.hasNext(); ) {
            obdata = (Object) it.next();
            if (obdata != null) {
              if (!obdata.toString().equalsIgnoreCase("taskname")
                  && !obdata.toString().equalsIgnoreCase("id")
                  && !obdata.toString().equalsIgnoreCase("userName")) {
                gridFields.add(obdata.toString());
                if (i < fieldNames1.size() - 1) query.append("ds." + obdata.toString() + ",");
                else query.append("ds." + obdata.toString());
              }
            }
            i++;
          }
          query.append(" FROM task_registration AS tr ");
          query.append(" LEFT JOIN dar_submission AS ds ON ds.taskname=tr.id ");
          query.append("LEFT JOIN compliance_contacts AS cc1 ON tr.allotedto=cc1.id ");
          query.append("LEFT JOIN compliance_contacts AS cc2 ON tr.allotedby=cc2.id ");
          query.append("LEFT JOIN compliance_contacts AS cc3 ON tr.validate_By_2=cc3.id ");
          query.append("LEFT JOIN compliance_contacts AS cc4 ON tr.validate_By_1=cc4.id ");
          query.append("LEFT JOIN compliance_contacts AS cc5 ON tr.guidance=cc5.id  ");
          query.append("LEFT JOIN employee_basic emp1 ON cc1.emp_id= emp1.id  ");
          query.append("LEFT JOIN employee_basic emp2 ON cc2.emp_id= emp2.id  ");
          query.append("LEFT JOIN employee_basic emp3 ON cc3.emp_id= emp3.id ");
          query.append("LEFT JOIN employee_basic emp4 ON cc4.emp_id= emp4.id ");
          query.append("LEFT JOIN employee_basic emp5 ON cc5.emp_id= emp5.id ");
          query.append("LEFT JOIN task_type ty ON tr.tasktype= ty.id   ");
          if (fdate.split("-")[0].length() < 3) {
            fdate = DateUtil.convertDateToUSFormat(fdate);
            tdate = DateUtil.convertDateToUSFormat(tdate);
          }
          query.append(" WHERE  ds.date BETWEEN '" + fdate + "' AND '" + tdate + "'  ");
          if (allotTo != null && !allotTo.equalsIgnoreCase("-1")) {
            query.append(" AND  tr.allotedTo='" + allotTo + "' ");
          }
          if (clientFor != null && !clientFor.equalsIgnoreCase("-1")) {
            query.append(" AND  tr.clientfor='" + clientFor + "' ");
          }
          if (taskTyp != null && !taskTyp.equalsIgnoreCase("-1")) {
            query.append(" AND  tr.tasktype='" + taskTyp + "' ");
          }
          if (taskPriority != null && !taskPriority.equalsIgnoreCase("-1")) {
            query.append(" AND  tr.priority='" + taskPriority + "' ");
          }
          if (statusWork != null && !statusWork.equalsIgnoreCase("-1")) {
            query.append(" AND  tr.status='" + statusWork + "' ");
          }
          if (alltedTo != null && alltedTo.length() > 0) {
            query.append(" AND  tr.allotedTo IN (" + alltedTo + ") ");
          }
          if (getSearchField() != null
              && getSearchString() != null
              && !getSearchField().equalsIgnoreCase("")
              && !getSearchString().equalsIgnoreCase("")) {
            query.append(" and ");
            if (getSearchOper().equalsIgnoreCase("eq")) {
              query.append(" " + getSearchField() + " = '" + getSearchString() + "'");
            } else if (getSearchOper().equalsIgnoreCase("cn")) {
              query.append(" " + getSearchField() + " like '%" + getSearchString() + "%'");
            } else if (getSearchOper().equalsIgnoreCase("bw")) {
              query.append(" " + getSearchField() + " like '" + getSearchString() + "%'");
            } else if (getSearchOper().equalsIgnoreCase("ne")) {
              query.append(" " + getSearchField() + " <> '" + getSearchString() + "'");
            } else if (getSearchOper().equalsIgnoreCase("ew")) {
              query.append(" " + getSearchField() + " like '%" + getSearchString() + "'");
            }
          }
          System.out.println("QUERY OF REPORT IS AS ::::  " + query.toString());
          List data = cbt.executeAllSelectQuery(query.toString(), connectionSpace);
          for (int k = 0; k < gridFields.size(); k++) {
            fieldNames.add(gridFields.get(k).toString());
          }
          if (data != null && data.size() > 0) {

            String clientData = null;
            String clientVal = null;
            Object[] obdata11 = null;
            for (Iterator it = data.iterator(); it.hasNext(); ) {
              obdata11 = (Object[]) it.next();
              Map<String, Object> one = new HashMap<String, Object>();
              for (int k = 0; k < fieldNames.size(); k++) {
                if (fieldNames.get(k) != null
                    && obdata11[k] != null
                    && !obdata11[k].toString().equalsIgnoreCase("")) {
                  if (obdata11[k].toString().matches("\\d{4}-[01]\\d-[0-3]\\d")) {
                    one.put(
                        fieldNames.get(k).toString(),
                        DateUtil.convertDateToIndianFormat(obdata11[k].toString()));
                  }
                  /*else if(fieldNames.get(k).toString().equalsIgnoreCase("attachment")||  fieldNames.get(k).toString().equalsIgnoreCase("attachmentt")||fieldNames.get(k).toString().equalsIgnoreCase("reviewDoc")  )
                  {
                  	String str=obdata11[k].toString().substring(obdata11[k].toString().indexOf("//"), obdata11[k].toString().length());
                  	String docName=str.substring(14,str.length());
                  	one.put(fieldNames.get(k).toString(),docName);
                  }*/
                  else if (fieldNames.get(k).toString().equalsIgnoreCase("clientfor")) {
                    clientVal = obdata11[k].toString();
                    if (obdata11[k].toString().equalsIgnoreCase("PA")) {
                      one.put(fieldNames.get(k).toString(), "Prospect Associate");
                    } else if (obdata11[k].toString().equalsIgnoreCase("PC")) {
                      one.put(fieldNames.get(k).toString(), "Prospect Client");
                    } else if (obdata11[k].toString().equalsIgnoreCase("N")) {
                      one.put(fieldNames.get(k).toString(), "Other");
                    } else if (obdata11[k].toString().equalsIgnoreCase("EC")) {
                      one.put(fieldNames.get(k).toString(), "Existing Client");
                    } else if (obdata11[k].toString().equalsIgnoreCase("EA")) {
                      one.put(fieldNames.get(k).toString(), "Existing Associate");
                    } else if (obdata11[k].toString().equalsIgnoreCase("IN")) {
                      one.put(fieldNames.get(k).toString(), "Internal");
                    }
                  } else if (fieldNames.get(k).toString().equalsIgnoreCase("cName")) {
                    clientData = obdata11[k].toString();
                    one.put(
                        fieldNames.get(k).toString(),
                        DRH.clientName(clientVal, obdata11[k].toString(), connectionSpace));
                  } else if (fieldNames.get(k).toString().equalsIgnoreCase("offering")) {
                    one.put(
                        fieldNames.get(k).toString(),
                        DRH.offeringName(
                            clientVal, clientData, obdata11[k].toString(), connectionSpace));
                  } else {
                    one.put(fieldNames.get(k).toString(), obdata11[k].toString());
                  }
                } else {
                  one.put(fieldNames.get(k).toString(), "NA");
                }
              }
              Listhb.add(one);
            }
            setViewList(Listhb);
            setTotal((int) Math.ceil((double) getRecords() / (double) getRows()));
          }
        }
        return SUCCESS;
      } catch (Exception exp) {
        exp.printStackTrace();
        return ERROR;
      }
    } else {
      return ERROR;
    }
  }
 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();
    }
  }