fine_record_execute
LogDB 表结构 - FineReport帮助文档 - 全面的报表使用教程和学习资料 (fanruan.com)

select username,count(type) from fine_record_execute
where todate(time)>='${start} 00:00:00'/*时间*/
and todate(time)<='${end} 23:59:59'
${if(len(czyh)=0,"","and username in('"+czyh+"')")}/*人员账号*/
and type>7
and type <= 27
GROUP BY username
order by username desc
/*这个是打印的*/
and type >=30
and type <=34
/*这个是查看的*/
and type<=3