admin_attendance_codes.php

/admin_attendance_codes.php

http://swifttide.googlecode.com/
PHP | 159 lines | 125 code | 17 blank | 17 comment | 11 complexity | 379a48f9ddfa8c38783d32f040124bbc MD5 | raw file

<?php
//*
// admin_attendance_codes.php
// Admin Section
// Display and Manage Attendance Codes Table
//*

//Check if admin is logged in
session_start();
if(!session_is_registered('UserId') || $_SESSION['UserType'] != "A")
  {
    header ("Location: index.php?action=notauth");
	exit;
}


//Include global functions
include_once "common.php";
//Initiate database functions
include_once "ez_sql.php";
//Include paging class
include_once "ez_results.php";
// config
include_once "configuration.php";
$msgFormErr="";

//Check what we have to do
$action=get_param("action");

if (!strlen($action))
	$action="none";
//Add or Remove Attendance Codes according to admin choice
switch ($action){
	case "remove":
		$attendance_codes_id=get_param("id");
		if($norem=$db->get_results("SELECT attendance_history_code FROM attendance_history WHERE attendance_history_code='".$attendance_codes_id."'")){
			$msgFormErr=_ADMIN_ATTENDANCE_CODES_FORM_ERROR;
		}else{
			$sSQL="DELETE FROM attendance_codes WHERE attendance_codes_id='".$attendance_codes_id."'";
			$db->query($sSQL);
		};
		break;
	case "add":
		$attendance_codes_desc=get_param("attendancename");
		//Check for duplicates
		$tot=$db->get_var("SELECT count(*) FROM attendance_codes WHERE attendance_codes_desc='$attendance_codes_desc'");
		if($tot>0){
			$msgFormErr=_ADMIN_ATTENDANCE_CODES_DUP;
		}else{
		$sSQL="INSERT INTO attendance_codes (attendance_codes_desc) VALUES (".tosql($attendance_codes_desc, "Text").")"; 
		$db->query($sSQL);
		};
		break;
	case "edit":
		$attendance_codes_id=get_param("id");
		$sSQL="SELECT attendance_codes_desc FROM attendance_codes WHERE attendance_codes_id='".$attendance_codes_id."'";
		$attendance_codes_desc = $db->get_var($sSQL);
		break;
	case "update":
		$attendance_codes_id=get_param("id");
		$attendance_codes_desc=get_param("attendancename");
		$sSQL="UPDATE attendance_codes SET attendance_codes_desc='$attendance_codes_desc' WHERE attendance_codes_id='".$attendance_codes_id."'";
		$db->query($sSQL);
		break;

};


//Set paging appearence
$ezr->results_open = "<table width=65% cellpadding=2 cellspacing=0 border=1>";
$ezr->results_close = "</table>";
$ezr->results_row = "<tr><td class=paging width=70%>COL2</td><td class=paging width=15% align=center><a href=admin_attendance_codes.php?action=edit&id=COL1 class=aform>&nbsp;" . _ADMIN_ATTENDANCE_CODES_EDIT . "</a></td><td class=paging width=15% align=center><a name=href_remove href=# onclick=cnfremove(COL1); class=aform>&nbsp;" . _ADMIN_ATTENDANCE_CODES_REMOVE . "</a></td></tr>";
$ezr->query_mysql("SELECT attendance_codes_id, attendance_codes_desc FROM attendance_codes ORDER BY attendance_codes_desc");
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<title><?echo _BROWSER_TITLE?></title>
<style type="text/css" media="all">@import "student-admin.css";</style>
<SCRIPT language="JavaScript">
/* Javascript function to submit form and check if field is empty */
function submitform(fldName)
{
  var f = document.forms[0];
  var t = f.elements[fldName]; 
  if (t.value!="") 
    f.submit();
  else
    alert("<?php echo _ENTER_VALUE?>");
}
/* Javascript function to ask confirmation before removing record */
function cnfremove(id) {
	var answer;	
	answer = window.confirm("<?php echo _ADMIN_ATTENDANCE_CODES_SURE?>");
	if (answer == 1) {
		var url;
		url = "admin_attendance_codes.php?action=remove&id=" + id;
		window.location = url; // other browsers
		href_remove.href = url; // explorer 
	}
	return false;
}

</SCRIPT>
<link rel="icon" href="favicon.ico" type="image/x-icon"><link rel="shortcut icon" href="favicon.ico" type="image/x-icon">

<script type="text/javascript" language="JavaScript" src="sms.js"></script>
</head>

<body><img src="images/<?php echo _LOGO?>" border="0">

<div id="Header">
<table width="100%">
  <tr>
    <td width="50%" align="left"><font size="2">&nbsp;&nbsp;<?php echo date(_DATE_FORMAT); ?></font></td>
    <td width="50%"><?php echo _ADMIN_ATTENDANCE_CODES_UPPER?></td>
  </tr>
</table>
</div>

<div id="Content">
	<h1><?php echo _ADMIN_ATTENDANCE_CODES_TITLE?></h1>
	<br>
	<?php
	if ($action!="edit"){
		//Dislay results with paging options
		$ezr->display();
		?>
		<br>
		<form name="addattendance" method="post" action="admin_attendance_codes.php">						
		  <p class="pform"><?php echo _ADMIN_ATTENDANCE_CODES_ADD_NEW?><br>
	      <input type="text" onChange="capitalizeMe(this)" name="attendancename" size="20">&nbsp;<A class="aform" href="javascript: submitform('attendancename')"><?php echo _ADMIN_ATTENDANCE_CODES_ADD?></a>
	      <input type="hidden" name="action" value="add">
	      </p>
	    </form>
	<?php
	}else{
	?>
		<br>
		<form name="editattendance" method="post" action="admin_attendance_codes.php">						
		  <p class="pform"><?php echo _ADMIN_ATTENDANCE_CODES_UPDATE_ATT?><br>
	      <input type="text" onChange="capitalizeMe(this)" name="attendancename" size="20" value="<?php echo $attendance_codes_desc; ?>">&nbsp;<A class="aform" href="javascript: submitform('attendancename')"><?php echo _ADMIN_ATTENDANCE_CODES_UPDATE?></a>
	      <input type="hidden" name="action" value="update">
		  <input type="hidden" name="id" value="<?php echo $attendance_codes_id; ?>">
	      </p>
	    </form>
	<?php
	};
	?>
	<h3><?php echo $msgFormErr; ?></h3>
</div>
<?php include "admin_maint_tables_menu.inc.php"; ?>
</body>

</html>