示例#1
0
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>';