$rowclose["1" . GoodFieldName($arr['name']) . "_grval"] = $groupvalue[$arr['name']];
$rowclose["group" . GoodFieldName($arr['name']) . "_total_cnt"] = $grouptotals_count[$arr['name']];
$arr_group_close[$i]["name"] = GoodFieldName($arr['name']);
$arr_group_close[$i]["group_order"] = $arr['group_order'];
$arr_group_close[$i]["int_type"] = $arr['int_type'];
$arr_group_close[$i]["ss"] = $arr['ss'];
$arr_group_close[$i]["color1"] = $arr['color1'];
$arr_group_close[$i]["color2"] = $arr['color2'];
$arr_group_close[$i]["endgroup"] = true;
$arr_group_close[$i]["grval"] = $groupvalue[$arr['name']];
$arr_group_close[$i]["total_cnt"] = $grouptotals_count[$arr['name']];
foreach ($rpt_array['totals'] as $fld){
if ($fld['show'] && $fld['sum']) {
$sum = array(fldname($fld) => $grouptotals_sum[$arr['name']][fldname($fld)]);
$sval = $viewControls->getControl(fldname($fld), $fld['view_format'])->showDBValue($sum, "");
$rowclose["group" . GoodFieldName($arr['name']) . "_total" . GoodFieldName(fldname($fld)) . "_sum"] = $sval;
$arr_group_close[$i]["group_total_sum"]["data"][0][fldname($fld)] = $sval;
}
}
if (testAgr($rpt_array['totals'], "avg", "min", "max", "") > 0) {
if ($grouptotals_count[$arr['name']]) {
foreach ($rpt_array['totals'] as $fld){
if ($fld['show']) {
if ($fld['avg']) {
$avg = array(fldname($fld) => $grouptotals_sum[$arr['name']][fldname($fld)] / $grouptotals_count[$arr['name']]);
$aval = $viewControls->getControl(fldname($fld), $fld['view_format'])->showDBValue($avg, "");
$rowclose["group" . GoodFieldName($arr['name']) . "_total" . GoodFieldName(fldname($fld)) . "_avg"] = $aval;
$arr_group_close[$i]["group_total_avg"]["data"][0][fldname($fld)] = $aval;
}
echo printJSON($returnJSON);
return;
}
$fieldValue = $data[$field];
$sessionPrefix = $pSet->getOriginalTableName();
if ($mode == LIST_DASHBOARD) {
//set the session prefix for the dashboard list page
$sessionPrefix = "Dashboard_" . $pSet->getOriginalTableName();
}
if ($lookup) {
//set the session prefix for the lookup list page
$sessionPrefix = $pSet->getOriginalTableName() . "_lookup_" . $mainTable . '_' . $mainField;
}
$searchClauseObj = SearchClause::UnserializeObject($_SESSION[$sessionPrefix . "_advsearch"]);
$container = new ViewControlsContainer($pSet, PAGE_LIST, null);
$cViewControl = $container->getControl($field);
if ($cViewControl->localControlsContainer && !$cViewControl->linkAndDisplaySame) {
$cViewControl->localControlsContainer->fullText = true;
} else {
$cViewControl->container->fullText = true;
}
if ($searchClauseObj) {
if ($searchClauseObj->bIsUsedSrch || $useViewControl) {
$cViewControl->searchClauseObj = $searchClauseObj;
$cViewControl->searchHighlight = true;
}
}
$htmlEncodedValue = $cViewControl->showDBValue($data, "");
$returnJSON = array("success" => true, "textCont" => nl2br($htmlEncodedValue));
echo printJSON($returnJSON);
return;
/**
* User API function
* @param Array data
* @param String field
* @param String table The datasource table name
*/
public static function Format($data, $field, $table)
{
$pSet = new ProjectSettings($table);
include_once getabspath("classes/controls/ViewControlsContainer.php");
$viewControls = new ViewControlsContainer($pSet, PAGE_VIEW);
return $viewControls->getControl($field)->getTextValue($data);
}
