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