package com.gc.biz;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.Iterator;
import java.util.List;

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

import com.gc.action.Category;
import com.gc.action.SmallCategory;
import com.gc.dao.DCategory;
import com.gc.dao.DFormat;
import com.gc.dao.DSmallCategory;

public class ManagerSelectCategoryServlet extends HttpServlet {

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		response.setContentType("text/html");
		DCategory dc = new DCategory();
		DFormat df = new DFormat();
		DSmallCategory ds = new DSmallCategory();
		List<Category> cate = dc.selectAllCategory();
		List<SmallCategory> smll = ds.selectAllSmallCategory();
		
		String category = request.getParameter("selbycid");
		String categoryname = request.getParameter("selbycname");
		
		String smallcate = request.getParameter("sel_byscid");
		String smallname = request.getParameter("sel_bysname");
		String smallcid = request.getParameter("sel_bycid");
		String smallcname = request.getParameter("sel_bycname");
		
		if(!"".equals(category) && category!=null)
		{
			int cid = Integer.parseInt(category);
			List<Category> list = dc.selectCategoryByCID(cid);
			request.setAttribute("selbycid", list);
			request.getRequestDispatcher("/ManagerSelectCategory.jsp?select=true").forward(request, response);
		}else if(!"".equals(categoryname) && categoryname!=null)
		{
			List<Category> list = dc.selectCategoryByCName(df.format(categoryname));
			request.setAttribute("selbycid", list);
			request.getRequestDispatcher("/ManagerSelectCategory.jsp?select=true").forward(request, response);
		}else if((!"".equals(smallcate) && smallcate!=null)||(!"".equals(smallname) && smallname!=null)
				||(!"".equals(smallcid) && smallcid!=null)||(!"".equals(smallcname) && smallcname!=null))
		{
			String sql="select * from SmallCategory where ";
			boolean isMultiple = false;
			if(!"".equals(smallcate.trim())){
				if(isMultiple == true){
					sql+=" and ";
				}
				if(isNumber(smallcate)){
					sql+="SCID="+Integer.parseInt(smallcate);
				}else{
					sql+="SCID=0";
				}
				isMultiple = true;
			}
			if(!"".equals(smallname.trim())){
				if(isMultiple == true){
					sql+=" and ";
				}
				sql+="SName='"+df.format(smallname)+"'";
				isMultiple = true;
			}
			if(!"".equals(smallcid.trim())){
				if(isMultiple == true){
					sql+=" and ";
				}
				if(isNumber(smallcid)){
					sql+="CID="+Integer.parseInt(smallcid);
				}else{
					sql+="SCID=0";
				}
				isMultiple = true;
			}
			if(!"".equals(smallcname.trim())){
				List<Category> li = dc.selectCategoryByCName(df.format(smallcname));
				Iterator<Category> it = li.iterator();
				if(isMultiple == true){
					sql+=" and ";
				}
				if(it.hasNext()){
					sql+="CID="+it.next().getCid();
					isMultiple = true;
				}else{
					sql+="CID=0";
				}
			}
			List<SmallCategory> list = ds.selectSmallCategoryBySql(sql);
			request.setAttribute("ca", cate);
			request.setAttribute("sel_smallcategory", list);
			request.getRequestDispatcher("/ManagerSelectCategory.jsp?select=true").forward(request, response);
		}else
		{
			request.setAttribute("ca", cate);
			request.setAttribute("sm", smll);
			request.getRequestDispatcher("/ManagerSelectCategory.jsp").forward(request, response);
		}
	}
	/**
	 * 判斷是否是數(shù)字
	 * @param str 
	 * @return
	 */
	private boolean isNumber(String str){
		char[]temp = str.toCharArray();
		boolean isDigit = false;
		for(char digit:temp){
			if(Character.isDigit(digit)){
				isDigit = true;
			}else{
				isDigit = false;
			}
		}
		return isDigit;
	}
}