import com.weimob.models.Pagination;

import com.weimob.models.QueryResult;

import com.weimob.models.UvData;

import com.weimob.uv.dao.WeiMobUvDao;

import org.json.JSONArray;

import org.json.JSONObject;

import javax.servlet.RequestDispatcher;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import java.io.IOException;

import java.util.ArrayList;

import java.util.List;

import java.util.Map;

@WebServlet(name="UVServlet",

        urlPatterns={"/WebApp/UVServlet"},

        loadOnStartup=0)

public class UVServlet extends HttpServlet {

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

        doGet(request, response);

    }

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

        String memthodname = request.getParameter("memthodname");

        if(memthodname!=null){

            switch (memthodname){

                case "queryList":

                    break;

                case "deleteuv":

                    deleteUv(request,response);

                    break;

                case "edituv":

                    edituv(request,response);

                    break;

                default:

                    queryList(request, response);

            }

        }else {

            queryList(request, response);

        }

    }

    private void queryList(javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response) throws javax.servlet.ServletException, IOException {

        String str = request.getParameter("keyword");

        String pindex = request.getParameter("page");

        String limit = request.getParameter("limit");

        response.setStatus(200);

        int aid = 0;

        int pagesize=15;

        int index = 0;

        int total = 0;

        if (str != null && str.length() > 0) {

            aid = Integer.valueOf(str);

        }

        if (pindex != null) {

            index = Integer.parseInt(pindex);

            pagesize=Integer.parseInt(limit);

        }

        WeiMobUvDao dao = new WeiMobUvDao();

        StringBuffer sbtotal = new StringBuffer();

        sbtotal.append("SELECT count(1) as count FROM WpMulShopDataUv_1 ");

        if (aid > 0) {

            sbtotal.append(" where aid=");

            sbtotal.append(aid);

        }

        total = dao.GetCount(sbtotal.toString());

        if (total > 0) {

            StringBuffer sb = new StringBuffer();

            sb.append("SELECT Id,AId,Uv,DataType,Date FROM WpMulShopDataUv_1 ");

            if (aid > 0) {

                sb.append(" where aid=");

                sb.append(aid);

            }

            if (total > pagesize) {

                sb.append(" Limit ");

                int start = (index - 1) * pagesize;

                if (start < 0) {

                    start = 0;

                }

                sb.append(start);

                sb.append(",");

                sb.append(pagesize);

            }

            List<UvData> list = dao.QueryUv(sb.toString());

            QueryResult<UvData> result = new QueryResult<UvData>(total, list);

            String jsonstr= ConvertListToPageJson(list,total);

            System.out.println(jsonstr);

           request.setAttribute("result", jsonstr);

            response.getWriter().print(jsonstr);

        }else {

            QueryResult<UvData> result = new QueryResult<UvData>(total, null);

            JSONObject obj = new JSONObject(result);

            response.getWriter().print(obj);

        }

}

    private void deleteUv(javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response) throws javax.servlet.ServletException, IOException {

        String str = request.getParameter("aid");

        String uvid = request.getParameter("uvid");

        String limit = request.getParameter("limit");

        response.setStatus(200);

        int aid = 0;

        int uv_id=0;

        int index = 0;

        int total = 0;

        if (str != null && str.length() > 0) {

            aid = Integer.valueOf(str);

        }

        if (uvid != null) {

            uv_id = Integer.parseInt(uvid);

        }

       if(uv_id<=0){

           response.getWriter().print("参数无效");

       }

        WeiMobUvDao dao = new WeiMobUvDao();

        List list=new ArrayList<Integer>();

        list.add(uv_id);

        int res_count= dao.DeleteByIds(aid,list);

        JSONObject jsonObject = new JSONObject();

        jsonObject.put("state",res_count>0?true:false);

        jsonObject.put("code",0);

        jsonObject.put("msg","null");

        response.getWriter().print(jsonObject);

    }

    private void edituv(javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response) throws javax.servlet.ServletException, IOException {

        String str = request.getParameter("aid");

        String uvid = request.getParameter("uvid");

        String uvstr = request.getParameter("uv");

        response.setStatus(200);

        JSONObject jsonObject = new JSONObject();

        int aid = 0;

        int uv_id=0;

        int uv = 0;

        if (str != null && str.length() > 0) {

            aid = Integer.valueOf(str);

        }

        if (uvid != null) {

            uv_id = Integer.parseInt(uvid);

            uv= Integer.parseInt(uvstr);

        }

        if(uv_id<=0){

            response.setStatus(500);

            jsonObject.put("state",-1);

            jsonObject.put("msg","参数无效");

            response.getWriter().print(jsonObject);

        }

        if(uv<0){

            response.setStatus(500);

            jsonObject.put("state",-1);

            jsonObject.put("msg","参数无效");

            response.getWriter().print(jsonObject);

        }

        WeiMobUvDao dao = new WeiMobUvDao();

        List list=new ArrayList<Integer>();

        list.add(uv_id);

        UvData res= dao.getByIds(aid,uv_id);

        if(res==null){

            response.setStatus(500);

            jsonObject.put("state",-1);

            jsonObject.put("msg","参数无效,对象不存在");

            response.getWriter().print(jsonObject);

            return;

        }

         int res_count= dao.modifyEntity(res);

        jsonObject.put("state",res_count>0?true:false);

        jsonObject.put("code",0);

        jsonObject.put("msg","null");

        response.getWriter().print(jsonObject);

    }

    public  String ConvertListToPageJson(List<?> list, int countList) {

        // 新建一个json数组

        JSONArray jsonArray = new JSONArray();

        // 新建一个json对象

        JSONObject jsonObject = null;

        // 遍历泛型集合

        for (Object object : list) {

            jsonObject = new JSONObject(object);

            jsonArray.put(jsonObject);

        }

        // 转换数据格式

        String json = jsonArray.toString();

        // 拼接字符串

        StringBuffer sb = new StringBuffer();

        sb.append("{\"count\":");

        sb.append(countList);

        sb.append(",\"code\":");

        sb.append(0);

        sb.append(",\"msg\":");

        sb.append("null");

        sb.append(",\"data\":");

        sb.append(json);

        sb.append("}");

        String jsonString = sb.toString();

        return jsonString;

    }

}