|
Server : Apache System : Linux vps.urbanovitalino.adv.br 3.10.0-1062.12.1.el7.x86_64 #1 SMP Tue Feb 4 23:02:59 UTC 2020 x86_64 User : urbanovitalinoad ( 1001) PHP Version : 7.3.33 Disable Function : exec,passthru,shell_exec,system Directory : /home/urbanovitalinoad/public_html/servicedesk/inc/ |
Upload File : |
<?php
/**
* ---------------------------------------------------------------------
* GLPI - Gestionnaire Libre de Parc Informatique
* Copyright (C) 2015-2021 Teclib' and contributors.
*
* http://glpi-project.org
*
* based on GLPI - Gestionnaire Libre de Parc Informatique
* Copyright (C) 2003-2014 by the INDEPNET Development Team.
*
* ---------------------------------------------------------------------
*
* LICENSE
*
* This file is part of GLPI.
*
* GLPI is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
* GLPI is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with GLPI. If not, see <http://www.gnu.org/licenses/>.
* ---------------------------------------------------------------------
*/
if (!defined('GLPI_ROOT')) {
die("Sorry. You can't access this file directly");
}
/**
* Budget class
*/
class Budget extends CommonDropdown{
use Glpi\Features\Clonable;
// From CommonDBTM
public $dohistory = true;
static $rightname = 'budget';
protected $usenotepad = true;
public $can_be_translated = false;
public function getCloneRelations() :array {
return [
Document_Item::class
];
}
static function getTypeName($nb = 0) {
return _n('Budget', 'Budgets', $nb);
}
function defineTabs($options = []) {
$ong = [];
$this->addDefaultFormTab($ong);
$this->addStandardTab(__CLASS__, $ong, $options);
$this->addStandardTab('Document_Item', $ong, $options);
$this->addStandardTab('KnowbaseItem_Item', $ong, $options);
$this->addStandardTab('Link', $ong, $options);
$this->addStandardTab('Notepad', $ong, $options);
$this->addStandardTab('Log', $ong, $options);
return $ong;
}
function getTabNameForItem(CommonGLPI $item, $withtemplate = 0) {
if (!$withtemplate) {
switch ($item->getType()) {
case __CLASS__ :
return [1 => __('Main'),
2 => _n('Item', 'Items', Session::getPluralNumber())];
}
}
return '';
}
static function displayTabContentForItem(CommonGLPI $item, $tabnum = 1, $withtemplate = 0) {
if ($item->getType() == __CLASS__) {
switch ($tabnum) {
case 1 :
$item->showValuesByEntity();
break;
case 2 :
$item->showItems();
break;
}
}
return true;
}
/**
* Print the contact form
*
* @param integer $ID Integer ID of the item
* @param array $options Array of possible options:
* - target for the Form
* - withtemplate : template or basic item
*
* @return void|boolean (display) Returns false if there is a rights error.
**/
function showForm($ID, $options = []) {
$rowspan = 3;
if ($ID > 0) {
$rowspan++;
}
$this->initForm($ID, $options);
$this->showFormHeader($options);
echo "<tr class='tab_bg_1'>";
echo "<td>".__('Name')."</td>";
echo "<td>";
Html::autocompletionTextField($this, "name");
echo "</td>";
echo "<td>"._n('Type', 'Types', 1)."</td>";
echo "<td>";
Dropdown::show('BudgetType', ['value' => $this->fields['budgettypes_id']]);
echo "</td></tr>";
echo "<tr class='tab_bg_1'>";
echo "<td>"._x('price', 'Value')."</td>";
echo "<td><input type='text' name='value' size='14'
value='".Html::formatNumber($this->fields["value"], true)."'></td>";
echo "<td rowspan='$rowspan' class='middle right'>".__('Comments')."</td>";
echo "<td class='center middle' rowspan='$rowspan'>".
"<textarea cols='45' rows='4' name='comment' >".$this->fields["comment"]."</textarea>".
"</td></tr>";
echo "<tr class='tab_bg_1'>";
echo "<td>".__('Start date')."</td>";
echo "<td>";
Html::showDateField("begin_date", ['value' => $this->fields["begin_date"]]);
echo "</td></tr>";
echo "<tr class='tab_bg_1'>";
echo "<td>".__('End date')."</td>";
echo "<td>";
Html::showDateField("end_date", ['value' => $this->fields["end_date"]]);
echo "</td></tr>";
echo "<tr class='tab_bg_1'>";
echo "<td>".Location::getTypeName(1)."</td>";
echo "<td>";
Location::dropdown(['value' => $this->fields["locations_id"],
'entity' => $this->fields["entities_id"]]);
echo "</td><td colspan='2'></td></tr>";
$this->showFormButtons($options);
return true;
}
function prepareInputForAdd($input) {
if (isset($input["id"]) && ($input["id"] > 0)) {
$input["_oldID"] = $input["id"];
}
unset($input['id']);
unset($input['withtemplate']);
return $input;
}
function rawSearchOptions() {
$tab = [];
$tab[] = [
'id' => 'common',
'name' => __('Characteristics')
];
$tab[] = [
'id' => '1',
'table' => $this->getTable(),
'field' => 'name',
'name' => __('Name'),
'datatype' => 'itemlink',
'massiveaction' => false,
'autocomplete' => true,
];
$tab[] = [
'id' => '2',
'table' => $this->getTable(),
'field' => 'id',
'name' => __('ID'),
'massiveaction' => false,
'datatype' => 'number'
];
$tab[] = [
'id' => '19',
'table' => $this->getTable(),
'field' => 'date_mod',
'name' => __('Last update'),
'datatype' => 'datetime',
'massiveaction' => false
];
$tab[] = [
'id' => '121',
'table' => $this->getTable(),
'field' => 'date_creation',
'name' => __('Creation date'),
'datatype' => 'datetime',
'massiveaction' => false
];
$tab[] = [
'id' => '4',
'table' => 'glpi_budgettypes',
'field' => 'name',
'name' => _n('Type', 'Types', 1),
'datatype' => 'dropdown'
];
$tab[] = [
'id' => '5',
'table' => $this->getTable(),
'field' => 'begin_date',
'name' => __('Start date'),
'datatype' => 'date'
];
$tab[] = [
'id' => '6',
'table' => $this->getTable(),
'field' => 'end_date',
'name' => __('End date'),
'datatype' => 'date'
];
$tab[] = [
'id' => '7',
'table' => $this->getTable(),
'field' => 'value',
'name' => _x('price', 'Value'),
'datatype' => 'decimal'
];
$tab[] = [
'id' => '16',
'table' => $this->getTable(),
'field' => 'comment',
'name' => __('Comments'),
'datatype' => 'text'
];
$tab[] = [
'id' => '50',
'table' => $this->getTable(),
'field' => 'template_name',
'name' => __('Template name'),
'datatype' => 'text',
'massiveaction' => false,
'nosearch' => true,
'nodisplay' => true,
'autocomplete' => true,
];
$tab[] = [
'id' => '80',
'table' => 'glpi_entities',
'field' => 'completename',
'name' => Entity::getTypeName(1),
'massiveaction' => false,
'datatype' => 'dropdown'
];
$tab[] = [
'id' => '86',
'table' => $this->getTable(),
'field' => 'is_recursive',
'name' => __('Child entities'),
'datatype' => 'bool'
];
// add objectlock search options
$tab = array_merge($tab, ObjectLock::rawSearchOptionsToAdd(get_class($this)));
$tab = array_merge($tab, Location::rawSearchOptionsToAdd());
$tab = array_merge($tab, Notepad::rawSearchOptionsToAdd());
return $tab;
}
/**
* Print the HTML array of Items on a budget
*
* @return void
**/
function showItems() {
global $DB;
$budgets_id = $this->fields['id'];
if (!$this->can($budgets_id, READ)) {
return false;
}
$iterator = $DB->request([
'SELECT' => 'itemtype',
'DISTINCT' => true,
'FROM' => 'glpi_infocoms',
'WHERE' => [
'budgets_id' => $budgets_id,
'NOT' => ['itemtype' => ['ConsumableItem', 'CartridgeItem', 'Software']]
],
'ORDER' => 'itemtype'
]);
$number = count($iterator);
echo "<div class='spaced'><table class='tab_cadre_fixe'>";
echo "<tr><th colspan='2'>";
Html::printPagerForm();
echo "</th><th colspan='4'>";
if ($number == 0) {
echo __('No associated item');
} else {
echo _n('Associated item', 'Associated items', $number);
}
echo "</th></tr>";
echo "<tr><th>"._n('Type', 'Types', 1)."</th>";
echo "<th>".Entity::getTypeName(1)."</th>";
echo "<th>".__('Name')."</th>";
echo "<th>".__('Serial number')."</th>";
echo "<th>".__('Inventory number')."</th>";
echo "<th>"._x('price', 'Value')."</th>";
echo "</tr>";
$num = 0;
$itemtypes = [];
while ($row = $iterator->next()) {
$itemtypes[] = $row['itemtype'];
}
$itemtypes[] = 'Contract';
$itemtypes[] = 'Ticket';
$itemtypes[] = 'Problem';
$itemtypes[] = 'Change';
$itemtypes[] = 'Project';
foreach ($itemtypes as $itemtype) {
if (!($item = getItemForItemtype($itemtype))) {
continue;
}
if ($item->canView()) {
switch ($itemtype) {
case 'Contract' :
$criteria = [
'SELECT' => [
$item->getTable() . '.id',
$item->getTable() . '.entities_id',
'SUM' => 'glpi_contractcosts.cost AS value'
],
'FROM' => 'glpi_contractcosts',
'INNER JOIN' => [
$item->getTable() => [
'ON' => [
$item->getTable() => 'id',
'glpi_contractcosts' => 'contracts_id'
]
]
],
'WHERE' => [
'glpi_contractcosts.budgets_id' => $budgets_id,
$item->getTable() . '.is_template' => 0
] + getEntitiesRestrictCriteria($item->getTable()),
'GROUPBY' => [
$item->getTable() . '.id',
$item->getTable() . '.entities_id'
],
'ORDERBY' => [
$item->getTable() . '.entities_id',
$item->getTable() . '.name'
]
];
break;
case 'Ticket' :
case 'Problem' :
case 'Change' :
$costtable = getTableForItemType($item->getType().'Cost');
$sum = new QueryExpression(
"SUM(" . $DB->quoteName("$costtable.actiontime") . " * " . $DB->quoteName("$costtable.cost_time") . "/".HOUR_TIMESTAMP."
+ " . $DB->quoteName("$costtable.cost_fixed") . "
+ " . $DB->quoteName("$costtable.cost_material") . ") AS " . $DB->quoteName('value')
);
$criteria = [
'SELECT' => [
$item->getTable() . '.id',
$item->getTable() . '.entities_id',
$sum
],
'FROM' => $costtable,
'INNER JOIN' => [
$item->getTable() => [
'ON' => [
$item->getTable() => 'id',
$costtable => $item->getForeignKeyField()
]
]
],
'WHERE' => [
$costtable . '.budgets_id' => $budgets_id
] + getEntitiesRestrictCriteria($item->getTable()),
'GROUPBY' => [
$item->getTable() . '.id',
$item->getTable() . '.entities_id'
],
'ORDERBY' => [
$item->getTable() . '.entities_id',
$item->getTable() . '.name'
]
];
break;
case 'Project' :
$criteria = [
'SELECT' => [
$item->getTable() . '.id',
$item->getTable() . '.entities_id',
'SUM' => 'glpi_projectcosts.cost AS value'
],
'FROM' => 'glpi_projectcosts',
'INNER JOIN' => [
$item->getTable() => [
'ON' => [
$item->getTable() => 'id',
'glpi_projectcosts' => 'projects_id'
]
]
],
'WHERE' => [
'glpi_projectcosts.budgets_id' => $budgets_id
] + getEntitiesRestrictCriteria($item->getTable()),
'GROUPBY' => [
$item->getTable() . '.id',
$item->getTable() . '.entities_id'
],
'ORDERBY' => [
$item->getTable() . '.entities_id',
$item->getTable() . '.name'
]
];
break;
case 'Cartridge' :
$criteria = [
'SELECT' => [
$item->getTable() . '.*',
'glpi_cartridgeitems.name',
'glpi_infocoms.value'
],
'FROM' => 'glpi_infocoms',
'INNER JOIN' => [
$item->getTable() => [
'ON' => [
$item->getTable() => 'id',
'glpi_infocoms' => 'items_id'
]
],
'glpi_cartridgeitems' => [
'ON' => [
$item->getTable() => 'cartridgeitems_id',
'glpi_cartridgeitems' => 'id'
]
]
],
'WHERE' => [
'glpi_infocoms.itemtype' => $itemtype,
'glpi_infocoms.budgets_id' => $budgets_id
] + getEntitiesRestrictCriteria($item->getTable()),
'ORDERBY' => [
'entities_id',
'glpi_cartridgeitems.name'
]
];
break;
case 'Consumable' :
$criteria = [
'SELECT' => [
$item->getTable() . '.*',
'glpi_consumableitems.name',
'glpi_infocoms.value'
],
'FROM' => 'glpi_infocoms',
'INNER JOIN' => [
$item->getTable() => [
'ON' => [
$item->getTable() => 'id',
'glpi_infocoms' => 'items_id'
]
],
'glpi_consumableitems' => [
'ON' => [
$item->getTable() => 'consumableitems_id',
'glpi_consumableitems' => 'id'
]
]
],
'WHERE' => [
'glpi_infocoms.itemtype' => $itemtype,
'glpi_infocoms.budgets_id' => $budgets_id
] + getEntitiesRestrictCriteria($item->getTable()),
'ORDERBY' => [
'entities_id',
'glpi_consumableitems.name'
]
];
break;
default:
$criteria = [
'SELECT' => [
$item->getTable() . '.*',
'glpi_infocoms.value',
],
'FROM' => 'glpi_infocoms',
'INNER JOIN' => [
$item->getTable() => [
'ON' => [
$item->getTable() => 'id',
'glpi_infocoms' => 'items_id'
]
]
],
'WHERE' => [
'glpi_infocoms.itemtype' => $itemtype,
'glpi_infocoms.budgets_id' => $budgets_id
] + getEntitiesRestrictCriteria($item->getTable()),
'ORDERBY' => [
$item->getTable() . '.entities_id'
]
];
if ($item->maybeTemplate()) {
$criteria['WHERE'][$item->getTable() . '.is_template'] = 0;
}
if ($item instanceof Item_Devices) {
$criteria['ORDERBY'][] = $item->getTable() .'.itemtype';
} else {
$criteria['ORDERBY'][] = $item->getTable() . '.name';
}
break;
}
$iterator = $DB->request($criteria);
$nb = count($iterator);
if ($nb > $_SESSION['glpilist_limit']) {
echo "<tr class='tab_bg_1'>";
$name = $item->getTypeName($nb);
//TRANS: %1$s is a name, %2$s is a number
echo "<td class='center'>".sprintf(__('%1$s: %2$s'), $name, $nb)."</td>";
echo "<td class='center' colspan='2'>";
$opt = ['order' => 'ASC',
'is_deleted' => 0,
'reset' => 'reset',
'start' => 0,
'sort' => 80,
'criteria' => [0 => ['value' => '$$$$'.$budgets_id,
'searchtype' => 'contains',
'field' => 50]]];
echo "<a href='". $item->getSearchURL() . "?" .Toolbox::append_params($opt). "'>".
__('Device list')."</a></td>";
echo "<td class='center'>-</td><td class='center'>-</td><td class='center'>-".
"</td></tr>";
} else if ($nb) {
for ($prem=true; $data = $iterator->next(); $prem=false) {
$name = NOT_AVAILABLE;
if ($item->getFromDB($data["id"])) {
if ($item instanceof Item_Devices) {
$tmpitem = new $item::$itemtype_2();
if ($tmpitem->getFromDB($data[$item::$items_id_2])) {
$name = $tmpitem->getLink(['additional' => true]);
}
} else {
$name = $item->getLink(['additional' => true]);
}
}
echo "<tr class='tab_bg_1'>";
if ($prem) {
$typename = $item->getTypeName($nb);
echo "<td class='center top' rowspan='$nb'>".
($nb>1 ? sprintf(__('%1$s: %2$s'), $typename, $nb) : $typename)."</td>";
}
echo "<td class='center'>".Dropdown::getDropdownName("glpi_entities",
$data["entities_id"]);
echo "</td><td class='center";
echo (isset($data['is_deleted']) && $data['is_deleted'] ? " tab_bg_2_2'" : "'");
echo ">".$name."</td>";
echo "<td class='center'>".(isset($data["serial"])? "".$data["serial"]."" :"-");
echo "</td>";
echo "<td class='center'>".
(isset($data["otherserial"])? "".$data["otherserial"]."" :"-")."</td>";
echo "<td class='center'>".
(isset($data["value"]) ? "".Html::formatNumber($data["value"], true).""
:"-");
echo "</td></tr>";
}
}
$num += $nb;
}
}
if ($num>0) {
echo "<tr class='tab_bg_2'>";
echo "<td class='center b'>".sprintf(__('%1$s = %2$s'), __('Total'), $num)."</td>";
echo "<td colspan='5'> </td></tr> ";
}
echo "</table></div>";
}
/**
* Print the HTML array of value consumed for a budget
*
* @return void
**/
function showValuesByEntity() {
global $DB;
$budgets_id = $this->fields['id'];
if (!$this->can($budgets_id, READ)) {
return false;
}
$types_iterator = Infocom::getTypes(
[
'budgets_id' => $budgets_id
] + getEntitiesRestrictCriteria('glpi_infocoms', 'entities_id')
);
$total = 0;
$totalbytypes = [];
$itemtypes = [];
$entities_values = [];
$entitiestype_values = [];
$found_types = [];
while ($types = $types_iterator->next()) {
$itemtypes[] = $types['itemtype'];
}
$itemtypes[] = 'Contract';
$itemtypes[] = 'Ticket';
$itemtypes[] = 'Problem';
$itemtypes[] = 'Project';
$itemtypes[] = 'Change';
foreach ($itemtypes as $itemtype) {
if (!($item = getItemForItemtype($itemtype))) {
continue;
}
$table = getTableForItemType($itemtype);
switch ($itemtype) {
case 'Contract' :
$criteria = [
'SELECT' => [
$table . '.entities_id',
'SUM' => 'glpi_contractcosts.cost AS sumvalue'
],
'FROM' => 'glpi_contractcosts',
'INNER JOIN' => [
$table => [
'ON' => [
$table => 'id',
'glpi_contractcosts' => 'contracts_id'
]
]
],
'WHERE' => [
'glpi_contractcosts.budgets_id' => $budgets_id
] + getEntitiesRestrictCriteria($table, 'entities_id'),
'GROUPBY' => [
$table . '.entities_id'
]
];
break;
case 'Project' :
$costtable = getTableForItemType($item->getType().'Cost');
$criteria = [
'SELECT' => [
$table . '.entities_id',
'SUM' => 'glpi_projectcosts.cost AS sumvalue'
],
'FROM' => 'glpi_projectcosts',
'INNER JOIN' => [
$table => [
'ON' => [
$table => 'id',
'glpi_projectcosts' => 'projects_id'
]
]
],
'WHERE' => [
'glpi_projectcosts.budgets_id' => $budgets_id
] + getEntitiesRestrictCriteria($table, 'entities_id'),
'GROUPBY' => [
$item->getTable() . '.entities_id'
]
];
break;
case 'Ticket' :
case 'Problem' :
case 'Change' :
$costtable = getTableForItemType($item->getType().'Cost');
$sum = new QueryExpression(
"SUM(" . $DB->quoteName("$costtable.actiontime") . " * " . $DB->quoteName("$costtable.cost_time") . "/".HOUR_TIMESTAMP."
+ " . $DB->quoteName("$costtable.cost_fixed") . "
+ " . $DB->quoteName("$costtable.cost_material") . ") AS " . $DB->quoteName('sumvalue')
);
$criteria = [
'SELECT' => [
$item->getTable() . '.entities_id',
$sum
],
'FROM' => $costtable,
'INNER JOIN' => [
$table => [
'ON' => [
$table => 'id',
$costtable => $item->getForeignKeyField()
]
]
],
'WHERE' => [
$costtable . '.budgets_id' => $budgets_id
] + getEntitiesRestrictCriteria($table, 'entities_id'),
'GROUPBY' => [
$item->getTable() . '.entities_id'
]
];
break;
default :
$criteria = [
'SELECT' => [
$table . '.entities_id',
'SUM' => 'glpi_infocoms.value AS sumvalue',
],
'FROM' => $table,
'INNER JOIN' => [
'glpi_infocoms' => [
'ON' => [
$table => 'id',
'glpi_infocoms' => 'items_id'
]
]
],
'WHERE' => [
'glpi_infocoms.itemtype' => $itemtype,
'glpi_infocoms.budgets_id' => $budgets_id
] + getEntitiesRestrictCriteria($table, 'entities_id'),
'GROUPBY' => [
$table . '.entities_id'
]
];
if ($item->maybeTemplate()) {
$criteria['WHERE'][$table . '.is_template'] = 0;
}
break;
}
$iterator = $DB->request($criteria);
$nb = count($iterator);
if ($nb) {
$found_types[$itemtype] = $item->getTypeName(1);
$totalbytypes[$itemtype] = 0;
//Store, for each entity, the budget spent
while ($values = $iterator->next()) {
if (!isset($entities_values[$values['entities_id']])) {
$entities_values[$values['entities_id']] = 0;
}
if (!isset($entitiestype_values[$values['entities_id']][$itemtype])) {
$entitiestype_values[$values['entities_id']][$itemtype] = 0;
}
$entities_values[$values['entities_id']] += $values['sumvalue'];
$entitiestype_values[$values['entities_id']][$itemtype] += $values['sumvalue'];
$total += $values['sumvalue'];
$totalbytypes[$itemtype] += $values['sumvalue'];
}
}
}
$budget = new self();
$budget->getFromDB($budgets_id);
$colspan = count($found_types)+2;
echo "<div class='spaced'><table class='tab_cadre_fixehov'>";
echo "<tr class='noHover'><th colspan='$colspan'>".__('Total spent on the budget')."</th></tr>";
echo "<tr><th>".Entity::getTypeName(1)."</th>";
if (count($found_types)) {
foreach ($found_types as $type => $typename) {
echo "<th>$typename</th>";
}
}
echo "<th>".__('Total')."</th>";
echo "</tr>";
// get all entities ordered by names
$allentities = getAllDataFromTable('glpi_entities', ['ORDER' => 'completename'], true);
foreach (array_keys($allentities) as $entity) {
if (isset($entities_values[$entity])) {
echo "<tr class='tab_bg_1'>";
echo "<td class='b'>".Dropdown::getDropdownName('glpi_entities', $entity)."</td>";
if (count($found_types)) {
foreach ($found_types as $type => $typename) {
echo "<td class='numeric'>";
$typevalue = 0;
if (isset($entitiestype_values[$entity][$type])) {
$typevalue = $entitiestype_values[$entity][$type];
}
echo Html::formatNumber($typevalue);
echo "</td>";
}
}
echo "<td class='right b'>".Html::formatNumber($entities_values[$entity])."</td>";
echo "</tr>";
}
}
if (count($found_types)) {
echo "<tr class='tab_bg_1'>";
echo "<td class='right b'>".__('Total')."</td>";
foreach ($found_types as $type => $typename) {
echo "<td class='numeric b'>";
echo Html::formatNumber($totalbytypes[$type]);
echo "</td>";
}
echo "<td class='numeric b'>".Html::formatNumber($total)."</td>";
echo "</tr>";
}
echo "<tr class='tab_bg_1 noHover'><th colspan='$colspan'><br></th></tr>";
echo "<tr class='tab_bg_1 noHover'>";
echo "<td class='right' colspan='".($colspan-1)."'>".__('Total spent on the budget')."</td>";
echo "<td class='numeric b'>".Html::formatNumber($total)."</td></tr>";
if ($_SESSION['glpiactive_entity'] == $budget->fields['entities_id']) {
echo "<tr class='tab_bg_1 noHover'>";
echo "<td class='right' colspan='".($colspan-1)."'>".__('Total remaining on the budget').
"</td>";
echo "<td class='numeric b'>".Html::formatNumber($budget->fields['value'] - $total).
"</td></tr>";
}
echo "</table></div>";
}
static function getIcon() {
return "fas fa-calculator";
}
}