package com.demo.reporteng;

import java.io.IOException;

import org.eclipse.birt.chart.model.Chart;
import org.eclipse.birt.chart.model.ChartWithAxes;
import org.eclipse.birt.chart.model.attribute.Anchor;
import org.eclipse.birt.chart.model.attribute.AxisType;
import org.eclipse.birt.chart.model.attribute.IntersectionType;
import org.eclipse.birt.chart.model.attribute.LegendItemType;
import org.eclipse.birt.chart.model.attribute.LineAttributes;
import org.eclipse.birt.chart.model.attribute.LineStyle;
import org.eclipse.birt.chart.model.attribute.Position;
import org.eclipse.birt.chart.model.attribute.TickStyle;
import org.eclipse.birt.chart.model.attribute.impl.ColorDefinitionImpl;
import org.eclipse.birt.chart.model.component.Axis;
import org.eclipse.birt.chart.model.component.Series;
import org.eclipse.birt.chart.model.component.impl.SeriesImpl;
import org.eclipse.birt.chart.model.data.NumberDataSet;
import org.eclipse.birt.chart.model.data.Query;
import org.eclipse.birt.chart.model.data.SeriesDefinition;
import org.eclipse.birt.chart.model.data.TextDataSet;
import org.eclipse.birt.chart.model.data.impl.NumberDataSetImpl;
import org.eclipse.birt.chart.model.data.impl.QueryImpl;
import org.eclipse.birt.chart.model.data.impl.SeriesDefinitionImpl;
import org.eclipse.birt.chart.model.data.impl.TextDataSetImpl;
import org.eclipse.birt.chart.model.impl.ChartWithAxesImpl;
import org.eclipse.birt.chart.model.layout.Legend;
import org.eclipse.birt.chart.model.layout.Plot;
import org.eclipse.birt.chart.model.type.BarSeries;
import org.eclipse.birt.chart.model.type.impl.BarSeriesImpl;
import org.eclipse.birt.core.framework.Platform;
import org.eclipse.birt.report.model.api.CellHandle;
import org.eclipse.birt.report.model.api.DesignConfig;
import org.eclipse.birt.report.model.api.DesignElementHandle;
import org.eclipse.birt.report.model.api.ElementFactory;
import org.eclipse.birt.report.model.api.ExtendedItemHandle;
import org.eclipse.birt.report.model.api.GridHandle;
import org.eclipse.birt.report.model.api.IDesignEngine;
import org.eclipse.birt.report.model.api.IDesignEngineFactory;
import org.eclipse.birt.report.model.api.ImageHandle;
import org.eclipse.birt.report.model.api.LabelHandle;
import org.eclipse.birt.report.model.api.OdaDataSetHandle;
import org.eclipse.birt.report.model.api.OdaDataSourceHandle;
import org.eclipse.birt.report.model.api.ReportDesignHandle;
import org.eclipse.birt.report.model.api.RowHandle;
import org.eclipse.birt.report.model.api.SessionHandle;
import org.eclipse.birt.report.model.api.activity.SemanticException;
import org.eclipse.birt.report.model.api.elements.structures.ComputedColumn;

import com.ibm.icu.util.ULocale;

/**
 * Simple BIRT Design Engine API (DEAPI) demo.
 */

public class DemoCreateRPT {
	private OdaDataSourceHandle customerDataSource = null;
	private static ReportDesignHandle design;
	private ElementFactory factory = null;
	private ReportDesignHandle reportDesignHandle = null;
	private String dataSourceName = "Sample BarChart";
	String query = "Select ename,sal from scott.emp";
	public static void main(String[] args) {
		try {
			new DemoCreateRPT().buildReport();
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SemanticException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	// This function shows how to build a very simple BIRT report with a
	// minimal set of content: a simple grid with an image and a label.

	public void buildReport() throws IOException, SemanticException {
		// Create a session handle. This is used to manage all open designs.
		// Your app need create the session only once.

		// Configure the Engine and start the Platform
		DesignConfig config = new DesignConfig();

		config
				.setProperty("BIRT_HOME",
						"F:\\Program\\Tools\\Java\\birt-runtime-2_5_2\\birt-runtime-2_5_2\\ReportEngine");
		IDesignEngine engine = null;
		try {
			Platform.startup(config);
			IDesignEngineFactory factory = (IDesignEngineFactory) Platform
					.createFactoryObject(IDesignEngineFactory.EXTENSION_DESIGN_ENGINE_FACTORY);
			engine = factory.createDesignEngine(config);

		} catch (Exception ex) {
			ex.printStackTrace();
		}

		SessionHandle session = engine.newSessionHandle(ULocale.ENGLISH);

		// Create a new report design.

		design = session.createDesign();

		// The element factory creates instances of the various BIRT elements.

		factory = design.getElementFactory();

		createDataSources();
		buildDataSet("Data Set","Sample BarChart",query);
		// Create a simple master page that describes how the report will
		// appear when printed.
		//
		// Note: The report will fail to load in the BIRT designer
		// unless you create a master page.

		DesignElementHandle element = factory
				.newSimpleMasterPage("Page Master"); //$NON-NLS-1$
		design.getMasterPages().add(element);

		// Create a grid and add it to the "body" slot of the report
		// design.

		GridHandle grid = factory.newGridItem(null, 3 /* cols */, 1 /* row */);
		design.getBody().add(grid);

		// Note: Set the table width to 100% to prevent the label
		// from appearing too narrow in the layout view.

		grid.setWidth("100%"); //$NON-NLS-1$

		// Get the first row.

		RowHandle row = (RowHandle) grid.getRows().get(0);

		// Create an image and add it to the first cell.

		ImageHandle image = factory.newImage(null);
		CellHandle cell = (CellHandle) row.getCells().get(0);
		cell.getContent().add(image);
		image.setURL("\"http://www.eclipse.org/birt/phoenix/tutorial/basic/multichip-4.jpg\"");

		// Create a label and add it to the second cell.

		LabelHandle label = factory.newLabel(null);
		cell = (CellHandle) row.getCells().get(1);
		cell.getContent().add(label);
		label.setText("Hello, world!"); //$NON-NLS-1$

		cell = (CellHandle) row.getCells().get(2);

		ExtendedItemHandle eih = factory.newExtendedItem(null, "Chart");//$NON-NLS-1$
		try {
			eih.setHeight("288pt");//$NON-NLS-1$
			eih.setWidth("252pt");//$NON-NLS-1$
			eih.setProperty(ExtendedItemHandle.DATA_SET_PROP, "Data Set");//$NON-NLS-1$
			eih.getReportItem().setProperty("chart.instance", createHSChart());//$NON-NLS-1$
		} catch (Exception e) {
			e.printStackTrace();
		}
		cell.getContent().add(eih);
		
		design.saveAs("c:/tmp/samplev1.rptdesign"); //$NON-NLS-1$
		design.close();
		System.out.println("Finished");

		// We're done!
	}

	public void createDataSources() {
		// type of the data source

		String extensionID = "org.eclipse.birt.report.data.oda.jdbc";

		String driverClassName = "oracle.jdbc.OracleDriver";

		String driverURL = "jdbc:oracle:thin:@localhost:1521:orcl";

		String userName = "SCOTT";

		String userPassword = "scott";

		// now make a data source with the dataSourceName and extensionID.
		try {

			OdaDataSourceHandle customerDataSource = factory.newOdaDataSource(
					dataSourceName, extensionID);
			customerDataSource.setProperty("odaDriverClass", driverClassName);

			customerDataSource.setProperty("odaURL", driverURL);

			customerDataSource.setProperty("odaUser", userName);

			customerDataSource.setProperty("odaPassword", userPassword);

			System.out.println("odaURL is "
					+ customerDataSource.getProperty("odaURL"));

			System.out.println("odaUser is "
					+ customerDataSource.getProperty("odaUser"));

			System.out.println("odaPassword is "
					+ customerDataSource.getProperty("odaPassword"));

			design.getDataSources().add(customerDataSource);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	/**
	 * Build the query ( data set to use in the report).
	 */
	public void buildDataSet(String dataSetName,String dataSourceName,String qry) 
	throws SemanticException
	{
		OdaDataSetHandle dataSetHandle = design.getElementFactory().newOdaDataSet( dataSetName,"org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" );
		dataSetHandle.setDataSource("Sample BarChart");
		dataSetHandle.setQueryText(qry );
		design.getDataSets( ).add( dataSetHandle );
	}


	public Chart createHSChart() {
		String[] cols = {
				"ENAME","SAL"
		};
		String[][] reportCols = {
				{"ENAME","Employee name"},
				{"ENAME","Salary"}
		};
		ChartWithAxes cwaBar = ChartWithAxesImpl.create();

		cwaBar.getBlock().setBackground(ColorDefinitionImpl.WHITE());

		Plot p = cwaBar.getPlot();
		p.getClientArea().setBackground(
				ColorDefinitionImpl.create(255, 255, 225));
		cwaBar.getTitle().getLabel().getCaption().setValue("Simple Bar Chart"); //$NON-NLS-1$
		cwaBar.setUnitSpacing(20);

		Legend lg = cwaBar.getLegend();
		LineAttributes lia = lg.getOutline();
		lg.getText().getFont().setSize(16);
		lia.setStyle(LineStyle.SOLID_LITERAL);
		lg.getInsets().set(10, 5, 0, 0);
		lg.getOutline().setVisible(false);
		lg.setAnchor(Anchor.NORTH_LITERAL);
		lg.setItemType(LegendItemType.CATEGORIES_LITERAL);

		// X-Axis
		
		Axis xAxisPrimary = cwaBar.getPrimaryBaseAxes()[0];

		xAxisPrimary.setType(AxisType.TEXT_LITERAL);
		xAxisPrimary.getMajorGrid().setTickStyle(TickStyle.BELOW_LITERAL);
		xAxisPrimary.getOrigin().setType(IntersectionType.VALUE_LITERAL);
		xAxisPrimary.getTitle().setVisible(true);
		
		
		// Y-Axis
		Axis yAxisPrimary = cwaBar.getPrimaryOrthogonalAxis(xAxisPrimary);
		yAxisPrimary.getMajorGrid().setTickStyle(TickStyle.LEFT_LITERAL);
		yAxisPrimary.setType(AxisType.LINEAR_LITERAL);
		yAxisPrimary.getLabel().getCaption().getFont().setRotation(90);

		// X-Series
		Series seCategory = SeriesImpl.create( );
		Query query = QueryImpl.create( "row[\"ename\"]" );//$NON-NLS-1$
		seCategory.getDataDefinition( ).add( query );
		
		SeriesDefinition sdX = SeriesDefinitionImpl.create();
		xAxisPrimary.getSeriesDefinitions( ).add( sdX );
		sdX.getSeries().add(seCategory);
		
		

		// Y-Series
		Query querySal = QueryImpl.create( "row[\"sal\"]" );//$NON-NLS-1$
		BarSeries bs = (BarSeries) BarSeriesImpl.create();
		bs.getDataDefinition().add(querySal);
		
		bs.setRiserOutline(null);
		bs.setSeriesIdentifier("Highlight"); //$NON-NLS-1$
		bs.getLabel().setVisible(true);
		bs.setLabelPosition(Position.INSIDE_LITERAL);
		
		SeriesDefinition sdY = SeriesDefinitionImpl.create();
		sdY.getSeriesPalette( ).update( -2 );
		yAxisPrimary.getSeriesDefinitions().add(sdY);
		sdY.getSeries().add(bs);
		
		
		return cwaBar;
	}
	
}

cs1 = StructureFactory.createComputedColumn();
			cs1.setName("Employee Name");
			cs1.setExpression("dataSetRow[\"ENAME\"]");
			cs1.setDataType("string");
			
			cs2 = StructureFactory.createComputedColumn();
			cs2.setName("Salary");
			cs2.setExpression("dataSetRow[\"SAL\"]");
			cs2.setDataType("decimal");