Bonjour,
J'utilise votre application depuis 2 ans et j'en suis super satisfait.
Mais je souhaiterais ci cela et possible d'avoir le champ type dans le dasboard comme le champ lieux si on l'active dans l'administration - paramètres.
Cordialement,
Mailleurs vœux 2016
Ajouter colone type dans le dasboard
Bonjour.
Tout dépend si vous voulez filtrer par le champ "type" ou non.
Si cela vous intéresse, je peux vous fournir le code que j'ai réalisé pour ajouter le champ "Description". Mais je n'ai pas modifié le code pour pouvoir filtrer les TT dessus.
Si vous voulez rajouter une filtre cela demande plus de modification du fichier dashboard.php (mais rien d'infaisable).
Tout dépend si vous voulez filtrer par le champ "type" ou non.
Si cela vous intéresse, je peux vous fournir le code que j'ai réalisé pour ajouter le champ "Description". Mais je n'ai pas modifié le code pour pouvoir filtrer les TT dessus.
Si vous voulez rajouter une filtre cela demande plus de modification du fichier dashboard.php (mais rien d'infaisable).
GestSup 3.1.7 - Fedora 21 - Firefox/Chrome/IE - PHP 5.6 - MySQL 5.5 - Apache 2.4
Bonjour.
J'ai modifié dashboard.php pour essayer de répondre à votre besoin.
Voici le code complet de dashboard.php modifié.
PS : je ne l'ai pas testé car je teste moi même d'autre morceau de code sur ma version de test. S'il y a un problème, alors, je prendrai le temps de la tester.
J'ai modifié dashboard.php pour essayer de répondre à votre besoin.
Voici le code complet de dashboard.php modifié.
Code : Tout sélectionner
<?php
################################################################################
# @Name : dashboard.php
# @Desc : Display tickets list
# @Author : Flox
# @Create : 17/07/2009
# @Update : 5/02/2016 by Sam
# @Version : 3.0.11
################################################################################
//initialize variables
if(!isset($asc)) $asc = '';
if(!isset($img)) $img= '';
if(!isset($date)) $date= '';
if(!isset($from)) $from='';
if(!isset($filter)) $filter='';
if(!isset($col)) $col='';
if(!isset($view)) $view='';
if(!isset($nkeyword)) $nkeyword='';
if(!isset($rowlastname)) $rowlastname='';
if(!isset($resultcriticality['color'])) $resultcriticality['color']= '';
if(!isset($displayusername)) $displayusername= '';
if(!isset($displaytechname)) $displaytechname= '';
if(!isset($u_group)) $u_group= '';
if(!isset($t_group)) $t_group= '';
if(!isset($techread)) $techread= '';
if(!isset($_GET['technician'])) $_GET['technician']= '';
if(!isset($_GET['u_group'])) $_GET['u_group']= '';
if(!isset($_GET['t_group'])) $_GET['t_group']= '';
if(!isset($_GET['type'])) $_GET['type']= '';
if(!isset($_GET['category'])) $_GET['category']= '';
if(!isset($_GET['subcat'])) $_GET['subcat']= '';
if(!isset($_GET['lieu'])) $_GET['lieu']= '';
if(!isset($_GET['cursor'])) $_GET['cursor']= '';
if(!isset($_GET['searchengine'])) $_GET['searchengine'] = '';
if(!isset($_GET['date_create'])) $_GET['date_create'] = '';
if(!isset($_GET['user'])) $_GET['user'] = '';
if(!isset($_GET['date'])) $_GET['date'] = '';
if(!isset($_GET['state'])) $_GET['state'] = '';
if(!isset($_GET['priority'])) $_GET['priority'] = '';
if(!isset($_GET['title'])) $_GET['title'] = '';
if(!isset($_GET['criticality'])) $_GET['criticality'] = '';
if(!isset($_GET['way'])) $_GET['way'] = '';
if(!isset($_GET['order'])) $_GET['order'] = '';
if(!isset($_GET['techread'])) $_GET['techread'] = '';
//get value is for filter case
if(!isset($_POST['date'])) $_POST['date']= '';
if(!isset($_POST['selectrow'])) $_POST['selectrow']= '';
if(!isset($_POST['technician'])) $_POST['technician']= $_GET['technician'];
if(!isset($_POST['title'])) $_POST['title']= $_GET['title'];
if(!isset($_POST['ticket'])) $_POST['ticket']= '';
if(!isset($_POST['userid'])) $_POST['userid']= '';
if(!isset($_POST['user'])) $_POST['user']= $_GET['user'];
if(!isset($_POST['type'])) $_POST['type']= $_GET['type'];
if(!isset($_POST['category'])) $_POST['category']= $_GET['category'];
if(!isset($_POST['subcat'])) $_POST['subcat']= $_GET['subcat'];
if(!isset($_POST['lieu'])) $_POST['lieu']= $_GET['lieu'];
if(!isset($_POST['fstate']) || $_GET['state']!='') $_POST['fstate']= $_GET['state'];
if(!isset($_POST['priority'])) $_POST['priority']=$_GET['priority'];
if(!isset($_POST['criticality'])) $_POST['criticality']=$_GET['criticality'];
if(!isset($_POST['u_group'])) $_POST['u_group']=$_GET['u_group'];
if(!isset($_POST['t_group'])) $_POST['t_group']=$_GET['t_group'];
//escape special char to sql query
$_POST['title']=mysql_real_escape_string($_POST['title']);
//default values
if ($techread=='') $techread='%';
if ($state=='')$state='%';
if($_GET['type']=='') $_GET['type']= '%';
if($_GET['category']=='') $_GET['category']= '%';
if($_GET['t_group']=='') $_GET['t_group']= '%';
if($_GET['u_group']=='') $_GET['u_group']= '%';
if($_GET['subcat']=='') $_GET['subcat']= '%';
if($_GET['lieu']=='') $_GET['lieu']= '%';
if($_GET['cursor']=='') $_GET['cursor']='0';
if($_GET['techread']=='') $_GET['techread']='%';
if($_POST['criticality']=='') $_POST['criticality']= '%';
if($_POST['priority']=='') $_POST['priority']='%';
if($_POST['fstate']=='' ) {$_POST['fstate']='%'; }
//default values check user profil parameters
//if admin user
if($_SESSION['profile_id']==0 || $_SESSION['profile_id']==4)
{
if($_POST['technician']=='') $_POST['technician']= $_GET['userid'];
if($_POST['user']=='') $_POST['user']= '%';
} else {
if($_POST['user']=='') $_POST['user']= $_GET['userid'];
if($_POST['technician']=='') $_POST['technician']= '%';
}
//convert post date to sql query
if($_POST['date']=='')
{
if ($_GET['date_create']=='current')
{
$_POST['date']=date("Y-m-d") ;
} else {
$_POST['date']= '%';
}
}
if($_POST['title']=='') $_POST['title']= '%';
if($_POST['ticket']=='') $_POST['ticket']= '%';
if($_POST['userid']=='') $_POST['userid']= '%';
if($_POST['type']=='') $_POST['type']= '%';
if($_POST['category']=='') $_POST['category']= '%';
if($_POST['subcat']=='') $_POST['subcat']= '%';
if($_POST['lieu']=='') $_POST['lieu']= '%';
//tech and techgroup separate
if(substr($_POST['technician'], 0, 1) =='G')
{
$t_group = explode("_", $_POST['technician']);
$t_group=$t_group[1];
$_GET['t_group']=$t_group;
$_POST['technician']='%';
}
//user and usergroup separate
if(substr($_POST['user'], 0, 1) =='G')
{
$u_group = explode("_", $_POST['user']);
$u_group=$u_group[1];
$_GET['u_group']=$u_group;
$_POST['user']='%';
}
//select order
if ($filter=='on' || $_GET['order']==''){
if($ruser['dashboard_ticket_order']) {$_GET['order']=$ruser['dashboard_ticket_order'];} else {$_GET['order']=$rparameters['order'];}
}
elseif ($_GET['order']=='') $_GET['order']='priority';
//meta state generation
if($_GET['state']=='meta')
{
$state="AND (tincidents.state LIKE 1 OR tincidents.state LIKE 2 OR tincidents.state LIKE 6)";
//change order in this case
if ($_GET['order']=='tstates.number, tincidents.priority, tincidents.criticality, tincidents.date_create') {$_GET['order']='tincidents.priority, tincidents.criticality, tincidents.date_create';}
if ($_GET['order']=='tstates.number, tincidents.priority, tincidents.criticality, tincidents.date_hope') {$_GET['order']='tincidents.priority, tincidents.criticality, tincidents.date_hope';}
if ($_GET['order']=='tstates.number, tincidents.date_hope, tincidents.priority, tincidents.criticality') {$_GET['order']='tincidents.date_hope, tincidents.priority, tincidents.criticality';}
if ($_GET['order']=='tstates.number, tincidents.date_hope, tincidents.criticality, tincidents.priority') {$_GET['order']='tincidents.date_hope, tincidents.criticality, tincidents.priority';}
if ($_GET['order']=='tstates.number, tincidents.criticality, tincidents.date_hope, tincidents.priority') {$_GET['order']='tincidents.criticality, tincidents.date_hope, tincidents.priority';}
} else {
$state='AND tincidents.state LIKE \''.$_POST['fstate'].'\'';
}
//echo $_GET['order'];
///// SQL QUERY
//Date conversion for filter line
if ($_POST['date']!='%')
{
$date=$_POST['date'];
$find='/';
$find= strpos($date, $find);
if ($find!=false)
{
$date=explode("/",$date);
$_POST['date']="$date[2]-$date[1]-$date[0]";
}
}
if ($keywords)
{
include "./searchengine.php";
} else {
$from="
FROM tincidents, tstates";
if($rparameters['ticket_places']==1){
$from.= ", tplaces ";
}
$from.="
WHERE
tincidents.state=tstates.id";
if($rparameters['ticket_places']==1){
$from.= " AND tincidents.place=tplaces.id
AND tplaces.id LIKE '$_POST[lieu]'";
}
$from.="
AND tincidents.user LIKE '$_POST[user]'
AND tincidents.u_group LIKE '$_GET[u_group]'
AND tincidents.technician LIKE '$_POST[technician]'
AND tincidents.t_group LIKE '$_GET[t_group]'
AND tincidents.techread LIKE '$_GET[techread]'
AND tincidents.disable='0'
AND (tincidents.type LIKE '$_POST[type]')
AND (tincidents.category LIKE '$_POST[category]')
AND tincidents.subcat LIKE '$_POST[subcat]'
AND tincidents.id LIKE '$_POST[ticket]'
AND tincidents.user LIKE '$_POST[userid]'
AND tincidents.date_create LIKE '$_POST[date]%'
$state
AND tincidents.priority LIKE '$_POST[priority]'
AND tincidents.criticality LIKE '$_POST[criticality]'
AND tincidents.title LIKE '%$_POST[title]%'
";
}
$mastercount = mysql_query("SELECT COUNT(DISTINCT tincidents.id) $from") or die (mysql_error());
$resultcount=mysql_fetch_array($mastercount);
$addSelect ="";
if($rparameters['ticket_places']==1){
$addSelect = ", tplaces.name";
}
$masterquery = mysql_query("
SELECT DISTINCT tincidents.* ".$addSelect."
$from
ORDER BY $_GET[order] $_GET[way]
LIMIT $_GET[cursor],
$rparameters[maxline]
");
if ($rparameters['debug']==1)
{
echo "
SELECT DISTINCT tincidents.*<br />
$from<br />
ORDER BY $_GET[order] $_GET[way]<br />
LIMIT $_GET[cursor],
$rparameters[maxline]<br />
";
}
//checkbox selection
if($_POST['selectrow'])
{
while ($row=mysql_fetch_array($masterquery))
{
//initialize variables
if(!isset($_POST['checkbox'.$row["id"]])) $_POST['checkbox'.$row["id"]] = '';
if ($_POST['checkbox'.$row['id']]!='')
{
//disable ticket
if($_POST['selectrow']=="delete")
{
$query = "UPDATE tincidents SET disable='1' WHERE id LIKE '$row[id]'";
$exec = mysql_query($query) or die('Erreur SQL !<br /><br />'.mysql_error());
echo '<div class="alert alert-block alert-success"><i class="icon-remove"></i> Ticket '.$row['id'].' supprimé.</div>';
}
//move ticket in unattrib state
if($_POST['selectrow']=="unattrib")
{
$query = "UPDATE tincidents SET state='5' WHERE id LIKE '$row[id]'";
$exec = mysql_query($query) or die('Erreur SQL !<br /><br />'.mysql_error());;
echo '<div class="alert alert-block alert-success"><i class="icon-ok green"></i> Ticket '.$row['id'].' marqué en non attribué.</div>';
}
//move ticket in pec state
if($_POST['selectrow']=="pec")
{
$query = "UPDATE tincidents SET state='1' WHERE id LIKE '$row[id]'";
$exec = mysql_query($query) or die('Erreur SQL !<br /><br />'.mysql_error());
echo '<div class="alert alert-block alert-success"><i class="icon-ok green"></i> Ticket '.$row['id'].' marqué en attente de prise en charge.</div>';
}
//move ticket in current state
if($_POST['selectrow']=="current")
{
$query = "UPDATE tincidents SET state='2' WHERE id LIKE '$row[id]'";
$exec = mysql_query($query) or die('Erreur SQL !<br /><br />'.mysql_error());
echo '<div class="alert alert-block alert-success"><i class="icon-ok green"></i> Ticket '.$row['id'].' marqué en cours.</div>';
}
//move ticket in return state
if($_POST['selectrow']=="return")
{
$query = "UPDATE tincidents SET state='6' WHERE id LIKE '$row[id]'";
$exec = mysql_query($query) or die('Erreur SQL !<br /><br />'.mysql_error());
echo '<div class="alert alert-block alert-success"><i class="icon-ok green"></i> Ticket '.$row['id'].' marqué en attente de retour.</div>';
}
//move ticket in resolv state
if($_POST['selectrow']=="resolv")
{
$query = "UPDATE tincidents SET state='3' WHERE id LIKE '$row[id]'";
$exec = mysql_query($query) or die('Erreur SQL !<br /><br />'.mysql_error());
echo '<div class="alert alert-block alert-success"><i class="icon-ok green"></i> Ticket '.$row['id'].' marqué en résolu.</div>';
}
}
}
//redirect
echo "<SCRIPT LANGUAGE='JavaScript'>
<!--
function redirect()
{
window.location='./index.php?page=dashboard&state=$_GET[state]&userid=$_GET[userid]'
}
setTimeout('redirect()',$rparameters[time_display_msg]);
-->
</SCRIPT>";
}
?>
<div class="page-header position-relative">
<h1>
<?php
if ($keywords)
{
echo '<i class="icon-search"></i> Recherche: '.$keywords.' ';
}
else
{
//find state name for display in title
$qstate = mysql_query("SELECT * FROM tstates WHERE id='$_GET[state]'");
$rstate=mysql_fetch_array($qstate);
if (!$rstate && !$_GET['viewid']) $rstate['description']='tickets non lus'; //case not read
if ($_GET['state']=='meta') $rstate['description']='tickets à traiter'; //case not read
//find view name to display in title
if ($_GET['viewid'])
{
$qview = mysql_query("SELECT name FROM tviews WHERE id='$_GET[viewid]'");
$rview=mysql_fetch_array($qview);
$rstate['description']='tickets de la vue '.$rview['name'].'';
}
if($_GET['userid']=='%')
{
if ($_GET['state']=='%') {echo '<i class="icon-ticket"></i> Tous les tickets';} else {echo '<i class="icon-ticket"></i> Tous les '.$rstate['description'].'';}
}
else if ($_GET['userid']!='0')
{
if ($_GET['state']=='%') {echo '<i class="icon-ticket"></i> Tous vos tickets';} else {echo '<i class="icon-ticket"></i> Vos '.$rstate['description'].'';}
}
if($_GET['state']=='%' && $_GET['userid']==0 && $_GET['userid']!='%') echo '<i class="icon-ticket"></i> Tous les tickets non attribués';; //case not read
if($_GET['date_create']=='current') echo ' du jour'; //case for today link is selected
}
?>
<small>
<i class="icon-double-angle-right"></i>
Nombre: <?php echo $resultcount[0]; ?></i>
</small>
</h1>
</div>
<?php
//display message if search result is null
if($resultcount[0]==0 && $keywords!="") echo '<div class="alert alert-danger"><i class="icon-remove"></i> Aucun ticket trouvé pour la recherche: <strong>'.$keywords.'</strong></div>';
?>
<div class="row">
<div class="col-xs-12">
<div class="table-responsive">
<table id="sample-table-1" class="table table-striped table-bordered table-hover">
<?php
//*********************** FIRST LIGN ***********************
if($_GET['way']=='ASC') $arrow_way='DESC'; else $arrow_way='ASC';
//build page url link
$url="./index.php?page=dashboard&
userid=$_GET[userid]&
user=$_POST[user]&
u_group=$_GET[u_group]&
t_group=$_GET[t_group]&
technician=$_POST[technician]&
keywords=$keywords&
viewid=$_GET[viewid]&
title=$_POST[title]&
type=$_POST[type]&
category=$_POST[category]&
subcat=$_POST[subcat]&
date=$_POST[date]&
state=$_POST[fstate]&
date_create=$_GET[date_create]&
priority=$_POST[priority]&
criticality=$_POST[criticality]
";
echo "
<thead>
<tr >
<th "; if ($_GET['order']=='id') echo 'class="active"'; echo ">
<center>
<a title=\"Numéro du ticket\" href=\"$url&order=id&way=$arrow_way\">
<i class=\"icon-tag\"></i><br />
Numéro";
//Display way arrows
if ($_GET['order']=='id'){
if ($_GET['way']=='ASC') {echo ' <i class="icon-sort-up"></i>';}
if ($_GET['way']=='DESC') {echo ' <i class="icon-sort-down"></i>';}
}
echo "
</a>
</center>
</th>
";
// do not diplay TECH column if technician is connected
if ($_SESSION['profile_id']!=0 || $_SESSION['profile_id']!=4 || $_GET['userid']=='%')
{
echo "
<th "; if ($_GET['order']=='technician') echo 'class="active"'; echo ">
<center>
<a title=\"Technicien en charge du ticket\" href=\"$url&order=technician&way=$arrow_way\">
<i class=\"icon-user\"></i><br />
Technicien";
//Display arrows
if ($_GET['order']=='technician'){
if ($_GET['way']=='ASC') {echo ' <i class="icon-sort-up"></i>';}
if ($_GET['way']=='DESC') {echo ' <i class="icon-sort-down"></i>';}
}
echo"
</a>
</center>
</th>
";
}
if (($_SESSION['profile_id']==0 || $_SESSION['profile_id']==3 || $_SESSION['profile_id']==4) || ($rright['side_all']!=0 && ($_GET['userid']=='%'|| $keywords!='')))
{
echo "
<th "; if ($_GET['order']=='user') echo 'class="active"'; echo ">
<center>
<a title=\"Demandeur\" href=\"$url&order=user&way=$arrow_way\">
<i class=\"icon-male\"></i><br />
Demandeur";
//Display arrows
if ($_GET['order']=='user'){
if ($_GET['way']=='ASC') {echo ' <i class="icon-sort-up"></i>';}
if ($_GET['way']=='DESC') {echo ' <i class="icon-sort-down"></i>';}
}
echo"
</a>
</center>
</th>
";
}
?>
<th <?php if ($_GET['order']=='type') echo 'class="active"'; ?> >
<center>
<a title="Type" href="<?php echo $url; ?>&order=type&way=<?php echo $arrow_way; ?>">
<i class="icon-sign-blank"></i><br />
Type
<?php
//Display arrows
if ($_GET['order']=='type'){
if ($_GET['way']=='ASC') {echo ' <i class="icon-sort-up"></i>';}
if ($_GET['way']=='DESC') {echo ' <i class="icon-sort-down"></i>';}
}
?>
</a>
</center>
</th>
<th <?php if ($_GET['order']=='category') echo 'class="active"'; ?> >
<center>
<a title="Catégorie" href="<?php echo $url; ?>&order=category&way=<?php echo $arrow_way; ?>">
<i class="icon-sign-blank"></i><br />
Catégorie
<?php
//Display arrows
if ($_GET['order']=='category'){
if ($_GET['way']=='ASC') {echo ' <i class="icon-sort-up"></i>';}
if ($_GET['way']=='DESC') {echo ' <i class="icon-sort-down"></i>';}
}
?>
</a>
</center>
</th>
<th <?php if ($_GET['order']=='subcat') echo 'class="active"'; ?> >
<center>
<a title="Sous-Catégorie" href="<?php echo $url; ?>&order=subcat&way=<?php echo $arrow_way; ?>">
<i class="icon-sitemap"></i>
Sous Catégorie
<?php
//Display arrows
if ($_GET['order']=='subcat'){
if ($_GET['way']=='ASC') {echo ' <i class="icon-sort-up"></i>';}
if ($_GET['way']=='DESC') {echo ' <i class="icon-sort-down"></i>';}
}
?>
</a>
</center>
</th>
<?php if($rparameters['ticket_places']==1){ ?>
<th <?php if ($_GET['order']=='name') echo 'class="active"'; ?> >
<center>
<a title="Lieu" href="<?php echo $url; ?>&order=name&way=<?php echo $arrow_way; ?>">
<i class="icon-building"></i>
Lieu
<?php
//Display arrows
if ($_GET['order']=='name'){
if ($_GET['way']=='ASC') {echo ' <i class="icon-sort-up"></i>';}
if ($_GET['way']=='DESC') {echo ' <i class="icon-sort-down"></i>';}
}
?>
</a>
</center>
</th>
<?php } ?>
<th <?php if ($_GET['order']=='description') echo 'class="active"'; ?> >
<center>
<a title="Titre de la demande" href="<?php echo $url; ?>&order=description&way=<?php echo $arrow_way; ?>">
<i class="icon-file-text-alt"></i>
Titre
<?php
//Display arrows
if ($_GET['order']=='description'){
if ($_GET['way']=='ASC') {echo ' <i class="icon-sort-up"></i>';}
if ($_GET['way']=='DESC') {echo ' <i class="icon-sort-down"></i>';}
}
?>
</a>
</center>
</th>
<th <?php if ($_GET['order']==$rparameters['dash_date']) echo 'class="active"'; ?> >
<?php
if($rparameters['dash_date']=="date_create") {$date_title='Date de création du ticket';}
if($rparameters['dash_date']=="date_hope") {$date_title='Date de résolution estimé';}
?>
<center>
<a title="<?php echo $date_title; ?>" href="<?php echo $url; ?>&order=<?php echo $rparameters['dash_date']; ?>&way=<?php echo $arrow_way; ?>">
<i class="icon-calendar"></i><br />
Date
<?php
//Display arrows
if ($_GET['order']==$rparameters['dash_date']){
if ($_GET['way']=='ASC') {echo ' <i class="icon-sort-up"></i>';}
if ($_GET['way']=='DESC') {echo ' <i class="icon-sort-down"></i>';}
}
?>
</a>
</center>
</th>
<th <?php if ($_GET['order']=='state') echo 'class="active"'; ?> >
<center>
<a title="État" href="<?php echo $url; ?>&order=state&way=<?php echo $arrow_way; ?>">
<i class="icon-adjust"></i><br />
État
<?php
//Display arrows
if ($_GET['order']=='state'){
if ($_GET['way']=='ASC') {echo ' <i class="icon-sort-up"></i>';}
if ($_GET['way']=='DESC') {echo ' <i class="icon-sort-down"></i>';}
}
?>
</a>
</center>
</th>
<th <?php if ($_GET['order']=='priority') echo 'class="active"'; ?> >
<center>
<a title="Priorité 0=Urgent et 5=Très basse" href="<?php echo $url; ?>&order=priority&way=<?php echo $arrow_way; ?>">
<i class="icon-sort-by-attributes"></i>
Priorité
<?php
//Display arrows
if ($_GET['order']=='priority'){
if ($_GET['way']=='ASC') {echo ' <i class="icon-sort-up"></i>';}
if ($_GET['way']=='DESC') {echo ' <i class="icon-sort-down"></i>';}
}
?>
</a>
</center>
</th>
<th <?php if ($_GET['order']=='criticality') echo 'class="active"'; ?> >
<center>
<a title="Criticité" href="<?php echo $url; ?>&order=criticality&way=<?php echo $arrow_way; ?>">
<i class="icon-bullhorn"></i>
Criticité
<?php
//Display arrows
if ($_GET['order']=='criticality'){
if ($_GET['way']=='ASC') {echo ' <i class="icon-sort-up"></i>';}
if ($_GET['way']=='DESC') {echo ' <i class="icon-sort-down"></i>';}
}
?>
</a>
</center>
</th>
</tr>
<?php // *********************************** FILTER LIGN ************************************** ?>
<form name="filter" method="POST">
<tr>
<td>
<center>
<input name="ticket" onchange="submit();" type="text" size="7" value="<?php if ($_POST['ticket']!='%')echo $_POST['ticket']; ?>" />
</center>
</td>
<?php
//Display tech column if all demands view is selected
if ($_SESSION['profile_id']!=0 || $_SESSION['profile_id']!=4 || $_GET['userid']=='%')
{
echo '
<td align="center" >
<select style="width:81px" name="technician" onchange="submit()" >
<option value="%"></option>';
//tech
$query = mysql_query("SELECT * FROM tusers WHERE (profile='0' or profile='4') and disable='0' ORDER BY lastname");
while ($row=mysql_fetch_array($query))
{
$cutfname=substr($row['firstname'], 0, 1);
if ($_POST['technician']==$row['id']) echo "<option selected value=\"$row[id]\">$cutfname. $row[lastname]</option>"; else echo "<option value=\"$row[id]\">$cutfname. $row[lastname]</option>";
}
//tech group
$query = mysql_query("SELECT * FROM tgroups WHERE disable='0' AND type='1' ORDER BY name");
while ($row=mysql_fetch_array($query))
{
if ($t_group==$row['id'] || $_GET['t_group']==$row['id']) echo "<option selected value=\"G_$row[id]\">$row[name]</option>"; else echo "<option value=\"G_$row[id]\">$row[name]</option>";
}
echo "
</select>
</td>";
}
if (($_SESSION['profile_id']==0 || $_SESSION['profile_id']==3 || $_SESSION['profile_id']==4) || ($rright['side_all']!=0 && ($_GET['userid']=='%'|| $keywords!='')))
{
echo '
<td align="center" >
<select style="width:92px" name="user" onchange="submit()">
<option value="%"></option>';
//user list
$query = mysql_query("SELECT * FROM tusers WHERE disable='0' ORDER BY lastname");
while ($row=mysql_fetch_array($query))
{
$cutfname=substr($row['firstname'], 0, 1);
if ($_POST['user']==$row['id']) echo "<option selected value=\"$row[id]\">$cutfname. $row[lastname]</option>"; else echo "<option value=\"$row[id]\">$row[lastname] $cutfname. </option>";
}
//user group list
$query = mysql_query("SELECT * FROM tgroups WHERE disable='0' AND type='0' ORDER BY name");
while ($row=mysql_fetch_array($query))
{
if ($u_group==$row['id'] || $_GET['u_group']==$row['id']) echo "<option selected value=\"G_$row[id]\">$row[name]</option>"; else echo "<option value=\"G_$row[id]\">[G] $row[name]</option>";
}
echo '
</select>
</td>';
}
?>
<td align="center">
<select style="width:65px" name="type" onchange="submit()" >
<option value="%"></option>
<?php
$query = mysql_query("SELECT * FROM ttypes ORDER BY name");
while ($row=mysql_fetch_array($query))
{
if ($_POST['type']==$row['id']) echo "<option selected value=\"$row[id]\">$row[name]</option>"; else echo "<option value=\"$row[id]\">$row[name]</option>";
}
?>
</select>
</td>
<td align="center">
<select style="width:65px" name="category" onchange="submit()" >
<option value="%"></option>
<?php
$query = mysql_query("SELECT * FROM tcategory ORDER BY name");
while ($row=mysql_fetch_array($query))
{
if ($_POST['category']==$row['id']) echo "<option selected value=\"$row[id]\">$row[name]</option>"; else echo "<option value=\"$row[id]\">$row[name]</option>";
}
?>
</select>
</td>
<td align="center">
<select style="width:60px" name="subcat" onchange="submit()">
<option value="%"></option>
<?php
if($_POST['category']!='%')
{$query = mysql_query("SELECT * FROM tsubcat WHERE cat LIKE $_POST[category] ORDER BY name");}
else
{$query = mysql_query("SELECT * FROM tsubcat ORDER BY name");}
while ($row=mysql_fetch_array($query))
{
if ($_POST['subcat']==$row['id']) echo "<option selected value=\"$row[id]\">$row[name]</option>"; else echo "<option value=\"$row[id]\">$row[name]</option>";
}
?>
</select>
</td>
<?php if($rparameters['ticket_places']==1){ ?>
<td align="center">
<select style="width:65px" name="lieu" onchange="submit()" >
<option value="%"></option>
<?php
$query = mysql_query("SELECT * FROM tplaces ORDER BY name");
while ($row=mysql_fetch_array($query))
{
if ($_POST['lieu']==$row['id']) echo "<option selected value=\"$row[id]\">$row[name]</option>"; else echo "<option value=\"$row[id]\">$row[name]</option>";
}
?>
</select>
</td>
<?php } ?>
<td>
<input name="title" size="24" onchange="submit();" type="text" value="<?php if ($_POST['title']!='%')echo $_POST['title']; ?>" />
</td>
<td>
<input name="date" size="4" onchange="submit();" type="text" value="<?php if ($_POST['date']!='%')echo $_POST['date']; ?>" />
</td>
<td align="center">
<select style="width:50px" id="fstate" name="fstate" onchange="submit()" >
<option value=""></option>
<?php
$query = mysql_query("SELECT * FROM tstates ORDER BY name");
while ($row=mysql_fetch_array($query)) {echo "<option value=\"$row[id]\">$row[name]</option>";}
?>
</select>
</td>
<td align="center">
<select style="width:45px" id="priority" name="priority" onchange="submit()">
<option value=""></option>
<?php
$query = mysql_query("SELECT * FROM tpriority ORDER BY number");
while ($row=mysql_fetch_array($query)){echo "<option value=\"$row[number]\">$row[name]</option>";}
?>
</select>
</td>
<td align="center">
<select style="width:50px" id="criticality" name="criticality" onchange="submit()">
<option value=""></option>
<?php
$query = mysql_query("SELECT * FROM tcriticality ORDER BY number");
while ($row=mysql_fetch_array($query))
{
echo "<option value=\"$row[id]\">$row[name]</option>";
}
?>
</select>
</td>
</tr>
<input name="state" type="hidden" value="<?php echo $_GET['state']; ?>" />
<input name="filter" type="hidden" value="on" />
</form>
</thead>
<tbody>
<form name="actionlist" method="POST">
<?php
while ($row=mysql_fetch_array($masterquery))
{
//Select name of states
$querystate=mysql_query("SELECT * FROM tstates WHERE id LIKE $row[state]");
$resultstate=mysql_fetch_array($querystate);
//Select name of priority
$querypriority=mysql_query("SELECT * FROM tpriority WHERE id LIKE $row[priority]");
$resultpriority=mysql_fetch_array($querypriority);
//Select name of criticality
$querycriticality=mysql_query("SELECT * FROM tcriticality WHERE id LIKE $row[criticality]");
$resultcriticality=mysql_fetch_array($querycriticality);
//Select name of user
$queryuser=mysql_query("SELECT * FROM tusers WHERE id LIKE '$row[user]'");
$resultuser=mysql_fetch_array($queryuser);
//Select name of usergroup
$queryusergroup=mysql_query("SELECT * FROM tgroups WHERE id LIKE '$row[u_group]'");
$resultusergroup=mysql_fetch_array($queryusergroup);
//Select name of technician
$querytech=mysql_query("SELECT * FROM tusers WHERE id LIKE '$row[technician]'");
$resulttech=mysql_fetch_array($querytech);
//Select name of techniciangroup
$querytechgroup=mysql_query("SELECT * FROM tgroups WHERE id LIKE '$row[t_group]'");
$resulttechgroup=mysql_fetch_array($querytechgroup);
//Select name of type
$querycat=mysql_query("SELECT * FROM ttypes WHERE id LIKE '$row[type]'");
$resultcat=mysql_fetch_array($querycat);
//Select name of category
$querycat=mysql_query("SELECT * FROM tcategory WHERE id LIKE '$row[category]'");
$resultcat=mysql_fetch_array($querycat);
//Select name of subcategory
$queryscat=mysql_query("SELECT * FROM tsubcat WHERE id LIKE '$row[subcat]'");
$resultscat=mysql_fetch_array($queryscat);
if($rparameters['ticket_places']==1) {$nameLieu = $row["name"];}
//cut first letter of firstame
$Fname=substr($resultuser['firstname'], 0, 1);
$Ftname=substr($resulttech['firstname'], 0, 1);
//display username or groupname
if ($resultusergroup[0]!=0) {$displayusername="[G] $resultusergroup[name]";} else {$displayusername="$Fname. $resultuser[lastname]" ;}
if ($resulttechgroup[0]!=0) {$displaytechname="[G] $resulttechgroup[name]";} else {$displaytechname="$Ftname. $resulttech[lastname]" ;}
$rowdate= date_cnv($row[$rparameters['dash_date']]);
//date hope
$img='';
if(!isset($row['date_hope'])) $row['date_hope']= '';
$date_hope=$row['date_hope'];
$querydiff=mysql_query("SELECT DATEDIFF(NOW(), '$date_hope') ");
$resultdiff=mysql_fetch_array($querydiff);
if ($resultdiff[0]>0) $img = '<i title="'.$resultdiff[0].' jours de retard" class="icon-time red"></i>';
// Display line color
$bgcolor="";
/* too long to execute temp remove
//query 30 days
$query15=mysql_query("SELECT count(*) FROM `tincidents` WHERE TO_DAYS(NOW()) - TO_DAYS(date_create) >= $rparameters[lign_yellow] and TO_DAYS(NOW()) - TO_DAYS(date_create) <= 45 and (state LIKE '2' or state LIKE '1') and date_create LIKE '$row[date_create]'");
$result15=mysql_fetch_array($query15);
if ($result15[0]!=0 && ($row['state'] == '1' || $row['state'] == '2')) {$bgcolor="label-yellow"; $comment="Ticket crée il y à plus de $rparameters[lign_yellow] jours";}
//query 45 days and more
$query15=mysql_query("SELECT count(*) FROM `tincidents` WHERE TO_DAYS(NOW()) - TO_DAYS(date_create) > $rparameters[lign_orange] and (state LIKE '2' or state LIKE '1') and date_create LIKE '$row[date_create]'");
$result15=mysql_fetch_array($query15);
if ($result15[0]!=0 && ($row['state'] == '1' || $row['state'] == '2')) {$bgcolor="label-important"; $comment="Ticket crée il y à plus de $rparameters[lign_orange] jours";}
*/
//query date is today display green
if (date('Y-m-d')==date('Y-m-d',strtotime($row['date_create']))) {$bgcolor="label-success"; $comment="Ticket crée ce jour";}
//if techncian unread
if ($row['techread']==0) {$bgcolor="label-info"; $comment="Ticket non lu par le technicien en charge";}
// default bg color
if ($bgcolor=="") {$bgcolor=""; $comment="";}
//if title is too long cut
$title=$row['title'];
//attach file
$attach='';
if(!isset($row['img1'])) $row['img1']= '';
if($row['img1']!='') $attach= "<i title=\"$row[img1]\" class=\"icon-paper-clip\"></i> ";
echo "
<tr>
<td>
<center>
";if ($rright['task_checkbox']!=0) echo "<input style=\"float:left;\" type=\"checkbox\" name=\"checkbox$row[id]\" value=\"$row[id]\"/>"; echo"
 <a href=\"./index.php?page=ticket&id=$row[id]&state=$_GET[state]&userid=$_GET[userid]&type=$_GET[type]&category=$_GET[category]&subcat=$_GET[subcat]&viewid=$_GET[viewid]\"><span title=\"$comment\" class=\"label $bgcolor\">$row[id]</span></a>
$img
</center>
</td>
";
if ($_SESSION['profile_id']!=0 || $_SESSION['profile_id']!=4 || $_GET['userid']=='%')
{
echo "<td onclick=\"document.location='./index.php?page=ticket&id=$row[id]&state=$_GET[state]&userid=$_GET[userid]&type=$_GET[type]&category=$_GET[category]&subcat=$_GET[subcat]&viewid=$_GET[viewid]'\" ><center><a class=\"td\" href=\"./index.php?page=ticket&id=$row[id]&state=$_GET[state]&userid=$_GET[userid]&type=$_GET[type]&category=$_GET[category]&subcat=$_GET[subcat]&viewid=$_GET[viewid]\">$displaytechname</a></center></td>";
}
if (($_SESSION['profile_id']==0 || $_SESSION['profile_id']==3 || $_SESSION['profile_id']==4) || ($rright['side_all']!=0 && ($_GET['userid']=='%'|| $keywords!='')))
{
echo "<td onclick=\"document.location='./index.php?page=ticket&id=$row[id]&state=$_GET[state]&userid=$_GET[userid]&type=$_GET[type]&category=$_GET[category]&subcat=$_GET[subcat]&viewid=$_GET[viewid]'\"><a class=\"td\" title=\"Tel: $resultuser[phone] \" href=\"./index.php?page=ticket&id=$row[id]&state=$_GET[state]&userid=$_GET[userid]&type=$_GET[type]&category=$_GET[category]&subcat=$_GET[subcat]&viewid=$_GET[viewid]\">$displayusername</a></td>";
}
echo "
<td onclick=\"document.location='./index.php?page=ticket&id=$row[id]&state=$_GET[state]&userid=$_GET[userid]'\">
<a class=\"td\" href=\"./index.php?page=ticket&id=$row[id]&state=$_GET[state]&userid=$_GET[userid]&type=$_GET[type]&category=$_GET[category]&subcat=$_GET[subcat]&viewid=$_GET[viewid]\">$resultcat[name]</a>
</td>
<td onclick=\"document.location='./index.php?page=ticket&id=$row[id]&state=$_GET[state]&userid=$_GET[userid]&type=$_GET[type]&category=$_GET[category]&subcat=$_GET[subcat]&viewid=$_GET[viewid]'\">
<a class=\"td\" href=\"./index.php?page=ticket&id=$row[id]&state=$_GET[state]&userid=$_GET[userid]&type=$_GET[type]&category=$_GET[category]&subcat=$_GET[subcat]&viewid=$_GET[viewid]\">$resultscat[name]</a>
</td>
";
if($rparameters['ticket_places']==1){
echo "<td onclick=\"document.location='./index.php?page=ticket&id=$row[id]&state=$_GET[state]&userid=$_GET[userid]&type=$_GET[type]&category=$_GET[category]&subcat=$_GET[subcat]&viewid=$_GET[viewid]'\">
<a class=\"td\" href=\"./index.php?page=ticket&id=$row[id]&state=$_GET[state]&userid=$_GET[userid]&type=$_GET[type]&category=$_GET[category]&subcat=$_GET[subcat]&viewid=$_GET[viewid]\">$nameLieu</a>
</td>";
}
echo "<td onclick=\"document.location='./index.php?page=ticket&id=$row[id]&state=$_GET[state]&userid=$_GET[userid]&type=$_GET[type]&category=$_GET[category]&subcat=$_GET[subcat]&viewid=$_GET[viewid]'\">
<a class=\"td\" title=\"$row[title] \" href=\"./index.php?page=ticket&id=$row[id]&state=$_GET[state]&userid=$_GET[userid]&type=$_GET[type]&category=$_GET[category]&subcat=$_GET[subcat]&viewid=$_GET[viewid]\">$title $attach</a>
</td>
<td onclick=\"document.location='./index.php?page=ticket&id=$row[id]&state=$_GET[state]&userid=$_GET[userid]&type=$_GET[type]&category=$_GET[category]&subcat=$_GET[subcat]&viewid=$_GET[viewid]'\">
<a class=\"td\" href=\"./index.php?page=ticket&id=$row[id]&state=$_GET[state]&userid=$_GET[userid]&type=$_GET[type]&category=$_GET[category]&subcat=$_GET[subcat]&viewid=$_GET[viewid]\">$rowdate</a>
</td>
<td onclick=\"document.location='./index.php?page=ticket&id=$row[id]&state=$_GET[state]&userid=$_GET[userid]&type=$_GET[type]&category=$_GET[category]&subcat=$_GET[subcat]&viewid=$_GET[viewid]'\">
<a class=\"td\" href=\"./index.php?page=ticket&id=$row[id]&state=$_GET[state]&userid=$_GET[userid]&type=$_GET[type]&category=$_GET[category]&subcat=$_GET[subcat]&viewid=$_GET[viewid]\"> <span class=\"$resultstate[display]\" title=\"$resultstate[description]\"> <font size=\"1\">$resultstate[name]</font></span></a>
</td>
<td onclick=\"document.location='./index.php?page=ticket&id=$row[id]&state=$_GET[state]&userid=$_GET[userid]&type=$_GET[type]&category=$_GET[category]&subcat=$_GET[subcat]&viewid=$_GET[viewid]'\">
<center><a title=\"Priorité $resultpriority[name]\" class=\"td\" href=\"./index.php?page=ticket&id=$row[id]&state=$_GET[state]&userid=$_GET[userid]&type=$_GET[type]&category=$_GET[category]&subcat=$_GET[subcat]&viewid=$_GET[viewid]\" > <i title=\"$resultpriority[name]\" class=\"icon-warning-sign bigger-130\" style=\"color:$resultpriority[color]\"></i></a></center>
</td>
<td onclick=\"document.location='./index.php?page=ticket&id=$row[id]&state=$_GET[state]&userid=$_GET[userid]&type=$_GET[type]&category=$_GET[category]&subcat=$_GET[subcat]&viewid=$_GET[viewid]'\">
<a title=\"Criticité $resultcriticality[name]\" class=\"td\" href=\"./index.php?page=ticket&id=$row[id]&state=$_GET[state]&userid=$_GET[userid]&type=$_GET[type]&category=$_GET[category]&subcat=$_GET[subcat]&viewid=$_GET[viewid]\" > <center><i title=\"$resultcriticality[name]\" class=\"icon-bullhorn bigger-130\" style=\"color:$resultcriticality[color]\" ></i></a></center>
</td>
</tr>
";
}
?>
</tbody>
</table>
</div>
</div>
</div>
<?php
//display multicheck options
if ($rright['task_checkbox']!=0 && $resultcount[0]>0)
{
echo '
<i class="icon-level-down icon-rotate-180 icon-2x"></i>   
<select title="Effectue des actions pour les tickets selectionnés dans la liste des tâches." name="selectrow" onchange="submit()">
<option selected>Pour la selection:</option>';
if ($rright['ticket_delete']!=0){
echo '<option value="delete">Supprimer</option>';
}
echo '<option value="unattrib">Marquer comme Non attribué</option>
<option value="pec">Marquer comme Attente de PEC</option>
<option value="current">Marquer comme En cours</option>
<option value="return">Marquer comme En attente de retour</option>
<option value="resolv">Marquer comme Résolu</option>
</select>
';
}
echo "</form>"; //end form for task_checkbox
//Multi-pages link
if ($resultcount[0]>$rparameters['maxline'])
{
//count number of page
$pagenum=ceil($resultcount[0]/$rparameters['maxline']);
echo '
<center>
<ul class="pagination">';
for ($i = 1; $i <= $pagenum; $i++) {
if ($i==1) $cursor=0;
$selectcursor=$rparameters['maxline']*($i-1);
if ($_GET['cursor']==$selectcursor)
{
$active='class="active"';
} else $active='';
if($_GET['searchengine']==1)
{echo "<li > <a href=\"$url&order=$_GET[order]&way=$_GET[way]&cursor=$cursor\"> $i </a></li> ";}
else
{echo "<li $active><a href=\"$url&order=$_GET[order]&way=$_GET[way]&cursor=$cursor\"> $i </a></li> ";}
$cursor=$i*$rparameters['maxline'];
}
echo '
</ul>
</center>
';
}
//////////////////////////////////////functions
//date conversion
function date_cnv ($date)
{return substr($date,8,2) . "/" . substr($date,5,2) . "/" . substr($date,0,4);}
//play notify sound for tech and admin in new ticket case
if ($rparameters['notify']==1 && ($_SESSION['profile_id']==4 || $_SESSION['profile_id']==0))
{
$query=mysql_query("SELECT id FROM `tincidents` WHERE technician='0' and t_group='0' and techread='0' and disable='0' and notify='0'");
$row=mysql_fetch_array($query);
if ($row[0]!=0) {
echo'<audio hidden="false" autoplay="true" src="./sounds/notify.ogg" controls="controls"></audio>';
$query = "UPDATE tincidents SET notify='1' WHERE id='$row[0]'";
$exec = mysql_query($query) or die('Erreur SQL !<br /><br />'.mysql_error());
}
}
?>PS : je ne l'ai pas testé car je teste moi même d'autre morceau de code sur ma version de test. S'il y a un problème, alors, je prendrai le temps de la tester.
GestSup 3.1.7 - Fedora 21 - Firefox/Chrome/IE - PHP 5.6 - MySQL 5.5 - Apache 2.4
Bonjour,
Je suis aussi très intéressé par cette fonctionnalité, mais cette version 3.0.11 de dashboard.php me retourne une erreur:
Merci,
François.
Je suis aussi très intéressé par cette fonctionnalité, mais cette version 3.0.11 de dashboard.php me retourne une erreur:
J'utilise Gestsup 3.1.7 / Ubuntu 15.10.Access denied for user 'www-data'@'localhost' (using password: NO)
Merci,
François.