-- -------------------------------------------------------- -- Host: 127.0.0.1 -- Server version: 8.0.30 - MySQL Community Server - GPL -- Server OS: Win64 -- HeidiSQL Version: 12.1.0.6537 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET NAMES utf8 */; /*!50503 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- Dumping database structure for catering CREATE DATABASE IF NOT EXISTS `catering` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */; USE `catering`; -- Dumping structure for table catering.admin CREATE TABLE IF NOT EXISTS `admin` ( `id_admin` varchar(8) NOT NULL, `nama` varchar(25) NOT NULL, `username` varchar(20) NOT NULL, `password` varchar(255) NOT NULL, PRIMARY KEY (`id_admin`), UNIQUE KEY `username` (`username`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Dumping data for table catering.admin: ~3 rows (approximately) INSERT INTO `admin` (`id_admin`, `nama`, `username`, `password`) VALUES ('ADM1', 'Bagus', 'admin1', '$2y$10$Kq9hus6WnO.axAHxT/C2UeTRNNzV8umqh9jz6QNjbma1JLZJg0i2q'), ('ADM2', 'Siti', 'admin2', '$2y$10$1Zjd0dSyjQnNY9.ffKLzJe2RcioprSIXm1potCVHT.HX8Yt19O4a2'), ('ADM3', 'BagusKP', 'admin3', '84be96f0a1b5cac3e4096467d270da6acac3adccc4056a8b22bc6bc7397a7421'); -- Dumping structure for table catering.detail_pemesanan CREATE TABLE IF NOT EXISTS `detail_pemesanan` ( `id_detail_pemesanan` varchar(8) NOT NULL, `id_pemesanan` varchar(8) DEFAULT NULL, `id_menu` varchar(8) DEFAULT NULL, `jumlah` int NOT NULL, `subtotal` decimal(10,2) NOT NULL, `tanggal_pemesanan` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `alamat_pengiriman` text NOT NULL, `tanggal_pengiriman` date NOT NULL, `jam_pengiriman` time NOT NULL, `latitude` decimal(10,8) DEFAULT NULL, `longitude` decimal(11,8) DEFAULT NULL, PRIMARY KEY (`id_detail_pemesanan`), KEY `id_pemesanan` (`id_pemesanan`), KEY `id_menu` (`id_menu`), CONSTRAINT `detail_pemesanan_ibfk_1` FOREIGN KEY (`id_pemesanan`) REFERENCES `pemesanan` (`id_pemesanan`) ON DELETE CASCADE, CONSTRAINT `detail_pemesanan_ibfk_2` FOREIGN KEY (`id_menu`) REFERENCES `menu` (`id_menu`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Dumping data for table catering.detail_pemesanan: ~171 rows (approximately) INSERT INTO `detail_pemesanan` (`id_detail_pemesanan`, `id_pemesanan`, `id_menu`, `jumlah`, `subtotal`, `tanggal_pemesanan`, `alamat_pengiriman`, `tanggal_pengiriman`, `jam_pengiriman`, `latitude`, `longitude`) VALUES ('DP1', 'PSM1', 'MNU2', 12, 300000.00, '2025-03-11 14:08:15', 'Jakarat aja ', '2025-03-15', '14:11:00', NULL, NULL), ('DP100', 'PSM47', 'MNU4', 10, 100000.00, '2025-10-10 23:40:24', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-13', '08:40:00', NULL, NULL), ('DP101', 'PSM48', 'MNU2', 15, 450000.00, '2025-10-10 23:41:14', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-14', '17:44:00', NULL, NULL), ('DP102', 'PSM49', 'MNU8', 10, 250000.00, '2025-10-10 23:42:04', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-15', '14:41:00', NULL, NULL), ('DP103', 'PSM49', 'MNU5', 10, 120000.00, '2025-10-10 23:42:04', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-15', '14:41:00', NULL, NULL), ('DP104', 'PSM50', 'MNU1', 20, 500000.00, '2025-10-10 23:42:48', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-15', '09:42:00', NULL, NULL), ('DP105', 'PSM51', 'MNU4', 30, 300000.00, '2025-10-10 23:43:37', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-13', '09:43:00', NULL, NULL), ('DP106', 'PSM51', 'MNU5', 20, 240000.00, '2025-10-10 23:43:37', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-13', '09:43:00', NULL, NULL), ('DP107', 'PSM52', 'MNU2', 12, 360000.00, '2025-10-10 23:52:57', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-14', '13:52:00', NULL, NULL), ('DP108', 'PSM52', 'MNU3', 12, 300000.00, '2025-10-10 23:52:57', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-14', '13:52:00', NULL, NULL), ('DP109', 'PSM53', 'MNU9', 20, 500000.00, '2025-10-10 23:53:45', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-14', '10:56:00', NULL, NULL), ('DP11', 'PSM10', 'MNU1', 10, 250000.00, '2025-10-10 15:24:10', 'Jl. Rajawali No. 9, Tegineneng', '2025-10-13', '11:00:00', NULL, NULL), ('DP110', 'PSM54', 'MNU8', 10, 250000.00, '2025-10-10 23:54:34', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-14', '06:00:00', NULL, NULL), ('DP111', 'PSM54', 'MNU5', 18, 216000.00, '2025-10-10 23:54:34', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-14', '06:00:00', NULL, NULL), ('DP112', 'PSM55', 'MNU1', 12, 300000.00, '2025-10-11 15:46:23', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-13', '17:46:00', NULL, NULL), ('DP113', 'PSM56', 'MNU1', 12, 300000.00, '2025-10-12 21:52:46', 'Jl. Merpati No. 5, Batanghari', '2025-10-15', '08:52:00', NULL, NULL), ('DP114', 'PSM56', 'MNU2', 10, 300000.00, '2025-10-12 21:52:46', 'Jl. Merpati No. 5, Batanghari', '2025-10-15', '08:52:00', NULL, NULL), ('DP115', 'PSM57', 'MNU1', 10, 250000.00, '2025-10-12 22:01:10', 'Jl. Mawar No. 18, Metro Utara', '2025-10-15', '08:04:00', NULL, NULL), ('DP116', 'PSM57', 'MNU5', 10, 120000.00, '2025-10-12 22:01:10', 'Jl. Mawar No. 18, Metro Utara', '2025-10-15', '08:04:00', NULL, NULL), ('DP117', 'PSM58', 'MNU1', 100, 2500000.00, '2025-10-30 11:40:50', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-16', '11:43:00', NULL, NULL), ('DP118', 'PSM59', 'MNU2', 10, 300000.00, '2025-10-30 17:40:39', 'Jl. Mawar No. 18, Metro Utara', '2025-11-01', '12:40:00', NULL, NULL), ('DP119', 'PSM60', 'MNU3', 19, 475000.00, '2025-10-30 18:06:43', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-11-01', '18:06:00', NULL, NULL), ('DP12', 'PSM10', 'MNU5', 10, 120000.00, '2025-10-10 15:24:10', 'Jl. Rajawali No. 9, Tegineneng', '2025-10-13', '11:00:00', NULL, NULL), ('DP120', 'PSM61', 'MNU1', 10, 250000.00, '2025-10-31 13:43:39', 'Rejomulyo, Metro, Lampung, Sumatra, 34123, Indonesia', '2025-10-31', '17:43:00', -5.15275200, 105.32036070), ('DP121', 'PSM62', 'MNU2', 5, 150000.00, '2025-10-31 13:49:52', 'Tejo Sari, Metro, Lampung, Sumatra, 34112, Indonesia', '2025-10-31', '20:49:00', -5.13721670, 105.32173510), ('DP122', 'PSM63', 'MNU1', 10, 250000.00, '2025-10-31 14:03:01', 'Tejo Sari, Metro, Lampung, Sumatra, 34123, Indonesia', '2025-10-31', '19:02:00', -5.13721670, 105.32173510), ('DP123', 'PSM64', 'MNU3', 35, 875000.00, '2025-10-31 14:13:45', 'Tejo Sari, Metro, Lampung, Sumatera, 34123, Indonesia', '2025-10-31', '19:13:00', -5.14226320, 105.32804489), ('DP124', 'PSM65', 'MNU2', 10, 300000.00, '2025-10-31 14:36:34', 'RSU Muhammadiyah Metro, Jalan Soekarno-Hatta, Margo Rejo, Metro, Lampung, Sumatera, 34115, Indonesia', '2025-10-31', '17:29:00', -5.13524046, 105.29020786), ('DP125', 'PSM66', 'MNU1', 50, 1250000.00, '2025-11-02 13:37:50', 'Magodadi, Metro, Lampung, Sumatera, 34125, Indonesia', '2025-11-07', '07:00:00', -5.13510823, 105.30518532), ('DP126', 'PSM67', 'MNU2', 20, 600000.00, '2025-11-02 13:54:38', 'Tejo Sari, Metro, Lampung, Sumatera, 34123, Indonesia', '2025-11-07', '10:54:00', -5.14828410, 105.33187065), ('DP127', 'PSM68', 'MNU3', 20, 500000.00, '2025-11-02 14:15:34', 'Rejomulyo, Metro, Lampung, Sumatera, 34123, Indonesia', '2025-11-07', '14:15:00', -5.16476768, 105.31386922), ('DP128', 'PSM69', 'MNU2', 10, 300000.00, '2025-11-06 16:58:08', 'Permukiman, Metro, Lampung Timur, Lampung, Sumatera, 34123, Indonesia', '2025-11-08', '10:00:00', -5.14863522, 105.33203504), ('DP129', 'PSM70', 'MNU2', 1, 30000.00, '2025-11-24 13:35:33', 'Tejo Sari, Metro, Lampung, Sumatera, 34123, Indonesia', '2025-11-25', '07:35:00', -5.14383455, 105.32483859), ('DP13', 'PSM10', 'MNU10', 10, 120000.00, '2025-10-10 15:24:10', 'Jl. Rajawali No. 9, Tegineneng', '2025-10-13', '11:00:00', NULL, NULL), ('DP130', 'PSM71', 'MNU8', 25, 625000.00, '2025-11-24 13:37:59', 'Magodadi, Metro, Lampung, Sumatera, 34125, Indonesia', '2025-11-25', '07:00:00', -5.13645575, 105.30512430), ('DP131', 'PSM72', 'MNU1', 10, 250000.00, '2025-11-24 13:40:03', 'Jalan Arjuna, Banjar Rejo, Lampung Timur, Lampung, Sumatera, 34112, Indonesia', '2025-11-25', '09:39:00', -5.13012975, 105.33516491), ('DP132', 'PSM73', 'MNU6', 10, 100000.00, '2025-11-24 20:52:31', 'Jalan Metro - Tanjung Kari, Permukiman 41 46, Banar Joyo, Lampung Timur, Lampung, Sumatera, 34123, Indonesia', '2025-11-28', '11:10:00', -5.13704057, 105.34229278), ('DP133', 'PSM73', 'MNU9', 10, 250000.00, '2025-11-24 20:52:31', 'Jalan Metro - Tanjung Kari, Permukiman 41 46, Banar Joyo, Lampung Timur, Lampung, Sumatera, 34123, Indonesia', '2025-11-28', '11:10:00', -5.13704057, 105.34229278), ('DP134', 'PSM74', 'MNU1', 10, 250000.00, '2025-11-25 08:14:51', 'Tejo Sari, Metro, Lampung, Sumatera, 34112, Indonesia', '2025-11-26', '12:14:00', -5.13442434, 105.32029152), ('DP135', 'PSM75', 'MNU2', 1, 30000.00, '2025-11-26 22:19:23', 'Sumber Rejo, Lampung Timur, Lampung, Sumatera, 15131, Indonesia', '2025-11-28', '08:25:00', -5.13024440, 105.35053253), ('DP136', 'PSM75', 'MNU3', 1, 25000.00, '2025-11-26 22:19:23', 'Sumber Rejo, Lampung Timur, Lampung, Sumatera, 15131, Indonesia', '2025-11-28', '08:25:00', -5.13024440, 105.35053253), ('DP137', 'PSM76', 'MNU1', 1, 25000.00, '2025-11-26 22:22:06', 'Permukiman, Adi Warno, Lampung Timur, Lampung, Sumatera, 34123, Indonesia', '2025-11-29', '09:26:00', -5.15024801, 105.34109115), ('DP138', 'PSM77', 'MNU1', 1, 25000.00, '2025-12-26 21:39:50', 'Banjar Rejo, Lampung Timur, Lampung, Sumatera, 34112, Indonesia', '2025-12-31', '08:41:00', -5.12619801, 105.34795761), ('DP139', 'PSM78', 'MNU1', 10, 250000.00, '2025-12-26 22:18:12', 'Tejoagung, Metro, Lampung, Sumatera, 34124, Indonesia', '2025-12-27', '08:20:00', -5.11701873, 105.32017708), ('DP14', 'PSM11', 'MNU2', 6, 180000.00, '2025-10-10 15:43:37', 'Jl. Rajawali No. 9, Tegineneng', '2025-10-14', '19:01:00', NULL, NULL), ('DP140', 'PSM79', 'MNU2', 1, 30000.00, '2025-12-26 22:20:01', 'Sumber Rejo, Lampung Timur, Lampung, Sumatera, 34123, Indonesia', '2025-12-27', '09:19:00', -5.13460577, 105.34148287), ('DP141', 'PSM80', 'MNU2', 1, 30000.00, '2025-12-26 22:21:01', 'Rejomulyo, Metro, Lampung, Sumatera, 34123, Indonesia', '2025-12-27', '09:01:00', -5.15683181, 105.32122819), ('DP142', 'PSM81', 'MNU1', 1, 25000.00, '2025-12-26 22:35:19', 'Sumber Rejo, Lampung Timur, Lampung, Sumatera, 15131, Indonesia', '2025-12-27', '16:35:00', -5.12545712, 105.35774231), ('DP143', 'PSM82', 'MNU2', 10, 300000.00, '2026-01-02 17:17:49', 'Margo Rejo, Metro, Lampung, Sumatera, 34115, Indonesia', '2026-01-03', '09:17:00', -5.13397510, 105.29494329), ('DP144', 'PSM82', 'MNU6', 10, 100000.00, '2026-01-02 17:17:49', 'Margo Rejo, Metro, Lampung, Sumatera, 34115, Indonesia', '2026-01-03', '09:17:00', -5.13397510, 105.29494329), ('DP145', 'PSM83', 'MNU1', 10, 250000.00, '2026-01-02 17:20:28', 'Tejoagung, Metro, Lampung, Sumatera, 34112, Indonesia', '2026-01-03', '09:02:00', -5.12491328, 105.32326773), ('DP146', 'PSM83', 'MNU5', 10, 120000.00, '2026-01-02 17:20:28', 'Tejoagung, Metro, Lampung, Sumatera, 34112, Indonesia', '2026-01-03', '09:02:00', -5.12491328, 105.32326773), ('DP147', 'PSM84', 'MNU8', 20, 500000.00, '2026-01-02 21:32:52', 'Sumber Rejo, Lampung Timur, Lampung, Sumatera, 34123, Indonesia', '2026-01-05', '10:32:00', -5.13503164, 105.34332275), ('DP148', 'PSM84', 'MNU5', 10, 120000.00, '2026-01-02 21:32:52', 'Sumber Rejo, Lampung Timur, Lampung, Sumatera, 34123, Indonesia', '2026-01-05', '10:32:00', -5.13503164, 105.34332275), ('DP149', 'PSM85', 'MNU3', 10, 250000.00, '2026-01-02 21:34:32', 'Tejoagung, Metro, Lampung, Sumatera, 34112, Indonesia', '2026-01-05', '09:43:00', -5.12237956, 105.32135009), ('DP15', 'PSM11', 'MNU6', 5, 50000.00, '2025-10-10 15:43:37', 'Jl. Rajawali No. 9, Tegineneng', '2025-10-14', '19:01:00', NULL, NULL), ('DP150', 'PSM85', 'MNU6', 20, 200000.00, '2026-01-02 21:34:32', 'Tejoagung, Metro, Lampung, Sumatera, 34112, Indonesia', '2026-01-05', '09:43:00', -5.12237956, 105.32135009), ('DP151', 'PSM86', 'MNU7', 20, 500000.00, '2026-01-02 21:36:21', 'Rejomulyo, Metro, Lampung, Sumatera, 34123, Indonesia', '2026-01-05', '11:36:00', -5.15486414, 105.31688690), ('DP152', 'PSM86', 'MNU5', 10, 120000.00, '2026-01-02 21:36:21', 'Rejomulyo, Metro, Lampung, Sumatera, 34123, Indonesia', '2026-01-05', '11:36:00', -5.15486414, 105.31688690), ('DP153', 'PSM87', 'MNU1', 20, 500000.00, '2026-01-02 21:42:46', 'Rejomulyo, Metro, Lampung, Sumatera, 34123, Indonesia', '2026-01-05', '12:00:00', -5.15349640, 105.30590057), ('DP154', 'PSM88', 'MNU2', 12, 360000.00, '2026-01-04 13:58:20', 'Permukiman, Adi Warno, Lampung Timur, Lampung, Sumatera, 34123, Indonesia', '2026-01-13', '18:58:00', -5.15107252, 105.34064864), ('DP155', 'PSM89', 'MNU1', 6, 150000.00, '2026-01-05 16:39:25', 'Jalan Selagai, Tejoagung, Metro, Lampung, Sumatera, 34124, Indonesia', '2026-01-06', '07:40:00', -5.11875801, 105.31112255), ('DP156', 'PSM89', 'MNU3', 5, 125000.00, '2026-01-05 16:39:25', 'Jalan Selagai, Tejoagung, Metro, Lampung, Sumatera, 34124, Indonesia', '2026-01-06', '07:40:00', -5.11875801, 105.31112255), ('DP157', 'PSM90', 'MNU1', 12, 300000.00, '2026-01-05 16:42:17', 'Jalan Metro - Tanjung Kari, Batas pemukiman desa (sawah, kelurahan, desa), Banar Joyo, Lampung Timur, Lampung, Sumatera, 34123, Indonesia', '2026-01-06', '06:42:00', -5.13448814, 105.35077677), ('DP158', 'PSM91', 'MNU2', 5, 150000.00, '2026-01-08 21:06:49', 'Iringmulyo, Metro, Lampung, Sumatera, 34112, Indonesia', '2026-01-09', '07:06:00', -5.11704820, 105.32944761), ('DP159', 'PSM91', 'MNU5', 5, 60000.00, '2026-01-08 21:06:49', 'Iringmulyo, Metro, Lampung, Sumatera, 34112, Indonesia', '2026-01-09', '07:06:00', -5.11704820, 105.32944761), ('DP16', 'PSM12', 'MNU3', 12, 300000.00, '2025-10-10 15:52:33', 'Jl. Rajawali No. 9, Tegineneng', '2025-10-16', '15:55:00', NULL, NULL), ('DP160', 'PSM92', 'MNU3', 10, 250000.00, '2026-01-08 21:09:18', 'Jalan Ahmad Yani, Tejoagung, Metro, Lampung, Sumatera, 34124, Indonesia', '2026-01-09', '07:28:00', -5.11773212, 105.31348292), ('DP161', 'PSM92', 'MNU6', 20, 200000.00, '2026-01-08 21:09:18', 'Jalan Ahmad Yani, Tejoagung, Metro, Lampung, Sumatera, 34124, Indonesia', '2026-01-09', '07:28:00', -5.11773212, 105.31348292), ('DP162', 'PSM93', 'MNU7', 10, 250000.00, '2026-01-08 21:11:10', 'Metro, Lampung Timur, Lampung, Sumatera, 34123, Indonesia', '2026-01-09', '08:11:00', -5.15808233, 105.31914781), ('DP163', 'PSM93', 'MNU4', 10, 100000.00, '2026-01-08 21:11:10', 'Metro, Lampung Timur, Lampung, Sumatera, 34123, Indonesia', '2026-01-09', '08:11:00', -5.15808233, 105.31914781), ('DP164', 'PSM94', 'MNU1', 20, 500000.00, '2026-01-08 21:13:13', 'Margo Rejo, Metro, Lampung, Sumatera, 34115, Indonesia', '2026-01-12', '13:13:00', -5.13653974, 105.29082337), ('DP165', 'PSM95', 'MNU2', 10, 300000.00, '2026-01-22 13:34:14', 'Batas pemukiman desa (sawah, kelurahan, desa), Sumber Rejo, Lampung Timur, Lampung, Sumatera, 15131, Indonesia ', '2026-01-23', '17:34:00', -5.13722365, 105.35850162), ('DP166', 'PSM96', 'MNU9', 5, 125000.00, '2026-01-24 07:39:57', 'Tejo Sari, Metro, Lampung, Sumatera, 34123, Indonesia', '2026-01-26', '08:40:00', -5.14042820, 105.32647512), ('DP167', 'PSM96', 'MNU6', 5, 50000.00, '2026-01-24 07:39:57', 'Tejo Sari, Metro, Lampung, Sumatera, 34123, Indonesia', '2026-01-26', '08:40:00', -5.14042820, 105.32647512), ('DP168', 'PSM97', 'MNU8', 10, 250000.00, '2026-01-24 07:43:50', 'Lampung Timur, Lampung, Sumatera, 34112, Indonesia ', '2026-01-26', '08:15:00', -5.13337559, 105.32879257), ('DP169', 'PSM98', 'MNU7', 6, 150000.00, '2026-01-24 07:46:08', 'Magodadi, Metro, Lampung, Sumatera, 34125, Indonesia', '2026-01-26', '08:50:00', -5.13504269, 105.30664810), ('DP17', 'PSM12', 'MNU4', 10, 100000.00, '2025-10-10 15:52:33', 'Jl. Rajawali No. 9, Tegineneng', '2025-10-16', '15:55:00', NULL, NULL), ('DP170', 'PSM98', 'MNU5', 6, 72000.00, '2026-01-24 07:46:08', 'Magodadi, Metro, Lampung, Sumatera, 34125, Indonesia', '2026-01-26', '08:50:00', -5.13504269, 105.30664810), ('DP171', 'PSM99', 'MNU1', 10, 250000.00, '2026-01-24 23:46:37', 'Sumber Rejo, Lampung Timur, Lampung, Sumatera, 34112, Indonesia', '2026-01-26', '09:00:00', -5.12991331, 105.33956409), ('DP172', 'PSM100', 'MNU2', 10, 300000.00, '2026-01-25 00:14:45', 'Banjar Rejo, Lampung Timur, Lampung, Sumatera, 34112, Indonesia', '2026-01-28', '11:00:00', -5.11875801, 105.33240880), ('DP173', 'PSM101', 'MNU4', 10, 100000.00, '2026-01-25 14:02:14', 'Magodadi, Metro, Lampung, Sumatera, 34125, Indonesia', '2026-01-28', '18:02:00', -5.13927535, 105.29773282), ('DP174', 'PSM101', 'MNU14', 10, 150000.00, '2026-01-25 14:02:14', 'Magodadi, Metro, Lampung, Sumatera, 34125, Indonesia', '2026-01-28', '18:02:00', -5.13927535, 105.29773282), ('DP175', 'PSM102', 'MNU1', 5, 125000.00, '2026-01-26 08:36:40', 'Sumber Rejo, Lampung Timur, Lampung, Sumatera, 34123, Indonesia', '2026-01-27', '11:36:00', -5.13537359, 105.34263610), ('DP176', 'PSM103', 'MNU1', 10, 250000.00, '2026-02-10 16:32:28', 'Ganjar Agung, Metro, Lampung, Sumatera, 34125, Indonesia', '2026-02-13', '18:32:00', -5.12178270, 105.29788381), ('DP177', 'PSM103', 'MNU1', 10, 250000.00, '2026-02-10 10:31:35', 'Jl. Madukoro No.16, Tejosari, Kec. Metro Tim., Kota Metro, Lampung 34123', '2026-02-13', '09:29:00', NULL, NULL), ('DP178', 'PSM103', 'MNU16', 10, 180000.00, '2026-02-10 10:32:51', 'Jl. Madukoro No.16, Tejosari, Kec. Metro Tim., Kota Metro, Lampung 34123', '2026-02-13', '09:29:00', NULL, NULL), ('DP179', 'PSM103', 'MNU1', 10, 250000.00, '2026-02-10 10:32:51', 'Jl. Madukoro No.16, Tejosari, Kec. Metro Tim., Kota Metro, Lampung 34123', '2026-02-13', '09:29:00', NULL, NULL), ('DP18', 'PSM12', 'MNU14', 10, 150000.00, '2025-10-10 15:52:33', 'Jl. Rajawali No. 9, Tegineneng', '2025-10-16', '15:55:00', NULL, NULL), ('DP180', 'PSM103', 'MNU17', 10, 150000.00, '2026-02-10 10:37:23', 'Jl. Madukoro No.16, Tejosari, Kec. Metro Tim., Kota Metro, Lampung 34123', '2026-02-11', '17:40:00', NULL, NULL), ('DP181', 'PSM104', 'MNU17', 10, 150000.00, '2026-02-10 10:40:18', 'Jl. Madukoro No.16, Tejosari, Kec. Metro Tim., Kota Metro, Lampung 34123', '2026-02-10', '19:40:00', NULL, NULL), ('DP182', 'PSM103', 'MNU17', 10, 150000.00, '2026-02-10 10:41:46', 'Jl. Madukoro No.16, Tejosari, Kec. Metro Tim., Kota Metro, Lampung 34123', '2026-02-13', '18:41:00', NULL, NULL), ('DP183', 'PSM104', 'MNU17', 10, 150000.00, '2026-02-10 10:44:06', 'Jl. Madukoro No.16, Tejosari, Kec. Metro Tim., Kota Metro, Lampung 34123', '2026-02-10', '18:44:00', NULL, NULL), ('DP184', 'PSM105', 'MNU14', 10, 150000.00, '2026-02-10 10:48:04', 'Jl. Madukoro No.16, Tejosari, Kec. Metro Tim., Kota Metro, Lampung 34123', '2026-02-13', '20:47:00', NULL, NULL), ('DP19', 'PSM13', 'MNU1', 30, 750000.00, '2025-10-10 15:59:43', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-13', '19:02:00', NULL, NULL), ('DP2', 'PSM1', 'MNU1', 13, 325000.00, '2025-03-11 14:08:15', 'Jakarat aja ', '2025-03-15', '14:11:00', NULL, NULL), ('DP20', 'PSM13', 'MNU5', 30, 360000.00, '2025-10-10 15:59:43', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-13', '19:02:00', NULL, NULL), ('DP21', 'PSM13', 'MNU10', 30, 360000.00, '2025-10-10 15:59:43', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-13', '19:02:00', NULL, NULL), ('DP22', 'PSM14', 'MNU3', 6, 150000.00, '2025-10-10 16:00:30', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-15', '20:00:00', NULL, NULL), ('DP23', 'PSM14', 'MNU6', 7, 70000.00, '2025-10-10 16:00:30', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-15', '20:00:00', NULL, NULL), ('DP24', 'PSM15', 'MNU1', 7, 175000.00, '2025-10-10 16:49:23', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-15', '19:52:00', NULL, NULL), ('DP25', 'PSM15', 'MNU5', 7, 84000.00, '2025-10-10 16:49:23', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-15', '19:52:00', NULL, NULL), ('DP26', 'PSM15', 'MNU17', 7, 105000.00, '2025-10-10 16:49:23', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-15', '19:52:00', NULL, NULL), ('DP27', 'PSM16', 'MNU3', 12, 300000.00, '2025-10-10 16:51:19', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-14', '16:54:00', NULL, NULL), ('DP28', 'PSM16', 'MNU5', 12, 144000.00, '2025-10-10 16:51:19', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-14', '16:54:00', NULL, NULL), ('DP3', 'PSM2', 'MNU2', 1, 25000.00, '2025-03-11 14:11:27', 'Jakarta', '2025-12-12', '12:34:00', NULL, NULL), ('DP30', 'PSM17', 'MNU1', 5, 125000.00, '2025-10-10 16:56:46', 'Jl. Melati No. 45, Metro Pusat', '2025-10-12', '16:58:00', NULL, NULL), ('DP31', 'PSM17', 'MNU5', 5, 60000.00, '2025-10-10 16:56:46', 'Jl. Melati No. 45, Metro Pusat', '2025-10-12', '16:58:00', NULL, NULL), ('DP32', 'PSM17', 'MNU10', 5, 60000.00, '2025-10-10 16:56:46', 'Jl. Melati No. 45, Metro Pusat', '2025-10-12', '16:58:00', NULL, NULL), ('DP33', 'PSM18', 'MNU2', 12, 360000.00, '2025-10-10 17:09:07', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-13', '18:08:00', NULL, NULL), ('DP34', 'PSM18', 'MNU5', 19, 228000.00, '2025-10-10 17:09:07', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-13', '18:08:00', NULL, NULL), ('DP35', 'PSM19', 'MNU5', 20, 240000.00, '2025-10-10 22:38:05', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-13', '18:00:00', NULL, NULL), ('DP36', 'PSM19', 'MNU10', 20, 240000.00, '2025-10-10 22:38:05', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-13', '18:00:00', NULL, NULL), ('DP37', 'PSM20', 'MNU2', 10, 300000.00, '2025-10-10 22:40:34', 'Jl. Mawar No. 18, Metro Utara', '2025-10-12', '08:40:00', NULL, NULL), ('DP38', 'PSM20', 'MNU1', 10, 250000.00, '2025-10-10 22:40:34', 'Jl. Mawar No. 18, Metro Utara', '2025-10-12', '08:40:00', NULL, NULL), ('DP39', 'PSM20', 'MNU5', 10, 120000.00, '2025-10-10 22:40:35', 'Jl. Mawar No. 18, Metro Utara', '2025-10-12', '08:40:00', NULL, NULL), ('DP4', 'PSM3', 'MNU1', 20, 500000.00, '2025-03-12 12:01:02', 'bekasi', '2025-03-27', '18:00:00', NULL, NULL), ('DP40', 'PSM21', 'MNU4', 12, 120000.00, '2025-10-10 22:42:06', 'Jl. Mawar No. 18, Metro Utara', '2025-10-14', '15:42:00', NULL, NULL), ('DP42', 'PSM21', 'MNU12', 20, 200000.00, '2025-10-10 22:42:06', 'Jl. Mawar No. 18, Metro Utara', '2025-10-14', '15:42:00', NULL, NULL), ('DP43', 'PSM22', 'MNU3', 20, 500000.00, '2025-10-10 22:45:37', 'Jl. Mawar No. 18, Metro Utara', '2025-10-12', '18:46:00', NULL, NULL), ('DP44', 'PSM22', 'MNU4', 10, 100000.00, '2025-10-10 22:45:37', 'Jl. Mawar No. 18, Metro Utara', '2025-10-12', '18:46:00', NULL, NULL), ('DP45', 'PSM23', 'MNU4', 20, 200000.00, '2025-10-10 22:51:38', 'Jl. Mawar No. 18, Metro Utara', '2025-10-14', '11:54:00', NULL, NULL), ('DP46', 'PSM23', 'MNU5', 20, 240000.00, '2025-10-10 22:51:38', 'Jl. Mawar No. 18, Metro Utara', '2025-10-14', '11:54:00', NULL, NULL), ('DP47', 'PSM23', 'MNU13', 20, 260000.00, '2025-10-10 22:51:38', 'Jl. Mawar No. 18, Metro Utara', '2025-10-14', '11:54:00', NULL, NULL), ('DP48', 'PSM24', 'MNU5', 10, 120000.00, '2025-10-10 22:52:51', 'Jl. Mawar No. 18, Metro Utara', '2025-10-14', '07:52:00', NULL, NULL), ('DP49', 'PSM24', 'MNU14', 10, 150000.00, '2025-10-10 22:52:51', 'Jl. Mawar No. 18, Metro Utara', '2025-10-14', '07:52:00', NULL, NULL), ('DP50', 'PSM25', 'MNU4', 20, 200000.00, '2025-10-10 22:55:23', 'Jl. Merpati No. 5, Batanghari', '2025-10-13', '22:55:00', NULL, NULL), ('DP51', 'PSM25', 'MNU5', 20, 240000.00, '2025-10-10 22:55:23', 'Jl. Merpati No. 5, Batanghari', '2025-10-13', '22:55:00', NULL, NULL), ('DP52', 'PSM26', 'MNU1', 12, 300000.00, '2025-10-10 22:56:22', 'Jl. Merpati No. 5, Batanghari', '2025-10-12', '18:57:00', NULL, NULL), ('DP53', 'PSM26', 'MNU4', 13, 130000.00, '2025-10-10 22:56:22', 'Jl. Merpati No. 5, Batanghari', '2025-10-12', '18:57:00', NULL, NULL), ('DP54', 'PSM26', 'MNU10', 6, 72000.00, '2025-10-10 22:56:22', 'Jl. Merpati No. 5, Batanghari', '2025-10-12', '18:57:00', NULL, NULL), ('DP55', 'PSM27', 'MNU1', 30, 750000.00, '2025-10-10 22:57:35', 'Jl. Merpati No. 5, Batanghari', '2025-10-14', '05:00:00', NULL, NULL), ('DP56', 'PSM27', 'MNU5', 30, 360000.00, '2025-10-10 22:57:35', 'Jl. Merpati No. 5, Batanghari', '2025-10-14', '05:00:00', NULL, NULL), ('DP57', 'PSM27', 'MNU11', 30, 450000.00, '2025-10-10 22:57:35', 'Jl. Merpati No. 5, Batanghari', '2025-10-14', '05:00:00', NULL, NULL), ('DP58', 'PSM28', 'MNU2', 16, 480000.00, '2025-10-10 22:58:48', 'Jl. Merpati No. 5, Batanghari', '2025-10-14', '14:00:00', NULL, NULL), ('DP59', 'PSM28', 'MNU6', 16, 160000.00, '2025-10-10 22:58:48', 'Jl. Merpati No. 5, Batanghari', '2025-10-14', '14:00:00', NULL, NULL), ('DP6', 'PSM5', 'MNU1', 1, 25000.00, '2025-03-12 13:25:45', 'Goden Sleman yk', '2025-03-12', '19:00:00', NULL, NULL), ('DP60', 'PSM29', 'MNU1', 20, 500000.00, '2025-10-10 23:01:49', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-11', '06:01:00', NULL, NULL), ('DP61', 'PSM29', 'MNU4', 10, 100000.00, '2025-10-10 23:01:49', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-11', '06:01:00', NULL, NULL), ('DP62', 'PSM29', 'MNU11', 10, 150000.00, '2025-10-10 23:01:49', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-11', '06:01:00', NULL, NULL), ('DP63', 'PSM30', 'MNU2', 10, 300000.00, '2025-10-10 23:12:24', 'Jl. Merpati No. 5, Batanghari', '2025-10-12', '11:12:00', NULL, NULL), ('DP64', 'PSM30', 'MNU5', 20, 240000.00, '2025-10-10 23:12:24', 'Jl. Merpati No. 5, Batanghari', '2025-10-12', '11:12:00', NULL, NULL), ('DP65', 'PSM30', 'MNU6', 10, 100000.00, '2025-10-10 23:12:24', 'Jl. Merpati No. 5, Batanghari', '2025-10-12', '11:12:00', NULL, NULL), ('DP66', 'PSM31', 'MNU5', 29, 348000.00, '2025-10-10 23:13:17', 'Jl. Merpati No. 5, Batanghari', '2025-10-14', '08:13:00', NULL, NULL), ('DP67', 'PSM31', 'MNU4', 29, 290000.00, '2025-10-10 23:13:17', 'Jl. Merpati No. 5, Batanghari', '2025-10-14', '08:13:00', NULL, NULL), ('DP68', 'PSM32', 'MNU1', 20, 500000.00, '2025-10-10 23:14:25', 'Jl. Merpati No. 5, Batanghari', '2025-10-13', '16:14:00', NULL, NULL), ('DP69', 'PSM32', 'MNU4', 20, 200000.00, '2025-10-10 23:14:25', 'Jl. Merpati No. 5, Batanghari', '2025-10-13', '16:14:00', NULL, NULL), ('DP7', 'PSM6', 'MNU2', 10, 300000.00, '2025-04-25 20:39:33', 'Jalan Sidomuncul Jakarta Sletan ', '2025-05-12', '10:45:00', NULL, NULL), ('DP70', 'PSM32', 'MNU11', 10, 150000.00, '2025-10-10 23:14:25', 'Jl. Merpati No. 5, Batanghari', '2025-10-13', '16:14:00', NULL, NULL), ('DP71', 'PSM33', 'MNU10', 20, 240000.00, '2025-10-10 23:15:18', 'Jl. Merpati No. 5, Batanghari', '2025-10-14', '13:15:00', NULL, NULL), ('DP72', 'PSM33', 'MNU4', 20, 200000.00, '2025-10-10 23:15:18', 'Jl. Merpati No. 5, Batanghari', '2025-10-14', '13:15:00', NULL, NULL), ('DP73', 'PSM34', 'MNU6', 30, 300000.00, '2025-10-10 23:16:45', 'Jl. Merpati No. 5, Batanghari', '2025-10-15', '07:16:00', NULL, NULL), ('DP74', 'PSM34', 'MNU11', 30, 450000.00, '2025-10-10 23:16:45', 'Jl. Merpati No. 5, Batanghari', '2025-10-15', '07:16:00', NULL, NULL), ('DP75', 'PSM35', 'MNU1', 30, 750000.00, '2025-10-10 23:20:06', 'Jl. Srikandi No. 8, Metro Timur', '2025-10-13', '23:22:00', NULL, NULL), ('DP76', 'PSM36', 'MNU1', 10, 250000.00, '2025-10-10 23:26:24', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-15', '13:26:00', NULL, NULL), ('DP77', 'PSM36', 'MNU5', 20, 240000.00, '2025-10-10 23:26:24', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-15', '13:26:00', NULL, NULL), ('DP78', 'PSM37', 'MNU7', 20, 500000.00, '2025-10-10 23:27:27', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-14', '04:27:00', NULL, NULL), ('DP79', 'PSM37', 'MNU4', 10, 100000.00, '2025-10-10 23:27:27', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-14', '04:27:00', NULL, NULL), ('DP8', 'PSM6', 'MNU6', 10, 100000.00, '2025-04-25 20:39:33', 'Jalan Sidomuncul Jakarta Sletan ', '2025-05-12', '10:45:00', NULL, NULL), ('DP80', 'PSM37', 'MNU10', 10, 120000.00, '2025-10-10 23:27:27', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-14', '04:27:00', NULL, NULL), ('DP81', 'PSM38', 'MNU8', 20, 500000.00, '2025-10-10 23:28:45', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-15', '16:28:00', NULL, NULL), ('DP82', 'PSM38', 'MNU5', 10, 120000.00, '2025-10-10 23:28:45', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-15', '16:28:00', NULL, NULL), ('DP83', 'PSM39', 'MNU8', 15, 375000.00, '2025-10-10 23:29:52', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-14', '10:29:00', NULL, NULL), ('DP84', 'PSM39', 'MNU6', 15, 150000.00, '2025-10-10 23:29:52', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-14', '10:29:00', NULL, NULL), ('DP85', 'PSM39', 'MNU11', 15, 225000.00, '2025-10-10 23:29:52', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-14', '10:29:00', NULL, NULL), ('DP86', 'PSM40', 'MNU9', 20, 500000.00, '2025-10-10 23:30:55', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-14', '19:30:00', NULL, NULL), ('DP87', 'PSM40', 'MNU4', 20, 200000.00, '2025-10-10 23:30:55', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-14', '19:30:00', NULL, NULL), ('DP88', 'PSM41', 'MNU2', 10, 300000.00, '2025-10-10 23:31:43', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-15', '07:31:00', NULL, NULL), ('DP89', 'PSM41', 'MNU10', 10, 120000.00, '2025-10-10 23:31:43', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-15', '07:31:00', NULL, NULL), ('DP9', 'PSM7', 'MNU1', 1, 25000.00, '2025-05-10 21:37:46', 'Jlan JOgja karta ', '2025-05-15', '22:31:00', NULL, NULL), ('DP90', 'PSM42', 'MNU3', 16, 400000.00, '2025-10-10 23:32:41', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-15', '12:36:00', NULL, NULL), ('DP91', 'PSM42', 'MNU7', 16, 400000.00, '2025-10-10 23:32:41', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-15', '12:36:00', NULL, NULL), ('DP92', 'PSM43', 'MNU2', 15, 450000.00, '2025-10-10 23:33:37', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-14', '16:33:00', NULL, NULL), ('DP93', 'PSM43', 'MNU8', 15, 375000.00, '2025-10-10 23:33:37', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-14', '16:33:00', NULL, NULL), ('DP94', 'PSM43', 'MNU5', 9, 108000.00, '2025-10-10 23:33:37', 'Jl. Kenanga No. 12, Metro Timur', '2025-10-14', '16:33:00', NULL, NULL), ('DP95', 'PSM44', 'MNU7', 12, 300000.00, '2025-10-10 23:35:37', 'Jl. Gajah Mada No. 2, Metro Pusat', '2025-10-15', '10:35:00', NULL, NULL), ('DP96', 'PSM44', 'MNU4', 12, 120000.00, '2025-10-10 23:35:37', 'Jl. Gajah Mada No. 2, Metro Pusat', '2025-10-15', '10:35:00', NULL, NULL), ('DP97', 'PSM45', 'MNU8', 30, 750000.00, '2025-10-10 23:37:08', 'Jl. Gajah Mada No. 2, Metro Pusat', '2025-10-13', '17:37:00', NULL, NULL), ('DP98', 'PSM46', 'MNU3', 20, 500000.00, '2025-10-10 23:39:37', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-13', '11:39:00', NULL, NULL), ('DP99', 'PSM47', 'MNU1', 20, 500000.00, '2025-10-10 23:40:24', 'Jl. Flamboyan No. 33, Metro Pusat', '2025-10-13', '08:40:00', NULL, NULL); -- Dumping structure for table catering.kategori_menu CREATE TABLE IF NOT EXISTS `kategori_menu` ( `id_kategori` varchar(8) NOT NULL, `nama_kategori` varchar(25) NOT NULL, `deskripsi` text, PRIMARY KEY (`id_kategori`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Dumping data for table catering.kategori_menu: ~6 rows (approximately) INSERT INTO `kategori_menu` (`id_kategori`, `nama_kategori`, `deskripsi`) VALUES ('KAT1', 'Nasi Box', 'paket nasi boxx'), ('KAT2', 'Snack Premium', 'Makanan ringan premium'), ('KAT3', 'Tumpeng', 'Tumpeng keluarga'), ('KAT5', 'Catering Sehat / Diet', 'Menu rendah kalori dan bergizi seimbang untuk program diet atau hidup sehat'), ('KAT6', 'Minuman & Dessert', 'Aneka minuman segar dan pencuci mulut seperti jus, puding, dan es buah'), ('KAT7', 'Katering Harian', 'Langganan makan siang/malam harian untuk karyawan atau rumah tangga'); -- Dumping structure for table catering.menu CREATE TABLE IF NOT EXISTS `menu` ( `id_menu` varchar(8) NOT NULL, `id_kategori` varchar(8) DEFAULT NULL, `nama_menu` varchar(25) NOT NULL, `deskripsi` text, `harga` decimal(10,2) NOT NULL, `gambar` varchar(100) NOT NULL DEFAULT 'default.jpg', PRIMARY KEY (`id_menu`), KEY `id_kategori` (`id_kategori`), CONSTRAINT `menu_ibfk_1` FOREIGN KEY (`id_kategori`) REFERENCES `kategori_menu` (`id_kategori`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Dumping data for table catering.menu: ~17 rows (approximately) INSERT INTO `menu` (`id_menu`, `id_kategori`, `nama_menu`, `deskripsi`, `harga`, `gambar`) VALUES ('MNU1', 'KAT1', 'Paket 1', 'Nasi Ayam Bakar Dll', 25000.00, 'ayambakar.jpeg'), ('MNU10', 'KAT6', 'Es Buah Segar', 'Campuran buah segar dengan sirup dan es batu', 12000.00, 'es buah.jpeg'), ('MNU11', 'KAT6', 'Jus Alpukat', 'Jus alpukat kental dengan coklat leleh', 15000.00, 'alpukat.jpeg'), ('MNU12', 'KAT6', 'Puding Coklat', 'Puding lembut dengan saus coklat manis', 10000.00, 'puding coklat.jpeg'), ('MNU13', 'KAT6', 'Jus Mangga', 'Jus mangga manis dan segar tanpa tambahan gula', 13000.00, 'jus mangga.jpeg'), ('MNU14', 'KAT6', 'Es Kopi Susu', 'Kopi dingin dengan susu kental manis', 15000.00, 'kopi susu.jpeg'), ('MNU15', 'KAT6', 'Puding Vanilla', 'Puding rasa vanilla lembut dengan topping karamel', 10000.00, 'puding vanila.jpg'), ('MNU16', 'KAT6', 'Cheesecake Mini', 'Potongan cheesecake lembut dengan saus strawberry', 18000.00, 'cheesecake.jpg'), ('MNU17', 'KAT6', 'Brownies Coklat', 'Brownies panggang lembut dengan taburan kacang', 15000.00, 'brownies.jpg'), ('MNU2', 'KAT1', 'Paket 2', 'Nasi Udang Balado', 30000.00, 'udangbalado.jpeg'), ('MNU3', 'KAT1', 'Paket 3', 'Nasi Ikan Goreng', 25000.00, 'ikan.jpeg'), ('MNU4', 'KAT2', 'Paket Snack 1', 'Kue tradisonal ', 10000.00, 'snak1.jpeg'), ('MNU5', 'KAT2', 'Paket Snack 2', 'Kue Tradsisonal nikmat', 12000.00, 'snk2.jpeg'), ('MNU6', 'KAT2', 'Paket Snack 3', 'Kue tradisonal Basah', 10000.00, 'basah.jpeg'), ('MNU7', 'KAT1', 'Paket 5', 'Nasi Ikan Balado, Sayur kacang , Sambal Lalapan', 25000.00, 'ikan balado.jpg'), ('MNU8', 'KAT1', 'Paket 6', 'Nasi Ikan Kembung bakar, sayur asem dan Lalapan ', 25000.00, 'ikan bakar.jpg'), ('MNU9', 'KAT1', 'Paket 7', 'Nasi Ayam Katsu , Salad sayur , Saos', 25000.00, 'ayam katsu.jpg'); -- Dumping structure for table catering.pelanggan CREATE TABLE IF NOT EXISTS `pelanggan` ( `id_pelanggan` varchar(8) NOT NULL, `nama` varchar(40) NOT NULL, `username` varchar(20) NOT NULL, `password` varchar(255) NOT NULL, `alamat` text NOT NULL, `no_telepon` varchar(15) DEFAULT NULL, PRIMARY KEY (`id_pelanggan`), UNIQUE KEY `username` (`username`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Dumping data for table catering.pelanggan: ~22 rows (approximately) INSERT INTO `pelanggan` (`id_pelanggan`, `nama`, `username`, `password`, `alamat`, `no_telepon`) VALUES ('PLG1', 'Aliando', 'arian123', '$2y$10$Je/GNIAOceiEyMoQjC8RDuz.iZ0KdYyMtttD1aVvq/OGnHDFjTg/q', 'Metro Kibang', '6287794873280'), ('PLG10', 'Rizal Muhammad', 'rizalmd', '$2y$10$QfYwbo1d1qsLdYX2y1gCWuHMgIrcUN2Yq3W9r1B7qIngapC2nZweC', 'Bandar Lampung ', '089987765412'), ('PLG11', 'Riza Putra', 'rizap', '$2y$10$JZvGHpFy9jRfkgwXmfguz.TBgMxSWtgsCMRYHQB8L5cQU7Z45BZqe', 'Jl. Kenanga No. 12, Metro Timur', '081234567801'), ('PLG12', 'Siti Nurhaliza', 'sitinur', '$2y$10$U2hI3Fs4aMiZ2ai4pFHKje4Guf9xhSQpNnueSxmaemXfDbg9mcRHq', 'Jl. Melati No. 45, Metro Pusat', '081234567802'), ('PLG13', 'Dwi Santoso', 'dwisant', '$2y$10$JffTidBtJW3X3ZNzwIHgpOiDSa.iCRjr1xW7GoQfKBcJLpqI/fnxi', 'Jl. Dahlia No. 22, Metro Barat', '081234567803'), ('PLG14', 'Budi Rahman', 'budir', '$2y$10$j2TxqcGpjJhGisUci.pB8ORDevwegZIxrAlJZRZeG.M/z8/S3P3SG', 'Jl. Mawar No. 18, Metro Utara', '081234567804'), ('PLG15', 'Intan Lestari', 'intanl', '$2y$10$OnS/wUZperTsXuHpd91EluqmTZwb4QHza5Ny9Ye24zp0QdIl/cjM.', 'Jl. Flamboyan No. 33, Metro Pusat', '081234567805'), ('PLG16', 'Rian Saputra', 'rians', '$2y$10$CBsNuzUsnOXi2xTOY08ZHO7ldRzfoj0kawkzfd0hEtgMO/QOo4xki', 'Jl. Merpati No. 5, Batanghari', '081234567806'), ('PLG17', 'Maya Wulandari ', 'mayawu', '$2y$10$q2nPYJ7PorJ2NNbPQqXbr.DBehvi8qlrXxCAyyQQy2uFfh7nZx8Zq', 'Jl. Rajawali No. 9, Tegineneng', '081234567807'), ('PLG18', 'Adi Nugroho', 'adiung', '$2y$10$t2CwWnBujYxwjPiqLcsTT.qrD3APZT8dxHWTqRX.8dZe9f28AewXq', 'Jl. Cemara No. 15, Branti', '081234567808'), ('PLG19', 'Nisa Rahmawati', 'nisar', '$2y$10$fBYiavNx600ad2wlK1KSt.U5VzHKYuZOrwK2Cm8/tho7iBP2Z4n4q', 'Jl. Srikandi No. 8, Metro Timur', '081234567809'), ('PLG2', 'Bagus Arianto Wibisono', 'bagus123', '$2y$10$nKkaMtMdK/8l6Z9VHkdCC.LqWZeWlfpQv2P7mDy/tLqyn32iWFX2m', 'Kota Gajah', '62877554432'), ('PLG20', 'Arif Setiawan', 'arifset', '$2y$10$nd52ooErOuHv/DX6SnhwIeREwMU1tE3gfoSK1rF2LFf3vXL34X.gm', 'Jl. Gajah Mada No. 2, Metro Pusat', '081234567810'), ('PLG21', 'Winarto', 'wiwin', '$2y$10$i/ms3/NZVGX9j2118WPoLen4gGhFeaga0mH/deKjxD5Ou3ld3snEa', 'Jl Madukotro no 20 . Metro Timur', '089998887776'), ('PLG22', 'Bambang Pamungkas', 'bbm12', '$2y$10$rlirmjIKerB2IlJKeh27SuPJvgh5dU1JuAfFLAs2fkd.CHZYxztji', 'Metro kibang , Natar Lampung Selatan', '08777662291'), ('PLG23', 'Bagus AW', 'bagus22', '$2y$10$Qb7Djqmaj1zLwdfIwim.sO/TiMLhROrPjgytGOE6GCbxOr44S1Nmu', 'Jl Madukoro Tejosari Metro', '0877798978787'), ('PLG24', 'Arief Muhammad', 'arif22', '$2y$10$MqLzFux28MHbxrcoaSt3ie/TB.hhhwC0ZbCOFSfGoUvMgc1YE.fg2', 'Jalan Merdeka, Metro Pussat', '08776655445'), ('PLG25', 'Jumadi Basir', 'jumadi12', '$2y$10$xaXKp8oyOkencXH.M05LFOMr7IXslVQcfwRPYwlUzoXBs8/KDXGRK', 'Batanghari', '08999000977'), ('PLG27', 'Warttana', '08776677667', '$2y$10$2lfyfGmat581WkgmYzJBC.BdnuaoFlTJtGMczp0ScntEuN.DcPFty', 'Jl. Madukoro No.16, Tejosari, Kec. Metro Tim., Kota Metro, Lampung 34123', '08776677667'), ('PLG5', 'Aldi Yoga', 'aldi123', '$2y$10$fURForAEIkkq2.0w2dPbFu57MxgQ/lcoSZWmZKpySljBQMZwh.Aj2', 'Punggur', '628770097826'), ('PLG6', 'Iqbal Nuro', 'iqbal123', '$2y$10$TZusRLyn1nL1y/CmVyxEauA/yh.qHyVuCYPjq7aHsLy0AOyA00j7S', 'Batanghari', '62899778863'), ('PLG7', 'Yanto Nikolas', 'yantoNIK', '$2y$10$L.4kQIV65xkUPSeJpy4.Ye8SW/Q7GTI.AwoqnIsvx1I/57sJ4bGdi', 'Metro Pusat', '0988877767'), ('PLG9', 'Ainun mahya', 'ainun123', '$2y$10$CvGmseXB6682.YsijMihduKpz4s3FGoSAbt8m8Ir539YX0/yqb1uW', 'Metro kibang jalan kedaton', '09888776657'); -- Dumping structure for table catering.pembayaran CREATE TABLE IF NOT EXISTS `pembayaran` ( `id_pembayaran` varchar(8) NOT NULL, `id_pemesanan` varchar(8) DEFAULT NULL, `id_pelanggan` varchar(8) DEFAULT NULL, `bukti_pembayaran` varchar(200) DEFAULT NULL, `status_pembayaran` enum('lunas','belum lunas') NOT NULL, `metode_pembayaran` enum('midtrans','transfer','cash') DEFAULT NULL, PRIMARY KEY (`id_pembayaran`), KEY `id_pemesanan` (`id_pemesanan`), KEY `id_pelanggan` (`id_pelanggan`), CONSTRAINT `pembayaran_ibfk_1` FOREIGN KEY (`id_pemesanan`) REFERENCES `pemesanan` (`id_pemesanan`) ON DELETE CASCADE, CONSTRAINT `pembayaran_ibfk_2` FOREIGN KEY (`id_pelanggan`) REFERENCES `pelanggan` (`id_pelanggan`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Dumping data for table catering.pembayaran: ~97 rows (approximately) INSERT INTO `pembayaran` (`id_pembayaran`, `id_pemesanan`, `id_pelanggan`, `bukti_pembayaran`, `status_pembayaran`, `metode_pembayaran`) VALUES ('PMB1', 'PSM1', 'PLG5', '../uploads/ayambakar.jpeg', 'lunas', NULL), ('PMB10', 'PSM12', 'PLG17', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB100', 'PSM103', 'PLG28', NULL, 'lunas', 'cash'), ('PMB101', 'PSM104', 'PLG29', NULL, 'lunas', 'cash'), ('PMB102', 'PSM103', 'PLG30', NULL, 'lunas', 'cash'), ('PMB103', 'PSM104', 'PLG26', NULL, 'lunas', 'cash'), ('PMB104', 'PSM105', 'PLG27', NULL, 'lunas', 'cash'), ('PMB11', 'PSM13', 'PLG11', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB12', 'PSM14', 'PLG11', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB13', 'PSM15', 'PLG11', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB14', 'PSM16', 'PLG11', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB15', 'PSM17', 'PLG12', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB16', 'PSM18', 'PLG12', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB17', 'PSM19', 'PLG12', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB18', 'PSM20', 'PLG14', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB19', 'PSM21', 'PLG14', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB2', 'PSM2', 'PLG5', '../uploads/udangbalado.jpeg', 'lunas', NULL), ('PMB20', 'PSM22', 'PLG14', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB21', 'PSM24', 'PLG14', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB22', 'PSM23', 'PLG14', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB23', 'PSM25', 'PLG16', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB24', 'PSM26', 'PLG16', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB25', 'PSM27', 'PLG16', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB26', 'PSM28', 'PLG16', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB27', 'PSM29', 'PLG20', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB28', 'PSM30', 'PLG20', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB29', 'PSM31', 'PLG20', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB30', 'PSM32', 'PLG20', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB31', 'PSM33', 'PLG20', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB32', 'PSM34', 'PLG20', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB33', 'PSM35', 'PLG20', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB34', 'PSM36', 'PLG19', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB35', 'PSM37', 'PLG19', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB36', 'PSM38', 'PLG19', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB37', 'PSM39', 'PLG19', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB38', 'PSM40', 'PLG19', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB39', 'PSM41', 'PLG19', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB4', 'PSM5', 'PLG6', '../uploads/dfd.drawio.png', 'lunas', NULL), ('PMB40', 'PSM42', 'PLG19', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB41', 'PSM43', 'PLG19', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB42', 'PSM44', 'PLG20', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB43', 'PSM45', 'PLG20', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB44', 'PSM46', 'PLG15', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB45', 'PSM47', 'PLG15', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB46', 'PSM48', 'PLG15', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB47', 'PSM49', 'PLG15', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB48', 'PSM50', 'PLG15', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB49', 'PSM51', 'PLG15', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB5', 'PSM6', 'PLG7', '../uploads/basah.jpeg', 'lunas', NULL), ('PMB50', 'PSM52', 'PLG15', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB51', 'PSM53', 'PLG15', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB52', 'PSM54', 'PLG15', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB53', 'PSM55', 'PLG17', '../uploads/1760172465_bb.jpeg', 'lunas', NULL), ('PMB54', 'PSM56', 'PLG17', '../uploads/1760280790_bb.jpeg', 'lunas', NULL), ('PMB55', 'PSM57', 'PLG17', '../uploads/1760281302_bb.jpeg', 'lunas', NULL), ('PMB56', 'PSM58', 'PLG17', '../uploads/1761799300_uhuy.drawio.png', 'lunas', NULL), ('PMB57', 'PSM59', 'PLG17', '../uploads/1761820848_uhuy.drawio.png', 'lunas', NULL), ('PMB58', 'PSM60', 'PLG17', '../uploads/1761822412_uhuy.drawio.png', 'lunas', NULL), ('PMB59', 'PSM61', 'PLG17', '../uploads/1761893033_uhuy.drawio.png', 'lunas', NULL), ('PMB6', 'PSM7', 'PLG2', '../uploads/j.drawio.png', 'lunas', NULL), ('PMB60', 'PSM62', 'PLG17', '../uploads/1761893403_uhuy.drawio.png', 'lunas', NULL), ('PMB61', 'PSM63', 'PLG17', '../uploads/1761894190_uhuy.drawio.png', 'lunas', NULL), ('PMB62', 'PSM64', 'PLG17', '../uploads/1761894833_uhuy.drawio.png', 'lunas', NULL), ('PMB63', 'PSM65', 'PLG14', '../uploads/1761896203_uhuy.drawio.png', 'lunas', NULL), ('PMB64', 'PSM66', 'PLG11', '../uploads/1762065488_bb.jpeg', 'lunas', NULL), ('PMB65', 'PSM67', 'PLG11', '../uploads/1762066492_bb.jpeg', 'lunas', NULL), ('PMB66', 'PSM68', 'PLG11', '../uploads/1762067745_bb.jpeg', 'lunas', NULL), ('PMB67', 'PSM69', 'PLG17', '../uploads/1762423099_bb.jpeg', 'lunas', NULL), ('PMB68', 'PSM70', 'PLG18', '../uploads/1763966174_bb.jpeg', 'lunas', NULL), ('PMB69', 'PSM71', 'PLG20', '../uploads/1763966291_bb.jpeg', 'lunas', NULL), ('PMB70', 'PSM72', 'PLG20', '../uploads/1763966416_bb.jpeg', 'lunas', NULL), ('PMB71', 'PSM73', 'PLG20', '../uploads/1763992370_bb.jpeg', 'lunas', NULL), ('PMB72', 'PSM74', 'PLG20', '../uploads/1764033305_bb.jpeg', 'lunas', NULL), ('PMB73', 'PSM76', 'PLG17', '../uploads/1764170585_bb.jpeg', 'lunas', NULL), ('PMB74', 'PSM75', 'PLG17', '../uploads/1764170615_keranjang_kosong.png', 'lunas', NULL), ('PMB75', 'PSM77', 'PLG17', '../uploads/1766760169_k.drawio.png', 'lunas', NULL), ('PMB76', 'PSM78', 'PLG17', '../uploads/1766762303_k.drawio.png', 'lunas', NULL), ('PMB77', 'PSM79', 'PLG14', '../uploads/1766762409_k.drawio.png', 'lunas', NULL), ('PMB78', 'PSM80', 'PLG19', '../uploads/1766762469_rd.drawio.png', 'lunas', NULL), ('PMB79', 'PSM82', 'PLG18', '../uploads/1767349082_Jurnal.png', 'lunas', NULL), ('PMB8', 'PSM11', 'PLG17', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB80', 'PSM83', 'PLG20', '../uploads/1767349237_Jurnal.png', 'lunas', NULL), ('PMB81', 'PSM84', 'PLG16', '../uploads/1767364383_WhatsApp Image 2026-01-02 at 19.19.52.jpeg', 'lunas', NULL), ('PMB82', 'PSM85', 'PLG14', '../uploads/1767364482_WhatsApp Image 2026-01-02 at 19.19.52 (1).jpeg', 'lunas', NULL), ('PMB83', 'PSM86', 'PLG15', '../uploads/1767364590_WhatsApp Image 2026-01-02 at 19.19.52 (1).jpeg', 'lunas', NULL), ('PMB84', 'PSM87', 'PLG15', '../uploads/1767364976_WhatsApp Image 2026-01-02 at 19.19.52.jpeg', 'lunas', NULL), ('PMB85', 'PSM88', 'PLG17', '../uploads/1767509918_WhatsApp Image 2026-01-02 at 19.19.52.jpeg', 'lunas', NULL), ('PMB86', 'PSM89', 'PLG23', '../uploads/1767605981_bb.jpeg', 'lunas', NULL), ('PMB87', 'PSM90', 'PLG11', '../uploads/1767606148_WhatsApp Image 2026-01-02 at 19.19.52 (1).jpeg', 'lunas', NULL), ('PMB88', 'PSM91', 'PLG17', '../uploads/1767881220_bb.jpeg', 'lunas', NULL), ('PMB89', 'PSM92', 'PLG14', '../uploads/1767881369_bb.jpeg', 'lunas', NULL), ('PMB9', 'PSM10', 'PLG17', '../uploads/bb.jpeg', 'lunas', NULL), ('PMB90', 'PSM93', 'PLG12', '../uploads/1767881481_bb.jpeg', 'lunas', NULL), ('PMB91', 'PSM94', 'PLG12', '../uploads/1767881605_bb.jpeg', 'lunas', NULL), ('PMB92', 'PSM95', 'PLG17', '../uploads/1769063668_bb.jpeg', 'lunas', NULL), ('PMB93', 'PSM96', 'PLG24', '../uploads/1769215210_bb.jpeg', 'lunas', NULL), ('PMB94', 'PSM97', 'PLG18', '../uploads/1769215443_bb.jpeg', 'lunas', NULL), ('PMB95', 'PSM98', 'PLG16', '../uploads/1769215582_bb.jpeg', 'lunas', NULL), ('PMB96', 'PSM99', 'PLG17', '../uploads/1769273211_bb.jpeg', 'lunas', NULL), ('PMB97', 'PSM100', 'PLG25', '../uploads/1769274896_bb.jpeg', 'lunas', NULL), ('PMB98', 'PSM101', 'PLG25', '../uploads/1769324547_bb.jpeg', 'lunas', NULL), ('PMB99', 'PSM102', 'PLG25', '../uploads/1769391468_bb.jpeg', 'lunas', NULL); -- Dumping structure for table catering.pemesanan CREATE TABLE IF NOT EXISTS `pemesanan` ( `id_pemesanan` varchar(8) NOT NULL, `id_pelanggan` varchar(8) DEFAULT NULL, `total_harga` decimal(10,2) NOT NULL, `status_pesanan` enum('menunggu','diproses','selesai','dibatalkan') NOT NULL, `sumber_pesanan` enum('web','telepon','langsung') DEFAULT 'web', PRIMARY KEY (`id_pemesanan`), KEY `id_pelanggan` (`id_pelanggan`), CONSTRAINT `pemesanan_ibfk_1` FOREIGN KEY (`id_pelanggan`) REFERENCES `pelanggan` (`id_pelanggan`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Dumping data for table catering.pemesanan: ~99 rows (approximately) INSERT INTO `pemesanan` (`id_pemesanan`, `id_pelanggan`, `total_harga`, `status_pesanan`, `sumber_pesanan`) VALUES ('PSM1', 'PLG5', 625000.00, 'selesai', 'web'), ('PSM10', 'PLG17', 490000.00, 'selesai', 'web'), ('PSM100', 'PLG25', 300000.00, 'selesai', 'web'), ('PSM101', 'PLG25', 250000.00, 'selesai', 'web'), ('PSM102', 'PLG25', 125000.00, 'selesai', 'web'), ('PSM103', 'PLG30', 150000.00, 'diproses', 'langsung'), ('PSM104', 'PLG26', 150000.00, 'diproses', 'langsung'), ('PSM105', 'PLG27', 150000.00, 'selesai', 'langsung'), ('PSM11', 'PLG17', 230000.00, 'selesai', 'web'), ('PSM12', 'PLG17', 550000.00, 'selesai', 'web'), ('PSM13', 'PLG11', 1470000.00, 'selesai', 'web'), ('PSM14', 'PLG11', 220000.00, 'selesai', 'web'), ('PSM15', 'PLG11', 364000.00, 'selesai', 'web'), ('PSM16', 'PLG11', 864000.00, 'selesai', 'web'), ('PSM17', 'PLG12', 245000.00, 'selesai', 'web'), ('PSM18', 'PLG12', 588000.00, 'selesai', 'web'), ('PSM19', 'PLG12', 480000.00, 'selesai', 'web'), ('PSM2', 'PLG5', 25000.00, 'selesai', 'web'), ('PSM20', 'PLG14', 670000.00, 'selesai', 'web'), ('PSM21', 'PLG14', 670000.00, 'selesai', 'web'), ('PSM22', 'PLG14', 600000.00, 'selesai', 'web'), ('PSM23', 'PLG14', 700000.00, 'selesai', 'web'), ('PSM24', 'PLG14', 270000.00, 'selesai', 'web'), ('PSM25', 'PLG16', 440000.00, 'selesai', 'web'), ('PSM26', 'PLG16', 502000.00, 'selesai', 'web'), ('PSM27', 'PLG16', 1560000.00, 'selesai', 'web'), ('PSM28', 'PLG16', 640000.00, 'selesai', 'web'), ('PSM29', 'PLG20', 750000.00, 'selesai', 'web'), ('PSM3', 'PLG5', 500000.00, 'selesai', 'web'), ('PSM30', 'PLG20', 640000.00, 'selesai', 'web'), ('PSM31', 'PLG20', 638000.00, 'selesai', 'web'), ('PSM32', 'PLG20', 850000.00, 'selesai', 'web'), ('PSM33', 'PLG20', 440000.00, 'selesai', 'web'), ('PSM34', 'PLG20', 750000.00, 'selesai', 'web'), ('PSM35', 'PLG20', 750000.00, 'selesai', 'web'), ('PSM36', 'PLG19', 490000.00, 'selesai', 'web'), ('PSM37', 'PLG19', 720000.00, 'selesai', 'web'), ('PSM38', 'PLG19', 620000.00, 'selesai', 'web'), ('PSM39', 'PLG19', 750000.00, 'selesai', 'web'), ('PSM40', 'PLG19', 700000.00, 'selesai', 'web'), ('PSM41', 'PLG19', 420000.00, 'selesai', 'web'), ('PSM42', 'PLG19', 800000.00, 'selesai', 'web'), ('PSM43', 'PLG19', 933000.00, 'selesai', 'web'), ('PSM44', 'PLG20', 420000.00, 'selesai', 'web'), ('PSM45', 'PLG20', 750000.00, 'selesai', 'web'), ('PSM46', 'PLG15', 500000.00, 'selesai', 'web'), ('PSM47', 'PLG15', 600000.00, 'selesai', 'web'), ('PSM48', 'PLG15', 450000.00, 'selesai', 'web'), ('PSM49', 'PLG15', 370000.00, 'selesai', 'web'), ('PSM5', 'PLG6', 25000.00, 'selesai', 'web'), ('PSM50', 'PLG15', 500000.00, 'selesai', 'web'), ('PSM51', 'PLG15', 540000.00, 'selesai', 'web'), ('PSM52', 'PLG15', 660000.00, 'selesai', 'web'), ('PSM53', 'PLG15', 500000.00, 'selesai', 'web'), ('PSM54', 'PLG15', 466000.00, 'selesai', 'web'), ('PSM55', 'PLG17', 300000.00, 'selesai', 'web'), ('PSM56', 'PLG17', 600000.00, 'selesai', 'web'), ('PSM57', 'PLG17', 370000.00, 'selesai', 'web'), ('PSM58', 'PLG17', 2500000.00, 'selesai', 'web'), ('PSM59', 'PLG17', 300000.00, 'selesai', 'web'), ('PSM6', 'PLG7', 400000.00, 'selesai', 'web'), ('PSM60', 'PLG17', 475000.00, 'selesai', 'web'), ('PSM61', 'PLG17', 250000.00, 'selesai', 'web'), ('PSM62', 'PLG17', 150000.00, 'selesai', 'web'), ('PSM63', 'PLG17', 250000.00, 'selesai', 'web'), ('PSM64', 'PLG17', 875000.00, 'selesai', 'web'), ('PSM65', 'PLG14', 300000.00, 'selesai', 'web'), ('PSM66', 'PLG11', 1250000.00, 'selesai', 'web'), ('PSM67', 'PLG11', 600000.00, 'selesai', 'web'), ('PSM68', 'PLG11', 500000.00, 'selesai', 'web'), ('PSM69', 'PLG17', 300000.00, 'selesai', 'web'), ('PSM7', 'PLG2', 25000.00, 'selesai', 'web'), ('PSM70', 'PLG18', 30000.00, 'selesai', 'web'), ('PSM71', 'PLG20', 625000.00, 'selesai', 'web'), ('PSM72', 'PLG20', 250000.00, 'selesai', 'web'), ('PSM73', 'PLG20', 350000.00, 'selesai', 'web'), ('PSM74', 'PLG20', 250000.00, 'selesai', 'web'), ('PSM75', 'PLG17', 55000.00, 'selesai', 'web'), ('PSM76', 'PLG17', 25000.00, 'selesai', 'web'), ('PSM77', 'PLG17', 25000.00, 'selesai', 'web'), ('PSM78', 'PLG17', 250000.00, 'selesai', 'web'), ('PSM79', 'PLG14', 30000.00, 'selesai', 'web'), ('PSM80', 'PLG19', 30000.00, 'selesai', 'web'), ('PSM81', 'PLG19', 25000.00, 'selesai', 'web'), ('PSM82', 'PLG18', 400000.00, 'selesai', 'web'), ('PSM83', 'PLG20', 370000.00, 'selesai', 'web'), ('PSM84', 'PLG16', 620000.00, 'selesai', 'web'), ('PSM85', 'PLG14', 450000.00, 'selesai', 'web'), ('PSM86', 'PLG15', 620000.00, 'selesai', 'web'), ('PSM87', 'PLG15', 500000.00, 'selesai', 'web'), ('PSM88', 'PLG17', 360000.00, 'selesai', 'web'), ('PSM89', 'PLG23', 275000.00, 'selesai', 'web'), ('PSM90', 'PLG11', 300000.00, 'selesai', 'web'), ('PSM91', 'PLG17', 210000.00, 'selesai', 'web'), ('PSM92', 'PLG14', 450000.00, 'selesai', 'web'), ('PSM93', 'PLG12', 350000.00, 'selesai', 'web'), ('PSM94', 'PLG12', 500000.00, 'selesai', 'web'), ('PSM95', 'PLG17', 300000.00, 'selesai', 'web'), ('PSM96', 'PLG24', 175000.00, 'selesai', 'web'), ('PSM97', 'PLG18', 250000.00, 'selesai', 'web'), ('PSM98', 'PLG16', 222000.00, 'selesai', 'web'), ('PSM99', 'PLG17', 250000.00, 'selesai', 'web'); /*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */; /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; /*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;