$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_RELIGION=$row_display["CSS_RELIGION"]; $CSS_islamiat=$row_display["CSS_ISLAMIAT_EXCEPTION"]; if($CSS_RELIGION == 'Muslim') { if(strlen($CSS_islamiat)==0) $CSS_islamiat=' '; else $CSS_islamiat='Yes'; } if($CSS_RELIGION == 'Non Muslim') { 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"]; $PSYCHOLOGICAL_TEST=$row_display["PSYCHOLOGICAL_TEST"]; $PSYCHOLOGICAL_CENTRE=$row_display["PSYCHOLOGICAL_CENTRE"]; $CSS_APPLICANT_MOBILE=$row_display["CSS_APPLICANT_MOBILE"]; $CSS_APP_DISCIPLINE=$row_display["CSS_APP_DISCIPLINE"]; $CSS_SPOUSE_AGE=$row_display["CSS_SPOUSE_AGE"]; $CSS_SPOUSE_EDUCATION=$row_display["CSS_SPOUSE_EDUCATION"]; $CSS_SPOUSE_OCCUPATION=$row_display["CSS_SPOUSE_OCCUPATION"]; $CSS_SPOUSE_DESIGNATION=$row_display["CSS_SPOUSE_DESIGNATION"]; $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_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"); } }*/ $query_tr="select * from css_job_reciept where css_applicant_id=$aid"; $query_tr1=OCIParse($conn,$query_tr); OCIExecute($query_tr1); OCIFetchInto($query_tr1,$query_treasury,OCI_ASSOC); $print_date=returnfield("select sysdate as PRINT_DATE from dual","PRINT_DATE"); $rt="select * from DOMICILE where DOMICILE_CODE=$CSS_DOMICILE"; $tt=OCIParse($conn,$rt); OCIExecute($tt); OCIFetchInto($tt,$art,OCI_ASSOC); } } $sql_year= "select distinct pa.css_advertisement_no from css_post_advertisement pa, css_app_general ag, css_job_reciept jr where ag.css_applicant_id = jr.css_applicant_id and jr.css_advertisement_id = pa.css_advertisement_id and ag.css_applicant_id =$aid"; $rs_display_date=OCIParse($conn, $sql_year); OCIExecute($rs_display_date); OCIFetchInto($rs_display_date, $rs_display_date_display, OCI_ASSOC); $date_display= $rs_display_date_display['CSS_ADVERTISEMENT_NO']; //echo $rs_display_date_display['CSS_ADVERTISEMENT_NO'];exit; $temp.="
\"logo\" Website: www.fpsc.gov.pk
Email: examination@fpsc.gov.pk
UAN: 051-111-000-248
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 COMPETITIVE EXAMINATION (CSS) - $date_display
For Official Use Only
  
To be filled by the Candidate
  
Please
Receiving Stamp of FPSC
 Application Fee Paid:"; if ($query_treasury['CSS_AMOUNT']>0) { $temp.="   YES"; } else { $temp.="   NO"; } $temp.="
Original Treasury Receipt of Rs. ".$query_treasury['CSS_AMOUNT']."
Treasury No. ".$query_treasury['CSS_TREASURY_NO']."
Treasury Receipt Date ".$query_treasury['CSS_DATE']."
Bank Name".$query_treasury['CSS_BANK_NAME']."
"; $branch_code_id = $query_treasury['BANK_DISTRICT_ID']; $query_br = "select GR_DISTRICT from district where GR_DISTRICT_ID=$branch_code_id"; //echo $query_br; exit; $query_br1=OCIParse($conn,$query_br); OCIExecute($query_br1); OCIFetchInto($query_br1,$query_branch_code,OCI_ASSOC); $temp.="District of Bank Branch ".$query_branch_code['GR_DISTRICT']."
"; $temp.="Bank Branch Code ".$query_treasury['CSS_BANK_CODE']."
 
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: (In capital letters as per Matriculation Certificate): ".$CSS_APPLICANT_NAME."
2) (a)  Father's Name: ".$CSS_FATHER_NAME."  
2) (b)  Husband's Name (In case of married female candidates): ".$CSS_SPOUSE_NAME."  
3)  Date of Birth(As per Matric. Certificate/ CE Rules) ".$CSS_DOB."    
4)    CNIC No: ".$CSS_NEW_NIC."
5)  (a)Religion ".$CSS_RELIGION." b)If Non-Muslim, whether desired to be examined in Islamiat  ".$CSS_islamiat."
6)  (a)Gender ".$CSS_GENDER." b) Marital Status ".$CSS_MARITAL_STATUS."
7)  Postal Address ".$CSS_POSTAL_ADD1.", ".$CSS_POSTAL_ADD2."
8)  Permanent Address ".$CSS_PARMANENT_ADD1.", ".$CSS_PARMANENT_ADD2."
9)  Particulars about Spouse/Fiancee:-
(a) Age:- ".$CSS_SPOUSE_AGE." b) Nationality ".$CSS_SPOUSE_NATIONALITY."
  (c) Education:- ".$CSS_SPOUSE_EDUCATION." d) Occupation: ".$CSS_SPOUSE_OCCUPATION."
10)  Examination Centre: ".$center_name."
11)  (a)Domicile: ".$art['DOMICILE_NAME']." b) District of Domicile: ".$district_name."
12)  (a)Email: ".$CSS_APPLICANT_EMAIL." b)Phone Office:  ".$CSS_APPLICANT_PHONE_OFF."
(c)Phone Residence: ".$CSS_APPLICANT_PHONE_RES." d)Mobile No.:  ".$CSS_APPLICANT_MOBILE."
13)    Age Relaxation Claimed: "; if($CSS_AGEREX1=='00') $temp.="Not Claimed (Within Age limit)"; //changes made as of applicationdetail.php 26-09-2013 if($CSS_AGEREX1=='01') $temp.="Government Employee (In Service)"; if($CSS_AGEREX1=='02') $temp.="Armed Forces (In Service)"; if($CSS_AGEREX1=='03') $temp.="Scheduled Caste"; if($CSS_AGEREX1=='04') $temp.="Budhist Community"; if($CSS_AGEREX1=='05') $temp.="Azad Kashmir"; if($CSS_AGEREX1=='06') $temp.="Gilgit - Baltistan"; if($CSS_AGEREX1=='07') $temp.="Recognized Tribes/Tribal Area"; if($CSS_AGEREX1=='08') $temp.="Disabled Candidate"; $temp.="
 
 
Applicant's Signature
Date

14) Education Record
"; OCIFreeStatement($rs_display); $display_sql= "select * from CSS_APP_EDUCATION where CSS_APPLICANT_ID=$aid order by css_start_date"; //echo $display_sql; exit; $temp14.=""; if($rs_display = OCIParse($conn, $display_sql)) { $i=0; OCIExecute($rs_display); OCIFetchInto($rs_display, $row_display10, OCI_ASSOC); do{ $i=$i+1; $CSS_EXAMINATION=$row_display10["CSS_EXAMINATION"]; $CSS_DATE_RESULT=$row_display10["CSS_DATE_RESULT"]; $CSS_GRADE=$row_display10["CSS_GRADE"]; $CSS_CGP=$row_display10["CSS_CGP"]; $CSS_DIVISION=$row_display10["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_display10["CSS_UNIVERSITY_ID"]; $CSS_BOARD_OTHER=$row_display10["CSS_BOARD_OTHER"]; $CSS_LOCATION=$row_display10["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_display10["CSS_ELIGIBLITY"]; $CSS_START_DATE=$row_display10["CSS_START_DATE"]; $CSS_END_DATE=$row_display10["CSS_END_DATE"]; $CSS_MAJOR_SUBJECTS=$row_display10["CSS_MAJOR_SUBJECTS"]; $CSS_ACADEMIC_AWARDS=$row_display10["CSS_ACADEMIC_AWARDS"]; $CSS_EXTRA_ACTIVITIES=$row_display10["CSS_EXTRA_ACTIVITIES"]; $temp14.=""; }while (OCIFetchInto($rs_display,$row_display10,OCI_ASSOC)); } $temp14.="
S.No. School/ College/ University Location From Date To Date 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) Extra Curricular Activities/Sports/Hobbies
"; OCIFreeStatement($rs_display); //OCIFreeStatement($row_display); $display_sql= "select distinct t.css_from_date, t.css_to_date, t.css_extra_curriculum_act, t.css_applicant_id, t.css_parent_id, t.ntcflag from CSS_APP_EXTRA_CURRICULUM t where CSS_APPLICANT_ID=$aid order by css_from_date"; //echo $display_sql; exit; $temp.=""; if($rs_display = OCIParse($conn, $display_sql)) { //echo "----ahahahah"; $i=0; OCIExecute($rs_display); OCIFetchInto($rs_display, $row_display12, OCI_ASSOC); do{ $i=$i+1; $CSS_FROM_DATES=$row_display12["CSS_FROM_DATE"]; $CSS_TO_DATES=$row_display12["CSS_TO_DATE"]; $CSS_ACTIVITIES=$row_display12["CSS_EXTRA_CURRICULUM_ACT"]; //echo $CSS_FROM_DATES."---".$CSS_TO_DATES; $temp16.=""; }while (OCIFetchInto($rs_display,$row_display12,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.="
16) Disciplinary Action/ Conviction ".$CSS_APP_DISCIPLINE."

"; $temp.="
17) Employment Record
"; OCIFreeStatement($rs_display); $display_sql= "select distinct t.css_post_title, t.css_dept_name, t.css_ministry_name, t.css_firm_name, t.css_firm_address, t.css_from_date, t.css_to_date, t.css_organization_type, t.css_job_status, t.css_basic_scale, t.css_applicant_id, t.css_parent_id, t.roll_no, t.year, t.ntcflag from CSS_APP_EMPLOYMENT t where CSS_APPLICANT_ID=$aid order by css_from_date"; //echo $display_sql; exit; $temp15.=""; if($rs_display = OCIParse($conn, $display_sql)) { $i=0; OCIExecute($rs_display); OCIFetchInto($rs_display, $row_display11, OCI_ASSOC); do{ $i=$i+1; $CSS_POST_TITLE=$row_display11["CSS_POST_TITLE"]; $CSS_DEPT_NAME=$row_display11["CSS_DEPT_NAME"]; $CSS_MINISTRY_NAME=$row_display11["CSS_MINISTRY_NAME"]; $CSS_FIRM_NAME=$row_display11["CSS_FIRM_NAME"]; $CSS_FROM_DATE=$row_display11["CSS_FROM_DATE"]; $CSS_TO_DATE=$row_display11["CSS_TO_DATE"]; $CSS_ORGANIZATION_TYPE=$row_display11["CSS_ORGANIZATION_TYPE"]; $CSS_JOB_STATUS=$row_display11["CSS_JOB_STATUS"]; $CSS_BASIC_SCALE=$row_display11["CSS_BASIC_SCALE"]; $temp15.=""; }while (OCIFetchInto($rs_display,$row_display11,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.="
18) Languages Information
"; OCIFreeStatement($rs_display); $display_sql= "select distinct t.css_applicant_id, t.css_language, t.css_read, t.css_write, t.css_speak, t.css_diploma, t.css_diploma_duration, t.css_parent_id, t.roll_no, t.year from CSS_APP_LANGUAGE t where CSS_APPLICANT_ID=$aid order by t.css_language desc"; //echo $display_sql;// exit; $temp22.=""; $i=0; if($rs_display = OCIParse($conn, $display_sql)) { OCIExecute($rs_display); OCIFetchInto($rs_display, $row_display14, OCI_ASSOC); do{ $i=$i+1; $CSS_LANGUAGE=$row_display14["CSS_LANGUAGE"]; $CSS_READ=$row_display14["CSS_READ"]; $CSS_WRITE=$row_display14["CSS_WRITE"]; $CSS_SPEAK=$row_display14["CSS_SPEAK"]; $CSS_DIPLOMA=$row_display14["CSS_DIPLOMA"]; if (strlen($CSS_DIPLOMA)=='') $CSS_DIPLOMA=" "; $temp22.=""; }while (OCIFetchInto($rs_display,$row_display14,OCI_ASSOC)); } $temp22.="
S.No. Name of Language Read Write Speak Certificate/Diploma. If any
".$i." ".$CSS_LANGUAGE." ".$CSS_READ." ".$CSS_WRITE." ".$CSS_SPEAK." ".$CSS_DIPLOMA."
"; $temp.=$temp22; $temp.="

19) Near Relations Information
"; OCIFreeStatement($rs_display); $display_sql= "select distinct t.css_applicant_id, t.css_name, t.css_relationship, t.css_position, t.css_department, t.css_department, t.css_place_duty, t.css_parent_id from CSS_APP_RELATIVE t 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_display16, OCI_ASSOC); $i=0; do{ $i=$i+1; $CSS_APPLICANT_RELATIVE_IDS = $row_display16["CSS_APPLICANT_RELATIVE_IDS"]; $CSS_NAME = $row_display16["CSS_NAME"]; $CSS_RELATIONSHIP = $row_display16["CSS_RELATIONSHIP"]; $CSS_DEPARTMENT = $row_display16["CSS_DEPARTMENT"]; $CSS_PLACE_DUTY = $row_display16["CSS_PLACE_DUTY"]; $temp3.=""; }while (OCIFetchInto($rs_display,$row_display16,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.="
20) 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; $rs111 = OCIParse($conn,$sql); OCIExecute($rs111); while(OCIFetchInto($rs111,$arr111,OCI_ASSOC)) { $temp166.=""; } $temp166.="
Subjects (Code No) Subjects Marks
$arr111[CSS_SUBJECT_ID] $arr111[CSS_SUBJECTS] $arr111[CSS_SUBJECT_MARKS]
"; $temp.=$temp166; $temp.="
21) Disability Claimed
"; OCIFreeStatement($rs111); $display_sql_dis= "Select distinct t.css_disablity_type, t.css_disablity_ass_writer, t.css_disablity_ass_comp, t.css_applicant_id, t.css_parent_id from css_app_disability t where CSS_APPLICANT_ID=$aid"; //echo $display_sql; exit; if($rs_display = OCIParse($conn, $display_sql_dis)) { //echo "you are in..."; OCIExecute($rs_display); OCIFetchInto($rs_display, $row_display1357, OCI_ASSOC); $CSS_DISABILITY_TYPE=$row_display1357["CSS_DISABLITY_TYPE"]; $CSS_DISABLITY_ASS_WRITER=$row_display1357["CSS_DISABLITY_ASS_WRITER"]; $CSS_DISABLITY_ASS_COMP=$row_display1357["CSS_DISABLITY_ASS_COMP"]; } $temp2357.="
Disability Claimed: $CSS_DISABILITY_TYPE Helper/Writer/Computer Required?  "; if($CSS_DISABLITY_ASS_WRITER == 1 && $CSS_DISABLITY_ASS_COMP == 1) { $temp2357.="Helper/Writer and Computer"; } else { if($CSS_DISABLITY_ASS_WRITER == 1) { $temp2357.=" Helper/Writer"; } if($CSS_DISABLITY_ASS_COMP == 1) { $temp2357.=" Computer"; } } $temp2357.="
"; /* } else { $temp2357.="NO   "; } */ $temp.=$temp2357; $temp.="
22) Particulars about Parents
"; OCIFreeStatement($rs_display); $display_sql= "select distinct t.css_parent_qualification, t.css_parent_occupation, t.css_family_income, t.css_parent_type, t.css_parent_name, t.css_parent_age, t.css_applicant_id, t.css_parent_id, t.parent_occupation_birth, t.parent_alive_dead, t.other_source, decode(t.alive_dead, 'No','Alive', 'Yes','Dead') alive_dead from css_app_parents t 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_display13, OCI_ASSOC); do{ $i=$i+1; $eid=$row_display13["CSS_APPLICANT_PARENTS_IDS"]; $CSS_PARENT_TYPE=$row_display13["CSS_PARENT_TYPE"]; $CSS_PARENT_AGE=$row_display13["CSS_PARENT_AGE"]; $CSS_PARENT_QUALIFICATION=$row_display13["CSS_PARENT_QUALIFICATION"]; $CSS_PARENT_OCCUPATION=$row_display13["CSS_PARENT_OCCUPATION"]; $CSS_PARENT_OCC_BIRTH=$row_display13["PARENT_OCCUPATION_BIRTH"]; $CSS_PARENT_ALIVE_DEAD=$row_display13["ALIVE_DEAD"]; $CSS_FAMILY_INCOME=$row_display13["CSS_FAMILY_INCOME"]; $CSS_PARENT_OTHER_INCOME=$row_display13["OTHER_SOURCE"]; $temp2.=" "; }while (OCIFetchInto($rs_display,$row_display13,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; //Disability area $temp.="
23) Brothers/ Sisters Information
"; OCIFreeStatement($rs_display); $display_sql= "select distinct t.css_examination, t.css_age, t.css_occupation, t.css_brother_or_sister, t.css_name, t.css_parent_id from css_app_brothers_sisters t 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_display15, OCI_ASSOC); do{ $i=$i+1; $CSS_APP_BROTHERS_SISTERS_IDS=$row_display15["CSS_APP_BROTHERS_SISTERS_IDS"]; $CSS_NAME=$row_display15["CSS_NAME"]; $CSS_EXAMINATION=$row_display15["CSS_EXAMINATION"]; $CSS_AGE=$row_display15["CSS_AGE"]; $CSS_OCCUPATION=$row_display15["CSS_OCCUPATION"]; $CSS_BROTHER_OR_SISTER=$row_display15["CSS_BROTHER_OR_SISTER"]; $temp122.=""; }while (OCIFetchInto($rs_display,$row_display15,OCI_ASSOC)); } $temp122.="
S.No. Name Relationship Age Occupation Education
".$i." ".$CSS_NAME." ".$CSS_BROTHER_OR_SISTER." ".$CSS_AGE." ".$CSS_OCCUPATION." ".$CSS_EXAMINATION."
"; $temp.=$temp122; $temp.="
24) Detail of previous attempt for Competitive Examinations (CSS)
"; OCIFreeStatement($rs_display); $display_sql= "select distinct t.css_applicant_id, t.css_app_year, t.css_app_roll_no, t.css_app_result, t.css_app_discipline, t.css_app_examination, t.css_parent_id, t.css_app_group from css_app_pre_attempt t where CSS_APPLICANT_ID=$aid"; $temp4.=""; if($rs_display = OCIParse($conn, $display_sql)) { OCIExecute($rs_display); OCIFetchInto($rs_display, $row_display17, OCI_ASSOC); $i=0; do{ $i=$i+1; // $CSS_APP_PRE_CSS_IDS = $row_display17["CSS_APP_PRE_CSS_IDS"]; $CSS_APP_YEAR = $row_display17["CSS_APP_YEAR"]; $CSS_APP_ROLL_NO = $row_display17["CSS_APP_ROLL_NO"]; $CSS_APP_RESULT = $row_display17["CSS_APP_RESULT"]; $CSS_APP_DISCIPLINE = $row_display17["CSS_APP_DISCIPLINE"]; $CSS_APP_EXAMINATION = $row_display17["CSS_APP_EXAMINATION"]; $temp4.=" "; }while (OCIFetchInto($rs_display,$row_display17,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; for($j=0;$j<12;$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; $temp25="
"; 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"]; } if($arr3["CSS_OCC11_ID"]==$arre["CSS_GROUP_ID"]) { $counter["pos11"]=$arre["CSS_GROUP_NAME"]; } if($arr3["CSS_OCC12_ID"]==$arre["CSS_GROUP_ID"]) { $counter["pos12"]=$arre["CSS_GROUP_NAME"]; } } $temp25.="
25) Applicant's Selection of CSS Occupational Groups Priority wise.
"; for($i=1;$i<=12;$i++) { $p="pos".$i; $temp25.=" "; } $temp25.="
Priority No CSS Occupational Group
$i ".$counter["pos".$i]."
"; $temp.= $temp25; $temp.="
26)  (a) Previous Experience of Psychological Test:  ". $PSYCHOLOGICAL_TEST." (b)  If Yes, Name of Test Taking Organization:  ".$PSYCHOLOGICAL_CENTRE."
"; // 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_display18, OCI_ASSOC); do{ $i=$i+1; $CSS_APP_DISCIPLINE=$row_display18["CSS_APP_DISCIPLINE"]; $temp133.=""; }while (OCIFetchInto($rs_display,$row_display18,OCI_ASSOC)); } $temp133.="
". strtoupper($CSS_APP_DISCIPLINE)."

"; $temp.=$temp133; */ $temp.="

27) Checklist
1)   Please confirm if the following documents have been attached with the application form
YesNo
a Original Treasury Receipt for Rs. 2200/-
  
b Recent 4 Photographs (attested on back side, mentioning name and father's name)
  
c Attested copy of Computerized National Identity Card
  
d Attested copy of Matriculation Certificate showing date of birth, Provisional Certificated/Result Card/Marks Sheet is not acceptable
  
e Attested copy of Intermediate Certificate. Provisional Certificate/Result Card/Marks Sheet is not acceptable
  
f Attested copy of Degree(s)
  
g Attested copy of self Domicile Certificate
  
h Certificate for Buddhist and Scheduled Caste Candidates
  
i Certificate for Provinical/Federal Tribal Areas candidates and those belonging to Gilgit-Baltistan
  
j Certificate from Kashmir Affairs Division for Azad Kashmir Nationals
  
k Certificate for Minoritites
  
l Departmental Permission Certificate (for Government Servants)
  
m In case of Ex-Employees of Armed Forces of Pakistan No Objection Certificate from relevant authority
  
n In case of Disabled candidates, certificate of disability from the competent authority
  
o Whether you have signed the application? (First Page & sixth page)
  
2) If additional documents are attached with application form, please attach a separate list:-
3) I have read and understood 'Rules for Competitive Examination' and 'Regulations for Physical Examination' before filling this application form and agree to abide by them.
28) Declaration:
I certify that the statements I have made in the application are ture to the best of my knowledge and belief. I understand that if any of the above statement is false in any material respect or omits any material information relevant to my previous examinations, service, etc. my application is liable to be rejected and if appoineted my appointment is liable to be terminated.
ii) I hereby declare that
I am not in possession of any domicile certificate other than District ________________________ as claimed/submitted alongwith the instant application form. I further declare that if I am found in possession of any domicile certificate other than the one mentioned above, my candidature for instant examination may be cancelled/rejected and if appointed, I will be liable to dismissal from service any time with costs or any other penalty.
iii) I hereby further declare that
a. I have never been involved in any criminal or civil case or prosecuted in any criminal/civil or quasi judicial proceedings involving moral turpitude. If so, please give detailed particulars of the incident with name of police station.
b. I have not been associated with any banned militant, ethnic or terrorist organization at any time.
c. My parents, in-laws and any of my close relations have not been associated with any banned terrorist, militant organization.
  
 
Applicant's Signature
Place
Date



Roll No.
Name:  ".$CSS_APPLICANT_NAME."
Address:  ".$CSS_POSTAL_ADD1.", ".$CSS_POSTAL_ADD2."
Roll No.
Name:  ".$CSS_APPLICANT_NAME."
Address:  ".$CSS_POSTAL_ADD1.", ".$CSS_POSTAL_ADD2."
Roll No.
Name:  ".$CSS_APPLICANT_NAME."
Address:  ".$CSS_POSTAL_ADD1.", ".$CSS_POSTAL_ADD2."
Roll No.
Name:  ".$CSS_APPLICANT_NAME."
Address:  ".$CSS_POSTAL_ADD1.", ".$CSS_POSTAL_ADD2."
Roll No.
Name:  ".$CSS_APPLICANT_NAME."
Address:  ".$CSS_POSTAL_ADD1.", ".$CSS_POSTAL_ADD2."
Roll No.
Name:  ".$CSS_APPLICANT_NAME."
Address:  ".$CSS_POSTAL_ADD1.", ".$CSS_POSTAL_ADD2."
Roll No.
Name:  ".$CSS_APPLICANT_NAME."
Address:  ".$CSS_POSTAL_ADD1.", ".$CSS_POSTAL_ADD2."
Roll No.
Name:  ".$CSS_APPLICANT_NAME."
Address:  ".$CSS_POSTAL_ADD1.", ".$CSS_POSTAL_ADD2."
Roll No.
Name:  ".$CSS_APPLICANT_NAME."
Address:  ".$CSS_POSTAL_ADD1.", ".$CSS_POSTAL_ADD2."
"; 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; } } ?>