Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
PrinChallan.php	698 B	-rwxr-xr-x
Thumbs.db	19 KB	-rwxr-xr-x
applicationFormReport.php	9.98 KB	-rwxr-xr-x
applicationFormReportNEFT.php	10.86 KB	-rwxr-xr-x
applicationFormReportPOSTOFFIC...	13.17 KB	-rwxr-xr-x
applicationFormReportSBM.php	16.63 KB	-rwxr-xr-x
cappcontext.php	2.64 KB	-rwxr-xr-x
cappdu.php	4.09 KB	-rwxr-xr-x
code128.php	14.86 KB	-rwxr-xr-x
code39.php	6.38 KB	-rwxr-xr-x
coutput.php	1.75 KB	-rwxr-xr-x
crequestbroker.php	2.49 KB	-rwxr-xr-x
csessions.php	516 B	-rwxr-xr-x
cuser.php	3.41 KB	-rwxr-xr-x
customappcontext.php	2.34 KB	-rwxr-xr-x
download_upload.html	3.64 KB	-rwxr-xr-x
getnumword.php	7.15 KB	-rwxr-xr-x
json.php	33.22 KB	-rwxr-xr-x
mregistry.php	1.63 KB	-rwxr-xr-x
process_payment.php	3.64 KB	-rwxr-xr-x
results.php	35.28 KB	-rwxr-xr-x
results_08032018.php	35.27 KB	-rwxr-xr-x
results_19022018.php	34.87 KB	-rwxr-xr-x
revaluation.php	23.08 KB	-rwxr-xr-x
rotation.php	598 B	-rwxr-xr-x

Code Editor : results_19022018.php

<?php

class results
{ 
	public $drop_down_arr;
	function __construct($aobj_context)
	{
		session_start();
		$this->aobj_context=$aobj_context;
		$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	}
	
	function dashboardMessageBoard()
	{
		$get_all_message="select message from message_board where current_date() between display_from
						  and display_to and college_code='RES' order by 1 desc ";
		$lobj_get_all_message = $this->aobj_context->mobj_db->GetRow($get_all_message);

$this->mess_data=$lobj_get_all_message['message'];

if(empty($this->mess_data))
		{
			$this->mess_data="<br><b>All the best.</b><br>
			<br><p justify></p>";
		}
			
	}
	
	function PopulateResultDegreeList()
	{
		
		$query = "select funivcode,FREGROLL as reg_text from control";	
		$this->results = $this->aobj_context->mobj_db->GetRow($query);
		$funivcode = $this->results['funivcode'];
		$_SESSION['G_FREGROLL'] = $this->results['reg_text'];
		
		$degreename = 'Reference';
		$examname   = 'Exam';
		
		if($funivcode == '031')
		{
			$degreename = 'Programme';
			$examname   = 'Semester';
		}	
		
		$this->html.="";
		$this->html.="<table  align='center' id='degree_table_data' width='100%' border='0' cellspacing='0' cellpadding='0'>";
		$this->html.="<tr class='tr_bg'>";
		if($funivcode != '031')
			$this->html.="<td  width='10%' style='border-left:1px solid #a1a1a1; border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'>Degree</td>";
		
		$this->html.="<td  width='50%' style='border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'>{$degreename}</td>";
		$this->html.="<td  width='20%' style='border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'>{$examname}</td>";
		
		if($funivcode != '031')
			$this->html.="<td  width='10%' style='border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'>Scheme </td>";
		
		$this->html.="<td  width='10%' style='border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'>Result Date </td>";
		$this->html.="</tr>";					
	
		$k=0;
		$sl=1;
		$get_data="SELECT FDEGREE,FDESCPN,FEXAMNO,FEXAMNAME,
		DATE_FORMAT(FRESULTDATE,'%d/%m/%Y') AS FRESULTDATE,FRESULTSCHEME
		FROM degree  
		WHERE IFNULL(FRESULTDATE,'0000-00-00')!='0000-00-00'
		ORDER BY FRESULTORDER desc, FDEGREE, FEXAMNO";
		
		$this->app_data=$this->aobj_context->mobj_db->GetAll($get_data);
		foreach($this->app_data as $k=>$v)
		{
			$FDEGREE       = $v['FDEGREE'];
			$FDESCPN       = $v['FDESCPN'];
			$FEXAMNO       = $v['FEXAMNO'];
			$FEXAMNAME     = $v['FEXAMNAME'];
			$FRESULTDATE   = $v['FRESULTDATE'];
			$FRESULTSCHEME = $v['FRESULTSCHEME'];

if($k%2==0)
				$class='tbl_row';
			else
				$class='tbl_row_alter';

$this->html.="<tr>";
			$this->html.="<td class={$class} style='border-left:1px solid #a1a1a1; border-right:1px solid #a1a1a1;' align='center'>{$FDEGREE}</td>";
			$this->html.="<td class={$class} style='text-align:left; border-right:1px solid #a1a1a1;' align='center'>{$FDESCPN}</td>";
			$this->html.="<td class={$class} style='text-align:left; border-right:1px solid #a1a1a1;'>{$FEXAMNAME}</td>";				
			$this->html.="<td class={$class} style='text-align:center; border-right:1px solid #a1a1a1;'>{$FRESULTSCHEME}</td>";				
			$this->html.="<td class={$class} style='line-height: 22px;text-align:center; border-right:1px solid #a1a1a1;'>{$FRESULTDATE}</td>";	
			$this->html.="</tr>";
			$sl++;
			$k++;
		}	
		
		$this->html.=" </table>";
		$arr["html"]=$this->html;
		$arr["funivcode"]=$this->results['funivcode'];;
		$arr["reg_text"]=$this->results['reg_text'];
		$arr["mess_data"]=$this->mess_data;
		echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
		return;			
	}
	
	function DisplayStudentResult()
	{
		session_start();
		$this->reg_no   = trim($this->aobj_context->mobj_data['r']);		 
		$this->exam     = trim($this->aobj_context->mobj_data['e']);
		$this->category = trim($this->aobj_context->mobj_data['ct']);
		
		if(empty($this->reg_no) || $this->reg_no=="undefined")
		{
			$arr['html']="Register number should be entered";
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
			return;	
		}
		else if(empty($this->exam) || $this->exam=="undefined")
		{
			$arr['html']="Year / Semester should be selected";
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
			return;	
		}
		
		$get_result_date="select FCOLLCODE,
						DATE_FORMAT(FRESULTDATE,'%d/%m/%Y') as FRESULTDATE,
						DATE_FORMAT(IFNULL(FRVLASTDATE,'0000-00-00'),'%d/%m/%Y') as FRVLASTDATE,
						DATE_FORMAT(IFNULL(FRTLASTDATE,'0000-00-00'),'%d/%m/%Y') as FRTLASTDATE,
						DATE_FORMAT(IFNULL(FXEROXLASTDATE,'0000-00-00'),'%d/%m/%Y') as FXEROXLASTDATE,
						DATE_FORMAT(IFNULL(FCVLASTDATE,'0000-00-00'),'%d/%m/%Y') as FCVLASTDATE
						from res_fee where FREGNO = '{$this->reg_no}' and FEXAMNO = '{$this->exam}'";
						//var_dump($get_result_date);
		$obj_get_result_date=$this->aobj_context->mobj_db->GetRow($get_result_date);
		
		$_SESSION['g_reg_no']    = $this->reg_no;
		$_SESSION['g_FEXAMNO']   = $this->exam;
		$_SESSION['g_category']  = $this->category;
		$_SESSION['g_FCOLLCODE'] = $obj_get_result_date['FCOLLCODE'];
		
		$FRESULTDATE    = $obj_get_result_date['FRESULTDATE'];		
		$FRVLASTDATE    = $obj_get_result_date['FRVLASTDATE'];		
		$FRTLASTDATE    = $obj_get_result_date['FRTLASTDATE'];		
		$FCVLASTDATE    = $obj_get_result_date['FCVLASTDATE'];		
		$FXEROXLASTDATE = $obj_get_result_date['FXEROXLASTDATE'];	
		
		$scroll_txt = " Last Date for ";
		
		if($FRVLASTDATE!="00/00/0000")
		{
			$scroll_txt.=" RV : {$FRVLASTDATE} &nbsp;&nbsp;";
		}
		if($FRTLASTDATE!="00/00/0000")
		{
			$scroll_txt.=" RT : {$FRTLASTDATE} &nbsp;&nbsp; ";
		}
		if($FXEROXLASTDATE!="00/00/0000")
		{
			$scroll_txt.=" Photo Copy : {$FXEROXLASTDATE} &nbsp;&nbsp;";
		}
		if($FCVLASTDATE!="00/00/0000")
		{
			$scroll_txt.=" CV : {$FCVLASTDATE} &nbsp;&nbsp;";
		}
		
		if($scroll_txt==" Last Date for ")
			$scroll_txt="";

$get_data="SELECT IFNULL(FRVFEE,0)+IFNULL(FRTFEE,0)+IFNULL(FXEROXFEE,0)+IFNULL(FCVFEE,0) AS rv_rt_total_fee,
				s.FDEGREE,d.FDESCPN, s.FEXAMNO,d.FEXAMNAME,s.FCOLLCODE,concat(c.FCOLLNAME,', ', c.FTOWN) as FCOLLNAME,d.FRESEXAMDATE,
				s.FREGNO,s.FNAME,s.FAYEAR,d.FELIGREM01,d.FELIGREM02,ifnull(s.FFATNAME,'') as FFATNAME,ifnull(s.FMOTNAME,'') as MOTNAME 
				FROM student s INNER JOIN college c ON c.FCOLLCODE=s.FCOLLCODE INNER JOIN degree d ON d.FDEGREE=s.FDEGREE
				where s.FREGNO = '{$this->reg_no}' and d.fexamno = '{$this->exam}'";
				//var_dump($get_data);
		$obj_student=$this->aobj_context->mobj_db->GetRow($get_data); 
		
		$_SESSION['g_FDEGREE'] = $obj_student['FDEGREE'];
		
		if(empty($obj_student))
		{
			$arr['html']="Invalid Register number / No Results found";
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
			return;	
		}
		
		$get_remarks     = "SELECT FRESULT_REMARKS, FUNIVCODE, FREGROLL FROM control";
		$obj_get_remarks = $this->aobj_context->mobj_db->GetRow($get_remarks);
		
		$remarks  = $obj_get_remarks['FRESULT_REMARKS'];	
		$univcode = $obj_get_remarks['FUNIVCODE'];
		$FREGROLL = $obj_get_remarks['FREGROLL'];
		
		$rv_rt_total_fee  = $obj_student['rv_rt_total_fee'];
		$FDEGREE          = $obj_student['FDEGREE'];
		$FDESCPN          = $obj_student['FDESCPN'];
		$FEXAMNO          = $obj_student['FEXAMNO'];
		$FEXAMDATE        = $obj_student['FRESEXAMDATE'];
		$FEXAMNAME        = $obj_student['FEXAMNAME'];
		$FCOLLCODE        = $obj_student['FCOLLCODE'];
		$this->FCOLLCODE  = $obj_student['FCOLLCODE'];
		$FCOLLNAME        = $obj_student['FCOLLNAME'];
		$this->FCOLLNAME  = $obj_student['FCOLLNAME'];
		$FREGNO           = $obj_student['FREGNO'];
		$FNAME            = $obj_student['FNAME'];
		$FFATNAME         = $obj_student['FFATNAME'];
		$MOTNAME          = $obj_student['MOTNAME'];
		$FAYEAR           = $obj_student['FAYEAR'];
		$FELIGREM01       = $obj_student['FELIGREM01'];
		$this->FELIGREM01 = $obj_student['FELIGREM01'];
		$FELIGREM02       = $obj_student['FELIGREM02'];
		$this->FELIGREM02 = $obj_student['FELIGREM02'];
		
		$tr1=" {$FEXAMNAME} {$FDESCPN} ";
		$tr4=" {$FEXAMDATE} Examinations";		
		$tr2=" {$FREGROLL} : {$FREGNO}";			
		$tr3=" Name of the Student : {$FNAME}";
		
		############ Writing Student Info START########################	
		/*  Display Application status - 06/07/2015      */
		
		$get_rvrtStatus = "select fcorrtype from res_stud 
						where fregno = '{$this->reg_no}' and fexamno = '{$this->exam}' and fpaymentstatus = 'success'";
		$obj_get_rvrtStatus = $this->aobj_context->mobj_db->GetAll($get_rvrtStatus);
		
		$rvDesp = '';
		$rtDesp = '';
		$cvDesp = '';
		$vrSlash = 0;
		$vrSlashSymb ='';
		$vrSlash2 = 0;
		$rspending = '';
		
		foreach($obj_get_rvrtStatus as $rvrtkey=>$rvrtVal)
		{
			if($rvrtVal['fcorrtype'] == 'RV')
			{
				$rvDesp = 'Re-valuation';
				$rspending='Result pending';
				$vrSlash =1;
			}
			
			if($rvrtVal[fcorrtype] == 'CV')
			{	
				if($vrSlash == 1)
				$vrSlashSymb = ' / ';
				$cvDesp = $vrSlashSymb.'Challenge valuation';
				$rspending='Result pending';
			}
		}
		
		$rcrtcvDesp = '';
		if($obj_get_rvrtStatus)
		{	
			$get_rvrtFeeStatus="select ifnull(fcorrtype,'') as fcorrtype from res_fee 
			where fregno = '{$this->reg_no}' and fexamno = '{$this->exam}'";
			
			$obj_get_rvrtFeeStatus=$this->aobj_context->mobj_db->GetRow($get_rvrtFeeStatus);

$rvrtArray = (explode(",",$obj_get_rvrtFeeStatus[fcorrtype]));
			if($obj_get_rvrtFeeStatus)
			{
				if($obj_get_rvrtFeeStatus[fcorrtype] != '')
				{
					
					$vrSlash =0;
					$vrSlashSymb ='';
					
					foreach($rvrtArray as $rvrtArrayVal)
					{
						if($rvrtArrayVal == 'RV')
						{
							$rvFeeDesp = 'Re-valuation';
							$slashRV =1;
						}
						if($rvrtArrayVal == 'RT')
						{
							$rtFeeDesp = 'Re-totalling';
							$slashRT =1;
						}
						if($rvrtArrayVal == 'CV')
						{
							$cvFeeDesp = $vrSlashSymb.'Challenge valuation';
							$slashCV =1;
						}

}
					
					if($slashRV == 1 && $slashRT == 1)
						$vrSlashSymb = ' / ';
					if($slashRT == 1 && $slashCV == 1)
						$vrSlashSymb2 = ' / ';
					if($slashRV == 1 && $slashCV == 1)
						$vrSlashSymb2 = ' / ';	
					
					/* $rcrtcvDesp = $rvFeeDesp .'  '.$vrSlashSymb.$rtFeeDesp.'  '.$vrSlashSymb2.$cvFeeDesp.' '.'Result';
					$this->html.="<div style='text-align:center;font-size:18px;width:100%;font-weight:bold;color:green;margin-bottom:10px;'><u>{$rcrtcvDesp}</u></div>"; */
				}
				else
				{
					$rcrtcvDesp = $rvDesp .'  '.$rtDesp.'  '.$cvDesp.' '.$rspending;
					$this->html.="<div style='text-align:center;font-size:18px;width:100%;font-weight:bold;color:red;margin-bottom:10px;'><u>{$rcrtcvDesp}</u></div>";
				}
			}
		}
		
		$this->html.="<table width=70% align=center class = 'result_table_header' id = 'student_info'>
		<tr style='height:22px;'><td align=center>{$tr1}</td></tr>
		<tr style='height:22px;'><td align=center>{$tr4}</td></tr>
		<tr style='height:22px;' ><td align=center >{$tr2}</td></tr>
		<tr style='height:22px;' ><td align=center >{$tr3}</td></tr>";
		$this->html.="</table>";
		
		if(!empty($FFATNAME) || !empty($MOTNAME))
		{
			$this->html.="<table width=100% align=center class='result_table_header' id='student_info'>
			<tr style='height:22px;'><td align=left>Father Name :  {$FFATNAME}</td><td align=right>Mother Name : {$MOTNAME}</td></tr> 
			</table>";
		}
		############ Writing Student Info END########################	
		$get_data = "select  count(1) as held_cnt, if(ifnull(fmcnumber,'') = '','',concat('Withheld Reason : ',fmcnumber)) as fwhrem
					from resmarks rm where FREGNO='{$this->reg_no}' and 
					rm.FEXAMNO='{$this->exam}' and FCLASS='WITHHELD'";
					//var_dump($get_data);
		$obj_held = $this->aobj_context->mobj_db->GetRow($get_data); 
	
		$held_cnt = $obj_held['held_cnt'];
		
		$this->with_held_text="";
		
		if($held_cnt==0)
		{
			$this->WriteSubjectWiseResult();
		}
		else
		{
			$this->with_held_text="<table width='900px' align=center class='result_table_header'><tr style='height:22px;'><td align=center><span style='font-weight:bold;color:red;font-size: 21px;'>WITHHELD</span></td></tr><tr></tr>
			<tr style='height:22px;'><td align=center><span style='font-weight:bold;font-size: 18px;align:center;'>{$obj_held['fwhrem']}</span><td></tr></table>";
			/*
			$this->with_held_text.="<table width='700px' class='result_table_remarks' style='border-top:2px solid #fff;color:#000' align=center border='0' cellspacing='0' cellpadding='5'><tr style='height:22px;'>
			<td align=center style='border-left:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;border-top:1px solid #a1a1a1;'>Sl.No.</td>
			<td align=center style='border-left:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;border-top:1px solid #a1a1a1;'>Withheld Reason</td>
			<td align=center style='border-left:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;border-right:1px solid #a1a1a1; border-top:1px solid #a1a1a1;'>Remarks</td>
			</tr>
			<tr>
			<td align=center style='border-left:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;'>1</td>
			<td align='left' style='border-left:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;'>Exam Fee Not Paid</td>
			<td align=center style='border-left:1px solid #a1a1a1; border-right:1px solid #a1a1a1;border-bottom:1px solid #a1a1a1;'>Send Fee Paid Details to Registrar(Ev) Through Study Center / College</td>
			</tr>
			<tr>
			<td align=center style='border-left:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;'>2</td>
			<td align='left' style='border-left:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;'>IA. (TH) / I.A. (PR) Pending</td>
			<td align=center style='border-left:1px solid #a1a1a1; border-right:1px solid #a1a1a1;border-bottom:1px solid #a1a1a1;'>Contact Study Center / College</td>
			</tr>
			<tr>
			<td align=center style='border-left:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;'>3</td>
			<td align='left' style='border-left:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;'>Double The Duration</td>
			<td align=center style='border-left:1px solid #a1a1a1; border-right:1px solid #a1a1a1;border-bottom:1px solid #a1a1a1;'>Contact Study Center / College</td>
			</tr>
			</table>";
			*/
		}

if($this->error_found==1)
		{
			$arr['html'] = "Invalid Register number / No Results found";
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
			return;	
		}

$this->html.="{$this->with_held_text}<br><table width=100% align=left class='result_table_remarks'>
		<tr><td align=left style='text-align:justify;'>{$remarks} </td></tr>";
		$this->html.="</table>";

$arr['html'] = $this->html;		
		$arr['scroll_txt']  = "<marquee  direction='left' scrollamount='3' onmouseover ='scrollAmount=\"0\"' onmouseout='scrollAmount=\"3\"'>".$scroll_txt."</marquee>";		
		$arr['FRESULTDATE'] = $FRESULTDATE;		
		$arr['rv_rt_total_fee'] = $rv_rt_total_fee;

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

}
	
	function WriteSubjectWiseResult()
	{
		$get_data = "select if(FSUBSIDARY = 'T',concat(s.FSUBNAME,' **'),s.FSUBNAME) as FSUBNAME,s.FLTP,
					sum(s.FSMAXMARKS) as FSMAXMARKS,
					if(FTHUE='','-',FTHUE) as FTHUE ,
					if(FPRUE='','-',FPRUE) as FPRUE ,
					if(FTHVV='','-',FTHVV) as FTHVV ,
					if(FPRVV='','-',FPRVV) as FPRVV,
					if(FTHIA='','-',FTHIA) as FTHIA,
					if(FPRIA='','-',FPRIA) as FPRIA,
					if(FTHTOT='','-',FTHTOT) as FTHTOT,
					if(FPRTOT='','-',FPRTOT) as FPRTOT,
					if(FTHPASSMTH='','-',FTHPASSMTH) as FTHPASSMTH,
					if(FPRPASSMTH='','-',FPRPASSMTH) as FPRPASSMTH,
					if(FCREDITS = '','-',FCREDITS) as FCREDITS,
					if(ifnull(FGP,'') = '','-',FGP) as FGP,
					if(ifnull(FCP,'') = '','-',FCP) as FCP,
					if(ifnull(FGRADE,'') = '','-',FGRADE) as FGRADE,
					if(ifnull(FSGPA,'') = '','-',FSGPA) as FSGPA,
					if(ifnull(FCGPA,'') = '','-',FCGPA) as FCGPA,
					FMAXMARKS,FTOTMARKS,FPREVMAX,FPREVTOT,FPERCENT,FCLASS,FMCNUMBER,FYEAR,FEXAMTYPE, FSCHEME
					from resmarks rm
					inner join subject s on s.FDEGREE=rm.FDEGREE
					and s.FEXAMNO=rm.FEXAMNO and s.FSUBCODE=rm.FSUBCODE 
					where rm.FREGNO='{$this->reg_no}' and 
					rm.FEXAMNO='{$this->exam}'
					group by s.FSUBCODE";
					//var_dump($get_data);
		$this->app_data = $this->aobj_context->mobj_db->GetAll($get_data); 
		$this->error_found=0;

if(count($this->app_data)>0)
		{	
			$this->error_found=0;
			$this->html.="<br>";
			
			$this->FSCHEME = $this->app_data[0][FSCHEME];
			
			$get_remarks     = "SELECT FRESULT_REMARKS, FUNIVCODE FROM control";
			$obj_get_remarks = $this->aobj_context->mobj_db->GetRow($get_remarks);
			
			$univcode        = $obj_get_remarks['FUNIVCODE'];
			
			if($this->FSCHEME == 'CR')
			{
				$title1 = array('Sl. No.','Subject Name',"<div style='padding:5px;'>Th</div><div>Pr</div>",
				'Sem. End Exam','Viva','I.A.','Total',"<div style='padding:5px;'>Credit</div><div>Hrs</div>","<div style='padding:5px;'>Grade</div><div>Points</div>","<div style='padding:5px;'>Credit</div><div>Points</div>",'Result');
				$w      = array('5','50','5','8','8','8','8','10');
					
					
					
				$w      = array('5','50','5','8','8','8','8','8','8','8','10');
				
			}else
			{		
				$title1 = array('Sl. No.','Subject Name',"<div style='padding:5px;'>Th</div><div>Pr</div>",
				'Sem. End Exam','Viva','I.A.','Total','Remarks');
				$w      = array('5','50','5','8','8','8','8','10');
			}
			
			for($i = 0;$i<count($title1);$i++)
			{
				$table.= "<td  width = '{$w[$i]}%' style ='border-left:1px solid #a1a1a1; border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'>{$title1[$i]}</td>";
			}
			
			$this->html.="<table  align='center' id='results_subject_table' width='100%' border='0' cellspacing='0' cellpadding='3'>";       			
			$this->html.="<tr class='tr_bg1'>";
			$this->html.= $table;

$this->FMAXMARKS = $this->app_data[0][FMAXMARKS];
			$this->FTOTMARKS = $this->app_data[0][FTOTMARKS];
			$this->FPREVMAX  = $this->app_data[0][FPREVMAX];
			$this->FPREVTOT  = $this->app_data[0][FPREVTOT];
			$this->FPERCENT  = $this->app_data[0][FPERCENT];
			$this->FCLASS    = $this->app_data[0][FCLASS];
			$this->FMCNUMBER = $this->app_data[0][FMCNUMBER];
			$this->FYEAR     = $this->app_data[0][FYEAR];
			$this->FEXAMTYPE = $this->app_data[0][FEXAMTYPE];	
			$this->FSCHEME   = $this->app_data[0][FSCHEME];	
		
			$this->html.="</tr>";
			$sl_no=1;
			foreach($this->app_data as $k=>$v)
			{
				$FSUBNAME   = $v['FSUBNAME'];
				$FSMAXMARKS = $v['FSMAXMARKS']; 
				$FLTP       = $v['FLTP'];
				$FTHUE      = $v['FTHUE'];
				$FPRUE      = $v['FPRUE'];
				$FTHVV      = $v['FTHVV'];
				$FPRVV      = $v['FPRVV'];
				$FTHIA      = $v['FTHIA'];
				$FPRIA      = $v['FPRIA'];
				$FTHTOT     = $v['FTHTOT'];
				$FPRTOT     = $v['FPRTOT'];
				$FGRADE     = $v['FGRADE']; 
				$FTHPASSMTH = trim($v['FTHPASSMTH']);
				$FPRPASSMTH = trim($v['FPRPASSMTH']);

$FTHPASSMTH = preg_replace("/[^A-Za-z0-9+-]/","",$FTHPASSMTH); 
				$FPRPASSMTH = preg_replace("/[^A-Za-z0-9+-]/","",$FPRPASSMTH);

$FEXAMNO       = $v['FEXAMNO'];
				$FEXAMNAME     = $v['FEXAMNAME'];
				$FRESULTDATE   = $v['FRESULTDATE'];
				$FRESULTSCHEME = $v['FRESULTSCHEME'];
				$FCREDITS      = $v['FCREDITS'];
				$FGP           = $v['FGP'];
				$FCP           = $v['FCP'];
				$FSGPA         = $v['FSGPA'];
				$FCGPA         = $v['FCGPA'];
				
				//$result = "Result : <span style='color:red;'>{$this->FCLASS}</span> ,&nbsp;&nbsp; Grade : <span style='color:red;'>{$FGRADE}</span>";
				
				if($k%2==0)
					$class = 'tbl_row1';
				else
					$class = 'tbl_row_alter1';

if($FTHUE != "-" && $FPRUE != "-")
				{
					$mthprue  = "Th. Pr.";
					$uni_exam = "{$FTHUE} {$FPRUE}";
					$mthprue  = GetTdData("Th.","Pr.");
					$uni_exam = GetTdData($FTHUE,$FPRUE);
				}
				else if($FTHUE != "-")
				{
					$mthprue  = "Th.";
					$uni_exam = "{$FTHUE}";
					$mthprue  = GetTdData("Th.","");
					$uni_exam = GetTdData($FTHUE,"");
				}
				else
				{
					$mthprue  = "Pr.";
					$uni_exam = "{$FPRUE}";
					$mthprue  = GetTdData("Pr.","");
					$uni_exam = GetTdData($FPRUE,"");
				}
				
				if($univcode=='018')
				{
					$mthprue = "-";
				}
				
				/* if($this->FSCHEME == 'CR' || $this->FSCHEME == 'C')
				{
					$mthprue = $FLTP;
				} */
				
				#########viva$########
				if($FTHVV!="-" && $FPRVV!="-")
				{
					$viva_exam = GetTdData($FTHVV,$FPRVV);
				}
				else if($FTHVV!="-")
				{
					$viva_exam = GetTdData($FTHVV,"");
				}
				else
				{
					$viva_exam = GetTdData($FPRVV,""); 
				}
				#########viva$########

#########IA########
				if($FTHIA!="-" && $FPRIA!="-")
				{
					$ia_exam=GetTdData($FTHIA,$FPRIA); 
				}
				else if($FTHIA != "-")
				{
					$ia_exam = GetTdData($FTHIA,"");  
				}
				else
				{
					$ia_exam = GetTdData($FPRIA,"");  
				}
				#########IA$########
				#########TOTAl########
				if($FTHTOT!="-" && $FPRTOT!="-")
				{
					$total=GetTdData($FTHTOT,$FPRTOT);  
				}
				else if($FTHTOT != "-")
				{
					$total=GetTdData($FTHTOT,"");
				}
				else
				{
					$total=GetTdData($FPRTOT,""); 
				}
				#########TOTAl$########
				#########Remarks########
				//echo strtolower($FTHPASSMTH).'--'.strtolower($FPRPASSMTH);
				if($univcode == '018')
				{
					$FPRPASSMTH="";
				}
				$pass_color = "green;";
				if(strtolower($FTHPASSMTH) == strtolower($FPRPASSMTH))
				{
					$remarks = GetTdData1($FTHPASSMTH,""); 
				}
				else if(strtolower($FTHPASSMTH)=="pass" && strtolower($FPRPASSMTH)=="pass")
				{
					$remarks = GetTdData1("Pass",""); 
				}
				else if(strtolower($FTHPASSMTH)=="fail" && strtolower($FPRPASSMTH)=="fail")
				{
					$pass_color = "red;";
					$remarks    = GetTdData1("Fail",""); 
				}
				else if(strtolower($FTHPASSMTH)!="-" && strtolower($FPRPASSMTH)=="-")
				{
					$remarks  = GetTdData1($FTHPASSMTH,""); 
				}
				else if(strtolower($FTHPASSMTH)=="-" && strtolower($FPRPASSMTH)!="-")
				{
					$remarks  = GetTdData1($FPRPASSMTH,""); 
				}						
				else 
				{
					$remarks  = GetTdData1($FTHPASSMTH,$FPRPASSMTH); 
				}
				#########Remarks$########
				
				
				$title1 = array("{$mthprue}","{$uni_exam}","{$viva_exam}","{$ia_exam}","{$total}");
				
				$this->html.="<tr>";
				$this->html.="<td class = {$class} style='border-left:1px solid #a1a1a1; border-right:1px solid #a1a1a1;text-align:center; ' >{$sl_no}</td>";
				$this->html.="<td class = {$class} style='letter-spacing:0.6px;text-align:left; border-right:1px solid #a1a1a1;'  >{$FSUBNAME}</td>";

for($i = 0;$i<count($title1);$i++)
				{
					$this->html.="<td class = {$class} style='text-align:center; border-right:1px solid #a1a1a1;' >{$title1[$i]}</td>";
				}
				
				/*$this->html.="<td class = {$class} style=' text-align:center; border-right:1px solid #a1a1a1;' >{$mthprue}</td>";
				$this->html.="<td class = {$class} style=' text-align:center; border-right:1px solid #a1a1a1;'>{$uni_exam}</td>";				
				$this->html.="<td class = {$class} style=' text-align:center; border-right:1px solid #a1a1a1;'>{$viva_exam}</td>";				
				$this->html.="<td class = {$class} style=' text-align:center; border-right:1px solid #a1a1a1;'>{$ia_exam}</td>";				
				$this->html.="<td class = {$class} style=' text-align:center; border-right:1px solid #a1a1a1;'>{$total}</td>";				 */
				
				if($univcode == '035')
				{	
					if($this->FSCHEME == 'CR')
					{	
						$this->html.="<td class={$class} style=' text-align:center; border-right:1px solid #a1a1a1;'>{$FCREDITS}</td>";				
						$this->html.="<td class={$class} style=' text-align:center; border-right:1px solid #a1a1a1;'>{$FGP}</td>";				
						$this->html.="<td class={$class} style=' text-align:center; border-right:1px solid #a1a1a1;'>{$FCP}</td>";
					}
				}
				
				$this->html.="<td class={$class} style=' text-align:center; border-right:1px solid #a1a1a1;color:{$pass_color}'>{$remarks}</td>";	
				$this->html.="</tr>";
				$sl_no++;
				$k++;
			}
			
			$this->html.="</table>";
			
			$pass_color="green;";
			
			if(strtolower($this->FCLASS)=='fail')
				$pass_color = "red;";
			
			$this->html.="<br><table width=100% align=center class='result_table_footer'>";
			if($univcode == '035' && $this->FSCHEME == 'CR')
			{	
				if($this->FCLASS == 'Fail, Promoted')
					$result = "Result : <span style='color:red;'>{$this->FCLASS}</span> ,&nbsp;&nbsp; Grade : <span style='color:red;'>-</span>";
				else
					$result = "Result : Pass  , &nbsp;&nbsp;Grade : <span style='color:{$pass_color};'>{$this->FCLASS}";
			}
			else
				$result = "&nbsp; Result : <span style='color:{$pass_color};'>{$this->FCLASS}</span></span>";
			
			if($this->FSCHEME != 'CR' || $univcode == '035')
				$this->html.="<tr><td align = center >Max. Marks : {$this->FMAXMARKS}    Sec. Marks : {$this->FTOTMARKS}</span> </td></tr>";
			
			if($this->FSCHEME == 'CR')
			{	
				$cgpa = " ";
				if($FCGPA != '0.00')
					$cgpa = "&nbsp;&nbsp; C.G.P.A : {$FCGPA} &nbsp;&nbsp;,";
				$this->html.="<tr><td align=center>S.G.P.A : {$FSGPA},   {$cgpa}  {$result}</td></tr>";
			}	
			else
				$this->html.="<tr><td align=center>Percentage : {$this->FPERCENT}     Result : <span style='color:{$pass_color};'>{$this->FCLASS}</td></tr>";
		
			if($this->FPREVMAX != "0000" && !empty($this->FPREVMAX))
				$this->html.="<tr><td align=center >Earlier Exams      [Max. Marks : {$this->FPREVMAX}    Sec. Marks : {$this->FPREVTOT} ] </td></tr>";
			
			
			if(strrpos("000*017*033*035*034*036*011*037*",$univcode.'*')== false)
				$this->html.="<tr><td align=center >College : {$this->FCOLLCODE}  -  {$this->FCOLLNAME}</td></tr>";
			
			if(!empty($this->FMCNUMBER) && $this->FMCNUMBER!=".")
				$this->html.="<tr><td align=center >[Marks Card Number : {$this->FMCNUMBER}] </td></tr>";
			
			$this->html.="<tr><td align=center >{$this->FELIGREM01}   {$this->FELIGREM02}</td></tr>";
			$this->html.="</table>";
			$this->html.="<a class='sub_wise_anchar' href='subjectDetails.php?r={$this->reg_no}&e={$this->exam}'>Click here to view Subjectwise Details</a> <span style='color: blue;
			cursor: pointer;
			font-size: 13px;
			font-weight: bold;
			line-height: 18px;
			margin-top: 15px;
			padding-left: 14px;
			text-decoration: underline;' onclick='print();'> Print </span><br>	";				
		}
		else
		{
			$this->error_found=1;
			$this->html.="<table  align='center' id='results_subject_table' width='100%' border='0' cellspacing='0' cellpadding='3'>";
			$this->html.="<th align='center' colspan='8'  style='color:red;height:34px;font-size:15px;'> No Results found </th>";        			
			$this->html.="</table><div style='height:200px;'></div>";
		}	
			
	}
	
	function DisplayStudentsubjectDetailsResult()
	{
		$this->reg_no=trim($this->aobj_context->mobj_data['r']);		 
		$this->exam=trim($this->aobj_context->mobj_data['e']);
		
		if(empty($this->reg_no) || $this->reg_no=="undefined")
		{
			$arr['html'] = "Register number should be entered";
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
			return;	
		}
		
		else if(empty($this->exam) || $this->exam=="undefined")
		{
			$arr['html']="Year / Semester should be selected";
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
			return;	
		}
		
		$get_data = "SELECT s.FDEGREE,d.FDESCPN, s.FEXAMNO,d.FEXAMNAME,s.FCOLLCODE,
					concat(c.FCOLLNAME,', ',c.FTOWN) AS FCOLLNAME,d.FRESEXAMDATE,s.FREGNO,s.FNAME,s.FAYEAR,d.FELIGREM01,d.FELIGREM02
					FROM student s INNER JOIN college c ON c.FCOLLCODE=s.FCOLLCODE
					INNER JOIN degree d ON d.FDEGREE=s.FDEGREE
					where s.FREGNO='{$this->reg_no}'  and d.fexamno = '{$this->exam}'";
		$obj_student = $this->aobj_context->mobj_db->GetRow($get_data);

if(empty($obj_student))
		{
			$arr['html']="Invalid Register number";
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
			return;	
		}
		
		$FDEGREE    = $obj_student['FDEGREE'];
		$FDESCPN    = $obj_student['FDESCPN'];
		$FEXAMNO    = $obj_student['FEXAMNO'];
		$FEXAMDATE  = $obj_student['FRESEXAMDATE'];
		$FEXAMNAME  = $obj_student['FEXAMNAME'];
		$FCOLLCODE  = $obj_student['FCOLLCODE'];
		$FCOLLNAME  = $obj_student['FCOLLNAME'];
		$FREGNO     = $obj_student['FREGNO'];
		$FNAME      = $obj_student['FNAME'];
		$FAYEAR     = $obj_student['FAYEAR'];
		$FELIGREM01 = $obj_student['FELIGREM01'];
		$FELIGREM02 = $obj_student['FELIGREM02'];
		
		$get_remarks="SELECT FRESULT_REMARKS, FUNIVCODE FROM control";
		$obj_get_remarks=$this->aobj_context->mobj_db->GetRow($get_remarks);
		
		$remarks  = $obj_get_remarks['FRESULT_REMARKS'];	
		$univcode = $obj_get_remarks['FUNIVCODE'];	
		 
		$tr1 = " {$FEXAMNAME} {$FDESCPN} {$FEXAMDATE} Examinations";		
		$tr2 = " Reg. No. : {$FREGNO}";			
		
		if($univcode == '018')
		{
			$tr2 = " Roll No. : {$FREGNO}";			
		}
		
		$tr3=" Name of the Student : {$FNAME}";
		
		############ Writing Student Info START########################	
		$this->html.="<br>";
		$this->html.="<table width=70% align=center class='result_table_header' id='student_info'>
		<tr style='height:22px;'><td align=center>{$tr1}</td></tr>
		<tr style='height:22px;' ><td align=center >{$tr2}</td></tr>
		<tr style='height:22px;' ><td align=center >{$tr3}</td></tr>
		</table>";

############ Writing Student Info END########################	
		$this->WriteSubjectWiseDetailedResult();
		
		$this->html.="<a class='sub_wise_anchar' href='result.php?r={$this->reg_no}&e={$this->exam}'>Click here to view Brief Results</a> <span style='color: blue;
		cursor: pointer;
		font-size: 13px;
		font-weight: bold;
		line-height: 18px;
		margin-top: 15px;
		padding-left: 14px;
		text-decoration: underline;' onclick='print();'> Print </span><br>	";

$this->html.="<br><table width=100% align=left class='result_table_remarks'>
		<tr><td align=left style='text-align:justify;'>{$remarks} </td></tr>";
		$this->html.="</table>";

$arr['html']=$this->html;

echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
		return;	
	}
	
	function WriteSubjectWiseDetailedResult()
	{
		$get_data = "select s.FSUBNAME, rm.fsubcode, rm.fssubname, rm.fmarks, rm.fyear, rm.fexamtype
			from resmarksdet rm left join subject s on s.FDEGREE = rm.fdegree
			and s.FEXAMNO = rm.fexamno and s.FCSUBCODE = rm.fsubcode
			where fregno = '{$this->reg_no}' and rm.fexamno = '{$this->exam}'
			order by s.fsubcode, s.fssubcode";
		$this->app_data=$this->aobj_context->mobj_db->GetAll($get_data); 	
		//echo $get_data;			
		$this->html.="<br>";

$this->html.="<table  align='center' id='results_subject_table' width='100%' border='0' cellspacing='0' cellpadding='3'>";
		//$this->html.="<th align='center' colspan='8'  class='header_grid'>Following course results are available </th>";        			
		$this->html.="<tr class='tr_bg1'>";
		$this->html.="<td  width='10%' style='border-left:1px solid #a1a1a1; border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'>Sl. No.</td>";
		$this->html.="<td  width='50%' style='border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'>Subject Name</td>";
		$this->html.="<td  width='20%' style='border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'>Component Name</td>";
		$this->html.="<td  width='20%' style='border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'>Marks</td>";
		$this->html.="</tr>";

$final_arr=array();
		$sl_no=1;
		
		foreach($this->app_data as $k=>$v)
		{
			$FSUBNAME=$v[FSUBNAME];
			$fssubname=$v[fssubname];
			$fmarks=$v[fmarks];
			$fsubcode=$v[fsubcode];
			$final_arr[$FSUBNAME][$fsubcode]['s']=$fssubname;
			$final_arr[$FSUBNAME][$fsubcode]['m']=$fmarks;
		}
		
		$sl_no=1;
		
		foreach($final_arr	as $ak=>$av)
		{	
			if($k%2==0)
				$class='tbl_row1';
			else
				$class='tbl_row_alter1';
			
			$this->html.="<tr>";
			$this->html.="<td class={$class} style='border-left:1px solid #a1a1a1; border-right:1px solid #a1a1a1;text-align:center; ' >{$sl_no}</td>";
			$this->html.="<td class={$class} style='letter-spacing:0.6px;text-align:left; border-right:1px solid #a1a1a1;'  >{$ak}</td>";
			
			$arr=GetSubjectData($av);
			
			$sub_html=$arr['sub_html'];
			$marks_html=$arr['marks_html'];
			$this->html.="<td class={$class} style=' text-align:center; border-right:1px solid #a1a1a1;' >{$sub_html}</td>";				
			$this->html.="<td class={$class} style=' text-align:center; border-right:1px solid #a1a1a1;'>{$marks_html}</td>";

$this->html.="</tr>";
			$sl_no++;
			$k++;
		}
		$this->html.="</table>";
	}	
	
	function ValidateRegNo($aobj_context)
	{
		session_start();
		
		$regroll   = $_SESSION['G_FREGROLL'];
		$FUNIVCODE = $_SESSION['FUNIVCODE'];
		
		$reg_no = trim($this->aobj_context->mobj_data['reg_no']);
		$exam   = trim($this->aobj_context->mobj_data['exam']);

$lsql   = "select fdegree, fregno, fname, fcollcode from student where fregno = '{$reg_no}'";
		$tmprs = $this->aobj_context->mobj_db->GetRow($lsql);
		
		if(count($tmprs) == 0)
		{
			$data="Invalid ".$regroll;
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure");
			return false;
		}
		
		$fdegree = $tmprs['fdegree'];
		
		$lsql  = "select * from degree where fdegree  = '{$fdegree}' and fexamno = '{$exam}' ";
		$tmprs = $this->aobj_context->mobj_db->GetRow($lsql);
		
		if(count($tmprs) == 0)
		{
			$data="Invalid Year / Semister";
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure");
			return false;
		}
		
		$lsql  = "select * from res_fee where fdegree  = '{$fdegree}' and fexamno = '{$exam}' and fregno = '{$reg_no}'";
		$tmprs = $this->aobj_context->mobj_db->GetRow($lsql);
		
		if(count($tmprs) == 0)
		{
			$data="No result found for the given details.";
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure");
			return false;
		}
		
		$data = "$FUNIVCODE";
		echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,0,"success");		
	
	}	
}
 
function GetTdData($div1,$div2)
{
	$html="";
	if(empty($div2))
		$html="{$div1}";
	else
		$html="<div style='padding:5px;'>{$div1}</div><div>{$div2}</div>";
	return $html;
}

function PopulateResultDegreeList($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$class_obj=new results($aobj_context);
	$class_obj->dashboardMessageBoard();	 
	$class_obj->PopulateResultDegreeList();	 
}
 
function DisplayStudentResult($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$class_obj=new results($aobj_context);
	$class_obj->DisplayStudentResult();	 
}

function DisplayStudentsubjectDetailsResult($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$class_obj=new results($aobj_context);
	$class_obj->DisplayStudentsubjectDetailsResult();	 
}

function ValidateRegNo($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$class_obj=new results($aobj_context);
	$class_obj->ValidateRegNo();	 
}

${this.title}

Code Editor : results_19022018.php