wartana
74b8f572a2
- Report: Added printable reports for all categories. - Dashboard: Fixed broken links and implemented gender balance filtering. - Logic: Auto-integration of Arrivals and Births into Resident/KK data. - Fix: Solved deletion popup bug in Birth Data. - Feature: Added Full KK History view. - Feature: Implemented Dynamic Village Profile for letter templates.
48 lines
2.4 KiB
SQL
48 lines
2.4 KiB
SQL
-- Dummy Data for SIDAK Application (Extended)
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
TRUNCATE TABLE `tb_anggota`;
|
|
TRUNCATE TABLE `tb_lahir`;
|
|
TRUNCATE TABLE `tb_mendu`;
|
|
TRUNCATE TABLE `tb_pindah`;
|
|
TRUNCATE TABLE `tb_datang`;
|
|
TRUNCATE TABLE `tb_kk`;
|
|
TRUNCATE TABLE `tb_pdd`;
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
|
|
|
-- 1. Insert Data Kartu Keluarga (tb_kk)
|
|
INSERT INTO `tb_kk` (`id_kk`, `no_kk`, `kepala`, `desa`, `rt`, `rw`, `kec`, `kab`, `prov`) VALUES
|
|
(1, '32010101010001', 'Budi Santoso', 'Sukamaju', '01', '02', 'Cibinong', 'Bogor', 'Jawa Barat'),
|
|
(2, '32010101010002', 'Siti Aminah', 'Sukamaju', '02', '02', 'Cibinong', 'Bogor', 'Jawa Barat');
|
|
|
|
-- 2. Insert Data Penduduk (tb_pdd) as Master Data
|
|
INSERT INTO `tb_pdd` (`id_pend`, `nik`, `nama`, `tempat_lh`, `tgl_lh`, `jekel`, `desa`, `rt`, `rw`, `agama`, `kawin`, `pekerjaan`, `status`) VALUES
|
|
(1, '3201010101000001', 'Budi Santoso', 'Bogor', '1980-01-01', 'LK', 'Sukamaju', '01', '02', 'Islam', 'Kawin', 'Karyawan', 'Ada'),
|
|
(2, '3201010101000002', 'Siti Aminah', 'Bogor', '1985-05-05', 'PR', 'Sukamaju', '02', '02', 'Islam', 'Cerai Mati', 'Wiraswasta', 'Ada'),
|
|
(3, '3201010101000003', 'Ani Santoso', 'Bogor', '2005-01-01', 'PR', 'Sukamaju', '01', '02', 'Islam', 'Belum', 'Pelajar', 'Ada'),
|
|
(4, '3201010101000004', 'Ahmad Santoso', 'Bogor', '2008-01-01', 'LK', 'Sukamaju', '01', '02', 'Islam', 'Belum', 'Pelajar', 'Ada'),
|
|
(5, '3201010101000005', 'Dewi Lestari', 'Bandung', '1990-10-10', 'PR', 'Sukamaju', '03', '03', 'Islam', 'Belum', 'Guru', 'Pindah'),
|
|
(6, '3201010101000006', 'Alm. Kakek', 'Jakarta', '1950-01-01', 'LK', 'Sukamaju', '01', '02', 'Islam', 'Cerai Mati', 'Pensiunan', 'Meninggal');
|
|
|
|
-- 3. Insert Anggota Keluarga (tb_anggota)
|
|
INSERT INTO `tb_anggota` (`id_kk`, `id_pend`, `hubungan`) VALUES
|
|
(1, 1, 'Kepala Keluarga'),
|
|
(1, 3, 'Anak'),
|
|
(1, 4, 'Anak'),
|
|
(2, 2, 'Kepala Keluarga');
|
|
|
|
-- 4. Insert Data Lahir (tb_lahir)
|
|
INSERT INTO `tb_lahir` (`nama`, `tgl_lh`, `jekel`, `id_kk`) VALUES
|
|
('Bayi Baru', '2023-10-01', 'LK', 2);
|
|
|
|
-- 5. Insert Data Meninggal (tb_mendu)
|
|
INSERT INTO `tb_mendu` (`id_pdd`, `tgl_mendu`, `sebab`) VALUES
|
|
(6, '2023-01-01', 'Sakit Tua');
|
|
|
|
-- 6. Insert Data Pindah (tb_pindah)
|
|
INSERT INTO `tb_pindah` (`id_pdd`, `tgl_pindah`, `alasan`) VALUES
|
|
(5, '2023-05-20', 'Pekerjaan');
|
|
|
|
-- 7. Insert Data Datang (tb_datang)
|
|
INSERT INTO `tb_datang` (`nik`, `nama_datang`, `jekel`, `tgl_datang`, `pelapor`) VALUES
|
|
('3301010101000099', 'Pendatang Baru', 'LK', '2023-11-15', 1);
|