ABSTRAK Tugas akhir ini berupa analisis dan pembuatan Sistem Informasi Pemantauan Kinerja Teknisi dan Inventori sebagai pendukung kegiatan di Aora TV daerah operasional Bandung. Sampai saat ini, Aora TV daerah operasional Bandung belum memiliki sistem untuk melakukan pengelolaan data barang dan distribusi work order, pencarian data, maupun pencatatan data pelanggan. Hal ini disebabkan karena data masih disimpan dalam bentuk arsip fisik dan file komputer yang diproses secara manual. Untuk itu dikembangkan suatu sistem informasi berbasis web yang sesuai dengan kebutuhan Aora TV daerah operasional Bandung. Sistem ini juga dapat membantu menentukan kinerja dari karyawan teknisi. Dengan adanya sistem ini para pengguna dapat memasukkan data barang, data pelanggan, data supplier, data distribusi work order, pencarian data, laporan barang masuk, laporan barang keluar, dan buku jurnal. Data dikelola secara terpadu dan diolah menjadi berbagai bentuk informasi yang dibutuhkan. Sistem juga dapat diakses secara cepat oleh pihak Aora TV daerah operasional Bandung melalui berbagai platform. Sistem informasi ini diharapkan dapat mempermudah proses pendataan barang yang masih terdapat di gudang maupun yang sudah terpasang di pelanggan. Lebih jauh lagi, juga sistem diharapkan dapat membantu pemantauan dan evaluasi kinerja karyawan.Sistem Informasi ini dibuat berbasis web menggunakan PHP sebagai bahasa pemrograman dan MySQL sebagai basis datanya. Kata kunci : Sistem informasi, pemantauan, kinerja, inventori, PHP, MySQL
Universitas Kristen Maranatha
ABSTRACT The final project of analysis and development of Technician Performance and Inventory Monitoring Information System was conducted to support operating activities in Aora TV Bandung. At the present, Aora TV Bandung has not yet possessed an appropriate system to manage inventory and work order distribution, data search, and customer data input. All these are still performed manually or semimanually and stored as computer files. The development of this information system may provide solutions to Aora TV Bandung.The system will allows users to manage inventory data, customer data, work order distribution, data search, incoming goods, outgoing goods, and journal entries. With this system, the data will be managed integratedly and processed as various information. This system can also be accessed quickly by Aora TV Bandung which may improve the stock keeping process in the warehouse and the stock monitoring for equipments that are held by the customers. Further, this system can assist the monitoring and performance of technicians. This information system is developed as a web-based application using PHP and MySQL databases.
Key Word: Information systems, monitoring, performance, inventory, PHP, MySQL
Universitas Kristen Maranatha
DAFTAR ISI PRAKATA ...................................................................................................... ABSTRAK ...................................................................................................... ABSTRACT ..................................................................................................... DAFTAR ISI ................................................................................................... DAFTAR TABEL ............................................................................................ DAFTAR GAMBAR ........................................................................................
i iii iv v viii x
BAB I PENDAHULUAN ................................................................................. 1.1 Latar Belakang Masalah ...................................................................... 1.2 Rumusan Masalah ............................................................................. 1.3 Tujuan Pembahasan ........................................................................... 1.4 Ruang Lingkup Kajian ......................................................................... 1.5 Sumber Data ....................................................................................... 1.6 Sistematika Penyajian .........................................................................
1 1 2 2 2 3 3
BAB II KAJIAN TEORI ................................................................................... 2.1 Sistem Informasi ................................................................................. 2.2 Kinerja .................................................................................. 2.3 Profil Perusahaan Aora TV .................................................................. 2.4 Proses Bisnis ..................................................................................... 2.5 Internet ................................................................................................ 2.6 Situs Web ................................................................................... 2.7 Bagan Alir ........................................................................................... 2.8 Basis Data............................................................................................ 2.9 Entity Relationship Diagram ................................................................. 2.10 Data Flow Diagram .............................................................................. 2.11 Kamus Data ......................................................................................... 2.12 PHP ................................................................................... 2.12.1 Sejarah PHP ............................................................................. 2.12.2 Keunggulan PHP ...................................................................... 2.12.3 Struktur Halaman PHP ............................................................. 2.13 Cascading Style Sheets ...................................................................... 2.13.1 Sejarah CSS ............................................................................. 2.13.2 Kelebihan CSS ......................................................................... 2.13.3 Struktur Penulisan CSS ............................................................ 2.13.4 Cara Penggunaan CSS ............................................................ 2.14 My Structure Query Language ............................................................ 2.14.1 Sejarah MySQL ....................................................................... 2.14.2 Keunggulan MySQL ................................................................. 2.14.3 Fitur-fitur MySQL ..................................................................... 2.14.4 Syntax MySQL ......................................................................... 2.15 Pengujian Black Box ...........................................................................
5 5 6 6 8 9 10 13 14 16 17 20 20 21 22 23 24 24 25 25 26 27 30 30 31 32 33
BAB III ANALISIS DAN RANCANGAN SISTEM ........................................... 3.1 Gambaran Umum Aora TV .................................................................. 3.2 Proses Bisnis ...................................................................................... 3.3 Perancangan Database........................................................................ 3.3.1 Entity Relational Diagram (ERD)............................................... 3.3.2 Relasi Antar Tabel .................................................................... 3.3.3 Transformasi ERD ....................................................................
34 34 35 44 44 46 46
Universitas Kristen Maranatha
3.4
3.5 3.6 3.7
Perancangan Sistem ............................................................................ 3.41 Diagram Konteks ...................................................................... 3.4.2 Data Flow Diagram (DFD) Level 1 ............................................ 3.4.3 Data Flow Diagram Level 2 Proses 1 ........................................ 3.4.4 Data Flow Diagram Level 2 Proses 2 ........................................ 3.4.5 Data Flow Diagram Level 2 Proses 3 ........................................ 3.4.6 Data Flow Diagram Level 2 Proses 4 ........................................ Kamus Data ......................................................................................... Process Specification (PSPEC) ......................................................... Rancangan Antarmuka .......................................................................
BAB IV HASIL PENELITIAN ................................................................... 4.1 Halaman Awal Login ........................................................................... 4.2 Halaman Sulit Akses .......................................................................... 4.3 Halaman Aktifasi Akun ......................................................................... 4.4 Halaman Index Level Akses Owner...................................................... 4.5 Halaman Barang Masuk (Owner) ......................................................... 4.6 Halaman Barang Keluar (Owner) ......................................................... 4.7 Halaman Buku Jurnal (Owner) ............................................................. 4.8 Halaman Distribusi WO (Owner) .......................................................... 4.9 Halaman Info Teknisi (Owner) .............................................................. 4.10 Halaman Data Admin (Owner) ............................................................. 4.11 Halaman Data Group (Owner).............................................................. 4.12 Halaman Data Kantor (Owner) ............................................................. 4.13 Halaman Data Katagori (Owner) .......................................................... 4.14 Halaman Data Pelanggan (Owner) ...................................................... 4.15 Halaman Data Supplier (Owner) .......................................................... 4.16 Halaman FAQ (Owner)......................................................................... 4.17 Halaman Histori Login (Owner) ............................................................ 4.18 Halaman Jejak Aktifitas (Owner) .......................................................... 4.19 Halaman Profil Saya (Owner) ............................................................... 4.20 Halaman Index Level Akses Admin ...................................................... 4.21 Halaman Barang Masuk (Admin) ......................................................... 4.22 Halaman Barang Keluar (Admin) .......................................................... 4.23 Halaman Distibusi WO (Admin) ............................................................ 4.24 Halaman Info Teknisi (Admin) .............................................................. 4.25 Halaman Data Group (Admin) .............................................................. 4.26 Halaman Data Katagori (Admin) ........................................................... 4.27 Halaman Data Pelanggan (Admin) ....................................................... 4.28 Halaman Data Supplier (Admin) ........................................................... 4.29 Halaman FAQ (Admin) ......................................................................... 4.30 Halaman Profil Saya (Admin) ............................................................... 4.31 Halaman Index Level Akses Dispatcher ............................................... 4.32 Halaman Distribusi WO (Dispatcher) .................................................... 4.33 Halaman Data Pelanggan (Dispatcher) ................................................ 4.34 Halaman Info Teknisi (Dispatcher) ....................................................... 4.35 Halaman FAQ (Dispatcher) .................................................................. 4.36 Halaman Profil Saya (Dispatcher) ........................................................ 4.37 Halaman Index Level Akses Gudang ................................................... 4.38 Halaman Info Inventori (Gudang) ......................................................... 4.39 Halaman FAQ (Gudang) ...................................................................... 4.40 Halaman Profil Saya (Gudang).............................................................
55 55 59 61 62 64 66 67 77 85 92 92 92 96 97 98 102 103 105 107 109 110 112 113 115 118 120 122 124 125 125 126 128 128 129 130 131 132 133 134 135 136 137 145 145 146 147 148 149 152 153
Universitas Kristen Maranatha
BAB V PEMBAHASAN DAN UJI COBA HASIL PENELITIAN ...................... 5.1 Pengujian Login ................................................................................... 5.2 Pengujian Lupa Password .................................................................... 5.3 Pengujian Barang Masuk ..................................................................... 5.4 Pengujian Distribusi WO ...................................................................... 5.5 Pengujian Data Admin.......................................................................... 5.6 Pengujian Data Group .......................................................................... 5.7 Pengujian Data Kantor ......................................................................... 5.8 Pengujian Data Katagori ...................................................................... 5.9 Pengujian Data Supplier....................................................................... 5.10 Pengujian Data FAQ ............................................................................ 5.11 Pengujian Profil Saya ...........................................................................
155 155 156 157 159 160 161 162 163 163 165 166
BAB VI SIMPULAN DAN SARAN .................................................................. 168 6.1 Simpulan ............................................................................................. 168 6.2 Saran .................................................................................................. 169 DAFTAR PUSTAKA ....................................................................................... 170 RIWAYAT HIDUP PENULIS ........................................................................... 172
Universitas Kristen Maranatha
DAFTAR TABEL Tabel I Tabel II Tabel III Tabel IV Tabel V Tabel VI Tabel VII Tabel VIII Tabel IX Tabel X Tabel XI Tabel XII Tabel XIII Tabel XIV Tabel XV Tabel XVI Tabel XVII Tabel XVIII Tabel XIX Tabel XX Tabel XXI Tabel XXII Tabel XXIII Tabel XXIV Tabel XXV Tabel XXVI Tabel XXVII Tabel XXVIII Tabel XXIX Tabel XXX Tabel XXXI Tabel XXXII Tabel XXXIII Tabel XXXIV Tabel XXXV Tabel XXXVI Tabel XXXVII Tabel XXXVIII Tabel XXXIX Tabel XL Tabel XLI Tabel XLII Tabel XLIII Tabel XLIV Tabel XLV Tabel XLVI Tabel XLVII Tabel XLVIII Tabel XLIX Tabel L
Data Statistik Pengguna Penjelajah Web ...................... Simbol-simbol bagan alir ............................................... Simbol-simbol ERD ....................................................... Simbol-simbol DFD ....................................................... Syntax MySQL .............................................................. Tabel tb_akses.............................................................. Tabel tb_data_admin .................................................... Tabel tb_data_kantor .................................................... Tabel tb_supplier........................................................... Tabel tb_provinsi ........................................................... Tabel tb_kabupaten ...................................................... Tabel tb_aktifitas ........................................................... Tabel tb_histori ............................................................. Tabel tb_faq .................................................................. Tabel tb_distribusi_wo .................................................. Tabel tb_detail_distribusi............................................... Tabel tb_pelanggan ...................................................... Tabel tb_barang ............................................................ Tabel tb_katagori .......................................................... Tabel tb_barang_milik ................................................... Tabel tb_temp ............................................................... Tabel tb_group .............................................................. Tabel tb_detail_group ................................................... Tabel tb_riwayat_wo ..................................................... Tabel tb_instalasi .......................................................... Tabel tb_pemilik_group ................................................. Tabel tb_no_spk ........................................................... Tabel tb_jurnal .............................................................. Kamus Data tb_akses ................................................... Kamus Data tb_data_admin .......................................... Kamus Data tb_data_kantor .......................................... Kamus Data tb_supplier ................................................ Kamus Data tb_provinsi ................................................ Kamus Data tb_kabupaten ............................................ Kamus Data tb_aktifitas ................................................ Kamus Data tb_histori ................................................... Kamus Data tb_faq ....................................................... Kamus Data tb_distribusi_wo ........................................ Kamus Data tb_detail_distribusi .................................... Kamus Data tb_pelanggan ............................................ Kamus Data tb_barang ................................................. Kamus Data tb_katagori ................................................ Kamus Data tb_barang_milik ........................................ Kamus Data tb_temp .................................................... Kamus Data tb_group ................................................... Kamus Data tb_detail_group ......................................... Kamus Data tb_riwayat_wo ........................................... Kamus Data tb_instalasi................................................ Kamus Data tb_no_spk ................................................. Kamus Data tb_jurnal ....................................................
12 13 16 17 32 47 47 48 48 49 49 49 50 50 50 51 51 52 52 53 53 53 53 54 54 55 55 55 67 67 68 68 69 69 70 70 70 71 71 72 72 73 73 74 74 74 75 75 75 76
Universitas Kristen Maranatha
Tabel LI Tabel LII Tabel LIII Tabel LIV Tabel LV Tabel LVI Tabel LVII Tabel LVIII Tabel LIX Tabel LX Tabel LXI Tabel LXII Tabel LXIII Tabel LXIV Tabel LXV Tabel LXVI Tabel LXVII Tabel LXVIII Tabel LXIX Tabel LXX Tabel LXXI Tabel LXXII Tabel LXXIII Tabel LXXIV Tabel LXXV Tabel LXXVI Tabel LXXVII Tabel LXXVIII Tabel LXXIX Tabel LXXX Tabel LXXXI Tabel LXXXII Tabel LXXXIII Tabel LXXXIV Tabel LXXXV Tabel LXXXVI Tabel LXXXVII Tabel LXXXVIII
Kamus Data tb_pemilik_group ...................................... 1 Mengelola login .......................................................... 2 Mengelola master....................................................... 3 Mengelola layanan ..................................................... 4 Mengelola bantuan ..................................................... 1.1 Proses login ............................................................ 1.2 Proses sulit akses ................................................... 2.1 Proses master data admin....................................... 2.2 Proses master data group ....................................... 2.3 Proses master data kantor ...................................... 2.4 Proses master data katagori.................................... 2.5 Proses master data pelanggan ................................ 2.6 Proses master data supplier .................................... 3.1 Proses layanan barang masuk ................................ 3.2 Proses layanan barang keluar ................................. 3.3 Proses layanan buku jurnal ..................................... 3.4 Proses layanan distribusi WO ................................. 3.5 Proses layanan info teknisi ...................................... 3.6 Proses layanan info inventori .................................. 4.1 Proses faq ............................................................... 4.2 Proses histori login .................................................. 4.3 Proses jejak aktifitas................................................ 4.4 Proses profil saya .................................................... Pengujian login ............................................................. Pengujian lupa password .............................................. Pengujian tambah barang masuk .................................. Pengujian ubah barang masuk ...................................... Pengujian tambah distribusi WO ................................... Pengujian tambah admin baru....................................... Pengujian tambah group baru ....................................... Pengujian ubah data kantor .......................................... Pengujian tambah katagori baru.................................... Pengujian tambah supplier baru .................................... Pengujian ubah supplier ................................................ Pengujian tambah FAQ baru ......................................... Pengujian ubah FAQ ..................................................... Pengujian ubah profil saya ............................................ Pengujian ubah password saya.....................................
76 77 77 77 78 78 79 79 79 80 80 80 81 81 81 82 82 83 83 83 84 84 84 155 156 157 158 159 160 161 162 163 163 164 165 166 166 167
Universitas Kristen Maranatha
DAFTAR GAMBAR Gambar 1 Gambar 2 Gambar 3 Gambar 4 Gambar 5 Gambar 6 Gambar 7 Gambar 8 Gambar 9 Gambar 10 Gambar 11 Gambar 12 Gambar 13 Gambar 14 Gambar 15 Gambar 16 Gambar 17 Gambar 18 Gambar 19 Gambar 20 Gambar 21 Gambar 22 Gambar 23 Gambar 24 Gambar 25 Gambar 26 Gambar 27 Gambar 28 Gambar 29 Gambar 30 Gambar 31 Gambar 32 Gambar 33 Gambar 34 Gambar 35 Gambar 36 Gambar 37 Gambar 38 Gambar 39 Gambar 40 Gambar 41 Gambar 42 Gambar 43 Gambar 44 Gambar 45 Gambar 46 Gambar 47 Gambar 48 Gambar 49 Gambar 50
Logo Aora TV ........................................................................... Ilustrasi Pengertian Internet ...................................................... Data statistik pengguna penjelajah situs berdasarkan negara .. Jenjang dari data ...................................................................... Logo PHP ................................................................................. Logo MySQL............................................................................. Diagram alir proses input data barang oleh admin .................... Diagram alir distribusi work order instalasi pemasangan baru .. Diagram alir distribusi work order gangguan ............................. Diagram alir distribusi work order pencabutan .......................... Diagram alir distribusi work order penambahan ........................ ERD .......................................................................................... Relasi antar tabel ...................................................................... Diagram konteks....................................................................... ERD level 1 .............................................................................. ERD level 2 pada proses 1 ....................................................... ERD level 2 pada proses 2 ....................................................... ERD level 2 pada proses 3 ....................................................... ERD level 2 pada proses 4 ....................................................... Rancangan halaman login ........................................................ Rancangan halaman sulit akses ............................................... Rancangan halaman untuk level akses admin .......................... Rancangan halaman untuk level akses dispatcher ................... Rancangan halaman untuk level akses gudang ........................ Rancangan halaman untuk level akses owner .......................... Halaman login........................................................................... Halaman sulit akses tahap 1 ..................................................... Halaman sulit akses tahap 2 ..................................................... Halaman sulit akses tahap 2 (pesan error) ............................... Halaman sulit akses tahap 3 ..................................................... Halaman sulit akses tahap 4 ..................................................... Halaman sulit akses tahap 5 ..................................................... Halaman aktifasi akun bagian 1 ................................................ Halaman aktifasi akun bagian 2 ................................................ Halaman index level owner ....................................................... Halaman barang masuk ............................................................ Halaman detail barang masuk .................................................. Halaman tambah barang .......................................................... Halaman import data barang .................................................... Halaman barang keluar ............................................................ Halaman buku jurnal ................................................................. Halaman distribusi WO ............................................................. Halaman detail WO................................................................... Halaman info teknisi ................................................................. Halaman detail info teknisi ........................................................ Halaman data admin................................................................. Halaman tambah data admin .................................................... Halaman data group ................................................................. Halaman detail data group ........................................................ Halaman data kantor ................................................................
8 9 12 15 21 30 36 37 39 41 43 45 46 56 59 61 62 64 66 85 86 87 88 89 91 92 93 93 94 94 95 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113
Universitas Kristen Maranatha
Gambar 51 Gambar 52 Gambar 53 Gambar 54 Gambar 55 Gambar 56 Gambar 57 Gambar 58 Gambar 59 Gambar 60 Gambar 61 Gambar 62 Gambar 63 Gambar 64 Gambar 65 Gambar 66 Gambar 67 Gambar 68 Gambar 69 Gambar 70 Gambar 71 Gambar 72 Gambar 73 Gambar 74 Gambar 75 Gambar 76 Gambar 77 Gambar 78 Gambar 79 Gambar 80 Gambar 81 Gambar 82 Gambar 83 Gambar 84 Gambar 85 Gambar 86 Gambar 87 Gambar 88 Gambar 89 Gambar 90 Gambar 91
Halaman data katagori.............................................................. Halaman tambah data katagori ................................................. Halaman data pelanggan .......................................................... Halaman detail data pelanggan ................................................ Halaman data supplier .............................................................. Halaman tambah data supplier ................................................. Halaman detail data supplier .................................................... Halaman FAQ ........................................................................... Halaman tambah FAQ .............................................................. Halaman histori login ................................................................ Halaman jejak aktifitas .............................................................. Halaman profil saya .................................................................. Halaman index level admin ....................................................... Halaman barang masuk ............................................................ Halaman barang keluar ............................................................ Halaman distribusi WO ............................................................. Halaman info teknisi ................................................................. Halaman data group ................................................................. Halaman data katagori.............................................................. Halaman data pelanggan .......................................................... Halaman data supplier .............................................................. Halaman FAQ ........................................................................... Halaman profil saya .................................................................. Halaman index level dispatcher ................................................ Halaman distribusi WO ............................................................. Halaman detail distribusi WO.................................................... Halaman tambah distribusi WO di langkah 1 ............................ Halaman tambah distribusi WO di langkah 2 ............................ Halaman pembuatan WO gangguan......................................... Halaman pembuatan WO pencabutan ...................................... Halaman pembuatan WO penambahan .................................... Halaman data pelanggan .......................................................... Halaman info teknisi ................................................................. Halaman FAQ ........................................................................... Halaman profil saya .................................................................. Halaman index level gudang..................................................... Halaman info inventori .............................................................. Halaman serah terima tahap 1 .................................................. Halaman serah terima tahap 2 .................................................. Halaman FAQ ........................................................................... Halaman profil saya ..................................................................
114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154
Universitas Kristen Maranatha