APS_NEW_004_PREVIEW.jsp

<%@page import="com.csc.library.database.StaticProperties"%>
<%@page import="java.util.Iterator"%>
<%@page import="java.util.LinkedHashMap"%>
<%@page import="java.net.URLDecoder"%>
<%@page import="com.csc.library.utilities.CheckNull"%>
<%@page import="com.csc.library.utilities.MyLog"%>
<%@page import="com.csc.library.session.InitialInquiry"%>
<%@page import="com.csc.library.session.DbInquiry"%>
<%@page import="com.csc.library.entry.HelpEntry"%>
<%@page contentType="text/html; charset=UTF-8"%>
<jsp:useBean id="APS_NEW_004_PREVIEW" class="com.csc.library.system.Task" scope="page"/>
<%
    APS_NEW_004_PREVIEW.setChannel(request,response);
    APS_NEW_004_PREVIEW.checkProfile();
    HelpEntry screen = (HelpEntry) APS_NEW_004_PREVIEW.process("HelpEntry","MQUESTION_GROUPHELP");
    screen.referLangOff();
    CheckNull chk = new CheckNull();
    String lang = screen.getUProfile().get("lang");
    String questionGroupid = request.getParameter("question_groupid");
    MyLog.debug(screen, screen.getUProfile(),"^^ Nut Freedom ^^ ----> questionGroupid ==== " + questionGroupid);
    screen.process();
    int lineNo = 1;
    int tmpLineObjective = 1;
    int tmpLineSubjective = 1;
    int tmpLineSortSentence = 1;
    int tmpLineQuestionnaire = 1;
    int tmpLineQuestionnaireMulti = 1;
    int tmpLineQuestionnaireSubjective = 1;
    int tmpLineMatch = 1;
    
    if(!questionGroupid.equals("")) {
        String[] sp = questionGroupid.split(",");
        for (int i = 0; i < sp.length; i++) {
            try {
    		DbInquiry mquestionGroup = new InitialInquiry(screen.getUProfile()).getDbInquiry("mquestion_group");
    		mquestionGroup.setColumn("*");
    		mquestionGroup.clearOldCondition();
    		mquestionGroup.setFilter("question_groupid = '" + sp[i] + "'");
    		mquestionGroup.refresh();
                while (mquestionGroup.next()) {
                    out.print("<br><strong>" + mquestionGroup.getString("question_group_name") + "</strong><br>");
                    if (!mquestionGroup.getString("objective").equals("")) {
                        out.print("<strong>" + StaticProperties.swapLang.getMessage("OBJECTIVE", lang) + " : " + mquestionGroup.getString("objective") + "</strong><br>");
                        if (mquestionGroup.getString("recommend").equals("")) {
                            out.print("<br>");
                        }
                    }
                    if (!mquestionGroup.getString("recommend").equals("")) {
                        out.print("<strong>" + StaticProperties.swapLang.getMessage("RECOMMEND", lang) + " : " + mquestionGroup.getString("recommend") + "</strong><br>");
                    }
                    try {
                        DbInquiry mquestionGroupDetail = new InitialInquiry(screen.getUProfile()).getDbInquiry("mquestion_group_detail");
                        mquestionGroupDetail.setColumn("*");
                        mquestionGroupDetail.clearOldCondition();
                        mquestionGroupDetail.setFilter("question_groupid = '" + sp[i] + "'");
                        mquestionGroupDetail.refresh();
                        while (mquestionGroupDetail.next()) { 
                            try {
                                DbInquiry msubGroup = new InitialInquiry(screen.getUProfile()).getDbInquiry("msub_group");
                                msubGroup.setColumn("*");
                                msubGroup.setFilter("sub_groupid = '" + mquestionGroupDetail.getString("sub_groupid") + "'");
                                msubGroup.refresh();
                                while (msubGroup.next()) {
                                    out.print("<br><strong>" + msubGroup.getString("sub_group_name") + "</strong>");
                                    try {
                                        DbInquiry msubGroupDetail = new InitialInquiry(screen.getUProfile()).getDbInquiry("msub_group_detail");
                                        msubGroupDetail.setColumn("*");
                                        msubGroupDetail.clearOldCondition();
                                        msubGroupDetail.setFilter("sub_groupid = '" + msubGroup.getString("sub_groupid") + "'");

                                        DbInquiry mquestion = new InitialInquiry(screen.getUProfile()).getDbInquiry("mquestion");
                                        mquestion.setColumn("*");
                                        msubGroupDetail.putChild(mquestion);

                                        msubGroupDetail.refresh();
                                        while (msubGroupDetail.next()) {
                                            String headQuestion = msubGroupDetail.getChild("mquestion").getString("question");
                                            String msgHeadFirst = headQuestion.substring(0, headQuestion.indexOf(">") + 1);
                                            String msgHeadLast = headQuestion.substring(headQuestion.indexOf(">") + 1);
                                            out.print("<br><br><strong>" + msgHeadFirst + (lineNo) + ". " + msgHeadLast + "</strong><br>");
                                            lineNo++;
                                            try {
                                                // ---------- for จับคู่ ----------
                                                LinkedHashMap<Integer, String> fieldQuestionDetail = new LinkedHashMap<Integer, String>();
                                                LinkedHashMap<Integer, String> fieldAnswerMatchDetail = new LinkedHashMap<Integer, String>();
                                                int lineMatch = 1;

                                                // ---------- for เรียงประโยค ----------
                                                LinkedHashMap<Integer, String> fieldSortSentence = new LinkedHashMap<Integer, String>();
                                                int lineSortSentence = 1;

                                                String titleType = msubGroupDetail.getChild("mquestion").getString("title_type");
                                                String queryType = msubGroupDetail.getChild("mquestion").getString("query_type");

                                                DbInquiry mquestionDetail = new InitialInquiry(screen.getUProfile()).getDbInquiry("mquestion_detail");
                                                mquestionDetail.setColumn("*");
                                                mquestionDetail.clearOldCondition();
                                                mquestionDetail.setFilter("questionid = '" + msubGroupDetail.getChild("mquestion").getString("questionid") + "'");
                                                mquestionDetail.refresh();

                                                while (mquestionDetail.next()) {
                                                    //out.print(questionDetail.getString("questionid"));
                                                    String questionDetail = mquestionDetail.getString("question_detail");
                                                    String answerMatchDetail = mquestionDetail.getString("answer_match_detail");

                                                    if (titleType.equals("0")) { // ปรนัย
                                                        String msgFirst = questionDetail.substring(0, questionDetail.indexOf(">") + 1);
                                                        String msgLast = questionDetail.substring(questionDetail.indexOf(">") + 1);
                                                        out.print(msgFirst + "<input type=\"radio\" name=\"objective" + tmpLineObjective + "\">&nbsp;" + msgLast);
                                                    } else if (titleType.equals("1")) { // อัตนัย
                                                        tmpLineSubjective++;
                                                        out.print("<textarea id=\"subjective" + tmpLineSubjective + "\" name=\"subjective" + tmpLineSubjective + "\" cols=\"140\" rows=\"5\"></textarea>");
                                                    } else if (titleType.equals("2")) { // จับคู่
                                                        fieldQuestionDetail.put(lineMatch, questionDetail);
                                                        fieldAnswerMatchDetail.put(lineMatch, answerMatchDetail);
                                                        lineMatch++;

                                                    } else if (titleType.equals("3")) { // เรียงประโยค
                                                        fieldSortSentence.put(lineSortSentence, mquestionDetail.getString("result_sort_sentence"));
                                                        lineSortSentence++;

                                                    } else if (titleType.equals("4")) { // แบบสอบถาม
                                                        if (queryType.equals("0")) { // เลือกคำตอบได้ข้อเดียว
                                                            String msgFirst = questionDetail.substring(0, questionDetail.indexOf(">") + 1);
                                                            String msgLast = questionDetail.substring(questionDetail.indexOf(">") + 1);
                                                            out.print(msgFirst + "<input type=\"radio\" name=\"questionnaire_objective" + tmpLineQuestionnaire + "\">&nbsp;" + msgLast);
                                                        } else if (queryType.equals("1")) { // เลือกคำตอบได้หลายข้อ
                                                            String msgFirst = questionDetail.substring(0, questionDetail.indexOf(">") + 1);
                                                            String msgLast = questionDetail.substring(questionDetail.indexOf(">") + 1);
                                                            out.print(msgFirst + "<input type=\"checkbox\" name=\"questionnaire_objective_multi" + tmpLineQuestionnaireMulti + "\">&nbsp;" + msgLast);
                                                        } else if (queryType.equals("2")) { // ความคิดเห็น
                                                            out.print("<textarea id=\"questionnaire_subjective" + tmpLineQuestionnaireSubjective + "\" name=\"questionnaire_subjective" + tmpLineQuestionnaireSubjective + "\" cols=\"140\" rows=\"5\"></textarea>");
                                                            tmpLineQuestionnaireSubjective++;
                                                        }
                                                    }
                                                }
                                                if (titleType.equals("0")) { // ปรนัย
                                                    tmpLineObjective++;
                                                }

                                                if (titleType.equals("2")) { // จับคู่
                                                    Iterator<Integer> it = fieldQuestionDetail.keySet().iterator();
                                                    out.print("<table class=\"table-preview\" style=\"width: 100%;border-style: none;\">");
                                                    String option = "";
                                                    int size = fieldAnswerMatchDetail.size();
                                                    for (short j = 1; j <= size; j++ ) {
                                                        option += "<option value=\"" + j + "\">" + j + "</option>";
                                                    }
                                                    String tmpRandom = "";
                                                    int line = 1;
                                                    while (it.hasNext()) {
                                                        int key = it.next();
                                                        String value = fieldQuestionDetail.get(key);
                                                        int random = (int)(Math.random() * size + 1);
                                                        boolean statusFound = true;
                                                        while (statusFound) {
                                                            if (tmpRandom.indexOf("," + random + ",") == -1 || tmpRandom.equals("")) {
                                                                statusFound = false;
                                                                tmpRandom += "," + random + ",";
                                                                String msgQuestionFirst = value.substring(0, value.indexOf('>') + 1);
                                                                String msgQuestionLast = value.substring(value.indexOf('>') + 1);
                                                                String answerDetail = fieldAnswerMatchDetail.get(random);
                                                                String msgAnswerFirst = answerDetail.substring(0, answerDetail.indexOf('>') + 1);
                                                                String msgAnswerLast = answerDetail.substring(answerDetail.indexOf('>') + 1);
                                                                if (!value.equals("")) {
                                                                    tmpLineMatch++;
                                                                    StringBuilder data = new StringBuilder();
                                                                    data.append("<tr>");
                                                                        data.append("<td width=\"40%\">");
                                                                            data.append(msgQuestionFirst + "<select id=\"match" + tmpLineMatch + "\" name=\"match" + tmpLineMatch + "\">" + option + "</select>&nbsp;" + msgQuestionLast);
                                                                        data.append("</td>");
                                                                        data.append("<td width=\"3%\">");
                                                                            data.append(msgAnswerFirst + line + ".");
                                                                        data.append("</td>");
                                                                        data.append("<td>");
                                                                            data.append(msgAnswerLast);
                                                                        data.append("</td>");
                                                                    data.append("</tr>");
                                                                    out.print(data.toString()); 
                                                                } else {
                                                                    StringBuilder data = new StringBuilder();
                                                                    data.append("<tr>");
                                                                        data.append("<td width=\"40%\">");
                                                                            data.append("&nbsp;");
                                                                        data.append("</td>");
                                                                        data.append("<td width=\"3%\">");
                                                                            data.append(msgAnswerFirst + line + ".");
                                                                        data.append("</td>");
                                                                        data.append("<td>");
                                                                            data.append(msgAnswerLast);
                                                                        data.append("</td>");
                                                                    data.append("</tr>");
                                                                    out.print(data.toString());
                                                                }
                                                                line++;
                                                            } else {
                                                                random = (int)(Math.random() * size + 1);
                                                            }
                                                        }
                                                    }
                                                    out.print("</table>");
                                                }

                                                if (titleType.equals("3")) { // เรียงประโยค
                                                    out.print("<div id=\"result" + tmpLineSortSentence + "\" style=\"height: 25px;border-bottom: 1px solid #000000;\"></div><br>");
                                                    Iterator<Integer> it = fieldSortSentence.keySet().iterator();
                                                    int size = fieldSortSentence.size();
                                                    String tmpRandom = "";
                                                    String question = "";
                                                    while (it.hasNext()) {
                                                        int key = it.next();
                                                        String value = fieldSortSentence.get(key);
                                                        int random = (int)(Math.random() * size + 1);
                                                        boolean statusFound = true;
                                                        while (statusFound) {
                                                            if (tmpRandom.indexOf("," + random + ",") == -1 || tmpRandom.equals("")) {
                                                                statusFound = false;
                                                                tmpRandom += "," + random + ",";
                                                                question += "<span class=\"plus\">" + fieldSortSentence.get(random) + "</span>";
                                                            } else {
                                                                random = (int)(Math.random() * size + 1);
                                                            }
                                                        }
                                                    }
                                                    out.print("<div id=\"question" + tmpLineSortSentence + "\">" + question + "</div>");
                                                    tmpLineSortSentence++;
                                                }

                                                if (titleType.equals("4")) { // แบบสอบถาม
                                                    if (queryType.equals("0")) { // เลือกคำตอบได้ข้อเดียว
                                                        tmpLineQuestionnaire++;
                                                    } else if (queryType.equals("1")) { // เลือกคำตอบได้หลายข้อ
                                                        tmpLineQuestionnaireMulti++;
                                                    }
                                                }
                                            } catch (Exception e) {
                                              e.printStackTrace();
                                            }
                                        }
                                    } catch (Exception e) {
                                      e.printStackTrace();
                                    }
                                }
                            } catch (Exception e) {
                              e.printStackTrace();
                            }
                        }
                    } catch (Exception e) {
                        e.printStackTrace();
                    }
                }
            } catch (Exception e) {
                    e.printStackTrace();
            }
        }
    }
%>