if(is_wr_project()) { foreach ($arr_join_tables as $tbl) { include_once("include/" . GetTableURL($tbl) . "_settings.php"); } } if (postvalue("rname")) { $inspect_fields = $xml_array["totals"]; } elseif (postvalue("cname")) { //$inspect_fields = $xml_array["parameters"]; $inspect_fields = array(); for ($i=0; $i < count($arr_join_tables); $i++ ) { $t = $arr_join_tables[$i]; $arr_fields = WRGetNBFieldsList($t); for ($j=0; $j < count($arr_fields); $j++) { $slabel=$arr_fields[$j]; for ($k=0; $k < count($xml_array["parameters"])-1; $k++) if($xml_array["parameters"][$k]["name"]==$slabel) { $slabel=$xml_array["parameters"][$k]["label"]; break; } $inspect_fields[] = array("table" => $t, "name" => $arr_fields[$j], "show" => "true", "label" => $slabel); } } } //} $pageName = GetTableLink("dsearch");
function get_chart_series_fields(&$arr_data_series, &$arr_label_series) { if (is_groupby_chart()) { return get_chart_groupbyseries_fields($arr_data_series, $arr_label_series); } $root =& $_SESSION['webcharts']; $arr_data_series = array(); $arr_label_series = array(); $arr_join_tables = getChartTablesList(); for ($i = 0; $i < count($arr_join_tables); $i++) { $t = $arr_join_tables[$i]; $arr_fields = GetNumberFieldsList($t); for ($j = 0; $j < count($arr_fields); $j++) { if (!is_wr_custom()) { $arr_data_series[] = array("field" => $t . "." . $arr_fields[$j], "label" => WRChartLabel($t . "." . $arr_fields[$j])); } else { $arr_data_series[] = array("field" => $arr_fields[$j], "label" => WRChartLabel($arr_fields[$j])); } } $arr_fields = WRGetNBFieldsList($t); for ($j = 0; $j < count($arr_fields); $j++) { if (!is_wr_custom()) { $arr_label_series[] = array("field" => $t . "." . $arr_fields[$j], "label" => WRChartLabel($t . "." . $arr_fields[$j])); } else { $arr_label_series[] = array("field" => $arr_fields[$j], "label" => WRChartLabel($arr_fields[$j])); } } } if (!count($arr_data_series)) { $arr_data_series = $arr_label_series; } }
function set_default_chart_parameter($idx, $labelMode, $addLabel) { $root =& $_SESSION["webcharts"]; $arr_join_tables = getChartTablesList(); if (is_groupby_chart()) { for ($i = 0; $i < count($root["group_by_condition"]) - 1; $i++) { if (!$root["group_by_condition"][$i]["group_by_value"]) { continue; } $type = WRGetFieldType($root["group_by_condition"][$i]["field_opt"]); $grvalue = $root["group_by_condition"][$i]["group_by_value"]; if (!$labelMode && (IsNumberType($type) || $grvalue != "GROUP BY") || $labelMode) { $table = ""; $field = ""; WRSplitFieldName($root["group_by_condition"][$i]["field_opt"], $table, $field); $root["parameters"][$idx]["name"] = $field; $root["parameters"][$idx]["table"] = $table; if ($grvalue != "GROUP BY") { $root["parameters"][$idx]["agr_func"] = $grvalue; } if ($addLabel) { $root["parameters"][$idx]["label"] = $field; } break; } } } else { foreach ($arr_join_tables as $tbl) { if (!$labelMode) { $fields = GetNumberFieldsList($tbl); } else { $fields = WRGetNBFieldsList($tbl); } if (count($fields)) { $root["parameters"][$idx]["name"] = $fields[0]; $root["parameters"][$idx]["table"] = $tbl; $root["parameters"][$idx]["agr_func"] = ""; if ($addLabel) { $root["parameters"][$idx]["label"] = WRChartLabel($tbl . "." . $fields[0]); } break; } } } }
} $aGroupFields = array(); //$aGroupFields = $sGroupFields; $aTypes = array(); $aChecked = array(); $aColor1 = array(); $aColor2 = array(); $aGrTypes=array(); $arr = $_SESSION['webreports']['group_fields']; if(count($arr)==1) { $arr[]=$arr[0]; $table=@$_SESSION['webreports']['tables'][0]; $arr_fields = WRGetNBFieldsList($table); $gfield=$arr_fields[0]; if(is_wr_db()) $gfield=$table.".".$arr_fields[0]; $arr[0] = array( array( "name" => $gfield, "int_type" => "0", "ss" => "true", "group_order" => "1", "color1" => "FF0000", "color2" => "CC0000" ) );
$stable=substr($stable,25)."..."; $xt->assign("report_table",", "."Table".": ".$stable); } else { $xt->assign("report_table",""); } $xt->assign("b_is_report_save",($_SESSION['webreports']['tmp_active'] != "x")); $xt->assign("b_is_report_name",($_SESSION['webreports']['settings']['name'] != "")); $xt->assign("report_name",$_SESSION['webreports']['settings']['name']); $arr_tables = getReportTablesList(); $sort_fields=array(); foreach($arr_tables as $t) { $tfields=WRGetNBFieldsList($t); foreach($tfields as $f) { if(is_wr_db()) $sort_fields[]=$t.".".$f; else $sort_fields[]=$f; } } $aSelSortFields=array(); $arr = $_SESSION['webreports']['group_fields']; if ( !empty( $arr ) ){ for ( $i=0; $i < count($arr)-1; $i++ ) { $aSelSortFields[$i]["name"] = $arr[$i]["name"];