-- --------------------------------------------------------

--
-- Table structure for table `sys_menu`
--

DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `id` int NOT NULL,
  `menu_parent` int DEFAULT NULL,
  `nama` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `order_no` int DEFAULT NULL,
  `group_menu` int DEFAULT NULL COMMENT '1. applications\r\n2. report\r\n3. systems',
  `icon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `stat` int DEFAULT NULL,
  `syscreateuser` int DEFAULT NULL,
  `syscreatedate` datetime DEFAULT NULL,
  `sysupdateuser` int DEFAULT NULL,
  `sysupdatedate` datetime DEFAULT NULL,
  `sysdeleteuser` int DEFAULT NULL,
  `sysdeletedate` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `sys_menu`
--

INSERT INTO `sys_menu` (`id`, `menu_parent`, `nama`, `link`, `order_no`, `group_menu`, `icon`, `description`, `stat`, `syscreateuser`, `syscreatedate`, `sysupdateuser`, `sysupdatedate`, `sysdeleteuser`, `sysdeletedate`) VALUES
(1, NULL, 'Dashboard', 'Applications/Dashboard/index/', 100, 1, 'fas fa-tachometer-alt', NULL, 1, 1, '2021-03-11 04:07:27', 1, '2021-03-22 16:36:10', 1, '2021-03-11 16:12:09'),
(2, NULL, 'Menu Management', 'Systems/Menu/index/', 300, 3, 'fas fa-bars', NULL, 1, 1, '2021-03-11 04:10:12', NULL, NULL, NULL, NULL),
(3, NULL, 'User Management', 'Systems/Users/index/', 306, 3, 'fas fa-user-cog', NULL, 1, 1, '2021-03-11 15:59:24', NULL, NULL, NULL, NULL),
(4, NULL, 'Permissions', 'Systems/Permissions/index/', 302, 3, 'fas fa-key', NULL, 1, 1, '2021-03-11 16:00:24', NULL, NULL, NULL, NULL),
(5, NULL, 'Systems', 'Systems/index/', 303, 3, 'fas fa-cogs', NULL, 1, 1, '2021-03-11 16:05:08', NULL, NULL, NULL, NULL),
(6, NULL, 'Logout', 'Auth/Logout/', 304, 3, 'fas fa-sign-out-alt', NULL, 0, 1, '2021-03-11 16:10:05', NULL, NULL, 1, '2021-03-11 16:12:30'),
(7, NULL, 'Master Wilayah', 'Master/Wilayah/index/', 101, 1, 'fas fa-globe-asia', NULL, 1, 1, '2021-03-13 12:29:43', 1, '2021-03-21 05:26:35', NULL, NULL),
(8, 7, 'Provinsi', 'Master/Wilayah/Provinsi/index/', 103, 1, '', NULL, 1, 1, '2021-03-13 12:31:34', NULL, NULL, NULL, NULL),
(9, 7, 'Kabupaten', 'Master/Wilayah/Kabupaten/index/', 104, 1, '', NULL, 1, 1, '2021-03-13 19:21:17', NULL, NULL, NULL, NULL),
(10, 7, 'Kecamatan', 'Master/Wilayah/Kecamatan/index/', 105, 1, '', NULL, 1, 1, '2021-03-13 19:22:00', NULL, NULL, NULL, NULL),
(11, 7, 'Kelurahan', 'Master/Wilayah/Kelurahan/index/', 106, 1, '', NULL, 1, 1, '2021-03-13 19:22:30', NULL, NULL, NULL, NULL),
(12, NULL, 'Master Country', 'Master/Country/index/', 102, 1, 'fas fa-globe', NULL, 1, 1, '2021-03-13 19:35:02', NULL, NULL, NULL, NULL),
(13, NULL, 'Menu Group', 'Systems/Menu_group/index/', 301, 3, 'fas fa-th-list', NULL, 1, 1, '2021-03-13 20:23:14', NULL, NULL, NULL, NULL),
(14, NULL, 'e-SBSN', 'Applications/Sekretariat/esbsn/index/', 500, 5, 'fas fa-file-invoice-dollar', NULL, 1, 1, '2021-03-21 04:27:16', 1, '2021-03-21 05:28:06', NULL, NULL),
(15, 14, 'SATKER', 'Applications/Sekretariat/Satker/index/', 505, 5, '', NULL, 1, 1, '2021-03-21 04:29:56', 1, '2021-03-21 04:32:11', NULL, NULL),
(16, NULL, 'SIHAT', 'Applications/Binsyar/Simas/index/', 603, 6, 'fas fa-toolbox', NULL, 1, 1, '2021-03-21 04:35:24', 1, '2021-03-21 04:44:14', NULL, NULL),
(17, 16, 'Alat Hisab Rukyat', 'Applications/Binsyar/Sihat/index/', 609, 6, '', NULL, 1, 1, '2021-03-21 04:37:00', NULL, NULL, NULL, NULL),
(18, NULL, 'BIMWIN', 'Application/Bimwin/index/', 710, 7, 'fas fa-ring', NULL, 1, 1, '2021-03-21 04:48:11', 1, '2021-03-23 13:28:15', NULL, NULL),
(19, 18, 'Target Catin', 'Applications/Bimwin/Target/index/', 702, 7, '', NULL, 1, 1, '2021-03-21 04:49:32', 1, '2021-03-23 13:34:12', NULL, NULL),
(20, NULL, 'Simpenais', 'Simpenais', 801, 8, 'far fa-lightbulb', NULL, 1, 1, '2021-03-21 04:55:16', NULL, NULL, NULL, NULL),
(21, 20, 'Penyuluh PNS', 'Applications/PAI/Pns/index/', 805, 8, '', NULL, 1, 1, '2021-03-21 04:57:48', NULL, NULL, NULL, NULL),
(22, NULL, 'Wakaf', 'Applications/Siwak/Wakaf/index/', 900, 9, 'fas fa-hand-holding-heart', NULL, 1, 1, '2021-03-21 04:59:40', 1, '2021-03-24 00:48:48', NULL, NULL),
(23, 14, 'Usulan Triwulan', 'Applications/Sekretariat/Usulan/index/', 502, 5, '', NULL, 1, 1, '2021-03-21 05:17:23', NULL, NULL, NULL, NULL),
(24, 14, 'input Triwulan', 'Applications/Sekretariat/Input/index/', 503, 5, '', NULL, 1, 1, '2021-03-21 05:19:17', NULL, NULL, NULL, NULL),
(25, 14, 'Approved Usulan', 'Applications/Sekretariat/Approved/index/', 504, 5, '', NULL, 1, 1, '2021-03-21 05:20:34', 1, '2021-03-21 05:21:16', NULL, NULL),
(26, NULL, 'SICAKEP', 'Applications/Sekretariat/Sicakep/index/', 501, 5, 'fas fa-chart-line', NULL, 1, 1, '2021-03-21 05:22:15', 1, '2021-03-21 05:27:43', NULL, NULL),
(27, 26, 'Data Pegawai', 'Applications/Sekretariat/Pegawai/index/', 507, 5, '', NULL, 1, 1, '2021-03-21 05:31:32', 1, '2021-03-22 17:45:51', NULL, NULL),
(28, 26, 'Data Pensiun', 'Applications/Sekretariat/Pensiun/index/', 506, 5, '', NULL, 1, 1, '2021-03-21 05:33:40', NULL, NULL, NULL, NULL),
(29, 16, 'Tenaga Ahli', 'Applications/Binsyar/Ahli/index/', 608, 6, '', NULL, 1, 1, '2021-03-21 05:35:09', NULL, NULL, NULL, NULL),
(30, 16, 'Hisab Pengukuran', 'Applications/Binsyar/Pengukuran/index/', 607, 6, '', NULL, 1, 1, '2021-03-21 05:48:18', NULL, NULL, NULL, NULL),
(31, 16, 'Hisab Lokasi', 'Applications/Binsyar/Lokasi/index/', 606, 6, '', NULL, 1, 1, '2021-03-21 05:50:05', 1, '2021-03-21 05:51:54', NULL, NULL),
(32, 16, 'Hisab Laporan', 'Applications/Binsyar/Laporan/index/', 604, 6, '', NULL, 1, 1, '2021-03-21 05:52:39', NULL, NULL, NULL, NULL),
(33, 16, 'Lintang Kota', 'Applications/Binsyar/Lintang/index/', 605, 6, '', NULL, 1, 1, '2021-03-21 05:53:49', NULL, NULL, NULL, NULL),
(34, NULL, 'SIMAS', 'Applications/Binsyar/Simas/index/', 602, 6, 'fas fa-mosque', 'menu untuk aplikasi simas / informasi data masjid', 1, 1, '2021-03-21 05:55:33', 1, '2021-09-13 00:02:19', NULL, NULL),
(35, 34, 'Data Masjid', 'Applications/Binsyar/Simas/index/', 611, 6, '', NULL, 1, 1, '2021-03-21 05:56:40', NULL, NULL, NULL, NULL),
(36, 34, 'Data Mushalla', 'Applications/Binsyar/Mushalla/index/', 610, 6, '', NULL, 1, 1, '2021-03-21 05:58:14', 1, '2021-03-21 05:59:06', NULL, NULL),
(37, 34, 'Masjid Tipologi', 'Applications/Binsyar/Tipologi/Masjid/', 612, 6, '', NULL, 1, 1, '2021-03-21 06:00:24', 1, '2021-03-23 12:29:56', NULL, NULL),
(38, 34, 'Mushalla Tipologi', 'Applications/Binsyar/Tipologi/Mushalla/', 613, 6, '', NULL, 1, 1, '2021-03-21 06:01:42', 1, '2021-03-23 12:33:15', NULL, NULL),
(39, 18, 'Data Catin', 'Applications/Bimwin/Catin/index/', 703, 7, '', NULL, 1, 1, '2021-03-23 12:37:52', 1, '2021-03-23 12:40:32', NULL, NULL),
(40, 18, 'Fasilitator Bimwin', 'Applications/Bimwin/Fasilitator/index/', 704, 7, '', NULL, 1, 1, '2021-03-23 12:42:04', 1, '2021-03-23 12:42:40', NULL, NULL),
(41, 20, 'Penyuluh non-PNS', 'Applications/PAI/N_pns/index/', 806, 8, '', NULL, 1, 1, '2021-03-23 18:46:08', NULL, NULL, NULL, NULL),
(42, 20, 'Majelis Taklim', 'Applications/PAI/Majelis/index/', 807, 8, '', NULL, 1, 1, '2021-03-23 18:54:58', 1, '2021-03-23 19:08:43', NULL, NULL),
(43, 20, 'Seni Islam', 'Applications/PAI/Seni_Islam/index/', 808, 8, '', NULL, 1, 1, '2021-03-23 19:10:56', NULL, NULL, NULL, NULL),
(44, 20, 'Lembaga Dakwah', 'Applications/PAI/Dakwah/index/', 809, 8, '', NULL, 1, 1, '2021-03-23 19:47:22', NULL, NULL, NULL, NULL),
(45, 20, 'Ormas Islam', 'Applications/PAI/Ormas/index/', 810, 8, '', NULL, 1, 1, '2021-03-23 20:01:19', NULL, NULL, NULL, NULL),
(46, 20, 'Dewan Hakim', 'Applications/PAI/Dewan/index/', 804, 8, '', NULL, 1, 1, '2021-03-23 20:12:06', NULL, NULL, NULL, NULL),
(47, 20, 'Guru Ngaji', 'Applications/PAI/Guru_ngaji/index/', 811, 8, '', NULL, 1, 1, '2021-03-23 20:30:16', NULL, NULL, NULL, NULL),
(48, 20, 'L P T Q', 'Applications/PAI/LPTQ/index/', 812, 8, '', NULL, 1, 1, '2021-03-23 20:35:23', NULL, NULL, NULL, NULL),
(49, 20, 'Hafidz', 'Applications/PAI/Hafiz/index/', 813, 8, '', NULL, 1, 1, '2021-03-23 20:45:03', NULL, NULL, NULL, NULL),
(50, 20, 'Qari', 'Applications/PAI/Qari/index/', 814, 8, '', NULL, 1, 1, '2021-03-23 20:57:45', NULL, NULL, NULL, NULL),
(51, 20, 'Mufassir', 'Applications/PAI/Mufassir/index/', 815, 8, '', NULL, 1, 1, '2021-03-23 21:15:13', NULL, NULL, NULL, NULL),
(52, 20, 'Kaligrafer', 'Applications/PAI/Kaligrafer/index/', 803, 8, '', NULL, 1, 1, '2021-03-23 21:30:04', NULL, NULL, NULL, NULL),
(53, 20, 'Seniman Islam', 'Applications/PAI/Seniman/index/', 816, 8, '', NULL, 1, 1, '2021-03-23 21:41:07', NULL, NULL, NULL, NULL),
(54, 20, 'Budayawan Islam', 'Applications/PAI/Budayawan/index/', 817, 8, '', NULL, 1, 1, '2021-03-23 23:55:11', NULL, NULL, NULL, NULL),
(55, 20, 'Radio Islam', 'Applications/PAI/Radio_Islam/index/', 818, 8, '', NULL, 1, 1, '2021-03-24 00:05:52', NULL, NULL, NULL, NULL),
(56, 20, 'Penulis Islam', 'Applications/PAI/Penulis/index/', 819, 8, '', NULL, 1, 1, '2021-03-24 00:16:17', NULL, NULL, NULL, NULL),
(57, NULL, 'e-PAI', 'Applications/PAI/Epai/index/', 800, 8, 'fas fa-bullhorn', NULL, 1, 1, '2021-03-24 00:26:03', 1, '2021-03-24 00:26:52', NULL, NULL),
(58, NULL, 'e-Monev', 'Applications/Emonev/index/', 700, 7, 'fas fa-chalkboard-teacher', NULL, 1, 1, '2021-03-24 12:51:34', NULL, NULL, NULL, NULL),
(59, 58, 'Rekap Data KUA', 'Applications/Emonev/Rekap_kua/index/', 719, 7, '', NULL, 1, 1, '2021-03-24 12:53:33', 1, '2021-03-24 13:24:11', NULL, NULL),
(60, 58, 'Tipologi KUA', 'Applications/Emonev/Tipologi/index/', 711, 7, '', NULL, 1, 1, '2021-03-24 13:35:22', NULL, NULL, NULL, NULL),
(61, 58, 'Status Tanah KUA', 'Applications/Emonev/Tanah/index/', 712, 7, '', NULL, 1, 1, '2021-03-24 13:57:27', NULL, NULL, NULL, NULL),
(62, 58, 'Rekapitulasi Penilaian KUA', 'Applications/Emonev/Penilaian/index/', 713, 7, '', NULL, 1, 1, '2021-03-24 14:10:11', NULL, NULL, NULL, NULL),
(63, 58, 'Rekapitulasi Data KUA', 'Applications/Emonev/Rekap/index/', 714, 7, '', NULL, 1, 1, '2021-03-24 15:42:59', NULL, NULL, NULL, NULL),
(64, 58, 'Rekap Isian KUA', 'Applications/Emonev/Isian/index/', 715, 7, '', NULL, 1, 1, '2021-03-24 15:47:46', NULL, NULL, NULL, NULL),
(65, 58, 'Status Bangunan KUA', 'Applications/Emonev/Bangunan/index/', 716, 7, '', NULL, 1, 1, '2021-03-24 15:51:50', NULL, NULL, NULL, NULL),
(66, 58, 'Penggunaan SIMKAH', 'Applications/Emonev/Simkah/index/', 717, 7, '', NULL, 1, 1, '2021-03-24 16:00:24', NULL, NULL, NULL, NULL),
(67, 58, 'Rekapitulasi Registrasi', 'Applications/Emonev/Registrasi/index/', 718, 7, '', NULL, 1, 1, '2021-03-24 16:26:19', NULL, NULL, NULL, NULL),
(68, NULL, 'Simpenghulu', 'Applications/Simpenghulu/index/', 705, 7, 'fas fa-handshake', NULL, 1, 1, '2021-03-24 16:38:58', NULL, NULL, NULL, NULL),
(69, 68, 'Data KUA', 'Applications/Simpenghulu/KUA/index/', 706, 7, '', NULL, 1, 1, '2021-03-24 16:40:36', NULL, NULL, NULL, NULL),
(70, 68, 'Data Penghulu', 'Applications/Simpenghulu/Penghulu/index/', 707, 7, '', NULL, 1, 1, '2021-03-25 09:52:18', NULL, NULL, NULL, NULL),
(71, 68, 'Peristiwa Nikah', 'Applications/Simpenghulu/Peristiwa/index/', 708, 7, '', NULL, 1, 1, '2021-03-25 10:02:48', NULL, NULL, NULL, NULL),
(72, 68, ' Rekapitulasi Nikah & Rujuk', 'Applications/Simpenghulu/Nikah_Rujuk/index/', 709, 7, '', NULL, 1, 1, '2021-03-25 10:16:55', NULL, NULL, NULL, NULL),
(73, NULL, 'Blocked Account', 'Systems/Locked/index/', 305, 3, 'fas fa-lock', NULL, 1, 1, '2021-06-19 22:10:30', NULL, NULL, NULL, NULL),
(74, NULL, 'SIMKAH', 'Applications/Simkah/index/?year=0', 701, 7, 'fas fa-ring', NULL, 1, 15068, '2021-08-09 23:40:38', 15068, '2021-08-10 00:32:03', NULL, NULL),
(75, NULL, 'Simzat', 'Simzat', 901, 9, 'fas fa-hands-helping', NULL, 1, 1, '2021-08-10 10:43:33', NULL, NULL, NULL, NULL),
(76, 75, 'Baznas', 'Applications/Simzat/Baznas/index/', 902, 9, '', NULL, 1, 1, '2021-08-10 10:44:47', 1, '2021-08-11 10:16:14', NULL, NULL),
(77, 75, 'Laznas', 'Applications/Simzat/Laznas/index/', 903, 9, '', NULL, 1, 1, '2021-08-10 10:45:18', 1, '2021-08-11 10:16:40', NULL, NULL),
(78, NULL, 'M T Q', 'Applications/Mtq/index/', 802, 8, 'fas fa-quran', NULL, 1, 1, '2021-08-10 13:57:54', 1, '2021-08-10 16:04:03', NULL, NULL),
(79, NULL, 'PUSBIM', 'Applications/Binsyar/Pustaka/index/', 601, 6, 'fas fa-archway', NULL, 1, 1, '2021-08-11 18:48:22', NULL, NULL, NULL, NULL),
(80, NULL, 'SIPAHAM', 'Applications/Sipaham/index/', 600, 6, 'fas fa-peace', NULL, 1, 1, '2021-09-03 09:56:10', NULL, NULL, NULL, NULL),
(81, NULL, 'Parameter', 'Systems/Parameter/index/', 307, 3, 'fas fa-code-branch', 'menu untuk fungsi parameter sistem', 1, 15068, '2022-01-25 11:00:57', NULL, NULL, NULL, NULL);