JezK

Edit File: Report_card.php

<?php
session_start(); 
include("menuheader.php"); 
if(!(in_array(4,$access) && in_array(4,$allow)))
echo "<script>location.replace('dashboard.php');</script>";
include_once("school_admin_access_app.php");
$fun=new adminaccess();
$school_id=$_SESSION['child']['log_school_id'];		//school_id
$academic_id=$_SESSION['child']['choosen_academic_id'];// academic_year_id 
$user_id=$_SESSION['child']['auth_id'];	 	//user_id 
$details=$fun->get_classes($school_id,$academic_id);
$sections=$fun->get_sections($_GET['classid'],$academic_id);
$students=$fun->get_students2($_GET['classid'],$_GET['section_id'],$school_id,$academic_id);
$student_id=$_GET['student_id'];
	///////////////////////////// classes
	if($details)
	{
		foreach($details as $row)
		{
			if($_GET['classid']==$row['class_id'])
			{
				$classes_list.= "<option value='{$row['class_id']}' selected>{$row['class_name']}</option>";
			}
			else
			{
				$classes_list.= "<option value='{$row['class_id']}' >{$row['class_name']}</option>";
			}
		}
	}
	//////////////////////////////sections
	if($sections)
	{
		foreach($sections as $row)
		{
			if($_GET['section_id']==$row['section_id'])
			{
				$secs .= "<option value='{$row['section_id']}' selected>{$row['section_name']}</option>";
			}
			else
			{
				$secs .="<option value='{$row['section_id']}' >{$row['section_name']}</option>";
			}
		}
	} 
	////////////////////////////////students				
	if($students)
	{
		foreach($students as $row)
		{
			if($_GET['student_id']==$row['student_id'])
			{
				$students_list.= "<option value='{$row['student_id']}' selected>{$row['student_name']}</option>";
			}
			else
			{
				$students_list.= "<option value='{$row['student_id']}' >{$row['student_name']}</option>";
			}
		}
	}					
	
	if(isset($_GET['classid']) && isset($_GET['section_id']) && isset($_GET['student_id']))
	{
		$subs=$fun->student_subjects($_GET['student_id'],$_GET['classid'],$_GET['section_id'],$school_id,$academic_id);
		
		$exms=$fun->student_exams($_GET['student_id'],$_GET['classid'],$_GET['section_id'],$school_id,$academic_id);
		if(!empty($exms))
		{
			$tab='<table class ="table table-bordered" id=".."><thead><tr><th>Subjects</th>';
			foreach($exms as $ex)
			{
				 $tab.='<th colspan="3" style="text-align:center;">'.$ex[exam_name].'</th>';
				 $grade=$fun->getthisStudentgrade($_GET['classid'],$_GET['section_id'],$ex[exam_id],$student_id,$school_id,$academic_id);
				 $grarr[]=$grade;
			}
			$tab.="</tr>";
			$tab.="<tr> <th>&nbsp;</th>";
			for($f=0;$f<count($exms);$f++)
			{
				$tab.="<th>Total Marks</th> <th>Secured Marks</th> <th>Status</th>";
			}
			$tab.="</tr>";
			$tab.="</thead><tbody><tr>";
			if(!empty($subs))
			{				
				$c=0;
				foreach($subs as $sb)
				{					 
					 $d=0;
					 $tab.='<td>'.$sb[subject_name].'</td>';					 
					 foreach($exms as $ex)
					 {
						 $m=$fun->get_subject_marks($ex['exam_id'],$sb['subject_id'],$student_id,$schoolid,$academic_id);
						 $tab.='<td>'.$m[total_marks].'</td><td>'.$m[marks_secured].'</td><td>'.$m[status].'</td>';
						 $totcal[$c][$d]=$m[marks_secured];
						 $totm[$c][$d]=$m[total_marks];
						 $d++;			
					 }
					 $c++;
					 $tab.="</tr>";					
				}
				$tab.="</tr><tr><td>Total</td>";
				for($h=0;$h<count($exms);$h++)
				{
					for($e=0;$e<count($subs);$e++)
					{
						$secshow+=$totcal[$e][$h];
						$totshow+=$totm[$e][$h];
					}
					if($totshow==0)
					$tab.="<td></td><td></td><td>&nbsp;</td>";
					else
					$tab.="<td>".$totshow."</td><td>".$secshow."</td><td>&nbsp;</td>";
					$secshow=0;
					$totshow=0;
				}
				$tab.="</tr><tr><td>Grade/Rank</td>";
				
				for($d=0;$d<count($grarr);$d++)
				{
					if($grarr[$d]=='0')
					$tab.='<td style="text-align:center;" colspan="3"></td>';	
					else
					$tab.='<td style="text-align:center;" colspan="3">'.$grarr[$d].'</td>';
				}
				$tab.="</tr>";
			}
		}
		
	}
	
		//STUDENT PERSONAL INFO
		$student_rollnumber=$fun->student_rollnumber($_GET['student_id']);

?>
<style>
#nav {
	
	margin: auto;
  	width:751px !important;
	padding-left:0;
	padding-right:0;
	list-style: none;
	background: rgb(51, 93, 220) none repeat scroll 0% 0%;
	}
	
	#nav li {
	display:inline-block;
	margin:0 auto;
	text-align:center;
	}
	
	#nav li a {
	display: inline-block;
	padding: 7px 0;
	text-align:center;
	text-decoration: none;
	
	color: #FFFFFF;
	margin:auto;
	}

#nav li:hover, li:active {
   background-color: #0b287b;
	width:90px;
}

#nav li.selected 
{
    background-color: #0b287b;
}

.table-condensed>thead>tr>th, .table-condensed>tbody>tr>th, .table-condensed>tfoot>tr>th, .table-condensed>thead>tr>td, .table-condensed>tbody>tr>td, .table-condensed>tfoot>tr>td {
padding: 3px;
}

select {
    width: 62px  !important;
    background-color: #FFF;
    border: 1px solid #CCC;
}
@media print {
	.row123,.menuu,.form-horizontal{display: none;}
   .table table-bordered {
    border:solid #000 !important;
    border-width:1px 0 0 1px !important;
}
.th, .td {
    border:solid #000 !important;
    border-width:0 1px 1px 1px !important;
}
.hello{display:block;}

}

@media screen and (min-width:1600px) {
  
   .media
   {
	   margin-left: -12px!important;
	   margin-top:-2px!important;
   }
  
}

</style>
<body style="overflow-x: hidden;">
	<div class="row row123" style="margin-top: 30px;">
		<div class="col-md-9  text-left" style="font:Arial, Helvetica, sans-serif;font-style:normal;font-size:24px; margin-left:20px;"><img src="images/exams-black.png"  title =" Examinations"   style="font-size: 24px;"/>
		Examinations
		</div>
	</div>		
	<br>
<div class="menuu">
<ul id="nav" class="margn_auto">
			<li style="border-right:1px solid #FFFFFF;width:150px; text-align:center;margin-left:-3px;font-family:Arial, Helvetica, sans-serif;font-style:normal; font-size:14px;">
				<a  href="examination_management.php"><img src="images/exam-nemes_white.png"   title ="Exam Names"   style="margin-right:5px;"/>Exam Names</a></li>
			<li style="border-right:1px solid #FFFFFF;width:150px; text-align:center; margin-left:-3px; font-family:Arial, Helvetica, sans-serif;font-style:normal; font-size:14px;">
				<a  href="exam_schedule.php"><img src="images/exam-schedule_white.png"   title =" Exam Schedule"   style="margin-right:5px;"/>Exam Schedule</a></li>
			<li style="border-right:1px solid #FFFFFF; width:150px; text-align:center; margin-left:-3px; font-family:Arial, Helvetica, sans-serif;font-style:normal; font-size:14px;">
				<a href="marksof_student.php"><img src="images/add-marks_white.png"   title ="Add Marks"   style="margin-right:5px;"/>Add Marks</a></li>
			<li style="border-right:1px solid #FFFFFF; width:150px; text-align:center; margin-left:-3px; font-family:Arial, Helvetica, sans-serif;font-style:normal; font-size:14px;">
				<a  href="addgrades_tostudent.php"><img src="images/set-grades_white.png"   title ="Set  Grades/Ranks"   style="margin-right:5px;"/>Set  Grades/Ranks</a></li>
			<li class="selected" style="border-right:1px solid #FFFFFF; width:150px; text-align:center; margin-left:-3px; font-family:Arial, Helvetica, sans-serif;font-style:normal; font-size:14px;">
				<a  href="Report_card.php"><img src="images/report-card_white.png"   title =" Report Card"   style="margin-right:5px;"/>Report Card</a></li>
		</ul>
	</div>
	
	<div class="row row123" style="margin-top: 30px;margin-left:14px;">
		<div class="col-md-9  text-left" style="font:Arial, Helvetica, sans-serif;font-style:normal;font-size:18px; margin-left:-24px; margin-top:-5px;">
			<img src="images/exam-nemes_black.png" style=" font-size:25px;"  title ="Student Report Card"  />
			Student Report Card
		</div>
	</div>

<form class="form-horizontal">
		<div class="box-body" style="background-color:#fff; padding: 10px; font-family:Arial, Helvetica, sans-serif; font-size:13px; ">
			<div class="clear">
				<div class="form-group col-md-6" style="margin-bottom:1.0%;">
					<div  class="col-md-4 col-md-offset-1 text-right">
						<b style="color:#666666; ">Class</b><span style="color:#FF0000; margin:2px;">*</span>
					</div>
					<div class="col-md-7">  
						<select class="form-control" id="classes" style="height:29px; width:295px!important;font-size:12px;" tabindex="2" >
						<option   value='0' selected>Select Class</option>
						<? echo $classes_list;?>
						</select>
						
							<div class="col-md-10 media" id="err_class" style="color:#990000;margin-left:-13px; display:none; width:250px;font-size:12px;margin-top:-2px"></div>
						
					</div>
				</div>
			</div>
					
			<div class="clear">
				<div class="form-group col-md-6" style="margin-bottom:1.0%;">
					<div  class="col-md-4 col-md-offset-1 text-right">
						<b style="color:#666666; ">Section</b><span style="color:#FF0000; margin:2px;">*</span>
					</div>
					<div class="col-md-7">  
						<select class="form-control" id="sections" style="height:29px; width:295px!important;font-size:12px;" tabindex="2" >
						<option   value='0' selected>Select Section</option>
						<? echo $secs;?>
						</select>
						
							<div class="col-md-10 media" id="err_section" style="color:#990000;margin-left:-13px; display:none; width:250px;font-size:12px;margin-top:-2px;"></div>
						
					</div>
				</div>
			</div>
					
					
			<div class="clear">
				<div class="form-group col-md-6" style="margin-bottom:1.0%;">
					<div  class="col-md-4 col-md-offset-1 text-right">
						<b style="color:#666666; ">Student</b><span style="color:#FF0000; margin:2px;">*</span>
					</div>
					<div class="col-md-7">  
						<select class="form-control" id="student" style="height:29px; width:295px!important;font-size:12px;" tabindex="2" >
							<option   value='0' selected>Select Student</option>
							<? echo $students_list;?>
							</select>
							
								<div class="col-md-10 media" id="err_student" style="color:#990000;margin-left:-13px; display:none; width:250px;font-size:12px;margin-top:-2px;"></div>
							
					</div>
				</div>
			</div>					
		</div>
		
		<div class="clear">
				<div class="form-group col-md-6" style="margin-bottom:1.0%;">
					<div  class="col-md-4 col-md-offset-1 text-right">
						<b style="color:#666666; ">Student Roll No</b><span style="color:#FF0000; margin:2px;"></span>
					</div>
					<div class="col-md-7">
						<span style="font-family:Arial, Helvetica, sans-serif;font-style:normal;font-size:13px;" id="rnm"><? echo $student_rollnumber;?></span>  
					</div>
				</div>
			</div>					
		
	</form>

<div class="row row123">
		<div class="col-md-4"></div>
		<div class="col-md-4"></div>
		<div class="col-md-4 text-right">
			<button class="btn btn-default" onclick="printData()" style="margin-left:42em;">Print</button>
		</div>
	</div>

<div style="height:1em;"></div>
	<div class="row text-center visible-print" style="display:none;"><h3><?php echo $_SESSION['child']['school_name'];?></h3></div>
	<div class="row text-left visible-print" style="display:none;margin-left:20px;">Academic Year : <?php echo $_SESSION['child']['choosen_year_name'];?></div>
		<div class="row text-left visible-print" style="display:none;margin-left:5px;">
	    <div class="col-md-4">
			<span>Class:</span><span id="cld"></span>
		</div>
	    <div class="col-md-4">
			<span>Section:</span><span id="scd"></span>
			
	    </div>
	    <div class="col-md-4">
			<span>Student Roll number:</span><span id="rld"></span>
	    </div>
	</div>
	
	<div class="hello" style="display:none;">Class:1st class ; Class:1st class ; Class:1st class ; Class:1st class</div>
		
	<? echo	$tab;?>
	   </tbody>  
</table>
</div>

$("#student").change(function()
	{
		var id = $("#student").val();
		var cls=$("#classes").val();
		var sec_id=$("#sections").val();
		$("#err_student").text("");
		if($("#student").val()==0)
		{
			$("#err_student").text("Please select Student");
			$("#err_student").show();
			return false;	
		}
		else if(sec_id!=0 && cls!=0)
		{			
			window.location.href="Report_card.php?classid="+cls+"&student_id="+id+"&section_id="+sec_id;
		}
	});
		
</script>
		
</body>
</html>