Data Gaji
| No | ID Pengguna | Nama | Jabatan | Tanggal | Gapok | Penambahan | Pengurangan | Netto | Aksi |
|---|---|---|---|---|---|---|---|---|---|
| '.$no.' | '.$row['employees_code'].' | '.$row['employees_name'].' | '.$row['position_name'].' | '.$row['tgl'].' | '.number_format($row['gpokok']).' | '.number_format($row['penambahan']).' | '.number_format($row['pengurangan']).' | '.number_format($row['netto']).' |
Detail Gaji
Rincian Gaji
';
if(!empty($_GET['id'])){
$id = mysqli_real_escape_string($connection,epm_decode($_GET['id']));
$query ="SELECT a.*,b.`employees_name`,c.`position_name`,b.employees_code,(a.gpokok+a.kerajinan+a.insentif+a.laind) as dapat,(a.pinjaman+a.bpjs+a.potongan+a.laink) as keluar FROM slipgaji a
LEFT JOIN employees b ON a.`nip`=b.`id`
LEFT JOIN enae6276_dbabsen.`position` c ON c.`position_id`=b.`position_id`
LEFT JOIN building d ON d.`building_id`=b.`building_id`
where a.id='$id'";
$result = $connection->query($query);
if($result->num_rows > 0){
$row = $result->fetch_assoc();
echo'
';
}
else{
echo'
Nama : '.$row['employees_name'].'
Devisi : '.$row['position_name'].'
Tanggal : '.$row['tgl'].'
Gaji Pokok : '.number_format($row['gpokok']).'
Insentif : '.number_format($row['insentif']).'
Kerajinan : '.number_format($row['kerajinan']).'
Lain Lain : '.number_format($row['laind']).'
Total Pendapatan : '.number_format($row['dapat']).'
Pinjaman : '.number_format($row['pinjaman']).'
Bpjs : '.number_format($row['bpjs']).'
Potongan : '.number_format($row['ppotongan']).'
Lain Lain : '.number_format($row['laink']).'
Total Potongan : '.number_format($row['keluar']).'
Total Terima Gaji : '.number_format($row['netto']).'
Data tidak ditemukan
';
}}
echo'