SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `u4595895_demospp` -- SET GLOBAL FOREIGN_KEY_CHECKS = 0; CREATE TABLE `angsurantoko` ( `id_angsurantoko` varchar(10) NOT NULL, `id_hutangtoko` varchar(10) NOT NULL, `tanggal` date NOT NULL, `angsuran` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO angsurantoko VALUES ("AP001","HT001","2022-06-09","10000"); CREATE TABLE `bulan` ( `idBulan` varchar(15) NOT NULL DEFAULT '0', `nmBulan` varchar(25) DEFAULT NULL, `urutan` int(2) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO bulan VALUES ("1","Januari","7"); CREATE TABLE `hari` ( `id` int(11) NOT NULL, `nmHari` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; INSERT INTO hari VALUES ("1","Senin"), ("2","Selasa"), ("3","Rabu"), ("4","Kamis"), ("5","Jumat"), ("6","Sabtu"); CREATE TABLE `hutangtoko` ( `id_hutangtoko` varchar(10) NOT NULL, `hutangke` varchar(50) NOT NULL, `tanggal` date NOT NULL, `ket` varchar(100) NOT NULL, `nominal` int(11) NOT NULL, `sisa` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=COMPACT; CREATE TABLE `identitas` ( `npsn` varchar(8) NOT NULL, `nmSekolah` varchar(100) DEFAULT NULL, `alamat` varchar(255) DEFAULT NULL, `kabupaten` varchar(100) NOT NULL, `propinsi` varchar(100) NOT NULL, `nipKepsek` varchar(200) DEFAULT NULL, `nmKepsek` varchar(100) DEFAULT NULL, `serverKey` varchar(200) DEFAULT NULL, `clientKey` varchar(200) DEFAULT NULL, `link` varchar(200) NOT NULL, `biaya_admin` int(11) DEFAULT NULL, `link_one_sender` varchar(100) NOT NULL, `token` varchar(100) NOT NULL, `wa` varchar(100) NOT NULL, `idnya` int(11) NOT NULL, `statusWa` enum('Y','T') NOT NULL, `skl` varchar(100) NOT NULL, `tgl_skl` date NOT NULL, `nmBendahara` varchar(100) DEFAULT NULL, `logo_kiri` varchar(255) DEFAULT NULL, `logo_kanan` varchar(100) NOT NULL, `tema` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO identitas VALUES ("10700295","SMP QUEEN AL FALAH 2","Ds. Ploso Rt/Rw 02/03 Kec. Mojo Kab. Kediri - 64162","Kediri","Jawa Timur ","-","M. Khirzudin Akhim, S.Pd.","Mid-server-nu8DQyBwRpo1o7uPC3B7tlmb","Mid-client-QFv7_9nHU3MlOwdb","https://app.midtrans.com/snap/snap.js","500","https://wa.queenalfalah.com/send-message","dTOTFlcS0Udg02vOFTuHdBvfZZpsAx","6285173338393","0","Y","085.55/Ma.28.05.0067/PP.01.7.1/05/2021","2022-03-07","Faiqoh Al Jihan","123-150x150.png","tutwuri.jpg","red"); CREATE TABLE `jam` ( `idJam` int(11) NOT NULL, `nmJam` varchar(200) NOT NULL, `dariJam` time NOT NULL, `sampaiJam` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; INSERT INTO jam VALUES ("1","Jam Ke - 1","07:00:00","08:30:00"), ("2","Jam Ke - 2","08:30:00","09:30:00"), ("3","Jam Ke - 3 ","10:00:00","11:30:00"), ("4","Jam Ke - 4 ","11:00:00","12:30:00"), ("5","Jam Ke - 5","12:30:00","14:00:00"); CREATE TABLE `jenis_bayar` ( `idJenisBayar` int(10) NOT NULL AUTO_INCREMENT, `idPosBayar` int(5) DEFAULT NULL, `idTahunAjaran` int(5) DEFAULT NULL, `nmJenisBayar` varchar(100) DEFAULT NULL, `tipeBayar` enum('bulanan','bebas') DEFAULT 'bulanan', PRIMARY KEY (`idJenisBayar`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO jenis_bayar VALUES ("1","12","2","Administrasi Kelas 7 Semester 1","bebas"), ("2","12","2","Administrasi Kelas 7 Semester 2","bebas"), ("3","12","2","Administrasi Kelas 8 Semester 1","bebas"), ("4","12","1","Administrasi Kelas 7 Semester 1","bebas"), ("5","12","1","Administrasi Kelas 7 Semester 2","bebas"), ("6","12","1","Administrasi Kelas 8 Semester 1","bebas"), ("7","12","1","Administrasi Kelas 8 Semester 2","bebas"), ("8","12","1","Administrasi Kelas 9 Semester 1","bebas"), ("9","12","3","Administrasi Kelas 7 Semester 1","bebas"); CREATE TABLE `jenis_pengeluaran` ( `idPengeluaran` int(11) NOT NULL AUTO_INCREMENT, `nmPengeluaran` varchar(100) NOT NULL, `jenis` enum('Masuk','Keluar') NOT NULL, PRIMARY KEY (`idPengeluaran`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO jenis_pengeluaran VALUES ("1","Konsumsi","Keluar"); CREATE TABLE `jurnal_umum` ( `id` int(50) NOT NULL, `idPengeluaran` int(11) DEFAULT NULL, `tgl` date DEFAULT NULL, `ket` varchar(100) DEFAULT NULL, `penerimaan` int(10) DEFAULT 0, `pengeluaran` int(10) DEFAULT 0, `nama` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; CREATE TABLE `kas` ( `kode` int(11) NOT NULL, `keterangan` varchar(300) NOT NULL, `idKelas` int(50) NOT NULL, `tgl` date NOT NULL, `jumlah` int(10) NOT NULL, `jenis` varchar(20) NOT NULL, `keluar` int(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; CREATE TABLE `kelas_siswa` ( `idKelas` int(5) NOT NULL AUTO_INCREMENT, `nmKelas` varchar(20) DEFAULT NULL, `ketKelas` varchar(255) DEFAULT NULL, PRIMARY KEY (`idKelas`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO kelas_siswa VALUES ("1","VII A","Kelas 7"), ("2","VII B","Kelas 7"), ("3","VII C","Kelas 7"), ("4","VII D","Kelas 7"), ("5","VII E","Kelas 7"), ("6","VII F","Kelas 7"), ("7","VII G","Kelas 7"), ("8","VII H","Kelas 7"), ("9","VIII A","Kelas 8"), ("10","VIII B","Kelas 8"), ("11","VIII C","Kelas 8"), ("12","VIII D","Kelas 8"); CREATE TABLE `log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(200) NOT NULL, `statusKlik` enum('0','1') DEFAULT '0', `ket` varchar(255) DEFAULT NULL, `waktu` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; INSERT INTO log VALUES ("1","Administrator","0","Melakukan transaksi Rp 3.804.000 untuk siswa a.n ABID ASYKURILLAH","2023-07-20 22:04:32"), ("2","Administrator","0","Melakukan transaksi Rp 3.804.000 untuk siswa a.n ANUGRAH ACHMAD ALHIKAM","2023-07-20 22:08:29"), ("3","Administrator","0","Melakukan transaksi Rp 3.804.000 untuk siswa a.n BAYU OCTA PRATAMA","2023-07-20 22:11:00"), ("4","Administrator","0","Melakukan transaksi Rp 3.804.000 untuk siswa a.n BAYU OCTA PRATAMA","2023-07-20 22:12:31"), ("5","Administrator","0","Melakukan transaksi Rp 10.000 untuk siswa a.n AGHNIYA` WISNU NUGROHO JATI","2023-07-20 22:32:39"), ("6","Administrator","0","Melakukan transaksi Rp 1.000 untuk siswa a.n AGHNIYA` WISNU NUGROHO JATI","2023-07-20 22:34:46"), ("7","Administrator","0","Melakukan transaksi Rp 3.213 untuk siswa a.n AGHNIYA` WISNU NUGROHO JATI","2023-07-20 22:36:09"), ("8","Administrator","0","Melakukan transaksi Rp 1.000 untuk siswa a.n AGHNIYA` WISNU NUGROHO JATI","2023-07-20 22:43:03"), ("9","Administrator","0","Melakukan transaksi Rp 1.388.787 untuk siswa a.n AGHNIYA` WISNU NUGROHO JATI","2023-07-20 22:46:44"), ("10","Administrator","0","Melakukan transaksi Rp 1.404.000 untuk siswa a.n AGHNIYA` WISNU NUGROHO JATI","2023-07-21 21:36:41"), ("11","Administrator","0","Melakukan transaksi Rp 1.000.000 untuk siswa a.n DEDE HILMANSYAH","2023-07-22 11:34:13"), ("12","Administrator","0","Melakukan transaksi Rp 100.000 untuk siswa a.n DEDE HILMANSYAH","2023-07-22 11:45:02"), ("13","Administrator","0","Melakukan transaksi Rp 1.000 untuk siswa a.n DEDE HILMANSYAH","2023-07-22 11:50:33"), ("14","Administrator","0","Melakukan transaksi Rp 303.000 untuk siswa a.n DEDE HILMANSYAH","2023-07-22 11:57:07"), ("15","Administrator","0","Melakukan transaksi Rp 1.000.000 untuk siswa a.n AGHNIYA` WISNU NUGROHO JATI","2023-07-22 12:15:15"), ("16","Administrator","0","Melakukan transaksi Rp 1.000.000 untuk siswa a.n AHMAD NIZAR MAULANA","2023-07-22 12:16:50"), ("17","Administrator","0","Melakukan transaksi Rp 404.000 untuk siswa a.n AGHNIYA` WISNU NUGROHO JATI","2023-07-22 12:17:16"), ("18","Administrator","0","Melakukan transaksi Rp 1.404.000 untuk siswa a.n AGHNIYA` WISNU NUGROHO JATI","2023-07-22 22:01:58"), ("19","Administrator","0","Melakukan transaksi Rp 1.404.000 untuk siswa a.n AGHNIYA` WISNU NUGROHO JATI","2023-07-22 22:02:33"), ("20","Administrator","0","Melakukan transaksi Rp 1.404.000 untuk siswa a.n AGHNIYA` WISNU NUGROHO JATI","2023-07-22 22:02:56"), ("21","Administrator","0","Melakukan transaksi Rp 1.404.000 untuk siswa a.n AGHNIYA` WISNU NUGROHO JATI","2023-07-22 22:04:49"), ("22","Administrator","0","Melakukan transaksi Rp 1.404.000 untuk siswa a.n AGHNIYA` WISNU NUGROHO JATI","2023-07-22 22:12:56"), ("23","Administrator","0","Melakukan transaksi Rp 111 untuk siswa a.n AGHNIYA` WISNU NUGROHO JATI","2023-07-22 22:13:22"), ("24","Administrator","0","Melakukan transaksi Rp 1.111 untuk siswa a.n AGHNIYA` WISNU NUGROHO JATI","2023-07-22 22:13:34"), ("25","Administrator","0","Melakukan transaksi Rp 24 untuk siswa a.n AGHNIYA` WISNU NUGROHO JATI","2023-07-22 22:14:23"), ("26","Administrator","0","Melakukan transaksi Rp 100.000 untuk siswa a.n AKBAR ILMI RAHMADANI","2023-08-09 11:28:36"); CREATE TABLE `menu` ( `idMenu` int(11) NOT NULL, `noMenu` int(11) DEFAULT NULL, `namaMenu` varchar(255) DEFAULT NULL, `iconMenu` varchar(100) DEFAULT NULL, `lokasiFileMenu` varchar(255) DEFAULT NULL, `ketMenu` varchar(255) DEFAULT NULL, `viewMenu` varchar(100) DEFAULT NULL, `level` varchar(25) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO menu VALUES ("1","0","Dashboard","fa fa-dashboard","admin/home_admin_row.php","Main Menu","home","Admin"), ("2","0","Kesiswaan","fa fa-users","-","Main Menu","-","Admin"), ("4","2","Kelas","fa fa-circle-o","admin/master_kelas.php","Sub Menu 1","kelas","Admin"), ("6","2","Siswa","fa fa-circle-o","admin/master_siswa.php","Sub Menu 1","siswa","Admin"), ("10","0","Master Guru","fa fa-suitcase","-","Main Menu","-","Admin"), ("12","10","Guru","fa fa-circle-o","admin/sease/master_guru.php","Sub Menu 1","guru","Admin"), ("13","0","Akademik","fa fa-graduation-cap","-","Main Menu","-","Admin"), ("14","13","Tahun Ajaran","fa fa-circle-o","admin/master_tahun.php","Sub Menu 1","tahun ajaran","Admin"), ("15","13","Kenaikan Kelas","fa fa-circle-o","admin/master_kenaikankelas.php","Sub Menu 1","kenaikankelas","Admin"), ("16","13","Kelulusan","fa fa-circle-o","admin/master_kelulusan.php","Sub Menu 1","kelulusan","Admin"), ("17","0","Keuangan","fa fa-money","-","Main Menu","-","Admin"), ("18","17","Pembayaran Siswa","fa fa-circle-o","admin/keuangan_pembayaran.php","Sub Menu 1","pembayaran","Admin"), ("19","17","Setting Pembayaran","fa fa-circle-o","-","Sub Menu 1","-","Admin"), ("21","19","Pos Bayar","fa fa-circle-o","admin/master_posbayar.php","Sub Menu 2","posbayar","Admin"), ("22","19","Jenis Bayar","fa fa-circle-o","admin/master_jenisbayar.php","Sub Menu 2","jenisbayar","Admin"), ("25","17","Tabungan","fa fa-circle-o","admin/com_transaksi/transaksi.php","Sub Menu 1","transaksi\n\n","Admin"), ("26","17","Kas & Bank","fa fa-circle-o","-","Sub Menu 1","-","Admin"), ("27","26","Saldo Awal","fa fa-circle-o","admin/master_saldoawal.php","Sub Menu 2","saldo awal","Admin"), ("28","26","Kas Keluar","fa fa-circle-o","admin/master_kaskeluar.php","Sub Menu 2","kas keluar","Admin"), ("29","26","Kas Masuk","fa fa-circle-o","admin/master_kasmasuk.php","Sub Menu 2","kas masuk","Admin"), ("30","26","Transfer Kas","fa fa-circle-o","admin/master_transferkas.php","Sub Menu 2","transfer kas","Admin"), ("31","26","Rekonsiliasi Bank","fa fa-circle-o","admin/master_rekonsiliasibank.php","Sub Menu 2","rekonsiliasi bank","Admin"), ("32","17","Penggajian","fa fa-circle-o","-","Sub Menu 1","-","Admin"), ("33","32","Setting Gaji","fa fa-circle-o","admin/master_settinggaji.php","Sub Menu 2","setting gaji","Admin"), ("34","32","Slip Gaji","fa fa-circle-o","admin/master_slipgaji.php","Sub Menu 2","slip gaji","Admin"), ("35","17","Hutang","fa fa-circle-o","-","Sub Menu 1","-","Admin"), ("37","35","Setting Hutang","fa fa-circle-o","admin/master_settinghutang.php","Sub Menu 2","setting hutang","Admin"), ("38","35","Bayar Hutang","fa fa-circle-o","admin/master_bayarhutang.php","Sub Menu 2","bayar hutang","Admin"), ("39","17","Kirim Tagihan","fa fa-circle-o","admin/master_kirimtagihan.php","Sub Menu 1","kirimtagihan","Admin"), ("40","0","Laporan","fa fa-file-text-o","-","Main Menu","-","Admin"), ("41","40","Lap. Pembayaran","fa fa-circle-o","-","Sub Menu 1","-","Admin"), ("42","41","Per Kelas","fa fa-circle-o","admin/master_laporanperkelas.php","Sub Menu 2","laporan perkelas","Admin"), ("43","41","Per Tanggal","fa fa-circle-o","admin/master_laporanpertanggal.php","Sub Menu 2","laporan pertanggal","Admin"), ("44","41","Tagihan Santri","fa fa-circle-o","admin/master_laporantagihansiswa.php","Sub Menu 2","laporan tagihan santri","Admin"), ("45","41","Rekap Pembayaran","fa fa-circle-o","admin/master_laporanrekappembayaran.php","Sub Menu 2","laporan rekap pembayaran","Admin"), ("46","40","Lap. Keuangan","fa fa-circle-o","-","Sub Menu 1","-","Admin"), ("47","46","Lap. Jurnal (Kas)","fa fa-circle-o","admin/master_laporanjurnal.php","Sub Menu 2","laporan kas tunai","Admin"), ("48","46","Lap. Kas Bank","fa fa-circle-o","admin/master_laporankasbank.php","Sub Menu 2","laporan kas bank","Admin"), ("49","46","Lap. Neraca","fa fa-circle-o","admin/master_laporanneraca.php","Sub Menu 2","laporan neraca","Admin"), ("50","40","Lap. Tabungan"," \n\nfa fa-circle-o","admin/master_laporantabungan.php","Sub Menu 1","laporan tabungan","Admin"), ("51","0","Pengaturan","fa fa-gear","-","Main Menu","-","Admin"), ("52","51","Identitas Sekolah","fa fa-circle-o","admin/master_identitassekolah.php","Sub Menu 1","identitas","Admin"), ("53","51","Bulan","fa fa-circle-o","admin/master_bulan.php","Sub Menu 1","bulan","Admin"), ("54","51","Informasi","fa fa-circle-o","admin/master_informasi.php","Sub Menu 1","informasi","Admin"), ("55","51","Manajemen Pengguna","fa fa-circle-o","admin/master_pengguna.php","Sub Menu 1","pengguna","Admin"), ("56","51","Pemeliharaan","fa fa-circle-o","admin/master_pemeliharaan.php","Sub Menu 1","pemeliharaan","Admin"), ("57","51","Logs Transaksi","fa fa-circle-o","admin/master_logtransaksi.php","Sub Menu 1","logs transaksi","Admin"), ("58","0","Dashboard","fa fa-dashboard","siswa/home_siswa.php","Main Menu","dashboard","Siswa"), ("59","0","Profil","fa fa-user","siswa/master_siswa.php","Main Menu","profil","Siswa"), ("60","0","Pembayaran","fa fa-money","siswa/master_pembayaran.php","Main Menu","cek pembayaran","Siswa"), ("61","9","Perizinan","fa fa-circle-o","admin/master_perizinan.php","Sub Menu 2","perizinan","Admin"), ("62","9","Pelanggaran","fa fa-circle-o","admin/master_pelanggaran.php","Sub Menu 2","pelanggaran","Admin"), ("63","40","Lap. Kesehatan","fa fa-circle-o","admin/master_laporankesehatan.php","Sub Menu 1","laporan kesehatan","Admin"), ("64","40","Lap. Konseling","fa fa-circle-o","-","Sub Menu 1","-","Admin"), ("65","64","Lap. Perizinan","fa fa-circle-o","admin/master_laporanperizinan.php","Sub Menu 2","laporan perizinan","Admin"), ("66","64","Lap. Pelanggaran","fa fa-circle-o","admin/master_laporanpelanggaran.php","Sub Menu 2","laporan pelanggaran","Admin"), ("67","46","Lap. Kas Kasir","fa fa-circle-o","admin/master_laporankaskasir.php","Sub Menu 2","laporan kas kasir","Admin"); CREATE TABLE `payment` ( `idPayment` int(11) NOT NULL AUTO_INCREMENT, `tglPayment` datetime NOT NULL, `paymentOrder` varchar(100) NOT NULL, `idSiswa` int(11) NOT NULL, `jenisTagihan` varchar(20) NOT NULL, `idTagihan` int(11) NOT NULL, `nominal` int(10) NOT NULL, `tipePayment` varchar(100) DEFAULT NULL, `noPayment` varchar(100) DEFAULT NULL, `status` varchar(11) NOT NULL, PRIMARY KEY (`idPayment`) ) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; INSERT INTO payment VALUES ("3","2022-12-08 11:44:44","","639","Bebas","801","188500","","",""), ("7","2023-01-20 05:53:00","","162","Bebas","1256","0","","",""), ("9","2023-02-02 12:58:49","","118","Bebas","421","10000","","",""), ("10","2023-02-02 12:59:00","","118","Bebas","1212","728000","","",""), ("12","2023-03-07 20:35:36","","678","Bebas","1576","1238000","","",""), ("13","2023-03-08 09:33:04","","137","Bebas","489","1020000","","",""), ("15","2023-03-08 09:35:18","","137","Bebas","602","1402000","","",""), ("16","2023-03-08 09:35:34","","137","Bebas","1231","1128000","","",""), ("17","2023-03-08 10:19:39","","724","Bebas","1679","1238000","","",""), ("20","2023-03-13 11:09:30","","447","Bebas","1070","1540000","","",""), ("21","2023-03-14 10:53:56","","580","Bebas","1671","1238000","","",""), ("22","2023-03-16 13:59:42","","360","Bebas","983","0","","",""), ("23","2023-03-17 15:19:08","","725","Bebas","770","0","","",""), ("24","2023-05-04 10:57:31","INV20230504105718","219","Bebas","1281","10000","qris","https://api.midtrans.com/v2/qris/shopeepay/sppq_976674a8-ead0-4b02-816f-9c656942e7b6/qr-code","pending"), ("27","2023-05-06 08:05:14","","101","Bebas","583","1082000","","",""), ("28","2023-05-06 08:06:32","","101","Bebas","1195","1128000","","",""); CREATE TABLE `pos_bayar` ( `idPosBayar` int(5) NOT NULL AUTO_INCREMENT, `nmPosBayar` varchar(100) DEFAULT NULL, `ketPosBayar` varchar(100) DEFAULT NULL, PRIMARY KEY (`idPosBayar`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO pos_bayar VALUES ("12","SMA","SMA Queen Al Falah"); CREATE TABLE `rb_absen` ( `kode_kehadiran` varchar(5) NOT NULL, `nama_kehadiran` varchar(20) NOT NULL, `nilai` int(2) NOT NULL, `bobot` varchar(5) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO rb_absen VALUES ("I","Izin","1","0.5"), ("S","Sakit","1","0.5"); CREATE TABLE `rb_absensi_guru` ( `id_absensi_guru` int(5) NOT NULL, `nip` varchar(20) NOT NULL, `kode_kehadiran` varchar(5) NOT NULL, `tanggal` date NOT NULL, `waktu_input` timestamp NOT NULL DEFAULT current_timestamp(), `nama` varchar(200) NOT NULL, `ukuran` varchar(100) NOT NULL, `tipe` varchar(100) NOT NULL, `latlng` varchar(100) NOT NULL, `address` varchar(200) NOT NULL, `keterangan` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; CREATE TABLE `rb_absensi_setting` ( `id` int(16) NOT NULL, `type` varchar(60) NOT NULL, `value` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; INSERT INTO rb_absensi_setting VALUES ("8","waktuSetting","17:15,19:00"); CREATE TABLE `rb_absensi_siswa` ( `id_absensi_siswa` int(5) NOT NULL, `kodejdwl` int(11) NOT NULL, `nisn` varchar(20) NOT NULL, `idKelas` int(15) NOT NULL, `kode_kehadiran` varchar(5) NOT NULL, `tanggal` date NOT NULL, `waktu_input` datetime NOT NULL, `nama` varchar(100) NOT NULL, `ukuran` varchar(100) NOT NULL, `tipe` varchar(100) NOT NULL, `latlng` varchar(100) NOT NULL, `address` varchar(200) NOT NULL, `keterangan` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO rb_absensi_siswa VALUES ("100","38","135649671","1","H","2022-08-10","2022-08-10 17:34:43","","","","","",""), ("99","38","0129700638","1","H","2022-08-10","2022-08-10 17:34:43","","","","","",""), ("98","38","3083268826","1","H","2022-08-10","2022-08-10 17:34:43","","","","","",""), ("97","38","20190007","1","H","2022-08-10","2022-08-10 17:34:43","","","","","",""), ("96","38","20190006","1","H","2022-08-10","2022-08-10 17:34:43","","","","","",""), ("95","38","20190005","1","H","2022-08-10","2022-08-10 17:34:43","","","","","",""), ("94","38","20190004","1","H","2022-08-10","2022-08-10 17:34:43","","","","","",""), ("93","38","3116747886","1","H","2022-08-10","2022-08-10 17:34:43","","","","","",""), ("92","38","20190003","1","H","2022-08-10","2022-08-10 17:34:43","","","","","",""), ("91","38","20190002","1","I","2022-08-10","2022-08-10 17:34:34","","","","","",""), ("90","37","3111259301","1","H","2022-08-01","2022-08-01 17:44:49","","","","","",""), ("89","37","0121670374","1","H","2022-08-01","2022-08-01 17:44:49","","","","","",""), ("86","37","3083268826","1","H","2022-08-01","2022-08-01 17:44:49","","","","","",""), ("87","37","0129700638","1","H","2022-08-01","2022-08-01 17:44:49","","","","","",""), ("88","37","135649671","1","H","2022-08-01","2022-08-01 17:44:49","","","","","",""), ("85","37","20190007","1","H","2022-08-01","2022-08-01 17:44:49","","","","","",""), ("84","37","20190006","1","H","2022-08-01","2022-08-01 17:44:49","","","","","",""), ("83","37","20190005","1","H","2022-08-01","2022-08-01 17:44:49","","","","","",""), ("82","37","20190004","1","H","2022-08-01","2022-08-01 17:44:49","","","","","",""), ("81","37","3116747886","1","H","2022-08-01","2022-08-01 17:44:49","","","","","",""), ("80","37","20190003","1","H","2022-08-01","2022-08-01 17:44:49","","","","","",""), ("79","37","20190002","1","H","2022-08-01","2022-08-01 17:44:49","","","","","",""), ("101","38","0121670374","1","H","2022-08-10","2022-08-10 17:34:43","","","","","",""), ("102","38","3111259301","1","H","2022-08-10","2022-08-10 17:34:43","","","","","",""), ("103","0","20190002","1","I","2022-08-10","2022-08-10 17:34:51","","","","","",""), ("104","0","20190003","1","H","2022-08-10","2022-08-10 17:34:53","","","","","",""), ("105","0","3116747886","1","H","2022-08-10","2022-08-10 17:34:53","","","","","",""), ("106","0","20190004","1","H","2022-08-10","2022-08-10 17:34:53","","","","","",""), ("107","0","20190005","1","H","2022-08-10","2022-08-10 17:34:53","","","","","",""), ("108","0","20190006","1","H","2022-08-10","2022-08-10 17:34:53","","","","","",""), ("109","0","20190007","1","H","2022-08-10","2022-08-10 17:34:53","","","","","",""), ("110","0","3083268826","1","H","2022-08-10","2022-08-10 17:34:53","","","","","",""), ("111","0","0129700638","1","H","2022-08-10","2022-08-10 17:34:53","","","","","",""), ("112","0","135649671","1","H","2022-08-10","2022-08-10 17:34:53","","","","","",""), ("113","0","0121670374","1","H","2022-08-10","2022-08-10 17:34:53","","","","","",""), ("114","0","3111259301","1","H","2022-08-10","2022-08-10 17:34:53","","","","","",""), ("115","37","20190002","1","H","2022-08-14","2022-08-14 17:59:24","","","","","",""), ("116","37","20190003","1","H","2022-08-14","2022-08-14 17:59:24","","","","","",""), ("117","37","20190004","1","H","2022-08-14","2022-08-14 17:59:24","","","","","",""), ("118","37","20190005","1","H","2022-08-14","2022-08-14 17:59:24","","","","","",""), ("119","37","20190006","1","H","2022-08-14","2022-08-14 17:59:24","","","","","",""), ("120","37","20190007","1","H","2022-08-14","2022-08-14 17:59:24","","","","","",""), ("121","37","1324","1","H","2022-08-14","2022-08-14 17:59:24","","","","","",""), ("122","37","20190002","1","H","2022-08-18","2022-08-18 15:45:13","","","","","",""), ("123","37","20190003","1","H","2022-08-18","2022-08-18 15:45:13","","","","","",""), ("124","37","20190004","1","H","2022-08-18","2022-08-18 15:45:13","","","","","",""), ("125","37","20190005","1","H","2022-08-18","2022-08-18 15:45:13","","","","","",""), ("126","37","20190006","1","H","2022-08-18","2022-08-18 15:45:13","","","","","",""), ("127","37","20190007","1","H","2022-08-18","2022-08-18 15:45:13","","","","","",""), ("128","37","1324","1","H","2022-08-18","2022-08-18 15:45:13","","","","","",""), ("129","37","20190002","1","H","2022-08-30","2022-08-30 21:33:18","","","","","",""), ("130","37","20190004","1","H","2022-08-30","2022-08-30 21:33:18","","","","","",""), ("131","37","20190006","1","H","2022-08-30","2022-08-30 21:33:18","","","","","",""), ("132","37","1324","1","H","2022-08-30","2022-08-30 21:33:18","","","","","",""), ("133","37","20190003","1","H","2022-08-30","2022-08-30 21:33:18","","","","","",""), ("134","37","20190005","1","H","2022-08-30","2022-08-30 21:33:18","","","","","",""), ("135","37","20190007","1","H","2022-08-30","2022-08-30 21:33:18","","","","","",""); CREATE TABLE `rb_agama` ( `id_agama` int(5) NOT NULL, `nama_agama` varchar(100) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO rb_agama VALUES ("1","Islam"), ("2","Kristen"), ("3","Hindu"), ("4","Budha"); CREATE TABLE `rb_barang` ( `idBarang` int(10) NOT NULL, `nmBarang` varchar(100) NOT NULL, `jumlahBarang` int(10) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; INSERT INTO rb_barang VALUES ("1","Papan Tulis","0"); CREATE TABLE `rb_bk` ( `id_bk` int(10) NOT NULL, `hari` varchar(100) NOT NULL, `kode_kelas` varchar(100) NOT NULL, `nama_siswa` varchar(100) NOT NULL, `penindak` varchar(100) NOT NULL, `tanggal` date NOT NULL, `pelanggaran` text NOT NULL, `penyelesaian` text NOT NULL, `waktu_input` datetime NOT NULL, `users` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO rb_bk VALUES ("2","Senin","11","ALFAREL FERNANDA SAVA YUDISTIRA","DAVANSYAH MINDA ARDIAN","2022-01-31","Gak tauss","Cukur gigi","2022-01-31 14:45:38","admin"), ("3","Minggu","11","ALFAREL FERNANDA SAVA YUDISTIRA","DAVANSYAH MINDA ARDIAN","2022-02-06","Gak tau","Gak tau juga \n","2022-02-06 07:09:19",""); CREATE TABLE `rb_elearning` ( `id_elearning` int(10) NOT NULL, `id_kategori_elearning` int(5) NOT NULL, `kodejdwl` int(5) NOT NULL, `nama_file` varchar(255) NOT NULL, `link` varchar(200) NOT NULL, `file_upload` text NOT NULL, `tanggal_tugas` datetime NOT NULL, `tanggal_selesai` datetime NOT NULL, `keterangan` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO rb_elearning VALUES ("30","1","2","Video Pembelajaran","xxN-fXBnQqA","20220130205935-WhatsApp-Image-2021-01-23-at-23.28.28.jpeg","2022-01-30 20:59:01","2022-01-30 20:59:01","Pencak Silat"), ("34","2","2","COba","","20220311124719-Invoice-396.pdf","2022-12-11 12:47:09","2022-12-17 12:47:09","dsa"), ("33","1","2","COba","","20220310000457-PURCHASE ORDER-92680.pdf","2022-12-10 00:04:46","2022-12-17 00:04:46","sfda"), ("35","1","4","Bocil","","20220630211113-laporan_absen_300622020241.xls","2022-12-30 21:11:03","2022-12-30 21:11:03","PAgar"); CREATE TABLE `rb_elearning_jawab` ( `id_elearning_jawab` int(5) NOT NULL, `id_elearning` int(5) NOT NULL, `nisn` varchar(20) NOT NULL, `keterangan` text NOT NULL, `file_tugas` varchar(255) NOT NULL, `waktu` datetime NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO rb_elearning_jawab VALUES ("7","34","20190002","Halloo bujk","20220705210228-AKUN ADMIN.docx","2022-07-05 21:02:28"); CREATE TABLE `rb_forum_komentar` ( `id_forum_komentar` int(10) NOT NULL, `id_forum_topic` int(10) NOT NULL, `nisn_nip` varchar(20) NOT NULL, `isi_komentar` text NOT NULL, `waktu_komentar` datetime NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; CREATE TABLE `rb_forum_topic` ( `id_forum_topic` int(10) NOT NULL, `kodejdwl` int(10) NOT NULL, `judul_topic` varchar(255) NOT NULL, `isi_topic` text NOT NULL, `waktu` datetime NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; CREATE TABLE `rb_golongan` ( `id_golongan` int(5) NOT NULL, `nama_golongan` varchar(150) NOT NULL, `keterangan` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO rb_golongan VALUES ("1","IV/a","Golongan IV/a"); CREATE TABLE `rb_guru` ( `nip` varchar(30) NOT NULL, `password` varchar(255) NOT NULL, `nama_guru` varchar(150) NOT NULL, `id_jenis_kelamin` int(5) NOT NULL, `tempat_lahir` varchar(150) NOT NULL, `tanggal_lahir` date NOT NULL, `nik` varchar(50) NOT NULL, `idKelas` varchar(100) NOT NULL, `niy_nigk` varchar(50) NOT NULL, `nuptk` varchar(50) NOT NULL, `id_status_kepegawaian` int(5) NOT NULL, `id_jenis_ptk` int(5) NOT NULL, `pengawas_bidang_studi` varchar(150) NOT NULL, `id_agama` int(5) NOT NULL, `alamat_jalan` varchar(255) NOT NULL, `rt` varchar(5) NOT NULL, `rw` varchar(5) NOT NULL, `nama_dusun` varchar(100) NOT NULL, `desa_kelurahan` varchar(100) NOT NULL, `kecamatan` varchar(100) NOT NULL, `kode_pos` int(10) NOT NULL, `telepon` varchar(15) NOT NULL, `hp` varchar(15) NOT NULL, `email` varchar(150) NOT NULL, `tugas_tambahan` varchar(100) NOT NULL, `id_status_keaktifan` int(5) NOT NULL, `sk_cpns` varchar(150) NOT NULL, `tanggal_cpns` date NOT NULL, `sk_pengangkatan` varchar(150) NOT NULL, `tmt_pengangkatan` date NOT NULL, `lembaga_pengangkatan` varchar(150) NOT NULL, `id_golongan` int(5) NOT NULL, `keahlian_laboratorium` varchar(150) NOT NULL, `sumber_gaji` varchar(150) NOT NULL, `nama_ibu_kandung` varchar(100) NOT NULL, `id_status_pernikahan` int(5) NOT NULL, `nama_suami_istri` varchar(100) NOT NULL, `nip_suami_istri` varchar(30) NOT NULL, `pekerjaan_suami_istri` varchar(100) NOT NULL, `tmt_pns` date NOT NULL, `lisensi_kepsek` varchar(20) NOT NULL, `jumlah_sekolah_binaan` int(5) NOT NULL, `diklat_kepengawasan` varchar(20) NOT NULL, `mampu_handle_kk` varchar(20) NOT NULL, `keahlian_breile` varchar(20) NOT NULL, `keahlian_bahasa_isyarat` varchar(20) NOT NULL, `npwp` varchar(50) NOT NULL, `kewarganegaraan` varchar(50) NOT NULL, `foto` varchar(255) NOT NULL, `page_absen` enum('Y','T') NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; CREATE TABLE `rb_inv_keluar` ( `id` int(11) NOT NULL, `idBarang` int(11) NOT NULL, `tgl` date NOT NULL, `jumlahBarang` int(10) NOT NULL, `nmOrang` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; INSERT INTO rb_inv_keluar VALUES ("11","1","2022-02-06","100","Zaki Mubarok"), ("12","1","2022-02-06","20","Zaki Mubarok"), ("13","1","2022-02-06","30","Zaki Mubarok"); CREATE TABLE `rb_inv_masuk` ( `id` int(11) NOT NULL, `idBarang` int(11) NOT NULL, `tgl` date NOT NULL, `jumlahBarang` int(10) NOT NULL, `nmOrang` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; CREATE TABLE `rb_inventaris` ( `idInv` int(10) NOT NULL, `idKelas` int(11) NOT NULL, `nmBarang` varchar(100) NOT NULL, `jumlahBarang` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; INSERT INTO rb_inventaris VALUES ("14","11","Kapur","100"), ("15","11","Papan Tulis","1"); CREATE TABLE `rb_jadwal_pelajaran` ( `kodejdwl` int(10) NOT NULL, `idTahunAjaran` int(5) NOT NULL, `idKelas` varchar(10) NOT NULL, `kode_pelajaran` varchar(10) NOT NULL, `semester` varchar(100) NOT NULL, `nip` varchar(30) NOT NULL, `jam_ke` varchar(10) NOT NULL, `hari` varchar(20) NOT NULL, `aktif` enum('Ya','Tidak') NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO rb_jadwal_pelajaran VALUES ("41","11","1","BP","Semester Ganjil","","1","Selasa","Ya"), ("42","11","1","BP","Semester Ganjil","","2","Selasa","Ya"), ("43","11","1","MK17","Semester Ganjil","202201001503504","1","Senin","Ya"), ("40","11","1","MK17","Semester Ganjil","20190012","4","Selasa","Ya"), ("39","11","1","MK17","Semester Ganjil","20190012","3","Selasa","Ya"), ("37","11","1","001","Semester Ganjil","20190012","1","Senin","Ya"), ("38","11","1","001","Semester Ganjil","20190012","2","Senin","Ya"), ("44","11","1","MK17","Semester Ganjil","202201001503504","2","Senin","Ya"), ("45","11","1","MK17","Semester Ganjil","202201001503504","3","Senin","Ya"); CREATE TABLE `rb_jawaban_essai` ( `id_jawaban_essai` int(5) NOT NULL, `nisn` varchar(20) NOT NULL, `id_pertanyaan_essai` int(10) NOT NULL, `jawaban_essai` text NOT NULL, `waktu_tugas` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO rb_jawaban_essai VALUES ("9","20190001 ","15","Awobuk \n","2022-03-11 13:22:47"), ("10","20190002 ","17","Iya aku coba \n","2022-06-30 08:29:01"), ("11","20190002 ","20","Jakarta \n","2022-06-30 21:06:07"), ("12","20190002 ","19","Bulan","2022-06-30 21:06:16"); CREATE TABLE `rb_jawaban_objektif` ( `id_jawaban_objektif` int(5) NOT NULL, `nisn` varchar(20) NOT NULL, `id_pertanyaan_objektif` int(10) NOT NULL, `jawaban` varchar(2) NOT NULL, `waktu_objektif` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO rb_jawaban_objektif VALUES ("26","20190001 ","10","b","2022-03-11 13:28:28"), ("27","20190002 ","12","a","2022-07-05 20:56:02"), ("28","20190002 ","14","a","2022-06-30 21:06:19"); CREATE TABLE `rb_jenis_kelamin` ( `id_jenis_kelamin` int(5) NOT NULL, `jenis_kelamin` varchar(50) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO rb_jenis_kelamin VALUES ("1","Laki-laki"), ("2","Perempuan"); CREATE TABLE `rb_jenis_ptk` ( `id_jenis_ptk` int(5) NOT NULL, `jenis_ptk` varchar(100) NOT NULL, `keterangan` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO rb_jenis_ptk VALUES ("5","Tenaga Administrasi Sekolah",""), ("2","Guru Mapel",""), ("3","Guru BK",""), ("4","Wali Kelas",""), ("1","Kepala Sekolah",""); CREATE TABLE `rb_journal_list` ( `id_journal` int(10) NOT NULL, `kodejdwl` int(10) NOT NULL, `hari` varchar(20) NOT NULL, `tanggal` date NOT NULL, `jam_ke` varchar(50) NOT NULL, `materi` text NOT NULL, `keterangan` text NOT NULL, `waktu_input` datetime NOT NULL, `users` varchar(50) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO rb_journal_list VALUES ("15","37","Senin","2022-08-01","1","

Sadasd fd2

\n","sdad","2022-08-01 15:11:48","20190012"); CREATE TABLE `rb_kategori_elearning` ( `id_kategori_elearning` int(5) NOT NULL, `nama_kategori_elearning` varchar(50) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO rb_kategori_elearning VALUES ("1","Bahan"), ("2","Tugas"); CREATE TABLE `rb_kategori_quiz_ujian` ( `id_kategori_quiz_ujian` int(5) NOT NULL, `kategori_quiz_ujian` varchar(50) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO rb_kategori_quiz_ujian VALUES ("1","Quiz Online"), ("2","Ujian Online"); CREATE TABLE `rb_kehadiran` ( `kode_kehadiran` varchar(5) NOT NULL, `nama_kehadiran` varchar(20) NOT NULL, `nilai` int(2) NOT NULL, `bobot` varchar(5) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO rb_kehadiran VALUES ("H","Hadir","1","1"), ("I","Izin","1","0.5"), ("S","Sakit","1","0.5"), ("A","Alpa","0","0"), ("T","Terlambat","1","0.5"), ("P","Pulang","1","0.5"); CREATE TABLE `rb_kelompok_mata_pelajaran` ( `id_kelompok_mata_pelajaran` int(5) NOT NULL, `jenis_kelompok_mata_pelajaran` varchar(50) NOT NULL, `nama_kelompok_mata_pelajaran` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO rb_kelompok_mata_pelajaran VALUES ("1","A","Kelompok A "), ("2","B","Kelompok B"), ("3","C","Kelompok C"); CREATE TABLE `rb_mata_pelajaran` ( `kode_pelajaran` varchar(20) NOT NULL, `nip` varchar(30) NOT NULL, `namamatapelajaran` varchar(150) NOT NULL, `aktif` enum('Ya','Tidak') NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO rb_mata_pelajaran VALUES ("001","20190012","Matematika","Ya"), ("MK17","20190011","Bahasa Indonesia","Ya"), ("BP","20190010","Bahasa Jepan","Ya"), ("IPA","20190004","Ilmu Pengetahuan Alam","Ya"); CREATE TABLE `rb_nasabah` ( `nisnSiswa` int(100) NOT NULL, `idKelas` int(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO rb_nasabah VALUES ("20190002","11"), ("20190003","11"), ("20190004","11"), ("20190005","11"), ("20190006","11"), ("20190007","11"), ("121670374","1"), ("129700638","1"), ("135649671","1"), ("2147483647","1"); CREATE TABLE `rb_nilai` ( `id_nilai_pengetahuan` int(10) NOT NULL, `id_kelompok_mapel` int(10) NOT NULL, `paralel` int(10) NOT NULL, `kode` varchar(20) NOT NULL, `nisn` varchar(100) NOT NULL, `nama_mapel` varchar(200) NOT NULL, `nilai_peng` varchar(100) NOT NULL, `nilai_ket` varchar(100) NOT NULL, `user_akses` varchar(50) NOT NULL, `waktu` datetime NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO rb_nilai VALUES ("79","2","0","5","20190001","Pengantar Teknologi","89","89","1","2022-02-04 14:10:44"), ("78","2","0","4","20190001","Kalkulus","93","93","1","2022-02-04 14:10:44"), ("77","2","0","3","20190001","Aritmatika Dasar","90","90","1","2022-02-04 14:10:44"), ("76","1","0","2","20190001","Bahasa Inggris","80","80","1","2022-02-04 14:10:44"), ("75","1","0","11","20190001","Matematika","0","0","1","2022-02-04 14:10:44"), ("74","1","1","","20190001","SKI","88","88","1","2022-02-04 14:10:44"), ("73","1","1","","20190001","Aqidah","98","98","1","2022-02-04 14:10:44"), ("72","1","1","","20190001","Fikih","90","90","1","2022-02-04 14:10:44"), ("1","1","0","1","20190001","Pendidikan Agama Islam","89","89","1","2022-02-04 14:10:44"), ("80","3","0","6","20190001","Sejarah Indonesia","87","87","1","2022-02-04 14:10:44"), ("81","3","0","7","20190001","Pendidikan Pancasila","78","78","1","2022-02-04 14:10:44"), ("82","3","0","8","20190001","Seni Budaya","89","89","1","2022-02-04 14:10:44"), ("83","3","0","9","20190001","Pendidikan Olahraga","88","88","1","2022-02-04 14:10:44"), ("84","3","0","10","20190001","Prakarya Kewirausahaan","87","87","1","2022-02-04 14:10:44"); CREATE TABLE `rb_nilai_pertanyaan_essai` ( `id_nilai_pertanyaan_essai` int(5) NOT NULL, `id_quiz_ujian` int(5) NOT NULL, `nisn` varchar(20) NOT NULL, `nilai_essai` int(3) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO rb_nilai_pertanyaan_essai VALUES ("6","9","20190001","40"), ("7","13","20190002","20"); CREATE TABLE `rb_pertanyaan_essai` ( `id_pertanyaan_essai` int(11) NOT NULL, `id_quiz_ujian` int(5) NOT NULL, `pertanyaan_essai` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO rb_pertanyaan_essai VALUES ("15","9","Wok \n"), ("16","10","Haruskah aku mati "), ("17","11","Mencoba"), ("18","12","Coba jelaskan \n"), ("19","13","Jelaskan Saja \n"), ("20","13","Ibu Kota Indonesia ? \n"); CREATE TABLE `rb_pertanyaan_objektif` ( `id_pertanyaan_objektif` int(11) NOT NULL, `id_quiz_ujian` int(11) NOT NULL, `pertanyaan_objektif` text NOT NULL, `jawab_a` varchar(255) NOT NULL, `jawab_b` varchar(255) NOT NULL, `jawab_c` varchar(255) NOT NULL, `jawab_d` varchar(255) NOT NULL, `jawab_e` varchar(255) NOT NULL, `kunci_jawaban` varchar(5) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO rb_pertanyaan_objektif VALUES ("10","9","Bau","Hallo","Hai","Hula","Huna","Hanu","a"), ("11","10","Mencoba meresapi","Bocil","Bocol","Bucil","Bobol ","PAgar","a"), ("12","11","GAs ?","Halo","Hali","Halu","Halp","Hala","b"), ("13","12","Jelaskan saja","Makna","Arti","Coba","Saja","Pilih","c"), ("14","13","Menangis adalah kegiatan ?","Sedi","Gembira","Riang","Murung","Senang","a"); CREATE TABLE `rb_predikat` ( `id_predikat` int(5) NOT NULL, `kode_kelas` varchar(10) NOT NULL, `nilai_a` int(3) NOT NULL, `nilai_b` int(3) NOT NULL, `grade` varchar(5) NOT NULL, `keterangan` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO rb_predikat VALUES ("1","0","86","100","A","Sangat Baik"), ("2","0","79","85","B","Baik"), ("3","0","77","78","C","Cukup"), ("4","0","0","77","D","Kurang"); CREATE TABLE `rb_prestasi` ( `idPrestasi` int(10) NOT NULL, `idSiswa` int(10) NOT NULL, `tahunAjaran` int(10) NOT NULL, `semester` varchar(100) NOT NULL, `tgl` date DEFAULT NULL, `nmPrestasi` varchar(200) NOT NULL, `tingkatPrestasi` enum('Internasional','Nasional','Provinsi','Kabupaten/Kota','Kecamatan') NOT NULL DEFAULT 'Nasional', `juaraPrestasi` int(10) NOT NULL, `stdel` int(10) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO rb_prestasi VALUES ("4","27","11","Ganjil","2022-02-06","Bulu tangkis","Internasional","2","0"), ("5","151","11","Ganjil","2022-07-05","Juara 1 Renang","Nasional","1","0"); CREATE TABLE `rb_quiz_ujian` ( `id_quiz_ujian` int(5) NOT NULL, `id_kategori_quiz_ujian` int(5) NOT NULL, `kodejdwl` int(5) NOT NULL, `keterangan` text NOT NULL, `batas_waktu` datetime NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO rb_quiz_ujian VALUES ("9","2","2","COba","2022-03-16 12:00:11"), ("13","2","4","Bocil","2022-06-30 22:34:27"), ("11","1","2","kkxc","2022-12-30 09:00:25"); CREATE TABLE `rb_setting_absen` ( `id` int(11) NOT NULL, `waktu_masuk` time NOT NULL, `waktu_absen` time NOT NULL, `waktu_pulang` time NOT NULL, `waktu_batas_pulang` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; INSERT INTO rb_setting_absen VALUES ("1","12:00:00","06:00:00","17:30:00","21:30:00"); CREATE TABLE `rb_status_keaktifan` ( `id_status_keaktifan` int(5) NOT NULL, `nama_status_keaktifan` varchar(255) NOT NULL, `keterangan` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO rb_status_keaktifan VALUES ("1","Aktif",""), ("2","Tidak Aktif",""); CREATE TABLE `rb_status_kepegawaian` ( `id_status_kepegawaian` int(5) NOT NULL, `status_kepegawaian` varchar(255) NOT NULL, `keterangan` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO rb_status_kepegawaian VALUES ("1","Tenaga Honor Sekolah\n",""), ("2","Guru Honor Sekolah\n",""), ("3","ASN",""), ("4","NON ASN",""); CREATE TABLE `rb_status_pernikahan` ( `id_status_pernikahan` int(5) NOT NULL, `status_pernikahan` varchar(150) NOT NULL, `keterangan` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO rb_status_pernikahan VALUES ("1","Menikah",""), ("2","Belum Menikah",""); CREATE TABLE `rb_tugas_tambahan` ( `id` int(11) NOT NULL, `nmTugas` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; INSERT INTO rb_tugas_tambahan VALUES ("1","Wali Kelas"), ("2","Wakil Kepala Sekolah"), ("3","Piket"); CREATE TABLE `rb_wa` ( `id` int(11) NOT NULL, `file` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; CREATE TABLE `realisasi` ( `id` int(11) NOT NULL, `idPengeluaran` int(11) NOT NULL, `uraian` varchar(100) NOT NULL, `pagu` varchar(100) NOT NULL, `realisasi` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; CREATE TABLE `siswa` ( `idSiswa` int(10) NOT NULL AUTO_INCREMENT, `nisSiswa` varchar(25) DEFAULT NULL, `nisnSiswa` varchar(25) DEFAULT NULL, `nmSiswa` varchar(100) DEFAULT NULL, `jkSiswa` varchar(15) DEFAULT NULL, `agamaSiswa` varchar(15) DEFAULT NULL, `tglLahirSiswa` date DEFAULT NULL, `tmptLahir` varchar(100) NOT NULL, `idKelas` int(5) DEFAULT NULL, `statusSiswa` enum('Aktif','Non Aktif','Pindah','Drop Out','Lulus') DEFAULT 'Aktif', `username` varchar(20) NOT NULL, `password` varchar(200) DEFAULT NULL, `level` varchar(10) NOT NULL, `statusKeluarga` varchar(100) DEFAULT NULL, `anakKe` varchar(100) DEFAULT NULL, `sekolah` varchar(100) DEFAULT NULL, `nmOrtuIbu` varchar(100) DEFAULT NULL, `nmOrtu` varchar(40) DEFAULT NULL, `alamatOrtu` varchar(100) DEFAULT NULL, `noHpOrtu` varchar(30) DEFAULT NULL, `noHpSis` varchar(200) NOT NULL, `saldo` double NOT NULL, `foto` varchar(200) NOT NULL, PRIMARY KEY (`idSiswa`), KEY `fk_kelas` (`idKelas`), KEY `fk_status` (`statusSiswa`) ) ENGINE=InnoDB AUTO_INCREMENT=400 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO siswa VALUES ("1","0105150383","0105150383","AGHNIYA` WISNU NUGROHO JATI","L","Islam","2010-05-25","Tulungagung","9","Aktif","0105150383","25052010","siswa","Kandung","1","SD 1 PICISAN","Yamah","Hadi Prayetno","Desa/Kel. Picisan - Kec. Sendang - 66254","6285724413091","","-1000",""), ("2","3090555113","3090555113","AHMAD HADI AL HAFIZD","L","Islam","2009-08-13","Batam","9","Aktif","3090555113","13082009","siswa","Kandung","1","TAHFIZ WAL LUGHOH RUHUL QURAN","Rahmi","Ahadian","Desa/Kel. Ploso - Kec. Mojo - 29432","6285724413091","","0",""), ("3","0126258762","0126258762","AHMAD NIZAR MAULANA","L","Islam","2009-12-16","Blitar","9","Aktif","0126258762","16122009","siswa","Kandung","3","UPT SD NEGERI KEMLOKO 01","Atik Yulistriani","Muajid","Desa/Kel. Kemloko - Kec. Nglegok - ","6285724413091","","0",""), ("4","0099309048","0099309048","AKBAR ILMI RAHMADANI","L","Islam","2009-08-27","Kediri","9","Aktif","0099309048","27082009","siswa","Kandung","1","MI PLUS DARUL HIKMAH","Sri Astutik Anggraini","Suyanto","Desa/Kel. Ploso - Kec. Mojo - 64291","6281387223331","","0",""), ("5","0109885495","0109885495","ANDIKA DWI PRASETIA","L","Islam","2010-05-31","Kotawaringin Timur","9","Aktif","0109885495","31052010","siswa","Kandung","3","SD NEGERI 2 TANJUNG HARAPAN","Rumiyati","Kalkup","Desa/Kel. Tanjung Harapan - Kec. Telaga Antang - 74356","6281387223331","","0",""), ("6","3093338458","3093338458","DEDE HILMANSYAH","L","Islam","2009-11-11","Jakarta","9","Aktif","3093338458","11112009","siswa","Kandung","1","","Asnawiyah","Ujang Maman","Penjaringan - Kec. Penjaringan - ","6285724413091","","0",""), ("7","3094147573","3094147573","DHAYFAN NAUFAR AL ARIDH","L","Islam","2009-08-17","Ponorogo","9","Aktif","3094147573","17082009","siswa","Kandung","1","MI PLUS BUNGA BANGSA","Sulestari","Mahfud Huda Ahsani","Desa/Kel. Babadan - Kec. Babadan - 63491","6281387223331","","0",""); CREATE TABLE `siswa_konseling` ( `idKonseling` int(11) NOT NULL, `siswa` int(11) NOT NULL, `tahunAjaran` int(11) NOT NULL, `tanggal` date NOT NULL, `pelanggaran` varchar(100) NOT NULL, `tindakan` varchar(100) NOT NULL, `poin` varchar(20) NOT NULL, `catatan` varchar(255) NOT NULL, `stdel` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; CREATE TABLE `tagihan_bebas` ( `idTagihanBebas` int(50) NOT NULL AUTO_INCREMENT, `idJenisBayar` int(5) DEFAULT NULL, `idSiswa` int(10) DEFAULT NULL, `idKelas` int(5) DEFAULT NULL, `idBulan` int(10) NOT NULL, `totalTagihan` int(10) DEFAULT NULL, `ref` varchar(100) NOT NULL, `statusBayar` enum('0','1','2') DEFAULT '0', PRIMARY KEY (`idTagihanBebas`), KEY `fk_t_jenis` (`idJenisBayar`), KEY `fk_t_siswa` (`idSiswa`), KEY `fk_t_kelas` (`idKelas`) ) ENGINE=InnoDB AUTO_INCREMENT=444 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO tagihan_bebas VALUES ("1","1","36","9","1","705000","","0"), ("2","1","93","11","1","2000000","","0"), ("3","1","115","12","1","810000","","0"), ("4","2","8","9","1","865000","","0"), ("5","2","36","9","1","865000","","0"), ("6","2","83","11","1","865000","","0"), ("7","2","85","11","1","665000","","0"), ("8","2","100","11","1","865000","","0"), ("9","2","101","11","1","865000","","0"), ("10","2","115","12","1","865000","","0"), ("11","3","1","9","1","1404000","","2"), ("12","3","2","9","1","1404000","","0"), ("13","3","3","9","1","1404000","","2"), ("14","3","4","9","1","1404000","","2"), ("15","3","5","9","1","1404000","","0"), ("16","3","6","9","1","1404000","","1"), ("17","3","7","9","1","1404000","","0"), ("18","3","8","9","1","1404000","","0"), ("19","3","9","9","1","1404000","","0"), ("20","3","10","9","1","1404000","","0"), ("21","3","11","9","1","1404000","","0"), ("22","3","12","9","1","1404000","","0"), ("23","3","13","9","1","1404000","","0"), ("24","3","14","9","1","1404000","","0"), ("25","3","15","9","1","1404000","","0"), ("26","3","16","9","1","1404000","","0"), ("27","3","17","9","1","1404000","","0"), ("28","3","18","9","1","1404000","","0"), ("29","3","19","9","1","1404000","","0"), ("30","3","20","9","1","1404000","","0"), ("31","3","21","9","1","1404000","","0"), ("32","3","22","9","1","1404000","","0"), ("33","3","23","9","1","1404000","","0"), ("34","3","24","9","1","1404000","","0"), ("35","3","25","9","1","1404000","","0"), ("36","3","26","9","1","1404000","","0"), ("37","3","27","9","1","1404000","","0"), ("38","3","28","9","1","1404000","","0"), ("39","3","29","9","1","1404000","","0"), ("40","3","30","9","1","1404000","","0"), ("41","3","31","9","1","1404000","","0"), ("42","3","32","9","1","1404000","","0"), ("43","3","33","9","1","1404000","","0"), ("44","3","34","9","1","1404000","","0"), ("45","3","35","9","1","1404000","","0"), ("46","3","36","9","1","1404000","","0"), ("47","3","37","10","1","1404000","","0"), ("48","3","38","10","1","1404000","","0"), ("49","3","39","10","1","1404000","","0"), ("50","3","40","10","1","1404000","","0"), ("51","3","41","10","1","1404000","","0"), ("52","3","42","10","1","1404000","","0"), ("53","3","43","10","1","1404000","","0"), ("54","3","44","10","1","1404000","","0"), ("55","3","45","10","1","1404000","","0"), ("56","3","46","10","1","1404000","","0"), ("57","3","47","10","1","1404000","","0"), ("58","3","48","10","1","1404000","","0"), ("59","3","49","10","1","1404000","","0"), ("60","3","50","10","1","1404000","","0"), ("61","3","51","10","1","1404000","","0"), ("62","3","52","10","1","1404000","","0"), ("63","3","53","10","1","1404000","","0"), ("64","3","54","10","1","1404000","","0"), ("65","3","55","10","1","1404000","","0"), ("66","3","56","10","1","1404000","","0"), ("67","3","57","10","1","1404000","","0"), ("68","3","58","10","1","1404000","","0"), ("69","3","59","10","1","1404000","","0"), ("70","3","60","10","1","1404000","","0"), ("71","3","61","10","1","1404000","","0"), ("72","3","62","10","1","1404000","","0"), ("73","3","63","10","1","1404000","","0"), ("74","3","64","10","1","1404000","","0"), ("75","3","65","10","1","1404000","","0"), ("76","3","66","10","1","1404000","","0"), ("77","3","67","10","1","1404000","","0"), ("78","3","68","10","1","1404000","","0"), ("79","3","69","10","1","1404000","","0"), ("80","3","70","10","1","1404000","","0"), ("81","3","71","10","1","1404000","","0"), ("82","3","72","11","1","1404000","","0"), ("83","3","73","11","1","1404000","","0"), ("84","3","74","11","1","1404000","","0"), ("85","3","75","11","1","1404000","","0"), ("86","3","76","11","1","1404000","","0"), ("87","3","77","11","1","1404000","","0"), ("88","3","78","11","1","1404000","","0"), ("89","3","79","11","1","1404000","","0"), ("90","3","80","11","1","1404000","","0"), ("91","3","81","11","1","1404000","","0"), ("92","3","82","11","1","1404000","","0"), ("93","3","83","11","1","1404000","","0"), ("94","3","84","11","1","1404000","","0"), ("95","3","85","11","1","1404000","","0"), ("96","3","86","11","1","1404000","","0"), ("97","3","87","11","1","1404000","","0"), ("98","3","88","11","1","1404000","","0"), ("99","3","89","11","1","1404000","","0"), ("100","3","90","11","1","1404000","","0"); INSERT INTO tagihan_bebas VALUES ("101","3","91","11","1","1404000","","0"), ("102","3","92","11","1","1404000","","0"), ("103","3","93","11","1","1404000","","0"), ("104","3","94","11","1","1404000","","0"), ("105","3","95","11","1","1404000","","0"), ("106","3","96","11","1","1404000","","0"), ("107","3","97","11","1","1404000","","0"), ("108","3","98","11","1","1404000","","0"), ("109","3","99","11","1","1404000","","0"), ("110","3","100","11","1","1404000","","0"), ("111","3","101","11","1","1404000","","0"), ("112","3","102","11","1","1404000","","0"), ("113","3","103","11","1","1404000","","0"), ("114","3","104","11","1","1404000","","0"), ("115","3","105","11","1","1404000","","0"), ("116","3","106","12","1","1404000","","0"), ("117","3","107","12","1","1404000","","0"), ("118","3","108","12","1","1404000","","0"), ("119","3","109","12","1","1404000","","0"), ("120","3","110","12","1","1404000","","0"), ("121","3","111","12","1","1404000","","0"), ("122","3","112","12","1","1404000","","0"), ("123","3","113","12","1","1404000","","0"), ("124","3","114","12","1","1404000","","0"), ("125","3","115","12","1","1404000","","0"), ("126","3","116","12","1","1404000","","0"), ("127","3","117","12","1","1404000","","0"), ("128","3","118","12","1","1404000","","0"), ("129","3","119","12","1","1404000","","0"), ("130","3","120","12","1","1404000","","0"), ("131","3","121","12","1","1404000","","0"), ("132","3","122","12","1","1404000","","0"), ("133","3","123","12","1","1404000","","0"), ("134","3","124","12","1","1404000","","0"), ("135","3","125","12","1","1404000","","0"), ("136","3","126","12","1","1404000","","0"), ("137","3","127","12","1","1404000","","0"), ("138","3","128","12","1","1404000","","0"), ("139","3","129","12","1","1404000","","0"), ("140","3","130","12","1","1404000","","0"), ("141","3","131","12","1","1404000","","0"), ("142","3","132","12","1","1404000","","0"), ("143","3","133","12","1","1404000","","0"), ("144","3","134","12","1","1404000","","0"), ("145","3","135","12","1","1404000","","0"), ("146","3","136","12","1","1404000","","0"), ("147","3","137","12","1","1404000","","0"), ("148","3","138","12","1","1404000","","0"), ("149","9","139","1","1","3804000","","1"), ("150","9","140","1","1","3804000","","0"), ("151","9","141","1","1","3804000","","0"), ("152","9","142","1","1","3804000","","0"), ("153","9","143","1","1","3804000","","1"), ("154","9","144","1","1","3804000","","1"), ("155","9","145","1","1","3804000","","0"), ("156","9","146","1","1","3804000","","0"), ("157","9","147","1","1","3804000","","0"), ("158","9","148","1","1","3804000","","0"), ("159","9","149","1","1","3804000","","0"), ("160","9","150","1","1","3804000","","0"), ("161","9","151","1","1","3804000","","0"), ("162","9","152","1","1","3804000","","0"), ("163","9","153","1","1","3804000","","0"), ("164","9","154","1","1","3804000","","0"), ("165","9","155","1","1","3804000","","0"), ("166","9","156","1","1","3804000","","0"), ("167","9","157","1","1","3804000","","0"), ("168","9","158","1","1","3804000","","0"), ("169","9","159","1","1","3804000","","0"), ("170","9","160","1","1","3804000","","0"), ("171","9","161","1","1","3804000","","0"), ("172","9","162","1","1","3804000","","0"), ("173","9","163","1","1","3804000","","0"), ("174","9","164","1","1","3804000","","0"), ("175","9","165","1","1","3804000","","0"), ("176","9","166","1","1","3804000","","0"), ("177","9","167","1","1","3804000","","0"), ("178","9","168","1","1","3804000","","0"), ("179","9","169","1","1","3804000","","0"), ("180","9","170","1","1","3804000","","0"), ("181","9","171","2","1","3804000","","0"), ("182","9","172","2","1","3804000","","0"), ("183","9","173","2","1","3804000","","0"), ("184","9","174","2","1","3804000","","0"), ("185","9","175","2","1","3804000","","0"), ("186","9","176","2","1","3804000","","0"), ("187","9","177","2","1","3804000","","0"), ("188","9","178","2","1","3804000","","0"), ("189","9","179","2","1","3804000","","0"), ("190","9","180","2","1","3804000","","0"), ("191","9","181","2","1","3804000","","0"), ("192","9","182","2","1","3804000","","0"), ("193","9","183","2","1","3804000","","0"), ("194","9","184","2","1","3804000","","0"), ("195","9","185","2","1","3804000","","0"), ("196","9","186","2","1","3804000","","0"), ("197","9","187","2","1","3804000","","0"), ("198","9","188","2","1","3804000","","0"), ("199","9","189","2","1","3804000","","0"), ("200","9","190","2","1","3804000","","0"); INSERT INTO tagihan_bebas VALUES ("201","9","191","2","1","3804000","","0"), ("202","9","192","2","1","3804000","","0"), ("203","9","193","2","1","3804000","","0"), ("204","9","194","2","1","3804000","","0"), ("205","9","195","2","1","3804000","","0"), ("206","9","196","2","1","3804000","","0"), ("207","9","197","2","1","3804000","","0"), ("208","9","198","2","1","3804000","","0"), ("209","9","199","2","1","3804000","","0"), ("210","9","200","2","1","3804000","","0"), ("211","9","201","2","1","3804000","","0"), ("212","9","202","2","1","3804000","","0"), ("213","9","203","2","1","3804000","","0"), ("214","9","204","2","1","3804000","","0"), ("215","9","205","3","1","3804000","","0"), ("216","9","206","3","1","3804000","","0"), ("217","9","207","3","1","3804000","","0"), ("218","9","208","3","1","3804000","","0"), ("219","9","209","3","1","3804000","","0"), ("220","9","210","3","1","3804000","","0"), ("221","9","211","3","1","3804000","","0"), ("222","9","212","3","1","3804000","","0"), ("223","9","213","3","1","3804000","","0"), ("224","9","214","3","1","3804000","","0"), ("225","9","215","3","1","3804000","","0"), ("226","9","216","3","1","3804000","","0"), ("227","9","217","3","1","3804000","","0"), ("228","9","218","3","1","3804000","","0"), ("229","9","219","3","1","3804000","","0"), ("230","9","220","3","1","3804000","","0"), ("231","9","221","3","1","3804000","","0"), ("232","9","222","3","1","3804000","","0"), ("233","9","223","3","1","3804000","","0"), ("234","9","224","3","1","3804000","","0"), ("235","9","225","3","1","3804000","","0"), ("236","9","226","3","1","3804000","","0"), ("237","9","227","3","1","3804000","","0"), ("238","9","228","3","1","3804000","","0"), ("239","9","229","3","1","3804000","","0"), ("240","9","230","3","1","3804000","","0"), ("241","9","231","3","1","3804000","","0"), ("242","9","232","3","1","3804000","","0"), ("243","9","233","3","1","3804000","","0"), ("244","9","234","3","1","3804000","","0"), ("245","9","235","3","1","3804000","","0"), ("246","9","236","3","1","3804000","","0"), ("247","9","237","3","1","3804000","","0"), ("248","9","238","3","1","3804000","","0"), ("249","9","239","4","1","3804000","","0"), ("250","9","240","4","1","3804000","","0"), ("251","9","241","4","1","3804000","","0"), ("252","9","242","4","1","3804000","","0"), ("253","9","243","4","1","3804000","","0"), ("254","9","244","4","1","3804000","","0"), ("255","9","245","4","1","3804000","","0"), ("256","9","246","4","1","3804000","","0"), ("257","9","247","4","1","3804000","","0"), ("258","9","248","4","1","3804000","","0"), ("259","9","249","4","1","3804000","","0"), ("260","9","250","4","1","3804000","","0"), ("261","9","251","4","1","3804000","","0"), ("262","9","252","4","1","3804000","","0"), ("263","9","253","4","1","3804000","","0"), ("264","9","254","4","1","3804000","","0"), ("265","9","255","4","1","3804000","","0"), ("266","9","256","4","1","3804000","","0"), ("267","9","257","4","1","3804000","","0"), ("268","9","258","4","1","3804000","","0"), ("269","9","259","4","1","3804000","","0"), ("270","9","260","4","1","3804000","","0"), ("271","9","261","4","1","3804000","","0"), ("272","9","262","4","1","3804000","","0"), ("273","9","263","4","1","3804000","","0"), ("274","9","264","4","1","3804000","","0"), ("275","9","265","5","1","3804000","","0"), ("276","9","266","5","1","3804000","","0"), ("277","9","267","5","1","3804000","","0"), ("278","9","268","5","1","3804000","","0"), ("279","9","269","5","1","3804000","","0"), ("280","9","270","5","1","3804000","","0"), ("281","9","271","5","1","3804000","","0"), ("282","9","272","5","1","3804000","","0"), ("283","9","273","5","1","3804000","","0"), ("284","9","274","5","1","3804000","","0"), ("285","9","275","5","1","3804000","","0"), ("286","9","276","5","1","3804000","","0"), ("287","9","277","5","1","3804000","","0"), ("288","9","278","5","1","3804000","","0"), ("289","9","279","5","1","3804000","","0"), ("290","9","280","5","1","3804000","","0"), ("291","9","281","5","1","3804000","","0"), ("292","9","282","5","1","3804000","","0"), ("293","9","283","5","1","3804000","","0"), ("294","9","284","5","1","3804000","","0"), ("295","9","285","5","1","3804000","","0"), ("296","9","286","5","1","3804000","","0"), ("297","9","287","5","1","3804000","","0"), ("298","9","288","5","1","3804000","","0"), ("299","9","289","5","1","3804000","","0"), ("300","9","290","5","1","3804000","","0"); INSERT INTO tagihan_bebas VALUES ("301","9","291","5","1","3804000","","0"), ("302","9","292","5","1","3804000","","0"), ("303","9","293","5","1","3804000","","0"), ("304","9","294","5","1","3804000","","0"), ("305","9","295","5","1","3804000","","0"), ("306","9","296","5","1","3804000","","0"), ("307","9","297","5","1","3804000","","0"), ("308","9","298","5","1","3804000","","0"), ("343","9","333","7","1","3914000","","0"), ("344","9","334","7","1","3914000","","0"), ("345","9","335","7","1","3914000","","0"), ("346","9","336","7","1","3914000","","0"), ("347","9","337","7","1","3914000","","0"), ("348","9","338","7","1","3914000","","0"), ("349","9","339","7","1","3914000","","0"), ("350","9","340","7","1","3914000","","0"), ("351","9","341","7","1","3914000","","0"), ("352","9","342","7","1","3914000","","0"), ("353","9","343","7","1","3914000","","0"), ("354","9","344","7","1","3914000","","0"), ("355","9","345","7","1","3914000","","0"), ("356","9","346","7","1","3914000","","0"), ("357","9","347","7","1","3914000","","0"), ("358","9","348","7","1","3914000","","0"), ("359","9","349","7","1","3914000","","0"), ("360","9","350","7","1","3914000","","0"), ("361","9","351","7","1","3914000","","0"), ("362","9","352","7","1","3914000","","0"), ("363","9","353","7","1","3914000","","0"), ("364","9","354","7","1","3914000","","0"), ("365","9","355","7","1","3914000","","0"), ("366","9","356","7","1","3914000","","0"), ("367","9","357","7","1","3914000","","0"), ("368","9","358","7","1","3914000","","0"), ("369","9","359","7","1","3914000","","0"), ("370","9","360","7","1","3914000","","0"), ("371","9","361","7","1","3914000","","0"), ("372","9","362","7","1","3914000","","0"), ("373","9","363","7","1","3914000","","0"), ("374","9","364","7","1","3914000","","0"), ("375","9","365","7","1","3914000","","0"), ("376","9","366","8","1","3914000","","0"), ("377","9","367","8","1","3914000","","0"), ("378","9","368","8","1","3914000","","0"), ("379","9","369","8","1","3914000","","0"), ("380","9","370","8","1","3914000","","0"), ("381","9","371","8","1","3914000","","0"), ("382","9","372","8","1","3914000","","0"), ("383","9","373","8","1","3914000","","0"), ("384","9","374","8","1","3914000","","0"), ("385","9","375","8","1","3914000","","0"), ("386","9","376","8","1","3914000","","0"), ("387","9","377","8","1","3914000","","0"), ("388","9","378","8","1","3914000","","0"), ("389","9","379","8","1","3914000","","0"), ("390","9","380","8","1","3914000","","0"), ("391","9","381","8","1","3914000","","0"), ("392","9","382","8","1","3914000","","0"), ("393","9","383","8","1","3914000","","0"), ("394","9","384","8","1","3914000","","0"), ("395","9","385","8","1","3914000","","0"), ("396","9","386","8","1","3914000","","0"), ("397","9","387","8","1","3914000","","0"), ("398","9","388","8","1","3914000","","0"), ("399","9","389","8","1","3914000","","0"), ("400","9","390","8","1","3914000","","0"), ("401","9","391","8","1","3914000","","0"), ("402","9","392","8","1","3914000","","0"), ("403","9","393","8","1","3914000","","0"), ("404","9","394","8","1","3914000","","0"), ("405","9","395","8","1","3914000","","0"), ("406","9","396","8","1","3914000","","0"), ("407","9","397","8","1","3914000","","0"), ("408","9","398","8","1","3914000","","0"), ("409","9","399","8","1","3914000","","0"), ("410","9","299","6","1","3914000","","0"), ("411","9","300","6","1","3914000","","0"), ("412","9","301","6","1","3914000","","0"), ("413","9","302","6","1","3914000","","0"), ("414","9","303","6","1","3914000","","0"), ("415","9","304","6","1","3914000","","0"), ("416","9","305","6","1","3914000","","0"), ("417","9","306","6","1","3914000","","0"), ("418","9","307","6","1","3914000","","0"), ("419","9","308","6","1","3914000","","0"), ("420","9","309","6","1","3914000","","0"), ("421","9","310","6","1","3914000","","0"), ("422","9","311","6","1","3914000","","0"), ("423","9","312","6","1","3914000","","0"), ("424","9","313","6","1","3914000","","0"), ("425","9","314","6","1","3914000","","0"), ("426","9","315","6","1","3914000","","0"), ("427","9","316","6","1","3914000","","0"), ("428","9","317","6","1","3914000","","0"), ("429","9","318","6","1","3914000","","0"), ("430","9","319","6","1","3914000","","0"), ("431","9","320","6","1","3914000","","0"), ("432","9","321","6","1","3914000","","0"), ("433","9","322","6","1","3914000","","0"), ("434","9","323","6","1","3914000","","0"); INSERT INTO tagihan_bebas VALUES ("435","9","324","6","1","3914000","","0"), ("436","9","325","6","1","3914000","","0"), ("437","9","326","6","1","3914000","","0"), ("438","9","327","6","1","3914000","","0"), ("439","9","328","6","1","3914000","","0"), ("440","9","329","6","1","3914000","","0"), ("441","9","330","6","1","3914000","","0"), ("442","9","331","6","1","3914000","","0"), ("443","9","332","6","1","3914000","","0"); CREATE TABLE `tagihan_bebas_bayar` ( `idTagihanBebasBayar` int(50) NOT NULL AUTO_INCREMENT, `idTagihanBebas` int(50) DEFAULT NULL, `tglBayar` date DEFAULT NULL, `jumlahBayar` int(10) DEFAULT NULL, `ketBayar` varchar(100) DEFAULT NULL, `caraBayar` enum('Tunai','Transfer','Transfer Midtrans') DEFAULT 'Tunai', PRIMARY KEY (`idTagihanBebasBayar`), KEY `fkbayarbebas` (`idTagihanBebas`) ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO tagihan_bebas_bayar VALUES ("1","153","2023-07-20","3804000","rw","Tunai"), ("3","154","2023-07-20","3804000","te","Tunai"), ("10","16","2023-07-22","1000000","Angsuran 1","Transfer"), ("11","16","2023-07-22","100000","Tunjangan PIP","Tunai"), ("12","16","2023-07-22","1000","tes","Tunai"), ("13","16","2023-07-22","303000","lunas","Tunai"), ("15","13","2023-07-22","1000000","angsuran 1","Tunai"), ("22","11","2023-07-22","111","r","Tunai"), ("23","11","2023-07-22","1111","da","Tunai"), ("24","11","2023-07-22","24","fa","Tunai"), ("25","11","2023-07-22","1000","tes","Tunai"), ("26","14","2023-08-09","100000","Lunas","Transfer"); CREATE TABLE `tagihan_bulanan` ( `idTagihanBulanan` int(50) NOT NULL AUTO_INCREMENT, `idJenisBayar` int(5) DEFAULT NULL, `idSiswa` int(10) DEFAULT NULL, `idKelas` int(5) DEFAULT NULL, `idBulan` varchar(15) DEFAULT NULL, `jumlahBayar` int(10) DEFAULT NULL, `tglBayar` datetime DEFAULT NULL ON UPDATE current_timestamp(), `tglUpdate` datetime DEFAULT NULL ON UPDATE current_timestamp(), `inv` varchar(100) NOT NULL, `statusBayar` enum('0','1','2') DEFAULT '0', `caraBayar` enum('Tunai','Transfer','Transfer Midtrans') DEFAULT 'Tunai', PRIMARY KEY (`idTagihanBulanan`), KEY `fk_t_jenis` (`idJenisBayar`), KEY `fk_t_siswa` (`idSiswa`), KEY `fk_t_kelas` (`idKelas`), KEY `fk_t_bulan` (`idBulan`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; CREATE TABLE `tahun_ajaran` ( `idTahunAjaran` int(5) NOT NULL AUTO_INCREMENT, `nmTahunAjaran` varchar(20) DEFAULT NULL, `aktif` enum('Y','T') DEFAULT 'Y', PRIMARY KEY (`idTahunAjaran`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO tahun_ajaran VALUES ("2","Angkatan 2022/23","Y"), ("3","Angkatan 2023/24","T"); CREATE TABLE `transaksi` ( `id_transaksi` varchar(50) NOT NULL, `nisnSiswa` varchar(50) NOT NULL, `tanggal` date NOT NULL, `debit` int(10) NOT NULL, `kredit` int(10) NOT NULL, `keterangan` varchar(50) NOT NULL, PRIMARY KEY (`id_transaksi`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO transaksi VALUES ("T0001","0105150383","2023-07-22","0","1000","Pembayaran Bebas"); CREATE TABLE `users` ( `username` varchar(50) NOT NULL, `password` varchar(50) NOT NULL, `nama_lengkap` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `no_telp` varchar(20) NOT NULL, `level` varchar(20) NOT NULL DEFAULT 'admin', `blokir` enum('Y','N') NOT NULL DEFAULT 'N', `idKelas` varchar(100) NOT NULL, `fotoUser` varchar(255) NOT NULL, `id_session` varchar(100) NOT NULL, `last_login` timestamp NULL DEFAULT NULL, PRIMARY KEY (`username`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; INSERT INTO users VALUES ("admin","aa0279c6f440c33c8b1faadd620f11a3","Administrator","bendaharasmaqueen@gmail.com","0852330726611","admin","N","","Logo.png","vgjkducma2cld9dq2a7ahg5f04","2023-08-09 13:08:39"), ("bendahara2sma","e10adc3949ba59abbe56e057f20f883e","Chifni Darun Naja, S.E.","admin@admin.com","08","admin","N","","","","2022-09-17 05:45:06"); CREATE TABLE `users_level` ( `idUsersLevel` int(11) NOT NULL AUTO_INCREMENT, `namaUsersLevel` varchar(255) DEFAULT NULL, PRIMARY KEY (`idUsersLevel`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; INSERT INTO users_level VALUES ("1","ADMIN"), ("2","KONSELING"), ("3","KESEHATAN"), ("4","AKADEMIK"), ("5","KESISWAAN"), ("6","TATA USAHA"), ("7","GURU"), ("8","KEUANGAN"), ("9","KASIR"); CREATE ALGORITHM=UNDEFINED DEFINER=`u4595895`@`socrates.id.domainesia.com` SQL SECURITY DEFINER VIEW `view_detil_jenis_bayar` AS select `jenis_bayar`.`idJenisBayar` AS `idJenisBayar`,`jenis_bayar`.`idPosBayar` AS `idPosBayar`,`jenis_bayar`.`idTahunAjaran` AS `idTahunAjaran`,`jenis_bayar`.`nmJenisBayar` AS `nmJenisBayar`,`jenis_bayar`.`tipeBayar` AS `tipeBayar`,`pos_bayar`.`nmPosBayar` AS `nmPosBayar`,`tahun_ajaran`.`nmTahunAjaran` AS `nmTahunAjaran`,`tahun_ajaran`.`aktif` AS `aktif` from ((`jenis_bayar` join `pos_bayar` on(`jenis_bayar`.`idPosBayar` = `pos_bayar`.`idPosBayar`)) join `tahun_ajaran` on(`jenis_bayar`.`idTahunAjaran` = `tahun_ajaran`.`idTahunAjaran`)); CREATE ALGORITHM=UNDEFINED DEFINER=`u4595895`@`socrates.id.domainesia.com` SQL SECURITY DEFINER VIEW `view_detil_siswa` AS select `siswa`.`idSiswa` AS `idSiswa`,`siswa`.`nisSiswa` AS `nisSiswa`,`siswa`.`nisnSiswa` AS `nisnSiswa`,`siswa`.`nmSiswa` AS `nmSiswa`,`siswa`.`jkSiswa` AS `jkSiswa`,`siswa`.`agamaSiswa` AS `agamaSiswa`,`siswa`.`tglLahirSiswa` AS `tglLahirSiswa`,`siswa`.`tmptLahir` AS `tmptLahir`,`siswa`.`idKelas` AS `idKelas`,`siswa`.`statusSiswa` AS `statusSiswa`,`kelas_siswa`.`nmKelas` AS `nmKelas`,`kelas_siswa`.`ketKelas` AS `ketKelas`,`siswa`.`nmOrtu` AS `nmOrtu`,`siswa`.`alamatOrtu` AS `alamatOrtu`,`siswa`.`noHpOrtu` AS `noHpOrtu`,`siswa`.`noHpSis` AS `noHpSis`,`siswa`.`saldo` AS `saldo`,`siswa`.`username` AS `username`,`siswa`.`password` AS `password`,`siswa`.`level` AS `level`,`siswa`.`statusKeluarga` AS `statusKeluarga`,`siswa`.`anakKe` AS `anakKe`,`siswa`.`sekolah` AS `sekolah`,`siswa`.`nmOrtuIbu` AS `nmOrtuIbu`,`siswa`.`foto` AS `foto` from (`siswa` join `kelas_siswa` on(`siswa`.`idKelas` = `kelas_siswa`.`idKelas`)); CREATE ALGORITHM=UNDEFINED DEFINER=`u4595895`@`socrates.id.domainesia.com` SQL SECURITY DEFINER VIEW `view_laporan_bayar_bulanan` AS select `tagihan_bulanan`.`idTagihanBulanan` AS `idTagihanBulanan`,`tagihan_bulanan`.`idJenisBayar` AS `idJenisBayar`,`tagihan_bulanan`.`idSiswa` AS `idSiswa`,`tagihan_bulanan`.`idKelas` AS `idKelas`,`tagihan_bulanan`.`idBulan` AS `idBulan`,`tagihan_bulanan`.`jumlahBayar` AS `jumlahBayar`,`tagihan_bulanan`.`tglBayar` AS `tglBayar`,`tagihan_bulanan`.`tglUpdate` AS `tglUpdate`,`tagihan_bulanan`.`statusBayar` AS `statusBayar`,`jenis_bayar`.`idTahunAjaran` AS `idTahunAjaran`,`jenis_bayar`.`nmJenisBayar` AS `nmJenisBayar`,`tahun_ajaran`.`nmTahunAjaran` AS `nmTahunAjaran`,`siswa`.`nisSiswa` AS `nisSiswa`,`siswa`.`nmSiswa` AS `nmSiswa`,`kelas_siswa`.`nmKelas` AS `nmKelas`,`bulan`.`nmBulan` AS `nmBulan`,`bulan`.`urutan` AS `urutan`,`tagihan_bulanan`.`caraBayar` AS `caraBayar` from (((((`tagihan_bulanan` join `jenis_bayar` on(`tagihan_bulanan`.`idJenisBayar` = `jenis_bayar`.`idJenisBayar`)) join `tahun_ajaran` on(`jenis_bayar`.`idTahunAjaran` = `tahun_ajaran`.`idTahunAjaran`)) join `siswa` on(`tagihan_bulanan`.`idSiswa` = `siswa`.`idSiswa`)) join `kelas_siswa` on(`siswa`.`idKelas` = `kelas_siswa`.`idKelas`)) join `bulan` on(`tagihan_bulanan`.`idBulan` = `bulan`.`idBulan`)); SET GLOBAL FOREIGN_KEY_CHECKS = 1; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;