37 lines
2.3 KiB
PHP
37 lines
2.3 KiB
PHP
<?php
|
|
header("Content-Type: application/json; charset=UTF-8");
|
|
|
|
include "model/koneksi.php";
|
|
session_start();
|
|
|
|
$ruang = $_POST['ruang'];
|
|
$obj = $_POST['awal'];
|
|
$objs = $_POST['akhir'];
|
|
|
|
|
|
if($_POST['kriteria']=='referral'){
|
|
$stmt = $open->prepare("SELECT id_pasien, nama,register,tanggal,triage,smf,status_keluar,nik,file_text,perawat_ppa,waiting,jam_keluar, keterangan ,kedatangan,rujukan FROM datapasien WHERE kedatangan = 'Rujukan' AND ruang ='$ruang' AND tanggal BETWEEN '$_POST[awal]'AND'$_POST[akhir]' ORDER BY id_pasien ");
|
|
}
|
|
if($_POST['kriteria']=='all'){
|
|
$stmt = $open->prepare("SELECT id_pasien, nama,register,tanggal,triage,smf,status_keluar,nik,file_text,perawat_ppa,waiting,jam_keluar, keterangan ,kedatangan,rujukan FROM datapasien WHERE ruang ='$ruang' AND tanggal BETWEEN '$_POST[awal]'AND'$_POST[akhir]' OR ruang ='$ruang' AND jam_keluar BETWEEN '$_POST[awal]'AND'$_POST[akhir]' OR status_tunggu='menunggu' AND ruang ='$ruang' ORDER BY id_pasien ");
|
|
}
|
|
if($_POST['kriteria']=='date_in'){
|
|
$stmt = $open->prepare("SELECT id_pasien, nama,register,tanggal,triage,smf,status_keluar,nik,file_text,perawat_ppa,waiting,jam_keluar, keterangan,kedatangan,rujukan FROM datapasien WHERE ruang ='$ruang' AND tanggal BETWEEN '$_POST[awal]'AND'$_POST[akhir]'");
|
|
}
|
|
if($_POST['kriteria']=='date_out'){
|
|
$stmt = $open->prepare("SELECT id_pasien, nama,register,tanggal,triage,smf,status_keluar,nik,file_text,perawat_ppa,waiting, jam_keluar,keterangan,kedatangan,rujukan FROM datapasien WHERE ruang ='$ruang' AND jam_keluar BETWEEN '$_POST[awal]'AND'$_POST[akhir]'");
|
|
}
|
|
// $kriteria= $.($_POST['kriteria']);
|
|
|
|
// $all="ruang =$ruang AND tanggal BETWEEN $_POST['awal']AND $_POST['akhir'] OR ruang =$ruang AND jam_keluar BETWEEN $_POST['awal']AND $_POST['akhir'] OR status_tunggu=menunggu AND ruang =$ruang";
|
|
// $date_in=" ruang ='$ruang' AND tanggal BETWEEN '$_POST[awal]'AND'$_POST[akhir]' ";
|
|
// $date_out=" ruang ='$ruang' AND jam_keluar BETWEEN '$_POST[awal]'AND'$_POST[akhir]' OR status_tunggu='menunggu' AND ruang ='$ruang'";
|
|
|
|
|
|
// $stmt = $open->prepare("SELECT id_pasien, nama,register,tanggal,triage,smf,status_keluar,nik,file_text,perawat_ppa,waiting, keterangan FROM datapasien WHERE $kriteria");
|
|
$stmt->execute();
|
|
$result = $stmt->get_result();
|
|
$outp = $result->fetch_all(MYSQLI_ASSOC);
|
|
|
|
echo json_encode($outp);
|