Voici mes modifs du dashboard pour pouvoir modifier en lot les tickets:
j'ai ajouté des cases a cocher sur la liste des tickets ainsi qu'un menu déroulant pour changer le statut d'un seul coup de plusieurs tickets.
En pratique, on selectionne les tickets puis on selectionne en bas de liste le statut souhaité.
lignes modifiées (souvent encadrées par //#############vincent ):
- lignes 12 -> 25
- Ajout cellule 166->168 et 304 -> 305
-lignes 410 -> 412
- ajout de la case : 487
- menu select : 533 ->544
dashboard.php:
Code : Tout sélectionner
<?php
/*
Author: Flox
File Name: dashboard.php
Call: index_auth.php
Description: Display list of tasks
Version: 2.5
Creation date: 17/07/2009
last update: 25/12/2012
*/
//#############Vincent
foreach($_POST['select_piece'] as $cle => $value)
{
$change_status= $_POST['change_status'];
$id_ticket = $_POST['select_piece'][$cle];
echo"$id_ticket -> $change_status | ";
//Update ticket
$query = "UPDATE tincidents SET
state='$change_status'
WHERE
id LIKE '$id_ticket'";
$exec = mysql_query($query) or die('Erreur SQL !<br /><br />'.mysql_error());
}
//#################fin vincent
// 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($keywords)) $keywords='';
if(!isset($nkeyword)) $nkeyword='';
if(!isset($rowlastname)) $rowlastname='';
if(!isset($resultcriticality['color'])) $resultcriticality['color']= '';
if(!isset($_GET['category'])) $_GET['category']= '';
if(!isset($_GET['subcat'])) $_GET['subcat']= '';
if(!isset($_GET['order'])) $_GET['order'] = '';
if(!isset($_GET['cursor'])) $_GET['cursor']= '';
if(!isset($_GET['way'])) $_GET['way'] = '';
if(!isset($_GET['searchengine'])) $_GET['searchengine'] = '';
if(!isset($_GET['date_create'])) $_GET['date_create'] = '';
if(!isset($_POST['criticality'])) $_POST['criticality'] = '';
if(!isset($_POST['priority'])) $_POST['priority']= '';
if(!isset($_POST['date'])) $_POST['date']= '';
if(!isset($_POST['fstate'])) $_POST['fstate']= '';
if(!isset($_POST['title'])) $_POST['title']= '';
if(!isset($_POST['ticket'])) $_POST['ticket']= '';
if(!isset($_POST['technician'])) $_POST['technician']= '';
if(!isset($_POST['userid'])) $_POST['userid']= '';
if(!isset($_POST['category'])) $_POST['category']= '';
if(!isset($_POST['subcat'])) $_POST['subcat']= '';
//compatibility between personal view and filter on category
if($_GET['category']!='') $_POST['category']= $_GET['category'];
if($_GET['subcat']!='') $_POST['subcat']= $_GET['subcat'];
// default values
if ($techread=='') $techread='%';
if ($state=='')$state='%';
if($_GET['category']=='') $_GET['category']= '%';
if($_GET['subcat']=='') $_GET['subcat']= '%';
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']= '%';
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['technician']=='') $_POST['technician']= '%';
if($_POST['userid']=='') $_POST['userid']= '%';
if($_POST['category']=='') $_POST['category']= '%';
if($_POST['subcat']=='') $_POST['subcat']= '%';
// asc or desc
if ($_GET['way']==''){$_GET['way']='ASC';} else if ($_GET['way']=='ASC') {$_GET['way']='DESC';} else if ($_GET['way']=='DESC') {$_GET['way']='ASC';}
if ($_GET['techid']=='')$_GET['techid']='$_SESSION[user_id]';
// select auto order
if ($filter=='on' || ($_GET['state']=='%' && $_GET['order']=='')){$_GET['order']='state';}
elseif ($_GET['order']=='') $_GET['order']='priority';
///// SQL QUERY
//conversion username to userid for filter line
if ($_POST['userid']!='%')
{
$query=mysql_query("SELECT id FROM tusers WHERE firstname LIKE '%$_POST[userid]%' or lastname LIKE '%$_POST[userid]%' LIMIT 1");
$row=mysql_fetch_array($query);
$_POST['userid']=$row[0];
}
//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]";
}
}
/*
// FOR NEXT DEV BUG ORDER BY subcat PB when empty case
INNER JOIN tcategory ON tincidents.category=tcategory.id
INNER JOIN tsubcat ON tincidents.subcat=tsubcat.id
INNER JOIN tusers ON tincidents.user=tusers.id
*/
//
if ($_GET['searchengine']=='1')
{
include "./searchengine.php";
} else {
$from="
FROM tincidents
WHERE
tincidents.$profile LIKE '$_GET[techid]'
AND tincidents.technician LIKE '$_POST[technician]'
AND tincidents.state LIKE '$_GET[state]'
AND tincidents.techread LIKE '$_GET[techread]'
AND tincidents.disable='0'
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]'
AND tincidents.state LIKE '$_POST[fstate]'
AND tincidents.priority LIKE '$_POST[priority]'
AND tincidents.criticality LIKE '$_POST[criticality]'
AND tincidents.title LIKE '%$_POST[title]%'
";
}
$mastercount = mysql_query("SELECT COUNT(*) $from");
$resultcount=mysql_fetch_array($mastercount);
$masterquery = mysql_query("
SELECT tincidents.*
$from
ORDER BY
$_GET[order] $_GET[way],
date_create DESC LIMIT $_GET[cursor],
$rparameters[maxline]
");
?>
<div class="post">
<h2>
<?php if ($_GET['searchengine']=='1') echo "Recherche: $keywords[0] "; else echo "Liste des demandes";?>
<span class="description">Nombre: <?php echo $resultcount[0] ?></span>
</h2>
<table cellspacing="0" cellpadding="0" >
<?php //*********************** FIRST LIGN *********************** ?>
<tr class="list">
<th scope="col" <?php if ($_GET['order']=='id') echo 'class="active"'; ?> >
</th>
<th scope="col" <?php if ($_GET['order']=='id') echo 'class="active"'; ?> >
<a title="Numéro du ticket" class="th" href="./index.php?page=dashboard&techid=<?php echo $_GET['techid']; ?>&state=<?php echo $_GET['state']; ?>&order=id&way=<?php echo $_GET['way']; ?>">
Ticket
<?php
//Display way arrows
if ($_GET['order']=='id'){
if ($_GET['way']=='ASC') {echo '<img style="border-style: none" alt="img" src="./images/up.png" />';}
if ($_GET['way']=='DESC') {echo '<img style="border-style: none" alt="img" src="./images/down.png" />';}
}
?>
</a>
</th>
<?php
// do not diplay TECH column if technician is connected
if ($_SESSION['profile_id']!=0 || $_SESSION['profile_id']!=4 || $_GET['techid']=='%')
{
echo "
<th scope=\"col\" "; if ($_GET['order']=='technician') echo 'class="active"'; echo ">
<a title=\"Technicien en charge du ticket\" class=\"th\" href=\"./index.php?page=dashboard&techid=$_GET[techid]&state=$_GET[state]&order=technician&way=$_GET[way]\">
TECH";
//Display arrows
if ($_GET['order']=='technician'){
if ($_GET['way']=='ASC') {echo '<img style="border-style: none" alt="img" src="./images/up.png" />';}
if ($_GET['way']=='DESC') {echo '<img style="border-style: none" alt="img" src="./images/down.png" />';}
}
echo"
</a>
</th>
";
}
if ($_SESSION['profile_id']==0 || $_SESSION['profile_id']==3 || $_SESSION['profile_id']==4) {
echo "
<th scope=\"col\""; if ($_GET['order']=='user') echo 'class="active"'; echo ">
<a title=\"Demandeur\" class=\"th\" href=\"./index.php?page=dashboard&techid=$_GET[techid]&state=$_GET[state]&order=user&way=$_GET[way]\">
Demandeur";
//Display arrows
if ($_GET['order']=='user'){
if ($_GET['way']=='ASC') {echo '<img style="border-style: none" alt="img" src="./images/up.png" />';}
if ($_GET['way']=='DESC') {echo '<img style="border-style: none" alt="img" src="./images/down.png" />';}
}
echo"
</a>
</th>
";
}
?>
<th scope="col" <?php if ($_GET['order']=='category') echo 'class="active"'; ?> >
<a title="Catégorie" class="th" href="./index.php?page=dashboard&techid=<?php echo $_GET['techid']; ?>&state=<?php echo $_GET['state']; ?>&order=category&way=<?php echo $_GET['way']; ?>">
Catégorie
<?php
//Display arrows
if ($_GET['order']=='category'){
if ($_GET['way']=='ASC') {echo '<img style="border-style: none" alt="img" src="./images/up.png" />';}
if ($_GET['way']=='DESC') {echo '<img style="border-style: none" alt="img" src="./images/down.png" />';}
}
?>
</a>
</th>
<th scope="col" <?php if ($_GET['order']=='subcat') echo 'class="active"'; ?> >
<a title="Sous-Catégorie" class="th" href="./index.php?page=dashboard&techid=<?php echo $_GET['techid']; ?>&state=<?php echo $_GET['state']; ?>&order=subcat&way=<?php echo $_GET['way']; ?>">
S-Catégorie
<?php
//Display arrows
if ($_GET['order']=='subcat'){
if ($_GET['way']=='ASC') {echo '<img style="border-style: none" alt="img" src="./images/up.png" />';}
if ($_GET['way']=='DESC') {echo '<img style="border-style: none" alt="img" src="./images/down.png" />';}
}
?>
</a>
</th>
<th scope="col" <?php if ($_GET['order']=='description') echo 'class="active"'; ?> >
<a title="Titre de la demande" class="th" href="./index.php?page=dashboard&techid=<?php echo $_GET['techid']; ?>&state=<?php echo $_GET['state']; ?>&order=description&way=<?php echo $_GET['way']; ?>">
Titre
<?php
//Display arrows
if ($_GET['order']=='description'){
if ($_GET['way']=='ASC') {echo '<img style="border-style: none" alt="img" src="./images/up.png" />';}
if ($_GET['way']=='DESC') {echo '<img style="border-style: none" alt="img" src="./images/down.png" />';}
}
?>
</a>
</th>
<th scope="col" <?php if ($_GET['order']=='date_create') echo 'class="active"'; ?> >
<a title="Date de création la demande" class="th" href="./index.php?page=dashboard&techid=<?php echo $_GET['techid']; ?>&state=<?php echo $_GET['state']; ?>&order=date_create&way=<?php echo $_GET['way']; ?>">
Date
<?php
//Display arrows
if ($_GET['order']=='date_create'){
if ($_GET['way']=='ASC') {echo '<img style="border-style: none" alt="img" src="./images/up.png" />';}
if ($_GET['way']=='DESC') {echo '<img style="border-style: none" alt="img" src="./images/down.png" />';}
}
?>
</a>
</th>
<th scope="col" <?php if ($_GET['order']=='state') echo 'class="active"'; ?> >
<a title="État" class="th" href="./index.php?page=dashboard&techid=<?php echo $_GET['techid']; ?>&state=<?php echo $_GET['state']; ?>&order=state&way=<?php echo $_GET['way']; ?>">
E
<?php
//Display arrows
if ($_GET['order']=='state'){
if ($_GET['way']=='ASC') {echo '<img style="border-style: none" alt="img" src="./images/up.png" />';}
if ($_GET['way']=='DESC') {echo '<img style="border-style: none" alt="img" src="./images/down.png" />';}
}
?>
</a>
</th>
<th scope="col" <?php if ($_GET['order']=='priority') echo 'class="active"'; ?> >
<a title="Priorité 0=Urgent et 5=Très basse" class="th" href="./index.php?page=dashboard&techid=<?php echo $_GET['techid']; ?>&state=<?php echo $_GET['state']; ?>&order=priority&way=<?php echo $_GET['way']; ?>">
P
<?php
//Display arrows
if ($_GET['order']=='priority'){
if ($_GET['way']=='ASC') {echo '<img style="border-style: none" alt="img" src="./images/up.png" />';}
if ($_GET['way']=='DESC') {echo '<img style="border-style: none" alt="img" src="./images/down.png" />';}
}
?>
</a>
</th>
<th scope="col" <?php if ($_GET['order']=='criticality') echo 'class="active"'; ?> >
<a title="Criticité" class="th" href="./index.php?page=dashboard&techid=<?php echo $_GET['techid']; ?>&state=<?php echo $_GET['state']; ?>&order=criticality&way=<?php echo $_GET['way']; ?>">
C
<?php
//Display arrows
if ($_GET['order']=='criticality'){
if ($_GET['way']=='ASC') {echo '<img style="border-style: none" alt="img" src="./images/up.png" />';}
if ($_GET['way']=='DESC') {echo '<img style="border-style: none" alt="img" src="./images/down.png" />';}
}
?>
</a>
</th>
</tr>
<?php // *********************************** FILTER LIGN ************************************** ?>
<form name="filter" method="post">
<tr class="green">
<td>
</td>
<td>
<input name="ticket" onchange="submit();" type="text" size="6" value="<?php if ($_POST['ticket']!='%')echo $_POST['ticket']; ?>" />
</td>
<?php
//Display tech column if all demands view is selected
if ($_SESSION['profile_id']!=0 || $_SESSION['profile_id']!=4 || $_GET['techid']=='%')
{
echo '
<td>
<select name="technician" onchange="submit()" style="width:69px">
<option value="%"> </option>';
$query = mysql_query("SELECT * FROM tusers WHERE profile='0' and disable='0'");
while ($row=mysql_fetch_array($query))
{
echo "<option value=\"$row[id]\">$row[firstname]</option>";
if ($_POST['technician']==$row['id']) echo "<option selected value=\"$row[id]\">$row[firstname]</option>";
}
echo "
</select>
</td>";
}
if ($_SESSION['profile_id']==0 || $_SESSION['profile_id']==3 || $_SESSION['profile_id']==4) {
echo "
<td>";
//find username
if ($filter=="on") {
$query=mysql_query("SELECT * FROM tusers WHERE id LIKE '$_POST[userid]'");
$row=mysql_fetch_array($query);
} echo '
<input name="userid" onchange="submit();" type="text" size="11\" value="'; if ($filter=="on" && $_POST['userid']!='%') {echo $row['lastname'];} echo '" />
</td>';
}
?>
<td>
<select name="category" onchange="submit()" style="width:83px">
<option value="%"></option>
<?php
$query = mysql_query("SELECT * FROM tcategory ORDER BY name");
while ($row=mysql_fetch_array($query))
{
echo "<option value=\"$row[id]\">$row[name]</option>";
if ($_POST['category']==$row['id']) echo "<option selected value=\"$row[id]\">$row[name]</option>";
}
?>
</select>
</td>
<td>
<select name="subcat" onchange="submit()" style="width:80px">
<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))
{
echo "<option value=\"$row[id]\">$row[name]</option>";
if ($_POST['subcat']==$row['id']) echo "<option selected value=\"$row[id]\">$row[name]</option>";
}
?>
</select>
</td>
<td>
<input name="title" onchange="submit();" type="text" value="<?php if ($_POST['title']!='%')echo $_POST['title']; ?>" />
</td>
<td>
<input name="date" onchange="submit();" type="text" size="8" value="<?php if ($_POST['date']!='%')echo $_POST['date']; ?>" />
</td>
<td>
<select name="fstate" onchange="submit()" style="width:22px" >
<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>
<select id="priority" name="priority" onchange="submit()" style="width:23px">
<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>
<select id="criticality" name="criticality" onchange="submit()" style="width:23px" >
<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>
<!-- ######## VINCENT -->
<form name="select_vincent" method="post">
<!-- ######## FIN VINCENT -->
<?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 number 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 technician
$querytech=mysql_query("SELECT * FROM tusers WHERE id LIKE '$row[technician]'");
$resulttech=mysql_fetch_array($querytech);
//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);
//cut first letter of firstame
$Fname=substr($resultuser['firstname'], 0, 1);
$Ftname=substr($resulttech['firstname'], 0, 1);
$rowdate= date_cnv($row['date_create']);
//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 && ($row['state']=='1'|| $row['state']=='2')) $img = "<img align=\"left\" border=\"0\" title=\"$resultdiff[0] jours de retard\" src=\"./images/clock.png\" />";
// Display line color
$bgcolor="";
//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="yellow";
//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="orange";
//query date is today display green
if (date('Y-m-d')==$row['date_create']) $bgcolor="green";
//if techncian unread
if ($row['techread']==0) $bgcolor="red";
// default bg color
if ($bgcolor=="") $bgcolor="blue";
//if text is too long cut
$title=$row['title'];
$uname=$resultuser['lastname'];
//attach file
$attach='';
if(!isset($row['img1'])) $row['img1']= '';
if($row['img1']!='') $attach= "<img border=\"0\" title=\"$row[img1]\" src=\"./images/attach_min.png\"/>";
if ($profile=='technician') {$pageticket='ticket';} else {$pageticket='ticket_u';}
echo "
<!--<tr class=\"$bgcolor\" onclick=\"document.location='./index.php?page=$pageticket&id=$row[id]&state=$_GET[state]&techid=$_GET[techid]'\">-->
<tr class=\"$bgcolor\" >
<td style=\"width:30px;\"><center><input id=\"select_piece\" name=\"select_piece[]\" type=\"checkbox\" size=\"4\" maxlength=\"4\" value=\"$row[id]\" /></center></td>
<td onclick=\"document.location='./index.php?page=$pageticket&id=$row[id]&state=$_GET[state]&techid=$_GET[techid]'\" style=\"width:30px;\"><center><a class=\"td\" href=\"./index.php?page=$pageticket&id=$row[id]\">$img $row[id]</a></center></td>
";
if ($_SESSION['profile_id']!=0 || $_SESSION['profile_id']!=4 || $_GET['techid']=='%')
{
echo "<td onclick=\"document.location='./index.php?page=$pageticket&id=$row[id]&state=$_GET[state]&techid=$_GET[techid]'\"><center><a class=\"td\" href=\"./index.php?page=$pageticket&id=$row[id]&state=$_GET[state]&techid=$_GET[techid]\">$Ftname. $resulttech[lastname] </a></center></td>";
}
if ($_SESSION['profile_id']==0 || $_SESSION['profile_id']==4 ||$_SESSION['profile_id']==3 )
{
echo "<td onclick=\"document.location='./index.php?page=$pageticket&id=$row[id]&state=$_GET[state]&techid=$_GET[techid]'\"><a class=\"td\" title=\"Tel: $resultuser[phone] \" href=\"./index.php?page=$pageticket&id=$row[id]&state=$_GET[state]&techid=$_GET[techid]\">$Fname. $uname </a></td>";
}
echo "
<td onclick=\"document.location='./index.php?page=$pageticket&id=$row[id]&state=$_GET[state]&techid=$_GET[techid]'\"><a class=\"td\" href=\"./index.php?page=$pageticket&id=$row[id]&state=$_GET[state]&techid=$_GET[techid]\">$resultcat[name]</a></td>
<td onclick=\"document.location='./index.php?page=$pageticket&id=$row[id]&state=$_GET[state]&techid=$_GET[techid]'\"><a class=\"td\" href=\"./index.php?page=$pageticket&id=$row[id]&state=$_GET[state]&techid=$_GET[techid]\">$resultscat[name]</a></td>
<td onclick=\"document.location='./index.php?page=$pageticket&id=$row[id]&state=$_GET[state]&techid=$_GET[techid]'\"><a class=\"td\" title=\"$row[title] \" href=\"./index.php?page=$pageticket&id=$row[id]&state=$_GET[state]&techid=$_GET[techid]\">$title $attach</a></td>
<td onclick=\"document.location='./index.php?page=$pageticket&id=$row[id]&state=$_GET[state]&techid=$_GET[techid]'\"><a class=\"td\" href=\"./index.php?page=$pageticket&id=$row[id]&state=$_GET[state]&techid=$_GET[techid]\">$rowdate</a></td>
<td onclick=\"document.location='./index.php?page=$pageticket&id=$row[id]&state=$_GET[state]&techid=$_GET[techid]'\"><a class=\"td\" href=\"./index.php?page=$pageticket&id=$row[id]&state=$_GET[state]&techid=$_GET[techid]\"> <center><img style=\"border-style: none\" alt=\"state\" title=\"$resultstate[name]\" src=\"./images/$resultstate[id].png\" /></center> </a></td>
<td onclick=\"document.location='./index.php?page=$pageticket&id=$row[id]&state=$_GET[state]&techid=$_GET[techid]'\"><center><a title=\"$resultpriority[name]\" class=\"td\" href=\"./index.php?page=$pageticket&id=$row[id]&state=$_GET[state]&techid=$_GET[techid]\" >$row[priority]</a></center></td>
<td onclick=\"document.location='./index.php?page=$pageticket&id=$row[id]&state=$_GET[state]&techid=$_GET[techid]'\"><a title=\"$resultcriticality[name]\" class=\"td\" href=\"./index.php?page=$pageticket&id=$row[id]&state=$_GET[state]&techid=$_GET[techid]\" > <center><img style=\"border-style: none\" alt=\"$resultcriticality[name]\" src=\"./images/critical_$resultcriticality[color].png\" /></a></center></td>
</tr>
";
}
?>
</table>
<?php
//Multi-pages link
if ($resultcount[0]>$rparameters['maxline'])
{
//count number of page
$pagenum=ceil($resultcount[0]/$rparameters['maxline']);
// asc or desc
if ($_GET['way']==''){$_GET['way']='ASC';} else if ($_GET['way']=='ASC') {$_GET['way']='DESC';} else if ($_GET['way']=='DESC') {$_GET['way']='ASC';}
echo "<center>";
for ($i = 1; $i <= $pagenum; $i++) {
if ($i==1) $_GET['cursor']=0;
if($_GET['searchengine']==1)
{echo "<span class=\"pagination\"> <a href=\"index.php?page=dashboard&techid=$_GET[techid]&state=$_GET[state]&order=$_GET[order]&way=$_GET[way]&cursor=$_GET[cursor]&searchengine=1&keywords=$keywords[0]\"> $i </a></span> ";}
else
{echo "<span class=\"pagination\"><a href=\"index.php?page=dashboard&techid=$_GET[techid]&state=$_GET[state]&order=$_GET[order]&way=$_GET[way]&cursor=$_GET[cursor]\"> $i </a></span> ";}
$_GET['cursor']=$i*$rparameters['maxline'];
}
echo "</center>";
}
//#################vincent
?>
<select name="change_status" onchange="submit()" style="" >
<option value=""></option>
<?php
$query = mysql_query("SELECT * FROM tstates ORDER BY number ");
while ($row=mysql_fetch_array($query)) {echo "<option value=\"$row[id]\">$row[name]</option>";}
?>
</select>
<!--<button name="valid_change_status" value="change_status" type="submit" class="positive" id="save">
<img src="images/apply2.png" alt=""/>
CHANGER LE STATUT
</button>-->
</form>
</div>
<?php
//##########FIN VINCENT
// Date conversion
function date_cnv ($date)
{return substr($date,8,2) . "/" . substr($date,5,2) . "/" . substr($date,0,4);}
// Display events popup
if(!isset($displayevent)) $displayevent= '';
$q = mysql_query("SELECT * FROM `tevents` WHERE technician LIKE '$uid' and disable='0' and type='1'");
while ($event=mysql_fetch_array($q))
{
$devent=explode(" ",$event['date_start']);
//day check
if ($devent[0]<=$daydate)
{
//hour check
$currenthour=date("H:i:s");
$eventhour=explode(" ",$event['date_start']);
if ($currenthour>$eventhour[1])
{
$displayevent= "<a title=\"Planifié aujourd'hui à $devent[1]\" href=\"./index.php?page=ticket&id=$event[incident]\"><img src=\"./images/event.png\" /> <font color=\"FFFFFF\">Rappel ticket: $event[incident]</font></a>";
$eventincident=$event['incident'];
$eventtime=$devent[1];
$eventid=$event['id'];
echo "
<script type=\"text/javascript\">
$().ready(function() {
$('#dialog').jqm();
$('#dialog').jqmShow();
return false;
});
</script>
<div class=\"jqmWindow\" id=\"dialog\">
";
include "./event.php";
echo"
</div>
";
}
}
}
$q=mysql_query("SELECT * FROM `tusers` WHERE id LIKE '$uid'");
$r=mysql_fetch_array($q);
// Popup to display message to change user password.
if ($r['chgpwd']=='1')
{
echo "
<script type=\"text/javascript\">
$().ready(function() {
$('#dialog').jqm();
$('#dialog').jqmShow();
return false;
});
</script>
<div class=\"jqmWindow\" id=\"dialog\">
";
include "./modify_pwd.php";
echo"
</div>
";
}
?>