<td><input type="text" name="telepon" value="' . $telepon . '" size="30" class="form-control"></td>
</tr>
<tr>
<td>Handphone</td>
<td><input type="text" name="handphone" value="' . $handphone . '" size="30" class="form-control"></td>
</tr>
<tr>
<td>Pendidikan Terakhir</td>
<td><select name="pendidikan_terakhir" class="form-control">';
$hasil = $koneksi_db->sql_query("SELECT * FROM hrd_pendidikan ORDER BY id");
$admin .= '<option value="-">== Pendidikan Terakhir ==</option>';
while ($datas = $koneksi_db->sql_fetchrow($hasil)) {
$pilihan = $datas['id'] == $pendidikan_terakhir ? "selected" : '';
$admin .= '<option value="' . $datas['id'] . '" ' . $pilihan . '>' . $datas['nama'] . '</option>';
}
$admin .= '</select></td>
</tr>
<tr>
<td>Foto</td>
<td><input type="file" name="foto" size="53"><p class="help-block">Extensi foto harus JPG</p></td>
</tr>';
if (!$fotolama) {
$fotolama = 'profile-default.jpg';
}
$admin .= '<tr>
<td></td>
<td><img src="mod/karyawan/images/normal/' . $fotolama . '" height="120">
<input type="hidden" name="fotolama" value="' . $fotolama . '"></td>
</tr>
<tr>
<td>Departemen</td>
<?php
include 'includes/config.php';
include 'includes/mysql.php';
$idkary = int_filter($_GET['idkary']);
$id = int_filter($_GET['id']);
global $koneksi_db, $translateKal, $url_situs;
$hasil = $koneksi_db->sql_query("SELECT * FROM hrd_karyawan WHERE id='{$idkary}'");
$data = $koneksi_db->sql_fetchrow($hasil);
$nama = $data['nama'];
$jabatan = getjabatan($data['jabatan']);
$departemen = getdepartemen($data['departemen']);
$status = getstatus($data['status']);
$golongan = getgolongan($data['golongan']);
$nip = $data['nip'];
$norek = $data['norek'];
$namarek = $data['namarek'];
$hasil2 = $koneksi_db->sql_query("SELECT * FROM hrd_penggajian WHERE id='{$id}'");
$data2 = $koneksi_db->sql_fetchrow($hasil2);
$bulan = getbulan($data2['bulan']);
$tahun = $data2['tahun'];
$gajipokok = $data2['gajipokok'];
$tstruktural = $data2['tstruktural'];
$tfungsional = $data2['tfungsional'];
$tpengabdian = $data2['tpengabdian'];
$tistrianak = $data2['tistrianak'];
$tuangtransport = $data2['tuangtransport'];
$tbebantugas = $data2['tbebantugas'];
$twalikelas = $data2['twalikelas'];
$tkhusus = $data2['tkhusus'];
$tlain = $data2['tlain'];
<td>Bulan / Tahun</td>
<td><select name="bulan" class="form-control">';
$hasil = $koneksi_db->sql_query("SELECT * FROM hrd_bulan ORDER BY id");
$admin .= '<option value="">== Pilih Bulan ==</option>';
while ($datas = $koneksi_db->sql_fetchrow($hasil)) {
$admin .= '<option value="' . $datas['id'] . '">' . $datas['bulan'] . '</option>';
}
$admin .= '</select> / <input type="text" name="tahun"value="' . $tahun . '" size="25" class="form-control"></td>
</tr>
<tr>
<td>Masuk</td>
<td><input type="text" name="masuk" size="25" class="form-control"> Hari</td>
</tr>
<tr>
<td>Lembur</td>
<td><input type="text" name="lembur" size="25" class="form-control"> Menit</td>
</tr>
<tr>
<td>Sakit</td>
<td><input type="text" name="sakit" size="25" class="form-control"> Hari</td>
</tr>
<tr>
<td>Alpha</td>
<td><input type="text" name="alpha" size="25" class="form-control"> Hari</td>
</tr>
<tr>
<td>Terlambat</td>
<td><input type="text" name="telat" size="25" class="form-control"> Menit</td>
</tr>
<tr>
<td></td>
<td>NIP</td>
<td><input type="hidden" name="nip" value="' . $nip . '">' . $nip . '</td>
</tr>
<tr>
<td>Nama Lengkap</td>
<td>
<input type="hidden" name="nama" value="' . $nama . '">' . $nama . '
</td>
</tr>
<tr>
<td>Departemen</td>
<td><input type="hidden" name="departemen" value="' . $departemen . '">' . getdepartemen($departemen) . '</td>
</tr>
<tr>
<td>Jabatan</td>
<td><input type="hidden" name="jabatan" value="' . $jabatan . '">' . getjabatan($jabatan) . '</td>
</tr>
<tr>
<td>Status</td>
<td><input type="hidden" name="status" value="' . $status . '">' . getstatus($status) . '</td>
</tr>
</table></form>';
}
if ($_GET['aksi'] == 'hapus_photo') {
$idkary = int_filter($_GET['idkary']);
$id = int_filter($_GET['id']);
$hapus = mysql_query("DELETE FROM `hrd_pinjaman` WHERE `id`='{$id}'");
if ($hapus) {
$admin .= '<div class="sukses">Berhasil Dihapus</div>';
$style_include[] = '<meta http-equiv="refresh" content="3; url=admin.php?pilih=pinjaman&mod=yes&aksi=add_pinjaman&id=' . $idkary . '" />';
} else {
$norek = $data['norek'];
$namarek = $data['namarek'];
$npwp = $data['npwp'];
$golongan = $data['golongan'];
$jabatan = $data['jabatan'];
$status = $data['status'];
$cetak = '<a href="cetak_slip.php?id=' . $idphoto . '&idkary=' . $idkary . '" target="new"onclick="return confirm(\'Apakah Anda Ingin Mencetak Penggajian Ini ?\')" style="color:blue">Cetak Slip</a>';
echo '
<tr align="left">
<td>' . $no . '</td>
<td>' . $norek . '</td>
<td>' . $namarek . '</td>
<td>' . $tkt . '</td>
<td>' . $nama . '</td>
<td>' . $npwp . '</td>
<td>' . getjabatan($jabatan) . '</td>
<td>' . getgolongan($golongan) . '</td>
<td>' . getstatus($status) . '</td>
<td>' . rupiah_format2($gajipokok) . '</td>
<td>' . rupiah_format2($tstruktural) . '</td>
<td>' . rupiah_format2($tfungsional) . '</td>
<td>' . rupiah_format2($tpengabdian) . '</td>
<td>' . rupiah_format2($tistrianak) . '</td>
<td>' . rupiah_format2($tuangtransport) . '</td>
<td>' . rupiah_format2($tbebantugas) . '</td>
<td>' . rupiah_format2($twalikelas) . '</td>
<td>' . rupiah_format2($tkhusus) . '</td>
<td>' . rupiah_format2($gajibruto) . '</td>
<td>' . rupiah_format2($tlain) . '</td>
<td>' . rupiah_format2($totalgaji) . '</td>
<td>' . rupiah_format2($ppinjaman) . '</td>
<th>Nama</th>
<th>Agama</th>
<th>Pendidikan</th>
<th>Jabatan</th>
<th>Status</th>
<th>Lama Kerja</th>
</tr></thead><tbody>';
$no = 1;
$s = mysql_query("SELECT * FROM hrd_karyawan where tipe='1' ORDER BY nama");
while ($data = mysql_fetch_array($s)) {
$date2 = $data['tglditerima'];
$date3 = date("Y-m-d");
$lamakerja = floor(daysBetween($date2, $date3));
$lamakerja2 = floor($lamakerja / 365);
//$lamakerja2 = dateDifference($date2, $date3,'%y Tahun,%m Bulan');
$urutan = $no + 1;
echo '
<tr align="left">
<td class="text-center">' . $no . '</td>
<td>' . $data['nip'] . '</td>
<td>' . $data['nama'] . '</td>
<td>' . getagama($data['agama']) . '</td>
<td>' . getpendidikan($data['pendidikan_terakhir']) . '</td>
<td>' . getjabatan($data['jabatan']) . '</td>
<td>' . getstatus($data['status']) . '</td>
<td>' . $lamakerja2 . ' Tahun</td>
</tr>';
$no++;
}
echo "</body</html>";
echo "<script language=javascript>\nwindow.print();\n</script>";
}
$admin .= '</tbody></table>';
}
###################################
# Tambah Berkas
###################################
if ($_GET['aksi'] == "add_berkas") {
$id = int_filter($_GET['id']);
$s = $koneksi_db->sql_query("SELECT * FROM hrd_karyawan WHERE id={$id}");
$datas = $koneksi_db->sql_fetchrow($s);
$nama = $datas['nama'];
$admin .= '<legend>Tambah Berkas karyawan dengan nama <strong>' . $nama . '</strong></legend>';
if (isset($_POST['submit'])) {
define("GIS_GIF", 1);
define("GIS_JPG", 2);
define("GIS_PNG", 3);
define("GIS_SWF", 4);
include "includes/hft_image.php";
$nip = $_POST['nip'];
$gambartambahan = $_FILES['gambartambahan']['name'];
$total = $koneksi_db->sql_query("SELECT * FROM hrd_karyawan WHERE nip = '" . $_POST['nip'] . "' and id != '" . $id . "'");
$jumlah = $koneksi_db->sql_numrows($total);
$error = '';
if ($jumlah) {
$error .= "Error: NIP karyawan {$nip} sudah ada di dalam database!<br />";
}
if (!$nip) {
$error .= "Error: NIP wajib diisi!<br />";
}
if ($error) {
$admin .= '<div class="alert alert-danger">' . $error . '</div>';
$large = $normal2 . $simpan;
create_thumbnail($uploaddir, $large, $new_width = 600, $new_height = auto, $quality = 100);
unlink($uploaddir);
$nfotolama = $normal2 . $lampiranlama;
unlink($nfotolama);
$hasil = $koneksi_db->sql_query("update hrd_karyawan set tipe='{$tipe}',tglresign='{$tglresign}',alasan='{$alasan}',lampiran='{$simpan}' where id='{$id}'");
} else {
$hasil = $koneksi_db->sql_query("update hrd_karyawan set tipe='{$tipe}',tglresign='{$tglresign}',alasan='{$alasan}' where id='{$id}'");
}
}
}
$hasil = $koneksi_db->sql_query("SELECT * FROM hrd_karyawan WHERE id={$id}");
$data = $koneksi_db->sql_fetchrow($hasil);
$idkary = $data['id'];
$nip = $data['nip'];
$nama = text_filter($data['nama']);
$departemen = $data['departemen'];
$jabatan = $data['jabatan'];
$status = $data['status'];
$fotolama = $data['foto'];
$tipe = $data['tipe'];
$tglresign = $data['tglresign'];
$alasan = $data['alasan'];
$lampiran = $data['lampiran'];
$lampiranlama = $data['lampiran'];
$admin .= '<form class="form-inline" method="post" action="" enctype ="multipart/form-data" id="posts">
<table class="table table-striped table-hover">
<tr>
<td>Foto</td>
<td></td>
</tr>';
$namafile_name = $_FILES['foto']['name'];
$fotolama = $_POST['fotolama'];
$nip = $_POST['nip'];
$nama = text_filter($_POST['nama']);
$kotalahir = $_POST['kotalahir'];
$tgllahir = $_POST['tgllahir'];
$kelamin = $_POST['kelamin'];
$agama = $_POST['agama'];
$menikah = $_POST['menikah'];
$alamat = $_POST['alamat'];
$kota = $_POST['kota'];
$kodepos = $_POST['kodepos'];
$propinsi = $_POST['propinsi'];
$negara = $_POST['negara'];
$telepon = $_POST['telepon'];
$handphone = $_POST['handphone'];
$departemen = $_POST['departemen'];
$jabatan = $_POST['jabatan'];
$status = $_POST['status'];
$pendidikan_terakhir = $_POST['pendidikan_terakhir'];
$tglditerima = $_POST['tglditerima'];
$tglpercobaan = $_POST['tglpercobaan'];
$tglkontrak = $_POST['tglkontrak'];
$jatahcuti = $_POST['jatahcuti'];
$total = $koneksi_db->sql_query("SELECT * FROM hrd_karyawan WHERE nip = '" . $_POST['nip'] . "' and id != '" . $id . "'");
$jumlah = $koneksi_db->sql_numrows($total);
$error = '';
if ($jumlah) {
$error .= "Error: NIP karyawan {$nip} sudah ada di dalam database!<br />";
}
if (!$nip) {