// Clear out cloned field
//dump($querySelects);
if ($Type[1] == 'mysqlfunc') {
$type = $Config['_mathMysqlFunc'][$Field];
if ($type == '_custom') {
if (!empty($Config['_mathMysqlCustomFunc'][$Field])) {
$type = str_replace('()', '', $Config['_mathMysqlCustomFunc'][$Field]);
}
}
//dump($_SERVER['fieldMath'][$Field]);
if ($Config['_mathMysqlFunc'][$Field] == 'sumtotal') {
$type = 'count';
$_SERVER['fieldMath'][$Field] = 0;
}
$fieldSett = $Field;
if (!empty($Config['_CloneField'][$Field])) {
if (!empty($Config['_CloneField'][$Config['_CloneField'][$Field]['Master']])) {
$fieldSett = dr_findCloneParent($Field, $Config['_CloneField'], $querySelects);
} else {
$fieldSett = $Config['_CloneField'][$Field]['Master'];
}
if (strpos($fieldSett, '.') === false) {
$fieldSett = 'prim.`' . $fieldSett . '`';
}
}
if ($type != '_custom') {
$querySelects[$Field] = $type . '(`' . $fieldSett . '`)';
} else {
$querySelects[$Field] = $fieldSett;
}
}
function dr_BuildReportGrid($EID, $Page = false, $SortField = false, $SortDir = false, $Format = false, $limitOveride = false, $wherePush = false, $getOverride = false)
{
// get element
$Element = getelement($EID);
$Config = $Element['Content'];
if (!empty($Config['_customFooterJavaScript']) && empty($Format)) {
$_SESSION['dataform']['OutScripts'] .= "\n " . stripslashes_deep($Config['_customFooterJavaScript']) . "\n ";
}
if (!empty($getOverride)) {
parse_str($getOverride, $_GET);
}
//Filters will be picked up via Session value
// Set Vars
if (empty($Page)) {
$Page = 1;
}
if (!empty($Format)) {
// XML Output
if (strtolower($Format) == 'xml') {
$apiOut = "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n";
$apiOut .= " <entries>\n";
}
//json output
if (strtolower($Format) == 'json') {
$jsonIndex = 0;
$apiOutput = array();
$apiOutput['page'] = $Page;
$apiOutput['totalpages'] = '';
$apiOutput['totalentries'] = '';
$apiOutput['entrycount'] = '';
$apiOutput['entries'] = array();
}
if (strtolower($Format) == 'pdf') {
$pdfIndex = 0;
$apiOutput = array();
if (!empty($_SESSION['reportFilters'][$EID])) {
$apiOutput['filters'] = $_SESSION['reportFilters'][$EID];
}
}
}
//global $ReportReturn;
$ReportReturn = '';
if (empty($Config['_main_table'])) {
return 'No Table Selected';
}
$queryJoin = '';
$queryJoins = array();
$queryWhere = array();
$queryLimit = '';
$querySelects = array();
$WhereTag = '';
$groupBy = '';
$orderStr = '';
$countSelect = '';
$countLimit = 'LIMIT 1';
$isModal = 'false';
if (!empty($Config['_popupTypeView'])) {
if ($Config['_popupTypeView'] == 'modal') {
$isModal = true;
}
}
// Setup Totals Fields
if (!empty($Config['_TotalsField'])) {
foreach ($Config['_TotalsField'] as $key => $Field) {
if (!empty($Config['_TotalsFieldTitle'][$key])) {
$Title = str_replace(' ', '', ucwords($Config['_TotalsFieldTitle'][$key]));
} else {
$Title = $Field . 'Total';
}
//if($Config['_TotalsFieldLocation'][$key] == 'inline'){
$Config['_Field'][$Title] = 'totals_' . $Config['_TotalsFieldType'][$key];
$Config['_IndexType'][$Title] = 'index_show';
$Config['_Justify'][$Title] = $Config['_TotalsFieldJustify'][$key];
//}else{
$Config['_TotalsFields'][$Title][$Config['_TotalsFieldType'][$key]] = 0;
//}
// Create easy sorting array
$Config['_TotalsFields'][$Title]['Type'] = $Config['_TotalsFieldType'][$key];
$Config['_TotalsFields'][$Title]['Grouping'] = $Config['_TotalsGroupingField'][$key];
$Config['_TotalsFields'][$Title]['Location'] = $Config['_TotalsFieldLocation'][$key];
$Config['_TotalsFields'][$Title]['Function'] = $Config['_TotalsFieldFunction'][$key];
$Config['_TotalsFields'][$Title]['Prefix'] = $Config['_TotalsFieldPrefix'][$key];
$Config['_TotalsFields'][$Title]['Suffix'] = $Config['_TotalsFieldSuffix'][$key];
$Config['_TotalsFields'][$Title]['PrimField'] = $Field;
//dump($Config['_TotalsFieldTitleWidth']);
if (!empty($Config['_TotalsFieldTitleWidth'][$key])) {
$Config['_WidthOverride'][$Title] = $Config['_TotalsFieldTitleWidth'][$key];
}
if (!empty($Config['_TotalsFieldCaption'][$key])) {
$Config['_TotalsFields'][$Title]['Caption'] = $Config['_TotalsFieldCaption'][$key];
}
$Config['_TotalsFields'][$Title]['Title'] = $Title;
unset($Title);
}
//unset($Config['_TotalsFieldType']);
//unset($Config['_TotalsFieldLocation']);
//unset($Config['_TotalsFieldTitle']);
//unset($Config['_TotalsField']);
}
if (!empty($Page)) {
$_SESSION['report_' . $EID]['LastPage'] = $Page;
} else {
if (empty($_SESSION['report_' . $EID]['LastPage']) || $_SESSION['report_' . $EID]['LastPage'] == 'undefined') {
$_SESSION['report_' . $EID]['LastPage'] = 1;
}
$Page = $_SESSION['report_' . $EID]['LastPage'];
}
if (!empty($SortDir)) {
$_SESSION['report_' . $EID]['SortDir'] = $SortDir;
}
if (!empty($SortField)) {
$_SESSION['report_' . $EID]['SortField'] = $SortField;
}
//setup Field Types
foreach ($Config['_Field'] as $Field => $Type) {
if (empty($Type)) {
//$querySelects[$Field] = $Field;
}
// explodes to:
// [0] = Field plugin dir
// [1] = Field plugin type
$Config['_Field'][$Field] = explode('_', $Type);
}
//SetupHeaders
// Start Table
// Check for template
$customClass = '';
if (!empty($Config['_ListTableClass'])) {
$customClass = $Config['_ListTableClass'];
}
$tableClass = 'class="data_report_Table ' . $customClass . '"';
if (is_admin()) {
$tableClass = 'class="widefat data_report_Table_admin ' . $customClass . '"';
}
$ReportReturn .= '<table width="100%" border="0" cellspacing="0" cellpadding="4" ' . $tableClass . ' id="data_report_' . $EID . '" style="cursor:default;">';
//Start Headers Row
//$ReportReturn .= '<caption>'.$Config['_ReportTitle'].'</caption>';
$ReportReturn .= '<thead>';
$ReportReturn .= '<tr>';
foreach ($Config['_IndexType'] as $Field => $Type) {
//echo 'ping';
//Seperate Index/Display Types
$Config['_IndexType'][$Field] = explode('_', $Type);
// Totals Location check to see if field is inline or not.
$Location = 'inline';
if (!empty($Config['_TotalsFields'][$Field]['Location'])) {
$Location = $Config['_TotalsFields'][$Field]['Location'];
}
if ($Config['_IndexType'][$Field][1] == 'show' && ($Location == 'inline' || $Location == 'headerinline' || $Location == 'footerinline') && empty($wherePush)) {
//Set Widths
$Direction = 'ASC';
if (key_exists('SortDir', $_SESSION['report_' . $EID])) {
if ($_SESSION['report_' . $EID]['SortDir'] == 'ASC') {
$Direction = 'DESC';
}
}
$sortClass = 'report_header';
if (key_exists('SortFIeld', $_SESSION['report_' . $EID])) {
if ($_SESSION['report_' . $EID]['SortField'] == $Field) {
$sortClass = 'sorting_' . $_SESSION['report_' . $EID]['SortDir'];
}
}
// set the column Title
$fieldTitle = $Field;
if (!empty($Config['_TotalsFields'][$Field]['Title'])) {
$fieldTitle = $Config['_TotalsFields'][$Field]['Title'];
}
if (empty($Config['_WidthOverride'][$Field])) {
$Config['_WidthOverride'][$Field] = '';
}
$ReportReturn .= '<th nowrap="nowrap" scope="col" width="' . ($Config['_WidthOverride'][$Field] == '' ? '{{width_' . $Field . '}}px' : $Config['_WidthOverride'][$Field] . 'px') . '" ';
if (!empty($Config['_Sortable'][$Field])) {
$ReportReturn .= 'onclick="dr_sortReport(\'' . $EID . '\', \'' . $Field . '\', \'' . $Direction . '\');" class="' . $sortClass . '"';
}
$ReportReturn .= '>';
if (!empty($Config['_FieldTitle'][$Field])) {
$ReportReturn .= '<span>' . $Config['_FieldTitle'][$Field] . '</span>';
} else {
$ReportReturn .= '<span>' . df_parseCamelCase($fieldTitle) . '</span>';
}
$ReportReturn .= '</th>';
// Preset the selects from query
$querySelects[$Field] = $Field;
// 'prim.`' . $Field . '`';
// Set average width and min width
$minWidth[$Field] = strlen($fieldTitle) * 8;
$AvrageWidth[$Field] = array();
$AvrageWidth[$Field][] = $minWidth[$Field];
}
if (!empty($wherePush)) {
$querySelects[$Field] = $Field;
//'prim.`' . $Field . '`';
}
}
// Add the return field to select
if (!empty($Config['_ReturnFields'])) {
//$querySelects[$Config['_ReturnFields'][0]] = 'prim.'.$Config['_ReturnFields'][0];
foreach ($Config['_ReturnFields'] as $Field) {
$newField = '_return_' . $Field;
$querySelects[$newField] = $Field;
//'prim.`' . $Field . '`';
}
}
if (empty($Config['_Show_popup'])) {
if (!empty($Config['_Show_Edit']) && empty($Config['_ItemViewPage']) || !empty($Config['_Show_Delete']) || !empty($Config['_Show_View']) || !empty($Config['_Show_Edit'])) {
$ShowActionPanel = true;
}
if (!empty($ShowActionPanel)) {
$ReportReturn .= '<th scope="col">';
$ReportReturn .= 'Action';
$ReportReturn .= '</th>';
}
}
$ReportReturn .= '</tr>';
$ReportReturn .= '</thead>';
// End Headers setup
// Build Query
// field type filters
$joinIndex = 'a';
foreach ($Config['_Field'] as $Field => $Type) {
//set filter for auto values
if ($Type[0] == 'hidden') {
if (!empty($_SESSION['reportFilters'][$EID][$Field])) {
if ($WhereTag == '') {
$WhereTag = " WHERE ";
}
$queryWhere[] = "prim.`" . $Field . "` = '" . $_SESSION['reportFilters'][$EID][$Field] . "'";
}
}
// Run Filters that have been set through each field type
if (file_exists(WP_PLUGIN_DIR . '/db-toolkit/data_form/fieldtypes/' . $Type[0] . '/queryfilter.php')) {
include WP_PLUGIN_DIR . '/db-toolkit/data_form/fieldtypes/' . $Type[0] . '/queryfilter.php';
}
if (!empty($_SESSION['reportFilters'][$EID]['_keywords'])) {
if ($WhereTag == '') {
$WhereTag = " WHERE ";
}
$keyField = 'prim.`' . $Field . '`';
$preWhere[] = $keyField . " LIKE '%" . $_SESSION['reportFilters'][$EID]['_keywords'] . "%' ";
}
//}
$joinIndex++;
}
// combine keyword search if there are any
if (!empty($preWhere)) {
$queryWhere[] = '(' . implode(' OR ', $preWhere) . ')';
}
if (!empty($wherePush)) {
if ($WhereTag == '') {
$WhereTag = " WHERE ";
}
foreach ($wherePush as $wField => $wVal) {
$queryWhere[] = 'prim.`' . $wField . '` = \'' . $wVal . '\'';
}
}
// create Query Selects and Where clause string
$querySelects = dr_processQuery($Config, $querySelects);
if (!empty($_SESSION['reportFilters'][$EID]['_keywords'])) {
if ($WhereTag == '') {
$WhereTag = " WHERE ";
}
foreach ($querySelects as $Key => $Field) {
if (!empty($Config['_IndexType'][$Field][0])) {
echo $Field . '<br />';
$preWhere[] = $Field . " LIKE '%" . $_SESSION['reportFilters'][$EID]['_keywords'] . "%' ";
// explode and serach parts
$parts = explode(',', $_SESSION['reportFilters'][$EID]['_keywords']);
foreach ($parts as $Part) {
$preWhere[] = $Field . " LIKE '%" . trim($Part) . "%' ";
}
// explode and serach parts
$parts = explode(', ', $_SESSION['reportFilters'][$EID]['_keywords']);
foreach ($parts as $Part) {
$preWhere[] = $Field . " LIKE '%" . trim($Part) . "%' ";
}
}
}
}
//vardump($Config['_CloneField']); //vardump($querySelects);
$preSelects = array();
foreach ($querySelects as $AS => $selectField) {
$preSelects[] = $selectField . ' AS `' . $AS . '`';
}
$querySelect = implode(", \n", $preSelects);
$queryWhere = implode(' AND ', $queryWhere);
// create sort fields
if (!empty($Config['_SortField'])) {
if (key_exists('SortFields', $_SESSION['report_' . $EID]) && !empty($querySelects[$_SESSION['report_' . $EID]['SortField']])) {
$orderStr = 'ORDER BY `' . $_SESSION['report_' . $EID]['SortField'] . '` ' . $_SESSION['report_' . $EID]['SortDir'];
} else {
$orderStr = 'ORDER BY prim.`' . $Config['_SortField'] . '` ' . $Config['_SortDirection'] . '';
}
}
// create joins and on
$pattern = 'prim.`(__[a-zA-Z0-9]+)`';
preg_match_all('/' . $pattern . '/s', $queryJoin, $matches);
foreach ($matches[0] as $key => $Match) {
$queryJoin = str_replace($Match, $querySelects[$matches[1][$key]], $queryJoin);
}
// Build the grouping if ther are any
if (is_array($groupBy)) {
$preGroup = array();
foreach ($groupBy as $groupField => $preField) {
if (!empty($querySelects[$groupField])) {
$preGroup[] = $querySelects[$groupField];
} else {
if (strpos($preField, '.') === false) {
$preField = 'prim.' . $preField . '';
}
$preGroup[] = $preField;
}
}
$groupBy = 'GROUP BY (' . implode('),(', $preGroup) . ')';
$countLimit = '';
$entryCount = true;
//add totals selects to count
if (is_array($countSelect)) {
$countSelect = ',' . implode(',', $countSelect);
}
}
// Build WHERES - prim.clones
$pattern = 'prim.`(__[a-zA-Z0-9]+)`';
preg_match_all('/' . $pattern . '/s', $queryWhere, $matches);
foreach ($matches[0] as $key => $Match) {
if (!empty($querySelects['_sourceid_' . $matches[1][$key]])) {
$queryWhere = str_replace($Match, $querySelects['_sourceid_' . $matches[1][$key]], $queryWhere);
} else {
$replace = dr_findCloneParent($matches[1][$key], $Config['_CloneField'], $querySelects);
if (strpos($replace, '.') === false) {
$replace = 'prim.`' . $replace . '`';
}
$queryWhere = str_replace($Match, $replace, $queryWhere);
}
}
//return;
// Totals Query & Results
//dump($querySelects);
if (!empty($Config['_CloneField'][$Config['_ReturnFields'][0]])) {
$countSelect = dr_findCloneParent($Config['_ReturnFields'][0], $Config['_CloneField'], $querySelects);
} else {
$countSelect = $Config['_ReturnFields'][0];
}
if (strpos($countSelect, '.') === false) {
$countSelect = 'prim.`' . $countSelect . '`';
}
// get done queries
global $wpdb;
//dump($Queries);
// Custom WHERE
$customWhere = '';
if (!empty($Config['_useCustomWhere'])) {
if ($WhereTag == '') {
$WhereTag = " WHERE ";
}
$preWhere = '';
foreach ($Config['_customWHERE'] as $cwhere) {
if (!empty($queryWhere)) {
$queryWhere = '(' . $queryWhere . ')';
$preWhere .= ' ' . $cwhere['_Req'] . ' ';
}
$preWhere .= '(' . $cwhere['_Where'] . ')';
}
$queryWhere .= $preWhere;
}
$CountQuery = "SELECT count(" . $countSelect . ") as Total FROM `" . $Config['_main_table'] . "` AS prim \n " . $queryJoin . " \n " . $WhereTag . " \n " . $queryWhere . " \n " . $groupBy . "\n\n " . $countLimit . ";";
$CountResult = mysql_query($CountQuery);
if (!empty($entryCount)) {
// Countr Rows
while ($prCount = mysql_fetch_assoc($CountResult)) {
$preCount[] = $prCount['Total'];
}
if (!empty($preCount)) {
$Count['TotalEntries'] = array_sum($preCount);
unset($prCount);
unset($preCount);
} else {
$Count['TotalEntries'] = 0;
}
$Count['Total'] = mysql_num_rows($CountResult);
} else {
// get Count entry
if (!empty($CountResult)) {
$Count = mysql_fetch_assoc($CountResult);
mysql_free_result($CountResult);
} else {
$Count = 0;
}
}
if (!empty($limitOveride) && $limitOveride != 'full') {
$Config['_Items_Per_Page'] = $limitOveride;
}
if (!empty($_SESSION['report_' . $EID]['limitOveride'])) {
$Config['_Items_Per_Page'] = floatval($_SESSION['report_' . $EID]['limitOveride']);
}
if (!empty($Config['_Items_Per_Page'])) {
$TotalPages = ceil($Count['Total'] / $Config['_Items_Per_Page']);
$Start = $Page * $Config['_Items_Per_Page'] - $Config['_Items_Per_Page'];
$Offset = $Config['_Items_Per_Page'];
if ($Page > 0) {
if ($Page > $TotalPages) {
$Page = $TotalPages;
$Start = $Page * $Config['_Items_Per_Page'] - $Config['_Items_Per_Page'];
if ($Start < 0) {
$Start = 1;
}
}
$queryLimit = " LIMIT " . $Start . ", " . $Offset . " ";
//$Limit = "";
}
}
if (strtolower($Format) == 'pdf' && $limitOveride != false) {
if ($limitOveride = 'full') {
$queryLimit = '';
}
}
if (empty($Config['_Items_Per_Page'])) {
$queryLimit = '';
}
if (!empty($Format)) {
// XML Output
if (strtolower($Format) == 'xml') {
$apiOut .= " <page>" . $Page . "</page>\n";
$apiOut .= " <totalpages>" . $TotalPages . "</totalpages>\n";
$apiOut .= " <totalentries>" . $Count['Total'] . "</totalentries>\n";
}
//json output
if (strtolower($Format) == 'json') {
$apiOutput['totalpages'] = $TotalPages;
$apiOutput['totalentries'] = $Count['Total'];
}
}
// Select Query
//$Query = "SELECT count(b.Country) as TotalCountry, ".$querySelect." FROM `".$Config['_main_table']."` AS prim \n ".$queryJoin." \n ".$WhereTag." \n ".$queryWhere."\n GROUP BY b.Country \n ".$orderStr." \n ".$queryLimit.";"
if (!empty($Config['_useListTemplate']) && empty($Format)) {
$Media = $Element;
ob_start();
$Query = dr_BuildReportGrid($EID, $Page, $SortField, $SortDir, 'sql', $limitOveride, $wherePush);
//$WrapperEl = 'div';
if (!empty($Config['_TemplateWrapper'])) {
$WrapperEl = $Config['_TemplateWrapper'];
}
$Wrapperclasses = '';
if (!empty($Config['_TemplateClass'])) {
$Wrapperclasses = $Config['_TemplateClass'];
}
if (!empty($Config['_TemplateWrapper'])) {
echo '<' . $WrapperEl . ' id="reportPanel_' . $Media['ID'] . '" class="interfaceWrapper ' . $Wrapperclasses . '">';
}
include 'templatemode.php';
if (!empty($Config['_TemplateWrapper'])) {
echo '</' . $WrapperEl . '>';
}
return ob_get_clean();
}
$Query = "SELECT " . $querySelect . " FROM `" . $Config['_main_table'] . "` AS prim \n " . $queryJoin . " \n " . $WhereTag . " \n " . $queryWhere . "\n " . $groupBy . " \n " . $orderStr . " \n " . $queryLimit . ";";
if (strtolower($Format) == 'data') {
$dtaRes = mysql_query($Query);
$Data = mysql_fetch_assoc($dtaRes);
return $Data;
}
if (!empty($Config['_UserQueryOveride']) && !empty($Config['_QueryOveride'])) {
$Query = $Config['_QueryOveride'];
preg_match('/(LIMIT [ 0-9]+,[ 0-9]+)/', $Query, $Limits);
if (!empty($Limits[0])) {
$Query = str_replace($Limits[0], $queryLimit, $Query);
} else {
$Query .= $queryLimit;
}
}
//vardump($Query);
// Wrap fields with ``
//foreach($querySelects as $Field=>$FieldValue){
// echo $Field.' = '.$FieldValue.'<br />';
// $Query = str_replace('.'.$Field, '.`'.$Field.'`', $Query);
//}
if (!empty($Config['_UseCustomQuery']) && !empty($Config['_ManualQuery'])) {
$Query = $Config['_ManualQuery'];
preg_match('/(LIMIT [ 0-9]+,[ 0-9]+)/', $Query, $Limits);
if (!empty($Limits[0])) {
$Query = str_replace($Limits[0], $queryLimit, $Query);
} else {
$Query .= $queryLimit;
}
}
//echo $Query;
$QueryHash = md5($Query);
$_SESSION['queries'][$EID] = $Query;
if (!empty($Queries[$QueryHash])) {
$Result = $Queries[$QueryHash];
mysql_data_seek($Result, 0);
} else {
$Result = mysql_query($Query);
$Queries[$QueryHash] = $Result;
}
$_SESSION['queries'][$EID] = $Query;
//echo $Query;
if (strtolower($Format) == 'sql') {
return $Query;
}
if (!empty($exitNotice)) {
return;
//'<div id="'.$EID.'_wrapper"></div>';
}
$Result = $wpdb->get_results($Query, ARRAY_A);
// Run View Processes
if (!empty($Config['_ViewProcessors'])) {
foreach ($Config['_ViewProcessors'] as $viewProcess) {
if (empty($_GET['format_' . $EID])) {
//ignore on export
if (file_exists(DB_TOOLKIT . 'data_report/processors/' . $viewProcess['_process'] . '/functions.php')) {
include_once DB_TOOLKIT . 'data_report/processors/' . $viewProcess['_process'] . '/functions.php';
$func = 'pre_process_' . $viewProcess['_process'];
$Result = $func($Result, $viewProcess, $Config, $EID);
if (empty($Result)) {
return;
}
}
}
//if(file_exists($viewProcess['_process']))
}
}
//pre_process_
//$Result = mysql_query($Query);
if (!empty($Config['_chartOnly'])) {
return '<div id="chart_' . $ChartID . '" style="height:' . $height . 'px;"></div>';
//$ReportReturn;
}
// Build Rows
$ReportReturn .= '<tbody>';
// Row number Increment
$rowIndex = 1;
// Set Row Style
$Row = 'odd';
// add in inline editing
if (!empty($Config['_InlineEdit'])) {
$_SESSION['dataform']['OutScripts'] .= "\n\t\t\tjQuery('.inlineedit').bind('change', function(t){\n\t\t\t\tajaxCall('df_inlineedit', this.id, jQuery(this).attr('ref'), this.value, function(f){\n\t\t\t\t\tif(f != '1'){\n\t\t\t\t\t\tdf_dialog(f, jQuery(this).attr('ref'), '0');\n\t\t\t\t\t}\n\t\t\t\t});\n\t\t\t\t//alert(this.id+' - '+jQuery(this).attr('ref')+' - '+this.value);\n\t\t\t});\n\t\t";
}
if (!empty($Result)) {
if (!empty($Format)) {
// XML Output
if (strtolower($Format) == 'xml') {
$apiOut .= " <entrycount>" . count($Result) . "</entrycount>\n";
}
//json output
if (strtolower($Format) == 'json') {
$apiOutput['entrycount'] = count($Result);
}
}
//while($row = mysql_fetch_assoc($Result)) {
foreach ($Result as $row) {
// Switch Row Style
//$Row = dais_rowswitch($Row);
//$Row = report_rowswitch($Row);
$Row = grid_rowswitch($Row);
// foreach column
$SelectedRow = '';
if (!empty($Config['_ReturnFields'][0])) {
if (!empty($_GET[$Config['_ReturnFields'][0]])) {
if ($row['_return_' . $Config['_ReturnFields'][0]] == $_GET[$Config['_ReturnFields'][0]]) {
if (!empty($Config['_Show_Edit'])) {
$SelectedRow = 'highlight';
}
$HighlightIndex = true;
}
}
}
$ReportReturn .= '<tr class="' . $Row . ' itemRow_' . $EID . ' ' . $SelectedRow . ' report_entry" ref="' . $row['_return_' . $Config['_ReturnFields'][0]] . ' highlight" id="row_' . $EID . '_' . $rowIndex . '" >';
// API Output
if (!empty($Format)) {
// XML Output
if (strtolower($Format) == 'xml') {
$apiOut .= " <entry>\n";
}
// json Output
if (strtolower($Format) == 'json') {
$apiOutput['entries'][$jsonIndex] = array();
}
if (strtolower($Format) == 'pdf') {
//$apiOutput[$jsonIndex][] = array();
if (!empty($_SESSION['reportFilters'][$EID])) {
//$apiOutput['filters'] = array();
}
}
}
$ColumnCounter = 0;
//vardump($Config);
// action panels
// Edit Functions if no popup
$actionPanels = '';
if (!empty($ShowActionPanel)) {
$ViewLink = '';
$ActionWidth = 16;
if (!empty($Config['_Show_View'])) {
$ActionWidth = $ActionWidth + 16;
$ViewLink .= "<span style=\"cursor:pointer;\" onclick=\"df_loadEntry('" . $row['_return_' . $Config['_ReturnFields'][0]] . "', '" . $EID . "', " . $isModal . "); return false;\"><img src=\"" . WP_PLUGIN_URL . "/db-toolkit/data_report/css/images/magnifier.png\" width=\"16\" height=\"16\" alt=\"View\" title=\"View\" border=\"0\" align=\"absmiddle\" /></span>";
if (!is_admin()) {
if (!empty($Config['_ItemViewPage'])) {
$ReportVars = array();
foreach ($Config['_ReturnFields'] as $ReportReturnField) {
$ReportVars[$ReportReturnField] = urlencode($row['_return_' . $ReportReturnField]);
}
// Get permalink
$PageLink = get_permalink($Config['_ItemViewPage']);
$Location = parse_url($PageLink);
if (!empty($Location['query'])) {
$PageLink = str_replace('?' . $Location['query'], '', $PageLink);
parse_str($Location['query'], $gets);
$PageLink = $PageLink . '?' . htmlspecialchars_decode(http_build_query(array_merge($gets, $ReportVars)));
} else {
$PageLink = $PageLink . '?' . htmlspecialchars_decode(http_build_query($ReportVars));
}
$ViewLink = "<a href=\"" . $PageLink . "\"><img src=\"" . WP_PLUGIN_URL . "/db-toolkit/data_report/css/images/magnifier.png\" width=\"16\" height=\"16\" alt=\"View\" title=\"View\" border=\"0\" align=\"absmiddle\" /></a>";
}
}
}
if (!empty($Config['_Show_Edit'])) {
$ActionWidth = $ActionWidth + 16;
if ($ViewLink != '') {
$ViewLink .= " ";
}
$ViewLink .= '<span style="cursor:pointer;" onclick="dr_BuildUpDateForm(\'' . $EID . '\', \'' . $row['_return_' . $Config['_ReturnFields'][0]] . '\');"><img src="' . WP_PLUGIN_URL . '/db-toolkit/data_report/edit.png" width="16" height="16" alt="Edit" title="Edit" border="0" align="absmiddle" /></span>';
}
if (!empty($Config['_Show_Delete_action'])) {
$ActionWidth = $ActionWidth + 16;
if ($ViewLink != '') {
$ViewLink .= " ";
}
if (!empty($_GET)) {
$hasQuery = build_query($_GET);
} else {
$hasQuery = false;
}
$ViewLink .= '<span style="cursor:pointer;" onclick="dr_deleteItem(\'' . $EID . '\', \'' . $row['_return_' . $Config['_ReturnFields'][0]] . '\',\'' . $hasQuery . '\');"><img src="' . WP_PLUGIN_URL . '/db-toolkit/data_report/delete.png" width="16" height="16" alt="Delete" title="Delete" border="0" align="absmiddle" /></span>';
}
//vardump($Config);
$PreReportReturn = '<td class="' . $Row . ' action" width="' . $ActionWidth . '" scope="col" style="text-align:center;overflow:hidden;">';
$PreReportReturn .= $ViewLink;
//'Edit | View';
$PreReportReturn .= '</td>';
$actionPanels .= $PreReportReturn;
}
// Show Action Panels on left
//$ReportReturn .= $actionPanels;
foreach ($Config['_IndexType'] as $Field => $Type) {
//foreach ($row as $Field => $Data) {
if ($Type[1] === 1) {
break;
}
if (isset($row[$Field])) {
$Data = $row[$Field];
} else {
$Data = '';
}
if (!empty($Config['_IndexType'][$Field][1])) {
if ($Config['_IndexType'][$Field][1] == 'show') {
$outData = $Data;
/// Capture value for Totals
if (!empty($Config['_TotalsFields'][$Field]['Type'])) {
switch ($Config['_TotalsFields'][$Field]['Type']) {
case 'count':
//echo $Field.' = '.$Config['_TotalsFields'][$Field][$Config['_TotalsFields'][$Field]['Type']].'+1<br />';
$Config['_TotalsFields'][$Field][$Config['_TotalsFields'][$Field]['Type']] = $Count['TotalEntries'];
break;
case 'sum':
//echo $Field.' = '.$Config['_TotalsFields'][$Field][$Config['_TotalsFields'][$Field]['Type']].' + '.$outData.'<br />';
$Config['_TotalsFields'][$Field][$Config['_TotalsFields'][$Field]['Type']] = $Config['_TotalsFields'][$Field][$Config['_TotalsFields'][$Field]['Type']] + $outData;
break;
case 'avg':
//echo $Field.' = '.$Config['_TotalsFields'][$Field][$Config['_TotalsFields'][$Field]['Type']].' + '.$outData.'<br />';
$Config['_TotalsFields'][$Field][$Config['_TotalsFields'][$Field]['Type']] = $Config['_TotalsFields'][$Field][$Config['_TotalsFields'][$Field]['Type']] + $outData;
break;
}
}
if (function_exists($Config['_Field'][$Field][0] . '_processValue')) {
$processFunc = $Config['_Field'][$Field][0] . '_processValue';
// Value field type
$outData = $processFunc($Data, $Config['_Field'][$Field][1], $Field, $Config, $EID, $row);
}
// Capture columns average width for ato widths
$AvrageWidth[$Field][] = strlen($outData) * 8;
// Apply keyword Fitler Highlight
if (!empty($_SESSION['reportFilters'][$EID]['_keywords'])) {
//$outData = str_replace($_SESSION['reportFilters'][$EID]['_keywords'], '<strong>'.$_SESSION['reportFilters'][$EID]['_keywords'].'</strong>', $outData);
//$outData = str_replace(ucwords($_SESSION['reportFilters'][$EID]['_keywords']), '<strong>'.ucwords($_SESSION['reportFilters'][$EID]['_keywords']).'</strong>', $outData);
//$outData = str_replace(strtoupper($_SESSION['reportFilters'][$EID]['_keywords']), '<strong>'.strtoupper($_SESSION['reportFilters'][$EID]['_keywords']).'</strong>', $outData);
//$outData = str_replace(strtolower($_SESSION['reportFilters'][$EID]['_keywords']), '<strong>'.strtolower($_SESSION['reportFilters'][$EID]['_keywords']).'</strong>', $outData);
}
// set row output
//Check if field is in totals and is allowed inline
$Location = 'inline';
if (!empty($Config['_TotalsFields'][$Field]['Location'])) {
$Location = $Config['_TotalsFields'][$Field]['Location'];
}
if ($Location == 'inline' || $Location == 'headerinline' || $Location == 'footerinline') {
// selection highlighting (experimental)
$sortClass = '';
if (key_exists('SortField', $_SESSION['report_' . $EID]) && $_SESSION['report_' . $EID]['SortField'] == $Field) {
$sortClass = 'column_sorting_' . $_SESSION['report_' . $EID]['SortDir'];
}
$itemID = uniqid('');
// Add Reload Highlighting
$LiveHighlight = '';
$ReportReturn .= '<td class="' . $Row . ' ' . $sortClass . ' ' . $LiveHighlight . '" scope="col" id="' . $itemID . '" ref="itemRow_' . $EID . '" width="' . ($Config['_WidthOverride'][$Field] == '' ? '{{width_' . $Field . '}}px' : $Config['_WidthOverride'][$Field] . 'px') . '" style="text-align:' . $Config['_Justify'][$Field] . '; ">';
//inline editing
if (!empty($Config['_InlineEdit'][$Field])) {
$Req = 'inlineedit';
$FieldSet = $Config['_Field'][$Field];
//$ReportReturn .= WP_PLUGIN_DIR.'/db-toolkit/data_form/fieldtypes/'.$FieldSet[0].'/input.php';
ob_start();
$Defaults[$Field] = $row['_sourceid_' . $Field];
include WP_PLUGIN_DIR . '/db-toolkit/data_form/fieldtypes/' . $FieldSet[0] . '/conf.php';
include WP_PLUGIN_DIR . '/db-toolkit/data_form/fieldtypes/' . $FieldSet[0] . '/input.php';
$ReportReturn .= ob_get_clean();
} else {
$PreReportReturn = '';
// Make View Item Link If page is set
if (is_admin()) {
//vardump($Config);
if (!empty($Config['_ItemViewInterface'])) {
// Create return link
$ReportVars = array();
foreach ($Config['_ReturnFields'] as $ReportReturnField) {
$ReportVars[$ReportReturnField] = urlencode($row['_return_' . $ReportReturnField]);
}
// Get permalink
// interface admin.php?page=Database_Toolkit&renderinterface=dt_intfc4c04c77ed928a
if ($_GET['page'] != 'dbt_builder') {
if (!empty($Config['_SetDashboard'])) {
$Interface = get_option($EID);
$app = get_option('_' . $Interface['_Application'] . '_app');
if (!empty($app['landing'])) {
$pageLoc = 'app_' . $Interface['_Application'];
} else {
$pageLoc = $EID;
}
if (!empty($app['docked'])) {
$PageLink = 'admin.php?page=' . $pageLoc . '&sub=' . $Config['_ItemViewInterface'] . '&' . htmlspecialchars_decode(http_build_query($ReportVars));
} else {
$PageLink = 'admin.php?page=dbt_builder&renderinterface=' . $Config['_ItemViewInterface'] . '&' . htmlspecialchars_decode(http_build_query($ReportVars));
}
} else {
$PageLink = 'admin.php?page=' . $_GET['page'] . '&sub=' . $Config['_ItemViewInterface'] . '&' . htmlspecialchars_decode(http_build_query($ReportVars));
}
} else {
$PageLink = 'admin.php?page=dbt_builder&renderinterface=' . $Config['_ItemViewInterface'] . '&' . htmlspecialchars_decode(http_build_query($ReportVars));
}
$PreReportReturn .= "<a href=\"" . $PageLink . "\">";
}
} else {
if (!empty($Config['_ItemViewInterface']) && !empty($Config['_targetInterface'])) {
// Create return link
$url = !empty($_SERVER['HTTPS']) ? "https://" . $_SERVER['SERVER_NAME'] . $_SERVER['REQUEST_URI'] : "http://" . $_SERVER['SERVER_NAME'] . $_SERVER['REQUEST_URI'];
$url = strtok($url, '?');
$ReportVars = array();
foreach ($Config['_ReturnFields'] as $ReportReturnField) {
$ReportVars[$ReportReturnField] = urlencode($row['_return_' . $ReportReturnField]);
}
// Get permalink
// interface admin.php?page=Database_Toolkit&renderinterface=dt_intfc4c04c77ed928a
$op = '?';
if (strpos($url, '?') !== false) {
$op = '&';
}
$sendString = htmlspecialchars_decode(http_build_query($ReportVars));
$PageLink = $url . $op . $sendString;
//$sendString = implode('&', $ReturnFields);
//$PreReportReturn .= '<a id href="#'.$Config['_ItemViewInterface'].'" onclick="dr_pushResult(\''.$Config['_ItemViewInterface'].'\', \''.$sendString.'\'); return false;">'.$outData.'</a>';
$PreReportReturn .= "<a href=\"" . $PageLink . "\" onclick=\"dr_pushResult('" . $Config['_ItemViewInterface'] . "', '" . $sendString . "'); return false;\" >";
//$PreReportReturn .= "<a href=\"" . $PageLink . "\">";
}
if (!empty($Config['_ItemViewPage'])) {
// Create return link
$ReportVars = array();
foreach ($Config['_ReturnFields'] as $ReportReturnField) {
$ReportVars[$ReportReturnField] = urlencode($row['_return_' . $ReportReturnField]);
}
// Get permalink
$PageLink = get_permalink($Config['_ItemViewPage']);
$Location = parse_url($PageLink);
if (!empty($Location['query'])) {
$PageLink = str_replace('?' . $Location['query'], '', $PageLink);
parse_str($Location['query'], $gets);
$PageLink = $PageLink . '?' . htmlspecialchars_decode(http_build_query(array_merge($gets, $ReportVars)));
} else {
$PageLink = $PageLink . '?' . htmlspecialchars_decode(http_build_query($ReportVars));
}
$PreReportReturn .= "<a href=\"" . $PageLink . "\" >";
}
}
$ReturnFields = array();
if (is_array($Config['_ReturnFields'])) {
foreach ($Config['_ReturnFields'] as $ReturnField) {
$ReturnFields[] = $ReturnField . '=' . urlencode($row['_return_' . $ReturnField]);
}
}
//$ReturnMix = implode('&', $ReturnFields);
//$PreReportReturn .= '<a href="'.getdocument($_GET['PageData']['ID']).'#'.$ReturnMix.'">'.stripslashes($outData).'</a>';
// CREATE redirect pushing
if (!empty($Config['_layoutTemplate']['_Fields'][$Field])) {
if (!empty($outData)) {
$before = $Config['_layoutTemplate']['_Fields'][$Field]['_before'];
$after = $Config['_layoutTemplate']['_Fields'][$Field]['_after'];
foreach ($row as $repField => $repValue) {
$before = str_replace('{{' . $repField . '}}', $repValue, $before);
$after = str_replace('{{' . $repField . '}}', $repValue, $after);
}
$PreReportReturn .= $before;
}
}
$PreReportReturn .= $outData;
if (!empty($Config['_layoutTemplate']['_Fields'][$Field])) {
if (!empty($outData)) {
$PreReportReturn .= $after;
}
}
// API Output
if (!empty($Format)) {
// XML Output
if (strtolower($Format) == 'xml') {
if (!is_integer($outData)) {
$apiOut .= " <" . $Field . "><![CDATA[" . stripslashes($outData) . "]]></" . $Field . ">\n";
} else {
$apiOut .= "\t<" . $Field . ">" . stripslashes($outData) . "</" . $Field . ">\n";
}
}
// json Output
if (strtolower($Format) == 'json') {
$apiOutput['entries'][$jsonIndex][$Field] = $outData;
//echo $outData;
}
// PDF output
if (strtolower($Format) == 'pdf') {
$apiOutput[$pdfIndex][$Field] = stripslashes($outData);
if (!empty($_SESSION['reportFilters'][$EID][$Field])) {
$apiOutput['filters'][$Field][stripslashes($outData)] = stripslashes($outData);
}
}
}
// Close link
if (!empty($Config['_ItemViewPage'])) {
$PreReportReturn .= "</a>";
}
if (!empty($Config['_ItemViewInterface'])) {
$PreReportReturn .= "</a>";
}
if (!empty($Config['_ItemViewInterface']) && !empty($Config['_targetInterface'])) {
$PreReportReturn .= "</a>";
}
}
$ReportReturn .= $PreReportReturn;
if (!empty($Config['_Show_popup'])) {
if ($ColumnCounter === 0) {
// Add inline actions
$ViewLink = '';
$ActionWidth = 16;
if (!empty($Config['_Show_View'])) {
$ActionWidth = $ActionWidth + 16;
$ViewLink['view'] = "<a href=\"#\" onclick=\"return false;\"><span style=\"cursor:pointer;\" onclick=\"df_loadEntry('" . $row['_return_' . $Config['_ReturnFields'][0]] . "', '" . $EID . "', " . $isModal . "); return false;\">View</span></a>";
if (is_admin()) {
if (!empty($Config['_ItemViewInterface'])) {
$ReportVars = array();
foreach ($Config['_ReturnFields'] as $ReportReturnField) {
$ReportVars[$ReportReturnField] = urlencode($row['_return_' . $ReportReturnField]);
}
// Get permalink
// check if its in a menu
$inf = get_option($Config['_ItemViewInterface']);
if (empty($inf['_ItemGroup']) && empty($inf['_interfaceName'])) {
$PageLink = 'admin.php?page=dbt_builder&renderinterface=' . $Config['_ItemViewInterface'] . '&' . htmlspecialchars_decode(http_build_query($ReportVars));
} else {
$PageLink = 'admin.php?page=' . $Config['_ItemViewInterface'] . '&' . htmlspecialchars_decode(http_build_query($ReportVars));
}
$ViewLink['view'] = "<a href=\"" . $PageLink . "\">View</a>";
}
} else {
if (!empty($Config['_ItemViewPage'])) {
$ReportVars = array();
foreach ($Config['_ReturnFields'] as $ReportReturnField) {
$ReportVars[$ReportReturnField] = urlencode($row['_return_' . $ReportReturnField]);
}
// Get permalink
$PageLink = get_permalink($Config['_ItemViewPage']);
$Location = parse_url($PageLink);
if (!empty($Location['query'])) {
$PageLink = str_replace('?' . $Location['query'], '', $PageLink);
parse_str($Location['query'], $gets);
$PageLink = $PageLink . '?' . htmlspecialchars_decode(http_build_query(array_merge($gets, $ReportVars)));
} else {
$PageLink = $PageLink . '?' . htmlspecialchars_decode(http_build_query($ReportVars));
}
$ViewLink['view'] = "<a href=\"" . $PageLink . "\">View</a>";
}
}
}
if (!empty($Config['_Show_Edit'])) {
$ActionWidth = $ActionWidth + 16;
$ViewLink['edit'] = '<a href="#" onclick="return false;"><span style="cursor:pointer;" onclick="dr_BuildUpDateForm(\'' . $EID . '\', \'' . $row['_return_' . $Config['_ReturnFields'][0]] . '\');">Edit</span></a>';
}
if (!empty($Config['_Show_Delete_action'])) {
$ActionWidth = $ActionWidth + 16;
$ViewLink['delete'] = '<a href="#" onclick="return false;"><span style="cursor:pointer;" class="delete" onclick="dr_deleteItem(\'' . $EID . '\', \'' . $row['_return_' . $Config['_ReturnFields'][0]] . '\');">Delete</span></a>';
}
//vardump($Config);
//$PreReportReturn = '<td class="'.$Row.' action" width="'.$ActionWidth.'" scope="col" style="text-align:center;overflow:hidden;">';
$ReportReturn .= '<div class="row-actions">' . implode(' | ', $ViewLink) . '</div>';
//'Edit | View';
//$PreReportReturn .= '</td>';
//$ReportReturn .= $PreReportReturn;
}
}
$ReportReturn .= '</td>';
}
}
}
$ColumnCounter++;
}
// API Output
if (!empty($Format)) {
// XML Output
if (strtolower($Format) == 'xml') {
$apiOut .= " </entry>\n";
}
// json Output
if (strtolower($Format) == 'json') {
$jsonIndex++;
}
//PDF Output
if (strtolower($Format) == 'pdf') {
$pdfIndex++;
}
}
// Show Action Panelson right
$ReportReturn .= $actionPanels;
$ReportReturn .= '</tr>';
// Increment row index
$rowIndex++;
}
}
//echo mysql_error();
// Close off Table end content
$ReportReturn .= '</tbody>';
$ReportReturn .= '</table>';
// Make Scripts for deleting and select
if (empty($Config['_Feature_Selectable_Rows'])) {
$_SESSION['dataform']['OutScripts'] .= "\n\t\tjQuery('#data_report_" . $EID . " .report_entry').bind('click', function(){\n\t\t\tjQuery(this).toggleClass(\"highlight\");\n\t\t});\n\t";
}
// Footer
//TODO: really need to clean up this templating. to much repetition
if (!empty($Config['_Show_Footer'])) {
$First = 1;
$Prev = $Page - 1;
$Next = $Page + 1;
$Last = $TotalPages;
if ($Prev <= 0) {
$Prev = 1;
}
if ($Next > $TotalPages) {
$Next = $TotalPages;
}
if (empty($Page)) {
$Page = 1;
}
//Page Index display
$toPos = $Page * $Offset;
if ($toPos > $Count['Total']) {
$toPos = $Count['Total'];
}
$pageLink = '';
if (!empty($_SERVER['QUERY_STRING'])) {
$pageLink = $_SERVER['QUERY_STRING'] . '&';
}
//$ReportReturn .= '<div style="padding:3px;" class="list_row3">';
$ReportReturn .= '<div style="padding:3px;" class="tablenav bottom">';
//Total pages display
$ReportReturn .= '<div class="tablenav-pages">';
// Check if there are any entries
if ($Count['Total'] == 0) {
$nothingFound = 'Nothing Found';
if (!empty($Config['_NoResultsText'])) {
$nothingFound = $Config['_NoResultsText'];
}
$ReportReturn .= '<span class="displaying-num">' . $nothingFound . '</span>';
} else {
$footerPrefix = $Start + 1 . ' - ' . $toPos . ' of ';
if (empty($Config['_Items_Per_Page'])) {
$footerPrefix = '';
}
$ReportReturn .= '<span class="displaying-num">' . $footerPrefix . $Count['Total'] . ' Items</span>';
}
//$ReportReturn .= '<div class="reportFooter_totals">';
if ($TotalPages > 1) {
//$ReportReturn .= '<div class="fbutton" onclick="dr_goToPage('.$EID.', '.$First.');"><div><img src="'.WP_PLUGIN_DIR.'/db-toolkit/data_report/images/resultset_first.png" width="16" height="16" alt="First" align="absmiddle" /></div></div>';
$ReportReturn .= '<a href="?' . $pageLink . 'npage=1" title="Go to the first page" class="first-page" onclick="dr_goToPage(\'' . $EID . '\', 1); return false;">«</a>';
$ReportReturn .= '<a href="?' . $pageLink . 'npage=' . $Prev . '" title="Go to the previous page" class="prev-page" onclick="dr_goToPage(\'' . $EID . '\', ' . $Prev . '); return false;">‹</a>';
$ReportReturn .= '<span class="paging-input"> ' . $Page . ' of <span class="total-pages">' . $TotalPages . ' </span></span>';
$ReportReturn .= '<a href="?' . $pageLink . 'npage=' . $Next . '" title="Go to the next page" class="next-page" onclick="dr_goToPage(\'' . $EID . '\', ' . $Next . '); return false;">›</a>';
$ReportReturn .= '<a href="?' . $pageLink . 'npage=' . $TotalPages . '" title="Go to the last page" class="last-page" onclick="dr_goToPage(\'' . $EID . '\', ' . $TotalPages . '); return false;">»</a>';
//$ReportReturn .= '<div class="fbutton" onclick="dr_goToPage('.$EID.', '.$Last.');"><div><img src="'.WP_PLUGIN_DIR.'/db-toolkit/data_report/images/resultset_last.png" width="16" height="16" alt="Last" align="absmiddle" /></div></div>';
}
$ReportReturn .= '<br class="clear"></div>';
$ReportReturn .= '</div>';
}
//query
if (is_admin()) {
if (!empty($_GET['debug'])) {
//$ReportReturn .= '<div id="'.$EID.'_queryDebug" class="button" style="cursor:pointer; width:100px; text-align: center;" onclick="jQuery(\'#'.$EID.'_queryDebug_panel\').toggle();">Show Query</div>';
$ReportReturn .= '<div id="' . $EID . '_queryDebug_panel" style="display:block;">';
$ReportReturn .= '<textarea style="width:99%; height:200px;">' . $CountQuery . '</textarea><br />';
$ReportReturn .= '<textarea style="width:99%; height:200px;">' . $Query . '</textarea><br />';
$ReportReturn .= 'ERRORS: ' . mysql_error();
//$ReportReturn .= '</div>';
}
}
//dump($Config);
// Create Header and Footer Totals
if (!empty($Config['_TotalsFields'])) {
if (!empty($Format)) {
// XML Output
if (strtolower($Format) == 'xml') {
//$apiOut .= " </entry>\n";
}
// json Output
if (strtolower($Format) == 'json') {
// $jsonIndex++;
}
//PDF Output
if (strtolower($Format) == 'pdf') {
// $pdfIndex++;
$apiOutput['Totals'] = array();
//$apiOutput = array();
//$apiOutput['
}
}
$header = '<div class="list_row1">';
$footer = '<div class="list_row2">';
$hcount = 0;
$fcount = 0;
foreach ($Config['_TotalsFields'] as $Field => $TotalsSet) {
//dump($TotalsSet);
if ($TotalsSet['Location'] == 'headerinline') {
$TotalsSet['Location'] = 'header';
}
if ($TotalsSet['Location'] == 'footerinline') {
$TotalsSet['Location'] = 'footer';
}
$box = '<div class="stuffbox" style="width:{{width_' . $TotalsSet['Location'] . '}}%; float:left;">';
if (!empty($TotalsSet['Title'])) {
$Title = df_parseCamelCase($TotalsSet['Title']);
}
$OutValue = round($TotalsSet[$TotalsSet['Type']], 2);
if ($TotalsSet['Function'] == 'VAT') {
$OutValue = totals_vat($OutValue);
}
if ($TotalsSet['Function'] == 'AddVAT') {
$OutValue = totals_addvat($OutValue);
}
$Title = df_parseCamelCase($Field);
$Caption = ' ';
if (!empty($TotalsSet['Caption'])) {
$Caption = $TotalsSet['Caption'];
}
/// Outputs
if (!empty($Format)) {
// XML Output
if (strtolower($Format) == 'xml') {
// $apiOut .= " </entry>\n";
}
// json Output
if (strtolower($Format) == 'json') {
// $jsonIndex++;
}
//PDF Output
if (strtolower($Format) == 'pdf') {
$apiOutput['Totals'][$Title] = $TotalsSet['Prefix'] . $OutValue . $TotalsSet['Suffix'] . ' ' . $Caption;
}
}
$box .= '<h3>' . $Title . '</h3>';
$box .= '<div class="inside"><h1>' . $TotalsSet['Prefix'] . $OutValue . $TotalsSet['Suffix'] . '</h1></div>';
$box .= '<div class="inside">' . $Caption . '</div>';
$box .= '</div>';
if (!empty(${$TotalsSet}['Location'])) {
${$TotalsSet}['Location'] .= $box;
}
switch ($TotalsSet['Location']) {
case 'header':
$hcount++;
break;
case 'footer':
$fcount++;
break;
}
}
$header .= '<div style="clear:both;"></div></div>';
$footer .= '<div style="clear:both;"></div></div>';
}
if (!empty($hcount)) {
if ($hcount >= 1) {
$header = str_replace('{{width_header}}', 100 / $hcount - 3, $header);
}
}
if (!empty($fcount)) {
if ($fcount >= 1) {
$footer = str_replace('{{width_footer}}', 100 / $fcount - 3, $footer);
}
}
// Run Final Totals Functions on return data
if (!empty($GLOBALS['Totals'][$EID])) {
foreach ($GLOBALS['Totals'][$EID] as $Key => $Output) {
$Total = $Config['_TotalsFields'][$Output['Field']][$Config['_TotalsFields'][$Output['Field']]['Type']];
if (!empty($GLOBALS['TotalsAverages'][$EID][$Output['Field']]['PreAverage'])) {
if (empty($AverageBar)) {
//foreach$Output['PreAverage']
$avT = 0;
foreach ($GLOBALS['TotalsAverages'][$EID][$Output['Field']]['PreAverage'] as $val) {
$avT = $avT + $val;
}
$AverageBar = ceil($avT / count($GLOBALS['TotalsAverages'][$EID][$Output['Field']]['PreAverage']));
}
$Total = $AverageBar;
}
$func = 'totals_' . $Output['Function'];
$newValue = $func($Output['Value'], $Total);
$ReportReturn = str_replace($Key, $newValue, $ReportReturn);
}
}
// Set Auto Widths to Averages
if (!empty($AvrageWidth)) {
foreach ($AvrageWidth as $Field => $Value) {
$Tmp = 0;
foreach ($Value as $Num) {
$Tmp = $Tmp + $Num;
}
$Av = ceil($Tmp / count($Value));
if (!empty($minWidth[$Field])) {
if ($Av < $minWidth[$Field]) {
$Av = $minWidth[$Field];
}
}
$Av = '';
$ReportReturn = str_replace('width="{{width_' . $Field . '}}px"', $Av, $ReportReturn);
}
}
//dump($Config);
//echo $Query;
// API Output
if (!empty($Format)) {
// XML Output
if (strtolower($Format) == 'xml') {
return $apiOut . "\n\t</entries>";
}
// json Output
if (strtolower($Format) == 'json') {
//$apiOutput;
//vardump($apiOutput);
return json_encode($apiOutput);
}
// PDF Output
if (strtolower($Format) == 'pdf') {
//$apiOutput;
return $apiOutput;
}
}
return do_shortcode($ReportReturn);
}
