function comlete_chart_session_default_values($isedit = "") { $root =& $_SESSION["webcharts"]; $table = $root['tables'][0]; $arr_fields = WRGetNBFieldsList($table); $arr_fields_all = WRGetFieldsList($table); $root['chart_type'] = array("type" => "2d_column"); $arr_data_series = array(); $arr_label_series = array(); get_chart_series_fields($arr_data_series, $arr_label_series); $datafield = array("field" => $arr_fields[0], "label" => WRChartLabel($arr_fields[0])); $labelfield = $datafield; if (count($arr_label_series)) { $labelfield = $arr_label_series[0]; $ttable = ""; $tfield = ""; WRSplitFieldName($labelfield["field"], $ttable, $tfield); $labelfield["field"] = $tfield; } if (count($arr_data_series)) { $datafield = $arr_data_series[0]; $ttable = ""; $tfield = ""; WRSplitFieldName($datafield["field"], $ttable, $tfield); $datafield["field"] = $tfield; } $root['parameters'] = array(array("name" => $datafield["field"], "ohlcOpen" => $datafield["field"], "ohlcClose" => $datafield["field"], "ohlcHigh" => $datafield["field"], "ohlcLow" => $datafield["field"], "table" => $table, "agr_func" => "", "label" => $datafield["label"]), array("name" => $labelfield["field"], "table" => $table, "agr_func" => "", "label" => "undefined")); $root['fields'] = array(); foreach ($arr_fields_all as $fld) { $root['fields'][] = array("name" => $fld, "label" => WRChartLabel($fld), "search" => ""); } $root['appearance']["series_color"] = "FF0000"; $root['appearance']["color51"] = ""; $root['appearance']["color52"] = ""; $root['appearance']["color61"] = ""; $root['appearance']["color62"] = ""; $root['appearance']["color71"] = ""; $root['appearance']["color72"] = ""; $root['appearance']["color81"] = ""; $root['appearance']["color82"] = ""; $root['appearance']["color91"] = ""; $root['appearance']["color92"] = ""; $root['appearance']["color101"] = ""; $root['appearance']["color102"] = ""; $root['appearance']["color111"] = ""; $root['appearance']["color112"] = ""; $root['appearance']["color121"] = ""; $root['appearance']["color122"] = ""; $root['appearance']["color131"] = ""; $root['appearance']["color132"] = ""; $root['appearance']["color141"] = ""; $root['appearance']["color142"] = ""; $root['appearance']["slegend"] = "true"; $root['appearance']["sgrid"] = "true"; $root['appearance']["sname"] = "true"; $root['appearance']["sval"] = "true"; $root['appearance']["sanim"] = "true"; $root['appearance']["scur"] = "false"; $root['appearance']["sstacked"] = "false"; $root['appearance']["saxes"] = "false"; $root['appearance']["slog"] = "false"; $root['appearance']["dec"] = "2"; $root['appearance']["head"] = $root['tables'][0] . ' Chart ' . CheckLastID('chart'); $root['appearance']["foot"] = $root['tables'][0] . ' Chart ' . CheckLastID('chart'); $root['appearance']["aqua"] = "0"; $root['appearance']["cview"] = "0"; $root['appearance']["is3d"] = "false"; $root['appearance']["isstacked"] = "false"; $root['appearance']["cscroll"] = "true"; $root['appearance']["autoupdate"] = "false"; $root['appearance']["maxbarscroll"] = "10"; $root['appearance']["update_interval"] = "5"; $root['appearance']["accumulstyle"] = "0"; $root['appearance']["accumulinvert"] = "false"; $root['appearance']["linestyle"] = "0"; $root['appearance']["gaugestyle"] = "0"; if (!$isedit) { $root['settings'] = array("name" => GoodFieldName($root['tables'][0]) . '_' . CheckLastID('chart'), "title" => $root['tables'][0] . ' Chart ' . CheckLastID('chart'), "status" => "private", "owner" => $_SESSION["UserID"], "table_name" => $root['tables'][0], "short_table_name" => GetTableURL($root['tables'][0])); $_SESSION["webobject"]["name"] = GoodFieldName($root['tables'][0]) . '_' . CheckLastID('chart'); $root['owner'] = $_SESSION["UserID"]; $_SESSION['webcharts']['tmp_active'] = "x"; } else { $root['settings'] = array("name" => $_SESSION['webcharts']['settings']['name'], "title" => $_SESSION['webcharts']['settings']['title'], "status" => $_SESSION['webcharts']['settings']['status'], "owner" => $_SESSION['webcharts']['settings']['owner'], "table_name" => $root['tables'][0], "short_table_name" => GetTableURL($root['tables'][0])); } $root['table_name'] = $root['tables'][0]; $root['short_table_name'] = GetTableURL($root['tables'][0]); }
if ( !empty( $root['group_by_condition'][0] ) ) { for ($i=0; $i < count($root['group_by_condition'])-1; $i++) { $arr = $root['group_by_condition'][$i]; if ( rawurldecode($arr['group_by_value']) != "-1" && rawurldecode($arr['group_by_value']) != "GROUP BY" ) { $arr_group_by[rawurldecode($arr['field_opt'])]["agr_func"] = rawurldecode($arr['group_by_value']); $arr_group_by[rawurldecode($arr['field_opt'])]["label"] = rawurldecode($arr['group_by_value'])."(".rawurldecode($arr['field_opt']).")"; } } } */ $arr_data_series=array(); $arr_label_series=array(); get_chart_series_fields($arr_data_series,$arr_label_series); foreach ( $arr_data_series as $arr ) { $dataSeries .= '<option value="'.runner_htmlspecialchars($arr["field"]).'">'.runner_htmlspecialchars($arr["field"]).'</option>'; $b_includes .= 'fld_labels[\''.jsreplace($arr["field"]).'\'] = \'' . jsreplace($arr["label"]) . '\';'."\r\n"; } $xt->assign("dataSeries", $dataSeries); $strLabel = ""; foreach ( $arr_label_series as $arr ) { $strLabel .= '<option value="'.runner_htmlspecialchars($arr["field"]).'">'.runner_htmlspecialchars($arr["field"]).'</option>'; } /* foreach ($arr_label_series as $arr) { $strLabel .= '<option value="'.$arr["table"].'.'.$arr["name"].'">'.$arr["table"].'.'.$arr["name"].'</option>';