$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"]; $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"]; $temp.=" "; if($CSS_ADVERT_ID == $adid) { $ch="checked"; } else { $ch=""; } $temp.=""; } $temp.="$norec
CSS Advertisements Application History
Serial. No CSS Advertisement No Apply Date Optional Subjects Occupational Groups Print Preview
No Record Found
".$x." ".$CSS_JOB_TITLE." ".$CSS_DATE." 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 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(){ global $conn,$userId; $temp=""; $aid=$_GET['userId_d']; //echo $aid; exit; if ($aid>0){ $display_sql= "select * from CSS_APP_GENERAL where CSS_APPLICANT_ID=$aid"; if($rs_display = OCIParse($conn, $display_sql)) { OCIExecute($rs_display); OCIFetchInto($rs_display, $row_display, OCI_ASSOC); $CSS_islamiat=$row_display["CSS_ISLAMIAT_EXCEPTION"]; if(strlen($CSS_islamiat)==0) $CSS_islamiat='No'; else $CSS_islamiat='Yes'; $CSS_APPLICANT_ID=$row_display["CSS_APPLICANT_ID"]; $CSS_APPLICATION_ID=$row_display["CSS_APPLICATION_ID"]; $CSS_APPLICANT_NAME=$row_display["CSS_APPLICANT_NAME"]; $CSS_FATHER_NAME=$row_display["CSS_FATHER_NAME"]; $CSS_SPOUSE_NAME=$row_display["CSS_SPOUSE_NAME"]; $CSS_SPOUSE_NATIONALITY=$row_display["CSS_SPOUSE_NATIONALITY"]; $CSS_NATIONALITY_STATUS=$row_display["CSS_NATIONALITY_STATUS"]; $CSS_APPLICANT_NATIONALITY=$row_display["CSS_APPLICANT_NATIONALITY"]; $CSS_OLD_NIC=$row_display["CSS_OLD_NIC"]; $CSS_NEW_NIC=$row_display["CSS_NEW_NIC"]; $CSS_GENDER=$row_display["CSS_GENDER"]; $CSS_MARITAL_STATUS=$row_display["CSS_MARITAL_STATUS"]; $CSS_RELIGION=$row_display["CSS_RELIGION"]; $CSS_DOB=$row_display["CSS_DOB"]; $CSS_AGE_RELAXATION=$row_display["CSS_AGE_RELAXATION"]; $CSS_DOMICILE=$row_display["CSS_DOMICILE"]; $GR_DISTRICT_DOMICILE=$row_display["CSS_DISTRICT_DOMICILE"]; $CSS_APPLICANT_EMAIL=$row_display["CSS_APPLICANT_EMAIL"]; $CSS_APPLICANT_PHONE_OFF=$row_display["CSS_APPLICANT_PHONE_OFF"]; $CSS_APPLICANT_PHONE_RES=$row_display["CSS_APPLICANT_PHONE_RES"]; $CSS_APPLICANT_FAX=$row_display["CSS_APPLICANT_FAX"]; $CSS_POSTAL_ADD1=$row_display["CSS_POSTAL_ADD1"]; $CSS_POSTAL_ADD2=$row_display["CSS_POSTAL_ADD2"]; $CSS_PARMANENT_ADD1=$row_display["CSS_PARMANENT_ADD1"]; $CSS_PARMANENT_ADD2=$row_display["CSS_PARMANENT_ADD2"]; $CSS_CENTER=$row_display["CSS_CENTER"]; $CSS_AGEREX1=$row_display["CSS_AGEREX1"]; $CSS_AGEREX2=$row_display["CSS_AGEREX2"]; $CSS_AGEREX3=$row_display["CSS_AGEREX3"]; $CSS_AGEREX4=$row_display["CSS_AGEREX4"]; $CSS_AGEREX5=$row_display["CSS_AGEREX5"]; $CSS_AGEREX6=$row_display["CSS_AGEREX6"]; $CSS_AGEREX7=$row_display["CSS_AGEREX7"]; $CSS_AGEREX8=$row_display["CSS_AGEREX8"]; /*if($aid!=0){ $jobid=returnfield("select CSS_RECIEPT_ID from CSS_JOB_RECIEPT where CSS_APPLICANT_ID=$aid","CSS_RECIEPT_ID"); if ($jobid!=0){ $postBPS=returnfield("select CSS_JOB_SCALE from CSS_JOB_POST where CSS_JOB_ID=$jobid","CSS_JOB_SCALE"); $postName=returnfield("select CSS_JOB_TITLE from CSS_JOB_POST where CSS_JOB_ID=$jobid","CSS_JOB_TITLE"); $ministryId=returnfield("select CSS_JOB_MINISTRY from CSS_JOB_POST where CSS_JOB_ID=$jobid","CSS_JOB_MINISTRY"); $ministryName=returnfield("select MINISTRY_NAME from CSS_MINISTRIES where MINISTRY_ID=$ministryId","MINISTRY_NAME"); $departmentId=returnfield("select CSS_JOB_DEPT from CSS_JOB_POST where CSS_JOB_ID=$jobid","CSS_JOB_DEPT"); $deptName=returnfield("select CSS_DEPARTMENT_NAME from CSS_MIN_DEPT where CSS_DEPARTMENT_ID=$departmentId","CSS_DEPARTMENT_NAME"); $advid=returnfield("select CSS_ADVERT_ID from CSS_JOB_POST where CSS_JOB_ID=$jobid","CSS_ADVERT_ID"); } if ($advid!=0){ $diaryNo=returnfield("select CSS_DIARY_NO from CSS_BATCH_DIARY where CSS_ADVERTISEMENT_ID=$advid","CSS_DIARY_NO"); $batchNo=returnfield("select CSS_BATCH_NO from CSS_BATCH_DIARY where CSS_ADVERTISEMENT_ID=$advid","CSS_BATCH_NO"); $advid=returnfield("select CSS_ADVERTISEMENT_NO from CSS_POST_ADVERTISEMENT where CSS_ADVERTISEMENT_ID=$advid","CSS_ADVERTISEMENT_NO"); } }*/ $rt="select * from DOMICILE where DOMICILE_CODE=$CSS_DOMICILE"; $tt=OCIParse($conn,$rt); OCIExecute($tt); OCIFetchInto($tt,$art,OCI_ASSOC); } } $temp.="
\"logo\" Website: www.fpsc.gov.pk
Email: fpsc@fpsc.gov.pk
Fax: 051-9213386-9203410
FEDERAL PUBLIC SERVICE COMMISSION
Sector F-5/1, Aga Khan Road,ISLAMABAD
 
Application Form No
$aid
Print Date:
$print_date
APPLICATION FORM
FOR RECRUITMENT TO BS-16 and ABOVE POSTS
For Official Use Only
 
To be filled by the Candidate
 
"; $sql = "SELECT CSS_PHOTO FROM CSS_APP_GENERAL where CSS_APPLICANT_ID=$aid"; $stmt = OCIParse ($conn, $sql); OCIExecute($stmt, OCI_DEFAULT); OCIFetchInto($stmt, $arr, OCI_ASSOC+OCI_RETURN_LOBS); $result = $arr['CSS_PHOTO']; if (strlen($result)>0) { $temp.=""; }else{ $temp.=""; } $temp.="
Receiving Stamp of FPSC
Application Fee Paid:"; if ($query_treasury['GR_AMOUNT']>0) { $temp.="   YES"; } else { $temp.="   NO"; } $temp.="
Original Treasury Receipt of Rs. ".$query_treasury['GR_AMOUNT']."
Treasury No. ".$query_treasury['GR_TREASURY_NO']."
Date ".$query_treasury['GR_DATE']."
Bank Name".$query_treasury['GR_BANK_NAME']."
Bank Branch Code
District of Bank Branch
 
Batch No.   Diary No.  
"; if($GR_DISTRICT_DOMICILE!=0){ $district_name=returnfield("select GR_DISTRICT from DISTRICT where GR_DISTRICT_ID=".$GR_DISTRICT_DOMICILE."","GR_DISTRICT"); } if($aid!=0){ $sql="select CSS_CENTER_ID from CSS_JOB_RECIEPT where CSS_APPLICANT_ID=".$aid." and CSS_ADVERTISEMENT_ID=".$_GET["jid"].""; $center_id=returnfield($sql,"CSS_CENTER_ID"); } if($center_id!=0){ $center_name=returnfield("select CENTER_NAME from CENTER where CENTER_ID=".$center_id."","CENTER_NAME"); } $temp.="
Personal Information
1) Name: (Write in Capital Letters and spell as per your Matriculation Certificate):
".$CSS_APPLICANT_NAME."
2) Father's/ Husband's Name (For female married candidates)
".$CSS_FATHER_NAME."
3) Date of Birth (Exact As per Matric. Certificate) ".$CSS_DOB." b) Age on Closing Date
4) (a)Religion ".$CSS_RELIGION." b) If Non-Muslim , whether desired to be examined in Islamiat".$CSS_islamiat."
5) (a)Gender ".$CSS_GENDER." b) Marital Status".$CSS_MARITAL_STATUS."
6) Postal Address    ".$CSS_POSTAL_ADD1.", ".$CSS_POSTAL_ADD2."
7) Permanent Address    ".$CSS_PARMANENT_ADD1.", ".$CSS_PARMANENT_ADD2."
Particulars about Spouse/Fiancee:-
8) (a) Age:- ".$CSS." b) Nationality".$CSS_APPLICANT_NATIONALITY."
  (c) Education:- d) Occupation:-".$CSS."
9) Examination Centre: ".$center_name."
10) (a)Domicile: ".$art['DOMICILE_NAME']." b) District of Domicile: ".$district_name."
11) Email: ".$CSS_APPLICANT_EMAIL." Phone Office: ".$CSS_APPLICANT_PHONE_OFF."
Phone Residence: ".$CSS_APPLICANT_PHONE_RES." Mobile No.: ".$CSS_."
12) CNIC No.    ".$CSS_NEW_NIC."
13) Age Relaxation Claimed: "; if($CSS_AGEREX1==1) $temp.="Not Claimed (Within Age limit)"; else $temp.="Yes Category: "; if($CSS_AGEREX1==2) $temp.="Govt. Servant including serving in Armed Forces"; if($CSS_AGEREX1==3) $temp.="Armed Forces Released / Retired Commissioned Officer/ Personnel."; if($CSS_AGEREX1==4) $temp.="Schedule Caste"; if($CSS_AGEREX1==5) $temp.="Budhist Community"; if($CSS_AGEREX1==6) $temp.="Azad Kashmir"; if($CSS_AGEREX1==7) $temp.="Northen Areas"; if($CSS_AGEREX1==8) $temp.="Recognized Tribal Areas"; if($CSS_AGEREX1==9) $temp.="Disabled Candidate
 
Applicant's Signature
Date
14) Education Record
"; OCIFreeStatement($rs_display); $display_sql= "select * from CSS_APP_EDUCATION where CSS_APPLICANT_ID=$aid"; //echo $display_sql; exit; $temp14.=""; if($rs_display = OCIParse($conn, $display_sql)) { $i=0; OCIExecute($rs_display); OCIFetchInto($rs_display, $row_display, OCI_ASSOC); do{ $i=$i+1; $CSS_EXAMINATION=$row_display["CSS_EXAMINATION"]; $CSS_DATE_RESULT=$row_display["CSS_DATE_RESULT"]; $CSS_GRADE=$row_display["CSS_GRADE"]; $CSS_CGP=$row_display["CSS_CGP"]; $CSS_DIVISION=$row_display["CSS_DIVISION"]; /* if (strlen($CSS_GRADE)>0) $gdc="Grade=".$CSS_GRADE; if (strlen($CSS_DIVISION)>0) $gdc="Division=".$CSS_DIVISION; if (intval($CSS_CGP)>0) $gdc="CGP=".$CSS_CGP; echo $gdc; */ if (strlen($CSS_GRADE)>0) $gdc="Grade:".$CSS_GRADE; if ($CSS_DIVISION!='NULL') $gdc="Div:".$CSS_DIVISION; if (intval($CSS_CGP)>0) $gdc="CGP:".$CSS_CGP; //echo $gdc; $CSS_UNIVERSITY_ID=$row_display["CSS_UNIVERSITY_ID"]; $CSS_BOARD_OTHER=$row_display["CSS_BOARD_OTHER"]; $CSS_LOCATION=$row_display["CSS_LOCATION"]; //echo $CSS_UNIVERSITY_ID; if ($CSS_UNIVERSITY_ID==""){ $University=0; }else{ $University=$CSS_UNIVERSITY_ID; } if(strlen(trim($University)) != '') { if(getUnviName($University)=='Other'){ $UnvIns=$Institute; }else{ $UnvIns=getUnviName($University); } } $CSS_ELIGIBLITY=$row_display["CSS_ELIGIBLITY"]; $CSS_START_DATE=$row_display["CSS_START_DATE"]; $CSS_END_DATE=$row_display["CSS_END_DATE"]; $CSS_MAJOR_SUBJECTS=$row_display["CSS_MAJOR_SUBJECTS"]; $CSS_ACADEMIC_AWARDS=$row_display["CSS_ACADEMIC_AWARDS"]; $CSS_EXTRA_ACTIVITIES=$row_display["CSS_EXTRA_ACTIVITIES"]; $temp14.=""; }while (OCIFetchInto($rs_display,$row_display,OCI_ASSOC)); } $temp14.="
S. No. School/ College/ University Location From To Examination Passed Date of Result Announccement Division
/Grade
/CGPA
Board/University Major Subjects Distinctions achieved/ Academic Awards ets. R/M/F
".$i."  ".$CSS_LOCATION."  ".$CSS_START_DATE."  ".$CSS_END_DATE."  ".$CSS_EXAMINATION."  ".$CSS_DATE_RESULT."  ".$gdc."  ".$UnvIns."  ".$CSS_MAJOR_SUBJECTS."  ".$CSS_ACADEMIC_AWARDS."  ".$CSS_ELIGIBLITY."
"; $temp.= $temp14; $temp.="
15) Employment Record
"; OCIFreeStatement($rs_display); $display_sql= "select * from CSS_APP_EMPLOYMENT where CSS_APPLICANT_ID=$aid"; //echo $display_sql; exit; $temp15.=""; if($rs_display = OCIParse($conn, $display_sql)) { $i=0; OCIExecute($rs_display); OCIFetchInto($rs_display, $row_display, OCI_ASSOC); do{ $i=$i+1; $CSS_POST_TITLE=$row_display["CSS_POST_TITLE"]; $CSS_DEPT_NAME=$row_display["CSS_DEPT_NAME"]; $CSS_MINISTRY_NAME=$row_display["CSS_MINISTRY_NAME"]; $CSS_FIRM_NAME=$row_display["CSS_FIRM_NAME"]; $CSS_FROM_DATE=$row_display["CSS_FROM_DATE"]; $CSS_TO_DATE=$row_display["CSS_TO_DATE"]; $CSS_ORGANIZATION_TYPE=$row_display["CSS_ORGANIZATION_TYPE"]; $CSS_JOB_STATUS=$row_display["CSS_JOB_STATUS"]; $CSS_BASIC_SCALE=$row_display["CSS_BASIC_SCALE"]; $temp15.=""; }while (OCIFetchInto($rs_display,$row_display,OCI_ASSOC)); } $temp15.="
S. No. Post and office held Name of Organiztion From To Type Of Organization Basic Scale / Grade
".$i." ".$CSS_POST_TITLE." ".$CSS_MINISTRY_NAME." ".$CSS_FROM_DATE." ".$CSS_TO_DATE." ".$CSS_ORGANIZATION_TYPE." ".$CSS_BASIC_SCALE."
"; $temp.=$temp15; $temp.="
16) Extra Activities
"; OCIFreeStatement($rs_display); //OCIFreeStatement($row_display); $display_sql= "select * from CSS_APP_EXTRA_CURRICULUM where CSS_APPLICANT_ID=$aid"; //echo $display_sql; exit; $temp.=""; if($rs_display = OCIParse($conn, $display_sql)) { //echo "----ahahahah"; $i=0; OCIExecute($rs_display); OCIFetchInto($rs_display, $row_display, OCI_ASSOC); do{ $i=$i+1; $CSS_FROM_DATES=$row_display["CSS_FROM_DATE"]; $CSS_TO_DATES=$row_display["CSS_TO_DATE"]; $CSS_ACTIVITIES=$row_display["CSS_EXTRA_CURRICULUM_ACT"]; //echo $CSS_FROM_DATES."---".$CSS_TO_DATES; $temp16.=""; }while (OCIFetchInto($rs_display,$row_display,OCI_ASSOC)); } $temp16.="
S. No. From Date To Date Extra Curricular Activities/ Sports/ Hobbies
".$i." ".$CSS_FROM_DATES." ".$CSS_TO_DATES." ".$CSS_ACTIVITIES."
"; $temp.=$temp16; $temp.="
17) Particulars about Parents
"; OCIFreeStatement($rs_display); $display_sql= "Select * from CSS_APP_PARENTS where CSS_APPLICANT_ID=$aid order by CSS_PARENT_NAME"; //echo $display_sql; exit; $temp2.=""; $i=0; if($rs_display = OCIParse($conn, $display_sql)) { //echo "you are in..."; OCIExecute($rs_display); OCIFetchInto($rs_display, $row_display, OCI_ASSOC); do{ $i=$i+1; $eid=$row_display["CSS_APPLICANT_PARENTS_IDS"]; $CSS_PARENT_TYPE=$row_display["CSS_PARENT_TYPE"]; $CSS_PARENT_AGE=$row_display["CSS_PARENT_AGE"]; $CSS_PARENT_QUALIFICATION=$row_display["CSS_PARENT_QUALIFICATION"]; $CSS_PARENT_OCCUPATION=$row_display["CSS_PARENT_OCCUPATION"]; $CSS_PARENT_OCC_BIRTH=$row_display["PARENT_OCCUPATION_BIRTH"]; $CSS_PARENT_ALIVE_DEAD=$row_display["PARENT_ALIVE_DEAD"]; $CSS_FAMILY_INCOME=$row_display["CSS_FAMILY_INCOME"]; $CSS_PARENT_OTHER_INCOME=$row_display["OTHER_SOURCE"]; $temp2.=" "; }while (OCIFetchInto($rs_display,$row_display,OCI_ASSOC)); } $temp2.="
S No. Parent Age Qualification Occupation/ Designation Present Occupation/ Designation (at time of your birth) Alive or Dead Annual Income Other Source of income/ supporting income
".$i." ".$CSS_PARENT_TYPE." ".$CSS_PARENT_AGE." ".$CSS_PARENT_QUALIFICATION." ".$CSS_PARENT_OCCUPATION." ".$CSS_PARENT_OCC_BIRTH." ".$CSS_PARENT_ALIVE_DEAD." ".$CSS_FAMILY_INCOME." ".$CSS_PARENT_OTHER_INCOME."
"; $temp.=$temp2; $temp.="
19) Languages Information
"; OCIFreeStatement($rs_display); $display_sql= "Select * from CSS_APP_LANGUAGE where CSS_APPLICANT_ID=$aid order by CSS_APPLICANT_LANGUAGE_ID desc"; //echo $display_sql;// exit; $temp22.=""; $i=0; if($rs_display = OCIParse($conn, $display_sql)) { OCIExecute($rs_display); OCIFetchInto($rs_display, $row_display, OCI_ASSOC); do{ $i=$i+1; $CSS_LANGUAGE=$row_display["CSS_LANGUAGE"]; $CSS_READ=$row_display["CSS_READ"]; $CSS_WRITE=$row_display["CSS_WRITE"]; $CSS_SPEAK=$row_display["CSS_SPEAK"]; $CSS_DIPLOMA=$row_display["CSS_DIPLOMA"]; if (strlen($CSS_DIPLOMA)=='') $CSS_DIPLOMA=" "; $temp22.=""; }while (OCIFetchInto($rs_display,$row_display,OCI_ASSOC)); } $temp22.="
S. No Name of Language Ability Certificate/Diploma. If any
Read Write Speak
".$i." ".$CSS_LANGUAGE." ".$CSS_READ." ".$CSS_WRITE." ".$CSS_SPEAK." ".$CSS_DIPLOMA."
"; $temp.=$temp22; $temp.="
20) Brothers/ Sisters Information
"; OCIFreeStatement($rs_display); $display_sql= "select * from CSS_APP_BROTHERS_SISTERS where CSS_APPLICANT_ID=$aid"; //echo $display_sql; exit; $temp122.=""; if($rs_display = OCIParse($conn, $display_sql)) { $i=0; OCIExecute($rs_display); OCIFetchInto($rs_display, $row_display, OCI_ASSOC); do{ $i=$i+1; $CSS_APP_BROTHERS_SISTERS_IDS=$row_display["CSS_APP_BROTHERS_SISTERS_IDS"]; $CSS_NAME=$row_display["CSS_NAME"]; $CSS_EXAMINATION=$row_display["CSS_EXAMINATION"]; $CSS_AGE=$row_display["CSS_AGE"]; $CSS_OCCUPATION=$row_display["CSS_OCCUPATION"]; $CSS_BROTHER_OR_SISTER=$row_display["CSS_BROTHER_OR_SISTER"]; $temp122.=""; }while (OCIFetchInto($rs_display,$row_display,OCI_ASSOC)); } $temp122.="
S. No. Name B,S,SB,SS OR X Age Occupation Education
".$i." ".$CSS_NAME." ".$CSS_BROTHER_OR_SISTER." ".$CSS_AGE." ".$CSS_OCCUPATION." ".$CSS_EXAMINATION."
"; $temp.=$temp122; $temp.="
21) Near Relations Information
"; OCIFreeStatement($rs_display); $display_sql= "Select * from CSS_APP_RELATIVE where CSS_APPLICANT_ID=$aid order by CSS_NAME"; //echo $display_sql; $temp3.=""; if($rs_display = OCIParse($conn, $display_sql)) { OCIExecute($rs_display); OCIFetchInto($rs_display, $row_display, OCI_ASSOC); $i=0; do{ $i=$i+1; $CSS_APPLICANT_RELATIVE_IDS = $row_display["CSS_APPLICANT_RELATIVE_IDS"]; $CSS_NAME = $row_display["CSS_NAME"]; $CSS_RELATIONSHIP = $row_display["CSS_RELATIONSHIP"]; $CSS_DEPARTMENT = $row_display["CSS_DEPARTMENT"]; $CSS_PLACE_DUTY = $row_display["CSS_PLACE_DUTY"]; $temp3.=" "; }while (OCIFetchInto($rs_display,$row_display,OCI_ASSOC)); } $temp3.="
S. No. Name of Relative Relationship Post held/ Department Place of duty
".$i." ". $CSS_NAME." ".$CSS_RELATIONSHIP." ".$CSS_DEPARTMENT." ".$CSS_PLACE_DUTY."
"; $temp.=$temp3; $temp.="
22) Detail of previous attempt for Competitive Examinations (CSS)
"; OCIFreeStatement($rs_display); $display_sql= "Select * from CSS_APP_PRE_ATTEMPT where CSS_APPLICANT_ID=$aid"; $temp4.=""; if($rs_display = OCIParse($conn, $display_sql)) { OCIExecute($rs_display); OCIFetchInto($rs_display, $row_display, OCI_ASSOC); $i=0; do{ $i=$i+1; $CSS_APP_PRE_CSS_IDS = $row_display["CSS_APP_PRE_CSS_IDS"]; $CSS_APP_YEAR = $row_display["CSS_APP_YEAR"]; $CSS_APP_ROLL_NO = $row_display["CSS_APP_ROLL_NO"]; $CSS_APP_RESULT = $row_display["CSS_APP_RESULT"]; $CSS_APP_DISCIPLINE = $row_display["CSS_APP_DISCIPLINE"]; $CSS_APP_EXAMINATION = $row_display["CSS_APP_EXAMINATION"]; $temp4.=" "; }while (OCIFetchInto($rs_display,$row_display,OCI_ASSOC)); } $temp4.="
S. No. Year Roll No. Examination Result
".$i." ".$CSS_APP_YEAR." ".$CSS_APP_ROLL_NO." ".$CSS_APP_EXAMINATION." ".$CSS_APP_RESULT."
"; $temp.=$temp4; $temp.="
23) Disciplinary Action/ Conviction
"; OCIFreeStatement($rs_display); $display_sql= "Select CSS_APP_DISCIPLINE from CSS_APP_PRE_ATTEMPT where CSS_APPLICANT_ID=$aid"; //echo $display_sql; exit; $temp133.=""; if($rs_display = OCIParse($conn, $display_sql)) { $i=0; OCIExecute($rs_display); OCIFetchInto($rs_display, $row_display, OCI_ASSOC); do{ $i=$i+1; $CSS_APP_DISCIPLINE=$row_display["CSS_APP_DISCIPLINE"]; $temp133.=""; }while (OCIFetchInto($rs_display,$row_display,OCI_ASSOC)); } $temp133.="
". strtoupper($CSS_APP_DISCIPLINE)."
"; $temp.=$temp133; $temp.="
24) Optional Subjects (600 Marks)
"; OCIFreeStatement($rs_display); $temp166.=""; $sql="select a.*,b.* from CSS_SUBJECT_CHOOSED a,CSS_APP_SUBJECT b where CSS_APPLICANT_ID=$aid and a.CSS_SUBJECT_ID=b.CSS_SUBJECT_ID and CSS_ADVERTISEMENT_ID=$_GET[jid]"; //echo $sql; exit; $rs = OCIParse($conn,$sql); OCIExecute($rs); while(OCIFetchInto($rs,$arr,OCI_ASSOC)) { $temp166.=""; $temp166.=""; } $temp166.="
Subjects (Code No) Subjects Marks
$arr[CSS_SUBJECT_ID] $arr[CSS_SUBJECTS] $arr[CSS_SUBJECT_MARKS]
"; for($j=0;$j<10;$j++) { $counter[$j]=""; } $sql3="select * from CSS_OCC_SELECTION where CSS_APPLICANT_ID=$aid and CSS_ADVERTISEMENT_ID=$_GET[jid]"; $rs3=OCIParse($conn,$sql3); OCIExecute($rs3); OCIFetchInto($rs3,$arr3,OCI_ASSOC); $sqle="select * from CSS_OCC_GROUPS"; $rse=OCIParse($conn,$sqle); OCIExecute($rse); $count=1; $temp166.="
"; while(OCIFetchInto($rse,$arre,OCI_ASSOC)) { if($arr3["CSS_OCC1_ID"]==$arre["CSS_GROUP_ID"]) { $counter["pos1"]=$arre["CSS_GROUP_NAME"]; } if($arr3["CSS_OCC2_ID"]==$arre["CSS_GROUP_ID"]) { $counter["pos2"]=$arre["CSS_GROUP_NAME"]; } if($arr3["CSS_OCC3_ID"]==$arre["CSS_GROUP_ID"]) { $counter["pos3"]=$arre["CSS_GROUP_NAME"]; } if($arr3["CSS_OCC4_ID"]==$arre["CSS_GROUP_ID"]) { $counter["pos4"]=$arre["CSS_GROUP_NAME"]; } if($arr3["CSS_OCC5_ID"]==$arre["CSS_GROUP_ID"]) { $counter["pos5"]=$arre["CSS_GROUP_NAME"]; } if($arr3["CSS_OCC6_ID"]==$arre["CSS_GROUP_ID"]) { $counter["pos6"]=$arre["CSS_GROUP_NAME"]; } if($arr3["CSS_OCC7_ID"]==$arre["CSS_GROUP_ID"]) { $counter["pos7"]=$arre["CSS_GROUP_NAME"]; } if($arr3["CSS_OCC8_ID"]==$arre["CSS_GROUP_ID"]) { $counter["pos8"]=$arre["CSS_GROUP_NAME"]; } if($arr3["CSS_OCC9_ID"]==$arre["CSS_GROUP_ID"]) { $counter["pos9"]=$arre["CSS_GROUP_NAME"]; } if($arr3["CSS_OCC10_ID"]==$arre["CSS_GROUP_ID"]) { $counter["pos10"]=$arre["CSS_GROUP_NAME"]; } } for($i=1;$i<=10;$i++) { $p="pos".$i; $temp166.="
25) CSS Applicant Occupational Groups.

"; } $temp166.="
$i. ".$counter["pos".$i]."
"; $temp.=$temp166; $temp.="
"; return $temp; } 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; } } ?>