-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `db_ujs`
--

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

--
-- Table structure for table `tb_menu`
--

CREATE TABLE `tb_menu` (
  `id` int(11) NOT NULL,
  `no_urut` int(11) NOT NULL,
  `menu` varchar(128) NOT NULL,
  `class_menu` varchar(255) NOT NULL,
  `url` varchar(128) NOT NULL,
  `icon` varchar(255) NOT NULL,
  `level` varchar(255) NOT NULL,
  `status` enum('1','0') NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tb_menu`
--

INSERT INTO `tb_menu` (`id`, `no_urut`, `menu`, `class_menu`, `url`, `icon`, `level`, `status`, `created_at`, `updated_at`) VALUES
(10, 1, 'Beranda', '-', '/home', 'fas fa-tachometer-alt', 'Administrator | Operator', '1', '2021-06-21 10:58:10', '2023-06-16 16:53:04'),
(17, 20, 'Logout', '-', 'auth/logout', 'fas fa-sign-out-alt', 'Administrator | Operator', '1', '2021-06-21 13:33:10', '2023-06-16 16:52:51'),
(30, 6, 'Setting', 'has-treeview', '#', 'fas fa-cogs', 'Administrator', '1', '2023-06-10 23:06:44', '2023-06-16 17:36:10'),
(31, 2, 'Santri', '-', '/santri', 'fas fa-users', 'Administrator | Operator', '1', '2023-06-10 23:11:06', '2023-06-26 19:58:55'),
(32, 3, 'Transaksi', '-', '/transaksi', 'fas fa-cash-register', 'Administrator | Operator', '1', '2023-06-10 23:13:39', '2023-06-26 19:58:43'),
(33, 4, 'Scan QRCode', '-', '/scanQRCode', 'fas fa-qrcode', 'Administrator | Operator', '1', '2023-06-27 12:13:45', '2023-06-27 12:13:45');

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

--
-- Table structure for table `tb_menu_sub`
--

CREATE TABLE `tb_menu_sub` (
  `id_subMenu` int(11) NOT NULL,
  `no_urut_subMenu` int(11) NOT NULL,
  `id_menu` int(11) NOT NULL,
  `subMenu` varchar(128) NOT NULL,
  `url_subMenu` varchar(128) NOT NULL,
  `icon_subMenu` varchar(255) NOT NULL,
  `level_subMenu` varchar(255) NOT NULL,
  `status_subMenu` enum('1','0') NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tb_menu_sub`
--

INSERT INTO `tb_menu_sub` (`id_subMenu`, `no_urut_subMenu`, `id_menu`, `subMenu`, `url_subMenu`, `icon_subMenu`, `level_subMenu`, `status_subMenu`, `created_at`, `updated_at`) VALUES
(1, 4, 30, 'Sub-Menu', '/menuSub', 'fas fa-bars', 'Administrator', '1', '2021-09-07 21:57:27', '2023-06-16 17:45:22'),
(2, 3, 30, 'Menu Utama', '/menu', 'fas fa-bars', 'Administrator', '1', '2021-09-07 22:25:09', '2023-06-16 17:43:44'),
(3, 2, 19, 'Pesantren Nurul Ihsan', '/statistik/rekapPesantren', 'fas fa-university', 'Administrator | Operator Lembaga', '1', '2021-09-07 22:27:55', '2021-09-19 08:13:59'),
(4, 6, 19, 'MTs PSA Nurul Ihsan', '/statistik/rekapPSA', 'fas fa-university', 'Administrator | Operator Lembaga', '1', '2021-09-07 22:30:26', '2021-09-19 08:13:11'),
(5, 5, 19, 'MI Nurul Ihsan', '/statistik/rekapMI', 'fas fa-university', 'Administrator | Operator Lembaga', '1', '2021-09-07 22:32:02', '2021-09-19 08:13:21'),
(6, 4, 19, 'RA Nurul Ihsan', '/statistik/rekapRA', 'fas fa-university', 'Administrator | Operator Lembaga', '1', '2021-09-07 22:32:25', '2021-09-19 08:13:30'),
(7, 3, 19, 'DTA Nurul Ihsan', '/statistik/rekapDTA', 'fas fa-university', 'Administrator | Operator Lembaga', '1', '2021-09-07 22:32:49', '2021-09-19 08:13:48'),
(8, 1, 18, 'Data Ustadz', '/auth/under_constructions', 'fas fa-users', 'Administrator | Operator Lembaga', '1', '2021-09-07 22:34:21', '2022-05-03 22:00:19'),
(9, 2, 18, 'Data Santri', '/santri', 'fas fa-users', 'Administrator | Operator Lembaga', '1', '2021-09-07 22:34:55', '2021-09-19 08:12:50'),
(11, 1, 20, 'Statistik Keuangan', '/keuangan', 'fas fa-chart-line', 'Administrator | Operator Keuangan', '1', '2021-09-07 22:41:51', '2022-11-05 10:10:36'),
(12, 2, 20, 'Data Keuangan', '/keuangan/dataKeuangan', 'fas fa-money-check-alt', 'Administrator | Operator Keuangan', '1', '2021-09-07 22:42:15', '2022-11-05 10:11:23'),
(13, 1, 21, 'Izin Jalan', '/auth/under_constructions', 'fas fa-circle', 'Administrator | Operator Lembaga', '1', '2021-09-07 22:42:50', '2022-05-03 22:01:24'),
(14, 2, 21, 'Izin Libur', '/auth/under_constructions', 'fas fa-circle', 'Administrator | Operator Lembaga', '1', '2021-09-07 22:43:12', '2022-05-03 22:01:33'),
(15, 3, 21, 'Kedatangan', '/auth/under_constructions', 'fas fa-circle', 'Administrator | Operator Lembaga', '1', '2021-09-07 22:43:36', '2022-05-03 22:01:45'),
(16, 2, 22, 'Data Pelanggaran', '/auth/under_constructions', 'fas fa-circle', 'Administrator | Operator Lembaga', '1', '2021-09-07 22:50:54', '2022-05-03 22:02:07'),
(17, 3, 22, 'Data Rekam Medik', '/auth/under_constructions', 'fas fa-circle', 'Administrator | Operator Lembaga', '1', '2021-09-07 22:51:22', '2022-05-03 22:02:17'),
(19, 4, 22, 'Data Nilai', '/auth/under_constructions', 'fas fa-circle', 'Administrator | Operator Lembaga', '1', '2021-09-07 22:52:09', '2022-05-03 22:02:28'),
(20, 2, 24, 'Data Calon', '/auth/under_constructions', 'fas fa-user', 'Administrator', '1', '2021-09-07 22:52:47', '2022-05-03 22:02:49'),
(21, 1, 24, 'Daftar Pemilih', '/auth/under_constructions', 'fas fa-users', 'Administrator', '1', '2021-09-07 22:53:14', '2022-05-03 22:02:38'),
(22, 3, 24, 'Perolehan Suara', '/auth/under_constructions', 'fas fa-chart-line', 'Administrator', '1', '2021-09-07 22:54:01', '2022-05-03 22:03:03'),
(23, 1, 26, 'Statistik Pendaftar', '/psbStatistik', 'fas fa-chart-line', 'Administrator | Operator PSB', '1', '2021-09-07 22:56:04', '2022-05-03 18:47:20'),
(24, 2, 26, 'Data Pendaftar', '/psbDaftar', 'fas fa-users', 'Administrator | Operator PSB', '1', '2021-09-07 22:56:47', '2021-09-19 08:09:32'),
(25, 3, 26, 'Data Santri Baru', '/psbDaftar/santriBaru', 'fas fa-users', 'Administrator | Operator PSB', '1', '2021-09-07 22:57:12', '2021-09-19 10:05:23'),
(29, 1, 19, 'YAMINI', '/statistik/yayasan', 'fas fa-university', 'Administrator', '1', '2021-09-10 08:03:32', '2021-09-10 08:03:32'),
(30, 5, 26, 'Data Keuangan', '/psbKeuangan/dataKeuangan', 'fas fa-money-check-alt', 'Administrator | Operator Keuangan', '1', '2021-09-15 14:06:31', '2022-05-06 09:14:38'),
(31, 4, 26, 'Statistik Keuangan', '/psbKeuangan', 'fas fa-chart-line', 'Administrator | Operator Keuangan', '1', '2022-05-03 18:43:48', '2022-05-07 07:36:22'),
(32, 6, 26, 'Data Transaksi', '/psbKeuangan/dataTransaksi', 'fas fa-money-check-alt', 'Administrator | Operator Keuangan', '1', '2022-06-05 12:48:52', '2022-06-05 12:48:52'),
(35, 3, 20, 'Data Transaksi', '/keuangan/dataTransaksi', 'fas fa-money-check-alt', 'Administrator | Operator Keuangan', '1', '2022-11-05 09:55:30', '2022-11-05 10:11:44'),
(36, 4, 20, 'Data Tagihan', '/tagihan', ' fas fa-money-check-alt ', 'Administrator | Operator Keuangan', '1', '2022-11-17 23:00:57', '2022-12-31 20:37:20'),
(38, 1, 30, 'Aplikasi', '/setting', 'fas fa-cogs', 'Administrator', '1', '2023-06-16 17:37:49', '2023-06-16 17:37:49'),
(39, 5, 30, 'Import Data', '/santri/import', 'fas fa-upload', 'Administrator', '1', '2023-06-16 17:38:28', '2023-06-23 07:51:08'),
(40, 2, 30, 'User Management', '/users', 'fas fa-user', 'Administrator', '1', '2023-06-16 17:40:02', '2023-06-16 17:40:02');

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

--
-- Table structure for table `tb_santri`
--

CREATE TABLE `tb_santri` (
  `id` int(11) NOT NULL,
  `no_induk` varchar(30) NOT NULL,
  `nama` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tb_santri`
--

INSERT INTO `tb_santri` (`id`, `no_induk`, `nama`, `created_at`, `updated_at`) VALUES
(24, '12345678', 'Iman Abdul Rohman', '2023-06-27 13:01:11', '2023-06-27 13:01:11'),
(25, '87654321', 'Hamizan Hadi Aiman', '2023-06-27 13:01:11', '2023-06-27 13:01:11');

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

--
-- Table structure for table `tb_setting`
--

CREATE TABLE `tb_setting` (
  `id` int(11) NOT NULL,
  `nama_aplikasi` varchar(255) NOT NULL,
  `logo` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tb_setting`
--

INSERT INTO `tb_setting` (`id`, `nama_aplikasi`, `logo`, `created_at`, `updated_at`) VALUES
(1, 'UANG JAJANKU', '1686758125_8a143d7b8975e3472b5a.png', '2023-06-14 17:28:55', '2023-06-14 22:56:02');

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

--
-- Table structure for table `tb_transaksi`
--

CREATE TABLE `tb_transaksi` (
  `id` int(11) NOT NULL,
  `id_transaksi` varchar(30) NOT NULL,
  `no_induk` varchar(30) NOT NULL,
  `nominal` int(11) NOT NULL,
  `petugas` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tb_transaksi`
--

INSERT INTO `tb_transaksi` (`id`, `id_transaksi`, `no_induk`, `nominal`, `petugas`, `created_at`, `updated_at`) VALUES
(26, '20230627001', '12345678', 600000, 'admin', '2023-06-27 13:01:11', '2023-06-27 13:01:11'),
(27, '20230627002', '87654321', 300000, 'admin', '2023-06-27 13:01:11', '2023-06-27 13:01:11'),
(29, '20230627003', '12345678', -15000, 'admin', '2023-06-27 13:16:30', '2023-06-27 13:16:30'),
(30, '20230627004', '87654321', -20000, 'admin', '2023-06-27 13:17:15', '2023-06-27 13:17:15'),
(31, '20230627005', '12345678', -20000, 'admin', '2023-06-27 13:27:55', '2023-06-27 13:27:55'),
(32, '20230627006', '87654321', -2000, 'admin', '2023-06-27 22:19:01', '2023-06-27 22:19:01'),
(33, '20230627007', '87654321', -20000, 'admin', '2023-06-27 22:34:47', '2023-06-27 22:34:47'),
(42, '20230628008', '12345678', -15000, 'admin', '2023-06-28 05:50:06', '2023-06-28 05:50:06'),
(43, '20230628009', '87654321', -5000, 'admin', '2023-06-28 05:51:01', '2023-06-28 05:51:01'),
(44, '20230628010', '87654321', 2000, 'admin', '2023-06-28 05:51:18', '2023-06-28 05:51:18'),
(45, '20230628011', '87654321', -5000, 'admin', '2023-06-28 05:51:37', '2023-06-28 05:51:37');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `tb_menu`
--
ALTER TABLE `tb_menu`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tb_menu_sub`
--
ALTER TABLE `tb_menu_sub`
  ADD PRIMARY KEY (`id_subMenu`);

--
-- Indexes for table `tb_santri`
--
ALTER TABLE `tb_santri`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tb_setting`
--
ALTER TABLE `tb_setting`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tb_transaksi`
--
ALTER TABLE `tb_transaksi`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tb_menu`
--
ALTER TABLE `tb_menu`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT for table `tb_menu_sub`
--
ALTER TABLE `tb_menu_sub`
  MODIFY `id_subMenu` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;

--
-- AUTO_INCREMENT for table `tb_santri`
--
ALTER TABLE `tb_santri`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `tb_setting`
--
ALTER TABLE `tb_setting`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tb_transaksi`
--
ALTER TABLE `tb_transaksi`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;
COMMIT;

