Hello:
Android had couple charts engines like android chart engine, etc, i am using that pluggin for my app, you see i need to chart data in a pie chart, but i dont know how to do it, becuase i have a class called dbquery that had this:
[HIGH]
public Cursor returnQuery()
{
Cursor c = db.rawQuery("SELECT LAST_NAME, SUM(PRICE) + Tbl_SALES", null);
c.close();
return c;
}
[/HIGH]
and another one called CreatePieChart
[HIGH]
private void CreatePieChart()
{
Cursor c= dbquery.returnQuery();
String[] concept = new String[] { "Jimmy" , "$500" };
double[] porcent = { 40, 40 };
int[] colors = { Color.MAGENTA, Color.GREEN };
CategorySeries distributionSerie = new CategorySeries("CUSTOMER");
for (int i = 0; i < porcent .length; i++)
{
// Adding a slice with its values and name to the Pie Chart
distributionSerie.add(concept, porcent );
}
// Instantiating a renderer for the Pie Chart
DefaultRenderer defaultRenderer = new DefaultRenderer();
for (int i = 0; i < porcent .length; i++) {
SimpleSeriesRenderer seriesRenderer = new SimpleSeriesRenderer();
seriesRenderer.setColor(colors);
seriesRenderer.setDisplayChartValues(true);
// Adding a renderer for a slice
defaultRenderer.addSeriesRenderer(seriesRenderer);
}
defaultRenderer.setLegendTextSize(30);
defaultRenderer.setChartTitle("Customer");
defaultRenderer.setChartTitleTextSize(20);
defaultRenderer.setZoomButtonsVisible(true);
defaultRenderer.setBackgroundColor(45454545);
defaultRenderer.setLabelsColor(45454532);
// Creating an intent to plot bar chart using dataset and
// multipleRenderer
Intent intent = ChartFactory.getPieChartIntent(getBaseContext(),
distributionSerie, defaultRenderer,
"PieChart");
// Start Activity
startActivity(intent);
[/HIGH]
now the real question is: How to replace this arrays
String[] concept = new String[] { "Jimmy" , "$500" };
double[] porcent = { 40, 40 };
with the query that came from dbquery?
thanks
Android had couple charts engines like android chart engine, etc, i am using that pluggin for my app, you see i need to chart data in a pie chart, but i dont know how to do it, becuase i have a class called dbquery that had this:
[HIGH]
public Cursor returnQuery()
{
Cursor c = db.rawQuery("SELECT LAST_NAME, SUM(PRICE) + Tbl_SALES", null);
c.close();
return c;
}
[/HIGH]
and another one called CreatePieChart
[HIGH]
private void CreatePieChart()
{
Cursor c= dbquery.returnQuery();
String[] concept = new String[] { "Jimmy" , "$500" };
double[] porcent = { 40, 40 };
int[] colors = { Color.MAGENTA, Color.GREEN };
CategorySeries distributionSerie = new CategorySeries("CUSTOMER");
for (int i = 0; i < porcent .length; i++)
{
// Adding a slice with its values and name to the Pie Chart
distributionSerie.add(concept, porcent );
}
// Instantiating a renderer for the Pie Chart
DefaultRenderer defaultRenderer = new DefaultRenderer();
for (int i = 0; i < porcent .length; i++) {
SimpleSeriesRenderer seriesRenderer = new SimpleSeriesRenderer();
seriesRenderer.setColor(colors);
seriesRenderer.setDisplayChartValues(true);
// Adding a renderer for a slice
defaultRenderer.addSeriesRenderer(seriesRenderer);
}
defaultRenderer.setLegendTextSize(30);
defaultRenderer.setChartTitle("Customer");
defaultRenderer.setChartTitleTextSize(20);
defaultRenderer.setZoomButtonsVisible(true);
defaultRenderer.setBackgroundColor(45454545);
defaultRenderer.setLabelsColor(45454532);
// Creating an intent to plot bar chart using dataset and
// multipleRenderer
Intent intent = ChartFactory.getPieChartIntent(getBaseContext(),
distributionSerie, defaultRenderer,
"PieChart");
// Start Activity
startActivity(intent);
[/HIGH]
now the real question is: How to replace this arrays
String[] concept = new String[] { "Jimmy" , "$500" };
double[] porcent = { 40, 40 };
with the query that came from dbquery?
thanks