package inventory; import com.fasterxml.jackson.databind.JsonNode; import com.fasterxml.jackson.databind.ObjectMapper; 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.Desktop; 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.io.BufferedWriter; import java.io.File; import java.io.FileReader; import java.io.FileWriter; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.text.DecimalFormat; import java.util.HashMap; import java.util.Map; import javax.swing.JOptionPane; import javax.swing.JTable; import javax.swing.event.DocumentEvent; import javax.swing.table.DefaultTableModel; import javax.swing.table.TableColumn; import javax.swing.text.Document; import javax.swing.text.html.HTMLEditorKit; import javax.swing.text.html.StyleSheet; import keuangan.Jurnal; import kepegawaian.DlgCariPetugas; import simrskhanza.DlgCariPasien; public class DlgCariPenjualan extends javax.swing.JDialog { private final DefaultTableModel tabMode; private sekuel Sequel=new sekuel(); private validasi Valid=new validasi(); private PreparedStatement ps,ps2,ps3,pscarijual,psdetailjual; private ResultSet rs,rs2,rs3; private Jurnal jur=new Jurnal(); private Connection koneksi=koneksiDB.condb(); private riwayatobat Trackobat=new riwayatobat(); private int i=0,no=1; public DlgCariPasien pasien=new DlgCariPasien(null,false); public DlgCariPetugas petugas=new DlgCariPetugas(null,false); public DlgBarang barang=new DlgBarang(null,false); private DecimalFormat df2 = new DecimalFormat("###,###,###,###,###,###,###"); private double ttljual=0,ttlppn=0,ttlongkir=0,ttldisc=0,ttltambahan=0,ttlembalase=0,ttltuslah=0,ttlsubttl=0,subttljual=0,subttldisc=0,subttlall=0,subttltambahan=0,subttlembalase=0,subttltuslah=0,ttlhpp=0; private String totaljual="",notapenjualan="No",verifikasi_penjualan_di_kasir="",statusbayar="",datacari="", nofak="",mem="",ptg="",sat="",bar="",tanggal="",Penjualan_Obat="",HPP_Obat_Jual_Bebas="",Persediaan_Obat_Jual_Bebas="",PPN_Keluaran=""; private String aktifkanbatch="no",kdrek=""; private boolean sukses=true; private File file; private FileWriter fileWriter; private ObjectMapper mapper = new ObjectMapper(); private JsonNode root; private JsonNode response; private FileReader myObj; /** Creates new form DlgProgramStudi * @param parent * @param modal */ public DlgCariPenjualan(java.awt.Frame parent, boolean modal) { super(parent, modal); initComponents(); try { aktifkanbatch = koneksiDB.AKTIFKANBATCHOBAT(); } catch (Exception e) { System.out.println("E : "+e); aktifkanbatch = "no"; } Object[] row={"No.Nota","Tanggal","Petugas","Pasien","Keterangan","Jns.Jual","PPN Obat","Asal Stok","","","","","","Ongkos Kirim","Akun Bayar"}; tabMode=new DefaultTableModel(null,row){ @Override public boolean isCellEditable(int rowIndex, int colIndex){return false;} }; tbDokter.setModel(tabMode); tbDokter.setPreferredScrollableViewportSize(new Dimension(800,800)); tbDokter.setAutoResizeMode(JTable.AUTO_RESIZE_OFF); for (i = 0; i < 15; i++) { TableColumn column = tbDokter.getColumnModel().getColumn(i); if(i==0){ column.setPreferredWidth(90); }else if(i==1){ column.setPreferredWidth(80); }else if(i==2){ column.setPreferredWidth(170); }else if(i==3){ column.setPreferredWidth(250); }else if(i==4){ column.setPreferredWidth(70); }else if(i==5){ column.setPreferredWidth(100); }else if(i==6){ column.setPreferredWidth(70); }else if(i==7){ column.setPreferredWidth(100); }else if(i==8){ column.setPreferredWidth(45); }else if(i==9){ column.setPreferredWidth(75); }else if(i==10){ column.setPreferredWidth(75); }else if(i==11){ column.setPreferredWidth(75); }else if(i==12){ column.setPreferredWidth(75); }else if(i==13){ column.setPreferredWidth(100); }else if(i==14){ column.setPreferredWidth(130); } } tbDokter.setDefaultRenderer(Object.class, new WarnaTable()); NoNota.setDocument(new batasInput((byte)25).getKata(NoNota)); kdmem.setDocument(new batasInput((byte)15).getKata(kdmem)); nmmem.setDocument(new batasInput((byte)70).getKata(nmmem)); kdptg.setDocument(new batasInput((byte)25).getKata(kdptg)); kdbar.setDocument(new batasInput((byte)15).getKata(kdbar)); kdsat.setDocument(new batasInput((byte)3).getKata(kdsat)); TCari.setDocument(new batasInput((byte)100).getKata(TCari)); if(koneksiDB.CARICEPAT().equals("aktif")){ TCari.getDocument().addDocumentListener(new javax.swing.event.DocumentListener(){ @Override public void insertUpdate(DocumentEvent e) { if(TCari.getText().length()>2){ tampil(); } } @Override public void removeUpdate(DocumentEvent e) { if(TCari.getText().length()>2){ tampil(); } } @Override public void changedUpdate(DocumentEvent e) { if(TCari.getText().length()>2){ tampil(); } } }); } 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("DlgCariPenjualan")){ if(pasien.getTable().getSelectedRow()!= -1){ kdmem.setText(pasien.getTable().getValueAt(pasien.getTable().getSelectedRow(),0).toString()); nmmem.setText(pasien.getTable().getValueAt(pasien.getTable().getSelectedRow(),1).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) {} }); pasien.getTable().addKeyListener(new KeyListener() { @Override public void keyTyped(KeyEvent e) {} @Override public void keyPressed(KeyEvent e) { if(akses.getform().equals("DlgCariPenjualan")){ if(e.getKeyCode()==KeyEvent.VK_SPACE){ pasien.dispose(); } } } @Override public void keyReleased(KeyEvent e) {} }); 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("DlgCariPenjualan")){ if(petugas.getTable().getSelectedRow()!= -1){ kdptg.setText(petugas.getTable().getValueAt(petugas.getTable().getSelectedRow(),0).toString()); nmptg.setText(petugas.getTable().getValueAt(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) {} }); 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("DlgCariPenjualan")){ if(barang.getTable().getSelectedRow()!= -1){ kdbar.setText(barang.getTable().getValueAt(barang.getTable().getSelectedRow(),1).toString()); nmbar.setText(barang.getTable().getValueAt(barang.getTable().getSelectedRow(),2).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) {} }); barang.getTable().addKeyListener(new KeyListener() { @Override public void keyTyped(KeyEvent e) {} @Override public void keyPressed(KeyEvent e) { if(akses.getform().equals("DlgCariPenjualan")){ if(e.getKeyCode()==KeyEvent.VK_SPACE){ barang.dispose(); } } } @Override public void keyReleased(KeyEvent e) {} }); barang.jenis.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("DlgCariPenjualan")){ if(barang.jenis.getTable().getSelectedRow()!= -1){ kdsat.setText(barang.jenis.getTable().getValueAt(barang.jenis.getTable().getSelectedRow(),0).toString()); nmsat.setText(barang.jenis.getTable().getValueAt(barang.jenis.getTable().getSelectedRow(),1).toString()); } kdsat.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) {} }); try { ps=koneksi.prepareStatement("select set_nota.cetaknotasimpanpenjualan,set_nota.verifikasi_penjualan_di_kasir from set_nota"); try { rs=ps.executeQuery(); if(rs.next()){ notapenjualan=rs.getString("cetaknotasimpanpenjualan"); verifikasi_penjualan_di_kasir=rs.getString("verifikasi_penjualan_di_kasir"); } } catch (Exception e) { System.out.println("Notif : "+e); } finally{ if(rs!=null){ rs.close(); } if(ps!=null){ ps.close(); } } if(notapenjualan.equals("")){ notapenjualan="No"; } if(verifikasi_penjualan_di_kasir.equals("Yes")){ ppVerif.setVisible(true); }else{ ppVerif.setVisible(false); } } catch (Exception e) { System.out.println("Notif : "+e); notapenjualan="No"; } try { ps=koneksi.prepareStatement("select set_akun.Penjualan_Obat,set_akun.HPP_Obat_Jual_Bebas,set_akun.Persediaan_Obat_Jual_Bebas,set_akun.PPN_Keluaran from set_akun"); try { rs=ps.executeQuery(); if(rs.next()){ Penjualan_Obat=rs.getString("Penjualan_Obat"); HPP_Obat_Jual_Bebas=rs.getString("HPP_Obat_Jual_Bebas"); Persediaan_Obat_Jual_Bebas=rs.getString("Persediaan_Obat_Jual_Bebas"); PPN_Keluaran=rs.getString("PPN_Keluaran"); } } 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); } HTMLEditorKit kit = new HTMLEditorKit(); LoadHTML1.setEditable(true); LoadHTML1.setEditorKit(kit); StyleSheet styleSheet = kit.getStyleSheet(); styleSheet.addRule( ".isi td{border-right: 1px solid #e2e7dd;font: 8.5px tahoma;height:12px;border-bottom: 1px solid #e2e7dd;background: #ffffff;color:#323232;}"+ ".head td{border-right: 1px solid #777777;font: 8.5px tahoma;height:10px;border-bottom: 1px solid #e2e7dd;background: #ffffff;color:#323232;}"+ ".isi a{text-decoration:none;color:#8b9b95;padding:0 0 0 0px;font-family: Tahoma;font-size: 8.5px;}"+ ".isi2 td{font: 8.5px tahoma;height:12px;background: #ffffff;color:#323232;}"+ ".isi3 td{border-right: 1px solid #e2e7dd;font: 8.5px tahoma;height:12px;border-top: 1px solid #e2e7dd;background: #ffffff;color:#323232;}"+ ".isi4 td{font: 11px tahoma;height:12px;border-top: 1px solid #e2e7dd;background: #ffffff;color:#323232;}" ); Document doc = kit.createDefaultDocument(); LoadHTML1.setDocument(doc); LoadHTML1.setEditable(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() { jPopupMenu1 = new javax.swing.JPopupMenu(); ppCetakNota = new javax.swing.JMenuItem(); ppHapus = new javax.swing.JMenuItem(); ppVerif = new javax.swing.JMenuItem(); ppResepObat = new javax.swing.JMenuItem(); ppResepObat1 = new javax.swing.JMenuItem(); ppResepObat2 = new javax.swing.JMenuItem(); WindowGantiCaraBayar = new javax.swing.JDialog(); internalFrame5 = new widget.InternalFrame(); BtnCloseIn4 = new widget.Button(); BtnSimpan4 = new widget.Button(); jLabel10 = new widget.Label(); AkunBayar = new widget.ComboBox(); BtnAll1 = new widget.Button(); internalFrame1 = new widget.InternalFrame(); jPanel1 = new javax.swing.JPanel(); panelisi4 = new widget.panelisi(); label17 = new widget.Label(); kdbar = new widget.TextBox(); nmbar = new widget.TextBox(); btnBarang = new widget.Button(); label24 = new widget.Label(); kdsat = new widget.TextBox(); btnSatuan = new widget.Button(); nmsat = new widget.TextBox(); label14 = new widget.Label(); Status = new widget.ComboBox(); panelisi1 = new widget.panelisi(); label10 = new widget.Label(); TCari = new widget.TextBox(); BtnCari = new widget.Button(); label9 = new widget.Label(); LTotal = new widget.Label(); BtnAll = new widget.Button(); BtnPrint = new widget.Button(); BtnKeluar = new widget.Button(); panelisi3 = new widget.panelisi(); label15 = new widget.Label(); NoNota = new widget.TextBox(); label11 = new widget.Label(); Tgl1 = new widget.Tanggal(); label16 = new widget.Label(); label13 = new widget.Label(); kdmem = new widget.TextBox(); kdptg = new widget.TextBox(); nmmem = new widget.TextBox(); nmptg = new widget.TextBox(); btnPasien = new widget.Button(); btnPetugas = new widget.Button(); label18 = new widget.Label(); Tgl2 = new widget.Tanggal(); TabRawat = new javax.swing.JTabbedPane(); scrollPane1 = new widget.ScrollPane(); tbDokter = new widget.Table(); Scroll = new widget.ScrollPane(); LoadHTML1 = new widget.editorpane(); jPopupMenu1.setName("jPopupMenu1"); // 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/category.png"))); // NOI18N ppCetakNota.setText("Cetak Ulang Nota"); ppCetakNota.setHorizontalAlignment(javax.swing.SwingConstants.LEFT); ppCetakNota.setHorizontalTextPosition(javax.swing.SwingConstants.RIGHT); ppCetakNota.setName("ppCetakNota"); // NOI18N ppCetakNota.setPreferredSize(new java.awt.Dimension(190, 25)); ppCetakNota.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { ppCetakNotaActionPerformed(evt); } }); jPopupMenu1.add(ppCetakNota); ppHapus.setBackground(new java.awt.Color(255, 255, 254)); ppHapus.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N ppHapus.setForeground(new java.awt.Color(50, 50, 50)); ppHapus.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/category.png"))); // NOI18N ppHapus.setText("Hapus Penjualan"); ppHapus.setHorizontalAlignment(javax.swing.SwingConstants.LEFT); ppHapus.setHorizontalTextPosition(javax.swing.SwingConstants.RIGHT); ppHapus.setName("ppHapus"); // NOI18N ppHapus.setPreferredSize(new java.awt.Dimension(190, 25)); ppHapus.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { ppHapusActionPerformed(evt); } }); jPopupMenu1.add(ppHapus); ppVerif.setBackground(new java.awt.Color(255, 255, 254)); ppVerif.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N ppVerif.setForeground(new java.awt.Color(50, 50, 50)); ppVerif.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/category.png"))); // NOI18N ppVerif.setText("Verifikasi"); ppVerif.setHorizontalAlignment(javax.swing.SwingConstants.LEFT); ppVerif.setHorizontalTextPosition(javax.swing.SwingConstants.RIGHT); ppVerif.setName("ppVerif"); // NOI18N ppVerif.setPreferredSize(new java.awt.Dimension(190, 25)); ppVerif.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { ppVerifActionPerformed(evt); } }); jPopupMenu1.add(ppVerif); 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("Cetak Aturan Pakai Model 1"); ppResepObat.setHorizontalAlignment(javax.swing.SwingConstants.LEFT); ppResepObat.setHorizontalTextPosition(javax.swing.SwingConstants.RIGHT); ppResepObat.setName("ppResepObat"); // NOI18N ppResepObat.setPreferredSize(new java.awt.Dimension(190, 25)); ppResepObat.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { ppResepObatActionPerformed(evt); } }); jPopupMenu1.add(ppResepObat); ppResepObat1.setBackground(new java.awt.Color(255, 255, 254)); ppResepObat1.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N ppResepObat1.setForeground(new java.awt.Color(50, 50, 50)); ppResepObat1.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/category.png"))); // NOI18N ppResepObat1.setText("Cetak Aturan Pakai Model 2"); ppResepObat1.setHorizontalAlignment(javax.swing.SwingConstants.LEFT); ppResepObat1.setHorizontalTextPosition(javax.swing.SwingConstants.RIGHT); ppResepObat1.setName("ppResepObat1"); // NOI18N ppResepObat1.setPreferredSize(new java.awt.Dimension(190, 25)); ppResepObat1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { ppResepObat1ActionPerformed(evt); } }); jPopupMenu1.add(ppResepObat1); ppResepObat2.setBackground(new java.awt.Color(255, 255, 254)); ppResepObat2.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N ppResepObat2.setForeground(new java.awt.Color(50, 50, 50)); ppResepObat2.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/category.png"))); // NOI18N ppResepObat2.setText("Cetak Aturan Pakai Model 3"); ppResepObat2.setHorizontalAlignment(javax.swing.SwingConstants.LEFT); ppResepObat2.setHorizontalTextPosition(javax.swing.SwingConstants.RIGHT); ppResepObat2.setName("ppResepObat2"); // NOI18N ppResepObat2.setPreferredSize(new java.awt.Dimension(190, 25)); ppResepObat2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { ppResepObat2ActionPerformed(evt); } }); jPopupMenu1.add(ppResepObat2); WindowGantiCaraBayar.setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE); WindowGantiCaraBayar.setName("WindowGantiCaraBayar"); // NOI18N WindowGantiCaraBayar.setUndecorated(true); WindowGantiCaraBayar.setResizable(false); internalFrame5.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(240, 245, 235)), "::[ Akun Bayar ]::", 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 internalFrame5.setName("internalFrame5"); // NOI18N internalFrame5.setLayout(null); BtnCloseIn4.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/cross.png"))); // NOI18N BtnCloseIn4.setMnemonic('U'); BtnCloseIn4.setText("Tutup"); BtnCloseIn4.setToolTipText("Alt+U"); BtnCloseIn4.setName("BtnCloseIn4"); // NOI18N BtnCloseIn4.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { BtnCloseIn4ActionPerformed(evt); } }); internalFrame5.add(BtnCloseIn4); BtnCloseIn4.setBounds(510, 30, 100, 30); BtnSimpan4.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/save-16x16.png"))); // NOI18N BtnSimpan4.setMnemonic('S'); BtnSimpan4.setText("Simpan"); BtnSimpan4.setToolTipText("Alt+S"); BtnSimpan4.setName("BtnSimpan4"); // NOI18N BtnSimpan4.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { BtnSimpan4ActionPerformed(evt); } }); internalFrame5.add(BtnSimpan4); BtnSimpan4.setBounds(405, 30, 100, 30); jLabel10.setText("Akun Bayar :"); jLabel10.setName("jLabel10"); // NOI18N internalFrame5.add(jLabel10); jLabel10.setBounds(0, 32, 80, 23); AkunBayar.setName("AkunBayar"); // NOI18N internalFrame5.add(AkunBayar); AkunBayar.setBounds(84, 32, 272, 23); BtnAll1.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/refresh.png"))); // NOI18N BtnAll1.setMnemonic('M'); BtnAll1.setToolTipText("Alt+M"); BtnAll1.setName("BtnAll1"); // NOI18N BtnAll1.setPreferredSize(new java.awt.Dimension(28, 23)); BtnAll1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { BtnAll1ActionPerformed(evt); } }); internalFrame5.add(BtnAll1); BtnAll1.setBounds(360, 32, 27, 23); WindowGantiCaraBayar.getContentPane().add(internalFrame5, java.awt.BorderLayout.CENTER); 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)), "::[ Cari Penjualan Obat, Alkes & BHP Medis ]::", 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)); jPanel1.setName("jPanel1"); // NOI18N jPanel1.setOpaque(false); jPanel1.setPreferredSize(new java.awt.Dimension(816, 100)); jPanel1.setLayout(new java.awt.BorderLayout(1, 1)); panelisi4.setName("panelisi4"); // NOI18N panelisi4.setPreferredSize(new java.awt.Dimension(100, 44)); panelisi4.setLayout(null); label17.setText("Barang :"); label17.setName("label17"); // NOI18N label17.setPreferredSize(new java.awt.Dimension(65, 23)); panelisi4.add(label17); label17.setBounds(445, 10, 50, 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(499, 10, 100, 23); nmbar.setEditable(false); nmbar.setName("nmbar"); // NOI18N nmbar.setPreferredSize(new java.awt.Dimension(207, 23)); panelisi4.add(nmbar); nmbar.setBounds(601, 10, 170, 23); btnBarang.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/190.png"))); // NOI18N btnBarang.setMnemonic('4'); btnBarang.setToolTipText("Alt+4"); btnBarang.setName("btnBarang"); // NOI18N btnBarang.setPreferredSize(new java.awt.Dimension(28, 23)); btnBarang.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { btnBarangActionPerformed(evt); } }); panelisi4.add(btnBarang); btnBarang.setBounds(774, 10, 28, 23); label24.setText("Jenis :"); label24.setName("label24"); // NOI18N label24.setPreferredSize(new java.awt.Dimension(68, 23)); panelisi4.add(label24); label24.setBounds(187, 10, 40, 23); kdsat.setName("kdsat"); // NOI18N kdsat.setPreferredSize(new java.awt.Dimension(80, 23)); kdsat.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { kdsatKeyPressed(evt); } }); panelisi4.add(kdsat); kdsat.setBounds(232, 10, 53, 23); btnSatuan.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/190.png"))); // NOI18N btnSatuan.setMnemonic('3'); btnSatuan.setToolTipText("Alt+3"); btnSatuan.setName("btnSatuan"); // NOI18N btnSatuan.setPreferredSize(new java.awt.Dimension(28, 23)); btnSatuan.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { btnSatuanActionPerformed(evt); } }); panelisi4.add(btnSatuan); btnSatuan.setBounds(406, 10, 28, 23); nmsat.setName("nmsat"); // NOI18N nmsat.setPreferredSize(new java.awt.Dimension(80, 23)); nmsat.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { nmsatKeyPressed(evt); } }); panelisi4.add(nmsat); nmsat.setBounds(287, 10, 116, 23); label14.setText("Status :"); label14.setName("label14"); // NOI18N label14.setPreferredSize(new java.awt.Dimension(70, 23)); panelisi4.add(label14); label14.setBounds(0, 10, 53, 23); Status.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Semua", "Belum Dibayar", "Sudah Dibayar" })); Status.setName("Status"); // NOI18N Status.setPreferredSize(new java.awt.Dimension(40, 23)); panelisi4.add(Status); Status.setBounds(58, 10, 120, 23); jPanel1.add(panelisi4, java.awt.BorderLayout.CENTER); panelisi1.setName("panelisi1"); // NOI18N panelisi1.setPreferredSize(new java.awt.Dimension(100, 56)); panelisi1.setLayout(new java.awt.FlowLayout(java.awt.FlowLayout.LEFT, 5, 9)); label10.setText("Key Word :"); label10.setName("label10"); // NOI18N label10.setPreferredSize(new java.awt.Dimension(60, 23)); panelisi1.add(label10); TCari.setName("TCari"); // NOI18N TCari.setPreferredSize(new java.awt.Dimension(180, 23)); TCari.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { TCariKeyPressed(evt); } }); panelisi1.add(TCari); BtnCari.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/accept.png"))); // NOI18N BtnCari.setMnemonic('5'); BtnCari.setToolTipText("Alt+5"); 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); } }); panelisi1.add(BtnCari); label9.setText("Total :"); label9.setName("label9"); // NOI18N label9.setPreferredSize(new java.awt.Dimension(55, 30)); panelisi1.add(label9); LTotal.setHorizontalAlignment(javax.swing.SwingConstants.LEFT); LTotal.setText("0"); LTotal.setName("LTotal"); // NOI18N LTotal.setPreferredSize(new java.awt.Dimension(155, 30)); panelisi1.add(LTotal); 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); } }); panelisi1.add(BtnAll); 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); } }); panelisi1.add(BtnPrint); 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); internalFrame1.add(jPanel1, java.awt.BorderLayout.PAGE_END); panelisi3.setName("panelisi3"); // NOI18N panelisi3.setPreferredSize(new java.awt.Dimension(100, 73)); panelisi3.setLayout(null); label15.setText("No.Nota :"); label15.setName("label15"); // NOI18N label15.setPreferredSize(new java.awt.Dimension(60, 23)); panelisi3.add(label15); label15.setBounds(0, 10, 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); } }); panelisi3.add(NoNota); NoNota.setBounds(74, 10, 211, 23); label11.setText("Tanggal :"); label11.setName("label11"); // NOI18N label11.setPreferredSize(new java.awt.Dimension(70, 23)); panelisi3.add(label11); label11.setBounds(0, 40, 70, 23); Tgl1.setDisplayFormat("dd-MM-yyyy"); Tgl1.setName("Tgl1"); // NOI18N Tgl1.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { Tgl1KeyPressed(evt); } }); panelisi3.add(Tgl1); Tgl1.setBounds(74, 40, 90, 23); label16.setText("Pasien :"); label16.setName("label16"); // NOI18N label16.setPreferredSize(new java.awt.Dimension(60, 23)); panelisi3.add(label16); label16.setBounds(335, 10, 60, 23); label13.setText("Petugas :"); label13.setName("label13"); // NOI18N label13.setPreferredSize(new java.awt.Dimension(70, 23)); panelisi3.add(label13); label13.setBounds(335, 40, 60, 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); } }); panelisi3.add(kdmem); kdmem.setBounds(399, 10, 120, 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); } }); panelisi3.add(kdptg); kdptg.setBounds(399, 40, 120, 23); nmmem.setName("nmmem"); // NOI18N nmmem.setPreferredSize(new java.awt.Dimension(207, 23)); panelisi3.add(nmmem); nmmem.setBounds(521, 10, 250, 23); nmptg.setEditable(false); nmptg.setName("nmptg"); // NOI18N nmptg.setPreferredSize(new java.awt.Dimension(207, 23)); panelisi3.add(nmptg); nmptg.setBounds(521, 40, 250, 23); btnPasien.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/190.png"))); // NOI18N btnPasien.setMnemonic('1'); btnPasien.setToolTipText("Alt+1"); btnPasien.setName("btnPasien"); // NOI18N btnPasien.setPreferredSize(new java.awt.Dimension(28, 23)); btnPasien.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { btnPasienActionPerformed(evt); } }); panelisi3.add(btnPasien); btnPasien.setBounds(774, 10, 28, 23); btnPetugas.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/190.png"))); // NOI18N btnPetugas.setMnemonic('2'); btnPetugas.setToolTipText("Alt+2"); btnPetugas.setName("btnPetugas"); // NOI18N btnPetugas.setPreferredSize(new java.awt.Dimension(28, 23)); btnPetugas.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { btnPetugasActionPerformed(evt); } }); panelisi3.add(btnPetugas); btnPetugas.setBounds(774, 40, 28, 23); label18.setHorizontalAlignment(javax.swing.SwingConstants.CENTER); label18.setText("s.d."); label18.setName("label18"); // NOI18N label18.setPreferredSize(new java.awt.Dimension(70, 23)); panelisi3.add(label18); label18.setBounds(163, 40, 30, 23); Tgl2.setDisplayFormat("dd-MM-yyyy"); Tgl2.setName("Tgl2"); // NOI18N Tgl2.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { Tgl2KeyPressed(evt); } }); panelisi3.add(Tgl2); Tgl2.setBounds(195, 40, 90, 23); internalFrame1.add(panelisi3, java.awt.BorderLayout.PAGE_START); TabRawat.setBackground(new java.awt.Color(255, 255, 253)); TabRawat.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(241, 246, 236))); TabRawat.setForeground(new java.awt.Color(50, 50, 50)); TabRawat.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N TabRawat.setName("TabRawat"); // NOI18N TabRawat.addMouseListener(new java.awt.event.MouseAdapter() { public void mouseClicked(java.awt.event.MouseEvent evt) { TabRawatMouseClicked(evt); } }); scrollPane1.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(255, 255, 255))); scrollPane1.setComponentPopupMenu(jPopupMenu1); scrollPane1.setName("scrollPane1"); // NOI18N scrollPane1.setOpaque(true); tbDokter.setModel(new javax.swing.table.DefaultTableModel( new Object [][] { {}, {}, {}, {} }, new String [] { } )); tbDokter.setToolTipText("Silahkan klik untuk memilih data yang mau diedit ataupun dihapus"); tbDokter.setComponentPopupMenu(jPopupMenu1); tbDokter.setName("tbDokter"); // NOI18N scrollPane1.setViewportView(tbDokter); TabRawat.addTab("Laporan 1", scrollPane1); Scroll.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(255, 255, 255))); Scroll.setName("Scroll"); // NOI18N Scroll.setOpaque(true); LoadHTML1.setBorder(null); LoadHTML1.setName("LoadHTML1"); // NOI18N Scroll.setViewportView(LoadHTML1); TabRawat.addTab("Laporan 2", Scroll); internalFrame1.add(TabRawat, java.awt.BorderLayout.CENTER); getContentPane().add(internalFrame1, java.awt.BorderLayout.CENTER); pack(); }// //GEN-END:initComponents /* private void KdKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_TKdKeyPressed Valid.pindah(evt,BtnCari,Nm); }//GEN-LAST:event_TKdKeyPressed */ private void btnPasienActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnPasienActionPerformed akses.setform("DlgCariPenjualan"); pasien.emptTeks(); pasien.isCek(); pasien.setSize(internalFrame1.getWidth()-20,internalFrame1.getHeight()-20); pasien.setLocationRelativeTo(internalFrame1); pasien.setAlwaysOnTop(false); pasien.setVisible(true); }//GEN-LAST:event_btnPasienActionPerformed private void btnPetugasActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnPetugasActionPerformed akses.setform("DlgCariPenjualan"); petugas.emptTeks(); petugas.isCek(); petugas.setSize(internalFrame1.getWidth()-20,internalFrame1.getHeight()-20); petugas.setLocationRelativeTo(internalFrame1); petugas.setAlwaysOnTop(false); petugas.setVisible(true); }//GEN-LAST:event_btnPetugasActionPerformed private void Tgl1KeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_Tgl1KeyPressed Valid.pindah(evt,kdmem,Tgl2); }//GEN-LAST:event_Tgl1KeyPressed 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()); NoNota.requestFocus(); }else if(evt.getKeyCode()==KeyEvent.VK_ENTER){ Sequel.cariIsi("select pasien.nm_pasien from pasien where pasien.no_rkm_medis=?", nmmem,kdmem.getText()); Tgl1.requestFocus(); }else if(evt.getKeyCode()==KeyEvent.VK_UP){ btnPasienActionPerformed(null); } }//GEN-LAST:event_kdmemKeyPressed private void NoNotaKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_NoNotaKeyPressed Valid.pindah(evt, BtnKeluar, kdptg); }//GEN-LAST:event_NoNotaKeyPressed private void kdptgKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_kdptgKeyPressed if(evt.getKeyCode()==KeyEvent.VK_PAGE_DOWN){ nmptg.setText(petugas.tampil3(kdptg.getText())); }else if(evt.getKeyCode()==KeyEvent.VK_PAGE_UP){ nmptg.setText(petugas.tampil3(kdptg.getText())); Tgl2.requestFocus(); }else if(evt.getKeyCode()==KeyEvent.VK_ENTER){ nmptg.setText(petugas.tampil3(kdptg.getText())); kdbar.requestFocus(); }else if(evt.getKeyCode()==KeyEvent.VK_UP){ btnPetugasActionPerformed(null); } }//GEN-LAST:event_kdptgKeyPressed private void Tgl2KeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_Tgl2KeyPressed Valid.pindah(evt, Tgl1,kdptg); }//GEN-LAST:event_Tgl2KeyPressed private void kdbarKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_kdbarKeyPressed if(evt.getKeyCode()==KeyEvent.VK_PAGE_DOWN){ Sequel.cariIsi("select databarang.nama_brng from databarang where databarang.kode_brng=?", nmbar,kdbar.getText()); }else if(evt.getKeyCode()==KeyEvent.VK_PAGE_UP){ Sequel.cariIsi("select databarang.nama_brng from databarang where databarang.kode_brng=?", nmbar,kdbar.getText()); kdsat.requestFocus(); }else if(evt.getKeyCode()==KeyEvent.VK_ENTER){ Sequel.cariIsi("select databarang.nama_brng from databarang where databarang.kode_brng=?", nmbar,kdbar.getText()); TCari.requestFocus(); }else if(evt.getKeyCode()==KeyEvent.VK_UP){ btnBarangActionPerformed(null); } }//GEN-LAST:event_kdbarKeyPressed private void btnBarangActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnBarangActionPerformed akses.setform("DlgCariPenjualan"); barang.emptTeks(); barang.isCek(); barang.setSize(internalFrame1.getWidth()-20,internalFrame1.getHeight()-20); barang.setLocationRelativeTo(internalFrame1); barang.setAlwaysOnTop(false); barang.setVisible(true); }//GEN-LAST:event_btnBarangActionPerformed private void kdsatKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_kdsatKeyPressed if(evt.getKeyCode()==KeyEvent.VK_PAGE_DOWN){ Sequel.cariIsi("select kodesatuan.satuan from kodesatuan where kodesatuan.kode_sat=?", nmsat,kdsat.getText()); }else if(evt.getKeyCode()==KeyEvent.VK_PAGE_UP){ Sequel.cariIsi("select kodesatuan.satuan from kodesatuan where kodesatuan.kode_sat=?", nmsat,kdsat.getText()); kdptg.requestFocus(); }else if(evt.getKeyCode()==KeyEvent.VK_ENTER){ Sequel.cariIsi("select kodesatuan.satuan from kodesatuan where kodesatuan.kode_sat=?", nmsat,kdsat.getText()); kdbar.requestFocus(); }else if(evt.getKeyCode()==KeyEvent.VK_UP){ btnSatuanActionPerformed(null); } }//GEN-LAST:event_kdsatKeyPressed private void btnSatuanActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnSatuanActionPerformed akses.setform("DlgCariPenjualan"); barang.jenis.emptTeks(); barang.jenis.isCek(); barang.jenis.setSize(internalFrame1.getWidth()-20,internalFrame1.getHeight()-20); barang.jenis.setLocationRelativeTo(internalFrame1); barang.jenis.setAlwaysOnTop(false); barang.jenis.setVisible(true); }//GEN-LAST:event_btnSatuanActionPerformed private void nmsatKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_nmsatKeyPressed // TODO add your handling code here: }//GEN-LAST:event_nmsatKeyPressed 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(); }else if(evt.getKeyCode()==KeyEvent.VK_UP){ tbDokter.requestFocus(); } }//GEN-LAST:event_TCariKeyPressed private void BtnCariActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnCariActionPerformed TabRawatMouseClicked(null); }//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 BtnAllActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnAllActionPerformed TCari.setText(""); NoNota.setText(""); kdbar.setText(""); nmbar.setText(""); kdsat.setText(""); nmsat.setText(""); kdmem.setText(""); nmmem.setText(""); kdptg.setText(""); nmptg.setText(""); TabRawatMouseClicked(null); }//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 BtnPrintActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnPrintActionPerformed this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR)); switch (TabRawat.getSelectedIndex()) { case 0: if(tabMode.getRowCount()==0){ JOptionPane.showMessageDialog(null,"Maaf, data sudah habis. Tidak ada data yang bisa anda print...!!!!"); TCari.requestFocus(); }else if(tabMode.getRowCount()!=0){ Sequel.queryu("delete from temporary where temp37='"+akses.getalamatip()+"'"); int row=tabMode.getRowCount(); for(i=0;i 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")); Valid.MyReportqry("rptPenjualan.jasper","report","::[ Transaksi Penjualan Barang ]::","select * from temporary where temporary.temp37='"+akses.getalamatip()+"' order by temporary.no",param); } break; case 1: this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR)); try { File g = new File("filepenjualan.css"); BufferedWriter bg = new BufferedWriter(new FileWriter(g)); bg.write( ".isi td{border-right: 1px solid #e2e7dd;font: 8.5px tahoma;height:12px;border-bottom: 1px solid #e2e7dd;background: #ffffff;color:#323232;}"+ ".head td{border-right: 1px solid #777777;font: 8.5px tahoma;height:10px;border-bottom: 1px solid #e2e7dd;background: #ffffff;color:#323232;}"+ ".isi a{text-decoration:none;color:#8b9b95;padding:0 0 0 0px;font-family: Tahoma;font-size: 8.5px;}"+ ".isi2 td{font: 8.5px tahoma;height:12px;background: #ffffff;color:#323232;}"+ ".isi3 td{border-right: 1px solid #e2e7dd;font: 8.5px tahoma;height:12px;border-top: 1px solid #e2e7dd;background: #ffffff;color:#323232;}"+ ".isi4 td{font: 11px tahoma;height:12px;border-top: 1px solid #e2e7dd;background: #ffffff;color:#323232;}" ); bg.close(); File f = new File("LaporanPenjualan.html"); BufferedWriter bw = new BufferedWriter(new FileWriter(f)); bw.write(LoadHTML1.getText().replaceAll("",""+ ""+ ""+ ""+ ""+ ""+ "
"+ ""+akses.getnamars()+"
"+ akses.getalamatrs()+", "+akses.getkabupatenrs()+", "+akses.getpropinsirs()+"
"+ akses.getkontakrs()+", E-mail : "+akses.getemailrs()+"

"+ "Data Penjualan Obat Bebas Periode "+Tgl1.getSelectedItem()+" s.d. "+Tgl2.getSelectedItem()+"

"+ "
") ); bw.close(); Desktop.getDesktop().browse(f.toURI()); } catch (Exception e) { System.out.println("Notifikasi : "+e); } this.setCursor(Cursor.getDefaultCursor()); break; default: break; } 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,BtnAll,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,kdbar);} }//GEN-LAST:event_BtnKeluarKeyPressed private void ppCetakNotaActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_ppCetakNotaActionPerformed this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR)); if(tabMode.getRowCount()==0){ JOptionPane.showMessageDialog(null,"Maaf, data sudah habis...!!!!"); TCari.requestFocus(); }else if(tbDokter.getSelectedRow()<= -1){ JOptionPane.showMessageDialog(null,"Maaf, Silahkan pilih data..!!"); }else{ if(tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim().equals("")){ Valid.textKosong(TCari,"No.Nota"); }else if(tabMode.getRowCount()==0){ JOptionPane.showMessageDialog(null,"Maaf, data sudah habis...!!!!"); kdbar.requestFocus(); }else { Valid.panggilUrl("billing/NotaApotek2.php?nonota="+tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim()+"&usere="+koneksiDB.USERHYBRIDWEB()+"&passwordte="+koneksiDB.PASHYBRIDWEB()); } } this.setCursor(Cursor.getDefaultCursor()); }//GEN-LAST:event_ppCetakNotaActionPerformed private void ppHapusActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_ppHapusActionPerformed if(tabMode.getRowCount()==0){ JOptionPane.showMessageDialog(null,"Maaf, data sudah habis...!!!!"); TCari.requestFocus(); }else if(tbDokter.getSelectedRow()<= -1){ JOptionPane.showMessageDialog(null,"Maaf, Silahkan pilih data..!!"); }else{ if(tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim().equals("")){ Valid.textKosong(TCari,"No.Nota"); }else{ try { pscarijual=koneksi.prepareStatement( "select penjualan.nota_jual,penjualan.kd_bangsal,penjualan.status,penjualan.kd_rek,penjualan.ongkir,penjualan.ppn from penjualan where penjualan.nota_jual=?"); try { pscarijual.setString(1,tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim()); rs=pscarijual.executeQuery(); if(rs.next()){ Sequel.AutoComitFalse(); sukses=true; if(rs.getString("status").equals("Sudah Dibayar")){ if(akses.getkode().equals("Admin Utama")){ psdetailjual=koneksi.prepareStatement( "select detailjual.kode_brng,detailjual.jumlah,detailjual.no_batch,detailjual.no_faktur from detailjual where detailjual.nota_jual=? "); try { psdetailjual.setString(1,rs.getString(1)); rs2=psdetailjual.executeQuery(); while(rs2.next()){ if(aktifkanbatch.equals("yes")){ Sequel.mengedit("data_batch","no_batch=? and kode_brng=? and no_faktur=?","sisa=sisa+?",4,new String[]{ rs2.getString("jumlah"),rs2.getString("no_batch"),rs2.getString("kode_brng"),rs2.getString("no_faktur") }); Trackobat.catatRiwayat(rs2.getString("kode_brng"),rs2.getDouble("jumlah"),0,"Penjualan",akses.getkode(),rs.getString("kd_bangsal"),"Hapus",rs2.getString("no_batch"),rs2.getString("no_faktur"),rs.getString("nota_jual")); Sequel.menyimpan("gudangbarang","'"+rs2.getString("kode_brng") +"','"+rs.getString("kd_bangsal")+"','"+rs2.getString("jumlah") +"','"+rs2.getString("no_batch")+"','"+rs2.getString("no_faktur")+"'", "stok=stok+'"+rs2.getString("jumlah") +"'","kode_brng='"+rs2.getString("kode_brng")+"' and kd_bangsal='"+rs.getString("kd_bangsal") +"' and no_batch='"+rs2.getString("no_batch")+"' and no_faktur='"+rs2.getString("no_faktur")+"'"); }else{ Trackobat.catatRiwayat(rs2.getString("kode_brng"),rs2.getDouble("jumlah"),0,"Penjualan",akses.getkode(),rs.getString("kd_bangsal"),"Hapus","","",rs.getString("nota_jual")); Sequel.menyimpan("gudangbarang","'"+rs2.getString("kode_brng") +"','"+rs.getString("kd_bangsal")+"','"+rs2.getString("jumlah") +"','',''", "stok=stok+'"+rs2.getString("jumlah") +"'","kode_brng='"+rs2.getString("kode_brng")+"' and kd_bangsal='"+rs.getString("kd_bangsal") +"' and no_batch='' and no_faktur=''"); } } } catch (Exception e) { sukses=false; System.out.println("Notifikasi : "+e); } finally{ if(rs2!=null){ rs2.close(); } if(psdetailjual!=null){ psdetailjual.close(); } } if(sukses==true){ ttljual=Sequel.cariIsiAngka("select sum(detailjual.total) from detailjual where detailjual.nota_jual=?",rs.getString("nota_jual")); ttlhpp=Sequel.cariIsiAngka("select sum(detailjual.h_beli*detailjual.jumlah) from detailjual where detailjual.nota_jual=?",rs.getString("nota_jual")); Sequel.queryu("delete from tampjurnal"); if(Sequel.menyimpantf2("tampjurnal","'"+Penjualan_Obat+"','PENJUALAN','"+(ttljual+rs.getDouble("ongkir"))+"','0'","Rekening")==false){ sukses=false; } if(Sequel.menyimpantf2("tampjurnal","'"+PPN_Keluaran+"','PPN KELUARAN','"+(rs.getDouble("ppn"))+"','0'","Rekening")==false){ sukses=false; } if(Sequel.menyimpantf2("tampjurnal","'"+rs.getString("kd_rek")+"','KAS DI TANGAN','0','"+(ttljual+rs.getDouble("ongkir")+rs.getDouble("ppn"))+"'","Rekening")==false){ sukses=false; } if(Sequel.menyimpantf2("tampjurnal","'"+HPP_Obat_Jual_Bebas+"','HPP Obat Jual Bebas','0','"+ttlhpp+"'","Rekening")==false){ sukses=false; } if(Sequel.menyimpantf2("tampjurnal","'"+Persediaan_Obat_Jual_Bebas+"','Persediaan Obat Jual Bebas','"+ttlhpp+"','0'","Rekening")==false){ sukses=false; } if(sukses==true){ sukses=jur.simpanJurnal(rs.getString("nota_jual"),"U","BATAL PENJUALAN DI "+Sequel.cariIsi("select bangsal.nm_bangsal from bangsal where bangsal.kd_bangsal='"+rs.getString("kd_bangsal")+"'").toUpperCase()+", OLEH "+akses.getkode()); } } if(sukses==true){ Sequel.queryu("delete from tagihan_sadewa where no_nota='"+tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim()+"'"); Sequel.queryu("delete from penjualan where nota_jual='"+tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim()+"'"); } }else{ JOptionPane.showMessageDialog(null,"Hanya Admin yang diijinkan untuk menghapus jika statusnya sudah bayar..!!"); } }else{ Sequel.queryu("delete from penjualan where nota_jual='"+tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim()+"'"); } 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){ tampil(); } } } catch (Exception e) { System.out.println("Notifikasi : "+e); } finally{ if(rs!=null){ rs.close(); } if(pscarijual!=null){ pscarijual.close(); } } } catch (Exception ex) { System.out.println(ex); } } } }//GEN-LAST:event_ppHapusActionPerformed private void formWindowOpened(java.awt.event.WindowEvent evt) {//GEN-FIRST:event_formWindowOpened tampil(); tampilAkunBayar(); }//GEN-LAST:event_formWindowOpened private void ppVerifActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_ppVerifActionPerformed if(tabMode.getRowCount()==0){ JOptionPane.showMessageDialog(null,"Maaf, data sudah habis...!!!!"); TCari.requestFocus(); }else if(tbDokter.getSelectedRow()<= -1){ JOptionPane.showMessageDialog(null,"Maaf, Silahkan pilih data..!!"); }else{ if(tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim().equals("")){ Valid.textKosong(TCari,"No.Nota"); }else{ WindowGantiCaraBayar.setSize(630,80); WindowGantiCaraBayar.setLocationRelativeTo(internalFrame1); WindowGantiCaraBayar.setAlwaysOnTop(false); WindowGantiCaraBayar.setVisible(true); } } }//GEN-LAST:event_ppVerifActionPerformed private void TabRawatMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_TabRawatMouseClicked if(TabRawat.getSelectedIndex()==0){ tampil(); }else if(TabRawat.getSelectedIndex()==1){ tampil2(); } }//GEN-LAST:event_TabRawatMouseClicked private void ppResepObatActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_ppResepObatActionPerformed if(tabMode.getRowCount()==0){ JOptionPane.showMessageDialog(null,"Maaf, data sudah habis...!!!!"); TCari.requestFocus(); }else if(tbDokter.getSelectedRow()<= -1){ JOptionPane.showMessageDialog(null,"Maaf, Silahkan pilih data..!!"); }else{ if(tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim().equals("")){ Valid.textKosong(TCari,"No.Nota"); }else{ this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR)); 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()); if(Sequel.cariInteger( "select count(*) from detailjual where detailjual.nota_jual=? and detailjual.aturan_pakai<>''",tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim())>0){ param.put("logo",Sequel.cariGambar("select setting.logo from setting")); Valid.MyReportqry("rptItemResepPenjualan.jasper","report","::[ Aturan Pakai Obat ]::", "select penjualan.nota_jual,penjualan.tgl_jual, "+ "penjualan.no_rkm_medis,penjualan.nm_pasien,databarang.nama_brng,"+ "detailjual.aturan_pakai,detailjual.jumlah,kodesatuan.satuan "+ "from penjualan inner join detailjual on penjualan.nota_jual=detailjual.nota_jual "+ "inner join databarang on detailjual.kode_brng=databarang.kode_brng "+ "inner join kodesatuan on databarang.kode_sat=kodesatuan.kode_sat "+ "where penjualan.nota_jual='"+tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim()+"' and detailjual.aturan_pakai<>''",param); } if(Sequel.cariInteger( "select count(*) from obat_racikan_jual where obat_racikan_jual.nota_jual=? and obat_racikan_jual.aturan_pakai<>''",tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim())>0){ param.put("logo",Sequel.cariGambar("select setting.logo from setting")); Valid.MyReportqry("rptItemResepPenjualan2.jasper","report","::[ Aturan Pakai Obat ]::", "select penjualan.nota_jual,penjualan.tgl_jual,metode_racik.nm_racik, "+ "penjualan.no_rkm_medis,penjualan.nm_pasien,obat_racikan_jual.nama_racik,"+ "obat_racikan_jual.aturan_pakai,obat_racikan_jual.jml_dr "+ "from penjualan inner join obat_racikan_jual on penjualan.nota_jual=obat_racikan_jual.nota_jual "+ "inner join metode_racik on obat_racikan_jual.kd_racik=metode_racik.kd_racik "+ "where obat_racikan_jual.nota_jual='"+tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim()+"' and obat_racikan_jual.aturan_pakai<>''",param); } this.setCursor(Cursor.getDefaultCursor()); } } }//GEN-LAST:event_ppResepObatActionPerformed private void ppResepObat1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_ppResepObat1ActionPerformed if(tabMode.getRowCount()==0){ JOptionPane.showMessageDialog(null,"Maaf, data sudah habis...!!!!"); TCari.requestFocus(); }else if(tbDokter.getSelectedRow()<= -1){ JOptionPane.showMessageDialog(null,"Maaf, Silahkan pilih data..!!"); }else{ if(tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim().equals("")){ Valid.textKosong(TCari,"No.Nota"); }else{ this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR)); 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()); if(Sequel.cariInteger( "select count(*) from detailjual where detailjual.nota_jual=? and detailjual.aturan_pakai<>''",tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim())>0){ param.put("logo",Sequel.cariGambar("select setting.logo from setting")); Valid.MyReportqry("rptItemResepPenjualan3.jasper","report","::[ Aturan Pakai Obat ]::", "select penjualan.nota_jual,penjualan.tgl_jual, "+ "penjualan.no_rkm_medis,penjualan.nm_pasien,databarang.nama_brng,"+ "detailjual.aturan_pakai,detailjual.jumlah,kodesatuan.satuan,jenis.nama as jenis "+ "from penjualan inner join detailjual on penjualan.nota_jual=detailjual.nota_jual "+ "inner join databarang on detailjual.kode_brng=databarang.kode_brng "+ "inner join kodesatuan on databarang.kode_sat=kodesatuan.kode_sat "+ "inner join jenis on databarang.kdjns=jenis.kdjns "+ "where penjualan.nota_jual='"+tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim()+"' and detailjual.aturan_pakai<>''",param); } if(Sequel.cariInteger( "select count(*) from obat_racikan_jual where obat_racikan_jual.nota_jual=? and obat_racikan_jual.aturan_pakai<>''",tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim())>0){ param.put("logo",Sequel.cariGambar("select setting.logo from setting")); Valid.MyReportqry("rptItemResepPenjualan2.jasper","report","::[ Aturan Pakai Obat ]::", "select penjualan.nota_jual,penjualan.tgl_jual,metode_racik.nm_racik, "+ "penjualan.no_rkm_medis,penjualan.nm_pasien,obat_racikan_jual.nama_racik,"+ "obat_racikan_jual.aturan_pakai,obat_racikan_jual.jml_dr "+ "from penjualan inner join obat_racikan_jual on penjualan.nota_jual=obat_racikan_jual.nota_jual "+ "inner join metode_racik on obat_racikan_jual.kd_racik=metode_racik.kd_racik "+ "where obat_racikan_jual.nota_jual='"+tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim()+"' and obat_racikan_jual.aturan_pakai<>''",param); } this.setCursor(Cursor.getDefaultCursor()); } } }//GEN-LAST:event_ppResepObat1ActionPerformed private void ppResepObat2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_ppResepObat2ActionPerformed if(tabMode.getRowCount()==0){ JOptionPane.showMessageDialog(null,"Maaf, data sudah habis...!!!!"); TCari.requestFocus(); }else if(tbDokter.getSelectedRow()<= -1){ JOptionPane.showMessageDialog(null,"Maaf, Silahkan pilih data..!!"); }else{ if(tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim().equals("")){ Valid.textKosong(TCari,"No.Nota"); }else{ this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR)); 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()); if(Sequel.cariInteger( "select count(*) from detailjual where detailjual.nota_jual=? and detailjual.aturan_pakai<>''",tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim())>0){ param.put("logo",Sequel.cariGambar("select setting.logo from setting")); Valid.MyReportqry("rptItemResepPenjualan5.jasper","report","::[ Aturan Pakai Obat ]::", "select penjualan.nota_jual,penjualan.tgl_jual, "+ "penjualan.no_rkm_medis,penjualan.nm_pasien,databarang.nama_brng,"+ "detailjual.aturan_pakai,detailjual.jumlah,kodesatuan.satuan "+ "from penjualan inner join detailjual on penjualan.nota_jual=detailjual.nota_jual "+ "inner join databarang on detailjual.kode_brng=databarang.kode_brng "+ "inner join kodesatuan on databarang.kode_sat=kodesatuan.kode_sat "+ "where penjualan.nota_jual='"+tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim()+"' and detailjual.aturan_pakai<>''",param); } if(Sequel.cariInteger( "select count(*) from obat_racikan_jual where obat_racikan_jual.nota_jual=? and obat_racikan_jual.aturan_pakai<>''",tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim())>0){ param.put("logo",Sequel.cariGambar("select setting.logo from setting")); Valid.MyReportqry("rptItemResepPenjualan6.jasper","report","::[ Aturan Pakai Obat ]::", "select penjualan.nota_jual,penjualan.tgl_jual,metode_racik.nm_racik, "+ "penjualan.no_rkm_medis,penjualan.nm_pasien,obat_racikan_jual.nama_racik,"+ "obat_racikan_jual.aturan_pakai,obat_racikan_jual.jml_dr "+ "from penjualan inner join obat_racikan_jual on penjualan.nota_jual=obat_racikan_jual.nota_jual "+ "inner join metode_racik on obat_racikan_jual.kd_racik=metode_racik.kd_racik "+ "where obat_racikan_jual.nota_jual='"+tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim()+"' and obat_racikan_jual.aturan_pakai<>''",param); } this.setCursor(Cursor.getDefaultCursor()); } } }//GEN-LAST:event_ppResepObat2ActionPerformed private void BtnCloseIn4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnCloseIn4ActionPerformed WindowGantiCaraBayar.dispose(); }//GEN-LAST:event_BtnCloseIn4ActionPerformed private void BtnSimpan4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnSimpan4ActionPerformed if(tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim().equals("")){ Valid.textKosong(TCari,"No.Nota"); }else{ try { pscarijual=koneksi.prepareStatement( "select penjualan.nota_jual,penjualan.kd_bangsal,penjualan.status,penjualan.no_rkm_medis,penjualan.nm_pasien,penjualan.tgl_jual,penjualan.ongkir,penjualan.ppn from penjualan where penjualan.nota_jual=?"); try { pscarijual.setString(1,tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim()); rs=pscarijual.executeQuery(); if(rs.next()){ if(rs.getString("status").equals("Sudah Dibayar")){ JOptionPane.showMessageDialog(rootPane,"Maaf transaksi penjualan sudah diverifikasi..!!"); }else{ kdrek=""; ttljual=rs.getDouble("ongkir")+rs.getDouble("ppn")+Sequel.cariIsiAngka("select sum(detailjual.total) from detailjual where detailjual.nota_jual=?",tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim()); try { myObj = new FileReader("./cache/akunbayar.iyem"); root = mapper.readTree(myObj); response = root.path("akunbayar"); if(response.isArray()){ for(JsonNode list:response){ if(list.path("NamaAkun").asText().equals(AkunBayar.getSelectedItem().toString())){ kdrek=list.path("KodeRek").asText(); } } } myObj.close(); } catch (Exception e) { sukses=false; } Sequel.mengedit("penjualan","nota_jual=?","kd_rek=?,nama_bayar=?",3,new String[]{ kdrek,AkunBayar.getSelectedItem().toString(),tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim() }); Sequel.AutoComitFalse(); sukses=true; psdetailjual=koneksi.prepareStatement( "select detailjual.kode_brng,detailjual.jumlah,detailjual.no_batch,detailjual.no_faktur from detailjual where detailjual.nota_jual=? "); try { psdetailjual.setString(1,rs.getString(1)); rs2=psdetailjual.executeQuery(); while(rs2.next()){ Trackobat.catatRiwayat(rs2.getString("kode_brng"),0,rs2.getDouble("jumlah") ,"Penjualan",akses.getkode(),rs.getString("kd_bangsal"),"Simpan",rs2.getString("no_batch"),rs2.getString("no_faktur"),rs.getString("nota_jual")); Sequel.menyimpan("gudangbarang","'"+rs2.getString("kode_brng") +"','"+rs.getString("kd_bangsal") +"','"+rs2.getString("jumlah") +"','"+rs2.getString("no_batch")+"','"+rs2.getString("no_faktur")+"'", "stok=stok-'"+rs2.getString("jumlah") +"'","kode_brng='"+rs2.getString("kode_brng")+"' and kd_bangsal='"+rs.getString("kd_bangsal") +"' and no_batch='"+rs2.getString("no_batch")+"' and no_faktur='"+rs2.getString("no_faktur")+"'"); if(aktifkanbatch.equals("yes")){ Sequel.mengedit("data_batch","no_batch=? and kode_brng=? and no_faktur=?","sisa=sisa-?",4,new String[]{ rs2.getString("jumlah"),rs2.getString("no_batch"),rs2.getString("kode_brng"),rs2.getString("no_faktur") }); } } } catch (Exception e) { sukses=false; System.out.println("Notifikasi 1 : "+e); } finally{ if(rs2!=null){ rs2.close(); } if(psdetailjual!=null){ psdetailjual.close(); } } if(sukses==true){ ttlhpp=Sequel.cariIsiAngka("select sum(detailjual.h_beli*detailjual.jumlah) from detailjual where detailjual.nota_jual=?",rs.getString("nota_jual")); Sequel.queryu("delete from tampjurnal"); if(Sequel.menyimpantf2("tampjurnal","'"+Penjualan_Obat+"','PENJUALAN OBAT BEBAS','0','"+Double.toString(ttljual-rs.getDouble("ppn"))+"'","Rekening")==false){ sukses=false; } if(Sequel.menyimpantf2("tampjurnal","'"+PPN_Keluaran+"','PPN KELUARAN','0','"+Double.toString(rs.getDouble("ppn"))+"'","Rekening")==false){ sukses=false; } if(Sequel.menyimpantf2("tampjurnal","'"+kdrek+"','KAS DI TANGAN','"+Double.toString(ttljual)+"','0'","Rekening")==false){ sukses=false; } if(Sequel.menyimpantf2("tampjurnal","'"+HPP_Obat_Jual_Bebas+"','HPP Obat Jual Bebas','"+ttlhpp+"','0'","Rekening")==false){ sukses=false; } if(Sequel.menyimpantf2("tampjurnal","'"+Persediaan_Obat_Jual_Bebas+"','Persediaan Obat Jual Bebas','0','"+ttlhpp+"'","Rekening")==false){ sukses=false; } if(sukses==true){ sukses=jur.simpanJurnal(rs.getString("nota_jual"),"U","PENJUALAN DI "+Sequel.cariIsi("select bangsal.nm_bangsal from bangsal where bangsal.kd_bangsal='"+rs.getString("kd_bangsal")+"'").toUpperCase()+", OLEH "+akses.getkode()); } } if(sukses==true){ Sequel.mengedit("penjualan","nota_jual=?","status='Sudah Dibayar'",1,new String[]{rs.getString("nota_jual")}); Sequel.menyimpan("tagihan_sadewa","'"+rs.getString("nota_jual")+"','"+rs.getString("no_rkm_medis")+"','"+rs.getString("nm_pasien").replaceAll("'","")+"','-',concat('"+rs.getString("tgl_jual")+ "',' ',CURTIME()),'Pelunasan','"+Double.toString(ttljual)+"','"+Double.toString(ttljual)+"','Sudah','"+akses.getkode()+"'","No.Nota"); 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){ if(notapenjualan.equals("Yes")){ ppCetakNotaActionPerformed(evt); } tampil(); } } } } catch (Exception e) { System.out.println("Notifikasi 2 : "+e); } finally{ if(rs!=null){ rs.close(); } if(pscarijual!=null){ pscarijual.close(); } } } catch (Exception ex) { System.out.println(ex); } WindowGantiCaraBayar.dispose(); } }//GEN-LAST:event_BtnSimpan4ActionPerformed private void BtnAll1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnAll1ActionPerformed tampilAkunBayar(); }//GEN-LAST:event_BtnAll1ActionPerformed /** * @param args the command line arguments */ public static void main(String args[]) { java.awt.EventQueue.invokeLater(() -> { DlgCariPenjualan dialog = new DlgCariPenjualan(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.ComboBox AkunBayar; private widget.Button BtnAll; private widget.Button BtnAll1; private widget.Button BtnCari; private widget.Button BtnCloseIn4; private widget.Button BtnKeluar; private widget.Button BtnPrint; private widget.Button BtnSimpan4; private widget.Label LTotal; private widget.editorpane LoadHTML1; private widget.TextBox NoNota; private widget.ScrollPane Scroll; private widget.ComboBox Status; private widget.TextBox TCari; private javax.swing.JTabbedPane TabRawat; private widget.Tanggal Tgl1; private widget.Tanggal Tgl2; private javax.swing.JDialog WindowGantiCaraBayar; private widget.Button btnBarang; private widget.Button btnPasien; private widget.Button btnPetugas; private widget.Button btnSatuan; private widget.InternalFrame internalFrame1; private widget.InternalFrame internalFrame5; private widget.Label jLabel10; private javax.swing.JPanel jPanel1; private javax.swing.JPopupMenu jPopupMenu1; private widget.TextBox kdbar; private widget.TextBox kdmem; private widget.TextBox kdptg; private widget.TextBox kdsat; private widget.Label label10; private widget.Label label11; private widget.Label label13; private widget.Label label14; private widget.Label label15; private widget.Label label16; private widget.Label label17; private widget.Label label18; private widget.Label label24; private widget.Label label9; private widget.TextBox nmbar; private widget.TextBox nmmem; private widget.TextBox nmptg; private widget.TextBox nmsat; private widget.panelisi panelisi1; private widget.panelisi panelisi3; private widget.panelisi panelisi4; private javax.swing.JMenuItem ppCetakNota; private javax.swing.JMenuItem ppHapus; private javax.swing.JMenuItem ppResepObat; private javax.swing.JMenuItem ppResepObat1; private javax.swing.JMenuItem ppResepObat2; private javax.swing.JMenuItem ppVerif; private widget.ScrollPane scrollPane1; private widget.Table tbDokter; // End of variables declaration//GEN-END:variables private void tampil() { tanggal=" penjualan.tgl_jual between '"+Valid.SetTgl(Tgl1.getSelectedItem()+"")+"' and '"+Valid.SetTgl(Tgl2.getSelectedItem()+"")+"' "; nofak="";mem="";ptg="";sat="";bar="";statusbayar="";datacari=""; if(!NoNota.getText().equals("")){ nofak=" and penjualan.nota_jual='"+NoNota.getText()+"' "; } if(!nmmem.getText().equals("")){ mem=" and penjualan.nm_pasien='"+nmmem.getText()+"' "; } if(!nmptg.getText().equals("")){ ptg=" and petugas.nama='"+nmptg.getText()+"' "; } if(!nmsat.getText().equals("")){ sat=" and jenis.nama='"+nmsat.getText()+"' "; } if(!nmbar.getText().equals("")){ bar=" and databarang.nama_brng='"+nmbar.getText()+"' "; } if(!Status.getSelectedItem().toString().equals("Semua")){ statusbayar=" and penjualan.status='"+Status.getSelectedItem().toString()+"' "; } if(!TCari.getText().trim().equals("")){ datacari=" and (penjualan.nota_jual like '%"+TCari.getText()+"%' or penjualan.no_rkm_medis like '%"+TCari.getText()+"%' or "+ "penjualan.nm_pasien like '%"+TCari.getText()+"%' or penjualan.nip like '%"+TCari.getText()+"%' or "+ "petugas.nama like '%"+TCari.getText()+"%' or penjualan.keterangan like '%"+TCari.getText()+"%' or "+ "penjualan.jns_jual like '%"+TCari.getText()+"%' or detailjual.kode_brng like '%"+TCari.getText()+"%' or "+ "bangsal.nm_bangsal like '%"+TCari.getText()+"%' or databarang.nama_brng like '%"+TCari.getText()+"%' or "+ "detailjual.kode_sat like '%"+TCari.getText()+"%' or jenis.nama like '%"+TCari.getText()+"%') "; } Valid.tabelKosong(tabMode); try{ ttljual=0; ps=koneksi.prepareStatement("select penjualan.nota_jual, penjualan.tgl_jual, "+ "penjualan.nip,petugas.nama,penjualan.no_rkm_medis,penjualan.nm_pasien, "+ "penjualan.keterangan, penjualan.jns_jual, penjualan.ongkir,bangsal.nm_bangsal,penjualan.status,penjualan.ppn,penjualan.nama_bayar "+ " from penjualan inner join petugas inner join bangsal inner join jenis "+ " inner join detailjual inner join databarang inner join kodesatuan "+ " on detailjual.kode_brng=databarang.kode_brng "+ " and detailjual.kode_sat=kodesatuan.kode_sat "+ " and penjualan.kd_bangsal=bangsal.kd_bangsal "+ " and penjualan.nota_jual=detailjual.nota_jual "+ " and penjualan.nip=petugas.nip and databarang.kdjns=jenis.kdjns "+ " where "+tanggal+nofak+mem+ptg+sat+bar+statusbayar+datacari+ " group by penjualan.nota_jual order by penjualan.tgl_jual,penjualan.nota_jual "); try { rs=ps.executeQuery(); ttlsubttl=0; ttlppn=0; ttlongkir=0; ttlembalase=0; ttltambahan=0; ttltuslah=0; ttldisc=0; while(rs.next()){ tabMode.addRow(new Object[]{ rs.getString(1),rs.getString(2),rs.getString(3)+", "+rs.getString(4), rs.getString(5)+", "+rs.getString(6),rs.getString(7),rs.getString(8), df2.format(rs.getDouble(12)),rs.getString(10),"","","","","",df2.format(rs.getDouble(9)),rs.getString(13) }); tabMode.addRow(new Object[]{ "","No.Batch","No.Nota","Barang","Satuan","Harga(Rp)","Jml","Subtotal(Rp)","Ptg(%)","Potongan(Rp)","Tambahan(Rp)","Embalase(Rp)","Tuslah(Rp)","Total","Aturan Pakai" }); ttlppn=ttlppn+rs.getDouble(12); ttlongkir=ttlongkir+rs.getDouble(9); ps2=koneksi.prepareStatement("select detailjual.kode_brng,databarang.nama_brng, detailjual.kode_sat,"+ " kodesatuan.satuan,detailjual.h_jual, detailjual.jumlah, "+ " detailjual.subtotal, detailjual.dis, detailjual.bsr_dis,"+ " detailjual.tambahan,detailjual.embalase,detailjual.tuslah,"+ " detailjual.aturan_pakai,detailjual.total,detailjual.no_batch,detailjual.no_faktur from "+ " detailjual inner join databarang inner join kodesatuan inner join jenis "+ " on detailjual.kode_brng=databarang.kode_brng and databarang.kdjns=jenis.kdjns "+ " and detailjual.kode_sat=kodesatuan.kode_sat where "+ " detailjual.nota_jual='"+rs.getString(1)+"' "+sat+bar+" and "+ " (detailjual.kode_brng like '%"+TCari.getText()+"%' or databarang.nama_brng like '%"+TCari.getText()+"%' or "+ " detailjual.kode_sat like '%"+TCari.getText()+"%' or jenis.nama like '%"+TCari.getText()+"%')"+ " order by detailjual.kode_brng"); try { rs2=ps2.executeQuery(); subttlall=0; subttldisc=0; subttljual=0; subttltambahan=0; subttlembalase=0; subttltuslah=0; no=1; while(rs2.next()){ subttlall=subttlall+rs2.getDouble(7); ttlsubttl=ttlsubttl+rs2.getDouble(7); subttldisc=subttldisc+rs2.getDouble(9); ttldisc=ttldisc+rs2.getDouble(9); subttltambahan=subttltambahan+rs2.getDouble(10); ttltambahan=ttltambahan+rs2.getDouble(10); subttlembalase=subttlembalase+rs2.getDouble(11); ttlembalase=ttlembalase+rs2.getDouble(11); subttltuslah=subttltuslah+rs2.getDouble(12); ttltuslah=ttltuslah+rs2.getDouble(12); ttljual=ttljual+rs2.getDouble(14); subttljual=subttljual+rs2.getDouble(14); tabMode.addRow(new Object[]{ "",no+". "+rs2.getString("no_batch"),rs2.getString("no_faktur"),rs2.getString("kode_brng")+", "+rs2.getString("nama_brng"), rs2.getString("satuan"),df2.format(rs2.getDouble("h_jual")), rs2.getString("jumlah"),df2.format(rs2.getDouble("subtotal")),df2.format(rs2.getDouble("dis")), df2.format(rs2.getDouble("bsr_dis")),df2.format(rs2.getDouble("tambahan")), df2.format(rs2.getDouble("embalase")),df2.format(rs2.getDouble("tuslah")), df2.format(rs2.getDouble("total")),rs2.getString("aturan_pakai") }); no++; } tabMode.addRow(new Object[]{ "","Status : ",rs.getString("status"),"","Total :","","",df2.format(subttlall),"",df2.format(subttldisc),df2.format(subttltambahan),df2.format(subttlembalase),df2.format(subttltuslah),df2.format(subttljual),"" }); } catch (Exception e) { System.out.println("Notifikasi : "+e); } finally{ if(rs2!=null){ rs2.close(); } if(ps2!=null){ ps2.close(); } } } } catch (Exception e) { System.out.println("Notifikasi : "+e); } finally{ if(rs!=null){ rs.close(); } if(ps!=null){ ps.close(); } } LTotal.setText(df2.format(ttljual+ttlppn+ttlongkir)); }catch(Exception e){ System.out.println("Notifikasi : "+e); } } public void tampil2(){ this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR)); tanggal=" penjualan.tgl_jual between '"+Valid.SetTgl(Tgl1.getSelectedItem()+"")+"' and '"+Valid.SetTgl(Tgl2.getSelectedItem()+"")+"' "; nofak="";mem="";ptg="";sat="";bar="";statusbayar=""; if(!NoNota.getText().equals("")){ nofak=" and penjualan.nota_jual='"+NoNota.getText()+"' "; } if(!nmmem.getText().equals("")){ mem=" and penjualan.nm_pasien='"+nmmem.getText()+"' "; } if(!nmptg.getText().equals("")){ ptg=" and petugas.nama='"+nmptg.getText()+"' "; } if(!nmsat.getText().equals("")){ sat=" and jenis.nama='"+nmsat.getText()+"' "; } if(!nmbar.getText().equals("")){ bar=" and databarang.nama_brng='"+nmbar.getText()+"' "; } if(!Status.getSelectedItem().toString().equals("Semua")){ statusbayar=" and penjualan.status='"+Status.getSelectedItem().toString()+"' "; } try{ ttljual=0; totaljual=""; StringBuilder htmlContent = new StringBuilder(); htmlContent.append( "").append( "No.Nota").append( "Tanggal").append( "Petugas").append( "Pasien").append( "Jenis Jual").append( "Keterangan").append( "Asal Barang").append( "Cara Bayar").append( "PPN").append( "Ongkos Kirim").append( ""); ps=koneksi.prepareStatement("select penjualan.nota_jual, penjualan.tgl_jual, "+ "penjualan.nip,petugas.nama,penjualan.ongkir,penjualan.ppn, "+ "penjualan.no_rkm_medis,penjualan.nm_pasien,penjualan.nama_bayar, "+ "penjualan.keterangan, penjualan.jns_jual, penjualan.ongkir,bangsal.nm_bangsal,penjualan.status "+ " from penjualan inner join petugas inner join bangsal inner join jenis "+ " inner join detailjual inner join databarang inner join kodesatuan "+ " on detailjual.kode_brng=databarang.kode_brng "+ " and detailjual.kode_sat=kodesatuan.kode_sat "+ " and penjualan.kd_bangsal=bangsal.kd_bangsal "+ " and penjualan.nota_jual=detailjual.nota_jual "+ " and penjualan.nip=petugas.nip and databarang.kdjns=jenis.kdjns "+ " where "+tanggal+nofak+mem+ptg+sat+bar+statusbayar+" and "+ "(penjualan.nota_jual like '%"+TCari.getText()+"%' or penjualan.no_rkm_medis like '%"+TCari.getText()+"%' or "+ "penjualan.nm_pasien like '%"+TCari.getText()+"%' or penjualan.nip like '%"+TCari.getText()+"%' or "+ "petugas.nama like '%"+TCari.getText()+"%' or penjualan.keterangan like '%"+TCari.getText()+"%' or "+ "penjualan.jns_jual like '%"+TCari.getText()+"%' or detailjual.kode_brng like '%"+TCari.getText()+"%' or "+ "bangsal.nm_bangsal like '%"+TCari.getText()+"%' or databarang.nama_brng like '%"+TCari.getText()+"%' or "+ "detailjual.kode_sat like '%"+TCari.getText()+"%' or jenis.nama like '%"+TCari.getText()+"%') "+ " group by penjualan.nota_jual order by penjualan.tgl_jual,penjualan.nota_jual "); try { rs=ps.executeQuery(); ttlsubttl=0; ttlppn=0; ttlongkir=0; ttlembalase=0; ttltambahan=0; ttltuslah=0; ttldisc=0; while(rs.next()){ ttlongkir=ttlongkir+rs.getDouble("ongkir"); ttlppn=ttlppn+rs.getDouble("ppn"); htmlContent.append( "").append( "").append(rs.getString("nota_jual")).append("").append( "").append(rs.getString("tgl_jual")).append("").append( "").append(rs.getString("nip")).append(" ").append(rs.getString("nama")).append("").append( "").append(rs.getString("no_rkm_medis")).append(" ").append(rs.getString("nm_pasien")).append("").append( "").append(rs.getString("jns_jual")).append("").append( "").append(rs.getString("keterangan")).append("").append( "").append(rs.getString("nm_bangsal")).append("").append( "").append(rs.getString("nama_bayar")).append("").append( "").append(Valid.SetAngka(rs.getDouble("ppn"))).append("").append( "").append(Valid.SetAngka(rs.getDouble("ongkir"))).append("").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( ""); ps2=koneksi.prepareStatement("select detailjual.kode_brng,databarang.nama_brng, detailjual.kode_sat,"+ " kodesatuan.satuan,detailjual.h_jual, detailjual.jumlah, "+ " detailjual.subtotal, detailjual.dis, detailjual.bsr_dis,"+ " detailjual.tambahan,detailjual.embalase,detailjual.tuslah,"+ " detailjual.aturan_pakai,detailjual.total,detailjual.no_batch from "+ " detailjual inner join databarang inner join kodesatuan inner join jenis "+ " on detailjual.kode_brng=databarang.kode_brng and databarang.kdjns=jenis.kdjns "+ " and detailjual.kode_sat=kodesatuan.kode_sat and "+ " detailjual.kode_brng not in(select kode_brng from detail_obat_racikan_jual where nota_jual='"+rs.getString("nota_jual")+"' group by kode_brng) where "+ " detailjual.nota_jual='"+rs.getString("nota_jual")+"' "+sat+bar+" and detailjual.kode_brng like '%"+TCari.getText()+"%' or "+ " detailjual.nota_jual='"+rs.getString("nota_jual")+"' "+sat+bar+" and databarang.nama_brng like '%"+TCari.getText()+"%' or "+ " detailjual.nota_jual='"+rs.getString("nota_jual")+"' "+sat+bar+" and detailjual.kode_sat like '%"+TCari.getText()+"%' or "+ " detailjual.nota_jual='"+rs.getString("nota_jual")+"' "+sat+bar+" and jenis.nama like '%"+TCari.getText()+"%' order by detailjual.kode_brng"); try { rs2=ps2.executeQuery(); subttlall=0; subttldisc=0; subttljual=0; subttltambahan=0; subttlembalase=0; subttltuslah=0; no=1; while(rs2.next()){ subttlall=subttlall+rs2.getDouble(7); ttlsubttl=ttlsubttl+rs2.getDouble(7); subttldisc=subttldisc+rs2.getDouble(9); ttldisc=ttldisc+rs2.getDouble(9); subttltambahan=subttltambahan+rs2.getDouble(10); ttltambahan=ttltambahan+rs2.getDouble(10); subttlembalase=subttlembalase+rs2.getDouble(11); ttlembalase=ttlembalase+rs2.getDouble(11); subttltuslah=subttltuslah+rs2.getDouble(12); ttltuslah=ttltuslah+rs2.getDouble(12); ttljual=ttljual+rs2.getDouble(14); subttljual=subttljual+rs2.getDouble(14); htmlContent.append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( ""); no++; } } catch (Exception e) { System.out.println("Notifikasi : "+e); } finally{ if(rs2!=null){ rs2.close(); } if(ps2!=null){ ps2.close(); } } ps2=koneksi.prepareStatement( "select obat_racikan_jual.no_racik,obat_racikan_jual.nama_racik,"+ "obat_racikan_jual.kd_racik,metode_racik.nm_racik as metode,"+ "obat_racikan_jual.jml_dr,obat_racikan_jual.aturan_pakai,"+ "obat_racikan_jual.keterangan from obat_racikan_jual inner join metode_racik "+ "on obat_racikan_jual.kd_racik=metode_racik.kd_racik where "+ "obat_racikan_jual.nota_jual=? order by obat_racikan_jual.no_racik"); try{ ps2.setString(1,rs.getString("nota_jual")); rs2=ps2.executeQuery(); while(rs2.next()){ htmlContent.append( "").append( "").append( "").append( "").append( "").append( "").append( ""); ps3=koneksi.prepareStatement("select detailjual.kode_brng,databarang.nama_brng, detailjual.kode_sat,"+ " kodesatuan.satuan,detailjual.h_jual, detailjual.jumlah, "+ " detailjual.subtotal, detailjual.dis, detailjual.bsr_dis,"+ " detailjual.tambahan,detailjual.embalase,detailjual.tuslah,"+ " detailjual.aturan_pakai,detailjual.total,detailjual.no_batch from "+ " detailjual inner join databarang inner join kodesatuan inner join jenis inner join detail_obat_racikan_jual "+ " on detailjual.kode_brng=databarang.kode_brng and databarang.kdjns=jenis.kdjns "+ " and detailjual.kode_sat=kodesatuan.kode_sat and detailjual.kode_brng=detail_obat_racikan_jual.kode_brng "+ " and detailjual.nota_jual=detail_obat_racikan_jual.nota_jual where "+ " detail_obat_racikan_jual.no_racik='"+rs2.getString("no_racik")+"' and detailjual.nota_jual='"+rs.getString("nota_jual")+"' "+sat+bar+" and detailjual.kode_brng like '%"+TCari.getText()+"%' or "+ " detail_obat_racikan_jual.no_racik='"+rs2.getString("no_racik")+"' and detailjual.nota_jual='"+rs.getString("nota_jual")+"' "+sat+bar+" and databarang.nama_brng like '%"+TCari.getText()+"%' or "+ " detail_obat_racikan_jual.no_racik='"+rs2.getString("no_racik")+"' and detailjual.nota_jual='"+rs.getString("nota_jual")+"' "+sat+bar+" and detailjual.kode_sat like '%"+TCari.getText()+"%' or "+ " detail_obat_racikan_jual.no_racik='"+rs2.getString("no_racik")+"' and detailjual.nota_jual='"+rs.getString("nota_jual")+"' "+sat+bar+" and jenis.nama like '%"+TCari.getText()+"%' order by detailjual.kode_brng"); try { rs3=ps3.executeQuery(); while(rs3.next()){ subttlall=subttlall+rs3.getDouble(7); ttlsubttl=ttlsubttl+rs3.getDouble(7); subttldisc=subttldisc+rs3.getDouble(9); ttldisc=ttldisc+rs3.getDouble(9); subttltambahan=subttltambahan+rs3.getDouble(10); ttltambahan=ttltambahan+rs3.getDouble(10); subttlembalase=subttlembalase+rs3.getDouble(11); ttlembalase=ttlembalase+rs3.getDouble(11); subttltuslah=subttltuslah+rs3.getDouble(12); ttltuslah=ttltuslah+rs3.getDouble(12); ttljual=ttljual+rs3.getDouble(14); subttljual=subttljual+rs3.getDouble(14); htmlContent.append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( ""); } } catch (Exception e) { System.out.println("Notifikasi : "+e); } finally{ if(rs3!=null){ rs3.close(); } if(ps3!=null){ ps3.close(); } } } } catch (Exception e) { System.out.println("Notifikasi : "+e); } finally{ if(rs2!=null){ rs2.close(); } if(ps2!=null){ ps2.close(); } } htmlContent.append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( "").append( ""); htmlContent.append( "
No.Kode BarangNama BarangJmlSatuanHarga(Rp)Subtotal(Rp)Ptg(%)Potongan(Rp)Tambahan(Rp)Embalase(Rp)Tuslah(Rp)Total(Rp)Aturan PakaiNo.Batch
").append(no).append("").append(rs2.getString("kode_brng")).append("").append(rs2.getString("nama_brng")).append("").append(rs2.getString("jumlah")).append("").append(rs2.getString("satuan")).append("").append(Valid.SetAngka(rs2.getDouble("h_jual"))).append("").append(Valid.SetAngka(rs2.getDouble("subtotal"))).append("").append(Valid.SetAngka(rs2.getDouble("dis"))).append("").append(Valid.SetAngka(rs2.getDouble("bsr_dis"))).append("").append(Valid.SetAngka(rs2.getDouble("tambahan"))).append("").append(Valid.SetAngka(rs2.getDouble("embalase"))).append("").append(Valid.SetAngka(rs2.getDouble("tuslah"))).append("").append(Valid.SetAngka(rs2.getDouble("total"))).append("").append(rs2.getString("aturan_pakai")).append("").append(rs2.getString("no_batch")).append("
").append(no).append("").append(rs2.getString("no_racik")).append(". ").append(rs2.getString("nama_racik")).append("").append(rs2.getString("jml_dr")).append(" ").append(rs2.getString("metode")).append("").append(rs2.getString("keterangan")).append("").append(rs2.getString("aturan_pakai")).append("
").append(rs3.getString("kode_brng")).append("").append(rs3.getString("nama_brng")).append("").append(rs3.getString("jumlah")).append("").append(rs3.getString("satuan")).append("").append(Valid.SetAngka(rs3.getDouble("h_jual"))).append("").append(Valid.SetAngka(rs3.getDouble("subtotal"))).append("").append(Valid.SetAngka(rs3.getDouble("dis"))).append("").append(Valid.SetAngka(rs3.getDouble("bsr_dis"))).append("").append(Valid.SetAngka(rs3.getDouble("tambahan"))).append("").append(Valid.SetAngka(rs3.getDouble("embalase"))).append("").append(Valid.SetAngka(rs3.getDouble("tuslah"))).append("").append(Valid.SetAngka(rs3.getDouble("total"))).append("").append(rs3.getString("aturan_pakai")).append("").append(rs3.getString("no_batch")).append("
Status : ").append(rs.getString("status")).append("Total :").append(df2.format(subttlall)).append("").append(df2.format(subttldisc)).append("").append(df2.format(subttltambahan)).append("").append(df2.format(subttlembalase)).append("").append(df2.format(subttltuslah)).append("").append(df2.format(subttljual)).append("
").append( "").append( ""); } } catch (Exception e) { System.out.println("Notif : "+e); } finally{ if(rs!=null){ rs.close(); } if(ps!=null){ ps.close(); } } LTotal.setText(df2.format(ttljual+ttlongkir+ttlppn)); if(ttljual>0){ totaljual= ""+ ""+ ""+ ""+ ""+ ""+ ""+ ""+ ""+ "
Jml.Subtotal : "+df2.format(ttlsubttl)+"Jml.Diskon : "+df2.format(ttldisc)+"Jml.Tambahan : "+df2.format(ttltambahan)+"Jml.Embalase : "+df2.format(ttlembalase)+"Jml.Tuslah : "+df2.format(ttltuslah)+"Jml.Total : "+df2.format(ttljual+ttlongkir+ttlppn)+"
"; } LoadHTML1.setText( ""+ ""+ htmlContent.toString()+ "
"+totaljual+ ""); htmlContent=null; }catch (Exception e) { System.out.println("Notif : "+e); } this.setCursor(Cursor.getDefaultCursor()); } public void emptTeks() { kdbar.setText(""); nmbar.setText(""); kdsat.setText(""); kdbar.requestFocus(); } public void isCek(){ BtnPrint.setEnabled(akses.getpenjualan_obat()); ppCetakNota.setEnabled(akses.getpenjualan_obat()); ppHapus.setEnabled(akses.getpenjualan_obat()); } private void tampilAkunBayar() { try{ file=new File("./cache/akunbayar.iyem"); file.createNewFile(); fileWriter = new FileWriter(file); StringBuilder iyembuilder = new StringBuilder(); ps=koneksi.prepareStatement("select * from akun_bayar order by akun_bayar.nama_bayar"); try{ rs=ps.executeQuery(); AkunBayar.removeAllItems(); while(rs.next()){ AkunBayar.addItem(rs.getString(1).replaceAll("\"","")); iyembuilder.append("{\"NamaAkun\":\"").append(rs.getString(1).replaceAll("\"","")).append("\",\"KodeRek\":\"").append(rs.getString(2)).append("\",\"PPN\":\"").append(rs.getDouble(3)).append("\"},"); } }catch (Exception e) { System.out.println("Notifikasi : "+e); } finally{ if(rs != null){ rs.close(); } if(ps != null){ ps.close(); } } if (iyembuilder.length() > 0) { iyembuilder.setLength(iyembuilder.length() - 1); fileWriter.write("{\"akunbayar\":["+iyembuilder+"]}"); fileWriter.flush(); } fileWriter.close(); iyembuilder=null; } catch (Exception e) { System.out.println("Notifikasi : "+e); } } }