/*
Dilarang keras menggandakan/mengcopy/menyebarkan/membajak/mendecompile
Software ini dalam bentuk apapun tanpa seijin pembuat software
(Khanza.Soft Media). Bagi yang sengaja membajak softaware ini ta
npa ijin, kami sumpahi sial 1000 turunan, miskin sampai 500 turu
nan. Selalu mendapat kecelakaan sampai 400 turunan. Anak pertama
nya cacat tidak punya kaki sampai 300 turunan. Susah cari jodoh
sampai umur 50 tahun sampai 200 turunan. Ya Alloh maafkan kami
karena telah berdoa buruk, semua ini kami lakukan karena kami ti
dak pernah rela karya kami dibajak tanpa ijin.
*/
package inventory;
import bridging.ApiPcare;
import com.fasterxml.jackson.databind.JsonNode;
import com.fasterxml.jackson.databind.ObjectMapper;
import fungsi.WarnaTable2;
import fungsi.batasInput;
import fungsi.koneksiDB;
import fungsi.sekuel;
import fungsi.validasi;
import fungsi.akses;
import java.awt.Cursor;
import java.awt.Dimension;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.KeyEvent;
import java.awt.event.KeyListener;
import java.awt.event.WindowEvent;
import java.awt.event.WindowListener;
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.util.Calendar;
import java.util.Date;
import javax.swing.JOptionPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.Timer;
import javax.swing.event.DocumentEvent;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableColumn;
import keuangan.Jurnal;
import org.apache.commons.codec.binary.Base64;
import org.springframework.http.HttpEntity;
import org.springframework.http.HttpHeaders;
import org.springframework.http.HttpMethod;
import org.springframework.http.MediaType;
import simrskhanza.DlgCariBangsal;
import widget.Button;
/**
*
* @author dosen
*/
public final class DlgCariObat extends javax.swing.JDialog {
private final DefaultTableModel tabModeobat,tabModeObatRacikan,tabModeDetailObatRacikan;
private sekuel Sequel=new sekuel();
private validasi Valid=new validasi();
private Connection koneksi=koneksiDB.condb();
private PreparedStatement psobat,pscarikapasitas,psstok,ps2,psbatch,psrekening;
private ResultSet rsobat,carikapasitas,rsstok,rs2,rsbatch,rsrekening;
private double h_belicari=0, hargacari=0, sisacari=0,y=0,embalase=Sequel.cariIsiAngka("select set_embalase.embalase_per_obat from set_embalase"),
tuslah=Sequel.cariIsiAngka("select set_embalase.tuslah_per_obat from set_embalase"),kenaikan=0,stokbarang=0,ttl=0,ppnobat=0,ttlhpp,ttljual;
private int i=0,z=0,row=0,row2,r;
private Jurnal jur=new Jurnal();
private String signa1="1",signa2="1",nokunjungan="",kdObatSK="",requestJson="",URL="",otorisasi,sql="",aktifpcare="no",no_batchcari="", tgl_kadaluarsacari="", no_fakturcari="", aktifkanbatch="no",kodedokter="",namadokter="",noresep="",bangsal="",bangsaldefault=Sequel.cariIsi("select set_lokasi.kd_bangsal from set_lokasi limit 1"),tampilkan_ppnobat_ralan="",
Suspen_Piutang_Obat_Ralan="",Obat_Ralan="",HPP_Obat_Rawat_Jalan="",Persediaan_Obat_Rawat_Jalan="",hppfarmasi="",VALIDASIULANGBERIOBAT="",DEPOAKTIFOBAT="",utc="";
private DlgCariBangsal caribangsal=new DlgCariBangsal(null,false);
private WarnaTable2 warna=new WarnaTable2();
private WarnaTable2 warna2=new WarnaTable2();
private WarnaTable2 warna3=new WarnaTable2();
private riwayatobat Trackobat=new riwayatobat();
private HttpHeaders headers;
private HttpEntity requestEntity;
private ObjectMapper mapper = new ObjectMapper();
private JsonNode root;
private JsonNode nameNode;
private JsonNode response;
private ApiPcare api=new ApiPcare();
private String[] arrSplit;
private boolean sukses=true;
private File file;
private FileWriter fileWriter;
private FileReader myObj;
/** Creates new form DlgPenyakit
* @param parent
* @param modal */
public DlgCariObat(java.awt.Frame parent, boolean modal) {
super(parent, modal);
initComponents();
this.setLocation(10,2);
setSize(656,250);
tabModeobat=new DefaultTableModel(null,new Object[]{
"K","Jumlah","Kode Barang","Nama Barang","Satuan","Kandungan",
"Harga(Rp)","Jenis Obat","Emb","Tsl","Stok","Aturan Pakai","I.F.",
"H.Beli","Kategori","Golongan","No.Batch","No.Faktur","Kadaluarsa"
}){
@Override public boolean isCellEditable(int rowIndex, int colIndex){
boolean a = false;
if ((colIndex==0)||(colIndex==1)||(colIndex==8)||(colIndex==9)||(colIndex==11)||(colIndex==16)||(colIndex==17)) {
a=true;
}
return a;
}
Class[] types = new Class[] {
java.lang.Boolean.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class,
java.lang.Object.class, java.lang.Object.class, java.lang.Double.class, java.lang.Object.class,
java.lang.Double.class, java.lang.Double.class, java.lang.Double.class, java.lang.Object.class,
java.lang.Object.class,java.lang.Double.class, java.lang.Object.class, java.lang.Object.class,
java.lang.Object.class, java.lang.Object.class, java.lang.Object.class
};
@Override
public Class getColumnClass(int columnIndex) {
return types [columnIndex];
}
};
tbObat.setModel(tabModeobat);
tbObat.setPreferredScrollableViewportSize(new Dimension(500,500));
tbObat.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
for (i = 0; i < 19; i++) {
TableColumn column = tbObat.getColumnModel().getColumn(i);
if(i==0){
column.setPreferredWidth(20);
}else if(i==1){
column.setPreferredWidth(45);
}else if(i==2){
column.setPreferredWidth(75);
}else if(i==3){
column.setPreferredWidth(200);
}else if(i==4){
column.setPreferredWidth(45);
}else if(i==5){
column.setMinWidth(0);
column.setMaxWidth(0);
}else if(i==6){
column.setPreferredWidth(70);
}else if(i==7){
column.setPreferredWidth(85);
}else if(i==8){
column.setPreferredWidth(40);
}else if(i==9){
column.setPreferredWidth(40);
}else if(i==10){
column.setPreferredWidth(40);
}else if(i==11){
column.setPreferredWidth(130);
}else if(i==12){
column.setPreferredWidth(85);
}else if(i==13){
column.setMinWidth(0);
column.setMaxWidth(0);
}else if(i==14){
column.setPreferredWidth(85);
}else if(i==15){
column.setPreferredWidth(85);
}else if(i==16){
column.setPreferredWidth(70);
}else if(i==17){
column.setPreferredWidth(100);
}else if(i==18){
column.setPreferredWidth(65);
}
}
warna.kolom=1;
tbObat.setDefaultRenderer(Object.class,warna);
tabModeObatRacikan=new DefaultTableModel(null,new Object[]{
"No","Nama Racikan","Kode Racik","Metode Racik","Jml.Racik",
"Aturan Pakai","Keterangan"
}){
@Override public boolean isCellEditable(int rowIndex, int colIndex){
boolean a = true;
if ((colIndex==0)||(colIndex==2)||(colIndex==3)) {
a=false;
}
return a;
}
Class[] types = new Class[] {
java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class,
java.lang.Object.class, java.lang.Object.class, java.lang.Object.class
};
@Override
public Class getColumnClass(int columnIndex) {
return types [columnIndex];
}
};
tbObatRacikan.setModel(tabModeObatRacikan);
tbObatRacikan.setPreferredScrollableViewportSize(new Dimension(500,500));
tbObatRacikan.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
for (i = 0; i < 7; i++) {
TableColumn column = tbObatRacikan.getColumnModel().getColumn(i);
if(i==0){
column.setPreferredWidth(25);
}else if(i==1){
column.setPreferredWidth(250);
}else if(i==2){
column.setMinWidth(0);
column.setMaxWidth(0);
}else if(i==3){
column.setPreferredWidth(100);
}else if(i==4){
column.setPreferredWidth(60);
}else if(i==5){
column.setPreferredWidth(200);
}else if(i==6){
column.setPreferredWidth(250);
}
}
warna2.kolom=4;
tbObatRacikan.setDefaultRenderer(Object.class,warna2);
tabModeDetailObatRacikan=new DefaultTableModel(null,new Object[]{
"No","Kode Barang","Nama Barang","Satuan","Harga(Rp)","H.Beli",
"Jenis Obat","Stok","Kps","Kandungan","Jml",
"Emb","Tsl","I.F.","Kategori","Golongan","No.Batch","No.Faktur","Kadaluarsa"
}){
@Override public boolean isCellEditable(int rowIndex, int colIndex){
boolean a = false;
if ((colIndex==9)||(colIndex==10)||(colIndex==11)||(colIndex==12)||(colIndex==13)||(colIndex==16)||(colIndex==17)) {
a=true;
}
return a;
}
Class[] types = new Class[] {
java.lang.Object.class, java.lang.Object.class, java.lang.Object.class,
java.lang.Object.class,
java.lang.Double.class, java.lang.Double.class, java.lang.Object.class,
java.lang.Double.class, java.lang.Double.class, java.lang.Object.class,
java.lang.Double.class, java.lang.Double.class, java.lang.Double.class,
java.lang.Object.class, java.lang.Object.class, java.lang.Object.class,
java.lang.Object.class, java.lang.Object.class, java.lang.Object.class
};
@Override
public Class getColumnClass(int columnIndex) {
return types [columnIndex];
}
};
tbDetailObatRacikan.setModel(tabModeDetailObatRacikan);
tbDetailObatRacikan.setPreferredScrollableViewportSize(new Dimension(500,500));
tbDetailObatRacikan.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
for (i = 0; i < 19; i++) {
TableColumn column = tbDetailObatRacikan.getColumnModel().getColumn(i);
if(i==0){
column.setPreferredWidth(25);
}else if(i==1){
column.setPreferredWidth(75);
}else if(i==2){
column.setPreferredWidth(200);
}else if(i==3){
column.setPreferredWidth(45);
}else if(i==4){
column.setPreferredWidth(70);
}else if(i==5){
column.setMinWidth(0);
column.setMaxWidth(0);
}else if(i==6){
column.setPreferredWidth(85);
}else if(i==7){
column.setPreferredWidth(40);
}else if(i==8){
column.setPreferredWidth(40);
}else if(i==9){
column.setPreferredWidth(70);
}else if(i==10){
column.setPreferredWidth(40);
}else if(i==11){
column.setPreferredWidth(40);
}else if(i==12){
column.setPreferredWidth(40);
}else if(i==13){
column.setPreferredWidth(85);
}else if(i==14){
column.setPreferredWidth(85);
}else if(i==15){
column.setPreferredWidth(85);
}else if(i==16){
column.setPreferredWidth(70);
}else if(i==17){
column.setPreferredWidth(100);
}else if(i==18){
column.setPreferredWidth(65);
}
}
warna3.kolom=9;
tbDetailObatRacikan.setDefaultRenderer(Object.class,warna3);
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){
BtnCariActionPerformed(null);
}
}
@Override
public void removeUpdate(DocumentEvent e) {
if(TCari.getText().length()>2){
BtnCariActionPerformed(null);
}
}
@Override
public void changedUpdate(DocumentEvent e) {
if(TCari.getText().length()>2){
BtnCariActionPerformed(null);
}
}
});
}
caribangsal.addWindowListener(new WindowListener() {
@Override
public void windowOpened(WindowEvent e) {}
@Override
public void windowClosing(WindowEvent e) {}
@Override
public void windowClosed(WindowEvent e) {
if(caribangsal.getTable().getSelectedRow()!= -1){
kdgudang.setText(caribangsal.getTable().getValueAt(caribangsal.getTable().getSelectedRow(),0).toString());
nmgudang.setText(caribangsal.getTable().getValueAt(caribangsal.getTable().getSelectedRow(),1).toString());
}
kdgudang.requestFocus();
}
@Override
public void windowIconified(WindowEvent e) {}
@Override
public void windowDeiconified(WindowEvent e) {}
@Override
public void windowActivated(WindowEvent e) {}
@Override
public void windowDeactivated(WindowEvent e) {}
});
try {
aktifkanbatch = koneksiDB.AKTIFKANBATCHOBAT();
if(aktifkanbatch.equals("no")){
ppStok.setVisible(true);
}else{
ppStok.setVisible(false);
}
otorisasi=koneksiDB.USERPCARE()+":"+koneksiDB.PASSPCARE()+":095";
URL=koneksiDB.URLAPIPCARE();
} catch (Exception e) {
System.out.println("E : "+e);
aktifkanbatch = "no";
ppStok.setVisible(true);
}
try {
hppfarmasi=koneksiDB.HPPFARMASI();
} catch (Exception e) {
hppfarmasi="dasar";
}
try {
VALIDASIULANGBERIOBAT=koneksiDB.VALIDASIULANGBERIOBAT();
} catch (Exception e) {
VALIDASIULANGBERIOBAT="no";
}
try {
DEPOAKTIFOBAT = koneksiDB.DEPOAKTIFOBAT();
} catch (Exception e) {
System.out.println("E : "+e);
DEPOAKTIFOBAT = "";
}
try {
psrekening=koneksi.prepareStatement(
"select set_akun_ralan.Suspen_Piutang_Obat_Ralan,set_akun_ralan.Obat_Ralan,set_akun_ralan.HPP_Obat_Rawat_Jalan,set_akun_ralan.Persediaan_Obat_Rawat_Jalan from set_akun_ralan");
try {
rsrekening=psrekening.executeQuery();
while(rsrekening.next()){
Suspen_Piutang_Obat_Ralan=rsrekening.getString("Suspen_Piutang_Obat_Ralan");
Obat_Ralan=rsrekening.getString("Obat_Ralan");
HPP_Obat_Rawat_Jalan=rsrekening.getString("HPP_Obat_Rawat_Jalan");
Persediaan_Obat_Rawat_Jalan=rsrekening.getString("Persediaan_Obat_Rawat_Jalan");
}
} catch (Exception e) {
System.out.println("Notif Rekening : "+e);
} finally{
if(rsrekening!=null){
rsrekening.close();
}
if(psrekening!=null){
psrekening.close();
}
}
} catch (Exception e) {
System.out.println(e);
}
tampilkan_ppnobat_ralan=Sequel.cariIsi("select set_nota.tampilkan_ppnobat_ralan from set_nota");
jam();
}
/** 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() {
Popup = new javax.swing.JPopupMenu();
ppBersihkan = new javax.swing.JMenuItem();
ppStok = new javax.swing.JMenuItem();
ppStok1 = new javax.swing.JMenuItem();
Kd2 = new widget.TextBox();
TNoRw = new widget.TextBox();
Tanggal = new widget.TextBox();
Jam = new widget.TextBox();
KdPj = new widget.TextBox();
internalFrame1 = new widget.InternalFrame();
panelisi3 = new widget.panelisi();
label9 = new widget.Label();
TCari = new widget.TextBox();
BtnCari = new widget.Button();
BtnAll = new widget.Button();
BtnTambah = new widget.Button();
BtnSeek5 = new widget.Button();
BtnTambah1 = new widget.Button();
BtnSimpan = new widget.Button();
BtnHapus = new widget.Button();
label13 = new widget.Label();
BtnKeluar = new widget.Button();
FormInput = new widget.PanelBiasa();
jLabel5 = new widget.Label();
LTotal = new widget.Label();
jLabel6 = new widget.Label();
LPpn = new widget.Label();
jLabel7 = new widget.Label();
LTotalTagihan = new widget.Label();
label12 = new widget.Label();
Jeniskelas = new widget.ComboBox();
ChkNoResep = new widget.CekBox();
jLabel8 = new widget.Label();
DTPTgl = new widget.Tanggal();
cmbJam = new widget.ComboBox();
cmbMnt = new widget.ComboBox();
cmbDtk = new widget.ComboBox();
ChkJln = new widget.CekBox();
label21 = new widget.Label();
kdgudang = new widget.TextBox();
nmgudang = new widget.TextBox();
BtnGudang = new widget.Button();
jLabel10 = new widget.Label();
jLabel11 = new widget.Label();
jLabel12 = new widget.Label();
TPasien = new widget.TextBox();
TNoRM = new widget.TextBox();
LblNoRawat = new widget.TextBox();
TabRawat = new javax.swing.JTabbedPane();
Scroll = new widget.ScrollPane();
tbObat = new widget.Table();
jPanel3 = new javax.swing.JPanel();
Scroll1 = new widget.ScrollPane();
tbObatRacikan = new widget.Table();
Scroll2 = new widget.ScrollPane();
tbDetailObatRacikan = new widget.Table();
Popup.setName("Popup"); // NOI18N
ppBersihkan.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N
ppBersihkan.setForeground(new java.awt.Color(50, 50, 50));
ppBersihkan.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/category.png"))); // NOI18N
ppBersihkan.setText("Bersihkan Jumlah");
ppBersihkan.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
ppBersihkan.setHorizontalTextPosition(javax.swing.SwingConstants.RIGHT);
ppBersihkan.setName("ppBersihkan"); // NOI18N
ppBersihkan.setPreferredSize(new java.awt.Dimension(200, 25));
ppBersihkan.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
ppBersihkanActionPerformed(evt);
}
});
Popup.add(ppBersihkan);
ppStok.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N
ppStok.setForeground(new java.awt.Color(50, 50, 50));
ppStok.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/category.png"))); // NOI18N
ppStok.setText("Tampilkan Semua Stok");
ppStok.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
ppStok.setHorizontalTextPosition(javax.swing.SwingConstants.RIGHT);
ppStok.setName("ppStok"); // NOI18N
ppStok.setPreferredSize(new java.awt.Dimension(200, 25));
ppStok.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
ppStokActionPerformed(evt);
}
});
Popup.add(ppStok);
ppStok1.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N
ppStok1.setForeground(new java.awt.Color(50, 50, 50));
ppStok1.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/category.png"))); // NOI18N
ppStok1.setText("Tampilkan Stok Lokasi Lain");
ppStok1.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
ppStok1.setHorizontalTextPosition(javax.swing.SwingConstants.RIGHT);
ppStok1.setName("ppStok1"); // NOI18N
ppStok1.setPreferredSize(new java.awt.Dimension(200, 25));
ppStok1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
ppStok1ActionPerformed(evt);
}
});
Popup.add(ppStok1);
Kd2.setHighlighter(null);
Kd2.setName("Kd2"); // NOI18N
Kd2.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
Kd2KeyPressed(evt);
}
});
TNoRw.setHighlighter(null);
TNoRw.setName("TNoRw"); // NOI18N
Tanggal.setHighlighter(null);
Tanggal.setName("Tanggal"); // NOI18N
Jam.setHighlighter(null);
Jam.setName("Jam"); // NOI18N
KdPj.setHighlighter(null);
KdPj.setName("KdPj"); // NOI18N
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
setUndecorated(true);
setResizable(false);
addWindowListener(new java.awt.event.WindowAdapter() {
public void windowActivated(java.awt.event.WindowEvent evt) {
formWindowActivated(evt);
}
});
internalFrame1.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(240, 245, 235)), "::[ Data 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.setFont(new java.awt.Font("Dialog", 0, 11)); // NOI18N
internalFrame1.setName("internalFrame1"); // NOI18N
internalFrame1.setLayout(new java.awt.BorderLayout(1, 1));
panelisi3.setName("panelisi3"); // NOI18N
panelisi3.setPreferredSize(new java.awt.Dimension(100, 43));
panelisi3.setLayout(new java.awt.FlowLayout(java.awt.FlowLayout.LEFT, 4, 9));
label9.setText("Key Word :");
label9.setName("label9"); // NOI18N
label9.setPreferredSize(new java.awt.Dimension(68, 23));
panelisi3.add(label9);
TCari.setToolTipText("Alt+C");
TCari.setName("TCari"); // NOI18N
TCari.setPreferredSize(new java.awt.Dimension(340, 23));
TCari.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
TCariKeyPressed(evt);
}
});
panelisi3.add(TCari);
BtnCari.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/accept.png"))); // NOI18N
BtnCari.setMnemonic('1');
BtnCari.setToolTipText("Alt+1");
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);
}
});
panelisi3.add(BtnCari);
BtnAll.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/Search-16x16.png"))); // NOI18N
BtnAll.setMnemonic('2');
BtnAll.setToolTipText("Alt+2");
BtnAll.setName("BtnAll"); // NOI18N
BtnAll.setPreferredSize(new java.awt.Dimension(28, 23));
BtnAll.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
BtnAllActionPerformed(evt);
}
});
BtnAll.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
BtnAllKeyPressed(evt);
}
});
panelisi3.add(BtnAll);
BtnTambah.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/plus_16.png"))); // NOI18N
BtnTambah.setMnemonic('3');
BtnTambah.setToolTipText("Alt+3");
BtnTambah.setName("BtnTambah"); // NOI18N
BtnTambah.setPreferredSize(new java.awt.Dimension(28, 23));
BtnTambah.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
BtnTambahActionPerformed(evt);
}
});
panelisi3.add(BtnTambah);
BtnSeek5.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/011.png"))); // NOI18N
BtnSeek5.setMnemonic('4');
BtnSeek5.setToolTipText("Alt+4");
BtnSeek5.setName("BtnSeek5"); // NOI18N
BtnSeek5.setPreferredSize(new java.awt.Dimension(28, 23));
BtnSeek5.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
BtnSeek5ActionPerformed(evt);
}
});
BtnSeek5.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
BtnSeek5KeyPressed(evt);
}
});
panelisi3.add(BtnSeek5);
BtnTambah1.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/category.png"))); // NOI18N
BtnTambah1.setMnemonic('3');
BtnTambah1.setToolTipText("Alt+3");
BtnTambah1.setName("BtnTambah1"); // NOI18N
BtnTambah1.setPreferredSize(new java.awt.Dimension(28, 23));
BtnTambah1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
BtnTambah1ActionPerformed(evt);
}
});
panelisi3.add(BtnTambah1);
BtnSimpan.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/save-16x16.png"))); // NOI18N
BtnSimpan.setMnemonic('S');
BtnSimpan.setToolTipText("Alt+S");
BtnSimpan.setName("BtnSimpan"); // NOI18N
BtnSimpan.setPreferredSize(new java.awt.Dimension(28, 23));
BtnSimpan.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
BtnSimpanActionPerformed(evt);
}
});
panelisi3.add(BtnSimpan);
BtnHapus.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/stop_f2.png"))); // NOI18N
BtnHapus.setMnemonic('H');
BtnHapus.setToolTipText("Alt+H");
BtnHapus.setName("BtnHapus"); // NOI18N
BtnHapus.setPreferredSize(new java.awt.Dimension(28, 23));
BtnHapus.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
BtnHapusActionPerformed(evt);
}
});
panelisi3.add(BtnHapus);
label13.setName("label13"); // NOI18N
label13.setPreferredSize(new java.awt.Dimension(65, 23));
panelisi3.add(label13);
BtnKeluar.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/exit.png"))); // NOI18N
BtnKeluar.setMnemonic('5');
BtnKeluar.setToolTipText("Alt+5");
BtnKeluar.setName("BtnKeluar"); // NOI18N
BtnKeluar.setPreferredSize(new java.awt.Dimension(28, 23));
BtnKeluar.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
BtnKeluarActionPerformed(evt);
}
});
panelisi3.add(BtnKeluar);
internalFrame1.add(panelisi3, java.awt.BorderLayout.PAGE_END);
FormInput.setBackground(new java.awt.Color(215, 225, 215));
FormInput.setName("FormInput"); // NOI18N
FormInput.setPreferredSize(new java.awt.Dimension(100, 103));
FormInput.setLayout(null);
jLabel5.setText("Total :");
jLabel5.setName("jLabel5"); // NOI18N
jLabel5.setPreferredSize(new java.awt.Dimension(45, 23));
FormInput.add(jLabel5);
jLabel5.setBounds(4, 70, 65, 23);
LTotal.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
LTotal.setText("0");
LTotal.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
LTotal.setName("LTotal"); // NOI18N
LTotal.setPreferredSize(new java.awt.Dimension(80, 23));
FormInput.add(LTotal);
LTotal.setBounds(72, 70, 80, 23);
jLabel6.setText("PPN :");
jLabel6.setName("jLabel6"); // NOI18N
jLabel6.setPreferredSize(new java.awt.Dimension(35, 23));
FormInput.add(jLabel6);
jLabel6.setBounds(145, 70, 35, 23);
LPpn.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
LPpn.setText("0");
LPpn.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
LPpn.setName("LPpn"); // NOI18N
LPpn.setPreferredSize(new java.awt.Dimension(65, 23));
FormInput.add(LPpn);
LPpn.setBounds(183, 70, 65, 23);
jLabel7.setText("Total+PPN :");
jLabel7.setName("jLabel7"); // NOI18N
jLabel7.setPreferredSize(new java.awt.Dimension(65, 23));
FormInput.add(jLabel7);
jLabel7.setBounds(251, 70, 65, 23);
LTotalTagihan.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
LTotalTagihan.setText("0");
LTotalTagihan.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
LTotalTagihan.setName("LTotalTagihan"); // NOI18N
LTotalTagihan.setPreferredSize(new java.awt.Dimension(80, 23));
FormInput.add(LTotalTagihan);
LTotalTagihan.setBounds(319, 70, 80, 23);
label12.setText("Tarif :");
label12.setName("label12"); // NOI18N
label12.setPreferredSize(new java.awt.Dimension(50, 23));
FormInput.add(label12);
label12.setBounds(395, 40, 50, 23);
Jeniskelas.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Rawat Jalan", "Beli Luar", "Karyawan", "Utama/BPJS" }));
Jeniskelas.setName("Jeniskelas"); // NOI18N
Jeniskelas.setPreferredSize(new java.awt.Dimension(100, 23));
Jeniskelas.addItemListener(new java.awt.event.ItemListener() {
public void itemStateChanged(java.awt.event.ItemEvent evt) {
JeniskelasItemStateChanged(evt);
}
});
Jeniskelas.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
JeniskelasKeyPressed(evt);
}
});
FormInput.add(Jeniskelas);
Jeniskelas.setBounds(448, 40, 150, 23);
ChkNoResep.setSelected(true);
ChkNoResep.setText("No.Resep ");
ChkNoResep.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
ChkNoResep.setHorizontalTextPosition(javax.swing.SwingConstants.RIGHT);
ChkNoResep.setName("ChkNoResep"); // NOI18N
ChkNoResep.setOpaque(false);
ChkNoResep.setPreferredSize(new java.awt.Dimension(85, 23));
ChkNoResep.addItemListener(new java.awt.event.ItemListener() {
public void itemStateChanged(java.awt.event.ItemEvent evt) {
ChkNoResepItemStateChanged(evt);
}
});
FormInput.add(ChkNoResep);
ChkNoResep.setBounds(608, 40, 100, 23);
jLabel8.setText("Tanggal :");
jLabel8.setName("jLabel8"); // NOI18N
jLabel8.setPreferredSize(new java.awt.Dimension(68, 23));
FormInput.add(jLabel8);
jLabel8.setBounds(4, 40, 65, 23);
DTPTgl.setForeground(new java.awt.Color(50, 70, 50));
DTPTgl.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "13-04-2023" }));
DTPTgl.setDisplayFormat("dd-MM-yyyy");
DTPTgl.setName("DTPTgl"); // NOI18N
DTPTgl.setOpaque(false);
DTPTgl.setPreferredSize(new java.awt.Dimension(100, 23));
DTPTgl.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
DTPTglKeyPressed(evt);
}
});
FormInput.add(DTPTgl);
DTPTgl.setBounds(72, 40, 90, 23);
cmbJam.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "00", "01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23" }));
cmbJam.setName("cmbJam"); // NOI18N
cmbJam.setPreferredSize(new java.awt.Dimension(50, 23));
cmbJam.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
cmbJamKeyPressed(evt);
}
});
FormInput.add(cmbJam);
cmbJam.setBounds(166, 40, 62, 23);
cmbMnt.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "00", "01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", "24", "25", "26", "27", "28", "29", "30", "31", "32", "33", "34", "35", "36", "37", "38", "39", "40", "41", "42", "43", "44", "45", "46", "47", "48", "49", "50", "51", "52", "53", "54", "55", "56", "57", "58", "59" }));
cmbMnt.setName("cmbMnt"); // NOI18N
cmbMnt.setPreferredSize(new java.awt.Dimension(50, 23));
cmbMnt.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
cmbMntKeyPressed(evt);
}
});
FormInput.add(cmbMnt);
cmbMnt.setBounds(231, 40, 62, 23);
cmbDtk.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "00", "01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", "24", "25", "26", "27", "28", "29", "30", "31", "32", "33", "34", "35", "36", "37", "38", "39", "40", "41", "42", "43", "44", "45", "46", "47", "48", "49", "50", "51", "52", "53", "54", "55", "56", "57", "58", "59" }));
cmbDtk.setName("cmbDtk"); // NOI18N
cmbDtk.setPreferredSize(new java.awt.Dimension(50, 23));
cmbDtk.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
cmbDtkKeyPressed(evt);
}
});
FormInput.add(cmbDtk);
cmbDtk.setBounds(296, 40, 62, 23);
ChkJln.setBorder(null);
ChkJln.setSelected(true);
ChkJln.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
ChkJln.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
ChkJln.setHorizontalTextPosition(javax.swing.SwingConstants.CENTER);
ChkJln.setName("ChkJln"); // NOI18N
ChkJln.setPreferredSize(new java.awt.Dimension(22, 23));
ChkJln.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
ChkJlnActionPerformed(evt);
}
});
FormInput.add(ChkJln);
ChkJln.setBounds(361, 40, 22, 23);
label21.setText("Depo :");
label21.setName("label21"); // NOI18N
label21.setPreferredSize(new java.awt.Dimension(70, 23));
FormInput.add(label21);
label21.setBounds(395, 70, 50, 23);
kdgudang.setEditable(false);
kdgudang.setName("kdgudang"); // NOI18N
kdgudang.setPreferredSize(new java.awt.Dimension(80, 23));
kdgudang.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
kdgudangKeyPressed(evt);
}
});
FormInput.add(kdgudang);
kdgudang.setBounds(448, 70, 55, 23);
nmgudang.setEditable(false);
nmgudang.setName("nmgudang"); // NOI18N
nmgudang.setPreferredSize(new java.awt.Dimension(207, 23));
FormInput.add(nmgudang);
nmgudang.setBounds(505, 70, 150, 23);
BtnGudang.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/190.png"))); // NOI18N
BtnGudang.setMnemonic('2');
BtnGudang.setToolTipText("Alt+2");
BtnGudang.setName("BtnGudang"); // NOI18N
BtnGudang.setPreferredSize(new java.awt.Dimension(28, 23));
BtnGudang.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
BtnGudangActionPerformed(evt);
}
});
FormInput.add(BtnGudang);
BtnGudang.setBounds(657, 70, 28, 23);
jLabel10.setText("No.Rawat :");
jLabel10.setName("jLabel10"); // NOI18N
jLabel10.setPreferredSize(new java.awt.Dimension(68, 23));
FormInput.add(jLabel10);
jLabel10.setBounds(4, 10, 65, 23);
jLabel11.setText("No.RM :");
jLabel11.setName("jLabel11"); // NOI18N
jLabel11.setPreferredSize(new java.awt.Dimension(68, 23));
FormInput.add(jLabel11);
jLabel11.setBounds(188, 10, 65, 23);
jLabel12.setText("Nama Pasien :");
jLabel12.setName("jLabel12"); // NOI18N
jLabel12.setPreferredSize(new java.awt.Dimension(68, 23));
FormInput.add(jLabel12);
jLabel12.setBounds(365, 10, 80, 23);
TPasien.setEditable(false);
TPasien.setName("TPasien"); // NOI18N
TPasien.setPreferredSize(new java.awt.Dimension(207, 23));
FormInput.add(TPasien);
TPasien.setBounds(448, 10, 237, 23);
TNoRM.setEditable(false);
TNoRM.setName("TNoRM"); // NOI18N
TNoRM.setPreferredSize(new java.awt.Dimension(207, 23));
FormInput.add(TNoRM);
TNoRM.setBounds(256, 10, 90, 23);
LblNoRawat.setEditable(false);
LblNoRawat.setName("LblNoRawat"); // NOI18N
LblNoRawat.setPreferredSize(new java.awt.Dimension(207, 23));
FormInput.add(LblNoRawat);
LblNoRawat.setBounds(72, 10, 123, 23);
internalFrame1.add(FormInput, 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);
}
});
Scroll.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(255, 255, 255)));
Scroll.setComponentPopupMenu(Popup);
Scroll.setName("Scroll"); // NOI18N
Scroll.setOpaque(true);
tbObat.setToolTipText("Silahkan klik untuk memilih data yang mau diedit ataupun dihapus");
tbObat.setComponentPopupMenu(Popup);
tbObat.setName("tbObat"); // NOI18N
tbObat.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
tbObatMouseClicked(evt);
}
});
tbObat.addPropertyChangeListener(new java.beans.PropertyChangeListener() {
public void propertyChange(java.beans.PropertyChangeEvent evt) {
tbObatPropertyChange(evt);
}
});
tbObat.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
tbObatKeyPressed(evt);
}
});
Scroll.setViewportView(tbObat);
TabRawat.addTab("Umum", Scroll);
jPanel3.setName("jPanel3"); // NOI18N
jPanel3.setOpaque(false);
jPanel3.setPreferredSize(new java.awt.Dimension(300, 102));
jPanel3.setLayout(new java.awt.BorderLayout(1, 1));
Scroll1.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(255, 255, 255)));
Scroll1.setName("Scroll1"); // NOI18N
Scroll1.setOpaque(true);
Scroll1.setPreferredSize(new java.awt.Dimension(454, 90));
tbObatRacikan.setToolTipText("Silahkan klik untuk memilih data yang mau diedit ataupun dihapus");
tbObatRacikan.setName("tbObatRacikan"); // NOI18N
tbObatRacikan.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
tbObatRacikanKeyPressed(evt);
}
});
Scroll1.setViewportView(tbObatRacikan);
jPanel3.add(Scroll1, java.awt.BorderLayout.PAGE_START);
Scroll2.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(255, 255, 255)));
Scroll2.setName("Scroll2"); // NOI18N
Scroll2.setOpaque(true);
tbDetailObatRacikan.setAutoCreateRowSorter(true);
tbDetailObatRacikan.setToolTipText("Silahkan klik untuk memilih data yang mau diedit ataupun dihapus");
tbDetailObatRacikan.setComponentPopupMenu(Popup);
tbDetailObatRacikan.setName("tbDetailObatRacikan"); // NOI18N
tbDetailObatRacikan.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
tbDetailObatRacikanMouseClicked(evt);
}
});
tbDetailObatRacikan.addPropertyChangeListener(new java.beans.PropertyChangeListener() {
public void propertyChange(java.beans.PropertyChangeEvent evt) {
tbDetailObatRacikanPropertyChange(evt);
}
});
tbDetailObatRacikan.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
tbDetailObatRacikanKeyPressed(evt);
}
});
Scroll2.setViewportView(tbDetailObatRacikan);
jPanel3.add(Scroll2, java.awt.BorderLayout.CENTER);
TabRawat.addTab("Racikan", jPanel3);
internalFrame1.add(TabRawat, java.awt.BorderLayout.CENTER);
getContentPane().add(internalFrame1, java.awt.BorderLayout.CENTER);
pack();
}// //GEN-END:initComponents
private void TCariKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_TCariKeyPressed
if(evt.getKeyCode()==KeyEvent.VK_ENTER){
BtnCariActionPerformed(null);
}else if(evt.getKeyCode()==KeyEvent.VK_PAGE_DOWN){
BtnCari.requestFocus();
}else if(evt.getKeyCode()==KeyEvent.VK_PAGE_UP){
BtnKeluar.requestFocus();
}else if(evt.getKeyCode()==KeyEvent.VK_UP){
tbObat.requestFocus();
}
}//GEN-LAST:event_TCariKeyPressed
private void BtnCariActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnCariActionPerformed
if(TabRawat.getSelectedIndex()==0){
tampilcacheberiobat();
}else if(TabRawat.getSelectedIndex()==1){
if(tbObatRacikan.getRowCount()!=0){
if(tbObatRacikan.getSelectedRow()!= -1){
if(tbObatRacikan.getValueAt(tbObatRacikan.getSelectedRow(),0).toString().equals("")||
tbObatRacikan.getValueAt(tbObatRacikan.getSelectedRow(),1).toString().equals("")||
tbObatRacikan.getValueAt(tbObatRacikan.getSelectedRow(),2).toString().equals("")||
tbObatRacikan.getValueAt(tbObatRacikan.getSelectedRow(),3).toString().equals("")||
tbObatRacikan.getValueAt(tbObatRacikan.getSelectedRow(),4).toString().equals("")||
tbObatRacikan.getValueAt(tbObatRacikan.getSelectedRow(),5).toString().equals("")||
tbObatRacikan.getValueAt(tbObatRacikan.getSelectedRow(),6).toString().equals("")){
JOptionPane.showMessageDialog(null,"Silahkan lengkapi data racikan..!!");
}else{
tampildetailracikanobat();
}
}else{
JOptionPane.showMessageDialog(null,"Silahkan pilih racikan..!!");
}
}else{
JOptionPane.showMessageDialog(null,"Silahkan masukkan racikan..!!");
}
}
}//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("");
buatcacheberiobat();
BtnCariActionPerformed(evt);
}//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, BtnCari, TCari);
}
}//GEN-LAST:event_BtnAllKeyPressed
private void tbObatMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_tbObatMouseClicked
if(tbObat.getRowCount()!=0){
try {
getDataobat();
} catch (java.lang.NullPointerException e) {
}
if(evt.getClickCount()==2){
if(akses.getform().equals("DlgPemberianObat")){
dispose();
}
}
}
}//GEN-LAST:event_tbObatMouseClicked
private void tbObatKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_tbObatKeyPressed
if(tbObat.getRowCount()!=0){
if(evt.getKeyCode()==KeyEvent.VK_ENTER){
try {
getDataobat();
i=tbObat.getSelectedColumn();
if(i==8){
try {
if(tbObat.getValueAt(tbObat.getSelectedRow(),8).toString().equals("0")||tbObat.getValueAt(tbObat.getSelectedRow(),8).toString().equals("")||tbObat.getValueAt(tbObat.getSelectedRow(),8).toString().equals("0.0")||tbObat.getValueAt(tbObat.getSelectedRow(),8).toString().equals("0,0")) {
tbObat.setValueAt(embalase,tbObat.getSelectedRow(),8);
}
} catch (Exception e) {
tbObat.setValueAt(0,tbObat.getSelectedRow(),8);
}
}else if(i==9){
try {
if(tbObat.getValueAt(tbObat.getSelectedRow(),9).toString().equals("0")||tbObat.getValueAt(tbObat.getSelectedRow(),9).toString().equals("")||tbObat.getValueAt(tbObat.getSelectedRow(),9).toString().equals("0.0")||tbObat.getValueAt(tbObat.getSelectedRow(),9).toString().equals("0,0")) {
tbObat.setValueAt(tuslah,tbObat.getSelectedRow(),9);
}
} catch (Exception e) {
tbObat.setValueAt(0,tbObat.getSelectedRow(),9);
}
TCari.setText("");
TCari.requestFocus();
}else if((i==10)||(i==3)){
hitungObat();
TCari.setText("");
TCari.requestFocus();
}else if(i==11){
TCari.setText("");
TCari.requestFocus();
}
} catch (java.lang.NullPointerException e) {
}
}else if((evt.getKeyCode()==KeyEvent.VK_UP)||(evt.getKeyCode()==KeyEvent.VK_DOWN)){
try {
getDataobat();
} catch (java.lang.NullPointerException e) {
}
}else if(evt.getKeyCode()==KeyEvent.VK_DELETE){
i=tbObat.getSelectedColumn();
if((i==1)||(i==11)||(i==8)||(i==9)){
if(tbObat.getSelectedRow()!= -1){
tbObat.setValueAt("",tbObat.getSelectedRow(),i);
}
}
}else if(evt.getKeyCode()==KeyEvent.VK_SHIFT){
i=tbObat.getSelectedColumn();
if(i!=11){
TCari.requestFocus();
}
}else if(evt.getKeyCode()==KeyEvent.VK_RIGHT){
i=tbObat.getSelectedColumn();
if(i==2){
try {
getDataobat();
try {
if(tbObat.getValueAt(tbObat.getSelectedRow(),8).toString().equals("0")||tbObat.getValueAt(tbObat.getSelectedRow(),8).toString().equals("")||tbObat.getValueAt(tbObat.getSelectedRow(),8).toString().equals("0.0")||tbObat.getValueAt(tbObat.getSelectedRow(),8).toString().equals("0,0")) {
tbObat.setValueAt(embalase,tbObat.getSelectedRow(),8);
}
} catch (Exception e) {
tbObat.setValueAt(0,tbObat.getSelectedRow(),8);
}
try {
if(tbObat.getValueAt(tbObat.getSelectedRow(),9).toString().equals("0")||tbObat.getValueAt(tbObat.getSelectedRow(),9).toString().equals("")||tbObat.getValueAt(tbObat.getSelectedRow(),9).toString().equals("0.0")||tbObat.getValueAt(tbObat.getSelectedRow(),9).toString().equals("0,0")) {
tbObat.setValueAt(tuslah,tbObat.getSelectedRow(),9);
}
} catch (Exception e) {
tbObat.setValueAt(0,tbObat.getSelectedRow(),9);
}
} catch (Exception e) {
tbObat.setValueAt(0,tbObat.getSelectedRow(),10);
}
hitungObat();
}else if(i==11){
akses.setform("DlgCariObat");
DlgCariAturanPakai aturanpakai=new DlgCariAturanPakai(null,false);
aturanpakai.addWindowListener(new WindowListener() {
@Override
public void windowOpened(WindowEvent e) {}
@Override
public void windowClosing(WindowEvent e) {}
@Override
public void windowClosed(WindowEvent e) {
if(aturanpakai.getTable().getSelectedRow()!= -1){
if(TabRawat.getSelectedIndex()==0){
tbObat.setValueAt(aturanpakai.getTable().getValueAt(aturanpakai.getTable().getSelectedRow(),0).toString(),tbObat.getSelectedRow(),11);
tbObat.requestFocus();
}else if(TabRawat.getSelectedIndex()==1){
tbObatRacikan.setValueAt(aturanpakai.getTable().getValueAt(aturanpakai.getTable().getSelectedRow(),0).toString(),tbObatRacikan.getSelectedRow(),5);
tbObatRacikan.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) {}
});
aturanpakai.setSize(internalFrame1.getWidth(),internalFrame1.getHeight());
aturanpakai.setLocationRelativeTo(internalFrame1);
aturanpakai.setVisible(true);
}
}
}
}//GEN-LAST:event_tbObatKeyPressed
private void Kd2KeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_Kd2KeyPressed
// TODO add your handling code here:
}//GEN-LAST:event_Kd2KeyPressed
private void BtnKeluarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnKeluarActionPerformed
dispose();
}//GEN-LAST:event_BtnKeluarActionPerformed
private void BtnTambahActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnTambahActionPerformed
this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR));
DlgBarang barang=new DlgBarang(null,false);
barang.emptTeks();
barang.isCek();
barang.setSize(internalFrame1.getWidth()-20,internalFrame1.getHeight()-20);
barang.setLocationRelativeTo(internalFrame1);
barang.setAlwaysOnTop(false);
barang.setVisible(true);
this.setCursor(Cursor.getDefaultCursor());
}//GEN-LAST:event_BtnTambahActionPerformed
private void BtnSimpanActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnSimpanActionPerformed
if(VALIDASIULANGBERIOBAT.equals("yes")){
for(i=0;i0){
getDataobat(i);
}
}
for(i=0;i0){
getDatadetailobatracikan(i);
}
}
}
if(TNoRw.getText().trim().equals("")){
Valid.textKosong(TCari,"Data");
}else if(kdgudang.getText().equals("")){
Valid.textKosong(TCari,"Lokasi");
}else if(ttl<=0){
JOptionPane.showMessageDialog(null,"Maaf, silahkan masukkan terlebih dahulu obat yang mau diberikan...!!!");
TCari.requestFocus();
}else{
int reply = JOptionPane.showConfirmDialog(rootPane,"Eeiiiiiits, udah bener belum data yang mau disimpan..??","Konfirmasi",JOptionPane.YES_NO_OPTION);
if (reply == JOptionPane.YES_OPTION) {
try {
ChkJln.setSelected(false);
Sequel.AutoComitFalse();
sukses=true;
ttlhpp=0;ttljual=0;
for(i=0;i0){
if(tbObat.getValueAt(i,0).toString().equals("true")){
pscarikapasitas= koneksi.prepareStatement("select IFNULL(databarang.kapasitas,1) from databarang where databarang.kode_brng=?");
try {
pscarikapasitas.setString(1,tbObat.getValueAt(i,2).toString());
carikapasitas=pscarikapasitas.executeQuery();
if(carikapasitas.next()){
if(Sequel.menyimpantf2("detail_pemberian_obat","?,?,?,?,?,?,?,?,?,?,?,?,?,?","data",14,new String[]{
Valid.SetTgl(DTPTgl.getSelectedItem()+""),cmbJam.getSelectedItem()+":"+cmbMnt.getSelectedItem()+":"+cmbDtk.getSelectedItem(),TNoRw.getText(),tbObat.getValueAt(i,2).toString(),tbObat.getValueAt(i,13).toString(),
tbObat.getValueAt(i,6).toString(),""+(Double.parseDouble(tbObat.getValueAt(i,1).toString())/carikapasitas.getDouble(1)),
tbObat.getValueAt(i,8).toString(),tbObat.getValueAt(i,9).toString(),""+Math.round(Double.parseDouble(tbObat.getValueAt(i,8).toString())+
Double.parseDouble(tbObat.getValueAt(i,9).toString())+(Double.parseDouble(tbObat.getValueAt(i,6).toString())*
(Double.parseDouble(tbObat.getValueAt(i,1).toString())/carikapasitas.getDouble(1)))),
"Ralan",kdgudang.getText(),tbObat.getValueAt(i,16).toString(),tbObat.getValueAt(i,17).toString()
})==true){
ttljual=ttljual+Math.round(Double.parseDouble(tbObat.getValueAt(i,8).toString())+
Double.parseDouble(tbObat.getValueAt(i,9).toString())+(Double.parseDouble(tbObat.getValueAt(i,6).toString())*
(Double.parseDouble(tbObat.getValueAt(i,1).toString())/carikapasitas.getDouble(1))));
ttlhpp=ttlhpp+Math.round(Double.parseDouble(tbObat.getValueAt(i,13).toString())*
(Double.parseDouble(tbObat.getValueAt(i,1).toString())/carikapasitas.getDouble(1)));
if(!tbObat.getValueAt(i,11).toString().equals("")){
Sequel.menyimpan("aturan_pakai","?,?,?,?,?",5,new String[]{
Valid.SetTgl(DTPTgl.getSelectedItem()+""),cmbJam.getSelectedItem()+":"+cmbMnt.getSelectedItem()+":"+cmbDtk.getSelectedItem(),TNoRw.getText(),tbObat.getValueAt(i,2).toString(),tbObat.getValueAt(i,11).toString()
});
}
if(aktifkanbatch.equals("yes")){
Sequel.mengedit("data_batch","no_batch=? and kode_brng=? and no_faktur=?","sisa=sisa-?",4,new String[]{
""+(Double.parseDouble(tbObat.getValueAt(i,1).toString())/carikapasitas.getDouble(1)),tbObat.getValueAt(i,16).toString(),tbObat.getValueAt(i,2).toString(),tbObat.getValueAt(i,17).toString()
});
Trackobat.catatRiwayat(tbObat.getValueAt(i,2).toString(),0,(Double.parseDouble(tbObat.getValueAt(i,1).toString())/carikapasitas.getDouble(1)),"Pemberian Obat",akses.getkode(),kdgudang.getText(),"Simpan",tbObat.getValueAt(i,16).toString(),tbObat.getValueAt(i,17).toString(),TNoRw.getText()+" "+TNoRM.getText()+" "+TPasien.getText());
Sequel.menyimpan("gudangbarang","'"+tbObat.getValueAt(i,2).toString()+"','"+kdgudang.getText()+"','-"+(Double.parseDouble(tbObat.getValueAt(i,1).toString())/carikapasitas.getDouble(1))+"','"+tbObat.getValueAt(i,16).toString()+"','"+tbObat.getValueAt(i,17).toString()+"'",
"stok=stok-'"+(Double.parseDouble(tbObat.getValueAt(i,1).toString())/carikapasitas.getDouble(1))+"'","kode_brng='"+tbObat.getValueAt(i,2).toString()+"' and kd_bangsal='"+kdgudang.getText()+"' and no_batch='"+tbObat.getValueAt(i,16).toString()+"' and no_faktur='"+tbObat.getValueAt(i,17).toString()+"'");
}else{
Trackobat.catatRiwayat(tbObat.getValueAt(i,2).toString(),0,(Double.parseDouble(tbObat.getValueAt(i,1).toString())/carikapasitas.getDouble(1)),"Pemberian Obat",akses.getkode(),kdgudang.getText(),"Simpan","","",TNoRw.getText()+" "+TNoRM.getText()+" "+TPasien.getText());
Sequel.menyimpan("gudangbarang","'"+tbObat.getValueAt(i,2).toString()+"','"+kdgudang.getText()+"','-"+(Double.parseDouble(tbObat.getValueAt(i,1).toString())/carikapasitas.getDouble(1))+"','',''",
"stok=stok-'"+(Double.parseDouble(tbObat.getValueAt(i,1).toString())/carikapasitas.getDouble(1))+"'","kode_brng='"+tbObat.getValueAt(i,2).toString()+"' and kd_bangsal='"+kdgudang.getText()+"' and no_batch='' and no_faktur=''");
}
if(aktifpcare.equals("yes")){
arrSplit = tbObat.getValueAt(i,11).toString().toLowerCase().split("x");
signa1="1";
try {
if(!arrSplit[0].replaceAll("[^0-9.]+", "").equals("")){
signa1=arrSplit[0].replaceAll("[^0-9.]+", "");
}
} catch (Exception e) {
signa1="1";
}
signa2="1";
try {
if(!arrSplit[1].replaceAll("[^0-9.]+", "").equals("")){
signa2=arrSplit[1].replaceAll("[^0-9.]+", "");
}
} catch (Exception e) {
signa2="1";
}
simpanObatPCare(
nokunjungan,"false",Sequel.cariIsi("select kode_brng_pcare from maping_obat_pcare where kode_brng=?",tbObat.getValueAt(i,2).toString()),
signa1,signa2,""+(Double.parseDouble(tbObat.getValueAt(i,1).toString())/carikapasitas.getDouble(1)),""+(Double.parseDouble(tbObat.getValueAt(i,1).toString())/carikapasitas.getDouble(1)),"",TNoRw.getText(),
Valid.SetTgl(DTPTgl.getSelectedItem()+""),cmbJam.getSelectedItem()+":"+cmbMnt.getSelectedItem()+":"+cmbDtk.getSelectedItem(),
tbObat.getValueAt(i,2).toString(),tbObat.getValueAt(i,16).toString(),tbObat.getValueAt(i,17).toString()
);
}
}else{
sukses=false;
}
}else{
if(Sequel.menyimpantf2("detail_pemberian_obat","?,?,?,?,?,?,?,?,?,?,?,?,?,?","data",14,new String[]{
Valid.SetTgl(DTPTgl.getSelectedItem()+""),cmbJam.getSelectedItem()+":"+cmbMnt.getSelectedItem()+":"+cmbDtk.getSelectedItem(),TNoRw.getText(),tbObat.getValueAt(i,2).toString(),tbObat.getValueAt(i,13).toString(),
tbObat.getValueAt(i,6).toString(),""+Double.parseDouble(tbObat.getValueAt(i,1).toString()),
tbObat.getValueAt(i,8).toString(),tbObat.getValueAt(i,9).toString(),""+Math.round(Double.parseDouble(tbObat.getValueAt(i,8).toString())+
Double.parseDouble(tbObat.getValueAt(i,9).toString())+(Double.parseDouble(tbObat.getValueAt(i,6).toString())*
Double.parseDouble(tbObat.getValueAt(i,1).toString()))),
"Ralan",kdgudang.getText(),tbObat.getValueAt(i,16).toString(),tbObat.getValueAt(i,17).toString()
})==true){
ttljual=ttljual+Math.round(Double.parseDouble(tbObat.getValueAt(i,8).toString())+
Double.parseDouble(tbObat.getValueAt(i,9).toString())+(Double.parseDouble(tbObat.getValueAt(i,6).toString())*
Double.parseDouble(tbObat.getValueAt(i,1).toString())));
ttlhpp=ttlhpp+Math.round(Double.parseDouble(tbObat.getValueAt(i,13).toString())*
Double.parseDouble(tbObat.getValueAt(i,1).toString()));
if(!tbObat.getValueAt(i,11).toString().equals("")){
Sequel.menyimpan("aturan_pakai","?,?,?,?,?",5,new String[]{
Valid.SetTgl(DTPTgl.getSelectedItem()+""),cmbJam.getSelectedItem()+":"+cmbMnt.getSelectedItem()+":"+cmbDtk.getSelectedItem(),TNoRw.getText(),tbObat.getValueAt(i,2).toString(),tbObat.getValueAt(i,11).toString()
});
}
if(aktifkanbatch.equals("yes")){
Sequel.mengedit("data_batch","no_batch=? and kode_brng=? and no_faktur=?","sisa=sisa-?",4,new String[]{
""+(Double.parseDouble(tbObat.getValueAt(i,1).toString())),tbObat.getValueAt(i,16).toString(),tbObat.getValueAt(i,2).toString(),tbObat.getValueAt(i,17).toString()
});
Trackobat.catatRiwayat(tbObat.getValueAt(i,2).toString(),0,Double.parseDouble(tbObat.getValueAt(i,1).toString()),"Pemberian Obat",akses.getkode(),kdgudang.getText(),"Simpan",tbObat.getValueAt(i,16).toString(),tbObat.getValueAt(i,17).toString(),TNoRw.getText()+" "+TNoRM.getText()+" "+TPasien.getText());
Sequel.menyimpan("gudangbarang","'"+tbObat.getValueAt(i,2).toString()+"','"+kdgudang.getText()+"','-"+Double.parseDouble(tbObat.getValueAt(i,1).toString())+"','"+tbObat.getValueAt(i,16).toString()+"','"+tbObat.getValueAt(i,17).toString()+"'",
"stok=stok-'"+Double.parseDouble(tbObat.getValueAt(i,1).toString())+"'","kode_brng='"+tbObat.getValueAt(i,2).toString()+"' and kd_bangsal='"+kdgudang.getText()+"' and no_batch='"+tbObat.getValueAt(i,16).toString()+"' and no_faktur='"+tbObat.getValueAt(i,17).toString()+"'");
}else{
Trackobat.catatRiwayat(tbObat.getValueAt(i,2).toString(),0,Double.parseDouble(tbObat.getValueAt(i,1).toString()),"Pemberian Obat",akses.getkode(),kdgudang.getText(),"Simpan","","",TNoRw.getText()+" "+TNoRM.getText()+" "+TPasien.getText());
Sequel.menyimpan("gudangbarang","'"+tbObat.getValueAt(i,2).toString()+"','"+kdgudang.getText()+"','-"+Double.parseDouble(tbObat.getValueAt(i,1).toString())+"','',''",
"stok=stok-'"+Double.parseDouble(tbObat.getValueAt(i,1).toString())+"'","kode_brng='"+tbObat.getValueAt(i,2).toString()+"' and kd_bangsal='"+kdgudang.getText()+"' and no_batch='' and no_faktur=''");
}
if(aktifpcare.equals("yes")){
arrSplit = tbObat.getValueAt(i,11).toString().toLowerCase().split("x");
signa1="1";
try {
if(!arrSplit[0].replaceAll("[^0-9.]+", "").equals("")){
signa1=arrSplit[0].replaceAll("[^0-9.]+", "");
}
} catch (Exception e) {
signa1="1";
}
signa2="1";
try {
if(!arrSplit[1].replaceAll("[^0-9.]+", "").equals("")){
signa2=arrSplit[1].replaceAll("[^0-9.]+", "");
}
} catch (Exception e) {
signa2="1";
}
simpanObatPCare(
nokunjungan,"false",Sequel.cariIsi("select kode_brng_pcare from maping_obat_pcare where kode_brng=?",tbObat.getValueAt(i,2).toString()),
signa1,signa2,""+Double.parseDouble(tbObat.getValueAt(i,1).toString()),""+Double.parseDouble(tbObat.getValueAt(i,1).toString()),"",TNoRw.getText(),
Valid.SetTgl(DTPTgl.getSelectedItem()+""),cmbJam.getSelectedItem()+":"+cmbMnt.getSelectedItem()+":"+cmbDtk.getSelectedItem(),
tbObat.getValueAt(i,2).toString(),tbObat.getValueAt(i,16).toString(),tbObat.getValueAt(i,17).toString()
);
}
}else{
sukses=false;
}
}
} catch (Exception e) {
System.out.println("Notifikasi Kapasitas : "+e);
} finally{
if(carikapasitas!=null){
carikapasitas.close();
}
if(pscarikapasitas!=null){
pscarikapasitas.close();
}
}
}else{
if(Sequel.menyimpantf2("detail_pemberian_obat","?,?,?,?,?,?,?,?,?,?,?,?,?,?","data",14,new String[]{
Valid.SetTgl(DTPTgl.getSelectedItem()+""),cmbJam.getSelectedItem()+":"+cmbMnt.getSelectedItem()+":"+cmbDtk.getSelectedItem(),TNoRw.getText(),tbObat.getValueAt(i,2).toString(),tbObat.getValueAt(i,13).toString(),
tbObat.getValueAt(i,6).toString(),""+Double.parseDouble(tbObat.getValueAt(i,1).toString()),
tbObat.getValueAt(i,8).toString(),tbObat.getValueAt(i,9).toString(),""+Math.round(Double.parseDouble(tbObat.getValueAt(i,8).toString())+
Double.parseDouble(tbObat.getValueAt(i,9).toString())+(Double.parseDouble(tbObat.getValueAt(i,6).toString())*
Double.parseDouble(tbObat.getValueAt(i,1).toString()))),
"Ralan",kdgudang.getText(),tbObat.getValueAt(i,16).toString(),tbObat.getValueAt(i,17).toString()
})==true){
ttljual=ttljual+Math.round(Double.parseDouble(tbObat.getValueAt(i,8).toString())+
Double.parseDouble(tbObat.getValueAt(i,9).toString())+(Double.parseDouble(tbObat.getValueAt(i,6).toString())*
Double.parseDouble(tbObat.getValueAt(i,1).toString())));
ttlhpp=ttlhpp+Math.round(Double.parseDouble(tbObat.getValueAt(i,13).toString())*
Double.parseDouble(tbObat.getValueAt(i,1).toString()));
if(!tbObat.getValueAt(i,11).toString().equals("")){
Sequel.menyimpan("aturan_pakai","?,?,?,?,?",5,new String[]{
Valid.SetTgl(DTPTgl.getSelectedItem()+""),cmbJam.getSelectedItem()+":"+cmbMnt.getSelectedItem()+":"+cmbDtk.getSelectedItem(),TNoRw.getText(),tbObat.getValueAt(i,2).toString(),tbObat.getValueAt(i,11).toString()
});
}
if(aktifkanbatch.equals("yes")){
Sequel.mengedit("data_batch","no_batch=? and kode_brng=? and no_faktur=?","sisa=sisa-?",4,new String[]{
""+Double.parseDouble(tbObat.getValueAt(i,1).toString()),tbObat.getValueAt(i,16).toString(),tbObat.getValueAt(i,2).toString(),tbObat.getValueAt(i,17).toString()
});
Trackobat.catatRiwayat(tbObat.getValueAt(i,2).toString(),0,Double.parseDouble(tbObat.getValueAt(i,1).toString()),"Pemberian Obat",akses.getkode(),kdgudang.getText(),"Simpan",tbObat.getValueAt(i,16).toString(),tbObat.getValueAt(i,17).toString(),TNoRw.getText()+" "+TNoRM.getText()+" "+TPasien.getText());
Sequel.menyimpan("gudangbarang","'"+tbObat.getValueAt(i,2).toString()+"','"+kdgudang.getText()+"','-"+Double.parseDouble(tbObat.getValueAt(i,1).toString())+"','"+tbObat.getValueAt(i,16).toString()+"','"+tbObat.getValueAt(i,17).toString()+"'",
"stok=stok-'"+Double.parseDouble(tbObat.getValueAt(i,1).toString())+"'","kode_brng='"+tbObat.getValueAt(i,2).toString()+"' and kd_bangsal='"+kdgudang.getText()+"' and no_batch='"+tbObat.getValueAt(i,16).toString()+"' and no_faktur='"+tbObat.getValueAt(i,17).toString()+"'");
}else{
Trackobat.catatRiwayat(tbObat.getValueAt(i,2).toString(),0,Double.parseDouble(tbObat.getValueAt(i,1).toString()),"Pemberian Obat",akses.getkode(),kdgudang.getText(),"Simpan","","",TNoRw.getText()+" "+TNoRM.getText()+" "+TPasien.getText());
Sequel.menyimpan("gudangbarang","'"+tbObat.getValueAt(i,2).toString()+"','"+kdgudang.getText()+"','-"+Double.parseDouble(tbObat.getValueAt(i,1).toString())+"','',''",
"stok=stok-'"+Double.parseDouble(tbObat.getValueAt(i,1).toString())+"'","kode_brng='"+tbObat.getValueAt(i,2).toString()+"' and kd_bangsal='"+kdgudang.getText()+"' and no_batch='' and no_faktur=''");
}
if(aktifpcare.equals("yes")){
arrSplit = tbObat.getValueAt(i,11).toString().toLowerCase().split("x");
signa1="1";
try {
if(!arrSplit[0].replaceAll("[^0-9.]+", "").equals("")){
signa1=arrSplit[0].replaceAll("[^0-9.]+", "");
}
} catch (Exception e) {
signa1="1";
}
signa2="1";
try {
if(!arrSplit[1].replaceAll("[^0-9.]+", "").equals("")){
signa2=arrSplit[1].replaceAll("[^0-9.]+", "");
}
} catch (Exception e) {
signa2="1";
}
simpanObatPCare(
nokunjungan,"false",Sequel.cariIsi("select kode_brng_pcare from maping_obat_pcare where kode_brng=?",tbObat.getValueAt(i,2).toString()),
signa1,signa2,""+Double.parseDouble(tbObat.getValueAt(i,1).toString()),""+Double.parseDouble(tbObat.getValueAt(i,1).toString()),"",TNoRw.getText(),
Valid.SetTgl(DTPTgl.getSelectedItem()+""),cmbJam.getSelectedItem()+":"+cmbMnt.getSelectedItem()+":"+cmbDtk.getSelectedItem(),
tbObat.getValueAt(i,2).toString(),tbObat.getValueAt(i,16).toString(),tbObat.getValueAt(i,17).toString()
);
}
}else{
sukses=false;
}
}
}
}
for(i=0;i0){
if(Sequel.menyimpantf2("obat_racikan","?,?,?,?,?,?,?,?,?","Obat Racikan",9,new String[]{
Valid.SetTgl(DTPTgl.getSelectedItem()+""),cmbJam.getSelectedItem()+":"+cmbMnt.getSelectedItem()+":"+cmbDtk.getSelectedItem(),TNoRw.getText(),
tbObatRacikan.getValueAt(i,0).toString(),tbObatRacikan.getValueAt(i,1).toString(),
tbObatRacikan.getValueAt(i,2).toString(),tbObatRacikan.getValueAt(i,4).toString(),
tbObatRacikan.getValueAt(i,5).toString(),tbObatRacikan.getValueAt(i,6).toString()
})==false){
sukses=false;
}
}
}
for(i=0;i0){
if(Sequel.menyimpantf2("detail_obat_racikan","?,?,?,?,?","Data",5,new String[]{
Valid.SetTgl(DTPTgl.getSelectedItem()+""),cmbJam.getSelectedItem()+":"+cmbMnt.getSelectedItem()+":"+cmbDtk.getSelectedItem(),TNoRw.getText(),
tbDetailObatRacikan.getValueAt(i,0).toString(),tbDetailObatRacikan.getValueAt(i,1).toString()
})==true){
if(Sequel.menyimpantf2("detail_pemberian_obat","?,?,?,?,?,?,?,?,?,?,?,?,?,?","data",14,new String[]{
Valid.SetTgl(DTPTgl.getSelectedItem()+""),cmbJam.getSelectedItem()+":"+cmbMnt.getSelectedItem()+":"+cmbDtk.getSelectedItem(),TNoRw.getText(),
tbDetailObatRacikan.getValueAt(i,1).toString(),tbDetailObatRacikan.getValueAt(i,5).toString(),
tbDetailObatRacikan.getValueAt(i,4).toString(),""+Double.parseDouble(tbDetailObatRacikan.getValueAt(i,10).toString()),
tbDetailObatRacikan.getValueAt(i,11).toString(),tbDetailObatRacikan.getValueAt(i,12).toString(),
""+Math.round(Double.parseDouble(tbDetailObatRacikan.getValueAt(i,11).toString())+
Double.parseDouble(tbDetailObatRacikan.getValueAt(i,12).toString())+
(Double.parseDouble(tbDetailObatRacikan.getValueAt(i,4).toString())*
Double.parseDouble(tbDetailObatRacikan.getValueAt(i,10).toString()))),
"Ralan",kdgudang.getText(),tbDetailObatRacikan.getValueAt(i,16).toString(),tbDetailObatRacikan.getValueAt(i,17).toString()
})==true){
ttljual=ttljual+Math.round(Double.parseDouble(tbDetailObatRacikan.getValueAt(i,11).toString())+
Double.parseDouble(tbDetailObatRacikan.getValueAt(i,12).toString())+(Double.parseDouble(tbDetailObatRacikan.getValueAt(i,4).toString())*
Double.parseDouble(tbDetailObatRacikan.getValueAt(i,10).toString())));
ttlhpp=ttlhpp+Math.round(Double.parseDouble(tbDetailObatRacikan.getValueAt(i,5).toString())*
Double.parseDouble(tbDetailObatRacikan.getValueAt(i,10).toString()));
if(aktifkanbatch.equals("yes")){
Sequel.mengedit("data_batch","no_batch=? and kode_brng=? and no_faktur=?","sisa=sisa-?",4,new String[]{
""+Double.parseDouble(tbDetailObatRacikan.getValueAt(i,10).toString()),tbDetailObatRacikan.getValueAt(i,16).toString(),tbDetailObatRacikan.getValueAt(i,1).toString(),tbDetailObatRacikan.getValueAt(i,17).toString()
});
Trackobat.catatRiwayat(tbDetailObatRacikan.getValueAt(i,1).toString(),0,Double.parseDouble(tbDetailObatRacikan.getValueAt(i,10).toString()),"Pemberian Obat",akses.getkode(),kdgudang.getText(),"Simpan",tbDetailObatRacikan.getValueAt(i,16).toString(),tbDetailObatRacikan.getValueAt(i,17).toString(),TNoRw.getText()+" "+TNoRM.getText()+" "+TPasien.getText());
Sequel.menyimpan("gudangbarang","'"+tbDetailObatRacikan.getValueAt(i,1).toString()+"','"+kdgudang.getText()+"','-"+Double.parseDouble(tbDetailObatRacikan.getValueAt(i,10).toString())+"','"+tbDetailObatRacikan.getValueAt(i,16).toString()+"','"+tbDetailObatRacikan.getValueAt(i,17).toString()+"'",
"stok=stok-'"+Double.parseDouble(tbDetailObatRacikan.getValueAt(i,10).toString())+"'","kode_brng='"+tbDetailObatRacikan.getValueAt(i,1).toString()+"' and kd_bangsal='"+kdgudang.getText()+"' and no_batch='"+tbDetailObatRacikan.getValueAt(i,16).toString()+"' and no_faktur='"+tbDetailObatRacikan.getValueAt(i,17).toString()+"'");
}else{
Trackobat.catatRiwayat(tbDetailObatRacikan.getValueAt(i,1).toString(),0,Double.parseDouble(tbDetailObatRacikan.getValueAt(i,10).toString()),"Pemberian Obat",akses.getkode(),kdgudang.getText(),"Simpan","","",TNoRw.getText()+" "+TNoRM.getText()+" "+TPasien.getText());
Sequel.menyimpan("gudangbarang","'"+tbDetailObatRacikan.getValueAt(i,1).toString()+"','"+kdgudang.getText()+"','-"+Double.parseDouble(tbDetailObatRacikan.getValueAt(i,10).toString())+"','',''",
"stok=stok-'"+Double.parseDouble(tbDetailObatRacikan.getValueAt(i,10).toString())+"'","kode_brng='"+tbDetailObatRacikan.getValueAt(i,1).toString()+"' and kd_bangsal='"+kdgudang.getText()+"' and no_batch='' and no_faktur=''");
}
if(aktifpcare.equals("yes")){
arrSplit = Sequel.cariIsi("select aturan_pakai from obat_racikan where tgl_perawatan='"+Valid.SetTgl(DTPTgl.getSelectedItem()+"")+"' and "+
"jam='"+cmbJam.getSelectedItem()+":"+cmbMnt.getSelectedItem()+":"+cmbDtk.getSelectedItem()+"' and "+
"no_rawat='"+TNoRw.getText()+"' and no_racik='"+tbDetailObatRacikan.getValueAt(i,0).toString()+"'").toLowerCase().split("x");
signa1="1";
try {
if(!arrSplit[0].replaceAll("[^0-9.]+", "").equals("")){
signa1=arrSplit[0].replaceAll("[^0-9.]+", "");
}
} catch (Exception e) {
signa1="1";
}
signa2="1";
try {
if(!arrSplit[1].replaceAll("[^0-9.]+", "").equals("")){
signa2=arrSplit[1].replaceAll("[^0-9.]+", "");
}
} catch (Exception e) {
signa2="1";
}
simpanObatPCare(
nokunjungan,"true",Sequel.cariIsi("select kode_brng_pcare from maping_obat_pcare where kode_brng=?",tbDetailObatRacikan.getValueAt(i,1).toString()),
signa1,signa2,""+Double.parseDouble(tbDetailObatRacikan.getValueAt(i,10).toString()),""+Double.parseDouble(tbDetailObatRacikan.getValueAt(i,10).toString()),"",TNoRw.getText(),
Valid.SetTgl(DTPTgl.getSelectedItem()+""),cmbJam.getSelectedItem()+":"+cmbMnt.getSelectedItem()+":"+cmbDtk.getSelectedItem(),
tbDetailObatRacikan.getValueAt(i,1).toString(),tbDetailObatRacikan.getValueAt(i,16).toString(),tbObat.getValueAt(i,17).toString()
);
}
}else{
sukses=false;
}
}else{
sukses=false;
}
}
}
if(!noresep.equals("")){
Sequel.mengedit("resep_obat","no_resep='"+noresep+"'","tgl_perawatan='"+Valid.SetTgl(DTPTgl.getSelectedItem()+"")+"',jam='"+cmbJam.getSelectedItem()+":"+cmbMnt.getSelectedItem()+":"+cmbDtk.getSelectedItem()+"'");
}
if(sukses==true){
Sequel.queryu("delete from tampjurnal");
if(ttljual>0){
if(Sequel.menyimpantf2("tampjurnal","'"+Suspen_Piutang_Obat_Ralan+"','Suspen Piutang Obat Ralan','"+ttljual+"','0'","Rekening")==false){
sukses=false;
}
if(Sequel.menyimpantf2("tampjurnal","'"+Obat_Ralan+"','Pendapatan Obat Rawat Jalan','0','"+ttljual+"'","Rekening")==false){
sukses=false;
}
}
if(ttlhpp>0){
if(Sequel.menyimpantf2("tampjurnal","'"+HPP_Obat_Rawat_Jalan+"','HPP Persediaan Obat Rawat Jalan','"+ttlhpp+"','0'","Rekening")==false){
sukses=false;
}
if(Sequel.menyimpantf2("tampjurnal","'"+Persediaan_Obat_Rawat_Jalan+"','Persediaan Obat Rawat Jalan','0','"+ttlhpp+"'","Rekening")==false){
sukses=false;
}
}
if(sukses==true){
if((ttljual>0)||(ttlhpp>0)){
sukses=jur.simpanJurnal(TNoRw.getText(),"U","PEMBERIAN OBAT RAWAT JALAN PASIEN "+TNoRM.getText()+" "+TPasien.getText()+", DIPOSTING OLEH "+akses.getkode());
}
}
}
if(sukses==true){
Sequel.Commit();
for(i=0;i {
DlgCariObat dialog = new DlgCariObat(new javax.swing.JFrame(), true);
dialog.addWindowListener(new java.awt.event.WindowAdapter() {
@Override
public void windowClosing(java.awt.event.WindowEvent e) {
System.exit(0);
}
});
dialog.setVisible(true);
});
}
// Variables declaration - do not modify//GEN-BEGIN:variables
private widget.Button BtnAll;
private widget.Button BtnCari;
private widget.Button BtnGudang;
private widget.Button BtnHapus;
private widget.Button BtnKeluar;
private widget.Button BtnSeek5;
private widget.Button BtnSimpan;
private widget.Button BtnTambah;
private widget.Button BtnTambah1;
private widget.CekBox ChkJln;
private widget.CekBox ChkNoResep;
private widget.Tanggal DTPTgl;
private widget.PanelBiasa FormInput;
private widget.TextBox Jam;
private widget.ComboBox Jeniskelas;
private widget.TextBox Kd2;
private widget.TextBox KdPj;
private widget.Label LPpn;
private widget.Label LTotal;
private widget.Label LTotalTagihan;
private widget.TextBox LblNoRawat;
private javax.swing.JPopupMenu Popup;
private widget.ScrollPane Scroll;
private widget.ScrollPane Scroll1;
private widget.ScrollPane Scroll2;
private widget.TextBox TCari;
private widget.TextBox TNoRM;
private widget.TextBox TNoRw;
private widget.TextBox TPasien;
private javax.swing.JTabbedPane TabRawat;
private widget.TextBox Tanggal;
private widget.ComboBox cmbDtk;
private widget.ComboBox cmbJam;
private widget.ComboBox cmbMnt;
private widget.InternalFrame internalFrame1;
private widget.Label jLabel10;
private widget.Label jLabel11;
private widget.Label jLabel12;
private widget.Label jLabel5;
private widget.Label jLabel6;
private widget.Label jLabel7;
private widget.Label jLabel8;
private javax.swing.JPanel jPanel3;
private widget.TextBox kdgudang;
private widget.Label label12;
private widget.Label label13;
private widget.Label label21;
private widget.Label label9;
private widget.TextBox nmgudang;
private widget.panelisi panelisi3;
private javax.swing.JMenuItem ppBersihkan;
private javax.swing.JMenuItem ppStok;
private javax.swing.JMenuItem ppStok1;
private widget.Table tbDetailObatRacikan;
private widget.Table tbObat;
private widget.Table tbObatRacikan;
// End of variables declaration//GEN-END:variables
public void tampilobat() {
buatcacheberiobat();
tampilcacheberiobat();
}
private void buatcacheberiobat(){
try{
file=new File("./cache/beriobatralan.iyem");
file.createNewFile();
fileWriter = new FileWriter(file);
StringBuilder iyembuilder = new StringBuilder();
if(kenaikan>0){
if(aktifkanbatch.equals("yes")){
if(aktifpcare.equals("yes")){
sql="select data_batch.kode_brng, databarang.nama_brng,jenis.nama, databarang.kode_sat,(data_batch.h_beli+(data_batch.h_beli*?)) as harga,"+
" databarang.letak_barang,industrifarmasi.nama_industri,databarang.h_beli,kategori_barang.nama as kategori,golongan_barang.nama as golongan,"+
" data_batch.no_batch,data_batch.no_faktur,data_batch.tgl_kadaluarsa,gudangbarang.stok,data_batch."+hppfarmasi+" as dasar,databarang.kapasitas "+
" from data_batch inner join databarang on data_batch.kode_brng=databarang.kode_brng "+
" inner join jenis on databarang.kdjns=jenis.kdjns "+
" inner join industrifarmasi on industrifarmasi.kode_industri=databarang.kode_industri "+
" inner join golongan_barang on databarang.kode_golongan=golongan_barang.kode "+
" inner join kategori_barang on databarang.kode_kategori=kategori_barang.kode "+
" inner join maping_obat_pcare on maping_obat_pcare.kode_brng=databarang.kode_brng "+
" inner join gudangbarang on gudangbarang.kode_brng=data_batch.kode_brng and gudangbarang.no_batch=data_batch.no_batch and gudangbarang.no_faktur=data_batch.no_faktur ";
}else{
sql="select data_batch.kode_brng, databarang.nama_brng,jenis.nama, databarang.kode_sat,(data_batch.h_beli+(data_batch.h_beli*?)) as harga,"+
" databarang.letak_barang,industrifarmasi.nama_industri,databarang.h_beli,kategori_barang.nama as kategori,golongan_barang.nama as golongan,"+
" data_batch.no_batch,data_batch.no_faktur,data_batch.tgl_kadaluarsa,gudangbarang.stok,data_batch."+hppfarmasi+" as dasar,databarang.kapasitas "+
" from data_batch inner join databarang on data_batch.kode_brng=databarang.kode_brng "+
" inner join jenis on databarang.kdjns=jenis.kdjns "+
" inner join industrifarmasi on industrifarmasi.kode_industri=databarang.kode_industri "+
" inner join golongan_barang on databarang.kode_golongan=golongan_barang.kode "+
" inner join kategori_barang on databarang.kode_kategori=kategori_barang.kode "+
" inner join gudangbarang on gudangbarang.kode_brng=data_batch.kode_brng and gudangbarang.no_batch=data_batch.no_batch and gudangbarang.no_faktur=data_batch.no_faktur ";
}
psobat=koneksi.prepareStatement(sql+" where gudangbarang.stok>0 and gudangbarang.kd_bangsal=? order by data_batch.tgl_kadaluarsa asc");
try{
psobat.setDouble(1,kenaikan);
psobat.setString(2,kdgudang.getText());
rsobat=psobat.executeQuery();
while(rsobat.next()){
iyembuilder.append("{\"KodeBarang\":\"").append(rsobat.getString("kode_brng")).append("\",\"NamaBarang\":\"").append(rsobat.getString("nama_brng").replaceAll("\"","")).append("\",\"Satuan\":\"").append(rsobat.getString("kode_sat")).append("\",\"Kandungan\":\"").append(rsobat.getString("letak_barang")).append("\",\"HargaKaryawan\":\"").append(Valid.roundUp(rsobat.getDouble("harga"),100)).append("\",\"HargaRalan\":\"").append(Valid.roundUp(rsobat.getDouble("harga"),100)).append("\",\"HargaBeliLuar\":\"").append(Valid.roundUp(rsobat.getDouble("harga"),100)).append("\",\"HargaUtama\":\"").append(Valid.roundUp(rsobat.getDouble("harga"),100)).append("\",\"Jenis\":\"").append(rsobat.getString("nama")).append("\",\"Kategori\":\"").append(rsobat.getString("kategori")).append("\",\"Golongan\":\"").append(rsobat.getString("golongan")).append("\",\"IndustriFarmasi\":\"").append(rsobat.getString("nama_industri")).append("\",\"HargaBeli\":\"").append(rsobat.getDouble("dasar")).append("\",\"Stok\":\"").append(rsobat.getDouble("stok")).append("\",\"Kapasitas\":\"").append(rsobat.getDouble("kapasitas")).append("\",\"NoBatch\":\"").append(rsobat.getString("no_batch")).append("\",\"NoFaktur\":\"").append(rsobat.getString("no_faktur")).append("\",\"Kadaluarsa\":\"").append(rsobat.getString("tgl_kadaluarsa")).append("\"},");
}
}catch(Exception e){
System.out.println("Notifikasi : "+e);
}finally{
if(rsobat != null){
rsobat.close();
}
if(psobat != null){
psobat.close();
}
}
}else{
if(aktifpcare.equals("yes")){
sql="select databarang.kode_brng, databarang.nama_brng,jenis.nama, databarang.kode_sat,(databarang.h_beli+(databarang.h_beli*?)) as harga,"+
" databarang.letak_barang,industrifarmasi.nama_industri,databarang.h_beli,kategori_barang.nama as kategori,gudangbarang.stok,golongan_barang.nama as golongan,databarang."+hppfarmasi+" as dasar,databarang.kapasitas "+
" from databarang inner join jenis on databarang.kdjns=jenis.kdjns "+
" inner join industrifarmasi on industrifarmasi.kode_industri=databarang.kode_industri "+
" inner join golongan_barang on databarang.kode_golongan=golongan_barang.kode "+
" inner join kategori_barang on databarang.kode_kategori=kategori_barang.kode "+
" inner join maping_obat_pcare on maping_obat_pcare.kode_brng=databarang.kode_brng "+
" inner join gudangbarang on databarang.kode_brng=gudangbarang.kode_brng ";
}else{
sql="select databarang.kode_brng, databarang.nama_brng,jenis.nama, databarang.kode_sat,(databarang.h_beli+(databarang.h_beli*?)) as harga,"+
" databarang.letak_barang,industrifarmasi.nama_industri,databarang.h_beli,kategori_barang.nama as kategori,gudangbarang.stok,golongan_barang.nama as golongan,databarang."+hppfarmasi+" as dasar,databarang.kapasitas "+
" from databarang inner join jenis on databarang.kdjns=jenis.kdjns "+
" inner join industrifarmasi on industrifarmasi.kode_industri=databarang.kode_industri "+
" inner join golongan_barang on databarang.kode_golongan=golongan_barang.kode "+
" inner join kategori_barang on databarang.kode_kategori=kategori_barang.kode "+
" inner join gudangbarang on databarang.kode_brng=gudangbarang.kode_brng ";
}
psobat=koneksi.prepareStatement(sql+" where gudangbarang.no_batch='' and gudangbarang.no_faktur='' and gudangbarang.stok>0 and gudangbarang.kd_bangsal=? and databarang.status='1' order by databarang.nama_brng");
try{
psobat.setDouble(1,kenaikan);
psobat.setString(2,kdgudang.getText());
rsobat=psobat.executeQuery();
while(rsobat.next()){
iyembuilder.append("{\"KodeBarang\":\"").append(rsobat.getString("kode_brng")).append("\",\"NamaBarang\":\"").append(rsobat.getString("nama_brng").replaceAll("\"","")).append("\",\"Satuan\":\"").append(rsobat.getString("kode_sat")).append("\",\"Kandungan\":\"").append(rsobat.getString("letak_barang")).append("\",\"HargaKaryawan\":\"").append(Valid.roundUp(rsobat.getDouble("harga"),100)).append("\",\"HargaRalan\":\"").append(Valid.roundUp(rsobat.getDouble("harga"),100)).append("\",\"HargaBeliLuar\":\"").append(Valid.roundUp(rsobat.getDouble("harga"),100)).append("\",\"HargaUtama\":\"").append(Valid.roundUp(rsobat.getDouble("harga"),100)).append("\",\"Jenis\":\"").append(rsobat.getString("nama")).append("\",\"Kategori\":\"").append(rsobat.getString("kategori")).append("\",\"Golongan\":\"").append(rsobat.getString("golongan")).append("\",\"IndustriFarmasi\":\"").append(rsobat.getString("nama_industri")).append("\",\"HargaBeli\":\"").append(rsobat.getDouble("dasar")).append("\",\"Stok\":\"").append(rsobat.getDouble("stok")).append("\",\"Kapasitas\":\"").append(rsobat.getDouble("kapasitas")).append("\",\"NoBatch\":\"\",\"NoFaktur\":\"\",\"Kadaluarsa\":\"\"},");
}
}catch(Exception e){
System.out.println("Notifikasi : "+e);
}finally{
if(rsobat != null){
rsobat.close();
}
if(psobat != null){
psobat.close();
}
}
}
}else{
if(aktifkanbatch.equals("yes")){
if(aktifpcare.equals("yes")){
sql="select data_batch.kode_brng, databarang.nama_brng,jenis.nama, databarang.kode_sat,data_batch.karyawan,data_batch.ralan,data_batch.beliluar,"+
" databarang.letak_barang,data_batch.utama,industrifarmasi.nama_industri,data_batch.h_beli,kategori_barang.nama as kategori,golongan_barang.nama as golongan, "+
" data_batch.no_batch,data_batch.no_faktur,data_batch.tgl_kadaluarsa,gudangbarang.stok,data_batch."+hppfarmasi+" as dasar,databarang.kapasitas "+
" from data_batch inner join databarang on data_batch.kode_brng=databarang.kode_brng "+
" inner join jenis on databarang.kdjns=jenis.kdjns "+
" inner join industrifarmasi on industrifarmasi.kode_industri=databarang.kode_industri "+
" inner join golongan_barang on databarang.kode_golongan=golongan_barang.kode "+
" inner join kategori_barang on databarang.kode_kategori=kategori_barang.kode "+
" inner join maping_obat_pcare on maping_obat_pcare.kode_brng=databarang.kode_brng "+
" inner join gudangbarang on gudangbarang.kode_brng=data_batch.kode_brng and gudangbarang.no_batch=data_batch.no_batch and gudangbarang.no_faktur=data_batch.no_faktur ";
}else{
sql="select data_batch.kode_brng, databarang.nama_brng,jenis.nama, databarang.kode_sat,data_batch.karyawan,data_batch.ralan,data_batch.beliluar,"+
" databarang.letak_barang,data_batch.utama,industrifarmasi.nama_industri,data_batch.h_beli,kategori_barang.nama as kategori,golongan_barang.nama as golongan, "+
" data_batch.no_batch,data_batch.no_faktur,data_batch.tgl_kadaluarsa,gudangbarang.stok,data_batch."+hppfarmasi+" as dasar,databarang.kapasitas "+
" from data_batch inner join databarang on data_batch.kode_brng=databarang.kode_brng "+
" inner join jenis on databarang.kdjns=jenis.kdjns "+
" inner join industrifarmasi on industrifarmasi.kode_industri=databarang.kode_industri "+
" inner join golongan_barang on databarang.kode_golongan=golongan_barang.kode "+
" inner join kategori_barang on databarang.kode_kategori=kategori_barang.kode "+
" inner join gudangbarang on gudangbarang.kode_brng=data_batch.kode_brng and gudangbarang.no_batch=data_batch.no_batch and gudangbarang.no_faktur=data_batch.no_faktur ";
}
psobat=koneksi.prepareStatement(sql+" where gudangbarang.stok>0 and gudangbarang.kd_bangsal=? order by data_batch.tgl_kadaluarsa asc");
try{
psobat.setString(1,kdgudang.getText());
rsobat=psobat.executeQuery();
while(rsobat.next()){
iyembuilder.append("{\"KodeBarang\":\"").append(rsobat.getString("kode_brng")).append("\",\"NamaBarang\":\"").append(rsobat.getString("nama_brng").replaceAll("\"","")).append("\",\"Satuan\":\"").append(rsobat.getString("kode_sat")).append("\",\"Kandungan\":\"").append(rsobat.getString("letak_barang")).append("\",\"HargaKaryawan\":\"").append(Valid.roundUp(rsobat.getDouble("karyawan"),100)).append("\",\"HargaRalan\":\"").append(Valid.roundUp(rsobat.getDouble("ralan"),100)).append("\",\"HargaBeliLuar\":\"").append(Valid.roundUp(rsobat.getDouble("beliluar"),100)).append("\",\"HargaUtama\":\"").append(Valid.roundUp(rsobat.getDouble("utama"),100)).append("\",\"Jenis\":\"").append(rsobat.getString("nama")).append("\",\"Kategori\":\"").append(rsobat.getString("kategori")).append("\",\"Golongan\":\"").append(rsobat.getString("golongan")).append("\",\"IndustriFarmasi\":\"").append(rsobat.getString("nama_industri")).append("\",\"HargaBeli\":\"").append(rsobat.getDouble("dasar")).append("\",\"Stok\":\"").append(rsobat.getDouble("stok")).append("\",\"Kapasitas\":\"").append(rsobat.getDouble("kapasitas")).append("\",\"NoBatch\":\"").append(rsobat.getString("no_batch")).append("\",\"NoFaktur\":\"").append(rsobat.getString("no_faktur")).append("\",\"Kadaluarsa\":\"").append(rsobat.getString("tgl_kadaluarsa")).append("\"},");
}
}catch(Exception e){
System.out.println("Notifikasi : "+e);
}finally{
if(rsobat != null){
rsobat.close();
}
if(psobat != null){
psobat.close();
}
}
}else{
if(aktifpcare.equals("yes")){
sql="select databarang.kode_brng, databarang.nama_brng,jenis.nama, databarang.kode_sat,databarang.karyawan,databarang.ralan,databarang.beliluar,gudangbarang.stok,"+
" databarang.letak_barang,databarang.utama,industrifarmasi.nama_industri,databarang.h_beli,kategori_barang.nama as kategori,golongan_barang.nama as golongan,databarang."+hppfarmasi+" as dasar,databarang.kapasitas "+
" from databarang inner join jenis on databarang.kdjns=jenis.kdjns "+
" inner join industrifarmasi on industrifarmasi.kode_industri=databarang.kode_industri "+
" inner join golongan_barang on databarang.kode_golongan=golongan_barang.kode "+
" inner join kategori_barang on databarang.kode_kategori=kategori_barang.kode "+
" inner join maping_obat_pcare on maping_obat_pcare.kode_brng=databarang.kode_brng "+
" inner join gudangbarang on databarang.kode_brng=gudangbarang.kode_brng ";
}else{
sql="select databarang.kode_brng, databarang.nama_brng,jenis.nama, databarang.kode_sat,databarang.karyawan,databarang.ralan,databarang.beliluar,gudangbarang.stok,"+
" databarang.letak_barang,databarang.utama,industrifarmasi.nama_industri,databarang.h_beli,kategori_barang.nama as kategori,golongan_barang.nama as golongan,databarang."+hppfarmasi+" as dasar,databarang.kapasitas "+
" from databarang inner join jenis on databarang.kdjns=jenis.kdjns "+
" inner join industrifarmasi on industrifarmasi.kode_industri=databarang.kode_industri "+
" inner join golongan_barang on databarang.kode_golongan=golongan_barang.kode "+
" inner join kategori_barang on databarang.kode_kategori=kategori_barang.kode "+
" inner join gudangbarang on databarang.kode_brng=gudangbarang.kode_brng ";
}
psobat=koneksi.prepareStatement(sql+" where gudangbarang.no_batch='' and gudangbarang.no_faktur='' and gudangbarang.stok>0 and gudangbarang.kd_bangsal=? and databarang.status='1' order by databarang.nama_brng");
try{
psobat.setString(1,kdgudang.getText());
rsobat=psobat.executeQuery();
while(rsobat.next()){
iyembuilder.append("{\"KodeBarang\":\"").append(rsobat.getString("kode_brng")).append("\",\"NamaBarang\":\"").append(rsobat.getString("nama_brng").replaceAll("\"","")).append("\",\"Satuan\":\"").append(rsobat.getString("kode_sat")).append("\",\"Kandungan\":\"").append(rsobat.getString("letak_barang")).append("\",\"HargaKaryawan\":\"").append(Valid.roundUp(rsobat.getDouble("karyawan"),100)).append("\",\"HargaRalan\":\"").append(Valid.roundUp(rsobat.getDouble("ralan"),100)).append("\",\"HargaBeliLuar\":\"").append(Valid.roundUp(rsobat.getDouble("beliluar"),100)).append("\",\"HargaUtama\":\"").append(Valid.roundUp(rsobat.getDouble("utama"),100)).append("\",\"Jenis\":\"").append(rsobat.getString("nama")).append("\",\"Kategori\":\"").append(rsobat.getString("kategori")).append("\",\"Golongan\":\"").append(rsobat.getString("golongan")).append("\",\"IndustriFarmasi\":\"").append(rsobat.getString("nama_industri")).append("\",\"HargaBeli\":\"").append(rsobat.getDouble("dasar")).append("\",\"Stok\":\"").append(rsobat.getDouble("stok")).append("\",\"Kapasitas\":\"").append(rsobat.getDouble("kapasitas")).append("\",\"NoBatch\":\"\",\"NoFaktur\":\"\",\"Kadaluarsa\":\"\"},");
}
}catch(Exception e){
System.out.println("Notifikasi : "+e);
}finally{
if(rsobat != null){
rsobat.close();
}
if(psobat != null){
psobat.close();
}
}
}
}
if (iyembuilder.length() > 0) {
iyembuilder.setLength(iyembuilder.length() - 1);
fileWriter.write("{\"beriobatralan\":["+iyembuilder+"]}");
fileWriter.flush();
}
fileWriter.close();
iyembuilder=null;
}catch(Exception e){
System.out.println("Notifikasi : "+e);
}
}
private void tampilcacheberiobat() {
try{
boolean[] pilih;
double[] jumlah,harga,eb,ts,stok,beli;
String[] kodebarang,namabarang,kodesatuan,letakbarang,namajenis,aturan,industri,kategori,golongan,nobatch,nofaktur,kadaluarsa;
z=0;
for(i=0;i0){
z++;
}
}
pilih=new boolean[z];
jumlah=new double[z];
harga=new double[z];
eb=new double[z];
ts=new double[z];
stok=new double[z];
kodebarang=new String[z];
namabarang=new String[z];
kodesatuan=new String[z];
letakbarang=new String[z];
namajenis=new String[z];
aturan=new String[z];
industri=new String[z];
beli=new double[z];
kategori=new String[z];
golongan=new String[z];
nobatch=new String[z];
nofaktur=new String[z];
kadaluarsa=new String[z];
z=0;
for(i=0;i0){
pilih[z]=Boolean.parseBoolean(tbObat.getValueAt(i,0).toString());
try {
jumlah[z]=Double.parseDouble(tbObat.getValueAt(i,1).toString());
} catch (Exception e) {
jumlah[z]=0;
}
kodebarang[z]=tbObat.getValueAt(i,2).toString();
namabarang[z]=tbObat.getValueAt(i,3).toString();
kodesatuan[z]=tbObat.getValueAt(i,4).toString();
letakbarang[z]=tbObat.getValueAt(i,5).toString();
try {
harga[z]=Double.parseDouble(tbObat.getValueAt(i,6).toString());
} catch (Exception e) {
harga[z]=0;
}
namajenis[z]=tbObat.getValueAt(i,7).toString();
try {
eb[z]=Double.parseDouble(tbObat.getValueAt(i,8).toString());
} catch (Exception e) {
eb[z]=0;
}
try {
ts[z]=Double.parseDouble(tbObat.getValueAt(i,9).toString());
} catch (Exception e) {
ts[z]=0;
}
try {
stok[z]=Double.parseDouble(tbObat.getValueAt(i,10).toString());
} catch (Exception e) {
stok[z]=0;
}
aturan[z]=tbObat.getValueAt(i,11).toString();
industri[z]=tbObat.getValueAt(i,12).toString();
try {
beli[z]=Double.parseDouble(tbObat.getValueAt(i,13).toString());
} catch (Exception e) {
beli[z]=0;
}
kategori[z]=tbObat.getValueAt(i,14).toString();
golongan[z]=tbObat.getValueAt(i,15).toString();
nobatch[z]=tbObat.getValueAt(i,16).toString();
nofaktur[z]=tbObat.getValueAt(i,17).toString();
try {
kadaluarsa[z]=tbObat.getValueAt(i,18).toString();
} catch (Exception e) {
kadaluarsa[z]="0000-00-00";
}
z++;
}
}
Valid.tabelKosong(tabModeobat);
for(i=0;i0){
if(aktifkanbatch.equals("yes")){
psobat=koneksi.prepareStatement(
"select databarang.kode_brng, databarang.nama_brng,jenis.nama,databarang.kode_sat,(databarang.h_beli+(databarang.h_beli*?)) as harga,"+
"databarang.letak_barang,industrifarmasi.nama_industri,databarang.h_beli,resep_dokter.jml,resep_dokter.aturan_pakai,kategori_barang.nama as kategori,"+
"golongan_barang.nama as golongan from databarang inner join jenis on databarang.kdjns=jenis.kdjns "+
"inner join golongan_barang on databarang.kode_golongan=golongan_barang.kode "+
"inner join kategori_barang on databarang.kode_kategori=kategori_barang.kode "+
"inner join industrifarmasi on industrifarmasi.kode_industri=databarang.kode_industri "+
"inner join resep_dokter on resep_dokter.kode_brng=databarang.kode_brng "+
"where resep_dokter.no_resep=? and databarang.status='1' order by databarang.nama_brng");
try{
psobat.setDouble(1,kenaikan);
psobat.setString(2,no_resep);
rsobat=psobat.executeQuery();
while(rsobat.next()){
no_batchcari="";tgl_kadaluarsacari="";no_fakturcari="";h_belicari=0;hargacari=0;sisacari=0;
psbatch=koneksi.prepareStatement(
"select data_batch.no_batch, data_batch.kode_brng, data_batch.tgl_beli, data_batch.tgl_kadaluarsa, data_batch.asal, data_batch.no_faktur, "+
"data_batch.h_beli,(data_batch.h_beli+(data_batch.h_beli*?)) as harga, gudangbarang.stok,data_batch."+hppfarmasi+" as dasar from data_batch inner join gudangbarang "+
"on data_batch.kode_brng=gudangbarang.kode_brng and data_batch.no_batch=gudangbarang.no_batch and data_batch.no_faktur=gudangbarang.no_faktur where "+
"gudangbarang.stok>0 and data_batch.kode_brng=? and gudangbarang.kd_bangsal=? order by data_batch.tgl_kadaluarsa,gudangbarang.stok desc limit 1");
try {
psbatch.setDouble(1,kenaikan);
psbatch.setString(2,rsobat.getString("kode_brng"));
psbatch.setString(3,kdgudang.getText());
rsbatch=psbatch.executeQuery();
while(rsbatch.next()){
no_batchcari=rsbatch.getString("no_batch");
tgl_kadaluarsacari=rsbatch.getString("tgl_kadaluarsa");
no_fakturcari=rsbatch.getString("no_faktur");
h_belicari=rsbatch.getDouble("dasar");
hargacari=rsbatch.getDouble("harga");
sisacari=rsbatch.getDouble("stok");
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rsbatch!=null){
rsbatch.close();
}
if(psbatch!=null){
psbatch.close();
}
}
if(rsobat.getDouble("jml")>sisacari){
JOptionPane.showMessageDialog(rootPane,"Maaf stok tidak mencukupi..!!");
tabModeobat.addRow(new Object[] {
false,sisacari,rsobat.getString("kode_brng"),rsobat.getString("nama_brng"),
rsobat.getString("kode_sat"),rsobat.getString("letak_barang"),Valid.roundUp(hargacari,100),
rsobat.getString("nama"),0,0,sisacari,rsobat.getString("aturan_pakai"),rsobat.getString("nama_industri"),
h_belicari,rsobat.getString("kategori"),rsobat.getString("golongan"),no_batchcari,no_fakturcari,tgl_kadaluarsacari
});
}else{
tabModeobat.addRow(new Object[] {
false,rsobat.getString("jml"),rsobat.getString("kode_brng"),rsobat.getString("nama_brng"),
rsobat.getString("kode_sat"),rsobat.getString("letak_barang"),Valid.roundUp(hargacari,100),
rsobat.getString("nama"),0,0,sisacari,rsobat.getString("aturan_pakai"),rsobat.getString("nama_industri"),
h_belicari,rsobat.getString("kategori"),rsobat.getString("golongan"),no_batchcari,no_fakturcari,tgl_kadaluarsacari
});
}
}
}catch(Exception e){
System.out.println("Notifikasi : "+e);
}finally{
if(rsobat != null){
rsobat.close();
}
if(psobat != null){
psobat.close();
}
}
}else{
psobat=koneksi.prepareStatement(
"select databarang.kode_brng, databarang.nama_brng,jenis.nama,databarang.kode_sat,(databarang.h_beli+(databarang.h_beli*?)) as harga,"+
"databarang.letak_barang,industrifarmasi.nama_industri,databarang.h_beli,databarang."+hppfarmasi+" as dasar, "+
"resep_dokter.jml, resep_dokter.aturan_pakai,kategori_barang.nama as kategori,golongan_barang.nama as golongan "+
"from databarang inner join jenis on databarang.kdjns=jenis.kdjns "+
"inner join golongan_barang on databarang.kode_golongan=golongan_barang.kode "+
"inner join kategori_barang on databarang.kode_kategori=kategori_barang.kode "+
"inner join industrifarmasi on industrifarmasi.kode_industri=databarang.kode_industri "+
"inner join resep_dokter on resep_dokter.kode_brng=databarang.kode_brng "+
"where resep_dokter.no_resep=? and databarang.status='1' order by databarang.nama_brng");
try{
psobat.setDouble(1,kenaikan);
psobat.setString(2,no_resep);
rsobat=psobat.executeQuery();
while(rsobat.next()){
sisacari=0;
psstok=koneksi.prepareStatement("select ifnull(gudangbarang.stok,'0') from gudangbarang where gudangbarang.kd_bangsal=? and gudangbarang.kode_brng=? and gudangbarang.no_batch='' and gudangbarang.no_faktur=''");
try {
psstok.setString(1,kdgudang.getText());
psstok.setString(2,rsobat.getString("kode_brng"));
rsstok=psstok.executeQuery();
if(rsstok.next()){
sisacari=rsstok.getDouble(1);
}
} catch (Exception e) {
sisacari=0;
System.out.println("Notifikasi : "+e);
}finally{
if(rsstok != null){
rsstok.close();
}
if(psstok != null){
psstok.close();
}
}
if(rsobat.getDouble("jml")>sisacari){
JOptionPane.showMessageDialog(rootPane,"Maaf stok tidak mencukupi..!!");
tabModeobat.addRow(new Object[] {false,sisacari,rsobat.getString("kode_brng"),rsobat.getString("nama_brng"),
rsobat.getString("kode_sat"),rsobat.getString("letak_barang"),Valid.roundUp(rsobat.getDouble("harga"),100),
rsobat.getString("nama"),0,0,sisacari,rsobat.getString("aturan_pakai"),rsobat.getString("nama_industri"),
rsobat.getDouble("dasar"),rsobat.getString("kategori"),rsobat.getString("golongan"),"","",""
});
}else{
tabModeobat.addRow(new Object[] {false,rsobat.getString("jml"),rsobat.getString("kode_brng"),rsobat.getString("nama_brng"),
rsobat.getString("kode_sat"),rsobat.getString("letak_barang"),Valid.roundUp(rsobat.getDouble("harga"),100),
rsobat.getString("nama"),0,0,sisacari,rsobat.getString("aturan_pakai"),rsobat.getString("nama_industri"),
rsobat.getDouble("dasar"),rsobat.getString("kategori"),rsobat.getString("golongan"),"","",""
});
}
}
}catch(Exception e){
System.out.println("Notifikasi : "+e);
}finally{
if(rsobat != null){
rsobat.close();
}
if(psobat != null){
psobat.close();
}
}
}
}else{
if(aktifkanbatch.equals("yes")){
psobat=koneksi.prepareStatement(
"select databarang.kode_brng, databarang.nama_brng,jenis.nama,databarang.kode_sat,databarang.karyawan,databarang.ralan,"+
"databarang.beliluar,databarang.letak_barang,databarang.utama,industrifarmasi.nama_industri,databarang.h_beli,resep_dokter.jml, "+
"resep_dokter.aturan_pakai,kategori_barang.nama as kategori,golongan_barang.nama as golongan "+
"from databarang inner join jenis on databarang.kdjns=jenis.kdjns "+
"inner join golongan_barang on databarang.kode_golongan=golongan_barang.kode "+
"inner join kategori_barang on databarang.kode_kategori=kategori_barang.kode "+
"inner join industrifarmasi on industrifarmasi.kode_industri=databarang.kode_industri "+
"inner join resep_dokter on resep_dokter.kode_brng=databarang.kode_brng "+
"where resep_dokter.no_resep=? and databarang.status='1' order by databarang.nama_brng");
try{
psobat.setString(1,no_resep);
rsobat=psobat.executeQuery();
while(rsobat.next()){
no_batchcari="";tgl_kadaluarsacari="";no_fakturcari="";h_belicari=0;hargacari=0;sisacari=0;
psbatch=koneksi.prepareStatement(
"select data_batch.no_batch, data_batch.kode_brng, data_batch.tgl_beli, data_batch.tgl_kadaluarsa, data_batch.asal, data_batch.no_faktur, "+
"data_batch.h_beli, data_batch.ralan, data_batch.kelas1, data_batch.kelas2, data_batch.kelas3, data_batch.utama, data_batch.vip, data_batch.vvip, data_batch.beliluar, "+
"data_batch.jualbebas, data_batch.karyawan, data_batch.jumlahbeli,gudangbarang.stok,data_batch."+hppfarmasi+" as dasar from data_batch inner join gudangbarang "+
"on data_batch.kode_brng=gudangbarang.kode_brng and data_batch.no_batch=gudangbarang.no_batch and data_batch.no_faktur=gudangbarang.no_faktur where "+
"gudangbarang.stok>0 and data_batch.kode_brng=? and gudangbarang.kd_bangsal=? order by data_batch.tgl_kadaluarsa,gudangbarang.stok desc limit 1");
try {
psbatch.setString(1,rsobat.getString("kode_brng"));
psbatch.setString(2,kdgudang.getText());
rsbatch=psbatch.executeQuery();
while(rsbatch.next()){
no_batchcari=rsbatch.getString("no_batch");
tgl_kadaluarsacari=rsbatch.getString("tgl_kadaluarsa");
no_fakturcari=rsbatch.getString("no_faktur");
h_belicari=rsbatch.getDouble("dasar");
if(Jeniskelas.getSelectedItem().equals("Karyawan")){
hargacari=rsbatch.getDouble("karyawan");
}else if(Jeniskelas.getSelectedItem().equals("Rawat Jalan")){
hargacari=rsbatch.getDouble("ralan");
}else if(Jeniskelas.getSelectedItem().equals("Beli Luar")){
hargacari=rsbatch.getDouble("beliluar");
}else if(Jeniskelas.getSelectedItem().equals("Utama/BPJS")){
hargacari=rsbatch.getDouble("utama");
}
sisacari=rsbatch.getDouble("stok");
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rsbatch!=null){
rsbatch.close();
}
if(psbatch!=null){
psbatch.close();
}
}
if(rsobat.getDouble("jml")>sisacari){
JOptionPane.showMessageDialog(rootPane,"Maaf stok tidak mencukupi..!!");
tabModeobat.addRow(new Object[] {
false,sisacari,rsobat.getString("kode_brng"),rsobat.getString("nama_brng"),
rsobat.getString("kode_sat"),rsobat.getString("letak_barang"),Valid.roundUp(hargacari,100),
rsobat.getString("nama"),0,0,sisacari,rsobat.getString("aturan_pakai"),rsobat.getString("nama_industri"),
h_belicari,rsobat.getString("kategori"),rsobat.getString("golongan"),no_batchcari,no_fakturcari,tgl_kadaluarsacari
});
}else{
tabModeobat.addRow(new Object[] {
false,rsobat.getString("jml"),rsobat.getString("kode_brng"),rsobat.getString("nama_brng"),
rsobat.getString("kode_sat"),rsobat.getString("letak_barang"),Valid.roundUp(hargacari,100),
rsobat.getString("nama"),0,0,sisacari,rsobat.getString("aturan_pakai"),rsobat.getString("nama_industri"),
h_belicari,rsobat.getString("kategori"),rsobat.getString("golongan"),no_batchcari,no_fakturcari,tgl_kadaluarsacari
});
}
}
}catch(Exception e){
System.out.println("Notifikasi : "+e);
}finally{
if(rsobat != null){
rsobat.close();
}
if(psobat != null){
psobat.close();
}
}
}else{
psobat=koneksi.prepareStatement(
"select databarang.kode_brng, databarang.nama_brng,jenis.nama,databarang.kode_sat,databarang.karyawan,databarang.ralan,"+
"databarang.beliluar,databarang.letak_barang,databarang.utama,industrifarmasi.nama_industri,databarang.h_beli,resep_dokter.jml,databarang."+hppfarmasi+" as dasar, "+
"resep_dokter.aturan_pakai,kategori_barang.nama as kategori,golongan_barang.nama as golongan "+
"from databarang inner join jenis on databarang.kdjns=jenis.kdjns "+
"inner join golongan_barang on databarang.kode_golongan=golongan_barang.kode "+
"inner join kategori_barang on databarang.kode_kategori=kategori_barang.kode "+
"inner join industrifarmasi on industrifarmasi.kode_industri=databarang.kode_industri "+
"inner join resep_dokter on resep_dokter.kode_brng=databarang.kode_brng "+
"where resep_dokter.no_resep=? and databarang.status='1' order by databarang.nama_brng");
try{
psobat.setString(1,no_resep);
rsobat=psobat.executeQuery();
while(rsobat.next()){
sisacari=0;
psstok=koneksi.prepareStatement("select ifnull(gudangbarang.stok,'0') from gudangbarang where gudangbarang.kd_bangsal=? and gudangbarang.kode_brng=? and gudangbarang.no_batch='' and gudangbarang.no_faktur=''");
try {
psstok.setString(1,kdgudang.getText());
psstok.setString(2,rsobat.getString("kode_brng"));
rsstok=psstok.executeQuery();
if(rsstok.next()){
sisacari=rsstok.getDouble(1);
}
} catch (Exception e) {
sisacari=0;
System.out.println("Notifikasi : "+e);
}finally{
if(rsstok != null){
rsstok.close();
}
if(psstok != null){
psstok.close();
}
}
if(rsobat.getDouble("jml")>sisacari){
JOptionPane.showMessageDialog(rootPane,"Maaf stok tidak mencukupi..!!");
if(Jeniskelas.getSelectedItem().equals("Karyawan")){
tabModeobat.addRow(new Object[] {false,sisacari,rsobat.getString("kode_brng"),rsobat.getString("nama_brng"),
rsobat.getString("kode_sat"),rsobat.getString("letak_barang"),Valid.roundUp(rsobat.getDouble("karyawan"),100),
rsobat.getString("nama"),0,0,sisacari,rsobat.getString("aturan_pakai"),rsobat.getString("nama_industri"),
rsobat.getDouble("dasar"),rsobat.getString("kategori"),rsobat.getString("golongan"),"","",""
});
}else if(Jeniskelas.getSelectedItem().equals("Rawat Jalan")){
tabModeobat.addRow(new Object[] {false,sisacari,rsobat.getString("kode_brng"),rsobat.getString("nama_brng"),
rsobat.getString("kode_sat"),rsobat.getString("letak_barang"),Valid.roundUp(rsobat.getDouble("ralan"),100),
rsobat.getString("nama"),0,0,sisacari,rsobat.getString("aturan_pakai"),rsobat.getString("nama_industri"),
rsobat.getDouble("dasar"),rsobat.getString("kategori"),rsobat.getString("golongan"),"","",""
});
}else if(Jeniskelas.getSelectedItem().equals("Beli Luar")){
tabModeobat.addRow(new Object[] {false,sisacari,rsobat.getString("kode_brng"),rsobat.getString("nama_brng"),
rsobat.getString("kode_sat"),rsobat.getString("letak_barang"),Valid.roundUp(rsobat.getDouble("beliluar"),100),
rsobat.getString("nama"),0,0,sisacari,rsobat.getString("aturan_pakai"),rsobat.getString("nama_industri"),
rsobat.getDouble("dasar"),rsobat.getString("kategori"),rsobat.getString("golongan"),"","",""
});
}else if(Jeniskelas.getSelectedItem().equals("Utama/BPJS")){
tabModeobat.addRow(new Object[] {false,sisacari,rsobat.getString("kode_brng"),rsobat.getString("nama_brng"),
rsobat.getString("kode_sat"),rsobat.getString("letak_barang"),Valid.roundUp(rsobat.getDouble("utama"),100),
rsobat.getString("nama"),0,0,sisacari,rsobat.getString("aturan_pakai"),rsobat.getString("nama_industri"),
rsobat.getDouble("dasar"),rsobat.getString("kategori"),rsobat.getString("golongan"),"","",""
});
}
}else{
if(Jeniskelas.getSelectedItem().equals("Karyawan")){
tabModeobat.addRow(new Object[] {false,rsobat.getString("jml"),rsobat.getString("kode_brng"),rsobat.getString("nama_brng"),
rsobat.getString("kode_sat"),rsobat.getString("letak_barang"),Valid.roundUp(rsobat.getDouble("karyawan"),100),
rsobat.getString("nama"),0,0,sisacari,rsobat.getString("aturan_pakai"),rsobat.getString("nama_industri"),
rsobat.getDouble("dasar"),rsobat.getString("kategori"),rsobat.getString("golongan"),"","",""
});
}else if(Jeniskelas.getSelectedItem().equals("Rawat Jalan")){
tabModeobat.addRow(new Object[] {false,rsobat.getString("jml"),rsobat.getString("kode_brng"),rsobat.getString("nama_brng"),
rsobat.getString("kode_sat"),rsobat.getString("letak_barang"),Valid.roundUp(rsobat.getDouble("ralan"),100),
rsobat.getString("nama"),0,0,sisacari,rsobat.getString("aturan_pakai"),rsobat.getString("nama_industri"),
rsobat.getDouble("dasar"),rsobat.getString("kategori"),rsobat.getString("golongan"),"","",""
});
}else if(Jeniskelas.getSelectedItem().equals("Beli Luar")){
tabModeobat.addRow(new Object[] {false,rsobat.getString("jml"),rsobat.getString("kode_brng"),rsobat.getString("nama_brng"),
rsobat.getString("kode_sat"),rsobat.getString("letak_barang"),Valid.roundUp(rsobat.getDouble("beliluar"),100),
rsobat.getString("nama"),0,0,sisacari,rsobat.getString("aturan_pakai"),rsobat.getString("nama_industri"),
rsobat.getDouble("dasar"),rsobat.getString("kategori"),rsobat.getString("golongan"),"","",""
});
}else if(Jeniskelas.getSelectedItem().equals("Utama/BPJS")){
tabModeobat.addRow(new Object[] {false,rsobat.getString("jml"),rsobat.getString("kode_brng"),rsobat.getString("nama_brng"),
rsobat.getString("kode_sat"),rsobat.getString("letak_barang"),Valid.roundUp(rsobat.getDouble("utama"),100),
rsobat.getString("nama"),0,0,sisacari,rsobat.getString("aturan_pakai"),rsobat.getString("nama_industri"),
rsobat.getDouble("dasar"),rsobat.getString("kategori"),rsobat.getString("golongan"),"","",""
});
}
}
}
}catch(Exception e){
System.out.println("Notifikasi : "+e);
}finally{
if(rsobat != null){
rsobat.close();
}
if(psobat != null){
psobat.close();
}
}
}
}
for(i=0;i0){
if(aktifkanbatch.equals("yes")){
ps2=koneksi.prepareStatement("select databarang.kode_brng,databarang.nama_brng,resep_dokter_racikan_detail.jml,resep_dokter_racikan_detail.kandungan,"+
"databarang.kode_sat,(databarang.h_beli+(databarang.h_beli*?)) as harga,databarang.letak_barang,"+
"databarang.h_beli,kategori_barang.nama as kategori,golongan_barang.nama as golongan,"+
"industrifarmasi.nama_industri,jenis.nama as jenis,databarang.kapasitas "+
"from resep_dokter_racikan_detail inner join databarang on resep_dokter_racikan_detail.kode_brng=databarang.kode_brng "+
"inner join jenis on databarang.kdjns=jenis.kdjns "+
"inner join golongan_barang on databarang.kode_golongan=golongan_barang.kode "+
"inner join kategori_barang on databarang.kode_kategori=kategori_barang.kode "+
"inner join industrifarmasi on industrifarmasi.kode_industri=databarang.kode_industri "+
"where resep_dokter_racikan_detail.no_resep=? and resep_dokter_racikan_detail.no_racik=? order by databarang.kode_brng");
try {
ps2.setDouble(1,kenaikan);
ps2.setString(2,no_resep);
ps2.setString(3,rsobat.getString("no_racik"));
rs2=ps2.executeQuery();
while(rs2.next()){
no_batchcari="";tgl_kadaluarsacari="";no_fakturcari="";h_belicari=0;hargacari=0;sisacari=0;
psbatch=koneksi.prepareStatement(
"select data_batch.no_batch, data_batch.kode_brng, data_batch.tgl_beli, data_batch.tgl_kadaluarsa, data_batch.asal, data_batch.no_faktur, "+
"data_batch.h_beli,(data_batch.h_beli+(data_batch.h_beli*?)) as harga, gudangbarang.stok,data_batch."+hppfarmasi+" as dasar from data_batch inner join gudangbarang "+
"on data_batch.kode_brng=gudangbarang.kode_brng and data_batch.no_batch=gudangbarang.no_batch and data_batch.no_faktur=gudangbarang.no_faktur where "+
"gudangbarang.stok>0 and data_batch.kode_brng=? and gudangbarang.kd_bangsal=? order by data_batch.tgl_kadaluarsa,gudangbarang.stok desc limit 1");
try {
psbatch.setDouble(1,kenaikan);
psbatch.setString(2,rs2.getString("kode_brng"));
psbatch.setString(3,kdgudang.getText());
rsbatch=psbatch.executeQuery();
while(rsbatch.next()){
no_batchcari=rsbatch.getString("no_batch");
tgl_kadaluarsacari=rsbatch.getString("tgl_kadaluarsa");
no_fakturcari=rsbatch.getString("no_faktur");
h_belicari=rsbatch.getDouble("dasar");
hargacari=rsbatch.getDouble("harga");
sisacari=rsbatch.getDouble("stok");
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rsbatch!=null){
rsbatch.close();
}
if(psbatch!=null){
psbatch.close();
}
}
if(rs2.getDouble("jml")>sisacari){
JOptionPane.showMessageDialog(rootPane,"Maaf stok tidak mencukupi..!!");
tabModeDetailObatRacikan.addRow(new Object[]{
rsobat.getString("no_racik"),rs2.getString("kode_brng"),rs2.getString("nama_brng"),
rs2.getString("kode_sat"),hargacari,h_belicari,
rs2.getString("jenis"),sisacari,rs2.getDouble("kapasitas"),rs2.getString("kandungan"),
sisacari,0,0,rs2.getString("nama_industri"),rs2.getString("kategori"),
rs2.getString("golongan"),no_batchcari,no_fakturcari,tgl_kadaluarsacari
});
}else{
tabModeDetailObatRacikan.addRow(new Object[]{
rsobat.getString("no_racik"),rs2.getString("kode_brng"),rs2.getString("nama_brng"),
rs2.getString("kode_sat"),hargacari,h_belicari,
rs2.getString("jenis"),sisacari,rs2.getDouble("kapasitas"),rs2.getString("kandungan"),
rs2.getDouble("jml"),0,0,rs2.getString("nama_industri"),rs2.getString("kategori"),
rs2.getString("golongan"),no_batchcari,no_fakturcari,tgl_kadaluarsacari
});
}
}
} catch (Exception e) {
System.out.println("Notifikasi 3 : "+e);
} finally{
if(rs2!=null){
rs2.close();
}
if(ps2!=null){
ps2.close();
}
}
}else{
ps2=koneksi.prepareStatement("select databarang.kode_brng,databarang.nama_brng,resep_dokter_racikan_detail.jml,resep_dokter_racikan_detail.kandungan,"+
"databarang.kode_sat,(databarang.h_beli+(databarang.h_beli*?)) as harga,databarang.letak_barang,"+
"databarang.h_beli,kategori_barang.nama as kategori,golongan_barang.nama as golongan,databarang."+hppfarmasi+" as dasar,"+
"industrifarmasi.nama_industri,jenis.nama as jenis,databarang.kapasitas "+
"from resep_dokter_racikan_detail inner join databarang on resep_dokter_racikan_detail.kode_brng=databarang.kode_brng "+
"inner join jenis on databarang.kdjns=jenis.kdjns "+
"inner join golongan_barang on databarang.kode_golongan=golongan_barang.kode "+
"inner join kategori_barang on databarang.kode_kategori=kategori_barang.kode "+
"inner join industrifarmasi on industrifarmasi.kode_industri=databarang.kode_industri "+
"where resep_dokter_racikan_detail.no_resep=? and resep_dokter_racikan_detail.no_racik=? order by databarang.kode_brng");
try {
ps2.setDouble(1,kenaikan);
ps2.setString(2,no_resep);
ps2.setString(3,rsobat.getString("no_racik"));
rs2=ps2.executeQuery();
while(rs2.next()){
sisacari=0;
psstok=koneksi.prepareStatement("select ifnull(gudangbarang.stok,'0') from gudangbarang where gudangbarang.kd_bangsal=? and gudangbarang.kode_brng=? and gudangbarang.no_batch='' and gudangbarang.no_faktur=''");
try {
psstok.setString(1,kdgudang.getText());
psstok.setString(2,rs2.getString("kode_brng"));
rsstok=psstok.executeQuery();
if(rsstok.next()){
sisacari=rsstok.getDouble(1);
}
} catch (Exception e) {
sisacari=0;
System.out.println("Notifikasi : "+e);
}finally{
if(rsstok != null){
rsstok.close();
}
if(psstok != null){
psstok.close();
}
}
if(rs2.getDouble("jml")>sisacari){
JOptionPane.showMessageDialog(rootPane,"Maaf stok tidak mencukupi..!!");
tabModeDetailObatRacikan.addRow(new Object[]{
rsobat.getString("no_racik"),rs2.getString("kode_brng"),rs2.getString("nama_brng"),
rs2.getString("kode_sat"),rs2.getDouble("harga"),rs2.getDouble("dasar"),
rs2.getString("jenis"),sisacari,rs2.getDouble("kapasitas"),rs2.getString("kandungan"),
sisacari,0,0,rs2.getString("nama_industri"),rs2.getString("kategori"),
rs2.getString("golongan"),"","",""
});
}else{
tabModeDetailObatRacikan.addRow(new Object[]{
rsobat.getString("no_racik"),rs2.getString("kode_brng"),rs2.getString("nama_brng"),
rs2.getString("kode_sat"),rs2.getDouble("harga"),rs2.getDouble("dasar"),
rs2.getString("jenis"),sisacari,rs2.getDouble("kapasitas"),rs2.getString("kandungan"),
rs2.getDouble("jml"),0,0,rs2.getString("nama_industri"),rs2.getString("kategori"),
rs2.getString("golongan"),"","",""
});
}
}
} catch (Exception e) {
System.out.println("Notifikasi 3 : "+e);
} finally{
if(rs2!=null){
rs2.close();
}
if(ps2!=null){
ps2.close();
}
}
}
}else{
if(aktifkanbatch.equals("yes")){
ps2=koneksi.prepareStatement("select databarang.kode_brng,databarang.nama_brng,resep_dokter_racikan_detail.jml,resep_dokter_racikan_detail.kandungan,"+
"databarang.kode_sat,databarang.karyawan,databarang.ralan,databarang.beliluar,databarang.letak_barang,"+
"databarang.utama,databarang.h_beli,kategori_barang.nama as kategori,golongan_barang.nama as golongan,"+
"industrifarmasi.nama_industri,jenis.nama as jenis,databarang.kapasitas "+
"from resep_dokter_racikan_detail inner join databarang on resep_dokter_racikan_detail.kode_brng=databarang.kode_brng "+
"inner join jenis on databarang.kdjns=jenis.kdjns "+
"inner join golongan_barang on databarang.kode_golongan=golongan_barang.kode "+
"inner join kategori_barang on databarang.kode_kategori=kategori_barang.kode "+
"inner join industrifarmasi on industrifarmasi.kode_industri=databarang.kode_industri "+
"where resep_dokter_racikan_detail.no_resep=? and resep_dokter_racikan_detail.no_racik=? order by databarang.kode_brng");
try {
ps2.setString(1,no_resep);
ps2.setString(2,rsobat.getString("no_racik"));
rs2=ps2.executeQuery();
while(rs2.next()){
no_batchcari="";tgl_kadaluarsacari="";no_fakturcari="";h_belicari=0;hargacari=0;sisacari=0;
psbatch=koneksi.prepareStatement(
"select data_batch.no_batch, data_batch.kode_brng, data_batch.tgl_beli, data_batch.tgl_kadaluarsa, data_batch.asal, data_batch.no_faktur, "+
"data_batch.h_beli, data_batch.ralan, data_batch.kelas1, data_batch.kelas2, data_batch.kelas3, data_batch.utama, data_batch.vip, data_batch.vvip, data_batch.beliluar, "+
"data_batch.jualbebas, data_batch.karyawan, data_batch.jumlahbeli,gudangbarang.stok,data_batch."+hppfarmasi+" as dasar from data_batch inner join gudangbarang "+
"on data_batch.kode_brng=gudangbarang.kode_brng and data_batch.no_batch=gudangbarang.no_batch and data_batch.no_faktur=gudangbarang.no_faktur where "+
"gudangbarang.stok>0 and data_batch.kode_brng=? and gudangbarang.kd_bangsal=? order by data_batch.tgl_kadaluarsa,gudangbarang.stok desc limit 1");
try {
psbatch.setString(1,rs2.getString("kode_brng"));
psbatch.setString(2,kdgudang.getText());
rsbatch=psbatch.executeQuery();
while(rsbatch.next()){
no_batchcari=rsbatch.getString("no_batch");
tgl_kadaluarsacari=rsbatch.getString("tgl_kadaluarsa");
no_fakturcari=rsbatch.getString("no_faktur");
h_belicari=rsbatch.getDouble("dasar");
if(Jeniskelas.getSelectedItem().equals("Karyawan")){
hargacari=rsbatch.getDouble("karyawan");
}else if(Jeniskelas.getSelectedItem().equals("Rawat Jalan")){
hargacari=rsbatch.getDouble("ralan");
}else if(Jeniskelas.getSelectedItem().equals("Beli Luar")){
hargacari=rsbatch.getDouble("beliluar");
}else if(Jeniskelas.getSelectedItem().equals("Utama/BPJS")){
hargacari=rsbatch.getDouble("utama");
}
sisacari=rsbatch.getDouble("stok");
}
} catch (Exception e) {
System.out.println("Notif Detail Racikan : "+e);
} finally{
if(rsbatch!=null){
rsbatch.close();
}
if(psbatch!=null){
psbatch.close();
}
}
if(rs2.getDouble("jml")>sisacari){
JOptionPane.showMessageDialog(rootPane,"Maaf stok tidak mencukupi..!!");
tabModeDetailObatRacikan.addRow(new Object[]{
rsobat.getString("no_racik"),rs2.getString("kode_brng"),rs2.getString("nama_brng"),
rs2.getString("kode_sat"),hargacari,h_belicari,
rs2.getString("jenis"),sisacari,rs2.getDouble("kapasitas"),rs2.getString("kandungan"),
sisacari,0,0,rs2.getString("nama_industri"),rs2.getString("kategori"),
rs2.getString("golongan"),no_batchcari,no_fakturcari,tgl_kadaluarsacari
});
}else{
tabModeDetailObatRacikan.addRow(new Object[]{
rsobat.getString("no_racik"),rs2.getString("kode_brng"),rs2.getString("nama_brng"),
rs2.getString("kode_sat"),hargacari,h_belicari,
rs2.getString("jenis"),sisacari,rs2.getDouble("kapasitas"),rs2.getString("kandungan"),
rs2.getDouble("jml"),0,0,rs2.getString("nama_industri"),rs2.getString("kategori"),
rs2.getString("golongan"),no_batchcari,no_fakturcari,tgl_kadaluarsacari
});
}
}
} catch (Exception e) {
System.out.println("Notifikasi 3 : "+e);
} finally{
if(rs2!=null){
rs2.close();
}
if(ps2!=null){
ps2.close();
}
}
}else{
ps2=koneksi.prepareStatement("select databarang.kode_brng,databarang.nama_brng,resep_dokter_racikan_detail.jml,resep_dokter_racikan_detail.kandungan,"+
"databarang.kode_sat,databarang.karyawan,databarang.ralan,databarang.beliluar,databarang.letak_barang,"+
"databarang.utama,databarang.h_beli,kategori_barang.nama as kategori,golongan_barang.nama as golongan,databarang."+hppfarmasi+" as dasar,"+
"industrifarmasi.nama_industri,jenis.nama as jenis,databarang.kapasitas "+
"from resep_dokter_racikan_detail inner join databarang on resep_dokter_racikan_detail.kode_brng=databarang.kode_brng "+
"inner join jenis on databarang.kdjns=jenis.kdjns "+
"inner join golongan_barang on databarang.kode_golongan=golongan_barang.kode "+
"inner join kategori_barang on databarang.kode_kategori=kategori_barang.kode "+
"inner join industrifarmasi on industrifarmasi.kode_industri=databarang.kode_industri "+
"where resep_dokter_racikan_detail.no_resep=? and resep_dokter_racikan_detail.no_racik=? order by databarang.kode_brng");
try {
ps2.setString(1,no_resep);
ps2.setString(2,rsobat.getString("no_racik"));
rs2=ps2.executeQuery();
while(rs2.next()){
sisacari=0;
psstok=koneksi.prepareStatement("select ifnull(gudangbarang.stok,'0') from gudangbarang where gudangbarang.kd_bangsal=? and gudangbarang.kode_brng=? and gudangbarang.no_batch='' and gudangbarang.no_faktur=''");
try {
psstok.setString(1,kdgudang.getText());
psstok.setString(2,rs2.getString("kode_brng"));
rsstok=psstok.executeQuery();
if(rsstok.next()){
sisacari=rsstok.getDouble(1);
}
} catch (Exception e) {
sisacari=0;
System.out.println("Notifikasi : "+e);
}finally{
if(rsstok != null){
rsstok.close();
}
if(psstok != null){
psstok.close();
}
}
if(rs2.getDouble("jml")>sisacari){
JOptionPane.showMessageDialog(rootPane,"Maaf stok tidak mencukupi..!!");
if(Jeniskelas.getSelectedItem().equals("Karyawan")){
tabModeDetailObatRacikan.addRow(new Object[]{
rsobat.getString("no_racik"),rs2.getString("kode_brng"),rs2.getString("nama_brng"),
rs2.getString("kode_sat"),rs2.getDouble("karyawan"),rs2.getDouble("dasar"),
rs2.getString("jenis"),sisacari,rs2.getDouble("kapasitas"),rs2.getString("kandungan"),
sisacari,0,0,rs2.getString("nama_industri"),rs2.getString("kategori"),
rs2.getString("golongan"),"","",""
});
}else if(Jeniskelas.getSelectedItem().equals("Rawat Jalan")){
tabModeDetailObatRacikan.addRow(new Object[]{
rsobat.getString("no_racik"),rs2.getString("kode_brng"),rs2.getString("nama_brng"),
rs2.getString("kode_sat"),rs2.getDouble("ralan"),rs2.getDouble("dasar"),
rs2.getString("jenis"),sisacari,rs2.getDouble("kapasitas"),rs2.getString("kandungan"),
sisacari,0,0,rs2.getString("nama_industri"),rs2.getString("kategori"),
rs2.getString("golongan"),"","",""
});
}else if(Jeniskelas.getSelectedItem().equals("Beli Luar")){
tabModeDetailObatRacikan.addRow(new Object[]{
rsobat.getString("no_racik"),rs2.getString("kode_brng"),rs2.getString("nama_brng"),
rs2.getString("kode_sat"),rs2.getDouble("beliluar"),rs2.getDouble("dasar"),
rs2.getString("jenis"),sisacari,rs2.getDouble("kapasitas"),rs2.getString("kandungan"),
sisacari,0,0,rs2.getString("nama_industri"),rs2.getString("kategori"),
rs2.getString("golongan"),"","",""
});
}else if(Jeniskelas.getSelectedItem().equals("Utama/BPJS")){
tabModeDetailObatRacikan.addRow(new Object[]{
rsobat.getString("no_racik"),rs2.getString("kode_brng"),rs2.getString("nama_brng"),
rs2.getString("kode_sat"),rs2.getDouble("utama"),rs2.getDouble("dasar"),
rs2.getString("jenis"),sisacari,rs2.getDouble("kapasitas"),rs2.getString("kandungan"),
sisacari,0,0,rs2.getString("nama_industri"),rs2.getString("kategori"),
rs2.getString("golongan"),"","",""
});
}
}else{
if(Jeniskelas.getSelectedItem().equals("Karyawan")){
tabModeDetailObatRacikan.addRow(new Object[]{
rsobat.getString("no_racik"),rs2.getString("kode_brng"),rs2.getString("nama_brng"),
rs2.getString("kode_sat"),rs2.getDouble("karyawan"),rs2.getDouble("dasar"),
rs2.getString("jenis"),sisacari,rs2.getDouble("kapasitas"),rs2.getString("kandungan"),
rs2.getDouble("jml"),0,0,rs2.getString("nama_industri"),rs2.getString("kategori"),
rs2.getString("golongan"),"","",""
});
}else if(Jeniskelas.getSelectedItem().equals("Rawat Jalan")){
tabModeDetailObatRacikan.addRow(new Object[]{
rsobat.getString("no_racik"),rs2.getString("kode_brng"),rs2.getString("nama_brng"),
rs2.getString("kode_sat"),rs2.getDouble("ralan"),rs2.getDouble("dasar"),
rs2.getString("jenis"),sisacari,rs2.getDouble("kapasitas"),rs2.getString("kandungan"),
rs2.getDouble("jml"),0,0,rs2.getString("nama_industri"),rs2.getString("kategori"),
rs2.getString("golongan"),"","",""
});
}else if(Jeniskelas.getSelectedItem().equals("Beli Luar")){
tabModeDetailObatRacikan.addRow(new Object[]{
rsobat.getString("no_racik"),rs2.getString("kode_brng"),rs2.getString("nama_brng"),
rs2.getString("kode_sat"),rs2.getDouble("beliluar"),rs2.getDouble("dasar"),
rs2.getString("jenis"),sisacari,rs2.getDouble("kapasitas"),rs2.getString("kandungan"),
rs2.getDouble("jml"),0,0,rs2.getString("nama_industri"),rs2.getString("kategori"),
rs2.getString("golongan"),"","",""
});
}else if(Jeniskelas.getSelectedItem().equals("Utama/BPJS")){
tabModeDetailObatRacikan.addRow(new Object[]{
rsobat.getString("no_racik"),rs2.getString("kode_brng"),rs2.getString("nama_brng"),
rs2.getString("kode_sat"),rs2.getDouble("utama"),rs2.getDouble("dasar"),
rs2.getString("jenis"),sisacari,rs2.getDouble("kapasitas"),rs2.getString("kandungan"),
rs2.getDouble("jml"),0,0,rs2.getString("nama_industri"),rs2.getString("kategori"),
rs2.getString("golongan"),"","",""
});
}
}
}
} catch (Exception e) {
System.out.println("Notifikasi 3 : "+e);
} finally{
if(rs2!=null){
rs2.close();
}
if(ps2!=null){
ps2.close();
}
}
}
}
}while(rsobat.next());
}
} catch (Exception e) {
System.out.println("Notifikasi 2 : "+e);
} finally{
if(rsobat!=null){
rsobat.close();
}
if(psobat!=null){
psobat.close();
}
}
for(i=0;i0){
stokbarang=0;
if(aktifkanbatch.equals("yes")){
psstok=koneksi.prepareStatement("select ifnull(gudangbarang.stok,'0') from gudangbarang where gudangbarang.kd_bangsal=? and gudangbarang.kode_brng=? and gudangbarang.no_batch=? and gudangbarang.no_faktur=?");
try {
psstok.setString(1,kdgudang.getText());
psstok.setString(2,tbObat.getValueAt(row,2).toString());
psstok.setString(3,tbObat.getValueAt(row,16).toString());
psstok.setString(4,tbObat.getValueAt(row,17).toString());
rsstok=psstok.executeQuery();
if(rsstok.next()){
stokbarang=rsstok.getDouble(1);
}
} catch (Exception e) {
stokbarang=0;
System.out.println("Notifikasi : "+e);
}finally{
if(rsstok != null){
rsstok.close();
}
if(psstok != null){
psstok.close();
}
}
}else{
psstok=koneksi.prepareStatement("select ifnull(gudangbarang.stok,'0') from gudangbarang where gudangbarang.kd_bangsal=? and gudangbarang.kode_brng=? and gudangbarang.no_batch='' and gudangbarang.no_faktur=''");
try {
psstok.setString(1,kdgudang.getText());
psstok.setString(2,tbObat.getValueAt(row,2).toString());
rsstok=psstok.executeQuery();
if(rsstok.next()){
stokbarang=rsstok.getDouble(1);
}
} catch (Exception e) {
stokbarang=0;
System.out.println("Notifikasi : "+e);
}finally{
if(rsstok != null){
rsstok.close();
}
if(psstok != null){
psstok.close();
}
}
}
tbObat.setValueAt(stokbarang,row,10);
y=0;
try {
if(tbObat.getValueAt(row,0).toString().equals("true")){
pscarikapasitas= koneksi.prepareStatement("select IFNULL(databarang.kapasitas,1) from databarang where databarang.kode_brng=?");
try {
pscarikapasitas.setString(1,tbObat.getValueAt(row,2).toString());
carikapasitas=pscarikapasitas.executeQuery();
if(carikapasitas.next()){
y=Double.parseDouble(tbObat.getValueAt(row,1).toString())/carikapasitas.getDouble(1);
}else{
y=Double.parseDouble(tbObat.getValueAt(row,1).toString());
}
} catch (Exception e) {
y=Double.parseDouble(tbObat.getValueAt(row,1).toString());
System.out.println("Kapasitasmu masih kosong broooh : "+e);
} finally{
if(carikapasitas!=null){
carikapasitas.close();
}
if(pscarikapasitas!=null){
pscarikapasitas.close();
}
}
}else{
y=Double.parseDouble(tbObat.getValueAt(row,1).toString());
}
} catch (Exception e) {
y=0;
}
if(stokbarang0){
z++;
}
}
jumlah=new double[z];
harga=new double[z];
eb=new double[z];
ts=new double[z];
stok=new double[z];
kodebarang=new String[z];
namabarang=new String[z];
kodesatuan=new String[z];
no=new String[z];
namajenis=new String[z];
industri=new String[z];
beli=new double[z];
kategori=new String[z];
golongan=new String[z];
kapasitas=new double[z];
kandungan=new double[z];
nobatch=new String[z];
nofaktur=new String[z];
kadaluarsa=new String[z];
z=0;
for(i=0;i0){
no[z]=tbDetailObatRacikan.getValueAt(i,0).toString();
kodebarang[z]=tbDetailObatRacikan.getValueAt(i,1).toString();
namabarang[z]=tbDetailObatRacikan.getValueAt(i,2).toString();
kodesatuan[z]=tbDetailObatRacikan.getValueAt(i,3).toString();
try {
harga[z]=Double.parseDouble(tbDetailObatRacikan.getValueAt(i,4).toString());
} catch (Exception e) {
harga[z]=0;
}
try {
beli[z]=Double.parseDouble(tbDetailObatRacikan.getValueAt(i,5).toString());
} catch (Exception e) {
beli[z]=0;
}
namajenis[z]=tbDetailObatRacikan.getValueAt(i,6).toString();
try {
stok[z]=Double.parseDouble(tbDetailObatRacikan.getValueAt(i,7).toString());
} catch (Exception e) {
stok[z]=0;
}
try {
kapasitas[z]=Double.parseDouble(tbDetailObatRacikan.getValueAt(i,8).toString());
} catch (Exception e) {
kapasitas[z]=0;
}
try {
kandungan[z]=Double.parseDouble(tbDetailObatRacikan.getValueAt(i,9).toString());
} catch (Exception e) {
kandungan[z]=0;
}
try {
jumlah[z]=Double.parseDouble(tbDetailObatRacikan.getValueAt(i,10).toString());
} catch (Exception e) {
jumlah[z]=0;
}
try {
eb[z]=Double.parseDouble(tbDetailObatRacikan.getValueAt(i,11).toString());
} catch (Exception e) {
eb[z]=0;
}
try {
ts[z]=Double.parseDouble(tbDetailObatRacikan.getValueAt(i,12).toString());
} catch (Exception e) {
ts[z]=0;
}
industri[z]=tbDetailObatRacikan.getValueAt(i,13).toString();
kategori[z]=tbDetailObatRacikan.getValueAt(i,14).toString();
golongan[z]=tbDetailObatRacikan.getValueAt(i,15).toString();
nobatch[z]=tbDetailObatRacikan.getValueAt(i,16).toString();
nofaktur[z]=tbDetailObatRacikan.getValueAt(i,17).toString();
try {
kadaluarsa[z]=tbObat.getValueAt(i,18).toString();
} catch (Exception e) {
kadaluarsa[z]="0000-00-00";
}
z++;
}
}
Valid.tabelKosong(tabModeDetailObatRacikan);
for(i=0;i0){
stokbarang=0;
if(aktifkanbatch.equals("yes")){
psstok=koneksi.prepareStatement("select ifnull(gudangbarang.stok,'0') from gudangbarang where gudangbarang.kd_bangsal=? and gudangbarang.kode_brng=? and gudangbarang.no_batch=? and gudangbarang.no_faktur=?");
try {
psstok.setString(1,kdgudang.getText());
psstok.setString(2,tbDetailObatRacikan.getValueAt(row,1).toString());
psstok.setString(3,tbDetailObatRacikan.getValueAt(row,16).toString());
psstok.setString(4,tbDetailObatRacikan.getValueAt(row,17).toString());
rsstok=psstok.executeQuery();
if(rsstok.next()){
stokbarang=rsstok.getDouble(1);
}
} catch (Exception e) {
stokbarang=0;
System.out.println("Notifikasi : "+e);
}finally{
if(rsstok != null){
rsstok.close();
}
if(psstok != null){
psstok.close();
}
}
}else{
psstok=koneksi.prepareStatement("select ifnull(gudangbarang.stok,'0') from gudangbarang where gudangbarang.kd_bangsal=? and gudangbarang.kode_brng=? and gudangbarang.no_batch='' and gudangbarang.no_faktur=''");
try {
psstok.setString(1,kdgudang.getText());
psstok.setString(2,tbDetailObatRacikan.getValueAt(row,1).toString());
rsstok=psstok.executeQuery();
if(rsstok.next()){
stokbarang=rsstok.getDouble(1);
}
} catch (Exception e) {
stokbarang=0;
System.out.println("Notifikasi : "+e);
}finally{
if(rsstok != null){
rsstok.close();
}
if(psstok != null){
psstok.close();
}
}
}
tbDetailObatRacikan.setValueAt(stokbarang,row,7);
y=0;
try {
y=Double.parseDouble(tbDetailObatRacikan.getValueAt(row,10).toString());
} catch (Exception e) {
y=0;
}
if(stokbarang0){
try {
y=Math.round(Double.parseDouble(tabModeobat.getValueAt(r,1).toString())*
Double.parseDouble(tabModeobat.getValueAt(r,6).toString())+
Double.parseDouble(tabModeobat.getValueAt(r,8).toString())+
Double.parseDouble(tabModeobat.getValueAt(r,9).toString()));
} catch (Exception e) {
y=0;
}
ttl=ttl+y;
}
} catch (Exception e) {
}
}
row2=tabModeDetailObatRacikan.getRowCount();
for(r=0;r0){
try {
y=Math.round(Double.parseDouble(tabModeDetailObatRacikan.getValueAt(r,10).toString())*
Double.parseDouble(tabModeDetailObatRacikan.getValueAt(r,4).toString())+
Double.parseDouble(tabModeDetailObatRacikan.getValueAt(r,11).toString())+
Double.parseDouble(tabModeDetailObatRacikan.getValueAt(r,12).toString()));
} catch (Exception e) {
y=0;
}
ttl=ttl+y;
}
} catch (Exception e) {
}
}
LTotal.setText(Valid.SetAngka(ttl));
ppnobat=0;
if(tampilkan_ppnobat_ralan.equals("Yes")){
ppnobat=Math.round(ttl*0.11);
ttl=ttl+ppnobat;
LPpn.setText(Valid.SetAngka(ppnobat));
LTotalTagihan.setText(Valid.SetAngka(ttl));
}
}
private void cariBatch() {
if(TabRawat.getSelectedIndex()==0){
try {
if(!tbObat.getValueAt(tbObat.getSelectedRow(),16).toString().equals("")){
ps2=koneksi.prepareStatement("select * from data_batch where data_batch.no_batch=? and data_batch.kode_brng=? and data_batch.sisa>0 order by data_batch.tgl_kadaluarsa limit 1");
try {
ps2.setString(1,tbObat.getValueAt(tbObat.getSelectedRow(),16).toString());
ps2.setString(2,tbObat.getValueAt(tbObat.getSelectedRow(),2).toString());
rs2=ps2.executeQuery();
if(rs2.next()){
tbObat.setValueAt(rs2.getString("no_faktur"), tbObat.getSelectedRow(),17);
tbObat.setValueAt(rs2.getString("tgl_kadaluarsa"), tbObat.getSelectedRow(),18);
tbObat.setValueAt(rs2.getDouble(hppfarmasi), tbObat.getSelectedRow(),13);
if(aktifkanbatch.equals("yes")){
if(Jeniskelas.getSelectedItem().equals("Karyawan")){
tbObat.setValueAt(rs2.getDouble("karyawan"), tbObat.getSelectedRow(),6);
}else if(Jeniskelas.getSelectedItem().equals("Beli Luar")){
tbObat.setValueAt(rs2.getDouble("beliluar"), tbObat.getSelectedRow(),6);
}else if(Jeniskelas.getSelectedItem().equals("Rawat Jalan")){
tbObat.setValueAt(rs2.getDouble("ralan"), tbObat.getSelectedRow(),6);
}else if(Jeniskelas.getSelectedItem().equals("Utama/BPJS")){
tbObat.setValueAt(rs2.getDouble("utama"), tbObat.getSelectedRow(),6);
}
}
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs2!=null){
rs2.close();
}
if(ps2!=null){
ps2.close();
}
}
}
} catch (Exception e) {
System.out.println("Notif : "+e);
}
try {
stokbarang=0;
if(aktifkanbatch.equals("yes")){
psstok=koneksi.prepareStatement("select ifnull(gudangbarang.stok,'0') from gudangbarang where gudangbarang.kd_bangsal=? and gudangbarang.kode_brng=? and gudangbarang.no_batch=? and gudangbarang.no_faktur=?");
try {
psstok.setString(1,kdgudang.getText());
psstok.setString(2,tbObat.getValueAt(tbObat.getSelectedRow(),2).toString());
psstok.setString(3,tbObat.getValueAt(tbObat.getSelectedRow(),16).toString());
psstok.setString(4,tbObat.getValueAt(tbObat.getSelectedRow(),17).toString());
rsstok=psstok.executeQuery();
if(rsstok.next()){
stokbarang=rsstok.getDouble(1);
}
} catch (Exception e) {
stokbarang=0;
System.out.println("Notifikasi : "+e);
}finally{
if(rsstok != null){
rsstok.close();
}
if(psstok != null){
psstok.close();
}
}
}else{
psstok=koneksi.prepareStatement("select ifnull(gudangbarang.stok,'0') from gudangbarang where gudangbarang.kd_bangsal=? and gudangbarang.kode_brng=? and gudangbarang.no_batch='' and gudangbarang.no_faktur=''");
try {
psstok.setString(1,kdgudang.getText());
psstok.setString(2,tbObat.getValueAt(tbObat.getSelectedRow(),2).toString());
rsstok=psstok.executeQuery();
if(rsstok.next()){
stokbarang=rsstok.getDouble(1);
}
} catch (Exception e) {
stokbarang=0;
System.out.println("Notifikasi : "+e);
}finally{
if(rsstok != null){
rsstok.close();
}
if(psstok != null){
psstok.close();
}
}
}
tbObat.setValueAt(stokbarang,tbObat.getSelectedRow(),10);
y=0;
try {
y=Double.parseDouble(tbObat.getValueAt(tbObat.getSelectedRow(),1).toString());
} catch (Exception e) {
y=0;
}
if(stokbarang0 order by data_batch.tgl_kadaluarsa limit 1");
try {
ps2.setString(1,tbDetailObatRacikan.getValueAt(tbDetailObatRacikan.getSelectedRow(),16).toString());
ps2.setString(2,tbDetailObatRacikan.getValueAt(tbDetailObatRacikan.getSelectedRow(),1).toString());
rs2=ps2.executeQuery();
if(rs2.next()){
tbDetailObatRacikan.setValueAt(rs2.getString("no_faktur"), tbDetailObatRacikan.getSelectedRow(),17);
tbDetailObatRacikan.setValueAt(rs2.getString("tgl_kadaluarsa"), tbDetailObatRacikan.getSelectedRow(),18);
tbDetailObatRacikan.setValueAt(rs2.getDouble(hppfarmasi), tbDetailObatRacikan.getSelectedRow(),5);
if(aktifkanbatch.equals("yes")){
if(Jeniskelas.getSelectedItem().equals("Karyawan")){
tbDetailObatRacikan.setValueAt(rs2.getDouble("karyawan"), tbDetailObatRacikan.getSelectedRow(),4);
}else if(Jeniskelas.getSelectedItem().equals("Beli Luar")){
tbDetailObatRacikan.setValueAt(rs2.getDouble("beliluar"), tbDetailObatRacikan.getSelectedRow(),4);
}else if(Jeniskelas.getSelectedItem().equals("Rawat Jalan")){
tbDetailObatRacikan.setValueAt(rs2.getDouble("ralan"), tbDetailObatRacikan.getSelectedRow(),4);
}else if(Jeniskelas.getSelectedItem().equals("Utama/BPJS")){
tbDetailObatRacikan.setValueAt(rs2.getDouble("utama"), tbDetailObatRacikan.getSelectedRow(),4);
}
}
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs2!=null){
rs2.close();
}
if(ps2!=null){
ps2.close();
}
}
}
try {
stokbarang=0;
if(aktifkanbatch.equals("yes")){
psstok=koneksi.prepareStatement("select ifnull(gudangbarang.stok,'0') from gudangbarang where gudangbarang.kd_bangsal=? and gudangbarang.kode_brng=? and gudangbarang.no_batch=? and gudangbarang.no_faktur=?");
try {
psstok.setString(1,kdgudang.getText());
psstok.setString(2,tbDetailObatRacikan.getValueAt(tbDetailObatRacikan.getSelectedRow(),1).toString());
psstok.setString(3,tbDetailObatRacikan.getValueAt(tbDetailObatRacikan.getSelectedRow(),16).toString());
psstok.setString(4,tbDetailObatRacikan.getValueAt(tbDetailObatRacikan.getSelectedRow(),17).toString());
rsstok=psstok.executeQuery();
if(rsstok.next()){
stokbarang=rsstok.getDouble(1);
}
} catch (Exception e) {
stokbarang=0;
System.out.println("Notifikasi : "+e);
}finally{
if(rsstok != null){
rsstok.close();
}
if(psstok != null){
psstok.close();
}
}
}else{
psstok=koneksi.prepareStatement("select ifnull(gudangbarang.stok,'0') from gudangbarang where gudangbarang.kd_bangsal=? and gudangbarang.kode_brng=? and gudangbarang.no_batch='' and gudangbarang.no_faktur=''");
try {
psstok.setString(1,kdgudang.getText());
psstok.setString(2,tbDetailObatRacikan.getValueAt(tbDetailObatRacikan.getSelectedRow(),1).toString());
rsstok=psstok.executeQuery();
if(rsstok.next()){
stokbarang=rsstok.getDouble(1);
}
} catch (Exception e) {
stokbarang=0;
System.out.println("Notifikasi : "+e);
}finally{
if(rsstok != null){
rsstok.close();
}
if(psstok != null){
psstok.close();
}
}
}
tbDetailObatRacikan.setValueAt(stokbarang,tbDetailObatRacikan.getSelectedRow(),7);
y=0;
try {
y=Double.parseDouble(tbDetailObatRacikan.getValueAt(tbDetailObatRacikan.getSelectedRow(),10).toString());
} catch (Exception e) {
y=0;
}
if(stokbarang