private void BtnSeek2ActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_BtnSeek2ActionPerformed
var.setStatus(true);
bangsal.tampil();
bangsal.emptTeks();
bangsal.setSize(internalFrame1.getWidth() - 50, internalFrame1.getHeight() - 50);
bangsal.setLocationRelativeTo(internalFrame1);
bangsal.setAlwaysOnTop(false);
bangsal.setVisible(true);
} // GEN-LAST:event_BtnSeek2ActionPerformed
/**
* Creates new form DlgProgramStudi
*
* @param parent
* @param modal
*/
public DlgRHTindakanParamedis(java.awt.Frame parent, boolean modal) {
super(parent, modal);
initComponents();
Object[] row = {
"No.", "Nama Paramedis", "Tgl.Tindakan", "Nama Pasien", "Tindakan Medis", "Jasa Medis"
};
tabMode =
new DefaultTableModel(null, row) {
@Override
public boolean isCellEditable(int rowIndex, int colIndex) {
return false;
}
};
tbDokter.setModel(tabMode);
tbDokter.setPreferredScrollableViewportSize(new Dimension(800, 800));
tbDokter.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
for (i = 0; i < 6; i++) {
TableColumn column = tbDokter.getColumnModel().getColumn(i);
if (i == 0) {
column.setPreferredWidth(35);
} else if (i == 1) {
column.setPreferredWidth(200);
} else if (i == 2) {
column.setPreferredWidth(130);
} else if (i == 3) {
column.setPreferredWidth(250);
} else if (i == 4) {
column.setPreferredWidth(250);
} else if (i == 5) {
column.setPreferredWidth(100);
}
}
tbDokter.setDefaultRenderer(Object.class, new WarnaTable());
kdbangsal.setDocument(new batasInput((byte) 5).getKata(kdbangsal));
bangsal
.getTable()
.addMouseListener(
new MouseListener() {
@Override
public void mouseClicked(MouseEvent e) {
kdbangsal.setText(bangsal.getTextField().getText());
Sequel.cariIsi(
"select nama from petugas where nip='" + bangsal.getTextField().getText() + "'",
nmbangsal);
prosesCari();
}
@Override
public void mousePressed(MouseEvent e) {}
@Override
public void mouseReleased(MouseEvent e) {}
@Override
public void mouseEntered(MouseEvent e) {}
@Override
public void mouseExited(MouseEvent e) {}
});
try {
ps = koneksi.prepareStatement("select nip,nama from petugas where nip like ? order by nama");
ps2 =
koneksi.prepareStatement(
"select pasien.nm_pasien,jns_perawatan.tarif_tindakanpr,"
+ "jns_perawatan.nm_perawatan,reg_periksa.tgl_registrasi "
+ "from pasien inner join reg_periksa "
+ "inner join jns_perawatan inner join rawat_jl_pr "
+ "on rawat_jl_pr.no_rawat=reg_periksa.no_rawat "
+ "and reg_periksa.no_rkm_medis=pasien.no_rkm_medis "
+ "and rawat_jl_pr.kd_jenis_prw=jns_perawatan.kd_jenis_prw "
+ "where reg_periksa.tgl_registrasi between ? and ? and rawat_jl_pr.nip=? "
+ " and jns_perawatan.total_byrpr>0 order by reg_periksa.tgl_registrasi,jns_perawatan.nm_perawatan");
ps4 =
koneksi.prepareStatement(
"select jns_perawatan.tarif_tindakanpr,pasien.nm_pasien,"
+ "jns_perawatan.nm_perawatan,periksa_lab.tgl_periksa,periksa_lab.jam "
+ " from periksa_lab inner join reg_periksa inner join pasien inner join petugas inner join jns_perawatan "
+ " on periksa_lab.no_rawat=reg_periksa.no_rawat and reg_periksa.no_rkm_medis=pasien.no_rkm_medis "
+ " and periksa_lab.nip=petugas.nip and periksa_lab.kd_jenis_prw=jns_perawatan.kd_jenis_prw "
+ " where periksa_lab.tgl_periksa between ? and ? and periksa_lab.nip=? order by periksa_lab.tgl_periksa,periksa_lab.jam,jns_perawatan.nm_perawatan ");
ps3 =
koneksi.prepareStatement(
"select jns_perawatan_inap.tarif_tindakanpr,pasien.nm_pasien,jns_perawatan_inap.nm_perawatan,"
+ "rawat_inap_pr.tgl_perawatan,rawat_inap_pr.jam_rawat "
+ "from pasien inner join reg_periksa inner join jns_perawatan_inap inner join rawat_inap_pr "
+ "on rawat_inap_pr.no_rawat=reg_periksa.no_rawat "
+ "and reg_periksa.no_rkm_medis=pasien.no_rkm_medis "
+ "and rawat_inap_pr.kd_jenis_prw=jns_perawatan_inap.kd_jenis_prw "
+ "where rawat_inap_pr.tgl_perawatan between ? and ? and rawat_inap_pr.nip=? "
+ " and jns_perawatan_inap.total_byrpr>0 order by rawat_inap_pr.tgl_perawatan,rawat_inap_pr.jam_rawat,jns_perawatan_inap.nm_perawatan ");
ps5 =
koneksi.prepareStatement(
"select operasi.biayaasisten_operator1,pasien.nm_pasien,paket_operasi.nm_perawatan,"
+ "operasi.tgl_operasi from operasi inner join reg_periksa inner join pasien inner join paket_operasi "
+ "on operasi.no_rawat=reg_periksa.no_rawat and reg_periksa.no_rkm_medis=pasien.no_rkm_medis and operasi.kode_paket=paket_operasi.kode_paket "
+ "where operasi.tgl_operasi between ? and ? and operasi.asisten_operator1=? "
+ " and operasi.biayaasisten_operator1>0 order by operasi.tgl_operasi,paket_operasi.nm_perawatan");
ps6 =
koneksi.prepareStatement(
"select operasi.biayaasisten_operator2,pasien.nm_pasien,paket_operasi.nm_perawatan,"
+ "operasi.tgl_operasi from operasi inner join reg_periksa inner join pasien inner join paket_operasi "
+ "on operasi.no_rawat=reg_periksa.no_rawat and reg_periksa.no_rkm_medis=pasien.no_rkm_medis and operasi.kode_paket=paket_operasi.kode_paket "
+ "where operasi.tgl_operasi between ? and ? and operasi.asisten_operator2=? "
+ " and operasi.biayaasisten_operator2>0 order by operasi.tgl_operasi,paket_operasi.nm_perawatan");
ps7 =
koneksi.prepareStatement(
"select operasi.biayaasisten_operator3,pasien.nm_pasien,paket_operasi.nm_perawatan,"
+ "operasi.tgl_operasi from operasi inner join reg_periksa inner join pasien inner join paket_operasi "
+ "on operasi.no_rawat=reg_periksa.no_rawat and reg_periksa.no_rkm_medis=pasien.no_rkm_medis and operasi.kode_paket=paket_operasi.kode_paket "
+ "where operasi.tgl_operasi between ? and ? and operasi.asisten_operator3=? "
+ " and operasi.biayaasisten_operator3>0 order by operasi.tgl_operasi,paket_operasi.nm_perawatan");
ps8 =
koneksi.prepareStatement(
"select operasi.biayaperawaat_resusitas,pasien.nm_pasien,paket_operasi.nm_perawatan,"
+ "operasi.tgl_operasi from operasi inner join reg_periksa inner join pasien inner join paket_operasi "
+ "on operasi.no_rawat=reg_periksa.no_rawat and reg_periksa.no_rkm_medis=pasien.no_rkm_medis and operasi.kode_paket=paket_operasi.kode_paket "
+ "where operasi.tgl_operasi between ? and ? and operasi.perawaat_resusitas=? "
+ " and operasi.biayaperawaat_resusitas>0 order by operasi.tgl_operasi,paket_operasi.nm_perawatan");
ps9 =
koneksi.prepareStatement(
"select operasi.biayaasisten_anestesi,pasien.nm_pasien,paket_operasi.nm_perawatan,"
+ "operasi.tgl_operasi from operasi inner join reg_periksa inner join pasien inner join paket_operasi "
+ "on operasi.no_rawat=reg_periksa.no_rawat and reg_periksa.no_rkm_medis=pasien.no_rkm_medis and operasi.kode_paket=paket_operasi.kode_paket "
+ "where operasi.tgl_operasi between ? and ? and operasi.asisten_anestesi=? "
+ " and operasi.biayaasisten_anestesi>0 order by operasi.tgl_operasi,paket_operasi.nm_perawatan");
ps10 =
koneksi.prepareStatement(
"select operasi.biayabidan,pasien.nm_pasien,paket_operasi.nm_perawatan,"
+ "operasi.tgl_operasi from operasi inner join reg_periksa inner join pasien inner join paket_operasi "
+ "on operasi.no_rawat=reg_periksa.no_rawat and reg_periksa.no_rkm_medis=pasien.no_rkm_medis and operasi.kode_paket=paket_operasi.kode_paket "
+ "where operasi.tgl_operasi between ? and ? and operasi.bidan=? "
+ " and operasi.biayabidan>0 order by operasi.tgl_operasi,paket_operasi.nm_perawatan");
ps11 =
koneksi.prepareStatement(
"select operasi.biayaperawat_luar,pasien.nm_pasien,paket_operasi.nm_perawatan,"
+ "operasi.tgl_operasi from operasi inner join reg_periksa inner join pasien inner join paket_operasi "
+ "on operasi.no_rawat=reg_periksa.no_rawat and reg_periksa.no_rkm_medis=pasien.no_rkm_medis and operasi.kode_paket=paket_operasi.kode_paket "
+ "where operasi.tgl_operasi between ? and ? and operasi.perawat_luar=? "
+ " and operasi.biayaperawat_luar>0 order by operasi.tgl_operasi,paket_operasi.nm_perawatan");
} catch (SQLException e) {
System.out.println(e);
}
}
