-- Karyawan
INSERT INTO karyawan(id, nama, tgllahir, no_ktp, posisi) VALUES
(16901,'Alan Nolan','1979-2-19',7867313192486378,'manager'),
(16902,'Adi Stone','1981-7-6',3958957716354255,'koki'),
(16903,'Benadict Goff','1989-1-7',5138557373336434,'koki'),
(16904,'Benjamin Hadi','1990-6-11',8654380767277662,'koki'),
(16905,'Cassandra Bishop','1987-7-6',9810599846936552,'staff'),
(16906,'Charles Talley','1986-11-21',1742870859287685,'staff'),
(16907,'Charles Walters','1992-5-24',6101796466188583,'staff'),
(16908,'Curran Tradi','1981-6-22',2571924567963357,'cashier'),
(16909,'Darrel Owen','1992-6-7',9045108692648731,'koki'),
(16910,'Evan Fleming','1974-7-25',2188923777981912,'cashier'),
(16911,'Fiona Moran','1977-7-27',9551219455894049,'staff'),
(16912,'Hermione Ferguson','1971-5-10',6706949116938119,'koki'),
(16913,'Hilary Bradley','1973-9-11',9732119515542017,'koki');

-- Koki
INSERT INTO koki(id, sertifikasi) VALUES
(16902,'Pastry'),
(16903,'Fry'),
(16904,'Pastry'),
(16909,'Fry'),
(16912,'Grill'),
(16913,'Pantry');

-- Supplier
INSERT INTO supplier(id, nama, telepon, email) VALUES
(10001,'Airawati Shop',087865764567,NULL),
(10002,'Ali Sumihar Shop',087656434321,'AliSumi@yahoo.com'),
(10003,'Bagas Aras Shop',081234565432,NULL),
(10004,'Bertua Shop',081234567865,'Bertuasss@gmail.com'),
(10005,'Chintya Shop',081234567654,'Chintya25@yahoo.com'),
(10006,'Dame Damanik Shop',081245768932,'Dame.damanik@yahoo.com'),
(10007,'Dame Uli Shop',081234568211,'Dameuli@gmail.com'),
(10008,'Emil Sutrisno Shop',082456784356,'EmilSutrisno@yahoo.com'),
(10009,'Ifan Shop',087654567876,'ifan@gmail.com'),
(10010,'Igun Ranaro Shop',085678415678,NULL),
(10011,'Joni Shop',08765467876,'joni@gmail.com');

-- Kategori
INSERT INTO kategori(id, nama) VALUES
(33331,'Makanan'),
(33332,'Minuman'),
(33333,'Cemilan'),
(33334,'Pencuci Mulut');

-- Menu
INSERT INTO menu(nama, harga, idkategori) VALUES
('Air mineral',5000,33332),
('Ayam goreng tepung',30000,33331),
('Bebek goreng mentega',30000,33331),
('Bubur ayam',20000,33331),
('Cah kailan',25000,33331),
('Cumi bakar',30000,33333),
('Cumi goreng',30000,33333),
('Es teh',3000,33332),
('Es teh manis',5000,33332),
('Gurame bakar',28000,33331),
('Gurame goreng asam manis',28000,33331),
('Jus alpukat',15000,33332),
('Jus apel',15000,33332),
('Kue keju',25000,33334),
('Kue tiramisu',30000,33334);

-- Menu Harian
INSERT INTO menu_harian(namamenu, tanggal, idkoki, jumlah) VALUES
('Air mineral','2016-07-04',16912,2),
('Air mineral','2016-07-04',16903,5),
('Cumi goreng','2016-07-05',16902,2),
('Es teh','2016-07-05',16903,5),
('Cah kailan','2016-07-05',16902,3),
('Jus alpukat','2016-07-06',16904,3),
('Cumi bakar','2016-07-07',16912,7),
('Gurame goreng asam manis','2016-07-10',16912,4),
('Kue keju','2016-07-10',16909,1),
('Cah kailan','2016-07-10',16904,6),
('Es teh','2016-07-11',16904,10),
('Gurame goreng asam manis','2016-07-12',16902,5),
('Jus alpukat','2016-07-12',16909,3),
('Jus alpukat','2016-07-13',16903,3),
('Ayam goreng tepung','2016-07-17',16909,8),
('Bebek goreng mentega','2016-07-17',16912,5),
('Cah kailan','2016-07-17',16904,3),
('Kue keju','2016-07-18',16909,7),
('Cumi goreng','2016-07-19',16902,6),
('Es teh','2016-07-20',16902,10),
('Kue keju','2016-07-24',16904,6),
('Kue keju','2016-07-25',16902,8),
('Jus alpukat','2016-07-26',16913,1),
('Kue keju','2016-07-26',16902,2),
('Kue keju','2016-07-26',16903,4),
('Cumi goreng','2016-07-26',16904,10),
('Es teh','2016-07-27',16902,5),
('Es teh manis','2016-07-31',16913,5),
('Gurame bakar','2016-08-01',16909,8),
('Cumi goreng','2016-08-01',16904,9),
('Kue keju','2016-08-01',16902,9),
('Bubur ayam','2016-08-02',16909,6),
('Kue tiramisu','2016-08-03',16902,8),
('Bebek goreng mentega','2016-08-03',16904,8),
('Bubur ayam','2016-08-07',16902,7),
('Es teh manis','2016-08-07',16904,10),
('Gurame bakar','2016-08-07',16913,3),
('Es teh','2016-08-07',16909,8),
('Gurame bakar','2016-08-07',16902,8),
('Es teh','2016-08-08',16904,1),
('Bebek goreng mentega','2016-08-09',16912,5),
('Bubur ayam','2016-08-14',16903,6),
('Kue tiramisu','2016-08-14',16909,8),
('Es teh manis','2016-08-14',16913,8),
('Jus apel','2016-08-15',16912,7),
('Kue tiramisu','2016-08-16',16902,10),
('Bebek goreng mentega','2016-08-16',16903,3),
('Es teh','2016-08-16',16904,8),
('Bubur ayam','2016-08-21',16909,4),
('Gurame bakar','2016-08-22',16903,10),
('Cah kailan','2016-08-22',16902,5),
('Es teh','2016-08-22',16904,10),
('Gurame bakar','2016-08-23',16903,6),
('Bubur ayam','2016-08-23',16903,7),
('Cah kailan','2016-08-24',16904,2),
('Bebek goreng mentega','2016-08-28',16902,4),
('Cah kailan','2016-08-28',16909,10),
('Bebek goreng mentega','2016-08-28',16904,5),
('Es teh manis','2016-08-28',16913,3),
('Kue tiramisu','2016-08-28',16902,10),
('Bebek goreng mentega','2016-08-28',16903,3),
('Es teh','2016-08-29',16904,8),
('Bubur ayam','2016-08-29',16909,4),
('Gurame bakar','2016-08-29',16903,10),
('Cah kailan','2016-08-30',16902,5),
('Gurame bakar','2016-08-31',16903,6),
('Es teh','2016-09-01',16904,10),
('Bubur ayam','2016-09-02',16903,7),
('Cah kailan','2016-09-02',16904,2),
('Bebek goreng mentega','2016-09-02',16902,4),
('Cah kailan','2016-09-03',16909,10),
('Bebek goreng mentega','2016-09-04',16904,5),
('Air mineral','2016-09-05',16913,3);

-- Bahan Baku
INSERT INTO bahan_baku(nama, stok, satuan) VALUES
('Air',6000,'ml'),
('Ayam',30,'ekor'),
('Bebek',26,'ekor'),
('Tepung',10000,'gram'),
('Cumi',50,'ons'),
('Telur',63,'butir'),
('Teh',123,'kantong'),
('Gurame',48,'ekor'),
('Alpukat',57,'buah'),
('Apel',36,'buah'),
('Keju',2360,'gram'),
('Kopi',1948,'gram'),
('Kailan',67,'Ikat'),
('Bawang putih',6,'Siung'),
('Gula',3560,'gram'),
('Beras',1250,'gram'),
('Garam',5329,'gram');`

-- Bahan Baku Menu
INSERT INTO bahan_baku_menu(namamenu, namabahan, jumlah, satuan) VALUES
('Air mineral','Air',300,'ml'),
('Ayam goreng tepung','Ayam',1,'ekor'),
('Ayam goreng tepung','Tepung',100,'gram'),
('Ayam goreng tepung','Garam',20,'gram'),
('Bebek goreng mentega','Bebek',1,'ekor'),
('Bebek goreng mentega','Garam',25,'gram'),
('Bubur ayam','Ayam',1,'ekor'),
('Bubur ayam','Beras',200,'gram'),
('Cah kailan','Kailan',1,'ikat'),
('Cah kailan','Bawang putih',1,'siung'),
('Cah kailan','Garam',5,'gram'),
('Cumi bakar','Cumi',3,'ons'),
('Cumi goreng','Cumi',4,'ons'),
('Cumi goreng','Tepung',50,'gram'),
('Es teh','Teh',1,'kantong'),
('Es teh','Air',400,'ml'),
('Es teh manis','Teh',1,'kantong'),
('Es teh manis','Air',400,'ml'),
('Es teh manis','Gula',5,'gram'),
('Gurame bakar','Gurame',1,'ekor'),
('Gurame goreng asam manis','Gurame',1,'ekor'),
('Gurame goreng asam manis','Gula',10,'gram'),
('Jus alpukat','Alpukat',1,'buah'),
('Jus alpukat','Air',100,'ml'),
('Jus apel','Apel',2,'buah'),
('Jus apel','Air',50,'ml'),
('Kue keju','Telur',3,'buah'),
('Kue keju','Keju',250,'gram'),
('Kue tiramisu','Telur',3,'buah'),
('Kue tiramisu','Kopi',5,'gram');

-- Pembelian Bahan Baku
INSERT INTO pembelian_bahan_baku(nota, namabahan, jumlah, satuan, hargasatuan, waktu, idsupplier, idkaryawan) VALUES
(78452,'Tepung',2500,'gram',8,'2016-07-01',10011,16905),
(75696,'Teh',10,'kantong',1500,'2016-07-01',10008,16905),
(77429,'Kailan',10,'Ikat',2900,'2016-07-01',10011,16905),
(75011,'Kailan',10,'Ikat',3000,'2016-07-08',10011,16906),
(78302,'Gurame',2,'ekor',15000,'2016-07-08',10009,16907),
(79221,'Garam',1000,'gram',50,'2016-07-08',10008,16911),
(73576,'Gula',1000,'gram',50,'2016-07-08',10008,16905),
(74233,'Teh',15,'kantong',1500,'2016-07-08',10008,16905),
(72634,'Bawang putih',4,'siung',10000,'2016-07-08',10006,16906),
(79276,'Ayam',7,'ekor',25000,'2016-07-12',10006,16905),
(79817,'Alpukat',5,'buah',8000,'2016-07-12',10004,16906),
(73142,'Bebek',1,'ekor',32000,'2016-07-12',10002,16907),
(73001,'Kopi',400,'gram',43,'2016-07-12',10001,16905),
(71550,'Kopi',500,'gram',40,'2016-07-25',10011,16907),
(71706,'Teh',10,'kantong',1500,'2016-07-25',10011,16905),
(77651,'Teh',6,'kantong',1500,'2016-08-01',10011,16905),
(73584,'Telur',7,'butir',2000,'2016-08-01',10011,16911),
(72794,'Cumi',5,'ons',8000,'2016-08-01',10009,16906),
(73528,'Beras',1500,'gram',77,'2016-08-06',10008,16911),
(74541,'Garam',2000,'gram',50,'2016-08-07',10008,16905),
(73414,'Gula',800,'gram',50,'2016-08-15',10008,16905),
(72131,'Kopi',750,'gram',37,'2016-08-15',10008,16905),
(75788,'Ayam',5,'ekor',25000,'2016-08-15',10007,16906),
(77335,'Alpukat',8,'buah',8000,'2016-08-23',10004,16905),
(76759,'Apel',5,'buah',5000,'2016-08-23',10004,16905),
(79344,'Bebek',9,'ekor',35000,'2016-08-23',10003,16907),
(78898,'Bebek',3,'ekor',35000,'2016-08-23',10002,16907),
(75689,'Air',1500,'ml',30,'2016-08-29',10001,16911),
(72816,'Kailan',8,'Ikat',10000,'2016-08-29',10001,16911),
(78247,'Keju',500,'gram',40,'2016-09-01',10001,16905),
(75437,'Teh',30,'kantong',1500,'2016-09-01',10001,16905),
(78627,'Tepung',500,'gram',16,'2016-09-01',10001,16905),
(73460,'Cumi',5,'ons',8400,'2016-09-01',10009,16906),
(79027,'Gurame',3,'ekor',15000,'2016-09-01',10009,16907),
(71043,'Tepung',2000,'gram',8,'2016-09-02',10008,16905),
(71838,'Telur',20,'butir',2000,'2016-09-02',10001,16905),
(73138,'Gurame',10,'ekor',15000,'2016-09-02',10010,16905),
(77263,'Apel',10,'buah',5000,'2016-09-02',10005,16906),
(74544,'Gurame',8,'ekor',15000,'2016-09-03',10010,16905);