SKRIPSI
SISTEM INFORMASI APOTEK BERBASIS CLIENT SERVER
Ditulis untuk memenuhi sebagai persyaratan akademik guna memperoleh gelar Sarjana Komputer Strata Satu
Oleh : NAMA
: ALEXS SANTOSO
NPM
: 08120110018
PROGRAM STUDI SISTEM INFORMASI FAKULTAS ILMU KOMPUTER UNIVERSITAS PELITA HARAPAN SURABAYA 2015
ABSTRAK Alexs Santoso (08120110018) SISTEM INFORMASI APOTEK BERBASIS CLIENT SERVER (xv + 128 halaman; 88 gambar; 40 tabel) Di era modern ini, perkembangan teknologi dan informasi yang berjalan begitu pesat sudah memasuki berbagai bidang dalam kehidupan masyarakat. Dalam bidang bisnis, penerapan teknologi merupakan faktor yang sangat penting untuk diperhatikan untuk mendapat kelebihan dalam bersaing di bidang bisnis. Dengan adanya sistem komputerisasi, pengolahan data menjadi informasi akan menjadi lebih akurat, efektif dan efisien serta membantu meningkatkan kinerja tiap profesi dan mempermudah dalam pengambilan keputusan. Sistem komputerisasi akan membantu menghemat waktu kerja yang dilakukan. Apotek Blessing adalah apotek yang sudah sangat berpengalaman di bidangnya dan sudah lama berdiri di kota Surabaya. Pelayanan apotek ini kepada pasien sangat ramah dan mengijinkan pasien untuk menawar harga. Namun, yang sangat disayangkan pada sistem yang sedang digunakan saat ini adalah dilakukan dengan cara manual sehingga kurang efektif dan kurang efisien. Solusi untuk mengatasi kurangnya efisiensi dan efektivitas tersebut adalah dengan menyediakan aplikasi yang dapat mengotomasi sistem yang ada dengan konsep client server. Dengan adanya aplikasi ini, pelayanan transaksi pada apotek akan menjadi lebih maksimal dengan mengurangi kegiatan secara manual dan memudahkan dalam pengelolaan data. Apabila kegiatan yang dilakukan secara manual dikurangi dengan aplikasi, maka sistem akan menjadi lebih efektif dan efisien. Berdasarkan hasil uji coba yang dilakukan, dapat disimpulkan bahwa aplikasi dapat memenuhi kebutuhan dan mengotomasi sistem dengan baik. Fiturfitur yang dimiliki aplikasi adalah : proses mengelola data user, proses mengelola data PBF, proses mengelola data dokter, proses mengelola data obat, proses mengelola data kemasan, proses transaksi pembelian, proses melunasi hutang, proses mencatat obat resep, proses transaksi penjualan, proses adjustment, proses stock opname dan proses menampilkan laporan. Referensi : 15 (1991-2014) Kata Kunci : Pemrograman Client/Server, Apotek, Obat, Sistem Informasi.
v
ABSTRACT Alexs Santoso (08120110018) CLIENT SERVER BASED DRUGSTORE INFORMATION SYSTEM (xv + 128 pages; 88 pictures; 40 tables) In this modern life, the development of technology and information that run so fast already entered in the various aspect in our society nowadays. In the business area, application of technology is a very important factor to be considered to gain advantages for compete in business area. With the computerized system, data management into information would be more accurate, effective, efficient and improving performance of each profession and facilitate the decission making. Computerization system will help to save working time. Blessing Drugstore is a very experiences drugstore in its area and has been along standing in Surabaya city. This drugstore services to patients is very friendly and allow patients to do price negotiation. But, unfortunately the current system is still working manually so less effective and less efficient. The solution to overcome the problems is to provide an application which can automating the current system with client server concept. With this application, transaction services in the drugstore will be more maximum with reducing manual activity and easier data management. If manual activity reduced by application, then system will be more effective and efficient. Based on trial, application can fulfilled the needs and automating the system well. The application features are : user data management process, PBF data management process, doctor data management process, medicine data management process, packaging data management process, purchases transaction process, paying off debt process, write prescription drugs, sales transaction process, adjustment process, stock opname process and report viewing process. References : 15 (1991-2014) Keywords : Client/Server Programming, Drugstore, Medicine, Information System.
vi
KATA PENGANTAR
Puji dan syukur penulis naikkan kepada Tuhan Yesus Kristus karena hanya atas rahmat dan anugerah-Nyalah tugas akhir ini dapat terselesaikan dengan baik. Tugas akhir dengan judul “Sistem Informasi Apotek Berbasis Client Server” ini disusun sebagai salah satu syarat untuk menyelesaikan jenjang strata satu, jurusan Sistem Informasi pada Universitas Pelita Harapan Surabaya. Pada kesempatan ini penulis hendak mengucapkan terima kasih kepada semua pihak yang telah terlibat mendukung penulis selama proses perkuliahan hingga laporan tugas akhir ini dapat terselesaikan, yakni : 1.
Kedua orangtua penulis, So Foei Ngai dan Wiwien, serta saudara dan saudari penulis, Yacoob dan Meliana yang telah memberikan doa, dukungan dan semangat selama proses perkuliahan hingga tugas akhir terselesaikan.
2.
Prof. Dr. Ir. Kuswara Setiawan, M.T., selaku Dosen Pembimbing.
3.
Andreas Jodhinata, S.Kom. M.Kom, selaku Ketua Program Studi Sistem Informasi dan Dosen Pembimbing.
4.
Dosen-dosen Program Studi Sistem Informasi yang telah memberikan bimbingan selama penulis menjalani studi di UPH Surabaya, yakni Yuliana, S.Kom, M.Kom; Budianto, S.Kom, M.Kom; Hartarto Junaedi, S.Kom, M.Kom; Yosi Kristian, S.Kom, M.Kom; Donald A. Latumahina, S.Kom, M.Kom; Ir. Suhatati Tjandra, M.Kom; Kiswono Prayogo, S.Kom, M.Kom; Aries Yoshan, S.Kom, M.Kom; James Wijaya, S.Kom;
5.
Pemilik apotek yang telah memberikan berbagai macam informasi mengenai apotek yaitu Julia Angelina, S.Farm., Apt.
6.
Beatrice Kerenhapukh H., Jevan Atmaja, Eklesianawati, Ardy Andrean, Windrawan Rakasiwi, Erga Kandly P., V. N. David Angelo, Daniel Hanry S., Alvin Ongkowijoyo, Emily Louis, Kholil Aziz, Joseph Christian, M. Nur Firdaus dan Paul Pieter untuk inspirasi, dukungan dan pengalaman bersama sepanjang masa studi.
7.
Anastasia Marcelina, Steven Nesdi Ghozali, Stephanie Er Em Nawahoke, Ignatius Richardo dan Merlin Sunyono Jie atas semangat dan dorongan selama masa perkuliahan di UPH Surabaya.
vii
8.
Stanislaus David Sundoro dan Daniel Cahyadi yang memberikan dukungan kepada penulis dalam berbagai bentuk selama masa studi.
9.
Stella August, Ryan Ferian serta seluruh staf ICT yang memberikan dukungan dalam berbagai bentuk selama masa studi.
10.
Seluruh civitas akademika UPH Surabaya dan semua pihak terkait yang telah membantu dalam proses pengembangan, uji coba sistem hingga penyelesaian laporan tugas akhir ini. Sebagai penutup, penulis menyadari bahwa laporan tugas akhir ini masih
memiliki banyak kekurangan, baik materi maupun penyajiannya, disebabkan keterbatasan pengetahuan dan pengalaman penulis. Oleh karena itu, kritik dan saran yang membangun sangat penulis harapkan.
Surabaya, Maret 2015
Alexs Santoso
viii
DAFTAR ISI
PERNYATAAN KEASLIAN KARYA TUGAS AKHIR ..................................... ii PERSETUJUAN DOSEN PEMBIMBING TUGAS AKHIR ............................... iii PERSETUJUAN TIM PENGUJI TUGAS AKHIR............................................... iv ABSTRAK .............................................................................................................. v ABSTRACT ........................................................................................................... vi KATA PENGANTAR .......................................................................................... vii DAFTAR ISI .......................................................................................................... ix DAFTAR GAMBAR ........................................................................................... xiii DAFTAR TABEL ................................................................................................. xv BAB I PENDAHULUAN ....................................................................................... 1 1.1
Latar Belakang ......................................................................................... 1
1.2
Permasalahan ............................................................................................ 3
1.3
Ruang Lingkup ......................................................................................... 4
1.4
Tujuan dan Manfaat .................................................................................. 7
1.5
Sistematika penulisan ............................................................................... 8
BAB II APOTEK .................................................................................................. 10 2.1
Tentang Apotek ...................................................................................... 10
2.1.1
Sejarah Apotek ................................................................................. 10
2.1.2
Definisi Apotek ................................................................................ 12
2.1.3
Tugas dan Fungsi Apotek ................................................................ 13
2.1.4
Pelayanan Apotek ............................................................................ 13
2.2
Tentang Obat .......................................................................................... 14
2.2.1
Definisi Obat .................................................................................... 14
2.2.2
Penggolongan Obat Menurut Undang-undang ................................ 15
2.2.3
Penggolongan Obat Generik dan Nama Dagang ............................. 18
2.2.4
Penggolongan Obat Tradisional....................................................... 19
2.2.5
Tujuan Penggolongan Obat ............................................................. 21
2.3
Tentang Obat Resep ............................................................................... 21
2.3.1
Penulisan Resep ............................................................................... 21
2.3.2
Copy Resep ...................................................................................... 22
ix
2.3.3
Pengelolaan Resep yang Telah Dibuat ............................................ 23
2.3.4
Penyerahan Obat .............................................................................. 23
2.4
Pedagang Besar Farmasi ........................................................................ 24
2.4.1
Definisi Pedagang Besar Farmasi .................................................... 24
2.4.2
Tugas dan Fungsi Pedagang Besar Farmasi .................................... 25
BAB III ANALISA DAN RANCANGAN SISTEM ........................................... 27 3.1
Analisa Sistem Apotek ........................................................................... 27
3.1.1
Obat Non Resep ............................................................................... 27
3.1.2
Obat Resep ....................................................................................... 29
3.1.3
Pembelian obat ................................................................................. 31
3.1.4
Penjualan Obat ................................................................................. 35
3.2
Rancangan Sistem .................................................................................. 37
3.2.1
Diagram Konteks (Context Diagram) Sistem Informasi Apotek .... 37
3.2.2
DFD Level 0 Sistem Informasi Apotek ........................................... 38
3.2.3
DFD Level 1 Proses Mengelola Data User ..................................... 40
3.2.4
DFD Level 1 Proses Mengelola Data PBF ...................................... 41
3.2.5
DFD Level 1 Proses Mengelola Data Dokter .................................. 42
3.2.6
DFD Level 1 Proses Mengelola Data Obat ..................................... 43
3.2.7
DFD Level 1 Proses Mengelola Data Kemasan .............................. 44
3.2.8
DFD Level 1 Proses Melakukan Transaksi Pembelian ................... 46
3.2.9
DFD Level 1 Proses Melunasi Hutang ............................................ 47
3.2.10 DFD Level 1 Proses Mencatat Obat Resep ..................................... 48 3.2.11 DFD Level 1 Proses Melakukan Transaksi Penjualan..................... 49 3.2.12 DFD Level 1 Proses Melakukan Adjustment ................................... 51 3.2.13 DFD Level 1 Proses Melakukan Stock Opname .............................. 52 3.2.14 DFD Level 1 Proses Menampilkan Laporan ................................... 52 3.2.15 DFD Level 2 Proses Menampilkan Laporan Master ....................... 53 3.2.16 DFD Level 2 Proses Menampilkan Laporan Stock .......................... 54 3.2.17 DFD Level 2 Proses Menampilkan Laporan Pembelian ................. 55 3.2.18 DFD Level 2 Proses Menampilkan Laporan Penjualan................... 56 3.2.19 DFD Level 2 Proses Menampilkan Laporan Hutang....................... 57 3.2.20 DFD Level 2 Proses Menampilkan Laporan Resep......................... 58
x
3.3
Diagram Hubungan Antar Entitas (Entity Relationship Diagram) ........ 58
3.4
Struktur Tabel ......................................................................................... 60
3.5
Kamus Data ............................................................................................ 66
3.6
Rancangan User Interface....................................................................... 74
BAB IV SISTEM INFORMASI APOTEK ........................................................ 102 4.1
Form Login ........................................................................................... 102
4.2
Form Menu ........................................................................................... 103
4.3
Menu Master......................................................................................... 103
4.3.1
Form Master Obat .......................................................................... 104
4.3.2
Form Tambah Obat ........................................................................ 105
4.4
Menu Akun ........................................................................................... 106
4.5
Menu Stock ........................................................................................... 107
4.5.1
Form Adjustment Obat ................................................................... 107
4.5.2
Form Stock Opname Obat .............................................................. 107
4.6
Menu Transaksi .................................................................................... 108
4.6.1
Form Transaksi Pembelian Obat.................................................... 109
4.6.2
Form Hutang .................................................................................. 110
4.6.3
Form Resep .................................................................................... 112
4.6.4
Form Transaksi Penjualan Obat Resep .......................................... 114
4.6.5
Form Transaksi Penjualan Obat Non Resep .................................. 115
4.7
Menu Laporan ...................................................................................... 116
4.7.1
Laporan Master Obat ..................................................................... 117
4.7.2
Laporan Stock Obat ........................................................................ 118
4.7.3
Laporan Kartu Stock Obat.............................................................. 119
4.7.4
Laporan Adjustment Obat .............................................................. 119
4.7.5
Laporan Summary Pembelian ........................................................ 120
4.7.6
Laporan Pembelian Obat ............................................................... 121
4.7.7
Laporan Detail Pembelian ............................................................. 122
4.7.8
Laporan Summary Penjualan ......................................................... 122
4.7.9
Laporan Penjualan Obat................................................................. 123
4.8
Form Konfigurasi ................................................................................. 124
BAB V PENUTUP .............................................................................................. 126
xi
5.1
Kesimpulan ........................................................................................... 126
5.2
Saran ..................................................................................................... 126
DAFTAR PUSTAKA ......................................................................................... 127 LAMPIRAN A Entity Relationship Diagram Sistem Informasi Apotek LAMPIRAN B Physical Diagram Sistem Informasi Apotek
xii
DAFTAR GAMBAR Gambar 2.1 Lambang Obat Bebas ........................................................................ 15 Gambar 2.2 Lambang Obat Bebas Terbatas ......................................................... 15 Gambar 2.3 Lambang Obat Keras ......................................................................... 16 Gambar 2.4 Lambang Obat Narkotika .................................................................. 17 Gambar 2.5 Lambang Jamu .................................................................................. 19 Gambar 2.6 Lambang Obat Herbal Terstandar ..................................................... 20 Gambar 2.7 Lambang Fitofarmaka ....................................................................... 20 Gambar 2.8 Contoh Resep Dokter ........................................................................ 22 Gambar 2.9 Contoh Copy Resep Dokter ............................................................... 23 Gambar 2.10 Contoh Etiket Putih ......................................................................... 24 Gambar 2.11 Contoh Etiket Biru .......................................................................... 24 Gambar 3.1 Contoh Resep Obat Jadi .................................................................... 30 Gambar 3.2 Contoh Resep Obat Racik ................................................................. 31 Gambar 3.3 Contoh Copy Resep ........................................................................... 36 Gambar 3.4 Diagram Konteks Sistem Informasi Apotek ..................................... 38 Gambar 3.5 DFD Level 0 Sistem Informasi Apotek............................................. 40 Gambar 3.6 DFD Level 1 Proses Mengelola Data User ....................................... 40 Gambar 3.7 DFD Level 1 Proses Mengelola Data PBF ....................................... 42 Gambar 3.8 DFD Level 1 Proses Mengelola Data Dokter ................................... 43 Gambar 3.9 DFD Level 1 Proses Mengelola Data Obat ....................................... 44 Gambar 3.10 DFD Level 1 Proses Mengelola Data Kemasan .............................. 45 Gambar 3.11 DFD Level 1 Proses Melakukan Transaksi Pembelian ................... 46 Gambar 3.12 DFD Level 1 Proses Melunasi Hutang............................................ 47 Gambar 3.13 DFD Level 1 Proses Mencatat Obat Resep ..................................... 48 Gambar 3.14 DFD Level 1 Proses Melakukan Transaksi Penjualan .................... 49 Gambar 3.15 DFD Level 1 Proses Melakukan Adjustment .................................. 51 Gambar 3.16 DFD Level 1 Proses Melakukan Stock Opname ............................. 52 Gambar 3.17 DFD Level 1 Proses Menampilkan Laporan ................................... 53 Gambar 3.18 DFD Level 2 Proses Menampilkan Laporan Master....................... 54 Gambar 3.19 DFD Level 2 Proses Menampilkan Laporan Stock ......................... 55 Gambar 3.20 DFD Level 2 Proses Menampilkan Laporan Pembelian ................. 56 Gambar 3.21 DFD Level 2 Proses Menampilkan Laporan Penjualan .................. 57 Gambar 3.22 DFD Level 2 Proses Menampilkan Laporan Hutang ...................... 57 Gambar 3.23 DFD Level 2 Proses Menampilkan Laporan Resep ........................ 58 Gambar 3.24 Entity Relationship Diagram Sistem Informasi Apotek ................. 59 Gambar 3.25 Physical Diagram Sistem Informasi Apotek .................................. 60 Gambar 3.26 Rancangan Form Login ................................................................... 74 Gambar 3.27 Rancangan Form Menu ................................................................... 75 Gambar 3.28 Rancangan Form Master User......................................................... 76 Gambar 3.29 Rancangan Form Tambah User....................................................... 77 Gambar 3.30 Rancangan Form Ubah Password ................................................... 79 Gambar 3.31 Rancangan Form Adjustment Obat .................................................. 80 Gambar 3.32 Rancangan Form Stock Opname Obat ............................................ 81 Gambar 3.33 Rancangan Form Transaksi Pembelian Obat .................................. 82 Gambar 3.34 Rancangan Form Hutang................................................................. 84 Gambar 3.35 Rancangan Form Pelunasan Hutang ............................................... 85
xiii
Gambar 3.36 Rancangan Form Resep ................................................................... 86 Gambar 3.37 Rancangan Form Tambah Resep..................................................... 87 Gambar 3.38 Rancangan Form Tambah Detail Resep .......................................... 88 Gambar 3.39 Rancangan Form Transaksi Penjualan Obat Resep......................... 90 Gambar 3.40 Rancangan Nota Penjualan Obat Resep .......................................... 91 Gambar 3.41 Rancangan Form Transaksi Penjualan Obat Non Resep ................. 92 Gambar 3.42 Rancangan Laporan Master User .................................................... 93 Gambar 3.43 Rancangan Laporan Stock Obat ...................................................... 94 Gambar 3.44 Rancangan Laporan Kartu Stock Obat ............................................ 95 Gambar 3.45 Rancangan Laporan Adjustment Obat ............................................. 95 Gambar 3.46 Rancangan Laporan Summary Pembelian ....................................... 96 Gambar 3.47 Rancangan Laporan Pembelian Obat .............................................. 97 Gambar 3.48 Rancangan Laporan Detail Pembelian ............................................ 98 Gambar 3.49 Rancangan Laporan Summary Penjualan ........................................ 98 Gambar 3.50 Rancangan Laporan Penjualan Obat ............................................... 99 Gambar 3.51 Rancangan Form Konfigurasi ....................................................... 101 Gambar 4.1 Form Login...................................................................................... 102 Gambar 4.2 Form Menu ...................................................................................... 103 Gambar 4.3 Form Master Obat ........................................................................... 104 Gambar 4.4 Form Tambah Obat ......................................................................... 105 Gambar 4.5 Form Ubah Password ...................................................................... 106 Gambar 4.6 Form Adjustment Obat .................................................................... 107 Gambar 4.7 Form Stock Opname Obat ............................................................... 108 Gambar 4.8 Form Transaksi Pembelian Obat ..................................................... 109 Gambar 4.9 Form Hutang ................................................................................... 111 Gambar 4.10 Form Pelunasan Hutang ................................................................ 111 Gambar 4.11 Form Resep ................................................................................... 112 Gambar 4.12 Form Tambah Resep ..................................................................... 113 Gambar 4.13 Form Tambah Detail Resep........................................................... 113 Gambar 4.14 Form Transaksi Penjualan Obat Resep ......................................... 114 Gambar 4.15 Form Transaksi Penjualan Obat Non Resep ................................. 115 Gambar 4.16 Nota Penjualan Obat Non Resep ................................................... 116 Gambar 4.17 Laporan Master Obat ..................................................................... 117 Gambar 4.18 Laporan Stock Obat ....................................................................... 118 Gambar 4.19 Laporan Kartu Stock Obat ............................................................. 119 Gambar 4.20 Laporan Adjustment Obat .............................................................. 120 Gambar 4.21 Laporan Summary Pembelian........................................................ 120 Gambar 4.22 Laporan Pembelian Obat ............................................................... 121 Gambar 4.23 Laporan Detail Pembelian ............................................................. 122 Gambar 4.24 Laporan Summary Penjualan ......................................................... 123 Gambar 4.25 Laporan Penjualan Obat ................................................................ 124 Gambar 4.26 Form Konfigurasi .......................................................................... 125
xiv
DAFTAR TABEL Tabel 3.1 Struktur Tabel User ............................................................................... 60 Tabel 3.2 Struktur Tabel Dokter ........................................................................... 61 Tabel 3.3 Struktur Tabel PBF ............................................................................... 61 Tabel 3.4 Struktur Tabel Obat ............................................................................... 61 Tabel 3.5 Struktur Tabel Kemasan........................................................................ 62 Tabel 3.6 Struktur Tabel Hbeli.............................................................................. 62 Tabel 3.7 Struktur Tabel Dbeli.............................................................................. 62 Tabel 3.8 Struktur Tabel Dbeli2............................................................................ 63 Tabel 3.9 Struktur Tabel Hutang........................................................................... 63 Tabel 3.10 Struktur Tabel Kartuhutang ................................................................ 63 Tabel 3.11 Struktur Tabel Resep ........................................................................... 63 Tabel 3.12 Struktur Tabel Dresep ......................................................................... 64 Tabel 3.13 Struktur Tabel Dracik.......................................................................... 64 Tabel 3.14 Struktur Tabel Hjual............................................................................ 64 Tabel 3.15 Struktur Tabel Djual............................................................................ 64 Tabel 3.16 Struktur Tabel Djual2.......................................................................... 65 Tabel 3.17 Struktur Tabel Adjustment .................................................................. 65 Tabel 3.18 Struktur Tabel Adjustment2 ................................................................ 65 Tabel 3.19 Struktur Tabel Kartustock ................................................................... 65 Tabel 3.20 Struktur Tabel Kartustock2 ................................................................. 66 Tabel 3.21 Kamus Data Tabel Adjustment ........................................................... 66 Tabel 3.22 Kamus Data Tabel Adjustment2 ......................................................... 66 Tabel 3.23 Kamus Data Tabel Dbeli ..................................................................... 67 Tabel 3.24 Kamus Data Tabel Dbeli2 ................................................................... 67 Tabel 3.25 Kamus Data Tabel Djual ..................................................................... 67 Tabel 3.26 Kamus Data Tabel Djual2 ................................................................... 68 Tabel 3.27 Kamus Data Tabel Dokter................................................................... 68 Tabel 3.28 Kamus Data Tabel Dracik ................................................................... 68 Tabel 3.29 Kamus Data Tabel Dresep .................................................................. 69 Tabel 3.30 Kamus Data Tabel Hbeli ..................................................................... 69 Tabel 3.31 Kamus Data Tabel Hjual ..................................................................... 70 Tabel 3.32 Kamus Data Tabel Hutang .................................................................. 70 Tabel 3.33 Kamus Data Tabel Kartuhutang.......................................................... 71 Tabel 3.34 Kamus Data Tabel Kartustock ............................................................ 71 Tabel 3.35 Kamus Data Tabel Kartustock2 .......................................................... 72 Tabel 3.36 Kamus Data Tabel Kemasan ............................................................... 72 Tabel 3.37 Kamus Data Tabel Obat ...................................................................... 72 Tabel 3.38 Kamus Data Tabel PBF ...................................................................... 73 Tabel 3.39 Kamus Data Tabel Resep .................................................................... 74 Tabel 3.40 Kamus Data Tabel User ...................................................................... 74
xv
