$value) { $$key = $value; } if ($a =='Apply'){ $v = verifyForm(); if ($v == 1) { insert_data($conn); ?>

  "; echo advertjobs(); } ?>
:: Application History
"; $get_rs = OCIParse($conn, $get_jobs); OCIExecute($get_rs); if(!$get_rs) { $norec=""; } $bcolor="#FFFFFF"; $x=0; while (OCIFetchInto($get_rs,$get_row, OCI_ASSOC)) { $x=$x+1; if($bcolor == "#FFFFFF") { $bcolor="#F4F4F4"; } else { $bcolor="#FFFFFF"; } $CSS_JOB_ID=$get_row["CSS_JOB_ID"]; $adver=$get_row["CSS_ADVERTISEMENT_ID"]; $date_applied=$get_row["DATE_APPLIED"]; $CSS_DATE=$get_row["CSS_DATE"]; $eexp=explode("12.",$CSS_DATE); $CSS_DATE=$eexp[0]; $CSS_JOB_TITLE=$get_row["CSS_ADVERTISEMENT_NO"]; $PYEAR=$get_row["PYEAR"]; $_SESSION["parentid"]=$get_row["CSS_APPLICANT_ID"]; $temp.=" "; if($CSS_ADVERT_ID == $adid) { $ch="checked"; } else { $ch=""; } $temp.=""; } $temp.="$norec
CSS Advertisements Application History
Important Note: No need to send Online Printout of MPT Application Form to FPSC. This is for your record only.
Serial. No CSS Advertisement No Apply Date Print Preview
No Record Found
".$x." ".$CSS_JOB_TITLE." ".$date_applied." Print View
"; return $temp; } function displayJobTitle($jobId){ return ""; } function jobsdetail() { global $conn,$jobid; $jobid=$_GET["jobid"]; $det_jobs="select j.CSS_JOB_TITLE,j.CSS_JOB_VACANCIES,j.CSS_JOB_EXP,j.CSS_JOB_GRADE, m.MINISTRY_NAME,j.CSS_JOB_DEPT,j.CSS_JOB_MAX_AGE,c.CITY_NAME,trim(to_char(j.CSS_JOB_POST_DATE,'YYYY')) as PYEAR, trim(to_char(j.CSS_JOB_CLOSE_DATE,'DD')) || '-' || trim(to_char(j.CSS_JOB_CLOSE_DATE,'MM')) || '-' || trim(to_char(j.CSS_JOB_CLOSE_DATE,'YYYY')) as CDATE from CSS_JOB_POST j, CSS_MINISTRIES m, CSS_CITY c where j.CSS_JOB_PLACE=c.CITY_ID and j.CSS_JOB_MINISTRY=m.MINISTRY_ID and j.CSS_JOB_ID=$jobid"; //echo $det_jobs; exit; $temp=""; $det_rs = OCIParse($conn, $det_jobs); OCIExecute($det_rs); OCIFetchInto($det_rs,$det_row, OCI_ASSOC); $CSS_JOB_TITLE=$det_row["CSS_JOB_TITLE"]; $MINISTRY_NAME=$det_row["MINISTRY_NAME"]; $CSS_JOB_DEPT=$det_row["CSS_JOB_DEPT"]; $CSS_JOB_MAX_AGE=$det_row["CSS_JOB_MAX_AGE"]; $CITY_NAME=$det_row["CITY_NAME"]; $CSS_JOB_VACANCIES=$det_row["CSS_JOB_VACANCIES"]; $CSS_JOB_EXP=$det_row["CSS_JOB_EXP"]; $CSS_JOB_GRADE=$det_row["CSS_JOB_GRADE"]; $CDATE=$det_row["CDATE"]; $PYEAR=$det_row["PYEAR"]; $dept_sql="select CSS_DEPARTMENT_NAME from CSS_MIN_DEPT where CSS_DEPARTMENT_ID=$CSS_JOB_DEPT"; $dept_rs = OCIParse($conn, $dept_sql); OCIExecute($dept_rs); OCIFetchInto($dept_rs,$dept_row, OCI_ASSOC); $CSS_DEPARTMENT_NAME=$dept_row["CSS_DEPARTMENT_NAME"]; $temp.="
Job Description
Job Title:
".$CSS_JOB_TITLE."
Ministry/Deoartment:
".$MINISTRY_NAME."/".$CSS_DEPARTMENT_NAME."
Grade:
BS-".$CSS_JOB_GRADE."
Max Age:
".$CSS_JOB_MAX_AGE."
Closing Date:
".$CDATE."
Job Placing:
".$CITY_NAME."
Job Description:
".$CSS_JOB_EXP."
 
"; echo $temp; } function ViewApplicantDetail1(){} function getUnviName($uId){ global $conn; $role_sql ="select GR_UNIVERSITY_ID, GR_UNIVERSITY_NAME from GR_board_university where GR_UNIVERSITY_ID=$uId"; //echo $role_sql; echo "
"; $rs1 = OCIParse($conn, $role_sql); OCIExecute($rs1); OCIFetchInto($rs1, $row1, OCI_ASSOC); if($row1["GR_UNIVERSITY_ID"]>0) { $uName =$row1["GR_UNIVERSITY_NAME"] ; }else{ $uName = ''; } OCIFreeStatement($rs1); return $uName; } function returnfield($sql,$fieldname) { global $conn; $mysql=$sql; //cho $mysql; $rs1 = OCIParse($conn, $mysql); OCIExecute($rs1); OCIFetchInto($rs1, $row1, OCI_ASSOC); if(strlen($row1[$fieldname]) > 0) { $returnfield = $row1[$fieldname]; } OCIFreeStatement($rs1); return $returnfield; } function displayJobFormat($jobId){ global $conn; if ($jobId>0){ $jobs_sql="select CSS_JOB_ID,CSS_JOB_TITLE ,trim(to_char(CSS_JOB_POST_DATE,'YYYY')) as PYEAR from CSS_JOB_POST where CSS_JOB_ID=$jobId"; // echo $jobs_sql; $det_rs = OCIParse($conn, $jobs_sql); OCIExecute($det_rs); OCIFetchInto($det_rs,$det_row, OCI_ASSOC); if ($det_row["CSS_JOB_ID"]>0){ $CSS_JOB_TITLE="F4-".$det_row["CSS_JOB_ID"]."/".$det_row["PYEAR"]."-R"; }else{ $CSS_JOB_TITLE="No Job Found"; } return $CSS_JOB_TITLE; } } ?>