JOBS
$value) {
$$key = $value;
}
global $conn,$jid;
$sgr="select a.*,b.* from GR_POST_ADVERTISEMENT a,GR_JOB_POST b where a.GR_ADVERTISEMENT_ID=b.GR_ADVERT_ID and b.GR_JOB_ID=$jid";
$ggr=OCIParse($conn,$sgr);
OCIExecute($ggr);
OCIFetchInto($ggr,$gga,OCI_ASSOC);
$close_ddate=$gga['CLOSE_DATE'];
$det_jobs="select GR_AGE_RELAXATION,decode(j.GR_ELIGIBLE_GENDER,'BOTH','Both male and female candidates are eligible ','MALE','Only male candidates are eligible','FEMALE','Only female candidates are eligible') as ELIG,j.NORTHAREA,decode(j.NORTHAREA,0,'',1,'Northern Area Job') NAREA,j.GR_JOB_SPAY,j.PARENT_ID,j.GR_JOB_STATUS,j.GR_JOB_TPERIOD,j.GR_CASE_NO,j.GR_JOB_DUTIES,j.GR_JOB_SSAL,j.GR_JOB_TITLE,j.GR_JOB_VACANCIES,j.GR_JOB_EXP,
j.GR_JOB_GRADE,j.GR_JOB_MIN_AGE,j.GR_AGE_RELAXATION,
m.MINISTRY_NAME,j.GR_JOB_DEPT,j.GR_JOB_MAX_AGE,c.CITY_NAME,trim(to_char(j.GR_JOB_POST_DATE,'YYYY')) as PYEAR,
trim(to_char(j.GR_JOB_CLOSE_DATE,'DD')) || '-' || trim(to_char(j.GR_JOB_CLOSE_DATE,'MM')) || '-' || trim(to_char(j.GR_JOB_CLOSE_DATE,'YYYY')) as CDATE
from GR_JOB_POST j, GR_MINISTRIES m, GR_CITY c
where j.GR_JOB_PLACE=c.CITY_ID and j.GR_JOB_MINISTRY=m.MINISTRY_ID and j.GR_JOB_ID=$jid";
//echo $det_jobs;
$det_rs = OCIParse($conn, $det_jobs);
OCIExecute($det_rs);
OCIFetchInto($det_rs,$det_row, OCI_ASSOC);
//echo $des_jobs; exit
if($det_row[PARENT_ID]!="") {
$sec = "select t.*,a.* from gr_job_sub_depend t,gr_job_subs a
where a.gr_sub_id=t.gr_sub_id and t.gr_dep_job_id=$jid";
$rec = OCIParse($conn,$sec);
OCIExecute($rec);
OCIFetchInto($rec,$arec,OCI_ASSOC);
if($arec[GR_SUB_ID]!="") {
$code = substr($get_row[GR_CASE_NO],strlen($get_row[GR_CASE_NO])-1,1);
$subjects = $arec[GR_SUB_NAME];
$seats =$arec[GR_SEATS];
}
else
$seats = $det_row[GR_JOB_VACANCIES];
}
else
$seats = $det_row[GR_JOB_VACANCIES];
$temp="";
$GR_AGE_RELAXATION=$det_row["GR_AGE_RELAXATION"];
$NORTH_AREA=$det_row["NORTHAREA"];
$ELIG=$det_row["ELIG"];
$GR_JOB_STATUS=$det_row["GR_JOB_STATUS"];
$GR_JOB_TPERIOD=$det_row["GR_JOB_TPERIOD"];
if(intval($GR_JOB_STATUS)==1)
$GR_JOB_TPERIOD="Permanent";
else if(is_string($GR_JOB_TPERIOD))
$GR_JOB_TPERIOD="Temporary ".$GR_JOB_TPERIOD;
else
$GR_JOB_TPERIOD="";
$GR_JOB_TITLE=$det_row["GR_JOB_TITLE"];
$GR_CASE_NO=$det_row["GR_CASE_NO"];
$MINISTRY_NAME=$det_row["MINISTRY_NAME"];
$GR_JOB_DEPT=$det_row["GR_JOB_DEPT"];
$GR_JOB_MIN_AGE=$det_row["GR_JOB_MIN_AGE"];
$GR_JOB_MAX_AGE=$det_row["GR_JOB_MAX_AGE"];
$CITY_NAME=$det_row["CITY_NAME"];
$GR_JOB_VACANCIES=$det_row["GR_JOB_VACANCIES"];
$GR_JOB_EXP=$det_row["GR_JOB_EXP"];
$GR_JOB_GRADE=$det_row["GR_JOB_GRADE"];
$CDATE=$det_row["CDATE"];
$PYEAR=$det_row["PYEAR"];
$dept_sql="select GR_DEPARTMENT_NAME from GR_MIN_DEPT where GR_DEPARTMENT_ID=$GR_JOB_DEPT";
$dept_rs = OCIParse($conn, $dept_sql);
OCIExecute($dept_rs);
OCIFetchInto($dept_rs,$dept_row, OCI_ASSOC);
$GR_DEPARTMENT_NAME=$dept_row["GR_DEPARTMENT_NAME"];
$temp.="
";
if($GR_JOB_GRADE!=16){
$temp.="
";}
echo $temp;
?>
|