Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.
Binary file not shown.

Large diffs are not rendered by default.

BIN +12.7 KB (100%) dist/SIMRSKhanza.jar
Binary file not shown.

Large diffs are not rendered by default.

@@ -3,9 +3,7 @@
<editor-bookmarks xmlns="http://www.netbeans.org/ns/editor-bookmarks/2" lastBookmarkId="1"/>
<open-files xmlns="http://www.netbeans.org/ns/projectui-open-files/2">
<group>
<file>file:/media/khanzamedia/Data/Source%20Java/SIMRSKhanza/src/setting/DlgUser.java</file>
<file>file:/media/khanzamedia/Data/Source%20Java/SIMRSKhanza/src/inventory/DlgCariObat.java</file>
<file>file:/media/khanzamedia/Data/Source%20Java/SIMRSKhanza/src/inventory/DlgCariObat2.java</file>
<file>file:/media/khanzamedia/Data/Source%20Java/SIMRSKhanza/src/keuangan/DlgBilingRalan.java</file>
</group>
</open-files>
</project-private>
BIN +0 Bytes (100%) report/rptSKL2.jasper
Binary file not shown.
BIN +50.9 KB report/rptSKL3.jasper
Binary file not shown.

Large diffs are not rendered by default.

231 sik.sql

Large diffs are not rendered by default.

@@ -180,7 +180,7 @@
}
updateAplicare();
// mengecek data
$cek = mysql_num_rows($sql);
$cek = mysqli_num_rows($sql);
// jika data kurang dari 1
if($cek < 1) {
?>
@@ -191,7 +191,7 @@
} else {

// mengulangi data agar tidak hanya 1 yang tampil
while($data = mysql_fetch_array($sql)) {
while($data = mysqli_fetch_array($sql)) {

?>
<tr>
@@ -21,7 +21,7 @@
require_once('conf/conf.php');
$a="SELECT * FROM poliklinik";
$sql=mysql_query($a);
while($data=mysql_fetch_array($sql)){
while($data=mysqli_fetch_array($sql)){
?>
<option value="<?php echo $data['kd_poli']?>"><?php echo $data['nm_poli']?></option>
<?php
@@ -44,7 +44,7 @@
if(isset($_POST['kd_poli'])){
$sql = "select * from reg_periksa WHERE kd_poli = ".$_POST['kd_poli'];
$q = mysql_query($sql);
while($data = mysql_fetch_array($q)){
while($data = mysqli_fetch_array($q)){
?>
<tr>
<td style="border: none;padding: 4px;"><?php echo $data['no_reg'];?></td>
@@ -59,7 +59,7 @@
}

// mengecek data
$cek = mysql_num_rows($sql);
$cek = mysqli_num_rows($sql);
// jika data kurang dari 1
if($cek < 1) {
?>
@@ -70,7 +70,7 @@
} else {

// mengulangi data agar tidak hanya 1 yang tampil
while($data = mysql_fetch_array($sql)) {
while($data = mysqli_fetch_array($sql)) {

?>
<tr>
@@ -247,7 +247,7 @@ function HapusAll($tabelname) {
function deletegb($sql){
$_sql = $sql;
$hasil = bukaquery($_sql);
$baris = mysql_fetch_row($hasil);
$baris = mysqli_fetch_row($hasil);
$gb = $baris[0];
$hapus=unlink($gb);
}
@@ -325,17 +325,17 @@ function formatRound($duit)
}

function JumlahBaris($result) {
return mysql_num_rows($result);
return mysqli_num_rows($result);
}

function getOne($sql) {
$hasil=bukaquery($sql);
list($result) =mysql_fetch_array($hasil);
list($result) =mysqli_fetch_array($hasil);
return $result;
}

function cekKosong($sql) {
$jum = mysql_num_rows($sql);
$jum = mysqli_num_rows($sql);
if ($jum==0) return true;
else return false;
}
@@ -506,7 +506,7 @@ function loadMenit(){

function autonomer($table,$strawal,$pnj){
$hasil = bukaquery($table);
$s = mysql_num_rows($hasil)+1;
$s = mysqli_num_rows($hasil)+1;
$j = strlen($s);
$s1 = "";
for($i=1;$i<=$pnj-$j;$i++){
@@ -118,7 +118,7 @@
$tes=("select count(status) as jml from kamar where status = 'ISI'") ;
$hasil=bukaquery($tes);

while ($data = mysql_fetch_array ($hasil)){
while ($data = mysqli_fetch_array ($hasil)){
$jml= ($data['jml']);
}
print_r ($jml);
@@ -151,7 +151,7 @@
$tes=("select count(status) as jml from kamar where status = 'KOSONG'") ;
$hasil=bukaquery($tes);

while ($data = mysql_fetch_array ($hasil)){
while ($data = mysqli_fetch_array ($hasil)){
$jml= ($data['jml']);
}
print_r ($jml);
@@ -185,7 +185,7 @@
$tes=("select count(no_rawat) as h from periksa_lab where tgl_periksa='$tgl'") ;
$hasil=bukaquery($tes);

while ($data = mysql_fetch_array ($hasil)){
while ($data = mysqli_fetch_array ($hasil)){
$jml= ($data['h']);
}
print_r ($jml);
@@ -218,7 +218,7 @@
$tes=("select count(no_rawat) as h from periksa_radiologi where tgl_periksa='$ff'") ;
$hasil=bukaquery($tes);

while ($data = mysql_fetch_array ($hasil)){
while ($data = mysqli_fetch_array ($hasil)){
$jml= ($data['h']);
}
print_r ($jml);
@@ -264,7 +264,7 @@
$sql = "select poliklinik.nm_poli, count(*) as jumlah from reg_periksa INNER JOIN poliklinik on reg_periksa.kd_poli=poliklinik.kd_poli WHERE reg_periksa.tgl_registrasi='$date' group by reg_periksa.kd_poli order by count(*) desc ";
$hasil=bukaquery($sql);

while ($data = mysql_fetch_array ($hasil)){
while ($data = mysqli_fetch_array ($hasil)){

$jumlah[]=intval($data['jumlah']);
$poli[]= $data['nm_poli'];
@@ -379,7 +379,7 @@
AND jadwal.kd_poli=poliklinik.kd_poli WHERE hari_kerja = '$namahari'" ;
$hasil=bukaquery($_sql);

while ($data = mysql_fetch_array ($hasil)){
while ($data = mysqli_fetch_array ($hasil)){
echo "<tr>
<td>".$data['nm_dokter']."</b></td>
<td>".$data['nm_poli']."</td>
@@ -410,29 +410,29 @@
$_sql="Select * From bangsal where status='1' and kd_bangsal in(select kd_bangsal from kamar)" ;
$hasil=bukaquery($_sql);

while ($data = mysql_fetch_array ($hasil)){
while ($data = mysqli_fetch_array ($hasil)){
echo "<tr class='isi1' >
<td align='left'>".$data['nm_bangsal']."</td>
<td align='center'>
<font color='blue'>
";
$data2=mysql_fetch_array(bukaquery("select count(kd_bangsal) from kamar where kamar.statusdata='1' and kd_bangsal='".$data['kd_bangsal']."'"));
$data2=mysqli_fetch_array(bukaquery("select count(kd_bangsal) from kamar where kamar.statusdata='1' and kd_bangsal='".$data['kd_bangsal']."'"));
echo $data2[0];
echo "
</font>
</td>
<td align='center'>
<font color='red'>
";
$data2=mysql_fetch_array(bukaquery("select count(kd_bangsal) from kamar where kamar.statusdata='1' and kd_bangsal='".$data['kd_bangsal']."' and status='ISI'"));
$data2=mysqli_fetch_array(bukaquery("select count(kd_bangsal) from kamar where kamar.statusdata='1' and kd_bangsal='".$data['kd_bangsal']."' and status='ISI'"));
echo $data2[0];
echo "
</font>
</td>
<td align='center'>
<font color='#000'>
";
$data2=mysql_fetch_array(bukaquery("select count(kd_bangsal) from kamar where kamar.statusdata='1' and kd_bangsal='".$data['kd_bangsal']."' and status='KOSONG'"));
$data2=mysqli_fetch_array(bukaquery("select count(kd_bangsal) from kamar where kamar.statusdata='1' and kd_bangsal='".$data['kd_bangsal']."' and status='KOSONG'"));
echo $data2[0];
echo "
</font>
@@ -143,7 +143,7 @@
AND jadwal.kd_poli=poliklinik.kd_poli WHERE hari_kerja = '$namahari'" ;
$hasil=bukaquery($_sql);

while ($data = mysql_fetch_array ($hasil)){
while ($data = mysqli_fetch_array ($hasil)){
echo "<tr>
<td><b>".$data['nm_dokter']."</b></td>
<td><b>".$data['nm_poli']."</b></td>
@@ -174,29 +174,29 @@
$_sql="Select * From bangsal where status='1' and kd_bangsal in(select kd_bangsal from kamar)" ;
$hasil=bukaquery($_sql);

while ($data = mysql_fetch_array ($hasil)){
while ($data = mysqli_fetch_array ($hasil)){
echo "<tr class='isi7' >
<td align='left'><b>".$data['nm_bangsal']."</b></td>
<td align='center'>
<font color='gren'>
<b>";
$data2=mysql_fetch_array(bukaquery("select count(kd_bangsal) from kamar where kamar.statusdata='1' and kd_bangsal='".$data['kd_bangsal']."'"));
$data2=mysqli_fetch_array(bukaquery("select count(kd_bangsal) from kamar where kamar.statusdata='1' and kd_bangsal='".$data['kd_bangsal']."'"));
echo $data2[0];
echo "</b>
</font>
</td>
<td align='center'>
<font color='red'>
<b>";
$data2=mysql_fetch_array(bukaquery("select count(kd_bangsal) from kamar where kamar.statusdata='1' and kd_bangsal='".$data['kd_bangsal']."' and status='ISI'"));
$data2=mysqli_fetch_array(bukaquery("select count(kd_bangsal) from kamar where kamar.statusdata='1' and kd_bangsal='".$data['kd_bangsal']."' and status='ISI'"));
echo $data2[0];
echo "</b>
</font>
</td>
<td align='center'>
<font color='#FF8C00'>
<b>";
$data2=mysql_fetch_array(bukaquery("select count(kd_bangsal) from kamar where kamar.statusdata='1' and kd_bangsal='".$data['kd_bangsal']."' and status='KOSONG'"));
$data2=mysqli_fetch_array(bukaquery("select count(kd_bangsal) from kamar where kamar.statusdata='1' and kd_bangsal='".$data['kd_bangsal']."' and status='KOSONG'"));
echo $data2[0];
echo "</b>
</font>
@@ -40,7 +40,7 @@
</object>
</noscript>
<?php
$setting= mysql_fetch_array(bukaquery("select nama_instansi,alamat_instansi,kabupaten,propinsi,kontak,email,logo from setting"));
$setting= mysqli_fetch_array(bukaquery("select nama_instansi,alamat_instansi,kabupaten,propinsi,kontak,email,logo from setting"));
echo "
<table width='100%' align='center' border='0' class='tbl_form' cellspacing='0' cellpadding='0'>
<tr>
@@ -102,7 +102,7 @@
and jadwal.kd_poli=poliklinik.kd_poli where jadwal.hari_kerja='$namahari'" ;
$hasil=bukaquery($_sql);

while ($data = mysql_fetch_array ($hasil)){
while ($data = mysqli_fetch_array ($hasil)){
echo "<tr class='isi7' >
<td align='left'><font size='5' color='#BB00BB' face='Tahoma'>".$data['nm_dokter']."</font></td>
<td align='center'><font size='5' color='gray' face='Tahoma'>".$data['nm_poli']."</font></td>
@@ -134,7 +134,7 @@
$sql = "select poliklinik.nm_poli, count(*) as jumlah from reg_periksa INNER JOIN poliklinik on reg_periksa.kd_poli=poliklinik.kd_poli WHERE reg_periksa.tgl_registrasi='$date' group by reg_periksa.kd_poli order by count(*) desc ";
$hasil=bukaquery($sql);

while ($data = mysql_fetch_array ($hasil)){
while ($data = mysqli_fetch_array ($hasil)){

$jumlah[]=intval($data['jumlah']);
$poli[]= $data['nm_poli'];
@@ -90,7 +90,7 @@ function showDokter()
$hasil = bukaquery($query);

// membuat if untuk masing-masing pilihan poliklinik beserta isi option untuk combobox dokter
while ($data = mysql_fetch_array($hasil))
while ($data = mysqli_fetch_array($hasil))
{
$idPoli = $data['kd_poli'];

@@ -103,7 +103,7 @@ function showDokter()
jadwal.kd_dokter=dokter.kd_dokter and jadwal.kd_poli='$idPoli' and jadwal.hari_kerja LIKE '%$hari%'";
$hasil2 = mysql_query($query2);
$content = "document.getElementById('dokter').innerHTML = \"<select name='kd_dokter' class='form-control'>";
while ($data2 = mysql_fetch_array($hasil2))
while ($data2 = mysqli_fetch_array($hasil2))
{
$content .= "<option value='".$data2['kd_dokter']."'>".$data2['nm_dokter']."</option>";
}
@@ -260,7 +260,7 @@ function showDokter()
else{
echo "<script>alert('Data Ditemukan.. ')</script>";
$rm=mysql_query("select * from pasien where no_rkm_medis='$no_rkm_medis'");
$b=mysql_fetch_array($rm);
$b=mysqli_fetch_array($rm);
$nm_pasien=$b['nm_pasien'];
?>
<form action='tes.php?act=registrasi' name='pilihan' align='center' onsubmit='return validasi_lama(this)' method='post' enctype='multipart/form-data' >
@@ -286,7 +286,7 @@ function showDokter()
<?php $poliklinik="select jadwal.kd_poli,poliklinik.nm_poli,jadwal.jam_mulai,jadwal.jam_selesai from jadwal,poliklinik,dokter where jadwal.kd_poli=poliklinik.kd_poli and
jadwal.kd_dokter=dokter.kd_dokter and hari_kerja LIKE '%$hari%' GROUP BY poliklinik.kd_poli";
$hasil=bukaquery($poliklinik);
while($baris=mysql_fetch_array($hasil)){
while($baris=mysqli_fetch_array($hasil)){
echo "<option value='".$baris['kd_poli']."'>".$baris['nm_poli']." [".$baris['jam_mulai']."-".$baris['jam_selesai']."]</option>";
}?>
</select></td>
@@ -299,7 +299,7 @@ function showDokter()
<option value='' selected >ASKES*</option>";
<?php $askes="select * from penjab where png_jawab LIKE '%umum%' or png_jawab LIKE '%bpjs%' and kd_pj!='2' ";
$hasil=bukaquery($askes);
while($baris=mysql_fetch_array($hasil)){
while($baris=mysqli_fetch_array($hasil)){
echo "<option value='$baris[kd_pj]'>$baris[png_jawab]</option>";
}?>
</select></td>
@@ -45,7 +45,7 @@ function fatal_error($sErrorMessage = '') {

// GET DATA
$query = mysql_query(" SELECT * FROM $sTable WHERE $sIndexColumn = " . intval($_GET['edit']), $gaSql['link']);
die(json_encode(mysql_fetch_assoc($query)));
die(json_encode(mysqli_fetch_assoc($query)));
}

// AJAX ADD FROM JQUERY
@@ -58,7 +58,7 @@ function fatal_error($sErrorMessage = '') {
@mysql_query(" INSERT INTO $sTable (name, email, mobile) VALUES ('" . $p['firstname'] . "', '" . $p['email'] . "', '" . $p['mobile'] . "')");
$id = mysql_insert_id();
$query = mysql_query(" SELECT * FROM $sTable WHERE $sIndexColumn = " . $id, $gaSql['link']);
die(json_encode(mysql_fetch_assoc($query)));
die(json_encode(mysqli_fetch_assoc($query)));
}
}

@@ -121,13 +121,13 @@ function fatal_error($sErrorMessage = '') {
$rResult = mysql_query($sQuery, $gaSql['link']) or fatal_error('MySQL Error: ' . mysql_errno());
$sQuery = " SELECT FOUND_ROWS() ";
$rResultFilterTotal = mysql_query($sQuery, $gaSql['link']) or fatal_error('MySQL Error: ' . mysql_errno());
$aResultFilterTotal = mysql_fetch_array($rResultFilterTotal);
$aResultFilterTotal = mysqli_fetch_array($rResultFilterTotal);
$iFilteredTotal = $aResultFilterTotal[0];
$sQuery = " SELECT COUNT(" . $sIndexColumn . ") FROM $sTable ";
$rResultTotal = mysql_query($sQuery, $gaSql['link']) or fatal_error('MySQL Error: ' . mysql_errno());
$aResultTotal = mysql_fetch_array($rResultTotal);
$aResultTotal = mysqli_fetch_array($rResultTotal);
$iTotal = $aResultTotal[0];
while ( $aRow = mysql_fetch_array($rResult) ) {
while ( $aRow = mysqli_fetch_array($rResult) ) {
$row = array();
for ( $i = 0 ; $i < count($aColumns); $i++ ) {
if ( $aColumns[$i] == "version" ) $row[] = ( $aRow[$aColumns[$i]] == "0" ) ? '-' : $aRow[$aColumns[$i]];
@@ -21,14 +21,14 @@
$stts_lanjut='Ralan';
$hari=$_POST['hari'];
//mencari biodata pasien dari no rm
$b= mysql_fetch_array(bukaquery("SELECT pasien.nm_ibu, pasien.alamatpj, pasien.kd_kel, pasien.nm_pasien, pasien.kd_kec, pasien.kd_kab, pasien.tgl_lahir, pasien.keluarga FROM pasien WHERE pasien.no_rkm_medis='$no_rkm_medis'"));
$b= mysqli_fetch_array(bukaquery("SELECT pasien.nm_ibu, pasien.alamatpj, pasien.kd_kel, pasien.nm_pasien, pasien.kd_kec, pasien.kd_kab, pasien.tgl_lahir, pasien.keluarga FROM pasien WHERE pasien.no_rkm_medis='$no_rkm_medis'"));
$p_jawab=$b['nm_ibu'];
$alamat_pj=$b['alamatpj'];
$hubunganpj=$b['keluarga'];
$tgl_lahir=$b['tgl_lahir'];
$nm_pasien=$b['nm_pasien'];
//jam pelayanan
$jam_pel=mysql_fetch_array(bukaquery("select jadwal.kd_poli,poliklinik.nm_poli,jadwal.jam_mulai,jadwal.jam_selesai from jadwal,poliklinik,dokter where jadwal.kd_poli=poliklinik.kd_poli and
$jam_pel=mysqli_fetch_array(bukaquery("select jadwal.kd_poli,poliklinik.nm_poli,jadwal.jam_mulai,jadwal.jam_selesai from jadwal,poliklinik,dokter where jadwal.kd_poli=poliklinik.kd_poli and
jadwal.kd_dokter=dokter.kd_dokter and hari_kerja LIKE '%$hari%' GROUP BY poliklinik.kd_poli"));
$jam_mulai=$jam_pel['jam_mulai'];
$jam_selesai=$jam_pel['jam_selesai'];
@@ -47,7 +47,7 @@
//mencari nama dokter
$nm_dokter=getone("SELECT dokter.nm_dokter FROM dokter WHERE dokter.kd_dokter='$kd_dokter'");
//mengambil kop rumah sakit
$setting= mysql_fetch_array(bukaquery("select nama_instansi,alamat_instansi,kabupaten,propinsi,kontak,email,logo from setting"));
$setting= mysqli_fetch_array(bukaquery("select nama_instansi,alamat_instansi,kabupaten,propinsi,kontak,email,logo from setting"));
//mencari no rawat terakhir
$no_rawat_akhir = getone("SELECT max(reg_periksa.no_rawat) as maxno_rawat FROM reg_periksa WHERE no_rawat LIKE '%$tgl_registrasi%'");
$no_urut_rawat = (int) substr($no_rawat_akhir, 11, 6);
@@ -90,7 +90,7 @@ function showDokter()
$hasil = bukaquery($query);

// membuat if untuk masing-masing pilihan poliklinik beserta isi option untuk combobox dokter
while ($data = mysql_fetch_array($hasil))
while ($data = mysqli_fetch_array($hasil))
{
$idPoli = $data['kd_poli'];

@@ -103,7 +103,7 @@ function showDokter()
jadwal.kd_dokter=dokter.kd_dokter and jadwal.kd_poli='$idPoli' and jadwal.hari_kerja LIKE '%$hari%'";
$hasil2 = mysql_query($query2);
$content = "document.getElementById('dokter').innerHTML = \"<select name='kd_dokter' class='form-control'>";
while ($data2 = mysql_fetch_array($hasil2))
while ($data2 = mysqli_fetch_array($hasil2))
{
$content .= "<option value='".$data2['kd_dokter']."'>".$data2['nm_dokter']."</option>";
}
@@ -174,7 +174,7 @@ function showDokter()
else{
echo "<script>alert('Data Ditemukan.. ')</script>";
$rm=mysql_query("select * from pasien where no_rkm_medis='$no_rkm_medis'");
$b=mysql_fetch_array($rm);
$b=mysqli_fetch_array($rm);
$nm_pasien=$b['nm_pasien'];
?>
<form action='tes.php?act=registrasi' name='pilihan' align='center' onsubmit='return validasi_lama(this)' method='post' enctype='multipart/form-data' >
@@ -200,7 +200,7 @@ function showDokter()
<?php $poliklinik="select jadwal.kd_poli,poliklinik.nm_poli,jadwal.jam_mulai,jadwal.jam_selesai from jadwal,poliklinik,dokter where jadwal.kd_poli=poliklinik.kd_poli and
jadwal.kd_dokter=dokter.kd_dokter and hari_kerja LIKE '%$hari%' GROUP BY poliklinik.kd_poli";
$hasil=bukaquery($poliklinik);
while($baris=mysql_fetch_array($hasil)){
while($baris=mysqli_fetch_array($hasil)){
echo "<option value='".$baris['kd_poli']."'>".$baris['nm_poli']." [".$baris['jam_mulai']."-".$baris['jam_selesai']."]</option>";
}?>
</select></td>
@@ -213,7 +213,7 @@ function showDokter()
<option value='' selected >ASKES*</option>";
<?php $askes="select * from penjab where png_jawab LIKE '%umum%' or png_jawab LIKE '%bpjs%' and kd_pj!='2' ";
$hasil=bukaquery($askes);
while($baris=mysql_fetch_array($hasil)){
while($baris=mysqli_fetch_array($hasil)){
echo "<option value='$baris[kd_pj]'>$baris[png_jawab]</option>";
}?>
</select></td>
@@ -15,12 +15,12 @@
$stts_daftar='Lama';
$stts_lanjut='Ralan';
//jam pelayanan
$jam_pel=mysql_fetch_array(bukaquery("select jadwal.kd_poli,poliklinik.nm_poli,jadwal.jam_mulai,jadwal.jam_selesai from jadwal,poliklinik,dokter where jadwal.kd_poli=poliklinik.kd_poli and
$jam_pel=mysqli_fetch_array(bukaquery("select jadwal.kd_poli,poliklinik.nm_poli,jadwal.jam_mulai,jadwal.jam_selesai from jadwal,poliklinik,dokter where jadwal.kd_poli=poliklinik.kd_poli and
jadwal.kd_dokter=dokter.kd_dokter and hari_kerja LIKE '%$hari%' GROUP BY poliklinik.kd_poli"));
$jam_mulai=$jam_pel['jam_mulai'];
$jam_selesai=$jam_pel['jam_selesai'];
//mencari biodata pasien dari no rm
$b=mysql_fetch_array(bukaquery("SELECT pasien.nm_ibu, pasien.alamatpj, pasien.kd_kel, pasien.nm_pasien, pasien.kd_kec, pasien.kd_kab, pasien.tgl_lahir, pasien.keluarga FROM pasien WHERE pasien.no_rkm_medis='$no_rkm_medis'"));
$b=mysqli_fetch_array(bukaquery("SELECT pasien.nm_ibu, pasien.alamatpj, pasien.kd_kel, pasien.nm_pasien, pasien.kd_kec, pasien.kd_kab, pasien.tgl_lahir, pasien.keluarga FROM pasien WHERE pasien.no_rkm_medis='$no_rkm_medis'"));
$p_jawab=$b['nm_ibu'];
$alamat_pj=$b['alamatpj'];
$hubunganpj=$b['keluarga'];
@@ -41,7 +41,7 @@
//mencari nama dokter
$nm_dokter=getone("SELECT dokter.nm_dokter FROM dokter WHERE dokter.kd_dokter='$kd_dokter'");
//mengambil kop rumah sakit
$setting= mysql_fetch_array(bukaquery("select nama_instansi,alamat_instansi,kabupaten,propinsi,kontak,email,logo from setting"));
$setting= mysqli_fetch_array(bukaquery("select nama_instansi,alamat_instansi,kabupaten,propinsi,kontak,email,logo from setting"));
//mencari no rawat terakhir
$no_rawat_akhir = getone("SELECT max(reg_periksa.no_rawat) as maxno_rawat FROM reg_periksa WHERE no_rawat LIKE '%$tgl_registrasi%'");
$no_urut_rawat = (int) substr($no_rawat_akhir, 11, 6);
@@ -36,7 +36,7 @@ function updateAplicare(){
aplicare_ketersediaan_kamar.tersediawanita,aplicare_ketersediaan_kamar.tersediapriawanita
from aplicare_ketersediaan_kamar inner join bangsal on aplicare_ketersediaan_kamar.kd_bangsal=bangsal.kd_bangsal" ;
$hasil=bukaquery($_sql);
while ($data = mysql_fetch_array ($hasil)){
while ($data = mysqli_fetch_array ($hasil)){
$kodekelas=$data['kode_kelas_aplicare'];
$koderuang=$data['kd_bangsal'];
$namaruang=$data['nm_bangsal'];

Large diffs are not rendered by default.

Large diffs are not rendered by default.

@@ -27,7 +27,7 @@ public Component getTableCellRendererComponent(JTable table, Object value, boole
if (column == kolom){
component.setBackground(new Color(215,215,255));
component.setForeground(new Color(255,255,255));
if(!table.getValueAt(row,kolom).toString().equals("")){
if(!table.getValueAt(row,kolom).toString().equals("0")){
component.setBackground(new Color(255,255,255));
component.setForeground(new Color(55,55,175));
}
@@ -69,7 +69,8 @@ public final class var {
permintaan_medis=false,rekap_permintaan_medis=false,surat_pemesanan_medis=false,permintaan_non_medis=false,rekap_permintaan_non_medis=false,
surat_pemesanan_non_medis=false,grafik_per_perujuk=false,bpjs_cek_prosedur=false,bpjs_cek_kelas_rawat=false,bpjs_cek_dokter=false,
bpjs_cek_spesialistik=false,bpjs_cek_ruangrawat=false,bpjs_cek_carakeluar=false,bpjs_cek_pasca_pulang=false,detail_tindakan_okvk=false,
billing_parsial=false,bpjs_cek_nomor_rujukan_rs=false,bpjs_cek_rujukan_kartu_pcare=false,bpjs_cek_rujukan_kartu_rs=false,akses_depo_obat=false;
billing_parsial=false,bpjs_cek_nomor_rujukan_rs=false,bpjs_cek_rujukan_kartu_pcare=false,bpjs_cek_rujukan_kartu_rs=false,akses_depo_obat=false,
bpjs_rujukan_keluar=false;

public static void setData(String user, String pass) {
try {
@@ -394,6 +395,7 @@ public static void setData(String user, String pass) {
var.bpjs_cek_rujukan_kartu_pcare=true;
var.bpjs_cek_rujukan_kartu_rs=true;
var.akses_depo_obat=true;
var.bpjs_rujukan_keluar=true;
}else if(rs2.getRow()>=1){
rs2.beforeFirst();
rs2.next();
@@ -702,6 +704,7 @@ public static void setData(String user, String pass) {
var.bpjs_cek_rujukan_kartu_pcare=rs2.getBoolean("bpjs_cek_rujukan_kartu_pcare");
var.bpjs_cek_rujukan_kartu_rs=rs2.getBoolean("bpjs_cek_rujukan_kartu_rs");
var.akses_depo_obat=rs2.getBoolean("akses_depo_obat");
var.bpjs_rujukan_keluar=rs2.getBoolean("bpjs_rujukan_keluar");
}else if((rs.getRow()==0)&&(rs2.getRow()==0)){
var.kode="";
var.penyakit= false;
@@ -1008,6 +1011,7 @@ public static void setData(String user, String pass) {
var.bpjs_cek_rujukan_kartu_pcare=false;
var.bpjs_cek_rujukan_kartu_rs=false;
var.akses_depo_obat=false;
var.bpjs_rujukan_keluar=false;
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
@@ -1361,4 +1365,5 @@ public static void setData(String user, String pass) {
public static boolean getbpjs_cek_rujukan_kartu_pcare(){return var.bpjs_cek_rujukan_kartu_pcare;}
public static boolean getbpjs_cek_rujukan_kartu_rs(){return var.bpjs_cek_rujukan_kartu_rs;}
public static boolean getakses_depo_obat(){return var.akses_depo_obat;}
public static boolean getbpjs_rujukan_keluar(){return var.bpjs_rujukan_keluar;}
}
@@ -147,7 +147,7 @@
<Properties>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="18-02-2018 09:46:20"/>
<StringItem index="0" value="01-03-2018 04:47:21"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy HH:mm:ss"/>
@@ -19,6 +19,7 @@
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Date;
import javax.swing.JTable;
import javax.swing.event.DocumentEvent;
import javax.swing.table.DefaultTableModel;
@@ -1807,6 +1808,7 @@ public void setNoRm(String norwt,String kodedokter, String namadokter,String Kod
}

private void isRawat(){
DTPTgl.setDate(new Date());
Sequel.cariIsi("select no_rkm_medis from reg_periksa where no_rawat=? ",TNoRM,TNoRw.getText());
}

@@ -1605,7 +1605,7 @@
<Properties>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="18-02-2018 08:21:58"/>
<StringItem index="0" value="03-03-2018 07:55:32"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy HH:mm:ss"/>

Large diffs are not rendered by default.

@@ -8,9 +8,6 @@
<Color blue="ff" green="ff" red="ff" type="rgb"/>
</Property>
<Property name="name" type="java.lang.String" value="TKd" noResource="true"/>
<Property name="selectionColor" type="java.awt.Color" editor="org.netbeans.beaninfo.editors.ColorEditor">
<Color blue="ff" green="ff" red="ff" type="rgb"/>
</Property>
</Properties>
</Component>
</NonVisualComponents>
@@ -2,8 +2,7 @@

package keuangan;

import fungsi.WarnaTable;
import fungsi.WarnaTable2;
import fungsi.WarnaTable3;
import fungsi.batasInput;
import fungsi.koneksiDB;
import fungsi.sekuel;
@@ -45,7 +44,7 @@ public final class DlgHutangObatBelumLunas extends javax.swing.JDialog {
private String koderekening="";
private double sisahutang=0,cicilan=0;
private Jurnal jur=new Jurnal();
private WarnaTable2 warna=new WarnaTable2();
private WarnaTable3 warna=new WarnaTable3();

/** Creates new form DlgLhtBiaya
* @param parent
@@ -74,7 +73,7 @@ public DlgHutangObatBelumLunas(java.awt.Frame parent, boolean modal) {
java.lang.Object.class,java.lang.Object.class,java.lang.Object.class,
java.lang.Object.class,java.lang.Object.class,
java.lang.Object.class,java.lang.Double.class,java.lang.Double.class,
java.lang.Object.class,java.lang.Object.class
java.lang.Double.class,java.lang.Double.class
};
@Override
public Class getColumnClass(int columnIndex) {
@@ -113,7 +112,7 @@ public Class getColumnClass(int columnIndex) {
column.setPreferredWidth(80);
}
}
warna.kolom=9;
warna.kolom=11;
tbBangsal.setDefaultRenderer(Object.class,warna);

no_bukti.setDocument(new batasInput((byte)20).getKata(no_bukti));
@@ -635,16 +634,17 @@ private void tbBangsalMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:e
if(tabMode.getRowCount()!=0){
if(evt.getClickCount()==1){
if(tbBangsal.getSelectedColumn()==0){
if(tbBangsal.getValueAt(tbBangsal.getSelectedRow(),11).toString().equals("")){
tbBangsal.setValueAt(tbBangsal.getValueAt(tbBangsal.getSelectedRow(),12).toString(), tbBangsal.getSelectedRow(),11);
if(tbBangsal.getValueAt(tbBangsal.getSelectedRow(),11).toString().equals("0")){
tbBangsal.setValueAt(Double.parseDouble(tbBangsal.getValueAt(tbBangsal.getSelectedRow(),12).toString()), tbBangsal.getSelectedRow(),11);
}
if(tbBangsal.getValueAt(tbBangsal.getSelectedRow(),0).toString().equals("true")){
tbBangsal.setValueAt(
(Valid.SetAngka(tbBangsal.getValueAt(tbBangsal.getSelectedRow(),12).toString())-
Valid.SetAngka(tbBangsal.getValueAt(tbBangsal.getSelectedRow(),11).toString()))
(Double.parseDouble(tbBangsal.getValueAt(tbBangsal.getSelectedRow(),12).toString())-
Double.parseDouble(tbBangsal.getValueAt(tbBangsal.getSelectedRow(),11).toString()))
,tbBangsal.getSelectedRow(),10);
}else if(tbBangsal.getValueAt(tbBangsal.getSelectedRow(),0).toString().equals("false")){
tbBangsal.setValueAt(Valid.SetAngka(tbBangsal.getValueAt(tbBangsal.getSelectedRow(),12).toString()),tbBangsal.getSelectedRow(),10);
tbBangsal.setValueAt(0,tbBangsal.getSelectedRow(),11);
tbBangsal.setValueAt(Double.parseDouble(tbBangsal.getValueAt(tbBangsal.getSelectedRow(),12).toString()),tbBangsal.getSelectedRow(),10);
}
}
}
@@ -656,15 +656,15 @@ private void tbBangsalKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event
if(evt.getKeyCode()==KeyEvent.VK_ENTER){
if(tbBangsal.getValueAt(tbBangsal.getSelectedRow(),0).toString().equals("true")){
tbBangsal.setValueAt(
(Valid.SetAngka(tbBangsal.getValueAt(tbBangsal.getSelectedRow(),12).toString())-
Valid.SetAngka(tbBangsal.getValueAt(tbBangsal.getSelectedRow(),11).toString()))
(Double.parseDouble(tbBangsal.getValueAt(tbBangsal.getSelectedRow(),12).toString())-
Double.parseDouble(tbBangsal.getValueAt(tbBangsal.getSelectedRow(),11).toString()))
,tbBangsal.getSelectedRow(),10);
}else if(tbBangsal.getValueAt(tbBangsal.getSelectedRow(),0).toString().equals("false")){
tbBangsal.setValueAt(Valid.SetAngka(tbBangsal.getValueAt(tbBangsal.getSelectedRow(),12).toString()),tbBangsal.getSelectedRow(),10);
tbBangsal.setValueAt(Double.parseDouble(tbBangsal.getValueAt(tbBangsal.getSelectedRow(),12).toString()),tbBangsal.getSelectedRow(),10);
}
}else if(evt.getKeyCode()==KeyEvent.VK_DELETE){
if(tbBangsal.getSelectedColumn()==11){
tbBangsal.setValueAt("", tbBangsal.getSelectedRow(),11);
tbBangsal.setValueAt(0, tbBangsal.getSelectedRow(),11);
}
}
}
@@ -739,7 +739,7 @@ private void BtnBayarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRS
row=tabMode.getRowCount();
for(int i=0;i<row;i++){
if(tabMode.getValueAt(i,0).toString().equals("true")){
if(Valid.SetAngka(tbBangsal.getValueAt(tbBangsal.getSelectedRow(),11).toString())>0){
if(Double.parseDouble(tbBangsal.getValueAt(i,11).toString())>0){
if(Sequel.menyimpantf("bayar_pemesanan","?,?,?,?,?,?,?","Data", 7,new String[]{
Valid.SetTgl(tgl_bayar.getSelectedItem()+""),tabMode.getValueAt(i,1).toString(),nip.getText(),
tabMode.getValueAt(i,11).toString(),keterangan.getText(),nama_bayar.getSelectedItem().toString(),
@@ -901,7 +901,7 @@ public void tampil(){
rs.getString("nama_suplier"),rs.getString("nama"),rs.getString("tgl_faktur"),
rs.getString("tgl_pesan"),rs.getString("tgl_tempo"),rs.getString("nm_bangsal"),
rs.getDouble("tagihan"),(rs.getDouble("tagihan")-rs.getDouble("bayar")),
"",(rs.getDouble("tagihan")-rs.getDouble("bayar"))
0,(rs.getDouble("tagihan")-rs.getDouble("bayar"))
});
sisahutang=sisahutang+rs.getDouble("tagihan");
cicilan=cicilan+rs.getDouble("bayar");
@@ -102,7 +102,7 @@ public DlgUser(java.awt.Frame parent, boolean modal) {
"[D]Permintaan Obat & BHP","[D]Rekap Permintaan Obat & BHP","[D]Surat Pemesanan Obat & BHP","[E]Permintaan Barang Non Medis","[E]Rekap Permintaan Barang Non Medis",
"[E]Surat Pemesanan Barang Non Medis","[N]Kunjungan Per Perujuk","[K]Referensi Prosedur VClaim","[K]Referensi Kelas Rawat VClaim","[K]Referensi Dokter VClaim",
"[K]Referensi Spesialistik VClaim","[K]Referensi Ruang Rawat VClaim","[K]Referensi Cara Keluar VClaim","[K]Referensi Pasca Pulang VClaim","[H]Detail VK/OK","[A]Billing Parsial",
"[K]Cek No.Rujukan RS di VClaim","[K]Cek Rujukan Kartu PCare di VClaim","[K]Cek Rujukan Kartu RS di VClaim","[A]Akses Depo Obat/BHP"
"[K]Cek No.Rujukan RS di VClaim","[K]Cek Rujukan Kartu PCare di VClaim","[K]Cek Rujukan Kartu RS di VClaim","[A]Akses Depo Obat/BHP","[K]Pembuatan Rujukan VClaim"
};

tabMode=new DefaultTableModel(null,row){
@@ -206,7 +206,7 @@ public Class getColumnClass(int columnIndex) {
tbUser.setPreferredScrollableViewportSize(new Dimension(500,500));
tbUser.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);

for (i = 0; i < 304;i++) {
for (i = 0; i < 305;i++) {
TableColumn column = tbUser.getColumnModel().getColumn(i);
if(i==0){
column.setPreferredWidth(130);
@@ -450,6 +450,8 @@ public Class getColumnClass(int columnIndex) {
column.setPreferredWidth(170);
}else if(i==303){
column.setPreferredWidth(127);
}else if(i==304){
column.setPreferredWidth(150);
}else{
column.setPreferredWidth(120);
}
@@ -884,7 +886,7 @@ private void BtnSimpanActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIR
"'false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false',"+
"'false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false',"+
"'false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false',"+
"'false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false'","User")==true){
"'false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false'","User")==true){
tampil();
emptTeks();
}
@@ -1230,7 +1232,8 @@ private void BtnEditActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST
"bpjs_cek_nomor_rujukan_rs='"+tbUser.getValueAt(i,300).toString()+"',"+
"bpjs_cek_rujukan_kartu_pcare='"+tbUser.getValueAt(i,301).toString()+"',"+
"bpjs_cek_rujukan_kartu_rs='"+tbUser.getValueAt(i,302).toString()+"',"+
"akses_depo_obat='"+tbUser.getValueAt(i,303).toString()+"'");
"akses_depo_obat='"+tbUser.getValueAt(i,303).toString()+"',"+
"bpjs_rujukan_keluar='"+tbUser.getValueAt(i,304).toString()+"'");
}
tampil();
emptTeks();
@@ -1507,8 +1510,8 @@ private void tampil() {
"permintaan_medis,rekap_permintaan_medis,surat_pemesanan_medis,permintaan_non_medis,rekap_permintaan_non_medis, "+
"surat_pemesanan_non_medis,grafik_per_perujuk,bpjs_cek_prosedur,bpjs_cek_kelas_rawat,bpjs_cek_dokter, "+
"bpjs_cek_spesialistik,bpjs_cek_ruangrawat,bpjs_cek_carakeluar,bpjs_cek_pasca_pulang,detail_tindakan_okvk, "+
"billing_parsial,bpjs_cek_nomor_rujukan_rs,bpjs_cek_rujukan_kartu_pcare,bpjs_cek_rujukan_kartu_rs,akses_depo_obat "+
"from user order by AES_DECRYPT(id_user,'nur')");
"billing_parsial,bpjs_cek_nomor_rujukan_rs,bpjs_cek_rujukan_kartu_pcare,bpjs_cek_rujukan_kartu_rs,akses_depo_obat,"+
"bpjs_rujukan_keluar from user order by AES_DECRYPT(id_user,'nur')");
try {
rs=ps.executeQuery();
while(rs.next()){
@@ -1823,7 +1826,8 @@ private void tampil() {
rs.getBoolean("bpjs_cek_nomor_rujukan_rs"),
rs.getBoolean("bpjs_cek_rujukan_kartu_pcare"),
rs.getBoolean("bpjs_cek_rujukan_kartu_rs"),
rs.getBoolean("akses_depo_obat")
rs.getBoolean("akses_depo_obat"),
rs.getBoolean("bpjs_rujukan_keluar")
});
}
} catch (Exception e) {
@@ -2128,7 +2132,8 @@ private void tampil() {
rs.getBoolean("bpjs_cek_nomor_rujukan_rs"),
rs.getBoolean("bpjs_cek_rujukan_kartu_pcare"),
rs.getBoolean("bpjs_cek_rujukan_kartu_rs"),
rs.getBoolean("akses_depo_obat")
rs.getBoolean("akses_depo_obat"),
rs.getBoolean("bpjs_rujukan_keluar")
});
}
}
@@ -666,6 +666,31 @@
<EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="MnSKL1ActionPerformed"/>
</Events>
</MenuItem>
<MenuItem class="javax.swing.JMenuItem" name="MnSKL2">
<Properties>
<Property name="background" type="java.awt.Color" editor="org.netbeans.beaninfo.editors.ColorEditor">
<Color blue="ff" green="ff" red="ff" type="rgb"/>
</Property>
<Property name="font" type="java.awt.Font" editor="org.netbeans.beaninfo.editors.FontEditor">
<Font name="Tahoma" size="11" style="0"/>
</Property>
<Property name="foreground" type="java.awt.Color" editor="org.netbeans.beaninfo.editors.ColorEditor">
<Color blue="50" green="78" red="5a" type="rgb"/>
</Property>
<Property name="icon" type="javax.swing.Icon" editor="org.netbeans.modules.form.editors2.IconEditor">
<Image iconType="3" name="/picture/category.png"/>
</Property>
<Property name="text" type="java.lang.String" value="Surat Keterangan Lahir 3"/>
<Property name="iconTextGap" type="int" value="5"/>
<Property name="name" type="java.lang.String" value="MnSKL2" noResource="true"/>
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor">
<Dimension value="[250, 28]"/>
</Property>
</Properties>
<Events>
<EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="MnSKL2ActionPerformed"/>
</Events>
</MenuItem>
</SubComponents>
</Container>
<Component class="widget.TextBox" name="Kd2">
@@ -29,6 +29,7 @@
import java.time.temporal.ChronoUnit;
import java.util.Date;
import java.util.HashMap;
import java.util.Locale;
import java.util.Map;
import javax.swing.JButton;
import javax.swing.JOptionPane;
@@ -247,6 +248,7 @@ private void initComponents() {
MnInformasiBayi = new javax.swing.JMenuItem();
MnSKL = new javax.swing.JMenuItem();
MnSKL1 = new javax.swing.JMenuItem();
MnSKL2 = new javax.swing.JMenuItem();
Kd2 = new widget.TextBox();
DlgBridgingLahir = new javax.swing.JDialog();
internalFrame3 = new widget.InternalFrame();
@@ -786,6 +788,21 @@ public void actionPerformed(java.awt.event.ActionEvent evt) {
});
Popup.add(MnSKL1);

MnSKL2.setBackground(new java.awt.Color(255, 255, 255));
MnSKL2.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N
MnSKL2.setForeground(new java.awt.Color(90, 120, 80));
MnSKL2.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/category.png"))); // NOI18N
MnSKL2.setText("Surat Keterangan Lahir 3");
MnSKL2.setIconTextGap(5);
MnSKL2.setName("MnSKL2"); // NOI18N
MnSKL2.setPreferredSize(new java.awt.Dimension(250, 28));
MnSKL2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
MnSKL2ActionPerformed(evt);
}
});
Popup.add(MnSKL2);

Kd2.setName("Kd2"); // NOI18N
Kd2.setPreferredSize(new java.awt.Dimension(207, 23));

@@ -2934,42 +2951,6 @@ private void BtnPenjabActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIR
pegawai.setVisible(true);
}//GEN-LAST:event_BtnPenjabActionPerformed

private void MnSKL1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_MnSKL1ActionPerformed
this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR));
tampil();
if(tabMode.getRowCount()==0){
JOptionPane.showMessageDialog(null,"Maaf, data sudah habis. Tidak ada data yang bisa anda print...!!!!");
BtnBatal.requestFocus();
}else if(tabMode.getRowCount()!=0){
Map<String, Object> param = new HashMap<>();
param.put("namars",var.getnamars());
param.put("alamatrs",var.getalamatrs());
param.put("kotars",var.getkabupatenrs());
param.put("nomor",NoSKL.getText());
param.put("propinsirs",var.getpropinsirs());
param.put("kontakrs",var.getkontakrs());
param.put("emailrs",var.getemailrs());
param.put("logo",Sequel.cariGambar("select logo from setting"));
param.put("logo2",Sequel.cariGambar("select logo from setting"));
Valid.MyReport("rptSKL2.jrxml","report","::[ Surat Kelahiran Bayi ]::",
"select pasien.no_rkm_medis, pasien.nm_pasien, pasien.jk, "+
"pasien.tgl_lahir,pasien_bayi.jam_lahir, pasien.umur, "+
"pasien.tgl_daftar,pasien.nm_ibu,pasien_bayi.umur_ibu,pasien.pekerjaanpj, "+
"pasien_bayi.nama_ayah,pasien_bayi.umur_ayah,pasien.no_ktp,"+
"concat(pasien.alamat,', ',kelurahan.nm_kel,', ',kecamatan.nm_kec,', ',kabupaten.nm_kab) as alamat, "+
"pasien_bayi.berat_badan,pasien_bayi.panjang_badan, pasien_bayi.lingkar_kepala, "+
"pasien_bayi.proses_lahir,pasien_bayi.anakke, pasien_bayi.keterangan, "+
"pasien_bayi.diagnosa,pasien_bayi.penyulit_kehamilan,pasien_bayi.ketuban,"+
"pasien_bayi.lingkar_perut,pasien_bayi.lingkar_dada,pegawai.nama,"+
"pasien_bayi.no_skl from pasien inner join pegawai inner join pasien_bayi "+
"inner join kelurahan inner join kecamatan inner join kabupaten "+
"on pasien.no_rkm_medis=pasien_bayi.no_rkm_medis and pasien_bayi.penolong=pegawai.nik "+
"and pasien.kd_kel=kelurahan.kd_kel and pasien.kd_kec=kecamatan.kd_kec and pasien.kd_kab=kabupaten.kd_kab "+
"where pasien_bayi.no_rkm_medis='"+NoRm.getText()+"'",param);
}
this.setCursor(Cursor.getDefaultCursor());
}//GEN-LAST:event_MnSKL1ActionPerformed

private void BtnKelurahan1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnKelurahan1ActionPerformed
if(NoRm.getText().trim().equals("")){
Valid.textKosong(NoRm,"No.Rekam Medis");
@@ -3426,6 +3407,80 @@ private void UmurSaksi2KeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:even
// TODO add your handling code here:
}//GEN-LAST:event_UmurSaksi2KeyPressed

private void MnSKL1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_MnSKL1ActionPerformed
this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR));
tampil();
if(tabMode.getRowCount()==0){
JOptionPane.showMessageDialog(null,"Maaf, data sudah habis. Tidak ada data yang bisa anda print...!!!!");
BtnBatal.requestFocus();
}else if(tabMode.getRowCount()!=0){
Map<String, Object> param = new HashMap<>();
param.put("namars",var.getnamars());
param.put("alamatrs",var.getalamatrs());
param.put("kotars",var.getkabupatenrs());
param.put("nomor",NoSKL.getText());
param.put("propinsirs",var.getpropinsirs());
param.put("kontakrs",var.getkontakrs());
param.put("emailrs",var.getemailrs());
param.put("logo",Sequel.cariGambar("select logo from setting"));
param.put("logo2",Sequel.cariGambar("select logo from setting"));
Valid.MyReport("rptSKL2.jrxml","report","::[ Surat Kelahiran Bayi ]::",
"select pasien.no_rkm_medis, pasien.nm_pasien, pasien.jk, "+
"pasien.tgl_lahir,pasien_bayi.jam_lahir, pasien.umur, "+
"pasien.tgl_daftar,pasien.nm_ibu,pasien_bayi.umur_ibu,pasien.pekerjaanpj, "+
"pasien_bayi.nama_ayah,pasien_bayi.umur_ayah,pasien.no_ktp,"+
"concat(pasien.alamat,', ',kelurahan.nm_kel,', ',kecamatan.nm_kec,', ',kabupaten.nm_kab) as alamat, "+
"pasien_bayi.berat_badan,pasien_bayi.panjang_badan, pasien_bayi.lingkar_kepala, "+
"pasien_bayi.proses_lahir,pasien_bayi.anakke, pasien_bayi.keterangan, "+
"pasien_bayi.diagnosa,pasien_bayi.penyulit_kehamilan,pasien_bayi.ketuban,"+
"pasien_bayi.lingkar_perut,pasien_bayi.lingkar_dada,pegawai.nama,"+
"pasien_bayi.no_skl from pasien inner join pegawai inner join pasien_bayi "+
"inner join kelurahan inner join kecamatan inner join kabupaten "+
"on pasien.no_rkm_medis=pasien_bayi.no_rkm_medis and pasien_bayi.penolong=pegawai.nik "+
"and pasien.kd_kel=kelurahan.kd_kel and pasien.kd_kec=kecamatan.kd_kec and pasien.kd_kab=kabupaten.kd_kab "+
"where pasien_bayi.no_rkm_medis='"+NoRm.getText()+"'",param);
}
this.setCursor(Cursor.getDefaultCursor());
}//GEN-LAST:event_MnSKL1ActionPerformed

private void MnSKL2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_MnSKL2ActionPerformed
this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR));
tampil();
if(tabMode.getRowCount()==0){
JOptionPane.showMessageDialog(null,"Maaf, data sudah habis. Tidak ada data yang bisa anda print...!!!!");
BtnBatal.requestFocus();
}else if(tabMode.getRowCount()!=0){
Locale locale = new Locale ("id", "ID");
Locale.setDefault(locale);
Map<String, Object> param = new HashMap<>();
param.put("namars",var.getnamars());
param.put("alamatrs",var.getalamatrs());
param.put("kotars",var.getkabupatenrs());
param.put("nomor",NoSKL.getText());
param.put("propinsirs",var.getpropinsirs());
param.put("kontakrs",var.getkontakrs());
param.put("emailrs",var.getemailrs());
param.put("logo",Sequel.cariGambar("select logo from setting"));
param.put("logo2",Sequel.cariGambar("select logo from setting"));
Valid.MyReport("rptSKL3.jrxml","report","::[ Surat Kelahiran Bayi ]::",
"select pasien.no_rkm_medis, pasien.nm_pasien, pasien.jk, "+
"pasien.tgl_lahir,pasien_bayi.jam_lahir, pasien.umur, "+
"pasien.tgl_daftar,pasien.nm_ibu,pasien_bayi.umur_ibu,pasien.pekerjaanpj, "+
"pasien_bayi.nama_ayah,pasien_bayi.umur_ayah,pasien.no_ktp,"+
"concat(pasien.alamat,', ',kelurahan.nm_kel,', ',kecamatan.nm_kec,', ',kabupaten.nm_kab) as alamat, "+
"pasien_bayi.berat_badan,pasien_bayi.panjang_badan, pasien_bayi.lingkar_kepala, "+
"pasien_bayi.proses_lahir,pasien_bayi.anakke, pasien_bayi.keterangan, "+
"pasien_bayi.diagnosa,pasien_bayi.penyulit_kehamilan,pasien_bayi.ketuban,"+
"pasien_bayi.lingkar_perut,pasien_bayi.lingkar_dada,pegawai.nama,"+
"pasien_bayi.no_skl from pasien inner join pegawai inner join pasien_bayi "+
"inner join kelurahan inner join kecamatan inner join kabupaten "+
"on pasien.no_rkm_medis=pasien_bayi.no_rkm_medis and pasien_bayi.penolong=pegawai.nik "+
"and pasien.kd_kel=kelurahan.kd_kel and pasien.kd_kec=kecamatan.kd_kec and pasien.kd_kab=kabupaten.kd_kab "+
"where pasien_bayi.no_rkm_medis='"+NoRm.getText()+"'",param);
}
this.setCursor(Cursor.getDefaultCursor());
}//GEN-LAST:event_MnSKL2ActionPerformed

/**
* @param args the command line arguments
*/
@@ -3491,6 +3546,7 @@ public void windowClosing(java.awt.event.WindowEvent e) {
private javax.swing.JMenuItem MnKartu;
private javax.swing.JMenuItem MnSKL;
private javax.swing.JMenuItem MnSKL1;
private javax.swing.JMenuItem MnSKL2;
private widget.TextBox NIKAyah;
private widget.TextBox NIKIbu;
private widget.TextBox NIKPelapor;
@@ -399,7 +399,7 @@ public void windowOpened(java.awt.event.WindowEvent evt) {
}
});

internalFrame1.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(240, 245, 235)), "::[ Cari Penyerahan Darah UTD ]::", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90,120,80))); // NOI18N
internalFrame1.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(240, 245, 235)), "::[ Cari Penyerahan Darah UTD ]::", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90, 120, 80))); // NOI18N
internalFrame1.setName("internalFrame1"); // NOI18N
internalFrame1.setLayout(new java.awt.BorderLayout(1, 1));

@@ -285,7 +285,7 @@
</Property>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="15-01-2017"/>
<StringItem index="0" value="21-02-2018"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -314,7 +314,7 @@
</Property>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="15-01-2017"/>
<StringItem index="0" value="21-02-2018"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -534,7 +534,7 @@
</Property>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="15-01-2017"/>
<StringItem index="0" value="21-02-2018"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -197,7 +197,7 @@ public void windowOpened(java.awt.event.WindowEvent evt) {
}
});

internalFrame1.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(240, 245, 235)), "::[ Data Pencekalan Darah Donor ]::", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90,120,80))); // NOI18N
internalFrame1.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(240, 245, 235)), "::[ Data Pencekalan Darah Donor ]::", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90, 120, 80))); // NOI18N
internalFrame1.setFont(new java.awt.Font("Tahoma", 2, 12)); // NOI18N
internalFrame1.setName("internalFrame1"); // NOI18N
internalFrame1.setLayout(new java.awt.BorderLayout(1, 1));
@@ -370,7 +370,7 @@ public void keyPressed(java.awt.event.KeyEvent evt) {

DTPCari1.setEditable(false);
DTPCari1.setForeground(new java.awt.Color(50, 70, 50));
DTPCari1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "04-01-2017" }));
DTPCari1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "15-01-2017" }));
DTPCari1.setDisplayFormat("dd-MM-yyyy");
DTPCari1.setName("DTPCari1"); // NOI18N
DTPCari1.setOpaque(false);
@@ -385,7 +385,7 @@ public void keyPressed(java.awt.event.KeyEvent evt) {

DTPCari2.setEditable(false);
DTPCari2.setForeground(new java.awt.Color(50, 70, 50));
DTPCari2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "04-01-2017" }));
DTPCari2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "15-01-2017" }));
DTPCari2.setDisplayFormat("dd-MM-yyyy");
DTPCari2.setName("DTPCari2"); // NOI18N
DTPCari2.setOpaque(false);
@@ -506,7 +506,7 @@ public void keyPressed(java.awt.event.KeyEvent evt) {

TanggalCekal.setEditable(false);
TanggalCekal.setForeground(new java.awt.Color(50, 70, 50));
TanggalCekal.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "04-01-2017" }));
TanggalCekal.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "15-01-2017" }));
TanggalCekal.setDisplayFormat("dd-MM-yyyy");
TanggalCekal.setName("TanggalCekal"); // NOI18N
TanggalCekal.setOpaque(false);
@@ -746,7 +746,7 @@
<Property name="editable" type="boolean" value="false"/>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="15-02-2017"/>
<StringItem index="0" value="21-02-2018"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -1712,7 +1712,7 @@
</Property>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="15-02-2017"/>
<StringItem index="0" value="21-02-2018"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -1741,7 +1741,7 @@
</Property>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="15-02-2017"/>
<StringItem index="0" value="21-02-2018"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -36,7 +36,6 @@
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableColumn;
import simrskhanza.DlgCariPetugas;
import tranfusidarah.UTDCekalDarah;

/**
*
@@ -537,13 +536,13 @@ public void windowActivated(java.awt.event.WindowEvent evt) {
}
});

internalFrame1.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(240, 245, 235)), "::[ Donor Darah ]::", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90,120,80))); // NOI18N
internalFrame1.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(240, 245, 235)), "::[ Donor Darah ]::", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90, 120, 80))); // NOI18N
internalFrame1.setName("internalFrame1"); // NOI18N
internalFrame1.setLayout(new java.awt.BorderLayout(1, 1));

TabRawat.setBackground(new java.awt.Color(250, 255, 245));
TabRawat.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(230, 235, 225)));
TabRawat.setForeground(new java.awt.Color(90,120,80));
TabRawat.setForeground(new java.awt.Color(90, 120, 80));
TabRawat.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N
TabRawat.setName("TabRawat"); // NOI18N
TabRawat.addMouseListener(new java.awt.event.MouseAdapter() {
@@ -561,7 +560,7 @@ public void mouseClicked(java.awt.event.MouseEvent evt) {
panelisi5.setPreferredSize(new java.awt.Dimension(450, 77));
panelisi5.setLayout(new java.awt.GridLayout(2, 0));

jPanel3.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(237, 242, 232)), ".: Penggunaan BHP Medis ", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90,120,80))); // NOI18N
jPanel3.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(237, 242, 232)), ".: Penggunaan BHP Medis ", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90, 120, 80))); // NOI18N
jPanel3.setName("jPanel3"); // NOI18N
jPanel3.setOpaque(false);
jPanel3.setPreferredSize(new java.awt.Dimension(300, 102));
@@ -645,7 +644,7 @@ public void keyPressed(java.awt.event.KeyEvent evt) {

panelisi5.add(jPanel3);

jPanel4.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(237, 242, 232)), ".: Penggunaan BHP Non Medis ", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90,120,80))); // NOI18N
jPanel4.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(237, 242, 232)), ".: Penggunaan BHP Non Medis ", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90, 120, 80))); // NOI18N
jPanel4.setName("jPanel4"); // NOI18N
jPanel4.setOpaque(false);
jPanel4.setPreferredSize(new java.awt.Dimension(300, 202));
@@ -207,7 +207,7 @@ public void windowOpened(java.awt.event.WindowEvent evt) {
}
});

internalFrame1.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(240, 245, 235)), "::[ Data Komponen Darah ]::", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90,120,80))); // NOI18N
internalFrame1.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(240, 245, 235)), "::[ Data Komponen Darah ]::", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90, 120, 80))); // NOI18N
internalFrame1.setName("internalFrame1"); // NOI18N
internalFrame1.setLayout(new java.awt.BorderLayout(1, 1));

@@ -570,7 +570,7 @@
</Property>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="15-01-2017"/>
<StringItem index="0" value="21-02-2018"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -599,7 +599,7 @@
</Property>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="15-01-2017"/>
<StringItem index="0" value="21-02-2018"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -254,13 +254,13 @@ public void windowOpened(java.awt.event.WindowEvent evt) {
}
});

internalFrame1.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(240, 245, 235)), "::[ BHP Medis Rusak ]::", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90,120,80))); // NOI18N
internalFrame1.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(240, 245, 235)), "::[ BHP Medis Rusak ]::", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90, 120, 80))); // NOI18N
internalFrame1.setName("internalFrame1"); // NOI18N
internalFrame1.setLayout(new java.awt.BorderLayout(1, 1));

TabSetting.setBackground(new java.awt.Color(250, 255, 245));
TabSetting.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(230, 235, 225)));
TabSetting.setForeground(new java.awt.Color(90,120,80));
TabSetting.setForeground(new java.awt.Color(90, 120, 80));
TabSetting.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N
TabSetting.setName("TabSetting"); // NOI18N
TabSetting.addMouseListener(new java.awt.event.MouseAdapter() {
@@ -496,7 +496,7 @@ public void keyPressed(java.awt.event.KeyEvent evt) {

DTPCari1.setEditable(false);
DTPCari1.setForeground(new java.awt.Color(50, 70, 50));
DTPCari1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "26-11-2016" }));
DTPCari1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "15-01-2017" }));
DTPCari1.setDisplayFormat("dd-MM-yyyy");
DTPCari1.setName("DTPCari1"); // NOI18N
DTPCari1.setOpaque(false);
@@ -511,7 +511,7 @@ public void keyPressed(java.awt.event.KeyEvent evt) {

DTPCari2.setEditable(false);
DTPCari2.setForeground(new java.awt.Color(50, 70, 50));
DTPCari2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "26-11-2016" }));
DTPCari2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "15-01-2017" }));
DTPCari2.setDisplayFormat("dd-MM-yyyy");
DTPCari2.setName("DTPCari2"); // NOI18N
DTPCari2.setOpaque(false);
@@ -409,7 +409,7 @@
<Property name="editable" type="boolean" value="false"/>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="18-01-2017"/>
<StringItem index="0" value="21-02-2018"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -1035,7 +1035,7 @@
</Property>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="18-01-2017"/>
<StringItem index="0" value="21-02-2018"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -1064,7 +1064,7 @@
</Property>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="18-01-2017"/>
<StringItem index="0" value="21-02-2018"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -354,7 +354,7 @@ public void windowOpened(java.awt.event.WindowEvent evt) {
}
});

internalFrame2.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(237, 242, 232)), "::[ Input Data Pemisahan Komponen Darah ]::", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90,120,80))); // NOI18N
internalFrame2.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(237, 242, 232)), "::[ Input Data Pemisahan Komponen Darah ]::", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90, 120, 80))); // NOI18N
internalFrame2.setName("internalFrame2"); // NOI18N
internalFrame2.setLayout(new java.awt.BorderLayout(1, 1));

@@ -363,7 +363,7 @@ public void windowOpened(java.awt.event.WindowEvent evt) {
panelisi5.setPreferredSize(new java.awt.Dimension(450, 77));
panelisi5.setLayout(new java.awt.GridLayout(2, 0));

jPanel3.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(237, 242, 232)), ".: Penggunaan BHP Medis ", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90,120,80))); // NOI18N
jPanel3.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(237, 242, 232)), ".: Penggunaan BHP Medis ", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90, 120, 80))); // NOI18N
jPanel3.setName("jPanel3"); // NOI18N
jPanel3.setOpaque(false);
jPanel3.setPreferredSize(new java.awt.Dimension(300, 102));
@@ -437,7 +437,7 @@ public void keyPressed(java.awt.event.KeyEvent evt) {

panelisi5.add(jPanel3);

jPanel4.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(237, 242, 232)), ".: Penggunaan BHP Non Medis ", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90,120,80))); // NOI18N
jPanel4.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(237, 242, 232)), ".: Penggunaan BHP Non Medis ", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90, 120, 80))); // NOI18N
jPanel4.setName("jPanel4"); // NOI18N
jPanel4.setOpaque(false);
jPanel4.setPreferredSize(new java.awt.Dimension(300, 202));
@@ -857,7 +857,7 @@ public void windowOpened(java.awt.event.WindowEvent evt) {
}
});

internalFrame1.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(240, 245, 235)), "::[ Data Pemisahan Komponen Darah ]::", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90,120,80))); // NOI18N
internalFrame1.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(240, 245, 235)), "::[ Data Pemisahan Komponen Darah ]::", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90, 120, 80))); // NOI18N
internalFrame1.setName("internalFrame1"); // NOI18N
internalFrame1.setLayout(new java.awt.BorderLayout(1, 1));

@@ -570,7 +570,7 @@
</Property>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="15-01-2017"/>
<StringItem index="0" value="21-02-2018"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -599,7 +599,7 @@
</Property>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="15-01-2017"/>
<StringItem index="0" value="21-02-2018"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -253,13 +253,13 @@ public void windowOpened(java.awt.event.WindowEvent evt) {
}
});

internalFrame1.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(240, 245, 235)), "::[ BHP Non Medis Rusak ]::", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90,120,80))); // NOI18N
internalFrame1.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(240, 245, 235)), "::[ BHP Non Medis Rusak ]::", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90, 120, 80))); // NOI18N
internalFrame1.setName("internalFrame1"); // NOI18N
internalFrame1.setLayout(new java.awt.BorderLayout(1, 1));

TabSetting.setBackground(new java.awt.Color(250, 255, 245));
TabSetting.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(230, 235, 225)));
TabSetting.setForeground(new java.awt.Color(90,120,80));
TabSetting.setForeground(new java.awt.Color(90, 120, 80));
TabSetting.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N
TabSetting.setName("TabSetting"); // NOI18N
TabSetting.addMouseListener(new java.awt.event.MouseAdapter() {
@@ -495,7 +495,7 @@ public void keyPressed(java.awt.event.KeyEvent evt) {

DTPCari1.setEditable(false);
DTPCari1.setForeground(new java.awt.Color(50, 70, 50));
DTPCari1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "26-11-2016" }));
DTPCari1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "15-01-2017" }));
DTPCari1.setDisplayFormat("dd-MM-yyyy");
DTPCari1.setName("DTPCari1"); // NOI18N
DTPCari1.setOpaque(false);
@@ -510,7 +510,7 @@ public void keyPressed(java.awt.event.KeyEvent evt) {

DTPCari2.setEditable(false);
DTPCari2.setForeground(new java.awt.Color(50, 70, 50));
DTPCari2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "26-11-2016" }));
DTPCari2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "15-01-2017" }));
DTPCari2.setDisplayFormat("dd-MM-yyyy");
DTPCari2.setName("DTPCari2"); // NOI18N
DTPCari2.setOpaque(false);
@@ -395,7 +395,7 @@ public void windowActivated(java.awt.event.WindowEvent evt) {
}
});

internalFrame1.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(240, 245, 235)), "::[ Transaksi Penyerahan Darah ]::", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90,120,80))); // NOI18N
internalFrame1.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(240, 245, 235)), "::[ Transaksi Penyerahan Darah ]::", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90, 120, 80))); // NOI18N
internalFrame1.setName("internalFrame1"); // NOI18N
internalFrame1.setLayout(new java.awt.BorderLayout(1, 1));

@@ -658,7 +658,7 @@ public void actionPerformed(java.awt.event.ActionEvent evt) {
panelisi6.setPreferredSize(new java.awt.Dimension(450, 77));
panelisi6.setLayout(new java.awt.GridLayout(2, 0));

jPanel3.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(237, 242, 232)), ".: Penggunaan BHP Medis ", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90,120,80))); // NOI18N
jPanel3.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(237, 242, 232)), ".: Penggunaan BHP Medis ", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90, 120, 80))); // NOI18N
jPanel3.setName("jPanel3"); // NOI18N
jPanel3.setOpaque(false);
jPanel3.setPreferredSize(new java.awt.Dimension(300, 102));
@@ -742,7 +742,7 @@ public void keyPressed(java.awt.event.KeyEvent evt) {

panelisi6.add(jPanel3);

jPanel4.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(237, 242, 232)), ".: Penggunaan BHP Non Medis ", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90,120,80))); // NOI18N
jPanel4.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(237, 242, 232)), ".: Penggunaan BHP Non Medis ", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90, 120, 80))); // NOI18N
jPanel4.setName("jPanel4"); // NOI18N
jPanel4.setOpaque(false);
jPanel4.setPreferredSize(new java.awt.Dimension(300, 202));
@@ -350,7 +350,7 @@
<Property name="editable" type="boolean" value="false"/>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="16-01-2017"/>
<StringItem index="0" value="21-02-2018"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -384,7 +384,7 @@
<Property name="editable" type="boolean" value="false"/>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="16-01-2017"/>
<StringItem index="0" value="21-02-2018"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy"/>
@@ -234,7 +234,7 @@ public void windowOpened(java.awt.event.WindowEvent evt) {
}
});

internalFrame1.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(240, 245, 235)), "::[ Data Stok Darah ]::", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90,120,80))); // NOI18N
internalFrame1.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(240, 245, 235)), "::[ Data Stok Darah ]::", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(90, 120, 80))); // NOI18N
internalFrame1.setName("internalFrame1"); // NOI18N
internalFrame1.setLayout(new java.awt.BorderLayout(1, 1));

@@ -369,7 +369,7 @@ public void keyPressed(java.awt.event.KeyEvent evt) {
Resus.setBounds(294, 72, 60, 23);

Aftap.setEditable(false);
Aftap.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "12-01-2017" }));
Aftap.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "16-01-2017" }));
Aftap.setDisplayFormat("dd-MM-yyyy");
Aftap.setName("Aftap"); // NOI18N
Aftap.addKeyListener(new java.awt.event.KeyAdapter() {
@@ -387,7 +387,7 @@ public void keyPressed(java.awt.event.KeyEvent evt) {
label32.setBounds(0, 72, 85, 23);

Kadaluarsa.setEditable(false);
Kadaluarsa.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "12-01-2017" }));
Kadaluarsa.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "16-01-2017" }));
Kadaluarsa.setDisplayFormat("dd-MM-yyyy");
Kadaluarsa.setName("Kadaluarsa"); // NOI18N
Kadaluarsa.addKeyListener(new java.awt.event.KeyAdapter() {
@@ -48,6 +48,7 @@
session_start();
require_once('conf/conf.php');
require_once('updateaplicare.php');
require_once('./updatesiranap.php');
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
@@ -87,7 +88,7 @@
</object>
</noscript>
<?php
$setting= mysql_fetch_array(bukaquery("select nama_instansi,alamat_instansi,kabupaten,propinsi,kontak,email,logo from setting"));
$setting= mysqli_fetch_array(bukaquery("select nama_instansi,alamat_instansi,kabupaten,propinsi,kontak,email,logo from setting"));
echo "
<table width='100%' align='center' border='0' class='tbl_form' cellspacing='0' cellpadding='0'>
<tr>
@@ -129,29 +130,29 @@
$_sql="Select * From bangsal where status='1' and kd_bangsal in(select kd_bangsal from kamar)" ;
$hasil=bukaquery($_sql);

while ($data = mysql_fetch_array ($hasil)){
while ($data = mysqli_fetch_array ($hasil)){
echo "<tr class='isi7' >
<td align='left'><font size='5' color='#BB00BB' face='Tahoma'><b>".$data['nm_bangsal']."</b></font></td>
<td align='center'>
<font size='6' color='red' face='Tahoma'>
<b>";
$data2=mysql_fetch_array(bukaquery("select count(kd_bangsal) from kamar where kamar.statusdata='1' and kd_bangsal='".$data['kd_bangsal']."'"));
$data2=mysqli_fetch_array(bukaquery("select count(kd_bangsal) from kamar where kamar.statusdata='1' and kd_bangsal='".$data['kd_bangsal']."'"));
echo $data2[0];
echo "</b>
</font>
</td>
<td align='center'>
<font color='#DDDD00' size='6' face='Tahoma'>
<b>";
$data2=mysql_fetch_array(bukaquery("select count(kd_bangsal) from kamar where kamar.statusdata='1' and kd_bangsal='".$data['kd_bangsal']."' and status='ISI'"));
$data2=mysqli_fetch_array(bukaquery("select count(kd_bangsal) from kamar where kamar.statusdata='1' and kd_bangsal='".$data['kd_bangsal']."' and status='ISI'"));
echo $data2[0];
echo "</b>
</font>
</td>
<td align='center'>
<font color='gren' size='6' face='Tahoma'>
<b>";
$data2=mysql_fetch_array(bukaquery("select count(kd_bangsal) from kamar where kamar.statusdata='1' and kd_bangsal='".$data['kd_bangsal']."' and status='KOSONG'"));
$data2=mysqli_fetch_array(bukaquery("select count(kd_bangsal) from kamar where kamar.statusdata='1' and kd_bangsal='".$data['kd_bangsal']."' and status='KOSONG'"));
echo $data2[0];
echo "</b>
</font>
@@ -47,6 +47,7 @@
session_start();
require_once('conf/conf.php');
require_once('updateaplicare.php');
require_once('./updatesiranap.php');
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
@@ -86,7 +87,7 @@
</object>
</noscript>
<?php
$setting= mysql_fetch_array(bukaquery("select nama_instansi,alamat_instansi,kabupaten,propinsi,kontak,email,logo from setting"));
$setting= mysqli_fetch_array(bukaquery("select nama_instansi,alamat_instansi,kabupaten,propinsi,kontak,email,logo from setting"));
echo "
<table width='100%' align='center' border='0' class='tbl_form' cellspacing='0' cellpadding='0'>
<tr>
@@ -124,29 +125,29 @@
$_sql="Select kelas from kamar where statusdata='1' group by kelas" ;
$hasil=bukaquery($_sql);

while ($data = mysql_fetch_array ($hasil)){
while ($data = mysqli_fetch_array ($hasil)){
echo "<tr class='isi7' >
<td align='left'><font size='5' color='#BB00BB' face='Tahoma'><b>".$data['kelas']."</b></font></td>
<td align='center'>
<font size='6' color='red' face='Tahoma'>
<b>";
$data2=mysql_fetch_array(bukaquery("select count(kelas) from kamar where statusdata='1' and kelas='".$data['kelas']."'"));
$data2=mysqli_fetch_array(bukaquery("select count(kelas) from kamar where statusdata='1' and kelas='".$data['kelas']."'"));
echo $data2[0];
echo "</b>
</font>
</td>
<td align='center'>
<font color='#DDDD00' size='6' face='Tahoma'>
<b>";
$data2=mysql_fetch_array(bukaquery("select count(kelas) from kamar where statusdata='1' and kelas='".$data['kelas']."' and status='ISI'"));
$data2=mysqli_fetch_array(bukaquery("select count(kelas) from kamar where statusdata='1' and kelas='".$data['kelas']."' and status='ISI'"));
echo $data2[0];
echo "</b>
</font>
</td>
<td align='center'>
<font color='gren' size='6' face='Tahoma'>
<b>";
$data2=mysql_fetch_array(bukaquery("select count(kelas) from kamar where statusdata='1' and kelas='".$data['kelas']."' and status='KOSONG'"));
$data2=mysqli_fetch_array(bukaquery("select count(kelas) from kamar where statusdata='1' and kelas='".$data['kelas']."' and status='KOSONG'"));
echo $data2[0];
echo "</b>
</font>
@@ -3,6 +3,7 @@
session_start();
require_once('conf/conf.php');
require_once('updateaplicare.php');
require_once('./updatesiranap.php');
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
@@ -42,7 +43,7 @@
</object>
</noscript>
<?php
$setting= mysql_fetch_array(bukaquery("select nama_instansi,alamat_instansi,kabupaten,propinsi,kontak,email,logo from setting"));
$setting= mysqli_fetch_array(bukaquery("select nama_instansi,alamat_instansi,kabupaten,propinsi,kontak,email,logo from setting"));
echo "
<table width='100%' align='center' border='0' class='tbl_form' cellspacing='0' cellpadding='0'>
<tr>
@@ -85,29 +86,29 @@
$_sql="Select * From bangsal where status='1' and kd_bangsal in(select kd_bangsal from kamar)" ;
$hasil=bukaquery($_sql);

while ($data = mysql_fetch_array ($hasil)){
while ($data = mysqli_fetch_array ($hasil)){
echo "<tr class='isi7' >
<td align='left'><font size='5' color='#BB00BB' face='Tahoma'><b>".$data['nm_bangsal']."</b></font></td>
<td align='center'>
<font size='6' color='red' face='Tahoma'>
<b>";
$data2=mysql_fetch_array(bukaquery("select count(kd_bangsal) from kamar where kamar.statusdata='1' and kd_bangsal='".$data['kd_bangsal']."'"));
$data2=mysqli_fetch_array(bukaquery("select count(kd_bangsal) from kamar where kamar.statusdata='1' and kd_bangsal='".$data['kd_bangsal']."'"));
echo $data2[0];
echo "</b>
</font>
</td>
<td align='center'>
<font color='#DDDD00' size='6' face='Tahoma'>
<b>";
$data2=mysql_fetch_array(bukaquery("select count(kd_bangsal) from kamar where kamar.statusdata='1' and kd_bangsal='".$data['kd_bangsal']."' and status='ISI'"));
$data2=mysqli_fetch_array(bukaquery("select count(kd_bangsal) from kamar where kamar.statusdata='1' and kd_bangsal='".$data['kd_bangsal']."' and status='ISI'"));
echo $data2[0];
echo "</b>
</font>
</td>
<td align='center'>
<font color='gren' size='6' face='Tahoma'>
<b>";
$data2=mysql_fetch_array(bukaquery("select count(kd_bangsal) from kamar where kamar.statusdata='1' and kd_bangsal='".$data['kd_bangsal']."' and status='KOSONG'"));
$data2=mysqli_fetch_array(bukaquery("select count(kd_bangsal) from kamar where kamar.statusdata='1' and kd_bangsal='".$data['kd_bangsal']."' and status='KOSONG'"));
echo $data2[0];
echo "</b>
</font>
@@ -3,6 +3,7 @@
session_start();
require_once('conf/conf.php');
require_once('updateaplicare.php');
require_once('./updatesiranap.php');
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
@@ -42,7 +43,7 @@
</object>
</noscript>
<?php
$setting= mysql_fetch_array(bukaquery("select nama_instansi,alamat_instansi,kabupaten,propinsi,kontak,email,logo from setting"));
$setting= mysqli_fetch_array(bukaquery("select nama_instansi,alamat_instansi,kabupaten,propinsi,kontak,email,logo from setting"));
echo "
<table width='100%' align='center' border='0' class='tbl_form' cellspacing='0' cellpadding='0'>
<tr>
@@ -85,29 +86,29 @@
$_sql="Select kelas from kamar where statusdata='1' group by kelas" ;
$hasil=bukaquery($_sql);

while ($data = mysql_fetch_array ($hasil)){
while ($data = mysqli_fetch_array ($hasil)){
echo "<tr class='isi7' >
<td align='left'><font size='5' color='#BB00BB' face='Tahoma'><b>".$data['kelas']."</b></font></td>
<td align='center'>
<font size='6' color='red' face='Tahoma'>
<b>";
$data2=mysql_fetch_array(bukaquery("select count(kelas) from kamar where statusdata='1' and kelas='".$data['kelas']."'"));
$data2=mysqli_fetch_array(bukaquery("select count(kelas) from kamar where statusdata='1' and kelas='".$data['kelas']."'"));
echo $data2[0];
echo "</b>
</font>
</td>
<td align='center'>
<font color='#DDDD00' size='6' face='Tahoma'>
<b>";
$data2=mysql_fetch_array(bukaquery("select count(kelas) from kamar where statusdata='1' and kelas='".$data['kelas']."' and status='ISI'"));
$data2=mysqli_fetch_array(bukaquery("select count(kelas) from kamar where statusdata='1' and kelas='".$data['kelas']."' and status='ISI'"));
echo $data2[0];
echo "</b>
</font>
</td>
<td align='center'>
<font color='gren' size='6' face='Tahoma'>
<b>";
$data2=mysql_fetch_array(bukaquery("select count(kelas) from kamar where statusdata='1' and kelas='".$data['kelas']."' and status='KOSONG'"));
$data2=mysqli_fetch_array(bukaquery("select count(kelas) from kamar where statusdata='1' and kelas='".$data['kelas']."' and status='KOSONG'"));
echo $data2[0];
echo "</b>
</font>
@@ -3,6 +3,7 @@
session_start();
require_once('conf/conf.php');
require_once('updateaplicare.php');
require_once('./updatesiranap.php');
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
@@ -11,7 +12,7 @@
date_default_timezone_set("Asia/Bangkok");
$tanggal= mktime(date("m"),date("d"),date("Y"));
$jam=date("H:i");
$setting= mysql_fetch_array(bukaquery("select nama_instansi,alamat_instansi,kabupaten,propinsi,kontak,email,logo from setting"));
$setting= mysqli_fetch_array(bukaquery("select nama_instansi,alamat_instansi,kabupaten,propinsi,kontak,email,logo from setting"));
?>
<!DOCTYPE html>
<html>
@@ -98,7 +99,7 @@
and jadwal.kd_poli=poliklinik.kd_poli where jadwal.hari_kerja='$namahari'" ;
$hasil=bukaquery($_sql);

while ($data = mysql_fetch_array ($hasil)){
while ($data = mysqli_fetch_array ($hasil)){
echo "<tr>
<td><b>".$data['nm_dokter']."</b></td>
<td><b>".$data['nm_poli']."</b></td>
@@ -129,29 +130,29 @@
$_sql="Select kelas from kamar where statusdata='1' group by kelas" ;
$hasil=bukaquery($_sql);

while ($data = mysql_fetch_array ($hasil)){
while ($data = mysqli_fetch_array ($hasil)){
echo "<tr class='isi7' >
<td align='left'><b>".$data['kelas']."</b></td>
<td align='center'>
<font color='gren'>
<b>";
$data2=mysql_fetch_array(bukaquery("select count(kelas) from kamar where statusdata='1' and kelas='".$data['kelas']."'"));
$data2=mysqli_fetch_array(bukaquery("select count(kelas) from kamar where statusdata='1' and kelas='".$data['kelas']."'"));
echo $data2[0];
echo "</b>
</font>
</td>
<td align='center'>
<font color='red'>
<b>";
$data2=mysql_fetch_array(bukaquery("select count(kelas) from kamar where statusdata='1' and kelas='".$data['kelas']."' and status='ISI'"));
$data2=mysqli_fetch_array(bukaquery("select count(kelas) from kamar where statusdata='1' and kelas='".$data['kelas']."' and status='ISI'"));
echo $data2[0];
echo "</b>
</font>
</td>
<td align='center'>
<font color='#FF8C00'>
<b>";
$data2=mysql_fetch_array(bukaquery("select count(kelas) from kamar where statusdata='1' and kelas='".$data['kelas']."' and status='KOSONG'"));
$data2=mysqli_fetch_array(bukaquery("select count(kelas) from kamar where statusdata='1' and kelas='".$data['kelas']."' and status='KOSONG'"));
echo $data2[0];
echo "</b>
</font>
@@ -179,7 +180,7 @@
<?php
$sql ="SELECT kelas, trf_kamar FROM kamar WHERE statusdata='1' GROUP BY kelas";
$hasil=bukaquery($sql);
while ($data = mysql_fetch_array ($hasil)){
while ($data = mysqli_fetch_array ($hasil)){
?>
<span class="marquee-content-items">| <?= $data['kelas'];?> Rp <?= number_format($data['trf_kamar'], 0, ".",",");?></span>
<?php } ?>