<?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'];
$tuangtransport = $datas['tuangtransport']; $urutan = $no + 1; $hasil = $koneksi_db->sql_query("SELECT * FROM hrd_karyawan where id='{$idkary}'"); $data = $koneksi_db->sql_fetchrow($hasil); $nip = $data['nip']; $nama = $data['nama']; $golongan = $data['golongan']; $tkt = $data['tkt']; $norek = $data['norek']; $cetak = '<a href="cetak_slip.php?id=' . $idphoto . '&idkary=' . $idkary . '" target="new"onclick="return confirm(\'Apakah Anda Ingin Mencetak Penggajian Ini ?\')" style="color:blue"><span class="btn btn-warning">Slip</span></a>'; $admin .= ' <tr align="left"> <td class="text-center">' . $nip . '</td> <td>' . $norek . '</td> <td>' . $nama . '</td> <td>' . getgolongan($golongan) . '</td> <td>' . $gajipokok . '</td> <td>' . $tstruktural . '</td> <td>' . $tfungsional . '</td> <td>' . $tpengabdian . '</td> <td>' . $tistrianak . '</td> <td>' . $tuangtransport . '</td> <td>' . $tbebantugas . '</td> <td>' . $twalikelas . '</td> <td>' . $tkhusus . '</td> <td>' . $tlain . '</td> <td>' . $ppinjaman . '</td> <td>' . $jamsostek . '</td> <td>' . $pph21 . '</td> <td>' . rupiah_format($gajibersih) . '</td> <td>' . $cetak . '</td></tr>';
<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>
$bulan = $_POST['bulan']; $tahun = $_POST['tahun']; $tkt = $_POST['tkt']; $gajipokok = $_POST['gajipokok']; $tstruktural = $_POST['tstruktural']; $tfungsional = $_POST['tfungsional']; $tpengabdian = $_POST['tpengabdian']; $tistrianak = $_POST['tistrianak']; $tuangtransport = $_POST['tuangtransport']; $tbebantugas = $_POST['tbebantugas']; $twalikelas = $_POST['twalikelas']; $tkhusus = $_POST['tkhusus']; $tlain = $_POST['tlain']; $ppinjaman = $_POST['ppinjaman']; $jamsostek = $_POST['jamsostek']; $pph21 = $_POST['pph21']; $potlain2 = $_POST['potlain2']; $pid = $_POST['pid']; $tglnow = date("Y-m-d"); //////////////////////////////////////////////////////// $gajibruto = $gajipokok + $tstruktural + $tfungsional + $tpengabdian + $tistrianak + $tuangtransport + $tbebantugas + $twalikelas + $tkhusus; $totalgaji = $gajibruto + $tlain; $gajibersih = $totalgaji - ($ppinjaman + $jamsostek + $pph21 + $potlain2); /*******************************************************/ $error = ''; if ($error) { $admin .= '<div class="alert alert-danger">' . $error . '</div>'; } else { if ($ppinjaman > '0') { $hasil = $koneksi_db->sql_query("update hrd_bayar set bayar={$ppinjaman} where id='{$idbayar}'"); }