.
* ---------------------------------------------------------------------
*/
if (!defined('GLPI_ROOT')) {
die("Sorry. You can't access this file directly");
}
class Problem_Ticket extends CommonDBRelation{
// From CommonDBRelation
static public $itemtype_1 = 'Problem';
static public $items_id_1 = 'problems_id';
static public $itemtype_2 = 'Ticket';
static public $items_id_2 = 'tickets_id';
/**
* @since 0.84
**/
function getForbiddenStandardMassiveAction() {
$forbidden = parent::getForbiddenStandardMassiveAction();
$forbidden[] = 'update';
return $forbidden;
}
static function getTypeName($nb = 0) {
return _n('Link Ticket/Problem', 'Links Ticket/Problem', $nb);
}
/**
* @see CommonGLPI::getTabNameForItem()
**/
function getTabNameForItem(CommonGLPI $item, $withtemplate = 0) {
if (static::canView()) {
$nb = 0;
switch ($item->getType()) {
case 'Ticket' :
if ($_SESSION['glpishow_count_on_tabs']) {
$problems = self::getTicketProblemsData($item->getID());
$nb = count($problems);
}
return self::createTabEntry(Problem::getTypeName(Session::getPluralNumber()), $nb);
case 'Problem' :
if ($_SESSION['glpishow_count_on_tabs']) {
$tickets = self::getProblemTicketsData($item->getID());
$nb = count($tickets);
}
return self::createTabEntry(Ticket::getTypeName(Session::getPluralNumber()), $nb);
}
}
return '';
}
static function displayTabContentForItem(CommonGLPI $item, $tabnum = 1, $withtemplate = 0) {
switch ($item->getType()) {
case 'Ticket' :
self::showForTicket($item);
break;
case 'Problem' :
self::showForProblem($item);
break;
}
return true;
}
/**
* @since 0.84
**/
function post_addItem() {
global $CFG_GLPI;
$donotif = !isset($this->input['_disablenotif']) && $CFG_GLPI["use_notifications"];
if ($donotif) {
$problem = new Problem();
if ($problem->getFromDB($this->input["problems_id"])) {
$options = [];
NotificationEvent::raiseEvent("new", $problem, $options);
}
}
parent::post_addItem();
}
/**
* @since 0.84
**/
function post_deleteFromDB() {
global $CFG_GLPI;
$donotif = !isset($this->input['_disablenotif']) && $CFG_GLPI["use_notifications"];
if ($donotif) {
$problem = new Problem();
if ($problem->getFromDB($this->fields["problems_id"])) {
$options = [];
NotificationEvent::raiseEvent("delete", $problem, $options);
}
}
parent::post_deleteFromDB();
}
/**
* @since 0.85
*
* @see CommonDBTM::showMassiveActionsSubForm()
**/
static function showMassiveActionsSubForm(MassiveAction $ma) {
switch ($ma->getAction()) {
case 'add_task' :
$tasktype = 'TicketTask';
if ($ttype = getItemForItemtype($tasktype)) {
$ttype->showMassiveActionAddTaskForm();
return true;
}
return false;
case "solveticket" :
$problem = new Problem();
$input = $ma->getInput();
if (isset($input['problems_id']) && $problem->getFromDB($input['problems_id'])) {
$problem->showMassiveSolutionForm($problem);
echo "
";
echo Html::submit(_x('button', 'Post'), ['name' => 'massiveaction']);
return true;
}
return false;
}
return parent::showMassiveActionsSubForm($ma);
}
/**
* @since 0.85
*
* @see CommonDBTM::processMassiveActionsForOneItemtype()
**/
static function processMassiveActionsForOneItemtype(MassiveAction $ma, CommonDBTM $item,
array $ids) {
switch ($ma->getAction()) {
case 'add_task' :
if (!($task = getItemForItemtype('TicketTask'))) {
$ma->itemDone($item->getType(), $ids, MassiveAction::ACTION_KO);
break;
}
$ticket = new Ticket();
$field = $ticket->getForeignKeyField();
$input = $ma->getInput();
foreach ($ids as $id) {
if ($item->can($id, READ)) {
if ($ticket->getFromDB($item->fields['tickets_id'])) {
$input2 = [$field => $item->fields['tickets_id'],
'taskcategories_id' => $input['taskcategories_id'],
'actiontime' => $input['actiontime'],
'content' => $input['content']];
if ($task->can(-1, CREATE, $input2)) {
if ($task->add($input2)) {
$ma->itemDone($item->getType(), $id, MassiveAction::ACTION_OK);
} else {
$ma->itemDone($item->getType(), $id, MassiveAction::ACTION_KO);
$ma->addMessage($item->getErrorMessage(ERROR_ON_ACTION));
}
} else {
$ma->itemDone($item->getType(), $id, MassiveAction::ACTION_NORIGHT);
$ma->addMessage($item->getErrorMessage(ERROR_RIGHT));
}
} else {
$ma->itemDone($item->getType(), $id, MassiveAction::ACTION_NORIGHT);
$ma->addMessage($item->getErrorMessage(ERROR_RIGHT));
}
}
}
return;
case 'solveticket' :
$input = $ma->getInput();
$ticket = new Ticket();
foreach ($ids as $id) {
if ($item->can($id, READ)) {
if ($ticket->getFromDB($item->fields['tickets_id'])
&& $ticket->canSolve()) {
$solution = new ITILSolution();
$added = $solution->add([
'itemtype' => $ticket->getType(),
'items_id' => $ticket->getID(),
'solutiontypes_id' => $input['solutiontypes_id'],
'content' => $input['content']
]);
if ($added) {
$ma->itemDone($item->getType(), $id, MassiveAction::ACTION_OK);
} else {
$ma->itemDone($item->getType(), $id, MassiveAction::ACTION_KO);
$ma->addMessage($ticket->getErrorMessage(ERROR_ON_ACTION));
}
} else {
$ma->itemDone($item->getType(), $id, MassiveAction::ACTION_NORIGHT);
$ma->addMessage($ticket->getErrorMessage(ERROR_RIGHT));
}
} else {
$ma->itemDone($item->getType(), $id, MassiveAction::ACTION_NORIGHT);
$ma->addMessage($ticket->getErrorMessage(ERROR_RIGHT));
}
}
return;
}
parent::processMassiveActionsForOneItemtype($ma, $item, $ids);
}
/**
* Show tickets for a problem
*
* @param $problem Problem object
**/
static function showForProblem(Problem $problem) {
$ID = $problem->getField('id');
if (!static::canView() || !$problem->can($ID, READ)) {
return false;
}
$canedit = $problem->canEdit($ID);
$rand = mt_rand();
$tickets = self::getProblemTicketsData($ID);
$used = [];
$numrows = count($tickets);
foreach ($tickets as $ticket) {
$used[$ticket['id']] = $ticket['id'];
}
if ($canedit
&& !in_array($problem->fields['status'], array_merge($problem->getClosedStatusArray(),
$problem->getSolvedStatusArray()))) {
echo "
";
}
echo "";
if ($canedit && $numrows) {
Html::openMassiveActionsForm('mass'.__CLASS__.$rand);
$massiveactionparams = ['num_displayed' => min($_SESSION['glpilist_limit'], $numrows),
'container' => 'mass'.__CLASS__.$rand,
'specific_actions' => ['purge'
=> _x('button',
'Delete permanently'),
__CLASS__.MassiveAction::CLASS_ACTION_SEPARATOR.'solveticket'
=> __('Solve tickets'),
__CLASS__.MassiveAction::CLASS_ACTION_SEPARATOR.'add_task'
=> __('Add a new task')],
'extraparams' => ['problems_id' => $problem->getID()],
'width' => 1000,
'height' => 500];
Html::showMassiveActions($massiveactionparams);
}
echo "
";
echo "| ".Ticket::getTypeName($numrows)." | ";
echo "
";
if ($numrows) {
Ticket::commonListHeader(Search::HTML_OUTPUT, 'mass'.__CLASS__.$rand);
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'), Problem::getTypeName(1),
$problem->fields["name"]));
$i = 0;
foreach ($tickets as $data) {
Session::addToNavigateListItems('Ticket', $data["id"]);
Ticket::showShort($data['id'], ['followups' => false,
'row_num' => $i,
'type_for_massiveaction' => __CLASS__,
'id_for_massiveaction' => $data['linkid']]);
$i++;
}
Ticket::commonListHeader(Search::HTML_OUTPUT, 'mass'.__CLASS__.$rand);
}
echo "
";
if ($canedit && $numrows) {
$massiveactionparams['ontop'] = false;
Html::showMassiveActions($massiveactionparams);
Html::closeForm();
}
echo "
";
}
/**
* Show problems for a ticket
*
* @param $ticket Ticket object
**/
static function showForTicket(Ticket $ticket) {
$ID = $ticket->getField('id');
if (!static::canView() || !$ticket->can($ID, READ)) {
return false;
}
$canedit = $ticket->can($ID, UPDATE);
$rand = mt_rand();
$problems = self::getTicketProblemsData($ID);
$used = [];
$numrows = count($problems);
foreach ($problems as $problem) {
$used[$problem['id']] = $problem['id'];
}
if ($canedit
&& !in_array($ticket->fields['status'], array_merge($ticket->getClosedStatusArray(),
$ticket->getSolvedStatusArray()))) {
echo "";
}
echo "";
if ($canedit && $numrows) {
Html::openMassiveActionsForm('mass'.__CLASS__.$rand);
$massiveactionparams = ['num_displayed' => min($_SESSION['glpilist_limit'], $numrows),
'container' => 'mass'.__CLASS__.$rand];
Html::showMassiveActions($massiveactionparams);
}
echo "
";
echo "| ".Problem::getTypeName($numrows)." | ";
echo "
";
if ($numrows) {
Problem::commonListHeader(Search::HTML_OUTPUT, 'mass'.__CLASS__.$rand);
Session::initNavigateListItems('Problem',
//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'),
Ticket::getTypeName(1), $ticket->fields["name"]));
$i = 0;
foreach ($problems as $data) {
Session::addToNavigateListItems('Problem', $data["id"]);
Problem::showShort($data['id'], ['row_num' => $i,
'type_for_massiveaction' => __CLASS__,
'id_for_massiveaction' => $data['linkid']]);
$i++;
}
Problem::commonListHeader(Search::HTML_OUTPUT, 'mass'.__CLASS__.$rand);
}
echo "
";
if ($canedit && $numrows) {
$massiveactionparams['ontop'] = false;
Html::showMassiveActions($massiveactionparams);
Html::closeForm();
}
echo "
";
}
/**
* Returns problems data for given ticket.
* Returned data is usable by `Problem::showShort()` method.
*
* @param integer $tickets_id
*
* @return array
*/
private static function getTicketProblemsData($tickets_id) {
$ticket = new Ticket();
$ticket->fields['id'] = $tickets_id;
$iterator = self::getListForItem($ticket);
$problems = [];
foreach ($iterator as $data) {
$problem = new Problem();
$problem->getFromDB($data['id']);
if ($problem->canViewItem()) {
$problems[$data['id']] = $data;
}
}
return $problems;
}
/**
* Returns tickets data for given problem.
* Returned data is usable by `Ticket::showShort()` method.
*
* @param integer $problems_id
*
* @return array
*/
private static function getProblemTicketsData($problems_id) {
$problem = new Problem();
$problem->fields['id'] = $problems_id;
$iterator = self::getListForItem($problem);
$tickets = [];
foreach ($iterator as $data) {
$ticket = new Ticket();
$ticket->getFromDB($data['id']);
if ($ticket->canViewItem()) {
$tickets[$data['id']] = $data;
}
}
return $tickets;
}
}