package com.itmill.toolkit.demo;

import java.sql.SQLException;

import com.itmill.toolkit.data.util.QueryContainer;
import com.itmill.toolkit.demo.util.SampleDatabase;
import com.itmill.toolkit.ui.Label;
import com.itmill.toolkit.ui.Panel;
import com.itmill.toolkit.ui.Select;
import com.itmill.toolkit.ui.Window;

/**
 * This example demonstrates what is lazy loading feature on Select component.
 * Demo Uses similar concepts to QueryContainerDemo.
 * 
 * @author IT Mill Ltd.
 * @since 4.0.0
 * 
 */
public class SelectDemo extends com.itmill.toolkit.Application {

	// Select component where SQL rows are attached (using QueryContainer)
	private final Select select = new Select();

	private final Select lazySelect = new Select();

	// Database provided with sample data
	private SampleDatabase sampleDatabase;

	/**
	 * Initialize Application. Demo components are added to main window.
	 */
	public void init() {
		Window main = new Window("Select demo");
		setMainWindow(main);

		// Main window contains heading, table, select and tree
		Panel panel = new Panel("Select demo (a.k.a Google Suggests)");
		panel.addComponent(this.lazySelect);
		panel.addComponent(new Label("<hr />", Label.CONTENT_XHTML));
		panel.addComponent(this.select);
		main.addComponent(panel);

		// create demo database
		this.sampleDatabase = new SampleDatabase();

		initSelects();
	}

	private void initSelects() {
		// init select
		this.select.setCaption("All employees default functionality.");
		this.select.setItemCaptionPropertyId("WORKER");
		// populate Toolkit select component with test SQL table rows
		try {
			QueryContainer qc = new QueryContainer(
					"SELECT ID, UNIT||', '||LASTNAME||' '||FIRSTNAME"
							+ " AS WORKER FROM employee ORDER BY WORKER",
					this.sampleDatabase.getConnection());
			this.select.setContainerDataSource(qc);
		} catch (SQLException e) {
			e.printStackTrace();
		}

		// init lazySelect
		this.lazySelect.setCaption("All employees with lazy loading "
				+ "(a.k.a Google Suggests) activated.");
		this.lazySelect.setItemCaptionPropertyId("WORKER");
		this.lazySelect.setFilteringMode(Select.FILTERINGMODE_CONTAINS);

		// use same datasource as select object uses
		this.lazySelect.setContainerDataSource(this.select
				.getContainerDataSource());
	}

}