-- --------------------------------------------------------
-- 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 structure for table manajementoko_ci4.customer
CREATE TABLE IF NOT EXISTS `customer` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nama` varchar(150) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `telepon` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `alamat` text COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table manajementoko_ci4.customer: ~49 rows (approximately)
DELETE FROM `customer`;
INSERT INTO `customer` (`id`, `nama`, `telepon`, `alamat`) VALUES
	(1, 'Sushi Hiro Palembang Indah Mall', NULL, 'Jl. Letkol Iskandar No.18, 24 Ilir, Kec. Bukit Kecil, Palembang'),
	(2, 'Sushi Hiro Palembang Icon', NULL, 'Jl. POM IX Lorok Pakjo, Kec. Ilir Bar. I, Palembang'),
	(3, 'Bp. Dhandy', NULL, 'Jl. Baypas Alang-Alang Lebar, Palembang'),
	(4, 'Airish Caffee', NULL, 'Jl. Perumnas Talang Kelapa, Palembang'),
	(5, 'Kedai Mirai', NULL, 'Jl. Suka Bangun II, Depan Soccer Sultan, Palembang'),
	(6, 'Pu Yang Kopitiam', NULL, 'Jl. Angkatan 45 No.15-16 Sungai Pengeran IB 1, Palembang'),
	(7, 'Dunia Frozen Food', NULL, 'Jl. Maskarebet Raya Km 10, Palembang'),
	(8, 'Selcout Coffee', NULL, 'Jl. MP. Mangkunegara, Jl. Kenten Hijau No.432, Bukit Sangkal, Kec. Kalidoni, Palembang'),
	(9, 'Gardenta - Resort Resto & Kedai Kopi', NULL, 'Jl. Sosial No.80, Suka Bangun, Kec. Sukarami, Palembang'),
	(10, 'Hotel Harper', NULL, 'Jl. R. Sukamto No.20, 20 Ilir D II, Kec. Kemuning, Palembang'),
	(11, 'Namthai', NULL, 'Lorong Masawa No.231, 13 Ilir, Palembang'),
	(12, 'SPPG Yayasan Sahabat Sampai Surga', NULL, 'Jl. Palembang - Betung KM 18, Banyuasin'),
	(13, 'Bp. Mochammad Ridho Saputra', NULL, 'Jl. AKBP. H. Umar No.616, RT.022, RW.001 Kemuning, Palembang'),
	(14, 'SPPG Moga Berkah Sukamaju', NULL, 'Jl. Palembang - Jambi Sei Lilin, Musi Banyuasin'),
	(15, 'Caffe The Peaks', NULL, 'Jl. Jaksa Agung R. Soeprapto No.130A-B, 26 Ilir D. I, Kec. Ilir Bar. I, Palembang'),
	(16, 'Ibu Fuji Astuti', NULL, 'Jl. Palembang - Betung, Sukajadi, Musi Banyuasin'),
	(17, 'Ibu Miswati', NULL, 'Jl. Lintas Sumatera, Tugu Mulyo, Ogan Komering Ilir'),
	(18, 'Healthy Go', NULL, 'Jl. Ciliwung, Suka Maju, Kec. Sako, Palembang'),
	(19, 'Butcher Steak', NULL, 'Jl. AKBP Cek Agus No.284, Duku, Kec. Ilir Tim. II, Palembang 30114'),
	(20, 'Nasi Cia', NULL, 'Jl. Angkatan 66 G No.1, Pipa Jaya, Kec. Kemuning, Palembang'),
	(21, 'Gachi Korean Restaurant', NULL, 'Union Pointe, Jl. AKBP Cek Agus Gedung No.286, Duku, Kec. Ilir Tim. II, Palembang'),
	(22, 'PT. Grand Sarana Mandiri', NULL, 'Jl. Veteran No.999, 9 Ilir, Kec. Ilir Tim. II, Palembang'),
	(23, 'RM. Selera Minang', NULL, 'Jl. Mayor Ruslan 2 Lahat (Depan PS Lematang sebelah TK Roti Paul & Co), Lahat'),
	(24, 'Shaburista', NULL, 'Komplek Ruko Taman Mandiri Blok B1 No. 9-11, Palembang'),
	(25, 'Tatashop Frozen Food', NULL, 'Jl. Siaran No.13a, Sako Baru, Kec. Sako, Palembang'),
	(26, 'Comforta Suites Hotel', NULL, 'Jl. Veteran No.125G, Kuto Batu, Kec. Ilir Tim. II, Palembang 30114'),
	(27, 'Catering Tiara', NULL, 'Suka Karya III, Suka Maku, Kec. Sako, Palembang'),
	(28, 'Nobu Bistro', NULL, 'Jl. Sumpah Pemuda, Lorok Pakjo, Kec. Ilir Bar. I, Palembang'),
	(29, 'SPPG Dapur Sehat Istana Gizi Lilin Jaya', NULL, 'Jl. Raya Palembang - Jambi KM 118 Samping Bengkel ARP Sungai Lilin, Musi Banyuasin'),
	(30, 'Nasi Bakar Pakjo', NULL, 'Jl. Veteran No.69A, Kuto Batu, Kec. Ilir Timur III, Palembang 30113'),
	(31, 'THE ALTS HOTEL', NULL, 'Jl. Rajawali No.8, 9 Ilir, Ilir Timur III, Palembang'),
	(32, 'Celebrity Cafe', NULL, 'Jl. Veteran No.1242-1243, Kuto Batu, Kec. Ilir Tim. II, Palembang'),
	(33, 'RM Sederhana Kenten', NULL, 'Jl. MP. Mangkunegara No.95-97, Bukit Sangkal, Kec. Ilir Tim. II, Palembang'),
	(34, 'PT Podo Moro', NULL, 'Jl. Tegal Binangun, Palembang'),
	(35, 'Keyla Katering Palembang', NULL, 'Jl. Perindustrian II Komp. Victoria Park Blok C No.01, Kebun Bunga, Kec. Sukarami, Palembang'),
	(36, 'Wyndham Opi Hotel Palembang', NULL, 'Komplek Opi Bisnis Center, Opi Mall, Jl. Gubernur H. A Bastari, Sungai Kedukan, Rambutan, Banyuasin'),
	(37, 'Tahu Sumedang Renyah Banyuasin', NULL, 'Jl. Jenderal Sudirman KM.41, RT.7/RW.2, Pangkalan Panji, Kec. Banyuasin III'),
	(38, 'Rumah Frozen Dewi', NULL, 'Jl. Mayor Salim Batu Bara, Palembang'),
	(39, 'Tahu Sumedang Renyah Prabumulih', NULL, 'Jl. Jenderal Sudirman, Patih Galung, Kec. Prabumulih'),
	(40, 'Coffee J Kedai Kopi & Resto', NULL, 'Jl. Jaksa Agung No.26, Bukit Kecil, Palembang'),
	(41, 'Brosis Suka Frozen Food', NULL, 'Jl. Muhajirin, Indralaya'),
	(42, 'Hotel Novotel', NULL, 'Jl. R. Sukamto No.8A, 8 Ilir, Kec. Ilir Tim. II, Palembang'),
	(43, 'SPPG Alang-Alang Lebar 2 (Dapur Ecy)', NULL, 'Jl. Pajak Permai Km 11, Alang-Alang Lebar, Palembang'),
	(44, 'RM Sri Melayu', NULL, 'Jl. Demang Lebar Daun No.1, Demang Lebar Daun, Kec. Ilir Bar. I, Palembang'),
	(45, 'Ibu Mei In', NULL, 'Jl. Abu Sama, Suka Jaya, Palembang'),
	(46, 'PT Listi Harjo Makmur', NULL, 'Jl. Sako Baru, Sako, Palembang'),
	(47, 'Noiis Diet Catering', NULL, 'Jl. Mawar, Sukajaya, Kec. Sukarami, Palembang'),
	(48, 'Bp. Riyan', NULL, 'Jl. Segaran 15 Ilir, Palembang'),
	(49, 'User', NULL, '');

-- Dumping structure for table manajementoko_ci4.karyawan
CREATE TABLE IF NOT EXISTS `karyawan` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nama` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `jabatan` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `telepon` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `alamat` text COLLATE utf8mb4_general_ci,
  `gaji_pokok` decimal(15,2) DEFAULT '0.00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table manajementoko_ci4.karyawan: ~1 rows (approximately)
DELETE FROM `karyawan`;
INSERT INTO `karyawan` (`id`, `nama`, `jabatan`, `telepon`, `alamat`, `gaji_pokok`) VALUES
	(1, 'Fahrul Adib', 'Programmer', '082266335544', 'Palembang', 9000000.00);

-- Dumping structure for table manajementoko_ci4.kategori
CREATE TABLE IF NOT EXISTS `kategori` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nama` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table manajementoko_ci4.kategori: ~7 rows (approximately)
DELETE FROM `kategori`;
INSERT INTO `kategori` (`id`, `nama`) VALUES
	(1, 'Beef'),
	(2, 'Buffalo'),
	(3, 'Seafood'),
	(4, 'Chicken'),
	(5, 'Olahan'),
	(6, 'Lamb'),
	(7, 'Japonica Rice');

-- Dumping structure for table manajementoko_ci4.orders
CREATE TABLE IF NOT EXISTS `orders` (
  `id` int NOT NULL AUTO_INCREMENT,
  `no_invoice` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `tanggal` date DEFAULT NULL,
  `customer_id` int DEFAULT NULL,
  `subtotal` decimal(15,2) DEFAULT NULL,
  `diskon` decimal(15,2) DEFAULT '0.00',
  `total` decimal(15,2) DEFAULT NULL,
  `total_hpp` decimal(15,2) DEFAULT NULL,
  `status_bayar` varchar(10) COLLATE utf8mb4_general_ci DEFAULT 'lunas',
  `catatan` text COLLATE utf8mb4_general_ci,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table manajementoko_ci4.orders: ~0 rows (approximately)
DELETE FROM `orders`;
INSERT INTO `orders` (`id`, `no_invoice`, `tanggal`, `customer_id`, `subtotal`, `diskon`, `total`, `total_hpp`, `status_bayar`, `catatan`, `created_at`) VALUES
	(3, 'INV-20261110-001', '2026-11-10', 4, 602000.00, 100000.00, 502000.00, 510000.00, 'lunas', '', '2026-11-10 17:14:41');

-- Dumping structure for table manajementoko_ci4.order_items
CREATE TABLE IF NOT EXISTS `order_items` (
  `id` int NOT NULL AUTO_INCREMENT,
  `order_id` int DEFAULT NULL,
  `produk_id` int DEFAULT NULL,
  `qty` decimal(12,2) DEFAULT NULL,
  `harga` decimal(15,2) DEFAULT NULL,
  `hpp` decimal(15,2) DEFAULT NULL,
  `subtotal` decimal(15,2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table manajementoko_ci4.order_items: ~0 rows (approximately)
DELETE FROM `order_items`;
INSERT INTO `order_items` (`id`, `order_id`, `produk_id`, `qty`, `harga`, `hpp`, `subtotal`) VALUES
	(4, 3, 1, 2.00, 218500.00, 185000.00, 437000.00),
	(5, 3, 2, 1.00, 165000.00, 140000.00, 165000.00);

-- Dumping structure for table manajementoko_ci4.pemusnahan
CREATE TABLE IF NOT EXISTS `pemusnahan` (
  `id` int NOT NULL AUTO_INCREMENT,
  `no_transaksi` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `tanggal` date DEFAULT NULL,
  `total_kerugian` decimal(15,2) DEFAULT NULL,
  `catatan` text COLLATE utf8mb4_general_ci,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table manajementoko_ci4.pemusnahan: ~0 rows (approximately)
DELETE FROM `pemusnahan`;
INSERT INTO `pemusnahan` (`id`, `no_transaksi`, `tanggal`, `total_kerugian`, `catatan`, `created_at`) VALUES
	(2, 'MSN-20261110-001', '2026-11-10', 185000.00, '', '2026-11-10 17:16:54');

-- Dumping structure for table manajementoko_ci4.pemusnahan_items
CREATE TABLE IF NOT EXISTS `pemusnahan_items` (
  `id` int NOT NULL AUTO_INCREMENT,
  `pemusnahan_id` int DEFAULT NULL,
  `produk_id` int DEFAULT NULL,
  `qty` decimal(12,2) DEFAULT NULL,
  `hpp` decimal(15,2) DEFAULT NULL,
  `subtotal` decimal(15,2) DEFAULT NULL,
  `alasan` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table manajementoko_ci4.pemusnahan_items: ~0 rows (approximately)
DELETE FROM `pemusnahan_items`;
INSERT INTO `pemusnahan_items` (`id`, `pemusnahan_id`, `produk_id`, `qty`, `hpp`, `subtotal`, `alasan`) VALUES
	(2, 2, 1, 1.00, 185000.00, 185000.00, 'kedaluarsa');

-- Dumping structure for table manajementoko_ci4.pengeluaran
CREATE TABLE IF NOT EXISTS `pengeluaran` (
  `id` int NOT NULL AUTO_INCREMENT,
  `no_transaksi` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `tanggal` date DEFAULT NULL,
  `jenis` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `supplier_id` int DEFAULT NULL,
  `periode` varchar(7) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `total` decimal(15,2) DEFAULT NULL,
  `catatan` text COLLATE utf8mb4_general_ci,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table manajementoko_ci4.pengeluaran: ~0 rows (approximately)
DELETE FROM `pengeluaran`;
INSERT INTO `pengeluaran` (`id`, `no_transaksi`, `tanggal`, `jenis`, `supplier_id`, `periode`, `total`, `catatan`, `created_at`) VALUES
	(2, 'PEN-20261110-001', '2026-11-10', 'penggajian', NULL, '2026-11', 10500000.00, NULL, '2026-11-10 17:12:32'),
	(3, 'PEM-20261110-001', '2026-11-10', 'pembelian', 1, NULL, 560000.00, '', '2026-11-10 17:15:35'),
	(4, 'PEM-20261110-002', '2026-11-10', 'pembelian', 1, NULL, 185000.00, '', '2026-11-10 17:17:59');

-- Dumping structure for table manajementoko_ci4.pengeluaran_items
CREATE TABLE IF NOT EXISTS `pengeluaran_items` (
  `id` int NOT NULL AUTO_INCREMENT,
  `pengeluaran_id` int DEFAULT NULL,
  `produk_id` int DEFAULT NULL,
  `karyawan_id` int DEFAULT NULL,
  `keterangan` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `qty` decimal(12,2) DEFAULT NULL,
  `harga` decimal(15,2) DEFAULT NULL,
  `subtotal` decimal(15,2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table manajementoko_ci4.pengeluaran_items: ~0 rows (approximately)
DELETE FROM `pengeluaran_items`;
INSERT INTO `pengeluaran_items` (`id`, `pengeluaran_id`, `produk_id`, `karyawan_id`, `keterangan`, `qty`, `harga`, `subtotal`) VALUES
	(2, 2, NULL, 1, 'Gaji Pokok', 1.00, 9000000.00, 9000000.00),
	(3, 2, NULL, 1, 'Bonus', 1.00, 1500000.00, 1500000.00),
	(4, 3, 2, NULL, NULL, 4.00, 140000.00, 560000.00),
	(5, 4, 1, NULL, NULL, 1.00, 185000.00, 185000.00);

-- Dumping structure for table manajementoko_ci4.produk
CREATE TABLE IF NOT EXISTS `produk` (
  `id` int NOT NULL AUTO_INCREMENT,
  `kode` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `nama` varchar(150) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `kategori_id` int DEFAULT NULL,
  `satuan` varchar(20) COLLATE utf8mb4_general_ci DEFAULT 'kg',
  `hpp` decimal(15,2) DEFAULT '0.00',
  `harga_jual` decimal(15,2) DEFAULT '0.00',
  `stok` decimal(12,2) DEFAULT '0.00',
  `stok_minimum` decimal(12,2) DEFAULT '0.00',
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table manajementoko_ci4.produk: ~52 rows (approximately)
DELETE FROM `produk`;
INSERT INTO `produk` (`id`, `kode`, `nama`, `kategori_id`, `satuan`, `hpp`, `harga_jual`, `stok`, `stok_minimum`, `created_at`) VALUES
	(1, 'BF-001', 'Beef Tenderloin', 1, 'Kg', 185000.00, 218500.00, 25.00, 10.00, '2026-11-10 09:27:40'),
	(2, 'BF-002', 'Beef Striploin', 1, 'Kg', 140000.00, 165000.00, 37.00, 10.00, '2026-11-10 09:27:40'),
	(3, 'BF-003', 'Beef Knuckle', 1, 'kg', 105000.00, 124000.00, 41.00, 10.00, '2026-11-10 09:27:40'),
	(4, 'BF-004', 'Beef Topside', 1, 'kg', 100000.00, 118000.00, 48.00, 10.00, '2026-11-10 09:27:40'),
	(5, 'BF-005', 'Beef Silverside', 1, 'kg', 98000.00, 115500.00, 55.00, 10.00, '2026-11-10 09:27:40'),
	(6, 'BF-006', 'Beef Blade', 1, 'kg', 95000.00, 112000.00, 62.00, 10.00, '2026-11-10 09:27:40'),
	(7, 'BF-007', 'Beef Meltique Whole', 1, 'kg', 150000.00, 177000.00, 69.00, 10.00, '2026-11-10 09:27:40'),
	(8, 'BF-008', 'Beef Meltique Cuting 200g', 1, 'kg', 160000.00, 189000.00, 76.00, 10.00, '2026-11-10 09:27:40'),
	(9, 'BF-009', 'Beef Shortribs', 1, 'kg', 120000.00, 141500.00, 22.00, 10.00, '2026-11-10 09:27:40'),
	(10, 'BF-010', 'Beef Backribs', 1, 'kg', 85000.00, 100500.00, 29.00, 10.00, '2026-11-10 09:27:40'),
	(11, 'BF-011', 'Beef Neckbone', 1, 'kg', 60000.00, 71000.00, 36.00, 10.00, '2026-11-10 09:27:40'),
	(12, 'BF-012', 'Beef Fat', 1, 'kg', 20000.00, 23500.00, 43.00, 10.00, '2026-11-10 09:27:40'),
	(13, 'BF-013', 'Beef Liver', 1, 'kg', 50000.00, 59000.00, 50.00, 10.00, '2026-11-10 09:27:40'),
	(14, 'BF-014', 'Beef Lung', 1, 'kg', 40000.00, 47000.00, 57.00, 10.00, '2026-11-10 09:27:40'),
	(15, 'BF-015', 'Beef Liga Mentum', 1, 'kg', 75000.00, 88500.00, 64.00, 10.00, '2026-11-10 09:27:40'),
	(16, 'BF-016', 'Beef Feet', 1, 'kg', 45000.00, 53000.00, 71.00, 10.00, '2026-11-10 09:27:40'),
	(17, 'BF-017', 'Beef Oxtail All Cut Local', 1, 'kg', 110000.00, 130000.00, 78.00, 10.00, '2026-11-10 09:27:40'),
	(18, 'BF-018', 'Beef Oxtail All Cut Import', 1, 'kg', 100000.00, 118000.00, 24.00, 10.00, '2026-11-10 09:27:40'),
	(19, 'BF-019', 'Beef Oxtail Center Cut Local', 1, 'kg', 125000.00, 147500.00, 31.00, 10.00, '2026-11-10 09:27:40'),
	(20, 'BF-020', 'Beef Oxtail Center Cut Import', 1, 'kg', 115000.00, 135500.00, 38.00, 10.00, '2026-11-10 09:27:40'),
	(21, 'BF-021', 'Minced Beef', 1, 'kg', 90000.00, 106000.00, 45.00, 10.00, '2026-11-10 09:27:41'),
	(22, 'BFL-001', 'Buffalo Hq Tenderloin (31)', 2, 'kg', 105000.00, 124000.00, 52.00, 10.00, '2026-11-10 09:27:41'),
	(23, 'BFL-002', 'Buffalo Hq Knuckle (42)', 2, 'kg', 80000.00, 94500.00, 59.00, 10.00, '2026-11-10 09:27:41'),
	(24, 'BFL-004', 'Buffalo Hq Topside (41)', 2, 'kg', 78000.00, 92000.00, 66.00, 10.00, '2026-11-10 09:27:41'),
	(25, 'BFL-005', 'Buffalo Hq Silverside (44)', 2, 'kg', 76000.00, 89500.00, 73.00, 10.00, '2026-11-10 09:27:41'),
	(26, 'BFL-006', 'Buffalo Hq Rump (45)', 2, 'kg', 82000.00, 97000.00, 80.00, 10.00, '2026-11-10 09:27:41'),
	(27, 'BFL-007', 'Buffalo Fq Blade (65)', 2, 'kg', 65000.00, 76500.00, 26.00, 10.00, '2026-11-10 09:27:41'),
	(28, 'BFL-008', 'Buffalo Fq (11)', 2, 'kg', 62000.00, 73000.00, 33.00, 10.00, '2026-11-10 09:27:41'),
	(29, 'BFL-009', 'Buffalo Fq (106)', 2, 'kg', 60000.00, 71000.00, 40.00, 10.00, '2026-11-10 09:27:41'),
	(30, 'BFL-010', 'Buffalo Fq (18)', 2, 'kg', 58000.00, 68500.00, 47.00, 10.00, '2026-11-10 09:27:41'),
	(31, 'BFL-011', 'Buffalo Fq (16)', 2, 'kg', 56000.00, 66000.00, 54.00, 10.00, '2026-11-10 09:27:41'),
	(32, 'SF-001', 'Fish Salmon Whole Headless', 3, 'kg', 165000.00, 194500.00, 61.00, 10.00, '2026-11-10 09:27:41'),
	(33, 'SF-002', 'Fish Salmon Whole Head On', 3, 'kg', 140000.00, 165000.00, 68.00, 10.00, '2026-11-10 09:27:41'),
	(34, 'SF-003', 'Squide Tube', 3, 'kg', 60000.00, 71000.00, 75.00, 10.00, '2026-11-10 09:27:41'),
	(35, 'SF-004', 'Squide Ring', 3, 'kg', 65000.00, 76500.00, 21.00, 10.00, '2026-11-10 09:27:41'),
	(36, 'SF-005', 'Ikan Dori Fillet', 3, 'kg', 38000.00, 45000.00, 28.00, 10.00, '2026-11-10 09:27:41'),
	(37, 'SF-006', 'Fish Lele', 3, 'kg', 28000.00, 33000.00, 35.00, 10.00, '2026-11-10 09:27:41'),
	(38, 'UD-007', 'Udang Kupas Vaname', 3, 'kg', 85000.00, 100500.00, 42.00, 10.00, '2026-11-10 09:27:41'),
	(39, 'CK-001', 'Chicken Whole 0,8', 4, 'kg', 37000.00, 43500.00, 49.00, 10.00, '2026-11-10 09:27:41'),
	(40, 'CK-002', 'Chicken Whole 0,9', 4, 'kg', 37000.00, 43500.00, 56.00, 10.00, '2026-11-10 09:27:41'),
	(41, 'CK-003', 'Chicken Whole 1', 4, 'kg', 36500.00, 43000.00, 63.00, 10.00, '2026-11-10 09:27:41'),
	(42, 'CK-004', 'Chicken Whole 1,2', 4, 'kg', 36500.00, 43000.00, 70.00, 10.00, '2026-11-10 09:27:41'),
	(43, 'CK-005', 'Chicken Whole 1,3', 4, 'kg', 36500.00, 43000.00, 77.00, 10.00, '2026-11-10 09:27:42'),
	(44, 'CK-006', 'Chicken Boneless Skinles Breast', 4, 'kg', 48000.00, 56500.00, 23.00, 10.00, '2026-11-10 09:27:42'),
	(45, 'CK-007', 'Chicken Boneless Skinless Leg', 4, 'kg', 52000.00, 61500.00, 30.00, 10.00, '2026-11-10 09:27:42'),
	(46, 'CK-008', 'Minced Chicken', 4, 'kg', 45000.00, 53000.00, 37.00, 10.00, '2026-11-10 09:27:42'),
	(47, 'FF-001', 'French Fries Shoestring', 5, 'kg', 32000.00, 38000.00, 44.00, 10.00, '2026-11-10 09:27:42'),
	(48, 'FF-002', 'French Fries Crinkle', 5, 'kg', 34000.00, 40000.00, 51.00, 10.00, '2026-11-10 09:27:42'),
	(49, 'FF-003', 'French Fries Strigh Cut', 5, 'kg', 33000.00, 39000.00, 58.00, 10.00, '2026-11-10 09:27:42'),
	(50, 'ED-004', 'Vegetable Edamame', 5, 'kg', 45000.00, 53000.00, 65.00, 10.00, '2026-11-10 09:27:42'),
	(51, 'LB-001', 'Lamb Carcas Cuting', 6, 'kg', 130000.00, 153500.00, 72.00, 10.00, '2026-11-10 09:27:42'),
	(52, 'JR-001', 'Japonica Rice', 7, 'kg', 24000.00, 28500.00, 79.00, 10.00, '2026-11-10 09:27:42');

-- Dumping structure for table manajementoko_ci4.supplier
CREATE TABLE IF NOT EXISTS `supplier` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nama` varchar(150) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `telepon` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `alamat` text COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table manajementoko_ci4.supplier: ~0 rows (approximately)
DELETE FROM `supplier`;
INSERT INTO `supplier` (`id`, `nama`, `telepon`, `alamat`) VALUES
	(1, 'PT. Indofood', '082273664663', 'Palembang');

-- Dumping structure for table manajementoko_ci4.users
CREATE TABLE IF NOT EXISTS `users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nama` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `email` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `foto` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table manajementoko_ci4.users: ~0 rows (approximately)
DELETE FROM `users`;
INSERT INTO `users` (`id`, `nama`, `email`, `password`, `foto`, `created_at`) VALUES
	(1, 'Superadmin', 'superadmin@gmail.com', '$2y$10$p6trMPpf8OjidnGtTs9rPejXGCJ.akI/a3DOcIOmf3w92101DaKy2', NULL, '2026-11-10 09:27:40');

/*!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) */;