| Server IP : 162.214.74.102 / Your IP : 216.73.217.114 Web Server : Apache System : Linux dedi-4363141.lrsys.com.br 3.10.0-1160.119.1.el7.tuxcare.els25.x86_64 #1 SMP Wed Oct 1 17:37:27 UTC 2025 x86_64 User : lrsys ( 1015) PHP Version : 5.6.40 Disable Function : exec,passthru,shell_exec,system MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/lrsys/www/lrsys_apps/school/application/views/backend/admin/ |
Upload File : |
<?php
$class_name = $this->db->get_where('class' , array('class_id' => $class_id))->row()->name;
$exam_name = $this->db->get_where('exam' , array('exam_id' => $exam_id))->row()->name;
$system_name = $this->db->get_where('settings' , array('type'=>'system_name'))->row()->description;
$running_year = $this->db->get_where('settings' , array('type'=>'running_year'))->row()->description;
?>
<div id="print">
<script src="assets/js/jquery-1.11.0.min.js"></script>
<style type="text/css">
td {
padding: 5px;
}
</style>
<center>
<img src="uploads/logo.png" style="max-height : 60px;"><br>
<h3 style="font-weight: 100;"><?php echo $system_name;?></h3>
<?php echo get_phrase('tabulation_sheet');?><br>
<?php echo get_phrase('class') . ' ' . $class_name;?><br>
<?php echo $exam_name;?>
</center>
<table style="width:100%; border-collapse:collapse;border: 1px solid #ccc; margin-top: 10px;" border="1">
<thead>
<tr>
<td style="text-align: center;">
<?php echo get_phrase('students');?> <i class="entypo-down-thin"></i> | <?php echo get_phrase('subjects');?> <i class="entypo-right-thin"></i>
</td>
<?php
$subjects = $this->db->get_where('subject' , array('class_id' => $class_id , 'year' => $running_year))->result_array();
foreach($subjects as $row):
?>
<td style="text-align: center;"><?php echo $row['name'];?></td>
<?php endforeach;?>
<td style="text-align: center;"><?php echo get_phrase('total');?></td>
<td style="text-align: center;"><?php echo get_phrase('average_grade_point');?></td>
</tr>
</thead>
<tbody>
<?php
$students = $this->db->get_where('enroll' , array('class_id' => $class_id , 'year' => $running_year))->result_array();
foreach($students as $row):
?>
<tr>
<td style="text-align: center;">
<?php echo $this->db->get_where('student' , array('student_id' => $row['student_id']))->row()->name;?>
</td>
<?php
$total_marks = 0;
$total_grade_point = 0;
foreach($subjects as $row2):
?>
<td style="text-align: center;">
<?php
$obtained_mark_query = $this->db->get_where('mark' , array(
'class_id' => $class_id ,
'exam_id' => $exam_id ,
'subject_id' => $row2['subject_id'] ,
'student_id' => $row['student_id'],
'year' => $running_year
));
if ( $obtained_mark_query->num_rows() > 0) {
$obtained_marks = $obtained_mark_query->row()->mark_obtained;
echo $obtained_marks;
if ($obtained_marks >= 0 && $obtained_marks != '') {
$grade = $this->crud_model->get_grade($obtained_marks);
$total_grade_point += $grade['grade_point'];
}
$total_marks += $obtained_marks;
}
?>
</td>
<?php endforeach;?>
<td style="text-align: center;"><?php echo $total_marks;?></td>
<td style="text-align: center;">
<?php
$this->db->where('class_id' , $class_id);
$this->db->where('year' , $running_year);
$this->db->from('subject');
$number_of_subjects = $this->db->count_all_results();
echo ($total_grade_point / $number_of_subjects);
?>
</td>
</tr>
<?php endforeach;?>
</tbody>
</table>
</div>
<script type="text/javascript">
jQuery(document).ready(function($)
{
var elem = $('#print');
PrintElem(elem);
Popup(data);
});
function PrintElem(elem)
{
Popup($(elem).html());
}
function Popup(data)
{
var mywindow = window.open('', 'my div', 'height=400,width=600');
mywindow.document.write('<html><head><title></title>');
//mywindow.document.write('<link rel="stylesheet" href="assets/css/print.css" type="text/css" />');
mywindow.document.write('</head><body >');
//mywindow.document.write('<style>.print{border : 1px;}</style>');
mywindow.document.write(data);
mywindow.document.write('</body></html>');
mywindow.document.close(); // necessary for IE >= 10
mywindow.focus(); // necessary for IE >= 10
mywindow.print();
mywindow.close();
return true;
}
</script>