File: /storage/v6964/school/public_html/school/application/views/backend/admin/examMarkReport.php
<div class="row">
<div class="col-sm-12">
<div class="panel panel-info">
<div class="panel-heading"> <i class="fa fa-plus"></i> <?php echo get_phrase('Enter Student Score');?></div>
<div class="panel-body table-responsive">
<!----CREATION FORM STARTS---->
<?php echo form_open(base_url() . 'report/examMarkReport' , array('class' => 'form-horizontal form-groups-bordered validate','target'=>'_top', 'enctype' => 'multipart/form-data'));?>
<div class="form-group">
<label class="col-md-12" for="example-text"><?php echo get_phrase('Exam');?></label>
<div class="col-sm-12">
<select name="exam_id" class="form-control select2">
<option value=""><?php echo get_phrase('select_class');?></option>
<?php $exams = $this->db->get('exam')->result_array();
foreach($exams as $key => $exam):?>
<option value="<?php echo $exam['exam_id'];?>"<?php if($exam_id == $exam['exam_id']) echo 'selected="selected"' ;?>><?php echo $exam['name'];?></option>
<?php endforeach;?>
</select>
</div>
</div>
<div class="form-group">
<label class="col-md-12" for="example-text"><?php echo get_phrase('class');?></label>
<div class="col-sm-12">
<select name="class_id" class="form-control select2" onchange="show_students(this.value)">
<option value=""><?php echo get_phrase('select_class');?></option>
<?php $classes = $this->db->get('class')->result_array();
foreach($classes as $key => $class):?>
<option value="<?php echo $class['class_id'];?>"<?php if($class_id == $class['class_id']) echo 'selected="selected"' ;?>>Class: <?php echo $class['name'];?></option>
<?php endforeach;?>
</select>
</div>
</div>
<div class="form-group">
<label class="col-md-12" for="example-text"><?php echo get_phrase('Student');?></label>
<div class="col-sm-12">
<?php $classes = $this->crud_model->get_classes();
foreach ($classes as $key => $row): ?>
<select name="<?php if($class_id == $row['class_id']) echo 'student_id'; else echo 'temp';?>" id="student_id_<?php echo $row['class_id'];?>" style="display:<?php if($class_id == $row['class_id']) echo 'block'; else echo 'none';?>" class="form-control">
<option value="">Student of: <?php echo $row['name'] ;?></option>
<?php $students = $this->crud_model->get_students($row['class_id']);
foreach ($students as $key => $student): ?>
<option value="<?php echo $student['student_id'];?>"<?php if(isset($student_id) && $student_id == $student['student_id']) echo 'selected="selected"';?>><?php echo $student['name'];?></option>
<?php endforeach;?>
</select>
<?php endforeach;?>
</div>
</div>
<div class="form-group">
<div class="col-sm-12">
<select name="" id="student_id_0" style="display:<?php if(isset($student_id) && $student_id > 0) echo 'none'; else echo 'block';?>" class="form-control">
<option value=""><?php echo get_phrase('Select Class First');?></option>
</select>
</div>
</div>
<input class="" type="hidden" value="selection" name="operation">
<div class="form-group">
<button type="submit" class="btn btn-info btn-block btn-rounded btn-sm"><i class="fa fa-search"></i> <?php echo get_phrase('Get Details');?></button>
</div>
</form>
</div>
</div>
</div>
</div>
<?php if($class_id > 0 && $student_id > 0 && $exam_id > 0):?>
<?php $select_sunject_with_class_id = $this->crud_model->get_subjects_by_class($class_id);
foreach ($select_sunject_with_class_id as $key => $class_subject_exam_student):
$verify_data = array('exam_id' => $exam_id, 'class_id' => $class_id, 'student_id' => $student_id, 'subject_id' => $class_subject_exam_student['subject_id']);
$query = $this->db->get_where('mark', $verify_data);
if($query->num_rows() < 1)
$this->db->insert('mark', $verify_data);
endforeach;?>
<div class="row">
<div class="col-sm-12">
<div class="panel panel-info">
<div class="panel-heading"> <i class="fa fa-plus"></i> <?php echo get_phrase('enter_student_score'); ?></div>
<div class="panel-body table-responsive">
<table cellpadding="0" cellspacing="0" border="0" class="table">
<thead>
<tr>
<td><?php echo get_phrase('subject');?></td>
<td><?php echo get_phrase('1st score');?></td>
<td><?php echo get_phrase('2nd score');?></td>
<td><?php echo get_phrase('3rd score');?></td>
<td><?php echo get_phrase('exam score');?></td>
<td><?php echo get_phrase('comment');?></td>
</tr>
</thead>
<tbody>
<?php $select_sunject_with_class_id = $this->crud_model->get_subjects_by_class($class_id);
foreach ($select_sunject_with_class_id as $key => $class_subject_exam_student):
$verify_data = array('exam_id' => $exam_id, 'class_id' => $class_id, 'student_id' => $student_id, 'subject_id' => $class_subject_exam_student['subject_id']);
$query = $this->db->get_where('mark', $verify_data);
$update_subject_marks = $query->result_array();
foreach ($update_subject_marks as $key => $general_select):
?>
<tr>
<td>
<?php echo $class_subject_exam_student['name'];?>
</td>
<td>
<?php echo $general_select['class_score1'];?>
</td>
<td>
<?php echo $general_select['class_score2'];?>
</td>
<td>
<?php echo $general_select['class_score3'];?>
</td>
<td>
<?php echo $general_select['exam_score'];?>
</td>
<td>
<?php echo $general_select['comment'];?>
</td>
<?php
endforeach;
endforeach;
?>
</tbody>
</table>
<h3 align="center"> Student Score (Over 100)</h3>
<div id="bar_chartdiv"></div>
</div>
</div>
</div>
</div>
<?php endif;?>
<script type="text/javascript">
function show_students(class_id){
for(i=0;i<=50;i++){
try{
document.getElementById('student_id_'+i).style.display = 'none' ;
document.getElementById('student_id_'+i).setAttribute("name" , "temp");
}
catch(err){}
}
if (class_id == "") {
class_id = "0";
}
document.getElementById('student_id_'+class_id).style.display = 'block' ;
document.getElementById('student_id_'+class_id).setAttribute("name" , "student_id");
var student_id = $(".student_id");
for(var i = 0; i < student_id.length; i++)
student_id[i].selected = "";
}
</script>
<style>
#bar_chartdiv {
width : 100%;
height : 397px;
font-size : 11px;
}
.amcharts-chart-div a{
display:none !important;
}
</style>
<script>
var chart = AmCharts.makeChart("bar_chartdiv", {
"theme": "light",
"type": "serial",
"startDuration": 2,
"dataProvider": [
<?php $select_sunject_with_class_id = $this->crud_model->get_subjects_by_class($class_id);
foreach ($select_sunject_with_class_id as $key => $class_subject_exam_student):
$verify_data = array('exam_id' => $exam_id, 'class_id' => $class_id, 'student_id' => $student_id, 'subject_id' => $class_subject_exam_student['subject_id']);
$query = $this->db->get_where('mark', $verify_data);
$update_subject_marks = $query->result_array();
foreach ($update_subject_marks as $key => $general_select):
$sum_Class_score_and_exam_score = $general_select['class_score1'] + $general_select['class_score2'] + $general_select['class_score3'] + $general_select['exam_score'];
?>
{
"country": "<?php echo $class_subject_exam_student['name'];?>",
"visits": "<?php echo $sum_Class_score_and_exam_score;?>",
"color": "#99BDF9"
},
<?php endforeach;
endforeach;?>
],
"valueAxes": [{
"position": "left",
"title": "Student Score in Subject"
}],
"graphs": [{
"balloonText": "[[category]]: <b>[[value]]</b>",
"fillColorsField": "color",
"fillAlphas": 1,
"lineAlpha": 0.1,
"type": "column",
"valueField": "visits"
}],
"depth3D": 20,
"angle": 30,
"chartCursor": {
"categoryBalloonEnabled": true,
"cursorAlpha": 0,
"zoomable": false
},
"categoryField": "country",
"categoryAxis": {
"gridPosition": "start",
"labelRotation": 90,
"position": "bottom",
"title": "All Subjects",
},
"export": {
"enabled": true
}
});
jQuery('.chart-input').off().on('input change', function () {
var property = jQuery(this).data('property');
var target = chart;
chart.startDuration = 0;
if (property == 'topRadius') {
target = chart.graphs[0];
if (this.value == 0) {
this.value = undefined;
}
}
target[property] = this.value;
chart.validateNow();
});
</script>