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; }