/*
 *   Mylyn Connector for Serena Business Mashups
 * 	 Copyright 2010 Brian Rosenberger (Brutex Network)
 *
 *   Licensed under the Apache License, Version 2.0 (the "License");
 *   you may not use this file except in compliance with the License.
 *   You may obtain a copy of the License at
 *
 *       http://www.apache.org/licenses/LICENSE-2.0
 *
 *   Unless required by applicable law or agreed to in writing, software
 *   distributed under the License is distributed on an "AS IS" BASIS,
 *   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 *   See the License for the specific language governing permissions and
 *   limitations under the License.
 * 
 *   Serena, TeamTrack and Serena Business Mashup are 
 * 	 registered trademarks of SERENA Software Inc.
 */
package net.brutex.mylyn.sbmconnector.ui;

import java.util.List;

import net.brutex.mylyn.sbmconnector.SBMConnectorPlugin;
import net.brutex.mylyn.sbmconnector.core.SBMClient;
import net.brutex.mylyn.sbmconnector.core.SBMRepositoryConnector;
import net.brutex.mylyn.sbmconnector.core.model.SBMField;
import net.brutex.mylyn.sbmconnector.core.model.SBMSystemFields;

import org.eclipse.core.runtime.CoreException;
import org.eclipse.core.runtime.IProgressMonitor;
import org.eclipse.jface.dialogs.IMessageProvider;
import org.eclipse.mylyn.tasks.core.TaskRepository;
import org.eclipse.mylyn.tasks.ui.wizards.AbstractRepositorySettingsPage;
import org.eclipse.swt.SWT;
import org.eclipse.swt.layout.GridData;
import org.eclipse.swt.layout.GridLayout;
import org.eclipse.swt.widgets.Combo;
import org.eclipse.swt.widgets.Composite;
import org.eclipse.swt.widgets.Event;
import org.eclipse.swt.widgets.Label;
import org.eclipse.swt.widgets.Listener;
import org.eclipse.swt.widgets.Table;
import org.eclipse.swt.widgets.TableColumn;
import org.eclipse.swt.widgets.TableItem;
import org.eclipse.ui.forms.widgets.ExpandableComposite;
import org.eclipse.ui.forms.widgets.FormToolkit;

public class SBMRepositorySettingsPage extends AbstractRepositorySettingsPage {

	private Combo table;
	private Table list;

	private String solutionTable = "";
	private String solutionTableList = "";
	private String tableFieldList = "";
	private String tableFullFieldList = "";

	public static final String STRING_SOLUTIONTABLE = "solutionTable";
	public static final String STRING_SOLUTIONTABLELIST = "solutionTableList";
	public static final String STRING_TABLEFIELDLIST = "tableFieldList";
	public static final String STRING_TABLEFULLFIELDLIST = "tableFullFieldList";

	public SBMRepositorySettingsPage(String title, String description,
			TaskRepository taskRepository) {
		super(title, description, taskRepository);
		setNeedsAdvanced(false);
		setNeedsValidation(true);
		setNeedsEncoding(false);
		// initialize table and table list if not null
		if (taskRepository.hasProperty(STRING_SOLUTIONTABLE)) {
			this.solutionTable = taskRepository
					.getProperty(STRING_SOLUTIONTABLE);
		}
		if (taskRepository.hasProperty(STRING_SOLUTIONTABLELIST)) {
			this.solutionTableList = taskRepository
					.getProperty(STRING_SOLUTIONTABLELIST);
		}
		if (taskRepository.hasProperty(STRING_TABLEFIELDLIST)) {
			this.tableFieldList = taskRepository
					.getProperty(STRING_TABLEFIELDLIST);
		}
		if (taskRepository.hasProperty(STRING_TABLEFULLFIELDLIST)) {
			this.tableFullFieldList = taskRepository
					.getProperty(STRING_TABLEFULLFIELDLIST);
		}
	}

	@Override
	public void applyTo(TaskRepository repository) {
		super.applyTo(repository);
		if (!solutionTable.isEmpty()) {
			repository.setProperty(STRING_SOLUTIONTABLE, solutionTable);
			repository.setProperty(STRING_SOLUTIONTABLELIST, solutionTableList);
			String fieldlist = ",";
			String fullfieldlist = ",";
			for (TableItem t : list.getItems()) {
				if (t.getChecked())
					fieldlist = fieldlist + t.getText(2) + ",";
				fullfieldlist = fullfieldlist + t.getText(2) + ",";
			}
			repository.setProperty(STRING_TABLEFIELDLIST, fieldlist);
			repository.setProperty(STRING_TABLEFULLFIELDLIST, fullfieldlist);
		}
	}

	@Override
	public boolean isPageComplete() {
		if (table != null 
				&& table.getText().length() > 4
				&& getUserName() != null
				&& getUserName().length() > 0) {
			return true;
		}
		return false;
	}

	@Override
	protected void createContributionControls(Composite parentControl) {
		ExpandableComposite expander = createSection(parentControl,
				"Mashup application");
		FormToolkit toolkit = new FormToolkit(parentControl.getDisplay());
		Composite control = toolkit.createComposite(expander, SWT.NONE);
		GridLayout gridLayout = new GridLayout();
		gridLayout.numColumns = 2;
		gridLayout.verticalSpacing = 5;
		gridLayout.marginWidth = 0;
		control.setLayout(gridLayout);
		control.setBackground(parentControl.getBackground());

		Label label = new Label(control, SWT.NONE);
		label.setText("Table:");

		table = new Combo(control, SWT.SINGLE | SWT.BORDER);
		Label label_list = new Label(control, SWT.NONE | SWT.TOP);
		label_list.setText("Fields:");
		list = new Table(control, SWT.MULTI | SWT.BORDER | SWT.V_SCROLL
				| SWT.H_SCROLL | SWT.FULL_SELECTION | SWT.CHECK);
		list.setLinesVisible(true);
		list.setHeaderVisible(true);
		GridData data = new GridData(SWT.FILL, SWT.FILL, true, true);
		data.heightHint = 200;
		list.setLayoutData(data);
		String[] titles = { " ", "Display Name", "DBName", "Type" };
		for (int i = 0; i < titles.length; i++) {
			TableColumn column = new TableColumn(list, SWT.NONE);
			column.setText(titles[i]);
		}
		list.addListener(SWT.Selection, new Listener() {
			@Override
			public void handleEvent(Event event) {
				//avoid that a system field may be unchecked
				try {
					SBMSystemFields
							.valueOf(((TableItem) event.item).getText(2));
					((TableItem) event.item).setChecked(true);
				} catch (IllegalArgumentException e) {
					// do nothing
				}
			}
		});
		table.addListener(SWT.Selection, new Listener() {
			@Override
			public void handleEvent(Event arg0) {
				// when the table has been changed
				// try to re-read the field list
				tableFieldList = "";
				tableFullFieldList = "";
				try {
					SBMField[] fields = SBMRepositoryConnector.getClient(
						createTaskRepository()).getFields(table.getText())
						.toArray(new SBMField[0]);
				fillList(list, fields);
				} catch (Exception e) { }
				if (getWizard() != null) {
					solutionTable = table.getText();
					getWizard().getContainer().updateButtons();
				}
			}

		});
		regenerateTables();
		expander.setClient(control);
	}

	@Override
	public String getConnectorKind() {
		return SBMConnectorPlugin.CONNECTOR_KIND;
	}

	@Override
	protected Validator getValidator(TaskRepository repository) {
		return new SBMConnectionValidator(repository);
	}

	@Override
	protected boolean isValidUrl(String url) {
		if (url.contains("<server>"))
			return false;
		return true;
	}

	@Override
	protected void applyValidatorResult(Validator validator) {
		if (((SBMConnectionValidator) validator).getResult() != null) {
			setMessage("Validate first!", IMessageProvider.ERROR);
			setNeedsValidation(true);
		} else {
			regenerateTables();
		}
	}

	private void regenerateTables() {
		try {
			List<String> tables = SBMRepositoryConnector.getClient(
					createTaskRepository()).getPrimaryTables();
			for (String table_name : tables) {
				table.add(table_name);
				if (solutionTable.equals(table_name)) {
					table.setText(table_name);
				}
			}
		} catch (Exception e) {
			// it was not possible to read the list of tables
			// from the server, so just restore saved settings
			table.add(solutionTable);
			table.setText(solutionTable);
		}
		try {
		SBMField[] fields = SBMRepositoryConnector.getClient(
				createTaskRepository()).getFields(table.getText()).toArray(
				new SBMField[0]);
				fillList(list, fields);
		} catch (Exception e) {
			// it was not possible to read the fields for the given table
			// do nothing
		}

	}

	protected class SBMConnectionValidator extends Validator {
		private TaskRepository repository;
		private String result = null;

		protected SBMConnectionValidator(TaskRepository repository) {
			this.repository = repository;
		}

		@Override
		public void run(IProgressMonitor monitor) throws CoreException {
			monitor.beginTask("Prüfe Verbindung", IProgressMonitor.UNKNOWN);
			SBMClient client = new SBMClient(repository);
			if (!client.canAuthenticate()) {
				result = "Verbindung fehlgeschlagen";
			} else {
				result = null;
			}
			monitor.done();
		}

		public String getResult() {
			return result;
		}
	}

	private void fillList(Table list, SBMField[] fields) {
		list.removeAll();
		for (int i = 0; i < fields.length; i++) {
			TableItem item = new TableItem(list, 0);
			item.setText(0, "");
			item.setText(1, fields[i].getLabel());
			item.setText(2, fields[i].getName());
			item.setText(3, fields[i].getType().getValue().replaceFirst(
					"FLDTYPE-", ""));
			try {
				// auto-select all system fields
				SBMSystemFields.valueOf(fields[i].getName());
				item.setChecked(true);
			} catch (IllegalArgumentException e) {
				// do nothing
			}
			if (tableFieldList.contains(","+fields[i].getName()+",")) {
				// item has been checked before
				// so check it
				item.setChecked(true);
			}
		}

		for (TableColumn c : list.getColumns()) {
			c.pack();
		}
	}

	@Override
	protected void createAdditionalControls(Composite arg0) {
		// TODO Auto-generated method stub

	}

}