function m_idpegawai_list($KdUnitKerja, $wordkey = "", $aktif = 0, $sort_by)
{
if ($aktif == 1) {
if ($wordkey == "") {
$query = m_idpegawai("KdUnitKerja LIKE '" . $KdUnitKerja . "%'", $sort_by);
} else {
$query = pegawai("(KdUnitKerja LIKE '" . $KdUnitKerja . "%') AND (Nib LIKE '%" . $wordkey . "%' OR \r\n\t\t\t\t\tNip LIKE '%" . $wordkey . "%' OR NamaLengkap LIKE '%" . $wordkey . "%')", $sort_by);
}
} else {
if ($wordkey == "") {
$query = m_idpegawai("KdUnitKerja LIKE '" . $KdUnitKerja . "%' AND (KdStatusPeg = '1' OR KdStatusPeg = '2')", $sort_by);
} else {
$query = m_idpegawai("(KdUnitKerja LIKE '" . $KdUnitKerja . "%') AND (Nib LIKE '%" . $wordkey . "%' OR \r\n\t\t\t\t\tNip LIKE '%" . $wordkey . "%' OR NamaLengkap LIKE '%" . $wordkey . "%') AND (KdStatusPeg = '1' OR \r\n\t\t\t\t\tKdStatusPeg = '2')", $sort_by);
}
}
return $query;
}
}
return $selisih - $jumlahlibur1 - $libur2;
}
$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);
function get_atasan($nip)
{
$Pegawai = pegawai_id($nip);
if ($Pegawai->status_jab == 1) {
$kode_bidang = $Pegawai->kode_bidang;
$cek = substr($kode_bidang, -2);
if ($cek == '00') {
$query = pegawai("kode_bidang LIKE '" . substr($kode_bidang, 0, 2) . "10'");
} else {
$cek = substr($kode_bidang, -1);
if ($cek != '0') {
$query = pegawai("kode_bidang LIKE '" . substr($kode_bidang, 0, 3) . "0' AND status_jab = '1'");
} else {
$query = pegawai("kode_bidang LIKE '" . substr($kode_bidang, 0, 2) . "00' AND status_jab = '1'");
}
}
} else {
$query = pegawai("kode_bidang LIKE '" . $Pegawai->kode_bidang . "' AND status_jab = '1'");
}
$result = mysql_fetch_object($query);
return $result;
}
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;
}
