"+
" | "+
" Biaya & Perawatan | "+
": | "+
""+
""
);
//tindakan dokter ralan
try{
rs3=koneksi.prepareStatement(
"select rawat_jl_dr.kd_jenis_prw,jns_perawatan.nm_perawatan,dokter.nm_dokter,rawat_jl_dr.biaya_rawat "+
"from rawat_jl_dr inner join jns_perawatan inner join dokter "+
"on rawat_jl_dr.kd_jenis_prw=jns_perawatan.kd_jenis_prw "+
"and rawat_jl_dr.kd_dokter=dokter.kd_dokter where rawat_jl_dr.no_rawat='"+rs2.getString("no_rawat")+"'").executeQuery();
if(rs3.next()){
htmlContent.append(
"");
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
}
//tindakan paramedis ralan
try{
rs3=koneksi.prepareStatement(
"select rawat_jl_pr.kd_jenis_prw,jns_perawatan.nm_perawatan,petugas.nama,rawat_jl_pr.biaya_rawat "+
"from rawat_jl_pr inner join jns_perawatan inner join petugas "+
"on rawat_jl_pr.kd_jenis_prw=jns_perawatan.kd_jenis_prw "+
"and rawat_jl_pr.nip=petugas.nip where rawat_jl_pr.no_rawat='"+rs2.getString("no_rawat")+"'").executeQuery();
if(rs3.next()){
htmlContent.append(
"");
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
}
//tindakan ralan dokter dan paramedis
try{
rs3=koneksi.prepareStatement(
"select rawat_jl_drpr.kd_jenis_prw,jns_perawatan.nm_perawatan,dokter.nm_dokter,petugas.nama,rawat_jl_drpr.biaya_rawat "+
"from rawat_jl_drpr inner join jns_perawatan inner join dokter inner join petugas "+
"on rawat_jl_drpr.kd_jenis_prw=jns_perawatan.kd_jenis_prw and rawat_jl_drpr.nip=petugas.nip "+
"and rawat_jl_drpr.kd_dokter=dokter.kd_dokter where rawat_jl_drpr.no_rawat='"+rs2.getString("no_rawat")+"'").executeQuery();
if(rs3.next()){
htmlContent.append(
"");
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
}
//tindakan dokter ranap
try{
rs3=koneksi.prepareStatement(
"select rawat_inap_dr.tgl_perawatan,rawat_inap_dr.jam_rawat,rawat_inap_dr.kd_jenis_prw,jns_perawatan.nm_perawatan,dokter.nm_dokter,rawat_inap_dr.biaya_rawat "+
"from rawat_inap_dr inner join jns_perawatan inner join dokter "+
"on rawat_inap_dr.kd_jenis_prw=jns_perawatan.kd_jenis_prw "+
"and rawat_inap_dr.kd_dokter=dokter.kd_dokter where rawat_inap_dr.no_rawat='"+rs2.getString("no_rawat")+"'").executeQuery();
if(rs3.next()){
htmlContent.append(
"");
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
}
//tindakan paramedis ranap
try{
rs3=koneksi.prepareStatement(
"select rawat_inap_pr.tgl_perawatan,rawat_inap_pr.jam_rawat,rawat_inap_pr.kd_jenis_prw,jns_perawatan.nm_perawatan,petugas.nama,rawat_inap_pr.biaya_rawat "+
"from rawat_inap_pr inner join jns_perawatan inner join petugas "+
"on rawat_inap_pr.kd_jenis_prw=jns_perawatan.kd_jenis_prw "+
"and rawat_inap_pr.nip=petugas.nip where rawat_inap_pr.no_rawat='"+rs2.getString("no_rawat")+"'").executeQuery();
if(rs3.next()){
htmlContent.append(
"");
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
}
//tindakan paramedis dan dokter ranap
try{
rs3=koneksi.prepareStatement(
"select rawat_inap_drpr.tgl_perawatan,rawat_inap_drpr.jam_rawat,rawat_inap_drpr.kd_jenis_prw,jns_perawatan.nm_perawatan,dokter.nm_dokter,petugas.nama,rawat_inap_drpr.biaya_rawat "+
"from rawat_inap_drpr inner join jns_perawatan inner join dokter inner join petugas "+
"on rawat_inap_drpr.kd_jenis_prw=jns_perawatan.kd_jenis_prw and rawat_inap_drpr.nip=petugas.nip "+
"and rawat_inap_drpr.kd_dokter=dokter.kd_dokter where rawat_inap_drpr.no_rawat='"+rs2.getString("no_rawat")+"'").executeQuery();
if(rs3.next()){
htmlContent.append(
"");
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
}
//kamar inap
try{
rs3=koneksi.prepareStatement(
"select kamar_inap.kd_kamar,bangsal.nm_bangsal,kamar_inap.tgl_masuk, kamar_inap.tgl_keluar, "+
"kamar_inap.stts_pulang,kamar_inap.lama,kamar_inap.jam_masuk,kamar_inap.jam_keluar,"+
"kamar_inap.ttl_biaya from kamar_inap inner join bangsal inner join kamar "+
"on kamar_inap.kd_kamar=kamar.kd_kamar and kamar.kd_bangsal=bangsal.kd_bangsal "+
"where kamar_inap.no_rawat='"+rs2.getString("no_rawat")+"'").executeQuery();
if(rs3.next()){
htmlContent.append(
"");
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
}
//operasi
try{
rs3=koneksi.prepareStatement(
"select operasi.tgl_operasi,operasi.jenis_anasthesi,operasi.operator1, operasi.operator2, operasi.operator3, operasi.asisten_operator1,"+
"operasi.asisten_operator2, operasi.instrumen, operasi.dokter_anak, operasi.perawaat_resusitas, "+
"operasi.dokter_anestesi, operasi.asisten_anestesi, operasi.bidan, operasi.bidan2, operasi.bidan3, operasi.perawat_luar, operasi.omloop,operasi.omloop2,operasi.omloop3, "+
"operasi.kode_paket,paket_operasi.nm_perawatan, operasi.biayaoperator1, operasi.biayaoperator2, operasi.biayaoperator3, "+
"operasi.biayaasisten_operator1, operasi.biayaasisten_operator2, operasi.biayainstrumen, "+
"operasi.biayadokter_anak, operasi.biayaperawaat_resusitas, operasi.biayadokter_anestesi, "+
"operasi.biayaasisten_anestesi, operasi.biayabidan,operasi.biayabidan2,operasi.biayabidan3, operasi.biayaperawat_luar, operasi.biayaalat,"+
"operasi.biayasewaok,operasi.akomodasi,operasi.bagian_rs,operasi.biaya_omloop,operasi.biaya_omloop2,operasi.biaya_omloop3,sarpras,"+
"(operasi.biayaoperator1+operasi.biayaoperator2+operasi.biayaoperator3+"+
"operasi.biayaasisten_operator1+operasi.biayaasisten_operator2+operasi.biayainstrumen+"+
"operasi.biayadokter_anak+operasi.biayaperawaat_resusitas+operasi.biayadokter_anestesi+"+
"operasi.biayaasisten_anestesi+operasi.biayabidan+operasi.biayabidan2+operasi.biayabidan3+operasi.biayaperawat_luar+operasi.biayaalat+"+
"operasi.biayasewaok+operasi.akomodasi+operasi.bagian_rs+operasi.biaya_omloop+operasi.biaya_omloop2+operasi.biaya_omloop3+sarpras) as total from operasi inner join paket_operasi "+
"on operasi.kode_paket=paket_operasi.kode_paket where operasi.no_rawat='"+rs2.getString("no_rawat")+"'").executeQuery();
if(rs3.next()){
htmlContent.append(
"");
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
}
//tindakan pemeriksaan radiologi
try{
rs3=koneksi.prepareStatement(
"select periksa_radiologi.tgl_periksa,periksa_radiologi.jam,periksa_radiologi.kd_jenis_prw, "+
"jns_perawatan_radiologi.nm_perawatan,petugas.nama,periksa_radiologi.biaya,periksa_radiologi.dokter_perujuk,dokter.nm_dokter "+
"from periksa_radiologi inner join jns_perawatan_radiologi inner join petugas inner join dokter "+
"on periksa_radiologi.kd_jenis_prw=jns_perawatan_radiologi.kd_jenis_prw and periksa_radiologi.kd_dokter=dokter.kd_dokter "+
"and periksa_radiologi.nip=petugas.nip where periksa_radiologi.no_rawat='"+rs2.getString("no_rawat")+"'").executeQuery();
if(rs3.next()){
htmlContent.append(
"");
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
}
//tindakan pemeriksaan laborat
try{
rs3=koneksi.prepareStatement(
"select periksa_lab.tgl_periksa,periksa_lab.jam,periksa_lab.kd_jenis_prw, "+
"jns_perawatan_lab.nm_perawatan,petugas.nama,periksa_lab.biaya,periksa_lab.dokter_perujuk,dokter.nm_dokter "+
"from periksa_lab inner join jns_perawatan_lab inner join petugas inner join dokter "+
"on periksa_lab.kd_jenis_prw=jns_perawatan_lab.kd_jenis_prw and periksa_lab.kd_dokter=dokter.kd_dokter "+
"and periksa_lab.nip=petugas.nip where periksa_lab.no_rawat='"+rs2.getString("no_rawat")+"'").executeQuery();
if(rs3.next()){
htmlContent.append(
"");
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
}
//pemberian obat
try{
rs3=koneksi.prepareStatement(
"select detail_pemberian_obat.tgl_perawatan,detail_pemberian_obat.jam,databarang.kode_sat, "+
"detail_pemberian_obat.kode_brng,detail_pemberian_obat.jml,detail_pemberian_obat.total,"+
"databarang.nama_brng from detail_pemberian_obat inner join databarang "+
"on detail_pemberian_obat.kode_brng=databarang.kode_brng "+
"where detail_pemberian_obat.no_rawat='"+rs2.getString("no_rawat")+"'").executeQuery();
if(rs3.next()){
htmlContent.append(
"");
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
}
//pemberian obat Operasi
try{
rs3=koneksi.prepareStatement(
"select beri_obat_operasi.tanggal,beri_obat_operasi.kd_obat,beri_obat_operasi.hargasatuan,obatbhp_ok.kode_sat, "+
"beri_obat_operasi.jumlah, obatbhp_ok.nm_obat,(beri_obat_operasi.hargasatuan*beri_obat_operasi.jumlah) as total "+
"from beri_obat_operasi inner join obatbhp_ok on beri_obat_operasi.kd_obat=obatbhp_ok.kd_obat "+
"where beri_obat_operasi.no_rawat='"+rs2.getString("no_rawat")+"'").executeQuery();
if(rs3.next()){
htmlContent.append(
"");
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
}
//Resep Pulang
try{
rs3=koneksi.prepareStatement(
"select resep_pulang.kode_brng,databarang.nama_brng,resep_pulang.dosis,resep_pulang.jml_barang, "+
"databarang.kode_sat,resep_pulang.dosis,resep_pulang.total from resep_pulang inner join databarang "+
"on resep_pulang.kode_brng=databarang.kode_brng where "+
"resep_pulang.no_rawat='"+rs2.getString("no_rawat")+"' order by databarang.nama_brng").executeQuery();
if(rs3.next()){
htmlContent.append(
"");
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
}
//Retur Obat
try{
rs3=koneksi.prepareStatement(
"select databarang.kode_brng,databarang.nama_brng,detreturjual.kode_sat,detreturjual.h_retur, "+
"(detreturjual.jml_retur * -1) as jumlah,(detreturjual.subtotal * -1) as total from detreturjual "+
"inner join databarang inner join returjual on detreturjual.kode_brng=databarang.kode_brng "+
"and returjual.no_retur_jual=detreturjual.no_retur_jual where returjual.no_retur_jual='"+rs2.getString("no_rawat")+"' order by databarang.nama_brng").executeQuery();
if(rs3.next()){
htmlContent.append(
"");
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
}
//Tambahan Biaya
try{
rs3=koneksi.prepareStatement(
"select nama_biaya, besar_biaya from tambahan_biaya where no_rawat='"+rs2.getString("no_rawat")+"' order by nama_biaya").executeQuery();
if(rs3.next()){
htmlContent.append(
"");
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
}
//Pengurangan Biaya
try{
rs3=koneksi.prepareStatement(
"select nama_pengurangan, (-1*besar_pengurangan) as besar_pengurangan from pengurangan_biaya where no_rawat='"+rs2.getString("no_rawat")+"' order by nama_pengurangan").executeQuery();
if(rs3.next()){
htmlContent.append(
"");
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
}
htmlContent.append(
" | "+
"
"
);
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
} finally{
if(rs2!=null){
rs2.close();
}
}
y++;
htmlContent.append("