/* Dilarang keras menggandakan/mengcopy/menyebarkan/membajak/mendecompile Software ini dalam bentuk apapun tanpa seijin pembuat software (Khanza.Soft Media). Bagi yang sengaja membajak softaware ini ta npa ijin, kami sumpahi sial 1000 turunan, miskin sampai 500 turu nan. Selalu mendapat kecelakaan sampai 400 turunan. Anak pertama nya cacat tidak punya kaki sampai 300 turunan. Susah cari jodoh sampai umur 50 tahun sampai 200 turunan. Ya Alloh maafkan kami karena telah berdoa buruk, semua ini kami lakukan karena kami ti dak pernah rela karya kami dibajak tanpa ijin. */ package inventory; 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.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.KeyEvent; import java.sql.Connection; import java.util.Calendar; import java.util.Date; import javax.swing.JOptionPane; import javax.swing.JTable; import javax.swing.Timer; import javax.swing.table.DefaultTableModel; import javax.swing.table.TableColumn; import java.awt.event.KeyListener; import java.awt.event.WindowEvent; import java.awt.event.WindowListener; import java.io.FileInputStream; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.HashMap; import java.util.Map; import java.util.Properties; import javax.swing.event.DocumentEvent; import keuangan.Jurnal; import simrskhanza.DlgCariBangsal; import simrskhanza.DlgCariObatPenyakit; import simrskhanza.DlgCariPasien; /** * * @author perpustakaan */ public class DlgPemberianObat extends javax.swing.JDialog { private final DefaultTableModel tabModePO; private Connection koneksi=koneksiDB.condb(); private sekuel Sequel=new sekuel(); private validasi Valid=new validasi(); private riwayatobat Trackobat=new riwayatobat(); public DlgCariObat2 dlgobt=new DlgCariObat2(null,false); public DlgCariObat3 dlgobt2=new DlgCariObat3(null,false); private String bangsal="",lokasi="",tgl="",pas="",sql="",status=""; private PreparedStatement ps,psrekening; private ResultSet rs,rsrekening; private double ttljual,ttlhpp,jumlahtotal=0; private String aktifkanbatch="no",aktifkanparsial="no",kodedokter="",namadokter="",statusberi="", Suspen_Piutang_Obat_Ranap="",Obat_Ranap="",HPP_Obat_Rawat_Inap="",Persediaan_Obat_Rawat_Inap="", Suspen_Piutang_Obat_Ralan="",Obat_Ralan="",HPP_Obat_Rawat_Jalan="",Persediaan_Obat_Rawat_Jalan=""; private Jurnal jur=new Jurnal(); private final Properties prop = new Properties(); private int jmlparsial=0; private boolean sukses=true,hapusdata=true; /** Creates new form DlgPemberianObat * @param parent * @param modal */ public DlgPemberianObat(java.awt.Frame parent, boolean modal) { super(parent, modal); initComponents(); tabModePO=new DefaultTableModel(null,new Object[]{ "Tgl.Beri","Jam Beri","No.Rawat","No.R.M.","Nama Pasien","Kode Obat","Nama Obat/Alkes","Embalase", "Tuslah","Jml","Biaya Obat","Total","Harga Beli","Gudang","No.Batch","No.Faktur" }){ @Override public boolean isCellEditable(int rowIndex, int colIndex){return false;} 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.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, java.lang.Object.class,java.lang.Object.class }; @Override public Class getColumnClass(int columnIndex) { return types[columnIndex]; } }; tbPemberianObat.setModel(tabModePO); //tampilPO(""); tbPemberianObat.setPreferredScrollableViewportSize(new Dimension(500,500)); tbPemberianObat.setAutoResizeMode(JTable.AUTO_RESIZE_OFF); for (int i = 0; i < 16; i++) { TableColumn column = tbPemberianObat.getColumnModel().getColumn(i); if(i==0){ column.setPreferredWidth(65); }else if(i==1){ column.setPreferredWidth(55); }else if(i==2){ column.setPreferredWidth(105); }else if(i==3){ column.setPreferredWidth(80); }else if(i==4){ column.setPreferredWidth(170); }else if(i==5){ column.setPreferredWidth(100); }else if(i==6){ column.setPreferredWidth(190); }else if(i==7){ column.setPreferredWidth(60); }else if(i==8){ column.setPreferredWidth(60); }else if(i==9){ column.setPreferredWidth(35); }else if(i==10){ column.setPreferredWidth(75); }else if(i==11){ column.setPreferredWidth(85); }else if(i==12){ column.setMinWidth(0); column.setMaxWidth(0); }else if(i==13){ column.setPreferredWidth(50); }else if(i==14){ column.setPreferredWidth(70); }else if(i==15){ column.setPreferredWidth(100); } } tbPemberianObat.setDefaultRenderer(Object.class, new WarnaTable()); TNoRw.setDocument(new batasInput((byte)17).getKata(TNoRw)); TKdOb.setDocument(new batasInput((byte)15).getKata(TKdOb)); TCari.setDocument(new batasInput((byte)100).getKata(TCari)); TCariPasien.setDocument(new batasInput((byte)20).getKata(TCariPasien)); if(koneksiDB.CARICEPAT().equals("aktif")){ TCari.getDocument().addDocumentListener(new javax.swing.event.DocumentListener(){ @Override public void insertUpdate(DocumentEvent e) { if(TCari.getText().length()>2){ tampilPO(); } } @Override public void removeUpdate(DocumentEvent e) { if(TCari.getText().length()>2){ tampilPO(); } } @Override public void changedUpdate(DocumentEvent e) { if(TCari.getText().length()>2){ tampilPO(); } } }); } dlgobt2.addWindowListener(new WindowListener() { @Override public void windowOpened(WindowEvent e) {} @Override public void windowClosing(WindowEvent e) {} @Override public void windowClosed(WindowEvent e) { if(akses.getform().equals("DlgPemberianObat")){ tampilPO(); } } @Override public void windowIconified(WindowEvent e) {} @Override public void windowDeiconified(WindowEvent e) {} @Override public void windowActivated(WindowEvent e) {} @Override public void windowDeactivated(WindowEvent e) {} }); dlgobt.addWindowListener(new WindowListener() { @Override public void windowOpened(WindowEvent e) {} @Override public void windowClosing(WindowEvent e) {} @Override public void windowClosed(WindowEvent e) { if(akses.getform().equals("DlgPemberianObat")){ tampilPO(); } } @Override public void windowIconified(WindowEvent e) {} @Override public void windowDeiconified(WindowEvent e) {} @Override public void windowActivated(WindowEvent e) {} @Override public void windowDeactivated(WindowEvent e) {} }); jam(); try { psrekening=koneksi.prepareStatement( "select set_akun_ralan.Suspen_Piutang_Obat_Ralan,set_akun_ralan.Obat_Ralan,"+ "set_akun_ralan.HPP_Obat_Rawat_Jalan,set_akun_ralan.Persediaan_Obat_Rawat_Jalan from set_akun_ralan"); try { rsrekening=psrekening.executeQuery(); while(rsrekening.next()){ Suspen_Piutang_Obat_Ralan=rsrekening.getString("Suspen_Piutang_Obat_Ralan"); Obat_Ralan=rsrekening.getString("Obat_Ralan"); HPP_Obat_Rawat_Jalan=rsrekening.getString("HPP_Obat_Rawat_Jalan"); Persediaan_Obat_Rawat_Jalan=rsrekening.getString("Persediaan_Obat_Rawat_Jalan"); } } catch (Exception e) { System.out.println("Notif Rekening : "+e); } finally{ if(rsrekening!=null){ rsrekening.close(); } if(psrekening!=null){ psrekening.close(); } } psrekening=koneksi.prepareStatement( "select set_akun_ranap.Suspen_Piutang_Obat_Ranap,set_akun_ranap.Obat_Ranap,"+ "set_akun_ranap.HPP_Obat_Rawat_Inap,set_akun_ranap.Persediaan_Obat_Rawat_Inap from set_akun_ranap"); try { rsrekening=psrekening.executeQuery(); while(rsrekening.next()){ Suspen_Piutang_Obat_Ranap=rsrekening.getString("Suspen_Piutang_Obat_Ranap"); Obat_Ranap=rsrekening.getString("Obat_Ranap"); HPP_Obat_Rawat_Inap=rsrekening.getString("HPP_Obat_Rawat_Inap"); Persediaan_Obat_Rawat_Inap=rsrekening.getString("Persediaan_Obat_Rawat_Inap"); } } 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 { prop.loadFromXML(new FileInputStream("setting/database.xml")); aktifkanparsial=prop.getProperty("AKTIFKANBILLINGPARSIAL"); aktifkanbatch = prop.getProperty("AKTIFKANBATCHOBAT"); } catch (Exception ex) { aktifkanparsial="no"; aktifkanbatch = "no"; } } //private DlgCariObatPenyakit dlgobtpny=new DlgCariObatPenyakit(null,false); /** 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() { Popup2 = new javax.swing.JPopupMenu(); ppResepObat = new javax.swing.JMenuItem(); ppNoRawat = new javax.swing.JMenuItem(); ppLokasi = new javax.swing.JMenuItem(); THBeli = new widget.TextBox(); Tanggal = new widget.Tanggal(); internalFrame1 = new widget.InternalFrame(); Scroll = new widget.ScrollPane(); tbPemberianObat = new widget.Table(); jPanel3 = new javax.swing.JPanel(); panelGlass8 = new widget.panelisi(); BtnHapus = new widget.Button(); BtnPrint = new widget.Button(); BtnAll = new widget.Button(); jLabel10 = new widget.Label(); LCount = new widget.Label(); jLabel12 = new widget.Label(); LCount1 = new widget.Label(); BtnKeluar = new widget.Button(); panelGlass9 = new widget.panelisi(); jLabel14 = new widget.Label(); DTPCari1 = new widget.Tanggal(); jLabel19 = new widget.Label(); DTPCari2 = new widget.Tanggal(); jLabel16 = new widget.Label(); TCariPasien = new widget.TextBox(); BtnSeek4 = new widget.Button(); jSeparator5 = new javax.swing.JSeparator(); jLabel6 = new widget.Label(); TCari = new widget.TextBox(); BtnCari = new widget.Button(); PanelInput = new javax.swing.JPanel(); FormInput = new widget.PanelBiasa(); jLabel3 = new widget.Label(); TNoRw = new widget.TextBox(); TNoRM = new widget.TextBox(); TPasien = new widget.TextBox(); jLabel7 = new widget.Label(); DTPBeri = new widget.Tanggal(); jLabel13 = new widget.Label(); TKdOb = new widget.TextBox(); btnObat1 = new widget.Button(); TNmOb = new widget.TextBox(); jLabel11 = new widget.Label(); cmbJam = new widget.ComboBox(); cmbMnt = new widget.ComboBox(); cmbDtk = new widget.ComboBox(); TBiayaObat = new widget.TextBox(); jLabel17 = new widget.Label(); TSatuan = new widget.TextBox(); ChkJln = new widget.CekBox(); BtnObat2 = new widget.Button(); BtnObat3 = new widget.Button(); ChkInput = new widget.CekBox(); Popup2.setName("Popup2"); // NOI18N ppResepObat.setBackground(new java.awt.Color(255, 255, 254)); ppResepObat.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N ppResepObat.setForeground(new java.awt.Color(50, 50, 50)); ppResepObat.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/category.png"))); // NOI18N ppResepObat.setText("Buat Nomor Resep Obat"); ppResepObat.setHorizontalAlignment(javax.swing.SwingConstants.LEFT); ppResepObat.setHorizontalTextPosition(javax.swing.SwingConstants.RIGHT); ppResepObat.setName("ppResepObat"); // NOI18N ppResepObat.setPreferredSize(new java.awt.Dimension(200, 25)); ppResepObat.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { ppResepObatActionPerformed(evt); } }); Popup2.add(ppResepObat); ppNoRawat.setBackground(new java.awt.Color(255, 255, 254)); ppNoRawat.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N ppNoRawat.setForeground(new java.awt.Color(50, 50, 50)); ppNoRawat.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/category.png"))); // NOI18N ppNoRawat.setText("Rekap Per No.Rawat"); ppNoRawat.setHorizontalAlignment(javax.swing.SwingConstants.LEFT); ppNoRawat.setHorizontalTextPosition(javax.swing.SwingConstants.RIGHT); ppNoRawat.setName("ppNoRawat"); // NOI18N ppNoRawat.setPreferredSize(new java.awt.Dimension(200, 25)); ppNoRawat.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { ppNoRawatActionPerformed(evt); } }); Popup2.add(ppNoRawat); ppLokasi.setBackground(new java.awt.Color(255, 255, 254)); ppLokasi.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N ppLokasi.setForeground(new java.awt.Color(50, 50, 50)); ppLokasi.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/category.png"))); // NOI18N ppLokasi.setText("Tampilkan Per Asal Stok"); ppLokasi.setHorizontalAlignment(javax.swing.SwingConstants.LEFT); ppLokasi.setHorizontalTextPosition(javax.swing.SwingConstants.RIGHT); ppLokasi.setName("ppLokasi"); // NOI18N ppLokasi.setPreferredSize(new java.awt.Dimension(180, 25)); ppLokasi.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { ppLokasiBtnPrintActionPerformed(evt); } }); Popup2.add(ppLokasi); THBeli.setText("0"); THBeli.setHighlighter(null); THBeli.setName("THBeli"); // NOI18N Tanggal.setEditable(false); Tanggal.setForeground(new java.awt.Color(50, 70, 50)); Tanggal.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "20-12-2019" })); Tanggal.setDisplayFormat("dd-MM-yyyy"); Tanggal.setName("Tanggal"); // NOI18N Tanggal.setOpaque(false); Tanggal.setPreferredSize(new java.awt.Dimension(100, 23)); Tanggal.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { TanggalKeyPressed(evt); } }); setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE); setUndecorated(true); setResizable(false); internalFrame1.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(240, 245, 235)), "::[ Detail Pemberian Obat/Barang/Alkes/Perlengkapan ]::", 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(Popup2); Scroll.setName("Scroll"); // NOI18N Scroll.setOpaque(true); tbPemberianObat.setToolTipText("Silahkan klik untuk memilih data yang mau diedit ataupun dihapus"); tbPemberianObat.setComponentPopupMenu(Popup2); tbPemberianObat.setName("tbPemberianObat"); // NOI18N tbPemberianObat.addMouseListener(new java.awt.event.MouseAdapter() { public void mouseClicked(java.awt.event.MouseEvent evt) { tbPemberianObatMouseClicked(evt); } }); tbPemberianObat.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { tbPemberianObatKeyPressed(evt); } public void keyReleased(java.awt.event.KeyEvent evt) { tbPemberianObatKeyReleased(evt); } }); Scroll.setViewportView(tbPemberianObat); internalFrame1.add(Scroll, java.awt.BorderLayout.CENTER); jPanel3.setName("jPanel3"); // NOI18N jPanel3.setOpaque(false); jPanel3.setPreferredSize(new java.awt.Dimension(44, 100)); jPanel3.setLayout(new java.awt.BorderLayout(1, 1)); panelGlass8.setName("panelGlass8"); // NOI18N panelGlass8.setPreferredSize(new java.awt.Dimension(44, 44)); panelGlass8.setLayout(new java.awt.FlowLayout(java.awt.FlowLayout.LEFT, 5, 9)); BtnHapus.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/stop_f2.png"))); // NOI18N BtnHapus.setMnemonic('H'); BtnHapus.setText("Hapus"); BtnHapus.setToolTipText("Alt+H"); BtnHapus.setName("BtnHapus"); // NOI18N BtnHapus.setPreferredSize(new java.awt.Dimension(100, 30)); BtnHapus.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { BtnHapusActionPerformed(evt); } }); BtnHapus.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { BtnHapusKeyPressed(evt); } }); panelGlass8.add(BtnHapus); BtnPrint.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/b_print.png"))); // NOI18N BtnPrint.setMnemonic('T'); BtnPrint.setText("Cetak"); BtnPrint.setToolTipText("Alt+T"); BtnPrint.setName("BtnPrint"); // NOI18N BtnPrint.setPreferredSize(new java.awt.Dimension(100, 30)); BtnPrint.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { BtnPrintActionPerformed(evt); } }); BtnPrint.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { BtnPrintKeyPressed(evt); } }); panelGlass8.add(BtnPrint); BtnAll.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/Search-16x16.png"))); // NOI18N BtnAll.setMnemonic('M'); BtnAll.setText("Semua"); BtnAll.setToolTipText("Alt+M"); BtnAll.setName("BtnAll"); // NOI18N BtnAll.setPreferredSize(new java.awt.Dimension(100, 30)); 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); } }); panelGlass8.add(BtnAll); jLabel10.setText("Record :"); jLabel10.setName("jLabel10"); // NOI18N jLabel10.setPreferredSize(new java.awt.Dimension(65, 23)); panelGlass8.add(jLabel10); LCount.setHorizontalAlignment(javax.swing.SwingConstants.LEFT); LCount.setText("0"); LCount.setName("LCount"); // NOI18N LCount.setPreferredSize(new java.awt.Dimension(55, 23)); panelGlass8.add(LCount); jLabel12.setText("Jumlah Total :"); jLabel12.setName("jLabel12"); // NOI18N jLabel12.setPreferredSize(new java.awt.Dimension(75, 23)); panelGlass8.add(jLabel12); LCount1.setHorizontalAlignment(javax.swing.SwingConstants.LEFT); LCount1.setText("0"); LCount1.setName("LCount1"); // NOI18N LCount1.setPreferredSize(new java.awt.Dimension(200, 23)); panelGlass8.add(LCount1); BtnKeluar.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/exit.png"))); // NOI18N BtnKeluar.setMnemonic('K'); BtnKeluar.setText("Keluar"); BtnKeluar.setToolTipText("Alt+K"); BtnKeluar.setName("BtnKeluar"); // NOI18N BtnKeluar.setPreferredSize(new java.awt.Dimension(100, 30)); 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); } }); panelGlass8.add(BtnKeluar); jPanel3.add(panelGlass8, 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, 10)); jLabel14.setText("Tgl.Beri :"); jLabel14.setName("jLabel14"); // NOI18N jLabel14.setPreferredSize(new java.awt.Dimension(58, 23)); panelGlass9.add(jLabel14); DTPCari1.setForeground(new java.awt.Color(50, 70, 50)); DTPCari1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "20-12-2019" })); DTPCari1.setDisplayFormat("dd-MM-yyyy"); DTPCari1.setName("DTPCari1"); // NOI18N DTPCari1.setOpaque(false); DTPCari1.setPreferredSize(new java.awt.Dimension(100, 23)); panelGlass9.add(DTPCari1); jLabel19.setText("s.d"); jLabel19.setName("jLabel19"); // NOI18N jLabel19.setPreferredSize(new java.awt.Dimension(18, 23)); panelGlass9.add(jLabel19); DTPCari2.setForeground(new java.awt.Color(50, 70, 50)); DTPCari2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "20-12-2019" })); DTPCari2.setDisplayFormat("dd-MM-yyyy"); DTPCari2.setName("DTPCari2"); // NOI18N DTPCari2.setOpaque(false); DTPCari2.setPreferredSize(new java.awt.Dimension(100, 23)); panelGlass9.add(DTPCari2); jLabel16.setText("No.RM :"); jLabel16.setName("jLabel16"); // NOI18N jLabel16.setPreferredSize(new java.awt.Dimension(50, 23)); panelGlass9.add(jLabel16); TCariPasien.setName("TCariPasien"); // NOI18N TCariPasien.setPreferredSize(new java.awt.Dimension(130, 23)); TCariPasien.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { TCariPasienKeyPressed(evt); } }); panelGlass9.add(TCariPasien); BtnSeek4.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/190.png"))); // NOI18N BtnSeek4.setMnemonic('5'); BtnSeek4.setToolTipText("Alt+5"); BtnSeek4.setName("BtnSeek4"); // NOI18N BtnSeek4.setPreferredSize(new java.awt.Dimension(28, 23)); BtnSeek4.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { BtnSeek4ActionPerformed(evt); } }); BtnSeek4.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { BtnSeek4KeyPressed(evt); } }); panelGlass9.add(BtnSeek4); jSeparator5.setBackground(new java.awt.Color(220, 225, 215)); jSeparator5.setForeground(new java.awt.Color(220, 225, 215)); jSeparator5.setOrientation(javax.swing.SwingConstants.VERTICAL); jSeparator5.setName("jSeparator5"); // NOI18N jSeparator5.setOpaque(true); jSeparator5.setPreferredSize(new java.awt.Dimension(1, 23)); panelGlass9.add(jSeparator5); 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(190, 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('6'); BtnCari.setToolTipText("Alt+6"); 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); jPanel3.add(panelGlass9, java.awt.BorderLayout.PAGE_START); internalFrame1.add(jPanel3, java.awt.BorderLayout.PAGE_END); PanelInput.setName("PanelInput"); // NOI18N PanelInput.setOpaque(false); PanelInput.setPreferredSize(new java.awt.Dimension(865, 128)); PanelInput.setLayout(new java.awt.BorderLayout(1, 1)); FormInput.setName("FormInput"); // NOI18N FormInput.setPreferredSize(new java.awt.Dimension(865, 137)); FormInput.setLayout(null); jLabel3.setText("No.Rawat :"); jLabel3.setName("jLabel3"); // NOI18N FormInput.add(jLabel3); jLabel3.setBounds(-2, 12, 80, 23); TNoRw.setHighlighter(null); TNoRw.setName("TNoRw"); // NOI18N TNoRw.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { TNoRwKeyPressed(evt); } }); FormInput.add(TNoRw); TNoRw.setBounds(81, 12, 175, 23); TNoRM.setEditable(false); TNoRM.setHighlighter(null); TNoRM.setName("TNoRM"); // NOI18N FormInput.add(TNoRM); TNoRM.setBounds(258, 12, 143, 23); TPasien.setEditable(false); TPasien.setHighlighter(null); TPasien.setName("TPasien"); // NOI18N TPasien.setPreferredSize(new java.awt.Dimension(25, 28)); FormInput.add(TPasien); TPasien.setBounds(403, 12, 425, 23); jLabel7.setText("Tgl.Beri :"); jLabel7.setName("jLabel7"); // NOI18N FormInput.add(jLabel7); jLabel7.setBounds(-2, 42, 80, 23); DTPBeri.setForeground(new java.awt.Color(50, 70, 50)); DTPBeri.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "20-12-2019" })); DTPBeri.setDisplayFormat("dd-MM-yyyy"); DTPBeri.setName("DTPBeri"); // NOI18N DTPBeri.setOpaque(false); DTPBeri.setPreferredSize(new java.awt.Dimension(100, 23)); DTPBeri.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { DTPBeriKeyPressed(evt); } }); FormInput.add(DTPBeri); DTPBeri.setBounds(81, 42, 100, 23); jLabel13.setText("Obt/Alkes :"); jLabel13.setName("jLabel13"); // NOI18N FormInput.add(jLabel13); jLabel13.setBounds(-2, 72, 80, 23); TKdOb.setName("TKdOb"); // NOI18N TKdOb.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { TKdObKeyPressed(evt); } }); FormInput.add(TKdOb); TKdOb.setBounds(81, 72, 90, 23); btnObat1.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/190.png"))); // NOI18N btnObat1.setMnemonic('4'); btnObat1.setToolTipText("Alt+4"); btnObat1.setName("btnObat1"); // NOI18N btnObat1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { btnObat1ActionPerformed(evt); } }); FormInput.add(btnObat1); btnObat1.setBounds(545, 72, 28, 23); TNmOb.setEditable(false); TNmOb.setName("TNmOb"); // NOI18N FormInput.add(TNmOb); TNmOb.setBounds(173, 72, 288, 23); jLabel11.setText("Jam :"); jLabel11.setName("jLabel11"); // NOI18N FormInput.add(jLabel11); jLabel11.setBounds(215, 42, 40, 23); cmbJam.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "00", "01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23" })); cmbJam.setName("cmbJam"); // NOI18N cmbJam.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { cmbJamKeyPressed(evt); } }); FormInput.add(cmbJam); cmbJam.setBounds(258, 42, 62, 23); cmbMnt.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "00", "01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", "24", "25", "26", "27", "28", "29", "30", "31", "32", "33", "34", "35", "36", "37", "38", "39", "40", "41", "42", "43", "44", "45", "46", "47", "48", "49", "50", "51", "52", "53", "54", "55", "56", "57", "58", "59" })); cmbMnt.setName("cmbMnt"); // NOI18N cmbMnt.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { cmbMntKeyPressed(evt); } }); FormInput.add(cmbMnt); cmbMnt.setBounds(323, 42, 62, 23); cmbDtk.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "00", "01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", "24", "25", "26", "27", "28", "29", "30", "31", "32", "33", "34", "35", "36", "37", "38", "39", "40", "41", "42", "43", "44", "45", "46", "47", "48", "49", "50", "51", "52", "53", "54", "55", "56", "57", "58", "59" })); cmbDtk.setName("cmbDtk"); // NOI18N cmbDtk.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { cmbDtkKeyPressed(evt); } }); FormInput.add(cmbDtk); cmbDtk.setBounds(388, 42, 62, 23); TBiayaObat.setText("0"); TBiayaObat.setHighlighter(null); TBiayaObat.setName("TBiayaObat"); // NOI18N FormInput.add(TBiayaObat); TBiayaObat.setBounds(710, 72, 118, 23); jLabel17.setText("Harga : Rp."); jLabel17.setName("jLabel17"); // NOI18N FormInput.add(jLabel17); jLabel17.setBounds(637, 72, 70, 23); TSatuan.setEditable(false); TSatuan.setName("TSatuan"); // NOI18N FormInput.add(TSatuan); TSatuan.setBounds(463, 72, 80, 23); ChkJln.setBorder(null); ChkJln.setSelected(true); ChkJln.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N ChkJln.setHorizontalAlignment(javax.swing.SwingConstants.CENTER); ChkJln.setHorizontalTextPosition(javax.swing.SwingConstants.CENTER); ChkJln.setName("ChkJln"); // NOI18N FormInput.add(ChkJln); ChkJln.setBounds(453, 42, 23, 23); BtnObat2.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/190.png"))); // NOI18N BtnObat2.setMnemonic('4'); BtnObat2.setToolTipText("Alt+4"); BtnObat2.setName("BtnObat2"); // NOI18N BtnObat2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { BtnObat2ActionPerformed(evt); } }); FormInput.add(BtnObat2); BtnObat2.setBounds(575, 72, 28, 23); BtnObat3.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/190.png"))); // NOI18N BtnObat3.setMnemonic('4'); BtnObat3.setToolTipText("Alt+4"); BtnObat3.setName("BtnObat3"); // NOI18N BtnObat3.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { BtnObat3ActionPerformed(evt); } }); FormInput.add(BtnObat3); BtnObat3.setBounds(604, 72, 28, 23); PanelInput.add(FormInput, java.awt.BorderLayout.CENTER); ChkInput.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/143.png"))); // NOI18N ChkInput.setMnemonic('I'); ChkInput.setText(".: Input Data"); ChkInput.setToolTipText("Alt+I"); ChkInput.setBorderPainted(true); ChkInput.setBorderPaintedFlat(true); ChkInput.setFocusable(false); ChkInput.setHorizontalAlignment(javax.swing.SwingConstants.LEFT); ChkInput.setHorizontalTextPosition(javax.swing.SwingConstants.RIGHT); ChkInput.setName("ChkInput"); // NOI18N ChkInput.setPreferredSize(new java.awt.Dimension(192, 20)); ChkInput.setRolloverIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/143.png"))); // NOI18N ChkInput.setRolloverSelectedIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/145.png"))); // NOI18N ChkInput.setSelectedIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/145.png"))); // NOI18N ChkInput.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { ChkInputActionPerformed(evt); } }); PanelInput.add(ChkInput, java.awt.BorderLayout.PAGE_END); internalFrame1.add(PanelInput, 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_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 tampilPO(); }//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 TNoRwKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_TNoRwKeyPressed if(evt.getKeyCode()==KeyEvent.VK_PAGE_DOWN){ isRawat(); isPsien(); }else{ Valid.pindah(evt,TCari,DTPBeri); } }//GEN-LAST:event_TNoRwKeyPressed private void DTPBeriKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_DTPBeriKeyPressed Valid.pindah(evt,TNoRw,cmbJam); }//GEN-LAST:event_DTPBeriKeyPressed private void TKdObKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_TKdObKeyPressed if(evt.getKeyCode()==KeyEvent.VK_UP){ btnObat1ActionPerformed(null); }else{ Valid.pindah(evt,cmbDtk,TCari); } }//GEN-LAST:event_TKdObKeyPressed private void btnObat1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnObat1ActionPerformed if(TNoRw.getText().trim().equals("")||TPasien.getText().trim().equals("")){ Valid.textKosong(TNoRw,"No.Rawat"); }else { akses.setform("DlgPemberianObat"); jmlparsial=0; if(aktifkanparsial.equals("yes")){ jmlparsial=Sequel.cariInteger("select count(set_input_parsial.kd_pj) from set_input_parsial where set_input_parsial.kd_pj=?",Sequel.cariIsi("select reg_periksa.kd_pj from reg_periksa where reg_periksa.no_rawat=?",TNoRw.getText())); } if(jmlparsial>0){ panggilform(); }else{ if(Sequel.cariRegistrasi(TNoRw.getText())>0){ JOptionPane.showMessageDialog(rootPane,"Data billing sudah terverifikasi, data tidak boleh dihapus.\nSilahkan hubungi bagian kasir/keuangan ..!!"); TCari.requestFocus(); }else{ panggilform(); } } } }//GEN-LAST:event_btnObat1ActionPerformed private void BtnHapusActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnHapusActionPerformed if(tbPemberianObat.getSelectedRow()!= -1){ bangsal=tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),13).toString(); } if(tabModePO.getRowCount()==0){ JOptionPane.showMessageDialog(null,"Maaf, data sudah habis...!!!!"); TNoRw.requestFocus(); }else if(TPasien.getText().trim().equals("")){ JOptionPane.showMessageDialog(null,"Maaf, Gagal menghapus. Pilih dulu data yang mau dihapus.\nKlik data pada table untuk memilih...!!!!"); }else if(ChkJln.isSelected()==true){ JOptionPane.showMessageDialog(rootPane,"Matikan dulu jam otomatis sebelum menghapus data..!!"); ChkJln.requestFocus(); }else if(!(TPasien.getText().trim().equals(""))){ try{ if(tbPemberianObat.getSelectedRow()!= -1){ jmlparsial=0; if(aktifkanparsial.equals("yes")){ jmlparsial=Sequel.cariInteger("select count(set_input_parsial.kd_pj) from set_input_parsial where set_input_parsial.kd_pj=?",Sequel.cariIsi("select reg_periksa.kd_pj from reg_periksa where reg_periksa.no_rawat=?",TNoRw.getText())); } Sequel.AutoComitFalse(); sukses=true; hapusdata=true; if(jmlparsial>0){ if(akses.getkode().equals("Admin Utama")){ hapus(); }else{ if(Sequel.cekTanggal48jam(tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),0).toString()+" "+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),1).toString(),Sequel.ambiltanggalsekarang())==true){ hapus(); }else{ hapusdata=false; } } }else{ if(Sequel.cariRegistrasi(TNoRw.getText())>0){ JOptionPane.showMessageDialog(rootPane,"Data billing sudah terverifikasi, data tidak boleh dihapus.\nSilahkan hubungi bagian kasir/keuangan ..!!"); TCari.requestFocus(); }else{ if(akses.getkode().equals("Admin Utama")){ hapus(); }else{ if(Sequel.cekTanggal48jam(tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),0).toString()+" "+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),1).toString(),Sequel.ambiltanggalsekarang())==true){ hapus(); }else{ hapusdata=false; } } } } if(sukses==true){ Sequel.Commit(); }else{ sukses=false; hapusdata=false; JOptionPane.showMessageDialog(null,"Terjadi kesalahan saat pemrosesan data, transaksi dibatalkan.\nPeriksa kembali data sebelum melanjutkan menyimpan..!!"); Sequel.RollBack(); } Sequel.AutoComitTrue(); if(hapusdata==true){ tabModePO.removeRow(tbPemberianObat.getSelectedRow()); LCount.setText(""+tabModePO.getRowCount()); LCount1.setText(""+Valid.SetAngka(jumlahtotal-ttljual)); } } }catch(Exception e){ System.out.println("Notifikasi : "+e); JOptionPane.showMessageDialog(null,"Maaf, Silahkan anda pilih terlebih dulu data yang mau anda hapus...\n Klik data pada table untuk memilih data...!!!!"); } } }//GEN-LAST:event_BtnHapusActionPerformed private void BtnHapusKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnHapusKeyPressed if(evt.getKeyCode()==KeyEvent.VK_SPACE){ BtnHapusActionPerformed(null); }else{ Valid.pindah(evt, TCari, BtnPrint); } }//GEN-LAST:event_BtnHapusKeyPressed private void BtnPrintActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnPrintActionPerformed this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR)); if(tabModePO.getRowCount()==0){ JOptionPane.showMessageDialog(null,"Maaf, data sudah habis. Tidak ada data yang bisa anda print...!!!!"); TCari.requestFocus(); }else if(tabModePO.getRowCount()!=0){ Map param = new HashMap<>(); param.put("namars",akses.getnamars()); param.put("alamatrs",akses.getalamatrs()); param.put("kotars",akses.getkabupatenrs()); param.put("propinsirs",akses.getpropinsirs()); param.put("kontakrs",akses.getkontakrs()); param.put("emailrs",akses.getemailrs()); param.put("logo",Sequel.cariGambar("select setting.logo from setting")); if(!TCariPasien.getText().equals("")){ pas=" and reg_periksa.no_rkm_medis='"+TCariPasien.getText()+"' "; } tgl=" detail_pemberian_obat.tgl_perawatan between '"+Valid.SetTgl(DTPCari1.getSelectedItem()+"")+"' and '"+Valid.SetTgl(DTPCari2.getSelectedItem()+"")+"' "+pas; Valid.MyReportqry("rptBrObt.jasper","report","::[ Rekam Data Pemberian Obat (UMUM) ]::", "select detail_pemberian_obat.tgl_perawatan,detail_pemberian_obat.jam,"+ "detail_pemberian_obat.no_rawat,reg_periksa.no_rkm_medis,pasien.nm_pasien,"+ "detail_pemberian_obat.kode_brng,databarang.nama_brng,detail_pemberian_obat.embalase,detail_pemberian_obat.tuslah,"+ "detail_pemberian_obat.jml,detail_pemberian_obat.biaya_obat,detail_pemberian_obat.total,detail_pemberian_obat.h_beli,"+ "detail_pemberian_obat.kd_bangsal,detail_pemberian_obat.no_batch,detail_pemberian_obat.no_faktur "+ "from detail_pemberian_obat inner join reg_periksa on detail_pemberian_obat.no_rawat=reg_periksa.no_rawat "+ "inner join pasien on reg_periksa.no_rkm_medis=pasien.no_rkm_medis "+ "inner join databarang on detail_pemberian_obat.kode_brng=databarang.kode_brng "+ "where "+tgl+(TCari.getText().trim().equals("")?"":" and (tgl_perawatan like '%"+TCari.getText().trim()+"%' or "+ "detail_pemberian_obat.no_rawat like '%"+TCari.getText().trim()+"%' or reg_periksa.no_rkm_medis like '%"+TCari.getText().trim()+"%' or "+ "pasien.nm_pasien like '%"+TCari.getText().trim()+"%' or detail_pemberian_obat.kode_brng like '%"+TCari.getText().trim()+"%' or "+ "databarang.nama_brng like '%"+TCari.getText().trim()+"%' or detail_pemberian_obat.no_faktur like '%"+TCari.getText().trim()+"%' or "+ "detail_pemberian_obat.no_batch like '%"+TCari.getText().trim()+"%') ")+" order by detail_pemberian_obat.tgl_perawatan",param); } this.setCursor(Cursor.getDefaultCursor()); }//GEN-LAST:event_BtnPrintActionPerformed private void BtnPrintKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnPrintKeyPressed if(evt.getKeyCode()==KeyEvent.VK_SPACE){ BtnPrintActionPerformed(null); }else{ Valid.pindah(evt, BtnHapus, BtnAll); } }//GEN-LAST:event_BtnPrintKeyPressed private void BtnKeluarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnKeluarActionPerformed dispose(); }//GEN-LAST:event_BtnKeluarActionPerformed private void BtnKeluarKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnKeluarKeyPressed if(evt.getKeyCode()==KeyEvent.VK_SPACE){ dispose(); }else{Valid.pindah(evt,BtnPrint,TCari);} }//GEN-LAST:event_BtnKeluarKeyPressed private void BtnAllActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnAllActionPerformed TCari.setText(""); TCariPasien.setText(""); tampilPO(); }//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, BtnPrint, BtnKeluar); } }//GEN-LAST:event_BtnAllKeyPressed private void TCariPasienKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_TCariPasienKeyPressed if(evt.getKeyCode()==KeyEvent.VK_ENTER){ tampilPO(); }else if(evt.getKeyCode()==KeyEvent.VK_PAGE_DOWN){ BtnSeek4.requestFocus(); }else if(evt.getKeyCode()==KeyEvent.VK_PAGE_UP){ DTPCari2.requestFocus(); } }//GEN-LAST:event_TCariPasienKeyPressed private void BtnSeek4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnSeek4ActionPerformed akses.setform("DlgPemberianObat"); DlgCariPasien pasien=new DlgCariPasien(null,false); pasien.addWindowListener(new WindowListener() { @Override public void windowOpened(WindowEvent e) {} @Override public void windowClosing(WindowEvent e) {} @Override public void windowClosed(WindowEvent e) { if(akses.getform().equals("DlgPemberianObat")){ if(pasien.getTable().getSelectedRow()!= -1){ TCariPasien.setText(pasien.getTable().getValueAt(pasien.getTable().getSelectedRow(),0).toString()); } TCariPasien.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) {} }); pasien.getTable().addKeyListener(new KeyListener() { @Override public void keyTyped(KeyEvent e) {} @Override public void keyPressed(KeyEvent e) { if(akses.getform().equals("DlgPemberianObat")){ if(e.getKeyCode()==KeyEvent.VK_SPACE){ pasien.dispose(); } } } @Override public void keyReleased(KeyEvent e) {} }); pasien.emptTeks(); pasien.isCek(); pasien.setSize(internalFrame1.getWidth()-20,internalFrame1.getHeight()-20); pasien.setLocationRelativeTo(internalFrame1); pasien.setVisible(true); }//GEN-LAST:event_BtnSeek4ActionPerformed private void BtnSeek4KeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnSeek4KeyPressed Valid.pindah(evt,TCariPasien,DTPCari1); }//GEN-LAST:event_BtnSeek4KeyPressed private void cmbJamKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_cmbJamKeyPressed Valid.pindah(evt,DTPBeri,cmbMnt); }//GEN-LAST:event_cmbJamKeyPressed private void cmbMntKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_cmbMntKeyPressed Valid.pindah(evt,cmbJam,cmbDtk); }//GEN-LAST:event_cmbMntKeyPressed private void cmbDtkKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_cmbDtkKeyPressed Valid.pindah(evt,cmbMnt,TKdOb); }//GEN-LAST:event_cmbDtkKeyPressed private void tbPemberianObatMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_tbPemberianObatMouseClicked if(tabModePO.getRowCount()!=0){ try { getData(); } catch (java.lang.NullPointerException e) { } } }//GEN-LAST:event_tbPemberianObatMouseClicked private void tbPemberianObatKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_tbPemberianObatKeyPressed if(tabModePO.getRowCount()!=0){ if(evt.getKeyCode()==KeyEvent.VK_SHIFT){ TCari.setText(""); TCari.requestFocus(); } } }//GEN-LAST:event_tbPemberianObatKeyPressed private void ChkInputActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_ChkInputActionPerformed isForm(); }//GEN-LAST:event_ChkInputActionPerformed private void BtnObat2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnObat2ActionPerformed if(TNoRw.getText().trim().equals("")||TPasien.getText().trim().equals("")){ Valid.textKosong(TNoRw,"No.Rawat"); }else { if(Sequel.cariRegistrasi(TNoRw.getText())>0){ JOptionPane.showMessageDialog(rootPane,"Data billing sudah terverifikasi, data tidak boleh dihapus.\nSilahkan hubungi bagian kasir/keuangan ..!!"); TCari.requestFocus(); }else{ akses.setform("DlgPemberianObat"); dlgobt2.setNoRm(TNoRw.getText(),TNoRM.getText(),TPasien.getText(),DTPBeri.getDate()); dlgobt2.setSize(internalFrame1.getWidth()-20,internalFrame1.getHeight()-20); dlgobt2.setLocationRelativeTo(internalFrame1); dlgobt2.setVisible(true); } } }//GEN-LAST:event_BtnObat2ActionPerformed private void BtnObat3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnObat3ActionPerformed if(TNoRw.getText().trim().equals("")||TPasien.getText().trim().equals("")){ Valid.textKosong(TNoRw,"No.Rawat"); }else { if(Sequel.cariRegistrasi(TNoRw.getText())>0){ JOptionPane.showMessageDialog(rootPane,"Data billing sudah terverifikasi, data tidak boleh dihapus.\nSilahkan hubungi bagian kasir/keuangan ..!!"); TCari.requestFocus(); }else{ if(status.equals("ralan")){ akses.setform("DlgPemberianObat"); DlgCariObatPenyakit dlgobtpny=new DlgCariObatPenyakit(null,false); dlgobtpny.setNoRm(TNoRw.getText(),Sequel.cariIsi("select diagnosa_pasien.kd_penyakit from diagnosa_pasien where diagnosa_pasien.no_rawat=? order by diagnosa_pasien.prioritas limit 1",TNoRw.getText())); dlgobtpny.setSize(internalFrame1.getWidth()-20,internalFrame1.getHeight()-20); dlgobtpny.setLocationRelativeTo(internalFrame1); dlgobtpny.setVisible(true); } } } }//GEN-LAST:event_BtnObat3ActionPerformed private void ppResepObatActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_ppResepObatActionPerformed if(tabModePO.getRowCount()==0){ JOptionPane.showMessageDialog(null,"Maaf, data sudah habis...!!!!"); TNoRw.requestFocus(); }else if(TPasien.getText().trim().equals("")){ JOptionPane.showMessageDialog(null,"Maaf, pilih dulu data yang mau dibuatkan Nomor Resep..!!\nKlik data pada table untuk memilih...!!!!"); }else if(!(TPasien.getText().trim().equals(""))){ DlgResepObat resep=new DlgResepObat(null,false); resep.setSize(internalFrame1.getWidth(),internalFrame1.getHeight()); resep.setLocationRelativeTo(internalFrame1); resep.emptTeks(); resep.isCek(); resep.setNoRm(TNoRw.getText(),Valid.SetTgl2(tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),0).toString()),Valid.SetTgl2(tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),0).toString()),tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),1).toString().substring(0,2),tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),1).toString().substring(3,5),tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),1).toString().substring(6,8),status); resep.tampil(); resep.setVisible(true); } }//GEN-LAST:event_ppResepObatActionPerformed private void ppNoRawatActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_ppNoRawatActionPerformed this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR)); tampilPO(); if(tabModePO.getRowCount()==0){ JOptionPane.showMessageDialog(null,"Maaf, data sudah habis. Tidak ada data yang bisa anda print...!!!!"); TCari.requestFocus(); }else if(tabModePO.getRowCount()!=0){ Map param = new HashMap<>(); param.put("namars",akses.getnamars()); param.put("alamatrs",akses.getalamatrs()); param.put("kotars",akses.getkabupatenrs()); param.put("propinsirs",akses.getpropinsirs()); param.put("kontakrs",akses.getkontakrs()); param.put("emailrs",akses.getemailrs()); param.put("logo",Sequel.cariGambar("select setting.logo from setting")); if(!TCariPasien.getText().equals("")){ pas=" and reg_periksa.no_rkm_medis='"+TCariPasien.getText()+"' "; } tgl=" detail_pemberian_obat.tgl_perawatan between '"+Valid.SetTgl(DTPCari1.getSelectedItem()+"")+"' and '"+Valid.SetTgl(DTPCari2.getSelectedItem()+"")+"' "+pas; Valid.MyReportqry("rptBrObt2.jasper","report","::[ Rekam Data Pemberian Obat (UMUM) ]::","select detail_pemberian_obat.tgl_perawatan,detail_pemberian_obat.jam,"+ "detail_pemberian_obat.no_rawat,reg_periksa.no_rkm_medis,pasien.nm_pasien,"+ "detail_pemberian_obat.kode_brng,databarang.nama_brng,detail_pemberian_obat.embalase,detail_pemberian_obat.tuslah,"+ "detail_pemberian_obat.jml,detail_pemberian_obat.biaya_obat,detail_pemberian_obat.total "+ "from detail_pemberian_obat inner join reg_periksa inner join pasien inner join databarang "+ "on detail_pemberian_obat.no_rawat=reg_periksa.no_rawat "+ "and reg_periksa.no_rkm_medis=pasien.no_rkm_medis "+ "and detail_pemberian_obat.kode_brng=databarang.kode_brng "+ "where "+tgl+"and tgl_perawatan like '%"+TCari.getText().trim()+"%' or "+ tgl+"and detail_pemberian_obat.no_rawat like '%"+TCari.getText().trim()+"%' or "+ tgl+"and reg_periksa.no_rkm_medis like '%"+TCari.getText().trim()+"%' or "+ tgl+"and pasien.nm_pasien like '%"+TCari.getText().trim()+"%' or "+ tgl+"and detail_pemberian_obat.kode_brng like '%"+TCari.getText().trim()+"%' or "+ tgl+"and databarang.nama_brng like '%"+TCari.getText().trim()+"%' "+ "order by detail_pemberian_obat.tgl_perawatan",param); } this.setCursor(Cursor.getDefaultCursor()); }//GEN-LAST:event_ppNoRawatActionPerformed private void ppLokasiBtnPrintActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_ppLokasiBtnPrintActionPerformed DlgCariBangsal depo = new DlgCariBangsal(null, false); depo.addWindowListener(new WindowListener() { @Override public void windowOpened(WindowEvent e) {} @Override public void windowClosing(WindowEvent e) {} @Override public void windowClosed(WindowEvent e) { if (depo.getTable().getSelectedRow() != -1) { lokasi=depo.getTable().getValueAt(depo.getTable().getSelectedRow(),0).toString(); tampilPO2(); } } @Override public void windowIconified(WindowEvent e) {} @Override public void windowDeiconified(WindowEvent e) {} @Override public void windowActivated(WindowEvent e) { depo.emptTeks(); } @Override public void windowDeactivated(WindowEvent e) {} }); depo.isCek(); depo.setSize(internalFrame1.getWidth() - 40, internalFrame1.getHeight() - 40); depo.setLocationRelativeTo(internalFrame1); depo.setVisible(true); }//GEN-LAST:event_ppLokasiBtnPrintActionPerformed private void tbPemberianObatKeyReleased(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_tbPemberianObatKeyReleased if(tabModePO.getRowCount()!=0){ if((evt.getKeyCode()==KeyEvent.VK_ENTER)||(evt.getKeyCode()==KeyEvent.VK_UP)||(evt.getKeyCode()==KeyEvent.VK_DOWN)){ try { getData(); } catch (java.lang.NullPointerException e) { } } } }//GEN-LAST:event_tbPemberianObatKeyReleased private void TanggalKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_TanggalKeyPressed // TODO add your handling code here: }//GEN-LAST:event_TanggalKeyPressed /** * @param args the command line arguments */ public static void main(String args[]) { java.awt.EventQueue.invokeLater(() -> { DlgPemberianObat dialog = new DlgPemberianObat(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 BtnHapus; private widget.Button BtnKeluar; private widget.Button BtnObat2; private widget.Button BtnObat3; private widget.Button BtnPrint; private widget.Button BtnSeek4; private widget.CekBox ChkInput; private widget.CekBox ChkJln; private widget.Tanggal DTPBeri; private widget.Tanggal DTPCari1; private widget.Tanggal DTPCari2; private widget.PanelBiasa FormInput; private widget.Label LCount; private widget.Label LCount1; private javax.swing.JPanel PanelInput; private javax.swing.JPopupMenu Popup2; private widget.ScrollPane Scroll; private widget.TextBox TBiayaObat; private widget.TextBox TCari; private widget.TextBox TCariPasien; private widget.TextBox THBeli; private widget.TextBox TKdOb; private widget.TextBox TNmOb; private widget.TextBox TNoRM; private widget.TextBox TNoRw; private widget.TextBox TPasien; private widget.TextBox TSatuan; private widget.Tanggal Tanggal; private widget.Button btnObat1; private widget.ComboBox cmbDtk; private widget.ComboBox cmbJam; private widget.ComboBox cmbMnt; private widget.InternalFrame internalFrame1; private widget.Label jLabel10; private widget.Label jLabel11; private widget.Label jLabel12; private widget.Label jLabel13; private widget.Label jLabel14; private widget.Label jLabel16; private widget.Label jLabel17; private widget.Label jLabel19; private widget.Label jLabel3; private widget.Label jLabel6; private widget.Label jLabel7; private javax.swing.JPanel jPanel3; private javax.swing.JSeparator jSeparator5; private widget.panelisi panelGlass8; private widget.panelisi panelGlass9; private javax.swing.JMenuItem ppLokasi; private javax.swing.JMenuItem ppNoRawat; private javax.swing.JMenuItem ppResepObat; private widget.Table tbPemberianObat; // End of variables declaration//GEN-END:variables public void tampilPO() { pas=""; if(!TCariPasien.getText().equals("")){ pas=" and reg_periksa.no_rkm_medis='"+TCariPasien.getText()+"' "; } tgl=" detail_pemberian_obat.tgl_perawatan between '"+Valid.SetTgl(DTPCari1.getSelectedItem()+"")+"' and '"+Valid.SetTgl(DTPCari2.getSelectedItem()+"")+"' "+pas; sql="select detail_pemberian_obat.tgl_perawatan,detail_pemberian_obat.jam,"+ "detail_pemberian_obat.no_rawat,reg_periksa.no_rkm_medis,pasien.nm_pasien,"+ "detail_pemberian_obat.kode_brng,databarang.nama_brng,detail_pemberian_obat.embalase,detail_pemberian_obat.tuslah,"+ "detail_pemberian_obat.jml,detail_pemberian_obat.biaya_obat,detail_pemberian_obat.total,detail_pemberian_obat.h_beli,"+ "detail_pemberian_obat.kd_bangsal,detail_pemberian_obat.no_batch,detail_pemberian_obat.no_faktur "+ "from detail_pemberian_obat inner join reg_periksa on detail_pemberian_obat.no_rawat=reg_periksa.no_rawat "+ "inner join pasien on reg_periksa.no_rkm_medis=pasien.no_rkm_medis "+ "inner join databarang on detail_pemberian_obat.kode_brng=databarang.kode_brng "+ "where "+tgl+(TCari.getText().trim().equals("")?"":" and (tgl_perawatan like ? or "+ "detail_pemberian_obat.no_rawat like ? or reg_periksa.no_rkm_medis like ? or "+ "pasien.nm_pasien like ? or detail_pemberian_obat.kode_brng like ? or databarang.nama_brng like ? or "+ "detail_pemberian_obat.no_faktur like ? or detail_pemberian_obat.no_batch like ?) ")+ "order by detail_pemberian_obat.tgl_perawatan"; Valid.tabelKosong(tabModePO); try{ ps=koneksi.prepareStatement(sql); try { if(!TCari.getText().trim().equals("")){ ps.setString(1,"%"+TCari.getText().trim()+"%"); ps.setString(2,"%"+TCari.getText().trim()+"%"); 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()+"%"); } rs=ps.executeQuery(); jumlahtotal=0; while(rs.next()){ jumlahtotal=jumlahtotal+rs.getDouble("total"); tabModePO.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.getDouble(8),rs.getDouble(9), rs.getDouble(10),rs.getDouble(11),rs.getDouble(12), rs.getDouble(13),rs.getString(14),rs.getString(15), rs.getString(16) }); } } catch (Exception e) { System.out.println("Notif : "+e); } finally{ if(rs!=null){ rs.close(); } if(ps!=null){ ps.close(); } } }catch(Exception e){ System.out.println("Notifikasi : "+e); } LCount.setText(""+tabModePO.getRowCount()); LCount1.setText(""+Valid.SetAngka(jumlahtotal)); } public void tampilPO2() { pas=""; if(!TCariPasien.getText().equals("")){ pas=" and reg_periksa.no_rkm_medis='"+TCariPasien.getText()+"' "; } tgl=" detail_pemberian_obat.tgl_perawatan between '"+Valid.SetTgl(DTPCari1.getSelectedItem()+"")+"' and '"+Valid.SetTgl(DTPCari2.getSelectedItem()+"")+"' and detail_pemberian_obat.kd_bangsal='"+lokasi+"' "+pas; sql="select detail_pemberian_obat.tgl_perawatan,detail_pemberian_obat.jam,"+ "detail_pemberian_obat.no_rawat,reg_periksa.no_rkm_medis,pasien.nm_pasien,"+ "detail_pemberian_obat.kode_brng,databarang.nama_brng,detail_pemberian_obat.embalase,detail_pemberian_obat.tuslah,"+ "detail_pemberian_obat.jml,detail_pemberian_obat.biaya_obat,detail_pemberian_obat.total,detail_pemberian_obat.h_beli,"+ "detail_pemberian_obat.kd_bangsal,detail_pemberian_obat.no_batch,detail_pemberian_obat.no_faktur "+ "from detail_pemberian_obat inner join reg_periksa on detail_pemberian_obat.no_rawat=reg_periksa.no_rawat "+ "inner join pasien on reg_periksa.no_rkm_medis=pasien.no_rkm_medis "+ "inner join databarang on detail_pemberian_obat.kode_brng=databarang.kode_brng "+ "where "+tgl+(TCari.getText().trim().equals("")?"":" and (tgl_perawatan like ? or "+ "detail_pemberian_obat.no_rawat like ? or reg_periksa.no_rkm_medis like ? or "+ "pasien.nm_pasien like ? or detail_pemberian_obat.kode_brng like ? or databarang.nama_brng like ? or "+ "detail_pemberian_obat.no_faktur like ? or detail_pemberian_obat.no_batch like ?) ")+ "order by detail_pemberian_obat.tgl_perawatan"; Valid.tabelKosong(tabModePO); try{ ps=koneksi.prepareStatement(sql); try { if(!TCari.getText().trim().equals("")){ ps.setString(1,"%"+TCari.getText().trim()+"%"); ps.setString(2,"%"+TCari.getText().trim()+"%"); 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()+"%"); } rs=ps.executeQuery(); jumlahtotal=0; while(rs.next()){ jumlahtotal=jumlahtotal+rs.getDouble("total"); tabModePO.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.getDouble(8),rs.getDouble(9), rs.getDouble(10),rs.getDouble(11),rs.getDouble(12), rs.getDouble(13),rs.getString(14),rs.getString(15), rs.getString(16) }); } } catch (Exception e) { System.out.println("Notif : "+e); } finally{ if(rs!=null){ rs.close(); } if(ps!=null){ ps.close(); } } }catch(Exception e){ System.out.println("Notifikasi : "+e); } LCount.setText(""+tabModePO.getRowCount()); LCount1.setText(""+Valid.SetAngka(jumlahtotal)); } private void isRawat() { Sequel.cariIsi("select reg_periksa.no_rkm_medis from reg_periksa where reg_periksa.no_rawat=? ",TNoRM,TNoRw.getText()); } private void isPsien() { Sequel.cariIsi("select pasien.nm_pasien from pasien where pasien.no_rkm_medis=? ",TPasien,TNoRM.getText()); } private void getData() { if(tbPemberianObat.getSelectedRow()!= -1){ cmbJam.setSelectedItem(tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),1).toString().substring(0,2)); cmbMnt.setSelectedItem(tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),1).toString().substring(3,5)); cmbDtk.setSelectedItem(tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),1).toString().substring(6,8)); TNoRw.setText(tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),2).toString()); TNoRM.setText(tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),3).toString()); TPasien.setText(tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),4).toString()); TKdOb.setText(tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),5).toString()); TNmOb.setText(tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),6).toString()); TBiayaObat.setText(tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),10).toString()); THBeli.setText(tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),12).toString()); Valid.SetTgl(DTPBeri,tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),0).toString()); } } public void setNoRm(String norwt, Date tgl1, Date tgl2,String statuspasien) { TNoRw.setText(norwt); TCari.setText(norwt); isRawat(); isPsien(); status=statuspasien; if(statuspasien.equals("ranap")){ BtnObat2.setEnabled(true); BtnObat3.setEnabled(false); if(Sequel.cariInteger("select count(stok_obat_pasien.no_rawat) from stok_obat_pasien where stok_obat_pasien.no_rawat=? ",norwt)>0){ btnObat1.setEnabled(false); }else{ btnObat1.setEnabled(true); } }else if(statuspasien.equals("ralan")){ btnObat1.setEnabled(true); BtnObat2.setEnabled(false); BtnObat3.setEnabled(true); } DTPCari1.setDate(tgl1); DTPCari2.setDate(tgl2); } public void setNoRm2(String norwt, Date tgl1, Date tgl2,String statuspasien) { TNoRw.setText(norwt); TCari.setText(norwt); isRawat(); isPsien(); status=statuspasien; if(statuspasien.equals("ranap")){ BtnObat2.setEnabled(true); BtnObat3.setEnabled(false); if(Sequel.cariInteger("select count(stok_obat_pasien.no_rawat) from stok_obat_pasien where stok_obat_pasien.no_rawat=? ",norwt)>0){ btnObat1.setEnabled(false); }else{ btnObat1.setEnabled(true); } }else if(statuspasien.equals("ralan")){ btnObat1.setEnabled(true); BtnObat2.setEnabled(false); BtnObat3.setEnabled(true); } DTPCari1.setDate(tgl1); DTPCari2.setDate(tgl2); ChkInput.setSelected(false); isForm(); } public void setNoRm3(String norwt, Date tgl1, Date tgl2,String statuspasien) { TNoRw.setText(norwt); TCari.setText(norwt); isRawat(); isPsien(); status=statuspasien; if(statuspasien.equals("ranap")){ BtnObat2.setEnabled(true); BtnObat3.setEnabled(false); if(Sequel.cariInteger("select count(stok_obat_pasien.no_rawat) from stok_obat_pasien where stok_obat_pasien.no_rawat=? ",norwt)>0){ btnObat1.setEnabled(false); }else{ btnObat1.setEnabled(true); } }else if(statuspasien.equals("ralan")){ btnObat1.setEnabled(true); BtnObat2.setEnabled(false); BtnObat3.setEnabled(true); } ChkJln.setSelected(false); DTPCari1.setDate(tgl1); DTPCari2.setDate(tgl2); ChkInput.setSelected(true); isForm(); } private void isForm(){ if(ChkInput.isSelected()==true){ ChkInput.setVisible(false); PanelInput.setPreferredSize(new Dimension(WIDTH,128)); FormInput.setVisible(true); ChkInput.setVisible(true); }else if(ChkInput.isSelected()==false){ ChkInput.setVisible(false); PanelInput.setPreferredSize(new Dimension(WIDTH,20)); FormInput.setVisible(false); ChkInput.setVisible(true); } } public void isCek(){ BtnHapus.setEnabled(akses.getberi_obat()); BtnPrint.setEnabled(akses.getberi_obat()); ppResepObat.setEnabled(akses.getresep_obat()); } private void jam(){ ActionListener taskPerformer = new ActionListener(){ private int nilai_jam; private int nilai_menit; private int nilai_detik; @Override public void actionPerformed(ActionEvent e) { String nol_jam = ""; String nol_menit = ""; String nol_detik = ""; // Membuat Date //Date dt = new Date(); Date now = Calendar.getInstance().getTime(); // Mengambil nilaj JAM, MENIT, dan DETIK Sekarang if(ChkJln.isSelected()==true){ nilai_jam = now.getHours(); nilai_menit = now.getMinutes(); nilai_detik = now.getSeconds(); }else if(ChkJln.isSelected()==false){ nilai_jam =cmbJam.getSelectedIndex(); nilai_menit =cmbMnt.getSelectedIndex(); nilai_detik =cmbDtk.getSelectedIndex(); } // Jika nilai JAM lebih kecil dari 10 (hanya 1 digit) if (nilai_jam <= 9) { // Tambahkan "0" didepannya nol_jam = "0"; } // Jika nilai MENIT lebih kecil dari 10 (hanya 1 digit) if (nilai_menit <= 9) { // Tambahkan "0" didepannya nol_menit = "0"; } // Jika nilai DETIK lebih kecil dari 10 (hanya 1 digit) if (nilai_detik <= 9) { // Tambahkan "0" didepannya nol_detik = "0"; } // Membuat String JAM, MENIT, DETIK String jam = nol_jam + Integer.toString(nilai_jam); String menit = nol_menit + Integer.toString(nilai_menit); String detik = nol_detik + Integer.toString(nilai_detik); // Menampilkan pada Layar //tampil_jam.setText(" " + jam + " : " + menit + " : " + detik + " "); cmbJam.setSelectedItem(jam); cmbMnt.setSelectedItem(menit); cmbDtk.setSelectedItem(detik); } }; // Timer new Timer(1000, taskPerformer).start(); } public void setDokter(String kodedokter,String namadokter){ this.kodedokter=kodedokter; this.namadokter=namadokter; } private void panggilform() { if(status.equals("ranap")){ dlgobt.setNoRm(TNoRw.getText(),TNoRM.getText(),TPasien.getText(),DTPBeri.getDate(),cmbJam.getSelectedItem().toString(),cmbMnt.getSelectedItem().toString(),cmbDtk.getSelectedItem().toString(),false); dlgobt.setSize(internalFrame1.getWidth()-20,internalFrame1.getHeight()-20); dlgobt.isCek(); dlgobt.tampil(); dlgobt.setLocationRelativeTo(internalFrame1); dlgobt.setVisible(true); }else if(status.equals("ralan")){ DlgCariObat dlgobtjalan=new DlgCariObat(null,false); dlgobtjalan.addWindowListener(new WindowListener() { @Override public void windowOpened(WindowEvent e) {} @Override public void windowClosing(WindowEvent e) {} @Override public void windowClosed(WindowEvent e) { if(akses.getform().equals("DlgPemberianObat")){ tampilPO(); } } @Override public void windowIconified(WindowEvent e) {} @Override public void windowDeiconified(WindowEvent e) {} @Override public void windowActivated(WindowEvent e) {} @Override public void windowDeactivated(WindowEvent e) {} }); dlgobtjalan.setNoRm2(TNoRw.getText(),TNoRM.getText(),TPasien.getText(),DTPBeri.getDate(),cmbJam.getSelectedItem().toString(),cmbMnt.getSelectedItem().toString(),cmbDtk.getSelectedItem().toString(),ChkJln.isSelected()); dlgobtjalan.isCek(); if(!namadokter.equals("")){ dlgobtjalan.setDokter(kodedokter, namadokter); } dlgobtjalan.setSize(internalFrame1.getWidth()-20,internalFrame1.getHeight()-20); dlgobtjalan.tampilobat(); dlgobtjalan.setLocationRelativeTo(internalFrame1); dlgobtjalan.setVisible(true); }else{ JOptionPane.showMessageDialog(rootPane,"Hanya bisa lewat Kasir Ralan atau Kamar Inap"); } } private void hapus() { statusberi=Sequel.cariIsi("select detail_pemberian_obat.status from detail_pemberian_obat where detail_pemberian_obat.no_rawat='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),2).toString()+"' "+ "and detail_pemberian_obat.kode_brng='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),5).toString()+"' "+ "and detail_pemberian_obat.tgl_perawatan='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),0).toString()+"' "+ "and detail_pemberian_obat.jam='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),1).toString()+"' "+ "and detail_pemberian_obat.no_batch='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),14).toString()+"' "+ "and detail_pemberian_obat.no_faktur='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),15).toString()+"' "); ttlhpp=Sequel.cariIsiAngka("select sum(detail_pemberian_obat.h_beli*detail_pemberian_obat.jml) from detail_pemberian_obat where detail_pemberian_obat.no_rawat='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),2).toString()+"' "+ "and detail_pemberian_obat.kode_brng='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),5).toString()+"' "+ "and detail_pemberian_obat.tgl_perawatan='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),0).toString()+"' "+ "and detail_pemberian_obat.jam='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),1).toString()+"' "+ "and detail_pemberian_obat.no_batch='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),14).toString()+"' "+ "and detail_pemberian_obat.no_faktur='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),15).toString()+"' "); ttljual=Sequel.cariIsiAngka("select sum(detail_pemberian_obat.total) from detail_pemberian_obat where detail_pemberian_obat.no_rawat='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),2).toString()+"' "+ "and detail_pemberian_obat.kode_brng='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),5).toString()+"' "+ "and detail_pemberian_obat.tgl_perawatan='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),0).toString()+"' "+ "and detail_pemberian_obat.jam='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),1).toString()+"' "+ "and detail_pemberian_obat.no_batch='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),14).toString()+"' "+ "and detail_pemberian_obat.no_faktur='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),15).toString()+"' "); if(Sequel.queryutf("delete from detail_pemberian_obat where no_rawat='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),2).toString()+"' "+ "and kode_brng='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),5).toString()+"' "+ "and tgl_perawatan='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),0).toString()+"' "+ "and jam='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),1).toString()+"' "+ "and no_batch='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),14).toString()+"' "+ "and no_faktur='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),15).toString()+"' ")==true){ if(statusberi.equals("Ranap")){ Sequel.queryu("delete from tampjurnal"); if(ttljual>0){ if(Sequel.menyimpantf2("tampjurnal","'"+Suspen_Piutang_Obat_Ranap+"','Suspen Piutang Obat Ranap','0','"+ttljual+"'","Rekening")==false){ sukses=false; } if(Sequel.menyimpantf2("tampjurnal","'"+Obat_Ranap+"','Pendapatan Obat Rawat Inap','"+ttljual+"','0'","Rekening")==false){ sukses=false; } } if(ttlhpp>0){ if(Sequel.menyimpantf2("tampjurnal","'"+HPP_Obat_Rawat_Inap+"','HPP Persediaan Obat Rawat Inap','0','"+ttlhpp+"'","Rekening")==false){ sukses=false; } if(Sequel.menyimpantf2("tampjurnal","'"+Persediaan_Obat_Rawat_Inap+"','Persediaan Obat Rawat Inap','"+ttlhpp+"','0'","Rekening")==false){ sukses=false; } } if(sukses==true){ sukses=jur.simpanJurnal(tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),2).toString(),"U","PEMBATALAN PEMBERIAN OBAT RAWAT INAP PASIEN "+TNoRM.getText()+" "+TPasien.getText()+" OLEH "+akses.getkode()); } }else if(statusberi.equals("Ralan")){ Sequel.queryu("delete from tampjurnal"); if(ttljual>0){ if(Sequel.menyimpantf2("tampjurnal","'"+Suspen_Piutang_Obat_Ralan+"','Suspen Piutang Obat Ralan','0','"+ttljual+"'","Rekening")==false){ sukses=false; } if(Sequel.menyimpantf2("tampjurnal","'"+Obat_Ralan+"','Pendapatan Obat Rawat Jalan','"+ttljual+"','0'","Rekening")==false){ sukses=false; } } if(ttlhpp>0){ if(Sequel.menyimpantf2("tampjurnal","'"+HPP_Obat_Rawat_Jalan+"','HPP Persediaan Obat Rawat Jalan','0','"+ttlhpp+"'","Rekening")==false){ sukses=false; } if(Sequel.menyimpantf2("tampjurnal","'"+Persediaan_Obat_Rawat_Jalan+"','Persediaan Obat Rawat Jalan','"+ttlhpp+"','0'","Rekening")==false){ sukses=false; } } if(sukses==true){ sukses=jur.simpanJurnal(tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),2).toString(),"U","PEMBATALAN PEMBERIAN OBAT RAWAT JALAN PASIEN "+TNoRM.getText()+" "+TPasien.getText()+" OLEH "+akses.getkode()); } } Sequel.queryu("delete from aturan_pakai where no_rawat='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),2).toString()+"' "+ "and kode_brng='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),5).toString()+"' "+ "and tgl_perawatan='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),0).toString()+"' "+ "and jam='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),1).toString()+"'"); if(btnObat1.isEnabled()==true){ if(aktifkanbatch.equals("yes")){ Sequel.mengedit("data_batch","no_batch=? and kode_brng=? and no_faktur=?","sisa=sisa+?",4,new String[]{ tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),9).toString(), tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),14).toString(), tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),5).toString(), tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),15).toString() }); Trackobat.catatRiwayat(tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),5).toString(),Valid.SetAngka(tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),9).toString()), 0,"Pemberian Obat",akses.getkode(),bangsal,"Hapus",tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),14).toString(),tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),15).toString(), tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),2).toString()+" "+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),3).toString()+" "+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),4).toString() ); Sequel.menyimpan("gudangbarang","'"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),5).toString()+"','"+bangsal+"',"+ "'"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),9).toString()+"',"+ "'"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),14).toString()+"',"+ "'"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),15).toString()+"'", "stok=stok+'"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),9).toString()+"'", "kode_brng='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),5).toString()+"' and kd_bangsal='"+bangsal+"' "+ "and no_batch='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),14).toString()+"' "+ "and no_faktur='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),15).toString()+"'"); }else{ Trackobat.catatRiwayat(tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),5).toString(),Valid.SetAngka(tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),9).toString()),0,"Pemberian Obat",akses.getkode(),bangsal,"Hapus","","", tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),2).toString()+" "+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),3).toString()+" "+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),4).toString() ); Sequel.menyimpan("gudangbarang","'"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),5).toString()+"','"+bangsal+"',"+ "'"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),9).toString()+"','',''", "stok=stok+'"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),9).toString()+"'", "kode_brng='"+tbPemberianObat.getValueAt(tbPemberianObat.getSelectedRow(),5).toString()+"' and kd_bangsal='"+bangsal+"' "+ "and no_batch='' and no_faktur=''"); } } }else{ sukses=false; } } }