package com.itbaizhan.action;

import java.io.IOException;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import com.itbaizhan.dao.DB;
import com.itbaizhan.orm.Tuser;
import com.itbaizhan.service.liuService;

public class user_servlet extends HttpServlet
{
    public void service(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException 
    {
        String type = req.getParameter("type");

        if(type.endsWith("userReg"))
        {
            userReg(req, res);
        }
        if(type.endsWith("userLogout"))
        {
            userLogout(req, res);
        }
        if(type.endsWith("userMana"))
        {
            userMana(req, res);
        }
        if(type.endsWith("userDel"))
        {
            userDel(req, res);
        }
        
        if(type.endsWith("userDetail"))
        {
            userDetail(req, res);
        }
    }

    public void userReg(HttpServletRequest req, HttpServletResponse res)
    {
        String id = String.valueOf(new Date().getTime());
        String loginname = req.getParameter("loginname");
        String loginpw = req.getParameter("loginpw");
        String name = req.getParameter("name");
        String del = "no";
        
        String s = liuService.panduan_zhanghao(loginname);
        if(s.equals("yizhan"))
        {
            req.setAttribute("message", "账号已占用，请重新选择账号");
            req.setAttribute("path", "site/userreg/userreg.jsp");
            String targetURL = "/common/success.jsp";
            dispatch(targetURL, req, res);
        }
        else
        {
            String sql = "insert into t_user values(?,?,?,?,?)";
            Object[] params = {id, loginname, loginpw, name, del};
            DB mydb = new DB();
            mydb.doPstm(sql, params);
            mydb.closed();
            
            req.setAttribute("message", "注册成功，请登录");
            req.setAttribute("path", "site/default.jsp");
            String targetURL = "/common/success.jsp";
            dispatch(targetURL, req, res);
        }
    }

    public void userLogout(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException
    {
        HttpSession session = req.getSession();
        session.setAttribute("userType", null);
        session.setAttribute("user", null);
        
        req.setAttribute("message", "成功退出系统");
        req.setAttribute("path", "site/default.jsp");
        String targetURL = "/common/success.jsp";
        dispatch(targetURL, req, res);
    }

    public void userMana(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException
    {
        List userList = new ArrayList();
        String sql = "select * from t_user where del='no'";
        Object[] params = {};
        DB mydb = new DB();
        try
        {
            mydb.doPstm(sql, params);
            ResultSet rs = mydb.getRs();
            while(rs.next())
            {
                Tuser user = new Tuser();
                user.setId(rs.getString("id"));
                user.setLoginname(rs.getString("loginname"));
                user.setLoginpw(rs.getString("loginpw"));
                user.setLoginpw(rs.getString("loginpw"));
                user.setName(rs.getString("name"));
                userList.add(user);
            }
            rs.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        mydb.closed();
        
        req.setAttribute("userList", userList);
        req.getRequestDispatcher("admin/user/userMana.jsp").forward(req, res);
    }

    public void userDel(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException
    {
        String id = req.getParameter("id");
        String sql = "update t_user set del='yes' where id=?";
        Object[] params = {id};
        DB mydb = new DB();
        mydb.doPstm(sql, params);
        mydb.closed();
        
        req.setAttribute("msg", "用户信息删除成功");
        String targetURL = "/common/msg.jsp";
        dispatch(targetURL, req, res);
    }

    public void userDetail(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException
    {
        String id = req.getParameter("id");
        
        List userList = new ArrayList();
        String sql = "select * from t_user where id=?";
        Object[] params = {id};
        DB mydb = new DB();
        try
        {
            mydb.doPstm(sql, params);
            ResultSet rs = mydb.getRs();
            while(rs.next())
            {
                Tuser user = new Tuser();
                user.setId(rs.getString("id"));
                user.setLoginname(rs.getString("loginname"));
                user.setLoginpw(rs.getString("loginpw"));
                user.setLoginpw(rs.getString("loginpw"));
                user.setName(rs.getString("name"));
                userList.add(user);
            }
            rs.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        mydb.closed();
        
        req.setAttribute("userList", userList);
        req.setAttribute("xinyongList", liuService.getxinyongList(id));
        req.getRequestDispatcher("admin/user/userDetail.jsp").forward(req, res);
    }

    public void dispatch(String targetURI, HttpServletRequest request, HttpServletResponse response) 
    {
        RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
        try 
        {
            dispatch.forward(request, response);
        } 
        catch (ServletException e) 
        {
            e.printStackTrace();
        } 
        catch (IOException e) 
        {
            e.printStackTrace();
        }
    }

    public void init(ServletConfig config) throws ServletException 
    {
        super.init(config);
    }

    public void destroy() 
    {
    }
}