Perintah untuk cek jumlah record inputan hari ini

 SELECT 'Jurnal Mengajar' AS jenis, COUNT(*) AS jumlah

FROM mdl_local_jurnalmengajar

WHERE DATE(FROM_UNIXTIME(timecreated)) = CURDATE()

UNION ALL

SELECT 'Pembinaan Mapel', COUNT(*)

FROM mdl_local_jurnalmengajar_pembinaanmapel

WHERE DATE(FROM_UNIXTIME(timecreated)) = CURDATE()

UNION ALL

SELECT 'Pembinaan BK', COUNT(*)

FROM mdl_local_jurnalpembinaan

WHERE DATE(FROM_UNIXTIME(timecreated)) = CURDATE()

UNION ALL

SELECT 'Layanan BK', COUNT(*)

FROM mdl_local_jurnallayananbk

WHERE DATE(FROM_UNIXTIME(timecreated)) = CURDATE()

UNION ALL

SELECT 'Guru Wali', COUNT(*)

FROM mdl_local_jurnalmengajar_guruwali

WHERE DATE(FROM_UNIXTIME(timecreated)) = CURDATE()

UNION ALL

SELECT 'Surat Izin Murid', COUNT(*)

FROM mdl_local_jurnalmengajar_suratizin

WHERE DATE(FROM_UNIXTIME(timecreated)) = CURDATE()

UNION ALL

SELECT 'Kehadiran Guru', COUNT(*)

FROM mdl_local_jurnalmengajar_kehadiran

WHERE DATE(FROM_UNIXTIME(timecreated)) = CURDATE()

UNION ALL

SELECT 'TOTAL', SUM(jumlah)

FROM (

    SELECT COUNT(*) AS jumlah

    FROM mdl_local_jurnalmengajar

    WHERE DATE(FROM_UNIXTIME(timecreated)) = CURDATE()

    UNION ALL

    SELECT COUNT(*)

    FROM mdl_local_jurnalmengajar_pembinaanmapel

    WHERE DATE(FROM_UNIXTIME(timecreated)) = CURDATE()

    UNION ALL

    SELECT COUNT(*)

    FROM mdl_local_jurnalpembinaan

    WHERE DATE(FROM_UNIXTIME(timecreated)) = CURDATE()

    UNION ALL

    SELECT COUNT(*)

    FROM mdl_local_jurnallayananbk

    WHERE DATE(FROM_UNIXTIME(timecreated)) = CURDATE()

    UNION ALL

    SELECT COUNT(*)

    FROM mdl_local_jurnalmengajar_guruwali

    WHERE DATE(FROM_UNIXTIME(timecreated)) = CURDATE()

    UNION ALL

    SELECT COUNT(*)

    FROM mdl_local_jurnalmengajar_suratizin

    WHERE DATE(FROM_UNIXTIME(timecreated)) = CURDATE()

    UNION ALL

    SELECT COUNT(*)

    FROM mdl_local_jurnalmengajar_kehadiran

    WHERE DATE(FROM_UNIXTIME(timecreated)) = CURDATE()

) x;