cari dokter
<link rel="stylesheet" type="text/css" href="styles/tabel.css">
<h2 align="center">DATA DOKTER</h2>
<table width="1000px" border="0" align="center" >
<tr>
<td><a href="index.php?page=form_dokter">
<input type="button" name="button" id="button" value="TAMBAH">
</a></td>
<td align="right"></td>
</tr>
</table>
<table width="1000px" align="center">
<tr bgcolor="#00FF00">
<th width="106" align="left">Kode Dokter</th>
<th width="275" align="left">Nama Dokter</th>
<th width="499" align="left">Nama Poli</th>
<th width="100" colspan="2" align="center">Aksi</th>
</tr>
</table>
<div style="overflow: auto;height: 300px;">
<table width="1000px" align="center" class="scroll">
<?php
$carinya=$_POST['cari'];
$menurut=$_POST['pilih']; // menampung pilihan yang kita cari
if($menurut=="Kode Dokter"){
$sqlTampil = mysql_query("SELECT a.KODEDOKTER,a.NMDOKTER,b.NAMAPOLI FROM dokter a, poliklinik b where a.KODEDOKTER like '%$carinya%' AND a.KODEPOLI=b.KODEPOLI ORDER BY a.KODEDOKTER ASC");
}else{
$sqlTampil = mysql_query("SELECT a.KODEDOKTER,a.NMDOKTER,b.NAMAPOLI FROM dokter a, poliklinik b where a.NMDOKTER like '%$carinya%' AND a.KODEPOLI=b.KODEPOLI ORDER BY a.KODEDOKTER ASC");
}
while ($data = mysql_fetch_array($sqlTampil)) {
?>
<tr>
<td width="106"><?php echo $data['KODEDOKTER'];?></td>
<td width="275"><?php echo $data['NMDOKTER'];?></td>
<td width="501"><?php echo $data['NAMAPOLI'];?></td>
<td width="46" ><a href="index.php?page=form_edit_dokter&id=<?php echo $data['KODEDOKTER'];?>"><img src="../tambah.png" alt="" width="29" height="32"></td>
<td width="48" ><a href="index.php?page=hapus_dokter&id=<?php echo $data['KODEDOKTER'];?>" onclick="return confirm('ANDA YAKIN INGIN MENGHAPUS DATA DOKTER INI ... ?')"><img src="../hapus.png" alt="" width="29" height="32"></td>
</tr>
<?php
}
?>
</table>
</div>
cari jadwal praktek
<link rel="stylesheet" type="text/css" href="styles/tabel.css">
<h2 align="center">DATA JADWAL PRAKTEK</h2>
<table width="1000px" border="0" align="center" >
<tr>
<td><a href="index.php?page=form_jadwal_praktek">
<input type="button" name="button" id="button" value="TAMBAH">
</a></td>
<td align="right"></td>
</tr>
</table>
<table width="1000px" align="center">
<tr bgcolor="#00FF00">
<th width="100" align="left">Kode Jadwal</th>
<th width="229" align="left">Nama Dokter</th>
<th width="234" align="left">Hari</th>
<th width="157" align="left">Jam Mulai</th>
<th width="167" align="left">Jam Selesai</th>
<th width="85" colspan="2" align="center">Aksi</th>
</tr>
</table>
<div style="overflow: auto;height: 300px;">
<table width="1000px" align="center" class="scroll">
<?php
$carinya=$_POST['cari'];
$sqlTampil = mysql_query("select a.KODEJADWAL,b.NMDOKTER,a.HARI,a.JAMMULAI,a.JAMSELESAI FROM jadwalpraktek a, dokter b where NMDOKTER like '%$carinya%' OR HARI like '%$carinya%' AND a.KODEDOKTER=b.KODEDOKTER ORDER BY a.KODEJADWAL ASC");
while ($data = mysql_fetch_array($sqlTampil)) {
?>
<tr>
<td width="101"><?php echo $data['KODEJADWAL'];?></td>
<td width="228"><?php echo $data['NMDOKTER'];?></td>
<td width="233"><?php echo $data['HARI'];?></td>
<td width="157"><?php echo $data['JAMMULAI'];?></td>
<td width="169"><?php echo $data['JAMSELESAI'];?></td>
<td width="38" ><a href="index.php?page=form_edit_jadwal_praktek&id=<?php echo $data['KODEJADWAL'];?>"><img src="../tambah.png" alt="" width="32" height="36"></td>
<td width="42" ><a href="index.php?page=hapus_jadwal_praktek&id=<?php echo $data['KODEJADWAL'];?>" onclick="return confirm('ANDA YAKIN INGIN MENGHAPUS DATA JADWAL PRAKTEK INI ... ?')"><img src="../hapus.png" alt="" width="28" height="41"></td>
</tr>
<?php
}
?>
</table>
</div>
cari jenis biaya
<link rel="stylesheet" type="text/css" href="styles/tabel.css">
<h2 align="center">DATA JENIS BIAYA</h2>
<table width="1000px" border="0" align="center" >
<tr>
<td><a href="index.php?page=form_jenis_biaya">
<input type="button" name="button" id="button" value="TAMBAH">
</a></td>
<td align="right"></td>
</tr>
</table>
<table width="1000px" align="center">
<tr>
<th width="125" align="left" bgcolor="#00FF00">ID JENIS BIAYA</th>
<th width="256" align="left" bgcolor="#00FF00">Nama Biaya</th>
<th width="499" align="left" bgcolor="#00FF00">Tarif</th>
<th width="100" colspan="2" align="center" bgcolor="#00FF00">Aksi</th>
</tr>
</table>
<div style="overflow: auto;height: 300px;">
<table width="1000px" align="center" class="scroll">
<?php
$carinya=$_POST['cari'];
$sqlTampil = mysql_query("SELECT * FROM jenisbiaya where IDJENISBIAYA like '%$carinya%' OR NAMABIAYA like '%$carinya%' ORDER BY IDJENISBIAYA ASC");
while ($data = mysql_fetch_array($sqlTampil)) {
?>
<tr>
<td width="126" height="35"><?php echo $data['IDJENISBIAYA'];?></td>
<td width="255"><?php echo $data['NAMABIAYA'];?></td>
<td width="501"><?php echo $data['TARIF'];?></td>
<td width="46" ><a href="index.php?page=form_edit_jenis_biaya&id=<?php echo $data['IDJENISBIAYA'];?>"><img src="../tambah.png" alt="" width="35" height="39" /></td>
<td width="48" ><a href="index.php?page=hapus_jenis_biaya&id=<?php echo $data['IDJENISBIAYA'];?>" onclick="return confirm('ANDA YAKIN INGIN MENGHAPUS DATA PEGAWAI INI ... ?')"><img src="../hapus.png" alt="" width="30" height="40" /></td>
</tr>
<?php
}
?>
</table>
</div>
</body>
</html>
cari login
<link rel="stylesheet" type="text/css" href="styles/tabel.css">
<h2 align="center">DATA LOGIN</h2>
<table width="1000px" border="0" align="center" >
<tr>
<td><a href="index.php?page=form_login">
<input type="button" name="button" id="button" value="TAMBAH">
</a></td>
<td align="right"></td>
</tr>
</table>
<table width="1000px" align="center">
<tr>
<th width="105" align="left" bgcolor="#00FF00">NIP</th>
<th width="274" align="left" bgcolor="#00FF00">Username</th>
<th width="156" align="left" bgcolor="#00FF00">Password</th>
<th width="168" align="left" bgcolor="#00FF00">Typeuser</th>
<th width="102" colspan="2" align="center" bgcolor="#00FF00">Aksi</th>
</tr>
</table>
<div style="overflow: auto;height: 300px;">
<table width="1000px" align="center" class="scroll">
<?php
$sqlTampil = mysql_query("SELECT NIP, USERNAME, PASSWORD, TYPEUSER ORDER BY NIP ASC");
while ($data = mysql_fetch_array($sqlTampil)) {
?>
<tr>
<td width="126"><?php echo $data['NIP'];?></td>
<td width="326"><?php echo $data['USERNAME'];?></td>
<td width="193"><?php echo $data['PASSWORD'];?></td>
<td width="208"><?php echo $data['TYPEUSER'];?></td>
<td width="49" ><a href="index.php?page=form_edit_login&id=<?php echo $data['NIP'];?>"><img src="../tambah.png" alt="" width="36" height="40"></td>
<td width="70" ><a href="index.php?page=hapus_login&id=<?php echo $data['NIP'];?>" onclick="return confirm('ANDA YAKIN INGIN MENGHAPUS DATA LOGIN INI ... ?')"><img src="../hapus.png" alt="" width="31" height="38"></td>
</tr>
<?php
}
?>
</table>
</div>
cari obat
<link rel="stylesheet" type="text/css" href="styles/tabel.css">
<h2 align="center">DATA OBAT</h2>
</table>
<table width="1000px" border="1" align="center">
<tr bgcolor="#00FF00">
<th width="105" align="left" bgcolor="#999999"><div align="center">Kode Obat</div></th>
<th width="274" align="left" bgcolor="#999999"><div align="center">Nama Obat</div></th>
<th width="156" align="left" bgcolor="#999999"><div align="center">Merk</div></th>
<th width="168" align="left" bgcolor="#999999"><div align="center">Satuan</div></th>
<th width="169" align="left" bgcolor="#999999"><div align="center">Harga Jual</div></th>
<th width="102" colspan="2" align="center" bgcolor="#999999"><div align="center">Aksi</div></th>
</tr>
</table>
<div style="overflow: auto;height: 300px;">
<table width="1000px" align="center" class="scroll">
<?php
$carinya=$_POST['cari'];
$sqlTampil = mysql_query("SELECT * FROM obat where KODEOBAT like '%$carinya%' OR NMOBAT like '%$carinya%' ORDER BY KODEOBAT ASC");
while ($data = mysql_fetch_array($sqlTampil)) {
?>
<tr>
<td width="104"><?php echo $data['KODEOBAT'];?></td>
<td width="270"><?php echo $data['NMOBAT'];?></td>
<td width="160"><?php echo $data['MERK'];?></td>
<td width="166"><?php echo $data['SATUAN'];?></td>
<td width="167"><?php echo $data['HARGAJUAL'];?></td>
<td width="46" ><a href="index.php?page=form_edit_obat&id=<?php echo $data['KODEOBAT'];?>"><img src="../tambah.png" alt="" width="29" height="43"></td>
<td width="55" ><a href="index.php?page=hapus_obat&id=<?php echo $data['KODEOBAT'];?>" onclick="return confirm('ANDA YAKIN INGIN MENGHAPUS DATA OBAT INI ... ?')"><img src="../hapus.png" alt="" width="31" height="44"></td>
</tr>
<?php
}
?>
</table>
</div>
cari pasien
<link rel="stylesheet" type="text/css" href="styles/tabel.css">
<h2 align="center">DATA PASIEN</h2>
</table>
<table width="975" border="1" align="center">
<tr>
<th width="163" align="left" bgcolor="#999999"><div align="center">No Pasien</div></th>
<th width="387" align="left" bgcolor="#999999"><div align="center">Nama Pasien</div></th>
<th width="350" align="left" bgcolor="#999999"><div align="center">Alamat Pasien</div></th>
<th width="47" colspan="2" align="center" bgcolor="#999999"><div align="center">Aksi</div></th>
</tr>
</table>
<div style="overflow: auto;height: 300px;">
<table width="978" border="1" align="center" class="scroll">
<?php
$carinya=$_POST['cari'];
$sqlTampil = mysql_query("SELECT * FROM pasien where NOPASIEN like '%$carinya%' OR NAMAPAS like '%$carinya%'ORDER BY NOPASIEN ASC");
while ($data = mysql_fetch_array($sqlTampil)) {
?>
<tr>
<td width="164" bgcolor="#CCCCCC"><div align="center"><?php echo $data['NOPASIEN'];?></div></td>
<td width="388" bgcolor="#CCCCCC"><div align="center"><?php echo $data['NAMAPAS'];?></div></td>
<td width="350" bgcolor="#CCCCCC"><div align="center"><?php echo $data['ALMPAS'];?></div></td>
<td width="48" bgcolor="#CCCCCC" ><a href="index.php?page=hapus_pasien&id=<?php echo $data['NOPASIEN'];?>" onclick="return confirm('ANDA YAKIN INGIN MENGHAPUS DATA PASIEN INI ... ?')">
<div align="center"><img src="../icon/hapus.jpg" alt="" width="30" height="30"></div></td>
</tr>
<?php
}
?>
</table>
</div>
cari pegawai
<link rel="stylesheet" type="text/css" href="styles/tabel.css">
<h2 align="center">DATA PEGAWAI</h2>
</table>
<table width="1000px" border="1" align="center">
<tr>
<th width="138" align="left" bgcolor="#999999"><div align="center">NIP</div></th>
<th width="382" align="left" bgcolor="#999999"><div align="center">Nama Pegawai</div></th>
<th width="407" align="left" bgcolor="#999999"><div align="center">Alamat Pegawai</div></th>
<th width="45" colspan="2" align="center" bgcolor="#999999"><div align="center">Aksi</div></th>
</tr>
</table>
<div style="overflow: auto;height: 300px;">
<table width="1000" border="1" align="center" class="scroll">
<?php
$carinya=$_POST['cari'];
$sqlTampil = mysql_query("SELECT * FROM pegawai where NIP like '%$carinya%' OR NAMAPEG like '%$carinya%' ORDER BY NIP ASC");
while ($data = mysql_fetch_array($sqlTampil)) {
?>
<tr>
<td width="138" bgcolor="#CCCCCC"><div align="center"><?php echo $data['NIP'];?></div></td>
<td width="382" bgcolor="#CCCCCC"><div align="center"><?php echo $data['NAMAPEG'];?></div></td>
<td width="407" bgcolor="#CCCCCC"><div align="center"><?php echo $data['ALMPEG'];?></div></td>
<td width="45" bgcolor="#CCCCCC" ><a href="index.php?page=hapus_pegawai&id=<?php echo $data['NIP'];?>" onclick="return confirm('ANDA YAKIN INGIN MENGHAPUS DATA PEGAWAI INI ... ?')">
<div align="center"><img src="../icon/hapus.jpg" alt="" width="30" height="30"></div></td>
</tr>
<?php
}
?>
</table>
</div>
cari pemeriksaan
<link rel="stylesheet" type="text/css" href="styles/tabel.css">
<h2 align="center">DATA PEMERIKSAAN</h2>
</table>
<table width="1000px" border="1" align="center">
<tr>
<th width="169" height="21" align="left" bgcolor="#999999"><div align="center">No Pemeriksaan</div></th>
<th width="232" align="left" bgcolor="#999999"><div align="center">Nama Pasien</div></th>
<th width="257" align="left" bgcolor="#999999"><div align="center">Nama Dokter</div></th>
<th width="266" align="left" bgcolor="#999999"><div align="center">Nama Poli</div></th>
<th width="42" colspan="2" align="center" bgcolor="#999999"><div align="center">Aksi</div></th>
</tr>
</table>
<div style="overflow: auto;height: 300px;">
<table width="999" border="1" align="center" class="scroll">
<?php
$carinya=$_POST['cari'];
$sqlTampil = mysql_query("SELECT a.NOPEMERIKSAAN,c.NAMAPAS,e.NMDOKTER,f.NAMAPOLI FROM pemeriksaan a,pendaftaran b,pasien c,jadwalpraktek d, dokter e,poliklinik f WHERE a.NOPEMERIKSAAN like '%$carinya%' OR c.NAMAPAS like '%$carinya%' and b.NOPASIEN=c.NOPASIEN and b.KODEJADWAL=d.KODEJADWAL and d.KODEDOKTER=e.KODEDOKTER and e.KODEPOLI=f.KODEPOLI ORDER BY a.NOPEMERIKSAAN ASC");
while ($data = mysql_fetch_array($sqlTampil)) {
?>
<tr>
<td width="167" bgcolor="#CCCCCC"><div align="center"><?php echo $data['NOPEMERIKSAAN'];?></div></td>
<td width="233" bgcolor="#CCCCCC"><div align="center"><?php echo $data['NAMAPAS'];?></div></td>
<td width="257" bgcolor="#CCCCCC"><div align="center"><?php echo $data['NMDOKTER'];?></div></td>
<td width="266" bgcolor="#CCCCCC"><div align="center"><?php echo $data['NAMAPOLI'];?></div></td>
<td width="42" bgcolor="#CCCCCC" ><a href="index.php?page=hapus_pemeriksaan&id=<?php echo $data['NOPEMERIKSAAN'];?>" onclick="return confirm('ANDA YAKIN INGIN MENGHAPUS DATA PEMERIKSAAN INI ... ?')">
<div align="center"><img src="../icon/hapus.jpg" alt="" width="30" height="30"></div></td>
</tr>
<?php
}
?>
</table>
</div>
cari pendaftaran
<link rel="stylesheet" type="text/css" href="styles/tabel.css">
<h2 align="center">DATA PENDAFTARAN</h2>
<table width="1000px" border="1" align="center"><tr bgcolor="#00FF00">
<th width="147" align="left" bgcolor="#999999"><div align="center">No Pendaftaran</div></th>
<th width="209" align="left" bgcolor="#999999"><div align="center">Nama Pasien</div></th>
<th width="217" align="left" bgcolor="#999999"><div align="center">Nama Pegawai</div></th>
<th width="150" align="left" bgcolor="#999999"><div align="center">Kode Jadwal</div></th>
<th width="186" align="left" bgcolor="#999999"><div align="center">Tgl Pendaftaran</div></th>
<th width="51" colspan="2" align="center" bgcolor="#999999"><div align="center">Aksi</div></th>
</tr>
</table>
<div style="overflow: auto;height: 300px;">
<table width="1000px" border="1" align="center" class="scroll">
<?php
$carinya=$_POST['cari'];
$sqlTampil = mysql_query("select a.NOPENDAFTARAN,b.NAMAPAS,c.NAMAPEG,a.KODEJADWAL,a.TGLPENDAFTARAN FROM pendaftaran a, pasien b,pegawai c, jadwalpraktek d where a.NOPENDAFTARAN like '%$carinya%' OR b.NAMAPAS like '%$carinya%' and a.NOPASIEN=b.NOPASIEN and a.NIP=c.NIP and a.KODEJADWAL=d.KODEJADWAL ORDER BY a.NOPENDAFTARAN ASC");
while ($data = mysql_fetch_array($sqlTampil)) {
?>
<tr>
<td width="147" height="37" bgcolor="#CCCCCC"><div align="center"><?php echo $data['NOPENDAFTARAN'];?></div></td>
<td width="210" bgcolor="#CCCCCC"><div align="center"><?php echo $data['NAMAPAS'];?></div></td>
<td width="216" bgcolor="#CCCCCC"><div align="center"><?php echo $data['NAMAPEG'];?></div></td>
<td width="150" bgcolor="#CCCCCC"><div align="center"><?php echo $data['KODEJADWAL'];?></div></td>
<td width="187" bgcolor="#CCCCCC"><div align="center"><?php echo $data['TGLPENDAFTARAN'];?></div></td>
<td width="50" bgcolor="#CCCCCC" ><a href="index.php?page=form_edit_pendaftaran&id=<?php echo $data['NOPENDAFTARAN'];?>"><a href="index.php?page=hapus_pendaftaran&id=<?php echo $data['NOPENDAFTARAN'];?>" onclick="return confirm('ANDA YAKIN INGIN MENGHAPUS DATA PENDAFTARAN INI ... ?')">
<div align="center"><img src="../icon/hapus.jpg" alt="" width="30" height="30"></div></td>
</tr>
<?php
}
?>
</table>
</div>
cari poliklinik
<link rel="stylesheet" type="text/css" href="styles/tabel.css">
<h2 align="center">DATA POLIKLINIK</h2>
<table width="1000px" border="0" align="center" >
<tr>
<td><a href="index.php?page=form_poliklinik">
<input type="button" name="button" id="button" value="TAMBAH">
</a></td>
<td align="right"></td>
</tr>
</table>
<table width="1000px" align="center">
<tr>
<th width="216" align="left" bgcolor="#00FF00">Kode Poli</th>
<th width="611" align="left" bgcolor="#00FF00">Nama Poli</th>
<th width="157" colspan="2" align="center" bgcolor="#00FF00">Aksi</th>
</tr>
</table>
<div style="overflow: auto;height: 300px;">
<table width="995" align="center" class="scroll">
<?php
$carinya=$_POST['cari'];
$sqlTampil = mysql_query("SELECT * FROM poliklinik where KODEPOLI like '%$carinya%' OR NAMAPOLI like '%$carinya%' ORDER BY KODEPOLI ASC");
while ($data = mysql_fetch_array($sqlTampil)) {
?>
<tr>
<td width="211" height="37"><?php echo $data['KODEPOLI'];?></td>
<td width="631"><?php echo $data['NAMAPOLI'];?></td>
<td width="72" ><a href="index.php?page=form_edit_poliklinik&id=<?php echo $data['KODEPOLI'];?>"><img src="../tambah.png" width="38" height="38"></td>
<td width="61" ><a href="index.php?page=hapus_poliklinik&id=<?php echo $data['KODEPOLI'];?>" onclick="return confirm('ANDA YAKIN INGIN MENGHAPUS DATA OBAT INI ... ?')"><img src="../hapus.png" width="32" height="40"></td>
</tr>
<?php
}
?>
</table>
</div>
cari resep
<link rel="stylesheet" type="text/css" href="styles/tabel.css">
<h2 align="center">DATA RESEP</h2>
<table width="1000px" border="1" align="center" >
<tr>
<th width="229" height="21" align="left" bgcolor="#999999"><div align="center">No Resep</div></th>
<th width="415" align="left" bgcolor="#999999"><div align="center">Nama Pasien</div></th>
<th width="285" align="left" bgcolor="#999999"><div align="center">Tgl Pendaftaran</div></th>
<th width="43" colspan="2" align="center" bgcolor="#999999"><div align="center">Aksi</div></th>
</tr>
</table>
<div style="overflow: auto;height: 300px;">
<table width="1000px" border="1" align="center" class="scroll">
<?php
$carinya=$_POST['cari'];
$sqlTampil = mysql_query("select * FROM resep a, pemeriksaan b,pendaftaran c, pasien d where a.NORESEP like '%$carinya%' OR d.NAMAPAS like '%$carinya%' and a.NOPEMERIKSAAN=b.NOPEMERIKSAAN and b.NOPENDAFTARAN=c.NOPENDAFTARAN and c.NOPASIEN=d.NOPASIEN ORDER BY a.NORESEP ASC");
while ($data = mysql_fetch_array($sqlTampil)) {
?>
<tr>
<td width="229" bgcolor="#CCCCCC"><div align="center"><?php echo $data['NORESEP'];?></div></td>
<td width="415" bgcolor="#CCCCCC"><div align="center"><?php echo $data['NAMAPAS'];?></div></td>
<td width="286" bgcolor="#CCCCCC"><div align="center"><?php echo IndonesiaTgl($data['TGLPENDAFTARAN']);?></div></td>
<td width="42" bgcolor="#CCCCCC" ><div align="center"><a href="index.php?page=hapus_resep&id=<?php echo $data['NORESEP'];?>" onclick="return confirm('ANDA YAKIN INGIN MENGHAPUS DATA RESEP INI ... ?')"></a><a href="index.php?page=hapus_resep&id=<?php echo $data['NORESEP'];?>" onclick="return confirm('ANDA YAKIN INGIN MENGHAPUS DATA RESEP INI ... ?')"><img src="../icon/hapus.jpg" alt="" width="30" height="30" /></a></div></td>
</tr>
<?php
}
?>
</table>
</div>
