queryadmin

package th.in.oneauthen.admin;

import java.io.IOException;


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

public class QueryAdmin extends HttpServlet {

    /**
     *
     */
    private static final long serialVersionUID = -2467938623988207708L;

    public static final String REQUEST_SELECT_QUERY = "select";

    public static final String REQUEST_QUERY_ROLE = "role";
    public static final String REQUEST_QUERY_DATE = "byDate";
    public static final String REQUEST_QUERY_TOTALMONTH = "byTotalMonth";
    public static final String REQUEST_QUERY_BETWEEN = "byBetween";

    public static final String REQUEST_QUERY_ROLE_TYPE = "admin";
    public static final String REQUEST_QUERY_ROLE_LIMIT = "100";

    public static final String REQUEST_QUERY_TOTALMONTH_MONTH = "9";
    public static final String REQUEST_QUERY_TOTALMONTH_YEAR = "2561";
    public static final String REQUEST_QUERY_TOTALMONTH_USER_ID = "8";

    public static final String REQUEST_QUERY_DATE_DATE = "2561-09-20";
    public static final String REQUEST_QUERY_DATE_USER_ID = "8";


    public static final String REQUEST_QUERY_BETWEEN_DATE_FRIST = "2561-09-20";
    public static final String REQUEST_QUERY_BETWEEN_DATE_END = "2561-09-30";
    public static final String REQUEST_QUERY_BETWEEN_USER_ID = "8";

    private static String selectQuery = "";

     public static final String DASHBOARD_BETWEEN = "dashboard.jsp?reqp=QueryBetween";
     public static final String DASHBOARD_MONTH = "dashboard.jsp?reqp=QueryMonth";
     public static final String DASHBOARD_DATE = "dashboard.jsp?reqp=QueryDate";
     public static final String DASHBOARD_TYPE = "dashboard.jsp?reqp=QueryType";

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException {

        selectQuery = request.getParameter(REQUEST_SELECT_QUERY);
        //////////////////// Query role////////////////////////////
        String type = request.getParameter(REQUEST_QUERY_ROLE_TYPE);
        String limitStr = request.getParameter(REQUEST_QUERY_ROLE_LIMIT);

        //////////////////// Query by date////////////////////////////
        String date = request.getParameter(REQUEST_QUERY_DATE_DATE);
        String userIdStr = request.getParameter(REQUEST_QUERY_DATE_USER_ID);

        //////////////////// Query by total month////////////////////////////
        String monthStr = request.getParameter(REQUEST_QUERY_TOTALMONTH_MONTH);
        String yearStr = request.getParameter(REQUEST_QUERY_TOTALMONTH_YEAR);
        String userIdOfTotalMonthStr = request.getParameter(REQUEST_QUERY_TOTALMONTH_USER_ID);

        //////////////////// Query by between////////////////////////////
        String dateFrist = request.getParameter(REQUEST_QUERY_BETWEEN_DATE_FRIST);
        String dateEnd = request.getParameter(REQUEST_QUERY_BETWEEN_DATE_END);
        String userIdOfBetweenStr = request.getParameter(REQUEST_QUERY_TOTALMONTH_USER_ID);


        switch (selectQuery) {
        case REQUEST_QUERY_ROLE:
            // เก็บค่าเข้า session เเล้ว เปลี่ยนหน้า
            request.getSession().setAttribute(REQUEST_QUERY_ROLE_TYPE, type);
            request.getSession().setAttribute(REQUEST_QUERY_ROLE_LIMIT, limitStr);
            try {
                request.getRequestDispatcher(DASHBOARD_TYPE).forward(request, response);
            } catch (IOException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }

            break;
        case REQUEST_QUERY_TOTALMONTH :

            request.getSession().setAttribute(REQUEST_QUERY_TOTALMONTH_MONTH, monthStr);
            request.getSession().setAttribute(REQUEST_QUERY_TOTALMONTH_YEAR, yearStr);
            request.getSession().setAttribute(REQUEST_QUERY_TOTALMONTH_USER_ID, userIdOfTotalMonthStr);
            try {
                request.getRequestDispatcher(DASHBOARD_MONTH).forward(request, response);
            } catch (IOException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }

            break;

        case REQUEST_QUERY_DATE:

            request.getSession().setAttribute(REQUEST_QUERY_DATE_DATE, date);
            request.getSession().setAttribute(REQUEST_QUERY_DATE_USER_ID, userIdStr);
            try {
                request.getRequestDispatcher(DASHBOARD_DATE).forward(request, response);
            } catch (IOException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }

            break;
        case REQUEST_QUERY_BETWEEN:

            request.getSession().setAttribute(REQUEST_QUERY_BETWEEN_DATE_FRIST, dateFrist);
            request.getSession().setAttribute(REQUEST_QUERY_BETWEEN_DATE_END, dateEnd);
            request.getSession().setAttribute(REQUEST_QUERY_TOTALMONTH_USER_ID, userIdOfBetweenStr);
            try {
                request.getRequestDispatcher(DASHBOARD_BETWEEN).forward(request, response);
            } catch (IOException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }

            break;
        }

    }

}