package com.huawei.icd30.agt.lesson;

import org.apache.struts.action.Action;
import javax.servlet.http.*;
import java.sql.SQLException;
import org.apache.struts.action.*;
import com.huawei.icd30.agt.util.OperatorFlagCode;
import com.huawei.icd30.common.db.*;
import java.util.Date;
import com.huawei.icd30.agt.util.*;
import com.huawei.icd30.common.systemconfig.*;

/**
 *
 * <p> 本類的功能描述信息</p>
 * <p> (這家伙很懶，什么都沒(méi)有寫)</p>
 * <p> </p>
 * <p> </p>
 * @author 高陽(yáng)
 * @version 1.0
 */
public class LessonOperatorAction extends Action
{
    public ActionForward perform(ActionMapping mapping,
                                 ActionForm    form1,
                                 HttpServletRequest request,
                                 HttpServletResponse response)
    {
        log("begin lesson now .......");

        LessonMngOperatorForm form       = (LessonMngOperatorForm)form1;
        String operatorFlag            =  form.getOperatorFlag();
        log(operatorFlag+"operatorFlag");
        operatorFlag  = operatorFlag==null?request.getParameter("operatorFlag")
                        :operatorFlag;


        if( operatorFlag.equals(OperatorFlagCode.LESSON_ADD))
        {
            return add(mapping ,form,request);
        }
        else if( operatorFlag.equals(OperatorFlagCode.LESSON_CHECKLIST))
        {
            return checkList(mapping ,form,request);
        }
        else if( operatorFlag.equals(OperatorFlagCode.LESSON_DRAFTLIST))
        {
            return draftList(mapping ,form,request);
        }
        else if( operatorFlag.equals(OperatorFlagCode.LESSON_DRAFT))
        {
            return draftSub(mapping ,form,request);
        }
        else if( operatorFlag.equals(OperatorFlagCode.LESSON_PASSLIST))
        {
            return passList(mapping ,form,request);
        }
        else if( operatorFlag.equals(OperatorFlagCode.LESSON_CHECKOPERATOR))
        {
            return checkOperator(mapping ,form,request);
        }
        else if( operatorFlag.equals(OperatorFlagCode.LESSON_CHECK))
        {
            return check(mapping ,form,request);
        }
        else if( operatorFlag.equals(OperatorFlagCode.LESSON_PASSOPERATOR))
        {
            return passOperator(mapping ,form,request);
        }
        else if( operatorFlag.equals(OperatorFlagCode.LESSON_PASS))
        {
            return pass(mapping ,form,request);
        }
        else if( operatorFlag.equals( OperatorFlagCode.LESSON_VIEW)
          || operatorFlag.equals( OperatorFlagCode.LESSON_VIEWSTUDY))
        {
            return view(mapping,form,request);
        }
        else if( operatorFlag.equals(OperatorFlagCode.LESSON_DELETE))
        {
            return delete(mapping ,form,request);
        }
        else if( operatorFlag.equals(OperatorFlagCode.LESSON_MOD))
        {
            return modify(mapping ,form,request);
        }
        else if( operatorFlag.equals(OperatorFlagCode.LESSON_SAVE))
        {
            return save(mapping ,form,request);
        }
        else if( operatorFlag.equals(OperatorFlagCode.LESSON_CANCEL))
        {
            return cancel(mapping ,form,request);
        }
        else if( operatorFlag.equals(OperatorFlagCode.LESSON_QUERY)
          ||  operatorFlag.equals(OperatorFlagCode.LESSON_QUERYSTUDY))
        {
             return manList(mapping,form,request);
        }
        else if(operatorFlag.equals(OperatorFlagCode.LESSON_STAT))
        {
            return lessonStat(mapping,form,request);
        }
        else if(operatorFlag.equals(OperatorFlagCode.LESSON_TAKE))
        {
           return lessonTake(mapping,form,request);
        }
        return null;
    }

    /**
     * 得到所有的發(fā)布課程
     * @param mapping
     * @param form
     * @param req
     * @return
     */
    private ActionForward allList(ActionMapping mapping,
                                  LessonMngOperatorForm    form,
                                  HttpServletRequest req)
    {
        log("allList now ....");
        SysConnPool cspool = null;
        SysDbConn con = null;
        //頂級(jí)目錄應(yīng)該可以配置
        try
        {
            cspool = SysConnPool.getInstance();
            con = cspool.getAplComs();
            con.preparedSP();
            con.setString(1,req.getSession().getAttribute("staffno").toString());
            con.setString(2,"00");
            con.setString(3,"00");
            SysResultSet res = con.csCommonSP("p_agt_lessonall").getResultSet();
            req.getSession().setAttribute("LESSON_SEARCHALL_RES",new ResUtil(res));
        }
        catch(SysDbException e)
        {
            e.printStackTrace();
            req.setAttribute("errorId",ErrorCode.COMMONSERVICE_ERROR);
            return servlet.findForward("error");
        }
        catch(java.sql.SQLException e)
        {
            e.printStackTrace();
            req.setAttribute("errorId",ErrorCode.DATABASE_ERROR);
            return servlet.findForward("error");
        }
        finally
        {
            con.close();
        }
        req.setAttribute("successId",SuccessCode.CLSMNG_ADD);
        return mapping.findForward("alllist");
    }

    /**
     * 按照類別查詢
     * @param mapping
     * @param form
     * @param req
     * @return
     */
    private ActionForward typelist(ActionMapping mapping,
                                  LessonMngOperatorForm    form,
                                  HttpServletRequest req)
    {
        log("typeList now ....");
        SysConnPool cspool = null;
        SysDbConn con = null;
        String classid = req.getParameter("classIdTerm");
        //頂級(jí)目錄應(yīng)該可以配置
        try
        {
            cspool = SysConnPool.getInstance();
            con = cspool.getAplComs();
            con.preparedSP();
            con.setString(1,req.getSession().getAttribute("staffno").toString());
            con.setString(2,"00");
            con.setString(3,"00");
            con.setString(4,classid);
            SysResultSet res = con.csCommonSP("p_agt_lessontype").getResultSet();
            req.getSession().setAttribute("LESSON_SEARCH_RES",new ResUtil(res));
        }
        catch(SysDbException e)
        {
            e.printStackTrace();
            req.setAttribute("errorId",ErrorCode.COMMONSERVICE_ERROR);
            return servlet.findForward("error");
        }
        catch(java.sql.SQLException e)
        {
            e.printStackTrace();
            req.setAttribute("errorId",ErrorCode.DATABASE_ERROR);
            return servlet.findForward("error");
        }
        finally
        {
            con.close();
        }
        req.setAttribute("successId",SuccessCode.CLSMNG_ADD);
        return mapping.findForward("searchlist");
    }

    /**
     * 查詢功能
     * @param mapping
     * @param form
     * @param req
     * @return
     */
    private ActionForward search(ActionMapping mapping,
                                 LessonMngOperatorForm    form,
                                 HttpServletRequest req)
    {
        log("search now ....");
        SysConnPool cspool = null;
        SysDbConn con = null;
        //頂級(jí)目錄應(yīng)該可以配置
        try
        {
            log("form.seach"+form.getSearchSQL());
            cspool = SysConnPool.getInstance();
            con = cspool.getAplComs();
            con.preparedQuery(form.getSearchSQL());
            SysResultSet res = con.csCommonQuery("SELF_SQL_LESSON","1","-1").getResultSet();
            req.getSession().setAttribute("LESSON_SEARCH_RES",res);
        }
        catch(SysDbException e)
        {
            e.printStackTrace();
            req.setAttribute("errorId",ErrorCode.COMMONSERVICE_ERROR);
            return servlet.findForward("error");
        }
        catch(java.sql.SQLException e)
        {
            e.printStackTrace();
            req.setAttribute("errorId",ErrorCode.DATABASE_ERROR);
            return servlet.findForward("error");
        }
        finally
        {
            con.close();
        }
        req.setAttribute("successId",SuccessCode.CLSMNG_ADD);
        return mapping.findForward("searchlist");
    }

    /**
     * 添加課程
     * @param mapping
     * @param form
     * @param req
     * @return
     */
    private ActionForward add(ActionMapping mapping,
                              LessonMngOperatorForm    form,
                              HttpServletRequest req)
    {
        log("add method ....");
        SysConnPool cspool = null;
        SysDbConn con = null;
        java.text.SimpleDateFormat date = new java.text.SimpleDateFormat("yyyy-MM-dd");
        Date endtime   = null;
        Date starthm   = null;
        Date endhm     = null;
        try
        {
            if(form.getEndtime() != null && !("".equalsIgnoreCase(form.getEndtime())))
            {
               endtime  = date.parse(form.getEndtime().trim());
            }
        }
        catch(Exception e)
        {

            e.printStackTrace();
            req.setAttribute("errorId",ErrorCode.DATAFORMAT_ERROR);
            return servlet.findForward("error");
        }

        //處理前端傳遞過(guò)來(lái)的資料,格式是11~12~13
        String matid[] = form.getMatid();
        String matids ="";
        if( matid != null)
        {

            for( int i=0; i < matid.length -1; i++)
            {
                matids += matid[i] +"~";
            }
            matids    = matids +matid[matid.length-1];
        }
        String paperid[] = form.getPaperID();
        String paperids  = "";

        if( paperid != null)
        {
            //處理前端傳遞過(guò)來(lái)的試題格式是111~111
            for( int i=0; i < paperid.length -1; i++)
            {
                paperids  += paperid[i] +"~";
            }
            paperids   = paperids +paperid[paperid.length-1];
        }
        //前端傳遞過(guò)來(lái)的用戶跟組格式如下
        //aaa~0 bb~1;0表示用戶,1表示組
        String[] partyname   = form.getParticipants();
        String part        ="";
        String parttype    = "";
        if( partyname != null)
        {
            for( int i=0; i < partyname.length -1 ;i++)
            {
                String[] temp = partyname[i].split("~");
                part         += temp[0] +"~";
                parttype     += temp[1] +"~";
            }
            String temp[]  = partyname[partyname.length-1].split("~");
            part         = part + temp[0];
            parttype      = parttype +temp[1];
        }

        try
        {
            cspool = SysConnPool.getInstance();
            con = cspool.getAplComs();
            con.preparedSP();
            con.setString(1,form.getDegree());
            log("form.getDegree()" +form.getDegree());
            con.setString(2,form.getClassId());
            log("form.getClassid()"+form.getClassId());
            con.setInt(3,form.getMode());
            log("form.getMode()"+form.getMode());
            con.setString(4,form.getLessonGoal());
            log("form.getLessonGoal()"+form.getLessonGoal());
            con.setString(5,form.getTeacherid());
            log("form.getTeacherid()"+form.getTeacherid());
            con.setString(6,form.getLessonName());
            log("form.getLessonName()"+form.getLessonName());
            con.setString(7,form.getCityid());
            log("form.getCityid()[0]"+form.getCityid());
            con.setString(8,form.getOrganiger());
            log("form.getOrganiger()"+form.getOrganiger());
            con.setDate(9,endtime);
            log("endtime"+endtime);
            con.setInt(10,form.getDuration());
            log("form.getDuration()" +form.getDuration());
            con.setString(11,matids);
            log("matids" + matids);
            con.setString(12,paperids);
            log("paperids" +paperids);
            con.setString(13,form.getNote());
            log("form.getNote()"+form.getNote());
            con.setString(14,req.getSession().getAttribute("staffno").toString());

            con.setString(15,form.getHandleid());

            con.setInt(16,form.getType());
            log("form.getType()"+form.getType());
            con.setString(17,form.getSchoolTime());
            log("form.getSchoolTime()"+form.getSchoolTime());
            con.setString(18,form.getStarthm());
            log("form.getStarthm()"+form.getStarthm());