static function showForTicket(Ticket $ticket) { global $DB, $CFG_GLPI; echo "<table class='tab_cadre_fixe'>"; echo "<tr><th>" . __('Summary') . "</th></tr>"; echo "<tr class='tab_bg_1 center'><td>" . _n('Time range', 'Time ranges', 2) . " : "; $calendar = new Calendar(); $calendars_id = Entity::getUsedConfig('calendars_id', $ticket->fields['entities_id']); if ($calendars_id > 0 && $calendar->getFromDB($calendars_id)) { echo $calendar->getLink(); } else { echo NOT_AVAILABLE; } echo "</td></tr>"; PluginTimelineticketState::showHistory($ticket); // Display ticket have Due date if ($ticket->fields['due_date'] && $ticket->fields['status'] != CommonITILObject::WAITING && strtotime(date('Y-m-d H:i:s')) - strtotime($ticket->fields['due_date']) > 0) { $calendar = new Calendar(); $calendars_id = Entity::getUsedConfig('calendars_id', $ticket->fields['entities_id']); if ($calendars_id > 0 && $calendar->getFromDB($calendars_id)) { if ($ticket->fields['closedate']) { $dateend = $calendar->getActiveTimeBetween($ticket->fields['due_date'], $ticket->fields['closedate']); } else { $dateend = $calendar->getActiveTimeBetween($ticket->fields['due_date'], date('Y-m-d H:i:s')); } } else { // cas 24/24 - 7/7 if ($ticket->fields['closedate']) { $dateend = strtotime($ticket->fields['closedate']) - strtotime($ticket->fields['due_date']); } else { $dateend = strtotime(date('Y-m-d H:i:s')) - strtotime($ticket->fields['due_date']); } } echo "<tr>"; echo "<th>" . __('Late') . "</th>"; echo "</tr>"; echo "<tr>"; echo "<td align='center' class='tab_bg_2_2'>" . Html::timestampToString($dateend, true) . "</td>"; echo "</tr>"; } echo "</table>"; echo "<table class='tab_cadre_fixe'>"; echo "<tr>"; echo "<th colspan='2'>" . __('Status') . "</th>"; echo "</tr>"; /* pChart library inclusions */ include GLPI_ROOT . "/plugins/timelineticket/lib/pChart2.1.4/class/pData.class.php"; include GLPI_ROOT . "/plugins/timelineticket/lib/pChart2.1.4/class/pDraw.class.php"; include GLPI_ROOT . "/plugins/timelineticket/lib/pChart2.1.4/class/pImage.class.php"; include GLPI_ROOT . "/plugins/timelineticket/lib/pChart2.1.4/class/pIndicator.class.php"; $a_data = PluginTimelineticketDisplay::getTotaltimeEnddate($ticket); $totaltime = $a_data['totaltime']; $end_date = $a_data['end_date']; $params = array('totaltime' => $totaltime, 'end_date' => $end_date); $ptState = new PluginTimelineticketState(); $ptState->showTimeline($ticket, $params); $ptAssignGroup = new PluginTimelineticketAssignGroup(); $ptAssignGroup->showTimeline($ticket, $params); $ptAssignUser = new PluginTimelineticketAssignUser(); $ptAssignUser->showTimeline($ticket, $params); echo "</table>"; PluginTimelineticketToolbox::ShowDetail($ticket, 'group'); PluginTimelineticketToolbox::ShowDetail($ticket, 'user'); }
static function showForTicket(Ticket $ticket) { global $DB, $CFG_GLPI; echo "<table class='tab_cadre_fixe'>"; echo "<tr><th>" . __('Summary') . "</th></tr>"; echo "<tr class='tab_bg_1 center'><td>" . _n('Time range', 'Time ranges', 2) . " : "; $calendar = new Calendar(); $calendars_id = Entity::getUsedConfig('calendars_id', $ticket->fields['entities_id']); if ($calendars_id > 0 && $calendar->getFromDB($calendars_id)) { echo $calendar->getLink(); } else { echo NOT_AVAILABLE; } echo "</td></tr>"; PluginTimelineticketState::showHistory($ticket); // Display ticket have Due date if ($ticket->fields['due_date'] && $ticket->fields['status'] != CommonITILObject::WAITING && strtotime(date('Y-m-d H:i:s')) - strtotime($ticket->fields['due_date']) > 0) { $calendar = new Calendar(); $calendars_id = Entity::getUsedConfig('calendars_id', $ticket->fields['entities_id']); if ($calendars_id > 0 && $calendar->getFromDB($calendars_id)) { if ($ticket->fields['closedate']) { $dateend = $calendar->getActiveTimeBetween($ticket->fields['due_date'], $ticket->fields['closedate']); } else { $dateend = $calendar->getActiveTimeBetween($ticket->fields['due_date'], date('Y-m-d H:i:s')); } } else { // cas 24/24 - 7/7 if ($ticket->fields['closedate']) { $dateend = strtotime($ticket->fields['closedate']) - strtotime($ticket->fields['due_date']); } else { $dateend = strtotime(date('Y-m-d H:i:s')) - strtotime($ticket->fields['due_date']); } } echo "<tr>"; echo "<th>" . __('Late') . "</th>"; echo "</tr>"; echo "<tr>"; echo "<td align='center' class='tab_bg_2_2'>" . Html::timestampToString($dateend, true) . "</td>"; echo "</tr>"; } echo "</table>"; echo "<table class='tab_cadre_fixe'>"; echo "<tr>"; echo "<th colspan='2'>" . __('Status') . "</th>"; echo "</tr>"; /* pChart library inclusions */ include GLPI_ROOT . "/plugins/timelineticket/lib/pChart2.1.4/class/pData.class.php"; include GLPI_ROOT . "/plugins/timelineticket/lib/pChart2.1.4/class/pDraw.class.php"; include GLPI_ROOT . "/plugins/timelineticket/lib/pChart2.1.4/class/pImage.class.php"; include GLPI_ROOT . "/plugins/timelineticket/lib/pChart2.1.4/class/pIndicator.class.php"; $a_data = PluginTimelineticketDisplay::getTotaltimeEnddate($ticket); $totaltime = $a_data['totaltime']; $end_date = $a_data['end_date']; $params = array('totaltime' => $totaltime, 'end_date' => $end_date); $ptState = new PluginTimelineticketState(); $ptState->showTimeline($ticket, $params); $ptAssignGroup = new PluginTimelineticketAssignGroup(); $ptAssignGroup->showTimeline($ticket, $params); $ptAssignUser = new PluginTimelineticketAssignUser(); $ptAssignUser->showTimeline($ticket, $params); echo "</table>"; PluginTimelineticketToolbox::ShowDetail($ticket, 'group'); PluginTimelineticketToolbox::ShowDetail($ticket, 'user'); if ($_SESSION['glpi_use_mode'] == Session::DEBUG_MODE) { echo "<br><table class='tab_cadre_fixe'>"; echo "<tr>"; echo "<th colspan='5'>" . __('DEBUG') . " " . __('Group') . "</th>"; echo "</tr>"; echo "<tr>"; echo "<th>" . __('ID') . "</th>"; echo "<th>" . __('Date') . "</th>"; echo "<th>" . __('Group') . "</th>"; echo "<th>" . __('Begin') . "</th>"; echo "<th>" . __('Delay', 'timelineticket') . "</th>"; echo "</tr>"; $query = "SELECT *\n FROM `glpi_plugin_timelineticket_assigngroups`\n WHERE `tickets_id` = '" . $ticket->getID() . "'"; $result = $DB->query($query); while ($data = $DB->fetch_assoc($result)) { echo "<tr class='tab_bg_1'>"; echo "<td>" . $data['id'] . "</td>"; echo "<td>" . Html::convDateTime($data['date']) . "</td>"; echo "<td>" . Dropdown::getDropdownName("glpi_groups", $data['groups_id']) . "</td>"; echo "<td>" . Html::timestampToString($data['begin']) . "</td>"; echo "<td>" . Html::timestampToString($data['delay']) . "</td>"; echo "</tr>"; } echo "</table>"; echo "<br><table class='tab_cadre_fixe'>"; echo "<tr>"; echo "<th colspan='5'>" . __('DEBUG') . " " . __('Technician') . "</th>"; echo "</tr>"; echo "<tr>"; echo "<th>" . __('ID') . "</th>"; echo "<th>" . __('Date') . "</th>"; echo "<th>" . __('Technician') . "</th>"; echo "<th>" . __('Begin') . "</th>"; echo "<th>" . __('Delay', 'timelineticket') . "</th>"; echo "</tr>"; $query = "SELECT *\n FROM `glpi_plugin_timelineticket_assignusers`\n WHERE `tickets_id` = '" . $ticket->getID() . "'"; $result = $DB->query($query); while ($data = $DB->fetch_assoc($result)) { echo "<tr class='tab_bg_1'>"; echo "<td>" . $data['id'] . "</td>"; echo "<td>" . Html::convDateTime($data['date']) . "</td>"; echo "<td>" . getUserName($data['users_id']) . "</td>"; echo "<td>" . Html::timestampToString($data['begin']) . "</td>"; echo "<td>" . Html::timestampToString($data['delay']) . "</td>"; echo "</tr>"; } echo "</table>"; } }