public static Column getObject(HttpServletRequest request) {
Column column = CCManager.getColumnInstance();
try {
column.setCreator(AuthHandler.getUserid(request));
column.setType(Integer.parseInt(request.getParameter("typeid")));
column.setHeader(request.getParameter("header"));
column.setModule(request.getParameter("module"));
if (!StringUtil.isNullOrEmpty("masterdata")) {
column.setMasterString(request.getParameter("masterdata"));
}
if (!StringUtil.isNullOrEmpty(request.getParameter("enabled"))) {
column.setEnabled(request.getParameter("enabled").equals("on") ? true : false);
}
if (!StringUtil.isNullOrEmpty(request.getParameter("visible"))) {
column.setVisible(request.getParameter("visible").equals("on") ? true : false);
}
if (!StringUtil.isNullOrEmpty(request.getParameter("isMandatory"))) {
column.setMandatory(request.getParameter("isMandatory").equals("on") ? true : false);
}
if (!StringUtil.isNullOrEmpty("defaultValue")) {
column.setDefaultValue(request.getParameter("defaultValue"));
}
} catch (SessionExpiredException ex) {
Logger.getLogger(CcUtil.class.getName()).log(Level.SEVERE, null, ex);
}
return column;
}
public static void getCompanyDetails(HttpServletRequest request) {
String res1 = null;
String res2 = null;
String res3 = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
com.krawler.database.DbPool.Connection conn = null;
String GET_COMPNY_IMGPATH =
"SELECT companyname,subdomain,image FROM company WHERE companyid = ?";
try {
conn = DbPool.getConnection();
pstmt = conn.prepareStatement(GET_COMPNY_IMGPATH);
pstmt.setString(1, AuthHandler.getCompanyid(request));
rs = pstmt.executeQuery();
if (rs.next()) {
res1 = rs.getString("image").trim();
String tmp[] = res1.split("/");
res1 = tmp[tmp.length - 1].toString().trim();
res3 = rs.getString("subdomain");
res2 = rs.getString("companyname");
} else {
res1 = "";
res2 = "";
res3 = "";
}
// conn.close();
} catch (SessionExpiredException ex) {
KrawlerLog.op.warn("Problem While Creating PDF :" + ex.toString());
DbPool.quietRollback(conn);
res1 = "";
res2 = "";
res3 = "";
} catch (SQLException ex) {
KrawlerLog.op.warn("Problem While Creating PDF :" + ex.toString());
DbPool.quietRollback(conn);
res1 = "";
res2 = "";
res3 = "";
} catch (ServiceException ex) {
KrawlerLog.op.warn("Problem While Creating PDF :" + ex.toString());
DbPool.quietRollback(conn);
res1 = "";
res2 = "";
res3 = "";
} finally {
imgPath = res1;
companyName = res2;
companySubDomain = res3;
DbPool.quietClose(conn);
}
}
public ModelAndView getDocs(HttpServletRequest request, HttpServletResponse response) {
JSONObject jobj = new JSONObject();
JSONObject jobj1 = new JSONObject();
KwlReturnObject kmsg = null;
KwlReturnObject result = null;
try {
HashMap<String, Object> requestParams = new HashMap<String, Object>();
ArrayList filter_names = new ArrayList(), filter_values = new ArrayList();
JSONArray jarr = new JSONArray();
String userid = "";
int start, limit;
userid = request.getParameter("userid");
String currentuser = AuthHandler.getUserid(request);
String ss = request.getParameter("ss");
if (request.getParameter("start") == null) {
start = 0;
limit = 15;
} else {
start = Integer.parseInt(request.getParameter("start"));
limit = Integer.parseInt(request.getParameter("limit"));
}
if (request.getParameter("applicant").equalsIgnoreCase("applicant")) {
filter_names.add("recid");
filter_values.add(userid);
filter_names.add("docid.deleted");
filter_values.add(false);
filter_names.add("docid.referenceid");
filter_values.add(userid);
requestParams.put("filter_names", filter_names);
requestParams.put("filter_values", filter_values);
requestParams.put("ss", ss);
requestParams.put("searchcol", new String[] {"docid.docname", "docid.docdesc"});
requestParams.put("start", start);
requestParams.put("limit", limit);
requestParams.put("allflag", false);
result = hrmsExtApplDocsDAOObj.getDocs(requestParams);
Iterator ite = result.getEntityList().iterator();
while (ite.hasNext()) {
HrmsDocmap docs = (HrmsDocmap) ite.next();
JSONObject tmpObj = new JSONObject();
tmpObj.put("docid", docs.getDocid().getDocid());
tmpObj.put("docname", docs.getDocid().getDocname());
tmpObj.put("docdesc", docs.getDocid().getDocdesc());
tmpObj.put("uploadedby", docs.getDocid().getUploadedby());
Float dsize = Math.max(0, Float.parseFloat(docs.getDocid().getDocsize()) / 1024);
tmpObj.put("docsize", String.valueOf(dsize));
tmpObj.put(
"uploaddate",
AuthHandler.getDateFormatter(request).format(docs.getDocid().getUploadedon()));
jarr.put(tmpObj);
}
} else {
filter_names.add("recid");
filter_values.add(userid);
filter_names.add("docid.deleteflag");
filter_values.add(0);
requestParams.put("filter_names", filter_names);
requestParams.put("filter_values", filter_values);
requestParams.put("ss", ss);
requestParams.put("searchcol", new String[] {"docid.docname", "docid.docdesc"});
requestParams.put("start", start);
requestParams.put("limit", limit);
requestParams.put("allflag", false);
result = documentDAOObj.getDocs(requestParams);
Iterator ite = result.getEntityList().iterator();
while (ite.hasNext()) {
Docmap docs = (Docmap) ite.next();
JSONObject tmpObj = new JSONObject();
tmpObj.put("docid", docs.getDocid().getDocid());
tmpObj.put("docname", docs.getDocid().getDocname());
tmpObj.put("docdesc", docs.getDocid().getDocdesc());
tmpObj.put(
"uploadedby",
docs.getDocid().getUserid().getFirstName()
+ " "
+ docs.getDocid().getUserid().getLastName());
Float dsize = Math.max(0, Float.parseFloat(docs.getDocid().getDocsize()) / 1024);
tmpObj.put("docsize", String.valueOf(dsize));
tmpObj.put(
"uploaddate",
AuthHandler.getDateFormatter(request).format(docs.getDocid().getUploadedon()));
jarr.put(tmpObj);
}
}
jobj.put("data", jarr);
jobj.put("count", result.getRecordTotalCount());
jobj1.put("data", jobj.toString());
jobj1.put("valid", true);
} catch (Exception e) {
System.out.println(e.getMessage());
}
return new ModelAndView("jsonView", "model", jobj1.toString());
}
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException, SessionExpiredException {
JSONObject j = null;
Connection conn = null;
clearAll();
String projectId = request.getParameter("projectid");
ProjectName = request.getParameter("projname");
ReportName = request.getParameter("reportname");
String loginid = AuthHandler.getUserid(request);
String userName = AuthHandler.getUserName(request);
String companyid = AuthHandler.getCompanyid(request);
String ipAddress = AuthHandler.getIPAddress(request);
String exportType = request.getParameter("exporttype");
String filename = filename = ProjectName + "_" + ReportName + "." + exportType;
ByteArrayOutputStream baos = null;
try {
conn = DbPool.getConnection();
String cmpcurr = ProfileHandler.getCmpCurrFromProj(conn, projectId);
try {
char a1 = (char) Integer.parseInt(cmpcurr, 16);
currSymbol = Character.toString(a1);
} catch (Exception e) {
currSymbol = cmpcurr;
}
String baseid = request.getParameter("baselineid");
String jbase = projdb.getBaselineDetails(conn, baseid);
JSONObject temp = new JSONObject(jbase);
baseName = temp.getJSONArray("data").getJSONObject(0).getString("baselinename");
String reportJson = projdb.getProjectSummaryData(conn, projectId, baseid, loginid);
j = projdb.getAllProjectSummaryData(reportJson);
JSONArray store = j.getJSONArray("data");
JSONArray rstore = j.getJSONArray("resources");
if (StringUtil.equal(exportType, "pdf")) {
baos = getPdfData(store, rstore, request);
} else if (StringUtil.equal(exportType, "csv")) {
JSONObject jtemp = new JSONObject(reportJson);
rstore = jtemp.getJSONArray("resources");
baos = getCsvData(rstore, store, request);
}
String params =
AuthHandler.getAuthor(conn, loginid)
+ " ("
+ userName
+ "), "
+ ReportName
+ ", "
+ exportType
+ " , "
+ ProjectName;
AuditTrail.insertLog(
conn, "1111", loginid, projectId, projectId, companyid, params, ipAddress, 0);
} catch (ServiceException ex) {
filename = "Problem_in_exporting_file." + exportType;
DbPool.quietRollback(conn);
} catch (JSONException e) {
filename = "Problem_in_exporting_file." + exportType;
DbPool.quietRollback(conn);
} finally {
DbPool.quietClose(conn);
try {
if (baos != null) {
baos.close();
}
} catch (IOException e) {
}
writeDataToFile(filename, baos, response);
}
}