指定月份显示每天的数据

实现功能截图
1.前台传参

2.
/*

 * createTime  前台传字符串
 * @param indexNoticeDto
 * @return
 */
@Override
public List<IndexNoticeDto> selectIndexNotice(IndexNoticeDto indexNoticeDto) throws ParseException {
    SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
    List<IndexNoticeDto> indexNoticeDtoList = new ArrayList<>();

    //不传月份日期表示当月，传日期表示之前月份
    String month = indexNoticeDto.getStrMonth();
    try {
        month = indexNoticeDto.getStrMonth();
    } catch (Exception e) {
        e.printStackTrace();
    }

    if (month == null) {
        indexNoticeDtoList.addAll(publicSqlMapper.selectIndexNotice(indexNoticeDto));
        List<IndexNoticeDto> dayList = getMonthEveryDays(indexNoticeDtoList, null);
        return dayList;
    } else {
        indexNoticeDto.setStrStartTime(month.substring(0, month.length() - 3) + "-01");
        indexNoticeDto.setDtStartTime(sdf.parse(indexNoticeDto.getStrStartTime()));
        int year = Integer.parseInt(month.substring(0, 4));
        int month1 = Integer.parseInt(month.substring(5, 7));

        int max = LocalDate.of(year, month1, 1).lengthOfMonth();
        //月份最大天数
        indexNoticeDto.setStrEndTime(month.substring(0, month.length() - 3) + "-" + String.valueOf(max));
        indexNoticeDto.setDtEndTime(sdf.parse(indexNoticeDto.getStrEndTime()));

        indexNoticeDto.setStrStartTime("'" + month.substring(0, month.length() - 3) + "-01" + "'");
        indexNoticeDto.setStrEndTime("'" + month.substring(0, month.length() - 3) + "-" + String.valueOf(max) + "'");
        List<IndexNoticeDto> indexNoticeDtoList1 = publicSqlMapper.selectIndexNoticeHis(indexNoticeDto);
        List<IndexNoticeDto> dayList = getMonthEveryDays(indexNoticeDtoList1, month.substring(0, month.length() - 3));
        return dayList;
    }
}

1. 上月月末+当月全月+下月月初数据
   /**

   • 上月月末+当月全月+下月月初数据
   • @param date

   • @return
     */
     public List getMonthEveryDays(List list, String month) throws ParseException {
     SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");

     int year = Integer.parseInt(month.substring(0, 4));
     int month1 = Integer.parseInt(month.substring(5, 7));
     //指定当前月份最大天数
     int max = LocalDate.of(year, month1, 1).lengthOfMonth();

     //当前月初开始日期属于周几
     int nowStartWeek = getWeekday(month + "-01");
     //当前月末结束日期属于周几
     int nowEndWeek = getWeekday(month + "-" + max);

     //上月年
     int lastYear = 0;
     //上月月份
     int lastMonth = Integer.parseInt(month.substring(5, 7)) - 1;
     String strLastMonth = "";
     if (lastMonth == 1) {

      lastMonth = 12;
      lastYear = Integer.parseInt(month.substring(0, 4)) - 1;
     

     } else {

      lastYear = year;
     

     }
     //上月最大天数
     int lastMonthMaxDay = LocalDate.of(lastYear, lastMonth, 1).lengthOfMonth();
     //拼接上月月末数据
     List lastIndexNoticeDtoList = new ArrayList<>();
     int sort = 0;
     //如果当前月份开始日期是周天，则不拼上月天数，我是根据前台的日期组件，一周开始属于周天拼接的
     if (nowStartWeek != 7) {

      for (int i = 0; i < nowStartWeek - 1; i++) {
          int lastDay = lastMonthMaxDay - i;
          IndexNoticeDto indexNoticeDto = new IndexNoticeDto();
          if (lastMonth < 10) {
              indexNoticeDto.setCreateTime(lastYear + "-" + "0" + lastMonth + "-" + lastDay);
          } else {
              indexNoticeDto.setCreateTime(lastYear + "-" + lastMonth + "-" + lastDay);
          }
          indexNoticeDto.setDtCreateTime(sdf.parse(lastYear + "-" + lastMonth + "-" + lastDay));
          if (nowStartWeek == 1) {
              indexNoticeDto.setWeek(7);
          } else {
              indexNoticeDto.setWeek(nowStartWeek - (1 + i));
          }
          indexNoticeDto.setDay(lastDay);
          indexNoticeDto.setTotal(0);//拼给前台的默认值，没有任何意义
          sort = i;
          indexNoticeDto.setSort(sort);
          lastIndexNoticeDtoList.add(indexNoticeDto);
      }
     

     }

     //本月数据
     List indexNoticeDtoList = new ArrayList<>();
     //上月数据
     List collect1 = lastIndexNoticeDtoList.stream().sorted(Comparator.comparing(IndexNoticeDto::getSort).reversed()).collect(Collectors.toList());
     indexNoticeDtoList.addAll(collect1);
     Calendar calendar = Calendar.getInstance();

     for (int i = 0; i < max; i++) {

      IndexNoticeDto indexNoticeDto = new IndexNoticeDto();
      if (month == null) {
          calendar.set(Calendar.DAY_OF_MONTH, i + 1);
      }
      String day = sdf.format(calendar.getTime());
      indexNoticeDto.setDay(i + 1);
      if (month != null) {
     
          int ii = i + 1;
          if (i < 9) {
              day = month + "-" + "0" + ii;
          } else {
              day = month + "-" + ii;
          }
      }
      indexNoticeDto.setCreateTime(day);
      indexNoticeDto.setDtCreateTime(sdf.parse(day));
      indexNoticeDto.setWeek(getWeekday(day));
      String finalDay = day;
      List<IndexNoticeDto> collect = list.stream().filter(s -> s.getCreateTime().equals(finalDay)).collect(Collectors.toList());
      if (collect.size() > 0) {
          indexNoticeDto.setTotal(collect.size());
      } else {
          indexNoticeDto.setTotal(0);
      }
      indexNoticeDto.setSort(sort + 1 + i);
     
      indexNoticeDtoList.add(indexNoticeDto);
     

     }

     //下个月数据
     int nextYear = 0;
     int nextMonth = 0;
     String strNextMonth = "";
     if (month1 == 12) {

      nextYear = year + 1;
      nextMonth = 1;
      strNextMonth = "0" + nextMonth;
     

     } else if (month1 != 12) {

      nextYear = year;
      nextMonth = month1 + 1;
      if (nextMonth < 1 && nextMonth < 10) {
          strNextMonth = "0" + nextMonth;
      } else {
          strNextMonth = String.valueOf(nextMonth);
      }
     

     }

     //日历组件方格 一共展示42天的数据
     int nextMonthDayNum = 42 - indexNoticeDtoList.size();
     for (int i = 0; i < nextMonthDayNum; i++) {

      String nextDay = "";
      if (i < 10) {
          nextDay = "0" + String.valueOf(i + 1);
      }
      IndexNoticeDto indexNoticeDto = new IndexNoticeDto();
      indexNoticeDto.setCreateTime(nextYear + "-" + strNextMonth + "-" + nextDay);
      indexNoticeDto.setDtCreateTime(sdf.parse(nextYear + "-" + strNextMonth + "-" + nextDay));
      indexNoticeDto.setDay(i + 1);
      indexNoticeDto.setWeek(getWeekday(nextYear + "-" + strNextMonth + "-" + nextDay));
      indexNoticeDto.setTotal(0);//拼给前台的默认值，没有任何意义
      sort = i;
      indexNoticeDto.setSort(sort);
      indexNoticeDtoList.add(indexNoticeDto);
     

     }

     return indexNoticeDtoList;
     }

4.制定月份每一天数据，与数据库中的数据进行比较，有数据的时候total的值 >0

5.计算指定日期星期几

/*

 * 实现给定某日期，判断是星期几
 * 必须yyyy-MM-dd
 * @param date
 * @return
 */
public static int getWeekday(String date) {
    SimpleDateFormat sd = new SimpleDateFormat("yyyy-MM-dd");
    SimpleDateFormat sdw = new SimpleDateFormat("E");
    Date d = null;
    try {
        d = sd.parse(date);
    } catch (ParseException e) {
        e.printStackTrace();
    }
    String strWeek = sdw.format(d); //输出 星期一。。。。。
    int intWeek = 0;
    switch (strWeek) {
        case "星期-":
            intWeek = 1;
            break;
        case "星期二":
            intWeek = 2;
            break;
        case "星期三":
            intWeek = 3;
            break;
        case "星期四":
            intWeek = 4;
            break;
        case "星期五":
            intWeek = 5;
            break;
        case "星期六":
            intWeek = 6;
            break;
        case "星期天":
            intWeek = 7;
            break;
        default:
            break;
    }
    return intWeek;
}

6.数据库查询

    SELECT
          total,
          day,
          CONCAT((date_format( ${strStartTime},'%yyy-')),(date_format( ${strStartTime},'%m-')), day) as create_time
    FROM
           (
             SELECT
                    DAY(create_time) as day,
                    count(notice_id) AS total
             FROM sys_notice
             WHERE create_time >= ${strStartTime} and create_time  <= ${strEndTime}
             GROUP BY DAY(create_time)
           ) as a
    WHERE a.day is not null

</select>

7.数据返回（一个日期组件一共展示42天的数据）