<%@page contentType="text/html"%> <%@page pageEncoding="UTF-8"%> <%@page import="com.pwd.common.*" %> <%@page import="com.pwd.user.object.*,com.pwd.user.dao.*"%> <%@page import="com.pwd.projects.dao.*,com.pwd.projects.objects.*" %> <%@page import="com.pwd.tendering.dao.*,com.pwd.tendering.objects.*,com.pwd.tendering.handlers.*" %> <%@page import="java.util.*"%> Kerala PWD :: Latest Tenders <% PropReader props; props = PropReader.getInstance(); props.reloadProperties(); String context = props.getProperty("CONTEXT_ROOT"); String loadTenders = request.getAttribute("showTenders") == null ? "show" : request.getAttribute("showTenders").toString(); List works = new ArrayList(); List tenders = new ArrayList(); List extnTender = new ArrayList(); List userDetails = new ArrayList(); List officeDetails = new ArrayList(); List listDistricts = new ArrayList(); String districtId = (String)request.getAttribute("districtsID"); if (request.getAttribute("pubTenders") != null) { tenders = (List)request.getAttribute("pubTenders"); } if (request.getAttribute("pubTendersExtn") != null) { extnTender = (List)request.getAttribute("pubTendersExtn"); } if (request.getAttribute("works") != null) { works = (List)request.getAttribute("works"); } if (request.getAttribute("userDetails") != null) { userDetails = (List)request.getAttribute("userDetails"); } if (request.getAttribute("officeDetails") != null) { officeDetails = (List)request.getAttribute("officeDetails"); } TnTender tenderDetails = new TnTender(); if (request.getAttribute("details") != null) { tenderDetails = (TnTender)request.getAttribute("details"); } if (request.getAttribute("districts") != null) { listDistricts = (List)request.getAttribute("districts"); } %>
<% if (request.getAttribute("tenderDetails") == "default") { %> <% int slNo = 0 ; for (TnTender tenderObj : tenders) { String displayDate = "", displayTime = "", userName = "", location = "", workName = "", paramName = "", publishedDate = ""; int officeId = 0, extnProceed = 0, userProceed = 0, officeProceed = 0, workProceed = 0; %> <% } %> <% } else if (request.getAttribute("tenderDetails") == "show") { %> <% if (tenderDetails.getPrebidMeetingDate() != null) { Date prebidMeetingDate = (Date) tenderDetails.getPrebidMeetingDate(); String prebidMeetingDateString = String.valueOf(prebidMeetingDate); String displayDate =DateUtil.getFormattedDate(prebidMeetingDateString,"yyyy-MM-dd","dd-MM-yyyy"); %> <% } else {%> <% } %> <% int submitProceed = 0; String lastSubmitDate = "", openDate = "", lastSubmitTime = "", openTime = ""; for (TnTenderExtension extension : extnTender) { if (extension.getTenderId() == tenderDetails.getId() && submitProceed == 0) { Date lastSubmit = (Date) extension.getTenderSubmitLastDate(); String lastSubmitDateString = String.valueOf(lastSubmit); lastSubmitDate = DateUtil.getFormattedDate(lastSubmitDateString,"yyyy-MM-dd","dd-MM-yyyy"); lastSubmitTime = lastSubmitDateString.substring(11,16); if (null != extension.getOpeningDate()) { Date open = (Date) extension.getOpeningDate(); String openDateString = String.valueOf(open); openDate = DateUtil.getFormattedDate(openDateString,"yyyy-MM-dd","dd-MM-yyyy"); openTime = openDateString.substring(11,16); } else { openDate = ""; openTime = ""; } submitProceed =1; } } if (submitProceed == 0) { Date lastSubmit = (Date) tenderDetails.getTenderSubmitLastDate(); String lastSubmitDateString = String.valueOf(lastSubmit); lastSubmitDate = DateUtil.getFormattedDate(lastSubmitDateString,"yyyy-MM-dd","dd-MM-yyyy"); lastSubmitTime = lastSubmitDateString.substring(11,16); if (null != tenderDetails.getOpeningDate()) { Date open = (Date) tenderDetails.getOpeningDate(); String openDateString = String.valueOf(open); openDate = DateUtil.getFormattedDate(openDateString,"yyyy-MM-dd","dd-MM-yyyy"); openTime = openDateString.substring(11,16); } else { openDate = ""; openTime = ""; } } %> <% if (tenderDetails.getOpeningDate() != null) { Date pqbidOpenDate = (Date) tenderDetails.getOpeningDate(); String pqbidOpenDateString = String.valueOf(pqbidOpenDate); String showDate =DateUtil.getFormattedDate(pqbidOpenDateString,"yyyy-MM-dd","dd-MM-yyyy"); %> <% } else {%> <% } %> <% if (tenderDetails.getPricebidOpenDate() != null) { Date priceBidOpeningDate = (Date) tenderDetails.getPricebidOpenDate(); String priceBidOpeningDateString = String.valueOf(priceBidOpeningDate); String displayDate =DateUtil.getFormattedDate(priceBidOpeningDateString,"yyyy-MM-dd","dd-MM-yyyy"); %> <%} else {%> <%}%> <% String compPeriod = tenderDetails.getCompletionPeriod().toString(); String[] compSplit = compPeriod.split("\\."); String months = "0", days = "0", compDispaly = ""; if (compSplit.length > 1) { if (!"0".equalsIgnoreCase(compSplit[0])) { months = compSplit[0]; compDispaly = months+ " Months "; } if (!"0".equalsIgnoreCase(compSplit[1])) { days = compSplit[1]; compDispaly = compDispaly+ days+" Days"; } } %> <% if (tenderDetails.getQuoteTyep() != null) { %> <%} else {%> <%} %> <%if(tenderDetails.getPrequalification().equalsIgnoreCase("Y")){%> <%} %> <% if (tenderDetails.getSaleCloseDate()!=(null)) { Date saleLastDate = (Date) tenderDetails.getSaleCloseDate(); String saleLastDateString = String.valueOf(saleLastDate); String saleDate =DateUtil.getFormattedDate(saleLastDateString,"yyyy-MM-dd","dd-MM-yyyy"); %> <%} else {%> <%} %> <% } if (request.getAttribute("tenderDetails") == "default" && tenders.size() < 1) { %> <% } %>
Latest Tenders        
<%=++slNo%> <% /* for (TnTenderExtension extnObj : extnTender) { if (tenderObj.getId() == extnObj.getTenderId() && extnProceed == 0) { Date lastDate = (Date) extnObj.getTenderSubmitLastDate(); String lastDateString = String.valueOf(lastDate); displayDate =DateUtil.getFormattedDate(lastDateString,"yyyy-MM-dd","dd-MM-yyyy"); displayTime = lastDateString.substring(11,16); extnProceed = 1; } } if (extnProceed == 0) { Date lastDate = (Date) tenderObj.getTenderSubmitLastDate(); String lastDateString = String.valueOf(lastDate); displayDate =DateUtil.getFormattedDate(lastDateString,"yyyy-MM-dd","dd-MM-yyyy"); displayTime = lastDateString.substring(11,16); } */ Date lastDate = (Date) tenderObj.getTenderSubmitLastDate(); String lastDateString = String.valueOf(lastDate); displayDate =DateUtil.getFormattedDate(lastDateString,"yyyy-MM-dd","dd-MM-yyyy"); displayTime = lastDateString.substring(11,16); String publishedDateString = String.valueOf((Date) tenderObj.getPublishedDate()); publishedDate =DateUtil.getFormattedDate(publishedDateString,"yyyy-MM-dd","dd-MM-yyyy"); for (UserObjNew userObj : userDetails) { if (userObj.getUserId().intValue() == tenderObj.getUserId().intValue() && userProceed == 0) { userName = userObj.getUserName() == null ? "" : userObj.getUserName().toString()+","; officeId = userObj.getOfficeId() == null ? 0 : userObj.getOfficeId(); userProceed = 1; } } for (OfficeObj officeObj : officeDetails) { if (officeObj.getOfficeId() == officeId && officeProceed == 0) { location = officeObj.getOfficeAddress() == null ? "" : officeObj.getOfficeAddress().toString(); paramName = officeObj.getOfficeName() == null ? "" : officeObj.getOfficeName().toString()+","; officeProceed = 1; } } for (PmWorks workObj : works) { if (workObj.getId() == tenderObj.getWorkId() && workProceed == 0) { workName = workObj.getWorkName() == null ? "" : workObj.getWorkName().toString(); if (workName.equalsIgnoreCase("Non Work") || workName.equalsIgnoreCase("Supplies and Services")) { workName = tenderObj.getDescription(); } workProceed = 1; } } %> <%=userName %> <%=paramName %> <%=location %>  invites tender for the work <%=workName %>

Tender Published on: <%=publishedDate %>
Last date for submission of tender: <%=displayDate %>  <%=displayTime %> hrs.       click here....

Tender Details : <%=tenderDetails.getTenderNo() %> Back
Tender Number : <%=tenderDetails.getTenderNo() %>
Submission Types : <%=tenderDetails.getManualSubmission().equalsIgnoreCase("Y")?"Offline":"Electronic" %>
Work Name : <%=request.getAttribute("workName").toString().equalsIgnoreCase("Non Work")?"Supplies & Services Tender" : request.getAttribute("workName").toString() %>
Description : <%=tenderDetails.getDescription() %>
Estimate PAC (Rs.) : <%=DateUtil.getFormattedDouble(tenderDetails.getProbableAmount()) %>
Pre-bid Meeting Date and Time : <%=displayDate %> <%=prebidMeetingDateString.substring(11,16)%>  hrs 
Last Date and Time of Submission of Tender : <%=lastSubmitDate %> <%=lastSubmitTime %> hrs
Bid Opening Date and Time : <%=openDate %> <%=openTime%>  hrs 
Price Bid Opening Date and Time <%=displayDate %> <%=priceBidOpeningDateString.substring(11,16)%>  hrs 
Period of Completion (in Months and Days) : <%=compDispaly%>
Cost of Department Supply (Rs) (if any) <%=tenderDetails.getCostOfMaterials()==(null)?"0":DateUtil.getFormattedDouble(tenderDetails.getCostOfMaterials())%>
Earnest Money Deposit (Rs) <%=tenderDetails.getEmd()==(null)?"0":DateUtil.getFormattedDouble(tenderDetails.getEmd())%>
Type of Quote <%=tenderDetails.getQuoteTyep().equalsIgnoreCase("percentage")?"Percentage":"Item wise Quoting"%> 
Prequalification Needed <%=tenderDetails.getPrequalification().equalsIgnoreCase("N")?"No":"Yes" %>
Whether Technical Bid in 2 Cover System submitted ? <%=tenderDetails.getTechnicalBidSubmitted().equalsIgnoreCase("N")?"No":"Yes"%>
Contractor Type Class <%=request.getAttribute("contractorClass") %>
Contact Person <%=tenderDetails.getContactperson() %>
Firm Period <%=tenderDetails.getFirmnessPeriod()==(null)?"0":tenderDetails.getFirmnessPeriod() %>
Cost of Tender Form [including Taxes] / Bid Submission Fee in Rs. <%=tenderDetails.getCostTender()==(null)?"0":DateUtil.getFormattedDouble(tenderDetails.getCostTender())%>
Last Date of Sale of Tender Form <%=saleDate %> 
Uploaded Tender Notice <%=request.getAttribute("tenderFileName") %>
No tenders published on-line