Lampiran 1 : Struktur organisasi PT. Tiga Manunggal...
Transcript of Lampiran 1 : Struktur organisasi PT. Tiga Manunggal...
42
Lampiran 1 : Struktur organisasi PT. Tiga Manunggal Synthetic Industries
43
Lampiran 2: Sub Struktur organisasi PT. Tiga Manunggal Synthetic Industries
44
Lampiran 3: Halaman Login dan Halaman Utama
45
Lampiran 4: Halaman Input Pembelian dan Tambah Supplier
46
Lampiran 5 : Halaman Tambah Barang dan Daftar Supplier
47
Lampiran 6 : Halaman Daftar Bahan Kimia dan Laporan Kartu Utang
48
Lampiran 7 : Coding untuk menjalankan program
Login.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Login Admin</title>
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body background="g13.jpg" >
<div align="center">
<img src="timatex.jpg" style="height:200px;width:200px;" />
<form id="form1" name="form1" method="post" action="proseslogin.php">
<font size="6" class="merah"></font><br /><br /><br /><br />
<table width="398" border="0" style="border: 2px solid gray; border-radius: 10px 10px
10px 10px; background: blue;">
<tr>
<td height="27" colspan="2" valign="top"><div align="center" class="merah">
<table width="392" border="0">
<tr>
<td></td>
<td> </td>
</tr>
<tr>
<td width="192"><div align="left" class="putih"><strong>
Silahkan Login</strong></div></td>
</tr>
</table>
</div></td>
</tr>
<tr >
<td height="26" colspan="2" valign="top"><div align="center">
<br /><span class="hijau"><strong>
<?php
if(isset($_GET['status'])){
$status = $_GET['status'];
}
else{
$status = "";
}
echo "<blink>$status</blink>";
?>
</strong></span><br><br>
<table width="303" border="0">
<tr>
<td><span class="putih"><strong>Username </strong></span></td>
<td><div align="right"><span class="putih"><strong> :
<input name="username" type="text" />
</strong></span></div></td>
</tr>
<tr>
<td><span class="putih"><strong>Password </strong></span></td>
<td><div align="right"><span class="putih"><strong>:
<input name="password" type="password" />
</strong></span></div></td>
</tr>
<tr></tr><tr></tr><tr></tr><tr></tr>
<tr>
<td> </td>
49
<td><input name="input" type="submit" value="Login" />
<input name="input" type="reset" /></td>
</tr>
</table>
</div></td>
</tr>
<tr >
<td></td>
</tr>
</table>
<br><br><h6 class="abu_abu">Copyright © Ulfa</h6>
<p> </p>
</form>
</div>
</body>
</html>
Proseslogin.php <?php
session_start();
$username = $_POST['username'];
$password = $_POST['password'];
include("config.php");
if (empty($username) || empty($password))
{
header("location:login.php?status=Maaf, semua field harus diisi");
}
else{
$sql = "SELECT * FROM login WHERE username = '$username' AND password = '$password'";
$hasil = mysql_query($sql, $koneksi);
$record = mysql_fetch_array($hasil);
if($record['username'] == ""){
header("location:login.php?status=Maaf, username dan password tidak valid");
exit();
}
if($record['username']){
$_SESSION['username'] = $username;
header ("location:index.php");
}
}
?>
Index.php <?php
session_start();
if(!isset($_SESSION['username'])){
header("location:login.php");
exit();
}
if(isset($_SESSION['username'])){
$username = $_SESSION['username'];
}
include "config.php";
?>
<html>
<head><title>welcome ulfa</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Welcome PT.Timatex</title>
<link rel="stylesheet" type="text/css" href="style.css">
<link rel="stylesheet" href="styles.css" type="text/css"/>
</head>
<body background="tm1.jpg">
50
<div id="container" align="center">
<div id='cssmenu'>
<ul>
<li class='active has-sub'><a href='#'><span>Profile</span></a>
<ul>
<li class='has-sub'><a href='about.php'><span>Sejarah Perusahaan</span></a></li>
<li class='has-sub'><a href='bidang.php'><span>Bidang Usaha, Visi dan
Misi</span></a></li>
<li class='has-sub'><a href='struktur.php'><span>Struktur Organisasi</span></a></li>
</ul></li>
<li class='active has-sub'><a href='#'><span>Daftar Barang</span></a>
<ul>
<li class='has-sub'><a href='BP.php'><span>Bahan Kimia</span></a></li>
</ul></li>
<li><a href='daftar_supplier.php'><span>Daftar Supplier</span></a>
<li class='active has-sub'><a href='#'><span>Pembelian</span></a>
<ul>
<li class='has-sub'><a href='suplai.php'><span>Pembelian Barang</span></a></li>
</ul></li>
<li class='active has-sub'><a href='#'><span>Laporan</span></a>
<ul>
<li class='has-sub'><a href='mutasi.php'><span>Mutasi Stock Bahan
Kimia</span></a></li>
<li class='has-sub'><a href='kartu_utang.php'><span>Kartu Utang</span></a></li>
</ul></li>
<li><a href='logout.php'><span>Logout</span></a>
</ul>
</div>
</div>
</body>
</html>
Suplai.php <html>
<head>
<link rel="stylesheet" href="styles.css" type="text/css"/>
<title> penyuplaian</title>
<link href="jquery-ui-1.11.2.custom/jquery-ui.css" type="text/css"
rel="stylesheet">
<script src="jquery-ui-1.11.2.custom/external/jquery/jquery.js"></script>
<script src="jquery-ui-1.11.2.custom/jquery-ui.js"></script>
<script>
$(function() {
$("#datepicker").datepicker({dateFormat: 'yy-mm-dd'});
});
</script>
<script> function hapus (){if (confirm('Anda Yakin Ingin Hapus?')){
return true;} else{return false;}} </script>
</head>
<body background="warna7.jpg">
<div id="container">
<div id='cssmenu'>
<ul>
<li class='active has-sub'><a href='#'><span>Profile</span></a>
<ul>
<li class='has-sub'><a href='about.php'><span>Sejarah Perusahaan</span></a></li>
<li class='has-sub'><a href='bidang.php'><span>Bidang Usaha, Visi dan
Misi</span></a></li>
<li class='has-sub'><a href='struktur.php'><span>Struktur Organisasi</span></a></li>
</ul></li>
<li class='active has-sub'><a href='#'><span>Daftar Barang</span></a>
<ul>
51
<li class='has-sub'><a href='BP.php'><span>Bahan Kimia</span></a></li></ul></li>
<li><a href='daftar_supplier.php'><span>Daftar Supplier</span></a>
<li class='active has-sub'><a href='#'><span>Pembelian</span></a>
<ul>
<li class='has-sub'><a href='suplai.php'><span>Pembelian Barang</span></a></li>
</ul></li>
<li class='active has-sub'><a href='#'><span>Laporan</span></a>
<ul>
<li class='has-sub'><a href='mutasi.php'><span>Mutasi Stock Bahan
Kimia</span></a></li>
<li class='has-sub'><a href='kartu_utang.php'><span>Kartu Utang</span></a></li>
</ul></li>
<li><a href='logout.php'><span>Logout</span></a>
</ul>
</div>
<table>
<tr><td><img src="timatex.jpg" style="height:200px;width:200px;"><br></td>
<td><center><blink>
<h1>TRANSAKSI PEMBELIAN BARANG</h1></blink></center>
</td></tr>
<tr><td></td>
<td>
<?php
include"konek.php";
error_reporting(0);
echo"
<form action=simpan_suplai.php method=POST>
<table>
<tr>
<td><b>No Suplai</b></td>
<td bgcolor='black'><input type=text size=23 name='no_suplai'></td>   
<td></td><td></td><td></td><td></td>
<td></td><td></td><td></td><td></td>
<td><b>Tgl suplai</b></td>   
<td bgcolor='black'><input type=text name='tgl_suplai' id=\"datepicker\"></td>
</tr>
<tr></tr><tr></tr><tr></tr>
<tr>
<td><b>Id Supplier</b></td>
<td><select name='id_supplier'><option value''>Pilih Id Supplier</option>";
$query=mysql_query("SELECT id_supplier, nama_supplier from supplier",$connection);
while($a=mysql_fetch_array($query)){
echo "<option value=".$a['id_supplier'].">".$a['id_supplier']." -
".$a['nama_supplier']."</option>";
}
echo "<td><a href=supplier.php>Supplier Baru?</a></td>
</tr>
</tr>
<tr></tr><tr></tr><tr></tr>
<tr>
<td><b>Id Barang</b></td>
<td><select name='id_barang'><option value''>Pilih Id Barang</option>";
$query=mysql_query("SELECT id_barang, nama_barang from bahan_kimia ",$connection);
while($a=mysql_fetch_array($query)){
echo "<option value=".$a['id_barang'].">".$a['id_barang']." -
".$a['nama_barang']."</option>";
}
echo "<td><a href=barang2.php>Barang Baru?</a></td></tr>
<tr></tr><tr></tr><tr></tr>
<tr>
<td><b>Harga Beli</b></td>
<td bgcolor='black'><input type=text size=23 name='harga_beli'></td>
<td>Isikan dalam USD ($)</td></tr>
52
<tr></tr><tr></tr><tr></tr>
<tr>
<td><b>Kuantitas</b></td>
<td bgcolor='black'><input type=text size=23 name='kuantitas'></td>
</tr>
<tr></tr><tr></tr><tr></tr>
<tr>
<td><b>Satuan</b></td>
<td bgcolor='black'><input type=text size=23 name='satuan'></td>
</tr>
<tr></tr><tr></tr><tr></tr>
<tr>
<td><input type=submit value='Simpan'></td>
<td></td>
</tr>
</table>
</form>";
?>
<table border="5" cellpadding="3" bgcolor="#FF6699" >
<font color=black>
<tr height="25" bgcolor="#00CCFF">
<td rowspan="1" valign="middle"><b><center>No Suplai</center></b></td>
<td rowspan="1" valign="middle"><b><center>Tgl Suplai</center></b></td>
<td rowspan="1" valign="middle"><b><center>Id Supplier</center></b></td>
<td rowspan="1" valign="middle"><b><center>Id & Nama Barang</center></b></td>
<td rowspan="1" valign="middle"><b><center>Harga Beli</center>
</b></td>
<td rowspan="1" valign="middle"><b><center>Kuantitas</center></b></td>
<td rowspan="1" valign="middle"><b><center>Satuan</center></b></td>
<td rowspan="1" valign="middle"><b><center>Subtotal</center></b></td>
</tr>
</font>
<?php
include"konek.php";
$query=mysql_query ("SELECT * FROM penyuplaian p, suplai_barang sb where
p.no_suplai=sb.no_suplai order by p.no_suplai ", $connection);
while($a=mysql_fetch_array($query)){ $query2=mysql_query("SELECT nama_barang from
bahan_kimia where id_barang='$a[id_barang]' UNION SELECT nama_barang from bahan_kimia
where id_barang='$a[id_barang]'",$connection);
while($b=mysql_fetch_array($query2)){
$nama_barang=$b['nama_barang'];
}
echo"
<tr>
<td>$a[no_suplai]</td>
<td>$a[tgl_suplai]</td>
<td>$a[id_supplier]</td>
<td>$a[id_barang]"." - ".$nama_barang."</td>
<td>$a[harga_beli]</td>
<td>$a[kuantitas]</td>
<td>$a[satuan]</td>
<td>$a[subtotal]</td>
<td align=center><a href=edit_suplai.php?id=$a[no_suplai]>Edit</a></td>
<td align=center><a href=\"hapus_suplai.php?id=$a[no_suplai]\" onClick=\"return
hapus();\">Hapus</a></td>
</tr>";
}
?>
</table>
</td>
</tr>
</table>
53
</body>
</html>
Update_suplai.php <html>
<head>
<link rel="stylesheet" href="styles.css" type="text/css"/>
<title>update penyuplaian</title>
</head>
<?php
include"konek.php";
$id = $_GET['id'];
$id_supplier = $_POST['id_supplier'];
$id_barang= $_POST['id_barang'];
$harga_beli = $_POST['harga_beli'];
$kuantitas= $_POST['kuantitas'];
$subtotal = $_POST['kuantitas']*$_POST['harga_beli'];
$query=mysql_query ("UPDATE suplai_barang SET id_barang='$id_barang',
harga_beli='$harga_beli', kuantitas='$kuantitas', subtotal='$subtotal' WHERE
no_suplai='$id'",$connection)or die (mysql_error());
if($query) {
?>
<<script language="JavaScript">
document.location='suplai.php'</script>
<?php
}
?>
Simpan_suplai.php <?php
include"konek.php";
error_reporting(0);
$no_suplai = $_POST['no_suplai'];
$tgl_suplai = $_POST['tgl_suplai'];
$id_supplier = $_POST['id_supplier'];
$id_barang = $_POST['id_barang'];
$harga_beli = $_POST['harga_beli'];
$kuantitas = $_POST['kuantitas'];
$satuan = $_POST['satuan'];
$subtotal = $_POST['kuantitas']*$_POST['harga_beli'];
$query=mysql_query ("INSERT INTO suplai_barang(id_barang, no_suplai, harga_beli,
kuantitas, satuan, subtotal)
VALUES ('$id_barang','$no_suplai', '$harga_beli','$kuantitas', '$satuan',
'$subtotal')",$connection);
$query=mysql_query ("INSERT INTO penyuplaian(no_suplai, tgl_suplai, id_supplier)
VALUES ('$no_suplai', '$tgl_suplai','$id_supplier')",$connection);
if($query) {
?>
<script language="JavaScript">
document.location='suplai.php'</script>
<?php
}
?
Edit_suplai.php <html>
<head>
<link rel="stylesheet" href="myproject2.css" type="text/css"/>
<title>edit penyuplaian</title>
</head><div id="wrapper2"
<body >
<?php
54
echo "<title>Update Entry</title>";
include"konek.php";
$id = $_GET['id'];
$query=mysql_query ("SELECT * FROM penyuplaian p, suplai_barang sb WHERE
p.no_suplai=sb.no_suplai AND p.no_suplai='$id'");
while ($row=mysql_fetch_array($query)){
$no_suplai = $row['no_suplai'];
$id_supplier = $row['id_supplier'];
$id_barang= $row['id_barang'];
$harga_beli = $row['harga_beli'];
$kuantitas= $row['kuantitas'];
$subtotal = $row['subtotal'];
echo"
<center><font color=blue>
<h3><hr width=400 size=3>Edit Daftar Penyuplaian
<hr width=400 size=3></h3></font>
<form method=\"post\" action=\"update_suplai.php?id=$id\" enctype='multipart/form-data'>
<input type=hidden name=id value=$id_barang>
<table>
<tr>
<td>No Suplai</td><td>:</td><td><input type=text
name='No' value='$no_suplai'></td>
</tr>
<tr>
<td>Id Supplier</td><td>:</td><td><input type=text
name='id_supplier' value='$id_supplier'></td>
</tr>
<tr>
<td>Id Barang</td><td>:</td>
<td><input type=text name='id_barang' value='$id_barang'></font></td>
<tr>
<td>Harga Beli</td><td>:</td><td><input type=text
name='harga_beli' value='$harga_beli'></font></td>
</tr>
<tr>
<td>Kuantitas</td><td>:</td><td><input type=text
name='kuantitas' value='$kuantitas'></font></td>
</tr>
</table><br>
<input type=submit value=UPDATE><input type=button value=BATAL
onClick=self.history.back()>
</form>
<hr width=400 size=5>";
}
?>
</body>
</html>
Hapus_suplai.php <?php
include"konek.php";
mysql_query("DELETE FROM penyuplaian WHERE no_suplai='$_GET[id]'");
mysql_query("DELETE FROM suplai_barang WHERE no_suplai='$_GET[id]'");
header("location:suplai.php");
BP.php <html>
<head>
<link rel="stylesheet" href="styles.css" type="text/css"/>
<title> Bahan Pembantu</title>
<script> function hapus (){if (confirm('Anda Yakin Ingin Hapus?')){
return true;} else{return false;}} </script>
</head>
55
<body background="kimia1.jpg" >
<div id="container">
<div id='cssmenu'>
<ul>
<li class='active has-sub'><a href='#'><span>Profile</span></a>
<ul>
<li class='has-sub'><a href='about.php'><span>Sejarah Perusahaan</span></a></li>
<li class='has-sub'><a href='bidang.php'><span>Bidang Usaha, Visi dan
Misi</span></a></li>
<li class='has-sub'><a href='struktur.php'><span>Struktur Organisasi</span></a></li>
</ul></li>
<li class='active has-sub'><a href='#'><span>Daftar Barang</span></a>
<ul>
<li class='has-sub'><a href='BP.php'><span>Bahan Kimia</span></a></li>
</ul></li>
<li><a href='daftar_supplier.php'><span>Daftar Supplier</span></a>
<li class='active has-sub'><a href='#'><span>Pembelian</span></a>
<ul>
<li class='has-sub'><a href='suplai.php'><span>Pembelian Barang</span></a></li>
</ul></li>
<li class='active has-sub'><a href='#'><span>Laporan</span></a>
<ul>
<li class='has-sub'><a href='mutasi.php'><span>Mutasi Stock Bahan
Kimia</span></a></li>
<li class='has-sub'><a href='kartu_utang.php'><span>Kartu Utang</span></a></li>
</ul></li>
<li><a href='logout.php'><span>Logout</span></a>
</ul>
</div>
<table>
<tr><td><img src="timatex.jpg" style="height:200px;width:200px;"><br></td>
<td><center><blink>
<h1>DAFTAR BAHAN KIMIA</h1></blink></center></td></tr>
<tr>
<td></td><td>
<table border="5" cellpadding="3" bgcolor="#CC6633" >
<font color=black>
<tr height="25" bgcolor="#666633">
<td rowspan="1" valign="middle"><b><center>Id Barang</center></b></td>
<td rowspan="1" valign="middle"><b><center>Nama Barang</center></b></td>
<td rowspan="1" valign="middle"><b><center>Harga Beli</center></b>
</td>
<td rowspan="1" valign="middle"><b><center>Stock Awal</center></b></td>
<td rowspan="1" valign="middle"><b><center>Stock Akhir</center></b></td>
<td rowspan="1" valign="middle"><b><center>Satuan</center></b></td>
</tr>
</font>
<?php
include"konek.php";
$no=1;
$query=mysql_query ("SELECT * FROM bahan_kimia", $connection)or die (mysql_error());
while($a=mysql_fetch_array($query)){
echo"
<tr>
<td>$a[id_barang]</td>
<td>$a[nama_barang]</td>
<td>$a[harga_beli]</td>
<td>$a[stock_awal]</td>
<td>$a[stock_akhir] </td>
<td>$a[satuan] </td>
<td align=center><a href=edit_BP.php?id=$a[id_barang]>Edit</a></td>
<td align=center><a href=\"hapus_BP.php?id=$a[id_barang]\" onClick=\"return hapus();\">
Hapus</a></td>
</tr>";
56
}
?>
</center>
</td>
</tr>
</table>
</body>
</html>
Input_BP.php <?php
include "konek.php";
error_reporting(0);
$id_barang = $_POST['id_barang'];
$nama_barang = $_POST['nama_barang'];
$harga_beli = $_POST['harga_beli'];
$stock_awal = $_POST['stock_awal'];
$stock_akhir = $_POST['stock_akhir'];
$satuan = $_POST['satuan'];
$query=mysql_query ("INSERT INTO bahan_kimia(id_barang, nama_barang, harga_beli,
stock_awal, stock_akhir, satuan)
VALUES ('$id_barang','$nama_barang', '$harga_beli', '$stock_awal', '$stock_akhir',
'$satuan')",$connection);
if($query) {
header("location:barang2.php?status=DATA TELAH BERHASIL DISIMPAN");
}
else{
header("location:barang2.php?status=MAAF DATA GAGAL DISIMPAN");
}
?>
Edit_BP.php <html>
<head>
<link rel="stylesheet" href="myproject2.css" type="text/css"/>
<title>edit bahan kimia</title>
</head>
<div id="wrapper2">
<?php
echo "<title>Update Entry</title>";
include"konek.php";
$id = $_GET['id'];
$query=mysql_query ("SELECT * FROM bahan_kimia WHERE id_barang='$id'");
while ($row=mysql_fetch_array($query)){
$nama_barang = $row['nama_barang'];
$harga_beli = $row['harga_beli'];
$stock_awal = $row['stock_awal'];
$stock_akhir = $row['stock_akhir'];
$satuan = $row['satuan'];
echo"
<center>
<center><font color=blue>
<h3><hr width=400 size=3>Edit Daftar Bahan Kimia
<hr width=400 size=3></h3></font>
<form method=\"post\" action=\"update_BP.php?id=$id\" enctype='multipart/form-data'>
<input type=hidden name=id value=$id_barang>
<table>
<tr>
<td>Nama Barang</td><td>:</td><td><input type=text
name='nama_barang' value='$nama_barang'></td>
</tr>
<tr>
<td>Harga Beli</td><td>:</td><td><input type=text
57
name='harga_beli' value='$harga_beli'></td>
</tr>
<tr>
<td>Stock Awal</td><td>:</td><td><input type=text
name='stock_awal' value='$stock_awal'></td>
</tr>
<tr>
<td>Stock Akhir</td><td>:</td><td><input type=text
name='stock_akhir' value='$stock_akhir'></td>
</tr>
<tr>
<td>Satuan</td><td>:</td><td><input type=text
name='satuan' value='$satuan'></td>
</tr>
</table><br>
<input type=submit value=UPDATE><input type=button value=BATAL
onClick=self.history.back()>
</form>
</center>
<hr width=400 size=5>";
}
?>
</div>
</html>
Hapus_BP.php <?php
include"konek.php";
mysql_query("DELETE FROM bahan_kimia WHERE id_barang='$_GET[id]'");
header("location:BP.php");
?>
Supplier.php <html>
<head>
<link rel="stylesheet" href="styles.css" type="text/css"/>
<title> Supplier</title>
</head>
<body background="g7.jpg">
<div id="container">
<div id='cssmenu'>
<ul>
<li class='active has-sub'><a href='#'><span>Profile</span></a>
<ul>
<li class='has-sub'><a href='about.php'><span>Sejarah Perusahaan</span></a></li>
<li class='has-sub'><a href='bidang.php'><span>Bidang Usaha, Visi dan
Misi</span></a></li>
<li class='has-sub'><a href='struktur.php'><span>Struktur Organisasi</span></a></li>
</ul></li>
<li class='active has-sub'><a href='#'><span>Daftar Barang</span></a>
<ul>
<li class='has-sub'><a href='BP.php'><span>Bahan Kimia</span></a></li>
</ul></li>
<li><a href='daftar_supplier.php'><span>Daftar Supplier</span></a>
<li class='active has-sub'><a href='#'><span>Pembelian</span></a>
<ul>
<li class='has-sub'><a href='suplai.php'><span>Pembelian Barang</span></a></li>
</ul></li>
<li class='active has-sub'><a href='#'><span>Laporan</span></a>
<ul>
<li class='has-sub'><a href='mutasi.php'><span>Mutasi Stock Bahan
Kimia</span></a></li>
<li class='has-sub'><a href='kartu_utang.php'><span>Kartu Utang</span></a></li>
58
</ul></li>
<li><a href='logout.php'><span>Logout</span></a>
</ul>
</div>
<table >
<tr><td><img src="timatex.jpg" style="height:200px;width:200px;"><br></td>
<td><center><blink>
<h1>TAMBAH SUPPLIER</h1></blink></center>
</td></tr>
<tr>
<td></td><td>
<?php
include"konek.php";
error_reporting(0);
echo"<form action=input_supplier.php method=POST>
<table>
<td><b>Id Supplier</b></td>
<td bgcolor='black'><input type=text name='id_supplier'></td></tr>
<tr>
<td><b>Nama Supplier</b></td>
<td bgcolor='black'><input type=text name='nama_supplier'></td>
</tr>
<tr>
<td><b>Alamat</b></td>
<td bgcolor='black'><input type=text name='alamat'></td>
</tr>
<tr>
<td><b>Telepon</b></td>
<td bgcolor='black'><input type=text name='telp'></td>
</tr>
<tr></tr><tr></tr><tr></tr>
<tr></tr><tr></tr><tr></tr>
<tr>
<td><input type=submit value=Simpan></td>
</tr>
</table>
</form>
</center>";
?>
<center><font color="#FF0000">
<?php
if(isset($_GET['status'])){
$status = $_GET['status'];
}
else{
$status = "";
}
echo "<blink>$status</blink>";
?>
</font></center>
</td>
</tr>
</table>
</body>
</html>
Input_supplier.php <?php
include "konek.php";
error_reporting(0);
$id_supplier = $_POST['id_supplier'];
$nama_supplier = $_POST['nama_supplier'];
$alamat = $_POST['alamat'];
$telp = $_POST['telp'];
59
$query=mysql_query ("INSERT INTO supplier(id_supplier, nama_supplier, alamat, telp)
VALUES ('$id_supplier','$nama_supplier', '$alamat', '$telp')",$connection);
if($query) {
header("location:supplier.php?status=DATA TELAH BERHASIL DISIMPAN");
}
else{
header("location:supplier.php?status=MAAF DATA GAGAL DISIMPAN");
}
?>
Update_supplier.php <html>
<head>
<link rel="stylesheet" href="styles.css" type="text/css"/>
<title>update daftar supplier</title>
</head>
<?php
include "konek.php";
$id = $_GET['id'];
$id_supplier = $_POST['id_supplier'];
$nama_supplier = $_POST['nama_supplier'];
$alamat = $_POST['alamat'];
$telp = $_POST['telp'];
$query=mysql_query ("UPDATE supplier SET nama_supplier='$nama_supplier',
alamat='$alamat', telp='$telp'
WHERE id_supplier='$id'",$connection)or die (mysql_error());
if($query) {
?>
<script language="JavaScript">
document.location='daftar_supplier.php'</script>
<?php
}
?>
Daftar_supplier.php <html>
<head>
<link rel="stylesheet" href="styles.css" type="text/css"/>
<title> Daftar Supplier</title>
<script> function hapus (){if (confirm('Anda Yakin Ingin Hapus?')){
return true;} else{return false;}} </script>
</head>
<body background="g9.jpg">
<div id="container">
<div id='cssmenu'>
<ul>
<li class='active has-sub'><a href='#'><span>Profil</span></a>
<ul>
<li class='has-sub'><a href='about.php'><span>Tentang Perusahaan</span></a></li>
<li class='has-sub'><a href='struktur.php'><span>Struktur Organisasi</span></a></li>
</ul></li>
<li class='active has-sub'><a href='#'><span>Daftar Barang</span></a>
<ul>
<li class='has-sub'><a href='BP.php'><span>Bahan Kimia</span></a></li>
</ul></li>
<li><a href='Daftar_Supplier.php'><span>Daftar Supplier</span></a>
<li class='active has-sub'><a href='#'><span>Pembelian</span></a>
<ul>
<li class='has-sub'><a href='suplai.php'><span>Pembelian Barang</span></a></li>
</ul></li>
<li class='active has-sub'><a href='#'><span>Laporan</span></a>
<ul>
60
<li class='has-sub'><a href='mutasi.php'><span>Mutasi Stock Bahan
Kimia</span></a></li>
<li class='has-sub'><a href='kartu_utang.php'><span>Kartu Utang</span></a></li>
</ul></li>
<li><a href='logout.php'><span>Logout</span></a>
</ul>
</div>
<table>
<tr><td>
<img src="timatex.jpg" style="height:200px;width:200px;"><br></td>
<td><center><blink>
<h1>DAFTAR SUPPLIER</h1></blink></center>
</td></tr>
<tr>
<td></td><td>
<table border="5" cellpadding="3" bgcolor="#FF99CC" >
<font color=black>
<tr height="25" bgcolor="#3399FF">
<td rowspan="1" valign="middle"><b><center>Id Supplier</center></b></td>
<td rowspan="1" valign="middle"><b><center>Nama Supplier</center></b></td>
<td rowspan="1" valign="middle"><b><center>Alamat</center></b></td>
<td rowspan="1" valign="middle"><b><center>Telepon</center></b></td>
</tr>
</font>
<?php
include"konek.php";
$query=mysql_query ("SELECT * FROM supplier order by id_supplier ", $connection)or die
(mysql_error());
while($a=mysql_fetch_array($query)){
echo"
<tr>
<td>$a[id_supplier]</td>
<td>$a[nama_supplier]</td>
<td>$a[alamat]</td>
<td>$a[telp]</td>
<td align=center><a href=edit_supplier.php?id=$a[id_supplier]>Edit</a></td>
<td align=center><a href=\"hapus_supplier.php?id=$a[id_supplier]\" onClick=\"return
hapus();\">
Hapus</a></td>
</tr>";
}
?>
</table>
</center>
</td>
</tr>
</table>
</body>
</html>
Edit_supplier.php <html>
<head>
<link rel="stylesheet" href="myproject2.css" type="text/css"/>
<title>edit daftar supplier</title>
</head><div id="wrapper2"
<?php
echo "<title>Update Entry</title>";
include"konek.php";
$id = $_GET['id'];
$query=mysql_query ("SELECT * FROM supplier WHERE id_supplier='$id'");
while ($row=mysql_fetch_array($query)){
$id_supplier = $row['id_supplier'];
61
$nama_supplier = $row['nama_supplier'];
$alamat = $row['alamat'];
$telp = $row['telp'];
echo"
<center>
<center><font color=blue>
<h3><hr width=400 size=3>Edit Daftar Supplier
<hr width=400 size=3></h3></font>
<center><form method=\"post\" action=\"update_supplier.php?id=$id\"
enctype='multipart/form-data'>
<input type=hidden name=id value=$id_supplier>
<table>
<tr>
<td>Id Supplier</td><td>:</td><td><input type=text name='id_supplier'
value='$id_supplier'></td>
</tr>
<tr>
<td>Nama Supplier</td><td>:</td><td><input type=text
name='nama_supplier' value='$nama_supplier'></td>
</tr>
<tr>
<td>Alamat</td><td>:</td><td><input type=text
name='alamat' value='$alamat'></td>
</tr>
<tr>
<td>Telepon</td><td>:</td><td><input type=text
name='telp' value='$telp'></td>
</tr>
</table><br>
<input type=submit value=UPDATE><input type=button value=BATAL
onClick=self.history.back()>
</form>
</center>
<hr width=400 size=5>";
}
?>
</html>
Hapus_supplier.php <?php
include"konek.php";
mysql_query("DELETE FROM supplier WHERE id_supplier='$_GET[id]'");
header("location:daftar_supplier.php");
?>
62
Barang2.php <html>
<head>
<link rel="stylesheet" href="styles.css" type="text/css"/>
<title> Bahan Pembantu</title>
</head>
<body background="kimia3.jpg">
<div id="container">
<div id='cssmenu'>
<ul>
<li class='active has-sub'><a href='#'><span>Profile</span></a>
<ul>
<li class='has-sub'><a href='about.php'><span>Sejarah Perusahaan</span></a></li>
<li class='has-sub'><a href='bidang.php'><span>Bidang Usaha, Visi dan
Misi</span></a></li>
<li class='has-sub'><a href='struktur.php'><span>Struktur Organisasi</span></a></li>
</ul></li>
<li class='active has-sub'><a href='#'><span>Daftar Barang</span></a>
<ul>
<li class='has-sub'><a href='BP.php'><span>Bahan Kimia</span></a></li>
</ul></li>
<li><a href='daftar_supplier.php'><span>Daftar Supplier</span></a>
<li class='active has-sub'><a href='#'><span>Pembelian</span></a>
<ul>
<li class='has-sub'><a href='suplai.php'><span>Pembelian Barang</span></a></li>
</ul></li>
<li class='active has-sub'><a href='#'><span>Laporan</span></a>
<ul>
<li class='has-sub'><a href='mutasi.php'><span>Mutasi Stock Bahan
Kimia</span></a></li>
<li class='has-sub'><a href='kartu_utang.php'><span>Kartu Utang</span></a></li>
</ul></li>
<li><a href='logout.php'><span>Logout</span></a>
</ul>
</div>
<table>
<tr><td><img src="timatex.jpg" style="height:130px;width:130px;"><br></td>
<td><center><blink><h1>TAMBAH BAHAN KIMIA</h1></blink></center></td></tr>
<tr><td></td><td>
<?php
include"konek.php";
echo"
<form action=input_bahan_kimia.php method=POST>
<table>
<tr>
<td><b>Id Barang</b></td>
<td bgcolor='black'><input type=text
name='id_barang'></td><td></td><td></td><td></td><td></td>
<td><b>Harga Beli</b></td>
<td bgcolor='black'><input type=text name='harga_beli'></td>
</tr>
<tr>
<td><b>Nama Barang</b></td>
<td bgcolor='black'><input type=text
name='nama_barang'></td><td></td><td></td><td></td><td></td>
<td><b>Satuan</b></td>
<td bgcolor='black'><input type=text name='satuan'></td>
</tr>
<tr>
<td><b>Stock Awal</b></td>
<td bgcolor='black'><input type=text
name='stock_awal'></td><td></td><td></td><td></td><td></td>
<td><b>Stock Akhir</b></td>
<td bgcolor='black'><input type=text name='stock_akhir'></td>
63
</tr>
<tr></tr><tr></tr><tr></tr>
<tr></tr><tr></tr><tr></tr>
<tr></tr><tr></tr><tr></tr>
<tr></tr><tr></tr><tr></tr>
<tr>
<td><input type=submit value=Simpan></td>
</tr>
</table>
</form>
</center>";
?>
<center><font color="#FF0000">
<?php
if(isset($_GET['status'])){
$status = $_GET['status'];
}
else{
$status = "";
}
echo "<blink>$status</blink>";
?>
</font></center>
</td>
</tr>
</table>
</body>
</html>
Update_BP.php <html>
<head>
<link rel="stylesheet" href="styles.css" type="text/css"/>
<title>update barang bahan pokok</title>
</head>
<?php
include "konek.php";
$id = $_GET['id'];
$nama_barang = $_POST['nama_barang'];
$harga_beli = $_POST['harga_beli'];
$stock_awal = $_POST['stock_awal'];
$stock_akhir = $_POST['stock_akhir'];
$satuan = $_POST['satuan'];
$query=mysql_query ("UPDATE bahan_kimia SET nama_barang='$nama_barang',
harga_beli='$harga_beli', stock_awal='$stock_awal' , stock_akhir='$stock_akhir',
satuan='$satuan' WHERE id_barang='$id'",$connection)or die (mysql_error());
if($query) {
?>
<script language="JavaScript">
document.location='BP.php'</script>
<?php
}
?>
Input_bahan_kimia.php <?php
include "konek.php";
error_reporting(0);
$id_barang = $_POST['id_barang'];
$nama_barang = $_POST['nama_barang'];
$harga_beli = $_POST['harga_beli'];
$stock_awal = $_POST['stock_awal'];
$stock_akhir = $_POST['stock_akhir'];
64
$satuan = $_POST['satuan'];
$query=mysql_query ("INSERT INTO bahan_kimia(id_barang, nama_barang, harga_beli,
stock_awal, stock_akhir, satuan)
VALUES ('$id_barang','$nama_barang', '$harga_beli', '$stock_awal', '$stock_akhir',
'$satuan')",$connection);
if($query) {
header("location:barang2.php?status=DATA TELAH BERHASIL DISIMPAN");
}
else{
header("location:barang2.php?status=MAAF DATA GAGAL DISIMPAN");
}
?>
Kartu_utang.php <html>
<head>
<title> Kartu Utang</title>
<link rel="stylesheet" type="text/css" href="style.css">
<link rel="stylesheet" href="styles.css" type="text/css"/>
<link href="jquery-ui-1.11.2.custom/jquery-ui.css" type="text/css"
rel="stylesheet">
<script src="jquery-ui-1.11.2.custom/external/jquery/jquery.js"></script>
<script src="jquery-ui-1.11.2.custom/jquery-ui.js"></script>
<script>
$(function() {
$("#datepicker").datepicker({dateFormat: 'yy-mm-dd'});
});
</script>
<script> function hapus (){if (confirm('Anda Yakin Ingin Hapus?')){
return true;} else{return false;}} </script>
</head>
<body background="g10.jpg">
<div id="container">
<div id='cssmenu'>
<ul>
<li class='active has-sub'><a href='#'><span>Profile</span></a>
<ul>
<li class='has-sub'><a href='about.php'><span>Sejarah Perusahaan</span></a></li>
<li class='has-sub'><a href='bidang.php'><span>Bidang Usaha, Visi dan
Misi</span></a></li>
<li class='has-sub'><a href='struktur.php'><span>Struktur Organisasi</span></a></li>
</ul></li>
<li class='active has-sub'><a href='#'><span>Daftar Barang</span></a>
<ul>
<li class='has-sub'><a href='BP.php'><span>Bahan Kimia</span></a></li>
</ul></li>
<li><a href='daftar_supplier.php'><span>Daftar Supplier</span></a>
<li class='active has-sub'><a href='#'><span>Pembelian</span></a>
<ul>
<li class='has-sub'><a href='suplai.php'><span>Pembelian Barang</span></a></li>
</ul></li>
<li class='active has-sub'><a href='#'><span>Laporan</span></a>
<ul>
<li class='has-sub'><a href='mutasi.php'><span>Mutasi Stock Bahan
Kimia</span></a></li>
<li class='has-sub'><a href='kartu_utang.php'><span>Kartu Utang</span></a></li>
</ul></li>
<li><a href='logout.php'><span>Logout</span></a>
</ul>
</div>
<table>
<tr><td><img src="timatex.jpg" style="height:200px;width:200px;"><br></td>
<td><center><blink>
<h1>KARTU UTANG</h1></blink></center>
65
</td></tr>
<tr><td></td>
<td>
<?php
include"config.php";
error_reporting(0);
echo"
<form action=simpan_kartu_utang.php method=POST>
<table>
<tr>
<td><b>No Hutang</b></td>
<td bgcolor='black'><input type=text name='no_hutang'></td><td></td><td></td><td></td>
<td><b>Tanggal Beli</b></td>
<td bgcolor='black'><input type=text name='tanggal' id=\"datepicker\"></td></tr>
<tr><tr></tr><tr></tr><tr></tr><tr></tr><tr></tr><tr></tr>
<tr>
<td><b>Tanggal Jatuh Tempo</b></td>
<td bgcolor='black'><input type=text name='tgl_jatuhtempo' id=\"datepicker\"></td></tr>
<td><b>Id Barang</b></td>
<td><select name='id_barang'><option value''>Pilih Id Barang</option>";
$query=mysql_query("SELECT id_barang, nama_barang from bahan_kimia ",$connection);
while($a=mysql_fetch_array($query)){
echo "<option value=".$a['id_barang'].">".$a['id_barang']." -
".$a['nama_barang']."</option>";
}
echo "<td><a href=barang2.php>Barang Baru?</a></td></tr>
<tr></tr><tr></tr><tr></tr>
<tr>
<td><b>Nama Supplier</b></td>
<td bgcolor='black'><input type=text
name='nama_supplier'></td><td></td><td></td><td></td>
<td><b>Hutang</b></td>
<td bgcolor='black'><input type=text name='hutang'></td>
<td></td><td></td><td></td>
<tr>
<td><b>Terbayar</b></td>
<td bgcolor='black'><input type=text name='terbayar'></td><td></td><td></td><td></td>
<td><b>Kurang</b></td>
<td bgcolor='black'><input type=text name='kurang'></td>
</tr>
<tr></tr><tr></tr><tr></tr>
<tr></tr><tr></tr><tr></tr>
<tr>
<td><input type=submit value='Simpan'></td>
<td></td>
</tr>
</table>
</form>
</center>";
?>
<table border="1" cellpadding="3" bgcolor="#999999">
<font color=black>
<tr height="25" bgcolor=grey>
<td rowspan="1" valign="middle"><b><center>Nomor Hutang</center></b></td>
<td rowspan="1" valign="middle"><b><center>Tanggal Beli</center></b></td>
<td rowspan="1" valign="middle"><b><center>Tanggal Jatuh Tempo</center></b></td>
<td rowspan="1" valign="middle"><b><center>Id & Nama Barang</center></b></td>
<td rowspan="1" valign="middle"><b><center>Nama Supplier</center></b></td>
<td rowspan="1" valign="middle"><b><center>Hutang</center></b></td>
<td rowspan="1" valign="middle"><b><center>Terbayar</center></b></td>
<td rowspan="1" valign="middle"><b><center>Kurang</center></b></td>
</tr>
</font>
<?php
66
include"konek.php";
$query=mysql_query ("SELECT * FROM lap_hutang p order by p.id_barang ", $connection);
while($a=mysql_fetch_array($query)){ $query2=mysql_query("SELECT nama_barang from
bahan_kimia where id_barang='$a[id_barang]' UNION SELECT nama_barang from bahan_kimia
where id_barang='$a[id_barang]'",$connection);
while($b=mysql_fetch_array($query2)){
$nama_barang=$b['nama_barang'];
}
echo"
<tr>
<td>$a[no_hutang]</td>
<td>$a[tanggal]</td>
<td>$a[tgl_jatuhtempo]</td>
<td>$a[id_barang]"." - ".$nama_barang."</td>
<td>$a[nama_supplier]</td>
<td>$a[hutang]</td>
<td>$a[terbayar]</td>
<td>$a[kurang]</td>
</tr>";
}
?>
</table>
</center>
</td>
</tr>
</table>
</body>
</html>
Simpan_kartu_utang.php <?php
include"konek.php";
error_reporting(0);
$no_hutang = $_POST['no_hutang'];
$tanggal = $_POST['tanggal'];
$tgl_jatuhtempo = $_POST['tgl_jatuhtempo '];
$id_barang = $_POST['id_barang'];
$nama_supplier = $_POST['nama_supplier '];
$hutang = $_POST['hutang'];
$terbayar = $_POST['terbayar'];
$kurang = $_POST['kurang'];
$query=mysql_query ("INSERT INTO lap_hutang(no_hutang, tanggal, tgl_jatuhtempo,
id_barang, nama_supplier, hutang, terbayar, kurang)
VALUES ('$no_hutang','$tanggal', '$tgl_jatuhtempo','$id_barang', '$nama_supplier',
'$hutang', '$terbayar', '$kurang')",$connection);
if($query) {
?>
<script language="JavaScript">
document.location='kartu_utang.php'</script>
<?php
}
?>
logout.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body >
<?php
67
$_SESSION['username'] = "";
unset($_SESSION['username']);
print "<script>alert('Logout berhasil'); location = 'login.php'; </script>";
?>
</body>
68
Lampiran 8 : Purchase Order (PO)
69
Lampiran 9 : Surat Jalan
70
Lampiran 10 : Bon Penerimaan Barang
71
Lampiran 11 : Rekapitulasi Kerja Praktek
72
Lampiran 12 : Jurnal Kerja Praktek
73
74
Lampiran 13 : Jurnal Bimbingan Tugas Akhir
75
Lampiran 14 : Surat Keterangan Kerja Praktek