sumbyqxaction.java

基于JAVA的学生就业信息网 实现对信息浏览 检索 审核 修改和删除

/*
 * Created on 2006-7-31
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package org.ug.sztz.webview.structs.actions.oa;

import java.util.HashMap;
import java.util.List;
import java.util.Vector;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import org.ug.sztz.domain.oa.JYQK;
import org.ug.sztz.domain.oa.StudentBaseInfo;
import org.ug.sztz.domain.oa.StudentJYInfo;

/**
 * @author Skywalker
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class SumByqxAction extends BaseAction {
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		// TODO Auto-generated method stub
		HashMap map = new HashMap();
		map.put("jlstatus", new Integer(1));
		List jyList = this.stuJYDao.getStudentJYInfoList(map);
		Vector all = new Vector();
		JYQK main = new JYQK();
		for (int i = 0; i < jyList.size(); i++) {
			sum(((StudentJYInfo) jyList.get(i)).getJyxs(), main);
		}
		main.setKyl((float) main.getKy() / jyList.size());
		main.setQyl((float) (main.getPq() + main.getKy() + main.getCg())
				/ jyList.size());
		main.setJyl((float) (jyList.size() - main.getEf() - main.getDf())
				/ jyList.size());
		main.setZy("总计");
		main.setSum(jyList.size());
		all.add(main);
		
		
		
		String allsql = "select * from bysbase where xsstatus='1' order by zy";
		map = new HashMap();
		map.put("sql", allsql);

		List allList = this.stuBaseDao.getSQLBaseInfoList(map);
        Vector zyList = new Vector();
        String temp = "";
		for (int i = 0; i < allList.size(); i++) {
			String zy = ((StudentBaseInfo) allList.get(i)).getZy();
			if (!zy.equals(temp)) {
				temp = zy;
				zyList.add(zy);
           }

		}

		for (int i = 0; i < zyList.size(); i++) {
			String sql = "select * from bysbase where xsstatus='1' and zy='" + zyList.get(i) + "'";
			map.put("sql", sql);
			List sList = this.stuBaseDao.getSQLBaseInfoList(map);
			Vector zyjyList = new Vector();
			for(int j=0;j<sList.size();j++)
			{
				StudentJYInfo info = this.stuJYDao.getStudentJYInfoByXh(((StudentBaseInfo)sList.get(j)).getXh());
				zyjyList.add(info);
			}
            JYQK qk = new JYQK();
			for (int j = 0; j < zyjyList.size(); j++) {
				sum(((StudentJYInfo) zyjyList.get(j)).getJyxs(),qk);
			}
			qk.setKyl((float) qk.getKy() / zyjyList.size());
			qk.setQyl((float) (qk.getPq() + qk.getKy() + qk.getCg())
					/ zyjyList.size());
			qk.setJyl((float) (zyjyList.size() - qk.getEf() - qk.getDf())
					/ zyjyList.size());
			qk.setZy((String)zyList.get(i));
			qk.setSum(zyjyList.size());
			all.add(qk);
		}
		request.setAttribute("jyqk",all);
		System.out.println(all.size());
		return mapping.findForward("success");
	}

	private void sum(String jyxs, JYQK qk) {
		jyxs = jyxs.trim();
		if (jyxs.equals("签就业协议")) {
			qk.pq++;
		} else if (jyxs.equals("已上博士后") || jyxs.equals("已上博")
				|| jyxs.equals("已上硕") || jyxs.equals("以上二学位")) {
			qk.ky++;
		} else if (jyxs.equals("已出国")) {
			qk.cg++;
		} else if (jyxs.equals("服务北京基层")) {
			qk.fwjc++;
		} else if (jyxs.equals("志愿服务西部")) {
			qk.fwxb++;
		} else if (jyxs.equals("签劳动合同") || jyxs.equals("灵活就业")
				|| jyxs.equals("单位用人证明") || jyxs.equals("自由职业")
				|| jyxs.equals("自主创业")) {
			qk.yx++;
		} else if (jyxs.equals("回省待就业")) {
			qk.ef++;
		} else if (jyxs.equals("在京待就业")) {
			qk.df++;
		}
	}
}