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 java.text.DecimalFormat;
import java.util.Date;
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 keuangan.DlgBayarPiutang;
import keuangan.Jurnal;
import kepegawaian.DlgCariPetugas;
import simrskhanza.DlgCariPasien;
public class DlgCariPiutang extends javax.swing.JDialog {
private final DefaultTableModel tabMode;
private sekuel Sequel=new sekuel();
private validasi Valid=new validasi();
private PreparedStatement ps,ps2;
private ResultSet rs,rs2;
private Jurnal jur=new Jurnal();
private riwayatobat Trackobat=new riwayatobat();
private Connection koneksi=koneksiDB.condb();
public DlgCariPasien member=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,subttljual=0,ttldisc=0,subttldisc=0,ttlall=0,
subttlall=0,sisapiutang=0,cicilan=0,telat=0;
private String status="",aktifkanbatch="no",nofak="",mem="",ptg="",sat="",bar="",tanggal="",kodedokter="",namadokter="",nomorrm="";
private int no=0,i=0;
private boolean sukses=true;
/** Creates new form DlgProgramStudi
* @param parent
* @param modal */
public DlgCariPiutang(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","Tanggal","Petugas","Pasien","Catatan","Jenis","PPN","OngKir","Uang Muka","Piutang",""
}){
@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 < 11; 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(300);
}else if(i==4){
column.setPreferredWidth(120);
}else if(i==5){
column.setPreferredWidth(75);
}else if(i==6){
column.setPreferredWidth(50);
}else if(i==7){
column.setPreferredWidth(90);
}else if(i==8){
column.setPreferredWidth(90);
}else if(i==9){
column.setPreferredWidth(80);
}else if(i==10){
column.setPreferredWidth(100);
}
}
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();
}
}
});
}
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("DlgCariPiutang")){
if(member.getTable().getSelectedRow()!= -1){
kdmem.setText(member.getTable().getValueAt(member.getTable().getSelectedRow(),0).toString());
nmmem.setText(member.getTable().getValueAt(member.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) {}
});
member.getTable().addKeyListener(new KeyListener() {
@Override
public void keyTyped(KeyEvent e) {}
@Override
public void keyPressed(KeyEvent e) {
if(akses.getform().equals("DlgCariPiutang")){
if(e.getKeyCode()==KeyEvent.VK_SPACE){
member.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("DlgCariPiutang")){
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("DlgCariPiutang")){
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("DlgCariPiutang")){
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("DlgCariPiutang")){
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) {}
});
}
/** 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();
MnDetailCicilan = new javax.swing.JMenuItem();
ppResepObat = new javax.swing.JMenuItem();
ppResepObat1 = new javax.swing.JMenuItem();
ppResepObat2 = new javax.swing.JMenuItem();
ppLembarObat = new javax.swing.JMenuItem();
ppLembarObat1 = new javax.swing.JMenuItem();
internalFrame1 = new widget.InternalFrame();
scrollPane1 = new widget.ScrollPane();
tbDokter = new widget.Table();
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();
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();
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.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));
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 Piutang");
ppHapus.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));
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);
MnDetailCicilan.setBackground(new java.awt.Color(255, 255, 254));
MnDetailCicilan.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N
MnDetailCicilan.setForeground(new java.awt.Color(50, 50, 50));
MnDetailCicilan.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/category.png"))); // NOI18N
MnDetailCicilan.setText("Bayar Piutang");
MnDetailCicilan.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));
MnDetailCicilan.setName("MnDetailCicilan"); // NOI18N
MnDetailCicilan.setPreferredSize(new java.awt.Dimension(190, 25));
MnDetailCicilan.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
MnDetailCicilanActionPerformed(evt);
}
});
jPopupMenu1.add(MnDetailCicilan);
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);
ppLembarObat.setBackground(new java.awt.Color(255, 255, 254));
ppLembarObat.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N
ppLembarObat.setForeground(new java.awt.Color(50, 50, 50));
ppLembarObat.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/category.png"))); // NOI18N
ppLembarObat.setText("Lembar Pemberian Obat 1");
ppLembarObat.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
ppLembarObat.setHorizontalTextPosition(javax.swing.SwingConstants.RIGHT);
ppLembarObat.setName("ppLembarObat"); // NOI18N
ppLembarObat.setPreferredSize(new java.awt.Dimension(190, 25));
ppLembarObat.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
ppLembarObatActionPerformed(evt);
}
});
jPopupMenu1.add(ppLembarObat);
ppLembarObat1.setBackground(new java.awt.Color(255, 255, 254));
ppLembarObat1.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N
ppLembarObat1.setForeground(new java.awt.Color(50, 50, 50));
ppLembarObat1.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/category.png"))); // NOI18N
ppLembarObat1.setText("Lembar Pemberian Obat 2");
ppLembarObat1.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
ppLembarObat1.setHorizontalTextPosition(javax.swing.SwingConstants.RIGHT);
ppLembarObat1.setName("ppLembarObat1"); // NOI18N
ppLembarObat1.setPreferredSize(new java.awt.Dimension(190, 25));
ppLembarObat1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
ppLembarObat1ActionPerformed(evt);
}
});
jPopupMenu1.add(ppLembarObat1);
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 Piutang 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));
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);
internalFrame1.add(scrollPane1, java.awt.BorderLayout.CENTER);
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(295, 10, 90, 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(389, 10, 110, 23);
nmbar.setEditable(false);
nmbar.setName("nmbar"); // NOI18N
nmbar.setPreferredSize(new java.awt.Dimension(207, 23));
panelisi4.add(nmbar);
nmbar.setBounds(501, 10, 270, 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(0, 10, 70, 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(75, 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(248, 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(130, 10, 115, 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(70, 23));
panelisi1.add(label10);
TCari.setName("TCari"); // NOI18N
TCari.setPreferredSize(new java.awt.Dimension(170, 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(152, 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, 224, 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, 100, 23);
label16.setText("Pasien :");
label16.setName("label16"); // NOI18N
label16.setPreferredSize(new java.awt.Dimension(60, 23));
panelisi3.add(label16);
label16.setBounds(385, 10, 60, 23);
label13.setText("Petugas :");
label13.setName("label13"); // NOI18N
label13.setPreferredSize(new java.awt.Dimension(70, 23));
panelisi3.add(label13);
label13.setBounds(385, 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(449, 10, 80, 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(449, 40, 80, 23);
nmmem.setName("nmmem"); // NOI18N
nmmem.setPreferredSize(new java.awt.Dimension(207, 23));
panelisi3.add(nmmem);
nmmem.setBounds(531, 10, 240, 23);
nmptg.setEditable(false);
nmptg.setName("nmptg"); // NOI18N
nmptg.setPreferredSize(new java.awt.Dimension(207, 23));
panelisi3.add(nmptg);
nmptg.setBounds(531, 40, 240, 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(173, 40, 27, 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(198, 40, 100, 23);
internalFrame1.add(panelisi3, java.awt.BorderLayout.PAGE_START);
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("DlgCariPiutang");
member.emptTeks();
member.isCek();
member.setSize(internalFrame1.getWidth()-20,internalFrame1.getHeight()-20);
member.setLocationRelativeTo(internalFrame1);
member.setAlwaysOnTop(false);
member.setVisible(true);
}//GEN-LAST:event_btnPasienActionPerformed
private void BtnPetugasActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnPetugasActionPerformed
akses.setform("DlgCariPiutang");
petugas.emptTeks();
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,kdmem);
}//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 nama_brng from databarang where kode_brng=?", nmbar,kdbar.getText());
}else if(evt.getKeyCode()==KeyEvent.VK_PAGE_UP){
Sequel.cariIsi("select nama_brng from databarang where kode_brng=?", nmbar,kdbar.getText());
kdsat.requestFocus();
}else if(evt.getKeyCode()==KeyEvent.VK_ENTER){
Sequel.cariIsi("select nama_brng from databarang where 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("DlgCariPiutang");
barang.emptTeks();
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("DlgCariPiutang");
barang.jenis.emptTeks();
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
tampil();
}//GEN-LAST:event_BtnCariActionPerformed
private void BtnCariKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnCariKeyPressed
if(evt.getKeyCode()==KeyEvent.VK_SPACE){
BtnCariActionPerformed(null);
}else{
Valid.pindah(evt, TCari, BtnAll);
}
}//GEN-LAST:event_BtnCariKeyPressed
private void 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("");
tampil();
}//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));
BtnCariActionPerformed(evt);
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(int 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("rptPiutang.jasper","report","::[ Transaksi Piutang Barang ]::","select * from temporary where temporary.temp37='"+akses.getalamatip()+"' order by temporary.no",param);
}
this.setCursor(Cursor.getDefaultCursor());
}//GEN-LAST:event_BtnPrintActionPerformed
private void BtnPrintKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnPrintKeyPressed
if(evt.getKeyCode()==KeyEvent.VK_SPACE){
BtnPrintActionPerformed(null);
}else{
Valid.pindah(evt,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/NotaApotek4.php?nonota="+tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString()+"&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.Faktur");
}else{
try {
ps=koneksi.prepareStatement(
"select piutang.nota_piutang, piutang.kd_bangsal from piutang where piutang.nota_piutang=?");
try {
ps.setString(1,tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString());
rs=ps.executeQuery();
if(rs.next()){
Sequel.AutoComitFalse();
sukses=true;
ps2=koneksi.prepareStatement(
"select detailpiutang.kode_brng,detailpiutang.jumlah,detailpiutang.no_batch,detailpiutang.no_faktur from detailpiutang where detailpiutang.nota_piutang=? ");
try {
ps2.setString(1,rs.getString(1));
rs2=ps2.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,"Piutang",akses.getkode(),rs.getString("kd_bangsal"),"Hapus",rs2.getString("no_batch"),rs2.getString("no_faktur"),rs.getString("nota_piutang"));
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,"Piutang",akses.getkode(),rs.getString("kd_bangsal"),"Hapus","","",rs.getString("nota_piutang"));
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("Notif : "+e);
} finally{
if(rs2!=null){
rs2.close();
}
if(ps2!=null){
ps2.close();
}
}
if(sukses==true){
Sequel.queryu("delete from tampjurnal");
if(Sequel.menyimpantf2("tampjurnal","'"+Sequel.cariIsi("select Piutang_Obat from set_akun")+"','PIUTANG PASIEN','0','"+Sequel.cariIsi("select sisapiutang from piutang where nota_piutang='"+rs.getString("nota_piutang")+"'")+"'","Rekening")==false){
sukses=false;
}
if(Sequel.menyimpantf2("tampjurnal","'"+Sequel.cariIsi("select Kontra_Piutang_Obat from set_akun")+"','KAS DI TANGAN','"+Sequel.cariIsi("select sisapiutang from piutang where nota_piutang='"+rs.getString("nota_piutang")+"'")+"','0'","Rekening")==false){
sukses=false;
}
if(sukses==true){
sukses=jur.simpanJurnal(rs.getString("nota_piutang"),"U","BATAL PIUTANG OBAT 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 piutang where nota_piutang='"+tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString()+"'");
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("Notif : "+e);
} finally{
if(rs!=null){
rs.close();
}
if(ps!=null){
ps.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();
}//GEN-LAST:event_formWindowOpened
private void MnDetailCicilanActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_MnDetailCicilanActionPerformed
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));
DlgBayarPiutang bayarpiutang=new DlgBayarPiutang(null,false);
bayarpiutang.emptTeks();
String norm=Sequel.cariIsi("select no_rkm_medis from piutang where nota_piutang='"+tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString()+"'");
String nama=Sequel.cariIsi("select pasien.nm_pasien from pasien where pasien.no_rkm_medis='"+norm+"'");
bayarpiutang.setData(tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString(),norm,nama);
bayarpiutang.tampil();
bayarpiutang.setSize(this.getWidth()-20,this.getHeight()-20);
bayarpiutang.setLocationRelativeTo(this);
bayarpiutang.setAlwaysOnTop(false);
bayarpiutang.setVisible(true);
this.setCursor(Cursor.getDefaultCursor());
}
}
}//GEN-LAST:event_MnDetailCicilanActionPerformed
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());
param.put("logo",Sequel.cariGambar("select setting.logo from setting"));
if(Sequel.cariInteger(
"select count(*) from detailpiutang where nota_piutang=? and aturan_pakai<>''",tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim())>0){
Valid.MyReportqry("rptItemResepPiutang.jasper","report","::[ Aturan Pakai Obat ]::",
"select piutang.nota_piutang,piutang.tgl_piutang, "+
"piutang.no_rkm_medis,piutang.nm_pasien,databarang.nama_brng,"+
"detailpiutang.aturan_pakai,detailpiutang.jumlah,kodesatuan.satuan "+
"from piutang inner join detailpiutang on piutang.nota_piutang=detailpiutang.nota_piutang "+
"inner join databarang on detailpiutang.kode_brng=databarang.kode_brng "+
"inner join kodesatuan on databarang.kode_sat=kodesatuan.kode_sat "+
"where piutang.nota_piutang='"+tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim()+"' and detailpiutang.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());
param.put("logo",Sequel.cariGambar("select setting.logo from setting"));
if(Sequel.cariInteger(
"select count(*) from detailpiutang where nota_piutang=? and aturan_pakai<>''",tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim())>0){
Valid.MyReportqry("rptItemResepPiutang2.jasper","report","::[ Aturan Pakai Obat ]::",
"select piutang.nota_piutang,piutang.tgl_piutang, "+
"piutang.no_rkm_medis,piutang.nm_pasien,databarang.nama_brng,"+
"detailpiutang.aturan_pakai,detailpiutang.jumlah,kodesatuan.satuan,jenis.nama as jenis "+
"from piutang inner join detailpiutang on piutang.nota_piutang=detailpiutang.nota_piutang "+
"inner join databarang on detailpiutang.kode_brng=databarang.kode_brng "+
"inner join kodesatuan on databarang.kode_sat=kodesatuan.kode_sat "+
"inner join jenis on databarang.kdjns=jenis.kdjns "+
"where piutang.nota_piutang='"+tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim()+"' and detailpiutang.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());
param.put("logo",Sequel.cariGambar("select setting.logo from setting"));
if(Sequel.cariInteger(
"select count(*) from detailpiutang where nota_piutang=? and aturan_pakai<>''",tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim())>0){
Valid.MyReportqry("rptItemResepPiutang3.jasper","report","::[ Aturan Pakai Obat ]::",
"select piutang.nota_piutang,piutang.tgl_piutang, "+
"piutang.no_rkm_medis,piutang.nm_pasien,databarang.nama_brng,"+
"detailpiutang.aturan_pakai,detailpiutang.jumlah,kodesatuan.satuan "+
"from piutang inner join detailpiutang on piutang.nota_piutang=detailpiutang.nota_piutang "+
"inner join databarang on detailpiutang.kode_brng=databarang.kode_brng "+
"inner join kodesatuan on databarang.kode_sat=kodesatuan.kode_sat "+
"where piutang.nota_piutang='"+tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim()+"' and detailpiutang.aturan_pakai<>''",param);
}
this.setCursor(Cursor.getDefaultCursor());
}
}
}//GEN-LAST:event_ppResepObat2ActionPerformed
private void ppLembarObatActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_ppLembarObatActionPerformed
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{
kodedokter=Sequel.cariIsi("select reg_periksa.kd_dokter from reg_periksa where reg_periksa.no_rawat=?",tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim());
if(kodedokter.equals("")){
JOptionPane.showMessageDialog(null,"Dokter Peresep tidak ditemukan, pastikan pasien berasal dari poli/unit..!!!");
}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("emailrs",akses.getemailrs());
param.put("kontakrs",akses.getkontakrs());
param.put("penanggung",Sequel.cariIsi("select penjab.png_jawab from penjab where penjab.kd_pj=?",Sequel.cariIsi("select reg_periksa.kd_pj from reg_periksa where reg_periksa.no_rawat=?",tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim())));
param.put("propinsirs",akses.getpropinsirs());
param.put("norawat",tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim());
nomorrm=Sequel.cariIsi("select reg_periksa.no_rkm_medis from reg_periksa where reg_periksa.no_rawat=?",tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim());
param.put("norm",nomorrm);
param.put("tanggal",tbDokter.getValueAt(tbDokter.getSelectedRow(),1).toString().trim());
param.put("pasien",Sequel.cariIsi("select pasien.nm_pasien from pasien where pasien.no_rkm_medis=?",nomorrm));
param.put("peresep",Sequel.cariIsi("select dokter.nm_dokter from dokter where dokter.kd_dokter=?",kodedokter));
param.put("noresep","R"+tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim());
param.put("logo",Sequel.cariGambar("select setting.logo from setting"));
Valid.MyReport("rptLembarPiutangObat.jasper",param,"::[ Lembar Pemberian Obat ]::");
this.setCursor(Cursor.getDefaultCursor());
}
}
}
}//GEN-LAST:event_ppLembarObatActionPerformed
private void ppLembarObat1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_ppLembarObat1ActionPerformed
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{
kodedokter=Sequel.cariIsi("select reg_periksa.kd_dokter from reg_periksa where reg_periksa.no_rawat=?",tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim());
if(kodedokter.equals("")){
JOptionPane.showMessageDialog(null,"Dokter Peresep tidak ditemukan, pastikan pasien berasal dari poli/unit..!!!");
}else{
this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR));
Sequel.queryu("delete from temporary_resep where temp37='"+akses.getalamatip()+"'");
try {
i=0;
ps=koneksi.prepareStatement(
"select databarang.nama_brng,detailpiutang.aturan_pakai,detailpiutang.jumlah,kodesatuan.satuan "+
"from detailpiutang inner join databarang on databarang.kode_brng=detailpiutang.kode_brng "+
"inner join kodesatuan on detailpiutang.kode_sat=kodesatuan.kode_sat "+
"where detailpiutang.nota_piutang=? and detailpiutang.aturan_pakai<>''");
try {
ps.setString(1,tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim());
rs=ps.executeQuery();
while(rs.next()){
Sequel.menyimpan("temporary_resep","?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?",38,new String[]{
""+i,rs.getString("nama_brng"),rs.getString("aturan_pakai"),rs.getString("jumlah"),rs.getString("satuan"),"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",akses.getalamatip()
});
i++;
}
} catch (Exception e) {
System.out.println("Notif 1 : "+e);
} finally{
if(rs!=null){
rs.close();
}
if(ps!=null){
ps.close();
}
}
} catch (Exception e) {
System.out.println("Notif : "+e);
}
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("emailrs",akses.getemailrs());
param.put("kontakrs",akses.getkontakrs());
param.put("penanggung",Sequel.cariIsi("select penjab.png_jawab from penjab where penjab.kd_pj=?",Sequel.cariIsi("select reg_periksa.kd_pj from reg_periksa where reg_periksa.no_rawat=?",tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim())));
param.put("propinsirs",akses.getpropinsirs());
param.put("norawat",tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim());
mem=Sequel.cariIsi("select reg_periksa.no_rkm_medis from reg_periksa where reg_periksa.no_rawat=?",tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim());
param.put("norm",mem);
param.put("tanggal",tbDokter.getValueAt(tbDokter.getSelectedRow(),1).toString().trim());
param.put("pasien",Sequel.cariIsi("select pasien.nm_pasien from pasien where pasien.no_rkm_medis=?",mem));
namadokter=Sequel.cariIsi("select dokter.nm_dokter from dokter where dokter.kd_dokter=?",kodedokter);
param.put("peresep",namadokter);
param.put("noresep","R"+tbDokter.getValueAt(tbDokter.getSelectedRow(),0).toString().trim());
Sequel.cariIsi("select sha1(sidikjari.sidikjari) from sidikjari inner join pegawai on pegawai.id=sidikjari.id where pegawai.nik=?",kodedokter);
param.put("finger","Dikeluarkan di "+akses.getnamars()+", Kabupaten/Kota "+akses.getkabupatenrs()+"\nDitandatangani secara elektronik oleh "+namadokter+"\nID "+(bar.equals("")?kodedokter:bar)+"\n"+Valid.SetTgl3(tbDokter.getValueAt(tbDokter.getSelectedRow(),1).toString().trim()));
param.put("logo",Sequel.cariGambar("select setting.logo from setting"));
Valid.MyReportqry("rptLembarPiutangObat2.jasper","report","::[ Lembar Pemberian Obat ]::","select * from temporary_resep where temporary_resep.temp37='"+akses.getalamatip()+"' order by temporary_resep.no",param);
this.setCursor(Cursor.getDefaultCursor());
}
}
}
}//GEN-LAST:event_ppLembarObat1ActionPerformed
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(() -> {
DlgCariPiutang dialog = new DlgCariPiutang(new javax.swing.JFrame(), true);
dialog.addWindowListener(new java.awt.event.WindowAdapter() {
@Override
public void windowClosing(java.awt.event.WindowEvent e) {
System.exit(0);
}
});
dialog.setVisible(true);
});
}
// Variables declaration - do not modify//GEN-BEGIN:variables
private widget.Button BtnAll;
private widget.Button BtnBarang;
private widget.Button BtnCari;
private widget.Button BtnKeluar;
private widget.Button BtnPetugas;
private widget.Button BtnPrint;
private widget.Label LTotal;
private javax.swing.JMenuItem MnDetailCicilan;
private widget.TextBox NoNota;
private widget.TextBox TCari;
private widget.Tanggal Tgl1;
private widget.Tanggal Tgl2;
private widget.Button btnPasien;
private widget.Button btnSatuan;
private widget.InternalFrame internalFrame1;
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 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 ppLembarObat;
private javax.swing.JMenuItem ppLembarObat1;
private javax.swing.JMenuItem ppResepObat;
private javax.swing.JMenuItem ppResepObat1;
private javax.swing.JMenuItem ppResepObat2;
private widget.ScrollPane scrollPane1;
private widget.Table tbDokter;
// End of variables declaration//GEN-END:variables
private void tampil() {
tanggal=" piutang.tgl_piutang between '"+Valid.SetTgl(Tgl1.getSelectedItem()+"")+"' and '"+Valid.SetTgl(Tgl2.getSelectedItem()+"")+"' ";
nofak="";mem="";ptg="";sat="";bar="";
if(!NoNota.getText().equals("")){
nofak=" and piutang.nota_piutang='"+NoNota.getText()+"' ";
}
if(!nmmem.getText().equals("")){
mem=" and piutang.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()+"' ";
}
Valid.tabelKosong(tabMode);
try{
ttljual=0;
ttldisc=0;
ttlall=0;
ps=koneksi.prepareStatement(
"select piutang.nota_piutang, piutang.tgl_piutang, "+
"piutang.nip,petugas.nama, "+
"piutang.no_rkm_medis,piutang.nm_pasien, "+
"piutang.catatan,piutang.jns_jual,piutang.ppn,piutang.ongkir,"+
"piutang.uangmuka,piutang.sisapiutang,piutang.tgltempo,bangsal.nm_bangsal "+
"from piutang inner join petugas on piutang.nip=petugas.nip "+
"inner join bangsal on piutang.kd_bangsal=bangsal.kd_bangsal "+
"inner join detailpiutang on piutang.nota_piutang=detailpiutang.nota_piutang "+
"inner join databarang on detailpiutang.kode_brng=databarang.kode_brng "+
"inner join jenis on databarang.kdjns=jenis.kdjns "+
"inner join kodesatuan on detailpiutang.kode_sat=kodesatuan.kode_sat "+
"where "+tanggal+nofak+mem+ptg+sat+bar+" and "+
"(piutang.nota_piutang like '%"+TCari.getText()+"%' or piutang.no_rkm_medis like '%"+TCari.getText()+"%' or "+
"piutang.nm_pasien like '%"+TCari.getText()+"%' or piutang.nip like '%"+TCari.getText()+"%' or "+
"petugas.nama like '%"+TCari.getText()+"%' or piutang.catatan like '%"+TCari.getText()+"%' or "+
"bangsal.nm_bangsal like '%"+TCari.getText()+"%' or piutang.jns_jual like '%"+TCari.getText()+"%' or "+
"detailpiutang.kode_brng like '%"+TCari.getText()+"%' or databarang.nama_brng like '%"+TCari.getText()+"%' or "+
"detailpiutang.kode_sat like '%"+TCari.getText()+"%' or jenis.nama like '%"+TCari.getText()+"%') "+
" group by piutang.nota_piutang order by piutang.tgl_piutang,piutang.nota_piutang ");
try {
rs=ps.executeQuery();
while(rs.next()){
tabMode.addRow(new Object[]{
rs.getString(1),rs.getString(2),rs.getString(3)+", "+rs.getString(4),rs.getString(5)+", "+rs.getString(6),rs.getString(7),rs.getString(8),df2.format(rs.getDouble(9)),df2.format(rs.getDouble(10)),df2.format(rs.getDouble(11)),df2.format(rs.getDouble(12)),""
});
tabMode.addRow(new Object[]{"","No.Batch","No.Faktur","Piutang di "+rs.getString(13),"Satuan","Harga","Jml","Subtotal","Disk(%)","Diskon(Rp)","Total"});
subttlall=0;
subttldisc=0;
subttljual=0;
sisapiutang=0;
cicilan=0;
no=1;
ps2=koneksi.prepareStatement("select detailpiutang.kode_brng,databarang.nama_brng, detailpiutang.kode_sat,"+
" kodesatuan.satuan,detailpiutang.h_jual, detailpiutang.jumlah,detailpiutang.subtotal,detailpiutang.dis, "+
" detailpiutang.bsr_dis, detailpiutang.total,detailpiutang.no_batch,detailpiutang.no_faktur,detailpiutang.aturan_pakai "+
" from detailpiutang inner join databarang on detailpiutang.kode_brng=databarang.kode_brng "+
" inner join kodesatuan on detailpiutang.kode_sat=kodesatuan.kode_sat "+
" inner join jenis on databarang.kdjns=jenis.kdjns "+
" where detailpiutang.nota_piutang='"+rs.getString(1)+"' "+sat+bar+" and "+
" (detailpiutang.kode_brng like '%"+TCari.getText()+"%' or databarang.nama_brng like '%"+TCari.getText()+"%' or "+
" detailpiutang.kode_sat like '%"+TCari.getText()+"%' or jenis.nama like '%"+TCari.getText()+"%') "+
" order by detailpiutang.kode_brng ");
try {
rs2=ps2.executeQuery();
while(rs2.next()){
ttlall=ttlall+rs2.getDouble(7);
subttlall=subttlall+rs2.getDouble(7);
ttldisc=ttldisc+rs2.getDouble(9);
subttldisc=subttldisc+rs2.getDouble(9);
ttljual=ttljual+rs2.getDouble(10);
subttljual=subttljual+rs2.getDouble(10);
tabMode.addRow(new Object[]{
"",no+". "+rs2.getString("no_batch"),rs2.getString("no_faktur"),rs2.getString("kode_brng")+" "+rs2.getString("nama_brng")+" "+rs2.getString("aturan_pakai"),
rs2.getString("satuan"),df2.format(rs2.getDouble("h_jual")),rs2.getString("jumlah"),df2.format(rs2.getDouble("subtotal")),
rs2.getString("dis"),df2.format(rs2.getDouble("bsr_dis")),df2.format(rs2.getDouble("total"))
});
no++;
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs2!=null){
rs2.close();
}
if(ps2!=null){
ps2.close();
}
}
cicilan=Sequel.cariIsiAngka("select (sum(bayar_piutang.besar_cicilan)+sum(bayar_piutang.diskon_piutang)+sum(bayar_piutang.tidak_terbayar)) from bayar_piutang where bayar_piutang.no_rawat='"+rs.getString(1)+"' ");
sisapiutang=rs.getDouble(12)-cicilan;
if(sisapiutang<1){
status="Lunas";
}else if(sisapiutang>1){
telat=Sequel.cariIsiAngka("select TO_DAYS('"+rs.getString(13)+"')-TO_DAYS(current_date()) as day");
status="Belum Lunas"+(telat<0?", Telat Bayar":"");
}
tabMode.addRow(new Object[]{"","Total",":","","",""," ",df2.format(subttlall),"",df2.format(subttldisc),df2.format(subttljual)});
tabMode.addRow(new Object[]{"","Jatuh Tempo",": "+rs.getString(13),"Cicilan+Diskon Bayar+Tidak Terbayar",":","","","","","",df2.format(cicilan)});
tabMode.addRow(new Object[]{"","Status",": "+status,"Sisa Piutang",":","","","","","",df2.format(sisapiutang)});
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs!=null){
rs.close();
}
if(ps!=null){
ps.close();
}
}
LTotal.setText(df2.format(ttljual));
}catch(Exception e){
System.out.println("Notifikasi : "+e);
}
}
public void emptTeks() {
kdbar.setText("");
nmbar.setText("");
kdsat.setText("");
kdbar.requestFocus();
}
public void cariNoTagihan(String notagihan,Date Taggal){
NoNota.setText(notagihan);
Tgl1.setDate(Taggal);
Tgl2.setDate(Taggal);
tampil();
}
public void isCek(){
MnDetailCicilan.setEnabled(akses.getbayar_piutang());
BtnPrint.setEnabled(akses.getpiutang_obat());
ppCetakNota.setEnabled(akses.getpiutang_obat());
if(akses.getkode().equals("Admin Utama")){
ppHapus.setEnabled(true);
}else{
ppHapus.setEnabled(false);
}
}
}