mysql 同一周,同一月
/**
* 星期一作为一周开始 ; 和现在是同一个周
*
* @param id
* @return
*/
@Query(value = "SELECT * FROM tbl_record WHERE YEARWEEK(date_format(create_time,'%Y-%m-%d'),1) = YEARWEEK(now(),1)" +
"and delete_flag=0 and equipment_id=?", nativeQuery = true)
List<TblRecordEntity> findfordevops(int id);
// 同一个月
@Query(value = "SELECT * FROM tbl_record WHERE DATE_FORMAT( create_time, '%Y%m' ) = DATE_FORMAT( CURDATE( ) , '%Y%m' )" +
" and delete_flag=0 and user_id=?", nativeQuery = true)
List<TblRecordEntity> findbymonth(int id);
// 日期的 起止 一周之前到现在
value2: [this.getDay(new Date(),-6),this.getDay(new Date(),0)],
getDay(date,day){
var today = new Date(date);
var targetday_milliseconds=today.getTime() + 1000*60*60*24*day;
today.setTime(targetday_milliseconds); //注意,这行是关键代码
var tYear = today.getFullYear();
var tMonth = today.getMonth();
var tDate = today.getDate();
tMonth = this.doHandleMonth(tMonth + 1);
tDate =this. doHandleMonth(tDate);
return tYear+"-"+tMonth+"-"+tDate;
}