@Override
 public String getGroupTotalCount(int categoryId, String cityId) {
   Map<Object, Object> params = new HashMap<Object, Object>();
   String totalCount = "0";
   params.put("city_id", cityId);
   params.put("category_id", categoryId);
   totalCount = commonDao.selectObject("taopiao.getGroupTotalCount", params);
   return totalCount;
 }
  @Override
  public CommonInfo getCommonInfoDetail(int common_id) {
    Map<Object, Object> params = new HashMap<Object, Object>();
    params.put("id", common_id);
    // 获取演出基本信息
    CommonInfo commonInfo = commonDao.selectObject("commonInfo.getCommonInfoDetail", params);

    Category category = getShow_category(commonInfo);
    commonInfo.setCategory(category);
    // 获取演出时间
    Map<Object, Object> timeMap = this.getCommonInfoTimeMap();
    CommonInfo time = (CommonInfo) timeMap.get(common_id + "");
    String show_time = time.getShow_time();
    String limit_time = time.getLimit_time();
    if (show_time != null && !show_time.contains("全年")) {
      Calendar calendar = Calendar.getInstance();
      try {
        calendar.setTime(YYYY_MM_DD_HH_MM.parse(show_time));
        int year = calendar.get(Calendar.YEAR);
        int month = calendar.get(Calendar.MONTH) + 1;
        int day = calendar.get(Calendar.DAY_OF_MONTH);
        int hour = calendar.get(Calendar.HOUR_OF_DAY);
        int minute = calendar.get(Calendar.MINUTE);
        int week = calendar.get(Calendar.DAY_OF_WEEK);
        show_time = "";
        if (hour < 10) {
          show_time = show_time + "0" + hour + ":";
        } else {
          show_time = show_time + hour + ":";
        }
        if (minute < 10) {
          show_time = show_time + "0" + minute;
        } else {
          show_time = show_time + minute;
        }
        commonInfo.setYear(year + "");
        commonInfo.setDay(day + "");
        commonInfo.setMonth(month + "");
        commonInfo.setWeek(Const.week[week - 1]);
        commonInfo.setShow_time(show_time);
        commonInfo.setLimit_time(limit_time);
      } catch (ParseException e) {
        e.printStackTrace();
      }
    }
    Map<Object, CommonInfo> priceMap = this.getCommonInfoPriceMap();
    CommonInfo commonPrice = priceMap.get(common_id + "");
    if (commonPrice != null) {
      commonInfo.setPrice(commonPrice.getPrice());
      commonInfo.setDiscount(commonPrice.getDiscount());
      commonInfo.setMin_price(commonPrice.getMin_price());
      commonInfo.setMainURL(commonPrice.getMainURL());
    }
    commonInfo.setCategory(getShow_category(commonInfo));
    return commonInfo;
  }
 @Override
 public Map<Object, CommonInfo> getCommonInfoPriceMap() {
   Map<Object, CommonInfo> priceMap = new HashMap<Object, CommonInfo>();
   Map<Object, Object> params = new HashMap<Object, Object>();
   List<CommonInfo> result = null;
   result = GetByCache.loadByCache(cu, CacheKey.COMMON_PRICE_MAP);
   if (result == null) {
     result = commonDao.selectObjects("commonInfo.getCommonPriceList", params);
   }
   cu.putCache(CacheKey.COMMON_PRICE_MAP, result, DateTime.getPeriodOfvalidityTime());
   if (result != null) {
     for (CommonInfo commonInfo : result) {
       priceMap.put(commonInfo.getId() + "", commonInfo);
     }
   }
   return priceMap;
 }
 @Override
 public List<CommonInfo> getGroupList(
     int categoryId, String cityId, String pageIndex, String pageCount) {
   Map<Object, Object> params = new HashMap<Object, Object>();
   params = new HashMap<Object, Object>();
   params.put("category_id", categoryId);
   params.put("city_id", cityId);
   params.put("pageIndex", (Integer.parseInt(pageIndex) - 1) * Integer.parseInt(pageCount));
   params.put("pageCount", Integer.parseInt(pageCount));
   Map<Object, CommonInfo> priceMap = this.getCommonInfoPriceMap();
   List<CommonInfo> groupList = commonDao.selectObjects("taopiao.getGroupList", params);
   for (int i = 0; i < groupList.size(); i++) {
     CommonInfo price = priceMap.get(groupList.get(i).getId() + "");
     if (price != null) {
       groupList.get(i).setPrice(price.getPrice());
       groupList.get(i).setDiscount(price.getDiscount());
       groupList.get(i).setMin_price(price.getMin_price());
       groupList.get(i).setAgency_name(price.getAgency_name());
     }
   }
   return groupList;
 }
  @Override
  public List<CommonInfo> getCommonInfoList(
      int categoryId, String cityId, String pageIndex, String pageCount) {
    Map<Object, Object> params = new HashMap<Object, Object>();
    params = new HashMap<Object, Object>();
    params.put("category_id", categoryId);
    params.put("city_id", cityId);
    params.put("pageIndex", (Integer.parseInt(pageIndex) - 1) * Integer.parseInt(pageCount));
    params.put("pageCount", Integer.parseInt(pageCount));
    List<CommonInfo> commonList = commonDao.selectObjects("commonInfo.getCommonList", params);
    Map<Object, Object> timeMap = this.getCommonInfoTimeMap();
    Map<Object, CommonInfo> priceMap = this.getCommonInfoPriceMap();
    for (int i = 0, length = commonList.size(); i < length; i++) {
      CommonInfo commonInfo = commonList.get(i);

      String introduction = commonInfo.getIntroduction().replaceAll("\\s*", "");
      if (introduction != null && !"".equals(introduction)) {
        introduction = Jsoup.parse(introduction).text().trim();
        if (introduction.length() > 350) {
          introduction = introduction.substring(0, 350);
        }
        commonList.get(i).setIntroduction(introduction);
      }

      if (commonInfo.getStatus() == 0) {
        commonInfo.setShow_status("预售中");
      } else if (commonInfo.getStatus() == 2) {
        commonInfo.setShow_status("已过期");
      } else {
        commonInfo.setShow_status("热售中");
      }

      CommonInfo time = (CommonInfo) timeMap.get(commonInfo.getId() + "");
      if (time != null) {
        String show_time = time.getShow_time();
        String limit_time = time.getLimit_time();
        if (show_time != null && !"null".equals(show_time) && !show_time.contains("全年")) {
          Calendar calendar = Calendar.getInstance();
          try {
            calendar.setTime(YYYY_MM_DD_HH_MM.parse(show_time));
            int year = calendar.get(Calendar.YEAR);
            int month = calendar.get(Calendar.MONTH) + 1;
            int day = calendar.get(Calendar.DAY_OF_MONTH);
            int hour = calendar.get(Calendar.HOUR);
            int minute = calendar.get(Calendar.MINUTE);
            int week = calendar.get(Calendar.DAY_OF_WEEK);
            int AM_PM = calendar.get(Calendar.AM_PM);
            if (AM_PM == 0) {
              show_time = "早";
            } else {
              show_time = "晚";
            }
            if (hour < 10) {
              show_time = show_time + "0" + hour + ":";
            } else {
              show_time = show_time + hour + ":";
            }
            if (minute < 10) {
              show_time = show_time + "0" + minute;
            } else {
              show_time = show_time + minute;
            }
            commonList.get(i).setYear(year + "");
            commonList.get(i).setDay(day + "");
            if (month < 10) {
              commonList.get(i).setMonth("0" + month);
            } else {
              commonList.get(i).setMonth(month + "");
            }
            commonList.get(i).setWeek(Const.week[week - 1]);
            commonList.get(i).setShow_time(show_time);
            commonList.get(i).setLimit_time(limit_time);
          } catch (ParseException e) {
            e.printStackTrace();
          }
        } else {
          commonList.get(i).setShow_time(show_time);
          commonList.get(i).setLimit_time(limit_time);
        }
      }
      CommonInfo commonPrice = priceMap.get(commonInfo.getId() + "");
      if (commonPrice != null) {
        commonList.get(i).setPrice(commonPrice.getPrice());
        commonList.get(i).setDiscount(commonPrice.getDiscount());
        commonList.get(i).setMin_price(commonPrice.getMin_price());
      }
    }
    return commonList;
  }