/** * @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); }