Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
Tickets.php	7.03 KB	-rw-rw-r--
attendance.php	3.07 KB	-rwxr-xr-x
commandb.php	412 B	-rwxr-xr-x
database.php	476 B	-rwxr-xr-x
examapp.php	3.19 KB	-rwxr-xr-x
examapp_iframe.php	1.1 KB	-rwxr-xr-x
examtimetable.php	2.85 KB	-rwxr-xr-x
hallticket.php	3.1 KB	-rwxr-xr-x
helpDesk.php	1.12 KB	-rwxr-xr-x
iamarks.php	3.12 KB	-rwxr-xr-x
login.php	703 B	-rwxr-xr-x
logout.php	212 B	-rwxr-xr-x
practicaltimetable.php	3.21 KB	-rwxr-xr-x
profile.php	2.19 KB	-rwxr-xr-x
results.php	1.58 KB	-rwxr-xr-x

Code Editor : hallticket.php

<?php

include("database.php");

include("commandb.php");

//session_start();
$UNIVCODE  = $_SESSION['UNIVCODE'];
$query = "INSERT INTO menulog(funivcode,fdate,fhallticket)
VALUES('{$UNIVCODE}',date_format(now(),'%Y-%m-%d'),1)
ON DUPLICATE KEY UPDATE fhallticket = if(ifnull(fhallticket,'') = '', 1,fhallticket+1)";

$results = mysqli_query($conndb,$query);

$strUserLogQuery = "insert into userlog 
	(funivcode, fregno, fmobileno, fipadd, FREASONCODE, FDESCPN)
	values ('{$_SESSION['UNIVCODE']}', '{$_SESSION['REGNO']}', 
	'{$_SESSION['MOBILE']}', '{$_SERVER['REMOTE_ADDR']}', 
	'HTMN', 'HTMN - {$_SESSION['REGNO']} Viewed Hall Ticket')";
$result = mysqli_query($conndb,$strUserLogQuery);

$regno  = $_SESSION['REGNO'];
$FUNIVCODE  = $_SESSION['UNIVCODE'];

$folder  = $_SESSION['FOLDER'];

$degree = $_SESSION['DEGREE'];
$collcode = $_SESSION['COLLCODE'];

$url = dirname(__FILE__);

$path = "/home/logisys32/public_html/oasis/".$folder.'/halltickets/'.'HT_'.$FUNIVCODE.'_'.$regno.'.pdf';
//echo $path;

$durl='http://oasis.logisys.org/'.$folder.'/halltickets/'.'HT_'.$FUNIVCODE.'_'.$regno.'.pdf';
//echo $durl;
$url = 'http://docs.google.com/gview?url=http://oasis.logisys.org/'.$folder.'/halltickets/'.'HT_'.$FUNIVCODE.'_'.$regno.'.pdf&embedded=true';

$fileName = 'HT_'.$regno.'.pdf';

$dateQuery = "select DATE_FORMAT(NOW(),'%Y-%m-%d') as presentdate, 
DATE_FORMAT(collexam.fhtfrom, '%d/%m/%Y') AS FROMDATE, 
DATE_FORMAT(collexam.fhtto, '%d/%m/%Y') as lastdate from collexam 
where fcollcode = '{$_SESSION['COLLCODE']}' 
and fdegree = '{$_SESSION['DEGREE']}'
and DATE_FORMAT(NOW(),'%Y-%m-%d') between collexam.fhtfrom
AND collexam.fhtto";

$dateResult = mysqli_query($conn,$dateQuery);
$count = mysqli_num_rows($dateResult);

if($count > 0)
{
	$row1 = mysqli_fetch_assoc($dateResult);
	$uploadRequest = array(
	 	    'degree_code' => $_SESSION['DEGREE'],
	 	    'fcollcode' => $_SESSION['COLLCODE'],
	 	    'reg_starts' => $_SESSION['REGNO'],
	 	    'reg_ends' => $_SESSION['REGNO'],
			'FUNIVCODE' => $_SESSION['UNIVCODE']
	 	);

// Execute remote upload
	 	$curl = curl_init();
	 	curl_setopt($curl, CURLOPT_URL, 'http://oasis.logisys.org/'.$folder.'/app.php?a=generatePostAdmissionTicket.demo');
	 	curl_setopt($curl, CURLOPT_TIMEOUT, 30);
	 	curl_setopt($curl, CURLOPT_POST, 1);
	 	curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
	 	curl_setopt($curl, CURLOPT_POSTFIELDS, $uploadRequest);
	 	$response = curl_exec($curl);
	 	curl_close($curl);
	 	//echo $response;

if(file_exists($path))
	{
		$strUpdateQuery = "update candsum set fhtstatus = 'T' 
		where fdegree = '{$degree}'
		and fcollcode = '{$collcode}'
		and fregno = '{$regno}'";
		$updateHtResult = mysqli_query($conn,$strUpdateQuery);

$row['status'] = 'success';
		$row['url'] = $url;
		$row['durl'] = $durl;
		$row['fileName'] = $fileName;
	}
	else if($_SESSION['EXAMBLK'] == 'T')
	{
		$row['status'] = 'failure';
		$row['msg'] = "Hall Ticket is blocked. Contact college.";
	}
	else
	{
		$row['status'] = 'failure';
		$row['msg'] = "Hall Ticket will be available in college";
	}	
}
else
{
	$row['status'] = 'error';
	$row['msg'] = "Hall Tickect is not available";
}

echo json_encode($row);

${this.title}

Code Editor : hallticket.php