1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80
|
<head>
<script language="javascript" src="calendar/calendar.js"></script>
<link media="print, projection, screen" type="text/css" href="Jqueryset/jquery.tablesorter/themes/blue/style.css" rel="stylesheet">
<script type="text/javascript" src="Jqueryset/jquery.tablesorter/jquery-latest.js"></script>
<script type="text/javascript" src="Jqueryset/jquery.tablesorter/jquery.tablesorter.js"></script>
<script type="text/javascript" src="Jqueryset/jquery.tablesorter/addons/pager/jquery.tablesorter.pager.js"></script>
<script type="text/javascript">$(function(){$("#tablecase").tablesorter({widthFixed: true, widgets: ['zebra']}).tablesorterPager({container: $("#pager")});});</script>
</head>
<?php
require_once('calendar/classes/tc_calendar.php')
?>
<?php
#####################Database connection
include('connect.php');
$query = "SELECT stage,name,creator,create_time,modification_time,owner,actions_taken,planned_actions,recommended_actions,final_report_action FROM Arc_cases ORDER BY create_time DESC";
$queryresult = mysql_query($query) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
mysql_close();
############################Print cases informations
$row = mysql_fetch_row($queryresult);
if (!$row){
echo "No case to display<BR>";
}else{
echo '<div id=tablecases>';
echo '<table id="tablecase" class="tablesorter"><thead><tr><th>Stage</th><th>Case name</th><th>Creator</th><th>Created</th><th>Modified</th><th>Escalated to</th><th>Actions taken</th>
<th>Planned actions</th><th>Recommended actions</th><th>Final action</th></tr></thead>';
echo '<tfoot><tr><th>Stage</th><th>Case name</th><th>Creator</th><th>Created</th><th>Modified</th><th>Escalated to</th><th>Actions taken</th><th>Planned actions</th>
<th>Recommended actions</th><th>Final action</th></tr></tfoot><tbody>';
$name=$row[1];
$creator=$row[2];
$create_time=$row[3];
$modification_time=$row[4];
$owner=$row[5];
$actions_taken=$row[6];
$planned_actions=$row[7];
$recommended_actions=$row[8];
$final_report_action=$row[9];
echo "<tr><td>$stage</td><td>$name</td><td>$creator</td><td>$create_time</td><td>$mofication_time</td><td>$owner</td><td>$actions_taken</td><td>$planned_actions</td>
<td>$recommended_actions</td><td>$final_report_action</td></tr>";
while ($row = mysql_fetch_row($queryresult)){
$stage=$row[0];
$name=$row[1];
$creator=$row[2];
$create_time=$row[3];
$modification_time=$row[4];
$owner=$row[5];
$actions_taken=$row[6];
$planned_actions=$row[7];
$recommended_actions=$row[8];
$final_report_action=$row[9];
echo "<tr><td>$stage</td><td>$name</td><td>$creator</td><td>$create_time</td><td>$mofication_time</td><td>$owner</td><td>$actions_taken</td><td>$planned_actions</td>
<td>$recommended_actions</td><td>$final_report_action</td></tr>";
}
}
mysql_close();
echo '</tbody></table>';
echo '<div id="pager" class="pager">
<form>
<img class="first" src="Jqueryset/jquery.tablesorter/addons/pager/icons/first.png">
<img class="prev" src="Jqueryset/jquery.tablesorter/addons/pager/icons/prev.png">
<input class="pagedisplay" type="text">
<img class="next" src="Jqueryset/jquery.tablesorter/addons/pager/icons/next.png">
<img class="last" src="Jqueryset/jquery.tablesorter/addons/pager/icons/last.png">
<select class="pagesize">
<option value="10" selected="selected">10</option>
<option value="20">20</option>
<option value="30">30</option>
<option value="40">40</option>
</select>
</form>
</div>';
echo '</div>';
?> |
Partager