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