Download - listing program
Universitas Sumatera Utara
LAMPIRAN 1
LISTING PROGRAM
Bentuk spesifikasi list program pada perancangan sistem informasi pelayanan
klinik TI kampus (Studi Kasus pada Klinik TI USU) adalah sebagai berikut :
1. List Program Pilih Session Form Login
Nama : Pilih Session Form Login Tujuan : Untuk menampilkan menu user sesuai dengan login masuk Lokasi : Form Login Program : PHP dan Database MySQL Pseudocode <?php session_start(); if ($_SESSION['level'] == "admin") { //tampilkan menu "admin" include "menu_admin.php";}
else if ($_SESSION['level'] == "petugas") { //tampilkan menu "petugas"
include "menu_opt.php";} else if ($_SESSION['level'] == "operator1")
{ //tampilkan menu "operator" include "menu_teknisi2.php"; echo "<meta http-equiv=\"refresh\" content=\"0 url=./tindakan2.php?user=$user2\">";} else if ($_SESSION['level'] == "operator2")
{ //tampilkan menu "operator" include "menu_teknisi.php";} ?>
Lampiran 1.1 Program Spesifikasi Session Menu
2. List Program Login User
Nama : Login_User Tujuan : Menjalankan aplikasi sesuai dengan hak akses masing-masing Lokasi : Form Login Program : PHP dan Database MySQL Pseudocode <?php session_start(); mysql_connect('localhost', 'root', ''); mysql_select_db('klinik_ti'); $username = $_POST['username'];
98
Universitas Sumatera Utara
$password = $_POST['pass']; $nama = $_POST['nama']; $query = "SELECT * FROM user WHERE nama = '$username'"; $hasil = mysql_query($query); $data = mysql_fetch_array($hasil); // cek kesesuaian password if ($password == $data['password']) { $level=$data['level'];
if ($level == "admin") { $_SESSION['level'] = $data['level']; $_SESSION['username'] = $data['username']; $_SESSION['nama'] = $data['nama']; include "menu_admin.php"; } else if ($level == "operator1") { $_SESSION['level2'] = $data['level']; $_SESSION['username2'] = $data['username']; $_SESSION['nama2'] = $data['nama']; include "menu_teknisi2.php"; } else if ($level == "operator2") { $_SESSION['level3'] = $data['level']; $_SESSION['username3'] = $data['username']; $_SESSION['nama3'] = $data['nama']; include "menu_teknisi.php"; } else if ($level == "petugas") { $_SESSION['level4'] = $data['level']; $_SESSION['username4'] = $data['username']; $_SESSION['nama4'] = $data['nama']; include "menu_opt.php"; } else{ include "index.htm"; } include "menu.php";
} else { include "index.htm"; echo "<script>alert('MAAF PROSES LOGIN ANDA GAGAL. COBA PERIKSA
KEMBALI USERNAME DAN PASSWORD ANDA');</script>"; } ?>
Lampiran 1.2 Program Spesifikasi Login User
120 97
99
Universitas Sumatera Utara
3. List Program Menu Admin
Nama : Menu_Admin Tujuan : Menampilkan dan menjalankan aplikasi menu admin sesuai dengan Login user Lokasi : Program : PHP dan Database MySQL Pseudocode <?php include"config.php"; ?> <html> <head> <title>SISTEM INFORMASI KLINIK TI UNIVERSITAS SUMATERA UTARA</title> <script language="JavaScript"> <!-- function mmLoadMenus() { if (window.mm_menu_0227084959_0) return; window.mm_menu_0227084959_0 = new Menu("root",232,18,"Franklin Gothic Book, Times, serif",12,"#000000","#0000FF","#CCCCFF","#FFFFFF","left","middle",3,0,50,-5,7,true,true,true,0,true,true); mm_menu_0227084959_0.addMenuItem("INPUT DATA KELUHAN","window.open('input_keluhan.php?user=<?php echo $_SESSION['username'];?>', 'framehome');"); mm_menu_0227084959_0.addMenuItem("INPUT KATEGORI KELUHAN","window.open('input_kategori.php', 'framehome');"); mm_menu_0227084959_0.fontWeight="bold"; mm_menu_0227084959_0.hideOnMouseOut=true; mm_menu_0227084959_0.bgColor='#000000'; mm_menu_0227084959_0.menuBorder=1; mm_menu_0227084959_0.menuLiteBgColor='#000000'; mm_menu_0227084959_0.menuBorderBgColor='#000000'; window.mm_menu_0227085749_0 = new Menu("root",172,18,"Franklin Gothic Book",12,"#000000","#0000FF","#CCCCFF","#FFFFFF","left","middle",3,0,50,-5,7,true,true,true,0,true,true); mm_menu_0227085749_0.addMenuItem("INPUT TINDAKAN","window.open('tindakan.php?user=<?php echo $_SESSION['username'];?>', 'framehome');"); mm_menu_0227085749_0.addMenuItem("DAFTAR TINDAKAN","window.open('cari_tindakan.php', 'framehome');"); mm_menu_0227085749_0.fontWeight="bold"; mm_menu_0227085749_0.hideOnMouseOut=true; mm_menu_0227085749_0.bgColor='#000000'; mm_menu_0227085749_0.menuBorder=1; mm_menu_0227085749_0.menuLiteBgColor='#000000'; mm_menu_0227085749_0.menuBorderBgColor='#000000'; window.mm_menu_0227090028_0 = new Menu("root",162,18,"Franklin Gothic Book",12,"#000000","#0000FF","#CCCCFF","#FFFFFF","left","middle",3,0,50,-5,7,true,true,true,0,true,true);
100
Universitas Sumatera Utara
mm_menu_0227090028_0.addMenuItem("TAMBAH USER","window.open('input_user.php', 'framehome');"); mm_menu_0227090028_0.addMenuItem("GANTI PASSWORD","window.open('ganti_password.php', 'framehome');"); mm_menu_0227090028_0.addMenuItem("CARI DATA USER","window.open('cari_user.php', 'framehome');"); mm_menu_0227090028_0.fontWeight="bold"; mm_menu_0227090028_0.hideOnMouseOut=true; mm_menu_0227090028_0.bgColor='#000000'; mm_menu_0227090028_0.menuBorder=1; mm_menu_0227090028_0.menuLiteBgColor='#000000'; mm_menu_0227090028_0.menuBorderBgColor='#000000'; window.mm_menu_0227090553_0 = new Menu("root",83,18,"Franklin Gothic Book",12,"#000000","#0000FF","#CCCCFF","#FFFFFF","left","middle",3,0,50,-5,7,true,true,true,0,true,true); mm_menu_0227090553_0.addMenuItem("New item"); mm_menu_0227090553_0.fontWeight="bold"; mm_menu_0227090553_0.hideOnMouseOut=true; mm_menu_0227090553_0.bgColor='#000000'; mm_menu_0227090553_0.menuBorder=1; mm_menu_0227090553_0.menuLiteBgColor='#000000'; mm_menu_0227090553_0.menuBorderBgColor='#000000'; window.mm_menu_0303005624_0 = new Menu("root",202,18,"Franklin Gothic Book",12,"#000000","#0000FF","#CCCCFF","#FFFFFF","left","middle",3,0,50,-5,7,true,true,true,0,true,true); mm_menu_0303005624_0.addMenuItem("INPUT MAHASISWA","window.open('input_mahasiswa.php', 'framehome');"); mm_menu_0303005624_0.addMenuItem("INPUT DOSEN/PEGAWAI","window.open('input_dosen.php', 'framehome');"); mm_menu_0303005624_0.fontWeight="bold"; mm_menu_0303005624_0.hideOnMouseOut=true; mm_menu_0303005624_0.bgColor='#000000'; mm_menu_0303005624_0.menuBorder=1; mm_menu_0303005624_0.menuLiteBgColor='#000000'; mm_menu_0303005624_0.menuBorderBgColor='#000000'; mm_menu_0303005624_0.writeMenus(); } // mmLoadMenus() //--> </script> <script language="JavaScript" src="mm_menu.js"></script> <link href="cssfont.css" rel="stylesheet" type="text/css"> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <style type="text/css"> <!-- font { font-family: "Franklin Gothic Book"; font-size: 13px; font-style: normal; line-height: normal;
101
Universitas Sumatera Utara
font-weight: normal; font-variant: normal; text-transform: none; } body { background-color: #CCCffC; margin-top: 10px; } a:link { color: #000000 ; } a:visited { color: #000000; } a:hover { color: #0000FF; } a:active { color: #0000FF; } a { text-decoration:none; } --> </style> </head> <body bgcolor="#CCCffC"> <script language="JavaScript1.2">mmLoadMenus();</script> <div align="center"> <table width="691" height="170" border="1" frame="box"> <tr> <td width="171" ><img src="image/Logo.jpg" width="171" height="160"></td> <td width="504"><img src="image/klinik1.jpg" width="520" height="160"></td> </tr> </table> </div> <div align="center"> <table width="706" border="1"> <tr> <td width="688" bgcolor="#CCCffC"><marquee> <font color="#9900FF" face="Times New Roman, Times, serif" size="4">MELAYANI KELUHAN AKADEMIKA UNIVERSITAS SUMATERA UTARA</font> </marquee></td> </tr> </table> </div> <div align="center">
102
Universitas Sumatera Utara
<table width="705" border="1"> <tr> <td width="84"><div align="center" class="spmk" ><a href="home_admin.php" target="framehome"><strong> HOME</strong></a></div></td> <td width="147" height="37"><div align="center" class="spmk" ><a href="#" name="link7" id="link8" onMouseOver="MM_showMenu(window.mm_menu_0303005624_0,0,18,null,'link7')" onMouseOut="MM_startTimeout();"> <strong>PENGUNJUNG</strong> </a> </div></td> <td width="116"><div align="center" class="spmk" ><a href="#" name="link3" id="link1" onMouseOver="MM_showMenu(window.mm_menu_0227084959_0,0,18,null,'link3')" onMouseOut="MM_startTimeout();"> <strong> KELUHAN</strong> </a></div></td> <td width="103"><div align="center" class="spmk" ><a href="#" name="link11" id="link2" onMouseOver="MM_showMenu(window.mm_menu_0227085749_0,0,18,null,'link11')" onMouseOut="MM_startTimeout();"> <strong>TINDAKAN</strong> </a></div> <div align="center"></div></td> <td width="65"><div align="center" class="spmk" ><a href="#" name="link5" id="link4" onMouseOver="MM_showMenu(window.mm_menu_0227090028_0,0,18,null,'link5')" onMouseOut="MM_startTimeout();"><strong> USER</strong> </a></div> <div align="center"></div></td> <td width="88"><div align="center" class="spmk" ><a href="lap_pengunjung.php" target="framehome"><strong> LAPORAN</strong> </a></div> <div align="center"></div></td> <td width="56"><div align="center" class="spmk" ><a href="help.php" target="framehome"><strong> HELP</strong> </a> </div></td> </tr> </table> </div> <table width="705" border="0" align="center"> <tr> <th align="right" bgcolor="#CCCffC" class="spmk" scope="row"> <a href="logout.php" onClick="<? echo "<script>alert('ANDA YAKIN AKAN KELUAR ');</script>"; ?>" class="style11"><strong>LogOut</strong></a></th> </tr> </table> <div align="center"> <iframe src="home_admin.php" name="framehome" width="735" height="1000" scrolling="no" frameborder="0" id="framehome" border="0"></iframe> </body> </html>
Lampiran 1.3 Program Spesifikasi Menu Admin
103
Universitas Sumatera Utara
4. List Program Menu Registrasi
Nama : Menu_Registrasi Tujuan : Menampilkan dan menjalankan aplikasi menu registrasi sesuai dengan login user Lokasi : Program : PHP dan Database MySQL Pseudocode <?php include"config.php"; ?> <html> <head> <title>SISTEM INFORMASI KLINIK TI UNIVERSITAS SUMATERA UTARA</title> <script language="JavaScript"> <!-- function mmLoadMenus() { if (window.mm_menu_0227084959_0) return; window.mm_menu_0227084959_0 = new Menu("root",195,18,"Franklin Gothic Book, Times, serif",12,"#000000","#0000FF","#CCCCFF","#FFFFFF","left","middle",3,0,50,-5,7,true,true,true,0,true,true); mm_menu_0227084959_0.addMenuItem("INPUT DATA KELUHAN","window.open('input_keluhann.php?user=<?php echo $_SESSION['username4'];?>', 'framehome');"); mm_menu_0227084959_0.fontWeight="bold"; mm_menu_0227084959_0.hideOnMouseOut=true; mm_menu_0227084959_0.bgColor='#000000'; mm_menu_0227084959_0.menuBorder=1; mm_menu_0227084959_0.menuLiteBgColor='#000000'; mm_menu_0227084959_0.menuBorderBgColor='#000000'; window.mm_menu_0227085749_0 = new Menu("root",83,18,"Franklin Gothic Book",12,"#000000","#0000FF","#CCCCFF","#FFFFFF","left","middle",3,0,50,-5,7,true,true,true,0,true,true); mm_menu_0227085749_0.addMenuItem("New item"); mm_menu_0227085749_0.fontWeight="bold"; mm_menu_0227085749_0.hideOnMouseOut=true; mm_menu_0227085749_0.bgColor='#000000'; mm_menu_0227085749_0.menuBorder=1; mm_menu_0227085749_0.menuLiteBgColor='#000000'; mm_menu_0227085749_0.menuBorderBgColor='#000000'; window.mm_menu_0227090028_0 = new Menu("root",162,18,"Franklin Gothic Book",12,"#000000","#0000FF","#CCCCFF","#FFFFFF","left","middle",3,0,50,-5,7,true,true,true,0,true,true); mm_menu_0227090028_0.addMenuItem("TAMBAH USER","window.open('input_user.php', 'framehome');"); mm_menu_0227090028_0.addMenuItem("GANTI PASSWORD","window.open('ganti_password.php', 'framehome');"); mm_menu_0227090028_0.addMenuItem("CARI DATA USER","window.open('cari_user.php', 'framehome');"); mm_menu_0227090028_0.fontWeight="bold"; mm_menu_0227090028_0.hideOnMouseOut=true;
104
Universitas Sumatera Utara
mm_menu_0227090028_0.bgColor='#000000'; mm_menu_0227090028_0.menuBorder=1; mm_menu_0227090028_0.menuLiteBgColor='#000000'; mm_menu_0227090028_0.menuBorderBgColor='#000000'; window.mm_menu_0227090553_0 = new Menu("root",206,18,"Franklin Gothic Book",12,"#000000","#0000FF","#CCCCFF","#FFFFFF","left","middle",3,0,50,-5,7,true,true,true,0,true,true); mm_menu_0227090553_0.addMenuItem("LAPORAN PENGUNJUNG","window.open('lap_pengunjung.php', 'framehome');"); mm_menu_0227090553_0.addMenuItem("LAPORAN KELUHAN","window.open('lap_keluhan.php', 'framehome');"); mm_menu_0227090553_0.addMenuItem("LAPORAN TINDAKAN","window.open('lap_tindakan.php', 'framehome');"); mm_menu_0227090553_0.fontWeight="bold"; mm_menu_0227090553_0.hideOnMouseOut=true; mm_menu_0227090553_0.bgColor='#000000'; mm_menu_0227090553_0.menuBorder=1; mm_menu_0227090553_0.menuLiteBgColor='#000000'; mm_menu_0227090553_0.menuBorderBgColor='#000000'; window.mm_menu_0303005624_0 = new Menu("root",202,18,"Franklin Gothic Book",12,"#000000","#0000FF","#CCCCFF","#FFFFFF","left","middle",3,0,50,-5,7,true,true,true,0,true,true); mm_menu_0303005624_0.addMenuItem("INPUT MAHASISWA","window.open('input_mahasiswa.php', 'framehome');"); mm_menu_0303005624_0.addMenuItem("INPUT DOSEN/PEGAWAI","window.open('input_dosen.php', 'framehome');"); mm_menu_0303005624_0.fontWeight="bold"; mm_menu_0303005624_0.hideOnMouseOut=true; mm_menu_0303005624_0.bgColor='#000000'; mm_menu_0303005624_0.menuBorder=1; mm_menu_0303005624_0.menuLiteBgColor='#000000'; mm_menu_0303005624_0.menuBorderBgColor='#000000'; mm_menu_0303005624_0.writeMenus(); } // mmLoadMenus() //--> </script> <script language="JavaScript" src="mm_menu.js"></script> <link href="cssfont.css" rel="stylesheet" type="text/css"> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <style type="text/css"> <!-- font { font-family: "Franklin Gothic Book"; font-size: 13px; font-style: normal; line-height: normal; font-weight: normal; font-variant: normal; text-transform: none; } body
105
Universitas Sumatera Utara
{ background-color: #CCCffC; margin-top: 10px; } a:link { color: #000000 ; } a:visited { color: #000000; } a:hover { color: #0000FF; } a:active { color: #0000FF; } a { text-decoration:none; } --> </style> </head> <body bgcolor="#CCCffC"> <script language="JavaScript1.2">mmLoadMenus(); </script> <div align="center"> <table width="691" height="170" border="1"> <tr> <td width="171" ><img src="image/Logo.jpg" width="171" height="160"></td> <td width="504"><img src="image/klinik1.jpg" width="520" height="160"></td> </tr> </table> </div> <div align="center"> <table width="706" border="1"> <tr> <td width="688" bgcolor="#CCCffC"><marquee> <font color="#9900FF" face="Times New Roman, Times, serif" size="4">MELAYANI KELUHAN AKADEMIKA UNIVERSITAS SUMATERA UTARA</font> </marquee></td> </tr> </table> </div> <div align="center"> <table width="705" border="1"> <tr> <td width="84"><div align="center" class="spmk" ><a href="home_admin.php" target="framehome"><strong> HOME</strong> </a></td> <td width="147" height="37"><div align="center" class="spmk" ><a href="#" name="link7"
106
Universitas Sumatera Utara
id="link8" onMouseOver="MM_showMenu(window.mm_menu_0303005624_0,0,18,null,'link7')" onMouseOut="MM_startTimeout();"> <strong>PENGUNJUNG</strong> </a> </div></td> <td width="123"><div align="center" class="spmk" ><a href="#" name="link3" id="link1" onMouseOver="MM_showMenu(window.mm_menu_0227084959_0,0,18,null,'link3')" onMouseOut="MM_startTimeout();"> <strong> KELUHAN</strong> </a></div></td> <div align="center"></div></td> <td width="56"><div align="center" class="spmk" ><a href="help.php" target="framehome"><strong> HELP</strong> </a> </div></td> </tr> </table> </div> <table width="705" border="0" align="center"> <tr> <th align="right" bgcolor="#CCCffC" class="spmk" scope="row"> <a href="logout.php" class="style11"><strong>LogOut</strong></a></th> </tr> </table> <div align="center"> <iframe src="home_admin.php" name="framehome" width="735" height="1000" scrolling="no" frameborder="0" id="framehome" border="0"></iframe> </body> </html>
Lampiran 1.4 Program Spesifikasi Menu Petugas Registrasi
5. List Program Menu Operator Pelayanan Akademik
Nama : Menu Operator Pelayanan Akademik Tujuan : Menampilkan dan menjalankan aplikasi menu Akademik sesuai dengan login user Lokasi : Tampilan Menu Admin dan Menu Petugas Registrasi Program : PHP dan Database MySQL Pseudocode <?php include"config.php"; ?> <html> <head> <title>SISTEM INFORMASI KLINIK TIU UNIVERSITAS SUMATERA UTARA</title> <script language="JavaScript"> <!-- function mmLoadMenus() { if (window.mm_menu_0227084959_0) return; window.mm_menu_0227084959_0 = new Menu("root",232,18,"Franklin Gothic Book, Times, serif",12,"#000000","#0000FF","#CCCCFF","#FFFFFF","left","middle",3,0,50,-5,7,true,true,true,0,true,true); mm_menu_0227084959_0.addMenuItem("INPUT DATA KELUHAN","window.open('input_keluhan.php', 'framehome');");
107
Universitas Sumatera Utara
mm_menu_0227084959_0.addMenuItem("INPUT KATEGORI KELUHAN","window.open('input_kategori.php', 'framehome');"); mm_menu_0227084959_0.fontWeight="bold"; mm_menu_0227084959_0.hideOnMouseOut=true; mm_menu_0227084959_0.bgColor='#000000'; mm_menu_0227084959_0.menuBorder=1; mm_menu_0227084959_0.menuLiteBgColor='#000000'; mm_menu_0227084959_0.menuBorderBgColor='#000000'; window.mm_menu_0227085749_0 = new Menu("root",172,18,"Franklin Gothic Book",12,"#000000","#0000FF","#CCCCFF","#FFFFFF","left","middle",3,0,50,-5,7,true,true,true,0,true,true); mm_menu_0227085749_0.addMenuItem("INPUT TINDAKAN","window.open('tindakan2.php?user=<?php echo $_SESSION['username2'];?>', 'framehome');"); mm_menu_0227085749_0.addMenuItem("DAFTAR TINDAKAN","window.open('cari_tindakan.php', 'framehome');"); mm_menu_0227085749_0.fontWeight="bold"; mm_menu_0227085749_0.hideOnMouseOut=true; mm_menu_0227085749_0.bgColor='#000000'; mm_menu_0227085749_0.menuBorder=1; mm_menu_0227085749_0.menuLiteBgColor='#000000'; mm_menu_0227085749_0.menuBorderBgColor='#000000'; window.mm_menu_0227090028_0 = new Menu("root",162,18,"Franklin Gothic Book",12,"#000000","#0000FF","#CCCCFF","#FFFFFF","left","middle",3,0,50,-5,7,true,true,true,0,true,true); mm_menu_0227090028_0.addMenuItem("TAMBAH USER","window.open('input_user.php', 'framehome');"); mm_menu_0227090028_0.addMenuItem("GANTI PASSWORD","window.open('ganti_password.php', 'framehome');"); mm_menu_0227090028_0.addMenuItem("CARI DATA USER","window.open('cari_user.php', 'framehome');"); mm_menu_0227090028_0.fontWeight="bold"; mm_menu_0227090028_0.hideOnMouseOut=true; mm_menu_0227090028_0.bgColor='#000000'; mm_menu_0227090028_0.menuBorder=1; mm_menu_0227090028_0.menuLiteBgColor='#000000'; mm_menu_0227090028_0.menuBorderBgColor='#000000'; window.mm_menu_0227090553_0 = new Menu("root",185,18,"Franklin Gothic Book",12,"#000000","#0000FF","#CCCCFF","#FFFFFF","left","middle",3,0,50,-5,7,true,true,true,0,true,true); mm_menu_0227090553_0.addMenuItem("LAPORAN TINDAKAN","window.open('lap_tindakan.php', 'framehome');"); mm_menu_0227090553_0.fontWeight="bold"; mm_menu_0227090553_0.hideOnMouseOut=true; mm_menu_0227090553_0.bgColor='#000000'; mm_menu_0227090553_0.menuBorder=1; mm_menu_0227090553_0.menuLiteBgColor='#000000'; mm_menu_0227090553_0.menuBorderBgColor='#000000'; window.mm_menu_0303005624_0 = new Menu("root",202,18,"Franklin Gothic
108
Universitas Sumatera Utara
Book",12,"#000000","#0000FF","#CCCCFF","#FFFFFF","left","middle",3,0,50,-5,7,true,true,true,0,true,true); mm_menu_0303005624_0.addMenuItem("INPUT MAHASISWA","window.open('input_mahasiswa.php', 'framehome');"); mm_menu_0303005624_0.addMenuItem("INPUT DOSEN/PEGAWAI","window.open('input_dosen.php', 'framehome');"); mm_menu_0303005624_0.fontWeight="bold"; mm_menu_0303005624_0.hideOnMouseOut=true; mm_menu_0303005624_0.bgColor='#000000'; mm_menu_0303005624_0.menuBorder=1; mm_menu_0303005624_0.menuLiteBgColor='#000000'; mm_menu_0303005624_0.menuBorderBgColor='#000000'; mm_menu_0303005624_0.writeMenus(); } // mmLoadMenus() //--> </script> <script language="JavaScript" src="mm_menu.js"></script> <link href="cssfont.css" rel="stylesheet" type="text/css"> <link href="Css/style.css" rel="stylesheet" type="text/css"> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <style type="text/css"> <!-- font { font-family: "Franklin Gothic Book"; font-size: 13px; font-style: normal; line-height: normal; font-weight: normal; font-variant: normal; text-transform: none; } body { background-color: #CCCffC; margin-top: 10px; } a:link { color: #000000 ; } a:visited { color: #000000; } a:hover { color: #0000FF; } a:active { color: #0000FF;
109
Universitas Sumatera Utara
} a { text-decoration:none; } --> </style> </head> <body bgcolor="#CCCffC"> <script language="JavaScript1.2">mmLoadMenus(); </script> <!-- <div id="menu"> <ul class="dropdown dropdown-horizontal"> <li class="first"><a href="indexadmin.php">Beranda</a></li> <li ><a href="v_adminc.php?kriteria=0">Admin</a></li> <li class="next">Admin <ul> <li class="dir"><a href="v_admin.php">View Data</a></li> <li class="dir"><a href="v_adminc.php?kriteria=0">Cari Data</a></li> <li class="dir"><a href="../admin/laporan/lap_admin.php">Report</a></li> </ul> </li> <li ><a href="v_pasienc.php?kriteria=0">Pasien</a></li> <li ><a href="v_dokterc.php?kriteria=0">Dokter</a></li> <li ><a href="v_obatc.php?kriteria=0">Obat</a></li> <li ><a href="v_penyakitc.php?kriteria=0">Penyakit</a></li> <li ><a href="../admin/eksekusi/p_logout.php" onClick="return confirm('Apakah Anda benar-benar akan keluar dari halaman Admin ?')">Log Out</a></ul> </div> --> <div align="center"> <table width="691" height="170" border="1"> <tr> <td width="171" ><img src="image/Logo.jpg" width="171" height="160"></td> <td width="504"><img src="image/klinik1.jpg" width="520" height="160"></td> </tr> </table> </div> <div align="center"> <table width="706" border="1"> <tr> <td width="688" bgcolor="#CCCffC"><marquee> <font color="#9900FF" face="Times New Roman, Times, serif" size="4">MELAYANI KELUHAN AKADEMIKA UNIVERSITAS SUMATERA UTARA</font> </marquee></td> </tr> </table> </div> <div align="center"> <table width="705" border="1"> <tr> <td width="163"><div align="center" class="spmk" > <div align="center"><a href="home_admin.php" target="framehome"><strong>
110
Universitas Sumatera Utara
HOME</strong> </a></div></td> <td width="358"><div align="center" class="spmk" ><a href="#" name="link1" id="link2" onMouseOver="MM_showMenu(window.mm_menu_0227085749_0,0,18,null,'link1')" onMouseOut="MM_startTimeout();"> <strong>TINDAKAN</strong> </a></div> <div align="center"></div></td> <td width="162"><div align="center" class="spmk" ><a href="help.php" target="framehome"><strong> HELP</strong> </a> </div></td> </tr> </table> </div> <table width="705" border="0" align="center"> <tr> <th align="right" bgcolor="#CCCffC" class="spmk" scope="row"> <a href="logout.php" class="style11"><strong>LogOut</strong></a></th> </tr> </table> <div align="center"> <iframe src="home_admin.php" name="framehome" width="735" height="1000" scrolling="no" frameborder="0" id="framehome" border="0"></iframe> </div> </body> </html>
Lampiran 1.5 Program Spesifikasi Menu Pelayanan Akademik
6. List Program Menu Pelayanan Teknisi
Nama : Menu Pelayanan Teknisi Tujuan : Menampilkan dan menjalankan aplikasi menu teknisi sesuai dengan login user Lokasi : Program : PHP dan Database MySQL Pseudocode <?php include"config.php"; ?> <html> <head> <title>SISTEM INFORMASI KLINIK TIU UNIVERSITAS SUMATERA UTARA</title> <script language="JavaScript"> <!-- function mmLoadMenus() { if (window.mm_menu_0227084959_0) return; window.mm_menu_0227084959_0 = new Menu("root",232,18,"Franklin Gothic Book, Times, serif",12,"#000000","#0000FF","#CCCCFF","#FFFFFF","left","middle",3,0,50,-5,7,true,true,true,0,true,true); mm_menu_0227084959_0.addMenuItem("INPUT DATA KELUHAN","window.open('input_keluhan.php', 'framehome');"); mm_menu_0227084959_0.addMenuItem("INPUT KATEGORI KELUHAN","win
111
Universitas Sumatera Utara
dow.open('input_kategori.php', 'framehome');"); mm_menu_0227084959_0.fontWeight="bold"; mm_menu_0227084959_0.hideOnMouseOut=true; mm_menu_0227084959_0.bgColor='#000000'; mm_menu_0227084959_0.menuBorder=1; mm_menu_0227084959_0.menuLiteBgColor='#000000'; mm_menu_0227084959_0.menuBorderBgColor='#000000'; window.mm_menu_0227085749_0 = new Menu("root",172,18,"Franklin Gothic Book",12,"#000000","#0000FF","#CCCCFF","#FFFFFF","left","middle",3,0,50,-5,7,true,true,true,0,true,true); mm_menu_0227085749_0.addMenuItem("INPUT TINDAKAN","window.open('tindakan3.php?user=<?php echo $_SESSION['username3'];?>', 'framehome');"); mm_menu_0227085749_0.addMenuItem("DAFTAR TINDAKAN","window.open('cari_tindakan.php', 'framehome');"); mm_menu_0227085749_0.fontWeight="bold"; mm_menu_0227085749_0.hideOnMouseOut=true; mm_menu_0227085749_0.bgColor='#000000'; mm_menu_0227085749_0.menuBorder=1; mm_menu_0227085749_0.menuLiteBgColor='#000000'; mm_menu_0227085749_0.menuBorderBgColor='#000000'; window.mm_menu_0227090028_0 = new Menu("root",162,18,"Franklin Gothic Book",12,"#000000","#0000FF","#CCCCFF","#FFFFFF","left","middle",3,0,50,-5,7,true,true,true,0,true,true); mm_menu_0227090028_0.addMenuItem("TAMBAH USER","window.open('input_user.php', 'framehome');"); mm_menu_0227090028_0.addMenuItem("GANTI PASSWORD","window.open('ganti_password.php', 'framehome');"); mm_menu_0227090028_0.addMenuItem("CARI DATA USER","window.open('cari_user.php', 'framehome');"); mm_menu_0227090028_0.fontWeight="bold"; mm_menu_0227090028_0.hideOnMouseOut=true; mm_menu_0227090028_0.bgColor='#000000'; mm_menu_0227090028_0.menuBorder=1; mm_menu_0227090028_0.menuLiteBgColor='#000000'; mm_menu_0227090028_0.menuBorderBgColor='#000000'; window.mm_menu_0227090553_0 = new Menu("root",185,18,"Franklin Gothic Book",12,"#000000","#0000FF","#CCCCFF","#FFFFFF","left","middle",3,0,50,-5,7,true,true,true,0,true,true); mm_menu_0227090553_0.addMenuItem("LAPORAN TINDAKAN","window.open('lap_tindakan.php', 'framehome');"); mm_menu_0227090553_0.fontWeight="bold"; mm_menu_0227090553_0.hideOnMouseOut=true; mm_menu_0227090553_0.bgColor='#000000'; mm_menu_0227090553_0.menuBorder=1; mm_menu_0227090553_0.menuLiteBgColor='#000000'; mm_menu_0227090553_0.menuBorderBgColor='#000000'; window.mm_menu_0303005624_0 = new Menu("root",202,18,"Franklin Gothic Book",12,"#000000","#0000FF","#CCCCFF","#FFFFFF","left","middle",3,0,50,-5,7,true,true,true,0,true,true);
112
Universitas Sumatera Utara
mm_menu_0303005624_0.addMenuItem("INPUT MAHASISWA","window.open('input_mahasiswa.php', 'framehome');"); mm_menu_0303005624_0.addMenuItem("INPUT DOSEN/PEGAWAI","window.open('input_dosen.php', 'framehome');"); mm_menu_0303005624_0.fontWeight="bold"; mm_menu_0303005624_0.hideOnMouseOut=true; mm_menu_0303005624_0.bgColor='#000000'; mm_menu_0303005624_0.menuBorder=1; mm_menu_0303005624_0.menuLiteBgColor='#000000'; mm_menu_0303005624_0.menuBorderBgColor='#000000'; mm_menu_0303005624_0.writeMenus(); } // mmLoadMenus() //--> </script> <script language="JavaScript" src="mm_menu.js"></script> <link href="cssfont.css" rel="stylesheet" type="text/css"> <link href="Css/style.css" rel="stylesheet" type="text/css"> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <style type="text/css"> <!-- font { font-family: "Franklin Gothic Book"; font-size: 13px; font-style: normal; line-height: normal; font-weight: normal; font-variant: normal; text-transform: none; } body { background-color: #CCCffC; margin-top: 10px; } a:link { color: #000000 ; } a:visited { color: #000000; } a:hover { color: #0000FF; } a:active { color: #0000FF; } a
113
Universitas Sumatera Utara
{ text-decoration:none; } --> </style> </head> <body bgcolor="#CCCffC"> <script language="JavaScript1.2">mmLoadMenus(); </script> <!-- <div id="menu"> <ul class="dropdown dropdown-horizontal"> <li class="first"><a href="indexadmin.php">Beranda</a></li> <li ><a href="v_adminc.php?kriteria=0">Admin</a></li> <li class="next">Admin <ul> <li class="dir"><a href="v_admin.php">View Data</a></li> <li class="dir"><a href="v_adminc.php?kriteria=0">Cari Data</a></li> <li class="dir"><a href="../admin/laporan/lap_admin.php">Report</a></li> </ul> </li> <li ><a href="v_pasienc.php?kriteria=0">Pasien</a></li> <li ><a href="v_dokterc.php?kriteria=0">Dokter</a></li> <li ><a href="v_obatc.php?kriteria=0">Obat</a></li> <li ><a href="v_penyakitc.php?kriteria=0">Penyakit</a></li> <li ><a href="../admin/eksekusi/p_logout.php" onClick="return confirm('Apakah Anda benar-benar akan keluar dari halaman Admin ?')">Log Out</a> </ul> </div> --> <div align="center"> <table width="691" height="170" border="1"> <tr> <td width="171" ><img src="image/Logo.jpg" width="171" height="160"></td> <td width="504"><img src="image/klinik1.jpg" width="520" height="160"></td> </tr> </table> </div> <div align="center"> <table width="706" border="1"> <tr> <td width="688" bgcolor="#CCCffC"><marquee> <font color="#9900FF" face="Times New Roman, Times, serif" size="4">MELAYANI KELUHAN AKADEMIKA UNIVERSITAS SUMATERA UTARA</font> </marquee></td> </tr> </table> </div> <div align="center"> <table width="705" border="1"> <tr> <td width="153"><div align="center" class="spmk" >
114
Universitas Sumatera Utara
<div align="center"><a href="home_admin.php" target="framehome"><strong> HOME</strong> </a></div></td> <td width="368"><div align="center" class="spmk" ><a href="#" name="link1" id="link2" onMouseOver="MM_showMenu(window.mm_menu_0227085749_0,0,18,null,'link1')" onMouseOut="MM_startTimeout();"> <strong>TINDAKAN</strong> </a></div> <div align="center"></div></td> <td width="162"><div align="center" class="spmk" ><a href="help.php" target="framehome"><strong> HELP</strong> </a> </div></td> </tr> </table> </div> <table width="705" border="0" align="center"> <tr> <th align="right" bgcolor="#CCCffC" class="spmk" scope="row"> <a href="logout.php" class="style11"><strong>LogOut</strong></a></th> </tr> </table> <div align="center"> <iframe src="home_admin.php" name="framehome" width="735" height="1000" scrolling="no" frameborder="0" id="framehome" border="0"></iframe> </div> </body> </html>
Lampiran 1.6 Program Spesifikasi Menu Form Pelayanan Teknisi
7. List Program Registrasi Mahasiswa
Nama : Registrasi_Mahasiswa Tujuan : Pendataan Identitas Mahasiswa Lokasi : Tampilan Menu Admin dan Menu Petugas Registrasi Program : PHP dan Database MySQL Pseudocode <?php include"config.php"; ?> <html> <head> <title>SISTEM INFORMASI KLINIK TI UNIVERSITAS SUMATERA UTARA</title> <script type="text/javascript"> function cek_data() { if (frmtindakan.keyword.value=="") {alert ("Maaf, Data tidak boleh kosong"); frmmhs.keyword.focus() return false } if (frmmhs.nama.value=="") {alert ("Maaf, Data tidak boleh kosong"); frmmhs.nama.focus() return false } return true
115
Universitas Sumatera Utara
} </script> <link href="cssfont.css" rel="stylesheet" type="text/css"> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><style type="text/css"> <!-- font {font-family: "Franklin Gothic Book"; font-size: 13px; font-style: normal; line-height: normal; font-weight: normal; font-variant: normal; text-transform: none; font-style:italic;} body { background-color: #CCCffC; margin-top: 10px;} .style1 { font-family: "Times New Roman", Times, serif; font-size: 9px; color: #FF0000; font-weight: bold;} .style2 {font-family: "Times New Roman", Times, serif} --> </style> </head> <body bgcolor="#CCCffC" onLoad="document.getElementById('keyword').focus()"> <form action="#" name="frmmhs" method="post"> <table width="705" height="303" align="center" frame="box" bordercolor="#000000"> <tr><td><div align="center"> <table border=0><tr><td height="98" colspan=3> <input name="search" type="submit" value="None" style="display:none"> <div align="center" class="tekshaldepan "><strong>PENDATAAN MAHASISWA</strong></div> <div align="center" class="graynote">(ISILAH NIM MAHASISWA PADA KOLOM KOSONG DIBAWAH INI)</div> <?php if( isset($_POST['search']) ) { if( $_POST['keyword'] != '' ) { $keyword = trim($_POST['keyword']); $databasename='sia'; $link=mysql_connect('localhost','root','') or die (mysql_error()); mysql_select_db($databasename,$link); $sql = "SELECT * FROM mhs WHERE nim LIKE '%" .$keyword. "%'"; $query = mysql_query($sql); $countData = mysql_num_rows($query); if( $countData > 0 ){ $data=0; while($data = mysql_fetch_array($query)) { $nim=$data['nim']; $nama=$data['nama']; $fakultas=$data['fakultas']; $jurusan=$data['jurusan']; $prodi=$data['prodi'];}} else {echo "<script>alert('DATA YANG DI INPUTKAN TIDAK DITEMUKAN ');</script>";}} else {echo "<script>alert('SILAHKAN MASUKKAN NIM YANG AKAN DICARI ');</script>";}} ?> <tr><td><span class="subproposal"><strong>NIM</strong></span></td> <td><span class="subproposal"><strong>:</td> <td> <input name="keyword" id="keyword" type="text" class="subproposal" size=35 value="<?php echo "$nim"; ?>"></td></tr> <tr><td><span class="subproposal"><strong>NAMA</strong></span></td> <td><span class="subproposal"><strong>:</strong></td> <td><input name="nama" id="nama" readonly="true" class="subproposal" type=text size=35
116
Universitas Sumatera Utara
value="<?php echo "$nama"; ?>"></td></tr> <tr><td><span class="subproposal"><strong>FAKULTAS</strong></span></td> <td><span class="subproposal"><strong>:</strong></td> <td><input name="fakultas" id="fakultas" readonly="true" class="subproposal" type=text size=35 value="<?php echo "$fakultas"; ?>"></td></tr> <tr><td><span class="subproposal"><strong>JURUSAN</strong></span></td> <td><span class="subproposal"><strong>:</strong></td> <td><input name="jurusan" id="jurusan" readonly="true" class="subproposal" type=text size=35 value="<?php echo "$jurusan"; ?>"></td></tr> <tr><td><span class="subproposal"><strong>PROGRAM STUDI</strong></span></td> <td><span class="subproposal"><strong>:</strong></td> <td><input name="prodi" id="prodi" readonly="true" class="subproposal" type=text size=35 value="<?php echo "$prodi"; ?>"></td></tr> <tr><td></td><td></td> <td colspan=3><input name="proses" class="subproposal" type="submit" onClick="return cek_data()" value="SIMPAN"> <input type="reset" class="subproposal" name="reset" value="BATAL"><td colspan=3></td></tr></table></div> <?php if($_POST['proses']){ $nim=$_POST['keyword']; $nama=$_POST['nama']; $fakultas=$_POST['fakultas']; $jurusan=$_POST['jurusan']; $prodi=$_POST['prodi']; $databasename='klinik_ti'; $link=mysql_connect('localhost','root','')or die (mysql_error()); mysql_select_db($databasename,$link); $sql="INSERT INTO pengunjung (nim_nip_niu, nama, fakultas, prodi, jurusan) VALUES ('$nim','$nama','$fakultas','$prodi','$jurusan')"; $query=mysql_query($sql); if($query) {echo "<script>alert('DATA YANG DI INPUT TELAH DISIMPAN ');</script>"; echo "<meta http-equiv=\"refresh\" content=\"0 url=./input_mahasiswa.php\">";} else {echo "<script>alert('MAAF, DATA TIDAK BISA DISIMPAN. PERIKSA KEMBALI DATA ANDA ');</script>"; echo "<meta http-equiv=\"refresh\" content=\"0 url=./input_mahasiswa.php\">";}} ?> </td></tr></table></div> <div align="center"><table width="705" frame="box" bordercolor="#000000" > <tr><td ><div align="center"><font color="#000000" size="4"><strong>DAFTAR PENGUNJUNG </strong></font><br></div></td></tr> <tr><td> <div align="center" style="border:0px solid white; width:690px; height:200px; overflow-y:scroll; overflow-x:scroll;"> <table width="1052" border="1" cellspacing="0" cellpadding="2" align="center"> <tr bgcolor="#FF0000"> <td width="50"><div align="center"><font size="3"><strong>NO</strong></font></div></td> <td width="100"><div align="center"><font size="3"><strong>NIM_NIP_NIU</strong></font></div></td> <td width="252"><div align="center"><font size="3"><strong>NAMA PENGUNJUNG</strong></font></div></td> <td width="150"><div align="center"><font
117
Universitas Sumatera Utara
size="3"><strong>FAKULTAS</strong></font></div></td> <td width="200"><div align="center"><font size="3"><strong>JURUSAN</strong></font></div></td> <td width="200"><div align="center"><font size="3"><strong>PROGRAM STUDI</strong></font></div></td> <td width="150"><div align="center"><font size="3"><strong>UNIT KERJA</strong></font></div></td> </tr> <?php $databasename='klinik_ti'; $link=mysql_connect('localhost','root','') or die (mysql_error()); mysql_select_db($databasename,$link); $sqlstr="SELECT * FROM pengunjung ORDER BY nim_nip_niu ASC"; $query=mysql_query($sqlstr); $no = 0; while ($row = mysql_fetch_row($query)){ $no++; ?> <tr bgcolor="#FFFFFF"> <td><div align="center"><font size="2" color="#000000"><?php echo $no; ?></font></div></td> <td><font size="2" color="#000000"><?php echo $row[0]; ?></font></td> <td><font size="2" color="#000000"><?php echo $row[1]; ?></font></td> <td><font size="2" color="#000000"><?php echo $row[2]; ?></font></td> <td><font size="2" color="#000000"><?php echo $row[3]; ?></font></td> <td><font size="2" color="#000000"><?php echo $row[4]; ?></font></td> <td><font size="2" color="#000000"><?php echo $row[5]; ?></font></td> </tr> <?php } ?> </table> </div> </td> </tr> </table> </div> </form> </body> </html>
Lampiran 1.7 Program Spesifikasi Pendataan Mahasiswa
118
Universitas Sumatera Utara
8. List Program Registrasi Dosen/Pegawai
Nama : Registrasi_Dosen/Pegawai Tujuan : Pendataan Identitas Dosen/Pegawai Lokasi : Tampilan Menu Admin dan Menu Petugas Registrasi Program : PHP dan Database MySQL Pseudocode <?php include"config.php"; ?> <html> <head> <title>SISTEM INFORMASI KLINIK TIU UNIVERSITAS SUMATERA UTARA</title> <script type="text/javascript"> function cek_data(){ if (frmdsn.keyword.value==""){ alert ("Maaf, Data tidak boleh kosong"); frmdsn.keyword.focus() return false } if (frmdsn.nama.value==""){ alert ("Maaf, Data tidak boleh kosong"); frmdsn.nama.focus() return false } return true } </script> <link href="cssfont.css" rel="stylesheet" type="text/css"> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><style type="text/css"> <!-- font {font-family: "Franklin Gothic Book"; font-size: 13px; font-style: normal; line-height: normal; font-weight: normal; font-variant: normal; text-transform: none; font-style:italic;} body { background-color: #CCCffC; margin-top: 10px; } .style1 {font-family: "Times New Roman", Times, serif} .style2 {font-size: 9px; font-family: "Times New Roman", Times, serif; color: #FF0000;} --> </style> </head> <body bgcolor="#CCCffC" onLoad="document.getElementById('keyword').focus()"> <form action="#" name="frmdsn" method="post"> <div align="center"> <table width="705" height="303" align="center" frame="box" bordercolor="#000000"> <tr><td> <div align="center"> <table border=0 align="center"> <tr><td colspan=3><input name="search" type="submit" value="None" style="display:none"> <div align="center" class="judul"><strong>PENDATAAN DOSEN/PEGAWAI</strong></div> <div align="center"class="graynote">(ISILAH NIP/NIU DOSEN/PEGAWAI PADA KOLOM KOSONG DIBAWAH INI)</div></td></tr> <?php if( isset($_POST['search']) ) { if( $_POST['keyword'] != '' ) { $keyword = trim($_POST['keyword']); $databasename='sipeg'; $link=mysql_connect('localhost','root','')or die (mysql_error()); mysql_select_db($databasename,$link);
119
Universitas Sumatera Utara
$sql = "SELECT * FROM pegawai WHERE nip LIKE '%" .$keyword. "%'"; $query = mysql_query($sql); $countData = mysql_num_rows($query); if( $countData > 0 ){ $data=0; while($data = mysql_fetch_array($query)) { $nim=$data['nip']; $nama=$data['nama']; $fakultas=$data['fakultas']; $jurusan=$data['jurusan']; $prodi=$data['prodi']; $unit=$data['unit'];}} else {echo "<script>alert('DATA YANG DI INPUTKAN TIDAK DITEMUKAN ');</script>";}} else {echo "<script>alert('SILAHKAN MASUKKAN NIM YANG AKAN DICARI ');</script>";}} ?> <tr><td><span class="subproposal"><strong>NIP</strong></span></td> <td><span class="subproposal"><strong>:</strong></td> <td> <input name="keyword" id="keyword" tabindex="0" class="subproposal" type="text" size=35 value="<?php echo "$nim"; ?>"></td></tr> <tr><td><span class="subproposal"><strong>NAMA</strong></span></td> <td><span class="subproposal"><strong>:</strong></td> <td><input name="nama" readonly="true" class="subproposal" type="text" size=35 value="<?php echo "$nama"; ?>"></td></tr> <tr><td><span class="subproposal"><strong>FAKULTAS</strong></span></td> <td><span class="subproposal"><strong>:</strong></td> <td><input name="fakultas" readonly="true" class="subproposal" type="text" size=35 value="<?php echo "$fakultas"; ?>"></td></tr> <tr><td><span class="subproposal"><strong>JURUSAN</strong></span></td> <td><span class="subproposal"><strong>:</strong></td> <td><input name="jurusan" readonly="true" class="subproposal" type="text" size=35 value="<?php echo "$jurusan"; ?>"></td></tr> <tr><td><span class="subproposal"><strong>PROGRAM STUDI</strong></span></td> <td><span class="subproposal"><strong>:</strong></td> <td><input name="prodi" readonly="true" class="subproposal" type="text" size=35 value="<?php echo "$prodi"; ?>"></td></tr> <tr><td><span class="subproposal"><strong>UNIT KERJA</strong></span></td> <td><span class="subproposal"><strong>:</strong></td> <td><input name="unit" readonly="true" class="subproposal" type="text" size=35 value="<?php echo "$unit"; ?>"></td></tr> <tr><td></td><td></td> <td colspan=3><input name="proses" class="subproposal" type="submit" onClick="return cek_data()" value="SIMPAN"> <input type="reset" class="subproposal" name="reset" value="BATAL"> <?php if($_POST['proses']){ $nim=$_POST['keyword']; $nama=$_POST['nama']; $fakultas=$_POST['fakultas']; $jurusan=$_POST['jurusan']; $prodi=$_POST['prodi']; $unit=$_POST['unit']; $databasename='klinik_ti'; $link=mysql_connect('localhost','root','') or die (mysql_error());
120
Universitas Sumatera Utara
mysql_select_db($databasename,$link); $sql="INSERT INTO pengunjung (nim_nip_niu, nama, fakultas, prodi, jurusan, unit) VALUES ('$nim','$nama','$fakultas','$prodi','$jurusan','$unit')"; $query=mysql_query($sql); if($query) {echo "<script>alert('DATA YANG DI INPUT TELAH DISIMPAN ');</script>"; echo "<meta http-equiv=\"refresh\" content=\"0 url=./input_dosen.php\">";} else {echo "<script>alert('MAAF, DATA YANG DIINPUT TIDAK BISA DISIMPAN. ADA KESAMAAN DATA ');</script>"; echo "<meta http-equiv=\"refresh\" content=\"0 url=./input_mahasiswa.php\">";}} ?> </td></tr></table></div> </td></tr> </table></div> <table width="705" frame="box" bordercolor="#000000" align="center" > <tr><td ><div align="center"><font color="#000000" size="4"><strong>DAFTAR PENGUNJUNG </strong></font><br></div></td></tr> <tr><td><div align="center" style="border:0px solid white; width:690px; height:200px; overflow-y:scroll; overflow-x:scroll;"> <table width="1052" border="1" cellspacing="0" cellpadding="2"> <tr bgcolor="#FF0000"> <td width="50"><div align="center"><font size="3"><strong>NO</strong></font></div></td> <td width="100"><div align="center"><font size="3"><strong>NIM_NIP_NIU</strong></font></div></td> <td width="252"><div align="center"><font size="3"><strong>NAMA PENGUNJUNG</strong></font></div></td> <td width="150"><div align="center"><font size="3"><strong>FAKULTAS</strong></font></div></td> <td width="200"><div align="center"><font size="3"><strong>JURUSAN</strong></font></div></td> <td width="200"><div align="center"><font size="3"><strong>PROGRAM STUDI</strong></font></div></td> <td width="150"><div align="center"><font size="3"><strong>UNIT KERJA</strong></font></div></td></tr> <?php $databasename='klinik_ti'; $link=mysql_connect('localhost','root','') or die (mysql_error()); mysql_select_db($databasename,$link); $sqlstr="SELECT * FROM pengunjung ORDER BY nim_nip_niu ASC"; $query=mysql_query($sqlstr); $no = 0; while ($row = mysql_fetch_row($query)){ $no++; ?> <tr bgcolor="#FFFFFF"> <td><div align="center"><font size="2" color="#000000"><?php echo $no; ?></font></td> <td><font size="2" color="#000000"><?php echo $row[0]; ?></font></td> <td><font size="2" color="#000000"><?php echo $row[1]; ?></font></td> <td><font size="2" color="#000000"><?php echo $row[2]; ?></font></td> <td><font size="2" color="#000000"><?php echo $row[3]; ?></font></td> <td><font size="2" color="#000000"><?php echo $row[4]; ?></font></td> <td><font size="2" color="#000000"><?php echo $row[5]; ?></font></td></tr> <?php } ?> </table>
121
Universitas Sumatera Utara
</div> </td> </tr> </table> </form> </body> </html>
Lampiran 1.8 Program Spesifikasi Pendataan Dosen/Pegawai
9. List Program Pendataan Keluhan untuk Menu Registrasi
Nama : Pendataan_Keluhan Tujuan : Menginputkan data keluhan dari pengunjung Lokasi : Tampilan Menu Petugas Registrasi Program : PHP dan Database MySQL Pseudocode <?php include"config.php"; ?> <html> <head> <title>SISTEM INFORMASI KLINIK TI UNIVERSITAS SUMATERA UTARA</title> <script type='text/javascript'> function createRequestObject() { var ro; var browser = navigator.appName; if(browser == "Microsoft Internet Explorer"){ ro = new ActiveXObject("Microsoft.XMLHTTP"); }else{ ro = new XMLHttpRequest(); } return ro; } var xmlhttp = createRequestObject(); function rubah(pilih) { var id_jenis = pilih.value; if (!id_jenis) return; xmlhttp.open('get', 'ambildata.php?id_jenis='+id_jenis, true); xmlhttp.onreadystatechange = function() { if ((xmlhttp.readyState==2) || (xmlhttp.readyState==3)) { document.getElementById("input").innerHTML="<img src='template/loading.gif'>"; return false; } if ((xmlhttp.readyState == 4) && (xmlhttp.status == 200)) document.getElementById("keluhan").innerHTML = xmlhttp.responseText; return false;
122
Universitas Sumatera Utara
} xmlhttp.send(null); } </script> <script type="text/javascript"> function cek_data() { if (frmkel.keyword.value=="") { alert ("Maaf, NIP tidak boleh kosong"); frmkel.keyword.focus() return false } return true } </script> <link href="cssfont.css" rel="stylesheet" type="text/css"> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><style type="text/css"> <!-- font {font-family: "Franklin Gothic Book"; font-size: 13px; font-style: normal; line-height: normal; font-weight: normal; font-variant: normal; text-transform: none; font-style:italic;} body { background-color: #CCCffC; margin-top: 10px;} --> </style> </head> <body bgcolor="#CCCffC"> <form action="#" method="post" name="frmkel" > <?php $user=$_GET['user'];?> <div align="center"> <table width="700" height="303" align="center" frame="box" bordercolor="#000000"> <tr> <td> <div align="center"> <table width="700" height="338" border="0"> <p align="center" class="judul"><strong><span>PENDATAAN KELUHAN PENGUNJUNG </strong></p> <p align="center"class="graynote">(ISILAH NIM/NIP/NIU PADA KOLOM KOSONG DIBAWAH INI)</p> <table border="0" align="center"> <tr><td width="154"><span class="subproposal"><strong>TANGGAL REGISTRASI</strong></span></td> <td width="16"><span class="subproposal"><strong><span>:</span></strong></td> <td width="231"><input name="tgl_registrasi" readonly="readonly" value="<?php print (date("Y-m-d(H:i:s)")); ?>" type="text" size="30"></td> </tr> <tr><td colspan=3><input name="search" type="submit" value="None" style="display:none"></td> <?php if( isset($_POST['search']) ) { if( $_POST['keyword'] != '' ) { $keyword = trim($_POST['keyword']); $databasename='klinik_ti'; $link=mysql_connect('localhost','root','') or die (mysql_error()); mysql_select_db($databasename,$link); $sql = "SELECT * FROM pengunjung WHERE nim_nip_niu LIKE '%" .$keyword. "%'"; $query = mysql_query($sql); $countData = mysql_num_rows($query); if( $countData > 0 ) {
123
Universitas Sumatera Utara
$data=0; while($data = mysql_fetch_array($query)) { $nim=$data['nim_nip_niu']; $nama=$data['nama']; $fakultas=$data['fakultas']; $jurusan=$data['jurusan']; $prodi=$data['prodi']; } } else {echo "<script>alert('DATA YANG DI INPUTKAN TIDAK DITEMUKAN ');</script>";} } else {echo "<script>alert('SILAHKAN MASUKKAN NIM YANG AKAN DICARI ');</script>";} } ?> <tr> <td><span class="subproposal"><strong>NIM/NIP/NIU</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td> <input name=keyword tabindex="0" type=text size=25 style="font-size:12px" value="<?php echo "$nim"; ?>"></td> </tr> <tr> <td><span class="subproposal"><strong>NAMA</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><input name=nama readonly="true" type=text size=40 style="font-size:12px" value="<?php echo "$nama"; ?>"></td> </tr> <tr> <td><span class="subproposal"><strong>FAKULTAS</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><input name=fakultas readonly="true" type=text size=25 style="font-size:12px" value="<?php echo "$fakultas"; ?>"></td> </tr> <tr> <td><span class="subproposal"><strong>JURUSAN</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><input name=jurusan readonly="true" type=text size=25 style="font-size:12px" value="<?php echo "$jurusan"; ?>"></td> </tr> <tr> <td><span class="subproposal"><strong>PROGRAM STUDI</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><input name=prodi readonly="true" type=text size=25 style="font-size:12px" value="<?php echo "$prodi"; ?>"></td> </tr> <tr> <td><span class="subproposal"><strong>JENIS LAYANAN </strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><select name="id_jenis" style="font-size:12px" onChange="javascript:rubah(this)"><option value=''>-JENIS KELUHAN-</option> <?php
124
Universitas Sumatera Utara
$pilih="SELECT * FROM jenis_keluhan"; $query=mysql_query($pilih); while($row=mysql_fetch_array($query)) {echo"<option value='$row[id_jenis]'>$row[jenis]</option>";} ?> </select></td> </tr> <tr> <td><span class="subproposal"><strong>KATEGORI KELUHAN </strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><select id="keluhan" style="font-size:12px" onChange="createNim(this.value)"></select></td> </tr> <tr> <td><span class="subproposal"><strong>KELUHAN</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><textarea name="keluhan" id="getNim" cols="35" rows="4"></textarea> <script> function createNim(val) { document.getElementById("getNim").value=val;} </script></td> </tr> <tr> <td><span class="subproposal"><strong>NAMA PETUGAS</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><input name=fakultas readonly="true" type=text size=25 style="font-size:12px" value="<?php echo $user;?>"></td> </tr> <tr> <td></td><td></td> <td><input name="proses" class="subproposal" type="submit" onClick="return cek_data()" value="SIMPAN"> <input type="reset" name="reset" value="BATAL"></td> <?php $today = date("Ymd"); $id = $_POST['id']; $jumlah = $_POST['jumlah']; $query = "SELECT max(id_keluhan) AS last FROM keluhan WHERE id_keluhan LIKE '$today%'"; $hasil = mysql_query($query); $data = mysql_fetch_array($hasil); $lastNoTransaksi = $data['last']; $lastNoUrut = substr($lastNoTransaksi, 8, 4); $nextNoUrut = $lastNoUrut + 1; $nextNoTransaksi = $today.sprintf('%04s', $nextNoUrut); $query = "INSERT INTO transaksi (idTransaksi, idMember, jumlah) VALUES ('$nextNoTransaksi', '$id', '$jumlah')"; $hasil = mysql_query($query); if($_POST['proses']){ $id_keluhan=$_POST['id_keluhan']; $tgl_registrasi=$_POST['tgl_registrasi']; $nim=$_POST['keyword']; $nama=$_POST['nama']; $id_jenis=$_POST['id_jenis'];
125
Universitas Sumatera Utara
$keluhan=$_POST['keluhan']; $databasename='klinik_ti'; $link=mysql_connect('localhost','root','') or die (mysql_error()); mysql_select_db($databasename,$link); $sql="INSERT INTO keluhan (id_keluhan, tgl_registrasi, nim_nip_niu, nama, id_jenis, keluhan) VALUES ('$nextNoTransaksi','$tgl_registrasi','$nim','$nama','$id_jenis','$keluhan')"; $query=mysql_query($sql); if($query) {echo "<script>alert('DATA YANG DI INPUT TELAH DISIMPAN ');</script>"; echo "<meta http-equiv=\"refresh\" content=\"0 url=./input_keluhan.php\">";} else{echo "<script>alert('MAAF, DATA YANG DIINPUT TIDAK BISA DISIMPAN. ADA KESAMAAN DATA ');</script>";}} ?> </tr></table> </div></th></table> <table width="705" frame="box" bordercolor="#000000" align="center" > <tr><td ><div align="center"><span class="judul"><strong>DAFTAR KELUHAN </strong><br></div></td></tr> <tr><td> <div align="center" style="border:0px solid white; width:690px; height:200px; overflow-y:scroll; overflow-x:scroll;"> <table width="1152" border="1" cellspacing="0" cellpadding="2"><tr bgcolor="#ff0000"> <td width="50"><div align="center"><span class="subproposal"><strong>NO</strong></span></div></td> <td width="150"><div align="center"><span class="subproposal"><strong>TANGGAL REGISTRASI</strong></span></div></td> <td width="150"><div align="center"><span class="subproposal"><strong>NIM_NIP_NIU</strong></span></div></td> <td width="200"><div align="center"><span class="subproposal"><strong>NAMA PENGUNJUNG</strong></span></div></td> <td width="150"><div align="center"><span class="subproposal"><strong>JENIS KELUHAN</strong></span></div></td> <td width="352"><div align="center"><span class="subproposal"><strong>KELUHAN</strong>></span></div></td></tr> <?php $databasename='klinik_ti'; $link=mysql_connect('localhost','root','') or die (mysql_error()); mysql_select_db($databasename,$link); $sqlstr="SELECT * FROM v_keluhan ORDER BY tgl_registrasi ASC"; $query=mysql_query($sqlstr); $no = 0; while ($row = mysql_fetch_row($query)){ $no++; ?> <tr bgcolor="#FFFFFF"> <td><div align="center"><font size="2" color="#00000"><?php echo $no; ?></font></td> <td><font size="2" color=""#000000""><?php echo $row[0]; ?></font></td> <td><font size="2" color=""#000000""><?php echo $row[1]; ?></font></td> <td><font size="2" color=""#000000""><?php echo $row[2]; ?></font></td> <td><font size="2" color=""#000000""><?php echo $row[5]; ?></font></td> <td><font size="2" color=""#000000""><?php echo $row[4]; ?></font></td> <?php } ?> </tr> </table> </div>
126
Universitas Sumatera Utara
</td> </tr> </table> </form> </body> </html>
Lampiran 1.9 Program Spesifikasi Penginputan Keluhan untuk Menu Registrasi
10. List Program Pendataan Keluhan untuk Menu Admin
Nama : Pendataan_Keluhan Tujuan : Menginputkan data keluhan dari pengunjung Lokasi : Tampilan Menu Admin Program : PHP dan Database MySQL Pseudocode <?php include"config.php"; ?> <html> <head> <title>SISTEM INFORMASI KLINIK TI UNIVERSITAS SUMATERA UTARA</title> <script type='text/javascript'> function createRequestObject() { var ro; var browser = navigator.appName; if(browser == "Microsoft Internet Explorer"){ ro = new ActiveXObject("Microsoft.XMLHTTP"); }else{ ro = new XMLHttpRequest(); } return ro; } var xmlhttp = createRequestObject(); function rubah(pilih) { var id_jenis = pilih.value; if (!id_jenis) return; xmlhttp.open('get', 'ambildata.php?id_jenis='+id_jenis, true); xmlhttp.onreadystatechange = function() { if ((xmlhttp.readyState==2) || (xmlhttp.readyState==3)) { document.getElementById("input").innerHTML="<img src='template/loading.gif'>"; return false; } if ((xmlhttp.readyState == 4) && (xmlhttp.status == 200)) document.getElementById("keluhan").innerHTML = xmlhttp.responseText; return false; } xmlhttp.send(null); }
127
Universitas Sumatera Utara
</script> <script type="text/javascript"> function cek_data() { if (frmkel.keyword.value=="") { alert ("Maaf, NIP tidak boleh kosong"); frmkel.keyword.focus() return false } return true } </script> <link href="cssfont.css" rel="stylesheet" type="text/css"> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><style type="text/css"> <!-- font {font-family: "Franklin Gothic Book"; font-size: 13px; font-style: normal; line-height: normal; font-weight: normal; font-variant: normal; text-transform: none; font-style:italic;} body { background-color: #CCCffC; margin-top: 10px;} --> </style> </head> <body bgcolor="#CCCffC"> <form action="#" method="post" name="frmkel" > <?php $user=$_GET['user'];?> <div align="center"> <table width="700" height="303" align="center" frame="box" bordercolor="#000000"> <tr> <td> <div align="center"> <table width="700" height="338" border="0"> <p align="center" class="judul"><strong><span>PENDATAAN KELUHAN PENGUNJUNG </strong></p> <p align="center"class="graynote">(ISILAH NIM/NIP/NIU PADA KOLOM KOSONG DIBAWAH INI)</p> <table border="0" align="center"> <tr><td width="154"><span class="subproposal"><strong>TANGGAL REGISTRASI</strong></span></td> <td width="16"><span class="subproposal"><strong><span>:</span></strong></td> <td width="231"><input name="tgl_registrasi" readonly="readonly" value="<?php print (date("Y-m-d(H:i:s)")); ?>" type="text" size="30"></td> </tr> <tr><td colspan=3><input name="search" type="submit" value="None" style="display:none"></td> <?php if( isset($_POST['search']) ) { if( $_POST['keyword'] != '' ) { $keyword = trim($_POST['keyword']); $databasename='klinik_ti'; $link=mysql_connect('localhost','root','') or die (mysql_error()); mysql_select_db($databasename,$link); $sql = "SELECT * FROM pengunjung WHERE nim_nip_niu LIKE '%" .$keyword. "%'"; $query = mysql_query($sql); $countData = mysql_num_rows($query); if( $countData > 0 ) { $data=0; while($data = mysql_fetch_array($query)) {
128
Universitas Sumatera Utara
$nim=$data['nim_nip_niu']; $nama=$data['nama']; $fakultas=$data['fakultas']; $jurusan=$data['jurusan']; $prodi=$data['prodi']; } } else {echo "<script>alert('DATA YANG DI INPUTKAN TIDAK DITEMUKAN ');</script>";} } else {echo "<script>alert('SILAHKAN MASUKKAN NIM YANG AKAN DICARI ');</script>";} } ?> <tr> <td><span class="subproposal"><strong>NIM/NIP/NIU</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td> <input name="keyword" tabindex="0" type="text" size=25 style="font-size:12px" value="<?php echo "$nim"; ?>"></td> </tr> <tr> <td><span class="subproposal"><strong>NAMA</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><input name="nama" readonly="true" type="text" size=40 style="font-size:12px" value="<?php echo "$nama"; ?>"></td> </tr> <tr> <td><span class="subproposal"><strong>FAKULTAS</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><input name="fakultas" readonly="true" type="text" size=25 style="font-size:12px" value="<?php echo "$fakultas"; ?>"></td> </tr> <tr> <td><span class="subproposal"><strong>JURUSAN</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><input name="jurusan" readonly="true" type="text" size=25 style="font-size:12px" value="<?php echo "$jurusan"; ?>"></td> </tr> <tr> <td><span class="subproposal"><strong>PROGRAM STUDI</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><input name="prodi" readonly="true" type="text" size=25 style="font-size:12px" value="<?php echo "$prodi"; ?>"></td> </tr> <tr> <td><span class="subproposal"><strong>JENIS LAYANAN </strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><select name="id_jenis" style="font-size:12px" onChange="javascript:rubah(this)"><option value=''>-JENIS KELUHAN-</option> <?php $pilih="SELECT * FROM jenis_keluhan"; $query=mysql_query($pilih);
129
Universitas Sumatera Utara
while($row=mysql_fetch_array($query)) {echo"<option value='$row[id_jenis]'>$row[jenis]</option>";} ?> </select></td> </tr> <tr> <td><span class="subproposal"><strong>KATEGORI KELUHAN </strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><select id="keluhan" style="font-size:12px" onChange="createNim(this.value)"></select></td> </tr> <tr> <td><span class="subproposal"><strong>KELUHAN</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><textarea name="keluhan" id="getNim" cols="35" rows="4"></textarea> <script> function createNim(val) { document.getElementById("getNim").value=val;} </script></td> </tr> <tr> <td><span class="subproposal"><strong>NAMA PETUGAS</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><input name="fakultas" readonly="true" type="text" size=25 style="font-size:12px" value="<?php echo $user;?>"></td> </tr> <tr> <td></td> <td></td> <td><input name="proses" class="subproposal" type="submit" onClick="return cek_data()" value="SIMPAN"> <input type="reset" name="reset" value="BATAL"></td> <?php $today = date("Ymd"); $id = $_POST['id']; $jumlah = $_POST['jumlah']; $query = "SELECT max(id_keluhan) AS last FROM keluhan WHERE id_keluhan LIKE '$today%'"; $hasil = mysql_query($query); $data = mysql_fetch_array($hasil); $lastNoTransaksi = $data['last']; $lastNoUrut = substr($lastNoTransaksi, 8, 4); $nextNoUrut = $lastNoUrut + 1; $nextNoTransaksi = $today.sprintf('%04s', $nextNoUrut); $query = "INSERT INTO transaksi (idTransaksi, idMember, jumlah) VALUES ('$nextNoTransaksi', '$id', '$jumlah')"; $hasil = mysql_query($query); if($_POST['proses']){ $id_keluhan=$_POST['id_keluhan']; $tgl_registrasi=$_POST['tgl_registrasi']; $nim=$_POST['keyword']; $nama=$_POST['nama']; $id_jenis=$_POST['id_jenis']; $keluhan=$_POST['keluhan'];
130
Universitas Sumatera Utara
$databasename='klinik_ti'; $link=mysql_connect('localhost','root','') or die (mysql_error()); mysql_select_db($databasename,$link); $sql="INSERT INTO keluhan (id_keluhan, tgl_registrasi, nim_nip_niu, nama, id_jenis, keluhan) VALUES ('$nextNoTransaksi','$tgl_registrasi','$nim','$nama','$id_jenis','$keluhan')"; $query=mysql_query($sql); if($query) {echo "<script>alert('DATA YANG DI INPUT TELAH DISIMPAN ');</script>"; echo "<meta http-equiv=\"refresh\" content=\"0 url=./input_keluhan.php\">";} else{echo "<script>alert('MAAF, DATA YANG DIINPUT TIDAK BISA DISIMPAN. ADA KESAMAAN DATA ');</script>";}} ?> </tr></table> </div></th></table> <table width="705" frame="box" bordercolor="#000000" align="center" > <tr><td ><div align="center"><span class="judul"><strong>DAFTAR KELUHAN </strong><br></div></td></tr> <tr><td> <div align="center" style="border:0px solid white; width:690px; height:200px; overflow-y:scroll; overflow-x:scroll;"> <table width="1152" border="1" cellspacing="0" cellpadding="2"><tr bgcolor="#ff0000"> <td width="50"><div align="center"><span class="subproposal"><strong>NO</strong></span></div></td> <td width="150"><div align="center"><span class="subproposal"><strong>TANGGAL REGISTRASI</strong></span></div></td> <td width="150"><div align="center"><span class="subproposal"><strong>NIM_NIP_NIU</strong></span></div></td> <td width="200"><div align="center"><span class="subproposal"><strong>NAMA PENGUNJUNG</strong></span></div></td> <td width="150"><div align="center"><span class="subproposal"><strong>JENIS KELUHAN</strong></span></div></td> <td width="352"><div align="center"><span class="subproposal"><strong>KELUHAN</strong>></span></div></td></tr> <?php $databasename='klinik_ti'; $link=mysql_connect('localhost','root','') or die (mysql_error()); mysql_select_db($databasename,$link); $sqlstr="SELECT * FROM v_keluhan ORDER BY tgl_registrasi ASC"; $query=mysql_query($sqlstr); $no = 0; while ($row = mysql_fetch_row($query)){ $no++; ?> <tr bgcolor="#FFFFFF"> <td><div align="center"><font size="2" color="#00000"><?php echo $no; ?></font></td> <td><font size="2" color=""#000000""><?php echo $row[0]; ?></font></td> <td><font size="2" color=""#000000""><?php echo $row[1]; ?></font></td> <td><font size="2" color=""#000000""><?php echo $row[2]; ?></font></td> <td><font size="2" color=""#000000""><?php echo $row[5]; ?></font></td> <td><font size="2" color=""#000000""><?php echo $row[4]; ?></font></td> <?php } ?> </tr> </table> </div> </td>
131
Universitas Sumatera Utara
</tr> </table> </form> </body> </html>
Lampiran 1.10 Program Spesifikasi Penginputan Keluhan untuk Menu Admin 11. List Program Kategori Keluhan
Nama : Input_Kategori Tujuan : Pemasukan data-data kategori keluhan yang lama dan baru Lokasi : Tampilan Menu Admin dan Menu Petugas Registrasi Program : PHP dan Database MySQL Pseudocode <?php include"config.php"; ?> <html> <head> <title>SISTEM INFORMASI KLINIK TI UNIVERSITAS SUMATERA UTARA</title> <script type="text/javascript"> function cek_data() { if (frmkategori.kategori.value=="") {alert ("Maaf, Data tidak boleh kosong"); frmkategori.kategori.focus() return false } return true } </script> <link href="cssfont.css" rel="stylesheet" type="text/css"> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><style type="text/css"> <!-- font {font-family: "Franklin Gothic Book"; font-size: 13px; font-style: normal; line-height: normal; font-weight: normal; font-variant: normal; text-transform: none; font-style:italic;} body {background-color: #CCCffC;margin-top: 10px;} --> </style> </head> <body bgcolor="#CCCffC"> <form action="#" method="post" name="frmkategori"> <table width="705" height="303" align="center" frame="box" bordercolor="#000000"> <tr><td> <div align="center" class="judul"><strong>PENDATAAN KETEGORI KELUHAN</strong></div> <div align="center" class="graynote"><strong>(ISILAH JENIS DAN KATEGORI KELUHAN PADA KOLOM KOSONG DIBAWAH INI)</strong></div> <p> </p>
132
133
Universitas Sumatera Utara
<table border="0" align="center"> <tr> <td><span class="subproposal"><strong>JENIS KELUHAN</strong></td> <td><span class="subproposal"><strong>:</strong></td> <td><select name="jenis" class="subproposal"> <option value="">-- SILAHKAN PILIH --</option> <option value="1">TEKNISI</option> <option value="2">AKADEMIS</option> </select> </td></tr> <tr> <td><span class="subproposal"><strong>KATEGORI KELUHAN</strong></td> <td><span class="subproposal"><strong>:</strong></td> <td><textarea name="kategori" class="subproposal" type="text" cols="40" rows="3"></textarea></td></tr> <tr><td></td><td></td> <td colspan=3><input name="proses" class="subproposal" onClick="return cek_data()" type="submit" value="SIMPAN"> <input type="reset" class="subproposal" name="reset" value="BATAL"></td></tr> <?php if($_POST['proses']){ $jenis=$_POST['jenis']; $kategori=$_POST['kategori']; $databasename='klinik_ti'; $link=mysql_connect('localhost','root','') or die (mysql_error()); mysql_select_db($databasename,$link); $sql="INSERT INTO kategori (id_jenis, kategori) VALUES ('$jenis','$kategori')"; $query=mysql_query($sql); if($query) {echo "<script>alert('DATA YANG DI INPUT TELAH DISIMPAN ');</script>"; echo "<meta http-equiv=\"refresh\" content=\"0 url=./input_kategori.php\">";} else {echo "<script>alert('MAAF, DATA YANG DIINPUT TIDAK BISA DISIMPAN. ADA KESAMAAN DATA ');</script>";}} ?> </table></td></tr></table> </form> </body> </html>
Lampiran 1.11 Program Spesifikasi Penginputan Kategori Keluhan
12. List Program Input Tindakan untuk Admin
134
Universitas Sumatera Utara
Nama : Input_Tindakan Tujuan : Pemasukan data-data hasil dari tindakan yang dikerjakan Operator Lokasi : Menu Admin Program : PHP dan Database MySQL Pseudocode <?php include"config.php"; include"class/class.php"; ?> <html> <head> <title>SISTEM INFORMASI KLINIK TI UNIVERSITAS SUMATERA UTARA</title> <script type="text/javascript"> function cek_data(){ if (frmtindakan.tindakan.value==""){ alert ("Maaf, Data tidak boleh kosong"); frmtindakan.tindakan.focus() return false } if (frmtindakan.select.value==""){ alert ("Maaf, Data tidak boleh kosong"); frmtindakan.select.focus() return false } return true } </script> <meta http-equiv=refresh content=5> <script language="JavaScript" src="mm_menu.js"></script> <link href="cssfont.css" rel="stylesheet" type="text/css"> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><style type="text/css"> <!-- body { background-color: #CCCffC; margin-top: 1px; } a:link { color: #000000; } a:visited { color: #000000; } a:hover { color: #00FF00; } a:active { color: #00FF00; } a { text-decoration:none; } --> </style></head> <body bgcolor="#CCCffC" onLoad="document.getElementById('keyword').focus()"> <form action="#" method="post" name="frmtindakan" > <?php $user=$_GET['user'];?>
135
Universitas Sumatera Utara
<script language="JavaScript1.2">mmLoadMenus();</script> <div align="center"> <table width="705" height="303" align="center" frame="box" bordercolor="#000000"> <tr> <td ><div align="center"><font color="#000000" size="4" face="Times New Roman, Times, serif"><strong>PENDATAAN TINDAKAN </strong></font><br></div></td> </tr> <tr> <td> <table width="100%" bgcolor="#CCCffC" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td width="45%"> <frame name="frametindak1" width="45%" height="10%" scrolling="auto" frameborder="0" id="frametindak1" border="0"> <div align="center"> <table border=1 cellpadding=0 cellspacing=0 bgcolor="#FFFFFF" > <tr> <th><strong><span class="judul">LIST ADMIN</span></strong></th> </tr> <tr> <th><span class="subproposal"><strong>NIM/NIP/NIU PENGUNJUNG</strong></span></th> </tr> <tr> <td align="center" valign="top"> <?php if($temp=="1"){temp($_GET['id'],$user,"id"); } else{update_temp($user,"id");} $link=koneksi_db(); $sqlstr="SELECT * FROM keluhan WHERE hasil='' and id_keluhan<>'$_GET[id]' ORDER BY `id_keluhan` DESC"; $query=mysql_query($sqlstr,$link); while($row=mysql_fetch_array($query)){ $aa= cek_id($row['id_keluhan'],"id"); if($aa==1){$tampil="";} if($aa==0){$tampil= "<tr><td> <a href=?user=$_GET[user]&aksi=edit&id=$row[0]&temp=1><span>$row[3]</span></a> </td></tr>";} echo $tampil; } echo "</table>"; if($_GET['aksi']=='edit'){ $aa= cek_id_lagi($_GET['id'],$user,"id"); if($aa==1){ $sqlstr="SELECT * FROM keluhan where id_keluhan='$_GET[id]'"; $query=mysql_query($sqlstr); $keluhan=mysql_fetch_array($query); } } ?> </strong> </span> </td> </iframe> <td>
136
Universitas Sumatera Utara
</td> </td> <td width="55%" valign="top"><frame name="frametindak2" width="55%" height="50%" frameborder="0" id="frametindak2" border="1"> <div align="left"> <table width="75%" height="138" border="0"> <th width="75%"> <table height="503" border="0"> <td width="97"><span class="subproposal"><strong>NIM/NIP/NIU</strong></span></td> <td width="3"><span class="subproposal"><strong>:</strong></span></td> <td width="350"> <input name="keyword" readonly="readonly" id="keyword" tabindex="0" type=text size=35 style="font-size:12px" value="<?php echo $keluhan['nim_nip_niu'];?>"></td> </tr> <tr> <td><span class="subproposal"><strong>NAMA</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><input name="nama" readonly="true" type=text size=35 style="font-size:12px" value="<?php echo $keluhan['nama'];?>"></td> </tr> <tr> <td><span class="subproposal"><strong>TANGGAL REGISTRASI</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><input name="tgl_reg" readonly="readonly" value="<?php echo $keluhan['tgl_registrasi'];?>" type="text" size="20"></td> </tr><tr> <td height="72"><span class="subproposal"><strong> KELUHAN</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td> <textarea name="keluhan" readonly="readonly" cols="35" rows="4"><?php echo $keluhan['keluhan'];?> </textarea></tr> <tr> <td><span class="subproposal"><strong> TINDAKAN</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><textarea name="tindakan" cols="35" rows="4"><?php echo $keluhan['tindakan'];?></textarea> </td> </tr> <tr> <td></td> </tr> <tr> <td><span class="subproposal"><strong>HASIL/STATUS</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><select name="select" > <option value="">-- SILAHKAN PILIH --</option> <option value="SELESAI">SELESAI</option> <option value="TIDAK SELESAI">TIDAK SELESAI</option> <option value="TUNDA/PENDING">TUNDA/PENDING</option> </select></td> </tr> <tr> <td><span class="subproposal"><strong>TANGGAL SELESAI</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><input name="tgl_sel" readonly="readonly" value="<?php print
137
Universitas Sumatera Utara
(date("Y-m-d")); ?>" type="text" size="20"></td> </tr> <tr> <td><span class="subproposal"><strong>TINDAK LANJUT</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><textarea name="tindak_lanjut" cols="35" rows="4"></textarea> </td> </tr> <tr> <td><span class="subproposal"><strong>PETUGAS OPERATOR</strong></span ></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><input name="nama_opt" readonly="readonly" id="nama_opt" type="text" size="30" value="<?php echo $user;?>"> </td> <td><input name="id_keluhan" type="hidden" value="<?php echo $keluhan['id_keluhan'];?>" size="30"> </td> </tr> <td></td> <td> </td> </tr> </table> <input name="proses" type="submit" onClick="return cek_data()" value="SIMPAN"> <?php if($_POST['proses']){ $id_keluhan=$_POST['id_keluhan']; $nim_nip_niu=$_POST['keyword']; $nama=$_POST['nama']; $tgl_reg=$_POST['tgl_reg']; $tgl_sel=$_POST['tgl_sel']; $keluhan=$_POST['keluhan']; $tindakan=$_POST['tindakan']; $hasil=$_POST['select']; $tindak_lanjut=$_POST['tindak_lanjut']; $nama_opt=$_POST['nama_opt']; $databasename='klinik_ti'; $link=mysql_connect('localhost','root','') or die (mysql_error()); mysql_select_db($databasename,$link); $sql="UPDATE keluhan SET nim_nip_niu='$nim_nip_niu', nama='$nama', tgl_registrasi='$tgl_reg', tgl2='$tgl_sel',keluhan='$keluhan', tindakan='$tindakan', hasil='$hasil', nama_opt='$nama_opt' where id_keluhan='$id_keluhan'"; $query=mysql_query($sql); if($query) { echo "<script>alert('DATA YANG DI INPUT TELAH DISIMPAN ');</script>"; echo "<meta http-equiv=\"refresh\" content=\"0 url=./tindakan.php?user=$user\">"; } else { echo "<script>alert('MAAF, Terjadi Kesalahan Dalam Penyimpanan Data, Data Tidak Boleh Kosong dan Harap Diisi Dengan Benar! ');</script>";} } ?> <input type="button" name="reset" value="BATAL" onClick="javascript:history.back()"></div> </th> </table> </div>
138
Universitas Sumatera Utara
</iframe></td> </tr> </table></td></tr> </table> </td></tr> <tr> <td><table width="100" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td><frame name="frametindak3" width="auto" height="auto" scrolling="no" frameborder="0" id="frametindak3" border="0"> <table width="705" frame="box" bordercolor="#000000" align="center" > <tr> <td ><div align="center"><font color="#000000" size="4" face="Times New Roman, Times, serif"><strong>HISTORY TINDAKAN TUNDA/PENDING </strong></font><br></div></td> </tr> <tr><td> <div align="center" style="border:0px solid white; width:690px; height:200px; overflow-y:scroll; overflow-x:scroll;"> <table width="1200" border=1 cellpadding=0 cellspacing=0 bgcolor="#FFFFFF" > <tr bgcolor="ff0000"><th width="70" class=subproposal>NIM/NIP/NIU</TH><th width="50" class=subproposal>TANGGAL REGISTRASI</th><TH width="400" class=subproposal>KELUHAN</TH><th width="350" class=subproposal>TINDAKAN</th><th width="50" class=subproposal>STATUS</th><th width"100" class=subproposal>PETUGAS</th> </tr> <tr> <td valign="top" headers="headers">
<?php if($temp=="1"){temp($_GET['id'],$user,"id_p"); } else{update_temp($user,"id_p");} $link=koneksi_db(); $sqlstr="SELECT * FROM keluhan WHERE hasil='TUNDA/PENDING' ORDER BY id_keluhan DESC"; $query=mysql_query($sqlstr,$link); while($row=mysql_fetch_array($query)){ $aa= cek_id($row['id_keluhan'],"id_p"); if($aa==1){$tampil="";} if($aa==0){$tampil= "<tr> <thclass=putih><ahref=?user=$_GET[user]&aksi=edit&id=$row[0]&temp=1><span>$row[3]</span></a></a></th> <th class=putih>$row[2]</th> <th class=putih>$row[1]</th> <th class=putih>$row[6]</th> <th class=putih>$row[8]</th> <th class=putih>$row[9]</th> </tr>"; } echo $tampil; }
echo "</table>"; if($_GET['aksi']=='edit'){ $aa= cek_id_lagi($_GET['id'],$user,"id_p"); if($aa==1){ $sqlstr="SELECT * FROM keluhan where id_keluhan='$_GET[id]'"; $query=mysql_query($sqlstr); $keluhan=mysql_fetch_array($query);
139
Universitas Sumatera Utara
} } ?> </strong> </span> </td> </iframe> </td></tr> </table></td> </tr> </table> <div align="center"></div> </form> </body> </html>
Lampiran 1.12 Program Spesifikasi Penginputan Tindakan untuk Menu Admin
13. List Program Input Tindakan untuk Pelayanan Akademik
Nama : Input_Tindakan Tujuan : Pemasukan data-data hasil dari tindakan yang dikerjakan Lokasi : Menu Pelayanan Akademik Program : PHP dan Database MySQL Pseudocode <?php include"config.php"; include"class/class.php"; ?> <html> <head> <title>SISTEM INFORMASI KLINIK TI UNIVERSITAS SUMATERA UTARA</title> <meta http-equiv=refresh content=5> <script language="JavaScript" src="mm_menu.js"></script> <link href="cssfont.css" rel="stylesheet" type="text/css"> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><style type="text/css"> <!-- body { background-color: #CCCffC; margin-top: 1px; } a:link { color: #000000; } a:visited { color: #000000; } a:hover { color: #00FF00; }
140
Universitas Sumatera Utara
a:active { color: #00FF00; } a { text-decoration:none; } --> </style></head> <body bgcolor="#CCCffC" onLoad="document.getElementById('keyword').focus()"> <form action="#" method="post" > <script language="JavaScript1.2">mmLoadMenus();</script> <div align="center"> <table width="705" height="303" align="center" frame="box" bordercolor="#000000"> <tr> <td ><div align="center"><font color="#000000" size="4" face="Times New Roman, Times, serif"><strong>PENDATAAN TINDAKAN </strong></font><br></div></td> </tr> <tr> <td> <table width="100%" bgcolor="#CCCffC" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td width="45%"> <frame name="frametindak1" width="45%" height="10%" scrolling="auto" frameborder="0" id="frametindak1" border="0"> <div align="center"> <table border=1 cellpadding=0 cellspacing=0 bgcolor="#FFFFFF" > <tr> <th><strong><span class="judul">LIST ADMIN</span></strong></th> </tr> <tr> <th><span class="subproposal"><strong>NIM/NIP/NIU PENGUNJUNG</strong></span></th> </tr> <tr> <td align="center" valign="top"> <?php $user=$_GET['user']; if($temp=="1"){temp($_GET['id'],$user,"id"); } else{update_temp($user,"id");} $link=koneksi_db(); $sqlstr="SELECT * FROM keluhan WHERE hasil='' and id_keluhan<>'$_GET[id]' and id_jenis='2' ORDER BY `id_keluhan` DESC"; $query=mysql_query($sqlstr,$link); while($row=mysql_fetch_array($query)){ $aa= cek_id($row['id_keluhan'],"id"); if($aa==1){$tampil="";} if($aa==0){$tampil= "<tr><td> <a href=?user=$_GET[user]&aksi=edit&id=$row[0]&temp=1><span>$row[3]</span></a> </td></tr>";} echo $tampil; }
141
Universitas Sumatera Utara
echo "</table>"; if($_GET['aksi']=='edit'){ $aa= cek_id_lagi($_GET['id'],$user,"id"); if($aa==1){ $sqlstr="SELECT * FROM keluhan where id_keluhan='$_GET[id]'"; $query=mysql_query($sqlstr); $keluhan=mysql_fetch_array($query); } } ?> </strong> </span> </td> </iframe> <td> </td> </td> <td width="55%" valign="top"><frame name="frametindak2" width="55%" height="50%" frameborder="0" id="frametindak2" border="1"> <div align="left"> <table width="75%" height="138" border="0"> <th width="75%"> <table height="503" border="0"> <td width="97"><span class="subproposal"><strong>NIM/NIP/NIU</strong></span></td> <td width="3"><span class="subproposal"><strong>:</strong></span></td> <td width="350"> <input name="keyword" readonly="readonly" id="keyword" tabindex="0" type="text" size=35 style="font-size:12px" value="<?php echo $keluhan['nim_nip_niu'];?>"></td> </tr> <tr> <td><span class="subproposal"><strong>NAMA</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><input name="nama" readonly="true" type="text" size=35 style="font-size:12px" value="<?php echo $keluhan['nama'];?>"></td> </tr> <tr> <td><span class="subproposal"><strong>TANGGAL REGISTRASI</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><input name="tgl_reg" readonly="readonly" value="<?php echo $keluhan['tgl_registrasi'];?>" type="text" size="20"></td> </tr> <tr> <td height="72"><span class="subproposal"><strong> KELUHAN</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td> <textarea name="keluhan" readonly="readonly" cols="35" rows="4"><?php echo $keluhan['keluhan'];?> </textarea> </tr> <tr> <td><span class="subproposal"><strong> TINDAKAN</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><textarea name="tindakan" cols="35" rows="4"><?php echo $keluhan['tindakan'];?></textarea> </td> </tr> <tr>
142
Universitas Sumatera Utara
<td></td> </tr> <tr> <td><span class="subproposal"><strong>HASIL/STATUS</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><select name="select" ><option value="">-- SILAHKAN PILIH --</option> <option value="SELESAI">SELESAI</option> <option value="TIDAK SELESAI">TIDAK SELESAI</option> <option value="TUNDA/PENDING">TUNDA/PENDING</option> </select></td> </tr> <tr> <td><span class="subproposal"><strong>TANGGAL SELESAI</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><input name="tgl_sel" readonly="readonly" value="<?php print (date("Y-m-d (H:i:s)")); ?>" type="text" size="20"></td> </tr> <tr> <td><span class="subproposal"><strong>TINDAK LANJUT</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><textarea name="tindak_lanjut" cols="35" rows="4"></textarea> </td> </tr> <tr> <td><span class="subproposal"><strong>PETUGAS OPERATOR</strong></span ></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><input name="nama_opt" readonly="readonly" id="nama_opt" type="text" size="30" value="<?php echo $user;?>"> </td> <td><input name="id_keluhan" type="hidden" value="<?php echo $keluhan['id_keluhan'];?>" size="30"> </td> </tr> <td></td> <td> </td> </tr> </table> </form> <input name="proses" type="submit" value="SIMPAN"> <?php if($_POST['proses']){ $id_keluhan=$_POST['id_keluhan']; $nim_nip_niu=$_POST['keyword']; $nama=$_POST['nama']; $tgl_reg=$_POST['tgl_reg']; $tgl_sel=$_POST['tgl_sel']; $keluhan=$_POST['keluhan']; $tindakan=$_POST['tindakan']; $hasil=$_POST['select']; $tindak_lanjut=$_POST['tindak_lanjut']; $nama_opt=$_POST['nama_opt']; $databasename='klinik_ti';
143
Universitas Sumatera Utara
$link=mysql_connect('localhost','root','') or die (mysql_error()); mysql_select_db($databasename,$link); $sql="UPDATE keluhan SET nim_nip_niu='$nim_nip_niu', nama='$nama', tgl_registrasi='$tgl_reg', tgl2='$tgl_sel',keluhan='$keluhan', tindakan='$tindakan', hasil='$hasil', nama_opt='$nama_opt' where id_keluhan='$id_keluhan'"; $query=mysql_query($sql); if($query) { echo "<script>alert('DATA YANG DI INPUT TELAH DISIMPAN ');</script>"; echo "<meta http-equiv=\"refresh\" content=\"0 url=./tindakan3.php?user=$user\">"; } else { echo "<script>alert('MAAF, DATA YANG DIINPUT TIDAK BISA DISIMPAN. ADA KESAMAAN DATA ');</script>"; } } ?> <input type="button" name="reset" value="BATAL" onClick="javascript:history.back()"> <form></div> </th> </table> </div> </iframe></td> </tr> </table></td> </tr> </table> </td> </tr> <tr> <td><table width="100" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td><frame name="frametindak3" width="auto" height="auto" scrolling="no" frameborder="0" id="frametindak3" border="0"> <table width="705" frame="box" bordercolor="#000000" align="center" > <tr> <td ><div align="center"><font color="#000000" size="4" face="Times New Roman, Times, serif"><strong>HISTORY TINDAKAN TUNDA/PENDING </strong></font><br></div></td> </tr> <tr> <td> <div align="center" style="border:0px solid white; width:690px; height:200px; overflow-y:scroll; overflow-x:scroll;"> <table width="1200" border=1 cellpadding=0 cellspacing=0 bgcolor="#FFFFFF" > <tr bgcolor="ff0000"> <th width="70" class=subproposal>NIM/NIP/NIU</TH><th width="50" class=subproposal>TANGGAL REGISTRASI</th><TH width="400" class=subproposal>KELUHAN</TH><th width="350" class=subproposal>TINDAKAN</th><th width="50" class=subproposal>STATUS</th><th width"100" class=subproposal>PETUGAS</th> </tr> <tr> <td valign="top" headers="headers">
144
Universitas Sumatera Utara
<?php if($temp=="1"){temp($_GET['id'],$user,"id_p"); } else{update_temp($user,"id_p");} $link=koneksi_db(); $sqlstr="SELECT * FROM keluhan WHERE hasil='TUNDA/PENDING' and id_jenis='2' ORDER BY id_keluhan DESC"; $query=mysql_query($sqlstr,$link); while($row=mysql_fetch_array($query)){ $aa= cek_id($row['id_keluhan'],"id_p"); if($aa==1){$tampil="";} if($aa==0){$tampil= "<tr> <thclass=putih><ahref=?user=$_GET[user]&aksi=edit&id=$row[0]&temp=1><span>$row[3]</span></a></a></th> <th class=putih>$row[2]</th> <th class=putih>$row[1]</th> <th class=putih>$row[6]</th> <th class=putih>$row[8]</th> <th class=putih>$row[9]</th> </tr>"; } echo $tampil; } echo "</table>"; if($_GET['aksi']=='edit'){ $aa= cek_id_lagi($_GET['id'],$user,"id_p"); if($aa==1){ $sqlstr="SELECT * FROM keluhan where id_keluhan='$_GET[id]'"; $query=mysql_query($sqlstr); $keluhan=mysql_fetch_array($query); } } ?> </strong> </span> </td> </iframe> </td> </tr> </table></td> </tr> </table> <div align="center"></div> </body> </html>
Lampiran 1.13 Program Spesifikasi Penginputan Tindakan untuk Menu Akademik 14. List Program Input Tindakan untuk Pelayanan Teknisi
145
Universitas Sumatera Utara
Nama : Input_Tindakan Tujuan : Pemasukan data-data hasil dari tindakan yang dikerjakan Lokasi : Menu Pelayanan Teknisi Program : PHP dan Database MySQL Pseudocode <?php include"config.php"; include"class/class.php"; ?> <html> <head> <title>SISTEM INFORMASI KLINIK TI UNIVERSITAS SUMATERA UTARA</title> <?php $testid=$_GET['id']; echo "<meta http-equiv=\"refresh\" content=\"5 \">";?> <!-- <meta http-equiv=refresh content=10;url=tindakan2.php> --> <script language="JavaScript" src="mm_menu.js"></script> <link href="cssfont.css" rel="stylesheet" type="text/css"> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><style type="text/css"> <!-- body { background-color: #CCCffC; margin-top: 1px; } a:link { color: #000000; } a:visited { color: #000000; } a:hover { color: #00FF00; } a:active { color: #00FF00; } a { text-decoration:none; } --> </style></head> <body bgcolor="#CCCffC" onLoad="document.getElementById('keyword').focus()"> <form action="#" method="post" > <?php $user=$_GET['user'];?> <script language="JavaScript1.2">mmLoadMenus();</script> <div align="center"> <table width="705" height="303" align="center" frame="box" bordercolor="#000000"> <tr> <td ><div align="center"><font color="#000000" size="4" face="Times New Roman, Times, serif"><strong>PENDATAAN TINDAKAN </strong></font><br></div></td> </tr> <tr> <td> <table width="100%" bgcolor="#CCCffC" border="0" align="center" cellpadding="0"
146
Universitas Sumatera Utara
cellspacing="0"> <tr> <td width="45%"> <frame name="frametindak1" width="45%" height="10%" scrolling="auto" frameborder="0" id="frametindak1" border="0"> <div align="center"> <table border=1 cellpadding=0 cellspacing=0 bgcolor="#FFFFFF" > <tr> <th><strong><span class="judul">LIST ADMIN</span></strong></th> </tr> <tr> <th><span class="subproposal"><strong>NIM/NIP/NIU PENGUNJUNG</strong></span></th> </tr> <tr> <td align="center" valign="top"> <?php if($temp=="1"){temp($_GET['id'],$user,"id"); } else{update_temp($user,"id");} $link=koneksi_db(); $sqlstr="SELECT * FROM keluhan WHERE hasil='' and id_keluhan<>'$_GET[id]' and id_jenis='1' ORDER BY `id_keluhan` DESC"; $query=mysql_query($sqlstr,$link); while($row=mysql_fetch_array($query)){ $aa= cek_id($row['id_keluhan'],"id"); if($aa==1){$tampil="";} if($aa==0){$tampil= "<tr><td> <a href=?user=$_GET[user]&aksi=edit&id=$row[0]&temp=1><span>$row[3]</span></a> </td></tr>";} echo $tampil; } echo "</table>"; if($_GET['aksi']=='edit'){ $aa= cek_id_lagi($_GET['id'],$user,"id"); if($aa==1){ $sqlstr="SELECT * FROM keluhan where id_keluhan='$_GET[id]'"; $query=mysql_query($sqlstr); $keluhan=mysql_fetch_array($query); } } ?> </strong> </span> </td> </iframe> <td> </td></td> <td width="55%" valign="top"><frame name="frametindak2" width="55%" height="50%" frameborder="0" id="frametindak2" border="1"> <div align="left"> <table width="75%" height="138" border="0">
147
Universitas Sumatera Utara
<th width="75%"> <table height="503" border="0"> <td width="97"><span class="subproposal"><strong>NIM/NIP/NIU</strong></span></td> <td width="3"><span class="subproposal"><strong>:</strong></span></td> <td width="350"> <input name="keyword" readonly="readonly" id="keyword" tabindex="0" type="text" size=35 style="font-size:12px" value="<?php echo $keluhan['nim_nip_niu'];?>"></td> </tr> <tr> <td><span class="subproposal"><strong>NAMA</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><input name="nama" readonly="true" type="text" size=35 style="font-size:12px" value="<?php echo $keluhan['nama'];?>"></td> </tr> <tr> <td><span class="subproposal"><strong>TANGGAL REGISTRASI</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><input name="tgl_reg" readonly="readonly" value="<?php echo $keluhan['tgl_registrasi'];?>" type="text" size="20"></td> </tr> <tr> <td height="72"><span class="subproposal"><strong> KELUHAN</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td> <textarea name="keluhan" readonly="readonly" cols="35" rows="4"><?php echo $keluhan['keluhan'];?> </textarea></tr> <tr> <td><span class="subproposal"><strong> TINDAKAN</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><textarea name="tindakan" cols="35" rows="4"><?php echo $keluhan['tindakan'];?></textarea> </td> </tr> <tr> <td></td>
</tr> <tr> <td><span class="subproposal"><strong>HASIL/STATUS</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><select name="select" > <option value="">-- SILAHKAN PILIH --</option> <option value="SELESAI">SELESAI</option> <option value="TIDAK SELESAI">TIDAK SELESAI</option> <option value="TUNDA/PENDING">TUNDA/PENDING</option> </select></td> </tr><tr> <td><span class="subproposal"><strong>TANGGAL SELESAI</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><input name="tgl_sel" readonly="readonly" value="<?php print (date("Y-m-d (H:i:s)")); ?>" type="text" size="20"></td> </tr> <tr> <td><span class="subproposal"><strong>TINDAK LANJUT</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><textarea name="tindak_lanjut" cols="35" rows="4"></textarea> </td>
148
Universitas Sumatera Utara
</tr> <tr> <td><span class="subproposal"><strong>PETUGAS OPERATOR</strong></span ></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><input name="nama_opt" readonly="readonly" id="nama_opt" type="text" size="30" value="<?php echo $user;?>"> </td> <td><input name="id_keluhan" type="hidden" value="<?php echo $keluhan['id_keluhan'];?>" size="30"> </td> </tr> <td></td> <td> </td> </tr> </table> </form> <input name="proses" type="submit" value="SIMPAN"> <?php if($_POST['proses']){ $id_keluhan=$_POST['id_keluhan']; $nim_nip_niu=$_POST['keyword']; $nama=$_POST['nama']; $tgl_reg=$_POST['tgl_reg']; $tgl_sel=$_POST['tgl_sel']; $keluhan=$_POST['keluhan']; $tindakan=$_POST['tindakan']; $hasil=$_POST['select']; $tindak_lanjut=$_POST['tindak_lanjut']; $nama_opt=$_POST['nama_opt']; $databasename='klinik_ti'; $link=koneksi_db(); $sql="UPDATE keluhan SET nim_nip_niu='$nim_nip_niu', nama='$nama', tgl_registrasi='$tgl_reg', tgl2='$tgl_sel',keluhan='$keluhan', tindakan='$tindakan', hasil='$hasil', nama_opt='$nama_opt' where id_keluhan='$id_keluhan'"; echo $sql; $query=mysql_query($sql,$link); if($query) { echo "<script>alert('DATA YANG DI INPUT TELAH DISIMPAN ');</script>"; echo "<meta http-equiv=\"refresh\" content=\"0 url=./tindakan2.php?user=$user\">"; } else { echo "<script>alert('MAAF, TERJADI KESALAHAN DALAM PENYIMPANAN DATA ');</script>"; } } ?> <input type="button" name="reset" value="BATAL" onClick="javascript:history.back()"> <form></div> </th> </table> </div> </iframe></td></tr> </table></td></tr>
149
Universitas Sumatera Utara
</table></td></tr><tr> <td><table width="100" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td><frame name="frametindak3" width="auto" height="auto" scrolling="no" frameborder="0" id="frametindak3" border="0"> <table width="705" frame="box" bordercolor="#000000" align="center" > <tr><td ><div align="center"><font color="#000000" size="4" face="Times New Roman, Times, serif"><strong>HISTORY TINDAKAN TUNDA/PENDING </strong></font><br></div></td> </tr><tr><td> <div align="center" style="border:0px solid white; width:690px; height:200px; overflow-y:scroll; overflow-x:scroll;"> <table width="1200" border=1 cellpadding=0 cellspacing=0 bgcolor="#FFFFFF" > <tr bgcolor="ff0000"> <th width="70" class=subproposal>NIM/NIP/NIU</TH><th width="50" class=subproposal>TANGGAL REGISTRASI</th><TH width="400" class=subproposal>KELUHAN</TH><th width="350" class=subproposal>TINDAKAN</th><th width="50" class=subproposal>STATUS</th><th width"100" class=subproposal>PETUGAS</th> </tr><tr><td valign="top" headers="headers"> <?php if($temp=="1"){temp($_GET['id'],$user,"id_p"); } else{update_temp($user,"id_p");} $link=koneksi_db(); $sqlstr="SELECT * FROM keluhan WHERE hasil='TUNDA/PENDING' ORDER BY id_keluhan DESC"; $query=mysql_query($sqlstr,$link); while($row=mysql_fetch_array($query)){ $aa= cek_id($row['id_keluhan'],"id_p"); if($aa==1){$tampil="";} if($aa==0){$tampil= "<tr> <thclass=putih><ahref=?user=$_GET[user]&aksi=edit&id=$row[0]&temp=1><span>$row[3]</span></a></a></th><th class=putih>$row[2]</th> <th class=putih>$row[1]</th> <th class=putih>$row[6]</th> <th class=putih>$row[8]</th> <th class=putih>$row[9]</th></tr>"; } echo $tampil; } echo "</table>"; if($_GET['aksi']=='edit'){$aa= cek_id_lagi($_GET['id'],$user,"id_p"); if($aa==1){$sqlstr="SELECT * FROM keluhan where id_keluhan='$_GET[id]'";
$query=mysql_query($sqlstr); $keluhan=mysql_fetch_array($query); } } ?> </strong> </span> </td> </iframe>
</td> </tr> </table></td> </tr>
150
Universitas Sumatera Utara
</table> <div align="center"></div> </body> </html>
Lampiran 1.14 Program Spesifikasi Penginputan Tindakan untuk Menu Teknisi
15. List Program Daftar Tindakan
Nama : Daftar_Tindakan Tujuan : Untuk Menampilkan hasil data Tindakan yang selesai Lokasi : Menu Admin, Menu Petugas Akademik, dan Petugas Teknisi Program : PHP dan Database MySQL Pseudocode <?php include"config.php"; ?> <html> <head> <title>SISTEM INFORMASI KLINIK TIU UNIVERSITAS SUMATERA UTARA</title> <link href="cssfont.css" rel="stylesheet" type="text/css"> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <style type="text/css"> <!-- font {font-family: "Franklin Gothic Book"; font-size: 13px; font-style: normal; line-height: normal; font-weight: normal; font-variant: normal; text-transform: none; font-style:italic;} body {background-color: #CCCffC; margin-top: 10px;} --> </style> </head> <body bgcolor="#CCCffC" onLoad="document.getElementById('keyword').focus()"> <table width="705" frame="box" bordercolor="#000000" align="center" > <tr> <td ><div align="center" class="tekshaldepan"><strong>DAFTAR TINDAKAN DARI KELUHAN PENGUNJUNG </strong><br> </div></td></tr><tr> <td> <div align="center" style="border:0px solid white; width:690px; height:200px; overflow-y:scroll; overflow-x:scroll;"> <table width="1152" border="1" cellspacing="0" cellpadding="2"> <tr bgcolor="#FF0000"> <td width="50"><div align="center"><font size="3"><strong>NO</strong></font></div></td> <td width="100"><div align="center"><font size="3"><strong>TANGGAL REGISTRASI</strong></font></div></td> <td width="100"><div align="center"><font size="3"><strong>TANGGAL SELESAI</strong></font></div></td> <td width="100"><div align="center"><font size="3"><strong>NIM_NIP_NIU</strong></font></div></td> <td width="252"><div align="center"><font size="3"><strong>NAMA PENGUNJUNG</strong></font></div></td> <td width="150"><div align="center"><font
151
Universitas Sumatera Utara
size="3"><strong>KELUHAN</strong></font></div></td> <td width="200"><div align="center"><font size="3"><strong>TINDAKAN</strong></font></div></td> <td width="200"><div align="center"><font size="3"><strong>HASIL</strong></font></div></td> <td width="150"><div align="center"><font size="3"><strong>PETUGAS</strong></font></div></td> </tr> <?php $databasename='klinik_ti'; $link=mysql_connect('localhost','root','') or die (mysql_error()); mysql_select_db($databasename,$link); $sqlstr="SELECT * FROM v_tindakan WHERE (`hasil`='SELESAI') ORDER BY nim_nip_niu ASC"; $query=mysql_query($sqlstr); $no = 0; while ($row = mysql_fetch_row($query)){ $no++; ?> <tr bgcolor="#FFFFFF"> <td><div align="center"><font size="2" color="#000000"><?php echo $no; ?></font></div></td> <td><font size="2" color="#000000"><?php echo $row[2]; ?></font></td> <td><font size="2" color="#000000"><?php echo $row[7]; ?></font></td> <td><font size="2" color="#000000"><?php echo $row[0]; ?></font></td> <td><font size="2" color="#000000"><?php echo $row[1]; ?></font></td> <td><font size="2" color="#000000"><?php echo $row[3]; ?></font></td> <td><font size="2" color="#000000"><?php echo $row[4]; ?></font></td> <td><font size="2" color="#000000"><?php echo $row[5]; ?></font></td> <td><font size="2" color="#000000"><?php echo $row[6]; ?></font></td> </tr> <?php } ?> </table></div></td></tr></table>
</body> </html>
Lampiran 1.15 Program Spesifikasi Daftar Tindakan
16. List Program Tambar User
Nama : Tambah_User Tujuan : Daftar registrasi User dalam pemasukan data login masuk Lokasi : Menu Admin Program : PHP dan Database MySQL Pseudocode <?php include"config.php"; ?> <html> <head> <title>SISTEM INFORMASI KLINIK TI UNIVERSITAS SUMATERA UTARA</title>
152
Universitas Sumatera Utara
<script type="text/javascript"> function cek_data(){ if (frminuser.keyword.value==""){ alert ("Maaf, Data tidak boleh kosong"); frminuser.keyword.focus() return false } if (frminuser.username.value==""){ alert ("Maaf, Data tidak boleh kosong"); frminuser.username.focus() return false } if (frminuser.password.value==""){ alert ("Maaf, Data tidak boleh kosong"); frminuser.password.focus() return false } if (frminuser.level.value==""){ alert ("Maaf, Data tidak boleh kosong"); frminuser.level.focus() return false } return true } </script> <link href="cssfont.css" rel="stylesheet" type="text/css"> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <style type="text/css"> <!-- font { font-family: "Franklin Gothic Book"; font-size: 13px; font-style: normal; line-height: normal; font-weight: normal; font-variant: normal; text-transform: none; font-style:italic; } body {background-color: #CCCffC; margin-top: 10px;} --> </style> </head> <body bgcolor="#CCCffC" onLoad="document.getElementById('keyword').focus()"> <form action="#" name="frminuser" method="post"> <table width="705" height="303" align="center" frame="box" bordercolor="#000000"> <tr> <td> <div align="center" class="judul"><strong>PENDATAAN USER</strong> </div> <div align="center" class="graynote"><p>(ISILAH USERNAME DAN PASSWORD PADA KOLOM KOSONG DIBAWAH INI)</div> <div align="center"> <table border=0> <tr><td colspan=3><input name="search" type="submit" value="None" style="display:none"></td></tr> <?php if( isset($_POST['search']) ) { if( $_POST['keyword'] != '' ) { $keyword = trim($_POST['keyword']); $databasename='sipeg'; $link=mysql_connect('localhost','root','') or die (mysql_error()); mysql_select_db($databasename,$link); $sql = "SELECT * FROM pegawai WHERE nip LIKE '%" .$keyword. "%'"; $query = mysql_query($sql); $countData = mysql_num_rows($query); if( $countData > 0 ){ $data=0; while($data = mysql_fetch_array($query)){ $nim=$data['nip']; $nama=$data['nama'];}} else {echo "<script>alert('DATA YANG DI INPUTKAN TIDAK DITEMUKAN ');</script>";}}
153
Universitas Sumatera Utara
else {echo "<script>alert('SILAHKAN MASUKKAN NIM YANG AKAN DICARI ');</script>";}} ?> <tr><td><span class="subproposal"><strong>NIP</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td> <input name="keyword" id="keyword" class="subproposal"type="text" size=25 value="<?php echo "$nim"; ?>"></td></tr> <tr><td><span class="subproposal"><strong>NAMA</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><input name="nama" class="subproposal" readonly="true" type="text" size=40 value="<?php echo "$nama"; ?>"></td></tr> <tr><td><span class="subproposal"><strong>USERNAME</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><input name="username" class="subproposal" type="text" size=25></td></tr> <tr><td><span class="subproposal"><strong>PASSWORD</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><input name="password" class="subproposal" type="text" size=25></td></tr> <tr><td><span class="subproposal"><strong>LEVEL</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><select name="level" class="subproposal"> <option value="">-- SILAHKAN PILIH --</option> <option value="admin">ADMIN</option> <option value="petugas">PETUGAS REGISTRASI</option> <option value="operator1">OPERATOR TEKNISI</option> <option value="operator2">OPERATOR AKADEMIS</option> </select></td></tr> <tr><td></td><td></td> <td colspan=3><input name="proses" class="subproposal" onClick="return cek_data()" type="submit" value="SIMPAN"> <input type="reset" class="subproposal" name="reset" value="BATAL"></td></tr> <?php if($_POST['proses']){ $nim=$_POST['keyword']; $nama= $_POST['username']; $username= $_POST['nama']; $level=$_POST['level']; $password=$_POST['password']; $databasename='klinik_ti'; $link=mysql_connect('localhost','root','') or die (mysql_error()); mysql_select_db($databasename,$link); $sql2="SELECT * FROM USER WHERE username = '$username' or nip='$nim'"; $query2=mysql_query($sql2); $n= mysql_num_rows($query2); if($n>=1) {echo "<script>alert('NIP / Username telah ada, pilih data berbeda! ');</script>";exit();} $sql="INSERT INTO user (nip, nama, username, level, password) VALUES ('$nim','$nama','$username','$level','$password')"; $query=mysql_query($sql); if($query){ $sql2="INSERT INTO temp (id, id_p, user) VALUES (null,null,'$username')"; $query2=mysql_query($sql2); echo "<script>alert('DATA YANG DI INPUT TELAH DISIMPAN ');</script>"; echo "<meta http-equiv=\"refresh\" content=\"0 url=./input_user.php\">";}
154
Universitas Sumatera Utara
else{echo "<script>alert('MAAF, DATA YANG DIINPUT TIDAK BISA DISIMPAN. ADA KESAMAAN DATA ');</script>"; echo "<meta http-equiv=\"refresh\" content=\"0 url=./input_user.php\">";}} ?> </table> </div></td></tr> </table> </form> </body> </html>
Lampiran 1.16 Program Spesifikasi Tambah User
17. List Program Ganti Password User
Nama : Ganti_Password User Tujuan : Mengganti password user yang lama ke baru Lokasi : Menu Admin Program : PHP dan Database MySQL Pseudocode <?php include"config.php"; ?> <html> <head> <title>SISTEM INFORMASI KLINIK TI UNIVERSITAS SUMATERA UTARA</title> <script type="text/javascript"> function cek_data() { if (frmuser.username.value=="") { alert ("Username salah atau tidak boleh kosong"); frmuser.username.focus() return false } if (frmuser.passwordlama.value=="") { alert ("Password salah atau tidak boleh kosong"); frmuser.passwordlama.focus() return false } if (frmuser.passwordbaru.value=="") { alert ("Password salah atau tidak boleh kosong"); frmuser.passwordbaru.focus() return false } if (frmuser.konfirmasipassword.value=="") { alert ("Password salah atau tidak boleh kosong"); frmuser.konfirmasipassword.focus() return false } return true } </script> <link href="cssfont.css" rel="stylesheet" type="text/css"> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <style type="text/css"> <!-- font { font-family: "Franklin Gothic Book"; font-size: 13px; font-style: normal;
155
Universitas Sumatera Utara
line-height: normal; font-weight: normal; font-variant: normal; text-transform: none; font-style:italic; } body { background-color: #CCCffC; margin-top: 10px; } --> </style> </head> <body bgcolor="#CCCffC" onLoad="document.getElementById('username').focus()"> <form action="" name="frmuser" method="POST"> <table width="705" height="303" align="center" frame="box" bordercolor="#000000"> <tr> <td> <div align="center" class="judul"><strong>PENGGANTIAN PASSWORD USER</strong></div> <div align="center" class="graynote"><p>(MASUKKAN USERNAME SERTA PASSWORD LAMA DAN BARU PADA KOLOM KOSONG DIBAWAH INI)</div> <div align="center"> <table border='0'> <tr><td><span class="subproposal"><strong>USERNAME</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><input type="text" name="username" class="subproposal" id="username"></td></tr> <tr><td><span class="subproposal"><strong>PASSWORD LAMA</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><input type="password" name="passwordlama" class="subproposal" id="passwordlama"></td></tr> <tr><td><span class="subproposal"><strong>PASSWORD BARU</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><input type="password" name="passwordbaru" class="subproposal" id="passwordbaru"></td></tr> <tr><td><span class="subproposal"><strong>KONFIRMASI PASSWORD BARU</strong></span></td> <td><span class="subproposal"><strong>:</strong></span></td> <td><input type="password" name="konfirmasipassword" class="subproposal" id="konfirmasipassword"></td></tr> <tr><td></td><td></td><td> <input type="submit" class="subproposal" onClick="return cek_data()" name="submit" value="GANTI"> <input type="reset" name="reset" value="BATAL"> </td></tr> <?php require_once "config.php"; $passwordlama = $_POST['passwordlama']; $passwordbaru = $_POST['passwordbaru']; $konfirmasipassword = $_POST['konfirmasipassword']; $username = $_POST['username']; $cekuser="select * from user where nama ='$username' and password='$passwordlama'"; $querycekuser = mysql_query($cekuser); $count = mysql_num_rows($querycekuser); if ($count >= 1){ $updatepassword = "update user set password ='$passwordbaru' where nama = '$username'"; $updatequery = mysql_query($updatepassword); if($updatequery) {echo "<script>alert('PASSWORD TELAH BERHASIL DI GANTI ');</script>";}} ?> </table></div></table>
156
Universitas Sumatera Utara
</form> </body> </html>
Lampiran 1.17 Program Spesifikasi Ganti Password User
18. List Program Cari Data User
Nama : Cari_Data User Tujuan : Mencari data-data user yang telah terdata di database Lokasi : Menu Admin Program : PHP dan Database MySQL Pseudocode <?php include 'config.php'; ?> <html> <head> <title>SISTEM INFORMASI KLINIK TI UNIVERSITAS SUMATERA UTARA</title> <style> body{ font-family: Tahoma; color: #222222; text-align: center; } table, tr, td { font-size: 11px; } form { text-align: center; padding: 5px; width: 600px; } form input { border: 1px solid #CCCCCC; padding: 5px; } form input[type="submit"] { border: 1px solid #666666; padding: 5px; margin-top:20px; font-weight: bold; } #q { width: 700px; border: 1px solid #CCCCCC; padding: 20px; } </style> <style type="text/css"> <!-- body { background-color: #CCFF66; background-image: url(); } --> </style> <script type="text/javascript"> function cek_data() { if (frmmhs.keyword.value==""){ alert ("Maaf, NIP Anda salah atau tidak boleh kosong"); frmmhs.keyword.focus() return false } return true } </script> <link href="cssfont.css" rel="stylesheet" type="text/css"> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><style type="text/css"> <!-- font { font-family: "Franklin Gothic Book"; font-size: 13px; font-style: normal; line-height: normal; font-weight: normal; font-variant: normal; text-transform: none; font-style:italic; } body { background-color: #CCCffC; margin-top: 10px; } .style16 { font-size: 16px; font-family: "Times New Roman", Times, serif; } -->
157
Universitas Sumatera Utara
</style> </head> <body bgcolor="#CCCffC" onLoad="document.getElementById('keyword').focus()"> <form action="#" name="frmmhs" method="post" onSubmit="return cek_data()"> <div id="q"> <div align="center" class="judul"><strong>PENDATAAN PEGAWAI KLINIK TI </strong></div><br> <div align="center" class="graynote">(ISILAH NIP/NIU USER PADA KOLOM KOSONG DIBAWAH INI)</div> <table align="center" border="0"> <tr><td><p class="ewGroupField style16">NIP/NIU</p></td> <td>:</td><td><input type="text" name="keyword" id="keyword" size="40" /></td></tr> <tr><td></td><td></td><td><input type="submit" name="search" value="CARI" /></td></tr> </table> <?php if( isset($_POST['search']) ) { if( $_POST['keyword'] != '' ) { $keyword = trim($_POST['keyword']); $sql = "SELECT * FROM user WHERE nip LIKE '%" .$keyword. "%'"; $query = mysql_query($sql); $countData = mysql_num_rows($query); echo "<table width=\"100%\" cellpadding=\"5\" cellspacing=\"1\" bgcolor=\"#333333\">"; echo "<tr bgcolor=\"#CCCCCC\">"; echo "<th width=\"2%\">NIP/NIU</th>\n"; echo "<th width=\"40%\">USERNAME</th>\n"; echo "<th width=\"25%\">NAMA</th>\n"; echo "<th width=\"33%\">PASSWORD</th>\n"; echo "<th width=\"33%\">LEVEL</th>\n"; echo "</tr>"; if( $countData > 0 ) { $data=0; while($data = mysql_fetch_assoc($query)) { $data++; echo "<tr bgcolor=\"#EEEEEE\">"; echo "<td>".$data['nip']."</td>\n"; echo "<td>".$data['nama']."</td>\n"; echo "<td>".$data['username']."</td>\n"; echo "<td>".$data['password']."</td>\n"; echo "<td>".$data['level']."</td>\n"; echo "</tr>"; }} else { echo "<tr bgcolor=\"#EEEEEE\">"; echo "<td colspan=\"5\" align=\"center\"><em>- data tidak ditemukan -</em></td>"; echo "</tr>"; } echo "<tr bgcolor=\"#EEEEEE\">"; echo "<td colspan=\"5\" align=\"center\"><em> ditemukan data ".$countData." record</em></td>"; echo "</tr>"; echo "</table>"; } else { echo '<center><em>- SILAHKAN MASUKKAN NIM/NIP/NIU YANG AKAN DICARI -</em></center>';}} ?> </div> </form>
158
Universitas Sumatera Utara
</body> </html>
Lampiran 1.18 Program Spesifikasi Cari Data User
19. List Program Form Laporan
Nama : Form Laporan Tujuan : Mencetak hasil kinerja pelayanan petugas klinik berupa laporan untuk ketua koordinator tim Lokasi : Menu Admin Program : PHP dan Database MySQL Pseudocode <?php include"config.php"; ?> <html> <head> <title>SISTEM INFORMASI KLINIK TIU UNIVERSITAS SUMATERA UTARA</title> <script type="text/javascript"> function cek_data(){ if (frmlap.harcat.value==""){ alert ("Maaf, Pilih Jenis Laporan yang dikehendaki....!!!!!"); frmlap.harcat.focus() return false } return true } </script> <link href="cssfont.css" rel="stylesheet" type="text/css"> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><style type="text/css"> <!-- font { font-family: "Franklin Gothic Book"; font-size: 13px; font-style: normal; line-height: normal; font-weight: normal; font-variant: normal; text-transform: none; font-style:italic; } body { background-color: #CCCffC; margin-top: 10px; } --> </style> </head> <body bgcolor="#CCCffC"> <form method="post" name="frmlap" action="tmpl_mhs.php" target="_blank">
159
Universitas Sumatera Utara
<div align="center"> <table width="705" frame="box" bordercolor="#000000" align="center" > <tr><td ><div align="center"><p><font size="5"><strong>LAPORAN KLINIK TI</strong></font></p></div> <div align="center"> <table width="642" border=0> <tr><td width="26"><input type="checkbox" name="cek0" value="0"></td> <td width="146"><font color="#FF0000" size="2">LAPORAN KESELURUHAN</font></td> <td width="17"></td><td width="435"></td></tr> <tr><td width="26"><input type="checkbox" name="cek1" value="1"></td> <td width="146"><font color="#FF0000" size="2">PILIH FAKULTAS</font></td> <td width="17"><font color="#FF0000" size="2">:</font></td><td width="435"> <select name="fkl"> <option value=''>-PILIH FAKULTAS-</option> <option value="KEDOKTERAN">KEDOKTERAN</option> <option value="HUKUM">HUKUM</option> <option value="PERTANIAN">PERTANIAN</option> <option value="TEKNIK">TEKNIK</option> <option value="EKONOMI">EKONOMI</option> <option value="KEDOKTERAN GIGI">KEDOKTERAN GIGI</option> <option value="ILMU BUDAYA">ILMU BUDAYA</option> <option value="MIPA">MIPA</option> <option value="ISIP">ISIP</option> <option value="KESEHATAN MASYARAKAT">KESEHATAN MASYARAKAT</option> <option value="FARMASI">FARMASI</option> <option value="PSIKOLOGI">PSIKOLOGI</option> <option value="KEPERAWATAN">KEPERAWATAN</option> <option value="PASCASARJANA">PASCASARJANA</option> <option value="KIMIA KEDOKTERAN">KIMIA KEDOKTERAN</option> <option value="FISIKA KEDOKTERAN">FISIKA KEDOKTERAN</option> <option value="ANATOMI">ANATOMI</option> <option value="BIOKIMIA">BIOKIMIA</option> <option value="FARMAKOLOGI DAN TERAPEUTIK">FARMAKOLOGI DAN TERAPEUTIK</option> <option value="FISIOLOGI">FISIOLOGI</option> <option value="HISTOLOGI">HISTOLOGI</option> <option value="PARASITOLOGI">PARASITOLOGI</option> <option value="PATOLOGI ANATOMI">PATOLOGI ANATOMI</option> <option value="PATOLOGI KLINIK">PATOLOGI KLINIK</option> <option value="GIZI">GIZI</option> <option value="KESEHATAN ANAK">KESEHATAN ANAK</option> <option value="PENYAKIT DALAM">PENYAKIT DALAM</option> <option value="ILMU KESEHATAN KULIT DAN KELAMIN">ILMU KESEHATAN KULIT DAN KELAMIN</option> <option value="PENYAKIT PARU">PENYAKIT PARU</option> <option value="RADIOLOGI">RADIOLOGI</option> <option value="PENYAKIT SARAF/NEUROLOGI">PENYAKIT SARAF/NEUROLOGI</option> <option value="ANESTESIOLOGI DAN REANIMASI">ANESTESIOLOGI DAN REANIMASI</option> <option value="ILMU BEDAH">ILMU BEDAH</option> <option value="ILMU BEDAH SARAF">ILMU BEDAH SARAF</option> <option value="THT DAN KEPALA LEHER">THT DAN KEPALA LEHER</option>
160
Universitas Sumatera Utara
<option value="KEBIDANAN DAN PENYAKIT KANDUNGAN">KEBIDANAN DAN PENYAKIT KANDUNGAN</option> <option value="ILMU KESEHATAN MASYARAKAT & KEDOKTERAN KOMUNITAS">ILMU KESEHATAN MASYARAKAT & KEDOKTERAN KOMUNITAS</option> <option value="KARDIOLOGI">KARDIOLOGI</option> <option value="PROGRAM PENDIDIKAN DOKTER SPESIALIS">PROGRAM PENDIDIKAN SPESIALIS</option> <option value="HUKUM KEPERDATAAN">HUKUM KEPERDATAAN</option> <option value="HUKUM PIDANA">HUKUM PIDANA</option> <option value="HUKUM INTERNASIONAL">HUKUM INTERNASIONAL</option> <option value="HUKUM ADMINISTRASI NEGARA">HUKUM ADMINISTRASI NEGARA</option> <option value="HUKUM TATA NEGARA">HUKUM TATA NEGARA</option> <option value="ILMU HAMA DAN PENYAKIT TUMBUHAN">ILMU HAMA DAN PENYAKIT TUMBUHAN</option> <option value="ILMU TANAH">ILMU TANAH</option> <option value="AGROBISNIS/SEP">AGROBISNIS/SEP</option> <option value="ILMU TEKNOLOGI PANGAN">ILMU TEKNOLOGI PANGAN</option> <option value="PETERNAKAN">PETERNAKAN</option> <option value="TEKNIK PERTANIAN">TEKNIK PERTANIAN</option> <option value="BUDIDAYA PERTANIAN">BUDIDAYA PERTANIAN</option> <option value="TEKNIK MESIN">TEKNIK MESIN</option> <option value="TEKNIK ELEKTRO">TEKNIK ELEKTRO</option> <option value="TEKNIK INDUSTRI">TEKNIK INDUSTRI</option> <option value="TEKNIK SIPIL">TEKNIK SIPIL</option> <option value="TEKNIK KIMIA">TEKNIK KIMIA</option> <option value="ARSITEKTUR">ARSITEKTUR</option> <option value="EKONOMI PEMBANGUNAN">EKONOMI PEMBANGUNAN</option> <option value="MANAJEMEN">MANAJEMEN</option> <option value="AKUNTANSI">AKUNTANSI</option> <option value="KEUANGAN D3">KEUANGAN D3</option> <option value="KEDOKTERAN GIGI">KEDOKTERAN GIGI</option> <option value="SASTRA INGGRIS">SASTRA INGGRIS</option> <option value="SASTRA INDONESIA">SASTRA INDONESIA</option> <option value="SASTRA ARAB">SASTRA ARAB</option> <option value="SASTRA BATAK">SASTRA BATAK</option> <option value="SASTRA MELAYU">SASTRA MELAYU</option> <option value="SASTRA JEPANG">SASTRA JEPANG</option> <option value="ILMU SEJARAH">ILMU SEJARAH</option> <option value="ETNOMUSIKOLOGI">ETNOMUSIKOLOGI</option> <option value="ILMU PERPUSTAKAAN DAN INFORMASI">ILMU PERPUSTAKAAN DAN INFORMASI</option> <option value="SASTRA CINA">SASTRA CINA</option> <option value="BAHASA INGGRIS D3">BAHASA INGGRIS D3</option> <option value="BAHASA JEPANG D3">BAHASA JEPANG D3</option> <option value="PARIWISATA">PARIWISATA</option> <option value="PERPUSTAKAAN">PERPUSTAKAAN</option> <option value="FISIKA">FISIKA</option> <option value="KIMIA">KIMIA</option> <option value="MATEMATIKA">MATEMATIKA</option> <option value="ILMU KOMPUTER">ILMU KOMPUTER</option> <option value="TEKNIK PERANGKAT LUNAK">TEKNIK PERANGKAT LUNAK</option>
161
Universitas Sumatera Utara
<option value="ILMU KESEJAHTERAAN SOSIAL">ILMU KESEJAHTERAAN SOSIAL</option> <option value="ILMU KOMUNIKASI">ILMU KOMUNIKASI</option> <option value="ILMU POLITIK">ILMU POLITIK</option> <option value="ADM. PERPAJAKAN">ADM. PERPAJAKAN</option> <option value="ADMINISTRASI DAN KEBIJAKAN KESEHATAN">ADMINISTRASI DAN KEBIJAKAN KESEHATAN</option> <option value="KEPENDUDUKAN DAN BIOSTATISTIKA">KEPENDUDUKAN DAN BIOSTATISTIKA</option> <option value="EPIDEMIOLOGI">EPIDEMIOLOGI</option> <option value="GIZI KESEHATAN MASYARAKAT">GIZI KESEHATAN MASYARAKA</option> <option value="KESELAMATAN DAN KESEHATAN KERJA">KESELAMATAN DAN KESEHATAN KERJA</option> <option value="KESEHATAN LINGKUNGAN">KESEHATAN LINGKUNGAN</option> <option value="PENDIDIKAN KESEHATAN DAN ILMU PERILAKU">PENDIDIKAN KESEHATAN DAN ILMU PERILAKU</option> <option value="FARMAKOLOGI FARMASI">FARMAKOLOGI FARMASI</option> <option value="KIMIA FARMASI">KIMIA FARMASI</option> <option value="BIOLOGI FARMASI">BIOLOGI FARMASI</option> <option value="TEKNOLOGI FARMASI">TEKNOLOGI FARMASI</option> </select> </td></tr> <tr><td width="26"><input type="checkbox" name="cek2" value="2"></td> <td width="146"><font color="#FF0000" size="2">PILIH JENIS KELUHAN</font></td> <td width="17"><font color="#FF0000" size="2">:</font></td> <td width="435"> <select name="jns"> <option value=''>-PILIH JENIS KELUHAN-</option> <?php include "config.php"; $pilih="SELECT * FROM jenis_keluhan"; $query=mysql_query($pilih); while($row=mysql_fetch_array($query)) {echo"<option value='$row[jenis]'>$row[jenis]</option>";} ?> </select> </td></tr><tr> <td width="26"><input type="checkbox" name="cek3" value="3"></td> <td width="146"><font color="#FF0000" size="2">PILIH KATEGORI KELUHAN</font></td> <td width="17"><font color="#FF0000" size="2">:</font></optgroup></td> <td width="435"> <select name="ktg"> <option value=''>-PILIH KATEGORI KELUHAN-</option> <?php include "config.php"; $pilih="SELECT * FROM kategori"; $query=mysql_query($pilih); while($row=mysql_fetch_array($query)) {echo"<option value='$row[kategori]'>$row[kategori]</option>";} ?> </select> </td></tr><tr>
162
Universitas Sumatera Utara
<td width="26"><input type="checkbox" name="cek4" value="4"></td> <td width="146"><font color="#FF0000" size="2">PILIH HASIL</font></td> <td width="17"><font color="#FF0000" size="2">:</font></td> <td width="435"> <select name="hsl"> <option value=''>-PILIH HASIL-</option> <option value='SELESAI'>SELESAI</option> <option value='TIDAK SELESAI'>TIDAK SELESAI</option> <option value='TUNDA/PENDING'>TUNDA/PENDING</option> </select> </td></tr> <tr> <td width="26"><input type="checkbox" name="cek5" value="5"></td> <td width="146"><font color="#FF0000" size="2">PILIH OPERATOR</font></td> <td width="17"><font color="#FF0000" size="2">:</font></td> <td width="435"> <select name="opt"> <option value=''>-PILIH NAMA-</option> <?php include "config.php"; $pilih="SELECT * FROM user"; $query=mysql_query($pilih); while($row=mysql_fetch_array($query)) {echo"<option value='$row[username]'>$row[username]</option>";} ?> </select> </td></tr><tr><td></td><td></td><td></td><td colspan=3></td></tr></table></div> <div align="center"> <table border=0> <tr> <td><input type="radio" name="harcat" value="0"></td> <td><font color="#FF0000" size="2">LAPORAN HARIAN</font></td> <td></td> <td></td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td></td> <td><font size="2">PILIH TANGGAL</font></td> <td><font size="2">:</font></td> <td> <select name="tgl">
163
Universitas Sumatera Utara
<option value=01 selected>01</option> <? for($tgl=2; $tgl<=31; $tgl++){ $tgl_leng=strlen($tgl); if ($tgl_leng==1) $i="0".$tgl; else $i=$tgl; echo "<option value=$i>$i</option>";} ?> </select> <select name="bln"> <option value="01">Januari</option> <option value="02">Februari</option> <option value="03">Maret</option> <option value="04">April</option> <option value="05">Mei</option> <option value="06">Juni</option> <option value="07">Juli</option> <option value="08">Agustus</option> <option value="09">September</option> <option value="10">Oktober</option> <option value="11">November</option> <option value="12">Desember</option> </select> <select name="thn"> <option value=2000 selected>2000</option> <?php $now=date("Y"); for($thn=2001; $thn<=$now; $thn++){ echo "<option value=$thn>$thn</option>";} ?> </select> </td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td><input type="radio" name="harcat" value="1"></td> <td><font size="2" color="#FF0000">LAPORAN BULANAN</font></td> <td></td> <td></td>
164
Universitas Sumatera Utara
</tr> <tr> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td></td> <td><font size="2">PILIH BULAN </font></td> <td><font size="2">:</font></td> <td> <select name="bln2"> <option value="01">Januari</option> <option value="02">Februari</option> <option value="03">Maret</option> <option value="04">April</option> <option value="05">Mei</option> <option value="06">Juni</option> <option value="07">Juli</option> <option value="08">Agustus</option> <option value="09">September</option> <option value="10">Oktober</option> <option value="11">November</option> <option value="12">Desember</option> </select> <select name="thn2"> <option value=2000 selected>2000</option> <?php $now=date("Y"); for($thn=2001; $thn<=$now; $thn++){ echo "<option value=$thn>$thn</option>";} ?> </select> </td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td></td>
165
Universitas Sumatera Utara
<td></td> <td></td> <td></td> </tr> <tr> <td><input type="radio" name="harcat" value="2"></td> <td><font size="2" color="#FF0000">LAPORAN TAHUNAN</font></td> <td></td> <td></td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td></td> <td><font size="2">PILIH TAHUN</font></td> <td><font size="2">:</font></td> <td > <select name="thn3"> <option value=2000 selected>2000</option> <?php $now=date("Y"); for($thn=2001; $thn<=$now; $thn++){ echo "<option value=$thn>$thn</option>";} ?> </select> </td> </tr> <tr> <td></td> <td></td> <td></td> <td colspan=3><input name="search" type="submit" onSelect="return cek_data()" value="CETAK"> <input name="RESET" value="RESET" type="reset"></td> </tr> </table> </div> </td> </tr> </table> </div>
166
Universitas Sumatera Utara
</form> </body> </html>
Lampiran 1.19 Program Spesifikasi Laporan Klinik TI USU
20. List Program Hasil Laporan
Nama : Hasil_Laporan Tujuan : Mencetak hasil kinerja pelayanan petugas klinik berupa laporan Format PDF untuk ketua koordinator tim Lokasi : Menu Admin Program : PHP dan Database MySQL Pseudocode <?php include "fungsi_indotgl.php"; $host ="localhost"; $user="root"; $password=""; $database="klinik_ti"; mysql_connect($host,$user,$password) or die("Koneksi server gagal"); mysql_select_db($database); $tgl = date('d-M-Y'); //////////Periksa Value Cekbox if ($_POST['cek0']<>"" or (($_POST['cek1']<>"" and $_POST['fkl']<>"") or ($_POST['cek2']<>"" and $_POST['jns']<>"") or ($_POST['cek3']<>"" and $_POST['ktg']<>"")or ($_POST['cek4']<>"" and $_POST['hsl']<>"") or ($_POST['cek5']<>"" and $_POST['opt']<>"")) and $_POST['harcat']<>"") { $keyword="";$harul="";$judul="";$where="";$weleh=""; $unit=""; //////////Variabel String Untuk Judul dan seleksi laporan if ($_POST['cek0']==0){ $judul="LAPORAN KESELURUHAN KLINIK TI"; $where=""; //$sub=""; } if ($_POST['cek1']==1){ $judul="LAPORAN KLINIK TI"; $sub="$fkl"; $unit="FAKULTAS : $sub"; $where=$where." and fakultas like '%" .$fkl. "%'"; } if ($_POST['cek2']==2){ $judul="LAPORAN KLINIK TI"; $where=$where." and jenis like '%" .$jns. "%'"; //$sub=$sub."$jns"; $sub="$jns"; $unit="JENIS KELUHAN : $sub"; } if ($_POST['cek3']==3){ $judul="LAPORAN KLINIK TI";
167
Universitas Sumatera Utara
$where=$where."and keluhan like '%" .$ktg. "%'"; $sub="$ktg"; $unit="KATEGORI KELUHAN : $sub"; } if ($_POST['cek4']==4){ $judul="LAPORAN KLINIK TI"; $where=$where."and hasil like '" .$hsl. "%'"; $sub="$hsl"; $unit="HASIL : $sub"; } if ($_POST['cek5']==5){ $judul="LAPORAN KLINIK TI"; $where=$where."and nama_opt like '%" .$opt. "%'"; $sub="$opt"; $unit="NAMA PETUGAS : $sub"; } //////////Ambil Variabel Untuk Date if ($_POST['harcat']==0){ $tanggal =($_POST['tgl']);$bulan = ($_POST['bln']);$tahun = ($_POST['thn']); $keyword= ("$tahun-$bulan-$tanggal");$harul= tgl_indo($keyword); } else if ($_POST['harcat']==1){ $bulan = ($_POST['bln2']);$tahun = ($_POST['thn2']); $keyword= ("$tahun-$bulan");$harul= tgl_indo($keyword); } else if ($_POST['harcat']==2){ $tahun = ($_POST['thn3']); $keyword= ("$tahun");$harul= tgl_indo($keyword); } //////////// Printah SQL BOS $sql = "SELECT * FROM v_campur WHERE tgl_registrasi like '%" .$keyword. "%' $where order by nim_nip_niu ASC"; //echo $sql; $query = mysql_query($sql); //Variabel untuk iterasi $i = 1; //Mengambil nilai dari query database while($data=mysql_fetch_row($query)) { $date = tgl_indo($data[0]); $cell[$i][0] = $date; $cell[$i][1] = $data[1]; $cell[$i][2] = $data[2]; $cell[$i][3] = $data[3]; $cell[$i][4] = $data[5]; $cell[$i][5] = $data[6]; $cell[$i][6] = $data[7]; $cell[$i][7] = $data[8]; $cell[$i][8] = $data[9]; $i++; } require('fpdf.php');
168
Universitas Sumatera Utara
class PDF extends FPDF { //Fungsi Untuk Membuat Header function Header() { //Pilih font Arial bold 15 $this->SetFont('Arial','B',15); //Geser ke kanan $this->Cell(80); //Judul dalam bingkai $this->Cell(30,10,'Title',1,0,'C'); //Ganti baris $this->Ln(0); } } $pdf = new PDF('L','cm','LEGAL'); $pdf->Open(); $pdf->AddPage(); $pdf->SetFont("Arial","B",14); $pdf->Cell(30,1.3,"", '0',0,'C'); $pdf->Ln(); $pdf->image('image/logo1.jpg','3','2','C'); $pdf->Cell(12.5,1,'KLINIK TI','0',0,'C'); $pdf->Ln(); $pdf->Cell(18.5,0.5,'UNIVERSITAS SUMATERA UTARA','0',0,'C'); $pdf->Ln(); $pdf->SetFont("Arial","B",11); $pdf->Cell(22,0.5,'JALAN UNIVERSITAS NO.9 PINTU I KAMPUS PADANG BULAN','0',0,'C'); $pdf->Ln(); $pdf->Cell(15.5,0.5,'MEDAN, SUMATERA UTARA','0',0,'C'); $pdf->Ln(); $pdf->SetFont("Arial","B",11); $pdf->setTextColor(0,0,0); $pdf->Cell(30,1,"", '0',0,'C'); $pdf->Ln(); $pdf->Cell(35,2,$judul,'0',0,'C'); $pdf->Ln(); $pdf->SetFont("Arial","B",9); $pdf->setTextColor(222,50,50); $pdf->Cell(3,0,"PERIODE :".$harul,'0',0,'C'); $pdf->Ln(); $pdf->SetFont("Arial","B",9); $pdf->setTextColor(222,50,50); $pdf->Cell(7,1,"SUB LAPORAN ".$unit,'0',0,'C'); $pdf->Ln(); $pdf->SetFont("Arial","B",7.5); $pdf->setTextColor(0,0,0); $pdf->Cell(1,0.5,'NO.','LRTB',0,'C'); $pdf->Cell(2.5,0.5,'TANGGAL','LRTB',0,'C'); $pdf->Cell(2,0.5,'NIM/NIP/NIU','LRTB',0,'C'); $pdf->Cell(3.5,0.5,'NAMA','LRTB',0,'C'); $pdf->Cell(3,0.5,'FAKULTAS','LRTB',0,'C'); $pdf->Cell(2,0.5,'JENIS','LRTB',0,'C'); $pdf->Cell(8,0.5,'MASALAH','LRTB',0,'C');
169
Universitas Sumatera Utara
$pdf->Cell(3,0.5,'NAMA OPERATOR','LRTB',0,'C'); $pdf->Cell(6,0.5,'TINDAKAN','LRTB',0,'C'); $pdf->Cell(2.5,0.5,'HASIL','LRTB',0,'C'); $pdf->Ln(); $pdf->SetFont('Times','',7); for($j=1;$j<$i;$j++) { //menampilkan data dari hasil query database $pdf->Cell(1,0.5,$j,'LBTR',0,'C'); $pdf->Cell(2.5,0.5,$cell[$j][0],'LBTR',0,'C'); $pdf->Cell(2,0.5,$cell[$j][1],'LBTR',0,'C'); $pdf->Cell(3.5,0.5,$cell[$j][2],'LBTR',0,'C'); $pdf->Cell(3,0.5,$cell[$j][3],'LBTR',0,'C'); $pdf->Cell(2,0.5,$cell[$j][4],'LBTR',0,'C'); $pdf->Cell(8,0.5,$cell[$j][5],'LBTR',0,'C'); $pdf->Cell(3,0.5,$cell[$j][6],'LBTR',0,'C'); $pdf->Cell(6,0.5,$cell[$j][7],'LBTR',0,'C'); $pdf->Cell(2.5,0.5,$cell[$j][8],'LBTR',0,'C'); $pdf->Ln(); } $pdf->Cell(60,1,"MEDAN , ".$tgl,'0',0,'C'); $pdf->Ln(); //menampilkan output berupa halaman PDF $pdf->Output(); //} } else { include "menu_admin.php"; echo "<script>alert('SILAHKAN PILIH JENIS LAPORAN YANG AKAN DICETAK ');</script>"; } ?>
Lampiran 1.20 Program Spesifikasi Hasil Cetak Laporan Klinik TI
21. List Program Form Help
170
Universitas Sumatera Utara
Nama : Help Tujuan : Sebagai Panduan bagaimana cara-cara menggunakan program Lokasi : Menu Admin Program : PHP dan Database MySQL Pseudocode <?php include"config.php"; ?> <html> <head> <title>SISTEM INFORMASI KLINIK TIU UNIVERSITAS SUMATERA UTARA</title> <link href="cssfont.css" rel="stylesheet" type="text/css"> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><style type="text/css"> <!-- font { font-family: "Franklin Gothic Book"; font-size: 13px; font-style: normal; line-height: normal; font-weight: normal; font-variant: normal; text-transform: none; font-style:italic; } body { background-color: #CCCffC; margin-top: 10px; } --> </style> </head> <body bgcolor="#CCCffC"> <div align="center"> <table width="704" border="0"> <tr> <td width="11" bordercolor="#FFFFFF" bgcolor="#FFFFFF"><span class="style19"></span></td> <td width="668" bgcolor="#FFFFFF" class="style14 style15"> <p align="center" class="style17"><font size="2" face="Times New Roman, Times, serif">CARA PENGGUNAAN PROGRAM</font></p> <font size="2" face="Times New Roman, Times, serif"><font color="black"> </font> <ol type = 1> <li class="style18"><font size="2" face="Times New Roman, Times, serif"> Masukkan <i>Username</i> dan <i>Password</i><B>.</B></font> <li class="style18"><font size="2" face="Times New Roman, Times, serif"> Pilih Menu.</font> <ol type = 1> <li><font size="2" face="Times New Roman, Times, serif"> Menu Home.</font> <li><font size="2" face="Times New Roman, Times, serif"> Menu Pengunjung.</font> <ul> <li><font size="2" face="Times New Roman, Times, serif">Mahasiswa.</font> <ul> <li type= circle><font size="2" face="Times New Roman, Times, serif">Masukkan nomor
171
Universitas Sumatera Utara
<b>NIM</b> Mahasiswa pada <i>TextBox, lalu tekan tombol <strong>ENTER</strong></i></font><font size="2" face="Times New Roman, Times, serif"><b>.</b></font> <li type= circle><font size="2" face="Times New Roman, Times, serif">Data akan terisi didalam <i>Form Mahasiswa.</i></font> <li type= circle><font size="2" face="Times New Roman, Times, serif">Lalu Klik tombol <strong>SIMPAN</strong> untuk menyimpan data Mahasiswa.</font> </ul> <li><font size="2" face="Times New Roman, Times, serif">Dosen/Pegawai.</font> <ul> <li type= circle><font size="2" face="Times New Roman, Times, serif">Masukkan nomor <b>NIP/NIU</b> Dosen/Pegawai pada <i>TextBox</i> , lalu tekan tombol <b>ENTER.</b></font> <li type= circle><font size="2" face="Times New Roman, Times, serif">Data akan terisi didalam <i>Form Dosen/Pegawai.</i></font> <li type= circle><font size="2" face="Times New Roman, Times, serif">Lalu Klik tombol <strong>SIMPAN</strong> untuk menyimpan data Dosen/Pegawai.</font> </ul> </ul> <li><font size="2" face="Times New Roman, Times, serif">Menu Keluhan</font> <ul> <li><font size="2" face="Times New Roman, Times, serif">Input Data Keluhan </font> <ul> <li type= circle><font size="2" face="Times New Roman, Times, serif">Masukkan nomor <strong>NIM/</strong><b>NIP/NIU</b> Pengunjung pada <i>TextBox</i>, lalu tekan tombol <b>ENTER.</b></font><font size="2" face="Times New Roman, Times, serif"><i>.</i></font> <li type= circle><font size="2" face="Times New Roman, Times, serif">Lalu pilih Jenis Keluhan dan Kategori Keluhan</font> <li type= circle><font size="2" face="Times New Roman, Times, serif">Lalu Klik tombol <strong>SIMPAN</strong> untuk menyimpan data Keluhan.</font> </ul> <li><font size="2" face="Times New Roman, Times, serif">Input Kategori Keluhan</font> <ul> <li type= circle><font size="2" face="Times New Roman, Times, serif">Pilih Jenis Kategori dan isikan Kategori Keluhan<b>.</b></font> <li type= circle><font size="2" face="Times New Roman, Times, serif">Klik Tombol <strong>SIMPAN</strong>.</font> </ul> </ul> <li><font size="2" face="Times New Roman, Times, serif">Menu Tindakan</font> <ul> <li><font size="2" face="Times New Roman, Times, serif">Input Data Tindakan</font> <ul> <li type= circle><font size="2" face="Times New Roman, Times, serif">Pilih NIM/NIP/NIU pada LIST ADMIN, maka data akan secara otomatis masuk pada Form Tindakan <b>.</b></font> <li type= circle><font size="2" face="Times New Roman, Times, serif">Lalu isi Tindakan dan <em>Hasil</em>, jika status Hasil Pending/T unda maka akan masuk ke dalam Tabel Pending. </font> <li type= circle><font size="2" face="Times New Roman, Times, serif">Lalu Klik tombol <strong>SIMPAN</strong> untuk menyimpan Data Tindakan.</font> <li type="circle"><font size="2" face="Times New Roman, Times, serif">Jika akan melanjutkan pekerjaan data Pending, maka klik NIM/NIP/NIU pada Tabel Pending, lalu isikan Tindak Lanjut. kemudian klik tombol <strong>SIMPAN</strong> </font> </ul> <li><font size="2" face="Times New Roman, Times, serif">Daftar Tindakan</font> </ul>
172
Universitas Sumatera Utara
<li><font size="2" face="Times New Roman, Times, serif">Menu User</font> <ul> <li><font size="2" face="Times New Roman, Times, serif">Tambah User</font> <ul> <li type= circle><font size="2" face="Times New Roman, Times, serif">Masukkan nomor <strong>NIP/NIU </strong> Pegawai pada <i>TextBox</i> Pencarian, lalu Klik tombol <b>CARI.</b></font> <li type= circle><font size="2" face="Times New Roman, Times, serif">Data akan terisi didalam <i>Form User.</i></font> <li type= circle><font size="2" face="Times New Roman, Times, serif">Lalu isi<em> Username, Password </em>dan <em>Level.</em></font> <li type= circle><font size="2" face="Times New Roman, Times, serif">Lalu Klik tombol <strong>SIMPAN</strong> untuk menyimpan data User.</font><font size="2" face="Times New Roman, Times, serif">.</font> </ul> <li><font size="2" face="Times New Roman, Times, serif">Ganti Password</font> <ul> <li type= circle><font size="2" face="Times New Roman, Times, serif">Masukkan nomor<strong>Username dan Password Lama</strong><i>.</i> </font> <li><font size="2" face="Times New Roman, Times, serif">Lalu isi<em> Password Baru dan Konfirmasi Password Baru </em></font> <li type= circle><font size="2" face="Times New Roman, Times, serif">Lalu Klik tombol<strong> GANTI </strong>untuk menyimpan data Ganti Password Baru.</font> </ul> <li><font size="2" face="Times New Roman, Times, serif">Cari Data User</font> <ul> <li type= circle><font size="2" face="Times New Roman, Times, serif">Masukkan nomor <b>NIP/NIU</b> Dosen/Pegawai pada <i>TextBox</i> Pencarian, lalu Klik tombol <b>CARI NIP/NIU.</b></font> <li type= circle><font size="2" face="Times New Roman, Times, serif">Data akan terisi didalam <i>Form Pencarian</i></font> </ul> </ul><li><font size="2" face="Times New Roman, Times, serif">Menu Laporan</font> <ul><li><font size="2" face="Times New Roman, Times, serif">Pilih Sub Laporan lalu pilih Jenis Laporan yang akan dicetak.</font> <li><font size="2" face="Times New Roman, Times, serif">Lalu Tekan Tombol <strong>CETAK</strong>.</font> <li><font size="2" face="Times New Roman, Times, serif">Jika ingin membatalkan tekan Tombol <strong>RESET</strong>.</font> </ul> <li><font size="2" face="Times New Roman, Times, serif">Menu Help </font> </ol> </ol></td> <td bgcolor="#FFFFFF" width="11"> </td> </tr> </table> </div> </body> </html
Lampiran 1.21 Program Spesifikasi Help
LAMPIRAN 2
Universitas Sumatera Utara
DESKRIPSI USE CASE DIAGRAM
Deskripsi use case diagram pada perancangan sistem informasi pelayanan
teknologi informasi klinik TI USU adalah sebagai berikut:
1. Use Case Lihat_Pendataan
Use Case Name : Lihat_Pendataan ID 1.1.1-6 Importance Level : Tinggi
Primary Actor : Pengunjung, Petugas
Registrasi
Use Case Type : Persyaratan Bisnis
Stakeholders and Interests : Petugas Registrasi
Brief Description : Use Case ini menjelaskan tentang proses pendataan
Trigger : Use Case ini diinisiasi saat sipengunjung meminta untuk melakukan proses
pendataan registrasi
Relationship : -
Normal Flow of Event :-
Subflows :
Alternate/Exceptional Flows :
Lampiran 2.1 Deskripsi Use Case Pendataan
2. Use Case Lihat_Keluhan
Use Case Name : Lihat_Keluhan ID 1.1.1-7 Importance Level : Tinggi
Primary Actor : Pengunjung, Petugas
Registrasi
Use Case Type : Persyaratan Bisnis
Stakeholders and Interests : Pengunjung, Petugas Registrasi dan Operator
Brief Description : Use Case ini menjelaskan tentang proses keluhan dan kategori
keluhan
Trigger : Use Case ini diinisiasi saat sipengunjung melakukan proses keluhan 173
174
Universitas Sumatera Utara
Relationship : Memiliki hubungan include terhadap proses pemeriksaan
Normal Flow of Event :
a. User Petugas Registrasi dapat mengisikan nomor ID sipengunjung
b. User Petugas Registrasi dapat melihat data sipengunjung
c. User Petugas Registrasi dapat mengisikan keluhan dari sipengunjung
Subflows : -
Alternate/Exceptional Flows : -
Lampiran 2.2 Deskripsi Use Case Keluhan
3. Use Case Lihat_Pemeriksaan
Use Case Name : Lihat_Pemeriksaan ID 1.1.1-8 Importance Level : Tinggi
Primary Actor : Pengunjung, Operator Use Case Type : Persyaratan Bisnis Stakeholders and Interests : Operator Brief Description : Use Case ini menjelaskan tentang proses pemeriksaan keluhan yang dilakukan oleh Operator. Trigger : Use Case ini diinisiasi saat sipengunjung telah selesai memberikan keluhan
Relationship : Memiliki hubungan include terhadap proses tindakan
Normal Flow of Event : a. User Operator dapat mengisikan penyebab keluhan Akademik yang dialami
oleh sipengunjung Subflows : - Alternate/Exceptional Flows : -
Lampiran 2.3 Deskripsi Use Case Pemeriksaan
4. Use Case Lihat_Tindakan
175
Universitas Sumatera Utara
Use Case Name : Lihat_Tindakan ID 1.1.1-9 Importance Level : Tinggi
Primary Actor : Operator Use Case Type : Persyaratan Bisnis
Stakeholders and Interests : Pengunjung, Operator
Brief Description : Use Case ini menjelaskan tentang proses tindakan
Trigger : Use Case ini diinisiasi saat sipengunjung melakukan proses pemeriksaan
Relationship : Memiliki hubungan include dari proses pemeriksaan
Normal Flow of Event :
a. User Operator dapat mengisikan tindakan yang dilakukan dan keterangannya
b. User Operator dapat mengisikan hasil dari tindakan yang telah diambil
Subflows : -
Alternate/Exceptional Flows : -
Lampiran 2.4 Deskripsi Use Case Tindakan
5. Use Case Pembuatan_laporan Use Case Name : Pembuatan_Laporan ID 1.1.1-10 Importance Level : Tinggi
Primary Actor : Administrator Use Case Type : Persyaratan Bisnis
Stakeholders and Interests : Administrator, Petugas Registrasi, dan Operator
Brief Description : Use Case ini menjelaskan tentang proses pembuatan laporan semua
kegiatan operasional Klinik Teknologi Informasi USU
Trigger : Use Case ini diinisiasi saat semua proses operasional selesai dilakukan
Relationship : Memiliki hubungan include dari proses data keluhan ke proses
pemeriksaan
Normal Flow of Event :
a. User dapat membuat dan mencetak laporan secara keseluruhan baik secara
harian, bulanan, atau tahunan
b. User dapat membuat dan mencetak sub laporan pilihan baik secara harian,
bulanan, atau tahunan.
Subflows : -
Alternate/Exceptional Flows : -
Lampiran 2.5 Deskripsi Use Case Pembuatan Laporan 6. Use Case Terima_Laporan
176
Universitas Sumatera Utara
Use Case Name : Terima_Laporan ID 1.1.1-10 Importance Level : Tinggi
Primary Actor : Ketua koordinator tim Use Case Type : Persyaratan Bisnis
Stakeholders and Interests : Ketua koordinator tim, Administrator
Brief Description : Use Case ini menjelaskan tentang proses penyerahan laporan
semua kegiatan operasional Klinik Teknologi Informasi
Trigger : Use Case ini diinisiasi saat semua proses operasional selesai dilakukan
Relationship : -
Normal Flow of Event :
a. User menerima laporan hasil kinerja operasional Klinik TI USU secara
keseluruhan dan sub laporan baik secara harian, bulanan atau tahunan
Subflows : -
Alternate/Exceptional Flows : -
Lampiran 2.6 Deskripsi Use Case Terima Laporan
LAMPIRAN 3
Universitas Sumatera Utara
TAMPILAN PERANCANGAN DESAIN INPUT
Berikut ini adalah tampilan-tampilan beserta tabel fungsi dan keterangan pada
perancangan desain input sistem informasi pelayanan teknologi informasi klinik TI
USU.
1. Tampilan Desain Form Menu Admin
Lampiran 3.1 Tampilan Desain Form Menu Admin
2. Tampilan Desain Form Menu Petugas Registrasi
KLINIK TI UNIVERSITAS SUMATERA UTARA
Jalan Universitas No.9 Pintu 1 Kampus Padang Bulan Medan, Sumatera Utara
LOGO UNIVERSI
TAS
MELAYANI KELUHAN SIVITAS AKADEMIKA UNIVERSITAS SUMATERA UTARA
PASSWORD
GAMBAR GEDUNG KLINIK TI USU
HOME PENGUNJUNG
KELUHAN
TINDAKAN
USER LAPORAN
HELP
SISTEM INFORMASI KLINIK TI USU Sistem Informasi Pelayanan TI ini berfungsi untuk mengelola administrasi data pengunjung di klinik TI USU. Aplikasi ini mendukung pengelolaan keluhan dan tindakan yang dilakukan oleh petugas klinik TI
LogOut
177
178
Universitas Sumatera Utara
Lampiran 3.2 Tampilan Desain Form Menu Petugas Registrasi
3. Tampilan Desain Form Menu Petugas Operator
Lampiran 3.3. Tampilan Desain Form Menu Petugas Operator 4. Tampilan Desain Form Login User
KLINIK TI UNIVERSITAS SUMATERA UTARA
Jalan Universitas No.9 Pintu 1 Kampus Padang Bulan Medan, Sumatera Utara
LOGO UNIVERSI
TAS
MELAYANI KELUHAN SIVITAS AKADEMIKA UNIVERSITAS SUMATERA UTARA
PASSWORD
GAMBAR GEDUNG KLINIK TI USU
SISTEM INFORMASI KLINIK TI USU Sistem Informasi Pelayanan TI ini berfungsi untuk mengelola administrasi data pengunjung di klinik TI USU. Aplikasi ini mendukung pengelolaan keluhan dan tindakan yang dilakukan oleh petugas klinik TI
LogOut
HOME TINDAKAN HELP
KLINIK TI UNIVERSITAS SUMATERA UTARA
Jalan Universitas No.9 Pintu 1 Kampus Padang Bulan Medan, Sumatera Utara
LOGO UNIVERSI
TAS
MELAYANI KELUHAN SIVITAS AKADEMIKA UNIVERSITAS SUMATERA UTARA
PASSWORD
GAMBAR GEDUNG KLINIK TI USU
SISTEM INFORMASI KLINIK TI USU Sistem Informasi Pelayanan TI ini berfungsi untuk mengelola administrasi data pengunjung di klinik TI USU. Aplikasi ini mendukung pengelolaan keluhan dan tindakan yang dilakukan oleh petugas klinik TI
LogOut
HOME PENGUNJUNG KELUHAN HELP
179
Universitas Sumatera Utara
Lampiran 3.4. Tampilan Desain Login
Fungsi dan keterangan dari form Login User sebagai berikut :
No Nama Objek Keterangan 1 ID Pegawai Text Box Untuk input ID Pegawai 2 Password Text Box Untuk input password 3 Login Button Untuk masuk ke aplikasi 4 Batal Button Untuk membatalkan masuk ke aplikasi
5. Tampilan Desain Form Pendataan Mahasiswa
KLINIK TI UNIVERSITAS SUMATERA UTARA
Jalan Universitas No.9 Pintu 1 Kampus Padang Bulan Medan, Sumatera Utara
LOGO UNIVERSI
TAS
MELAYANI KELUHAN SIVITAS AKADEMIKA UNIVERSITAS SUMATERA UTARA UTARA
LOGIN USER ISILAH USERNAME DAN PASSWORD YANG
USERNAME PASSWORD
180
Universitas Sumatera Utara
Lampiran 3.5. Tampilan Desain Input Data Mahasiswa
Fungsi dan keterangan dari form Pendataan Mahasiswa sebagai berikut :
No Nama Objek Keterangan 1 NIM Text Box Untuk input NIM Mahasiswa 2 Nama Text Box Untuk input nama Mahasiswa 3 Fakultas Text Box Untuk input Fakultas Mahasiswa 4 Jurusan Text Box Untuk input Jurusan Mahasiswa 5 Program Studi Text Box Untuk input Prodi Mahasiswa 6 Simpan Button Untuk simpan data Mahasiswa ke database 7 Batal Button Membatalkan data Mahasiswa ke database
8 Logout Button Untuk keluar dari data form Mahasiswa ke Login Masuk
6. Tampilan Desain Form Pendataan Dosen/Pegawai
KLINIK TI UNIVERSITAS SUMATERA UTARA
Jalan Universitas No.9 Pintu 1 Kampus Padang Bulan Medan, Sumatera Utara
LOGO UNIVERSI
TAS
MELAYANI KELUHAN SIVITAS AKADEMIKA UNIVERSITAS SUMATERA UTARA
PENDATAAN MAHASISWA (ISILAH NIM MAHASISWA PADA KOLOM KOSONG
NIM NAMA
FAKULTAS JURUSAN PROGRAM
HOME PENGUNJUNG KELUHAN HELP
LogOu
181
Universitas Sumatera Utara
Lampiran 3.6. Tampilan Desain Input Data Dosen/Pegawai
Fungsi dan keterangan dari Desain form Pendataan Dosen/Pegawai sebagai berikut :
No Nama Objek Keterangan 1 NIP/NIU Text Box Untuk input ID Dosen/Pegawai 2 Nama Text Box Untuk input nama Dosen/Pegawai 3 Fakultas Text Box Untuk input Fakultas Dosen/Pegawai 4 Jurusan Text Box Untuk input Jurusan Dosen/Pegawai 5 Program_Studi Text Box Untuk input Prodi Dosen/Pegawai 6 Unit_Kerja Text Box Untuk input Unit kerja Dosen/Pegawai 7 Simpan Button Menyimpan data Dosen/Pegawai ke database 8 Batal Button Membatalkan data Dosen/Pegawai ke database
9 LogOut Button Untuk keluar dari form data Dosen/Pegawai ke Login Masuk
7. Tampilan Desain Form Pendataan Keluhan Pengunjung
KLINIK TI UNIVERSITAS SUMATERA UTARA
Jalan Universitas No.9 Pintu 1 Kampus Padang Bulan Medan, Sumatera Utara
LOGO UNIVERSI
TAS
MELAYANI KELUHAN SIVITAS AKADEMIKA UNIVERSITAS SUMATERA UTARA
PENDATAAN DOSEN/PEGAWAI (ISILAH NIM MAHASISWA PADA KOLOM KOSONG
NIP/NIU NAMA
FAKULTAS JURUSAN PROGRAM
UNIT
HOME PENGUNJUNG KELUHAN HELP
LogOu
182
Universitas Sumatera Utara
Lampiran 3.7 Tampilan Desain Input Data Keluhan Pengunjung
Fungsi dan keterangan dari Desain form Data Keluhan sebagai berikut :
KLINIK TI UNIVERSITAS SUMATERA UTARA
Jalan Universitas No.9 Pintu 1 Kampus Padang Bulan Medan, Sumatera Utara
LOGO UNIVERSI
TAS
MELAYANI KELUHAN SIVITAS AKADEMIKA UNIVERSITAS SUMATERA UTARA
PENDATAAN KELUHAN
PENGUNJUNG
NIM/NIP/NIU NAMA
FAKULTAS JURUSAN PROGRAM STUDI UNIT KERJA JENIS KELUHAN
KELUHAN
KATEGORI KELUHAN :
NAMA
V V
LogOu
HOME PENGUNJUNG KELUHAN HELP
183
Universitas Sumatera Utara
No Nama Objek Keterangan 1 NIM/NIP/NIU Text box Untuk input Id_Pengunjung 2 Nama Text box Untuk input nama pengunjung 3 Fakultas Text box Untuk input fakultas pengunjung 4 Jurusan Text box Untuk input jurusan pengunjung 5 Program_Studi Text box Untuk input Program studi pengunjung 6 Unit_Kerja Text box Untuk input Unit kerja pengunjung 7 Jenis_Keluhan Combo box Untuk memilih jenis keluhan 8 Kategori_keluhan Combo box Untuk memilih kategori keluhan 9 Keluhan Scroll box Untuk input isi dari keluhan
10 Nama_petugas Text Box Untuk input nama petugas yang menangani
11 Simpan Button Menyimpan data keluhan ke database 12 Batal Button Membatalkan proses data keluhan
13 LogOut Button Untuk Keluar dari form data Keluhan ke Login Masuk
8. Tampilan Desain Form Pendataan Tindakan
184
Universitas Sumatera Utara
Lampiran 3.8. Tampilan Desain Input Data Tindakan
Fungsi dan keterangan dari Desain form Data Tindakan sebagai berikut :
KLINIK TI UNIVERSITAS SUMATERA UTARA
Jalan Universitas No.9 Pintu 1 Kampus Padang Bulan Medan, Sumatera Utara
LOGO UNIVERSI
TAS
MELAYANI KELUHAN SIVITAS AKADEMIKA UNIVERSITAS SUMATERA UTARA
LogOut PENDATAAN TINDAKAN
NIM/NIP/NIU NAMA TANGGAL REGISTRASI :
KELUHAN
TINDAKAN
HASIL/STATUS
V TANGGAL
SELESAI TINDAK LANJUT PETUGAS
LIST REGISTRASI KELUHAN
ID KELUHAN
ID KELUHAN
TGL REGISTRASI
KELUHAN
TINDAKAN
STATUS
PETUGAS
HISTORY TINDAKAN
HOME TINDAKAN HELP
185
Universitas Sumatera Utara
No Nama Objek Keterangan 1 NIM/NIP/NIU Text box Untuk input Id_Pengunjung 2 Nama Text box Untuk input nama Pengunjung 3 Tanggal_Registrasi Text box Tanggal Registrasi (Daftar) 4 Keluhan Scroll box Untuk memasukan data rincian keluhan 5 Tindakan Scroll box Untuk memasukkan data rincian Tindakan
6 Hasil/Status Combo box Memilih hasil seperti Selesai, Tidak Selesai, dan Tunda/Pending
7 Tanggal_Selesai Text box Tanggal Selesainya Tindakan dilakukan
8 Tindak/Lanjut Text box Memasukkan data tindak/lanjut apabila status pending
Petugas_Operator Text box Untuk input nama petugas Operator Simpan Button Simpan data tindakan ke database 9 Batal Button Batalkan proses data
8 LogOut Button Untuk keluar dari form data Tindakan ke Login Masuk
10 List_Registrasi Text box Memunculkan NIM/NIP/NIU Pengunjung
11 History_Tunda/Pending Scroll Text
box Memunculkan History Tunda/Pending dalam pekerjaan Tindakan
Universitas Sumatera Utara
9. Tampilan Desain Form Input User
Lampiran 3.9 Tampilan Desain Form Data User
Fungsi dan keterangan dari Desain form Pendataan User sebagai berikut :
No Nama Objek Keterangan 1 NIP/NIU Text box Untuk input ID_Pegawai 2 Nama Text box Untuk input nama Pegawai 3 Username Tex box Untuk input username login Pegawai 4 Password Text box Untuk input password login Pegawai 5 Level Combo box Untuk memilih Jabatan Pegawai Klinik TI 6 Simpan Button Menyimpan data User ke database 7 Batal Button Membatalkan data User ke database
8 LogOut Button Untuk keluar dari form data tambah User ke Login Masuk
KLINIK TI UNIVERSITAS SUMATERA UTARA
Jalan Universitas No.9 Pintu 1 Kampus Padang Bulan Medan, Sumatera Utara
LOGO UNIVERSI
TAS
MELAYANI KELUHAN SIVITAS AKADEMIKA UNIVERSITAS SUMATERA UTARA
PENDATAAN USER (ISILAH USERNAME DAN PASSWORD PADA KOLOM KOSONG
DIBAWAH INI)
NIP/NIU NAMA
USERNAME PASSWORD LEVEL
V
LogOu
PENGUNJU
KELUH
TINDAK
USE
HEL
LAPOR
HOM
186
Universitas Sumatera Utara
10. Tampilan Desain Form Input Penggantian Password User
Lampiran 3.10 Tampilan Desain Form Penggantian Data Password User
Fungsi dan keterangan dari Desain form Data Password User sebagai berikut :
No Nama Objek Keterangan 1 Username Tex box Untuk input Username Pegawai 2 Password_Lama Text box Untuk input Password lama Pegawai 3 Password_Baru Text box Untuk input Password baru Pegawai
4 Konfirmasi
Password Baru Text box Untuk input Konfirmasi Password baru Pegawai
5 Ganti Button Menyimpan data Password baru User ke database
6 Batal Button Membatalkan proses data
7 LogOut Button Untuk keluar dari form penggantian data Password User ke login masuk
KLINIK TI UNIVERSITAS SUMATERA UTARA
Jalan Universitas No.9 Pintu 1 Kampus Padang Bulan Medan, Sumatera Utara
LOGO UNIVERSI
TAS
MELAYANI KELUHAN SIVITAS AKADEMIKA UNIVERSITAS SUMATERA UTARA
PENGGANTIAN DATA PASSWORD USER (MASUKKAN USERNAME SERTA PASSWORD LAMA DAN BARU
PADA KOLOM KOSONG DIBAWAH INI)
GANTI
PASSWORD
KONFIRMASI PASSWORD BARU :
USERNAME
PASSWORD
LogOu
PENGUNJU
KELUH
TINDAK
USE
HEL
LAPOR
HOM
187
Universitas Sumatera Utara
11. Tampilan Desain Form Input Pencarian Data User
Lampiran 3.11 Tampilan Desain Form Pencarian Data User
Fungsi dan keterangan dari form Pencarian Data User sebagai berikut :
No Nama Objek Keterangan 1 NIP/NIU Tex box Untuk input Id_Pegawai
2 Cari Button Untuk Mencari Data User Pegawai berdasarkan NIP/NIU
3 LogOut Button Untuk keluar dari form Pencarian Data User ke login masuk
4 Daftar_Cari_User Text box Untuk memunculkan data User berdasarkan NIP/NIU
LogOu PENCARIAN DATA USER
(MASUKKAN NIP/NIU PADA KOLOM KOSONG DIBAWAH INI)
CARI
NIP/NIU
NIP/NIU NAMA USERNAME PASSWORD LEVEL
DAFTAR PENCARIAN DATA USER
KLINIK TI UNIVERSITAS SUMATERA UTARA
Jalan Universitas No.9 Pintu 1 Kampus Padang Bulan Medan, Sumatera Utara
LOGO UNIVERSI
TAS
MELAYANI KELUHAN SIVITAS AKADEMIKA UNIVERSITAS SUMATERA UTARA
PENGUNJU
KELUH
TINDAK
USE
HEL
LAPOR
HOM
188
Universitas Sumatera Utara
LAMPIRAN 4
TAMPILAN PERANCANGAN DESAIN OUTPUT
Berikut ini adalah tampilan-tampilan beserta tabel fungsi dan keterangan pada
perancangan desain keluaran pada aplikasi sistem informasi pelayanan teknologi
informasi klinik TI USU.
189
Universitas Sumatera Utara
190
Universitas Sumatera Utara
Fungsi dan keterangan dari tampilan Form Laporan Klinik TI adalah:
Tabel Lampiran 4.2 Fungsi dan Keterangan Form Laporan No Nama Objek Keterangan 1 Ceklist Cek box Untuk menandai Tombol yang akan dipilih 2 Pilih Fakultas Combo box Untuk memilih fakultas
3 Pilih Jenis Keluhan Combo box Untuk memilih jenis keluhan pelayanan
4 Pilih Kategori Combo box Untuk memilih kategori keluhan pengunjung 5 Pilih Hasil Combo box Untuk memilih hasil dari tindakan dilakukan 6 Pilih Operator Combo box Untuk memilih Nama petugas Operator 7 Harcat Radio button Untuk menandai tombol yang akan dipilih
8 Pilih Tanggal Combo box Untuk memilih Tanggal, Bulan, dan Tahun laporan
9 Pilih Bulan Combo box Untuk memilih Bulan dan Tahun laporan 10 Pilih Tahun Combo box Untuk memilih Tahun laporan 11 Cetak Button Untuk mencetak data Laporan 12 Batal Button Untuk membatalkan proses cetak data laporan 13 LogOut Button Untuk keluar dari tampilan form Laporan
191
Universitas Sumatera Utara
192
Universitas Sumatera Utara