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