PHP Classes

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: 6 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>