/** * Return array with all data * * @param Ticket $ticket * @param type $type 'user' or 'group' * @param type $withblank option to fill blank zones * * @return type */ static function getDetails(Ticket $ticket, $type, $withblank = 1) { if ($type == 'group') { $palette = array(array('250', '151', '186'), array('255', '211', '112'), array('183', '210', '118'), array('117', '199', '187'), array('188', '168', '208'), array('186', '213', '118'), array('124', '169', '0'), array('168', '208', '49'), array('239', '215', '113'), array('235', '155', '0'), array('235', '249', '255'), array('193', '228', '250'), array('164', '217', '250'), array('88', '195', '240'), array('0', '156', '231'), array('198', '229', '111'), array('234', '38', '115'), array('245', '122', '160'), array('255', '208', '220')); } else { if ($type == 'user') { $palette = array(array('164', '53', '86'), array('137', '123', '78'), array('192', '114', '65'), array('143', '102', '98'), array('175', '105', '93'), array('186', '127', '61'), array('174', '104', '92'), array('213', '113', '63'), array('185', '168', '122'), array('233', '168', '112'), array('199', '133', '99'), array('80', '24', '69'), array('133', '39', '65'), array('120', '22', '61'), array('114', '59', '82'), array('245', '229', '195')); } } $ptState = new PluginTimelineticketState(); $a_ret = PluginTimelineticketDisplay::getTotaltimeEnddate($ticket); $totaltime = $a_ret['totaltime']; if ($type == 'group') { $ptItem = new PluginTimelineticketAssignGroup(); } else { if ($type == 'user') { $ptItem = new PluginTimelineticketAssignUser(); } } $a_states = array(); $a_item_palette = array(); $a_dbstates = $ptState->find("`tickets_id`='" . $ticket->getField('id') . "'", "date"); $end_previous = 0; foreach ($a_dbstates as $a_dbstate) { $end_previous += $a_dbstate['delay']; if ($a_dbstate['old_status'] == '') { $a_dbstate['old_status'] = 0; } if (isset($a_states[$end_previous])) { $end_previous++; } $a_states[$end_previous] = $a_dbstate['old_status']; } if (isset($a_dbstate['new_status']) && $a_dbstate['new_status'] != Ticket::CLOSED) { $a_states[$totaltime] = $a_dbstate['new_status']; } $a_itemsections = array(); $a_dbitems = $ptItem->find("`tickets_id`='" . $ticket->getField('id') . "'", "`date`"); foreach ($a_dbitems as $a_dbitem) { if ($type == 'group') { $items_id = 'groups_id'; } else { if ($type == 'user') { $items_id = 'users_id'; } } if (!isset($a_itemsections[$a_dbitem[$items_id]])) { $a_itemsections[$a_dbitem[$items_id]] = array(); $last_statedelay = 0; } else { foreach ($a_itemsections[$a_dbitem[$items_id]] as $data) { $last_statedelay = $data['End']; } } if (!isset($a_item_palette[$a_dbitem[$items_id]])) { $a_item_palette[$a_dbitem[$items_id]] = array_shift($palette); } $color_R = $a_item_palette[$a_dbitem[$items_id]][0]; $color_G = $a_item_palette[$a_dbitem[$items_id]][1]; $color_B = $a_item_palette[$a_dbitem[$items_id]][2]; $gbegin = $a_dbitem['begin']; if ($a_dbitem['delay'] == '') { $gdelay = $totaltime; } else { $gdelay = $a_dbitem['begin'] + $a_dbitem['delay']; } $mem = 0; $old_delay = 0; foreach ($a_states as $delay => $statusname) { if ($mem == 1) { if ($gdelay > $delay) { // all time of the state $a_itemsections[$a_dbitem[$items_id]][] = array('Start' => $gbegin, 'End' => $delay, "Caption" => "", "Status" => $statusname, "R" => $color_R, "G" => $color_G, "B" => $color_B); $gbegin = $delay; } else { if ($gdelay == $delay) { // end of status = end of group $a_itemsections[$a_dbitem[$items_id]][] = array('Start' => $gbegin, 'End' => $delay, "Caption" => "", "Status" => $statusname, "R" => $color_R, "G" => $color_G, "B" => $color_B); $mem = 2; } else { // end of status is after end of group $a_itemsections[$a_dbitem[$items_id]][] = array('Start' => $gbegin, 'End' => $gdelay, "Caption" => "", "Status" => $statusname, "R" => $color_R, "G" => $color_G, "B" => $color_B); $mem = 2; } } } else { if ($mem == 0 && $gbegin < $delay) { if ($withblank && $gbegin != $last_statedelay) { $a_itemsections[$a_dbitem[$items_id]][] = array('Start' => $last_statedelay, 'End' => $gbegin, "Caption" => "", "Status" => "", "R" => 235, "G" => 235, "B" => 235); } if ($gdelay > $delay) { // all time of the state $a_itemsections[$a_dbitem[$items_id]][] = array('Start' => $gbegin, 'End' => $delay, "Caption" => "", "Status" => $statusname, "R" => $color_R, "G" => $color_G, "B" => $color_B); $gbegin = $delay; $mem = 1; } else { if ($gdelay == $delay) { // end of status = end of group $a_itemsections[$a_dbitem[$items_id]][] = array('Start' => $gbegin, 'End' => $delay, "Caption" => "", "Status" => $statusname, "R" => $color_R, "G" => $color_G, "B" => $color_B); $mem = 2; } else { // end of status is after end of group $a_itemsections[$a_dbitem[$items_id]][] = array('Start' => $gbegin, 'End' => $gdelay, "Caption" => "", "Status" => $statusname, "R" => $color_R, "G" => $color_G, "B" => $color_B); $mem = 2; } } } } $old_delay = $delay; } } if ($withblank) { end($a_states); $verylastdelayStateDB = key($a_states); foreach ($a_itemsections as $items_id => $data_f) { $last = 0; $R = 235; $G = 235; $B = 235; $statusname = ''; $a_end = end($data_f); $last = $a_end['End']; if ($ticket->fields['status'] != Ticket::CLOSED && $last == $verylastdelayStateDB) { $R = $a_end['R']; $G = $a_end['G']; $B = $a_end['B']; $statusname = $a_end['Status']; } if ($last < $totaltime) { $a_itemsections[$items_id][] = array('Start' => $last, 'End' => $totaltime, "Caption" => "", "Status" => $statusname, "R" => $R, "G" => $G, "B" => $B); } } } return $a_itemsections; }
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>"; } }
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'); }
private function totaltimeEnddateOfTicket() { global $DB; $DB->connect(); $ticket = new Ticket(); // $a_storedate_temp = self::$storedate; $ticket->getFromDB(1); $a_data = PluginTimelineticketDisplay::getTotaltimeEnddate($ticket); $totaltime_ref = 0; $a_states = getAllDatasFromTable('glpi_plugin_timelineticket_states', '', FALSE, 'id'); foreach ($a_states as $data) { $totaltime_ref += $data['delay']; } $this->assertEquals($totaltime_ref, $a_data['totaltime'], 'Totaltime of ticket (without hours of calendar'); }