/* * To change this template, choose Tools | Templates * and open the template in the editor. */ /* * DlgJnsPerawatan.java * * Created on May 22, 2010, 11:58:21 PM */ package informasi; import fungsi.WarnaTable; import fungsi.batasInput; import fungsi.koneksiDB; import fungsi.sekuel; import fungsi.validasi; import java.awt.Dimension; import java.awt.event.KeyEvent; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import javax.swing.JTable; import javax.swing.event.DocumentEvent; import javax.swing.table.DefaultTableModel; import javax.swing.table.TableColumn; /** * * @author dosen */ public final class InformasiTarifOperasi 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 pstampil; private ResultSet rs; /** Creates new form DlgJnsPerawatan * @param parent * @param modal */ public InformasiTarifOperasi(java.awt.Frame parent, boolean modal) { super(parent, modal); initComponents(); this.setLocation(8,1); setSize(628,674); Object[] row={"Kode Paket","Nama Operasi","Tarif Operasi","Jenis Bayar"}; tabMode=new DefaultTableModel(null,row){ @Override public boolean isCellEditable(int rowIndex, int colIndex){return false;} }; tbJnsPerawatan.setModel(tabMode); //tbObat.setDefaultRenderer(Object.class, new WarnaTable(panelJudul.getBackground(),tbObat.getBackground())); tbJnsPerawatan.setPreferredScrollableViewportSize(new Dimension(500,500)); tbJnsPerawatan.setAutoResizeMode(JTable.AUTO_RESIZE_OFF); for (int i = 0; i < 4; i++) { TableColumn column = tbJnsPerawatan.getColumnModel().getColumn(i); if(i==0){ column.setPreferredWidth(100); }else if(i==1){ column.setPreferredWidth(490); }else{ column.setPreferredWidth(130); } } tbJnsPerawatan.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(); } } }); } } /** 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() { internalFrame1 = new widget.InternalFrame(); Scroll = new widget.ScrollPane(); tbJnsPerawatan = new widget.Table(); panelGlass9 = new widget.panelisi(); jLabel6 = new widget.Label(); TCari = new widget.TextBox(); BtnCari = new widget.Button(); BtnAll = new widget.Button(); jLabel7 = new widget.Label(); LCount = new widget.Label(); BtnKeluar = new widget.Button(); setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE); setUndecorated(true); setResizable(false); addWindowListener(new java.awt.event.WindowAdapter() { public void windowActivated(java.awt.event.WindowEvent evt) { formWindowActivated(evt); } public void windowOpened(java.awt.event.WindowEvent evt) { formWindowOpened(evt); } }); internalFrame1.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(240, 245, 235)), "::[ Informasi Tarif Tindakan Operasi/VK ]::", 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.setName("Scroll"); // NOI18N Scroll.setOpaque(true); tbJnsPerawatan.setAutoCreateRowSorter(true); tbJnsPerawatan.setToolTipText("Silahkan klik untuk memilih data yang mau diedit ataupun dihapus"); tbJnsPerawatan.setName("tbJnsPerawatan"); // NOI18N Scroll.setViewportView(tbJnsPerawatan); internalFrame1.add(Scroll, java.awt.BorderLayout.CENTER); panelGlass9.setName("panelGlass9"); // NOI18N panelGlass9.setPreferredSize(new java.awt.Dimension(44, 44)); panelGlass9.setLayout(new java.awt.FlowLayout(java.awt.FlowLayout.LEFT, 5, 9)); jLabel6.setText("Key Word :"); jLabel6.setName("jLabel6"); // NOI18N jLabel6.setPreferredSize(new java.awt.Dimension(70, 23)); panelGlass9.add(jLabel6); TCari.setName("TCari"); // NOI18N TCari.setPreferredSize(new java.awt.Dimension(400, 23)); TCari.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { TCariKeyPressed(evt); } }); panelGlass9.add(TCari); BtnCari.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/accept.png"))); // NOI18N BtnCari.setMnemonic('2'); BtnCari.setToolTipText("Alt+2"); 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); } }); panelGlass9.add(BtnCari); BtnAll.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/Search-16x16.png"))); // NOI18N BtnAll.setMnemonic('4'); BtnAll.setToolTipText("Alt+4"); 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); } }); panelGlass9.add(BtnAll); jLabel7.setText("Record :"); jLabel7.setName("jLabel7"); // NOI18N jLabel7.setPreferredSize(new java.awt.Dimension(65, 23)); panelGlass9.add(jLabel7); LCount.setHorizontalAlignment(javax.swing.SwingConstants.LEFT); LCount.setText("0"); LCount.setName("LCount"); // NOI18N LCount.setPreferredSize(new java.awt.Dimension(50, 23)); panelGlass9.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); } }); panelGlass9.add(BtnKeluar); internalFrame1.add(panelGlass9, java.awt.BorderLayout.PAGE_END); 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_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 formWindowOpened(java.awt.event.WindowEvent evt) {//GEN-FIRST:event_formWindowOpened tampil(); }//GEN-LAST:event_formWindowOpened private void BtnKeluarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnKeluarActionPerformed dispose(); }//GEN-LAST:event_BtnKeluarActionPerformed 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){ TCari.setText(""); tampil(); }else{ Valid.pindah(evt, BtnCari, BtnKeluar); } }//GEN-LAST:event_BtnAllKeyPressed private void formWindowActivated(java.awt.event.WindowEvent evt) {//GEN-FIRST:event_formWindowActivated TCari.requestFocus(); }//GEN-LAST:event_formWindowActivated /** * @param args the command line arguments */ public static void main(String args[]) { java.awt.EventQueue.invokeLater(() -> { InformasiTarifOperasi dialog = new InformasiTarifOperasi(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.Label LCount; private widget.ScrollPane Scroll; private widget.TextBox TCari; private widget.InternalFrame internalFrame1; private widget.Label jLabel6; private widget.Label jLabel7; private widget.panelisi panelGlass9; private widget.Table tbJnsPerawatan; // End of variables declaration//GEN-END:variables private void tampil() { Valid.tabelKosong(tabMode); try{ pstampil=koneksi.prepareStatement("select paket_operasi.kode_paket, paket_operasi.nm_perawatan,(paket_operasi.operator1+paket_operasi.operator2+paket_operasi.operator3+"+ "paket_operasi.asisten_operator1+paket_operasi.asisten_operator2+paket_operasi.instrumen+"+ "paket_operasi.dokter_anak+paket_operasi.perawaat_resusitas+"+ "paket_operasi.alat+paket_operasi.dokter_anestesi+paket_operasi.asisten_anestesi+"+ "paket_operasi.bidan+paket_operasi.bidan2+paket_operasi.bidan3+paket_operasi.perawat_luar+"+ "paket_operasi.sewa_ok+paket_operasi.akomodasi+paket_operasi.bagian_rs+"+ "paket_operasi.omloop+paket_operasi.omloop2+paket_operasi.omloop3+"+ "paket_operasi.sarpras+paket_operasi.dokter_pjanak+paket_operasi.dokter_umum) as jumlah, "+ "penjab.png_jawab from paket_operasi inner join penjab on penjab.kd_pj=paket_operasi.kd_pj "+ "where paket_operasi.status='1' and paket_operasi.kode_paket like ? or "+ "paket_operasi.status='1' and paket_operasi.nm_perawatan like ? or "+ "paket_operasi.status='1' and penjab.png_jawab like ? order by paket_operasi.kode_paket "); try{ pstampil.setString(1,"%"+TCari.getText()+"%"); pstampil.setString(2,"%"+TCari.getText()+"%"); pstampil.setString(3,"%"+TCari.getText()+"%"); rs=pstampil.executeQuery(); while(rs.next()){ tabMode.addRow(new Object[]{rs.getString("kode_paket"), rs.getString("nm_perawatan"), Valid.SetAngka(rs.getDouble("jumlah")), rs.getString("png_jawab") }); } }catch(Exception e){ System.out.println(e); }finally{ if(rs!=null){ rs.close(); } if(pstampil!=null){ pstampil.close(); } } }catch(Exception e){ System.out.println("Notifikasi : "+e); } LCount.setText(""+tabMode.getRowCount()); } }