$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: Any correction in the printed hard copy of online form may be made by hand and initialled before dispatch or submission to the Commission, whereafter no request for change in any entry of online application or its hard copy shall be accepted.
Printout of the duly filled Online Form i.e. Hardcopy must be obtained. After signing hardcopy, copies of all documents/ certificates as mentioned in para 27 of the printed form along with original Treasury Receipt must be despatched so as to reach FPSC Headquarters, Islamabad within 10 days of online submission date of application, otherwise your candidature will be rejected. Onus of proof of dispatch of hardcopy of online form and documents, within date, shall solely lie on the candidate
Serial. No CSS Advertisement No Apply Date Optional Subjects Occupational Groups Print Preview
No Record Found
".$x." ".$CSS_JOB_TITLE." ".$date_applied." View View 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 CE23_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; } } ?>