-- https://www.phpmyadmin.net/
--
-- Waktu pembuatan: 26 Nov 2025 pada 12.15
-- Versi server: 10.1.37-MariaDB
-- Versi PHP: 7.3.0

START TRANSACTION;



--
-- Database: `ohdeqzjq_rohismanager`
--

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

--
-- Struktur dari tabel `app_logs`
--

CREATE TABLE `app_logs` (
  `log_id` int(11) NOT NULL,
  `Timestamp` varchar(255) DEFAULT NULL,
  `Action` varchar(255) DEFAULT NULL,
  `TableName` varchar(255) DEFAULT NULL,
  `RecordID` varchar(255) DEFAULT NULL,
  `SqlQuery` varchar(255) DEFAULT NULL,
  `UserID` varchar(255) DEFAULT NULL,
  `ServerIP` varchar(255) DEFAULT NULL,
  `RequestUrl` text,
  `RequestData` text,
  `RequestCompleted` varchar(255) DEFAULT NULL,
  `RequestMsg` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `app_logs`
--

INSERT INTO `app_logs` (`log_id`, `Timestamp`, `Action`, `TableName`, `RecordID`, `SqlQuery`, `UserID`, `ServerIP`, `RequestUrl`, `RequestData`, `RequestCompleted`, `RequestMsg`) VALUES
(1176, '2025-11-11 06:19:57', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '::1', 'index/login/', '{\"username\":\"admin\",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\"}', 'true', NULL),
(1177, '2025-11-11 06:20:12', 'userlogout', 'user', NULL, NULL, '2', '::1', 'index/logout', '[]', 'true', NULL),
(1178, '2025-11-11 06:21:11', 'add', 'user', '78', 'INSERT INTO user (`username`, `email`, `password`)  VALUES (?, ?, ?)', NULL, '::1', 'index/register', '{\"username\":\"user\",\"email\":\"user@gmail.com\",\"password\":\"$2y$10$rFJMEZFEj7knRxrRyAqPsuk1SQ805aDhgm3n0eEEcvyLsT\\/1gDZdS\"}', 'true', NULL),
(1179, '2025-11-11 06:21:11', 'userlogin', 'user', '78', 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '78', '::1', 'index/register', '{\"username\":\"user\",\"email\":\"user@gmail.com\",\"password\":\"$2y$10$rFJMEZFEj7knRxrRyAqPsuk1SQ805aDhgm3n0eEEcvyLsT\\/1gDZdS\"}', 'true', NULL),
(1180, '2025-11-11 06:24:23', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '78', '::1', 'index/login/', '{\"username\":\"user\",\"password\":\"$2y$10$rFJMEZFEj7knRxrRyAqPsuk1SQ805aDhgm3n0eEEcvyLsT\\/1gDZdS\"}', 'true', NULL),
(1181, '2025-11-11 06:26:06', 'userlogout', 'user', NULL, NULL, '78', '::1', 'index/logout', '[]', 'true', NULL),
(1182, '2025-11-11 06:26:34', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '::1', 'index/login/', '{\"username\":\"admin\",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\"}', 'true', NULL),
(1183, '2025-11-11 06:27:54', 'add', 'user', '79', 'INSERT INTO user (`username`, `email`, `password`, `role`, `jabatan`)  VALUES (?, ?, ?, ?, ?)', '2', '::1', 'user/add', '{\"username\":\"aji\",\"email\":\"fajri13shd@gmail.com\",\"password\":\"$2y$10$kZMIVPPxYU1rLOuoSvd8XOJdcrwFbd7UnPLcbAftSP0Ll2\\/TbOhou\",\"role\":\"Pengurus\",\"jabatan\":\"DKM\"}', 'true', NULL),
(1184, '2025-11-11 06:27:58', 'userlogout', 'user', NULL, NULL, '2', '::1', 'index/logout', '[]', 'true', NULL),
(1185, '2025-11-11 06:28:01', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '79', '::1', 'index/login/', '{\"username\":\"aji\",\"password\":\"$2y$10$kZMIVPPxYU1rLOuoSvd8XOJdcrwFbd7UnPLcbAftSP0Ll2\\/TbOhou\"}', 'true', NULL),
(1186, '2025-11-13 10:45:26', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '114.10.73.63', 'index/login/', '{\"username\":\"admin\",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\"}', 'true', NULL),
(1187, '2025-11-13 10:45:53', 'userlogout', 'user', NULL, NULL, '2', '114.10.73.63', 'index/logout', '[]', 'true', NULL),
(1188, '2025-11-13 10:46:12', 'add', 'user', '80', 'INSERT INTO user (`username`, `email`, `password`)  VALUES (?, ?, ?)', NULL, '114.10.73.63', 'index/register', '{\"username\":\"user2\",\"email\":\"user2@gmail.com\",\"password\":\"$2y$10$txg\\/yZLUl\\/7Gaj4MP9KqZOj1OBvVvWxkMkruL3XzvsisMxxgRmPG.\"}', 'true', NULL),
(1189, '2025-11-13 10:46:12', 'userlogin', 'user', '80', 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '80', '114.10.73.63', 'index/register', '{\"username\":\"user2\",\"email\":\"user2@gmail.com\",\"password\":\"$2y$10$txg\\/yZLUl\\/7Gaj4MP9KqZOj1OBvVvWxkMkruL3XzvsisMxxgRmPG.\"}', 'true', NULL),
(1190, '2025-11-13 10:47:56', 'delete', 'user', '79', 'DELETE FROM user WHERE  user.id_user in ( ? ) ', '80', '114.10.73.63', 'user/delete/79/', '[]', 'true', NULL),
(1191, '2025-11-13 10:48:00', 'userlogout', 'user', NULL, NULL, '80', '114.10.73.63', 'index/logout', '[]', 'true', NULL),
(1192, '2025-11-13 10:48:25', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '78', '114.10.73.63', 'index/login/', '{\"username\":\"user@gmail.com\",\"password\":\"$2y$10$rFJMEZFEj7knRxrRyAqPsuk1SQ805aDhgm3n0eEEcvyLsT\\/1gDZdS\"}', 'true', NULL),
(1193, '2025-11-13 10:49:08', 'userlogout', 'user', NULL, NULL, '78', '114.10.73.63', 'index/logout', '[]', 'true', NULL),
(1194, '2025-11-13 10:50:35', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '114.10.73.63', 'index/login/', '{\"username\":\"admin\",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\"}', 'true', NULL),
(1195, '2025-11-13 10:51:04', 'edit', 'kas', '21', 'UPDATE kas SET `jumlah_kas` = ?, `jenis_kas` = ?, `deskripsi` = ? WHERE  kas.id_kas = ? ', '2', '114.10.73.63', 'kas/edit/21/', '{\"jumlah_kas\":\"50.000\",\"jenis_kas\":\"Pemasukan\",\"deskripsi\":\"\"}', 'true', NULL),
(1196, '2025-11-13 10:51:29', 'edit', 'kas', '21', 'UPDATE kas SET `jumlah_kas` = ?, `jenis_kas` = ?, `deskripsi` = ? WHERE  kas.id_kas = ? ', '2', '114.10.73.63', 'kas/edit/21/', '{\"jumlah_kas\":\"50000\",\"jenis_kas\":\"Pemasukan\",\"deskripsi\":\"\"}', 'true', NULL),
(1197, '2025-11-13 10:52:20', 'view', 'jabatan', '12', 'SELECT   id_jabatan, nama_jabatan FROM jabatan WHERE  jabatan.id_jabatan = ?  LIMIT 1', '2', '114.10.73.63', 'jabatan/view/12', '[]', 'true', NULL),
(1198, '2025-11-13 10:52:25', 'view', 'jabatan', '12', 'SELECT   id_jabatan, nama_jabatan FROM jabatan WHERE  jabatan.id_jabatan = ?  LIMIT 1', '2', '114.10.73.63', 'jabatan/view/12', '[]', 'true', NULL),
(1199, '2025-11-13 10:52:38', 'view', 'user', '80', 'SELECT   id_user, username, role, jabatan FROM user WHERE  user.id_user = ?  LIMIT 1', '2', '114.10.73.63', 'user/view/80', '[]', 'true', NULL),
(1200, '2025-11-13 10:52:42', 'view', 'user', '78', 'SELECT   id_user, username, role, jabatan FROM user WHERE  user.id_user = ?  LIMIT 1', '2', '114.10.73.63', 'user/view/78', '[]', 'true', NULL),
(1201, '2025-11-13 10:59:30', 'edit', 'user', '2', 'UPDATE user SET `username` = ?, `email` = ?, `photo` = ? WHERE  user.id_user = ? ', '2', '114.10.73.63', 'account/edit//', '{\"username\":\"admin\",\"email\":\"admin@gmail.com\",\"photo\":\"http:\\/\\/localhost\\/rohismanager\\/uploads\\/files\\/4jlfgzxvoq2d1mn.png\"}', 'true', NULL),
(1202, '2025-11-13 04:31:36', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '78', '182.3.36.192', 'index/login/', '{\"username\":\"user\",\"password\":\"$2y$10$rFJMEZFEj7knRxrRyAqPsuk1SQ805aDhgm3n0eEEcvyLsT\\/1gDZdS\"}', 'true', NULL),
(1203, '2025-11-13 04:31:58', 'userlogout', 'user', NULL, NULL, '78', '182.3.36.192', 'index/logout', '[]', 'true', NULL),
(1204, '2025-11-13 04:32:06', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '182.3.36.192', 'index/login/', '{\"username\":\"admin\",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\"}', 'true', NULL),
(1205, '2025-11-13 05:28:19', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '78', '182.3.36.192', 'index/login/', '{\"username\":\"user@gmail.com\",\"password\":\"$2y$10$rFJMEZFEj7knRxrRyAqPsuk1SQ805aDhgm3n0eEEcvyLsT\\/1gDZdS\"}', 'true', NULL),
(1206, '2025-11-13 05:30:46', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '182.3.36.192', 'index/login/', '{\"username\":\"admin@gmail.com\",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\"}', 'true', NULL),
(1207, '2025-11-13 05:31:07', 'delete', 'pengumuman', '26', 'DELETE FROM pengumuman WHERE  pengumuman.id_pengumuman in ( ? ) ', '2', '182.3.36.192', 'pengumuman/delete/26/', '[]', 'true', NULL),
(1208, '2025-11-13 05:31:10', 'delete', 'pengumuman', '24', 'DELETE FROM pengumuman WHERE  pengumuman.id_pengumuman in ( ? ) ', '2', '182.3.36.192', 'pengumuman/delete/24/', '[]', 'true', NULL),
(1209, '2025-11-13 05:31:24', 'delete', 'kegiatan', '28', 'DELETE FROM kegiatan WHERE  kegiatan.id_kegiatan in ( ? ) ', '2', '182.3.36.192', 'kegiatan/delete/28/', '[]', 'true', NULL),
(1210, '2025-11-13 05:31:28', 'delete', 'kegiatan', '27', 'DELETE FROM kegiatan WHERE  kegiatan.id_kegiatan in ( ? ) ', '2', '182.3.36.192', 'kegiatan/delete/27/', '[]', 'true', NULL),
(1211, '2025-11-13 05:31:31', 'delete', 'kegiatan', '26', 'DELETE FROM kegiatan WHERE  kegiatan.id_kegiatan in ( ? ) ', '2', '182.3.36.192', 'kegiatan/delete/26/', '[]', 'true', NULL),
(1212, '2025-11-13 05:31:33', 'delete', 'kegiatan', '25', 'DELETE FROM kegiatan WHERE  kegiatan.id_kegiatan in ( ? ) ', '2', '182.3.36.192', 'kegiatan/delete/25/', '[]', 'true', NULL),
(1213, '2025-11-13 05:31:35', 'delete', 'kegiatan', '23', 'DELETE FROM kegiatan WHERE  kegiatan.id_kegiatan in ( ? ) ', '2', '182.3.36.192', 'kegiatan/delete/23/', '[]', 'true', NULL),
(1214, '2025-11-13 05:32:32', 'add', 'kegiatan', '34', 'INSERT INTO kegiatan (`username`, `nama_kegiatan`, `lokasi_kegiatan`, `deskripsi_kegiatan`, `kategori_kegiatan`, `tanggal_kegiatan`)  VALUES (?, ?, ?, ?, ?, ?)', '2', '182.3.36.192', 'kegiatan/add', '{\"username\":\"admin\",\"nama_kegiatan\":\"Hadroh \",\"lokasi_kegiatan\":\"Masjid SMKN 46 JAKARTA \",\"deskripsi_kegiatan\":\"Latihan \",\"kategori_kegiatan\":\"Latihan\",\"tanggal_kegiatan\":\"2025-11-10 15:45:00\"}', 'true', NULL),
(1215, '2025-11-13 05:33:22', 'add', 'kegiatan', '35', 'INSERT INTO kegiatan (`username`, `nama_kegiatan`, `lokasi_kegiatan`, `deskripsi_kegiatan`, `kategori_kegiatan`, `tanggal_kegiatan`)  VALUES (?, ?, ?, ?, ?, ?)', '2', '182.3.36.192', 'kegiatan/add', '{\"username\":\"admin\",\"nama_kegiatan\":\"Tibar \",\"lokasi_kegiatan\":\"Masjid SMKN 46 JAKARTA \",\"deskripsi_kegiatan\":\"Tilawah bareng \",\"kategori_kegiatan\":\"Kegiatan\",\"tanggal_kegiatan\":\"2025-11-11 15:45:00\"}', 'true', NULL),
(1216, '2025-11-13 05:33:38', 'delete', 'kas', '28', 'DELETE FROM kas WHERE  kas.id_kas in ( ? ) ', '2', '182.3.36.192', 'kas/delete/28/', '[]', 'true', NULL),
(1217, '2025-11-13 05:33:47', 'delete', 'kas', '21', 'DELETE FROM kas WHERE  kas.id_kas in ( ? ) ', '2', '182.3.36.192', 'kas/delete/21/', '[]', 'true', NULL),
(1218, '2025-11-13 05:33:51', 'delete', 'kas', '22', 'DELETE FROM kas WHERE  kas.id_kas in ( ? ) ', '2', '182.3.36.192', 'kas/delete/22/', '[]', 'true', NULL),
(1219, '2025-11-13 05:33:55', 'delete', 'kas', '23', 'DELETE FROM kas WHERE  kas.id_kas in ( ? ) ', '2', '182.3.36.192', 'kas/delete/23/', '[]', 'true', NULL),
(1220, '2025-11-13 05:34:02', 'delete', 'kas', '24', 'DELETE FROM kas WHERE  kas.id_kas in ( ? ) ', '2', '182.3.36.192', 'kas/delete/24/', '[]', 'true', NULL),
(1221, '2025-11-13 05:34:06', 'delete', 'kas', '25', 'DELETE FROM kas WHERE  kas.id_kas in ( ? ) ', '2', '182.3.36.192', 'kas/delete/25/', '[]', 'true', NULL),
(1222, '2025-11-13 05:34:10', 'delete', 'kas', '26', 'DELETE FROM kas WHERE  kas.id_kas in ( ? ) ', '2', '182.3.36.192', 'kas/delete/26/', '[]', 'true', NULL),
(1223, '2025-11-13 05:34:14', 'delete', 'kas', '27', 'DELETE FROM kas WHERE  kas.id_kas in ( ? ) ', '2', '182.3.36.192', 'kas/delete/27/', '[]', 'true', NULL),
(1224, '2025-11-13 05:35:26', 'edit', 'inventaris', '36', 'UPDATE inventaris SET `nama_barang` = ?, `jumlah_barang` = ?, `status_barang` = ?, `username` = ?, `tanggal_masuk` = ? WHERE  inventaris.id_barang = ? ', '2', '182.3.36.192', 'inventaris/edit/36/', '{\"nama_barang\":\"Vacuum Cleaner\",\"jumlah_barang\":\"1\",\"status_barang\":\"Baik\",\"username\":\"Fajri\",\"tanggal_masuk\":\"2025-04-26 10:32:16\"}', 'true', NULL),
(1225, '2025-11-13 05:35:53', 'edit', 'inventaris', '35', 'UPDATE inventaris SET `nama_barang` = ?, `jumlah_barang` = ?, `status_barang` = ?, `username` = ?, `tanggal_masuk` = ? WHERE  inventaris.id_barang = ? ', '2', '182.3.36.192', 'inventaris/edit/35/', '{\"nama_barang\":\"Kipas\",\"jumlah_barang\":\"3\",\"status_barang\":\"Baik\",\"username\":\"Fajri\",\"tanggal_masuk\":\"2025-04-26 10:32:02\"}', 'true', NULL),
(1226, '2025-11-13 05:36:29', 'delete', 'inventaris', '37', 'DELETE FROM inventaris WHERE  inventaris.id_barang in ( ? ) ', '2', '182.3.36.192', 'inventaris/delete/37/', '[]', 'true', NULL),
(1227, '2025-11-13 05:36:34', 'delete', 'inventaris', '36', 'DELETE FROM inventaris WHERE  inventaris.id_barang in ( ? ) ', '2', '182.3.36.192', 'inventaris/delete/36/', '[]', 'true', NULL),
(1228, '2025-11-13 05:36:41', 'delete', 'inventaris', '35', 'DELETE FROM inventaris WHERE  inventaris.id_barang in ( ? ) ', '2', '182.3.36.192', 'inventaris/delete/35/', '[]', 'true', NULL),
(1229, '2025-11-13 05:37:45', 'delete', 'inventaris', '34', 'DELETE FROM inventaris WHERE  inventaris.id_barang in ( ? ) ', '2', '182.3.36.192', 'inventaris/delete/34/', '[]', 'true', NULL),
(1230, '2025-11-13 05:38:10', 'add', 'inventaris', '38', 'INSERT INTO inventaris (`nama_barang`, `jumlah_barang`, `status_barang`, `username`, `tanggal_masuk`)  VALUES (?, ?, ?, ?, ?)', '2', '182.3.36.192', 'inventaris/add', '{\"nama_barang\":\"Sapu\",\"jumlah_barang\":\"5\",\"status_barang\":\"Baik\",\"username\":\"admin\",\"tanggal_masuk\":\"2025-11-13 05:36:00\"}', 'true', NULL),
(1231, '2025-11-13 05:38:53', 'add', 'inventaris', '39', 'INSERT INTO inventaris (`nama_barang`, `jumlah_barang`, `status_barang`, `username`, `tanggal_masuk`)  VALUES (?, ?, ?, ?, ?)', '2', '182.3.36.192', 'inventaris/add', '{\"nama_barang\":\"Kipas\",\"jumlah_barang\":\"3\",\"status_barang\":\"Baik\",\"username\":\"admin\",\"tanggal_masuk\":\"2025-11-13 12:40:00\"}', 'true', NULL),
(1232, '2025-11-13 05:39:48', 'add', 'inventaris', '40', 'INSERT INTO inventaris (`nama_barang`, `jumlah_barang`, `status_barang`, `username`, `tanggal_masuk`)  VALUES (?, ?, ?, ?, ?)', '2', '182.3.36.192', 'inventaris/add', '{\"nama_barang\":\"Pel Lantai\",\"jumlah_barang\":\"2\",\"status_barang\":\"Baik\",\"username\":\"admin\",\"tanggal_masuk\":\"2025-11-13 12:40:00\"}', 'true', NULL),
(1233, '2025-11-13 05:40:24', 'add', 'inventaris', '41', 'INSERT INTO inventaris (`nama_barang`, `jumlah_barang`, `status_barang`, `username`, `tanggal_masuk`)  VALUES (?, ?, ?, ?, ?)', '2', '182.3.36.192', 'inventaris/add', '{\"nama_barang\":\"Karpet Masjid\",\"jumlah_barang\":\"5\",\"status_barang\":\"Baik\",\"username\":\"admin\",\"tanggal_masuk\":\"2025-11-13 12:40:00\"}', 'true', NULL),
(1234, '2025-11-13 05:41:41', 'delete', 'user', '16', 'DELETE FROM user WHERE  user.id_user in ( ? ) ', '2', '182.3.36.192', 'user/delete/16/', '[]', 'true', NULL),
(1235, '2025-11-13 05:41:59', 'delete', 'user', '77', 'DELETE FROM user WHERE  user.id_user in ( ? ) ', '2', '182.3.36.192', 'user/delete/77/', '[]', 'true', NULL),
(1236, '2025-11-13 05:42:07', 'delete', 'user', '80', 'DELETE FROM user WHERE  user.id_user in ( ? ) ', '2', '182.3.36.192', 'user/delete/80/', '[]', 'true', NULL),
(1237, '2025-11-13 05:42:21', 'userlogout', 'user', NULL, NULL, '2', '182.3.36.192', 'index/logout', '[]', 'true', NULL),
(1238, '2025-11-13 05:43:41', 'add', 'user', '81', 'INSERT INTO user (`username`, `email`, `password`)  VALUES (?, ?, ?)', NULL, '182.3.36.192', 'index/register', '{\"username\":\"Aji\",\"email\":\"fajri13shd@gmail.com\",\"password\":\"$2y$10$5yXCduwXnGfjHUyMyip60u3B\\/MiLJ3BiGgVt2mBcrAIH.OsX3Xlgu\"}', 'true', NULL),
(1239, '2025-11-13 05:43:41', 'userlogin', 'user', '81', 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '81', '182.3.36.192', 'index/register', '{\"username\":\"Aji\",\"email\":\"fajri13shd@gmail.com\",\"password\":\"$2y$10$5yXCduwXnGfjHUyMyip60u3B\\/MiLJ3BiGgVt2mBcrAIH.OsX3Xlgu\"}', 'true', NULL),
(1240, '2025-11-13 05:45:34', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '182.3.36.192', 'index/login/', '{\"username\":\"admin \",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\"}', 'true', NULL),
(1241, '2025-11-13 05:46:10', 'edit', 'user', '2', 'UPDATE user SET `username` = ?, `email` = ?, `photo` = ? WHERE  user.id_user = ? ', '2', '182.3.36.192', 'account/edit//', '{\"username\":\"admin\",\"email\":\"admin@gmail.com\",\"photo\":\"\"}', 'true', NULL),
(1242, '2025-11-13 05:48:39', 'userlogout', 'user', NULL, NULL, '2', '182.3.36.192', 'index/logout', '[]', 'true', NULL),
(1243, '2025-11-13 05:48:58', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '182.3.36.192', 'index/login/', '{\"username\":\"admin\",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\"}', 'true', NULL),
(1244, '2025-11-13 05:49:11', 'delete', 'user', '81', 'DELETE FROM user WHERE  user.id_user in ( ? ) ', '2', '182.3.36.192', 'user/delete/81/', '[]', 'true', NULL),
(1245, '2025-11-13 05:49:17', 'userlogout', 'user', NULL, NULL, '2', '182.3.36.192', 'index/logout', '[]', 'true', NULL),
(1246, '2025-11-13 05:50:14', 'add', 'user', '82', 'INSERT INTO user (`username`, `email`, `password`)  VALUES (?, ?, ?)', NULL, '182.3.36.192', 'index/register', '{\"username\":\"Aji\",\"email\":\"fajri13shd@gmail.com\",\"password\":\"$2y$10$uOdC9ernzvVj3jpIlY1ekemqLwwv7gO0r7w.Y7YkMwYOpxnCCAZ16\"}', 'true', NULL),
(1247, '2025-11-13 05:50:14', 'userlogin', 'user', '82', 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '82', '182.3.36.192', 'index/register', '{\"username\":\"Aji\",\"email\":\"fajri13shd@gmail.com\",\"password\":\"$2y$10$uOdC9ernzvVj3jpIlY1ekemqLwwv7gO0r7w.Y7YkMwYOpxnCCAZ16\"}', 'true', NULL),
(1248, '2025-11-13 05:51:30', 'userlogout', 'user', NULL, NULL, '82', '182.3.36.192', 'index/logout', '[]', 'true', NULL),
(1249, '2025-11-13 05:51:42', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '82', '182.3.36.192', 'index/login/', '{\"username\":\"fajri13shd@gmail.com\",\"password\":\"$2y$10$uOdC9ernzvVj3jpIlY1ekemqLwwv7gO0r7w.Y7YkMwYOpxnCCAZ16\"}', 'true', NULL),
(1250, '2025-11-13 05:51:49', 'userlogout', 'user', NULL, NULL, '82', '182.3.36.192', 'index/logout', '[]', 'true', NULL),
(1251, '2025-11-13 05:53:06', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '182.3.36.192', 'index/login/', '{\"username\":\"admin\",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\"}', 'true', NULL),
(1252, '2025-11-13 05:54:30', 'add', 'user', '83', 'INSERT INTO user (`username`, `email`, `password`, `role`, `jabatan`)  VALUES (?, ?, ?, ?, ?)', '2', '182.3.36.192', 'user/add', '{\"username\":\"pengurus \",\"email\":\"pengurus2025@gmail.com\",\"password\":\"$2y$10$yIcclofJeTE7uwLk3QHNpOJhTtJPcIRleDIZrXLd49WPAbYmvyE9C\",\"role\":\"Pengurus\",\"jabatan\":\"Ketua Umum\"}', 'true', NULL),
(1253, '2025-11-13 05:54:57', 'userlogout', 'user', NULL, NULL, '2', '182.3.36.192', 'index/logout', '[]', 'true', NULL),
(1254, '2025-11-13 08:57:22', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '103.154.214.194', 'index/login/', '{\"username\":\"admin\",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\"}', 'true', NULL),
(1255, '2025-11-13 09:01:49', 'add', 'dokumentasi', '46', 'INSERT INTO dokumentasi (`nama_kegiatan`, `foto`, `deskripsi_dokumen`, `username`)  VALUES (?, ?, ?, ?)', '2', '103.154.214.194', 'dokumentasi/add', '{\"nama_kegiatan\":\"Hadroh \",\"foto\":\"uploads\\/files\\/Rohis - WhatsApp Image 2025-11-10 at 15.44.13_5dd0b7dc.jpg,uploads\\/files\\/Rohis - WhatsApp Image 2025-11-10 at 21.18.08_b27cfdaf.jpg\",\"deskripsi_dokumen\":\"Latihan Hadroh\",\"username\":\"admin\"}', 'true', NULL),
(1256, '2025-11-13 09:02:37', 'view', 'dokumentasi', '46', 'SELECT   id_dokumentasi, nama_kegiatan, foto, deskripsi_dokumen, link, username, waktu_upload FROM dokumentasi WHERE  dokumentasi.id_dokumentasi = ?  LIMIT 1', '2', '103.154.214.194', 'dokumentasi/view/46', '[]', 'true', NULL),
(1257, '2025-11-13 09:04:06', 'view', 'jabatan', '1', 'SELECT   id_jabatan, nama_jabatan FROM jabatan WHERE  jabatan.id_jabatan = ?  LIMIT 1', '2', '103.154.214.194', 'jabatan/view/1', '[]', 'true', NULL),
(1258, '2025-11-13 09:04:48', 'view', 'kegiatan', '35', 'SELECT   id_kegiatan, nama_kegiatan, lokasi_kegiatan, deskripsi_kegiatan, kategori_kegiatan, tanggal_kegiatan, username FROM kegiatan WHERE  kegiatan.id_kegiatan = ?  LIMIT 1', '2', '103.154.214.194', 'kegiatan/view/35', '[]', 'true', NULL),
(1259, '2025-11-13 09:06:24', 'userlogout', 'user', NULL, NULL, '2', '103.154.214.194', 'index/logout', '[]', 'true', NULL),
(1260, '2025-11-13 09:17:04', 'add', 'user', '84', 'INSERT INTO user (`username`, `email`, `password`)  VALUES (?, ?, ?)', NULL, '103.154.214.194', 'index/register', '{\"username\":\"Faishal sang admin\",\"email\":\"faishalical127@gmail.com\",\"password\":\"$2y$10$DuH4B9RMMOtzbucxXATwwu5P2mHqzyQjGCzQF\\/wfU7ZfTQQGfmgvS\"}', 'true', NULL),
(1261, '2025-11-13 09:17:04', 'userlogin', 'user', '84', 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '84', '103.154.214.194', 'index/register', '{\"username\":\"Faishal sang admin\",\"email\":\"faishalical127@gmail.com\",\"password\":\"$2y$10$DuH4B9RMMOtzbucxXATwwu5P2mHqzyQjGCzQF\\/wfU7ZfTQQGfmgvS\"}', 'true', NULL),
(1262, '2025-11-13 10:07:12', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '36.84.129.7', 'index/login/', '{\"username\":\"admin\",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\"}', 'true', NULL),
(1263, '2025-11-14 02:13:06', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '114.4.82.59', 'index/login/', '{\"username\":\"admin\",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\"}', 'true', NULL),
(1264, '2025-11-14 02:14:28', 'add', 'kas', '29', 'INSERT INTO kas (`username`, `jumlah_kas`, `jenis_kas`, `deskripsi`)  VALUES (?, ?, ?, ?)', '2', '114.4.82.59', 'kas/add', '{\"username\":\"admin\",\"jumlah_kas\":\"50000\",\"jenis_kas\":\"Pemasukan\",\"deskripsi\":\"Minggu pertama \"}', 'true', NULL),
(1265, '2025-11-14 02:14:52', 'edit', 'kas', '29', 'UPDATE kas SET `jumlah_kas` = ?, `jenis_kas` = ?, `deskripsi` = ? WHERE  kas.id_kas = ? ', '2', '114.4.82.59', 'kas/edit/29/', '{\"jumlah_kas\":\"30000\",\"jenis_kas\":\"Pemasukan\",\"deskripsi\":\"Minggu pertama \"}', 'true', NULL),
(1266, '2025-11-14 02:15:10', 'edit', 'kas', '29', 'UPDATE kas SET `jumlah_kas` = ?, `jenis_kas` = ?, `deskripsi` = ? WHERE  kas.id_kas = ? ', '2', '114.4.82.59', 'kas/edit/29/', '{\"jumlah_kas\":\"3000\",\"jenis_kas\":\"Pemasukan\",\"deskripsi\":\"Minggu pertama \"}', 'true', NULL),
(1267, '2025-11-14 02:15:27', 'edit', 'kas', '29', 'UPDATE kas SET `jumlah_kas` = ?, `jenis_kas` = ?, `deskripsi` = ? WHERE  kas.id_kas = ? ', '2', '114.4.82.59', 'kas/edit/29/', '{\"jumlah_kas\":\"30000\",\"jenis_kas\":\"Pemasukan\",\"deskripsi\":\"Minggu pertama \"}', 'true', NULL),
(1268, '2025-11-14 02:15:43', 'delete', 'kas', '29', 'DELETE FROM kas WHERE  kas.id_kas in ( ? ) ', '2', '114.4.82.59', 'kas/delete/29/', '[]', 'true', NULL),
(1269, '2025-11-14 02:16:00', 'view', 'user', '83', 'SELECT   id_user, username, role, jabatan FROM user WHERE  user.id_user = ?  LIMIT 1', '2', '114.4.82.59', 'user/view/83', '[]', 'true', NULL),
(1270, '2025-11-14 02:16:25', 'delete', 'user', '83', 'DELETE FROM user WHERE  user.id_user in ( ? ) ', '2', '114.4.82.59', 'user/delete/83/', '[]', 'true', NULL),
(1271, '2025-11-14 02:16:57', 'delete', 'jabatan', '1', 'DELETE FROM jabatan WHERE  jabatan.id_jabatan in ( ? ) ', '2', '114.4.82.59', 'jabatan/delete/1/', '[]', 'true', NULL),
(1272, '2025-11-14 02:16:59', 'delete', 'jabatan', '2', 'DELETE FROM jabatan WHERE  jabatan.id_jabatan in ( ? ) ', '2', '114.4.82.59', 'jabatan/delete/2/', '[]', 'true', NULL),
(1273, '2025-11-14 02:17:02', 'delete', 'jabatan', '3', 'DELETE FROM jabatan WHERE  jabatan.id_jabatan in ( ? ) ', '2', '114.4.82.59', 'jabatan/delete/3/', '[]', 'true', NULL),
(1274, '2025-11-14 02:17:06', 'delete', 'jabatan', '4', 'DELETE FROM jabatan WHERE  jabatan.id_jabatan in ( ? ) ', '2', '114.4.82.59', 'jabatan/delete/4/', '[]', 'true', NULL),
(1275, '2025-11-14 02:17:20', 'delete', 'jabatan', '12', 'DELETE FROM jabatan WHERE  jabatan.id_jabatan in ( ? ) ', '2', '114.4.82.59', 'jabatan/delete/12/', '[]', 'true', NULL),
(1276, '2025-11-14 02:17:34', 'add', 'jabatan', '13', 'INSERT INTO jabatan (`nama_jabatan`)  VALUES (?)', '2', '114.4.82.59', 'jabatan/add', '{\"nama_jabatan\":\"Sekretaris \"}', 'true', NULL),
(1277, '2025-11-14 02:17:41', 'add', 'jabatan', '14', 'INSERT INTO jabatan (`nama_jabatan`)  VALUES (?)', '2', '114.4.82.59', 'jabatan/add', '{\"nama_jabatan\":\"Sekretaris \"}', 'true', NULL),
(1278, '2025-11-14 02:17:48', 'delete', 'jabatan', '14', 'DELETE FROM jabatan WHERE  jabatan.id_jabatan in ( ? ) ', '2', '114.4.82.59', 'jabatan/delete/14/', '[]', 'true', NULL),
(1279, '2025-11-14 02:18:00', 'add', 'jabatan', '15', 'INSERT INTO jabatan (`nama_jabatan`)  VALUES (?)', '2', '114.4.82.59', 'jabatan/add', '{\"nama_jabatan\":\"bendahara \"}', 'true', NULL),
(1280, '2025-11-14 02:18:32', 'add', 'jabatan', '16', 'INSERT INTO jabatan (`nama_jabatan`)  VALUES (?)', '2', '114.4.82.59', 'jabatan/add', '{\"nama_jabatan\":\"Sekretaris jenderal \"}', 'true', NULL),
(1281, '2025-11-14 02:18:52', 'add', 'jabatan', '17', 'INSERT INTO jabatan (`nama_jabatan`)  VALUES (?)', '2', '114.4.82.59', 'jabatan/add', '{\"nama_jabatan\":\"Ketua keputrian \"}', 'true', NULL),
(1282, '2025-11-14 02:18:59', 'add', 'jabatan', '18', 'INSERT INTO jabatan (`nama_jabatan`)  VALUES (?)', '2', '114.4.82.59', 'jabatan/add', '{\"nama_jabatan\":\"Ketua umum \"}', 'true', NULL),
(1283, '2025-11-14 02:20:25', 'add', 'user', '85', 'INSERT INTO user (`username`, `email`, `password`, `role`, `jabatan`)  VALUES (?, ?, ?, ?, ?)', '2', '114.4.82.59', 'user/add', '{\"username\":\"Pengurus \",\"email\":\"pengurus2025@gmail.com\",\"password\":\"$2y$10$VqpWi8lC31aolgm1HRzY8uQLegGKCQJO542o8l7A7fVOfxcjlRpAW\",\"role\":\"Pengurus\",\"jabatan\":\"Anggota\"}', 'true', NULL),
(1284, '2025-11-14 02:21:20', 'userlogout', 'user', NULL, NULL, '2', '114.4.82.59', 'index/logout', '[]', 'true', NULL),
(1285, '2025-11-14 02:23:13', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '114.4.82.59', 'index/login/', '{\"username\":\"admin\",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\"}', 'true', NULL),
(1286, '2025-11-14 02:23:23', 'delete', 'user', '82', 'DELETE FROM user WHERE  user.id_user in ( ? ) ', '2', '114.4.82.59', 'user/delete/82/', '[]', 'true', NULL),
(1287, '2025-11-14 02:23:27', 'userlogout', 'user', NULL, NULL, '2', '114.4.82.59', 'index/logout', '[]', 'true', NULL),
(1288, '2025-11-14 02:24:10', 'add', 'user', '86', 'INSERT INTO user (`username`, `email`, `password`)  VALUES (?, ?, ?)', NULL, '114.4.82.59', 'index/register', '{\"username\":\"Aji\",\"email\":\"fajrihajat@gmail.com\",\"password\":\"$2y$10$1j37sMAV.9hUBm3rNQ0ChO.NxeiTNigmY.8V6m1935Urit66NTrZy\"}', 'true', NULL),
(1289, '2025-11-14 02:24:10', 'userlogin', 'user', '86', 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '86', '114.4.82.59', 'index/register', '{\"username\":\"Aji\",\"email\":\"fajrihajat@gmail.com\",\"password\":\"$2y$10$1j37sMAV.9hUBm3rNQ0ChO.NxeiTNigmY.8V6m1935Urit66NTrZy\"}', 'true', NULL),
(1290, '2025-11-14 02:26:21', 'userlogout', 'user', NULL, NULL, '86', '114.4.82.59', 'index/logout', '[]', 'true', NULL),
(1291, '2025-11-14 03:20:16', 'add', 'user', '87', 'INSERT INTO user (`username`, `email`, `password`)  VALUES (?, ?, ?)', NULL, '182.2.166.114', 'index/register', '{\"username\":\"dimm\",\"email\":\"dims3838383@gmail.com\",\"password\":\"$2y$10$ag\\/yZeyfdkr5hOkroNCR5uQAednrUhRVZ5hiwLzwkK3bkAZk6wwKO\"}', 'true', NULL),
(1292, '2025-11-14 03:20:16', 'userlogin', 'user', '87', 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '87', '182.2.166.114', 'index/register', '{\"username\":\"dimm\",\"email\":\"dims3838383@gmail.com\",\"password\":\"$2y$10$ag\\/yZeyfdkr5hOkroNCR5uQAednrUhRVZ5hiwLzwkK3bkAZk6wwKO\"}', 'true', NULL),
(1293, '2025-11-14 03:25:24', 'emailchange', 'user', '87', 'UPDATE user SET `email` = ? WHERE  id_user = ? ', '87', '182.2.166.114', 'account/change_email', '[]', 'true', NULL),
(1294, '2025-11-14 03:25:34', 'emailchange', 'user', '87', 'UPDATE user SET `email` = ? WHERE  id_user = ? ', '87', '182.2.166.114', 'account/change_email', '[]', 'true', NULL),
(1295, '2025-11-14 03:49:16', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '86', '114.4.82.59', 'index/login/', '{\"username\":\"aji \",\"password\":\"$2y$10$1j37sMAV.9hUBm3rNQ0ChO.NxeiTNigmY.8V6m1935Urit66NTrZy\"}', 'true', NULL),
(1296, '2025-11-14 04:14:00', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '78', '182.2.166.114', 'index/login/', '{\"username\":\"user\",\"password\":\"$2y$10$rFJMEZFEj7knRxrRyAqPsuk1SQ805aDhgm3n0eEEcvyLsT\\/1gDZdS\"}', 'true', NULL),
(1297, '2025-11-14 04:14:44', 'userlogout', 'user', NULL, NULL, '78', '182.2.166.114', 'index/logout', '[]', 'true', NULL),
(1298, '2025-11-14 04:14:59', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '182.2.166.114', 'index/login/', '{\"username\":\"admin\",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\"}', 'true', NULL),
(1299, '2025-11-14 04:15:49', 'userlogout', 'user', NULL, NULL, '2', '182.2.166.114', 'index/logout', '[]', 'true', NULL),
(1300, '2025-11-14 07:18:07', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '103.154.214.194', 'index/login/', '{\"username\":\"admin\",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\"}', 'true', NULL),
(1301, '2025-11-14 07:18:25', 'delete', 'user', '86', 'DELETE FROM user WHERE  user.id_user in ( ? ) ', '2', '103.154.214.194', 'user/delete/86/', '[]', 'true', NULL),
(1302, '2025-11-14 07:18:32', 'delete', 'user', '87', 'DELETE FROM user WHERE  user.id_user in ( ? ) ', '2', '103.154.214.194', 'user/delete/87/', '[]', 'true', NULL),
(1303, '2025-11-14 07:18:36', 'userlogout', 'user', NULL, NULL, '2', '103.154.214.194', 'index/logout', '[]', 'true', NULL),
(1304, '2025-11-14 07:19:33', 'add', 'user', '88', 'INSERT INTO user (`username`, `email`, `password`, `photo`)  VALUES (?, ?, ?, ?)', NULL, '103.154.214.194', 'index/register', '{\"username\":\"Aji\",\"email\":\"fajrihajat@gmail.com\",\"password\":\"$2y$10$7dEzs.oZs6D88VVuA.d\\/SurG9qYCjLVdhbXd9HzjsMH6y.01UDzzO\",\"photo\":\"https:\\/\\/rohman.my.id\\/uploads\\/files\\/7gs4u53jxyr0avt.jpg\"}', 'true', NULL),
(1305, '2025-11-14 07:19:33', 'userlogin', 'user', '88', 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '88', '103.154.214.194', 'index/register', '{\"username\":\"Aji\",\"email\":\"fajrihajat@gmail.com\",\"password\":\"$2y$10$7dEzs.oZs6D88VVuA.d\\/SurG9qYCjLVdhbXd9HzjsMH6y.01UDzzO\",\"photo\":\"https:\\/\\/rohman.my.id\\/uploads\\/files\\/7gs4u53jxyr0avt.jpg\"}', 'true', NULL),
(1306, '2025-11-14 07:21:11', 'edit', 'user', '88', 'UPDATE user SET `username` = ?, `email` = ?, `photo` = ? WHERE  user.id_user = ? ', '88', '103.154.214.194', 'account/edit//', '{\"username\":\"Aji\",\"email\":\"fajrihajat@gmail.com\",\"photo\":\"https:\\/\\/rohman.my.id\\/uploads\\/files\\/sreap016d83qzcl.jpg\"}', 'true', NULL),
(1307, '2025-11-14 07:21:41', 'userlogout', 'user', NULL, NULL, '88', '103.154.214.194', 'index/logout', '[]', 'true', NULL),
(1308, '2025-11-14 08:46:29', 'add', 'user', '89', 'INSERT INTO user (`username`, `email`, `password`)  VALUES (?, ?, ?)', NULL, '114.124.147.235', 'index/register', '{\"username\":\"Fuad Adam Gusai\",\"email\":\"fuadgusai@gmail.com\",\"password\":\"$2y$10$86MXrjLYdskUVV\\/W0ibaeuwYVpZldlnOCJW9AuxOhGV5diKPpPQ1O\"}', 'true', NULL),
(1309, '2025-11-14 08:46:29', 'userlogin', 'user', '89', 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '89', '114.124.147.235', 'index/register', '{\"username\":\"Fuad Adam Gusai\",\"email\":\"fuadgusai@gmail.com\",\"password\":\"$2y$10$86MXrjLYdskUVV\\/W0ibaeuwYVpZldlnOCJW9AuxOhGV5diKPpPQ1O\"}', 'true', NULL),
(1310, '2025-11-14 11:41:10', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '88', '114.10.118.22', 'index/login/', '{\"username\":\"fajrihajat@gmail.com\",\"password\":\"$2y$10$7dEzs.oZs6D88VVuA.d\\/SurG9qYCjLVdhbXd9HzjsMH6y.01UDzzO\"}', 'true', NULL),
(1311, '2025-11-14 11:47:14', 'userlogout', 'user', NULL, NULL, '88', '114.10.118.22', 'index/logout', '[]', 'true', NULL),
(1312, '2025-11-14 11:47:32', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '114.10.118.22', 'index/login/', '{\"username\":\"admin@gmail.com\",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\"}', 'true', NULL),
(1313, '2025-11-14 11:50:39', 'add', 'pengumuman', '34', 'INSERT INTO pengumuman (`username`, `judul_pengumuman`, `isi_pengumuman`, `nama_kegiatan`, `tanggal_pengumuman`)  VALUES (?, ?, ?, ?, ?)', '2', '114.10.118.22', 'pengumuman/add', '{\"username\":\"admin\",\"judul_pengumuman\":\"Persiapan maulid \",\"isi_pengumuman\":\"Pembagian Pantia \",\"nama_kegiatan\":\"Hadroh \",\"tanggal_pengumuman\":\"2025-11-14 07:30:00\"}', 'true', NULL),
(1314, '2025-11-14 11:58:30', 'userlogout', 'user', NULL, NULL, '2', '114.10.118.22', 'index/logout', '[]', 'true', NULL),
(1315, '2025-11-14 11:58:46', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '88', '114.10.118.22', 'index/login/', '{\"username\":\"fajrihajat@gmail.com\",\"password\":\"$2y$10$7dEzs.oZs6D88VVuA.d\\/SurG9qYCjLVdhbXd9HzjsMH6y.01UDzzO\"}', 'true', NULL),
(1316, '2025-11-14 11:59:01', 'userlogout', 'user', NULL, NULL, '88', '114.10.118.22', 'index/logout', '[]', 'true', NULL),
(1317, '2025-11-14 12:05:28', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '114.10.118.22', 'index/login/', '{\"username\":\"admin\",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\"}', 'true', NULL),
(1318, '2025-11-14 12:05:37', 'delete', 'pengumuman', '34', 'DELETE FROM pengumuman WHERE  pengumuman.id_pengumuman in ( ? ) ', '2', '114.10.118.22', 'pengumuman/delete/34/', '[]', 'true', NULL),
(1319, '2025-11-14 12:06:05', 'userlogout', 'user', NULL, NULL, '2', '114.10.118.22', 'index/logout', '[]', 'true', NULL),
(1320, '2025-11-14 12:11:34', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '114.10.118.22', 'index/login/', '{\"username\":\"admin@gmail.com\",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\"}', 'true', NULL),
(1321, '2025-11-14 12:11:48', 'delete', 'user', '85', 'DELETE FROM user WHERE  user.id_user in ( ? ) ', '2', '114.10.118.22', 'user/delete/85/', '[]', 'true', NULL),
(1322, '2025-11-14 12:19:52', 'add', 'user', '90', 'INSERT INTO user (`username`, `email`, `password`, `photo`, `role`, `jabatan`)  VALUES (?, ?, ?, ?, ?, ?)', '2', '114.10.118.22', 'user/add', '{\"username\":\"Pengurus \",\"email\":\"pengurus2025@gmail.com\",\"password\":\"$2y$10$hctB9dtt3nHGL7KtjL0ESuhXBZHuJ0FYnyGvQr\\/5.IQE4qtbOFzwm\",\"photo\":\"https:\\/\\/rohman.my.id\\/uploads\\/files\\/otiqbez8wclfa_s.jpg\",\"role\":\"Pengurus\",\"jabatan\":\"Ketua keputrian \"}', 'true', NULL),
(1323, '2025-11-14 12:20:42', 'userlogout', 'user', NULL, NULL, '2', '114.10.118.22', 'index/logout', '[]', 'true', NULL),
(1324, '2025-11-14 12:21:00', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '90', '114.10.118.22', 'index/login/', '{\"username\":\"pengurus2025@gmail.com\",\"password\":\"$2y$10$hctB9dtt3nHGL7KtjL0ESuhXBZHuJ0FYnyGvQr\\/5.IQE4qtbOFzwm\"}', 'true', NULL),
(1325, '2025-11-14 12:22:14', 'edit', 'user', '90', 'UPDATE user SET `username` = ?, `email` = ?, `photo` = ? WHERE  user.id_user = ? ', '90', '114.10.118.22', 'account/edit//', '{\"username\":\"Pengurus \",\"email\":\"pengurus2025@gmail.com\",\"photo\":\"https:\\/\\/rohman.my.id\\/uploads\\/files\\/joh4etz8vbl5d36.jpg\"}', 'true', NULL),
(1326, '2025-11-14 12:23:54', 'userlogout', 'user', NULL, NULL, '90', '114.10.118.22', 'index/logout', '[]', 'true', NULL),
(1327, '2025-11-14 12:54:12', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '114.10.118.22', 'index/login/', '{\"username\":\"admin@gmail.com\",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\"}', 'true', NULL),
(1328, '2025-11-14 12:54:24', 'userlogout', 'user', NULL, NULL, '2', '114.10.118.22', 'index/logout', '[]', 'true', NULL),
(1329, '2025-11-14 13:42:35', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '110.138.81.1', 'index/login/', '{\"username\":\"admin@gmail.com\",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\"}', 'true', NULL),
(1330, '2025-11-14 13:43:34', 'add', 'kegiatan', '36', 'INSERT INTO kegiatan (`username`, `nama_kegiatan`, `lokasi_kegiatan`, `deskripsi_kegiatan`, `kategori_kegiatan`, `tanggal_kegiatan`)  VALUES (?, ?, ?, ?, ?, ?)', '2', '110.138.81.1', 'kegiatan/add', '{\"username\":\"admin\",\"nama_kegiatan\":\"Tibar \",\"lokasi_kegiatan\":\"Masjid SMKN 46 JAKARTA \",\"deskripsi_kegiatan\":\"Tilawah bareng \",\"kategori_kegiatan\":\"Kegiatan\",\"tanggal_kegiatan\":\"2025-11-04 15:45:00\"}', 'true', NULL),
(1331, '2025-11-14 13:46:13', 'add', 'dokumentasi', '47', 'INSERT INTO dokumentasi (`nama_kegiatan`, `foto`, `deskripsi_dokumen`, `username`, `waktu_upload`)  VALUES (?, ?, ?, ?, ?)', '2', '110.138.81.1', 'dokumentasi/add', '{\"nama_kegiatan\":\"Tibar \",\"foto\":\"uploads\\/files\\/Rohis - IMG-20251104-WA0047.jpg,uploads\\/files\\/Rohis - IMG-20251104-WA0048.jpg\",\"deskripsi_dokumen\":\"Kegiatan Tilawah Bersama \",\"username\":\"admin\",\"waktu_upload\":\"2025-11-04 17:20:00\"}', 'true', NULL),
(1332, '2025-11-14 13:47:56', 'add', 'kegiatan', '37', 'INSERT INTO kegiatan (`username`, `nama_kegiatan`, `lokasi_kegiatan`, `deskripsi_kegiatan`, `kategori_kegiatan`, `tanggal_kegiatan`)  VALUES (?, ?, ?, ?, ?, ?)', '2', '110.138.81.1', 'kegiatan/add', '{\"username\":\"admin\",\"nama_kegiatan\":\"Tibar \",\"lokasi_kegiatan\":\"Masjid SMKN 46 JAKARTA \",\"deskripsi_kegiatan\":\"Tilawah bareng \",\"kategori_kegiatan\":\"Kegiatan\",\"tanggal_kegiatan\":\"2025-11-14 13:47:00\"}', 'true', NULL),
(1333, '2025-11-14 13:48:13', 'edit', 'kegiatan', '37', 'UPDATE kegiatan SET `username` = ?, `nama_kegiatan` = ?, `lokasi_kegiatan` = ?, `deskripsi_kegiatan` = ?, `kategori_kegiatan` = ?, `tanggal_kegiatan` = ? WHERE  kegiatan.id_kegiatan = ? ', '2', '110.138.81.1', 'kegiatan/edit/37/', '{\"username\":\"admin\",\"nama_kegiatan\":\"Tibar \",\"lokasi_kegiatan\":\"Masjid SMKN 46 JAKARTA \",\"deskripsi_kegiatan\":\"Tilawah bareng \",\"kategori_kegiatan\":\"Kegiatan\",\"tanggal_kegiatan\":\"2025-11-11 15:45:00\"}', 'true', NULL),
(1334, '2025-11-14 13:52:19', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '110.138.81.1', 'index/login/', '{\"username\":\"admin\",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\"}', 'true', NULL),
(1335, '2025-11-14 13:57:59', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '90', '110.138.81.1', 'index/login/', '{\"username\":\"pengurus2025@gmail.com\",\"password\":\"$2y$10$hctB9dtt3nHGL7KtjL0ESuhXBZHuJ0FYnyGvQr\\/5.IQE4qtbOFzwm\"}', 'true', NULL),
(1336, '2025-11-14 14:06:42', 'add', 'kegiatan', '38', 'INSERT INTO kegiatan (`username`, `nama_kegiatan`, `lokasi_kegiatan`, `deskripsi_kegiatan`, `kategori_kegiatan`, `tanggal_kegiatan`)  VALUES (?, ?, ?, ?, ?, ?)', '90', '110.138.81.1', 'kegiatan/add', '{\"username\":\"Pengurus \",\"nama_kegiatan\":\"Tahsin \",\"lokasi_kegiatan\":\"Masjid SMKN 46 JAKARTA \",\"deskripsi_kegiatan\":\"Tahsin adalah kegiatan belajar memperbaiki bacaan Al-Qur\\u2019an sesuai tajwid, agar bacaan lebih benar dan lancar.\\r\\n\",\"kategori_kegiatan\":\"Kegiatan\",\"tanggal_kegiatan\":\"2025-11-06 16:13:00\"}', 'true', NULL),
(1337, '2025-11-14 14:09:00', 'add', 'dokumentasi', '48', 'INSERT INTO dokumentasi (`nama_kegiatan`, `foto`, `deskripsi_dokumen`, `username`, `waktu_upload`)  VALUES (?, ?, ?, ?, ?)', '90', '110.138.81.1', 'dokumentasi/add', '{\"nama_kegiatan\":\"Tahsin \",\"foto\":\"uploads\\/files\\/Rohis - IMG_20251106_162345_992.jpg,uploads\\/files\\/Rohis - IMG_20251106_162329_801.jpg\",\"deskripsi_dokumen\":\"Kegiatan Tahsin \",\"username\":\"Pengurus \",\"waktu_upload\":\"2025-11-06 17:08:00\"}', 'true', NULL),
(1338, '2025-11-14 14:11:19', 'delete', 'dokumentasi', '46', 'DELETE FROM dokumentasi WHERE  dokumentasi.id_dokumentasi in ( ? ) ', '90', '110.138.81.1', 'dokumentasi/delete/46/', '[]', 'true', NULL),
(1339, '2025-11-14 14:11:56', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '110.138.81.1', 'index/login/', '{\"username\":\"admin\",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\"}', 'true', NULL),
(1340, '2025-11-14 14:13:26', 'add', 'dokumentasi', '49', 'INSERT INTO dokumentasi (`nama_kegiatan`, `foto`, `deskripsi_dokumen`, `username`, `waktu_upload`)  VALUES (?, ?, ?, ?, ?)', '2', '110.138.81.1', 'dokumentasi/add', '{\"nama_kegiatan\":\"Hadroh \",\"foto\":\"uploads\\/files\\/Rohis - 2025-11-03 16.55.15_25, Jalan Cipinang Latihan.jpg,uploads\\/files\\/Rohis - IMG-20251103-WA0015.jpg\",\"deskripsi_dokumen\":\"Kegiatan Latihan Hadroh \",\"username\":\"admin\",\"waktu_upload\":\"2025-11-03 19:23:00\"}', 'true', NULL),
(1341, '2025-11-15 00:03:36', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '88', '114.4.215.237', 'index/login/', '{\"username\":\"fajrihajat@gmail.com\",\"password\":\"$2y$10$7dEzs.oZs6D88VVuA.d\\/SurG9qYCjLVdhbXd9HzjsMH6y.01UDzzO\"}', 'true', NULL),
(1342, '2025-11-15 00:03:51', 'view', 'dokumentasi', '48', 'SELECT   id_dokumentasi, nama_kegiatan, foto, deskripsi_dokumen, link, username, waktu_upload FROM dokumentasi WHERE  dokumentasi.id_dokumentasi = ?  LIMIT 1', '88', '114.4.215.237', 'dokumentasi/view/48', '[]', 'true', NULL),
(1343, '2025-11-15 00:03:55', 'view', 'dokumentasi', '48', 'SELECT   id_dokumentasi, nama_kegiatan, foto, deskripsi_dokumen, link, username, waktu_upload FROM dokumentasi WHERE  dokumentasi.id_dokumentasi = ?  LIMIT 1', '88', '114.4.215.237', 'dokumentasi/view/48', '[]', 'true', NULL),
(1344, '2025-11-15 00:04:19', 'userlogout', 'user', NULL, NULL, '88', '114.4.215.237', 'index/logout', '[]', 'true', NULL),
(1345, '2025-11-15 00:04:31', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '114.4.215.237', 'index/login/', '{\"username\":\"admin@gmail.com\",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\"}', 'true', NULL),
(1346, '2025-11-15 00:04:50', 'delete', 'dokumentasi', '49', 'DELETE FROM dokumentasi WHERE  dokumentasi.id_dokumentasi in ( ? ) ', '2', '114.4.215.237', 'dokumentasi/delete/49/', '[]', 'true', NULL),
(1347, '2025-11-15 00:24:26', 'add', 'dokumentasi', '50', 'INSERT INTO dokumentasi (`nama_kegiatan`, `foto`, `deskripsi_dokumen`, `username`, `waktu_upload`)  VALUES (?, ?, ?, ?, ?)', '2', '114.4.215.237', 'dokumentasi/add', '{\"nama_kegiatan\":\"Hadroh \",\"foto\":\"uploads\\/files\\/Rohis - 2025-11-03 16.55.15_25, Jalan Cipinang Latihan.jpg,uploads\\/files\\/Rohis - IMG-20251103-WA0015.jpg\",\"deskripsi_dokumen\":\"Dokumentasi kegiatan Hadroh Minggu ke 1 \",\"username\":\"admin\",\"waktu_upload\":\"2025-11-03 20:16:00\"}', 'true', NULL),
(1348, '2025-11-15 00:24:35', 'view', 'dokumentasi', '50', 'SELECT   id_dokumentasi, nama_kegiatan, foto, deskripsi_dokumen, link, username, waktu_upload FROM dokumentasi WHERE  dokumentasi.id_dokumentasi = ?  LIMIT 1', '2', '114.4.215.237', 'dokumentasi/view/50', '[]', 'true', NULL),
(1349, '2025-11-18 04:22:32', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '182.2.144.22', 'index/login/', '{\"username\":\"admin\",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\"}', 'true', NULL),
(1350, '2025-11-18 04:22:42', 'view', 'dokumentasi', '50', 'SELECT   id_dokumentasi, nama_kegiatan, foto, deskripsi_dokumen, link, username, waktu_upload FROM dokumentasi WHERE  dokumentasi.id_dokumentasi = ?  LIMIT 1', '2', '182.2.144.22', 'dokumentasi/view/50', '[]', 'true', NULL),
(1351, '2025-11-18 04:23:52', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '103.154.214.194', 'index/login/', '{\"username\":\"admin \",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\"}', 'true', NULL),
(1352, '2025-11-18 04:24:02', 'delete', 'dokumentasi', '50', 'DELETE FROM dokumentasi WHERE  dokumentasi.id_dokumentasi in ( ? ) ', '2', '103.154.214.194', 'dokumentasi/delete/50/', '[]', 'true', NULL),
(1353, '2025-11-18 04:25:22', 'delete', 'dokumentasi', '48', 'DELETE FROM dokumentasi WHERE  dokumentasi.id_dokumentasi in ( ? ) ', '2', '103.154.214.194', 'dokumentasi/delete/48/', '[]', 'true', NULL),
(1354, '2025-11-18 04:26:15', 'delete', 'dokumentasi', '47', 'DELETE FROM dokumentasi WHERE  dokumentasi.id_dokumentasi in ( ? ) ', '2', '182.2.144.22', 'dokumentasi/delete/47/', '[]', 'true', NULL),
(1355, '2025-11-18 04:27:24', 'add', 'dokumentasi', '51', 'INSERT INTO dokumentasi (`nama_kegiatan`, `foto`, `deskripsi_dokumen`, `username`, `waktu_upload`)  VALUES (?, ?, ?, ?, ?)', '2', '182.2.144.22', 'dokumentasi/add', '{\"nama_kegiatan\":\"Hadroh \",\"foto\":\"uploads\\/files\\/Rohis - Rohis - WhatsApp Image 2025-11-10 at 21.18.08_b27cfdaf.jpg\",\"deskripsi_dokumen\":\"test\",\"username\":\"admin\",\"waktu_upload\":\"2025-11-18 04:27:03\"}', 'true', NULL),
(1356, '2025-11-18 04:27:32', 'add', 'dokumentasi', '52', 'INSERT INTO dokumentasi (`nama_kegiatan`, `foto`, `deskripsi_dokumen`, `username`, `waktu_upload`)  VALUES (?, ?, ?, ?, ?)', '2', '182.2.144.22', 'dokumentasi/add', '{\"nama_kegiatan\":\"Hadroh \",\"foto\":\"uploads\\/files\\/Rohis - Rohis - WhatsApp Image 2025-11-10 at 21.18.08_b27cfdaf.jpg\",\"deskripsi_dokumen\":\"test\",\"username\":\"admin\",\"waktu_upload\":\"2025-11-18 04:27:25\"}', 'true', NULL),
(1357, '2025-11-18 04:27:35', 'delete', 'dokumentasi', '51', 'DELETE FROM dokumentasi WHERE  dokumentasi.id_dokumentasi in ( ? ) ', '2', '182.2.144.22', 'dokumentasi/delete/51/', '[]', 'true', NULL),
(1358, '2025-11-18 04:30:43', 'delete', 'dokumentasi', '52', 'DELETE FROM dokumentasi WHERE  dokumentasi.id_dokumentasi in ( ? ) ', '2', '182.2.144.22', 'dokumentasi/delete/52/', '[]', 'true', NULL),
(1359, '2025-11-18 04:33:00', 'add', 'dokumentasi', '53', 'INSERT INTO dokumentasi (`nama_kegiatan`, `foto`, `username`)  VALUES (?, ?, ?)', '2', '182.2.144.22', 'dokumentasi/add', '{\"nama_kegiatan\":\"Tahsin \",\"foto\":\"uploads\\/files\\/Rohis - Rohis - WhatsApp Image 2025-11-10 at 21.18.08_b27cfdaf.jpg\",\"username\":\"admin\"}', 'true', NULL),
(1360, '2025-11-18 04:33:02', 'delete', 'dokumentasi', '53', 'DELETE FROM dokumentasi WHERE  dokumentasi.id_dokumentasi in ( ? ) ', '2', '182.2.144.22', 'dokumentasi/delete/53/', '[]', 'true', NULL),
(1361, '2025-11-18 04:36:55', 'add', 'dokumentasi', '54', 'INSERT INTO dokumentasi (`nama_kegiatan`, `foto`, `username`)  VALUES (?, ?, ?)', '2', '182.2.144.22', 'dokumentasi/add', '{\"nama_kegiatan\":\"Hadroh \",\"foto\":\"uploads\\/files\\/Rohis - Rohis - WhatsApp Image 2025-11-10 at 21.18.08_b27cfdaf.jpg\",\"username\":\"admin\"}', 'true', NULL),
(1362, '2025-11-18 04:36:58', 'delete', 'dokumentasi', '54', 'DELETE FROM dokumentasi WHERE  dokumentasi.id_dokumentasi IN ( ? ) ', '2', '182.2.144.22', 'dokumentasi/delete/54/', '[]', 'true', NULL),
(1363, '2025-11-18 04:39:39', 'add', 'dokumentasi', '55', 'INSERT INTO dokumentasi (`nama_kegiatan`, `foto`, `deskripsi_dokumen`, `username`)  VALUES (?, ?, ?, ?)', '2', '103.154.214.194', 'dokumentasi/add', '{\"nama_kegiatan\":\"Hadroh \",\"foto\":\"uploads\\/files\\/Rohis - IMG-20251103-WA0015.jpg,uploads\\/files\\/Rohis - 2025-11-03 16.55.15_25, Jalan Cipinang Latihan.jpg\",\"deskripsi_dokumen\":\"Kegiatan Latihan Hadroh \\r\\nTanggal:03-11-2025\",\"username\":\"admin\"}', 'true', NULL),
(1364, '2025-11-18 04:40:12', 'delete', 'dokumentasi', '55', 'DELETE FROM dokumentasi WHERE  dokumentasi.id_dokumentasi IN ( ? ) ', '2', '103.154.214.194', 'dokumentasi/delete/55/', '[]', 'true', NULL),
(1365, '2025-11-18 04:41:35', 'add', 'dokumentasi', '56', 'INSERT INTO dokumentasi (`nama_kegiatan`, `foto`, `deskripsi_dokumen`, `username`)  VALUES (?, ?, ?, ?)', '2', '103.154.214.194', 'dokumentasi/add', '{\"nama_kegiatan\":\"Hadroh \",\"foto\":\"uploads\\/files\\/Rohis - 2025-11-03 16.55.15_25, Jalan Cipinang Latihan (1).jpg,uploads\\/files\\/Rohis - IMG-20251103-WA0015.jpg\",\"deskripsi_dokumen\":\"Kegiatan Latihan Hadroh \\r\\nHari\\/tnggl: Senin\\/03-11-2025\",\"username\":\"admin\"}', 'true', NULL),
(1366, '2025-11-18 04:44:57', 'delete', 'dokumentasi', '56', 'DELETE FROM dokumentasi WHERE  dokumentasi.id_dokumentasi in ( ? ) ', '2', '182.2.144.22', 'dokumentasi/delete/56/', '[]', 'true', NULL),
(1367, '2025-11-18 04:46:07', 'add', 'dokumentasi', '57', 'INSERT INTO dokumentasi (`nama_kegiatan`, `foto`, `username`)  VALUES (?, ?, ?)', '2', '182.2.144.22', 'dokumentasi/add', '{\"nama_kegiatan\":\"Hadroh \",\"foto\":\"uploads\\/files\\/Rohis - Rohis - WhatsApp Image 2025-11-10 at 21.18.08_b27cfdaf.jpg\",\"username\":\"admin\"}', 'true', NULL),
(1368, '2025-11-18 04:46:08', 'view', 'dokumentasi', '57', 'SELECT   id_dokumentasi, nama_kegiatan, foto, deskripsi_dokumen, link, username, waktu_upload FROM dokumentasi WHERE  dokumentasi.id_dokumentasi = ?  LIMIT 1', '2', '182.2.144.22', 'dokumentasi/view/57', '[]', 'true', NULL);
INSERT INTO `app_logs` (`log_id`, `Timestamp`, `Action`, `TableName`, `RecordID`, `SqlQuery`, `UserID`, `ServerIP`, `RequestUrl`, `RequestData`, `RequestCompleted`, `RequestMsg`) VALUES
(1369, '2025-11-18 04:46:47', 'delete', 'dokumentasi', '57', 'DELETE FROM dokumentasi WHERE  dokumentasi.id_dokumentasi IN ( ? ) ', '2', '182.2.144.22', 'dokumentasi/delete/57/', '[]', 'true', NULL),
(1370, '2025-11-18 04:47:56', 'add', 'dokumentasi', '58', 'INSERT INTO dokumentasi (`nama_kegiatan`, `foto`, `deskripsi_dokumen`, `username`)  VALUES (?, ?, ?, ?)', '2', '182.2.144.22', 'dokumentasi/add', '{\"nama_kegiatan\":\"Hadroh \",\"foto\":\"uploads\\/files\\/Rohis - Rohis - WhatsApp Image 2025-11-10 at 21.18.08_b27cfdaf.jpg,uploads\\/files\\/Rohis - Rohis - WhatsApp Image 2025-11-10 at 15.44.13_5dd0b7dc.jpg\",\"deskripsi_dokumen\":\"tset\",\"username\":\"admin\"}', 'true', NULL),
(1371, '2025-11-18 04:50:27', 'add', 'dokumentasi', '59', 'INSERT INTO dokumentasi (`nama_kegiatan`, `foto`, `deskripsi_dokumen`, `username`)  VALUES (?, ?, ?, ?)', '2', '103.154.214.194', 'dokumentasi/add', '{\"nama_kegiatan\":\"Tahsin \",\"foto\":\"uploads\\/files\\/Rohis - IMG_20251106_162345_992.jpg,uploads\\/files\\/Rohis - IMG_20251106_162329_801.jpg\",\"deskripsi_dokumen\":\"Kegiatan Tahsin \\r\\nHari\\/tgl : Kamis\\/11-11-2025\",\"username\":\"admin\"}', 'true', NULL),
(1372, '2025-11-18 04:57:20', 'add', 'user', '91', 'INSERT INTO user (`username`, `email`, `password`, `role`, `jabatan`)  VALUES (?, ?, ?, ?, ?)', '2', '103.154.214.194', 'user/add', '{\"username\":\"monitor \",\"email\":\"monitor.activity@gmail.com\",\"password\":\"$2y$10$WUltF6K5wsj.c0Q3e2NSJ.agIMHGEAGwrgrLewn9M0xO6NbYxPBM6\",\"role\":\"Administrator\",\"jabatan\":\"Anggota\"}', 'true', NULL),
(1373, '2025-11-18 04:57:28', 'delete', 'user', '88', 'DELETE FROM user WHERE  user.id_user in ( ? ) ', '2', '103.154.214.194', 'user/delete/88/', '[]', 'true', NULL),
(1374, '2025-11-18 09:08:22', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '78', '103.154.214.194', 'index/login/', '{\"username\":\"user\",\"password\":\"$2y$10$rFJMEZFEj7knRxrRyAqPsuk1SQ805aDhgm3n0eEEcvyLsT\\/1gDZdS\"}', 'true', NULL),
(1375, '2025-11-19 23:43:13', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '114.10.117.73', 'index/login/', '{\"username\":\"admin \",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\"}', 'true', NULL),
(1376, '2025-11-19 23:43:40', 'delete', 'user', '91', 'DELETE FROM user WHERE  user.id_user in ( ? ) ', '2', '114.10.117.73', 'user/delete/91/', '[]', 'true', NULL),
(1377, '2025-11-20 06:30:00', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '114.10.117.73', 'index/login/', '{\"username\":\"admin\",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\"}', 'true', NULL),
(1378, '2025-11-20 06:31:24', 'add', 'inventaris', '42', 'INSERT INTO inventaris (`nama_barang`, `jumlah_barang`, `status_barang`, `username`, `tanggal_masuk`)  VALUES (?, ?, ?, ?, ?)', '2', '114.10.117.73', 'inventaris/add', '{\"nama_barang\":\"Mick kabel \",\"jumlah_barang\":\"1\",\"status_barang\":\"Rusak Berat\",\"username\":\"admin\",\"tanggal_masuk\":\"2025-11-20 06:31:05\"}', 'true', NULL),
(1379, '2025-11-20 06:32:25', 'edit', 'inventaris', '42', 'UPDATE inventaris SET `nama_barang` = ?, `jumlah_barang` = ?, `status_barang` = ?, `username` = ?, `tanggal_masuk` = ? WHERE  inventaris.id_barang = ? ', '2', '114.10.117.73', 'inventaris/edit/42/', '{\"nama_barang\":\"Mick imam \",\"jumlah_barang\":\"1\",\"status_barang\":\"Rusak Berat\",\"username\":\"admin\",\"tanggal_masuk\":\"2025-11-20 06:31:05\"}', 'true', NULL),
(1380, '2025-11-20 09:59:24', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '114.10.71.139', 'index/login/', '{\"username\":\"admin\",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\",\"rememberme\":\"true\"}', 'true', NULL),
(1381, '2025-11-20 10:02:33', 'view', 'inventaris', '42', 'SELECT   id_barang, nama_barang, jumlah_barang, status_barang, tanggal_masuk, username FROM inventaris WHERE  inventaris.id_barang = ?  LIMIT 1', '2', '114.10.71.139', 'inventaris/view/42', '[]', 'true', NULL),
(1382, '2025-11-20 10:02:36', 'view', 'inventaris', '41', 'SELECT   id_barang, nama_barang, jumlah_barang, status_barang, tanggal_masuk, username FROM inventaris WHERE  inventaris.id_barang = ?  LIMIT 1', '2', '114.10.71.139', 'inventaris/view/41', '[]', 'true', NULL),
(1383, '2025-11-20 10:02:42', 'view', 'inventaris', '42', 'SELECT   id_barang, nama_barang, jumlah_barang, status_barang, tanggal_masuk, username FROM inventaris WHERE  inventaris.id_barang = ?  LIMIT 1', '2', '114.10.71.139', 'inventaris/view/42', '[]', 'true', NULL),
(1384, '2025-11-20 10:02:50', 'view', 'inventaris', '42', 'SELECT   id_barang, nama_barang, jumlah_barang, status_barang, tanggal_masuk, username FROM inventaris WHERE  inventaris.id_barang = ?  LIMIT 1', '2', '114.10.71.139', 'inventaris/view/42', '[]', 'true', NULL),
(1385, '2025-11-20 10:02:52', 'view', 'inventaris', '42', 'SELECT   id_barang, nama_barang, jumlah_barang, status_barang, tanggal_masuk, username FROM inventaris WHERE  inventaris.id_barang = ?  LIMIT 1', '2', '114.10.71.139', 'inventaris/view/42', '[]', 'true', NULL),
(1386, '2025-11-20 10:03:40', 'delete', 'inventaris', '42,41,40,39,38', 'DELETE FROM inventaris WHERE  inventaris.id_barang in ( ?, ?, ?, ?, ? ) ', '2', '114.10.71.139', 'inventaris/delete/42,41,40,39,38/', '[]', 'true', NULL),
(1387, '2025-11-20 10:19:10', 'add', 'kas', '30', 'INSERT INTO kas (`username`, `jumlah_kas`, `jenis_kas`, `deskripsi`)  VALUES (?, ?, ?, ?)', '2', '114.10.71.139', 'kas/add', '{\"username\":\"admin\",\"jumlah_kas\":\"2000\",\"jenis_kas\":\"Pemasukan\",\"deskripsi\":\"Fadhel\"}', 'true', NULL),
(1388, '2025-11-20 10:19:14', 'view', 'kas', '30', 'SELECT   id_kas, jumlah_kas, jenis_kas, deskripsi, tanggal, username, total_kas FROM kas WHERE  kas.id_kas = ?  LIMIT 1', '2', '114.10.71.139', 'kas/view/30', '[]', 'true', NULL),
(1389, '2025-11-20 10:24:07', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '103.138.49.78', 'index/login/', '{\"username\":\"admin\",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\"}', 'true', NULL),
(1390, '2025-11-20 10:24:39', 'view', 'kas', '30', 'SELECT   id_kas, jumlah_kas, jenis_kas, deskripsi, tanggal, username, total_kas FROM kas WHERE  kas.id_kas = ?  LIMIT 1', '2', '103.138.49.78', 'kas/view/30', '[]', 'true', NULL),
(1391, '2025-11-20 10:24:54', 'add', 'kas', '31', 'INSERT INTO kas (`username`, `jumlah_kas`, `jenis_kas`, `deskripsi`)  VALUES (?, ?, ?, ?)', '2', '103.138.49.78', 'kas/add', '{\"username\":\"admin\",\"jumlah_kas\":\"5000\",\"jenis_kas\":\"Pemasukan\",\"deskripsi\":\"Faisal\"}', 'true', NULL),
(1392, '2025-11-20 10:25:33', 'add', 'kas', '32', 'INSERT INTO kas (`username`, `jumlah_kas`, `jenis_kas`, `deskripsi`)  VALUES (?, ?, ?, ?)', '2', '103.138.49.78', 'kas/add', '{\"username\":\"admin\",\"jumlah_kas\":\"10000\",\"jenis_kas\":\"Pengeluaran\",\"deskripsi\":\"Firda\"}', 'true', NULL),
(1393, '2025-11-20 10:26:01', 'edit', 'dokumentasi', '58', 'UPDATE dokumentasi SET `deskripsi_dokumen` = ? WHERE  dokumentasi.id_dokumentasi = ? ', '2', '103.138.49.78', 'dokumentasi/editfield/58', '{\"deskripsi_dokumen\":\"Hadroh\"}', 'true', NULL),
(1394, '2025-11-20 10:28:38', 'delete', 'dokumentasi', '59,58', 'DELETE FROM dokumentasi WHERE  dokumentasi.id_dokumentasi IN ( ?, ? ) ', '2', '103.138.49.78', 'dokumentasi/delete/59,58/', '[]', 'true', NULL),
(1395, '2025-11-20 10:30:25', 'add', 'dokumentasi', '60', 'INSERT INTO dokumentasi (`nama_kegiatan`, `foto`, `deskripsi_dokumen`, `username`)  VALUES (?, ?, ?, ?)', '2', '103.138.49.78', 'dokumentasi/add', '{\"nama_kegiatan\":\"Hadroh \",\"foto\":\"uploads\\/files\\/Rohis - 1d607ec48a5246eaa2dee2869e407576.jpg\",\"deskripsi_dokumen\":\"Kegiatan Hadroh di Masjid 46\",\"username\":\"admin\"}', 'true', NULL),
(1396, '2025-11-20 10:31:03', 'delete', 'dokumentasi', '60', 'DELETE FROM dokumentasi WHERE  dokumentasi.id_dokumentasi IN ( ? ) ', '2', '103.138.49.78', 'dokumentasi/delete/60/', '[]', 'true', NULL),
(1397, '2025-11-20 10:31:56', 'add', 'dokumentasi', '61', 'INSERT INTO dokumentasi (`nama_kegiatan`, `foto`, `deskripsi_dokumen`, `username`)  VALUES (?, ?, ?, ?)', '2', '103.138.49.78', 'dokumentasi/add', '{\"nama_kegiatan\":\"Tahsin \",\"foto\":\"uploads\\/files\\/Rohis - 1d607ec48a5246eaa2dee2869e407576.jpg\",\"deskripsi_dokumen\":\"Kegiatan Hadroh\",\"username\":\"admin\"}', 'true', NULL),
(1398, '2025-11-20 10:51:07', 'add', 'pengumuman', '35', 'INSERT INTO pengumuman (`username`, `judul_pengumuman`, `isi_pengumuman`, `nama_kegiatan`, `tanggal_pengumuman`)  VALUES (?, ?, ?, ?, ?)', '2', '103.138.49.78', 'pengumuman/add', '{\"username\":\"admin\",\"judul_pengumuman\":\"SESI HADROHH \",\"isi_pengumuman\":\"HALOO TEMAN TEMANN ADA KEGIATAN HADROHH\",\"nama_kegiatan\":\"Hadroh \",\"tanggal_pengumuman\":\"2025-11-20 10:50:29\"}', 'true', NULL),
(1399, '2025-11-21 02:09:51', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '114.10.74.121', 'index/login/', '{\"username\":\"admin\",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\"}', 'true', NULL),
(1400, '2025-11-21 02:10:03', 'delete', 'pengumuman', '35', 'DELETE FROM pengumuman WHERE  pengumuman.id_pengumuman in ( ? ) ', '2', '114.10.74.121', 'pengumuman/delete/35/', '[]', 'true', NULL),
(1401, '2025-11-21 02:11:40', 'delete', 'kas', '32,31,30', 'DELETE FROM kas WHERE  kas.id_kas in ( ?, ?, ? ) ', '2', '114.10.74.121', 'kas/delete/32,31,30/', '[]', 'true', NULL),
(1402, '2025-11-21 02:11:55', 'add', 'kas', '33', 'INSERT INTO kas (`username`, `jumlah_kas`, `jenis_kas`, `deskripsi`)  VALUES (?, ?, ?, ?)', '2', '114.10.74.121', 'kas/add', '{\"username\":\"admin\",\"jumlah_kas\":\"30000\",\"jenis_kas\":\"Pemasukan\",\"deskripsi\":\"Minggu pertama \"}', 'true', NULL),
(1403, '2025-11-21 06:49:04', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '182.3.50.19', 'index/login/', '{\"username\":\"admin\",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\",\"rememberme\":\"true\"}', 'true', NULL),
(1404, '2025-11-21 06:49:47', 'view', 'kas', '33', 'SELECT   id_kas, jumlah_kas, jenis_kas, deskripsi, tanggal, username, total_kas FROM kas WHERE  kas.id_kas = ?  LIMIT 1', '2', '182.3.50.19', 'kas/view/33', '[]', 'true', NULL),
(1405, '2025-11-21 07:45:59', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '114.10.74.121', 'index/login/', '{\"username\":\"admin\",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\"}', 'true', NULL),
(1406, '2025-11-21 07:46:17', 'delete', 'kas', '33,32,31,30', 'DELETE FROM kas WHERE  kas.id_kas in ( ?, ?, ?, ? ) ', '2', '114.10.74.121', 'kas/delete/33,32,31,30/', '[]', 'true', NULL),
(1407, '2025-11-21 07:46:29', 'add', 'kas', '34', 'INSERT INTO kas (`username`, `jumlah_kas`, `jenis_kas`, `deskripsi`)  VALUES (?, ?, ?, ?)', '2', '114.10.74.121', 'kas/add', '{\"username\":\"admin\",\"jumlah_kas\":\"20000\",\"jenis_kas\":\"Pemasukan\",\"deskripsi\":\"dcds\"}', 'true', NULL),
(1408, '2025-11-21 07:48:46', 'add', 'inventaris', '43', 'INSERT INTO inventaris (`nama_barang`, `jumlah_barang`, `status_barang`, `username`, `tanggal_masuk`)  VALUES (?, ?, ?, ?, ?)', '2', '114.10.74.121', 'inventaris/add', '{\"nama_barang\":\"Sapu\",\"jumlah_barang\":\"7\",\"status_barang\":\"Baik\",\"username\":\"admin\",\"tanggal_masuk\":\"2025-11-21 07:48:27\"}', 'true', NULL),
(1409, '2025-11-21 07:49:12', 'add', 'inventaris', '44', 'INSERT INTO inventaris (`nama_barang`, `jumlah_barang`, `status_barang`, `username`, `tanggal_masuk`)  VALUES (?, ?, ?, ?, ?)', '2', '114.10.74.121', 'inventaris/add', '{\"nama_barang\":\"Kipas\",\"jumlah_barang\":\"4\",\"status_barang\":\"Baik\",\"username\":\"admin\",\"tanggal_masuk\":\"2025-11-21 07:48:53\"}', 'true', NULL),
(1410, '2025-11-21 07:49:28', 'add', 'inventaris', '45', 'INSERT INTO inventaris (`nama_barang`, `jumlah_barang`, `status_barang`, `username`, `tanggal_masuk`)  VALUES (?, ?, ?, ?, ?)', '2', '114.10.74.121', 'inventaris/add', '{\"nama_barang\":\"Vacuum Cleaner\",\"jumlah_barang\":\"1\",\"status_barang\":\"Baik\",\"username\":\"admin\",\"tanggal_masuk\":\"2025-11-21 07:48:53\"}', 'true', NULL),
(1411, '2025-11-21 07:50:09', 'add', 'inventaris', '46', 'INSERT INTO inventaris (`nama_barang`, `jumlah_barang`, `status_barang`, `username`, `tanggal_masuk`)  VALUES (?, ?, ?, ?, ?)', '2', '114.10.74.121', 'inventaris/add', '{\"nama_barang\":\"Al - Quran\",\"jumlah_barang\":\"2000\",\"status_barang\":\"Baik\",\"username\":\"admin\",\"tanggal_masuk\":\"2025-11-21 07:48:53\"}', 'true', NULL),
(1412, '2025-11-21 07:50:39', 'add', 'inventaris', '47', 'INSERT INTO inventaris (`nama_barang`, `jumlah_barang`, `status_barang`, `username`, `tanggal_masuk`)  VALUES (?, ?, ?, ?, ?)', '2', '114.10.74.121', 'inventaris/add', '{\"nama_barang\":\"Pel Lantai\",\"jumlah_barang\":\"2\",\"status_barang\":\"Baik\",\"username\":\"admin\",\"tanggal_masuk\":\"2025-11-21 07:48:53\"}', 'true', NULL),
(1413, '2025-11-21 07:50:51', 'add', 'inventaris', '48', 'INSERT INTO inventaris (`nama_barang`, `jumlah_barang`, `status_barang`, `username`, `tanggal_masuk`)  VALUES (?, ?, ?, ?, ?)', '2', '114.10.74.121', 'inventaris/add', '{\"nama_barang\":\"Mick imam \",\"jumlah_barang\":\"1\",\"status_barang\":\"Rusak Berat\",\"username\":\"admin\",\"tanggal_masuk\":\"2025-11-21 07:48:53\"}', 'true', NULL),
(1414, '2025-11-21 07:55:27', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '114.10.30.61', 'index/login/', '{\"username\":\"admin\",\"password\":\"$2y$10$kx4ZbQcXboUP4ss1DvkfkO\\/PzM1Sp4bkrKyCvvHD\\/CcifRBedsUam\",\"rememberme\":\"true\"}', 'true', NULL),
(1415, '2025-11-21 07:58:25', 'userlogout', 'user', NULL, NULL, '2', '114.10.30.61', 'index/logout', '[]', 'true', NULL),
(1416, '2025-11-22 08:51:05', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '2', '114.4.82.81', 'index/login/', '{\"username\":\"admin\",\"password\":\"$2y$10$2E6sO1RfMXSvGt2xmkTbMOrXxx3pt3mBUCuEw\\/CH\\/R4wh680hL\\/ZK\"}', 'true', NULL),
(1417, '2025-11-22 08:52:10', 'delete', 'dokumentasi', '61', 'DELETE FROM dokumentasi WHERE  dokumentasi.id_dokumentasi IN ( ? ) ', '2', '114.4.82.81', 'dokumentasi/delete/61/', '[]', 'true', NULL),
(1418, '2025-11-23 06:38:48', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '90', '114.4.78.43', 'index/login/', '{\"username\":\"Pengurus \",\"password\":\"$2y$10$hctB9dtt3nHGL7KtjL0ESuhXBZHuJ0FYnyGvQr\\/5.IQE4qtbOFzwm\"}', 'true', NULL),
(1419, '2025-11-23 06:39:37', 'userlogout', 'user', NULL, NULL, '90', '114.4.78.43', 'index/logout', '[]', 'true', NULL),
(1420, '2025-11-23 06:45:18', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '90', '114.4.78.43', 'index/login/', '{\"username\":\"pengurus \",\"password\":\"$2y$10$hctB9dtt3nHGL7KtjL0ESuhXBZHuJ0FYnyGvQr\\/5.IQE4qtbOFzwm\"}', 'true', NULL),
(1421, '2025-11-23 06:47:18', 'userlogout', 'user', NULL, NULL, '90', '114.4.78.43', 'index/logout', '[]', 'true', NULL),
(1422, '2025-11-23 06:51:18', 'add', 'user', '92', 'INSERT INTO user (`username`, `email`, `password`)  VALUES (?, ?, ?)', NULL, '114.4.78.43', 'index/register', '{\"username\":\"admin1@gmail.com\",\"email\":\"admin146@gmail.com\",\"password\":\"$2y$10$qT9MD.uUyQcE.CHaYP71Ie\\/HiRhHqoCwGzQdNBVXRUoAhWWqmmMSu\"}', 'true', NULL),
(1423, '2025-11-23 06:51:18', 'userlogin', 'user', '92', 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '92', '114.4.78.43', 'index/register', '{\"username\":\"admin1@gmail.com\",\"email\":\"admin146@gmail.com\",\"password\":\"$2y$10$qT9MD.uUyQcE.CHaYP71Ie\\/HiRhHqoCwGzQdNBVXRUoAhWWqmmMSu\"}', 'true', NULL),
(1424, '2025-11-23 06:51:32', 'userlogout', 'user', NULL, NULL, '92', '114.4.78.43', 'index/logout', '[]', 'true', NULL),
(1425, '2025-11-23 07:00:44', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '90', '114.4.78.43', 'index/login/', '{\"username\":\"pengurus2025@gmail.com\",\"password\":\"$2y$10$hctB9dtt3nHGL7KtjL0ESuhXBZHuJ0FYnyGvQr\\/5.IQE4qtbOFzwm\"}', 'true', NULL),
(1426, '2025-11-23 07:03:53', 'userlogout', 'user', NULL, NULL, '90', '114.4.78.43', 'index/logout', '[]', 'true', NULL),
(1427, '2025-11-23 07:29:28', 'add', 'user', '93', 'INSERT INTO user (`username`, `email`, `password`)  VALUES (?, ?, ?)', NULL, '114.4.78.43', 'index/register', '{\"username\":\"Aji\",\"email\":\"aji17@gmail.com\",\"password\":\"$2y$10$DWGkVoC5eQ8X8Zgh0tatFO7mYTSGD4JMemnNmENAVaGdVms.6xVhW\"}', 'true', NULL),
(1428, '2025-11-23 07:29:28', 'userlogin', 'user', '93', 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '93', '114.4.78.43', 'index/register', '{\"username\":\"Aji\",\"email\":\"aji17@gmail.com\",\"password\":\"$2y$10$DWGkVoC5eQ8X8Zgh0tatFO7mYTSGD4JMemnNmENAVaGdVms.6xVhW\"}', 'true', NULL),
(1429, '2025-11-04 07:02:49', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '90', '103.154.214.194', 'index/login/', '{\"username\":\"Pengurus \",\"password\":\"$2y$10$hctB9dtt3nHGL7KtjL0ESuhXBZHuJ0FYnyGvQr\\/5.IQE4qtbOFzwm\"}', 'true', NULL),
(1430, '2025-11-04 07:03:28', 'userlogout', 'user', NULL, NULL, '90', '103.154.214.194', 'index/logout', '[]', 'true', NULL),
(1431, '2025-11-04 07:04:52', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '90', '103.154.214.194', 'index/login/', '{\"username\":\"pengurus \",\"password\":\"$2y$10$hctB9dtt3nHGL7KtjL0ESuhXBZHuJ0FYnyGvQr\\/5.IQE4qtbOFzwm\"}', 'true', NULL),
(1432, '2025-11-26 08:16:27', 'add', 'user', '96', 'INSERT INTO user (`username`, `email`, `password`, `role`)  VALUES (?, ?, ?, ?)', NULL, '::1', 'index/register', '{\"username\":\"admin\",\"email\":\"admin@gmail.com\",\"password\":\"$2y$10$IDdg\\/cWJ5mN1dXR.6RnxkOJxgpS.WpGb9nUe.Tpkrwdnd\\/W.49mNe\",\"role\":\"Administrator\"}', 'true', NULL),
(1433, '2025-11-26 08:16:27', 'userlogin', 'user', '96', 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '96', '::1', 'index/register', '{\"username\":\"admin\",\"email\":\"admin@gmail.com\",\"password\":\"$2y$10$IDdg\\/cWJ5mN1dXR.6RnxkOJxgpS.WpGb9nUe.Tpkrwdnd\\/W.49mNe\",\"role\":\"Administrator\"}', 'true', NULL),
(1434, '2025-11-26 08:22:25', 'add', 'user', '97', 'INSERT INTO user (`username`, `email`, `password`, `role`, `jabatan`)  VALUES (?, ?, ?, ?, ?)', '96', '::1', 'user/add', '{\"username\":\"admin46\",\"email\":\"admin46@gmail.com\",\"password\":\"$2y$10$DsMmWAUYOF8epuWRttFkSO3C6cy4izIIIJ8JQtU0bHxto5VM8FKw2\",\"role\":\"Administrator\",\"jabatan\":\"Anggota\"}', 'true', NULL),
(1435, '2025-11-26 08:23:08', 'delete', 'user', '78', 'DELETE FROM user WHERE  user.id_user in ( ? ) ', '96', '::1', 'user/delete/78/', '[]', 'true', NULL),
(1436, '2025-11-26 08:24:50', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '96', '::1', 'index/login/', '{\"username\":\"admin\",\"password\":\"$2y$10$IDdg\\/cWJ5mN1dXR.6RnxkOJxgpS.WpGb9nUe.Tpkrwdnd\\/W.49mNe\"}', 'true', NULL),
(1437, '2025-11-26 08:25:10', 'delete', 'kas', '34,33,32,31', 'DELETE FROM kas WHERE  kas.id_kas in ( ?, ?, ?, ? ) ', '96', '::1', 'kas/delete/34,33,32,31/', '[]', 'true', NULL),
(1438, '2025-11-26 08:25:12', 'delete', 'kas', '30', 'DELETE FROM kas WHERE  kas.id_kas in ( ? ) ', '96', '::1', 'kas/delete/30/', '[]', 'true', NULL),
(1439, '2025-11-26 08:25:19', 'add', 'kas', '35', 'INSERT INTO kas (`username`, `jumlah_kas`, `jenis_kas`)  VALUES (?, ?, ?)', '96', '::1', 'kas/add', '{\"username\":\"admin\",\"jumlah_kas\":\"2122222221\",\"jenis_kas\":\"Pemasukan\"}', 'true', NULL),
(1440, '2025-11-26 08:25:35', 'delete', 'kas', '35', 'DELETE FROM kas WHERE  kas.id_kas in ( ? ) ', '96', '::1', 'kas/delete/35/', '[]', 'true', NULL),
(1441, '2025-11-26 08:25:40', 'delete', 'kas', '34,33,32,31,30', 'DELETE FROM kas WHERE  kas.id_kas in ( ?, ?, ?, ?, ? ) ', '96', '::1', 'kas/delete/34,33,32,31,30/', '[]', 'true', NULL),
(1442, '2025-11-26 08:25:48', 'add', 'kas', '36', 'INSERT INTO kas (`username`, `jumlah_kas`, `jenis_kas`)  VALUES (?, ?, ?)', '96', '::1', 'kas/add', '{\"username\":\"admin\",\"jumlah_kas\":\"1\",\"jenis_kas\":\"Pemasukan\"}', 'true', NULL),
(1443, '2025-11-26 08:25:57', 'delete', 'kas', '36', 'DELETE FROM kas WHERE  kas.id_kas in ( ? ) ', '96', '::1', 'kas/delete/36/', '[]', 'true', NULL),
(1444, '2025-11-26 12:13:20', 'userlogin', 'user', NULL, 'SELECT   * FROM user WHERE  username = ?  OR email = ?  LIMIT 1', '96', '::1', 'index/login/', '{\"username\":\"admin\",\"password\":\"$2y$10$IDdg\\/cWJ5mN1dXR.6RnxkOJxgpS.WpGb9nUe.Tpkrwdnd\\/W.49mNe\"}', 'true', NULL),
(1445, '2025-11-26 12:13:46', 'add', 'dokumentasi', '1', 'INSERT INTO dokumentasi (`nama_kegiatan`, `foto`, `deskripsi_dokumen`, `username`)  VALUES (?, ?, ?, ?)', '96', '::1', 'dokumentasi/add', '{\"nama_kegiatan\":\"Tibar \",\"foto\":\"uploads\\/files\\/Rohis - Rohis - IMG-20251113-WA0138.jpg\",\"deskripsi_dokumen\":\"tes\",\"username\":\"admin\"}', 'true', NULL),
(1446, '2025-11-26 12:13:49', 'delete', 'dokumentasi', '1', 'DELETE FROM dokumentasi WHERE  dokumentasi.id_dokumentasi IN ( ? ) ', '96', '::1', 'dokumentasi/delete/1/', '[]', 'true', NULL);

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

--
-- Struktur dari tabel `barang`
--

CREATE TABLE `barang` (
  `id_barang` int(11) NOT NULL,
  `nama_barang` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `barang`
--

INSERT INTO `barang` (`id_barang`, `nama_barang`) VALUES
(1, 'Sapu'),
(2, 'Kipas'),
(3, 'Vacuum Cleaner'),
(4, 'Pel Lantai'),
(5, 'Ember'),
(6, 'Karpet Masjid'),
(7, 'Mimbar'),
(8, 'Mikrofon'),
(9, 'Speaker'),
(10, 'Lampu'),
(11, 'Al - Quran'),
(12, 'Jam Dinding'),
(17, 'Mick imam ');

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

--
-- Struktur dari tabel `dokumentasi`
--

CREATE TABLE `dokumentasi` (
  `id_dokumentasi` int(11) NOT NULL,
  `nama_kegiatan` varchar(11) NOT NULL,
  `foto` varchar(255) NOT NULL,
  `deskripsi_dokumen` text NOT NULL,
  `waktu_upload` datetime NOT NULL,
  `username` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Struktur dari tabel `inventaris`
--

CREATE TABLE `inventaris` (
  `id_barang` int(11) NOT NULL,
  `username` varchar(255) DEFAULT NULL,
  `nama_barang` varchar(255) NOT NULL,
  `jumlah_barang` int(11) DEFAULT NULL,
  `status_barang` varchar(255) DEFAULT NULL,
  `tanggal_masuk` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `inventaris`
--

INSERT INTO `inventaris` (`id_barang`, `username`, `nama_barang`, `jumlah_barang`, `status_barang`, `tanggal_masuk`) VALUES
(43, 'admin', 'Sapu', 7, 'Baik', '2025-11-21 07:48:27'),
(44, 'admin', 'Kipas', 4, 'Baik', '2025-11-21 07:48:53'),
(45, 'admin', 'Vacuum Cleaner', 1, 'Baik', '2025-11-21 07:48:53'),
(46, 'admin', 'Al - Quran', 2000, 'Baik', '2025-11-21 07:48:53'),
(47, 'admin', 'Pel Lantai', 2, 'Baik', '2025-11-21 07:48:53'),
(48, 'admin', 'Mick imam ', 1, 'Rusak Berat', '2025-11-21 07:48:53');

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

--
-- Struktur dari tabel `jabatan`
--

CREATE TABLE `jabatan` (
  `id_jabatan` int(11) NOT NULL,
  `nama_jabatan` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `jabatan`
--

INSERT INTO `jabatan` (`id_jabatan`, `nama_jabatan`) VALUES
(7, 'Anggota'),
(8, 'KPSDM'),
(9, 'DPK'),
(10, 'SYIAR'),
(11, 'DKM'),
(13, 'Sekretaris '),
(15, 'bendahara '),
(16, 'Sekretaris jenderal '),
(17, 'Ketua keputrian '),
(18, 'Ketua umum ');

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

--
-- Struktur dari tabel `kas`
--

CREATE TABLE `kas` (
  `id_kas` int(11) NOT NULL,
  `username` varchar(255) DEFAULT NULL,
  `jumlah_kas` varchar(255) NOT NULL,
  `jenis_kas` varchar(255) NOT NULL,
  `deskripsi` text NOT NULL,
  `tanggal` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `total_kas` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `kas`
--

INSERT INTO `kas` (`id_kas`, `username`, `jumlah_kas`, `jenis_kas`, `deskripsi`, `tanggal`, `total_kas`) VALUES
(30, 'admin', '2000', 'Pemasukan', 'Fadhel', '2025-11-20 10:19:10', 0),
(31, 'admin', '5000', 'Pemasukan', 'Faisal', '2025-11-20 10:24:54', 0),
(32, 'admin', '10000', 'Pengeluaran', 'Firda', '2025-11-20 10:25:33', 0),
(33, 'admin', '30000', 'Pemasukan', 'Minggu pertama ', '2025-11-21 02:11:55', 0),
(34, 'admin', '20000', 'Pemasukan', 'dcds', '2025-11-21 07:46:29', 0);

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

--
-- Struktur dari tabel `kegiatan`
--

CREATE TABLE `kegiatan` (
  `id_kegiatan` int(11) NOT NULL,
  `username` varchar(255) DEFAULT NULL,
  `nama_kegiatan` varchar(255) NOT NULL,
  `lokasi_kegiatan` varchar(255) NOT NULL,
  `deskripsi_kegiatan` text NOT NULL,
  `tanggal_kegiatan` datetime DEFAULT NULL,
  `kategori_kegiatan` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `kegiatan`
--

INSERT INTO `kegiatan` (`id_kegiatan`, `username`, `nama_kegiatan`, `lokasi_kegiatan`, `deskripsi_kegiatan`, `tanggal_kegiatan`, `kategori_kegiatan`) VALUES
(34, 'admin', 'Hadroh ', 'Masjid SMKN 46 JAKARTA ', 'Latihan ', '2025-11-10 15:45:00', 'Latihan'),
(35, 'admin', 'Tibar ', 'Masjid SMKN 46 JAKARTA ', 'Tilawah bareng ', '2025-11-11 15:45:00', 'Kegiatan'),
(36, 'admin', 'Tibar ', 'Masjid SMKN 46 JAKARTA ', 'Tilawah bareng ', '2025-11-04 15:45:00', 'Kegiatan'),
(37, 'admin', 'Tibar ', 'Masjid SMKN 46 JAKARTA ', 'Tilawah bareng ', '2025-11-11 15:45:00', 'Kegiatan'),
(38, 'Pengurus ', 'Tahsin ', 'Masjid SMKN 46 JAKARTA ', 'Tahsin adalah kegiatan belajar memperbaiki bacaan Al-Qur’an sesuai tajwid, agar bacaan lebih benar dan lancar.\r\n', '2025-11-06 16:13:00', 'Kegiatan');

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

--
-- Struktur dari tabel `pengumuman`
--

CREATE TABLE `pengumuman` (
  `id_pengumuman` int(11) NOT NULL,
  `nama_kegiatan` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `judul_pengumuman` varchar(255) NOT NULL,
  `isi_pengumuman` text NOT NULL,
  `tanggal_pengumuman` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Struktur dari tabel `roles`
--

CREATE TABLE `roles` (
  `role_id` int(11) NOT NULL,
  `role` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `roles`
--

INSERT INTO `roles` (`role_id`, `role`) VALUES
(1, 'Administrator'),
(3, 'Pengurus'),
(2, 'User');

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

--
-- Struktur dari tabel `role_permissions`
--

CREATE TABLE `role_permissions` (
  `permission_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `page_name` varchar(255) NOT NULL,
  `action_name` varchar(255) NOT NULL,
  `id_jabatan` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `role_permissions`
--

INSERT INTO `role_permissions` (`permission_id`, `role_id`, `page_name`, `action_name`, `id_jabatan`) VALUES
(342, 0, 'absensi_kegiatan', 'list', 7),
(343, 0, 'absensi_kegiatan', 'view', 7),
(344, 0, 'absensi_kegiatan', 'add', 7),
(345, 0, 'absensi_kegiatan', 'edit', 7),
(346, 0, 'absensi_kegiatan', 'editfield', 7),
(347, 0, 'absensi_kegiatan', 'delete', 7),
(348, 0, 'absensi_kegiatan', 'import_data', 7),
(349, 0, 'app_logs', 'list', 7),
(350, 0, 'app_logs', 'view', 7),
(351, 0, 'app_logs', 'add', 7),
(352, 0, 'app_logs', 'edit', 7),
(353, 0, 'app_logs', 'editfield', 7),
(354, 0, 'app_logs', 'delete', 7),
(355, 0, 'app_logs', 'import_data', 7),
(356, 0, 'dokumentasi', 'list', 7),
(357, 0, 'dokumentasi', 'view', 7),
(358, 0, 'dokumentasi', 'add', 7),
(359, 0, 'dokumentasi', 'edit', 7),
(360, 0, 'dokumentasi', 'editfield', 7),
(361, 0, 'dokumentasi', 'delete', 7),
(362, 0, 'dokumentasi', 'import_data', 7),
(363, 0, 'inventaris', 'list', 7),
(364, 0, 'inventaris', 'view', 7),
(365, 0, 'inventaris', 'add', 7),
(366, 0, 'inventaris', 'edit', 7),
(367, 0, 'inventaris', 'editfield', 7),
(368, 0, 'inventaris', 'delete', 7),
(369, 0, 'inventaris', 'import_data', 7),
(370, 0, 'jabatan', 'list', 7),
(371, 0, 'jabatan', 'view', 7),
(372, 0, 'jabatan', 'add', 7),
(373, 0, 'jabatan', 'edit', 7),
(374, 0, 'jabatan', 'editfield', 7),
(375, 0, 'jabatan', 'delete', 7),
(376, 0, 'jabatan', 'import_data', 7),
(377, 0, 'kas', 'list', 7),
(378, 0, 'kas', 'view', 7),
(379, 0, 'kas', 'add', 7),
(380, 0, 'kas', 'edit', 7),
(381, 0, 'kas', 'editfield', 7),
(382, 0, 'kas', 'delete', 7),
(383, 0, 'kas', 'import_data', 7),
(384, 0, 'kegiatan', 'list', 7),
(385, 0, 'kegiatan', 'view', 7),
(386, 0, 'kegiatan', 'add', 7),
(387, 0, 'kegiatan', 'edit', 7),
(388, 0, 'kegiatan', 'editfield', 7),
(389, 0, 'kegiatan', 'delete', 7),
(390, 0, 'kegiatan', 'import_data', 7),
(391, 0, 'pengumuman', 'list', 7),
(392, 0, 'pengumuman', 'view', 7),
(393, 0, 'pengumuman', 'add', 7),
(394, 0, 'pengumuman', 'edit', 7),
(395, 0, 'pengumuman', 'editfield', 7),
(396, 0, 'pengumuman', 'delete', 7),
(397, 0, 'pengumuman', 'import_data', 7),
(398, 0, 'pengurus', 'list', 7),
(399, 0, 'pengurus', 'view', 7),
(400, 0, 'pengurus', 'add', 7),
(401, 0, 'pengurus', 'edit', 7),
(402, 0, 'pengurus', 'editfield', 7),
(403, 0, 'pengurus', 'delete', 7),
(404, 0, 'pengurus', 'import_data', 7),
(405, 0, 'role_permissions', 'list', 7),
(406, 0, 'role_permissions', 'view', 7),
(407, 0, 'role_permissions', 'add', 7),
(408, 0, 'role_permissions', 'edit', 7),
(409, 0, 'role_permissions', 'editfield', 7),
(410, 0, 'role_permissions', 'delete', 7),
(411, 0, 'role_permissions', 'import_data', 7),
(412, 0, 'roles', 'list', 7),
(413, 0, 'roles', 'view', 7),
(414, 0, 'roles', 'add', 7),
(415, 0, 'roles', 'edit', 7),
(416, 0, 'roles', 'editfield', 7),
(417, 0, 'roles', 'delete', 7),
(418, 0, 'roles', 'import_data', 7),
(419, 0, 'user', 'list', 7),
(420, 0, 'user', 'view', 7),
(421, 0, 'user', 'add', 7),
(422, 0, 'user', 'edit', 7),
(423, 0, 'user', 'editfield', 7),
(424, 0, 'user', 'delete', 7),
(425, 0, 'user', 'import_data', 7),
(426, 0, 'user', 'userregister', 7),
(427, 0, 'user', 'accountedit', 7),
(428, 0, 'user', 'accountview', 7),
(3972, 1, 'absensi_kegiatan', 'list', 0),
(3973, 1, 'absensi_kegiatan', 'view', 0),
(3974, 1, 'absensi_kegiatan', 'add', 0),
(3975, 1, 'absensi_kegiatan', 'edit', 0),
(3976, 1, 'absensi_kegiatan', 'editfield', 0),
(3977, 1, 'absensi_kegiatan', 'delete', 0),
(3978, 1, 'absensi_kegiatan', 'import_data', 0),
(3979, 1, 'app_logs', 'list', 0),
(3980, 1, 'dokumentasi', 'list', 0),
(3981, 1, 'dokumentasi', 'view', 0),
(3982, 1, 'dokumentasi', 'add', 0),
(3983, 1, 'dokumentasi', 'edit', 0),
(3984, 1, 'dokumentasi', 'editfield', 0),
(3985, 1, 'dokumentasi', 'delete', 0),
(3986, 1, 'dokumentasi', 'import_data', 0),
(3987, 1, 'inventaris', 'list', 0),
(3988, 1, 'inventaris', 'view', 0),
(3989, 1, 'inventaris', 'add', 0),
(3990, 1, 'inventaris', 'edit', 0),
(3991, 1, 'inventaris', 'editfield', 0),
(3992, 1, 'inventaris', 'delete', 0),
(3993, 1, 'inventaris', 'import_data', 0),
(3994, 1, 'jabatan', 'list', 0),
(3995, 1, 'jabatan', 'view', 0),
(3996, 1, 'jabatan', 'add', 0),
(3997, 1, 'jabatan', 'edit', 0),
(3998, 1, 'jabatan', 'editfield', 0),
(3999, 1, 'jabatan', 'delete', 0),
(4000, 1, 'jabatan', 'import_data', 0),
(4001, 1, 'kas', 'list', 0),
(4002, 1, 'kas', 'view', 0),
(4003, 1, 'kas', 'add', 0),
(4004, 1, 'kas', 'edit', 0),
(4005, 1, 'kas', 'editfield', 0),
(4006, 1, 'kas', 'delete', 0),
(4007, 1, 'kas', 'import_data', 0),
(4008, 1, 'kegiatan', 'list', 0),
(4009, 1, 'kegiatan', 'view', 0),
(4010, 1, 'kegiatan', 'add', 0),
(4011, 1, 'kegiatan', 'edit', 0),
(4012, 1, 'kegiatan', 'editfield', 0),
(4013, 1, 'kegiatan', 'delete', 0),
(4014, 1, 'kegiatan', 'import_data', 0),
(4015, 1, 'pengumuman', 'list', 0),
(4016, 1, 'pengumuman', 'view', 0),
(4017, 1, 'pengumuman', 'add', 0),
(4018, 1, 'pengumuman', 'edit', 0),
(4019, 1, 'pengumuman', 'editfield', 0),
(4020, 1, 'pengumuman', 'delete', 0),
(4021, 1, 'pengumuman', 'import_data', 0),
(4022, 1, 'pengurus', 'list', 0),
(4023, 1, 'pengurus', 'view', 0),
(4024, 1, 'pengurus', 'add', 0),
(4025, 1, 'pengurus', 'edit', 0),
(4026, 1, 'pengurus', 'editfield', 0),
(4027, 1, 'pengurus', 'delete', 0),
(4028, 1, 'pengurus', 'import_data', 0),
(4029, 1, 'roles', 'list', 0),
(4030, 1, 'user', 'list', 0),
(4031, 1, 'user', 'view', 0),
(4032, 1, 'user', 'add', 0),
(4033, 1, 'user', 'edit', 0),
(4034, 1, 'user', 'editfield', 0),
(4035, 1, 'user', 'delete', 0),
(4036, 1, 'user', 'import_data', 0),
(4037, 1, 'user', 'userregister', 0),
(4038, 1, 'user', 'accountedit', 0),
(4039, 1, 'user', 'accountview', 0),
(4040, 1, 'dokumentasi', 'list', 0),
(4041, 1, 'dokumentasi', 'view', 0),
(4042, 1, 'dokumentasi', 'add', 0),
(4043, 1, 'dokumentasi', 'edit', 0),
(4044, 1, 'dokumentasi', 'editfield', 0),
(4045, 1, 'dokumentasi', 'delete', 0),
(4046, 3, 'absensi_kegiatan', 'list', 0),
(4047, 3, 'absensi_kegiatan', 'view', 0),
(4048, 3, 'absensi_kegiatan', 'add', 0),
(4049, 3, 'absensi_kegiatan', 'edit', 0),
(4050, 3, 'absensi_kegiatan', 'editfield', 0),
(4051, 3, 'absensi_kegiatan', 'delete', 0),
(4052, 3, 'absensi_kegiatan', 'import_data', 0),
(4053, 3, 'dokumentasi', 'list', 0),
(4054, 3, 'dokumentasi', 'view', 0),
(4055, 3, 'dokumentasi', 'add', 0),
(4056, 3, 'dokumentasi', 'edit', 0),
(4057, 3, 'dokumentasi', 'editfield', 0),
(4058, 3, 'dokumentasi', 'delete', 0),
(4059, 3, 'dokumentasi', 'import_data', 0),
(4060, 3, 'inventaris', 'list', 0),
(4061, 3, 'inventaris', 'view', 0),
(4062, 3, 'inventaris', 'add', 0),
(4063, 3, 'inventaris', 'edit', 0),
(4064, 3, 'inventaris', 'editfield', 0),
(4065, 3, 'inventaris', 'delete', 0),
(4066, 3, 'inventaris', 'import_data', 0),
(4067, 3, 'jabatan', 'list', 0),
(4068, 3, 'jabatan', 'view', 0),
(4069, 3, 'jabatan', 'add', 0),
(4070, 3, 'jabatan', 'edit', 0),
(4071, 3, 'jabatan', 'editfield', 0),
(4072, 3, 'jabatan', 'delete', 0),
(4073, 3, 'jabatan', 'import_data', 0),
(4074, 3, 'kas', 'list', 0),
(4075, 3, 'kas', 'view', 0),
(4076, 3, 'kas', 'add', 0),
(4077, 3, 'kas', 'edit', 0),
(4078, 3, 'kas', 'editfield', 0),
(4079, 3, 'kas', 'delete', 0),
(4080, 3, 'kas', 'import_data', 0),
(4081, 3, 'kegiatan', 'list', 0),
(4082, 3, 'kegiatan', 'view', 0),
(4083, 3, 'kegiatan', 'add', 0),
(4084, 3, 'kegiatan', 'edit', 0),
(4085, 3, 'kegiatan', 'editfield', 0),
(4086, 3, 'kegiatan', 'delete', 0),
(4087, 3, 'kegiatan', 'import_data', 0),
(4088, 3, 'pengumuman', 'list', 0),
(4089, 3, 'pengumuman', 'view', 0),
(4090, 3, 'pengumuman', 'add', 0),
(4091, 3, 'pengumuman', 'edit', 0),
(4092, 3, 'pengumuman', 'editfield', 0),
(4093, 3, 'pengumuman', 'delete', 0),
(4094, 3, 'pengumuman', 'import_data', 0),
(4095, 3, 'pengurus', 'list', 0),
(4096, 3, 'pengurus', 'view', 0),
(4097, 3, 'user', 'list', 0),
(4098, 3, 'user', 'view', 0),
(4099, 3, 'user', 'accountview', 0),
(4100, 3, 'dokumentasi', 'list', 0),
(4101, 3, 'dokumentasi', 'view', 0),
(4102, 3, 'dokumentasi', 'add', 0),
(4103, 3, 'dokumentasi', 'edit', 0),
(4104, 3, 'dokumentasi', 'editfield', 0),
(4105, 3, 'dokumentasi', 'delete', 0),
(4106, 2, 'absensi_kegiatan', 'list', 0),
(4107, 2, 'absensi_kegiatan', 'view', 0),
(4108, 2, 'absensi_kegiatan', 'add', 0),
(4109, 2, 'dokumentasi', 'list', 0),
(4110, 2, 'dokumentasi', 'view', 0),
(4111, 2, 'inventaris', 'list', 0),
(4112, 2, 'inventaris', 'view', 0),
(4113, 2, 'kas', 'list', 0),
(4114, 2, 'kas', 'view', 0),
(4115, 2, 'kegiatan', 'list', 0),
(4116, 2, 'kegiatan', 'view', 0),
(4117, 2, 'pengumuman', 'list', 0),
(4118, 2, 'pengumuman', 'view', 0),
(4119, 2, 'pengurus', 'list', 0),
(4120, 2, 'pengurus', 'view', 0),
(4121, 2, 'user', 'list', 0),
(4122, 2, 'user', 'view', 0),
(4123, 2, 'user', 'accountedit', 0),
(4124, 2, 'user', 'accountview', 0),
(4125, 2, 'dokumentasi', 'list', 0),
(4126, 2, 'dokumentasi', 'view', 0);

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

--
-- Struktur dari tabel `user`
--

CREATE TABLE `user` (
  `id_user` int(11) NOT NULL,
  `username` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) DEFAULT NULL,
  `photo` varchar(255) NOT NULL,
  `login_session_key` varchar(255) DEFAULT NULL,
  `email_status` varchar(255) DEFAULT NULL,
  `password_expire_date` datetime DEFAULT '2025-05-06 00:00:00',
  `password_reset_key` varchar(255) DEFAULT NULL,
  `role` varchar(255) DEFAULT 'User',
  `account_status` varchar(255) DEFAULT 'Active',
  `jabatan` varchar(255) NOT NULL DEFAULT 'Anggota'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `user`
--

INSERT INTO `user` (`id_user`, `username`, `email`, `password`, `photo`, `login_session_key`, `email_status`, `password_expire_date`, `password_reset_key`, `role`, `account_status`, `jabatan`) VALUES
(84, 'Faishal sang admin', 'faishalical127@gmail.com', '$2y$10$DuH4B9RMMOtzbucxXATwwu5P2mHqzyQjGCzQF/wfU7ZfTQQGfmgvS', '', NULL, NULL, '2025-05-06 00:00:00', NULL, 'User', 'Active', 'Anggota'),
(89, 'Fuad Adam Gusai', 'fuadgusai@gmail.com', '$2y$10$86MXrjLYdskUVV/W0ibaeuwYVpZldlnOCJW9AuxOhGV5diKPpPQ1O', '', NULL, NULL, '2025-05-06 00:00:00', NULL, 'User', 'Active', 'Anggota'),
(90, 'Pengurus ', 'pengurus2025@gmail.com', '$2y$10$hctB9dtt3nHGL7KtjL0ESuhXBZHuJ0FYnyGvQr/5.IQE4qtbOFzwm', 'https://rohman.my.id/uploads/files/joh4etz8vbl5d36.jpg', NULL, NULL, '2025-05-06 00:00:00', NULL, 'Pengurus', 'Active', 'Ketua keputrian '),
(93, 'Aji', 'aji17@gmail.com', '$2y$10$DWGkVoC5eQ8X8Zgh0tatFO7mYTSGD4JMemnNmENAVaGdVms.6xVhW', '', NULL, NULL, '2025-05-06 00:00:00', NULL, 'User', 'Active', 'Anggota'),
(96, 'admin', 'admin@gmail.com', '$2y$10$IDdg/cWJ5mN1dXR.6RnxkOJxgpS.WpGb9nUe.Tpkrwdnd/W.49mNe', '', NULL, NULL, '2025-05-06 00:00:00', NULL, 'Administrator', 'Active', 'Anggota'),
(97, 'admin46', 'admin46@gmail.com', '$2y$10$DsMmWAUYOF8epuWRttFkSO3C6cy4izIIIJ8JQtU0bHxto5VM8FKw2', '', NULL, NULL, '2025-05-06 00:00:00', NULL, 'Administrator', 'Active', 'Anggota');

--
-- Indexes for dumped tables
--

--
-- Indeks untuk tabel `app_logs`
--
ALTER TABLE `app_logs`
  ADD PRIMARY KEY (`log_id`);

--
-- Indeks untuk tabel `barang`
--
ALTER TABLE `barang`
  ADD PRIMARY KEY (`id_barang`);

--
-- Indeks untuk tabel `dokumentasi`
--
ALTER TABLE `dokumentasi`
  ADD PRIMARY KEY (`id_dokumentasi`);

--
-- Indeks untuk tabel `inventaris`
--
ALTER TABLE `inventaris`
  ADD PRIMARY KEY (`id_barang`);

--
-- Indeks untuk tabel `jabatan`
--
ALTER TABLE `jabatan`
  ADD PRIMARY KEY (`id_jabatan`);

--
-- Indeks untuk tabel `kas`
--
ALTER TABLE `kas`
  ADD PRIMARY KEY (`id_kas`);

--
-- Indeks untuk tabel `kegiatan`
--
ALTER TABLE `kegiatan`
  ADD PRIMARY KEY (`id_kegiatan`);

--
-- Indeks untuk tabel `pengumuman`
--
ALTER TABLE `pengumuman`
  ADD PRIMARY KEY (`id_pengumuman`);

--
-- Indeks untuk tabel `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`role_id`),
  ADD UNIQUE KEY `role_name` (`role`);

--
-- Indeks untuk tabel `role_permissions`
--
ALTER TABLE `role_permissions`
  ADD PRIMARY KEY (`permission_id`);

--
-- Indeks untuk tabel `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`id_user`),
  ADD UNIQUE KEY `username` (`username`),
  ADD UNIQUE KEY `email` (`email`);

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

--
-- AUTO_INCREMENT untuk tabel `app_logs`
--
ALTER TABLE `app_logs`
  MODIFY `log_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1447;

--
-- AUTO_INCREMENT untuk tabel `barang`
--
ALTER TABLE `barang`
  MODIFY `id_barang` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT untuk tabel `dokumentasi`
--
ALTER TABLE `dokumentasi`
  MODIFY `id_dokumentasi` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT untuk tabel `inventaris`
--
ALTER TABLE `inventaris`
  MODIFY `id_barang` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49;

--
-- AUTO_INCREMENT untuk tabel `jabatan`
--
ALTER TABLE `jabatan`
  MODIFY `id_jabatan` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT untuk tabel `kas`
--
ALTER TABLE `kas`
  MODIFY `id_kas` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT untuk tabel `kegiatan`
--
ALTER TABLE `kegiatan`
  MODIFY `id_kegiatan` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;

--
-- AUTO_INCREMENT untuk tabel `pengumuman`
--
ALTER TABLE `pengumuman`
  MODIFY `id_pengumuman` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `roles`
--
ALTER TABLE `roles`
  MODIFY `role_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT untuk tabel `role_permissions`
--
ALTER TABLE `role_permissions`
  MODIFY `permission_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4127;

--
-- AUTO_INCREMENT untuk tabel `user`
--
ALTER TABLE `user`
  MODIFY `id_user` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=98;
COMMIT;

