/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
/*
* DlgPenyakit.java
*
* Created on May 23, 2010, 12:57:16 AM
*/
package keuangan;
import kepegawaian.DlgCariDokter;
import kepegawaian.DlgCariPetugas;
import fungsi.WarnaTable;
import fungsi.batasInput;
import fungsi.koneksiDB;
import fungsi.sekuel;
import fungsi.validasi;
import fungsi.akses;
import java.awt.Cursor;
import java.awt.Dimension;
import java.awt.event.KeyEvent;
import java.awt.event.KeyListener;
import java.awt.event.WindowEvent;
import java.awt.event.WindowListener;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Date;
import javax.swing.JOptionPane;
import javax.swing.JTable;
import javax.swing.event.DocumentEvent;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableColumn;
import simrskhanza.DlgKtgPerawatan;
/**
*
* @author dosen
*/
public final class DlgCariPerawatanRanap2 extends javax.swing.JDialog {
private final DefaultTableModel tabMode;
private sekuel Sequel=new sekuel();
private validasi Valid=new validasi();
private Connection koneksi=koneksiDB.condb();
private PreparedStatement psinputrawatdr,psinputrawatpr,psinputrawatdrpr,pstarif,pscari,pscari2,pscari3,pscari4,pscari5,pscari6,pscari7,pscari8,
pstindakan,pstindakan2,pstindakan3,pshapustindakan,pshapustindakan2,pshapustindakan3,psrekening;
private ResultSet rs,rstindakan,rstarif,rsrekening;
private String pilihtable="",kd_pj="",kd_bangsal="",ruang_ranap="Yes", cara_bayar_ranap="Yes",kelas="",kelas_ranap="Yes";
private boolean[] pagi,siang,sore,malam;
private boolean pg=false,sg=false,sr=false,mlm=false;
private boolean sukses=false;
private String[] kode,nama,kategori,kelastarif;
private double[] totaltnd,bagianrs,bhp,jmdokter,jmperawat,kso,menejemen;
private int jml=0,i=0,index=0;
public DlgCariDokter dokter=new DlgCariDokter(null,false);
public DlgCariPetugas petugas=new DlgCariPetugas(null,false);
private double ttljmdokter=0,ttljmperawat=0,ttlkso=0,ttlpendapatan=0,ttljasasarana=0,ttlbhp=0,ttlmenejemen=0,
hapusttljasasarana=0,hapusttlbhp=0,hapusttlmenejemen=0,hapusttljmdokter=0,hapusttljmperawat=0,hapusttlkso=0,hapusttlpendapatan=0;
private Jurnal jur=new Jurnal();
private String Suspen_Piutang_Tindakan_Ranap="",Tindakan_Ranap="",Beban_Jasa_Medik_Dokter_Tindakan_Ranap="",Utang_Jasa_Medik_Dokter_Tindakan_Ranap="",
Beban_Jasa_Medik_Paramedis_Tindakan_Ranap="",Utang_Jasa_Medik_Paramedis_Tindakan_Ranap="",Beban_KSO_Tindakan_Ranap="",Utang_KSO_Tindakan_Ranap="",
Beban_Jasa_Sarana_Tindakan_Ranap="",Utang_Jasa_Sarana_Tindakan_Ranap="",Beban_Jasa_Menejemen_Tindakan_Ranap="",Utang_Jasa_Menejemen_Tindakan_Ranap="",
HPP_BHP_Tindakan_Ranap="",Persediaan_BHP_Tindakan_Ranap="";
public DlgKtgPerawatan ktg=new DlgKtgPerawatan(null,false);
/** Creates new form DlgPenyakit
* @param parent
* @param modal */
public DlgCariPerawatanRanap2(java.awt.Frame parent, boolean modal) {
super(parent, modal);
initComponents();
this.setLocation(10,2);
setSize(656,250);
Object[] row={"Pagi","Siang","Sore","Malam","Kode","Nama Perawatan","Kategori Perawatan",
"Tarif/Biaya","Bagian RS","BHP","JM Dokter","JM Perawat","KSO","Menejemen","Kelas"};
tabMode=new DefaultTableModel(null,row){
@Override public boolean isCellEditable(int rowIndex, int colIndex){
boolean a = false;
if ((colIndex==0)||(colIndex==1)||(colIndex==2)||(colIndex==3)) {
a=true;
}
return a;
}
Class[] types = new Class[] {
java.lang.Boolean.class,java.lang.Boolean.class,java.lang.Boolean.class,java.lang.Boolean.class,
java.lang.Object.class, java.lang.Object.class, java.lang.Object.class,java.lang.Double.class,
java.lang.Double.class, java.lang.Double.class,java.lang.Double.class,java.lang.Double.class,
java.lang.Double.class,java.lang.Double.class, java.lang.Object.class
};
/*Class[] types = new Class[] {
java.lang.Boolean.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class,
};*/
@Override
public Class getColumnClass(int columnIndex) {
return types [columnIndex];
}
};
tbKamar.setModel(tabMode);
//tbPenyakit.setDefaultRenderer(Object.class, new WarnaTable(panelJudul.getBackground(),tbPenyakit.getBackground()));
tbKamar.setPreferredScrollableViewportSize(new Dimension(500,500));
tbKamar.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
for (i = 0; i < 15; i++) {
TableColumn column = tbKamar.getColumnModel().getColumn(i);
if(i==0){
column.setPreferredWidth(35);
}else if(i==1){
column.setPreferredWidth(35);
}else if(i==2){
column.setPreferredWidth(35);
}else if(i==3){
column.setPreferredWidth(35);
}else if(i==4){
column.setPreferredWidth(90);
}else if(i==5){
column.setPreferredWidth(300);
}else if(i==6){
column.setPreferredWidth(150);
}else if(i==7){
column.setPreferredWidth(120);
}else if(i==14){
column.setPreferredWidth(75);
}else{
column.setMinWidth(0);
column.setMaxWidth(0);
}
}
tbKamar.setDefaultRenderer(Object.class, new WarnaTable());
TCari.setDocument(new batasInput((byte)100).getKata(TCari));
if(koneksiDB.CARICEPAT().equals("aktif")){
TCari.getDocument().addDocumentListener(new javax.swing.event.DocumentListener(){
@Override
public void insertUpdate(DocumentEvent e) {
if(TCari.getText().length()>2){
tampil();
}
}
@Override
public void removeUpdate(DocumentEvent e) {
if(TCari.getText().length()>2){
tampil();
}
}
@Override
public void changedUpdate(DocumentEvent e) {
if(TCari.getText().length()>2){
tampil();
}
}
});
}
dokter.addWindowListener(new WindowListener() {
@Override
public void windowOpened(WindowEvent e) {}
@Override
public void windowClosing(WindowEvent e) {}
@Override
public void windowClosed(WindowEvent e) {
if(dokter.getTable().getSelectedRow()!= -1){
kddokter.setText(dokter.getTable().getValueAt(dokter.getTable().getSelectedRow(),0).toString());
nmdokter.setText(dokter.getTable().getValueAt(dokter.getTable().getSelectedRow(),1).toString());
}
kddokter.requestFocus();
}
@Override
public void windowIconified(WindowEvent e) {}
@Override
public void windowDeiconified(WindowEvent e) {}
@Override
public void windowActivated(WindowEvent e) {}
@Override
public void windowDeactivated(WindowEvent e) {}
});
petugas.addWindowListener(new WindowListener() {
@Override
public void windowOpened(WindowEvent e) {}
@Override
public void windowClosing(WindowEvent e) {}
@Override
public void windowClosed(WindowEvent e) {
if(petugas.getTable().getSelectedRow()!= -1){
switch (pilihtable) {
case "rawat_inap_pr":
kddokter.setText(petugas.getTable().getValueAt(petugas.getTable().getSelectedRow(),0).toString());
nmdokter.setText(petugas.getTable().getValueAt(petugas.getTable().getSelectedRow(),1).toString());
kddokter.requestFocus();
break;
case "rawat_inap_drpr":
KdPtg2.setText(petugas.getTable().getValueAt(petugas.getTable().getSelectedRow(),0).toString());
NmPtg2.setText(petugas.getTable().getValueAt(petugas.getTable().getSelectedRow(),1).toString());
KdPtg2.requestFocus();
break;
}
}
}
@Override
public void windowIconified(WindowEvent e) {}
@Override
public void windowDeiconified(WindowEvent e) {}
@Override
public void windowActivated(WindowEvent e) {}
@Override
public void windowDeactivated(WindowEvent e) {}
});
ktg.addWindowListener(new WindowListener() {
@Override
public void windowOpened(WindowEvent e) {}
@Override
public void windowClosing(WindowEvent e) {}
@Override
public void windowClosed(WindowEvent e) {
if(ktg.getTable().getSelectedRow()!= -1){
KdKtg.setText(ktg.getTable().getValueAt(ktg.getTable().getSelectedRow(),1).toString());
NmKtg.setText(ktg.getTable().getValueAt(ktg.getTable().getSelectedRow(),2).toString());
}
KdKtg.requestFocus();
}
@Override
public void windowIconified(WindowEvent e) {}
@Override
public void windowDeiconified(WindowEvent e) {}
@Override
public void windowActivated(WindowEvent e) {}
@Override
public void windowDeactivated(WindowEvent e) {}
});
ktg.getTable().addKeyListener(new KeyListener() {
@Override
public void keyTyped(KeyEvent e) {}
@Override
public void keyPressed(KeyEvent e) {
if(e.getKeyCode()==KeyEvent.VK_SPACE){
ktg.dispose();
}
}
@Override
public void keyReleased(KeyEvent e) {}
});
TCari.requestFocus();
try {
psrekening=koneksi.prepareStatement("select * from set_akun_ranap");
try {
rsrekening=psrekening.executeQuery();
while(rsrekening.next()){
Suspen_Piutang_Tindakan_Ranap=rsrekening.getString("Suspen_Piutang_Tindakan_Ranap");
Tindakan_Ranap=rsrekening.getString("Tindakan_Ranap");
Beban_Jasa_Medik_Dokter_Tindakan_Ranap=rsrekening.getString("Beban_Jasa_Medik_Dokter_Tindakan_Ranap");
Utang_Jasa_Medik_Dokter_Tindakan_Ranap=rsrekening.getString("Utang_Jasa_Medik_Dokter_Tindakan_Ranap");
Beban_Jasa_Medik_Paramedis_Tindakan_Ranap=rsrekening.getString("Beban_Jasa_Medik_Paramedis_Tindakan_Ranap");
Utang_Jasa_Medik_Paramedis_Tindakan_Ranap=rsrekening.getString("Utang_Jasa_Medik_Paramedis_Tindakan_Ranap");
Beban_KSO_Tindakan_Ranap=rsrekening.getString("Beban_KSO_Tindakan_Ranap");
Utang_KSO_Tindakan_Ranap=rsrekening.getString("Utang_KSO_Tindakan_Ranap");
Beban_Jasa_Sarana_Tindakan_Ranap=rsrekening.getString("Beban_Jasa_Sarana_Tindakan_Ranap");
Utang_Jasa_Sarana_Tindakan_Ranap=rsrekening.getString("Utang_Jasa_Sarana_Tindakan_Ranap");
Beban_Jasa_Menejemen_Tindakan_Ranap=rsrekening.getString("Beban_Jasa_Menejemen_Tindakan_Ranap");
Utang_Jasa_Menejemen_Tindakan_Ranap=rsrekening.getString("Utang_Jasa_Menejemen_Tindakan_Ranap");
HPP_BHP_Tindakan_Ranap=rsrekening.getString("HPP_BHP_Tindakan_Ranap");
Persediaan_BHP_Tindakan_Ranap=rsrekening.getString("Persediaan_BHP_Tindakan_Ranap");
}
} catch (Exception e) {
System.out.println("Notif Rekening : "+e);
} finally{
if(rsrekening!=null){
rsrekening.close();
}
if(psrekening!=null){
psrekening.close();
}
}
} catch (Exception e) {
System.out.println(e);
}
try {
pstarif=koneksi.prepareStatement("select * from set_tarif");
try {
rstarif=pstarif.executeQuery();
if(rstarif.next()){
ruang_ranap=rstarif.getString("ruang_ranap");
cara_bayar_ranap=rstarif.getString("cara_bayar_ranap");
kelas_ranap=rstarif.getString("kelas_ranap");
}else{
ruang_ranap="Yes";
cara_bayar_ranap="Yes";
kelas_ranap="Yes";
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
} finally{
if(rstarif != null){
rstarif.close();
}
if(pstarif != null){
pstarif.close();
}
}
} catch (Exception e) {
System.out.println(e);
}
}
/** This method is called from within the constructor to
* initialize the form.
* WARNING: Do NOT modify this code. The content of this method is
* always regenerated by the Form Editor.
*/
@SuppressWarnings("unchecked")
// //GEN-BEGIN:initComponents
private void initComponents() {
Popup = new javax.swing.JPopupMenu();
ppBersihkan = new javax.swing.JMenuItem();
ppDokter = new javax.swing.JMenuItem();
ppPetugas = new javax.swing.JMenuItem();
ppPetugasDokter = new javax.swing.JMenuItem();
TNoRw = new widget.TextBox();
TPasien = new widget.TextBox();
internalFrame1 = new widget.InternalFrame();
Scroll = new widget.ScrollPane();
tbKamar = new widget.Table();
panelisi3 = new widget.panelisi();
jLabel4 = new widget.Label();
KdKtg = new widget.TextBox();
NmKtg = new widget.TextBox();
btnKategori = new widget.Button();
label9 = new widget.Label();
TCari = new widget.TextBox();
BtnCari = new widget.Button();
BtnAll = new widget.Button();
BtnTambah = new widget.Button();
BtnSimpan = new widget.Button();
label10 = new widget.Label();
LCount = new widget.Label();
BtnKeluar = new widget.Button();
FormInput = new widget.PanelBiasa();
DTPTgl = new widget.Tanggal();
jLabel5 = new widget.Label();
kddokter = new widget.TextBox();
nmdokter = new widget.TextBox();
btnDokter = new widget.Button();
jLabel10 = new widget.Label();
LblPetugas = new widget.Label();
KdPtg2 = new widget.TextBox();
NmPtg2 = new widget.TextBox();
btnPetugas = new widget.Button();
Popup.setName("Popup"); // NOI18N
ppBersihkan.setBackground(new java.awt.Color(255, 255, 254));
ppBersihkan.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N
ppBersihkan.setForeground(new java.awt.Color(50, 50, 50));
ppBersihkan.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/stop_f2.png"))); // NOI18N
ppBersihkan.setText("Hilangkan Centang/Tindakan Terpilih");
ppBersihkan.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
ppBersihkan.setHorizontalTextPosition(javax.swing.SwingConstants.RIGHT);
ppBersihkan.setName("ppBersihkan"); // NOI18N
ppBersihkan.setPreferredSize(new java.awt.Dimension(250, 25));
ppBersihkan.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
ppBersihkanActionPerformed(evt);
}
});
Popup.add(ppBersihkan);
ppDokter.setBackground(new java.awt.Color(255, 255, 254));
ppDokter.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N
ppDokter.setForeground(new java.awt.Color(50, 50, 50));
ppDokter.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/inventaris.png"))); // NOI18N
ppDokter.setText("Ubah Ke Tindakan Dokter");
ppDokter.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
ppDokter.setHorizontalTextPosition(javax.swing.SwingConstants.RIGHT);
ppDokter.setName("ppDokter"); // NOI18N
ppDokter.setPreferredSize(new java.awt.Dimension(250, 25));
ppDokter.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
ppDokterActionPerformed(evt);
}
});
Popup.add(ppDokter);
ppPetugas.setBackground(new java.awt.Color(255, 255, 254));
ppPetugas.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N
ppPetugas.setForeground(new java.awt.Color(50, 50, 50));
ppPetugas.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/inventaris.png"))); // NOI18N
ppPetugas.setText("Ubah Ke Tindakan Petugas");
ppPetugas.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
ppPetugas.setHorizontalTextPosition(javax.swing.SwingConstants.RIGHT);
ppPetugas.setName("ppPetugas"); // NOI18N
ppPetugas.setPreferredSize(new java.awt.Dimension(250, 25));
ppPetugas.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
ppPetugasActionPerformed(evt);
}
});
Popup.add(ppPetugas);
ppPetugasDokter.setBackground(new java.awt.Color(255, 255, 254));
ppPetugasDokter.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N
ppPetugasDokter.setForeground(new java.awt.Color(50, 50, 50));
ppPetugasDokter.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/inventaris.png"))); // NOI18N
ppPetugasDokter.setText("Ubah Ke Tindakan Dokter & Petugas");
ppPetugasDokter.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
ppPetugasDokter.setHorizontalTextPosition(javax.swing.SwingConstants.RIGHT);
ppPetugasDokter.setName("ppPetugasDokter"); // NOI18N
ppPetugasDokter.setPreferredSize(new java.awt.Dimension(250, 25));
ppPetugasDokter.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
ppPetugasDokterActionPerformed(evt);
}
});
Popup.add(ppPetugasDokter);
TNoRw.setHighlighter(null);
TNoRw.setName("TNoRw"); // NOI18N
TPasien.setFocusTraversalPolicyProvider(true);
TPasien.setName("TPasien"); // NOI18N
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
setUndecorated(true);
setResizable(false);
addWindowListener(new java.awt.event.WindowAdapter() {
public void windowOpened(java.awt.event.WindowEvent evt) {
formWindowOpened(evt);
}
public void windowActivated(java.awt.event.WindowEvent evt) {
formWindowActivated(evt);
}
});
internalFrame1.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(240, 245, 235)), "::[ Tarif Tagihan/Perawatan/Tindakan Rawat Inap ]::", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(50, 50, 50))); // NOI18N
internalFrame1.setName("internalFrame1"); // NOI18N
internalFrame1.setLayout(new java.awt.BorderLayout(1, 1));
Scroll.setComponentPopupMenu(Popup);
Scroll.setName("Scroll"); // NOI18N
Scroll.setOpaque(true);
tbKamar.setAutoCreateRowSorter(true);
tbKamar.setComponentPopupMenu(Popup);
tbKamar.setName("tbKamar"); // NOI18N
tbKamar.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
tbKamarMouseClicked(evt);
}
});
tbKamar.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
tbKamarKeyPressed(evt);
}
});
Scroll.setViewportView(tbKamar);
internalFrame1.add(Scroll, java.awt.BorderLayout.CENTER);
panelisi3.setName("panelisi3"); // NOI18N
panelisi3.setPreferredSize(new java.awt.Dimension(100, 43));
panelisi3.setLayout(new java.awt.FlowLayout(java.awt.FlowLayout.LEFT, 4, 9));
jLabel4.setText("Kategori :");
jLabel4.setName("jLabel4"); // NOI18N
jLabel4.setPreferredSize(new java.awt.Dimension(55, 23));
panelisi3.add(jLabel4);
KdKtg.setHighlighter(null);
KdKtg.setName("KdKtg"); // NOI18N
KdKtg.setPreferredSize(new java.awt.Dimension(50, 23));
KdKtg.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
KdKtgActionPerformed(evt);
}
});
KdKtg.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
KdKtgKeyPressed(evt);
}
});
panelisi3.add(KdKtg);
NmKtg.setEditable(false);
NmKtg.setHighlighter(null);
NmKtg.setName("NmKtg"); // NOI18N
NmKtg.setPreferredSize(new java.awt.Dimension(140, 23));
NmKtg.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
NmKtgKeyPressed(evt);
}
});
panelisi3.add(NmKtg);
btnKategori.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/190.png"))); // NOI18N
btnKategori.setMnemonic('1');
btnKategori.setToolTipText("Alt+1");
btnKategori.setName("btnKategori"); // NOI18N
btnKategori.setPreferredSize(new java.awt.Dimension(28, 23));
btnKategori.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnKategoriActionPerformed(evt);
}
});
btnKategori.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
btnKategoriKeyPressed(evt);
}
});
panelisi3.add(btnKategori);
label9.setText("Key Word :");
label9.setName("label9"); // NOI18N
label9.setPreferredSize(new java.awt.Dimension(68, 23));
panelisi3.add(label9);
TCari.setName("TCari"); // NOI18N
TCari.setPreferredSize(new java.awt.Dimension(200, 23));
TCari.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
TCariKeyPressed(evt);
}
});
panelisi3.add(TCari);
BtnCari.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/accept.png"))); // NOI18N
BtnCari.setMnemonic('1');
BtnCari.setToolTipText("Alt+1");
BtnCari.setName("BtnCari"); // NOI18N
BtnCari.setPreferredSize(new java.awt.Dimension(28, 23));
BtnCari.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
BtnCariActionPerformed(evt);
}
});
BtnCari.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
BtnCariKeyPressed(evt);
}
});
panelisi3.add(BtnCari);
BtnAll.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/Search-16x16.png"))); // NOI18N
BtnAll.setMnemonic('2');
BtnAll.setToolTipText("2Alt+2");
BtnAll.setName("BtnAll"); // NOI18N
BtnAll.setPreferredSize(new java.awt.Dimension(28, 23));
BtnAll.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
BtnAllActionPerformed(evt);
}
});
BtnAll.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
BtnAllKeyPressed(evt);
}
});
panelisi3.add(BtnAll);
BtnTambah.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/plus_16.png"))); // NOI18N
BtnTambah.setMnemonic('3');
BtnTambah.setToolTipText("Alt+3");
BtnTambah.setName("BtnTambah"); // NOI18N
BtnTambah.setPreferredSize(new java.awt.Dimension(28, 23));
BtnTambah.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
BtnTambahActionPerformed(evt);
}
});
panelisi3.add(BtnTambah);
BtnSimpan.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/save-16x16.png"))); // NOI18N
BtnSimpan.setMnemonic('S');
BtnSimpan.setToolTipText("Alt+S");
BtnSimpan.setName("BtnSimpan"); // NOI18N
BtnSimpan.setPreferredSize(new java.awt.Dimension(28, 23));
BtnSimpan.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
BtnSimpanActionPerformed(evt);
}
});
panelisi3.add(BtnSimpan);
label10.setText("Record :");
label10.setName("label10"); // NOI18N
label10.setPreferredSize(new java.awt.Dimension(50, 23));
panelisi3.add(label10);
LCount.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
LCount.setText("0");
LCount.setName("LCount"); // NOI18N
LCount.setPreferredSize(new java.awt.Dimension(30, 23));
panelisi3.add(LCount);
BtnKeluar.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/exit.png"))); // NOI18N
BtnKeluar.setMnemonic('4');
BtnKeluar.setToolTipText("Alt+4");
BtnKeluar.setName("BtnKeluar"); // NOI18N
BtnKeluar.setPreferredSize(new java.awt.Dimension(28, 23));
BtnKeluar.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
BtnKeluarActionPerformed(evt);
}
});
panelisi3.add(BtnKeluar);
internalFrame1.add(panelisi3, java.awt.BorderLayout.PAGE_END);
FormInput.setBackground(new java.awt.Color(215, 225, 215));
FormInput.setName("FormInput"); // NOI18N
FormInput.setPreferredSize(new java.awt.Dimension(710, 74));
FormInput.setLayout(null);
DTPTgl.setForeground(new java.awt.Color(50, 70, 50));
DTPTgl.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "26-07-2020" }));
DTPTgl.setDisplayFormat("dd-MM-yyyy");
DTPTgl.setName("DTPTgl"); // NOI18N
DTPTgl.setOpaque(false);
DTPTgl.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
DTPTglKeyPressed(evt);
}
});
FormInput.add(DTPTgl);
DTPTgl.setBounds(685, 10, 120, 23);
jLabel5.setText("Dokter :");
jLabel5.setName("jLabel5"); // NOI18N
FormInput.add(jLabel5);
jLabel5.setBounds(0, 10, 60, 23);
kddokter.setHighlighter(null);
kddokter.setName("kddokter"); // NOI18N
kddokter.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
kddokterKeyPressed(evt);
}
});
FormInput.add(kddokter);
kddokter.setBounds(63, 10, 100, 23);
nmdokter.setEditable(false);
nmdokter.setHighlighter(null);
nmdokter.setName("nmdokter"); // NOI18N
FormInput.add(nmdokter);
nmdokter.setBounds(165, 10, 367, 23);
btnDokter.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/190.png"))); // NOI18N
btnDokter.setMnemonic('4');
btnDokter.setToolTipText("ALt+4");
btnDokter.setName("btnDokter"); // NOI18N
btnDokter.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnDokterActionPerformed(evt);
}
});
FormInput.add(btnDokter);
btnDokter.setBounds(536, 10, 28, 23);
jLabel10.setText("Tanggal :");
jLabel10.setName("jLabel10"); // NOI18N
FormInput.add(jLabel10);
jLabel10.setBounds(602, 10, 80, 23);
LblPetugas.setText("Petugas :");
LblPetugas.setName("LblPetugas"); // NOI18N
FormInput.add(LblPetugas);
LblPetugas.setBounds(0, 40, 60, 23);
KdPtg2.setHighlighter(null);
KdPtg2.setName("KdPtg2"); // NOI18N
KdPtg2.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
KdPtg2KeyPressed(evt);
}
});
FormInput.add(KdPtg2);
KdPtg2.setBounds(63, 40, 100, 23);
NmPtg2.setEditable(false);
NmPtg2.setHighlighter(null);
NmPtg2.setName("NmPtg2"); // NOI18N
FormInput.add(NmPtg2);
NmPtg2.setBounds(165, 40, 367, 23);
btnPetugas.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/190.png"))); // NOI18N
btnPetugas.setMnemonic('4');
btnPetugas.setToolTipText("ALt+4");
btnPetugas.setName("btnPetugas"); // NOI18N
btnPetugas.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnPetugasActionPerformed(evt);
}
});
FormInput.add(btnPetugas);
btnPetugas.setBounds(536, 40, 28, 23);
internalFrame1.add(FormInput, java.awt.BorderLayout.PAGE_START);
getContentPane().add(internalFrame1, java.awt.BorderLayout.CENTER);
pack();
}// //GEN-END:initComponents
private void TCariKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_TCariKeyPressed
if(evt.getKeyCode()==KeyEvent.VK_ENTER){
BtnCariActionPerformed(null);
}else if(evt.getKeyCode()==KeyEvent.VK_UP){
tbKamar.requestFocus();
}else if(evt.getKeyCode()==KeyEvent.VK_PAGE_DOWN){
BtnCari.requestFocus();
}else if(evt.getKeyCode()==KeyEvent.VK_PAGE_UP){
BtnKeluar.requestFocus();
}
}//GEN-LAST:event_TCariKeyPressed
private void BtnCariActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnCariActionPerformed
tampil();
}//GEN-LAST:event_BtnCariActionPerformed
private void BtnCariKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnCariKeyPressed
if(evt.getKeyCode()==KeyEvent.VK_SPACE){
BtnCariActionPerformed(null);
}else{
Valid.pindah(evt, TCari, BtnAll);
}
}//GEN-LAST:event_BtnCariKeyPressed
private void BtnAllActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnAllActionPerformed
TCari.setText("");
tampil();
}//GEN-LAST:event_BtnAllActionPerformed
private void BtnAllKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnAllKeyPressed
if(evt.getKeyCode()==KeyEvent.VK_SPACE){
BtnAllActionPerformed(null);
}else{
Valid.pindah(evt, BtnCari, TCari);
}
}//GEN-LAST:event_BtnAllKeyPressed
private void tbKamarMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_tbKamarMouseClicked
if(tbKamar.getRowCount()!=0){
try {
getData();
} catch (java.lang.NullPointerException e) {
}
if(evt.getClickCount()==2){
dispose();
}
}
}//GEN-LAST:event_tbKamarMouseClicked
private void tbKamarKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_tbKamarKeyPressed
if(tbKamar.getRowCount()!=0){
if(evt.getKeyCode()==KeyEvent.VK_ENTER){
try {
if(tbKamar.getSelectedRow()>-1){
i=tbKamar.getSelectedColumn();
if(i==0){
tbKamar.setValueAt(true,tbKamar.getSelectedRow(),0);
}else if(i==1){
tbKamar.setValueAt(true,tbKamar.getSelectedRow(),1);
}else if(i==2){
tbKamar.setValueAt(true,tbKamar.getSelectedRow(),2);
}else if(i==3){
tbKamar.setValueAt(true,tbKamar.getSelectedRow(),3);
}
}
getData();
} catch (java.lang.NullPointerException e) {
}
}else if((evt.getKeyCode()==KeyEvent.VK_UP)||(evt.getKeyCode()==KeyEvent.VK_DOWN)){
try {
getData();
} catch (java.lang.NullPointerException e) {
}
}else if(evt.getKeyCode()==KeyEvent.VK_SPACE){
dispose();
}else if(evt.getKeyCode()==KeyEvent.VK_SHIFT){
TCari.setText("");
TCari.requestFocus();
}
}
}//GEN-LAST:event_tbKamarKeyPressed
private void BtnKeluarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnKeluarActionPerformed
dispose();
}//GEN-LAST:event_BtnKeluarActionPerformed
private void BtnTambahActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnTambahActionPerformed
this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR));
DlgJnsPerawatanRanap perawatan=new DlgJnsPerawatanRanap(null,false);
perawatan.emptTeks();
perawatan.isCek();
perawatan.setSize(internalFrame1.getWidth()-20,internalFrame1.getHeight()-20);
perawatan.setLocationRelativeTo(internalFrame1);
perawatan.setAlwaysOnTop(false);
perawatan.setVisible(true);
this.setCursor(Cursor.getDefaultCursor());
}//GEN-LAST:event_BtnTambahActionPerformed
private void BtnSimpanActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnSimpanActionPerformed
if(TNoRw.getText().trim().equals("")||kddokter.getText().trim().equals("")){
Valid.textKosong(TCari,"Pasien & Dokter");
}else{
try {
if(pilihtable.equals("rawat_inap_dr")||pilihtable.equals("rawat_inap_pr")||pilihtable.equals("rawat_inap_drpr")){
Sequel.AutoComitFalse();
sukses=true;
ttljmdokter=0;ttljmperawat=0;ttlkso=0;ttlpendapatan=0;ttljasasarana=0;ttlbhp=0;ttlmenejemen=0;
hapusttljasasarana=0;hapusttlbhp=0;hapusttlmenejemen=0;hapusttljmdokter=0;hapusttljmperawat=0;
hapusttlkso=0;hapusttlpendapatan=0;
for(i=0;i0){
if(Sequel.menyimpantf("tampjurnal","'"+Suspen_Piutang_Tindakan_Ranap+"','Suspen Piutang Tindakan Ranap','0','"+hapusttlpendapatan+"'","kredit=kredit+'"+(hapusttlpendapatan)+"'","kd_rek='"+Suspen_Piutang_Tindakan_Ranap+"'")==false){
sukses=false;
}
if(Sequel.menyimpantf("tampjurnal","'"+Tindakan_Ranap+"','Pendapatan Tindakan Rawat Inap','"+hapusttlpendapatan+"','0'","debet=debet+'"+(hapusttlpendapatan)+"'","kd_rek='"+Tindakan_Ranap+"'")==false){
sukses=false;
}
}
if(hapusttljmdokter>0){
if(Sequel.menyimpantf("tampjurnal","'"+Beban_Jasa_Medik_Dokter_Tindakan_Ranap+"','Beban Jasa Medik Dokter Tindakan Ranap','0','"+hapusttljmdokter+"'","kredit=kredit+'"+(hapusttljmdokter)+"'","kd_rek='"+Beban_Jasa_Medik_Dokter_Tindakan_Ranap+"'")==false){
sukses=false;
}
if(Sequel.menyimpantf("tampjurnal","'"+Utang_Jasa_Medik_Dokter_Tindakan_Ranap+"','Utang Jasa Medik Dokter Tindakan Ranap','"+hapusttljmdokter+"','0'","debet=debet+'"+(hapusttljmdokter)+"'","kd_rek='"+Utang_Jasa_Medik_Dokter_Tindakan_Ranap+"'")==false){
sukses=false;
}
}
if(hapusttljmperawat>0){
if(Sequel.menyimpantf("tampjurnal","'"+Beban_Jasa_Medik_Paramedis_Tindakan_Ranap+"','Beban Jasa Medik Paramedis Tindakan Ranap','0','"+hapusttljmperawat+"'","kredit=kredit+'"+(hapusttljmperawat)+"'","kd_rek='"+Beban_Jasa_Medik_Paramedis_Tindakan_Ranap+"'")==false){
sukses=false;
}
if(Sequel.menyimpantf("tampjurnal","'"+Utang_Jasa_Medik_Paramedis_Tindakan_Ranap+"','Utang Jasa Medik Paramedis Tindakan Ranap','"+hapusttljmperawat+"','0'","debet=debet+'"+(hapusttljmperawat)+"'","kd_rek='"+Utang_Jasa_Medik_Paramedis_Tindakan_Ranap+"'")==false){
sukses=false;
}
}
if(hapusttlkso>0){
if(Sequel.menyimpantf("tampjurnal","'"+Beban_KSO_Tindakan_Ranap+"','Beban KSO Tindakan Ranap','0','"+hapusttlkso+"'","kredit=kredit+'"+(hapusttlkso)+"'","kd_rek='"+Beban_KSO_Tindakan_Ranap+"'")==false){
sukses=false;
}
if(Sequel.menyimpantf("tampjurnal","'"+Utang_KSO_Tindakan_Ranap+"','Utang KSO Tindakan Ranap','"+hapusttlkso+"','0'","debet=debet+'"+(hapusttlkso)+"'","kd_rek='"+Utang_KSO_Tindakan_Ranap+"'")==false){
sukses=false;
}
}
if(hapusttlmenejemen>0){
if(Sequel.menyimpantf("tampjurnal","'"+Beban_Jasa_Menejemen_Tindakan_Ranap+"','Beban Jasa Menejemen Tindakan Ranap','0','"+hapusttlmenejemen+"'","kredit=kredit+'"+(hapusttlmenejemen)+"'","kd_rek='"+Beban_Jasa_Menejemen_Tindakan_Ranap+"'")==false){
sukses=false;
}
if(Sequel.menyimpantf("tampjurnal","'"+Utang_Jasa_Menejemen_Tindakan_Ranap+"','Utang Jasa Menejemen Tindakan Ranap','"+hapusttlmenejemen+"','0'","debet=debet+'"+(hapusttlmenejemen)+"'","kd_rek='"+Utang_Jasa_Menejemen_Tindakan_Ranap+"'")==false){
sukses=false;
}
}
if(hapusttljasasarana>0){
if(Sequel.menyimpantf("tampjurnal","'"+Beban_Jasa_Sarana_Tindakan_Ranap+"','Beban Jasa Sarana Tindakan Ranap','0','"+hapusttljasasarana+"'","kredit=kredit+'"+(hapusttljasasarana)+"'","kd_rek='"+Beban_Jasa_Sarana_Tindakan_Ranap+"'")==false){
sukses=false;
}
if(Sequel.menyimpantf("tampjurnal","'"+Utang_Jasa_Sarana_Tindakan_Ranap+"','Utang Jasa Sarana Tindakan Ranap','"+hapusttljasasarana+"','0'","debet=debet+'"+(hapusttljasasarana)+"'","kd_rek='"+Utang_Jasa_Sarana_Tindakan_Ranap+"'")==false){
sukses=false;
}
}
if(hapusttlbhp>0){
if(Sequel.menyimpantf("tampjurnal","'"+HPP_BHP_Tindakan_Ranap+"','HPP BHP Tindakan Ranap','0','"+hapusttlbhp+"'","kredit=kredit+'"+(hapusttlbhp)+"'","kd_rek='"+HPP_BHP_Tindakan_Ranap+"'")==false){
sukses=false;
}
if(Sequel.menyimpantf("tampjurnal","'"+Persediaan_BHP_Tindakan_Ranap+"','Persediaan BHP Tindakan Ranap','"+hapusttlbhp+"','0'","debet=debet+'"+(hapusttlbhp)+"'","kd_rek='"+Persediaan_BHP_Tindakan_Ranap+"'")==false){
sukses=false;
}
}
if(sukses==true){
sukses=jur.simpanJurnal(TNoRw.getText(),"U","PEMBATALAN TINDAKAN RAWAT INAP PASIEN OLEH "+akses.getkode());
}
}
if(sukses==true){
Sequel.queryu("delete from tampjurnal");
if(ttlpendapatan>0){
if(Sequel.menyimpantf("tampjurnal","'"+Suspen_Piutang_Tindakan_Ranap+"','Suspen Piutang Tindakan Ranap','"+ttlpendapatan+"','0'","debet=debet+'"+(ttlpendapatan)+"'","kd_rek='"+Suspen_Piutang_Tindakan_Ranap+"'")==false){
sukses=false;
}
if(Sequel.menyimpantf("tampjurnal","'"+Tindakan_Ranap+"','Pendapatan Tindakan Rawat Inap','0','"+ttlpendapatan+"'","kredit=kredit+'"+(ttlpendapatan)+"'","kd_rek='"+Tindakan_Ranap+"'")==false){
sukses=false;
}
}
if(ttljmdokter>0){
if(Sequel.menyimpantf("tampjurnal","'"+Beban_Jasa_Medik_Dokter_Tindakan_Ranap+"','Beban Jasa Medik Dokter Tindakan Ranap','"+ttljmdokter+"','0'","debet=debet+'"+(ttljmdokter)+"'","kd_rek='"+Beban_Jasa_Medik_Dokter_Tindakan_Ranap+"'")==false){
sukses=false;
}
if(Sequel.menyimpantf("tampjurnal","'"+Utang_Jasa_Medik_Dokter_Tindakan_Ranap+"','Utang Jasa Medik Dokter Tindakan Ranap','0','"+ttljmdokter+"'","kredit=kredit+'"+(ttljmdokter)+"'","kd_rek='"+Utang_Jasa_Medik_Dokter_Tindakan_Ranap+"'")==false){
sukses=false;
}
}
if(ttljmperawat>0){
if(Sequel.menyimpantf("tampjurnal","'"+Beban_Jasa_Medik_Paramedis_Tindakan_Ranap+"','Beban Jasa Medik Paramedis Tindakan Ranap','"+ttljmperawat+"','0'","debet=debet+'"+(ttljmperawat)+"'","kd_rek='"+Beban_Jasa_Medik_Paramedis_Tindakan_Ranap+"'")==false){
sukses=false;
}
if(Sequel.menyimpantf("tampjurnal","'"+Utang_Jasa_Medik_Paramedis_Tindakan_Ranap+"','Utang Jasa Medik Paramedis Tindakan Ranap','0','"+ttljmperawat+"'","kredit=kredit+'"+(ttljmperawat)+"'","kd_rek='"+Utang_Jasa_Medik_Paramedis_Tindakan_Ranap+"'")==false){
sukses=false;
}
}
if(ttlkso>0){
if(Sequel.menyimpantf("tampjurnal","'"+Beban_KSO_Tindakan_Ranap+"','Beban KSO Tindakan Ranap','"+ttlkso+"','0'","debet=debet+'"+(ttlkso)+"'","kd_rek='"+Beban_KSO_Tindakan_Ranap+"'")==false){
sukses=false;
}
if(Sequel.menyimpantf("tampjurnal","'"+Utang_KSO_Tindakan_Ranap+"','Utang KSO Tindakan Ranap','0','"+ttlkso+"'","kredit=kredit+'"+(ttlkso)+"'","kd_rek='"+Utang_KSO_Tindakan_Ranap+"'")==false){
sukses=false;
}
}
if(ttljasasarana>0){
if(Sequel.menyimpantf("tampjurnal","'"+Beban_Jasa_Sarana_Tindakan_Ranap+"','Beban Jasa Sarana Tindakan Ranap','"+ttljasasarana+"','0'","debet=debet+'"+(ttljasasarana)+"'","kd_rek='"+Beban_Jasa_Sarana_Tindakan_Ranap+"'")==false){
sukses=false;
}
if(Sequel.menyimpantf("tampjurnal","'"+Utang_Jasa_Sarana_Tindakan_Ranap+"','Utang Jasa Sarana Tindakan Ranap','0','"+ttljasasarana+"'","kredit=kredit+'"+(ttljasasarana)+"'","kd_rek='"+Utang_Jasa_Sarana_Tindakan_Ranap+"'")==false){
sukses=false;
}
}
if(ttlbhp>0){
if(Sequel.menyimpantf("tampjurnal","'"+HPP_BHP_Tindakan_Ranap+"','HPP BHP Tindakan Ranap','"+ttlbhp+"','0'","debet=debet+'"+(ttlbhp)+"'","kd_rek='"+HPP_BHP_Tindakan_Ranap+"'")==false){
sukses=false;
}
if(Sequel.menyimpantf("tampjurnal","'"+Persediaan_BHP_Tindakan_Ranap+"','Persediaan BHP Tindakan Ranap','0','"+ttlbhp+"'","kredit=kredit+'"+(ttlbhp)+"'","kd_rek='"+Persediaan_BHP_Tindakan_Ranap+"'")==false){
sukses=false;
}
}
if(ttlmenejemen>0){
if(Sequel.menyimpantf("tampjurnal","'"+Beban_Jasa_Menejemen_Tindakan_Ranap+"','Beban Jasa Menejemen Tindakan Ranap','"+ttlmenejemen+"','0'","debet=debet+'"+(ttlmenejemen)+"'","kd_rek='"+Beban_Jasa_Menejemen_Tindakan_Ranap+"'")==false){
sukses=false;
}
if(Sequel.menyimpantf("tampjurnal","'"+Utang_Jasa_Menejemen_Tindakan_Ranap+"','Utang Jasa Menejemen Tindakan Ranap','0','"+ttlmenejemen+"'","kredit=kredit+'"+(ttlmenejemen)+"'","kd_rek='"+Utang_Jasa_Menejemen_Tindakan_Ranap+"'")==false){
sukses=false;
}
}
if(sukses==true){
sukses=jur.simpanJurnal(TNoRw.getText(),"U","TINDAKAN RAWAT INAP PASIEN "+TPasien.getText()+" DIPOSTING OLEH "+akses.getkode());
}
}
if(sukses==true){
Sequel.Commit();
JOptionPane.showMessageDialog(null,"Proses simpan selesai...!");
tampil2();
}else{
JOptionPane.showMessageDialog(null,"Terjadi kesalahan saat pemrosesan data, transaksi dibatalkan.\nPeriksa kembali data sebelum melanjutkan menyimpan..!!");
Sequel.RollBack();
}
Sequel.AutoComitTrue();
}
} catch (Exception ex) {
System.out.println(ex);
JOptionPane.showMessageDialog(null,"Maaf, gagal menyimpan data. Kemungkinan ada data yang sama dimasukkan sebelumnya...!");
}
}
}//GEN-LAST:event_BtnSimpanActionPerformed
private void ppBersihkanActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_ppBersihkanActionPerformed
for(i=0;i {
DlgCariPerawatanRanap2 dialog = new DlgCariPerawatanRanap2(new javax.swing.JFrame(), true);
dialog.addWindowListener(new java.awt.event.WindowAdapter() {
@Override
public void windowClosing(java.awt.event.WindowEvent e) {
System.exit(0);
}
});
dialog.setVisible(true);
});
}
// Variables declaration - do not modify//GEN-BEGIN:variables
private widget.Button BtnAll;
private widget.Button BtnCari;
private widget.Button BtnKeluar;
private widget.Button BtnSimpan;
private widget.Button BtnTambah;
private widget.Tanggal DTPTgl;
private widget.PanelBiasa FormInput;
private widget.TextBox KdKtg;
private widget.TextBox KdPtg2;
private widget.Label LCount;
private widget.Label LblPetugas;
private widget.TextBox NmKtg;
private widget.TextBox NmPtg2;
private javax.swing.JPopupMenu Popup;
private widget.ScrollPane Scroll;
private widget.TextBox TCari;
private widget.TextBox TNoRw;
private widget.TextBox TPasien;
private widget.Button btnDokter;
private widget.Button btnKategori;
private widget.Button btnPetugas;
private widget.InternalFrame internalFrame1;
private widget.Label jLabel10;
private widget.Label jLabel4;
private widget.Label jLabel5;
private widget.TextBox kddokter;
private widget.Label label10;
private widget.Label label9;
private widget.TextBox nmdokter;
private widget.panelisi panelisi3;
private javax.swing.JMenuItem ppBersihkan;
private javax.swing.JMenuItem ppDokter;
private javax.swing.JMenuItem ppPetugas;
private javax.swing.JMenuItem ppPetugasDokter;
private widget.Table tbKamar;
// End of variables declaration//GEN-END:variables
public void tampil() {
try{
jml=0;
for(i=0;i0){
tabMode.addRow(new Object[] {
pg,sg,sr,mlm,rs.getString(1),rs.getString(2),rs.getString(3),
rs.getDouble("total_byrdr"),rs.getDouble("material"),
rs.getDouble("bhp"),rs.getDouble("tarif_tindakandr"),
rs.getDouble("tarif_tindakanpr"),rs.getDouble("kso"),
rs.getDouble("menejemen"),rs.getString("kelas")
});
}
break;
case "rawat_inap_pr":
if(rs.getDouble("total_byrpr")>0){
tabMode.addRow(new Object[] {
pg,sg,sr,mlm,rs.getString(1),rs.getString(2),rs.getString(3),
rs.getDouble("total_byrpr"),rs.getDouble("material"),
rs.getDouble("bhp"),rs.getDouble("tarif_tindakandr"),
rs.getDouble("tarif_tindakanpr"),rs.getDouble("kso"),
rs.getDouble("menejemen"),rs.getString("kelas")
});
}
break;
case "rawat_inap_drpr":
if(rs.getDouble("total_byrdrpr")>0){
tabMode.addRow(new Object[] {
pg,sg,sr,mlm,rs.getString(1),rs.getString(2),rs.getString(3),
rs.getDouble("total_byrdrpr"),rs.getDouble("material"),
rs.getDouble("bhp"),rs.getDouble("tarif_tindakandr"),
rs.getDouble("tarif_tindakanpr"),rs.getDouble("kso"),
rs.getDouble("menejemen"),rs.getString("kelas")
});
}
break;
}
}
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
} finally{
if( rs != null){
rs.close();
}
if(pscari != null){
pscari.close();
}
if(pscari2 != null){
pscari2.close();
}
if(pscari3 != null){
pscari3.close();
}
if(pscari4 != null){
pscari4.close();
}
}
}catch(Exception e){
System.out.println("Notifikasi : "+e);
}
LCount.setText(""+tbKamar.getRowCount());
}
public void tampil2() {
try{
Valid.tabelKosong(tabMode);
try {
if(ruang_ranap.equals("Yes")&&cara_bayar_ranap.equals("Yes")&&kelas_ranap.equals("No")){
pscari=koneksi.prepareStatement("select jns_perawatan_inap.kd_jenis_prw,jns_perawatan_inap.nm_perawatan,kategori_perawatan.nm_kategori,"+
"jns_perawatan_inap.total_byrdr,jns_perawatan_inap.total_byrpr,jns_perawatan_inap.total_byrdrpr,jns_perawatan_inap.bhp,jns_perawatan_inap.material,jns_perawatan_inap.kso,jns_perawatan_inap.menejemen," +
"jns_perawatan_inap.tarif_tindakandr,jns_perawatan_inap.tarif_tindakanpr,jns_perawatan_inap.kelas from jns_perawatan_inap inner join kategori_perawatan "+
"on jns_perawatan_inap.kd_kategori=kategori_perawatan.kd_kategori "+
"where jns_perawatan_inap.status='1' and kategori_perawatan.nm_kategori like ? and (jns_perawatan_inap.kd_pj=? or jns_perawatan_inap.kd_pj='-') and (jns_perawatan_inap.kd_bangsal=? or jns_perawatan_inap.kd_bangsal='-') "+
"and (jns_perawatan_inap.kd_jenis_prw like ? or jns_perawatan_inap.nm_perawatan like ? or kategori_perawatan.nm_kategori like ?) order by jns_perawatan_inap.nm_perawatan");
pscari.setString(1,"%"+NmKtg.getText().trim()+"%");
pscari.setString(2,kd_pj.trim());
pscari.setString(3,kd_bangsal.trim());
pscari.setString(4,"%"+TCari.getText().trim()+"%");
pscari.setString(5,"%"+TCari.getText().trim()+"%");
pscari.setString(6,"%"+TCari.getText().trim()+"%");
rs=pscari.executeQuery();
}else if(ruang_ranap.equals("No")&&cara_bayar_ranap.equals("Yes")&&kelas_ranap.equals("No")){
pscari2=koneksi.prepareStatement("select jns_perawatan_inap.kd_jenis_prw,jns_perawatan_inap.nm_perawatan,kategori_perawatan.nm_kategori,"+
"jns_perawatan_inap.total_byrdr,jns_perawatan_inap.total_byrpr,jns_perawatan_inap.total_byrdrpr,jns_perawatan_inap.bhp,jns_perawatan_inap.material,jns_perawatan_inap.kso,jns_perawatan_inap.menejemen," +
"jns_perawatan_inap.tarif_tindakandr,jns_perawatan_inap.tarif_tindakanpr,jns_perawatan_inap.kelas from jns_perawatan_inap inner join kategori_perawatan "+
"on jns_perawatan_inap.kd_kategori=kategori_perawatan.kd_kategori "+
"where jns_perawatan_inap.status='1' and kategori_perawatan.nm_kategori like ? and (jns_perawatan_inap.kd_pj=? or jns_perawatan_inap.kd_pj='-') "+
"and (jns_perawatan_inap.kd_jenis_prw like ? or jns_perawatan_inap.nm_perawatan like ? or kategori_perawatan.nm_kategori like ?) order by jns_perawatan_inap.nm_perawatan");
pscari2.setString(1,"%"+NmKtg.getText().trim()+"%");
pscari2.setString(2,kd_pj.trim());
pscari2.setString(3,"%"+TCari.getText().trim()+"%");
pscari2.setString(4,"%"+TCari.getText().trim()+"%");
pscari2.setString(5,"%"+TCari.getText().trim()+"%");
rs=pscari2.executeQuery();
}else if(ruang_ranap.equals("Yes")&&cara_bayar_ranap.equals("No")&&kelas_ranap.equals("No")){
pscari3=koneksi.prepareStatement("select jns_perawatan_inap.kd_jenis_prw,jns_perawatan_inap.nm_perawatan,kategori_perawatan.nm_kategori,"+
"jns_perawatan_inap.total_byrdr,jns_perawatan_inap.total_byrpr,jns_perawatan_inap.total_byrdrpr,jns_perawatan_inap.bhp,jns_perawatan_inap.material,jns_perawatan_inap.kso,jns_perawatan_inap.menejemen," +
"jns_perawatan_inap.tarif_tindakandr,jns_perawatan_inap.tarif_tindakanpr,jns_perawatan_inap.kelas from jns_perawatan_inap inner join kategori_perawatan "+
"on jns_perawatan_inap.kd_kategori=kategori_perawatan.kd_kategori "+
"where jns_perawatan_inap.status='1' and kategori_perawatan.nm_kategori like ? and (jns_perawatan_inap.kd_bangsal=? or jns_perawatan_inap.kd_bangsal='-') "+
"and (jns_perawatan_inap.kd_jenis_prw like ? or jns_perawatan_inap.nm_perawatan like ? or kategori_perawatan.nm_kategori like ?) order by jns_perawatan_inap.nm_perawatan");
pscari3.setString(1,"%"+NmKtg.getText().trim()+"%");
pscari3.setString(2,kd_bangsal.trim());
pscari3.setString(3,"%"+TCari.getText().trim()+"%");
pscari3.setString(4,"%"+TCari.getText().trim()+"%");
pscari3.setString(5,"%"+TCari.getText().trim()+"%");
rs=pscari3.executeQuery();
}else if(ruang_ranap.equals("No")&&cara_bayar_ranap.equals("No")&&kelas_ranap.equals("No")){
pscari4=koneksi.prepareStatement("select jns_perawatan_inap.kd_jenis_prw,jns_perawatan_inap.nm_perawatan,kategori_perawatan.nm_kategori,"+
"jns_perawatan_inap.total_byrdr,jns_perawatan_inap.total_byrpr,jns_perawatan_inap.total_byrdrpr,jns_perawatan_inap.bhp,jns_perawatan_inap.material,jns_perawatan_inap.kso,jns_perawatan_inap.menejemen," +
"jns_perawatan_inap.tarif_tindakandr,jns_perawatan_inap.tarif_tindakanpr,jns_perawatan_inap.kelas from jns_perawatan_inap inner join kategori_perawatan "+
"on jns_perawatan_inap.kd_kategori=kategori_perawatan.kd_kategori "+
"where jns_perawatan_inap.status='1' and kategori_perawatan.nm_kategori like ? "+
"and (jns_perawatan_inap.kd_jenis_prw like ? or jns_perawatan_inap.nm_perawatan like ? or kategori_perawatan.nm_kategori like ?) order by jns_perawatan_inap.nm_perawatan");
pscari4.setString(1,"%"+NmKtg.getText().trim()+"%");
pscari4.setString(2,"%"+TCari.getText().trim()+"%");
pscari4.setString(3,"%"+TCari.getText().trim()+"%");
pscari4.setString(4,"%"+TCari.getText().trim()+"%");
rs=pscari4.executeQuery();
}else if(ruang_ranap.equals("Yes")&&cara_bayar_ranap.equals("Yes")&&kelas_ranap.equals("Yes")){
pscari5=koneksi.prepareStatement("select jns_perawatan_inap.kd_jenis_prw,jns_perawatan_inap.nm_perawatan,kategori_perawatan.nm_kategori,"+
"jns_perawatan_inap.total_byrdr,jns_perawatan_inap.total_byrpr,jns_perawatan_inap.total_byrdrpr,jns_perawatan_inap.bhp,jns_perawatan_inap.material,jns_perawatan_inap.kso,jns_perawatan_inap.menejemen," +
"jns_perawatan_inap.tarif_tindakandr,jns_perawatan_inap.tarif_tindakanpr,jns_perawatan_inap.kelas from jns_perawatan_inap inner join kategori_perawatan "+
"on jns_perawatan_inap.kd_kategori=kategori_perawatan.kd_kategori "+
"where jns_perawatan_inap.status='1' and kategori_perawatan.nm_kategori like ? and jns_perawatan_inap.status='1' and (jns_perawatan_inap.kd_pj=? or jns_perawatan_inap.kd_pj='-') and (jns_perawatan_inap.kd_bangsal=? or jns_perawatan_inap.kd_bangsal='-') and (jns_perawatan_inap.kelas=? or jns_perawatan_inap.kelas='-') "+
"and (jns_perawatan_inap.kd_jenis_prw like ? or jns_perawatan_inap.nm_perawatan like ? or kategori_perawatan.nm_kategori like ?) order by jns_perawatan_inap.nm_perawatan");
pscari5.setString(1,"%"+NmKtg.getText().trim()+"%");
pscari5.setString(2,kd_pj.trim());
pscari5.setString(3,kd_bangsal.trim());
pscari5.setString(4,kelas.trim());
pscari5.setString(5,"%"+TCari.getText().trim()+"%");
pscari5.setString(6,"%"+TCari.getText().trim()+"%");
pscari5.setString(7,"%"+TCari.getText().trim()+"%");
rs=pscari5.executeQuery();
}else if(ruang_ranap.equals("No")&&cara_bayar_ranap.equals("Yes")&&kelas_ranap.equals("Yes")){
pscari6=koneksi.prepareStatement("select jns_perawatan_inap.kd_jenis_prw,jns_perawatan_inap.nm_perawatan,kategori_perawatan.nm_kategori,"+
"jns_perawatan_inap.total_byrdr,jns_perawatan_inap.total_byrpr,jns_perawatan_inap.total_byrdrpr,jns_perawatan_inap.bhp,jns_perawatan_inap.material,jns_perawatan_inap.kso,jns_perawatan_inap.menejemen," +
"jns_perawatan_inap.tarif_tindakandr,jns_perawatan_inap.tarif_tindakanpr,jns_perawatan_inap.kelas from jns_perawatan_inap inner join kategori_perawatan "+
"on jns_perawatan_inap.kd_kategori=kategori_perawatan.kd_kategori "+
"where jns_perawatan_inap.status='1' and kategori_perawatan.nm_kategori like ? and jns_perawatan_inap.status='1' and (jns_perawatan_inap.kd_pj=? or jns_perawatan_inap.kd_pj='-') and (jns_perawatan_inap.kelas=? or jns_perawatan_inap.kelas='-') "+
"and (jns_perawatan_inap.kd_jenis_prw like ? or jns_perawatan_inap.nm_perawatan like ? or kategori_perawatan.nm_kategori like ?) order by jns_perawatan_inap.nm_perawatan");
pscari6.setString(1,"%"+NmKtg.getText().trim()+"%");
pscari6.setString(2,kd_pj.trim());
pscari6.setString(3,kelas.trim());
pscari6.setString(4,"%"+TCari.getText().trim()+"%");
pscari6.setString(5,"%"+TCari.getText().trim()+"%");
pscari6.setString(6,"%"+TCari.getText().trim()+"%");
rs=pscari6.executeQuery();
}else if(ruang_ranap.equals("Yes")&&cara_bayar_ranap.equals("No")&&kelas_ranap.equals("Yes")){
pscari7=koneksi.prepareStatement("select jns_perawatan_inap.kd_jenis_prw,jns_perawatan_inap.nm_perawatan,kategori_perawatan.nm_kategori,"+
"jns_perawatan_inap.total_byrdr,jns_perawatan_inap.total_byrpr,jns_perawatan_inap.total_byrdrpr,jns_perawatan_inap.bhp,jns_perawatan_inap.material,jns_perawatan_inap.kso,jns_perawatan_inap.menejemen," +
"jns_perawatan_inap.tarif_tindakandr,jns_perawatan_inap.tarif_tindakanpr,jns_perawatan_inap.kelas from jns_perawatan_inap inner join kategori_perawatan "+
"on jns_perawatan_inap.kd_kategori=kategori_perawatan.kd_kategori "+
"where jns_perawatan_inap.status='1' and kategori_perawatan.nm_kategori like ? and jns_perawatan_inap.status='1' and (jns_perawatan_inap.kd_bangsal=? or jns_perawatan_inap.kd_bangsal='-') and (jns_perawatan_inap.kelas=? or jns_perawatan_inap.kelas='-') "+
"and (jns_perawatan_inap.kd_jenis_prw like ? or jns_perawatan_inap.nm_perawatan like ? or kategori_perawatan.nm_kategori like ?) order by jns_perawatan_inap.nm_perawatan");
pscari7.setString(1,"%"+NmKtg.getText().trim()+"%");
pscari7.setString(2,kd_bangsal.trim());
pscari7.setString(3,kelas.trim());
pscari7.setString(4,"%"+TCari.getText().trim()+"%");
pscari7.setString(5,"%"+TCari.getText().trim()+"%");
pscari7.setString(6,"%"+TCari.getText().trim()+"%");
rs=pscari7.executeQuery();
}else if(ruang_ranap.equals("No")&&cara_bayar_ranap.equals("No")&&kelas_ranap.equals("Yes")){
pscari8=koneksi.prepareStatement("select jns_perawatan_inap.kd_jenis_prw,jns_perawatan_inap.nm_perawatan,kategori_perawatan.nm_kategori,"+
"jns_perawatan_inap.total_byrdr,jns_perawatan_inap.total_byrpr,jns_perawatan_inap.total_byrdrpr,jns_perawatan_inap.bhp,jns_perawatan_inap.material,jns_perawatan_inap.kso,jns_perawatan_inap.menejemen," +
"jns_perawatan_inap.tarif_tindakandr,jns_perawatan_inap.tarif_tindakanpr,jns_perawatan_inap.kelas from jns_perawatan_inap inner join kategori_perawatan "+
"on jns_perawatan_inap.kd_kategori=kategori_perawatan.kd_kategori "+
"where jns_perawatan_inap.status='1' and kategori_perawatan.nm_kategori like ? and jns_perawatan_inap.status='1' and (jns_perawatan_inap.kelas=? or jns_perawatan_inap.kelas='-') "+
"and (jns_perawatan_inap.kd_jenis_prw like ? or jns_perawatan_inap.nm_perawatan like ? or kategori_perawatan.nm_kategori like ?) order by jns_perawatan_inap.nm_perawatan");
pscari8.setString(1,"%"+NmKtg.getText().trim()+"%");
pscari8.setString(2,kelas.trim());
pscari8.setString(3,"%"+TCari.getText().trim()+"%");
pscari8.setString(4,"%"+TCari.getText().trim()+"%");
pscari8.setString(5,"%"+TCari.getText().trim()+"%");
rs=pscari8.executeQuery();
}
while(rs.next()){
pg=false;
sg=false;
sr=false;
mlm=false;
switch (pilihtable) {
case "rawat_inap_dr":
pstindakan=koneksi.prepareStatement("select rawat_inap_dr.kd_jenis_prw from rawat_inap_dr where rawat_inap_dr.no_rawat=? "+
"and rawat_inap_dr.tgl_perawatan=? and rawat_inap_dr.kd_jenis_prw=? and rawat_inap_dr.jam_rawat between ? and ?");
try{
pstindakan.setString(1,TNoRw.getText());
pstindakan.setString(2,Valid.SetTgl(DTPTgl.getSelectedItem()+""));
pstindakan.setString(3,rs.getString(1));
pstindakan.setString(4,"00:00:01");
pstindakan.setString(5,"10:00:00");
rstindakan=pstindakan.executeQuery();
if(rstindakan.next()){
pg=true;
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rstindakan!=null){
rstindakan.close();
}
if(pstindakan!=null){
pstindakan.close();
}
}
pstindakan=koneksi.prepareStatement("select rawat_inap_dr.kd_jenis_prw from rawat_inap_dr where rawat_inap_dr.no_rawat=? "+
"and rawat_inap_dr.tgl_perawatan=? and rawat_inap_dr.kd_jenis_prw=? and rawat_inap_dr.jam_rawat between ? and ?");
try{
pstindakan.setString(1,TNoRw.getText());
pstindakan.setString(2,Valid.SetTgl(DTPTgl.getSelectedItem()+""));
pstindakan.setString(3,rs.getString(1));
pstindakan.setString(4,"10:00:01");
pstindakan.setString(5,"15:00:00");
rstindakan=pstindakan.executeQuery();
if(rstindakan.next()){
sg=true;
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rstindakan!=null){
rstindakan.close();
}
if(pstindakan!=null){
pstindakan.close();
}
}
pstindakan=koneksi.prepareStatement("select rawat_inap_dr.kd_jenis_prw from rawat_inap_dr where rawat_inap_dr.no_rawat=? "+
"and rawat_inap_dr.tgl_perawatan=? and rawat_inap_dr.kd_jenis_prw=? and rawat_inap_dr.jam_rawat between ? and ?");
try{
pstindakan.setString(1,TNoRw.getText());
pstindakan.setString(2,Valid.SetTgl(DTPTgl.getSelectedItem()+""));
pstindakan.setString(3,rs.getString(1));
pstindakan.setString(4,"15:00:01");
pstindakan.setString(5,"19:00:00");
rstindakan=pstindakan.executeQuery();
if(rstindakan.next()){
sr=true;
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rstindakan!=null){
rstindakan.close();
}
if(pstindakan!=null){
pstindakan.close();
}
}
pstindakan=koneksi.prepareStatement("select rawat_inap_dr.kd_jenis_prw from rawat_inap_dr where rawat_inap_dr.no_rawat=? "+
"and rawat_inap_dr.tgl_perawatan=? and rawat_inap_dr.kd_jenis_prw=? and rawat_inap_dr.jam_rawat between ? and ?");
try{
pstindakan.setString(1,TNoRw.getText());
pstindakan.setString(2,Valid.SetTgl(DTPTgl.getSelectedItem()+""));
pstindakan.setString(3,rs.getString(1));
pstindakan.setString(4,"19:00:01");
pstindakan.setString(5,"23:59:59");
rstindakan=pstindakan.executeQuery();
if(rstindakan.next()){
mlm=true;
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rstindakan!=null){
rstindakan.close();
}
if(pstindakan!=null){
pstindakan.close();
}
}
break;
case "rawat_inap_pr":
pstindakan2=koneksi.prepareStatement("select rawat_inap_pr.kd_jenis_prw from rawat_inap_pr where rawat_inap_pr.no_rawat=? "+
"and rawat_inap_pr.tgl_perawatan=? and rawat_inap_pr.kd_jenis_prw=? and rawat_inap_pr.jam_rawat between ? and ?");
try{
pstindakan2.setString(1,TNoRw.getText());
pstindakan2.setString(2,Valid.SetTgl(DTPTgl.getSelectedItem()+""));
pstindakan2.setString(3,rs.getString(1));
pstindakan2.setString(4,"00:00:01");
pstindakan2.setString(5,"10:00:00");
rstindakan=pstindakan2.executeQuery();
if(rstindakan.next()){
pg=true;
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rstindakan!=null){
rstindakan.close();
}
if(pstindakan2!=null){
pstindakan2.close();
}
}
pstindakan2=koneksi.prepareStatement("select rawat_inap_pr.kd_jenis_prw from rawat_inap_pr where rawat_inap_pr.no_rawat=? "+
"and rawat_inap_pr.tgl_perawatan=? and rawat_inap_pr.kd_jenis_prw=? and rawat_inap_pr.jam_rawat between ? and ?");
try{
pstindakan2.setString(1,TNoRw.getText());
pstindakan2.setString(2,Valid.SetTgl(DTPTgl.getSelectedItem()+""));
pstindakan2.setString(3,rs.getString(1));
pstindakan2.setString(4,"10:00:01");
pstindakan2.setString(5,"15:00:00");
rstindakan=pstindakan2.executeQuery();
if(rstindakan.next()){
sg=true;
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rstindakan!=null){
rstindakan.close();
}
if(pstindakan2!=null){
pstindakan2.close();
}
}
pstindakan2=koneksi.prepareStatement("select rawat_inap_pr.kd_jenis_prw from rawat_inap_pr where rawat_inap_pr.no_rawat=? "+
"and rawat_inap_pr.tgl_perawatan=? and rawat_inap_pr.kd_jenis_prw=? and rawat_inap_pr.jam_rawat between ? and ?");
try{
pstindakan2.setString(1,TNoRw.getText());
pstindakan2.setString(2,Valid.SetTgl(DTPTgl.getSelectedItem()+""));
pstindakan2.setString(3,rs.getString(1));
pstindakan2.setString(4,"15:00:01");
pstindakan2.setString(5,"19:00:00");
rstindakan=pstindakan2.executeQuery();
if(rstindakan.next()){
sr=true;
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rstindakan!=null){
rstindakan.close();
}
if(pstindakan2!=null){
pstindakan2.close();
}
}
pstindakan2=koneksi.prepareStatement("select rawat_inap_pr.kd_jenis_prw from rawat_inap_pr where rawat_inap_pr.no_rawat=? "+
"and rawat_inap_pr.tgl_perawatan=? and rawat_inap_pr.kd_jenis_prw=? and rawat_inap_pr.jam_rawat between ? and ?");
try{
pstindakan2.setString(1,TNoRw.getText());
pstindakan2.setString(2,Valid.SetTgl(DTPTgl.getSelectedItem()+""));
pstindakan2.setString(3,rs.getString(1));
pstindakan2.setString(4,"19:00:01");
pstindakan2.setString(5,"23:59:59");
rstindakan=pstindakan2.executeQuery();
if(rstindakan.next()){
mlm=true;
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rstindakan!=null){
rstindakan.close();
}
if(pstindakan2!=null){
pstindakan2.close();
}
}
break;
case "rawat_inap_drpr":
pstindakan3=koneksi.prepareStatement("select rawat_inap_drpr.kd_jenis_prw from rawat_inap_drpr where rawat_inap_drpr.no_rawat=? "+
"and rawat_inap_drpr.tgl_perawatan=? and rawat_inap_drpr.kd_jenis_prw=? and rawat_inap_drpr.jam_rawat between ? and ?");
try{
pstindakan3.setString(1,TNoRw.getText());
pstindakan3.setString(2,Valid.SetTgl(DTPTgl.getSelectedItem()+""));
pstindakan3.setString(3,rs.getString(1));
pstindakan3.setString(4,"00:00:01");
pstindakan3.setString(5,"10:00:00");
rstindakan=pstindakan3.executeQuery();
if(rstindakan.next()){
pg=true;
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rstindakan!=null){
rstindakan.close();
}
if(pstindakan3!=null){
pstindakan3.close();
}
}
pstindakan3=koneksi.prepareStatement("select rawat_inap_drpr.kd_jenis_prw from rawat_inap_drpr where rawat_inap_drpr.no_rawat=? "+
"and rawat_inap_drpr.tgl_perawatan=? and rawat_inap_drpr.kd_jenis_prw=? and rawat_inap_drpr.jam_rawat between ? and ?");
try{
pstindakan3.setString(1,TNoRw.getText());
pstindakan3.setString(2,Valid.SetTgl(DTPTgl.getSelectedItem()+""));
pstindakan3.setString(3,rs.getString(1));
pstindakan3.setString(4,"10:00:01");
pstindakan3.setString(5,"15:00:00");
rstindakan=pstindakan3.executeQuery();
if(rstindakan.next()){
sg=true;
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rstindakan!=null){
rstindakan.close();
}
if(pstindakan3!=null){
pstindakan3.close();
}
}
pstindakan3=koneksi.prepareStatement("select rawat_inap_drpr.kd_jenis_prw from rawat_inap_drpr where rawat_inap_drpr.no_rawat=? "+
"and rawat_inap_drpr.tgl_perawatan=? and rawat_inap_drpr.kd_jenis_prw=? and rawat_inap_drpr.jam_rawat between ? and ?");
try{
pstindakan3.setString(1,TNoRw.getText());
pstindakan3.setString(2,Valid.SetTgl(DTPTgl.getSelectedItem()+""));
pstindakan3.setString(3,rs.getString(1));
pstindakan3.setString(4,"15:00:01");
pstindakan3.setString(5,"19:00:00");
rstindakan=pstindakan3.executeQuery();
if(rstindakan.next()){
sr=true;
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rstindakan!=null){
rstindakan.close();
}
if(pstindakan3!=null){
pstindakan3.close();
}
}
pstindakan3=koneksi.prepareStatement("select rawat_inap_drpr.kd_jenis_prw from rawat_inap_drpr where rawat_inap_drpr.no_rawat=? "+
"and rawat_inap_drpr.tgl_perawatan=? and rawat_inap_drpr.kd_jenis_prw=? and rawat_inap_drpr.jam_rawat between ? and ?");
try{
pstindakan3.setString(1,TNoRw.getText());
pstindakan3.setString(2,Valid.SetTgl(DTPTgl.getSelectedItem()+""));
pstindakan3.setString(3,rs.getString(1));
pstindakan3.setString(4,"19:00:01");
pstindakan3.setString(5,"23:59:59");
rstindakan=pstindakan3.executeQuery();
if(rstindakan.next()){
mlm=true;
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rstindakan!=null){
rstindakan.close();
}
if(pstindakan3!=null){
pstindakan3.close();
}
}
break;
}
switch (pilihtable) {
case "rawat_inap_dr":
if(rs.getDouble("total_byrdr")>0){
tabMode.addRow(new Object[] {
pg,sg,sr,mlm,rs.getString(1),rs.getString(2),rs.getString(3),
rs.getDouble("total_byrdr"),rs.getDouble("material"),
rs.getDouble("bhp"),rs.getDouble("tarif_tindakandr"),
rs.getDouble("tarif_tindakanpr"),rs.getDouble("kso"),
rs.getDouble("menejemen"),rs.getString("kelas")
});
}
break;
case "rawat_inap_pr":
if(rs.getDouble("total_byrpr")>0){
tabMode.addRow(new Object[] {
pg,sg,sr,mlm,rs.getString(1),rs.getString(2),rs.getString(3),
rs.getDouble("total_byrpr"),rs.getDouble("material"),
rs.getDouble("bhp"),rs.getDouble("tarif_tindakandr"),
rs.getDouble("tarif_tindakanpr"),rs.getDouble("kso"),
rs.getDouble("menejemen"),rs.getString("kelas")
});
}
break;
case "rawat_inap_drpr":
if(rs.getDouble("total_byrdrpr")>0){
tabMode.addRow(new Object[] {
pg,sg,sr,mlm,rs.getString(1),rs.getString(2),rs.getString(3),
rs.getDouble("total_byrdrpr"),rs.getDouble("material"),
rs.getDouble("bhp"),rs.getDouble("tarif_tindakandr"),
rs.getDouble("tarif_tindakanpr"),rs.getDouble("kso"),
rs.getDouble("menejemen"),rs.getString("kelas")
});
}
break;
}
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
} finally{
if(rs != null){
rs.close();
}
if(pscari != null){
pscari.close();
}
if(pscari2 != null){
pscari2.close();
}
if(pscari3 != null){
pscari3.close();
}
if(pscari4 != null){
pscari4.close();
}
}
}catch(Exception e){
System.out.println("Notifikasi : "+e);
}
LCount.setText(""+tbKamar.getRowCount());
}
private void emptTeks() {
TCari.setText("");
for(i=0;i