Files
2024-04-19 14:04:41 +07:00

451 lines
16 KiB
PHP

<?php
include '../core/main.php';
header("Content-Type: text/html; charset=ISO-8859-15");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
//login validasi
if(!empty($_GET['NIP'])){
$ip = getRealIpAddr();
$db->query('delete from tmp_cartbayar where IP = \''.$ip.'\'');
$db->query('delete from tmp_orderpenunjang where ip = \''.$ip.'\'');
$db->query('delete from tmp_cartresep where IP = \''.$ip.'\'');
$sql = "SELECT * FROM m_login WHERE NIP = '".$_GET['NIP']."'";
$query = $db->query($sql);
$data = $query->fetchAll()[0];
$NIP = $data['NIP'];
$KDUNIT = $data['KDUNIT'];
if($_GET['NIP'] == $NIP){
$_SESSION['NIP'] = $NIP;
$_SESSION['KDUNIT'] = $KDUNIT;
$status_login = ($data['KDDOKTER'] != 0 && $data['ROLES'] == 4) ? 'dokter' : (($data['KDPERAWAT'] != 0) ? 'perawat' : 'umum');
$hidden_form = '<input type="hidden" id="status_login" name="status_login" value="'.$status_login.'">';
echo "<font color='green'> USERNAME Valid</font>".$hidden_form;
}else{
echo "<font color='red'> USERNAME Tidak Valid</font>";
}
}
if(!empty($_GET['PWD'])){
$NIP1 = $_SESSION['NIP'];
$sql = "SELECT * FROM m_login WHERE NIP = '".$NIP1."' AND PWD = '".$_GET['PWD']."'";
$query = $db->query($sql);
$data = $query->fetchAll()[0];
$PWD2 = $_GET['PWD'];
$PWD = $data['PWD'];
$SES_REG = $data['SES_REG'];
if($_GET['PWD'] == $PWD){
$_SESSION['SES_REG'] = $SES_REG;
?>
<script>
jQuery(document).ready(function(event){
jQuery("#PWD").keyup(function(event){
if(event.keyCode == 13){
jQuery("#LOGIN").click();
}
});
});
</script>
<input type="button" onclick="window.location='user_level.php';" value=" LOGIN " class=" text " name="LOGIN" id="LOGIN"/>
<?php
}else{
echo"<font color='red'>PASSWORD Tidak Valid</font>";
}
}
//kondisi total list-----------------------------------------------------------------------------------
if(!empty($_GET['code'])){
if($_GET['code']){
$sql = "SELECT * FROM m_tarif WHERE kode = '".htmlspecialchars($_GET['code'])."'";
$query = $db->query($sql);
$data = $query->fetchAll()[0];
$_SESSION['cart'][$data['tarif']];
echo "<br /><strong>TOTAL : Rp. ".number_format($_SESSION['cart'], 0)." <input type='submit' value=' chex ' class=' text '></strong>";
}
}
if(!empty($_GET['edit_pasien'])){
echo"data pasien di edit ";
}
//kondisi cek no rm PENDAFTARAN-----------------------------------------------------------------------------
if(!empty($_GET['NOMR'])){
$sql = "SELECT * FROM m_pasien WHERE NOMR='".htmlspecialchars($_GET['NOMR'])."'";
$qry = $db->query($sql);
$data = $qry->fetchAll()[0];
$lihat = str_pad($_GET['NOMR'],8,"0",STR_PAD_LEFT);
if($lihat == $data['NOMR']){
$_SESSION['kosong'] = "";
$_SESSION['new_nomr'] ="";
include("function.php");
include("view_prosess.php");
}else{
//$_SESSION['new_nomr'] = str_pad($_GET['NOMR'],6,"0",STR_PAD_LEFT);
$_SESSION['new_nomr'] = $_GET['NOMR'];
$_SESSION['kosong'] = "Data No MR tidak Ditemukan";
include("function.php");
include("view_prosess.php");
}
}
if(!empty($_GET['psn'])){
$sql = "SELECT *
FROM m_pasien
WHERE NOMR='".$_GET['psn']."'";
// var_dump($sql);exit;
$qry = $db->query($sql);
if($qry->numRows() > 0) {
$data = $qry->fetchAll()[0];
$lihat = $_GET['psn'];
#print_r($lihat);
if($lihat == $data['nomr']){
#if($qry->numRows() > 0){
$r = 0;
$a = datediff($data['tgllahir'],date("Y-m-d"));
$umur = $a['years']." tahun ".$a['months']." bulan ".$a['days']." hari";
$nama = explode(',',str_replace('.',' ',$data['nama']));
$CleanArray = TrimArray($nama);
//$a = array('Tn.','Ny.','Nn.','An.');
if(array_search('Tn',$CleanArray)){
$title = 'Tn';
}elseif(array_search('Nn',$CleanArray)){
$title = 'Nn';
}elseif(array_search('Ny',$CleanArray)){
$title = 'Ny';
}elseif(array_search('An',$CleanArray)){
$title = 'An';
}
echo $r.'|'.
$data['nomr'].'|'.
$nama[0].'|'.
$data['tempat'].'|'.
$data['tgllahir'].'|'.
strtoupper($data['jeniskelamin']).'|'.
$data['alamat'].'|'.
$data['kelurahan'].'|'.
$data['kdkecamatan'].'|'.
$data['kota'].'|'.
$data['kdprovinsi'].'|'.
$data['notelp'].'|'.
$data['noktp'].'|'.
$data['suami_ortu'].'|'.$data['pekerjaan'].'|'.$data['status'].'|'.$data['agama'].'|'.$data['pendidikan'].'|'.$data['kdcarabayar'].'|'.$data['alamat_ktp'].'|'.$umur.'|'.$title.'|'.$data['penanggungjawab_nama'].'|'.$data['penanggungjawab_hubungan'].'|'.$data['penanggungjawab_alamat'].'|'.$data['penanggungjawab_phone'].'|'.$data['no_kartu'].'|'.$data['jns_pasien'].'|'.$data['kdprovider'].'|'.$data['nmprovider'].'|'.$data['kelas'].'|'.$data['bahasa'].'|'.$data['kebangsaan'].'|'.$data['notelprumah1'].'|'.$data['notelprumah2'].'|'.$data['notelpkantor'].'|'.$data['no_hp'].'|'.$data['asal_masuk'].'|'.strtolower($data['buta_huruf']).'|'.strtolower($data['hambatan_komunikasi']).'|'.$data['sim'].'|'.$data['paspor'].'|'.$data['st_disabilitas'].'|'.$data['disabilitas'].'|'.$data['st_identitas_ortu'].'|'.$data['nama_ayah'].'|'.$data['nama_ibu'].'|'.$data['pendidikan_ayah'].'|'.$data['pendidikan_ibu'].'|'.(($data['ktp_file'] != '') ? base64_encode($data['ktp_file']) : '').'|'.(($data['kk_file'] != '') ? base64_encode($data['kk_file']) : '');
}else{
$r = 1;
echo $r.'|'.$data['nomr'].'|'.$data['nama'];
}
}
else {
$r = 1;
echo $r.'|-|';
}
}
#echo '<input type="hidden" name="PASIENBARU" id="PASIENBARU" value="'.$r.'">';
#echo '<input type="radio" name="STATUSPASIEN" id="STATUSPASIEN" class="statuspasien" value="1" '.if($r != '0'): echo'checked="checked"'; endif;.'> Pasien Baru';
#echo '<input type="radio" name="STATUSPASIEN" id="STATUSPASIEN" class="statuspasien" value="0" '.if($r == '0'): echo'checked="checked"'; endif;.'> Pasien Lama';
//kondisi get no mr untuk pembayaran
//kondisi cek no rm----------------------------------------------------------------------------------
if(!empty($_GET['cek_rm'])){
$sql = "SELECT a.NOMR,b.NAMA
FROM t_pendaftaran a, m_pasien b
where tglreg=current_date() and a.nomr=b.nomr and a.nomr='".htmlspecialchars($_GET['cek_rm'])."'";
$qry = $db->query($sql);
$data = $qry->fetchAll()[0];
if($_GET['cek_rm'] == $data['NOMR']){
echo "<input type='text' class='text' name='NAMA' value='". $data['NAMA'] ."'> No Rm
<input type='text' class='text' name='NAMA' value='". $data['NOMR'] ."'> ";
}else{
//echo "<input type='text' class='text' name='NAMA'> Data No MR tidak Ditemukan";
}
}
//kondisi cek poli -------------------------------------------------------------------------------------------------
if(!empty($_GET['jadwal_dokter'])){
if($_GET['jadwal_dokter']){
$sql = "SELECT * FROM m_dokter WHERE KDPOLY='".htmlspecialchars($_GET['jadwal_dokter'])."'";
$qry = $db->query($sql);
echo "<select name=\"KDDOKTER\" class='text'>";
foreach($qry->fetchAll() as $data){
echo "<option nama='".$data['KDDOKTER']."' value='".$data['KDDOKTER']."'>".$data['NAMADOKTER']."</option>";
}
echo "</select>";
}
}
//searching pasien---------------------------------------------------------------------------------
if(!empty($_GET['search'])){
if($_GET['search']){
echo $pos = strpos($_GET['search'],'.');
?>
<table width="95%" style="margin:10px;" border="0" cellspacing="0" cellspading="0">
<tr align="center">
<th>NO RM</th>
<th>Nama Pasien</th>
<th>Tempat Tanggal lahir</th>
<th>Alamat</th>
<th>Jenis Kelamin</th>
<th>No telepon</th>
<th>Edit</th>
</tr>
<?php
if (substr($_GET['search'],0,$pos)=='nomr' ){
$sql="SELECT *
FROM m_pasien
WHERE NOMR like '".substr($_GET['search'],$pos+1,strlen($_GET['search'])-$pos)."%'";
}
if (substr($_GET['search'],0,$pos)=='nama' ){
$sql="SELECT *
FROM m_pasien
WHERE NAMA like '".substr($_GET['search'],$pos+1,strlen($_GET['search'])-$pos)."%'";
}
if (substr($_GET['search'],0,$pos)=='alamat' ){
$sql="SELECT *
FROM m_pasien
WHERE ALAMAT like '".substr($_GET['search'],$pos+1,strlen($_GET['search'])-$pos)."%'";
}
if (substr($_GET['search'],0,$pos)=='telepon' ){
$sql="SELECT *
FROM m_pasien
WHERE NOTELP like '".substr($_GET['search'],$pos+1,strlen($_GET['search'])-$pos)."%'";
}
$pager = paginate( $sql, 15, 5, "param1=valu1&param2=value2");
//The paginate() function returns a mysql result set
foreach($pager['list'] as $data) {?>
<tr <?php echo "class =";
$count++;
if ($count % 2) {
echo "tr1"; }
else {
echo "tr2";
}
?>
<td><?php echo $data['NOMR'];?></td>
<td><?php echo $data['NAMA']; ?></td>
<td><?php echo $data['TGLLAHIR']; ?></td>
<td><?php echo $data['ALAMAT']; ?></td>
<td><?php if($data['JENISKELAMIN']=="l" || $data['JENISKELAMIN']=="L"){echo"Laki-Laki";}else{echo"Perempuan";} ?></td>
<td><?php echo $data['NOTELP'] ?></td>
<td align="center"><a href="?link=24&NOMR=<?=$data['NOMR'];?>">edit pasien</a></td>
</tr>
<?php } ?>
</table>
<?php
//Display the full navigation in one go
echo $pager['nav'];
?>
</table>
<?php
}
}
//cari_poly----------------------------------------------------------------------------------
if(!empty($_POST['poly']) && !empty($_POST['TGLREG'])){
if(!empty($_POST['TGLREG'])){
$tgl_reg = $_POST['TGLREG'];
}else{
$tgl_reg =date('Y/m/d');
}
?>
<table width="95%" style="margin:10px;" border="0" cellspacing="0" cellspading="0" title="List Kunjungan Data Pasien Per Hari Ini">
<tr align="center">
<th>NO RM</th>
<th>Nama Pasien</th>
<th>Alamat</th>
<th>Poly</th>
<th>Cara Bayar</th>
<th>Rujukan</th>
</tr>
<?php
$sql="SELECT A.NOMR,A.NAMA,A.ALAMAT,B.NAMA AS POLY1,C.NAMA AS CARABAYAR1,D.NAMA AS RUJUKAN1
FROM m_pasien A, m_poly B, m_carabayar C, m_rujukan D, t_pendaftaran E
WHERE A.NOMR=E.NOMR AND E.KDPOLY=".$_POST['poly']." AND E.KDRUJUK=D.KODE AND E.KDCARABAYAR=C.KODE AND E.KDPOLY=B.KODE AND E.TGLREG='$tgl_reg'";
$pager = paginate( $sql, 15, 5, "param1=valu1&param2=value2");
//The paginate() function returns a mysql result set
if(!$rs){ echo"<div class='tb'>anda belum memilih poly</div>";
}else{
foreach($pager['list'] as $data) {?>
<tr <?php echo "class =";
$count++;
if ($count % 2) {
echo "tr1"; }
else {
echo "tr2";
}
?>>
<td><?php echo $data['NOMR'];?></td>
<td><?php echo $data['NAMA']; ?></td>
<td><?php echo $data['ALAMAT']; ?></td>
<td><?php echo $data['POLY1']; ?></td>
<td><?php echo $data['CARABAYAR1'];?></td>
<td><?php echo $data['RUJUKAN1'];?></td>
</tr>
<?php }
//Display the full navigation in one go
echo $pager['nav'];
?>
</table>
<?php }
}
// cek nama pasien
if(!empty($_GET['NAMA'])){
if($_GET['NAMA']){
$sql_nama = "SELECT NAMA FROM m_pasien WHERE NAMA = '".$_GET['NAMA']."'";
$qry_nama = $db->query($sql_nama);
$data_nama = $qry_nama->fetchAll()[0];
if($data_nama['NAMA'] == $_GET['NAMA']){
?>
<input title="NAMA" disabled="disabled" class="text" type="text" <?php if($_GET['NAMA']){ echo"value='".$data_nama['NAMA']."'";} ?> name="NAMA" size="30" value="<?=$m_pasien->NAMA?>" id="NAMA" onblur="javascript: MyAjaxRequest('nam','include/process.php?NAMA=','NAMA');" /> <span style="color:#F00; font:bold;">Nama Pasien Telah Terdaftar</span>
<?php }
}
}
// switch case ----------------------------------------------------------------------------------------------
switch (array_key_exists('state', $_GET) && $_GET['state'])
{
case 'info':
echo "<p>Klik tarif Pilih untuk melihat Hasil / Total.<br> ".$_SESSION['total2']."</p>";
break;
case 'pendaftaran_val':
echo "test";
break;
case 'puskesmas':
echo " ket. <input name='KETRUJUK' id='KETRUJUK' type='text' size='20' class='text'>";
break;
case 'rs_lain':
echo " ket. <input type='text' name='KETRUJUK' id='KETRUJUK' size='20' class='text'>";
break;
case 'lain_lain':
echo " ket. <input type='text' name='KETRUJUK' id='KETRUJUK' size='20' class='text'>";
break;
case 'cetak':
$db->query("INSERT INTO t_cetak_data (IDXBILL,JUMLAH) VALUES('".$_GET['idxb']."','1')");
$sql_cetak = "SELECT sum(JUMLAH) AS JUMLAH FROM t_cetak_data WHERE IDXBILL='".$_GET['idxb']."'";
$qry_cetak = $db->query($sql_cetak);
$cetak = $qry_cetak->fetchAll()[0];
$_SESSION['cetak']=$cetak['JUMLAH'];
echo $cetak['JUMLAH'];
break;
case 'tgl_lahir':
$a = datediff($m_pasien->TGLLAHIR, date("Y-m-d"));
echo "<input type='text' value='umur ".$a['years']." tahun ".$a['months']." bulan ".$a['days']." hari' size='45' class='text'>";
break;
case 'list':
include("../list_data_pasien.php");
break;
case 'reset':
unset($_SESSION['total']);
unset($_SESSION['total2']);
echo "Record telah terhapus!";
break;
}
//update t_bayarrajal dari form keringanan
if(array_key_exists('idxb', $_REQUEST) && $_REQUEST['idxb']){
$tcount = $db->query('SELECT *, TARIFRS * QTY AS TOTAL FROM t_billrajal WHERE IDXBILL = "'.$_REQUEST['idxb'].'"');
$sisa = $_REQUEST['keringanan']; #10.000
$carabayar = $_REQUEST['carabayar'];
$arr_bill = array();
foreach($tcount->fetchAll() as $dt){
$arr_bill[] = $dt;
if($sisa > 0): # Jika keringanan > 0
$sisa_s = $sisa - $dt['TOTAL']; #10.000 - 100.000 = 0;
if($sisa_s > 0):
$t_billrajal = "UPDATE t_billrajal SET SHIFT='".$_POST['SHIFT']."', COSTSHARING = '".$dt['TOTAL']."', CARABAYAR = '".$carabayar."' WHERE IDXBILL='".$dt['IDXBILL']."'";
elseif($sisa_s < 0):
$t_billrajal = "UPDATE t_billrajal SET SHIFT='".$_POST['SHIFT']."', COSTSHARING = '".$sisa."', CARABAYAR = '".$carabayar."' WHERE IDXBILL='".$dt['IDXBILL']."'";
else:
$t_billrajal = "UPDATE t_billrajal SET SHIFT='".$_POST['SHIFT']."', COSTSHARING = '".$dt['TOTAL']."', CARABAYAR = '".$carabayar."' WHERE IDXBILL='".$dt['IDXBILL']."'";
endif;
execute($t_billrajal);
$sisa = $sisa_s;
endif;
}
$tbp = (array_key_exists('tbp', $_REQUEST)) ? $_REQUEST['tbp'] : NULL;
$t_bayarrajal = "UPDATE t_bayarrajal SET
TGLBAYAR='".date('Y-m-d')."',
JAMBAYAR='".date('H:i:s')."',
JMBAYAR='".$_REQUEST['total']."',
NIP = '".$_SESSION['NIP']."',
SHIFT='".$_REQUEST['SHIFT']."',
TBP='".$tbp."',
LUNAS = '1',
STATUS = 'LUNAS',
TOTCOSTSHARING = '".$_REQUEST['keringanan']."',
ALASAN_KERINGANAN = '".$_REQUEST['alasan']."',
CARABAYAR = '".$carabayar."',
st_carabayar = '".$_REQUEST['st_carabayar']."',
kd_penjamin = '".$_REQUEST['kd_penjamin']."'
WHERE IDXBILL='".$_REQUEST['idxb']."'";
execute($t_bayarrajal);
// jika piutang
if($_REQUEST['st_carabayar'] == 2){
$sql_piutang = "INSERT INTO t_piutang SET idxbill = ".$_REQUEST['idxb'].", nomr = '".$arr_bill[0]['NOMR']."', tanggal = '".date('Y-m-d')."', pukul = '".date('H:i:s')."', idxdaftar = ".$arr_bill[0]['IDXDAFTAR'].", nobilling = ".$arr_bill[0]['NOBILL'].", nip = '".$_SESSION['NIP']."', shift = ".$_REQUEST['SHIFT'].", idxtarif = '".$arr_bill[0]['KODETARIF']."', idxpoly = ".$arr_bill[0]['KDPOLY'].", kddokter = ".$arr_bill[0]['KDDOKTER'].", jumlah_bayar = ".$_REQUEST['total'].", jasa_sarana = ".($arr_bill[0]['JASA_SARANA']).", jasa_pelayanan = ".($arr_bill[0]['JASA_PELAYANAN']).", kode_penjamin= ".$_REQUEST['kd_penjamin'].", st_billing = 'IRJA'";
execute($sql_piutang);
}
$lunas = $db->query('select * from t_bayarrajal where IDXBILL = "'.$_REQUEST['idxb'].'"');
$rlunas= $lunas->fetchAll()[0];
if($rlunas['STATUS'] == 'LUNAS'){
echo 'ok';
}else{
echo 'error';
}
}
if(array_key_exists('bayardeporanap', $_REQUEST) && $_REQUEST['bayardeporanap']=="true"){
$nobill = $_REQUEST['nobill'];
$tbp = $_REQUEST['tbp'];
$shift = $_REQUEST['shift'];
$total = $_REQUEST['total'];
$sql = $db->query('CALL pr_bayar_obat_ranap("'.$nobill.'","'.$tbp.'","'.$shift.'","'.$total.'")');
if($sql){
echo 'ok';
}
}
?>