-
Notifications
You must be signed in to change notification settings - Fork 0
/
hod_view.php
153 lines (131 loc) · 5.28 KB
/
hod_view.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
<?php
ob_start();
?>
<script src="https://code.jquery.com/jquery-1.12.0.min.js"></script>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<!-- Our Custom CSS -->
<link rel="stylesheet" href="style2.css">
<!-- Scrollbar Custom CSS -->
<link rel="icon" type="image/png" href="images/vjitlogo.png"/>
<title>VJIT FEEDBACK</title>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/malihu-custom-scrollbar-plugin/3.1.5/jquery.mCustomScrollbar.min.css">
<script type='text/javascript' src='js/check_size.js'>
</script>
<body>
<?php
error_reporting(0);
session_start();
if(isset($_SESSION["faculty"]))
{
if($_SESSION['position']==5)
{
require_once("property_read.php");
require_once("database_connect.php");
require_once("code_insert.php");
/*echo "
<div align='center'><h4>Branch Wise Faculty Feedback Data</h4>
<form id='branch_select' action='branch-faculty.php' method='post'>
<table class='table'>
<tr><th>Select Branch</th>
<td><input type='radio' value='CSE' name='branch' id='c13'> CSE</td>
<td><input type='radio' value='MECH' name='branch' id='c13'> MECH</td>
<td><input type='radio' value='IT' name='branch' id='c13'> IT</td>
<td><input type='radio' value='ECE' name='branch' id='c13'> ECE</td>
<td><input type='radio' value='EEE' name='branch' id='c13'> EEE</td>
<td><input type='radio' value='CIVIL' name='branch' id='c13'> CIVIL</td>
</tr>
<tr><td><input type='checkbox' name='check_comment'>Show Comments</td><td><input type='submit' value='Get Data' title='year_select' class='btn btn-success'></td>
<td><button value='clear' onclick='clear(this.title)' title='year_select' class='btn btn-default'>clear</button></td>
<td><a href='admin-index.php'><input type='button' class='btn btn-basic' value='Home'></a></td>
</tr>
</table>
</form>
</div>
<hr>
";*/
$branch=$_SESSION['branch'];
$name='';
$subject_fid;
$array_cols;
$cols=$property_decode['t104']['admin-main'];
$columns=$property_decode['t104']['final-admin'];
$comments;
$i=0;
$query="select c7 from t102 where c13='$branch'";
echo "<div id='result_box'><div align='center' class='noprint'><h3> Faculty Feedback Data-$branch</h3></div>";
echo "<div align='center'><table class='table table-hover' id='table' style='text-align:center'><tr><th>Faculty Name</th>";
foreach($cols as $columns_insert=>$value)
{
if($value=='c34')continue;
echo "<th>".$array_names[trim($value)]."</th>";
}
echo "<th>Average</th>";
if($check_comment=='on')
echo "<th>Comments</th>";
if($result=mysqli_query($con,$query))
{
if(($rows=mysqli_num_rows($result))>0)
{
while ($row = mysqli_fetch_assoc($result))
{
foreach($row as $key=>$field)
{
$query2="select ".$columns." from t114_".$property_decode['current_database']['value']." where c7='$field'";
if($result2=mysqli_query($con,$query2))
{
if(($rows2=mysqli_num_rows($result2))>0)
{
//echo "rows='$rows2'<br>";
while ($row2 = mysqli_fetch_assoc($result2))
{
foreach($row2 as $key2=>$field2)
{
if($key2=='c7')
{
$name=array_search($field2,$faculty_code);
echo"<tr><td>$name</td>";
}
else if($key2=='c15')
{
if(array_search(trim($field2),$regular_subject_code)!=null)
echo "<td>".array_search(trim($field2),$regular_subject_code)."</td>";
else if(array_search(trim($field2),$oe_subject_code)!=null)
echo "<td>".array_search(trim($field2),$oe_subject_code)."-OE</td>";
else if(array_search(trim($field2),$pe_subject_code)!=null)
echo "<td>".array_search(trim($field2),$pe_subject_code)."-PE</td>";
else if(array_search(trim($field2),$batch_lab_subject_code)!=null)
echo "<td>".array_search(trim($field2),$batch_lab_subject_code)."-SPLAB </td>";
// calculating average here
}
else
echo "<td>$field2</td>";
}
echo "</tr>";
}
}
}
}
}
}
}
echo "</table></div></div>";
echo "<div align='center' id='print'>
<button class='btn btn-default' onclick='print()'>print</button>
</div>";
//logging
$desc=":,viewed branch wise faculty feedback data";
$query_log="(".$query.")";
require_once('logging.php');
////
}
else
echo "<h3>You are not authorised to acces this content</h3>";
}
else
{
echo "<div align='center'><h2 class='fs-title'>Please Proof that You are an ADMIN <a href='admin.php'>click here</a></h2></div>";
exit();
}
?>
<a href='#result_box'><div style='position:fixed;bottom:0;right:0;padding-top:25px;padding-right:25px;padding-left:25px;padding-bottom:75px'><img src='images/arrow.png' height='35px' width='20px'></div></a>
<a href='#print'><div style='position:fixed;bottom:0;right:0;padding:25px'><img src='images/down-arrow.png' height='35px' width='20px'></div></a>