PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE IF NOT EXISTS "migrations" ("id" integer primary key autoincrement not null, "migration" varchar not null, "batch" integer not null);
INSERT INTO migrations VALUES(1,'0001_01_01_000000_create_users_table',1);
INSERT INTO migrations VALUES(2,'0001_01_01_000001_create_cache_table',1);
INSERT INTO migrations VALUES(3,'0001_01_01_000002_create_jobs_table',1);
INSERT INTO migrations VALUES(4,'2026_04_10_210934_create_pricing_rules_table',2);
INSERT INTO migrations VALUES(5,'2026_04_10_210934_create_rentals_table',2);
INSERT INTO migrations VALUES(6,'2026_04_10_210934_create_units_table',2);
INSERT INTO migrations VALUES(7,'2026_04_10_222754_add_deleted_at_to_units_table',3);
INSERT INTO migrations VALUES(8,'2026_04_10_230509_add_metode_pembayaran_to_rentals_table',4);
INSERT INTO migrations VALUES(9,'2026_04_10_231922_create_settings_table',5);
INSERT INTO migrations VALUES(10,'2026_04_10_231923_add_denda_to_rentals_table',5);
INSERT INTO migrations VALUES(11,'2026_04_11_070000_add_denda_payment_method_to_rentals',6);
INSERT INTO migrations VALUES(12,'2026_04_11_070001_add_role_to_users_table',7);
INSERT INTO migrations VALUES(13,'2026_04_11_005047_add_kategori_to_units_table',8);
INSERT INTO migrations VALUES(14,'2026_04_11_010140_add_dates_to_pricing_rules_table',9);
INSERT INTO migrations VALUES(15,'2026_04_11_010905_add_denda_kerusakan_to_rentals_table',10);
INSERT INTO migrations VALUES(16,'2026_04_11_011523_add_catatan_kerusakan_to_rentals_table',11);
CREATE TABLE IF NOT EXISTS "users" ("id" integer primary key autoincrement not null, "name" varchar not null, "email" varchar not null, "email_verified_at" datetime, "password" varchar not null, "remember_token" varchar, "created_at" datetime, "updated_at" datetime, "role" varchar not null default 'admin');
INSERT INTO users VALUES(1,'Test User','test@example.com','2026-04-10 21:30:05','$2y$12$k1qQTEfxtKtdYl2gJ5HnuOCkRflggsRfaPRsThcXcr07SJRRfpTkm','hZi6GjzBW4','2026-04-10 21:30:06','2026-04-10 21:30:06','admin');
INSERT INTO users VALUES(2,'Administrator','admin@rentspace.com',NULL,'$2y$12$ECxIsDDcIa2ANoiB4KCuFOQwqllZm93CJcoB.slICNihbeuAznczu',NULL,'2026-04-10 21:30:24','2026-04-11 04:22:49','admin');
INSERT INTO users VALUES(3,'singgih','singgih@gmail.com',NULL,'$2y$12$k3rV5bPl2WMK3BU08PwwH.cFRkA7eZhtKjFgpOqVmWvnt5..KeyMS',NULL,'2026-04-10 23:37:55','2026-04-10 23:37:55','admin');
INSERT INTO users VALUES(5,'avan','avan@gmail.com',NULL,'$2y$12$UyEBb2Ft14svmKhs.Rylr.J/laKvBko8hTtcdep6rZr7tMjdW2bOi',NULL,'2026-04-10 23:41:38','2026-04-10 23:41:38','viewer');
CREATE TABLE IF NOT EXISTS "password_reset_tokens" ("email" varchar not null, "token" varchar not null, "created_at" datetime, primary key ("email"));
CREATE TABLE IF NOT EXISTS "sessions" ("id" varchar not null, "user_id" integer, "ip_address" varchar, "user_agent" text, "payload" text not null, "last_activity" integer not null, primary key ("id"));
INSERT INTO sessions VALUES('se8Zj6sE0jji9OAWZAbUgvYzmeV5vXY0gWxs5DOE',3,'172.20.10.1','Mozilla/5.0 (iPhone; CPU iPhone OS 18_7 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.3 Mobile/15E148 Safari/604.1','YTo1OntzOjY6Il90b2tlbiI7czo0MDoick15QkFhVEVNSFNMYXhiSVEyem5LS3RtWm5HZFoyNEZBVGRralBFZiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly8xNzIuMjAuMTAuMjo4MDgwL3RpbWVsaW5lIjtzOjU6InJvdXRlIjtzOjE1OiJwdWJsaWMudGltZWxpbmUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjM6InVybCI7YToxOntzOjg6ImludGVuZGVkIjtzOjM5OiJodHRwOi8vMTcyLjIwLjEwLjI6ODA4MC9hZG1pbi9kYXNoYm9hcmQiO31zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aTozO30=',1775874409);
INSERT INTO sessions VALUES('nlR7V7XtX4yVWBMpgDAGjP8HnLTzB8BN0J2G91R3',3,'127.0.0.1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','YTo1OntzOjY6Il90b2tlbiI7czo0MDoiTTZ3bm1UN3F6dmNvaGlYU0V2ZzlrS21UQzVwYVU3UHd5c2VTYjlKSiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mjk6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC90ZW50YW5nIjtzOjU6InJvdXRlIjtzOjEyOiJwdWJsaWMuYWJvdXQiO31zOjM6InVybCI7YToxOntzOjg6ImludGVuZGVkIjtzOjM3OiJodHRwOi8vMTI3LjAuMC4xOjgwMDAvYWRtaW4vZGFzaGJvYXJkIjt9czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6Mzt9',1775880137);
CREATE TABLE IF NOT EXISTS "cache" ("key" varchar not null, "value" text not null, "expiration" integer not null, primary key ("key"));
CREATE TABLE IF NOT EXISTS "cache_locks" ("key" varchar not null, "owner" varchar not null, "expiration" integer not null, primary key ("key"));
CREATE TABLE IF NOT EXISTS "jobs" ("id" integer primary key autoincrement not null, "queue" varchar not null, "payload" text not null, "attempts" integer not null, "reserved_at" integer, "available_at" integer not null, "created_at" integer not null);
CREATE TABLE IF NOT EXISTS "job_batches" ("id" varchar not null, "name" varchar not null, "total_jobs" integer not null, "pending_jobs" integer not null, "failed_jobs" integer not null, "failed_job_ids" text not null, "options" text, "cancelled_at" integer, "created_at" integer not null, "finished_at" integer, primary key ("id"));
CREATE TABLE IF NOT EXISTS "failed_jobs" ("id" integer primary key autoincrement not null, "uuid" varchar not null, "connection" text not null, "queue" text not null, "payload" text not null, "exception" text not null, "failed_at" datetime not null default CURRENT_TIMESTAMP);
CREATE TABLE IF NOT EXISTS "pricing_rules" ("id" integer primary key autoincrement not null, "nama_promo" varchar not null, "tipe" varchar not null, "value" numeric not null, "syarat_minimal_durasi" integer, "syarat_tipe_durasi" varchar not null default 'jam', "is_active" tinyint(1) not null default '1', "created_at" datetime, "updated_at" datetime, "start_date" date, "end_date" date, "deleted_at" datetime);
INSERT INTO pricing_rules VALUES(1,'PROMO LEBARAN','diskon_persen',35,12,'jam',1,'2026-04-10 23:54:28','2026-04-11 01:05:41','2026-04-11','2026-04-19',NULL);
INSERT INTO pricing_rules VALUES(2,'GRATIS','hari_gratis',3,24,'jam',0,'2026-04-11 01:26:47','2026-04-11 01:28:02',NULL,NULL,NULL);
INSERT INTO pricing_rules VALUES(12,'ppp','hari_gratis',2,7,'jam',1,'2026-04-11 04:01:20','2026-04-11 04:01:20',NULL,NULL,NULL);
CREATE TABLE IF NOT EXISTS "rentals" ("id" integer primary key autoincrement not null, "unit_id" integer not null, "nik" varchar not null, "nama" varchar not null, "alamat" text not null, "no_wa" varchar not null, "waktu_mulai" datetime not null, "waktu_selesai" datetime not null, "subtotal_harga" numeric not null, "potongan_diskon" numeric not null default '0', "kode_unik_pembayaran" integer, "grand_total" numeric not null, "status" varchar check ("status" in ('pending', 'paid', 'completed', 'cancelled')) not null default 'pending', "created_at" datetime, "updated_at" datetime, "metode_pembayaran" varchar not null default 'qris', "denda" integer not null default '0', "denda_payment_method" varchar, "denda_kerusakan" integer not null default '0', "catatan_kerusakan" varchar, foreign key("unit_id") references "units"("id") on delete cascade);
INSERT INTO rentals VALUES(1,3,'3312305628360315','Andi Wijaya','Jl. Contoh No. 70, Purwokerto','08652246842','2026-01-15 08:00:00','2026-01-15 12:00:00',40000,0,335,40335,'completed','2026-01-15 08:00:00','2026-01-15 08:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(2,4,'3312692338742718','Fajar Nugroho','Jl. Contoh No. 98, Purwokerto','08549225507','2026-01-30 08:00:00','2026-01-30 10:00:00',40000,0,236,40236,'completed','2026-01-30 08:00:00','2026-01-30 08:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(3,3,'3312700380578624','Rudi Hermawan','Jl. Contoh No. 17, Purwokerto','08372012377','2026-01-18 10:00:00','2026-01-18 13:00:00',30000,0,259,30259,'completed','2026-01-18 10:00:00','2026-01-18 10:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(4,4,'3312339023880363','Andi Wijaya','Jl. Contoh No. 99, Purwokerto','08118854216','2026-01-21 09:00:00','2026-01-21 13:00:00',80000,0,166,80166,'completed','2026-01-21 09:00:00','2026-01-21 09:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(5,3,'3312797009725177','Rudi Hermawan','Jl. Contoh No. 12, Purwokerto','08855490378','2026-01-28 13:00:00','2026-01-28 21:00:00',80000,0,219,80219,'completed','2026-01-28 13:00:00','2026-01-28 13:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(6,2,'3312095581124489','Fajar Nugroho','Jl. Contoh No. 33, Purwokerto','08771131030','2026-01-22 12:00:00','2026-01-22 16:00:00',38000,0,600,38600,'completed','2026-01-22 12:00:00','2026-01-22 12:00:00','transfer',0,NULL,0,NULL);
INSERT INTO rentals VALUES(7,2,'3312231963137099','Andi Wijaya','Jl. Contoh No. 39, Purwokerto','08523695806','2026-01-07 08:00:00','2026-01-07 15:00:00',66500,0,190,66690,'completed','2026-01-07 08:00:00','2026-01-07 08:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(8,4,'3312280125984120','Maya Putri','Jl. Contoh No. 47, Purwokerto','08945136395','2026-01-12 08:00:00','2026-01-12 14:00:00',120000,0,890,120890,'completed','2026-01-12 08:00:00','2026-01-12 08:00:00','transfer',0,NULL,0,NULL);
INSERT INTO rentals VALUES(9,4,'3312571572855297','Ani Suryani','Jl. Contoh No. 29, Purwokerto','08331040184','2026-01-28 11:00:00','2026-01-28 18:00:00',140000,0,924,140924,'completed','2026-01-28 11:00:00','2026-01-28 11:00:00','transfer',0,NULL,0,NULL);
INSERT INTO rentals VALUES(10,2,'3312222603831149','Ani Suryani','Jl. Contoh No. 78, Purwokerto','08688797161','2026-01-18 16:00:00','2026-01-18 21:00:00',47500,0,575,48075,'completed','2026-01-18 16:00:00','2026-01-18 16:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(11,2,'3312380688544354','Dian Permata','Jl. Contoh No. 57, Purwokerto','08634037315','2026-01-01 16:00:00','2026-01-01 18:00:00',19000,0,842,19842,'completed','2026-01-01 16:00:00','2026-01-01 16:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(12,3,'3312357511234814','Dewi Lestari','Jl. Contoh No. 98, Purwokerto','08382243023','2026-01-06 09:00:00','2026-01-06 16:00:00',70000,0,377,70377,'completed','2026-01-06 09:00:00','2026-01-06 09:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(13,2,'3312663602176981','Hendra Kusuma','Jl. Contoh No. 80, Purwokerto','08852710889','2026-01-22 12:00:00','2026-01-22 17:00:00',47500,0,964,48464,'completed','2026-01-22 12:00:00','2026-01-22 12:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(14,2,'3312255027491733','Fajar Nugroho','Jl. Contoh No. 89, Purwokerto','08599887519','2026-01-12 11:00:00','2026-01-12 15:00:00',38000,0,749,38749,'completed','2026-01-12 11:00:00','2026-01-12 11:00:00','transfer',0,NULL,0,NULL);
INSERT INTO rentals VALUES(15,3,'3312365700839793','Dewi Lestari','Jl. Contoh No. 90, Purwokerto','08350625399','2026-01-15 17:00:00','2026-01-16 01:00:00',80000,0,796,80796,'completed','2026-01-15 17:00:00','2026-01-15 17:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(16,2,'3312343863549699','Ani Suryani','Jl. Contoh No. 20, Purwokerto','08958406511','2026-01-19 16:00:00','2026-01-19 18:00:00',19000,0,181,19181,'completed','2026-01-19 16:00:00','2026-01-19 16:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(17,3,'3312979259347422','Dewi Lestari','Jl. Contoh No. 8, Purwokerto','08303456301','2026-01-15 14:00:00','2026-01-15 21:00:00',70000,0,720,70720,'completed','2026-01-15 14:00:00','2026-01-15 14:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(18,3,'3312791902650398','Maya Putri','Jl. Contoh No. 73, Purwokerto','08889171668','2026-01-12 17:00:00','2026-01-12 20:00:00',30000,0,618,30618,'completed','2026-01-12 17:00:00','2026-01-12 17:00:00','transfer',0,NULL,0,NULL);
INSERT INTO rentals VALUES(19,4,'3312919035980304','Rudi Hermawan','Jl. Contoh No. 73, Purwokerto','08177875031','2026-02-04 17:00:00','2026-02-05 01:00:00',160000,0,722,160722,'completed','2026-02-04 17:00:00','2026-02-04 17:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(20,4,'3312141213885682','Hendra Kusuma','Jl. Contoh No. 71, Purwokerto','08423202083','2026-02-10 09:00:00','2026-02-10 11:00:00',40000,0,788,40788,'completed','2026-02-10 09:00:00','2026-02-10 09:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(21,2,'3312174197699587','Rudi Hermawan','Jl. Contoh No. 53, Purwokerto','08612069188','2026-02-05 16:00:00','2026-02-05 20:00:00',38000,0,914,38914,'completed','2026-02-05 16:00:00','2026-02-05 16:00:00','transfer',0,NULL,0,NULL);
INSERT INTO rentals VALUES(22,3,'3312831570088960','Siti Rahayu','Jl. Contoh No. 72, Purwokerto','08186505711','2026-02-15 11:00:00','2026-02-15 13:00:00',20000,0,853,20853,'completed','2026-02-15 11:00:00','2026-02-15 11:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(23,2,'3312773544468752','Hendra Kusuma','Jl. Contoh No. 26, Purwokerto','08723703813','2026-02-18 10:00:00','2026-02-18 16:00:00',57000,0,505,57505,'completed','2026-02-18 10:00:00','2026-02-18 10:00:00','transfer',0,NULL,0,NULL);
INSERT INTO rentals VALUES(24,2,'3312393540029443','Ani Suryani','Jl. Contoh No. 48, Purwokerto','08344811428','2026-02-16 18:00:00','2026-02-17 02:00:00',76000,0,509,76509,'completed','2026-02-16 18:00:00','2026-02-16 18:00:00','transfer',0,NULL,0,NULL);
INSERT INTO rentals VALUES(25,4,'3312394766116594','Maya Putri','Jl. Contoh No. 83, Purwokerto','08320598178','2026-02-23 08:00:00','2026-02-23 12:00:00',80000,0,830,80830,'completed','2026-02-23 08:00:00','2026-02-23 08:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(26,2,'3312401046160226','Ani Suryani','Jl. Contoh No. 56, Purwokerto','08777257200','2026-02-06 13:00:00','2026-02-06 18:00:00',47500,0,200,47700,'completed','2026-02-06 13:00:00','2026-02-06 13:00:00','transfer',0,NULL,0,NULL);
INSERT INTO rentals VALUES(27,2,'3312619261478441','Budi Santoso','Jl. Contoh No. 97, Purwokerto','08257547463','2026-02-05 16:00:00','2026-02-05 21:00:00',47500,0,401,47901,'completed','2026-02-05 16:00:00','2026-02-05 16:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(28,3,'3312168808910304','Siti Rahayu','Jl. Contoh No. 29, Purwokerto','08439190326','2026-02-06 08:00:00','2026-02-06 11:00:00',30000,0,620,30620,'completed','2026-02-06 08:00:00','2026-02-06 08:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(29,4,'3312855914029159','Fajar Nugroho','Jl. Contoh No. 4, Purwokerto','08985782567','2026-02-07 14:00:00','2026-02-07 20:00:00',120000,0,915,120915,'completed','2026-02-07 14:00:00','2026-02-07 14:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(30,2,'3312221704274165','Ani Suryani','Jl. Contoh No. 5, Purwokerto','08143445666','2026-02-19 18:00:00','2026-02-19 23:00:00',47500,0,987,48487,'completed','2026-02-19 18:00:00','2026-02-19 18:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(31,4,'3312267798196198','Rudi Hermawan','Jl. Contoh No. 84, Purwokerto','08131986440','2026-02-10 14:00:00','2026-02-10 19:00:00',100000,0,100,100100,'completed','2026-02-10 14:00:00','2026-02-10 14:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(32,4,'3312251099880081','Siti Rahayu','Jl. Contoh No. 81, Purwokerto','08962055827','2026-02-12 17:00:00','2026-02-12 22:00:00',100000,0,541,100541,'completed','2026-02-12 17:00:00','2026-02-12 17:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(33,3,'3312328892570655','Siti Rahayu','Jl. Contoh No. 13, Purwokerto','08559976791','2026-02-10 09:00:00','2026-02-10 12:00:00',30000,0,714,30714,'completed','2026-02-10 09:00:00','2026-02-10 09:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(34,3,'3312678510578468','Ani Suryani','Jl. Contoh No. 46, Purwokerto','08939816402','2026-02-21 09:00:00','2026-02-21 13:00:00',40000,0,887,40887,'completed','2026-02-21 09:00:00','2026-02-21 09:00:00','transfer',0,NULL,0,NULL);
INSERT INTO rentals VALUES(35,4,'3312208770802251','Maya Putri','Jl. Contoh No. 61, Purwokerto','08326130151','2026-02-16 16:00:00','2026-02-16 23:00:00',140000,0,459,140459,'completed','2026-02-16 16:00:00','2026-02-16 16:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(36,4,'3312793230886664','Andi Wijaya','Jl. Contoh No. 39, Purwokerto','08809313009','2026-02-05 09:00:00','2026-02-05 13:00:00',80000,0,108,80108,'completed','2026-02-05 09:00:00','2026-02-05 09:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(37,2,'3312575955863936','Dian Permata','Jl. Contoh No. 14, Purwokerto','08174707514','2026-02-11 08:00:00','2026-02-11 10:00:00',19000,0,952,19952,'completed','2026-02-11 08:00:00','2026-02-11 08:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(38,4,'3312674104352938','Budi Santoso','Jl. Contoh No. 26, Purwokerto','08628969606','2026-02-10 10:00:00','2026-02-10 15:00:00',100000,0,155,100155,'completed','2026-02-10 10:00:00','2026-02-10 10:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(39,4,'3312961026110007','Hendra Kusuma','Jl. Contoh No. 85, Purwokerto','08933663969','2026-02-02 10:00:00','2026-02-02 14:00:00',80000,0,835,80835,'completed','2026-02-02 10:00:00','2026-02-02 10:00:00','transfer',0,NULL,0,NULL);
INSERT INTO rentals VALUES(40,3,'3312878279538505','Budi Santoso','Jl. Contoh No. 50, Purwokerto','08319412850','2026-02-20 13:00:00','2026-02-20 20:00:00',70000,0,917,70917,'completed','2026-02-20 13:00:00','2026-02-20 13:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(41,3,'3312756235230488','Rudi Hermawan','Jl. Contoh No. 35, Purwokerto','08739293080','2026-03-12 16:00:00','2026-03-12 18:00:00',20000,0,799,20799,'completed','2026-03-12 16:00:00','2026-03-12 16:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(42,4,'3312822133249460','Siti Rahayu','Jl. Contoh No. 75, Purwokerto','08935851364','2026-03-06 18:00:00','2026-03-06 21:00:00',60000,0,621,60621,'completed','2026-03-06 18:00:00','2026-03-06 18:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(43,3,'3312252507135242','Ani Suryani','Jl. Contoh No. 38, Purwokerto','08901261871','2026-03-15 12:00:00','2026-03-15 14:00:00',20000,0,962,20962,'completed','2026-03-15 12:00:00','2026-03-15 12:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(44,3,'3312139694897256','Andi Wijaya','Jl. Contoh No. 11, Purwokerto','08616818308','2026-03-27 10:00:00','2026-03-27 14:00:00',40000,0,642,40642,'completed','2026-03-27 10:00:00','2026-03-27 10:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(45,2,'3312282346545017','Budi Santoso','Jl. Contoh No. 66, Purwokerto','08251489474','2026-03-09 19:00:00','2026-03-10 00:00:00',47500,0,167,47667,'completed','2026-03-09 19:00:00','2026-03-09 19:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(46,2,'3312014567812521','Rudi Hermawan','Jl. Contoh No. 92, Purwokerto','08507167065','2026-03-11 10:00:00','2026-03-11 17:00:00',66500,0,294,66794,'completed','2026-03-11 10:00:00','2026-03-11 10:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(47,2,'3312474641046437','Andi Wijaya','Jl. Contoh No. 68, Purwokerto','08237096900','2026-03-12 15:00:00','2026-03-12 18:00:00',28500,0,866,29366,'completed','2026-03-12 15:00:00','2026-03-12 15:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(48,2,'3312801472421234','Budi Santoso','Jl. Contoh No. 81, Purwokerto','08237235514','2026-03-01 12:00:00','2026-03-01 15:00:00',28500,0,875,29375,'completed','2026-03-01 12:00:00','2026-03-01 12:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(49,2,'3312944956226486','Rudi Hermawan','Jl. Contoh No. 12, Purwokerto','08798328465','2026-03-18 15:00:00','2026-03-18 22:00:00',66500,0,785,67285,'completed','2026-03-18 15:00:00','2026-03-18 15:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(50,3,'3312447420078724','Maya Putri','Jl. Contoh No. 66, Purwokerto','08729190525','2026-03-13 10:00:00','2026-03-13 15:00:00',50000,0,862,50862,'completed','2026-03-13 10:00:00','2026-03-13 10:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(51,3,'3312119654439160','Andi Wijaya','Jl. Contoh No. 64, Purwokerto','08758275286','2026-03-03 18:00:00','2026-03-03 20:00:00',20000,0,717,20717,'completed','2026-03-03 18:00:00','2026-03-03 18:00:00','transfer',0,NULL,0,NULL);
INSERT INTO rentals VALUES(52,2,'3312042499119060','Siti Rahayu','Jl. Contoh No. 90, Purwokerto','08963175509','2026-03-06 14:00:00','2026-03-06 21:00:00',66500,0,234,66734,'completed','2026-03-06 14:00:00','2026-03-06 14:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(53,4,'3312392933888973','Andi Wijaya','Jl. Contoh No. 88, Purwokerto','08149563952','2026-03-27 19:00:00','2026-03-27 22:00:00',60000,0,148,60148,'completed','2026-03-27 19:00:00','2026-03-27 19:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(54,3,'3312965057486246','Ani Suryani','Jl. Contoh No. 79, Purwokerto','08353569113','2026-03-30 10:00:00','2026-03-30 14:00:00',40000,0,162,40162,'completed','2026-03-30 10:00:00','2026-03-30 10:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(55,3,'3312962817366323','Ani Suryani','Jl. Contoh No. 15, Purwokerto','08816468982','2026-03-26 10:00:00','2026-03-26 16:00:00',60000,0,294,60294,'completed','2026-03-26 10:00:00','2026-03-26 10:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(56,4,'3312375249971294','Budi Santoso','Jl. Contoh No. 76, Purwokerto','08481716502','2026-03-21 17:00:00','2026-03-22 01:00:00',160000,0,599,160599,'completed','2026-03-21 17:00:00','2026-03-21 17:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(57,3,'3312255188130005','Budi Santoso','Jl. Contoh No. 98, Purwokerto','08200609901','2026-03-12 16:00:00','2026-03-12 21:00:00',50000,0,793,50793,'completed','2026-03-12 16:00:00','2026-03-12 16:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(58,3,'3312416467191739','Dewi Lestari','Jl. Contoh No. 44, Purwokerto','08989674847','2026-03-03 17:00:00','2026-03-03 23:00:00',60000,0,837,60837,'completed','2026-03-03 17:00:00','2026-03-03 17:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(59,2,'3312855172088819','Fajar Nugroho','Jl. Contoh No. 79, Purwokerto','08671522522','2026-03-16 08:00:00','2026-03-16 14:00:00',57000,0,912,57912,'completed','2026-03-16 08:00:00','2026-03-16 08:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(60,3,'3312473919164048','Rudi Hermawan','Jl. Contoh No. 62, Purwokerto','08501862556','2026-03-24 19:00:00','2026-03-24 22:00:00',30000,0,972,30972,'completed','2026-03-24 19:00:00','2026-03-24 19:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(61,3,'3312800706911073','Budi Santoso','Jl. Contoh No. 77, Purwokerto','08894380805','2026-03-18 14:00:00','2026-03-18 16:00:00',20000,0,524,20524,'completed','2026-03-18 14:00:00','2026-03-18 14:00:00','transfer',0,NULL,0,NULL);
INSERT INTO rentals VALUES(62,2,'3312930881114182','Ani Suryani','Jl. Contoh No. 44, Purwokerto','08721676001','2026-03-15 14:00:00','2026-03-15 17:00:00',28500,0,621,29121,'completed','2026-03-15 14:00:00','2026-03-15 14:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(63,3,'3312717332605131','Dewi Lestari','Jl. Contoh No. 60, Purwokerto','08283312491','2026-03-21 11:00:00','2026-03-21 16:00:00',50000,0,299,50299,'completed','2026-03-21 11:00:00','2026-03-21 11:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(64,3,'3312081862377075','Fajar Nugroho','Jl. Contoh No. 13, Purwokerto','08595598331','2026-03-12 18:00:00','2026-03-12 22:00:00',40000,0,716,40716,'completed','2026-03-12 18:00:00','2026-03-12 18:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(65,2,'3312209014544807','Dewi Lestari','Jl. Contoh No. 90, Purwokerto','08457496065','2026-03-04 09:00:00','2026-03-04 15:00:00',57000,0,165,57165,'completed','2026-03-04 09:00:00','2026-03-04 09:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(66,3,'3312139310627049','Dewi Lestari','Jl. Contoh No. 87, Purwokerto','08914574665','2026-03-08 12:00:00','2026-03-08 16:00:00',40000,0,465,40465,'completed','2026-03-08 12:00:00','2026-03-08 12:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(67,3,'3312175701328546','Budi Santoso','Jl. Contoh No. 25, Purwokerto','08387984033','2026-03-19 14:00:00','2026-03-19 21:00:00',70000,0,479,70479,'completed','2026-03-19 14:00:00','2026-03-19 14:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(68,2,'3312880675872684','Hendra Kusuma','Jl. Contoh No. 21, Purwokerto','08327120696','2026-03-07 12:00:00','2026-03-07 17:00:00',47500,0,607,48107,'completed','2026-03-07 12:00:00','2026-03-07 12:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(69,4,'3312767241704419','Maya Putri','Jl. Contoh No. 68, Purwokerto','08359780602','2026-03-21 11:00:00','2026-03-21 13:00:00',40000,0,855,40855,'completed','2026-03-21 11:00:00','2026-03-21 11:00:00','transfer',0,NULL,0,NULL);
INSERT INTO rentals VALUES(70,4,'3312149732980001','Hendra Kusuma','Jl. Contoh No. 24, Purwokerto','08901084599','2026-03-27 10:00:00','2026-03-27 14:00:00',80000,0,403,80403,'completed','2026-03-27 10:00:00','2026-03-27 10:00:00','transfer',0,NULL,0,NULL);
INSERT INTO rentals VALUES(71,2,'3312842473473485','Ani Suryani','Jl. Contoh No. 83, Purwokerto','08628137557','2026-04-04 13:00:00','2026-04-04 19:00:00',57000,0,564,57564,'completed','2026-04-04 13:00:00','2026-04-04 13:00:00','transfer',0,NULL,0,NULL);
INSERT INTO rentals VALUES(72,4,'3312661182901473','Andi Wijaya','Jl. Contoh No. 11, Purwokerto','08307671871','2026-04-06 11:00:00','2026-04-06 19:00:00',160000,0,984,160984,'completed','2026-04-06 11:00:00','2026-04-06 11:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(73,2,'3312251644511116','Maya Putri','Jl. Contoh No. 28, Purwokerto','08467758286','2026-04-07 18:00:00','2026-04-07 20:00:00',19000,0,215,19215,'completed','2026-04-07 18:00:00','2026-04-07 18:00:00','transfer',0,NULL,0,NULL);
INSERT INTO rentals VALUES(74,2,'3312307094615592','Siti Rahayu','Jl. Contoh No. 23, Purwokerto','08451160845','2026-04-01 18:00:00','2026-04-02 01:00:00',66500,0,166,66666,'completed','2026-04-01 18:00:00','2026-04-01 18:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(75,3,'3312893007368684','Dian Permata','Jl. Contoh No. 52, Purwokerto','08281837493','2026-04-02 12:00:00','2026-04-02 16:00:00',40000,0,930,40930,'completed','2026-04-02 12:00:00','2026-04-02 12:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(76,2,'3312773624824101','Hendra Kusuma','Jl. Contoh No. 13, Purwokerto','08383083882','2026-04-01 13:00:00','2026-04-01 21:00:00',76000,0,944,76944,'completed','2026-04-01 13:00:00','2026-04-01 13:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(77,3,'3312229015209313','Fajar Nugroho','Jl. Contoh No. 52, Purwokerto','08236201743','2026-04-02 14:00:00','2026-04-02 21:00:00',70000,0,269,70269,'completed','2026-04-02 14:00:00','2026-04-02 14:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(78,3,'3312986158280411','Hendra Kusuma','Jl. Contoh No. 19, Purwokerto','08727303254','2026-04-02 12:00:00','2026-04-02 19:00:00',70000,0,147,70147,'completed','2026-04-02 12:00:00','2026-04-02 12:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(79,2,'3312991636860420','Dian Permata','Jl. Contoh No. 42, Purwokerto','08412712879','2026-04-06 08:00:00','2026-04-06 11:00:00',28500,0,658,29158,'completed','2026-04-06 08:00:00','2026-04-06 08:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(80,3,'3312002298983124','Fajar Nugroho','Jl. Contoh No. 49, Purwokerto','08446095972','2026-04-10 19:00:00','2026-04-11 02:00:00',70000,0,841,110841,'completed','2026-04-10 19:00:00','2026-04-11 01:12:10','transfer',0,'qris',40000,NULL);
INSERT INTO rentals VALUES(81,4,'3312007447048946','Rudi Hermawan','Jl. Contoh No. 5, Purwokerto','08116176642','2026-04-07 10:00:00','2026-04-07 17:00:00',140000,0,134,140134,'paid','2026-04-07 10:00:00','2026-04-11 01:12:42','transfer',0,NULL,0,NULL);
INSERT INTO rentals VALUES(82,3,'3312668906426805','Siti Rahayu','Jl. Contoh No. 2, Purwokerto','08405281673','2026-04-05 08:00:00','2026-04-05 11:00:00',30000,0,353,30353,'pending','2026-04-05 08:00:00','2026-04-05 08:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(83,2,'rewr','er','re','ew','2026-04-09 08:27:00','2026-04-10 08:27:00',150000,150000,606,606,'pending','2026-04-11 01:27:37','2026-04-11 01:27:37','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(84,4,'o','o9oo','ooo','ooo','2026-04-10 08:42:00','2026-04-11 08:42:00',400000,140000,684,260684,'pending','2026-04-11 01:43:13','2026-04-11 01:43:13','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(85,2,'543425','34231','453423','534231','2026-04-10 08:48:00','2026-04-18 08:48:00',1200000,420000,625,780625,'cancelled','2026-04-11 01:49:24','2026-04-11 01:49:39','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(86,2,'u78i','8','789','89','2026-04-11 08:50:00','2026-04-12 08:50:00',150000,52500,520,98020,'pending','2026-04-11 01:50:58','2026-04-11 01:50:58','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(87,4,'583892','SINGGIH','ndjdj','0824882928','2026-04-11 08:57:00','2026-04-12 08:57:00',400000,140000,240,260240,'paid','2026-04-11 01:58:02','2026-04-11 01:59:31','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(88,3,'3312001323519318','Rudi Hermawan','Jl. Contoh No. 42, Purwokerto','08395877778','2026-01-02 17:00:00','2026-01-03 00:00:00',70000,0,755,70755,'completed','2026-01-02 17:00:00','2026-01-02 17:00:00','transfer',0,NULL,0,NULL);
INSERT INTO rentals VALUES(89,4,'3312064003540196','Siti Rahayu','Jl. Contoh No. 96, Purwokerto','08376172680','2026-01-01 12:00:00','2026-01-01 14:00:00',40000,0,986,40986,'completed','2026-01-01 12:00:00','2026-01-01 12:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(90,2,'3312717576409811','Budi Santoso','Jl. Contoh No. 56, Purwokerto','08967859154','2026-01-04 13:00:00','2026-01-04 21:00:00',76000,0,399,76399,'completed','2026-01-04 13:00:00','2026-01-04 13:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(91,4,'3312898902384966','Budi Santoso','Jl. Contoh No. 20, Purwokerto','08570711888','2026-01-14 12:00:00','2026-01-14 17:00:00',100000,0,914,100914,'completed','2026-01-14 12:00:00','2026-01-14 12:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(92,2,'3312793896959914','Siti Rahayu','Jl. Contoh No. 66, Purwokerto','08222884142','2026-01-13 18:00:00','2026-01-14 01:00:00',66500,0,180,66680,'completed','2026-01-13 18:00:00','2026-01-13 18:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(93,4,'3312533344871175','Ani Suryani','Jl. Contoh No. 59, Purwokerto','08150950373','2026-01-07 14:00:00','2026-01-07 22:00:00',160000,0,518,160518,'completed','2026-01-07 14:00:00','2026-01-07 14:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(94,3,'3312404474459182','Maya Putri','Jl. Contoh No. 9, Purwokerto','08179890470','2026-01-09 09:00:00','2026-01-09 15:00:00',60000,0,599,60599,'completed','2026-01-09 09:00:00','2026-01-09 09:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(95,4,'3312233190948797','Ani Suryani','Jl. Contoh No. 24, Purwokerto','08233053691','2026-01-31 09:00:00','2026-01-31 11:00:00',40000,0,393,40393,'completed','2026-01-31 09:00:00','2026-01-31 09:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(96,4,'3312785403935038','Maya Putri','Jl. Contoh No. 55, Purwokerto','08810746526','2026-01-04 19:00:00','2026-01-04 21:00:00',40000,0,987,40987,'completed','2026-01-04 19:00:00','2026-01-04 19:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(97,4,'3312674033966300','Maya Putri','Jl. Contoh No. 18, Purwokerto','08113609633','2026-01-07 18:00:00','2026-01-07 23:00:00',100000,0,138,100138,'completed','2026-01-07 18:00:00','2026-01-07 18:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(98,3,'3312136972617246','Budi Santoso','Jl. Contoh No. 77, Purwokerto','08845735934','2026-01-16 09:00:00','2026-01-16 13:00:00',40000,0,219,40219,'completed','2026-01-16 09:00:00','2026-01-16 09:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(99,4,'3312191719062087','Maya Putri','Jl. Contoh No. 57, Purwokerto','08442727338','2026-01-12 16:00:00','2026-01-13 00:00:00',160000,0,827,160827,'completed','2026-01-12 16:00:00','2026-01-12 16:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(100,3,'3312401721059343','Ani Suryani','Jl. Contoh No. 89, Purwokerto','08904496105','2026-01-02 19:00:00','2026-01-03 03:00:00',80000,0,354,80354,'completed','2026-01-02 19:00:00','2026-01-02 19:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(101,4,'3312744020661999','Dewi Lestari','Jl. Contoh No. 59, Purwokerto','08878340550','2026-01-13 10:00:00','2026-01-13 17:00:00',140000,0,785,140785,'completed','2026-01-13 10:00:00','2026-01-13 10:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(102,3,'3312573111946386','Hendra Kusuma','Jl. Contoh No. 59, Purwokerto','08970868133','2026-01-21 12:00:00','2026-01-21 15:00:00',30000,0,686,30686,'completed','2026-01-21 12:00:00','2026-01-21 12:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(103,4,'3312169842296095','Ani Suryani','Jl. Contoh No. 28, Purwokerto','08405142466','2026-01-22 13:00:00','2026-01-22 20:00:00',140000,0,366,140366,'completed','2026-01-22 13:00:00','2026-01-22 13:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(104,4,'3312438566130682','Budi Santoso','Jl. Contoh No. 9, Purwokerto','08140090083','2026-01-31 10:00:00','2026-01-31 13:00:00',60000,0,918,60918,'completed','2026-01-31 10:00:00','2026-01-31 10:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(105,4,'3312575293439026','Dewi Lestari','Jl. Contoh No. 35, Purwokerto','08577107625','2026-01-15 16:00:00','2026-01-15 23:00:00',140000,0,149,140149,'completed','2026-01-15 16:00:00','2026-01-15 16:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(106,2,'3312082823462666','Andi Wijaya','Jl. Contoh No. 89, Purwokerto','08261824149','2026-02-04 15:00:00','2026-02-04 22:00:00',66500,0,898,67398,'completed','2026-02-04 15:00:00','2026-02-04 15:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(107,3,'3312555218344619','Andi Wijaya','Jl. Contoh No. 51, Purwokerto','08682558768','2026-02-05 08:00:00','2026-02-05 10:00:00',20000,0,300,20300,'completed','2026-02-05 08:00:00','2026-02-05 08:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(108,4,'3312056085163361','Hendra Kusuma','Jl. Contoh No. 7, Purwokerto','08642967340','2026-02-11 11:00:00','2026-02-11 17:00:00',120000,0,453,120453,'completed','2026-02-11 11:00:00','2026-02-11 11:00:00','transfer',0,NULL,0,NULL);
INSERT INTO rentals VALUES(109,3,'3312116501438899','Dian Permata','Jl. Contoh No. 91, Purwokerto','08665399909','2026-02-24 11:00:00','2026-02-24 16:00:00',50000,0,542,50542,'completed','2026-02-24 11:00:00','2026-02-24 11:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(110,2,'3312068684427084','Ani Suryani','Jl. Contoh No. 24, Purwokerto','08254290001','2026-02-22 12:00:00','2026-02-22 16:00:00',38000,0,625,38625,'completed','2026-02-22 12:00:00','2026-02-22 12:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(111,3,'3312813308531192','Budi Santoso','Jl. Contoh No. 35, Purwokerto','08747048240','2026-02-05 15:00:00','2026-02-05 21:00:00',60000,0,343,60343,'completed','2026-02-05 15:00:00','2026-02-05 15:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(112,4,'3312552447813968','Fajar Nugroho','Jl. Contoh No. 38, Purwokerto','08238125035','2026-02-19 18:00:00','2026-02-19 22:00:00',80000,0,733,80733,'completed','2026-02-19 18:00:00','2026-02-19 18:00:00','transfer',0,NULL,0,NULL);
INSERT INTO rentals VALUES(113,2,'3312948047307230','Ani Suryani','Jl. Contoh No. 14, Purwokerto','08700839842','2026-02-21 18:00:00','2026-02-22 02:00:00',76000,0,964,76964,'completed','2026-02-21 18:00:00','2026-02-21 18:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(114,3,'3312978231610503','Fajar Nugroho','Jl. Contoh No. 47, Purwokerto','08169082325','2026-02-24 09:00:00','2026-02-24 16:00:00',70000,0,480,70480,'completed','2026-02-24 09:00:00','2026-02-24 09:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(115,2,'3312773951596349','Dewi Lestari','Jl. Contoh No. 50, Purwokerto','08267250060','2026-02-17 18:00:00','2026-02-18 02:00:00',76000,0,126,76126,'completed','2026-02-17 18:00:00','2026-02-17 18:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(116,2,'3312241899920948','Dian Permata','Jl. Contoh No. 2, Purwokerto','08279639222','2026-02-01 12:00:00','2026-02-01 16:00:00',38000,0,900,38900,'completed','2026-02-01 12:00:00','2026-02-01 12:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(117,2,'3312682806134364','Hendra Kusuma','Jl. Contoh No. 32, Purwokerto','08207829984','2026-02-16 09:00:00','2026-02-16 13:00:00',38000,0,451,38451,'completed','2026-02-16 09:00:00','2026-02-16 09:00:00','transfer',0,NULL,0,NULL);
INSERT INTO rentals VALUES(118,2,'3312033029403111','Budi Santoso','Jl. Contoh No. 3, Purwokerto','08335874379','2026-02-10 08:00:00','2026-02-10 15:00:00',66500,0,536,67036,'completed','2026-02-10 08:00:00','2026-02-10 08:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(119,3,'3312953629771193','Andi Wijaya','Jl. Contoh No. 16, Purwokerto','08818014513','2026-02-07 15:00:00','2026-02-07 23:00:00',80000,0,435,80435,'completed','2026-02-07 15:00:00','2026-02-07 15:00:00','transfer',0,NULL,0,NULL);
INSERT INTO rentals VALUES(120,4,'3312000376459220','Rudi Hermawan','Jl. Contoh No. 98, Purwokerto','08264964587','2026-02-16 19:00:00','2026-02-16 23:00:00',80000,0,998,80998,'completed','2026-02-16 19:00:00','2026-02-16 19:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(121,4,'3312152161867526','Dian Permata','Jl. Contoh No. 14, Purwokerto','08998664774','2026-02-01 11:00:00','2026-02-01 13:00:00',40000,0,827,40827,'completed','2026-02-01 11:00:00','2026-02-01 11:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(122,4,'3312380664770956','Dian Permata','Jl. Contoh No. 78, Purwokerto','08420636965','2026-02-10 11:00:00','2026-02-10 17:00:00',120000,0,699,120699,'completed','2026-02-10 11:00:00','2026-02-10 11:00:00','transfer',0,NULL,0,NULL);
INSERT INTO rentals VALUES(123,4,'3312299110611928','Fajar Nugroho','Jl. Contoh No. 84, Purwokerto','08234845595','2026-02-14 18:00:00','2026-02-14 20:00:00',40000,0,336,40336,'completed','2026-02-14 18:00:00','2026-02-14 18:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(124,2,'3312205948532031','Budi Santoso','Jl. Contoh No. 56, Purwokerto','08517805803','2026-02-27 19:00:00','2026-02-27 21:00:00',19000,0,952,19952,'completed','2026-02-27 19:00:00','2026-02-27 19:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(125,4,'3312666041806973','Hendra Kusuma','Jl. Contoh No. 75, Purwokerto','08753124841','2026-02-05 14:00:00','2026-02-05 18:00:00',80000,0,619,80619,'completed','2026-02-05 14:00:00','2026-02-05 14:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(126,4,'3312974932125111','Rudi Hermawan','Jl. Contoh No. 58, Purwokerto','08642536762','2026-02-10 09:00:00','2026-02-10 12:00:00',60000,0,116,60116,'completed','2026-02-10 09:00:00','2026-02-10 09:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(127,3,'3312672923159242','Ani Suryani','Jl. Contoh No. 23, Purwokerto','08114585847','2026-02-26 15:00:00','2026-02-26 18:00:00',30000,0,917,30917,'completed','2026-02-26 15:00:00','2026-02-26 15:00:00','transfer',0,NULL,0,NULL);
INSERT INTO rentals VALUES(128,4,'3312619265309674','Maya Putri','Jl. Contoh No. 16, Purwokerto','08874568746','2026-03-22 16:00:00','2026-03-22 22:00:00',120000,0,114,120114,'completed','2026-03-22 16:00:00','2026-03-22 16:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(129,3,'3312378259494280','Rudi Hermawan','Jl. Contoh No. 82, Purwokerto','08193785619','2026-03-11 09:00:00','2026-03-11 12:00:00',30000,0,839,30839,'completed','2026-03-11 09:00:00','2026-03-11 09:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(130,4,'3312220284222278','Dewi Lestari','Jl. Contoh No. 99, Purwokerto','08158227268','2026-03-25 19:00:00','2026-03-25 22:00:00',60000,0,928,60928,'completed','2026-03-25 19:00:00','2026-03-25 19:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(131,4,'3312432022770896','Dian Permata','Jl. Contoh No. 23, Purwokerto','08789707789','2026-03-01 14:00:00','2026-03-01 20:00:00',120000,0,749,120749,'completed','2026-03-01 14:00:00','2026-03-01 14:00:00','transfer',0,NULL,0,NULL);
INSERT INTO rentals VALUES(132,4,'3312562596561793','Rudi Hermawan','Jl. Contoh No. 2, Purwokerto','08145990809','2026-03-12 14:00:00','2026-03-12 21:00:00',140000,0,935,140935,'completed','2026-03-12 14:00:00','2026-03-12 14:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(133,4,'3312886733549238','Hendra Kusuma','Jl. Contoh No. 54, Purwokerto','08808985030','2026-03-04 09:00:00','2026-03-04 12:00:00',60000,0,588,60588,'completed','2026-03-04 09:00:00','2026-03-04 09:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(134,3,'3312890599299222','Fajar Nugroho','Jl. Contoh No. 96, Purwokerto','08540445695','2026-03-15 17:00:00','2026-03-15 23:00:00',60000,0,658,60658,'completed','2026-03-15 17:00:00','2026-03-15 17:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(135,3,'3312287596587536','Maya Putri','Jl. Contoh No. 57, Purwokerto','08165774623','2026-03-07 12:00:00','2026-03-07 18:00:00',60000,0,133,60133,'completed','2026-03-07 12:00:00','2026-03-07 12:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(136,2,'3312391458483832','Budi Santoso','Jl. Contoh No. 31, Purwokerto','08731889099','2026-03-01 19:00:00','2026-03-02 02:00:00',66500,0,607,67107,'completed','2026-03-01 19:00:00','2026-03-01 19:00:00','transfer',0,NULL,0,NULL);
INSERT INTO rentals VALUES(137,4,'3312816473933971','Budi Santoso','Jl. Contoh No. 58, Purwokerto','08664162336','2026-03-12 15:00:00','2026-03-12 19:00:00',80000,0,391,80391,'completed','2026-03-12 15:00:00','2026-03-12 15:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(138,3,'3312574428417898','Hendra Kusuma','Jl. Contoh No. 28, Purwokerto','08839715413','2026-03-06 09:00:00','2026-03-06 11:00:00',20000,0,555,20555,'completed','2026-03-06 09:00:00','2026-03-06 09:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(139,4,'3312902845902384','Fajar Nugroho','Jl. Contoh No. 79, Purwokerto','08344077075','2026-03-09 09:00:00','2026-03-09 17:00:00',160000,0,594,160594,'completed','2026-03-09 09:00:00','2026-03-09 09:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(140,4,'3312108255092056','Andi Wijaya','Jl. Contoh No. 10, Purwokerto','08133901670','2026-03-04 09:00:00','2026-03-04 12:00:00',60000,0,655,60655,'completed','2026-03-04 09:00:00','2026-03-04 09:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(141,2,'3312091164547050','Fajar Nugroho','Jl. Contoh No. 29, Purwokerto','08349626509','2026-03-16 10:00:00','2026-03-16 15:00:00',47500,0,895,48395,'completed','2026-03-16 10:00:00','2026-03-16 10:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(142,2,'3312175408033642','Maya Putri','Jl. Contoh No. 13, Purwokerto','08434436582','2026-03-22 10:00:00','2026-03-22 14:00:00',38000,0,513,38513,'completed','2026-03-22 10:00:00','2026-03-22 10:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(143,2,'3312864666147775','Maya Putri','Jl. Contoh No. 40, Purwokerto','08164263767','2026-03-05 14:00:00','2026-03-05 21:00:00',66500,0,439,66939,'completed','2026-03-05 14:00:00','2026-03-05 14:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(144,4,'3312421990056495','Budi Santoso','Jl. Contoh No. 10, Purwokerto','08563098536','2026-03-29 12:00:00','2026-03-29 20:00:00',160000,0,547,160547,'completed','2026-03-29 12:00:00','2026-03-29 12:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(145,3,'3312572725296680','Dian Permata','Jl. Contoh No. 87, Purwokerto','08889767328','2026-03-14 15:00:00','2026-03-14 23:00:00',80000,0,150,80150,'completed','2026-03-14 15:00:00','2026-03-14 15:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(146,2,'3312948986234247','Dewi Lestari','Jl. Contoh No. 89, Purwokerto','08260392190','2026-03-21 12:00:00','2026-03-21 19:00:00',66500,0,182,66682,'completed','2026-03-21 12:00:00','2026-03-21 12:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(147,3,'3312786277159302','Hendra Kusuma','Jl. Contoh No. 45, Purwokerto','08663661483','2026-03-27 13:00:00','2026-03-27 16:00:00',30000,0,272,30272,'completed','2026-03-27 13:00:00','2026-03-27 13:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(148,2,'3312148270399143','Dian Permata','Jl. Contoh No. 73, Purwokerto','08876323182','2026-03-23 12:00:00','2026-03-23 19:00:00',66500,0,842,67342,'completed','2026-03-23 12:00:00','2026-03-23 12:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(149,2,'3312405830061110','Maya Putri','Jl. Contoh No. 10, Purwokerto','08473480699','2026-03-10 16:00:00','2026-03-10 18:00:00',19000,0,260,19260,'completed','2026-03-10 16:00:00','2026-03-10 16:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(150,4,'3312472524159919','Rudi Hermawan','Jl. Contoh No. 9, Purwokerto','08255803841','2026-03-10 17:00:00','2026-03-10 22:00:00',100000,0,234,100234,'completed','2026-03-10 17:00:00','2026-03-10 17:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(151,2,'3312283201406840','Budi Santoso','Jl. Contoh No. 71, Purwokerto','08981427197','2026-03-11 15:00:00','2026-03-11 20:00:00',47500,0,689,48189,'completed','2026-03-11 15:00:00','2026-03-11 15:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(152,3,'3312148659186122','Budi Santoso','Jl. Contoh No. 92, Purwokerto','08313398764','2026-03-10 19:00:00','2026-03-11 01:00:00',60000,0,120,60120,'completed','2026-03-10 19:00:00','2026-03-10 19:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(153,4,'3312099506514793','Rudi Hermawan','Jl. Contoh No. 18, Purwokerto','08527453149','2026-03-19 16:00:00','2026-03-19 19:00:00',60000,0,260,60260,'completed','2026-03-19 16:00:00','2026-03-19 16:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(154,4,'3312689324763091','Andi Wijaya','Jl. Contoh No. 54, Purwokerto','08480130942','2026-03-14 12:00:00','2026-03-14 16:00:00',80000,0,197,80197,'completed','2026-03-14 12:00:00','2026-03-14 12:00:00','transfer',0,NULL,0,NULL);
INSERT INTO rentals VALUES(155,2,'3312333523383304','Dewi Lestari','Jl. Contoh No. 14, Purwokerto','08586788960','2026-03-24 09:00:00','2026-03-24 14:00:00',47500,0,704,48204,'completed','2026-03-24 09:00:00','2026-03-24 09:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(156,4,'3312025321152853','Budi Santoso','Jl. Contoh No. 51, Purwokerto','08207833861','2026-03-22 15:00:00','2026-03-22 19:00:00',80000,0,761,80761,'completed','2026-03-22 15:00:00','2026-03-22 15:00:00','transfer',0,NULL,0,NULL);
INSERT INTO rentals VALUES(157,3,'3312908277333172','Ani Suryani','Jl. Contoh No. 85, Purwokerto','08593975447','2026-03-07 18:00:00','2026-03-07 20:00:00',20000,0,860,20860,'completed','2026-03-07 18:00:00','2026-03-07 18:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(158,4,'3312570890967342','Budi Santoso','Jl. Contoh No. 43, Purwokerto','08231902375','2026-04-10 11:00:00','2026-04-10 17:00:00',120000,0,863,120863,'completed','2026-04-10 11:00:00','2026-04-10 11:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(159,2,'3312464093552935','Andi Wijaya','Jl. Contoh No. 4, Purwokerto','08846422699','2026-04-01 13:00:00','2026-04-01 15:00:00',19000,0,142,19142,'completed','2026-04-01 13:00:00','2026-04-01 13:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(160,2,'3312454501655965','Rudi Hermawan','Jl. Contoh No. 1, Purwokerto','08415397531','2026-04-09 10:00:00','2026-04-09 17:00:00',66500,0,494,66994,'completed','2026-04-09 10:00:00','2026-04-09 10:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(161,4,'3312132909909685','Fajar Nugroho','Jl. Contoh No. 22, Purwokerto','08481891545','2026-04-01 16:00:00','2026-04-01 20:00:00',80000,0,768,80768,'completed','2026-04-01 16:00:00','2026-04-01 16:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(162,3,'3312373304763953','Dewi Lestari','Jl. Contoh No. 77, Purwokerto','08564031096','2026-04-11 09:00:00','2026-04-11 17:00:00',80000,0,294,80294,'completed','2026-04-11 09:00:00','2026-04-11 09:00:00','transfer',0,NULL,0,NULL);
INSERT INTO rentals VALUES(163,3,'3312541911246744','Fajar Nugroho','Jl. Contoh No. 65, Purwokerto','08832940366','2026-04-05 11:00:00','2026-04-05 18:00:00',70000,0,720,70720,'completed','2026-04-05 11:00:00','2026-04-05 11:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(164,3,'3312198026537982','Rudi Hermawan','Jl. Contoh No. 34, Purwokerto','08361303333','2026-04-08 16:00:00','2026-04-08 22:00:00',60000,0,496,60496,'completed','2026-04-08 16:00:00','2026-04-08 16:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(165,4,'3312944348971474','Siti Rahayu','Jl. Contoh No. 26, Purwokerto','08975553704','2026-04-03 16:00:00','2026-04-04 00:00:00',160000,0,520,160520,'completed','2026-04-03 16:00:00','2026-04-03 16:00:00','qris',0,NULL,0,NULL);
INSERT INTO rentals VALUES(166,3,'3312190927585052','Siti Rahayu','Jl. Contoh No. 58, Purwokerto','08259118366','2026-04-01 13:00:00','2026-04-01 17:00:00',40000,0,374,40374,'completed','2026-04-01 13:00:00','2026-04-01 13:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(167,3,'3312147268005807','Andi Wijaya','Jl. Contoh No. 32, Purwokerto','08478641051','2026-04-03 10:00:00','2026-04-03 15:00:00',50000,0,726,50726,'paid','2026-04-03 10:00:00','2026-04-03 10:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(168,2,'3312026093879466','Budi Santoso','Jl. Contoh No. 91, Purwokerto','08153294671','2026-04-03 14:00:00','2026-04-03 16:00:00',19000,0,860,19860,'pending','2026-04-03 14:00:00','2026-04-03 14:00:00','cash',0,NULL,0,NULL);
INSERT INTO rentals VALUES(169,2,'3312372746331715','Siti Rahayu','Jl. Contoh No. 1, Purwokerto','08778143616','2026-04-04 18:00:00','2026-04-05 01:00:00',66500,0,398,66898,'pending','2026-04-04 18:00:00','2026-04-04 18:00:00','qris',0,NULL,0,NULL);
CREATE TABLE IF NOT EXISTS "settings" ("id" integer primary key autoincrement not null, "key" varchar not null, "value" text, "created_at" datetime, "updated_at" datetime);
INSERT INTO settings VALUES(1,'home_title','Sewa iPhone Mudah, Cepat, dan Aman','2026-04-10 23:23:38','2026-04-10 23:23:49');
INSERT INTO settings VALUES(2,'home_description','Pilih tipe iPhone sesuai kebutuhan Anda. Bebas atur jadwal sewa, harga bersahabat, tanpa syarat ribet!','2026-04-10 23:23:38','2026-04-10 23:23:38');
INSERT INTO settings VALUES(3,'late_tolerance_minutes','60','2026-04-10 23:23:38','2026-04-10 23:23:38');
INSERT INTO settings VALUES(4,'admin_wa','6281234567890','2026-04-11 00:08:15','2026-04-11 00:08:15');
INSERT INTO settings VALUES(5,'admin_address','Jl. BP Pereng, Pereng, Sokanegara, Purwokerto','2026-04-11 00:08:15','2026-04-11 01:48:04');
INSERT INTO settings VALUES(6,'terms_conditions',unistr('Penyewa wajib menjaga iPhone yang disewa dan bertanggung jawab atas kerusakan atau kehilangan selama masa sewa.\u000aPembayaran dilakukan di awal sebelum unit diserahkan, sesuai total tagihan yang tertera.\u000aKeterlambatan pengembalian melewati batas toleransi waktu akan dikenakan denda yang ditentukan oleh pengelola.\u000aPengelola berhak menolak penyewaan apabila dokumen identitas (NIK/KTP) tidak valid atau tidak sesuai.\u000aPemesanan yang sudah terkonfirmasi tidak dapat dibatalkan secara sepihak oleh penyewa.'),'2026-04-11 00:08:15','2026-04-11 00:08:15');
INSERT INTO settings VALUES(7,'payment_methods','{"qris":true,"cash":true,"transfer":false}','2026-04-11 00:20:52','2026-04-11 00:27:44');
INSERT INTO settings VALUES(8,'about_faq_items','[{"question":"pp","answer":"pppp"}]','2026-04-11 04:02:15','2026-04-11 04:02:15');
CREATE TABLE IF NOT EXISTS "units" ("id" integer primary key autoincrement not null, "seri" varchar not null, "imei" varchar, "memori" varchar, "warna" varchar, "kondisi" text, "harga_per_jam" numeric not null default ('0'), "harga_per_hari" numeric not null default ('0'), "is_active" tinyint(1) not null default ('1'), "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, "kategori" varchar not null default 'iphone');
INSERT INTO units VALUES(2,'iPhone 13','6543423','256 GB','Black','Muluss',9500,150000,1,'2026-04-10 22:15:35','2026-04-11 00:51:17',NULL,'iphone');
INSERT INTO units VALUES(3,'iPhone 16','7543232','128 GB','White','mulus',10000,190000,1,'2026-04-10 22:18:29','2026-04-11 00:51:24',NULL,'iphone');
INSERT INTO units VALUES(4,'iPhone 19','4323','512 GB','Black','mulusss',20000,400000,1,'2026-04-10 22:25:19','2026-04-10 22:29:30',NULL,'iphone');
INSERT INTO sqlite_sequence VALUES('migrations',16);
INSERT INTO sqlite_sequence VALUES('users',5);
INSERT INTO sqlite_sequence VALUES('settings',8);
INSERT INTO sqlite_sequence VALUES('pricing_rules',12);
INSERT INTO sqlite_sequence VALUES('rentals',169);
INSERT INTO sqlite_sequence VALUES('units',4);
CREATE UNIQUE INDEX "users_email_unique" on "users" ("email");
CREATE INDEX "sessions_user_id_index" on "sessions" ("user_id");
CREATE INDEX "sessions_last_activity_index" on "sessions" ("last_activity");
CREATE INDEX "cache_expiration_index" on "cache" ("expiration");
CREATE INDEX "cache_locks_expiration_index" on "cache_locks" ("expiration");
CREATE INDEX "jobs_queue_index" on "jobs" ("queue");
CREATE UNIQUE INDEX "failed_jobs_uuid_unique" on "failed_jobs" ("uuid");
CREATE UNIQUE INDEX "settings_key_unique" on "settings" ("key");
CREATE UNIQUE INDEX "units_imei_unique" on "units" ("imei");
COMMIT;
