-
Notifications
You must be signed in to change notification settings - Fork 1
/
chartfees.php
123 lines (107 loc) · 3.59 KB
/
chartfees.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
<?php
session_start();
include("header.php");
include("connection.php");
$background_colors = array('#FF00FF', '#0099FF', '#CC9900', '#FF0000', '#66FFFF','#00FF00','#0066FF','#666600','#FFFF00','#FF0066');
?>
<div id="main">
<div id="content" class="left">
<div class="highlight">
<h3>Fee Report </h3>
<form id="form2" name="form2" method="post" action="">
<label for="textfield"></label>
<table width="371" border="0">
<tr>
<th width="122" height="35" scope="row"> School Type</th>
<td width="233"> <select name="insttype" id="insttype">
<?php
$arrec = array("High school","PUC");
foreach($arrec as $value)
{
echo "<option value='$value'>$value </option>";
}
?>
</select></td>
</tr>
<tr>
<th height="39" scope="row">Year </th>
<td><select name="insttype2" id="insttype2">
<?php
$result = mysqli_query($con,"SELECT DISTINCT year FROM survey");
while($arrays = mysqli_fetch_array($result))
{
echo "<option value='$arrays[year]'>$arrays[year]</option>";
}
?>
</select></td>
</tr>
<tr>
<th height="38" scope="row"> </th>
<td><input type="submit" name="submit" id="submit" value=" Submit " /></td>
</tr>
</table>
</form>
<?php
//select institute0
$contti=0;
$result2 = mysqli_query($con,"SELECT * FROM institute where inst_type='$_POST[insttype]'");
while($arrays2 = mysqli_fetch_array($result2))
{
$result4 = mysqli_query($con,"SELECT * FROM survey where inst_id='$arrays2[0]'");
while($arrays1 = mysqli_fetch_array($result4))
{
$result=0;
$counts=0;
// mysqli_num_rows($result4);
$result1 = mysqli_query($con,"SELECT * FROM payment where surveyno = '$arrays1[0]'");
$ct = mysqli_num_rows($result1);
while($arrays4 = mysqli_fetch_array($result1))
{
$annual_result = unserialize($arrays4[pay_details]);
//$result = ($annual_result[32])*100;
$contti = $contti+1;
// $count = count($background_colors) - 1;
// $i = rand(0, $count);
$rand_background = $background_colors[$contti];
echo "<tr bgcolor='$rand_background'>
<td height='23'> <b> $arrays2[0]</b></td>
<td> ";
$widthal = number_format($result,2);
$widthal1 = $widthal*5;
echo "</td></tr>";
$chartval = $annual_result[32]/1000;
echo "
<table width='$chartval' border='0' bgcolor='$rand_background'>
<tr>
<th height='18' scope='row'> $annual_result[32]</th>
</tr>
</table><br>";
$totresult = $totresult + $result;
}
$counts++;
$entire0 = $entire0 + $result;
$entire1=$entire0/$counts;
}
$totres = $totres + $result;
}
?>
</table>
<label for="type"><a href="surveytype.php"><strong>Back</strong></a></label>
<p> </p>
</div>
<div class="projects">
<div class="item"></div>
<div class="item">
<div class="cl"> </div>
</div>
</div>
</div>
<div class="cl"> </div>
</div>
<div class="shadow-l"></div>
<div class="shadow-r"></div>
<div class="shadow-b"></div>
</div>
<?php
include("footer.php");
?>