import data kasmaran hotel

16
tanda pengenal id tamu nama alamat 109376536782 C001 Subroto Rudin Jln. Kurang darah no 4, Malang 103845362789 C002 Amel Karla Jln. Kukur Mulut no 3, Malang 784923113725 C003 Haris Tutanto Jln. Lupa nma no 90, Malang 265278162352 C004 Crag Macrow Jln. Soekarno Hatta no 32, Malan 247583901823 C005 Dentist Doc Jln. Kuburan I no 30, Malang 576478392734 C006 Debora Upin Jln. Jauh Disana no 40, Malang 654746372834 C007 Ipin Masuat Jln. Lenovo baru, no 55, Malang 475847362748 C008 Selena Mahrin Jln. Kejora Baru no 34, Malang 573647281736 C009 Baharudin Jln. Ketupat Lebaran no 32, Mala 681234627382 C010 Muhammad Jln. Pending bro no 99, Malang 127384923749 C011 Kusman Jln. Sempoa no 6, Malang 183928379955 C012 Andika Pratama Jln. Kejora II no 24, Malang 134890473823 C013 Kesongo Wali Jln. Topi Hitam no 5, Malang 474829102834 C014 Amerta Bhuana Jln. Malaysia no 8, Malang 465748392898 C015 Jumanji Krodit Jln. Film Lama no 5, Malang 123457890212 C016 Shila on seven Jln. Band Terkenal no 65, Malang 384901728349 C017 Hades God Jln. Chat Lama banget no 99, Mal 213475478367 C018 Hercules Jln. Hancur Hatiku no 45, Malang 234567384729 C019 Joker Jam Jln. Cinta Indah no 64, Malang 567483726783 C020 Face Poker Jln. Ppak 25 no 15, Malang

Upload: gung-de-p-w

Post on 03-Dec-2015

215 views

Category:

Documents


2 download

DESCRIPTION

MDB

TRANSCRIPT

Page 1: Import Data Kasmaran Hotel

tanda pengenal id tamu nama alamat no tlpn109376536782 C001 Subroto Rudin Jln. Kurang darah no 4, Malang 083456278221103845362789 C002 Amel Karla Jln. Kukur Mulut no 3, Malang 081234567452784923113725 C003 Haris Tutanto Jln. Lupa nma no 90, Malang 081234564733265278162352 C004 Crag Macrow Jln. Soekarno Hatta no 32, Malang 081453745244247583901823 C005 Dentist Doc Jln. Kuburan I no 30, Malang 081234536125576478392734 C006 Debora Upin Jln. Jauh Disana no 40, Malang 081345263542654746372834 C007 Ipin Masuat Jln. Lenovo baru, no 55, Malang 083456342872475847362748 C008 Selena Mahrin Jln. Kejora Baru no 34, Malang 085675647564573647281736 C009 Baharudin Jln. Ketupat Lebaran no 32, Malang 087453647281681234627382 C010 Muhammad Jln. Pending bro no 99, Malang 085342536721127384923749 C011 Kusman Jln. Sempoa no 6, Malang 085432534123183928379955 C012 Andika Pratama Jln. Kejora II no 24, Malang 083456372123134890473823 C013 Kesongo Wali Jln. Topi Hitam no 5, Malang 085123456234474829102834 C014 Amerta Bhuana Jln. Malaysia no 8, Malang 087654123456465748392898 C015 Jumanji Krodit Jln. Film Lama no 5, Malang 08123456478123457890212 C016 Shila on seven Jln. Band Terkenal no 65, Malang 081234354675384901728349 C017 Hades God Jln. Chat Lama banget no 99, Malang 083213456321213475478367 C018 Hercules Jln. Hancur Hatiku no 45, Malang 083123567432234567384729 C019 Joker Jam Jln. Cinta Indah no 64, Malang 089745323671567483726783 C020 Face Poker Jln. Ppak 25 no 15, Malang 081234568922

Page 2: Import Data Kasmaran Hotel

KETERANGAN NO KAMAR HARGA FASILITAS KELASISI 101 Rp 250,000 Single Room Standar RoomKOSONG 102 Rp 300,000 Single Room Superior RoomKOSONG 103 Rp 350,000 Single Room Deluxe RoomISI 104 Rp 400,000 Single Room Suite RoomISI 105 Rp 275,000 Twin Room Standar RoomISI 106 Rp 350,000 Twin Room Superior RoomISI 107 Rp 425,000 Twin Room Deluxe RoomISI 108 Rp 500,000 Twin Room Suite RoomISI 109 Rp 300,000 Double Room Standar RoomKOSONG 110 Rp 375,000 Double Room Superior RoomISI 111 Rp 450,000 Double Room Deluxe RoomKOSONG 112 Rp 525,000 Double Room Suite RoomKOSONG 113 Rp 350,000 Family Room Standar RoomKOSONG 114 Rp 425,000 Family Room Superior RoomKOSONG 115 Rp 500,000 Family Room Deluxe RoomKOSONG 116 Rp 575,000 Family Room Suite RoomISI 201 Rp 250,000 Single Room Standar RoomKOSONG 202 Rp 300,000 Single Room Superior RoomISI 203 Rp 350,000 Single Room Deluxe RoomKOSONG 204 Rp 400,000 Single Room Suite RoomISI 205 Rp 275,000 Twin Room Standar RoomISI 206 Rp 350,000 Twin Room Superior RoomKOSONG 207 Rp 425,000 Twin Room Deluxe RoomKOSONG 208 Rp 500,000 Twin Room Suite RoomKOSONG 209 Rp 300,000 Double Room Standar RoomISI 210 Rp 375,000 Double Room Superior RoomKOSONG 211 Rp 450,000 Double Room Deluxe RoomKOSONG 212 Rp 525,000 Double Room Suite RoomISI 213 Rp 350,000 Family Room Standar RoomISI 214 Rp 425,000 Family Room Superior RoomKOSONG 215 Rp 500,000 Family Room Deluxe RoomISI 216 Rp 575,000 Family Room Suite RoomKOSONG 301 Rp 250,000 Single Room Standar RoomISI 302 Rp 300,000 Single Room Superior RoomKOSONG 303 Rp 350,000 Single Room Deluxe RoomKOSONG 304 Rp 400,000 Single Room Suite RoomISI 305 Rp 275,000 Twin Room Standar RoomKOSONG 306 Rp 350,000 Twin Room Superior RoomKOSONG 307 Rp 425,000 Twin Room Deluxe RoomKOSONG 308 Rp 500,000 Twin Room Suite RoomKOSONG 309 Rp 300,000 Double Room Standar RoomKOSONG 310 Rp 375,000 Double Room Superior RoomKOSONG 311 Rp 450,000 Double Room Deluxe RoomKOSONG 312 Rp 525,000 Double Room Suite RoomISI 313 Rp 350,000 Family Room Standar RoomKOSONG 314 Rp 425,000 Family Room Superior RoomISI 315 Rp 500,000 Family Room Deluxe Room

Page 3: Import Data Kasmaran Hotel

KOSONG 316 Rp 575,000 Family Room Suite Room

Page 4: Import Data Kasmaran Hotel

ID PESAN KAMAR ID TAMU NO KAMAR LAMA Harga DPR001 C001 101 3 Rp250,000 Rp200,000R002 C002 302 4 Rp300,000 Rp1,000,000R003 C003 206 3 Rp350,000 Rp500,000R004 C004 216 2 Rp575,000 Rp500,000R005 C005 203 4 Rp350,000 Rp400,000R006 C006 104 2 Rp400,000 Rp300,000R007 C007 105 3 Rp275,000 Rp500,000R008 C008 201 4 Rp250,000 Rp500,000R009 C009 315 2 Rp500,000 Rp500,000R010 C010 214 3 Rp425,000 Rp250,000R011 C011 213 4 Rp350,000 Rp400,000R012 C012 313 6 Rp350,000 Rp1,000,000R013 C013 205 5 Rp275,000 Rp375,000R014 C014 305 3 Rp275,000 Rp500,000R015 C015 109 1 Rp300,000 Rp100,000R016 C016 108 2 Rp500,000 Rp500,000R017 C017 107 3 Rp425,000 Rp275,000R018 C018 106 4 Rp350,000 Rp300,000R019 C019 111 5 Rp450,000 Rp550,000R020 C020 210 6 Rp375,000 Rp550,000

Page 5: Import Data Kasmaran Hotel

ID PESAN KAMAR TGL CHECK IN TGL CHECK OUT TOTAL BAYAR STATUSR001 2/2/2015 2/5/2015 750000 belum lunasR002 2/3/2015 2/7/2015 1200000 belum lunasR003 2/10/2015 2/13/2015 1050000 belum lunasR004 2/11/2015 2/13/2015 1150000 belum lunasR005 2/10/2015 2/14/2015 1400000 belum lunasR006 2/15/2015 2/17/2015 800000 belum lunasR007 2/12/2015 2/15/2015 825000 belum lunasR008 2/10/2015 2/14/2015 1000000 belum lunasR009 2/25/2015 2/27/2015 1000000 belum lunasR010 2/20/2015 2/23/2015 1275000 belum lunasR011 2/17/2015 2/21/2015 1400000 belum lunasR012 2/18/2015 2/24/2015 2100000 belum lunasR013 2/12/2015 2/17/2015 1375000 belum lunasR014 2/13/2015 2/16/2015 825000 belum lunasR015 2/4/2015 2/5/2015 300000 belum lunasR016 2/5/2015 2/7/2015 1000000 belum lunasR017 2/14/2015 2/17/2015 1275000 belum lunasR018 2/6/2015 2/10/2015 1400000 belum lunasR019 2/7/2015 2/12/2015 2250000 belum lunasR020 2/8/2015 2/14/2015 2250000 belum lunas

Page 6: Import Data Kasmaran Hotel

ID CHECK IN ID PESAN KAMAR TGL CHECK IN TOTAL BAYAR PESANANCKIN001 R001 2/2/2015 750000CKIN002 R002 2/3/2015 1200000CKIN003 R003 2/10/2015 1050000CKIN004 R004 2/11/2015 1150000CKIN005 R005 2/10/2015 1400000CKIN006 R006 2/15/2015 800000CKIN007 R007 2/12/2015 825000CKIN008 R008 2/10/2015 1000000CKIN009 R009 2/25/2015 1000000CKIN010 R010 2/20/2015 1275000CKIN011 R011 2/17/2015 1400000CKIN012 R012 2/18/2015 2100000CKIN013 R013 2/12/2015 1375000CKIN014 R014 2/13/2015 825000CKIN015 R015 2/4/2015 300000CKIN016 R016 2/5/2015 1000000CKIN017 R017 2/14/2015 1275000CKIN018 R018 2/6/2015 1400000CKIN019 R019 2/7/2015 2250000CKIN020 R020 2/8/2015 2250000

Page 7: Import Data Kasmaran Hotel

ID MAKANAN NAMA NAMAKAN HARGAM001 Pizza Rp 45,000 M002 Lasagna Rp 30,000 M003 Nasi Goreng Ayam Rp 25,000 M004 Ayam Goreng Rp 25,000 M005 Nasi Padang Rp 20,000 M006 Beef Panggang Rp 55,000 M007 Patin Betutu Rp 40,000 M008 Cumi Bumbu Merah Rp 35,000 M009 Pepes Udang Rp 30,000 M010 Sirloin Steak Rp 80,000

Page 8: Import Data Kasmaran Hotel

ID PESAN MAKANAN ID MANANAN TGL TRANSAKSI BANYAK MAKANAN TOTAL MAKANPM001 M001 2/3/2015 2 Rp 90,000 PM002 M002 2/4/2015 3 Rp 90,000 PM003 M003 2/11/2015 2 Rp 50,000 PM004 M004 2/12/2015 3 Rp 75,000 PM005 M005 2/11/2015 2 Rp 40,000 PM006 M006 2/16/2015 2 Rp 110,000 PM007 M007 2/13/2015 2 Rp 80,000 PM008 M008 2/11/2015 2 Rp 70,000 PM009 M009 2/26/2015 3 Rp 90,000 PM010 M010 2/21/2015 3 Rp 240,000 PM011 M002 2/18/2015 3 Rp 90,000 PM012 M003 2/19/2015 2 Rp 50,000 PM013 M010 2/13/2015 2 Rp 160,000 PM014 M003 2/14/2015 2 Rp 50,000 PM015 M009 2/5/2015 2 Rp 60,000 PM016 M008 2/6/2015 2 Rp 70,000 PM017 M004 2/15/2015 3 Rp 75,000 PM018 M005 2/7/2015 3 Rp 60,000 PM019 M005 2/8/2015 3 Rp 60,000 PM020 M006 2/9/2015 2 Rp 110,000

Page 9: Import Data Kasmaran Hotel

ID PESAN MAKANAN ID CHECK IN TOTAL BAYAR MAKANANPM001 CKIN001 Rp 90,000 PM002 CKIN002 Rp 90,000 PM003 CKIN003 Rp 50,000 PM004 CKIN004 Rp 75,000 PM005 CKIN005 Rp 40,000 PM006 CKIN006 Rp 110,000 PM007 CKIN007 Rp 80,000 PM008 CKIN008 Rp 70,000 PM009 CKIN009 Rp 90,000 PM010 CKIN010 Rp 240,000 PM011 CKIN011 Rp 90,000 PM012 CKIN012 Rp 50,000 PM013 CKIN013 Rp 160,000 PM014 CKIN014 Rp 50,000 PM015 CKIN015 Rp 60,000 PM016 CKIN016 Rp 70,000 PM017 CKIN017 Rp 75,000 PM018 CKIN018 Rp 60,000 PM019 CKIN019 Rp 60,000 PM020 CKIN020 Rp 110,000

Page 10: Import Data Kasmaran Hotel

ID JELNIS PAKIAN JENIS PAKAIAN HARGAPK001 JEAN Rp 10,000 PK002 LEVIS Rp 8,000 PK003 CATON Rp 5,000 PK004 SWETER Rp 8,000 PK005 JAS Rp 20,000 PK006 SELIMUT Rp 15,000 PK007 SEPRAI Rp 15,000 PK008 WOLL Rp 20,000 PK009 SPANDEX Rp 17,000 PK010 DENIM Rp 12,000

Page 11: Import Data Kasmaran Hotel

ID JENIS PAKAIAN ID PESAN LAUNDRY BANYAK CUCI TOTAL CUCIPK001 PL001 3 Rp 30,000 PK002 PL002 2 Rp 16,000 PK003 PL003 2 Rp 10,000 PK004 PL004 2 Rp 16,000 PK005 PL005 21 Rp 420,000 PK006 PL006 2 Rp 30,000 PK007 PL007 3 Rp 45,000 PK008 PL008 2 Rp 40,000 PK009 PL009 1 Rp 17,000 PK010 PL010 1 Rp 12,000 PK001 PL011 1 Rp 10,000 PK002 PL012 2 Rp 16,000 PK005 PL013 2 Rp 40,000 PK010 PL014 1 Rp 12,000 PK003 PL015 1 Rp 5,000 PK005 PL016 2 Rp 40,000 PK006 PL017 3 Rp 45,000 PK008 PL018 3 Rp 60,000 PK009 PL019 2 Rp 34,000 PK010 PL020 1 Rp 12,000

Page 12: Import Data Kasmaran Hotel

ID PESAN LAUNDRY ID CHECK IN TOTAL BAYAR PESANPL001 CKIN001 Rp 30,000 PL002 CKIN002 Rp 16,000 PL003 CKIN003 Rp 10,000 PL004 CKIN004 Rp 16,000 PL005 CKIN005 Rp 420,000 PL006 CKIN006 Rp 30,000 PL007 CKIN007 Rp 45,000 PL008 CKIN008 Rp 40,000 PL009 CKIN009 Rp 17,000 PL010 CKIN010 Rp 12,000 PL011 CKIN011 Rp 10,000 PL012 CKIN012 Rp 16,000 PL013 CKIN013 Rp 40,000 PL014 CKIN014 Rp 12,000 PL015 CKIN015 Rp 5,000 PL016 CKIN016 Rp 40,000 PL017 CKIN017 Rp 45,000 PL018 CKIN018 Rp 60,000 PL019 CKIN019 Rp 34,000 PL020 CKIN020 Rp 12,000

Page 13: Import Data Kasmaran Hotel

ID CHECK OUT ID CHECK IN ID PESAN LAUNDRY ID PESAN MAKANAN TGL CHECK IN TOTAL BAYARCKOT001 CKIN001 PL001 PM001 2/2/2015 Rp 670,000 CKOT002 CKIN002 PL002 PM002 2/3/2015 Rp 306,000 CKOT003 CKIN003 PL003 PM003 2/10/2015 Rp 610,000 CKOT004 CKIN004 PL004 PM004 2/11/2015 Rp 741,000 CKOT005 CKIN005 PL005 PM005 2/10/2015 Rp 1,460,000 CKOT006 CKIN006 PL006 PM006 2/15/2015 Rp 640,000 CKOT007 CKIN007 PL007 PM007 2/12/2015 Rp 450,000 CKOT008 CKIN008 PL008 PM008 2/10/2015 Rp 610,000 CKOT009 CKIN009 PL009 PM009 2/25/2015 Rp 607,000 CKOT010 CKIN010 PL010 PM010 2/20/2015 Rp 1,277,000 CKOT011 CKIN011 PL011 PM011 2/17/2015 Rp 1,100,000 CKOT012 CKIN012 PL012 PM012 2/18/2015 Rp 1,166,000 CKOT013 CKIN013 PL013 PM013 2/12/2015 Rp 1,200,000 CKOT014 CKIN014 PL014 PM014 2/13/2015 Rp 387,000 CKOT015 CKIN015 PL015 PM015 2/4/2015 Rp 265,000 CKOT016 CKIN016 PL016 PM016 2/5/2015 Rp 610,000 CKOT017 CKIN017 PL017 PM017 2/14/2015 Rp 1,120,000 CKOT018 CKIN018 PL018 PM018 2/6/2015 Rp 1,220,000 CKOT019 CKIN019 PL019 PM019 2/7/2015 Rp 1,794,000 CKOT020 CKIN020 PL020 PM020 2/8/2015 Rp 1,822,000