/**
* @param $item Contract object
**/
static function countForContract(Contract $item)
{
global $DB;
$sql = "SELECT DISTINCT `itemtype`\n FROM `glpi_contracts_items`\n WHERE `glpi_contracts_items`.`contracts_id` = '" . $item->getField('id') . "'";
$nb = 0;
foreach ($DB->request($sql) as $data) {
$itemt = getItemForItemtype($data['itemtype']);
$query = "SELECT COUNT(*) AS cpt\n FROM `glpi_contracts_items`, `" . $itemt->getTable() . "`\n WHERE `glpi_contracts_items`.`contracts_id` = '" . $item->getField('id') . "'\n AND `glpi_contracts_items`.`itemtype` = '" . $data['itemtype'] . "'\n AND `" . $itemt->getTable() . "`.`id` = `glpi_contracts_items`.`items_id`";
if ($itemt->maybeTemplate()) {
$query .= " AND NOT `" . $itemt->getTable() . "`.`is_template`";
}
foreach ($DB->request($query) as $row) {
$nb += $row['cpt'];
}
}
return $nb;
}
/**
* @param $item string Contract object
**/
static function countForContract(Contract $item)
{
$restrict = "`glpi_contracts_suppliers`.`contracts_id` = '" . $item->getField('id') . "'\n AND `glpi_contracts_suppliers`.`suppliers_id` = `glpi_suppliers`.`id` " . getEntitiesRestrictRequest(" AND ", "glpi_suppliers", '', $_SESSION['glpiactiveentities'], true);
return countElementsInTable(array('glpi_contracts_suppliers', 'glpi_suppliers'), $restrict);
}
/**
* @param $item Contract object
**/
static function countForContract(Contract $item)
{
$restrict = "`glpi_contracts_items`.`contracts_id` = '" . $item->getField('id') . "'";
return countElementsInTable(array('glpi_contracts_items'), $restrict);
}
