Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- group: nameOfTheNewGroup
- Member = {
- memberNo:string, fName:string, lName:string, telNo:number, sex:string, address:string, eMail:string
- 'AF001' , 'Annisa' , 'Afisina' , 3122233 , 'P' , 'Keputih' , 'afisina@gmail.com'
- 'AF002' , 'Humairo' , 'Mahfud' , 3188833 , 'P' , 'Gebang' , 'mahfud@gmail.com'
- 'AF003' , 'Siti' , 'Nurbaya' , 3144234 , 'P' , 'Gubeng' , 'nurbaya@gmail.com'
- 'AF004' , 'Salim' , 'Akbar' , 3155315 , 'L' , 'Kertajaya' , 'akbar@gmail.com'
- 'AF005' , 'Azifa' , 'Fitriani' , 3124566 , 'P' , 'Mulyosari' , 'azifa@gmail.com'
- 'AF006' , 'Akbar' , 'Hasan' , 3144325 , 'L' , 'Gunung Sari' , 'hasan@gmail.com'
- }
- Vehicle = {
- machineNo:string, policeNo:string, frameNo:string, type:string , color:string , year:number
- '04HY62' , 'A 203 SK' , 'UERN45' , 'Honda Freed A' , 'ABU METALIK', 2011
- '10JG4U' , 'Q 038 VY' , 'DAJSF34' , 'Honda Brio Satya E Manual' , 'SILVER' , 2010
- '12FH44' , 'P 896 NU' , 'KAHGF53' , 'Honda Brio Satya A Manual' , 'HITAM' , 2013
- '12PM09' , 'E 934 ZM' , 'UAFE73' , 'Honda Brio E Otomatis' , 'ABU METALIK', 2010
- '13PQ50' , 'R 285 XN' , 'KAHF53' , 'Honda Brio Sports E Manual', 'PUTIH ' , 2008
- '14TU67' , 'K 832 PZ' , 'HFDG34' , 'Honda New City ES CVT' , 'ABU METALIK', 2015
- }
- Staff = {
- staffID:string, fName:string, lName:string, address:string, telNo:number, sex:string, position:string , salary:number
- 'AD' , 'Affan' , 'Danu' , 'SEMOLOWARU' , 87398923423 , 'L' , 'MANAGER' , 4500000
- 'AG' , 'Andika' , 'Gris' , 'NGAGEL' , 81764644347 , 'L' , 'CHASIER' , 3500000
- 'AK' , 'Ambar' , 'Krishna' , 'KERTAJAYA' , 81543457886 , 'L' , 'MECHANIC 1' , 3800000
- 'AN' , 'Alif' , 'Novan' , 'GAYUNGSARI' , 89544362167 , 'L' , 'MECHANIC 1' , 3800000
- 'AR' , 'Arko' , 'Ridho' , 'MANYAR' , 89543767448 , 'L' , 'MECHANIC 2' , 3800000
- 'DI' , 'Dimas' , 'Igus' , 'KETINTANG ' , 87422112763 , 'L' , 'MECHANIC 2' , 3800000
- 'NO' , 'NOVI' , 'DIAN' , 'WARU' , 89483753945 , 'P' , 'CHASIER' , 3000000
- 'EH' , 'ELITA' , 'HARTAYATI' , 'GEDANGAN' , 87329738232 , 'P' , 'CUSTOMER SERVICE', 2500000
- 'KK' , 'KIKI' , 'KURNIAWATI', 'WARU' , 89627364383 , 'P' , 'CUSTOMER SERVICE', 2500000
- }
- Service = {
- serviceID:string, role:string , category:string , price:number
- 'AR' , 'PERIKSA AIR DAN RADIATOR', 'TEST DRIVE' , 175000
- 'CV' , 'CUCI DAN VAKUM MOBIL' , 'CUCI MOBIL' , 150000
- 'DM' , 'DEMPUL' , 'PERAWATAN BODY' , 220000
- 'GO' , 'GANTI OLI' , 'PERAWATAN MESIN', 80000
- 'LMR' , 'PERIKSA LEVEL MINYAK REM', 'TEST DRIVE' , 175000
- 'PO' , 'POLES' , 'PERAWATAN BODY' , 375000
- 'SC' , 'PENGGANTIAN SUKU CADANG' , 'PERAWATAN BODY' , 400000
- }
- Mechanic1 = {
- mechanic1ID:string, fName:string, lName:string, telNo:number, address:string
- 'AK' , 'AMBAR' , 'KRISHNA' , 81543457886 , 'KERTAJAYA'
- 'AN' , 'ALIF' , 'NOVAN' , 89544362167 , 'GAYUNGSARI'
- }
- Mechanic2 = {
- mechanic2ID:string, fName:string, lName:string, telNo:number, address:string
- 'AR' , 'ARKO' , 'RIDHO' , 89543767448 , 'MANYAR'
- 'DI' , 'DIMAS' , 'IGUS' , 87422112763 , 'KETINTANG'
- }
- Bill = {
- billNo:number, memberNo:string, machineNo:string, dateIn:string, dateOut:string, dateDone:string, status:string, staffID:string, mechanic1ID:string, mechanic2ID:string, serviceID:string, cost:number
- 1 , 'AF001' , '04HY62' , '05/10/2016' , '08/10/2016' , '09/10/2016' , 'TAKEN' , 'AG' , 'AK' , 'AR' , 'AR CV' , 225000
- 2 , 'AF002' , '10JG4U' , '06/10/2016' , '09/10/2016' , '10/10/2016' , 'TAKEN' , 'AG' , 'AK' , 'DI' , 'AR' , 175000
- 3 , 'AF003' , '12FH44' , '07/10/2016' , '10/10/2016' , '11/10/2016' , 'TAKEN' , 'NO' , 'AN' , 'DI' , 'CV' , 150000
- 4 , 'AF004' , '12PM09' , '08/10/2016' , '11/10/2016' , '12/10/2016' , 'TAKEN' , 'AG' , 'AK' , 'DI' , 'CV' , 150000
- 5 , 'AF005' , '13PQ50' , '09/10/2016' , '12/10/2016' , '13/10/2016' , 'TAKEN' , 'NO' , 'AN' , 'DI' , 'DM' , 220000
- 6 , 'AF005' , '13PQ50' , '10/10/2016' , '13/10/2016' , '14/10/2016' , 'TAKEN' , 'AG' , 'AK' , 'AR' , 'GO' , 80000
- 7 , 'AF006' , '14TU67' , '11/10/2016' , '14/10/2016' , '15/10/2016' , 'FINISHED' , 'AG' , 'AN' , 'AR' , 'LMR' , 175000
- 8 , 'AF003' , '12FH44' , '12/10/2016' , '15/10/2016' , '16/10/2016' , 'QUEUING' , 'NO' , 'AN' , 'AR' , 'PO' , 375000
- 9 , 'AF004' , '12PM09' , '13/10/2016' , '16/10/2016' , '17/10/2016' , 'QUEUING' , 'NO' , 'AN' , 'AR' , 'SC' , 400000
- 10 , 'AF006' , '14TU67' , '14/10/2016' , '17/10/2016' , '18/10/2016' , 'QUEUING' , 'NO' , 'AN' , 'DI' , 'DM LMR' , 395000
- }
- Registration = {
- memberNo:string, StaffID:string, dateJoined:string
- 'AF001' , 'EH' , '23/09/2016'
- 'AF002' , 'EH' , '25/09/2016'
- 'AF003' , 'KK' , '26/09/2016'
- 'AF004' , 'KK' , '27/09/2016'
- 'AF005' , 'KK' , '28/09/2016'
- 'AF006' , 'EH' , '29/09/2016'
- }
Add Comment
Please, Sign In to add comment