指定月份显示每天的数据-阿里云开发者社区

实现功能截图
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;
    }
}

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

上月月末+当月全月+下月月初数据
@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 &gt;= ${strStartTime} and create_time  &lt;= ${strEndTime}
             GROUP BY DAY(create_time)
           ) as a
    WHERE a.day is not null

</select>

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

指定月份显示每天的数据

热门文章

最新文章

相关电子书