function GetTotals($field, $value, $stype, $iNumberOfRows, $sFormat, $ptype)
{
global $strTableName;
$pSet = new ProjectSettings($strTableName, $ptype);
$days = 0;
if ($stype == "AVERAGE") {
if ($iNumberOfRows) {
if ($sFormat == FORMAT_TIME) {
if ($value) {
$value = round($value / $iNumberOfRows, 0);
$s = $value % 60;
$value -= $s;
$value /= 60;
$m = $value % 60;
$value -= $m;
$value /= 60;
$h = $value % 24;
$value -= $h;
$value /= 24;
$d = $value;
$value = ($d != 0 ? $d . 'd ' : '') . mysprintf("%02d:%02d:%02d", array($h, $m, $s));
}
} else {
$value = round($value / $iNumberOfRows, 2);
}
} else {
return "";
}
}
if ($stype == "TOTAL") {
if ($sFormat == FORMAT_TIME) {
if ($value) {
$s = $value % 60;
$value -= $s;
$value /= 60;
$m = $value % 60;
$value -= $m;
$value /= 60;
$h = $value % 24;
$value -= $h;
$value /= 24;
$d = $value;
$value = ($d != 0 ? $d . 'd ' : '') . mysprintf("%02d:%02d:%02d", array($h, $m, $s));
}
}
}
$sValue = "";
$data = array($field => $value);
if ($sFormat == FORMAT_CURRENCY) {
$sValue = str_format_currency($value);
} else {
if ($sFormat == FORMAT_PERCENT) {
$sValue = str_format_number($value * 100) . "%";
} else {
if ($sFormat == FORMAT_NUMBER) {
$sValue = str_format_number($value, $pSet->isDecimalDigits($field));
} else {
if ($sFormat == FORMAT_CUSTOM && $stype != "COUNT") {
include_once getabspath('classes/controls/ViewControlsContainer.php');
$viewControls = new ViewControlsContainer($pSet, $ptype);
$sValue = $viewControls->showDBValue($field, $data);
} else {
$sValue = $value;
}
}
}
}
if ($stype == "COUNT") {
return $value;
}
if ($stype == "TOTAL") {
return $sValue;
}
if ($stype == "AVERAGE") {
return $sValue;
}
return "";
}
