package Frame;
import java.awt.BorderLayout;
import java.awt.Color;
import java.awt.Component;
import java.awt.Container;
import java.awt.Dimension;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.KeyEvent;
import java.awt.event.KeyListener;
import java.awt.event.WindowEvent;
import java.awt.event.WindowListener;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;
import javax.swing.Box;
import javax.swing.ImageIcon;
import javax.swing.JDialog;
import javax.swing.JPanel;
import javax.swing.JProgressBar;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableCellRenderer;
import javax.swing.table.TableColumn;
import ColorAndFont.English;
import ColorAndFont.NothJPanel;
import ColorAndFont.UIColor;
import ColorAndFont.buttonTitle;
import DataBase.DatabaseManagement;
import PbuliClass.JButtonModel;
import PbuliClass.JlableModel;
import PbuliClass.OutButton;
import PbuliClass.ShowMessage;
import PbuliClass.Systems;
import PbuliClass.WarningMessage;
import PbuliClass.greateTables;
import PbuliClass.jinternalFrame;
import tbDataModel_Dell.Dell_hispower;
import tbDataModel_Dell.LineXy;
@SuppressWarnings("rawtypes")
public class TagHistoryPower extends jinternalFrame {
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	JPanel inJpanel=null;//ÄÚ²¿Ãæ°å
	NothJPanel northJpanel=null;//±±²¿Ãæ°å
	JPanel centerJpanel=null;//Öв¿Ãæ°å
	JButtonModel jbut;//°´Å¥Ä£ÐÍ
	JTextField searchFileld=null;//ËÑË÷Îı¾¿ò
	JButtonModel search=null;//ËÑË÷°´Å¥
	JButtonModel shuaxin=null;//ˢа´Å¥
	JButtonModel delete=null;//ɾ³ý°´Å¥
	JButtonModel deleteAll=null;//È«²¿É¾³ý°´Å¥
	JTable table=null;//ÉêÃ÷±í¸ñ
	Vector<Vector<String>> rowData=null;
	DefaultTableModel tableModel=null;//±í¸ñÄ£ÐÍ
	List list;
	Container rq;
	JScrollPane gd=null;
	JButtonModel firstPageButton=null;
	JButtonModel latePageButton=null;
	JButtonModel nextPageButton=null;
	JButtonModel lastPageButton=null;
	JButtonModel open=null;//´ò¿ª
	int maxPageNumber;
	Dialog dialog=null;
	static int currentPageNumber = 1;//µ±Ç°Ò³Ãæ
	int allrows;//Êý¾Ý×ÜÌõÊý
	NothJPanel south=null;
	JlableModel nowpage;//µ±Ç°Ò³Âë
	String serch;
	int k;
	String a;
	int selectedRow;//±»Ñ¡ÖеÄÐÐ
	JTextField hang=null;
	String tagid=null;

	public TagHistoryPower() {
		String title="ÀúÊ·µçÁ¿";
		if(Systems.sys().getLanguage().equals("English")) {
			title="Tag Historical battery";
		}
		this.setTitle(title);
		this.setFrameIcon(new ImageIcon("image/icon/historypowericon.png"));//ÉèÖô°Ìåͼ±ê
		rowData=new Vector<>();
		rq=getContentPane();//»ñÈ¡ÈÝÆ÷
		rq.setLayout(new BorderLayout());
		rq.setBackground(Color.white);
		rq.add(getNorthJpanel(),BorderLayout.NORTH);
		rq.add(getGd(),BorderLayout.CENTER);
		rq.add(getSouth(),BorderLayout.SOUTH);
		getMaxPageNumber();
		
	}


	/**»ñÈ¡±±²¿Ãæ°å*/
	public NothJPanel getNorthJpanel() {
		if(northJpanel==null) {
			northJpanel=new NothJPanel();
			Box topicBox = Box.createHorizontalBox();// ´´½¨Ò»¸öˮƽÏäÈÝÆ÷
			topicBox.add(getSearchFileld());//Ìí¼ÓËÑË÷Îı¾¿ò
			topicBox.add(Box.createHorizontalStrut(3));// Ìí¼ÓÒ»¸ö3ÏñËØ¿íµÄˮƽ֧Öù
			topicBox.add(getSearch());//Ìí¼ÓËÑË÷°´Å¥
			topicBox.add(Box.createHorizontalStrut(10));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù
			topicBox.add(getShuaxin());//Ìí¼Óˢа´Å¥
			topicBox.add(Box.createHorizontalStrut(10));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù
			topicBox.add(getDelete());//Ìí¼Óɾ³ý°´Å¥
			topicBox.add(Box.createHorizontalStrut(10));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù
			topicBox.add(getDeleteAll());//Ìí¼Óɾ³ýÈ«²¿°´Å¥ 
			topicBox.add(Box.createHorizontalStrut(10));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù
			topicBox.add(getOutport());//Ìí¼Óµ¼³ö°´Å¥
			topicBox.add(Box.createHorizontalStrut(10));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù
			topicBox.add(getOpen());
			northJpanel.add(topicBox );	
		}

		return northJpanel;
	}
	
	/**»ñÈ¡Äϲ¿Ãæ°åµÄ·½·¨*/	
	public NothJPanel getSouth() {
		if(south==null) {
			south=new NothJPanel();
			Box topicBox = Box.createHorizontalBox();// ´´½¨Ò»¸öˮƽÏäÈÝÆ÷
			topicBox.add(getFirstPageButton());//Ìí¼ÓËÑË÷Îı¾¿ò
			topicBox.add(Box.createHorizontalStrut(15));// Ìí¼ÓÒ»¸ö3ÏñËØ¿íµÄˮƽ֧Öù
			topicBox.add(getLatePageButton());//Ìí¼ÓËÑË÷°´Å¥
			topicBox.add(Box.createHorizontalStrut(15));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù
			topicBox.add(getNextPageButton());//Ìí¼Óˢа´Å¥
			topicBox.add(Box.createHorizontalStrut(15));// Ìí¼ÓÒ»¸ö5ÏñËØ¿íµÄˮƽ֧Öù			
			topicBox.add(getLastPageButton());//Ìí¼Óɾ³ý°´Å¥
			nowpage= new JlableModel("µÚ"+currentPageNumber+"Ò³"); 
			topicBox.add(Box.createHorizontalStrut(25));// Ìí¼ÓÒ»¸ö15ÏñËØ¿íµÄˮƽ֧Öù			
			topicBox.add(nowpage);
			south.add(topicBox );
		}
		return south;
	}
	
	public JButtonModel getFirstPageButton() {
		if(firstPageButton==null) {
			firstPageButton=new JButtonModel(buttonTitle.getHome());
			firstPageButton.setEnabled(false);
			firstPageButton.addActionListener(new ActionListener() {
				public void actionPerformed(ActionEvent e) {
					currentPageNumber=1;
					nowpage.setText("µÚ"+currentPageNumber+"Ò³");
					lastPageButton.setEnabled(true);
					nextPageButton.setEnabled(true);
					k=Integer.parseInt(getHang().getText());
					serch="select * from tb_history_power limit 0,"+k;
					updateSerch(serch);
					currentPageNumber = 1;
					firstPageButton.setEnabled(false);
					latePageButton.setEnabled(false);	
				}
			});
		}
		return firstPageButton;
	}

	public JButtonModel getLatePageButton() {
		if(latePageButton==null) {
			latePageButton=new JButtonModel(buttonTitle.getPrevious());			
			latePageButton.addActionListener(new ActionListener() {
				public void actionPerformed(ActionEvent e) {					
					lastPageButton.setEnabled(true);
					latePageButton.setEnabled(true);
					--currentPageNumber;
					nowpage.setText("µÚ"+currentPageNumber+"Ò³");
					if(currentPageNumber==1) {
						latePageButton.setEnabled(false);
						firstPageButton.setEnabled(false);
					}
					if(currentPageNumber>=1) {
						k=Integer.parseInt(getHang().getText().trim());
						a=String.valueOf(currentPageNumber*k-k);
						serch="select * from tb_history_power limit "+a+","+k;
						updateSerch(serch);	
						nextPageButton.setEnabled(true);
					}
				}
			});
		}
		return latePageButton;
	}

	public JButtonModel getNextPageButton() {
		if(nextPageButton==null) {
			nextPageButton=new JButtonModel(buttonTitle.getNext());
			nextPageButton.addActionListener(new ActionListener() {
				public void actionPerformed(ActionEvent e) {
					++currentPageNumber;
					nowpage.setText("µÚ"+currentPageNumber+"Ò³");
					k=Integer.parseInt(getHang().getText().trim());
					a=String.valueOf(currentPageNumber*k-k);
					serch="select * from tb_history_power limit "+a+","+k;
					updateSerch(serch);					
					if(currentPageNumber!=1) {
						firstPageButton.setEnabled(true);
						latePageButton.setEnabled(true);
					}
					if (currentPageNumber == maxPageNumber) {
						nextPageButton.setEnabled(false);
						lastPageButton.setEnabled(false);
					}


				}
			});
		}
		return nextPageButton;
	}

	public JButtonModel getLastPageButton() {
		if(lastPageButton==null) {
			lastPageButton=new JButtonModel(buttonTitle.getLast());
			lastPageButton.addActionListener(new ActionListener() {
				public void actionPerformed(ActionEvent e) {
					nextPageButton.setEnabled(false);
					lastPageButton.setEnabled(false);
					k=Integer.parseInt(getHang().getText().trim()); 
					a=String.valueOf(getMaxPageNumber()*k-k);
					serch="select * from tb_history_power limit "+a+","+k;
					updateSerch(serch);	
					latePageButton.setEnabled(true);
					firstPageButton.setEnabled(true);
					currentPageNumber=getMaxPageNumber();
					nowpage.setText("µÚ"+currentPageNumber+"Ò³");

				}
			});

		}
		return lastPageButton;
	}

	/**ÿҳÏÔʾÐÐÊý*/
	public JTextField getHang() {
		if(hang==null) {
			hang=new JTextField(5);
			hang.setText("200");

		}
		return hang;

	}
	
	public int getMaxPageNumber() {
		String sql="select * from tb_history_power order by id desc";
		allrows=DatabaseManagement.serch(sql).size();
		double k=Integer.parseInt(getHang().getText().trim());
		double j=allrows/k;
		return maxPageNumber=(int) Math.ceil(j);

		//Math.ceil() º¯Êý·µ»Ø´óÓÚ»òµÈÓÚÒ»¸ö¸ø¶¨Êý×ÖµÄ×îСÕûÊý
	}


	/**»ñÈ¡ËÑË÷Îı¾¿òµÄ·½·¨*/
	public JTextField getSearchFileld() {
		if(searchFileld==null){
			searchFileld=new JTextField(10);
			searchFileld.addKeyListener(new KeyListener() {	//¼üÅÌʼþ¼àÌý				
				public void keyTyped(KeyEvent e) {		
				}					
				public void keyReleased(KeyEvent e) {
					int keyCode=e.getKeyCode();
					if(keyCode==KeyEvent.VK_ENTER) {
						getSearch().doClick();//ËÑË÷°´Å¥±»µã»÷
					}						
				}					
				public void keyPressed(KeyEvent e) {				
				}
			});
		}
		return searchFileld;
	}


	/**»ñÈ¡ËÑË÷°´Å¥µÄ·½·¨*/	
	public JButtonModel getSearch() {
		if(search==null){
			search=new JButtonModel(buttonTitle.getSerch());
			search.addActionListener(new ActionListener() {	
				public void actionPerformed(ActionEvent e) {
					// Ö´ÐÐSQL²éѯÓï¾ä»ñµÃµÄ½á¹û¼¯	
					try {	
						if(getSearchFileld().getText().length()>1) {
							String go=searchFileld.getText().trim();
							String a="select * from tb_history_power  where tagid= '"+go+ "'  limit 500";
							updateSerch(a);	
						}
					} catch (Exception er) {
						er.printStackTrace();
					}
				}
			});
		}
		return search;
	}


	/**»ñȡˢа´Å¥µÄ·½·¨*/	
	public JButtonModel getShuaxin() {
		if(shuaxin==null){
			shuaxin=new JButtonModel(buttonTitle.getRefresh());
			shuaxin.addActionListener(new ActionListener() {
				public void actionPerformed(ActionEvent e) {
					updateTable();
				}
			});

		}
		return shuaxin;
	}


	/**»ñȡɾ³ý°´Å¥µÄ·½·¨*/	
	public JButtonModel getDelete() {
		if(delete==null){
			delete=new JButtonModel(buttonTitle.getDelete());
			delete.addActionListener(new ActionListener() {
				public void actionPerformed(ActionEvent e) {
					int[] selectedRows=table.getSelectedRows();//±»Ñ¡ÖÐÐеÄË÷Òý¼¯ºÏ
					if(selectedRows.length !=0) {
						for(int i=0;i<selectedRows.length;i++){				
							String deleteSql="DELETE FROM tb_history_power WHERE id='"+table.getValueAt(selectedRows[i], 0)+"'";
							DatabaseManagement.update(deleteSql);// ɾ³ý±êÇ©ÐÅÏ¢	
						}
						
						//ɾ³ýËùÓб»Ñ¡ÖеÄÐÐ
						for(int j=selectedRows.length-1;j>=0;j--){//ÕâÊǹؼü´úÂë
							tableModel.removeRow(selectedRows[j]);//ɾ³ýÈÎÒⱻѡÖÐÐÐ
						}
						table.setModel(tableModel);//¸üбí¸ñÄ£ÐÍ

						//ɾ³ý³É¹¦ÌáʾÐÅÏ¢
						ShowMessage.delteSuccess(selectedRows.length);					

					}
					else {
						ShowMessage.zidingyi("ÇëÑ¡ÖÐÐèҪɾ³ýµÄÐУ¡");				
					}
					updateTable();
				}
			});
		}
		return delete;
	}


	/**»ñÈ¡È«²¿É¾³ý°´Å¥µÄ·½·¨*/	
	public JButtonModel getDeleteAll() {
		if(deleteAll==null){
			deleteAll=new JButtonModel(buttonTitle.getDeleteall());
			deleteAll.addActionListener(new ActionListener() {
				public void actionPerformed(ActionEvent e) {
					//Ñ¡Ôñ¶Ô»°¿òÈçyes·µ»Ø0£¬NO·µ»Ø1£¬È¡Ïû·µ»Ø2
					WarningMessage warning=new WarningMessage();
					warning.setMessage("Ñ¡Ôñɾ³ýÈ«²¿½«»á°Ñ±í¸ñÊý¾ÝÈ«²¿É¾³ýÈ·¶¨Âð£¿");
					int warn=warning.getwarMss(getNorthJpanel());
					int tagnum=table.getRowCount();//±í¸ñ×ÜÐÐÊý
					if(tagnum!=0 && warn==0) {
						String deleteSql="TRUNCATE TABLE tb_history_power";
						ShowMessage.deleteAll(DatabaseManagement.update(deleteSql));
					}
					
					int a = table.getRowCount();
					for (int i = 0; i < a; i++) {
						tableModel.removeRow(0);
					}
					rq.repaint();
				}
			});

		}
		return deleteAll;
	}

	/**»ñÈ¡µ¼³ö±í¸ñ°´Å¥µÄ·½·¨*/	
	public JButtonModel getOutport() {
		OutButton.setAddtime("time");
		OutButton.setDataName("tb_history_power");
		return new OutButton().get_ouotport_button();
	}

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


	/**Ìí¼Ó±í¸ñÐÐÏòÁ¿Êý¾Ý·½·¨*/ 
	@SuppressWarnings("unchecked")
	public void getRowData(List list ) {
		Iterator iterator = list.iterator();//´´½¨µü´úÆ÷		
		while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ			
			List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
			Vector row = new Vector();	
			row.add(String.valueOf(info.get(0)));// ÐòºÅ
			row.add(String.valueOf(info.get(1)));// ±êÇ©ID
			row.add(String.valueOf(info.get(2)));// ±êÇ©µçÁ¿
			row.add(Integer.parseInt(String.valueOf(info.get(2))));// ±êÇ©µçÁ¿
			row.add(String.valueOf(info.get(3)));// ¸üÐÂʱ¼ä
			tableModel.addRow(row);// Ïò±í¸ñ¶ÔÏóÌí¼ÓÐÐÊý¾Ý
		}	

	}


	/**»ñÈ¡±êÇ©µçÁ¿±í¸ñµÄ·½·¨*/	
	@SuppressWarnings("serial")
	public JTable getTable() {
		if(table==null) {
			String[] name1= {"ÐòºÅ","±êÇ©ID","µçÁ¿(%)","µçÁ¿×´Ì¬","ʱ¼ä"};//±í¸ñÁÐÃû
			String[] name2= {"Serial Number","Tag ID","Power(%)","Power Status","Time"};//±í¸ñÁÐÃû
			String[] columnNames=English.columnNames(name1, name2);
			//Ìí¼Ó±í¸ñÁÐÏòÁ¿
			Vector<String> columnName=new Vector<>();
			for(int i=0;i<columnNames.length;i++){
				columnName.add(columnNames[i]);			
			}
			
			String sql="select * from tb_history_power  order by id desc limit 500 ";
			list = DatabaseManagement.serch(sql);//½«ÁбíÖÐËùÓнá¹û¼¯¸øµ½list¼¯ºÏ	
			
			greateTables tables=new greateTables();
			tableModel=new DefaultTableModel(rowData, columnName){  
				//  ʵÏÖÈÃÕû¸ö±í¸ñ²»²»ÔÊÐí±»±à¼­
				public boolean isCellEditable(int row,int column){  
					return false;  
				}  
			};
			table=tables.getTable(tableModel);	
			getRowData(list );
			table.getColumnModel().getColumn(3).setPreferredWidth(135);// ÉèÖõÚ3Áпí
			TableColumn column = table.getColumnModel().getColumn(3);// »ñÈ¡±í¸ñµÚ4ÁжÔÏó
			column.setCellRenderer(new TableCellRenderer() {// ÉèÖõÚ4ÁеÄäÖȾÆ÷                
				public Component getTableCellRendererComponent(
						JTable table, Object value, boolean isSelected,
						boolean hasFocus, int row, int column) {
					if (value instanceof Integer) {
						JProgressBar bar=new JProgressBar();//´´½¨½ø¶ÈÌõ
						Integer percent=(Integer)value;//°Ñµ±Ç°Öµ×ªÎªÕûÊý
						bar.setValue(percent);//ÉèÖýø¶ÈÌõµÄÖµ
						//bar.setStringPainted(true);//ÏÔʾ½ø¶ÈÌõÎı¾
						if(percent<=15) {
							bar.setForeground(Color.red);//ÏÔʾ½ø¶ÈÌõµÄÑÕÉ«
						}
						else if(percent>50) {
							bar.setForeground(Color.green);//ÏÔʾ½ø¶ÈÌõµÄÑÕÉ«	
						}
						else if(percent<=50 && percent>15) {
							bar.setForeground(Color.yellow);//ÏÔʾ½ø¶ÈÌõµÄÑÕÉ«	
						}
						
						bar.setBackground(UIColor.getNorth_color());

						bar.setBorderPainted(false);//ÊÇ·ñÏÔʾ½ø¶ÈÌõ±ß¿ò
						
						if (row % 2 == 0) {
							bar.setBackground(UIColor.getTable_1());
				        } else {
				        	bar.setBackground(UIColor.getTable_2());
				        }
						
						if(isSelected) {
							bar.setBackground(UIColor.getTable_sekected());	
						}
						return bar;// °Ñͼ±ê×÷ΪΪäÖȾ¿Ø¼þ
					}
					else {
						return null;
					}
				}
			});
			
		}
		return table;
	}


	/**ˢбí¸ñ·½·¨*/
	public void updateTable() {	
		
		if(tableModel !=null) {
			tableModel.getDataVector().clear();
			String sql="select * from tb_history_power  order by id desc limit 500";
			list = DatabaseManagement.serch(sql);
			getRowData(list);
			gd.validate();
			}
		
	}


	/**ËÑË÷·½·¨*/
	public void updateSerch(String serch) {		
		if(tableModel !=null) {
			tableModel.getDataVector().clear();
			list = DatabaseManagement.serch(serch);//½«ÁбíÖÐËùÓнá¹û¼¯¸øµ½list¼¯ºÏ
			getRowData(list);
			}
	}
	
	public JButtonModel getOpen() {
		if(open==null) {
			open=new JButtonModel(buttonTitle.getAnalysis());
			open.addActionListener(new ActionListener() {
				public void actionPerformed(ActionEvent e) {
					Dell_hispower.getHispower_vec().removeAllElements();
					tagid=searchFileld.getText().trim();
					if(tagid.length()>3){
						Dell_hispower.insert(tagid);
						if(dialog==null) {
							dialog=new Dialog(tagid+"µçÁ¿");
						}
					}else {
						ShowMessage.zidingyi("ÇëÊäÈëÕýÈ·µÄÉ豸±àºÅ");
					}					
				}
			});
		}
		return open;
	}
	
	class Dialog extends JDialog implements WindowListener{

		/**
		 * 
		 */
		private static final long serialVersionUID = 1L;
		/**»ñÈ¡¶Ô»°¿ò·½·¨*/
		public Dialog(String title) {		
			super();
			this.setAlwaysOnTop(true);//×ÜÊÇÖö¥			
			this.setTitle(title);
			Toolkit toolkit = getToolkit();// »ñµÃ´°Ì幤¾ß°ü
			Dimension screenSize = toolkit.getScreenSize();// »ñÈ¡ÆÁÄ»´óС
			int width = (int) (screenSize.width* 0.5);// ¼ÆËã´°Ìåпí¶È
			int height = (int) (screenSize.height * 0.5);// ¼ÆËã´°Ìåпí¶È
			int x0=width-390;//´°Ìåx0×ø±ê
			int y0=height-240;//´°Ìåy0×ø±ê
			Container rq=getContentPane();
			this.setIconImage(new ImageIcon("image/icon/historypowericon.png").getImage());
			this.addWindowListener((WindowListener) this);
			rq.add(new LineXy().getMb(title));
			this.setBounds(x0, y0, 780, 480);
			this.setVisible(true);
		}
		
		
		
		public void windowOpened(WindowEvent e) {
			// TODO ×Ô¶¯Éú³ÉµÄ·½·¨´æ¸ù
			
		}
		@Override
		public void windowClosing(WindowEvent e) {
			// TODO ×Ô¶¯Éú³ÉµÄ·½·¨´æ¸ù
			dialog=null;
			
		}
		@Override
		public void windowClosed(WindowEvent e) {
			// TODO ×Ô¶¯Éú³ÉµÄ·½·¨´æ¸ù
			
		}
		@Override
		public void windowIconified(WindowEvent e) {
			// TODO ×Ô¶¯Éú³ÉµÄ·½·¨´æ¸ù
			
		}
		@Override
		public void windowDeiconified(WindowEvent e) {
			// TODO ×Ô¶¯Éú³ÉµÄ·½·¨´æ¸ù
			
		}
		@Override
		public void windowActivated(WindowEvent e) {
			// TODO ×Ô¶¯Éú³ÉµÄ·½·¨´æ¸ù
			
		}
		@Override
		public void windowDeactivated(WindowEvent e) {
			// TODO ×Ô¶¯Éú³ÉµÄ·½·¨´æ¸ù
			
		}
		
	}

}