session_cache_limiter('private, must-revalidate');
session_start();
include"../include/conn.php";
$userId=$_SESSION["userId"];
$loginid=$_SESSION["loginid"];
if(!isset($userId))
header("Location: ../profile/newaccount.php?a=displayLogin");
$display_sql= "select count(*) as COUNT from CSS_APP_GENERAL where CSS_APPLICANT_ID=$userId";
$rpos=OCIParse($conn,$display_sql);
OCIExecute($rpos);
OCIFetchInto($rpos,$disarr,OCI_ASSOC);
$iocoount=$disarr["COUNT"];
if($iocoount==0)
header("Location: ../profile/applicationdetail.php?a=Add&aid=$userId");
if(count($_POST)){
foreach ($_POST as $key => $value) {
$$key = $value;
}
}
$a=$_REQUEST["a"];
//echo $a;
switch (@$a) {
case "Save & add another activity":
insert_data($conn,1);
break;
case "Save & move to next section":
//insert_data($conn,2);
?>
break;
default:
displayform();
}
function displayform()
{
global $conn,$temp, $userId;
$limit = "select count(*) as CNT from CSS_APP_EXTRA_CURRICULUM where css_applicant_id=$userId";
$rsedu = OCIParse($conn,$limit);
OCIExecute($rsedu);
OCIFetchInto($rsedu,$rsedu_arr,OCI_ASSOC);
if($rsedu_arr["CNT"]<=2){
?>
}
?>
|
include("../include/top.php"); ?>
|
include("../include/userleft.php"); ?>
include("../include/profileleft.php"); ?>
|
|
| include("../include/bottom.php"); ?> |
|
}
function insert_data($conn,$flage)
{
global $S_Date,$E_Date,$extra,$userId,$Start_Date,$End_Date;
//$S_Date=explode("-",$S_Date);
//$E_Date=explode("-",$E_Date);
$Start_Date = "$S_Date";
$End_Date = "$E_Date";
//$S_Date = "$S_Date[2]-$S_Date[1]-$S_Date[0]";
//$E_Date = "$E_Date[2]-$E_Date[1]-$E_Date[0]";
/* Check for max 3 extra curriculur activities -- implemented from CSS-2015 */
$limit = "select count(*) as CNT from CSS_APP_EXTRA_CURRICULUM where css_applicant_id=$userId";
$rsedu = OCIParse($conn,$limit);
OCIExecute($rsedu);
OCIFetchInto($rsedu,$rsedu_arr,OCI_ASSOC);
if($rsedu_arr["CNT"]<=2){
$max_ext_query = "select max(CSS_EXTRA_CURRICULUM_ID) as MAX_EXT from CSS_APP_EXTRA_CURRICULUM";
$max_ext=OCIParse($conn,$max_ext_query);
OCIExecute($max_ext);
OCIFetchInto($max_ext, $max_ext_result,OCI_ASSOC);
//echo "-----".$max_qual_result['MAX_QUAL']."----------".$max_qual_query; exit;
$extid=$max_ext_result['MAX_EXT']+1;
/*
$query = "insert into CSS_APP_EXTRA_CURRICULUM(CSS_EXTRA_CURRICULUM_ID,CSS_FROM_DATE, CSS_TO_DATE, CSS_EXTRA_CURRICULUM_ACT,CSS_APPLICANT_ID)
values(SQ_CSS_EXTRA_CURRICULUM_ID.nextval,to_timestamp('$Start_Date','DD-MM-YYYY')
,to_timestamp('$End_Date','DD-MM-YYYY'),'$extra',$userId)";
*/
$query = "insert into CSS_APP_EXTRA_CURRICULUM(CSS_EXTRA_CURRICULUM_ID,CSS_FROM_DATE, CSS_TO_DATE, CSS_EXTRA_CURRICULUM_ACT,CSS_APPLICANT_ID)
values($extid,to_timestamp('$Start_Date','DD-MM-YYYY')
,to_timestamp('$End_Date','DD-MM-YYYY'),'$extra',$userId)";
// echo $query; exit;
$stmt = OCIParse($conn, $query);
if(OCIExecute($stmt))
{
$temp="Successfuly Addedd";
if($flage == 1)
displayform();
}
} // Max extra curricular activities if ends here
else{
displayform();
}
}
?>