$jumlah = mysql_num_rows($hasil);
if (mysql_num_rows($hasil) != 0) {
echo "<table width='100%' border='0' align='center' cellpadding='0' cellspacing='0' class='tbl_form'>\n <tr class='head'>\n <td width='90px'><div align='center'><font size='2' face='Verdana'><strong>Proses</strong></font></div></td>\n <td width='40px'><div align='center'><font size='2' face='Verdana'><strong>No.</strong></font></div></td>\n <td width='260px'><div align='center'><font size='2' face='Verdana'><strong>Tgl.Angsur</strong></font></div></td>\n <td width='260px'><div align='center'><font size='2' face='Verdana'><strong>Besar Angsuran</strong></font></div></td>\n </tr>";
$i = 1;
while ($baris = mysql_fetch_array($hasil)) {
echo "<tr class='isi' title='{$baris['2']}, {$baris['3']}, {$baris['4']}, {$baris['5']}, {$baris['6']}, {$baris['7']}, {$baris['8']}'>\n <td>\n <center>";
?>
<a href="?act=BayarPinjam&action=HAPUS&nop=<?php
print $baris[1];
?>
&no_detail=<?php
print $baris[0];
?>
" onClick="if (!confirm('Anda yakin menghapus data history pinjam ini?')) return false;">[hapus]</a>
<?php
echo "</center>\n </td>\n <td>{$i}</td>\n <td>{$baris['2']}</td>\n <td>" . formatDuit($baris[3]) . "</td>\n </tr>";
$i++;
}
echo "</table>";
} else {
echo "<b>Data Bayar Peminjaman masih kosong !</b>";
}
?>
</div>
</form>
<?php
if ($_GET['action'] == "HAPUS") {
Hapus(" detailpinjam_koperasi ", " no_detail ='" . $_GET['no_detail'] . "'", "?act=BayarPinjam&action=TAMBAH&nop=" . $_GET['nop']);
}
if (mysql_num_rows($hasil) != 0) {
echo "Data : {$jumlah} <a target=_blank href=/penggajian/pages/pinjam/LaporanDetailPinjam.php?&id={$id}>| Laporan |</a> ";
}
echo "</table>";
} else {
echo "<b>Data Bagian Karyawan masih kosong !</b>";
}
?>
</div>
<?php
if ($_GET['action'] == "HAPUSAKTE") {
Hapus(" set_akte ", " pendapatan_akte ='" . $_GET['pendapatan_akte'] . "' and tahun='{$tahun}' and bulan='{$bulan}' ", "?act=ListAkte");
}
if ($_GET['action'] == "HAPUSPENERIMA") {
Hapus(" pembagian_akte ", " id ='" . $_GET['id'] . "'", "?act=ListAkte");
}
if (mysql_num_rows($hasil) != 0) {
echo "<br/>Data : {$jumlah}, Ttl Prosen : " . $prosen . "%, Ttl Bagian : " . formatDuit($ttl);
}
?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
if (empty($baris25[6])) {
$pajak = 0;
} else {
$pajak = $baris25[6];
}
$ttlpajak = $ttlpajak + $pajak;
if (empty($baris25[7])) {
$pribadi = 0;
} else {
$pribadi = $baris25[7];
}
$ttlpribadi = $ttlpribadi + $pribadi;
if (empty($baris25[8])) {
$lain = 0 + $alpha;
} else {
$lain = $baris25[8] + $alpha;
}
$ttllain = $ttllain + $lain;
$ttlditerima = $ttlgaji - ($jamsostek + $dansos + $simwajib + $angkop + $angla + $telpri + $pajak + $pribadi + $lain);
$ttlttlditerima = $ttlttlditerima + $ttlditerima;
echo "\n <table>\n <TR class='isi'>\n <TD width='100px'>Jamsostek</TD>\n <TD width='100px'>Dana Sosial</TD>\n <TD width='100px'>Simp.Wajib</TD>\n <TD width='100px'>Ang.Koperasi</TD>\n <TD width='100px'>Ang.Lain</TD>\n <TD width='100px'>Telp.Pribadi</TD>\n <TD width='100px'>Pajak</TD>\n <TD width='100px'>Pribadi</TD>\n <TD width='100px'>Potongan Lain</TD>\n </TR>\n\t\t\t\t <TR class='isi'>\n <TD>" . formatDuit($jamsostek) . " </TD>\n <TD>" . formatDuit($dansos) . " </TD>\n <TD>" . formatDuit($simwajib) . " </TD>\n <TD>" . formatDuit($angkop) . " </TD>\n <TD>" . formatDuit($angla) . " </TD>\n <TD>" . formatDuit($telpri) . " </TD>\n <TD>" . formatDuit($pajak) . " </TD>\n <TD>" . formatDuit($pribadi) . " </TD>\n <TD>" . formatDuit($lain) . " </TD>\n </table>\n\t\t\t\t </td>\n <TD><font size='2' color='green'><i>" . formatDuit($ttlditerima) . "</i></font></TD>\n </tr>";
}
$ttlttlindex = $ttlindexjaga + $ttltotal;
echo "<tr class='head'>\n <td COLSPAN='4'><div align='right'>Total Gaji {$barisbid['0']} : </div></td>\n \n <td width='100px'><div align='center'><font size='2' color='green'><i>" . formatDuit($ttlttlgaji) . "</i></font></div></td>\n <td>\n <table>\n\t\t\t\t <TR class='isi5'>\n <TD width='100px'>" . formatDuit($ttljamsostek) . " </TD>\n <TD width='100px'>" . formatDuit($ttldansos) . " </TD>\n <TD width='100px'>" . formatDuit($ttlsimwajib) . " </TD>\n <TD width='100px'>" . formatDuit($ttlangkop) . " </TD>\n <TD width='100px'>" . formatDuit($ttlangla) . " </TD>\n <TD width='100px'>" . formatDuit($ttltelpri) . " </TD>\n <TD width='100px'>" . formatDuit($ttlpajak) . " </TD>\n <TD width='100px'>" . formatDuit($ttlpribadi) . " </TD>\n <TD width='100px'>" . formatDuit($ttllain) . " </TD>\n </table>\n\t\t\t </td>\n <TD><font size='2' color='green'><i>" . formatDuit($ttlttlditerima) . "</i></font> </TD>\n </tr>\n </table>";
}
$semuanya = $semuanya + $ttlttlditerima;
}
echo " <h3 class=title><b><font color='999999'>Total Seluruh Gaji Karyawan : " . formatDuit($semuanya) . "</font></b><h3>";
?>
</body>
</html>
$hasil = bukaquery($_sql);
$jumlah = mysql_num_rows($hasil);
if (mysql_num_rows($hasil) != 0) {
echo "<table width='900px' border='0' align='center' cellpadding='0' cellspacing='0' class='tbl_form'>\r\n <tr class='head'>\r\n <td width='80px'><div align='center'><font size='2' face='Verdana'><strong>Proses</strong></font></div></td>\r\n <td width='200px'><div align='center'><font size='2' face='Verdana'><strong>Tingkat Pendidikan</strong></font></div></td>\r\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Index Pendidikan</strong></font></div></td>\r\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Gapok Ms Krj <1th</strong></font></div></td>\r\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Gapok Ms Krj 1-<3th</strong></font></div></td>\r\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Gapok Ms Krj >=3th</strong></font></div></td>\r\n </tr>";
while ($baris = mysql_fetch_array($hasil)) {
echo "<tr class='isi'>\r\n\t\t\t\t\t\t <td>\r\n <center>\r\n <a href=?act=InputPendidikan&action=UBAH&tingkat=" . str_replace(" ", "_", $baris[0]) . ">[edit]</a>";
?>
<a href="?act=ListPendidikan&action=HAPUS&tingkat=<?php
print $baris[0];
?>
" onClick="if (!confirm('Anda yakin menghapus data Pendidikan <?php
print $baris[0];
?>
?')) return false;">[hapus]</a>
<?php
echo "</center>\r\n </td>\r\n <td>{$baris['0']}</td>\r\n <td>{$baris['1']}</td>\r\n <td>" . formatDuit($baris[2]) . "</td>\r\n <td>" . formatDuit($baris[3]) . "</td>\r\n <td>" . formatDuit($baris[4]) . "</td>\r\n </tr>";
}
echo "</table>";
} else {
echo "<b>Data Pendidikan masih kosong !</b>";
}
?>
<?php
if ($_GET['action'] == "HAPUS") {
Hapus(" pendidikan ", " tingkat ='" . $_GET['tingkat'] . "' ", "?act=ListPendidikan");
}
?>
</div>
<?php
if ($angla != 0) {
echo "\n\t\t\t\t <TR class='isi6'>\n <TD width='130px'>Angsuran Lain</TD><td width='3px'>:</td><td width='140px'>" . formatDuit($angla) . "</td>\n\t\t\t\t </TR>";
}
if ($telpri != 0) {
echo "\n\t\t\t\t <TR class='isi6'>\n <TD width='130px'>Telepon Pribadi</TD><td width='3px'>:</td><td width='140px'>" . formatDuit($telpri) . "</td>\n\t\t\t\t </TR>";
}
if ($pajak != 0) {
echo "\n\t\t\t\t <TR class='isi6'>\n <TD width='130px'>Pajak</TD><td width='3px'>:</td><td width='140px'>" . formatDuit($pajak) . "</td>\n\t\t\t\t </TR>";
}
if ($pribadi != 0) {
echo "\n\t\t\t\t <TR class='isi6'>\n <TD width='130px'>Pribadi</TD><td width='3px'>:</td><td width='140px'>" . formatDuit($pribadi) . "</td>\n\t\t\t\t </TR>";
}
if ($lain - $alpha > 0) {
echo "\n\t\t\t\t <TR class='isi6'>\n <TD width='130px'>{$ktg}</TD><td width='3px'>:</td><td width='140px'>" . formatDuit($lain - $alpha) . "</td>\n\t\t\t\t </TR>";
}
if ($alpha != 0) {
echo "\n\t\t\t\t <TR class='isi6'>\n <TD width='130px'>Kurang Jaga</TD><td width='3px'>:</td><td width='140px'>" . formatDuit($alpha) . "</td>\n\t\t\t\t </TR>";
}
echo "<TR class='isi6'>\n <TD width='130px'> <i>Jumlah Potongan </i></TD>\n\t\t\t\t\t <td width='3px'>:</td>\n\t\t\t\t\t <td width='140px' align=right><i>" . formatDuit($jamsostek + $dansos + $simwajib + $angkop + $angla + $telpri + $pajak + $pribadi + $lain) . "</i></td>\n\t\t\t\t\t </TR> \n \n\t\t\t\t <TR class='isi6'>\n <TD width='130px'> <i>TOTAL JM DITERIMA</i></TD>\n\t\t\t\t\t <td width='3px'>:</td>\n\t\t\t\t\t <td width='140px' align=right><font size='2px' face='Arial' color='777777'><i>" . formatDuit($ttlditerima) . "</i></font></td>\n\t\t\t\t </TR>\n <TR class='isi6'>\n <TD width='130px' colspan='3'> <i>" . Terbilang($ttlditerima) . "</i></td>\n\t\t\t\t </TR>\n\t\t\t\t <TR class='isi6'>\n <TD width='130px'></TD><td></td><td><center>Yogyakarta, " . date('d-m-Y') . "</center> </td>\n\t\t\t\t </TR>\n\t\t\t\t <TR class='isi6'>\n <TD width='130px'><center>Penerima</center></TD>\n\t\t\t\t\t <td width='3px'> </td>\n\t\t\t\t\t <td width='140px'><center>Pengelola</center></td>\n\t\t\t\t </TR>\n\t\t\t\t <TR class='isi6'>\n <TD width='130px'> </TD>\n\t\t\t\t\t <td width='3px'> </td>\n\t\t\t\t\t <td width='140px'> </td>\n\t\t\t\t </TR>\n\t\t\t\t <TR class='isi6'>\n <TD width='130px'> </TD>\n\t\t\t\t\t <td width='3px'> </td>\n\t\t\t\t\t <td width='140px'> </td>\n\t\t\t\t </TR>\n\t\t\t\t <TR class='isi6'>\n <TD width='130px'><center>( {$baris['2']} )</center></TD>\n\t\t\t\t\t <td width='3px'> </td>\n\t\t\t\t\t <td width='140px'><center>( dr Lily T S Siagian )</center></td>\n\t\t\t\t </TR>\n\t\t\t\t </table>\n\t\t\t\t <center><font size='1px' face='Arial' color='777777'><i><b>..Terima kasih atas kerjasamanya <br>dalam memberikan pelayanan yang berkualitas..</b></i></font></center>\n\n <center><font face='Arial' size='3' color='777777'>Rincian Tindakan</font></center>";
$_sql30 = "select tindakan.tgl,tindakan.nm_pasien,tindakan.kamar,master_tindakan.nama\n from master_tindakan,tindakan\n where tindakan.tnd=master_tindakan.id and\n tindakan.id='{$baris['0']}'\n and tgl like '%" . $tahun . "-" . $bulan . "%' ";
echo "<table width='270px' border='0' align='center' cellpadding='0' cellspacing='0' class='tbl_form'>\n <tr class='isi6'>\n <td width='50px'><div align='center'><font size='1' face='Arial'>Tgl</font></div></td>\n <td width='50px'><div align='center'><font size='1' face='Arial'>Nm.Pasien</font></div></td>\n <td width='50px'><div align='center'><font size='1' face='Arial'>Kamar</font></div></td>\n <td width='50px'><div align='center'><font size='1' face='Arial'>Tindakan</font></div></td>\n </tr>";
$hasil30 = bukaquery($_sql30);
while ($baris30 = mysql_fetch_array($hasil30)) {
echo "<TR class='isi6'>\n <td>" . date("Y-m-d", $baris30[0]) . "</td>\n <td>{$baris30['1']}</td>\n <td>{$baris30['2']}</td>\n <td>{$baris30['3']}</td>\n </tr>";
}
echo " \n </table>\n \n </td>\n </tr>\n </table>";
}
}
?>
</body>
</html>
$hasil = bukaquery($_sql);
$jumlah = mysql_num_rows($hasil);
if (mysql_num_rows($hasil) != 0) {
echo "<table width='600px' border='0' align='center' cellpadding='0' cellspacing='0' class='tbl_form'>\n <tr class='head'>\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Proses</strong></font></div></td>\n <td width='180px'><div align='center'><font size='2' face='Verdana'><strong>Status Keanggotaan</strong></font></div></td>\n <td width='250px'><div align='center'><font size='2' face='Verdana'><strong>Biaya Jamsostek</strong></font></div></td>\n </tr>";
while ($baris = mysql_fetch_array($hasil)) {
echo "<tr class='isi'>\n <td>\n <center>\n\t\t\t\t\t <a href=?act=DetailJamsostek&action=UBAH&stts=" . str_replace(" ", "_", $baris[0]) . "&biaya=" . $baris[1] . ">[edit]</a>";
?>
<a href="?act=DetailJamsostek&action=HAPUS&stts=<?php
print $baris[0];
?>
" onClick="if (!confirm('Anda yakin menghapus data status keanggotaan jamsostek <?php
print $baris[0];
?>
?')) return false;">[hapus]</a>
<?php
echo "</center>\n </td>\n <td>{$baris['0']}</td>\n <td>" . formatDuit($baris[1]) . "</td>\n </tr>";
}
echo "</table>";
} else {
echo "<b>Data Status Keanggotaan Jamsostek masih kosong !</b>";
}
?>
</div>
</form>
<?php
if ($_GET['action'] == "HAPUS") {
Hapus(" jamsostek ", " stts ='" . $stts . "' ", "?act=DetailJamsostek&action=TAMBAH&stts={$stts}");
}
if (mysql_num_rows($hasil) != 0) {
$hasil1 = bukaquery("SELECT stts,biaya from jamsostek ORDER BY stts ");
$jumlah1 = mysql_num_rows($hasil1);
<tr class="head">
<td width="31%">Nama</td><td width="">:</td>
<td width="67%"><?php
echo $baris2[1];
?>
</td>
</tr>
</table>
<?php
$_sql = "select nop, id, jml_angsur, pinjaman, pokok,\n jasa, setoran, tgl_pinjam, stts from pinjam_koperasi\n where id='{$id}'";
$hasil = bukaquery($_sql);
$jumlah = mysql_num_rows($hasil);
if (mysql_num_rows($hasil) != 0) {
echo "<table width='100%' border='0' align='center' cellpadding='0' cellspacing='0' class='tbl_form'>\n \n <tr class='head'>\n <td width='120px'><div align='center'><font size='2' face='Verdana'><strong>JMl.Angsur</strong></font></div></td>\n <td width='110px'><div align='center'><font size='2' face='Verdana'><strong>Pinjaman</strong></font></div></td>\n <td width='110px'><div align='center'><font size='2' face='Verdana'><strong>Pokok</strong></font></div></td>\n <td width='110px'><div align='center'><font size='2' face='Verdana'><strong>Jasa</strong></font></div></td>\n <td width='110px'><div align='center'><font size='2' face='Verdana'><strong>Setoran</strong></font></div></td>\n <td width='110px'><div align='center'><font size='2' face='Verdana'><strong>Tgl.Pinjam</strong></font></div></td>\n <td width='140px'><div align='center'><font size='2' face='Verdana'><strong>Status Pinjam</strong></font></div></td>\n </tr>";
$_sql2 = "select stts from pinjam_koperasi where\n stts='Belum Lunas' and id='{$baris['0']}' ";
$hasil2 = bukaquery($_sql2);
$jumlah2 = mysql_num_rows($hasil2);
$status = "Tidak Ada Pinjaman";
if ($jumlah2 != 0) {
$status = "Ada Pinjaman";
}
while ($baris = mysql_fetch_array($hasil)) {
echo "<tr class='isi'>\n <td>{$baris['2']}</td>\n <td>" . formatDuit($baris[3]) . "</td>\n <td>" . formatDuit($baris[4]) . "</td>\n <td>" . formatDuit($baris[5]) . "</td>\n <td>" . formatDuit($baris[6]) . "</td>\n <td>{$baris['7']}</td>\n <td>{$baris['8']}</td>\n </tr>";
}
echo "</table>";
echo "<h3 class=title><font color='999999'>Jumlah Data : {$jumlah} </font></h3>";
}
?>
</body>
</html>
$ttllembur = 0;
$ttlhr = 0;
if (mysql_num_rows($hasil) != 0) {
echo "<table width='998px' border='0' align='center' cellpadding='0' cellspacing='0' class='tbl_form'>\n <tr class='head'>\n <td width='110px'><div align='center'><font size='2' face='Verdana'><strong>Proses</strong></font></div></td>\n <td width='120px'><div align='center'><font size='2' face='Verdana'><strong>JMl.Angsur</strong></font></div></td>\n <td width='110px'><div align='center'><font size='2' face='Verdana'><strong>Pinjaman</strong></font></div></td>\n <td width='110px'><div align='center'><font size='2' face='Verdana'><strong>Pokok</strong></font></div></td>\n <td width='110px'><div align='center'><font size='2' face='Verdana'><strong>Jasa</strong></font></div></td>\n <td width='110px'><div align='center'><font size='2' face='Verdana'><strong>Setoran</strong></font></div></td>\n <td width='110px'><div align='center'><font size='2' face='Verdana'><strong>Tgl.Pinjam</strong></font></div></td>\n <td width='140px'><div align='center'><font size='2' face='Verdana'><strong>Status Pinjam</strong></font></div></td>\n </tr>";
while ($baris = mysql_fetch_array($hasil)) {
echo "<tr class='isi' title='{$baris['2']}, {$baris['3']}, {$baris['4']}, {$baris['5']}, {$baris['6']}, {$baris['7']}, {$baris['8']}'>\n <td>\n <center>\n <a href=?act=BayarPinjam&action=TAMBAH&nop=" . str_replace(" ", "_", $baris[0]) . ">[Detail]</a>";
?>
<a href="?act=DetailPinjam&action=HAPUS&nop=<?php
print $baris[0];
?>
&id=<?php
print $baris[1];
?>
" onClick="if (!confirm('Anda yakin menghapus data history pinjam ini?')) return false;">[hapus]</a>
<?php
echo "</center>\n </td>\n <td>{$baris['2']}</td>\n <td>" . formatDuit($baris[3]) . "</td>\n <td>" . formatDuit($baris[4]) . "</td>\n <td>" . formatDuit($baris[5]) . "</td>\n <td>" . formatDuit($baris[6]) . "</td>\n <td>{$baris['7']}</td>\n <td>{$baris['8']}</td>\n </tr>";
}
echo "</table>";
} else {
echo "<b>Data Peminjaman masih kosong !</b>";
}
?>
</div>
</form>
<?php
if ($_GET['action'] == "HAPUS") {
Hapus(" pinjam_koperasi ", " nop ='" . $_GET['nop'] . "'", "?act=DetailPinjam&action=TAMBAH&id=" . $_GET['id']);
}
if (mysql_num_rows($hasil) != 0) {
echo "Data : {$jumlah} <a target=_blank href=/penggajian/pages/pinjam/LaporanDetailPinjam.php?&id={$id}>| Laporan |</a> ";
}
$jml = $jml + $ttl;
echo "<tr class='isi' title='{$baris['1']} {$baris['2']}'>\r\n <td>\r\n <center>\r\n <a href=?act=InputPotongan&action=UBAH&id={$baris['0']}>[Update]</a>\r\n </center>\r\n </td>\r\n <td><a href=?act=InputPotongan&action=UBAH&id={$baris['0']}>{$baris['1']}</a></td>\r\n <td><a href=?act=InputPotongan&action=UBAH&id={$baris['0']}>{$baris['2']}</a></td>\r\n <td><a href=?act=InputPotongan&action=UBAH&id={$baris['0']}>{$baris['3']}</a></td>\r\n <td><a href=?act=InputPotongan&action=UBAH&id={$baris['0']}>{$baris['4']}</a></td>\r\n <td><a href=?act=InputPotongan&action=UBAH&id={$baris['0']}>{$baris['5']}</a></td>\r\n <td><a href=?act=InputPotongan&action=UBAH&id={$baris['0']}>" . formatDuit($baris[6]) . "</a></td>\r\n <td><a href=?act=InputPotongan&action=UBAH&id={$baris['0']}>" . formatDuit($baris[7]) . "</a></td>\r\n <td><a href=?act=InputPotongan&action=UBAH&id={$baris['0']}>" . formatDuit($baris[8]) . "</a></td>\r\n <td><a href=?act=InputPotongan&action=UBAH&id={$baris['0']}>" . formatDuit($baris[9]) . "</a></td>\r\n <td><a href=?act=InputPotongan&action=UBAH&id={$baris['0']}>" . formatDuit($baris[10]) . "</a></td>\r\n <td><a href=?act=InputPotongan&action=UBAH&id={$baris['0']}>" . formatDuit($baris[11]) . "</a></td>\r\n <td><a href=?act=InputPotongan&action=UBAH&id={$baris['0']}>" . formatDuit($baris[12]) . "</a></td>\r\n <td><a href=?act=InputPotongan&action=UBAH&id={$baris['0']}>" . formatDuit($baris[13]) . "</a></td>\r\n <td><a href=?act=InputPotongan&action=UBAH&id={$baris['0']}>" . formatDuit($baris[14]) . "</a></td>\r\n <td><a href=?act=InputPotongan&action=UBAH&id={$baris['0']}>" . formatDuit($ttl) . "</a></td>\r\n <td><a href=?act=InputPotongan&action=UBAH&id={$baris['0']}>{$baris['15']}</a></td>\r\n </tr>";
}
echo "</table>";
} else {
echo "<b>Data potongan masih kosong !</b>";
}
?>
</div>
</form>
<?php
if (mysql_num_rows($hasil) != 0) {
$hasil1 = bukaquery("SELECT pegawai.id, \r\n\t\t pegawai.nik,\r\n\t\t\t\tpegawai.nama,\r\n\t\t\t\tpegawai.departemen,\r\n\t\t\t\tkeanggotaan.koperasi, \r\n\t\t\t\tkeanggotaan.jamsostek, \t\t\t\t \r\n\t\t\t\tpotongan.jamsostek, \r\n\t\t\t\tpotongan.dansos, \r\n\t\t\t\tpotongan.simwajib, \r\n\t\t\t\tpotongan.angkop, \r\n\t\t\t\tpotongan.angla, \r\n\t\t\t\tpotongan.telpri, \r\n\t\t\t\tpotongan.pajak, \r\n\t\t\t\tpotongan.pribadi, \r\n\t\t\t\tpotongan.lain, \r\n\t\t\t\tpotongan.ktg\r\n\t\t\t\tFROM keanggotaan, potongan\r\n\t\t\t\tRIGHT OUTER JOIN pegawai ON potongan.id = pegawai.id\r\n\t\t\t\tAND tahun like '%" . $tahun . "%' and bulan like '%" . $bulan . "%' \r\n\t\t\t\tWHERE keanggotaan.id=pegawai.id and pegawai.nik like '%" . $keyword . "%' or\r\n\t\t\t\tkeanggotaan.id=pegawai.id and pegawai.nama like '%" . $keyword . "%' or\r\n\t\t\t\tkeanggotaan.id=pegawai.id and pegawai.departemen like '%" . $keyword . "%' or\r\n\t\t\t\tkeanggotaan.id=pegawai.id and keanggotaan.koperasi like '%" . $keyword . "%' or\r\n\t\t\t\tkeanggotaan.id=pegawai.id and keanggotaan.jamsostek like '%" . $keyword . "%'\r\n\t\t\t\torder by pegawai.id ASC ");
$jumlah1 = mysql_num_rows($hasil1);
$i = $jumlah1 / 19;
$i = ceil($i);
echo "Data : {$jumlah}, Jml.Ptg : " . formatDuit($jml) . " <a target=_blank href=/penggajian/pages/potongan/LaporanPotongan.php?&keyword={$keyword}>| Laporan |</a> ";
}
?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
$ttljm = $ttljm + $baris[4];
echo "<tr class='isi' title='{$baris['1']} {$baris['2']}'>\r\n <td>\r\n <center>\r\n <a href=?act=InputJasLa&action=TAMBAH&id={$baris['0']}>[Detail]</a>\r\n </center>\r\n </td>\r\n <td><a href=?act=InputJasLa&action=TAMBAH&id={$baris['0']}>{$baris['1']}</a></td>\r\n <td><a href=?act=InputJasLa&action=TAMBAH&id={$baris['0']}>{$baris['2']}</a></td>\r\n <td><a href=?act=InputJasLa&action=TAMBAH&id={$baris['0']}>{$baris['3']}</a></td>\r\n <td><a href=?act=InputJasLa&action=TAMBAH&id={$baris['0']}>" . formatDuit($baris[4]) . "</a></td>\r\n </tr>";
}
echo "</table>";
} else {
echo "<b>Data Jasa lain masih kosong !</b>";
}
?>
</div>
</form>
<?php
if (mysql_num_rows($hasil) != 0) {
$hasil1 = bukaquery("SELECT pegawai.id,pegawai.nik,pegawai.nama,\r\n\t\t pegawai.departemen,sum(bsr_jasa)\r\n FROM jasa_lain right OUTER JOIN pegawai\r\n\t\t\t\tON jasa_lain.id=pegawai.id and thn='" . $tahun . "'\r\n and bln='" . $bulan . "'\r\n\t\t\t\twhere pegawai.nik like '%" . $keyword . "%' or\r\n\t\t\t\tpegawai.nama like '%" . $keyword . "%' or\r\n\t\t\t\tpegawai.departemen like '%" . $keyword . "%'\r\n\t\t\t\tgroup by pegawai.id order by pegawai.id ASC");
$jumlah1 = mysql_num_rows($hasil1);
$i = $jumlah1 / 19;
$i = ceil($i);
echo "Data : {$jumlah}, Ttl.Jasa lain : " . formatDuit($ttljm) . " ";
}
?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
}
echo "</table>";
} else {
echo "<b>Data Insentif masih kosong !</b>";
}
?>
</div>
<?php
if ($_GET['action'] == "HAPUSINSENTIF") {
Hapus(" set_insentif ", " pendapatan ='" . $_GET['pendapatan'] . "' and tahun='{$tahun}' and bulan='{$bulan}' ", "?act=ListInsentif");
}
if ($_GET['action'] == "HAPUSINDEX") {
Hapus(" indexins ", " dep_id ='" . $_GET['dep_id'] . "'", "?act=ListInsentif");
}
if (mysql_num_rows($hasil) != 0) {
echo "<br/>Data : {$jumlah}, Ttl Prosen : " . $prosen . "%, Ttl Insentif : " . formatDuit($ttl) . " ";
}
?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<head>
<link href="../../css/default.css" rel="stylesheet" type="text/css" />
</head>
<body>
<?php
$keyword = $_GET['keyword'];
$_sql = "select pegawai.id,pegawai.nik,pegawai.nama,\n\t\t pegawai.departemen from pegawai\n\t\t where pegawai.stts_aktif<>'KELUAR' and pegawai.nik like '%" . $keyword . "%' or\n\t\t pegawai.stts_aktif<>'KELUAR' and pegawai.nama like '%" . $keyword . "%' or\n\t\t pegawai.stts_aktif<>'KELUAR' and pegawai.departemen like '%" . $keyword . "%'\n\t\t order by pegawai.id ASC ";
$hasil = bukaquery($_sql);
$jumlah = mysql_num_rows($hasil);
if (mysql_num_rows($hasil) != 0) {
echo "<table width='100%' border='0' align='center' cellpadding='0' cellspacing='0' class='tbl_form'>\n <caption><h2 class=title><font color='999999'>Laporan Penerima Tunjangan</font></h2></caption>\n <tr class='head'>\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>NIK</strong></font></div></td>\n <td width='250px'><div align='center'><font size='2' face='Verdana'><strong>Nama</strong></font></div></td>\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Departemen</strong></font></div></td>\n <td width='300px'><div align='center'><font size='2' face='Verdana'><strong>Tnj. Bulanan Diterima</strong></font></div></td>\n\t\t\t<td width='250px'><div align='center'><font size='2' face='Verdana'><strong>Tnj. Harian Diterima</strong></font></div></td>\n </tr>";
while ($baris = mysql_fetch_array($hasil)) {
echo "<tr class='isi'>\n <td>{$baris['1']} </td>\n <td>{$baris['2']} </td>\n <td>{$baris['3']} </td>\n <td>";
$_sql2 = "select master_tunjangan_bulanan.nama,\n\t\t\t\t master_tunjangan_bulanan.tnj\n\t\t\t\t\t from pnm_tnj_bulanan,master_tunjangan_bulanan\n\t\t\t\t\t where pnm_tnj_bulanan.id_tnj=master_tunjangan_bulanan.id\n\t\t\t\t\t and pnm_tnj_bulanan.id='{$baris['0']}'";
$hasil2 = bukaquery($_sql2);
while ($baris2 = mysql_fetch_array($hasil2)) {
echo "<table width='300px'><tr class='isi3'><td width='150px'>{$baris2['0']} </td><td>: " . formatDuit($baris2[1]) . " </td></tr></table>";
}
echo " \n\t\t\t\t</td>\n\t\t\t\t<td>";
$_sql2 = "select master_tunjangan_harian.nama,\n\t\t\t\t master_tunjangan_harian.tnj\n\t\t\t\t\t from pnm_tnj_harian,master_tunjangan_harian\n\t\t\t\t\t where pnm_tnj_harian.id_tnj=master_tunjangan_harian.id\n\t\t\t\t\t and pnm_tnj_harian.id='{$baris['0']}'";
$hasil2 = bukaquery($_sql2);
while ($baris2 = mysql_fetch_array($hasil2)) {
echo "<table width='300px'><tr class='isi3'><td width='150px'>{$baris2['0']} </td><td>: " . formatDuit($baris2[1]) . " </td></tr></table>";
}
echo " \n\t\t\t\t</td>\n </tr>";
}
echo "</table>";
}
?>
</body>
</html>
} else {
echo "<b>Data Detail masih kosong !</b>";
}
?>
</div>
</form>
<?php
if ($_GET['action'] == "HAPUS") {
Hapus(" tindakan ", " id ='" . $_GET['id'] . "' and tgl ='" . $_GET['tgl'] . "' and tnd ='" . $_GET['tnd'] . "' and nm_pasien ='" . str_replace("_", " ", $_GET['nm_pasien']) . "'", "?act=InputTindakanSpesialis&action=TAMBAH&id={$id}");
}
if (mysql_num_rows($hasil) != 0) {
$hasil1 = bukaquery("select tindakan.tgl,\r\n tindakan.id,\r\n tindakan.tnd,\r\n master_tindakan.nama,\r\n tindakan.jm,\r\n tindakan.nm_pasien,\r\n tindakan.kamar,\r\n tindakan.diagnosa,\r\n tindakan.jmlh\r\n from tindakan inner join master_tindakan\r\n where tindakan.tnd=master_tindakan.id and tindakan.id='{$id}'\r\n\t\t\tand tgl like '%" . $tahun . "-" . $bulan . "%' ORDER BY tgl ASC");
$jumlah1 = mysql_num_rows($hasil1);
$i = $jumlah1 / 19;
$i = ceil($i);
echo "Data : {$jumlah}, Ttl.JM : " . formatDuit($ttljms) . " <a target=_blank href=/penggajian/pages/tindakan/laporandetailtindakandokter.php?&id={$id}>| Laporan |</a> ";
}
?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
$hakcuti = 0;
} else {
if ($baris[14] >= 1 && $baris[14] < 3) {
$gapok = $baris4[1];
$hakcuti = 12;
} else {
if ($baris[14] >= 3) {
$gapok = $baris4[2];
$hakcuti = 14;
}
}
}
$total = 0;
if ($baris[11] == 0) {
$total = $baris[7] + $masa_kerja + $baris[9] + $baris[10];
} else {
if ($baris[11] > 0) {
$total = ($baris[7] + $masa_kerja + $baris[9] + $baris[10]) * ($baris[11] / 100);
}
}
echo "<tr class='isi'>\t\t\t\t\t \n <td>{$baris['1']} </td>\n <td>{$baris['2']} </td>\n <td>{$baris['3']} </td>\n <td>{$baris['4']} </td>\n <td>{$baris['5']} </td>\n <td>{$baris['6']} </td>\n <td>{$baris['7']} </td>\n <td>{$masa_kerja} </td>\n <td>{$baris['9']} </td>\n <td>{$baris['10']} </td>\n <td>{$baris['11']} % </td>\n <td>{$total} </td>\n <td>{$baris['12']} </td>\n <td>{$baris['13']} </td>\n <td>" . formatDuit($gapok) . " </td>\n <td>{$hakcuti} </td>\n <td>{$ttlc} </td>\n <td>" . ($hakcuti - $ttlc) . " </td>\n </tr>";
}
echo "</table>";
echo "<br><font color='999999' size='3'><b>Jumlah Pegawai : " . $jumlah . "</b></font>";
} else {
echo "<b>Data Index Pegawai masih kosong !</b>";
}
?>
</body>
</html>
<div style="width: 598px; height: 150px; overflow: auto; padding: 5px">
<?php
$_sql = "SELECT tnj from set_lemburhr ORDER BY tnj ASC";
$hasil = bukaquery($_sql);
$jumlah = mysql_num_rows($hasil);
if (mysql_num_rows($hasil) != 0) {
echo "<table width='598px' border='0' align='center' cellpadding='0' cellspacing='0' class='tbl_form'>\n <tr class='head'>\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Proses</strong></font></div></td>\n <td width='250px'><div align='center'><font size='2' face='Verdana'><strong>Besar Tunjangan</strong></font></div></td>\n </tr>";
while ($baris = mysql_fetch_array($hasil)) {
echo "<tr class='isi'>\n <td>\n <center>";
?>
<a href="?act=InputSetLemburHR&action=HAPUS&tnj=<?php
print $baris[0];
?>
" onClick="if (!confirm('Anda yakin menghapus set lebur hari raya ?')) return false;">[hapus]</a>
<?php
echo "</center>\n </td>\n <td>" . formatDuit($baris[0]) . "</td>\n </tr>";
}
echo "</table>";
} else {
echo "<b>Data set lebur hari raya masih kosong !</b>";
}
?>
</div>
</form>
<?php
if ($_GET['action'] == "HAPUS") {
Hapus(" set_lemburhr ", " tnj ='" . $tnj . "' ", "?act=InputSetLemburHR&action=TAMBAH&tnj=" . $tnj);
}
?>
</div>
if (empty($baris25[7])) {
$pribadi = 0;
} else {
$pribadi = $baris25[7];
}
$ttlpribadi = $ttlpribadi + $pribadi;
if (empty($baris25[8])) {
$lain = 0 + $alpha;
} else {
$lain = $baris25[8] + $alpha;
}
$ttllain = $ttllain + $lain;
$ttlditerima = $ttlgaji - ($jamsostek + $dansos + $simwajib + $angkop + $angla + $telpri + $pajak + $pribadi + $lain);
$ttlttlditerima = $ttlttlditerima + $ttlditerima;
echo "\n \n <TR class='isi6'>\n <TD width='130px'>Potongan Jasa Medis :</TD><td></td><td></td>\n\t\t\t\t </TR>\n\t\t\t\t <TR class='isi6'>\n <TD width='130px'>Pajak</TD><td width='3px'>:</td><td width='140px'>" . formatDuit($pajak) . "</td>\n\t\t\t\t </TR>\n\t\t\t\t <TR class='isi6'>\n <TD width='130px'>{$ktg}</TD><td width='3px'>:</td><td width='140px'>" . formatDuit($lain) . "</td>\n\t\t\t\t </TR>\n\t\t\t\t <TR class='isi6'>\n <TD width='130px'> <i>TOTAL JM DITERIMA</i></TD>\n\t\t\t\t\t <td width='3px'>:</td>\n\t\t\t\t\t <td width='140px'> <i>" . formatDuit($ttlditerima) . "</i></td>\n\t\t\t\t </TR>\n <TR class='isi6'>\n <TD width='130px' colspan='3'> <i>" . Terbilang($ttlditerima) . "</i></td>\n\t\t\t\t </TR>\n <TR class='isi6'>\n <TD width='130px'></TD><td></td><td><center>Yogyakarta, " . date('d-m-Y') . "</center> </td>\n\t\t\t\t </TR>\n\t\t\t\t <TR class='isi6'>\n <TD width='130px'><center>Penerima</center></TD>\n\t\t\t\t\t <td width='3px'> </td>\n\t\t\t\t\t <td width='140px'><center>Pengelola</center></td>\n\t\t\t\t </TR>\n\t\t\t\t <TR class='isi6'>\n <TD width='130px'> </TD>\n\t\t\t\t\t <td width='3px'> </td>\n\t\t\t\t\t <td width='140px'> </td>\n\t\t\t\t </TR>\n\t\t\t\t <TR class='isi6'>\n <TD width='130px'> </TD>\n\t\t\t\t\t <td width='3px'> </td>\n\t\t\t\t\t <td width='140px'> </td>\n\t\t\t\t </TR>\n\t\t\t\t <TR class='isi6'>\n <TD width='130px'><center>( {$baris['2']} )</center></TD>\n\t\t\t\t\t <td width='3px'> </td>\n\t\t\t\t\t <td width='140px'><center>( dr Lily T S Siagian )</center></td>\n\t\t\t\t </TR>\n <TR class='isi6'>\n <TD width='130px'> </TD>\n\t\t\t\t\t <td width='3px'> </td>\n\t\t\t\t\t <td width='140px'> </td>\n\t\t\t\t </TR>\n <TR class='isi6'>\n <TD width='130px'> </TD>\n\t\t\t\t\t <td width='3px'> </td>\n\t\t\t\t\t <td width='140px'> </td>\n\t\t\t\t </TR>\n <!--ini di hiden disini\n <TR class='isi6'>\n <TD width='130px' colspan='3'><center><font color='999999' size='2' face='Arial'>RSKIA SADEWA</font> <br>\n <font color='999999' size='1' face='Arial'><b>Yayasan Pelayanan Kesehatan Prima SEMAR<br> \n Jl.Babarsari TB 16 No.13 Sleman Yogyakarta 55281<br> \n Telp 0274-489118, Fax 0274-485903<br>\n Jasa Medis Tahun " . $tahun . " </b></font></center></TD>\n\t\t\t\t </TR>\n <TR class='isi6'>\n <TD width='130px' colspan='3'><center><font face='Arial' size='1' color='999999'>Rawat Jalan</font></center>";
$_sql30 = "select rawatjalan.tgl,rawatjalan.nm_pasien,rawatjalan.diagnosa,master_tindakan.nama,\n rawatjalan.kamar,rawatjalan.jm,rawatjalan.jmlh,master_tindakan.jm\n from master_tindakan,rawatjalan\n where rawatjalan.tnd=master_tindakan.id and\n rawatjalan.id='{$baris['0']}'\n and tgl like '%" . $tahun . "-" . $bulan . "%' ";
echo "<table width='270px' border='1' align='center' cellpadding='0' cellspacing='0' class='tbl_form'>\n <tr class='isi6'>\n <td width='10px'><div align='center'><font size='1' face='Arial'>No</font></div></td>\n <td width='40px'><div align='center'><font size='1' face='Arial'>Tgl</font></div></td>\n <td width='50px'><div align='center'><font size='1' face='Arial'>Tindakan</font></div></td>\n <td width='20px'><div align='center'><font size='1' face='Arial'>Jmlh</font></div></td>\n <td width='50px'><div align='center'><font size='1' face='Arial'>JM</font></div></td>\n <td width='50px'><div align='center'><font size='1' face='Arial'>Ttl.JM</font></div></td>\n </tr>";
$hasil30 = bukaquery($_sql30);
$x = 1;
$jmrj = 0;
while ($baris30 = mysql_fetch_array($hasil30)) {
echo "<TR class='isi6'>\n <td>{$x}</td>\n <td>" . substr($baris30[0], 0, 10) . "</td>\n <td>{$baris30['3']}</td>\n <td>{$baris30['6']}</td>\n <td>{$baris30['7']}</td>\n <td>{$baris30['5']}</td>\n </tr>";
$x++;
$jmrj = $jmrj + $baris30[5];
}
echo " \n \n </table> \n </td>\n\t\t\t\t </TR>\n <TR class='isi6'>\n <TD width='130px'>JM Rawat Jalan</TD>\n\t\t\t\t\t <td width='3px'>:</td>\n\t\t\t\t\t <td width='140px'>" . formatDuit($jmrj) . "</td>\n\t\t\t\t </TR>\n <TR class='isi6'>\n <TD width='130px'>JM Tindakan </TD>\n\t\t\t\t\t <td width='3px'>:</td>\n\t\t\t\t\t <td width='140px'>" . formatDuit($ttlditerima) . "</td>\n\t\t\t\t </TR>\n <TR class='isi6'>\n <TD width='130px'>Total Diterima </TD>\n\t\t\t\t\t <td width='3px'>:</td>\n\t\t\t\t\t <td width='140px'> " . formatDuit($jmrj + $ttlditerima) . "</td>\n\t\t\t\t </TR>\n <TR class='isi6'>\n\t\t\t\t\t <td colspan=3>" . Terbilang($jmrj + $ttlditerima) . "</td>\n\t\t\t\t </TR>\n\t\t\t\t <TR class='isi6'>\n <TD width='130px'></TD><td></td><td><center>Yogyakarta, " . date('d-m-Y') . "</center> </td>\n\t\t\t\t </TR>\n\t\t\t\t <TR class='isi6'>\n <TD width='130px'><center>Penerima</center></TD>\n\t\t\t\t\t <td width='3px'> </td>\n\t\t\t\t\t <td width='140px'><center>Pengelola</center></td>\n\t\t\t\t </TR>\n\t\t\t\t <TR class='isi6'>\n <TD width='130px'> </TD>\n\t\t\t\t\t <td width='3px'> </td>\n\t\t\t\t\t <td width='140px'> </td>\n\t\t\t\t </TR>\n\t\t\t\t <TR class='isi6'>\n <TD width='130px'> </TD>\n\t\t\t\t\t <td width='3px'> </td>\n\t\t\t\t\t <td width='140px'> </td>\n\t\t\t\t </TR>\n\t\t\t\t <TR class='isi6'>\n <TD width='130px'><center>( {$baris['2']} )</center></TD>\n\t\t\t\t\t <td width='3px'> </td>\n\t\t\t\t\t <td width='140px'><center>( dr Lily T S Siagian )</center></td>\n\t\t\t\t </TR>\n\t\t\t\t </table>\n\t\t\t\t \n </td> \n </tr> \n akhir dari hiden disini-->\n </table>";
}
}
?>
</body>
</html>
if (mysql_num_rows($hasil) != 0) {
echo "<table width='100%' border='0' align='center' cellpadding='0' cellspacing='0' class='tbl_form'>\n <caption><h2 class=title><font color='999999'>Laporan Potongan Gaji Tahun " . $tahun . " Bulan " . $bulan . "</font></h2></caption>\n <tr class='head'>\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>NIK</strong></font></div></td>\n <td width='250px'><div align='center'><font size='2' face='Verdana'><strong>Nama</strong></font></div></td>\n\t\t\t<td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Departemen</strong></font></div></td>\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Anggota Koperasi</strong></font></div></td>\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Anggota Jamsostek</strong></font></div></td>\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Jamsostek</strong></font></div></td>\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Dana Sosial</strong></font></div></td>\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Simpanan Wajib</strong></font></div></td>\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Angsuran Koperasi</strong></font></div></td>\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Angsuran Lain</strong></font></div></td>\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Telepon Pribadi</strong></font></div></td>\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Pajak</strong></font></div></td>\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Pribadi</strong></font></div></td>\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Lain-Lain</strong></font></div></td>\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Total Potongan</strong></font></div></td>\n <td width='200px'><div align='center'><font size='2' face='Verdana'><strong>Keterangan</strong></font></div></td>\n </tr>";
while ($baris = mysql_fetch_array($hasil)) {
$ttl = $baris[6] + $baris[7] + $baris[8] + $baris[9] + $baris[10] + $baris[11] + $baris[12] + $baris[13] + $baris[14];
$jml = $jml + $ttl;
$jamsos = $jamsos + $baris[6];
$dansos = $dansos + $baris[7];
$simwa = $simwa + $baris[8];
$angkop = $angkop + $baris[9];
$angla = $angla + $baris[10];
$telpri = $telpri + $baris[11];
$pajak = $pajak + $baris[12];
$pribadi = $pribadi + $baris[13];
$lain = $lain + $baris[14];
echo "<tr class='isi'>\n <td>{$baris['1']} </td>\n <td>{$baris['2']} </td>\n <td>{$baris['3']} </td>\n <td>{$baris['4']} </td>\n <td>{$baris['5']} </td>\n <td>" . formatDuit($baris[6]) . " </td>\n <td>" . formatDuit($baris[7]) . " </td>\n <td>" . formatDuit($baris[8]) . " </td>\n <td>" . formatDuit($baris[9]) . " </td>\n <td>" . formatDuit($baris[10]) . " </td>\n <td>" . formatDuit($baris[11]) . " </td>\n <td>" . formatDuit($baris[12]) . " </td>\n <td>" . formatDuit($baris[13]) . " </td>\n <td>" . formatDuit($baris[14]) . " </td>\n <td>" . formatDuit($ttl) . " </td>\n <td>{$baris['15']} </td>\n </tr>";
}
echo "</table>";
}
echo "<br><font color='999999' size='3'><b>Total Jamsostek : " . formatDuit($jamsos) . "</b></font>";
echo "<br><font color='999999' size='3'><b>Total Dana Sosial : " . formatDuit($dansos) . "</b></font>";
echo "<br><font color='999999' size='3'><b>Total Simpanan Wajib : " . formatDuit($simwa) . "</b></font>";
echo "<br><font color='999999' size='3'><b>Total Angsuran koperasi : " . formatDuit($angkop) . "</b></font>";
echo "<br><font color='999999' size='3'><b>Total Angsuran Lain : " . formatDuit($angla) . "</b></font>";
echo "<br><font color='999999' size='3'><b>Total Telephone Pribadi : " . formatDuit($telpri) . "</b></font>";
echo "<br><font color='999999' size='3'><b>Total Pajak : " . formatDuit($pajak) . "</b></font>";
echo "<br><font color='999999' size='3'><b>Total Pribadi : " . formatDuit($pribadi) . "</b></font>";
echo "<br><font color='999999' size='3'><b>Total Lain-Lain : " . formatDuit($lain) . "</b></font>";
echo "<br><font color='999999' size='3'><b>Jumlah Total Potongan Gaji : " . formatDuit($jml) . "</b></font>";
?>
</body>
</html>
$baris = mysql_fetch_row($hasil);
$tahun = $baris[0];
$bln_leng = strlen($baris[1]);
$bulan = "0";
if ($bln_leng == 1) {
$bulan = "0" . $baris[1];
} else {
$bulan = $baris[1];
}
$id = $_GET['id'];
$_sql = "SELECT nik,nama FROM pegawai where id='{$id}'";
$hasil = bukaquery($_sql);
$baris = mysql_fetch_row($hasil);
$nik = $baris[0];
$nama = $baris[1];
$_sql = "select rawatjalan.tgl,\n rawatjalan.id,\n rawatjalan.tnd,\n master_tindakan.nama,\n rawatjalan.jm,\n rawatjalan.nm_pasien,\n rawatjalan.kamar,\n rawatjalan.diagnosa,\n rawatjalan.jmlh\n from rawatjalan inner join master_tindakan\n where rawatjalan.tnd=master_tindakan.id and rawatjalan.id='{$id}'\n\t\t\t and tgl like '%" . $tahun . "-" . $bulan . "%' ORDER BY tgl ";
$hasil = bukaquery($_sql);
$jumlah = mysql_num_rows($hasil);
$ttljm = 0;
if (mysql_num_rows($hasil) != 0) {
echo "<table width='100%' border='0' align='center' cellpadding='0' cellspacing='0' class='tbl_form'>\n <caption><h3 class=title><font color='999999'>Laporan Rawat Jalan Dokter " . $nik . " " . $nama . "<br>Tahun " . $tahun . " Bulan " . $bulan . "</font></h3><br>\n\t\t\t\t\t</caption>\n <tr class='head'>\n <td width='20%'><div align='center'><font size='2' face='Verdana'><strong>Jmlh.Tindakan</strong></font></div></td>\n <td width='50%'><div align='center'><font size='2' face='Verdana'><strong>Nama Tindakan</strong></font></div></td>\n <td width='30%'><div align='center'><font size='2' face='Verdana'><strong>JM Tindakan</strong></font></div></td>\n </tr>";
while ($baris = mysql_fetch_array($hasil)) {
$ttljm = $ttljm + $baris[4];
echo "<tr class='isi'>\n <td>{$baris['8']} </td>\n <td>{$baris['3']} </td>\n <td>" . formatDuit($baris[4]) . " </td>\n </tr>";
}
echo "</table>";
echo "<br><font color='999999' size='3'><b>Jumlah Total JM : " . formatDuit($ttljm) . "</b></font>";
}
?>
</body>
</html>
if ($baris[14] >= 3) {
$gapok = $baris4[2];
$hakcuti = 14;
}
}
}
$total = 0;
if ($baris[11] == 0) {
$total = $baris[7] + $masa_kerja + $baris[9] + $baris[10];
} else {
if ($baris[11] > 0) {
$total = ($baris[7] + $masa_kerja + $baris[9] + $baris[10]) * ($baris[11] / 100);
}
}
echo "<tr class='isi' title='{$baris['1']} {$baris['2']}'>\r\n <td width='70'>\r\n <center>\r\n <a href=?act=EditIndexPegawai&action=UBAH&id={$baris['0']}>[edit]</a>";
echo " </center>\r\n </td>\t\t\t\t\t\t \r\n <td><a href=?act=InputPegawai&action=UBAH&id={$baris['0']}>{$baris['1']}</a></td>\r\n <td><a href=?act=InputPegawai&action=UBAH&id={$baris['0']}>{$baris['2']}</a></td>\r\n <td><a href=?act=InputPegawai&action=UBAH&id={$baris['0']}>{$baris['3']}</a></td>\r\n <td><a href=?act=InputPegawai&action=UBAH&id={$baris['0']}>{$baris['4']}</a></td>\r\n <td><a href=?act=InputPegawai&action=UBAH&id={$baris['0']}>{$baris['5']}</a></td>\r\n <td><a href=?act=InputPegawai&action=UBAH&id={$baris['0']}>{$baris['6']}</a></td>\r\n <td><a href=?act=InputPegawai&action=UBAH&id={$baris['0']}>{$baris['7']}</a></td>\r\n <td><a href=?act=InputPegawai&action=UBAH&id={$baris['0']}>{$masa_kerja}</a></td>\r\n <td><a href=?act=InputPegawai&action=UBAH&id={$baris['0']}>{$baris['9']}</a></td>\r\n <td><a href=?act=EditIndexPegawai&action=UBAH&id={$baris['0']}>{$baris['10']}</a></td>\r\n <td><a href=?act=EditIndexPegawai&action=UBAH&id={$baris['0']}>{$baris['11']} %</a></td>\r\n <td><a href=?act=EditIndexPegawai&action=UBAH&id={$baris['0']}>{$total}</a></td>\r\n <td><a href=?act=InputPegawai&action=UBAH&id={$baris['0']}>{$baris['12']}</a></td>\r\n <td><a href=?act=InputPegawai&action=UBAH&id={$baris['0']}>{$baris['13']}</a></td>\r\n <td><a href=?act=InputPegawai&action=UBAH&id={$baris['0']}>" . formatDuit($gapok) . "</a></td>\r\n <td><a href=?act=InputPegawai&action=UBAH&id={$baris['0']}>{$hakcuti}</a></td>\r\n <td><a href=?act=EditIndexPegawai&action=UBAH&id={$baris['0']}>{$ttlc}</a></td>\r\n <td><a href=?act=EditIndexPegawai&action=UBAH&id={$baris['0']}>" . ($hakcuti - $ttlc) . "</a></td>\r\n </tr>";
}
echo "</table>";
} else {
echo "<b>Data Index Pegawai masih kosong !</b>";
}
$BtnPrint = $_POST['BtnPrint'];
if (isset($BtnPrint)) {
echo "<html><head><title></title><meta http-equiv='refresh' content='2;pages/pegawai/LaporanIndex.php?&keyword={$keyword}'></head><body></body></html>";
}
?>
</div>
</form>
<?php
if (mysql_num_rows($hasil) != 0) {
$say = " pegawai.pendidikan=pendidikan.tingkat\r\n and pegawai.stts_kerja =stts_kerja.stts\r\n and pegawai.jnj_jabatan=jnj_jabatan.kode ";
} else {
$pribadi = $baris25[7];
}
$ttlpribadi = $ttlpribadi + $pribadi;
if (empty($baris25[8])) {
$lain = 0 + $alpha;
} else {
$lain = $baris25[8] + $alpha;
}
$ttllain = $ttllain + $lain;
$ttlditerima = $ttlgaji - ($jamsostek + $dansos + $simwajib + $angkop + $angla + $telpri + $pajak + $pribadi + $lain);
$ttlttlditerima = $ttlttlditerima + $ttlditerima;
echo "\n <table>\n <TR class='isi'>\n <TD width='100px'><a href=?act=InputPotongan&action=UBAH&id={$baris['0']}>Jamsostek</a></TD>\n <TD width='100px'><a href=?act=InputPotongan&action=UBAH&id={$baris['0']}>Dana Sosial</a></TD>\n <TD width='100px'><a href=?act=InputPotongan&action=UBAH&id={$baris['0']}>Simp.Wajib</a></TD>\n <TD width='100px'><a href=?act=InputPotongan&action=UBAH&id={$baris['0']}>Ang.Koperasi</a></TD>\n <TD width='100px'><a href=?act=InputPotongan&action=UBAH&id={$baris['0']}>Ang.Lain</a></TD>\n <TD width='100px'><a href=?act=InputPotongan&action=UBAH&id={$baris['0']}>Telp.Pribadi</a></TD>\n <TD width='100px'><a href=?act=InputPotongan&action=UBAH&id={$baris['0']}>Pajak</a></TD>\n <TD width='100px'><a href=?act=InputPotongan&action=UBAH&id={$baris['0']}>Pribadi</a></TD>\n <TD width='100px'><a href=?act=InputPotongan&action=UBAH&id={$baris['0']}>Potongan Lain</a></TD>\n </TR>\n\t\t\t\t <TR class='isi'>\n <TD>" . formatDuit($jamsostek) . "</TD>\n <TD>" . formatDuit($dansos) . "</TD>\n <TD>" . formatDuit($simwajib) . "</TD>\n <TD>" . formatDuit($angkop) . "</TD>\n <TD>" . formatDuit($angla) . "</TD>\n <TD>" . formatDuit($telpri) . "</TD>\n <TD>" . formatDuit($pajak) . "</TD>\n <TD>" . formatDuit($pribadi) . "</TD>\n <TD>" . formatDuit($lain) . "</TD>\n </table>\n\t\t\t\t </td>\n <TD><font size='2' color='green'><i>" . formatDuit($ttlditerima) . "</i></font></TD>\n </tr>";
}
$ttlttlindex = $ttlindexjaga + $ttltotal;
echo "<tr class='head'>\n <td COLSPAN='9'><div align='right'>Total : </div></td>\n <td>\n <table>\n\t\t\t\t <TR class='isi5'>\n <TD width='100px'>" . formatDuit($ttlgapok) . "</TD>\n\t\t\t\t\t <TD width='100px'>" . formatDuit($ttltnjjbtn) . "</TD>\n <TD width='300px'>" . formatDuit($ttltnjtnj) . "</TD>\n <TD width='100px'>" . formatDuit($ttltmbhjgmlm) . "</TD>\n\t\t\t\t\t <TD width='100px'>" . formatDuit($ttltmbahanjg) . "</TD>\n\t\t\t\t\t <TD width='100px'>" . formatDuit($ttltnjhadir) . "</TD>\n\t\t\t\t\t <TD width='120px'><i>" . formatDuit($ttljmlgaji) . "</i></TD>\n </TR>\n </table>\n\t\t\t </td>\n <td>\n <table>\n\t\t\t\t <TR class='isi5'>\n <TD width='100px'>" . formatDuit($ttllemburhb) . "</TD>\n <TD width='100px'>" . formatDuit($ttllemburhr) . "</TD>\n <TD width='100px'><i>" . formatDuit($ttllemburhb + $ttllemburhr) . "</i></TD>\n </TR>\n </table>\n\t\t\t </td>\n <td>\n <table>\n\t\t\t\t <TR class='isi5'>\n <TD width='65px'>{$ttltotal}</TD>\n\t\t\t\t\t <TD width='65px'>{$ttlindexjaga}</TD>\n\t\t\t\t\t <TD width='65px'>{$ttlttlindex}</TD>\n <TD width='105px'>" . formatDuit($ttlttlinsentif) . "</TD>\n <TD width='105px'>" . formatDuit($ttljm) . "</TD>\n <TD width='105px'>" . formatDuit($ttljasalain) . "</TD>\n <TD width='105px'><i>" . formatDuit($ttljmltmb) . "</i></TD>\n </TR>\n </table>\n\t\t\t </td>\n <td width='100px'><div align='center'><font size='2' color='green'><i>" . formatDuit($ttlttlgaji) . "</i></font></div></td>\n <td>\n <table>\n\t\t\t\t <TR class='isi5'>\n <TD width='100px'>" . formatDuit($ttljamsostek) . "</TD>\n <TD width='100px'>" . formatDuit($ttldansos) . "</TD>\n <TD width='100px'>" . formatDuit($ttlsimwajib) . "</TD>\n <TD width='100px'>" . formatDuit($ttlangkop) . "</TD>\n <TD width='100px'>" . formatDuit($ttlangla) . "</TD>\n <TD width='100px'>" . formatDuit($ttltelpri) . "</TD>\n <TD width='100px'>" . formatDuit($ttlpajak) . "</TD>\n <TD width='100px'>" . formatDuit($ttlpribadi) . "</TD>\n <TD width='100px'>" . formatDuit($ttllain) . "</TD>\n </table>\n\t\t\t </td>\n <TD><font size='2' color='green'><i>" . formatDuit($ttlttlditerima) . "</i></font></TD>\n </tr>\n </table>";
} else {
echo "<b>Data Lampiran masih kosong !</b>";
}
?>
</div>
</form>
<?php
if (mysql_num_rows($hasil) != 0) {
echo "Data : {$jumlah} <a target=_blank href=/penggajian/pages/lampiran/LaporanLampiran.php?&keyword={$keyword}>| Laporan1 </a>\n <a target=_blank href=/penggajian/pages/lampiran/LaporanLampiran2.php?&keyword={$keyword}>| Laporan2 </a>\n <a target=_blank href=/penggajian/pages/lampiran/LaporanLampiran3.php?&keyword={$keyword}>| Laporan3 </a>\n <a target=_blank href=/penggajian/pages/lampiran/LaporanLampiran4.php?&keyword={$keyword}>| Laporan4 </a>\n <a target=_blank href=/penggajian/pages/lampiran/LaporanLampiran5.php?&keyword={$keyword}>| Laporan5 </a>\n <a target=_blank href=/penggajian/pages/lampiran/LaporanTransfer.php?&keyword={$keyword}>| Transfer1 </a>\n <a target=_blank href=/penggajian/pages/lampiran/LaporanTransfer2.php?&keyword={$keyword}>| Transfer2 </a>\n <a target=_blank href=/penggajian/pages/lampiran/LaporanCash.php?&keyword={$keyword}>| Cash1 </a>\n <a target=_blank href=/penggajian/pages/lampiran/LaporanCash2.php?&keyword={$keyword}>| Cash2 </a>\n <a target=_blank href=/penggajian/pages/lampiran/LaporanTHR.php?&keyword={$keyword}>| Laporan THR </a>\n <a target=_blank href=/penggajian/pages/lampiran/LaporanTHR2.php?&keyword={$keyword}>| Laporan THR2 </a>";
}
?>
</div>
</div>
</div>
$hasil = bukaquery($_sql);
$jumlah = mysql_num_rows($hasil);
if (mysql_num_rows($hasil) != 0) {
echo "<table width='600px' border='0' align='center' cellpadding='0' cellspacing='0' class='tbl_form'>\n <tr class='head'>\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Proses</strong></font></div></td>\n <td width='170px'><div align='center'><font size='2' face='Verdana'><strong>Nama Tindakan</strong></font></div></td>\n <td width='150px'><div align='center'><font size='2' face='Verdana'><strong>JM Tindakan</strong></font></div></td>\n <td width='150px'><div align='center'><font size='2' face='Verdana'><strong>Jns.Tindakan</strong></font></div></td>\n </tr>";
while ($baris = mysql_fetch_array($hasil)) {
echo "<tr class='isi'>\n <td>\n <center>\n\t\t\t\t\t <a href=?act=DetailTindakanRj&action=UBAH&id=" . $baris[0] . "&nama=" . str_replace(" ", "_", $baris[1]) . "&jm=" . $baris[2] . "&jns=" . str_replace(" ", "_", $baris[3]) . ">[edit]</a>";
?>
<a href="?act=DetailTindakanRj&action=HAPUS&id=<?php
print $baris[0];
?>
" onClick="if (!confirm('Anda yakin menghapus data master tindakan <?php
print $baris[1];
?>
?')) return false;">[hapus]</a>
<?php
echo "</center>\n </td>\n <td>{$baris['1']}</td>\n <td>" . formatDuit($baris[2]) . "</td>\n <td>{$baris['3']}</td>\n </tr>";
}
echo "</table>";
} else {
echo "<b>Data master tindakan masih kosong !</b>";
}
?>
</div>
</form>
<?php
if ($_GET['action'] == "HAPUS") {
Hapus(" master_tindakan ", " id ='" . $_GET['id'] . "' ", "?act=DetailTindakanRj&action=TAMBAH&nama={$nama}");
}
if (mysql_num_rows($hasil) != 0) {
$hasil1 = bukaquery("SELECT id,nama,jm from master_tindakan ORDER BY nama ASC ");
$jumlah1 = mysql_num_rows($hasil1);
$telpri = $baris25[5];
}
$ttltelpri = $ttltelpri + $telpri;
if (empty($baris25[6])) {
$pajak = 0;
} else {
$pajak = $baris25[6];
}
$ttlpajak = $ttlpajak + $pajak;
if (empty($baris25[7])) {
$pribadi = 0;
} else {
$pribadi = $baris25[7];
}
$ttlpribadi = $ttlpribadi + $pribadi;
if (empty($baris25[8])) {
$lain = 0 + $alpha;
} else {
$lain = $baris25[8] + $alpha;
}
$ttllain = $ttllain + $lain;
$ttlditerima = $ttlgaji - ($jamsostek + $dansos + $simwajib + $angkop + $angla + $telpri + $pajak + $pribadi + $lain);
$ttlttlditerima = $ttlttlditerima + $ttlditerima;
echo "\n <TD><font size='2' color='green'><i>" . formatDuit($ttlditerima) . "</i></font> </TD>\n </tr>";
}
$ttlttlindex = $ttlindexjaga + $ttltotal;
echo "<tr class='head'>\n <td COLSPAN='4'><div align='right'>Total : </div></td>\n <TD><font size='2' color='green'><i>" . formatDuit($ttlttlditerima) . "</i></font> </TD>\n </tr>\n </table>";
}
?>
</body>
</html>
$gapok = $gapokgp;
if ($masker < 1 && $status == "CK" || $masker < 1 && $status == "FT") {
$gapok = $masker * $gapokgp;
}
} else {
if ($status == "PT") {
$_sqlgp = "SELECT `gapok1`, `gapok2`, `gapok3`\n from pendidikan where tingkat like '%" . substr($pendidikan, 0, 7) . "%' order by gapok1 desc limit 1 ";
$hasilgp = bukaquery($_sqlgp);
$barisgp = mysql_fetch_row($hasilgp);
$gapokgp = 0;
if ($masker < 1) {
$gapokgp = $barisgp[0];
} else {
if ($masker >= 1 && $masker < 3) {
$gapokgp = $barisgp[1];
} else {
if ($masker >= 3) {
$gapokgp = $barisgp[2];
}
}
}
$gapok = $nmasuk / $wajibmasuk * $gapokgp;
if ($masker < 1) {
$gapok = $masker / 12 * ($nmasuk / $wajibmasuk) * $gapokgp;
}
}
}
echo "<table width=300px border='0' align='left' bgcolor='#FFFFFF' border='0' align='center' cellpadding='0' cellspacing='0' class='tbl_form'>\n <caption><center><font color='777777' size='2' face='Arial'>RSKIA SADEWA</font> <br>\n <font color='777777' size='1' face='Arial'><b>Yayasan Pelayanan Kesehatan Prima SEMAR<br> \n Jl.Babarsari TB 16 No.13 Sleman Yogyakarta 55281<br> \n Telp 0274-489118, Fax 0274-485903<br/><br/><br/><br/></b></font></center></caption>\n <tr class='isi6'>\n <td width='30%'>NIK</td>\n <td>:</td>\n <td width='70%'>{$nik}</td> \n </tr>\n <tr class='isi6'>\n <td width='30%'>Nama</td>\n <td>:</td>\n <td width='70%'>{$nama}</td> \n </tr>\n <tr class='isi6'>\n <td width='30%'>Status</td>\n <td>:</td>\n <td width='70%'>{$data['6']}</td> \n </tr>\n <tr class='isi6'>\n <td width='30%'>Departemen</td>\n <td>:</td>\n <td width='70%'>{$data['7']}</td> \n </tr>\n <tr class='isi6'>\n <td width='30%'>THR</td>\n <td>:</td>\n <td width='70%'>" . formatDuit($gapok) . "</td> \n </tr>\n <tr class='isi6'>\n <td width='30%'>Terbilang</td>\n <td>:</td>\n <td width='70%'>" . Terbilang($gapok) . " rupiah</td> \n </tr>\n \n <TR class='isi6'>\n <TD width='130px'><center> </center></TD>\n\t\t <td width='3px'> </td>\n\t\t <td width='140px'><center> </center></td>\n\t </TR>\n <TR class='isi6'>\n <TD width='130px'><center> </center></TD>\n\t\t <td width='3px'> </td>\n\t\t <td width='140px'><center> </center></td>\n\t </TR>\n <TR class='isi6'>\n <TD width='130px'><center> </center></TD>\n\t\t <td width='3px'> </td>\n\t\t <td width='140px'><center> </center></td>\n\t </TR>\n <TR class='isi6'>\n <TD width='130px'><center>Penerima</center></TD>\n\t\t <td width='3px'> </td>\n\t\t <td width='140px'><center>Pengelola</center></td>\n\t </TR>\n <TR class='isi6'>\n <TD width='130px'><center> </center></TD>\n\t\t <td width='3px'> </td>\n\t\t <td width='140px'><center> </center></td>\n\t </TR>\n <TR class='isi6'>\n <TD width='130px'><center> </center></TD>\n\t\t <td width='3px'> </td>\n\t\t <td width='140px'><center> </center></td>\n\t </TR>\n <TR class='isi6'>\n <TD width='130px'><center> </center></TD>\n\t\t <td width='3px'> </td>\n\t\t <td width='140px'><center> </center></td>\n\t </TR> \n <TR class='isi6'>\n <TD colspan=3></TD>\n </TR><TR class='isi6'>\n <TD colspan=3></TD>\n </TR>\n <TR class='isi6'>\n <TD width='130px'><center>( {$nama} )</center></TD>\n\t\t <td width='3px'> </td>\n\t\t <td width='140px'><center>( dr Lily T S Siagian )</center></td>\n </TR>\n <TR class='isi6'>\n <TD width='130px'><center> </center></TD>\n\t\t <td width='3px'> </td>\n\t\t <td width='140px'><center> </center></td>\n\t </TR> \n \n <TR class='isi6'>\n <TD width='130px'><center> </center></TD>\n\t\t <td width='3px'> </td>\n\t\t <td width='140px'><center> </center></td>\n\t </TR>\n \n <TR class='isi6'>\n <TD width='130px'><center> </center></TD>\n\t\t <td width='3px'> </td>\n\t\t <td width='140px'><center> </center></td>\n\t </TR>\n \n <TR class='isi6'>\n <TD colspan=3><center>\n <font size='2px' face='Arial' color='777777'><i><b>Selamat Hari Raya Idul Fitri<br/></b></i></font>\n <font size='1px' face='Arial' color='777777'><i><b>Mohon Maaf Lahir dan Batin<br/>Semoga Berhasil Menjadi Insan Yang Bertaqwa<br/></b></i></font>\n <font size='2px' face='Arial' color='777777'><i><b>Salam Sukses!</b></i></font></center></TD>\n </TR>\n <TR class='isi6'>\n <TD width='130px'><center> </center></TD>\n\t\t <td width='3px'> </td>\n\t\t <td width='140px'><center> </center></td>\n\t </TR>\n <TR class='isi6'>\n <TD width='130px'><center> </center></TD>\n\t\t <td width='3px'> </td>\n\t\t <td width='140px'><center> </center></td>\n\t </TR>\n <TR class='isi6'>\n <TD colspan=3><center><font size='1px' face='Arial' color='777777'><i><b>..Terima kasih atas kerjasamanya <br>dalam memberikan pelayanan yang berkualitas..</b></i></font></center></TD>\n </TR>\n </table>";
?>
</body>
</html>
}
echo " </a>\r\n\t\t\t\t</td>\r\n <td><a href=?act=InputTindakanDokter&action=TAMBAH&id={$baris['0']}>" . formatDuit($baris[5]) . "</a></td>\r\n </tr>";
}
echo "</table>";
} else {
echo "<b>Data keanggotaan masih kosong !</b>";
}
?>
</div>
</form>
<?php
if (mysql_num_rows($hasil) != 0) {
$hasil1 = bukaquery("SELECT pegawai.id,pegawai.nik,pegawai.nama,\r\n\t\t pegawai.departemen,sum(tindakan.jmlh),sum(tindakan.jm)\r\n FROM tindakan right OUTER JOIN pegawai\r\n\t\t\t\tON tindakan.id=pegawai.id and tgl like '%" . $tahun . "-" . $bulan . "%'\r\n\t\t\t\twhere pegawai.nik like '%" . $keyword . "%' or \r\n\t\t\t\tpegawai.nama like '%" . $keyword . "%' or\r\n\t\t\t\tpegawai.departemen like '%" . $keyword . "%' \r\n\t\t\t\tgroup by pegawai.id order by pegawai.id ASC");
$jumlah1 = mysql_num_rows($hasil1);
$i = $jumlah1 / 19;
$i = ceil($i);
echo "Data : {$jumlah}, Ttl.JM : " . formatDuit($ttljm) . " <a target=_blank href=/penggajian/pages/tindakan/laporantindakandokter.php?&keyword={$keyword}>| Laporan |</a> ";
}
?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
}
echo " </a>\r\n\t\t\t\t</td>\r\n <td><a href=?act=InputRj&action=TAMBAH&id={$baris['0']}>" . formatDuit($baris[5]) . "</a></td>\r\n </tr>";
}
echo "</table>";
} else {
echo "<b>Data rawat jalan masih kosong !</b>";
}
?>
</div>
</form>
<?php
if (mysql_num_rows($hasil) != 0) {
$hasil1 = bukaquery("SELECT pegawai.id,pegawai.nik,pegawai.nama,\r\n\t\t pegawai.departemen,sum(rawatjalan.jmlh),sum(rawatjalan.jm)\r\n FROM rawatjalan right OUTER JOIN pegawai\r\n\t\t\t\tON rawatjalan.id=pegawai.id and tgl like '%" . $tahun . "-" . $bulan . "%'\r\n\t\t\t\twhere pegawai.nik like '%" . $keyword . "%' or \r\n\t\t\t\tpegawai.nama like '%" . $keyword . "%' or\r\n\t\t\t\tpegawai.departemen like '%" . $keyword . "%' \r\n\t\t\t\tgroup by pegawai.id order by pegawai.id ASC");
$jumlah1 = mysql_num_rows($hasil1);
$i = $jumlah1 / 19;
$i = ceil($i);
echo "Data : {$jumlah}, Ttl.JM : " . formatDuit($ttljm) . " <a target=_blank href=/penggajian/pages/rawat/laporanrj.php?&keyword={$keyword}>| Laporan |</a> ";
}
?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
