1#@!#!123s

: / home / diafrica / result.dominicaninstitute.org /
Filename : managegp3.php
back
<?php 
if (!$_SESSION){
	session_start();
}
$acc=$_SESSION['acc'];
$yto=$_SESSION['yto'];
if(isset($acc) && ($acc=="administratoroftheduresult2018byto")){?>

<?php include("Connecter/dataconn.php"); ?>

<?php
if (isset($_POST['applystage2'])){
	
$nsql="update gradepoints set status='passive',dfrom=0,dto=0";	
$nresult=mysql_query($nsql);

$felis=$_POST['applystage2'];
	for($i=0;$i<=$felis;$i++){
		$gradepoint="gp".$i;
		$dfrom="from".$i;
		$dto="to".$i;
		
		$gp=$_POST[$gradepoint];
		$from=$_POST[$dfrom];
		$to=$_POST[$dto];
		
		$nsql="update gradepoints set status='active', dfrom='".$from."', dto='".$to."' where gradepoint='".$gp."'";
		//$nresult=@mysql_query($nsql);
		
		if (mysql_query($nsql)){
			$bb=$bb."<div class='alert alert-success'><p><span class='glyphicon glyphicon-ok' aria-hidden='true'></span> Grade Point ".$i." Successfully Edited!</p></div>";
		} else {
			$bb=$bb."<div class='alert alert-danger'><p><span class='glyphicon glyphicon-remove' aria-hidden='true'></span> Unable to edit Grade Point ".$i.": " . mysql_error() . "</p></div>";
		}

	}

//gp adjustments
$sqln="update coursesregistered set gp=0";
$resultn=mysql_query($sqln);

$nsql="select * from gradepoints where status='active' order by gradepoint asc";
$nresult=mysql_query($nsql);
$ndn=mysql_num_rows($nresult);
if($ndn>0){
	while($nrow=mysql_fetch_array($nresult)){
		$ddgp=$nrow['gradepoint'];
		$ddfrom=$nrow['dfrom'];
		$ddto=$nrow['dto'];
		
		$fsql="update coursesregistered set gp=".$ddgp." where score>=".$ddfrom." and score<=".$ddto;
		$fresult=mysql_query($fsql);
	}
}
//end of gp adjustments


?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php include("head.php"); ?>

<style type="text/css">
.error { color:#990000; }
</style>

	<script src="validator/lib/jquery.js"></script>
	<script src="validator/dist/jquery.validate.js"></script>
    

<script>
	$().ready(function() {
		
		//Disable cut copy paste
		$('input.gnum').bind("cut copy paste",function(e) {
      e.preventDefault();
		   });
		$('input.gnum2').bind("cut copy paste",function(e) {
      e.preventDefault();
		   });
		$('input.gchar').bind("cut copy paste",function(e) {
      e.preventDefault();
		   });
		$('input.gchar2').bind("cut copy paste",function(e) {
      e.preventDefault();
		   });
		
		//Disable mouse right click
    $('input.gnum').on("contextmenu",function(e){
        return false;
    });
	$('input.gnum2').on("contextmenu",function(e){
        return false;
    });
	$('input.gchar').on("contextmenu",function(e){
        return false;
    });
	$('input.gchar2').on("contextmenu",function(e){
        return false;
    });
	
		//Prevents some keys from being entered
		
			//Allows numbers, backspaces. No characters, spaces or dot
		$('input.gnum').keypress(function(key) {
        if((key.charCode < 48 || key.charCode > 57) && key.charCode != 0 && key.charCode != 8 && key.charCode != 9) return false;
		    });
			
			//Allows numbers, backspaces and dot. No characters, spaces or dot
		$('input.gnum2').keypress(function(key) {
        if((key.charCode < 48 || key.charCode > 57) && key.charCode != 0 && key.charCode != 8 && key.charCode != 9 && key.charCode != 46) return false;
		    });
		
		
			//Allows characters, backspaces and hyphen. No numbers
		$('input.gchar').keypress(function(key) {
if((key.charCode < 97 || key.charCode > 122) && (key.charCode < 65 || key.charCode > 90) && (key.charCode != 45) && key.charCode != 0 && key.charCode != 8 && key.charCode != 9) return false;
			});
			
			//Allows characters, backspaces, hyphen and spaces. No numbers
		$('input.gchar2').keypress(function(key) {
if((key.charCode < 97 || key.charCode > 122) && (key.charCode < 65 || key.charCode > 90) && (key.charCode != 45) && key.charCode != 0 && key.charCode != 8 && key.charCode != 9 && key.charCode != 32) return false;
			});			



	});
	</script>

<script src="jay/jquery-2.2.4.min.js"></script>
<script src='jay/bootbox.min.js'></script>

<link rel="stylesheet" href="jay/bootstrap.min.css">
<script src="jay/bootstrap.min.js"></script>  


<script>
$(document).ready(function(){
	
	

		
	$('.etom').blur(function(event){
		var el = this;
        var dto = this.id;
		dto = "#" + dto;
		
		var dfrom = this.title;
		var splitid = dfrom.split("_");	
		var pos = splitid[1];
		
		var itsfrom = "#from" + pos;
		dpos = parseInt(pos) + 1;
		var nextfrom = "#from" + dpos;
		var nextto = "#to" + dpos;
		
		var trouwumi = $('#applystage3').val();
		
		if( $(dto).val()<=0 || $(dto).val()>=trouwumi || $(dto).val()<=$(itsfrom).val() ){
			$(dto).val('');
		} else {
			$(nextfrom).val($(dto).val());
		}
		if( $(dto).val()>=$(nextto).val() ){
			if($(nextto).val()!=trouwumi){
				$(nextto).val('');
			}
		}
	});
	
	
    $("#NewApply").submit(function(event){
		var vname = 0;
		
		$('.etom').each(function(i, obj) {
    		var el = this;

			var dto = "#to" + i;
			var itsfrom = "#from" + i;
			j = parseInt(i) + 1;
			var nextto = "#to" + j;
			var nextfrom = "#from" + j;
			
			var trouwumi = $('#applystage3').val();
					
			if( $(dto).val()<0 || $(dto).val()>trouwumi || parseFloat($(dto).val()) <= parseFloat($(itsfrom).val()) ){
				vname=1;	
				$(dto).val('');
			}
			if( parseFloat($(dto).val()) >= parseFloat($(nextto).val()) ){
				vname=1;
				if($(nextto).val()!=trouwumi){
					$(nextto).val('');
				}
			}
			if($(dto).val()==''){
				vname=1;
				$(dto).css("background-color","#fcc3c5");
			}
			if($(itsfrom).val()==''){
				vname=1;
				$(itsfrom).css("background-color","#fcc3c5");
			}

		});
		
		//alert(vname)
		
		if(vname==1){
			event.preventDefault();
        	bootbox.alert("Invalid Entry!");
		} else {
		}
    });
	
	
});
</script>

</head>
<body>

<?php include("top.php"); ?>
<?php include("dtable0.php"); ?>
<?php include("nav.php"); ?>
<?php include("dtable1.php"); ?>
<?php include("topcontainer.php"); ?>
<!--Content Goes Here-->
<div class="headingbiggest">Editing Class of Degree</div>
<div class="headingbigger">Fill the Form below appropriately</div>
<hr />


 <form class="form-horizontal" role="form" id="NewApply" name="NewApply" method="post" action="managegp4.php">
 
<div style="width:80%; text-align:center; margin:0px auto;"> 
<table class="table table-striped">
    <thead>
      <tr>
        <th>Class of Degree</th>
        <th>From</th>
        <th>To</th>
      </tr>
    </thead>
    <tbody> 
    
    <tr>
<td><input type="text" class="form-control gnum2" name="gp0" value="Fail" required readonly size="1"></td>
<td><input type="text" class="form-control gnum2" id="from0" name="from0" value="0" required readonly size="1"></td>
<td><input type="text" class="form-control gnum2 etom" id="to0" name="to0" value="" required size="1" title="pos_0"></td>
      </tr>

    <tr>
<td><input type="text" class="form-control gnum2" name="gp1" value="Pass" required readonly size="1"></td>
<td><input type="text" class="form-control gnum2" id="from1" name="from1" value="" required readonly size="1"></td>
<td><input type="text" class="form-control gnum2 etom" id="to1" name="to1" value="" required size="1" title="pos_1"></td>
      </tr>    

    <tr>
<td><input type="text" class="form-control gnum2" name="gp2" value="Third Class" required readonly size="1"></td>
<td><input type="text" class="form-control gnum2" id="from2" name="from2" value="" required readonly size="1"></td>
<td><input type="text" class="form-control gnum2 etom" id="to2" name="to2" value="" required size="1" title="pos_2"></td>
      </tr> 

    <tr>
<td><input type="text" class="form-control gnum2" name="gp3" value="Second Class Lower" required readonly size="1"></td>
<td><input type="text" class="form-control gnum2" id="from3" name="from3" value="" required readonly size="1"></td>
<td><input type="text" class="form-control gnum2 etom" id="to3" name="to3" value="" required size="1" title="pos_3"></td>
      </tr>  
      
    <tr>
<td><input type="text" class="form-control gnum2" name="gp4" value="Second Class Upper" required readonly size="1"></td>
<td><input type="text" class="form-control gnum2" id="from4" name="from4" value="" required readonly size="1"></td>
<td><input type="text" class="form-control gnum2 etom" id="to4" name="to4" value="" required size="1" title="pos_4"></td>
      </tr>           
      
    <tr>
<td><input type="text" class="form-control gnum2" name="gp5" value="First Class" required readonly size="1"></td>
<td><input type="text" class="form-control gnum2" id="from5" name="from5" value="" required readonly size="1"></td>
<td><input type="text" class="form-control gnum2 etom" id="to5" name="to5" value="<?php echo($felis); ?>" required size="1" readonly title="pos_5"></td>
      </tr>    
    
    

    </tbody>
  </table>
</div>

  
  
<div class="col-sm-offset-2 col-sm-10">
      <button type="submit" class="btn btn-primary" name="applystage3" id="applystage3" value="<?php echo($felis); ?>"><span class="glyphicon glyphicon-menu-right" aria-hidden="true"></span> Proceed</button>
    </div>
  </div>
     
 </form>
 

<p>&nbsp;</p>
<hr />
<?php echo($bb); ?>
 
 
<!--Content Ends Here-->
<?php include("bottomcontainer.php"); ?>
<?php include("dtable2.php"); ?>
<?php include("side.php"); ?>
<?php include("dtable3.php"); ?>
<?php include("foot.php"); ?>


</body>
</html>

<?php
} else {
	include("dadmin.php");
}
?>

<?php } else {
include("ddadmin.php");
}?>