Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
.pgetadm.php	3.61 KB	-rw-r--r--
PrintAdmissionOrderstudent.php	9.51 KB	-rwxrwxrwx
PrintAdmissionOrderstudent_ru....	11.26 KB	-rwxrwxrwx
acuapplicationFormPGReport.php	26.02 KB	-rwxr-xr-x
add-course.php	5.63 KB	-rwxrwxrwx
admissionorderPGReport.php	15.91 KB	-rwxrwxrwx
admissionordertest.php	356 B	-rwxrwxrwx
app-status.php	2.87 KB	-rwxrwxrwx
applicationFormPGReport.php	43.11 KB	-rwxrwxrwx
bcuapplicationFormPGReport.php	50.46 KB	-rwxrwxrwx
cancelSeat.php	4.51 KB	-rwxrwxrwx
casual-seat-allot.php	16.88 KB	-rwxrwxrwx
category.php	2.95 KB	-rwxrwxrwx
data.json	1.98 KB	-rwxrwxrwx
degree.php	11.73 KB	-rwxrwxrwx
feestr.php	5.7 KB	-rwxrwxrwx
forgot-password.php	2.77 KB	-rwxrwxrwx
generatestudentlistreport.php	11.34 KB	-rwxrwxrwx
getSavedData.php	13.67 KB	-rwxrwxrwx
getSavedData_old_12102019.php	5 KB	-rwxrwxrwx
hallticket.php	7.61 KB	-rwxrwxrwx
leaddetmail.php	2.09 KB	-rwxr-xr-x
login.php	1.21 KB	-rwxrwxrwx
logout.php	44 B	-rwxrwxrwx
option-entry-cr.php	4.76 KB	-rwxrwxrwx
option-entry.php	9.11 KB	-rwxrwxrwx
option-entryPrint.php	9.34 KB	-rwxrwxrwx
printadmissionorder.php	1.38 KB	-rwxrwxrwx
printhostelfeereport.php	11.84 KB	-rwxrwxrwx
report_ra_Notice_Boaed_Chart.p...	9.79 KB	-rwxrwxrwx
report_ra_invigilator_dairy.ph...	9.61 KB	-rwxrwxrwx
reportadm_admission_ticket.php	14.66 KB	-rwxrwxrwx
reprint.php	707 B	-rwxrwxrwx
resetpassword.php	783 B	-rwxrwxrwx
saveApplication.php	24.33 KB	-rwxrwxrwx
saveApplication_BACKUP_15072.p...	48.01 KB	-rwxrwxrwx
saveApplication_BASE_15072.php	23.61 KB	-rwxrwxrwx
saveApplication_LOCAL_15072.ph...	24.27 KB	-rwxrwxrwx
saveApplication_REMOTE_15072.p...	23.67 KB	-rwxrwxrwx
saveApplication_old_12102019.p...	14.67 KB	-rwxrwxrwx
seat-allot.php	9.18 KB	-rwxrwxrwx
seat_allotment_summary.php	8.42 KB	-rwxrwxrwx
sendGridMail.php	1.47 KB	-rwxrwxrwx
sendMobEmailOTP.php	1.41 KB	-rwxrwxrwx
sendsmsapi.php	760 B	-rwxrwxrwx
signin.php	1.24 KB	-rwxrwxrwx
signup.php	1.21 KB	-rwxrwxrwx
validateRegno.php	3.12 KB	-rwxrwxrwx
vkuapplicationFormPGReport cop...	36.61 KB	-rwxrwxrwx
vkuapplicationFormPGReport.php	24.17 KB	-rwxrwxrwx
vkuapplicationFormPGReportOld....	39.28 KB	-rwxrwxrwx

Code Editor : option-entry-cr.php

<?php

function getCasualOptionEntryDet($aobj_context) 
{
	session_start();
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);

$query_pgadmdate = "select * from collexam where fcollcode = 'PGET'
    and fdegree = 'OPCR'
    and date_format(now(),'%Y-%m-%d') between date_format(FPGADMFROM,'%Y-%m-%d') 
    and date_format(FPGADMTO,'%Y-%m-%d')";
    // var_dump($query_pgadmdate);

$result3 = $aobj_context->mobj_db->GetAll($query_pgadmdate);
    // var_dump($result3);

if(count($result3) == 0)
    {
      $arr['msg'] = "Last Date to modify option-entry is over";
      echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-2,"Failure"); 
      return;
	}

$query2 = "select ifnull(fappno,'') as fappno,
	ifnull(ffinsub,'F') as ffinsub,ifnull(fpaystatus,'F') as fpaystatus 
	from entstudadm 
	where fmobileno = '{$_SESSION['MOBILE']}'
	and ifnull(fapprstatus,'') = 'Accepted'";
	$qry2 =  $aobj_context->mobj_db->GetAll($query2);
	if(count($qry2) == 0) {
		$arr['msg'] = 'Option Entry not available.';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
		return;
	}

$fappno = $qry2[0]['fappno'];
	$ffinsub = $qry2[0]['ffinsub'];
	$fpaystatus = $qry2[0]['fpaystatus'];

$query1 = "select x.fdegree, concat(fdescpn) as degree, 
	concat(fcollname) as college, x.fcollcode
	from entcolldeg x inner join entdeg y on x.fdegree = y.fdegree
	inner join entcoll z on x.fcollcode = z.fcollcode
	inner join entoptdeg deg on deg.fdegree = x.fdegree 
	where deg.fappno ='{$fappno}'
	order by x.fdegree, x.fcollcode";
	//var_dump($query1);
	$obj =  $aobj_context->mobj_db->GetAll($query1);
	
	$query3 = "select * from entoptions 
	where fappno = '{$fappno}' and fentoptround = 'CR' 
	order by fpriority";
		$result2 = $aobj_context->mobj_db->GetAll($query3);
		//var_dump($query3);
	if(count($obj) > 0) {

$res['fappno'] = $fappno;
		$res['fround'] = $res1['fentoptround'];
		$res['optent'] = $obj;
		$res['priority'] = $result2;
		$res['ffinsub'] = $ffinsub;
		$res['fpaystatus'] = $fpaystatus;
		echo $aobj_context->mobj_output->ToJSONEnvelope($res,0,"success"); 
		return;
	}
	else 
	{
		$arr['msg'] = 'Error in fetching option entry details.';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
		return;
	}
}

function saveCasualOptionEntryDet($aobj_context) 
{
	session_start();
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$data = json_decode($aobj_context->mobj_data['options'], true);

// $res = true;
	// if($res) {
	// 	$arr['msg'] = 'Last date is over';
	// 	echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
	// 	return;
	//  } 
	$query_pgadmdate = "select * from collexam where fcollcode = 'PGET'
    and fdegree = 'OPCR'
    and date_format(now(),'%Y-%m-%d') between date_format(FPGADMFROM,'%Y-%m-%d') 
    and date_format(FPGADMTO,'%Y-%m-%d')";
    // var_dump($query_pgadmdate);

$result3 = $aobj_context->mobj_db->GetAll($query_pgadmdate);
    // var_dump($result3);

if(count($result3) == 0)
    {
      $arr['msg'] = "Last Date to modify option-entry is over";
      echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-2,"Failure"); 
      return;
    }

$query = "select fappno from entstudadm where fmobileno = '{$_SESSION['MOBILE']}'";
	$obj =  $aobj_context->mobj_db->GetRow($query); 
	$appno = $obj['fappno'];

if($appno == "") {
		$arr['msg'] = 'Application Payment Not done';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
		return;
	}

$values = "";
	foreach($data as $value) {
		$values .= "('{$appno}', '{$value['degree']}', '{$value['college']}', '{$value['priority']}', 'CR','9'),";
	}

$values = rtrim($values, ',');
	$delete = "delete from entoptions where fappno = '{$appno}' and fentoptround = 'CR'";

$res =  $aobj_context->mobj_db->Execute($delete);

$insert = "insert into entoptions(fappno, fdegree, fcollcode, fpriority, fentoptround,fround) 
	values  $values ";
	$res =  $aobj_context->mobj_db->Execute($insert);

if($res) {
		$arr['msg'] = "Preferences saved successfully.";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
	}
	else {
		$arr['msg'] = 'Error While saving preferences.';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 	
	}

}

function UpdateCasualforStudent($aobj_context) {

session_start();
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);	
	$fappno = $aobj_context->mobj_data['fappno'];
	$response = $aobj_context->mobj_data['response'];

$query = "update entstudadm set fcaround = '{$response}' where fappno = '{$fappno}'";

$res =  $aobj_context->mobj_db->Execute($query);

if($res) {
		$arr['msg'] = "Updated successfully.";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
	}
	else {
		$arr['msg'] = 'Error While updating.';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 	
	}

}

${this.title}

Code Editor : option-entry-cr.php