Witajcie,
Próbuję za pomocą
http://www.maani.us/xml_charts wygenerować sobie prosty (jak mi się wydawało) wykres. Ma on wyświetlać wyniki graczy.
Tabele:
GAME, PLAYER oraz ENTRY (wyjaśnień chyba nie potrzeba).
Wykres się generuje, ale mam "przesunięcie" - tzn nie generuje się na poziomej osi pierwsza wartość, z kolei w wynikach (słupkach) nie pokazuje się wynik ostatni. Męczę się z tym już 2 dzień, gdzieś pewnie jakiś iterator....
Zerkniecie? Z góry dzięki.
//********************************************************************************
*
// Terminy gier
//********************************************************************************
*
$query1 = "SELECT G_ID, G_DATE FROM GAME WHERE G_STATS = 1";
$terminy_gier[$row1[0]] = $row1[1];
}
//********************************************************************************
*
// ID i LOGIN
//********************************************************************************
*
$query2 = "SELECT DISTINCT P_ID, P_LOGIN FROM PLAYER INNER JOIN ENTRY ON P_ID = E_P_ID WHERE E_RESULT IS NOT NULL";
$wyniki[$row2[0]][0] = $row2[1];
}
//********************************************************************************
*
// Wyniki
//********************************************************************************
*
$query3 = "SELECT E_P_ID, E_G_ID, E_RESULT FROM ENTRY WHERE E_RESULT IS NOT NULL";
$wyniki[$row3[0]][$row3[1]] = $row3[2];
}
//********************************************************************************
*
// Wygenerowanie wykresu
//********************************************************************************
*
include "../charts/charts.php";
//pozioma skala
$chart[ 'axis_category' ] = array ( 'size'=>10, 'color'=>"ffffff", 'alpha'=>50, 'font'=>"arial", 'bold'=>true
, 'skip'=>0 ,'orientation'=>"vertical_up" ); //pionowa skala
$chart[ 'axis_value' ] = array ( 'min'=>-200, 'max'=>200, 'font'=>"arial", 'bold'=>true
, 'size'=>10, 'color'=>"ffffff", 'alpha'=>50, 'steps'=>8, 'prefix'=>"", 'suffix'=>"", 'decimals'=>2, 'separator'=>"", 'show_min'=>true
); //podzialki na pionowej skali
$chart[ 'axis_ticks' ] = array ( 'value_ticks'=>true
, 'category_ticks'=>true
, 'major_thickness'=>2, 'minor_thickness'=>1, 'minor_count'=>1, 'major_color'=>"000000", 'minor_color'=>"222222" ,'position'=>"outside" ); //poziomy grid line
$chart[ 'chart_grid_h' ] = array ( 'alpha'=>10, 'color'=>"000000", 'thickness'=>1, 'type'=>"solid" ); //pionowy grid line
$chart[ 'chart_grid_v' ] = array ( 'alpha'=>10, 'color'=>"000000", 'thickness'=>1, 'type'=>"solid" ); //ramka wykresu
$chart[ 'chart_border' ] = array ( 'color'=>"000000", 'top_thickness'=>2, 'bottom_thickness'=>2, 'left_thickness'=>2, 'right_thickness'=>2
); //preferencje wykresu
$chart[ 'chart_pref' ] = array ( 'line_thickness'=>2, 'point_shape'=>"none", 'fill_shape'=>false
); //tlo wykresu
$chart[ 'chart_rect' ] = array ( 'x'=>70, 'y'=>25, 'width'=>500, 'height'=>200, 'positive_color'=>"000000", 'positive_alpha'=>30, 'negative_color'=>"ff0000", 'negative_alpha'=>10
); //typ wykresu
$chart[ 'chart_type' ] = "column";
//wartosci na wykresie
$chart[ 'chart_value' ] = array ( 'prefix'=>"", 'suffix'=>"", 'decimals'=>2, 'separator'=>"", 'position'=>"cursor", 'hide_zero'=>true
, 'as_percentage'=>false
, 'font'=>"arial", 'bold'=>true
, 'size'=>12, 'color'=>"ffffff", 'alpha'=>75
); //Opis i inne
$chart[ 'draw' ] = array ( array ( 'type'=>"text", 'color'=>"ffffff", 'alpha'=>15, 'font'=>"arial", 'rotation'=>-90, 'bold'=>true
, 'size'=>30, 'x'=>0, 'y'=>250, 'width'=>250, 'height'=>150, 'text'=>"Wynik w PLN", 'h_align'=>"center", 'v_align'=>"top" ), array ( 'type'=>"text", 'color'=>"000000", 'alpha'=>15, 'font'=>"arial", 'rotation'=>0, 'bold'=>true
, 'size'=>30, 'x'=>275, 'y'=>50, 'width'=>200, 'height'=>270, 'text'=>"Gry", 'h_align'=>"left", 'v_align'=>"bottom" ) ); //legenda
$chart[ 'legend_rect' ] = array ( 'x'=>580, 'y'=>30, 'width'=>80, 'height'=>40, 'margin'=>3
); //legenda
$chart[ 'legend_label' ] = array ( 'layout'=>"vertical", 'bullet'=>"square", 'font'=>"arial", 'bold'=>false
, 'size'=>9, 'color'=>"000000" ); //kolory wykresow
$chart[ 'series_color' ] = array ( "FFFF00", "FFFFFF", "cc5511", "800000", "FF0000","800080","FF00FF","008000","00FF00","91BDD3","C0C0C0", "000080", "0000FF" ); //dane
$chart[ 'chart_data' ] = array ($terminy_gier, $wyniki[3
], $wyniki[4
], $wyniki[9
], $wyniki[13
], $wyniki[29
]); //
SendChartData ( $chart );