package com.vci.client.portal.UI.v3.comptdesign.compt.popupcompt;

import java.awt.BorderLayout;
import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.Insets;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.LinkedList;
import java.util.List;

import com.vci.client.oq.QTClient;
import com.vci.client.ui.swing.VCISwingUtil;
import com.vci.client.ui.swing.components.VCIJButton;
import com.vci.client.ui.swing.components.VCIJPanel;
import com.vci.client.ui.swing.components.table.AbstractVCIJTableDataProvider;
import com.vci.client.ui.swing.components.table.VCIJTableDataProvider;
import com.vci.client.ui.swing.components.table.VCIJTableNode;
import com.vci.client.ui.swing.components.table.VCIJTablePanel;
import com.vci.corba.common.VCIError;
import com.vci.corba.omd.qtm.QTInfo;

public class QTPopupTablePanel  extends VCIJPanel{

	/**
	 * 
	 */
	private static final long serialVersionUID = -718487619680889638L;


	private final String COLUMN_NAME = "名称"; 
	private final String COLUMN_TYPE = "类型";
	
	private VCIJButton btnSearch = VCISwingUtil.createVCIJButton("search", "查询", "查询", "search.gif", new ActionListener() {
		@Override
		public void actionPerformed(ActionEvent e) {
			btnSearch_actionPerformed(e);
		}
	});
	private VCIJButton btnClear = VCISwingUtil.createVCIJButton("clear", "清空", "清空查询条件", "clear.gif", new ActionListener() {
		@Override
		public void actionPerformed(ActionEvent e) {
			btnClear_actionPerformed(e);
		}
	});
	
	private VCIJPanel searchInfoPanel = null;
	private VCIJTableDataProvider<QTInfo> dataProvider = null; 
	private VCIJTablePanel<QTInfo> tablePanel = null;
	private QTPopupDialog popupDialog = null;
	
	public QTPopupTablePanel(QTPopupDialog popupDialog){
		this.popupDialog = popupDialog;
	}
	
	public void buildTablePanel(){
		setLayout(new BorderLayout());
		
		dataProvider = new AbstractVCIJTableDataProvider<QTInfo>() {
			@Override
			public String[] getSpecialColumns() {
				return new String[]{COLUMN_NAME, COLUMN_TYPE};
			}
			@Override
			public int getTotal() {
				return super.total;
			}
			@Override
			public VCIJTableNode<QTInfo> getNewRowNode(QTInfo obj) {
				VCIJTableNode<QTInfo> res = new VCIJTableNode<QTInfo>(obj);
				res.setPropertyValue(COLUMN_NAME, obj.qtName);
				res.setPropertyValue(COLUMN_TYPE, obj.btmName);
				return res;
			}
			@Override
			public QTInfo[] getDatas(int pageIndex, int pageSize) {
				QTInfo[] datas = new QTInfo[0];
				try {
					ResData<QTInfo> res = getDatasByPageInfo(pageIndex, pageSize);
					datas = res.getDatas();
					super.total = res.getTotal();
				} catch (VCIError e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				return datas;
			}
		};
		tablePanel = new VCIJTablePanel<QTInfo>(dataProvider);
		tablePanel.setShowExport(false);
		tablePanel.setColumnDefaultWidth(250);
		tablePanel.setPageSizeList(new int[]{10,20,30,40,50,100, 10});
		tablePanel.buildTablePanel();
		
		searchInfoPanel = getNorthSearchPanel();
		add(searchInfoPanel, BorderLayout.NORTH);
		add(tablePanel, BorderLayout.CENTER);
	}

	private VCIJPanel getNorthSearchPanel(){
		VCIJPanel pal = new VCIJPanel(new GridBagLayout());
		pal.add(btnSearch, getGBC(1, 0, 1, 1, 0.0, 0.0, GridBagConstraints.NORTHEAST, GridBagConstraints.NONE, 1));
		pal.add(btnClear, getGBC(2, 0, 1, 1, 0.0, 0.0, GridBagConstraints.NORTHEAST, GridBagConstraints.NONE, 1));
		searchInfoPanel = pal;
		return pal;
	}
	private GridBagConstraints getGBC(int gridx, int gridy, int gridwidth, int gridheight, double weightx, double weighty, int anchor, int fill, int padxy) {
		return new GridBagConstraints(gridx, gridy, gridwidth, gridheight, weightx, weighty, anchor, fill, new Insets(padxy, padxy, padxy, padxy), padxy, padxy);
	}
	
	
	private ResData<QTInfo> getDatasByPageInfo(int pageIndex, int pageSize) throws VCIError{
		QTInfo[] datas = null;
		int start = pageIndex <= 1 ? 1 : (pageIndex - 1) * pageSize + 1;
		int end = pageIndex <= 1 ? pageSize : (pageIndex * pageSize);
		
		String where = " 1=1 ";
		String text = "";

		if(getPopupDialog() != null){
			if(getPopupDialog().getBtmLinKTypeTxt() != null){
				text = getPopupDialog().getBtmLinKTypeTxt().getText().trim();
				where += String.format(" and qt.btmname = '%s' ", text);
			}
			if(!getPopupDialog().isIgnoreTxtInputValue()){
				text = getPopupDialog().getSearchInputTxt().getText().trim();
				where += String.format(" and (qt.qtname like '%%%s%%') ", text, text);
			}
		}
		String fromWhere = String.format(" from PL_QTEMPLATE qt where %s ", where);
		String fromWhereOrderBy = String.format(" %s order by qt.qtname ", fromWhere);
		String sql = String.format("select * from(" +
				"  select row_.*,rownum rownum_ from( " +
				"         select qt.qtname,qt.btmname  %s" +
				"  ) row_ " +
				") where rownum_ >= %d and rownum_ <= %d ", fromWhereOrderBy, start, end);
		List<QTInfo> list = new LinkedList<QTInfo>();
		String[][] kvss = QTClient.getService().queryBySqlWithoutKey(sql);
		for(String[] kvs : kvss){
			QTInfo bi = new QTInfo();
			bi.qtName = kvs[0];
			bi.btmName = kvs[1];
			list.add(bi);
		}
		datas = list.toArray(new QTInfo[]{});
		
		sql = String.format("select count(1) count_ %s", fromWhere);
		kvss = QTClient.getService().queryBySqlWithoutKey(sql);
		int total = Integer.valueOf(kvss[0][0]);
		
		ResData<QTInfo> res = new ResData<QTInfo>();
		res.setDatas(datas);
		res.setTotal(total);
		return res;
	}

	private void btnSearch_actionPerformed(ActionEvent e){
		tablePanel.setPageIndex(1);
		tablePanel.refreshTableData();
	}
	
	private void btnClear_actionPerformed(ActionEvent e){
		tablePanel.setPageIndex(1);
		if(getPopupDialog() != null && getPopupDialog().getSearchInputTxt() != null){
			getPopupDialog().getSearchInputTxt().setText("");
		}
		tablePanel.refreshTableData();
	}
	
	public VCIJTablePanel<QTInfo> getTablePanel() {
		return tablePanel;
	}

	public QTPopupDialog getPopupDialog() {
		return popupDialog;
	}

	public void setPopupDialog(QTPopupDialog popupDialog) {
		this.popupDialog = popupDialog;
	}
	
}