package com.vci.client.uif.engine.client.tableArea;

import java.awt.BorderLayout;
import java.awt.Component;
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.HashMap;
import java.util.Iterator;
import java.util.LinkedList;
import java.util.Map;
import javax.swing.ComboBoxModel;
import javax.swing.DefaultComboBoxModel;
import javax.swing.JTextField;

import com.vci.client.portal.utility.DataModelFactory;
import com.vci.client.portal.utility.PLDefination;
import com.vci.client.portal.utility.PRM;
import com.vci.client.portal.utility.PRMItem;
import com.vci.client.portal.utility.UITools;
import com.vci.client.ui.swing.VCISwingUtil;
import com.vci.client.ui.swing.components.VCIJButton;
import com.vci.client.ui.swing.components.VCIJComboBox;
import com.vci.client.ui.swing.components.VCIJDialog;
import com.vci.client.ui.swing.components.VCIJLabel;
import com.vci.client.ui.swing.components.VCIJPanel;
import com.vci.client.ui.swing.components.VCIJScrollPane;
import com.vci.client.ui.swing.components.VCIJTextField;
import com.vci.client.uif.actions.client.UIFCache;
import com.vci.client.uif.actions.client.UIFUtils;
import com.vci.client.uif.engine.client.controls.ControlFactory;
import com.vci.client.uif.engine.client.controls.ICustomControl;
import com.vci.client.uif.engine.client.controls.VCIJComboBoxModelValueObject;
import com.vci.corba.common.VCIError;
import com.vci.corba.omd.atm.AttribItem;
import com.vci.corba.portal.data.PortalVI;
import com.vci.mw.ClientContextVariable;
import com.vci.omd.dataType.VTDataType;

public class TablePanalAdvanceSearchDialog extends VCIJDialog implements ActionListener{

	/**
	 * 
	 */
	private static final long serialVersionUID = 4547945867911768830L;
	
	private String btmType = "";
	private String context = "";
	private PLDefination defination = null;
	private DataModelFactory factory = null;
	private TablePanel tablePanel = null;
	
	private VCIJButton btnSearch = VCISwingUtil.createVCIJButton("search", "查询", "查询", "search.png", this);
	private VCIJButton btnCancel = VCISwingUtil.createVCIJButton("cancel", "取消", "取消", "cancel.png", this);
	
	private HashMap<String, VCIJLabel> ctlLblMap = new HashMap<String, VCIJLabel>();
	private HashMap<String, VCIJTextField> ctlComptMap = new HashMap<String, VCIJTextField>();
	

	private final String AND_NAME = "并且";
	private final String AND_VALUE = "\\AND";
	private final String OR_NAME = "或者";
	private final String OR_VALUE = "\\OR";
	
	private final String EQUAL_NAME = "等于";
	private final String EQUAL_NOT_NAME = "不等于";
	private final String EQUAL_NOT_VALUE = "!=";
	private final String CONTAIN_NAME = "包含";
	private final String CONTAIN_VALUE = "*";
	private final String FUZZY = "模糊";
	private final String GREAT_NAME = "大于";
	private final String GREAT_VALUE = ">";
	private final String GREAT_EQUAL_NAME = "大于等于";
	private final String GREAT_EQUAL_VALUE = ">=";
	private final String LESS_NAME = "小于";
	private final String LESS_VALUE = "<";
	private final String LESS_EQUAL_NAME = "小于等于";
	private final String LESS_EQUAL_VALUE = "<=";
	
	public TablePanalAdvanceSearchDialog(
			String type, String context,
			PLDefination defination, DataModelFactory factory,
			TablePanel tablePanel) {
		
		super(ClientContextVariable.getFrame(), true);
		
		this.btmType = type;
		this.context = context;
		this.defination = defination;
		
		this.factory = factory;
		this.tablePanel = tablePanel;
		
	}
	
	public void init(){
		
		setIconImage(VCISwingUtil.createImageIcon("search.png").getImage());
		
		setTitle("高级查询");
		
		setLayout(new BorderLayout());

		add(new VCIJScrollPane(getCenterAreaPanel()), BorderLayout.CENTER);
		
		add(getSouthButtonPanel(), BorderLayout.SOUTH);
	}
	
	private VCIJPanel getCenterAreaPanel(){
		VCIJPanel pal = new VCIJPanel(new GridBagLayout());

		PortalVI tableDef = null;
		try {
			if(!"".equals(getDefination().getLinkType())){
				tableDef = factory.getTableDefinationByTypeAndTableName(getDefination().getLinkType(), getDefination().getTemplateId());
			} else {
				tableDef = factory.getTableDefinationByTypeAndTableName(getDefination().getShowType(), getDefination().getTemplateId());
			}
			PRM tablePrm = UITools.getPRM(tableDef.prm);
			if(tablePrm == null) return pal;
			String[] queryCols = tablePrm.getPrmItemList().get(0).getItemKeyFields().split(",");
			if(queryCols == null) return pal;
			if (queryCols.length == 0) {
				return pal;
			}
			// 第个属性出现多少次
			Map<String, Integer> colAndUseCountMap = tablePrm.getPrmItemList().get(0).getColAndUseCountMap();
			if(colAndUseCountMap == null || colAndUseCountMap.size() == 0){
				return pal;
			}
			// 属性对应的名称
			PortalVI formView = factory.getFormViewById(tablePrm.getPrmItemList().get(0).getItemInObj());
			PRM formPrm = UITools.getPRM(formView.prm);
			//Map<String, String> colAndNameMap = formPrm.getColAndNameMap();
			//得到每一个控件配置信息
			Map<String, PRMItem> prmItemMap = UIFUtils.getColAndPRMItemMap(formPrm);
			
			pal = loadAttrToPanel(colAndUseCountMap, prmItemMap);
			
		} catch (VCIError e) {
			e.printStackTrace();
		}
		return pal;
	}
	
	private VCIJPanel loadAttrToPanel(Map<String, Integer> mapNums, Map<String, PRMItem> prmItemMap){

		VCIJPanel pal = new VCIJPanel(new GridBagLayout());
		
		Iterator<String> keyNums = mapNums.keySet().iterator();

		int gridx = -1;
		int gridy = -1;
		
		while(keyNums.hasNext()){

			gridx = 0;
			gridy++;
			
			String field = keyNums.next();
			Integer count = mapNums.get(field);
			PRMItem item = prmItemMap.get(field);
			if(item == null) {
				continue;
			}
			//去掉item必填和只读的属性
			item.setItemIsEditable("0");
			item.setItemIsRequired("0");
			
			//获得属性的类型
			String type = field;
			if(type.indexOf(".") != -1) {
				type = type.substring(type.lastIndexOf(".") + 1);
			}
			//判断是否是系统默认的属性
			if(UIFUtils.getDefaultAttributeDataType(type) != null) {
				type = UIFUtils.getDefaultAttributeDataType(type);
			} else {
				AttribItem ai = UIFCache.getInstance().getAllAttributeMap().get(type);
				if(ai != null) {
					type = ai.vtDataType;
				}
			}
			
			VCIJLabel lbl = new VCIJLabel(item.getItemName());
			VCIJComboBox cbx = new VCIJComboBox(getNewComboBoxModel(type));
			Component txt = ControlFactory.createControl(item);
			
			pal.add(lbl, getGBC(gridx, gridy, 1, 1, 0.0, 0.0, GridBagConstraints.EAST, GridBagConstraints.NONE));
			
			gridx++;
			pal.add(cbx, getGBC(gridx, gridy, 1, 1, 0.0, 0.0, GridBagConstraints.NORTHEAST, GridBagConstraints.NONE));
			
			gridx++;
			GridBagConstraints gbc = getGBC(gridx, gridy, 1, 1, 1.0, 0.0, GridBagConstraints.NORTHEAST, GridBagConstraints.BOTH);
			if(count == 1){
				Insets insets = gbc.insets;
				gbc.insets = new Insets(insets.top, insets.left, 10, insets.right);
			}
			pal.add(txt, gbc);
			
			LinkedList<InnerStruct> list = new LinkedList<InnerStruct>();
			InnerStruct is = new InnerStruct(field, null, cbx, txt);
			list.add(is);
			
			singleFilterMap.put(field, list);
			
			if(count <= 1) {
				continue;
			}
			
			gridy = add(count, gridy, pal, field, item);
		}
		
		gridy++;
		VCIJLabel lblFill = new VCIJLabel("");
		pal.add(lblFill, getGBC(0, gridy, 3, 1, 1.0, 1.0, GridBagConstraints.NORTHEAST, GridBagConstraints.BOTH));
		
		return pal;
	}
	
	private int  add(int count, int gridyCurrent, VCIJPanel pal, String field, PRMItem item){
		int gridx = 0;
		int gridy = gridyCurrent;
		
		LinkedList<InnerStruct> dupFilterList = new LinkedList<InnerStruct>();
		
		for(int i = 2; i <= count; i++){
			//获得属性的类型
			String type = field;
			if(type.indexOf(".") != -1) {
				type = type.substring(type.lastIndexOf(".") + 1);
			}
			//判断是否是系统默认的属性
			if(UIFUtils.getDefaultAttributeDataType(type) != null) {
				type = UIFUtils.getDefaultAttributeDataType(type);
			} else {
				AttribItem ai = UIFCache.getInstance().getAllAttributeMap().get(type);
				if(ai != null) {
					type = ai.vtDataType;
				}
			}
			
			VCIJComboBox cbxAndOr = new VCIJComboBox(getNewAndOrComboBoxModel());
			VCIJComboBox cbxFilter = new VCIJComboBox(getNewComboBoxModel(type));
			Component txtFilter = ControlFactory.createControl(item);
			
			gridx = 0;
			gridy++;
			pal.add(cbxAndOr, getGBC(gridx, gridy, 1, 1, 0.0, 0.0, GridBagConstraints.NORTHEAST, GridBagConstraints.NONE));
			
			gridx++;
			pal.add(cbxFilter, getGBC(gridx, gridy, 1, 1, 0.0, 0.0, GridBagConstraints.NORTHEAST, GridBagConstraints.NONE));

			gridx++;
			GridBagConstraints gbc = getGBC(gridx, gridy, 1, 1, 1.0, 0.0, GridBagConstraints.NORTHEAST, GridBagConstraints.BOTH);
			if(i == count){
				Insets insets = gbc.insets;
				gbc.insets = new Insets(insets.top, insets.left, 10, insets.right);
			}
			pal.add(txtFilter, gbc);
			
			InnerStruct is = new InnerStruct(field, cbxAndOr, cbxFilter, txtFilter);
			dupFilterList.add(is);
		}
		
		// 存储每个属性重复出现的查询条件数据结构
		dupFilterMap.put(field, dupFilterList);
		
		return gridy;
	}
	
	/**
	 * 
	 */
	private HashMap<String, LinkedList<InnerStruct>> singleFilterMap = new HashMap<String, LinkedList<InnerStruct>>();
	
	/**
	 * 同一个属性，重复定义出的那些组查询条件
	 */
	private HashMap<String, LinkedList<InnerStruct>> dupFilterMap = new HashMap<String, LinkedList<InnerStruct>>();
	
	class InnerStruct{
		private String field = "";
		private VCIJComboBox cbxAndOr = null;
		private VCIJComboBox cbxFilter = null;
		private Component vlaueCompt = null;
		public InnerStruct(
				String field, 
				VCIJComboBox cbxAndOr, VCIJComboBox cbxFilter,
				Component txtValue) {
			super();
			this.cbxAndOr = cbxAndOr;
			this.cbxFilter = cbxFilter;
			this.vlaueCompt = txtValue;
		}
		public String getField() {
			return field;
		}
		public void setField(String field) {
			this.field = field;
		}
		public VCIJComboBox getCbxAndOr() {
			return cbxAndOr;
		}
		public void setCbxAndOr(VCIJComboBox cbxAndOr) {
			this.cbxAndOr = cbxAndOr;
		}
		public VCIJComboBox getCbxFilter() {
			return cbxFilter;
		}
		public void setCbxFilter(VCIJComboBox cbxFilter) {
			this.cbxFilter = cbxFilter;
		}
		public Component getVlaueCompt() {
			return vlaueCompt;
		}
		public void setVlaueCompt(Component txtValue) {
			this.vlaueCompt = txtValue;
		}
		
	}
	
	private DefaultComboBoxModel getNewAndOrComboBoxModel(){
		DefaultComboBoxModel model = new DefaultComboBoxModel();
		model.addElement(AND_NAME);
		model.addElement(OR_NAME);
		return model;
	}
	
	/**
	 * 获得属性类型支持的查询条件
	 * TODO 未完成
	 * @param type 属性的类型
	 * @return
	 */
	private DefaultComboBoxModel getNewComboBoxModel(String type){
		DefaultComboBoxModel model = new DefaultComboBoxModel();
		if(type.equals(VTDataType.VTSTRING)) {
			model.addElement(EQUAL_NAME); //等于
			model.addElement(EQUAL_NOT_NAME); //不等于
			model.addElement(CONTAIN_NAME); //包含
			model.addElement(FUZZY); //模糊
		} else if (type.equals(VTDataType.VTINTEGER)
				|| type.equals(VTDataType.VTLONG) 
				|| type.equals(VTDataType.VTDOUBLE)) {
			model.addElement(EQUAL_NAME); //等于
			model.addElement(EQUAL_NOT_NAME); //不等于
			model.addElement(GREAT_NAME); //大于
			model.addElement(GREAT_EQUAL_NAME); //大于等于
			model.addElement(LESS_NAME); //小于
			model.addElement(LESS_EQUAL_NAME); //小于等于
		} else if (type.equals(VTDataType.VTBOOLEAN)) {
			model.addElement(EQUAL_NAME); //等于
			model.addElement(EQUAL_NOT_NAME); //不等于
		} else if (type.equals(VTDataType.VTDATETIME)
				|| type.equals(VTDataType.VTDATE)
				|| type.equals(VTDataType.VTTIME)) {
			model.addElement(EQUAL_NAME); //等于
			model.addElement(EQUAL_NOT_NAME); //不等于
			model.addElement(GREAT_NAME); //大于
			model.addElement(GREAT_EQUAL_NAME); //大于等于
			model.addElement(LESS_NAME); //小于
			model.addElement(LESS_EQUAL_NAME); //小于等于
		} else {
			model.addElement(EQUAL_NAME);
		}
//		model.addElement(EQUAL_NAME);
//		model.addElement(EQUAL_NOT_NAME);
//		model.addElement(CONTAIN_NAME);
//		model.addElement(GREAT_NAME);
//		model.addElement(GREAT_EQUAL_NAME);
//		model.addElement(LESS_NAME);
//		model.addElement(LESS_EQUAL_NAME);
		return model;
	}

	private GridBagConstraints getGBC(int gridx, int gridy, int gridwidth, int gridheight, double weightx, double weighty, int anchor, int fill) {
		int padxy = 2;
		return new GridBagConstraints(gridx, gridy, gridwidth, gridheight, weightx, weighty, anchor, fill, new Insets(padxy, padxy, padxy, padxy), padxy, padxy);
	}
	
	private VCIJPanel getSouthButtonPanel(){
		VCIJPanel pal = new VCIJPanel();
		pal.add(btnSearch);
		pal.add(btnCancel);
		return pal;
	}
	
	
	@Override
	public void actionPerformed(ActionEvent e) {
		// TODO Auto-generated method stub
		String actionCommand = e.getActionCommand();
		if(actionCommand.equals(btnSearch.getActionCommand())) search();
		else if(actionCommand.equals(btnCancel.getActionCommand())) cancel();
	}
	
	
	private void search(){
		HashMap<String, String> conditionMap = getSearchConditionMap();
		this.tablePanel.getDataTablePanel().setPageIndex(1);
		this.tablePanel.getDataProvider().setLoadByCondition(true);
		this.tablePanel.getDataProvider().setNormalSearchFilterMap(conditionMap);
		this.tablePanel.getDataTablePanel().refreshTableData();
		
		cancel();
	}
	
	private HashMap<String, String> getSearchConditionMap(){
		HashMap<String, String> conditionMap = new HashMap<String, String>();
		
		Iterator<String> keys = singleFilterMap.keySet().iterator();
		while(keys.hasNext()){
			String field = keys.next();
			InnerStruct singleStruct = singleFilterMap.get(field).get(0);
			
			VCIJComboBox cbxFilterSignle = singleStruct.getCbxFilter();
			Component txtValueSingle = singleStruct.getVlaueCompt();
			
			String filter = cbxFilterSignle.getSelectedItem().toString();
			String value = getComponentValue(txtValueSingle);

			String valueToAdd = "";
			if(EQUAL_NAME.equals(filter)){
				valueToAdd = value;
			} else if(EQUAL_NOT_NAME.equals(filter)) {
				valueToAdd = EQUAL_NOT_VALUE + value;
			} else if(CONTAIN_NAME.equals(filter)){
				valueToAdd = CONTAIN_VALUE + value + CONTAIN_VALUE;
			} else if(FUZZY.equals(filter)){
				if(value.contains("%")){
					value = value.replace("%", "*");
				}
				valueToAdd = value;
			}else if(GREAT_NAME.equals(filter)) {
				valueToAdd = GREAT_VALUE + value;
			} else if(GREAT_EQUAL_NAME.equals(filter)) {
				valueToAdd = GREAT_EQUAL_VALUE + value;
			} else if(LESS_NAME.equals(filter)) {
				valueToAdd = LESS_VALUE + value;
			} else if(LESS_EQUAL_NAME.equals(filter)) {
				valueToAdd = LESS_EQUAL_VALUE + value;
			}
			
			String dupFilterValue = getDupFilterConditonString(field);
			String mergeFilterValue = valueToAdd + dupFilterValue;
			if(!"".equals(mergeFilterValue)){ 
				conditionMap.put(field, mergeFilterValue);
			}
		}
		
		return conditionMap;
	}
	private String getDupFilterConditonString(String field){
		String res = "";
		LinkedList<InnerStruct> dupFliterList = dupFilterMap.get(field);
		if(dupFliterList == null) return res;
		else if(dupFliterList.size() == 0) return res;
		
		for(InnerStruct is : dupFliterList){
			VCIJComboBox cbxAndOr = is.getCbxAndOr();
			VCIJComboBox cbxFilter = is.getCbxFilter();
			Component cbxValue = is.getVlaueCompt();
			
			String value = getComponentValue(cbxValue);
			if(value == null || "".equals(value)) continue;
			
			String filter = cbxFilter.getSelectedItem().toString();
			
			String valueToAdd = "";
			if(EQUAL_NAME.equals(filter)){
				valueToAdd = value;
			} else if(EQUAL_NOT_NAME.equals(filter)) {
				valueToAdd = EQUAL_NOT_VALUE + value;
			} else if(CONTAIN_NAME.equals(filter)){
				valueToAdd = CONTAIN_VALUE + value + CONTAIN_VALUE;
			} else if(GREAT_NAME.equals(filter)) {
				valueToAdd = GREAT_VALUE + value;
			} else if(GREAT_EQUAL_NAME.equals(filter)) {
				valueToAdd = GREAT_EQUAL_VALUE + value;
			} else if(LESS_NAME.equals(filter)) {
				valueToAdd = LESS_VALUE + value;
			} else if(LESS_EQUAL_NAME.equals(filter)) {
				valueToAdd = LESS_EQUAL_VALUE + value;
			}
			
			String andOr = cbxAndOr.getSelectedItem().toString();
			if(AND_NAME.equals(andOr)){
				valueToAdd = AND_VALUE + valueToAdd;
			} else if(OR_NAME.equals(andOr)){
				valueToAdd = OR_VALUE + valueToAdd;
			}
			
			res += valueToAdd;
			
		}
		return res;
	}
	
	private void cancel(){
		setDialogResult(DialogResult.CANCEL);
		this.setVisible(false);
		this.dispose();
	}
	
	/**
	 * 获得控件的值
	 * @param compt
	 * @return
	 */
	private String getComponentValue(Component compt){
		String value = "";
		if(JTextField.class.isAssignableFrom(compt.getClass())){
			JTextField txtCompt = (JTextField)compt;
			String text = txtCompt.getText();
			value = text;
		} else if(compt instanceof VCIJComboBox){
			VCIJComboBox cbx = (VCIJComboBox)compt;
			ComboBoxModel model = cbx.getModel();
			Object selectObj = model.getSelectedItem();
			if(selectObj instanceof VCIJComboBoxModelValueObject){
				VCIJComboBoxModelValueObject vo  = (VCIJComboBoxModelValueObject) selectObj;
				value = vo.getValue();
			}
		} else if(compt instanceof ICustomControl){
			ICustomControl ctrl = (ICustomControl)compt;
			value = ctrl.getValue();
		}
		return value;
	}

	public String getBtmType() {
		return btmType;
	}

	public void setBtmType(String type) {
		this.btmType = type;
	}

	public String getContext() {
		return context;
	}

	public void setContext(String context) {
		this.context = context;
	}

	public PLDefination getDefination() {
		return defination;
	}

	public void setDefination(PLDefination defination) {
		this.defination = defination;
	}

	public DataModelFactory getFactory() {
		return factory;
	}

	public void setFactory(DataModelFactory factory) {
		this.factory = factory;
	}
}