//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,