kicap
/
panti_asuhan_backend
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
panti_asuhan_backend/db_panti_asuhan (2).sql

498 lines
44 KiB
SQL
Executable File
Raw Permalink Blame History

-- 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 */;
Reference in New Issue View Git Blame Copy Permalink