File: managegroups.php

Recommend this page to a friend!
  Classes of zinsou A.A.E.Mo´se  >  tinyUGatMs  >  managegroups.php  >  Download  
File: managegroups.php
Role: Auxiliary script
Content type: text/plain
Description: script for groups management panel
Class: tinyUGatMs
Manage users and groups of events in a database
Author: By
Last change:
Date: 2 years ago
Size: 12,656 bytes
 

Contents

Class file image Download
<?php
	session_start();
	require_once('config.php');
	if(isset($_SESSION['role'])&&$_SESSION['role']=="admin"){
		?>
		<!DOCTYPE>
			<html>
			<head>
				<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
				<title>MANAGE GROUP ACCESS TIME</title>	

			<style type="text/css">
				
				 #other {
					font-family: verdana;
					font-weight: bold;
					font-size: 14px;
					font-style:italic;
					color: #FFFFFF;
					background-color: grey;
					width: auto;
					margin-left: 15%;
					margin-right: 15%;
					padding:2%;
				}
				
				label
				{
					display: block ; 
					width: 150px;
					float : left ;
				}
				</style>
			
			</head>
		<body>
		<div id="other">
		<?php
		$_GET["action"]=(isset($_GET["action"]))?$_GET["action"]:false;
		switch ($_GET["action"]){
		case "add":
			 ?>
			<div>
			<form id="groups" method="POST">
			<fieldset><legend>Groups ADD</legend>
			<label for="name">name</label><input name="name" type="text" id="name" /><br>
			<label for="description">description</label><textarea name="description" ROWS="4" COLS="40" id="description" ></textarea><br>
			<label for="startaccesstime">startaccesstime</label><input name="startaccesstime" type="text" id="startaccesstime" /><br>
			<label for="endaccesstime">endaccesstime</label><input name="endaccesstime" type="text" id="endaccesstime"  /><br>
			<label for="datecreation">datecreation</label><input name="datecreation" type="text" id="datecreation" /><br>
			<?php
							$rang = array
							('dayly','weekly','monthly','quartely','yearly','once','custom'); 
							echo'<label for="recurrence">recurrence</label>';
							echo'<select name="recurrence" id="recurrence">';
							for($i=0;$i<7;$i++)
							{
								echo'<option value="'.$rang[$i].'">'.$rang[$i].'</option>';
							}
					echo'</select><br>';
			?>
			<label for="days">days</label><input name="days" type="text" id="days" /> <span style="font-size:12px;">use for custom recurrence only, example= friday,monday,saturday</span> <br >
			</p>
			</fieldset>
			<p><input type="submit" value="Submit" /></p>
			<div id="manage"></div></form></div>
			<div><p>What do you want to do ?
			<ul><li><a href="./managegroups.php?action=edit">Edit existing groups ?</a></li>
			<li><a href="./managegroups.php?action=add">Add a new group ?</a></li>
			<li><a href="./managegroups.php?action=delete">DELETE a  group ?</a></li>
			</ul>
			</p></div>
			<script language="JavaScript">	
				var manage=document.getElementById("manage");
				var select=document.getElementById("select");
				var groups=document.getElementById("groups");	
				var description=document.getElementById("description");
				var startaccesstime=document.getElementById("startaccesstime");
				var endaccesstime=document.getElementById("endaccesstime");
				var datecreation=document.getElementById("datecreation");
				var recurrence=document.getElementById("recurrence");
				var days=document.getElementById("days");
				
				
				function addEvent (element,event,func) {
					if (element.attachEvent){ 
						element.attachEvent ("on"+event,func) ; 
					}else{
						element.addEventListener(event,func,true) ;
					} 
				}	
				
				
				
				function group_create(){
					var name=document.getElementById("name");
					manage.innerHTML='<span style="color:blue;">submitting...Please wait...</span>';
					var xhr=new XMLHttpRequest;
					xhr.open("POST","./group_properties.php");
					xhr .setRequestHeader ( "Content-Type" ,"application/x-www-form-urlencoded" );
					xhr.onreadystatechange=function(){
						if(xhr.readyState==4&&xhr.status==200){
							var resp=xhr.responseText;
								manage.innerHTML=resp;
								if(resp=="Group successfully added"){
									manage.innerHTML +="<br> You will be redirected in 25 seconds";
									setInterval(window.location="./managegroups.php?action=edit",25000);
								}
							
						}	
					}
					xhr.send('add=true&name='+name.value+'&description='+description.value+'&recurrence='+recurrence.options[recurrence.selectedIndex ].innerHTML+'&datestart='+datecreation.value+'&startaccesstime='+startaccesstime.value+'&endaccesstime='+endaccesstime.value+'&days='+days.value);
				}
				
				addEvent(groups,"submit",function(e){									 
												e = e || window.event ;
												group_create();
												e.returnValue= false;
												if (e.preventDefault) {;
													e.preventDefault();
												}
											}													
				);
				
			</script>
			<?php 
			break;
			case "edit": ?>

			<form id="groups" method="POST">
			<fieldset><legend>Groups management</legend>
			<p><select id="select">
			<option value="none" >none</option>

			<?php

			$query=$bdd->query('SELECT name FROM groups');
			// $query->bindValue(':pseudo',$_POST['pseudo'],PDO::PARAM_STR);
			$query->execute();

			while($data=$query->fetch()){
			echo'<option value='.$data["name"].' id='.$data["name"].'>'.$data["name"].'</option>';
			}
			?></select></p><p>
			<!--<input type="submit" value="modify" />-->
			</p>
			</fieldset><fieldset id="propert"></fieldset></form><div id="manage" ></div>
			<div><p>What do you want to do ?
			<ul><li><a href="./managegroups.php?action=edit">Edit existing groups ?</a></li>
			<li><a href="./managegroups.php?action=add">Add a new group ?</a></li>
			<li><a href="./managegroups.php?action=delete">DELETE a  group ?</a></li>
			</ul>
			</p></div>
			<script language="JavaScript">	
				var manage=document.getElementById("manage");
				var select=document.getElementById("select");
				var groups=document.getElementById("groups");
				var propert=document.getElementById("propert");
				
				
				
				function addEvent (element,event,func) {
					if (element.attachEvent){ 
						element.attachEvent ("on"+event,func) ; 
					}else{
						element.addEventListener(event,func,true) ;
					} 
				}	
				
				
				function gproperties(){
					if(select.options[select.selectedIndex ].innerHTML!=="none"){
						manage.innerHTML='<span style="color:blue;">Loading...Please wait...</span>';
						var xhr=new XMLHttpRequest;
						xhr.open("GET","./ajaxgroups.php?group="+select.options[select.selectedIndex ].innerHTML );
						xhr.onreadystatechange=function(){
							if(xhr.readyState==4&&xhr.status==200){
							manage.innerHTML='';
								var resp=xhr.responseText;
									propert.innerHTML=resp;
								
							}	
						}
						xhr.send(null);
					}else{
						propert.innerHTML='This group doesn\'t exist so it doesn\'t  have any properties';
						manage.innerHTML='<span style="color:blue;">Choose another group to modify it</span>';
					}
				}
				
				addEvent(select,"change",function(e){									 
												e = e || window.event ;
												gproperties();
												e.returnValue= false;
												if (e.preventDefault) {
													e.preventDefault();
												}
											}													
				);
				
				function properties_update(){
					var name=document.getElementById("name");
					var description=document.getElementById("description");
					var startaccesstime=document.getElementById("startaccesstime");
					var endaccesstime=document.getElementById("endaccesstime");
					var datecreation=document.getElementById("datecreation");
					var recurrence=document.getElementById("recurrence");
					var days=document.getElementById("days");
					var oldname=document.getElementById("oldname");
					manage.innerHTML='<span style="color:blue;">Updating...Please wait...</span>';
					var xhr=new XMLHttpRequest;
					xhr.open("POST","./group_properties.php");
					xhr .setRequestHeader ( "Content-Type" ,"application/x-www-form-urlencoded" );
					xhr.onreadystatechange=function(){
						if(xhr.readyState==4&&xhr.status==200){
							var resp=xhr.responseText;
								manage.innerHTML=resp;
								if(resp=="Group successfully updated"){
									manage.innerHTML +="<br> You will be redirected in 25 seconds";
									setInterval(window.location="./managegroups.php?action=edit",25000);
								}
						}	
					}
					xhr.send('update=true&name='+name.value+'&description='+description.value+'&datestart='+datecreation.value+'&startaccesstime='+startaccesstime.value+'&endaccesstime='+endaccesstime.value+'&recurrence='+recurrence.options[recurrence.selectedIndex ].innerHTML+'&days='+days.value+'&oldname='+oldname.value);
				}
				
				addEvent(groups,"submit",function(e){									 
												e = e || window.event ;
												properties_update();
												e.returnValue= false;
												if (e.preventDefault) {
													e.preventDefault();
												}
											}													
				);
				
			</script>
			<?php
		break;
		case "delete":
			?>
			Delete a group will be definitive, think about it...!
			<form id="groups" method="POST">
			<fieldset><legend>Groups management</legend>
			<p><select id="select">
			<option value="none" ></option>

			<?php

			$query=$bdd->query('SELECT name FROM groups');
			// $query->bindValue(':pseudo',$_POST['pseudo'],PDO::PARAM_STR);
			$query->execute();

			while($data=$query->fetch()){
			echo'<option value='.$data["name"].' id='.$data["name"].'>'.$data["name"].'</option>';
			}
			?></select></p><p>
			<!--<input type="submit" value="modify" />-->
			</p>
			</fieldset><p id="propert"></p></form><div id="manage" ></div><div><p>What do you want to do ?
			<ul><li><a href="./managegroups.php?action=edit">Edit existing groups ?</a></li>
			<li><a href="./managegroups.php?action=add">Add a new group ?</a></li>
			<li><a href="./managegroups.php?action=delete">DELETE a  group ?</a></li>
			</ul>
			</p></div>
			<script language="JavaScript">	
				var manage=document.getElementById("manage");
				var select=document.getElementById("select");
				var groups=document.getElementById("groups");
				var propert=document.getElementById("propert");
				function addEvent (element,event,func) {
					if (element.attachEvent){ 
						element.attachEvent ("on"+event,func) ; 
					}else{
						element.addEventListener(event,func,true) ;
					} 
				}	
				
				
				function gproperties(){
					manage.innerHTML='<span style="color:blue;">Loading...Please wait...</span>';
					var xhr=new XMLHttpRequest;
					xhr.open("GET","./ajaxgroups.php?group="+select.options[select.selectedIndex ].innerHTML+"&delete=true"
					);
					xhr.onreadystatechange=function(){
						if(xhr.readyState==4&&xhr.status==200){
						manage.innerHTML='';
							var resp=xhr.responseText;
								propert.innerHTML=resp;
							
						}	
					}
					xhr.send(null);
				}
				
				addEvent(select,"change",function(e){									 
												e = e || window.event ;
												gproperties();
												e.returnValue= false;
												if (e.preventDefault) {
													e.preventDefault();
												}
											}													
				);
				
				function delete_group(){
					manage.innerHTML='<span style="color:blue;">Updating...Please wait...</span>';
					var xhr=new XMLHttpRequest;
					xhr.open("POST","./group_properties.php");
					xhr .setRequestHeader ( "Content-Type" ,"application/x-www-form-urlencoded" );
					xhr.onreadystatechange=function(){
						if(xhr.readyState==4&&xhr.status==200){
							var resp=xhr.responseText;
								manage.innerHTML=resp;
							if(resp=='Group deleted'){
								manage.innerHTML +="<br> You will be redirected in 25 seconds";
								setInterval(window.location="./managegroups.php?action=delete",25000);
							}
						}	
					}
					xhr.send('group='+select.options[select.selectedIndex ].innerHTML);
				}
				
				addEvent(groups,"submit",function(e){									 
												e = e || window.event ;
												delete_group();
												e.returnValue= false;
												if (e.preventDefault) {
													e.preventDefault();
												}
											}													
				);
				
			</script>
			<?php
			break;
		default:
			echo'<div><p>What do you want to do ?
			<ul><li><a href="./managegroups.php?action=edit">Edit existing groups ?</a></li>
			<li><a href="./managegroups.php?action=add">Add a new group ?</a></li>
			<li><a href="./managegroups.php?action=delete">DELETE a  group ?</a></li>
			</ul>
			</p></div>';
		break;
		}
	}else{
		$url="./connexion.php";
		echo '<script type="text/javascript">window.location="'.$url.'";</script>';
		exit;
	}
	?>
	</div>
	</body>
	</html>

For more information send a message to info at phpclasses dot org.