package com.servlet;


import java.io.IOException;
import java.util.ArrayList;

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

import net.sf.json.JSONArray;
import net.sf.json.JSONObject;

import com.bean.Shop;
import com.dao.Dao;

public class Servlet extends HttpServlet {

	@Override
	protected void service(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		request.setCharacterEncoding("UTF-8");
		response.setContentType("text/html;charset=utf-8");
		String flag = request.getParameter("flag");
		if(flag!=null&&flag.equals("show")) {
			show(request,response);
		}else if(flag!=null&&flag.equals("del")) {
			del(request,response);
		}else if(flag!=null&&flag.equals("toadd")) {
			toadd(request,response);
		}else if(flag!=null&&flag.equals("add")) {
			adds(request,response);
		}else if(flag!=null&&flag.equals("upd")) {
			upd(request,response);
		}else if(flag!=null&&flag.equals("xg")) {
			xg(request,response);
		}else if(flag!=null&&flag.equals("query")) {
			query(request,response);
		}
	}


	private void query(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException{
		// TODO Auto-generated method stub
		String id = request.getParameter("id");
		String name = request.getParameter("name");
		String content = request.getParameter("content");
		String start = request.getParameter("start");
		String end = request.getParameter("end");
		String bname = request.getParameter("bname");
		ArrayList<Shop> list = Dao.query(id, name, content, start, end, bname);
		request.setAttribute("list", list);
		int haha=0;
		request.setAttribute("haha",haha);
		request.getRequestDispatcher("view/List.jsp").forward(request,response);
	}


	private void adds(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException{
		String name = request.getParameter("name");
		String content = request.getParameter("content");
		String datea = request.getParameter("datea");
		String bid = request.getParameter("bid");
		int i = Dao.adds(name, content, datea, bid);
		if (i>0) {
			response.getWriter().print("y");
		}else {
			response.getWriter().print("n");
		}
	}
	private void xg(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException{
		String name = request.getParameter("name");
		String content = request.getParameter("content");
		String datea = request.getParameter("datea");
		String bid = request.getParameter("bid");
		String id = request.getParameter("id");
		int i = Dao.xg(name, content, datea, bid, id);
		if (i>0) {
			response.getWriter().print("y");
		}else {
			response.getWriter().print("n");
		}
	}
	private void toadd(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException{
		ArrayList<Shop> list = Dao.toAdd();
		JSONArray obj = JSONArray.fromObject(list);
		response.getWriter().print(obj);
	}

	private void del(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException{
			String id = request.getParameter("id");
			int i = Dao.del(id);
			if (i>0) {
				response.getWriter().print("y");
			}else {
				response.getWriter().print("n");
			}
	}

	private void show(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException{
		// TODO Auto-generated method stub
		String page = request.getParameter("page");
		//int page = Integer.parseInt(p);
		if (page==null) {
			page="1";
		}
		int currpage=Integer.parseInt(page);
		int prevpage=0;
		if (currpage==1) {
			prevpage=1;
		}else {
			prevpage=currpage-1;	
		}
		int pagesize=4;
		int count = Dao.getcount();
		int lastpage=count/pagesize;
		if (lastpage%pagesize!=0) {
			lastpage++;
		}
		int nextpage=0;
		if (currpage==lastpage) {
			nextpage=lastpage;
		}else {
			nextpage=currpage+1;
		}
		ArrayList<Shop> list = Dao.show(currpage,pagesize);
		request.setAttribute("prevpage", prevpage);
		request.setAttribute("nextpage", nextpage);
		request.setAttribute("lastpage", lastpage);
		request.setAttribute("list", list);
		request.getRequestDispatcher("view/List.jsp").forward(request,response);
	}
	
	private void upd(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException{
		String id=request.getParameter("id");
		Shop  s= Dao.upd(id);
		JSONObject obj = JSONObject.fromObject(s);
		response.getWriter().print(obj);
	}
}