package Panel.StudentSroce;

import Sys.dao.*;
import Sys.vo.*;
import Tools.Teacher;


import java.util.*;
import javax.swing.table.*;

public class QueryClassSrocePanel extends javax.swing.JPanel {
	private static final long serialVersionUID = 1L;
	public QueryClassSrocePanel() {
		initComponents();
	}

	private void initComponents() {
		java.awt.GridBagConstraints gridBagConstraints;

		jLabel1 = new javax.swing.JLabel();
		jLabel2 = new javax.swing.JLabel();
		jComboBox1 = new javax.swing.JComboBox();
		jLabel3 = new javax.swing.JLabel();
		jTextField1 = new javax.swing.JTextField();
		jScrollPane1 = new javax.swing.JScrollPane();
		jTable1 = new javax.swing.JTable();
		jLabel4 = new javax.swing.JLabel();
		jTextField2 = new javax.swing.JTextField();

		setLayout(new java.awt.GridBagLayout());

		jLabel1.setFont(new java.awt.Font("宋體", 1, 24));
		jLabel1.setText("\u67e5\u8be2\u73ed\u7ea7\u6210\u7ee9");
		gridBagConstraints = new java.awt.GridBagConstraints();
		gridBagConstraints.gridwidth = java.awt.GridBagConstraints.REMAINDER;
		add(jLabel1, gridBagConstraints);

		jLabel2.setFont(new java.awt.Font("宋體", 0, 14));
		jLabel2.setText("\u73ed\u7ea7");
		gridBagConstraints = new java.awt.GridBagConstraints();
		gridBagConstraints.weightx = 5.0;
		gridBagConstraints.weighty = 20.0;
		add(jLabel2, gridBagConstraints);

		jComboBox1.setFont(new java.awt.Font("宋體", 0, 18));
		jComboBox1.setPreferredSize(new java.awt.Dimension(130, 23));
		jComboBox1.addItemListener(new java.awt.event.ItemListener() {
			public void itemStateChanged(java.awt.event.ItemEvent evt) {
				jComboBox1ItemStateChanged(evt);
			}
		});
		gridBagConstraints = new java.awt.GridBagConstraints();
		gridBagConstraints.weightx = 5.0;
		gridBagConstraints.weighty = 20.0;
		add(jComboBox1, gridBagConstraints);

		jLabel3.setFont(new java.awt.Font("宋體", 0, 14));
		jLabel3.setText("\u73ed\u4e3b\u4efb");
		gridBagConstraints = new java.awt.GridBagConstraints();
		gridBagConstraints.weightx = 5.0;
		gridBagConstraints.weighty = 20.0;
		add(jLabel3, gridBagConstraints);

		jTextField1.setColumns(20);
		jTextField1.setEditable(false);
		jTextField1.setFont(new java.awt.Font("宋體", 0, 14));
		gridBagConstraints = new java.awt.GridBagConstraints();
		gridBagConstraints.gridwidth = java.awt.GridBagConstraints.REMAINDER;
		gridBagConstraints.weightx = 5.0;
		gridBagConstraints.weighty = 20.0;
		add(jTextField1, gridBagConstraints);

		jTable1.setRowHeight(jTable1.getRowHeight()+6);
		jScrollPane1.setViewportView(jTable1);

		gridBagConstraints = new java.awt.GridBagConstraints();
		gridBagConstraints.gridwidth = java.awt.GridBagConstraints.REMAINDER;
		gridBagConstraints.fill = java.awt.GridBagConstraints.HORIZONTAL;
		gridBagConstraints.weightx = 5.0;
		gridBagConstraints.weighty = 20.0;
		add(jScrollPane1, gridBagConstraints);

		jLabel4.setText("\u603b\u4eba\u6570");
		gridBagConstraints = new java.awt.GridBagConstraints();
		gridBagConstraints.gridx = 0;
		gridBagConstraints.gridy = 3;
		gridBagConstraints.weightx = 5.0;
		gridBagConstraints.weighty = 20.0;
		add(jLabel4, gridBagConstraints);

		jTextField2.setColumns(20);
		gridBagConstraints = new java.awt.GridBagConstraints();
		gridBagConstraints.gridx = 1;
		gridBagConstraints.gridy = 3;
		gridBagConstraints.weightx = 5.0;
		gridBagConstraints.weighty = 20.0;
		add(jTextField2, gridBagConstraints);
		
		java.util.List<ClassInfo> list=null;
		ClassDao classdao=new ClassDao();
		list=classdao.getAllClass();
		Iterator<ClassInfo> iter=list.iterator();
		while(iter.hasNext())
			jComboBox1.addItem(iter.next().getClassID());
		nameCounts((String)jComboBox1.getSelectedItem());
	}
	
	private void nameCounts(String classid){
		TeacherDao teacherdao=new TeacherDao();
		Teacher teacher=teacherdao.getTeacher(classid);
		jTextField1.setText(teacher.getTeacherName());
		StudentInfoDao studentinfodao=new StudentInfoDao();
		List<StudentInfo> list=studentinfodao.getClassStudentInfo(classid);
		jTextField2.setText(Integer.toString(list.size()));
		
		//加載表頭
		CourseClassDao courseclassdao=new CourseClassDao();
		List<Course> list0=courseclassdao.getCourseForClass(classid);
		int j=0,t=list0.size();
		String []columnNames=new String[6+t]; 
		columnNames[0]="序號";
		columnNames[1]="學號";
		columnNames[2]="姓名";
		columnNames[3]="性別";
		Iterator<Course> iter0=list0.iterator();
		while(iter0.hasNext()){
			columnNames[4+j]=((Course)iter0.next()).getCourseName();
			j++;
		}
		columnNames[6+t-2]="平均分";
		columnNames[6+t-1]="總分";
		jTable1.setModel(tablemodel=new DefaultTableModel(columnNames,0){
			private static final long serialVersionUID = 1L;
			public boolean isCellEditable(int row, int col) {
				return false;
		    }
		});
		jTable1.getTableHeader().setReorderingAllowed(false);

		//加載數據
		StudentSroceDao studentsrocedao=new StudentSroceDao();
		Iterator<StudentInfo> iter=list.iterator();
		StudentInfo studentinfo=null;
		int o=1;
		while(iter.hasNext()){
			studentinfo=(StudentInfo)iter.next();
			List<StudentSroce> list1=studentsrocedao.getStudentSroce((studentinfo).getStudentID());
			Iterator<StudentSroce> iter1=list1.iterator();
			int i=0;
			double total=0.0;
			String []content=new String[6+t];
			content[0]=String.valueOf(o);
			content[1]=studentinfo.getStudentID();
			content[2]=studentinfo.getStudentName();
			content[3]=studentinfo.getSex();
			StudentSroce studentsroce=null;
			while(iter1.hasNext()){
				studentsroce=(StudentSroce)iter1.next();
				content[4+i]=Double.toString(studentsroce.getSroce());
				total+=studentsroce.getSroce();
				i++;
			}
			content[6+t-2]=Double.toString(total/i);
			content[6+t-1]=Double.toString(total);
			tablemodel.addRow(content);
			o++;
		}
	}
	private void jComboBox1ItemStateChanged(java.awt.event.ItemEvent evt) {
		nameCounts((String)jComboBox1.getSelectedItem());
	}

	private DefaultTableModel tablemodel;
	private javax.swing.JComboBox jComboBox1;
	private javax.swing.JLabel jLabel1;
	private javax.swing.JLabel jLabel2;
	private javax.swing.JLabel jLabel3;
	private javax.swing.JLabel jLabel4;
	private javax.swing.JScrollPane jScrollPane1;
	private javax.swing.JTable jTable1;
	private javax.swing.JTextField jTextField1;
	private javax.swing.JTextField jTextField2;
}