Usuário:AlexSP/Testes: diferenças entre revisões
Conteúdo apagado Conteúdo adicionado
Linha 1:
<?php
/*
* @version $Id: ticket.class.php
-------------------------------------------------------------------------
GLPI - Gestionnaire Libre de Parc Informatique
Copyright (C) 2003-
http://indepnet.net/ http://glpi-project.org
Linha 28:
*/
/** @file
* @brief
*/
if (!defined('GLPI_ROOT')) {
Linha 38 ⟶ 36:
}
/**
* Ticket Class
**/
class Ticket extends CommonITILObject {
// From CommonDBTM
public $dohistory = true;
static protected $forward_entity_to = array('TicketValidation', 'TicketCost');
// From CommonITIL
public $userlinkclass = 'Ticket_User';
public $grouplinkclass = 'Group_Ticket';
public $supplierlinkclass = 'Supplier_Ticket';
static $rightname = 'ticket';
protected $userentity_oncreate = true;
const
const
const IMPACT_MASK_FIELD = 'impact_mask';
const STATUS_MATRIX_FIELD = 'ticket_status';
// HELPDESK LINK HARDWARE DEFINITION : CHECKSUM SYSTEM : BOTH=1*2^0+1*2^1=3
const HELPDESK_MY_HARDWARE = 0;
const HELPDESK_ALL_HARDWARE = 1;
// Specific ones
Linha 66 ⟶ 73:
// Demand type
const DEMAND_TYPE = 2;
const READMY = 1;
const READALL = 1024;
const READGROUP = 2048;
const READASSIGN = 4096;
const ASSIGN = 8192;
const STEAL = 16384;
const OWN = 32768;
const CHANGEPRIORITY = 65536;
function getForbiddenStandardMassiveAction() {
$forbidden = parent::getForbiddenStandardMassiveAction();
if (!Session::haveRightsOr(self::$rightname, array(DELETE, PURGE))) {
$forbidden[] = 'delete';
$forbidden[] = 'purge';
$forbidden[] = 'restore';
}
return $forbidden;
}
Linha 71 ⟶ 101:
* Name of the type
*
* @param $nb : number of item in the type (default 0)
**/
static function getTypeName($nb=0) {
}
/**
* @see CommonGLPI::getMenuShorcut()
*
* @since version 0.85
**/
static function getMenuShorcut() {
return 't';
}
/**
* @see CommonGLPI::getAdditionalMenuOptions()
*
* @since version 0.85
**/
static function getAdditionalMenuOptions() {
if (TicketTemplate::canView()) {
$menu['TicketTemplate']['title'] = TicketTemplate::getTypeName(2);
$menu['TicketTemplate']['page'] = TicketTemplate::getSearchURL(false);
$menu['TicketTemplate']['links']['search'] = TicketTemplate::getSearchURL(false);
if (TicketTemplate::canCreate()) {
$menu['TicketTemplate']['links']['add'] = TicketTemplate::getFormURL(false);
}
return $menu;
}
return false;
}
/**
* @see CommonGLPI::getAdditionalMenuContent()
*
* @since version 0.85
**/
static function getAdditionalMenuContent() {
$menu['create_ticket']['title'] = __('Create ticket');
$menu['create_ticket']['page'] = static::getFormURL(false);
return $menu;
}
}
/**
* @see CommonGLPI::getAdditionalMenuLinks()
*
* @since version 0.85
**/
static function getAdditionalMenuLinks() {
global $CFG_GLPI;
$links = array();
if (TicketTemplate::canView()) {
$links['template'] = TicketTemplate::getSearchURL(false);
}
if (Session::haveRightsOr('ticketvalidation', TicketValidation::getValidateRights())) {
$opt = array();
$opt['reset'] = 'reset';
$opt['criteria'][0]['field'] = 55; // validation status
$opt['criteria'][0]['searchtype'] = 'equals';
$opt['criteria'][0]['value'] = CommonITILValidation::WAITING;
$opt['criteria'][0]['link'] = 'AND';
$opt['criteria'][1]['field'] = 59; // validation aprobator
$opt['criteria'][1]['searchtype'] = 'equals';
$opt['criteria'][1]['value'] = Session::getLoginUserID();
$opt['criteria'][1]['link'] = 'AND';
$pic_validate = "<img title=\"".__s('Ticket waiting for your approval')."\" alt=\"".
__s('Ticket waiting for your approval')."\" src='".
$CFG_GLPI["root_doc"]."/pics/menu_showall.png'>";
$links[$pic_validate] = '/front/ticket.php?'.Toolbox::append_params($opt, '&');
}
if (count($links)) {
return $links;
}
return false;
}
function
return Session::haveRight(self::$rightname, UPDATE);
}
function canAssign() {
}
function canAssignToMe() {
return (Session::haveRight(self::$rightname, self::STEAL)
|| (Session::haveRight(self::$rightname, self::OWN)
}
static function
// To allow update of urgency and category for post-only
if ($_SESSION["glpiactiveprofile"]["interface"] == "helpdesk") {
return Session::haveRight(self::$rightname, CREATE);
}
return
array(UPDATE, self::ASSIGN, self::STEAL, self::OWN));
}
static function canView() {
/*
if (isset($_SESSION['glpiactiveprofile']['interface'])
&& $_SESSION['glpiactiveprofile']['interface'] == 'helpdesk') {
return true;
}*/
return (Session::haveRightsOr(self::$rightname,
array(self::READALL, self::READMY, UPDATE, self::READASSIGN,
self::READGROUP, self::OWN))
|| Session::haveRightsOr('ticketvalidation', TicketValidation::getValidateRights()));
}
Linha 164 ⟶ 243:
return false;
}
return (Session::haveRight(self::$rightname, self::READALL)
|| $this->isUser(
|| $this->isUser(
|| (Session::haveRight(
&& isset($_SESSION["glpigroups"])
&& ($this->haveAGroup(
|| $this->haveAGroup(
|| (Session::haveRight(
&& ($this->isUser(
|| (isset($_SESSION["glpigroups"])
&& $this->haveAGroup(
|| (Session::haveRight(
&& ($this->fields["status"] == self::INCOMING))))
|| (Session::haveRightsOr('ticketvalidation', TicketValidation::getValidateRights())
}
Linha 192 ⟶ 269:
**/
function canSolve() {
return ((Session::haveRight(
|| $this->isUser(
|| (isset($_SESSION["glpigroups"])
&& $this->haveAGroup(
&& self::isAllowedStatus($this->fields['status'],
// No edition on closed status
&& !in_array($this->fields['status'], $this->getClosedStatusArray()));
}
Linha 208 ⟶ 287:
function canApprove() {
return (($this->fields["users_id_recipient"] === Session::getLoginUserID())
|| $this->isUser(
|| (isset($_SESSION["glpigroups"])
&& $this->haveAGroup(
}
/**
* @see CommonDBTM::canMassiveAction()
**/
function canMassiveAction($action, $field, $value) {
switch ($action) {
case 'update' :
switch ($field) {
case 'status' :
if (!self::isAllowedStatus($this->fields['status'], $value)) {
return false;
}
break;
}
break;
}
return true;
}
Linha 218 ⟶ 317:
* Get Datas to be added for SLA add
*
* @param $slas_id SLA id
* @param $entities_id entity ID of the ticket
* @param $date begin date of the ticket
*
* @return array of datas to add in ticket
**/
function getDatasToAddSLA($slas_id, $entities_id, $date) {
$calendars_id =
$data = array();
Linha 233 ⟶ 332:
$sla->setTicketCalendar($calendars_id);
// Get first SLA Level
$data["slalevels_id"] = SlaLevel::getFirstSlaLevel($slas_id);
// Compute due_date
$data['due_date'] = $sla->computeDueDate($date);
Linha 243 ⟶ 342:
$data['sla_waiting_duration'] = 0;
}
return $data;
Linha 261 ⟶ 359:
$input['slas_id'] = 0;
$input['slalevels_id'] = 0;
$input['sla_waiting_duration'] = 0;
$input['id'] = $id;
Linha 280 ⟶ 378:
return false;
}
return
}
Linha 295 ⟶ 393:
}
if (($this->numberOfFollowups() == 0)
&& ($this->numberOfTasks() == 0)
&& ($this->isUser(
|| ($this->fields["users_id_recipient"] === Session::getLoginUserID()))) {
return true;
}
return
}
/**
* @since version 0.85
**/
static function canDelete() {
// to allow delete for self-service only if no action on the ticket
if ($_SESSION["glpiactiveprofile"]["interface"] == "helpdesk") {
return Session::haveRight(self::$rightname, CREATE);
}
return Session::haveRight(self::$rightname, DELETE);
}
Linha 318 ⟶ 429:
// user can delete his ticket if no action on it
if (($this->isUser(
|| ($this->fields["users_id_recipient"] === Session::getLoginUserID()))
&& ($this->numberOfFollowups() == 0)
&& ($this->numberOfTasks() == 0)
&& ($this->fields["date"] == $this->fields["date_mod"])) {
return true;
}
return
}
/**
* @see CommonITILObject::getDefaultActor()
**/
function getDefaultActor($type) {
if ($type ==
if (Session::haveRight(
&& $_SESSION['glpiset_default_tech']) {
return Session::getLoginUserID();
Linha 342 ⟶ 456:
/**
* @see CommonITILObject::getDefaultActorRightSearch()
**/
function getDefaultActorRightSearch($type) {
$right = "all";
if ($type ==
$right = "own_ticket";
if (!Session::haveRight(
$right = 'id';
}
Linha 363 ⟶ 480:
function getTabNameForItem(CommonGLPI $item, $withtemplate=0) {
if (
$nb = 0;
$title =
if ($_SESSION['glpishow_count_on_tabs']) {
switch ($item->getType()) {
case 'User' :
$nb = countElementsInTable('glpi_tickets_users',
"`users_id` = '".$item->getID()."'
AND `type` = ".
$title =
break;
case 'Supplier' :
$nb = countElementsInTable('
"`
break;
Linha 400 ⟶ 506:
$nb = countElementsInTable('glpi_groups_tickets',
"`groups_id` = '".$item->getID()."'
AND `type` = ".
$title =
break;
Linha 410 ⟶ 516:
AND `items_id` = '".$item->getID()."'");
// Linked items
if
foreach ($linkeditems as $type => $tab) {
foreach ($tab as $ID) {
$nb += countElementsInTable('glpi_tickets',
" `itemtype` = '$type'
AND `items_id` = '$ID'");
}
}
}
break;
}
} // glpishow_count_on_tabs
// Not for Ticket class
if ($item->getType() != __CLASS__) {
return self::createTabEntry($title, $nb);
}
} //
// Not check
switch ($item->getType()) {
case __CLASS__ :
$ong = array();
$ong[2] =
// enquete si statut clos
if ($item->fields['status'] ==
$satisfaction = new TicketSatisfaction();
if ($satisfaction->getFromDB($item->getID())) {
$ong[3] =
}
}
if (
$ong[4] =
}
return $ong;
// default :
// return
}
return '';
}
Linha 451 ⟶ 564:
static function displayTabContentForItem(CommonGLPI $item, $tabnum=1, $withtemplate=0) {
switch ($item->getType()) {
case __CLASS__ :
switch ($tabnum) {
case 2 :
if (!isset($
$
}
$item->showSolutionForm($
if ($item->canApprove()) {
$fup = new TicketFollowup();
Linha 481 ⟶ 583:
case 3 :
$satisfaction = new TicketSatisfaction();
if (($item->fields['status'] ==
&& $satisfaction->getFromDB($ $satisfaction->
} else {
echo "<p class='center b'>".
}
break;
Linha 504 ⟶ 607:
function defineTabs($options=array()) {
$ong = array();
$this->addDefaultFormTab($ong);
$this->addStandardTab('TicketFollowup',$ong, $options);
$this->addStandardTab('TicketValidation', $ong, $options);
$this->addStandardTab('TicketTask', $ong, $options);
$this->addStandardTab(__CLASS__, $ong, $options);
$this->addStandardTab('
$this->addStandardTab('
$this->addStandardTab('Change_Ticket', $ong, $options);
$this->addStandardTab('Log', $ong, $options);
Linha 527 ⟶ 631:
function getAdditionalDatas() {
if ($this->fields["itemtype"]
&& ($item = getItemForItemtype($this->fields["itemtype"]))) { if ($item->getFromDB($this->fields["items_id"])) {
$this->hardwaredatas=$item;
}
} else {
$this->hardwaredatas = NULL;
}
}
Linha 551 ⟶ 655:
$DB->query($query1);
$
$ts->cleanDBonItemDelete($this->getType(), $this->fields['id']);
$query1 = "DELETE
Linha 560 ⟶ 663:
WHERE `tickets_id` = '".$this->fields['id']."'";
$DB->query($query1);
$pt = new Problem_Ticket();
$pt->cleanDBonItemDelete('Ticket', $this->fields['id']);
$ts = new TicketCost();
$ts->cleanDBonItemDelete($this->getType(), $this->fields['id']);
SlaLevel_Ticket::deleteForTicket($this->getID());
Linha 566 ⟶ 675:
FROM `glpi_tickets_tickets`
WHERE `tickets_id_1` = '".$this->fields['id']."'
OR `tickets_id_2` = '".$this->fields['id']."'";
$DB->query($query1);
$ct = new Change_Ticket();
$ct->cleanDBonItemDelete(__CLASS__, $this->fields['id']);
parent::cleanDBonPurge();
Linha 575 ⟶ 687:
function prepareInputForUpdate($input) {
global $
// Get ticket : need for comparison
$this->getFromDB($input['id']);
// Clean new lines before passing to rules
if ($CFG_GLPI["use_rich_text"] && isset($input["content"])) {
$input["content"] = preg_replace('/\\\\r\\\\n/',"\n",$input['content']);
$input["content"] = preg_replace('/\\\\n/',"\n",$input['content']);
}
// automatic recalculate if user changes urgence or technician change impact
if (isset($input['urgency'])
&& isset($input['impact'])
&& (($input['urgency'] != $this->fields['urgency'])
|| $input['impact'] != $this->fields['impact'])
&& !isset($input['priority'])) {
$input['priority'] = self::computePriority($input['urgency'], $input['impact']);
}
// Security checks
if (
&& !Session::haveRight(self::$rightname, self::ASSIGN)) {
if (isset($input["_itil_assign"])
&& isset($input['_itil_assign']['_type'])
&& ($input['_itil_assign']['_type'] == 'user')) {
// must own_ticket to grab a non assign ticket
if ($this->countUsers(
if ((!Session::
|| !isset($input["_itil_assign"]['users_id'])
|| ($input["_itil_assign"]['users_id'] != Session::getLoginUserID())) {
Linha 621 ⟶ 724:
} else {
// Can not steal or can steal and not assign to me
if (!Session::haveRight(
|| !isset($input["_itil_assign"]['users_id'])
|| ($input["_itil_assign"]['users_id'] != Session::getLoginUserID())) {
Linha 630 ⟶ 733:
// No supplier assign
if (isset($input["
&& ($input['_itil_assign']['_type'] == 'supplier')) {
unset($input["_itil_assign"]);
}
// No group
if (isset($input["_itil_assign"])
&& isset($input['_itil_assign']['_type'])
&& ($input['_itil_assign']['_type'] == 'group')) {
unset($input["_itil_assign"]);
}
}
$check_allowed_fields_for_template = false;
$allowed_fields = array();
if (!Session::isCron()
&& !Session::haveRight(self::$rightname, UPDATE)) {
$allowed_fields = array('id');
$check_allowed_fields_for_template = true;
if ($this->canApprove()
&& isset($input["status"])) { $allowed_fields[] = 'status';
}
// for post-only with validate right or validation created by rules
|| isset($input["_rule_process"])) {
$allowed_fields[] = 'global_validation';
}
// Manage assign and steal right
if (Session::
$allowed_fields[] = '_itil_assign';
}
// Can only update initial fields if no followup or task already added
if (($this->numberOfFollowups() == 0)
&& ($this->numberOfTasks() == 0)
&& $this->isUser(
$allowed_fields[] = 'content';
$allowed_fields[] = 'urgency';
$allowed_fields[] = 'priority'; // automatic recalculate if user changes urgence
Linha 685 ⟶ 780:
$allowed_fields[] = 'items_id';
$allowed_fields[] = 'name';
}
Linha 701 ⟶ 795:
$input = $ret;
}
//// check mandatory fields
// First get ticket template associated : entity and type/category
if (isset($input['entities_id'])) {
$entid = $input['entities_id'];
} else {
$entid = $this->fields['entities_id'];
}
Linha 730 ⟶ 817:
}
if (count($tt->mandatory)) {
$mandatory_missing = array();
$fieldsname = $tt->getAllowedFieldsNames(true);
foreach ($tt->mandatory as $key => $val) {
if ((!$check_allowed_fields_for_template || in_array($key,$allowed_fields))
&& (empty($input[$key]) || ($input[$key] == 'NULL')) // Take only into account already set items : do not block old tickets
&& (!empty($this->fields[$key]))
)) {
$mandatory_missing[$key] = $fieldsname[$val];
}
}
if (count($mandatory_missing)) {
//TRANS: %s are the fields concerned
$message = sprintf(__('Mandatory fields are not filled. Please correct: %s'),
implode(", ",$mandatory_missing));
Session::addMessageAfterRedirect($message, false, ERROR);
return false;
Linha 768 ⟶ 841:
}
/// Process Business Rules
// Add actors on standard input
$rules = new RuleTicketCollection($entid);
$rule = $rules->getRuleClass();
$changes = array();
$tocleanafterrules = array();
$usertypes = array('assign', 'requester', 'observer');
foreach ($usertypes as $t) {
if (isset($input['_itil_'.$t]) && isset($input['_itil_'.$t]['_type'])) {
$field = $input['_itil_'.$t]['_type'].'s_id';
if (isset($input['_itil_'.$t][$field])
&& !isset($input[$field.'_'.$t])) {
$input['_'.$field.'_'.$t] = $input['_itil_'.$t][$field];
$tocleanafterrules['_'.$field.'_'.$t] = $input['_itil_'.$t][$field];
}
}
}
foreach ($rule->getCriterias() as $key => $val) {
if
if (!isset($this->fields[$key])
|| ($DB->escape($this->fields[$key]) != $input[$key])) {
$changes[] = $key;
}
}
}
// Business Rules do not override manual SLA
$manual_slas_id = 0;
if (isset($input['slas_id']) && ($input['slas_id'] > 0)) {
$manual_slas_id = $input['slas_id'];
}
// Only process rules on changes
if (count($changes)) {
// If itemtype changed : set items_locations
if (in_array('itemtype', $changes)) {
$item = NULL;
if (isset($input["items_id"]) && ($input["items_id"] > 0)
&& !empty($input["itemtype"])) {
if ($item = getItemForItemtype($input["itemtype"])) {
if ($item->getFromDB($input["items_id"])) {
if ($item->isField('locations_id')) {
$input['items_locations'] = $item->fields['locations_id'];
$changes[] = 'items_locations';
}
}
}
}
}
if (in_array('_users_id_requester', $changes)) {
$user = new User();
if (isset($input["_users_id_requester"])
&& $user->getFromDB($input["_users_id_requester"])) {
$input['users_locations'] = $user->fields['locations_id'];
$changes[] = 'users_locations';
}
// If _users_id_requester changed : add _groups_id_of_requester to changes
$changes[] = '_groups_id_of_requester';
}
$input = $rules->processAllRules(Toolbox::stripslashes_deep($input),
Toolbox::stripslashes_deep($input),
array('recursive' => true,
'entities_id' => $entid),
array('condition' => RuleTicket::ONUPDATE,
'only_criteria' => $changes));
}
// Restore slas_id
if ($manual_slas_id > 0) {
$input['slas_id'] = $manual_slas_id;
}
//Action for send_validation rule : do validation before clean
$this->manageValidationAdd($input);
// Clean actors fields added for rules
foreach ($tocleanafterrules as $key => $val) {
if ($input[$key] == $val) {
unset($input[$key]);
}
}
// Manage fields from auto update or rules : map rule actions to standard additional ones
$usertypes = array('assign', 'requester', 'observer');
$actortypes = array('user','group','supplier');
foreach ($usertypes as $t) {
foreach ($actortypes as $a) {
if (isset($input['_'.$a.'s_id_'.$t])) {
switch ($a) {
case 'user' :
$additionalfield = '_additional_'.$t.'s';
$input[$additionalfield][] = array('users_id' => $input['_'.$a.'s_id_'.$t]);
break;
default :
$additionalfield = '_additional_'.$a.'s_'.$t.'s';
$input[$additionalfield][] = $input['_'.$a.'s_id_'.$t];
break;
}
}
}
}
Linha 800 ⟶ 952:
$ticket_ticket = new Ticket_Ticket();
if (!empty($input['_link']['tickets_id_2'])) {
if ($ticket_ticket->can(-1,
if ($ticket_ticket->add($input['_link'])) {
$input['_forcenotif'] = true;
}
} else {
Session::addMessageAfterRedirect(
}
}
}
if (isset($input["
}
//// SLA affect by rules : reset due_date
// Manual SLA defined : reset due date
// No manual SLA and due date defined : reset auto SLA
if (($manual_slas_id == 0)
&&
&& ($input['slas_id'] > 0)
&& ($input['slas_id'] !=
if (isset($input['due_date'])) {
// Unset due date
unset($input["due_date"]);
}
}
$date = $this->fields['date'];
/// Use updated date if also done
if (isset($
$date = $
}
// Get datas to initialize SLA and set it
$sla_data = $this->getDatasToAddSLA($
$date);
if (count($sla_data)) {
Linha 873 ⟶ 999:
}
if (isset($input['_stock_image'])) {
$this->addImagePaste();
$input['content'] = $input['content'];
$input['_disablenotif'] = true;
} else if ($CFG_GLPI["use_rich_text"]) {
$input['content'] = $this->convertTagToImage($input['content']);
if (!isset($input['_filename'])) {
$input['_donotadddocs'] = true;
}
}
}
$input = parent::prepareInputForUpdate($input);
return $input;
}
Linha 880 ⟶ 1 018:
function pre_updateInDB() {
// takeintoaccount :
// - update done by someone who have update right
// see also updatedatemod used by ticketfollowup updates if (($this->fields['takeintoaccount_delay_stat'] == 0)
&& (Session::haveRight("
|| Session::
array(TicketFollowup::ADDALLTICKET,
TicketFollowup::ADDMYTICKET,
TicketFollowup::ADDGROUPTICKET))
|| $this->isUser(CommonITILActor::ASSIGN, Session::getLoginUserID())
|| (isset($_SESSION["glpigroups"])
&& $this->haveAGroup(
$this->updates[] = "takeintoaccount_delay_stat";
$this->fields['takeintoaccount_delay_stat'] = $this->computeTakeIntoAccountDelayStat();
Linha 902 ⟶ 1 044:
function computeTakeIntoAccountDelayStat() {
if (isset($this->fields['id'])
&& !empty($this->fields['date'])) { $calendars_id =
$calendar = new Calendar();
// Using calendar
if (($calendars_id > 0) && $calendar->getFromDB($calendars_id)) {
return max(0, $calendar->getActiveTimeBetween($this->fields['date'],
$_SESSION["glpi_currenttime"]));
}
// Not calendar defined
Linha 920 ⟶ 1 063:
function post_updateItem($history=1) {
global $CFG_GLPI
$donotif = count($this->updates);
Linha 927 ⟶ 1 070:
$donotif = true;
}
// Manage SLA Level : add actions
if (in_array("slas_id", $this->updates)
&& ($this->fields["slas_id"] > 0)) {
// Add First Level
$calendars_id =
$sla = new SLA();
Linha 940 ⟶ 1 082:
$sla->setTicketCalendar($calendars_id);
// Add first level in working table
if ($this->fields["slalevels_id"] > 0) {
$sla->addLevelToDo($this);
}
Linha 950 ⟶ 1 092:
if (count($this->updates)) {
// Update Ticket Tco
if (in_array("actiontime", $this->updates)
|| in_array("cost_time", $this->updates)
|| in_array("cost_fixed", $this->updates)
|| in_array("cost_material", $this->updates)) {
if ($this->fields["itemtype"]
&& ($item = getItemForItemtype($this->fields["itemtype"]))) {
if ($item->getFromDB($this->fields["items_id"])) {
$newinput = array();
$newinput['id'] = $this->fields["items_id"];
$newinput['ticket_tco'] = self::computeTco($item);
Linha 967 ⟶ 1 110:
// Setting a solution type means the ticket is solved
if ((in_array("solutiontypes_id", $this->updates)
Ticket_Ticket::manageLinkedTicketsOnSolved($this->fields['id']);
}
// Clean content to mail
//$this->fields["content"] = stripslashes($this->fields["content"]);
$donotif = true;
}
Linha 989 ⟶ 1 132:
if (isset($this->input["status"])
&& $this->input["status"]
&& in_array("status", $this->updates)
&& in_array($this->input["status"], $this->getSolvedStatusArray())) {
Linha 1 002 ⟶ 1 145:
$mailtype = "closed";
}
// Read again ticket to be sure that all data are up to date
$this->getFromDB($this->fields['id']);
Linha 1 010 ⟶ 1 152:
// inquest created immediatly if delay = O
$inquest = new TicketSatisfaction();
$rate =
$delay =
$type =
$max_closedate = $this->fields['closedate'];
Linha 1 032 ⟶ 1 174:
function prepareInputForAdd($input) {
global $CFG_GLPI
// save value before clean;
$title = ltrim($input['name']);
// Standard clean datas
$input = parent::prepareInputForAdd($input);
Linha 1 042 ⟶ 1 182:
// Do not check mandatory on auto import (mailgates)
if (!isset($input['_auto_import'])) {
if (isset($input['_tickettemplates_id']) && $input['_tickettemplates_id']) {
$tt = new TicketTemplate();
Linha 1 052 ⟶ 1 187:
if (count($tt->mandatory)) {
$mandatory_missing = array();
$fieldsname = $tt->getAllowedFieldsNames(true);
foreach ($tt->mandatory as $key => $val) {
// for title if mandatory (restore initial value)
if ($key == 'name') {
$input['name'] = $title;
}
// Check only defined values : Not defined not in form
if (isset($input[$key])) {
// If content is also predefined need to be different from predefined value
if (($key == 'content')
&& isset($tt->predefined['content'])) { // Clean new lines to be fix encoding
if (strcmp(preg_replace("/\r?\n/", ""
preg_replace("/\r?\n/", "",
$tt->predefined['content'])) == 0) {
$mandatory_missing[$key] = $fieldsname[$val];
}
}
if (empty($input[$key]) || ($input[$key] == 'NULL')) {
$mandatory_missing[$key] = $fieldsname[$val];
}
}
// For due_date : check also slas_id
if (($key == 'due_date')
&& isset($input['slas_id']) && ($input['slas_id'] > 0)
&& isset($mandatory_missing['due_date'])) {
unset($mandatory_missing['due_date']);
}
}
if (count($mandatory_missing)) {
$message = sprintf(__('Mandatory fields are not filled. Please correct: %s'),
implode(", ",$mandatory_missing));
Session::addMessageAfterRedirect($message, false, ERROR);
return false;
Linha 1 082 ⟶ 1 228:
}
}
}
if (!isset($input["requesttypes_id"])) {
Linha 1 123 ⟶ 1 235:
if (!isset($input['global_validation'])) {
$input['global_validation'] =
}
// Set additional default dropdown
$dropdown_fields = array('items_id', 'items_locations', 'users_locations');
foreach ($dropdown_fields as $field ) {
if (!isset($input[$field])) {
Linha 1 133 ⟶ 1 245:
}
}
if (!isset($input['itemtype']) || !($input['items_id'] > 0)) {
$input['itemtype'] = '';
}
$item = NULL;
if (($input["items_id"] > 0) && !empty($input["itemtype"])) {
if ($item = getItemForItemtype($input["itemtype"])) {
if (
if ($item->isField('locations_id')) {
$input['items_locations'] = $item->fields['locations_id'];
}
} else {
$item = NULL;
}
Linha 1 148 ⟶ 1 264:
// Business Rules do not override manual SLA
$manual_slas_id = 0;
if (isset($input['slas_id']) && ($input['slas_id'] > 0)) {
$manual_slas_id = $input['slas_id'];
}
Linha 1 171 ⟶ 1 287:
}
$input = $rules->processAllRules(Toolbox::stripslashes_deep($input),
Toolbox::stripslashes_deep($input),
array('recursive' => true),
array('condition' => RuleTicket::ONADD));
// Recompute default values based on values computed by rules
$input = $this->computeDefaultValuesForAdd($input);
Linha 1 188 ⟶ 1 308:
// Manage auto assign
$auto_assign_mode =
switch ($auto_assign_mode) {
case
break;
case
if ($item != NULL) {
// Auto assign tech from item
if ((!isset($input['_users_id_assign']) || ($input['_users_id_assign'] == 0))
&& $item->isField('users_id_tech')) {
$input['_users_id_assign'] = $item->getField('users_id_tech');
}
// Auto assign group from item
if ((!isset($input['_groups_id_assign']) || ($input['_groups_id_assign'] == 0))
&& $item->isField('groups_id_tech')) {
$input['_groups_id_assign'] = $item->getField('groups_id_tech');
Linha 1 208 ⟶ 1 328:
}
// Auto assign tech/group from Category
if (($input['itilcategories_id'] > 0)
&& ((!isset($input['_users_id_assign']) || !$input['_users_id_assign'])
|| (!isset($input['_groups_id_assign']) || !$input['_groups_id_assign']))) {
Linha 1 225 ⟶ 1 345:
break;
case
// Auto assign tech/group from Category
if (($input['itilcategories_id'] > 0)
&& ((!isset($input['_users_id_assign']) || !$input['_users_id_assign'])
|| (!isset($input['_groups_id_assign']) || !$input['_groups_id_assign']))) {
Linha 1 234 ⟶ 1 354:
$cat->getFromDB($input['itilcategories_id']);
if ((!isset($input['_users_id_assign']) || !$input['_users_id_assign'])
$input['_users_id_assign'] = $cat->getField('users_id');
}
Linha 1 242 ⟶ 1 362:
}
}
if ($item != NULL) {
// Auto assign tech from item
if ((!isset($input['_users_id_assign']) || ($input['_users_id_assign'] == 0))
&& $item->isField('users_id_tech')) {
$input['_users_id_assign'] = $item->getField('users_id_tech');
}
// Auto assign group from item
if ((!isset($input['_groups_id_assign']) || ($input['_groups_id_assign'] == 0))
&& $item->isField('groups_id_tech')) {
$input['_groups_id_assign'] = $item->getField('groups_id_tech');
Linha 1 258 ⟶ 1 378:
// Replay setting auto assign if set in rules engine or by auto_assign_mode
if (((isset($input["_users_id_assign"]) && ($input["_users_id_assign"] > 0))
|| (isset($input["_groups_id_assign"]) && ($input["_groups_id_assign"] > 0))
|| (isset($input["
&& (in_array($input['status'], $this->getNewStatusArray()))) {
$input["status"] =
}
Linha 1 270 ⟶ 1 390:
// Manual SLA defined : reset due date
// No manual SLA and due date defined : reset auto SLA
if (($manual_slas_id == 0)
&& isset($input["due_date"]) && ($input['due_date'] != 'NULL')) {
// Valid due date
if ($input['due_date'] >= $input['date']) {
if (isset($input["slas_id"])) {
unset($input["slas_id"]);
Linha 1 283 ⟶ 1 403:
}
if (isset($input["slas_id"]) && ($input["slas_id"] > 0)) {
// Get datas to initialize SLA and set it
$sla_data = $this->getDatasToAddSLA($input["slas_id"], $input['entities_id'],
Linha 1 296 ⟶ 1 416:
// auto set type if not set
if (!isset($input["type"])) {
$input['type'] =
}
return $input;
}
Linha 1 305 ⟶ 1 424:
function post_addItem() {
global
if (isset($this->input['content'])) {
if (isset($this->input['_stock_image'])) {
$this->addImagePaste();
}
}
// Log this event
$username = 'anonymous';
if (isset($_SESSION["glpiname"])) {
$username = $_SESSION["glpiname"];
}
Event::log($this->fields['id'], "ticket", 4, "tracking",
$this->fields['id']));
if (isset($this->input["_followup"])
&& is_array($this->input["_followup"])
&& (strlen($this->input["_followup"]['content']) > 0)) {
$fup = new TicketFollowup();
$type = "new";
if (isset($this->fields["status"]) && ($this->fields["status"] ==
$type = "solved";
}
Linha 1 324 ⟶ 1 454:
if (isset($this->input["_followup"]['content'])
&& (strlen($this->input["_followup"]['content']) > 0)) {
$toadd["content"] = $this->input["_followup"]['content'];
}
Linha 1 331 ⟶ 1 461:
$toadd["is_private"] = $this->input["_followup"]['is_private'];
}
// $toadd['_no_notif'] = true;
$fup->add($toadd);
Linha 1 337 ⟶ 1 467:
if ((isset($this->input["plan"]) && count($this->input["plan"]))
|| (isset($this->input["actiontime"]) && ($this->input["actiontime"] > 0))) {
$task = new TicketTask();
$type = "new";
if (isset($this->fields["status"]) && ($this->fields["status"] ==
$type = "solved";
}
Linha 1 347 ⟶ 1 477:
"tickets_id" => $this->fields['id'],
"actiontime" => $this->input["actiontime"]);
if (isset($this->input["plan"]) && count($this->input["plan"])) {
$toadd["plan"] = $this->input["plan"];
}
if (isset($_SESSION['glpitask_private'])) {
Linha 1 352 ⟶ 1 486:
}
// $toadd['_no_notif'] = true;
$task->add($toadd);
Linha 1 367 ⟶ 1 498:
// message if ticket's ID doesn't exist
if (!empty($this->input['_link']['tickets_id_2'])) {
if ($ticket_ticket->can(-1,
$ticket_ticket->add($this->input['_link']);
} else {
Session::addMessageAfterRedirect(
}
}
Linha 1 384 ⟶ 1 515:
// Manage SLA Level : add actions
if (isset($this->input["slas_id"]) && ($this->input["slas_id"] > 0)
&& isset($this->input["
$calendars_id =
$sla = new SLA();
Linha 1 395 ⟶ 1 524:
$sla->setTicketCalendar($calendars_id);
// Add first level in working table
if ($this->input["slalevels_id"] > 0) {
$sla->addLevelToDo($this);
}
Linha 1 403 ⟶ 1 532:
}
// Add project task link if needed
if (isset($this->input['_projecttasks_id'])) {
$projecttask = new ProjectTask();
if
$pt = new ProjectTask_Ticket();
$pt->add(array('projecttasks_id' => $this->input['_projecttasks_id'],
/*'_no_notif' => true*/));
}
}
parent::post_addItem();
$this->manageValidationAdd($this->input);
// Processing Email
Linha 1 439 ⟶ 1 553:
$type = "new";
if (isset($this->fields["status"]) && ($this->fields["status"] ==
$type = "solved";
}
Linha 1 446 ⟶ 1 560:
if (isset($_SESSION['glpiis_ids_visible']) && !$_SESSION['glpiis_ids_visible']) {
Session::addMessageAfterRedirect(
__('Your ticket has been registered, its treatment is in
"/front/ticket.form.php?id=".
$this->fields['id']."'>".
$this->fields['id']."</a>")));
}
Linha 1 455 ⟶ 1 572:
/**
* Manage Validation add from input
*
* @since version 0.85
*
* @param $input array : input array
*
* @return nothing
**/
function manageValidationAdd($input) {
//Action for send_validation rule
if (isset($input["_add_validation"])) {
if (isset($input['entities_id'])) {
$entid = $input['entities_id'];
} else if (isset($this->fields['entities_id'])){
$entid = $this->fields['entities_id'];
} else {
return false;
}
$validations_to_send = array();
if (!is_array($input["_add_validation"])) {
$input["_add_validation"] = array($input["_add_validation"]);
}
foreach ($input["_add_validation"] as $key => $validation) {
switch ($validation) {
case 'requester_supervisor' :
if (isset($input['_groups_id_requester'])
&& $input['_groups_id_requester']) {
$users = Group_User::getGroupUsers($input['_groups_id_requester'],
"is_manager='1'");
foreach ($users as $data) {
$validations_to_send[] = $data['id'];
}
}
// Add to already set groups
foreach ($this->getGroups(CommonITILActor::REQUESTER) as $d) {
$users = Group_User::getGroupUsers($d['groups_id'], "is_manager='1'");
foreach ($users as $data) {
$validations_to_send[] = $data['id'];
}
}
break;
case 'assign_supervisor' :
if (isset($input['_groups_id_assign'])
&& $input['_groups_id_assign']) {
$users = Group_User::getGroupUsers($input['_groups_id_assign'],
"is_manager='1'");
foreach ($users as $data) {
$validations_to_send[] = $data['id'];
}
}
foreach ($this->getGroups(CommonITILActor::ASSIGN) as $d) {
$users = Group_User::getGroupUsers($d['groups_id'], "is_manager='1'");
foreach ($users as $data) {
$validations_to_send[] = $data['id'];
}
}
break;
default :
// Group case from rules
if ($key === 'group') {
foreach ($validation as $groups_id) {
$validation_right = 'validate_incident';
if (isset($input['type'])
&& ($input['type'] == Ticket::DEMAND_TYPE)) {
$validation_right = 'validate_request';
}
$opt = array('groups_id' => $groups_id,
'right' => $validation_right,
'entity' => $entid);
$data_users = TicketValidation::getGroupUserHaveRights($opt);
foreach ($data_users as $user) {
$validations_to_send[] = $user['id'];
}
}
} else {
$validations_to_send[] = $validation;
}
}
}
// Validation user added on ticket form
if (isset($input['users_id_validate'])) {
if (array_key_exists('groups_id', $input['users_id_validate'])) {
foreach ($input['users_id_validate'] as $key => $validation_to_add){
if (is_numeric($key)) {
$validations_to_send[] = $validation_to_add;
}
}
} else {
foreach ($input['users_id_validate'] as $key => $validation_to_add) {
if (is_numeric($key)) {
$validations_to_send[] = $validation_to_add;
}
}
}
}
// Keep only one
$validations_to_send = array_unique($validations_to_send);
$validation = new TicketValidation();
if (count($validations_to_send)) {
$values = array();
$values['tickets_id'] = $this->fields['id'];
if ($input['id'] != $this->fields['id']) {
$values['_ticket_add'] = true;
}
// to know update by rules
if (isset($input["_rule_process"])) {
$values['_rule_process'] = $input["_rule_process"];
}
// if auto_import, tranfert it for validation
if (isset($input['_auto_import'])) {
$values['_auto_import'] = $input['_auto_import'];
}
// Cron or rule process of hability to do
if (Session::isCron()
|| isset($input["_auto_import"])
|| isset($input["_rule_process"])
|| $validation->can(-1, CREATE, $values)) { // cron or allowed user
$add_done = false;
foreach ($validations_to_send as $user) {
// Do not auto add twice same validation
if (!TicketValidation::alreadyExists($values['tickets_id'], $user)) {
$values["users_id_validate"] = $user;
if ($validation->add($values)) {
$add_done = true;
}
}
}
if ($add_done) {
Event::log($this->fields['id'], "ticket", 4, "tracking",
sprintf(__('%1$s updates the item %2$s'), $_SESSION["glpiname"],
$this->fields['id']));
}
}
}
}
return true;
}
/**
* Number of followups of the ticket
*
* @param $with_private boolean : true : all followups / false : only public ones (default 1)
*
* @return followup count
Linha 1 472 ⟶ 1 743:
// Set number of followups
$query = "SELECT
FROM `glpi_ticketfollowups`
WHERE `tickets_id` = '".$this->fields["id"]."'
Linha 1 485 ⟶ 1 756:
* Number of tasks of the ticket
*
* @param $with_private boolean : true : all ticket / false : only public ones (default 1)
*
* @return followup count
Linha 1 498 ⟶ 1 769:
// Set number of followups
$query = "SELECT
FROM `glpi_tickettasks`
WHERE `tickets_id` = '".$this->fields["id"]."'
Linha 1 513 ⟶ 1 784:
* @since version 0.83
*
* @param $itemtype string Item type
* @param $items_id integer ID of the Item
* @param $days integer day number
*
* @return integer
Linha 1 549 ⟶ 1 820:
* @since version 0.83
*
* @param $itemtype string Item type
* @param $items_id integer ID of the Item
*
* @return integer
Linha 1 572 ⟶ 1 843:
* @since version 0.83
*
* @param $itemtype string Item type
* @param $items_id integer ID of the Item
* @param $days integer day number
*
* @return integer
**/
function countSolvedTicketsForItemLastDays($itemtype, $items_id, $days) {
return countElementsInTable($this->getTable(),
Linha 1 597 ⟶ 1 868:
* Update date mod of the ticket
*
* @
*
* @param $ID ID of the ticket
* @param $no_stat_computation boolean do not cumpute take into account stat (false by default)
* @param $users_id_lastupdater integer to force last_update id (default 0 = not used)
**/
Linha 1 606 ⟶ 1 879:
if ($this->getFromDB($ID)) {
if (!$no_stat_computation
&& (Session::haveRight(
|| Session::
array(TicketFollowup::ADDALLTICKET,
TicketFollowup::ADDMYTICKET,
TicketFollowup::ADDGROUPTICKET))
|| $this->isUser(CommonITILActor::ASSIGN, Session::getLoginUserID())
|| (isset($_SESSION["glpigroups"])
&& $this->haveAGroup(
if ($this->fields['takeintoaccount_delay_stat'] == 0) {
Linha 1 622 ⟶ 1 898:
parent::updateDateMod($ID, $no_stat_computation, $users_id_lastupdater);
}
}
Linha 1 713 ⟶ 1 912:
function canAddItem($type) {
if (($type == 'Document')
&& ($this->getField('status') == return false;
}
Linha 1 727 ⟶ 1 927:
function canAddFollowups() {
return ((Session::haveRight("
&& ($this->isUser(
|| ($this->fields["users_id_recipient"] === Session::getLoginUserID())))
|| Session::haveRight(
|| (Session::haveRight(
&& isset($_SESSION["glpigroups"])
&& $this->haveAGroup(
||
|| (isset($_SESSION["glpigroups"])
&& $this->haveAGroup(
}
Linha 1 745 ⟶ 1 945:
static function getDefaultSearchRequest() {
$search = array('
'searchtype'
'
'sort'
'order'
if (Session::haveRight(
$search['
}
return $search;
Linha 1 758 ⟶ 1 958:
/**
* @see CommonDBTM::getSpecificMassiveActions()
**/
function getSpecificMassiveActions($checkitem=NULL) {
$
$actions = parent::getSpecificMassiveActions($checkitem);
if ($
if (TicketFollowup::canCreate()) {
$actions['TicketFollowup'.MassiveAction::CLASS_ACTION_SEPARATOR.'add_followup']
if (TicketTask::canCreate()) {
$actions[__CLASS__.MassiveAction::CLASS_ACTION_SEPARATOR.'add_task'] = __('Add a new task');
}
if (TicketValidation::canCreate()) {
$actions['TicketValidation'.MassiveAction::CLASS_ACTION_SEPARATOR.'submit_validation']
}
if (Session::haveRight(self::$rightname, UPDATE)) {
$actions[__CLASS__.MassiveAction::CLASS_ACTION_SEPARATOR.'add_actor']
= __('Add an actor');
$actions['Ticket_Ticket'.MassiveAction::CLASS_ACTION_SEPARATOR.'add']
= _x('button', 'Link tickets');
}
if (Session::haveRight(self::$rightname, UPDATE)) {
MassiveAction::getAddTransferList($actions);
}
return $actions;
}
function getSearchOptions() {
$tab
$tab
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[13]['comments'] = true;
$tab[13]['nosort'] = true;
$tab[13]['massiveaction'] = false;
$tab[13]['additionalfields'] = array('itemtype');
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[131]['massiveaction'] = false;
$tab[
$tab[
$tab[
$tab[
// Can't use Location::getSearchOptionsToAdd because id conflicts
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
// For ticket template
$tab[
$tab[
$tab[
$tab[142]['forcegroupby'] = true;
$tab[142]['usehaving'] = true;
$tab[
$tab[
$tab[
$tab[
$tab[
'beforejoin' => array('table'
=> 'glpi_documents_items',
'joinparams'
=> 'itemtype_item')));
$tab += $this->getSearchOptionsActors();
$tab
$tab[
$tab[
$tab[
$tab[
$tab[30]['datatype'] = 'dropdown';
$tab[32]['table'] = 'glpi_slalevels';
$tab[32]['field'] = 'name';
$tab[32]['name'] = __('Escalation level');
$tab[32]['massiveaction'] = false;
$tab[32]['datatype'] = 'dropdown';
$tab += TicketValidation::getSearchOptionsToAdd();
$tab
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[31]['datatype'] = 'specific';
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab['followup'] = _n('Followup', 'Followups', 2);
$followup_condition = '';
if (!Session::haveRight('
$followup_condition = "AND (`NEWTABLE`.`is_private` = '0'
OR `NEWTABLE`.`users_id` = '".Session::getLoginUserID()."')";
}
$tab[25]['table'] = 'glpi_ticketfollowups';
$tab[25]['field'] = 'content';
$tab[25]['name']
$tab[25]['forcegroupby'] = true;
$tab[25]['splititems'] = true;
$tab[25]['massiveaction'] = false;
$tab[25]['joinparams'] = array('jointype' => 'child',
'condition' => $followup_condition);
$tab[25]['datatype'] = 'text';
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
'condition' => $followup_condition);
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
'joinparams'
=> array('jointype' => 'child', $tab[91]['table'] = 'glpi_ticketfollowups';
$tab[91]['field'] = 'is_private';
$tab[91]['name'] = __('Private followup');
$tab[91]['datatype'] = 'bool';
$tab[91]['forcegroupby'] = true;
$tab[91]['splititems'] = true;
$tab[91]['massiveaction'] = false;
$tab[91]['joinparams'] = array('jointype' => 'child',
'condition' => $followup_condition);
$tab[93]['table'] = 'glpi_users';
$tab[93]['field'] = 'name';
$tab[93]['name'] = __('Writer');
$tab[93]['datatype'] = 'itemlink';
$tab[93]['right'] = 'all';
$tab[93]['forcegroupby'] = true;
$tab[93]['massiveaction'] = false;
$tab[93]['joinparams'] = array('beforejoin'
=> array('table'
=> 'glpi_ticketfollowups',
'joinparams'
=> array('jointype' => 'child',
'condition' => $followup_condition)));
$tab += $this->getSearchOptionsStats();
$tab[150]['field'] = 'takeintoaccount_delay_stat';
$tab[150]['name'] = __('Take into account time');
$tab[150]['datatype'] = 'timestamp';
$tab[150]['forcegroupby'] = true;
$tab[150]['massiveaction'] = false;
if (Session::haveRightsOr(self::$rightname,
array(self::READALL, self::READASSIGN, self::OWN))) {
$tab
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[40]['additionalfields'] = array('tickets_id_2');
$tab[47]['table'] = 'glpi_tickets_tickets';
$tab[47]['field'] = 'tickets_id_1';
$tab[47]['name'] = __('Duplicated tickets');
$tab[47]['massiveaction'] = false;
$tab[47]['searchtype'] = 'equals';
$tab[47]['joinparams'] = array('jointype' => 'item_item',
'condition' => "AND NEWTABLE.`link` = ".
Ticket_Ticket::DUPLICATE_WITH);
$tab[47]['datatype'] = 'dropdown';
$tab[47]['forcegroupby'] = true;
$tab[41]['
$tab[41]['field'] = 'id';
$tab[41]['name'] = __('Number of all linked tickets');
$tab[41]['massiveaction'] = false;
$tab[41]['datatype'] = 'count';
$tab[41]['usehaving'] = true;
$tab[41]['joinparams'] = array('jointype' => 'item_item');
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
'condition' => "AND NEWTABLE.`link` = ".
Ticket_Ticket::DUPLICATE_WITH);
$tab
$tab
if (Session::haveRight('ticketcost', READ)) {
}
$tab
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
$tab[
}
// Filter search fields for helpdesk
if (!Session::
&& (!isset($_SESSION['glpiactiveprofile']['interface']
|| ($_SESSION['glpiactiveprofile']['interface'] == 'helpdesk'))) {
$tokeep = array('common', 'requester');
if (Session::haveRightsOr('ticketvalidation',
array_merge(TicketValidation::getValidateRights(),
TicketValidation::getCreateRights()))) {
$tokeep[] = 'validation';
}
$keep = false;
foreach ($tab as $key => $val) {
if (!is_array($val)) {
$keep = in_array($key, $tokeep);
Linha 2 340 ⟶ 2 299:
}
/**
* @since version 0.84
*
* @param $field
* @param $values
* @param $options array
**/
static function getSpecificValueToDisplay($field, $values, array $options=array()) {
if (!is_array($values)) {
Linha 2 346 ⟶ 2 313:
}
switch ($field) {
case '
$content = Html::clean($content);
return nl2br($content);
case 'type':
return self::getTicketTypeName($values[$field]);
case 'items_id':
Linha 2 368 ⟶ 2 329:
$tmp = Dropdown::getDropdownName(getTableForItemtype($values['itemtype']),
$values[$field], 1);
return sprintf(__('%1$s %2$s'), $tmp['name']
Html::showToolTip($tmp['comment'], array('display' => false)));
}
Linha 2 377 ⟶ 2 338:
break;
}
return parent::getSpecificValueToDisplay($field, $values
}
/**
* @since version 0.84
*
* @param $field
* @param $name (default '')
* @param $values (default '')
* @param $options array
*
* @return string
**/
static function getSpecificValueToSelect($field, $name='', $values='', array $options=array()) {
if (!is_array($values)) {
$values = array($field => $values);
}
$options['display'] = false;
switch ($field) {
case 'content' :
return "<textarea cols='90' rows='6' name='$name'>".$values['content']."</textarea>";
case 'items_id' :
if (isset($values['itemtype']) && !empty($values['itemtype'])) {
$options['name'] = $name;
$options['value'] = $values[$field];
return Dropdown::show($values['itemtype'], $options);
}
break;
case 'type':
$options['value'] = $values[$field];
return self::dropdownType($name, $options);
}
return parent::getSpecificValueToSelect($field, $name, $values, $options);
}
Linha 2 384 ⟶ 2 381:
* Dropdown of ticket type
*
* @param $name select name
* @param $options array of options:
* - value : integer / preselected value (default 0)
* - toadd : array / array of specific values to add at the begining
* - on_change : string / value to transmit to "onChange"
* - display : boolean / display or get string (default true)
*
* @return string id of the select
**/
static function dropdownType($name, $options=array()) {
$params['value'] = 0;
$params['toadd'] = array();
$params['on_change'] = '';
$params['display'] = true;
if (is_array($options) && count($options)) {
Linha 2 408 ⟶ 2 404:
$items = array();
if (count($params['toadd']) > 0) {
$items = $params['toadd'];
}
Linha 2 424 ⟶ 2 420:
**/
static function getTypes() {
$options[self::INCIDENT_TYPE] =
$options[self::DEMAND_TYPE] =
return $options;
Linha 2 439 ⟶ 2 434:
**/
static function getTicketTypeName($value) {
switch ($value) {
case self::INCIDENT_TYPE :
return
case self::DEMAND_TYPE :
return
default :
// Return $value if not defined
return $value;
}
}
/**
* get the Ticket status list
*
* @param $withmetaforsearch boolean (false by default)
*
* @return an array
**/
static function getAllStatusArray($withmetaforsearch=false) {
// To be overridden by class
$tab = array(
if ($withmetaforsearch) {
$tab['notold'] =
$tab['notclosed'] =
$tab['process'] =
$tab['old'] =
$tab['all'] =
}
return $tab;
Linha 2 485 ⟶ 2 483:
*
* @return an array
**/
static function getClosedStatusArray() {
return array(
}
Linha 2 500 ⟶ 2 497:
**/
static function getSolvedStatusArray() {
return array(
}
Linha 2 511 ⟶ 2 508:
**/
static function getNewStatusArray() {
return array(
}
Linha 2 522 ⟶ 2 519:
**/
static function getProcessStatusArray() {
return array(
}
Linha 2 610 ⟶ 2 526:
* Make a select box for Ticket my devices
*
* @param $userID User ID for my device section (default 0)
* @param $
* @param $
* @param $
*
* @return nothing (print out an HTML select box)
**/
static function dropdownMyDevices($userID=0, $entity_restrict=-1, $itemtype=0, $items_id=0) {
global $DB
if ($userID == 0) {
Linha 2 628 ⟶ 2 543:
$already_add = array();
if ($_SESSION["glpiactiveprofile"]["helpdesk_hardware"]&pow(2, self::HELPDESK_MY_HARDWARE)) {
$my_devices =
$my_item = $itemtype.'_'.$items_id;
$devices = array();
// My items
Linha 2 637 ⟶ 2 553:
&& parent::isPossibleToAssignType($itemtype)) {
$itemtable = getTableForItemType($itemtype);
$query = "SELECT
WHERE `users_id` = '$userID'";
if ($item->maybeDeleted()) {
$query .= " AND `$itemtable`.`is_deleted` = '0' ";
}
if ($item->maybeTemplate()) {
$query .= " AND `$itemtable`.`is_template` = '0' ";
}
if (in_array($itemtype, $CFG_GLPI["helpdesk_visible_types"])) {
$query .= " AND `is_helpdesk_visible` = '1' ";
}
Linha 2 654 ⟶ 2 571:
ORDER BY `name` ";
$result = $DB->query($query);
$nb = $DB->numrows($result);
if ($DB->numrows($result) > 0) {
$type_name = $item->getTypeName($nb);
while ($data = $DB->
$output = $data["name"];
if (empty($output) || $_SESSION["glpiis_ids_visible"]) {
$output
}
$output = sprintf(__('%1$
if ($itemtype != 'Software') {
if (!empty($data['serial'])) {
$output
}
if (!empty($data['otherserial'])) {
$output
}
}
$
$already_add[$itemtype][] = $data["id"];
Linha 2 683 ⟶ 2 597:
}
}
if (
$my_devices
}
// My group items
if (Session::haveRight("show_group_hardware","1")) {
$group_where = "";
$query = "SELECT `glpi_groups_users`.`groups_id`, `glpi_groups`.`name`
FROM `glpi_groups_users`
LEFT JOIN `glpi_groups`
ON (`glpi_groups`.`id` = `glpi_groups_users`.`groups_id`)
WHERE `glpi_groups_users`.`users_id` = '$userID' ".
getEntitiesRestrictRequest("AND", "glpi_groups", "",
$entity_restrict, true);
$result = $DB->query($query);
$first = true;
while ($data = $DB->fetch_assoc($result)) {
if ($first) {
$first = false;
Linha 2 706 ⟶ 2 621:
$group_where .= " OR ";
}
$a_groups = getAncestorsOf("glpi_groups", $data["groups_id"]);
$a_groups[$data["groups_id"]] = $data["groups_id"];
$group_where .= " `groups_id` IN (".implode(',', $a_groups).") ";
}
foreach ($CFG_GLPI["linkgroup_types"] as $itemtype) {
if (($item = getItemForItemtype($itemtype))
&& parent::isPossibleToAssignType($itemtype)) {
$itemtable = getTableForItemType($itemtype);
$query = "SELECT *
FROM `$itemtable`
WHERE ($group_where) ".
getEntitiesRestrictRequest("AND", $itemtable, "",
$entity_restrict,
$item->maybeRecursive());
if ($item->maybeDeleted()) {
Linha 2 729 ⟶ 2 643:
$query .= " AND `is_template` = '0' ";
}
$query .= ' ORDER BY `name`';
$result = $DB->query($query);
if ($DB->numrows($result) > 0) {
$type_name = $item->getTypeName();
if (!isset($already_add[$itemtype])) {
$already_add[$itemtype] = array();
}
while ($data = $DB->
if (!in_array($data["id"], $already_add[$itemtype])) {
$output = '';
if (isset($data["name"])) {
Linha 2 743 ⟶ 2 658:
}
if (empty($output) || $_SESSION["glpiis_ids_visible"]) {
$output
}
$output = sprintf(__('%1$
if (isset($data['serial'])) {
$output
}
if (isset($data['otherserial'])) {
$output
}
$
$already_add[$itemtype][] = $data["id"];
Linha 2 765 ⟶ 2 675:
}
}
if (
$my_devices[__('Devices
}
}
Linha 2 774 ⟶ 2 683:
if (isset($already_add['Computer']) && count($already_add['Computer'])) {
$search_computer = " XXXX IN (".implode(',',$already_add['Computer']).') ';
$
// Direct Connection
$types = array('
foreach ($types as $itemtype) {
if (in_array($itemtype,$_SESSION["glpiactiveprofile"]["helpdesk_item_type"])
Linha 2 793 ⟶ 2 702:
$search_computer);
if ($item->maybeDeleted()) {
$query .= " AND `$itemtable`.`is_deleted` = '0' ";
}
if ($item->maybeTemplate()) {
$query .= " AND `$itemtable`.`is_template` = '0' ";
}
$query .= getEntitiesRestrictRequest("AND",$itemtable,"",$entity_restrict)."
Linha 2 804 ⟶ 2 713:
if ($DB->numrows($result) > 0) {
$type_name = $item->getTypeName();
while ($data = $DB->
if (!in_array($data["id"],$already_add[$itemtype])) {
$output = $data["name"];
if (empty($output) || $_SESSION["glpiis_ids_visible"]) {
$output
}
$output = sprintf(__('%1$
if ($itemtype != 'Software') {
$output
}
$
$already_add[$itemtype][] = $data["id"];
Linha 2 827 ⟶ 2 731:
}
}
if (
$my_devices
}
// Software
if (in_array('Software', $_SESSION["glpiactiveprofile"]["helpdesk_item_type"])) {
$query = "SELECT DISTINCT `glpi_softwareversions`.`name` AS version,
`glpi_softwares`.`name` AS name, `glpi_softwares`.`id`
Linha 2 847 ⟶ 2 751:
$entity_restrict)."
ORDER BY `glpi_softwares`.`name`";
$devices = array();
$result = $DB->query($query);
if ($DB->numrows($result) > 0) {
$tmp_device = "";
$item = new Software();
$type_name = $item->getTypeName();
if (!isset($already_add['Software'])) {
$already_add['Software'] = array();
}
while ($data = $DB->
if (!in_array($data["id"], $already_add['Software'])) {
$output =
$output =
sprintf(__('%1$s: %2$s'), __('version'),
$output = sprintf(__('%1$s
$devices["Software_".$data["id"]] =
$already_add['Software'][] = $data["id"];
}
}
if (
$my_devices
}
}
Linha 2 878 ⟶ 2 781:
}
echo "<div id='tracking_my_devices'>";
echo "<
Linha 2 886 ⟶ 2 788:
$params = array('my_items' => '__VALUE__');
Ajax::updateItemOnSelectEvent("
$CFG_GLPI["root_doc"]."/ajax/ticketiteminformation.php",
$params);
Linha 2 897 ⟶ 2 799:
* Make a select box for Tracking All Devices
*
* @param $myname select name
* @param $itemtype preselected value.for item type
* @param $items_id preselected value for item ID (default 0)
* @param $admin is an admin access ? (default 0)
* @param $users_id user ID used to display my devices (default 0
* @param $entity_restrict Restrict to a defined entity (default -1)
*
* @return nothing (print out an HTML select box)
**/
static function dropdownAllDevices($myname, $itemtype, $items_id=0, $admin=0, $users_id=0,
$entity_restrict=-1) {
global
$rand = mt_rand();
if ($_SESSION["glpiactiveprofile"]["helpdesk_hardware"] == 0) {
echo "<input type='hidden' name='$myname' value='
echo "<input type='hidden' name='items_id' value='0'>";
} else {
echo "<div id='tracking_all_devices$rand'>";
if ($_SESSION["glpiactiveprofile"]["helpdesk_hardware"]&pow(2,
self::HELPDESK_ALL_HARDWARE)) {
if ($users_id
&&($_SESSION["glpiactiveprofile"]["helpdesk_hardware"]&pow(2,
self::HELPDESK_MY_HARDWARE))) {
echo __('Or complete search')." ";
}
$types = parent::getAllTypesForHelpdesk();
$
array('
$params = array('itemtype' => '__VALUE__',
'entity_restrict' => $entity_restrict,
'admin' => $admin,
'myname' => "items_id",);
Ajax::updateItemOnSelectEvent("
$CFG_GLPI["root_doc"].
"/ajax/dropdownTrackingDeviceType.php", $params);
echo "<span id='results_$myname$rand'>\n";
Linha 2 953 ⟶ 2 852:
&& $itemtype) {
if (($item = getItemForItemtype($itemtype))
if ($item->getFromDB($items_id)) {
}
} else {
$params['itemtype'] = $itemtype;
echo "<script type='text/javascript' >\n";
Ajax::updateItemJsCode("results_$myname$rand
$
"/ajax/dropdownTrackingDeviceType.php",
$params);
echo '</script>';
}
Linha 2 972 ⟶ 2 872:
}
return $rand;
}
Linha 3 046 ⟶ 2 887:
$totalcost = 0;
$query = "SELECT `
FROM `glpi_tickets`, `glpi_ticketcosts`
WHERE `
AND `
AND
AND
OR `
OR `glpi_ticketcosts`.`cost_material` > '0')";
$result = $DB->query($query);
$i = 0;
if ($DB->numrows($result)) {
while ($data = $DB->
$totalcost +=
$data["cost_fixed"], $data["cost_material"]);
}
}
return $totalcost;
}
Linha 3 087 ⟶ 2 911:
* Print the helpdesk form
*
* @param $ID
* @param $ticket_template
* (false by default)
*
* @return nothing (print the helpdesk)
**/
global $DB, $CFG_GLPI
if (!
return false;
}
if (!$ticket_template
&& Session::haveRightsOr('ticketvalidation', TicketValidation::getValidateRights())) {
$opt = array();
$opt['reset'] = 'reset';
$opt['
$opt['
$opt['
$opt['
$opt['
$opt['
$opt['
$opt['
$url_validate = $CFG_GLPI["root_doc"]."/front/ticket.php?".Toolbox::append_params($opt,
'&');
if (TicketValidation::
echo "<a href='$url_validate' title=\"".
alt=\"".
__('Tickets awaiting approval')."</a><br><br>";
}
}
Linha 3 131 ⟶ 2 959:
// Set default values...
$default_values = array('_users_id_requester_notif'
'
'_users_id_observer' => 0,
'
'
'itemtype' => '',
'
// Get default values from posted values on reload form
if (!$ticket_template) {
if (isset($
$values = Html::cleanPostForTextArea($_POST);
}
}
// Restore saved value or override with page parameter
$saved = $this->restoreInput();
foreach ($default_values as $name => $value) {
if (!isset($
if (isset($
$
} else {
$
}
}
}
if (!$ticket_template) {
Linha 3 191 ⟶ 3 010:
$delegating = User::getDelegateGroupsForUser($
if (count($delegating)) {
echo "<div class='center'><table class='tab_cadre_fixe'>";
echo "<tr><th colspan='2'>".
$rand = Dropdown::showYesNo("nodelegate", $
$params = array
Ajax::UpdateItemOnSelectEvent("dropdown_nodelegate".$rand, "show_result".$rand,
$CFG_GLPI["root_doc"]."/ajax/dropdownDelegationUsers.php",
$params);
if ($CFG_GLPI['use_check_pref'] && $values['nodelegate']) {
echo "</th><th>".__('Check your personnal information');
}
echo "</th></tr>";
Linha 3 220 ⟶ 3 043:
$self = new self();
if ($
$
} else {
$
}
$self->showActorAddFormOnCreate(
echo "</div>";
if ($CFG_GLPI['use_check_pref'] && $values['nodelegate']) {
echo "</td><td class='center'>";
User::showPersonalInformation(Session::getLoginUserID());
}
echo "</td></tr>";
echo "</table></div>";
echo "<input type='hidden' name='_users_id_recipient' value='".Session::getLoginUserID()."'>";
} else {
// User as requester
$values['_users_id_requester'] = Session::getLoginUserID();
if ($CFG_GLPI['use_check_pref']) {
echo "<div class='center'><table class='tab_cadre_fixe'>";
echo "<tr><th>".__('Check your personnal information')."</th></tr>";
echo "<tr class='tab_bg_1'><td class='center'>";
User::showPersonalInformation(Session::getLoginUserID());
echo "</td></tr>";
echo "</table></div>";
}
}
Linha 3 239 ⟶ 3 079:
// Load ticket template if available :
$tt = $this->getTicketTemplateToUse($ticket_template, $values['type'],
$values['itilcategories_id'],
$_SESSION["glpiactive_entity"]);
// Predefined fields from template : reset them
if (isset($
$
=
} else {
$
}
Linha 3 285 ⟶ 3 096:
if (isset($tt->predefined) && count($tt->predefined)) {
foreach ($tt->predefined as $predeffield => $predefvalue) {
if (isset($
// Is always default value : not set
// Set if already predefined field
// Set if ticket template change
if (((count($
||
||
$values[$predeffield] = $predefvalue;
$predefined_fields[$predeffield] = $predefvalue;
}
Linha 3 301 ⟶ 3 113:
}
}
// All predefined override : add option to say predifined exists
if (count($predefined_fields) == 0) {
$predefined_fields['_all_predefined_override'] = 1;
}
} else { // No template load : reset predefined values
if (count($
foreach ($
if ($
$
}
}
}
}
if (($CFG_GLPI['urgency_mask'] == (1<<3))
|| $tt->isHiddenField('urgency')) { // Dont show dropdown if only 1 value enabled or field is hidden
echo "<input type='hidden' name='urgency' value='".$
}
// Display predefined fields if hidden
if ($tt->isHiddenField('itemtype')) {
echo "<input type='hidden' name='itemtype' value='".$
echo "<input type='hidden' name='items_id' value='".$
}
if ($tt->isHiddenField('locations_id')) {
echo "<input type='hidden' name='locations_id' value='".$values['locations_id']."'>";
}
echo "<input type='hidden' name='entities_id' value='".$_SESSION["glpiactive_entity"]."'>";
echo "<div class='center'><table class='tab_cadre_fixe'>";
echo "<tr><th
if (Session::isMultiEntitiesMode()) {
echo "
}
echo "</th></tr>";
echo "<tr class='tab_bg_1'>";
echo "<td>".sprintf(__('%1$
echo "<td>";
self::dropdownType('type', array('value' => $
'on_change' => 'this.form.submit()'));
echo "</td></tr>";
echo "<tr class='tab_bg_1'>";
echo "<td>".sprintf(__('%1$
echo "
$condition = "`is_helpdeskvisible`='1'";
switch ($values['type']) {
case self::DEMAND_TYPE :
$condition .= " AND `is_request`='1'";
Linha 3 369 ⟶ 3 171:
$condition .= " AND `is_incident`='1'";
}
$opt = array('value' => $values['itilcategories_id'],
'condition' => $condition,
'on_change' => 'this.form.submit()');
if ($values['itilcategories_id'] && $tt->isMandatoryField("itilcategories_id")) {
$opt['display_emptychoice'] = false;
}
echo "</td></tr>";
if ($CFG_GLPI['urgency_mask'] != (1<<3)) {
if (!$tt->isHiddenField('urgency')) {
echo "<tr class='tab_bg_1'>";
echo "<td>".sprintf(__('%1$
"</td>";
echo "<td>";
self::dropdownUrgency(
echo "</td></tr>";
}
}
if (empty($delegating)
&& NotificationTargetTicket::isAuthorMailingActivatedForHelpdesk()) {
echo "<tr class='tab_bg_1'>";
echo "<td>".
echo "<td>";
if ($
$
}
$
$
$
include (GLPI_ROOT."/ajax/uemailUpdate.php");
echo "</td></tr>";
}
if (($_SESSION["glpiactiveprofile"]["helpdesk_hardware"] != 0)
&& (count($_SESSION["glpiactiveprofile"]["helpdesk_item_type"]))) {
if (!$tt->isHiddenField('itemtype')) {
echo "<tr class='tab_bg_1'>";
echo "<td>".sprintf(__('%1$
$tt->getMandatoryMark('itemtype'))."</td>";
echo "<td>";
self::dropdownMyDevices($
$
self::dropdownAllDevices("itemtype", $
$ $_SESSION["glpiactive_entity"]);
echo "<span id='item_ticket_selection_information'></span>";
Linha 3 445 ⟶ 3 227:
}
if (!$tt->isHiddenField('locations_id')) {
echo "<tr class='tab_bg_1'><td>";
printf(__('%1$s%2$s'), __('Location'), $tt->getMandatoryMark('locations_id'));
echo "</td><td>";
Location::dropdown(array('value' => $values["locations_id"]));
echo "</td></tr>";
}
if (!$tt->isHiddenField('_users_id_observer')
|| $tt->isPredefinedField('_users_id_observer')) {
echo "<tr class='tab_bg_1'><td>".__('Watcher')."</td>";
echo "<td>";
$values['_right'] = "groups";
// Observer
if (!$tt->isHiddenField('_users_id_observer')) {
$this->showActorAddFormOnCreate(CommonITILActor::OBSERVER, $values);
echo '<hr>';
} else { // predefined value
if (isset($values["_users_id_observer"]) && $values["_users_id_observer"]) {
echo self::getActorIcon('user', CommonITILActor::OBSERVER)." ";
echo Dropdown::getDropdownName("glpi_users", $values["_users_id_observer"]);
echo "<input type='hidden' name='_users_id_observer' value=\"".
$values["_users_id_observer"]."\">";
echo '<hr>';
}
}
echo "</td></tr>";
}
if (!$tt->isHiddenField('name')
|| $tt->isPredefinedField('name')) {
echo "<tr class='tab_bg_1'>";
echo "<td>".
echo "<td><input type='text' maxlength='250' size='80' name='
}
if (!$tt->isHiddenField('content')
|| $tt->isPredefinedField('content')) {
echo "<tr class='tab_bg_1'>";
echo "<td>".
"</td><td>";
$rand = mt_rand();
$rand_text = mt_rand();
$cols = 90;
$rows = 6;
$content_id = "content$rand";
if ($CFG_GLPI["use_rich_text"]) {
$values["content"] = $this->setRichTextContent($content_id, $values["content"], $rand);
$cols = 100;
$rows = 10;
} else {
$values["content"] = $this->setSimpleTextContent($values["content"]);
}
echo "<div id='content$rand_text'>";
echo "<textarea id='$content_id' name='content' cols='$cols' rows='$rows'>".
$values['content']."</textarea></div>";
echo "</td></tr>";
}
// File upload system
$width = '100%';
if ($CFG_GLPI['use_rich_text']) {
$width = '50%';
}
echo "<tr class='tab_bg_1'>";
echo "<td class='top'>".sprintf(__('%1$s (%2$s)'), __('File'), Document::getMaxUploadSize());
DocumentType::showAvailableTypesLink();
echo "</td>";
echo "<td class='top'>";
echo "<div id='fileupload_info'></div>";
echo "</td>";
echo "</tr>";
echo "<tr class='tab_bg_1'>";
echo "<td colspan='4'>";
echo "<table width='100%'><tr>";
echo "<td width='$width '>";
echo Html::file(array('multiple' => true,
'values' => array('filename' => $values['_filename'],
'tag' => $values['_tag_filename'])
));
// "<div id='uploadfiles'><input type='file' name='filename[]' value='' size='60'></div>";
echo "</td>";
if ($CFG_GLPI['use_rich_text']) {
echo "<td width='$width '>";
if (!isset($rand)) {
$rand = mt_rand();
}
echo Html::imagePaste(array('rand' => $rand));
echo "</td>";
}
echo "</tr></table>";
echo "</td>";
echo "</tr>";
if (!$ticket_template) {
echo "<tr class='tab_bg_1'>";
echo "<td colspan='2' class='center'>";
if ($tt->isField('id') && ($tt->fields['id'] > 0)) {
echo "<input type='hidden' name='_tickettemplates_id' value='".$tt->fields['id']."'>";
echo "<input type='hidden' name='_predefined_fields'
}
echo "<input type='submit' name='add' value=\"".__s('Submit message')."\" class='submit'>";
echo "</td></tr>";
}
echo "</table></div>";
Linha 3 858 ⟶ 3 353:
* @since version 0.83
*
* @param $entity integer entities_id usefull is function called by cron (default 0)
**/
static function getDefaultValues($entity=0) {
Linha 3 866 ⟶ 3 361:
$users_id_requester = Session::getLoginUserID();
// No default requester if own ticket right = tech and update_ticket right to update requester
if (Session::
$users_id_requester = 0;
}
Linha 3 876 ⟶ 3 371:
}
$type =
// Set default values...
Linha 3 884 ⟶ 3 379:
'_groups_id_requester' => 0,
'_users_id_assign' => 0,
'_users_id_assign_notif' => array('use_notification' => 1,
'alternative_email' => ''),
'_groups_id_assign' => 0,
'_users_id_observer' => 0,
'_users_id_observer_notif' => array('use_notification' => 1,
'alternative_email' => ''),
'_groups_id_observer' => 0,
'_link' => array('tickets_id_2' => '',
'link' => ''),
'
'_suppliers_id_assign_notif' => array('use_notification' => 1,
'alternative_email' => ''),
'name' => '',
'content' => '',
Linha 3 904 ⟶ 3 401:
'date' => $_SESSION["glpi_currenttime"],
'entities_id' => $entity,
'status' =>
'followup' => array(),
'itemtype' => '',
'items_id' => 0,
'locations_id' => 0,
'plan' => array(),
'global_validation' =>
'due_date' => 'NULL',
'slas_id' => 0,
'_add_validation' => 0,
'type' => $type
'_documents_id' => array(),
'_filename' => array(),
'_tag_filename' => array());
}
/**
* Get ticket template to use
* Use force_template first, then try on template define for type and category
* then use default template of active profile of connected user and then use default entity one
*
* @param $force_template integer tickettemplate_id to used (case of preview for example)
* (default 0)
* @param $type integer type of the ticket (default 0)
* @param $itilcategories_id integer ticket category (default 0)
* @param $entities_id integer (default -1)
*
* @since version 0.84
*
* @return ticket template object
**/
function getTicketTemplateToUse($force_template=0, $type=0, $itilcategories_id=0,
$entities_id=-1) {
// Load ticket template if available :
$tt = new TicketTemplate();
$template_loaded = false;
if ($force_template) {
// with type and categ
if ($tt->getFromDBWithDatas($force_template, true)) {
$template_loaded = true;
}
}
if (!$template_loaded
&& $type
&& $itilcategories_id) {
$categ = new ITILCategory();
if ($categ->getFromDB($itilcategories_id)) {
$field = '';
switch ($type) {
case self::INCIDENT_TYPE :
$field = 'tickettemplates_id_incident';
break;
case self::DEMAND_TYPE :
$field = 'tickettemplates_id_demand';
break;
}
if (!empty($field) && $categ->fields[$field]) {
// without type and categ
if ($tt->getFromDBWithDatas($categ->fields[$field], false)) {
$template_loaded = true;
}
}
}
}
// If template loaded from type and category do not check after
if ($template_loaded) {
return $tt;
}
if (!$template_loaded) {
// load default profile one if not already loaded
if (isset($_SESSION['glpiactiveprofile']['tickettemplates_id'])
&& $_SESSION['glpiactiveprofile']['tickettemplates_id']) {
// with type and categ
if ($tt->getFromDBWithDatas($_SESSION['glpiactiveprofile']['tickettemplates_id'],
true)) {
$template_loaded = true;
}
}
}
if (!$template_loaded
&& ($entities_id >= 0)) {
// load default entity one if not already loaded
if ($template_id = Entity::getUsedConfig('tickettemplates_id', $entities_id)) {
// with type and categ
if ($tt->getFromDBWithDatas($template_id, true)) {
$template_loaded = true;
}
}
}
// Check if profile / entity set type and category and try to load template for these values
if ($template_loaded) { // template loaded for profile or entity
$newtype = $type;
$newitilcategories_id = $itilcategories_id;
// Get predefined values for ticket template
if (isset($tt->predefined['itilcategories_id']) && $tt->predefined['itilcategories_id']) {
$newitilcategories_id = $tt->predefined['itilcategories_id'];
}
if (isset($tt->predefined['type']) && $tt->predefined['type']) {
$newtype = $tt->predefined['type'];
}
if ($newtype
&& $newitilcategories_id) {
$categ = new ITILCategory();
if ($categ->getFromDB($newitilcategories_id)) {
$field = '';
switch ($newtype) {
case self::INCIDENT_TYPE :
$field = 'tickettemplates_id_incident';
break;
case self::DEMAND_TYPE :
$field = 'tickettemplates_id_demand';
break;
}
if (!empty($field) && $categ->fields[$field]) {
// without type and categ
if ($tt->getFromDBWithDatas($categ->fields[$field], false)) {
$template_loaded = true;
}
}
}
}
}
return $tt;
}
function showForm($ID, $options=array()) {
global $DB, $CFG_GLPI
$default_values = self::getDefaultValues();
// Get default values from posted values on reload form
// On get because of tabs
if (!isset($options['template_preview'])) {
if (isset($
$values = Html::cleanPostForTextArea($_GET);
}
}
// Restore saved value or override with page parameter
$saved = $this->restoreInput();
foreach ($default_values as $name => $value) {
if (!isset($values[$name])) {
if (isset($
$values[$name] = $
} else {
$values[$name] = $value;
Linha 3 937 ⟶ 3 567:
}
}
if (isset($
// Clean new lines to be fix encoding
$order = array('\\r', '\\n', "\\");
$replace = array("", "", "");
$values['content'] = str_replace($order,$replace,$values['content']);
}
if (!$ID) {
// Override defaut values from projecttask if needed
if (isset($options['projecttasks_id'])) {
$pt = new ProjectTask();
if ($pt->getFromDB($options['projecttasks_id'])) {
$values['name'] = $pt->getField('name');
$values['content'] = $pt->getField('name');
}
}
}
// Check category / type validity
if ($values['itilcategories_id']) {
$cat = new ITILCategory();
if ($cat->getFromDB($values['itilcategories_id'])) {
switch ($values['type']) {
case self::INCIDENT_TYPE :
if (!$cat->getField('is_incident')) {
$values['itilcategories_id'] = 0;
}
break;
case self::DEMAND_TYPE :
if (!$cat->getField('is_request')) {
$values['itilcategories_id'] = 0;
}
break;
default :
break;
}
}
}
// Default check
if ($ID > 0) {
$this->check($ID,
} else {
// Create item
$this->check(-1,
}
Linha 3 956 ⟶ 3 622:
if ($values["_users_id_requester"]) {
//Get all the user's entities
$all_entities = Profile_User::getUserEntities($values["_users_id_requester"], true,
true);
//For each user's entity, check if the technician which creates the ticket have access to it
foreach ($all_entities as $tmp => $ID_entity) {
Linha 3 966 ⟶ 3 633:
$this->countentitiesforuser = count($this->userentities);
if (($this->countentitiesforuser > 0)
&& !in_array($this->fields["entities_id"], $this->userentities)) {
// If entity is not in the list of user's entities,
// then use as default value the first value of the user's entites list
$this->fields["entities_id"] = $this->userentities[0];
// Pass to values
$values['entities_id'] = $this->userentities[0];
}
}
if ($values['type'] <= 0) {
$values['type'] =
}
if (!isset($options['template_preview'])) {
$options['template_preview'] = 0;
}
// Load ticket template if available :
$tt = $this->getTicketTemplateToUse($options['template_preview'], $this->fields['type'],
$this->fields['itilcategories_id'], $this->fields['entities_id']);
} else {
$tt = $this->getTicketTemplateToUse($options['template_preview'], $values['type'],
$values['itilcategories_id'], $values['entities_id']);
}
Linha 4 025 ⟶ 3 664:
if (isset($values['_predefined_fields'])) {
$values['_predefined_fields']
=
} else {
$values['_predefined_fields'] = array();
Linha 4 034 ⟶ 3 673:
$predefined_fields = array();
if (!$ID) {
if (isset($tt->predefined) && count($tt->predefined)) {
foreach ($tt->predefined as $predeffield => $predefvalue) {
Linha 4 040 ⟶ 3 680:
// Set if already predefined field
// Set if ticket template change
if (((count($values[
||
||
&& ($values['_tickettemplates_id'] != $tt->getID()))) {
// Load template data
$values[$predeffield] = $predefvalue;
Linha 4 051 ⟶ 3 692:
}
}
}
// All predefined override : add option to say predifined exists
if (count($predefined_fields) == 0) {
$predefined_fields['_all_predefined_override'] = 1;
}
Linha 4 063 ⟶ 3 708:
}
}
// Put ticket template on $values for actors
$values['_tickettemplate'] = $tt;
$canupdate = Session::haveRight(
$canpriority = Session::haveRight(
$
if ($ID && in_array($this->fields['status'], $this->getClosedStatusArray())) {
$canupdate = false;
// No update for actors
$values['_noupdate'] = true;
}
$showuserlink = 0;
if (Session::haveRight('user', READ)) {
$showuserlink = 1;
}
if ($options['template_preview']) {
// Add all values to fields of tickets for template preview
foreach ($
if (!isset($this->fields[$key])) {
$this->fields[$key] = $val;
}
}
}
// In percent
$colsize1 = '13';
$colsize2 = '29';
$colsize3 = '13';
$colsize4 = '45';
$canupdate_descr = $canupdate
|| (($this->fields['status'] == && ($this->numberOfFollowups() ==
if (!$options['template_preview']) {
echo "<form method='post' name='form_ticket' enctype='multipart/form-data' action='".
$CFG_GLPI["root_doc"]."/front/ticket.form.php'>";
if (isset($options['projecttasks_id'])) {
echo "<input type='hidden' name='_projecttasks_id' value='".$options['projecttasks_id']."'>";
}
}
echo "<div class='spaced' id='tabsbody'>";
echo "<table class='tab_cadre_fixe' id='mainformtable'>";
// Optional line
$ismultientities = Session::isMultiEntitiesMode();
echo "<tr class='headerRow'>";
echo "<th colspan='4'>";
if ($ID) {
sprintf(__('%1$s: %2$s'), __('ID'), $ID));
if ($ismultientities) {
$text = sprintf(__('%1$s (%2$s)'), $text,
Dropdown::getDropdownName('glpi_entities',
$this->fields['entities_id']));
}
echo $text;
} else {
if ($ismultientities) {
printf(__('The ticket will be added in the entity %s'),
Dropdown::getDropdownName("glpi_entities", $this->fields['entities_id']));
} else {
}
}
Linha 4 123 ⟶ 3 783:
echo "<tr class='tab_bg_1'>";
echo "<th width='$colsize1%'
echo $tt->getBeginHiddenFieldText('date');
if (!$ID) {
printf(__('%1$s%2$s'), __('Opening date'), $tt->getMandatoryMark('date'));
} else {
_e('Opening date');
}
echo $tt->getEndHiddenFieldText('date');
echo "</th>";
echo "<td width='$colsize2%'>";
echo $tt->getBeginHiddenFieldValue('date');
$date = $this->fields["date"];
if ($canupdate) {
Html::
'timestep' => 1,
'maybeempty' => false));
} else {
echo Html::convDateTime($date);
}
echo $tt->getEndHiddenFieldValue('date', $this);
echo "</td>";
// SLA
echo "<th width='$colsize3%'>".$tt->getBeginHiddenFieldText('due_date');
if (!$ID) {
} else {
_e('Due date');
}
echo $tt->getEndHiddenFieldText('due_date');
Linha 4 144 ⟶ 3 817:
echo "<td width='$colsize4%' class='nopadding'>";
if ($ID) {
if ($this->fields["slas_id"] > 0) {
echo "<table width='100%'><tr><td class='nopadding'>";
echo Html::convDateTime($this->fields["due_date"]);
echo "</td><td class='b'>".__('SLA')."</td>";
echo "<
echo Dropdown::getDropdownName("glpi_slas", $this->fields["slas_id"]);
$commentsla = "";
$slalevel = new SlaLevel();
if ($slalevel->getFromDB($this->fields['slalevels_id'])) {
$commentsla .= '<span class="b spaced">'
$slalevel->getName()).'</span><br>';
}
$nextaction = new SlaLevel_Ticket();
if ($nextaction->getFromDBForTicket($this->fields["id"])) {
$commentsla .= '<span class="b spaced">'
Html::convDateTime($nextaction->fields['date'])).
'</span><br>';
if ($slalevel->getFromDB($nextaction->fields['slalevels_id'])) {
$commentsla .= '<span class="b spaced">'
$slalevel->getName()).'</span>';
}
}
$slaoptions = array();
if (Session::haveRight('config',
$slaoptions['link'] = Toolbox::getItemTypeFormURL('SLA').
"?id=".$this->fields["slas_id"]; }
Html::showToolTip($commentsla,$slaoptions);
if ($canupdate) {
echo "
Html::showSimpleForm($this->getFormURL(),
_x('button', 'Delete permanently'),
array('id' => $this->getID()));
}
echo "</td
echo "</tr></table>";
} else {
echo "<table width='100%'><tr><td class='nopadding'>";
echo $tt->getBeginHiddenFieldValue('due_date');
Html::showDateTimeField("due_date", array('value' => $this->fields["due_date"],
'timestep' => 1,
'maybeempty' => true));
} else {
echo Html::convDateTime($this->fields["due_date"]);
}
echo $tt->getEndHiddenFieldValue('due_date',$this);
echo "</td>";
if (
echo "<td>";
echo $tt->getBeginHiddenFieldText('slas_id');
echo "<span id='sla_action'>";
echo "<a class='
Html::addConfirmationOnAction(array(__('The assignment of a SLA to a ticket causes the recalculation of the due
__("Escalations defined in the SLA will be triggered under this new
"
echo "</span>";
echo "<div id='sla_choice' style='display:none'>";
echo "<span class='b'>".__('SLA')."</span> ";
Sla::dropdown(array('entity' => $this->fields["entities_id"],
'value' => $this->fields["slas_id"]));
echo "</div>";
echo $tt->getEndHiddenFieldText('slas_id');
echo "</td>";
Linha 4 205 ⟶ 3 892:
} else { // New Ticket
echo "<table width='100%'><tr><td width='40%' class='nopadding'>";
if ($this->fields["due_date"] == 'NULL') {
$this->fields["due_date"]='';
}
echo $tt->getBeginHiddenFieldValue('due_date');
Html::
'timestep' => 1,
'maybeempty' => false,
'canedit' => $canupdate));
echo $tt->getEndHiddenFieldValue('due_date',$this);
echo "</td>";
if ($canupdate) {
echo "<td class='nopadding b'>".$tt->getBeginHiddenFieldText('slas_id')
printf(__('%1$s%2$s'),
echo "<td class='nopadding'>".$tt->getBeginHiddenFieldValue('slas_id');
echo $tt->getEndHiddenFieldValue('slas_id',$this);
echo "</td>";
Linha 4 225 ⟶ 3 915:
echo "</tr></table>";
}
echo "</td></tr>";
if ($ID) {
echo "<tr class='tab_bg_1'>";
echo "<th width='$colsize1%'>".
echo "<td width='$colsize2%'>";
if ($canupdate) {
User::dropdown(array('name' => 'users_id_recipient',
Linha 4 240 ⟶ 3 929:
echo getUserName($this->fields["users_id_recipient"], $showuserlink);
}
echo "</td>";
echo "<th width='$colsize3%'>".
echo "<td
if ($this->fields['users_id_lastupdater'] > 0) {
//TRANS: %1$s is the update date, %2$s is the last updater name
getUserName($this->fields["users_id_lastupdater"], $showuserlink));
}
echo "</td>";
Linha 4 251 ⟶ 3 942:
}
if ($ID
&& (in_array($this->fields["status"], $this->getSolvedStatusArray()) echo "<tr class='tab_bg_1'>";
echo "<th width='$colsize1%'>".
echo "<td width='$colsize2%'>";
Html::
'maybeempty' => false,
'canedit' => $canupdate));
echo "</td>";
if (in_array($this->fields["status"], $this->getClosedStatusArray())) {
'canedit' => $canupdate));
echo "</td>";
} else {
echo "<td colspan='2'> </td>";
Linha 4 273 ⟶ 3 970:
if ($ID) {
echo "</table>";
echo "<table class='tab_cadre_fixe' id='mainformtable2'>";
}
echo "<tr class='tab_bg_1'>";
echo "<th width='$colsize1%'>".
$tt->getMandatoryMark('type'))."</th>";
echo "<td width='$colsize2%'>";
// Permit to set type when creating ticket without update right
Linha 4 284 ⟶ 3 982:
/// Auto submit to load template
if (!$ID) {
$opt['on_change'] = 'this.form.submit()';
}
$rand = self::dropdownType('type', $opt);
Linha 4 301 ⟶ 3 999:
}
echo "</td>";
echo "<th width='$colsize3%'>".sprintf(__('%1$
echo "<td width='$colsize4%'>";
// Permit to set category when creating ticket without update right
if ($canupdate
|| !$ID || $canupdate_descr) { $opt = array('value' => $this->fields["itilcategories_id"],
'entity' => $this->fields["entities_id"]);
Linha 4 316 ⟶ 4 016:
/// Auto submit to load template
if (!$ID) {
$opt['on_change'] = 'this.form.submit()';
}
/// if category mandatory, no empty choice
/// no empty choice is default value set on ticket creation, else yes
if (($ID || $values['itilcategories_id'])
&& $tt->isMandatoryField("itilcategories_id")
&& ($this->fields["itilcategories_id"] > 0)) {
$opt['display_emptychoice'] = false;
}
switch ($this->fields[
case self::INCIDENT_TYPE :
$opt['condition'] .= "`is_incident`='1'";
Linha 4 338 ⟶ 4 038:
break;
}
echo "<span id='show_category_by_type'>";
echo "</span>";
} else {
Linha 4 350 ⟶ 4 049:
if (!$ID) {
echo "</table>";
$this->showActorsPartForm($ID, $values);
echo "<table class='tab_cadre_fixe' id='mainformtable3'>";
}
echo "<tr class='tab_bg_1'>";
echo "<th width='$colsize1%'>".$tt->getBeginHiddenFieldText('status')
printf(__('%1$s%2$s'),
echo $tt->getEndHiddenFieldText('status')."</th>"; echo "<td width='$colsize2%'>";
echo $tt->getBeginHiddenFieldValue('status');
if ($
self::dropdownStatus(
'showtype' => 'allowed'));
TicketValidation::alertValidation($this, 'status');
} else {
echo self::getStatus($this->fields["status"]);
if (in_array($this->fields["status"], $this->getClosedStatusArray())
&& $this->isAllowedStatus($this->fields['status'], Ticket::INCOMING)) {
echo " <a class='vsubmit' href='".$this->getLinkURL().
"&forcetab=TicketFollowup$1&_openfollowup=1'>". __('Reopen')."</a>";
}
}
echo $tt->getEndHiddenFieldValue('status',$this);
echo "</td>";
echo "<th width='$colsize3%'>".$tt->getBeginHiddenFieldText('requesttypes_id')
printf(__('%1$s%2$s'), __('Request source'),
echo "<td width='$colsize4%'>";
echo $tt->getBeginHiddenFieldValue('requesttypes_id');
if ($canupdate) {
} else {
echo Dropdown::getDropdownName('glpi_requesttypes', $this->fields["requesttypes_id"]);
Linha 4 382 ⟶ 4 089:
echo "<tr class='tab_bg_1'>";
echo "<th>".$tt->getBeginHiddenFieldText('urgency')
printf(__('%1$s%2$s'),
echo $tt->getEndHiddenFieldText('urgency')."</th>"; echo "<td>";
Linha 4 391 ⟶ 4 099:
// Only change during creation OR when allowed to change priority OR when user is the creator
echo $tt->getBeginHiddenFieldValue('urgency');
$idurgency = self::dropdownUrgency(
echo $tt->getEndHiddenFieldValue('urgency', $this);
} else {
$idurgency = "value_urgency".mt_rand();
echo "<input id='$idurgency' type='hidden' name='urgency' value='".
$this->fields["urgency"]."'>"; echo parent::getUrgencyName($this->fields["urgency"]);
}
Linha 4 405 ⟶ 4 113:
if (!$ID) {
echo $tt->getBeginHiddenFieldText('_add_validation');
echo $tt->getEndHiddenFieldText('_add_validation');
} else {
echo $
_e('Approval');
echo $tt->getEndHiddenFieldText('global_validation');
}
echo "</th>";
Linha 4 414 ⟶ 4 124:
if (!$ID) {
echo $tt->getBeginHiddenFieldValue('_add_validation');
$validation_right = '';
if
&& Session::haveRight('ticketvalidation', TicketValidation::CREATEINCIDENT)) {
}
if (($values['type'] == self::DEMAND_TYPE)
&& Session::haveRight('ticketvalidaton', TicketValidation::CREATEREQUEST)) {
$validation_right = 'validate_request';
}
if (!empty($validation_right)) {
echo "<input type='hidden' name='_add_validation' value='".
$values['_add_validation']."'>";
$users_id_validate = array();
$params = array('name' => "users_id_validate",
'entity' => $this->fields['entities_id'],
'right' => $validation_right,
'users_id_validate' => $users_id_validate);
TicketValidation::dropdownValidator($params);
}
echo $tt->getEndHiddenFieldValue('_add_validation',$this);
if ($tt->isPredefinedField('global_validation')) {
echo "<input type='hidden' name='global_validation' value='".
$tt->predefined['global_validation']."'>";
}
} else {
echo $tt->getBeginHiddenFieldValue('global_validation');
if ($canupdate) {
TicketValidation::dropdownStatus('global_validation',
Linha 4 429 ⟶ 4 159:
echo TicketValidation::getStatus($this->fields['global_validation']);
}
echo $tt->getEndHiddenFieldValue('global_validation',$this);
}
echo "</td></tr>";
echo "<tr class='tab_bg_1'>";
echo "<th>".$tt->getBeginHiddenFieldText('impact')
printf(__('%1$s%2$s'),
echo $tt->getEndHiddenFieldText('impact')."</th>"; echo "<td>";
echo $tt->getBeginHiddenFieldValue('impact');
if ($canupdate) {
$idimpact = self::dropdownImpact(
} else {
$idimpact = "value_impact".mt_rand();
Linha 4 447 ⟶ 4 181:
echo "</td>";
echo "<th rowspan='2'>".$tt->getBeginHiddenFieldText('itemtype')
printf(__('%1$s%2$s'), __('Associated
if ($ID && $canupdate) {
echo " <img title=
onClick=\"
class='pointer' src='".$CFG_GLPI["root_doc"]."/pics/showselect.png'>";
}
echo $tt->getEndHiddenFieldText('itemtype');
Linha 4 460 ⟶ 4 194:
// Select hardware on creation or if have update right
if ($canupdate
|| !$ID || $canupdate_descr) { if ($ID) {
if ($this->fields['itemtype']
&& ($item = getItemForItemtype($this->fields['itemtype']))
&& $this->fields["items_id"]) {
if
printf(__('%1$s - %2$s'), $item->getTypeName(),
$item->getLink(array('comments' => true)));
} else {
}
}
}
$dev_user_id = 0;
$dev_itemtype = $this->fields["itemtype"];
$dev_items_id = $this->fields["items_id"];
Linha 4 479 ⟶ 4 218:
$dev_itemtype = $values["itemtype"];
$dev_items_id = $values["items_id"];
} else if (isset($this->users[CommonITILActor::REQUESTER])
foreach
$dev_user_id = $user_id_single['users_id'];
}
Linha 4 489 ⟶ 4 227:
echo "<div id='tickethardwareselection$ID' style='display:none'>";
}
if ($dev_user_id > 0) {
self::dropdownMyDevices($dev_user_id, $this->fields["entities_id"],
Linha 4 498 ⟶ 4 237:
echo "</div>";
}
echo "<span id='item_ticket_selection_information'></span>";
Linha 4 504 ⟶ 4 244:
&& $this->fields['itemtype']
&& ($item = getItemForItemtype($this->fields['itemtype']))) {
if ($item->
$item->getLink(array('comments' => true)));
} else {
printf(__('%1$s - %2$s'), $item->getTypeName(), $item->getNameID());
}
} else {
}
}
Linha 4 516 ⟶ 4 260:
echo "<tr class='tab_bg_1'>";
echo "<th>".sprintf(__('%1$
echo "<td>";
$idajax
if ($canupdate
&& $canpriority && !$tt->isHiddenField('priority')) { $idpriority = parent::dropdownPriority(
'withmajor' => true));
echo " <span id='$idajax' style='display:none'></span>";
} else {
$idpriority = 0;
echo $tt->getBeginHiddenFieldValue('priority');
echo "<span id='$idajax'>".parent::getPriorityName($this->fields["priority"])."</span>";
echo $tt->getEndHiddenFieldValue('priority', $this);
}
if ($canupdate
|| $canupdate_descr) { $params = array('urgency' => '__VALUE0__',
'impact' => '__VALUE1__',
'priority' => 'dropdown_priority'.$idpriority);
Ajax::updateItemOnSelectEvent(array('dropdown_urgency'.$idurgency
'dropdown_impact'.$idimpact),
$idajax,
$CFG_GLPI["root_doc"]."/ajax/priority.php", $params);
}
Linha 4 540 ⟶ 4 291:
echo "</tr>";
echo "<tr class='tab_bg_1'>";
// Need comment right to add a followup with the actiontime
if (!$ID
&& Session::haveRight('followup', TicketFollowup::ADDALLTICKET)) {
echo "<th>".$tt->getBeginHiddenFieldText('actiontime');
printf(__('%1$s%2$s'), __('Total duration'), $tt->getMandatoryMark('actiontime'));
echo $tt->getEndHiddenFieldText('actiontime')."</th>";
echo "<td>";
echo $tt->getBeginHiddenFieldValue('actiontime');
Dropdown::showTimeStamp('actiontime', array('value' => $values['actiontime'],
'addfirstminutes' => true));
echo $tt->getEndHiddenFieldValue('actiontime',$this);
} else
echo "<th></th><td></td>";
}
echo "<th>".$tt->getBeginHiddenFieldText('locations_id');
printf(__('%1$s%2$s'), __('Location'), $tt->getMandatoryMark('locations_id'));
echo $tt->getEndHiddenFieldText('locations_id')."</th>";
echo "<td>";
echo $tt->getBeginHiddenFieldValue('locations_id');
if ($canupdate) {
Location::dropdown(array('value' => $this->fields['locations_id'],
'entity' => $this->fields['entities_id']));
} else {
echo Dropdown::getDropdownName('glpi_locations', $this->fields["locations_id"]);
}
echo $tt->getEndHiddenFieldValue('locations_id', $this);
echo "</td></tr>";
echo "</table>";
if ($ID) {
$this->showActorsPartForm($ID, $values);
}
$view_linked_tickets = ($ID || $canupdate);
echo "<table class='tab_cadre_fixe' id='mainformtable4'>";
echo "<tr class='tab_bg_1'>";
echo "<th width='$colsize1%'>".$tt->getBeginHiddenFieldText('name')
printf(__('%1$s%2$s'),
echo "<td width='".(100-$colsize1)."%' colspan='3'>";
if (!$ID
|| $canupdate_descr) { echo $tt->
echo "<input type='text' size='90' maxlength=250 name='name' ".
" value=\"".Html::cleanInputText($this->fields["name"])."\">";
echo
} else {
if (empty($this->fields["name"])) {
} else {
echo $this->fields["name"];
Linha 4 609 ⟶ 4 350:
echo "</td>";
echo "</tr>";
echo "<tr class='tab_bg_1'>";
echo "<th width='$colsize1%'>".$tt->getBeginHiddenFieldText('
printf(__('%1$s%2$s'),
if (!$ID
|| $canupdate_descr) {
$content = Toolbox::unclean_cross_side_scripting_deep(Html::entity_decode_deep($this->fields['content']));
Html::showTooltip(nl2br(Html::Clean($content)));
}
echo $tt->getEndHiddenFieldText('content')."</
echo "<td width='".(100-$colsize1)."%' colspan='3'>";
if (!$ID
|| $canupdate_descr) { // Admin =oui on autorise la modification de la description
echo $tt->getBeginHiddenFieldValue('content');
$rand = mt_rand();
$rows = 6;
$
if ($CFG_GLPI["use_rich_text"]) {
$this->fields["content"] = $this->setRichTextContent($content_id,
$rand);
$cols =
} else {
}
echo "<div id='
echo "<
$this->fields["content"]."</textarea></div>";
} else {
$content = Toolbox::unclean_cross_side_scripting_deep(Html::entity_decode_deep($this->fields['content']));
}
echo "</td>";
echo "</tr>";
echo "<tr class='tab_bg_1'>";
if ($view_linked_tickets) {
echo "<th width='$
$rand_linked_ticket = mt_rand();
if ($canupdate) {
echo " ";
echo "<img onClick=\"
}
echo '</th>';
echo "<td width='".(100-$
if ($canupdate) {
echo "<div style='display:none' id='linkedticket$rand_linked_ticket'>";
echo "<table class='tab_format' width='100%'><tr><td width='30%'>";
Ticket_Ticket::dropdownLinks('_link[link]',
(isset($values["_link"])?$values["_link"]['link']:''));
echo "<input type='hidden' name='_link[tickets_id_1]' value='$ID'>\n";
echo "<
$linkparam = array('name' =>
if (isset($values["_link"])) {
$linkparam['value'] = $values["_link"]['tickets_id_2'];
}
Ticket::dropdown($linkparam);
echo "</td></tr></table>";
echo "</div>";
if (isset($values["_link"])
&& !empty($values["_link"]['tickets_id_2'])) { echo "<script language='javascript'>
echo Html::jsShow( echo
}
}
Linha 5 139 ⟶ 4 432:
echo "</td>";
}
echo "</tr>";
// View files added
echo "<tr class='tab_bg_1'>";
// Permit to add doc when creating a ticket
echo "<th width='$colsize1%'>";
echo $tt->getBeginHiddenFieldText('_documents_id');
$doctitle = sprintf(__('File (%s)'), Document::getMaxUploadSize());
printf(__('%1$s%2$s'), $doctitle, $tt->getMandatoryMark('_documents_id'));
// Do not show if hidden.
if (!$tt->isHiddenField('_documents_id')) {
DocumentType::showAvailableTypesLink();
}
echo $tt->getEndHiddenFieldText('_documents_id');
echo "</th>";
echo "<td colspan='3' width='".(100-$colsize1)."%' >";
// Do not set values
echo $tt->getEndHiddenFieldValue('_documents_id');
if ($tt->isPredefinedField('_documents_id')) {
if (isset($values['_documents_id'])
&& is_array($values['_documents_id'])
&& count($values['_documents_id'])) {
echo "<span class='b'>".__('Default documents:').'</span>';
echo "<br>";
$doc = new Document();
foreach ($values['_documents_id'] as $key => $val) {
if ($doc->getFromDB($val)) {
echo "<input type='hidden' name='_documents_id[$key]' value='$val'>";
echo "- ".$doc->getNameID()."<br>";
}
}
}
}
echo "<div id='fileupload_info'></div>";
echo "</td>";
echo "</tr>";
Linha 5 145 ⟶ 4 473:
|| $canupdate
|| $canupdate_descr
|| Session::
&& !$options['template_preview']) {
echo "<tr class='tab_bg_1'>";
if ($ID) {
if (Session::
|| $this->canUpdateItem()) {
echo "<td class='tab_bg_2 center' colspan='4'>";
if ($this->fields["is_deleted"] == 1) {
if (self::canPurge()) {
echo "<input type='submit' class='submit' name='restore' value='". }
} else {
if (self::canUpdate() ) {
echo "<input type='submit' class='submit' name='update' value='". }
}
if ($this->fields["is_deleted"] == 1) {
if (self::canPurge()) {
echo "<input type='submit' class='submit' name='purge' value='". Html::addConfirmationOnAction(
}
} else {
if (self::canDelete()) {
echo "<input type='submit' class='submit' name='delete' value='". }
}
echo "<input type='hidden' name='_read_date_mod' value='".$this->getField('date_mod')."'>";
}
} else {
echo "<td class='tab_bg_2 center' colspan='4'>";
echo "<input type='submit' name='add' value=\"".
if ($tt->isField('id') && ($tt->fields['id'] > 0)) {
echo "<input type='hidden' name='_tickettemplates_id' value='".$tt->fields['id']."'>";
echo "<input type='hidden' name='_predefined_fields'
}
}
}
// File upload system
$colspan = 2;
if (!$CFG_GLPI['use_rich_text']) {
$colspan = 4;
}
echo "<tr class='tab_bg_1'>";
echo "<td colspan='$colspan'>";
echo $tt->getBeginHiddenFieldValue('_documents_id');
echo Html::file(array('multiple' => true,
'showfilecontainer' => 'fileupload_info',
'values' => array('filename' => $values['_filename'],
'tag' => $values['_tag_filename'])
));
echo "</td>";
if ($CFG_GLPI['use_rich_text']) {
echo "<td colspan='$colspan'>";
if (!isset($rand)) {
$rand = mt_rand();
}
echo Html::imagePaste(array('rand' => $rand));
echo "</td>";
}
echo "</tr>";
echo "</table>";
Linha 5 195 ⟶ 4 552:
echo "</div>";
if (!
}
return true;
}
/**
* @param $size (default 25)
**/
static function showDocumentAddButton($size=25) {
global
echo "<script type='text/javascript'>var nbfiles=1; var maxfiles = 5;</script>";
echo "<span id='addfilebutton'><img title=\"".
var row =
row.
nbfiles++;
if (nbfiles==maxfiles) {
}
}\"
Linha 5 220 ⟶ 4 580:
/**
* @param $start
* @param $status (default ''process)
* @param $showgrouptickets (true by default)
*/
static function showCentralList($start, $status="process", $showgrouptickets=true) {
global $DB, $CFG_GLPI
if (!Session::haveRightsOr(self::$rightname, array(CREATE, self::READALL, self::READASSIGN))
&& !Session::haveRightsOr('ticketvalidation', TicketValidation::getValidateRights())) {
return false;
}
$search_users_id = " (`glpi_tickets_users`.`users_id` = '".Session::getLoginUserID()."'
AND `glpi_tickets_users`.`type` = '".
$search_assign = " (`glpi_tickets_users`.`users_id` = '".Session::getLoginUserID()."'
AND `glpi_tickets_users`.`type` = '".
$search_observer = " (`glpi_tickets_users`.`users_id` = '".Session::getLoginUserID()."'
AND `glpi_tickets_users`.`type` = '".CommonITILActor::OBSERVER."')";
$is_deleted = " `glpi_tickets`.`is_deleted` = 0 ";
if ($showgrouptickets) {
Linha 5 241 ⟶ 4 608:
if (count($_SESSION['glpigroups'])) {
$groups = implode("
$search_assign = " (`glpi_groups_tickets`.`groups_id` IN (
AND `glpi_groups_tickets`.`type` = '".
if (Session::haveRight(
$search_users_id = " (`glpi_groups_tickets`.`groups_id` IN ('$groups')
AND `glpi_groups_tickets`.`type`
= '".CommonITILActor::REQUESTER."') ";
$search_observer = " (`glpi_groups_tickets`.`groups_id` IN ('$groups')
AND `glpi_groups_tickets`.`type`
= '".CommonITILActor::OBSERVER."') ";
}
}
Linha 5 261 ⟶ 4 632:
switch ($status) {
case "waiting" : // on affiche les tickets en attente
$query .= "WHERE $is_deleted
AND ($search_assign) AND `status` = '
getEntitiesRestrictRequest("AND", "glpi_tickets");
break;
case "process" : // on affiche les tickets planifiés ou assignés au user
$query .= "WHERE $is_deleted
AND ( $search_assign ) AND (`status` IN ('
getEntitiesRestrictRequest("AND", "glpi_tickets");
break;
case "toapprove" : // on affiche les tickets planifiés ou assignés au user
$query .= "WHERE $is_deleted
AND (`status` = '".self::SOLVED."')
AND ($search_users_id";
if (!$showgrouptickets) {
Linha 5 281 ⟶ 4 655:
getEntitiesRestrictRequest("AND", "glpi_tickets");
break;
case "tovalidate" : // on affiche les tickets à valider
$query .= " LEFT JOIN `glpi_ticketvalidations`
ON (`glpi_tickets`.`id` = `glpi_ticketvalidations`.`tickets_id`)
WHERE $is_deleted
AND `users_id_validate` = '".Session::getLoginUserID()."' AND `glpi_ticketvalidations`.`status` = '
AND (`glpi_tickets`.`status` NOT IN ('
getEntitiesRestrictRequest("AND", "glpi_tickets");
break;
case "rejected" : // on affiche les tickets rejetés
$query .= "WHERE $is_deleted
AND ($search_assign) AND `status` <> '
AND `global_validation` = '
getEntitiesRestrictRequest("AND", "glpi_tickets");
break;
case "observed" :
$query .= "WHERE $is_deleted
AND ($search_observer)
AND (`status` IN ('".self::INCOMING."',
'".self::PLANNED."',
'".self::ASSIGNED."',
'".self::WAITING."'))
AND NOT ( $search_assign )
AND NOT ( $search_users_id ) ".
getEntitiesRestrictRequest("AND","glpi_tickets");
break;
case "requestbyself" : // on affiche les tickets demandés le user qui sont planifiés ou assignés
Linha 5 303 ⟶ 4 690:
default :
$query .= "WHERE $is_deleted
AND ($search_users_id) AND (`status` IN ('
'".self::WAITING."'))
AND NOT ( $search_assign ) ".
getEntitiesRestrictRequest("AND","glpi_tickets");
}
Linha 5 316 ⟶ 4 707:
$query .= " LIMIT ".intval($start).','.intval($_SESSION['glpidisplay_count_on_home']);
$result = $DB->query($query);
$number = $DB->numrows($result);
} else {
$number = 0;
Linha 5 322 ⟶ 4 713:
if ($numrows > 0) {
echo "<table class='tab_cadrehov
echo "<tr class='noHover'><th colspan='
$options['reset'] = 'reset';
$forcetab = '';
$num = 0;
if ($showgrouptickets) {
switch ($status) {
case "toapprove" :
$options['criteria'][1]['field']
$forcetab
echo "<a href=\"".$CFG_GLPI["root_doc"]."/front/ticket.php?".
Toolbox::append_params($options,'&')."\">".
Html::makeTitle(
break;
case "waiting" :
$options['criteria'][1]['field']
echo "<a href=\"".$CFG_GLPI["root_doc"]."/front/ticket.php?".
Toolbox::append_params($options,'&')."\">".
Html::makeTitle(
break;
case "process" :
$options['criteria'][1]['field']
echo "<a href=\"".$CFG_GLPI["root_doc"]."/front/ticket.php?".
Toolbox::append_params($options,'&')."\">".
Html::makeTitle(
break;
case "observed":
$options['criteria'][0]['field'] = 12; // status
$options['criteria'][0]['searchtype'] = 'equals';
$options['criteria'][0]['value'] = 'notold';
$options['criteria'][0]['link'] = 'AND';
$options['criteria'][1]['field'] = 65; // groups_id
$options['criteria'][1]['searchtype'] = 'equals';
$options['criteria'][1]['value'] = 'mygroups';
$options['criteria'][1]['link'] = 'AND';
echo "<a href=\"".$CFG_GLPI["root_doc"]."/front/ticket.php?".
Toolbox::append_params($options,'&')."\">".
Html::makeTitle(__('Your observed tickets'), $number, $numrows)."</a>";
break;
case "requestbyself" :
default :
$options['criteria'][1]['field']
echo "<a href=\"".$CFG_GLPI["root_doc"]."/front/ticket.php?".
Toolbox::append_params($options,'&')."\">".
Html::makeTitle(
}
Linha 5 408 ⟶ 4 806:
switch ($status) {
case "waiting" :
$options['
$options['
$options['
$options['
$options['
$options['
$options['
$options['
echo "<a href=\"".$CFG_GLPI["root_doc"]."/front/ticket.php?".
Toolbox::append_params($options,'&')."\">".
Html::makeTitle(
break;
case "process" :
$options['
$options['
$options['
$options['
$options['
$options['
$options['
$options['
echo "<a href=\"".$CFG_GLPI["root_doc"]."/front/ticket.php?".
Toolbox::append_params($options,'&')."\">".
Html::makeTitle(
break;
case "tovalidate" :
$options['
$options['
$options['
$options['
$options['
$options['
$options['
$options['
$
$options['criteria'][2]['searchtype'] = 'equals';
$options['criteria'][2]['value'] = 'old';
$options['criteria'][2]['link'] = 'AND NOT';
$forcetab = 'TicketValidation$1';
echo "<a href=\"".$CFG_GLPI["root_doc"]."/front/ticket.php?".
Toolbox::append_params($options,'&')."\">".
Html::makeTitle(
break;
case "rejected" :
$options['
$options['
$options['
$options['
$options['
$options['
$options['
$options['
echo "<a href=\"".$CFG_GLPI["root_doc"]."/front/ticket.php?".
Toolbox::append_params($options,'&')."\">".
Html::makeTitle(
break;
case "toapprove" :
$options['
$options['
$options['
$options['
$options['
$options['
$options['
$options['
$options['
$options['
$options['
$options['
$options['
$options['
$options['
$options['
$forcetab = 'Ticket$2';
echo "<a href=\"".$CFG_GLPI["root_doc"]."/front/ticket.php?".
Toolbox::append_params($options,'&')."\">".
Html::makeTitle(
break;
case "observed" :
$options['criteria'][0]['field'] = 66; // users_id
$options['criteria'][0]['searchtype'] = 'equals';
$options['criteria'][0]['value'] = Session::getLoginUserID();
$options['criteria'][0]['link'] = 'AND';
$options['criteria'][1]['field'] = 12; // status
$options['criteria'][1]['searchtype'] = 'equals';
$options['criteria'][1]['value'] = 'notold';
$options['criteria'][1]['link'] = 'AND';
echo "<a href=\"".$CFG_GLPI["root_doc"]."/front/ticket.php?".
Toolbox::append_params($options,'&')."\">".
Html::makeTitle(__('Your observed tickets'), $number, $numrows)."</a>";
break;
case "requestbyself" :
default :
$options['
$options['
$options['
$options['
$options['
$options['
$options['
$options['
echo "<a href=\"".$CFG_GLPI["root_doc"]."/front/ticket.php?".
Toolbox::append_params($options,'&')."\">".
Html::makeTitle(
}
}
Linha 5 530 ⟶ 4 942:
if ($number) {
echo "<tr><th></th>";
echo "<th>".
echo "<th>".
echo "<th>".
for ($i = 0 ; $i < $number ; $i++) {
$ID = $DB->result($result, $i, "id");
Linha 5 540 ⟶ 4 952:
echo "</table>";
}
}
/**
* Get tickets count
*
* @param $foruser boolean : only for current login user as requester (false by default)
**/
static function showCentralCount($foruser=false) {
global $DB, $CFG_GLPI
// show a tab with count of jobs in the central and give link
if (!Session::haveRight(
return false;
}
if (!Session::haveRight(
$foruser = true;
}
Linha 5 596 ⟶ 4 978:
$query .= " LEFT JOIN `glpi_tickets_users`
ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`
AND `glpi_tickets_users`.`type` = '".
if (Session::haveRight(
&& isset($_SESSION["glpigroups"])
&& count($_SESSION["glpigroups"])) {
$query .= " LEFT JOIN `glpi_groups_tickets`
ON (`glpi_tickets`.`id` = `glpi_groups_tickets`.`tickets_id`
AND `glpi_groups_tickets`.`type` = '".
}
}
Linha 5 611 ⟶ 4 993:
$query .= " AND (`glpi_tickets_users`.`users_id` = '".Session::getLoginUserID()."' ";
if (Session::haveRight(
&& isset($_SESSION["glpigroups"])
&& count($_SESSION["glpigroups"])) {
$groups = implode("
$query .= " OR `glpi_groups_tickets`.`groups_id` IN (
}
$query.= ")";
Linha 5 621 ⟶ 5 003:
$query_deleted = $query;
$query .= " AND NOT `glpi_tickets`.`is_deleted`
GROUP BY `status`";
$
$result = $DB->query($query);
$result_deleted = $DB->query($query_deleted);
$status = array(
foreach (self::getAllStatusArray() as $key => $val) {
}
if ($DB->numrows($result) > 0) {
while ($data = $DB->fetch_assoc($result)) {
$status[$data["status"]] = $data["COUNT"];
}
}
$number_deleted = 0;
if ($DB->numrows($result_deleted) > 0) {
while ($data = $DB->fetch_assoc($result_deleted)) {
$number_deleted += $data["COUNT"];
}
}
$options['criteria'][0]['field'] = 12;
$options['
$options['
$options['
$options['reset'] ='reset';
echo "<table class='tab_cadrehov' >";
echo "<tr class='noHover'><th colspan='2'>";
if ($
echo "<a href=\"".$CFG_GLPI["root_doc"]."/front/helpdesk.public.php?create_ticket=1\">".
"/pics/menu_add.png' title=\"".
} else {
echo "<a href=\"".$CFG_GLPI["root_doc"]."/front/ticket.php?".
}
echo "</th></tr>";
echo "<tr><th>".
foreach ($status as $key => $val) {
$options['criteria'][0]['value'] = $key;
echo "<tr class='tab_bg_2'>";
echo "<td><a href=\"".$CFG_GLPI["root_doc"]."/front/ticket.php?". Toolbox::append_params($options,'&')."\">".self::getStatus($
echo "<td class='numeric'>
}
$options['
$options['is_deleted'] = 1;
echo "<tr class='tab_bg_2'>";
echo "<td><a href=\"".$CFG_GLPI["root_doc"]."/front/ticket.php?".
Toolbox::append_params($options,'&')."\">".
echo "<td class='numeric'>".$
echo "</table><br>";
Linha 5 718 ⟶ 5 068:
static function showCentralNewList() {
global $DB, $CFG_GLPI
if (!Session::haveRight(
return false;
}
Linha 5 726 ⟶ 5 076:
$query = "SELECT ".self::getCommonSelect()."
FROM `glpi_tickets` ".self::getCommonLeftJoin()."
WHERE `status` = '
getEntitiesRestrictRequest("AND","glpi_tickets")."
AND NOT `is_deleted`
ORDER BY `glpi_tickets`.`date_mod` DESC
LIMIT ".intval($_SESSION['glpilist_limit']);
$result = $DB->query($query);
$number = $DB->numrows($result);
Linha 5 736 ⟶ 5 087:
if ($number > 0) {
Session::initNavigateListItems('Ticket');
$options['criteria'][0]['field'] = 12;
$options['
$options['
$options['
$options['reset'] ='reset';
echo "<div class='center'><table class='tab_cadre_fixe'>";
//TRANS: %d is the number of new tickets
echo "<tr><th colspan='12'>".sprintf(_n('%d new ticket','%d new tickets', $number), $number);
echo "<a href='".$CFG_GLPI["root_doc"]."/front/ticket.php?".
Toolbox::append_params($options,'&')."'>".
echo "</th></tr>";
self::commonListHeader(Search::HTML_OUTPUT);
while ($data = $DB->fetch_assoc($result)) {
Session::addToNavigateListItems('Ticket',$data["id"]);
self::showShort($data["id"]
}
echo "</table></div>";
Linha 5 760 ⟶ 5 111:
echo "<div class='center'>";
echo "<table class='tab_cadre_fixe'>";
echo "<tr><th>".
echo "</table>";
echo "</div><br>";
}
}
/**
Linha 5 813 ⟶ 5 127:
**/
static function showListForItem(CommonDBTM $item) {
global $DB, $CFG_GLPI
if (!Session::
array(self::READALL, self::READMY, self::READASSIGN, CREATE))) {
return false;
}
Linha 5 829 ⟶ 5 144:
switch ($item->getType()) {
case 'User' :
$restrict
$order
$options['
$options['
$options['
$options['criteria'][0]['value'] = $item->getID();
$options['criteria'][0]['link'] = 'AND';
break;
case 'SLA' :
$restrict
$order
$options['
$options['
$options['
$options['criteria'][0]['link'] = 'AND';
break;
case 'Supplier' :
$restrict
$
$options['
$options['
$options['criteria'][0]['value'] = $item->getID();
$options['criteria'][0]['link'] = 'AND';
break;
Linha 5 862 ⟶ 5 182:
$tree = Session::getSavedOption(__CLASS__, 'tree', 0);
echo "<table class='tab_cadre_fixe'>";
echo "<tr class='tab_bg_1'><th>".
echo "<tr class='tab_bg_1'><td class='center'>";
echo
Dropdown::showYesNo('tree', $tree, -1,
array('on_change' => 'reloadTab("start=0&tree="+this.value)'));
Linha 5 877 ⟶ 5 197:
$restrict = "='".$item->getID()."'";
}
$restrict
$order
$options['
$options['
$options['
$options['criteria'][0]['link'] = 'AND';
break;
default :
$restrict
" AND `itemtype` = '".$item->getType()."')"; if (!Session::haveRight(self::$rightname, self::READALL)) {
$restrict .= " AND (`glpi_tickets`.`users_id_recipient` = '".Session::getLoginUserID()."'
OR (`glpi_tickets_users`.`tickets_id` = '".$item->getID()."'
AND `glpi_tickets_users`.`users_id`
= '".Session::getLoginUserID()."'))";
}
$order = '`glpi_tickets`.`date_mod` DESC';
$options['criteria'][0]['field'] = 12;
$options['criteria'][0]['searchtype'] = 'equals';
$options['criteria'][0]['value'] = 'all';
$options['criteria'][0]['link'] = 'AND';
$options['
$options['
'id');
$options['
$options['
$options['metacriteria'][0]['link'] = 'AND';
break;
}
Linha 5 912 ⟶ 5 243:
$result = $DB->query($query);
$number = $DB->numrows($result);
$colspan = 11;
if (count($_SESSION["glpiactiveentities"]) > 1) {
$colspan++;
}
// Ticket for the item
echo "<div class='firstbloc
// Link to open a new ticket
if ($item->getID()
&& Ticket::isPossibleToAssignType($item->getType())
&& self::canCreate()) {
Html::showSimpleForm($CFG_GLPI["root_doc"]."/front/ticket.form.php",
'_add_fromitem', __('New ticket for this item...'),
array('itemtype' => $item->getType(),
'items_id' => $item->getID()));
}
echo "</div><div>";
echo "<table class='tab_cadre_fixehov'>";
if ($number > 0) {
if (Session::
Session::initNavigateListItems('Ticket',
//TRANS : %1$s is the itemtype name, %2$s is the name of the item (used for headings of a list)
sprintf(__('%1$s = %2$s'), $item->getTypeName(1),
$item->getName()));
echo "<tr class='noHover'><th colspan='
Toolbox::append_params($options,'&')."'>".__('Show all')."</a>";
$title = printf(__('%1$s (%2$s)'), $title, $link);
echo "</th></tr>";
} else {
echo "<tr><th colspan='$
}
} else {
echo "<tr><th>".
}
if ($item->getID()
&&
&&
echo "<tr><td class='tab_bg_2 center b' colspan='
'_add_fromitem', __('New ticket for this item...'),
array('_users_id_requester' => $item->getID()));
echo "</td></tr>";
}
Linha 5 955 ⟶ 5 297:
// Ticket list
if ($number > 0) {
self::commonListHeader(Search::HTML_OUTPUT);
while ($data = $DB->fetch_assoc($result)) {
Session::addToNavigateListItems('Ticket',$data["id"]);
self::showShort($data["id"]
}
self::commonListHeader(Search::HTML_OUTPUT);
}
Linha 5 966 ⟶ 5 309:
// Tickets for linked items
$restrict = array();
if (count($linkeditems)) {
foreach ($linkeditems as $ltype => $tab) {
foreach ($tab as $lID) {
$restrict[] = "(`itemtype` = '$ltype' AND `items_id` = '$lID')";
}
}
}
if (count($restrict)
&& Session::haveRight(self::$rightname, self::READALL)) {
$query = "SELECT ".self::getCommonSelect()."
FROM `glpi_tickets` ".self::getCommonLeftJoin()."
WHERE ".implode(
getEntitiesRestrictRequest(' AND ', 'glpi_tickets') . "
ORDER BY `glpi_tickets`.`date_mod` DESC
Linha 5 977 ⟶ 5 331:
echo "<div class='spaced'><table class='tab_cadre_fixe'>";
echo "<tr><th colspan='
echo "</th></tr>";
if ($number > 0) {
self::commonListHeader(Search::HTML_OUTPUT);
while ($data = $DB->fetch_assoc($result)) {
// Session::addToNavigateListItems(TRACKING_TYPE,$data["id"]);
self::showShort($data["id"]
}
self::commonListHeader(Search::HTML_OUTPUT);
} else {
echo "<tr><th>".
}
echo "</table></div>";
Linha 5 999 ⟶ 5 349:
}
/**
*
* @param $forcetab string name of the tab to force at the display (default '')
**/
static function showVeryShort($ID, $forcetab='') {
global $CFG_GLPI;
// Prints a job in short form
Linha 6 022 ⟶ 5 361:
// Print links or not in case of user view
// Make new job object and fill it from database, if success, print it
$
if (Session::haveRight('followup', TicketFollowup::SEEPRIVATE)) {
$showprivate = true;
}
$job = new self();
$rand = mt_rand();
if ($job->getFromDBwithData($ID, 0)) {
$bgcolor = $_SESSION["glpipriority_".$job->fields["priority"]];
// $rand = mt_rand();
echo "<tr class='tab_bg_2'>";
echo "<td class='center' bgcolor='$bgcolor'
$job->fields["id"])."</td>";
echo "<td class='center'>";
if (isset($job->users[
&& count($job->users[ foreach ($job->users[
if ($d["users_id"] > 0) {
$userdata = getUserName($d["users_id"],2);
Html::showToolTip($userdata["comment"],
array('link' => $userdata["link"],
'display' => false)));
echo $name;
} else {
echo $d['alternative_email']." ";
Linha 6 297 ⟶ 5 395:
if (isset($job->groups[
&& count($job->groups[ foreach ($job->groups[
echo Dropdown::getDropdownName("glpi_groups", $d["groups_id"]);
echo "<br>";
Linha 6 306 ⟶ 5 405:
echo "</td>";
if ($job->hardwaredatas
&& $job->hardwaredatas->canView()) { echo "<td class='center";
if ($job->hardwaredatas->isDeleted()) {
Linha 6 321 ⟶ 5 421:
} else {
echo "<td class='center' >".
}
echo "<td>";
"/front/ticket.form.php?id=".$job->fields["id"];
if ($forcetab != '') {
}
$link = sprintf(__('%1$s (%2$s)'), $link,
sprintf(__('%1$s - %2$s'), $job->numberOfFollowups($showprivate),
$content = Toolbox::unclean_cross_side_scripting_deep(html_entity_decode($job->fields['content'],
ENT_QUOTES,
"UTF-8"));
$link = printf(__('%1$s %2$s'), $link,
Html::showToolTip(nl2br(Html::Clean($content)),
array('applyto' => 'ticket'.$job->fields["id"].$rand,
'display' => false)));
echo "</td>";
Linha 6 342 ⟶ 5 447:
echo "</tr>";
} else {
echo "<tr class='tab_bg_2'>";
echo "<td colspan='6' ><i>". }
}
Linha 6 357 ⟶ 5 463:
return " DISTINCT `glpi_tickets`.*,
`glpi_itilcategories`.`completename` AS catname
$SELECT";
}
Linha 6 373 ⟶ 5 479:
LEFT JOIN `glpi_tickets_users`
ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id`)
LEFT JOIN `glpi_suppliers_tickets`
ON (`glpi_tickets`.`id` = `glpi_suppliers_tickets`.`tickets_id`)
LEFT JOIN `glpi_itilcategories`
ON (`glpi_tickets`.`itilcategories_id` = `glpi_itilcategories`.`id`)
LEFT JOIN `glpi_tickettasks`
ON (`glpi_tickets`.`id` = `glpi_tickettasks`.`tickets_id`)
$FROM";
}
/**
* @param $output
**/
static function showPreviewAssignAction($output) {
//If ticket is assign to an object, display this information first
Linha 6 390 ⟶ 5 502:
if ($item->getFromDB($output["items_id"])) {
echo "<tr class='tab_bg_2'>";
echo "<td>".
echo "<td>".$item->getLink(array('comments' => true))."</td>";
echo "</tr>";
}
}
unset($output["items_id"]);
}
unset($output["entities_id"]);
return $output;
}
/**
* Give cron
*
* @param $name : task's name
*
* @return arrray of
**/
static function cronInfo($name) {
switch ($name) {
case 'closeticket' :
return array('description' =>
case 'alertnotclosed' :
return array('description' =>
case 'createinquest' :
return array('description' =>
}
return array();
Linha 6 450 ⟶ 5 559:
FROM `glpi_tickets`
WHERE `entities_id` = '".$entity."'
AND `status` = '
AND `is_deleted` = 0";
if ($delay > 0) {
$query .= " AND ADDDATE(`solvedate`, INTERVAL ".$delay." DAY) < CURDATE()";
}
Linha 6 460 ⟶ 5 569:
foreach ($DB->request($query) as $tick) {
$ticket->update(array('id' => $tick['id'],
'status' =>
'_auto_update' => true));
$nb++;
Linha 6 492 ⟶ 5 601:
// Recherche des entités
$tot = 0;
foreach (Entity::getEntitiesToNotify('notclosed_delay') as $entity => $value) {
$query = "SELECT `glpi_tickets`.*
FROM `glpi_tickets`
WHERE `glpi_tickets`.`entities_id` = '".$entity."'
AND `glpi_tickets`.`is_deleted` = 0
AND `glpi_tickets`.`status` IN ('
'".self::ASSIGNED."',
'".self::PLANNED."',
'".self::WAITING."')
AND `glpi_tickets`.`closedate` IS NULL
AND ADDDATE(`glpi_tickets`.`date`, INTERVAL ".$value." DAY) <
$tickets = array();
foreach ($DB->request($query) as $tick) {
Linha 6 520 ⟶ 5 621:
array('items' => $tickets,
'entities_id' => $entity))) {
$tot += count($tickets);
$task->addVolume(count($tickets));
$task->log(
Dropdown::getDropdownName('glpi_entities', $entity),
count($tickets)));
}
}
Linha 6 561 ⟶ 5 645:
global $DB;
$conf = new
$inquest = new TicketSatisfaction();
$tot = 0;
$maxentity = array();
$tabentities = array();
$rate =
if ($rate > 0) {
$tabentities[0] = $rate;
}
foreach ($DB->request('glpi_entities') as $entity) {
$rate =
$parent =
if ($rate > 0) {
$tabentities[$entity['id']] = $rate;
}
Linha 6 582 ⟶ 5 666:
foreach ($tabentities as $entity => $rate) {
$parent =
$delay =
$type =
$max_closedate =
$query = "SELECT `glpi_tickets`.`id`,
Linha 6 595 ⟶ 5 679:
WHERE `glpi_tickets`.`entities_id` = '$entity'
AND `glpi_tickets`.`is_deleted` = 0
AND `glpi_tickets`.`status` = '
AND `glpi_tickets`.`closedate` > '$max_closedate'
AND ADDDATE(`glpi_tickets`.`closedate`, INTERVAL $delay DAY)<=NOW()
Linha 6 601 ⟶ 5 685:
ORDER BY `closedate` ASC";
$nb = 0;
$max_closedate = '';
Linha 6 618 ⟶ 5 702:
// conservation de toutes les max_closedate des entites filles
if (!empty($max_closedate)
&& (!isset($maxentity[$parent])
|| ($max_closedate > $maxentity[$parent]))) { $maxentity[$parent] = $max_closedate;
}
Linha 6 626 ⟶ 5 710:
$tot += $nb;
$task->addVolume($nb);
$task->log(
Dropdown::getDropdownName('glpi_entities', $entity), $nb));
}
}
Linha 6 634 ⟶ 5 719:
$conf->getFromDB($parent);
$conf->update(array('id' => $conf->fields['id'],
//'entities_id' => $parent,
'max_closedate' => $maxdate));
}
Linha 6 640 ⟶ 5 725:
return ($tot > 0);
}
Linha 6 650 ⟶ 5 732:
function showDebug() {
NotificationEvent::debugEvent($this);
}
/**
* @since version 0.85
*
* @see commonDBTM::getRights()
**/
function getRights($interface='central') {
$values = parent::getRights();
unset($values[READ]);
$values[self::READMY] = __('See my ticket');
//TRANS: short for : See tickets created by my groups
$values[self::READGROUP] = array('short' => __('See group ticket'),
'long' => __('See tickets created by my groups'));
if ($interface == 'central') {
$values[self::READALL] = __('See all tickets');
//TRANS: short for : See assigned tickets (group associated)
$values[self::READASSIGN] = array('short' => __('See assigned'),
'long' => __('See assigned tickets'));
//TRANS: short for : Assign a ticket
$values[self::ASSIGN] = array('short' => __('Assign'),
'long' => __('Assign a ticket'));
//TRANS: short for : Steal a ticket
$values[self::STEAL] = array('short' => __('Steal'),
'long' => __('Steal a ticket'));
//TRANS: short for : To be in charge of a ticket
$values[self::OWN] = array('short' => __('Beeing in charge'),
'long' => __('To be in charge of a ticket'));
$values[self::CHANGEPRIORITY] = __('Change the priority');
}
if ($interface == 'helpdesk') {
unset($values[UPDATE], $values[DELETE], $values[PURGE]);
}
return $values;
}
/**
* Add image pasted to GLPI doc after ADD and before UPDATE of the item in the database
*
* @since version 0.85
*
* @return nothing
**/
function addImagePaste() {
if (count($this->input['_stock_image']) > 0) {
$count_files = 0;
// Filename
if (isset($this->input['_filename'])) {
$count_files = count($this->input['_stock_image']);
foreach($this->input['_filename'] as $key => $filename){
$this->input['_filename'][$count_files] = $filename;
$count_files++;
}
$count_files = count($this->input['_stock_image']);
foreach($this->input['_tag_filename'] as $key => $tag){
$this->input['_tag'][$count_files] = $tag;
$count_files++;
}
unset($this->input['_tag_filename']);
}
// Stock_image
foreach ($this->input['_stock_image'] as $key => $filename) {
$this->input['_filename'][$key] = $filename;
}
unset($this->input['_stock_image']);
foreach($this->input['_tag_stock_image'] as $key => $tag){
$this->input['_tag'][$key] = $tag;
$count_files++;
}
unset($this->input['_tag_stock_image']);
ksort($this->input['_filename']);
ksort($this->input['_tag']);
// $this->input['_forcenotif'] = 1;
}
}
/**
* Convert tag to image
*
* @since version 0.85
*
* @param $content_text text content of input
* @param $force_update force update of content in item (false by default
* @param $doc_data array of filenames and tags
*
* @return nothing
**/
function convertTagToImage($content_text, $force_update=false, $doc_data=array()) {
global $CFG_GLPI;
$matches = array();
// If no doc data available we match all tags in content
if (!count($doc_data)) {
$doc = new Document();
preg_match_all('/'.Document::getImageTag('(([a-z0-9]+|[\.\-]?)+)').'/', $content_text,
$matches, PREG_PATTERN_ORDER);
if (isset($matches[1]) && count($matches[1])) {
$doc_data = $doc->find("`tag` IN('".implode("','", array_unique($matches[1]))."')");
}
}
if (count($doc_data)) {
foreach ($doc_data as $id => $image) {
// Add only image files : try to detect mime type
$ok = false;
$mime = '';
if (isset($image['filepath'])) {
$fullpath = GLPI_DOC_DIR."/".$image['filepath'];
if (function_exists('finfo_open')
&& ($finfo = finfo_open(FILEINFO_MIME))) {
$mime = finfo_file($finfo, $fullpath);
finfo_close($finfo);
} else if (function_exists('mime_content_type')) {
$mime = mime_content_type($fullpath);
}
switch (substr($mime, 0, strrpos($mime, ';'))) {
case 'image/gif':case 'image/jpg':case 'image/jpeg':case 'image/png' :
$ok = true;
break;
}
}
if (isset($image['tag'])
&& ($ok || empty($mime))) {
// Replace tags by image in textarea
$img = "<img alt='".$image['tag']."' src='".$CFG_GLPI['root_doc'].
"/front/document.send.php?docid=".$id."&tickets_id=".$this->fields['id']."'/>";
// Replace tag by the image
$content_text = preg_replace('/'.Document::getImageTag($image['tag']).'/',
Html::entities_deep($img), $content_text);
// Replace <br> TinyMce bug
$content_text = str_replace(array('>rn<','>\r\n<','>\r<','>\n<'),
'><', $content_text);
// If the tag is from another ticket : link document to ticket
/// TODO : comment maybe not used
// if($image['tickets_id'] != $this->fields['id']){
// $docitem = new Document_Item();
// $docitem->add(array('documents_id' => $image['id'],
// '_do_notif' => false,
// '_disablenotif' => true,
// 'itemtype' => $this->getType(),
// 'items_id' => $this->fields['id']));
// }
} else {
// Remove tag
$content_text = preg_replace('/'.Document::getImageTag($image['tag']).'/',
'', $content_text);
}
}
}
if ($force_update) {
$this->fields['content'] = $content_text;
$this->updateInDB(array('content'));
}
return $content_text;
}
/**
* Convert image to tag
*
* @since version 0.85
*
* @param $content_html html content of input
* @param $force_update force update of content in item (false by default
*
* @return htlm content
**/
function convertImageToTag($content_html, $force_update=false) {
$html = str_replace('&', '&', $content_html);
if (!empty($html)) {
// We parse HTML with dom
libxml_use_internal_errors(true);
$dom = new DOMDocument();
$dom->loadHTML($html);
$dom->preserveWhiteSpace = false;
// We replace each html element by its tag
$htmlTags = array('img', 'object');
foreach ($htmlTags as $htmlTag) {
$nodes = $dom->getElementsByTagName($htmlTag);
$nodeListLength = $nodes->length;
// If config display image
for ($i = 0; $i < $nodeListLength; $i ++) {
$node = $nodes->item(0);
if ($node->getAttribute('alt')) {
$tag = $dom->createTextNode(Document::getImageTag($node->getAttribute('alt')));
}
$p = $dom->createElement('p');
$p->appendChild($tag);
$node->parentNode->replaceChild($p, $node);
}
}
// Get only body content
$doc = new DOMDocument();
$body = $dom->getElementsByTagName('body')->item(0);
foreach ($body->childNodes as $child)
$doc->appendChild($doc->importNode($child, true));
if ($force_update) {
$this->fields['content'] = utf8_decode(Html::entity_decode_deep($doc->saveHTML()));
$this->updateInDB(array('content'));
}
return utf8_decode(Html::entity_decode_deep($doc->saveHTML()));
}
}
/**
* Convert img of the collector for ticket
*
* @since version 0.85
*
* @param $content_html html content of input
* @param $files array of filename
* @param $tags array of image tag
*
* @return htlm content
**/
static function convertContentForTicket($content_html, $files, $tags) {
// We inject another meta tag
$contentType = '<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>';
$html = str_replace('<head>', '<head>'.$contentType, Html::entity_decode_deep($content_html));
// We parse HTML with dom
libxml_use_internal_errors(true);
$dom = new DOMDocument();
$dom->loadHTML($html);
$dom->preserveWhiteSpace = false;
// We replace each img by a compatible tag for tickets
$nodes = $dom->getElementsByTagName('img');
$nodeListLength = $nodes->length;
// If config display image
for ($i = 0; $i < $nodeListLength; $i ++) {
$node = $nodes->item(0);
$src = $node->getAttribute('src');
foreach ($files as $id => $data) {
if (preg_match("/".$data."/i", $src)) {
$p = $dom->createElement('p');
$tag = $dom->createTextNode(Document::getImageTag($tags[$id]));
$p->appendChild($tag);
$node->parentNode->replaceChild($p, $node);
}
}
}
// Get only body content
$doc = new DOMDocument();
$body = $dom->getElementsByTagName('body')->item(0);
foreach ($body->childNodes as $child)
$doc->appendChild($doc->importNode($child, true));
return Html::entity_decode_deep($doc->saveHTML());
}
/**
* Convert img or tag of ticket for notification mails
*
* @since version 0.85
*
* @param $content : html content of input
* @param $item : item to store filenames and tags found for each image in $content
*
* @return htlm content
**/
function convertContentForNotification($content, $item) {
global $CFG_GLPI, $DB;
$tag = '';
$html = str_replace(array('&','&nbsp;'), array('&',' '),
html_entity_decode($content, ENT_QUOTES, "ISO-8859-1"));
// If is html content
if ($CFG_GLPI["use_rich_text"]) {
// We parse HTML with dom
libxml_use_internal_errors(true);
$dom = new DOMDocument();
$dom->loadHTML($html);
$dom->preserveWhiteSpace = false;
// We replace each img by compatible embeded img for mail
$nodes = $dom->getElementsByTagName('img');
$nodeListLength = $nodes->length;
// If config display image
for ($i = 0; $i < $nodeListLength; $i++) {
$node = $nodes->item($i);
if ($node->getAttribute('alt')) {
$tag = Document::getImageTag($node->getAttribute('alt'));
$img = $dom->createElement('img');
$img->setAttribute('src', 'cid:'.$tag);
$node->parentNode->replaceChild($img, $node);
}
}
$content = $dom->saveHTML();
// If is text content
} else {
$doc = new Document();
$doc_data = array();
preg_match_all('/'.Document::getImageTag('(([a-z0-9]+|[\.\-]?)+)').'/', $content,
$matches, PREG_PATTERN_ORDER);
if (isset($matches[1]) && count($matches[1])) {
$doc_data = $doc->find("tag IN('".implode("','", array_unique($matches[1]))."')");
}
if (count($doc_data)) {
foreach ($doc_data as $image) {
// Replace tags by image in textarea
$img = "<img src='cid:".Document::getImageTag($image['tag'])."'/>";
// Replace tag by the image
$content = preg_replace('/'.Document::getImageTag($image['tag']).'/', $img,
$content);
}
}
}
// Get all attached documents of ticket
$query = "SELECT `glpi_documents_items`.`id` AS assocID,
`glpi_entities`.`id` AS entity,
`glpi_documents`.`name` AS assocName,
`glpi_documents`.*
FROM `glpi_documents_items`
LEFT JOIN `glpi_documents`
ON (`glpi_documents_items`.`documents_id`=`glpi_documents`.`id`)
LEFT JOIN `glpi_entities`
ON (`glpi_documents`.`entities_id`=`glpi_entities`.`id`)
WHERE `glpi_documents_items`.`items_id` = '".$item->fields['id']."'
AND `glpi_documents_items`.`itemtype` = '".$item->getType()."' ";
$query .= getEntitiesRestrictRequest(" AND","glpi_documents",'','',true);
$result = $DB->query($query);
if ($DB->numrows($result)) {
while ($data = $DB->fetch_assoc($result)) {
if (!empty($data['id'])) {
// Image document
if (!empty($data['tag'])) {
$item->documents[] = $data['id'];
// Other document
} else if ($CFG_GLPI['attach_ticket_documents_to_mail']) {
$item->documents[] = $data['id'];
}
}
}
}
return $content;
}
/**
* Delete tag or image from ticket content
*
* @since version 0.85
*
* @param $content html content of input
* @param $tags
*
* @return htlm content
**/
function cleanTagOrImage($content, $tags){
global $CFG_GLPI;
// RICH TEXT : delete img tag
if ($CFG_GLPI["use_rich_text"]) {
$html = str_replace(array('&','&nbsp;'), array('&',' '),
html_entity_decode($content, ENT_QUOTES, "ISO-8859-1"));
// We parse HTML with dom
libxml_use_internal_errors(true);
$dom = new DOMDocument();
$dom->loadHTML('<html>'.$html.'</html>');
$dom->preserveWhiteSpace = false;
// We replace each <img> by a <p>
$nodes = $dom->getElementsByTagName('img');
$nodeListLength = $nodes->length;
$nodesToDelete = array();
for ($i=0 ; $i<$nodeListLength ; $i++) {
$node = $nodes->item($i);
if ($id = $node->getAttribute('alt')) {
foreach ($tags as $tag) {
if (preg_match("/".$tag."/i", $id)) {
$nodesToDelete[] = $node;
}
}
}
}
foreach($nodesToDelete as $node){
$p = $dom->createElement('p');
$node->parentNode->replaceChild($p, $node);
}
// Get only body content
$doc = new DOMDocument();
$body = $dom->getElementsByTagName('body')->item(0);
foreach ($body->childNodes as $child)
$doc->appendChild($doc->importNode($child, true));
return utf8_decode(Html::entity_decode_deep($doc->saveHTML()));
// SIMPLE TEXT : delete tag
} else {
foreach ($tags as $tag) {
$content = preg_replace('/'.Document::getImageTag($tag).'/', '\r\n', $content);
}
return $content;
}
}
/**
* Convert rich text content to simple text content
*
* @since version 0.85
*
* @param $content : content to convert in html
*
* @return $content
**/
function setSimpleTextContent($content) {
$content = Html::entity_decode_deep($content);
// If is html content
if ($content != strip_tags($content)) {
$content = Html::clean($this->convertImageToTag($content));
}
return $content;
}
/**
* Convert simple text content to rich text content, init html editor
*
* @since version 0.85
*
* @param $name name of textarea
* @param $content content to convert in html
* @param $rand
*
* @return $content
**/
function setRichTextContent($name, $content, $rand) {
$content = Html::entity_decode_deep($content);
// Init html editor
Html::initEditorSystem($name, $rand);
// If no html
if ($content == strip_tags($content)) {
$content = $this->convertTagToImage($content);
}
// If content does not contain <br> or <p> html tag, use nl2br
$content = Html::entity_decode_deep($content);
if (!preg_match("/<br\s?\/?>/", $content) && !preg_match("/<p>/", $content)) {
$content = nl2br($content);
}
return $content;
}
| |||