Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
Thumbs.db	19 KB	-rwxr-xr-x
applicationFormReport.php	8.81 KB	-rwxr-xr-x
cappcontext.php	2.64 KB	-rwxr-xr-x
cappdu.php	3.53 KB	-rwxr-xr-x
challan_preparation.php	10.28 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	2.6 KB	-rwxr-xr-x
json.php	33.22 KB	-rwxr-xr-x
mregistry.php	1.08 KB	-rwxr-xr-x
results.php	31.03 KB	-rwxr-xr-x
results_15032014.php	27.11 KB	-rwxr-xr-x
results_17042018.php	28.35 KB	-rwxr-xr-x
results_26_12.php	23.87 KB	-rwxr-xr-x
results_old.php	25.54 KB	-rwxr-xr-x
revaluation.php	17.61 KB	-rwxr-xr-x
revaluation12072016.php	17.12 KB	-rwxr-xr-x
revaluation_12032014.php	15.77 KB	-rwxr-xr-x
revaluation_old.php	17.52 KB	-rwxr-xr-x
revaluationnew.php	17.37 KB	-rwxr-xr-x

Code Editor : results_15032014.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()
	  {
		$this->html.="";
			
			$this->html.="<table  align='center' id='degree_table_data' width='100%' border='0' cellspacing='0' cellpadding='0'>";
		    //$this->html.="<th align='center' colspan='6'  class='header_grid'>Following course results are available </th>";        			
		    $this->html.="<tr class='tr_bg'>";
			$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'>Reference</td>";
			$this->html.="<td  width='20%' style='border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'>Exam</td>";
			$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["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']);
		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
						from res_fee
						where FREGNO='{$this->reg_no}'
						and FEXAMNO='{$this->exam}'";
		
		$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_FCOLLCODE']=$obj_get_result_date['FCOLLCODE'];
		$FRESULTDATE=$obj_get_result_date['FRESULTDATE'];		
		$FRVLASTDATE=$obj_get_result_date['FRVLASTDATE'];		
		$FRTLASTDATE=$obj_get_result_date['FRTLASTDATE'];		
		$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;";
		}
		$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}' 
					";
		$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;	
		}
		$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} {$FEXAMDATE} Examinations";

$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'];	
		$tr2=" Reg. No. : {$FREGNO}";			
		if($univcode=='018')
		{
			$tr2=" Roll No. : {$FREGNO}";			
		}
		
		$tr3=" Name of the Student : {$FNAME}";
		############ Writing Student Info START########################	
		 
		$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########################
		
		############ Writing Student Info START########################	
	 
		if((!empty($FFATNAME) || !empty($MOTNAME)) && $univcode == '027')
		{
		$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						 
						from resmarks rm					 
						where FREGNO='{$this->reg_no}' and 
						rm.FEXAMNO='{$this->exam}' and FCLASS='WITHHELD' 
						 ";
			$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="<br><br><br><span style='font-weight:bold;color:red;margin-left:375px;font-size: 21px;'>WITHHELD</span><br><br><br>";
			 
			 
		 
		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>
					 </tr>
					</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 s.FSUBNAME,
					 
						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,
						 
						 
						FMAXMARKS,FTOTMARKS,FPREVMAX,FPREVTOT,FPERCENT,FCLASS,FMCNUMBER,FYEAR,FEXAMTYPE
						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";
			$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->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='8%' 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='44%' style='border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'>Subject Name</td>";
					$this->html.="<td  width='8%' style='border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'><div style='padding:5px;'>Th</div><div>Pr</div></td>";
					$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($univcode=='018')
					{
					$this->html.="<td  width='8%' style='border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'><div style='padding:5px;'>Total</div><div>Marks</div>   </td>";
					$this->html.="<td  width='8%' style='border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'><div style='padding:5px;'>Credit</div><div>Hours</div>   </td>";
					$this->html.="<td  width='8%' style='border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'><div style='padding:5px;'>Grade</div><div>Point</div>   </td>";
					$this->html.="<td  width='8%' style='border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'><div style='padding:5px;'>Credit</div><div>Point</div>   </td>";
					$this->html.="<td  width='8%' style='border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'>Grade</td>";
					}
					else
					{
					$this->html.="<td  width='8%' style='border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'><div style='padding:5px;'>Univ</div><div>Exam</div>   </td>";
					$this->html.="<td  width='8%' style='border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'>Viva</td>";
					$this->html.="<td  width='8%' style='border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'>I.A.</td>";
					$this->html.="<td  width='8%' style='border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'>Total</td>";
					$this->html.="<td  width='8%' style='border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'>Remarks</td>";
					}
					$this->html.="</tr>";
					
					$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];	
					$sl_no=1;
					foreach($this->app_data as $k=>$v)
					{
					
						$FSUBNAME=$v[FSUBNAME];
						$FTHUE=$v[FTHUE];
						$FPRUE=$v[FPRUE];
						
						$FTHVV=$v[FTHVV];
						$FPRVV=$v[FPRVV];
						
						$FTHIA=$v[FTHIA];
						$FPRIA=$v[FPRIA];
						
						$FTHTOT=$v[FTHTOT];
						$FPRTOT=$v[FPRTOT];
						
						$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];
						
						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="-";
						}
						#########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$########
						
						$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>";
						$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>";				
						$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>";
				$tr1="";
				$tr2="";
				$tr6 ="";
				$tr3="";
				$tr4="";
				$tr5="";
				$pass_color="green;";
				if(strtolower($this->FCLASS)=='fail')
				$pass_color="red;";
				if($univcode=='018')
				{
				$this->html.="<br><table width=100% align=center class='result_table_footer'>
							<tr><td align=center>S.G.P.A : {$this->FPERCENT},    Result : <span style='color:{$pass_color};'>{$this->FCLASS}</td></tr>";
				}
				else
				{
				$this->html.="<br><table width=100% align=center class='result_table_footer'>
							<tr><td align=center>Percentage : {$this->FPERCENT}     Result : <span style='color:{$pass_color};'>{$this->FCLASS}</td></tr>
							<tr><td align=center >Max. Marks : {$this->FMAXMARKS}    Sec. Marks : {$this->FTOTMARKS}</span> </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>";
				$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>
					 </tr>
					</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 GetTdData($div1,$div2)
{
$html="";
if(empty($div2))
$html="{$div1}";
else
$html="<div style='padding:5px;'>{$div1}</div><div>{$div2}</div>";
return $html;
}
function GetTdData1($div1,$div2)
{
$color1="color:green;";
$color2="color:green;";
if(trim(strtolower($div1)=="fail"))
$color1="color:red;";
if(trim(strtolower($div2)=="fail"))
$color2="color:red;";
$html="";
if(empty($div2))
$html="<div style=' {$color1}'>{$div1}</div>";
else
$html="<div style='padding:5px;{$color1}'>{$div1}</div><div style='{$color2}'>{$div2}</div>";
return $html;
}
function GetSubjectData($arr)
{
	$sub_html="";
	$marks_html="";
	 
	foreach($arr as $akk=>$avv)
	{
	$sub_html.="<div style='padding:5px'>{$avv['s']}</div>";
	$marks_html.="<div style='padding:5px'>{$avv['m']}</div>";
	}
	$fin_arr['sub_html']=$sub_html;
	$fin_arr['marks_html']=$marks_html;
	return $fin_arr;
}
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();	 
} 
?>

${this.title}

Code Editor : results_15032014.php