package cn.st.util;

import java.awt.Toolkit;
import java.net.URL;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.swing.ImageIcon;

import cn.st.data.ClassInfo;
import cn.st.data.CoursesInfo;
import cn.st.data.DataBaseConnector;
import cn.st.data.KeMuChengJi;
import cn.st.data.StudentInfo;

import com.db4o.ObjectContainer;
import com.db4o.ObjectSet;

public class OtherUtil {

	/**
	 * 得到所有的學(xué)生對(duì)象
	 * @return 一個(gè)包含了學(xué)生對(duì)象的list。
	 */
	public List<StudentInfo> getStudentInfos() {
		ObjectContainer oc = DataBaseConnector.getDb();
		ObjectSet query = oc.query(StudentInfo.class);
		List<StudentInfo> list = new ArrayList<StudentInfo>();
		while(query.hasNext()) {
			list.add((StudentInfo) query.next());
		}
		oc.close();

		return list;
	}

	/**
	 * 獲得指定的學(xué)生對(duì)象
	 * @param UUID
	 * @return
	 */
	public StudentInfo getStudentInfo(String UUID) {
		List<StudentInfo> list = this.getStudentInfos();
		for(StudentInfo stuInfo : list) {
			if(stuInfo.getUUID().trim().equals(UUID.trim())) {
				return stuInfo;
			}
		}
		return null;
	}

	/**
	 * 得到所有的classinfo對(duì)象
	 * @return
	 */
	public List<ClassInfo> getClassInfos() {
		ObjectContainer oc = DataBaseConnector.getDb();
		ObjectSet query = oc.query(ClassInfo.class);
		List<ClassInfo> list = new ArrayList<ClassInfo>();
		while(query.hasNext()) {
			list.add((ClassInfo) query.next());
		}
		oc.close();

		return list;
	}

	/**
	 * 得到一個(gè)班級(jí)名和班級(jí)對(duì)象一一對(duì)應(yīng)的map;
	 * @return
	 */
	public Map<String, ClassInfo> getClassInfosMap() {
		List<ClassInfo> list = this.getClassInfos();
		Map<String, ClassInfo> classMap = new HashMap<String, ClassInfo>();
		for(ClassInfo ci : list) {
			classMap.put(ci.getName(), ci);
		}

		return classMap;
	}

	/**
	 * 根據(jù)className獲得一個(gè)班級(jí)對(duì)象
	 * @param className
	 * @return
	 */
	public ClassInfo getClassInfoByName(String className) {
		Map<String, ClassInfo> classMap = this.getClassInfosMap();
		if(classMap != null) {

			return classMap.get(className);
		}

		return null;
	}

	/**
	 * 根據(jù)班級(jí)的uuid獲得班級(jí)對(duì)象
	 * @param UUID
	 * @return
	 */
	public ClassInfo getClassInfoBYUUID(String UUID) {
		List<ClassInfo> list = this.getClassInfos();
		for(ClassInfo ci : list){
			if(ci.getUUID().trim().equals(UUID.trim())){
				return ci;
			}
		}

		return null;
	}

	/**
	 * 獲得所有科目的對(duì)象
	 * @return
	 */
	public List<CoursesInfo> getCourseInfos() {
		ObjectContainer oc = DataBaseConnector.getDb();
		ObjectSet query = oc.query(CoursesInfo.class);
		List<CoursesInfo> list = new ArrayList<CoursesInfo>();
		while(query.hasNext()) {
			list.add((CoursesInfo) query.next());
		}
		oc.close();

		return list;
	}

	/**
	 * 根據(jù)課程的編號(hào)獲得課程信息
	 * @param couNum 課程編號(hào)
	 * @return
	 */
	public CoursesInfo getCourseInfo(String couNum) {
		List<CoursesInfo> list = this.getCourseInfos();
		for(CoursesInfo ci : list){
			if(ci.getNumber().trim().equals(couNum.trim())) {
				return ci;
			}
		}

		return null;
	}

	/**
	 * 根據(jù)課程的名字獲得課程信息,不建議使用，請(qǐng)用
	 * public CoursesInfo getCourseInfo(String couNum)
	 * 替代
	 * @param couName 課程名
	 * @return
	 */
	@Deprecated
	public CoursesInfo getCoursesInfo(String couName){
		List<CoursesInfo> list = this.getCourseInfos();
		for(CoursesInfo ci : list){
			if(ci.getName().trim().equals(couName.trim())) {
				return ci;
			}
		}

		return null;
	}

	/**
	 * 獲得所有成績(jī)對(duì)象
	 * @return
	 */
	public List<KeMuChengJi> getKeMuChengJis() {
		ObjectContainer oc = DataBaseConnector.getDb();
		ObjectSet query = oc.query(KeMuChengJi.class);
		List<KeMuChengJi> list = new ArrayList<KeMuChengJi>();
		while(query.hasNext()) {
			list.add((KeMuChengJi) query.next());
		}
		oc.close();

		return list;
	}
	/**
	 *獲得指定學(xué)生的科目成績(jī)
	 * @param stuInfo
	 * @return
	 */
	public List<KeMuChengJi> getKeMuChengJis(StudentInfo stuInfo) {
		List<KeMuChengJi> tmp = this.getKeMuChengJis();
		List<KeMuChengJi> list = new ArrayList<KeMuChengJi>();
		for(KeMuChengJi kmcj : tmp) {
			if(kmcj.getStuInfo().getUUID().trim().equals(stuInfo.getUUID().trim())) {
				list.add(kmcj);
			}
		}

		return list;
	}
	
	public ImageIcon getImage(Class clazz, String fileName) {
		 URL url = clazz.getResource(fileName);
	        if (url == null)
	            return null;

	        return new ImageIcon(Toolkit.getDefaultToolkit().getImage(url));
	}
	
}