param = new HashMap<>();
param.put("namars",akses.getnamars());
param.put("alamatrs",akses.getalamatrs());
param.put("kotars",akses.getkabupatenrs());
param.put("propinsirs",akses.getpropinsirs());
param.put("kontakrs",akses.getkontakrs());
param.put("emailrs",akses.getemailrs());
param.put("logo",Sequel.cariGambar("select setting.logo from setting"));
Valid.MyReportqry("rptDataTelaahResep.jasper","report","::[ Data Telaah Resep ]::",
"select telaah_farmasi.no_resep,resep_obat.tgl_perawatan,resep_obat.jam,resep_obat.no_rawat,reg_periksa.no_rkm_medis,"+
"pasien.nm_pasien,concat(reg_periksa.umurdaftar,' ',reg_periksa.sttsumur)as umur,pasien.jk,pasien.tgl_lahir,resep_obat.kd_dokter,dokter.nm_dokter,resep_obat.status,"+
"telaah_farmasi.resep_identifikasi_pasien,telaah_farmasi.resep_ket_identifikasi_pasien,telaah_farmasi.resep_tepat_obat,"+
"telaah_farmasi.resep_ket_tepat_obat,telaah_farmasi.resep_tepat_dosis,telaah_farmasi.resep_ket_tepat_dosis,"+
"telaah_farmasi.resep_tepat_cara_pemberian,telaah_farmasi.resep_ket_tepat_cara_pemberian,telaah_farmasi.resep_tepat_waktu_pemberian,"+
"telaah_farmasi.resep_ket_tepat_waktu_pemberian,telaah_farmasi.resep_ada_tidak_duplikasi_obat,telaah_farmasi.resep_ket_ada_tidak_duplikasi_obat,"+
"telaah_farmasi.resep_interaksi_obat,telaah_farmasi.resep_ket_interaksi_obat,telaah_farmasi.resep_kontra_indikasi_obat,"+
"telaah_farmasi.resep_ket_kontra_indikasi_obat,telaah_farmasi.obat_tepat_pasien,telaah_farmasi.obat_tepat_obat,"+
"telaah_farmasi.obat_tepat_dosis,telaah_farmasi.obat_tepat_cara_pemberian,telaah_farmasi.obat_tepat_waktu_pemberian,"+
"telaah_farmasi.nip,petugas.nama "+
"from telaah_farmasi inner join resep_obat on telaah_farmasi.no_resep=resep_obat.no_resep "+
"inner join reg_periksa on resep_obat.no_rawat=reg_periksa.no_rawat "+
"inner join pasien on pasien.no_rkm_medis=reg_periksa.no_rkm_medis "+
"inner join dokter on resep_obat.kd_dokter=dokter.kd_dokter "+
"inner join petugas on telaah_farmasi.nip=petugas.nip "+
"where resep_obat.tgl_perawatan between '"+Valid.SetTgl(DTPCari1.getSelectedItem()+"")+"' and '"+Valid.SetTgl(DTPCari2.getSelectedItem()+"")+"' "+
(TCari.getText().equals("")?"":"and (telaah_farmasi.no_resep like '%"+TCari.getText().trim()+"%' or resep_obat.no_rawat like '%"+TCari.getText().trim()+"%' or "+
"reg_periksa.no_rkm_medis like '%"+TCari.getText().trim()+"%' or pasien.nm_pasien like '%"+TCari.getText().trim()+"%' or resep_obat.kd_dokter like '%"+TCari.getText().trim()+"%' or "+
"dokter.nm_dokter like '%"+TCari.getText().trim()+"%' or resep_obat.status like '%"+TCari.getText().trim()+"%' or telaah_farmasi.nip like '%"+TCari.getText().trim()+"%' or "+
"petugas.nama like '%"+TCari.getText().trim()+"%') ")+"order by resep_obat.tgl_perawatan",param);
}
}else if(TabData.getSelectedIndex()==1){
try {
File g = new File("file2.css");
BufferedWriter bg = new BufferedWriter(new FileWriter(g));
bg.write(
".isi td{border-right: 1px solid #e2e7dd;font: 11px tahoma;height:12px;border-bottom: 1px solid #e2e7dd;background: #ffffff;color:#323232;}"+
".isi2 td{font: 11px tahoma;height:12px;background: #ffffff;color:#323232;}"+
".isi3 td{border-right: 1px solid #e2e7dd;font: 11px tahoma;height:12px;border-top: 1px solid #e2e7dd;background: #ffffff;color:#323232;}"+
".isi4 td{font: 11px tahoma;height:12px;border-top: 1px solid #e2e7dd;background: #ffffff;color:#323232;}"
);
bg.close();
File f = new File("VerifikasiResep.html");
BufferedWriter bw = new BufferedWriter(new FileWriter(f));
bw.write(LoadHTML.getText().replaceAll("",""+
"No.Resep "+
"Tgl.Resep "+
"Jam Resep "+
"No.Rawat "+
"No.RM "+
"Pasien "+
"Kode Dokter "+
"Dokter Peresep "+
"Status "+
" ");
ps=koneksi.prepareStatement("select resep_obat.no_resep,resep_obat.tgl_peresepan,resep_obat.jam_peresepan,"+
" resep_obat.no_rawat,pasien.no_rkm_medis,pasien.nm_pasien,resep_obat.kd_dokter,dokter.nm_dokter,"+
" resep_obat.status,resep_obat.tgl_perawatan,resep_obat.jam "+
" from resep_obat inner join reg_periksa inner join pasien inner join dokter on resep_obat.no_rawat=reg_periksa.no_rawat "+
" and reg_periksa.no_rkm_medis=pasien.no_rkm_medis and resep_obat.kd_dokter=dokter.kd_dokter where "+
" resep_obat.tgl_peresepan<>'0000-00-00' and resep_obat.tgl_perawatan<>'0000-00-00' and resep_obat.tgl_peresepan between ? and ? "+
(TCari.getText().trim().equals("")?"":"and (resep_obat.no_resep like ? or resep_obat.no_rawat like ? or "+
"pasien.no_rkm_medis like ? or pasien.nm_pasien like ? or resep_obat.kd_dokter like ? or dokter.nm_dokter like ? or "+
"resep_obat.status like ?) ")+"order by resep_obat.tgl_perawatan,resep_obat.jam desc");
try {
ps.setString(1,Valid.SetTgl(DTPCari1.getSelectedItem()+""));
ps.setString(2,Valid.SetTgl(DTPCari2.getSelectedItem()+""));
if(!TCari.getText().trim().equals("")){
ps.setString(3,"%"+TCari.getText().trim()+"%");
ps.setString(4,"%"+TCari.getText().trim()+"%");
ps.setString(5,"%"+TCari.getText().trim()+"%");
ps.setString(6,"%"+TCari.getText().trim()+"%");
ps.setString(7,"%"+TCari.getText().trim()+"%");
ps.setString(8,"%"+TCari.getText().trim()+"%");
ps.setString(9,"%"+TCari.getText().trim()+"%");
}
rs=ps.executeQuery();
while(rs.next()){
htmlContent.append(
""+
""+rs.getString("no_resep")+" "+
""+rs.getString("tgl_peresepan")+" "+
""+rs.getString("jam_peresepan")+" "+
""+rs.getString("no_rawat")+" "+
""+rs.getString("no_rkm_medis")+" "+
""+rs.getString("nm_pasien")+" "+
""+rs.getString("kd_dokter")+" "+
""+rs.getString("nm_dokter")+" "+
""+rs.getString("status").replace("r","R")+" "+
" "
);
htmlContent.append(
""+
""+
""+
" "+
" "
);
htmlContent.append(
""+
""+
""+
" "+
" "
);
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs!=null){
rs.close();
}
if(ps!=null){
ps.close();
}
}
LoadHTML.setText(
""+
""+
""
);
}catch(Exception e){
System.out.println("Notifikasi : "+e);
}
this.setCursor(Cursor.getDefaultCursor());
}
}