Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
ExcelWriterXML	[ DIR ]	drwxr-xr-x
Excel_Writer	[ DIR ]	drwxr-xr-x
Excel_reader	[ DIR ]	drwxr-xr-x
JQGrid3.5	[ DIR ]	drwxr-xr-x
Report_details	[ DIR ]	drwxr-xr-x
css	[ DIR ]	drwxr-xr-x
custom_js	[ DIR ]	drwxr-xr-x
custom_src	[ DIR ]	drwxr-xr-x
docs	[ DIR ]	drwxr-xr-x
easy_zip	[ DIR ]	drwxr-xr-x
gradlist	[ DIR ]	drwxr-xr-x
grid	[ DIR ]	drwxr-xr-x
grid_display_files	[ DIR ]	drwxr-xr-x
gridsrch	[ DIR ]	drwxr-xr-x
html_modules	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
img	[ DIR ]	drwxr-xr-x
jqGrid4	[ DIR ]	drwxr-xr-x
jqgridn3.5	[ DIR ]	drwxr-xr-x
js	[ DIR ]	drwxr-xr-x
libgd-gd-2.2.3	[ DIR ]	drwxr-xr-x
libs	[ DIR ]	drwxr-xr-x
maya-pdf	[ DIR ]	drwxr-xr-x
misc_files	[ DIR ]	drwxrwxrwx
popups	[ DIR ]	drwxr-xr-x
schema	[ DIR ]	drwxr-xr-x
src	[ DIR ]	drwxr-xr-x
student_photos	[ DIR ]	drwxrwxrwx
student_photos11	[ DIR ]	drwxr-xr-x
tarka_pdf	[ DIR ]	drwxr-xr-x
tarka_pdf_latest	[ DIR ]	drwxr-xr-x
tcpdf	[ DIR ]	drwxr-xr-x
teacher_photos	[ DIR ]	drwxrwxrwx
tmpphotos	[ DIR ]	drwxrwxrwx
user_images	[ DIR ]	drwxr-xr-x
validation_files	[ DIR ]	drwxr-xr-x
.htaccess	602 B	-rwxr-xr-x
MainPage.html	11.66 KB	-rwxr-xr-x
MainPagepopup.html	7.05 KB	-rwxr-xr-x
Thumbs.db	464 KB	-rwxr-xr-x
a.php	28 B	-rwxr-xr-x
app.php	416 B	-rwxr-xr-x
cconfig.php	901 B	-rwxr-xr-x
collegeInfoPopup.html	3.75 KB	-rwxr-xr-x
docverify.php	784 B	-rwxr-xr-x
homepage.html	3.05 KB	-rwxr-xr-x
index.html	6.91 KB	-rwxr-xr-x
indexlogin.html	5.74 KB	-rwxr-xr-x
mcverifydet.php	14.83 KB	-rwxr-xr-x
mverifytranscript.php	14.62 KB	-rwxr-xr-x
verification.php	2.68 KB	-rwxr-xr-x
~$sis_manual.rtf	162 B	-rwxr-xr-x

Code Editor : mverifytranscript.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
 <link rel="stylesheet" type="text/css" href="css/basic.css" /> 

<script type="text/javascript" src="js/jquery-1.8.3.js"></script>
<script type="text/javascript" src="js/jquery.corner.js"></script>
<script type="text/javascript" src="js/jscript.js"></script>
<script type="text/javascript" src="js/curve-min.js"></script>
<link rel="stylesheet" href="jquery-ui-1.9/themes/base/jquery.ui.all.css">
<link rel="shortcut icon" type="image/jpg" href="img/favicon.jpg" />

<?php

$v1 = $_GET['v1'];
	$v2 = $_GET['v2'];
	$v3 = $_GET['v3'];
	$v4 = substr($v3,-1); 
	$v3 = substr($v3, 0, -1);

/*$servername = "72.167.46.92";
	$username = "gccuser";
	$password = "Logisys@2106";
	$dbname = "resultsg_gcc";*/

$servername = "localhost";
	$username = "root";
	$password = "";
	$dbname = "resultsg_gcm";

// Create connection
	$conn = new mysqli($servername, $username, $password, $dbname);
	// Check connection
	if($conn->connect_error)
	{
		die("Connection failed: " . $conn->connect_error);
	}

$get_data="select FUNIVCODE,FUNIVNAME,FUNIVADD1,pdf_logo_path from control";
	$result=$conn->query($get_data); 
	if (mysqli_num_rows($result) > 0) 
	{
		// output data of each row
		while($row = mysqli_fetch_assoc($result)) 
		{
			$FUNIVCODE=$row['FUNIVCODE'];
			$FUNIVNAME=$row['FUNIVNAME'];
			$FUNIVADD1=$row['FUNIVADD1'];
			$pdf_logo_path=$row['pdf_logo_path'];
		}
	}	
	
	$query = "select d.FDESCPN,d.FEXAMNAME,d.FEXAMDATE,st.FNAME,st.FPHOTOPATH,rm.FREGNO,concat(st.fcollcode,' - ',FCOLLNAME,',',ftown) as FCOLLNAME,if(FSUBSIDARY = 'T',concat(s.FSUBNAME,' **'),s.FSUBNAME) as 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,
	FCREDITS,FGP,FCP,FGRADE,FSGPA,FCGPA,
	FMAXMARKS,FTOTMARKS,FPREVMAX,FPREVTOT,FPERCENT,FCLASS,FMCNUMBER,FYEAR,FEXAMTYPE, FSCHEME
	from vertran rm inner join verdeg d on d.fdegree = rm.fdegree and d.fexamno = rm.fexamno 
	inner join verstud st on st.fregno = rm.fregno 
	inner join college c on st.fcollcode = c.fcollcode
	inner join subject s on s.FDEGREE=rm.FDEGREE
	and s.FEXAMNO=rm.FEXAMNO and s.FSUBCODE=rm.FSUBCODE 
	where rm.FREGNO='{$v1}' and 
	FYEAR = '{$v3}' and FEXAMTYPE = '{$v4}'
	group by s.FSUBCODE";
	//var_dump($query);
	$rst=$conn->query($query); 
	
	if (mysqli_num_rows($rst) > 0) 
	{
		/*$arrydata  = mysqli_fetch_assoc($rst);
		 $FMAXMARKS = $row['FMAXMARKS'];
		$FTOTMARKS = $row['FTOTMARKS'];
		$FPREVMAX  = $row['FPREVMAX'];
		$FPREVTOT  = $row['FPREVTOT'];
		$FPERCENT  = $row['FPERCENT'];
		$FCLASS    = $row['FCLASS'];
		$FMCNUMBER = $row['FMCNUMBER'];
		$FYEAR     = $row['FYEAR'];
		$FEXAMTYPE = $row['FEXAMTYPE'];	
		$FSCHEME   = $row['FSCHEME'];
		$FDESCPN   = $row['FDESCPN'];
		$FEXAMNAME = $row['FEXAMNAME'];
		$FEXAMDATE = $row['FEXAMDATE'];
		$FREGNO    = $row['FREGNO'];
		$FNAME     = $row['FNAME'];
		$PHOTOPATH = $row['FPHOTOPATH'];
        $FCOLLNAME  = $row['FCOLLNAME']; */ 
        $sl_no = 1;
		//var_dump($query);
		//$row = mysqli_fetch_assoc($rst);
		//var_dump($row);
		while($row = mysqli_fetch_assoc($rst)) 
		{
			if($sl_no == 1)
			{
				$FMAXMARKS = $row['FMAXMARKS'];
				$FTOTMARKS = $row['FTOTMARKS'];
				$FPREVMAX  = $row['FPREVMAX'];
				$FPREVTOT  = $row['FPREVTOT'];
				$FPERCENT  = $row['FPERCENT'];
				$FCLASS    = $row['FCLASS'];
				$FMCNUMBER = $row['FMCNUMBER'];
				$FYEAR     = $row['FYEAR'];
				$FEXAMTYPE = $row['FEXAMTYPE'];	
				$FSCHEME   = $row['FSCHEME'];
				$FDESCPN   = $row['FDESCPN'];
				$FEXAMNAME = $row['FEXAMNAME'];
				$FEXAMDATE = $row['FEXAMDATE'];
				$FREGNO    = $row['FREGNO'];
				$FNAME     = $row['FNAME'];
				$PHOTOPATH = $row['FPHOTOPATH'];
				$FCOLLNAME  = $row['FCOLLNAME'];
			}
            $FSUBNAME=$row['FSUBNAME'];
            $FTHUE=$row['FTHUE'];
            $FPRUE=$row['FPRUE'];
            
            $FTHVV=$row['FTHVV'];
            $FPRVV=$row['FPRVV'];
            
            $FTHIA=$row['FTHIA'];
            $FPRIA=$row['FPRIA'];
            
            $FTHTOT=$row['FTHTOT'];
            $FPRTOT=$row['FPRTOT'];
            
            $FTHPASSMTH=trim($row['FTHPASSMTH']);
            $FPRPASSMTH=trim($row['FPRPASSMTH']);
            $FTHPASSMTH=preg_replace("/[^A-Za-z0-9+-]/","",$FTHPASSMTH); 
            $FPRPASSMTH=preg_replace("/[^A-Za-z0-9+-]/","",$FPRPASSMTH); 
            
            $FEXAMNO=$row[FEXAMNO];
            $FEXAMNAME=$row[FEXAMNAME];
            $FRESULTDATE=$row[FRESULTDATE];
            $FRESULTSCHEME=$row[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); 
            }
						
			$html.="<tr>";
			$html.="<td class={$class} style='border-left:1px solid #a1a1a1; border-right:1px solid #a1a1a1;text-align:center; ' >{$sl_no}</td>";
			$html.="<td class={$class} style='letter-spacing:0.6px;text-align:left; border-right:1px solid #a1a1a1;'  >{$FSUBNAME}</td>";
			$html.="<td class={$class} style=' text-align:center; border-right:1px solid #a1a1a1;' >{$mthprue}</td>";				
			$html.="<td class={$class} style=' text-align:center; border-right:1px solid #a1a1a1;'>{$uni_exam}</td>";				
			$html.="<td class={$class} style=' text-align:center; border-right:1px solid #a1a1a1;'>{$viva_exam}</td>";				
			$html.="<td class={$class} style=' text-align:center; border-right:1px solid #a1a1a1;'>{$ia_exam}</td>";				
			$html.="<td class={$class} style=' text-align:center; border-right:1px solid #a1a1a1;'>{$total}</td>";				
			$html.="<td class={$class} style=' text-align:center; border-right:1px solid #a1a1a1;color:{$pass_color}'>{$remarks}</td>";	
			$html.="</tr>";
            $sl_no++;
		}
	}
	
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;
}
	
?>

<div id='main_frame' align=center>
	<div class='header_main_div' align=center >
		<div class='header_left_div' >
			<div class='header_log_left_div'><img height=103 width=120 src="<?php echo $pdf_logo_path?>"></div>
		</div>
		<div class='header_right_div'>
			<div class='header_right_txt_div'>
				<?php echo $FUNIVNAME?><br>
				<span  id='span_address'><?php echo $FUNIVADD1?><br></span>  
			</div>
			<div class='header_right_txt_div' style='margin-top:-15px;'>Official Transcript</div>
		</div> 
		<div style='clear:both;'>
			<div id='main_page_div' >	
				<div id="index_main_page" style='margin-top:10px;margin-left:40px;font-size:20px;align:center;width :90%;'>
                
					<table width=70% align=center class='result_table_header' id='student_info'>
						<tr style='height:22px;color:red;font-family:Algerian;font-size:20px;' >
						
						<tr style='height:22px;' ><td align=center >Reg. No. : <?php echo $FREGNO; ?></td></tr>
						<tr style='height:22px;' ><td align=center >Name of the Student : <?php echo $FNAME; ?></td></tr>
					</table>
					<div style='float:right;'>	
						<span style='padding:2px;'><img src='<?php echo $PHOTOPATH?>' width='80px'  height='80px' style = 'margin-left:700px;margin-top:-200px;'/></span>
					</div> 
                   
					<div >  
						 <table  align='center' id='results_subject_table' width='100%' border='0' cellspacing='0' cellpadding='3'>       			
						<tr class='tr_bg1'>
						<td  width='8%' style='border-left:1px solid #a1a1a1; border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'>Sl. No.</td>			<td  width='44%' style='border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'>Subject Name</td>
						<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>
						
						<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>		
						<?
						if($FSCHEME=='CR')
						{?>
							<td  width='8%' style='border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'>Credits</td>
							<td  width='8%' style='border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'>Credit Point</td>
							<td  width='8%' style='border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'>Grade Point</td>						
							<td  width='8%' style='border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'>Grade</td>
						<?}
						else
						{?>
							<td  width='8%' style='border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'>Viva</td>
							<td  width='8%' style='border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'>I.A.</td>
							<td  width='8%' style='border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'>Total</td>					
							<td  width='8%' style='border-right:1px solid #a1a1a1; border-bottom:1px solid #a1a1a1;' align='center'>Remarks</td>
						<?}?>
						
						<?php echo $html;?>
						</table>
                        
                      <? if($FSCHEME=='CR')
                        {?>
                          <table width=90% align=center class='result_table_footer'>
                            <tr><td align=center>S.G.P.A : <?echo $FPERCENT;?>     Result : <span style='color:{$pass_color};'><?echo $FCLASS;?></td></tr>
                            
                       <? }
                        else
                        {?>
                           <table width=90% align=center class='result_table_footer'>
                            <tr><td align=center>Percentage : <?echo $FPERCENT;?>     Result : <span style='color:{$pass_color};'><?echo $FCLASS; ?></td></tr>
                            
                       <? }?>
                       <? if($FPREVMAX!="0000" && !empty($FPREVMAX))
                         {?>   <tr><td align=center >Earlier Exams      [Max. Marks : <?echo $FPREVMAX;?>    Sec. Marks : <? echo $FPREVTOT;?> ] </td></tr><?}?>
                        <tr><td align=center >College : <?echo $FCOLLNAME;?> </td></tr>
                        <tr><td align=center >Marks Card Number :<?echo $FMCNUMBER;?> </td></tr>
                        </table>
                        
					</div>
					
			</div>
	 
			
		</div>
</div>

${this.title}

Code Editor : mverifytranscript.php