package Frame;
import java.awt.BorderLayout;
import java.awt.Container;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.FocusEvent;
import java.awt.event.FocusListener;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;
import javax.swing.Box;
import javax.swing.ImageIcon;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.event.InternalFrameEvent;
import javax.swing.event.InternalFrameListener;
import javax.swing.table.DefaultTableModel;
import ColorAndFont.English;
import ColorAndFont.NothJPanel;
import ColorAndFont.UIColor;
import ColorAndFont.buttonTitle;
import DataBase.DatabaseManagement;
import PbuliClass.JButtonModel;
import PbuliClass.ShowMessage;
import PbuliClass.Systems;
import PbuliClass.greateTables;
import PbuliClass.jinternalFrame;
import anchor.Anchor;
import anchor.Anchor_Dell;
import anchor.Anchor_nerby_dell;
import home.ChuShiHua;
@SuppressWarnings("rawtypes")
public class AnchorNearby extends jinternalFrame{

	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	Container rq;
	NothJPanel northPanel=null;//±±²¿Ãæ°å
	JPanel centerPanel=null;//Öв¿Ãæ°å
	JScrollPane gd=null;//¹ö¶¯Ãæ°å
	static JTable table=null;//ÉêÃ÷±í¸ñ
	JButtonModel but_serch=null;//ËÑË÷°´Å¥
	JButtonModel but_save=null;//±£´æ°´Å¥
	JButtonModel but_issave=null;//±£´æÑ¡ÖÐ
	JButtonModel but_clear=null;//Çå¿Õ°´Å¥
	JButtonModel but_refresh=null;//ˢа´Å¥
	JButtonModel but_tihuan=null;//Ìæ»»»ùÕ¾
	JButtonModel but_siji=null;//4»ùÕ¾¿ìËÙÅäÖÃ
	JTextField jf_serch=null;
	JTextField jf_anchorA=null;//»ùÕ¾A
	JTextField jf_anchorB=null;//»ùÕ¾B
	Vector<String> columnName;	
	List list;
	Vector rowData=null;
	DefaultTableModel tableModel=null;//ÉùÃ÷±í¸ñÄ£ÐÍ
	Vector nearanchor=new Vector();
	static Vector<String> choose_anchor=new Vector<String>();
	static boolean nerbyopen=false;



	public AnchorNearby() {//¹¹Ôì·½·¨
		String title="ÁÙ½üÅäÖÃ";
		if(Systems.sys().getLanguage().equals("English")) {
			title="Approaching Site";
		}
		this.setTitle(title);
		rowData=new Vector();
		this.setFrameIcon(new ImageIcon("image/icon/linjing.png"));//ÉèÖô°Ìåͼ±ê
		rq=getContentPane();//»ñÈ¡ÈÝÆ÷
		rq.setLayout(new BorderLayout());
		rq.setBackground(UIColor.getNorth_color());
		rq.add(getNorthPanel(),BorderLayout.NORTH);
		rq.add(getGd(),BorderLayout.CENTER);
		nerbyopen=true;
		this.addInternalFrameListener(new InternalFrameListener() {

			@Override
			public void internalFrameOpened(InternalFrameEvent e) {	

			}

			@Override
			public void internalFrameIconified(InternalFrameEvent e) {
			}

			@Override
			public void internalFrameDeiconified(InternalFrameEvent e) {				
			}

			@Override
			public void internalFrameDeactivated(InternalFrameEvent e) {				
			}

			@Override
			public void internalFrameClosing(InternalFrameEvent e) {
				nerbyopen=false;
				choose_anchor.removeAllElements();
				table=null;
			}

			@Override
			public void internalFrameClosed(InternalFrameEvent e) {
			}

			@Override
			public void internalFrameActivated(InternalFrameEvent e) {
			}
		});

	}

	/**»ñÈ¡±±²¿Ãæ°åµÄ·½·¨*/	
	public NothJPanel getNorthPanel() {
		if(northPanel==null) {
			northPanel=new NothJPanel();
			Box topicBox = Box.createHorizontalBox();// ´´½¨Ò»¸öˮƽÏäÈÝÆ÷
			topicBox.add(getJf_serch());
			topicBox.add(Box.createHorizontalStrut(5));
			topicBox.add(getBut_serch());			
			topicBox.add(Box.createHorizontalStrut(10));
			topicBox.add(getBut_refresh());			
			topicBox.add(Box.createHorizontalStrut(10));// Ìí¼ÓÒ»¸ö10ÏñËØ¿íµÄˮƽ֧Öù
			topicBox.add(getBut_issave());
			topicBox.add(Box.createHorizontalStrut(10));// Ìí¼ÓÒ»¸ö10ÏñËØ¿íµÄˮƽ֧Öù
			topicBox.add(getJf_anchorA());
			topicBox.add(Box.createHorizontalStrut(5));// Ìí¼ÓÒ»¸ö10ÏñËØ¿íµÄˮƽ֧Öù
			topicBox.add(getJf_anchorB());
			topicBox.add(Box.createHorizontalStrut(5));// Ìí¼ÓÒ»¸ö10ÏñËØ¿íµÄˮƽ֧Öù
			topicBox.add(getBut_tihuan());
			topicBox.add(Box.createHorizontalStrut(10));// Ìí¼ÓÒ»¸ö10ÏñËØ¿íµÄˮƽ֧Öù
			topicBox.add(getBut_siji());
			topicBox.add(Box.createHorizontalStrut(10));
			topicBox.add(getBut_save());

			northPanel.add(topicBox );
		}
		return northPanel;
	}

	public JButtonModel getBut_save() {
		if(but_save==null) {
			but_save=new JButtonModel("È«²¿±£´æ");
			but_save.addActionListener(new ActionListener() {
				@Override
				public void actionPerformed(ActionEvent e) {
					int tagnum=getTable().getRowCount();//±í¸ñ×ÜÐÐÊý
					boolean succ=false;
					for(int i=0;i<tagnum;i++) {
						String anchorid=(String) table.getValueAt(i, 0);
						String near1=(String) table.getValueAt(i, 1);						
						String near2=(String) table.getValueAt(i, 2);
						String near3=(String) table.getValueAt(i, 3);
						String near4=(String) table.getValueAt(i, 4);
						String near5=(String) table.getValueAt(i, 5);
						String near6=(String) table.getValueAt(i, 6);
						String near7=(String) table.getValueAt(i, 7);
						String near8=(String) table.getValueAt(i, 8);
						String near9=(String) table.getValueAt(i, 9);
						String near10=(String) table.getValueAt(i, 10);
						String qiehuan=(String) table.getValueAt(i,11);	
						String baoliu1=(String) table.getValueAt(i,12);	
						String baoliu2=(String) table.getValueAt(i,13);	
						near1=near1.replaceAll(" ", "");
						near2=near2.replaceAll(" ", "");
						near3=near3.replaceAll(" ", "");
						near4=near4.replaceAll(" ", "");
						near5=near5.replaceAll(" ", "");
						near6=near6.replaceAll(" ", "");
						near6=near6.replaceAll(" ", "");
						near7=near7.replaceAll(" ", "");
						near8=near8.replaceAll(" ", "");
						near9=near9.replaceAll(" ", "");
						near10=near10.replaceAll(" ", "");
						qiehuan=qiehuan.replaceAll(" ", "");
						baoliu1=baoliu1.replaceAll(" ", "");						
						
						String[] ziduan= {"near1","near2","near3","near4","near5","near6","near7",
								"near8","near9","near10","qiehuan","baoliu1","baoliu2","anchorid"};
						String[] zhi= {near1,near2,near3,near4,near5,near6,near7,near8,near9,near10,
								qiehuan,baoliu1,baoliu2,anchorid};
						succ=DatabaseManagement.fast_alert_dbase("tb_anchor_nearby", ziduan, zhi);
						Anchor_nerby_dell.alert_anchorby(anchorid, near1, near2, near3, near4, near5, 
								near6, near7, near8,near9, near10,qiehuan,baoliu1,baoliu2);
					}
					if(succ) {						
						ChuShiHua.write_nearby();
						ShowMessage.zidingyi("Êý¾Ý±£´æ³É¹¦...");
						//дÈëÁÙ½ü»ùÕ¾
					}
				}
			});
		}
		return but_save;
	}

	public JButtonModel getBut_issave() {
		if(but_issave==null) {
			but_issave=new JButtonModel("±£´æÑ¡ÖÐ");
			but_issave.addActionListener(new ActionListener() {
				public void actionPerformed(ActionEvent e) {
					int[] selectedRows=table.getSelectedRows();//±»Ñ¡ÖÐÐеÄË÷Òý¼¯ºÏ
					int size=selectedRows.length;
					if(size==0) {
						ShowMessage.zidingyi_24("ÇëÏÈÑ¡ÖÐÐèÒª±£´æµÄÐÐ");
						return;
					}
					for(int i=0;i<size;i++) {
						int a=selectedRows[i];
						String anchorid=(String) table.getValueAt(a, 0);
						String near1=(String) table.getValueAt(a, 1);
						String near2=(String) table.getValueAt(a, 2);
						String near3=(String) table.getValueAt(a, 3);
						String near4=(String) table.getValueAt(a, 4);
						String near5=(String) table.getValueAt(a, 5);
						String near6=(String) table.getValueAt(a, 6);
						String near7=(String) table.getValueAt(a, 7);
						String near8=(String) table.getValueAt(a, 8);
						String near9=(String) table.getValueAt(a, 9);
						String near10=(String) table.getValueAt(a, 10);
						String qiehuan=(String) table.getValueAt(a,11);
						String baoliu1=(String) table.getValueAt(a,12);//×îÔ¶²â¾à¾àÀë
						String baoliu2=(String) table.getValueAt(a,13);
						near1=near1.replaceAll(" ", "");
						near2=near2.replaceAll(" ", "");
						near3=near3.replaceAll(" ", "");
						near4=near4.replaceAll(" ", "");
						near5=near5.replaceAll(" ", "");
						near6=near6.replaceAll(" ", "");
						near6=near6.replaceAll(" ", "");
						near7=near7.replaceAll(" ", "");
						near8=near8.replaceAll(" ", "");
						near9=near9.replaceAll(" ", "");
						near10=near10.replaceAll(" ", "");
						qiehuan=qiehuan.replaceAll(" ", "");
						baoliu1=baoliu1.replaceAll(" ", "");
						String[] ziduan= {"near1","near2","near3","near4","near5","near6",
								"near7","near8","near9","near10","qiehuan","baoliu1","baoliu2","anchorid"};
						String[] zhi= {near1,near2,near3,near4,near5,near6,near7,near8,near9,near10,
								qiehuan,baoliu1,baoliu2,anchorid};
						boolean succ=DatabaseManagement.fast_alert_dbase("tb_anchor_nearby", ziduan, zhi);
						Anchor_nerby_dell.alert_anchorby(anchorid, near1, near2, near3, near4, near5, near6, 
								near7, near8,near9, near10,qiehuan,baoliu1,baoliu2);
						if(succ) {
							Anchor anchor=Anchor_Dell.get_anchor(anchorid);
							ChuShiHua.write_anchor_near(anchor);
							ShowMessage.zidingyi(anchorid+"ÁÙ½üÅäÖÃÒÑÏ·¢");
						}
					}
					
				}
			});
		}
		return but_issave;
	}

	public JButtonModel getBut_clear() {
		if(but_clear==null) {
			but_clear=new JButtonModel("Çå¿Õ");
		}
		return but_clear;
	}

	public JButtonModel getBut_refresh() {
		if(but_refresh==null) {
			but_refresh=new JButtonModel(buttonTitle.getRefresh());
			but_refresh.addActionListener(new ActionListener() {
				@Override
				public void actionPerformed(ActionEvent e) {
					updateTable();
				}
			});
		}
		return but_refresh;
	}

	/**ˢбí¸ñ·½·¨*/
	public void updateTable() {	
		if(tableModel !=null) {
			tableModel.getDataVector().clear();
			getRowData(  DatabaseManagement.get_alldate_indatabase("tb_anchor_nearby"));
			gd.validate();
		}
	}

	/**»ñÈ¡Öв¿Ãæ°åµÄ·½·¨*/	
	public JPanel getCenterPanel() {
		if(centerPanel==null) {
			centerPanel=new JPanel();
			centerPanel.add(getGd());//Ìí¼Ó¹ö¶¯Ãæ°å
			centerPanel.setBackground(UIColor.getNorth_color());

		}
		return centerPanel;
	}

	/**»ñÈ¡¹ö¶¯Ãæ°åµÄ·½·¨*/	
	public JScrollPane getGd() {
		if(gd==null){
			gd=new JScrollPane();
			gd.getViewport().setBackground(UIColor.getNorth_color());
			gd.setViewportView(getTable());

		}
		return gd;
	}

	/**»ñÈ¡»ùÕ¾±í¸ñµÄ·½·¨*/	
	public JTable getTable() {
		if(table==null) {			
			//Ìí¼Ó±í¸ñÁÐÏòÁ¿
			String[] name1= {"»ùÕ¾ID","ÁÙ½ü1","ÁÙ2","ÁÙ3","ÁÙ4","ÁÙ5","ÁÙ6","ÁÙ7","ÁÙ8","ÁÙ9","ÁÙ10","Çл»¾àÀë","×îÔ¶²â¾à","allout"};//±í¸ñÁÐÃû
			String[] name2= {
					"Anchor ID", 
					"Near1", 
					"Near2", 
					"Near3", 
					"Near4", 
					"Near5", 
					"Near6", 
					"Near7", 
					"Near8",
					"Near9", 
					"Near10", 
					"Handover Distance",
					"fastdistance",
					"allout"};//±í¸ñÁÐÃû
			String[] columnNames=English.columnNames(name1, name2);
			columnName=new Vector<>();
			for(int i=0;i<columnNames.length;i++){
				columnName.add(columnNames[i]);			
			}

			//½«ÁбíÖÐËùÓнá¹û¼¯¸øµ½list¼¯ºÏ	
			list = DatabaseManagement.table_base("tb_anchor_nearby","ASC","anchorid");
			greateTables tables=new greateTables();
			tableModel=new DefaultTableModel(rowData, columnName);
			table=tables.getTable(tableModel);	
			getRowData(list );
		}
		return table;

	}
	

	/**Ìí¼Ó±í¸ñÐÐÏòÁ¿Êý¾Ý·½·¨*/
	@SuppressWarnings({ "unchecked"})
	public void getRowData(List list ) { 		
		Iterator iterator = list.iterator();//´´½¨µü´úÆ÷		
		while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ			
			List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½list¼¯ºÏ
			Vector<String> row = new Vector();
			for(int i=0;i<11;i++) {
				String anchorner=(String)info.get(i);
				if(anchorner==null) {
					ShowMessage.zidingyi_24("ÁÙ½ü»ùվΪNULL±¨´í");
					return;
				}
				if(anchorner.length()>2 ) {
					row.add(anchorner);// »ùÕ¾ID	
				}
			}
			
			if(row.size() !=11) {		
				int size=row.size();
				for(int j=0;j<(11-size);j++) {
					row.add(" ");// »ùÕ¾ID
				}
			}					
			row.add((String)info.get(11));//Ìí¼ÓÇл»¾àÀë
			String fastdis="65535";
			String a=(String)info.get(12);
			if( a!=null) {
				fastdis=a;
			}
			row.add(fastdis);//×îÔ¶²â¾à
			
			String allout=(String)info.get(13);//ËùÓвâ¾àÊä³ö
			if( allout==null) {
				allout="0";
			}
			row.add(allout);
			
			tableModel.addRow(row);// Ïò±í¸ñ¶ÔÏóÌí¼ÓÐÐÊý¾Ý
			row=null;
		}
	}

	public JButtonModel getBut_tihuan() {
		if(but_tihuan==null) {
			but_tihuan=new JButtonModel("»ùÕ¾AÌæ»»B");
			but_tihuan.addActionListener(new ActionListener() {
				@Override
				public void actionPerformed(ActionEvent e) {
					String anchora=jf_anchorA.getText().trim();
					String anchorb=jf_anchorB.getText().trim();
					anchora=anchora.replaceAll(" ", "");
					anchorb=anchorb.replaceAll(" ", "");					
					for(int i=0;i<table.getRowCount();i++) {
						for(int j=0;j<table.getColumnCount();j++) {
							if(table.getValueAt(i, j).equals(anchora)) {
								table.setValueAt(anchorb, i, j);
							}
						}
					}
					ShowMessage.zidingyi("È«²¿Ìæ»»Íê±Ï...");
				}
			});
		}
		return but_tihuan;
	}

	public JTextField getJf_anchorA() {
		if(jf_anchorA==null) {
			jf_anchorA=new JTextField(4);
			jf_anchorA.setText("A");
			jf_anchorA.addFocusListener(new FocusListener() {

				@Override
				public void focusLost(FocusEvent e) {

				}

				@Override
				public void focusGained(FocusEvent e) {
					jf_anchorA.setText("");
				}
			});
		}
		return jf_anchorA;
	}

	public JTextField getJf_anchorB() {
		if(jf_anchorB==null) {
			jf_anchorB=new JTextField(4);
			jf_anchorB.setText("B");
			jf_anchorB.addFocusListener(new FocusListener() {

				@Override
				public void focusLost(FocusEvent e) {

				}

				@Override
				public void focusGained(FocusEvent e) {
					jf_anchorB.setText("");
				}
			});
		}
		return jf_anchorB;
	}

	/**»ñÈ¡Ñ¡ÖÐÐлùÕ¾¼¯ºÏ*/
	public static Vector<String> getChoose_anchor() {
		if(nerbyopen) {		
			if(choose_anchor.size() !=0) {
				choose_anchor.removeAllElements();
			}
			int size=table.getSelectedRowCount();			
			if(size==1) {
				choose_anchor=new Vector<String>();
				for(int i=0;i<11;i++) {
					int row=table.getSelectedRow();
					String anchorid=(String) table.getValueAt(row, i);
					if(anchorid.length()>3) {
					choose_anchor.add(anchorid);
					}
				}
			}
		}
		return choose_anchor;
	}

	/**4»ùÕ¾¿ìËÙÅäÖð´Å¥*/
	public JButtonModel getBut_siji() {
		if(but_siji==null) {
			but_siji=new JButtonModel("¿ìËÙÅäÖÃ");
			but_siji.addActionListener(new ActionListener() {
				public void actionPerformed(ActionEvent e) {
					int size=table.getRowCount();					
					if(size>10 || size<2) {
						ShowMessage.zidingyi("µ±Ç°»ùÕ¾ÊýÁ¿²»Ö§³Ö¿ìËÙÅäÖÃģʽ£¡");
						return;
					}

					String[] anchor=new String[size];

					for(int i=0;i<size;i++) {
						anchor[i]=(String) table.getValueAt(i, 0);
					}

					for(int i=0;i<size;i++) {
						Vector<String> anchorids=new Vector<String>();

						for(int j=0;j<size;j++) {
							if(i !=j) {
								anchorids.add(anchor[j]);
							}
						}

						for(int k=0;k<anchorids.size();k++) {
							table.setValueAt(anchorids.get(k), i,k+1);
						}

					}
					
					ShowMessage.zidingyi("¿ìËÙÅäÖÃÁÙ½üÍê±Ï£¡");

				}
			});
		}
		return but_siji;
	}

	public JButtonModel getBut_serch() {
		if(but_serch==null) {
			but_serch=new JButtonModel("ËÑË÷");
			but_serch.addActionListener(new ActionListener() {
				public void actionPerformed(ActionEvent e) {
					if(jf_serch.getText().length()>=1) {
						String serch=jf_serch.getText().trim();
						
						if(Anchor_nerby_dell.get_anchor(serch)==null) {
							ShowMessage.zidingyi("ËÑË÷µÄ"+serch+"²»´æÔÚ");
							return;
						}
						
						int tagnum=table.getRowCount();//±í¸ñ×ÜÐÐÊý
						if(tagnum >0 ) {
							for (int i = 0; i < tagnum; i++) {//ɾ³ýËùÓÐÐÐ
								tableModel.removeRow(0);							
							}
							//½«ÁбíÖÐËùÓнá¹û¼¯¸øµ½list¼¯ºÏ
							String sql="select * from tb_anchor_nearby where anchorid='"+serch+"'";
							list=DatabaseManagement.get_moudata_indatabase(sql);
							getRowData(list);
						}
					}else {
						ShowMessage.zidingyi("ÊÕÈëÐèÒªËÑË÷»ùÕ¾ID");
					}
				}
			});
			
		}
		return but_serch;
	}

	public JTextField getJf_serch() {
		if(jf_serch==null) {
			jf_serch=new JTextField(6);
		}
		return jf_serch;
	}






}