INSERT INTO `m_barang_foto` (`iId`, `iBarangid`, `vImage`, `vAlt`, `eDefault`, `tUpdated`, `iCreatedid`, `iUpdatedid`, `tCreated`, `eDeleted`, `iSize`, `iSizecomp`, `iSizewebp`, `iSizecompwebp`, `vSize`, `vSizecomp`, `eSync`, `ePublish`) VALUES
(29139, 26367, 'TOLAK-ANGIN-MINT-KAPSUL-30-S-MEDICASTORE.jpg', 'TOLAK ANGIN MINT KAPSUL 30 S MEDICASTORE', 'Ya', '2024-07-23 03:58:10', 162, 162, '2023-12-06 13:59:20', 'Tidak', '5.0', NULL, NULL, NULL, NULL, NULL, 0, 'Ya'),
(29140, 3970, 'GLOW-ENHANZ-KAPSUL-30\'S*-MEDICASTORE.jpg', 'GLOW ENHANZ KAPSUL 30\'S* MEDICASTORE', 'Ya', '2024-07-23 03:58:10', 162, 162, '2023-12-06 13:59:53', 'Tidak', '63.7', '3.0', NULL, '20.8', 'width=\"1080\" height=\"1080\"', 'width=\"165\" height=\"165\"', 1, 'Ya'),
(29141, 3960, 'CALNIC-PLUS-SUSPENSI-100-ML-MEDICASTORE.jpg', 'CALNIC PLUS SUSPENSI 100 ML MEDICASTORE', 'Ya', '2024-07-23 03:58:10', 162, 162, '2023-12-06 14:00:46', 'Tidak', '61.0', NULL, NULL, '1.5', NULL, NULL, 1, 'Ya'),
(29142, 3790, 'NATURE\'S-PLUS-ANIMAL-PARADE-LIQUID-236-ML-MEDICASTORE.jpg', 'NATURE\'S PLUS ANIMAL PARADE LIQUID 236 ML MEDICASTORE', 'Ya', '2024-07-23 03:58:10', 162, 162, '2023-12-06 14:02:12', 'Tidak', '76.6', '2.4', NULL, '36.9', 'width=\"1080\" height=\"1080\"', 'width=\"165\" height=\"165\"', 1, 'Ya'),
(29143, 3821, 'NATURE\'S-PLUS-ANIMAL-PARADE-KIDS-IMMUNE-BOOSTER-90\'S-MEDICASTORE.jpg', 'NATURE\'S PLUS ANIMAL PARADE KIDS IMMUNE BOOSTER 90\'S MEDICASTORE', 'Ya', '2024-07-23 03:58:10', 162, 162, '2023-12-06 14:03:09', 'Tidak', '96.0', '3.1', NULL, '48.9', 'width=\"1080\" height=\"1080\"', 'width=\"165\" height=\"165\"', 1, 'Ya'),
(29144, 26304, 'VIPALBUMIN-PLUS-JUNIOR-SACHET-6-S-MEDICASTORE.jpg', 'VIPALBUMIN PLUS JUNIOR SACHET 6 S MEDICASTORE', 'Ya', '2024-07-23 03:58:10', 162, 162, '2023-12-06 14:04:00', 'Tidak', '4.0', NULL, NULL, NULL, NULL, NULL, 0, 'Ya'),
(29145, 4222, 'WELLNESS-OMEGA-3-FISH-OIL-KAPSUL-LUNAK-1000-MG-150\'S-MEDICASTORE.jpg', 'WELLNESS OMEGA-3 FISH OIL KAPSUL LUNAK 1000 MG 150\'S MEDICASTORE', 'Ya', '2024-07-23 03:58:10', 162, 162, '2023-12-06 14:04:36', 'Tidak', '111.4', '4.0', NULL, '44.9', 'width=\"1080\" height=\"1080\"', 'width=\"165\" height=\"165\"', 1, 'Ya'),
(29146, 4232, 'NATURE\'S-HEALTH-JOINT-HEALTH-MEDICASTORE.jpg', 'NATURE\'S HEALTH JOINT HEALTH MEDICASTORE', 'Ya', '2024-07-23 03:58:10', 162, 162, '2023-12-06 14:05:37', 'Tidak', '133.0', '4.1', NULL, '57.6', 'width=\"1080\" height=\"1080\"', 'width=\"165\" height=\"165\"', 1, 'Ya'),
(29147, 4237, 'NATURE\'S-PLUS-BONOWER-90\'S-MEDICASTORE.jpg', 'NATURE\'S PLUS BONOWER 90\'S MEDICASTORE', 'Ya', '2024-07-23 03:58:10', 162, 162, '2023-12-06 14:06:25', 'Tidak', '83.4', '2.9', NULL, '34.8', 'width=\"1080\" height=\"1080\"', 'width=\"165\" height=\"165\"', 1, 'Ya'),
(29148, 4061, 'INLACTA-DHA-KAPSUL-30\'S-MEDICASTORE.jpg', 'INLACTA DHA KAPSUL 30\'S MEDICASTORE', 'Ya', '2024-07-23 03:58:10', 162, 162, '2023-12-06 14:08:24', 'Tidak', '72.5', '2.8', NULL, '24.7', 'width=\"1080\" height=\"1080\"', 'width=\"165\" height=\"165\"', 1, 'Ya'),
(29149, 3921, 'WELLNESS-SKIN--HAIR---NAILS-FORMULA-TABLET-30\'S-MEDICASTORE.jpg', 'WELLNESS SKIN, HAIR & NAILS FORMULA TABLET 30\'S MEDICASTORE', 'Ya', '2024-07-23 03:58:10', 162, 162, '2023-12-06 14:10:15', 'Tidak', '134.2', '4.0', NULL, '62.4', 'width=\"1080\" height=\"1080\"', 'width=\"165\" height=\"165\"', 1, 'Ya'),
(29150, 3691, 'NUTRIMAX-B-COMPLEX-TABLET-30\'S-MEDICASTORE.jpg', 'NUTRIMAX B COMPLEX TABLET 30\'S MEDICASTORE', 'Ya', '2024-07-23 03:58:10', 162, 162, '2023-12-06 14:11:20', 'Tidak', '64.9', '2.9', NULL, '24.2', 'width=\"1080\" height=\"1080\"', 'width=\"165\" height=\"165\"', 1, 'Ya'),
(29151, 3697, 'WELLNESS-CAL-MAG-ZINC-TABLET-60\'S-MEDICASTORE.jpg', 'WELLNESS CAL/MAG/ZINC TABLET 60\'S MEDICASTORE', 'Ya', '2024-07-23 03:58:10', 162, 162, '2023-12-06 14:12:48', 'Tidak', '119.5', '4.1', NULL, '51.1', 'width=\"1080\" height=\"1080\"', 'width=\"165\" height=\"165\"', 1, 'Ya'),
(29152, 3700, 'NATURE\'S-PLUS-ESPECIALLY-YOURS-MEDICASTORE.jpg', 'NATURE\'S PLUS ESPECIALLY YOURS MEDICASTORE', 'Ya', '2024-07-23 03:58:10', 162, 162, '2023-12-06 14:13:30', 'Tidak', '86.1', '3.2', NULL, '34.7', 'width=\"1080\" height=\"1080\"', 'width=\"165\" height=\"165\"', 1, 'Ya'),
(29153, 3957, 'WELLNESS-CELERY-COMPLEX-KAPSUL-120\'S-MEDICASTORE.jpg', 'WELLNESS CELERY COMPLEX KAPSUL 120\'S MEDICASTORE', 'Ya', '2024-07-23 03:58:10', 162, 162, '2023-12-06 14:20:54', 'Tidak', '101.0', '3.4', NULL, '41.6', 'width=\"1080\" height=\"1080\"', 'width=\"165\" height=\"165\"', 1, 'Ya'),
(29154, 4299, 'NATURE\'S-PLUS-SC-FORMULA-MEDICASTORE.jpg', 'NATURE\'S PLUS SC FORMULA MEDICASTORE', 'Ya', '2024-07-23 03:58:10', 162, 162, '2023-12-06 14:23:41', 'Tidak', '97.8', '3.4', NULL, '45.5', 'width=\"1080\" height=\"1080\"', 'width=\"165\" height=\"165\"', 1, 'Ya'),
(29155, 4303, 'THERMOLYTE-PLUS-10\'s-MEDICASTORE.jpg', 'THERMOLYTE PLUS 10\'s MEDICASTORE', 'Ya', '2024-07-23 03:58:10', 162, 162, '2023-12-06 14:24:37', 'Tidak', '89.5', '3.4', NULL, '35.5', 'width=\"1080\" height=\"1080\"', 'width=\"165\" height=\"165\"', 1, 'Ya'),
(29156, 4314, 'AXAMED-KAPSUL-30\'S-MEDICASTORE.jpg', 'AXAMED KAPSUL 30\'S MEDICASTORE', 'Ya', '2024-07-23 03:58:10', 162, 162, '2023-12-06 14:25:40', 'Tidak', '91.6', '3.1', NULL, '31.3', 'width=\"1080\" height=\"1080\"', 'width=\"165\" height=\"165\"', 1, 'Ya'),
(29157, 4109, 'ACNACARE-PLUS-KAPSUL-LUNAK-30\'S-MEDICASTORE.jpg', 'ACNACARE PLUS KAPSUL LUNAK 30\'S MEDICASTORE', 'Ya', '2024-07-23 03:58:10', 162, 162, '2023-12-06 14:28:46', 'Tidak', '76.0', NULL, NULL, NULL, NULL, NULL, 1, 'Ya'),
(29158, 4110, 'WELLNESS-EXCELL-C-+-BETA-1-3-GLUCAN-TABLET-SALUT-SELAPUT-30\'S-MEDICASTORE.jpg', 'WELLNESS EXCELL C + BETA 1,3 GLUCAN TABLET SALUT SELAPUT 30\'S MEDICASTORE', 'Ya', '2024-07-23 03:58:10', 162, 162, '2023-12-06 14:29:47', 'Tidak', '122.4', '4.0', NULL, '55.4', 'width=\"1080\" height=\"1080\"', 'width=\"165\" height=\"165\"', 1, 'Ya'),
(29159, 26393, 'FRUIT-18-JUNIOR-30-S-MEDICASTORE.jpg', 'FRUIT 18 JUNIOR 30 S MEDICASTORE', 'Ya', '2024-07-23 03:58:10', 162, 162, '2023-12-06 14:52:24', 'Tidak', '87.0', NULL, NULL, NULL, NULL, NULL, 0, 'Ya'),
(29160, 26092, 'BALJITOT-BALSEM-20GR-MDICASTORE.jpg', 'BALJITOT BALSEM 20GR MDICASTORE', 'Ya', '2024-07-23 03:58:10', 162, 162, '2023-12-06 14:52:30', 'Tidak', '4.0', NULL, NULL, NULL, NULL, NULL, 0, 'Ya'),
(29161, 26089, 'EZYVEGIE-MIX-FRUIT---VEGIE-SACHET-5-S-MEDICASTORE.jpg', 'EZYVEGIE MIX FRUIT & VEGIE SACHET 5 S MEDICASTORE', 'Ya', '2024-07-23 03:58:10', 162, 162, '2023-12-06 14:58:59', 'Tidak', '5.0', NULL, NULL, NULL, NULL, NULL, 0, 'Ya'),
(29162, 26324, 'XON-CE-1000-KAPLET-100-S-MEDICASTORE.jpg', 'XON-CE 1000 KAPLET 100 S MEDICASTORE', 'Ya', '2024-07-23 03:58:10', 162, 162, '2023-12-06 14:59:52', 'Tidak', '71.0', NULL, NULL, NULL, NULL, NULL, 0, 'Ya'),
(29163, 26299, 'VIDORAN-SMART-IMUNUP-ANGGUR-25-S-MEDICASTORE.jpg', 'VIDORAN SMART IMUNUP ANGGUR 25 S MEDICASTORE', 'Ya', '2024-08-13 09:25:05', 162, 162, '2023-12-06 15:11:01', 'Tidak', '54.0', NULL, NULL, NULL, NULL, NULL, 1, 'Ya'),
(29164, 25955, 'LARUTAN-CAP-KAKI-TIGA-JAMBU-BIJI-320ML-MEDICASTORE.jpg', 'LARUTAN CAP KAKI TIGA JAMBU BIJI 320ML MEDICASTORE', 'Ya', '2024-07-23 03:58:10', 162, 162, '2023-12-06 15:12:48', 'Tidak', '5.0', NULL, NULL, NULL, NULL, NULL, 0, 'Ya'),
(29165, 26191, 'ROSAGEN-FLEX-KAPSUL-30-S-MEDICASTORE.jpg', 'ROSAGEN FLEX KAPSUL 30 S MEDICASTORE', 'Ya', '2024-07-23 03:58:10', 162, 162, '2023-12-06 16:08:56', 'Tidak', '65.0', NULL, NULL, NULL, NULL, NULL, 0, 'Ya'),
(29166, 26176, 'THERAGRAN-C-605-STRIP-5-S-MEDICASTORE.jpg', 'THERAGRAN C-605 STRIP 5 S MEDICASTORE', 'Ya', '2024-07-23 03:58:10', 162, 162, '2023-12-06 16:15:17', 'Tidak', '57.0', NULL, NULL, NULL, NULL, NULL, 0, 'Ya'),
(29167, 26086, 'VITAMIN-B-COMPLEX-INJ-10ML-MEDICASTORE.jpg', 'VITAMIN B COMPLEX INJ 10ML MEDICASTORE', 'Ya', '2024-07-23 03:58:10', 162, 162, '2023-12-06 16:26:13', 'Tidak', '88.0', NULL, NULL, NULL, NULL, NULL, 0, 'Ya'),
(29168, 26068, 'FORTI-D-1000-KAPSUL-LUNAK-28-S-MEDICASTORE.jpg', 'FORTI-D 1000 KAPSUL LUNAK 28 S MEDICASTORE', 'Ya', '2024-07-23 03:58:10', 162, 162, '2023-12-06 16:31:19', 'Tidak', '78.0', NULL, NULL, NULL, NULL, NULL, 0, 'Ya'),
(29169, 25992, 'IMUNOS-SYRUP-100-ML--MEDICASTORE.jpg', 'IMUNOS SYRUP 100 ML  MEDICASTORE', 'Ya', '2024-07-23 03:58:10', 162, 162, '2023-12-06 16:42:26', 'Tidak', '66.0', NULL, NULL, NULL, NULL, NULL, 0, 'Ya'),
(29170, 25991, 'VITAZYM-PLUS-TABLET-100-S-MEDICASTORE.jpg', 'VITAZYM PLUS TABLET 100 S MEDICASTORE', 'Ya', '2024-07-23 03:58:10', 162, 162, '2023-12-06 16:48:39', 'Tidak', '91.0', NULL, NULL, NULL, NULL, NULL, 0, 'Ya'),
(29171, 26399, 'tese2.jpg', 'tesss', 'Ya', '2024-08-13 09:25:06', 49, 49, '2023-12-22 03:43:54', 'Tidak', '35.0', NULL, NULL, NULL, NULL, NULL, 1, 'Ya'),
(29172, 3089, 'ddd.jpg', 'dd', 'Ya', '2024-08-13 09:23:04', 49, 49, '2024-01-12 03:45:38', 'Tidak', '108.0', NULL, NULL, NULL, NULL, NULL, 1, 'Ya'),
(29173, 26609, 'apiban-drops.png', '-', 'Tidak', '2024-03-25 03:40:01', 49, 49, '2024-03-07 00:54:13', 'Tidak', '190.0', NULL, NULL, NULL, NULL, NULL, 0, 'Tidak'),
(29174, 26609, 'asasa.jpg', 'asas', 'Tidak', '2024-03-25 03:40:15', 49, 49, '2024-03-25 03:08:39', 'Tidak', '89.0', NULL, NULL, NULL, NULL, NULL, 0, 'Tidak'),
(29175, 26609, 'DAKTARIN-CREAM-10-GRw-1pD.jpg', 'NU Q-TEN COM KAPLET 30 S MEDICASTORE', 'Ya', '2024-07-23 03:58:10', 49, 49, '2024-03-25 03:25:42', 'Tidak', '7.0', NULL, NULL, NULL, NULL, NULL, 0, 'Ya'),
(29176, 26609, 'DAKTARIN-CREAM-10-GR44.png', 'DAKTARIN CREAM 10 GR', 'Tidak', '2024-03-25 03:32:42', 49, 49, '2024-03-25 03:32:42', 'Tidak', '13.0', NULL, NULL, NULL, NULL, NULL, 0, 'Tidak'),
(29177, 26747, 'ter.jpg', 's', 'Ya', '2024-08-13 09:25:06', 49, 49, '2024-05-15 08:25:23', 'Tidak', '7.0', NULL, NULL, NULL, NULL, NULL, 1, 'Ya'),
(29178, 26748, 'tes.png', 'zxzzx', 'Ya', '2024-08-13 09:25:07', 49, 49, '2024-06-25 08:02:23', 'Tidak', '9.0', NULL, NULL, NULL, NULL, NULL, 1, 'Ya'),
(29179, 27167, 'Zdi6d_09-30-2024.jpeg', NULL, 'Tidak', '2024-10-16 08:35:34', 195, 195, '2024-09-30 02:52:41', 'Ya', NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Tidak'),
(29180, 27167, 'ZQyt1_09-30-2024.jpeg', NULL, 'Ya', '2024-09-30 02:56:02', 195, 195, '2024-09-30 02:56:02', 'Tidak', NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Tidak'),
(29181, 490, 'prorenal-kapletttttt.jpg', 'prorenal-kapletttttt2', 'Tidak', '2024-10-11 02:21:15', 174, 187, '2024-10-11 02:10:53', 'Ya', '23.0', NULL, NULL, NULL, NULL, NULL, 1, 'Ya'),
(29182, 490, 'prorenal-kapletttttt.jpg', 'prorenal-kapletttttt', 'Tidak', '2024-10-11 02:12:03', 174, 174, '2024-10-11 02:11:07', 'Tidak', '23.0', NULL, NULL, NULL, NULL, NULL, 1, 'Ya'),
(29183, 27167, 'test-skin1004.jpeg', 'skin1004', 'Tidak', '2024-10-16 06:37:39', 195, 195, '2024-10-16 06:37:39', 'Tidak', '21.0', NULL, NULL, NULL, NULL, NULL, 0, 'Ya'),
(29184, 27167, 'skin1004.jpeg', 'skin1004', 'Tidak', '2024-10-16 08:35:51', 195, 195, '2024-10-16 08:35:51', 'Tidak', '21.0', NULL, NULL, NULL, NULL, NULL, 0, 'Ya'),
(29185, 24734, 'Mederma-Advanced-Gel-10-gr.jpg', 'Mederma Advanced Gel 10 gr', 'Ya', '2024-11-07 06:32:02', 195, 195, '2024-11-07 06:30:05', 'Tidak', '21.0', NULL, NULL, NULL, NULL, NULL, 1, 'Ya'),
(29186, 24734, 'test_foto_dulu-_MD.png', 'mederma', 'Tidak', '2025-01-13 02:06:32', 97, 97, '2025-01-10 08:43:06', 'Tidak', '3.0', NULL, NULL, NULL, NULL, NULL, 1, 'Ya'),
(29188, 27476, 'foto-produk-1.png', 'Mederma Advanced Gel 10 gr', 'Tidak', '2025-04-11 10:22:09', 195, 201, '2025-01-31 08:26:30', 'Tidak', '14.0', NULL, NULL, NULL, NULL, NULL, 0, 'Tidak'),
(29189, 27476, 'vitaminb150mg.jpeg', 'VITAMIN B1 50MG (IFI)', 'Ya', '2025-04-11 10:22:09', 201, 201, '2025-04-11 10:22:09', 'Tidak', '18.0', NULL, NULL, NULL, NULL, NULL, 0, 'Ya');

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

--
-- Table structure for table `m_cluster`
--

CREATE TABLE `m_cluster` (
  `iId` int(11) NOT NULL,
  `idCluster` char(50) DEFAULT NULL,
  `vNama` varchar(100) NOT NULL,
  `vIPL` int(100) DEFAULT NULL,
  `noSK` varchar(100) NOT NULL,
  `vLogo` varchar(100) NOT NULL,
  `vImage` varchar(100) DEFAULT NULL,
  `vTelp` varchar(50) DEFAULT NULL,
  `vEmail` varchar(100) NOT NULL,
  `vAlamat` text NOT NULL,
  `vLokasi` varchar(500) DEFAULT NULL,
  `vMisiVisi` text NOT NULL,
  `vKota` varchar(50) NOT NULL,
  `vProvinsi` varchar(50) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `eDeleted` enum('Ya','Tidak') DEFAULT 'Tidak',
  `iCreatedid` int(11) DEFAULT NULL,
  `tCreated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `iUpdatedid` int(11) DEFAULT NULL,
  `tUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `prefix` varchar(20) DEFAULT 'INV',
  `panjang_nomor` int(11) DEFAULT '4',
  `reset_tipe` varchar(20) DEFAULT NULL,
  `nomor_terakhir` int(11) DEFAULT '0',
  `auto_print` enum('Ya','Tidak') DEFAULT 'Tidak',
  `format_id` int(11) DEFAULT NULL,
  `print_id` int(11) DEFAULT NULL,
  `pdf_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `m_cluster`
--

INSERT INTO `m_cluster` (`iId`, `idCluster`, `vNama`, `vIPL`, `noSK`, `vLogo`, `vImage`, `vTelp`, `vEmail`, `vAlamat`, `vLokasi`, `vMisiVisi`, `vKota`, `vProvinsi`, `slug`, `eDeleted`, `iCreatedid`, `tCreated`, `iUpdatedid`, `tUpdated`, `prefix`, `panjang_nomor`, `reset_tipe`, `nomor_terakhir`, `auto_print`, `format_id`, `print_id`, `pdf_id`) VALUES
(16, 'IPL-SC2', 'TOKO ICAM OPAN', 150000, 'Bank Cimb Niaga Syariah A.N Harbin No. Rek 761696304900', 'SC2_logo.png', NULL, NULL, 'anak.sarerea@gmail.com', 'RT.03/RW.10, KEL.RAGAJAYA & KEL. SASAK PANJANG, KEC.BOJONG GEDE,KABUPATEN BOGOR JAWA BARAT 16920 ', 'https://www.google.com/maps/place/Samasta+Citayam+2/@-6.4491013,106.774153,15z/data=!4m5!3m4!1s0x0:0x887d7d1ccf94d866!8m2!3d-6.4491013!4d106.774153', '96', 'BOGOR', 'JAWA BARAT', 'citayam-2-ydgh', 'Tidak', NULL, '2026-02-16 17:57:42', NULL, '2021-10-08 11:34:07', 'INV', 4, 'bulanan', 9, 'Tidak', 1, 0, NULL),
(17, 'IPL-opp', 'Opan Icam Cluster', 100000, '', '', NULL, NULL, 'husnul.asrpiana@gmail.com', 'ciomas', NULL, '', 'BOGOR', 'JAWA BARAT', 'hofan-pdu1', 'Tidak', NULL, '2021-12-10 10:26:51', NULL, '2021-10-16 11:39:46', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(18, 'IPL-TES', 'Nama Perumahan', 50000, '', '', NULL, NULL, 'anak.sarerea@gmail.com', 'Nama Jalan, RT/RW, Kelurahan - Provinsi', NULL, '', 'TEXT', 'TEXT', 'text-han4', 'Tidak', NULL, '2022-09-07 09:52:58', NULL, '2021-12-21 06:08:30', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(27, 'IPL-RQGJZY', 'cikeas gardenia', 60000, '', '', NULL, NULL, 'athafarizradeyafadhil18@gmail.com', 'cikeas ', NULL, '', 'BOGOR', 'JAWABARAT', 'cikeas-gardenia-ckhn', 'Tidak', NULL, '2022-01-21 01:35:36', NULL, '2022-01-20 05:49:52', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(32, 'IPL-INARJL', 'Pondok Payung Mas', 100000, '', '', NULL, NULL, 'bendaharappm12@gmail.com', 'Pondok Payung Mas Jl. Rajawali No.1', NULL, '', 'TANGERANG SELATAN', 'BANTEN', 'pondok-payung-mas-d2m5', 'Tidak', NULL, '2022-01-25 00:02:11', NULL, '2022-01-24 12:38:23', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(35, 'IPL-FRZGEZ', 'Cluster APH 2010', NULL, '', '', NULL, NULL, 'yayupuspitasari10@gmail.com', 'Jl. A. Yani, Karangjambu, Purwokerto', NULL, '', 'BANYUMAS', 'JAWA TENGAH', 'cluster-aph-2010-vlu9', 'Tidak', NULL, '2022-02-06 12:33:38', NULL, '2022-02-06 05:36:15', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(37, 'IPL-BMNKLM', 'BUANA SUBANG KENCANA / 16 / 48', NULL, '', '', NULL, NULL, 'm.januaridwan@gmail.com', 'Jl. Kapten Hanafiah', NULL, '', 'SUBANG', 'JAWA BARAT', 'buana-subang-kencana-16-48-qsz', 'Tidak', NULL, '2022-02-14 02:12:25', NULL, '2022-02-13 12:33:00', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(38, 'IPL-GZVXFV', 'Greenland Healthful Living ', 150000, '', '', NULL, NULL, 'zaebuso@gmail.com', 'Jl. Mawar\nKel. Curug\nKec. Bojongsari \nKota Depok\nPropinsi Jawa Barat', NULL, '', 'DEPOK', 'JAWA BARAT', 'greenland-healthful-living-gout', 'Tidak', NULL, '2022-06-13 23:26:47', NULL, '2022-02-16 00:35:26', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(39, 'IPL-KNXTYD', 'afnan ragency A.56', NULL, '', '', NULL, NULL, 'Arjunastore.online@gmail.com', 'afnan regency blok A.no .56', NULL, '', 'SUKABUMI', 'JAWA BARAT', 'afnan-ragency-a56-zjvr', 'Tidak', NULL, '2022-03-13 07:01:38', NULL, '2022-03-13 05:29:20', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(41, 'IPL-DGMJEC', 'otista 2 Rw09 Rt.004 ', NULL, '', '', NULL, NULL, 'zulkiflirina14@gmail.com ', 'Otista 2', NULL, '', 'JAKARTA TIMUR', 'DKI JAKARTA ', 'otista-2-rw09-rt004-lxqh', 'Tidak', NULL, '2022-03-27 15:04:33', NULL, '2022-03-14 17:07:44', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(42, 'IPL-DNSKLJ', 'CISANDAUT ', 25000, '', '', NULL, NULL, 'Depimutakin471@gmail.com', 'JL. RAYA Terminal SINDANGKERTA\nRT 005 RW 003 DESA CINTAKAYA KEC SINDANGKERTA', NULL, '', 'BANDUNG BARAT', 'JAWABARAT', 'cisandaut-ou3h', 'Tidak', NULL, '2022-03-28 03:39:27', NULL, '2022-03-27 07:00:12', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(43, 'IPL-CAZZVZ', 'Darmawangsa', NULL, '', '', NULL, NULL, 'kuninganhakim@gmail.com', 'Desa satria mekar, Tambun utara', NULL, '', 'BEKASI', 'JAWA BARAT', 'darmawangsa-e3ah', 'Tidak', NULL, '2022-04-07 01:11:21', NULL, '2022-04-06 15:57:58', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(44, 'IPL-JOVKKZ', 'PURI HARMONI 2 RT 003 RW 007', NULL, '', '', NULL, NULL, 'mas3yono@gmail.com', 'PURI HARMONI 2', NULL, '', 'TANGERANG', 'BANTEN', 'puri-harmoni-2-rt-003-rw-007-g8le', 'Tidak', NULL, '2022-04-28 02:08:40', NULL, '2022-04-27 15:36:28', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(45, 'IPL-BYOMOL', 'Darthaybah', 250000, '', '', NULL, NULL, 'elghifaary@gmail.com', 'Desa Karya Indah KM 9 Tapung', NULL, '', 'KAMPAR', 'RIAU', 'darthaybah-3k1e', 'Tidak', NULL, '2022-05-11 01:40:46', NULL, '2022-05-10 11:11:27', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(46, 'IPL-YLUXGH', 'Cipadung', 140000, '', '', NULL, NULL, 'hot.ehr@gmail.com', 'Cipadung-Cibiru ', NULL, '', 'BANDUNG', 'JAWA BARAT', 'cipadung-0niw', 'Tidak', NULL, '2022-05-27 07:11:44', NULL, '2022-05-26 15:43:18', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(47, 'IPL-MICSIE', 'Rempong', NULL, '', '', NULL, NULL, 'vitanovi151178@gmail.com ', 'Kab Cilacap', NULL, '', 'CILACAP', 'JAWA TENGAH ', 'rempong-b4b7', 'Ya', NULL, '2022-05-30 15:13:10', NULL, '2022-05-30 15:13:10', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(48, 'IPL-VLCRYP', 'Rempong PM', NULL, '', '', NULL, NULL, 'vitanovi27@yahoo.co.id', 'Kab Cilacap', NULL, '', 'CILACAP ', 'JAWA TENGAH ', 'rempong-pm-mmc', 'Tidak', NULL, '2022-05-31 01:38:00', NULL, '2022-05-30 15:16:34', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(49, 'IPL-ANLOLS', 'mutiara landbouw village', NULL, '', '', NULL, NULL, 'harmonisejahtera138@yahoo.com', 'jalan lintas perdagangan siantar\n\n', NULL, '', 'PERDAGANGAN', 'SUMUT', 'mutiara-landbouw-village-uym6', 'Tidak', NULL, '2022-06-15 02:49:49', NULL, '2022-06-15 02:19:52', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(50, 'IPL-EJVMNM', 'arrosyad residence', NULL, '', '', NULL, NULL, 'agus.listiyo@ymail.com', 'jl guru elat, pemagarsari, parung, bogor', NULL, '', 'BOGOR', 'JAWA BARAT', 'arrosyad-residence-a6c6', 'Tidak', NULL, '2022-06-20 01:16:16', NULL, '2022-06-19 04:03:38', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(51, 'IPL-QRRWFZ', 'arisansmea1bjm', NULL, '', '', NULL, NULL, 'arisansmea1bjm@gmail.com ', 'Banjarmasin ', NULL, '', 'BANJARMASIN ', 'KALIMANTAN SELATAN ', 'arisansmea1bjm-7ckt', 'Tidak', NULL, '2022-08-25 14:57:57', NULL, '2022-07-08 07:20:16', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(52, 'IPL-AIZXAM', 'Orchard Village', NULL, '', '', NULL, NULL, 'syo_83@yahoo.com', 'Jl. Pertamina', NULL, '', 'BEKASI', 'JAWA BARAT', 'orchard-village-diy', 'Tidak', NULL, '2022-08-08 01:50:59', NULL, '2022-08-05 14:07:04', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(53, 'IPL-EUEPCN', 'GRAND SURYA ASRI', NULL, '', '', NULL, NULL, 'abiiamii04@gmail.com ', 'Perum Grand Surya Asri', NULL, '', 'KEDIRI', 'JAWA TIMUR', 'grand-surya-asri-a4ai', 'Tidak', NULL, '2022-08-25 14:57:40', NULL, '2022-08-11 17:36:21', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(54, 'IPL-DHZANA', 'ciledug indah 1 Rt.006', 65, '', '', NULL, NULL, 'rhardiantama@gmail.com', 'ciledug indah 1', NULL, '', 'KOTA TANGERANG', 'BANTEN', 'ciledug-indah-1-rt006-qdzw', 'Tidak', NULL, '2023-03-29 09:14:40', NULL, '2022-08-18 03:17:07', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(55, 'IPL-VEOSGR', 'oke', NULL, '', '', NULL, NULL, 'anak.sarerea@gmail.com', 'tes', NULL, '', 'BOGOR', 'JABAW', 'oke-dzjg', 'Ya', NULL, '2022-09-04 15:15:08', NULL, '2022-08-23 02:23:37', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(56, 'IPL-DYQKUK', 'Basen/04/15', NULL, '', '', NULL, NULL, 'wawanprod@gmail.com', 'kampung basen', NULL, '', 'YOGYAKARTA', 'DIY', 'basen0415-7y6', 'Tidak', 0, '2022-08-24 01:22:37', NULL, '2022-08-24 01:22:37', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(58, 'IPL-TXULWZ', 'ajag ijig residence', 300000, '', '', NULL, NULL, 'sujiwom@gmail.com', 'jl.penjernihan 2 no 2', NULL, '', 'TANAH ABANG ', 'DKI JAKARTA', 'ajag-ijig-residence-64r', 'Tidak', NULL, '2022-08-25 15:11:07', NULL, '2022-08-25 13:31:03', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(59, 'IPL-BHIQIL', 'PERUM BUMI CARUBAN ASRI', 125, '', '', NULL, NULL, 'ucoks.angelish@gmail.com', 'PERUM BUMI CARUBAN ASRI NO.11', NULL, '', 'KENDAL', 'JAWA TENGAH', 'perum-bumi-caruban-asri-prc', 'Tidak', NULL, '2022-08-30 03:38:41', NULL, '2022-08-30 02:20:51', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(60, 'IPL-DQDZYG', 'RAWALELE RT 007 RW 010', 25000, '', '', NULL, NULL, 'rawalelert007@gmail.com', 'rawalele RT 07 RW 10 kalideres Jakarta barat DKI Jakarta 11840', NULL, '', 'JAKARTA BARAT ', 'DKI JAKARTA ', 'rawalele-rt-007-rw-010-hnf', 'Tidak', NULL, '2022-08-31 17:18:40', NULL, '2022-08-31 15:08:20', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(61, 'IPL-YQLHDL', 'Savana Alam Serpong 2 ', 0, '', '', NULL, NULL, 'irulmutta@gmail.com', 'jl Cibunar Perumahan Savana Alam Serpong 2 Parung Panjang Kab Bogor Jawa Barat ', NULL, '', 'KAB BOGOR ', 'JAWA BARAT ', 'savana-alam-serpong-2-pnck', 'Tidak', NULL, '2022-09-07 19:12:47', NULL, '2022-09-07 09:37:55', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(62, 'IPL-YDYVPF', 'permata puri harmoni', NULL, '', '', NULL, NULL, 'wibialazfar83@gmail.com', 'Permata Puri Harmoni\nJl Durian Blok B4/2 RT005/015\nDesa Situsari Kecamatan Cileungsi', NULL, '', 'KABUPATEN BOGOR', 'JAWA BARAT', 'permata-puri-harmoni-qewt', 'Tidak', NULL, '2022-09-10 23:26:52', NULL, '2022-09-10 13:41:19', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(63, 'IPL-HKYSGV', 'Grand Oriental 2', NULL, '', '', NULL, NULL, 'grandorientalrt05@gmail.com', 'Perum Grand Oriental grogol tulangan', NULL, '', 'SIDOARJO', 'JAWA TIMUR', 'grand-oriental-2-i35w', 'Tidak', NULL, '2022-09-10 23:27:05', NULL, '2022-09-10 17:48:08', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(64, 'IPL-BQMNQO', 'Perumahan Permata Puri Harmoni', NULL, '', '', NULL, NULL, 'ardiyatsen@gmail.com', 'Perumahan Permata Puri Harmoni Blok B', NULL, '', 'BOGOR', 'JAWA BARAT', 'perumahan-permata-puri-harmoni-fkjm', 'Tidak', NULL, '2022-09-11 11:53:01', NULL, '2022-09-11 03:27:24', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(65, 'IPL-JKAEFL', 'griya bukit jaya 2', 90000, '', '', NULL, NULL, 'wibowo.piss@gmail.com', 'griya bukit jaya 2 blok ba2', NULL, '', 'KOTA BOGOR', 'JAWA BARAT', 'griya-bukit-jaya-2-0gv5', 'Tidak', NULL, '2022-09-11 12:51:50', NULL, '2022-09-11 08:22:07', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(66, 'IPL-QKEYYY', 'GIA 3 ', 50000, '', '', NULL, NULL, 'agungwahyuwinadi@gmail.com', 'Perumahan Griya Idaman Asri 3 Blok.E-21 , Pesantren,  Tembelang Jombang ', NULL, '', 'JOMBANG ', 'JAWA TIMUR ', 'pagia-3-4yz', 'Tidak', NULL, '2022-09-21 00:21:00', NULL, '2022-09-15 17:59:47', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(67, 'IPL-AKDMFF', 'Cisanggiri 2C', NULL, '', '', NULL, NULL, 'setiarro19@gmail.com', 'Cisanggiri 2C Nob7', NULL, '', 'KAB. BEKASI', 'JAWA BARAT', 'cisanggiri-2c-5mr4', 'Tidak', NULL, '2022-09-17 17:32:13', NULL, '2022-09-17 15:23:43', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(68, 'IPL-XHMCHS', 'Graha Asri RT 005 RW 009', NULL, '', '', NULL, NULL, 'setiarto19@gmail.com', 'Jln. cisanggiri 2C blok S No 7', NULL, '', 'BEKASI', 'JAWA BARAT', 'graha-asri-rt-005-rw-009-47t', 'Tidak', NULL, '2022-09-17 17:32:26', NULL, '2022-09-17 15:35:42', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(69, 'IPL-YTEKYS', 'Cimahpar Stoneyard Bogor 04/04', 25000, '', '', NULL, NULL, 'maliqherjuno@gmail.com', 'Cimahpar Stoneyard Jl Guru Kuchtar', NULL, '', 'BOGOR', 'JAWA BARAT', 'cimahpar-stoneyard-bogor-0404-kltf', 'Tidak', NULL, '2022-09-18 14:21:14', NULL, '2022-09-18 05:27:59', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(70, 'IPL-FAPXWT', 'vila dago tol RT.03/21', 90000, '', '', NULL, NULL, 'sachrul28@gmail.com', 'perumahan vila dago tol blok i RT.03/21', NULL, '', 'TANGERANG SELATAN', 'BANTEN', 'vila-dago-tol-rt0321-0euf', 'Tidak', NULL, '2022-09-19 02:02:38', NULL, '2022-09-19 00:13:08', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(71, 'IPL-TMETGR', 'Ciawi Online Community', NULL, '', '', NULL, NULL, 'anwarfauzi20net@gmail.com', 'Wilayah Ciawi dan sekitarnya', NULL, '', 'KAB. TASIKMALAYA', 'JAWA BARAT', 'ciawi-online-community-4bnm', 'Tidak', NULL, '2022-09-21 01:27:05', NULL, '2022-09-19 17:29:21', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(72, 'IPL-IQQCNC', 'Graha Selaras ', NULL, '', '', NULL, NULL, 'mrapeimrapei@gmail.com', 'Jln M Sanun', NULL, '', 'BOGOR ', 'JAWA BARAT', 'graha-selaras-rbar', 'Tidak', NULL, '2022-09-21 01:27:13', NULL, '2022-09-20 03:54:28', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(73, 'IPL-HSTNZO', 'Perum Griya Idaman Asri 3  Pesantren,Tembelang, Jombang ', 50000, '', '', NULL, NULL, 'omnedisaja@gmail.com', 'Perumahan Griya Idaman Asri 3, Pesantren, Tembelang , Jombang ', NULL, '', 'JOMBANG ', 'JAWA TIMUR ', 'perum-griya-idaman-asri-3-tembelang-jombang-nikq', 'Tidak', NULL, '2022-09-21 09:33:11', NULL, '2022-09-20 16:32:52', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(74, 'IPL-HGSJDT', 'bekasi timur regency 3', 0, '', '', NULL, NULL, 'mya28031975@gmail.com', 'Chrysocolla c5/18', NULL, '', 'BEKASI KOTA', 'JAWA BARAT', 'bekasi-timur-regency-3-3r4c', 'Tidak', NULL, '2022-09-22 14:06:50', NULL, '2022-09-22 01:14:57', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(75, 'IPL-LNLEUV', 'Green Bintaro Indah', NULL, '', '', NULL, NULL, 'Greenbintaroindah.2022@gmail.com', 'Jl.Pesantren Kel.Jurang Mangu Timur Kec.Pondok Aren', NULL, '', 'TANGERANG SELATAN', 'BANTEN', 'green-bintaro-indah-rcia', 'Tidak', NULL, '2022-09-25 08:26:21', NULL, '2022-09-25 07:32:28', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(76, 'IPL-JEHJES', 'GMC D1', NULL, '', '', NULL, NULL, 'tridisa@yahoo.com', 'gmc', NULL, '', 'TANGERANG', 'BANTEN', 'gmc-d1-aayq', 'Tidak', NULL, '2022-09-30 16:02:28', NULL, '2022-09-30 14:17:28', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(77, 'IPL-PGZJKP', 'Kalipinanh', NULL, '', '', NULL, NULL, 'indobis21@gmail.com', 'jl.Kresna Non50', NULL, '', 'DUKUHWARU', 'JAWA TENGAH', 'kalipinanh-4b8o', 'Tidak', NULL, '2022-10-03 15:36:33', NULL, '2022-10-03 03:18:18', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(78, 'IPL-MFIIJC', 'Palm Asri 1', NULL, '', '', NULL, NULL, 'indobis21com', 'Jl Sadewa 21', NULL, '', 'TEGAL', 'JAWA TENGAH', 'palm-asri-1-arpo', 'Ya', NULL, '2022-10-03 03:20:31', NULL, '2022-10-03 03:20:31', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(79, 'IPL-USHLLJ', 'Palm Asri 1', NULL, '', '', NULL, NULL, 'indobis22@gmail.com', 'Jl Sadewa 21', NULL, '', 'TEGAL', 'JAWA TENGAH', 'palm-asri-1-hiez', 'Tidak', NULL, '2022-10-03 15:35:19', NULL, '2022-10-03 03:20:50', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(80, 'IPL-BRGFWC', 'ASMOL', NULL, '', '', NULL, NULL, 'bambangsutrisno846@gmail.com', 'jl bsd', NULL, '', 'TANGERANG', 'TANGERANG', 'asmol-p0qp', 'Tidak', NULL, '2022-10-06 07:20:02', NULL, '2022-10-06 06:55:08', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(81, 'IPL-MSJAJI', 'PB DELIMA RT 02 RW 05', NULL, '', '', NULL, NULL, 'griya.islam19@gmail.com', 'Sindangkarsa Cimanggis Depok Jawa barat', NULL, '', 'DEPOK', 'JAWA BARAT', 'pb-delima-rt-02-rw-05-sxnq', 'Tidak', NULL, '2022-10-08 14:40:12', NULL, '2022-10-08 12:39:18', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(82, 'IPL-IXLSCZ', 'bukit permata cimahi /22/09', NULL, '', '', NULL, NULL, 'kopegbtnbandung2@gmail.com', 'komp  bukit permata cimahi blok g8 no 25rt 09 rw22 cilame ngamprah kab bdg brt', NULL, '', 'KAB BANDUNG BARAT', 'JAWA BARAT', 'bukit-permata-cimahi-2209-c9om', 'Tidak', NULL, '2022-10-09 08:41:23', NULL, '2022-10-08 23:32:14', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(83, 'IPL-YIVYUQ', 'cluster sakura emiko/007/04', NULL, '', '', NULL, NULL, 'jomex878@gmail.com', ' harvest city cluster sakura emiko  ', NULL, '', 'BEKASI', 'JAWA BARAT', 'cluster-sakura-emiko00704-tblw', 'Tidak', NULL, '2022-10-10 01:58:29', NULL, '2022-10-09 23:04:46', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(84, 'IPL-RQGJZY', 'Cikeas Gardenia', NULL, '', '', NULL, NULL, 'bayuindra03@gmail.com', 'jl mawar 3', NULL, '', 'KABUPATEN BOGOR', 'BOGOR', 'cikeas-gardenia-3w57', 'Tidak', NULL, '2022-10-12 01:41:35', NULL, '2022-10-11 16:33:02', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(85, 'IPL-TNOFPX', 'Perum Bumi Sentosa Damai Rt 005 RW 008', 45000, '', '', NULL, NULL, 'wardicell@gmail.com', 'perum bumi sentosa damai blok B14/21\nRt005/008 desa karang sentosa kec karang bahagia', NULL, '', 'KABUPATEN BEKASI', 'JAWA BARAT', 'perum-bumi-sentosa-damai-rt-005-rw-008-bsaj', 'Tidak', NULL, '2022-10-13 06:53:37', NULL, '2022-10-12 15:13:17', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(86, 'IPL-KYLWES', 'Kelurahan Kunciran Jaya', NULL, '', '', NULL, NULL, 'nurabdulazis@gmail.com', '• Jl.HR.Rasuna said nomor rumah 20. RT 01/01. Kel. kunciran jaya. Kec. Pinang. Kota Tangerang.', NULL, '', 'TANGERANG', 'BANTEN', 'kelurahan-kunciran-jaya-0w3o', 'Tidak', NULL, '2022-10-17 02:08:51', NULL, '2022-10-15 23:57:43', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(87, 'IPL-RYJFXT', 'Perum Green Garden 2', NULL, '', '', NULL, NULL, 'agusprasetyo594@gmail.com', 'Temurejo Kembiritan Genteng', NULL, '', 'BANYUWANGI', 'JAWA TIMUR', 'perum-green-garden-2-xfe3', 'Tidak', NULL, '2022-10-22 04:15:06', NULL, '2022-10-21 15:38:51', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(88, 'IPL-TRRSAR', 'perum harapan', NULL, '', '', NULL, NULL, 'hdputra1007@gmail.com', 'jl hasanudin no 76', NULL, '', 'BEKASI', 'JAWABARAT', 'perum-harapan-fuu', 'Tidak', NULL, '2022-10-27 01:36:26', NULL, '2022-10-26 17:04:21', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(89, 'IPL-YNXFTA', 'perumahan wahid', NULL, '', '', NULL, NULL, 'koohongnio@gmail.com', 'jl nanggulan ', NULL, '', 'SALATIGA ', 'JAWA TENGAH', 'perumahan-wahid-gyyq', 'Tidak', NULL, '2022-11-01 01:41:24', NULL, '2022-10-27 18:23:43', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(90, 'IPL-LMMXVH', 'TATELI DUA ', NULL, '', '', NULL, NULL, 'muhammadtampilang@gmail.com', 'tateli dua jaga 1', NULL, '', 'MINAHASA ', 'SULAWESI UTARA', 'tateli-dua-7dal', 'Tidak', NULL, '2022-11-08 01:15:30', NULL, '2022-11-07 09:24:11', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(91, 'IPL-HCYOPM', 'Duren Jaya Permai ', NULL, '', '', NULL, NULL, 'rt05rw04arenjaya@gmail.com', 'Jl.  Kanon RT 05/04', NULL, '', 'KOTA BEKASI ', 'JAWA BARAT ', 'duren-jaya-permai-hu3f', 'Tidak', NULL, '2022-11-09 01:28:48', NULL, '2022-11-08 12:44:42', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(92, 'IPL-MYPRUI', 'rt 01 rw 07 bekasi jaya', NULL, '', '', NULL, NULL, 'rayyankaziandru@gmail.com', 'jl kh agus salim no 39', NULL, '', 'KOTA BEKASI', 'JAWA BARAT', 'rt-01-rw-07-bekasi-jaya-v1tr', 'Tidak', NULL, '2022-11-18 01:42:38', NULL, '2022-11-17 16:23:28', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(93, 'IPL-LHGSFP', 'yusuf', NULL, '', '', NULL, NULL, 'yusuf irdaniyanto', 'Perum. Samasta Citayam 2, Jalan Setapak Blok C 52, Citayam, Bojonggede', NULL, '', 'BOGOR', 'JAWA BARAT', 'yusuf-9lvw', 'Ya', NULL, '2022-11-22 11:57:24', NULL, '2022-11-22 11:57:24', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(94, 'IPL-PDNFVL', 'yusuf', NULL, '', '', NULL, NULL, 'yusufirdaniyanto@gmail.com', 'Perum. Samasta Citayam 2, Jalan Setapak Blok C 52, Citayam, Bojonggede', NULL, '', 'BOGOR', 'JAWA BARAT', 'yusuf-lsr', 'Ya', NULL, '2022-11-22 11:57:47', NULL, '2022-11-22 11:57:47', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(95, 'IPL-PJCORR', 'Manyar Sabrangan/01/01', NULL, '', '', NULL, NULL, 'daves.familys@yahoo.com', 'Manyar Sabrangan I/36', NULL, '', 'SURABAYA', 'JAWA TIMUR', 'manyar-sabrangan0101-wmnk', 'Tidak', NULL, '2022-11-26 09:11:56', NULL, '2022-11-26 05:49:53', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(96, 'IPL-VKYJXZ', 'Dukuh Duren Rw03/Rt14', NULL, '', '', NULL, NULL, 'taufiqhidayah3344@gmail.com', 'Dukuh Duren Rw03 Rt14 Kecamatan Tengaran Kabupaten Semarang Jawa Tengah ', NULL, '', 'KABUPATEN SEMARANG ', 'JAWA TENGAH ', 'dukuh-duren-rw03rt14-cboh', 'Tidak', NULL, '2022-12-02 06:01:44', NULL, '2022-12-02 05:47:45', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(97, 'IPL-AVIBLD', 'Langensari rt 04 RW 03', NULL, '', '', NULL, NULL, 'zulfaadena@gmail.com', 'jl.jayabaya', NULL, '', 'KAN.SEMARANG', 'JAWA TENGAH', 'langensari-rt-04-rw-03-nsg0', 'Tidak', NULL, '2022-12-04 06:12:07', NULL, '2022-12-03 19:29:53', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(98, 'IPL-NIKPXV', 'Perumahan Samasta Citayam 2', NULL, '', '', NULL, NULL, 'violanova26@gmail.com', 'perumahan samasta Citayam 2 Blok D no 05', NULL, '', 'BOGOR', 'JAWA BARAT', 'perumahan-samasta-citayam-2-bfza', 'Ya', NULL, '2022-12-07 12:45:33', NULL, '2022-12-07 12:45:33', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(99, 'IPL-CPQLEJ', 'deparis by avani', NULL, '', '', NULL, NULL, 'marsudioetomo13@gmail.com', 'perumahan deparis by avani ', NULL, '', 'KAB BOGOR', 'JAWA BARAT', 'deparis-by-avani-igog', 'Tidak', NULL, '2022-12-09 10:35:38', NULL, '2022-12-09 10:08:31', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(100, 'IPL-UBKRWJ', 'Cluster Bukit Sakura', 50000, '', '', NULL, NULL, 'achmadfahmi1988@gmail.com', 'Cluster Bukit Sakura - BG10/03', NULL, '', 'BOGOR', 'JAWA BARAT', 'cluster-bukit-sakura-cdgc', 'Tidak', NULL, '2022-12-19 14:35:39', NULL, '2022-12-13 02:44:09', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(101, 'IPL-ETHHUB', 'Griya sejahtera 1 Boyolali', NULL, '', '', NULL, NULL, 'egokill24@gmail.com', 'Dukuh Rejosari RT 09 RW 04 Desa Randusari, Kec. Teras, Kab. Boyolali, Provinsi Jawa Tengah', NULL, '', 'BOYOLALI', 'JAWA TENGAH', 'griya-sejahtera-1-boyolali-wpop', 'Ya', NULL, '2022-12-14 10:03:43', NULL, '2022-12-14 10:03:43', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(102, 'IPL-LTLWXG', 'BCL 2 CIBALONGSARI', NULL, '', '', NULL, NULL, 'abiyusuffaisal@gmail.com', 'Desa Cibalongsari Kecamatan Klari', NULL, '', 'KARAWANG', 'JAWA BARAT', 'bcl-2-cibalongsari-y04y', 'Ya', NULL, '2022-12-20 04:11:04', NULL, '2022-12-20 04:11:04', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(103, 'IPL-VVUXJN', 'SMA 1', NULL, '', '', NULL, NULL, 'imron319800@gmail.com', 'tanah Jambo aye ', NULL, '', 'ACEH UTARA ', 'ACEH ', 'sma-1-iw-j', 'Ya', NULL, '2022-12-24 01:25:16', NULL, '2022-12-24 01:25:16', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(104, 'IPL-DQUQIE', 'R 14', NULL, '', '', NULL, NULL, '319800imron@gmail.com', 'jl. pendidikan no 4', NULL, '', 'ACEH UTARA ', 'ACEH', 'r-14-ioue', 'Ya', NULL, '2022-12-24 02:13:56', NULL, '2022-12-24 02:13:56', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(105, 'IPL-DNHQGD', 'Telaga Golf', NULL, '', '', NULL, NULL, 'dewasurya@gmail.com', 'Sawangan Depok', NULL, '', 'DEPOK', 'JAWA BARAT', 'telaga-golf-benh', 'Tidak', NULL, '2023-01-05 07:20:10', NULL, '2022-12-30 07:32:28', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(106, 'IPL-BVAZXY', 'Ciwaringin Tanah Sewa/002/001', NULL, '', '', NULL, NULL, 'dinaidin22@gmail.com ', 'Ciwaringin Tanah Sewa RT 002 RW 001', NULL, '', 'KOTA BOGOR', 'JAWA BARAT', 'ciwaringin-tanah-sewa002001-fpyy', 'Ya', NULL, '2022-12-30 17:36:39', NULL, '2022-12-30 17:36:39', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(107, 'IPL-HAZAZS', 'Iqro Jatimakmur rt09 rw08', NULL, '', '', NULL, NULL, 'm.nurilhuda@gmail.com ', 'Jl Ayat no 40 Rt 09 Rw 08', NULL, '', 'KOTA BEKASI', 'JAWA BARAT', 'iqro-jatimakmur-rt09-rw08-1oso', 'Ya', NULL, '2023-01-03 14:22:56', NULL, '2023-01-03 14:22:56', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(108, 'IPL-OYPMTB', 'Cahaya Sakinah Village', NULL, '', '', NULL, NULL, 'cahayasakinah.village@gmail.com', 'jl parahyangan, adiarsa barat', NULL, '', 'KARAWANG', 'JAWA BARAT', 'cahaya-sakinah-village-ap4a', 'Tidak', NULL, '2023-01-06 01:39:23', NULL, '2023-01-04 02:46:30', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(109, 'IPL-AIBAGM', 'evergreen cibubur', NULL, '', '', NULL, NULL, 'evergreenegc24', 'JL pratidina harjamukti  cimanggis depok', NULL, '', 'DEPOK', 'JAWA BARAT', 'evergreen-cibubur-m47u', 'Ya', NULL, '2023-01-05 00:34:07', NULL, '2023-01-05 00:34:07', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(110, 'IPL-ZPVTQH', 'evergreen cibubur', NULL, '', '', NULL, NULL, 'evergreenegc24@gmail.com', 'JL pratidina harjamukti  cimanggis depok', NULL, '', 'DEPOK', 'JAWA BARAT', 'evergreen-cibubur-xo8', 'Tidak', NULL, '2023-01-06 01:37:55', NULL, '2023-01-05 00:34:40', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(111, 'IPL-PSUTOH', 'Komplek Taman Pelesiran ', NULL, '', '', NULL, NULL, 'tamanpelesiranrt06', 'jl taman pelesiran', NULL, '', 'KOTA BANDUNG', 'JAWA BARAT', 'komplek-taman-pelesiran-ix7l', 'Ya', NULL, '2023-01-05 04:44:53', NULL, '2023-01-05 04:44:53', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(112, 'IPL-HJTTKB', 'Komplek Taman Pelesiran ', NULL, '', '', NULL, NULL, 'tamanpelesiranrt06@gmail.com', 'jl taman pelesiran', NULL, '', 'KOTA BANDUNG', 'JAWA BARAT', 'komplek-taman-pelesiran-ozl1', 'Ya', NULL, '2023-01-05 04:45:06', NULL, '2023-01-05 04:45:06', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(113, 'IPL-BVFVNL', 'BUMI PURWASARI RESIDEN', NULL, '', '', NULL, NULL, 'syaefulawaludinnur002@gmail.com', 'Perum Bumi Purwasari Residen jln Rafflesia', NULL, '', 'KARAWANG ', 'JAWA BARAT', 'bumi-purwasari-residen-ib33', 'Ya', NULL, '2023-01-05 06:30:20', NULL, '2023-01-05 06:30:20', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(114, 'IPL-HKUJWP', 'sukaregang 01/19', NULL, '', '', NULL, NULL, 'asep02603@gmail.com', 'sukaregang', NULL, '', 'GARUY', 'JAWA BARAT', 'sukaregang-0119-t4cw', 'Ya', NULL, '2023-01-05 06:31:07', NULL, '2023-01-05 06:31:07', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(115, 'IPL-QVMRMP', 'Cluster Ciledug Land', NULL, '', '', NULL, NULL, 'wido.kriswanto@gmail.com', 'Jl. Keramat 7, Kelurahan Tajur, Kecamatan Ciledug', NULL, '', 'TANGERANG', 'BANTEN', 'cluster-ciledug-land-bwj', 'Tidak', NULL, '2023-01-06 01:38:48', NULL, '2023-01-05 12:17:50', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(116, 'IPL-ZROIDM', 'Blok Anggrek/17/03', NULL, '', '', NULL, NULL, 'achmadsetiawan1971@gmail.com', 'Jl.Somawinata Desa Tanimulya Kec Ngamprah ', NULL, '', 'KABUPATEN BANDUNG BARAT', 'JAWA BARAT ', 'blok-anggrek1703-gisx', 'Ya', NULL, '2023-01-07 07:26:49', NULL, '2023-01-07 07:26:49', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(117, 'IPL-NLQWAD', 'SIDODADI', NULL, '', '', NULL, NULL, 'wargasidodadi@gmail.com', 'Sidodadi Arjosari', NULL, '', 'MALANG', 'JAWA TIMUR', 'sidodadi-q14m', 'Ya', NULL, '2023-01-07 15:37:29', NULL, '2023-01-07 15:37:29', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(118, 'IPL-SXWORC', '24/05', NULL, '', '', NULL, NULL, 'hokimalangkab@gmail.com', 'Sidodadi Arjosari', NULL, '', 'KAB MALANG', 'JAWA TIMUR', '2405-hs32', 'Ya', NULL, '2023-01-07 15:55:59', NULL, '2023-01-07 15:55:59', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(119, 'IPL-FKOYWH', 'Nuansa Kori Sading', NULL, '', '', NULL, NULL, 'pyudiarta@gmail.com', 'Nuansa Kori Sading II no 6', NULL, '', 'BADUNG', 'BALI', 'nuansa-kori-sading-leeo', 'Tidak', NULL, '2023-01-09 10:03:28', NULL, '2023-01-08 13:53:37', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(120, 'IPL-KOSXJM', 'metroniaga 02/18', NULL, '', '', NULL, NULL, 'meroniaga@gmail.com', 'kp. sukasari 02/18 ciranjang', NULL, '', 'CIANJUR', 'JAWA BARAT', 'metroniaga-0218-dgas', 'Ya', NULL, '2023-01-08 14:32:35', NULL, '2023-01-08 14:32:35', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(121, 'IPL-FNFTMY', 'Samasta Citayam 2', NULL, '', '', NULL, NULL, 'pitra_jm@yahoo.com', 'Blok B-29\nJl. Setapak, RT.003 RW. 10\nKel. Ragajaya\nKec. Bojong Gede', NULL, '', 'KAB. BOGOR', 'JAWA BARAT', 'samasta-citayam-2-7s', 'Ya', NULL, '2023-01-10 02:32:25', NULL, '2023-01-10 02:32:25', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(122, 'IPL-ZKXLST', 'Pondok Wage Indah 2', NULL, '', '', NULL, NULL, 'dederudi32@gmail.com', 'Dede Rudi', NULL, '', 'SIDOARJO', 'JAWA TIMUR', 'pondok-wage-indah-2-woqh', 'Ya', NULL, '2023-01-10 08:19:08', NULL, '2023-01-10 08:19:08', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(123, 'IPL-YSLIIH', 'GRIYA MALIK DALAM', NULL, '', '', NULL, NULL, 'r.nieaza@gmail.com', 'Jl. KH Malik Dalam Rt.03/04 \nKedungkandang', NULL, '', 'KOTA MALANG', 'JAWA TIMUR', 'griya-malik-dalam-y6sy', 'Tidak', NULL, '2023-01-13 02:43:36', NULL, '2023-01-13 00:48:34', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(124, 'IPL-JPNIDD', '02/01', NULL, '', '', NULL, NULL, 'carmanabdulrohman@gmail.com', 'Rancakuya RT 01 RW 02', NULL, '', 'BANDUNG', 'JAWA BARAT', '0201-fxw7', 'Ya', NULL, '2023-01-15 07:21:12', NULL, '2023-01-15 07:21:12', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(125, 'IPL-ZJIBVO', 'PERUM MTR', NULL, '', '', NULL, NULL, 'sakaprobo@gmail.com', 'perumahan mutiara tlogo regency rt 04 rw01 kel.tlogo,kec.tuntang', NULL, '', 'KABUPATEN SEMARANG', 'JAWA TENGAH', 'perum-mtr-xlgq', 'Ya', NULL, '2023-01-16 09:34:18', NULL, '2023-01-16 09:34:18', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(126, 'IPL-ODWOQJ', 'Arjuno RT 01 rw 08', NULL, '', '', NULL, NULL, 'bentang2019@gmail.com ', 'Rudi Kurniawan ', NULL, '', 'BATU', 'JAWA TIMUR ', 'arjuno-rt-01-rw-08-myos', 'Ya', NULL, '2023-01-16 11:21:38', NULL, '2023-01-16 11:21:38', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(127, 'IPL-PCKLCC', 'Graha Catania', 35000, '', '', NULL, NULL, 'graha.catania.03.09@gmail.com', 'Graha catania desa ciakar kec panongan', NULL, '', 'KABUPATEN TANGERANG', 'BANTEN', 'graha-catania-v3n4', 'Tidak', NULL, '2023-02-04 04:07:21', NULL, '2023-01-21 06:36:29', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(128, 'IPL-UWVPNG', 'GTP-RT05', NULL, '', '', NULL, NULL, 'matano.gtp@gmail.com', 'Cilangkap ', NULL, '', 'KOTA DEPOK', 'JAWA BARAT', 'gtp-rt05-lwtn', 'Ya', NULL, '2023-01-22 09:20:00', NULL, '2023-01-22 09:20:00', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(129, 'IPL-KZTHOP', 'rgt', NULL, '', '', NULL, NULL, 'taraamirah21@gmail.com', 'rgt 23', NULL, '', 'ABY', 'JATIM', 'rgt-n6rt', 'Ya', NULL, '2023-01-23 16:28:24', NULL, '2023-01-23 16:28:24', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(130, 'IPL-QLJWAV', 'Samasta Citayam 2', NULL, '', '', NULL, NULL, 'Rifqimahendraa@gmail.com', 'Samasta Citayam 2, C-21', NULL, '', 'BOGOR', 'JAWA BARAT', 'samasta-citayam-2-pswf', 'Ya', NULL, '2023-01-28 02:51:54', NULL, '2023-01-28 02:51:54', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(131, 'IPL-ZWOOTM', 'Pampang Dua', NULL, '', '', NULL, NULL, 'Iuranairbersih@gmail.com', 'Pampang Dua', NULL, '', 'SANGGAU', 'KALIMANTAN BARAT', 'pampang-dua-zxfv', 'Ya', NULL, '2023-01-28 18:53:27', NULL, '2023-01-28 18:53:27', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(132, 'IPL-ANCDEX', '010/013', NULL, '', '', NULL, NULL, 'marliandi269@gmail.com', 'Jalan Bukit Cemara Mustika, Cluster Bukit Permata Jaya, Bukit Kencana Jaya', NULL, '', 'KOTA SEMARANG', 'JAWA TENGAH', '010013-lcrs', 'Tidak', NULL, '2023-01-31 01:39:32', NULL, '2023-01-30 14:19:58', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(133, 'IPL-XQQTII', 'perumahan Mutiara Tragung', NULL, '', '', NULL, NULL, 'happywulandari02@gmail.com', 'Perumahan Mutiara Tragung blok H nomer 6 ', NULL, '', 'BATANG ', 'JAWA TENGAH ', 'perumahan-mutiara-tragung-ucd', 'Ya', NULL, '2023-01-30 23:47:13', NULL, '2023-01-30 23:47:13', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(134, 'IPL-SZCNHZ', 'Patikraja Estate / 1 / 4', NULL, '', '', NULL, NULL, 'warga.patikrajaestate@gmail.com', 'Jl. Tasaba RT 4 RW 1', NULL, '', 'PATIKRAJA / BANYUMAS', 'JAWA TENGAH', 'patikraja-estate-1-4-zbrm', 'Tidak', NULL, '2023-02-02 06:24:48', NULL, '2023-02-02 04:52:25', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(135, 'IPL-WZVFQK', 'Anjasmoro VI', NULL, '', '', NULL, NULL, 'mardiyono122@gmail.com', 'Anjasmoro VI', NULL, '', 'SEMARANG', 'JAWA TENGAH', 'anjasmoro-vi-mdks', 'Ya', NULL, '2023-02-04 14:28:29', NULL, '2023-02-04 14:28:29', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(136, 'IPL-GBVHFE', 'WISMA ASRI/08/01', NULL, '', '', NULL, NULL, 'ardhi.yoza.hakim@gmail.com', 'jl menteng 3', NULL, '', 'BEKASI', 'JAWABARAT', 'wisma-asri0801-nvwi', 'Tidak', NULL, '2023-02-08 06:08:03', NULL, '2023-02-05 05:41:06', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(137, 'IPL-UQFMFU', 'GRAND PERMATA SEPATAN ', NULL, '', '', NULL, NULL, 'rasyadzaim8@gmail.com', 'A SUNARTO ', NULL, '', 'TANGERANG ', 'BANTEN ', 'grand-permata-sepatan-lvux', 'Tidak', NULL, '2023-02-13 02:41:03', NULL, '2023-02-10 11:55:09', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(138, 'IPL-CQWTEN', 'Perumahan Garden Valley RT 001/001', 0, '', '', NULL, NULL, 'nurcholis645@gmail.com', 'Jalan Kapten Harsono Sudiro , Kelurahan Cigembor', NULL, '', 'CIAMIS', 'JAWA BARAT', 'perumahan-garden-valley-rt-001001-jkml', 'Tidak', NULL, '2023-02-19 17:23:12', NULL, '2023-02-15 17:22:15', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(139, 'IPL-SZFSLG', 'Serpong Natura Cluster Basea', NULL, '', '', NULL, NULL, 'aliesadikin2004@gmail.com', 'NB1/8', NULL, '', 'BOGOR', 'JAWA BARAT', 'serpong-natura-cluster-basea-fw7l', 'Tidak', NULL, '2023-02-20 01:58:23', NULL, '2023-02-17 22:50:34', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(140, 'IPL-BBVVIU', 'pekayon RT009 RW 08', NULL, '', '', NULL, NULL, 'm.hatmoko@gmail.com', 'pekayon RT 009 RW 08', NULL, '', 'JAKARTA TIMUR', 'DKI', 'pekayon-rt009-rw-08-3tvf', 'Tidak', NULL, '2023-02-21 05:24:38', NULL, '2023-02-21 02:20:25', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(141, 'IPL-KFPCEY', '04/03', NULL, '', '', NULL, NULL, 'teja.jonki@gmail.com', 'jl. sempati', NULL, '', 'KOTA TANGERANG', 'BANTEN', '0403-bdq3', 'Tidak', NULL, '2023-02-28 01:34:44', NULL, '2023-02-27 16:24:38', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(142, 'IPL-HDGAGG', 'Pesona Kembang Setu', NULL, '', '', NULL, NULL, 'mohammadrulikusumaputra@gmail.com', 'blok c16', NULL, '', 'SETU', 'BEKASI', 'pesona-kembang-setu-pcmm', 'Ya', NULL, '2023-02-28 07:34:33', NULL, '2023-02-28 07:27:11', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(143, 'IPL-IHXEJA', 'Pesona Kembang Setu', NULL, '', '', NULL, NULL, 'mohammadrulikusumaputra@ymail.com', 'blok c16', NULL, '', 'SETU', 'BEKASI', 'pesona-kembang-setu-exsu', 'Tidak', NULL, '2023-02-28 07:33:34', NULL, '2023-02-28 07:27:29', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(144, 'IPL-SPSPVP', 'PERUMAHAN BUMI SAWITA PERMAI/001/003', NULL, '', '', NULL, NULL, 'rahmawatimarsuki91@gmail.com', 'JL. PONGTIKU, PERUMAHAN BUMI SAWITA PERMAI BLOK K10, PUNCAK INDAH', NULL, '', 'MALILI/LUWU TUMUR', 'SULAWESI SELATAN', 'perumahan-bumi-sawita-permai001003-agzg', 'Tidak', NULL, '2023-03-02 02:12:37', NULL, '2023-03-01 11:29:59', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(145, 'IPL-ENAADQ', 'GRIYA BUKIT INTAN', NULL, '', '', NULL, NULL, 'nedijuna92@gmail.com', 'griya bukit intan rt16/rw05 kel sukabares kec waringinkurung', NULL, '', 'SERANG', 'BANTEN', 'griya-bukit-intan-dd1n', 'Ya', NULL, '2023-03-02 16:00:30', NULL, '2023-03-02 16:00:30', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(146, 'IPL-PERRSA', 'GRIYA BUKIT INTAN', NULL, '', '', NULL, NULL, 'nedijuna19@gmail.com', 'GRIYA BUKIT INTAN KEL SUKABARES KEC WALANTAK', NULL, '', 'SERANG', 'BANTEN', 'griya-bukit-intan-uxx8', 'Tidak', NULL, '2023-03-03 01:26:09', NULL, '2023-03-02 16:35:13', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(147, 'IPL-NARSXS', 'Griya Angkasa Islami', 115000, '', '', NULL, NULL, 'esaenteoes@gmail.com', 'jl. rd Gunawan , Rajabasa pemuka , Bandar Lampung', NULL, '', 'BANDAR LAMPUNG', 'LAMPUNG', 'griya-angkasa-islami-qwa0', 'Tidak', NULL, '2023-03-06 15:02:11', NULL, '2023-03-05 09:35:40', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(148, 'IPL-QZGZXU', 'Graha Angkasa RT 32 RW 06', 50000, '', '', NULL, NULL, 'mego.nondo.sby@gmail.com', 'Jalan Brigjend Katamso IV', NULL, '', 'SIDOARJO', 'JAWA TIMUR', 'graha-angkasa-rt-32-rw-06-eyex', 'Tidak', NULL, '2023-03-09 02:26:33', NULL, '2023-03-08 23:07:38', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(149, 'IPL-QJLJLT', 'Citraland Banjarmasin', NULL, '', '', NULL, NULL, 'hrizki719@gmail.com', 'jl. Ahmad Yani Km 7, Manarap Lama, Kertak Hanyar', NULL, '', 'BANJAR', 'KALIMANTAN SELATAN', 'citraland-banjarmasin-6msg', 'Tidak', NULL, '2023-03-10 02:41:24', NULL, '2023-03-10 02:39:37', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(150, 'IPL-ZVAFWS', 'SENETUAN', NULL, '', '', NULL, NULL, 'elsamdoko5@gmail.com', 'DESA OELOMIN KECAMATAN NEKAMESE', NULL, '', 'KABUPATEN KUPANG', 'NUSA TENGGARA TIMUR', 'senetuan-d3nt', 'Tidak', NULL, '2023-03-13 01:32:03', NULL, '2023-03-11 16:16:37', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(151, 'IPL-IYRYYV', 'perumahan griya bekasi permai 2', NULL, '', '', NULL, NULL, 'rasno.hermawan@gmail.com', 'ds.ciledug.kec.setu kab.bekasi', NULL, '', 'BEKASI', 'JAWA BARAT', 'perumahan-griya-bekasi-permai-2-qi1n', 'Tidak', NULL, '2023-03-13 01:32:19', NULL, '2023-03-12 11:21:33', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(152, 'IPL-UOLKQS', 'graha asri sukodono', NULL, '', '', NULL, NULL, 'yudharana2014@gmail.com', 'graha asri Sukodono L no 17 ', NULL, '', 'SIDOARJO', 'JATIM', 'graha-asri-sukodono-pfod', 'Tidak', NULL, '2023-03-17 06:14:27', NULL, '2023-03-17 01:39:50', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(153, 'IPL-YPWKYS', 'PERUMAHAN MUTIARA CITRA ', NULL, '', '', NULL, NULL, 'sabawargarw12@gmail.com', 'Rw.12 Sukamaju kidul indihiang ', NULL, '', 'TASIKMALAYA', 'JAWA BARAT', 'perumahan-mutiara-citra-xswc', 'Tidak', NULL, '2023-03-17 09:57:39', NULL, '2023-03-17 09:30:10', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(154, 'IPL-GMDNQU', 'Perumahan The Sun Garden', NULL, '', '', NULL, NULL, 'tpambudi@gmail.com', 'Blok B7 No 10, desa sumberejo', NULL, '', 'SIDOARJO', 'JAWA TIMUR', 'perumahan-the-sun-garden-tefk', 'Tidak', NULL, '2023-03-19 12:13:25', NULL, '2023-03-18 15:25:02', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(155, 'IPL-CHAIVS', 'graha asri Sukodono Sidoarjo ', NULL, '', '', NULL, NULL, 'ditapujilestari89@gmail.com', 'perum graha asri Sukodono blok L no 17 sidoarjo', NULL, '', 'SIDOARJO', 'JAWA TIMUR ', 'graha-asri-sukodono-sidoarjo-vvlg', 'Ya', NULL, '2023-03-21 07:12:25', NULL, '2023-03-21 05:03:00', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(156, 'IPL-EMWRIY', 'Sidomukti RT 07 RW 02 ', NULL, '', '', NULL, NULL, 'hariri07@gmail.com', 'Sidomukti RT 07 RW 02 DS Kraton kec Krian Sidoarjo ', NULL, '', 'SIDOARJO ', 'JATIM ', 'sidomukti-rt-07-rw-02-ke03', 'Tidak', NULL, '2023-03-23 01:14:05', NULL, '2023-03-22 13:13:45', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(157, 'IPL-UUJQDR', 'Pribadi', NULL, '', '', NULL, NULL, 'andemi05andemi@gmail.com', 'Jl.freeportlama', NULL, '', 'MIMIKA', 'PAPUA', 'pribadi-jrxl', 'Tidak', NULL, '2023-03-24 01:12:14', NULL, '2023-03-23 15:24:36', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(158, 'IPL-NNGKPB', 'Ngrayung RT.03 RW.01', NULL, '', '', NULL, NULL, 'nanangsby132@gmail.com', 'Ds.brayung Dsn.Ngrayung Kec.Puri Kab.Mojokerto Prov.Jawa timur', NULL, '', 'MOJOKERTO ', 'JAWA TIMUR ', 'ngrayung-rt03-rw01-fh8f', 'Ya', NULL, '2023-03-24 17:35:44', NULL, '2023-03-24 17:35:44', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(159, 'IPL-LJYIQH', 'Jatikramat Indah 1 /03/07', NULL, '', '', NULL, NULL, 'susenononny@gmail.com', 'Jl. Cempaka 6 no 84Jatikramat Indah 1 Jatiasih', NULL, '', 'KOTA BEKASI', 'JAWA BARAT', 'jatikramat-indah-1-0307-0vxx', 'Tidak', NULL, '2023-03-28 09:01:16', NULL, '2023-03-28 07:31:41', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(160, 'IPL-GODKKR', 'Perum Pesona Kahuripan', NULL, '', '', NULL, NULL, 'btcakunmamet@gmail.com', 'Handapherang - Cijeungjing', NULL, '', 'CIAMIS', 'JAWA BARAT', 'perum-pesona-kahuripan-trbg', 'Tidak', NULL, '2023-03-31 07:39:42', NULL, '2023-03-31 07:23:23', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(161, 'IPL-BIYIFN', 'GBA', NULL, '', '', NULL, NULL, 'you.21.@gmail.com', 'Kulon Progo', NULL, '', 'KULON PROGO', 'DIY', 'gba-ouux', 'Ya', NULL, '2023-04-06 05:45:09', NULL, '2023-04-06 05:45:09', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(162, 'IPL-ADIBGJ', 'GBA', NULL, '', '', NULL, NULL, 'you.21.dhy@gmail.com', 'Kulon Progo', NULL, '', 'KULON PROGO', 'DIY', 'gba-zkip', 'Ya', NULL, '2023-04-06 05:45:40', NULL, '2023-04-06 05:45:40', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(163, 'IPL-CKRDVX', 'Rt 7', NULL, '', '', NULL, NULL, 'bahrikayla@gmail.com', 'Jl. Kapten Darmo Sugondo 12B Indro Kebomas', NULL, '', 'GRESIK', 'JAWA TIMUR', 'rt-7-n3by', 'Tidak', NULL, '2023-04-10 01:39:35', NULL, '2023-04-10 00:27:58', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(164, 'IPL-TGSRPK', 'PEMUKIMAN PONDOK', 35000, '', '', NULL, NULL, 'Irwansyah1970@gmail.com', 'Jl. Woltermonginsidi Gg V\nNO. 99 ', NULL, '', 'JEMBER', 'JAWA TIMUR ', 'pemukiman-pondok-0p46', 'Tidak', NULL, '2023-04-13 08:40:05', NULL, '2023-04-13 05:55:57', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(165, 'IPL-UDTULF', 'Perumahan Jatimulya Residence ', NULL, '', '', NULL, NULL, 'fredinurmita.89@gmail.com', 'Jalan R.Suprapto Kampung Tempe RT 001/RW 004', NULL, '', 'KABUPATEN TANGERANG ', 'BANTEN', 'perumahan-jatimulya-residence-zfdq', 'Tidak', NULL, '2023-04-18 07:12:41', NULL, '2023-04-18 04:01:42', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(166, 'IPL-DMPDOT', 'Desa wonosari', NULL, '', '', NULL, NULL, 'iurandesawonosari', 'desa wonosari kecamatan wonosari', NULL, '', 'KABUPATEN MALANG', 'JAWA TIMUR', 'desa-wonosari-kmhk', 'Ya', NULL, '2023-04-29 11:56:59', NULL, '2023-04-29 11:56:59', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(167, 'IPL-USDAMC', 'iuran sampah wonosari', NULL, '', '', NULL, NULL, 'iuransampahwonosari@gmail.com', 'desa wonosari kecamatan wonosari', NULL, '', 'KABUPATEN MALANG', 'JAWA TIMUR', 'iuran-sampah-wonosari-xjux', 'Tidak', NULL, '2023-04-30 15:23:59', NULL, '2023-04-29 11:58:06', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(168, 'IPL-CHTBYV', 'Keroncong Permai /03/06', NULL, '', '', NULL, NULL, 'Awalvaro86@gmail.com', 'Perum Keroncong Permai ', NULL, '', 'TANGERANG', 'BANTEN', 'keroncong-permai-0306-9jnb', 'Tidak', NULL, '2023-04-30 15:23:52', NULL, '2023-04-30 11:53:47', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(169, 'IPL-QVCTSY', 'VGH 5', 0, '', '', NULL, NULL, 'indraprasasti1@gmail.com', 'vgh 5 tambun utara', NULL, '', 'BEKASI', 'JAWA BARAT', 'vgh-5-ocey', 'Tidak', NULL, '2023-05-02 03:07:25', NULL, '2023-05-02 02:06:40', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(170, 'IPL-WBPMGP', 'Cluster Munjung Agung Asri', NULL, '', '', NULL, NULL, 'bimarama906@gmail.com', 'munjung agung - kramat', NULL, '', 'TEGAL', 'JAWA TENGAH', 'cluster-munjung-agung-asri-j3a', 'Tidak', NULL, '2023-05-04 09:58:32', NULL, '2023-05-04 09:00:15', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(171, 'IPL-MMAKPS', 'raffa residence/05/05', NULL, '', '', NULL, NULL, 'hollaoffice2@gmail.com', 'raffa residence 4 blok f5, jl.kemang rt05/05 pasir putih sawangan depok', NULL, '', 'DEPOK', 'JAWA BARAT', 'raffa-residence0505-xiyr', 'Ya', NULL, '2023-05-05 15:06:15', NULL, '2023-05-05 15:06:15', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(172, 'IPL-VSIWVT', 'GAS 3', NULL, '', '', NULL, NULL, 'qiens2015@gmail.com', 'GAS 3', NULL, '', 'SIDOARJO', 'JAWA TIMUR', 'gas-3-baje', 'Ya', NULL, '2023-05-06 10:33:05', NULL, '2023-05-06 10:33:05', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(173, 'IPL-QFWUDP', 'Kp cikiiing', NULL, '', '', NULL, NULL, 'dhaniedua1@gmail.com', 'kp.cikijinh', NULL, '', 'TASIKMALAYA', 'JAWABARAT', 'kp-cikiiing-pz-e', 'Ya', NULL, '2023-05-07 16:05:24', NULL, '2023-05-07 16:05:24', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(174, 'IPL-URVRFG', 'Puri Surya Jaya, Sydney Garden/RW.07/RT.02', NULL, '', '', NULL, NULL, 'aa.dhan0809@gmail.com', 'Puri Surya Jaya, Sydney Garden, Punggul, Gedangan', NULL, '', 'SIDOARJO', 'JAWA TENGAH', 'puri-surya-jaya-sydney-gardenrw07rt02-k-5w', 'Ya', NULL, '2023-05-08 14:39:34', NULL, '2023-05-08 14:39:34', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(175, 'IPL-JLYWLD', 'Boulevard Denpasar Blok E15 & F12 ', 75, '', '', NULL, NULL, 'muhammad.jiyadi02@gmail.com', 'Panorama Bali Residence', NULL, '', 'BOGOR', 'JAWA BARAT', 'boulevard-denpasar-blok-e15-f12-6hmd', 'Tidak', NULL, '2023-05-09 04:43:32', NULL, '2023-05-09 03:17:24', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(176, 'IPL-QQSTLH', 'Kp.sawahbera', NULL, '', '', NULL, NULL, 'ayuchman@gmail.com', 'kp.sawahbera rt03/rw05\ndesa cintaasi  kec samarang', NULL, '', 'GARUT', 'JAWABARAT', 'kpsawahbera-zwb', 'Ya', NULL, '2023-05-12 12:08:47', NULL, '2023-05-12 12:08:47', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(177, 'IPL-BXIJUT', 'Usman Land', NULL, '', '', NULL, NULL, 'triyuni593@gmail.com', 'Kelurahan Garum, Kecamatan Garum, Kabupaten Blitar', NULL, '', 'BLITAR', 'JAWA TIMUR', 'usman-land-e8l0', 'Ya', NULL, '2023-05-13 11:01:03', NULL, '2023-05-13 11:01:03', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(178, 'IPL-YOLDZE', 'Usman Land/03/03', NULL, '', '', NULL, NULL, 'Trit9211@gmail.com', 'W698+RVP Perumahan Usman Land, Jl. Majapahit, Area Sawah, Garum, Kec. Garum, Kabupaten Blitar, Jawa Timur 66182', NULL, '', 'BLITAR', 'JAWA TIMUR', 'usman-land0303-mjee', 'Ya', NULL, '2023-05-13 11:11:48', NULL, '2023-05-13 11:11:48', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(179, 'IPL-ZVCJJU', 'RT 001 RW 008', NULL, '', '', NULL, NULL, 'rt01rw08gpg2@gmail.com', 'Griya Permata Gedangan II', NULL, '', 'SIDOARJO', 'JAWA TIMUR', 'rt-001-rw-008-oalh', 'Ya', NULL, '2023-05-14 12:41:57', NULL, '2023-05-14 12:41:57', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(180, 'IPL-YUKFMD', 'kaliacai', NULL, '', '', NULL, NULL, 'rasgyatrav@gmail.com', 'kaliacai', NULL, '', 'JAYAPURA', 'PAPUA', 'kaliacai-nbm3', 'Ya', NULL, '2023-05-15 05:39:25', NULL, '2023-05-15 05:39:25', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(181, 'IPL-AHPULQ', 'PONDOK MELATI 2 WARGA B2', NULL, '', '', NULL, NULL, 'yusupiyam124@gmol.com', 'kp pawarengan rt 02 rw 09', NULL, '', 'KARAWANG', 'JAWA BARAT', 'pondok-melati-2-warga-b2-bttp', 'Ya', NULL, '2023-05-23 14:40:32', NULL, '2023-05-23 14:40:32', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(182, 'IPL-WJOHVT', 'PONDOK MELATI 2 WARGA B2', NULL, '', '', NULL, NULL, 'yusupiyam124@gmail.com', 'kp pawarengan rt 02 rw 09', NULL, '', 'KARAWANG', 'JAWA BARAT', 'pondok-melati-2-warga-b2-dnby', 'Tidak', NULL, '2023-05-24 01:18:15', NULL, '2023-05-23 14:40:58', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(183, 'IPL-CPCIYP', 'Kampung Sunnah Azzikra ', 100000, '', '', NULL, NULL, 'rw05ksazzikra@gmail.com', 'Jl. Syukur I No. 10 A, Cipambuan, Babakan Madang, Bogor, Jawa Barat', NULL, '', 'BOGOR', 'JAWA BARAT', 'kampung-sunnah-azzikra-y7y', 'Tidak', NULL, '2023-05-25 05:06:57', NULL, '2023-05-24 11:36:28', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(184, 'IPL-RRWMAF', 'PURA ARISTA 004/019', NULL, '', '', NULL, NULL, 'yusuf1010@gmail.com', 'Komp. Pura Arista\nDesa Tajurhalang\nKec    Tajurhalang', NULL, '', 'KAB. BOGOR', 'JAWA BARAT', 'pura-arista-004019-3gbv', 'Tidak', NULL, '2023-05-25 09:50:30', NULL, '2023-05-25 07:34:36', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(185, 'IPL-IMTCSJ', 'Perumahan Nanggela Anugrah Pratama ', NULL, '', '', NULL, NULL, 'septianwira90@gmail.com', 'Perumahan Nanggela Anugrah Pratama ', NULL, '', 'BOGOR', 'JAWA BARAT ', 'perumahan-nanggela-anugrah-pratama-slze', 'Tidak', NULL, '2023-05-29 01:42:41', NULL, '2023-05-27 05:34:47', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(186, 'IPL-ZHRAXY', 'Perum. Citra Raya Graha Indira Blok K5 No. 31 RT.000/RW,00', NULL, '', '', NULL, NULL, 'lasmauliremmy@gmIl.com', 'Graha Indira Blok K5 No. 31', NULL, '', 'TANGERANG', 'BANTEN', 'perum-citra-raya-graha-indira-blok-k5-no-31-rt000rw00-yg88', 'Ya', NULL, '2023-05-30 11:24:44', NULL, '2023-05-30 11:24:44', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(187, 'IPL-IIVQMI', 'hafiz residence', NULL, '', '', NULL, NULL, 'erwinkiket12@gmail.com', 'tanjung raya 2 gang haji qadir', NULL, '', 'KOTA PONTIANAK', 'KALIMANTAN BARAT', 'hafiz-residence-dpcy', 'Tidak', NULL, '2023-05-31 02:48:13', NULL, '2023-05-30 17:47:10', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(188, 'IPL-ZXAIXQ', 'cokro', NULL, '', '', NULL, NULL, 'bittryan1992@gmail.com', 'hayam wuruk', NULL, '', 'MADIUN', 'JAWA TIMUR', 'cokro-dbmr', 'Ya', NULL, '2023-06-03 15:24:12', NULL, '2023-06-03 15:24:12', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(189, 'IPL-NJMYIG', 'Kuala merbau', NULL, '', '', NULL, NULL, 'yanfaizal08@gmail.com', 'Jl setia pati', NULL, '', 'KEPULAUAN MERANTI', 'RIAU', 'kuala-merbau-qwgy', 'Tidak', NULL, '2023-06-07 01:31:49', NULL, '2023-06-06 16:06:20', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(190, 'IPL-HYMCEJ', 'Setia pati', NULL, '', '', NULL, NULL, 'mujibyan5@gmail.com', 'kuala merbau', NULL, '', 'KEPULAUAN MERANTI', 'RIAU', 'setia-pati-1ojt', 'Tidak', NULL, '2023-06-07 03:00:41', NULL, '2023-06-06 16:09:52', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(191, 'IPL-VXCILN', 'Pulogebang 08 06', NULL, '', '', NULL, NULL, 'Yudi.imawanto@gmail.com ', 'pulogebang ', NULL, '', 'DKI JAKARTA ', 'JAKARTA TIMUR ', 'pulogebang-08-06-srzu', 'Ya', NULL, '2023-06-07 14:08:16', NULL, '2023-06-07 14:08:16', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(192, 'IPL-CJBBUO', 'griya kertamukti tesidance', NULL, '', '', NULL, NULL, 'kertamukti@gmail.com', 'blok c1 dan c2', NULL, '', 'BEKASI', 'CIBITUNG', 'griya-kertamukti-tesidance-5ce5', 'Tidak', NULL, '2023-06-15 02:59:49', NULL, '2023-06-15 02:56:18', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL);
INSERT INTO `m_cluster` (`iId`, `idCluster`, `vNama`, `vIPL`, `noSK`, `vLogo`, `vImage`, `vTelp`, `vEmail`, `vAlamat`, `vLokasi`, `vMisiVisi`, `vKota`, `vProvinsi`, `slug`, `eDeleted`, `iCreatedid`, `tCreated`, `iUpdatedid`, `tUpdated`, `prefix`, `panjang_nomor`, `reset_tipe`, `nomor_terakhir`, `auto_print`, `format_id`, `print_id`, `pdf_id`) VALUES
(193, 'IPL-DBOUJP', 'Wisma asri/ 08/ 01', NULL, '', '', NULL, NULL, 'yozaok@gmail.com', 'jl menyeng 3', NULL, '', 'BEKASI', 'JAWA BARAT', 'wisma-asri-08-01-irlb', 'Ya', NULL, '2023-06-17 19:17:30', NULL, '2023-06-17 19:17:30', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(194, 'IPL-VORFHS', 'Perumahaan Menara Bumi Asri 3', NULL, '', '', NULL, NULL, 'pl.menarabumiasri3@gmail.com', 'komplek mba3 . kec nan sabaris. kab padang pariaman sumbar', NULL, '', 'PADANG PARIAMAN', 'SUMBAR', 'perumahaan-menara-bumi-asri-3-5pwf', 'Ya', NULL, '2023-06-20 01:28:39', NULL, '2023-06-20 01:28:39', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(195, 'IPL-KRPJOE', 'Menara bumi asri 3', NULL, '', '', NULL, NULL, 'unan1980@gmail.com', 'kampung ladang  nan sabaris.', NULL, '', 'PADANG PARIAMAN', 'SUMBAR', 'menara-bumi-asri-3-zo61', 'Tidak', NULL, '2023-06-20 01:43:06', NULL, '2023-06-20 01:35:03', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(196, 'IPL-TDMQOH', 'Perumahan Fontana Lake RT 06 RW 03', 45000, '', '', NULL, NULL, 'vincensunaryo@gmail.com', 'Perumahan Fontana Lake Situsari Cileungsi ', NULL, '', 'KAB BOGOR ', 'JAWA BARAT ', 'perumahan-fontana-lake-rt-06-rw-03-anes', 'Tidak', NULL, '2023-06-27 17:14:47', NULL, '2023-06-20 10:45:35', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(197, 'IPL-ZJNFPX', 'Magnolia Park 7&9', NULL, '', '', NULL, NULL, 'wmraffi2@gmail.com', 'irigasi sipon kenanga Cipondoh ', NULL, '', 'TANGERANG KOTA', 'BANTEN', 'magnolia-park-79-xkcw', 'Tidak', NULL, '2023-06-27 15:46:55', NULL, '2023-06-27 13:19:41', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(198, 'IPL-CMGIRH', 'Alamanda regensi RT 03/027', NULL, '', '', NULL, NULL, 'abuhor98i@gmail.com', 'Alamanda regensi blok N RT 03 RW 027', NULL, '', 'BEKASI ', 'JAWA BARAT ', 'alamanda-regensi-rt-03027-yhoi', 'Tidak', NULL, '2023-06-28 10:00:26', NULL, '2023-06-28 04:34:32', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(199, 'IPL-WNINRS', 'Toholand Debora', NULL, '', '', NULL, NULL, 'ditadevrianti@gmail.com', 'jln Oswald siahaan', NULL, '', 'TAPANULI TENGAH', 'SUMATERA UTARA', 'toholand-debora-0pdo', 'Tidak', NULL, '2023-07-04 02:58:08', NULL, '2023-07-03 05:22:34', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(200, 'IPL-JDBRZQ', 'toholand debora', NULL, '', '', NULL, NULL, 'erditadevrianti051@gmail.com', 'jl. Oswald siahaan\nkecamatan pandan\n', NULL, '', 'TAPANULI TENGAH', 'SUMATERA UTARA', 'toholand-debora-7we3', 'Ya', NULL, '2023-07-03 05:34:39', NULL, '2023-07-03 05:34:39', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(201, 'IPL-GVGOOS', 'Kavling Pelita Air Service Depok', NULL, '', '', NULL, NULL, 'rw15.kavas@gmail.com', 'Kavling Pelita Air Service RW 15 Kelurahan Rangkapan Jaya Baru', NULL, '', 'DEPOK', 'JAWA BARAT ', 'kavling-pelita-air-service-depok-rpoe', 'Tidak', NULL, '2023-07-04 02:58:01', NULL, '2023-07-03 13:11:48', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(202, 'IPL-GSKYEE', 'Argawana', NULL, '', '', NULL, NULL, 'argawana.baletirtawana@gmail.com', 'Jl. Raya Rumpin', NULL, '', 'BOGOR', 'JAWA BARAT ', 'argawana-f7nn', 'Tidak', NULL, '2023-07-05 01:41:15', NULL, '2023-07-04 13:07:31', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(203, 'IPL-VTQXQB', 'PERUMAHAN PERMATA HIJAU PRATAMA', NULL, '', '', NULL, NULL, 'zlatanaditya@gmail.com', 'BLOK O NOMER 2', NULL, '', 'LAMPUNG SELATAN', 'LAMPUNG', 'perumahan-permata-hijau-pratama-rd0c', 'Tidak', NULL, '2023-07-07 01:35:19', NULL, '2023-07-06 10:32:19', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(204, 'IPL-IKAMMF', 'perum kota batara', NULL, '', '', NULL, NULL, 'nisfisubandi59@gmail.com', 'perum kota batara blok L4/21', NULL, '', 'TANGERANG ', 'BANTEN ', 'perum-kota-batara-4nnd', 'Ya', NULL, '2023-07-08 12:46:08', NULL, '2023-07-08 12:46:08', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(205, 'IPL-FYDZMJ', 'Anjasmoro 6 ', NULL, '', '', NULL, NULL, 'freistek@gmail.com', 'Anjasmoro 6 ', NULL, '', 'KOTA SEMARANG ', 'JAWATENGAH', 'anjasmoro-6-qcu', 'Tidak', NULL, '2023-07-10 02:01:44', NULL, '2023-07-09 12:33:03', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(206, 'IPL-SZUVWI', 'Perum. Bumi Trias Alam Sejahtera ', NULL, '', '', NULL, NULL, 'yunan.alam@gmail.com', 'Kebalen', NULL, '', 'BEKASI', 'JAWA TENGAH', 'perum-bumi-trias-alam-sejahtera-gvxa', 'Tidak', NULL, '2023-07-11 10:15:55', NULL, '2023-07-11 09:58:45', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(207, 'IPL-NGZPEU', 'Griya Asri 2', NULL, '', '', NULL, NULL, 'handitowibowo@yahoo.com', 'Perum. Griya Asri 2 Blok E Timur RT 005 RW 023', NULL, '', 'KABUPATEN BEKASI', 'JAWA BARAT', 'griya-asri-2-6swv', 'Tidak', NULL, '2023-07-18 04:08:03', NULL, '2023-07-18 03:50:24', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(208, 'IPL-JKSDGY', 'Mansion Garden ', NULL, '', '', NULL, NULL, 'mansion.garden2020@gmail.com', 'Jl Sukabakti 3 RT 02 RW 06 Serua Indah  Ciputat', NULL, '', 'TANGERANG SELATAN ', 'BANTEN ', 'mansion-garden-34k3', 'Tidak', NULL, '2023-07-20 01:43:38', NULL, '2023-07-18 12:23:28', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(209, 'IPL-QAAWJZ', 'Pasir randu residence', NULL, '', '', NULL, NULL, 'gangextrajoss@gmail.com', 'pasir randu residence', NULL, '', 'BEKASI', 'JAWA BARAT', 'pasir-randu-residence-fvo4', 'Tidak', NULL, '2023-07-21 02:22:14', NULL, '2023-07-20 22:48:41', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(210, 'IPL-RAAFIC', 'Bellavista Residence/06/05', NULL, '', '', NULL, NULL, 'alitanmas@gmail.com', 'Bellavista Residence ', NULL, '', 'BATAM', 'KEPULAUAN RIAU', 'bellavista-residence0605-kcyk', 'Tidak', NULL, '2023-07-25 01:59:11', NULL, '2023-07-22 13:30:05', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(211, 'IPL-FAVCYX', 'nabire', NULL, '', '', NULL, NULL, 'krisnasungkono95@gmail.com', 'seluruh nabire', NULL, '', 'NABIRE', 'PAPUA TENGAH', 'nabire-iam6', 'Tidak', NULL, '2023-07-24 01:45:56', NULL, '2023-07-22 22:30:04', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(212, 'IPL-RRGQLM', 'Alam Serpong', NULL, '', '', NULL, NULL, 'mr.syahrial@yahoo.com', 'Perumahan Alam Serpong Blok F9 Kelurahan Ciater Kecamatan Serpong', NULL, '', 'TANGERANG SELATAN', 'BANTEN', 'alam-serpong-psvu', 'Tidak', NULL, '2023-07-27 01:49:47', NULL, '2023-07-27 00:44:47', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(213, 'IPL-HYFJQJ', 'Bukit Pratama Residemce', NULL, '', '', NULL, NULL, 'zswandono@gmail.com', 'Jl Lindung No.101 RT 004/RW 009', NULL, '', 'KOTA BEKASI', 'JAWA BARAT', 'bukit-pratama-residemce-4gv', 'Tidak', NULL, '2023-07-28 01:49:04', NULL, '2023-07-27 13:16:20', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(214, 'IPL-IQFHPX', 'Perumahan Cahaya Ros', NULL, '', '', NULL, NULL, 'muhammadwahyudji@gmail.com', 'Perumahan Cahaya Ros', NULL, '', 'PALEMBANG', 'SUMATERA SELATAN ', 'perumahan-cahaya-ros-9pwu', 'Tidak', NULL, '2023-07-31 15:45:23', NULL, '2023-07-31 11:46:23', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(215, 'IPL-HDIMPA', 'perumahan griya kencana 1 ', 50000, '', '', NULL, NULL, 'wellyseano@gmail.com', 'perumahan griya kencana 1 blok A18', NULL, '', 'TANGERANG', 'BANTEN', 'perumahan-griya-kencana-1-dotr', 'Tidak', NULL, '2023-08-02 07:37:56', NULL, '2023-08-02 05:29:43', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(216, 'IPL-SAXVMF', 'sd negri 1 pacet', NULL, '', '', NULL, NULL, 'lelysagenis@gmail.com', 'desa pacet kecamatan pacet kabupaten mojokerto', NULL, '', 'MOJOKERTO', 'JAWA TIMUR', 'sd-negri-1-pacet-kekk', 'Tidak', NULL, '2023-08-02 15:09:31', NULL, '2023-08-02 10:19:03', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(217, 'IPL-MFHXCE', 'rezana', NULL, '', '', NULL, NULL, 'luckyxxx39@gmail.com', 'rezana garden', NULL, '', 'PROBOLINGGO', 'JAWA TIMUR', 'rezana-2lu', 'Ya', NULL, '2023-08-03 11:13:51', NULL, '2023-08-03 11:13:51', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(218, 'IPL-MZYDAW', 'paguyupan kelas 71', NULL, '', '', NULL, NULL, 'wulankwok888@gmail.com', 'SMP 8 Balikpapan ', NULL, '', 'BALIKPAPAN ', 'KALIMANTAN TIMUR ', 'paguyupan-kelas-71-kg16', 'Tidak', NULL, '2023-08-14 09:57:42', NULL, '2023-08-14 08:28:28', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(219, 'IPL-DOEFMS', 'AWK/14/04', NULL, '', '', NULL, NULL, 'pajaja.pajajaran@gmail.com', 'bojong gede', NULL, '', 'BOGOR', 'JAWA BARAT', 'awk1404-pmd8', 'Ya', NULL, '2023-08-17 06:33:11', NULL, '2023-08-17 06:33:11', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(220, 'IPL-IGUTSA', 'The Cinnamond RT 14/04', NULL, '', '', NULL, NULL, 'setyabe77@gmail.com', 'Jl. Mekarwangi ', NULL, '', 'BOGOR', 'JAWA BARAT', 'the-cinnamond-rt-1404-sjsz', 'Ya', NULL, '2023-08-21 04:11:01', NULL, '2023-08-21 04:11:01', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(221, 'IPL-FVDXXZ', 'nr2', NULL, '', '', NULL, NULL, 'ekspedisi30juz@gmail.com', 'asem', NULL, '', 'BEKASI', 'JAWA BARAT', 'nr2-wvfb', 'Ya', NULL, '2023-08-24 19:57:31', NULL, '2023-08-24 19:57:31', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(222, 'IPL-FEQDUS', 'Gdr', NULL, '', '', NULL, NULL, 'yudaprasetya93@gmail.com ', 'Gedung dalam residence ', NULL, '', 'PESAWARAN ', 'LAMPUNG ', 'gdr-coyp', 'Ya', NULL, '2023-08-25 16:44:38', NULL, '2023-08-25 16:44:38', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(223, 'IPL-KVEKEF', 'BP008019', NULL, '', '', NULL, NULL, 'Kurniawanahmad1580@gmail.com', 'perum buana point blok h no. 1, sungai langkai, sagulung', NULL, '', 'BATAM', 'KEPULAUAN RIAU', 'bp008019-2kxb', 'Ya', NULL, '2023-09-02 18:38:20', NULL, '2023-09-02 18:38:20', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(224, 'IPL-ZYDREI', 'Puri Satreyan Regency', NULL, '', '', NULL, NULL, 'warga.psr@gmail.com', 'Jl. Patimura RT 01/RW 03, Kelurahan Satreyan, Kecamatan Kanigoro', NULL, '', 'KABUPATEN BLITAR', 'JAWA TIMUR', 'puri-satreyan-regency-4prt', 'Ya', NULL, '2023-09-08 00:56:50', NULL, '2023-09-08 00:56:50', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(225, 'IPL-PDMJYL', 'Samasta Ciseeng/01/05', NULL, '', '', NULL, NULL, 'macho.anjoy@gmail.com', 'jl amd kuripan ', NULL, '', 'KABUPATEN BOGOR', 'JAWA BARAT', 'samasta-ciseeng0105-ubm', 'Tidak', NULL, '2023-09-11 01:37:25', NULL, '2023-09-09 15:50:05', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(226, 'IPL-HETZSS', '013/002/017', NULL, '', '', NULL, NULL, 'adesofyan.quality@gmail.com', 'jl. batu ampar 1 no.13', NULL, '', 'JAKARTA TIMUR ', 'DKI JAKARTA ', '013002017-3md', 'Ya', NULL, '2023-09-13 19:46:09', NULL, '2023-09-13 19:46:09', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(227, 'IPL-BTAWCM', 'dreamland 2', NULL, '', '', NULL, NULL, 'rt02rw023@gmail.com', 'dreamland 2 rt02 rw023 kel. tj riau kec sekupang', NULL, '', 'BATAM', 'KEPRI', 'dreamland-2-melr', 'Ya', NULL, '2023-09-15 08:20:19', NULL, '2023-09-15 08:20:19', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(228, 'IPL-KNLPVT', 'dreamland 2', NULL, '', '', NULL, NULL, 'aprizuhri78@gmail.com', 'kel tj riau kec sekupang', NULL, '', 'BATAM', 'KEPRI', 'dreamland-2-szvc', 'Ya', NULL, '2023-09-15 08:30:40', NULL, '2023-09-15 08:30:40', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(229, 'IPL-RFYAXA', 'geo', NULL, '', '', NULL, NULL, 'geomnrl@gmail.com', 'dimana mana', NULL, '', 'JOGJO', 'JOGJO', 'geo-rco5', 'Ya', NULL, '2023-09-17 22:48:18', NULL, '2023-09-17 22:48:18', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(230, 'IPL-UNZYXH', 'Ambarukmo GH', NULL, '', '', NULL, NULL, 'aghjogja@gmail.com', 'Nologaten', NULL, '', 'SLEMAN', 'D.I.YOGYAKARTA', 'ambarukmo-gh-2jpg', 'Ya', NULL, '2023-09-18 01:53:58', NULL, '2023-09-18 01:53:58', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(231, 'IPL-UBMKZA', 'vila dago tol blok i RW.21 RT.03', NULL, '', '', NULL, NULL, 'sachrulm@yahoo.com', 'jalan manyar 2, kel.serua,ciputat, tangsel, banten', NULL, '', 'TANGERANG SELATAN', 'BANTEN', 'vila-dago-tol-blok-i-rw21-rt03-m5dl', 'Ya', NULL, '2023-09-18 03:37:21', NULL, '2023-09-18 03:37:21', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(232, 'IPL-CBYCVG', 'Muara karang rt 10', NULL, '', '', NULL, NULL, 'yatomo@gmail.com', 'pluit karang sari x no.36 ', NULL, '', 'JAKARTA UTARA ', 'JAKARTA ', 'muara-karang-rt-10-wruw', 'Ya', NULL, '2023-09-18 12:32:04', NULL, '2023-09-18 12:32:04', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(233, 'IPL-ODRLHZ', 'perumahan taman karang bahagia ', NULL, '', '', NULL, NULL, 'dianahidayanti07@gmail.com', 'perumahan taman karang bahagia blok b26no37 rt 04/014', NULL, '', 'KABUPATEN BEKASI', 'JAWA BARAT ', 'perumahan-taman-karang-bahagia-qlup', 'Ya', NULL, '2023-09-20 11:45:46', NULL, '2023-09-20 11:45:46', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(234, 'IPL-GLRDFU', 'Perum. Citra Indah City ', NULL, '', '', NULL, NULL, 'sophie.santosa@yahoo.com', 'Perum. Citra Indah City Bukit Heliconia AG 16/2', NULL, '', 'BOGOR', 'JAWA BARAT', 'perum-citra-indah-city-8jx7', 'Ya', NULL, '2023-09-23 10:51:30', NULL, '2023-09-23 10:51:30', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(235, 'IPL-MZDNYR', 'HELICONIA RT.03/11', NULL, '', '', NULL, NULL, 'winasuryani@yahoo.com', 'Citra Indah City', NULL, '', 'KABUPATEN BOGOR', 'JAWA BARAT', 'heliconia-rt0311-jgcx', 'Ya', NULL, '2023-09-23 10:57:22', NULL, '2023-09-23 10:57:22', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(236, 'IPL-IHXLEO', 'perum citra indah city / 012/002', NULL, '', '', NULL, NULL, 'yudhasantosa22@gmail.com', 'perumahan citra indah city bukit heliconia AG 16/2', NULL, '', 'JONGGOL/BOGOR', 'JAWA BARAT', 'perum-citra-indah-city-012002-wmzm', 'Ya', NULL, '2023-09-23 11:55:02', NULL, '2023-09-23 11:55:02', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(237, 'IPL-BWKXXG', 'Perum Bumi Endah ', NULL, '', '', NULL, NULL, 'ceppysahrulsidik@gmail.com', 'perum bumi endah blok p12 p13 i indihiang', NULL, '', 'KOTA TASIKMALAYA', 'JAWABARAT', 'perum-bumi-endah-usnk', 'Ya', NULL, '2023-09-29 08:59:49', NULL, '2023-09-29 08:59:49', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(238, 'IPL-QNQLDK', 'RT3/RW9', NULL, '', '', NULL, NULL, 'elowspeed@gmail.com', 'Eko Yulianto ', NULL, '', 'KEBUMEN', 'JAWA TENGAH ', 'rt3rw9-olsi', 'Ya', NULL, '2023-10-15 02:32:23', NULL, '2023-10-15 02:32:23', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(239, 'IPL-ZAUWVO', 'kandangan', NULL, '', '', NULL, NULL, 'fasdi', 'samiranna', NULL, '', 'TEMANGGING', 'JATENG', 'kandangan-sz8i', 'Ya', NULL, '2023-10-16 16:20:45', NULL, '2023-10-16 16:20:45', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(240, 'IPL-KHMQBS', 'Cluster Pinang Merah / 005 / 014', NULL, '', '', NULL, NULL, 'Pinangmerah005014@gmail.com', 'Perumahan Mekarsari Permai Cluster Pinang Merah Blok E2 No D31 Rt 005 Rw 014 Kelurahan Gandoang Kecamatan Cileungsi', NULL, '', 'KABUPATEN BOGOR', 'JAWA BARAT', 'cluster-pinang-merah-005-014-hcde', 'Ya', NULL, '2023-10-18 15:03:21', NULL, '2023-10-18 15:03:21', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(241, 'IPL-OMWIJQ', 'jingkang Rt 4 RW 1', NULL, '', '', NULL, NULL, 'lempayan@gmail.com', 'jingkang Karangreja purbalingga', NULL, '', 'KARANGREJA PURBALINGGA ', 'JAWA TENGAH', 'jingkang-rt-4-rw-1-ghkb', 'Ya', NULL, '2023-10-24 17:01:02', NULL, '2023-10-24 17:01:02', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(242, 'IPL-ORNXRA', 'Kp Sukawening ', NULL, '', '', NULL, NULL, 'yusupsukarno13@gmail.com', 'Kp Sukawening 001/003', NULL, '', 'KABUPATEN BANDUNG ', 'JAWA BARAT ', 'kp-sukawening-rn-d', 'Ya', NULL, '2023-10-25 18:00:25', NULL, '2023-10-25 18:00:25', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(243, 'IPL-PMBNSP', 'kedungbanteng', NULL, '', '', NULL, NULL, 'hhjios@bacot.in', 'jl.arsaleh 4', NULL, '', 'NGANJUK', 'JAWATIMUR', 'kedungbanteng-qlld', 'Ya', NULL, '2023-10-27 10:15:24', NULL, '2023-10-27 10:15:24', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(244, 'IPL-CQWFTL', 'Perum Griya Samudra Asri', NULL, '', '', NULL, NULL, 'alvinarga9@gmail.com', 'Perum Griya Samudra Asri, Taman, Sidoarjo', NULL, '', 'SIDOARJO ', 'JAWA TIMUR', 'perum-griya-samudra-asri-xvo6', 'Ya', NULL, '2023-10-28 08:30:02', NULL, '2023-10-28 08:30:02', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(245, 'IPL-MNINFM', 'yu', NULL, '', '', NULL, NULL, 'husnul2aspiana@gmail.com', 'jjj', NULL, '', 'JHS', 'HSHHS', 'yu-vr3i', 'Ya', NULL, '2023-11-03 06:38:05', NULL, '2023-11-03 06:25:47', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(247, 'IPL-ZKWBZA', 'Citra Indah City, Cluster Bukit Heliconia', NULL, '', '', NULL, NULL, 'winasuryani3t0@gmail.com', 'Citra Indah City\nCluster Bukit Heliconia', NULL, '', 'KABUPATEN BOGOR', 'JAWA BARAT', 'citra-indah-city-cluster-bukit-heliconia-m5dp', 'Ya', NULL, '2023-11-04 10:20:14', NULL, '2023-11-04 10:20:14', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(248, 'IPL-UWENKC', 'Permata Singosari', NULL, '', '', NULL, NULL, 'ulimahendra@gmail.com', 'Perum. Permata Singosari B17', NULL, '', 'MALANG', 'JAWA TIMUR', 'permata-singosari-k7re', 'Ya', NULL, '2023-11-04 12:02:24', NULL, '2023-11-04 12:02:24', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(249, 'IPL-MVLWCT', 'hshshdh', NULL, '', '', NULL, NULL, 'husnulw.aspiana@gmail.com', 'hdhshd', NULL, '', 'DBBD', 'BSBSB', 'hshshdh-9ges', 'Ya', NULL, '2023-12-21 01:27:13', NULL, '2023-11-06 06:00:25', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(250, 'IPL-XYAESF', 'Perumahan Puri Kosambi RT 23', NULL, '', '', NULL, NULL, 'sendi.galih.pratama@gmail.com', 'Perumahan Puri Kosambi Blok B2 No.6', NULL, '', 'TANGERANG', 'BANTEN', 'perumahan-puri-kosambi-rt-23-xehn', 'Ya', NULL, '2023-11-25 12:18:55', NULL, '2023-11-25 12:18:55', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(251, 'IPL-KZWOKO', 'SJRC', NULL, '', '', NULL, NULL, '3heng99@gmail.com', 'sjrc c101', NULL, '', 'SIDOARJO', 'JAWA TIMUR', 'sjrc-fzah', 'Ya', NULL, '2023-11-26 01:02:36', NULL, '2023-11-26 01:02:36', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(252, 'IPL-FOIKPO', 'SJRC', NULL, '', '', NULL, NULL, '3heng88@gmail.com', 'sukodono', NULL, '', 'SIDOARJO', 'JAWA TIMUR', 'sjrc-qyg5', 'Ya', NULL, '2023-11-28 05:12:53', NULL, '2023-11-28 05:12:53', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(253, 'IPL-BZURSI', 'Puri Cendrawasih', NULL, '', '', NULL, NULL, 'droomansyah@gmail.com', 'Puri Cendrawasih Blok PC 02/02 Sukamantri Pasar Kemis', NULL, '', 'TANGRERANG', 'BANTEN', 'puri-cendrawasih-oitq', 'Ya', NULL, '2023-12-01 17:27:12', NULL, '2023-12-01 17:27:12', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(254, 'IPL-SCSEJZ', 'Telukjambe 2023', NULL, '', '', NULL, NULL, 'pemudateje2023@gmail.com', 'Telukjambe ', NULL, '', 'KARAWANG ', 'JAWA BARAT ', 'telukjambe-2023-kskw', 'Ya', NULL, '2023-12-04 05:24:10', NULL, '2023-12-04 05:24:10', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(255, 'IPL-MKCTBT', 'Graha Sevilla T.05/06 RT 001 RW 007', NULL, '', '', NULL, NULL, 'yayahsyamsiahh1@gmail.com', 'Graha Sevilla T .05/06 RT 001 RW 007 desa Ciakar kecamatan Panongan ', NULL, '', 'KABUPATEN TANGERANG', 'BANTEN', 'graha-sevilla-t0506-rt-001-rw-007-sv-t', 'Ya', NULL, '2023-12-09 03:54:04', NULL, '2023-12-09 03:54:04', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(256, 'IPL-OVYWHI', 'GuaHiro', NULL, '', '', NULL, NULL, 'gue@jah.com', 'disini', NULL, '', 'LAMA', 'ISTIMEWA', 'guahiro-po4d', 'Ya', NULL, '2023-12-10 09:05:01', NULL, '2023-12-10 09:05:01', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(257, 'IPL-VLAGGC', 'Bougenville Indah Residence ', NULL, '', '', NULL, NULL, 'jefri.jabbaar@gmail.com', 'Jl.Sei Mencirim, Desa Suka Maju, Kec.Sunggal, Kab.Deli Serdang', NULL, '', 'DELI SERDANG ', 'SUMATRA UTARA ', 'bougenville-indah-residence-qvlx', 'Ya', NULL, '2023-12-20 18:27:17', NULL, '2023-12-20 18:27:17', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(258, 'IPL-PLOJZV', 'tes', NULL, '', '', NULL, NULL, 'husnul.aspiana@gmail.com', 'tete', NULL, '', 'HSHHS', 'BSBS', 'tes-hgcr', 'Ya', NULL, '2023-12-21 01:27:16', NULL, '2023-12-21 01:27:16', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(259, 'IPL-MQGENA', 'Arrosyad Residence', NULL, '', '', NULL, NULL, 'aguslistiyo29@gmail.com', 'Jl. Guru Elat, Pamegarsari', NULL, '', 'BOGOR', 'JAWA BARAT', 'arrosyad-residence-8950', 'Ya', NULL, '2024-01-03 02:24:06', NULL, '2024-01-03 02:24:06', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(260, 'IPL-NOXKXK', 'desa babakan karet', NULL, '', '', NULL, NULL, 'calya1416@gmail.com', 'jln profesor Moch Yamin ', NULL, '', 'CIANJUR ', 'JAWA BARAT ', 'desa-babakan-karet-usjs', 'Ya', NULL, '2024-01-03 16:10:00', NULL, '2024-01-03 16:10:00', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(261, 'IPL-KLZVFT', 'VILLA BATU ASRI PANCUR BATU', NULL, '', '', NULL, NULL, 'sjumakir@gmail.com', 'Perumahan Villa Batu Asri Pancur Batu', NULL, '', 'DELI SERDANG', 'SUMATERA UTARA', 'villa-batu-asri-pancur-batu-alh', 'Ya', NULL, '2024-01-04 02:53:58', NULL, '2024-01-04 02:53:58', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(262, 'IPL-JECCMC', 'MUTIARA CITRA', NULL, '', '', NULL, NULL, 'zahiratravelnusa@gmail.com', 'JL.GUNUNGMANGGU', NULL, '', 'TASIKMALAYA', 'JAWA BARAT', 'mutiara-citra-dsp', 'Ya', NULL, '2024-01-09 11:48:43', NULL, '2024-01-09 11:48:43', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(263, 'IPL-SDWJBS', 'Puri taman pesona', NULL, '', '', NULL, NULL, 'prionos58@gmail.com', 'Puri Taman Pesona blok A1', NULL, '', 'BANYUMAS', 'JAWA TENGAH', 'puri-taman-pesona-mt3p', 'Ya', NULL, '2024-01-09 21:44:57', NULL, '2024-01-09 21:44:57', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(264, 'IPL-HZTMJV', 'Dharma Residence Umalas', NULL, '', '', NULL, NULL, 'dru.estatemanager@gmail.com', 'JL Bumbak Dauh', NULL, '', 'BADUNG', 'BALI', 'dharma-residence-umalas-idkd', 'Ya', NULL, '2024-01-19 07:45:52', NULL, '2024-01-19 07:45:52', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(265, 'IPL-GMGXXD', 'Perum. Bumi Harapan Sejahtera RT 003 RW 029', NULL, '', '', NULL, NULL, 'aditya.fds16@gmail.com', 'Perum. Bumi Harapan Sejahtera RT 003 RW 029 Kel. Unyur', NULL, '', 'SERANG', 'BANTEN', 'perum-bumi-harapan-sejahtera-rt-003-rw-029-dmz5', 'Ya', NULL, '2024-01-31 02:25:29', NULL, '2024-01-31 02:25:29', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(266, 'IPL-CYGYBX', 'Perumahan Griya Bangil Asri', NULL, '', '', NULL, NULL, 'nurindrawahyuimamsaputraati@gmail.com', 'Perumahan Griya Bangil Asri ', NULL, '', 'PASURUAN ', 'JAWA TIMUR', 'perumahan-griya-bangil-asri-iqle', 'Ya', NULL, '2024-02-03 15:33:03', NULL, '2024-02-03 15:33:03', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(267, 'IPL-RUOIDL', 'Taman Rejeki', NULL, '', '', NULL, NULL, 'dgratias.work@gmail.com', 'jl. kiara payung 24', NULL, '', 'CIBINONG', 'JAWA BARAT', 'taman-rejeki-fkjs', 'Ya', NULL, '2024-02-12 08:03:56', NULL, '2024-02-12 08:03:56', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(268, 'IPL-XDWXCS', 'Blok Pemijen RT 14 RW 04', NULL, '', '', NULL, NULL, 'mpatmput2@gmail.com', 'RT 14 RW 04', NULL, '', 'CIREBON', 'JAWA BARAT', 'blok-pemijen-rt-14-rw-04-zyj', 'Ya', NULL, '2024-03-23 15:13:40', NULL, '2024-03-23 15:13:40', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(269, 'IPL-UHSDWW', 'Perumahan Samasta Citayam 2, Blok A No.16', NULL, '', '', NULL, NULL, 'azs_saranajasa@yahoo.com', 'Perumahan Samasta Citayam 2, Blok A No. 16, Jalan Setapak, Kel. Ragajaya, Kec. Bojong Gede.', NULL, '', 'BOGOR ', 'JAWA BARAT ', 'perumahan-samasta-citayam-2-blok-a-no16-ya9f', 'Ya', NULL, '2024-03-31 01:55:24', NULL, '2024-03-31 01:55:24', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(270, 'IPL-HXZSZH', 'Komplek Grand Purnama 2 Blok F Jalur 23', NULL, '', '', NULL, NULL, 'rizaabqary29@gmail.com', 'Jalan Trans Kalimantan', NULL, '', 'BARITO KUALA', 'KALIMANTAN SELATAN', 'komplek-grand-purnama-2-blok-f-jalur-23-bsc', 'Ya', NULL, '2024-04-20 02:37:30', NULL, '2024-04-20 02:37:30', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(271, 'IPL-NUZDLH', 'Lotus Sepinggan Residence RT 07', NULL, '', '', NULL, NULL, 'wicaksonoari90@gmail.com', 'Jalan Daksa Raya Perumahan Lotus Sepinggan Residence RT 07 Blok C No 5', NULL, '', 'BALIKPAPAN', 'KALIMANTAN TIMUR ', 'lotus-sepinggan-residence-rt-07-qv1r', 'Ya', NULL, '2024-04-21 05:18:23', NULL, '2024-04-21 05:18:23', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(272, 'IPL-VVHQFK', 'Perumahan Seruni Hills', NULL, '', '', NULL, NULL, 'dudi.hadmojo@gmail.com', 'Jl. Swadaya 3, Perumahan Seruni Hills, RT 004/RW 006, Kelurahan Jatiranggon, Kecamatan Jatisampurna', NULL, '', 'KOTA BEKASI', 'JAWA BARAT', 'perumahan-seruni-hills-e05b', 'Ya', NULL, '2024-05-11 16:45:08', NULL, '2024-05-11 16:45:08', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(273, 'IPL-VVQCDS', 'Perumahan Permata asri sea/001/001', NULL, '', '', NULL, NULL, 'art8845@gmail.com', 'Perumahan Permata Asri sea \ndeaa sea kecamatan pineleng', NULL, '', 'MINAHASA', 'SULAWESI UTARA', 'perumahan-permata-asri-sea001001-9eta', 'Ya', NULL, '2024-05-14 07:26:45', NULL, '2024-05-14 07:26:45', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(274, 'IPL-DCQAKB', 'RT 02 friendship', NULL, '', '', NULL, NULL, 'layananmantap2016@gmail.com', 'jl.moh nur ', NULL, '', 'KABUPATEN BOGOR ', 'JAWA BARAT ', 'rt-02-friendship-zkhf', 'Ya', NULL, '2024-06-20 04:59:12', NULL, '2024-06-20 04:59:12', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(275, 'IPL-GSLVHU', 'HARMONI PRIMAVERA ', NULL, '', '', NULL, NULL, 'asepsaepudin27@guru.smp.belajar.id', 'Harmoni PRIMAVERA blok AA09 Desa Bojong Kecamatan klapanunggal ', NULL, '', 'KABUPATEN BOGOR ', 'JAWA BARAT ', 'harmoni-primavera-i5vp', 'Ya', NULL, '2024-07-16 23:32:13', NULL, '2024-07-16 23:32:13', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(276, 'IPL-LDSEKQ', 'Perum Bumi citra indah BCI 1 ', NULL, '', '', NULL, NULL, 'dedetayudin2@gmail.com ', 'Perum Bumi citra indah BCI 1 blok H no 8A1 Desa Pataruman Kec cihampelas kab Bandung Barat Rt 03 RW 13', NULL, '', 'BANDUNG BARAT ', 'JAWA BARAT ', 'perum-bumi-citra-indah-bci-1-7xie', 'Ya', NULL, '2024-07-21 16:48:51', NULL, '2024-07-21 16:48:51', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(277, 'IPL-GGPRIV', 'Perum Bumi citra indah BCI 1 ', NULL, '', '', NULL, NULL, 'dedekangenwater001@gmail.com ', 'Perum Bumi citra indah BCI 1 blok H no 8A1 Desa Pataruman Kec cihampelas kab Bandung Barat Rt 03 RW 13', NULL, '', 'BANDUNG BARAT ', 'JAWA BARAT ', 'perum-bumi-citra-indah-bci-1-f38l', 'Ya', NULL, '2024-07-21 16:49:37', NULL, '2024-07-21 16:49:37', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(278, 'IPL-HRCAZI', 'Perum Bumi citra indah BCI 1 ', NULL, '', '', NULL, NULL, 'dedekangenwater003@gmail.com ', 'Perum Bumi citra indah BCI 1 blok H no 8A1 Desa Pataruman Kec cihampelas kab Bandung Barat Rt 03 RW 13', NULL, '', 'BANDUNG BARAT ', 'JAWA BARAT ', 'perum-bumi-citra-indah-bci-1-oqmc', 'Ya', NULL, '2024-07-21 16:50:10', NULL, '2024-07-21 16:50:10', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(279, 'IPL-PWPOAU', 'perumahan grand nusa indah, cluster urena', NULL, '', '', NULL, NULL, 'aminudinahmad03@gmail.com', 'jl. grand nusa indah, cluster urena, blok U9/18', NULL, '', 'BOGOR', 'JAWA BARAT', 'perumahan-grand-nusa-indah-cluster-urena-kqh3', 'Ya', NULL, '2024-07-28 11:25:47', NULL, '2024-07-28 11:25:47', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(280, 'IPL-NDKOBP', 'CLUSTER KANA', NULL, '', '', NULL, NULL, 'dedesugianto996@gmail.com', 'Perum Citra Swarna Grande Blok K16 no 14, dusun Kawali, desa Pancawati, kecamatan Klari', NULL, '', 'KARAWANG', 'JAWA BARAT', 'cluster-kana-4pnh', 'Ya', NULL, '2024-08-01 06:18:13', NULL, '2024-08-01 06:18:13', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(281, 'IPL-IDKVUH', 'Cluster Ubud RT 04 RW 051', NULL, '', '', NULL, NULL, 'rizky.septiana20512@gmail.com', 'cluster ubud u31 no 11', NULL, '', 'KAB.BEKASI', 'JAWA BARAT', 'cluster-ubud-rt-04-rw-051-cqww', 'Ya', NULL, '2024-08-07 23:57:09', NULL, '2024-08-07 23:57:09', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(282, 'IPL-NJBLVV', 'jv', NULL, '', '', NULL, NULL, 'raisdasta05@gmail.com', 'tapos', NULL, '', 'DEPOK', 'JABAR', 'jv-0bch', 'Ya', NULL, '2024-08-31 13:54:18', NULL, '2024-08-31 13:54:18', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(283, 'IPL-MMBFQL', 'Safira juanda resort ', NULL, '', '', NULL, NULL, 'amrullah1984@gmail.com', 'Safira Juanda Resort Cluster Valley ', NULL, '', 'SIDOARJO ', 'JAWA TIMUR', 'safira-juanda-resort-hkha', 'Ya', NULL, '2024-09-01 02:00:10', NULL, '2024-09-01 02:00:10', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(284, 'IPL-AIRNEY', 'vxmckm', NULL, '', '', NULL, NULL, 'mguhyo', 'fspbwg\n', NULL, '', 'UXNNTM', 'RIIBVT', 'vxmckm-h5cs', 'Ya', NULL, '2024-09-06 22:16:03', NULL, '2024-09-06 22:16:03', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(285, 'IPL-OHMYVO', 'Graceland Residence ', NULL, '', '', NULL, NULL, 'fortunaajustitia@gmail.com', 'Perumahan  Graceland  Residence  blok C-24\nJln. AH. Nasution No 20a', NULL, '', 'KOTA BANDUNG', 'JAWABARAT', 'graceland-residence-t4kn', 'Ya', NULL, '2024-10-07 06:15:07', NULL, '2024-10-07 06:15:07', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(286, 'IPL-HMJMYM', 'Graceland Residence', NULL, '', '', NULL, NULL, 'rc807746@@gmail.com', 'Perum. Gracelad Residence \njalan: AH. Nasution no 20a\nkelurahan antapani wetan\nkecamatan antapani\nRT 01 RW 010\n', NULL, '', 'KOTA BANDUNG', 'JAWA BARAT', 'graceland-residence-fx3j', 'Ya', NULL, '2024-10-07 06:20:20', NULL, '2024-10-07 06:20:20', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(288, 'IPL-BGHSTD', 'Pesona Candi', NULL, '', '', NULL, NULL, 'mepeaninalsav@gmail.com', 'Jl. Pesona Candi', NULL, '', 'PASURUAN', 'JAWARIMUR', 'pesona-candi-z45c', 'Ya', NULL, '2024-11-23 18:08:57', NULL, '2024-11-23 18:08:57', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(289, 'IPL-BGGHEE', 'PURI HARMONI 8 EXT BLOK L', NULL, '', '', NULL, NULL, 'ph8ext.blokl@gmail.com', 'Jl. Raya Cibunar', NULL, '', 'BOGOR', 'JAWA BARAT', 'puri-harmoni-8-ext-blok-l-anyz', 'Ya', NULL, '2024-11-27 07:27:28', NULL, '2024-11-27 07:27:28', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(290, 'IPL-EZAQXZ', 'perumahan D\'Area Permata ', NULL, '', '', NULL, NULL, 'fariedir@gmail.com', 'perumahan D\'Area Permata, Sawangan, Depok, Jawa Barat', NULL, '', 'DEPOK ', 'JAWA BARAT ', 'perumahan-darea-permata-d4fk', 'Ya', NULL, '2024-11-28 09:08:38', NULL, '2024-11-28 09:08:38', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(291, 'IPL-NOJYDJ', 'Ardena Residence', NULL, '', '', NULL, NULL, 'rifiandi.indrajaya@gmail.com', 'ardena residence mampang depok', NULL, '', 'DEPOK', 'JAWA BARAT', 'ardena-residence-te2b', 'Ya', NULL, '2024-12-09 00:06:38', NULL, '2024-12-09 00:06:38', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(292, 'IPL-KOGKCN', 'perum vila mutiara cikarang 2 / RT 027 / RW 008', NULL, '', '', NULL, NULL, 'yangcha 5718@gmail.com', 'vmc 2 blok G11 / 09', NULL, '', 'KAB.BEKASI', 'JAWA BARAT', 'perum-vila-mutiara-cikarang-2-rt-027-rw-008-osgz', 'Ya', NULL, '2025-01-01 21:01:06', NULL, '2025-01-01 21:01:06', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(293, 'IPL-YPVMTQ', 'Bukit Amarilis ', NULL, '', '', NULL, NULL, 'irvanverd@gmail.com', 'Citra Indah City ,Jonggol', NULL, '', 'BOGOR', 'JABAR', 'bukit-amarilis-pw9m', 'Ya', NULL, '2025-01-16 11:29:16', NULL, '2025-01-16 11:29:16', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(294, 'IPL-ZSAIOH', 'Puri Kintamani RT.07 RW.06', NULL, '', '', NULL, NULL, 'jablukbuluk86@gmail.com', 'Perumahan Puri Kintamani Blok A Rt.07 Rw.06', NULL, '', 'BOGOR', 'JAWA BARAT', 'puri-kintamani-rt07-rw06-wtah', 'Ya', NULL, '2025-01-25 13:14:35', NULL, '2025-01-25 13:14:35', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(295, 'IPL-JILSVQ', 'GRIYA INDAH SERPONG BLOK S-U/04/17', NULL, '', '', NULL, NULL, 'dhanapala.gbwgis@gmail.com', 'Griya Indah Serpong Blok S-U RT/RW 04/17 Cibinong, Gunung Sindur, Bogor - Jawa Barat 16340', NULL, '', 'BOGOR', 'JAWA BARAT', 'griya-indah-serpong-blok-s-u0417-h86', 'Ya', NULL, '2025-03-02 16:18:07', NULL, '2025-03-02 16:18:07', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(296, 'IPL-ZINOIP', 'brawijaya regency', NULL, '', '', NULL, NULL, 'gusavies09@gmail.com', 'brawijaya regency kel kebalenan banyuwangi', NULL, '', 'BANYUWANGI', 'JAWA TIMUR', 'brawijaya-regency-21ox', 'Ya', NULL, '2025-04-03 14:55:09', NULL, '2025-04-03 14:55:09', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(297, 'IPL-KMPMIH', 'Diamond Park Sawangan', NULL, '', '', NULL, NULL, 'diamondparksawangan@gmail.com', 'Bedahan, Sawangan, Depok City, West Java 16512', NULL, '', 'DEPOK', 'JAWA BARAT', 'diamond-park-sawangan-ggdm', 'Ya', NULL, '2025-04-30 10:27:30', NULL, '2025-04-30 10:27:30', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(298, 'IPL-IWOQEW', 'Mahkota/02/03', NULL, '', '', NULL, NULL, 'hindrahuang91@gmail.com', 'Jl Bambu Kuning no 12', NULL, '', 'KOTA PEKANBARU', 'RIAU', 'mahkota0203-bofn', 'Ya', NULL, '2025-05-07 04:20:05', NULL, '2025-05-07 04:20:05', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(299, 'IPL-AZMCQA', 'Mahkota/02/03', NULL, '', '', NULL, NULL, 'hindrahuang92@gmail.com', 'Jl Bambu Kuning no 12', NULL, '', 'KOTA PEKANBARU', 'RIAU', 'mahkota0203-puw3', 'Ya', NULL, '2025-05-07 04:20:08', NULL, '2025-05-07 04:20:08', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(300, 'IPL-KVXEEN', 'Diamond Park', NULL, '', '', NULL, NULL, 'mahayuda30@gmail.com', 'Bedahan', NULL, '', 'DEPOK', 'JAWA BARAT', 'diamond-park-gqn7', 'Ya', NULL, '2025-05-09 05:19:01', NULL, '2025-05-09 05:19:01', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(301, 'IPL-CFOGEO', 'grand delima sentul', NULL, '', '', NULL, NULL, 'yudilesmana11@gmail.com', 'sukaraja', NULL, '', 'BOGOR', 'JAWA BARAT', 'grand-delima-sentul-aihy', 'Ya', NULL, '2025-05-12 13:52:54', NULL, '2025-05-12 13:52:54', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(302, 'IPL-TBQFNS', 'Gondangan ', NULL, '', '', NULL, NULL, 'jokopnm1980@gmail.com', 'Gondangan rt / rw :014/007,somokaton,karangnongko', NULL, '', 'KLATEN', 'JAW TENGAH ', 'gondangan-wxpc', 'Ya', NULL, '2025-06-13 11:30:45', NULL, '2025-06-13 11:30:45', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(303, 'IPL-UGXEGV', 'sir2', NULL, '', '', NULL, NULL, 'ronylukman1969@gmail.com', 'sentul', NULL, '', 'BOGOR', 'JAWABARAT', 'sir2-i-tj', 'Ya', NULL, '2025-06-15 21:32:44', NULL, '2025-06-15 21:32:44', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(304, 'IPL-UOVSDP', 'RT 03', NULL, '', '', NULL, NULL, 'maulvinazir@gmail.com', 'Perum Prima Garuda Sakti Blok G No.6', NULL, '', 'PEKANBARU ', 'RIAU ', 'rt-03-u1ka', 'Ya', NULL, '2025-06-18 16:24:14', NULL, '2025-06-18 16:24:14', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(305, 'IPL-JQXHSM', 'Giriland Sukagalih', NULL, '', '', NULL, NULL, 'rahmanyusup2010@gmail.com', 'perum giriland blok 5 no 12', NULL, '', 'KAB TASIKMALAYA', 'JAWA BARAT', 'giriland-sukagalih-qm8p', 'Ya', NULL, '2025-06-19 13:34:08', NULL, '2025-06-19 13:34:08', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(306, 'IPL-GWHJZO', 'Jakarta Regency', NULL, '', '', NULL, NULL, 'fahrianiman@gmail.com', 'Jl. Jakarta 2, Perum Jakarta Regency, Blok Gardenia No.B9A, Loa Bakung, Sungai Kunjang', NULL, '', 'SAMARINDA', 'KALIMANTAN TIMUR', 'jakarta-regency-qrz3', 'Ya', NULL, '2025-06-24 03:03:31', NULL, '2025-06-24 03:03:31', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(307, 'IPL-SOMTGV', 'KHALAS CLUSTER ESTATE', NULL, '', '', NULL, NULL, 'riyadi.cikarang@gmail.com', 'Khalas Cluster Estate, Jl. H. Nalim, RT.001/RW.008, Karangasih, Kec. Cikarang Utara, Kabupaten Bekasi, Jawa Barat 17530', NULL, '', 'CIKARAMG UTARA', 'JAWA BARAT', 'khalas-cluster-estate-uv5m', 'Ya', NULL, '2025-07-07 00:56:37', NULL, '2025-07-07 00:56:37', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(308, 'IPL-SHRKKL', 'Taman Suko Asri RT.32', NULL, '', '', NULL, NULL, 'dramandana@gmail.com', 'Taman Suko Asri RT 32', NULL, '', 'SIDOARJO', 'JAWA TIMUR', 'taman-suko-asri-rt32-vqat', 'Ya', NULL, '2025-07-07 15:21:24', NULL, '2025-07-07 15:21:24', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(309, 'IPL-TOPUQB', 'dddc', NULL, '', '', NULL, NULL, 'ahanan@gmail.com', 'djdjjss', NULL, '', 'SJKSKS', 'SKKDKS', 'dddc-kayb', 'Ya', NULL, '2025-07-23 19:44:13', NULL, '2025-07-23 19:44:13', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(310, 'IPL-UNJGCL', 'GRAND PAKIS RESIDENCE 3 / 01 / 02', NULL, '', '', NULL, NULL, 'evan.trijanitra@gmail.com', 'Jl. Cendana Rawakalong', NULL, '', 'KAB. BOGOR', 'JAWA BARAT', 'grand-pakis-residence-3-01-02-8yt3', 'Ya', NULL, '2025-08-08 18:55:09', NULL, '2025-08-08 18:55:09', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(311, 'IPL-QRGSMX', 'Lotus Regency', NULL, '', '', NULL, NULL, 'deddydamon219@gmail.com', 'Jl. Transad Komp. Gt. Manggis Rahayu Kel. Guntung Manggis Kecamatan Landasan Ulin', NULL, '', 'BANJARBARU', 'KALIMANTAN SELATAN', 'lotus-regency-0yva', 'Ya', NULL, '2025-08-11 13:13:54', NULL, '2025-08-11 13:13:54', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(312, 'IPL-EVEDGD', 'CLUSTER BOTANICA GRAND TENJO RESIDENCE ', NULL, '', '', NULL, NULL, 'jkotriady@gmail.com', 'jl raya Cilaku, Tenjo, Kabupaten Bogor ', NULL, '', 'KABUPATEN BOGOR ', 'JAWA BARAT ', 'cluster-botanica-grand-tenjo-residence-7bj7', 'Ya', NULL, '2025-08-12 16:08:09', NULL, '2025-08-12 16:08:09', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(313, 'IPL-FGCKGX', 'citraland', NULL, '', '', NULL, NULL, 'albaalyspa@gmail.com', 'Ruko Nortwesh Boulevard NV 02/01 citraland', NULL, '', 'SURABAYA', 'JAWA TIMUR', 'citraland-jffy', 'Ya', NULL, '2025-08-21 05:01:53', NULL, '2025-08-21 05:01:53', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(314, 'IPL-YFOBFL', 'asten', NULL, '', '', NULL, NULL, 'dafarinakarin@gmail.com', 'asten, jln kh Abdullah bin nih cianjur ', NULL, '', 'CIANJUR', 'JAWA BARAT', 'asten-dfej', 'Ya', NULL, '2025-08-31 08:29:44', NULL, '2025-08-31 08:29:44', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(315, 'IPL-HYHAUN', '12/09', NULL, '', '', NULL, NULL, 'dafarinakarin@gmil.com', 'asten jln. kh Abdullah. bin nuh', NULL, '', 'CIANJUR', 'JAWA BARAT', '1209-trd', 'Ya', NULL, '2025-09-01 01:05:51', NULL, '2025-09-01 01:05:51', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(316, 'IPL-QPUAHJ', 'rt 6 rw 1', NULL, '', '', NULL, NULL, 'rafidasalsa124@gmail.com', 'jln. halaman rt 6 rw 1 desa sengguruh kecamatan kepanjen kabupaten malang', NULL, '', 'MALANG', 'JAWA TIMUR', 'rt-6-rw-1-7u8e', 'Ya', NULL, '2025-09-02 13:40:53', NULL, '2025-09-02 13:40:53', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(317, 'IPL-PHHNQJ', 'Griyajati Kalijaga 2 / RW9 / RT8', NULL, '', '', NULL, NULL, 'ar.data19@gmail.com', 'Griyajati Kalijaga 2\nKec. Harjamukti\nKel. Kalijaga', NULL, '', 'KOTA CIREBON', 'JAWA BARAT', 'griyajati-kalijaga-2-rw9-rt8-ti62', 'Ya', NULL, '2025-09-04 02:55:00', NULL, '2025-09-04 02:55:00', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(318, 'IPL-RLZQAG', 'RT 01 RW 03', NULL, '', '', NULL, NULL, 'siwohartono30@gmail.com', 'Warak Kidul Sumberadi Mlati Sleman Yogyakarta 55288', NULL, '', 'SLEMAN ', 'YOGYAKARTA ', 'rt-01-rw-03-crki', 'Ya', NULL, '2025-09-05 07:04:16', NULL, '2025-09-05 07:04:16', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(319, 'IPL-NEMDYZ', 'GRAHA PESONA PAKANSARI RT 07/RW 08', NULL, '', '', NULL, NULL, 'joenedyahmad@gmail.com', 'jl.Sirojul munir kelurahan nanggewer kecamatan cibinong ', NULL, '', 'BOGOR', 'JAWA BARAT', 'graha-pesona-pakansari-rt-07rw-08-6wer', 'Ya', NULL, '2025-09-07 04:06:09', NULL, '2025-09-07 04:06:09', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(320, 'IPL-WIMJDU', 'Griya Pesona Rancalame', NULL, '', '', NULL, NULL, 'silmihasna@gmail.com', 'Jl. Mayang', NULL, '', 'BANDUNG', 'JAWA BARAT', 'griya-pesona-rancalame-ct4d', 'Ya', NULL, '2025-09-16 13:49:20', NULL, '2025-09-16 13:49:20', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(321, 'IPL-VXVQVX', 'Gardenia cileungsi 1 rt04 rw08', NULL, '', '', NULL, NULL, 'albiansyahzyanakbar@gmail.com', 'perum gardenia cileungsi 1 Blok H no 1  klapanunggal kab bogor', NULL, '', 'BOGOR', 'JAWABARAT ', 'gardenia-cileungsi-1-rt04-rw08-vtjy', 'Ya', NULL, '2025-09-22 09:12:13', NULL, '2025-09-22 09:12:13', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(322, 'IPL-FTJCYG', 'Perumahan Grand Nusa Indah RT 004 RW 012', NULL, '', '', NULL, NULL, 'anoegroh.77@gmail.com', 'Perumahan Grand Nusa Indah RT 004/012 Desa Setusari Kecamatan Cileungsi ', NULL, '', 'KABUPATEN BOGOR ', 'JAWA BARAT ', 'perumahan-grand-nusa-indah-rt-004-rw-012-ba52', 'Ya', NULL, '2025-09-23 09:48:05', NULL, '2025-09-23 09:48:05', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(323, 'IPL-NBQMKA', 'Perumahan Bumi Gesya Cikarang ', NULL, '', '', NULL, NULL, 'budiwoodpeker70.as@gmail.com', 'RT 048/RW 002 kp leungsir, Jayasampurna, Kec. Serang Baru, Kabupaten Bekasi, Jawa Barat 17330', NULL, '', 'BEKASI', 'JAWA BARAT ', 'perumahan-bumi-gesya-cikarang-ihb2', 'Ya', NULL, '2025-09-26 08:21:32', NULL, '2025-09-26 08:21:32', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(324, 'IPL-UYXKLZ', 'BADAN HARIAN RT01', NULL, '', '', NULL, NULL, 'pengurusbendaharan1@gmail.com', 'Komp Ex Pertamina', NULL, '', 'JAKARTA TIMUR', 'DKI', 'badan-harian-rt01-bcam', 'Ya', NULL, '2025-09-30 16:33:44', NULL, '2025-09-30 16:33:44', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(325, 'IPL-ABHDFZ', 'balcony', NULL, '', '', NULL, NULL, 'evadayu354@gmail.com', '-', NULL, '', 'BOGOR', 'HHH', 'balcony-pvva', 'Ya', NULL, '2025-10-01 10:18:46', NULL, '2025-10-01 10:18:46', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(326, 'IPL-MQXGWK', 'MTR04', NULL, '', '', NULL, NULL, 'installertechnologysystem@gmail.com', 'tlogo', NULL, '', 'TUNTANG ', 'JAWA TENGAH ', 'mtr04-uo7i', 'Ya', NULL, '2025-10-03 13:00:28', NULL, '2025-10-03 13:00:28', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(327, 'IPL-GXCICY', 'cikarang baru / 07 / 01', NULL, '', '', NULL, NULL, '13kondang@gmail.com', 'jl panda 5A C6 no 2\ndesa jayamukti \nkec cikarang pusat', NULL, '', 'KAB BEKASI', 'JAWA BARAT', 'cikarang-baru-07-01-smzu', 'Ya', NULL, '2025-10-10 05:46:35', NULL, '2025-10-10 05:46:35', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(328, 'IPL-SGDKCI', 'Giriland sukagalih', NULL, '', '', NULL, NULL, 'yusuprahman2010@gmail.com', 'perum giriland bkok 5 no 12', NULL, '', 'TASIKMALAYA', 'JAWA BARAT', 'giriland-sukagalih-hual', 'Ya', NULL, '2025-10-11 03:41:58', NULL, '2025-10-11 03:41:58', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(329, 'IPL-BQAZDU', 'FruitVille Relife Greenville', NULL, '', '', NULL, NULL, 'supriansyah@uhamka.ac.id', 'Jl. Raya Setu Km. 4 Rt.004 Rw 010, Cikarageman, K3c Setu Bekasi', NULL, '', 'KAB BEKASI', 'JAWA BARAT', 'fruitville-relife-greenville-ya6p', 'Ya', NULL, '2025-10-12 01:48:03', NULL, '2025-10-12 01:48:03', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(330, 'IPL-PTGTPX', 'Relife Greenville Kluster FruitVille / RW 010/RT 004', NULL, '', '', NULL, NULL, 'bungsu030883@gmail.com', 'Jl. Raya Setu Km 4, Relife Greenville Kluster Fruitville Blok D16 Rt. 004/010, Cikarageman, Setu', NULL, '', 'BEKASI', 'JAWA BARAT', 'relife-greenville-kluster-fruitville-rw-010rt-004-f7jm', 'Ya', NULL, '2025-10-12 03:14:51', NULL, '2025-10-12 03:14:51', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(331, 'IPL-VBNJOK', 'Grand madani residance 3', NULL, '', '', NULL, NULL, 'marcusiskandar@gmail.com', 'Kp. Guha Pabuaran Desa Lembang sari kec. Rajeg Kab. Tangerang', NULL, '', 'TANGERANG', 'BANTEN', 'grand-madani-residance-3-royi', 'Ya', NULL, '2025-10-18 17:54:53', NULL, '2025-10-18 17:54:53', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(332, 'IPL-FUWHUI', 'pesona prima 8 banjaran', NULL, '', '', NULL, NULL, 'arieffahrizal14@gmail.com', 'Pesona Prima 8 Banjaran, Jl. Pahlawan No.62, Kiangroke, Kec. Banjaran, Kabupaten Bandung, Jawa Barat 40377', NULL, '', 'BANDUNG', 'JAWA BARAT', 'pesona-prima-8-banjaran-cfz6', 'Ya', NULL, '2025-10-24 16:32:08', NULL, '2025-10-24 16:32:08', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(333, 'IPL-RPBDLQ', 'Kampung Babakan Khoer RT 02 RW 13 Bojongsawah', NULL, '', '', NULL, NULL, 'duniakaka081414@gmail.. com', 'Kampung Babakan Khoer RT 02 RW 13 Bojongsawah Kebonpedes Sukabumi', NULL, '', 'SUKABUMI', 'JAWA BARAT', 'kampung-babakan-khoer-rt-02-rw-13-bojongsawah-tqq8', 'Ya', NULL, '2025-10-31 23:11:40', NULL, '2025-10-31 23:11:40', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(334, 'IPL-PJFOIT', 'Kampung Babakan Khoer RT 02 RW 13 Bojongsawah', NULL, '', '', NULL, NULL, 'duniakaka081414@gmail.com', 'Kampung Babakan Khoer RT 02 RW 13 Bojongsawah Kebonpedes Sukabumi', NULL, '', 'SUKABUMI', 'JAWA BARAT', 'kampung-babakan-khoer-rt-02-rw-13-bojongsawah-pm45', 'Ya', NULL, '2025-10-31 23:12:07', NULL, '2025-10-31 23:12:07', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(335, 'IPL-VEIJPO', 'La Palma Grande RT 05/ RW 09', NULL, '', '', NULL, NULL, 'pratamacf@gmail.com', 'Jl. Raya Letjen R. Suprapto No.12, Cijengkol, Kec. Setu, Kabupaten Bekasi, Jawa Barat 17320', NULL, '', 'BEKASI', 'JAWA BARAT', 'la-palma-grande-rt-05-rw-09-qdkp', 'Ya', NULL, '2025-11-01 03:44:36', NULL, '2025-11-01 03:44:36', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(336, 'IPL-ZOUACH', 'RT 02 RW 10 kelurahan sindangrasa', NULL, '', '', NULL, NULL, 'nank412ro@gmail.com', 'kp muara rt 02 rw 10 kelurahan sindangrasa kec bogor timur', NULL, '', 'BOGOR', 'JAWA BARAT', 'rt-02-rw-10-kelurahan-sindangrasa-jdfs', 'Ya', NULL, '2025-11-01 09:05:36', NULL, '2025-11-01 09:05:36', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(337, 'IPL-KPWHRJ', 'Buah Batu Square', NULL, '', '', NULL, NULL, 'developerbuahbatusquare@gmail.com', 'Bojongsoang Raya', NULL, '', 'KABUPATEN BANDUNG', 'JAWA BARAT', 'buah-batu-square-ncdk', 'Ya', NULL, '2025-11-04 08:40:52', NULL, '2025-11-04 08:40:52', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(338, 'IPL-DVRPHC', 'kepuren residence / 05 / 025', NULL, '', '', NULL, NULL, 'pantat14@gmail.com', 'R', NULL, '', 'SERANG', 'BANTEN', 'kepuren-residence-05-025-mpt5', 'Ya', NULL, '2025-11-14 09:36:51', NULL, '2025-11-14 09:36:51', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(339, 'IPL-CEQCTQ', 'kepuren residence / 05 / 025', NULL, '', '', NULL, NULL, 'pantat14@gmail.com', 'R', NULL, '', 'SERANG', 'BANTEN', 'kepuren-residence-05-025-wbvd', 'Ya', NULL, '2025-11-14 09:36:51', NULL, '2025-11-14 09:36:51', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(340, 'IPL-ULQOQH', 'kepuren residence / 05 / 025', NULL, '', '', NULL, NULL, 'pantat14@gmail.com', 'R', NULL, '', 'SERANG', 'BANTEN', 'kepuren-residence-05-025-jsmo', 'Ya', NULL, '2025-11-14 09:36:51', NULL, '2025-11-14 09:36:51', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(341, 'IPL-RGZSQH', 'kepuren residence / 05 / 025', NULL, '', '', NULL, NULL, 'pantat14@gmail.com', 'R', NULL, '', 'SERANG', 'BANTEN', 'kepuren-residence-05-025-1y-y', 'Ya', NULL, '2025-11-14 09:36:51', NULL, '2025-11-14 09:36:51', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(342, 'IPL-VJNHWL', 'kepuren residence / 05 / 025', NULL, '', '', NULL, NULL, 'pantat14@gmail.com', 'R', NULL, '', 'SERANG', 'BANTEN', 'kepuren-residence-05-025-smkd', 'Ya', NULL, '2025-11-14 09:36:51', NULL, '2025-11-14 09:36:51', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(343, 'IPL-RYMLQN', 'kepuren residence / 05 / 025', NULL, '', '', NULL, NULL, 'pantat14@gmail.com', 'R', NULL, '', 'SERANG', 'BANTEN', 'kepuren-residence-05-025-omwi', 'Ya', NULL, '2025-11-14 09:36:51', NULL, '2025-11-14 09:36:51', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(344, 'IPL-ZDXHJH', 'kepuren residence / 05 / 025', NULL, '', '', NULL, NULL, 'pantat14@gmail.com', 'R', NULL, '', 'SERANG', 'BANTEN', 'kepuren-residence-05-025-qlvu', 'Ya', NULL, '2025-11-14 09:36:51', NULL, '2025-11-14 09:36:51', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(345, 'IPL-QCPPIT', 'kepuren residence / 05 / 025', NULL, '', '', NULL, NULL, 'pantat14@gmail.com', 'R', NULL, '', 'SERANG', 'BANTEN', 'kepuren-residence-05-025-wm18', 'Ya', NULL, '2025-11-14 09:36:51', NULL, '2025-11-14 09:36:51', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(346, 'IPL-HNQQYF', 'kepuren residence / 05 / 025', NULL, '', '', NULL, NULL, 'pantat14@gmail.com', 'R', NULL, '', 'SERANG', 'BANTEN', 'kepuren-residence-05-025-naq4', 'Ya', NULL, '2025-11-14 09:36:51', NULL, '2025-11-14 09:36:51', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(347, 'IPL-VGHVUU', 'kepuren residence / 05 / 025', NULL, '', '', NULL, NULL, 'pantat14@gmail.com', 'R', NULL, '', 'SERANG', 'BANTEN', 'kepuren-residence-05-025-uzya', 'Ya', NULL, '2025-11-14 09:36:51', NULL, '2025-11-14 09:36:51', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(348, 'IPL-VGBFXZ', 'kepuren residence / 05 / 025', NULL, '', '', NULL, NULL, 'pantat14@gmail.com', 'R', NULL, '', 'SERANG', 'BANTEN', 'kepuren-residence-05-025-9dbv', 'Ya', NULL, '2025-11-14 09:36:51', NULL, '2025-11-14 09:36:51', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(349, 'IPL-RPVFFB', 'kepuren residence / 05 / 025', NULL, '', '', NULL, NULL, 'pantat14@gmail.com', 'R', NULL, '', 'SERANG', 'BANTEN', 'kepuren-residence-05-025-8ph1', 'Ya', NULL, '2025-11-14 09:36:51', NULL, '2025-11-14 09:36:51', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(350, 'IPL-COXDCD', 'kepuren residence / 05 / 025', NULL, '', '', NULL, NULL, 'pantat14@gmail.com', 'R', NULL, '', 'SERANG', 'BANTEN', 'kepuren-residence-05-025-yqtu', 'Ya', NULL, '2025-11-14 09:36:51', NULL, '2025-11-14 09:36:51', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(351, 'IPL-PRGQYP', 'kepuren residence / 05 / 025', NULL, '', '', NULL, NULL, 'pantat14@gmail.com', 'R', NULL, '', 'SERANG', 'BANTEN', 'kepuren-residence-05-025-ciik', 'Ya', NULL, '2025-11-14 09:36:51', NULL, '2025-11-14 09:36:51', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL);
INSERT INTO `m_cluster` (`iId`, `idCluster`, `vNama`, `vIPL`, `noSK`, `vLogo`, `vImage`, `vTelp`, `vEmail`, `vAlamat`, `vLokasi`, `vMisiVisi`, `vKota`, `vProvinsi`, `slug`, `eDeleted`, `iCreatedid`, `tCreated`, `iUpdatedid`, `tUpdated`, `prefix`, `panjang_nomor`, `reset_tipe`, `nomor_terakhir`, `auto_print`, `format_id`, `print_id`, `pdf_id`) VALUES
(352, 'IPL-UVCSBX', 'kepuren residence / 05 / 025', NULL, '', '', NULL, NULL, 'pantat14@gmail.com', 'R', NULL, '', 'SERANG', 'BANTEN', 'kepuren-residence-05-025-mun6', 'Ya', NULL, '2025-11-14 09:36:51', NULL, '2025-11-14 09:36:51', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(353, 'IPL-KUQXOB', 'Perumahan Pinus 3 Cluster Garuda/ RT 05/ RW 03', NULL, '', '', NULL, NULL, 'rizalmutaqin.sip.me@gmail.com', 'Perumahan Pinus 3 Blok A17 ', NULL, '', 'BOGOR', 'JAWA BARAT ', 'perumahan-pinus-3-cluster-garuda-rt-05-rw-03-ivbk', 'Ya', NULL, '2025-11-16 12:56:02', NULL, '2025-11-16 12:56:02', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(354, 'IPL-ZXEQUY', 'banjaran indah ', NULL, '', '', NULL, NULL, 'ninoscremous@gmail.com', 'jl.raya banjaran', NULL, '', 'KABUPATEN BANDUNG', 'JAWA BARAT', 'banjaran-indah-of3a', 'Ya', NULL, '2025-11-18 05:05:24', NULL, '2025-11-18 05:05:24', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(355, 'IPL-HHSJTU', 'cluster sukamantri residence RT01 RW19', NULL, '', '', NULL, NULL, 'alkindocctv@gmail.com', 'desa sukamantri kecamatan psarkemis kabupaten tangerang', NULL, '', 'KABUPATEN TANGERANG', 'BANTEN', 'cluster-sukamantri-residence-rt01-rw19-sa8k', 'Ya', NULL, '2025-11-19 02:14:26', NULL, '2025-11-19 02:14:26', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(356, 'IPL-AOTRNO', 'perum alam jaya asri 05/01', NULL, '', '', NULL, NULL, 'arimbicell9@gmail.com', 'desa gandasari kec kasokandel kab Majalengka RT/RW 01/05', NULL, '', 'MAJALENGKA', 'JAWABARAT', 'perum-alam-jaya-asri-0501-2geh', 'Ya', NULL, '2025-11-27 14:30:33', NULL, '2025-11-27 14:30:33', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(357, 'IPL-EZFUND', 'kesadaran 1 RW07/RT01', NULL, '', '', NULL, NULL, 'fhurhybakery@gmail.com', 'jl kesadaran 1 panaikang ', NULL, '', 'MAKASSAR', 'SULAWESI SELATAN', 'kesadaran-1-rw07rt01-6ldj', 'Ya', NULL, '2025-11-27 16:50:29', NULL, '2025-11-27 16:50:29', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(358, 'IPL-DICEEQ', 'Citra Swarna Riverside', NULL, '', '', NULL, NULL, 'firmanroby07@gmail.com', 'Jl. Raya Bojong Klapanunggal, Bojong, Kec. Klapanunggal, Kabupaten Bogor, Jawa Barat 16710', NULL, '', '16710', 'JAWA BARAT', 'citra-swarna-riverside-r7eq', 'Ya', NULL, '2025-11-30 08:03:30', NULL, '2025-11-30 08:03:30', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(359, 'IPL-SOQUSR', 'Jatrec (Jatisawit residance)', NULL, '', '', NULL, NULL, 'aurora9268@gmail.com', 'Muncang rt/rw 006/008 gang mawar jatisawit bumiayu', NULL, '', 'BREBES', 'JAWA TENGAH', 'jatrec-jatisawit-residance-wh2y', 'Ya', NULL, '2025-12-06 12:23:05', NULL, '2025-12-06 12:23:05', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(360, 'IPL-NCZECE', 'De Griya/13/25', NULL, '', '', NULL, NULL, 'ranggadahahsona@gmail.com', 'Perum De Griya Desa Cibalongsari Kecamatan Klari Kabupaten Karawang', NULL, '', 'KARAWANG', 'JAWA BARAT', 'de-griya1325-qc1p', 'Ya', NULL, '2025-12-07 14:19:38', NULL, '2025-12-07 14:19:38', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(361, 'IPL-REEWRJ', 'KEPUREN RESIDENCD', NULL, '', '', NULL, NULL, 'wandyadg08@gmail.com', 'serang Banten\n', NULL, '', 'SERANG', 'BANTEN ', 'kepuren-residencd-3dax', 'Ya', NULL, '2025-12-13 06:19:35', NULL, '2025-12-13 06:19:35', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(362, 'IPL-BJXXFY', 'Puri Tenjo D2/10', NULL, '', '', NULL, NULL, 'egirisma.009@gmail.com', 'Puri Tenjo', NULL, '', 'BOGOR', 'BOGOR', 'puri-tenjo-d210-2zsr', 'Ya', NULL, '2025-12-14 06:59:39', NULL, '2025-12-14 06:59:39', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(363, 'IPL-MWIIHZ', 'perumahan papanmas RT01 RW07 Mangun jaya tambun Selatan Bekasi ', NULL, '', '', NULL, NULL, 'kondeindra21@gmail.com', 'perumahan papanmas blok C3 no 18 RT01/ RW07 desa Mangun jaya kecamatan tambun selatan', NULL, '', 'KABUPATEN BEKASI', 'JAWA BARAT', 'perumahan-papanmas-rt01-rw07-mangun-jaya-tambun-selatan-bekasi-woom', 'Ya', NULL, '2025-12-22 17:32:59', NULL, '2025-12-22 17:32:59', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(364, 'IPL-PJXKXR', 'Manunggal 12 02', NULL, '', '', NULL, NULL, 'rtbanjarsari02@gmail.com', 'jalan manunggal 2', NULL, '', 'SURAKARTA ', 'JAWA TENGAH ', 'manunggal-12-02-llcq', 'Ya', NULL, '2025-12-28 14:57:43', NULL, '2025-12-28 14:57:43', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(365, 'IPL-DHUXKN', 'Manunggal RW 12 RT 02 ', NULL, '', '', NULL, NULL, 'herupwnto@gmail.com', 'jalan manunggal 2 ', NULL, '', 'SURAKARTA ', 'JAWA TENGAH ', 'manunggal-rw-12-rt-02-g-1v', 'Ya', NULL, '2026-01-01 11:02:37', NULL, '2026-01-01 11:02:37', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(366, 'IPL-KXWVDV', 'Villa Gading Parung', NULL, '', '', NULL, NULL, '3mitraautoaccessories@gmail.com', 'jl. Gading Utama Blok G No. 1 desa Rt. 001/005 Desa pamegarsari kec. parung kab. bogor ', NULL, '', 'BOGOR', 'JAWA BARAT', 'villa-gading-parung-uhlk', 'Ya', NULL, '2026-01-02 16:56:46', NULL, '2026-01-02 16:56:46', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(367, 'IPL-XNBVLS', 'Pabuaran indah RT01 RW05', NULL, '', '', NULL, NULL, 'Pabuaranindahrt01rw05@gmail.com', 'jl angrek 2 blok a3 no7', NULL, '', 'KAB.BOGOR', 'JAWA BARAT', 'pabuaran-indah-rt01-rw05-lg84', 'Ya', NULL, '2026-01-05 17:01:06', NULL, '2026-01-05 17:01:06', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(368, 'IPL-XYBITS', 'Perumahan Griya Setiabudi Pebatan Brebes', NULL, '', '', NULL, NULL, 'fisikawanunnes@gmail.com', 'Jl. Raya Wanasari - Klampok, RT 1/ RW 5,  Pebatan, Wanasari', NULL, '', 'BREBES', 'JAWA TENGAH', 'perumahan-griya-setiabudi-pebatan-brebes-srjj', 'Ya', NULL, '2026-01-10 00:37:12', NULL, '2026-01-10 00:37:12', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(369, 'IPL-BSSZGX', 'RT 07/RW 01 ', NULL, '', '', NULL, NULL, 'budiutoyo91@gmail.com', 'Jomblang perbalan RT 07 RW 01 CANDI CANDISARI ', NULL, '', 'KOTA SEMARANG ', 'JAWA TENGAH ', 'rt-07rw-01-sqnr', 'Ya', NULL, '2026-01-10 01:06:20', NULL, '2026-01-10 01:06:20', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(370, 'IPL-PWYNLS', 'Bahtera Residance 1', NULL, '', '', NULL, NULL, 'd.dracko87@gmail.com', 'Perum Bahtera Residance 1 Blok D12 RT/RW 04/15 Jalan bukit Pesanggrahan indah 2, Ragajaya, Bojong Gede, Bogor', NULL, '', 'BOGOR', 'JAWA BARAT', 'bahtera-residance-1-i9o', 'Ya', NULL, '2026-01-14 08:24:57', NULL, '2026-01-14 08:24:57', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(371, 'IPL-PWNDNQ', 'Warga Rukun Tetangga 01 Cipinang', NULL, '', '', NULL, NULL, 'bendahara1@gmail.com', 'Jl. Bajubang ', NULL, '', 'JAKARTA TIMUR', 'JAKARTA', 'warga-rukun-tetangga-01-cipinang-1hmr', 'Ya', NULL, '2026-01-14 13:50:26', NULL, '2026-01-14 13:50:26', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(372, 'IPL-XJRLSN', 'Warga RT 01 Cipinang', NULL, '', '', NULL, NULL, 'pengurusbendahara1@gmail.com', 'Jl. Bajubang', NULL, '', 'JAKARTA TIMUR', 'JAKARTA', 'warga-rt-01-cipinang-jv1n', 'Ya', NULL, '2026-01-14 13:51:58', NULL, '2026-01-14 13:51:58', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(373, 'IPL-VKERNW', 'VILLAMAS POLEWALI MANDAR / RT.11', NULL, '', '', NULL, NULL, 'villamaspolewalimandar@gmail.com', 'Jl. Andi Latanratu - Takatidung', NULL, '', 'POLEWALI MANDAR', 'SULAWESI BARAT', 'villamas-polewali-mandar-rt11-pcoo', 'Ya', NULL, '2026-01-20 17:49:44', NULL, '2026-01-20 17:49:44', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(374, 'IPL-WUKSZH', 'Griya Testing', 100000, '1215555545 Bank OK', '', NULL, NULL, 'bendahara@email.com', 'Jl. Pajajaran No 171 ', 'https://maps.app.goo.gl/VYiXm8dhWkauFXx5A', '2', 'BOGOR', 'JAWA BARAT ', 'griya-testing-neza', 'Tidak', NULL, '2022-01-23 02:43:35', NULL, '2026-01-22 03:44:34', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(375, 'IPL-JUJEXH', 'Griya Permata Citayam ', NULL, '', '', NULL, NULL, 'anak.sarerea@gmail.comE', 'Jl. Citayam', NULL, '', 'BOGOR', 'JAWA BARAT', 'griya-permata-citayam-hc-b', 'Ya', NULL, '2026-01-26 09:17:07', NULL, '2026-01-26 09:17:07', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(376, 'IPL-CIDYDZ', 'Griya Permata Citayam ', NULL, '', '', NULL, NULL, 'anak.sarerea@emal.com', 'Jl. Citayam', NULL, '', 'BOGOR', 'JAWA BARAT', 'griya-permata-citayam-ss', 'Tidak', NULL, '2026-01-26 09:23:20', NULL, '2026-01-26 09:17:34', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(377, 'IPL-CLABEX', 'Griya Testing Citayam  2', 1000001, '1215555545 Bank JANGKRIK', '', NULL, NULL, 'ciomas_1905@yahoo.co.id', 'Jln. Citayam ', '', '3', 'BOGOR ', 'JAWA BARAT ', 'griya-testing-citayam-caht', 'Tidak', NULL, '2026-03-18 08:46:45', NULL, '2026-01-27 01:41:59', 'ICM', 4, 'tahunan', 34, 'Tidak', 1, 5, 6),
(378, 'IPL-KKBPYP', 'Cikago ', NULL, '', '', NULL, NULL, 'anak.sararea@gmail.com', 'Jl. ciomas', NULL, '', 'BOCOR', 'JADI BESOK', 'cikago-jjd9', 'Tidak', NULL, '2026-01-27 03:50:26', NULL, '2026-01-27 03:46:33', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL),
(379, 'IPL-OTTPMM', 'Rumah Icam Opan', NULL, '', '', NULL, NULL, 'icamgocamcam@gmail.com', 'Jl. Portugis', NULL, '', 'SRAGEN', 'JAWA TENGAH', 'rumah-icam-opan-f1pv', 'Tidak', NULL, '2026-01-27 14:08:20', NULL, '2026-01-27 14:01:04', 'INV', 4, 'bulanan', 0, 'Tidak', NULL, NULL, NULL);

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

--
-- Table structure for table `m_kalender`
--

CREATE TABLE `m_kalender` (
  `iId` int(11) NOT NULL,
  `vTahun` int(50) DEFAULT NULL,
  `vBulan` int(11) DEFAULT NULL,
  `dCreated` datetime DEFAULT NULL,
  `dUpdated` datetime DEFAULT NULL,
  `eTipe` enum('Internal','External') DEFAULT 'External',
  `vKeterangan` varchar(255) DEFAULT NULL,
  `vImage` varchar(50) DEFAULT NULL,
  `eDeleted` enum('Ya','Tidak') DEFAULT 'Tidak',
  `eStatus` enum('AKTIF','TIDAK') NOT NULL DEFAULT 'AKTIF'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `m_kalender`
--

INSERT INTO `m_kalender` (`iId`, `vTahun`, `vBulan`, `dCreated`, `dUpdated`, `eTipe`, `vKeterangan`, `vImage`, `eDeleted`, `eStatus`) VALUES
(1, 2021, 1, NULL, NULL, 'External', 'JANUARI', '1x.jpg', 'Tidak', 'AKTIF'),
(2, 2021, 2, NULL, NULL, 'External', 'FEBRUARI', '2x.jpg', 'Tidak', 'AKTIF'),
(3, 2021, 3, NULL, NULL, 'External', 'MARET', '3x.jpg', 'Tidak', 'AKTIF'),
(4, NULL, 4, NULL, NULL, 'External', 'APRIL', '4x.jpg', 'Tidak', 'AKTIF'),
(5, NULL, 5, NULL, NULL, 'External', 'MEI', '5x.jpg', 'Tidak', 'AKTIF'),
(6, NULL, 6, NULL, NULL, 'External', 'JUNI', '6x.jpg', 'Tidak', 'AKTIF'),
(7, NULL, 7, NULL, NULL, 'External', 'JULI', '7x.jpg', 'Tidak', 'AKTIF'),
(8, NULL, 8, NULL, NULL, 'External', 'AGUSTUS', '8x.jpg', 'Tidak', 'AKTIF'),
(9, NULL, 9, NULL, NULL, 'External', 'SEPTEMBER', '9x.jpg', 'Tidak', 'AKTIF'),
(10, NULL, 10, NULL, NULL, 'External', 'OKTOBER', '10x.jpg', 'Tidak', 'AKTIF'),
(11, NULL, 11, NULL, NULL, 'External', 'NOVEMBER', '11x.jpg', 'Tidak', 'AKTIF'),
(12, NULL, 12, NULL, NULL, 'External', 'DESEMBER', '12x.jpg', 'Tidak', 'AKTIF');

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

--
-- Table structure for table `m_metodepembayaran`
--

CREATE TABLE `m_metodepembayaran` (
  `iId` int(11) NOT NULL,
  `vNama` varchar(100) NOT NULL,
  `iCabangid` int(11) DEFAULT NULL,
  `cabang` varchar(20) DEFAULT NULL,
  `eDeleted` enum('Ya','Tidak') DEFAULT 'Tidak',
  `iCreatedid` int(11) DEFAULT NULL,
  `tCreated` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `tUpdated` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `iUpdatedid` int(11) DEFAULT NULL,
  `iKategoriPayment` varchar(100) DEFAULT NULL,
  `iKasir` int(11) DEFAULT '0' COMMENT 'untuk mengidentifikasi metode pembayaran yg bisa dilakukan di SO Kasir',
  `iExpHours` int(11) DEFAULT NULL COMMENT 'untuk expired pembayaran. satuannya menggunakan jam. 0 = tidak ada due date'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `m_metodepembayaran`
--

INSERT INTO `m_metodepembayaran` (`iId`, `vNama`, `iCabangid`, `cabang`, `eDeleted`, `iCreatedid`, `tCreated`, `tUpdated`, `iUpdatedid`, `iKategoriPayment`, `iKasir`, `iExpHours`) VALUES
(1, 'COD', 1, '1#2#3#4#6#7#10#11', 'Tidak', 49, '2021-02-02 15:44:39', '2025-08-10 11:26:40', 8, '4', 0, NULL),
(2, 'TRANSFER BCA', NULL, '1#2#3#4#6#7#10#11', 'Tidak', 49, '2021-03-08 11:04:24', '2025-06-09 06:35:32', 8, '3', 1, NULL),
(3, 'DEBIT BCA', NULL, '1#2#3#4#6#7#10#11', 'Tidak', 49, '2021-03-08 11:04:41', '2025-06-09 06:35:47', 8, NULL, 1, NULL),
(4, 'CC', NULL, '1#2#3#6#10', 'Tidak', 49, '2021-03-08 11:04:57', '2022-06-15 15:27:30', 8, NULL, 0, NULL),
(5, 'BCA Virtual Account', NULL, '1#2#3#6#10', 'Tidak', 49, '2021-03-08 11:05:13', '2025-11-13 12:33:03', 8, '2', 0, NULL),
(6, 'GOPAY', NULL, '1#2#3#6#10', 'Tidak', 49, '2021-03-08 11:05:27', '2025-06-09 06:35:51', 8, '1', 1, NULL),
(7, 'DOMPET', 1, '1#2#3#6#10', 'Tidak', 49, '2023-10-09 15:06:46', '2023-10-13 15:22:25', 8, NULL, 0, NULL),
(8, 'BAYAR DI OUTLET', NULL, '1#2#3#6#10', 'Tidak', 49, '2023-10-13 11:25:45', '2024-12-05 08:27:58', 8, '4', 0, NULL),
(9, 'TRANSFER MANDIRI', NULL, '1#2', 'Tidak', 49, '2023-10-13 11:26:01', '2024-12-27 07:49:31', 8, '3', 0, NULL),
(10, 'POIN', NULL, '1#2#3#6#10', 'Tidak', 49, '2023-10-13 11:26:01', '2024-10-28 06:09:51', 8, NULL, 0, NULL),
(11, 'DANA', NULL, '1#2#3#6#10', 'Tidak', 49, '2023-10-13 11:26:01', '2024-10-28 06:09:51', 8, '1', 0, NULL),
(12, 'ShopeePay', NULL, '1#2#3#6#10', 'Tidak', 49, '2023-10-13 11:26:01', '2024-10-28 06:09:51', 8, '1', 0, NULL),
(13, 'Shopee PayLetter', NULL, '1#2#6#7#8#16', 'Tidak', 49, '2025-02-11 01:55:10', '2025-08-10 11:25:34', 195, NULL, 0, NULL),
(14, 'TUNAI', NULL, '1#2#3#6#10', 'Tidak', 195, '2025-08-10 11:24:49', '2025-08-10 11:26:11', 195, NULL, 1, NULL);

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

--
-- Table structure for table `m_pembayaran`
--

CREATE TABLE `m_pembayaran` (
  `iId` int(11) NOT NULL,
  `idMember` int(50) DEFAULT NULL,
  `idCluster` char(50) DEFAULT NULL,
  `vNama` varchar(50) DEFAULT NULL,
  `vBank` varchar(50) DEFAULT NULL,
  `vNoRek` int(100) DEFAULT NULL,
  `vNilai` int(100) DEFAULT NULL,
  `jumlah_bulan` int(50) NOT NULL,
  `vImage` varchar(100) DEFAULT NULL,
  `vKode` char(50) DEFAULT NULL,
  `dateStart` datetime DEFAULT NULL,
  `dateFinish` datetime DEFAULT NULL,
  `vKeterangan` text NOT NULL,
  `eDeleted` enum('Ya','Tidak') DEFAULT 'Tidak',
  `eStatus` enum('PEMBAYARAN DITERIMA','PROSES','VERIFIKASI','GRATIS') NOT NULL DEFAULT 'PROSES',
  `tCreated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `tUpdated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `m_pembayaran`
--

INSERT INTO `m_pembayaran` (`iId`, `idMember`, `idCluster`, `vNama`, `vBank`, `vNoRek`, `vNilai`, `jumlah_bulan`, `vImage`, `vKode`, `dateStart`, `dateFinish`, `vKeterangan`, `eDeleted`, `eStatus`, `tCreated`, `tUpdated`) VALUES
(1, 222, 'IPL-SC2', 'noe', 'bca', NULL, NULL, 0, 'BULAN-1637229748222.png', 'INV-20260123-0003', '2021-11-18 17:02:28', '2030-11-15 17:02:28', '', 'Tidak', 'PEMBAYARAN DITERIMA', '2026-01-23 03:45:48', '0000-00-00 00:00:00'),
(5, 463, 'IPL-WUKSZH', 'NU', 'BSI1', 21212121, 65000, 1, NULL, 'INV-20260123-0001', '2026-01-23 11:30:24', '2026-02-23 11:30:24', '', 'Ya', 'VERIFIKASI', '2026-01-23 04:30:24', '2026-01-23 07:09:53'),
(6, 463, 'IPL-WUKSZH', NULL, NULL, NULL, NULL, 6, NULL, 'INV-20260123-0002', '2026-01-01 14:13:41', '2026-01-01 14:13:41', '', 'Tidak', 'GRATIS', '2026-01-23 07:13:41', '0000-00-00 00:00:00'),
(7, 463, 'IPL-WUKSZH', NULL, NULL, NULL, 65000, 1, NULL, 'INV-20260123-0003', '2026-01-23 15:10:36', '2026-02-23 15:10:36', '', 'Ya', 'PROSES', '2026-01-23 08:10:36', '0000-00-00 00:00:00'),
(8, 463, 'IPL-WUKSZH', 'Geri', 'BSI1', 21212121, 65000, 1, NULL, 'INV-IPL-WUKSZH-20260123-0001', '2026-01-23 16:15:48', '2026-01-25 16:15:48', '', 'Tidak', 'PEMBAYARAN DITERIMA', '2026-01-23 08:39:41', '2026-01-23 08:46:20'),
(9, 463, 'IPL-WUKSZH', 'NU', 'BSI1', 21212121, 65000, 1, NULL, 'INV-IPL-WUKSZH-2026-02', '2026-01-24 11:19:55', '2026-01-25 11:19:55', '', 'Tidak', 'PEMBAYARAN DITERIMA', '2026-01-26 03:33:29', '2026-01-26 04:12:56'),
(10, 463, 'IPL-WUKSZH', 'Geri', 'BSI1', 21212121, 65000, 1, NULL, 'INV-IPL-WUKSZH-2026-03', '2026-01-26 11:49:52', '2026-02-19 11:49:52', '', 'Tidak', 'PEMBAYARAN DITERIMA', '2026-01-26 04:48:21', '2026-01-26 04:49:35'),
(15, 256, 'IPL-CLABEX', NULL, NULL, NULL, 195000, 3, NULL, 'INV-IPL-KKBPYP-2026-01', '2026-01-06 10:48:46', '2026-01-26 10:48:46', '', 'Tidak', 'GRATIS', '2026-01-27 03:48:46', '0000-00-00 00:00:00'),
(16, 481, 'IPL-CLABEX', 'NU', 'BSI1', 21212121, 65000, 1, NULL, 'INV-377202601', '2026-01-27 16:27:21', '2026-02-02 16:27:21', '', 'Tidak', 'PEMBAYARAN DITERIMA', '2026-01-27 09:23:08', '2026-01-27 09:26:58'),
(17, 256, 'IPL-OTTPMM', NULL, NULL, NULL, 195000, 3, NULL, 'INV-IPL-OTTPMM-2026-01', '2026-01-27 21:08:11', '2026-04-27 21:08:11', '', 'Tidak', 'GRATIS', '2026-01-27 14:08:11', '0000-00-00 00:00:00'),
(18, 481, 'IPL-CLABEX', NULL, NULL, NULL, 65000, 1, NULL, 'INV-377202602', '2026-02-09 15:49:02', '2026-03-09 15:49:02', '', 'Tidak', 'PEMBAYARAN DITERIMA', '2026-02-09 08:49:03', '0000-00-00 00:00:00'),
(19, 482, 'IPL-CLABEX', 'NU', 'BSI1', 21212121, 65000, 1, NULL, 'INV-377202603', '2026-03-18 10:34:44', '2026-04-18 10:34:44', '', 'Tidak', 'PEMBAYARAN DITERIMA', '2026-03-18 03:30:20', '2026-03-18 03:33:16');

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

--
-- Table structure for table `m_ppn`
--

CREATE TABLE `m_ppn` (
  `iId` int(11) NOT NULL,
  `iPpn` int(11) NOT NULL,
  `payment_method_id` int(11) NOT NULL,
  `tCreated` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `tUpdated` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `tCreatedid` int(11) DEFAULT NULL,
  `tUpdatedid` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `m_ppn`
--

INSERT INTO `m_ppn` (`iId`, `iPpn`, `payment_method_id`, `tCreated`, `tUpdated`, `tCreatedid`, `tUpdatedid`) VALUES
(1, 11, 0, '2022-03-15 11:30:43', '2026-02-11 04:03:28', 8, 8);

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

--
-- Table structure for table `nota`
--

CREATE TABLE `nota` (
  `id` int(11) NOT NULL,
  `payment_method_id` int(11) NOT NULL DEFAULT '0',
  `nomor` varchar(50) DEFAULT NULL,
  `idCluster` varchar(50) DEFAULT NULL,
  `tanggal` date DEFAULT NULL,
  `pelanggan` varchar(150) DEFAULT NULL,
  `total` decimal(12,2) DEFAULT NULL,
  `grand_total` decimal(15,2) NOT NULL DEFAULT '0.00',
  `uang_diterima` decimal(15,2) DEFAULT '0.00',
  `kembalian` decimal(15,2) DEFAULT '0.00',
  `ppn` decimal(15,2) DEFAULT '0.00',
  `voucher_id` int(11) DEFAULT NULL,
  `voucher` decimal(12,2) DEFAULT '0.00',
  `diskon` decimal(12,2) DEFAULT '0.00',
  `eDeleted` enum('Ya','Tidak') NOT NULL DEFAULT 'Tidak',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `shift_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `nota`
--

INSERT INTO `nota` (`id`, `payment_method_id`, `nomor`, `idCluster`, `tanggal`, `pelanggan`, `total`, `grand_total`, `uang_diterima`, `kembalian`, `ppn`, `voucher_id`, `voucher`, `diskon`, `eDeleted`, `created_at`, `updated_at`, `shift_id`) VALUES
(3, 2, 'NT20260210113130', NULL, '2026-02-10', 'Aryan', '247500.00', '274725.00', '0.00', '0.00', '27225.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-12 23:14:59', '2026-02-12 23:14:59', NULL),
(4, 0, 'NT20260210122438', NULL, '2026-02-10', 'TU', '2500.00', '0.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-12 23:14:59', '2026-02-12 23:14:59', NULL),
(9, 0, 'NT20260210122938', NULL, '2026-02-10', 'Icam', '47500.00', '0.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-12 23:14:59', '2026-02-12 23:14:59', NULL),
(10, 0, 'NT20260210124141', NULL, '2026-02-10', 'Jak', '2500.00', '0.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-12 23:14:59', '2026-02-12 23:14:59', NULL),
(20, 0, 'NT20260211132825', NULL, '2026-02-11', 'rtrtr', '5000.00', '0.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-12 23:14:59', '2026-02-12 23:14:59', NULL),
(21, 0, 'NT20260211151016', NULL, '2026-02-11', 'Okbos', '310800.00', '0.00', '0.00', '0.00', '30800.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-12 23:14:59', '2026-02-12 23:14:59', NULL),
(22, 0, 'NT20260211154206', NULL, '2026-02-11', 'aa', '55300.00', '0.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-12 23:14:59', '2026-02-12 23:14:59', NULL),
(23, 0, 'NT20260211155417', NULL, '2026-02-11', 'Jin ', '1549893.00', '0.00', '0.00', '0.00', '153593.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-12 23:14:59', '2026-02-12 23:14:59', NULL),
(24, 2, 'NT20260211233455', NULL, '2026-02-11', '', NULL, '0.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-12 23:14:59', '2026-02-12 23:14:59', NULL),
(25, 4, 'NT20260211233534', NULL, '2026-02-11', '', NULL, '0.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-12 23:14:59', '2026-02-12 23:14:59', NULL),
(26, 3, 'NT20260211233556', NULL, '2026-02-11', '', NULL, '0.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-12 23:14:59', '2026-02-12 23:14:59', NULL),
(27, 6, 'NT20260211233656', NULL, '2026-02-11', '', NULL, '0.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-12 23:14:59', '2026-02-12 23:14:59', NULL),
(28, 2, 'NT20260211233928', NULL, '2026-02-11', '', '27750.00', '0.00', '0.00', '0.00', '2750.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-12 23:14:59', '2026-02-12 23:14:59', NULL),
(29, 2, 'NT20260212101333', NULL, '2026-02-12', 'Gery', '125000.00', '0.00', '0.00', '0.00', '8250.00', NULL, '50000.00', '0.00', 'Tidak', '2026-02-12 23:14:59', '2026-02-12 23:14:59', NULL),
(30, 5, 'NT20260212101851', NULL, '2026-02-12', 'Tuti', '72000.00', '0.00', '0.00', '0.00', '7920.00', NULL, NULL, '0.00', 'Tidak', '2026-02-12 23:14:59', '2026-02-12 23:14:59', NULL),
(31, 5, 'NT20260212102432', NULL, '2026-02-12', 'OKK', '63000.00', '63000.00', '0.00', '0.00', '0.00', NULL, NULL, '0.00', 'Tidak', '2026-02-12 23:14:59', '2026-02-12 23:14:59', NULL),
(32, 2, 'NT20260212211746', NULL, '2026-02-12', 'RERE', '500000.00', '450000.00', '0.00', '0.00', '0.00', NULL, '10.00', '0.00', 'Tidak', '2026-02-12 23:14:59', '2026-02-12 23:14:59', NULL),
(33, 3, 'NT20260212214058', NULL, '2026-02-12', '', '50000.00', '0.00', '0.00', '0.00', '0.00', 1, '50000.00', '0.00', 'Tidak', '2026-02-12 23:14:59', '2026-02-12 23:14:59', NULL),
(34, 1, 'NT20260212222749', 'IPL-SC2', '2026-02-12', 'Noe', '50000.00', '50000.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-12 23:14:59', '2026-02-13 16:09:03', NULL),
(35, 1, 'NT20260212231239', NULL, '2026-02-12', '', '23000.00', '23000.00', '50000.00', '27000.00', '0.00', NULL, NULL, '0.00', 'Tidak', '2026-02-12 23:14:59', '2026-02-12 23:14:59', NULL),
(36, 1, 'NT20260212231707', NULL, '2026-02-12', 'User', '38000.00', '37962.00', '50000.00', '12038.00', '3762.00', 2, '10.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-12 23:17:07', NULL),
(37, 1, 'NT20260213103009', 'IPL-SC2', '2026-02-13', 'User', '228600.00', '253746.00', '270000.00', '16254.00', '25146.00', 2, '25400.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-13 16:08:49', NULL),
(38, 1, 'NT20260213105215', 'IPL-SC2', '2026-02-13', 'User', '150000.00', '111000.00', '120000.00', '9000.00', '11000.00', 1, '50000.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-13 16:08:47', NULL),
(39, 2, 'NT20260213145451', 'IPL-SC2', '2026-02-13', 'User', '20700.00', '20700.00', '0.00', '0.00', '0.00', 2, '2300.00', '0.00', 'Ya', '0000-00-00 00:00:00', '2026-02-13 16:20:58', NULL),
(40, 1, 'NT20260213151731', 'IPL-SC2', '2026-02-13', 'User', '35500.00', '39405.00', '50000.00', '10600.00', '3905.00', 1, '50000.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-13 16:08:45', NULL),
(42, 1, 'NT20260213162324', 'IPL-SC2', '2026-02-13', 'Tuti', '57500.00', '63825.00', '70000.00', '6200.00', '6325.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-13 16:23:24', NULL),
(43, 1, 'NT20260213164137', 'IPL-SC2', '2026-02-13', 'Wini', '61300.00', '61300.00', '65000.00', '3700.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-13 16:41:37', NULL),
(44, 2, NULL, NULL, '2026-02-13', 'User', '0.00', '0.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-13 17:25:51', '2026-02-13 17:25:51', NULL),
(45, 2, NULL, NULL, '2026-02-13', 'User', '0.00', '0.00', NULL, NULL, '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-13 17:25:54', '2026-02-13 17:25:54', NULL),
(46, 1, 'NT20260213234319', 'IPL-CLABEX', '2026-02-13', 'User', '75000.00', '83250.00', '90000.00', '6800.00', '8250.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-13 23:43:19', NULL),
(47, 2, 'NT20260214200009', 'IPL-CLABEX', '2026-02-14', 'iCAM', '275000.00', '305250.00', '0.00', '0.00', '30250.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-14 20:00:09', NULL),
(48, 1, 'INV/2026/02/0001', 'IPL-CLABEX', '2026-02-14', 'Opan', '120500.00', '133755.00', '150000.00', '16200.00', '13255.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-14 20:03:10', NULL),
(49, 5, NULL, NULL, '2026-02-14', 'Noe', '90000.00', '99900.00', '0.00', '0.00', '9900.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 20:24:24', '2026-02-14 20:24:24', NULL),
(50, 5, NULL, NULL, '2026-02-14', 'Noe', '90000.00', '99900.00', NULL, NULL, '9900.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 20:24:31', '2026-02-14 20:24:31', NULL),
(51, 5, NULL, NULL, '2026-02-14', 'Noe', '90000.00', '99900.00', NULL, NULL, '9900.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 20:24:38', '2026-02-14 20:24:38', NULL),
(52, 5, NULL, NULL, '2026-02-14', 'Noe', '90000.00', '99900.00', NULL, NULL, '9900.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 20:25:17', '2026-02-14 20:25:17', NULL),
(53, 5, NULL, NULL, '2026-02-14', 'Noe', '90000.00', '99900.00', NULL, NULL, '9900.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 20:25:20', '2026-02-14 20:25:20', NULL),
(54, 5, NULL, NULL, '2026-02-14', 'Noe', '90000.00', '99900.00', NULL, NULL, '9900.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 20:28:32', '2026-02-14 20:28:32', NULL),
(55, 5, NULL, NULL, '2026-02-14', 'Noe', '90000.00', '99900.00', NULL, NULL, '9900.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 20:28:35', '2026-02-14 20:28:35', NULL),
(56, 5, NULL, NULL, '2026-02-14', 'Noe', '90000.00', '99900.00', NULL, NULL, '9900.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 20:33:40', '2026-02-14 20:33:40', NULL),
(57, 5, NULL, NULL, '2026-02-14', 'Noe', '90000.00', '99900.00', NULL, NULL, '9900.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 20:33:44', '2026-02-14 20:33:44', NULL),
(58, 5, NULL, NULL, '2026-02-14', 'Noe', '90000.00', '99900.00', NULL, NULL, '9900.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 20:35:34', '2026-02-14 20:35:34', NULL),
(59, 5, 'INV/377/2026/02/0002', 'IPL-CLABEX', '2026-02-14', 'Noe', '90000.00', '99900.00', NULL, NULL, '9900.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-14 20:36:51', NULL),
(60, 2, 'TR/377/2026/02/0003', 'IPL-CLABEX', '2026-02-14', 'Noe', '49200.00', '49200.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-14 20:38:04', NULL),
(61, 6, 'TR/377/2026/02/0004', 'IPL-CLABEX', '2026-02-14', 'User', '49500.00', '49500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-14 20:40:24', NULL),
(62, 2, 'TR/377/2026/02/0005', 'IPL-CLABEX', '2026-02-14', 'User', '49500.00', '49500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-14 20:41:24', NULL),
(63, 2, NULL, NULL, '2026-02-14', 'User', '74000.00', '74000.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 20:42:06', '2026-02-14 20:42:06', NULL),
(64, 2, NULL, NULL, '2026-02-14', 'User', '74000.00', '74000.00', NULL, NULL, '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 20:43:06', '2026-02-14 20:43:06', NULL),
(65, 2, NULL, NULL, '2026-02-14', 'User', '74000.00', '74000.00', NULL, NULL, '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 20:47:49', '2026-02-14 20:47:49', NULL),
(66, 2, NULL, NULL, '2026-02-14', 'User', '74000.00', '74000.00', NULL, NULL, '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 20:48:51', '2026-02-14 20:48:51', NULL),
(67, 2, NULL, NULL, '2026-02-14', 'User', '74000.00', '74000.00', NULL, NULL, '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 20:49:39', '2026-02-14 20:49:39', NULL),
(68, 2, NULL, NULL, '2026-02-14', 'User', '74000.00', '74000.00', NULL, NULL, '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 20:49:41', '2026-02-14 20:49:41', NULL),
(69, 2, NULL, NULL, '2026-02-14', 'User', '74000.00', '74000.00', NULL, NULL, '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 20:49:44', '2026-02-14 20:49:44', NULL),
(70, 2, NULL, NULL, '2026-02-14', 'User', '74000.00', '74000.00', NULL, NULL, '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 20:50:11', '2026-02-14 20:50:11', NULL),
(71, 2, NULL, NULL, '2026-02-14', 'User', '74000.00', '74000.00', NULL, NULL, '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 20:50:41', '2026-02-14 20:50:41', NULL),
(72, 2, NULL, NULL, '2026-02-14', 'User', '74000.00', '74000.00', NULL, NULL, '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 20:51:51', '2026-02-14 20:51:51', NULL),
(73, 2, NULL, NULL, '2026-02-14', 'User', '74000.00', '74000.00', NULL, NULL, '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 20:53:29', '2026-02-14 20:53:29', NULL),
(74, 2, NULL, NULL, '2026-02-14', 'User', '74000.00', '74000.00', NULL, NULL, '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 20:53:54', '2026-02-14 20:53:54', NULL),
(75, 2, NULL, NULL, '2026-02-14', 'User', '74000.00', '74000.00', NULL, NULL, '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 20:54:12', '2026-02-14 20:54:12', NULL),
(76, 2, 'TR-202602-0006', 'IPL-CLABEX', '2026-02-14', 'User', '74000.00', '74000.00', NULL, NULL, '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-14 20:54:36', NULL),
(77, 2, 'ICM-202602-0007', 'IPL-CLABEX', '2026-02-14', 'User', '74000.00', '74000.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-14 22:23:36', NULL),
(78, 2, NULL, NULL, '2026-02-14', 'User', '49500.00', '49500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 22:28:26', '2026-02-14 22:28:26', NULL),
(79, 2, NULL, NULL, '2026-02-14', 'User', '49500.00', '49500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 22:28:48', '2026-02-14 22:28:48', NULL),
(80, 2, NULL, NULL, '2026-02-14', 'User', '49500.00', '49500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 22:29:02', '2026-02-14 22:29:02', NULL),
(81, 2, NULL, NULL, '2026-02-14', 'User', '49500.00', '49500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 22:29:52', '2026-02-14 22:29:52', NULL),
(82, 2, NULL, NULL, '2026-02-14', 'User', '49500.00', '49500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 22:30:06', '2026-02-14 22:30:06', NULL),
(83, 2, NULL, NULL, '2026-02-14', 'User', '49500.00', '49500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 22:30:09', '2026-02-14 22:30:09', NULL),
(84, 2, NULL, NULL, '2026-02-14', 'User', '49500.00', '49500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 22:30:23', '2026-02-14 22:30:23', NULL),
(85, 2, NULL, NULL, '2026-02-14', 'User', '49500.00', '49500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 22:30:32', '2026-02-14 22:30:32', NULL),
(86, 2, NULL, NULL, '2026-02-14', 'User', '49500.00', '49500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 22:30:36', '2026-02-14 22:30:36', NULL),
(87, 2, NULL, NULL, '2026-02-14', 'User', '49500.00', '49500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 22:31:49', '2026-02-14 22:31:49', NULL),
(88, 2, NULL, NULL, '2026-02-14', 'User', '49500.00', '49500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 22:31:53', '2026-02-14 22:31:53', NULL),
(89, 2, NULL, NULL, '2026-02-14', 'User', '49500.00', '49500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 22:32:30', '2026-02-14 22:32:30', NULL),
(90, 2, NULL, NULL, '2026-02-14', 'User', '49500.00', '49500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 22:34:25', '2026-02-14 22:34:25', NULL),
(91, 2, NULL, NULL, '2026-02-14', 'User', '49500.00', '49500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 22:35:06', '2026-02-14 22:35:06', NULL),
(92, 2, NULL, NULL, '2026-02-14', 'User', '49500.00', '49500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 22:59:10', '2026-02-14 22:59:10', NULL),
(93, 2, NULL, NULL, '2026-02-14', 'User', '49500.00', '49500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-14 23:23:48', '2026-02-14 23:23:48', NULL),
(94, 2, 'ICM-202602140008', 'IPL-CLABEX', '2026-02-14', 'User', '49500.00', '49500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-14 23:24:01', NULL),
(95, 2, 'ICM/2026/0009', 'IPL-CLABEX', '2026-02-15', 'User', '74000.00', '74000.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-15 07:15:21', NULL),
(96, 2, 'ICM/2026/0010', 'IPL-CLABEX', '2026-02-15', 'User', '74000.00', '74000.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-15 07:19:52', NULL),
(97, 2, 'ICM/2026/0011', 'IPL-CLABEX', '2026-02-15', 'User', '74000.00', '74000.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-15 07:20:39', NULL),
(98, 2, 'ICM/2026/0012', 'IPL-CLABEX', '2026-02-15', 'User', '74000.00', '74000.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-15 07:21:29', NULL),
(99, 6, 'ICM/2026/0013', 'IPL-CLABEX', '2026-02-15', 'User', '74000.00', '74000.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-15 07:21:51', NULL),
(100, 1, 'ICM/2026/0014', 'IPL-CLABEX', '2026-02-15', 'User', '49200.00', '49200.00', '50000.00', '800.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-15 07:26:02', NULL),
(101, 3, 'ICM/2026/0015', 'IPL-CLABEX', '2026-02-15', 'User', '49500.00', '54945.00', '0.00', '0.00', '5445.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-15 07:35:59', NULL),
(102, 4, 'ICM/2026/0016', 'IPL-CLABEX', '2026-02-15', 'User', '49500.00', '49500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-15 14:42:37', NULL),
(103, 1, 'ICM/2026/0017', 'IPL-CLABEX', '2026-01-15', 'User', '120500.00', '133755.00', '150000.00', '16200.00', '13255.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-17 21:48:22', NULL),
(104, 2, 'ICM/2026/0018', 'IPL-CLABEX', '2026-02-16', 'User', '120500.00', '133755.00', '0.00', '0.00', '13255.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-16 15:36:28', 2),
(105, 1, 'ICM/2026/0019', 'IPL-CLABEX', '2026-02-16', 'Opan', '90000.00', '90000.00', '100000.00', '10000.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-16 15:39:09', 2),
(106, 3, 'ICM/2026/0020', 'IPL-CLABEX', '2026-02-16', 'User', '25000.00', '25000.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-16 16:31:18', 3),
(107, 7, 'ICM/2026/0021', 'IPL-CLABEX', '2026-02-16', 'User', '139500.00', '139500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-16 16:55:41', 4),
(108, 2, NULL, NULL, '2026-02-16', 'User', '585000.00', '649350.00', '0.00', '0.00', '64350.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-16 23:17:06', '2026-02-16 23:17:06', 5),
(109, 2, NULL, NULL, '2026-02-16', 'User', '585000.00', '649350.00', '0.00', '0.00', '64350.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-16 23:17:18', '2026-02-16 23:17:18', 5),
(110, 4, NULL, NULL, '2026-02-16', 'User', '585000.00', '649350.00', '0.00', '0.00', '64350.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-16 23:18:00', '2026-02-16 23:18:00', 5),
(111, 4, NULL, NULL, '2026-02-16', 'User', '585000.00', '649350.00', '0.00', '0.00', '64350.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-16 23:18:19', '2026-02-16 23:18:19', 5),
(112, 4, NULL, NULL, '2026-02-16', 'NOe', '585000.00', '585000.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-16 23:19:44', '2026-02-16 23:19:44', 5),
(113, 4, NULL, NULL, '2026-02-16', 'User', '12500.00', '12500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-16 23:20:26', '2026-02-16 23:20:26', 5),
(114, 2, 'ICM/2026/0022', 'IPL-CLABEX', '2026-02-16', 'User', '49500.00', '54945.00', '0.00', '0.00', '5445.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-16 23:21:40', 4),
(115, 4, NULL, NULL, '2026-02-16', 'User', '12500.00', '12500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-16 23:22:32', '2026-02-16 23:22:32', 5),
(116, 4, NULL, NULL, '2026-02-16', 'User', '12500.00', '12500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-16 23:22:46', '2026-02-16 23:22:46', 5),
(117, 4, NULL, NULL, '2026-02-16', 'User', '12500.00', '12500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-16 23:23:34', '2026-02-16 23:23:34', 5),
(118, 4, NULL, NULL, '2026-02-16', 'User', '0.00', '0.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-16 23:27:55', '2026-02-16 23:27:55', 5),
(119, 4, NULL, NULL, '2026-02-16', 'User', '0.00', '0.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-16 23:28:10', '2026-02-16 23:28:10', 5),
(120, 4, NULL, NULL, '2026-02-16', 'User', '0.00', '0.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-16 23:28:11', '2026-02-16 23:28:11', 5),
(121, 4, NULL, NULL, '2026-02-16', 'User', '12500.00', '12500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-16 23:29:40', '2026-02-16 23:29:40', 5),
(122, 4, NULL, NULL, '2026-02-16', 'User', '12500.00', '12500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-16 23:29:51', '2026-02-16 23:29:51', 5),
(123, 4, NULL, NULL, '2026-02-16', 'User', '12500.00', '12500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-16 23:30:48', '2026-02-16 23:30:48', 5),
(124, 4, NULL, NULL, '2026-02-16', 'User', '12500.00', '12500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-16 23:31:12', '2026-02-16 23:31:12', 5),
(125, 4, NULL, NULL, '2026-02-16', 'User', '12500.00', '12500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-16 23:32:23', '2026-02-16 23:32:23', 5),
(126, 4, NULL, NULL, '2026-02-16', 'User', '12500.00', '12500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-16 23:32:33', '2026-02-16 23:32:33', 5),
(127, 4, NULL, NULL, '2026-02-16', 'User', '12500.00', '12500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-16 23:33:51', '2026-02-16 23:33:51', 5),
(128, 4, NULL, NULL, '2026-02-16', 'User', '12500.00', '12500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-16 23:33:55', '2026-02-16 23:33:55', 5),
(129, 4, NULL, NULL, '2026-02-16', 'User', '12500.00', '12500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-16 23:34:55', '2026-02-16 23:34:55', 5),
(130, 4, NULL, NULL, '2026-02-16', 'User', '12500.00', '12500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-16 23:35:58', '2026-02-16 23:35:58', 5),
(131, 4, NULL, NULL, '2026-02-16', 'User', '12500.00', '12500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-16 23:36:45', '2026-02-16 23:36:45', 5),
(132, 4, NULL, NULL, '2026-02-16', 'User', '12500.00', '12500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-16 23:36:51', '2026-02-16 23:36:51', 5),
(133, 4, NULL, NULL, '2026-02-16', 'User', '12500.00', '12500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-16 23:38:31', '2026-02-16 23:38:31', 5),
(134, 4, NULL, NULL, '2026-02-16', 'User', '12500.00', '12500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-16 23:40:54', '2026-02-16 23:40:54', 5),
(135, 4, NULL, NULL, '2026-02-16', 'User', '12500.00', '12500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-16 23:42:12', '2026-02-16 23:42:12', 5),
(136, 1, 'ICM/2026/0023', 'IPL-CLABEX', '2026-02-16', 'User', '74000.00', '74000.00', '100000.00', '26000.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-16 23:43:18', 4),
(137, 4, NULL, NULL, '2026-02-16', 'User', '0.00', '0.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-16 23:43:50', '2026-02-16 23:43:50', 5),
(138, 4, NULL, NULL, '2026-02-16', 'User', '12500.00', '12500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-16 23:45:28', '2026-02-16 23:45:28', 5),
(139, 4, NULL, NULL, '2026-02-16', 'User', '12500.00', '12500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '2026-02-16 23:45:38', '2026-02-16 23:45:38', 5),
(140, 4, 'INV/2026/0001', 'IPL-SC2', '2026-02-16', 'User', '12500.00', '12500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-16 23:56:03', 5),
(141, 1, 'INV/2026/0002', 'IPL-SC2', '2026-02-17', 'User', '57500.00', '57500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-17 00:03:18', 5),
(142, 1, 'INV/2026/0003', 'IPL-SC2', '2026-02-17', 'User', '57500.00', '57500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-17 00:12:41', 6),
(143, 1, 'INV/2026/0004', 'IPL-SC2', '2026-02-17', 'User', '12500.00', '12500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-17 00:36:23', 6),
(144, 2, 'INV/2026/0005', 'IPL-SC2', '2026-02-17', 'User', '12500.00', '12500.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-17 00:46:28', 6),
(145, 1, 'INV/2026/0006', 'IPL-SC2', '2026-02-17', 'User', '45000.00', '45000.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-17 00:47:21', 6),
(146, 1, 'INV/2026/0007', 'IPL-SC2', '2026-02-17', 'User', '72200.00', '72200.00', '100000.00', '27800.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-17 00:51:09', 6),
(147, 1, 'INV/2026/0008', 'IPL-SC2', '2026-02-17', 'User', '72200.00', '72200.00', '100000.00', '27800.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-17 00:57:17', 7),
(148, 4, 'INV/2026/0009', 'IPL-SC2', '2026-02-17', 'User', '60000.00', '60000.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-17 00:57:42', 7),
(149, 2, 'ICM/2026/0024', 'IPL-CLABEX', '2026-02-17', 'User', '270200.00', '270200.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-17 20:13:31', 8),
(150, 1, 'ICM/2026/0025', 'IPL-CLABEX', '2026-02-17', 'Noe', '115000.00', '115000.00', '120000.00', '5000.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-17 20:14:43', 8),
(151, 1, 'ICM/2026/0026', 'IPL-CLABEX', '2026-02-17', 'User', '25000.00', '27750.00', '100000.00', '72300.00', '2750.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-17 20:17:39', 8),
(152, 1, 'ICM/2026/0027', 'IPL-CLABEX', '2026-02-17', 'User', '99000.00', '109890.00', '200000.00', '90100.00', '10890.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-17 23:05:17', 9),
(153, 1, 'ICM/2026/0028', 'IPL-CLABEX', '2026-02-18', 'ARman', '710000.00', '788100.00', '800000.00', '11900.00', '78100.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-18 11:32:19', 10),
(154, 4, 'ICM/2026/0029', 'IPL-CLABEX', '2026-02-18', 'User', '49200.00', '49200.00', '0.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-02-18 11:33:11', 10),
(155, 1, 'ICM/2026/0030', 'IPL-CLABEX', '2026-03-18', 'Noe', '49200.00', '49200.00', '50000.00', '800.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-03-18 10:36:25', 14),
(156, 4, 'ICM/2026/0031', 'IPL-CLABEX', '2026-03-18', 'Tuti', '71000.00', '78810.00', '0.00', '0.00', '7810.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-03-18 10:39:28', 14),
(157, 6, 'ICM/2026/0032', 'IPL-CLABEX', '2026-03-18', 'Opan', '25000.00', '27750.00', '0.00', '0.00', '2750.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-03-18 14:14:17', 15),
(158, 2, 'ICM/2026/0033', 'IPL-CLABEX', '2026-03-18', 'iCAM', '49200.00', '54612.00', '0.00', '0.00', '5412.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-03-18 15:45:21', 16),
(159, 1, 'ICM/2026/0034', 'IPL-CLABEX', '2026-03-18', 'Wini', '25000.00', '25000.00', '25000.00', '0.00', '0.00', NULL, '0.00', '0.00', 'Tidak', '0000-00-00 00:00:00', '2026-03-18 15:46:45', 16);

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

--
-- Table structure for table `nota_item`
--

CREATE TABLE `nota_item` (
  `id` int(11) NOT NULL,
  `nota_id` int(11) DEFAULT NULL,
  `nama_barang` varchar(150) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `harga` decimal(12,2) DEFAULT NULL,
  `subtotal` decimal(12,2) DEFAULT NULL,
  `barang_id` int(11) DEFAULT NULL,
  `diskon` decimal(5,2) NOT NULL DEFAULT '0.00',
  `eDeleted` enum('Ya','Tidak') NOT NULL DEFAULT 'Tidak'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `nota_item`
--

INSERT INTO `nota_item` (`id`, `nota_id`, `nama_barang`, `qty`, `harga`, `subtotal`, `barang_id`, `diskon`, `eDeleted`) VALUES
(2, 2, NULL, 1, '5300.00', '5300.00', 2, '0.00', 'Tidak'),
(5, 5, NULL, 1, '5000.00', '5000.00', 1, '0.00', 'Tidak'),
(8, 10, NULL, 1, '5000.00', '2500.00', 1, '50.00', 'Tidak'),
(19, 9, NULL, 1, '5000.00', '2500.00', 1, '50.00', 'Tidak'),
(20, 9, NULL, 1, '45000.00', '45000.00', 3, '0.00', 'Tidak'),
(25, 20, NULL, 1, '5000.00', '5000.00', 1, '0.00', 'Tidak'),
(26, 21, NULL, 56, '5000.00', '280000.00', 1, '0.00', 'Tidak'),
(27, 22, NULL, 1, '5000.00', '5000.00', 1, '0.00', 'Tidak'),
(28, 22, NULL, 1, '5300.00', '5300.00', 2, '0.00', 'Tidak'),
(29, 22, NULL, 1, '45000.00', '45000.00', 3, '0.00', 'Tidak'),
(30, 23, NULL, 1, '5300.00', '5300.00', 2, '0.00', 'Tidak'),
(31, 23, NULL, 1, '5000.00', '5000.00', 1, '0.00', 'Tidak'),
(32, 23, NULL, 14, '99000.00', '1386000.00', 103, '0.00', 'Tidak'),
(34, 24, NULL, 1, '99000.00', '99000.00', 103, '0.00', 'Tidak'),
(35, 24, NULL, 20, '50000.00', '1000000.00', 13, '0.00', 'Tidak'),
(36, 25, NULL, 1, '25000.00', '25000.00', 4, '0.00', 'Tidak'),
(37, 26, NULL, 1, '23000.00', '23000.00', 14, '0.00', 'Tidak'),
(38, 27, NULL, 1, '25000.00', '25000.00', 4, '0.00', 'Tidak'),
(39, 28, NULL, 1, '25000.00', '25000.00', 4, '0.00', 'Tidak'),
(40, 29, NULL, 5, '25000.00', '125000.00', 4, '0.00', 'Tidak'),
(41, 30, NULL, 1, '34000.00', '34000.00', 17, '0.00', 'Tidak'),
(42, 30, NULL, 1, '38000.00', '38000.00', 18, '0.00', 'Tidak'),
(43, 31, NULL, 1, '25000.00', '25000.00', 4, '0.00', 'Tidak'),
(44, 31, NULL, 1, '38000.00', '38000.00', 18, '0.00', 'Tidak'),
(48, 32, NULL, 10, '50000.00', '500000.00', 13, '0.00', 'Tidak'),
(49, 33, NULL, 1, '50000.00', '50000.00', 13, '0.00', 'Tidak'),
(51, 35, NULL, 1, '23000.00', '23000.00', 14, '0.00', 'Tidak'),
(52, 36, NULL, 1, '38000.00', '38000.00', 18, '0.00', 'Tidak'),
(61, 38, NULL, 3, '50000.00', '150000.00', 13, '0.00', 'Tidak'),
(97, 39, NULL, 1, '23000.00', '23000.00', 14, '0.00', 'Ya'),
(106, 37, NULL, 1, '50000.00', '50000.00', 13, '0.00', 'Tidak'),
(107, 37, NULL, 1, '38000.00', '38000.00', 18, '0.00', 'Tidak'),
(108, 37, NULL, 1, '34000.00', '34000.00', 17, '0.00', 'Tidak'),
(109, 37, NULL, 1, '29000.00', '29000.00', 16, '0.00', 'Tidak'),
(110, 37, NULL, 1, '31000.00', '31000.00', 15, '0.00', 'Tidak'),
(111, 37, NULL, 1, '23000.00', '23000.00', 14, '0.00', 'Tidak'),
(112, 37, NULL, 1, '25000.00', '25000.00', 4, '0.00', 'Tidak'),
(113, 37, NULL, 1, '24000.00', '24000.00', 20, '0.00', 'Tidak'),
(114, 3, NULL, 11, '45000.00', '247500.00', 3, '50.00', 'Tidak'),
(118, 40, NULL, 1, '25000.00', '12500.00', 4, '50.00', 'Tidak'),
(119, 40, NULL, 1, '50000.00', '50000.00', 13, '0.00', 'Tidak'),
(120, 40, NULL, 1, '23000.00', '23000.00', 14, '0.00', 'Tidak'),
(124, 34, NULL, 1, '50000.00', '50000.00', 13, '0.00', 'Tidak'),
(125, 42, NULL, 1, '25000.00', '12500.00', 4, '50.00', 'Tidak'),
(126, 42, NULL, 1, '50000.00', '45000.00', 13, '10.00', 'Tidak'),
(127, 43, NULL, 1, '5300.00', '5300.00', 2, '0.00', 'Tidak'),
(128, 43, NULL, 1, '56000.00', '56000.00', 107, '0.00', 'Tidak'),
(130, 47, NULL, 11, '25000.00', '275000.00', 108, '0.00', 'Tidak'),
(131, 48, NULL, 1, '66000.00', '49500.00', 70, '25.00', 'Tidak'),
(132, 48, NULL, 1, '71000.00', '71000.00', 75, '0.00', 'Tidak'),
(133, 59, NULL, 1, '90000.00', '90000.00', 94, '0.00', 'Tidak'),
(134, 60, NULL, 1, '82000.00', '49200.00', 86, '40.00', 'Tidak'),
(135, 61, NULL, 1, '66000.00', '49500.00', 70, '25.00', 'Tidak'),
(136, 62, NULL, 1, '66000.00', '49500.00', 70, '25.00', 'Tidak'),
(137, 76, NULL, 1, '74000.00', '74000.00', 78, '0.00', 'Tidak'),
(138, 77, NULL, 1, '74000.00', '74000.00', 78, '0.00', 'Tidak'),
(139, 94, NULL, 1, '66000.00', '49500.00', 70, '25.00', 'Tidak'),
(140, 95, NULL, 1, '74000.00', '74000.00', 78, '0.00', 'Tidak'),
(141, 96, NULL, 1, '74000.00', '74000.00', 78, '0.00', 'Tidak'),
(142, 97, NULL, 1, '74000.00', '74000.00', 78, '0.00', 'Tidak'),
(143, 98, NULL, 1, '74000.00', '74000.00', 78, '0.00', 'Tidak'),
(144, 99, NULL, 1, '74000.00', '74000.00', 78, '0.00', 'Tidak'),
(145, 100, NULL, 1, '82000.00', '49200.00', 86, '40.00', 'Tidak'),
(146, 101, NULL, 1, '66000.00', '49500.00', 70, '25.00', 'Tidak'),
(147, 102, NULL, 1, '66000.00', '49500.00', 70, '25.00', 'Tidak'),
(148, 103, NULL, 1, '66000.00', '49500.00', 70, '25.00', 'Tidak'),
(149, 103, NULL, 1, '71000.00', '71000.00', 75, '0.00', 'Tidak'),
(150, 104, NULL, 1, '66000.00', '49500.00', 70, '25.00', 'Tidak'),
(151, 104, NULL, 1, '71000.00', '71000.00', 75, '0.00', 'Tidak'),
(152, 105, NULL, 1, '90000.00', '90000.00', 94, '0.00', 'Tidak'),
(153, 106, NULL, 1, '25000.00', '25000.00', 108, '0.00', 'Tidak'),
(154, 107, NULL, 1, '66000.00', '49500.00', 70, '25.00', 'Tidak'),
(155, 107, NULL, 1, '90000.00', '90000.00', 94, '0.00', 'Tidak'),
(156, 114, NULL, 1, '66000.00', '49500.00', 70, '25.00', 'Tidak'),
(157, 136, NULL, 1, '74000.00', '74000.00', 78, '0.00', 'Tidak'),
(158, 140, NULL, 1, '25000.00', '12500.00', 4, '50.00', 'Tidak'),
(159, 141, NULL, 1, '25000.00', '12500.00', 4, '50.00', 'Tidak'),
(160, 141, NULL, 1, '50000.00', '45000.00', 13, '10.00', 'Tidak'),
(161, 142, NULL, 1, '25000.00', '12500.00', 4, '50.00', 'Tidak'),
(162, 142, NULL, 1, '50000.00', '45000.00', 13, '10.00', 'Tidak'),
(163, 143, NULL, 1, '25000.00', '12500.00', 4, '50.00', 'Tidak'),
(164, 144, NULL, 1, '25000.00', '12500.00', 4, '50.00', 'Tidak'),
(165, 145, NULL, 1, '50000.00', '45000.00', 13, '10.00', 'Tidak'),
(166, 146, NULL, 1, '50000.00', '45000.00', 13, '10.00', 'Tidak'),
(167, 146, NULL, 1, '34000.00', '27200.00', 17, '20.00', 'Tidak'),
(168, 147, NULL, 1, '50000.00', '45000.00', 13, '10.00', 'Tidak'),
(169, 147, NULL, 1, '34000.00', '27200.00', 17, '20.00', 'Tidak'),
(170, 148, NULL, 5, '12000.00', '60000.00', 5, '0.00', 'Tidak'),
(171, 149, NULL, 1, '71000.00', '71000.00', 75, '0.00', 'Tidak'),
(172, 149, NULL, 1, '74000.00', '74000.00', 78, '0.00', 'Tidak'),
(173, 149, NULL, 1, '76000.00', '76000.00', 80, '0.00', 'Tidak'),
(174, 149, NULL, 1, '82000.00', '49200.00', 86, '40.00', 'Tidak'),
(175, 150, NULL, 1, '25000.00', '25000.00', 108, '0.00', 'Tidak'),
(176, 150, NULL, 1, '90000.00', '90000.00', 94, '0.00', 'Tidak'),
(177, 151, NULL, 1, '25000.00', '25000.00', 108, '0.00', 'Tidak'),
(178, 152, NULL, 2, '66000.00', '99000.00', 70, '25.00', 'Tidak'),
(179, 153, NULL, 10, '71000.00', '710000.00', 75, '0.00', 'Tidak'),
(180, 154, NULL, 1, '82000.00', '49200.00', 86, '40.00', 'Tidak'),
(181, 46, NULL, 3, '25000.00', '75000.00', 108, '0.00', 'Tidak'),
(182, 155, NULL, 1, '82000.00', '49200.00', 86, '40.00', 'Tidak'),
(183, 156, NULL, 1, '71000.00', '71000.00', 75, '0.00', 'Tidak'),
(184, 157, NULL, 1, '25000.00', '25000.00', 108, '0.00', 'Tidak'),
(185, 158, NULL, 1, '82000.00', '49200.00', 86, '40.00', 'Tidak'),
(186, 159, NULL, 1, '25000.00', '25000.00', 108, '0.00', 'Tidak');

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

--
-- Table structure for table `payment_method`
--

CREATE TABLE `payment_method` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL COMMENT 'Nama metode pembayaran, misal Tunai',
  `code` varchar(20) NOT NULL COMMENT 'Kode unik, misal CASH, TRF',
  `is_active` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'Aktif = 1, Nonaktif = 0',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Daftar metode pembayaran';

--
-- Dumping data for table `payment_method`
--

INSERT INTO `payment_method` (`id`, `name`, `code`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Tunai', 'TN', 1, '2026-02-11 09:18:55', '2026-02-12 22:04:12'),
(2, 'Transfer Bank', 'TRF', 1, '2026-02-10 22:00:12', '2026-02-11 09:03:52'),
(3, 'OVO ONO', 'OVO', 1, '2026-02-10 22:00:12', '2026-02-15 14:33:27'),
(4, 'GoPay', 'GOPAY', 1, '2026-02-10 22:00:12', '2026-02-15 14:33:34'),
(5, 'Dana', 'DANA', 1, '2026-02-10 22:00:12', '2026-02-15 14:33:42'),
(6, 'Credit Card', 'CARD', 1, '2026-02-10 22:00:12', '2026-02-10 22:00:12'),
(7, 'QRIS', 'QR', 1, '2026-02-10 22:00:12', '2026-02-15 08:25:46');

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

--
-- Table structure for table `payment_settings`
--

CREATE TABLE `payment_settings` (
  `id` int(11) NOT NULL,
  `payment_method_id` int(11) NOT NULL,
  `account_number` varchar(50) NOT NULL,
  `owner_name` varchar(100) DEFAULT NULL,
  `bank_name` varchar(100) DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `idCluster` char(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payment_settings`
--

INSERT INTO `payment_settings` (`id`, `payment_method_id`, `account_number`, `owner_name`, `bank_name`, `created_at`, `updated_at`, `idCluster`) VALUES
(1, 2, '1234567890', 'PT ABC', '22', '2026-02-15 09:10:32', '2026-02-15 09:10:32', NULL),
(2, 2, '1234567890', 'PT AA', '23', '2026-02-15 09:10:32', '2026-02-15 09:10:32', NULL),
(3, 3, '081234567890', NULL, NULL, '2026-02-15 09:10:32', '2026-02-15 09:10:32', NULL),
(4, 4, '089876543210', 'Husnul', NULL, '2026-02-15 09:10:32', '2026-02-15 09:10:32', NULL),
(5, 2, '1234567890', 'PT ABC', 'BCA', '2026-02-15 14:27:08', '2026-02-15 14:27:08', NULL),
(6, 2, '9876543210', 'PT XYZ', 'Mandiri', '2026-02-15 14:27:08', '2026-02-15 14:27:08', NULL),
(7, 3, '081234567890', 'Husnul', 'OVO', '2026-02-15 14:27:08', '2026-02-15 14:27:08', NULL),
(8, 3, '081234567890', 'Husnul', 'Gopay', '2026-02-15 14:29:23', '2026-02-15 14:29:23', NULL),
(9, 3, '081234567891', 'Husnul', 'Dana', '2026-02-15 14:29:23', '2026-02-15 14:29:23', NULL),
(10, 3, '081234567892', 'Husnul', 'OVO', '2026-02-15 14:29:23', '2026-02-15 14:29:23', NULL),
(11, 1, '', NULL, NULL, '2026-02-16 13:19:51', '2026-02-16 13:19:51', NULL),
(12, 1, '', '', '', '2026-02-16 13:27:35', '2026-02-16 13:27:35', 'IPL-CLABEX'),
(13, 2, '3232832890', 'Arman', 'BCA', '2026-02-16 13:28:06', '2026-02-16 13:28:06', 'IPL-CLABEX'),
(14, 4, '546546546', 'Araman', '', '2026-02-16 13:28:58', '2026-02-16 13:28:58', 'IPL-CLABEX'),
(15, 4, '23244', 'NOe', '', '2026-02-16 13:37:45', '2026-02-16 13:37:45', 'IPL-SC2'),
(16, 1, '', '', '', '2026-02-17 00:03:01', '2026-02-17 00:03:01', 'IPL-SC2');

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

--
-- Table structure for table `setting_format_nomor`
--

CREATE TABLE `setting_format_nomor` (
  `id` int(11) NOT NULL,
  `nama_format` varchar(50) DEFAULT NULL,
  `template` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `setting_format_nomor`
--

INSERT INTO `setting_format_nomor` (`id`, `nama_format`, `template`) VALUES
(1, 'Format INV/2026/00001', '{PREFIX}/{YEAR}/{NUMBER}'),
(2, 'Format NT-202602-0001', '{PREFIX}-{YEAR}{MONTH}-{NUMBER}'),
(3, 'Format TRX-14-02-2026-001', '{PREFIX}-{DAY}-{MONTH}-{YEAR}-{NUMBER}'),
(4, 'Format NT-20260214-0001', '{PREFIX}-{YEAR}{MONTH}{DAY}{NUMBER}');

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

--
-- Table structure for table `setting_pdf`
--

CREATE TABLE `setting_pdf` (
  `id` int(11) NOT NULL,
  `paper_size` varchar(20) NOT NULL,
  `orientation` enum('portrait','landscape') DEFAULT 'portrait',
  `margin_top` int(11) DEFAULT '10',
  `margin_bottom` int(11) DEFAULT '10',
  `margin_left` int(11) DEFAULT '10',
  `margin_right` int(11) DEFAULT '10',
  `show_logo` tinyint(1) DEFAULT '1',
  `header_text` text,
  `footer_text` text,
  `tCreated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `tUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `setting_pdf`
--

INSERT INTO `setting_pdf` (`id`, `paper_size`, `orientation`, `margin_top`, `margin_bottom`, `margin_left`, `margin_right`, `show_logo`, `header_text`, `footer_text`, `tCreated`, `tUpdated`) VALUES
(3, 'a4', 'portrait', 10, 10, 10, 10, 1, 'Terima kasih atas pembayaran Anda', 'Barang yang sudah dibeli tidak dapat dikembalikan', '2026-02-11 04:22:24', '2026-02-15 09:22:53'),
(4, 'a5', 'portrait', 8, 8, 8, 8, 1, 'Terima kasih atas pembayaran Anda', 'Barang yang sudah dibeli tidak dapat dikembalikan', '2026-02-11 04:22:24', '2026-02-15 09:22:57'),
(5, 'thermal58', 'portrait', 5, 5, 5, 5, 1, 'Terima kasih atas pembayaran Anda', 'Barang yang sudah dibeli tidak dapat dikembalikan', '2026-02-11 04:22:24', '2026-02-15 09:21:41'),
(6, 'thermal80', 'portrait', 5, 5, 5, 5, 1, 'Terima kasih atas pembayaran Anda', 'Barang yang sudah dibeli tidak dapat dikembalikan', '2026-02-11 04:22:24', '2026-02-11 04:22:24');

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

--
-- Table structure for table `template_nota`
--

CREATE TABLE `template_nota` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `file` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `template_nota`
--

INSERT INTO `template_nota` (`id`, `name`, `file`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Template Standar', 'template_standar.html', 1, '2026-02-11 04:39:18', '2026-02-11 04:39:18'),
(2, 'Template Modern', 'template_modern.html', 0, '2026-02-11 04:39:18', '2026-02-11 04:39:18'),
(3, 'Template Minimalis', 'template_minimalis.html', 0, '2026-02-11 04:39:18', '2026-02-11 04:39:18');

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

--
-- Table structure for table `voucher`
--

CREATE TABLE `voucher` (
  `id` int(11) NOT NULL,
  `kode` varchar(50) NOT NULL,
  `idCluster` varchar(50) NOT NULL,
  `type` enum('nominal','percent') NOT NULL DEFAULT 'nominal',
  `value` decimal(12,2) NOT NULL DEFAULT '0.00',
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `voucher`
--

INSERT INTO `voucher` (`id`, `kode`, `idCluster`, `type`, `value`, `active`, `created_at`) VALUES
(1, 'DISKON50', '', 'nominal', '50000.00', 1, '2026-02-12 01:45:44'),
(2, 'PROMO10', '', 'percent', '10.00', 1, '2026-02-12 01:45:44'),
(3, 'WELCOME5', '', 'percent', '5.00', 1, '2026-02-12 01:45:44');

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `kasir_shift`
--
ALTER TABLE `kasir_shift`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `log_hist`
--
ALTER TABLE `log_hist`
  ADD PRIMARY KEY (`iId`) USING BTREE;

--
-- Indexes for table `m_barang_foto`
--
ALTER TABLE `m_barang_foto`
  ADD PRIMARY KEY (`iId`) USING BTREE,
  ADD UNIQUE KEY `id` (`iId`) USING BTREE,
  ADD KEY `Barangid` (`iBarangid`) USING BTREE,
  ADD KEY `eDefault` (`eDefault`) USING BTREE,
  ADD KEY `image` (`vImage`) USING BTREE;

--
-- Indexes for table `m_cluster`
--
ALTER TABLE `m_cluster`
  ADD PRIMARY KEY (`iId`) USING BTREE;

--
-- Indexes for table `m_kalender`
--
ALTER TABLE `m_kalender`
  ADD PRIMARY KEY (`iId`) USING BTREE;

--
-- Indexes for table `m_metodepembayaran`
--
ALTER TABLE `m_metodepembayaran`
  ADD PRIMARY KEY (`iId`) USING BTREE;

--
-- Indexes for table `m_pembayaran`
--
ALTER TABLE `m_pembayaran`
  ADD PRIMARY KEY (`iId`) USING BTREE;

--
-- Indexes for table `m_ppn`
--
ALTER TABLE `m_ppn`
  ADD PRIMARY KEY (`iId`) USING BTREE;

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

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

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

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

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

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

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

--
-- Indexes for table `voucher`
--
ALTER TABLE `voucher`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `kode` (`kode`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

--
-- AUTO_INCREMENT for table `log_hist`
--
ALTER TABLE `log_hist`
  MODIFY `iId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=266;

--
-- AUTO_INCREMENT for table `m_barang_foto`
--
ALTER TABLE `m_barang_foto`
  MODIFY `iId` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID foto Produk', AUTO_INCREMENT=29190;

--
-- AUTO_INCREMENT for table `m_cluster`
--
ALTER TABLE `m_cluster`
  MODIFY `iId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=380;

--
-- AUTO_INCREMENT for table `m_kalender`
--
ALTER TABLE `m_kalender`
  MODIFY `iId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `m_metodepembayaran`
--
ALTER TABLE `m_metodepembayaran`
  MODIFY `iId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `m_pembayaran`
--
ALTER TABLE `m_pembayaran`
  MODIFY `iId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

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

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

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

--
-- AUTO_INCREMENT for table `payment_method`
--
ALTER TABLE `payment_method`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

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

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

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

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

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

