date_default_timezone_set('Asia/Jakarta'); include '../config/config.php'; function kirimWA($no, $pesan){ $token = "FcykjZvSbJsiArgKYCh4"; $curl = curl_init(); curl_setopt_array($curl, array( CURLOPT_URL => "https://api.fonnte.com/send", CURLOPT_RETURNTRANSFER => true, CURLOPT_POST => true, CURLOPT_POSTFIELDS => array( 'target' => $no, 'message' => $pesan, ), CURLOPT_HTTPHEADER => array( "Authorization: $token" ), )); $response = curl_exec($curl); curl_close($curl); return $response; } $today = date('Y-m-d'); $tanggal = date('Y-m-d'); $pesan = ""; if(isset($_POST['barcode'])){ $barcode = trim($_POST['barcode']); $jam = date('H:i:s'); $siswa = $koneksi->query("
SELECT s.*, k.nama_kelas
FROM siswa s
LEFT JOIN kelas k ON s.id_kelas = k.id_kelas
WHERE TRIM(s.barcode)='$barcode'
"); $pegawai = $koneksi->query("
SELECT * FROM pegawai
WHERE TRIM(barcode)='$barcode'
"); if($siswa->num_rows > 0){ $s = $siswa->fetch_assoc(); $id = $s['id_siswa']; $cek = $koneksi->query("
SELECT * FROM absensi
WHERE id_siswa='$id'
AND DATE(tanggal)=CURDATE()
LIMIT 1
"); if($cek->num_rows == 0){ echo ""; } else { $data = $cek->fetch_assoc(); if(!empty($data['jam_pulang'])){ echo ""; } else { $koneksi->query("
UPDATE absensi
SET jam_pulang='$jam'
WHERE id='".$data['id']."'
"); $nama = $s['nama']; $kelas = !empty($s['nama_kelas']) ? $s['nama_kelas'] : '-'; $no_ortu = $s['no_ortu']; $tanggal = date('d-m-Y'); $jam_pulang = $jam; $pesan = "📢 ABSENSI PULANG SISWA\n\n". "Nama: $nama\n". "Kelas: $kelas\n". "Tanggal: $tanggal\n". "Jam Pulang: $jam_pulang\n\n". "Status: PULANG 🏁"; if(!empty($no_ortu)){ kirimWA($no_ortu, $pesan); } echo ""; } } } elseif($pegawai->num_rows > 0){ $p = $pegawai->fetch_assoc(); $id = $p['id_pegawai']; $cek = $koneksi->query("
SELECT * FROM absensi_pegawai
WHERE id_pegawai='$id'
AND DATE(tanggal)=CURDATE()
LIMIT 1
"); if($cek->num_rows == 0){ echo ""; } else { $data = $cek->fetch_assoc(); if(!empty($data['jam_pulang'])){ echo ""; } else { $koneksi->query("
UPDATE absensi_pegawai
SET jam_pulang='$jam'
WHERE id='".$data['id']."'
"); $nama = $p['nama']; $jabatan = $p['jabatan']; $tanggal = date('d-m-Y'); $jam_pulang = $jam; $no_kepsek = "6281214399124"; $pesan = "📢 ABSENSI PULANG PEGAWAI\n\n". "Nama: $nama\n". "Jabatan: $jabatan\n". "Tanggal: $tanggal\n". "Jam Pulang: $jam_pulang\n\n". "Status: PULANG 🏁"; kirimWA($no_kepsek, $pesan); echo ""; } } } else { echo ""; } } $hadir_siswa = $koneksi->query("
SELECT COUNT(*) as jml
FROM absensi
WHERE tanggal='$today'
AND jam_masuk IS NOT NULL
")->fetch_assoc()['jml']; $total_siswa = $koneksi->query("
SELECT COUNT(*) as jml FROM siswa
")->fetch_assoc()['jml']; $hadir_pegawai = $koneksi->query("
SELECT COUNT(*) as jml
FROM absensi_pegawai
WHERE tanggal='$today'
AND jam_masuk IS NOT NULL
")->fetch_assoc()['jml']; $total_pegawai = $koneksi->query("
SELECT COUNT(*) as jml FROM pegawai
")->fetch_assoc()['jml']; ?>
Absensi Digital
JAM SEKARANG
12
1
2
3
4
5
6
7
8
9
10
11
ABSEN PULANG
Siswa Hadir
Siswa Tidak Hadir
0
Pegawai Hadir
Pegawai Tidak Hadir
0
5 Absensi Terakhir