/*
 * @(#)BusinessBean.java 
 *
 * Copyright 2003 by SYNTC, All rights reserved.
 *
 * This software is the confidential and proprietary information of SYNTC.
 * ("Confidential Information").
 */
package cn.com.syntc.webapp.business;

import javax.servlet.*;
import javax.servlet.http.*;

import cn.com.syntc.common.action.*;
import cn.com.syntc.common.io.*;
import cn.com.syntc.common.util.*;
import cn.com.syntc.common.type.*;
import cn.com.syntc.webapp.taglib.CheckLogin;

import cn.com.syntc.webapp.session.UserSession;

/**
 * 考試信息<br>
 * @author wang yong
 * @version 1.0
 */
public class ExaminationBean extends BusinessLogic{
  /**
   * 構(gòu)造函數(shù)
   */
  public ExaminationBean(){
    System.out.println("FrameWork：業(yè)務(wù)處理類實例化完成【" + this.getClass().getName() + "】");
  }

  /**
   * 業(yè)務(wù)邏輯處理機(jī)能
   */
  public void execute(HttpServletRequest request, HttpServletResponse response, Parameters parameters) throws CommonException{
    try{
      String strSql = "";
      ResultSet resultset = null;
      SqlUtil sqlutil = new SqlUtil();

      UserSession USession = (UserSession)request.getSession().getAttribute("UserSession");

      String command = request.getParameter("command")==null?"":request.getParameter("command");

      String libid = "";
      if(request.getParameter("libid")!=null)
      {
        libid = (String)request.getParameter("libid");
      }

      String libname = "";
      if(request.getParameter("libname")!=null)
      {
        libname = (String)request.getParameter("libname");
      }


      String category = "";
      if(request.getParameter("category")!=null)
      {
        category = (String)request.getParameter("category");
      }
      else
      {
        category = "1";  // 判斷題
      }

      // 判斷題庫ID列表
      String YesNoNameListHidden = "";
      String[] YesNoNameList = null;
      if(request.getParameter("YesNoNameListHidden")!=null)
      {
        YesNoNameListHidden = (String)request.getParameter("YesNoNameListHidden");
        if(!YesNoNameListHidden.equals(""))
        {
          YesNoNameList = StringUtil.split(YesNoNameListHidden, ",");
        }
      }

      // 單選題庫ID列表
      String SingleNameListHidden = "";
      String[] SingleNameList = null;
      if(request.getParameter("SingleNameListHidden")!=null)
      {
        SingleNameListHidden = (String)request.getParameter("SingleNameListHidden");
        if(!SingleNameListHidden.equals(""))
        {
          SingleNameList = StringUtil.split(SingleNameListHidden, ",");
        }
      }

      // 多選題庫ID列表
      String MutiNameListHidden = "";
      String[] MutiNameList = null;
      if(request.getParameter("MutiNameListHidden")!=null)
      {
        MutiNameListHidden = (String)request.getParameter("MutiNameListHidden");
        if(!MutiNameListHidden.equals(""))
        {
          MutiNameList = StringUtil.split(MutiNameListHidden, ",");
        }
      }
      
      // 答題結(jié)果
      String YesNoValueListHidden = request.getParameter("YesNoValueListHidden")==null?"":request.getParameter("YesNoValueListHidden");
      String SingleValueListHidden = request.getParameter("SingleValueListHidden")==null?"":request.getParameter("SingleValueListHidden");
      String MutiValueListHidden = request.getParameter("MutiValueListHidden")==null?"":request.getParameter("MutiValueListHidden");

      // 成績
      String scoreYesNoHidden = request.getParameter("scoreYesNoHidden")==null?"0":request.getParameter("scoreYesNoHidden");
      String scoreSingleHidden = request.getParameter("scoreSingleHidden")==null?"0":request.getParameter("scoreSingleHidden");
      String scoreMutiHidden = request.getParameter("scoreMutiHidden")==null?"0":request.getParameter("scoreMutiHidden");
      int totalscore = Integer.parseInt(scoreYesNoHidden) + Integer.parseInt(scoreSingleHidden) + Integer.parseInt(scoreMutiHidden);

      strSql = "SELECT CATEGORYID,CATEGORYNAME FROM CATEGORY_TBL";
      resultset = sqlutil.executeQuery(strSql);
      parameters.setParameters("results","CategoryList", resultset);

      strSql = "";
      // 隨機(jī)選題（每種題型各10道）
      if(category.equals("1"))
      {
        if(YesNoNameList!=null && !YesNoNameList.equals(""))
        {
          for(int i=0; i<YesNoNameList.length; i++)
          {
            strSql += "SELECT A.LIBRARYID,A.CATEGORYID,B.CATEGORYNAME,A.LEVELID,C.LEVELNAME,A.TITLE,A.ANSWER,A.A,A.B,A.C,A.D,A.E,A.F,A.G,A.ONOFF FROM LIBRARY_TBL A,CATEGORY_TBL B,LEVEL_TBL C WHERE A.CATEGORYID=B.CATEGORYID AND A.LEVELID=C.LEVELID AND A.LIBID='" + libid + "' AND A.LIBRARYID ='" + YesNoNameList[i] + "'";
            if(i!=YesNoNameList.length-1)
            {
              strSql += " UNION ";
            }
          }
        }
        else
        {
          strSql = "SELECT A.LIBRARYID,A.CATEGORYID,B.CATEGORYNAME,A.LEVELID,C.LEVELNAME,A.TITLE,A.ANSWER,A.A,A.B,A.C,A.D,A.E,A.F,A.G,A.ONOFF FROM LIBRARY_TBL A,CATEGORY_TBL B,LEVEL_TBL C WHERE A.CATEGORYID=B.CATEGORYID AND A.LEVELID=C.LEVELID AND A.LIBID='" + libid + "' AND A.CATEGORYID='" +category+ "' AND ONOFF='1' ORDER BY RAND() LIMIT 10";
        }
      }

      if(category.equals("2"))
      {
        if(SingleNameList!=null && !SingleNameList.equals(""))
        {
          for(int i=0; i<SingleNameList.length; i++)
          {
            strSql += "SELECT A.LIBRARYID,A.CATEGORYID,B.CATEGORYNAME,A.LEVELID,C.LEVELNAME,A.TITLE,A.ANSWER,A.A,A.B,A.C,A.D,A.E,A.F,A.G,A.ONOFF FROM LIBRARY_TBL A,CATEGORY_TBL B,LEVEL_TBL C WHERE A.CATEGORYID=B.CATEGORYID AND A.LEVELID=C.LEVELID AND A.LIBID='" + libid + "' AND A.LIBRARYID ='" + SingleNameList[i] + "'";
            if(i!=SingleNameList.length-1)
            {
              strSql += " UNION ";
            }
          }
        }
        else
        {
          strSql = "SELECT A.LIBRARYID,A.CATEGORYID,B.CATEGORYNAME,A.LEVELID,C.LEVELNAME,A.TITLE,A.ANSWER,A.A,A.B,A.C,A.D,A.E,A.F,A.G,A.ONOFF FROM LIBRARY_TBL A,CATEGORY_TBL B,LEVEL_TBL C WHERE A.CATEGORYID=B.CATEGORYID AND A.LEVELID=C.LEVELID AND A.LIBID='" + libid + "' AND A.CATEGORYID='" +category+ "' AND ONOFF='1' ORDER BY RAND() LIMIT 10";
        }
      }


      if(category.equals("3"))
      {
        if(MutiNameList!=null && !MutiNameList.equals(""))
        {
          for(int i=0; i<MutiNameList.length; i++)
          {
            strSql += "SELECT A.LIBRARYID,A.CATEGORYID,B.CATEGORYNAME,A.LEVELID,C.LEVELNAME,A.TITLE,A.ANSWER,A.A,A.B,A.C,A.D,A.E,A.F,A.G,A.ONOFF FROM LIBRARY_TBL A,CATEGORY_TBL B,LEVEL_TBL C WHERE A.CATEGORYID=B.CATEGORYID AND A.LEVELID=C.LEVELID AND A.LIBID='" + libid + "' AND A.LIBRARYID ='" + MutiNameList[i] + "'";
            if(i!=MutiNameList.length-1)
            {
              strSql += " UNION ";
            }
          }
        }
        else
        {
          strSql = "SELECT A.LIBRARYID,A.CATEGORYID,B.CATEGORYNAME,A.LEVELID,C.LEVELNAME,A.TITLE,A.ANSWER,A.A,A.B,A.C,A.D,A.E,A.F,A.G,A.ONOFF FROM LIBRARY_TBL A,CATEGORY_TBL B,LEVEL_TBL C WHERE A.CATEGORYID=B.CATEGORYID AND A.LEVELID=C.LEVELID AND A.LIBID='" + libid + "' AND A.CATEGORYID='" +category+ "' AND ONOFF='1' ORDER BY RAND() LIMIT 10";
        }
      }

      resultset = sqlutil.executeQuery(strSql);
      parameters.setParameters("results","ExaminationList", resultset);

      // 保存考試成績
      if(command.equals("CompleteExam"))
      {
        strSql = "INSERT INTO PAPER_TBL(USERID,LIBID,YESNOLIST,SINGLELIST,MUTILIST,YESNOANSWERS,SINGLEANSWERS,MUTIANSWERS,YESNOSCORE,SINGLESCORE,MUTISCORE,TOTALSCORE,EXAMTIME) VALUES("+USession.getUserID()+","+libid+",'"+YesNoNameListHidden+"','"+SingleNameListHidden+"','"+MutiNameListHidden+"','"+YesNoValueListHidden+"','"+SingleValueListHidden+"','"+MutiValueListHidden+"',"+scoreYesNoHidden+","+scoreSingleHidden+","+scoreMutiHidden+","+totalscore+",SYSDATE())";

        sqlutil.executeUpdate(strSql);
      }

      sqlutil.close();

      parameters.setParameters("results", "ForwardPage", "/framework/exam/examination.jsp");

    }
    catch(Exception ex){
      System.out.println("error:"+ex.getMessage());;
    }
  }


  /**
   * 頁面表單檢測處理機(jī)能
   */
  public void validate(HttpServletRequest request, HttpServletResponse response, Parameters parameters) throws CommonException{


  }

}