package com.tool;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class QueryStrCreator {
//    private String queryStr;
    public static String create(String keyWork) {
        return null;
    }

    public static String create(String keyWork, HttpServletRequest request) {
        String reStr = "";
        if (keyWork.equals("compUser")) reStr = createCompUserStr(request);
        else if(keyWork.equals("clientTable")) reStr=createClientStr(request);
        else if(keyWork.equals("productTable")) reStr=createProductStr(request);
        else if(keyWork.equals("Shmanager"))reStr=createShmanager(request);
        else if(keyWork.equals("inputInformActive")) reStr="where INFORM_STATE=0 and DEL_FLAG=0";
        else if(keyWork.equals("inputInformCancle")) reStr="where INFORM_STATE=0 and DEL_FLAG=1";
        else if(keyWork.equals("inputApply")) reStr=createInputApplyStr(request);
        //else if(keyWork.equals("listAllInReg")) reStr="where register_state=0 and del_flag=0";
        else if(keyWork.equals("listAllInReg")) reStr="where inReg.register_state=0 and inReg.del_flag=0";
        else if(keyWork.equals("listCancledInReg")) reStr="where inReg.register_state=0 and inReg.del_flag=1";
        else if(keyWork.equals("listInputAuditActive")) reStr="where del_flag=0";
        else if(keyWork.equals("forInputShFormRev")) reStr="where inReg.In_Regi_Id in(select in_regi_id from input_sh_form where del_flag=1 and WARRANT_FLAG=0) and register_state=1";
        else if(keyWork.equals("selectForCreateStockWarrant")) reStr=createForStockWarrantStr(request);
        return reStr;
    }

    private static String createCompUserStr(HttpServletRequest request) {

        HttpSession session = request.getSession();

        String andOr = request.getParameter("andorButton");
        String realName = request.getParameter("realName");
        String department = request.getParameter("department");
        String compUserQueryStr = (String)session.getAttribute("compUserQueryStr");
        String currentPageStr = request.getParameter("currentPage");
        String reStr = "";
        if (realName != null) realName = realName.trim();
        if (department != null) department = department.trim();
        if (realName != null && realName.equals("")) realName = null;
        if (department != null && department.equals("")) department = null;

        if (andOr!=null) {//點擊查詢時
            if (realName == null && department != null) reStr =
                    "where department like'%" + department + "%'";
            else if (realName != null && department == null) reStr =
                    "where real_name  like'%" + realName + "%'";
            else if (realName != null && department != null) reStr =
                    "where real_name  like'%" + realName + "%'  " + andOr + "  " +
                    "department  like'%" + department + "%'";
            else   reStr="";
            session.setAttribute("compUserQueryStr",reStr);
        }else if(currentPageStr!=null){//點擊翻頁時
            //如果是查詢結果的分頁
            if(compUserQueryStr!=null) reStr=compUserQueryStr;
            //如果是默認打開的分面
            else reStr="";
        }
        return reStr;
    }
    private static String createClientStr(HttpServletRequest request){
         HttpSession session = request.getSession();
         String clientName=request.getParameter("clientName");
         String seatNum= request.getParameter("seatNum");
         String submit=request.getParameter("Submit");
         String clientQueryStr = (String)session.getAttribute("clientQueryStr");
         String currentPageStr = request.getParameter("currentPage");
         String reStr = "";
         if(clientName!=null)clientName=clientName.trim();
         if(seatNum!=null)seatNum = seatNum.trim();
         if(clientName!=null&&clientName.equals("")) clientName=null;
         if(seatNum!=null&&seatNum.equals("")) seatNum=null;

         if(submit!=null){
             if(clientName!=null&&seatNum!=null) reStr="where client_name like'%"+clientName+"%' or seat_num like'%"+seatNum+"%'";
             else if(clientName!=null && seatNum==null) reStr="where client_name like'%"+clientName+"%'";
             else if(clientName==null&&seatNum!=null)reStr="where seat_num like'%"+seatNum+"%'";
             session.setAttribute("clientQueryStr",reStr);
         }
         else if(currentPageStr!=null){
             if(clientQueryStr!=null)reStr=clientQueryStr;
             else reStr="";
         }
         return reStr;
    }
    private static String createProductStr(HttpServletRequest request){
        HttpSession session = request.getSession();
        String conditionType = request.getParameter("conditionType");
        String condition = request.getParameter("condition");
        String confirm = request.getParameter("confirm");
        String currentPage = request.getParameter("currentPage");
        String reStr="";

        //當點擊查詢時
        if(confirm!=null&&confirm.equals("查詢")){
            if (condition == null || condition.trim().equals("")) {
                return reStr;
            } else if (conditionType.equals("產品名稱")) {
                reStr = "where product_name like'%" + condition + "%'";
            } else if (conditionType.equals("產品型號")) {
                reStr = "where product_type like'%" + condition + "%'";
            } else if (conditionType.equals("產品品牌")) {
                reStr = "where pin_pai like'%" + condition + "%'";
            } else if (conditionType.equals("生產工藝")) {
                reStr = "where product_technics like'%" + condition + "%'";
            }
        }
        //當點擊下一頁時
        else if(currentPage!=null&&!currentPage.trim().equals("")){
            reStr = (String)session.getAttribute("productTableQueryStr");
        }
        else reStr="";
        session.setAttribute("productTableQueryStr",reStr);
        return reStr;
    }

    private static String createShmanager(HttpServletRequest request) {
        HttpSession session = request.getSession();
        String storehouse = request.getParameter("storehouse");
        String realName = request.getParameter("realName");
        String submit = request.getParameter("Submit");
        String currentPage = request.getParameter("currentPage");
//        System.out.print("realName="+realName);
//        System.out.print("storehouse="+storehouse);
//        System.out.print("submit="+submit);
//        System.out.print("currentPage="+currentPage);
        String reStr = "";
        //當點擊查詢時
        if (submit != null && submit.trim().equals("查詢")) {
            if((realName==null||realName.trim().equals(""))&&(storehouse==null||storehouse.trim().equals(""))){
                return reStr;
            }else if((realName!=null&&!realName.trim().equals(""))&&(storehouse==null||storehouse.trim().equals(""))){
                reStr=" where real_name like'%"+realName.trim()+"%'";
            }else if((storehouse!=null||!storehouse.trim().equals(""))&&(realName==null||realName.trim().equals(""))){
                reStr=" where sh_name like'%"+storehouse.trim()+"%'";
            }else if((storehouse!=null||!storehouse.trim().equals(""))&&(realName!=null&&!realName.trim().equals(""))){
                reStr=" where sh_name like'%"+storehouse.trim()+"%' or real_name like'%"+realName.trim()+"%'";
            }
        }
        //當點擊下一頁時
        else if (currentPage != null && !currentPage.trim().equals("")) {
            reStr = (String) session.getAttribute("shManagerQueryStr");
        }
        else reStr = "";
        session.setAttribute("shManagerQueryStr", reStr);
        return reStr;
    }

    private static String createInputApplyStr(HttpServletRequest request) {
        String reStr="";
        if(request.getParameter("fromInpuReg")!=null && request.getParameter("fromInpuReg").equals("fromInpuReg")){
            reStr="where in_ap_id in(select in_ap_id from input_inform where inform_state=0 and del_flag=0)";
        }else reStr="where DEL_FLAG=0 and apply_state=0";
        return reStr;
    }

    private static String createForStockWarrantStr(HttpServletRequest request) {
        String reStr = "";
        String clientName = request.getParameter("clientName").toString().trim();
        String seatNum = request.getParameter("seatNum").toString().trim();
        String modFlag = request.getParameter("modFlag").toString();
        if(modFlag.equals("j")){
            if(clientName.length()>0){
                reStr+="where Client_Name='"+clientName+"'";
                if(seatNum.length()>0)reStr+="and Seat_Num='"+seatNum+"'";
            }else{
                if(seatNum.length()>0) reStr+="where Seat_Num='"+seatNum+"'";
            }
        }else{
            if(clientName.length()>0){
                reStr+="where Client_Name like'%"+clientName+"%'";
                if(seatNum.length()>0)reStr+="and Seat_Num like'%"+seatNum+"%'";
            }else{
                if(seatNum.length()>0) reStr+="where Seat_Num like'%"+seatNum+"%'";
            }
        }
        return reStr;
    }
}