$value) {
// if ($rowcount == 0)
// $Select_Years = $Select_Years . "\n";
// $rowcount++;
$tableValue = $key;
$tableShow = $value;
if ($tableValue == $oldvalue)
$Select_Years = $Select_Years . "\n";
else
$Select_Years = $Select_Years . "\n";
} // end for
return $Select_Years;
} // end function
function validjobs_ac ($conn)
{
$query = "select distinct t.gr_job_id, t.post_name, t.case_no, t.subject
from gr_phaseiv_2013_ac t
order by t.gr_job_id";
$rjobs = OCIParse($conn,$query);
OCIExecute($rjobs);
$Select_jobs = "";
$Select_jobs = "";
while(OCIFetchInto($rjobs,$mod_row, OCI_ASSOC)) {
$tableValue = $mod_row["GR_JOB_ID"];
$tableShow = $mod_row["CASE_NO"]." [ ".$mod_row["POST_NAME"]." ".$mod_row["SUBJECT"]." ]";
$Select_jobs = $Select_jobs . "";
} // end while
return $Select_jobs;
} // end function
function AgeRelaxGovt($oldvalue)
{
$arrYears[0]="Less than 2 year";
$arrYears[10]="2 years or above";
//print_r($arrYears);
$Select_Years = "";
// $rowcount = 0;
foreach ($arrYears as $key => $value) {
// if ($rowcount == 0)
// $Select_Years = $Select_Years . "\n";
// $rowcount++;
$tableValue = $key;
$tableShow = $value;
if ($tableValue == $oldvalue)
$Select_Years = $Select_Years . "\n";
else
$Select_Years = $Select_Years . "\n";
} // end for
return $Select_Years;
} // end function
function districtList_New ($oldvalue,$conn)
{
$seldistrictnew = "select GR_DISTRICT_ID, GR_DISTRICT from DISTRICT where FLAG=1 ORDER BY GR_DISTRICT";
$rsdistrictnew = OCIParse($conn,$seldistrictnew);
OCIExecute($rsdistrictnew);
$Select_districtnew = "";
$Select_districtnew = "";
while(OCIFetchInto($rsdistrictnew,$mod_row, OCI_ASSOC)) {
$tableValue = $mod_row["GR_DISTRICT_ID"];
$tableShow = $mod_row["GR_DISTRICT"];
if ($tableValue == $oldvalue)
$Select_districtnew = $Select_districtnew . "";
else
$Select_districtnew = $Select_districtnew . "";
} // end for
return $Select_districtnew;
} // end function
function districtList ($oldvalue,$conn)
{
$seldistrict = "select GR_DOMICILE_ID,GR_DISTRICT_ID, GR_DISTRICT from DISTRICT ORDER BY GR_DISTRICT";
$rsdistrict = OCIParse($conn,$seldistrict);
OCIExecute($rsdistrict);
$Select_district = "";
while(OCIFetchInto($rsdistrict,$mod_row, OCI_ASSOC)) {
$tableValue = $mod_row["GR_DISTRICT_ID"];
$tableShow = $mod_row["GR_DISTRICT"];
$tableClass = $mod_row["GR_DOMICILE_ID"];
if ($tableValue == $oldvalue)
$Select_district = $Select_district . "";
else
$Select_district = $Select_district . "";
} // end for
return $Select_district;
} // end function
function DomicileList ($oldvalue,$conn)
{
$selDomicile = "select DOMICILE_NAME, DOMICILE_CODE from DOMICILE WHERE FLAG=1 ORDER BY DOMICILE_NAME";
$rsDomicile = OCIParse($conn,$selDomicile);
OCIExecute($rsDomicile);
$Select_Domicile = "";
while(OCIFetchInto($rsDomicile,$mod_row, OCI_ASSOC)) {
$tableValue = $mod_row["DOMICILE_CODE"];
$tableShow = $mod_row["DOMICILE_NAME"];
if ($tableValue == $oldvalue)
$Select_Domicile = $Select_Domicile . "";
else
$Select_Domicile = $Select_Domicile . "";
} // end for
return $Select_Domicile;
} // end function
function GB_DomicileList ($oldvalue,$conn)
{
$selDomicile = "select DOMICILE_NAME, DOMICILE_CODE from DOMICILE WHERE DOMICILE_CODE = 61";
$rsDomicile = OCIParse($conn,$selDomicile);
OCIExecute($rsDomicile);
$Select_Domicile = "";
while(OCIFetchInto($rsDomicile,$mod_row, OCI_ASSOC)) {
$tableValue = $mod_row["DOMICILE_CODE"];
$tableShow = $mod_row["DOMICILE_NAME"];
if ($tableValue == $oldvalue)
$Select_Domicile = $Select_Domicile . "";
else
$Select_Domicile = $Select_Domicile . "";
} // end for
//echo $Select_Domicile; exit;
return $Select_Domicile;
} // end function
function AgeRelaxListnew ($oldvalue,$conn)
{
$selCenter = "select GR_AGE_RELAX_DESC, GR_AGE_RELAX_ID from GR_AGE_RELAX ORDER BY GR_AGE_RELAX_ID";
$rsCenter = OCIParse($conn,$selCenter);
OCIExecute($rsCenter);
$Select_Center = "";
while(OCIFetchInto($rsCenter,$mod_row, OCI_ASSOC)) {
$tableValue = $mod_row["GR_AGE_RELAX_ID"];
$tableShow = $mod_row["GR_AGE_RELAX_DESC"];
if ($tableValue == $oldvalue)
$Select_Center = $Select_Center . "\n";
else
$Select_Center = $Select_Center . "\n";
} // end for
return $Select_Center;
} // end function
function ReligionList ($job_id,$conn)
{
$selReligion = "select t.gr_eligible_religion from gr_job_post t where gr_job_id=" . $job_id;
$rsReligion = OCIParse($conn,$selReligion);
OCIExecute($rsReligion);
$Select_Religion = "";
$Select_Religion = "";
OCIFetchInto($rsReligion,$mod_row, OCI_ASSOC);
$tableValue = $mod_row["GR_ELIGIBLE_RELIGION"];
if ($tableValue == "BOTH"){
$Select_Religion = $Select_Religion . "";
}
if ($tableValue == "Non Muslim"){
$Select_Religion = $Select_Religion . "";
}
return $Select_Religion;
}
function CenterListnew ($oldvalue,$conn)
{
$selCenter = "select CENTER_NAME, CENTER_CODE,CENTER_ID from CENTER where GR_CENTER = 1 ORDER BY Center_NAME";
$rsCenter = OCIParse($conn,$selCenter);
OCIExecute($rsCenter);
$Select_Center = "";
$Select_Center = "";
while(OCIFetchInto($rsCenter,$mod_row, OCI_ASSOC)) {
$tableValue = $mod_row["CENTER_ID"];
$tableShow = $mod_row["CENTER_NAME"];
if ($tableValue == $oldvalue)
$Select_Center = $Select_Center . "\n";
else
$Select_Center = $Select_Center . "\n";
} // end for
return $Select_Center;
}
function InterviewListnew ($oldvalue,$conn)
{
$selCenter = "select CENTER_NAME, CENTER_CODE,CENTER_ID from CENTER where INTERVIEW_CENTER = 1 ORDER BY Center_NAME";
$rsCenter = OCIParse($conn,$selCenter);
OCIExecute($rsCenter);
$Select_Center = "";
$Select_Center = "";
while(OCIFetchInto($rsCenter,$mod_row, OCI_ASSOC)) {
$tableValue = $mod_row["CENTER_ID"];
$tableShow = $mod_row["CENTER_NAME"];
if ($tableValue == $oldvalue)
$Select_Center = $Select_Center . "\n";
else
$Select_Center = $Select_Center . "\n";
} // end for
return $Select_Center;
}
function validjobs ($conn)
{
$query = "select jp.GR_JOB_ID,
'F.4-'||jp.gr_case_no||'/'||trim(to_char(jp.GR_JOB_POST_DATE,'YYYY'))||'-R ['||jp.gr_job_title||']'||js.gr_sub_name as GR_JOB_TITLE
from GR_JOB_POST jp, gr_job_subs js, gr_job_sub_depend jsd
where jp.gr_job_id = jsd.gr_dep_job_id(+)
and jsd.gr_sub_id = js.gr_sub_id(+)
and jp.gr_job_online = 1
and GR_ADVERT_ID in(
select GR_ADVERTISEMENT_ID from GR_POST_ADVERTISEMENT where (trunc(SYSDATE) - trunc(CLOSE_DATE)) <= 0)
order by to_number(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(jp.gr_case_no,'A',''),'B',''),'C',''),'D',''),'E',''),'F',''),'G',''),'H',''),'I',''),'J',''),'K',''),'L',''),'M',''),'N',''),'O',''),'P',''),'Q',''),'R',''),'S',''),'T',''),'U',''),'V',''),'W',''),'X',''),'Y',''),'Z',''))
";
$rjobs = OCIParse($conn,$query);
OCIExecute($rjobs);
$Select_jobs = "";
while(OCIFetchInto($rjobs,$mod_row, OCI_ASSOC)) {
$tableValue = $mod_row["GR_JOB_ID"];
$tableShow = $mod_row["GR_JOB_TITLE"];
$Select_jobs = $Select_jobs . "";
} // end while
return $Select_jobs;
} // end function
function validgender ($job_id,$conn)
{
$query = "select t.gr_eligible_gender from gr_job_post t where gr_job_id=" . $job_id;
$rgender = OCIParse($conn,$query);
OCIExecute($rgender);
$select_genders="";
OCIFetchInto($rgender,$mod_row, OCI_ASSOC);
$tableValue = $mod_row["GR_ELIGIBLE_GENDER"];
//print_r($mod_row);
if($tableValue=="BOTH"){
$select_genders = "";
}
if($tableValue=="MALE"){
$select_genders = "";
}
if($tableValue=="FEMALE"){
$select_genders = "";
}
$select_genders = '";
return $select_genders;
} // end function
function validdomicile ($job_id,$conn)
{
$query = "select distinct d.domicile_code, d.domicile_name, pr.gr_province_name, t.gr_province_id, jp.northarea from domicile d, gr_post_calculation t, gr_province pr, gr_job_post jp where d.prov_id(+)=pr.gr_province_id and pr.gr_province_id!=3 and pr.gr_province_id=t.gr_province_id and nvl(jp.parent_id,jp.gr_job_id) = t.gr_post_id and t.gr_post_id in(select nvl(parent_id,gr_job_id) from gr_job_post p where gr_post_allocation>0 and p.gr_job_id=" . $job_id . ") order by t.gr_province_id";
$rprovinces = OCIParse($conn,$query);
OCIExecute($rprovinces);
$Select_provinces = "";
while(OCIFetchInto($rprovinces,$mod_row, OCI_ASSOC)) {
if($mod_row["GR_PROVINCE_ID"]==1){
return DomicileList('',$conn);
}
if($mod_row["GR_PROVINCE_ID"]==8 && $mod_row["NORTHAREA"]==1){
return GB_DomicileList('',$conn);
}
$tableValue = $mod_row["DOMICILE_CODE"];
$tableShow = $mod_row["DOMICILE_NAME"];
$Select_provinces = $Select_provinces . "";
} // end for
return $Select_provinces;
} // end function
function new_application($data,$conn){
/*
$sql= "INSERT INTO NEW_GR_APP_PER_EDU (
GR_APPLICANT_ID,
GR_APPLICANT_NAME,
GR_JOB_ID,
GR_DOB,
GR_NEW_NIC,
GR_APPLICANT_EMAIL,
GR_APP_MOBILE
)
VALUES(
SQ_GR_LOGIN_INFORMATION.NEXTVAL,
'$data->gr_applicant_name',
'$data->gr_job_id',
to_date('$data->gr_dob','dd-mm-yyyy'),
'$data->gr_cnic',
'$data->gr_email',
'923335556444')";
//return $sql;
$sql_ins_stmt = OCIParse($conn, $sql);
if (OCIExecute($sql_ins_stmt)) {
return "1";
}else{
return OCIError();
}
*/
$sql= "INSERT INTO NEW_GR_APP (
GR_APPLICANT_ID,
GR_APPLICANT_NAME,
GR_FATHER_NAME,
GR_DOB,
GR_NEW_NIC,
GR_GENDER,
GR_RELIGION,
GR_POSTAL_ADD,
GR_APPLICANT_EMAIL,
GR_APPLICANT_PHONE_OFF,
GR_APP_MOBILE,
GR_AGEREX1,
GR_RELAX_YEARS,
GR_DOMICILE,
GR_DISTRICT_DOMICILE,
GR_DISABILITY,
GR_HELPER,
GR_JOB_ID,
TR_DATE,
GR_AMOUNT,
GR_BANK_BRANCH_NAME,
GR_BANK_CODE,
GR_BANK_DISTRICT,
DATE_APPLIED,
GR_CENTER_ID,
GR_CENTER_NAME,
GR_INTERVIEW_ID,
GR_INTERVIEW_NAME,
GR_REQUIRED_QUALEXP,
GR_RDD,
GR_PHOTO
)
VALUES(
SQ_NEW_GR_APP.NEXTVAL,
trim(upper(:GR_APPLICANT_NAME)),
trim(upper(:GR_FATHER_NAME)),
to_date(:GR_DOB,'dd-mm-yyyy'),
:GR_NEW_NIC,
:GR_GENDER,
:GR_RELIGION,
upper(:GR_POSTAL_ADD1)||', '||upper(:GR_POSTAL_ADD2),
lower(:GR_APPLICANT_EMAIL),
:GR_APPLICANT_PHONE_OFF,
:GR_APP_MOBILE,
upper(:GR_AGEREX1),
:GR_RELAX_YEARS,
upper(:GR_DOMICILE),
upper(:GR_DISTRICT_DOMICILE),
upper(:GR_DISABILITY),
upper(:GR_HELPER),
:GR_JOB_ID,
to_date(:TR_DATE,'dd-mm-yyyy'),
:GR_AMOUNT,
:GR_BANK_BRANCH_NAME,
:GR_BANK_CODE,
:GR_BANK_DISTRICT,
to_date(:DATE_APPLIED,'dd-mm-yyyy hh:mi:ss AM'),
:GR_CENTER_ID,
upper(:GR_CENTER_NAME),
:GR_INTERVIEW_ID,
upper(:GR_INTERVIEW_NAME),
:GR_REQUIRED_QUALEXP,
to_date(:GR_RDD,'dd-mm-yyyy'),
EMPTY_BLOB()
) returning GR_PHOTO ,GR_APPLICANT_ID INTO :GR_PHOTO, :GR_APPLICANT_ID";
$lob = OCINewDescriptor($conn, OCI_D_LOB);
$stid = ociparse($conn, $sql);
//$mobile_num=92+str_replace(substr($data->gr_mobile,strpos($data->gr_mobile,'3')),'-','');
//echo $data->gr_helper."----".$data->gr_disability;
$mobile_num='92'.str_replace('-','',substr($data->gr_mobile,strpos($data->gr_mobile,'3')));
$current_date=date('d-m-Y h:i:s A');
//var_dump($data);exit;
//print_r($data);exit;
$GR_APPLICANT_ID="-1";
OCIBindByName($stid, ':GR_PHOTO', $lob, -1, OCI_B_BLOB);
OCIBindByName($stid, ':GR_APPLICANT_ID', $GR_APPLICANT_ID, 32);
//echo "---".$data->gr_education[0]->degree_text; exit;
ocibindbyname($stid, ':GR_APPLICANT_NAME', $data->gr_applicant_name);
ocibindbyname($stid, ':GR_FATHER_NAME', $data->gr_father_name);
ocibindbyname($stid, ':GR_DOB', $data->gr_dob);
ocibindbyname($stid, ':GR_NEW_NIC', $data->gr_cnic);
ocibindbyname($stid, ':GR_GENDER', $data->gr_gender);
ocibindbyname($stid, ':GR_RELIGION', $data->gr_religion);
ocibindbyname($stid, ':GR_POSTAL_ADD1', $data->gr_postal_adress1);
ocibindbyname($stid, ':GR_POSTAL_ADD2', $data->gr_postal_adress2);
ocibindbyname($stid, ':GR_APPLICANT_EMAIL', $data->gr_email);
ocibindbyname($stid, ':GR_APPLICANT_PHONE_OFF', $data->gr_phone_off);
ocibindbyname($stid, ':GR_APP_MOBILE', $mobile_num);
ocibindbyname($stid, ':GR_AGEREX1', $data->gr_age_relaxation);
ocibindbyname($stid, ':GR_RELAX_YEARS', $data->gr_relaxation_years);
ocibindbyname($stid, ':GR_DOMICILE', $data->gr_domicile);
ocibindbyname($stid, ':GR_DISTRICT_DOMICILE', $data->gr_district);
ocibindbyname($stid, ':GR_DISABILITY', $data->gr_disability);
ocibindbyname($stid, ':GR_HELPER', $data->gr_helper);
ocibindbyname($stid, ':GR_JOB_ID', $data->gr_job_id);
ocibindbyname($stid, ':TR_DATE', $data->gr_TR_Date);
ocibindbyname($stid, ':GR_AMOUNT', $data->gr_TR_Amount);
ocibindbyname($stid, ':GR_BANK_BRANCH_NAME', $data->gr_TR_Bank_Branch_Name);
ocibindbyname($stid, ':GR_BANK_CODE', $data->gr_TR_Bank_Code);
ocibindbyname($stid, ':GR_BANK_DISTRICT', $data->gr_TR_Bank_District);
ocibindbyname($stid, ':DATE_APPLIED', $current_date);
ocibindbyname($stid, ':GR_CENTER_ID', $data->gr_test_centre);
ocibindbyname($stid, ':GR_CENTER_NAME', $data->gr_test_centre_name);
ocibindbyname($stid, ':GR_INTERVIEW_ID', $data->gr_interview_centre);
ocibindbyname($stid, ':GR_INTERVIEW_NAME', $data->gr_interview_centre_name);
ocibindbyname($stid, ':GR_RDD', $data->gr_RDD);
ocibindbyname($stid, ':GR_REQUIRED_QUALEXP', $data->gr_REQUIRED_QUALEXP);
$_SESSION['cnic']=$data->gr_cnic;
$_SESSION['job']=$data->gr_job_id;
session_write_close();
$r = OCIExecute($stid, OCI_DEFAULT);
if($data->gr_picture_path!=""){
if ($lob->savefile($data->gr_picture_path)){
OCICommit($conn);
}
}
else{OCICommit($conn);}
if ($r) {
smtpmailer($data->gr_email, 'noreply@fpsc.gov.pk', 'webmanagerfpsc@fpsc.gov.pk', 'FPSC', 'FPSC ONLINE RECRUITMENT SYSTEM', "Your Application has been received in $data->gr_job_name , Your tracking id is $GR_APPLICANT_ID
Important Notice: No hard copy of your application, documents or Bank Challan/Treasury Receipt is required to be sent to FPSC at this stage. The Bank Challan/Treasury Receipt should be preserved and presented at time of test/examination.
Note: This is system generated e-mail. Please do not reply.
Federal Public Service Commission, Islamabad");
$lob->free();
OCIFreeStatement($stid);
return $GR_APPLICANT_ID;
}else{
return OCIError();
}
$lob->free();
OCIFreeStatement($stid);
}
function check_duplicate_application($cnic, $job_id,$conn){
$check_job_status="select count(gr_applicant_id) as CNT
from new_gr_app
where gr_new_nic ='$cnic'
and gr_job_id =$job_id";
//echo $check_job_status; exit;
$check_job_rs = OCIParse($conn, $check_job_status);
OCIExecute($check_job_rs);
OCIFetchInto($check_job_rs,$cnt_row, OCI_ASSOC);
if ($cnt_row["CNT"] > 0)
{
return "1";
}else{
return "0";
}
OCIFreeStatement($check_job_rs);
}
function check_withindate_application($job_id,$conn){
$check_job_status="select count(*) as CNTAPP
from GR_JOB_POST jp
where jp.gr_job_id = $job_id
and GR_ADVERT_ID in(
select GR_ADVERTISEMENT_ID from GR_POST_ADVERTISEMENT where (trunc(SYSDATE) - trunc(CLOSE_DATE)) <= 0)";
//echo $check_job_status; exit;
$check_job_rs = OCIParse($conn, $check_job_status);
OCIExecute($check_job_rs);
OCIFetchInto($check_job_rs,$cnt_row, OCI_ASSOC);
if ($cnt_row["CNTAPP"] > 0)
{
return "1";
}else{
return "0";
}
OCIFreeStatement($check_job_rs);
}
?>