-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               8.0.30 - MySQL Community Server - GPL
-- Server OS:                    Win64
-- HeidiSQL Version:             12.1.0.6537
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

-- Dumping structure for table absensi_sekolah_v.3.absen
DROP TABLE IF EXISTS `absen`;
CREATE TABLE IF NOT EXISTS `absen` (
  `absen_id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL DEFAULT '0',
  `tanggal` date NOT NULL,
  `lokasi_id` int DEFAULT NULL,
  `jam_masuk` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jam_toleransi` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jam_pulang` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `absen_in` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `absen_out` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `foto_in` varchar(70) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `foto_out` varchar(70) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_masuk` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_pulang` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `map_in` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `map_out` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kehadiran` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `radius` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `radius_out` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `keterangan` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`absen_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.absen: ~0 rows (approximately)

-- Dumping structure for table absensi_sekolah_v.3.absen_ekbm
DROP TABLE IF EXISTS `absen_ekbm`;
CREATE TABLE IF NOT EXISTS `absen_ekbm` (
  `absen_id` int NOT NULL AUTO_INCREMENT,
  `jadwal_id` int NOT NULL DEFAULT '0',
  `pegawai` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `kelas` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pelajaran` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tanggal` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `keterangan` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`absen_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.absen_ekbm: ~0 rows (approximately)
INSERT INTO `absen_ekbm` (`absen_id`, `jadwal_id`, `pegawai`, `user_id`, `kelas`, `pelajaran`, `tanggal`, `time`, `keterangan`) VALUES
	(1, 4, 12, 1, 'IX-A', '3', '2025-11-29', '12:03:21', 'N');

-- Dumping structure for table absensi_sekolah_v.3.absen_pegawai
DROP TABLE IF EXISTS `absen_pegawai`;
CREATE TABLE IF NOT EXISTS `absen_pegawai` (
  `absen_id` int NOT NULL AUTO_INCREMENT,
  `pegawai_id` int NOT NULL DEFAULT '0',
  `tanggal` date NOT NULL,
  `lokasi_id` int DEFAULT NULL,
  `jam_masuk` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jam_toleransi` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jam_pulang` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `absen_in` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `absen_out` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `foto_in` varchar(70) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `foto_out` varchar(70) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_masuk` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_pulang` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `map_in` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `map_out` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kehadiran` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `radius` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `radius_out` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `keterangan` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`absen_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.absen_pegawai: ~0 rows (approximately)

-- Dumping structure for table absensi_sekolah_v.3.admin
DROP TABLE IF EXISTS `admin`;
CREATE TABLE IF NOT EXISTS `admin` (
  `admin_id` int NOT NULL AUTO_INCREMENT,
  `fullname` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `avatar` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `registrasi_date` date NOT NULL,
  `tanggal_login` datetime NOT NULL,
  `time` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `level` int NOT NULL,
  `ip` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `browser` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`admin_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.admin: ~3 rows (approximately)
INSERT INTO `admin` (`admin_id`, `fullname`, `username`, `phone`, `email`, `password`, `avatar`, `registrasi_date`, `tanggal_login`, `time`, `status`, `level`, `ip`, `browser`, `active`) VALUES
	(1, 'Coki Widodo', 'Widodo', '089666665781', 'swidodo.com@gmail.com', '$2y$10$iUZpF3UFbPjH4U/zErn5I.mixtbptmapoRYp6tIi69MqTVqaNirRy', 'avatar-Widodo-1670038763.jpg', '2022-03-22', '2026-03-03 19:07:34', '1772539654', 'Online', 1, '1', 'Google Crome', 'Y'),
	(6, 'Intan Permata sari', 'Intan', '089666665781', 'intanpermatasari@gmail.com', '$2y$10$lIKR1cqN8kNusBU45zqvAuINgD.g9X3/2rDBC6qvjT4oejy1jP53S', 'avatar.jpg', '2022-12-01', '2022-12-03 10:22:26', '1670047459', 'Offline', 1, '::1', 'Google Chrome 107.0.0.0', 'Y'),
	(7, 'Intan', 'Intan', '083160901108', 'intanwidodo@gmail.com', '$2y$10$qcLhXtELoswkSi.j4xEwFuK76EgZdLLR7aDlOikwJyp16B1y.dKXS', 'avatar.jpg', '2023-07-07', '2023-07-07 05:08:01', '1688699281', 'Offline', 3, '::1', 'Google Chrome 114.0.0.0', 'Y');

-- Dumping structure for table absensi_sekolah_v.3.artikel
DROP TABLE IF EXISTS `artikel`;
CREATE TABLE IF NOT EXISTS `artikel` (
  `artikel_id` int NOT NULL AUTO_INCREMENT,
  `penerbit` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `judul` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `domain` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deskripsi` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `foto` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `kategori` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `time` time NOT NULL,
  `date` date NOT NULL,
  `statistik` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`artikel_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.artikel: ~3 rows (approximately)
INSERT INTO `artikel` (`artikel_id`, `penerbit`, `judul`, `domain`, `deskripsi`, `foto`, `kategori`, `time`, `date`, `statistik`, `active`) VALUES
	(2, 'Widodo', 'Aplikasi Absensi Siswa Dengan Notifikasi ke Orang Tua Berbasis Web', 'aplikasi-absensi-siswa-dengan-notifikasi-ke-orang-tua-berbasis-web', '<p><span class="yt-core-attributed-string--link-inherit-color" dir="auto">Halo, Bapak/Ibu Guru dan Sobat Pendidikan! 📢 Pernah repot dengan absensi manual yang memakan waktu? Kini saatnya beralih ke AbsenSiswa! ✅ Solusi absensi digital yang cepat, akurat, dan anti-kecurangan. Pantau kehadiran siswa secara real-time dengan mudah! 🚀📊 Yuk, kenali fitur lengkapnya sekarang! </span><span class="yt-core-attributed-string--link-inherit-color" dir="auto"><a class="yt-core-attributed-string__link yt-core-attributed-string__link--call-to-action-color" tabindex="0" href="https://www.youtube.com/hashtag/absensiswa" target="">#AbsenSiswa</a></span> <span class="yt-core-attributed-string--link-inherit-color" dir="auto"><a class="yt-core-attributed-string__link yt-core-attributed-string__link--call-to-action-color" tabindex="0" href="https://www.youtube.com/hashtag/absensidigital" target="">#AbsensiDigital</a></span><span class="yt-core-attributed-string--link-inherit-color" dir="auto">" Untuk Harga dan Pemesanan bisa langsung hub </span><span class="yt-core-attributed-string--link-inherit-color" dir="auto"><a class="yt-core-attributed-string__link yt-core-attributed-string__link--call-to-action-color" tabindex="0" href="https://www.youtube.com/redirect?event=video_description&amp;redir_token=QUFFLUhqbnhKOFN2YjVqcEJYOE9aQzZWaTRWWkllYnB1UXxBQ3Jtc0trV1Z0WDJXTVFPRXM5a29qSkdXb1JsQURjNE9STDVleHVZQU16cjZCMEZjT0dKZmtWSmV5akZDMDZfSDV1bVNIQTd2RDU3M05TSlBwYU16WEtzVGp6cU9RTXMteHRUcy13TDE3eVlwRzc2UmZQbEYwaw&amp;q=https%3A%2F%2Fwa.me%2F62083160901108&amp;v=IFpfp62F9_Y" target="_blank" rel="nofollow noopener">https://wa.me/62083160901108</a></span></p>\r\n<p><span class="yt-core-attributed-string--link-inherit-color" dir="auto"><iframe title="YouTube video player" src="//www.youtube.com/embed/IFpfp62F9_Y?si=8FvO1EbsfZVwP4pI" width="560" height="315" frameborder="0" allowfullscreen="allowfullscreen"></iframe></span></p>', 'file_685c28e93a19d9.58068809.jpg', 'berita', '16:53:10', '2022-11-29', '12', 'Y'),
	(3, 'Widodo', 'Aplikasi Absensi V.5 Absen dengan Selfie Recognition &amp; QRCODE Radius', 'aplikasi-absensi-v5-absen-dengan-selfie-recognition-amp-qrcode-radius', '<div class="more_lessx">\r\n<p>Aplikasi Absensi Online Berbasis Foto Selfie Recognition dan QRCODE. Website ini dibangun menggunakan framework bootstrap dan PHP (MYSQLi). Sekilas cara kerjanya dengan merekam absen menggunakan verifikasi foto selfie recognition dan QRCODE, serta mendetek lokasi pengguna saat mengisi absensi online. Pengguna hanya boleh melakukan absen masuk dan absen pulang 1 kali perhari di jam kerja nya.</p>\r\n<ins class="adsbygoogle" data-ad-layout="in-article" data-ad-format="fluid" data-ad-client="ca-pub-9864620178233492" data-ad-slot="8776392112" data-adsbygoogle-status="done" data-ad-status="unfilled"></ins>\r\n<p>Di versi ke 5 ini Foto Selfienya sudah menggunakan Recognition dan&nbsp; Menggunakan QRCODE sebagai pengganti jadi ada 2 pilihan Tipe Absenya.</p>\r\n<p>- FREE Biaya Ongkos Kirim<br>- Dapat Source Kode dan Databasenya<br>- Lisensi Dijamin ORIGINAL Garansi Uang Kembali 100%<br>- BARANG SELALU READY<br>- TANPA ONGKOS KIRIM<br>- PRODUK ORIGINAL 100%</p>\r\n<p><br><strong>FITUR UNGGULAN</strong></p>\r\n<ol>\r\n<li>Absensi dengan foto wajah sudah menggunakan Recognition</li>\r\n<li>Absen Menggunakan QRCODE untuk pilihan ke 2</li>\r\n<li>Lokasi Radiusnya bias di aktifinkan dan non aktifkan</li>\r\n<li>Terdapat Api Notifikasi WhatsApp</li>\r\n<li>Absen masuk &amp; absen pulang</li>\r\n<li>Deteksi lokasi pengguna (geolocation)</li>\r\n<li>Laporan Absensi Lengkap</li>\r\n<li>Manajemen jam</li>\r\n<li>Fitur login dengan akun google</li>\r\n<li>Pengajuan Cuti</li>\r\n<li>Hadir, Izin, Sakit</li>\r\n<li>Terdapat Slider foto/untuk promo</li>\r\n<li>Terdapat Artikel/Informasi</li>\r\n<li>Terdapat Live Chat ke Admin</li>\r\n</ol>\r\n<p><br><strong>FITUR UMUM</strong><br>- Landing page &amp; web responsive<br>- Mudah di gunakan dan aplikasi ringan<br>- Rekap laporan berdasarkan bulan, Tanggal dan Hari<br>- Laporan absen dalam PDF, Excel dan Print<br>- Fitur print laporan langsung ke printer</p>\r\n<p>- Kelebihan Script / Source Code :<br>- Bersifat selamanya tanpa batas waktu<br>- Panduan Instalasi Lengkap<br>- Installasi Sangat Mudah<br>- Tidak akan di Banned<br>- Bisa Offline maupun Online<br>- Tidak boleh dijual kembali<br>- Tampilan Bisa di edit atau di custom sesuai yang dibutuhkan<br>- Konsultasi Free<br><br></p>\r\n<p><strong>DEMO APLIKASI</strong></p>\r\n<p><strong>Pegawai/User:</strong><br>- Url : https://absensiv5.s-widodo.com<br>- Email : swidodo.com@gmail.com<br>- Password : 123456</p>\r\n<p><strong>Admin</strong><br>-&nbsp;<a href="https://absensiv5.s-widodo.com/sw-admin">https://absensiv5.s-widodo.com/sw-admin</a><br>- User : Widodo<br>- Password : 123456</p>\r\n<p><br><br><strong>UPDATE ICON TIDAK TAMPIL SILAHKAN DOWNLOAD LINK DIBAWAH INI</strong></p>\r\n<p><a title="DOWNLOAD" href="https://drive.google.com/file/d/1PNxh960XAf2j7Dkdm2yRB6q6hMK6FW7J/view?usp=drive_link" target="_blank" rel="noopener"><strong>Download</strong></a></p>\r\n<p><strong>*Bagi yang sudah order</strong></p>\r\n<p>&nbsp;</p>\r\n<p><strong>*PRODUK ORIGINAL DIBUAT OLEH S-WIDODO.COM</strong></p>\r\n</div>', 'file_685c28bbef8856.56859555.jpg', 'berita', '10:41:55', '2022-11-30', '55', 'Y'),
	(4, 'Coki Widodo', 'Aplikasi Absensi Siswa Dengan Scan Qrcode/Barcode V.1', 'aplikasi-absensi-siswa-dengan-scan-qrcodebarcode-v1', '<p><a class="google-anno" href="https://s-widodo.com/product/19-aplikasi-absensi-siswa-dengan-scan-qrcodebarcode-v1.html#" data-google-vignette="false" data-google-interstitial="false">&nbsp;<span class="google-anno-t">Aplikasi</span></a>&nbsp;ini merecord absensi menggunakan QR CODE yang bisa di download oleh siswa beserta ID CARDnya. sudah support di Semua HP, Laptop dan bisa pakai Mesin&nbsp;<a class="google-anno" href="https://s-widodo.com/product/19-aplikasi-absensi-siswa-dengan-scan-qrcodebarcode-v1.html#" data-google-vignette="false" data-google-interstitial="false">&nbsp;<span class="google-anno-t">scanner</span></a><br>.<br><br><strong>*SEMUA PRODUK FULL SOURCE CODE YA BISA LANGSUNG DIGUNAKAN</strong><br><br></p>\r\n<ul>\r\n<li><span data-preserver-spaces="true">Dapat Source Kode dan Databasenya</span></li>\r\n<li><span data-preserver-spaces="true">Lisensi Dijamin ORIGINAL Garansi Uang Kembali 100%</span></li>\r\n<li><span data-preserver-spaces="true">BARANG SELALU READY</span></li>\r\n<li><span data-preserver-spaces="true">PRODUK ORIGINAL 100%</span></li>\r\n</ul>\r\n<p><strong>FITUR UNGGULA</strong></p>\r\n<ul>\r\n<li><span data-preserver-spaces="true">Tampilan Sudah Respoonsive</span></li>\r\n<li><span data-preserver-spaces="true">Absen Scan qrcode menggunakan Hp, Laptop atau Mesin Scanner</span></li>\r\n<li><span data-preserver-spaces="true">Mudah di Operasikan</span></li>\r\n<li><span data-preserver-spaces="true">Terdapat ID Card yang bisa diubah Oleh siswa maupun Admin</span></li>\r\n<li><span data-preserver-spaces="true">Terdapat Geo Location Absen masuk mencatat lokasi titik absen</span></li>\r\n<li><span data-preserver-spaces="true">Memiliki Fitur Login Google</span></li>\r\n<li><span data-preserver-spaces="true">Memiiliki Fitur Notifikasi WhatsApp ke Wali Murid/Siswa</span></li>\r\n<li><span data-preserver-spaces="true">Laporan Lengkap per hari, siswa maupun bulan dengan output PDF, EXCEL dan PRINT</span></li>\r\n<li><span data-preserver-spaces="true">Memiliki Fitur Izin dengan Approve Guru atau Admin</span></li>\r\n<li><span data-preserver-spaces="true">Support PHP Versi 7.4</span></li>\r\n<li><span data-preserver-spaces="true">Memiliki Radius Lokasi</span></li>\r\n</ul>\r\n<p>&nbsp;</p>\r\n<div id="aswift_1_host"><iframe id="aswift_1" tabindex="0" title="Advertisement" src="https://googleads.g.doubleclick.net/pagead/ads?client=ca-pub-9864620178233492&amp;output=html&amp;h=183&amp;slotname=8776392112&amp;adk=1194630350&amp;adf=2803266164&amp;pi=t.ma~as.8776392112&amp;w=730&amp;abgtt=6&amp;fwrn=4&amp;lmt=1742000165&amp;rafmt=11&amp;format=730x183&amp;url=https%3A%2F%2Fs-widodo.com%2Fproduct%2F19-aplikasi-absensi-siswa-dengan-scan-qrcodebarcode-v1.html&amp;wgl=1&amp;uach=WyJXaW5kb3dzIiwiMTkuMC4wIiwieDg2IiwiIiwiMTM0LjAuNjk5OC44OSIsbnVsbCwwLG51bGwsIjY0IixbWyJDaHJvbWl1bSIsIjEzNC4wLjY5OTguODkiXSxbIk5vdDpBLUJyYW5kIiwiMjQuMC4wLjAiXSxbIkdvb2dsZSBDaHJvbWUiLCIxMzQuMC42OTk4Ljg5Il1dLDBd&amp;dt=1742000165348&amp;bpp=1&amp;bdt=403&amp;idt=115&amp;shv=r20250312&amp;mjsv=m202503130101&amp;ptt=9&amp;saldr=aa&amp;abxe=1&amp;cookie=ID%3Df224fe6f6d255e66%3AT%3D1730436363%3ART%3D1742000160%3AS%3DALNI_MYYMEXP2UdT586N_zS4X_sU7Xc1uA&amp;gpic=UID%3D00000f49832daf32%3AT%3D1730436363%3ART%3D1742000160%3AS%3DALNI_MYSp3REtreyD8M0nBXOjCeHduaFYw&amp;eo_id_str=ID%3Daf23020dfda5e9bc%3AT%3D1730436363%3ART%3D1742000160%3AS%3DAA-AfjZxApCm2sA4vbeTJeiOqK1L&amp;prev_fmts=0x0&amp;nras=1&amp;correlator=5183522587339&amp;frm=20&amp;pv=1&amp;rplot=4&amp;u_tz=420&amp;u_his=3&amp;u_h=1080&amp;u_w=1920&amp;u_ah=1032&amp;u_aw=1920&amp;u_cd=24&amp;u_sd=1&amp;dmc=8&amp;adx=400&amp;ady=1958&amp;biw=1910&amp;bih=911&amp;scr_x=0&amp;scr_y=0&amp;eid=31089628%2C31091052%2C95332590%2C95354310%2C95354338%2C95354598%2C31091039%2C31088250%2C31090357%2C95352178&amp;oid=2&amp;pvsid=4476553562543792&amp;tmod=1486444475&amp;uas=0&amp;nvt=1&amp;ref=https%3A%2F%2Fs-widodo.com%2Fproduct&amp;fc=1920&amp;brdim=0%2C0%2C0%2C0%2C1920%2C0%2C1920%2C1032%2C1920%2C911&amp;vis=1&amp;rsz=%7C%7CpoeEbr%7C&amp;abl=CS&amp;pfx=0&amp;fu=128&amp;bc=31&amp;bz=1&amp;td=1&amp;tdf=2&amp;psd=W251bGwsbnVsbCxudWxsLDNd&amp;nt=1&amp;ifi=2&amp;uci=a!2&amp;btvi=1&amp;fsb=1&amp;dtd=124" name="aswift_1" width="730" height="0" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" sandbox="allow-forms allow-popups allow-popups-to-escape-sandbox allow-same-origin allow-scripts allow-top-navigation-by-user-activation" data-google-container-id="a!2" aria-label="Advertisement" data-google-query-id="CJCbnajwiowDFfBynQkdWq4Oww" data-load-complete="true"></iframe></div>\r\n<p>&nbsp;</p>\r\n<p><br><br>FITUR UMUM</p>\r\n<ul>\r\n<li><span data-preserver-spaces="true">Landing page &amp; web responsive</span></li>\r\n<li><span data-preserver-spaces="true">Mudah di gunakan dan aplikasi ringan</span></li>\r\n<li><span data-preserver-spaces="true">Rekap laporan berdasarkan bulan, Tanggal dan Siswa</span></li>\r\n<li><span data-preserver-spaces="true">Laporan absen dalam PDF, EXCEL dan PRINT</span></li>\r\n<li><span data-preserver-spaces="true">Fitur Print laporan langsung ke Printer</span></li>\r\n</ul>\r\n<p><br><br>Kelebihan Script / Source Code :<br>Bersifat selamanya tanpa batas waktu<br>Panduan Instalasi Lengkap<br>Installasi Sangat Mudah<br>Tidak akan di Banned<br>Bisa Offline maupun Online<br>Tidak boleh dijual kembali<br>Tampilan Bisa di edit atau di custom sesuai yang dibutuhkan<br>Konsultasi Free<br><br><br>DEMO APLIKASI<br>https://absensi-sekolah.s-widodo.com/<br>Email : swidodo.com@gmail.com<br>Password : 123456<br><br>ADMIN<br>https://absensi-sekolah.s-widodo.com/sw-admin<br>Username : Widodo<br>Password : 123456</p>', 'file_685c28780a0eb7.19604562.jpg', 'berita', '07:55:33', '2025-06-25', '18', 'Y'),
	(7, 'Coki Widodo', 'Aplikasi PPDB (Pendaftaran Siswa baru) PHP V.8+', 'aplikasi-ppdb-pendaftaran-siswa-baru-php-v8', '<p><a class="google-anno" href="https://s-widodo.com/product/22-aplikasi-ppdb-pendaftaran-siswa-baru-php-v8.html#" data-google-vignette="false" data-google-interstitial="false">&nbsp;<span class="google-anno-t">Aplikasi</span></a>&nbsp;PPDB (Penerimaan Peserta Didik Baru) adalah sebuah sistem digital yang dirancang untuk mempermudah proses pendaftaran siswa baru ke jenjang pendidikan tertentu, mulai dari tingkat SD, SMP, hingga SMA/SMK. Dengan memanfaatkan teknologi informasi,&nbsp;<a class="google-anno" href="https://s-widodo.com/product/22-aplikasi-ppdb-pendaftaran-siswa-baru-php-v8.html#" data-google-vignette="false" data-google-interstitial="false">&nbsp;<span class="google-anno-t">aplikasi</span></a>&nbsp;ini memungkinkan proses seleksi, validasi data, dan pengumuman hasil dilakukan secara online.<br><br></p>\r\n<p class="" data-start="542" data-end="568"><strong data-start="542" data-end="568">Manfaat Aplikasi PPDB:</strong></p>\r\n<ol data-start="570" data-end="1550">\r\n<li class="" data-start="570" data-end="819">\r\n<p class="" data-start="573" data-end="819"><strong data-start="573" data-end="609">Meningkatkan Efisiensi dan Waktu</strong><br>Proses pendaftaran yang sebelumnya harus dilakukan langsung di sekolah kini bisa dilakukan dari rumah, hanya dengan menggunakan komputer atau ponsel. Ini menghemat waktu dan tenaga bagi orang tua dan siswa.</p>\r\n<div class="google-anno-skip google-anno-sc" tabindex="0" role="link" aria-label="Kursus online terbaik" data-google-vignette="false" data-google-interstitial="false">Kursus online terbaik</div>\r\n<p>&nbsp;</p>\r\n</li>\r\n<li class="" data-start="821" data-end="1020">\r\n<p class="" data-start="824" data-end="1020"><strong data-start="824" data-end="860">Mengurangi Antrean dan Kerumunan</strong><br>Dengan sistem online, tak perlu lagi datang ke sekolah hanya untuk menyerahkan berkas. Ini sangat berguna terutama saat pandemi atau dalam kondisi terbatas.</p>\r\n</li>\r\n<li class="" data-start="1022" data-end="1218">\r\n<p class="" data-start="1025" data-end="1218"><strong data-start="1025" data-end="1056">Transparansi Proses Seleksi</strong><br>Aplikasi PPDB sering dilengkapi dengan sistem penilaian otomatis dan publikasi hasil secara real-time. Ini mengurangi potensi kecurangan atau manipulasi data.</p>\r\n</li>\r\n</ol>\r\n<h4 data-start="1609" data-end="1847">FITUR UNGGULAN</h4>\r\n<p data-start="1609" data-end="1847">✅Formulir Data diri lengkap<br>✅ Formulir Nilai (Fleksibel Bisa di aktifkan dan Nonaktifkan)<br>✅ Upload Berkas (Fleksibel Bisa di aktifkan dan Nonaktifkan)<br>✅ Pembayaran Payment Gateway (Fleksibel Bisa di aktifkan dan Nonaktifkan)<br>✅ Registrasi Ulang (Fleksibel Bisa di aktifkan dan Nonaktifkan)<br>✅ Login dengan Google<br>✅ Memiliki Notifikasi WhatsApp (jika di aktifkan)<br>✅ Laporan Lengkap.<br>✅ Tampilan Responsive<br>✅ Support Php Versi 8+</p>\r\n<p><iframe src="https://www.youtube.com/embed/mabbQ7ZSTv4?si=beLZyfLCQawRgAjJ" width="560" height="314" allowfullscreen="allowfullscreen"></iframe></p>', 'file_685c29475c27d0.48182116.jpg', 'berita', '23:51:09', '2025-06-25', '8', 'Y');

-- Dumping structure for table absensi_sekolah_v.3.bentuk_pelanggaran
DROP TABLE IF EXISTS `bentuk_pelanggaran`;
CREATE TABLE IF NOT EXISTS `bentuk_pelanggaran` (
  `bentuk_pelanggaran_id` int NOT NULL AUTO_INCREMENT,
  `kategori_pelanggaran_id` int NOT NULL DEFAULT '0',
  `bentuk_pelanggaran` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bobot` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`bentuk_pelanggaran_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.bentuk_pelanggaran: ~5 rows (approximately)
INSERT INTO `bentuk_pelanggaran` (`bentuk_pelanggaran_id`, `kategori_pelanggaran_id`, `bentuk_pelanggaran`, `bobot`) VALUES
	(1, 1, 'Berkelahi dengan sekolahan lain', '100'),
	(2, 1, 'Terbukti melakukan kejahatan', '50'),
	(3, 4, 'Mengejek Guru', '10'),
	(4, 4, 'Berkata Kotor Dengan Guru', '50'),
	(5, 2, 'Absensi Telat', '10');

-- Dumping structure for table absensi_sekolah_v.3.chat
DROP TABLE IF EXISTS `chat`;
CREATE TABLE IF NOT EXISTS `chat` (
  `chat_id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL DEFAULT '0',
  `pegawai_id` int NOT NULL DEFAULT '0',
  `pesan` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `files` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ukuran` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `datetime` datetime NOT NULL,
  `tujuan` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_user` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_pegawai` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`chat_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.chat: ~0 rows (approximately)

-- Dumping structure for table absensi_sekolah_v.3.chat_list
DROP TABLE IF EXISTS `chat_list`;
CREATE TABLE IF NOT EXISTS `chat_list` (
  `chat_list_id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `pegawai_id` int DEFAULT NULL,
  `datetime` datetime NOT NULL,
  PRIMARY KEY (`chat_list_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.chat_list: ~0 rows (approximately)
INSERT INTO `chat_list` (`chat_list_id`, `user_id`, `pegawai_id`, `datetime`) VALUES
	(6, 1, 12, '2026-02-10 19:57:09');

-- Dumping structure for table absensi_sekolah_v.3.izin
DROP TABLE IF EXISTS `izin`;
CREATE TABLE IF NOT EXISTS `izin` (
  `izin_id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL DEFAULT '0',
  `nama_lengkap` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tanggal` date NOT NULL,
  `tanggal_selesai` date NOT NULL,
  `files` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alasan` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `keterangan` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `time` time NOT NULL,
  `date` date NOT NULL,
  `status` enum('PENDING','Y','N') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PENDING',
  PRIMARY KEY (`izin_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.izin: ~0 rows (approximately)
INSERT INTO `izin` (`izin_id`, `user_id`, `nama_lengkap`, `tanggal`, `tanggal_selesai`, `files`, `alasan`, `keterangan`, `time`, `date`, `status`) VALUES
	(1, 1, 'Siswa Widodo', '2025-11-18', '2025-11-18', 'izin_691c1349cac038.74153482.jpg', 'Izin', 'asdasd', '13:33:45', '2025-11-18', 'Y');

-- Dumping structure for table absensi_sekolah_v.3.izin_pegawai
DROP TABLE IF EXISTS `izin_pegawai`;
CREATE TABLE IF NOT EXISTS `izin_pegawai` (
  `izin_id` int NOT NULL AUTO_INCREMENT,
  `pegawai_id` int NOT NULL DEFAULT '0',
  `nama_lengkap` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tanggal` date NOT NULL,
  `tanggal_selesai` date NOT NULL,
  `files` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alasan` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `keterangan` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `time` time NOT NULL,
  `date` date NOT NULL,
  `status` enum('PENDING','Y','N') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PENDING',
  PRIMARY KEY (`izin_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.izin_pegawai: ~0 rows (approximately)

-- Dumping structure for table absensi_sekolah_v.3.jadwal_mengajar
DROP TABLE IF EXISTS `jadwal_mengajar`;
CREATE TABLE IF NOT EXISTS `jadwal_mengajar` (
  `jadwal_id` int NOT NULL AUTO_INCREMENT,
  `hari` varchar(50) DEFAULT NULL,
  `pegawai` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `mata_pelajaran` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `tingkat` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `kelas` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `dari_jam` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `sampai_jam` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  PRIMARY KEY (`jadwal_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3;

-- Dumping data for table absensi_sekolah_v.3.jadwal_mengajar: ~6 rows (approximately)
INSERT INTO `jadwal_mengajar` (`jadwal_id`, `hari`, `pegawai`, `mata_pelajaran`, `tingkat`, `kelas`, `dari_jam`, `sampai_jam`) VALUES
	(4, 'Sabtu', '12', '3', 'IX', 'IX-A', '07:00', '08:00'),
	(6, 'Selasa', '12', '3', 'IX', 'IX-A', '07:00', '08:00'),
	(7, 'Rabu', '12', '3', 'IX', 'IX-A', '07:30', '09:00'),
	(8, 'Jumat', '12', '3', 'IX', 'IX-A', '07:00', '09:00'),
	(9, 'Kamis', '14', '3', 'IX', 'IX-A', '07:00', '08:00'),
	(10, 'Kamis', '12', '3', 'IX', 'IX-A', '07:00', '08:00');

-- Dumping structure for table absensi_sekolah_v.3.jam_sekolah
DROP TABLE IF EXISTS `jam_sekolah`;
CREATE TABLE IF NOT EXISTS `jam_sekolah` (
  `jam_sekolah_id` int NOT NULL AUTO_INCREMENT,
  `hari` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jam_masuk` time DEFAULT NULL,
  `jam_telat` time DEFAULT NULL,
  `jam_pulang` time DEFAULT NULL,
  `tipe` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active` enum('Y','N') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'N',
  PRIMARY KEY (`jam_sekolah_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.jam_sekolah: ~21 rows (approximately)
INSERT INTO `jam_sekolah` (`jam_sekolah_id`, `hari`, `jam_masuk`, `jam_telat`, `jam_pulang`, `tipe`, `active`) VALUES
	(1, 'Minggu', '07:30:00', '08:00:00', '12:00:00', 'Siswa', 'N'),
	(2, 'Senin', '07:30:00', '08:00:00', '12:00:00', 'Siswa', 'Y'),
	(3, 'Selasa', '07:30:00', '08:00:00', '13:00:00', 'Siswa', 'Y'),
	(4, 'Rabu', '07:30:00', '08:00:00', '13:00:00', 'Siswa', 'Y'),
	(5, 'Kamis', '07:30:00', '16:00:00', '21:00:00', 'Siswa', 'Y'),
	(6, 'Jumat', '07:30:00', '08:00:00', '12:00:00', 'Siswa', 'Y'),
	(7, 'Sabtu', '05:58:55', '05:58:59', '05:59:00', 'Siswa', 'N'),
	(8, 'Senin', '07:30:00', '08:00:00', '15:00:00', 'guru', 'Y'),
	(9, 'Selasa', '07:30:00', '08:00:00', '15:00:00', 'guru', 'Y'),
	(10, 'Rabu', '07:00:00', '08:00:00', '15:00:00', 'guru', 'Y'),
	(11, 'Kamis', '00:00:00', '00:00:00', '00:00:00', 'guru', 'Y'),
	(12, 'Jumat', '07:00:00', '00:00:00', '00:00:00', 'guru', 'Y'),
	(13, 'Sabtu', '07:00:00', '07:30:00', '13:00:00', 'guru', 'N'),
	(14, 'Minggu', '00:00:00', '00:00:00', '00:00:00', 'guru', 'N'),
	(15, 'Senin', '00:00:00', '00:00:00', '00:00:00', 'staff', 'Y'),
	(16, 'Selasa', '00:00:00', '00:00:00', '00:00:00', 'staff', 'Y'),
	(17, 'Rabu', '00:00:00', '00:00:00', '00:00:00', 'staff', 'Y'),
	(18, 'Kamis', '00:00:00', '00:00:00', '00:00:00', 'staff', 'Y'),
	(19, 'Jumat', '00:00:00', '00:00:00', '00:00:00', 'staff', 'Y'),
	(20, 'Sabtu', '00:00:00', '00:00:00', '00:00:00', 'staff', 'Y'),
	(21, 'Minggu', '00:00:00', '00:00:00', '00:00:00', 'staff', 'N');

-- Dumping structure for table absensi_sekolah_v.3.kartu_nama
DROP TABLE IF EXISTS `kartu_nama`;
CREATE TABLE IF NOT EXISTS `kartu_nama` (
  `kartu_id` int NOT NULL AUTO_INCREMENT,
  `nama` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `foto` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tipe` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active` enum('Y','N') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'N',
  PRIMARY KEY (`kartu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.kartu_nama: ~0 rows (approximately)
INSERT INTO `kartu_nama` (`kartu_id`, `nama`, `foto`, `tipe`, `active`) VALUES
	(2, 'Template 1', 'file_68c13a41ae59c9.05901307.png', 'P', 'Y');

-- Dumping structure for table absensi_sekolah_v.3.kategori
DROP TABLE IF EXISTS `kategori`;
CREATE TABLE IF NOT EXISTS `kategori` (
  `kategori_id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `seotitle` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`kategori_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.kategori: ~2 rows (approximately)
INSERT INTO `kategori` (`kategori_id`, `title`, `seotitle`) VALUES
	(1, 'Pengumuman', 'pengumuman'),
	(15, 'Berita', 'berita');

-- Dumping structure for table absensi_sekolah_v.3.kategori_pelanggaran
DROP TABLE IF EXISTS `kategori_pelanggaran`;
CREATE TABLE IF NOT EXISTS `kategori_pelanggaran` (
  `kategori_pelanggaran_id` int NOT NULL AUTO_INCREMENT,
  `nama_kategori` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`kategori_pelanggaran_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.kategori_pelanggaran: ~4 rows (approximately)
INSERT INTO `kategori_pelanggaran` (`kategori_pelanggaran_id`, `nama_kategori`) VALUES
	(1, 'KEJAHATAN'),
	(2, 'KERAJINAN'),
	(3, 'KERAPIAN'),
	(4, 'KESOPANAN');

-- Dumping structure for table absensi_sekolah_v.3.kelas
DROP TABLE IF EXISTS `kelas`;
CREATE TABLE IF NOT EXISTS `kelas` (
  `kelas_id` int NOT NULL AUTO_INCREMENT,
  `parent_id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `nama_kelas` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`kelas_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.kelas: ~7 rows (approximately)
INSERT INTO `kelas` (`kelas_id`, `parent_id`, `nama_kelas`) VALUES
	(1, '0', 'VII'),
	(2, '0', 'VIII'),
	(3, '0', 'IX'),
	(7, '3', 'IX-A'),
	(8, '3', 'IX-B'),
	(9, '3', 'IX-C'),
	(12, '3', 'IX-D');

-- Dumping structure for table absensi_sekolah_v.3.lain_lain
DROP TABLE IF EXISTS `lain_lain`;
CREATE TABLE IF NOT EXISTS `lain_lain` (
  `lain_lain_id` int NOT NULL AUTO_INCREMENT,
  `nama` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tipe` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lain_lain_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.lain_lain: ~8 rows (approximately)
INSERT INTO `lain_lain` (`lain_lain_id`, `nama`, `tipe`) VALUES
	(1, 'Asia/Jakarta', 'timezone'),
	(2, 'Asia/Makassar', 'timezone'),
	(3, 'Asia/Jayapura', 'timezone'),
	(4, 'Siswa', 'waktu'),
	(5, 'Guru', 'Waktu'),
	(6, 'TU', 'waktu'),
	(7, 'Izin', 'izin'),
	(8, 'Sakit', 'izin');

-- Dumping structure for table absensi_sekolah_v.3.level
DROP TABLE IF EXISTS `level`;
CREATE TABLE IF NOT EXISTS `level` (
  `level_id` int NOT NULL AUTO_INCREMENT,
  `level_nama` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`level_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.level: ~3 rows (approximately)
INSERT INTO `level` (`level_id`, `level_nama`) VALUES
	(1, 'Superadmin'),
	(2, 'User'),
	(3, 'Guru');

-- Dumping structure for table absensi_sekolah_v.3.libur
DROP TABLE IF EXISTS `libur`;
CREATE TABLE IF NOT EXISTS `libur` (
  `libur_id` int NOT NULL AUTO_INCREMENT,
  `libur_hari` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`libur_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.libur: ~3 rows (approximately)
INSERT INTO `libur` (`libur_id`, `libur_hari`, `active`) VALUES
	(1, 'Sabtu', 'N'),
	(2, 'Minggu', 'N'),
	(3, 'Jumat', 'Y');

-- Dumping structure for table absensi_sekolah_v.3.libur_nasional
DROP TABLE IF EXISTS `libur_nasional`;
CREATE TABLE IF NOT EXISTS `libur_nasional` (
  `libur_nasional_id` int NOT NULL AUTO_INCREMENT,
  `libur_tanggal` date NOT NULL,
  `keterangan` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`libur_nasional_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.libur_nasional: ~2 rows (approximately)
INSERT INTO `libur_nasional` (`libur_nasional_id`, `libur_tanggal`, `keterangan`) VALUES
	(1, '2023-08-17', 'Hari Kemerdakaan Indonesia'),
	(7, '2023-11-30', 'Hari Guru');

-- Dumping structure for table absensi_sekolah_v.3.lokasi
DROP TABLE IF EXISTS `lokasi`;
CREATE TABLE IF NOT EXISTS `lokasi` (
  `lokasi_id` int NOT NULL AUTO_INCREMENT,
  `lokasi_nama` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lokasi_alamat` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `lokasi_latitude` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lokasi_longitude` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lokasi_radius` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lokasi_qrcode` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lokasi_tanggal` date NOT NULL,
  `lokasi_jam_mulai` time NOT NULL,
  `lokasi_jam_selesai` time NOT NULL,
  `lokasi_status` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`lokasi_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.lokasi: ~0 rows (approximately)
INSERT INTO `lokasi` (`lokasi_id`, `lokasi_nama`, `lokasi_alamat`, `lokasi_latitude`, `lokasi_longitude`, `lokasi_radius`, `lokasi_qrcode`, `lokasi_tanggal`, `lokasi_jam_mulai`, `lokasi_jam_selesai`, `lokasi_status`) VALUES
	(2, 'S-widodo.com', 'Jl. Rizai kedaton bandar lampung', '-5.371990', '105.271356', '4000', '7FFB1668764933', '2022-11-18', '16:48:53', '16:48:53', 'N');

-- Dumping structure for table absensi_sekolah_v.3.mata_pelajaran
DROP TABLE IF EXISTS `mata_pelajaran`;
CREATE TABLE IF NOT EXISTS `mata_pelajaran` (
  `id` int NOT NULL AUTO_INCREMENT,
  `kode` varchar(50) DEFAULT NULL,
  `nama_mapel` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb3;

-- Dumping data for table absensi_sekolah_v.3.mata_pelajaran: ~12 rows (approximately)
INSERT INTO `mata_pelajaran` (`id`, `kode`, `nama_mapel`) VALUES
	(1, 'PABP', 'Penddidikan Agama dan Budi Pekerti'),
	(2, 'PPKn', 'Pendidikan Pancasila dan Kewarganegaraan'),
	(3, 'BINDO', 'Bahasa Indonesia'),
	(4, 'MTK', 'Matematika'),
	(5, 'IPA', 'Ilmu Pengetahuan Alam'),
	(6, 'IPS', 'Ilmu Pengetahuan Sosial'),
	(7, 'BING', 'Bahasa Inggris'),
	(8, 'PJOK', 'Pendidikan Jasmani Olahraga dan Kesehatan'),
	(9, 'INFO', 'Informatika'),
	(10, 'PRK', 'Prakarya'),
	(11, 'BSUND', 'Bahasa Sunda'),
	(12, 'TIK', 'Tekhnologi Indormasi dan Komunikasi');

-- Dumping structure for table absensi_sekolah_v.3.modul
DROP TABLE IF EXISTS `modul`;
CREATE TABLE IF NOT EXISTS `modul` (
  `modul_id` int NOT NULL AUTO_INCREMENT,
  `modul_nama` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`modul_id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.modul: ~25 rows (approximately)
INSERT INTO `modul` (`modul_id`, `modul_nama`) VALUES
	(1, 'Siswa'),
	(2, 'Wali Murid'),
	(3, 'Kelas'),
	(4, 'Artikel'),
	(5, 'Lokasi'),
	(6, 'Jam Sekolah'),
	(7, 'Tahun ajaran'),
	(8, 'Libur'),
	(9, 'Izin'),
	(10, 'Laporan'),
	(11, 'Pengarutan Web'),
	(13, 'Admin'),
	(14, 'Hak Akses'),
	(15, 'Master Data'),
	(16, 'ID CARD'),
	(17, 'Alumni'),
	(18, 'Pegawai'),
	(19, 'Users'),
	(20, 'Mata Pelajaran'),
	(21, 'E-KBM'),
	(22, 'Jadwal Mengajar'),
	(23, 'Slider'),
	(24, 'Absen Manual'),
	(25, 'Pelanggaran'),
	(26, 'Template Surat'),
	(27, 'Recognition');

-- Dumping structure for table absensi_sekolah_v.3.notifikasi
DROP TABLE IF EXISTS `notifikasi`;
CREATE TABLE IF NOT EXISTS `notifikasi` (
  `notifikasi_id` int NOT NULL AUTO_INCREMENT,
  `user_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pegawai_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nama` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `keterangan` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tanggal` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `datetime` datetime NOT NULL,
  `tipe` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tujuan` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`notifikasi_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.notifikasi: ~4 rows (approximately)
INSERT INTO `notifikasi` (`notifikasi_id`, `user_id`, `pegawai_id`, `nama`, `keterangan`, `link`, `tanggal`, `datetime`, `tipe`, `tujuan`, `status`) VALUES
	(1, '1', '12', 'Siswa Widodo', 'Baru saja megajukan izin', 'izin', '2025-11-18', '2025-11-18 13:33:45', 'siswa', 'pegawai', 'Y'),
	(2, '1', NULL, 'Siswa Widodo', 'Permohonan Izin Anda disetujui', 'izin', '2025-11-18', '2025-11-18 13:33:57', 'pegawai', 'siswa', 'Y'),
	(4, '1', '12', 'Widodo, S.kom', 'Baru saja mengirimkan surat peringatan', 'sanksi-pelanggaran', '2025-12-11', '2025-12-11 21:51:12', 'pegawai', 'siswa', 'Y');

-- Dumping structure for table absensi_sekolah_v.3.pegawai
DROP TABLE IF EXISTS `pegawai`;
CREATE TABLE IF NOT EXISTS `pegawai` (
  `pegawai_id` int NOT NULL AUTO_INCREMENT,
  `nip` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rfid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `descriptor` text COLLATE utf8mb4_unicode_ci,
  `qrcode` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nama_lengkap` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tempat_lahir` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tanggal_lahir` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jenis_kelamin` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jabatan` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wali_kelas` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lokasi` int NOT NULL DEFAULT '0',
  `telp` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alamat` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `avatar` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tanggal_registrasi` datetime NOT NULL,
  `tanggal_login` datetime NOT NULL,
  `ip` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `browser` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('Offline','Online') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Offline',
  `active` enum('Y','N') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`pegawai_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.pegawai: ~2 rows (approximately)
INSERT INTO `pegawai` (`pegawai_id`, `nip`, `rfid`, `descriptor`, `qrcode`, `nama_lengkap`, `email`, `password`, `tempat_lahir`, `tanggal_lahir`, `jenis_kelamin`, `jabatan`, `wali_kelas`, `lokasi`, `telp`, `alamat`, `avatar`, `tanggal_registrasi`, `tanggal_login`, `ip`, `browser`, `status`, `active`) VALUES
	(12, '47821646', '', '[-0.10229844599962234,0.1210261732339859,0.07467818260192871,-0.03945039212703705,-0.06942722201347351,-0.024252932518720627,-0.029015369713306427,-0.083680160343647,0.1931900531053543,-0.11460589617490768,0.30717095732688904,-0.02235858328640461,-0.1579565405845642,-0.15915492177009583,0.006947232410311699,0.18880483508110046,-0.18203826248645782,-0.13469423353672028,-0.07678566128015518,-0.03933720290660858,0.05777605623006821,-0.02790011093020439,0.01185495126992464,-0.023659100756049156,-0.1384560763835907,-0.404992938041687,-0.08296879380941391,-0.06646683812141418,0.09211708605289459,-0.06528905034065247,-0.04564927890896797,-0.028387166559696198,-0.26399174332618713,-0.1053064838051796,-0.00022011995315551758,0.09088297188282013,-0.034107696264982224,-0.05294448509812355,0.1536407768726349,-0.026125872507691383,-0.1991957277059555,-0.0008739912882447243,0.009054108522832394,0.20674729347229004,0.18186581134796143,0.08611515164375305,0.03109724447131157,-0.1095123291015625,0.08961860835552216,-0.15784381330013275,0.07666666060686111,0.10739943385124207,0.0996796265244484,0.05398508906364441,0.021844346076250076,-0.09213036298751831,-0.0032211467623710632,0.13812954723834991,-0.16006401181221008,-0.02586328610777855,0.02947874926030636,-0.05711137503385544,-0.056658945977687836,-0.04806940630078316,0.2545592784881592,0.06669823080301285,-0.10305596888065338,-0.11987408250570297,0.15431556105613708,-0.08270252496004105,-0.006266634911298752,0.032695576548576355,-0.10681866109371185,-0.1764131635427475,-0.3162161111831665,0.06372173130512238,0.44924893975257874,0.06108083575963974,-0.19616319239139557,0.031072279438376427,-0.06139005348086357,-0.02577808126807213,0.13067033886909485,0.12191541492938995,-0.009034881368279457,0.0047575803473591805,-0.07748722285032272,0.04634849354624748,0.2068815678358078,-0.06954917311668396,-0.016028497368097305,0.18347951769828796,-0.048175517469644547,0.06851363182067871,-0.02103261649608612,0.012793274596333504,-0.06390170753002167,0.06805683672428131,-0.06685125827789307,-0.029164833948016167,0.10334677994251251,0.0178381334990263,-0.02186664007604122,0.09638162702322006,-0.15283340215682983,0.102958545088768,0.040798235684633255,0.0318385474383831,0.0742308646440506,-0.026661619544029236,-0.06077319756150246,-0.11792410910129547,0.10377815365791321,-0.2391481250524521,0.22710809111595154,0.19847626984119415,-0.03664502501487732,0.16226929426193237,0.10038850456476212,0.06775060296058655,0.03959638625383377,-0.028637398034334183,-0.2132790982723236,-0.011037650518119335,0.0775732696056366,-0.04595299810171127,0.09928222000598907,-0.0036009596660733223]', '14E1DA5F33', 'Widodo, S.kom', 'swidodo.com@gmail.com', '$2y$10$G6rGVVzneW8YOT9PsM/TZunNCIN/s7dlIN5nzpGTydyJYJb/zHlCu', 'Kudus', '1990-01-01', 'Laki-laki', 'guru', 'IX-A', 2, '6283160901108', 'Lampung', 'avatar_68ff041bd9d5f5.08016454.jpg', '2025-09-12 00:56:06', '2026-03-03 18:45:37', '127.0.0.1', 'Google Chrome 139.0.0.0', 'Online', 'Y'),
	(14, '123456', NULL, NULL, '2222222222', 'Widodo Guru', 'swidodo.com2@gmail.com', '$2y$10$LVFauiZ1AZ0VqbeROgr16.ifzsQ/0nWr9McbRWrxGgGgRtMIQz4xy', NULL, NULL, NULL, 'guru', 'IX-A', 2, NULL, NULL, NULL, '2025-10-13 03:13:10', '2025-10-13 03:13:10', '::1', 'Google Chrome 141.0.0.0', 'Offline', 'Y');

-- Dumping structure for table absensi_sekolah_v.3.pelanggaran
DROP TABLE IF EXISTS `pelanggaran`;
CREATE TABLE IF NOT EXISTS `pelanggaran` (
  `pelanggaran_id` int NOT NULL AUTO_INCREMENT,
  `pegawai_id` int DEFAULT '0',
  `kelas` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `jenis_pelanggaran` int DEFAULT NULL,
  `bentuk_pelanggaran` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bobot` int DEFAULT NULL,
  `tanggal` date NOT NULL,
  `time` time NOT NULL,
  PRIMARY KEY (`pelanggaran_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.pelanggaran: ~3 rows (approximately)
INSERT INTO `pelanggaran` (`pelanggaran_id`, `pegawai_id`, `kelas`, `user_id`, `jenis_pelanggaran`, `bentuk_pelanggaran`, `bobot`, `tanggal`, `time`) VALUES
	(2, 12, 'IX-A', 1, 1, 'Terbukti melakukan kejahatan', 50, '2025-12-08', '14:20:19'),
	(3, 12, 'IX-A', 2, 2, 'Absensi Telat', 10, '2025-12-10', '01:07:29'),
	(4, 12, 'IX-A', 1, 2, 'Absensi Telat', 10, '2025-12-15', '12:47:03');

-- Dumping structure for table absensi_sekolah_v.3.role
DROP TABLE IF EXISTS `role`;
CREATE TABLE IF NOT EXISTS `role` (
  `role_id` int NOT NULL AUTO_INCREMENT,
  `level_id` int NOT NULL,
  `modul_id` int NOT NULL,
  `lihat` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL,
  `modifikasi` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hapus` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.role: ~33 rows (approximately)
INSERT INTO `role` (`role_id`, `level_id`, `modul_id`, `lihat`, `modifikasi`, `hapus`) VALUES
	(2, 1, 2, 'Y', 'Y', 'Y'),
	(5, 1, 5, 'Y', 'Y', 'Y'),
	(11, 1, 11, 'Y', 'Y', 'Y'),
	(13, 1, 13, 'Y', 'Y', 'Y'),
	(14, 1, 14, 'Y', 'Y', 'Y'),
	(16, 2, 2, 'Y', 'Y', 'Y'),
	(19, 2, 5, 'N', 'N', 'N'),
	(25, 2, 11, 'Y', 'N', 'N'),
	(27, 2, 13, 'N', 'N', 'N'),
	(28, 2, 14, 'N', 'N', 'N'),
	(29, 1, 3, 'Y', 'Y', 'Y'),
	(30, 3, 9, 'Y', 'Y', 'Y'),
	(31, 1, 6, 'Y', 'Y', 'Y'),
	(32, 1, 7, 'Y', 'Y', 'Y'),
	(33, 1, 8, 'Y', 'Y', 'Y'),
	(34, 1, 9, 'Y', 'Y', 'Y'),
	(35, 1, 10, 'Y', 'Y', 'Y'),
	(36, 3, 10, 'Y', 'Y', 'Y'),
	(37, 2, 7, 'N', 'N', 'N'),
	(38, 1, 1, 'Y', 'Y', 'Y'),
	(39, 1, 15, 'Y', 'Y', 'Y'),
	(40, 1, 16, 'Y', 'Y', 'Y'),
	(41, 1, 17, 'Y', 'Y', 'Y'),
	(42, 1, 18, 'Y', 'Y', 'Y'),
	(43, 1, 19, 'Y', 'Y', 'Y'),
	(44, 1, 20, 'Y', 'Y', 'Y'),
	(45, 1, 21, 'Y', 'Y', 'Y'),
	(46, 1, 22, 'Y', 'Y', 'Y'),
	(47, 1, 23, 'Y', 'Y', 'Y'),
	(48, 1, 24, 'Y', 'Y', 'Y'),
	(49, 1, 4, 'Y', 'Y', 'Y'),
	(50, 1, 25, 'Y', 'Y', 'Y'),
	(51, 1, 26, 'Y', 'Y', 'Y'),
	(52, 1, 27, 'Y', 'Y', 'Y');

-- Dumping structure for table absensi_sekolah_v.3.sanksi_pelanggaran
DROP TABLE IF EXISTS `sanksi_pelanggaran`;
CREATE TABLE IF NOT EXISTS `sanksi_pelanggaran` (
  `id` int NOT NULL AUTO_INCREMENT,
  `pegawai_id` int NOT NULL DEFAULT '0',
  `user_id` int DEFAULT NULL,
  `wali_murid` int DEFAULT NULL,
  `ditujukan` varchar(70) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kode_surat` varchar(70) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `perihal` varchar(70) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `keterangan` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `template` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `tanggal` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.sanksi_pelanggaran: ~0 rows (approximately)
INSERT INTO `sanksi_pelanggaran` (`id`, `pegawai_id`, `user_id`, `wali_murid`, `ditujukan`, `kode_surat`, `perihal`, `keterangan`, `template`, `tanggal`, `time`) VALUES
	(2, 12, 1, 6, 'Wali Murid', '01/SP/KS/XII/2025', 'Peringatan Pertama', '- Terbukti melakukan kejahatan', 'Dengan hormat,\r\nDengan ini kami sampaikan kepada Bapak/Ibu/Wali dari :\r\n\r\nNama  : {{nama_siswa}}\r\nKelas    : {{kelas}}\r\n\r\nSehubungan dengan sikap tidak disiplin dan pelanggaran terhadap tata tertib sekolah yang Siswa lakukan, maka dengan ini pihak sekolah memberikan surat peringatan {{peringatan}}. Bahwa siswa/siswi tersebut telah melakukan pelanggaran tata tertib berupa\r\n\r\n{{daftar_pelanggaran}}\r\n\r\nDengan surat peringatan ini diharapkan agar kiranya Bapak/Ibu/Wali lebih mengawasi kegiatan siswa baik dari segi sikap individu, sosial dan spiritual. Agar dikemudian hari siswa tidak mengulangi kesalahan yang sama dan atau kesalahan lainnya, sehingga tercipta perilaku siswa yang lebih baik.\r\n\r\nDemikian surat ini kami sampaikan, atas perhatiaanya saya ucapkan terimakasih.', '2025-12-11', '21:51:12');

-- Dumping structure for table absensi_sekolah_v.3.setting
DROP TABLE IF EXISTS `setting`;
CREATE TABLE IF NOT EXISTS `setting` (
  `site_id` int NOT NULL AUTO_INCREMENT,
  `site_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_sekolah` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kementrian` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `npsn` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `desa` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kecamatan` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kabupaten` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `propinsi` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kepala_sekolah` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nip_kepala_sekolah` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `site_phone` char(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `site_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `site_owner` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `site_logo` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `site_favicon` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `site_kop` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ttd_kepsek` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stempel` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `site_url` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `site_email` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gmail_host` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gmail_username` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gmail_password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gmail_port` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gmail_active` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `google_client_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `google_client_secret` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `google_client_active` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tipe_absen_siswa` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tipe_absen_pegawai` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tipe_absen_layar` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `timezone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `whatsapp_phone` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `whatsapp_token` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `secret_key` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `whatsapp_domain` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `whatsapp_tipe` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `whatsapp_template` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `whatsapp_active` enum('Y','N') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'N',
  PRIMARY KEY (`site_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.setting: ~0 rows (approximately)
INSERT INTO `setting` (`site_id`, `site_name`, `nama_sekolah`, `kementrian`, `npsn`, `desa`, `kecamatan`, `kabupaten`, `propinsi`, `kepala_sekolah`, `nip_kepala_sekolah`, `site_phone`, `site_address`, `site_owner`, `site_logo`, `site_favicon`, `site_kop`, `ttd_kepsek`, `stempel`, `site_url`, `site_email`, `gmail_host`, `gmail_username`, `gmail_password`, `gmail_port`, `gmail_active`, `google_client_id`, `google_client_secret`, `google_client_active`, `tipe_absen_siswa`, `tipe_absen_pegawai`, `tipe_absen_layar`, `timezone`, `whatsapp_phone`, `whatsapp_token`, `secret_key`, `whatsapp_domain`, `whatsapp_tipe`, `whatsapp_template`, `whatsapp_active`) VALUES
	(1, 'App. Sekolah V.3', 'SMAN 1 Bandar Lampung', 'KEMDIKBUD', '167513653', 'Tanjungkarang', 'Tanjungkarang Timur', 'Bandar Lampung', 'Lampung', 'S. Widodo, S.com', '38247324664', '083160901108', 'Jl. Jend. Sudirman No.41, Rw. Laut, Kec. Tanjungkarang Timur, Kota Bandar Lampung, Lampung 35213', 'Widodo', '68c5de6649a570.00310931.png', '68c5de7930a584.47887366.png', '68c5df0b040624.10893316.png', NULL, '68d199ed54cd60.64506895.png', 'http://localhost/Absensi-sekolah-V.3', 'swidodo.com@gmail.com', 'smtp.gmail.com', 'swidodo.com@gmail.com', 'cqpveixfqexoqfak', '465', 'N', '482205120603-hf6aqm1mgr29ubsi2qttcrmfhmm2uklb.apps.googleusercontent.com', '7EjMuD8XO88nR-5mtqYhh4Y3', 'Y', 'qrcode', 'selfie', 'qrcode', 'Asia/Jakarta', '6285231843379', 'Dv50Gu50KBD1KduYw5Zr6cz3fOluvZdecShTJqddhx0gHoZgX8ocJdl', 'Am0OtShp', 'https://tegal.wablas.com/api/v2/send-message', 'POST', 'Assalamualaikum wr wb, Bapak/Ibu Kami  dari Perusahaan Menginformasikan bahwa :\r\n\r\nNama: {{nama}}\r\nHari/Tanggal: {{tanggal}}\r\n\r\n=========================\r\nTelah {{tipe}} Sekolah \r\nJam Sekolah : {{jam_sekolah}}\r\nJam Absen : {{jam_absen}}\r\nStatus : {{status}}\r\n=========================\r\nLokasi :  {{lokasi}}\r\n\r\nTerimakasih, Wassalamualaikum wr wb\r\nHormat kami,\r\nS-widodo.com', 'Y');

-- Dumping structure for table absensi_sekolah_v.3.slider
DROP TABLE IF EXISTS `slider`;
CREATE TABLE IF NOT EXISTS `slider` (
  `slider_id` int NOT NULL AUTO_INCREMENT,
  `slider_nama` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slider_url` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `foto` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`slider_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.slider: ~2 rows (approximately)
INSERT INTO `slider` (`slider_id`, `slider_nama`, `slider_url`, `foto`, `active`) VALUES
	(1, 'Slider 1', '#', '2022-11-29-1669693034.jpg', 'Y'),
	(3, 'SLIDER 2', '#', 'slider-2024-11-22-1732260994.jpg', 'Y');

-- Dumping structure for table absensi_sekolah_v.3.tahun_ajaran
DROP TABLE IF EXISTS `tahun_ajaran`;
CREATE TABLE IF NOT EXISTS `tahun_ajaran` (
  `tahun_ajaran_id` int NOT NULL AUTO_INCREMENT,
  `tahun_ajaran` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`tahun_ajaran_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.tahun_ajaran: ~0 rows (approximately)
INSERT INTO `tahun_ajaran` (`tahun_ajaran_id`, `tahun_ajaran`) VALUES
	(1, '2025/2026');

-- Dumping structure for table absensi_sekolah_v.3.template_surat
DROP TABLE IF EXISTS `template_surat`;
CREATE TABLE IF NOT EXISTS `template_surat` (
  `id` int NOT NULL AUTO_INCREMENT,
  `kode` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `template` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `tipe` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.template_surat: ~0 rows (approximately)
INSERT INTO `template_surat` (`id`, `kode`, `template`, `tipe`, `date`) VALUES
	(2, 'SP', 'Dengan hormat,\r\nDengan ini kami sampaikan kepada Bapak/Ibu/Wali dari :\r\n\r\nNama  : {{nama_siswa}}\r\nKelas    : {{kelas}}\r\n\r\nSehubungan dengan sikap tidak disiplin dan pelanggaran terhadap tata tertib sekolah yang Siswa lakukan, maka dengan ini pihak sekolah memberikan surat peringatan {{peringatan}}. Bahwa siswa/siswi tersebut telah melakukan pelanggaran tata tertib berupa\r\n\r\n{{daftar_pelanggaran}}\r\n\r\nDengan surat peringatan ini diharapkan agar kiranya Bapak/Ibu/Wali lebih mengawasi kegiatan siswa baik dari segi sikap individu, sosial dan spiritual. Agar dikemudian hari siswa tidak mengulangi kesalahan yang sama dan atau kesalahan lainnya, sehingga tercipta perilaku siswa yang lebih baik.\r\n\r\nDemikian surat ini kami sampaikan, atas perhatiaanya saya ucapkan terimakasih.', 'pelanggaran', '2025-12-11');

-- Dumping structure for table absensi_sekolah_v.3.user
DROP TABLE IF EXISTS `user`;
CREATE TABLE IF NOT EXISTS `user` (
  `user_id` int NOT NULL AUTO_INCREMENT,
  `nisn` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rfid` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `descriptor` text COLLATE utf8mb4_unicode_ci,
  `email` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nama_lengkap` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tempat_lahir` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tanggal_lahir` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jenis_kelamin` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kelas` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tahun_ajaran` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lokasi` int DEFAULT NULL,
  `alamat` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `telp` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tanggal_registrasi` datetime NOT NULL,
  `tanggal_login` datetime NOT NULL,
  `ip` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `browser` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active` enum('Y','N') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Y',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.user: ~2 rows (approximately)
INSERT INTO `user` (`user_id`, `nisn`, `rfid`, `descriptor`, `email`, `password`, `nama_lengkap`, `tempat_lahir`, `tanggal_lahir`, `jenis_kelamin`, `kelas`, `tahun_ajaran`, `lokasi`, `alamat`, `telp`, `avatar`, `tanggal_registrasi`, `tanggal_login`, `ip`, `browser`, `status`, `active`) VALUES
	(1, '123456789', '', '[-0.11816569417715073,0.10250844061374664,0.13626523315906525,-0.05598965659737587,-0.09313598275184631,-0.03940455988049507,-0.018963012844324112,-0.0640016570687294,0.17214645445346832,-0.0984695702791214,0.28105854988098145,0.01735229603946209,-0.15669816732406616,-0.17050981521606445,0.03082149475812912,0.16670431196689606,-0.16345511376857758,-0.1314324140548706,-0.10474353283643723,-0.06628827005624771,0.07596714794635773,0.007740030065178871,0.0852702334523201,-0.06900535523891449,-0.1318916380405426,-0.4437061548233032,-0.06766316294670105,-0.08412966877222061,0.06987398862838745,-0.07427749037742615,0.015012114308774471,-0.05278591439127922,-0.2637353539466858,-0.05848431959748268,-0.013530174270272255,0.08515272289514542,-0.05047798156738281,-0.06091295927762985,0.13164979219436646,-0.03888160362839699,-0.20868824422359467,-0.007755863945931196,0.006268796510994434,0.14996139705181122,0.1775507926940918,0.08642510324716568,0.04323990270495415,-0.10023219138383865,0.10378730297088623,-0.1697121411561966,0.0954897478222847,0.10193511843681335,0.049219563603401184,0.036976221948862076,0.05098079890012741,-0.05914802476763725,0.03560274839401245,0.10029309242963791,-0.187412828207016,-0.018467038869857788,0.05420975387096405,-0.05029939115047455,-0.11991120874881744,-0.019923057407140732,0.19998888671398163,0.09209023416042328,-0.08175978064537048,-0.1557212471961975,0.1609887033700943,-0.1192391961812973,-0.022758938372135162,0.05259784311056137,-0.10979224741458893,-0.1482335925102234,-0.27815186977386475,0.027042139321565628,0.42448902130126953,0.029936091974377632,-0.21358977258205414,-0.028091048821806908,-0.07943353056907654,0.017517631873488426,0.09661293774843216,0.07969275861978531,-0.04007965698838234,0.017235662788152695,-0.13042987883090973,0.03164656087756157,0.2007368505001068,-0.07024528831243515,-0.0317239910364151,0.22377406060695648,0.01706855371594429,0.060490310192108154,0.013512960635125637,0.02014949917793274,-0.06673336029052734,0.035302482545375824,-0.11455098539590836,-0.056770943105220795,0.11763602495193481,-0.0036693578585982323,-0.0763319656252861,0.06937889754772186,-0.15383979678153992,0.15852797031402588,0.01855173334479332,0.01379459910094738,0.050622761249542236,-0.04878276586532593,-0.07703787088394165,-0.11299174278974533,0.09919463098049164,-0.17250663042068481,0.22230090200901031,0.22644798457622528,0.008215803653001785,0.1604904681444168,0.09255713224411011,0.06146787852048874,0.009746566414833069,-0.033272698521614075,-0.19908897578716278,-0.03683739900588989,0.03712889552116394,-0.04074189066886902,0.04500341787934303,0.007804779335856438]', 'swidodo.com@gmail.com', '$2y$10$j.DCKRGWx713W1BY3.34deMT4quqWdINm1aIr0ekD33WbGo7xmOuW', 'Siswa Widodo', '-', '1970-01-01', 'Laki-laki', 'IX-A', '2025/2026', 2, 'Bandar Lampung, lampung', '6283160901108', 'avatar_68ff042ed998b1.50387249.jpg', '2025-10-12 17:39:09', '2026-03-03 17:46:17', '::1', 'Google Chrome 141.0.0.0', 'Online', 'Y'),
	(2, '3453409', '898080', NULL, 'Intan@gmail.com', '$2y$10$T5SVbGgRN3ow/gDAv4bb.OLFc/Ueyt43Ng9A8SQ4pCrhuX3tLTegS', 'Intan', 'Kudus', '2000-08-07', 'Laki-laki', 'IX-A', '2025/2026', 2, 'Lampung', '6283160901108', NULL, '2025-11-14 18:06:39', '2025-11-14 18:06:39', '127.0.0.1', 'Google Chrome 142.0.0.0', 'Offline', 'Y');

-- Dumping structure for table absensi_sekolah_v.3.wali_murid
DROP TABLE IF EXISTS `wali_murid`;
CREATE TABLE IF NOT EXISTS `wali_murid` (
  `wali_murid_id` int NOT NULL AUTO_INCREMENT,
  `nama_lengkap` varchar(70) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(70) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tempat_lahir` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jenis_kelamin` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `telp` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nisn` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nama_siswa` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alamat` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `avatar` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'avatar.jpg',
  `tanggal_registrasi` datetime NOT NULL,
  `tanggal_login` timestamp NOT NULL,
  `ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `browser` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`wali_murid_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.wali_murid: ~2 rows (approximately)
INSERT INTO `wali_murid` (`wali_murid_id`, `nama_lengkap`, `email`, `password`, `tempat_lahir`, `jenis_kelamin`, `telp`, `nisn`, `nama_siswa`, `alamat`, `avatar`, `tanggal_registrasi`, `tanggal_login`, `ip`, `browser`, `status`) VALUES
	(5, 'Widodo', 'swidodo.com@gmail.com', '$2y$10$V7IchcaK/8X/5itaYEaEWOxLtRARHmQ.938xlF/07V1w.mH2kz0PW', 'Kudus', 'Laki-laki', '6283160901108', '123456789', 'Siswa Widodo', 'Bandar Lampung', 'avatar.jpg', '2025-09-10 17:18:42', '2025-12-15 05:48:31', '::1', 'Google Chrome 139.0.0.0', 'Online'),
	(6, 'Wali Murid', 'swidodo2.com@gmail.com', '123456', NULL, NULL, NULL, '123456789', 'QWwewiu', NULL, 'avatar.jpg', '2025-10-13 03:28:03', '2025-10-12 20:28:03', '::1', 'Google Chrome 141.0.0.0', 'Offline');

-- Dumping structure for table absensi_sekolah_v.3.whatsapp_pesan
DROP TABLE IF EXISTS `whatsapp_pesan`;
CREATE TABLE IF NOT EXISTS `whatsapp_pesan` (
  `whatsapp_pesan_id` int NOT NULL AUTO_INCREMENT,
  `penerima` varchar(70) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tujuan` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pesan` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `date` date NOT NULL,
  `time` time NOT NULL,
  PRIMARY KEY (`whatsapp_pesan_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table absensi_sekolah_v.3.whatsapp_pesan: ~0 rows (approximately)

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
