|
|
|
|
|
|
|
Selected
and accepted candidates list
|
|
|
<%
String queryStr=" SELECT Master_id, Valid_id,paid,Rate_id FROM Payment p,Rate_plan r ";
queryStr+=" WHERE p.Master_id=? and p.Rate_id=r.id and p.Valid_id<>0 ORDER BY p.id,master_id ";
//System.out.println(" queryStr first "+queryStr);
log(" queryStr first "+queryStr);
try{
pmst=con.prepareStatement(queryStr);
pmst.setInt(1,1292);
paidrs=pmst.executeQuery();
boolean countBln=paidrs.next();
boolean countCheckBln=countBln;
log("countBln"+countBln);
ArrayList masterArr=null;
ArrayList validArr=null;
ArrayList paidArr=null;
ArrayList rateArr=null;
System.out.println(" countBln "+countBln);
if(countBln){
masterArr=new ArrayList();
validArr=new ArrayList();
paidArr=new ArrayList();
rateArr=new ArrayList();
while(countBln){
masterArr.add(""+paidrs.getInt(1));
validArr.add(""+paidrs.getInt(2));
paidArr.add(paidrs.getString(3));
rateArr.add(""+paidrs.getInt(4));
countBln=paidrs.next();
}//end of while loop
//===================================code to be added =======================
//===================================================
System.out.println(" countCheckBln "+countCheckBln);
if(countCheckBln){ // if loop to check paid vacancy
%>
|
Sl.
No.
|
Company
Name |
Job
Code
|
Position
Vacant
|
Posted
date
|
Selected
Candidate |
Candidate
Replied |
<%
int countInt=1;
String tempStr=null;
String masterFirstStr=null;
String masterSecondStr=null;
String paidStr=null;
String rateStr=null;
for(int i=0;i
|
<%=countInt++ %>
|
<%= paidrs.getString(2) %> |
<%= paidrs.getString(3)%>
|
<%= paidrs.getString(4)%>
|
<%= paidrs.getString(5)%>
|
<%=countselectInt%> |
<%=countstudentInt%> |
<%
countBln=paidrs.next();
}// end of while loop
}//end of if loop for vacancy select
}//end of if loop
//------------------------------else loop ---------------------------------
else if(paidStr.equals("y")){
//------------------------
System.out.println(" i am in else loop for paid Y");
queryStr=" SELECT DISTINCT v.Id, m.CompanyName, v.Reference, v.Position_vacant,v.Post_date ";
queryStr+=" FROM Vacancy AS v, Payment p, Rate_plan r, master m ";
queryStr+=" WHERE (v.Master_id=?) And (p.master_id=v.Master_id and m.id=v.Master_id) And (v.Id>=?) And (v.Rate_id=? Or v.Rate_id=0) and v.Activated='y' ORDER BY v.Id ";
System.out.println(queryStr);
pmst=con.prepareStatement(queryStr);
System.out.println(" masterArr.get(i) "+masterArr.get(i));
tempStr=(String)masterArr.get(i);
Integer tempINT=new Integer(tempStr);
pmst.setInt(1,tempINT.intValue());
tempStr=(String)validArr.get(i);
tempINT=new Integer(tempStr);
pmst.setInt(2,tempINT.intValue());
tempINT=new Integer(rateStr);
pmst.setInt(3,tempINT.intValue());
paidrs=pmst.executeQuery();
countBln=paidrs.next();
System.out.println(" countBln "+countBln);
if(countBln){
while(countBln){
//--------------------------------------------------
int countselectInt=0;
int countstudentInt=0;
int vacInt=0;
boolean countselect=false;
vacInt=paidrs.getInt(1);
System.out.println(" vacancy id "+vacInt);
queryStr=" SELECT count(Resume_id) FROM Selected_candidate WHERE Post_id=? ";
selectpmst=con.prepareStatement(queryStr);
selectpmst.setInt(1,vacInt);
selectrs=selectpmst.executeQuery();
countselect=selectrs.next();
if(countselect){
countselectInt=selectrs.getInt(1);
System.out.println(" Resume selected "+countselectInt);
}
queryStr=" SELECT count(Student_approval) FROM selected_candidate WHERE Student_approval='y' and Post_id=? ";
studentpmst=con.prepareStatement(queryStr);
studentpmst.setInt(1,vacInt);
studentrs=studentpmst.executeQuery();
countselect=studentrs.next();
log(countselect+"countselect");
if(countselect){
countstudentInt=studentrs.getInt(1);
System.out.println(" student selected "+countstudentInt);
}
//--------------------------------------------------
%>
|
<%=countInt++ %>
|
<%= paidrs.getString(2) %> |
<%= paidrs.getString(3)%>
|
<%= paidrs.getString(4)%>
|
<%= paidrs.getString(5)%>
|
<%=countselectInt%> |
<%=countstudentInt%> |
<%
countBln=paidrs.next();
}// end of while loop
}//end of if loop for vacancy select
//------------------------
}//end of else if loop
//--------------------------------else ends -------------------------------
}//end of for loop
//===================================code to be added =======================
}//end of if loop check queryStr
}// end of if loop for paid services
else{
%>
|
Payment not made |
<%
}// end of else loop for not paid services
}//end of try
catch(Exception ex){
log(" ex "+ex);
System.out.println(" ex "+ex);
}
%>
<%
//-------------------------------Second Cut---------------------------------
}//end of if block for connection boolean
else{
%>
<%@ include file="jobsonline_connection.jsp" %>
<%
}//end of else block for connection boolean
}//end of try
catch(Exception ex){
}
finally{
try{
if (con!=null){
insert.freeConnection(con);
}
}
catch(Exception e){
}
}
//-------------------------------close of Second Cut---------------------------------
%>
Sign
out Back
|
|
|
|
