importPackage(Packages.java.lang);
importPackage(Packages.java.util);
importPackage(Packages.org.eclipse.birt.data.engine.api);
importPackage(Packages.org.eclipse.birt.report.model.api);
importPackage(Packages.org.eclipse.birt.data.engine.api.querydefn);
importPackage(Packages.org.eclipse.birt.data.engine.core);

// Grab the configuration object for the report engine
var myconfig = reportContext.getReportRunnable().getReportEngine().getConfig();

// Create a temporary data source based on the Banner data source
var dsrc = reportContext.getDesignHandle().findDataSource("Banner (PROD)");
  
var odaDataSource = new OdaDataSourceDesign( "Temporary Data Source" );
odaDataSource.setExtensionID( "org.eclipse.birt.report.data.oda.jdbc" );
odaDataSource.addPublicProperty( "odaURL", dsrc.getProperty("odaURL").toString() );
odaDataSource.addPublicProperty( "odaDriverClass", dsrc.getProperty("odaDriverClass").toString());
odaDataSource.addPublicProperty( "odaUser", dsrc.getProperty("odaUser").toString() );
odaDataSource.addPublicProperty( "odaPassword", dsrc.getProperty("odaPassword").toString() );

// Create a temporary data set based on the term codes data set
var dset = reportContext.getDesignHandle().findDataSet("Term Codes");
  
var odaDataSet = new OdaDataSetDesign( "Temporary Data Set" );
odaDataSet.setDataSource( odaDataSource.getName( ) );
odaDataSet.setExtensionID("org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" );
odaDataSet.setQueryText( dset.getQueryText() );

// Instantiate a new data engine
var dataEngine = DataEngine.newDataEngine( myconfig, null );
dataEngine.defineDataSource( odaDataSource );
dataEngine.defineDataSet( odaDataSet );

// Create a new query definition using the data set
var queryDefinition = new QueryDefinition( );
queryDefinition.setDataSetName( odaDataSet.getName() );
queryDefinition.setAutoBinding(true);

// Prepare and execute the query
var pq = dataEngine.prepare( queryDefinition );
var queryResult = pq.execute( null );

// Setup an interator for the results
var resultIterator = queryResult.getResultIterator( );
  
// This will hold the default term code
var defaultTermCode = null;

var today = new Date().getTime();
  
while (resultIterator.next() && defaultTermCode == null) {
  var termCode = resultIterator.getString("STVTERM_CODE");
  var termStartDate = resultIterator.getDate("STVTERM_START_DATE").getTime();
  var termEndDate = resultIterator.getDate("STVTERM_END_DATE").getTime();

  //System.out.println("Code:" + termCode + "; Start: " + termStartDate + "; End: " + termEndDate);

  if(today >= termStartDate && today <= termEndDate) {
	defaultTermCode = termCode;
  }
}

resultIterator.close( );
queryResult.close( );
dataEngine.shutdown( );

// Return the default value
defaultTermCode;