DAFTAR PUSTAKA Adelheid, Andrea & Khairi Nst, 2012. Buku Pintar Menguasai PHP MySQL. Jakarta: Mediakita. Anhar, 2010. Panduan Menguasai PHP & MySQL. Jakarta: Mediakita. Kurniawan, Rulianto, 2010. PHP & MySQL untuk orang Awam. Palembang: Maxikom. Madcoms, 2006. Aplikasi Manajemen Database Pendidikan Berbasis Web dengan PHP dan MySQL. Yogyakarta: ANDI. Menteri Pekerjaan Umum, 2011. Peraturan Menteri Pekeraan Umum Nomor: 10/PRT/M/2011 tentang Pedoman Tata Naskah Dinas Kementerian Pekerjaan Umum. Jakarta: Sekretaris Jenderal . Rahajo, Budi, Imam Heryanto, Enjang RK, 2010. Modul Pemrograman Web HTML, PHP & MYSQL. Bandung: Modula. Rizky, Soetama .2011. Konsep Dasar Rekayasa Perangkat Lunak. Jakarta:PT. Prestasi Pustakarya. A.S, Rosa, M. Salahuddin, 2011. Modul Pembelajaran Rekayasa Perangkat Lunak. Bandung: Modula. Tata Sutabri, 2012. Analisa Sistem Informasi. Yogyakarta: ANDI. Widodo, Prabowo Pudjo, 2011. Menggunakan UML. Bandung: Informatika.
64
http://digilib.mercubuana.ac.id/
LAMPIRAN Lembar Disposisi Sekretaris
65
http://digilib.mercubuana.ac.id/
Surat Masuk
66
http://digilib.mercubuana.ac.id/
Agenda Surat Masuk
67
http://digilib.mercubuana.ac.id/
68
http://digilib.mercubuana.ac.id/
69
http://digilib.mercubuana.ac.id/
KODING Login.php
if(
isset($_SESSION['username'])
&&
isset($_SESSION['password'])
&&
isset($_SESSION['jabatan']) ) { header('location:home.php'); } ?>
html
PUBLIC
"-//W3C//DTD
XHTML
1.0
Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
Login here <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <style type="text/css">
Surat_masuk.php
Untitled Page <meta
name="generator"
content="WYSIWYG
Web
Builder
-
http://www.wysiwygwebbuilder.com"> <style type="text/css"> div#container { width: 800px; position: relative; margin: 0 auto 0 auto; text-align: left; } body
72
http://digilib.mercubuana.ac.id/
{ background-color: #FFFFFF; color: #000000; font-family: Arial; font-size: 13px; margin: 0; text-align: center; } <style type="text/css"> a { color: #0000FF; text-decoration: underline; } a:visited { color: #800080; } a:active { color: #FF0000; }
73
http://digilib.mercubuana.ac.id/
a:hover { color: #0000FF; text-decoration: underline; } <style type="text/css"> #NavigationBar2 ul.navbar { list-style: none; margin: 0; padding: 0; } #NavigationBar2 ul.navbar li { height: 22px; float: left; margin: 0 25px 0 0; } #NavigationBar2 ul.navbar li a { display: block; position: relative;
74
http://digilib.mercubuana.ac.id/
} #NavigationBar2 ul.navbar li a img { position: absolute; left: 0; z-index: 1; border-width: 0; } #NavigationBar2 ul.navbar li span { display: block; height: 22px; position: absolute; z-index: 2; } #NavigationBar2_item0 { width: 79px; } #NavigationBar2_item1 { width: 118px; } #NavigationBar2_item2 { width: 131px; } #NavigationBar2_item3 { width: 159px; } #NavigationBar2_item4 { width: 102px; } #NavigationBar2 a .hover { visibility: hidden;
75
http://digilib.mercubuana.ac.id/
} #NavigationBar2 a:hover .hover { visibility: visible; } #NavigationBar2 a:hover span { visibility: hidden; } #wb_Text1 { background-color: transparent; border: 0px #000000 solid; padding: 0; text-align: center; } #wb_Text1 div { text-align: center; } #wb_Text3 { background-color: transparent;
76
http://digilib.mercubuana.ac.id/
border: 0px #000000 solid; padding: 0; text-align: left; } #wb_Text3 div { text-align: left; } #homeImage1 { border: 0px #000000 solid; } #homeImage2 { border: 0px #000000 solid; } #homeImage3 { border: 0px #000000 solid; } #homeImage4 { border: 0px #000000 solid;
77
http://digilib.mercubuana.ac.id/
} .loginform_table { background-color: #EEEEEE; border-color:#98FB98; border-width:1px; border-style: solid; color: #228B22; border-spacing: 4px; font-family: Arial; font-size: 15px; text-align: right; } .loginform_header { background-color: #98FB98; color: #FFFFFF; text-align: center; } .loginform_text { background-color: #FFFFFF; border-color: #228B22;
78
http://digilib.mercubuana.ac.id/
border-width: 1px; border-style: solid; color: #228B22; font-family: Arial; font-size: 15px; } .loginform_button { background-color: #FFFFFF; border-color: #228B22; border-width: 1px; border-style: solid; color: #228B22; font-family: Arial; font-size: 15px; } table, td, th { border: 1px solid green; padding:4px; } <script language="javascript">
79
http://digilib.mercubuana.ac.id/
function do_delete(id_delete,text_delete,lokasi) { var msg = "Yakin akan Menghapus " + text_delete + " akan dihapus. \n" + "Sistem akan menghapus data tersebut secara permanen dan tidak bisa dikembalikan lagi. \n" + "Jika Anda ingin melanjutkan, klik OK atau klik Cancel untuk membatalkan proses penghapusan. \n" ; if (confirm(msg)){ //var loca
= lokasi+"/"+id_delete;
var loca
= lokasi;
var st
= loca;
window.location = st; } }
id="container"
style="border-style:
solid;border-width:
3px;border-
color:#008000;margin-top:10px;width:1000px;padding:10px;">
src="images/logo%20kemenpera.jpg"
id="homeImage1"
alt=""
style="width:130px;height:104px;">
80
http://digilib.mercubuana.ac.id/
<span
style="color:#003264;font-family:Arial;font-
size:20px;"><strong>Sistem
Informasi
Dokument
Management
System
SEKRETARIS KEMENTERIAN PERUMAHAN RAKYAT
style="border-top-style:
solid;border-top-width:
3px;border-
color:#008000;padding-top:20px;">
id="NavigationBar2"
style="height:40px;text-align:center;padding-
left:50px;">
=
isset($_SESSION['jabatan'])
?
$_SESSION['jabatan'] : ''; if ($jabatan=="STAFF") { ?>
DATA SURAT MASUK
style="border:
1px
solid
#008000;border-collapse:
collapse;width:100%;">
No Urut | No Surat | Tgl Surat |
82
http://digilib.mercubuana.ac.id/
Tgl Terima | Asal Surat | Perihal | Jenis Surat | Sifat Surat | Tanggal Input | Lampiran | Aksi |
connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT * from surat_masuk ORDER BY no_urut"; $result = $conn->query($sql);
$conn->close();
if ($result->num_rows > 0) { // output data of each row $a = 1;
83
http://digilib.mercubuana.ac.id/
while($row = $result->fetch_assoc()) { //print_r($row); //echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "
"; echo ""; // echo " " . $row["no_urut"] . " | "; echo "" . ( strlen($a) > 1 ? $a : "0" . $a) . " | "; echo " " . $row["no_surat"] . " | "; echo " " . $row["tgl_surat"] . " | "; echo " " . $row["tgl_terima"] . " | "; echo " " . $row["asal_surat"] . " | "; echo " " . $row["perihal"] . " | "; echo " " . $row["jenis_surat"] . " | "; echo " " . $row["sifat_surat"] . " | "; echo " " . $row["tgl_input"] . " | "; echo "
target=new>" . $row["lampiran"] . " | "; //echo href=\"editform.php?id=".$row['no_urut']."\">
"
Edit
|
href=\"hapus_sm.php?id=".$row['no_urut']."\">Hapus | "; ?> "> Edit |
84
http://digilib.mercubuana.ac.id/
echo
$row['no_urut'];?>','
href="#" echo
$row['perihal'];?>','hapus_sm.php?id=')"> Hapus | "; $a++; } } else { echo "
"; echo " 0 results | "; echo "
"; } ?>