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