Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
applicationFormReportPOSTOFFIC...	19.27 KB	-rwxr-xr-x
applicationFormReportSBM.php	8.41 KB	-rwxr-xr-x
caccesscontext.php	1.24 KB	-rwxr-xr-x
cappcontext.php	2.66 KB	-rwxr-xr-x
code39.php	6.38 KB	-rwxr-xr-x
coutput.php	1.76 KB	-rwxr-xr-x
crequestbroker.php	2.49 KB	-rwxr-xr-x
csessions.php	514 B	-rwxr-xr-x
cuser.php	3.41 KB	-rwxr-xr-x
customappcontext.php	2.35 KB	-rwxr-xr-x
dropdown.php	844 B	-rwxr-xr-x
format.php	7.43 KB	-rwxr-xr-x
fpdf_protection.php	5.61 KB	-rwxr-xr-x
getdata.php	1.06 KB	-rwxr-xr-x
getnumword.php	7.15 KB	-rwxr-xr-x
instruction.html	9.62 KB	-rwxr-xr-x
json.php	33.2 KB	-rwxr-xr-x
kusphdadm.php	6.5 KB	-rwxr-xr-x
mregistry.php	4.97 KB	-rwxr-xr-x
re_rigistration.php	7.38 KB	-rwxr-xr-x
report_bulk_applications.php	6.06 KB	-rwxr-xr-x
report_hall_ticket.php	11.31 KB	-rwxr-xr-x
reportapplicationform - Copy.p...	19.59 KB	-rwxr-xr-x
reportapplicationform.php	23.92 KB	-rwxr-xr-x
rotation.php	596 B	-rwxr-xr-x
saveApplication.php	8.91 KB	-rwxr-xr-x
saveRerigistration.php	10.87 KB	-rwxr-xr-x
student.php	11.75 KB	-rwxr-xr-x
student_24092018.php	13.3 KB	-rwxr-xr-x
subfeedetl.php	3.39 KB	-rwxr-xr-x

Code Editor : student.php

<?php

function getcmsdropdownmenuvalues($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	$fappno = $aobj_context->mobj_data["fappno"];

$query3 = "SELECT feventcode AS int_code,feventname AS val FROM masevent 
	where ifnull(FDELETED,'') <> 'T' order by feventname";
	$rst3 = $aobj_context->mobj_db->GetAll($query3);
	$arr['event'] = $rst3;
	
	$query4 = "select fdistcode as int_code, fdistname as val from masdist 
	where ifnull(FDELETED,'') <> 'T' order by fdistname";
	 // var_dump($query4);
	$rst4 = $aobj_context->mobj_db->GetAll($query4);
	 // var_dump($rst4);
	$arr['distic'] = $rst4;
	if($fappno != '')
	{
		$query = "select FMOBILENO , FAPPNO,FAADHAR,FNAME , FFATNAME , FMOTNAME , date_format(FDOB,'%d/%m/%Y') as FDOB, FGENDER , FPERADD1 , FPERADD2, 
		FPERADD3 ,FPERDIST ,FPERPIN , FPERSTATE , FSECADD1 , FSECADD2 ,	FSECADD3 ,FPHOTOPATH,
		FSECDIST ,FSECPIN , FSECSTATE , FACCOUNT , FIFSC , FBANK ,FBRANCH, FTEACH , FTEACHMOB , FTEACHSEC,
		FTEACHSECADD, FEVENT , FEVENTL , date_format(FEVENTWD,'%d/%m/%Y') as FEVENTWD , FEVENTP 
		from student where fappno = '{$fappno}'";

$result = $aobj_context->mobj_db->GetRow($query);
		$arr['perdet'] = $result;
	}else
	{
		$arr['perdet'] = "F";
	}	
	
	echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
	return;

}

function getdegreedetails($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	$college = $aobj_context->mobj_data["college"];

$query = "select distinct  d.fdegree as int_code, concat(d.fdescpn,' - ',d.fdegree) as val from degree  d 
	where d.fexamno = 'A' and d.fadmdeg = 'T' and ifnull(d.fdeleted,'') <> 'T'
	order by d.fdescpn";
	$results = $aobj_context->mobj_db->GetAll($query);
	$arr['degree'] = $results;
	//
	echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
	return;
}

function getcombinationdetailsdetails($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	$college = $aobj_context->mobj_data["college"];
	$degree = $aobj_context->mobj_data["degree"];

$query = "select distinct  m.fcombcode as int_code, concat(m.fcombcode,' - ',m.FCOMBDESC) as val from mascomb m
	where m.fdegree = '{$degree}' and ifnull(m.fdeleted,'') <> 'T' order by m.fcombcode";
	$results = $aobj_context->mobj_db->GetAll($query);
	$arr['mascomb'] = $results;
	//
	echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
	return;
}

function getboarddetails($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	$boardCode = $aobj_context->mobj_data["boardCode"];

$query = "select fboardcode, fboardsate, fboardname, faddress, fphoneno 
	from masboard where fboardcode = '{$boardCode}' 
	order by forder";
	$results = $aobj_context->mobj_db->GetRow($query);
	$arr['boardDet'] = $results;
	//
	echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
	return;
}

function loadSubjectdet($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	$degree = $aobj_context->mobj_data["degree"];
	$combcode = $aobj_context->mobj_data["combcode"];
	$query = "select FTOTSUB from degree where fdegree ='{$degree}' and fexamno = 'A'";
	$results = $aobj_context->mobj_db->GetRow($query);
	$totsub = $results['FTOTSUB'];

$query = "SELECT fsubcode,fsubname,fsubshort  FROM degree d INNER JOIN subject s ON 
	s.FDEGREE=d.FDEGREE  AND  d.FEXAMNO=s.FEXAMNO
	WHERE d.FDEGREE='{$degree}' AND s.FEXAMNO='A' AND FMANDATORY='T' GROUP BY  s.FSUBCODE
	UNION
	SELECT s.FSUBCODE,s.FSUBNAME,s.FSUBSHORT  FROM degree d INNER JOIN subject s ON 
	s.FDEGREE=d.FDEGREE  AND  d.FEXAMNO=s.FEXAMNO
	LEFT JOIN mascomb m ON m.FDEGREE=d.FDEGREE AND m.fcombcode = '{$combcode}'
	WHERE d.FDEGREE='{$degree}'  AND m.FSUBCODE = s.FSUBCODE  
	GROUP BY  s.FSUBCODE";
	//var_dump($query);
	$mresults = $aobj_context->mobj_db->GetAll($query);
	$mtotalsub = count($mresults);

$remaing = $totsub - $mtotalsub;

$query = "select fsubcode,fsubname,fsubshort from subject 
	where fdegree = '{$degree}' 
	and fexamno = 'A' and ifnull(fmandatory,'F') <> 'T' 
	and ifnull(fretain,'F') <> 'T' and ifnull(fintass,'F') <> 'T'
	and ifnull(fsuspend,'F') <> 'T' and ifnull(fcombsub,'') <> 'T'";
	
	$rresults = $aobj_context->mobj_db->GetAll($query);

$arr['totsub'] = $totsub;
	$arr['mresults'] = $mresults;
	$arr['mtotalsub'] = $mtotalsub;
	$arr['rresults'] = $rresults;
	$arr['remaing'] = $remaing;

echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
	return;

}

function loadeditSubjectdet($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	$degree = $aobj_context->mobj_data["degree"];
	$combcode = $aobj_context->mobj_data["combcode"];
	$appno = $aobj_context->mobj_data["appno"];
	$query = "select FTOTSUB from degree where fdegree ='{$degree}' and fexamno = 'A'";
	$results = $aobj_context->mobj_db->GetRow($query);
	$totsub = $results['FTOTSUB'];

$remaing = $totsub - $mtotalsub;

$query = "select fsubcode,fsubname,fsubshort from subject 
	where fdegree = '{$degree}' 
	and fexamno = 'A' and ifnull(fmandatory,'F') = 'F' 
	and ifnull(fretain,'F') = 'F' and ifnull(fintass,'F') = 'F'
	and ifnull(fsuspend,'F') <> 'T' and ifnull(fcombsub,'') <> 'T'";
	
	$rresults = $aobj_context->mobj_db->GetAll($query);

$query = "select fsubcode from options where fappno = '{$appno}'";
	$option_sub = $aobj_context->mobj_db->GetAll($query);

$arr['option_sub'] = $option_sub;
	$arr['totsub'] = $totsub;
	$arr['mresults'] = $mresults;
	$arr['mtotalsub'] = $mtotalsub;
	$arr['rresults'] = $rresults;
	$arr['remaing'] = $remaing;

echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
	return;
}

function loadpgmarks($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	$appno = $aobj_context->mobj_data["appno"];

$query = "select fappno, fsubcode, fsubname, fsecmarksa, fmaxmarksa, fsecmarksb, fmaxmarksb, fsecmarksc, fmaxmarksc,
	fsecmarksd, fmaxmarksd, fsecmarkse, fmaxmarkse, fsecmarksf, fmaxmarksf, ftotsecmarks, ftotmaxmarks, fsubpercent  
	from qualsubdet where fappno = '{$appno}'";

$results = $aobj_context->mobj_db->GetAll($query);
	$arr['pgmarks'] = $results;

echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
	return;
}

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

$query = "select internal_code as int_code, 
	FCERTDESC as doc_type ,
	ifnull(FFILENAME,REPLACE(REPLACE(FCERTDESC,' ','_'),'+','_')) as FFILENAME
	from 
	masdoc where fdegree = 'MCOM1' order by forder";
	$results = $aobj_context->mobj_db->GetAll($query);
	$arr['masdoc'] = $results;

echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
	return;
}

function uploadeditdetails($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	
	$degree = $aobj_context->mobj_data["degree"];
	$fappno = $aobj_context->mobj_data["fappno"];
	$college = $aobj_context->mobj_data["college"];

$query = "SELECT DISTINCT m.internal_code AS int_code, 
	FCERTDESC AS doc_type ,
	IFNULL(FFILENAME,REPLACE(REPLACE(FCERTDESC,' ','_'),'+','_')) AS FFILENAME,
	ifnull(s.file_path,'') as file_path
	FROM masdoc m
	LEFT OUTER JOIN studoc s 
	ON s.fdegree = m.fdegree and s.fdoctype = m.FFILENAME 
	AND s.login_cnt = '{$fappno}' 
	AND s.fcollcode = '{$college}' where m.fdegree = '{$degree}'
	ORDER BY forder";
	// var_dump($query);
	$results = $aobj_context->mobj_db->GetAll($query);
	$arr['masdoc'] = $results;

echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
	return;
}

function getstudentdetails($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	session_start();
	$user_agent = $_SERVER['HTTP_USER_AGENT'];

$os_platform  = "Unknown OS Platform";

$os_array     = array(
          '/windows nt 10/i'      =>  'Windows 10',
          '/windows nt 6.3/i'     =>  'Windows 8.1',
          '/windows nt 6.2/i'     =>  'Windows 8',
          '/windows nt 6.1/i'     =>  'Windows 7',
          '/windows nt 6.0/i'     =>  'Windows Vista',
          '/windows nt 5.2/i'     =>  'Windows Server 2003/XP x64',
          '/windows nt 5.1/i'     =>  'Windows XP',
          '/windows xp/i'         =>  'Windows XP',
          '/windows nt 5.0/i'     =>  'Windows 2000',
          '/windows me/i'         =>  'Windows ME',
          '/win98/i'              =>  'Windows 98',
          '/win95/i'              =>  'Windows 95',
          '/win16/i'              =>  'Windows 3.11',
          '/macintosh|mac os x/i' =>  'Mac OS X',
          '/mac_powerpc/i'        =>  'Mac OS 9',
          '/linux/i'              =>  'Linux',
          '/ubuntu/i'             =>  'Ubuntu',
          '/iphone/i'             =>  'iPhone',
          '/ipod/i'               =>  'iPod',
          '/ipad/i'               =>  'iPad',
          '/android/i'            =>  'Android',
          '/blackberry/i'         =>  'BlackBerry',
          '/webos/i'              =>  'Mobile'
    );

foreach ($os_array as $regex => $value)
        if (preg_match($regex, $user_agent))
            $os_platform = $value;

$mobile = 'F';
	if($os_platform == 'Mobile' || $os_platform == 'Android' || $os_platform == 'iPhone')
	{
		$mobile = 'T';
	}

$query = "select s.fname,date_format(s.fdob,'%d-%m-%Y') as dob,s.ffatname,
    s.fmobileno,e.feventname,fappno from student s inner join masevent e on s.fevent = e.feventcode
    where s.FENTEREDmob = '{$_SESSION['MOBILE']}' and  s.FENTEREDDIST = '{$_SESSION['DISTCPDE']}' ";
	// var_dump($query);
	$rst = $aobj_context->mobj_db->GetAll($query);
	
	if($rst)
	{
		echo $aobj_context->mobj_output->ToJSONEnvelope($rst,0,"success"); 
		return;			
	}		
	else
	{	
		$error_msg = 'Not a valid Register no.';
		echo $aobj_context->mobj_output->ToJSONEnvelope($error_msg,-1,"failure");
		return;	
	}				
}

function replaceChars($name)
{
	$spl_char = array("*","/","~","!","@","#","$","%","^","&",":",";","?","/","\\","_","-","'"," ","");
	$link_name = strtolower(str_replace($spl_char,"_",$name));
	return str_ireplace("__","_",$link_name);
}

function submitquery($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	
	$fmessage = $aobj_context->mobj_data["fmessage"];
	$fsubject = $aobj_context->mobj_data["fsubject"];
	$femail   = $aobj_context->mobj_data["femail"];

$query = "select funivcode from control";
	$rst = $aobj_context->mobj_db->GetRow($query);
	$funivcode = $rst['funivcode'];

if($_SESSION['MOBILE'] != '')
	{	
		
		$query = "insert into logisys3_grv.grvhead(fgrvdate,fgrvfrom,fgrvemail,fgrvmobile,fgrvsub,
		fgrvmsg,fgrvuser,fgrvmode,funivcode,fstudemail)
		values (now(),'{$_SESSION['NAME']}','{$_SESSION['EMAIL']}','{$_SESSION['MOBILE']}',
		'{$fsubject}','{$fmessage}','Student','helpdesk','{$funivcode}','{$femail}')";
		//var_dump($query);
		$results = $aobj_context->mobj_db->Execute($query);	
		$last_inserted_id = $aobj_context->mobj_db->Insert_ID();
		
		if($results)
		{
			$msg = $last_inserted_id;
			echo $aobj_context->mobj_output->ToJSONEnvelope($msg,0,"success"); 
			return;			
		}		
		else
		{	
			$error_msg = 'Not able to submit the query. please try after some time.';
			echo $aobj_context->mobj_output->ToJSONEnvelope($error_msg,-1,"failure");
			return;	
		}

}
	else
	{

$error_msg = 'Please login to submit the query.';
		echo $aobj_context->mobj_output->ToJSONEnvelope($error_msg,-2,"failure");
		return;
	}	
	
}
?>

${this.title}

Code Editor : student.php