/* * To change this template, choose Tools | Templates * and open the template in the editor. */ /* * DlgReg.java * * Created on Jun 8, 2010, choose Tools | Templates * and open the template in10:28:56 PM */ package simrskhanza; import fungsi.WarnaTable; import fungsi.batasInput; import fungsi.koneksiDB; 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.JButton; import javax.swing.JTable; import javax.swing.event.DocumentEvent; import javax.swing.table.DefaultTableModel; import javax.swing.table.TableColumn; /** * * @author dosen */ public final class DlgCariReg extends javax.swing.JDialog { private final DefaultTableModel tabMode; private validasi Valid=new validasi(); private Connection koneksi=koneksiDB.condb(); private PreparedStatement ps; private ResultSet rs; private int i=0; /** Creates new form DlgReg * @param parent * @param modal */ public DlgCariReg(java.awt.Frame parent, boolean modal) { super(parent, modal); initComponents(); this.setLocation(8,1); setSize(885,674); tabMode=new DefaultTableModel(null,new Object[]{ "No.Reg","No.Rawat","Tanggal","Jam","Kd.Dokter","Dokter Dituju","Nomer RM", "Pasien","J.K.","Umur","Poliklinik","Jenis Bayar","Penanggung Jawab","Alamat P.J.","Hubungan P.J.", "Biaya Regristrasi","Status","No.Telp","Stts Rawat","Stts Poli","Kode Poli","Kode PJ" }){ @Override public boolean isCellEditable(int rowIndex, int colIndex){ boolean a = false; if (colIndex==0) { a=true; } return a; } Class[] types = new Class[] { java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class,java.lang.Object.class,java.lang.Object.class }; @Override public Class getColumnClass(int columnIndex) { return types [columnIndex]; } }; tbPetugas.setModel(tabMode); tbPetugas.setPreferredScrollableViewportSize(new Dimension(800,800)); tbPetugas.setAutoResizeMode(JTable.AUTO_RESIZE_OFF); for (i = 0; i < 22; i++) { TableColumn column = tbPetugas.getColumnModel().getColumn(i); if(i==0){ column.setPreferredWidth(50); }else if(i==1){ column.setPreferredWidth(120); }else if(i==2){ column.setPreferredWidth(70); }else if(i==3){ column.setPreferredWidth(50); }else if(i==4){ column.setPreferredWidth(70); }else if(i==5){ column.setPreferredWidth(200); }else if(i==6){ column.setPreferredWidth(70); }else if(i==7){ column.setPreferredWidth(200); }else if(i==8){ column.setPreferredWidth(30); }else if(i==9){ column.setPreferredWidth(50); }else if(i==10){ column.setPreferredWidth(140); }else if(i==11){ column.setPreferredWidth(140); }else if(i==12){ column.setPreferredWidth(200); }else if(i==13){ column.setPreferredWidth(140); }else if(i==14){ column.setPreferredWidth(90); }else if(i==15){ column.setPreferredWidth(100); }else if(i==16){ column.setPreferredWidth(80); }else if(i==17){ column.setPreferredWidth(80); }else if(i==18){ column.setPreferredWidth(70); }else if(i==19){ column.setPreferredWidth(60); }else if(i==20){ column.setMinWidth(0); column.setMaxWidth(0); }else if(i==21){ column.setMinWidth(0); column.setMaxWidth(0); } } tbPetugas.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(); tbPetugas = new widget.Table(); panelGlass7 = new widget.panelisi(); jLabel15 = new widget.Label(); DTPCari1 = new widget.Tanggal(); jLabel17 = new widget.Label(); DTPCari2 = new widget.Tanggal(); jLabel6 = new widget.Label(); TCari = new widget.TextBox(); BtnCari = new widget.Button(); BtnAll = new widget.Button(); jLabel10 = 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 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)), "::[ Registrasi Periksa Hari Ini ]::", 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.setToolTipText("Klik data di table, kemudian klik kanan untuk memilih menu yang diinginkan"); Scroll.setName("Scroll"); // NOI18N Scroll.setOpaque(true); tbPetugas.setToolTipText("Klik data di table, kemudian klik kanan untuk memilih menu yang diinginkan"); tbPetugas.setName("tbPetugas"); // NOI18N Scroll.setViewportView(tbPetugas); internalFrame1.add(Scroll, java.awt.BorderLayout.CENTER); panelGlass7.setName("panelGlass7"); // NOI18N panelGlass7.setPreferredSize(new java.awt.Dimension(44, 44)); panelGlass7.setLayout(new java.awt.FlowLayout(java.awt.FlowLayout.LEFT, 5, 9)); jLabel15.setText("Periode :"); jLabel15.setName("jLabel15"); // NOI18N jLabel15.setPreferredSize(new java.awt.Dimension(55, 23)); panelGlass7.add(jLabel15); DTPCari1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "28-02-2022" })); DTPCari1.setDisplayFormat("dd-MM-yyyy"); DTPCari1.setName("DTPCari1"); // NOI18N DTPCari1.setOpaque(false); DTPCari1.setPreferredSize(new java.awt.Dimension(90, 23)); panelGlass7.add(DTPCari1); jLabel17.setHorizontalAlignment(javax.swing.SwingConstants.CENTER); jLabel17.setText("s.d."); jLabel17.setName("jLabel17"); // NOI18N jLabel17.setPreferredSize(new java.awt.Dimension(24, 23)); panelGlass7.add(jLabel17); DTPCari2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "28-02-2022" })); DTPCari2.setDisplayFormat("dd-MM-yyyy"); DTPCari2.setName("DTPCari2"); // NOI18N DTPCari2.setOpaque(false); DTPCari2.setPreferredSize(new java.awt.Dimension(90, 23)); panelGlass7.add(DTPCari2); jLabel6.setText("Key Word :"); jLabel6.setName("jLabel6"); // NOI18N jLabel6.setPreferredSize(new java.awt.Dimension(68, 23)); panelGlass7.add(jLabel6); TCari.setName("TCari"); // NOI18N TCari.setPreferredSize(new java.awt.Dimension(236, 23)); TCari.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { TCariKeyPressed(evt); } }); panelGlass7.add(TCari); BtnCari.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/accept.png"))); // NOI18N BtnCari.setMnemonic('7'); BtnCari.setToolTipText("Alt+7"); 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); } }); panelGlass7.add(BtnCari); BtnAll.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/Search-16x16.png"))); // NOI18N BtnAll.setMnemonic('M'); BtnAll.setToolTipText("Alt+M"); 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); } }); panelGlass7.add(BtnAll); jLabel10.setText("Record :"); jLabel10.setName("jLabel10"); // NOI18N jLabel10.setPreferredSize(new java.awt.Dimension(60, 23)); panelGlass7.add(jLabel10); LCount.setHorizontalAlignment(javax.swing.SwingConstants.LEFT); LCount.setText("0"); LCount.setName("LCount"); // NOI18N LCount.setPreferredSize(new java.awt.Dimension(65, 23)); panelGlass7.add(LCount); BtnKeluar.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/exit.png"))); // NOI18N BtnKeluar.setMnemonic('K'); BtnKeluar.setToolTipText("Alt+K"); 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); } }); BtnKeluar.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { BtnKeluarKeyPressed(evt); } }); panelGlass7.add(BtnKeluar); internalFrame1.add(panelGlass7, java.awt.BorderLayout.PAGE_END); getContentPane().add(internalFrame1, java.awt.BorderLayout.CENTER); pack(); }// //GEN-END:initComponents private void formWindowOpened(java.awt.event.WindowEvent evt) {//GEN-FIRST:event_formWindowOpened tampil(); }//GEN-LAST:event_formWindowOpened private void BtnKeluarKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnKeluarKeyPressed if(evt.getKeyCode()==KeyEvent.VK_SPACE){ BtnKeluarActionPerformed(null); }else{Valid.pindah(evt,BtnAll,TCari);} }//GEN-LAST:event_BtnKeluarKeyPressed private void BtnKeluarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnKeluarActionPerformed dispose(); }//GEN-LAST:event_BtnKeluarActionPerformed private void BtnAllKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnAllKeyPressed if(evt.getKeyCode()==KeyEvent.VK_SPACE){ tampil(); TCari.setText(""); }else{ Valid.pindah(evt, BtnAll, BtnKeluar); } }//GEN-LAST:event_BtnAllKeyPressed private void BtnAllActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnAllActionPerformed TCari.setText(""); tampil(); }//GEN-LAST:event_BtnAllActionPerformed 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 BtnCariActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnCariActionPerformed tampil(); }//GEN-LAST:event_BtnCariActionPerformed 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 /** * @param args the command line arguments */ public static void main(String args[]) { java.awt.EventQueue.invokeLater(() -> { DlgCariReg dialog = new DlgCariReg(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.Tanggal DTPCari1; private widget.Tanggal DTPCari2; private widget.Label LCount; private widget.ScrollPane Scroll; private widget.TextBox TCari; private widget.InternalFrame internalFrame1; private widget.Label jLabel10; private widget.Label jLabel15; private widget.Label jLabel17; private widget.Label jLabel6; private widget.panelisi panelGlass7; private widget.Table tbPetugas; // End of variables declaration//GEN-END:variables private void tampil() { Valid.tabelKosong(tabMode); try { ps=koneksi.prepareStatement("select reg_periksa.no_reg,reg_periksa.no_rawat,reg_periksa.tgl_registrasi,reg_periksa.jam_reg,"+ "reg_periksa.kd_dokter,dokter.nm_dokter,reg_periksa.no_rkm_medis,pasien.nm_pasien,pasien.jk,concat(reg_periksa.umurdaftar,' ',reg_periksa.sttsumur)as umur,poliklinik.nm_poli,"+ "reg_periksa.p_jawab,reg_periksa.almt_pj,reg_periksa.hubunganpj,reg_periksa.biaya_reg,reg_periksa.stts_daftar,penjab.png_jawab,pasien.no_tlp,reg_periksa.stts,reg_periksa.status_poli, "+ "reg_periksa.kd_poli,reg_periksa.kd_pj from reg_periksa inner join dokter on reg_periksa.kd_dokter=dokter.kd_dokter inner join pasien on reg_periksa.no_rkm_medis=pasien.no_rkm_medis "+ "inner join poliklinik on reg_periksa.kd_poli=poliklinik.kd_poli inner join penjab on reg_periksa.kd_pj=penjab.kd_pj where "+ "reg_periksa.tgl_registrasi between ? and ? "+(TCari.getText().trim().equals("")?"":"and (reg_periksa.no_rawat like ? or reg_periksa.kd_dokter like ? or dokter.nm_dokter like ? or "+ "reg_periksa.no_rkm_medis like ? or reg_periksa.stts_daftar like ? or pasien.nm_pasien like ? or poliklinik.nm_poli like ? or reg_periksa.p_jawab like ? or reg_periksa.almt_pj like ? "+ "or reg_periksa.hubunganpj like ? or penjab.png_jawab like ?)")+" order by pasien.nm_pasien"); try{ ps.setString(1,Valid.SetTgl(DTPCari1.getSelectedItem()+"")); ps.setString(2,Valid.SetTgl(DTPCari2.getSelectedItem()+"")); if(!TCari.getText().trim().equals("")){ ps.setString(3,"%"+TCari.getText().trim()+"%"); ps.setString(4,"%"+TCari.getText().trim()+"%"); ps.setString(5,"%"+TCari.getText().trim()+"%"); ps.setString(6,"%"+TCari.getText().trim()+"%"); ps.setString(7,"%"+TCari.getText().trim()+"%"); ps.setString(8,"%"+TCari.getText().trim()+"%"); ps.setString(9,"%"+TCari.getText().trim()+"%"); ps.setString(10,"%"+TCari.getText().trim()+"%"); ps.setString(11,"%"+TCari.getText().trim()+"%"); ps.setString(12,"%"+TCari.getText().trim()+"%"); ps.setString(13,"%"+TCari.getText().trim()+"%"); } rs=ps.executeQuery(); while(rs.next()){ tabMode.addRow(new Object[] {rs.getString(1), rs.getString(2), rs.getString(3), rs.getString(4), rs.getString(5), rs.getString(6), rs.getString(7), rs.getString(8), rs.getString(9), rs.getString(10), rs.getString(11), rs.getString(17), rs.getString(12), rs.getString(13), rs.getString(14), Valid.SetAngka(rs.getDouble(15)), rs.getString(16), rs.getString("no_tlp"), rs.getString("stts"),rs.getString("status_poli"), rs.getString("kd_poli"),rs.getString("kd_pj") }); } }catch(Exception e){ System.out.println("Notifikasi : "+e); }finally{ if(rs != null){ rs.close(); } if(ps != null){ ps.close(); } } } catch (Exception e) { System.out.println("Notifikasi : "+e); } LCount.setText(""+tabMode.getRowCount()); } public JTable getTable(){ return tbPetugas; } public JButton getButton(){ return BtnKeluar; } }