ABSTRAK

Yung Christanto : Skripsi Perancangan dan Pembuatan Sistem Informasi Administrasi pada Toko Foto Nirwana Sekarang ini Toko Foto Nirwana masih menggunakan sistem yang

manual, baik untuk pembelian, penjualan, absensi pegawai, dan masih banyak yang lainnya. Untuk pembuatan laporan juga masih manual dengan menggunakan kertas yang kemungkinan hilang lebih besar. Dengan sistem yang masih manual ini, banyak kesulitan yang terjadi, misalnya buku catatan yang hilang dan kesulitan dalam penghitungan gaji pegawai.

Karena itu penulis berusaha untuk mengatasi semua permasalahan yang terjadi dengan merancang sistem informasi administrasi pada Toko Foto Nirwana secara komputerisasi dimana pada pembuatannya menggunakan bahasa pemrograman Borland Delphi 7 dan databasenya menggunakan Microsoft SQL Server 2000. Dengan adanya aplikasi ini diharapkan semua permasalahan akan teratasi dan sistem informasi administrasi pada Toko Foto Nirwana menjadi lebih baik lagi. Pembuatan aplikasi ini dimulai dengan pengumpulan data, mempelajari sistem dari Toko Foto Nirwana, perencanaan dan pembuatan aplikasi kemudian pengujian aplikasi.

Hasil dari pembuatan Tugas Akhir ini berupa sebuah perangkat lunak yang dapat menyimpan transaksi pembelian, penjualan, retur, absensi, dan penggajian. Selain itu juga dapat menghitung harga pokok penjualan dan menampilkan laporan – laporan yang dibutuhkan secara otomatis.

Kata kunci : Sistem informasi administrasi, HPP

ABSTRACT

Yung Christanto : Thesis Designing and Developing Administration Information System at Nirwana Photo Studio

Nowadays, Nirwana Photo Studio is still using manual system which is good for purchasing, selling, employee attendance, etc. For the report making also use manually with paper which the probability of loss is high. With the manual system there is plenty of difficulty that happened, for example the notes is missing and it is difficult to count employees’ salary. In overcoming those problems, an administration information system at Nirwana Photo Studio was designed with computerized system. They use Borland Delphi 7 for the programs and Microsoft SQL Server 2000 for the database. Hopefully all the problems will solve with this application and the information administration system at Nirwana Photo Studio can be much better. The making of application started with data collecting, study the system of Nirwana Photo Studio, planning and making the application and then test the application. The result from this Final Assignment consists of software which can save purchasing transaction, selling, returned transaction, attendance, and payroll. Furthermore, it also can calculate cost of goods sold and results several reports automatically. Keywords:

Administration Information System, cost of goods sold.

DAFTAR ISI

LEMBAR PENGESAHAN ............................................................................ i

KATA PENGANTAR ................................................................................... ii

LEMBAR PERNYATAAN PERSETUJUAN PUBLIKASI KARYA

ILMIAH UNTUK KEPENTINGAN AKADEMIS ..................................... .iii

ABSTRAK .................................................................................................... iv

ABSTRACT.. ................................................................................................. v

DAFTAR ISI.. ............................................................................................... vi

DAFTAR GAMBAR ..................................................................................... x

DAFTAR TABEL . . . . . . . . . . . . . . . . . . . .. ..................................................................... xl11

1. PENDAHULUAN ..................................................................................... 1

1.1. Latar Belakang Masalah.. ................................................................ 11.2. Perumusan Masalah ........................................................................ .21.3. Ruang Lingkup ............................................................................... .21.4. Tujuan Tugas Akhir.. ...................................................................... .41 .5. Metodologi Penelitian .................................................................... .41.6. Sistematika Penyusunan Laporan ................................................... .5

2. LANDASAN TEORI ................................................................................ .6

2.1. Konsep Dasar Sistem ...................................................................... .62.2. Konsep Dasar Informasi ................................................................. .62.3. Konsep Dasar Sistern Informasi ..................................................... .62.4. Metode Pengambilan Harga Bahan Produksi ................................. .72.5. Metode Pengumpulan Harga Pokok ............................................... .72.6. Rumus Penghitungan Harga Pokok ................................................ .82.7. Teori Depresiasi ............................................................................. 102.8. Data Flow Diagram Context Diagram Level ................................. 122.9. Data Flow Diagram Leveled (DFDL) ........................................... 132.10. Entity Relationship Diagram (ERD) ............................................. 142.11. Structured Query Language (SQL) ............................................... 16

2.11.1. Data Definition Language (DDL) ................................... 16

2.11.2. Data Manipulation Language (DML) ............................... 173. ANALISIS DAN DESAIN SISTEM.. ..................................................... 19

3.1. Analisis Sistem yang Lama ........................................................... 193.2. Identifikasi Masalah ..................................................................... .213.3. Analisis Kebutuhan ...................................................................... .213.4. Desain Data Flow Diagram (DFD). .............................................. .22

3.4.1. Context Diagram .............................................................. .23

3.4.2. DFD Level 0.. ................................................................... .24

vi Universitas Kristen Petra

HALAMAN JUDUL

3.4.3. DFD Level 1 Pembelian .................................................., 25

3.4.4. DFD Level 1 Penjualan . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26

3.5. Desain Entity Relationship Diagram . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ..I 273.6. Desain Database . . . . . . . . . . . . . . . . . . . .................................................. 323.7. Desain Menu . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 453.8. Desain Form ,..... . . ......................................................... 45

3.8.1. Form Main . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45

3.8.2. Form Login . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46

3.8.3. Form Order Pembelian . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ,47

3.8.4. Form Pembatalan Order Pembelian.. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .47

3 -8.5. Form Pembelian.. . , . . . , . . . . , . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48

3.8.6. Form Pembayaran . . . . . . . . . . . . . . , . . . . . . . . . . . . . . . . . . . . . .................................... 49

3.8.7. Forrn Master Barang . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50

3.8.8. Form Master Supplier . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50

3.8.9. Form Master Customer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51

3.8.10. Form Master Pegawai.. . . . , . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52

3.8.11. Form Master Mesin . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53

3.8.12. Form Master Proses Produksi . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54

3.8.13. Form Absensi Pegawai . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55

3.8.14. Form Penerimaan Service.. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .56

3.8.15. Form Pengembalian Service.. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .57

3.8.16. Form Penjualan . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . 58

3.8.17. Form Retur Penjualan . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59

3.8.18. Form Jumlah Retur .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60

3.8.19. Form Pemesanan Foto Video . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61

3.8.20. Form Pemesanan Cuci Cetak . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62

3.8.21. Form Range Tanggal . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63

3.8.22. Form Insert Pegawai . . . . . . . , . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . , , . . . . . . . . . . . . .63

3.8.23. Form Produksi . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 64

4. IMPLEMENTASI SISTEM . . . . . . . ............................................................ 65

4.1. Implementasi Database _ . . . . . . . . . .................................................... 654.2. Setting Koneksi Database . . _ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 654.3. Implementasi Program.. . . . . . . . . . . . . . . . . . . . . . . . . . . . . , . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .68

4.3.2. Nirwana. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69

4.3.3. Form Login . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 78

vii Universitas Kristen Petra

4.3.4. Form Master Supplier . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 78

4.3.5. FormMaster Customer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 83

4.3.6. Form Master Pegawai . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 84

4.3.7. Form Master Barang . . . . . . . . . . . . . . . . . . ....................................... 85

4.3.8. Form Master Barang Hasil Produksi . , . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .86

4.3.9. Form Master Mesin .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87

4.3.10. Form Master Proses Produksi.. . . . . . . . . . . , . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .88

4.3.11. Form Order Pembelian . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 89

4.3.12. Form Pembelian. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 92

4.3.13. Form Retur Pembelian.. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .98

4.3.14. Form Pembayaran. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............. 101

4.3.15. FormPenjualan . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .102

4.3.16. Form Retur Penjualan . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 107

4.3.17. Form Penerimaan Service.. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 113

4.3.18. Form Pengembalian Service.. . _ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 115

4.3.19. Form Absensi Pegawai . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 118

4.3.20. Form Penggajian. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 120

4.3.2 1. Form Pemesanan Foto Video . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 1

4.3.22. Form Pemesanan Cuci Cetak.. _. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 123

4.3.23. Form Pembatalan Order Pembelian.. . . . . . . . . . . . . . . . . . , . . . . . . . . . . . . . 126

5. PENGUJIAN SISTEM . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 127

5.1. Login . . . . . .. . . . . . . . . . . . . . ......................................................................... 1275.2. Form Main (Nirwana). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1275.3. Master Supplier . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1285.4. Master Customer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1305.5. Master Pegawai . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1315.6. Master Barang . . . . . . . . . . . . . . . . . . . .............................................. . . . . . . . . . . . . . 1335.7. Master Barang Hasil Produksi . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1355.8. Master Mesin . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1375.9. Master Proses Produksi , . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1395.10. Form Order Pembelian . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1405.11. Form Pembatalan Order Pembelian . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1415.12. Form Pembelian. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1425.13. Form Retur Pembelian. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1465.14. Form Penjualan . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1485.15. Form Retur Penjualan . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1505.16. Form Penerimaan Service . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1525.17. Form Pengembalian Service.. . . , . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . , . . . . . . . . , . . . . . 153

. . .vll l Universitas Kristen Petra

5.18. Form Absensi.. ............................................................................. 1555.19. Form Penggajian.. ........................................................................ 1565.20. Form Pemesanan Foto dan Video ................................................ 1575.2 1. Form Pemesanan Cuci Cetak ....................................................... 1605.22. Laporan Stok ............................................................................... 161

6. KESIMPULAN DAN SARAN .............................................................. 166

6.1. Kesimpulan.. ................................................................................ 1666.2. Saran.. .......................................................................................... 166

ix Universitas Kristen Petra

REFERENSI

DAF’TAR GAMBAR

Gambar 2.1. Notasi ERD .............................................................................................. 14

Gambar 2.3. Relasi one to one. ..................................................................................... 15

Gambar 2.4. Relasi one-to-many ................................................................................. .16

Gambar 2.5. Relasi many-to-many ............................................................................... 16

Gambar 3.1. Context Diagram.. ................................................................................... .23

Gambar 3.2. DFD Level 0 ........................................................................................... .24

Gambar 3.3. DFD Level 1 Pembelian .......................................................................... .25

Gambar 3.4. DFD Level 1 Penjualan ........................................................................... .26

Gambar 3.5. Conceptual Data Model Toko Foto Nirwana .......................................... .28

Gambar 3.6. Physical Data Modelling Toko Foto Nirwana ........................................ .29

Gambar 3.7. Desain Menu ........................................................................................... .45

Gambar 3.8. Form Main .............................................................................................. .46

Gambar 3.9. Form Login ............................................................................................. .46

Gambar 3.10. Form Order Pembelian ............................................................................ .47

Gambar 3.11. Form Pembatalan Order Pembelian ....................................................... .48

Gambar 3.12. Form Pembelian.. .................................................................................... .49

Gambar 3.13. Form Pembayaran ................................................................................... .49

Gambar 3.14. Form Master Barang ............................................................................... .50

Gambar 3.15. Form Master Supplier ............................................................................. .5 1

Gambar 3.16. Form Master Customer ........................................................................... .52

Gambar 3.17. Form Master Pegawai ............................................................................. .53

Gambar 3.18. Form Master Mesin................................................................................. .54

Gambar 3.19. Form Master Proses Produksi ................................................................. .55

Gambar 3.20. Form Absensi Pegawai ........................................................................... .56

Gambar 3.2 1. Form Penerimaan Service ....................................................................... .57

Gambar 3.22. Form Pengembalian Service ................................................................... .58

Gambar 3.23. Form Penjualan.. ..................................................................................... .59

Gambar 3.24. Form Retur Penjualan ............................................................................. .60

Gambar 3.25. Form Jumlah Retur ................................................................................. .61

Gambar 3.26. Form Pemesanan Foto Video.................................................................. .62X Universitas Kristen Petra

Gambar 3.27. Form Pemesanan Cuci Cetak.. ................................................................ .63

Gambar 3.28. Form Range Tanggal ............................................................................... 63

Gambar 3.29. Insert Pegawai ......................................................................................... .64

Gambar 3.30. Form Produksi ........................................................................................ 64

Gambar 4.1. Tampilan Database Microsoft SQL Server 2000 ..................................... 65

Gambar 4.2. Komponen ADO Connection................................................................... 66

Gambar 4.3. Object Inspector ADOConnection .......................................................... .66

Gambar 4.4. OLE DB Provider SQL Server ................................................................ 67

Gambar 4.5. Data Link Properties ................................................................................ 67

Gambar 5.1. Form Login ............................................................................................ 127

Gambar 5.2. Form Main ............................................................................................. 128

Gambar 5.3. Form Master Supplier ............................................................................ 128

Gambar 5.4. Form Edit Master Supplier..................................................................... 129

Gambar 5.5. Form Master Customer .......................................................................... 130

Gambar 5.6. Form Edit Master Customer................................................................... 131

Gambar 5.7. Form Master Pegawai ............................................................................ 132

Gambar 5.8. Form Edit Master Pegawai ..................................................................... 133

Gambar 5.9. Form Master Barang .............................................................................. 134

Gambar 5.10. Form Edit Master Barang. ...................................................................... 135

Gambar 5.11. Form Master Barang Hasil Produksi ...................................................... 136

Gambar 5.12. Form Edit Master Barang Hasil Produksi .............................................. 137

Garnbar 5.13. Form Master Mesin ................................................................................ 138

Gambar 5.14. Form Edit Master Mesin ........................................................................ 139

Gambar 5.15. Forrn Edit Master Mesin ........................................................................ 140

Gambar 5.16. Form Order Pembelian........................................................................... 141

Gambar 5.17. Laporan Order Pembelian ..................................................................... .14 1

Gambar 5.18. Form Pembatalan Order Pembelian ...................................................... .142

Gambar 5.19. Form Pembelian dengan Order Pembelian ............................................ 143

G-arnbar 5.20. Laporan Hutang ..................................................................................... 143

Gambar 5.2 1. Form Pembayaran .................................................................................. 144

Gambar 5.22. Form Range Tanggal .............................................................................. 144

Gambar 5.23. Laporan Pembayaran ............................................................................ .145

xi Universitas Kristen Petra

Gambar 5.24. Form Pembelian Tanpa Order................................................................ 145

Gambar 5.25. Laporan Pembelian per Supplier ........................................................... .146

Gambar 5.26. Form Jumlah Retur ................................................................................ 147

Gambar 5.27. Form Jumlah Retur ............................................................................... .147

Gambar 5.28. Laporan Retur Pembelian ...................................................................... 148

Gambar 5.29. Form Penjualan ...................................................................................... 148

Gambar 5.30. Nota Retur Penjualan ............................................................................. 149

Gambar 5.3 1. Laporan Penjualan per Barang ............................................................... 150

Gambar 5.32. Form Retur Penjualan ............................................................................ 151

Gambar 5.33. Nota Retur Penjualan ............................................................................. 151

Gambar 5.34. Form Penerimaan Service ...................................................................... 152

Gambar 5.35. Nota Penerimaan Service ....................................................................... 153

Garnbar 5.36. Form Pengembalian Service .................................................................. 154

Gambar 5.37. Nota Pengembalian Service ................................................................... 154

Gambar 5.38. Form Absensi ......................................................................................... 155

Gambar 5.39. Laporan Absensi .................................................................................... 156

Gambar 5.40. Form Penggajian .................................................................................... 156

Gambar 5.4 1. Form Pemesanan Foto Video ................................................................. 157

Gambar 5.42. Nota Pemesanan Foto Video................................................................. .158

Gambar 5.43. Laporan Pemesanan Foto Video ........................................................... .158

Gambar 5.44. . Insert Pegawai ...................................................................................... 159

Gambar 5.45. Form Produksi ........................................................................................ 159

Gambar 5.46. Form Pemesanan Cuci Cetak ................................................................. 160

Gambar 5.47. Nota Pemesanan Cuci Cetak .................................................................. 16 1

Gambar 5.48. .Laporan Stok .......................................................................................... 162

xii Universitas Kristen Petra

DAFTAR TABEL

Tabel3.1.

Tabe13.2.

Tabe13.3.

Tabe13.4.

Tabe13.5.

Tabe13.6.

Tabe13.7.

Tabe13.8.

Tabe13.9.

Tabel3.10.

Tabel3.11.

Tabel3.12.

Tabel3.13.

Tabe13.14.

Tabel3.15.

Tabel3.16.

Tabe13.17.

Tabel3.18.

Tabel3.19.

Tabel3.20.

Tabel3.21.

Tabe13.22.

Tabe13.23.

Tabe13.24.

Tabe13.25.

Tabe13.26.

Tabe13.27.

Tabe13.28.

Tabe13.29.

Tabel3.30.

Tabel Login ............................................................................................. .32

Tabel Barang............................................................................................ 32

Tabel Detail-Barang ............................................................................... .33

Tabel Supplier .......................................................................................... 33

Tabel Customer . . ..................................................................................... .34

Tabel Pegawai .......................................................................................... 34

Tabel Barang_Hasil_Produksi ................................................................. 35

Tabel Absensi_Pegawai............... ............................................................ 35

Tabel Order-Pembelian .......................................................................... .35

Tabel Detail-Order-Pembelian .............................................................. .36

Tabel Pembelian....................................................................................... 36

Tabel DetailPembelian .......................................................................... .37

Tabel Retur_Pembelian ............................................................................ 37

Tabel Detail_Retur_Pembelian ............................................................... .37

Tabel Pemesanan_Foto_Video ................................................................ 38

Tabel Detail_Pemesanan_Foto_Video .................................................... .3 8

Tabel Pemesanan_Cuci_Cetak ................................................................ .39

Tabel Detail_Pemesanan_Cuci_Cetak ..................................................... 39

Tabel Penggajian. .................................................................................... .39

Tabel Service ........................................................................................... 40

Tabel Pengembalian_Service .................................................................. .40

Tabel Detail_Pengembalian_Service ....................................................... 41

Tabel Penjualan ....................................................................................... .41

Tabel Detail_Penjualan ........................................................................... .4 1

Tabel Retur_Penjualan ............................................................................. 42

Tabel Detail_Retur_Penjualan ................................................................. 42

Tabel Detail_Retur_Penjualan_Pengembalian_Barang .......................... .42

Tabel Detail-Proses-Produksi-Bahan..................................................... 43

Tabel Detail-Proses-Prod&i-Mesin ..................................................... 43

Tabel Detail- Produksi_Mesin ................................................................ 44...

xl11 Universitas Kristen Petra

Tabe13.3 1.

Tabe13.32.

Tabel4.1.

Tabe14.2.

Tabe14.3.

Tabe14.4.

Tabe14.5.

Tabe14.6.

Tabe14.7.

Tabe14.8.

Tabe14.9.

Tabel4.10.

Tabel4.11.

Tabel4.12.

Tabel4.13.

Tabel4.14.

Tabel4.15.

Tabe14.16.

Tabel4.17.

Tabe14.18.

Tabel4.19.

Tabel4.20.

Tabel4.21.

Tabe14.22.

Tabe14.23.

Tabe15.1.

Tabe15.2.

Tabe15.3.

Tabe15.4.

Tabe15.5.

Tabel Detail- ProduksiMesin ................................................................ 44

Tabel Detail- ProduksiPegawai ............................................................. 44

Tabel Menu dan Submenu dari Form Main ... .......................................... 68

Daftar Procedure Form Main (Nirwana) .................................................. 69

Daftar Procedure Form Login ................................................................. .78

Daftar Procedure Form Master Supplier .................................................. 78

Daftar Procedure Form Master Customer ................................................ 83

Daftar Procedure Form Master Pegawai .................................................. 84

Daftar Procedure Form Master Barang .................................................... 85

Daftar Procedure Form Master Barang Hasil Produksi .......................... .86

Daftar Procedure Form Master Mesin .................................................... .87

Daftar Procedure Form Master Proses Produksi ..................................... .88

Daftar Procedure Form Order Pembelian . . .............................................. 89

Daftar Procedure Form Pembelian. ......................................................... .92

Daftar Procedure Form Retur Pembelian................................................ .98

Daftar Procedure Form Pembayaran ...................................................... 10 1

Daftar Procedure Form Penjualan .......................................................... 102

Daftar Procedure Form Retur Penjualan ................................................ 107

Daftar Procedure Form Penerimaan Service.......................................... 113

Daftar Procedure Form Pengembalian Service ...................................... 115

Daftar Procedure Form Absensi Pegawai .............................................. 118

Daftar Procedure Form Penggajian........................................................ 120

Daftar Procedure Form Pemesanan Foto Video .................................... 121

Daftar Procedure Form Pemesanan Foto Video .................................... 123

Daftar Procedure Form Pembatalan Order Pembelian ........................... 126

Tabel Data Order Pembelian .................................................................. 140

Tabel Data Pembelian ............................................................................ 145

Tabel Data Penerimaan Service ............................................................. 152

Tabel Data Pemesanan Foto Video ........................................................ 157

Tabel Data Pemesanan Cuci Cetak ........................................................ 160

XiV Universitas Kristen Petra

Segmen 4.1. Procedure M s g ....................................................................... .69

Segmen 4.2. Procedure Penggajian ............................................................. .70

Segmen 4.3. Function Total-Gaji ............................................................... .7 1

Segmen 4.4. Function Last-Day ................................................................. .73

Segrnen 4.5. Function Get_Tanggal_Awal ................................................. .74

Segmen 4.6. Function Get-Tanggal ............................................................. ‘75

Segmen 4.7. Function Get-Bulan ............................................................... .75

Segmen 4.8. Function Get-Tahun............................................................... .76

Segmen 4.9. Function StringToCurrency ................................................... .76

Seg,men 4.10. Function CurrencyToString ................................................. .77

Segmen 4.11. Function Generate-Code.. .................................................... .79

Segmen 4.12. Procedure ButtonAddClick .................................................. .80

Segmen 4.13. Procedure ButtonDeleteClick............................................... .82

Segmen 4.14. Procedure ButtonSimpanClick ............................................. .90

Segmen 4.15. Procedure Insert-Order ........................................................ .93

Segmen 4.16. Function Get_Kode_FIFO ................................................... .94

Segmen 4.17. Procedure ButtonSimpanClick ............................................. .95

Segmen 4.18. Procedure ButtonSimpanClick ............................................. .99

Segmen 4.19. Procedure DBGrid 1DblClick .............................................. 10 1

Segmen 4.20. Procedure ButtonSimpanClick ............................................ 103

Segmen 4.2 1. Procedure ButtonSimpanClick ............................................ 109

Segmen 4.22. Procedure ButtonSimpanClick ............................................ 114

Segmen 4.23. Procedure ButtonSimpanClick ............................................ 116

Segmen 4.24. Procedure ButtonSimpanClick .......................................... 119

Segmen 4.25. Procedure ButtonSimpanClick ............................................ 122

Segmen 4.26. Procedure ButtonSimpanClick ............................................ 125

Segmen 4.27. Procedure ButtonSimpanClick .......................................... 127

xv Universitas Kristen Petra