CARA MENGHITUNG UPAH GAJI KARYWAN BERDASARKAN JAM MENGGUNAKAN PHP
Deskripsi :
Menginput data karyawan :
- Nama
- Jam Kerja Keseluruhan
- gaji pokok
Menghitung Upah Gaji karyawan
Tampilan Form Input Data Gaji Karywan
Tampilan Data gaji Karyawan
Langkah :
1. Buat database dengan nama "Gaji Lembur" Table di database
Code :
CREATE TABLE `tbl_karyawan` (
`id_karyawan` int(11) NOT NULL,
`nama` char(50) NOT NULL,
`jam_kerja_keseluruhan` int(20) NOT NULL,
`gaji_pokok` int(40) NOT NULL,
PRIMARY KEY(`id_karyawan`));
Source Code :
<!doctype html>
<html lang="en">
<head>
<!-- Required meta tags -->
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<!-- Bootstrap CSS -->
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/css/bootstrap.min.css" integrity="sha384-Vkoo8x4CGsO3+Hhxv8T/Q5PaXtkKtu6ug5TOeNV6gBiFeWPGFN9MuhOf23Q9Ifjh" crossorigin="anonymous">
<title>Upah Lembur</title>
<style>
.popup{
width: 100%;
height: 100%;
position: fixed;
background: rgba(0,0,0,.7);
top: 0;
left: 0;
z-index: 99999999;
visibility: visible;
}
.content-pesan{
width: 30%;
margin: 10% auto;
margin-left: 32%;
position: fixed;
z-index: 99999999;
}
</style>
</head>
<body>
<div class="container mt-2">
<!-- Button trigger modal -->
<button type="button" class="btn btn-primary" data-toggle="modal" data-target="#exampleModal">
Input Data Karyawan
</button>
<!-- Modal -->
<div class="modal fade" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="exampleModalLabel">Input Data Karyawan</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<form action="" method="post">
<div class="modal-body">
<div class="form-group">
<label for="">Nama Karyawan</label>
<input type="text" name="nama" placeholder="Nama Karyawan...." class="form-control" required>
</div>
<div class="form-group">
<label for="">Jam Kerja Keseluruhan</label>
<input type="number" name="jam_kerja_keseluruhan" placeholder="Jam Kerja Keseluruhan..." class="form-control" required>
</div>
<div class="form-group">
<label for="">Gaji Pokok</label>
<input type="number" name="gaji_pokok" placeholder="Gaji Pokok..." class="form-control" required>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
<button type="submit" name="input_gaji" class="btn btn-primary">Save changes</button>
</div>
</form>
</div>
</div>
</div>
<!-- end modal -->
<h1>Menghitung upah Lembur Karyawan Menggunakan PHP</h1>
<table class="table table-striped table-bordered">
<tr>
<td>No</td>
<td>Nama Karyawan</td>
<td>Jam Kerja Keseluruhan</td>
<td>Rata2 Jam Kerja Sebulan</td>
<td>Jam Lembur (Perbulan)</td>
<td>Upah Lembur</td>
<td>Gaji Pokok</td>
<td>Gaji Pokok + Lembur</td>
</tr>
<?php
//buat koneksi
$conn = mysqli_connect('localhost','root','','gaji_lembur');
if(isset($_POST['input_gaji'])){
$nama = $_POST['nama'];
$jam_kerja_keseluruhan = $_POST['jam_kerja_keseluruhan'];
$gaji_pokok = $_POST['gaji_pokok'];
//input kedatabase
$input = mysqli_query($conn,"INSERT INTO `tbl_karyawan` (nama,jam_kerja_keseluruhan,gaji_pokok)
VALUES('$nama','$jam_kerja_keseluruhan','$gaji_pokok')");
if($input){
$pesan = "Berhasil Input data Karyawan";
}else{
$pesan = "gagal";
}
echo"<div class='popup'>
<div class='content-pesan' style='background-color: #FFF;'>
<div class='modal-header' style='background-color: #FFF;'><h4>Informasi</h4></div>
<div class='modal-body'>
<h7 class='animate__animated animate__zoomInDown'><span class='iconify' data-icon='clarity:success-standard-solid' data-inline='false' style='color: green;''></span> $pesan</h7>
<nav aria-label='Page navigation example'>
<ul class='pagination'>
<li class='page-item'><a class='page-link text-danger' href='index.php'><i class='fa fa-left'></i> Oke</a></li>
</ul>
</nav>
</div>
</div>
</div>";
}
$data = mysqli_query($conn,"SELECT * FROM tbl_karyawan ");
$no=1;
while($row = mysqli_fetch_array($data)){
$gaji_pokok = $row['gaji_pokok'];
$rupiah_gaji_pokok = number_format($gaji_pokok, 0, '', '.');
$jam_kerja_keseluruhan = $row['jam_kerja_keseluruhan'];
//hitung jumlah jam perhari, hari perminggu, dan jumlah minggu perbulan
$jam_kerja_perhari =('8');
$hari_perminggu =('6');
$jumlah_minggu_perbulan = ('4.3');
$upah_lembur_perjam =('15000');
//kali jam kerja perhari x hari perminggu x jumlah minggu perbulan
$jam_kerja_perbulan = $jam_kerja_perhari*$hari_perminggu*$jumlah_minggu_perbulan;
//bulat kan nilai pecahan dengan round();
$min_jam_kerja_perbulan = round($jam_kerja_perbulan);
//total jam kerja - Min Jam Kerja Sebulan
$jam_lembur = $jam_kerja_keseluruhan-$min_jam_kerja_perbulan;
//jam lembur x upah lembur perjam
$upah_lembur = $jam_lembur*$upah_lembur_perjam;
$rupiah_lembur = number_format($upah_lembur, 0, '', '.');
//upah Lembur + Gaji Pokok
$total = $upah_lembur+$gaji_pokok;
$rupiah_total = number_format($total, 0, '', '.');
echo"<tr>
<td>$no</td>
<td>$row[nama]</td>
<td>$row[jam_kerja_keseluruhan]</td>
<td>$jam_lembur</td>
<td>$min_jam_kerja_perbulan</td>
<td>$rupiah_lembur</td>
<td>$rupiah_gaji_pokok</td>
<td>$rupiah_total</td>
</tr>";
$no++;
}
?>
</table>
</div>
<!-- Optional JavaScript -->
<!-- jQuery first, then Popper.js, then Bootstrap JS -->
<script src="https://code.jquery.com/jquery-3.4.1.slim.min.js" integrity="sha384-J6qa4849blE2+poT4WnyKhv5vZF5SrPo0iEjwBvKU7imGFAV0wwj1yYfoRSJoZ+n" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.0/dist/umd/popper.min.js" integrity="sha384-Q6E9RHvbIyZFJoft+2mJbHaEWldlvI9IOYy5n3zV9zzTtmI3UksdQRVvoxMfooAo" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/js/bootstrap.min.js" integrity="sha384-wfSDF2E50Y2D1uUdj0O3uMBJnjuUD4Ih7YwaYd1iqfktj0Uod8GCExl3Og8ifwB6" crossorigin="anonymous"></script>
</body>
</html>
0 Komentar