?>
",
"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: 20%; 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;'> <?php
echo __('Tickets', 'dashboard');
?>
: </span><?php
echo $total_cham;
?>
</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
echo _x('button', 'Export');
?>
",
"aButtons": [ "csv", "xls",
{
"sExtends": "pdf",
"sPdfOrientation": "landscape",
"sPdfMessage": ""
} ]
}
if ($status1 == "5") {
$status1 = "solved";
}
if ($status1 == "6") {
$status1 = "closed";
}
//requerente
$sql_user = "******" . $row['id'] . "\nAND glpi_tickets_users.`users_id` = glpi_users.id\nAND glpi_tickets_users.type = 1\n";
$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\nFROM `glpi_tickets_users` , glpi_tickets, glpi_users\nWHERE glpi_tickets.id = glpi_tickets_users.`tickets_id`\nAND glpi_tickets.id = " . $row['id'] . "\nAND glpi_tickets_users.`users_id` = glpi_users.id\nAND glpi_tickets_users.type = 2\n";
$result_tec = $DB->query($sql_tec);
$row_tec = $DB->fetch_assoc($result_tec);
echo "\t\n\n<tr>\n<td style='vertical-align:middle; text-align:center;'><a href=../../../front/ticket.form.php?id=" . $row['id'] . " target=_blank >" . $row['id'] . "</a></td>\n<td style='vertical-align:middle;'><img src=../../../pics/" . $status1 . ".png title='" . Ticket::getStatus($row['status']) . "' style=' cursor: pointer; cursor: hand;'/> </td>\n<td> " . substr($row['descr'], 0, 55) . " </td>\n<td> " . $row_user['name'] . " " . $row_user['sname'] . " </td>\n<td> " . $row_tec['name'] . " " . $row_tec['sname'] . " </td>\n<td> " . conv_data($row['date']) . " </td>\n<td> " . conv_data($row['solvedate']) . " </td>\n<!-- <td> " . Ticket::getStatus($row['status']) . " </td> -->\n</tr>";
}
echo "</table></div>";
?>
<?php
// paginacao 2
echo '<div id=pag align=center class="paginas navigation row-fluid">';
$total_paginas = $total_cham / $num_por_pagina;
$prev = $pagina - 1;
$next = $pagina + 1;
// se página maior que 1 (um), então temos link para a página anterior
if ($pagina > 1) {
$prev_link = "<a href=" . $url2 . "?con=1&stat=" . $_GET['stat'] . "&date1=" . $data_ini2 . "&date2=" . $data_fin2 . "&date=" . $id_date . "&pagina=" . $prev . ">" . __('Previous', 'dashboard') . "</a>";
} else {
