"+
"| "+tabMode.getValueAt(i,0)+" | "+
""+tabMode.getValueAt(i,1)+" | "+
""+tabMode.getValueAt(i,2)+" | "+
""+tabMode.getValueAt(i,3)+" | "+
""+tabMode.getValueAt(i,4)+" | "+
""+tabMode.getValueAt(i,5)+" | "+
""+tabMode.getValueAt(i,6)+" | "+
""+tabMode.getValueAt(i,7)+" | "+
""+Valid.SetAngka(Double.parseDouble(tabMode.getValueAt(i,8).toString()))+" | "+
""
);
}
f = new File("RingkasanBiayaObat.html");
bw = new BufferedWriter(new FileWriter(f));
bw.write(""+
""+
""+
""+
""+
""+
""
);
bw.close();
Desktop.getDesktop().browse(f.toURI());
break;
case "Laporan 2 (WPS)":
htmlContent = new StringBuilder();
htmlContent.append(
""+
"| No. | "+
"Tanggal | "+
"No.Rawat | "+
"No.RM | "+
"Nama Pasien | "+
"Alamat | "+
"Cara Bayar | "+
"Unit/Layanan | "+
"Total | "+
"
"
);
for(i=0;i"+
""+tabMode.getValueAt(i,0)+" | "+
""+tabMode.getValueAt(i,1)+" | "+
""+tabMode.getValueAt(i,2)+" | "+
""+tabMode.getValueAt(i,3)+" | "+
""+tabMode.getValueAt(i,4)+" | "+
""+tabMode.getValueAt(i,5)+" | "+
""+tabMode.getValueAt(i,6)+" | "+
""+tabMode.getValueAt(i,7)+" | "+
""+Valid.SetAngka(Double.parseDouble(tabMode.getValueAt(i,8).toString()))+" | "+
""
);
}
f = new File("RingkasanBiayaObat.wps");
bw = new BufferedWriter(new FileWriter(f));
bw.write(""+
""+
""+
""+
""+
""+
""
);
bw.close();
Desktop.getDesktop().browse(f.toURI());
break;
case "Laporan 3 (CSV)":
htmlContent = new StringBuilder();
//"No.","Tanggal","No.Rawat","No.RM","Nama Pasien","Alamat","Cara Bayar","Unit/Layanan","Total"
htmlContent.append(
"\"No.\";\"Tanggal\";\"No.Rawat\";\"No.RM\";\"Nama Pasien\";\"Alamat\";\"Cara Bayar\";\"Unit/Layanan\";\"Total\"\n"
);
for(i=0;i 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("rptRingkasanBiayaObatPasienPertanggal.jasper","report","[ Ringkasan Biaya Obat Pasien Per Tanggal ]","select * from temporary where temporary.temp37='"+akses.getalamatip()+"' order by temporary.no",param);
break;
}
} catch (Exception e) {
}
this.setCursor(Cursor.getDefaultCursor());
}
}//GEN-LAST:event_BtnPrintActionPerformed
private void BtnPrintKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnPrintKeyPressed
if(evt.getKeyCode()==KeyEvent.VK_SPACE){
BtnPrintActionPerformed(null);
}else{
//Valid.pindah(evt, BtnHapus, BtnAll);
}
}//GEN-LAST:event_BtnPrintKeyPressed
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(() -> {
InventoryRingkasanBiayaObatPasienPerTanggal dialog = new InventoryRingkasanBiayaObatPasienPerTanggal(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 BtnGolongan;
private widget.Button BtnJenis;
private widget.Button BtnKategori;
private widget.Button BtnKeluar;
private widget.Button BtnPrint;
private widget.Button BtnSeek3;
private widget.Button BtnSeek4;
private widget.CekBox ChkInput;
private widget.panelisi FormInput;
private widget.TextBox Kd2;
private javax.swing.JPanel PanelInput;
private widget.TextBox TCari;
private widget.Tanggal Tgl1;
private widget.Tanggal Tgl2;
private widget.InternalFrame internalFrame1;
private widget.Label jLabel7;
private widget.TextBox kdasal;
private widget.TextBox kdgolongan;
private widget.TextBox kdjenis;
private widget.TextBox kdkategori;
private widget.TextBox kdpenjab;
private widget.Label label11;
private widget.Label label17;
private widget.Label label18;
private widget.Label label19;
private widget.Label label20;
private widget.Label label21;
private widget.Label label22;
private widget.Label label23;
private widget.Label label9;
private widget.TextBox nmasal;
private widget.TextBox nmgolongan;
private widget.TextBox nmjns;
private widget.TextBox nmkategori;
private widget.TextBox nmpenjab;
private widget.panelisi panelisi1;
private widget.ScrollPane scrollPane4;
private widget.ComboBox status;
private widget.Table tbDokter;
// End of variables declaration//GEN-END:variables
private void prosesCari() {
try{
this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR));
Valid.tabelKosong(tabMode);
statusobat="";
if(status.getSelectedIndex()==1){
statusobat=" and detail_pemberian_obat.status='Ralan' ";
}else if(status.getSelectedIndex()==2){
statusobat=" and detail_pemberian_obat.status='Ranap' ";
}
carabayar="";
if(!kdpenjab.getText().trim().equals("")){
carabayar=" and reg_periksa.kd_pj='"+kdpenjab.getText()+"' ";
}
bangsal="";
if(!kdasal.getText().trim().equals("")){
bangsal=" and detail_pemberian_obat.kd_bangsal='"+kdasal.getText()+"' ";
}
jenisbarang="";
if(!kdjenis.getText().trim().equals("")){
jenisbarang=" and databarang.kdjns='"+kdjenis.getText()+"' ";
}
kategoribarang="";
if(!kdkategori.getText().trim().equals("")){
kategoribarang=" and databarang.kode_kategori='"+kdkategori.getText()+"' ";
}
golonganbarang="";
if(!kdgolongan.getText().trim().equals("")){
golonganbarang=" and databarang.kode_golongan='"+kdgolongan.getText()+"' ";
}
ps=koneksi.prepareStatement(
"select detail_pemberian_obat.tgl_perawatan,detail_pemberian_obat.no_rawat,reg_periksa.no_rkm_medis,pasien.nm_pasien,"+
"concat(pasien.alamat,', ',kelurahan.nm_kel,', ',kecamatan.nm_kec,', ',kabupaten.nm_kab,', ',propinsi.nm_prop) as alamat,"+
"penjab.png_jawab,sum(detail_pemberian_obat.total) as total,detail_pemberian_obat.status,poliklinik.nm_poli "+
"from detail_pemberian_obat inner join reg_periksa on detail_pemberian_obat.no_rawat=reg_periksa.no_rawat "+
"inner join pasien on reg_periksa.no_rkm_medis=pasien.no_rkm_medis inner join databarang on detail_pemberian_obat.kode_brng=databarang.kode_brng "+
"inner join kelurahan on pasien.kd_kel=kelurahan.kd_kel inner join kecamatan on pasien.kd_kec=kecamatan.kd_kec "+
"inner join kabupaten on pasien.kd_kab=kabupaten.kd_kab inner join propinsi on pasien.kd_prop=propinsi.kd_prop "+
"inner join penjab on reg_periksa.kd_pj=penjab.kd_pj inner join poliklinik on poliklinik.kd_poli=reg_periksa.kd_poli "+
"where detail_pemberian_obat.tgl_perawatan between ? and ? "+
statusobat+carabayar+bangsal+jenisbarang+kategoribarang+golonganbarang+(TCari.getText().trim().equals("")?"":
"and (detail_pemberian_obat.no_rawat like ? or reg_periksa.no_rkm_medis like ? or pasien.nm_pasien like ? or "+
"concat(pasien.alamat,', ',kelurahan.nm_kel,', ',kecamatan.nm_kec,', ',kabupaten.nm_kab,', ',propinsi.nm_prop) like ?) ")+
"group by detail_pemberian_obat.tgl_perawatan,detail_pemberian_obat.no_rawat order by detail_pemberian_obat.tgl_perawatan");
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()+"%");
ps.setString(5,"%"+TCari.getText().trim()+"%");
ps.setString(6,"%"+TCari.getText().trim()+"%");
}
rs=ps.executeQuery();
i=1;
total=0;
while(rs.next()){
total=total+rs.getDouble("total");
unit=rs.getString("nm_poli");
if(rs.getString("status").equals("Ranap")){
unit=Sequel.cariIsi("select concat(kamar_inap.kd_kamar,' ',bangsal.nm_bangsal) from kamar_inap inner join kamar on kamar_inap.kd_kamar=kamar.kd_kamar inner join bangsal on kamar.kd_bangsal=bangsal.kd_bangsal where kamar_inap.no_rawat=? order by kamar_inap.tgl_keluar desc limit 1 ",rs.getString("no_rawat"));
}
tabMode.addRow(new Object[]{
i+".",rs.getString("tgl_perawatan"),rs.getString("no_rawat"),rs.getString("no_rkm_medis"),rs.getString("nm_pasien"),
rs.getString("alamat"),rs.getString("png_jawab"),unit,rs.getDouble("total")
});
i++;
}
if(total>0){
tabMode.addRow(new Object[]{
"","Total",":","","","","","",total
});
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs!=null){
rs.close();
}
if(ps!=null){
ps.close();
}
}
this.setCursor(Cursor.getDefaultCursor());
}catch(Exception e){
System.out.println("Catatan "+e);
}
}
private void isForm(){
if(ChkInput.isSelected()==true){
ChkInput.setVisible(false);
PanelInput.setPreferredSize(new Dimension(WIDTH,96));
FormInput.setVisible(true);
ChkInput.setVisible(true);
}else if(ChkInput.isSelected()==false){
ChkInput.setVisible(false);
PanelInput.setPreferredSize(new Dimension(WIDTH,20));
FormInput.setVisible(false);
ChkInput.setVisible(true);
}
}
}