示例#1
0
文件: Page.java 项目: jaseeka/baseSSM
  public PageBounds gainPageBounds() {
    if (this.no == null || this.no <= 0) setNo(1);
    if (this.size == null || this.size <= 0) setSize(Integer.MAX_VALUE - 1);

    if (StringUtils.isEmpty(this.sort)) {
      return new PageBounds(this.no, this.size);
    } else {
      return new PageBounds(this.no, this.size, Order.create(getSort(), getOrder()));
    }
  }
  /**
   * 查询单技能
   *
   * @param req
   * @param response
   * @param dataParm
   */
  @RequestMapping("abli/searchAblityById")
  public void searchTaskById(
      HttpServletRequest req, HttpServletResponse response, @RequestParam String dataParm) {
    if (logger.isDebugEnabled()) {
      logger.debug("UserAblityController---searchAblityById---begin");
    }

    try {
      super.getParm(req, response);

      if (!UserAgentUtils.isMobileOrTablet(req)) {
        super.writeJson(response, "9997", "无效设备", null, null);
      } else {
        Map paramMap = data.getDataset();

        Object page = paramMap.get("page"), // PAGE NUMBER
            pageSize = paramMap.get("pageSize"), // MAX ROWS RETURN
            sort = paramMap.get("sort"); // SORT INFO

        String sortString = sort == null ? "COMMENT_TIME.desc" : sort.toString(); // 评论排序
        int pageInt = Integer.parseInt(page.toString());
        int pageSizeInt = Integer.parseInt(pageSize.toString());

        Map resMap = new HashMap();
        List resList = null;

        // 分页查询,仅仅在第一页中加入技能数据,满足的记录数totalCount, 以及第一页的技能留言
        if (pageInt == 1) {
          resMap = userAblityService.searchAblityById(paramMap);
        }

        PageBounds pageBounds = new PageBounds(pageInt, pageSizeInt, Order.formString(sortString));

        resList =
            PubTool.getResultList(
                "UserAblityDAO.getAbliComments", paramMap, pageBounds, sqlSessionFactory);

        // 仅在第一页加入评论
        int totalCount = 0;
        if (PubTool.isListHasData(resList) && pageInt == 1) {
          totalCount = ((PageList) resList).getPaginator().getTotalCount();
        }
        resMap.put("totalCount", totalCount);

        super.writeJson(response, Code.SUCCESS, Code.SUCCESS_MSG, resMap, resList);
      }
    } catch (Exception e) {
      super.writeJson(response, "9992", "后台程序执行失败", null, null);
      logger.error("UserAblityController---searchAblityById---interface error: ", e);
    }
  }
  /**
   * 查询技能列表 1.查询用户发布的技能列表 -OPTIMAL 2.查询所有的技能列表 -DEFAULT 3.根据距离查询 LONGITUDE LATITUDE -REQUIRED
   *
   * @param req
   * @param response
   * @param dataParm
   */
  @RequestMapping("abli/searchAblityList")
  public void searchAblityList(
      HttpServletRequest req, HttpServletResponse response, @RequestParam String dataParm) {
    if (logger.isDebugEnabled()) {
      logger.debug("UserAblityController---searchAblityList---begin");
    }

    try {
      super.getParm(req, response);

      Map paramMap = data.getDataset();

      if (!UserAgentUtils.isMobileOrTablet(req)) {
        super.writeJson(response, "9997", "无效设备", null, null);
      } else {
        // DIST.desc,ABLI_BUY_COUNT.desc,ABLI_COMMMENT.desc,ABLI_POINT.desc,ABLI_LAST_UPDATE.desc
        String sortString = paramMap.get("sort").toString();
        int pageInt = Integer.parseInt(paramMap.get("page").toString()); // PAGE NUMBER
        int pageSizeInt = Integer.parseInt(paramMap.get("pageSize").toString()); // MAX ROWS RETURN

        PageBounds pageBounds = new PageBounds(pageInt, pageSizeInt, Order.formString(sortString));

        List resList =
            PubTool.getResultList(
                "UserAblityDAO.searchAblityList", paramMap, pageBounds, sqlSessionFactory);

        Map resMap = new HashMap();
        int totalCount = 0;
        if (PubTool.isListHasData(resList)) {
          totalCount = ((PageList) resList).getPaginator().getTotalCount();
          PubTool.reCalculateDistance(resList, paramMap, "ABLI_LONGITUDE", "ABLI_LATITUDE");
        }
        resMap.put("totalCount", totalCount);

        super.writeJson(response, Code.SUCCESS, Code.SUCCESS_MSG, resMap, resList);
      }
    } catch (Exception e) {
      super.writeJson(response, "9992", "后台程序执行失败", null, null);
      logger.error("UserAblityController---searchAblityList---interface error: ", e);
    }
  }