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>