";
include "model/koneksi.php"; {
$awal = date('Y-m-d H:i:s', strtotime($_GET['awal']));
$akhir = date('Y-m-d H:i:s', strtotime($_GET['akhir']));
$query = "SELECT * FROM tb_indikator_mutu WHERE tanggal BETWEEN '$awal' AND '$akhir'";
$d_gelang = mysqli_num_rows(mysqli_query($open, "SELECT * FROM datapasien WHERE tanggal BETWEEN '$awal' AND '$akhir' AND NOT status_keluar like '%delete%'"));
$hitung_gelang = mysqli_num_rows(mysqli_query($openinmut, "SELECT keterangan FROM tb_indikator_mutu WHERE tanggal BETWEEN '$awal' AND '$akhir' AND keterangan ='gelang_id'"));
$num_gelang = mysqli_num_rows(mysqli_query($openinmut, "$query AND question1=1 AND question2=1"));
echo "";
echo " | 1 | ";
echo " Audit pemahaman terhadap pemakaian gelang identitas pasien ( n= $hitung_gelang responden) | ";
echo " $num_gelang | ";
if ($d_gelang > 0) {
$d_gelang_result = number_format($d_gelang / 10);
$per_gelang = number_format((($num_gelang / $d_gelang_result) * 100), 2);
echo " $d_gelang_result | ";
echo " $per_gelang % | ";
} else {
echo " - | ";
echo " - | ";
}
echo " 90 % | ";
echo " | ";
echo "
";
$num_paps = mysqli_num_rows(mysqli_query($openinmut, "$query AND paps=1"));
$num_los = mysqli_num_rows(mysqli_query($openinmut, "$query AND los=1"));
$num_ktd = mysqli_num_rows(mysqli_query($openinmut, "$query AND insiden=1 AND keterangan='ktd'"));
$num_knc = mysqli_num_rows(mysqli_query($openinmut, "$query AND insiden=1 AND keterangan='knc'"));
$num_inf_con = mysqli_num_rows(mysqli_query($openinmut, "$query AND inf_con=1"));
$num_site_mark = mysqli_num_rows(mysqli_query($openinmut, "$query AND site_mark=1"));
$num_tranfusi = mysqli_num_rows(mysqli_query($openinmut, "SELECT * FROM tb_tranfusi WHERE tanggal BETWEEN '$awal' AND '$akhir' AND reaksi=1"));
$num_sc = mysqli_num_rows(mysqli_query($openinmut, "$query AND timeinterval=1"));
$num_identifikasi = mysqli_num_rows(mysqli_query($openinmut, "$query AND identifikasi=1 "));
$denum_identifikasi = mysqli_num_rows(mysqli_query($open, "SELECT * FROM datapasien WHERE tanggal BETWEEN '$awal' AND '$akhir' AND NOT status_keluar like '%delete%'"));
echo "";
echo " | 2 | ";
echo " Identifikasi pasien ( n= $num_identifikasi responden) | ";
echo " $num_identifikasi | ";
if ($denum_identifikasi > 0) {
$denum_identifikasi_result = number_format($denum_identifikasi / 10);
$per_identifikasi = number_format((($num_identifikasi / $denum_identifikasi_result) * 100), 2);
echo " $denum_identifikasi_result | ";
echo " $per_identifikasi % | ";
} else {
echo " - | ";
echo " - | ";
}
echo "100 % | ";
echo " | ";
echo "
";
$denum_sc = mysqli_num_rows(mysqli_query($open, "SELECT * FROM datapasien INNER JOIN tb_maternal ON datapasien.id_pasien=tb_maternal.id_pasien WHERE tanggal BETWEEN '$awal' AND '$akhir' AND jenis_persalinan like '%sc%' AND NOT status_keluar like '%delete%'"));
echo "";
echo "| 3 | ";
echo " Respon-Time SC Emergency | ";
echo " $num_sc | ";
echo " $denum_sc | ";
if ($denum_sc > 0) {
$per_sc = number_format((($num_sc / $denum_sc) * 100), 2);
echo " $per_sc % | ";
} else {
echo " - | ";
}
echo "80 % | ";
echo " | ";
echo "
";
$denum_tranfusi = mysqli_num_rows(mysqli_query($openinmut, "SELECT * FROM tb_tranfusi WHERE tanggal BETWEEN '$awal' AND '$akhir'"));
echo "";
echo "| 4 | ";
echo " Angka Kejadian reaksi tranfusi | ";
echo " $num_tranfusi | ";
echo " $denum_tranfusi | ";
if ($denum_tranfusi > 0) {
$per_tranfusi = number_format((($num_tranfusi / $denum_tranfusi) * 100), 2);
echo " $per_tranfusi % | ";
} else {
echo " - | ";
}
echo "0 % | ";
echo " | ";
echo "
";
$denum_paps = mysqli_num_rows(mysqli_query($open, "SELECT * FROM datapasien WHERE tanggal BETWEEN '$awal' AND '$akhir' AND NOT status_keluar like '%delete%' "));
echo "";
echo "| 5 | ";
echo " Pulang Atas Permintaan Sendiri | ";
echo " $num_paps | ";
echo " $denum_paps | ";
if ($denum_paps > 0) {
$per_paps = number_format((($num_paps / $denum_paps) * 100), 2);
echo " $per_paps % | ";
} else {
echo " - | ";
}
echo "< 5 % | ";
echo " | ";
echo "
";
$denum_los = mysqli_num_rows(mysqli_query($open, "SELECT * FROM datapasien WHERE tanggal BETWEEN '$awal' AND '$akhir' AND NOT status_keluar like '%delete%'"));
echo "";
echo "| 6 | ";
echo " Ketepatan Waktu Pelayanan IGD 《 6 jam | ";
echo " $num_los | ";
echo " $denum_los | ";
if ($denum_los > 0) {
$per_los = number_format((($num_los / $denum_los) * 100), 2);
echo " $per_los % | ";
} else {
echo " - | ";
}
echo "60 % | ";
echo " | ";
echo "
";
$denum_ktd = mysqli_num_rows(mysqli_query($openinmut, "SELECT * FROM tb_indikator_mutu WHERE tanggal BETWEEN '$awal' AND '$akhir' AND insiden_ctrl=1 AND keterangan='ktd'"));
echo "";
echo "| 7 | ";
echo " Kepatuhan pelaporan kejadian tidak diharapkan ( KTD ) | ";
echo " $num_ktd | ";
echo " $denum_ktd | ";
if ($denum_ktd > 0) {
$per_ktd = number_format((($num_ktd / $denum_ktd) * 100), 2);
echo " $per_ktd % | ";
} else {
echo " - | ";
}
echo "100 % | ";
echo " | ";
echo "
";
$denum_knc = mysqli_num_rows(mysqli_query($openinmut, "SELECT * FROM tb_indikator_mutu WHERE tanggal BETWEEN '$awal' AND '$akhir' AND insiden_ctrl=1 AND keterangan='knc'"));
echo "";
echo "| 8 | ";
echo " Kepatuhan pelaporan kejadian nyaris cedera ( KNC ) | ";
echo " $num_knc | ";
echo " $denum_knc | ";
if ($denum_knc > 0) {
$per_knc = number_format((($num_knc / $denum_knc) * 100), 2);
echo " $per_knc % | ";
} else {
echo " - | ";
}
echo " 100 % | ";
echo " | ";
echo "
";
$denum_inf_con = mysqli_num_rows(mysqli_query($open, "SELECT * FROM datapasien INNER JOIN tb_tindakan ON datapasien.id_pasien=tb_tindakan.id_pasien WHERE tanggal BETWEEN '$awal' AND '$akhir' AND tindakan like '%IMTIGD_08%' AND NOT status_keluar like '%delete%'"));
echo "";
echo "| 9 | ";
echo " Kelengkapan Informed Consent | ";
echo " $num_inf_con | ";
echo " $denum_inf_con | ";
if ($denum_inf_con > 0) {
$per_inf_con = number_format((($num_inf_con / $denum_inf_con) * 100), 2);
echo " $per_inf_con % | ";
} else {
echo " - | ";
}
echo " 100 % | ";
echo " | ";
echo "
";
$denum_site_mark = mysqli_num_rows(mysqli_query($open, "SELECT * FROM datapasien WHERE tanggal BETWEEN '$awal' AND '$akhir' AND status_keluar like '%OK%' AND NOT status_keluar like '%delete%'"));
echo "";
echo "| 10 | ";
echo " Site Mark ( penandaan area yang akan dioperasi ) | ";
echo " $num_site_mark | ";
echo " $denum_site_mark | ";
if ($denum_site_mark > 0) {
$per_site_mark = number_format((($num_site_mark / $denum_site_mark) * 100), 2);
echo " $per_site_mark % | ";
} else {
echo " - | ";
}
echo " 100 % | ";
echo " | ";
echo "
";
}
echo "";
echo "