query("SELECT nobill,carabayar FROM t_billranap where NOMR = '$norm' and IDXDAFTAR = '$idxdaftar'");
$get_data = $qrynobil->fetchAll()[0];
$maxnobyr = $get_data['nobill'];
$carabayar = $get_data['carabayar'];
$kdunit = $_SESSION['KDUNIT'];
$data_deposit = [];
$data_deposit['nomr'] = $norm;
$data_deposit['idadmission'] = $idxdaftar;
$data_deposit['deposit'] = $deposit;
$data_deposit['tanggal'] = date('Y-m-d H:i:s');
$data_deposit['shift_bayar'] = $shift;
$data_deposit['no_bayar'] = lastNoBayar($nip,date('Y-m-d'),$shift);
$data_deposit['nobill'] = $maxnobyr;
$data_deposit['user_deposit'] = $_SESSION['NIP'];
$data_deposit['dt_deposit'] = date('Y-m-d H:i:s');
$save_deposit = execute('INSERT into t_deposit '.bind_sql($data_deposit));
if($save_deposit != false)
{
$db->query("UPDATE m_maxnobyr set nomor = ".$data_deposit['no_bayar']." where type='kuitansi'");
$msg = "Pembayaran deposito berhasil";
$type = "success";
}
else {
$message = "Pembayaran deposito gagal";
$type = "error";
}
echo json_encode(['message'=>$message,'type'=>$type, 'nonota' => $data_deposit['no_bayar']]);
exit;
}
elseif($page == 'list')
{
$query_list = "SELECT * from t_billranap
JOIN t_bayarranap on t_billranap.idxbill = t_bayarranap.idxbill where t_billranap.NOMR = '{$_REQUEST['nomr']}' and t_billranap.IDXDAFTAR='{$_REQUEST['idxdaftar']}' AND t_billranap.KODETARIF = 'DEPOSIT' and t_bayarranap.status != 'BATAL' ";
$tmp_list = $db->query( $query_list);
if($tmp_list->numRows())
{
$table_data = '
| No. | Tanggal | Jumlah Deposit | Status | # |
|---|
';
$no = 1;
foreach($tmp_list->fetchAll() as $data)
{
$status = ($data['status'] == 'TRX') ? 'Belum Bayar' : 'Lunas';
$btn_batal = ($data['status'] == 'TRX') ? '' : '';
$table_data .= '| '.$no.' |
'.$data['tanggal'].' |
'.format_uang($data['tarifrs']).' |
'.$status.' |
'.$btn_batal.' |
';
$no++;
}
$table_data .= '
';
echo $table_data;
}
exit;
}
elseif($page == 'cari_orderbatal') {
$nobill = $_REQUEST['nobill'];
$idxdaftar = $_REQUEST['idxdaftar'];
if($nobill != '') {
$nobill = preg_replace("/\./", "", $nobill);
$sql = "SELECT a.idxdeposit,b.id_admission,a.tanggal,a.no_bayar,a.nomr,c.nama as nama_pasien,d.nama as nama_ruang,a.deposit,a.nobill,a.st_orderbatal,a.st_batal from
t_deposit a
join t_admission b on a.idadmission = b.id_admission
join m_pasien c on a.nomr = c.nomr
join m_ruang d on b.noruang = d.no
where a.nobill = '$nobill'
and (a.st_batal is null or a.st_batal = 0)";
$tmp_deposit = $db->query($sql);
if($tmp_deposit->numRows() > 0) {
$html_deposit = '';
$idxdaftar = '';
$no = 1;
foreach($tmp_deposit->fetchAll() as $row)
{
$idxdaftar = $row['id_admission'];
$status = '';
if($row['st_orderbatal'] == 1) {
$status = 'Sudah diorder batal';
}
$btn_orderbatal = '';
$html_deposit .= '
| '.$no.' |
'.datetime_to_dateid($row['tanggal']).' |
'.$row['no_bayar'].' |
'.$row['nomr'].' |
'.$row['nama_pasien'].' |
'.$row['nama_ruang'].' |
'.format_uang($row['deposit']).' |
'.(($status != '') ? $status : $btn_orderbatal).' |
';
$no++;
}
echo json_encode(['data'=>$html_deposit,'idxdaftar'=>$idxdaftar]);
}
else {
$html_deposit = '| Data tidak ditemukan |
';
echo json_encode(['data'=>$html_deposit]);
}
}
}
elseif($page == 'orderbatal') {
$nobill = $_REQUEST['nobill'];
$idxdeposit = $_REQUEST['idxdeposit'];
if($nobill != '' && $idxdeposit != '') {
$arr_order['st_orderbatal'] = ['value'=>1,'type'=>'number'];
$arr_order['orderbatal_by'] = $_SESSION['NIP'];
$arr_order['dt_orderbatal'] = date('Y-m-d H:i:s');
$sql = 'UPDATE t_deposit '.bind_sql($arr_order, 1).' WHERE idxdeposit = '.$idxdeposit;
$save_orderbatal = execute($sql);
if($save_orderbatal) {
$msg = 'Order Batal Deposit Berhasil';
$type = 'success';
}
else {
$msg = 'Order Batal Deposit Gagal';
$type = 'error';
}
}
else {
$msg = 'Data tidak ditemukan';
$type = 'error';
}
echo json_encode(['message'=>$msg,'type'=>$type]);
exit;
}
elseif($page == 'cari_batal') {
$nobill = $_REQUEST['nobill'];
$idxdaftar = $_REQUEST['idxdaftar'];
if($nobill != '') {
$nobill = preg_replace("/\./", "", $nobill);
$sql = "SELECT a.idxdeposit,b.id_admission,a.tanggal,a.no_bayar,a.nomr,c.nama as nama_pasien,d.nama as nama_ruang,a.deposit,a.nobill,a.st_orderbatal,a.st_batal from
t_deposit a
join t_admission b on a.idadmission = b.id_admission
join m_pasien c on a.nomr = c.nomr
join m_ruang d on b.noruang = d.no
where a.nobill = '$nobill'
and (a.st_batal is null or a.st_batal = 0) and a.st_orderbatal = 1";
$tmp_deposit = $db->query($sql);
if($tmp_deposit->numRows() > 0) {
$html_deposit = '';
$idxdaftar = '';
$no = 1;
foreach($tmp_deposit->fetchAll() as $row)
{
$idxdaftar = $row['id_admission'];
$status = '';
if($row['st_batal'] == 1) {
$status = 'Sudah dibatalkan';
}
$btn_orderbatal = '';
$html_deposit .= '
| '.$no.' |
'.datetime_to_dateid($row['tanggal']).' |
'.$row['no_bayar'].' |
'.$row['nomr'].' |
'.$row['nama_pasien'].' |
'.$row['nama_ruang'].' |
'.format_uang($row['deposit']).' |
'.(($status != '') ? $status : $btn_orderbatal).' |
';
$no++;
}
echo json_encode(['data'=>$html_deposit,'idxdaftar'=>$idxdaftar]);
}
else {
$html_deposit = '| Data tidak ditemukan |
';
echo json_encode(['data'=>$html_deposit]);
}
}
}
elseif($page == 'batal') {
$nobill = $_REQUEST['nobill'];
$idxdeposit = $_REQUEST['idxdeposit'];
if($nobill != '' && $idxdeposit != '') {
$arr_order['st_batal'] = ['value'=>1,'type'=>'number'];
$arr_order['batal_by'] = $_SESSION['NIP'];
$arr_order['dt_batal'] = date('Y-m-d H:i:s');
$sql = 'UPDATE t_deposit '.bind_sql($arr_order, 1).' WHERE idxdeposit = '.$idxdeposit;
$save_orderbatal = execute($sql);
if($save_orderbatal) {
$msg = 'Batal Deposit Berhasil';
$type = 'success';
}
else {
$msg = 'Batal Deposit Gagal';
$type = 'error';
}
}
else {
$msg = 'Data tidak ditemukan';
$type = 'error';
}
echo json_encode(['message'=>$msg,'type'=>$type]);
exit;
}
?>