";
}
}
/**
* Get problems count
*
* @since version 0.84
*
* @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 (!static::canView()) {
return false;
}
if (!Session::haveRight(self::$rightname, self::READALL)) {
$foruser = true;
}
$query = "SELECT `status`,
COUNT(*) AS COUNT
FROM `glpi_problems` ";
if ($foruser) {
$query .= " LEFT JOIN `glpi_problems_users`
ON (`glpi_problems`.`id` = `glpi_problems_users`.`problems_id`
AND `glpi_problems_users`.`type` = '".CommonITILActor::REQUESTER."')";
if (isset($_SESSION["glpigroups"])
&& count($_SESSION["glpigroups"])) {
$query .= " LEFT JOIN `glpi_groups_problems`
ON (`glpi_problems`.`id` = `glpi_groups_problems`.`problems_id`
AND `glpi_groups_problems`.`type` = '".CommonITILActor::REQUESTER."')";
}
}
$query .= getEntitiesRestrictRequest("WHERE", "glpi_problems");
if ($foruser) {
$query .= " AND (`glpi_problems_users`.`users_id` = '".Session::getLoginUserID()."' ";
if (isset($_SESSION["glpigroups"])
&& count($_SESSION["glpigroups"])) {
$groups = implode(",",$_SESSION['glpigroups']);
$query .= " OR `glpi_groups_problems`.`groups_id` IN (".$groups.") ";
}
$query.= ")";
}
$query_deleted = $query;
$query .= " AND NOT `glpi_problems`.`is_deleted`
GROUP BY `status`";
$query_deleted .= " AND `glpi_problems`.`is_deleted`
GROUP BY `status`";
$result = $DB->query($query);
$result_deleted = $DB->query($query_deleted);
$status = array();
foreach (self::getAllStatusArray() as $key => $val) {
$status[$key] = 0;
}
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['criteria'][0]['searchtype'] = 'equals';
$options['criteria'][0]['value'] = 'process';
$options['criteria'][0]['link'] = 'AND';
$options['reset'] ='reset';
echo "
";
}
/**
* @since version 0.84
*
* @param $ID
* @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
// Should be called in a
-segment
// Print links or not in case of user view
// Make new job object and fill it from database, if success, print it
$viewusers = User::canView();
$problem = new self();
$rand = mt_rand();
if ($problem->getFromDBwithData($ID, 0)) {
$bgcolor = $_SESSION["glpipriority_".$problem->fields["priority"]];
// $rand = mt_rand();
echo "
";
// Only change during creation OR when allowed to change priority OR when user is the creator
$idurgency = self::dropdownUrgency(array('value' => $this->fields["urgency"]));
echo "
";
if ($tree) {
$restrict = "IN (".implode(',', getSonsOf('glpi_groups', $item->getID())).")";
} else {
$restrict = "='".$item->getID()."'";
}
$restrict = "(`glpi_groups_problems`.`groups_id` $restrict)";
$order = '`glpi_problems`.`date_mod` DESC';
$options['criteria'][0]['field'] = 71;
$options['criteria'][0]['searchtype'] = ($tree ? 'under' : 'equals');
$options['criteria'][0]['value'] = $item->getID();
$options['criteria'][0]['link'] = 'AND';
break;
default :
$restrict = "(`items_id` = '".$item->getID()."'
AND `itemtype` = '".$item->getType()."')";
$order = '`glpi_problems`.`date_mod` DESC';
break;
}
$query = "SELECT ".self::getCommonSelect()."
FROM `glpi_problems`
LEFT JOIN `glpi_items_problems`
ON (`glpi_problems`.`id` = `glpi_items_problems`.`problems_id`) ".
self::getCommonLeftJoin()."
WHERE $restrict ".
getEntitiesRestrictRequest("AND","glpi_problems")."
ORDER BY $order
LIMIT ".intval($_SESSION['glpilist_limit']);
$result = $DB->query($query);
$number = $DB->numrows($result);
// Ticket for the item
echo "
";
$colspan = 11;
if (count($_SESSION["glpiactiveentities"]) > 1) {
$colspan++;
}
if ($number > 0) {
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'), $item->getTypeName(1),
$item->getName()));
echo "
";
//TRANS : %d is the number of problems
echo sprintf(_n('Last %d problem','Last %d problems',$number), $number);
// echo "".__('Show all')."";
echo "
";
} else {
echo "
".__('No problem found.')."
";
}
// Ticket list
if ($number > 0) {
self::commonListHeader(Search::HTML_OUTPUT);
while ($data = $DB->fetch_assoc($result)) {
Session::addToNavigateListItems('Problem', $data["id"]);
self::showShort($data["id"]);
}
self::commonListHeader(Search::HTML_OUTPUT);
}
echo "
";
// Tickets for linked items
$linkeditems = $item->getLinkedItems();
$restrict = array();
if (count($linkeditems)) {
foreach ($linkeditems as $ltype => $tab) {
foreach ($tab as $lID) {
$restrict[] = "(`itemtype` = '$ltype' AND `items_id` = '$lID')";
}
}
}
if (count($restrict)) {
$query = "SELECT ".self::getCommonSelect()."
FROM `glpi_problems`
LEFT JOIN `glpi_items_problems`
ON (`glpi_problems`.`id` = `glpi_items_problems`.`problems_id`) ".
self::getCommonLeftJoin()."
WHERE ".implode(' OR ', $restrict).
getEntitiesRestrictRequest(' AND ', 'glpi_problems') . "
ORDER BY `glpi_problems`.`date_mod` DESC
LIMIT ".intval($_SESSION['glpilist_limit']);
$result = $DB->query($query);
$number = $DB->numrows($result);
echo "