echo "<fieldset><legend>Consolidated Report</legend><center><form action='#' method='post'>Select Class: ";
echo getClassesAsSelect("cls","");
echo " From-Date: <input type='text' id='inputField1' name='datein' />To-Date: <input type='text' id='inputField2' name='dateout'></input><input type='submit' name='phase1'><br /></form>";
if(isset($_POST['phase1']))
{
$bat = $_POST['cls'];
$batdet = explode(":",$_POST['cls']);
$batid = $batdet[0];
$sec = $batdet[1];
$datein = $_POST["datein"];
$dateout = $_POST['dateout'];
$in=strtotime($datein);
$out=strtotime($dateout);
if($in<$out)
{
echo getConReport($batid,$sec,strtotime($datein),strtotime($dateout));
}
else
{
notifyerr("Not A Valid In And Out Time");
}
echo "</center></fieldset>";
}
?>
</html>
function retrival($srno)
{
include_once("../lib/connection.php");
$newakyr=-1;
$srno= strtoupper($srno);
$result=mysql_query("select * from MSTUDENTT where srno='$srno'");
$rownum=mysql_num_rows($result);
if($rownum<=0)
{
notifyerr("Invalid Hallticket Number");
}
else
{
echo "Roll Number:<font color='blue'>".$srno."</font><br><br>";
while($s = mysql_fetch_array($result))
{
$sid=$s[0];
$batid=$s[6];
$did=$s[8];
$imgid=$s[5];
$image=mysql_query("select * from MIMGT where imgid='$imgid'");
$img=mysql_fetch_array($image);
$imguri=$img[1];
echo "<img src='../".$imguri."' width='150' height='150' class='imgshadow'></img><br /><br />";
}
if($did>=0)
{
$detain=mysql_query("select * from MDETAINT where did='$did'");
while($d=mysql_fetch_array($detain))
{
$batid=$d[2];
$newbatid=$d[3];
$newakyr=$d[4];
}
if($newakyr=='0')
{
echo "<br><font color='red'>NOTE:The Student is Detained in 1st Year</font><br>";
}
else if($newakyr=='1')
{
echo "<br><font color='red'>NOTE:The Student is Detained in 2-1</font><br>";
}
else if($newakyr=='2')
{
echo "<br><font color='red'>NOTE:The Student is Detained in 2-2</font><br>";
}
else if($newakyr=='3')
{
echo "<br><font color='red'>NOTE:The Student is Detained in 3-1</font><br>";
}
else if($newakyr=='4')
{
echo "<br><font color='red'>NOTE:The Student is Detained in 3-2</font><br>";
}
else if($newakyr=='5')
{
echo "<br><font color='red'>NOTE:The Student is Detained in 4-1</font><br>";
}
else if($newakyr=='6')
{
echo "<br><font color='red'>NOTE:The Student is Detained in 4-2</font><br>";
}
}
include_once("Detain.php");
$branch=mysql_query("select * from MBATCHT where batid='$batid'");
while($br = mysql_fetch_array($branch))
{
$brid=$br[1];
$regid=$br[2];
$batyr=$br['batyr'];
}
$brname=mysql_query("select * from MBRANCHT where brid='$brid'");
while($BR=mysql_fetch_array($brname))
{
$brname=$BR[1];
echo "<br>Branch:".$brname;
}
$reg=mysql_query("select * from MREGT where regid='$regid'");
while($REG=mysql_fetch_array($reg))
{
$reg=$REG[1];
echo "<br>Regulation:".$reg;
}
$regular=mysql_query("select * from MAVAILT where batid='$batid' and ros='R'");
$i=0;
echo "<br><div1><center><h2>Regular Results</h2></center></div1><br />";
while($reglr=mysql_fetch_array($regular))
{
$mrid=$reglr[0];
$akyr=$reglr[4];
if($i==0){
echo "<div id='placeholderm' style='width:450px;height:250px'></div>
<p id='hoverdata'><span id='clickdata'></span></p></div>" ;
echo getMarksGraph($srno);
}
echo "<center>";
if($akyr=='1')
{
echo "<br>Results For 1st Year Regular<br>";
}
else if($akyr=='2')
{
echo "<br>Results For 2nd Year 1st Semester Regular<br>";
}
else if($akyr=='3')
{
echo "<br>Results For 2nd Year 2st Semester Regular<br>";
}
else if($akyr=='4')
{
echo "<br>Results For 3rd Year 1st Semester Regular<br>";
}
else if($akyr=='5')
{
echo "<br>Results For 3rd Year 2nd Semester Regular<br>";
}
else if($akyr=='6')
{
echo "<br>Results For 4th Year 1st Semester Regular<br>";
}
else if($akyr=='7')
{
echo "<br>Results For 4th Year 2nd Semester Regular<br>";
}
echo "</center>";
echo "<br>";
echo("<table border=2 align=center bordercolor=black cellpadding='5'>");
echo "<div4>";
echo "<tr bgcolor=pink>";
echo("<td>");
echo("Subject Code");
echo("</td>");
echo("<td>");
echo("Subject Name");
echo("</td>");
echo("<td>");
echo("Internal");
echo("</td>");
echo("<td>");
echo("External");
echo("</td>");
echo("<td>");
echo("Credits");
echo("</td>");
echo("</tr>");
echo "</div4>";
$marks=mysql_query("select * from MMARKST where sid='$sid' and mrid='$mrid'");
$class="even";
$var=1;
while($sub=mysql_fetch_array($marks))
{
$subid=$sub[2];
$subject=mysql_query("select * from MSUBJECTT where subid='$subid'");
while($subj=mysql_fetch_array($subject))
{
$subname=$subj[2];
$subcode=$subj[1];
echo("<tr class='$class'>");
echo("<td>");
echo($subcode);
echo("</td>");
echo("<td>");
echo($subname);
echo("</td>");
}
$intr=$sub[3];
$extr=$sub[4];
$cre=$sub[5];
echo("<td>");
echo($intr);
echo("</td>");
echo("<td>");
echo($extr);
echo("</td>");
echo("<td>");
echo($cre);
echo("</td>");
echo("</tr>");
if($var%2==0)
{
$class="even";
$var=$var+1;
}
else if($var%2!=0)
{
$class="odd";
$var=$var+1;
}
}
echo("</table>");
if($newakyr==$akyr)
{
detainRegular($newbatid,$newakyr,$sid);
break;
}
$i++;
}
$supply=mysql_query("select * from MAVAILT where batid='$batid' and ros='S'");
$class="even";
$var=1;
while($supp=mysql_fetch_array($supply))
{
$mrid=$supp[0];
$akyr=$supp[4];
$regular=mysql_query("select * from MAVAILT where batid='$batid' and ros='R'");
while($reg=mysql_fetch_array($regular))
{
$doex=$reg[2];
}
echo "<br><div2><h2>Black Log History</h2></div2>";
echo "<center>";
if($akyr=='1')
{
echo "<br>Results For 1st Year Supplymentary<br>";
}
else if($akyr=='2')
{
echo "<br>Results For 2nd Year 1st Semester Supplymentary<br>";
}
else if($akyr=='3')
{
echo "<br>Results For 2nd Year 2st Semester Supplymentary<br>";
}
else if($akyr=='4')
{
echo "<br>Results For 3rd Year 1st Semester Supplymentary<br>";
}
else if($akyr=='5')
{
echo "<br>Results For 3rd Year 2nd Semester Supplymentary<br>";
}
else if($akyr=='6')
{
echo "<br>Results For 4th Year 1st Semester Supplymentary<br>";
}
else if($akyr=='7')
{
echo "<br>Results For 4th Year 2nd Semester Supplymentary<br>";
}
echo "</center>";
$marks=mysql_query("select * from MBACKLOGT where sid='$sid' and doex='$doex'");
$rows=mysql_num_rows($marks);
if($rows<=0)
{
echo "<br>No Backlock History Found<br>";
break;
}
echo "<br>";
echo("<table border=2 align=center bordercolor=black cellpadding='5'>");
echo "<div4>";
echo "<tr bgcolor=pink>";
echo("<td >");
echo("Subject Code");
echo("</td>");
echo("<td>");
echo("Subject Name");
echo("</td>");
echo("<td>");
echo("Internal");
echo("</td>");
echo("<td>");
echo("External");
echo("</td>");
echo("<td>");
echo("Credits");
echo("</td>");
echo("</tr>");
echo "</div4>";
while($sub=mysql_fetch_array($marks))
{
$subid=$sub[2];
$subject=mysql_query("select * from MSUBJECTT where subid='$subid'");
while($subj=mysql_fetch_array($subject))
{
$subname=$subj[2];
$subcode=$subj[1];
echo("<tr class='$class'>");
echo("<td>");
echo($subcode);
echo("</td>");
echo("<td>");
echo($subname);
echo("</td>");
}
$intr=$sub[3];
$cre='0';
$extr=$sub[4];
echo("<td>");
echo($intr);
echo("</td>");
echo("<td>");
echo($extr);
echo("</td>");
echo("<td>");
echo($cre);
echo("</td>");
echo("</tr>");
if($var%2==0)
{
$class="even";
$var=$var+1;
}
else if($var%2!=0)
{
$class="odd";
$var=$var+1;
}
}
echo("</table>");
if($newakyr>=$akyr)
{
detainSupply($newbatid,$newakyr,$sid);
break;
}
}
$rev=mysql_query("select * from MAVAILT where batid='$batid' and ros='RV'");
$var=1;
$class="even";
while($REV=mysql_fetch_array($rev))
{
$mrid=$REV[0];
$akyr=$REV[4];
$regular=mysql_query("select * from MAVAILT where batid='$batid' and ros='R'");
while($reg=mysql_fetch_array($regular))
{
$doex=$reg[2];
}
echo "<br><div3><h2>Revaluation History</h2></div3>";
if($akyr>$newakyr)
{
detainRev();
break;
}
if($akyr=='1')
{
echo "<br>Revaluation For 1st Year<br>";
}
else if($akyr=='2')
{
echo "<br>Revaluation For 2nd Year 1st Semester<br>";
}
else if($akyr=='3')
{
echo "<br>Revaluation For 2nd Year 2st Semester <br>";
}
else if($akyr=='4')
{
echo "<br>Revaluation For 3rd Year 1st Semester <br>";
}
else if($akyr=='5')
{
echo "<br>Revaluation For 3rd Year 2nd Semester<br>";
}
else if($akyr=='6')
{
echo "<br>Revaluation For 4th Year 1st Semester<br>";
}
else if($akyr=='7')
{
echo "<br>Revaluation For 4th Year 2nd Semester<br>";
}
echo "<br>";
$marks=mysql_query("select * from MREVT where sid='$sid' and doex='$doex'");
$rows=mysql_num_rows($marks);
if($rows<=0)
{
echo "<br>No Revaluation History Found<br><br>";
break;
}
echo("<table border=2 align=center bordercolor=black cellpadding='5'>");
echo "<div4>";
echo "<tr bgcolor=pink>";
echo("<td>");
echo("Subject Code");
echo("</td>");
echo("<td>");
echo("Subject Name");
echo("</td>");
echo("<td>");
echo("Internal");
echo("</td>");
echo("<td>");
echo("External");
echo("</td>");
echo("<td>");
echo("Credits");
echo("</td>");
echo("</tr>");
echo "</div4>";
while($sub=mysql_fetch_array($marks))
{
$subid=$sub[2];
$subject=mysql_query("select * from MSUBJECTT where subid='$subid'");
while($subj=mysql_fetch_array($subject))
{
$subname=$subj[2];
$subcode=$subj[1];
echo("<tr bgcolor=cyan>");
echo("<td>");
echo($subcode);
echo("</td>");
echo("<td>");
echo($subname);
echo("</td>");
}
$intr=$sub[3];
$cre='0';
$extr=$sub[4];
echo("<td>");
echo($intr);
echo("</td>");
echo("<td>");
echo($extr);
echo("</td>");
echo("<td>");
echo($cre);
echo("</td>");
echo("</tr>");
if($var%2==0)
{
$class="even";
$var=$var+1;
}
else if($var%2!=0)
{
$class="odd";
$var=$var+1;
}
}
echo("</table>");
if($newakyr>=$akyr)
{
detainSupply($newbatid,$newakyr,$sid);
break;
}
}
}
}
$sid = $Arr['sid'];
$brid = getBranchFromSrno($rno);
$obrid = getBranchFilter();
$result=mysql_query("select * from MSTUDENTT where srno='$rno'");
$rownum=mysql_num_rows($result);
if($rownum<=0)
{
notifyerr("Invalid Hallticket Number");
}
else
{
if($obrid=='%' || $brid==$obrid)
{
echo " <div id='placeholder' style='width:500px;height:300px'></div>
<p id='hoverdata'> <span id='clickdata'></span></p>";
echo getStuGraph($sid,strtotime($datein),strtotime($dateout));
echo getStuReport($sid,strtotime($datein),strtotime($dateout),-1);
}
else
notifyerr("The Student Does Not Correspond To The Branch Concerned With You!");
}
}
?>
</div>
</center>
</fieldset>
</body>
</html>
echo "<td><input type=text name=cre value='$cre' size='2' Style='text-align: center;'></td>";
echo "<td><input type='submit' value='Update' name='final'></td></tr>";
}
if(isset($_POST['final']))
{
$intm=$_POST['intm'];
$extm=$_POST['extm'];
$cre=$_POST['cre'];
$subid=$_POST['subid'];
$sid=$_POST['sid'];
$mrid=$_POST['mrid'];
if($intm==null || $extm==null || $cre==null)
{
notifyerr("Null Values cannot be updated");
}
else
{
mysql_query("update MMARKST set intm='$intm',extm='$extm',cre='$cre' where sid='$sid' and mrid='$mrid' and subid='$subid'");
notify("Update Done");
}
}
?>
</center>
</fieldset>
</body>
</html>
<?php
require_once '../lib/mod_lib.php';
$keys = getConfigKeys(getAuthToken("portcullis"));
if (!array_key_exists('dbname', $keys) || !array_key_exists('dbpass', $keys) || !array_key_exists('dbuser', $keys)) {
notifyerr("<b >Module Not Configured Properly!</b>");
redirect("?m=modules");
}
$dbname = $keys["dbname"][1];
$dbuser = $keys["dbuser"][1];
$dbpass = $keys["dbpass"][1];
$conx = mysql_connect("localhost", $dbuser, $dbpass);
mysql_select_db($dbname, $conx);
?>
<fieldset>
<legend>Import From A Portcullis Database</legend>
<body>
<center>
<?php
if ($_GET["tabid"] == NULL) {
echo "<div class='box' style='width:60%'>";
echo "<h3 class='label success'>Available Results</h3>";
echo "<form action='#' class='uniForm' method='post'>";
$q = mysql_query("select * from MRESULTT", $conx);
echo "<table class='bttable'>";
while ($row = mysql_fetch_array($q)) {
echo "<tr><td>";
$table = $row["rtabname"];
$resname = $row["rname"];
include_once("../lib/connection.php");
$per=$_POST['per'];
$per1=$_POST['per1'];
$aid=$_POST['aid'];
$aid1=$_POST['aid1'];
$faculty=mysql_query("select * from MATDT where aid='$aid[$per]'");
$f=mysql_fetch_array($faculty);
$fac=$f['fid'];
$faculty1=mysql_query("select * from MATDT where aid='$aid1[$per1]'");
$f1=mysql_fetch_array($faculty1);
$fac1=$f1['fid'];
xDebug($aid[$per]);
xDebug($aid1[$per1]);
if($per==null || $per1==null)
{
notifyerr("One or more Periods not selected. Try Again");
redirect("?m=edit_Matt");
}
else if($aid1[$per1]==NULL)
{
mysql_query("update MATDT set sessionid='$per1' where aid='$aid[$per]'");
notify("Updated Successfully");
redirect("?m=edit_Matt");
}
else
{
//mysql_query("update MATDT set fid='$fac' where aid='$aid1[$per1]'");
//mysql_query("update MATDT set fid='$fac1' where aid='$aid'");
mysql_query("update MATDT set sessionid='$per' where aid='$aid1[$per1]'");
mysql_query("update MATDT set sessionid='$per1' where aid='$aid[$per]'");
notify("Updated Successfully");
<input type="submit" name='retrival'/> <a href='' onclick='printer()'>Print</a>
</form>
<div id='php_retival'>
<?php
echo "<div id='printarea'>";
if(isset($_POST['retrival']))
{
if($_POST['srno']!="")
{
$brid = getBranchFromSrno($_POST['srno']);
$obrid = getBranchFilter();
$srno=$_POST['srno'];
if($obrid=='%' || $brid==$obrid)
{
include_once("Retrival.php");
retrival($srno);
}
else
notifyerr("The Student Does Not Correspond To The Branch Concerned With You!");
}
else
notifyerr("Invalid Hall Ticket Number");
}
echo "</div>";
?>
</div>
</body>
</html>
