lampiran 1 struktur organisasi perusahaan struktur...

38

Lampiran 1 Struktur Organisasi Perusahaan

Struktur Organisasi Operational

39

Sub Struktur : Departemen Accounting 2014

40

Lampiran 2Coding List

Koneksi.php <?php

$host = "localhost";

$username = "root";

$password = "";

$databasename = "penggajian";

$connection = mysql_connect($host, $username, $password) or die("Kesalahan Koneksi

... !!");

mysql_select_db($databasename, $connection) or die("Databasenya Error");

?>

Index.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>Sistem Penggajian PT Sai Apparel Industries</title>

</head>

<body bgcolor="#00FFCC" >

<div id="main_container">

<br>

<IMG SRC="apparels.jpg" WIDTH=1320 HEIGHT=139/>

<p class="header"><marquee><font size="15">Sistem Penggajian PT Sai Apparel

Industries</font></marquee></p><br /><hr>

<br>

<table width="200" align="center" class="home">

<center>

<p><a href="loginadmin.php"><b>ADMIN</b></A></p>

<p><A HREF="loginkry.php"><b>KARYAWAN</b></A></p>

</center>

</TR>

</TABLE>

</body>

</html>

Loginadmin.php




<head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>Login Administrator</title></head>



<br>

<IMG SRC="aku.jpg" WIDTH=1320 HEIGHT=139/>



<TR><TD align="center" valign="top" bordercolorlight="#33CC00"><center><h1>LOG

IN</h1

><font size="6" color="#FF0000" >Administrator</font>

<?php

//kode php ini kita gunakan untuk menampilkan pesan eror

if (!empty($_GET['error'])) {

if ($_GET['error'] == 1) {

echo '<h3>username dan password belum diisi!</h3>';

} else if ($_GET['error'] == 2) {

echo '<h3>username belum diisi!</h3>';


41

echo '<h3>password belum diisi!</h3>';


echo '<h3>username dan password tidak terdaftar!</h3>';

}

}

?>

<form name="login" action="login_proses1.php" method="post">

<center>

<table border="0" cellpadding="5" cellspacing="0">

<tr><td>User Name</td>

<td>:</td>

<td><input type="text" name="username"></td>

</tr>

<tr><td>Password</td>

<td>:</td>

<td><input type="password" name="password"></td></tr>

<tr align="center">

<td colspan="3"><input type="submit" name="login1" value="Login">

<input type="reset" value="Reset" onClick="return confirm('hapus data yang telah

diinput?')">

</table></center></form></TD>

<A HREF="index.php"><b>Home</b></A>

</body>

</html>

Login_proses1.php <?php

include "koneksi.php";

$username = $_POST['username'];

$password = $_POST['password'];

$username = mysql_real_escape_string($username);

$password = mysql_real_escape_string($password);

if (empty($username) && empty($username)) {

header('Location: loginadmin.php?error=1');

break;

} else if (empty($username)) {


break;

} else if (empty($password)) {


break;

}

$q = mysql_query("select * from admin where username='$username'and

password='$password'");

$cek=mysql_num_rows($q);

//$q ==1 yang di if tak ganti sama tak tambahi yang di baris 30

if ($cek) {

header('Location: daftaradmin.php');

} else {


}

?>

Daftaradmin.php




<head>


<title>Selamat Datang di Halaman Administrator</title>

</head>


<TABLE width="1300" BORDER="1">

42

<TR>

<TD height="187" COLSPAN="2"><img src="apparels.jpg" width="1300" height="187"

/></TD></TR>

<TR><TD width="152" align="left" valign="top" bordercolorlight="#33CC00">

<A HREF="daftaradmin.php"><b>Admin</b></A>

<p><A HREF="karyawanx.php"><b>Karyawan</b></A></p>

<p><A HREF="bagian.php"><b>Bagian</b></A></p>

<p><A HREF="penggajian.php"><b>Penggajian</b></A></p>

<p><A HREF="laporan.php"><b>Laporan</b></A></p>

<p><A HREF="tanda_gaji.php"><b>Tanda Gaji</b></A></p>

<p><A HREF="slip_gaji.php"><b>Slip Gaji</b></A></p>

<p><A HREF="index.php"><b>Keluar</b></A></p></TD>

<td width="2173" height="317" align="left" valign="top" bgcolor="#00FFCC">

<legend><center>Form Tambah Admin</center>

</legend>

<form action="daftaradmin.php" method="post">

<TABLE BORDER="0" align="center">

<TR>

<TD>ID</TD>

<TD><input type="varchar" name="id_user" required /></TD>

</TR>

<TR>

<TD>User Name</TD>

<TD><input type="varchar" name="username"

required /></TD>

</TR>

<TR>

<TD>Password</TD>

<TD><input type="varchar" name="password" required /></TD>

</TR>

<TD></TD>

<TD><input type="submit" value="Simpan" name="simpan_admin">


diinput?')"></TD>

</TR></TABLE>

<p>

<?php

mysql_connect("localhost","root","")or die(mysql_error());

mysql_select_db("penggajian") or die(mysql_error());

if(isset($_POST['simpan_admin'])){

$id_user =$_POST['id_user'];

$username =$_POST['username'];

$password =$_POST['password'];

$sql = "INSERT INTO admin SET id_user='$id_user',

username='$username', password ='$password'";

$query=mysql_query($sql) or die(mysql_error());

}

?>

<center>

<table width="50%" border="1">

<tr>

<th width="21%" align="center" >ID Admin</th>

<th width="31%" align="center" >User Name</th>

<th width="24%" align="center">Password</th>

<th align="center">Pilihan</th>

</tr>

<?php

$sql = "SELECT * FROM admin";

$query2=mysql_query($sql);

while($data=mysql_fetch_array($query2)){

$out_id_user=$data['id_user'];

$out_username=$data['username'];

$out_password=$data['password'];

?>

<tr>

<td height="38">

<?php echo $out_id_user; ?></td>

<td><?php echo $out_username; ?></td>

<td><?php echo $out_password; ?></td>

<td align="center">

43

<a href="edit_admin.php?id_user=<?php echo $data['id_user'] ?>"><b>Edit</b></A>

<a href="delete_admin.php?id_user=<?php echo $data['id_user'] ?>"><b>Hapus</b></A>

</td>

</tr>

<?php

}

?>

</table>

</center>

</TABLE>

</body>

</html>

Edit_admin.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"



<head>


<title>Edit Data Admin</title>

</head>



<TR>


/></TD></TR>

<TR>

<TD width="152" align="left" valign="top" bordercolorlight="#33CC00">


<p><A HREF="karyawan.php"><b>Karyawan</b></A></p>








<?php


$data = $_GET['id_user'];

$query=mysql_query ("SELECT * FROM admin WHERE id_user='$data'");

while ($row=mysql_fetch_array($query)){

$username = $row['username'];

$password = $row['password'];

echo "<html>";

echo "<body>";

echo "<font face='tahoma' color='green' size=4><b>Perbaharui Data

Admin</b></font>";

echo "<table align='left'>";

echo "<form method=\"post\" action=\"update_admin.php?id_user=$data\"

enctype='multipart/form-data'>";

echo "<br>";

echo "<tr><td><font face='Tahoma' color='black' size=2>User Name

</font></td><td>:</td><td><input type='text' name='username' value='$username'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Password

</font></td><td>:</td><td><input type='text' name='password' value='$password'

size='30'> </td></tr>";

echo "<tr><td></td><td></td><td><font size='2'><input type='submit' name='submit'

value='Update'/></font></td></tr>";

echo "</table></form></body></html>";

}

?>

<p>

<?php



if(isset($_POST['simpan_admin'])){

44

$id_user =$_POST['id_user'];



$sql = "INSERT INTO admin SET id_user='$id_user',

username='$username', password ='$password'";


}

?>

<center>

<table width="50%" border="1">

<tr>

<th width="21%" align="center" >ID Admin</th>

<th width="31%" align="center" >User Name</th>

<th width="24%" align="center">Password</th>


</tr>

<?php

$sql = "SELECT * FROM admin";



$out_id_user=$data['id_user'];

$out_username=$data['username'];

$out_password=$data['password'];

?>

<tr><td height="38">

<?php echo $out_id_user; ?></td>

<td><?php echo $out_username; ?></td>

<td><?php echo $out_password; ?></td>

<td align="center">

<a href="edit_admin.php?id_user=<?php echo $data['id_user'] ?>"><b>Edit</b></A>

<a href="delete_admin.php?id_user=<?php echo $data['id_user'] ?>"><b>Hapus</b></A>

</td></tr>

<?php

}

?>

</table>

</center>

</TABLE>

</body>

</html>

Update_admin.php

<?php


$id_user = $_GET['id_user'];



$query=mysql_query ("UPDATE admin SET username='$username', password ='$password'

WHERE

id_user='$id_user'",$connection)or die (mysql_error());

if($query) {

?>

<script language="JavaScript">

document.location='daftaradmin.php'</script>

<?php

}

?>

Delete_admin.php <?php

include ("koneksi.php");

$id_user = $_GET['id_user'];

$query = "DELETE FROM admin WHERE id_user = '$id_user'";

mysql_query($query);

45

?>


document.location='daftaradmin.php'</script>

<?php

?>

Karyawanx.php <?php


?>




<head>


<title>.Karyawan.</title>

<script>

function showInfoBagian(str) {

if (str=="") {

document.getElementById("tampil").innerHTML="";

return;

}

if (window.XMLHttpRequest) {

// code for IE7+, Firefox, Chrome, Opera, Safari

xmlhttp=new XMLHttpRequest();

} else { // code for IE6, IE5

xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");

}

xmlhttp.onreadystatechange=function() {

if (xmlhttp.readyState==4 && xmlhttp.status==200) {

document.getElementById("tampil").innerHTML=xmlhttp.responseText;

}

}

xmlhttp.open("GET","get_info_bagian.php?p="+str,true);

xmlhttp.send();

}

</script>

</head>



<TABLE width="65%" BORDER="1">

<TR><TD height="157" COLSPAN="2"><img src="apparels.jpg" width="1400" height="187"

/></TD></TR>


<p><A HREF="daftaradmin.php"><b>Admin</b></A></p>








<legend><center><b><font face="Arial">Form Input

Karyawan</font></b></center></legend>

<form action="karyawanx.php" method="post"><TABLE BORDER="0" align="center">

<TR><TD>NIK</TD>

<TD><input type="varchar" name="nik" required /></TD></TR>

<TR><TD>Nama Karyawan</TD><TD><input type="varchar" name="nama_kry" required

/></TD></TR>

<TR><TD>Jenis Kelamin</TD>

<TD><select name='gender' id='gender'>

<option value=''>-Pilih-</option>

<option value='pria'>Pria</option>

<option value='wanita'>Wanita</option>

</select></TD></TR>

<TR><TD>Agama</TD>

<TD><select name='agama' id='agama'>


<option value='islam'>Islam</option>

<option value='kristen'>Kristen</option>

<option value='katolik'>Katolik</option>

46

<option value='hindu'>Hindu</option>

<option value='budha'>Budha</option>

<option value='lainnya'>Lainnya</option>

</select></TD></TR>

<TR><TD>Alamat</TD>

<TD><input type="varchar" name="alamat" required /></TD></TR>

<TR><TD>Tempat Lahir</TD>

<TD><input type="varchar" name="tempat_lhr" required /></TD></TR>

<TR><TD>Tanggal Lahir</TD>

<TD><input type="text" name="tanggal_lhr" value="yyyy-mm-dd" required

/></TD></TR>

<TR><TD>Telpon</TD>

<TD><input type="varchar" name="telp" required /></TD></TR>

<TR><TD>Status</TD>

<TD><select name='status' id='status'>


<option value='TK/0'>TK/0</option>

<option value='K/0'>K/0</option>




</select></TD></TR>

<TR><TD>Pendidikan</TD>

<TD><input type="varchar" name="pendidikan" required /></TD></TR>

<TR>

<td width="100">Kode Bagian</td>

<td><SELECT NAME="kode_bag" required onchange="showInfoBagian(this.value);"

onkeyup="showInfoBagian(this.value);">

<?php

$sql = "SELECT kode_bag, nama_bag FROM bagian ORDER BY kode_bag";

$query = mysql_query($sql) or die(mysql_error());

while($result = mysql_fetch_array($query)) {

echo "<option value=\"";

echo $result['kode_bag'];

echo "\">";


echo " - ";

echo $result['nama_bag'];

echo "</option>";

}

?>

</SELECT></td></TR>

<TR><TD>Tanggal Join</TD>

<TD><input type="text" name="tgl_join" value="yyyy-mm-dd" required /></TD></TR>

<TD>Status Karyawan </TD>

<TD><select name='status_kry' id='status_kry'>


<option value='K.Tetap'>K.Tetap</option>

<option value='K.Kontrak'>K.Kontrak</option>

</select></TD></TR><TR>

<TD>Kenaikan</TD>

<TD><input type="text" name="kenaikan" required /></TD></TR>

<TR>

<td></td><TD><input type="submit" value="Simpan" name="simpan_kry">

<input type="reset" value="Hapus" onClick="return confirm('hapus data yang telah

diinput?')"></TD>

</TR></TABLE></form>

<p>

<?php



if(isset($_POST['simpan_kry'])){

$nik =$_POST['nik'];

$nama_kry =$_POST['nama_kry'];

$gender =$_POST['gender'];

$agama =$_POST['agama'];

$alamat =$_POST['alamat'];

$tempat_lhr =$_POST['tempat_lhr'];

$tanggal_lhr = $_POST['tanggal_lhr'];

$telp =$_POST['telp'];

$status =$_POST['status'];

$pendidikan = $_POST['pendidikan'];

$kode_bag =$_POST['kode_bag'];

$tgl_join = $_POST['tgl_join'];

47

$status_kry =$_POST['status_kry'];

$kenaikan = $_POST['kenaikan'];

$sql = "INSERT INTO karyawan SET nik='$nik', nama_kry='$nama_kry',

gender ='$gender' ,agama ='$agama',alamat

='$alamat',tempat_lhr='$tempat_lhr',tanggal_lhr='$tanggal_lhr',telp='$telp',status

='$status',pendidikan='$pendidikan',kode_bag='$kode_bag',tgl_join='$tgl_join',stat

us_kry='$status_kry',kenaikan='$kenaikan'";


}

?>

<p>

<table align="left" bordercolor="#000000" border="1">

<tr>

<th >NIK</th>

<th >Nama</th>

<th >Gender</th>

<th >Agama</th>

<th >Alamat</th>

<th >Tempat Lahir</th>

<th >Tanggal Lahir</th>

<th >Telpon</th>

<th >Status</th>

<th >Pendidikan</th>

<th >Kode Bagian</th>

<th >Tanggal join</th>

<th >Status Karyawan</th>

<th >Kenaikan</th>

<th >Pilihan</th>

</tr>

<?php



$sql = "SELECT * FROM karyawan";



$out_nik=$data['nik'];

$out_nama_kry=$data['nama_kry'];

$out_gender=$data['gender'];

$out_agama=$data['agama'];

$out_alamat=$data['alamat'];

$out_tempat_lhr=$data['tempat_lhr'];

$out_tanggal_lhr=$data['tanggal_lhr'];

$out_telp=$data['telp'];

$out_status=$data['status'];

$out_pendidikan=$data['pendidikan'];

$out_kode_bag=$data['kode_bag'];

$out_tgl_join=$data['tgl_join'];

$out_status_kry=$data['status_kry'];

$out_kenaikan=$data['kenaikan'];

?>

<tr>

<td><?php echo $out_nik; ?></td>

<td><?php echo $out_nama_kry; ?></td>

<td><?php echo $out_gender; ?></td>

<td><?php echo $out_agama; ?></td>

<td><?php echo $out_alamat; ?></td>

<td><?php echo $out_tempat_lhr; ?></td>

<td><?php echo $out_tanggal_lhr; ?></td>

<td><?php echo $out_telp; ?></td>

<td><?php echo $out_status; ?></td>

<td><?php echo $out_pendidikan; ?></td>

<td><?php echo $out_kode_bag; ?></td>

<td><?php echo $out_tgl_join; ?></td>

<td><?php echo $out_status_kry; ?></td>

<td><?php echo $out_kenaikan; ?></td>

<td align="center">

<a href="edit_kry.php?nik=<?php echo $data['nik'] ?>"><b>Edit</b></A>

<a href="delete_kry.php?nik=<?php echo $data['nik'] ?>"><b>Hapus</b></A>

</td>

</tr>

<?php

}

48

?>

</table>

</center>

</td>

</TABLE>

</body>

</html>

Edit_kry.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"



<head>


<title>Edit Data Karyawan</title>

</head>


<TABLE width="100%" BORDER="1">

<TR>


/></TD>

</TR>

<TR>


<A HREF="karyawanx.php"><b>Karyawan</b></A></p>

<p><A HREF="daftaradmin.php"><b>Admin</b></A></p>





<p><A HREF="index.php"><b>Keluar</b></A></p>

</TD>


<?php


$data = $_GET['nik'];

$query=mysql_query ("SELECT * FROM karyawan WHERE nik='$data'");


$nama_kry = $row['nama_kry'];

$gender = $row['gender'];

$agama = $row['agama'];

$alamat = $row['alamat'];

$tempat_lhr = $row['tempat_lhr'];

$tanggal_lhr = $row['tanggal_lhr'];

$telp = $row['telp'];

$status = $row['status'];

$pendidikan = $row['pendidikan'];

$kode_bag = $row['kode_bag'];

$tgl_join = $row['tgl_join'];

$status_kry = $row['status_kry'];

$kenaikan = $row['kenaikan'];

echo "<font align ='center' face='tahoma' color='green' size=4><b>Update

Karyawan</b></font>";


echo "<form method=\"post\" action=\"update_kry.php?nik=$data\"


echo "<br>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Nama

</font></td><td>:</td><td><input priatype='text' name='nama_kry' value='$nama_kry'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Jenis Kelamin

</font></td><td>:</td><td><select name='gender' id='gender'>


<option value='pria'>Pria</option>

<option value='wanita'>Wanita</option>

</select> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Agama

49

</font></td><td>:</td><td><select name='agama' id='agama'>


<option value='islam'>Islam</option>

<option value='kristen'>Kristen</option>

<option value='katolik'>Katolik</option>

<option value='hindu'>Hindu</option>

<option value='budha'>Budha</option>

<option value='lainnya'>Lainnya</option>


echo "<tr><td><font face='Tahoma' color='black' size=2>Alamat

</font></td><td>:</td><td><input type='text' name='alamat' value='$alamat'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Tempat Lahir

</font></td><td>:</td><td><input type='text' name='tempat_lhr' value='$tempat_lhr'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Tanggal Lahir

</font></td><td>:</td><td><input type='text' name='tanggal_lhr'

value='$tanggal_lhr'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2> Telpon

</font></td><td>:</td><td><input type='text' name='telp' value='$telp'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Status

</font></td><td>:</td><td><input type='text' name='status' value='$status'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Pendidikan

</font></td><td>:</td><td><input type='text' name='pendidikan' value='$pendidikan'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Kode Bagian

</font></td><td>:</td><td><input type='text' name='kode_bag' value='$kode_bag'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Tanggal Join

</font></td><td>:</td><td><input type='text' name='tgl_join' value='$tgl_join'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Status Karyawan

</font></td><td>:</td><td><select name='status_kry' id='status_kry'>


<option value='K.Tetap'>K.Tetap</option>

<option value='K.Kontrak'>K.Kontrak</option>


echo "<tr><td><font face='Tahoma' color='black' size=2>Kenaikan

</font></td><td>:</td><td><input type='text' name='kenaikan' value='$kenaikan'

size='30'> </td></tr>";




}

?>

update_kry.php <?php


$nik = $_GET['nik'];

$nama_kry =$_POST['nama_kry'];

$gender =$_POST['gender'];

$agama =$_POST['agama'];

$alamat =$_POST['alamat'];

$tempat_lhr =$_POST['tempat_lhr'];

$tanggal_lhr = $_POST['tanggal_lhr'];

$telp =$_POST['telp'];

$status =$_POST['status'];

$pendidikan = $_POST['pendidikan'];


$tgl_join = $_POST['tgl_join'];

$status_kry =$_POST['status_kry'];

50

$kenaikan = $_POST['kenaikan'];

$query=mysql_query ("UPDATE karyawan SET nama_kry='$nama_kry', gender ='$gender'

,agama ='$agama',alamat

='$alamat',tempat_lhr='$tempat_lhr',tanggal_lhr='$tanggal_lhr',telp='$telp',status

='$status',pendidikan='$pendidikan',kode_bag='$kode_bag',tgl_join='$tgl_join',stat

us_kry='$status_kry',kenaikan='$kenaikan' WHERE

nik='$nik'",$connection)or die (mysql_error());

if($query) {

?>


document.location='karyawanx.php'</script>

<?php

}

?>

Delete_kry.php <?php


$nik = $_GET['nik'];

$query = "DELETE FROM karyawan WHERE nik = '$nik'";


?>


document.location='karyawanx.php'</script>

<?php

?>

Get_info_kry.php <?php


$nik = $_GET['q'];

$sql = "SELECT * FROM karyawan WHERE nik = '$nik'";


while($result = mysql_fetch_array($query)){

echo "<table>";

echo "

<tr>

<td>Nama Karyawan</td>

<td>:</td>

<td>".$result['nama_kry']."</td>

</tr>";

echo "

<tr>

<td>Alamat</td>

<td>:</td>

<td>".$result['alamat']."</td>

</tr>";

echo "

<tr>

<td>Status</td>

<td>:</td>

<td>".$result['status']."</td>

</tr>";

echo "

<tr>

<td>Kode bagian</td>

<td>:</td>

<td>".$result['kode_bag']."</td>

</tr>";

echo "

<tr><td>Status Karyawan</td>

<td>:</td>

<td>".$result['status_kry']."</td></tr>";

51

echo "

<tr><td>Tanggal Join</td>

<td>:</td>

<td>".$result['tgl_join']."</td></tr>";

echo "

<tr><td>Kenaikan</td>

<td>:</td>

<td>".$result['kenaikan']."</td></tr>";

echo "</table>";

}

?>

Bagian.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"



<head>


<title>Daftar Bagian</title>

</head>



<TR><TD height="187" COLSPAN="2"><img src="apparels.jpg" width="1300" height="187"

/></TD></TR>

<TR>










</TD>

<td width="2173" height="407" align="center" valign="top" bgcolor="#00FFCC">

<legend>Form Tambah Bagian</legend>

<form action="bagian.php" method="post"><TABLE BORDER="0" align="center">

<TR>

<TD>Kode Bagian</TD>

<TD><input type="varchar" name="kode_bag" required /></TD>

</TR>

<TR>

<TD>Nama Bagian</TD>

<TD><input type="text" name="nama_bag" required /></TD>

</TR>

<TR>

<TD>Gaji Pokok</TD>

<TD><input type="varchar" name="gaji_pokok" required /></TD>

</TR>

<TR>

<TD>Uang Lembur</TD>

<TD><input type="varchar" name="uang_lembur" required /></TD>

</TR>

<TR>

<TD>Tunjangan Jabatan</TD>

<TD><input type="varchar" name="tunjangan_jab" required /></TD>

</TR>

<TR>

<TD>Tunjangan Makan</TD>

<TD><input type="varchar" name="tunjangan_makan" required /></TD>

</TR>

<td></td><TD><input type="submit" value="Simpan" name="simpan_bag">


diinput?')"></TD>

</TR></TABLE>

<p>

52

<?php



if(isset($_POST['simpan_bag'])){


$nama_bag =$_POST['nama_bag'];

$gaji_pokok =$_POST['gaji_pokok'];

$uang_lembur =$_POST['uang_lembur'];

$tunjangan_jab =$_POST['tunjangan_jab'];

$tunjangan_makan =$_POST['tunjangan_makan'];

$sql = "INSERT INTO bagian SET kode_bag='$kode_bag',

nama_bag='$nama_bag', gaji_pokok ='$gaji_pokok' ,uang_lembur

='$uang_lembur',tunjangan_jab ='$tunjangan_jab',tunjangan_makan

='$tunjangan_makan'";


}

?>

</p>

<p> </p>

<table align="center" bordercolor="#000000" border="1">

<tr>

<th >Kode Bagian</th>

<th >Nama Bagian</th>

<th >Gaji Pokok</th>

<th >Uang Lembur</th>

<th >Tunjangan Jabatan</th>

<th >Tunjangan Makan</th>

<th >Pilihan</th>

</tr>

<?php

$sql = "SELECT * FROM bagian";



$out_kode_bag=$data['kode_bag'];

$out_nama_bag=$data['nama_bag'];

$out_gaji_pokok=$data['gaji_pokok'];

$out_uang_lembur=$data['uang_lembur'];

$out_tunjangan_jab=$data['tunjangan_jab'];

$out_tunjangan_makan=$data['tunjangan_makan'];

?>

<tr>

<td><?php echo $out_kode_bag; ?></td>

<td><?php echo $out_nama_bag; ?></td>

<td><?php echo $out_gaji_pokok; ?></td>

<td><?php echo $out_uang_lembur; ?></td>

<td><?php echo $out_tunjangan_jab; ?></td>

<td><?php echo $out_tunjangan_makan; ?></td>

<td align="center">

<a href="edit_bag.php?kode_bag=<?php echo $data['kode_bag'] ?>"><b>Edit</b></A>

<a href="delete_bag.php?kode_bag=<?php echo $data['kode_bag'] ?>"><b>Hapus</b></A>

</td></tr>

<?php

}

?>

</table>

</TABLE>

</body>

</html>

edit_bag.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"



<head>


<title>Edit Data Bagian</title>

</head>



<TR>

53


/></TD>

</TR>

<TR>










</TD>


<?php


$data = $_GET['kode_bag'];

$query=mysql_query ("SELECT * FROM bagian WHERE kode_bag='$data'");


$nama_bag =$row['nama_bag'];

$gaji_pokok =$row['gaji_pokok'];

$uang_lembur =$row['uang_lembur'];

$tunjangan_jab =$row['tunjangan_jab'];

$tunjangan_makan =$row['tunjangan_makan'];

echo "<html>";

echo "<body>";


Bagian</b></font>";


echo "<form method=\"post\" action=\"update_bag.php?kode_bag=$data\"


echo "<br>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Nama Bagian

</font></td><td>:</td><td><input type='text' name='nama_bag' value='$nama_bag'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Gaji Pokok

</font></td><td>:</td><td><input type='text' name='gaji_pokok' value='$gaji_pokok'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Uang Lembur

</font></td><td>:</td><td><input type='text' name='uang_lembur'

value='$uang_lembur'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Tunjangan Jabatan

</font></td><td>:</td><td><input type='text' name='tunjangan_jab'

value='$tunjangan_jab'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Tunjangan Makan

</font></td><td>:</td><td><input type='text' name='tunjangan_makan'

value='$tunjangan_makan'

size='30'> </td></tr>";




}

?>

Update_bag.php <?php


$kode_bag = $_GET['kode_bag'];

$nama_bag =$_POST['nama_bag'];

$gaji_pokok =$_POST['gaji_pokok'];

54


$tunjangan_jab =$_POST['tunjangan_jab'];


$query=mysql_query ("UPDATE bagian SET nama_bag='$nama_bag',

gaji_pokok='$gaji_pokok',uang_lembur='$uang_lembur', tunjangan_jab

='$tunjangan_jab',tunjangan_makan='$tunjangan_makan' WHERE

kode_bag='$kode_bag'",$connection)or die (mysql_error());

if($query) {

?>


document.location='bagian.php'</script>

<?php

}

?>

Delete_bag.php <?php


$kode_bag = $_GET['kode_bag'];

$query = "DELETE FROM bagian WHERE kode_bag = '$kode_bag'";


?>


document.location='bagian.php'</script>

<?php

?>

Get_info_bagian.php <?php


$kode_bag = $_GET['p'];

$sql = "SELECT * FROM bagian WHERE kode_bag = '$kode_bag'";


while($result = mysql_fetch_array($query)){

echo "<table>";

echo "

<tr><td>Nama Bagian</td>

<td>:</td>

<td>".$result['nama_bag']."</td></tr>";

echo "

<tr><td>Gaji Pokok</td>

<td>:</td>

<td>".$result['gaji_pokok']."</td></tr>";

echo "

<tr><td>Uang Lembur</td>

<td>:</td>

<td>".$result['uang_lembur']."</td></tr>";

echo "

<tr><td>Tunjangan Jabatan</td>

<td>:</td><td>".$result['tunjangan_jab']."</td></tr>";

echo "

<tr><td>Tunjangan Makan</td><td>:</td>

<td>".$result['tunjangan_makan']."</td></tr>";

echo "</table>";

}

?>

Penggajian.php <?php


?>




<head>


<title>.Penggajian.</title>

<script>

55

function showInfoKaryawan(str) {

if (str=="") {


return;

}






}




}

}

xmlhttp.open("GET","get_info_kry.php?q="+str,true);

xmlhttp.send();

}

</script>

</head>



<TR><TD height="187" COLSPAN="2"><IMG SRC="apparels.jpg" WIDTH=2000

HEIGHT=187></TD></TR>








<legend>Form Penggajian</legend>

<form action="penggajian.php" method="post">

<table>

<TR><TD width="626"><table>

<tr><td width="609"><table><tr>

<td width="616"><table>

<tr></tr><tr>

<td>ID Gaji</td>

<td><input type="varchar" name="id_gaji" required /></td>

</tr>

<td width="200">NIK</td>

<td><SELECT NAME="nik" required onchange="showInfoKaryawan(this.value);"

onkeyup="showInfoKaryawan(this.value);">

<?php

$sql = "SELECT nik, nama_kry, kode_bag FROM karyawan ORDER BY

nik";




echo $result['nik'];

echo "\">";

echo $result['nik'];

echo " - ";

echo $result['nama_kry'];

echo " - ";


echo "</option>";

}

?>

</select></td>

<tr><td>Periode</td>

<td><input type="text" name="periode" value="periode-bulan-tahun"

required /></td></tr>

<tr>

<td>Tanggal</td>

<td><input type="datetime" name="tanggal" value="yyyy-mm-dd"


<td>Pendapatan</td>

<td></td>

<td>Potongan</td>

<tr><td>Gaji Pokok</td>

56

<td><input type="text" name="gaji_pokok"

required /></td>

<td>SPN</td>

<td><input type="text" name="spn"


<tr><td>Jam Kehadiran</td>

<td><input type="text" name="jml_kehadiran"

required /></td>

<td>PPH 21</td>

<td><input type="text" name="pph21"


<tr><td>Jumlah Absen</td>

<td><input type="text" name="jml_absen"

required /></td>

<td>Potongan Gaji</td>

<td><input type="text" name="pot_gaji"


<tr><td>Jam Lembur</td>

<td><input type="text" name="jam_lembur"

required /></td>

<td>Iuran Koperasi</td>

<td><input type="text" name="iur_kop"


<tr><td>Uang Lembur</td>

<td><input type="text" name="uang_lembur"

required /></td>

<td>BPJS</td>

<td><input type="text" name="bpjs"


<tr><td>Tunjangan Makan</td>

<td><input type="text" name="tunjangan_makan"

required /></td>

<td>Jamsostek</td>

<td><input type="text" name="jamsostek"

required /></td>

</tr>

<tr>

<td>Tunjangan Transport</td>

<td><input type="text" name="tunjangan_transport"

required /></td>

<td>Pot Lainnya</td>

<td><input type="text" name="pot_lainnya"


<tr><td>Tunjangan Overtime</td>

<td><input type="text" name="tunjangan_overtime"


<tr><td>Tunjangan Jabatan</td>

<td><input type="text" name="tunjangan_jab"


<tr><td>Cuti Haid</td>

<td><input type="text" name="cuti_haid"

required /></td>

</tr>

<tr>

<td>Pendapatan Lainnya</td>

<td><input type="text" name="pend_lainnya"

required /></td>

</tr>

<tr>

<td>Shift Milk</td>

<td><input type="text" name="shift_milk"

required /></td>

</tr>

<tr>

<td>Tunjangan MK</td>

<td><input type="text" name="tunj_mk"


<tr><td>Sisa Lalu</td>

<td><input type="text" name="sisa_lalu"

required /></td>

</tr>

<tr>

<td></td>

<td><input type="submit" value="Simpan" name="simpan_penggajian" />

57

<input type="reset" value="Reset" onclick="return confirm('hapus data yang telah

diinput?')" /></td></tr>

</table></form>

<p> </p>

<?php



if(isset($_POST['simpan_penggajian'])){

$id_gaji =$_POST['id_gaji'];

$nik =$_POST['nik'];

$periode =$_POST['periode'];

$tanggal =$_POST['tanggal'];

$gaji_pokok = $_POST['gaji_pokok'];

$jml_kehadiran =$_POST['jml_kehadiran'];

$jml_absen =$_POST['jml_absen'];

$jam_lembur = $_POST['jam_lembur'];



$tunjangan_transport =$_POST['tunjangan_transport'];

$tunjangan_overtime =$_POST['tunjangan_overtime'];

$tunjangan_jab = $_POST['tunjangan_jab'];

$lembur =$jam_lembur*$uang_lembur;

$cuti_haid =$_POST['cuti_haid'];

$pend_lainnya =$_POST['pend_lainnya'];

$shift_milk =$_POST['shift_milk'];

$tunj_mk = $_POST['tunj_mk'];

$sisa_lalu =$_POST['sisa_lalu'];

$jml_pend

=$gaji_pokok+$tunjangan_makan+$tunjangan_transport+$tunjangan_overtime+$tunjangan_

jab+$lembur+$cuti_haid+$pend_lainnya+$shift_milk+$tunj_mk+$sisa_lalu;

$spn = $_POST['spn'];

$pph21 =$_POST['pph21'];

$pot_gaji =$jml_pend/20*$jml_absen;

$iur_kop =$_POST['iur_kop'];

$bpjs =$_POST['bpjs'];

$jamsostek = $_POST['jamsostek'];

$pot_lainnya = $_POST['pot_lainnya'];

$jml_pot

=$spn+$pph21+$pot_gaji+$iur_kop+$bpjs+$jamsostek+$pot_lainnya;

$gaji_bersih =$jml_pend-$jml_pot;

$sql = "INSERT INTO tbl_penggajian SET id_gaji='$id_gaji',

nik='$nik', periode ='$periode' ,tanggal ='$tanggal',gaji_pokok ='$gaji_pokok',

jml_kehadiran='$jml_kehadiran',jml_absen='$jml_absen', jam_lembur ='$jam_lembur'

,uang_lembur ='$uang_lembur',tunjangan_makan

='$tunjangan_makan',tunjangan_transport

='$tunjangan_transport',tunjangan_overtime='$tunjangan_overtime', tunjangan_jab

='$tunjangan_jab' ,lembur ='$lembur',cuti_haid ='$cuti_haid',pend_lainnya

='$pend_lainnya',shift_milk='$shift_milk', tunj_mk ='$tunj_mk' ,sisa_lalu

='$sisa_lalu',jml_pend ='$jml_pend',spn ='$spn',pph21 ='$pph21',pot_gaji

='$pot_gaji',iur_kop ='$iur_kop',bpjs='$bpjs', jamsostek ='$jamsostek'

,pot_lainnya ='$pot_lainnya',jml_pot ='$jml_pot',gaji_bersih ='$gaji_bersih'";


}

?>

<table border="1">

<tr>

<th align="center">ID Gaji</th>

<th align="center">NIK & Nama Karyawan</th>

<th align="center">Periode</th>

<th align="center">Tanggal</th>

<th align="center">Gaji Pokok</th>

<th align="center">Jam Kehadiran - Jumlah Absen</th>

<th align="center">Jam Lembur - Uang Lembur</th>

<th align="center">Tunj. Makan - Tunj. Transport</th>

<th align="center">Tunj. Overtime - Tunj. Jabatan</th>

<th align="center">Lembur</th>

<th align="center">Cuti Haid - Pend. Lainnya</th>

<th align="center">Shift Milk - Tunj. MK</th>

<th align="center">Sisa Lalu</th>

<th align="center">Jumlah Pendapatan</th>

<th align="center">SPN</th>

<th align="center">PPH21</th>

58

<th align="center">Pot. Gaji</th>

<th align="center">Iur.Kop</th>

<th align="center">BPJS</th>

<th align="center">Jamsostek</th>

<th align="center">Pot. Lainnya</th>

<th align="center">Jumlah Potongan</th>

<th align="center">Gaji Bersih</th>


</tr>

<?php

$sql = "SELECT * FROM tbl_penggajian tp, karyawan ka WHERE tp.nik = ka.nik";



$out_id_gaji=$data['id_gaji'];



$out_periode=$data['periode'];

$out_tanggal=$data['tanggal'];


$out_jml_kehadiran=$data['jml_kehadiran'];

$out_jml_absen=$data['jml_absen'];

$out_jam_lembur=$data['jam_lembur'];



$out_tunjangan_transport=$data['tunjangan_transport'];

$out_tunjangan_overtime=$data['tunjangan_overtime'];


$out_lembur=$data['lembur'];

$out_cuti_haid=$data['cuti_haid'];

$out_pend_lainnya=$data['pend_lainnya'];

$out_shift_milk=$data['shift_milk'];

$out_tunj_mk=$data['tunj_mk'];

$out_sisa_lalu=$data['sisa_lalu'];

$out_jml_pend=$data['jml_pend'];

$out_spn=$data['spn'];

$out_pph21=$data['pph21'];

$out_pot_gaji=$data['pot_gaji'];

$out_iur_kop=$data['iur_kop'];

$out_bpjs=$data['bpjs'];

$out_jamsostek=$data['jamsostek'];

$out_pot_lainnya=$data['pot_lainnya'];

$out_jml_pot=$data['jml_pot'];

$out_gaji_bersih=$data['gaji_bersih'];

?>

<tr>

<td height="27"><?php echo $out_id_gaji; ?></td>

<td><?php echo $out_nik ."-". $out_nama_kry; ?></td>

<td><?php echo $out_periode; ?></td>

<td><?php echo $out_tanggal; ?></td>


<td><?php echo $out_jml_kehadiran."-".$out_jml_absen; ?></td>

<td><?php echo $out_jam_lembur."-".$out_uang_lembur; ?></td>

<td><?php echo $out_tunjangan_makan."-".$out_tunjangan_transport; ?></td>

<td><?php echo $out_tunjangan_overtime."-".$out_tunjangan_jab; ?></td>

<td><?php echo $out_lembur; ?></td>

<td><?php echo $out_cuti_haid."-".$out_pend_lainnya; ?></td>

<td><?php echo $out_shift_milk."-".$out_tunj_mk; ?></td>

<td><?php echo $out_sisa_lalu; ?></td>

<td><?php echo $out_jml_pend; ?></td>

<td><?php echo $out_spn; ?></td>

<td><?php echo $out_pph21; ?></td>

<td><?php echo $out_pot_gaji; ?></td>

<td><?php echo $out_iur_kop; ?></td>

<td><?php echo $out_bpjs; ?></td>

<td><?php echo $out_jamsostek; ?></td>

<td><?php echo $out_pot_lainnya; ?></td>

<td><?php echo $out_jml_pot; ?></td>

<td><?php echo $out_gaji_bersih; ?></td>

<td align="center">

<a href="edit_penggajian.php?id_gaji=<?php echo $data['id_gaji']

?>"><b>Edit</b></A>

<a href="delete_penggajian.php?id_gaji=<?php echo $data['id_gaji']

?>"><b>Hapus</b></A>

</td>

59

</tr>

<?php

}

$sql = "SELECT SUM(gaji_bersih) as total_jumlah FROM tbl_penggajian";

$query=mysql_query($sql);

while($data=mysql_fetch_array($query)){

$out_total_jumlah=$data['total_jumlah'];

}

?>

<tr>

<td height="22" colspan=22>Total</td>

<td height="22"><?php echo $out_total_jumlah; ?></td></tr>

</table>

</center>

</td>

</TABLE>

</body>

</html>

Edit_penggajian.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"



<head>


<title>Edit Data Gaji</title>

</head>



<TR>

<TD height="187" COLSPAN="2"><IMG SRC="apparels.jpg" WIDTH=2000 HEIGHT=187></TD>

</TR>

<TR>







</TD>


<?php


$data = $_GET['id_gaji'];

$query=mysql_query ("SELECT * FROM tbl_penggajian WHERE id_gaji='$data'");


$periode =$row['periode'];

$tanggal =$row['tanggal'];

$gaji_pokok = $row['gaji_pokok'];

$jml_kehadiran =$row['jml_kehadiran'];

$jml_absen =$row['jml_absen'];

$jam_lembur = $row['jam_lembur'];



$tunjangan_transport =$row['tunjangan_transport'];

$tunjangan_overtime =$row['tunjangan_overtime'];

$tunjangan_jab = $row['tunjangan_jab'];

$cuti_haid =$row['cuti_haid'];

$pend_lainnya =$row['pend_lainnya'];

$shift_milk =$row['shift_milk'];

$tunj_mk = $row['tunj_mk'];

$sisa_lalu =$row['sisa_lalu'];

$spn = $row['spn'];

$pph21 =$row['pph21'];

// $pot_gaji =$row['pot_gaji'];

$iur_kop =$row['iur_kop'];

$bpjs =$row['bpjs'];

$jamsostek = $row['jamsostek'];

$pot_lainnya = $row['pot_lainnya'];

60

echo "<html>";

echo "<body>";


Penggajian</b></font>";


echo "<form method=\"post\" action=\"update_penggajian.php?id_gaji=$data\"


echo "<br>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Periode

</font></td><td>:</td><td><input type='text' name='periode' value='$periode'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Tanggal

</font></td><td>:</td><td><input type='text' name='tanggal' value='$tanggal'

size='30'> </td></tr>";



size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Jumlah Kehadiran

</font></td><td>:</td><td><input type='text' name='jml_kehadiran'

value='$jml_kehadiran'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Jumlah Absen

</font></td><td>:</td><td><input type='text' name='jml_absen' value='$jml_absen'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Jam Lembur

</font></td><td>:</td><td><input type='text' name='jam_lembur' value='$jam_lembur'

size='30'> </td></tr>";




size='30'> </td></tr>";




size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Tunjangan Transport

</font></td><td>:</td><td><input type='text' name='tunjangan_transport'

value='$tunjangan_transport'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Tunjangan Overtime

</font></td><td>:</td><td><input type='text' name='tunjangan_overtime'

value='$tunjangan_overtime'

size='30'> </td></tr>";




size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Cuti Haid

</font></td><td>:</td><td><input type='text' name='cuti_haid' value='$cuti_haid'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Pendapatan Lainnya

</font></td><td>:</td><td><input type='text' name='pend_lainnya'

value='$pend_lainnya'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Shift Milk

</font></td><td>:</td><td><input type='text' name='shift_milk' value='$shift_milk'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Tunjangan MK

61

</font></td><td>:</td><td><input type='text' name='tunj_mk' value='$tunj_mk'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Sisa Lalu

</font></td><td>:</td><td><input type='text' name='sisa_lalu' value='$sisa_lalu'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>SPN

</font></td><td>:</td><td><input type='text' name='spn' value='$spn'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>PPH21

</font></td><td>:</td><td><input type='text' name='pph21' value='$pph21'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Iuran Koperasi

</font></td><td>:</td><td><input type='text' name='iur_kop' value='$iur_kop'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>BPJS

</font></td><td>:</td><td><input type='text' name='bpjs' value='$bpjs'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>JAMSOSTEK

</font></td><td>:</td><td><input type='text' name='jamsostek' value='$jamsostek'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Potongan Lainnya

</font></td><td>:</td><td><input type='text' name='pot_lainnya'

value='$pot_lainnya'

size='30'> </td></tr>";




}

?>

Update_penggajian.php <?php


$id_gaji = $_GET['id_gaji'];

$periode =$_POST['periode'];

$tanggal =$_POST['tanggal'];

$gaji_pokok = $_POST['gaji_pokok'];

$jml_kehadiran =$_POST['jml_kehadiran'];

$jml_absen =$_POST['jml_absen'];

$jam_lembur = $_POST['jam_lembur'];



$tunjangan_transport =$_POST['tunjangan_transport'];

$tunjangan_overtime =$_POST['tunjangan_overtime'];

$tunjangan_jab = $_POST['tunjangan_jab'];

$lembur =$jam_lembur*$uang_lembur;

$cuti_haid =$_POST['cuti_haid'];

$pend_lainnya =$_POST['pend_lainnya'];

$shift_milk =$_POST['shift_milk'];

$tunj_mk = $_POST['tunj_mk'];

$sisa_lalu =$_POST['sisa_lalu'];

$jml_pend

=$gaji_pokok+$tunjangan_makan+$tunjangan_transport+$tunjangan_overtime+$tunjangan_

jab+$lembur+$cuti_haid+$pend_lainnya+$shift_milk+$tunj_mk+$sisa_lalu;

$spn = $_POST['spn'];

$pph21 =$_POST['pph21'];

$pot_gaji =$jml_pend/13*$jml_absen;

$iur_kop =$_POST['iur_kop'];

$bpjs =$_POST['bpjs'];

$jamsostek = $_POST['jamsostek'];

$pot_lainnya = $_POST['pot_lainnya'];

62

$jml_pot

=$spn+$pph21+$pot_gaji+$iur_kop+$bpjs+$jamsostek+$pot_lainnya;

$gaji_bersih =$jml_pend-$jml_pot;

$query=mysql_query ("UPDATE tbl_penggajian SET periode ='$periode', tanggal

='$tanggal', gaji_pokok ='$gaji_pokok', jml_kehadiran ='$jml_kehadiran', jml_absen

='$jml_absen', jam_lembur ='$jam_lembur', uang_lembur ='$uang_lembur',

tunjangan_makan ='$tunjangan_makan', tunjangan_transport ='$tunjangan_transport',

tunjangan_overtime ='$tunjangan_overtime', tunjangan_jab ='$tunjangan_jab', lembur

='$lembur', cuti_haid ='$cuti_haid', pend_lainnya ='$pend_lainnya', shift_milk

='$shift_milk', tunj_mk ='$tunj_mk', sisa_lalu ='$sisa_lalu', jml_pend

='$jml_pend', spn ='$spn', pph21 ='$pph21', pot_gaji ='$pot_gaji', iur_kop

='$iur_kop', bpjs ='$bpjs', jamsostek ='$jamsostek',pot_lainnya

='$pot_lainnya',jml_pot ='$jml_pot',gaji_bersih ='$gaji_bersih' WHERE

id_gaji='$id_gaji'",$connection)or die (mysql_error());

if($query) {

?>


document.location='penggajian.php'</script>

<?php

}

?>

Delete_penggajian.php <?php



$query = "DELETE FROM tbl_penggajian WHERE id_gaji = '$id_gaji'";


?>


document.location='penggajian.php'</script>

<?php

?>

Laporan.php <?php


?>




<head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>Laporan Gaji</title>

<script>

function showInfoPenggajian(str) {

if (str=="") {


return;

}






}




}

}

xmlhttp.open("GET","get_info_penggajian.php?g="+str,true);

xmlhttp.send();

}

</script>

</head>

<body bgcolor="#99CC66">

63

<TR><p class="header"><font size="3">PT SAI APPAREL INDUSTRIES</font></p>

<TR><TD><p>Laporan Gaji Karyawan </p></TD></TR>

<TR><td width="200">Periode</td>

<td><SELECT NAME="periode" required onchange="showInfoPenggajian(this.value);"

onkeyup="showInfoPenggajian(this.value);">

<?php

$sql = "SELECT periode FROM tbl_penggajian";




echo $result['periode'];

echo "\">";


echo "</option>";

}

?>

</select></td>

</TR>

<br /><hr>

<center></center>

<center>

<table border="1">

<tr>

<th align="center">ID Gaji</th>























</tr>

<?php

$sql = "SELECT * FROM tbl_penggajian tp, karyawan ka WHERE tp.nik = ka.nik";

























64









?>

<tr>

<td height="27"><?php echo $out_id_gaji; ?></td>























<td></td>

</tr>

<?php

}





}

?>

<tr>

<td height="22" colspan=22>Total</td>


</table>

</center> </td>

</TABLE>

<tr><center>

<td align="left"><p><A HREF="penggajian.php"><b>KEMBALI</b></A><br >

</p></td><td align="left"><A HREF="index.php"><b>HOME</b></A></td>

</center></tr>

</body>

</html>

Loginkry.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"



<head>


<title>Login Karyawan</title></head>



<br>



65

<TR><TD align="center" valign="top" bordercolorlight="#33CC00"><center><h1>LOG IN

KARYAWAN</h1>

<?php

if (!empty($_GET['error'])) {

if ($_GET['error'] == 1) {

echo '<h3>username dan password belum diisi!</h3>';


echo '<h3>username belum diisi!</h3>';


echo '<h3>password belum diisi!</h3>';


echo '<h3>username dan password tidak terdaftar!</h3>';

}

}

?>

<form name="login" action="login_proses2.php" method="post">

<center>

<table border="0" cellpadding="5" cellspacing="0">

<tr>

<td>User Name</td>

<td>:</td>

<td><input type="text" name="nama_kry"></td>

</tr>

<tr>

<td>Password</td>

<td>:</td>

<td><input type="password" name="nik"></td>

</tr>

<tr align="center">

<td colspan="3"><input type="submit" name="login2" value="Login">


diinput?')">

</table></center>

</form>

</TD>

<A HREF="index.php"><b>Home</b></A>

</body>

</html>

Login_proses2.php <?php


$nama_kry = $_POST['nama_kry'];

$nik = $_POST['nik'];

$username = mysql_real_escape_string($username);

$password = mysql_real_escape_string($nik);

if (empty($nama_kry) && empty($nama_kry)) {

header('Location: loginkry.php?error=1');

break;

} else if (empty($nama_kry)) {


break;

} else if (empty($nik)) {


break;

}

$q = mysql_query("select * from karyawan where nama_kry='$nama_kry' and

nik='$nik'");

$cek=mysql_num_rows($q);

//$q ==1 yang di if tak ganti sama tak tambahi yang di baris 30

if ($cek) {

session_start();

$_SESSION['nik']=$nik;

header('Location: tanda_gaji2.php');

} else {

session_start();

$_SESSION['nik']=$nik;


}

66

?>

Tanda_gaji2.php <?php


?>




<head>


<title>Laporan Gaji</title>

<script>

function showInfoPenggajian(str) {

if (str=="") {


return;

}






}




}

}

xmlhttp.open("GET","get_info_penggajian.php?g="+str,true);

xmlhttp.send();

}</script>

</head><body bgcolor="#99CC66">

<TR><p class="header"><font size="3">PT SAI APPAREL INDUSTRIES</font></p>

<TR><TD><p>Laporan Gaji Karyawan </p></TD></TR>

<p>NIK :

<?php

session_start();

echo $_SESSION['nik'];

?>

</p><p></p><TR><td width="200">Periode</td>

<td><SELECT NAME="periode" required onchange="showInfoPenggajian(this.value);"

onkeyup="showInfoPenggajian(this.value);">

<?php

$sql = "SELECT periode FROM tbl_penggajian";





echo "\">";


echo "</option>";

}

?>

</select></td></TR><br /><hr>

<center></center>

<center><table border="1">

<tr><th align="center">ID Gaji</th>















67









<th align="center">pilihan</th></tr>

<?php

$sql = "SELECT * FROM tbl_penggajian tp, karyawan ka WHERE tp.nik = ka.nik and

tp.nik = '".$_SESSION['nik']."'";

































?>

<tr><td height="27"><?php echo $out_id_gaji; ?></td>























<td align="center">

<a href="slip_gaji2.php?id_gaji=<?php echo $data['id_gaji']

?>"><b>Slip</b></A></td></tr>

<?php

}


68




}

?>

<tr><td height="22" colspan=22>Total</td>


</table></center></td></TABLE>

<tr><center><td align="left"><p><A HREF="loginkry.php"><b>KEMBALI</b></A><br >

</p></td><td align="left"><A HREF="index.php"><b>HOME</b></A></td></center></tr>

</body>

</html>

slip_gaji2.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"



<head>


<title>Edit Data Gaji</title>

</head>


<?php



$query=mysql_query ("SELECT * FROM tbl_penggajian WHERE id_gaji='$id_gaji'");


$nik=$row['nik'];

$periode =$row['periode'];

$gaji_pokok = $row['gaji_pokok'];

$jml_kehadiran =$row['jml_kehadiran'];

$jml_absen =$row['jml_absen'];

$jam_lembur = $row['jam_lembur'];



$tunjangan_transport =$row['tunjangan_transport'];

$tunjangan_overtime =$row['tunjangan_overtime'];

$tunjangan_jab = $row['tunjangan_jab'];

$cuti_haid =$row['cuti_haid'];

$pend_lainnya =$row['pend_lainnya'];

$shift_milk =$row['shift_milk'];

$tunj_mk = $row['tunj_mk'];

$sisa_lalu =$row['sisa_lalu'];

$jml_pend=$row['jml_pend']-$sisa_lalu;

$spn = $row['spn'];

$pph21 =$row['pph21'];

$pot_gaji =$row['pot_gaji'];

$iur_kop =$row['iur_kop'];

$bpjs =$row['bpjs'];

$jamsostek = $row['jamsostek'];

$pot_lainnya = $row['pot_lainnya'];

$jml_pot=$row['jml_pot']-$pph21;

$jml_kotor=$jml_pend-$jml_pot-$sisa_lalu+$pph21;

$gaji_bersih=$row['gaji_bersih'];

echo "<html>";

echo "<body>";

echo "<font face='tahoma' color='green' size=4><b>PT SAI Apparel : SLIP

GAJI</b></font>";


echo "<br>";

echo "<td><input type='text' name='periode' value='$periode'

size='30'> </td>";

echo "<tr><td><font face='Tahoma' color='black' size=2>NIK

</font></td><td>:</td><td><input type='text' name='nik' value='$nik'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2><b>PENDAPATAN</b>

</font></td><td></td><td></td>

69

<td><font face='Tahoma' color='black' size=2><b>POTONGAN</b>

</font></td></tr>";



size='30'> </td>

<td><font face='Tahoma' color='black' size=2>SPN

</font></td><td>:</td><td><input type='text' name='spn' value='$spn'

size='30'> </td></tr>";




size='30'> </td>

<td><font face='Tahoma' color='black' size=2>Pot. Gaji

</font></td><td>:</td><td><input type='text' name='pot_gaji' value='$pot_gaji'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Tunjangan Transport

</font></td><td>:</td><td><input type='text' name='tunjangan_transport'

value='$tunjangan_transport'

size='30'> </td>

<td><font face='Tahoma' color='black' size=2>Iuran Koperasi

</font></td><td>:</td><td><input type='text' name='iur_kop' value='$iur_kop'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Tunjangan Overtime

</font></td><td>:</td><td><input type='text' name='tunjangan_overtime'

value='$tunjangan_overtime'

size='30'> </td>

<td><font face='Tahoma' color='black' size=2>BPJS

</font></td><td>:</td><td><input type='text' name='bpjs' value='$bpjs'

size='30'> </td></tr>";




size='30'> </td>

<td><font face='Tahoma' color='black' size=2>JAMSOSTEK

</font></td><td>:</td><td><input type='text' name='jamsostek' value='$jamsostek'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Cuti Haid

</font></td><td>:</td><td><input type='text' name='cuti_haid' value='$cuti_haid'

size='30'> </td>

<td><font face='Tahoma' color='black' size=2>Potongan Lainnya

</font></td><td>:</td><td><input type='text' name='pot_lainnya'

value='$pot_lainnya'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Pendapatan Lainnya

</font></td><td>:</td><td><input type='text' name='pend_lainnya'

value='$pend_lainnya'

size='30'> </td>

<td><font face='Tahoma' color='black' size=2><b>Sub Total

</font></td><td>:</td><td><input type='text' name='jml_pot' value='$jml_pot'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Shift Milk

</font></td><td>:</td><td><input type='text' name='shift_milk' value='$shift_milk'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Tunjangan MK

</font></td><td>:</td><td><input type='text' name='tunj_mk' value='$tunj_mk'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2><b>Sub Total

</font></td><td>:</td><td><input type='text' name='jml_pend' value='$jml_pend'

size='30'> </td>

<td><font face='Tahoma' color='black' size=2>PPH21

</font></td><td>:</td><td><input type='text' name='pph21' value='$pph21'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2><b>Jumlah Kotor

70

</font></td><td>:</td><td><input type='text' name='jml_kotor' value='$jml_kotor'

size='30'> </td>

<td><font face='Tahoma' color='black' size=2>Sisa Lalu

</font></td><td>:</td><td><input type='text' name='sisa_lalu' value='$sisa_lalu'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2><b>Jumlah Bersih

</font></td><td>:</td><td><input type='text' name='gaji_bersih'

value='$gaji_bersih'

size='30'> </td>

<td><font face='Tahoma' color='black' size=2>Sisa Sekarang

</font></td><td>:</td><td><input type='text' name='sisa_sekarang' value='0'

size='30'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>Jam Lembur

</font></td><td>:</td><td><input type='text' name='jam_lembur' value='$jam_lembur'

size='10'> </td></tr>";




size='10'> </td></tr>";

echo "<tr><td><font face='Tahoma' color='black' size=2>JK

</font><input type='text' name='jml_kehadiran' value='$jml_kehadiran'

size='5'> ,

<font face='Tahoma' color='black' size=2>DC</font><input type='text' name='DC'

value='0'

size='5'> ,

<font face='Tahoma' color='black' size=2>Absent

</font><input type='text' name='jml_absen' value='$jml_absen'

size='5'> </td></tr>";


value='CETAK'/></font></td></tr>";


}

?>

<table><p><A HREF="tanda_gaji2.php"><b>KEMBALI</b></A></p>

</table>

71

Lampiran 3Formulir

Slip Gaji Karyawan

72

Tanda Terima Gaji

73

Lampiran 4 Surat Keterangan Kerja Praktek

74

Lampiran 5 Rekapitulasi Kehadiran Kerja Praktek

75

Lampiran 6 Jurnal Kerja Praktek

Halaman Depan

76

Halaman Belakang

77

Lampiran 7 Jurnal Bimbingan Tugas Akhir

Halaman Depan

78

Halaman Belakang

lampiran 1 struktur organisasi perusahaan struktur...

Documents