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;
    }
}