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); } }