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

START TRANSACTION;



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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint UNSIGNED NOT NULL,
  `reserved_at` int UNSIGNED DEFAULT NULL,
  `available_at` int UNSIGNED NOT NULL,
  `created_at` int UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext COLLATE utf8mb4_unicode_ci,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `laporan_kegiatan`
--

CREATE TABLE `laporan_kegiatan` (
  `id_kegiatan` bigint UNSIGNED NOT NULL,
  `id_user` bigint UNSIGNED NOT NULL,
  `id_lokasi` bigint UNSIGNED NOT NULL,
  `tanggal_kegiatan` date NOT NULL,
  `jenis_kegiatan` enum('Harian','Mingguan','Bulanan') COLLATE utf8mb4_unicode_ci NOT NULL,
  `deskripsi` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `gambar_sebelum` longtext COLLATE utf8mb4_unicode_ci,
  `gambar_sesudah` longtext COLLATE utf8mb4_unicode_ci,
  `is_valid` tinyint(1) NOT NULL DEFAULT '0',
  `validated_by` bigint UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `laporan_kegiatan`
--

INSERT INTO `laporan_kegiatan` (`id_kegiatan`, `id_user`, `id_lokasi`, `tanggal_kegiatan`, `jenis_kegiatan`, `deskripsi`, `gambar_sebelum`, `gambar_sesudah`, `is_valid`, `validated_by`, `created_at`, `updated_at`) VALUES
(2, 15, 4, '2024-12-30', 'Bulanan', 'Membersihkan box dispenser parkir PM1', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(3, 15, 4, '2024-12-30', 'Bulanan', 'Membersihkan box dispenser parkir PM2', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(4, 15, 4, '2024-12-30', 'Bulanan', 'Membersihkan box dispenser parkir PM3', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(5, 8, 3, '2024-12-30', 'Bulanan', 'Membersihkan box dispenser  PM1', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(6, 8, 3, '2024-12-30', 'Bulanan', 'Membersihkan box dispenser  PM2', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(10, 8, 3, '2024-12-30', 'Bulanan', 'Membersihkan box dispenser  PM3', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(17, 8, 3, '2024-12-30', 'Bulanan', 'Membersihkan box dispenser  PM4', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(18, 8, 3, '2024-12-30', 'Bulanan', 'Membersihkan box dispenser  PM5', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(19, 8, 3, '2024-12-30', 'Bulanan', 'Membersihkan PK1', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(20, 8, 3, '2024-12-30', 'Bulanan', 'Membersihkan box dispenser  PK2', '', '', 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(21, 8, 3, '2024-12-30', 'Bulanan', 'Membersihkan box dispenser  PK3', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(22, 8, 3, '2024-12-30', 'Bulanan', 'Membersihkan box dispenser  PK4', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(23, 8, 3, '2024-12-30', 'Bulanan', 'Membersihkan box dispenser  PK5', NULL, '', 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(24, 8, 3, '2024-12-30', 'Bulanan', 'Foto jalur tengah PM dan PK', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(25, 8, 3, '2024-12-30', 'Bulanan', 'Foto jalur utama PM dan PK', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(26, 8, 3, '2024-12-30', 'Bulanan', 'Pembersihan Ruangan Office', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(27, 18, 1, '2024-12-30', 'Bulanan', 'Membersihkan box dispenser  PM1', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(28, 18, 1, '2024-12-30', 'Bulanan', 'Membersihkan box dispenser  PM2', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(29, 18, 1, '2024-12-30', 'Bulanan', 'Membersihkan box dispenser  PM3', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(30, 18, 1, '2024-12-30', 'Bulanan', 'Membersihkan box dispenser  PM4', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(31, 18, 1, '2024-12-30', 'Bulanan', 'Membersihkan box dispenser  PM5', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(32, 18, 1, '2024-12-30', 'Bulanan', 'Membersihkan box dispenser  PM6', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(33, 18, 1, '2024-12-30', 'Bulanan', 'Membersihkan box dispenser  PK1', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(34, 18, 1, '2024-12-30', 'Bulanan', 'Membersihkan box dispenser  PK2', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(35, 18, 1, '2024-12-30', 'Bulanan', 'Membersihkan box dispenser  PK3', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(36, 18, 1, '2024-12-30', 'Bulanan', 'Membersihkan pos motor PK4', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(37, 18, 1, '2024-12-30', 'Bulanan', 'Membersihkan box dispenser  PK5', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(38, 18, 1, '2024-12-30', 'Bulanan', 'Membersihkan pos mobil PK6', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(39, 18, 1, '2024-12-30', 'Bulanan', 'Membersihkan box dispenser  PK1 belakang', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(40, 18, 1, '2024-12-30', 'Bulanan', 'Membersihkan box dispenser  PK2 belakang', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(41, 18, 1, '2024-12-30', 'Bulanan', 'Foto jalur get all  PM PK', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(42, 18, 1, '2024-12-30', 'Bulanan', 'Foto jalur get all  PM PK', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(43, 18, 1, '2024-12-30', 'Bulanan', 'Foto jalur get all  PM PK', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(44, 18, 1, '2024-12-30', 'Bulanan', 'Membersihkan office', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(45, 10, 2, '2024-12-30', 'Bulanan', 'Membersihkan box depan lobi a PM1', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(46, 10, 2, '2024-12-30', 'Bulanan', 'Membersihkan box depan lobi a PM2', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(47, 10, 2, '2024-12-30', 'Bulanan', 'Membersihkan box depan lobi a PM3', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(48, 10, 2, '2024-12-30', 'Bulanan', 'Membersihkan box depan lobi a PM4', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(49, 10, 2, '2024-12-30', 'Bulanan', 'Membersihkan box depan lobi a PK1', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(50, 10, 2, '2024-12-30', 'Bulanan', 'Membersihkan box depan lobi a PK2', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(51, 10, 2, '2024-12-30', 'Bulanan', 'Membersihkan box depan lobi a PK3', 'images/S7IhbDxbhTE5uJ5COfyrhBynpP1nMjqOhQycgV3r.jpg', 'images/g4O7f8jZbR8OecoYxwhacknzT9LqDKjMgKvVRdTN.jpg', 1, 1, '0000-00-00 00:00:00', '2025-01-14 07:40:53'),
(52, 10, 2, '2024-12-30', 'Bulanan', 'Membersihkan box depan lobi a PK4', 'images/DctSSHIbnyl3zyEPUC8dgq9nV6JmEXmoJzhxQCDS.jpg', 'images/1skRQv9u5gI9aRkYxmxiVz69AChlFPmthTS1vu0C.jpg', 1, 1, '0000-00-00 00:00:00', '2025-01-14 07:43:41'),
(53, 10, 2, '2024-12-30', 'Bulanan', 'Membersihkan pos depan lobi a', 'images/uGOfP3cG4yy3bl0RpY3jJE0Xs7pbyMUTSjlJVgqP.jpg', 'images/TWwOSFBbJipHlOdkmtZvHGl0yRLjgDXCWJakSo6Q.jpg', 1, 1, '0000-00-00 00:00:00', '2025-01-14 07:45:08'),
(54, 10, 2, '2024-12-30', 'Bulanan', 'Membersihkan pos depan masjid PK1', 'images/9dKsC3JRHi1214wQ56YJiF6SucOx8JRvVeMRpH0z.jpg', 'images/0Fp3UL4QmzAG8bYlQUYVNFk0aRwOoDySp2FFEyk7.jpg', 1, 1, '0000-00-00 00:00:00', '2025-01-14 07:47:46'),
(55, 10, 2, '2024-12-30', 'Bulanan', 'Membersihkan box depan masjid PK2', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(56, 10, 2, '2024-12-30', 'Bulanan', 'Membersihkan box depan masjid PK3', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(57, 10, 2, '2024-12-30', 'Bulanan', 'Membersihkan box samping lobi a PM1', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(58, 10, 2, '2024-12-30', 'Bulanan', 'Membersihkan box samping lobi a PM2', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(59, 10, 2, '2024-12-30', 'Bulanan', 'Membersihkan box samping lobi a PM3', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(60, 10, 2, '2024-12-30', 'Bulanan', 'Membersihkan box samping lobi a PM4', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(61, 10, 2, '2024-12-30', 'Bulanan', 'Membersihkan box samping lobi a PK1', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(62, 10, 2, '2024-12-30', 'Bulanan', 'Membersihkan box samping lobi a PK2', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(63, 10, 2, '2024-12-30', 'Bulanan', 'Membersihkan box samping lobi a PK3', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(64, 10, 2, '2024-12-30', 'Bulanan', 'Membersihkan box samping lobi a PK4', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(65, 10, 2, '2024-12-30', 'Bulanan', 'Membersihkan office', NULL, NULL, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(66, 10, 2, '2025-01-03', 'Harian', 'Perbaikan Palang PK 4', 'images/T4UkCE1qmAJH4bxNTBuWC3dXB5BKuHxJRdwgcMjf.jpg', 'images/yahNY4xDMmPqe2JcDwmwIToFR4SEbFJ9hTxspAMf.jpg', 0, NULL, '2025-01-14 06:12:44', '2025-01-20 01:48:08'),
(67, 10, 2, '2025-01-04', 'Harian', 'Perbaikan PM 1 depan Lobi A', 'images/XFnCOnrJa9tB7W57SGrTjpdFV8vru6rU58mrkjPf.jpg', 'images/BcLLpgpvl1rnQF0uM4uf9jU7yWTHAjqxpQP7hWMJ.jpg', 1, 1, '2025-01-14 06:16:00', '2025-01-14 06:24:18'),
(68, 10, 2, '2025-01-06', 'Harian', 'Perbaikan Palang PK 1samping Lobi A', 'images/TuKBVu4cpYNuEowf2rC0FQ20xizxetNDnm35lS6W.jpg', 'images/GmWW9PlP0y9eLOKCZXM8sBvuqRT5Ppy7TbXc3dQ3.jpg', 1, 1, '2025-01-14 06:19:10', '2025-01-14 06:24:52'),
(69, 10, 2, '2025-01-09', 'Mingguan', 'Pengecekan Dan Perbaikan palang serta kamera PM1', 'images/BqvNxTGoCSRH3wS9uNvmvdLGOXU6zf2aKqpMyuDL.jpg', 'images/kpI9rC00pOe9loJmLOvgdPXJLJQWNL4uH65ajARC.jpg', 1, 1, '2025-01-14 06:23:16', '2025-01-14 06:25:07');

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

--
-- Table structure for table `laporan_kegiatan1`
--

CREATE TABLE `laporan_kegiatan1` (
  `id_kegiatan` bigint UNSIGNED NOT NULL,
  `id_user` bigint UNSIGNED NOT NULL,
  `id_lokasi` bigint UNSIGNED NOT NULL,
  `tanggal_kegiatan` date NOT NULL,
  `jenis_kegiatan` enum('Harian','Mingguan','Bulanan') COLLATE utf8mb4_unicode_ci NOT NULL,
  `deskripsi` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `gambar_sebelum` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `gambar_sesudah` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_valid` tinyint(1) NOT NULL DEFAULT '0',
  `validated_by` bigint UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `laporan_kegiatan1`
--

INSERT INTO `laporan_kegiatan1` (`id_kegiatan`, `id_user`, `id_lokasi`, `tanggal_kegiatan`, `jenis_kegiatan`, `deskripsi`, `gambar_sebelum`, `gambar_sesudah`, `is_valid`, `validated_by`, `created_at`, `updated_at`) VALUES
(2, 3, 2, '2024-12-26', 'Harian', 'Totalitas Tanpa batas bersih bersih boss', 'images/5gT9j4lWAD09HvSWG1exDPGv59dpz0hRNbsSZKaf.jpg', 'images/Mted0j6DcO582sMqXWvZw43dDRZ5GYbNGPFvxl59.jpg', 1, 1, '2024-12-26 09:47:34', '2025-01-03 07:42:42'),
(3, 3, 3, '2024-12-27', 'Mingguan', 'Membersihkan semua Boomgate', NULL, NULL, 1, 1, '2024-12-26 10:20:51', '2025-01-02 07:45:20'),
(4, 9, 4, '2024-12-28', 'Bulanan', 'Kegiatan apa nih uhuy', NULL, NULL, 1, 1, '2024-12-26 11:06:36', '2025-01-02 07:53:20'),
(5, 8, 3, '2024-12-28', 'Harian', 'Tolong dibantu biar cepat selesai', NULL, NULL, 1, 1, '2024-12-28 00:55:48', '2025-01-03 08:24:41'),
(6, 3, 4, '2024-12-30', 'Mingguan', 'tolong dong kawan hehehe', NULL, NULL, 0, NULL, '2024-12-28 01:11:33', '2024-12-28 01:11:33'),
(10, 8, 3, '2025-01-03', 'Harian', 'Kegiatan tugas Skripsi', NULL, NULL, 1, 1, '2025-01-03 04:49:02', '2025-01-03 04:49:11'),
(17, 10, 2, '2025-01-04', 'Mingguan', 'bismillah coyy', 'images/xs1Sgqaekr772mFgzz5nSfAhDdgbR59Vyoqa2WBh.png', 'images/wrhlDZOTuHI7yYooRrcvG8isudOzIL0UAfL2NF0V.png', 1, 1, '2025-01-03 06:25:50', '2025-01-03 07:51:14'),
(18, 10, 2, '2025-01-04', 'Bulanan', 'Percobaan ketiga cuy', 'images/O6XUJuAeblodCUxJXxqWcbQ2JyJjVwgtB8xib0o2.jpg', 'images/dUbXCZHdzbBx0Z7wEIX1mvjtTT869qZhN6BvMpS5.jpg', 1, 1, '2025-01-03 06:44:33', '2025-01-03 07:52:54'),
(19, 10, 2, '2025-01-04', 'Harian', 'Coba Coba klub', 'images/UJsFdfRvdgYEvOBicTzbf7oYoucwouRammNcpTjK.png', 'images/yk6M980TL1FTgvKx9jQYz9bTIqExtGfmJbCcutmT.png', 0, NULL, '2025-01-03 07:44:08', '2025-01-03 07:44:08');

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

--
-- Table structure for table `lokasi`
--

CREATE TABLE `lokasi` (
  `id_lokasi` bigint UNSIGNED NOT NULL,
  `nama_lokasi` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alamat` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lokasi`
--

INSERT INTO `lokasi` (`id_lokasi`, `nama_lokasi`, `alamat`, `created_at`, `updated_at`) VALUES
(1, 'Pusat', 'Jl. Suryakencana No.1, Pamulang Bar., Kec. Pamulang, Kota Tangerang Selatan, Banten 15417', NULL, NULL),
(2, 'Viktor', 'Jl. Raya Puspitek, Buaran, Kec. Pamulang, Kota Tangerang Selatan, Banten 15310', NULL, NULL),
(3, 'Witana', 'Jl. Witana Harja No.18b, Pamulang Bar., Kec. Pamulang, Kota Tangerang Selatan, Banten 15417', NULL, NULL),
(4, 'Stikes', 'Jl. Pajajaran No.1, Pamulang Bar., Kec. Pamulang, Kota Tangerang Selatan, Banten 15417', NULL, NULL);

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(4, '0001_01_01_000000_create_users_table', 1),
(5, '0001_01_01_000001_create_cache_table', 1),
(6, '0001_01_01_000002_create_jobs_table', 1),
(7, '2024_12_22_072515_create_lokasi_table', 2),
(8, '2024_12_22_081847_create_lokasis_table', 3),
(9, '2024_12_22_083648_create_lokasis_table', 4),
(10, '2024_12_22_090259_create_lokasis_table', 5),
(11, '2024_12_22_093108_create_lokasis_table', 6),
(12, '2024_12_22_140223_create_lokasis_table', 7),
(14, '2024_12_22_143250_create_lokasis_table', 8),
(15, '2024_12_24_004446_update_users_table', 9),
(16, '2024_12_26_040527_create_setoran_table', 9),
(17, '2024_12_26_161109_create_laporan_kegiatan_table', 10),
(18, '2025_01_02_122408_add_validation_to_setorans_table', 11),
(19, '2025_01_02_132722_add_validation_to_kegiatan_table', 12),
(20, '2025_01_03_115914_add_gambar_sebelum_dan_sesudah_to_kegiatan_harian_table', 13),
(21, '2025_01_03_120303_add_gambar_sebelum_dan_sesudah_to_kegiatan_harian_table', 14);

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('MB1ekgSmHwqvskHecadD8dwQ0xRHFYxF7W4gM12K', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiOE1sWkl2elNNMjFsNjFiRXQxMGp5aWFKaUFZQWVQMDlHY3hOS3VYZSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly9teXByb2plY3QudGVzdC9hZG1pbi9zZXRvcmFuIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9', 1739146954),
('Q1LTz2UWFZjjKZKJhZAbIFpFaZI68lrhysbS7r1t', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiS0dwaHJIOFZ4UmdmSVlKd2hKTlczT01aS3dSRDhlM29ob2FQQmhJbCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6OTg6Imh0dHA6Ly9teXByb2plY3QudGVzdC9hZG1pbi9kYXNoYm9hcmQ/ZW5kX2RhdGU9MjAyNC0wNy0xOCZsb2NhdGlvbj0mc3RhcnRfZGF0ZT0yMDI0LTA3LTE1JnVzZXJfaWQ9Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9', 1737363111);

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

--
-- Table structure for table `setoran`
--

CREATE TABLE `setoran` (
  `id_setoran` bigint UNSIGNED NOT NULL,
  `id_user` bigint UNSIGNED NOT NULL,
  `id_lokasi` bigint UNSIGNED NOT NULL,
  `jenis_setoran` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shift` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pendapatan_awal` double NOT NULL,
  `pengeluaran` double NOT NULL,
  `pendapatan_akhir` double NOT NULL,
  `pendapatan_sistem` double NOT NULL,
  `selisih_setoran` double NOT NULL,
  `keterangan` text COLLATE utf8mb4_unicode_ci,
  `tanggal_transaksi` datetime NOT NULL,
  `nomor_hp` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_valid` tinyint(1) NOT NULL DEFAULT '0',
  `validated_by` bigint UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `setoran`
--

INSERT INTO `setoran` (`id_setoran`, `id_user`, `id_lokasi`, `jenis_setoran`, `shift`, `pendapatan_awal`, `pengeluaran`, `pendapatan_akhir`, `pendapatan_sistem`, `selisih_setoran`, `keterangan`, `tanggal_transaksi`, `nomor_hp`, `is_valid`, `validated_by`, `created_at`, `updated_at`) VALUES
(10, 8, 3, 'Parkir', 'Shift 1', 400000, 60000, 340000, 330000, 70000, 'Uang Harian Petugas Rp.30.000 + Security Rp.30.000', '2024-07-15 15:05:27', '81314991404', 0, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(11, 4, 2, 'Parkir', 'Shift 2', 532000, 201000, 331000, 550000, -18000, 'uang harian petugas dan security Rp.60.0000', '2024-07-15 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(12, 10, 2, 'Parkir', 'Shift 1', 1000000, 50000, 950000, 1000000, 0, 'Uang bensin ambulan', '2024-07-15 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(13, 11, 2, 'Parkir', 'Shift 1', 778000, 31000, 747000, 31000, 747000, 'Uang bensin ambulan', '2024-07-15 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(14, 12, 2, 'Parkir', 'Shift 1', 61000, 0, 61000, 61000, 0, 'Uang bensin ambulan', '2024-07-15 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(15, 4, 2, 'Parkir', 'Shift 1', 290000, 75000, 290000, 288000, 2000, 'harian security', '2024-07-16 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(16, 10, 2, 'Parkir', 'Shift 1', 608000, 50000, 608000, 558000, 50000, 'Uang harian shift 1', '2024-07-16 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(17, 8, 3, 'Parkir', 'Shift 1', 399000, 115000, 399000, 0, 0, 'Harian shift 2 = Rp 40.000', '2024-07-16 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(20, 13, 3, 'Parkir', 'Shift 1', 277000, 75000, 277000, 263000, 14000, 'Harian security', '2024-07-16 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(21, 12, 2, 'Parkir', 'Shift 1', 399000, 40000, 399000, 392000, 7000, 'Uang harian shift 1', '2024-07-16 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(22, 13, 3, 'Parkir', 'Shift 1', 35000, 0, 35000, 35000, 0, 'Uang harian shift 1', '2024-07-17 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(23, 11, 2, 'Parkir', 'Shift 1', 14000, 0, 14000, 0, 14000, 'Uang harian shift 1', '2024-07-17 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(24, 4, 2, 'Parkir', 'Shift 1', 533000, 0, 533000, 332000, 201000, 'Uang harian shift 1', '2024-07-17 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(25, 10, 2, 'Parkir', 'Shift 1', 10000, 0, 10000, 0, 10000, 'Uang harian shift 1', '2024-07-17 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '2025-01-14 01:52:51'),
(26, 8, 3, 'Parkir', 'Shift 1', 317000, 125000, 317000, 0, 0, '-Harian shift 2 = Rp 50000', '2024-07-17 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(29, 14, 2, 'Parkir', 'Shift 1', 190000, 90000, 190000, 190000, 0, 'Harian security', '2024-07-18 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '2025-01-14 01:53:08'),
(30, 11, 2, 'Parkir', 'Shift 1', 249000, 40000, 249000, 243000, 6000, 'uang harian shift', '2024-07-18 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(31, 4, 2, 'Parkir', 'Shift 1', 10000, 0, 10000, 10000, 0, 'uang harian shift', '2024-07-18 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(32, 10, 2, 'Parkir', 'Shift 1', 155000, 0, 155000, 149000, 6000, '-', '2024-07-18 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(33, 13, 3, 'Parkir', 'Shift 1', 200000, 115000, 200000, 0, 0, 'Harian shift 2 Rp 40000', '2024-07-18 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(35, 15, 4, 'Parkir', 'Shift 1', 309000, 75000, 309000, 0, 234000, 'Harian security', '2024-07-19 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(36, 11, 2, 'Parkir', 'Shift 1', 362000, 40000, 362000, 0, 322000, 'harian shift ', '2024-07-19 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(37, 16, 2, 'Parkir', 'Shift 1', 10000, 0, 10000, 0, 10000, 'harian shift ', '2024-07-19 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(38, 15, 4, 'Parkir', 'Shift 1', 206000, 90000, 206000, 0, 116000, 'uang makan anak parkir 6 orang dan security 3orang', '2024-07-19 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(39, 8, 3, 'Parkir', 'Shift 1', 591000, 115000, 591000, 0, 0, '-Harian shift 2 Rp 40000', '2024-07-19 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '2025-01-14 01:53:22'),
(41, 4, 2, 'Parkir', 'Shift 1', 207000, 0, 207000, 0, 207000, '', '2024-07-19 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(42, 10, 2, 'Parkir', 'Shift 1', 180000, 90000, 180000, 0, 90000, 'uang makan parkir 6 orang dan security 3 orang', '2024-07-19 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(43, 8, 3, 'Parkir', 'Shift 1', 19000, 0, 19000, 0, 19000, '', '2024-07-19 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(44, 8, 3, 'Parkir', 'Shift 1', 238000, 90000, 238000, 0, 148000, 'Harian security', '2024-07-20 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(45, 13, 3, 'Parkir', 'Shift 1', 202000, 30000, 202000, 0, 172000, 'Harian shift 1', '2024-07-22 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(46, 13, 3, 'Parkir', 'Shift 1', 36000, 0, 36000, 0, 36000, '', '2024-07-21 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(47, 12, 2, 'Parkir', 'Shift 1', 11000, 0, 11000, 0, 11000, '', '2024-07-22 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(48, 11, 2, 'Parkir', 'Shift 1', 11000, 0, 11000, 0, 11000, '', '2024-07-22 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(49, 15, 4, 'Parkir', 'Shift 1', 34000, 0, 34000, 0, 34000, '', '2024-07-22 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(50, 11, 2, 'Parkir', 'Shift 1', 373000, 0, 373000, 0, 373000, '', '2024-07-22 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(51, 15, 4, 'Parkir', 'Shift 1', 324000, 115000, 324000, 0, 0, '-Harian shift 2 Rp 40000', '2024-07-22 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(53, 4, 2, 'Parkir', 'Shift 1', 133000, 90000, 133000, 0, 43000, 'uang makan parkir 6 orang dan 3 orang security', '2024-07-23 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(54, 12, 2, 'Parkir', 'Shift 1', 141000, 0, 141000, 114000, 27000, '', '2024-07-23 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(55, 8, 3, 'Parkir', 'Shift 1', 173000, 90000, 173000, 173000, 0, 'uang makan parkir 6 orang dan security 3 orang', '2024-07-23 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(56, 10, 2, 'Parkir', 'Shift 1', 1305000, 210000, 1305000, 1262000, 43000, 'Harian security dan harian semua shift', '2024-07-23 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(57, 4, 2, 'Parkir', 'Shift 1', 232000, 90000, 232000, 257000, -25000, 'harian Security: Rp.90.000', '2024-07-23 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(58, 13, 3, 'Parkir', 'Shift 1', 14000, 0, 14000, 14000, 0, '', '2024-07-23 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(59, 15, 4, 'Parkir', 'Shift 1', 420000, 150000, 420000, 414000, 6000, 'Harian securty', '2024-07-23 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(60, 11, 2, 'Parkir', 'Shift 1', 185000, 50000, 185000, 164000, 21000, 'Harian shift 1', '2024-07-24 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(61, 4, 2, 'Parkir', 'Shift 1', 246000, 50000, 246000, 0, 196000, 'kebersihan Rp. 50.000', '2024-07-24 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(62, 10, 2, 'Parkir', 'Shift 1', 139000, 90000, 139000, 139000, 0, 'uang makan parkir 6 orang dan 3 orang security', '2024-07-24 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(63, 12, 2, 'Parkir', 'Shift 1', 233000, 40000, 233000, 208000, 25000, '-Harian shift 2 Rp 40000', '2024-07-24 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(64, 13, 3, 'Parkir', 'Shift 1', 118000, 60000, 118000, 120000, -2000, 'Harian security', '2024-07-24 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(65, 11, 2, 'Parkir', 'Shift 1', 407000, 90000, 407000, 388000, 19000, 'Harian shift ', '2024-07-24 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(66, 12, 2, 'Parkir', 'Shift 1', 392000, 0, 392000, 297000, 95000, '', '2024-07-24 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(67, 8, 3, 'Parkir', 'Shift 1', 137000, 90000, 137000, 0, 47000, 'uang makan parkir 6 orang dan 3 orang security', '2024-07-25 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(68, 10, 2, 'Parkir', 'Shift 1', 261000, 125000, 261000, 0, 0, '-Harian Shift 2 Rp 50000', '2024-07-27 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(70, 4, 2, 'Parkir', 'Shift 1', 280000, 0, 280000, 275000, 5000, '', '2024-07-25 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(71, 13, 3, 'Parkir', 'Shift 1', 27000, 0, 27000, 0, 27000, '', '2024-07-26 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(72, 13, 3, 'Parkir', 'Shift 1', 449000, 90000, 449000, 0, 0, 'Harian securty', '2024-07-26 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(74, 11, 2, 'Parkir', 'Shift 1', 131000, 60000, 131000, 117000, 14000, 'Harian shift 1', '2024-07-26 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(75, 13, 3, 'Parkir', 'Shift 1', 15000, 0, 15000, 0, 15000, '', '2024-07-26 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(76, 8, 3, 'Parkir', 'Shift 1', 20000, 0, 20000, 0, 20000, '', '2024-07-27 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(77, 8, 3, 'Parkir', 'Shift 1', 946000, 110000, 946000, 0, 0, 'Harian shift 2 Rp 50000', '2024-07-27 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(79, 10, 2, 'Parkir', 'Shift 1', 15000, 0, 15000, 0, 15000, '', '2024-07-31 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(80, 4, 2, 'Parkir', 'Shift 1', 14000, 0, 14000, 0, 14000, '', '2024-07-29 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(81, 11, 2, 'Parkir', 'Shift 1', 32000, 0, 32000, 0, 32000, '', '2024-07-29 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(82, 8, 3, 'Parkir', 'Shift 1', 376000, 90000, 376000, 0, 286000, 'Harian securty', '2024-07-29 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '2025-01-13 03:04:05'),
(83, 10, 2, 'Parkir', 'Shift 1', 111000, 60000, 111000, 0, 51000, 'Harian shift 1', '2024-07-29 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(84, 4, 2, 'Parkir', 'Shift 1', 384000, 115000, 384000, 0, 0, 'Harian shift 2 Rp 40000', '2024-07-30 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(86, 16, 2, 'Parkir', 'Shift 1', 42000, 0, 42000, 0, 42000, '', '2024-07-30 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(87, 11, 2, 'Parkir', 'Shift 1', 224000, 0, 224000, 0, 224000, '', '2024-07-30 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(88, 11, 2, 'Parkir', 'Shift 1', 223000, 140000, 223000, 0, 83000, 'Harian security dan harian shift 1', '2024-07-30 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(89, 4, 2, 'Parkir', 'Shift 1', 70000, 0, 70000, 0, 70000, '', '2024-07-31 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(90, 4, 2, 'Parkir', 'Shift 1', 418000, 115000, 418000, 0, 0, 'Harian shift 2 Rp 40000', '2024-07-31 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(92, 10, 2, 'Parkir', 'Shift 1', 1657000, 410000, 1657000, 0, 0, 'Harian Shift Rp 135000', '2024-07-27 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(95, 10, 2, 'Parkir', 'Shift 1', 205000, 0, 205000, 0, 205000, '', '2024-07-30 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(96, 14, 2, 'Parkir', 'Shift 1', 308000, 50000, 308000, 0, 258000, 'Harian shift 1', '2024-07-31 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(97, 11, 2, 'Parkir', 'Shift 1', 307000, 75000, 307000, 0, 232000, 'Harian securty', '2024-07-31 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(98, 8, 3, 'Parkir', 'Shift 1', 709000, 90000, 709000, 0, 619000, 'Harian securty', '2024-08-03 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '2025-01-13 03:24:13'),
(99, 8, 3, 'Parkir', 'Shift 1', 577000, 0, 577000, 628000, -51000, '', '2024-08-01 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(100, 4, 2, 'Parkir', 'Shift 1', 405000, 115000, 405000, 0, 0, '-Harian shift 2 Rp 40000', '2024-08-02 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(102, 10, 2, 'Parkir', 'Shift 1', 55000, 0, 55000, 0, 55000, '', '2024-08-02 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(103, 14, 2, 'Parkir', 'Shift 1', 32000, 0, 32000, 0, 32000, '', '2024-07-31 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(104, 11, 2, 'Parkir', 'Shift 1', 214000, 60000, 214000, 0, 154000, 'Harian shift 1', '2024-08-01 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(105, 4, 2, 'Parkir', 'Shift 1', 705000, 90000, 705000, 613000, 92000, 'harian securty', '2024-08-02 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(106, 10, 2, 'Parkir', 'Shift 1', 592000, 0, 592000, 0, 592000, '', '2024-08-02 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(107, 8, 3, 'Parkir', 'Shift 1', 525000, 125000, 525000, 0, 0, '-Harian shift 2 Rp 50000', '2024-08-02 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(109, 13, 3, 'Parkir', 'Shift 1', 238000, 50000, 238000, 0, 188000, 'Harian shift 1', '2024-08-02 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(110, 13, 3, 'Parkir', 'Shift 1', 709000, 90000, 709000, 701000, 8000, 'harian securty', '2024-08-03 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(111, 13, 3, 'Parkir', 'Shift 1', 41000, 0, 41000, 0, 41000, '', '2024-08-01 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(112, 13, 3, 'Parkir', 'Shift 1', 121000, 0, 121000, 0, 121000, '', '2024-08-02 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(113, 14, 2, 'Parkir', 'Shift 1', 11000, 0, 11000, 0, 11000, '', '2024-08-05 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(114, 11, 2, 'Parkir', 'Shift 1', 20000, 0, 20000, 0, 20000, '', '2024-08-03 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(115, 10, 2, 'Parkir', 'Shift 1', 18000, 0, 18000, 0, 18000, '', '2024-08-05 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(116, 14, 2, 'Parkir', 'Shift 1', 857000, 0, 857000, 0, 857000, '', '2024-08-01 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(117, 11, 2, 'Parkir', 'Shift 1', 630000, 125000, 630000, 0, 0, '-Harian Shift 2 Rp 50000', '2024-08-03 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(119, 17, 2, 'Parkir', 'Shift 1', 1159000, 150000, 1159000, 0, 0, 'Harian securty : Rp90.000', '2024-08-03 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(121, 8, 3, 'Parkir', 'Shift 1', 847000, 0, 847000, 0, 847000, '', '2024-08-06 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(122, 13, 3, 'Parkir', 'Shift 1', 812000, 133000, 812000, 0, 0, '-Harian Shift Rp 40000', '2024-08-06 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(125, 13, 3, 'Parkir', 'Shift 1', 710000, 60000, 710000, 689000, 21000, 'Harian security', '2024-08-06 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(126, 11, 2, 'Parkir', 'Shift 1', 74000, 0, 74000, 0, 74000, '', '2024-08-06 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(127, 11, 2, 'Parkir', 'Shift 1', 16000, 0, 16000, 0, 16000, '', '2024-08-07 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(128, 16, 2, 'Parkir', 'Shift 1', 23000, 0, 23000, 0, 23000, '', '2024-08-07 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(129, 13, 3, 'Parkir', 'Shift 1', 403000, 115000, 403000, 0, 0, '-Harian Shift 2 Rp 40000', '2024-08-07 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(131, 13, 3, 'Parkir', 'Shift 1', 403000, 115000, 403000, 0, 0, '-Harian Shift 2 Rp 40000', '2024-08-08 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(133, 4, 2, 'Parkir', 'Shift 1', 629000, 0, 629000, 0, 629000, '', '2024-08-06 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(134, 4, 2, 'Parkir', 'Shift 1', 334000, 90000, 334000, 0, 244000, 'Security', '2024-08-07 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(135, 8, 3, 'Parkir', 'Shift 1', 12000, 0, 12000, 0, 12000, '', '2024-08-08 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(136, 4, 2, 'Parkir', 'Shift 1', 66000, 0, 66000, 0, 66000, '', '2024-08-08 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(137, 4, 2, 'Parkir', 'Shift 1', 358000, 0, 358000, 0, 358000, 'Tidak ada pengeluaran ', '2024-08-06 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(139, 8, 3, 'Parkir', 'Shift 1', 47000, 0, 47000, 0, 47000, '', '2024-08-07 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(140, 10, 2, 'Parkir', 'Shift 1', 520000, 0, 520000, 0, 520000, 'Tidak ada pengeluaran ', '2024-08-08 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(141, 10, 2, 'Parkir', 'Shift 1', 351000, 60000, 351000, 0, 291000, 'Harian shift 1', '2024-08-08 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(142, 11, 2, 'Parkir', 'Shift 1', 41000, 0, 41000, 0, 41000, '', '2024-08-08 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(143, 15, 4, 'Parkir', 'Shift 1', 1311000, 420000, 1311000, 0, 0, 'Securty Rp75.000', '2024-08-09 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(147, 8, 3, 'Parkir', 'Shift 1', 1155000, 75000, 1155000, 0, 1080000, 'Securty Rp75.000', '2024-08-09 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(148, 10, 2, 'Parkir', 'Shift 1', 186000, 0, 186000, 0, 186000, '', '2024-08-11 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(149, 11, 2, 'Parkir', 'Shift 1', 193000, 90000, 193000, 0, 103000, 'uang makan parkir 6 orang dan uang makan security 3 orang', '2024-08-11 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(150, 14, 2, 'Parkir', 'Shift 1', 46000, 0, 46000, 46000, 0, '', '2024-08-11 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(151, 4, 2, 'Parkir', 'Shift 1', 737000, 150000, 737000, 0, 0, 'Harian securty Rp90.000', '2024-08-10 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(153, 11, 2, 'Parkir', 'Shift 1', 867000, 115000, 867000, 0, 0, '-Harian Shift 2 Rp 40000', '2024-08-12 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(155, 8, 3, 'Parkir', 'Shift 1', 67000, 0, 67000, 0, 67000, '', '2024-08-12 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(156, 10, 2, 'Parkir', 'Shift 1', 187000, 0, 187000, 0, 187000, 'Tidak ada pengeluaran', '2024-08-13 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(157, 14, 2, 'Parkir', 'Shift 1', 367000, 115000, 367000, 0, 0, '-Harian shift 2 Rp 40000', '2024-08-13 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(159, 11, 2, 'Parkir', 'Shift 1', 14000, 0, 14000, 0, 14000, '', '2024-08-13 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(160, 8, 3, 'Parkir', 'Shift 1', 662000, 140000, 662000, 0, 0, 'Securty Rp90.000', '2024-08-13 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(162, 13, 3, 'Parkir', 'Shift 1', 267000, 0, 267000, 0, 267000, '', '2024-08-13 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(163, 13, 3, 'Parkir', 'Shift 1', 357000, 115000, 357000, 0, 0, '-Harian Shift 2 Rp 40000', '2024-08-13 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(165, 13, 3, 'Parkir', 'Shift 1', 12000, 0, 12000, 0, 12000, '', '2024-08-08 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(166, 10, 2, 'Parkir', 'Shift 1', 14000, 0, 14000, 0, 14000, '', '2024-08-09 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(167, 11, 2, 'Parkir', 'Shift 1', 12000, 0, 12000, 0, 12000, '', '2024-08-10 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(168, 15, 4, 'Parkir', 'Shift 1', 12000, 0, 12000, 0, 12000, '', '2024-08-10 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(169, 15, 4, 'Parkir', 'Shift 1', 441000, 125000, 441000, 0, 0, 'Securty Rp75.000', '2024-08-12 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(171, 15, 4, 'Parkir', 'Shift 1', 443000, 115000, 443000, 0, 0, '-Harian Shift 2 Rp 40000', '2024-08-14 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(173, 15, 4, 'Parkir', 'Shift 1', 131000, 90000, 131000, 0, 41000, 'uang makan parkir 6 orang dan uang makan security 3 orang', '2024-08-15 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(175, 4, 2, 'Parkir', 'Shift 1', 95000, 90000, 95000, 0, 5000, 'uang makan parkir 6 orang dan uang makan security 3 orang', '2024-08-14 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(176, 16, 2, 'Parkir', 'Shift 1', 90000, 90000, 90000, 0, 0, 'uang makan parkir 6 orang dan uang makan security 3 orang', '2024-08-15 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(177, 17, 2, 'Parkir', 'Shift 1', 208000, 0, 208000, 0, 208000, 'Tidak ada pengeluaran', '2024-08-15 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(178, 4, 2, 'Parkir', 'Shift 1', 635000, 0, 635000, 0, 635000, '', '2024-08-16 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(179, 15, 4, 'Parkir', 'Shift 1', 360000, 150000, 360000, 0, 0, 'Securty Rp90.000', '2024-08-16 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(181, 11, 2, 'Parkir', 'Shift 1', 88000, 0, 88000, 75000, 13000, 'Tidak ada pengeluaran', '2024-08-16 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(182, 14, 2, 'Parkir', 'Shift 1', 103000, 90000, 103000, 0, 13000, 'uang makan parkir 6 orang dan uang makan security 3 orang', '2024-08-19 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(183, 4, 2, 'Parkir', 'Shift 1', 1041000, 215000, 1041000, 0, 0, '-Harian Shuft 2 Rp 40000', '2024-08-16 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(186, 8, 3, 'Parkir', 'Shift 1', 1032000, 0, 1032000, 854000, 178000, '', '2024-08-20 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(187, 3, 3, 'Parkir', 'Shift 1', 1186000, 200000, 1186000, 1004000, 182000, 'bensin ambulance : Rp. 200.000', '2024-08-20 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(188, 10, 2, 'Parkir', 'Shift 1', 1096000, 0, 1096000, 1070000, 26000, '', '2024-08-20 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(189, 8, 3, 'Parkir', 'Shift 1', 815000, 0, 815000, 780000, 35000, '', '2024-08-21 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(190, 10, 2, 'Parkir', 'Shift 1', 410000, 90000, 410000, 336000, 74000, 'Securty Rp90.000', '2024-08-21 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(191, 11, 2, 'Parkir', 'Shift 1', 16000, 0, 16000, 16000, 0, '', '2024-08-21 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(192, 11, 2, 'Parkir', 'Shift 1', 500000, 140000, 500000, 0, 0, 'Securty Rp90.000', '2024-08-22 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(194, 8, 3, 'Parkir', 'Shift 1', 486000, 290000, 486000, 0, 0, '-Harian Shift Rp 165000', '2024-08-22 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(197, 4, 2, 'Parkir', 'Shift 1', 362000, 135000, 362000, 0, 0, '-Harian Shift 2 Rp 60000', '2024-08-22 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(199, 15, 4, 'Parkir', 'Shift 1', 15000, 0, 15000, 15000, 0, '', '2024-08-23 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(200, 15, 4, 'Parkir', 'Shift 1', 137000, 50000, 137000, 0, 87000, 'Harian shift 1', '2024-08-23 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(201, 11, 2, 'Parkir', 'Shift 1', 122000, 90000, 122000, 0, 32000, 'uang makan anak parkir 6 orang dan uang makan security 3 orang', '2024-08-23 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(202, 11, 2, 'Parkir', 'Shift 1', 103000, 90000, 103000, 0, 13000, 'uang makan anak parkir 6 orang dan uang makan security 3 orang', '2024-08-24 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(203, 16, 2, 'Parkir', 'Shift 1', 329000, 135000, 329000, 0, 0, '-Harian Shift 2 Rp 60000', '2024-08-24 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(205, 17, 2, 'Parkir', 'Shift 1', 329000, 135000, 329000, 0, 0, '-Harian Shift 2 Rp 60000', '2024-08-24 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(207, 17, 2, 'Parkir', 'Shift 1', 449000, 0, 449000, 0, 449000, '', '2024-08-25 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(208, 13, 3, 'Parkir', 'Shift 1', 318000, 90000, 318000, 0, 228000, 'Harian scurity', '2024-08-25 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(209, 13, 3, 'Parkir', 'Shift 1', 355000, 125000, 355000, 0, 0, 'Securty Rp75. 000', '2024-08-25 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(211, 13, 3, 'Parkir', 'Shift 1', 48000, 0, 48000, 0, 48000, '', '2024-08-26 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(212, 13, 3, 'Parkir', 'Shift 1', 22000, 0, 22000, 0, 22000, '', '2024-08-26 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(213, 13, 3, 'Parkir', 'Shift 1', 0, 0, 0, 0, 0, '', '2024-08-26 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(214, 13, 3, 'Parkir', 'Shift 1', 115000, 0, 115000, 0, 115000, '', '2024-08-27 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(215, 16, 2, 'Parkir', 'Shift 1', 15000, 0, 15000, 0, 15000, '', '2024-08-27 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(216, 11, 2, 'Parkir', 'Shift 1', 9000, 0, 9000, 0, 9000, '', '2024-08-27 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(217, 10, 2, 'Parkir', 'Shift 1', 613000, 0, 613000, 0, 613000, '', '2024-08-28 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(218, 15, 4, 'Parkir', 'Shift 1', 500000, 135000, 500000, 0, 0, '-Harian Shift 2 Rp 60000', '2024-08-28 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(220, 15, 4, 'Parkir', 'Shift 1', 864000, 60000, 864000, 0, 804000, 'Harian shift 1', '2024-08-28 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(221, 15, 4, 'Parkir', 'Shift 1', 15, 0, 15, 0, 15, '', '2024-08-29 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(222, 4, 2, 'Parkir', 'Shift 1', 153000, 90000, 153000, 0, 63000, 'uang makan anak parkir 6 orang dan uang security 3 orang', '2024-08-29 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(223, 4, 2, 'Parkir', 'Shift 1', 111000, 90000, 111000, 0, 21000, 'uang makan anak parkir 6 orang dan uang security 3 orang', '2024-08-29 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(224, 15, 4, 'Parkir', 'Shift 1', 421000, 90000, 421000, 0, 331000, 'Harian security', '2024-08-30 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(225, 11, 2, 'Parkir', 'Shift 1', 186000, 60000, 186000, 0, 126000, 'Harian shift 1', '2024-08-30 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(226, 11, 2, 'Parkir', 'Shift 1', 174000, 90000, 174000, 174000, 0, 'uang makan anak parkir 6 orang dan uang makan security 3 orang', '2024-08-30 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(227, 8, 3, 'Parkir', 'Shift 1', 620000, 135000, 620000, 0, 0, '-Harian Shift 2 Rp 60000', '2024-08-30 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(229, 10, 2, 'Parkir', 'Shift 1', 424000, 160000, 424000, 0, 0, '-Harian Shift 2 Rp 70000', '2024-08-01 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(231, 10, 2, 'Parkir', 'Shift 1', 21000, 0, 21000, 0, 21000, '', '2024-08-01 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(232, 16, 2, 'Parkir', 'Shift 1', 1045000, 90000, 1045000, 1045000, 0, 'Securty 90.000', '2024-08-01 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(233, 8, 3, 'Parkir', 'Shift 1', 1022000, 150000, 1022000, 0, 0, 'Securty 90.000', '2024-08-01 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(235, 10, 2, 'Parkir', 'Shift 1', 769000, 125000, 769000, 0, 644000, '', '2024-08-02 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(236, 10, 2, 'Parkir', 'Shift 1', 22000, 0, 22000, 0, 22000, '', '2024-08-02 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(237, 10, 2, 'Parkir', 'Shift 1', 390000, 0, 390000, 0, 390000, '', '2024-08-02 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(238, 10, 2, 'Parkir', 'Shift 1', 1610000, 130000, 1610000, 0, 0, 'Securty Rp90.000', '2024-08-02 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(240, 10, 2, 'Parkir', 'Shift 1', 983000, 140000, 983000, 0, 0, 'Securty Rp90.000', '2024-08-02 15:05:27', '81314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00');

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

--
-- Table structure for table `setoran2`
--

CREATE TABLE `setoran2` (
  `id_setoran` bigint UNSIGNED NOT NULL,
  `id_user` bigint UNSIGNED NOT NULL,
  `id_lokasi` bigint UNSIGNED NOT NULL,
  `jenis_setoran` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `shift` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `pendapatan_awal` double NOT NULL,
  `pengeluaran` double NOT NULL,
  `pendapatan_akhir` double NOT NULL,
  `pendapatan_sistem` double NOT NULL,
  `selisih_setoran` double NOT NULL,
  `keterangan` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `tanggal_transaksi` datetime NOT NULL,
  `nomor_hp` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_valid` tinyint(1) NOT NULL DEFAULT '0',
  `validated_by` bigint UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `setoran2`
--

INSERT INTO `setoran2` (`id_setoran`, `id_user`, `id_lokasi`, `jenis_setoran`, `shift`, `pendapatan_awal`, `pengeluaran`, `pendapatan_akhir`, `pendapatan_sistem`, `selisih_setoran`, `keterangan`, `tanggal_transaksi`, `nomor_hp`, `is_valid`, `validated_by`, `created_at`, `updated_at`) VALUES
(4, 9, 3, 'Parkir', 'Shift 1', 300000, 100000, 200000, 330000, -30000, 'Uang Harian Petugas Rp.30.000 + Security Rp.30.000', '2024-12-26 16:09:00', '081314991404', 0, NULL, '2024-12-26 02:09:31', '2025-01-10 18:45:54'),
(6, 8, 2, 'Parkir', 'Shift 1', 532000, 201000, 331000, 550000, -18000, 'uang harian petugas dan security Rp.60.0000', '2024-12-27 01:11:00', '081457922287', 0, NULL, '2024-12-26 11:11:49', '2024-12-26 11:12:30'),
(7, 8, 3, 'Parkir', 'Shift 1', 1000000, 50000, 950000, 1000000, 0, 'Uang bensin ambulan', '2024-12-29 13:57:00', '081314778921', 1, 1, '2024-12-28 23:58:06', '2025-01-03 08:25:02'),
(9, 3, 4, 'Parkir', 'Shift 2', 778000, 31000, 747000, 31000, 747000, 'Uang bensin ambulan', '2024-12-30 14:36:00', '081314778921', 0, NULL, '2024-12-29 00:36:41', '2024-12-29 00:36:41');

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

--
-- Table structure for table `setoran3`
--

CREATE TABLE `setoran3` (
  `id_setoran` bigint UNSIGNED NOT NULL,
  `id_user` bigint UNSIGNED NOT NULL,
  `id_lokasi` bigint UNSIGNED NOT NULL,
  `jenis_setoran` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shift` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pendapatan_awal` double NOT NULL,
  `pengeluaran` double NOT NULL,
  `pendapatan_akhir` double NOT NULL,
  `pendapatan_sistem` double NOT NULL,
  `selisih_setoran` double NOT NULL,
  `keterangan` text COLLATE utf8mb4_unicode_ci,
  `tanggal_transaksi` datetime NOT NULL,
  `nomor_hp` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_valid` tinyint(1) NOT NULL DEFAULT '0',
  `validated_by` bigint UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `setoran3`
--

INSERT INTO `setoran3` (`id_setoran`, `id_user`, `id_lokasi`, `jenis_setoran`, `shift`, `pendapatan_awal`, `pengeluaran`, `pendapatan_akhir`, `pendapatan_sistem`, `selisih_setoran`, `keterangan`, `tanggal_transaksi`, `nomor_hp`, `is_valid`, `validated_by`, `created_at`, `updated_at`) VALUES
(10, 8, 3, 'Parkir', 'Shift 1', 400000, 60000, 340000, 330000, 70000, 'Uang Harian Petugas Rp.30.000 + Security Rp.30.000', '2024-07-15 00:00:00', '081314991404', 0, NULL, '2024-07-15 07:29:52', '2025-01-10 18:49:19'),
(11, 9, 3, 'Parkir', '', 532000, 201000, 331000, 550000, -18000, 'uang harian petugas dan security Rp.60.0000', '2024-07-15 00:00:00', '081314991404', 0, 0, '2024-07-15 08:17:46', '2024-07-16 04:32:06'),
(12, 10, 3, 'Parkir', 'Shift 1', 1000000, 50000, 950000, 1000000, 0, 'Uang bensin ambulan', '2024-07-15 00:00:00', '081314991404', 0, 0, '2024-07-15 08:34:53', '2025-01-10 20:29:18'),
(13, 1, 3, 'Parkir', 'Shift 1', 778000, 31000, 747000, 31000, 747000, 'Uang bensin ambulan', '2024-07-15 00:00:00', '081314991404', 0, 0, '2024-07-15 12:47:57', '2025-01-10 20:29:51'),
(14, 3, 3, 'Parkir', 'Shift 1', 61000, 0, 61000, 61000, 0, 'apa aja deh', '2024-07-15 00:00:00', '081314991404', 0, 0, '2024-07-15 12:49:24', '2025-01-10 21:17:23'),
(15, 9, 3, 'Parkir', '', 290000, 75000, 290000, 288000, 2000, 'harian security', '2024-07-16 00:00:00', '081314991404', 0, 0, '2024-07-16 07:16:39', '2024-07-16 07:59:11'),
(16, 8, 3, 'Parkir', 'Shift 1', 608000, 50000, 608000, 558000, 50000, 'Uang harian shift 1', '2024-07-16 00:00:00', '081314991404', 0, 0, '2024-07-16 07:23:50', '2025-01-10 21:16:23'),
(17, 10, 3, 'Parkir', 'Shift 1', 399000, 115000, 399000, 0, 0, 'Harian shift 2 = Rp 40.000', '2024-07-16 00:00:00', '081314991404', 0, 0, '2024-07-16 07:32:31', '2025-01-10 21:16:40'),
(20, 3, 3, 'Parkir', 'Shift 1', 277000, 75000, 277000, 263000, 14000, 'Harian security', '2024-07-16 00:00:00', '081314991404', 0, 0, '2024-07-16 12:57:00', '2025-01-10 21:16:58'),
(21, 1, 3, 'Parkir', 'Shift 1', 399000, 40000, 399000, 392000, 7000, 'Uang harian shift 1', '2024-07-16 00:00:00', '081314991404', 0, 0, '2024-07-16 13:43:44', '2025-01-10 21:17:46'),
(22, 9, 3, 'Parkir', '', 35000, 0, 35000, 35000, 0, '', '2024-07-17 00:00:00', '081314991404', 0, 0, '2024-07-17 07:16:25', '2024-07-17 08:08:12'),
(23, 8, 3, 'Parkir', 'Shift 1', 14000, 0, 14000, 0, 14000, 'apa aja deh', '2024-07-17 00:00:00', '081314991404', 0, 0, '2024-07-17 08:03:31', '2025-01-10 21:18:12'),
(24, 3, 3, 'Parkir', 'Shift 1', 533000, 0, 533000, 332000, 201000, 'apa aja deh', '2024-07-17 00:00:00', '081314991404', 0, 0, '2024-07-17 09:08:44', '2025-01-10 21:18:33'),
(25, 10, 3, 'Parkir', 'Shift 1', 10000, 0, 10000, 0, 10000, 'apa aja deh', '2024-07-17 00:00:00', '081314991404', 0, 0, '2024-07-17 12:48:27', '2025-01-10 21:19:24'),
(26, 1, 3, 'Parkir', 'Shift 1', 317000, 125000, 317000, 0, 0, '-Harian shift 2 = Rp 50000', '2024-07-17 00:00:00', '081314991404', 0, 0, '2024-07-17 14:03:40', '2025-01-10 21:19:43'),
(29, 9, 3, 'Parkir', '', 190000, 90000, 190000, 190000, 0, 'Harian security', '2024-07-18 00:00:00', '081314991404', 0, 0, '2024-07-18 08:47:59', '0000-00-00 00:00:00'),
(30, 8, 3, 'Parkir', 'Shift 1', 249000, 40000, 249000, 243000, 6000, 'uang harian shift', '2024-07-18 00:00:00', '081314991404', 0, 0, '2024-07-18 09:55:05', '2025-01-10 21:20:03'),
(31, 3, 3, 'Parkir', 'Shift 1', 10000, 0, 10000, 10000, 0, 'apa aja deh', '2024-07-18 00:00:00', '081314991404', 0, 0, '2024-07-18 12:52:30', '2025-01-10 21:20:28'),
(32, 10, 3, 'Parkir', 'Shift 1', 155000, 0, 155000, 149000, 6000, '-', '2024-07-18 00:00:00', '081314991404', 0, 0, '2024-07-18 12:54:52', '2025-01-10 21:20:51'),
(33, 1, 3, 'Parkir', 'Shift 1', 200000, 115000, 200000, 0, 0, 'Harian shift 2 Rp 40000', '2024-07-18 00:00:00', '081314991404', 0, 0, '2024-07-18 13:55:37', '2025-01-10 21:21:09'),
(35, 9, 3, 'Parkir', '', 309000, 75000, 309000, 0, 234000, 'Harian security', '2024-07-19 00:00:00', '081314991404', 0, 0, '2024-07-19 07:16:24', '0000-00-00 00:00:00'),
(36, 9, 3, 'Parkir', '', 362000, 40000, 362000, 0, 322000, 'harian shift ', '2024-07-19 00:00:00', '081314991404', 0, 0, '2024-07-19 07:19:47', '0000-00-00 00:00:00'),
(37, 9, 3, 'Parkir', '', 10000, 0, 10000, 0, 10000, '', '2024-07-19 00:00:00', '081314991404', 0, 0, '2024-07-19 08:00:05', '0000-00-00 00:00:00'),
(38, 9, 3, 'Parkir', '', 206000, 90000, 206000, 0, 116000, 'uang makan anak parkir 6 orang dan security 3orang', '2024-07-19 00:00:00', '081314991404', 0, 0, '2024-07-19 08:02:21', '0000-00-00 00:00:00'),
(39, 9, 3, 'Parkir', '', 591000, 115000, 591000, 0, 0, '-Harian shift 2 Rp 40000', '2024-07-19 00:00:00', '081314991404', 0, 0, '2024-07-19 08:03:20', '0000-00-00 00:00:00'),
(41, 9, 3, 'Parkir', '', 207000, 0, 207000, 0, 207000, '', '2024-07-19 00:00:00', '081314991404', 0, 0, '2024-07-19 12:49:13', '0000-00-00 00:00:00'),
(42, 9, 3, 'Parkir', '', 180000, 90000, 180000, 0, 90000, 'uang makan parkir 6 orang dan security 3 orang', '2024-07-19 00:00:00', '081314991404', 0, 0, '2024-07-19 12:51:38', '0000-00-00 00:00:00'),
(43, 9, 3, 'Parkir', '', 19000, 0, 19000, 0, 19000, '', '2024-07-19 00:00:00', '081314991404', 0, 0, '2024-07-19 15:27:52', '0000-00-00 00:00:00'),
(44, 9, 3, 'Parkir', '', 238000, 90000, 238000, 0, 148000, 'Harian security', '2024-07-20 00:00:00', '081314991404', 0, 0, '2024-07-20 09:39:51', '2024-07-22 07:23:31'),
(45, 9, 3, 'Parkir', '', 202000, 30000, 202000, 0, 172000, 'Harian shift 1', '2024-07-20 00:00:00', '081314991404', 0, 0, '2024-07-20 10:42:21', '2024-07-22 07:24:48'),
(46, 9, 3, 'Parkir', '', 36000, 0, 36000, 0, 36000, '', '2024-07-21 00:00:00', '081314991404', 0, 0, '2024-07-21 07:08:36', '2024-07-22 07:06:53'),
(47, 9, 3, 'Parkir', '', 11000, 0, 11000, 0, 11000, '', '2024-07-22 00:00:00', '081314991404', 0, 0, '2024-07-22 06:20:24', '2024-07-22 07:28:53'),
(48, 9, 3, 'Parkir', '', 11000, 0, 11000, 0, 11000, '', '2024-07-22 00:00:00', '081314991404', 0, 0, '2024-07-22 07:47:02', '2024-07-22 07:47:36'),
(49, 9, 3, 'Parkir', '', 34000, 0, 34000, 0, 34000, '', '2024-07-22 00:00:00', '081314991404', 0, 0, '2024-07-22 08:00:51', '2024-07-22 08:11:53'),
(50, 9, 3, 'Parkir', '', 373000, 0, 373000, 0, 373000, '', '2024-07-22 00:00:00', '081314991404', 0, 0, '2024-07-22 08:35:01', '2024-07-22 08:42:45'),
(51, 9, 3, 'Parkir', '', 324000, 115000, 324000, 0, 0, '-Harian shift 2 Rp 40000', '2024-07-22 00:00:00', '081314991404', 0, 0, '2024-07-22 10:44:28', '0000-00-00 00:00:00'),
(53, 9, 3, 'Parkir', '', 133000, 90000, 133000, 0, 43000, 'uang makan parkir 6 orang dan 3 orang security', '2024-07-23 00:00:00', '081314991404', 0, 0, '2024-07-22 17:08:46', '2024-07-23 13:58:11'),
(54, 9, 3, 'Parkir', '', 141000, 0, 141000, 114000, 27000, '', '2024-07-23 00:00:00', '081314991404', 0, 0, '2024-07-23 07:15:14', '2024-07-23 13:44:05'),
(55, 9, 3, 'Parkir', '', 173000, 90000, 173000, 173000, 0, 'uang makan parkir 6 orang dan security 3 orang', '2024-07-23 00:00:00', '081314991404', 0, 0, '2024-07-23 07:19:31', '2024-07-23 13:46:01'),
(56, 9, 3, 'Parkir', '', 1305000, 210000, 1305000, 1262000, 43000, 'Harian security dan harian semua shift', '2024-07-23 00:00:00', '081314991404', 0, 0, '2024-07-23 07:19:40', '2024-07-23 13:53:00'),
(57, 9, 3, 'Parkir', '', 232000, 90000, 232000, 257000, -25000, 'harian Security: Rp.90.000', '2024-07-23 00:00:00', '081314991404', 0, 0, '2024-07-23 12:48:35', '0000-00-00 00:00:00'),
(58, 9, 3, 'Parkir', '', 14000, 0, 14000, 14000, 0, '', '2024-07-23 00:00:00', '081314991404', 0, 0, '2024-07-23 12:53:07', '2024-07-23 13:54:05'),
(59, 9, 3, 'Parkir', '', 420000, 150000, 420000, 414000, 6000, 'Harian securty', '2024-07-23 00:00:00', '081314991404', 0, 0, '2024-07-23 12:53:43', '2024-07-23 13:54:43'),
(60, 9, 3, 'Parkir', '', 185000, 50000, 185000, 164000, 21000, 'Harian shift 1', '2024-07-24 00:00:00', '081314991404', 0, 0, '2024-07-24 00:01:36', '0000-00-00 00:00:00'),
(61, 9, 3, 'Parkir', '', 246000, 50000, 246000, 0, 196000, 'kebersihan Rp. 50.000', '2024-07-24 00:00:00', '081314991404', 0, 0, '2024-07-24 07:20:03', '2024-07-25 00:47:16'),
(62, 9, 3, 'Parkir', '', 139000, 90000, 139000, 139000, 0, 'uang makan parkir 6 orang dan 3 orang security', '2024-07-24 00:00:00', '081314991404', 0, 0, '2024-07-24 07:25:32', '2024-07-25 00:47:41'),
(63, 9, 3, 'Parkir', '', 233000, 40000, 233000, 208000, 25000, '-Harian shift 2 Rp 40000', '2024-07-24 00:00:00', '081314991404', 0, 0, '2024-07-24 10:45:37', '0000-00-00 00:00:00'),
(64, 9, 3, 'Parkir', '', 118000, 60000, 118000, 120000, -2000, 'Harian security', '2024-07-24 00:00:00', '081314991404', 0, 0, '2024-07-24 10:47:00', '0000-00-00 00:00:00'),
(65, 9, 3, 'Parkir', '', 407000, 90000, 407000, 388000, 19000, 'Harian shift ', '2024-07-24 00:00:00', '081314991404', 0, 0, '2024-07-24 13:33:46', '2024-07-25 00:46:57'),
(66, 9, 3, 'Parkir', '', 392000, 0, 392000, 297000, 95000, '', '2024-07-24 00:00:00', '081314991404', 0, 0, '2024-07-24 15:42:04', '0000-00-00 00:00:00'),
(67, 9, 3, 'Parkir', '', 137000, 90000, 137000, 0, 47000, 'uang makan parkir 6 orang dan 3 orang security', '2024-07-25 00:00:00', '081314991404', 0, 0, '2024-07-25 00:28:43', '0000-00-00 00:00:00'),
(68, 9, 3, 'Parkir', '', 261000, 125000, 261000, 0, 0, '-Harian Shift 2 Rp 50000', '2024-07-25 00:00:00', '081314991404', 0, 0, '2024-07-25 07:40:27', '0000-00-00 00:00:00'),
(70, 9, 3, 'Parkir', '', 280000, 0, 280000, 275000, 5000, '', '2024-07-25 00:00:00', '081314991404', 0, 0, '2024-07-25 10:16:58', '0000-00-00 00:00:00'),
(71, 9, 3, 'Parkir', '', 27000, 0, 27000, 0, 27000, '', '2024-07-26 00:00:00', '081314991404', 0, 0, '2024-07-25 12:40:57', '0000-00-00 00:00:00'),
(72, 9, 3, 'Parkir', '', 449000, 90000, 449000, 0, 0, 'Harian securty', '2024-07-26 00:00:00', '081314991404', 0, 0, '2024-07-26 07:48:50', '0000-00-00 00:00:00'),
(74, 9, 3, 'Parkir', '', 131000, 60000, 131000, 117000, 14000, 'Harian shift 1', '2024-07-26 00:00:00', '081314991404', 0, 0, '2024-07-26 07:51:20', '0000-00-00 00:00:00'),
(75, 9, 3, 'Parkir', '', 15000, 0, 15000, 0, 15000, '', '2024-07-26 00:00:00', '081314991404', 0, 0, '2024-07-26 12:34:24', '0000-00-00 00:00:00'),
(76, 9, 3, 'Parkir', '', 20000, 0, 20000, 0, 20000, '', '2024-07-27 00:00:00', '081314991404', 0, 0, '2024-07-26 13:38:57', '0000-00-00 00:00:00'),
(77, 9, 3, 'Parkir', '', 946000, 110000, 946000, 0, 0, 'Harian shift 2 Rp 50000', '2024-07-27 00:00:00', '081314991404', 0, 0, '2024-07-27 13:45:16', '0000-00-00 00:00:00'),
(79, 9, 3, 'Parkir', '', 15000, 0, 15000, 0, 15000, '', '2024-07-27 00:00:00', '081314991404', 0, 0, '2024-07-29 07:33:56', '0000-00-00 00:00:00'),
(80, 9, 3, 'Parkir', '', 14000, 0, 14000, 0, 14000, '', '2024-07-29 00:00:00', '081314991404', 0, 0, '2024-07-29 07:58:07', '0000-00-00 00:00:00'),
(81, 9, 3, 'Parkir', '', 32000, 0, 32000, 0, 32000, '', '2024-07-29 00:00:00', '081314991404', 0, 0, '2024-07-29 09:49:08', '0000-00-00 00:00:00'),
(82, 9, 3, 'Parkir', '', 376000, 90000, 376000, 0, 286000, 'Harian securty', '2024-07-29 00:00:00', '081314991404', 0, 0, '2024-07-29 12:47:05', '2024-07-30 07:36:49'),
(83, 9, 3, 'Parkir', '', 111000, 60000, 111000, 0, 51000, 'Harian shift 1', '2024-07-29 00:00:00', '081314991404', 0, 0, '2024-07-29 15:04:32', '2024-07-30 07:36:06'),
(84, 9, 3, 'Parkir', '', 384000, 115000, 384000, 0, 0, 'Harian shift 2 Rp 40000', '2024-07-30 00:00:00', '081314991404', 0, 0, '2024-07-29 23:45:21', '0000-00-00 00:00:00'),
(86, 9, 3, 'Parkir', '', 42000, 0, 42000, 0, 42000, '', '2024-07-30 00:00:00', '081314991404', 0, 0, '2024-07-30 07:28:07', '0000-00-00 00:00:00'),
(87, 9, 3, 'Parkir', '', 224000, 0, 224000, 0, 224000, '', '2024-07-30 00:00:00', '081314991404', 0, 0, '2024-07-30 07:32:25', '2024-07-30 07:38:33'),
(88, 9, 3, 'Parkir', '', 223000, 140000, 223000, 0, 83000, 'Harian security dan harian shift 1', '2024-07-30 00:00:00', '081314991404', 0, 0, '2024-07-30 12:47:51', '0000-00-00 00:00:00'),
(89, 9, 3, 'Parkir', '', 70000, 0, 70000, 0, 70000, '', '2024-07-31 00:00:00', '081314991404', 0, 0, '2024-07-30 13:24:46', '2024-07-31 08:04:04'),
(90, 9, 3, 'Parkir', '', 418000, 115000, 418000, 0, 0, 'Harian shift 2 Rp 40000', '2024-07-31 00:00:00', '081314991404', 0, 0, '2024-07-31 07:54:29', '0000-00-00 00:00:00'),
(92, 9, 3, 'Parkir', '', 1657000, 410000, 1657000, 0, 0, 'Harian Shift Rp 135000', '2024-07-27 00:00:00', '081314991404', 0, 0, '2024-07-31 08:58:22', '0000-00-00 00:00:00'),
(95, 9, 3, 'Parkir', '', 205000, 0, 205000, 0, 205000, '', '2024-07-30 00:00:00', '081314991404', 0, 0, '2024-07-31 09:44:00', '0000-00-00 00:00:00'),
(96, 9, 3, 'Parkir', '', 308000, 50000, 308000, 0, 258000, 'Harian shift 1', '2024-07-31 00:00:00', '081314991404', 0, 0, '2024-07-31 09:44:21', '0000-00-00 00:00:00'),
(97, 9, 3, 'Parkir', '', 307000, 75000, 307000, 0, 232000, 'Harian securty', '2024-07-31 00:00:00', '081314991404', 0, 0, '2024-07-31 13:07:28', '0000-00-00 00:00:00'),
(98, 9, 3, 'Parkir', '', 709000, 90000, 709000, 0, 619000, 'Harian securty', '2024-08-01 00:00:00', '081314991404', 0, 0, '2024-07-31 13:27:03', '0000-00-00 00:00:00'),
(99, 9, 3, 'Parkir', '', 577000, 0, 577000, 628000, -51000, '', '2024-08-01 00:00:00', '081314991404', 0, 0, '2024-08-01 08:38:18', '0000-00-00 00:00:00'),
(100, 9, 3, 'Parkir', '', 405000, 115000, 405000, 0, 0, '-Harian shift 2 Rp 40000', '2024-08-02 00:00:00', '081314991404', 0, 0, '2024-08-01 12:54:21', '0000-00-00 00:00:00'),
(102, 9, 3, 'Parkir', '', 55000, 0, 55000, 0, 55000, '', '2024-08-02 00:00:00', '081314991404', 0, 0, '2024-08-02 07:34:27', '2024-08-06 07:24:35'),
(103, 9, 3, 'Parkir', '', 32000, 0, 32000, 0, 32000, '', '2024-07-31 00:00:00', '081314991404', 0, 0, '2024-08-02 10:04:20', '0000-00-00 00:00:00'),
(104, 9, 3, 'Parkir', '', 214000, 60000, 214000, 0, 154000, 'Harian shift 1', '2024-08-01 00:00:00', '081314991404', 0, 0, '2024-08-02 10:27:26', '0000-00-00 00:00:00'),
(105, 9, 3, 'Parkir', '', 705000, 90000, 705000, 613000, 92000, 'harian securty', '2024-08-02 00:00:00', '081314991404', 0, 0, '2024-08-02 10:28:44', '0000-00-00 00:00:00'),
(106, 9, 3, 'Parkir', '', 592000, 0, 592000, 0, 592000, '', '2024-08-02 00:00:00', '081314991404', 0, 0, '2024-08-02 13:26:48', '0000-00-00 00:00:00'),
(107, 9, 3, 'Parkir', '', 525000, 125000, 525000, 0, 0, '-Harian shift 2 Rp 50000', '2024-08-02 00:00:00', '081314991404', 0, 0, '2024-08-02 13:27:20', '0000-00-00 00:00:00'),
(109, 9, 3, 'Parkir', '', 238000, 50000, 238000, 0, 188000, 'Harian shift 1', '2024-08-02 00:00:00', '081314991404', 0, 0, '2024-08-03 05:15:31', '0000-00-00 00:00:00'),
(110, 9, 3, 'Parkir', '', 709000, 90000, 709000, 701000, 8000, 'harian securty', '2024-08-03 00:00:00', '081314991404', 0, 0, '2024-08-05 06:26:28', '0000-00-00 00:00:00'),
(111, 9, 3, 'Parkir', '', 41000, 0, 41000, 0, 41000, '', '2024-08-01 00:00:00', '081314991404', 0, 0, '2024-08-05 06:26:49', '0000-00-00 00:00:00'),
(112, 9, 3, 'Parkir', '', 121000, 0, 121000, 0, 121000, '', '2024-08-02 00:00:00', '081314991404', 0, 0, '2024-08-05 07:09:09', '0000-00-00 00:00:00'),
(113, 9, 3, 'Parkir', '', 11000, 0, 11000, 0, 11000, '', '2024-08-05 00:00:00', '081314991404', 0, 0, '2024-08-05 07:10:25', '0000-00-00 00:00:00'),
(114, 9, 3, 'Parkir', '', 20000, 0, 20000, 0, 20000, '', '2024-08-03 00:00:00', '081314991404', 0, 0, '2024-08-05 07:13:07', '0000-00-00 00:00:00'),
(115, 9, 3, 'Parkir', '', 18000, 0, 18000, 0, 18000, '', '2024-08-05 00:00:00', '081314991404', 0, 0, '2024-08-05 07:14:40', '0000-00-00 00:00:00'),
(116, 9, 3, 'Parkir', '', 857000, 0, 857000, 0, 857000, '', '2024-08-01 00:00:00', '081314991404', 0, 0, '2024-08-05 07:15:29', '0000-00-00 00:00:00'),
(117, 9, 3, 'Parkir', '', 630000, 125000, 630000, 0, 0, '-Harian Shift 2 Rp 50000', '2024-08-03 00:00:00', '081314991404', 0, 0, '2024-08-05 07:16:28', '0000-00-00 00:00:00'),
(119, 9, 3, 'Parkir', '', 1159000, 150000, 1159000, 0, 0, 'Harian securty : Rp90.000', '2024-08-03 00:00:00', '081314991404', 0, 0, '2024-08-05 09:09:37', '0000-00-00 00:00:00'),
(121, 9, 3, 'Parkir', '', 847000, 0, 847000, 0, 847000, '', '2024-08-06 00:00:00', '081314991404', 0, 0, '2024-08-05 13:00:16', '0000-00-00 00:00:00'),
(122, 9, 3, 'Parkir', '', 812000, 133000, 812000, 0, 0, '-Harian Shift Rp 40000', '2024-08-06 00:00:00', '081314991404', 0, 0, '2024-08-06 07:09:14', '2024-08-06 07:21:14'),
(125, 9, 3, 'Parkir', '', 710000, 60000, 710000, 689000, 21000, 'Harian security', '2024-08-06 00:00:00', '081314991404', 0, 0, '2024-08-06 12:48:54', '0000-00-00 00:00:00'),
(126, 9, 3, 'Parkir', '', 74000, 0, 74000, 0, 74000, '', '2024-08-06 00:00:00', '081314991404', 0, 0, '2024-08-06 14:30:07', '0000-00-00 00:00:00'),
(127, 9, 3, 'Parkir', '', 16000, 0, 16000, 0, 16000, '', '2024-08-07 00:00:00', '081314991404', 0, 0, '2024-08-07 05:12:16', '0000-00-00 00:00:00'),
(128, 9, 3, 'Parkir', '', 23000, 0, 23000, 0, 23000, '', '2024-08-07 00:00:00', '081314991404', 0, 0, '2024-08-07 07:35:09', '0000-00-00 00:00:00'),
(129, 9, 3, 'Parkir', '', 403000, 115000, 403000, 0, 0, '-Harian Shift 2 Rp 40000', '2024-08-07 00:00:00', '081314991404', 0, 0, '2024-08-07 07:53:26', '0000-00-00 00:00:00'),
(131, 9, 3, 'Parkir', '', 403000, 115000, 403000, 0, 0, '-Harian Shift 2 Rp 40000', '2024-08-08 00:00:00', '081314991404', 0, 0, '2024-08-07 12:47:49', '0000-00-00 00:00:00'),
(133, 9, 3, 'Parkir', '', 629000, 0, 629000, 0, 629000, '', '2024-08-06 00:00:00', '081314991404', 0, 0, '2024-08-08 07:27:12', '0000-00-00 00:00:00'),
(134, 9, 3, 'Parkir', '', 334000, 90000, 334000, 0, 244000, 'Security', '2024-08-07 00:00:00', '081314991404', 0, 0, '2024-08-08 07:27:28', '0000-00-00 00:00:00'),
(135, 9, 3, 'Parkir', '', 12000, 0, 12000, 0, 12000, '', '2024-08-08 00:00:00', '081314991404', 0, 0, '2024-08-08 07:27:47', '0000-00-00 00:00:00'),
(136, 9, 3, 'Parkir', '', 66000, 0, 66000, 0, 66000, '', '2024-08-08 00:00:00', '081314991404', 0, 0, '2024-08-08 07:44:07', '0000-00-00 00:00:00'),
(137, 9, 3, 'Parkir', '', 358000, 0, 358000, 0, 358000, 'Tidak ada pengeluaran ', '2024-08-06 00:00:00', '081314991404', 0, 0, '2024-08-08 13:19:02', '0000-00-00 00:00:00'),
(139, 9, 3, 'Parkir', '', 47000, 0, 47000, 0, 47000, '', '2024-08-07 00:00:00', '081314991404', 0, 0, '2024-08-08 15:40:54', '0000-00-00 00:00:00'),
(140, 9, 3, 'Parkir', '', 520000, 0, 520000, 0, 520000, 'Tidak ada pengeluaran ', '2024-08-08 00:00:00', '081314991404', 0, 0, '2024-08-08 15:41:46', '0000-00-00 00:00:00'),
(141, 9, 3, 'Parkir', '', 351000, 60000, 351000, 0, 291000, 'Harian shift 1', '2024-08-08 00:00:00', '081314991404', 0, 0, '2024-08-08 15:44:23', '0000-00-00 00:00:00'),
(142, 9, 3, 'Parkir', '', 41000, 0, 41000, 0, 41000, '', '2024-08-08 00:00:00', '081314991404', 0, 0, '2024-08-08 16:57:41', '0000-00-00 00:00:00'),
(143, 9, 3, 'Parkir', '', 1311000, 420000, 1311000, 0, 0, 'Securty Rp75.000', '2024-08-09 00:00:00', '081314991404', 0, 0, '2024-08-09 06:05:15', '0000-00-00 00:00:00'),
(147, 9, 3, 'Parkir', '', 1155000, 75000, 1155000, 0, 1080000, 'Securty Rp75.000', '2024-08-09 00:00:00', '081314991404', 0, 0, '2024-08-09 12:38:37', '2024-08-12 04:11:38'),
(148, 9, 3, 'Parkir', '', 186000, 0, 186000, 0, 186000, '', '2024-08-11 00:00:00', '081314991404', 0, 0, '2024-08-09 13:46:59', '2024-08-12 04:11:15'),
(149, 9, 3, 'Parkir', '', 193000, 90000, 193000, 0, 103000, 'uang makan parkir 6 orang dan uang makan security 3 orang', '2024-08-11 00:00:00', '081314991404', 0, 0, '2024-08-12 04:05:53', '2024-08-12 04:08:59'),
(150, 9, 3, 'Parkir', '', 46000, 0, 46000, 46000, 0, '', '2024-08-11 00:00:00', '081314991404', 0, 0, '2024-08-12 04:06:28', '2024-08-12 04:08:18'),
(151, 9, 3, 'Parkir', '', 737000, 150000, 737000, 0, 0, 'Harian securty Rp90.000', '2024-08-10 00:00:00', '081314991404', 0, 0, '2024-08-12 04:07:10', '2024-08-12 04:07:56'),
(153, 9, 3, 'Parkir', '', 867000, 115000, 867000, 0, 0, '-Harian Shift 2 Rp 40000', '2024-08-12 00:00:00', '081314991404', 0, 0, '2024-08-12 07:15:33', '2024-08-12 07:16:18'),
(155, 9, 3, 'Parkir', '', 67000, 0, 67000, 0, 67000, '', '2024-08-12 00:00:00', '081314991404', 0, 0, '2024-08-13 05:02:08', '0000-00-00 00:00:00'),
(156, 9, 3, 'Parkir', '', 187000, 0, 187000, 0, 187000, 'Tidak ada pengeluaran', '2024-08-13 00:00:00', '081314991404', 0, 0, '2024-08-13 06:12:28', '0000-00-00 00:00:00'),
(157, 9, 3, 'Parkir', '', 367000, 115000, 367000, 0, 0, '-Harian shift 2 Rp 40000', '2024-08-13 00:00:00', '081314991404', 0, 0, '2024-08-13 07:09:26', '2024-08-13 07:09:56'),
(159, 9, 3, 'Parkir', '', 14000, 0, 14000, 0, 14000, '', '2024-08-13 00:00:00', '081314991404', 0, 0, '2024-08-13 10:53:50', '0000-00-00 00:00:00'),
(160, 9, 3, 'Parkir', '', 662000, 140000, 662000, 0, 0, 'Securty Rp90.000', '2024-08-13 00:00:00', '081314991404', 0, 0, '2024-08-13 12:35:36', '0000-00-00 00:00:00'),
(162, 9, 3, 'Parkir', '', 267000, 0, 267000, 0, 267000, '', '2024-08-13 00:00:00', '081314991404', 0, 0, '2024-08-13 13:52:11', '0000-00-00 00:00:00'),
(163, 9, 3, 'Parkir', '', 357000, 115000, 357000, 0, 0, '-Harian Shift 2 Rp 40000', '2024-08-13 00:00:00', '081314991404', 0, 0, '2024-08-14 01:56:46', '0000-00-00 00:00:00'),
(165, 9, 3, 'Parkir', '', 12000, 0, 12000, 0, 12000, '', '2024-08-08 00:00:00', '081314991404', 0, 0, '2024-08-14 07:20:38', '0000-00-00 00:00:00'),
(166, 9, 3, 'Parkir', '', 14000, 0, 14000, 0, 14000, '', '2024-08-09 00:00:00', '081314991404', 0, 0, '2024-08-14 07:37:16', '0000-00-00 00:00:00'),
(167, 9, 3, 'Parkir', '', 12000, 0, 12000, 0, 12000, '', '2024-08-10 00:00:00', '081314991404', 0, 0, '2024-08-14 07:37:50', '0000-00-00 00:00:00'),
(168, 9, 3, 'Parkir', '', 12000, 0, 12000, 0, 12000, '', '2024-08-10 00:00:00', '081314991404', 0, 0, '2024-08-14 07:38:31', '0000-00-00 00:00:00'),
(169, 9, 3, 'Parkir', '', 441000, 125000, 441000, 0, 0, 'Securty Rp75.000', '2024-08-12 00:00:00', '081314991404', 0, 0, '2024-08-14 07:38:52', '0000-00-00 00:00:00'),
(171, 9, 3, 'Parkir', '', 443000, 115000, 443000, 0, 0, '-Harian Shift 2 Rp 40000', '2024-08-14 00:00:00', '081314991404', 0, 0, '2024-08-14 07:40:05', '0000-00-00 00:00:00'),
(173, 9, 3, 'Parkir', '', 131000, 90000, 131000, 0, 41000, 'uang makan parkir 6 orang dan uang makan security 3 orang', '2024-08-15 00:00:00', '081314991404', 0, 0, '2024-08-14 13:50:58', '0000-00-00 00:00:00'),
(175, 9, 3, 'Parkir', '', 95000, 90000, 95000, 0, 5000, 'uang makan parkir 6 orang dan uang makan security 3 orang', '2024-08-14 00:00:00', '081314991404', 0, 0, '2024-08-15 12:32:16', '0000-00-00 00:00:00'),
(176, 9, 3, 'Parkir', '', 90000, 90000, 90000, 0, 0, 'uang makan parkir 6 orang dan uang makan security 3 orang', '2024-08-15 00:00:00', '081314991404', 0, 0, '2024-08-15 12:33:50', '0000-00-00 00:00:00'),
(177, 9, 3, 'Parkir', '', 208000, 0, 208000, 0, 208000, 'Tidak ada pengeluaran', '2024-08-15 00:00:00', '081314991404', 0, 0, '2024-08-15 12:34:34', '0000-00-00 00:00:00'),
(178, 9, 3, 'Parkir', '', 635000, 0, 635000, 0, 635000, '', '2024-08-16 00:00:00', '081314991404', 0, 0, '2024-08-16 11:23:09', '0000-00-00 00:00:00'),
(179, 9, 3, 'Parkir', '', 360000, 150000, 360000, 0, 0, 'Securty Rp90.000', '2024-08-16 00:00:00', '081314991404', 0, 0, '2024-08-16 11:25:48', '0000-00-00 00:00:00'),
(181, 9, 3, 'Parkir', '', 88000, 0, 88000, 75000, 13000, 'Tidak ada pengeluaran', '2024-08-16 00:00:00', '081314991404', 0, 0, '2024-08-16 21:26:02', '2024-08-19 08:54:50'),
(182, 9, 3, 'Parkir', '', 103000, 90000, 103000, 0, 13000, 'uang makan parkir 6 orang dan uang makan security 3 orang', '2024-08-19 00:00:00', '081314991404', 0, 0, '2024-08-16 21:27:16', '2024-08-19 08:54:15'),
(183, 9, 3, 'Parkir', '', 1041000, 215000, 1041000, 0, 0, '-Harian Shuft 2 Rp 40000', '2024-08-16 00:00:00', '081314991404', 0, 0, '2024-08-19 07:31:37', '0000-00-00 00:00:00'),
(186, 9, 3, 'Parkir', '', 1032000, 0, 1032000, 854000, 178000, '', '2024-08-20 00:00:00', '081314991404', 0, 0, '2024-08-19 13:33:57', '0000-00-00 00:00:00'),
(187, 9, 3, 'Parkir', '', 1186000, 200000, 1186000, 1004000, 182000, 'bensin ambulance : Rp. 200.000', '2024-08-20 00:00:00', '081314991404', 0, 0, '2024-08-20 07:16:25', '0000-00-00 00:00:00'),
(188, 9, 3, 'Parkir', '', 1096000, 0, 1096000, 1070000, 26000, '', '2024-08-20 00:00:00', '081314991404', 0, 0, '2024-08-20 15:42:13', '0000-00-00 00:00:00'),
(189, 9, 3, 'Parkir', '', 815000, 0, 815000, 780000, 35000, '', '2024-08-21 00:00:00', '081314991404', 0, 0, '2024-08-21 07:20:23', '0000-00-00 00:00:00'),
(190, 9, 3, 'Parkir', '', 410000, 90000, 410000, 336000, 74000, 'Securty Rp90.000', '2024-08-21 00:00:00', '081314991404', 0, 0, '2024-08-21 08:00:41', '0000-00-00 00:00:00'),
(191, 9, 3, 'Parkir', '', 16000, 0, 16000, 16000, 0, '', '2024-08-21 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(192, 9, 3, 'Parkir', '', 500000, 140000, 500000, 0, 0, 'Securty Rp90.000', '2024-08-22 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(194, 9, 3, 'Parkir', '', 486000, 290000, 486000, 0, 0, '-Harian Shift Rp 165000', '2024-08-22 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(197, 9, 3, 'Parkir', '', 362000, 135000, 362000, 0, 0, '-Harian Shift 2 Rp 60000', '2024-08-22 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(199, 9, 3, 'Parkir', '', 15000, 0, 15000, 15000, 0, '', '2024-08-23 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(200, 9, 3, 'Parkir', '', 137000, 50000, 137000, 0, 87000, 'Harian shift 1', '2024-08-23 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(201, 9, 3, 'Parkir', '', 122000, 90000, 122000, 0, 32000, 'uang makan anak parkir 6 orang dan uang makan security 3 orang', '2024-08-23 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(202, 9, 3, 'Parkir', '', 103000, 90000, 103000, 0, 13000, 'uang makan anak parkir 6 orang dan uang makan security 3 orang', '2024-08-24 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(203, 9, 3, 'Parkir', '', 329000, 135000, 329000, 0, 0, '-Harian Shift 2 Rp 60000', '2024-08-24 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(205, 9, 3, 'Parkir', '', 329000, 135000, 329000, 0, 0, '-Harian Shift 2 Rp 60000', '2024-08-24 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(207, 9, 3, 'Parkir', '', 449000, 0, 449000, 0, 449000, '', '2024-08-25 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(208, 9, 3, 'Parkir', '', 318000, 90000, 318000, 0, 228000, 'Harian scurity', '2024-08-25 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(209, 9, 3, 'Parkir', '', 355000, 125000, 355000, 0, 0, 'Securty Rp75. 000', '2024-08-25 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(211, 9, 3, 'Parkir', '', 48000, 0, 48000, 0, 48000, '', '2024-08-26 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(212, 9, 3, 'Parkir', '', 22000, 0, 22000, 0, 22000, '', '2024-08-26 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(213, 9, 3, 'Parkir', '', 0, 0, 0, 0, 0, '', '2024-08-26 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(214, 9, 3, 'Parkir', '', 115000, 0, 115000, 0, 115000, '', '2024-08-27 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(215, 9, 3, 'Parkir', '', 15000, 0, 15000, 0, 15000, '', '2024-08-27 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(216, 9, 3, 'Parkir', '', 9000, 0, 9000, 0, 9000, '', '2024-08-27 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(217, 9, 3, 'Parkir', '', 613000, 0, 613000, 0, 613000, '', '2024-08-28 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(218, 9, 3, 'Parkir', '', 500000, 135000, 500000, 0, 0, '-Harian Shift 2 Rp 60000', '2024-08-28 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(220, 9, 3, 'Parkir', '', 864000, 60000, 864000, 0, 804000, 'Harian shift 1', '2024-08-28 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(221, 9, 3, 'Parkir', '', 15, 0, 15, 0, 15, '', '2024-08-29 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(222, 9, 3, 'Parkir', '', 153000, 90000, 153000, 0, 63000, 'uang makan anak parkir 6 orang dan uang security 3 orang', '2024-08-29 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(223, 9, 3, 'Parkir', '', 111000, 90000, 111000, 0, 21000, 'uang makan anak parkir 6 orang dan uang security 3 orang', '2024-08-29 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(224, 9, 3, 'Parkir', '', 421000, 90000, 421000, 0, 331000, 'Harian security', '2024-08-30 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(225, 9, 3, 'Parkir', '', 186000, 60000, 186000, 0, 126000, 'Harian shift 1', '2024-08-30 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(226, 9, 3, 'Parkir', '', 174000, 90000, 174000, 174000, 0, 'uang makan anak parkir 6 orang dan uang makan security 3 orang', '2024-08-30 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(227, 9, 3, 'Parkir', '', 620000, 135000, 620000, 0, 0, '-Harian Shift 2 Rp 60000', '2024-08-30 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(229, 9, 3, 'Parkir', '', 424000, 160000, 424000, 0, 0, '-Harian Shift 2 Rp 70000', '2024-08-01 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(231, 9, 3, 'Parkir', '', 21000, 0, 21000, 0, 21000, '', '2024-08-01 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(232, 9, 3, 'Parkir', '', 1045000, 90000, 1045000, 1045000, 0, 'Securty 90.000', '2024-08-01 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(233, 9, 3, 'Parkir', '', 1022000, 150000, 1022000, 0, 0, 'Securty 90.000', '2024-08-01 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(235, 9, 3, 'Parkir', '', 769000, 125000, 769000, 0, 644000, '', '2024-08-02 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(236, 9, 3, 'Parkir', '', 22000, 0, 22000, 0, 22000, '', '2024-08-02 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(237, 9, 3, 'Parkir', '', 390000, 0, 390000, 0, 390000, '', '2024-08-02 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(238, 9, 3, 'Parkir', '', 1610000, 130000, 1610000, 0, 0, 'Securty Rp90.000', '2024-08-02 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(240, 9, 3, 'Parkir', '', 983000, 140000, 983000, 0, 0, 'Securty Rp90.000', '2024-08-02 00:00:00', '081314991404', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00');

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

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

--
-- Indexes for table `laporan_kegiatan`
--
ALTER TABLE `laporan_kegiatan`
  ADD PRIMARY KEY (`id_kegiatan`),
  ADD KEY `laporan_kegiatan_id_user_foreign` (`id_user`),
  ADD KEY `laporan_kegiatan_id_lokasi_foreign` (`id_lokasi`),
  ADD KEY `laporan_kegiatan_validated_by_foreign` (`validated_by`);

--
-- Indexes for table `laporan_kegiatan1`
--
ALTER TABLE `laporan_kegiatan1`
  ADD PRIMARY KEY (`id_kegiatan`),
  ADD KEY `laporan_kegiatan_id_user_foreign` (`id_user`),
  ADD KEY `laporan_kegiatan_id_lokasi_foreign` (`id_lokasi`),
  ADD KEY `laporan_kegiatan_validated_by_foreign` (`validated_by`);

--
-- Indexes for table `lokasi`
--
ALTER TABLE `lokasi`
  ADD PRIMARY KEY (`id_lokasi`);

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

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Indexes for table `setoran`
--
ALTER TABLE `setoran`
  ADD PRIMARY KEY (`id_setoran`),
  ADD KEY `setoran_id_user_foreign` (`id_user`),
  ADD KEY `setoran_id_lokasi_foreign` (`id_lokasi`),
  ADD KEY `setoran_validated_by_foreign` (`validated_by`);

--
-- Indexes for table `setoran2`
--
ALTER TABLE `setoran2`
  ADD PRIMARY KEY (`id_setoran`),
  ADD KEY `setoran_id_user_foreign` (`id_user`),
  ADD KEY `setoran_id_lokasi_foreign` (`id_lokasi`),
  ADD KEY `setoran_validated_by_foreign` (`validated_by`);

--
-- Indexes for table `setoran3`
--
ALTER TABLE `setoran3`
  ADD PRIMARY KEY (`id_setoran`),
  ADD KEY `setoran_id_user_foreign` (`id_user`),
  ADD KEY `setoran_id_lokasi_foreign` (`id_lokasi`),
  ADD KEY `setoran_validated_by_foreign` (`validated_by`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `laporan_kegiatan`
--
ALTER TABLE `laporan_kegiatan`
  MODIFY `id_kegiatan` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=70;

--
-- AUTO_INCREMENT for table `laporan_kegiatan1`
--
ALTER TABLE `laporan_kegiatan1`
  MODIFY `id_kegiatan` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `lokasi`
--
ALTER TABLE `lokasi`
  MODIFY `id_lokasi` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `setoran`
--
ALTER TABLE `setoran`
  MODIFY `id_setoran` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=257;

--
-- AUTO_INCREMENT for table `setoran2`
--
ALTER TABLE `setoran2`
  MODIFY `id_setoran` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `setoran3`
--
ALTER TABLE `setoran3`
  MODIFY `id_setoran` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=253;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `laporan_kegiatan1`
--
ALTER TABLE `laporan_kegiatan1`
  ADD CONSTRAINT `laporan_kegiatan_id_lokasi_foreign` FOREIGN KEY (`id_lokasi`) REFERENCES `lokasi` (`id_lokasi`) ON DELETE CASCADE,
  ADD CONSTRAINT `laporan_kegiatan_id_user_foreign` FOREIGN KEY (`id_user`) REFERENCES `users` (`id_user`) ON DELETE CASCADE,
  ADD CONSTRAINT `laporan_kegiatan_validated_by_foreign` FOREIGN KEY (`validated_by`) REFERENCES `users` (`id_user`) ON DELETE SET NULL;
COMMIT;

