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.KeyEvent; import java.awt.event.KeyListener; import java.awt.event.WindowEvent; import java.awt.event.WindowListener; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import javax.swing.JOptionPane; import javax.swing.JTable; import javax.swing.event.DocumentEvent; import javax.swing.table.DefaultTableModel; import javax.swing.table.TableColumn; import simrskhanza.DlgPasien; import keuangan.Jurnal; import simrskhanza.DlgCariBangsal; public class DlgReturJual extends javax.swing.JDialog { private final DefaultTableModel tabMode; private sekuel Sequel=new sekuel(); private validasi Valid=new validasi(); private Jurnal jur=new Jurnal(); private DlgCariBangsal bangsal=new DlgCariBangsal(null,false); private DlgCariReturJual form=new DlgCariReturJual(null,false); private DlgPasien member=new DlgPasien(null,false); private double ttlretur=0; private PreparedStatement ps; private ResultSet rs; private Connection koneksi=koneksiDB.condb(); private riwayatobat Trackobat=new riwayatobat(); private String formvalid=""; private String aktifkanbatch="no",norawat=""; private boolean sukses=true; /** Creates new form DlgProgramStudi * @param parent * @param modal */ public DlgReturJual(java.awt.Frame parent, boolean modal) { super(parent, modal); initComponents(); try { aktifkanbatch = koneksiDB.AKTIFKANBATCHOBAT(); } catch (Exception e) { System.out.println("E : "+e); aktifkanbatch = "no"; } tabMode=new DefaultTableModel(null,new Object[]{ "No.Nota","Kode Barang","Nama Barang","Satuan","Hrg.Retur(Rp)","Jml.Retur","Total Retur(Rp)","No.Batch","No.Faktur" }){ @Override public boolean isCellEditable(int rowIndex, int colIndex){return false;} Class[] types = new Class[] { java.lang.String.class,java.lang.String.class,java.lang.String.class,java.lang.String.class, java.lang.Double.class,java.lang.Double.class,java.lang.Double.class,java.lang.String.class, java.lang.String.class }; @Override public Class getColumnClass(int columnIndex) { return types [columnIndex]; } }; tbDokter.setModel(tabMode); tbDokter.setPreferredScrollableViewportSize(new Dimension(800,800)); tbDokter.setAutoResizeMode(JTable.AUTO_RESIZE_OFF); for (int i = 0; i < 9; i++) { TableColumn column = tbDokter.getColumnModel().getColumn(i); if(i==0){ column.setPreferredWidth(100); }else if(i==1){ column.setPreferredWidth(90); }else if(i==2){ column.setPreferredWidth(200); }else if(i==3){ column.setPreferredWidth(60); }else if(i==4){ column.setPreferredWidth(90); }else if(i==5){ column.setPreferredWidth(60); }else if(i==6){ column.setPreferredWidth(90); }else if(i==7){ column.setPreferredWidth(70); }else if(i==8){ column.setPreferredWidth(100); } } tbDokter.setDefaultRenderer(Object.class, new WarnaTable()); NoRetur.setDocument(new batasInput((byte)14).getKata(NoRetur)); kdmem.setDocument(new batasInput((byte)15).getKata(kdmem)); NoNota.setDocument(new batasInput((byte)20).getKata(NoNota)); NoFaktur.setDocument(new batasInput((byte)20).getKata(NoFaktur)); Kdptg.setDocument(new batasInput((byte)25).getKata(Kdptg)); Kdbar.setDocument(new batasInput((byte)15).getKata(Kdbar)); //Jmlbeli.setDocument(new batasInput((byte)13).getKata(Jmlbeli)); Jmlretur.setDocument(new batasInput((byte)13).getKata(Jmlretur)); NoBatch.setDocument(new batasInput((byte)20).getKata(NoBatch)); Hargaretur.setDocument(new batasInput((byte)13).getKata(Hargaretur)); Jmlretur.getDocument().addDocumentListener(new javax.swing.event.DocumentListener(){ @Override public void insertUpdate(DocumentEvent e) {isHitung();} @Override public void removeUpdate(DocumentEvent e) {isHitung();} @Override public void changedUpdate(DocumentEvent e) {isHitung();} }); Hargaretur.getDocument().addDocumentListener(new javax.swing.event.DocumentListener(){ @Override public void insertUpdate(DocumentEvent e) {isHitung();} @Override public void removeUpdate(DocumentEvent e) {isHitung();} @Override public void changedUpdate(DocumentEvent e) {isHitung();} }); form.barang.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("DlgReturJual")){ if(form.barang.getTable().getSelectedRow()!= -1){ Kdbar.setText(form.barang.getTable().getValueAt(form.barang.getTable().getSelectedRow(),1).toString()); nmbar.setText(form.barang.getTable().getValueAt(form.barang.getTable().getSelectedRow(),2).toString()); Satuanbar.setText(form.barang.getTable().getValueAt(form.barang.getTable().getSelectedRow(),6).toString()); if(Jenisjual.getSelectedItem().equals("Jual Bebas")){ Hargaretur.setText(form.barang.getTable().getValueAt(form.barang.getTable().getSelectedRow(),20).toString()); }else if(Jenisjual.getSelectedItem().equals("Karyawan")){ Hargaretur.setText(form.barang.getTable().getValueAt(form.barang.getTable().getSelectedRow(),21).toString()); }else if(Jenisjual.getSelectedItem().equals("Beli Luar")){ Hargaretur.setText(form.barang.getTable().getValueAt(form.barang.getTable().getSelectedRow(),19).toString()); }else if(Jenisjual.getSelectedItem().equals("Rawat Jalan")){ Hargaretur.setText(form.barang.getTable().getValueAt(form.barang.getTable().getSelectedRow(),12).toString()); }else if(Jenisjual.getSelectedItem().equals("Kelas 1")){ Hargaretur.setText(form.barang.getTable().getValueAt(form.barang.getTable().getSelectedRow(),13).toString()); }else if(Jenisjual.getSelectedItem().equals("Kelas 2")){ Hargaretur.setText(form.barang.getTable().getValueAt(form.barang.getTable().getSelectedRow(),14).toString()); }else if(Jenisjual.getSelectedItem().equals("Kelas 3")){ Hargaretur.setText(form.barang.getTable().getValueAt(form.barang.getTable().getSelectedRow(),15).toString()); }else if(Jenisjual.getSelectedItem().equals("Utama/BPJS")){ Hargaretur.setText(form.barang.getTable().getValueAt(form.barang.getTable().getSelectedRow(),16).toString()); }else if(Jenisjual.getSelectedItem().equals("VIP")){ Hargaretur.setText(form.barang.getTable().getValueAt(form.barang.getTable().getSelectedRow(),17).toString()); }else if(Jenisjual.getSelectedItem().equals("VVIP")){ Hargaretur.setText(form.barang.getTable().getValueAt(form.barang.getTable().getSelectedRow(),18).toString()); }else if(Jenisjual.getSelectedItem().equals("Harga Beli")){ Hargaretur.setText(form.barang.getTable().getValueAt(form.barang.getTable().getSelectedRow(),11).toString()); } if(aktifkanbatch.equals("yes")){ NoBatch.setText(form.barang.getTable().getValueAt(form.barang.getTable().getSelectedRow(),32).toString()); NoFaktur.setText(form.barang.getTable().getValueAt(form.barang.getTable().getSelectedRow(),33).toString()); } } Kdbar.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) {} }); form.barang.getTable().addKeyListener(new KeyListener() { @Override public void keyTyped(KeyEvent e) {} @Override public void keyPressed(KeyEvent e) { if(akses.getform().equals("DlgReturJual")){ if(e.getKeyCode()==KeyEvent.VK_SPACE){ form.barang.dispose(); Kdbar.requestFocus(); } } } @Override public void keyReleased(KeyEvent e) {} }); member.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("DlgReturJual")){ if(member.getTable().getSelectedRow()!= -1){ kdmem.setText(member.getTable().getValueAt(member.getTable().getSelectedRow(),1).toString()); nmmem.setText(member.getTable().getValueAt(member.getTable().getSelectedRow(),2).toString()); } if(member.getTable2().getSelectedRow()!= -1){ kdmem.setText(member.getTable2().getValueAt(member.getTable2().getSelectedRow(),1).toString()); nmmem.setText(member.getTable2().getValueAt(member.getTable2().getSelectedRow(),2).toString()); } if(member.getTable3().getSelectedRow()!= -1){ kdmem.setText(member.getTable3().getValueAt(member.getTable3().getSelectedRow(),1).toString()); nmmem.setText(member.getTable3().getValueAt(member.getTable3().getSelectedRow(),2).toString()); } kdmem.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) {} }); member.getTable().addKeyListener(new KeyListener() { @Override public void keyTyped(KeyEvent e) {} @Override public void keyPressed(KeyEvent e) { if(akses.getform().equals("DlgReturJual")){ if(e.getKeyCode()==KeyEvent.VK_SPACE){ member.dispose(); } } } @Override public void keyReleased(KeyEvent e) {} }); member.getTable2().addKeyListener(new KeyListener() { @Override public void keyTyped(KeyEvent e) {} @Override public void keyPressed(KeyEvent e) { if(akses.getform().equals("DlgReturJual")){ if(e.getKeyCode()==KeyEvent.VK_SPACE){ member.dispose(); } } } @Override public void keyReleased(KeyEvent e) {} }); member.getTable3().addKeyListener(new KeyListener() { @Override public void keyTyped(KeyEvent e) {} @Override public void keyPressed(KeyEvent e) { if(akses.getform().equals("DlgReturJual")){ if(e.getKeyCode()==KeyEvent.VK_SPACE){ member.dispose(); } } } @Override public void keyReleased(KeyEvent e) {} }); bangsal.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("DlgReturJual")){ if(bangsal.getTable().getSelectedRow()!= -1){ kdgudang.setText(bangsal.getTable().getValueAt(bangsal.getTable().getSelectedRow(),0).toString()); nmgudang.setText(bangsal.getTable().getValueAt(bangsal.getTable().getSelectedRow(),1).toString()); } kdgudang.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) {} }); form.petugas.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("DlgReturJual")){ if(form.petugas.getTable().getSelectedRow()!= -1){ Kdptg.setText(form.petugas.getTable().getValueAt(form.petugas.getTable().getSelectedRow(),0).toString()); Nmptg.setText(form.petugas.getTable().getValueAt(form.petugas.getTable().getSelectedRow(),1).toString()); } Kdptg.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) {} }); } /** 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() { Kd2 = new widget.TextBox(); Popup = new javax.swing.JPopupMenu(); ppCetakNota = new javax.swing.JMenuItem(); internalFrame1 = new widget.InternalFrame(); scrollPane1 = new widget.ScrollPane(); tbDokter = new widget.Table(); jPanel1 = new javax.swing.JPanel(); panelisi1 = new widget.panelisi(); BtnTambah = new widget.Button(); BtnHapus = new widget.Button(); label9 = new widget.Label(); LTotal = new widget.Label(); BtnSimpan = new widget.Button(); BtnBatal = new widget.Button(); BtnCari = new widget.Button(); BtnKeluar = new widget.Button(); panelisi4 = new widget.panelisi(); label25 = new widget.Label(); Subtotal = new widget.TextBox(); label27 = new widget.Label(); Hargaretur = new widget.TextBox(); label17 = new widget.Label(); Kdbar = new widget.TextBox(); nmbar = new widget.TextBox(); BtnBrg = new widget.Button(); Jmlretur = new widget.TextBox(); label26 = new widget.Label(); Satuanbar = new widget.TextBox(); label21 = new widget.Label(); NoBatch = new widget.TextBox(); NoFaktur = new widget.TextBox(); label23 = new widget.Label(); panelisiBeli = new widget.panelisi(); label15 = new widget.Label(); NoRetur = new widget.TextBox(); label18 = new widget.Label(); NoNota = new widget.TextBox(); Kdptg = new widget.TextBox(); Jenisjual = new widget.ComboBox(); label13 = new widget.Label(); Nmptg = new widget.TextBox(); BtnPtg = new widget.Button(); label11 = new widget.Label(); TglRetur = new widget.Tanggal(); label16 = new widget.Label(); kdmem = new widget.TextBox(); nmmem = new widget.TextBox(); BtnMmb = new widget.Button(); label12 = new widget.Label(); label32 = new widget.Label(); kdgudang = new widget.TextBox(); nmgudang = new widget.TextBox(); BtnGudang = new widget.Button(); Kd2.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N Kd2.setName("Kd2"); // NOI18N Kd2.setPreferredSize(new java.awt.Dimension(207, 23)); Popup.setName("Popup"); // NOI18N ppCetakNota.setBackground(new java.awt.Color(255, 255, 254)); ppCetakNota.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N ppCetakNota.setForeground(new java.awt.Color(50, 50, 50)); ppCetakNota.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/Agenda-1-16x16.png"))); // NOI18N ppCetakNota.setText("Cetak Nota"); ppCetakNota.setHorizontalAlignment(javax.swing.SwingConstants.LEFT); ppCetakNota.setHorizontalTextPosition(javax.swing.SwingConstants.RIGHT); ppCetakNota.setName("ppCetakNota"); // NOI18N ppCetakNota.setPreferredSize(new java.awt.Dimension(150, 25)); ppCetakNota.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { ppCetakNotaActionPerformed(evt); } }); Popup.add(ppCetakNota); 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)), "::[ Transaksi Retur Obat, Alkes & BHP Medis Dari Pasien/Pembeli ]::", 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)); scrollPane1.setComponentPopupMenu(Popup); scrollPane1.setName("scrollPane1"); // NOI18N scrollPane1.setOpaque(true); tbDokter.setModel(new javax.swing.table.DefaultTableModel( new Object [][] { {}, {}, {}, {} }, new String [] { } )); tbDokter.setComponentPopupMenu(Popup); tbDokter.setName("tbDokter"); // NOI18N tbDokter.addMouseListener(new java.awt.event.MouseAdapter() { public void mouseClicked(java.awt.event.MouseEvent evt) { tbDokterMouseClicked(evt); } }); tbDokter.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { tbDokterKeyPressed(evt); } }); scrollPane1.setViewportView(tbDokter); internalFrame1.add(scrollPane1, java.awt.BorderLayout.CENTER); jPanel1.setName("jPanel1"); // NOI18N jPanel1.setOpaque(false); jPanel1.setPreferredSize(new java.awt.Dimension(816, 130)); jPanel1.setLayout(new java.awt.BorderLayout(1, 1)); panelisi1.setName("panelisi1"); // NOI18N panelisi1.setPreferredSize(new java.awt.Dimension(100, 56)); panelisi1.setLayout(new java.awt.FlowLayout(java.awt.FlowLayout.LEFT, 5, 9)); BtnTambah.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/add-file-16x16.png"))); // NOI18N BtnTambah.setMnemonic('T'); BtnTambah.setText("Tambah"); BtnTambah.setToolTipText("Alt+T"); BtnTambah.setName("BtnTambah"); // NOI18N BtnTambah.setPreferredSize(new java.awt.Dimension(100, 30)); BtnTambah.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { BtnTambahActionPerformed(evt); } }); BtnTambah.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { BtnTambahKeyPressed(evt); } }); panelisi1.add(BtnTambah); 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); } }); panelisi1.add(BtnHapus); label9.setText("Total :"); label9.setName("label9"); // NOI18N label9.setPreferredSize(new java.awt.Dimension(50, 23)); panelisi1.add(label9); LTotal.setHorizontalAlignment(javax.swing.SwingConstants.LEFT); LTotal.setText("0"); LTotal.setName("LTotal"); // NOI18N LTotal.setPreferredSize(new java.awt.Dimension(110, 23)); panelisi1.add(LTotal); BtnSimpan.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/save-16x16.png"))); // NOI18N BtnSimpan.setMnemonic('S'); BtnSimpan.setText("Simpan"); BtnSimpan.setToolTipText("Alt+S"); BtnSimpan.setName("BtnSimpan"); // NOI18N BtnSimpan.setPreferredSize(new java.awt.Dimension(100, 30)); BtnSimpan.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { BtnSimpanActionPerformed(evt); } }); BtnSimpan.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { BtnSimpanKeyPressed(evt); } }); panelisi1.add(BtnSimpan); BtnBatal.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/Cancel-2-16x16.png"))); // NOI18N BtnBatal.setMnemonic('B'); BtnBatal.setText("Clear"); BtnBatal.setToolTipText("Alt+B"); BtnBatal.setName("BtnBatal"); // NOI18N BtnBatal.setPreferredSize(new java.awt.Dimension(100, 30)); BtnBatal.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { BtnBatalActionPerformed(evt); } }); BtnBatal.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { BtnBatalKeyPressed(evt); } }); panelisi1.add(BtnBatal); BtnCari.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/Search-16x16.png"))); // NOI18N BtnCari.setMnemonic('E'); BtnCari.setText("Cari"); BtnCari.setToolTipText("Alt+E"); BtnCari.setName("BtnCari"); // NOI18N BtnCari.setPreferredSize(new java.awt.Dimension(100, 30)); 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); } }); panelisi1.add(BtnCari); 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); } }); panelisi1.add(BtnKeluar); jPanel1.add(panelisi1, java.awt.BorderLayout.PAGE_END); panelisi4.setName("panelisi4"); // NOI18N panelisi4.setPreferredSize(new java.awt.Dimension(100, 44)); panelisi4.setLayout(null); label25.setText("SubTotal :"); label25.setName("label25"); // NOI18N label25.setPreferredSize(new java.awt.Dimension(70, 23)); panelisi4.add(label25); label25.setBounds(592, 40, 80, 23); Subtotal.setEditable(false); Subtotal.setName("Subtotal"); // NOI18N Subtotal.setPreferredSize(new java.awt.Dimension(80, 23)); panelisi4.add(Subtotal); Subtotal.setBounds(676, 40, 100, 23); label27.setText("Hrga.Retur :"); label27.setName("label27"); // NOI18N label27.setPreferredSize(new java.awt.Dimension(70, 23)); panelisi4.add(label27); label27.setBounds(592, 10, 80, 23); Hargaretur.setName("Hargaretur"); // NOI18N Hargaretur.setPreferredSize(new java.awt.Dimension(80, 23)); Hargaretur.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { HargareturKeyPressed(evt); } }); panelisi4.add(Hargaretur); Hargaretur.setBounds(676, 10, 100, 23); label17.setText("Barang :"); label17.setName("label17"); // NOI18N label17.setPreferredSize(new java.awt.Dimension(70, 23)); panelisi4.add(label17); label17.setBounds(0, 10, 63, 23); Kdbar.setName("Kdbar"); // NOI18N Kdbar.setPreferredSize(new java.awt.Dimension(80, 23)); Kdbar.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { KdbarKeyPressed(evt); } }); panelisi4.add(Kdbar); Kdbar.setBounds(67, 10, 100, 23); nmbar.setEditable(false); nmbar.setName("nmbar"); // NOI18N nmbar.setPreferredSize(new java.awt.Dimension(207, 23)); panelisi4.add(nmbar); nmbar.setBounds(169, 10, 320, 23); BtnBrg.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/190.png"))); // NOI18N BtnBrg.setMnemonic('3'); BtnBrg.setToolTipText("Alt+3"); BtnBrg.setName("BtnBrg"); // NOI18N BtnBrg.setPreferredSize(new java.awt.Dimension(28, 23)); BtnBrg.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { BtnBrgActionPerformed(evt); } }); panelisi4.add(BtnBrg); BtnBrg.setBounds(546, 10, 28, 23); Jmlretur.setName("Jmlretur"); // NOI18N Jmlretur.setPreferredSize(new java.awt.Dimension(80, 23)); Jmlretur.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { JmlreturKeyPressed(evt); } }); panelisi4.add(Jmlretur); Jmlretur.setBounds(524, 40, 50, 23); label26.setText("Jumlah Retur :"); label26.setName("label26"); // NOI18N label26.setPreferredSize(new java.awt.Dimension(90, 23)); panelisi4.add(label26); label26.setBounds(440, 40, 80, 23); Satuanbar.setEditable(false); Satuanbar.setName("Satuanbar"); // NOI18N Satuanbar.setPreferredSize(new java.awt.Dimension(80, 23)); panelisi4.add(Satuanbar); Satuanbar.setBounds(491, 10, 53, 23); label21.setText("No.Batch :"); label21.setName("label21"); // NOI18N label21.setPreferredSize(new java.awt.Dimension(70, 23)); panelisi4.add(label21); label21.setBounds(0, 40, 63, 23); NoBatch.setName("NoBatch"); // NOI18N NoBatch.setPreferredSize(new java.awt.Dimension(80, 23)); NoBatch.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { NoBatchKeyPressed(evt); } }); panelisi4.add(NoBatch); NoBatch.setBounds(67, 40, 100, 23); NoFaktur.setName("NoFaktur"); // NOI18N NoFaktur.setPreferredSize(new java.awt.Dimension(80, 23)); NoFaktur.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { NoFakturKeyPressed(evt); } }); panelisi4.add(NoFaktur); NoFaktur.setBounds(244, 40, 140, 23); label23.setText("Faktur :"); label23.setName("label23"); // NOI18N label23.setPreferredSize(new java.awt.Dimension(70, 23)); panelisi4.add(label23); label23.setBounds(170, 40, 70, 23); jPanel1.add(panelisi4, java.awt.BorderLayout.CENTER); internalFrame1.add(jPanel1, java.awt.BorderLayout.PAGE_END); panelisiBeli.setName("panelisiBeli"); // NOI18N panelisiBeli.setPreferredSize(new java.awt.Dimension(100, 103)); panelisiBeli.setLayout(null); label15.setText("No.Retur :"); label15.setName("label15"); // NOI18N label15.setPreferredSize(new java.awt.Dimension(60, 23)); panelisiBeli.add(label15); label15.setBounds(0, 10, 70, 23); NoRetur.setName("NoRetur"); // NOI18N NoRetur.setPreferredSize(new java.awt.Dimension(207, 23)); NoRetur.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { NoReturKeyPressed(evt); } }); panelisiBeli.add(NoRetur); NoRetur.setBounds(74, 10, 190, 23); label18.setText("No.Nota :"); label18.setName("label18"); // NOI18N label18.setPreferredSize(new java.awt.Dimension(60, 23)); panelisiBeli.add(label18); label18.setBounds(0, 40, 70, 23); NoNota.setName("NoNota"); // NOI18N NoNota.setPreferredSize(new java.awt.Dimension(207, 23)); NoNota.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { NoNotaKeyPressed(evt); } }); panelisiBeli.add(NoNota); NoNota.setBounds(74, 40, 190, 23); Kdptg.setName("Kdptg"); // NOI18N Kdptg.setPreferredSize(new java.awt.Dimension(80, 23)); Kdptg.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { KdptgKeyPressed(evt); } }); panelisiBeli.add(Kdptg); Kdptg.setBounds(409, 40, 100, 23); Jenisjual.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Rawat Jalan", "Kelas 1", "Kelas 2", "Kelas 3", "Utama/BPJS", "VIP", "VVIP", "Beli Luar", "Jual Bebas", "Karyawan", "Harga Beli" })); Jenisjual.setSelectedIndex(10); Jenisjual.setName("Jenisjual"); // NOI18N Jenisjual.setPreferredSize(new java.awt.Dimension(45, 23)); Jenisjual.addItemListener(new java.awt.event.ItemListener() { public void itemStateChanged(java.awt.event.ItemEvent evt) { JenisjualItemStateChanged(evt); } }); panelisiBeli.add(Jenisjual); Jenisjual.setBounds(74, 70, 120, 23); label13.setText("Petugas :"); label13.setName("label13"); // NOI18N label13.setPreferredSize(new java.awt.Dimension(70, 23)); panelisiBeli.add(label13); label13.setBounds(335, 40, 70, 23); Nmptg.setEditable(false); Nmptg.setName("Nmptg"); // NOI18N Nmptg.setPreferredSize(new java.awt.Dimension(207, 23)); panelisiBeli.add(Nmptg); Nmptg.setBounds(511, 40, 230, 23); BtnPtg.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/190.png"))); // NOI18N BtnPtg.setMnemonic('2'); BtnPtg.setToolTipText("Alt+2"); BtnPtg.setName("BtnPtg"); // NOI18N BtnPtg.setPreferredSize(new java.awt.Dimension(28, 23)); BtnPtg.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { BtnPtgActionPerformed(evt); } }); panelisiBeli.add(BtnPtg); BtnPtg.setBounds(744, 40, 28, 23); label11.setText("Tanggal :"); label11.setName("label11"); // NOI18N label11.setPreferredSize(new java.awt.Dimension(70, 23)); panelisiBeli.add(label11); label11.setBounds(195, 70, 52, 23); TglRetur.setDisplayFormat("dd-MM-yyyy"); TglRetur.setName("TglRetur"); // NOI18N TglRetur.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { TglReturKeyPressed(evt); } }); panelisiBeli.add(TglRetur); TglRetur.setBounds(251, 70, 90, 23); label16.setText("Pasien :"); label16.setName("label16"); // NOI18N label16.setPreferredSize(new java.awt.Dimension(60, 23)); panelisiBeli.add(label16); label16.setBounds(335, 10, 70, 23); kdmem.setName("kdmem"); // NOI18N kdmem.setPreferredSize(new java.awt.Dimension(80, 23)); kdmem.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { kdmemKeyPressed(evt); } }); panelisiBeli.add(kdmem); kdmem.setBounds(409, 10, 100, 23); nmmem.setName("nmmem"); // NOI18N nmmem.setPreferredSize(new java.awt.Dimension(207, 23)); panelisiBeli.add(nmmem); nmmem.setBounds(511, 10, 230, 23); BtnMmb.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/190.png"))); // NOI18N BtnMmb.setMnemonic('1'); BtnMmb.setToolTipText("Alt+1"); BtnMmb.setName("BtnMmb"); // NOI18N BtnMmb.setPreferredSize(new java.awt.Dimension(28, 23)); BtnMmb.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { BtnMmbActionPerformed(evt); } }); panelisiBeli.add(BtnMmb); BtnMmb.setBounds(744, 10, 28, 23); label12.setText("Jenis :"); label12.setName("label12"); // NOI18N label12.setPreferredSize(new java.awt.Dimension(70, 23)); panelisiBeli.add(label12); label12.setBounds(0, 70, 70, 23); label32.setText("Lokasi :"); label32.setName("label32"); // NOI18N label32.setPreferredSize(new java.awt.Dimension(70, 23)); panelisiBeli.add(label32); label32.setBounds(335, 70, 70, 23); kdgudang.setName("kdgudang"); // NOI18N kdgudang.setPreferredSize(new java.awt.Dimension(80, 23)); kdgudang.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { kdgudangKeyPressed(evt); } }); panelisiBeli.add(kdgudang); kdgudang.setBounds(409, 70, 100, 23); nmgudang.setEditable(false); nmgudang.setName("nmgudang"); // NOI18N nmgudang.setPreferredSize(new java.awt.Dimension(207, 23)); panelisiBeli.add(nmgudang); nmgudang.setBounds(511, 70, 230, 23); BtnGudang.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/190.png"))); // NOI18N BtnGudang.setMnemonic('2'); BtnGudang.setToolTipText("Alt+2"); BtnGudang.setName("BtnGudang"); // NOI18N BtnGudang.setPreferredSize(new java.awt.Dimension(28, 23)); BtnGudang.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { BtnGudangActionPerformed(evt); } }); panelisiBeli.add(BtnGudang); BtnGudang.setBounds(744, 70, 28, 23); internalFrame1.add(panelisiBeli, java.awt.BorderLayout.PAGE_START); getContentPane().add(internalFrame1, java.awt.BorderLayout.CENTER); pack(); }// //GEN-END:initComponents private void tbDokterMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_tbDokterMouseClicked if(tabMode.getRowCount()!=0){ try { getData(); } catch (java.lang.NullPointerException e) { } } }//GEN-LAST:event_tbDokterMouseClicked private void tbDokterKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_tbDokterKeyPressed if(tabMode.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_tbDokterKeyPressed private void BtnTambahActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnTambahActionPerformed if(nmbar.getText().trim().equals("")){ Valid.textKosong(Kdbar,"Obat/Alkes/BHP"); }else if(Jmlretur.getText().trim().equals("")){ Valid.textKosong(Jmlretur,"Jumlah Retur"); }else if(Jmlretur.getText().trim().equals("0")){ Valid.textKosong(Jmlretur,"Jumlah Retur"); }else if(aktifkanbatch.equals("yes")&&NoFaktur.getText().equals("")){ Valid.textKosong(NoFaktur,"No.Faktur"); }else if(aktifkanbatch.equals("yes")&&NoBatch.getText().equals("")){ Valid.textKosong(NoBatch,"No.Batch"); }else if(Hargaretur.getText().trim().equals("")){ Valid.textKosong(Hargaretur,"harga retur"); }else{ if(formvalid.equals("No")){ if(aktifkanbatch.equals("yes")){ if(Double.parseDouble(Jmlretur.getText())<=Sequel.cariIsiAngka("select sum(jml) from detail_pemberian_obat where no_rawat='"+norawat+"' and kode_brng='"+Kdbar.getText()+"' and no_batch='"+NoBatch.getText()+"' and no_faktur='"+NoFaktur.getText()+"'")){ if(Sequel.menyimpantf("tampreturjual","'"+NoNota.getText()+"','"+Kdbar.getText()+"','"+nmbar.getText()+"','0','0','"+Jmlretur.getText()+"','"+Hargaretur.getText()+"','"+Satuanbar.getText()+"','"+Subtotal.getText()+"','"+NoBatch.getText()+"','"+akses.getkode()+"','"+NoFaktur.getText()+"'","Kode Barang, No.Batch, No.Faktur")==true){ emptTeks(); tampil(); } }else{ JOptionPane.showMessageDialog(null,"Jumlah obat retur tidak sesuai dengan pemberian obat..!!"); Jmlretur.requestFocus(); } }else{ if(Double.parseDouble(Jmlretur.getText())<=Sequel.cariIsiAngka("select sum(jml) from detail_pemberian_obat where no_rawat='"+norawat+"' and kode_brng='"+Kdbar.getText()+"' and no_batch='' and no_faktur=''")){ if(Sequel.menyimpantf("tampreturjual","'"+NoNota.getText()+"','"+Kdbar.getText()+"','"+nmbar.getText()+"','0','0','"+Jmlretur.getText()+"','"+Hargaretur.getText()+"','"+Satuanbar.getText()+"','"+Subtotal.getText()+"','"+NoBatch.getText()+"','"+akses.getkode()+"','"+NoFaktur.getText()+"'","Kode Barang, No.Batch, No.Faktur")==true){ emptTeks(); tampil(); } }else{ JOptionPane.showMessageDialog(null,"Jumlah obat retur tidak sesuai dengan pemberian obat..!!"); Jmlretur.requestFocus(); } } }else{ if(Sequel.menyimpantf("tampreturjual","'"+NoNota.getText()+"','"+Kdbar.getText()+"','"+nmbar.getText()+"','0','0','"+Jmlretur.getText()+"','"+Hargaretur.getText()+"','"+Satuanbar.getText()+"','"+Subtotal.getText()+"','"+NoBatch.getText()+"','"+akses.getkode()+"','"+NoFaktur.getText()+"'","Kode Barang, No.Batch, No.Faktur")==true){ emptTeks(); tampil(); } } } }//GEN-LAST:event_BtnTambahActionPerformed private void BtnTambahKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnTambahKeyPressed if(evt.getKeyCode()==KeyEvent.VK_SPACE){ BtnTambahActionPerformed(null); }else{ Valid.pindah(evt,Hargaretur, BtnHapus); } }//GEN-LAST:event_BtnTambahKeyPressed private void BtnHapusActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnHapusActionPerformed if(nmbar.getText().trim().equals("")){ JOptionPane.showMessageDialog(null,"Maaf, Pilih dulu data yang akan Anda hapus dengan menklik data pada tabel...!!!"); tbDokter.requestFocus(); }else{ Valid.hapusTable(tabMode,Kdbar," tampreturjual","no_batch='"+NoBatch.getText()+"' and nota_jual='"+NoNota.getText()+"' and no_faktur='"+NoFaktur.getText()+"' and petugas='"+akses.getkode()+"' and kode_brng"); tampil(); emptTeks(); } }//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, BtnTambah, BtnCari); } }//GEN-LAST:event_BtnHapusKeyPressed private void BtnCariActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnCariActionPerformed this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR)); form.isCek(); form.setSize(internalFrame1.getWidth()-20,internalFrame1.getHeight()-20); form.setLocationRelativeTo(internalFrame1); form.setAlwaysOnTop(false); form.setVisible(true); this.setCursor(Cursor.getDefaultCursor()); }//GEN-LAST:event_BtnCariActionPerformed 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,BtnBatal,Kdbar);} }//GEN-LAST:event_BtnKeluarKeyPressed /* private void KdKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_TKdKeyPressed Valid.pindah(evt,BtnCari,Nm); }//GEN-LAST:event_TKdKeyPressed */ private void BtnPtgActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnPtgActionPerformed akses.setform("DlgReturJual"); this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR)); form.petugas.emptTeks(); form.petugas.isCek(); form.petugas.setSize(internalFrame1.getWidth()-20,internalFrame1.getHeight()-20); form.petugas.setLocationRelativeTo(internalFrame1); form.petugas.setAlwaysOnTop(false); form.petugas.setVisible(true); this.setCursor(Cursor.getDefaultCursor()); }//GEN-LAST:event_BtnPtgActionPerformed private void TglReturKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_TglReturKeyPressed Valid.pindah(evt,NoRetur,Kdptg); }//GEN-LAST:event_TglReturKeyPressed private void BtnSimpanActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnSimpanActionPerformed if(NoRetur.getText().trim().equals("")){ Valid.textKosong(NoRetur,"No.Retur"); }else if(Nmptg.getText().trim().equals("")){ Valid.textKosong(Kdptg,"Petugas"); }else if(nmmem.getText().trim().equals("")){ Valid.textKosong(kdmem,"Member"); }else if(nmgudang.getText().trim().equals("")){ Valid.textKosong(kdgudang,"Lokasi"); }else if(tabMode.getRowCount()==0){ JOptionPane.showMessageDialog(null,"Maaf, data sudah habis...!!!!"); Kdbar.requestFocus(); }else{ int reply = JOptionPane.showConfirmDialog(rootPane,"Eeiiiiiits, udah bener belum data yang mau disimpan..??","Konfirmasi",JOptionPane.YES_NO_OPTION); if (reply == JOptionPane.YES_OPTION) { Sequel.AutoComitFalse(); sukses=true; if(Sequel.menyimpantf2("returjual","'"+NoRetur.getText()+"','"+Valid.SetTgl(TglRetur.getSelectedItem()+"")+"','"+Kdptg.getText()+"','"+kdmem.getText()+"','"+kdgudang.getText()+"'","data")==true){ simpan(); }else{ int konfirm = JOptionPane.showConfirmDialog(rootPane,"No.Retur sudah ada sebelumnya,\napa data mau ditambahkan ke No.Retur tersebut..??","Konfirmasi",JOptionPane.YES_NO_OPTION); if (konfirm == JOptionPane.YES_OPTION) { simpan(); } } if(sukses==true){ if(!formvalid.equals("No")){ Sequel.queryu("delete from tampjurnal"); if(Sequel.menyimpantf2("tampjurnal","'"+Sequel.cariIsi("select Retur_Dari_pembeli from set_akun")+"','RETUR PENJUALAN','0','"+ttlretur+"'","Rekening")==false){ sukses=false; } if(Sequel.menyimpantf2("tampjurnal","'"+Sequel.cariIsi("select Kontra_Retur_Dari_Pembeli from set_akun")+"','KAS DI TANGAN','"+ttlretur+"','0'","Rekening")==false){ sukses=false; } if(sukses==true){ sukses=jur.simpanJurnal(NoRetur.getText(),"U","RETUR PENJUALAN DI "+nmgudang.getText().toUpperCase()+", OLEH "+akses.getkode()); } } } if(sukses==true){ Sequel.Commit(); }else{ sukses=false; JOptionPane.showMessageDialog(null,"Terjadi kesalahan saat pemrosesan data, transaksi dibatalkan.\nPeriksa kembali data sebelum melanjutkan menyimpan..!!"); Sequel.RollBack(); } Sequel.AutoComitTrue(); if(sukses==true){ BtnBatalActionPerformed(evt); } } } }//GEN-LAST:event_BtnSimpanActionPerformed private void BtnSimpanKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnSimpanKeyPressed if(evt.getKeyCode()==KeyEvent.VK_SPACE){ BtnSimpanActionPerformed(null); }else{ Valid.pindah(evt,Kdbar,BtnBatal); } }//GEN-LAST:event_BtnSimpanKeyPressed private void BtnBatalActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnBatalActionPerformed Sequel.queryu("delete from tampreturjual where petugas='"+akses.getkode()+"'"); tampil(); autonomor(); }//GEN-LAST:event_BtnBatalActionPerformed private void BtnBatalKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnBatalKeyPressed if(evt.getKeyCode()==KeyEvent.VK_SPACE){ emptTeks(); }else{Valid.pindah(evt, BtnSimpan, BtnHapus);} }//GEN-LAST:event_BtnBatalKeyPressed private void NoReturKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_NoReturKeyPressed Valid.pindah(evt, BtnTambah, TglRetur); }//GEN-LAST:event_NoReturKeyPressed private void KdptgKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_KdptgKeyPressed if(evt.getKeyCode()==KeyEvent.VK_PAGE_DOWN){ Nmptg.setText(form.petugas.tampil3(Kdptg.getText())); }else if(evt.getKeyCode()==KeyEvent.VK_PAGE_UP){ Nmptg.setText(form.petugas.tampil3(Kdptg.getText())); TglRetur.requestFocus(); }else if(evt.getKeyCode()==KeyEvent.VK_ENTER){ Nmptg.setText(form.petugas.tampil3(Kdptg.getText())); NoNota.requestFocus(); }else if(evt.getKeyCode()==KeyEvent.VK_UP){ BtnPtgActionPerformed(null); } }//GEN-LAST:event_KdptgKeyPressed private void BtnCariKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnCariKeyPressed if(evt.getKeyCode()==KeyEvent.VK_SPACE){ //BtnEditActionPerformed(null); }else{ Valid.pindah(evt, BtnHapus, Kdbar); } }//GEN-LAST:event_BtnCariKeyPressed private void NoNotaKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_NoNotaKeyPressed Valid.pindah(evt, Kdptg, Jmlretur); }//GEN-LAST:event_NoNotaKeyPressed private void HargareturKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_HargareturKeyPressed Valid.pindah(evt, Jmlretur, BtnTambah); }//GEN-LAST:event_HargareturKeyPressed private void KdbarKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_KdbarKeyPressed if(evt.getKeyCode()==KeyEvent.VK_PAGE_DOWN){ cariBatch(); }else if(evt.getKeyCode()==KeyEvent.VK_PAGE_UP){ cariBatch(); Kdptg.requestFocus(); }else if(evt.getKeyCode()==KeyEvent.VK_ENTER){ cariBatch(); Jmlretur.requestFocus(); }else if(evt.getKeyCode()==KeyEvent.VK_UP){ BtnBrgActionPerformed(null); } }//GEN-LAST:event_KdbarKeyPressed private void BtnBrgActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnBrgActionPerformed akses.setform("DlgReturJual"); if(aktifkanbatch.equals("yes")){ form.barang.aktifkanbatch="yes"; form.barang.isBatch(); } form.barang.emptTeks(); form.barang.isCek(); if(!norawat.equals("")){ form.barang.tampil4(norawat); } form.barang.setSize(internalFrame1.getWidth()-20,internalFrame1.getHeight()-20); form.barang.setLocationRelativeTo(internalFrame1); form.barang.setAlwaysOnTop(false); form.barang.setVisible(true); }//GEN-LAST:event_BtnBrgActionPerformed private void JmlreturKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_JmlreturKeyPressed Valid.pindah(evt, NoNota,Hargaretur); }//GEN-LAST:event_JmlreturKeyPressed private void kdmemKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_kdmemKeyPressed if(evt.getKeyCode()==KeyEvent.VK_PAGE_DOWN){ Sequel.cariIsi("select pasien.nm_pasien from pasien where pasien.no_rkm_medis=?", nmmem,kdmem.getText()); }else if(evt.getKeyCode()==KeyEvent.VK_PAGE_UP){ Sequel.cariIsi("select pasien.nm_pasien from pasien where pasien.no_rkm_medis=?", nmmem,kdmem.getText()); TglRetur.requestFocus(); }else if(evt.getKeyCode()==KeyEvent.VK_ENTER){ Sequel.cariIsi("select pasien.nm_pasien from pasien where pasien.no_rkm_medis=?", nmmem,kdmem.getText()); Kdptg.requestFocus(); }else if(evt.getKeyCode()==KeyEvent.VK_UP){ BtnMmbActionPerformed(null); } }//GEN-LAST:event_kdmemKeyPressed private void BtnMmbActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnMmbActionPerformed akses.setform("DlgReturJual"); member.emptTeks(); member.isCek(); member.setSize(internalFrame1.getWidth()-20,internalFrame1.getHeight()-20); member.setLocationRelativeTo(internalFrame1); member.setAlwaysOnTop(false); member.setVisible(true); }//GEN-LAST:event_BtnMmbActionPerformed private void JenisjualItemStateChanged(java.awt.event.ItemEvent evt) {//GEN-FIRST:event_JenisjualItemStateChanged cariBatch(); }//GEN-LAST:event_JenisjualItemStateChanged private void ppCetakNotaActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_ppCetakNotaActionPerformed this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR)); if(NoRetur.getText().trim().equals("")){ Valid.textKosong(NoRetur,"No.Retur"); }else if(Nmptg.getText().trim().equals("")){ Valid.textKosong(Kdptg,"Petugas"); }else if(nmmem.getText().trim().equals("")){ Valid.textKosong(kdmem,"Member"); }else if(tabMode.getRowCount()==0){ JOptionPane.showMessageDialog(null,"Maaf, data sudah habis...!!!!"); Kdbar.requestFocus(); }else { Valid.panggilUrl("billing/NotaApotek5.php?noretur="+NoRetur.getText()+"&nm_member="+nmmem.getText().replaceAll(" ","_")+"&tanggal="+Valid.SetTgl(TglRetur.getSelectedItem()+"")+"&petugas="+Nmptg.getText().replaceAll(" ","_")+"&usere="+koneksiDB.USERHYBRIDWEB()+"&passwordte="+koneksiDB.PASHYBRIDWEB()); } this.setCursor(Cursor.getDefaultCursor()); }//GEN-LAST:event_ppCetakNotaActionPerformed private void kdgudangKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_kdgudangKeyPressed if(evt.getKeyCode()==KeyEvent.VK_PAGE_DOWN){ nmgudang.setText(bangsal.tampil3(kdgudang.getText())); }else if(evt.getKeyCode()==KeyEvent.VK_PAGE_UP){ nmgudang.setText(bangsal.tampil3(kdgudang.getText())); Kdptg.requestFocus(); }else if(evt.getKeyCode()==KeyEvent.VK_ENTER){ nmgudang.setText(bangsal.tampil3(kdgudang.getText())); BtnSimpan.requestFocus(); }else if(evt.getKeyCode()==KeyEvent.VK_UP){ BtnGudangActionPerformed(null); } }//GEN-LAST:event_kdgudangKeyPressed private void BtnGudangActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnGudangActionPerformed akses.setform("DlgReturJual"); bangsal.isCek(); bangsal.emptTeks(); bangsal.setSize(internalFrame1.getWidth()-20,internalFrame1.getHeight()-20); bangsal.setLocationRelativeTo(internalFrame1); bangsal.setAlwaysOnTop(false); bangsal.setVisible(true); }//GEN-LAST:event_BtnGudangActionPerformed private void formWindowOpened(java.awt.event.WindowEvent evt) {//GEN-FIRST:event_formWindowOpened tampil(); }//GEN-LAST:event_formWindowOpened private void NoBatchKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_NoBatchKeyPressed if(evt.getKeyCode()==KeyEvent.VK_PAGE_DOWN){ cariBatch(); }else if(evt.getKeyCode()==KeyEvent.VK_PAGE_UP){ cariBatch(); Kdbar.requestFocus(); }else if(evt.getKeyCode()==KeyEvent.VK_ENTER){ cariBatch(); Jmlretur.requestFocus(); } }//GEN-LAST:event_NoBatchKeyPressed private void NoFakturKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_NoFakturKeyPressed if(evt.getKeyCode()==KeyEvent.VK_PAGE_DOWN){ cariBatch(); }else if(evt.getKeyCode()==KeyEvent.VK_PAGE_UP){ cariBatch(); Kdbar.requestFocus(); }else if(evt.getKeyCode()==KeyEvent.VK_ENTER){ cariBatch(); Jmlretur.requestFocus(); } }//GEN-LAST:event_NoFakturKeyPressed /** * @param args the command line arguments */ public static void main(String args[]) { java.awt.EventQueue.invokeLater(() -> { DlgReturJual dialog = new DlgReturJual(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 BtnBatal; private widget.Button BtnBrg; private widget.Button BtnCari; private widget.Button BtnGudang; private widget.Button BtnHapus; private widget.Button BtnKeluar; private widget.Button BtnMmb; private widget.Button BtnPtg; private widget.Button BtnSimpan; private widget.Button BtnTambah; private widget.TextBox Hargaretur; private widget.ComboBox Jenisjual; private widget.TextBox Jmlretur; private widget.TextBox Kd2; private widget.TextBox Kdbar; private widget.TextBox Kdptg; private widget.Label LTotal; private widget.TextBox Nmptg; private widget.TextBox NoBatch; private widget.TextBox NoFaktur; private widget.TextBox NoNota; private widget.TextBox NoRetur; private javax.swing.JPopupMenu Popup; private widget.TextBox Satuanbar; private widget.TextBox Subtotal; private widget.Tanggal TglRetur; private widget.InternalFrame internalFrame1; private javax.swing.JPanel jPanel1; private widget.TextBox kdgudang; private widget.TextBox kdmem; private widget.Label label11; private widget.Label label12; private widget.Label label13; private widget.Label label15; private widget.Label label16; private widget.Label label17; private widget.Label label18; private widget.Label label21; private widget.Label label23; private widget.Label label25; private widget.Label label26; private widget.Label label27; private widget.Label label32; private widget.Label label9; private widget.TextBox nmbar; private widget.TextBox nmgudang; private widget.TextBox nmmem; private widget.panelisi panelisi1; private widget.panelisi panelisi4; private widget.panelisi panelisiBeli; private javax.swing.JMenuItem ppCetakNota; private widget.ScrollPane scrollPane1; private widget.Table tbDokter; // End of variables declaration//GEN-END:variables private void tampil() { Valid.tabelKosong(tabMode); try{ ps=koneksi.prepareStatement("select nota_jual, kode_brng, nama_brng, satuan, h_jual, jml_jual, h_retur, jml_retur, subtotal,no_batch,no_faktur from tampreturjual where petugas=? "); try { ps.setString(1,akses.getkode()); rs=ps.executeQuery(); ttlretur=0; while(rs.next()){ ttlretur=ttlretur+rs.getDouble(9); tabMode.addRow(new Object[]{ rs.getString(1),rs.getString(2),rs.getString(3), rs.getString(4),rs.getDouble(7), rs.getDouble(8),rs.getDouble(9), rs.getString(10),rs.getString(11) }); } LTotal.setText(Valid.SetAngka(ttlretur)); } 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); } } public void emptTeks() { Kdbar.setText(""); nmbar.setText(""); Satuanbar.setText(""); Hargaretur.setText("0"); Jmlretur.setText(""); Subtotal.setText("0"); NoBatch.setText(""); NoFaktur.setText(""); Kdbar.requestFocus(); } private void getData() { int row=tbDokter.getSelectedRow(); if(row!= -1){ NoNota.setText(tabMode.getValueAt(row,0).toString()); Kdbar.setText(tabMode.getValueAt(row,1).toString()); nmbar.setText(tabMode.getValueAt(row,2).toString()); Satuanbar.setText(tabMode.getValueAt(row,3).toString()); Hargaretur.setText(tabMode.getValueAt(row,4).toString()); Jmlretur.setText(tabMode.getValueAt(row,5).toString()); NoBatch.setText(tabMode.getValueAt(row,7).toString()); NoFaktur.setText(tabMode.getValueAt(row,8).toString()); isHitung(); } } private void isHitung(){ if((!Jmlretur.getText().equals(""))&&(!Hargaretur.getText().equals(""))){ Subtotal.setText(Double.toString( Double.parseDouble(Jmlretur.getText())* Double.parseDouble(Hargaretur.getText()) )); }else{ Subtotal.setText("0"); } } public void isCek(){ autonomor(); Sequel.cariIsi("select set_lokasi.kd_bangsal from set_lokasi",kdgudang); nmgudang.setText(bangsal.tampil3(kdgudang.getText())); if(akses.getjml2()>=1){ Kdptg.setEditable(false); BtnPtg.setEnabled(false); BtnSimpan.setEnabled(akses.getretur_dari_pembeli()); BtnTambah.setEnabled(akses.getretur_dari_pembeli()); BtnHapus.setEnabled(akses.getretur_dari_pembeli()); BtnBatal.setEnabled(akses.getretur_dari_pembeli()); Kdptg.setText(akses.getkode()); Nmptg.setText(form.petugas.tampil3(Kdptg.getText())); } } public void setPasien(String norm,String norawat){ kdmem.setText(norm); this.norawat=norawat; Valid.autoNomer3("select ifnull(MAX(CONVERT(RIGHT(no_retur_jual,2),signed)),0) from returjual where no_retur_jual like '%"+norawat+"%' ",norawat,2,NoRetur); formvalid="No"; Sequel.cariIsi("select pasien.nm_pasien from pasien where pasien.no_rkm_medis=?",nmmem,kdmem.getText()); kdgudang.setText(akses.getkdbangsal()); nmgudang.setText(bangsal.tampil3(kdgudang.getText())); } private void cariBatch() { try { ps=koneksi.prepareStatement( "select * from data_batch where data_batch.no_batch=? and data_batch.kode_brng=? and data_batch.no_faktur=?"); try { ps.setString(1,NoBatch.getText()); ps.setString(2,Kdbar.getText()); ps.setString(3,NoFaktur.getText()); rs=ps.executeQuery(); if(rs.next()){ if(Jenisjual.getSelectedItem().equals("Karyawan")){ Hargaretur.setText(rs.getString("karyawan")); }else if(Jenisjual.getSelectedItem().equals("Jual Bebas")){ Hargaretur.setText(rs.getString("jualbebas")); }else if(Jenisjual.getSelectedItem().equals("Beli Luar")){ Hargaretur.setText(rs.getString("beliluar")); }else if(Jenisjual.getSelectedItem().equals("Rawat Jalan")){ Hargaretur.setText(rs.getString("ralan")); }else if(Jenisjual.getSelectedItem().equals("Kelas 1")){ Hargaretur.setText(rs.getString("kelas1")); }else if(Jenisjual.getSelectedItem().equals("Kelas 2")){ Hargaretur.setText(rs.getString("kelas2")); }else if(Jenisjual.getSelectedItem().equals("Kelas 3")){ Hargaretur.setText(rs.getString("kelas3")); }else if(Jenisjual.getSelectedItem().equals("Utama/BPJS")){ Hargaretur.setText(rs.getString("utama")); }else if(Jenisjual.getSelectedItem().equals("VIP")){ Hargaretur.setText(rs.getString("vip")); }else if(Jenisjual.getSelectedItem().equals("VVIP")){ Hargaretur.setText(rs.getString("vvip")); }else if(Jenisjual.getSelectedItem().equals("Harga Beli")){ Hargaretur.setText(rs.getString("h_beli")); } } } 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("Notif : "+e); } } private void autonomor() { if(!formvalid.equals("No")){ Valid.autoNomer3("select ifnull(MAX(CONVERT(RIGHT(no_retur_jual,3),signed)),0) from returjual where tgl_retur='"+Valid.SetTgl(TglRetur.getSelectedItem()+"")+"' ", "RJ"+TglRetur.getSelectedItem().toString().substring(6,10)+TglRetur.getSelectedItem().toString().substring(3,5)+TglRetur.getSelectedItem().toString().substring(0,2),3,NoRetur); }else{ Valid.autoNomer3("select ifnull(MAX(CONVERT(RIGHT(no_retur_jual,2),signed)),0) from returjual where no_retur_jual like '%"+norawat+"%' ",norawat,2,NoRetur); } } private void simpan() { try { ps=koneksi.prepareStatement("select nota_jual, kode_brng, satuan, jml_jual, h_jual, jml_retur, h_retur,subtotal,no_batch,no_faktur from tampreturjual where petugas=?"); try { ps.setString(1,akses.getkode()); rs=ps.executeQuery(); while(rs.next()){ if(Sequel.menyimpantf2("detreturjual","?,?,?,?,?,?,?,?,?,?,?","data barang sama",11,new String[]{ NoRetur.getText(),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) })==true){ if(aktifkanbatch.equals("yes")){ Sequel.mengedit("data_batch","no_batch=? and kode_brng=? and no_faktur=?","sisa=sisa+?",4,new String[]{ rs.getString(6),rs.getString(9),rs.getString(2),rs.getString(10) }); Trackobat.catatRiwayat(rs.getString(2),rs.getDouble(6),0,"Retur Jual",akses.getkode(),kdgudang.getText(),"Simpan",rs.getString(9),rs.getString(10),NoRetur.getText()+" "+kdmem.getText()+" "+nmmem.getText()); Sequel.menyimpan("gudangbarang","'"+rs.getString(2)+"','"+kdgudang.getText()+"','"+rs.getString(6)+"','"+rs.getString(9)+"','"+rs.getString(10)+"'", "stok=stok+'"+rs.getString(6)+"'","kode_brng='"+rs.getString(2)+"' and kd_bangsal='"+kdgudang.getText()+"' and no_batch='"+rs.getString(9)+"' and no_faktur='"+rs.getString(10)+"'"); }else{ Trackobat.catatRiwayat(rs.getString(2),rs.getDouble(6),0,"Retur Jual",akses.getkode(),kdgudang.getText(),"Simpan","","",NoRetur.getText()+" "+kdmem.getText()+" "+nmmem.getText()); Sequel.menyimpan("gudangbarang","'"+rs.getString(2)+"','"+kdgudang.getText()+"','"+rs.getString(6)+"','',''", "stok=stok+'"+rs.getString(6)+"'","kode_brng='"+rs.getString(2)+"' and kd_bangsal='"+kdgudang.getText()+"' and no_batch='' and no_faktur=''"); } }else{ sukses=false; } } } catch (Exception e) { System.out.println("Notif Tampil Temp : "+e); } finally{ if(rs!=null){ rs.close(); } if(ps!=null){ ps.close(); } } } catch (Exception e) { System.out.println("Notifikasi Tampil : "+e); } } }