| |
sitengine:: admin.php
<? global $SE;include ('mySitengine.lib.php');
authentificationControler();
$SE['CATEGORY']='admin';
///////////////////////////////////
// Default sort parameters
///////////////////////////////////
$order='ORDER BY DATE ';$orderby='ASC';$linksAddOn = '';$APR='false';
///////////////////////////////////
// Code de gestion des différentes actions de la liste admin
///////////////////////////////////
if (isset($_REQUEST['action'])){
if (strtolower($_REQUEST['action']) == 'online') {
if ($_REQUEST["ID"] !='') {
$sql = "UPDATE `".$SE['SQLTable']."` SET `MD` = NOW() ,`STATE`='offline' WHERE `ID` = '".$_REQUEST['ID']."';";
$result = mysql_query($sql);
}
}
if (strtolower($_REQUEST['action']) == 'offline') {
if ($_REQUEST['ID'] !='') {
$sql = "UPDATE `".$SE['SQLTable']."` SET `MD` = NOW() ,`STATE`='online' WHERE `ID` = '".$_REQUEST['ID']."';";
$result = mysql_query($sql);
}
}
if ($_REQUEST['action'] == 'OWN') {
if ($_REQUEST['ID'] !='') {
$sql = "UPDATE `".$SE['SQLTable']."` SET `MD` = NOW() ,`RIGHT`='ALL' WHERE `ID` = '".$_REQUEST['ID']."';";
$result = mysql_query($sql);
}
}
if ($_REQUEST['action'] == 'GRP') {
if ($_REQUEST['ID'] !='') {
$sql = "UPDATE `".$SE['SQLTable']."` SET `MD` = NOW() ,`RIGHT`='OWN' WHERE `ID` = '".$_REQUEST['ID']."';";
$result = mysql_query($sql);
}
}
if ($_REQUEST['action'] == 'ALL') {
if ($_REQUEST['ID'] !='') {
$sql = "UPDATE `".$SE['SQLTable']."` SET `MD` = NOW() ,`RIGHT`='GRP' WHERE `ID` = '".$_REQUEST['ID']."';";
$result = mysql_query($sql);
}
}
if ($_REQUEST["action"] == 'delete') {
if ($_GET['APR'] == 'true'){
if ($_GET['ID'] !='') {
$sql = "DELETE FROM ".$SE['SQLTable']." WHERE ID='".$_REQUEST['ID']."';";
$result = mysql_query($sql);
}
} else {
$APR='true';
}
}
if ($_REQUEST['action'] == 'copy') {
$sql = "SELECT * FROM `".$SE['SQLTable']."` WHERE `ID` = '".$_REQUEST['ID']."';";
$original = mysql_query($sql);
$copy = mysql_fetch_row($original);
$i=0;
// Instancie a vide le champs autocremetiel du ID et a NOW les champs CD MD
$values="'',NOW(),NOW()";
$sql="INSERT INTO `".$SE['SQLTable']."` ( ";
while($i < mysql_num_fields($original)) {
$meta = mysql_fetch_field($original, $i);
$sql.= "`".$meta->name."`";
if ($i > 2){
// Ajoute la virgule
if ($i < mysql_num_fields($original)){$values.=",";}
// Insert les valeurs
$values.= "'".mysql_escape_string($copy[$i])."'";
}
//incremente le pointeur
$i++;
// Ajoute la virgule après chaque champs
if ($i < mysql_num_fields($original)){$sql.=",";}
}
$sql.= ") VALUES (".$values.");";
$result = mysql_query($sql);
}
}
///////////////////////////////////
// Code de gestion du triage de la liste
///////////////////////////////////
if (isset($_REQUEST['sort'])){
if ($_REQUEST['col'] == 'STATE'){
$order= 'ORDER BY `STATE` ';
} else if($_REQUEST['col'] == 'TITLE'){
$order= 'ORDER BY `TITLE` ';
} else if($_REQUEST['col'] == 'CATEGORY'){
$order= 'ORDER BY `CATEGORY` ';
} else if($_REQUEST['col'] == 'DATE'){
$order= 'ORDER BY `DATE` ';
} else if($_REQUEST['col'] == 'DATE'){
$order= 'ORDER BY `DATE` ';
} else if($_REQUEST['col'] == 'RIGHT'){
$order= 'ORDER BY `RIGHT` ';
}else if($_REQUEST['col'] == 'MD'){
$order= 'ORDER BY `MD` ';
}
$linksAddOn = 'sort=sort&col='.$_REQUEST['col'].'&orderby='.$_REQUEST['orderby'];
}
if (isset($_REQUEST['orderby'])){
if ($_REQUEST['orderby'] == 'ASC'){
$orderby= 'DESC';
} else {
$orderby= 'ASC';
}
}
///////////////////////////////////
// Parametres d'affichages des différentes zone d'informations
///////////////////////////////////
if ((isset($_REQUEST['VIEW']))&&(isset($_SESSION['sitengineAuth']))){
if ($_REQUEST['VIEW'] == 'ALL'){
$_SESSION['RIGHT']= 'GRP';
$SE['adm-permissions'] = "`RIGHT`='GRP' ";
} else if ($_REQUEST['VIEW'] == 'GRP'){
$_SESSION['RIGHT']= 'OWN';
$SE['adm-permissions'] = "`RIGHT`='OWN' ";
} else {
$_SESSION['RIGHT']= 'ALL';
$SE['adm-permissions'] = "`RIGHT`='ALL' ";
}
}
///////////////////////////////////
// Paramétres d'affichage des filtres de tri croisé
///////////////////////////////////
$and='';$filter='';$tilter='';$filters='';
if ((isset($_REQUEST['FILTER']))&&(isset($_SESSION['sitengineAuth']))){
if (!$_REQUEST['FILTER']){
$_SESSION['FILTER']= $SE['CONTENT']['cat1'];
} else if ($_REQUEST['FILTER'] == $SE['CONTENT']['cat1']){
$_SESSION['FILTER']= $SE['CONTENT']['cat2'];
} else if ($_REQUEST['FILTER'] == $SE['CONTENT']['cat2']){
$_SESSION['FILTER']= $SE['CONTENT']['cat3'];
} else if ($_REQUEST['FILTER'] == $SE['CONTENT']['cat3']){
$_SESSION['FILTER']= '';
} else {
$_SESSION['FILTER']= '';
}
}
if ( (isset ($_SESSION['FILTER'])) && (!empty($_SESSION['FILTER'])) ) $filter=" WHERE CATEGORY='".$_SESSION['FILTER']."' ";
if ((isset($_REQUEST['TILTER']))&&(isset($_SESSION['sitengineAuth']))){
if (!$_REQUEST['TILTER']){
$_SESSION['TILTER']= 'OWN';
} else if ($_REQUEST['TILTER'] == 'OWN'){
$_SESSION['TILTER']= 'GRP';
} else if ($_REQUEST['TILTER'] == 'GRP'){
$_SESSION['TILTER']= 'ALL';
} else if ($_REQUEST['TILTER'] == 'ALL'){
$_SESSION['TILTER']= '';
} else {
$_SESSION['TILTER']= '';
}
}
if (isset ($_SESSION['TILTER'])){
if (empty($_SESSION['TILTER'])){
$tilter='';$and='';
} else {
$tilter=" `RIGHT`='".$_SESSION['TILTER']."' ";$and=' AND ';$filters='WHERE ';
}
} else {
$tilter='';$and='';
}
if (isset ($_SESSION['FILTER'])){
if (empty($_SESSION['FILTER'])){
$filter='';$and='';
} else {
$filter=" CATEGORY='".$_SESSION['FILTER']."' ";$filters='WHERE ';
}
} else {
$filter='';$and='';
}
$where= $filters.$filter.$and.$tilter;
///////////////////////////////////
// Requete d'affichage de la liste
///////////////////////////////////
setPagination("SELECT ID FROM ".$SE['SQLTable']." ".$where." ".$order." ".$orderby,'list',20 );
$query="SELECT *, DATE_FORMAT(MD,'%d-%m-%Y %H:%i') AS dateFormatMD,DATE_FORMAT(DATE,'%d-%m-%Y') AS dateFormat FROM ".$SE['SQLTable']." ".$where." ".$order." ".$orderby." LIMIT ".$SE['RANK'].",".$SE['RANKSIZE'];
$result = mysql_query($query);
$cpt=$SE['RANK']+1;
///////////////////////////////////
// Template/code HTML
///////////////////////////////////
?><!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>
<? include ('head.inc.php');?>
</head>
<body class="body">
<? include ('header.inc.php');?>
<br/><br/>
<!-- ------------------------------------------------------------------------- -->
<!-- MAIN -->
<!-- ------------------------------------------------------------------------- -->
<table width="100%" cellpadding=2 cellspacing=0 border=0 >
<tr>
<td> </td>
<td></td>
<td> </td>
<td><a href="<? echo $SE['SELF'];?>?sort=sort&col=ID&orderby=<? echo $orderby;?>"><span class="nav">ID</span></a></td>
<td> </td>
<td><a href="<? echo $SE['SELF'];?>?sort=sort&col=MD&orderby=<? echo $orderby;?>"><span class="nav">MD</span></a></td>
<td> </td>
<td></td>
<td> </td>
<td></td>
<td> </td>
<td></td>
<td> </td>
<td></td>
<td> </td>
<td><a href="<? echo $SE['SELF'];?>?sort=sort&col=STATE&orderby=<? echo $orderby;?>"><span class="nav">state</span></a></td>
<td> </td>
<td><a href="<? echo $SE['SELF'];?>?TILTER=<? if (isset($_SESSION['TILTER'])) echo $_SESSION['TILTER'];?>&orderby=<? echo $orderby;?>"><span class="nav"><? if ((isset($_SESSION['TILTER'])) && (!empty($_SESSION['TILTER']))) {echo $SE['CONTENT'][$_SESSION['TILTER']];} else {echo 'right';}?></span></a></td>
<td> </td>
<td><a href="<? echo $SE['SELF'];?>?FILTER=<? if (isset($_SESSION['FILTER'])) echo $_SESSION['FILTER'];?>&orderby=<? echo $orderby;?>"><span class="nav"><? if ((isset($_SESSION['FILTER'])) && (!empty($_SESSION['FILTER']))) {echo $_SESSION['FILTER'];} else {echo 'category';}?></span></a></td>
<td> </td>
<td><a href="<? echo $SE['SELF'];?>?sort=sort&col=DATE&orderby=<? echo $orderby;?>"><span class="nav">date</span></a></td>
<td> </td>
<td><a href="<? echo $SE['SELF'];?>?sort=sort&col=TITLE&orderby=<? echo $orderby;?>"><span class="nav">title</span></a></td>
<td> </td>
</tr>
<?
while($row = mysql_fetch_object($result)) {
$confirm='false';$class='text';
if ((isset($_GET['ID']))&&($_GET['action']=='delete')){
if (($APR==true) && ($_GET['ID']==$row->ID)){
$confirm='true';$class='nav';
}
} ?>
<!-- ------------------------------------------------------------------------- -->
<!-- CONTENT -->
<!-- ------------------------------------------------------------------------- -->
<tr class="<? echo (($cpt % 2) == 0) ? 'coloredLine' : '';?>">
<td> </td>
<td><span class="text"><b><? echo $cpt++;?></b></span></td>
<td> </td>
<td><a href="form.php?action=UPDATE&ID=<? echo $row->ID;?>"><span class="text"><?echo $row->ID;?></span></a></td>
<td> </td>
<td><span class="date"><? echo $row->dateFormatMD;?></span></td>
<td> </td>
<td><a href="<? echo $SE['SELF'];?>?action=delete&ID=<? echo $row->ID;?>&APR=<? echo $confirm;?>&<? echo $linksAddOn;?>"><span class="<? echo $class;?>">del</span></a></td>
<td> </td>
<td><a href="<? echo $SE['SELF'];?>?action=copy&ID=<? echo $row->ID;?>&<? echo $linksAddOn;?>"><span class="text">copy</span></a></td>
<td> </td>
<td><a href="form.php?CAT=<? echo $row->CATEGORY;?>&DATE=<? echo urlencode($row->dateFormat);?>"><span class="text">add</span></a></td>
<td> </td>
<td><a href="form.php?action=UPDATE&ID=<? echo $row->ID;?>"><span class="text">edit</span></a></td>
<td> </td>
<td><a href="<? echo $SE['SELF'];?>?ID=<? echo $row->ID;?>&action=<? echo $row->STATE;?>&<? echo $linksAddOn;?>"><span class="text"><?echo $row->STATE;?></span></a></td>
<td> </td>
<td><a href="<? echo $SE['SELF'];?>?ID=<? echo $row->ID;?>&action=<? echo $row->RIGHT;?>&<? echo $linksAddOn;?>"><span class="text"><? echo $SE['CONTENT'][$row->RIGHT];?></span></a></td>
<td> </td>
<td><span class="text"><? echo $row->CATEGORY;?></span></td>
<td> </td>
<td><span class="date"><? echo $row->dateFormat;?></span></td>
<td> </td>
<td><? if ($row->CATEGORY == 'ressources'){ ?><a href="form.php?action=UPDATE&ID=<? echo $row->ID;?>"><span class="text"><? echo $row->TITLE;?> <? echo $row->nom;?> <? echo $row->prenom;?></span></a><? } else {?><a href="form.php?action=UPDATE&ID=<? echo $row->ID;?>"><span class="text"><? echo $row->TITLE;?></span></a><? }?></td>
<td> </td>
</tr><!-- /CONTENT -->
<? } ?>
<tr>
<td> </td>
<td colspan="25" align="right"><? echo getPagination();?></td>
<td> </td>
</tr>
</table><!-- /MAIN -->
</body>
</html>
<? sitengineInfo();?>
<!--DOCUMENT CREATED BY FREESTYLE TECHNOLOGIES - zarg69@graz.li-->
1
|