Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
phpmailer	[ DIR ]	drwxrwxrwx
.htaccess	602 B	-rwxr-xr-x
ApplicationReport.php	11.81 KB	-rwxrwxrwx
CreateUser.php	5.23 KB	-rwxrwxrwx
appForm.php	23.31 KB	-rwxrwxrwx
applicationFormReportPOSTOFFIC...	19.32 KB	-rwxrwxrwx
applicationStatus.php	6.84 KB	-rwxrwxrwx
applicationStatus_31012018.php	2.94 KB	-rwxrwxrwx
cManualMailer.php	1.52 KB	-rwxrwxrwx
caccesscontext.php	1.24 KB	-rwxrwxrwx
candidate_list.php	54.71 KB	-rwxrwxrwx
cappcontext.php	2.66 KB	-rwxrwxrwx
ceckFile.php	1.12 KB	-rwxrwxrwx
cmailer.php	6.83 KB	-rwxrwxrwx
code39.php	6.38 KB	-rwxrwxrwx
coutput.php	1.76 KB	-rwxrwxrwx
crequestbroker.php	2.49 KB	-rwxrwxrwx
csessions.php	514 B	-rwxrwxrwx
cuser.php	3.41 KB	-rwxrwxrwx
customappcontext.php	2.35 KB	-rwxrwxrwx
download.php	5.65 KB	-rwxrwxrwx
dropdown.php	844 B	-rwxrwxrwx
everifyMc.php	6.36 KB	-rwxrwxrwx
feehead.php	1.51 KB	-rwxrwxrwx
format.php	7.43 KB	-rwxrwxrwx
fpdf_protection.php	5.61 KB	-rwxrwxrwx
getdata.php	1.06 KB	-rwxrwxrwx
getnumword.php	7.15 KB	-rwxrwxrwx
home.html	14.48 KB	-rwxrwxrwx
json.php	33.2 KB	-rwxrwxrwx
login.php	1.88 KB	-rwxrwxrwx
mc-verify.php	6.65 KB	-rwxrwxrwx
mregistry.php	4.55 KB	-rwxrwxrwx
mregistry_31012018.php	2.65 KB	-rwxrwxrwx
report_appstatus.php	6.42 KB	-rwxrwxrwx
report_verificationlist.php	4.99 KB	-rwxrwxrwx
reportapplicationform.php	19.59 KB	-rwxrwxrwx
reportapplicationform_old.php	28 KB	-rwxrwxrwx
rotation.php	596 B	-rwxrwxrwx
sendGridMail.php	1.29 KB	-rwxrwxrwx
servfee.php	1.38 KB	-rwxrwxrwx
servicedet.php	1.6 KB	-rwxrwxrwx
stringspliter.php	693 B	-rwxrwxrwx
student.php	25.37 KB	-rwxrwxrwx
verifiedlistReport.php	7 KB	-rwxrwxrwx

Code Editor : mc-verify.php

<?php

require_once(__DIR__."/../../aws/aws-autoloader.php");
use Aws\S3\S3Client;
use Aws\S3\Exception\S3Exception;

function getMarksCardsForVerification($aobj_context)
{
	include('ceckFile.php');
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	$fregno = $aobj_context->mobj_data['fregno'];
	$db = $aobj_context->mobj_data['db'];
	$examno = json_decode($aobj_context->mobj_data['examno'], true);

$funivcode = '003';
	if($db == 'kusdde'){
		$funivcode = '003D';
	}

$rst = array();
	foreach($examno as $exam) {
		
		$res = checkDocument("{$funivcode}","{$fregno}","{$exam}");
		if(count($res) > 0) {
			$res_arr = array("fregno"=>$fregno, "furl" => "https://kuvempu-university-marks-card-verification.s3.ap-south-1.amazonaws.com/{$res[0]}" , "fsem" => $exam);
			array_push($rst, $res_arr);
		}
	}

$arr['mcfiles'] = $rst;
	
	
	echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
	return;		
}

function verifyMarksCard($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	session_start();
	$fregno = $aobj_context->mobj_data['fregno'];

$fremarks = $aobj_context->mobj_data['fremarks'];
	$fstatus = $aobj_context->mobj_data['status'];
	$examno = json_decode($aobj_context->mobj_data['examno'], true);

$fexamno = implode("*", $examno);
	
	$query = "insert into mcverify(fregno, fexamno, fverifyby, fverifydate, fstatus, fremarks)
	values('{$fregno}', '{$fexamno}', '{$_SESSION['username']}', now(), '{$fstatus}*', '{$fremarks}')";
	$rst = $aobj_context->mobj_db->Execute($query);
	if($rst) {
		$arr['appno'] = $aobj_context->mobj_db->insert_Id();
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
	}
	else {
		$arr['msg'] = "Error while Inserting";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Error"); 
	}
	return;		
}

function getSemsForUser($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	session_start();
	
	$query = "select distinct fexamno from degree 
	where instr('{$_SESSION['fdegree']}', fdegree) > 0 
	order by fexamno";
	$rst = $aobj_context->mobj_db->GetAll($query);

if(count($rst) > 0) {
		$arr['sems'] = $rst;
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
	}
	else {
		$arr['msg'] = "Error while fetching semisters.";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Error"); 
	}
	return;		
}

function getVerificationList($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	session_start();
	$fromdate = trim($aobj_context->mobj_data["fromdate"]);
	$todate = trim($aobj_context->mobj_data["todate"]);
	$fromroll = trim($aobj_context->mobj_data["fromroll"]);
	$toroll = trim($aobj_context->mobj_data["toroll"]);

$fromref = trim($aobj_context->mobj_data["fromref"]);
	$toref = trim($aobj_context->mobj_data["toref"]);
	
	// $query = "select fappno, fregno, fexamno, fverifyby, date_format(fverifydate, '%d/%m/%Y') as fvdate,
	// fstatus, fremarks from mcverify 
	// where fregno between '{$fromroll}' and '{$toroll}' and fappno >= '{$fromref}' and fappno <= '{$toref}'
	// and date_format(fverifydate,'%Y-%m-%d') between date_format(str_to_date('{$fromdate}', '%d/%m/%Y'),'%Y-%m-%d') 
	// and date_format(str_to_date('{$todate}', '%d/%m/%Y'),'%Y-%m-%d')";
	$query="SELECT st.fappno,DATE_FORMAT(fappdate,'%d/%m/%Y') AS fappdate,IFNULL(st.FAPPASSIGN,'') AS FAPPASSIGN, st.fregno, st.fname, st.fcategory, st.ftotal, 
			st.femail,st.fmobile,st.fpaystatus, st.fverifyuser,
			s.fservname,IFNULL(st.fverifystatus,'') AS fverifystatus, IFNULL(DATE_FORMAT(st.fverifydate,'%d/%m/%Y'),'')  AS fverifydate FROM servtran st INNER JOIN servtype s ON 
			s.fservcode =  st.fservcode
			WHERE LEFT(st.fverifydate,10) BETWEEN DATE_FORMAT(STR_TO_DATE('$fromdate','%d/%m/%Y'),'%Y-%m-%d') 
			AND DATE_FORMAT(STR_TO_DATE('$todate','%d/%m/%Y'),'%Y-%m-%d') 
			AND st.fregno BETWEEN '0' AND 'Z' AND st.fservcode='KS06' AND IFNULL(st.fverifystatus,'') = 'Verified'   AND 1=1 AND fpaystatus ='success'
				ORDER BY st.fappno, st.fregno";
	// var_dump($query);
	$rst = $aobj_context->mobj_db->GetAll($query);

if(count($rst) > 0) {
		$arr['mcverify'] = $rst;
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
	}
	else {
		$arr['msg'] = "No verification details found.";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Error"); 
	}
	return;		
	
}

function getLedgerForRegnoSem($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$alphabets = ['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J'];
	$fregno = trim($aobj_context->mobj_data["fregno"]);
	$fexamno = trim($aobj_context->mobj_data["fexamno"]);
	$fyear = trim($aobj_context->mobj_data["fyear"]);
	$db = trim($aobj_context->mobj_data["db"]);

$query = "select fdegree, fcollcode from student 
	where fregno = '{$fregno}'";
	$rst = $aobj_context->mobj_db->GetRow($query);
	// var_dump($rst);

if(count($rst) == 0) {
		$arr['msg'] = "Student Not found.";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
	}
	// $url = $_SERVER['REQUEST_URI'];
	// var_dump($db);

$collcode = $rst['fcollcode'];
	$degree = $rst['fdegree'];

$s3 = S3Client::factory(
		array(
			'credentials' => array(
				'key' => IAM_KEY,
				'secret' => IAM_SECRET
			),
			'version' => "latest",
			'region'  => 'ap-south-1'
		)
	);
	$sem = roman(array_search($fexamno, $alphabets) + 1);

$bucket = "kuvempu-university-marks-card-verification";

if($db == "kusdde"){
		$objects = $s3->getIterator('ListObjects', array(
			"Bucket" => $bucket,
			"Prefix" => "003D/Ledger/{$collcode}-{$degree}-{$sem}"
		));
	}else{
		$objects = $s3->getIterator('ListObjects', array(
			"Bucket" => $bucket,
			"Prefix" => "003/ledger/{$collcode}-{$degree}-{$sem}"
			));
	}
	$ledgers = array();
	// var_dump($objects);
	foreach ($objects as $object) {
		if(strpos($object['Key'], $fyear) !== false) {
			$arrn = explode('-', $object['Key']);
			$sems = explode('_', $arrn[2]);
			if($sems[0] == $sem){
				array_push($ledgers, 'https://kuvempu-university-marks-card-verification.s3.ap-south-1.amazonaws.com/'.$object['Key']);
			}
		}
	}
	// var_dump(count($ledgers));

if(count($ledgers) > 0 ) {
		$arr['ledgers'] = $ledgers;
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
	}
	else {
		$arr['msg'] = "Cannot find the ledgers";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Error"); 
	}
}

${this.title}

Code Editor : mc-verify.php