$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); }