| ${if(type=="日报"," and date(o.create_time)='"+ date +"'", if(type=="月报"," and date_format(o.create_time,'%m')='"+ month+"'"+" and date_format(o.create_time,'%Y')='"+ year+"'"," and date_format(o.create_time,'%Y')='"+ year+"'"))} 日报月报年报 实现了，文档的周报和日报月报年报不是一个系统的额，哪位大神能不能给个比较好的加上周报功能的方法 原来文档周报是通过这样的过滤实现的，o.create_time大于等于 DATEDELTA($week, if(tointeger(WEEKDAY($date1)) == 0, -7, 0 - WEEKDAY($week))) 并且o.create_time小于 ATEDELTA($week, if(tointeger(WEEKDAY($week)) == 0, 1, 6 - WEEKDAY($week)))，有没有好一想到办法呢  |
最佳回答 |
||||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
