-- ============================================================ -- Gedoong CRM — Demo Data (phpMyAdmin / cPanel) -- Password semua akun: password123 -- -- Jalankan SETELAH: -- 1. schema-cpanel.sql -- 2. tables-advanced.sql -- -- PERINGATAN: Menghapus semua data di tabel utama sebelum insert. -- ============================================================ SET FOREIGN_KEY_CHECKS = 0; TRUNCATE TABLE `commissions`; TRUNCATE TABLE `clients`; TRUNCATE TABLE `listings`; TRUNCATE TABLE `users`; SET FOREIGN_KEY_CHECKS = 1; -- users (3 akun demo) INSERT INTO `users` (`id`, `email`, `password`, `name`, `phone`, `role`, `is_active`) VALUES ('a0000000-0000-4000-8000-000000000001', 'admin@gedoong.com', '$2b$10$2N6x6U/NvtxliFkCaeLwROSjAYFFkWkAvpn5b.IDOgMOIGseeOWta', 'Admin Gedoong', '081100000001', 'admin', 1), ('a0000000-0000-4000-8000-000000000002', 'agent1@gedoong.com', '$2b$10$2N6x6U/NvtxliFkCaeLwROSjAYFFkWkAvpn5b.IDOgMOIGseeOWta', 'Budi Santoso', '081234567890', 'agent', 1), ('a0000000-0000-4000-8000-000000000003', 'agent2@gedoong.com', '$2b$10$2N6x6U/NvtxliFkCaeLwROSjAYFFkWkAvpn5b.IDOgMOIGseeOWta', 'Siti Rahayu', '081987654321', 'agent', 1); -- listings (6 properti) INSERT INTO `listings` (`id`, `title`, `description`, `address`, `city`, `province`, `postal_code`, `price`, `bedroom`, `bathroom`, `land_area`, `building_area`, `listing_type`, `status`, `images`, `views`, `is_featured`, `agent_id`, `created_at`, `updated_at`) VALUES ('b0000000-0000-4000-8000-000000000001', 'Rumah Minimalis 2 Lantai — BSD City', 'Rumah hook 2 lantai, siap huni. Dekat sekolah internasional dan mall.', 'Jl. Letnan Sutopo Blok A12 No. 8', 'Tangerang Selatan', 'Banten', '15310', 2850000000.00, 4, 3, '120.00', '180.00', 'sale', 'active', '["https://images.unsplash.com/photo-1600596542815-ffad4c1539a9?w=800","https://images.unsplash.com/photo-1600585154340-be6161a56a0c?w=800","https://images.unsplash.com/photo-1600047509807-ba8f99d2cd4f?w=800"]', 128, 1, 'a0000000-0000-4000-8000-000000000002', DATE_SUB(NOW(), INTERVAL 2 DAY), DATE_SUB(NOW(), INTERVAL 2 DAY)), ('b0000000-0000-4000-8000-000000000002', 'Apartemen Sudirman Park — 2BR Furnished', 'Unit tinggi, view city. Cocok investasi atau tempat tinggal.', 'Jl. KH Mas Mansyur Kav. 35', 'Jakarta Pusat', 'DKI Jakarta', '10220', 18500000.00, 2, 1, NULL, '68.00', 'rent', 'active', '["https://images.unsplash.com/photo-1600585154340-be6161a56a0c?w=800"]', 89, 1, 'a0000000-0000-4000-8000-000000000002', DATE_SUB(NOW(), INTERVAL 5 DAY), DATE_SUB(NOW(), INTERVAL 5 DAY)), ('b0000000-0000-4000-8000-000000000003', 'Ruko Strategis — Kemang', 'Ruko 3 lantai di kawasan ramai. Cocok F&B atau kantor.', 'Jl. Kemang Raya No. 45', 'Jakarta Selatan', 'DKI Jakarta', '12730', 5200000000.00, NULL, 2, '80.00', '240.00', 'sale', 'sold', '["https://images.unsplash.com/photo-1600047509807-ba8f99d2cd4f?w=800"]', 256, 0, 'a0000000-0000-4000-8000-000000000002', DATE_SUB(NOW(), INTERVAL 30 DAY), DATE_SUB(NOW(), INTERVAL 30 DAY)), ('b0000000-0000-4000-8000-000000000004', 'Tanah Kavling — Sentul', 'Tanah datar, sertifikat SHM, akses jalan 6 meter.', 'Cluster Green Hills Blok C5', 'Bogor', 'Jawa Barat', '16810', 950000000.00, NULL, NULL, '300.00', NULL, 'sale', 'off_market', NULL, 42, 0, 'a0000000-0000-4000-8000-000000000002', DATE_SUB(NOW(), INTERVAL 45 DAY), DATE_SUB(NOW(), INTERVAL 45 DAY)), ('b0000000-0000-4000-8000-000000000005', 'Villa Puncak View Pegunungan', 'Villa 3 kamar dengan kolam renang pribadi. Suasana sejuk.', 'Jl. Raya Puncak KM 78', 'Cisarua', 'Jawa Barat', '16750', 3400000000.00, 3, 3, '500.00', '220.00', 'sale', 'active', '["https://images.unsplash.com/photo-1600596542815-ffad4c1539a9?w=800","https://images.unsplash.com/photo-1600585154340-be6161a56a0c?w=800","https://images.unsplash.com/photo-1600047509807-ba8f99d2cd4f?w=800"]', 175, 1, 'a0000000-0000-4000-8000-000000000003', DATE_SUB(NOW(), INTERVAL 1 DAY), DATE_SUB(NOW(), INTERVAL 1 DAY)), ('b0000000-0000-4000-8000-000000000006', 'Kost Eksklusif — Tebet', 'Kost putri/putra, full AC, WiFi, laundry.', 'Jl. Tebet Timur Dalam No. 12', 'Jakarta Selatan', 'DKI Jakarta', '12820', 3500000.00, 1, 1, NULL, '18.00', 'rent', 'active', '["https://images.unsplash.com/photo-1600596542815-ffad4c1539a9?w=800"]', 63, 0, 'a0000000-0000-4000-8000-000000000003', DATE_SUB(NOW(), INTERVAL 7 DAY), DATE_SUB(NOW(), INTERVAL 7 DAY)), ('b0000000-0000-4000-8000-000000000007', 'Rumah Type 45 — Grand Wisata', 'Rumah subsidi ready stock, dekat tol JORR.', 'Cluster Melati Blok B2 No. 15', 'Bekasi', 'Jawa Barat', '17510', 680000000.00, 2, 1, '60.00', '45.00', 'sale', 'sold', '["https://images.unsplash.com/photo-1600585154340-be6161a56a0c?w=800"]', 312, 0, 'a0000000-0000-4000-8000-000000000003', DATE_SUB(NOW(), INTERVAL 20 DAY), DATE_SUB(NOW(), INTERVAL 20 DAY)); -- clients (10 klien — semua stage pipeline) INSERT INTO `clients` (`id`, `name`, `phone`, `email`, `source`, `stage`, `notes`, `listing_id`, `agent_id`, `created_at`, `updated_at`) VALUES ('c0000000-0000-4000-8000-000000000001', 'Andi Pratama', '081211111101', 'andi.pratama@email.com', 'website', 'prospect', 'Tanya soal KPR dan DP minimum.', 'b0000000-0000-4000-8000-000000000001', 'a0000000-0000-4000-8000-000000000002', DATE_SUB(NOW(), INTERVAL 1 DAY), DATE_SUB(NOW(), INTERVAL 1 DAY)), ('c0000000-0000-4000-8000-000000000002', 'Dewi Lestari', '081211111102', 'dewi.l@email.com', 'referral', 'show', 'Sudah jadwalkan viewing Sabtu pagi.', 'b0000000-0000-4000-8000-000000000001', 'a0000000-0000-4000-8000-000000000002', DATE_SUB(NOW(), INTERVAL 3 DAY), DATE_SUB(NOW(), INTERVAL 3 DAY)), ('c0000000-0000-4000-8000-000000000003', 'Rizky Hidayat', '081211111103', NULL, 'social_media', 'negotiation', 'Negosiasi harga sewa 12 bulan.', 'b0000000-0000-4000-8000-000000000002', 'a0000000-0000-4000-8000-000000000002', DATE_SUB(NOW(), INTERVAL 6 DAY), DATE_SUB(NOW(), INTERVAL 6 DAY)), ('c0000000-0000-4000-8000-000000000004', 'Maya Sari', '081211111104', 'maya.sari@email.com', 'walk_in', 'closing', 'Deal closed — menunggu akad.', 'b0000000-0000-4000-8000-000000000003', 'a0000000-0000-4000-8000-000000000002', DATE_SUB(NOW(), INTERVAL 10 DAY), DATE_SUB(NOW(), INTERVAL 10 DAY)), ('c0000000-0000-4000-8000-000000000005', 'Hendra Wijaya', '081211111105', 'hendra.w@email.com', 'other', 'lost', 'Pilih properti dari agen lain.', NULL, 'a0000000-0000-4000-8000-000000000002', DATE_SUB(NOW(), INTERVAL 14 DAY), DATE_SUB(NOW(), INTERVAL 14 DAY)), ('c0000000-0000-4000-8000-000000000006', 'Putri Anggraini', '081922222201', 'putri.a@email.com', 'referral', 'prospect', 'Cari villa untuk staycation keluarga.', 'b0000000-0000-4000-8000-000000000005', 'a0000000-0000-4000-8000-000000000003', DATE_SUB(NOW(), INTERVAL 2 DAY), DATE_SUB(NOW(), INTERVAL 2 DAY)), ('c0000000-0000-4000-8000-000000000007', 'Agus Setiawan', '081922222202', 'agus.s@email.com', 'website', 'show', 'Viewing villa minggu depan.', 'b0000000-0000-4000-8000-000000000005', 'a0000000-0000-4000-8000-000000000003', DATE_SUB(NOW(), INTERVAL 4 DAY), DATE_SUB(NOW(), INTERVAL 4 DAY)), ('c0000000-0000-4000-8000-000000000008', 'Lina Marlina', '081922222203', NULL, 'social_media', 'negotiation', 'Minta diskon untuk kontrak 6 bulan.', 'b0000000-0000-4000-8000-000000000006', 'a0000000-0000-4000-8000-000000000003', DATE_SUB(NOW(), INTERVAL 5 DAY), DATE_SUB(NOW(), INTERVAL 5 DAY)), ('c0000000-0000-4000-8000-000000000009', 'Fajar Nugroho', '081922222204', 'fajar.n@email.com', 'walk_in', 'closing', 'Sudah tanda tangan PPJB.', 'b0000000-0000-4000-8000-000000000007', 'a0000000-0000-4000-8000-000000000003', DATE_SUB(NOW(), INTERVAL 8 DAY), DATE_SUB(NOW(), INTERVAL 8 DAY)), ('c0000000-0000-4000-8000-00000000000a', 'Sari Indah', '081922222205', 'sari.i@email.com', 'other', 'lost', 'Budget tidak sesuai.', NULL, 'a0000000-0000-4000-8000-000000000003', DATE_SUB(NOW(), INTERVAL 12 DAY), DATE_SUB(NOW(), INTERVAL 12 DAY)); -- commissions (6 komisi — pending / paid / overdue) INSERT INTO `commissions` (`id`, `listing_id`, `agent_id`, `client_id`, `amount`, `percentage`, `status`, `due_date`, `paid_date`, `notes`, `created_at`, `updated_at`) VALUES ('d0000000-0000-4000-8000-000000000001', 'b0000000-0000-4000-8000-000000000003', 'a0000000-0000-4000-8000-000000000002', 'c0000000-0000-4000-8000-000000000004', 52000000.00, 1.00, 'paid', DATE_SUB(CURDATE(), INTERVAL 15 DAY), DATE_SUB(CURDATE(), INTERVAL 10 DAY), 'Komisi penjualan ruko Kemang.', NOW(), NOW()), ('d0000000-0000-4000-8000-000000000002', 'b0000000-0000-4000-8000-000000000001', 'a0000000-0000-4000-8000-000000000002', 'c0000000-0000-4000-8000-000000000003', 28500000.00, 1.00, 'pending', DATE_ADD(CURDATE(), INTERVAL 14 DAY), NULL, 'Menunggu akad KPR klien Rizky.', NOW(), NOW()), ('d0000000-0000-4000-8000-000000000003', 'b0000000-0000-4000-8000-000000000002', 'a0000000-0000-4000-8000-000000000002', 'c0000000-0000-4000-8000-000000000003', 2220000.00, 1.00, 'overdue', DATE_SUB(CURDATE(), INTERVAL 7 DAY), NULL, 'Komisi sewa apartemen — follow up pembayaran developer.', NOW(), NOW()), ('d0000000-0000-4000-8000-000000000004', 'b0000000-0000-4000-8000-000000000007', 'a0000000-0000-4000-8000-000000000003', 'c0000000-0000-4000-8000-00000000000a', 6800000.00, 1.00, 'paid', DATE_SUB(CURDATE(), INTERVAL 20 DAY), DATE_SUB(CURDATE(), INTERVAL 5 DAY), 'Komisi rumah type 45 Grand Wisata.', NOW(), NOW()), ('d0000000-0000-4000-8000-000000000005', 'b0000000-0000-4000-8000-000000000005', 'a0000000-0000-4000-8000-000000000003', 'c0000000-0000-4000-8000-000000000008', 34000000.00, 1.00, 'pending', DATE_ADD(CURDATE(), INTERVAL 21 DAY), NULL, 'Komisi villa Puncak — negosiasi final.', NOW(), NOW()), ('d0000000-0000-4000-8000-000000000006', 'b0000000-0000-4000-8000-000000000006', 'a0000000-0000-4000-8000-000000000003', 'c0000000-0000-4000-8000-000000000009', 350000.00, 10.00, 'overdue', DATE_SUB(CURDATE(), INTERVAL 3 DAY), NULL, 'Komisi sewa kost Tebet.', NOW(), NOW()); -- Akun demo: -- admin@gedoong.com / password123 (admin) -- agent1@gedoong.com / password123 (agent) -- agent2@gedoong.com / password123 (agent)