package com.sccp.StudentMS.baseFrame;

import java.awt.BorderLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.DefaultComboBoxModel;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextField;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.sccp.StudentMS.DBtools.DBtool;
import com.swtdesigner.SwingResourceManager;

public class PeopleStatisticFrame extends JFrame {

	private JTextField cName;
	private JComboBox sex;
	private JTextField max;
	private JTextField min;
	private JComboBox type;
	DBtool db=new DBtool();
	ResultSet rs,rs1;
	String sql;
	 JLabel l2;
	 JLabel l3;
	 JLabel  l4  ;
	 
	 
	 
	/**
	 * Launch the application
	 * @param args
	 */
	public static void main(String args[]) {
		try {
			PeopleStatisticFrame frame = new PeopleStatisticFrame();
			frame.setVisible(true);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	/**
	 * Create the frame
	 */
	public PeopleStatisticFrame() {
		super();
		setTitle("人員統計");
		setBounds(100, 100, 500, 209);
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

		final JPanel panel = new JPanel();
		panel.setLayout(null);
		getContentPane().add(panel, BorderLayout.CENTER);

		final JLabel l1 = new JLabel();
		l1.setText("請選擇統計選項：");
		l1.setBounds(54, 23, 143, 15);
		panel.add(l1);

		type = new JComboBox();
		type.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				if(type.getSelectedItem().equals("學號"))
				{
					l2.setText("請輸入統計范圍：");
					setvisible(true,true,true,true,true,false,false);
				}
				else if(type.getSelectedItem().equals("性別"))
				{
					l2.setText("請選擇性別：");
					setvisible(true,false,false,false,false,true,false);
				}
				else if(type.getSelectedItem().equals("班級"))
				{
					l2.setText("請輸入班級：");
					setvisible(true,false,false,false,false,false,true);
				}
				else if(type.getSelectedItem().equals("出生年月"))
				{
					l2.setText("請輸入統計范圍：");
					setvisible(true,true,true,true,true,false,false);
				}
				
					
			}
		});
		type.setModel(new DefaultComboBoxModel(new String[] {"學號", "性別", "班級", "出生年月"}));
		type.setBounds(53, 62, 107, 23);
		panel.add(type);

		final JButton button = new JButton();
		button.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				sql="select * from studentInfo ";
				if(type.getSelectedIndex()==0)
				{
					 if(min.getText().equals("")&&max.getText().equals(""))
						 JOptionPane.showMessageDialog(null, "統計范圍不能為空！");
					 else 
				   {
						 if(min.getText().equals(""))
						  sql=sql+" where ID <="+max.getText();
					 else if(max.getText().equals(""))
						  sql=sql+" where ID >="+min.getText();
					 else 
					 {
						  sql=sql+" where ID >="+min.getText();
						  sql=sql+" and  ID<="+max.getText();
					 }
						 execute();
			       }
				}else if(type.getSelectedIndex()==1)
					{
					sql=sql+" where Sex='"+sex.getSelectedItem().toString()+"'";
					 execute();
					}
				else if(type.getSelectedIndex()==2)
				{
					if(cName.getText().equals(""))
						JOptionPane.showMessageDialog(null, "請輸入班級！");
					else
						{
						sql=sql+"where Class='"+cName.getText()+"'";
						 execute();
						}
				}
				else if(type.getSelectedIndex()==3)
				{
					 if(min.getText().equals("")&&max.getText().equals(""))
						 JOptionPane.showMessageDialog(null, "統計范圍不能為空！");
					 else 
				   {
						 if(min.getText().equals(""))
						  sql=sql+" where Birth  <='"+max.getText()+"'";
					 else if(max.getText().equals(""))
						  sql=sql+" where Birth >='"+min.getText()+"'";
					 else 
					 {
						  sql=sql+" where Birth >='"+min.getText()+"'";
						  sql=sql+" and Birth <='"+max.getText()+"'";
					 }
						 execute();
			       }
				}
			
			}
		});
		button.setText("確定");
		button.setBounds(88, 136, 74, 23);
		panel.add(button);

		final JButton button_1 = new JButton();
		button_1.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				PeopleStatisticFrame.this.dispose();
			}
		});
		button_1.setText("取消");
		button_1.setBounds(212, 136, 73, 23);
		panel.add(button_1);

		 l2 = new JLabel();
		l2.setText("請輸入統計范圍：");
		l2.setBounds(237, 23, 136, 15);
		panel.add(l2);

		  l3 = new JLabel();
		l3.setText("從");
		l3.setBounds(237, 66, 29, 15);
		panel.add(l3);

		  l4 = new JLabel();
		l4.setText("至");
		l4.setBounds(373, 66, 19, 15);
		panel.add(l4);

		min = new JTextField();
		min.setBounds(272, 64, 95, 20);
		panel.add(min);

		max = new JTextField();
		max.setBounds(397, 64, 85, 20);
		panel.add(max);

		sex = new JComboBox();
		sex.setModel(new DefaultComboBoxModel(new String[] {"男", "女"}));
		sex.setBounds(237, 62, 58, 23);
		panel.add(sex);

		cName = new JTextField();
		cName.setBounds(247, 64, 95, 20);
		panel.add(cName);

		final JLabel label_1 = new JLabel();
		panel.add(label_1);
		label_1.setIcon(SwingResourceManager.getIcon(PeopleStatisticFrame.class, "/images/cool15.gif"));
		label_1.setText(" ");
		label_1.setBounds(300, 105, 115, 54);

		final JLabel label = new JLabel();
		label.setIcon(SwingResourceManager.getIcon(PeopleStatisticFrame.class, "/images/發.JPG"));
		label.setText(" ");
		label.setBounds(0, 0, 492, 178);
		panel.add(label);

	  
		setvisible(true,true,true,true,true,false,false);
		//
	}
	public void setvisible(boolean bl2,boolean bl3,boolean bl4,boolean bmin,boolean bmax,boolean bsex,boolean bcName)
	{
		l2.setVisible(bl2);
		l3.setVisible(bl3);
		l4.setVisible(bl4);
		min.setVisible(bmin);
		max.setVisible(bmax);
		sex.setVisible(bsex);
		cName.setVisible(bcName);
	}
	public void listShow()
	{
		StudentInfoTableFrame sitf=new StudentInfoTableFrame();
		sitf.showTableStudentInfo(rs1);
		sitf.setVisible(true);
		sitf.setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);
	}
  public void execute()
  {
		 rs=db.getResult(sql);	
		 rs1=db.getResult(sql);				      
		 try {
			if(rs.next())
			 {  
				 listShow();
				 PeopleStatisticFrame.this.dispose();
			 }else
			 {
				 JOptionPane.showMessageDialog(null, "無滿足條件的學生信息！");
			 }
		} catch (SQLException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
  }
}