Server : Apache System : Linux server.xvl.jdw.mybluehostin.me 5.14.0-611.42.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 24 05:30:20 EDT 2026 x86_64 User : pigugusurya ( 1113) PHP Version : 8.2.30 Disable Function : exec,passthru,shell_exec,system Directory : /home/pigugusurya/public_html/admin/ |
<?php
include("config.php");
admin_protect();
require 'library/php-export-data.class.php';
ini_set('memory_limit','300M');
$faculties = $db->selectAll('feedback', 'distinct faculty', 'ORDER BY faculty ASC');
$subjects = $db->selectAll('subjects', '*', 'ORDER BY subject ASC');
if(isset($_POST['submit'])){
$faculty = isset($_POST['faculty'])?$_POST['faculty']:'';
$year = isset($_POST['year'])?$_POST['year']:'';
$semister = isset($_POST['semister'])?$_POST['semister']:'';
$subject = isset($_POST['subject'])?$_POST['subject']:'';
$sql = "SELECT a.* FROM `feedback` a, `students` b WHERE a.student_id=b.id";
if(!empty($faculty)){
$sql .= " AND a.faculty = '$faculty'";
}
if(!empty($year)){
$sql .= " AND b.year = '$year'";
}
if(!empty($semister)){
$sql .= " AND b.semister = '$semister'";
}
if(!empty($subject)){
$sql .= " AND b.subject = '$subject'";
}
//echo $sql; exit;
$stmt = $db->prepare($sql);
$stmt->execute();
$reports = $stmt->fetchAll(PDO::FETCH_OBJ);
$exporter = new ExportDataExcel('browser', 'faculty-'.date('d-m-Y H-i-s').'.xls');
$exporter->initialize();
$exporter->addRow(array("S.No", "Faculty Name", "Student Name", "Year", "Semester", "Roll No.", "Subject", "How much of the syllabus was covered by the teacher?", "How well did your teacher prepare for the classes?", "How well is the teacher able to communicate?", "The teacher’s approach to teaching can best be described as", "Fairness of the internal evaluation process by the teacher", "Was your performance in assignments discussed with you?", "The teacher takes active interest in arranging field visits for students.", "The teaching process in the class room facilitates you in cognitive, social and emotional growth", "The teacher provides multiple opportunities to learn and grow.", "The teacher informs you about your expected competencies, course outcomes and programme outcomes.", "Your teacher does a necessary follow-up with an assigned task to you.", "The teacher illustrates the concepts through examples and applications.", "The teacher identifies your strengths and encourage you with providing right level of challenges.", "Teacher is able to identify your weaknesses and help you to overcome them.", "The teacher makes effort to engage students in the monitoring, review and continuous quality improvement of the teaching learning process.", "The teacher uses the student centric methods, such as experiential learning, participative learning and problem solving for enhancing learning experiences.", "The teacher encourages you to participate in extracurricular activities.", "Efforts are made by the teacher to inculcate soft skills, life skills and employability skills to make you ready for the world of work.", "The teacher uses ICT tools such as LCD projector, Multimedia, etc. while teaching.", "The overall quality of teaching-learning process in the class is very good.", "Give three observations/suggestions to improve the overall teaching – learning experience in the class with reference to the teacher.", "Total Marks","Date Created"));
$i = 1;
foreach($reports as $report){
$student_info = $db->selectRow('students', '*', $report->student_id);
$quest1 = explode('ABC',$report->quest1);
$quest2 = explode('ABC',$report->quest2);
$quest3 = explode('ABC',$report->quest3);
$quest4 = explode('ABC',$report->quest4);
$quest5 = explode('ABC',$report->quest5);
$quest6 = explode('ABC',$report->quest6);
$quest7 = explode('ABC',$report->quest7);
$quest8 = explode('ABC',$report->quest8);
$quest9 = explode('ABC',$report->quest9);
$quest10 = explode('ABC',$report->quest10);
$quest11 = explode('ABC',$report->quest11);
$quest12 = explode('ABC',$report->quest12);
$quest13 = explode('ABC',$report->quest13);
$quest14 = explode('ABC',$report->quest14);
$quest15 = explode('ABC',$report->quest15);
$quest16 = explode('ABC',$report->quest16);
$quest17 = explode('ABC',$report->quest17);
$quest18 = explode('ABC',$report->quest18);
$quest19 = explode('ABC',$report->quest19);
$quest20 = explode('ABC',$report->quest20);
$marks = $quest1[1]+$quest2[1]+$quest3[1]+$quest4[1]+$quest5[1]+$quest6[1]+$quest7[1]+$quest8[1]+$quest9[1]+$quest10[1]+$quest11[1]+$quest12[1]+$quest13[1]+$quest14[1]+$quest15[1]+$quest16[1]+$quest17[1]+$quest18[1]+$quest19[1]+$quest20[1];
$exporter->addRow(array($i, $report->faculty, $student_info->name, $student_info->year, $student_info->semester, $student_info->roll, $report->subject, $quest1[1], $quest2[1], $quest3[1], $quest4[1], $quest5[1], $quest6[1], $quest7[1], $quest8[1], $quest9[1], $quest10[1], $quest11[1], $quest12[1], $quest13[1], $quest14[1], $quest15[1], $quest16[1], $quest17[1], $quest18[1], $quest19[1], $quest20[1], $report->message, $marks, $report->date_created));
$i++;
}
$exporter->finalize();
exit(); // all done
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title><?php echo $settings->name; ?> | Admin Panel</title>
<!-- Site favicon -->
<link rel='shortcut icon' type='image/x-icon' href='images/favicon.ico' />
<!-- /site favicon -->
<!-- Entypo font stylesheet -->
<link href="css/entypo.css" rel="stylesheet">
<!-- /entypo font stylesheet -->
<!-- Font awesome stylesheet -->
<link href="css/font-awesome.min.css" rel="stylesheet">
<!-- /font awesome stylesheet -->
<!-- Bootstrap stylesheet min version -->
<link href="css/bootstrap.min.css" rel="stylesheet">
<!-- /bootstrap stylesheet min version -->
<!-- Integral core stylesheet -->
<link href="css/integral-core.css" rel="stylesheet">
<!-- /integral core stylesheet -->
<link href="css/integral-forms.css" rel="stylesheet">
<link rel="stylesheet" href="//cdnjs.cloudflare.com/ajax/libs/jquery-form-validator/2.3.26/theme-default.min.css" type="text/css"/>
<!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
<script src="js/html5shiv.min.js"></script>
<script src="js/respond.min.js"></script>
<![endif]-->
</head>
<body>
<!-- Loader Backdrop -->
<div class="loader-backdrop">
<!-- Loader -->
<div class="loader">
<div class="bounce-1"></div>
<div class="bounce-2"></div>
</div>
<!-- /loader -->
</div>
<!-- loader backgrop -->
<!-- Page container -->
<div class="page-container">
<!-- Page Sidebar -->
<?php include("includes/sidebar.php"); ?>
<!-- /page sidebar -->
<!-- Main container -->
<div class="main-container">
<!-- Main header -->
<?php include("includes/header.php"); ?>
<!-- /main header -->
<!-- Main content -->
<div class="main-content">
<div class="row">
<div class="col-lg-8">
<h1 class="page-title">Faculty Report</h1>
<!-- Breadcrumb -->
<ol class="breadcrumb breadcrumb-2">
<li><a href="index-2.html"><i class="fa fa-home"></i>Home</a></li>
<li class="active"><strong>Faculty Report</strong></li>
</ol>
</div>
<div class="col-lg-4 ">
</div>
</div>
<div class="line-dashed"></div>
<?php
if(isset($_GET['msg'])){
if($_GET['msg']=='fail'){
echo "<div class='alert alert-warning'>
<button class='close' data-dismiss='alert'>×</button>
<strong>There was a Problem.</strong>
</div>";
} elseif($_GET['msg']=='success'){
echo "<div class='alert alert-success'>
<button class='close' data-dismiss='alert'>×</button>
<strong>Report Generated Successfully.</strong>
</div>";
}
}
?>
<div class="row">
<div class="col-lg-12">
<div class="panel panel-default">
<div class="panel-body">
<form enctype="multipart/form-data" class="form-horizontal" method="post">
<div class="form-group">
<label class="col-sm-2 control-label">Faculty Name</label>
<div class="col-sm-6">
<select name="faculty" class="form-control">
<option value="">-- All Faculty--</option>
<?php foreach($faculties as $faculty){ ?>
<option value="<?php echo $faculty->faculty; ?>"><?php echo $faculty->faculty; ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="form-group">
<label class="col-sm-2 control-label">Acedemic Year</label>
<div class="col-sm-6">
<select name="year" class="form-control">
<option value="">-- All Years --</option>
<option value="I Year">I Year</option>
<option value="II Year">II Year</option>
<option value="III Year">III Year</option>
</select>
</div>
</div>
<div class="form-group">
<label class="col-sm-2 control-label">Semester</label>
<div class="col-sm-6">
<select name="semester" class="form-control">
<option value="">-- All Semesters --</option>
<option value="I Semester">I Semester</option>
<option value="II Semester">II Semester</option>
<option value="III Semester">III Semester</option>
<option value="IV Semester">IV Semester</option>
<option value="V Semester">V Semester</option>
<option value="VI Semester">VI Semester</option>
</select>
</div>
</div>
<div class="form-group">
<label class="col-sm-2 control-label">Subject</label>
<div class="col-sm-6">
<select name="subject" class="form-control">
<option value="">-- All Subjects --</option>
<?php foreach($subjects as $subject){ ?>
<option value="<?php echo $subject->id; ?>"><?php echo $subject->subject; ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="form-group">
<div class="col-sm-4 col-sm-offset-2">
<button type="submit" name="submit" class="btn btn-primary">Submit</button>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
<!-- Footer -->
<?php include("includes/footer.php"); ?>
<!-- /footer -->
</div>
<!-- /main content -->
</div>
<!-- /main container -->
</div>
<!-- /page container -->
<!--Load JQuery-->
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.min.js"></script>
<script src="plugins/metismenu/js/jquery.metisMenu.js"></script>
<script src="plugins/blockui-master/js/jquery-ui.js"></script>
<script src="plugins/blockui-master/js/jquery.blockUI.js"></script>
<script src="js/functions.js"></script>
<script src="js/loader.js"></script>
<script src="//cdnjs.cloudflare.com/ajax/libs/jquery-form-validator/2.3.26/jquery.form-validator.min.js"></script>
<script>
$.validate({
modules : 'file'
});
</script>
</body>
</html>