/**
* Get the validation statistics
*
* @param $tID tickets id
*
* @return statistics array
**/
static function getValidationStats($tID)
{
$tab = self::getAllStatusArray();
$nb = countElementsInTable(static::getTable(), "`" . static::$items_id . "` = " . $tID);
$stats = array();
foreach ($tab as $status => $name) {
$restrict = "`" . static::$items_id . "` = '" . $tID . "'\n AND `status` = '" . $status . "'";
$validations = countElementsInTable(static::getTable(), $restrict);
if ($validations > 0) {
if (!isset($stats[$status])) {
$stats[$status] = 0;
}
$stats[$status] = $validations;
}
}
$list = "";
foreach ($stats as $stat => $val) {
$list .= $tab[$stat];
$list .= sprintf(__('%1$s (%2$d%%) '), " ", HTml::formatNumber($val * 100 / $nb));
}
return $list;
}
/**
* Get the validation statistics
*
* @param $tID tickets id
*
* @return statistics array
**/
static function getValidationStats($tID)
{
$tab = self::getAllStatusArray();
$nb = countElementsInTable(static::getTable(), [static::$items_id => $tID]);
$stats = array();
foreach ($tab as $status => $name) {
$validations = countElementsInTable(static::getTable(), [static::$items_id => $tID, 'status' => $status]);
if ($validations > 0) {
if (!isset($stats[$status])) {
$stats[$status] = 0;
}
$stats[$status] = $validations;
}
}
$list = "";
foreach ($stats as $stat => $val) {
$list .= $tab[$stat];
$list .= sprintf(__('%1$s (%2$d%%) '), " ", HTml::formatNumber($val * 100 / $nb));
}
return $list;
}
