if ($datetime->format('D') == "Sun") {
$gajilembur = $pdata->NOMINAL_LEMBUR * $lemburdata * 2;
}
if ($datetime->format('D') != "Sun") {
$gajilembur = $pdata->NOMINAL_LEMBUR * $lemburdata;
}
}
}
}
$totalgaji = $gajiperhari + $totalgaji;
$totallembur = $gajilembur + $totallembur;
}
$lembur = gajilembur($NIP, $takehomepayfix, $getnamapegawaidata->GAJI_POKOK, $totaljamlembur);
$terlambat = potogan_terlambat($NIP, $BULAN, $TAHUN);
$total_potongan = number_format($kasbon + $getnamapegawaidata->TABUNGAN + $nominalpinjaman + $terlambat);
$total_penerimaan = number_format(getthp($NIP) + $uang_makan_transport + $getnamapegawaidata->PENGHARGAAN + $lembur);
$pengambilantab = mysql_fetch_object(mysql_query("SELECT sum(NOMINAL_PENGAMBILAN) as totalpengambilanpeg FROM pengambilan_tabungan where NIP_PEGAWAI='{$getnamapegawaidata->KODE_PEGAWAI}'"));
$tabungan = mysql_fetch_object(mysql_query("SELECT sum(NOMINAL) as totaltabungan FROM tabungan where NIP='{$getnamapegawaidata->KODE_PEGAWAI}'"));
$pengambilan = mysql_fetch_object(mysql_query("SELECT sum(NOMINAL_PENGAMBILAN) as totalpengambilan FROM pengambilan_tabungan where NIP_PEGAWAI='{$getnamapegawaidata->KODE_PEGAWAI}'"));
$subtotaltabungan = $tabungan->totaltabungan - $pengambilan->totalpengambilan;
if ($subtotaltabungan <= 0) {
$tb = 0;
}
if ($subtotaltabungan > 0) {
$tb = $subtotaltabungan;
}
$tnabung = mysql_fetch_object(mysql_query("SELECT TANGGAL as tanggalnabung FROM tabungan where NIP='{$getnamapegawaidata->KODE_PEGAWAI}' order by TANGGAL asc limit 1"));
}
?>
<div class="panel price panel-blue">
$mangkir = $hitungjumlahharikerja - $jumlahmasuk - $hasiljumlahcuti;
if ($mangkir < 0) {
$hasil = 0;
}
if ($mangkir > 0) {
$hasil = $mangkir;
} else {
$hasil = 0;
}
$terlambat = potogan_terlambat($NIP);
$go = str_replace(array(','), array(''), $takehomepay);
$pot_mangkir = $go / $hitungjumlahharikerja * $hasil;
$takehomepayfix = getthp($NIP) + $uang_makan_transport + $totalpenghargaan - ($hutang->hutangnya + $nominalpinjaman + $datapegawai->TABUNGAN + $pot_mangkir + $terlambat);
$total_potongan = number_format(potogan_terlambat($NIP) + $hutang->hutangnya + $datapegawai->TABUNGAN + $nominalpinjaman + $pot_mangkir);
}
$total_penerimaan = number_format(getthp($NIP) + $uang_makan_transport + $totalpenghargaan);
$no++;
echo '
<tr>
<td width="10%">' . $no . '</td>
';
$penggajiannama = mysql_query("SELECT * FROM departemen where KODE_DEPARTEMEN='{$datapegawai->KODE_DEPARTEMEN}'") or die(mysql_error());
$getnamapenggajian = mysql_fetch_object($penggajiannama);
echo '
<td>' . $getnamapenggajian->NAMA_DEPARTEMEN . '</td>
';
echo '
<td width="30%">' . $datapegawai->NO_REKENING . '</td>
<td>' . $datapegawai->NAMA_PEGAWAI . '</td>
<td>Rp.' . number_format($takehomepayfix) . '</td>
</tr>
<p>Tunjangan lainnya:Rp.<?php
echo number_format(getthp($NIP));
?>
</p>
<p>UMT:Rp.<?php
echo number_format($pdata->NOMINAL_UMT * $jumlahmasuk);
?>
</p>
<p>Lembur:Rp.<?php
echo $totallembur;
?>
</p>
<?php
$total_potongan = number_format($kasbon + $nominaltabungan + $nominalpinjaman + $tambah_pemotongan + $toko);
$total_penerimaan = getthp($NIP) + $nominal_kehadiran_full + $totalgaji + $totallembur + $uang_makan_transport + $totalpenghargaan + $tambah_penambahan;
$takehomepayfix = getthp($NIP) + $hasiljumlahcuti * $pdata->GAJI_POKOK + $nominal_kehadiran_full + $totalgaji + $totallembur + $uang_makan_transport + $totalpenghargaan + $tambah_penambahan - ($hutang->hutangnya + $nominalpinjaman + $nominaltabungan + $tambah_pemotongan + $toko);
?>
<p>Bonus kehadiran full:Rp.<?php
echo number_format($nominal_kehadiran_full);
?>
</p>
<p>Potongan Kasbon:Rp.<?php
echo number_format($kasbon);
?>
</p>
<p>Potongan Pinjaman:Rp.<?php
echo number_format($nominalpinjaman);
?>
</p>
<p>Potongan Tabungan:Rp.<?php
echo number_format($nominaltabungan);
<p>Lembur:Rp.<?php
echo number_format($lembur);
?>
</p>
<p>Penghargaan:Rp.<?php
echo number_format($nominal_kehadiran_full);
?>
</p>
<?php
$qmenit23 = mysql_query("select VALUE from pengaturan_penggajian where ID='2'");
$tmenit23 = mysql_fetch_object($qmenit23);
$tmenit22 = explode(",", $tmenit->VALUE);
$terlambat = $jmlterlambat * $tmenit22[1];
$total_potongan = number_format($kasbon + $nominaltabungan + $nominalpinjaman + $terlambat + $tambah_pemotongan + $toko);
$total_penerimaan = number_format(getthp($NIP) + $uang_makan_transport + $nominal_kehadiran_full + $lembur + $tambah_penambahan);
$takehomepayfix2 = getthp($NIP) + $uang_makan_transport + $nominal_kehadiran_full + $lembur + $tambah_penambahan - ($kasbon + $nominaltabungan + $nominalpinjaman + $terlambat + $tambah_pemotongan + $toko);
?>
<p>Potongan terlambat:Rp.<?php
echo number_format($terlambat);
?>
</p>
<p>Potongan Kasbon:Rp.<?php
echo number_format($kasbon);
?>
</p>
<p>Potongan Pinjaman:Rp.<?php
echo number_format($nominalpinjaman);
?>
</p>
<p>Potongan Tabungan:Rp.<?php
echo number_format($nominaltabungan);
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td>
<?php
echo $totaljam . ' Jam';
?>
</td>
<td>
<?php
echo $totaljamlembur . ' Jam';
$lembur = 1 / 173 * (getthp($NIP) + $uang_makan_transport) * $totaljamlembur;
$pot_mangkir = (getthp($NIP) + $uang_makan_transport) / 26 * $hasil;
?>
</td>
</tr>
</table>
<br/>
</div>
<?php
}
?>
</div>
</div>
if ($nominal_pemotongan != "") {
$nominal_pemotongan_tambah = $nominal_pemotongan;
}
if ($nominal_penambahan != "") {
$nominal_penambahan_tambah = $nominal_penambahan;
}
$lembur = 1 / 173 * (getthp($NIP) + $uang_makan_transport) * $totaljamlembur;
$pot_mangkir = (getthp($NIP) + $uang_makan_transport) / 26 * $hasil;
$datalembur = number_format($lembur);
$qmenit23 = mysql_query("select VALUE from pengaturan_penggajian where ID='2'");
$tmenit23 = mysql_fetch_object($qmenit23);
$tmenit22 = explode(",", $tmenit->VALUE);
$terlambat = $jmlterlambat * $tmenit22[1];
$total_potongan = number_format($hutang->hutangnya + $nominaltabungan + $nominalpinjaman + $terlambat + $nominal_pemotongan_tambah + $toko);
$total_penerimaan = number_format(getthp($NIP) + $uang_makan_transport + $nominal_kehadiran_full + $lembur + $nominal_penambahan_tambah);
$thp = getthp($NIP) + $uang_makan_transport + $nominal_kehadiran_full + $lembur + $nominal_penambahan_tambah - ($kasbon + $nominaltabungan + $nominalpinjaman + $terlambat + $nominal_pemotongan_tambah + $toko) - $pot_mangkir;
if ($tipe == "SIMPAN") {
if ($data_input == "good") {
$query = "SELECT max(kode_penggajian) as idMaks FROM head_penggajian";
$hasil32 = mysql_query($query);
$data = mysql_fetch_array($hasil32);
$nim = $data['idMaks'];
$noUrut = (int) substr($nim, 9, 5);
$noUrut++;
$inisial = date('d/m/') . 'GH-';
$w = $inisial;
$IDbaru = $char . sprintf("%05s", $noUrut);
$getkode = $w . $IDbaru;
mysql_query("insert into head_penggajian values('{$getkode}','{$kp}','{$gaji_pokok}','{$uang_makan_transport}','{$datalembur}','{$terlambat}','{$tabungan}','{$hasil}','{$total_potongan}','{$total_penerimaan}','{$tanggal_gaji}','{$KODE_DEPARTEMEN}','{$thp}','{$kasbon}','{$nominalpinjaman}','{$pot_mangkir}','{$jumlahmasuk}','0','{$hasiljumlahcuti}','{$nominal_kehadiran_full}','Bulanan','{$BULAN}','{$TAHUN}','{$startp}','{$endp}','{$nominal_pemotongan_tambah}','{$nominal_penambahan_tambah}','{$totaljamlembur}','{$jmlterlambat}','0','{$toko}')");
$bulansekarang = $BULAN;
$tahunsekarang = $TAHUN;
$tmenit21 = mysql_fetch_object($qmenit2);
$tmenit22 = explode(",", $tmenit21->VALUE);
$ckmenit12 = date('H:i', strtotime($getabsensidataharian1->JAM_MASUK));
$ckmenit23 = date('H', strtotime($tampiljam2->JAM_DATANG));
$ckmenit33 = $ckmenit23 . ":" . $tmenit22[0];
if ($ckmenit12 > $ckmenit33) {
$nominal_kehadiran_full = 0;
$hariterlambat += 1;
}
}
$terlambat = potogan_terlambat($NIP);
$go = str_replace(array(','), array(''), $takehomepay);
$pot_mangkir = $go / $hitungjumlahharikerja * $hasil;
$takehomepayfix = getthp($NIP) + $hasiljumlahcuti * $pgrade_bekasi->NOMINAL_GRADE + $nominal_kehadiran_full + $totalgaji + $totallembur + $uang_makan_transport + $totalpenghargaan + $nominal_penambahan_tambah - ($hutang->hutangnya + $nominalpinjaman + $nominaltabungan + $nominal_pemotongan_tambah + $toko);
$total_potongan = number_format($hutang->hutangnya + $nominaltabungan + $nominalpinjaman + $nominal_pemotongan_tambah + $toko);
$total_penerimaan = number_format(getthp($NIP) + $nominal_kehadiran_full + $totalgaji + $totallembur + $uang_makan_transport + $totalpenghargaan + $nominal_penambahan_tambah);
if ($tipe == "SIMPAN") {
if ($data_input == "good") {
$query = "SELECT max(kode_penggajian) as idMaks FROM head_penggajian";
$hasil32 = mysql_query($query);
$data = mysql_fetch_array($hasil32);
$nim = $data['idMaks'];
$noUrut = (int) substr($nim, 9, 5);
$noUrut++;
$inisial = date('d/m/') . 'GH-';
$w = $inisial;
$IDbaru = $char . sprintf("%05s", $noUrut);
$getkode = $w . $IDbaru;
mysql_query("insert into head_penggajian values('{$getkode}','{$kp}','{$totalgaji}','{$uang_makan_transport}','{$totallembur}','{$hariterlambat}','{$tabungan}','{$hasil}','{$total_potongan}','{$total_penerimaan}','{$tanggal_gaji}','{$KODE_DEPARTEMEN}','{$takehomepayfix}','{$kasbon}','{$nominalpinjaman}','0','{$jumlahmasuk}','{$totalpenghargaan}','{$hasiljumlahcuti}','{$nominal_kehadiran_full}','Harian Bekasi','{$BULAN}','{$TAHUN}','{$startp}','{$endp}','{$nominal_pemotongan_tambah}','{$nominal_penambahan_tambah}','','','{$nominallembur}','{$toko}')");
$bulansekarang = $BULAN;
$tahunsekarang = $TAHUN;
</div> </div> <ul class="list-group list-group-flush"> <li class="list-group-item"><ul><li>Terlambat Bulan Ini : <span style="color:blue;"><?php echo gettelat($NIP); ?> Jam dari <?php echo getjumlahtelat($NIP); ?> Hari</span></li></ul></li> <li class="list-group-item"><ul><li>Lembur Bulan Ini : <span style="color:blue;"><?php echo jmlembur($NIP); ?> Jam</span></li></ul></li> <li class="list-group-item"><ul><li>Pendapatan Bulan Ini : <span style="color:blue;">Rp.<?php echo number_format(getthp($NIP)); ?> ,-</span></li></ul></li> </ul> </div> </div> <div class="col-md-6"> <div class="well"> <div id="container2" style="height:300px;"></div> </div> </div>
<td width="25%">TOTAL POTONGAN</td>
<td width="25%">Rp.<?php echo number_format(potogan_terlambat($NIP)+$hutang->hutangnya+$jabatan->NOMINAL_TABUNGAN);?></td>
</tr>
</table>
</th>
</tr>
<tr>
<th colspan="2">
<table width="100%">
<tr>
<td width="15%">TAKE HOME PAY</td>
<td width="1%">:</td>
<td width="37%">Rp.<?php echo number_format(getthp($NIP) - (potogan_terlambat($NIP)+$hutang->hutangnya+$jabatan->NOMINAL_TABUNGAN));?>,-</td>
</tr>
</table>
</th>
<th colspan="2">
</th>
</tr>
</tfoot>
</table>
<?php
} else{
echo 'false';
}
$gajilembur = $pdata->NOMINAL_LEMBUR * $lemburdata * 2;
}
if ($datetime->format('D') != "Sun") {
$gajilembur = $pdata->NOMINAL_LEMBUR * $lemburdata;
}
}
}
}
$totalgaji = $gajiperhari + $totalgaji;
$totallembur = $gajilembur + $totallembur;
$subtotal = $gajiperhari + $gajilembur;
$subtotalgaji = $subtotal + $subtotalgaji;
}
$total_potongan = number_format($kasbon + $pdata->TABUNGAN + $nominalpinjaman);
$total_penerimaan = getthp($NIP) + $nominal_kehadiran_full + $totalgaji + $totallembur + $uang_makan_transport + $totalpenghargaan;
$takehomepayfix = getthp($NIP) + $nominal_kehadiran_full + $totalgaji + $totallembur + $uang_makan_transport + $totalpenghargaan - ($hutang->hutangnya + $nominalpinjaman + $datapegawai->TABUNGAN);
$pengambilantab = mysql_fetch_object(mysql_query("SELECT sum(NOMINAL_PENGAMBILAN) as totalpengambilanpeg FROM pengambilan_tabungan where NIP_PEGAWAI='{$getnamapegawaidata->KODE_PEGAWAI}'"));
$tabungan = mysql_fetch_object(mysql_query("SELECT sum(NOMINAL) as totaltabungan FROM tabungan where NIP='{$getnamapegawaidata->KODE_PEGAWAI}'"));
$pengambilan = mysql_fetch_object(mysql_query("SELECT sum(NOMINAL_PENGAMBILAN) as totalpengambilan FROM pengambilan_tabungan where NIP_PEGAWAI='{$getnamapegawaidata->KODE_PEGAWAI}'"));
$subtotaltabungan = $tabungan->totaltabungan - $pengambilan->totalpengambilan;
if ($subtotaltabungan <= 0) {
$tb = 0;
}
if ($subtotaltabungan > 0) {
$tb = $subtotaltabungan;
}
$tnabung = mysql_fetch_object(mysql_query("SELECT TANGGAL as tanggalnabung FROM tabungan where NIP='{$getnamapegawaidata->KODE_PEGAWAI}' order by TANGGAL asc limit 1"));
}
?>
<div class="panel price panel-blue">
function gajilembur($NIP, $THP, $GAJI_POKOK, $JMLLEMBUR)
{
$tampilpengaturangaji = pengaturangaji(3);
$rumusperbulan = pengaturangaji(8);
//$harisebulan=pengaturangaji(1);
//$ttlwaktukerja=waktukerja(1);
if ($tampilpengaturangaji->VALUE == "THP") {
$valthp = getthp($NIP);
$vlembur = 1 / $rumusperbulan->VALUE * $THP * $JMLLEMBUR;
}
if ($tampilpengaturangaji->VALUE == "GAJI POKOK") {
$datapeg = pegawai($NIP);
$vlembur = 1 / $rumusperbulan->VALUE * $GAJI_POKOK * $JMLLEMBUR;
}
return $vlembur;
}
function gajilembur($NIP)
{
$tampilpengaturangaji = pengaturangaji(3);
$harisebulan = pengaturangaji(1);
$ttlwaktukerja = waktukerja(1);
$ttharisebln = $harisebulan->VALUE * 4 * $ttlwaktukerja;
$jmllembur = jmlembur($NIP);
if ($tampilpengaturangaji->VALUE == "THP") {
$valthp = getthp($NIP);
$vlembur = 1 / $ttharisebln * $valthp * $jmllembur;
}
if ($tampilpengaturangaji->VALUE == "GAJI POKOK") {
$datapeg = pegawai($NIP);
$vlembur = 1 / $ttharisebln * $datapeg->GAJI_POKOK * $jmllembur;
}
return $vlembur;
}
