advertview($uid); break; case "edit": $temp.=$this->editadvert($uid); break; case "update": $temp.=$this->updateadvert($uid); break; case "jobdetail": $temp.=$this->jobsdetail($adid); break; case "jobs": $temp.=$this->advertjobs($adid); break; case "delete": $temp.=$this->deleteadvert(); break; case "assrole": $temp.=$this->assignrole($uid); break; case "assign": $temp.=$this->assigncomplete($uid); break; case "permissions": $temp.=$this->advertpermissions($uid); break; case "varify": $chk = $this->verifyApplicant(); if ($chk==0){ $v = $this->verifyForm(); if ($v == 1) { ?> Already applyed for this job, please choose different job

"; $temp.= "$errorHead "; } }else{ $errMsg ="
Please create your applicantion first

"; $temp.= "$errMsg"; } break; default: $temp.=$this->advertlists(); } return $temp; } //Child adverts List function advertlists() { global $conn,$key,$key1,$node,$menu,$hid,$cuid; $date=getdate(); $date_year=$date["year"]; $date_mon=$date["mon"]; $date_day=$date["mday"]; $temp.="
"; $advert_sql="select CSS_ADVERTISEMENT_ID,CSS_ADVERTISEMENT_NO, trim(to_char(POST_DATE,'DD')) || '-' || trim(to_char(POST_DATE,'MM')) || '-' || trim(to_char(POST_DATE,'YYYY')) as PDATE, trim(to_char(CLOSE_DATE,'DD')) || '-' || trim(to_char(CLOSE_DATE,'MM')) || '-' || trim(to_char(CLOSE_DATE,'YYYY')) as CDATE from CSS_POST_ADVERTISEMENT where (trunc(SYSDATE) -trunc(CLOSE_DATE)) <= 0"; //echo $advert_sql; //exit; $bcolor="#FFFFFF"; $advert_rs = OCIParse($conn, $advert_sql); OCIExecute($advert_rs); while (OCIFetchInto($advert_rs,$ad_row, OCI_ASSOC)) { if($bcolor == "#FFFFFF") { $bcolor="#F4F4F4"; } else { $bcolor="#FFFFFF"; } $advertid = $ad_row["CSS_ADVERTISEMENT_ID"]; $advertno = $ad_row["CSS_ADVERTISEMENT_NO"]; $advertpdate = $ad_row["PDATE"]; $advertcdate=$ad_row["CDATE"]; $temp.=""; } $temp.="
:: Advertisments
Competitive Examination (CSS) Advertisment No. Post Date Close Date
Competitive Examination (CSS) .".$advertno." ".$advertpdate." ".$advertcdate." Apply
 
"; return $temp; } function advertjobs($adid) { global $conn,$hid; $get_jobs="select j.CSS_JOB_ID,j.CSS_JOB_TITLE, 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_POST_DATE,'DD')) || '-' || trim(to_char(j.CSS_JOB_POST_DATE,'MM')) || '-' || trim(to_char(j.CSS_JOB_POST_DATE,'YYYY')) as PDATE 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 CSS_ADVERT_ID=$adid"; $temp=""; $temp.="
"; $get_rs = OCIParse($conn, $get_jobs); OCIExecute($get_rs); if(!$get_rs) { $norec=""; } $bcolor="#FFFFFF"; while (OCIFetchInto($get_rs,$get_row, OCI_ASSOC)) { if($bcolor == "#FFFFFF") { $bcolor="#F4F4F4"; } else { $bcolor="#FFFFFF"; } $CSS_JOB_ID=$get_row["CSS_JOB_ID"]; $CSS_JOB_TITLE=$get_row["CSS_JOB_TITLE"]; $MINISTRY_NAME=$get_row["MINISTRY_NAME"]; $CSS_JOB_DEPT=$get_row["CSS_JOB_DEPT"]; $CSS_JOB_MAX_AGE=$get_row["CSS_JOB_MAX_AGE"]; $CITY_NAME=$get_row["CITY_NAME"]; $PDATE=$get_row["PDATE"]; $PYEAR=$get_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.=""; } $temp.="$norec
:: Jobs
Posted Date Case No Job Title Minstry/Department Max Age City
No Record Found
".$PDATE." Case No.F4-".$CSS_JOB_ID."/".$PYEAR."-R ".$CSS_JOB_TITLE." ".$MINISTRY_NAME."/".$CSS_DEPARTMENT_NAME." ".$CSS_JOB_MAX_AGE." ".$CITY_NAME."
"; return $temp; } function jobsdetail($jid) { global $conn,$jid; $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=$jid"; //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."
 
"; return $temp; } function verifyForm() { global $errMsg,$login_Name,$pwd,$uemail,$conn,$userId,$jid,$userId; $errMsg = ""; if (strlen($errMsg) == 0) { $errorHead = "
Error
Your request couldnot be processed due to following reasons,
"; $role_sql = "select count(*) as CNT from CSS_JOB_RECIEPT where CSS_APPLICANT_ID = $userId and CSS_JOB_ID=$jid"; // echo $role_sql; exit; $rs1 = OCIParse($conn, $role_sql); OCIExecute($rs1); OCIFetchInto($rs1, $row1, OCI_ASSOC); if($row1["CNT"] > 0) { OCIFreeStatement($rs1); $return = 0; }else { $return = 1; } } else { $return = 0; } return $return; } function verifyApplicant() { global $errMsg,$login_Name,$pwd,$uemail,$conn,$userId,$jid,$userId; $role_sql = "select CSS_APPLICANT_ID as AID from CSS_APPLICANT_DETAIL where CSS_APPLICANT_ID = $userId"; $rs1 = OCIParse($conn, $role_sql); OCIExecute($rs1); OCIFetchInto($rs1, $row1, OCI_ASSOC); if($row1["AID"] > 0) { OCIFreeStatement($rs1); $return = 0; }else { $return = 1; } return $return; } } // end of class $advertClass = new Advertisment; ?>