-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Generation Time: Jun 05, 2024 at 05:54 PM -- Server version: 10.6.16-MariaDB-0ubuntu0.22.04.1 -- PHP Version: 7.4.33 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `db_panti_asuhan` -- -- -------------------------------------------------------- -- -- Table structure for table `tb_dana_sosial` -- CREATE TABLE `tb_dana_sosial` ( `id_dana_sosial` int(11) NOT NULL, `bentuk` varchar(15) NOT NULL, `nama` text DEFAULT NULL, `jenis` varchar(10) NOT NULL, `ket` text DEFAULT NULL, `jumlah` varchar(11) DEFAULT NULL, `tanggal` date NOT NULL, `status` int(11) NOT NULL DEFAULT 0, `jenis_barang` varchar(20) DEFAULT NULL, `satuan` varchar(10) DEFAULT NULL, `jumlah_barang` varchar(3) DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `tb_dana_sosial` -- INSERT INTO `tb_dana_sosial` (`id_dana_sosial`, `bentuk`, `nama`, `jenis`, `ket`, `jumlah`, `tanggal`, `status`, `jenis_barang`, `satuan`, `jumlah_barang`, `created_at`, `updated_at`) VALUES (7, 'Pemasukan', 'H. Taswin', 'Uang', NULL, '200000', '2023-06-02', 0, NULL, NULL, NULL, '2024-05-26 10:22:37', '2024-05-26 10:22:37'), (8, 'Pemasukan', 'Hamba Allah', 'Uang', NULL, '250000', '2023-06-02', 0, NULL, NULL, NULL, '2024-05-26 10:23:38', '2024-05-26 10:23:38'), (9, 'Pemasukan', 'Anwar', 'Uang', NULL, '100000', '2023-06-02', 0, NULL, NULL, NULL, '2024-05-26 10:24:22', '2024-05-26 10:24:22'), (10, 'Pemasukan', 'Nur Farelia', 'Uang', NULL, '100000', '2023-06-02', 0, NULL, NULL, NULL, '2024-05-26 10:24:57', '2024-05-26 10:24:57'), (11, 'Pemasukan', 'Ratu Sulaika', 'Uang', NULL, '100000', '2023-06-02', 0, NULL, NULL, NULL, '2024-05-26 10:26:06', '2024-05-26 10:26:06'), (12, 'Pemasukan', 'H. Hamzah /Hj. Minang', 'Uang', NULL, '100000', '2023-06-02', 0, NULL, NULL, NULL, '2024-05-26 10:26:56', '2024-05-26 10:26:56'), (13, 'Pemasukan', 'Desi Indriyani', 'Uang', NULL, '300000', '2023-06-02', 0, NULL, NULL, NULL, '2024-05-26 10:27:43', '2024-05-26 10:27:43'), (14, 'Pemasukan', 'Hamba Allah', 'Uang', NULL, '700000', '2023-06-02', 0, NULL, NULL, NULL, '2024-05-26 10:28:26', '2024-05-26 10:28:26'), (15, 'Pemasukan', 'Hikmah/Hj Gusti', 'Uang', NULL, '100000', '2023-06-02', 0, NULL, NULL, NULL, '2024-05-26 10:29:17', '2024-05-26 10:29:17'), (16, 'Pemasukan', 'Hj. Nurhayati/Thamrin', 'Uang', NULL, '200000', '2023-06-03', 0, NULL, NULL, NULL, '2024-05-26 10:31:03', '2024-05-26 10:31:03'), (18, 'Pemasukan', 'Adi Rismawati', 'Uang', NULL, '200000', '2023-05-28', 0, NULL, NULL, NULL, '2024-05-26 10:33:28', '2024-05-26 10:33:28'), (19, 'Pemasukan', 'WA Ade', 'Uang', NULL, '500000', '2023-05-28', 0, NULL, NULL, NULL, '2024-05-26 10:34:05', '2024-05-26 10:34:05'), (21, 'Pemasukan', 'Hamba Allah', 'Uang', NULL, '200000', '2023-05-31', 0, NULL, NULL, NULL, '2024-05-26 10:35:43', '2024-05-26 10:35:43'), (22, 'Pemasukan', 'iqbal/amelia', 'Uang', NULL, '250000', '2023-05-31', 0, NULL, NULL, NULL, '2024-05-26 10:36:13', '2024-05-26 10:36:13'), (23, 'Pemasukan', 'Saharuddin. Slaeh', 'Uang', NULL, '500000', '2023-05-29', 0, NULL, NULL, NULL, '2024-05-26 10:38:14', '2024-05-26 10:38:14'), (24, 'Pemasukan', 'hamba Allah', 'Uang', NULL, '100000', '2023-05-30', 0, NULL, NULL, NULL, '2024-05-26 10:39:50', '2024-05-26 10:39:50'), (26, 'Pengeluaran', NULL, 'Uang', NULL, '2077000', '2023-06-04', 0, NULL, NULL, NULL, '2024-05-26 10:48:48', '2024-05-26 10:48:48'), (27, 'Pemasukan', 'PT. Dharma Lautan', 'Uang', NULL, '4000000', '2023-06-05', 0, NULL, NULL, NULL, '2024-05-26 10:50:13', '2024-05-26 10:50:13'), (28, 'Pemasukan', 'Salin', 'Uang', NULL, '100000', '2023-06-04', 0, NULL, NULL, NULL, '2024-05-26 10:51:03', '2024-05-26 10:51:03'), (29, 'Pemasukan', 'Orang baik', 'Uang', NULL, '500000', '2023-06-04', 0, NULL, NULL, NULL, '2024-05-26 10:51:50', '2024-05-26 10:51:50'), (30, 'Pemasukan', 'Ayus Renaldi', 'Uang', NULL, '500000', '2023-06-05', 0, NULL, NULL, NULL, '2024-05-26 10:52:32', '2024-05-26 10:52:32'), (31, 'Pemasukan', 'Haniyar', 'Uang', NULL, '10000', '2023-06-05', 0, NULL, NULL, NULL, '2024-05-26 10:53:40', '2024-05-26 10:53:40'), (32, 'Pemasukan', 'Hamba Allah', 'Uang', NULL, '200000', '2023-06-05', 0, NULL, NULL, NULL, '2024-05-26 10:54:29', '2024-05-26 10:54:29'), (33, 'Pemasukan', 'Amirullah. Sek', 'Uang', NULL, '100000', '2023-06-09', 0, NULL, NULL, NULL, '2024-05-26 10:57:31', '2024-05-26 10:57:31'), (34, 'Pemasukan', 'Ani', 'Uang', NULL, '150000', '2023-06-09', 0, NULL, NULL, NULL, '2024-05-26 10:58:04', '2024-05-26 10:58:04'), (35, 'Pemasukan', 'H. Taswin', 'Uang', NULL, '200000', '2023-06-09', 0, NULL, NULL, NULL, '2024-05-26 10:58:32', '2024-05-26 10:58:32'), (36, 'Pemasukan', 'Dwi Septeani', 'Uang', NULL, '50000', '2023-06-09', 0, NULL, NULL, NULL, '2024-05-26 10:59:45', '2024-05-26 10:59:45'), (37, 'Pemasukan', 'H. Hamzah', 'Uang', NULL, '100000', '2023-06-09', 0, NULL, NULL, NULL, '2024-05-26 11:00:12', '2024-05-26 11:00:12'), (38, 'Pengeluaran', NULL, 'Uang', NULL, '510000', '2023-06-09', 0, NULL, NULL, NULL, '2024-05-26 11:01:37', '2024-05-26 11:01:37'), (39, 'Pemasukan', 'Asnawati Giling ', 'Uang', NULL, '100000', '2023-06-11', 0, NULL, NULL, NULL, '2024-05-26 11:02:23', '2024-05-26 11:02:23'), (40, 'Pemasukan', 'Aswar', 'Uang', NULL, '150000', '2023-06-13', 0, NULL, NULL, NULL, '2024-05-26 11:02:40', '2024-05-26 11:02:40'), (41, 'Pemasukan', 'H. Taswin', 'Uang', NULL, '250000', '2023-06-14', 0, NULL, NULL, NULL, '2024-05-26 11:03:12', '2024-05-26 11:03:12'), (42, 'Pemasukan', 'Hendra', 'Uang', NULL, '200000', '2023-06-16', 0, NULL, NULL, NULL, '2024-05-26 11:03:50', '2024-05-26 11:03:50'), (43, 'Pemasukan', 'Hamba Allah', 'Uang', NULL, '250000', '2023-06-16', 0, NULL, NULL, NULL, '2024-05-26 11:04:52', '2024-05-26 11:04:52'), (44, 'Pemasukan', 'Alm Aisyah Np. ', 'Uang', NULL, '50000', '2023-06-16', 0, NULL, NULL, NULL, '2024-05-26 11:05:23', '2024-05-26 11:05:23'), (45, 'Pemasukan', 'Ardiansyah Sekeluarga', 'Uang', NULL, '100000', '2023-06-16', 0, NULL, NULL, NULL, '2024-05-26 11:05:47', '2024-05-26 11:05:47'), (46, 'Pemasukan', 'Nawir', 'Uang', NULL, '250000', '2023-06-16', 0, NULL, NULL, NULL, '2024-05-26 11:06:24', '2024-05-26 11:06:24'), (49, 'Pemasukan', 'H. Hamzah', 'Uang', NULL, '100000', '2023-06-16', 0, NULL, NULL, NULL, '2024-05-26 11:19:20', '2024-05-26 11:19:20'), (50, 'Pemasukan', 'Roswale Dewi', 'Uang', NULL, '200000', '2023-06-16', 0, NULL, NULL, NULL, '2024-05-26 11:19:58', '2024-05-26 11:19:58'), (51, 'Pemasukan', 'Firman Sabania', 'Uang', NULL, '500000', '2023-06-16', 0, NULL, NULL, NULL, '2024-05-26 11:20:34', '2024-05-26 11:20:34'), (52, 'Pengeluaran', NULL, 'Uang', NULL, '340000', '2023-06-17', 0, NULL, NULL, NULL, '2024-05-26 11:22:09', '2024-05-26 11:22:09'), (53, 'Pemasukan', 'Heji', 'Uang', NULL, '450000', '2023-06-18', 0, NULL, NULL, NULL, '2024-05-26 11:22:58', '2024-05-26 11:22:58'), (54, 'Pemasukan', 'Hamba Allah', 'Uang', NULL, '250000', '2023-06-22', 0, NULL, NULL, NULL, '2024-05-26 11:23:29', '2024-05-26 11:23:29'), (55, 'Pemasukan', 'H. Taswin', 'Uang', NULL, '200000', '2023-06-23', 0, NULL, NULL, NULL, '2024-05-26 11:24:23', '2024-05-26 11:24:23'), (56, 'Pemasukan', 'Jefri', 'Uang', NULL, '150000', '2023-06-10', 0, NULL, NULL, NULL, '2024-05-26 11:25:12', '2024-05-26 11:25:12'), (57, 'Pemasukan', 'Babe', 'Uang', NULL, '80000', '2023-06-18', 0, NULL, NULL, NULL, '2024-05-26 11:25:42', '2024-05-26 11:25:42'), (58, 'Pemasukan', 'King Ocean', 'Uang', NULL, '500000', '2023-06-19', 0, NULL, NULL, NULL, '2024-05-26 11:26:14', '2024-05-26 11:26:14'), (59, 'Pemasukan', 'Amir/Musni', 'Uang', NULL, '200000', '2023-06-21', 0, NULL, NULL, NULL, '2024-05-26 11:26:40', '2024-05-26 11:26:40'), (60, 'Pemasukan', 'Dwi Septiani', 'Uang', NULL, '50000', '2023-06-23', 0, NULL, NULL, NULL, '2024-05-26 11:27:37', '2024-05-26 11:27:37'), (61, 'Pemasukan', 'H. umar sekeluarga', 'Uang', NULL, '500000', '2023-06-23', 0, NULL, NULL, NULL, '2024-05-26 11:28:12', '2024-05-26 11:28:12'), (62, 'Pemasukan', 'H. Hamzah', 'Uang', NULL, '100000', '2023-06-23', 0, NULL, NULL, NULL, '2024-05-26 11:28:42', '2024-05-26 11:28:42'), (63, 'Pemasukan', 'H. Gustianti', 'Uang', NULL, '50000', '2023-06-23', 0, NULL, NULL, NULL, '2024-05-26 11:29:12', '2024-05-26 11:29:12'), (64, 'Pemasukan', 'Hamba Allah', 'Uang', NULL, '150000', '2023-06-23', 0, NULL, NULL, NULL, '2024-05-26 11:29:56', '2024-05-26 11:29:56'), (65, 'Pemasukan', 'Muslimah', 'Uang', NULL, '200000', '2023-06-23', 0, NULL, NULL, NULL, '2024-05-26 11:30:24', '2024-05-26 11:30:24'), (66, 'Pemasukan', 'TK. Al-Aqsha', 'Uang', NULL, '1050000', '2023-06-23', 0, NULL, NULL, NULL, '2024-05-26 11:30:55', '2024-05-26 11:30:55'), (67, 'Pemasukan', 'Hamba Allah', 'Uang', NULL, '100000', '2023-06-23', 0, NULL, NULL, NULL, '2024-05-26 11:31:34', '2024-05-26 11:31:34'), (68, 'Pemasukan', 'Hj. Nurawang', 'Uang', NULL, '100000', '2023-06-25', 0, NULL, NULL, NULL, '2024-05-26 11:32:09', '2024-05-26 11:32:09'), (69, 'Pemasukan', 'Hj. Eda ', 'Uang', NULL, '200000', '2023-06-25', 0, NULL, NULL, NULL, '2024-05-26 11:33:05', '2024-05-26 11:33:05'), (70, 'Pemasukan', 'Pak Danil', 'Uang', NULL, '500000', '2023-06-27', 0, NULL, NULL, NULL, '2024-05-26 11:33:39', '2024-05-26 11:33:39'), (71, 'Pemasukan', 'Hamba Allah', 'Uang', NULL, '1000000', '2023-06-28', 0, NULL, NULL, NULL, '2024-05-26 11:34:07', '2024-05-26 11:34:07'), (72, 'Pemasukan', 'Lahabi Sekeluarga', 'Uang', NULL, '200000', '2023-06-28', 0, NULL, NULL, NULL, '2024-05-26 11:34:49', '2024-05-26 11:34:49'), (73, 'Pemasukan', 'Sisa Afika', 'Uang', NULL, '200000', '2023-06-29', 0, NULL, NULL, NULL, '2024-05-26 11:35:19', '2024-05-26 11:35:19'), (74, 'Pemasukan', 'Adi Rismawati', 'Uang', NULL, '300000', '2023-06-30', 0, NULL, NULL, NULL, '2024-05-26 11:36:07', '2024-05-26 11:36:07'), (75, 'Pemasukan', 'Herliani Muliadi', 'Uang', NULL, '177000', '2023-06-30', 0, NULL, NULL, NULL, '2024-05-26 11:36:33', '2024-05-26 11:36:33'), (76, 'Pemasukan', 'dr.hj. A. Rismawati Darma', 'Uang', NULL, '550000', '2023-06-30', 0, NULL, NULL, NULL, '2024-05-26 11:37:18', '2024-05-26 11:37:18'), (77, 'Pemasukan', 'H. Muh. Daming', 'Uang', NULL, '300000', '2023-06-30', 0, NULL, NULL, NULL, '2024-05-26 11:38:14', '2024-05-26 11:38:14'), (78, 'Pemasukan', 'Hasmidayani', 'Uang', NULL, '450000', '2023-07-02', 0, NULL, NULL, NULL, '2024-05-26 11:38:52', '2024-05-26 11:38:52'), (79, 'Pemasukan', 'Nurul Ain', 'Uang', NULL, '450000', '2023-07-02', 0, NULL, NULL, NULL, '2024-05-26 11:39:20', '2024-05-26 11:39:20'), (80, 'Pemasukan', 'kakak amal ', 'Uang', NULL, '150000', '2023-07-02', 0, NULL, NULL, NULL, '2024-05-26 11:39:39', '2024-05-26 11:39:39'), (81, 'Pengeluaran', NULL, 'Uang', NULL, '1401000', '2023-06-30', 0, NULL, NULL, NULL, '2024-05-26 11:40:14', '2024-05-26 11:40:14'), (82, 'Pemasukan', 'ir. andoko', 'Uang', NULL, '200000', '2023-07-04', 0, NULL, NULL, NULL, '2024-05-26 11:41:18', '2024-05-26 11:41:18'), (83, 'Pemasukan', 'Amrillah', 'Uang', NULL, '100000', '2023-07-04', 0, NULL, NULL, NULL, '2024-05-26 11:41:46', '2024-05-26 11:41:46'), (84, 'Pemasukan', 'H. Taswin', 'Uang', NULL, '400000', '2023-07-07', 0, NULL, NULL, NULL, '2024-05-26 11:42:24', '2024-05-26 11:42:24'), (85, 'Pemasukan', 'Barakai', 'Uang', NULL, '215000', '2023-07-07', 0, NULL, NULL, NULL, '2024-05-26 11:42:51', '2024-05-26 11:42:51'), (86, 'Pemasukan', 'hamba Alloh', 'Uang', NULL, '250000', '2023-07-07', 0, NULL, NULL, NULL, '2024-05-26 11:43:18', '2024-05-26 11:43:18'), (87, 'Pemasukan', 'Muh. Ridwan', 'Uang', NULL, '1000000', '2023-07-07', 0, NULL, NULL, NULL, '2024-05-26 11:43:39', '2024-05-26 11:43:39'), (88, 'Pemasukan', 'H. Hamzah', 'Uang', NULL, '100000', '2023-07-07', 0, NULL, NULL, NULL, '2024-05-26 11:44:19', '2024-05-26 11:44:19'), (89, 'Pemasukan', 'Anwar', 'Uang', NULL, '500000', '2023-07-07', 0, NULL, NULL, NULL, '2024-05-26 11:44:48', '2024-05-26 11:44:48'), (90, 'Pemasukan', 'Maslan', 'Uang', NULL, '500000', '2023-07-07', 0, NULL, NULL, NULL, '2024-05-26 11:45:08', '2024-05-26 11:45:08'), (91, 'Pemasukan', 'Nur Emma', 'Uang', NULL, '200000', '2023-07-08', 0, NULL, NULL, NULL, '2024-05-26 11:45:48', '2024-05-26 11:45:48'), (93, 'Pengeluaran', NULL, 'Uang', NULL, '376000', '2023-07-09', 0, NULL, NULL, NULL, '2024-05-26 11:47:05', '2024-05-26 11:47:05'), (94, 'Pemasukan', 'Hj. Murni', 'Uang', NULL, '200000', '2023-07-09', 0, NULL, NULL, NULL, '2024-05-26 11:47:30', '2024-05-26 11:47:30'), (95, 'Pemasukan', 'Hj. Rahmatan', 'Uang', NULL, '500000', '2023-07-13', 0, NULL, NULL, NULL, '2024-05-26 11:48:13', '2024-05-26 11:48:13'), (96, 'Pemasukan', 'hamba allah', 'Uang', NULL, '250000', '2023-07-14', 0, NULL, NULL, NULL, '2024-05-26 11:48:38', '2024-05-26 11:48:38'), (97, 'Pemasukan', 'hamba Allah', 'Uang', NULL, '150000', '2023-07-14', 0, NULL, NULL, NULL, '2024-05-26 11:49:04', '2024-05-26 11:49:04'), (98, 'Pemasukan', 'H. Hamzah', 'Uang', NULL, '100000', '2023-07-14', 0, NULL, NULL, NULL, '2024-05-26 11:49:34', '2024-05-26 11:49:34'), (99, 'Pemasukan', 'Amiluddin', 'Uang', NULL, '800000', '2023-07-18', 0, NULL, NULL, NULL, '2024-05-26 11:50:01', '2024-05-26 11:50:01'), (100, 'Pemasukan', 'Sitrisno', 'Uang', NULL, '200000', '2023-07-18', 0, NULL, NULL, NULL, '2024-05-26 11:50:43', '2024-05-26 11:50:43'), (101, 'Pemasukan', 'andy', 'Uang', NULL, '150000', '2023-07-18', 0, NULL, NULL, NULL, '2024-05-26 11:51:10', '2024-05-26 11:51:10'), (102, 'Pemasukan', 'Nur Farelia Arwan', 'Uang', NULL, '300000', '2023-07-19', 0, NULL, NULL, NULL, '2024-05-26 11:51:36', '2024-05-26 11:51:36'), (103, 'Pemasukan', 'Bahri', 'Uang', NULL, '500000', '2023-07-19', 0, NULL, NULL, NULL, '2024-05-26 11:51:55', '2024-05-26 11:51:55'), (104, 'Pemasukan', 'H. Taswin', 'Uang', NULL, '400000', '2023-07-21', 0, NULL, NULL, NULL, '2024-05-26 11:52:42', '2024-05-26 11:52:42'), (105, 'Pemasukan', 'Hasriadi', 'Uang', NULL, '50000', '2023-07-21', 0, NULL, NULL, NULL, '2024-05-26 11:53:02', '2024-05-26 11:53:02'), (106, 'Pemasukan', 'hamba Alloh', 'Uang', NULL, '250000', '2023-07-21', 0, NULL, NULL, NULL, '2024-05-26 11:53:26', '2024-05-26 11:53:26'), (107, 'Pemasukan', 'H. Hamzah', 'Uang', NULL, '100000', '2023-07-21', 0, NULL, NULL, NULL, '2024-05-26 11:53:55', '2024-05-26 11:53:55'), (108, 'Pemasukan', 'Hendri/Hj.Sia', 'Uang', NULL, '100000', '2023-07-23', 0, NULL, NULL, NULL, '2024-05-26 11:54:21', '2024-05-26 11:54:21'), (109, 'Pemasukan', 'kotak amal', 'Uang', NULL, '592000', '2023-06-23', 0, NULL, NULL, NULL, '2024-05-26 11:54:48', '2024-05-26 11:54:48'), (110, 'Pemasukan', 'Hj. Eda', 'Uang', NULL, '200000', '2023-07-23', 0, NULL, NULL, NULL, '2024-05-26 11:55:08', '2024-05-26 11:55:08'), (111, 'Pemasukan', 'hamba Alloh', 'Uang', NULL, '200000', '2023-07-23', 0, NULL, NULL, NULL, '2024-05-26 11:55:35', '2024-05-26 11:55:35'), (112, 'Pemasukan', 'muh. ilham', 'Uang', NULL, '100000', '2023-07-23', 0, NULL, NULL, NULL, '2024-05-26 11:56:26', '2024-05-26 11:56:26'), (113, 'Pemasukan', 'Hj. Murni ', 'Uang', NULL, '100000', '2023-07-24', 0, NULL, NULL, NULL, '2024-05-26 11:56:46', '2024-05-26 11:56:46'), (114, 'Pengeluaran', NULL, 'Uang', NULL, '1807000', '2023-07-24', 0, NULL, NULL, NULL, '2024-05-26 11:57:05', '2024-05-26 11:57:05'), (115, 'Pemasukan', 'andy', 'Uang', NULL, '1350000', '2023-07-18', 0, NULL, NULL, NULL, '2024-05-26 11:58:00', '2024-05-26 11:58:00'), (116, 'Pemasukan', 'almh rahmani', 'Uang', NULL, '100000', '2023-07-18', 0, NULL, NULL, NULL, '2024-05-26 11:59:12', '2024-05-26 11:59:12'), (117, 'Pemasukan', 'Salim', 'Uang', NULL, '100000', '2023-07-26', 0, NULL, NULL, NULL, '2024-05-26 12:00:02', '2024-05-26 12:00:02'), (118, 'Pemasukan', 'H. Taswin', 'Uang', NULL, '200000', '2023-07-28', 0, NULL, NULL, NULL, '2024-05-26 12:00:31', '2024-05-26 12:00:31'), (119, 'Pemasukan', 'Muh Akbar', 'Uang', NULL, '50000', '2023-07-28', 0, NULL, NULL, NULL, '2024-05-26 12:01:05', '2024-05-26 12:01:05'), (120, 'Pemasukan', 'Muh. Munawir', 'Uang', NULL, '50000', '2023-07-28', 0, NULL, NULL, NULL, '2024-05-26 12:01:27', '2024-05-26 12:01:27'), (121, 'Pemasukan', 'Rafika Sekeluarga', 'Uang', NULL, '150000', '2023-07-28', 0, NULL, NULL, NULL, '2024-05-26 12:01:50', '2024-05-26 12:01:50'), (122, 'Pemasukan', 'Dwi Septiani', 'Uang', NULL, '88000', '2023-07-28', 0, NULL, NULL, NULL, '2024-05-26 12:02:23', '2024-05-26 12:02:23'), (123, 'Pemasukan', 'iwang bintang', 'Uang', NULL, '50000', '2023-07-28', 0, NULL, NULL, NULL, '2024-05-26 12:02:52', '2024-05-26 12:02:52'), (124, 'Pemasukan', 'hamba Allah', 'Uang', NULL, '300000', '2023-07-28', 0, NULL, NULL, NULL, '2024-05-26 12:03:20', '2024-05-26 12:03:20'), (125, 'Pemasukan', 'hamba Alloh', 'Uang', NULL, '250000', '2023-07-28', 0, NULL, NULL, NULL, '2024-05-26 12:03:43', '2024-05-26 12:03:43'), (126, 'Pemasukan', 'Nawir', 'Uang', NULL, '250000', '2023-07-28', 0, NULL, NULL, NULL, '2024-05-26 12:04:02', '2024-05-26 12:04:02'), (127, 'Pemasukan', 'Muh.Nasir', 'Uang', NULL, '300000', '2023-07-28', 0, NULL, NULL, NULL, '2024-05-26 12:04:32', '2024-05-26 12:04:32'), (128, 'Pemasukan', 'Hj. Saddiah', 'Uang', NULL, '500000', '2023-07-28', 0, NULL, NULL, NULL, '2024-05-26 12:31:25', '2024-05-26 12:31:25'), (129, 'Pemasukan', 'andi muh farhan', 'Uang', NULL, '200000', '2023-07-28', 0, NULL, NULL, NULL, '2024-05-26 12:32:12', '2024-05-26 12:32:12'), (130, 'Pemasukan', 'Nur farelia arwan', 'Uang', NULL, '300000', '2023-07-28', 0, NULL, NULL, NULL, '2024-05-26 12:32:41', '2024-05-26 12:32:41'), (131, 'Pemasukan', 'Erwin syah. sek', 'Uang', NULL, '100000', '2023-07-28', 0, NULL, NULL, NULL, '2024-05-26 12:33:03', '2024-05-26 12:33:03'), (132, 'Pemasukan', 'Hj. Masyara', 'Uang', NULL, '500000', '2023-07-28', 0, NULL, NULL, NULL, '2024-05-26 12:33:35', '2024-05-26 12:33:35'), (133, 'Pemasukan', 'Alm. lamakka', 'Uang', NULL, '500000', '2023-07-28', 0, NULL, NULL, NULL, '2024-05-26 12:34:25', '2024-05-26 12:34:25'), (134, 'Pemasukan', 'alh. isa', 'Uang', NULL, '500000', '2023-07-28', 0, NULL, NULL, NULL, '2024-05-26 12:34:53', '2024-05-26 12:34:53'), (135, 'Pemasukan', 'alh. lateke', 'Uang', NULL, '100000', '2023-07-28', 0, NULL, NULL, NULL, '2024-05-26 12:35:18', '2024-05-26 12:35:18'), (136, 'Pemasukan', 'alh. ipung', 'Uang', NULL, '100000', '2023-07-28', 0, NULL, NULL, NULL, '2024-05-26 12:35:39', '2024-05-26 12:35:39'), (137, 'Pemasukan', 'alh. laonggo', 'Uang', NULL, '100000', '2023-07-28', 0, NULL, NULL, NULL, '2024-05-26 12:36:13', '2024-05-26 12:36:13'), (138, 'Pemasukan', 'alh. ratingga', 'Uang', NULL, '100000', '2023-07-28', 0, NULL, NULL, NULL, '2024-05-26 12:36:33', '2024-05-26 12:36:33'), (139, 'Pemasukan', 'Hj. Nurhayati Thamrin', 'Uang', NULL, '200000', '2023-07-28', 0, NULL, NULL, NULL, '2024-05-26 12:37:11', '2024-05-26 12:37:11'), (140, 'Pemasukan', 'Hj. andi Mulyani', 'Uang', NULL, '100000', '2023-07-28', 0, NULL, NULL, NULL, '2024-05-26 12:37:38', '2024-05-26 12:37:38'), (141, 'Pemasukan', 'Hj. Saurah', 'Uang', NULL, '200000', '2023-07-28', 0, NULL, NULL, NULL, '2024-05-26 12:38:02', '2024-05-26 12:38:02'), (142, 'Pemasukan', 'H. Lukman/Hj.Suri', 'Uang', NULL, '100000', '2023-07-28', 0, NULL, NULL, NULL, '2024-05-26 12:38:30', '2024-05-26 12:38:30'), (143, 'Pemasukan', 'alm. H. Hadir dan Nurhayati', 'Uang', NULL, '100000', '2023-07-28', 0, NULL, NULL, NULL, '2024-05-26 12:38:58', '2024-05-26 12:38:58'), (144, 'Pemasukan', 'Abd. Hafid', 'Uang', NULL, '100000', '2023-07-28', 0, NULL, NULL, NULL, '2024-05-26 12:39:19', '2024-05-26 12:39:19'), (145, 'Pemasukan', 'Dr. Hj. A. Rismawaty Darma', 'Uang', NULL, '500000', '2023-07-28', 0, NULL, NULL, NULL, '2024-05-26 12:39:48', '2024-05-26 12:39:48'), (146, 'Pengeluaran', NULL, 'Uang', NULL, '7938000', '2023-07-29', 0, NULL, NULL, NULL, '2024-05-26 12:40:10', '2024-05-26 12:40:10'), (147, 'Pemasukan', 'Suarni', 'Uang', NULL, '100000', '2023-07-30', 0, NULL, NULL, NULL, '2024-05-26 12:40:55', '2024-05-26 12:40:55'), (148, 'Pemasukan', 'Nabila', 'Uang', NULL, '300000', '2023-07-31', 0, NULL, NULL, NULL, '2024-05-26 12:41:15', '2024-05-26 12:41:15'), (149, 'Pemasukan', 'alm. H. P. Daeuy/ hj.p.camu', 'Uang', NULL, '50000', '2023-08-01', 0, NULL, NULL, NULL, '2024-05-26 12:43:50', '2024-05-26 12:43:50'), (150, 'Pemasukan', 'H. P. Salihi/H.P.Nursiah', 'Uang', NULL, '50000', '2023-08-01', 0, NULL, NULL, NULL, '2024-05-26 12:44:43', '2024-05-26 12:44:43'), (151, 'Pemasukan', 'nurlfliha khaerah', 'Uang', NULL, '1000000', '2023-08-01', 0, NULL, NULL, NULL, '2024-05-26 12:45:39', '2024-05-26 12:45:39'), (152, 'Pemasukan', 'adama. sek', 'Uang', NULL, '100000', '2023-08-01', 0, NULL, NULL, NULL, '2024-05-26 12:46:10', '2024-05-26 12:46:10'), (153, 'Pemasukan', 'hamba allah', 'Uang', NULL, '250000', '2023-08-04', 0, NULL, NULL, NULL, '2024-05-26 12:46:44', '2024-05-26 12:46:44'), (154, 'Pemasukan', 'salin', 'Uang', NULL, '100000', '2023-08-04', 0, NULL, NULL, NULL, '2024-05-26 12:47:18', '2024-05-26 12:47:18'), (155, 'Pemasukan', 'Hj. Diana', 'Uang', NULL, '100000', '2023-08-04', 0, NULL, NULL, NULL, '2024-05-26 12:47:36', '2024-05-26 12:47:36'), (156, 'Pemasukan', 'H. Hamzah', 'Uang', NULL, '100000', '2023-08-04', 0, NULL, NULL, NULL, '2024-05-26 12:48:12', '2024-05-26 12:48:12'), (157, 'Pemasukan', 'Hj. Gustiati', 'Uang', NULL, '50000', '2023-08-04', 0, NULL, NULL, NULL, '2024-05-26 12:48:37', '2024-05-26 12:48:37'), (158, 'Pemasukan', 'hamba Allah', 'Uang', NULL, '700000', '2023-08-04', 0, NULL, NULL, NULL, '2024-05-26 12:49:00', '2024-05-26 12:49:00'), (159, 'Pemasukan', 'Hj. Herlina', 'Uang', NULL, '100000', '2023-08-04', 0, NULL, NULL, NULL, '2024-05-26 12:49:22', '2024-05-26 12:49:22'), (160, 'Pemasukan', 'H. lukman / Hj. Surianti', 'Uang', NULL, '100000', '2023-08-04', 0, NULL, NULL, NULL, '2024-05-26 12:50:06', '2024-05-26 12:50:06'), (161, 'Pemasukan', 'Yusril', 'Uang', NULL, '50000', '2023-08-04', 0, NULL, NULL, NULL, '2024-05-26 12:50:27', '2024-05-26 12:50:27'), (162, 'Pemasukan', 'Muh. Afzal Athallah', 'Uang', NULL, '1000000', '2023-08-05', 0, NULL, NULL, NULL, '2024-05-26 12:51:12', '2024-05-26 12:51:12'), (163, 'Pemasukan', 'hasim', 'Uang', NULL, '100000', '2023-08-05', 0, NULL, NULL, NULL, '2024-05-26 12:51:34', '2024-05-26 12:51:34'), (164, 'Pemasukan', 'ibu lela', 'Uang', NULL, '550000', '2023-08-06', 0, NULL, NULL, NULL, '2024-05-26 12:51:53', '2024-05-26 12:51:53'), (165, 'Pengeluaran', NULL, 'Uang', NULL, '870000', '2023-08-06', 0, NULL, NULL, NULL, '2024-05-26 12:52:19', '2024-05-26 12:52:19'), (166, 'Pemasukan', 'Hasniyar', 'Uang', NULL, '100000', '2023-08-07', 0, NULL, NULL, NULL, '2024-05-28 11:16:29', '2024-05-28 11:16:29'), (167, 'Pemasukan', 'hardiyanti cahyani tahir', 'Uang', NULL, '50000', '2023-08-07', 0, NULL, NULL, NULL, '2024-05-28 11:17:12', '2024-05-28 11:17:12'), (168, 'Pemasukan', 'PT. Darma Lautan Utama', 'Uang', NULL, '4000000', '2023-08-08', 0, NULL, NULL, NULL, '2024-05-28 11:18:02', '2024-05-28 11:18:02'), (169, 'Pemasukan', 'ibra la irhan', 'Uang', NULL, '270000', '2023-08-09', 0, NULL, NULL, NULL, '2024-05-28 11:18:38', '2024-05-28 11:18:38'), (170, 'Pemasukan', 'ibu Nuralam', 'Uang', NULL, '200000', '2023-08-10', 0, NULL, NULL, NULL, '2024-05-28 11:19:07', '2024-05-28 11:19:07'), (171, 'Pemasukan', 'H. Iwan', 'Uang', NULL, '100000', '2023-08-11', 0, NULL, NULL, NULL, '2024-05-28 11:19:44', '2024-05-28 11:19:44'), (172, 'Pemasukan', 'H. Taswin', 'Uang', NULL, '200000', '2023-08-11', 0, NULL, NULL, NULL, '2024-05-28 11:21:28', '2024-05-28 11:21:28'), (173, 'Pemasukan', 'A. Reski. T', 'Uang', NULL, '300000', '2023-08-11', 0, NULL, NULL, NULL, '2024-05-28 11:22:05', '2024-05-28 11:22:05'), (174, 'Pemasukan', 'Hamba Allah', 'Uang', NULL, '250000', '2023-08-11', 0, NULL, NULL, NULL, '2024-05-28 11:22:36', '2024-05-28 11:22:36'), (175, 'Pemasukan', 'Hamba Allah', 'Uang', NULL, '200000', '2023-08-11', 0, NULL, NULL, NULL, '2024-05-28 11:23:05', '2024-05-28 11:23:05'), (176, 'Pemasukan', 'Normah/Muh saleh', 'Uang', NULL, '200000', '2023-08-11', 0, NULL, NULL, NULL, '2024-05-28 11:24:00', '2024-05-28 11:24:00'), (177, 'Pemasukan', 'Alam', 'Uang', NULL, '100000', '2023-08-11', 0, NULL, NULL, NULL, '2024-05-28 11:24:21', '2024-05-28 11:24:21'), (178, 'Pemasukan', 'sedekah subuh muh al-ghifari', 'Uang', NULL, '350000', '2023-08-11', 0, NULL, NULL, NULL, '2024-05-28 11:25:04', '2024-05-28 11:25:04'), (179, 'Pemasukan', 'H. Hamzah', 'Uang', NULL, '100000', '2023-08-11', 0, NULL, NULL, NULL, '2024-05-28 11:25:39', '2024-05-28 11:25:39'), (180, 'Pemasukan', 'Hj. Gusti', 'Uang', NULL, '100000', '2023-08-11', 0, NULL, NULL, NULL, '2024-05-28 11:26:00', '2024-05-28 11:26:00'), (181, 'Pemasukan', 'Rosmala', 'Uang', NULL, '100000', '2023-08-11', 0, NULL, NULL, NULL, '2024-05-28 11:26:16', '2024-05-28 11:26:16'), (182, 'Pemasukan', 'Thamrin', 'Uang', NULL, '500000', '2023-08-11', 0, NULL, NULL, NULL, '2024-05-28 11:26:42', '2024-05-28 11:26:42'), (183, 'Pemasukan', 'alzara pare', 'Barang', 'sembako', NULL, '2023-08-11', 0, 'Beras', 'Kg', '', '2024-05-28 11:27:54', '2024-05-28 11:27:54'), (184, 'Pengeluaran', NULL, 'Uang', NULL, '1455000', '2023-08-12', 0, NULL, NULL, NULL, '2024-05-28 11:28:48', '2024-05-28 11:28:48'), (185, 'Pemasukan', 'metry Wijaya/gallery phone', 'Uang', NULL, '300000', '2023-12-30', 0, NULL, NULL, NULL, '2024-05-29 09:05:27', '2024-05-29 09:05:27'), (186, 'Pemasukan', 'Erulmunin', 'Uang', NULL, '150000', '2023-12-30', 0, NULL, NULL, NULL, '2024-05-29 09:06:04', '2024-05-29 09:06:04'), (187, 'Pemasukan', 'Hamba Allah', 'Uang', NULL, '200000', '2024-01-01', 0, NULL, NULL, NULL, '2024-05-29 09:06:41', '2024-05-29 09:06:41'), (188, 'Pemasukan', 'hamba allah', 'Uang', NULL, '50000', '2024-01-02', 0, NULL, NULL, NULL, '2024-05-29 09:08:06', '2024-05-29 09:08:06'), (189, 'Pemasukan', 'Hamba Allah', 'Uang', NULL, '700000', '2024-01-02', 0, NULL, NULL, NULL, '2024-05-29 09:12:58', '2024-05-29 09:12:58'), (190, 'Pemasukan', 'Salin', 'Uang', NULL, '100000', '2024-01-04', 0, NULL, NULL, NULL, '2024-05-29 09:17:49', '2024-05-29 09:17:49'), (191, 'Pemasukan', 'guru SMP 2 parepare', 'Uang', NULL, '500000', '2024-01-05', 0, NULL, NULL, NULL, '2024-05-29 09:19:18', '2024-05-29 09:19:18'), (192, 'Pemasukan', 'hendra/ hj sia', 'Uang', NULL, '100000', '2024-01-05', 0, NULL, NULL, NULL, '2024-05-29 09:21:11', '2024-05-29 09:21:11'), (193, 'Pemasukan', 'H. Taswin', 'Uang', NULL, '200000', '2024-01-05', 0, NULL, NULL, NULL, '2024-05-29 09:22:03', '2024-05-29 09:22:03'), (194, 'Pemasukan', 'Hj. Nurhayati Thamrin', 'Uang', NULL, '100000', '2024-01-05', 0, NULL, NULL, NULL, '2024-05-29 09:24:02', '2024-05-29 09:24:02'), (195, 'Pemasukan', 'hajeriah/nurhafiah', 'Uang', NULL, '500000', '2024-01-05', 0, NULL, NULL, NULL, '2024-05-29 09:25:07', '2024-05-29 09:25:07'), (196, 'Pemasukan', 'H. hamzah / Hj. Gusti', 'Uang', NULL, '200000', '2024-01-05', 0, NULL, NULL, NULL, '2024-05-29 09:27:14', '2024-05-29 09:27:14'), (197, 'Pemasukan', 'surianti Dirgahayu', 'Uang', NULL, '200000', '2024-01-05', 0, NULL, NULL, NULL, '2024-05-29 09:28:26', '2024-05-29 09:28:26'), (198, 'Pemasukan', 'M. Yusri', 'Uang', NULL, '500000', '2024-01-05', 0, NULL, NULL, NULL, '2024-05-29 09:29:10', '2024-05-29 09:29:10'), (199, 'Pemasukan', 'PT. Darma lautan Utama', 'Uang', NULL, '4000000', '2024-01-05', 0, NULL, NULL, NULL, '2024-05-29 09:30:06', '2024-05-29 09:30:06'), (200, 'Pemasukan', 'sisa akikah', 'Uang', NULL, '200000', '2024-01-06', 0, NULL, NULL, NULL, '2024-05-29 09:31:12', '2024-05-29 09:31:12'), (201, 'Pengeluaran', NULL, 'Uang', NULL, '138000', '2024-01-06', 0, NULL, NULL, NULL, '2024-05-29 09:31:53', '2024-05-29 09:31:53'), (202, 'Pemasukan', 'aln. Amsiri/ alm amsiyah', 'Uang', NULL, '150000', '2024-01-06', 0, NULL, NULL, NULL, '2024-05-29 09:33:10', '2024-05-29 09:33:10'), (203, 'Pemasukan', 'Ayu', 'Uang', NULL, '500000', '2024-01-07', 0, NULL, NULL, NULL, '2024-05-29 09:33:38', '2024-05-29 09:33:38'), (204, 'Pemasukan', 'Riswandi', 'Uang', NULL, '200000', '2024-01-07', 0, NULL, NULL, NULL, '2024-05-29 09:34:28', '2024-05-29 09:34:28'), (205, 'Pemasukan', 'juliwanti', 'Uang', NULL, '50000', '2024-01-07', 0, NULL, NULL, NULL, '2024-05-29 09:34:47', '2024-05-29 09:34:47'), (206, 'Pemasukan', 'Hj. dahlia sek ', 'Uang', NULL, '500000', '2024-01-07', 0, NULL, NULL, NULL, '2024-05-29 09:35:23', '2024-05-29 09:35:23'), (207, 'Pemasukan', 'Hj. dahlia. sek', 'Uang', NULL, '1000000', '2024-01-07', 0, NULL, NULL, NULL, '2024-05-29 09:35:49', '2024-05-29 09:35:49'), (208, 'Pemasukan', 'Rosmina Tappa', 'Uang', NULL, '300000', '2024-01-07', 0, NULL, NULL, NULL, '2024-05-29 09:36:19', '2024-05-29 09:36:19'), (209, 'Pemasukan', 'hamba allah', 'Uang', NULL, '2500000', '2024-01-07', 0, NULL, NULL, NULL, '2024-05-29 09:36:51', '2024-05-29 09:36:51'), (210, 'Pemasukan', 'H. Hamzah', 'Uang', NULL, '116000', '2024-01-12', 0, NULL, NULL, NULL, '2024-05-29 09:37:20', '2024-05-29 09:37:20'), (211, 'Pemasukan', 'Hj. Gusti', 'Uang', NULL, '100000', '2024-01-12', 0, NULL, NULL, NULL, '2024-05-29 09:37:50', '2024-05-29 09:37:50'), (212, 'Pemasukan', 'Rosmadewi', 'Uang', NULL, '50000', '2024-01-12', 0, NULL, NULL, NULL, '2024-05-29 09:38:22', '2024-05-29 09:38:22'), (213, 'Pemasukan', 'Annisa Putri Tami', 'Uang', NULL, '100000', '2024-01-12', 0, NULL, NULL, NULL, '2024-05-29 09:38:48', '2024-05-29 09:38:48'), (214, 'Pengeluaran', NULL, 'Uang', NULL, '607000', '2024-01-13', 0, NULL, NULL, NULL, '2024-05-29 09:39:09', '2024-05-29 09:39:09'), (215, 'Pemasukan', 'Hj. djahrias', 'Uang', NULL, '200000', '2024-01-15', 0, NULL, NULL, NULL, '2024-05-29 09:40:57', '2024-05-29 09:40:57'), (216, 'Pemasukan', 'Hamba Allah', 'Uang', NULL, '1000000', '2024-01-16', 0, NULL, NULL, NULL, '2024-05-29 09:41:20', '2024-05-29 09:41:20'), (217, 'Pemasukan', 'H. Ramli', 'Uang', NULL, '400000', '2024-01-17', 0, NULL, NULL, NULL, '2024-05-29 09:41:40', '2024-05-29 09:41:40'), (218, 'Pemasukan', 'Irwansyah', 'Uang', NULL, '1000000', '2024-01-18', 0, NULL, NULL, NULL, '2024-05-29 09:42:17', '2024-05-29 09:42:17'), (219, 'Pemasukan', 'H. Taswin', 'Uang', NULL, '200000', '2024-01-19', 0, NULL, NULL, NULL, '2024-05-29 09:42:36', '2024-05-29 09:42:36'), (220, 'Pemasukan', 'Hamba Alla', 'Uang', NULL, '250000', '2024-01-19', 0, NULL, NULL, NULL, '2024-05-29 09:43:04', '2024-05-29 09:43:04'), (221, 'Pemasukan', 'Aswar', 'Uang', NULL, '150000', '2024-01-19', 0, NULL, NULL, NULL, '2024-05-29 09:43:23', '2024-05-29 09:43:23'), (222, 'Pemasukan', 'muh abbas/ muh. munawwar', 'Uang', NULL, '100000', '2024-01-19', 0, NULL, NULL, NULL, '2024-05-29 09:43:56', '2024-05-29 09:43:56'), (223, 'Pemasukan', 'H. umar', 'Uang', NULL, '250000', '2024-01-19', 0, NULL, NULL, NULL, '2024-05-29 09:44:15', '2024-05-29 09:44:15'), (224, 'Pemasukan', 'H. Minang', 'Uang', NULL, '100000', '2024-01-19', 0, NULL, NULL, NULL, '2024-05-29 09:45:01', '2024-05-29 09:45:01'), (225, 'Pemasukan', 'salin', 'Uang', NULL, '100000', '2024-01-19', 0, NULL, NULL, NULL, '2024-05-29 09:46:13', '2024-05-29 09:46:13'), (226, 'Pemasukan', 'kotak amal', 'Uang', NULL, '519000', '2024-01-19', 0, NULL, NULL, NULL, '2024-05-29 09:46:31', '2024-05-29 09:46:31'), (227, 'Pemasukan', 'gallery phone', 'Uang', NULL, '300000', '2024-01-20', 0, NULL, NULL, NULL, '2024-05-29 09:46:52', '2024-05-29 09:46:52'), (228, 'Pemasukan', 'agus', 'Uang', NULL, '4500000', '2024-01-21', 0, NULL, NULL, NULL, '2024-05-29 09:47:32', '2024-05-29 09:47:32'), (229, 'Pemasukan', 'Hj. Eda', 'Uang', NULL, '200000', '2024-01-21', 0, NULL, NULL, NULL, '2024-05-29 09:48:05', '2024-05-29 09:48:05'), (230, 'Pemasukan', 'H. Hasan. Sek', 'Uang', NULL, '250000', '2024-01-24', 0, NULL, NULL, NULL, '2024-05-29 09:48:27', '2024-05-29 09:48:27'), (231, 'Pemasukan', 'H. Taswin', 'Uang', NULL, '200000', '2024-01-26', 0, NULL, NULL, NULL, '2024-05-29 09:48:48', '2024-05-29 09:48:48'), (232, 'Pemasukan', 'Dwi Septiani ', 'Uang', NULL, '50000', '2024-01-26', 0, NULL, NULL, NULL, '2024-05-29 09:49:26', '2024-05-29 09:49:26'), (233, 'Pemasukan', 'H. Hamzah', 'Uang', NULL, '100000', '2024-01-26', 0, NULL, NULL, NULL, '2024-05-29 09:49:55', '2024-05-29 09:49:55'), (234, 'Pemasukan', 'Muh Akbar / Muh Munawir', 'Uang', NULL, '100000', '2024-01-26', 0, NULL, NULL, NULL, '2024-05-29 09:50:20', '2024-05-29 09:50:20'), (235, 'Pemasukan', 'Hj. Gusti', 'Uang', NULL, '100000', '2024-01-26', 0, NULL, NULL, NULL, '2024-05-29 09:50:37', '2024-05-29 09:50:37'), (236, 'Pemasukan', 'Rosmala', 'Uang', NULL, '100000', '2024-01-26', 0, NULL, NULL, NULL, '2024-05-29 09:52:32', '2024-05-29 09:52:32'), (237, 'Pemasukan', 'dr. hj. A. Rismawaty', 'Uang', NULL, '640000', '2024-01-26', 0, NULL, NULL, NULL, '2024-05-29 09:53:08', '2024-05-29 09:53:08'), (238, 'Pemasukan', 'Annisa Putri Tami', 'Uang', NULL, '100000', '2024-01-26', 0, NULL, NULL, NULL, '2024-05-29 09:53:48', '2024-05-29 09:53:48'), (239, 'Pemasukan', 'Andi Sabring Binti Zainuddin', 'Uang', NULL, '100000', '2024-01-26', 0, NULL, NULL, NULL, '2024-05-29 09:54:28', '2024-05-29 09:54:28'), (240, 'Pengeluaran', NULL, 'Uang', NULL, '1687000', '2024-01-27', 0, NULL, NULL, NULL, '2024-05-29 09:54:49', '2024-05-29 09:54:49'), (241, 'Pemasukan', 'alm. H. Pute/almh. hj. nani', 'Uang', NULL, '200000', '2024-01-28', 0, NULL, NULL, NULL, '2024-05-29 09:55:44', '2024-05-29 09:55:44'), (242, 'Pemasukan', 'eva saad', 'Uang', NULL, '100000', '2024-01-28', 0, NULL, NULL, NULL, '2024-05-29 09:56:01', '2024-05-29 09:56:01'), (243, 'Pemasukan', 'hj. nurhayati Thamrin', 'Uang', NULL, '100000', '2024-02-01', 0, NULL, NULL, NULL, '2024-05-29 09:56:37', '2024-05-29 09:56:37'), (244, 'Pemasukan', 'Sisa Akikah', 'Uang', NULL, '400000', '2024-02-01', 0, NULL, NULL, NULL, '2024-05-29 09:57:01', '2024-05-29 09:57:01'), (245, 'Pemasukan', 'Andini', 'Barang', 'Beras', '10', '2024-01-01', 0, 'Beras', 'Kg', '', '2024-05-29 10:03:59', '2024-05-29 10:03:59'), (246, 'Pemasukan', 'PLN Batam Yg ada di suppa', 'Barang', 'Sembako', '5', '2024-01-02', 0, 'Beras', 'Kg', '', '2024-05-29 10:05:49', '2024-05-29 10:05:49'), (247, 'Pemasukan', 'Wahyuddin', 'Barang', 'Beras Telur', '10', '2024-01-02', 0, 'Beras', 'Kg', '', '2024-05-29 10:08:37', '2024-05-29 10:08:37'), (248, 'Pemasukan', 'Jamal', 'Uang', NULL, '200000', '2024-05-04', 0, NULL, NULL, NULL, '2024-06-04 20:59:47', '2024-06-04 20:59:47'), (249, 'Pemasukan', 'Jamal', 'Barang', 'Pemberian Beras 10 kg', '10', '2024-05-05', 0, 'Beras', 'Kg', '10', '2024-06-05 15:41:37', '2024-06-05 15:41:37'); -- -------------------------------------------------------- -- -- Table structure for table `tb_dana_sosial_khusus` -- CREATE TABLE `tb_dana_sosial_khusus` ( `id_dana_sosial` int(11) NOT NULL, `id_donatur` int(2) NOT NULL, `bentuk` varchar(15) NOT NULL, `jenis` varchar(10) NOT NULL, `ket` text DEFAULT NULL, `jumlah` varchar(11) DEFAULT NULL, `tanggal` date NOT NULL, `status` int(11) NOT NULL DEFAULT 0, `jenis_barang` varchar(20) DEFAULT NULL, `satuan` varchar(10) DEFAULT NULL, `jumlah_barang` varchar(3) DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `tb_dana_sosial_khusus` -- INSERT INTO `tb_dana_sosial_khusus` (`id_dana_sosial`, `id_donatur`, `bentuk`, `jenis`, `ket`, `jumlah`, `tanggal`, `status`, `jenis_barang`, `satuan`, `jumlah_barang`, `created_at`, `updated_at`) VALUES (1, 1, 'Pemasukan', 'Uang', NULL, '200000', '2023-08-11', 0, NULL, NULL, NULL, '2024-05-28 11:20:48', '2024-05-28 11:20:48'); -- -------------------------------------------------------- -- -- Table structure for table `tb_donatur` -- CREATE TABLE `tb_donatur` ( `id_donatur` int(2) NOT NULL, `nama_donatur` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `tb_donatur` -- INSERT INTO `tb_donatur` (`id_donatur`, `nama_donatur`) VALUES (1, 'H. Taswin'); -- -------------------------------------------------------- -- -- Table structure for table `tb_jabatan` -- CREATE TABLE `tb_jabatan` ( `id` int(3) NOT NULL, `nama` varchar(100) NOT NULL, `jabatan` varchar(50) NOT NULL, `img_url` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `tb_jabatan` -- INSERT INTO `tb_jabatan` (`id`, `nama`, `jabatan`, `img_url`) VALUES (1, 'Dra. Hj Cia', 'Ketua', 'assets/jabatan/1/IMG-20240507-WA0003.jpg'), (2, 'Fitriana Bunyanis, S.SI, M.Kes', 'Sekretaris', 'assets/jabatan/2/IMG-20240507-WA0003.jpg'), (3, 'HJ. Jaliah, Ama', 'Bendahara', 'assets/jabatan/3/IMG-20240507-WA0003.jpg'), (4, 'Datang, S.Ag', 'Seksi Pengasuh', 'assets/jabatan/4/IMG-20240507-WA0003.jpg'), (5, 'Darwan', 'Seksi Pengasuh', 'assets/jabatan/5/IMG-20240507-WA0002.jpg'), (6, 'Drs. Ust. Najib.L', 'Seksi Ibadah', 'assets/jabatan/6/IMG-20240507-WA0002.jpg'), (7, 'Ust. Abd. Rahman, S.Sos', 'Seksi Ibadah', 'assets/jabatan/7/IMG-20240507-WA0002.jpg'), (8, 'Faizah Mansyur', 'Seksi Pendidikan', 'assets/jabatan/8/IMG-20240507-WA0003.jpg'), (10, 'Firdaus', 'Seksi Keamanan', 'assets/jabatan/10/IMG-20240507-WA0002.jpg'), (11, 'Ahmad', 'Seksi Keamanan', 'assets/jabatan/11/IMG-20240507-WA0002.jpg'), (12, 'Faizah Mansyur', 'Seksi Keterampilan', 'assets/jabatan/12/IMG-20240507-WA0003.jpg'), (13, 'Fatmawati', 'Seksi Konsumsi', 'assets/jabatan/13/IMG-20240507-WA0003.jpg'), (18, 'nur', 'Seksi Kebersihan', 'assets/jabatan/18/+62 823-4921-0714 20240603_110344.jpg'), (19, 'Nur Ikhwana', 'Wakil Bendahara', 'assets/jabatan/19/+62 823-4921-0714 20240603_110344.jpg'); -- -------------------------------------------------------- -- -- Table structure for table `tb_siswa` -- CREATE TABLE `tb_siswa` ( `id_siswa` int(10) NOT NULL, `nama` varchar(100) NOT NULL, `tanggal_lahir` date NOT NULL, `jenis_kelamin` varchar(10) NOT NULL, `alamat` varchar(200) NOT NULL, `kemampuan` text NOT NULL, `img_url` text NOT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp(), `tempat_lahir` varchar(100) DEFAULT NULL, `no_telpon` varchar(13) DEFAULT NULL, `agama` varchar(20) DEFAULT NULL, `kewarganegaraan` varchar(20) DEFAULT NULL, `pendidikan_sd` text DEFAULT NULL, `pendidikan_smp` text DEFAULT NULL, `pendidikan_sma` text DEFAULT NULL, `hobi` text DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `tb_siswa` -- INSERT INTO `tb_siswa` (`id_siswa`, `nama`, `tanggal_lahir`, `jenis_kelamin`, `alamat`, `kemampuan`, `img_url`, `created_at`, `updated_at`, `tempat_lahir`, `no_telpon`, `agama`, `kewarganegaraan`, `pendidikan_sd`, `pendidikan_smp`, `pendidikan_sma`, `hobi`) VALUES (2, 'ahmad faril', '2009-09-14', 'Laki-laki', 'jl. panti asuhan no 3 parepare', 'menguasai basket dan menguasai surat 3 Qul, Al-Maun - Al-kausar', 'assets/siswa/2/IMG-20240327-WA0006.jpg', '2024-03-26 20:34:19', '2024-03-26 20:34:19', 'Letta', '0', 'islma', 'indonesia', 'SD 200 lembang', 'SMP muhammadiyah', '-', 'bermain basket'), (3, 'firman', '2004-01-02', 'Laki-laki', 'jl. panti asuhan no 3 parepare', 'menguasai suratpendek dari surat al-fatihah SD/ surat ad-duha', 'assets/siswa/3/IMG-20240327-WA0006.jpg', '2024-03-26 20:36:16', '2024-03-26 20:36:16', 'parepare', '085298962023', 'islam', 'indonesia', 'SD SLB parepare', 'SMP SLB parepare', '-', 'menghafal'), (4, 'Muh. jusman syaputra', '2009-01-01', 'Laki-laki', 'jl. panti asuhan no 3 parepare', 'menguasai jus 30', 'assets/siswa/4/IMG-20240327-WA0006.jpg', '2024-03-26 20:38:04', '2024-03-26 20:38:04', 'cambiku', '082293969811', 'islam', 'indonesia', 'SD negeri 4 napabalano', 'SMP muhammadiyah', '-', 'basket dan bola'), (5, 'ali musa', '2006-12-05', 'Laki-laki', 'jl. panti asuhan no 3 parepare', 'mampu menghapal suara al-fatihah sd/ al-qoriah', 'assets/siswa/5/IMG-20240327-WA0006.jpg', '2024-03-26 20:40:01', '2024-03-26 20:40:01', 'letta', '0', 'islam', 'indonesia', 'SD 200 lembang', 'SMP muhammadiyah parepare', '-', 'bermain basket'), (6, 'arjun', '2006-06-28', 'Laki-laki', 'jl. panti asuhan no 3 parepare', 'menguasai 3 surat dari jus 29', 'assets/siswa/6/IMG-20240327-WA0006.jpg', '2024-03-26 20:41:45', '2024-03-26 20:41:45', 'makassar', '0', 'islam', 'indonesia', 'SD muhammadiyah parepare', 'SMP Muhammadiyah parepare', 'SMK muhamnadiyah parepare', 'sepak bola'), (7, 'M. Warban', '2011-04-17', 'Laki-laki', 'jl. panti asuhan no 3 parepare', 'menghafal surat an-nas sampai surat albalaq', 'assets/siswa/7/IMG-20240327-WA0006.jpg', '2024-03-26 20:46:48', '2024-03-26 20:46:48', 'tarakan', '085298962023', 'islam', 'indonesia', 'SD muhammadiyah parepare', '-', '-', 'bermain bola'), (8, 'fadil', '2005-01-01', 'Perempuan', 'jl. panti asuhan no 3 parepare', 'memahami pelajaran muhammadiyah dan mampu menghafal jus 30 An-naba sampai surat an-nas', 'assets/siswa/8/IMG-20240327-WA0006.jpg', '2024-03-26 20:49:11', '2024-03-26 20:49:11', 'loka', '0', 'islam', 'indonesia', 'SD muhammadiyah parepare', 'SMP muhammadiyah parepare', 'SMK muhammadiyah parepare', 'bermain basket'), (9, 'Ayu', '2010-03-05', 'Perempuan', 'jl. panti asuhan no 3 parepare', 'menghafal surat pendek an-nas s/d al-Maun', 'assets/siswa/9/IMG_20240327_042944.jpg', '2024-03-26 20:50:46', '2024-03-26 20:50:46', 'arra', '0', 'islam', 'indonesia', 'SD muhammadiyah parepare', '-', '-', 'berenang'), (10, 'ebin', '2005-07-24', 'Perempuan', 'jl. panti asuhan no 3 parepare', 'mengaji /menghafal surat pendek', 'assets/siswa/10/IMG_20240327_042944.jpg', '2024-03-26 20:52:37', '2024-03-26 20:52:37', 'kendari', '085256330779', 'islam', 'indonesia', 'SD muhammadiyah parepare', 'SMP muhammadiyah parepare', 'SMK muhammadiyah parepare', 'bulu tangkis'), (11, 'anisa aprilia salsabila', '2009-04-13', 'Perempuan', 'jl. panti asuhan no 3 parepare', 'menguasai jus 30', 'assets/siswa/11/IMG_20240327_042944.jpg', '2024-03-26 20:55:20', '2024-03-26 20:55:20', 'tangru', '0', 'islam', 'indonesia', 'SD Muhammadiyah parepare', 'SMP muhammdiyah parepare', '-', 'membaca dan menulis'), (12, 'M. Nasrul', '2008-08-16', 'Laki-laki', 'jl. panti asuhan no 3 parepare', 'menguasai surat wad-duha - an-nas', 'assets/siswa/12/IMG-20240327-WA0006.jpg', '2024-03-26 20:57:42', '2024-03-26 20:57:42', 'tangru', '081524288532', 'islam', 'indonesia', 'SD 166 tangru', 'SMP muhammadiyah parepare', '-', 'main bola'), (13, 'Azizul al hakim', '2011-01-01', 'Laki-laki', 'jl. panti asuhan no 3 parepare', 'menghafal surat al an-nas s/d surat fajar', 'assets/siswa/13/IMG-20240327-WA0006.jpg', '2024-03-26 20:59:44', '2024-03-26 20:59:44', 'palopo', '0', 'islam', 'indonesia', 'SD muhammadiyah parepare', '-', '-', 'bermain bola'), (14, 'selvi', '2007-08-07', 'Perempuan', 'jl. panti asuhan no 3 parepare', 'membaca alquran', 'assets/siswa/14/IMG_20240327_042944.jpg', '2024-03-26 21:01:12', '2024-03-26 21:01:12', 'perempuan', '085394996835', 'islam', 'indonesia', 'SD muhammadiyah parepare', 'SMP muhammadiyah parepare', '-', 'makan'), (15, 'amran sarwan', '2009-01-09', 'Laki-laki', 'jl. panti asuhan no 3 parepare', 'menguasai surat al-bayyinah s/d surat an-nas', 'assets/siswa/15/IMG-20240327-WA0006.jpg', '2024-03-26 21:02:47', '2024-03-26 21:02:47', 'tangru', '0', 'islam', 'indonesia', 'SD muhammadiyah parepare', 'SMP muhammadiyah parepare', '-', 'membaca dan olahraga'); -- -- Indexes for dumped tables -- -- -- Indexes for table `tb_dana_sosial` -- ALTER TABLE `tb_dana_sosial` ADD PRIMARY KEY (`id_dana_sosial`); -- -- Indexes for table `tb_dana_sosial_khusus` -- ALTER TABLE `tb_dana_sosial_khusus` ADD PRIMARY KEY (`id_dana_sosial`), ADD KEY `id_donatur` (`id_donatur`); -- -- Indexes for table `tb_donatur` -- ALTER TABLE `tb_donatur` ADD PRIMARY KEY (`id_donatur`); -- -- Indexes for table `tb_jabatan` -- ALTER TABLE `tb_jabatan` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tb_siswa` -- ALTER TABLE `tb_siswa` ADD PRIMARY KEY (`id_siswa`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `tb_dana_sosial` -- ALTER TABLE `tb_dana_sosial` MODIFY `id_dana_sosial` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=250; -- -- AUTO_INCREMENT for table `tb_dana_sosial_khusus` -- ALTER TABLE `tb_dana_sosial_khusus` MODIFY `id_dana_sosial` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `tb_donatur` -- ALTER TABLE `tb_donatur` MODIFY `id_donatur` int(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `tb_jabatan` -- ALTER TABLE `tb_jabatan` MODIFY `id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20; -- -- AUTO_INCREMENT for table `tb_siswa` -- ALTER TABLE `tb_siswa` MODIFY `id_siswa` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- Constraints for dumped tables -- -- -- Constraints for table `tb_dana_sosial_khusus` -- ALTER TABLE `tb_dana_sosial_khusus` ADD CONSTRAINT `tb_dana_sosial_khusus_ibfk_1` FOREIGN KEY (`id_donatur`) REFERENCES `tb_donatur` (`id_donatur`) ON DELETE CASCADE ON UPDATE CASCADE; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;