TemplateMonitoringManageDialog.java

package com.hangum.tadpole.monitoring.core.dialogs.monitoring;

import java.util.List;

import org.apache.commons.lang.StringUtils;
import org.apache.log4j.Logger;
import org.eclipse.jface.dialogs.Dialog;
import org.eclipse.jface.dialogs.IDialogConstants;
import org.eclipse.jface.dialogs.MessageDialog;
import org.eclipse.jface.viewers.ArrayContentProvider;
import org.eclipse.jface.viewers.ISelectionChangedListener;
import org.eclipse.jface.viewers.IStructuredSelection;
import org.eclipse.jface.viewers.SelectionChangedEvent;
import org.eclipse.jface.viewers.TableViewer;
import org.eclipse.jface.viewers.TableViewerColumn;
import org.eclipse.swt.SWT;
import org.eclipse.swt.custom.SashForm;
import org.eclipse.swt.events.SelectionAdapter;
import org.eclipse.swt.events.SelectionEvent;
import org.eclipse.swt.graphics.Point;
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.Control;
import org.eclipse.swt.widgets.Group;
import org.eclipse.swt.widgets.Label;
import org.eclipse.swt.widgets.Shell;
import org.eclipse.swt.widgets.Table;
import org.eclipse.swt.widgets.TableColumn;
import org.eclipse.swt.widgets.Text;

import com.hangum.tadpole.commons.libs.core.define.PublicTadpoleDefine;
import com.hangum.tadpole.commons.libs.core.message.CommonMessages;
import com.hangum.tadpole.engine.define.DBDefine;
import com.hangum.tadpole.engine.query.dao.system.sql.template.TeadpoleMonitoringTemplateDAO;
import com.hangum.tadpole.engine.query.sql.TadpoleSystem_Template;
import com.hangum.tadpole.monitoring.core.Messages;
import com.hangum.tadpole.monitoring.core.utils.MonitoringDefine;

/**
 * Add template monitoring index Dialog
 * 
 * @author hangum
 *
 */
public class TemplateMonitoringManageDialog extends Dialog {
	private static final Logger logger = Logger.getLogger(TemplateMonitoringManageDialog.class);
	
	private int NEW_BTN = IDialogConstants.CLIENT_ID + 1;
	
	/** 화면의 저장 상태인지 수정 상태인 */
	private boolean isNewSaveStatue = true;
	
	/** 주의) update 시에 사용하려는 dao */
	private TeadpoleMonitoringTemplateDAO updateUseTemplateDao;
	
	private Combo comboDBType;
	private Combo comboKPIType;
	private Combo comboTemplateType;
	
	private TableViewer tvTemplate;
	
	private Combo comboMonitoringType;
	private Text textTitle;
	private Text textDescription;
	private Text textAdvice;
	
	private Combo comboMonitoringReadType;
	private Text textQuery;
	private Text textParameter1_name;
	private Text textParameter1Value;
	private Text textIndexName;
	private Text textConditionValue;
	
	private Combo comboConditionType;
	private Combo comboAfterProcess;
	private Text textParameter2_name;
	private Text textParameter2Value;
	
	private Combo comboExceptionConditionType;
	private Text textExceptionIndexNM;
	private Text textExceptionConditionValue;
	
	private Combo comboIsResultSave;
	private Combo comboIsSnapshotSave;

	/**
	 * Create the dialog.
	 * 
	 * @param parentShell
	 * @param userDB
	 */
	public TemplateMonitoringManageDialog(Shell parentShell) {
		super(parentShell);
		setShellStyle(SWT.MAX | SWT.RESIZE | SWT.TITLE);
	}
	
	@Override
	protected void configureShell(Shell newShell) {
		super.configureShell(newShell);
		newShell.setText("Add Monitoring Index Template"); //$NON-NLS-1$
	}

	/**
	 * Create contents of the dialog.
	 * @param parent
	 */
	@Override
	protected Control createDialogArea(Composite parent) {
		Composite container = (Composite) super.createDialogArea(parent);
		GridLayout gridLayout = (GridLayout) container.getLayout();
		gridLayout.verticalSpacing = 4;
		gridLayout.horizontalSpacing = 4;
		gridLayout.marginHeight = 4;
		gridLayout.marginWidth = 4;
		
		SashForm sashForm = new SashForm(container, SWT.VERTICAL);
		sashForm.setLayoutData(new GridData(SWT.FILL, SWT.FILL, true, true, 1, 1));
		
		Group grpTemplate = new Group(sashForm, SWT.NONE);
		grpTemplate.setText("Template");
		grpTemplate.setLayout(new GridLayout(2, false));
		
		Label lblDbType = new Label(grpTemplate, SWT.NONE);
		lblDbType.setLayoutData(new GridData(SWT.RIGHT, SWT.CENTER, false, false, 1, 1));
		lblDbType.setText("DB Type");
		
		comboDBType = new Combo(grpTemplate, SWT.READ_ONLY);
		comboDBType.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));
		comboDBType.setVisibleItemCount(11);
		comboDBType.addSelectionListener(new SelectionAdapter() {
			@Override
			public void widgetSelected(SelectionEvent e) {				
				initUI();
			}
		});
		for (DBDefine dbDefine : DBDefine.userDBValues()) {
			comboDBType.add(dbDefine.getDBToString());
			comboDBType.setData(dbDefine.getDBToString(), dbDefine);
		}
		comboDBType.select(0);
		
		tvTemplate = new TableViewer(grpTemplate, SWT.BORDER | SWT.FULL_SELECTION);
		tvTemplate.addSelectionChangedListener(new ISelectionChangedListener() {
			public void selectionChanged(SelectionChangedEvent event) {
				IStructuredSelection select = (IStructuredSelection)event.getSelection();
				if(!select.isEmpty()) {
					isNewSaveStatue = false;
					updateUseTemplateDao = (TeadpoleMonitoringTemplateDAO)select.getFirstElement();
					selectTemplateData(updateUseTemplateDao);
				}
				
			}
		});
		Table table = tvTemplate.getTable();
		table.setLinesVisible(true);
		table.setHeaderVisible(true);
		table.setLayoutData(new GridData(SWT.FILL, SWT.FILL, true, true, 2, 1));
		
		createColumns();
		
		tvTemplate.setContentProvider(new ArrayContentProvider());
		tvTemplate.setLabelProvider(new MonitoringTemplateLabelProvider());
		
		Composite compositeMoni = new Composite(sashForm, SWT.NONE);
		compositeMoni.setLayout(new GridLayout(6, false));
		
		Label lblMonitoringType_1 = new Label(compositeMoni, SWT.NONE);
		lblMonitoringType_1.setText("Monitoring Type");
		
		comboMonitoringType = new Combo(compositeMoni, SWT.READ_ONLY);
		comboMonitoringType.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 5, 1));
		for (MonitoringDefine.MONITORING_TYPE type : MonitoringDefine.MONITORING_TYPE.values()) {
			comboMonitoringType.add(type.toString());
		}
		comboMonitoringType.setVisibleItemCount(MonitoringDefine.MONITORING_TYPE.values().length);
		comboMonitoringType.select(0);
		
		Label lblKpi = new Label(compositeMoni, SWT.NONE);
		lblKpi.setText("KPI Type");
		
		comboKPIType = new Combo(compositeMoni, SWT.READ_ONLY);
		comboKPIType.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 5, 1));
		for (MonitoringDefine.KPI_TYPE type : MonitoringDefine.KPI_TYPE.values()) {
			comboKPIType.add(type.toString());
		}
		comboKPIType.setVisibleItemCount(MonitoringDefine.MONITORING_TYPE.values().length);
		comboKPIType.select(0);
		
		Label lblTemplateType = new Label(compositeMoni, SWT.NONE);
		lblTemplateType.setText("Template Type");
		
		comboTemplateType = new Combo(compositeMoni, SWT.READ_ONLY);
		comboTemplateType.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 5, 1));
		for (MonitoringDefine.TEMPLATE_TYPE type : MonitoringDefine.TEMPLATE_TYPE.values()) {
			comboTemplateType.add(type.toString());
		}
		comboTemplateType.setVisibleItemCount(MonitoringDefine.MONITORING_TYPE.values().length);
		comboTemplateType.select(0);
		
		Label lblTitle = new Label(compositeMoni, SWT.NONE);
		lblTitle.setText("Title");
		
		textTitle = new Text(compositeMoni, SWT.BORDER);
		textTitle.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 5, 1));
		
		Label lblDescription = new Label(compositeMoni, SWT.NONE);
		lblDescription.setText("Description");
		
		textDescription = new Text(compositeMoni, SWT.BORDER | SWT.WRAP | SWT.V_SCROLL | SWT.MULTI);
		GridData gd_textDescription = new GridData(SWT.FILL, SWT.CENTER, true, false, 5, 1);
		gd_textDescription.heightHint = 40;
		gd_textDescription.minimumHeight = 40;
		textDescription.setLayoutData(gd_textDescription);
		
		Label lblAdvice = new Label(compositeMoni, SWT.NONE);
		lblAdvice.setText("Advice");
		
		textAdvice = new Text(compositeMoni, SWT.BORDER | SWT.WRAP | SWT.H_SCROLL | SWT.V_SCROLL | SWT.CANCEL | SWT.MULTI);
		GridData gd_textAdvice = new GridData(SWT.FILL, SWT.CENTER, true, false, 5, 1);
		gd_textAdvice.minimumHeight = 40;
		gd_textAdvice.heightHint = 40;
		textAdvice.setLayoutData(gd_textAdvice);
		
		Label lblMonitoringType = new Label(compositeMoni, SWT.NONE);
		lblMonitoringType.setText("Read Type");
		
		comboMonitoringReadType = new Combo(compositeMoni, SWT.READ_ONLY);
		comboMonitoringReadType.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 5, 1));
		for (MonitoringDefine.ACCESS_TYPE type : MonitoringDefine.ACCESS_TYPE.values()) {
			comboMonitoringReadType.add(type.toString());
		}
		comboMonitoringReadType.setVisibleItemCount(MonitoringDefine.ACCESS_TYPE.values().length);
		comboMonitoringReadType.select(0);
		
		Label lblQuery = new Label(compositeMoni, SWT.NONE);
		lblQuery.setText("Query");
		
		textQuery = new Text(compositeMoni, SWT.BORDER | SWT.WRAP | SWT.H_SCROLL | SWT.V_SCROLL | SWT.CANCEL | SWT.MULTI);
		GridData gd_textQuery = new GridData(SWT.FILL, SWT.CENTER, true, false, 5, 1);
		gd_textQuery.heightHint = 80;
		gd_textQuery.minimumHeight = 80;
		textQuery.setLayoutData(gd_textQuery);
		
		Label lblParameter = new Label(compositeMoni, SWT.NONE);
		lblParameter.setText("Parameter 1 Name");
		
		textParameter1_name = new Text(compositeMoni, SWT.BORDER);
		textParameter1_name.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 2, 1));
		
		Label lblParameterValue = new Label(compositeMoni, SWT.NONE);
		lblParameterValue.setText("Parameter 1 Value");
		
		textParameter1Value = new Text(compositeMoni, SWT.BORDER);
		textParameter1Value.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 2, 1));
		
		Label lblParameterName = new Label(compositeMoni, SWT.NONE);
		lblParameterName.setLayoutData(new GridData(SWT.RIGHT, SWT.CENTER, false, false, 1, 1));
		lblParameterName.setText("Parameter 2 Name");
		
		textParameter2_name = new Text(compositeMoni, SWT.BORDER);
		textParameter2_name.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 2, 1));
		
		Label lblParameterValue_1 = new Label(compositeMoni, SWT.NONE);
		lblParameterValue_1.setText("Parameter 2 Value");
		
		textParameter2Value = new Text(compositeMoni, SWT.BORDER);
		textParameter2Value.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 2, 1));
		
		Label lblIndexName = new Label(compositeMoni, SWT.NONE);
		lblIndexName.setText("Index Name");
		
		textIndexName = new Text(compositeMoni, SWT.BORDER);
		textIndexName.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));
		
		Label lblConditionType = new Label(compositeMoni, SWT.NONE);
		lblConditionType.setText("Type");
		
		comboConditionType = new Combo(compositeMoni, SWT.READ_ONLY);
		comboConditionType.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));
		for (MonitoringDefine.CONDITION_TYPE type : MonitoringDefine.CONDITION_TYPE.values()) {
			comboConditionType.add(type.toString());
		}
		comboConditionType.setVisibleItemCount(MonitoringDefine.CONDITION_TYPE.values().length);
		comboConditionType.select(0);
		
		Label lblCondition = new Label(compositeMoni, SWT.NONE);
		lblCondition.setText("Value");
		
		textConditionValue = new Text(compositeMoni, SWT.BORDER);
		textConditionValue.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));
		
		Label lblExceptionIndex = new Label(compositeMoni, SWT.NONE);
		lblExceptionIndex.setText("Exception Index");
		
		textExceptionIndexNM = new Text(compositeMoni, SWT.BORDER);
		textExceptionIndexNM.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));
		
		Label lblType = new Label(compositeMoni, SWT.NONE);
		lblType.setText("Type");
		
		comboExceptionConditionType = new Combo(compositeMoni, SWT.READ_ONLY);
		comboExceptionConditionType.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));
		for (MonitoringDefine.CONDITION_TYPE type : MonitoringDefine.CONDITION_TYPE.values()) {
			comboExceptionConditionType.add(type.toString());
		}
		comboExceptionConditionType.setVisibleItemCount(MonitoringDefine.CONDITION_TYPE.values().length);
		comboExceptionConditionType.select(0);
		
		Label lblNewLabel = new Label(compositeMoni, SWT.NONE);
		lblNewLabel.setLayoutData(new GridData(SWT.RIGHT, SWT.CENTER, false, false, 1, 1));
		lblNewLabel.setText("Value");
		
		textExceptionConditionValue = new Text(compositeMoni, SWT.BORDER);
		textExceptionConditionValue.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));
		
		Label lblIfError = new Label(compositeMoni, SWT.NONE);
		lblIfError.setText("If error?");
		
		comboAfterProcess = new Combo(compositeMoni, SWT.READ_ONLY);
		comboAfterProcess.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 5, 1));
		for (MonitoringDefine.AFTER_PROCESS_TYPE type : MonitoringDefine.AFTER_PROCESS_TYPE.values()) {
			comboAfterProcess.add(type.toString());
		}
		comboAfterProcess.setVisibleItemCount(MonitoringDefine.AFTER_PROCESS_TYPE.values().length);
		comboAfterProcess.select(0);
		
		Label lblSaveResultData = new Label(compositeMoni, SWT.NONE);
		lblSaveResultData.setText("Is save result data?");
		
		comboIsResultSave = new Combo(compositeMoni, SWT.READ_ONLY);
		comboIsResultSave.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 2, 1));
		for (PublicTadpoleDefine.YES_NO type : PublicTadpoleDefine.YES_NO.values()) {
			comboIsResultSave.add(type.toString());
		}
		comboIsResultSave.setVisibleItemCount(MonitoringDefine.AFTER_PROCESS_TYPE.values().length);
		comboIsResultSave.select(0);
		
		Label lblSaveSanpshotData = new Label(compositeMoni, SWT.NONE);
		lblSaveSanpshotData.setText("is Save sanpshot data?");
		
		comboIsSnapshotSave = new Combo(compositeMoni, SWT.READ_ONLY);
		comboIsSnapshotSave.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 2, 1));
		for (PublicTadpoleDefine.YES_NO type : PublicTadpoleDefine.YES_NO.values()) {
			comboIsSnapshotSave.add(type.toString());
		}
		comboIsSnapshotSave.setVisibleItemCount(MonitoringDefine.AFTER_PROCESS_TYPE.values().length);
		comboIsSnapshotSave.select(0);
		
		sashForm.setWeights(new int[] {3, 7});
		
		initUI();

		return container;
	}

	/**
	 * ui initialize
	 */
	private void initUI() {
		try {
			DBDefine dbDefine = (DBDefine)comboDBType.getData(comboDBType.getText());
			
			List<TeadpoleMonitoringTemplateDAO> listTemplateDao = TadpoleSystem_Template.getMonitoringTemplate(dbDefine);
			tvTemplate.setInput(listTemplateDao);
			tvTemplate.refresh();
			
			isNewSaveStatue = true;
			selectTemplateData(new TeadpoleMonitoringTemplateDAO());
		} catch(Exception e) {
			logger.error("Get template list", e);
		}
	}
	
	/**
	 * select template data
	 * 
	 * @param dao
	 */
	private void selectTemplateData(TeadpoleMonitoringTemplateDAO dao) {
		comboMonitoringType.setText(dao.getMonitoring_type());
		comboKPIType.setText(dao.getKpi_type());
		comboTemplateType.setText(dao.getTemplate_type());
		
		textTitle.setText(dao.getTitle());
		textDescription.setText(dao.getDescription());
		textAdvice.setText(dao.getAdvice());
		comboMonitoringReadType.setText("SQL");
		textQuery.setText(dao.getQuery());
		
		textParameter1_name.setText(StringUtils.trimToEmpty(dao.getParam_1_column()));
		textParameter1Value.setText(StringUtils.trimToEmpty(dao.getParam_1_init_value()));
		textParameter2_name.setText(StringUtils.trimToEmpty(dao.getParam_2_column()));
		textParameter2Value.setText(StringUtils.trimToEmpty(dao.getParam_2_init_value()));
		
		textIndexName.setText(dao.getIndex_nm());
		comboConditionType.setText(dao.getCondition_type());
		textConditionValue.setText(dao.getCondition_value());

		textExceptionIndexNM.setText(dao.getException_index_nm());
		comboExceptionConditionType.setText(dao.getException_condition_type());
		textExceptionConditionValue.setText(dao.getException_condition_value());
		
		comboAfterProcess.setText(dao.getAfter_type());
		
		comboIsResultSave.setText(dao.getIs_result_save());
		comboIsSnapshotSave.setText(dao.getIs_snapshot_save());
	}
	
	@Override
	protected void buttonPressed(int buttonId) {
		if(buttonId == NEW_BTN) {
			isNewSaveStatue = true;
			selectTemplateData(new TeadpoleMonitoringTemplateDAO());
		} else {
			super.buttonPressed(buttonId);
		}
	}
	
	@Override
	protected void okPressed() {
		if("".equals(textTitle.getText())) {
			MessageDialog.openWarning(null, CommonMessages.get().Warning, "Please input the Title");//Title은 공백이 될 수 없습니다.");
			textTitle.setFocus();
			return;
		}
		if("".equals(textQuery.getText())) {
			MessageDialog.openWarning(null, CommonMessages.get().Warning, "Please input the Query");//Query은 공백이 될 수 없습니다.");
			textQuery.setFocus();
			return;
		}
		
		
		if(isNewSaveStatue) {
			updateUseTemplateDao = new TeadpoleMonitoringTemplateDAO();
			updateUseTemplateDao.setUser_seq(-1);
			updateUseTemplateDao.setDb_type(comboDBType.getText());
		} 
		
		updateUseTemplateDao.setTemplate_type(comboTemplateType.getText());
		updateUseTemplateDao.setMonitoring_type(comboMonitoringType.getText());
		updateUseTemplateDao.setKpi_type(comboKPIType.getText());
		updateUseTemplateDao.setTitle(textTitle.getText());
		updateUseTemplateDao.setDescription(textDescription.getText());
		updateUseTemplateDao.setAdvice(textAdvice.getText());
		
		updateUseTemplateDao.setQuery(textQuery.getText());
		updateUseTemplateDao.setIndex_nm(textIndexName.getText());
		updateUseTemplateDao.setCondition_type(comboConditionType.getText());
		updateUseTemplateDao.setCondition_value(textConditionValue.getText());
		
		updateUseTemplateDao.setException_index_nm(textExceptionIndexNM.getText());
		updateUseTemplateDao.setException_condition_type(comboExceptionConditionType.getText());
		updateUseTemplateDao.setException_condition_value(textExceptionConditionValue.getText());
		
		updateUseTemplateDao.setParam_1_column(textParameter1_name.getText());
		updateUseTemplateDao.setParam_1_init_value(textParameter1Value.getText());
		updateUseTemplateDao.setParam_2_column(textParameter2_name.getText());
		updateUseTemplateDao.setParam_2_init_value(textParameter2Value.getText());
		
		updateUseTemplateDao.setAfter_type(comboAfterProcess.getText());
		
		updateUseTemplateDao.setIs_result_save(comboIsResultSave.getText());
		updateUseTemplateDao.setIs_snapshot_save(comboIsSnapshotSave.getText());

		try {
			if(isNewSaveStatue) {
				TadpoleSystem_Template.saveMonitoringTemplate(updateUseTemplateDao);
				MessageDialog.openInformation(null, "Save Data", "Save Template data");
			} else {
				TadpoleSystem_Template.updateMonitoringTemplate(updateUseTemplateDao);
				MessageDialog.openInformation(null, "Update Data", "Update Template data");
			}
			
			initUI();
		} catch (Exception e) {
			logger.error("save monitoring index", e);
			
			MessageDialog.openError(null,CommonMessages.get().Error, e.getMessage());
		}
	}
	
	/**
	 * crate table column
	 */
	private void createColumns() {
		String[] names = {"Template", "Type", "KPI", "Title", "Description", "Query", 
					"param 1 column", "param 1 value", "param 2 column", "param 2 value", 
					"Index Name", "Condition Type", "Condition Value"};
		int[] intWidth = {60, 120, 90, 100, 150, 200,
						100, 100, 100, 100, 
						100, 100, 100};
		
		for(int i=0; i<names.length; i++) {
			TableViewerColumn tableViewerColumn = new TableViewerColumn(tvTemplate, SWT.NONE);
			TableColumn tblclmnDbName = tableViewerColumn.getColumn();
			tblclmnDbName.setText(names[i]);
			tblclmnDbName.setWidth(intWidth[i]);
		}
	}

	/**
	 * Create contents of the button bar.
	 * @param parent
	 */
	@Override
	protected void createButtonsForButtonBar(Composite parent) {
		createButton(parent, NEW_BTN, "New", true);
		createButton(parent, IDialogConstants.OK_ID, "Save", false);
		createButton(parent, IDialogConstants.CANCEL_ID, "Close", false);
	}

	/**
	 * Return the initial size of the dialog.
	 */
	@Override
	protected Point getInitialSize() {
		return new Point(700, 800);
	}
}