/**
* @see NotificationTargetCommonITILObject::getDatasForObject()
**/
function getDatasForObject(CommonDBTM $item, array $options, $simple = false)
{
global $CFG_GLPI;
// Common ITIL datas
$datas = parent::getDatasForObject($item, $options, $simple);
$datas['##ticket.description##'] = Html::clean($datas['##ticket.description##']);
$datas['##ticket.description##'] = $item->convertContentForNotification($datas['##ticket.description##'], $item);
$datas['##ticket.content##'] = $datas['##ticket.description##'];
// Specific datas
$datas['##ticket.urlvalidation##'] = $this->formatURL($options['additionnaloption']['usertype'], "ticket_" . $item->getField("id") . "_TicketValidation\$1");
$datas['##ticket.globalvalidation##'] = TicketValidation::getStatus($item->getField('global_validation'));
$datas['##ticket.type##'] = Ticket::getTicketTypeName($item->getField('type'));
$datas['##ticket.requesttype##'] = Dropdown::getDropdownName('glpi_requesttypes', $item->getField('requesttypes_id'));
$autoclose_value = Entity::getUsedConfig('autoclose_delay', $this->getEntity(), '', Entity::CONFIG_NEVER);
$datas['##ticket.autoclose##'] = __('Never');
$datas['##lang.ticket.autoclosewarning##'] = "";
if ($autoclose_value > 0) {
$datas['##ticket.autoclose##'] = $autoclose_value;
$datas['##lang.ticket.autoclosewarning##'] = sprintf(_n('Without a reply, the ticket will be automatically closed after %s day', 'Without a reply, the ticket will be automatically closed after %s days', $autoclose_value), $autoclose_value);
}
$datas['##ticket.sla##'] = '';
if ($item->getField('slas_id')) {
$datas['##ticket.sla##'] = Dropdown::getDropdownName('glpi_slas', $item->getField('slas_id'));
}
$datas['##ticket.location##'] = '';
if ($item->getField('locations_id')) {
$datas['##ticket.location##'] = Dropdown::getDropdownName('glpi_locations', $item->getField('locations_id'));
}
// is ticket deleted
$datas['##ticket.isdeleted##'] = Dropdown::getYesNo($item->getField('is_deleted'));
//Tags associated with the object linked to the ticket
$datas['##ticket.itemtype##'] = '';
$datas['##ticket.item.name##'] = '';
$datas['##ticket.item.serial##'] = '';
$datas['##ticket.item.otherserial##'] = '';
$datas['##ticket.item.location##'] = '';
$datas['##ticket.item.contact##'] = '';
$datas['##ticket.item.contactnumber##'] = '';
$datas['##ticket.item.user##'] = '';
$datas['##ticket.item.group##'] = '';
$datas['##ticket.item.model##'] = '';
$item_ticket = new Item_Ticket();
$items = $item_ticket->find("`tickets_id` = '" . $item->getField('id') . "'");
$datas['items'] = array();
if (count($items)) {
foreach ($items as $val) {
if (isset($val['itemtype']) && ($hardware = getItemForItemtype($val['itemtype'])) && isset($val["items_id"]) && $hardware->getFromDB($val["items_id"])) {
$tmp = array();
//Object type
$tmp['##ticket.itemtype##'] = $hardware->getTypeName();
//Object name
$tmp['##ticket.item.name##'] = $hardware->getField('name');
//Object serial
if ($hardware->isField('serial')) {
$tmp['##ticket.item.serial##'] = $hardware->getField('serial');
}
//Object contact
if ($hardware->isField('contact')) {
$tmp['##ticket.item.contact##'] = $hardware->getField('contact');
}
//Object contact num
if ($hardware->isField('contact_num')) {
$tmp['##ticket.item.contactnumber##'] = $hardware->getField('contact_num');
}
//Object otherserial
if ($hardware->isField('otherserial')) {
$tmp['##ticket.item.otherserial##'] = $hardware->getField('otherserial');
}
//Object location
if ($hardware->isField('locations_id')) {
$tmp['##ticket.item.location##'] = Dropdown::getDropdownName('glpi_locations', $hardware->getField('locations_id'));
}
//Object user
if ($hardware->getField('users_id')) {
$user_tmp = new User();
if ($user_tmp->getFromDB($hardware->getField('users_id'))) {
$tmp['##ticket.item.user##'] = $user_tmp->getName();
}
}
//Object group
if ($hardware->getField('groups_id')) {
$tmp['##ticket.item.group##'] = Dropdown::getDropdownName('glpi_groups', $hardware->getField('groups_id'));
}
$modeltable = getSingular($hardware->getTable()) . "models";
$modelfield = getForeignKeyFieldForTable($modeltable);
if ($hardware->isField($modelfield)) {
$tmp['##ticket.item.model##'] = Dropdown::getDropdownName($modeltable, $hardware->getField($modelfield));
}
$datas['items'][] = $tmp;
}
}
}
$datas['##ticket.numberofitems##'] = count($datas['items']);
// Get followups, log, validation, satisfaction, linked tickets
if (!$simple) {
// Linked tickets
$linked_tickets = Ticket_Ticket::getLinkedTicketsTo($item->getField('id'));
$datas['linkedtickets'] = array();
if (count($linked_tickets)) {
$linkedticket = new Ticket();
foreach ($linked_tickets as $data) {
if ($linkedticket->getFromDB($data['tickets_id'])) {
$tmp = array();
$tmp['##linkedticket.id##'] = $data['tickets_id'];
$tmp['##linkedticket.link##'] = Ticket_Ticket::getLinkName($data['link']);
$tmp['##linkedticket.url##'] = $this->formatURL($options['additionnaloption']['usertype'], "ticket_" . $data['tickets_id']);
$tmp['##linkedticket.title##'] = $linkedticket->getField('name');
$tmp['##linkedticket.content##'] = $linkedticket->getField('content');
$datas['linkedtickets'][] = $tmp;
}
}
}
$datas['##ticket.numberoflinkedtickets##'] = count($datas['linkedtickets']);
$restrict = "`tickets_id`='" . $item->getField('id') . "'";
$problems = getAllDatasFromTable('glpi_problems_tickets', $restrict);
$datas['problems'] = array();
if (count($problems)) {
$problem = new Problem();
foreach ($problems as $data) {
if ($problem->getFromDB($data['problems_id'])) {
$tmp = array();
$tmp['##problem.id##'] = $data['problems_id'];
$tmp['##problem.date##'] = $problem->getField('date');
$tmp['##problem.title##'] = $problem->getField('name');
$tmp['##problem.url##'] = $this->formatURL($options['additionnaloption']['usertype'], "problem_" . $data['problems_id']);
$tmp['##problem.content##'] = $problem->getField('content');
$datas['problems'][] = $tmp;
}
}
}
$datas['##ticket.numberofproblems##'] = count($datas['problems']);
$restrict = "`tickets_id`='" . $item->getField('id') . "'";
$changes = getAllDatasFromTable('glpi_changes_tickets', $restrict);
$datas['changes'] = array();
if (count($changes)) {
$change = new Change();
foreach ($changes as $data) {
if ($change->getFromDB($data['changes_id'])) {
$tmp = array();
$tmp['##change.id##'] = $data['changes_id'];
$tmp['##change.date##'] = $change->getField('date');
$tmp['##change.title##'] = $change->getField('name');
$tmp['##change.url##'] = $this->formatURL($options['additionnaloption']['usertype'], "change_" . $data['changes_id']);
$tmp['##change.content##'] = $change->getField('content');
$datas['changes'][] = $tmp;
}
}
}
$datas['##ticket.numberofchanges##'] = count($datas['changes']);
if (!isset($options['additionnaloption']['show_private']) || !$options['additionnaloption']['show_private']) {
$restrict .= " AND `is_private` = '0'";
}
$restrict .= " ORDER BY `date` DESC, `id` ASC";
//Followup infos
$followups = getAllDatasFromTable('glpi_ticketfollowups', $restrict);
$datas['followups'] = array();
foreach ($followups as $followup) {
$tmp = array();
$tmp['##followup.isprivate##'] = Dropdown::getYesNo($followup['is_private']);
$tmp['##followup.author##'] = Html::clean(getUserName($followup['users_id']));
$tmp['##followup.requesttype##'] = Dropdown::getDropdownName('glpi_requesttypes', $followup['requesttypes_id']);
$tmp['##followup.date##'] = Html::convDateTime($followup['date']);
$tmp['##followup.description##'] = $followup['content'];
$datas['followups'][] = $tmp;
}
$datas['##ticket.numberoffollowups##'] = count($datas['followups']);
// Approbation of solution
$restrict .= " LIMIT 1";
$replysolved = getAllDatasFromTable('glpi_ticketfollowups', $restrict);
$data = current($replysolved);
$datas['##ticket.solution.approval.description##'] = $data['content'];
$datas['##ticket.solution.approval.date##'] = Html::convDateTime($data['date']);
$datas['##ticket.solution.approval.author##'] = Html::clean(getUserName($data['users_id']));
//Validation infos
$restrict = "`tickets_id`='" . $item->getField('id') . "'";
if (isset($options['validation_id']) && $options['validation_id']) {
$restrict .= " AND `glpi_ticketvalidations`.`id` = '" . $options['validation_id'] . "'";
}
$restrict .= " ORDER BY `submission_date` DESC, `id` ASC";
$validations = getAllDatasFromTable('glpi_ticketvalidations', $restrict);
$datas['validations'] = array();
foreach ($validations as $validation) {
$tmp = array();
$tmp['##validation.submission.title##'] = sprintf(__('An approval request has been submitted by %s'), Html::clean(getUserName($validation['users_id'])));
$tmp['##validation.answer.title##'] = sprintf(__('An answer to an an approval request was produced by %s'), Html::clean(getUserName($validation['users_id_validate'])));
$tmp['##validation.author##'] = Html::clean(getUserName($validation['users_id']));
$tmp['##validation.status##'] = TicketValidation::getStatus($validation['status']);
$tmp['##validation.storestatus##'] = $validation['status'];
$tmp['##validation.submissiondate##'] = Html::convDateTime($validation['submission_date']);
$tmp['##validation.commentsubmission##'] = $validation['comment_submission'];
$tmp['##validation.validationdate##'] = Html::convDateTime($validation['validation_date']);
$tmp['##validation.validator##'] = Html::clean(getUserName($validation['users_id_validate']));
$tmp['##validation.commentvalidation##'] = $validation['comment_validation'];
$datas['validations'][] = $tmp;
}
// Ticket Satisfaction
$inquest = new TicketSatisfaction();
$datas['##satisfaction.type##'] = '';
$datas['##satisfaction.datebegin##'] = '';
$datas['##satisfaction.dateanswered##'] = '';
$datas['##satisfaction.satisfaction##'] = '';
$datas['##satisfaction.description##'] = '';
if ($inquest->getFromDB($item->getField('id'))) {
// internal inquest
if ($inquest->fields['type'] == 1) {
$datas['##ticket.urlsatisfaction##'] = $this->formatURL($options['additionnaloption']['usertype'], "ticket_" . $item->getField("id") . '_Ticket$3');
// external inquest
} else {
if ($inquest->fields['type'] == 2) {
$datas['##ticket.urlsatisfaction##'] = Entity::generateLinkSatisfaction($item);
}
}
$datas['##satisfaction.type##'] = $inquest->getTypeInquestName($inquest->getfield('type'));
$datas['##satisfaction.datebegin##'] = Html::convDateTime($inquest->fields['date_begin']);
$datas['##satisfaction.dateanswered##'] = Html::convDateTime($inquest->fields['date_answered']);
$datas['##satisfaction.satisfaction##'] = $inquest->fields['satisfaction'];
$datas['##satisfaction.description##'] = $inquest->fields['comment'];
}
}
return $datas;
}
/**
* @since version 0.84 (before in entitydata.class)
*
* @param $field
* @param $values
* @param $options array
**/
static function getSpecificValueToDisplay($field, $values, array $options = array())
{
if (!is_array($values)) {
$values = array($field => $values);
}
switch ($field) {
case 'use_licenses_alert':
case 'use_contracts_alert':
case 'use_infocoms_alert':
case 'is_notif_enable_default':
if ($values[$field] == self::CONFIG_PARENT) {
return __('Inheritance of the parent entity');
}
return Dropdown::getYesNo($values[$field]);
case 'use_reservations_alert':
switch ($values[$field]) {
case self::CONFIG_PARENT:
return __('Inheritance of the parent entity');
case 0:
return __('Never');
}
return sprintf(_n('%d hour', '%d hours', $values[$field]), $values[$field]);
case 'default_cartridges_alarm_threshold':
case 'default_consumables_alarm_threshold':
switch ($values[$field]) {
case self::CONFIG_PARENT:
return __('Inheritance of the parent entity');
case 0:
return __('Never');
}
return $values[$field];
case 'send_contracts_alert_before_delay':
case 'send_infocoms_alert_before_delay':
case 'send_licenses_alert_before_delay':
switch ($values[$field]) {
case self::CONFIG_PARENT:
return __('Inheritance of the parent entity');
case 0:
return __('No');
}
return sprintf(_n('%d day', '%d days', $values[$field]), $values[$field]);
case 'cartridges_alert_repeat':
case 'consumables_alert_repeat':
switch ($values[$field]) {
case self::CONFIG_PARENT:
return __('Inheritance of the parent entity');
case self::CONFIG_NEVER:
case 0:
// For compatibility issue
return __('Never');
case DAY_TIMESTAMP:
return __('Each day');
case WEEK_TIMESTAMP:
return __('Each week');
case MONTH_TIMESTAMP:
return __('Each month');
default:
// Display value if not defined
return $values[$field];
}
break;
case 'notclosed_delay':
// 0 means never
switch ($values[$field]) {
case self::CONFIG_PARENT:
return __('Inheritance of the parent entity');
case 0:
return __('Never');
}
return sprintf(_n('%d day', '%d days', $values[$field]), $values[$field]);
case 'auto_assign_mode':
return self::getAutoAssignMode($values[$field]);
case 'tickettype':
if ($values[$field] == self::CONFIG_PARENT) {
return __('Inheritance of the parent entity');
}
return Ticket::getTicketTypeName($values[$field]);
case 'autofill_buy_date':
case 'autofill_order_date':
case 'autofill_delivery_date':
case 'autofill_use_date':
case 'autofill_warranty_date':
switch ($values[$field]) {
case self::CONFIG_PARENT:
return __('Inheritance of the parent entity');
case Infocom::COPY_WARRANTY_DATE:
return __('Copy the start date of warranty');
case Infocom::COPY_BUY_DATE:
return __('Copy the date of purchase');
case Infocom::COPY_ORDER_DATE:
return __('Copy the order date');
case Infocom::COPY_DELIVERY_DATE:
return __('Copy the delivery date');
default:
if (strstr($values[$field], '_')) {
list($type, $sid) = explode('_', $values[$field], 2);
if ($type == Infocom::ON_STATUS_CHANGE) {
// TRANS %s is the name of the state
return sprintf(__('Fill when shifting to state %s'), Dropdown::getDropdownName('glpi_states', $sid));
}
}
}
return __('No autofill');
case 'inquest_config':
if ($values[$field] == self::CONFIG_PARENT) {
return __('Inheritance of the parent entity');
}
return TicketSatisfaction::getTypeInquestName($values[$field]);
case 'default_contract_alert':
return Contract::getAlertName($values[$field]);
case 'default_infocom_alert':
return Infocom::getAlertName($values[$field]);
case 'entities_id_software':
if ($values[$field] == self::CONFIG_NEVER) {
return __('No change of entity');
}
if ($values[$field] == self::CONFIG_PARENT) {
return __('Inheritance of the parent entity');
}
return Dropdown::getDropdownName('glpi_entities', $values[$field]);
case 'tickettemplates_id':
if ($values[$field] == self::CONFIG_PARENT) {
return __('Inheritance of the parent entity');
}
return Dropdown::getDropdownName('glpi_tickettemplates', $values[$field]);
case 'calendars_id':
switch ($values[$field]) {
case self::CONFIG_PARENT:
return __('Inheritance of the parent entity');
case 0:
return __('24/7');
}
return Dropdown::getDropdownName('glpi_calendars', $values[$field]);
}
return parent::getSpecificValueToDisplay($field, $values, $options);
}
/**
* Generic Function to display Items
*
* @param $itemtype item type
* @param $ID ID of the SEARCH_OPTION item
* @param $data array containing data results
* @param $num item num in the request
* @param $meta is a meta item ?
*
* @return string to print
**/
static function giveItem($itemtype, $ID, $data, $num, $meta = 0)
{
global $CFG_GLPI, $LANG;
$searchopt =& self::getOptions($itemtype);
if (isset($CFG_GLPI["union_search_type"][$itemtype]) && $CFG_GLPI["union_search_type"][$itemtype] == $searchopt[$ID]["table"]) {
return self::giveItem($data["TYPE"], $ID, $data, $num, $meta);
}
// Plugin can override core definition for its type
if ($plug = isPluginItemType($itemtype)) {
$function = 'plugin_' . $plug['plugin'] . '_giveItem';
if (function_exists($function)) {
$out = $function($itemtype, $ID, $data, $num);
if (!empty($out)) {
return $out;
}
}
}
$NAME = "ITEM_";
if ($meta) {
$NAME = "META_";
}
$table = $searchopt[$ID]["table"];
$field = $searchopt[$ID]["field"];
$linkfield = $searchopt[$ID]["linkfield"];
switch ($table . '.' . $field) {
case "glpi_users.name":
// USER search case
if ($itemtype != 'User' && isset($searchopt[$ID]["forcegroupby"]) && $searchopt[$ID]["forcegroupby"]) {
$out = "";
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$count_display = 0;
$added = array();
for ($k = 0; $k < count($split); $k++) {
if ($split[$k] > 0) {
if ($count_display) {
$out .= "<br>";
}
$count_display++;
if ($itemtype == 'Ticket') {
$userdata = getUserName($split[$k], 2);
$out .= $userdata['name'] . " " . showToolTip($userdata["comment"], array('link' => $userdata["link"], 'display' => false));
} else {
$out .= getUserName($split[$k], 1);
}
}
}
// Manage alternative_email for tickets_users
if ($itemtype == 'Ticket' && isset($data[$NAME . $num . '_2'])) {
$split = explode("\$\$\$\$", $data[$NAME . $num . '_2']);
for ($k = 0; $k < count($split); $k++) {
$split2 = explode(" ", $split[$k]);
if (count($split2) == 2 && $split2[0] == 0 && !empty($split2[1])) {
if ($count_display) {
$out .= "<br>";
}
$count_display++;
$out .= "<a href='mailto:" . $split2[1] . "'>" . $split2[1] . "</a>";
}
}
}
return $out;
}
if ($itemtype != 'User') {
$toadd = '';
if ($itemtype == 'Ticket' && $data[$NAME . $num . "_3"] > 0) {
$userdata = getUserName($data[$NAME . $num . "_3"], 2);
$toadd = " " . showToolTip($userdata["comment"], array('link' => $userdata["link"], 'display' => false));
}
return formatUserName($data[$NAME . $num . "_3"], $data[$NAME . $num], $data[$NAME . $num . "_2"], $data[$NAME . $num . "_4"], 1) . $toadd;
}
break;
case "glpi_profiles.interface":
return Profile::getInterfaceName($data[$NAME . $num]);
case "glpi_profiles.name":
if ($itemtype == 'User' && $ID == 20) {
$out = "";
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$split2 = explode("\$\$\$\$", $data[$NAME . $num . "_2"]);
$split3 = explode("\$\$\$\$", $data[$NAME . $num . "_3"]);
$count_display = 0;
$added = array();
for ($k = 0; $k < count($split); $k++) {
if (strlen(trim($split[$k])) > 0) {
$text = $split[$k] . " - " . Dropdown::getDropdownName('glpi_entities', $split2[$k]);
if ($split3[$k]) {
$text .= " (R)";
}
if (!in_array($text, $added)) {
if ($count_display) {
$out .= "<br>";
}
$count_display++;
$out .= $text;
$added[] = $text;
}
}
}
return $out;
}
break;
case "glpi_complete_entities.completename":
if ($itemtype == 'User') {
$out = "";
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$split2 = explode("\$\$\$\$", $data[$NAME . $num . "_2"]);
$split3 = explode("\$\$\$\$", $data[$NAME . $num . "_3"]);
$added = array();
$count_display = 0;
for ($k = 0; $k < count($split); $k++) {
if (strlen(trim($split[$k])) > 0) {
$text = $split[$k] . " - " . Dropdown::getDropdownName('glpi_profiles', $split2[$k]);
if ($split3[$k]) {
$text .= " (R)";
}
if (!in_array($text, $added)) {
if ($count_display) {
$out .= "<br>";
}
$count_display++;
$out .= $text;
$added[] = $text;
}
}
}
return $out;
}
break;
case "glpi_entities.completename":
if ($data[$NAME . $num . "_2"] == 0) {
// Set name for Root entity
$data[$NAME . $num] = $LANG['entity'][2];
}
break;
case "glpi_documenttypes.icon":
if (!empty($data[$NAME . $num])) {
return "<img class='middle' alt='' src='" . $CFG_GLPI["typedoc_icon_dir"] . "/" . $data[$NAME . $num] . "'>";
}
return " ";
case "glpi_documents.filename":
$doc = new Document();
if ($doc->getFromDB($data['id'])) {
return $doc->getDownloadLink();
}
return NOT_AVAILABLE;
case "glpi_deviceharddrives.specificity":
case "glpi_devicememories.specificity":
case "glpi_deviceprocessors.specificity":
return $data[$NAME . $num];
case "glpi_networkports.mac":
$out = "";
if ($itemtype == 'Computer') {
$displayed = array();
if (!empty($data[$NAME . $num . "_2"])) {
$split = explode("\$\$\$\$", $data[$NAME . $num . "_2"]);
$count_display = 0;
for ($k = 0; $k < count($split); $k++) {
$lowstr = utf8_strtolower($split[$k]);
if (strlen(trim($split[$k])) > 0 && !in_array($lowstr, $displayed)) {
if ($count_display) {
$out .= "<br>";
}
$count_display++;
$out .= $split[$k];
$displayed[] = $lowstr;
}
}
if (!empty($data[$NAME . $num])) {
$out .= "<br>";
}
}
if (!empty($data[$NAME . $num])) {
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$count_display = 0;
for ($k = 0; $k < count($split); $k++) {
$lowstr = utf8_strtolower($split[$k]);
if (strlen(trim($split[$k])) > 0 && !in_array($lowstr, $displayed)) {
if ($count_display) {
$out .= "<br>";
}
$count_display++;
$out .= $split[$k];
$displayed[] = $lowstr;
}
}
}
return $out;
}
break;
case "glpi_contracts.duration":
case "glpi_contracts.notice":
case "glpi_contracts.periodicity":
case "glpi_contracts.billing":
if (!empty($data[$NAME . $num])) {
$split = explode('$$$$', $data[$NAME . $num]);
$output = "";
foreach ($split as $duration) {
$output .= (empty($output) ? '' : '<br>') . $duration . " " . $LANG['financial'][57];
}
return $output;
}
return " ";
case "glpi_contracts.renewal":
return Contract::getContractRenewalName($data[$NAME . $num]);
case "glpi_infocoms.sink_time":
if (!empty($data[$NAME . $num])) {
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$out = '';
foreach ($split as $val) {
$out .= empty($out) ? '' : '<br>';
if ($val > 0) {
$out .= $val . " " . $LANG['financial'][9];
}
}
return $out;
}
return " ";
case "glpi_infocoms.warranty_duration":
if (!empty($data[$NAME . $num])) {
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$out = '';
foreach ($split as $val) {
$out .= empty($out) ? '' : '<br>';
if ($val > 0) {
$out .= $val . " " . $LANG['financial'][57];
}
if ($val < 0) {
$out .= $LANG['financial'][2];
}
}
return $out;
}
return " ";
case "glpi_infocoms.sink_type":
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$out = '';
foreach ($split as $val) {
$out .= (empty($out) ? '' : '<br>') . Infocom::getAmortTypeName($val);
}
return $out;
case "glpi_infocoms.alert":
if ($data[$NAME . $num] == pow(2, Alert::END)) {
return $LANG['financial'][80];
}
return "";
case "glpi_contracts.alert":
switch ($data[$NAME . $num]) {
case pow(2, Alert::END):
return $LANG['buttons'][32];
case pow(2, Alert::NOTICE):
return $LANG['financial'][10];
case pow(2, Alert::END) + pow(2, Alert::NOTICE):
return $LANG['buttons'][32] . " + " . $LANG['financial'][10];
}
return "";
case "glpi_tickets_tickets.tickets_id_1":
$out = "";
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$split2 = explode("\$\$\$\$", $data[$NAME . $num . "_2"]);
$displayed = array();
for ($k = 0; $k < count($split); $k++) {
$linkid = $split[$k] == $data['id'] ? $split2[$k] : $split[$k];
if ($linkid > 0 && !isset($displayed[$linkid])) {
$text = $linkid . " - " . Dropdown::getDropdownName('glpi_tickets', $linkid);
if (count($displayed)) {
$out .= "<br>";
}
$displayed[$linkid] = $linkid;
$out .= $text;
}
}
return $out;
case "glpi_tickets.count":
if ($data[$NAME . $num] > 0 && haveRight("show_all_ticket", "1")) {
if ($itemtype == 'User') {
$options['field'][0] = 4;
$options['searchtype'][0] = 'equals';
$options['contains'][0] = $data['id'];
$options['link'][0] = 'AND';
$options['field'][1] = 22;
$options['searchtype'][1] = 'equals';
$options['contains'][1] = $data['id'];
$options['link'][1] = 'OR';
$options['field'][2] = 5;
$options['searchtype'][2] = 'equals';
$options['contains'][2] = $data['id'];
$options['link'][2] = 'OR';
} else {
$options['field'][0] = 12;
$options['searchtype'][0] = 'equals';
$options['contains'][0] = 'all';
$options['link'][0] = 'AND';
$options['itemtype2'][0] = $itemtype;
$options['field2'][0] = self::getOptionNumber($itemtype, 'name');
$options['searchtype2'][0] = 'equals';
$options['contains2'][0] = $data['id'];
$options['link2'][0] = 'AND';
}
$options['reset'] = 'reset';
$out = "<a id='ticket{$itemtype}" . $data['id'] . "' ";
$out .= "href=\"" . $CFG_GLPI["root_doc"] . "/front/ticket.php?" . append_params($options, '&') . "\">";
$out .= $data[$NAME . $num] . "</a>";
} else {
$out = $data[$NAME . $num];
}
return $out;
case "glpi_softwarelicenses.number":
if ($data[$NAME . $num . "_2"] == -1) {
return $LANG['software'][4];
}
if (empty($data[$NAME . $num])) {
return 0;
}
return $data[$NAME . $num];
case "glpi_auth_tables.name":
return Auth::getMethodName($data[$NAME . $num], $data[$NAME . $num . "_2"], 1, $data[$NAME . $num . "_3"] . $data[$NAME . $num . "_4"]);
case "glpi_reservationitems.comment":
if (empty($data[$NAME . $num])) {
return "<a title=\"" . $LANG['reservation'][22] . "\"\n href='" . $CFG_GLPI["root_doc"] . "/front/reservationitem.form.php?id=" . $data["refID"] . "' >" . $LANG['common'][49] . "</a>";
}
return "<a title=\"" . $LANG['reservation'][22] . "\"\n href='" . $CFG_GLPI["root_doc"] . "/front/reservationitem.form.php?id=" . $data['refID'] . "' >" . resume_text($data[$NAME . $num]) . "</a>";
case 'glpi_notifications.mode':
return Notification::getMode($data[$NAME . $num]);
case 'glpi_notifications.event':
$item = NotificationTarget::getInstanceByType($data['itemtype']);
if ($item) {
$events = $item->getAllEvents();
return $events[$data[$NAME . $num]];
}
return '';
case 'glpi_crontasks.description':
$tmp = new CronTask();
return $tmp->getDescription($data['id']);
case 'glpi_crontasks.state':
return CronTask::getStateName($data[$NAME . $num]);
case 'glpi_crontasks.mode':
return CronTask::getModeName($data[$NAME . $num]);
case 'glpi_crontasks.itemtype':
if ($plug = isPluginItemType($data[$NAME . $num])) {
return $plug['plugin'];
}
return '';
case 'glpi_tickets.status':
$status = Ticket::getStatus($data[$NAME . $num]);
return "<img src=\"" . $CFG_GLPI["root_doc"] . "/pics/" . $data[$NAME . $num] . ".png\"\n alt=\"{$status}\" title=\"{$status}\"> {$status}";
case 'glpi_tickets.type':
return Ticket::getTicketTypeName($data[$NAME . $num]);
case 'glpi_tickets.priority':
return Ticket::getPriorityName($data[$NAME . $num]);
case 'glpi_tickets.urgency':
return Ticket::getUrgencyName($data[$NAME . $num]);
case 'glpi_tickets.impact':
return Ticket::getImpactName($data[$NAME . $num]);
case 'glpi_tickets.items_id':
if (!empty($data[$NAME . $num . "_2"]) && class_exists($data[$NAME . $num . "_2"])) {
$item = new $data[$NAME . $num . "_2"]();
if ($item->getFromDB($data[$NAME . $num])) {
return $item->getLink(true);
}
}
return ' ';
case 'glpi_tickets.name':
$link = getItemTypeFormURL('Ticket');
$out = "<a id='ticket" . $data[$NAME . $num . "_2"] . "' href=\"" . $link;
$out .= strstr($link, '?') ? '&' : '?';
$out .= 'id=' . $data[$NAME . $num . "_2"];
// Force solution tab if solved
if ($data[$NAME . $num . "_4"] == 'solved') {
$out .= "&forcetab=4";
}
$out .= "\">" . $data[$NAME . $num];
if ($_SESSION["glpiis_ids_visible"] || empty($data[$NAME . $num])) {
$out .= " (" . $data[$NAME . $num . "_2"] . ")";
}
$out .= "</a>";
$out .= showToolTip(nl2br($data[$NAME . $num . "_3"]), array('applyto' => 'ticket' . $data[$NAME . $num . "_2"], 'display' => false));
return $out;
case "glpi_tickets.due_date":
// No due date in waiting status
if ($data[$NAME . $num . '_2'] == 'waiting') {
$data[$NAME . $num] = "";
}
break;
case 'glpi_ticketvalidations.status':
case "glpi_tickets.global_validation":
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$out = '';
foreach ($split as $val) {
$status = TicketValidation::getStatus($val);
$bgcolor = TicketValidation::getStatusColor($val);
$out .= (empty($out) ? '' : '<br>') . "<div style=\"background-color:" . $bgcolor . ";\">" . $status . '</div>';
}
return $out;
case 'glpi_ticketsatisfactions.type':
return TicketSatisfaction::getTypeInquestName($data[$NAME . $num]);
case 'glpi_ticketsatisfactions.satisfaction':
return TicketSatisfaction::displaySatisfaction($data[$NAME . $num]);
case 'glpi_notimportedemails.reason':
return NotImportedEmail::getReason($data[$NAME . $num]);
case 'glpi_notimportedemails.messageid':
$clean = array('<' => '', '>' => '');
return strtr($data[$NAME . $num], $clean);
case 'glpi_fieldunicities.fields':
$values = explode(',', $data[$NAME . $num]);
$item = new $data['ITEMTYPE']();
$message = array();
foreach ($values as $field) {
$table = getTableNameForForeignKeyField($field);
if ($table != '') {
$searchOption = $item->getSearchOptionByField('field', 'name', $table);
} else {
$searchOption = $item->getSearchOptionByField('field', $field);
}
$message[] = $searchOption['name'];
}
return implode(',', $message);
}
//// Default case
// Link with plugin tables : need to know left join structure
if (preg_match("/^glpi_plugin_([a-z0-9]+)/", $table . '.' . $field, $matches)) {
if (count($matches) == 2) {
$plug = $matches[1];
$function = 'plugin_' . $plug . '_giveItem';
if (function_exists($function)) {
$out = $function($itemtype, $ID, $data, $num);
if (!empty($out)) {
return $out;
}
}
}
}
$unit = '';
if (isset($searchopt[$ID]['unit'])) {
$unit = $searchopt[$ID]['unit'];
}
// Preformat items
if (isset($searchopt[$ID]["datatype"])) {
switch ($searchopt[$ID]["datatype"]) {
case "itemlink":
if (!empty($data[$NAME . $num . "_2"])) {
if (isset($searchopt[$ID]["itemlink_type"])) {
$link = getItemTypeFormURL($searchopt[$ID]["itemlink_type"]);
} else {
$link = getItemTypeFormURL($itemtype);
}
$out = "<a id='" . $itemtype . "_" . $data[$NAME . $num . "_2"] . "' href=\"" . $link;
$out .= strstr($link, '?') ? '&' : '?';
$out .= 'id=' . $data[$NAME . $num . "_2"] . "\">" . $data[$NAME . $num] . $unit;
if ($_SESSION["glpiis_ids_visible"] || empty($data[$NAME . $num])) {
$out .= " (" . $data[$NAME . $num . "_2"] . ")";
}
$out .= "</a>";
return $out;
}
if (isset($searchopt[$ID]["itemlink_type"])) {
$out = "";
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$count_display = 0;
$separate = '<br>';
if (isset($searchopt[$ID]['splititems']) && $searchopt[$ID]['splititems']) {
$separate = '<hr>';
}
for ($k = 0; $k < count($split); $k++) {
if (strlen(trim($split[$k])) > 0) {
$split2 = explode("\$\$", $split[$k]);
if (isset($split2[1]) && $split2[1] > 0) {
if ($count_display) {
$out .= $separate;
}
$count_display++;
$page = getItemTypeFormURL($searchopt[$ID]["itemlink_type"]);
$page .= strpos($page, '?') ? '&id' : '?id';
$out .= "<a id='" . $searchopt[$ID]["itemlink_type"] . "_" . $data['id'] . "_" . $split2[1] . "' href='{$page}=" . $split2[1] . "'>" . $split2[0] . $unit;
if ($_SESSION["glpiis_ids_visible"] || empty($split2[0])) {
$out .= " (" . $split2[1] . ")";
}
$out .= "</a>";
}
}
}
return $out;
}
break;
case "text":
$separate = '<br>';
if (isset($searchopt[$ID]['splititems']) && $searchopt[$ID]['splititems']) {
$separate = '<hr>';
}
$text = str_replace('$$$$', $separate, nl2br($data[$NAME . $num]));
if (isset($searchopt[$ID]['htmltext']) && $searchopt[$ID]['htmltext']) {
$text = html_clean(unclean_cross_side_scripting_deep($text));
}
return $text;
case "date":
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$out = '';
foreach ($split as $val) {
$out .= (empty($out) ? '' : '<br>') . convDate($val);
}
return $out;
case "datetime":
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$out = '';
foreach ($split as $val) {
$out .= (empty($out) ? '' : '<br>') . convDateTime($val);
}
return $out;
case "timestamp":
$withseconds = false;
if (isset($searchopt[$ID]['withseconds'])) {
$withseconds = $searchopt[$ID]['withseconds'];
}
return timestampToString($data[$NAME . $num], $withseconds);
case "date_delay":
$split = explode('$$$$', $data[$NAME . $num]);
$out = '';
foreach ($split as $val) {
if (strpos($val, ',')) {
list($dat, $dur) = explode(',', $val);
if (!empty($dat)) {
$out .= (empty($out) ? '' : '<br>') . getWarrantyExpir($dat, $dur);
}
}
}
return empty($out) ? " " : $out;
case "email":
$email = trim($data[$NAME . $num]);
if (!empty($email)) {
return "<a href='mailto:{$email}'>{$email}</a>";
}
return " ";
case "weblink":
$orig_link = trim($data[$NAME . $num]);
if (!empty($orig_link)) {
// strip begin of link
$link = preg_replace('/https?:\\/\\/(www[^\\.]*\\.)?/', '', $orig_link);
$link = preg_replace('/\\/$/', '', $link);
if (utf8_strlen($link) > $CFG_GLPI["url_maxlength"]) {
$link = utf8_substr($link, 0, $CFG_GLPI["url_maxlength"]) . "...";
}
return "<a href=\"" . formatOutputWebLink($orig_link) . "\" target='_blank'>{$link}</a>";
}
return " ";
case "number":
if (isset($searchopt[$ID]['forcegroupby']) && $searchopt[$ID]['forcegroupby']) {
$out = "";
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$count_display = 0;
for ($k = 0; $k < count($split); $k++) {
if (strlen(trim($split[$k])) > 0) {
if ($count_display) {
$out .= "<br>";
}
$count_display++;
$out .= str_replace(' ', ' ', formatNumber($split[$k], false, 0)) . $unit;
}
}
return $out;
}
return str_replace(' ', ' ', formatNumber($data[$NAME . $num], false, 0)) . $unit;
case "decimal":
if (isset($searchopt[$ID]['forcegroupby']) && $searchopt[$ID]['forcegroupby']) {
$out = "";
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$count_display = 0;
for ($k = 0; $k < count($split); $k++) {
if (strlen(trim($split[$k])) > 0) {
if ($count_display) {
$out .= "<br>";
}
$count_display++;
$out .= str_replace(' ', ' ', formatNumber($split[$k])) . $unit;
}
}
return $out;
}
return str_replace(' ', ' ', formatNumber($data[$NAME . $num])) . $unit;
case "bool":
return Dropdown::getYesNo($data[$NAME . $num]) . $unit;
case "right":
return Profile::getRightValue($data[$NAME . $num]);
case "itemtypename":
if (class_exists($data[$NAME . $num])) {
$obj = new $data[$NAME . $num]();
return $obj->getTypeName();
}
return "";
case "language":
if (isset($CFG_GLPI['languages'][$data[$NAME . $num]])) {
return $CFG_GLPI['languages'][$data[$NAME . $num]][0];
}
return $LANG['setup'][46];
}
}
// Manage items with need group by / group_concat
if (isset($searchopt[$ID]['forcegroupby']) && $searchopt[$ID]['forcegroupby']) {
$out = "";
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$count_display = 0;
$separate = '<br>';
if (isset($searchopt[$ID]['splititems']) && $searchopt[$ID]['splititems']) {
$separate = '<hr>';
}
for ($k = 0; $k < count($split); $k++) {
if (strlen(trim($split[$k])) > 0) {
if ($count_display) {
$out .= $separate;
}
$count_display++;
$out .= $split[$k] . $unit;
}
}
return $out;
}
return $data[$NAME . $num] . $unit;
}
/**
* Generic Function to display Items
*
* @param $itemtype item type
* @param $ID ID of the SEARCH_OPTION item
* @param $data array containing data results
* @param $num item num in the request
* @param $meta is a meta item ? (default 0)
* @param $addobjectparams array added parameters for union search
*
* @return string to print
**/
static function giveItem($itemtype, $ID, array $data, $num, $meta = 0, array $addobjectparams = array())
{
global $CFG_GLPI;
$showuserlink = 0;
if (Session::haveRight('user', READ)) {
$showuserlink = 1;
}
$searchopt =& self::getOptions($itemtype);
if (isset($CFG_GLPI["union_search_type"][$itemtype]) && $CFG_GLPI["union_search_type"][$itemtype] == $searchopt[$ID]["table"]) {
if (isset($searchopt[$ID]['addobjectparams']) && $searchopt[$ID]['addobjectparams']) {
return self::giveItem($data["TYPE"], $ID, $data, $num, $meta, $searchopt[$ID]['addobjectparams']);
}
return self::giveItem($data["TYPE"], $ID, $data, $num, $meta);
}
if (count($addobjectparams)) {
$searchopt[$ID] = array_merge($searchopt[$ID], $addobjectparams);
}
// Plugin can override core definition for its type
if ($plug = isPluginItemType($itemtype)) {
$function = 'plugin_' . $plug['plugin'] . '_giveItem';
if (function_exists($function)) {
$out = $function($itemtype, $ID, $data, $num);
if (!empty($out)) {
return $out;
}
}
}
$NAME = "ITEM_";
if ($meta) {
$NAME = "META_";
}
$table = $searchopt[$ID]["table"];
$field = $searchopt[$ID]["field"];
$linkfield = $searchopt[$ID]["linkfield"];
/// TODO try to clean all specific cases using SpecificToDisplay
switch ($table . '.' . $field) {
case "glpi_users.name":
// USER search case
if ($itemtype != 'User' && isset($searchopt[$ID]["forcegroupby"]) && $searchopt[$ID]["forcegroupby"]) {
$out = "";
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$count_display = 0;
$added = array();
for ($k = 0; $k < count($split); $k++) {
if ($split[$k] > 0) {
if ($count_display) {
$out .= "<br>";
}
$count_display++;
if ($itemtype == 'Ticket') {
$userdata = getUserName($split[$k], 2);
$tooltip = "";
if (Session::haveRight('user', READ)) {
$tooltip = Html::showToolTip($userdata["comment"], array('link' => $userdata["link"], 'display' => false));
}
$out .= sprintf(__('%1$s %2$s'), $userdata['name'], $tooltip);
} else {
$out .= getUserName($split[$k], $showuserlink);
}
}
}
// Manage alternative_email for tickets_users
if ($itemtype == 'Ticket' && isset($data[$NAME . $num . '_2'])) {
$split = explode("\$\$\$\$", $data[$NAME . $num . '_2']);
for ($k = 0; $k < count($split); $k++) {
$split2 = explode(" ", $split[$k]);
if (count($split2) == 2 && $split2[0] == 0 && !empty($split2[1])) {
if ($count_display) {
$out .= "<br>";
}
$count_display++;
$out .= "<a href='mailto:" . $split2[1] . "'>" . $split2[1] . "</a>";
}
}
}
return $out;
}
if ($itemtype != 'User') {
$toadd = '';
if ($itemtype == 'Ticket' && $data[$NAME . $num . "_3"] > 0) {
$userdata = getUserName($data[$NAME . $num . "_3"], 2);
$toadd = Html::showToolTip($userdata["comment"], array('link' => $userdata["link"], 'display' => false));
}
if (Session::haveRight('user', READ)) {
$usernameformat = formatUserName($data[$NAME . $num . "_3"], $data[$NAME . $num], $data[$NAME . $num . "_2"], $data[$NAME . $num . "_4"], 1);
} else {
$usernameformat = formatUserName($data[$NAME . $num . "_3"], $data[$NAME . $num], $data[$NAME . $num . "_2"], $data[$NAME . $num . "_4"], 0);
}
return sprintf(__('%1$s %2$s'), $usernameformat, $toadd);
}
break;
case "glpi_profiles.interface":
return Profile::getInterfaceName($data[$NAME . $num]);
case "glpi_profiles.name":
if ($itemtype == 'User' && $ID == 20) {
$out = "";
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$split2 = explode("\$\$\$\$", $data[$NAME . $num . "_2"]);
$split3 = explode("\$\$\$\$", $data[$NAME . $num . "_3"]);
$split4 = explode("\$\$\$\$", $data[$NAME . $num . "_4"]);
$count_display = 0;
$added = array();
for ($k = 0; $k < count($split); $k++) {
if (strlen(trim($split[$k])) > 0) {
$text = sprintf(__('%1$s - %2$s'), $split[$k], Dropdown::getDropdownName('glpi_entities', $split2[$k]));
$comp = '';
if ($split3[$k]) {
$comp = __(READ);
if ($split4[$k]) {
$comp = sprintf(__('%1$s%2$s'), $comp, ", ");
}
}
if ($split4[$k]) {
$comp = sprintf(__('%1$s%2$s'), $comp, __('D'));
}
if (!empty($comp)) {
$text = sprintf(__('%1$s %2$s'), $text, "(" . $comp . ")");
}
if (!in_array($text, $added)) {
if ($count_display) {
$out .= "<br>";
}
$count_display++;
$out .= $text;
$added[] = $text;
}
}
}
return $out;
}
break;
case "glpi_entities.completename":
if ($itemtype == 'User') {
$out = "";
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$split2 = explode("\$\$\$\$", $data[$NAME . $num . "_2"]);
$split3 = explode("\$\$\$\$", $data[$NAME . $num . "_3"]);
$split4 = explode("\$\$\$\$", $data[$NAME . $num . "_4"]);
$added = array();
$count_display = 0;
for ($k = 0; $k < count($split); $k++) {
if (strlen(trim($split[$k])) > 0) {
$text = sprintf(__('%1$s - %2$s'), $split[$k], Dropdown::getDropdownName('glpi_profiles', $split2[$k]));
$comp = '';
if ($split3[$k]) {
$comp = __(READ);
if ($split4[$k]) {
$comp = sprintf(__('%1$s%2$s'), $comp, ", ");
}
}
if ($split4[$k]) {
$comp = sprintf(__('%1$s%2$s'), $comp, __('D'));
}
if (!empty($comp)) {
$text = sprintf(__('%1$s %2$s'), $text, "(" . $comp . ")");
}
if (!in_array($text, $added)) {
if ($count_display) {
$out .= "<br>";
}
$count_display++;
$out .= $text;
$added[] = $text;
}
}
}
return $out;
}
break;
case "glpi_documenttypes.icon":
if (!empty($data[$NAME . $num])) {
return "<img class='middle' alt='' src='" . $CFG_GLPI["typedoc_icon_dir"] . "/" . $data[$NAME . $num] . "'>";
}
return " ";
case "glpi_documents.filename":
$doc = new Document();
if ($doc->getFromDB($data['id'])) {
return $doc->getDownloadLink();
}
return NOT_AVAILABLE;
case "glpi_deviceharddrives.specificity":
case "glpi_devicememories.specificity":
case "glpi_deviceprocessors.specificity":
return $data[$NAME . $num];
case "glpi_networkports.mac":
$out = "";
if ($itemtype == 'Computer') {
$displayed = array();
if (!empty($data[$NAME . $num . "_2"])) {
$split = explode("\$\$\$\$", $data[$NAME . $num . "_2"]);
$count_display = 0;
for ($k = 0; $k < count($split); $k++) {
$lowstr = Toolbox::strtolower($split[$k]);
if (strlen(trim($split[$k])) > 0 && !in_array($lowstr, $displayed)) {
if ($count_display) {
$out .= "<br>";
}
$count_display++;
$out .= $split[$k];
$displayed[] = $lowstr;
}
}
if (!empty($data[$NAME . $num])) {
$out .= "<br>";
}
}
if (!empty($data[$NAME . $num])) {
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$count_display = 0;
for ($k = 0; $k < count($split); $k++) {
$lowstr = Toolbox::strtolower($split[$k]);
if (strlen(trim($split[$k])) > 0 && !in_array($lowstr, $displayed)) {
if ($count_display) {
$out .= "<br>";
}
$count_display++;
$out .= $split[$k];
$displayed[] = $lowstr;
}
}
}
return $out;
}
break;
case "glpi_contracts.duration":
case "glpi_contracts.notice":
case "glpi_contracts.periodicity":
case "glpi_contracts.billing":
if (!empty($data[$NAME . $num])) {
$split = explode('$$$$', $data[$NAME . $num]);
$output = "";
foreach ($split as $duration) {
$output .= (empty($output) ? '' : '<br>') . sprintf(_n('%d month', '%d months', $duration), $duration);
}
return $output;
}
return " ";
case "glpi_contracts.renewal":
return Contract::getContractRenewalName($data[$NAME . $num]);
// case "glpi_infocoms.sink_time" :
// if (!empty($data[$NAME.$num])) {
// $split = explode("$$$$", $data[$NAME.$num]);
// $out = '';
// foreach ($split as $val) {
// $out .= (empty($out)?'':'<br>');
// if ($val > 0) {
// //TRANS: %d is a number of years
// $out .= sprintf(_n('%d year', '%d years', $val), $val);
// }
// }
// return $out;
// }
// return " ";
//
// case "glpi_infocoms.warranty_duration" :
// if (!empty($data[$NAME.$num])) {
// $split = explode("$$$$", $data[$NAME.$num]);
// $out = '';
// foreach ($split as $val) {
// $out .= (empty($out)?'':'<br>');
// if ($val > 0) {
// $out .= sprintf(_n('%d month', '%d months', $val), $val);
// }
// if ($val < 0) {
// $out .= __('Lifelong');
// }
// }
// return $out;
// }
// return " ";
// case "glpi_infocoms.sink_time" :
// if (!empty($data[$NAME.$num])) {
// $split = explode("$$$$", $data[$NAME.$num]);
// $out = '';
// foreach ($split as $val) {
// $out .= (empty($out)?'':'<br>');
// if ($val > 0) {
// //TRANS: %d is a number of years
// $out .= sprintf(_n('%d year', '%d years', $val), $val);
// }
// }
// return $out;
// }
// return " ";
//
// case "glpi_infocoms.warranty_duration" :
// if (!empty($data[$NAME.$num])) {
// $split = explode("$$$$", $data[$NAME.$num]);
// $out = '';
// foreach ($split as $val) {
// $out .= (empty($out)?'':'<br>');
// if ($val > 0) {
// $out .= sprintf(_n('%d month', '%d months', $val), $val);
// }
// if ($val < 0) {
// $out .= __('Lifelong');
// }
// }
// return $out;
// }
// return " ";
case "glpi_infocoms.sink_type":
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$out = '';
foreach ($split as $val) {
$out .= (empty($out) ? '' : '<br>') . Infocom::getAmortTypeName($val);
}
return $out;
case "glpi_infocoms.alert":
if ($data[$NAME . $num] == pow(2, Alert::END)) {
return __s('Warranty expiration date');
}
return "";
case "glpi_contracts.alert":
switch ($data[$NAME . $num]) {
case pow(2, Alert::END):
return __('End');
case pow(2, Alert::NOTICE):
return __('Notice');
case pow(2, Alert::END) + pow(2, Alert::NOTICE):
return __('End + Notice');
}
return "";
case "glpi_tickets_tickets.tickets_id_1":
$out = "";
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$split2 = explode("\$\$\$\$", $data[$NAME . $num . "_2"]);
$displayed = array();
for ($k = 0; $k < count($split); $k++) {
$linkid = $split[$k] == $data['id'] ? $split2[$k] : $split[$k];
if ($linkid > 0 && !isset($displayed[$linkid])) {
$text = "<a ";
$text .= "href=\"" . $CFG_GLPI["root_doc"] . "/front/ticket.form.php?id={$linkid}\">";
$text .= Dropdown::getDropdownName('glpi_tickets', $linkid) . "</a>";
if (count($displayed)) {
$out .= "<br>";
}
$displayed[$linkid] = $linkid;
$out .= $text;
}
}
return $out;
case "glpi_problems.count":
if ($data[$NAME . $num] > 0 && Session::haveRight("problem", Problem::READALL)) {
if ($itemtype == 'ITILCategory') {
$options['field'][0] = 7;
$options['searchtype'][0] = 'equals';
$options['contains'][0] = $data['id'];
$options['link'][0] = 'AND';
}
$options['reset'] = 'reset';
$out = "<a id='problem{$itemtype}" . $data['id'] . "' ";
$out .= "href=\"" . $CFG_GLPI["root_doc"] . "/front/problem.php?" . Toolbox::append_params($options, '&') . "\">";
$out .= $data[$NAME . $num] . "</a>";
} else {
$out = $data[$NAME . $num];
}
return $out;
case "glpi_tickets.count":
if ($data[$NAME . $num] > 0 && Session::haveRight("ticket", Ticket::READALL)) {
if ($itemtype == 'User') {
$options['field'][0] = 4;
$options['searchtype'][0] = 'equals';
$options['contains'][0] = $data['id'];
$options['link'][0] = 'AND';
$options['field'][1] = 22;
$options['searchtype'][1] = 'equals';
$options['contains'][1] = $data['id'];
$options['link'][1] = 'OR';
$options['field'][2] = 5;
$options['searchtype'][2] = 'equals';
$options['contains'][2] = $data['id'];
$options['link'][2] = 'OR';
} else {
if ($itemtype == 'ITILCategory') {
$options['field'][0] = 7;
$options['searchtype'][0] = 'equals';
$options['contains'][0] = $data['id'];
$options['link'][0] = 'AND';
} else {
$options['field'][0] = 12;
$options['searchtype'][0] = 'equals';
$options['contains'][0] = 'all';
$options['link'][0] = 'AND';
$options['itemtype2'][0] = $itemtype;
$options['field2'][0] = self::getOptionNumber($itemtype, 'name');
$options['searchtype2'][0] = 'equals';
$options['contains2'][0] = $data['id'];
$options['link2'][0] = 'AND';
}
}
$options['reset'] = 'reset';
$out = "<a id='ticket{$itemtype}" . $data['id'] . "' ";
$out .= "href=\"" . $CFG_GLPI["root_doc"] . "/front/ticket.php?" . Toolbox::append_params($options, '&') . "\">";
$out .= $data[$NAME . $num] . "</a>";
} else {
$out = $data[$NAME . $num];
}
return $out;
case "glpi_tickets.due_date":
// Due date + progress
if ($ID == 151) {
$out = Html::convDate($data[$NAME . $num]);
// No due date in waiting status
if ($data[$NAME . $num . '_2'] == CommonITILObject::WAITING) {
return '';
}
if (empty($data[$NAME . $num])) {
return '';
}
if ($data[$NAME . $num . '_2'] == Ticket::SOLVED || $data[$NAME . $num . '_2'] == Ticket::CLOSED) {
return $data[$NAME . $num];
}
$ticket = new Ticket();
$ticket->getFromDB($data['ITEM_0']);
$percentage = 0;
$totaltime = 0;
$currenttime = 0;
if ($ticket->fields['slas_id'] != 0) {
// Have SLA
$sla = new SLA();
$sla->getFromDB($ticket->fields['slas_id']);
$currenttime = $sla->getActiveTimeBetween($ticket->fields['date'], date('Y-m-d H:i:s'));
$totaltime = $sla->getActiveTimeBetween($ticket->fields['date'], $data[$NAME . $num]);
} else {
$calendars_id = Entity::getUsedConfig('calendars_id', $ticket->fields['entities_id']);
if ($calendars_id != 0) {
// Ticket entity have calendar
$calendar = new Calendar();
$calendar->getFromDB($calendars_id);
$currenttime = $calendar->getActiveTimeBetween($ticket->fields['date'], date('Y-m-d H:i:s'));
$totaltime = $calendar->getActiveTimeBetween($ticket->fields['date'], $data[$NAME . $num]);
} else {
// No calendar
$currenttime = strtotime(date('Y-m-d H:i:s')) - strtotime($ticket->fields['date']);
$totaltime = strtotime($data[$NAME . $num]) - strtotime($ticket->fields['date']);
}
}
if ($totaltime != 0) {
$percentage = round(100 * $currenttime / $totaltime);
} else {
// Total time is null : no active time
$percentage = 100;
}
if ($percentage > 100) {
$percentage = 100;
}
$percentage_text = $percentage;
if ($_SESSION['glpiduedatewarning_unit'] == '%') {
$less_warn_limit = $_SESSION['glpiduedatewarning_less'];
$less_warn = 100 - $percentage;
} else {
if ($_SESSION['glpiduedatewarning_unit'] == 'hours') {
$less_warn_limit = $_SESSION['glpiduedatewarning_less'] * HOUR_TIMESTAMP;
$less_warn = $totaltime - $currenttime;
} else {
if ($_SESSION['glpiduedatewarning_unit'] == 'days') {
$less_warn_limit = $_SESSION['glpiduedatewarning_less'] * DAY_TIMESTAMP;
$less_warn = $totaltime - $currenttime;
}
}
}
if ($_SESSION['glpiduedatecritical_unit'] == '%') {
$less_crit_limit = $_SESSION['glpiduedatecritical_less'];
$less_crit = 100 - $percentage;
} else {
if ($_SESSION['glpiduedatecritical_unit'] == 'hours') {
$less_crit_limit = $_SESSION['glpiduedatecritical_less'] * HOUR_TIMESTAMP;
$less_crit = $totaltime - $currenttime;
} else {
if ($_SESSION['glpiduedatecritical_unit'] == 'days') {
$less_crit_limit = $_SESSION['glpiduedatecritical_less'] * DAY_TIMESTAMP;
$less_crit = $totaltime - $currenttime;
}
}
}
$color = $_SESSION['glpiduedateok_color'];
if ($less_crit < $less_crit_limit) {
$color = $_SESSION['glpiduedatecritical_color'];
} else {
if ($less_warn < $less_warn_limit) {
$color = $_SESSION['glpiduedatewarning_color'];
}
}
//Calculate bar progress
$out .= "<div class='center' style='background-color: #ffffff; width: 100%;\n border: 1px solid #9BA563;' >";
$out .= "<div style='position:absolute;'> " . $percentage_text . "%</div>";
$out .= "<div class='center' style='background-color: " . $color . ";\n width: " . $percentage . "%; height: 12px' ></div>";
$out .= "</div>";
return $out;
}
break;
case "glpi_softwarelicenses.number":
if ($data[$NAME . $num . "_2"] == -1) {
return __('Unlimited');
}
if (empty($data[$NAME . $num])) {
return 0;
}
return $data[$NAME . $num];
case "glpi_auth_tables.name":
return Auth::getMethodName($data[$NAME . $num], $data[$NAME . $num . "_2"], 1, $data[$NAME . $num . "_3"] . $data[$NAME . $num . "_4"]);
case "glpi_reservationitems.comment":
if (empty($data[$NAME . $num])) {
return "<a title=\"" . __s('Modify the comment') . "\"\n href='" . $CFG_GLPI["root_doc"] . "/front/reservationitem.form.php?id=" . $data["refID"] . "' >" . __('None') . "</a>";
}
return "<a title=\"" . __s('Modify the comment') . "\"\n href='" . $CFG_GLPI["root_doc"] . "/front/reservationitem.form.php?id=" . $data['refID'] . "' >" . Html::resume_text($data[$NAME . $num]) . "</a>";
case 'glpi_notifications.mode':
return Notification::getMode($data[$NAME . $num]);
case 'glpi_notifications.event':
$item = NotificationTarget::getInstanceByType($data['itemtype']);
if ($item) {
$events = $item->getAllEvents();
if (isset($events[$data[$NAME . $num]])) {
return $events[$data[$NAME . $num]];
}
}
return '';
case 'glpi_reminders.state':
return Planning::getState($data[$NAME . $num]);
case 'glpi_crontasks.description':
$tmp = new CronTask();
return $tmp->getDescription($data['id']);
case 'glpi_crontasks.state':
return CronTask::getStateName($data[$NAME . $num]);
case 'glpi_crontasks.mode':
return CronTask::getModeName($data[$NAME . $num]);
case 'glpi_crontasks.itemtype':
if ($plug = isPluginItemType($data[$NAME . $num])) {
return $plug['plugin'];
}
return '';
case 'glpi_changes.status':
$status = Change::getStatus($data[$NAME . $num]);
return "<img src=\"" . Change::getStatusIconURL($data[$NAME . $num]) . "\"\n alt=\"{$status}\" title=\"{$status}\"> {$status}";
case 'glpi_problems.status':
$status = Problem::getStatus($data[$NAME . $num]);
return "<img src=\"" . Problem::getStatusIconURL($data[$NAME . $num]) . "\"\n alt=\"{$status}\" title=\"{$status}\"> {$status}";
case 'glpi_tickets.status':
$status = Ticket::getStatus($data[$NAME . $num]);
return "<img src=\"" . Ticket::getStatusIconURL($data[$NAME . $num]) . "\"\n alt=\"{$status}\" title=\"{$status}\"> {$status}";
case 'glpi_tickets.items_id':
if (!empty($data[$NAME . $num . "_2"]) && ($item = getItemForItemtype($data[$NAME . $num . "_2"]))) {
if ($item->getFromDB($data[$NAME . $num])) {
return $item->getLink(array('comments' => true));
}
}
return ' ';
case 'glpi_tickets.name':
if (isset($searchopt[$ID]['forcegroupby']) && $searchopt[$ID]['forcegroupby']) {
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$out = '';
$link = Toolbox::getItemTypeFormURL('Ticket');
foreach ($split as $val) {
if (!empty($val)) {
$split2 = self::explodeWithID("\$\$", $val);
$out .= "<a id='ticket" . $split2[1] . "' href=\"" . $link;
$out .= strstr($link, '?') ? '&' : '?';
$out .= 'id=' . $split2[1];
$out .= "\">";
$name = $split2[0];
if ($_SESSION["glpiis_ids_visible"] || empty($split2[0])) {
$name = sprintf(__('%1$s (%2$s)'), $name, $split2[1]);
}
$out .= $name . "</a><br>";
}
}
return $out;
}
$link = Toolbox::getItemTypeFormURL('Ticket');
$out = "<a id='ticket" . $data[$NAME . $num . "_2"] . "' href=\"" . $link;
$out .= strstr($link, '?') ? '&' : '?';
$out .= 'id=' . $data[$NAME . $num . "_2"];
// Force solution tab if solved
if ($data[$NAME . $num . "_4"] == CommonITILObject::SOLVED) {
$out .= "&forcetab=Ticket\$2";
}
$out .= "\">";
$name = $data[$NAME . $num];
if ($_SESSION["glpiis_ids_visible"] || empty($data[$NAME . $num])) {
$name = sprintf(__('%1$s (%2$s)'), $name, $data[$NAME . $num . "_2"]);
}
$out .= $name . "</a>";
$out = sprintf(__('%1$s %2$s'), $out, Html::showToolTip(nl2br($data[$NAME . $num . "_3"]), array('applyto' => 'ticket' . $data[$NAME . $num . "_2"], 'display' => false)));
return $out;
case 'glpi_ticketvalidations.status':
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$out = '';
foreach ($split as $val) {
if (!empty($val)) {
$split2 = self::explodeWithID("\$\$", $val);
$status = TicketValidation::getStatus($split2[0]);
$bgcolor = TicketValidation::getStatusColor($split2[0]);
$out .= (empty($out) ? '' : '<br>') . "<div style=\"background-color:" . $bgcolor . ";\">" . $status . '</div>';
}
}
return $out;
case 'glpi_ticketsatisfactions.type':
return TicketSatisfaction::getTypeInquestName($data[$NAME . $num]);
case 'glpi_ticketsatisfactions.satisfaction':
return TicketSatisfaction::displaySatisfaction($data[$NAME . $num]);
case 'glpi_notimportedemails.reason':
return NotImportedEmail::getReason($data[$NAME . $num]);
case 'glpi_notimportedemails.messageid':
$clean = array('<' => '', '>' => '');
return strtr($data[$NAME . $num], $clean);
}
//// Default case
// Link with plugin tables : need to know left join structure
if (preg_match("/^glpi_plugin_([a-z0-9]+)/", $table . '.' . $field, $matches)) {
if (count($matches) == 2) {
$plug = $matches[1];
$function = 'plugin_' . $plug . '_giveItem';
if (function_exists($function)) {
$out = $function($itemtype, $ID, $data, $num);
if (!empty($out)) {
return $out;
}
}
}
}
$unit = '';
if (isset($searchopt[$ID]['unit'])) {
$unit = $searchopt[$ID]['unit'];
}
/// TODO try to use getvalueToDisplay instead of redefine display system
// Preformat items
if (isset($searchopt[$ID]["datatype"])) {
switch ($searchopt[$ID]["datatype"]) {
case "itemlink":
$linkitemtype = getItemTypeForTable($searchopt[$ID]["table"]);
if (isset($data[$NAME . $num . "_2"]) && strlen($data[$NAME . $num . "_2"])) {
$link = Toolbox::getItemTypeFormURL($linkitemtype);
$out = "<a id='" . $itemtype . "_" . $data[$NAME . $num . "_2"] . "' href=\"" . $link;
$out .= strstr($link, '?') ? '&' : '?';
$out .= 'id=' . $data[$NAME . $num . "_2"];
if (isset($searchopt[$ID]['forcetab'])) {
$out .= "&forcetab=" . $searchopt[$ID]['forcetab'];
}
$out .= "\">";
$name = Dropdown::getValueWithUnit($data[$NAME . $num], $unit);
if ($_SESSION["glpiis_ids_visible"] || empty($data[$NAME . $num])) {
$name = sprintf(__('%1$s (%2$s)'), $name, $data[$NAME . $num . "_2"]);
}
$out .= $name . "</a>";
return $out;
}
$out = "";
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$count_display = 0;
$separate = '<br>';
if (isset($searchopt[$ID]['splititems']) && $searchopt[$ID]['splititems']) {
$separate = '<hr>';
}
for ($k = 0; $k < count($split); $k++) {
if (strlen(trim($split[$k])) > 0) {
$split2 = self::explodeWithID("\$\$", $split[$k]);
if (isset($split2[1]) && $split2[1] > 0) {
if ($count_display) {
$out .= $separate;
}
$count_display++;
$page = Toolbox::getItemTypeFormURL($linkitemtype);
$page .= strpos($page, '?') ? '&id' : '?id';
$name = Dropdown::getValueWithUnit($split2[0], $unit);
if ($_SESSION["glpiis_ids_visible"] || empty($split2[0])) {
$name = sprintf(__('%1$s (%2$s)'), $name, $split2[1]);
}
$out .= "<a id='" . $linkitemtype . "_" . $data['id'] . "_" . $split2[1] . "' href='{$page}=" . $split2[1] . "'>" . $name . "</a>";
}
}
}
return $out;
case "text":
$separate = '<br>';
if (isset($searchopt[$ID]['splititems']) && $searchopt[$ID]['splititems']) {
$separate = '<hr>';
}
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$out = '';
$count_display = 0;
foreach ($split as $val) {
if (strlen(trim($val)) > 0) {
$split2 = self::explodeWithID("\$\$", $val);
if ($count_display) {
$out .= $separate;
}
$count_display++;
if (isset($searchopt[$ID]['htmltext']) && $searchopt[$ID]['htmltext']) {
$text = Html::clean(Toolbox::unclean_cross_side_scripting_deep(nl2br($split2[0])));
} else {
$text = nl2br($split2[0]);
}
if (self::$output_type == self::HTML_OUTPUT && Toolbox::strlen($text) > $CFG_GLPI['cut']) {
$rand = mt_rand();
$out .= sprintf(__('%1$s %2$s'), "<span id='text{$rand}'>" . Html::resume_text($text, $CFG_GLPI['cut']) . '</span>', Html::showToolTip($text, array('applyto' => "text{$rand}", 'display' => false)));
} else {
$out .= $text;
}
}
}
return $out;
case "date":
case "date_delay":
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$out = '';
foreach ($split as $val) {
$out .= (empty($out) ? '' : '<br>') . Html::convDate($val);
}
return $out;
case "datetime":
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$out = '';
foreach ($split as $val) {
$out .= (empty($out) ? '' : '<br>') . Html::convDateTime($val);
}
return $out;
case "timestamp":
$withseconds = false;
if (isset($searchopt[$ID]['withseconds'])) {
$withseconds = $searchopt[$ID]['withseconds'];
}
$withdays = true;
if (isset($searchopt[$ID]['withdays'])) {
$withdays = $searchopt[$ID]['withdays'];
}
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$out = '';
foreach ($split as $val) {
$out .= (empty($out) ? '' : '<br>') . Html::timestampToString($val, $withseconds, $withdays);
}
return $out;
case "email":
$split = explode('$$$$', $data[$NAME . $num]);
$out = '';
$count_display = 0;
foreach ($split as $val) {
$split2 = self::explodeWithID("\$\$", $val);
if ($count_display) {
$out .= "<br>";
}
$count_display++;
if (!empty($val)) {
$out .= empty($out) ? '' : '<br>';
$out .= "<a href='mailto:{$split2['0']}'>{$split2['0']}</a>";
}
}
return empty($out) ? " " : $out;
case "weblink":
$orig_link = trim($data[$NAME . $num]);
if (!empty($orig_link)) {
// strip begin of link
$link = preg_replace('/https?:\\/\\/(www[^\\.]*\\.)?/', '', $orig_link);
$link = preg_replace('/\\/$/', '', $link);
if (Toolbox::strlen($link) > $CFG_GLPI["url_maxlength"]) {
$link = Toolbox::substr($link, 0, $CFG_GLPI["url_maxlength"]) . "...";
}
return "<a href=\"" . formatOutputWebLink($orig_link) . "\" target='_blank'>{$link}</a>";
}
return " ";
case "number":
if (isset($searchopt[$ID]['forcegroupby']) && $searchopt[$ID]['forcegroupby']) {
$out = "";
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$count_display = 0;
for ($k = 0; $k < count($split); $k++) {
if (strlen(trim($split[$k])) > 0) {
$split2 = self::explodeWithID("\$\$", $split[$k]);
if ($count_display) {
$out .= "<br>";
}
$count_display++;
if (isset($searchopt[$ID]['toadd']) && isset($searchopt[$ID]['toadd'][$split2[0]])) {
$out .= $searchopt[$ID]['toadd'][$split2[0]];
} else {
$number = str_replace(' ', ' ', Html::formatNumber($split2[0], false, 0));
$out .= Dropdown::getValueWithUnit($number, $unit);
}
}
}
return $out;
}
if (isset($searchopt[$ID]['toadd']) && isset($searchopt[$ID]['toadd'][$data[$NAME . $num]])) {
return $searchopt[$ID]['toadd'][$data[$NAME . $num]];
} else {
$number = str_replace(' ', ' ', Html::formatNumber($data[$NAME . $num], false, 0));
return Dropdown::getValueWithUnit($number, $unit);
}
case "decimal":
if (isset($searchopt[$ID]['forcegroupby']) && $searchopt[$ID]['forcegroupby']) {
$out = "";
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$count_display = 0;
for ($k = 0; $k < count($split); $k++) {
if (strlen(trim($split[$k])) > 0) {
$split2 = self::explodeWithID("\$\$", $split[$k]);
if ($count_display) {
$out .= "<br>";
}
$count_display++;
if (isset($searchopt[$ID]['toadd']) && isset($searchopt[$ID]['toadd'][$split2[0]])) {
$out .= $searchopt[$ID]['toadd'][$split2[0]];
} else {
$number = str_replace(' ', ' ', Html::formatNumber($split2[0]));
$out .= Dropdown::getValueWithUnit($number, $unit);
}
}
}
return $out;
}
$number = str_replace(' ', ' ', Html::formatNumber($data[$NAME . $num]));
return Dropdown::getValueWithUnit($number, $unit);
case "bool":
if (isset($searchopt[$ID]['forcegroupby']) && $searchopt[$ID]['forcegroupby']) {
$out = "";
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$count_display = 0;
for ($k = 0; $k < count($split); $k++) {
if (strlen(trim($split[$k])) > 0) {
$split2 = self::explodeWithID("\$\$", $split[$k]);
if ($count_display) {
$out .= "<br>";
}
$count_display++;
$out .= Dropdown::getValueWithUnit(Dropdown::getYesNo($split2[0]), $unit);
}
}
return $out;
}
return Dropdown::getValueWithUnit(Dropdown::getYesNo($data[$NAME . $num]), $unit);
case "right":
return Profile::getRightValue($data[$NAME . $num]);
case "itemtypename":
if ($obj = getItemForItemtype($data[$NAME . $num])) {
return $obj->getTypeName();
}
return "";
case "language":
if (isset($CFG_GLPI['languages'][$data[$NAME . $num]])) {
return $CFG_GLPI['languages'][$data[$NAME . $num]][0];
}
return __('Default value');
}
}
// Manage items with need group by / group_concat
if (isset($searchopt[$ID]['forcegroupby']) && $searchopt[$ID]['forcegroupby']) {
$out = "";
$split = explode("\$\$\$\$", $data[$NAME . $num]);
$count_display = 0;
$separate = '<br>';
if (isset($searchopt[$ID]['splititems']) && $searchopt[$ID]['splititems']) {
$separate = '<hr>';
}
for ($k = 0; $k < count($split); $k++) {
if (strlen(trim($split[$k])) > 0) {
if ($count_display) {
$out .= $separate;
}
$withoutid = self::explodeWithID("\$\$", $split[$k]);
$count_display++;
// Get specific display if available
$itemtype = getItemTypeForTable($table);
if ($item = getItemForItemtype($itemtype)) {
$tmpdata = array($field => $withoutid[0]);
$specific = $item->getSpecificValueToDisplay($field, $tmpdata, array('html' => true));
}
if (!empty($specific)) {
$out .= $specific;
} else {
$out .= Dropdown::getValueWithUnit($withoutid[0], $unit);
}
}
}
return $out;
}
// Get specific display if available
$itemtype = getItemTypeForTable($table);
if ($item = getItemForItemtype($itemtype)) {
$tmpdata = array($field => $data[$NAME . $num]);
if (isset($searchopt[$ID]['additionalfields']) && count($searchopt[$ID]['additionalfields'])) {
foreach ($searchopt[$ID]['additionalfields'] as $key) {
$tmpdata[$key] = $data[$NAME . $num . '_' . $key];
}
}
$specific = $item->getSpecificValueToDisplay($field, $tmpdata, array('html' => true));
if (!empty($specific)) {
return $specific;
}
}
// Manage auto CONCAT id
$split = self::explodeWithID('$$', $data[$NAME . $num]);
$split[0] = trim($split[0]);
if (isset($searchopt[$ID]['toadd']) && isset($searchopt[$ID]['toadd'][$split[0]])) {
return $searchopt[$ID]['toadd'][$split[0]];
}
// Empty is 0 or empty
if (empty($split[0]) && isset($searchopt[$ID]['emptylabel'])) {
return $searchopt[$ID]['emptylabel'];
}
return Dropdown::getValueWithUnit($split[0], $unit);
}
/**
* Get all data needed for template processing
**/
function getDatasForTemplate($event, $options = array())
{
global $LANG, $CFG_GLPI;
//----------- Ticket infos -------------- //
if ($event != 'alertnotclosed') {
$fields = array('ticket.title' => 'name', 'ticket.content' => 'content', 'ticket.description' => 'content', 'ticket.costfixed' => 'cost_fixed', 'ticket.costmaterial' => 'cost_material');
foreach ($fields as $tag => $table_field) {
$this->datas['##' . $tag . '##'] = $this->obj->getField($table_field);
}
$this->datas['##ticket.id##'] = sprintf("%07d", $this->obj->getField("id"));
$this->datas['##ticket.url##'] = urldecode($CFG_GLPI["url_base"] . "/index.php?redirect=ticket_" . $this->obj->getField("id"));
$this->datas['##ticket.urlapprove##'] = urldecode($CFG_GLPI["url_base"] . "/index.php?redirect=ticket_" . $this->obj->getField("id") . "_4");
$this->datas['##ticket.urlvalidation##'] = urldecode($CFG_GLPI["url_base"] . "/index.php?redirect=ticket_" . $this->obj->getField("id") . "_7");
$this->datas['##ticket.entity##'] = Dropdown::getDropdownName('glpi_entities', $this->getEntity());
$events = $this->getAllEvents();
if ($event == 'validation' && isset($options['validation_status'])) {
$this->datas['##ticket.action##'] = $LANG['validation'][0] . ' - ' . TicketValidation::getStatus($options['validation_status']);
} else {
$this->datas['##ticket.action##'] = $events[$event];
}
$this->datas['##ticket.storestatus##'] = $this->obj->getField('status');
$this->datas['##ticket.status##'] = Ticket::getStatus($this->obj->getField('status'));
$this->datas['##ticket.globalvalidation##'] = TicketValidation::getStatus($this->obj->getField('global_validation'));
$this->datas['##ticket.type##'] = Ticket::getTicketTypeName($this->obj->getField('type'));
$this->datas['##ticket.requesttype##'] = Dropdown::getDropdownName('glpi_requesttypes', $this->obj->getField('requesttypes_id'));
$this->datas['##ticket.urgency##'] = Ticket::getUrgencyName($this->obj->getField('urgency'));
$this->datas['##ticket.impact##'] = Ticket::getImpactName($this->obj->getField('impact'));
$this->datas['##ticket.priority##'] = Ticket::getPriorityName($this->obj->getField('priority'));
$this->datas['##ticket.time##'] = Ticket::getActionTime($this->obj->getField('actiontime'));
$this->datas['##ticket.costtime##'] = $this->obj->getField('cost_time');
$this->datas['##ticket.creationdate##'] = convDateTime($this->obj->getField('date'));
$this->datas['##ticket.closedate##'] = convDateTime($this->obj->getField('closedate'));
$this->datas['##ticket.solvedate##'] = convDateTime($this->obj->getField('solvedate'));
$this->datas['##ticket.duedate##'] = convDateTime($this->obj->getField('due_date'));
$entitydata = new EntityData();
$autoclose_value = $CFG_GLPI['autoclose_delay'];
if ($entitydata->getFromDB($this->getEntity())) {
$autoclose_value = $entitydata->getField('autoclose_delay');
// Set global config value
if ($autoclose_value == -1) {
$autoclose_value = $CFG_GLPI['autoclose_delay'];
}
}
if ($autoclose_value > 0) {
$this->datas['##ticket.autoclose##'] = $autoclose_value;
$this->datas['##lang.ticket.autoclosewarning##'] = $LANG['job'][54] . " " . $autoclose_value . " " . $LANG['stats'][31];
} else {
$this->datas['##ticket.autoclose##'] = $LANG['setup'][307];
$this->datas['##lang.ticket.autoclosewarning##'] = "";
}
if ($this->obj->getField('ticketcategories_id')) {
$this->datas['##ticket.category##'] = Dropdown::getDropdownName('glpi_ticketcategories', $this->obj->getField('ticketcategories_id'));
} else {
$this->datas['##ticket.category##'] = '';
}
if ($this->obj->getField('slas_id')) {
$this->datas['##ticket.sla##'] = Dropdown::getDropdownName('glpi_slas', $this->obj->getField('slas_id'));
} else {
$this->datas['##ticket.sla##'] = '';
}
if ($this->obj->countUsers(Ticket::REQUESTER)) {
$users = array();
foreach ($this->obj->getUsers(Ticket::REQUESTER) as $uid => $tmp) {
$user_tmp = new User();
$user_tmp->getFromDB($uid);
$users[$uid] = $user_tmp->getName();
$tmp = array();
$tmp['##author.id##'] = $uid;
$tmp['##author.name##'] = $user_tmp->getName();
if ($user_tmp->getField('locations_id')) {
$tmp['##author.location##'] = Dropdown::getDropdownName('glpi_locations', $user_tmp->getField('locations_id'));
} else {
$tmp['##author.location##'] = '';
}
$tmp['##author.phone##'] = $user_tmp->getField('phone');
$tmp['##author.phone2##'] = $user_tmp->getField('phone2');
$this->datas['authors'][] = $tmp;
}
$this->datas['##ticket.authors##'] = implode(', ', $users);
} else {
$this->datas['##ticket.authors##'] = '';
}
if ($this->obj->getField('users_id_recipient')) {
$user_tmp = new User();
$user_tmp->getFromDB($this->obj->getField('users_id_recipient'));
$this->datas['##ticket.openbyuser##'] = $user_tmp->getName();
} else {
$this->datas['##ticket.openbyuser##'] = '';
}
if ($this->obj->countUsers(Ticket::ASSIGN)) {
$users = array();
foreach ($this->obj->getUsers(Ticket::ASSIGN) as $uid => $tmp) {
$user_tmp = new User();
$user_tmp->getFromDB($uid);
$users[$uid] = $user_tmp->getName();
}
$this->datas['##ticket.assigntousers##'] = implode(', ', $users);
} else {
$this->datas['##ticket.assigntousers##'] = '';
}
if ($this->obj->countUsers(Ticket::OBSERVER)) {
$users = array();
foreach ($this->obj->getUsers(Ticket::OBSERVER) as $uid => $tmp) {
$user_tmp = new User();
$user_tmp->getFromDB($uid);
$users[$uid] = $user_tmp->getName();
}
$this->datas['##ticket.observerusers##'] = implode(', ', $users);
} else {
$this->datas['##ticket.observerusers##'] = '';
}
if ($this->obj->getField('suppliers_id_assign')) {
$this->datas['##ticket.assigntosupplier##'] = Dropdown::getDropdownName('glpi_suppliers', $this->obj->getField('suppliers_id_assign'));
} else {
$this->datas['##ticket.assigntosupplier##'] = '';
}
if ($this->obj->countGroups(Ticket::REQUESTER)) {
$groups = array();
foreach ($this->obj->getUsers(Ticket::REQUESTER) as $gid => $tmp) {
$groups[$gid] = Dropdown::getDropdownName('glpi_groups', $gid);
}
$this->datas['##ticket.groups##'] = implode(', ', $groups);
} else {
$this->datas['##ticket.groups##'] = '';
}
if ($this->obj->countGroups(Ticket::OBSERVER)) {
$groups = array();
foreach ($this->obj->getGroups(Ticket::OBSERVER) as $gid => $tmp) {
$groups[$gid] = Dropdown::getDropdownName('glpi_groups', $gid);
}
$this->datas['##ticket.observergroups##'] = implode(', ', $groups);
} else {
$this->datas['##ticket.observergroups##'] = '';
}
if ($this->obj->countGroups(Ticket::ASSIGN)) {
$groups = array();
foreach ($this->obj->getGroups(Ticket::ASSIGN) as $gid => $tmp) {
$groups[$gid] = Dropdown::getDropdownName('glpi_groups', $gid);
}
$this->datas['##ticket.assigntogroups##'] = implode(', ', $groups);
} else {
$this->datas['##ticket.assigntogroups##'] = '';
}
//Tags associated with the object linked to the ticket
if ($this->target_object != null) {
//Object type
$this->datas['##ticket.itemtype##'] = $this->target_object->getTypeName();
//Object name
$this->datas['##ticket.item.name##'] = $this->target_object->getField('name');
//Object serial
if ($this->target_object->isField('serial')) {
$this->datas['##ticket.item.serial##'] = $this->target_object->getField('serial');
} else {
$this->datas['##ticket.item.serial##'] = '';
}
//Object contact
if ($this->target_object->isField('contact')) {
$this->datas['##ticket.item.contact##'] = $this->target_object->getField('contact');
} else {
$this->datas['##ticket.item.contact##'] = '';
}
//Object contact num
if ($this->target_object->isField('contact_num')) {
$this->datas['##ticket.item.contactnumber##'] = $this->target_object->getField('contact_num');
} else {
$this->datas['##ticket.item.contactnumber##'] = '';
}
//Object otherserial
if ($this->target_object->isField('otherserial')) {
$this->datas['##ticket.item.otherserial##'] = $this->target_object->getField('otherserial');
} else {
$this->datas['##ticket.item.otherserial##'] = '';
}
//Object location
if ($this->target_object->isField('locations_id')) {
$this->datas['##ticket.item.location##'] = Dropdown::getDropdownName('glpi_locations', $this->target_object->getField('locations_id'));
} else {
$this->datas['##ticket.item.location##'] = '';
}
//Object user
$this->datas['##ticket.item.user##'] = '';
if ($this->obj->getField('users_id')) {
$user_tmp = new User();
if ($user_tmp->getFromDB($this->target_object->getField('users_id'))) {
$this->datas['##ticket.item.user##'] = $user_tmp->getName();
}
}
//Object group
if ($this->obj->getField('groups_id')) {
$this->datas['##ticket.item.group##'] = Dropdown::getDropdownName('glpi_groups', $this->target_object->getField('groups_id'));
} else {
$this->datas['##ticket.item.group##'] = '';
}
$modeltable = getSingular($this->getTable()) . "models";
$modelfield = getForeignKeyFieldForTable($modeltable);
if ($this->target_object->isField($modelfield)) {
$this->datas['##ticket.item.model##'] = $this->target_object->getField($modelfield);
} else {
$this->datas['##ticket.item.model##'] = '';
}
} else {
$this->datas['##ticket.itemtype##'] = '';
$this->datas['##ticket.item.name##'] = '';
$this->datas['##ticket.item.serial##'] = '';
$this->datas['##ticket.item.otherserial##'] = '';
$this->datas['##ticket.item.location##'] = '';
}
if ($this->obj->getField('ticketsolutiontypes_id')) {
$this->datas['##ticket.solution.type##'] = Dropdown::getDropdownName('glpi_ticketsolutiontypes', $this->obj->getField('ticketsolutiontypes_id'));
} else {
$this->datas['##ticket.solution.type##'] = '';
}
$this->datas['##ticket.solution.description##'] = unclean_cross_side_scripting_deep($this->obj->getField('solution'));
// Linked tickets
$linked_tickets = Ticket_Ticket::getLinkedTicketsTo($this->obj->getField('id'));
if (count($linked_tickets)) {
$linkedticket = new Ticket();
foreach ($linked_tickets as $data) {
if ($linkedticket->getFromDB($data['tickets_id'])) {
$tmp = array();
$tmp['##linkedticket.id##'] = $data['tickets_id'];
$tmp['##linkedticket.link##'] = Ticket_Ticket::getLinkName($data['link']);
$tmp['##linkedticket.url##'] = urldecode($CFG_GLPI["url_base"] . "/index.php" . "?redirect=ticket_" . $data['tickets_id']);
$tmp['##linkedticket.title##'] = $linkedticket->getField('name');
$tmp['##linkedticket.content##'] = $linkedticket->getField('content');
$this->datas['linkedtickets'][] = $tmp;
}
}
}
if (!empty($this->datas['linkedtickets'])) {
$this->datas['##ticket.numberoflinkedtickets##'] = count($this->datas['linkedtickets']);
} else {
$this->datas['##ticket.numberoflinkedtickets##'] = 0;
}
$restrict = "`tickets_id`='" . $this->obj->getField('id') . "'";
if (!isset($options['additionnaloption']) || !$options['additionnaloption']) {
$restrict .= " AND `is_private` = '0'";
}
$restrict .= " ORDER BY `date` DESC, `id` ASC";
//Task infos
$tasks = getAllDatasFromTable('glpi_tickettasks', $restrict);
foreach ($tasks as $task) {
$tmp = array();
$tmp['##task.isprivate##'] = Dropdown::getYesNo($task['is_private']);
$tmp['##task.author##'] = html_clean(getUserName($task['users_id']));
$tmp['##task.category##'] = Dropdown::getDropdownName('glpi_taskcategories', $task['taskcategories_id']);
$tmp['##task.date##'] = convDateTime($task['date']);
$tmp['##task.description##'] = $task['content'];
$tmp['##task.time##'] = Ticket::getActionTime($task['actiontime']);
$plan = new TicketPlanning();
if ($plan->getFromDBbyTask($task['id'])) {
$tmp['##task.planning.user##'] = html_clean(getUserName($plan->fields['users_id']));
$tmp['##task.planning.begin##'] = convDateTime($plan->fields['begin']);
$tmp['##task.planning.end##'] = convDateTime($plan->fields['end']);
$tmp['##task.planning.status##'] = Planning::getState($plan->fields['state']);
} else {
$tmp['##task.planning.user##'] = "";
$tmp['##task.planning.begin##'] = "";
$tmp['##task.planning.end##'] = "";
$tmp['##task.planning.status##'] = "";
}
$this->datas['tasks'][] = $tmp;
}
if (!empty($this->datas['tasks'])) {
$this->datas['##ticket.numberoftasks##'] = count($this->datas['tasks']);
} else {
$this->datas['##ticket.numberoftasks##'] = 0;
}
//Followup infos
$followups = getAllDatasFromTable('glpi_ticketfollowups', $restrict);
foreach ($followups as $followup) {
$tmp = array();
$tmp['##followup.isprivate##'] = Dropdown::getYesNo($followup['is_private']);
$tmp['##followup.author##'] = html_clean(getUserName($followup['users_id']));
$tmp['##followup.requesttype##'] = Dropdown::getDropdownName('glpi_requesttypes', $followup['requesttypes_id']);
$tmp['##followup.date##'] = convDateTime($followup['date']);
$tmp['##followup.description##'] = $followup['content'];
$this->datas['followups'][] = $tmp;
}
if (isset($this->datas['followups'])) {
$this->datas['##ticket.numberoffollowups##'] = count($this->datas['followups']);
} else {
$this->datas['##ticket.numberoffollowups##'] = 0;
}
//Validation infos
$restrict = "`tickets_id`='" . $this->obj->getField('id') . "'";
if (isset($options['validation_id']) && $options['validation_id']) {
$restrict .= " AND `glpi_ticketvalidations`.`id` = '" . $options['validation_id'] . "'";
}
$restrict .= " ORDER BY `submission_date` DESC, `id` ASC";
$validations = getAllDatasFromTable('glpi_ticketvalidations', $restrict);
foreach ($validations as $validation) {
$tmp = array();
$tmp['##validation.submission.title##'] = $LANG['validation'][27] . " (" . $LANG['job'][4] . " " . html_clean(getUserName($validation['users_id'])) . ")";
$tmp['##validation.answer.title##'] = $LANG['validation'][32] . " (" . $LANG['validation'][21] . " " . html_clean(getUserName($validation['users_id_validate'])) . ")";
$tmp['##validation.author##'] = html_clean(getUserName($validation['users_id']));
$tmp['##validation.status##'] = TicketValidation::getStatus($validation['status']);
$tmp['##validation.storestatus##'] = $validation['status'];
$tmp['##validation.submissiondate##'] = convDateTime($validation['submission_date']);
$tmp['##validation.commentsubmission##'] = $validation['comment_submission'];
$tmp['##validation.validationdate##'] = convDateTime($validation['validation_date']);
$tmp['##validation.validator##'] = html_clean(getUserName($validation['users_id_validate']));
$tmp['##validation.commentvalidation##'] = $validation['comment_validation'];
$this->datas['validations'][] = $tmp;
}
// Ticket Satisfaction
$inquest = new TicketSatisfaction();
if ($inquest->getFromDB($this->obj->getField('id'))) {
// internal inquest
if ($inquest->fields['type'] == 1) {
$this->datas['##ticket.urlsatisfaction##'] = urldecode($CFG_GLPI["url_base"] . "/index.php?redirect=ticket_" . $this->obj->getField("id") . "_10");
// external inquest
} else {
if ($inquest->fields['type'] == 2) {
$this->datas['##ticket.urlsatisfaction##'] = EntityData::generateLinkSatisfaction($this->obj);
}
}
$this->datas['##satisfaction.type##'] = $inquest->getTypeInquestName($inquest->getfield('type'));
$this->datas['##satisfaction.datebegin##'] = convDateTime($inquest->fields['date_begin']);
$this->datas['##satisfaction.dateanswered##'] = convDateTime($inquest->fields['date_answered']);
$this->datas['##satisfaction.satisfaction##'] = $inquest->fields['satisfaction'];
$this->datas['##satisfaction.description##'] = $inquest->fields['comment'];
} else {
$this->datas['##satisfaction.type##'] = '';
$this->datas['##satisfaction.datebegin##'] = '';
$this->datas['##satisfaction.dateanswered##'] = '';
$this->datas['##satisfaction.satisfaction##'] = '';
$this->datas['##satisfaction.description##'] = '';
}
// Use list_limit_max or load the full history ?
foreach (Log::getHistoryData($this->obj, 0, $CFG_GLPI['list_limit_max']) as $data) {
$tmp = array();
$tmp['##ticket.log.date##'] = $data['date_mod'];
$tmp['##ticket.log.user##'] = $data['user_name'];
$tmp['##ticket.log.field##'] = $data['field'];
$tmp['##ticket.log.content##'] = $data['change'];
$this->datas['log'][] = $tmp;
}
if (isset($this->datas['log'])) {
$this->datas['##ticket.numberoflogs##'] = count($this->datas['log']);
} else {
$this->datas['##ticket.numberoflogs##'] = 0;
}
} else {
if (isset($options['entities_id']) && isset($options['tickets'])) {
$this->datas['##ticket.entity##'] = Dropdown::getDropdownName('glpi_entities', $options['entities_id']);
$this->datas['##ticket.action##'] = $LANG['crontask'][15];
$t = new Ticket();
foreach ($options['tickets'] as $ticket) {
$tmp = array();
$t->getFromDB($ticket['id']);
$tmp['##ticket.id##'] = sprintf("%07d", $ticket['id']);
$tmp['##ticket.url##'] = urldecode($CFG_GLPI["url_base"] . "/index.php?redirect=ticket_" . $ticket['id']);
$tmp['##ticket.title##'] = $ticket['name'];
$tmp['##ticket.status##'] = Ticket::getStatus($ticket['status']);
$tmp['##ticket.globalvalidation##'] = TicketValidation::getStatus($ticket['global_validation']);
$tmp['##ticket.requesttype##'] = Dropdown::getDropdownName('glpi_requesttypes', $ticket['requesttypes_id']);
$tmp['##ticket.urgency##'] = Ticket::getUrgencyName($ticket['urgency']);
$tmp['##ticket.impact##'] = Ticket::getImpactName($ticket['impact']);
$tmp['##ticket.priority##'] = Ticket::getPriorityName($ticket['priority']);
$tmp['##ticket.time##'] = Ticket::getActionTime($ticket['actiontime']);
$tmp['##ticket.costtime##'] = $ticket['cost_time'];
$tmp['##ticket.creationdate##'] = convDateTime($ticket['date']);
$tmp['##ticket.content##'] = $ticket['content'];
if ($t->getField('ticketsolutiontypes_id')) {
$tmp['##ticket.solution.type##'] = Dropdown::getDropdownName('glpi_ticketsolutiontypes', $t->getField('ticketsolutiontypes_id'));
} else {
$this->datas['##ticket.solution.type##'] = '';
}
$tmp['##ticket.solution.description##'] = unclean_cross_side_scripting_deep($t->getField('solution'));
if ($t->countUsers(Ticket::REQUESTER)) {
$users = array();
foreach ($t->getUsers(Ticket::REQUESTER) as $uid => $val) {
$user_tmp = new User();
$user_tmp->getFromDB($uid);
$users[$uid] = $user_tmp->getName();
$tmp2 = array();
$tmp2['##author.id##'] = $uid;
$tmp2['##author.name##'] = $user_tmp->getName();
if ($user_tmp->getField('locations_id')) {
$tmp2['##author.location##'] = Dropdown::getDropdownName('glpi_locations', $user_tmp->getField('locations_id'));
} else {
$tmp2['##author.location##'] = '';
}
$tmp2['##author.phone##'] = $user_tmp->getField('phone');
$tmp2['##author.phone2##'] = $user_tmp->getField('phone2');
$tmp['authors'][] = $tmp2;
}
$tmp['##ticket.authors##'] = implode(', ', $users);
} else {
$tmp['##ticket.authors##'] = '';
}
if ($t->countUsers(Ticket::ASSIGN)) {
$users = array();
foreach ($t->getUsers(Ticket::ASSIGN) as $uid => $val) {
$user_tmp = new User();
$user_tmp->getFromDB($uid);
$users[$uid] = $user_tmp->getName();
}
$tmp['##ticket.assigntousers##'] = implode(', ', $users);
} else {
$tmp['##ticket.assigntousers##'] = '';
}
if ($t->countGroups(Ticket::ASSIGN)) {
$groups = array();
foreach ($t->getGroups(Ticket::ASSIGN) as $gid => $val) {
$groups[$gid] = Dropdown::getDropdownName('glpi_groups', $gid);
}
$tmp['##ticket.assigntogroups##'] = implode(', ', $groups);
} else {
$tmp['##ticket.assigntogroups##'] = '';
}
if ($t->countGroups(Ticket::REQUESTER)) {
$groups = array();
foreach ($t->getGroups(Ticket::REQUESTER) as $gid => $val) {
$groups[$gid] = Dropdown::getDropdownName('glpi_groups', $gid);
}
$tmp['##ticket.groups##'] = implode(', ', $groups);
} else {
$tmp['##ticket.groups##'] = '';
}
if ($t->countUsers(Ticket::OBSERVER)) {
$users = array();
foreach ($t->getUsers(Ticket::OBSERVER) as $uid => $tmp) {
$user_tmp = new User();
$user_tmp->getFromDB($uid);
$users[$uid] = $user_tmp->getName();
}
$tmp['##ticket.observerusers##'] = implode(', ', $users);
} else {
$tmp['##ticket.observerusers##'] = '';
}
if ($t->countGroups(Ticket::OBSERVER)) {
$groups = array();
foreach ($t->getGroups(Ticket::OBSERVER) as $gid => $tmp) {
$groups[$gid] = Dropdown::getDropdownName('glpi_groups', $gid);
}
$tmp['##ticket.observergroups##'] = implode(', ', $groups);
} else {
$tmp['##ticket.observergroups##'] = '';
}
if ($ticket['suppliers_id_assign']) {
$tmp['##ticket.assigntosupplier##'] = Dropdown::getDropdownName('glpi_suppliers', $ticket['suppliers_id_assign']);
} else {
$tmp['##ticket.assigntosupplier##'] = '';
}
$this->datas['tickets'][] = $tmp;
}
}
}
$this->getTags();
foreach ($this->tag_descriptions[NotificationTarget::TAG_LANGUAGE] as $tag => $values) {
if (!isset($this->datas[$tag])) {
$this->datas[$tag] = $values['label'];
}
}
}
