213 src/keuangan/DlgBilingParsialRalan.java
View file

Large diffs are not rendered by default.

2 src/keuangan/DlgBilingRalan.form
View file
@@ -1605,7 +1605,7 @@
<Properties>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="03-03-2018 07:55:32"/>
<StringItem index="0" value="29-03-2018 07:22:31"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy HH:mm:ss"/>
35 src/keuangan/DlgBilingRalan.java
View file
@@ -152,7 +152,7 @@ public class DlgBilingRalan extends javax.swing.JDialog {
"on detreturjual.kode_brng=databarang.kode_brng "+
"and returjual.no_retur_jual=detreturjual.no_retur_jual where returjual.no_retur_jual=? group by databarang.nama_brng",
sqlpstambahan="select nama_biaya, besar_biaya from tambahan_biaya where no_rawat=? ",
sqlpsbiling="insert into billing values('0',?,?,?,?,?,?,?,?,?,?)",
sqlpsbiling="insert into billing values(?,?,?,?,?,?,?,?,?,?,?)",
sqlpstemporary="insert into temporary_bayar_ralan values('0',?,?,?,?,?,?,?,?,?,'','','','','','','','')",
sqlpspotongan="select nama_pengurangan,besar_pengurangan from pengurangan_biaya where no_rawat=?",
sqlpsbilling="select no,nm_perawatan, if(biaya<>0,biaya,null) as satu, if(jumlah<>0,jumlah,null) as dua,"+
@@ -2752,8 +2752,8 @@ private void MnHapusTagihanActionPerformed(java.awt.event.ActionEvent evt) {//GE
}

if(rsceknota.getDouble("Obat_Rawat_Jalan")>0){
Sequel.menyimpan("tampjurnal","'"+Persediaan_Obat_Rawat_Jalan+"','Operasi Ralan','"+rsceknota.getDouble("Obat_Rawat_Jalan")+"','0'","debet=debet+'"+(rsceknota.getDouble("Obat_Rawat_Jalan"))+"'","kd_rek='"+Persediaan_Obat_Rawat_Jalan+"'");
Sequel.menyimpan("tampjurnal","'"+HPP_Obat_Rawat_Jalan+"','Operasi Ralan','0','"+rsceknota.getDouble("Obat_Rawat_Jalan")+"'","kredit=kredit+'"+(rsceknota.getDouble("Obat_Rawat_Jalan"))+"'","kd_rek='"+HPP_Obat_Rawat_Jalan+"'");
Sequel.menyimpan("tampjurnal","'"+Persediaan_Obat_Rawat_Jalan+"','Obat Ralan','"+rsceknota.getDouble("Obat_Rawat_Jalan")+"','0'","debet=debet+'"+(rsceknota.getDouble("Obat_Rawat_Jalan"))+"'","kd_rek='"+Persediaan_Obat_Rawat_Jalan+"'");
Sequel.menyimpan("tampjurnal","'"+HPP_Obat_Rawat_Jalan+"','Obat Ralan','0','"+rsceknota.getDouble("Obat_Rawat_Jalan")+"'","kredit=kredit+'"+(rsceknota.getDouble("Obat_Rawat_Jalan"))+"'","kd_rek='"+HPP_Obat_Rawat_Jalan+"'");
}

if(rsceknota.getDouble("Jasa_Medik_Dokter_Operasi_Ralan")>0){
@@ -5199,30 +5199,31 @@ private void isSimpan(){
for(i=0;i<tbBilling.getRowCount();i++){
psbiling=koneksi.prepareStatement(sqlpsbiling);
try {
psbiling.setString(1,TNoRw.getText());
psbiling.setString(2,Valid.SetTgl(DTPTgl.getSelectedItem()+""));
psbiling.setString(3,tbBilling.getValueAt(i,1).toString());
psbiling.setString(4,tbBilling.getValueAt(i,2).toString().replaceAll("'","`"));
psbiling.setString(5,tbBilling.getValueAt(i,3).toString());
psbiling.setInt(1,i);
psbiling.setString(2,TNoRw.getText());
psbiling.setString(3,Valid.SetTgl(DTPTgl.getSelectedItem()+""));
psbiling.setString(4,tbBilling.getValueAt(i,1).toString());
psbiling.setString(5,tbBilling.getValueAt(i,2).toString().replaceAll("'","`"));
psbiling.setString(6,tbBilling.getValueAt(i,3).toString());
try {
psbiling.setDouble(6,Valid.SetAngka(tbBilling.getValueAt(i,4).toString()));
psbiling.setDouble(7,Valid.SetAngka(tbBilling.getValueAt(i,4).toString()));
} catch (Exception e) {
psbiling.setDouble(6,0);
psbiling.setDouble(7,0);
}
try {
psbiling.setDouble(7,Valid.SetAngka(tbBilling.getValueAt(i,5).toString()));
psbiling.setDouble(8,Valid.SetAngka(tbBilling.getValueAt(i,5).toString()));
} catch (Exception e) {
psbiling.setDouble(7,0);
psbiling.setDouble(8,0);
}
subttl=0;
try {
if((!tbBilling.getValueAt(i,8).toString().equals("Laborat"))&&(!tbBilling.getValueAt(i,8).toString().equals("Obat"))){
subttl=Valid.SetAngka(tbBilling.getValueAt(i,6).toString());
}
psbiling.setDouble(8,Valid.SetAngka(tbBilling.getValueAt(i,6).toString()));
psbiling.setDouble(9,Valid.SetAngka(tbBilling.getValueAt(i,6).toString()));
} catch (Exception e) {
subttl=0;
psbiling.setDouble(8,0);
psbiling.setDouble(9,0);
}
if(subttl>0){
Sequel.queryu2("delete from tambahan_biaya where no_rawat=? and nama_biaya=?",2,new String[]{
@@ -5239,11 +5240,11 @@ private void isSimpan(){
"','"+tbBilling.getValueAt(i,6).toString()+"'","Potongan Biaya");
}
try {
psbiling.setDouble(9,Valid.SetAngka(tbBilling.getValueAt(i,7).toString()));
psbiling.setDouble(10,Valid.SetAngka(tbBilling.getValueAt(i,7).toString()));
} catch (Exception e) {
psbiling.setDouble(9,0);
psbiling.setDouble(10,0);
}
psbiling.setString(10,tbBilling.getValueAt(i,8).toString());
psbiling.setString(11,tbBilling.getValueAt(i,8).toString());
psbiling.executeUpdate();
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
2 src/keuangan/DlgBilingRanap.form
View file
@@ -1915,7 +1915,7 @@
<Properties>
<Property name="model" type="javax.swing.ComboBoxModel" editor="org.netbeans.modules.form.editors2.ComboBoxModelEditor">
<StringArray count="1">
<StringItem index="0" value="05-01-2018 10:09:34"/>
<StringItem index="0" value="29-03-2018 07:33:07"/>
</StringArray>
</Property>
<Property name="displayFormat" type="java.lang.String" value="dd-MM-yyyy HH:mm:ss"/>
31 src/keuangan/DlgBilingRanap.java
View file
@@ -196,7 +196,7 @@ public class DlgBilingRanap extends javax.swing.JDialog {
"on operasi.kode_paket=paket_operasi.kode_paket where "+
"operasi.no_rawat=? and operasi.status like ?",
sqlpsnota="insert into nota_inap values(?,?,?,?,?)",
sqlpsbiling="insert into billing values('0',?,?,?,?,?,?,?,?,?,?)",
sqlpsbiling="insert into billing values(?,?,?,?,?,?,?,?,?,?,?)",
sqlpssudahmasuk="select no,nm_perawatan, if(biaya<>0,biaya,null) as satu, if(jumlah<>0,jumlah,null) as dua,"+
"if(tambahan<>0,tambahan,null) as tiga, if(totalbiaya<>0,totalbiaya,null) as empat,pemisah,status "+
"from billing where no_rawat=? order by noindex",
@@ -5911,30 +5911,31 @@ private void isSimpan() {
for(i=0;i<tbBilling.getRowCount();i++){
psbiling=koneksi.prepareStatement(sqlpsbiling);
try {
psbiling.setString(1,TNoRw.getText());
psbiling.setString(2,Valid.SetTgl(DTPTgl.getSelectedItem()+""));
psbiling.setString(3,tbBilling.getValueAt(i,1).toString());
psbiling.setString(4,tbBilling.getValueAt(i,2).toString().replaceAll("'","`"));
psbiling.setString(5,tbBilling.getValueAt(i,3).toString());
psbiling.setInt(1,i);
psbiling.setString(2,TNoRw.getText());
psbiling.setString(3,Valid.SetTgl(DTPTgl.getSelectedItem()+""));
psbiling.setString(4,tbBilling.getValueAt(i,1).toString());
psbiling.setString(5,tbBilling.getValueAt(i,2).toString().replaceAll("'","`"));
psbiling.setString(6,tbBilling.getValueAt(i,3).toString());
try {
psbiling.setDouble(6,Valid.SetAngka(tbBilling.getValueAt(i,4).toString()));
psbiling.setDouble(7,Valid.SetAngka(tbBilling.getValueAt(i,4).toString()));
} catch (Exception e) {
psbiling.setDouble(6,0);
psbiling.setDouble(7,0);
}
try {
psbiling.setDouble(7,Valid.SetAngka(tbBilling.getValueAt(i,5).toString()));
psbiling.setDouble(8,Valid.SetAngka(tbBilling.getValueAt(i,5).toString()));
} catch (Exception e) {
psbiling.setDouble(7,0);
psbiling.setDouble(8,0);
}
subttl=0;
try {
if((!tbBilling.getValueAt(i,8).toString().equals("Laborat"))&&(!tbBilling.getValueAt(i,8).toString().equals("Obat"))&&(!tbBilling.getValueAt(i,8).toString().equals("Operasi"))){
subttl=Valid.SetAngka(tbBilling.getValueAt(i,6).toString());
}
psbiling.setDouble(8,Valid.SetAngka(tbBilling.getValueAt(i,6).toString()));
psbiling.setDouble(9,Valid.SetAngka(tbBilling.getValueAt(i,6).toString()));
} catch (Exception e) {
subttl=0;
psbiling.setDouble(8,0);
psbiling.setDouble(9,0);
}
if(subttl>0){
Sequel.queryu2("delete from tambahan_biaya where no_rawat=? and nama_biaya=?",2,new String[]{
@@ -5951,11 +5952,11 @@ private void isSimpan() {
"','"+tbBilling.getValueAt(i,6).toString()+"'","Potongan Biaya");
}
try {
psbiling.setDouble(9,Valid.SetAngka(tbBilling.getValueAt(i,7).toString()));
psbiling.setDouble(10,Valid.SetAngka(tbBilling.getValueAt(i,7).toString()));
} catch (Exception e) {
psbiling.setDouble(9,0);
psbiling.setDouble(10,0);
}
psbiling.setString(10,tbBilling.getValueAt(i,8).toString());
psbiling.setString(11,tbBilling.getValueAt(i,8).toString());
psbiling.executeUpdate();
} catch (Exception e) {
System.out.println("Notifikasi : "+e);