}
$no = 0;
$pegawaicari = mysql_fetch_object(mysql_query("SELECT * FROM pegawai where NIP_PEGAWAI='{$NIP_PEGAWAIH}'"));
$query = mysql_query("SELECT * FROM pegawai WHERE STATUS_PEGAWAI='Tetap' and KODE_PEGAWAI='{$pegawaicari->KODE_PEGAWAI}'") or die(mysql_error());
while ($objectdata = mysql_fetch_object($query)) {
$totalgaji = 0;
$totaljam = 0;
$totaljamlembur = 0;
$totallembur = 0;
$subtotalgaji = 0;
$no++;
/* batas */
$NIP = $objectdata->NIP_PEGAWAI;
$data = pegawai($NIP);
$kp = $data->KODE_PEGAWAI;
$jabatan = jabatan($data->KODE_JABATAN);
$departemen = departemen($data->KODE_DEPARTEMEN);
$KODE_DEPARTEMEN = $objectdata->KODE_DEPARTEMEN;
$pinjaman = mysql_query("select * from pinjaman where KODE_PEGAWAI='{$kp}' and SISA_CICILAN >'0'");
$getpinjaman = mysql_fetch_object($pinjaman);
$nominalpinjaman = $getpinjaman->CICILAN_PERBULAN;
$sisa_cicilan = $getpinjaman->SISA_CICILAN;
$hutang = gethutangrekap($kp, $BULAN, $TAHUN);
$gaji_pokok = $data->GAJI_POKOK;
$tabungan = $objectdata->TABUNGAN;
$tanggal_gaji = date("Y-m-d");
/* $query = "SELECT max(kode_penggajian) as idMaks FROM head_penggajian";
$hasil = mysql_query($query);
$data = mysql_fetch_array($hasil);
$nim = $data['idMaks'];
$noUrut = (int) substr($nim, 9, 5);
function gettunjangan($NIP)
{
$datapeg = pegawai($NIP);
$gajipokok = $datapeg->GAJI_POKOK;
$dataumt = jabatan($datapeg->KODE_JABATAN);
$umt = $dataumt->NOMINAL_UMT;
$TUNJANGAN_LAIN = $datapeg->TUNJANGAN_LAIN;
$gjlembur = gajilembur($NIP);
$tmptunjanganlain = array();
$tmptunjanganlain = explode(",", $TUNJANGAN_LAIN);
$querytunjangan = mysql_query("select sum(NOMINAL) as tunjangan from master_tunjangan where KODE_MASTER_TUNJANGAN IN({$TUNJANGAN_LAIN})");
$gettunjangan = mysql_fetch_object($querytunjangan);
$tunjangan = $gettunjangan->tunjangan;
$tunjangannya = $tunjangan;
return $tunjangannya;
}
