echo __('Technician', 'dashboard');
?>
: </span><?php
echo $tech;
?>
</td> <td colspan='2' style='font-size: 16px; font-weight:bold; vertical-align:middle;'><span style='color:#000;'> <?php
echo _n('Task', 'Tasks', 2);
?>
: </span><?php
echo $conta_cons;
?>
</td><td colspan='2' style='font-size: 16px; font-weight:bold; vertical-align:middle; width:200px;'><span style='color:#000;'><?php
echo __('Time');
?>
</span> : <?php
echo time_ext($tempoTotal);
?>
</td><td colspan='2' style='font-size: 16px; font-weight:bold; vertical-align:middle; width:200px;'><span style='color:#000;'> <?php
echo __('Period', 'dashboard');
?>
: </span> <?php
echo conv_data($data_ini2);
?>
a <?php
echo conv_data($data_fin2);
?>
</td> </table></div>"
},
{
"sExtends": "collection",
"sButtonText": "<?php
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,
}
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['closedate']) . " </td>\n\t\t\t<td style='vertical-align:middle; text-align:center;'> " . time_ext($row['time']) . "</td>\n\t\t\t</tr>";
}
echo "</tbody>\n\t\t\t\t\t</table>\n\t\t\t\t\t</div>";
?>
<script type="text/javascript" charset="utf-8">
$('#cat')
.removeClass( 'display' )
.addClass('table table-striped table-bordered');
$(document).ready(function() {
oTable = $('#cat').dataTable({
"bJQueryUI": true,
"sPaginationType": "full_numbers",
"bFilter": false,
"sExtends": "print",
"sButtonText": "<?php
echo __('Print', 'dashboard');
?>
",
"sMessage": "<div id='print' class='info_box row-fluid span12' style='margin-bottom:35px; margin-left: -1px;'><table id='print_tb' class='row-fluid' style='width: 80%; margin-left: 10%; font-size: 18px; font-weight:bold;' cellpadding = '1px'><td colspan='2' style='font-size: 16px; font-weight:bold; vertical-align:middle;'><span style='color:#000;'> </td> <td colspan='2' style='font-size: 16px; font-weight:bold; vertical-align:middle;'><span style='color:#000;'> <?php
echo _n('Task', 'Tasks', 2);
?>
: </span><?php
echo $conta_cons;
?>
</td><td colspan='2' style='font-size: 16px; font-weight:bold; vertical-align:middle; width:200px;'><span style='color:#000;'><?php
echo __('Time');
?>
</span> : <?php
echo time_ext($tempo_total);
?>
</td><td colspan='2' style='font-size: 16px; font-weight:bold; vertical-align:middle; width:200px;'><span style='color:#000;'> <?php
echo __('Period', 'dashboard');
?>
: </span> <?php
echo conv_data($data_ini2);
?>
a <?php
echo conv_data($data_fin2);
?>
</td> </table></div>"
},
{
"sExtends": "collection",
"sButtonText": "<?php
