Linux ip-172-26-7-228 5.4.0-1103-aws #111~18.04.1-Ubuntu SMP Tue May 23 20:04:10 UTC 2023 x86_64
Apache
: 172.26.7.228 | : 3.23.102.79
Cant Read [ /etc/named.conf ]
5.6.40-24+ubuntu18.04.1+deb.sury.org+1
www-data
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
HASH IDENTIFIER
README
+ Create Folder
+ Create File
/
var /
www /
html /
rcub /
valdet /
[ HOME SHELL ]
Name
Size
Permission
Action
index.js
3.47
KB
-rw-rw-r--
index.php
7.59
KB
-rw-rw-r--
rcub_logo_bg.jpg
262.93
KB
-rw-rw-r--
sys_connect.php
316
B
-rw-rw-r--
val_status.php
37.39
KB
-rw-rw-r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : val_status.php
<?php include("sys_connect.php"); $load_data = $_POST['load_data']; $myqry = ""; if ($load_data == 'valcntr') { $mysql = "select distinct vc.fvalcntr,vc.fvalname from masvalcntr vc inner join subject sb on vc.fvalcntr = sb.fvalcntr inner join degree dg on sb.fdegree = dg.fdegree and sb.fexamno = dg.fexamno inner join masqp qp on sb.fqpcode = qp.fqpcode where if(ifnull(qp.fappear,0)>0,ifnull(qp.fappear,0),ifnull(fcodecount,0)) and dg.fdeggrp like '$_POST[deggrp]' order by vc.fvalcntr;"; $myres = mysqli_query($mycon, $mysql); if (mysqli_num_rows($myres) == 0) { echo "<option value='%'>--Select--</option>"; }else{ echo "<option value='%'>All [Val. Centers]</option>"; } while ($myrow = mysqli_fetch_assoc($myres)) { echo "<option value='$myrow[fvalcntr]'>$myrow[fvalcntr] - $myrow[fvalname]</option>"; } } if ($load_data == 'program') { $mysql = "select distinct dg.fprogcode from degree dg inner join subject sb on dg.fdegree = sb.fdegree and dg.fexamno = sb.fexamno inner join masqp qp on sb.fqpcode = qp.fqpcode where if(ifnull(qp.fappear,0)>0,ifnull(qp.fappear,0),ifnull(fcodecount,0)) and dg.fdeggrp like '$_POST[deggrp]' order by dg.fprogcode;"; $myres = mysqli_query($mycon, $mysql); if (mysqli_num_rows($myres) == 0) { echo "<option value='%'>--Select--</option>"; }else{ echo "<option value='%'>All [Programs]</option>"; } while ($myrow = mysqli_fetch_assoc($myres)) { echo "<option value='$myrow[fprogcode]'>$myrow[fprogcode]</option>"; } } if ($load_data == 'examno') { $mysql = "select distinct dg.fexamno,dg.fexamname from degree dg inner join subject sb on dg.fdegree = sb.fdegree and dg.fexamno = sb.fexamno inner join masqp qp on sb.fqpcode = qp.fqpcode where if(ifnull(qp.fappear,0)>0,ifnull(qp.fappear,0),ifnull(fcodecount,0)) and dg.fdeggrp like '$_POST[deggrp]' order by dg.fexamno;"; $myres = mysqli_query($mycon, $mysql); if (mysqli_num_rows($myres) == 0) { echo "<option value='%'>--Select--</option>"; }else{ echo "<option value='%'>All [Sem / Year]</option>"; } while ($myrow = mysqli_fetch_assoc($myres)) { echo "<option value='$myrow[fexamno]'>$myrow[fexamname]</option>"; } } if ($load_data == 'board') { $mysql = "select distinct sb.fboard,mb.fboardname from degree dg inner join subject sb on dg.fdegree = sb.fdegree and dg.fexamno = sb.fexamno inner join masqp qp on sb.fqpcode = qp.fqpcode left join masboard mb on sb.fboard = mb.fboardcode where if(ifnull(qp.fappear,0)>0,ifnull(qp.fappear,0),ifnull(fcodecount,0)) and dg.fdeggrp like '$_POST[deggrp]' and sb.fvalcntr like '$_POST[valcntr]' and dg.fprogcode like '$_POST[program]' and dg.fexamno like '$_POST[examno]' order by mb.fboardname;"; $myres = mysqli_query($mycon, $mysql); if (mysqli_num_rows($myres) == 0) { echo "<option value='%'>--Select--</option>"; }else{ echo "<option value='%'>All [Boards]</option>"; } while ($myrow = mysqli_fetch_assoc($myres)) { echo "<option value='$myrow[fboard]'>$myrow[fboardname] [$myrow[fboard]]</option>"; } } if ($load_data == 'disp_data') { if($_POST['qpstat']=='codecomp'){ $myqry = " and ifnull(qp.fcodecount,0)>0 "; } if($_POST['qpstat']=='codepend'){ $myqry = " and ifnull(qp.fcodecount,0)=0 "; } if($_POST['qpstat']=='evalpend'){ $myqry = " and ifnull(ftotpkt1,0) > 0 and (ifnull(ftotpkt1,0) - ifnull(fvalpkt1,0)) <> 0 "; } if($_POST['qpstat']=='evalcomp'){ $myqry = " and ifnull(ftotpkt1,0) > 0 and (ifnull(ftotpkt1,0) - ifnull(fvalpkt1,0)) = 0 "; } // qp wise report if($_POST['reptype']=='qpcode'){ $mysql = "select dg.fdeggrp,sb.fvalcntr,qp.fboard,qp.fqpcode, qp.fsubname,ifnull(sb.fexamno,'') as fexamno, ifnull(qp.fappear,ifnull(qp.fcodecount,0)) as fappear, ifnull(qp.fcodecount,0) as fcodecount, ifnull(qp.fspresent,0) as fspresent, ifnull(qp.fapresent,0) as fapresent, ifnull(qp.ftotpkt1,0) as ftotpkt1, ifnull(qp.fvalpkt1,0) as fvalpkt1, ifnull(qp.ftotpkt2,0) as ftotpkt2, ifnull(qp.fvalpkt2,0) as fvalpkt2, ifnull(qp.ftotpkt1,0) - ifnull(qp.fvalpkt1,0) as fpenpkt1, left(group_concat(distinct sb.fdegree separator ' / '),30) as fdegreerange from masqp qp inner join subject sb on qp.fqpcode = sb.fqpcode inner join degree dg on sb.fdegree = dg.fdegree and sb.fexamno = dg.fexamno where if(ifnull(qp.fappear,0)>0,ifnull(qp.fappear,0),ifnull(fcodecount,0)) and qp.fdeggrp like '$_POST[deggrp]' and dg.fprogcode like '$_POST[program]' and sb.fvalcntr like '$_POST[valcntr]' and qp.fboard like '$_POST[board]' and qp.fexamno like '$_POST[examno]' ".$myqry." group by qp.fqpcode order by sb.fvalcntr,qp.fboard,fexamno,qp.fqpcode;"; $myres = mysqli_query($mycon, $mysql); $mycnt = mysqli_num_rows($myres); $i = 1; $totappear= 0; $totcodecount = 0; $totcodepkt1 = 0; $totvalpkt1 = 0; $totpenpkt1 = 0; if ($mycnt > 0) { echo "<table class='table table-sm table-striped table-bordered'>"; echo "<thead class='thread-dark'>"; echo "<tr>"; echo "<th width='5%' class='align-middle' style='text-align:center;'> # </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Val. Center </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Board </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> QP Code </th>"; echo "<th width='26%' class='align-middle' style='text-align:center;'> Subject Name </th>"; echo "<th width='5%' class='align-middle' style='text-align:center;'> Sem</th>"; echo "<th width='10%' class='align-middle' style='text-align:center;'> Degree Range </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Appear Count </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Coded Scripts </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Coding % </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Coded Packets </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Valued Packets </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Pending Packets </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Valuation % </th>"; echo "</tr>"; echo "</thead>"; echo "<tbody>"; while ($myrow = mysqli_fetch_assoc($myres)) { $codeper = number_format(($myrow['fcodecount'] / $myrow['fappear']) * 100,2); $valnper = number_format(($myrow['fvalpkt1'] / $myrow['ftotpkt1']) * 100,2); if($myrow['fappear']<$myrow['fcodecount']){ $trcolor = "color:Tomato;"; }else{ $trcolor = ""; } echo "<tr style='$trcolor'>"; echo "<td align='center'> $i</td>"; echo "<td align='center'> $myrow[fvalcntr]</td>"; echo "<td align='center'> $myrow[fboard]</td>"; echo "<td align='center'> $myrow[fqpcode]</td>"; echo "<td align='left'> $myrow[fsubname]</td>"; echo "<td align='center'> $myrow[fexamno]</td>"; echo "<td align='center'> $myrow[fdegreerange]</td>"; echo "<td align='center'> $myrow[fappear]</td>"; echo "<td align='center'> $myrow[fcodecount]</td>"; echo "<td align='center'> $codeper</td>"; echo "<td align='center'> $myrow[ftotpkt1]</td>"; echo "<td align='center'> $myrow[fvalpkt1]</td>"; echo "<td align='center'> $myrow[fpenpkt1]</td>"; echo "<td align='center'> $valnper</td>"; echo "</tr>"; $totappear= $totappear + $myrow['fappear']; $totcodecount = $totcodecount + $myrow['fcodecount']; $totcodepkt1 = $totcodepkt1 + $myrow['ftotpkt1']; $totvalpkt1 = $totvalpkt1 + $myrow['fvalpkt1']; $totpenpkt1 = $totpenpkt1 + $myrow['fpenpkt1']; $i++; } $totcodeper = number_format(($totcodecount / $totappear) * 100,2); $totvalnper = number_format(($totvalpkt1 / $totcodepkt1) * 100,2); echo "<strong>"; echo "<tr>"; echo "<td align='center' style='font-weight:bold' colspan='7'> Total</td>"; echo "<td align='center' style='font-weight:bold'> $totappear</td>"; echo "<td align='center' style='font-weight:bold'> $totcodecount</td>"; echo "<td align='center' style='font-weight:bold'> $totcodeper</td>"; echo "<td align='center' style='font-weight:bold'> $totcodepkt1</td>"; echo "<td align='center' style='font-weight:bold'> $totvalpkt1</td>"; echo "<td align='center' style='font-weight:bold'> $totpenpkt1</td>"; echo "<td align='center' style='font-weight:bold'> $totvalnper</td>"; echo "</tr>"; echo "</strong>"; echo "</tbody>"; echo "</table>"; } else { echo "<div class='alert alert-info alert-dismissible text-center'>QP Wise details not found!</div>"; } } // degree group wise summary if($_POST['reptype']=='deggrp' or $_POST['reptype']=='deggrp_examno'){ $myqry2 = "group by dg.fdeggrp;"; if($_POST['reptype']=='deggrp_examno'){ $myqry2 = "group by dg.fdeggrp,dg.fexamno;"; } $mysql = "select dg.fdeggrp,dg.fexamno,gp.fdescpn, sum(ifnull(fappear,0)) as fappear, sum(ifnull(fcodecount,0)) as fcodecount, sum(ifnull(ftotpkt1,0)) as ftotpkt1,sum(ifnull(fvalpkt1,0)) as fvalpkt1,sum(ifnull(ftotpkt1,0))-sum(ifnull(fvalpkt1,0)) as fpenpkt1, sum(ifnull(ftotpkt2,0)) as ftotpkt2,sum(ifnull(fvalpkt2,0)) as fvalpkt2,sum(ifnull(ftotpkt2,0))-sum(ifnull(fvalpkt2,0)) as fpenpkt2 from masqp qp inner join subject sb on qp.fqpcode = sb.fqpcode inner join degree dg on sb.fdegree = dg.fdegree and sb.fexamno = dg.fexamno inner join deggrp gp on dg.fdeggrp = gp.fdeggrp where if(ifnull(qp.fappear,0)>0,ifnull(qp.fappear,0),ifnull(fcodecount,0)) and qp.fdeggrp like '$_POST[deggrp]' and dg.fprogcode like '$_POST[program]' and sb.fvalcntr like '$_POST[valcntr]' and qp.fboard like '$_POST[board]' and qp.fexamno like '$_POST[examno]' ".$myqry.$myqry2; $myres = mysqli_query($mycon, $mysql); $mycnt = mysqli_num_rows($myres); $i = 1; $totappear= 0; $totcodecount = 0; $totcodepkt1 = 0; $totvalpkt1 = 0; $totpenpkt1 = 0; $totcodeper = 0; $totvalnper = 0; if ($mycnt > 0) { echo "<table class='table table-sm table-striped'>"; echo "<thead class='thread-dark'>"; echo "<tr>"; echo "<th width='5%' class='align-middle' style='text-align:center;'> # </th>"; echo "<th width='10%' class='align-middle' style='text-align:center;'> Deg. Group </th>"; echo "<th width='25%' class='align-middle' style='text-align:center;'> Group Description </th>"; if($_POST['reptype']=='deggrp_examno'){ echo "<th width='5%' class='align-middle' style='text-align:center;'> Sem</th>"; } echo "<th width='8%' class='align-middle' style='text-align:center;'> Appear Count </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Coded Scripts </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Coding % </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Coded Packets </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Valued Packets </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Pending Packets </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Valuation % </th>"; echo "</tr>"; echo "</thead>"; echo "<tbody>"; while ($myrow = mysqli_fetch_assoc($myres)) { $codeper = number_format(($myrow['fcodecount'] / $myrow['fappear']) * 100,2); $valnper = number_format(($myrow['fvalpkt1'] / $myrow['ftotpkt1']) * 100,2); echo "<tr>"; echo "<td align='center'> $i</td>"; echo "<td align='center'> $myrow[fdeggrp]</td>"; echo "<td align='left'>$myrow[fdescpn]</td>"; if($_POST['reptype']=='deggrp_examno'){ echo "<td align='center'> $myrow[fexamno]</td>"; } echo "<td align='center'> $myrow[fappear]</td>"; echo "<td align='center'> $myrow[fcodecount]</td>"; echo "<td align='center'> $codeper</td>"; echo "<td align='center'> $myrow[ftotpkt1]</td>"; echo "<td align='center'> $myrow[fvalpkt1]</td>"; echo "<td align='center'> $myrow[fpenpkt1]</td>"; echo "<td align='center'> $valnper</td>"; echo "</tr>"; $totappear= $totappear + $myrow['fappear']; $totcodecount = $totcodecount + $myrow['fcodecount']; $totcodepkt1 = $totcodepkt1 + $myrow['ftotpkt1']; $totvalpkt1 = $totvalpkt1 + $myrow['fvalpkt1']; $totpenpkt1 = $totpenpkt1 + $myrow['fpenpkt1']; $i++; } $totcodeper = number_format(($totcodecount / $totappear) * 100,2); $totvalnper = number_format(($totvalpkt1 / $totcodepkt1) * 100,2); echo "<strong>"; echo "<tr>"; if($_POST['reptype']=='deggrp_examno'){ echo "<td align='center' style='font-weight:bold' colspan='4'> Total</td>"; }else{ echo "<td align='center' style='font-weight:bold' colspan='3'> Total</td>"; } echo "<td align='center' style='font-weight:bold'> $totappear</td>"; echo "<td align='center' style='font-weight:bold'> $totcodecount</td>"; echo "<td align='center' style='font-weight:bold'> $totcodeper</td>"; echo "<td align='center' style='font-weight:bold'> $totcodepkt1</td>"; echo "<td align='center' style='font-weight:bold'> $totvalpkt1</td>"; echo "<td align='center' style='font-weight:bold'> $totpenpkt1</td>"; echo "<td align='center' style='font-weight:bold'> $totvalnper</td>"; echo "</tr>"; echo "</strong>"; echo "</tbody>"; echo "</table>"; } else { echo "<div class='alert alert-info alert-dismissible text-center'>Degree Group wise details not found!</div>"; } } // board wise summary if($_POST['reptype']=='board' or $_POST['reptype']=='board_examno'){ $myqry2 = "group by sb.fboard;"; if($_POST['reptype']=='board_examno'){ $myqry2 = "group by sb.fboard,sb.fexamno;"; } $mysql = "select sb.fboard,fboardname,sb.fexamno, sum(ifnull(fappear,0)) as fappear, sum(ifnull(fcodecount,0)) as fcodecount, sum(ifnull(ftotpkt1,0)) as ftotpkt1,sum(ifnull(fvalpkt1,0)) as fvalpkt1,sum(ifnull(ftotpkt1,0))-sum(ifnull(fvalpkt1,0)) as fpenpkt1, sum(ifnull(ftotpkt2,0)) as ftotpkt2,sum(ifnull(fvalpkt2,0)) as fvalpkt2,sum(ifnull(ftotpkt2,0))-sum(ifnull(fvalpkt2,0)) as fpenpkt2 from masqp qp inner join subject sb on qp.fqpcode = sb.fqpcode inner join degree dg on sb.fdegree = dg.fdegree and sb.fexamno = dg.fexamno left join masboard mb on qp.fboard = mb.fboardcode where if(ifnull(qp.fappear,0)>0,ifnull(qp.fappear,0),ifnull(fcodecount,0)) and qp.fdeggrp like '$_POST[deggrp]' and dg.fprogcode like '$_POST[program]' and sb.fvalcntr like '$_POST[valcntr]' and qp.fboard like '$_POST[board]' and qp.fexamno like '$_POST[examno]' ".$myqry.$myqry2; $myres = mysqli_query($mycon, $mysql); $mycnt = mysqli_num_rows($myres); $i = 1; $totappear= 0; $totcodecount = 0; $totcodepkt1 = 0; $totvalpkt1 = 0; $totpenpkt1 = 0; if ($mycnt > 0) { echo "<table class='table table-sm table-striped'>"; echo "<thead class='thread-dark'>"; echo "<tr>"; echo "<th width='5%' class='align-middle' style='text-align:center;'> # </th>"; echo "<th width='10%' class='align-middle' style='text-align:center;'> Board </th>"; echo "<th width='25%' class='align-middle' style='text-align:center;'> Board Name </th>"; if($_POST['reptype']=='board_examno'){ echo "<th width='5%' class='align-middle' style='text-align:center;'> Sem</th>"; } echo "<th width='8%' class='align-middle' style='text-align:center;'> Appear Count </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Coded Scripts </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Coding % </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Coded Packets </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Valued Packets </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Pending Packets </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Valuation % </th>"; echo "</tr>"; echo "</thead>"; echo "<tbody>"; while ($myrow = mysqli_fetch_assoc($myres)) { $codeper = number_format(($myrow['fcodecount'] / $myrow['fappear']) * 100,2); $valnper = number_format(($myrow['fvalpkt1'] / $myrow['ftotpkt1']) * 100,2); echo "<tr>"; echo "<td align='center'> $i</td>"; echo "<td align='center'> $myrow[fboard]</td>"; echo "<td align='left'> $myrow[fboardname]</td>"; if($_POST['reptype']=='board_examno'){ echo "<td align='center'> $myrow[fexamno]</td>"; } echo "<td align='center'> $myrow[fappear]</td>"; echo "<td align='center'> $myrow[fcodecount]</td>"; echo "<td align='center'> $codeper</td>"; echo "<td align='center'> $myrow[ftotpkt1]</td>"; echo "<td align='center'> $myrow[fvalpkt1]</td>"; echo "<td align='center'> $myrow[fpenpkt1]</td>"; echo "<td align='center'> $valnper</td>"; echo "</tr>"; $totappear= $totappear + $myrow['fappear']; $totcodecount = $totcodecount + $myrow['fcodecount']; $totcodepkt1 = $totcodepkt1 + $myrow['ftotpkt1']; $totvalpkt1 = $totvalpkt1 + $myrow['fvalpkt1']; $totpenpkt1 = $totpenpkt1 + $myrow['fpenpkt1']; $i++; } $totcodeper = number_format(($totcodecount / $totappear) * 100,2); $totvalnper = number_format(($totvalpkt1 / $totcodepkt1) * 100,2); echo "<strong>"; echo "<tr>"; if($_POST['reptype']=='board_examno'){ echo "<td align='center' style='font-weight:bold' colspan='4'> Total</td>"; }else{ echo "<td align='center' style='font-weight:bold' colspan='3'> Total</td>"; } echo "<td align='center' style='font-weight:bold'> $totappear</td>"; echo "<td align='center' style='font-weight:bold'> $totcodecount</td>"; echo "<td align='center' style='font-weight:bold'> $totcodeper</td>"; echo "<td align='center' style='font-weight:bold'> $totcodepkt1</td>"; echo "<td align='center' style='font-weight:bold'> $totvalpkt1</td>"; echo "<td align='center' style='font-weight:bold'> $totpenpkt1</td>"; echo "<td align='center' style='font-weight:bold'> $totvalnper</td>"; echo "</tr>"; echo "</strong>"; echo "</tbody>"; echo "</table>"; } else { echo "<div class='alert alert-info alert-dismissible text-center'>Board wise details not found!</div>"; } } // center wise summary if($_POST['reptype']=='valcntr' or $_POST['reptype']=='valcntr_deggrp' or $_POST['reptype']=='valcntr_examno'){ $myqry2 = "group by sb.fvalcntr;"; if($_POST['reptype']=='valcntr_examno'){ $myqry2 = "group by sb.fvalcntr,sb.fexamno;"; } if($_POST['reptype']=='valcntr_deggrp'){ $myqry2 = "group by sb.fvalcntr,dg.fdeggrp;"; } $mysql = "select sb.fvalcntr,fvalname,sb.fexamno,dg.fdeggrp, sum(ifnull(fappear,0)) as fappear, sum(ifnull(fcodecount,0)) as fcodecount, sum(ifnull(ftotpkt1,0)) as ftotpkt1,sum(ifnull(fvalpkt1,0)) as fvalpkt1,sum(ifnull(ftotpkt1,0))-sum(ifnull(fvalpkt1,0)) as fpenpkt1, sum(ifnull(ftotpkt2,0)) as ftotpkt2,sum(ifnull(fvalpkt2,0)) as fvalpkt2,sum(ifnull(ftotpkt2,0))-sum(ifnull(fvalpkt2,0)) as fpenpkt2 from masqp qp inner join subject sb on qp.fqpcode = sb.fqpcode inner join degree dg on sb.fdegree = dg.fdegree and sb.fexamno = dg.fexamno inner join masvalcntr mb on sb.fvalcntr = mb.fvalcntr where if(ifnull(qp.fappear,0)>0,ifnull(qp.fappear,0),ifnull(fcodecount,0)) and qp.fdeggrp like '$_POST[deggrp]' and dg.fprogcode like '$_POST[program]' and sb.fvalcntr like '$_POST[valcntr]' and qp.fboard like '$_POST[board]' and qp.fexamno like '$_POST[examno]' ".$myqry.$myqry2; $myres = mysqli_query($mycon, $mysql); $mycnt = mysqli_num_rows($myres); $i = 1; $totappear= 0; $totcodecount = 0; $totcodepkt1 = 0; $totvalpkt1 = 0; $totpenpkt1 = 0; if ($mycnt > 0) { echo "<table class='table table-sm table-striped'>"; echo "<thead class='thread-dark'>"; echo "<tr>"; echo "<th width='5%' class='align-middle' style='text-align:center;'> # </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Val. Center </th>"; echo "<th width='25%' class='align-middle' style='text-align:center;'> Val. Center Name </th>"; if($_POST['reptype']=='valcntr_deggrp'){ echo "<th width='5%' class='align-middle' style='text-align:center;'> Deg Grp</th>"; } if($_POST['reptype']=='valcntr_examno'){ echo "<th width='5%' class='align-middle' style='text-align:center;'> Sem</th>"; } echo "<th width='8%' class='align-middle' style='text-align:center;'> Appear Count </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Coded Scripts </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Coding % </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Coded Packets </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Valued Packets </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Pending Packets </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Valuation % </th>"; echo "</tr>"; echo "</thead>"; echo "<tbody>"; while ($myrow = mysqli_fetch_assoc($myres)) { $codeper = number_format(($myrow['fcodecount'] / $myrow['fappear']) * 100,2); $valnper = number_format(($myrow['fvalpkt1'] / $myrow['ftotpkt1']) * 100,2); echo "<tr>"; echo "<td align='center'> $i</td>"; echo "<td align='center'> $myrow[fvalcntr]</td>"; echo "<td align='left'> $myrow[fvalname]</td>"; if($_POST['reptype']=='valcntr_deggrp'){ echo "<td align='center'> $myrow[fdeggrp]</td>"; } if($_POST['reptype']=='valcntr_examno'){ echo "<td align='center'> $myrow[fexamno]</td>"; } echo "<td align='center'> $myrow[fappear]</td>"; echo "<td align='center'> $myrow[fcodecount]</td>"; echo "<td align='center'> $codeper</td>"; echo "<td align='center'> $myrow[ftotpkt1]</td>"; echo "<td align='center'> $myrow[fvalpkt1]</td>"; echo "<td align='center'> $myrow[fpenpkt1]</td>"; echo "<td align='center'> $valnper</td>"; echo "</tr>"; $totappear= $totappear + $myrow['fappear']; $totcodecount = $totcodecount + $myrow['fcodecount']; $totcodepkt1 = $totcodepkt1 + $myrow['ftotpkt1']; $totvalpkt1 = $totvalpkt1 + $myrow['fvalpkt1']; $totpenpkt1 = $totpenpkt1 + $myrow['fpenpkt1']; $i++; } $totcodeper = number_format(($totcodecount / $totappear) * 100,2); $totvalnper = number_format(($totvalpkt1 / $totcodepkt1) * 100,2); echo "<strong>"; echo "<tr>"; if($_POST['reptype']=='valcntr'){ echo "<td align='center' style='font-weight:bold' colspan='3'> Total</td>"; }else{ echo "<td align='center' style='font-weight:bold' colspan='4'> Total</td>"; } echo "<td align='center' style='font-weight:bold'> $totappear</td>"; echo "<td align='center' style='font-weight:bold'> $totcodecount</td>"; echo "<td align='center' style='font-weight:bold'> $totcodeper</td>"; echo "<td align='center' style='font-weight:bold'> $totcodepkt1</td>"; echo "<td align='center' style='font-weight:bold'> $totvalpkt1</td>"; echo "<td align='center' style='font-weight:bold'> $totpenpkt1</td>"; echo "<td align='center' style='font-weight:bold'> $totvalnper</td>"; echo "</tr>"; echo "</strong>"; echo "</tbody>"; echo "</table>"; } else { echo "<div class='alert alert-info alert-dismissible text-center'>Center wise details not found!</div>"; } } // program wise summary if($_POST['reptype']=='program' or $_POST['reptype']=='program_examno'){ $myqry2 = "group by dg.fprogcode;"; if($_POST['reptype']=='program_examno'){ $myqry2 = "group by dg.fprogcode,dg.fexamno;"; } $mysql = "select dg.fprogcode,dg.fexamno, sum(ifnull(fappear,0)) as fappear, sum(ifnull(fcodecount,0)) as fcodecount, sum(ifnull(ftotpkt1,0)) as ftotpkt1,sum(ifnull(fvalpkt1,0)) as fvalpkt1,sum(ifnull(ftotpkt1,0))-sum(ifnull(fvalpkt1,0)) as fpenpkt1, sum(ifnull(ftotpkt2,0)) as ftotpkt2,sum(ifnull(fvalpkt2,0)) as fvalpkt2,sum(ifnull(ftotpkt2,0))-sum(ifnull(fvalpkt2,0)) as fpenpkt2 from masqp qp inner join subject sb on qp.fqpcode = sb.fqpcode inner join degree dg on sb.fdegree = dg.fdegree and sb.fexamno = dg.fexamno where if(ifnull(qp.fappear,0)>0,ifnull(qp.fappear,0),ifnull(fcodecount,0)) and qp.fdeggrp like '$_POST[deggrp]' and dg.fprogcode like '$_POST[program]' and sb.fvalcntr like '$_POST[valcntr]' and qp.fboard like '$_POST[board]' and qp.fexamno like '$_POST[examno]' ".$myqry.$myqry2; $myres = mysqli_query($mycon, $mysql); $mycnt = mysqli_num_rows($myres); $i = 1; $totappear= 0; $totcodecount = 0; $totcodepkt1 = 0; $totvalpkt1 = 0; $totpenpkt1 = 0; if ($mycnt > 0) { echo "<table class='table table-sm table-striped'>"; echo "<thead class='thread-dark'>"; echo "<tr>"; echo "<th width='5%' class='align-middle' style='text-align:center;'> # </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Program </th>"; if($_POST['reptype']=='program_examno'){ echo "<th width='5%' class='align-middle' style='text-align:center;'> Sem</th>"; } echo "<th width='8%' class='align-middle' style='text-align:center;'> Appear Count </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Coded Scripts </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Coding % </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Coded Packets </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Valued Packets </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Pending Packets </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Valuation % </th>"; echo "</tr>"; echo "</thead>"; echo "<tbody>"; while ($myrow = mysqli_fetch_assoc($myres)) { $codeper = number_format(($myrow['fcodecount'] / $myrow['fappear']) * 100,2); $valnper = number_format(($myrow['fvalpkt1'] / $myrow['ftotpkt1']) * 100,2); echo "<tr>"; echo "<td align='center'> $i</td>"; echo "<td align='center'> $myrow[fprogcode]</td>"; if($_POST['reptype']=='program_examno'){ echo "<td align='center'> $myrow[fexamno]</td>"; } echo "<td align='center'> $myrow[fappear]</td>"; echo "<td align='center'> $myrow[fcodecount]</td>"; echo "<td align='center'> $codeper</td>"; echo "<td align='center'> $myrow[ftotpkt1]</td>"; echo "<td align='center'> $myrow[fvalpkt1]</td>"; echo "<td align='center'> $myrow[fpenpkt1]</td>"; echo "<td align='center'> $valnper</td>"; echo "</tr>"; $totappear= $totappear + $myrow['fappear']; $totcodecount = $totcodecount + $myrow['fcodecount']; $totcodepkt1 = $totcodepkt1 + $myrow['ftotpkt1']; $totvalpkt1 = $totvalpkt1 + $myrow['fvalpkt1']; $totpenpkt1 = $totpenpkt1 + $myrow['fpenpkt1']; $i++; } $totcodeper = number_format(($totcodecount / $totappear) * 100,2); $totvalnper = number_format(($totvalpkt1 / $totcodepkt1) * 100,2); echo "<strong>"; echo "<tr>"; if($_POST['reptype']=='program_examno'){ echo "<td align='center' style='font-weight:bold' colspan='3'> Total</td>"; }else{ echo "<td align='center' style='font-weight:bold' colspan='2'> Total</td>"; } echo "<td align='center' style='font-weight:bold'> $totappear</td>"; echo "<td align='center' style='font-weight:bold'> $totcodecount</td>"; echo "<td align='center' style='font-weight:bold'> $totcodeper</td>"; echo "<td align='center' style='font-weight:bold'> $totcodepkt1</td>"; echo "<td align='center' style='font-weight:bold'> $totvalpkt1</td>"; echo "<td align='center' style='font-weight:bold'> $totpenpkt1</td>"; echo "<td align='center' style='font-weight:bold'> $totvalnper</td>"; echo "</tr>"; echo "</strong>"; echo "</tbody>"; echo "</table>"; } else { echo "<div class='alert alert-info alert-dismissible text-center'>Program wise details not found!</div>"; } } // examno wise summary if($_POST['reptype']=='examno'){ $myqry2 = "group by dg.fexamno;"; $mysql = "select dg.fexamno,dg.fexamname, sum(ifnull(fappear,0)) as fappear, sum(ifnull(fcodecount,0)) as fcodecount, sum(ifnull(ftotpkt1,0)) as ftotpkt1,sum(ifnull(fvalpkt1,0)) as fvalpkt1,sum(ifnull(ftotpkt1,0))-sum(ifnull(fvalpkt1,0)) as fpenpkt1, sum(ifnull(ftotpkt2,0)) as ftotpkt2,sum(ifnull(fvalpkt2,0)) as fvalpkt2,sum(ifnull(ftotpkt2,0))-sum(ifnull(fvalpkt2,0)) as fpenpkt2 from masqp qp inner join subject sb on qp.fqpcode = sb.fqpcode inner join degree dg on sb.fdegree = dg.fdegree and sb.fexamno = dg.fexamno where if(ifnull(qp.fappear,0)>0,ifnull(qp.fappear,0),ifnull(fcodecount,0)) and qp.fdeggrp like '$_POST[deggrp]' and dg.fprogcode like '$_POST[program]' and sb.fvalcntr like '$_POST[valcntr]' and qp.fboard like '$_POST[board]' and qp.fexamno like '$_POST[examno]' ".$myqry.$myqry2; $myres = mysqli_query($mycon, $mysql); $mycnt = mysqli_num_rows($myres); $i = 1; $totappear= 0; $totcodecount = 0; $totcodepkt1 = 0; $totvalpkt1 = 0; $totpenpkt1 = 0; if ($mycnt > 0) { echo "<table class='table table-sm table-striped'>"; echo "<thead class='thread-dark'>"; echo "<tr>"; echo "<th width='5%' class='align-middle' style='text-align:center;'> # </th>"; echo "<th width='15%' class='align-middle' style='text-align:center;'> Sem</th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Appear Count </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Coded Scripts </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Coding % </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Coded Packets </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Valued Packets </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Pending Packets </th>"; echo "<th width='8%' class='align-middle' style='text-align:center;'> Valuation % </th>"; echo "</tr>"; echo "</thead>"; echo "<tbody>"; while ($myrow = mysqli_fetch_assoc($myres)) { $codeper = number_format(($myrow['fcodecount'] / $myrow['fappear']) * 100,2); $valnper = number_format(($myrow['fvalpkt1'] / $myrow['ftotpkt1']) * 100,2); echo "<tr>"; echo "<td align='center'> $i</td>"; echo "<td align='left'> $myrow[fexamno] - $myrow[fexamname]</td>"; echo "<td align='center'> $myrow[fappear]</td>"; echo "<td align='center'> $myrow[fcodecount]</td>"; echo "<td align='center'> $codeper</td>"; echo "<td align='center'> $myrow[ftotpkt1]</td>"; echo "<td align='center'> $myrow[fvalpkt1]</td>"; echo "<td align='center'> $myrow[fpenpkt1]</td>"; echo "<td align='center'> $valnper</td>"; echo "</tr>"; $totappear= $totappear + $myrow['fappear']; $totcodecount = $totcodecount + $myrow['fcodecount']; $totcodepkt1 = $totcodepkt1 + $myrow['ftotpkt1']; $totvalpkt1 = $totvalpkt1 + $myrow['fvalpkt1']; $totpenpkt1 = $totpenpkt1 + $myrow['fpenpkt1']; $i++; } $totcodeper = number_format(($totcodecount / $totappear) * 100,2); $totvalnper = number_format(($totvalpkt1 / $totcodepkt1) * 100,2); echo "<strong>"; echo "<tr>"; echo "<td align='center' style='font-weight:bold' colspan='2'> Total</td>"; echo "<td align='center' style='font-weight:bold'> $totappear</td>"; echo "<td align='center' style='font-weight:bold'> $totcodecount</td>"; echo "<td align='center' style='font-weight:bold'> $totcodeper</td>"; echo "<td align='center' style='font-weight:bold'> $totcodepkt1</td>"; echo "<td align='center' style='font-weight:bold'> $totvalpkt1</td>"; echo "<td align='center' style='font-weight:bold'> $totpenpkt1</td>"; echo "<td align='center' style='font-weight:bold'> $totvalnper</td>"; echo "</tr>"; echo "</strong>"; echo "</tbody>"; echo "</table>"; } else { echo "<div class='alert alert-info alert-dismissible text-center'>Semester wise details not found!</div>"; } } } ?>
Close
