/**
* Method execute
*
* @param mapping
* @param form
* @param request
* @param response
* @return ActionForward
*/
public ActionForward execute(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception {
HttpSession session = request.getSession();
// System.out.println("checkpoint13");
String numCount = (String) session.getAttribute("numCount");
int count = Integer.parseInt(numCount);
int remander = count % 2;
System.out.println("checkpoint at corpo 2");
AdvtMaster advtMaster = new AdvtMaster();
RootMaster rootMaster = new RootMaster();
IndvMaster indvMaster = new IndvMaster();
String uId = (String) session.getAttribute("uId");
String compId = (String) session.getAttribute("compId");
System.out.println("compId..in Action avdt ........." + compId);
// int regFlag= rootMaster.getRegisteredFlag(getDataSource(request, "corpo"), compId);
// System.out.println("regFlag..in Action avdt ........."+regFlag);
Vector allRights = (Vector) session.getAttribute("allRights");
String adminFlag = allRights.elementAt(18).toString();
// System.out.println("checkpoint at corpo 3");
String pageid =
(request.getParameter("pageid") != null) ? request.getParameter("pageid").trim() : "1";
String aType =
(request.getParameter("aType") != null) ? request.getParameter("aType").trim() : "0";
String lowerSubTag =
(request.getParameter("lowerSubTag") != null)
? request.getParameter("lowerSubTag").trim()
: "1";
String categoryid =
(request.getParameter("categoryid") != null)
? request.getParameter("categoryid").trim()
: "0";
// System.out.println("lowerSubTag..in Action avdt ........."+lowerSubTag);
java.util.Date dt = new java.util.Date();
SimpleDateFormat sform = new SimpleDateFormat("yyyy-MM-dd");
String completeRemDate = sform.format(dt);
StringTokenizer sttotal = new StringTokenizer(completeRemDate, ",");
String creationDate = sttotal.nextToken();
String dateToday[] = creationDate.split("-");
String YR = dateToday[0];
String DaY = dateToday[2];
String MTH = dateToday[1];
String month = (request.getParameter("Month") != null) ? request.getParameter("Month") : MTH;
String nYear = (request.getParameter("Year") != null) ? request.getParameter("Year") : YR;
System.out.println("month and yesar" + month + " " + nYear);
String strShortBy =
(request.getParameter("sby") != null) ? request.getParameter("sby") : "creation_date";
String strSOrder = "";
String strComFIdOrder = "asc";
String strCTitelOrder = "asc";
String strDateOrder = "asc";
if (request.getParameter("sby") != null) {
if (request.getParameter("fidorder") != null) {
if (request.getParameter("fidorder").trim().equalsIgnoreCase("asc")) {
strSOrder = "desc";
strComFIdOrder = "desc";
} else if (request.getParameter("fidorder").trim().equalsIgnoreCase("desc")) {
strSOrder = "asc";
strComFIdOrder = "asc";
}
}
if (request.getParameter("ctorder") != null) {
if (request.getParameter("ctorder").trim().equalsIgnoreCase("asc")) {
strSOrder = "desc";
strCTitelOrder = "desc";
} else if (request.getParameter("ctorder").trim().equalsIgnoreCase("desc")) {
strSOrder = "asc";
strCTitelOrder = "asc";
}
}
if (request.getParameter("dateorder") != null) {
if (request.getParameter("dateorder").trim().equalsIgnoreCase("asc")) {
strSOrder = "desc";
strDateOrder = "desc";
} else if (request.getParameter("dateorder").trim().equalsIgnoreCase("desc")) {
strSOrder = "asc";
strDateOrder = "asc";
}
}
}
String strFShortBy = strShortBy + " " + strSOrder;
int minVal =
(request.getParameter("numMin") != null)
? Integer.parseInt(request.getParameter("numMin"))
: 0;
int maxVal = 10;
//// System.out.println("countVec.............InboxAction......minVal..... "+minVal);
//// System.out.println("countVec.............InboxAction......maxVal..... "+maxVal);
Vector<String> paramVec1 = new Vector<String>();
paramVec1.add(uId);
paramVec1.add(compId);
paramVec1.add(adminFlag);
paramVec1.add(pageid);
Vector<String> paramVec = new Vector<String>();
paramVec.add(String.valueOf(minVal));
paramVec.add(String.valueOf(maxVal));
paramVec.add(strFShortBy);
paramVec.add(uId);
paramVec.add(compId);
paramVec.add(adminFlag);
paramVec.add(pageid);
int Cid = Integer.parseInt(compId);
int Uid = Integer.parseInt(uId);
int aFid = Integer.parseInt(adminFlag);
Vector comVec = new Vector();
Vector comListVec = new Vector();
String comList = "";
paramVec1.add("0");
paramVec.add("0");
////// System.out.println("comList................on page."+comList);
int totalRow = 0;
paramVec1.add(lowerSubTag);
paramVec1.add(categoryid);
paramVec1.add(month);
paramVec1.add(nYear);
paramVec.add(lowerSubTag);
paramVec.add(categoryid);
paramVec.add(month);
paramVec.add(nYear);
totalRow = advtMaster.getComplaintCountL(getDataSource(request, "corpo"), paramVec1);
Vector UserVec = advtMaster.getBrandComplaintList1L(getDataSource(request, "corpo"), paramVec);
String country = "", state = "", city = "", brand = "", category = "", firstName = "";
String countryName = "", stateName = "", cityName = "", brandName = "", categoryName = "";
String searchFor = "";
DataSource dataSource = getDataSource(request, "corpo");
Vector userVec = (Vector) session.getAttribute("userVec");
Vector cscVec = (Vector) session.getAttribute("cscVec");
cscVec = userVec;
Vector userTempVec = new Vector();
if (session.getAttribute("userVec") != null) {
userTempVec = (Vector) session.getAttribute("userVec");
for (int i = 0; i < userTempVec.size(); i++) {
if (userTempVec.elementAt(i).toString().equals("city =")) {
city = userTempVec.elementAt(i + 1).toString().trim();
cityName = rootMaster.getPlaceName(dataSource, Integer.parseInt(city));
break;
}
}
}
Vector searchVec = new Vector();
/*
* searchFor (0) Student.
*/
if (searchFor.equalsIgnoreCase("0")) {
if (session.getAttribute("searchVec") != null) {
searchVec = (Vector) session.getAttribute("searchVec");
for (int i = 0; i < searchVec.size(); i++) {
paramVec.add(searchVec.elementAt(i).toString());
if (searchVec.elementAt(i).toString().equals("course =")) {
category = searchVec.elementAt(i + 1).toString().trim();
Vector categoryNameVec =
indvMaster.getCourseName(dataSource, Integer.parseInt(category.trim()));
categoryName = categoryNameVec.elementAt(0).toString();
}
if (searchVec.elementAt(i).toString().equals("first_name like")) {
firstName = searchVec.elementAt(i + 1).toString().trim();
String teamCat1[] = firstName.split("%");
////////// System.out.println("teamCat[]>>>>>>>searchVec>>>>>>>"+teamCat1[1]);
firstName = teamCat1[1];
}
if (searchVec.elementAt(i).toString().equals("college_id =")) {
brand = searchVec.elementAt(i + 1).toString().trim();
String StrArr[] = brand.split("~");
int compnyid = Integer.parseInt(StrArr[0]);
if (compnyid == 0) {
compnyid = Integer.parseInt(userVec.elementAt(27).toString());
Vector name = indvMaster.getOtherCollege(dataSource, compnyid);
brandName = name.elementAt(0).toString().trim();
} else if (StrArr[1].equalsIgnoreCase("1")) {
brandName = rootMaster.getCompnyName(dataSource, compnyid);
} else {
brandName = rootMaster.getCollegeName(dataSource, compnyid);
}
// brandName
}
}
}
if (session.getAttribute("userVec") != null) {
for (int i = 0; i < userVec.size(); i++) {
paramVec.add(userVec.elementAt(i).toString());
}
}
}
String strPageHtml = getPages(minVal, maxVal, totalRow, lowerSubTag, pageid, numCount);
int regFlag = 0;
int numcount = UserVec.size();
String strComplaintList =
getComplaintList(
searchFor,
dataSource,
numcount,
strComFIdOrder,
strCTitelOrder,
strDateOrder,
minVal,
maxVal,
totalRow,
strPageHtml,
UserVec,
pageid,
lowerSubTag,
regFlag,
city,
brand,
categoryName,
cityName,
brandName,
remander,
firstName,
month,
nYear);
// System.out.println("Users "+strComplaintList);
/**
* setContentType - text/html to write String on page. PrintWriter - This line use to get writer
* to write on page. out.println - use to write string.
*/
response.setContentType("text/html;charset=ISO-8859-1");
PrintWriter out = response.getWriter();
out.println(strComplaintList);
out.flush();
// TODO Auto-generated method stub
return null;
}
