0){
htmlContent.append(
"").append(
" | ").append(
"Total ").append(namapiutang[i]).append(" | ").append(
"").append(Valid.SetAngka(totalpiutang[i])).append(" | ").append(
"
"
);
}
}
if(piutangobat>0){
htmlContent.append(
"").append(
" | ").append(
"Total ").append(akunpiutangobat).append(" | ").append(
"").append(Valid.SetAngka(piutangobat)).append(" | ").append(
"
"
);
}
if(all>0){
htmlContent.append(
"").append(
" | ").append(
"Jumlah Total | ").append(
"").append(Valid.SetAngka(all+piutangobat)).append(" | ").append(
"
"
);
}
LoadHTML.setText(
""+
""+
"");
htmlContent=null;
}catch(Exception e){
System.out.println("Notifikasi : "+e);
}
this.setCursor(Cursor.getDefaultCursor());
}
private void tampil2(){
this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR));
try{
StringBuilder htmlContent = new StringBuilder();
htmlContent.append(
"").append(
"| No. | ").append(
"Tanggal | ").append(
"No.Rawat/No.Nota | ").append(
"Nama Pasien | ").append(
"Jenis/Cara Bayar | ").append(
"Akun Closing | ").append(
"
"
);
kolom=0;
psakunbayar=koneksi.prepareStatement("select akun_bayar.nama_bayar from akun_bayar order by akun_bayar.nama_bayar");
try {
rsakunbayar=psakunbayar.executeQuery();
rsakunbayar.last();
i=rsakunbayar.getRow();
namabayar=new String[i];
rsakunbayar.beforeFirst();
while(rsakunbayar.next()){
namabayar[kolom]=rsakunbayar.getString("nama_bayar");
kolom++;
}
} catch (Exception e) {
System.out.println("Akun Bayar : "+e);
} finally{
if(rsakunbayar!=null){
rsakunbayar.close();
}
if(psakunbayar!=null){
psakunbayar.close();
}
}
totalbayar=new double[kolom];
kolompiutang=0;
psakunpiutang=koneksi.prepareStatement("select akun_piutang.nama_bayar from akun_piutang order by akun_piutang.nama_bayar");
try {
rsakunpiutang=psakunpiutang.executeQuery();
rsakunpiutang.last();
i=rsakunpiutang.getRow();
namapiutang=new String[i];
rsakunpiutang.beforeFirst();
while(rsakunpiutang.next()){
namapiutang[kolompiutang]=rsakunpiutang.getString("nama_bayar");
kolompiutang++;
}
} catch (Exception e) {
System.out.println("Akun Piutang : "+e);
} finally{
if(rsakunpiutang!=null){
rsakunpiutang.close();
}
if(psakunpiutang!=null){
psakunpiutang.close();
}
}
totalpiutang=new double[kolompiutang];
kolom2=0;
psakunbayar=koneksi.prepareStatement("select rekening.kd_rek,rekening.nm_rek from rekening where rekening.kd_rek in (select kategori_pemasukan_lain.kd_rek2 from kategori_pemasukan_lain group by kategori_pemasukan_lain.kd_rek2) order by rekening.nm_rek");
try {
rsakunbayar=psakunbayar.executeQuery();
rsakunbayar.last();
i=rsakunbayar.getRow();
akunrekening=new String[i];
namarekening=new String[i];
rsakunbayar.beforeFirst();
while(rsakunbayar.next()){
akunrekening[kolom2]=rsakunbayar.getString("kd_rek");
namarekening[kolom2]=rsakunbayar.getString("nm_rek");
kolom2++;
}
} catch (Exception e) {
System.out.println("Akun Bayar : "+e);
} finally{
if(rsakunbayar!=null){
rsakunbayar.close();
}
if(psakunbayar!=null){
psakunbayar.close();
}
}
totalbayar2=new double[kolom2];
all=0;
ps=koneksi.prepareStatement(
"select tagihan_sadewa.no_nota,date_format(tagihan_sadewa.tgl_bayar,'%Y-%m-%d') as tgl_bayar,tagihan_sadewa.nama_pasien "+
"from tagihan_sadewa where tagihan_sadewa.tgl_bayar between ? and ? order by tagihan_sadewa.tgl_bayar,tagihan_sadewa.no_nota");
try {
ps.setString(1,Valid.SetTgl(Tgl1.getSelectedItem()+"")+" 00:00:00");
ps.setString(2,Valid.SetTgl(Tgl2.getSelectedItem()+"")+" 23:59:59");
rs=ps.executeQuery();
no=1;
while(rs.next()){
norawatinap="";
norawatjalan="";
notajual="";
carabayar="";
nodeposit="";
nonota=Sequel.cariIsi("select nota_inap.no_nota from nota_inap where nota_inap.no_rawat=?",rs.getString("no_nota"));
if(!nonota.equals("")){
norawatinap=rs.getString("no_nota");
carabayar=Sequel.cariIsi("select penjab.png_jawab from penjab inner join reg_periksa on penjab.kd_pj=reg_periksa.kd_pj where reg_periksa.no_rawat=?",rs.getString("no_nota"));
}else if(nonota.equals("")){
nonota=Sequel.cariIsi("select nota_jalan.no_nota from nota_jalan where nota_jalan.no_rawat=?",rs.getString("no_nota"));
if(!nonota.equals("")){
norawatjalan=rs.getString("no_nota");
carabayar=Sequel.cariIsi("select penjab.png_jawab from penjab inner join reg_periksa on penjab.kd_pj=reg_periksa.kd_pj where reg_periksa.no_rawat=?",rs.getString("no_nota"));
}else if(nonota.equals("")){
nonota=Sequel.cariIsi("select penjualan.nota_jual from penjualan where penjualan.nota_jual=?",rs.getString("no_nota"));
if(!nonota.equals("")){
notajual=rs.getString("no_nota");
carabayar="Penjualan Apotek";
}else if(nonota.equals("")){
nonota=Sequel.cariIsi("select deposit.no_deposit from deposit where deposit.no_deposit=?",rs.getString("no_nota"));
if(!nonota.equals("")){
nodeposit=rs.getString("no_nota");
carabayar="Deposit Pasien";
}else{
nodeposit="";
carabayar="Transaksi Tidak Ditemukan";
}
}
}
}
if((!carabayar.equals("Transaksi Tidak Ditemukan"))&&(rs.getString("nama_pasien").toLowerCase().trim().contains(TCari.getText().toLowerCase().trim())||nonota.toLowerCase().trim().contains(TCari.getText().toLowerCase().trim()))){
htmlContent.append(
"").append(
"| ").append(no).append(" | ").append(
"").append(rs.getString("tgl_bayar")).append(" | ").append(
"").append(nonota).append(" | ").append(
"").append(rs.getString("nama_pasien")).append(" | ").append(
"").append(carabayar).append(" | ").append(
"").append(
"").append(
" | ").append(
"
"
);
no++;
}
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
} finally{
if(rs!=null){
rs.close();
}
if(ps!=null){
ps.close();
}
}
//pemasukanlain2
ps= koneksi.prepareStatement(
"select tagihan_sadewa.no_nota,date_format(tagihan_sadewa.tgl_bayar,'%Y-%m-%d') as tgl_bayar,tagihan_sadewa.nama_pasien "+
"from tagihan_sadewa inner join pemasukan_lain on tagihan_sadewa.no_nota=pemasukan_lain.no_masuk "+
"where tagihan_sadewa.tgl_bayar between ? and ? order by tagihan_sadewa.tgl_bayar,tagihan_sadewa.no_nota");
try {
ps.setString(1,Valid.SetTgl(Tgl1.getSelectedItem()+"")+" 00:00:00");
ps.setString(2,Valid.SetTgl(Tgl2.getSelectedItem()+"")+" 23:59:59");
rs=ps.executeQuery();
while(rs.next()){
if((rs.getString("nama_pasien").toLowerCase().trim().contains(TCari.getText().toLowerCase().trim())||nonota.toLowerCase().trim().contains(TCari.getText().toLowerCase().trim()))){
htmlContent.append(
"").append(
"| ").append(no).append(" | ").append(
"").append(rs.getString("tgl_bayar")).append(" | ").append(
"").append(nonota).append(" | ").append(
"").append(rs.getString("nama_pasien")).append(" | ").append(
"Pemasukan Lain-lain | ").append(
"").append(
"").append(
" | ").append(
"
"
);
no++;
}
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
} finally{
if(rs!=null){
rs.close();
}
if(ps!=null){
ps.close();
}
}
ps=koneksi.prepareStatement(
"select piutang_pasien.no_rawat,piutang_pasien.tgl_piutang,pasien.nm_pasien from piutang_pasien inner join pasien on piutang_pasien.no_rkm_medis=pasien.no_rkm_medis "+
"where piutang_pasien.uangmuka='0' and piutang_pasien.tgl_piutang between ? and ? "+(!TCari.getText().trim().equals("")?" and (piutang_pasien.no_rawat like ? or pasien.nm_pasien like ?) ":"")+
"order by piutang_pasien.tgl_piutang,piutang_pasien.no_rawat");
try {
ps.setString(1,Valid.SetTgl(Tgl1.getSelectedItem()+""));
ps.setString(2,Valid.SetTgl(Tgl2.getSelectedItem()+""));
if(!TCari.getText().trim().equals("")){
ps.setString(3,"%"+TCari.getText().trim()+"%");
ps.setString(4,"%"+TCari.getText().trim()+"%");
}
rs=ps.executeQuery();
while(rs.next()){
htmlContent.append(
"").append(
"| ").append(no).append(" | ").append(
"").append(rs.getString("tgl_piutang")).append(" | ").append(
"").append(rs.getString("no_rawat")).append(" | ").append(
"").append(rs.getString("nm_pasien")).append(" | ").append(
"Piutang Perawatan | ").append(
"").append(
"").append(
" | ").append(
"
"
);
no++;
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
} finally{
if(rs!=null){
rs.close();
}
if(ps!=null){
ps.close();
}
}
ps=koneksi.prepareStatement(
"select piutang.nota_piutang,piutang.tgl_piutang,piutang.nm_pasien,piutang.sisapiutang from piutang "+
"where piutang.tgl_piutang between ? and ? "+(!TCari.getText().trim().equals("")?" and (piutang.nota_piutang like ? or pasien.nm_pasien like ?) ":"")+
"order by piutang.tgl_piutang,piutang.nota_piutang");
try {
ps.setString(1,Valid.SetTgl(Tgl1.getSelectedItem()+""));
ps.setString(2,Valid.SetTgl(Tgl2.getSelectedItem()+""));
if(!TCari.getText().trim().equals("")){
ps.setString(3,"%"+TCari.getText().trim()+"%");
ps.setString(4,"%"+TCari.getText().trim()+"%");
}
rs=ps.executeQuery();
piutangobat=0;
while(rs.next()){
piutangobat=piutangobat+rs.getDouble("sisapiutang");
htmlContent.append(
"").append(
"| ").append(no).append(" | ").append(
"").append(rs.getString("tgl_piutang")).append(" | ").append(
"").append(rs.getString("nota_piutang")).append(" | ").append(
"").append(rs.getString("nm_pasien")).append(" | ").append(
"Piutang Obat | ").append(
"").append(
"").append(
" | ").append(
"
"
);
no++;
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
} finally{
if(rs!=null){
rs.close();
}
if(ps!=null){
ps.close();
}
}
for(i=0;i0){
htmlContent.append(
"").append(
" | ").append(
"Total ").append(namabayar[i]).append(" | ").append(
"").append(Math.round(totalbayar[i])).append(" | ").append(
"
"
);
}
}
for(i=0;i0){
htmlContent.append(
"").append(
" | ").append(
"Total ").append(namarekening[i]).append(" | ").append(
"").append(Math.round(totalbayar2[i])).append(" | ").append(
"
"
);
}
}
for(i=0;i0){
htmlContent.append(
"").append(
" | ").append(
"Total ").append(namapiutang[i]).append(" | ").append(
"").append(Math.round(totalpiutang[i])).append(" | ").append(
"
"
);
}
}
if(piutangobat>0){
htmlContent.append(
"").append(
" | ").append(
"Total ").append(akunpiutangobat).append(" | ").append(
"").append(Math.round(piutangobat)).append(" | ").append(
"
"
);
}
if(all>0){
htmlContent.append(
"").append(
" | ").append(
"Jumlah Total | ").append(
"").append(Math.round(all+piutangobat)).append(" | ").append(
"
"
);
}
LoadHTML.setText(
""+
""+
"");
htmlContent=null;
}catch(Exception e){
System.out.println("Notifikasi : "+e);
}
this.setCursor(Cursor.getDefaultCursor());
}
}