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