<!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>Untitled Document</title>
<link href="css/styles.css" rel="stylesheet" type="text/css" />
<script src="js/jquery-1.7.2.min.js"></script>
<script type='text/javascript' src='http://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.min.js'></script>
<script type='text/javascript' src='js/example.js'></script>
<link type="image/gif" href="image/kecil_879522dinas-perhubungan.jpg" rel="icon"/>
</head>
<SCRIPT language="Javascript">
function validasi () {
var nip=document.insert_pegawai.txtnip.value
var nama = document.insert_pegawai.txtnama.value
var golongan = document.insert_pegawai.txtgolongan.value
var jabatan = document.insert_pegawai.txtjabatan.value
var pendidikan = document.insert_pegawai.txtpendidikan.value
var alamat = document.insert_pegawai.txtalamat.value
if (nip.length == 0 || nama.length == 0 || golongan.length == 0 || jabatan.length == 0 || pendidikan.length == 0 || alamat.length == 0 )
window.alert ("inputan masih ada yang kosong !!!!");
else
document.insert_pegawai.submit() ;
}
$(document).ready(function(){
$('#bglb,#trgt').hide();
$("#link").click(function(){
$('#bglb,#trgt').fadeIn('fast');
});
$('#bglb,.cllb').click(function(){
$('#bglb,#trgt').fadeOut('fast');
});
$(".datapeg a").click(function(){
ambil(this.id);
});
function ambil(nip){
url='getbendahara.php?nip=' + nip;
$.getJSON(url,
function(data){
$.each(data, function(index, entry){
alert(entry['nip']);
$('#txtnama').val(entry['nama']);
});
});
return false;
};
});
</script>
<body>
<div id="bglb"></div>
<div id="trgt">
<?php
include "config/koneksi.php";
$query="select NIP, NAMA from pegawai";
$sql = mysql_query($query);
echo "<table border=1 align=center >
<tr>
<th align=center>Nip</th>
<th align=center>Jenis Nama</th>
</tr>";
while($data = mysql_fetch_array($sql)){
echo "<tr class='datapeg'>
<td><a href='#' id=".$data['NIP']." class='cllb' >".$data['NIP']."</a></td>
<td>".$data['NAMA']."</td>
</tr>";
}
echo "</table>";
?>
</div>
<div id="wrapper">
<?php
include "include/menu.php";
?>
</div>
<?php
include "config/koneksi.php";
//PROSES SIMPAN BENDAHARA
if (isset($_POST['input'])) {
$npwp = $_POST['txtnpwp'];
$nip = addslashes (strip_tags ($_POST['txtnip']));
$jenis_bendahara =$_POST['txtjenis_bendahara'];
$nama_bank = addslashes (strip_tags ($_POST['txtnama_bank']));
$no_rekening = addslashes (strip_tags ($_POST['txtno_rekening']));
//INSERT BENDAHARA
$query = ("INSERT INTO bendahara VALUES ('$npwp','$nip','$jenis_bendahara','$nama_bank','$no_rekening')") ;
$sql = mysql_query ($query);
if ($sql){
echo "<h4> Simpan Data Berhasil </h4>";
}else{
echo "<h4>Simpan Data Gagal<br></h4>";
echo "<h5>'".mysql_error()."' </h5>";
}
}
?>
</div>
<div id="page-wrap">
<div class="login-block">
<form action="" method="post" name="input">
<p><label><span>Npwp</span></label><input type="text" name="txtnpwp" ></p>
<tr>
<td width=200><font color=#FFFFFF>Nip</font></td>
<td> <input type='text' name='txtnip' size=25 id="txtnip" />
<input type='text' name='txtnama' size=30 id="txtnama">
<input type=button name=Input value=Browse id='link'>
</td>
</tr>
<p><label>Jenis Bendahara</label><input type="text" name="txtjenis_bendahara" /></p>
<p><label>Nama Bank</label><input type="text" name="txtnama_bank"/></p>
<p><label >No Rekening</label><input type="text" name="txtno_rekening" /></p>
<p class="submit-wrap"><input type="submit" id="ftp-submit" class="button" value="Save" name="input" /></p>
</form>
</div>
</div>
</body>
</html>