function ambilAlamat()
{
$nama_karyawan = $_POST['nama_karyawan'];
$qry2 = "SELECT * FROM tbl_karyawan WHERE nama_karyawan = '{$nama_karyawan}'";
$sql2 = custom_query($qry2);
while ($array2 = mysqli_fetch_array($sql2)) {
echo $array2['alamat'];
}
}
$update1 = custom_query($tblupdate1);
while ($r1 = mysqli_fetch_array($update1)) {
$hasil1 = $r1['jumlah'];
}
if ($jumlah > $hasil) {
$ok = $hasil1 + ($jumlah - $hasil);
$sqlupdate = "UPDATE tbl_barang SET jumlah = '{$ok}' WHERE part_number = '{$part_number}'";
$jmlupdate = custom_query($sqlupdate);
$dbinput = "UPDATE `tbl_det_masuk` SET part_number = '{$part_number}', description = '{$deskripsi}', jumlah = '{$jumlah}', tgl_masuk = '{$tgl_masuk}', username = '******', keterangan = '{$keterangan}', id_cabang = '{$id_cabang}', id_dasar = '{$id_dasar}' WHERE no_form_m = '{$noform}'";
$input = custom_query($dbinput);
echo '<div align="center" style="color:green; font-size:15px;"><b>Data barang masuk berhasil di edit. silakan klik <a href="detbrgmasuk.php">disini </a>untuk melihat perubahan</b></div><br />';
}
if ($jumlah < $hasil) {
$ok1 = $hasil1 - ($hasil - $jumlah);
$sqlupdate1 = "UPDATE tbl_barang SET jumlah = '{$ok1}' WHERE part_number = '{$part_number}'";
$jmlupdate1 = custom_query($sqlupdate1);
$dbinput = "UPDATE `tbl_det_masuk` SET part_number = '{$part_number}', description = '{$deskripsi}', jumlah = '{$jumlah}', tgl_masuk = '{$tgl_masuk}', username = '******', keterangan = '{$keterangan}', id_cabang = '{$id_cabang}', id_dasar = '{$id_dasar}' WHERE no_form_m = '{$noform}'";
$input = custom_query($dbinput);
echo '<div align="center" style="color:green; font-size:15px;"><b>Data barang masuk berhasil di edit. silakan klik <a href="detbrgmasuk.php">disini </a>untuk melihat perubahan</b></div><br />';
} else {
$dbinput = "UPDATE `tbl_det_masuk` SET part_number = '{$part_number}', description = '{$deskripsi}', jumlah = '{$jumlah}', tgl_masuk = '{$tgl_masuk}', username = '******', keterangan = '{$keterangan}', id_cabang = '{$id_cabang}', id_dasar = '{$id_dasar}' WHERE no_form_m = '{$noform}'";
$input = custom_query($dbinput);
if ($input) {
echo "<script>alert('Selamat, data barang masuk telah terupdate');javascript:window.location='status.php';</script>";
} else {
// echo $dbinput;
echo "<script>alert('Maaf, data barang masuk gagal terupdate');javascript:window.location='status.php';</script>";
}
}
}
die;
<div id="main_content">
<?php
include "atas.php";
?>
<p align="center"><strong>Master Data keterangan</strong></p>
<table align="center" width="801" border="0">
<tr>
<td><div align="center"><strong>No.</strong></div></td>
<td><div align="center"><strong>Nama keterangan</strong></div></td>
<td colspan="2"><div align="center"><strong>Aksi</strong></div></td>
</tr>
<?php
$sql = custom_query("SELECT * FROM tbl_keterangan");
while ($r = mysqli_fetch_array($sql)) {
$no++;
?>
<tr>
<td><div align="center"><?php
echo $no;
?>
</div></td>
<td><div align="center"><?php
echo $r['nama_keterangan'];
?>
</div></td>
<option value="Bank DKI">DKI</option>
<option value="Bank Jateng">JTG</option>
<option value="Bank Mandiri">MDR</option>
<option value="Bank Pundi">PUN</option>
<option value="Bank Saudara">SDR</option>
<option value="Sinarmas">SIN</option>
</select><br>
Cabang
<select name="id_cabang" id="id_cabang">
<?php
$query = "SELECT * FROM tbl_cabang";
if ($_SESSION[level] == "operator") {
$query .= " WHERE id_cabang = " . $_SESSION['id_cabang'];
}
// echo $query;
$sql1 = custom_query($query);
while ($r1 = mysqli_fetch_array($sql1)) {
?>
<option value="<?php
echo $r1['id_cabang'];
?>
"><?php
echo $r1['nama_cabang'];
?>
</option><?php
}
?>
</select>
<input type="submit" name="pilih" id="pilih" value="Pilih">
</form></div></p>
//validasi
$pn = $_POST['pn'];
$description = $_POST['description'];
$jumlah = $_POST['jumlah'];
$query = "SELECT part_number FROM tbl_barang WHERE part_number = '{$pn}'";
$a = custom_query($query);
if (trim($pn) == '') {
$error[] = '- Part Number harus diisi';
}
if (trim(mysqli_num_rows($a) > 0)) {
$error[] = '- Part Number sudah ada, silakan ulangi kembali.';
}
if (trim($description) == '') {
$error[] = '- Deskripsi harus dipilih';
}
if (trim($jumlah) == '') {
$error[] = '- Jumlah barang harus diisi';
}
//dan seterusnya
if (isset($error)) {
echo '<div align="center" style="color:red; font-size:20px;"><b>Error</b>: <br /></div><div style="color:red;">' . implode('<br />', $error) . '</div>';
} else {
/*
jika data mau dimasukkan ke database,
maka perintah SQL INSERT bisa ditulis di sini
*/
$query1 = "INSERT INTO tbl_barang (part_number,description,jumlah) VALUES ('{$pn}','{$description}', '{$jumlah}')";
$input = custom_query($query1);
echo '<div align="center" style="color:green; font-size:15px;"><b>Data Sparepart Baru berhasil di tambah. silakan klik <a href="listbarang.php">disini</a> untuk melihat perubahan:</b></div><br />';
}
die;
<h1 align="center">
<b>Status Barang Return</b>
</h1>
<table align="center" width="1335" border="0" bordercolor="#FFFFFF">
<tr>
<td width="90"><div align="center"><strong>No. Form</strong></div></td>
<td width="174"><div align="center"><strong>Part Number</strong></div></td>
<td width="215"><div align="center"><strong>Description</strong></div></td>
<td width="53"><div align="center"><strong>Jumlah</strong></div></td>
<td width="300"><div align="center"><strong>Alasan Direturn</strong></div></td>
<td width="150"><div align="center"><strong>Tanggal Return</strong></div></td>
<td width="98"><div align="center"><strong>Operator</strong></div></td>
<td width="212"><div align="center"><strong>Keterangan</strong></div></td>
</tr>
<?php
$sql = custom_query("select * from tbl_det_return where tgl_return >= '{$startdate}' and tgl_return <= '{$enddate}' order by no_form_r desc");
while ($r = mysqli_fetch_array($sql)) {
?>
<tr>
<td><div align="center"><?php
echo $r['no_form_r'];
?>
</div></td>
<td><div align="center"><?php
echo $r['part_number'];
?>
</div></td>
<td><?php
echo $r['description'];
?>
}
</style>
</head>
</html>
<body>
<div id="header">
</div>
<div id="main_content">
<?php
include "atas.php";
?>
<p align="center"><strong>Silahkan edit form dibawah ini untuk mengedit Cabang</strong></p>
<?php
$id = $_GET['id'];
$sql = custom_query("SELECT * FROM tbl_cabang WHERE id_cabang='{$id}'");
while ($r = mysqli_fetch_array($sql)) {
?>
<form action="prosescabang.php?task=edit" method="post" id="update">
<div align="center">
<table width="400" border="6">
<input type="hidden" name="idcabang" value="<?php
echo $id;
?>
" />
<tr>
<td width="123"><strong>Nama Cabang :</strong></td>
<td class="field" width="255" bgcolor="#FFFFFF"><label for="username"></label>
<input name="nmcabang" type="text" id="nmcabang" value="<?php
echo $r['nama_cabang'];
<h1 align="center">
<b>Status Barang Return</b>
</h1>
<table align="center" width="1335" border="0" bordercolor="#FFFFFF">
<tr>
<td width="90"><div align="center"><strong>No. Form</strong></div></td>
<td width="174"><div align="center"><strong>Part Number</strong></div></td>
<td width="215"><div align="center"><strong>Description</strong></div></td>
<td width="53"><div align="center"><strong>Jumlah</strong></div></td>
<td width="250"><div align="center"><strong>Alasan Direturn</strong></div></td>
<td width="212"><div align="center"><strong>Tanggal Masuk</strong></div></td>
<td width="98"><div align="center"><strong>Operator</strong></div></td>
<td width="212"><div align="center"><strong>Keterangan</strong></div></td>
</tr>
<?php
$sql = custom_query("SELECT * \nFROM `tbl_det_return` \nORDER BY `tbl_det_return`.`no_form_r` DESC");
while ($r = mysqli_fetch_array($sql)) {
?>
<tr>
<td><div align="center"><?php
echo $r['no_form_r'];
?>
</div></td>
<td><div align="center"><?php
echo $r['part_number'];
?>
</div></td>
<td><?php
echo $r['description'];
?>
session_start();
// koneksi ke database
include "koneksi.php";
//membaca inputan user
$pwdlama = $_POST['pwdlama'];
$pwdbaru = $_POST['pwdbaru'];
$repwdbaru = $_POST['repwdbaru'];
//mencari benar tidaknya password yang lama
$sql = custom_query("SELECT * FROM tbl_user WHERE username = '******'username']}'");
$data = mysqli_fetch_array($sql);
if (trim($data['password']) != $pwdlama) {
$error[] = '- Password lama tidak sesuai';
}
//jika password yang lama benar, maka selanjutnya cek kesesuaian password baru dan konfirmasi password
if (trim($repwdbaru) != $pwdbaru) {
$error[] = '- Konfirmasi password tidak sama, harap ulangi kembali';
}
if (strlen($pwdbaru) <= 5) {
$error[] = '- Password minimal 6 karakter';
}
if (isset($error)) {
echo '<div align="center"><b>Error</b>: <br /></div>' . implode('<br />', $error);
} else {
// jika password baru dan konfirmasi password benar, maka akan di lakukan update password ke database
$query = "UPDATE tbl_user SET password = '******' WHERE username = '******'username']}'";
$update = custom_query($query);
echo '<div class="result" align="center"><b>Password berhasil di ubah. password baru anda adalah : ';
echo $pwdbaru;
'</b></div><br />';
}
<?php
session_start();
include "koneksi.php";
if (empty($_SESSION['username']) and empty($_SESSION['password'])) {
echo print "<script>alert('Maaf anda tidak memiliki akses untuk melihat halaman ini, silakan login terlebih dahulu.');javascript:window.location='formlogin.php';</script>";
} else {
if ($password = "" || ($nama_karyawan = "" || ($id_karyawan = ""))) {
echo print "<script>alert('Terjadi kesalahan, field tidak boleh kosong. Harap ulangi kembali');javascript:window.location='edituser.php';</script>";
} else {
if (isset($_POST['simpan'])) {
$username = $_POST['username'];
$password = $_POST['password'];
$nama_karyawan = $_POST['nama_karyawan'];
$level = $_POST['level'];
$id_karyawan = $_POST['id_karyawan'];
$id_cabang = $_POST['id_cabang'];
$dquery = "UPDATE tbl_user SET password='******', nama_karyawan='{$nama_karyawan}', level='{$level}', id_karyawan='{$id_karyawan}', id_cabang = '{$id_cabang}' WHERE username='******'";
$sql = custom_query($dquery);
if ($sql) {
echo "<script>alert('Selamat, data user telah terupdate');javascript:window.location='user.php';</script>";
} else {
echo "<script>alert('Maaf, data user gagal terupdate');javascript:window.location='user.php';</script>";
}
}
}
}
<?php
include "koneksi.php";
$waktu = time() + 25200;
$expired = 30;
$username = $_POST['username'];
$username = htmlentities(str_replace("'", '', $username));
$password = $_POST['password'];
$password = htmlentities(str_replace("'", '', $password));
$login = custom_query("SELECT * FROM tbl_user WHERE username='******' AND password='******'");
$hasil = mysqli_num_rows($login);
$r = mysqli_fetch_array($login);
if ($hasil > 0) {
session_start();
isset($_SESSION['username']);
isset($_SESSION['password']);
isset($_SESSION['password']);
$_SESSION['id_karyawan'] = $r['user_id'];
$_SESSION['username'] = $r['username'];
$_SESSION['password'] = $r['password'];
$_SESSION['level'] = $r['level'];
$_SESSION['id_cabang'] = $r['id_cabang'];
$_SESSION['timeout'] = $waktu + $expired;
header('location:/simdatindo');
} else {
echo print "<script>alert('Username atau password salah. Silakan mencoba kembali.');javascript:window.location='formlogin.php';</script>";
}
<?php
session_start();
include "koneksi.php";
if (empty($_SESSION['username']) and empty($_SESSION['password'])) {
echo print "<script>alert('Maaf anda tidak memiliki akses untuk melihat halaman ini, silakan login terlebih dahulu.');javascript:window.location='formlogin.php';</script>";
} else {
$username = $_GET['username'];
$sql = custom_query("DELETE FROM tbl_user WHERE username='******'");
if ($sql) {
echo print "<script>alert('Selamat, data user telah dihapus');javascript:window.location='user.php';</script>";
} else {
echo print "<script>alert('Maaf, data user gagal dihapus');javascript:window.location='user.php';</script>";
}
}
}
</style>
</head>
</html>
<body>
<div id="header">
</div>
<div id="main_content">
<?php
include "atas.php";
?>
<p align="center"><strong>Silahkan edit form dibawah ini untuk mengedit user</strong></p>
<?php
$username = $_GET['username'];
$sql = custom_query("SELECT * FROM tbl_user WHERE username='******'");
while ($r = mysqli_fetch_array($sql)) {
?>
<form action="updateuser.php" method="post" id="update">
<div align="center">
<table width="400" border="6">
<tr>
<td width="123"><strong>Username :</strong></td>
<td class="field" width="255" bgcolor="#FFFFFF"><label for="username"></label>
<input name="username" type="text" id="username" value="<?php
echo $r['username'];
?>
" readonly></td>
</tr>
<tr>
<td width="90"><div align="center"><strong>No. Form</strong></div></td>
<td width="174"><div align="center"><strong>Part Number</strong></div></td>
<td width="215"><div align="center"><strong>Description</strong></div></td>
<td width="215"><div align="center"><strong>Dasar Barang masuk</strong></div></td>
<td width="53"><div align="center"><strong>Jumlah</strong></div></td>
<td width="53"><div align="center"><strong>Cabang</strong></div></td>
<td width="212"><div align="center"><strong>Tanggal Masuk</strong></div></td>
<td width="98"><div align="center"><strong>Operator</strong></div></td>
<td width="212"><div align="center"><strong>Keterangan</strong></div></td>
</tr>
<?php
$where = "";
if ($_SESSION[level] == "operator") {
$where = " WHERE tbl_det_masuk.id_cabang = " . $_SESSION['id_cabang'];
}
$sql = custom_query("SELECT * \nFROM `tbl_det_masuk` LEFT JOIN tbl_keterangan on keterangan = id_keterangan \nLEFT JOIN tbl_cabang on tbl_det_masuk.id_cabang = tbl_cabang.id_cabang\nLEFT JOIN tbl_dasar on tbl_det_masuk.id_dasar = tbl_dasar.id_dasar\n{$where}\nORDER BY `tbl_det_masuk`.`no_form_m` DESC");
while ($r = mysqli_fetch_array($sql)) {
?>
<tr>
<td><div align="center"><?php
echo $r['no_form_m'];
?>
</div></td>
<td><div align="center"><?php
echo $r['part_number'];
?>
</div></td>
<td><?php
echo $r['description'];
?>
}
?>
</table>
<?php
} else {
?>
<h1 align="center"><strong>Maaf, Tidak Ditemukan hasil pencarian dengan kata kunci " <?php
echo $cari;
?>
"</strong></h1>
<?php
}
}
if ($status == "brgret") {
$query7 = "SELECT * FROM tbl_det_return WHERE no_form_r LIKE '%{$cari}%' OR part_number LIKE '%{$cari}%' OR description LIKE '%{$cari}%' OR alasan LIKE '%{$cari}%' OR username LIKE '%{$cari}%' OR tgl_return LIKE '%{$cari}%' OR keterangan LIKE '%{$cari}%' ORDER BY no_form_r DESC";
$sql7 = custom_query($query7);
$total7 = mysqli_num_rows($sql7);
if ($total7 > 0) {
?>
<style>
table{
width:1180px;
margin-bottom:10px;
border-top-width: medium;
border-right-width: medium;
border-bottom-width: medium;
border-left-width: medium;
border-top-style: none;
border-right-style: none;
border-bottom-style: none;
border-left-style: none;
<?php
session_start();
include "koneksi.php";
if (empty($_SESSION['username']) and empty($_SESSION['password'])) {
echo print "<script>alert('Maaf anda tidak memiliki akses untuk melihat halaman ini, silakan login terlebih dahulu.');javascript:window.location='formlogin.php';</script>";
} else {
$id_karyawan = $_GET['id_karyawan'];
$sql = custom_query("DELETE FROM tbl_karyawan WHERE id_karyawan='{$id_karyawan}'");
if ($sql) {
echo print "<script>alert('Selamat, data user telah dihapus');javascript:window.location='karyawan.php';</script>";
} else {
echo print "<script>alert('Maaf, data user gagal dihapus');javascript:window.location='karyawan.php';</script>";
}
}
<td width="173"><div align="center"><strong>BANK</strong></div></td>
<td width="315"><div align="center"><strong>Lokasi</strong></div></td>
<td width="175"><div align="center"><strong>Serial Number</strong></div></td>
<td width="170"><div align="center"><strong>Install Date</strong></div></td>
</font>
</tr>
<?php
if (isset($_POST['pilih'])) {
$bank1 = $_POST['Bank'];
if ($bank1 == ALL) {
$query = "SELECT * FROM tbl_atm ORDER BY bank";
$result = custom_query($query) or die('Error');
} else {
$query = "SELECT * FROM tbl_atm WHERE bank = '{$bank1}' ORDER BY id_atm";
$result = custom_query($query) or die('Error');
}
while ($r1 = mysqli_fetch_array($result)) {
$no++;
?>
<tr>
<td><div align="center"><?php
echo $no;
?>
</div></td>
<td><div align="center"><?php
echo $r1['id_atm'];
?>
</div></td>
<td><div align="center"><?php
if (trim($alasan) == '') {
$error[] = '- Alasan barang direturn harus diisi';
}
if (trim($tgl_return) == '') {
$error[] = '- Tanggal Return barang harus diisi';
}
//dan seterusnya
if (isset($error)) {
echo '<div align="center" style="color:red; font-size:20px;"><b>Error</b>: <br /></div><div style="color:red;">' . implode('<br />', $error) . '</div>';
} else {
/*
jika data mau dimasukkan ke database,
maka perintah SQL INSERT bisa ditulis di sini
*/
$dbinput = "INSERT INTO `tbl_det_return`(`no_form_r`, `part_number`, `description`, `jumlah`, `alasan`,`tgl_return`, `username`, `keterangan`) VALUES ('{$noform}','{$part_number}','{$deskripsi}','{$jumlah}','{$alasan}','{$tgl_return}','{$username}','{$keterangan}')";
$input = custom_query($dbinput);
$tblupdate = "SELECT * FROM tbl_barang WHERE part_number = '{$part_number}'";
$update = custom_query($tblupdate);
while ($r = mysqli_fetch_array($update)) {
$hasil = $r['jumlah'];
}
if ($jumlah > $hasil) {
echo '<div align="center"><b>Error</b>: <br />Jumlah barang yang akan di return tidak sesuai dengan jumlah yang ada pada stocklist</div>';
} else {
$ok = $hasil - $jumlah;
$sqlupdate = "UPDATE tbl_barang SET jumlah = '{$ok}' WHERE part_number = '{$part_number}'";
$jmlupdate = custom_query($sqlupdate);
echo '<div align="center"><b>Data barang return berhasil di tambah. silakan klik <a href="detbrgreturn.php">disini </a>untuk melihat perubahan</b></div><br />';
}
}
die;
<?php
include "atas.php";
?>
<p align="center"><strong>Master Data dasar keterangan barang masuk / keluar</strong></p>
<table align="center" width="801" border="0">
<tr>
<td><div align="center"><strong>No.</strong></div></td>
<td><div align="center"><strong>Nama dasar keterangan barang masuk / keluar</strong></div></td>
<td><div align="center"><strong>Jenis</strong></div></td>
<td colspan="2"><div align="center"><strong>Aksi</strong></div></td>
</tr>
<?php
$sql = custom_query("SELECT * FROM tbl_dasar");
while ($r = mysqli_fetch_array($sql)) {
$no++;
if ($r['jenis'] == 1) {
$jenis = 'Barang masuk';
} else {
if ($r['jenis'] == 2) {
$jenis = 'Barang keluar';
}
}
?>
<tr>
<td><div align="center"><?php
echo $no;
if (trim(mysqli_num_rows($a) > 0)) {
$error[] = '- ID ATM sudah ada, silakan ulangi kembali.';
}
if (trim($bank) == '') {
$error[] = '- Bank harus dipilih';
}
if (trim($lokasi) == '') {
$error[] = '- Lokasi harus diisi';
}
if (trim($sn) == '') {
$error[] = '- Serial Number harus diisi';
}
if (trim(mysqli_num_rows($a1) > 0)) {
$error[] = '- Serial Number sudah ada, silakan ulangi kembali.';
}
if (trim($install_date) == '') {
$error[] = '- Tanggal Instalasi harus diisi';
}
//dan seterusnya
if (isset($error)) {
echo '<div align="center" style="color:red; font-size:20px;"><b>Error</b>: <br /></div><div style="color:red;">' . implode('<br />', $error) . '</div>';
} else {
/*
jika data mau dimasukkan ke database,
maka perintah SQL INSERT bisa ditulis di sini
*/
$query2 = "INSERT INTO tbl_atm (id_atm,bank,lokasi,sn,install_date) VALUES ('{$id_atm}','{$bank}', '{$lokasi}', '{$sn}','{$install_date}')";
$input = custom_query($query2);
echo '<div align="center" style="color:green; font-size:15px;"><b>Data ATM berhasil di tambah. silakan klik <a href="pilihlist.php">disini</a> untuk melihat perubahan:</b></div><br />';
}
die;
}
</style>
</head>
</html>
<body>
<div id="header">
</div>
<div id="main_content">
<?php
include "atas.php";
?>
<p align="center"><strong>Silahkan edit form dibawah ini untuk mengedit dasar</strong></p>
<?php
$id = $_GET['id'];
$sql = custom_query("SELECT * FROM tbl_dasar WHERE id_dasar='{$id}'");
while ($r = mysqli_fetch_array($sql)) {
?>
<form action="prosesdasar.php?task=edit" method="post" id="update">
<div align="center">
<table width="400" border="6">
<input type="hidden" name="iddasar" value="<?php
echo $id;
?>
" />
<tr>
<td width="123"><strong>Nama dasar keterangan barang masuk / keluar :</strong></td>
<td class="field" width="255" bgcolor="#FFFFFF"><label for="username"></label>
<input name="nmdasar" type="text" id="nmdasar" value="<?php
echo $r['nama_dasar'];
echo $r1['nama_karyawan'];
?>
</option>
<?php
}
?>
</select>
<strong> </strong></td>
</tr>
<tr>
<td><strong>Cabang :</strong></td>
<td class="field">
<select name="id_cabang" id="id_cabang">
<option value="">- Pilih -</option>
<?php
$sql1 = custom_query("SELECT * FROM tbl_cabang");
while ($r1 = mysqli_fetch_array($sql1)) {
?>
<option value="<?php
echo $r1['id_cabang'];
?>
" <?php
echo $r['id_cabang'] == $r1['id_cabang'] ? "selected" : "";
?>
><?php
echo $r1['nama_cabang'];
?>
</option><?php
}
?>
$input = custom_query($dbinput);
echo '<div align="center" style="color:green; font-size:15px;"><b>Data User berhasil di tambah. silakan klik <a href="keterangan.php">disini </a>untuk melihat perubahan</b></div><br />';
}
die;
} else {
if ($task == 'edit') {
if (isset($_POST['simpan'])) {
$nmketerangan = $_POST['nmketerangan'];
$idketerangan = $_POST['idketerangan'];
$dquery = "UPDATE tbl_keterangan SET nama_keterangan='{$nmketerangan}' WHERE id_keterangan='{$idketerangan}'";
$sql = custom_query($dquery);
if ($sql) {
echo "<script>alert('Selamat, data keterangan telah terupdate');javascript:window.location='keterangan.php';</script>";
} else {
echo "<script>alert('Maaf, data keterangan gagal terupdate');javascript:window.location='keterangan.php';</script>";
}
}
} else {
if ($task == 'hapus') {
$idketerangan = $_GET['idketerangan'];
$sql = custom_query("DELETE FROM tbl_keterangan WHERE id_keterangan='{$idketerangan}'");
if ($sql) {
echo print "<script>alert('Selamat, data keterangan telah dihapus');javascript:window.location='keterangan.php';</script>";
} else {
echo print "<script>alert('Maaf, data keterangan gagal dihapus');javascript:window.location='keterangan.php';</script>";
}
} else {
echo '<div align="center" style="color:red; font-size:20px;"><b>Error</b>: <br /></div><div style="color:red;">unknown task</div>';
}
}
}
<b>Status Barang Keluar</b>
</h1>
<table align="center" width="1400" border="0" bordercolor="#FFFFFF">
<tr>
<td width="59"><div align="center"><strong>No. Form</strong></div></td>
<td width="109"><div align="center"><strong>Part Number</strong></div></td>
<td width="143"><div align="center"><strong>Description</strong></div></td>
<td width="94"><div align="center"><strong>Problem</strong></div></td>
<td width="77"><div align="center"><strong>Operator</strong></div></td>
<td width="77"><div align="center"><strong>Engineer</strong></div></td>
<td width="47"><div align="center"><strong>Jumlah</strong></div></td>
<td width="130"><div align="center"><strong>Tanggal Keluar</strong></div></td>
<td width="140"><div align="center"><strong>Keterangan</strong></div></td>
</tr>
<?php
$sql = custom_query("SELECT * \nFROM `tbl_det_keluar` \nORDER BY `tbl_det_keluar`.`no_form_k` DESC");
while ($r = mysqli_fetch_array($sql)) {
?>
<tr>
<td><div align="center"><?php
echo $r['no_form_k'];
?>
</div></td>
<td><div align="center"><?php
echo $r['part_number'];
?>
</div></td>
<td><?php
echo $r['description'];
?>
</tr>
<tr>
<td height="34"><strong>Alasan Return</strong></td>
<td class="field"><div align="center"><span class="field">
<input name="alasan" type="text" id="alasan" value="">
</span></div></td>
</tr>
<tr>
<td height="34"><strong>Tgl Return</strong></td>
<td><input type="text" id="tgl_return" name="tgl_return" onClick="if(self.gfPop)gfPop.fPopCalendar(document.form1.tgl_return);return false;"/><a href="javascript:void(0)" onClick="if(self.gfPop)gfPop.fPopCalendar(document.form1.tgl_return);return false;"><img name="popcal" align="absmiddle" style="border:none" src="calender/calender.jpeg" width="34" height="29" border="0" alt=""></a></td>
</tr>
<td height="34"><strong>Operator</strong></td>
<td><span class="field">
<input name="id_user" type="text" id="id_user" value="<?php
$sql = custom_query("SELECT * FROM tbl_user WHERE username = '******'username']}'");
while ($data = mysqli_fetch_array($sql)) {
$username = $data['username'];
}
echo $username;
?>
" readonly>
</span></td>
</tr>
<tr>
<td height="34"><strong>Keterangan</strong></td>
<td class="field">
<input name="keterangan" type="text" id="keterangan" value="">
</td>
</tr>
<tr>
<div id="result" style="display:none;"></div>
<form action="regatm.php" method="post" id="formreg" name="formreg">
<div align="center">
<table width="400" border="6">
<tr>
<td width="123"><strong>ID ATM:</strong></td>
<td class="field" width="255" bgcolor="#FFFFFF"><label for="id_atm"></label>
<input name="id_atm" type="text" id="id_karyawan"></td>
</tr>
<tr>
<td><strong>Bank :</strong></td>
<td><span class="field"><select name="bank" id="bank">
<option value="">- Pilih -</option>
<?php
$sql1 = custom_query("SELECT bank FROM tbl_atm GROUP BY bank ORDER BY bank ASC");
while ($r1 = mysqli_fetch_array($sql1)) {
?>
<option value="<?php
echo $r1['bank'];
?>
"><?php
echo $r1['bank'];
}
?>
</option>
</select></span></td>
</tr>
<tr>
<td><strong>Lokasi :</strong></td>
</script>
<?php
}
}
?>
</tr>
<tr>
<td colspan="4" align="center">
</td>
</tr>
</table><br>
<div align="center"><?php
// mencari jumlah semua data dalam tabel guestbook
$query = "SELECT COUNT(*) AS jumData FROM tbl_barang {$where}";
$hasil = custom_query($query);
$data = mysqli_fetch_array($hasil);
$jumData = $data['jumData'];
// menentukan jumlah halaman yang muncul berdasarkan jumlah semua data
$jumPage = ceil($jumData / $dataPerPage);
// menampilkan link previous
if ($noPage > 1) {
echo "<a href='" . $_SERVER['PHP_SELF'] . "?page=" . ($noPage - 1) . "'><< Prev</a>";
}
// memunculkan nomor halaman dan linknya
for ($page = 1; $page <= $jumPage; $page++) {
if ($page >= $noPage - 3 && $page <= $noPage + 3 || $page == 1 || $page == $jumPage) {
if ($showPage == 1 && $page != 2) {
echo "...";
}
if ($showPage != $jumPage - 1 && $page == $jumPage) {
" readonly>
</span></div></td>
</tr>
<tr>
<td height="34"><strong>Nama Engineer</strong></td>
<td><span class="field">
<select name="nama_karyawan" id="nama_karyawan">
<option value="<?php
echo $r['nama_karyawan'];
?>
"><?php
echo $r['nama_karyawan'];
?>
</option>
<?php
$sql1 = custom_query("SELECT * FROM tbl_karyawan WHERE jabatan = 'Engineer' ORDER BY nama_karyawan");
while ($r1 = mysqli_fetch_array($sql1)) {
?>
<option value="<?php
echo $r1['nama_karyawan'];
?>
"><?php
echo $r1['nama_karyawan'];
}
?>
</option>
</select>
</span></td>
</tr>
<tr>
}
</style>
</head>
</html>
<body>
<div id="header">
</div>
<div id="main_content">
<?php
include "atas.php";
?>
<br>
<?php
$noform = $_GET['no_form_k'];
$query = "SELECT * FROM tbl_det_keluar WHERE no_form_k='{$noform}'";
$sql = custom_query($query);
while ($r = mysqli_fetch_array($sql)) {
?>
<h1 align="center"><strong>Detail Barang Keluar No. Form <?php
echo $r['no_form_k'];
?>
</strong></h1>
<div align="center">
<table width="400" border="6">
<tr>
<td width="120"><strong>Nomor Form :</strong></td>
<td><?php
echo $r['no_form_k'];
?>
</td>
}
</style>
</head>
</html>
<body>
<div id="header">
</div>
<div id="main_content">
<?php
include "atas.php";
?>
<p align="center"><strong>Silahkan edit form dibawah ini untuk mengedit keterangan</strong></p>
<?php
$id = $_GET['id'];
$sql = custom_query("SELECT * FROM tbl_keterangan WHERE id_keterangan='{$id}'");
while ($r = mysqli_fetch_array($sql)) {
?>
<form action="prosesketerangan.php?task=edit" method="post" id="update">
<div align="center">
<table width="400" border="6">
<input type="hidden" name="idketerangan" value="<?php
echo $id;
?>
" />
<tr>
<td width="123"><strong>Nama keterangan :</strong></td>
<td class="field" width="255" bgcolor="#FFFFFF"><label for="username"></label>
<input name="nmketerangan" type="text" id="nmketerangan" value="<?php
echo $r['nama_keterangan'];
