Cvlogs

gistfile1.sql

'cvlog-query' =>
            "SELECT IFNULL(Division.name,'Unknown Division') AS did,
             IFNULL(User.name,'Unknown User') AS uid, division_id, user_id,
             count(*) as today, null as twoweeks, null as archive
             FROM cvlogs as Cvlog
             LEFT JOIN divisions AS Division ON (Cvlog.division_id = Division.id)
             LEFT JOIN users AS User ON (Cvlog.user_id = User.id)
             WHERE DATE(Cvlog.date) = CURDATE()
             GROUP BY division_id, user_id",
            'cvlog-archive-query' =>
            "SELECT IFNULL(Division.name,'Unknown Division') AS did,
             IFNULL(User.name,'Unknown User') AS uid, division_id, user_id,
             null as today,count(*) as twoweeks,null as archive
             from cvlogs as Cvlog
             LEFT JOIN divisions AS Division ON (Cvlog.division_id = Division.id)
             LEFT JOIN users AS User ON (Cvlog.user_id = User.id)
             WHERE DATEDIFF(CURDATE(), DATE(Cvlog.date)) < 14
             GROUP BY division_id, user_id
             UNION
             SELECT IFNULL(Division.name,'Unknown Division') AS did,
             IFNULL(User.name,'Unknown User') AS uid, division_id, user_id,
             null as today,null as twoweeks,count(*) as archive
             from cvlogs as Cvlog
             LEFT JOIN divisions AS Division ON (Cvlog.division_id = Division.id)
             LEFT JOIN users AS User ON (Cvlog.user_id = User.id)
             GROUP BY division_id, user_id
             ORDER BY did, uid",