blob: 0d809c1fe9014148509423032410baf9cbcd2a71 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
#
# This query properly handles calls that span from the
# previous reset period into the current period but
# involves more work for the SQL server than those
# below
#
query = "\
SELECT SUM(AcctSessionTime - GREATEST((%%b - EXTRACT(epoch FROM AcctStartTime)), 0)) \
FROM radacct \
WHERE UserName='%{${key}}' \
AND EXTRACT(epoch FROM AcctStartTime) + AcctSessionTime > '%%b'"
|
