//nome e total
$sql_nome = "\nSELECT `firstname` , `realname`, `name`\nFROM `glpi_users`\nWHERE `id` = " . $id_tec . " ";
$result_nome = $DB->query($sql_nome);
//total time of tasks
while ($row = $DB->fetch_assoc($result_cons1)) {
$tempoTotal += $row['actiontime'];
}
//table thread
while ($row = $DB->fetch_assoc($result_nome)) {
$tech = $row['firstname'] . " " . $row['realname'];
echo "\n\t<div class='well info_box row-fluid span12' style='margin-top:25px; margin-left: -1px;'>\n\t\n\t<table class='row-fluid' style='font-size: 18px; font-weight:bold; margin-bottom: 30px;' cellpadding = 1px>\n\t<tr>\n\t<td style='vertical-align:middle; width:40%;'> <span style='color: #000;'>" . __('Technician', 'dashboard') . ": </span> " . $row['firstname'] . " " . $row['realname'] . "</td>\n\t<td style='vertical-align:middle;'> <span style='color: #000;'>" . _n('Task', 'Tasks', 2) . ": </span>" . $conta_cons . "</td>\n\t<td style='vertical-align:middle;'> <span style='color: #000;'>" . __('Time') . ": </span>" . time_ext($tempoTotal) . "</td>\n\t<td colspan='3' style='font-size: 16px; font-weight:bold; vertical-align:middle; width:200px;'><span style='color:#000;'>\n\t" . __('Period', 'dashboard') . ": </span> " . conv_data($data_ini2) . " a " . conv_data($data_fin2) . "\n\t</td>\n\t</tr>\n\t</table>\n\t\n\t<table id='tarefa' class='display' style='font-size: 13px; font-weight:bold;' cellpadding = 2px>\n\t\t<thead>\n\t\t\t<tr>\n\t\t\t\t<th style='text-align:center; color: #000; cursor:pointer;'> " . __('Ticket') . " </th>\n\t\t\t\t<th style='text-align:center; color: #000; cursor:pointer;'> " . __('Date') . " </th>\n\t\t\t\t<th style='text-align:center; color: #000; cursor:pointer;'> " . __('Description') . "</th>\n\t\t\t\t<th style='text-align:center color: #000; cursor:pointer;'> " . __('Duration') . " </th>\n\t\t\t\t<th style='text-align:center color: #000; cursor:pointer;'> " . __('Begin') . " </th>\n\t\t\t\t<th style='text-align:center color: #000; cursor:pointer;'> " . __('End') . " </th>\n\t\t\t</tr>\n\t\t</thead>\n\t<tbody>\n\t";
}
//listar chamados
$DB->data_seek($result_cham, 0);
while ($row = $DB->fetch_assoc($result_cham)) {
echo "\n\t<tr>\n\t<td style='text-align:center;'><a href=" . $CFG_GLPI['root_doc'] . "/front/ticket.form.php?id=" . $row['id'] . " target=_blank >" . $row['id'] . "</a></td>\n\t<td> " . conv_data_hora($row['date']) . " </td>\n\t<td> " . $row['content'] . " </td>\n\t<td> " . time_ext($row['actiontime']) . "</td>";
echo "\n\t<td> " . $row['begin'] . "</td>\n\t<td> " . $row['end'] . "</td>\n\t</tr>";
}
echo "</tbody>\n\t\t</table>\n\t\t</div>";
?>
<script type="text/javascript" charset="utf-8">
$('#tarefa')
.removeClass( 'display' )
.addClass('table table-striped table-bordered');
$(document).ready(function() {
oTable = $('#tarefa').dataTable({
"bJQueryUI": true,
"sPaginationType": "full_numbers",
}
if ($status1 == "5") {
$status1 = "solved";
}
if ($status1 == "6") {
$status1 = "closed";
}
//requerente
$sql_user = "******" . $row['id'] . "\n\t\t\tAND glpi_tickets_users.`users_id` = glpi_users.id\n\t\t\tAND glpi_tickets_users.type = 1\n\t\t\t" . $entidade . " ";
$result_user = $DB->query($sql_user);
$row_user = $DB->fetch_assoc($result_user);
//tecnico
$sql_tec = "SELECT glpi_tickets.id AS id, glpi_users.firstname AS name, glpi_users.realname AS sname\n\t\t\tFROM `glpi_tickets_users` , glpi_tickets, glpi_users\n\t\t\tWHERE glpi_tickets.id = glpi_tickets_users.`tickets_id`\n\t\t\tAND glpi_tickets.id = " . $row['id'] . "\n\t\t\tAND glpi_tickets_users.`users_id` = glpi_users.id\n\t\t\tAND glpi_tickets_users.type = 2\n\t\t\t" . $entidade . " ";
$result_tec = $DB->query($sql_tec);
$row_tec = $DB->fetch_assoc($result_tec);
echo "\t\n\t\t\t<tr>\n\t\t\t<td style='vertical-align:middle; text-align:center;'><a href=" . $CFG_GLPI['url_base'] . "/front/ticket.form.php?id=" . $row['id'] . " target=_blank >" . $row['id'] . "</a></td>\n\t\t\t<td style='vertical-align:middle;'><img src=" . $CFG_GLPI['url_base'] . "/pics/" . $status1 . ".png title='" . Ticket::getStatus($row['status']) . "' style=' cursor: pointer; cursor: hand;'/> " . Ticket::getStatus($row['status']) . " </td>\n\t\t\t<td style='vertical-align:middle;'> " . substr($row['descr'], 0, 55) . " </td>\n\t\t\t<td style='vertical-align:middle;'> " . $row_user['name'] . " " . $row_user['sname'] . " </td>\n\t\t\t<td style='vertical-align:middle;'> " . $row_tec['name'] . " " . $row_tec['sname'] . " </td>\n\t\t\t<td style='vertical-align:middle;'> " . conv_data_hora($row['date']) . " </td>\n\t\t\t<td style='vertical-align:middle;'> " . conv_data_hora($row['solvedate']) . " </td>\n\t\t\t</tr>";
}
echo "</tbody>\n\t\t\t\t</table>\n\t\t\t\t</div>";
?>
<script type="text/javascript" charset="utf-8">
$('#data')
.removeClass( 'display' )
.addClass('table table-striped table-bordered');
$(document).ready(function() {
oTable = $('#data').dataTable({
"bJQueryUI": true,
"sPaginationType": "full_numbers",
"bFilter": false,
if ($status1 == "6") {
$status1 = "closed";
}
if ($row['type'] == 1) {
$type = __('Incident');
} else {
$type = __('Request');
}
if ($satisfacao != '' || $satisfacao > 0) {
$query_satc = "SELECT `glpi_ticketsatisfactions`.satisfaction AS sat\n\t\tFROM `glpi_ticketsatisfactions`\n\t\tWHERE glpi_ticketsatisfactions.tickets_id = " . $row['id'] . "\n\t\t";
$result_satc = $DB->query($query_satc);
$satc = $DB->fetch_assoc($result_satc);
$satc1 = $satc['sat'];
echo "\n\t\t<tr>\n\t\t<td style='vertical-align:middle; text-align:center;'><a href=" . $CFG_GLPI['root_doc'] . "/front/ticket.form.php?id=" . $row['id'] . " target=_blank >" . $row['id'] . "</a></td>\n\t\t<td style='vertical-align:middle;' align='center'><img src=../../../../pics/" . $status1 . ".png title='" . Ticket::getStatus($row['status']) . "' style=' cursor: pointer; cursor: hand;'/> </td>\n\t\t<td style='vertical-align:middle;'> " . $type . " </td>\n\t\t<td style='vertical-align:middle;'> " . substr($row['name'], 0, 75) . " </td>\n\t\t<td style='vertical-align:middle;'> " . conv_data_hora($row['date']) . " </td>\n\t\t<td style='vertical-align:middle;'> " . conv_data_hora($row['solvedate']) . " </td>\n\t\t<td style='vertical-align:middle;'> " . time_ext($row['time']) . "</td>\n\t\t<td style='vertical-align:middle;'> <img src=../img/s" . $satc1 . ".png> </td>\n\t\t</tr>";
} else {
echo "\n\t\t<tr>\n\t\t<td style='vertical-align:middle; text-align:center;'><a href=" . $CFG_GLPI['root_doc'] . "/front/ticket.form.php?id=" . $row['id'] . " target=_blank >" . $row['id'] . "</a></td>\n\t\t<td style='vertical-align:middle;' align='center'><img src=../../../../pics/" . $status1 . ".png title='" . Ticket::getStatus($row['status']) . "' style=' cursor: pointer; cursor: hand;'/> </td>\n\t\t<td style='vertical-align:middle;'> " . $type . " </td>\n\t\t<td style='vertical-align:middle;'> " . substr($row['name'], 0, 75) . " </td>\n\t\t<td style='vertical-align:middle;'> " . conv_data_hora($row['date']) . " </td>\n\t\t<td style='vertical-align:middle;'> " . conv_data_hora($row['solvedate']) . " </td>\n\t\t<td style='vertical-align:middle;'> " . time_ext($row['time']) . "</td>\n\t\t</tr>";
}
}
echo "</tbody>\n\t\t</table>\n\t\t</div>";
?>
<script type="text/javascript" charset="utf-8">
$('#tec')
.removeClass( 'display' )
.addClass('table table-striped table-bordered');
$(document).ready(function() {
oTable = $('#tec').dataTable({
"bJQueryUI": true,
}
//get Location
$sql_loc = "SELECT id, name\n\t\tFROM glpi_locations\n\t\tWHERE glpi_locations.id = " . $row['lid'] . " ";
$result_loc = $DB->query($sql_loc);
$row_loc = $DB->fetch_assoc($result_loc);
echo "\n\t\t<tr class='title'>\n\t\t\t<td style='text-align:center; vertical-align:middle;'> <a href=../../../../front/ticket.form.php?id=" . $row['id'] . " target=_blank > <span >" . $row['id'] . "</span> </a></td>\n\t\t\t<td style='vertical-align:middle;'><span style='color:#000099';><img src=../../../../pics/" . $status1 . ".png /> " . Ticket::getStatus($row['status']) . "</span ></td>\n\t\t\t<td style='vertical-align:middle;'><a href=../../../../front/ticket.form.php?id=" . $row['id'] . " target=_blank > <span >" . $row['descri'] . "</span> </a></td>\n\t\t\t<td style='vertical-align:middle;'><span >" . $row_tec['name'] . " " . $row_tec['sname'] . "</span> </td>\n\t\t\t<td style='vertical-align:middle;'><span >" . $row_req['name'] . " " . $row_req['sname'] . "</span> </td>";
if ($show_loc == 1) {
echo "<td style='vertical-align:middle; text-align:center; font-size:14pt;'>" . $row_loc['name'] . "</td>";
}
if ($show_due == 1) {
if ($count_due > 0) {
$now = date("Y-m-d H:i");
if ($row['duedate'] < $now) {
echo "<td style='vertical-align:middle; font-size:14pt; color:red;'><span>" . conv_data_hora($row['duedate']) . "</span> </td>";
} else {
echo "<td style='vertical-align:middle; font-size:14pt; color:green;'><span>" . conv_data_hora($row['duedate']) . "</span> </td>";
}
}
}
echo "\t\t\t\t\n\t\t\t<td style='vertical-align:middle; text-align:center; background-color:" . $row_prio['value'] . ";'>" . $prio_name . "</td>\n\t\t</tr>";
}
echo "</tbody>\n\t\t\t\t</table>";
?>
</div>
</div>
</div>
<style type="text/css">
table.dataTable thead > tr > th {
padding-right: 10px;
//category
$sql_cat = "SELECT name\n\t\t\t\tFROM glpi_itilcategories\n\t\t\t\tWHERE id = " . $row['cat'] . " ";
$result_cat = $DB->query($sql_cat);
$row_cat = $DB->fetch_assoc($result_cat);
// associated element
$sql_item = "SELECT itemtype, items_id\n\t\t\t\tFROM glpi_items_tickets \n\t\t\t\tWHERE glpi_items_tickets.tickets_id = " . $row['id'] . "";
$result_item = $DB->query($sql_item);
$row_item = $DB->fetch_assoc($result_item);
$type = strtolower($row_item['itemtype']);
$url_type = $CFG_GLPI['url_base'] . "/front/" . $type . ".form.php?id=";
$sql_ass = "SELECT id, name\n\t\t\t\tFROM glpi_" . $type . "s\n\t\t\t\tWHERE id = " . $row_item['items_id'] . " ";
$result_ass = $DB->query($sql_ass);
if ($result_ass != '') {
$row_item = $DB->fetch_assoc($result_ass);
}
echo "\n\t\t<tr>\n\t\t\t<td style='vertical-align:middle; text-align:center;'><a href=" . $CFG_GLPI['url_base'] . "/front/ticket.form.php?id=" . $row['id'] . " target=_blank >" . $row['id'] . "</a></td>\n\t\t\t<td style='vertical-align:middle; font-size:10px;'><img src=" . $CFG_GLPI['url_base'] . "/pics/" . $status1 . ".png title='" . Ticket::getStatus($row['status']) . "' style=' cursor: pointer; cursor: hand;'/> " . Ticket::getStatus($row['status']) . " </td>\n\t\t\t<td style='vertical-align:middle;'> " . Ticket::getTicketTypeName($row['TYPE']) . " </td>\n\t\t\t<td style='vertical-align:middle;'> " . substr($row['descr'], 0, 55) . " </td>\n\t\t\t<td style='vertical-align:middle;'> " . $row_user['name'] . " " . $row_user['sname'] . " </td>\n\t\t\t<td style='vertical-align:middle;'> " . $row_tec['name'] . " " . $row_tec['sname'] . " </td>\n\t\t\t<td style='vertical-align:middle;'> " . $row_cat['name'] . " </td>\n\t\t\t<td style='vertical-align:middle;'> <a href=" . $url_type . $row_item['id'] . " target=_blank >" . $row_item['name'] . " </a></td>\t\t\t\n\t\t\t<td style='vertical-align:middle;'> " . conv_data_hora($row['date']) . " </td>\n\t\t\t<td style='vertical-align:middle;'> " . conv_data_hora($row['closedate']) . " </td>\n\t\t\t<td style='vertical-align:middle;'> " . time_ext($row['time_sec']) . " </td>\n\t\t</tr>";
}
echo "</tbody> \n\t\t\t\t</table>\n\t\t\t\t</div>";
?>
<script type="text/javascript" charset="utf-8">
$('#t_ent')
.removeClass( 'display' )
.addClass('table table-striped table-bordered table-hover');
$(document).ready(function() {
oTable = $('#t_ent').dataTable({
"bJQueryUI": true,
"sPaginationType": "full_numbers",
"bFilter": false,
if ($conta_cons > 0) {
//total time of tasks
while ($row = $DB->fetch_assoc($result_cons1)) {
$tempo_total += $row['actiontime'];
}
//$tech = $row['firstname'] ." ". $row['realname'];
echo "\n\t<div class='well info_box row-fluid col-md-12 report' style='margin-left: -1px;'>\n\t\n\t<table class='row-fluid' style='font-size: 18px; font-weight:bold; margin-bottom: 30px;' cellpadding = 1px>\n\t\t<tr>\n\t\t\t<td style='vertical-align:middle; width:350px;'> <span style='color: #000;'>" . _n('Task', 'Tasks', 2) . ": </span>" . $conta_cons . "</td>\n\t\t\t<td style='vertical-align:middle; width:350px;'> <span style='color: #000;'>" . __('Time') . ": </span>" . time_ext($tempo_total) . "</td>\n\t\t\t<td colspan='4' style='font-weight:bold; vertical-align:middle; width:200px;'><span style='color:#000;'>" . __('Period', 'dashboard') . ": </span> " . conv_data($data_ini2) . " a " . conv_data($data_fin2) . "</td>\n\t\t</tr>\n\t</table>";
echo "\n\t<table id='tarefa' class='display' style='font-size: 13px; font-weight:bold;' cellpadding = 2px>\n\t\t<thead>\n\t\t\t<tr>\n\t\t\t\t<th style='text-align:center; cursor:pointer;'> " . __('Ticket') . " </th>\n\t\t\t\t<th style='text-align:center; cursor:pointer;'> " . __('Date') . " </th>\n\t\t\t\t<th style='text-align:center; cursor:pointer;'> " . __('Technician') . " </th>\n\t\t\t\t<th style='text-align:center; cursor:pointer;'> " . __('Description') . "</th>\n\t\t\t\t<th style='text-align:center; cursor:pointer;'> " . __('Duration') . " </th>\n\t\t\t\t<th style='text-align:center; cursor:pointer;'> " . __('Begin') . " </th>\n\t\t\t\t<th style='text-align:center; cursor:pointer;'> " . __('End') . " </th>\n\t\t\t</tr>\n\t\t</thead>\n\t<tbody>\n\t";
//}
//listar chamados
while ($row = $DB->fetch_assoc($result_cham)) {
//nome e total
$sql_nome = "\n\tSELECT glpi_users.id, glpi_users.firstname , glpi_users.realname, glpi_users.name\n\tFROM glpi_users, glpi_tickettasks\n\tWHERE glpi_tickettasks.users_id = glpi_users.id\n\tAND glpi_users.id = " . $row['uid'] . " ";
$result_nome = $DB->query($sql_nome);
$row_nome = $DB->fetch_assoc($result_nome);
echo "\n\t<tr>\n\t<td style='text-align:center;'><a href=" . $CFG_GLPI['url_base'] . "/front/ticket.form.php?id=" . $row['id'] . " target=_blank >" . $row['id'] . "</a></td>\n\t<td style='text-align:center;'> " . conv_data_hora($row['date']) . " </td>\n\t<td> " . $row_nome['firstname'] . " " . $row_nome['realname'] . " </td>\n\t<td style='max-width:350px;'> " . $row['content'] . " </td>\n\t<td> " . time_ext($row['actiontime']) . "</td>\n\t<td style='text-align:center;'> " . conv_data_hora($row['begin']) . "</td>\n\t<td style='text-align:center;'> " . conv_data_hora($row['end']) . "</td>\n\t</tr>";
}
echo "</tbody>\n\t\t</table>\n\t\t</div>";
?>
<script type="text/javascript" charset="utf-8">
$('#tarefa')
.removeClass( 'display' )
.addClass('table table-striped table-bordered table-hover');
$(document).ready(function() {
oTable = $('#tarefa').dataTable({
"bJQueryUI": true,
"sPaginationType": "full_numbers",
"bFilter": false,
}
if ($barra > 0 and $barra <= 50) {
$cor_due = " ";
}
if ($barra < 0) {
$cor_due = "progress-bar-success";
$barra = 0;
}
}
// progress bar color
if ($row['percent_done'] == 100) {
$cor = "progress-bar-success";
} else {
$cor = "";
}
echo "\n\t<tr>\n\t<td style='text-align:center; vertical-align:middle'><a href=" . $CFG_GLPI['url_base'] . "/front/project.form.php?id=" . $row['id'] . " target=_blank >" . $row['id'] . "</a></td>\n\t<td style='vertical-align:middle'> " . $row['name'] . " </td>\n\t<td style='text-align:center; vertical-align:middle; color:" . $row_stat['color'] . ";'> " . $row_stat['name'] . " </td>\t\n\t<td style='text-align:center; vertical-align:middle'> " . conv_data_hora($row['plan_start_date']) . "</td>\n\t<td style='text-align:center; vertical-align:middle'> " . conv_data_hora($row['plan_end_date']) . "</td>\n\t<td style='text-align:center; vertical-align:middle;'> " . getUserName($row['users_id']) . " </td>\t\n\t<td style='text-align:center; vertical-align:middle'><a href='./rel_projecttasks.php?sel_pro=" . $row['id'] . "' target=_self >" . $row_task['tasks'] . "</a></td>\n\t<td style='text-align:center; vertical-align:middle;'>\t\n\t\t<div class='progress' style='margin-top: 5px; margin-bottom: 5px;'>\n\t\t\t<div class='progress-bar " . $cor . " progress-bar-striped active' role='progressbar' aria-valuenow='" . $row['percent_done'] . "' aria-valuemin='0' aria-valuemax='100' style='width: " . $row['percent_done'] . "%;'>\n\t\t\t \t\t\t" . $row['percent_done'] . " % \t\n\t\t\t</div>\t\t\n\t\t</div> \n\t</td>\n\t<td style='text-align:center; vertical-align:middle;'> \n\t<div class='progress' style='margin-top: 19px;'>\n\t\t<div class='progress-bar " . $cor_due . " progress-bar-striped active' role='progressbar' aria-valuenow='" . $barra . "' aria-valuemin='0' aria-valuemax='100' style='width: " . $barra . "%;'>\n \t\t\t\t \t\t" . $message . "\n \t\t\t</div>\n \t\t</div>\t\n\t</td>\n\t</tr>";
}
//echo <td> ". $row_nome['firstname'] ." ".$row_nome['realname']." </td>;
echo "</tbody>\n\t\t</table>\n\t\t</div>";
?>
<script type="text/javascript" charset="utf-8">
$('#tarefa')
.removeClass( 'display' )
.addClass('table table-striped table-bordered table-hover');
$(document).ready(function() {
oTable = $('#tarefa').dataTable({
"bJQueryUI": true,
"sPaginationType": "full_numbers",
$sql_cat = "SELECT glpi_tickets.id AS id, glpi_itilcategories.name AS name\n\tFROM `glpi_tickets` , glpi_itilcategories\n\tWHERE glpi_tickets.itilcategories_id = glpi_itilcategories.`id`\n\tAND glpi_tickets.id = " . $row['id'] . " ";
$result_cat = $DB->query($sql_cat);
$row_cat = $DB->fetch_assoc($result_cat);
//vencimento
//check due_date
$sql_due = "SELECT due_date, closedate, solvedate \n\tFROM glpi_tickets\n\tWHERE glpi_tickets.is_deleted = 0\n\tAND glpi_tickets.id = " . $row['id'] . " ";
$result_due = $DB->query($sql_due);
$row_due = $DB->fetch_assoc($result_due);
echo "\t\n\t<tr>\n\t\t<td style='vertical-align:middle; text-align:center;'><a href=" . $CFG_GLPI['url_base'] . "/front/ticket.form.php?id=" . $row['id'] . " target=_blank >" . $row['id'] . "</a></td>\n\t\t<td style='vertical-align:middle;'><img src=" . $CFG_GLPI['url_base'] . "/pics/" . $status1 . ".png title='" . Ticket::getStatus($row['status']) . "' style=' cursor: pointer; cursor: hand;'/> " . Ticket::getStatus($row['status']) . "</td>\n\t\t<td style='vertical-align:middle;'> " . $type . " </td>\n\t\t<td style='vertical-align:middle;'> " . $row_req['name'] . " </td>\n\t\t<td style='vertical-align:middle;'> " . $pri . " </td>\n\t\t<td style='vertical-align:middle;'> " . $row_cat['name'] . " </td>\t\t\n\t\t<td style='vertical-align:middle;'> " . substr($row_user['descr'], 0, 55) . " </td>\n\t\t<td style='vertical-align:middle;'> " . $row_user['name'] . " " . $row_user['sname'] . " </td>\n\t\t<td style='vertical-align:middle;'> " . $row_tec['name'] . " " . $row_tec['sname'] . " </td>\n\t\t<td style='vertical-align:middle;'> " . conv_data_hora($row['date']) . " </td>\t\t\n\t\t<td style='vertical-align:middle;'> " . conv_data_hora($row['solvedate']) . " </td>";
//due date
//$now = date("Y-m-d H:i");
if (conv_data_hora($row_due['due_date']) > conv_data_hora($row['solvedate'])) {
//if($row_due['closedate'] > $row_due['due_date'] || $row_due['due_date'] > conv_data_hora($now) ) {
echo "<td style='vertical-align:middle; color:green;'><span>" . conv_data_hora($row['due_date']) . "</span> </td>";
} else {
echo "<td style='vertical-align:middle; color:red;'><span>" . conv_data_hora($row['due_date']) . "</span> </td>";
}
echo "\t\t\n\t</tr>";
}
echo "</tbody>\n\t\t</table>\n\t\t</div>";
?>
<script type="text/javascript" charset="utf-8">
$('#ticket')
.removeClass( 'display' )
.addClass('table table-striped table-bordered table-hover');
$(document).ready(function() {
oTable = $('#ticket').dataTable({
"bJQueryUI": true,
$cor = "progress-bar-success";
}
if ($barra >= 80 and $barra < 100) {
$cor = " ";
}
if ($barra > 51 and $barra < 80) {
$cor = "progress-bar-warning";
}
if ($barra > 0 and $barra <= 50) {
$cor = "progress-bar-danger";
}
if ($barra < 0) {
$cor = "progress-bar-danger";
$barra = 0;
}
echo "\n\t<tr>\n\t<td style='text-align:center; vertical-align:middle;'><a href=" . $CFG_GLPI['url_base'] . "/front/projecttask.form.php?id=" . $row['id'] . " target=_blank >" . $row['id'] . "</a></td>\t\t\n\t<td style='text-align:center; vertical-align:middle;'> " . $row['name'] . " </td>\n\t<td style='text-align:center; vertical-align:middle;'> " . getUserName($row['users_id']) . " </td>\t\t\t\t\n\t<td style='text-align:center; vertical-align:middle;'> " . conv_data_hora($row['date']) . "</td>\n\t<td style='text-align:center; vertical-align:middle;'> " . conv_data_hora($row['real_start_date']) . "</td>\n\t<td style='text-align:center; vertical-align:middle;'> " . conv_data_hora($row['real_end_date']) . "</td>\n\t<td style='text-align:center; vertical-align:middle;'> " . time_ext($row['effective_duration']) . "</td>\n\t<td style='text-align:center; vertical-align:middle;'> \n\t\t<div class='progress' style='margin-top: 5px; margin-bottom: 5px;'>\n\t\t\t<div class='progress-bar " . $cor . " progress-bar-striped active' role='progressbar' aria-valuenow='" . $barra . "' aria-valuemin='0' aria-valuemax='100' style='width: " . $barra . "%;'>\n\t\t\t \t\t\t" . $barra . " % \t\n\t\t\t </div>\t\t\n\t\t</div>\t\t\t\n\t</td>\n\t</tr>";
}
echo "</tbody>\n\t\t</table>\n\t\t</div>";
?>
<script type="text/javascript" charset="utf-8">
$('#tarefa')
.removeClass( 'display' )
.addClass('table table-striped table-bordered table-hover');
$(document).ready(function() {
oTable = $('#tarefa').dataTable({
"bJQueryUI": true,
"sPaginationType": "full_numbers",
"bFilter": false,
