"+
""+
""+
""+
"| No.Rawat | : | "+tbTriase.getValueAt(i,0).toString()+" | "+
" "+
""+
"| No.R.M. | : | "+tbTriase.getValueAt(i,1).toString()+" | "+
" "+
""+
"| Nama Pasien | : | "+tbTriase.getValueAt(i,2).toString()+" | "+
" "+
" "+
" | "+
""+
""+
""+
"| Tgl.Kunjungan | : | "+tbTriase.getValueAt(i,3).toString()+" | "+
" "+
""+
"| Cara Masuk | : | "+tbTriase.getValueAt(i,4).toString()+" | "+
" "+
""+
"| Transportasi | : | "+tbTriase.getValueAt(i,5).toString()+" | "+
" "+
" "+
" | "+
""+
""+
""+
"| Alasan Kedatangan | : | "+tbTriase.getValueAt(i,6).toString()+" | "+
" "+
""+
"| Keterangan | : | "+tbTriase.getValueAt(i,7).toString()+" | "+
" "+
""+
"| Macam Kasus | : | "+tbTriase.getValueAt(i,9).toString()+" | "+
" "+
" "+
" | "
);
ps=koneksi.prepareStatement(
"select data_triase_igdprimer.keluhan_utama,data_triase_igdprimer.kebutuhan_khusus,data_triase_igdprimer.catatan,"+
"data_triase_igdprimer.plan,data_triase_igdprimer.tanggaltriase,data_triase_igdprimer.nik,data_triase_igd.tekanan_darah,"+
"data_triase_igd.nadi,data_triase_igd.pernapasan,data_triase_igd.suhu,data_triase_igd.saturasi_o2,data_triase_igd.nyeri,"+
"data_triase_igd.no_rawat from data_triase_igdprimer inner join data_triase_igd on data_triase_igd.no_rawat="+
"data_triase_igdprimer.no_rawat where data_triase_igd.no_rawat=?");
try {
ps.setString(1,tbTriase.getValueAt(i,0).toString());
rs=ps.executeQuery();
if(rs.next()){
htmlContent.append(
" Keluhan Utama : "+rs.getString("keluhan_utama")+"
Kebutuhan Khusus : "+rs.getString("kebutuhan_khusus")+" | "+
" Suhu (C) : "+rs.getString("suhu")+", Respirasi(/menit) : "+rs.getString("pernapasan")+", Tensi : "+rs.getString("tekanan_darah")+", Nadi(/menit) : "+rs.getString("nadi")+", Saturasi O²(%) : "+rs.getString("saturasi_o2")+", Nyeri : "+rs.getString("nyeri")+" | "
);
ps2=koneksi.prepareStatement(
"select master_triase_pemeriksaan.kode_pemeriksaan,master_triase_pemeriksaan.nama_pemeriksaan "+
"from master_triase_pemeriksaan inner join master_triase_skala1 inner join data_triase_igddetail_skala1 "+
"on master_triase_pemeriksaan.kode_pemeriksaan=master_triase_skala1.kode_pemeriksaan and "+
"master_triase_skala1.kode_skala1=data_triase_igddetail_skala1.kode_skala1 where data_triase_igddetail_skala1.no_rawat=? "+
"group by master_triase_pemeriksaan.kode_pemeriksaan order by master_triase_pemeriksaan.kode_pemeriksaan");
try {
ps2.setString(1,rs.getString("no_rawat"));
rs2=ps2.executeQuery();
if(rs2.next()){
htmlContent.append(
""+
""
);
rs2.beforeFirst();
while(rs2.next()){
htmlContent.append(
""+
"| "+rs2.getString("nama_pemeriksaan")+" | "+
": | "+
""+
""
);
ps3=koneksi.prepareStatement(
"select master_triase_skala1.pengkajian_skala1 from master_triase_skala1 inner join data_triase_igddetail_skala1 "+
"on master_triase_skala1.kode_skala1=data_triase_igddetail_skala1.kode_skala1 where "+
"master_triase_skala1.kode_pemeriksaan=? and data_triase_igddetail_skala1.no_rawat=? "+
"order by data_triase_igddetail_skala1.kode_skala1");
try {
ps3.setString(1,rs2.getString("kode_pemeriksaan"));
ps3.setString(2,rs.getString("no_rawat"));
rs3=ps3.executeQuery();
while(rs3.next()){
htmlContent.append(
""+
"| "+rs3.getString("pengkajian_skala1")+" | "+
" "
);
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
if(ps3!=null){
ps3.close();
}
}
htmlContent.append(
" "+
" | "+
" "
);
}
htmlContent.append(
" "+
" | "
);
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs2!=null){
rs2.close();
}
if(ps2!=null){
ps2.close();
}
}
ps2=koneksi.prepareStatement(
"select master_triase_pemeriksaan.kode_pemeriksaan,master_triase_pemeriksaan.nama_pemeriksaan "+
"from master_triase_pemeriksaan inner join master_triase_skala2 inner join data_triase_igddetail_skala2 "+
"on master_triase_pemeriksaan.kode_pemeriksaan=master_triase_skala2.kode_pemeriksaan and "+
"master_triase_skala2.kode_skala2=data_triase_igddetail_skala2.kode_skala2 where data_triase_igddetail_skala2.no_rawat=? "+
"group by master_triase_pemeriksaan.kode_pemeriksaan order by master_triase_pemeriksaan.kode_pemeriksaan");
try {
ps2.setString(1,rs.getString("no_rawat"));
rs2=ps2.executeQuery();
if(rs2.next()){
htmlContent.append(
""+
""
);
rs2.beforeFirst();
while(rs2.next()){
htmlContent.append(
""+
"| "+rs2.getString("nama_pemeriksaan")+" | "+
": | "+
""+
""
);
ps3=koneksi.prepareStatement(
"select master_triase_skala2.pengkajian_skala2 from master_triase_skala2 inner join data_triase_igddetail_skala2 "+
"on master_triase_skala2.kode_skala2=data_triase_igddetail_skala2.kode_skala2 where "+
"master_triase_skala2.kode_pemeriksaan=? and data_triase_igddetail_skala2.no_rawat=? "+
"order by data_triase_igddetail_skala2.kode_skala2");
try {
ps3.setString(1,rs2.getString("kode_pemeriksaan"));
ps3.setString(2,rs.getString("no_rawat"));
rs3=ps3.executeQuery();
while(rs3.next()){
htmlContent.append(
""+
"| "+rs3.getString("pengkajian_skala2")+" | "+
" "
);
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
if(ps3!=null){
ps3.close();
}
}
htmlContent.append(
" "+
" | "+
" "
);
}
htmlContent.append(
" "+
" | "
);
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs2!=null){
rs2.close();
}
if(ps2!=null){
ps2.close();
}
}
htmlContent.append(
""+
""+
""+
"| Keputusan | : | Zona Merah "+rs.getString("plan")+" | "+
" "+
""+
"| Tanggal & Jam | : | "+rs.getString("tanggaltriase")+" | "+
" "+
""+
"| Catatan | : | "+rs.getString("catatan")+" | "+
" "+
""+
"| Dokter/Petugas | : | "+rs.getString("nik")+" "+Sequel.cariIsi("select pegawai.nama from pegawai where pegawai.nik=?",rs.getString("nik"))+" | "+
" "+
" "+
" | "
);
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs!=null){
rs.close();
}
if(ps!=null){
ps.close();
}
}
ps=koneksi.prepareStatement(
"select data_triase_igdsekunder.anamnesa_singkat,data_triase_igdsekunder.catatan,"+
"data_triase_igdsekunder.plan,data_triase_igdsekunder.tanggaltriase,data_triase_igdsekunder.nik,data_triase_igd.tekanan_darah,"+
"data_triase_igd.nadi,data_triase_igd.pernapasan,data_triase_igd.suhu,data_triase_igd.saturasi_o2,data_triase_igd.nyeri,"+
"data_triase_igd.no_rawat from data_triase_igdsekunder inner join data_triase_igd on data_triase_igd.no_rawat="+
"data_triase_igdsekunder.no_rawat where data_triase_igd.no_rawat=?");
try {
ps.setString(1,tbTriase.getValueAt(i,0).toString());
rs=ps.executeQuery();
if(rs.next()){
htmlContent.append(
" Anamnesa Singkat : "+rs.getString("anamnesa_singkat")+" | "+
" Suhu (C) : "+rs.getString("suhu")+", Respirasi(/menit) : "+rs.getString("pernapasan")+", Tensi : "+rs.getString("tekanan_darah")+", Nadi(/menit) : "+rs.getString("nadi")+", Saturasi O²(%) : "+rs.getString("saturasi_o2")+", Nyeri : "+rs.getString("nyeri")+" | "
);
ps2=koneksi.prepareStatement(
"select master_triase_pemeriksaan.kode_pemeriksaan,master_triase_pemeriksaan.nama_pemeriksaan "+
"from master_triase_pemeriksaan inner join master_triase_skala3 inner join data_triase_igddetail_skala3 "+
"on master_triase_pemeriksaan.kode_pemeriksaan=master_triase_skala3.kode_pemeriksaan and "+
"master_triase_skala3.kode_skala3=data_triase_igddetail_skala3.kode_skala3 where data_triase_igddetail_skala3.no_rawat=? "+
"group by master_triase_pemeriksaan.kode_pemeriksaan order by master_triase_pemeriksaan.kode_pemeriksaan");
try {
ps2.setString(1,rs.getString("no_rawat"));
rs2=ps2.executeQuery();
if(rs2.next()){
htmlContent.append(
""+
""
);
rs2.beforeFirst();
while(rs2.next()){
htmlContent.append(
""+
"| "+rs2.getString("nama_pemeriksaan")+" | "+
": | "+
""+
""
);
ps3=koneksi.prepareStatement(
"select master_triase_skala3.pengkajian_skala3 from master_triase_skala3 inner join data_triase_igddetail_skala3 "+
"on master_triase_skala3.kode_skala3=data_triase_igddetail_skala3.kode_skala3 where "+
"master_triase_skala3.kode_pemeriksaan=? and data_triase_igddetail_skala3.no_rawat=? "+
"order by data_triase_igddetail_skala3.kode_skala3");
try {
ps3.setString(1,rs2.getString("kode_pemeriksaan"));
ps3.setString(2,rs.getString("no_rawat"));
rs3=ps3.executeQuery();
while(rs3.next()){
htmlContent.append(
""+
"| "+rs3.getString("pengkajian_skala3")+" | "+
" "
);
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
if(ps3!=null){
ps3.close();
}
}
htmlContent.append(
" "+
" | "+
" "
);
}
htmlContent.append(
" "+
" | "
);
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs2!=null){
rs2.close();
}
if(ps2!=null){
ps2.close();
}
}
ps2=koneksi.prepareStatement(
"select master_triase_pemeriksaan.kode_pemeriksaan,master_triase_pemeriksaan.nama_pemeriksaan "+
"from master_triase_pemeriksaan inner join master_triase_skala4 inner join data_triase_igddetail_skala4 "+
"on master_triase_pemeriksaan.kode_pemeriksaan=master_triase_skala4.kode_pemeriksaan and "+
"master_triase_skala4.kode_skala4=data_triase_igddetail_skala4.kode_skala4 where data_triase_igddetail_skala4.no_rawat=? "+
"group by master_triase_pemeriksaan.kode_pemeriksaan order by master_triase_pemeriksaan.kode_pemeriksaan");
try {
ps2.setString(1,rs.getString("no_rawat"));
rs2=ps2.executeQuery();
if(rs2.next()){
htmlContent.append(
""+
""
);
rs2.beforeFirst();
while(rs2.next()){
htmlContent.append(
""+
"| "+rs2.getString("nama_pemeriksaan")+" | "+
": | "+
""+
""
);
ps3=koneksi.prepareStatement(
"select master_triase_skala4.pengkajian_skala4 from master_triase_skala4 inner join data_triase_igddetail_skala4 "+
"on master_triase_skala4.kode_skala4=data_triase_igddetail_skala4.kode_skala4 where "+
"master_triase_skala4.kode_pemeriksaan=? and data_triase_igddetail_skala4.no_rawat=? "+
"order by data_triase_igddetail_skala4.kode_skala4");
try {
ps3.setString(1,rs2.getString("kode_pemeriksaan"));
ps3.setString(2,rs.getString("no_rawat"));
rs3=ps3.executeQuery();
while(rs3.next()){
htmlContent.append(
""+
"| "+rs3.getString("pengkajian_skala4")+" | "+
" "
);
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
if(ps3!=null){
ps3.close();
}
}
htmlContent.append(
" "+
" | "+
" "
);
}
htmlContent.append(
" "+
" | "
);
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs2!=null){
rs2.close();
}
if(ps2!=null){
ps2.close();
}
}
ps2=koneksi.prepareStatement(
"select master_triase_pemeriksaan.kode_pemeriksaan,master_triase_pemeriksaan.nama_pemeriksaan "+
"from master_triase_pemeriksaan inner join master_triase_skala5 inner join data_triase_igddetail_skala5 "+
"on master_triase_pemeriksaan.kode_pemeriksaan=master_triase_skala5.kode_pemeriksaan and "+
"master_triase_skala5.kode_skala5=data_triase_igddetail_skala5.kode_skala5 where data_triase_igddetail_skala5.no_rawat=? "+
"group by master_triase_pemeriksaan.kode_pemeriksaan order by master_triase_pemeriksaan.kode_pemeriksaan");
try {
ps2.setString(1,rs.getString("no_rawat"));
rs2=ps2.executeQuery();
if(rs2.next()){
htmlContent.append(
""+
""
);
rs2.beforeFirst();
while(rs2.next()){
htmlContent.append(
""+
"| "+rs2.getString("nama_pemeriksaan")+" | "+
": | "+
""+
""
);
ps3=koneksi.prepareStatement(
"select master_triase_skala5.pengkajian_skala5 from master_triase_skala5 inner join data_triase_igddetail_skala5 "+
"on master_triase_skala5.kode_skala5=data_triase_igddetail_skala5.kode_skala5 where "+
"master_triase_skala5.kode_pemeriksaan=? and data_triase_igddetail_skala5.no_rawat=? "+
"order by data_triase_igddetail_skala5.kode_skala5");
try {
ps3.setString(1,rs2.getString("kode_pemeriksaan"));
ps3.setString(2,rs.getString("no_rawat"));
rs3=ps3.executeQuery();
while(rs3.next()){
htmlContent.append(
""+
"| "+rs3.getString("pengkajian_skala5")+" | "+
" "
);
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
if(ps3!=null){
ps3.close();
}
}
htmlContent.append(
" "+
" | "+
" "
);
}
htmlContent.append(
" "+
" | "
);
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs2!=null){
rs2.close();
}
if(ps2!=null){
ps2.close();
}
}
htmlContent.append(
""+
""+
""+
"| Keputusan | : | "+rs.getString("plan")+" | "+
" "+
""+
"| Tanggal & Jam | : | "+rs.getString("tanggaltriase")+" | "+
" "+
""+
"| Catatan | : | "+rs.getString("catatan")+" | "+
" "+
""+
"| Dokter/Petugas | : | "+rs.getString("nik")+" "+Sequel.cariIsi("select pegawai.nama from pegawai where pegawai.nik=?",rs.getString("nik"))+" | "+
" "+
" "+
" | "
);
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs!=null){
rs.close();
}
if(ps!=null){
ps.close();
}
}
htmlContent.append(
""
);
}
LoadHTML2.setText(
""+
""+
""
);
File g = new File("file2.css");
BufferedWriter bg = new BufferedWriter(new FileWriter(g));
bg.write(
".isi td{border-right: 1px solid #e2e7dd;font: 8.5px tahoma;height:12px;border-bottom: 1px solid #e2e7dd;background: #ffffff;color:#323232;}"+
".isi2 td{font: 8.5px tahoma;border:none;height:12px;background: #ffffff;color:#323232;}"+
".isi3 td{border-right: 1px solid #e2e7dd;font: 8.5px 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;}"+
".isi5 td{font: 8.5px tahoma;border:none;height:12px;background: #ffffff;color:#AA0000;}"+
".isi6 td{font: 8.5px tahoma;border:none;height:12px;background: #ffffff;color:#FF0000;}"+
".isi7 td{font: 8.5px tahoma;border:none;height:12px;background: #ffffff;color:#C8C800;}"+
".isi8 td{font: 8.5px tahoma;border:none;height:12px;background: #ffffff;color:#00AA00;}"+
".isi9 td{font: 8.5px tahoma;border:none;height:12px;background: #ffffff;color:#969696;}"
);
bg.close();
File f = new File("DataTriaseIGD.html");
BufferedWriter bw = new BufferedWriter(new FileWriter(f));
bw.write(LoadHTML2.getText().replaceAll("",""+
""+
"")
);
bw.close();
Desktop.getDesktop().browse(f.toURI());
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
}
this.setCursor(Cursor.getDefaultCursor());
TNoRM1.setText("");
TPasien1.setText("");
LoadHTML.setText("");
ChkAccor.setSelected(false);
isMenu();
break;
}
}
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, BtnEdit, BtnKeluar);
}
}//GEN-LAST:event_BtnPrintKeyPressed
private void TCariKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_TCariKeyPressed
if(evt.getKeyCode()==KeyEvent.VK_ENTER){
BtnCariActionPerformed(null);
}else if(evt.getKeyCode()==KeyEvent.VK_PAGE_DOWN){
BtnCari.requestFocus();
}else if(evt.getKeyCode()==KeyEvent.VK_PAGE_UP){
BtnKeluar.requestFocus();
}
}//GEN-LAST:event_TCariKeyPressed
private void BtnCariActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnCariActionPerformed
tampil();
}//GEN-LAST:event_BtnCariActionPerformed
private void BtnCariKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnCariKeyPressed
if(evt.getKeyCode()==KeyEvent.VK_SPACE){
BtnCariActionPerformed(null);
}else{
Valid.pindah(evt, TCari, BtnAll);
}
}//GEN-LAST:event_BtnCariKeyPressed
private void BtnAllActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnAllActionPerformed
TCari.setText("");
tampil();
}//GEN-LAST:event_BtnAllActionPerformed
private void BtnAllKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnAllKeyPressed
if(evt.getKeyCode()==KeyEvent.VK_SPACE){
TCari.setText("");
tampil();
}else{
Valid.pindah(evt, BtnCari, TPasien);
}
}//GEN-LAST:event_BtnAllKeyPressed
private void tbTriaseMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_tbTriaseMouseClicked
if(tabMode.getRowCount()!=0){
try {
ChkAccor.setSelected(true);
isMenu();
getData();
} catch (java.lang.NullPointerException e) {
}
}
}//GEN-LAST:event_tbTriaseMouseClicked
private void tbTriaseKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_tbTriaseKeyPressed
if(tabMode.getRowCount()!=0){
if(evt.getKeyCode()==KeyEvent.VK_SHIFT){
TCari.setText("");
TCari.requestFocus();
}else if(evt.getKeyCode()==KeyEvent.VK_SPACE){
if(tbTriase.getSelectedRow()!= -1){
try {
Valid.tabelKosong(tabModeSkala1);
Valid.tabelKosong(tabModeSkala2);
Valid.tabelKosong(tabModeSkala3);
Valid.tabelKosong(tabModeSkala4);
Valid.tabelKosong(tabModeSkala5);
TNoRw.setText(tbTriase.getValueAt(tbTriase.getSelectedRow(),0).toString());
TNoRM.setText(tbTriase.getValueAt(tbTriase.getSelectedRow(),1).toString());
TPasien.setText(tbTriase.getValueAt(tbTriase.getSelectedRow(),2).toString());
Valid.SetTgl2(TanggalKunjungan,tbTriase.getValueAt(tbTriase.getSelectedRow(),3).toString());
CaraMasuk.setSelectedItem(tbTriase.getValueAt(tbTriase.getSelectedRow(),4).toString());
Transportasi.setSelectedItem(tbTriase.getValueAt(tbTriase.getSelectedRow(),5).toString());
AlasanKedatangan.setSelectedItem(tbTriase.getValueAt(tbTriase.getSelectedRow(),6).toString());
KeteranganKedatangan.setText(tbTriase.getValueAt(tbTriase.getSelectedRow(),7).toString());
KdKasus.setText(tbTriase.getValueAt(tbTriase.getSelectedRow(),8).toString());
NmKasus.setText(tbTriase.getValueAt(tbTriase.getSelectedRow(),9).toString());
TabPilihan.setSelectedIndex(0);
ps=koneksi.prepareStatement(
"select data_triase_igdprimer.keluhan_utama,data_triase_igdprimer.kebutuhan_khusus,data_triase_igdprimer.catatan,"+
"data_triase_igdprimer.plan,data_triase_igdprimer.tanggaltriase,data_triase_igdprimer.nik,data_triase_igd.tekanan_darah,"+
"data_triase_igd.nadi,data_triase_igd.pernapasan,data_triase_igd.suhu,data_triase_igd.saturasi_o2,data_triase_igd.nyeri,"+
"data_triase_igd.no_rawat from data_triase_igdprimer inner join data_triase_igd on data_triase_igd.no_rawat="+
"data_triase_igdprimer.no_rawat where data_triase_igd.no_rawat=?");
try {
ps.setString(1,tbTriase.getValueAt(tbTriase.getSelectedRow(),0).toString());
rs=ps.executeQuery();
if(rs.next()){
kodepetugas=rs.getString("nik");
PrimerKeluhanUtama.setText(rs.getString("keluhan_utama"));
PrimerSuhu.setText(rs.getString("suhu"));
PrimerNyeri.setText(rs.getString("nyeri"));
PrimerTensi.setText(rs.getString("tekanan_darah"));
PrimerNadi.setText(rs.getString("nadi"));
PrimerSaturasi.setText(rs.getString("saturasi_o2"));
PrimerRespirasi.setText(rs.getString("pernapasan"));
PrimerKubutuhanKusus.setSelectedItem(rs.getString("kebutuhan_khusus"));
TabTriase.setSelectedIndex(0);
ps2=koneksi.prepareStatement(
"select master_triase_pemeriksaan.kode_pemeriksaan,master_triase_pemeriksaan.nama_pemeriksaan "+
"from master_triase_pemeriksaan inner join master_triase_skala1 inner join data_triase_igddetail_skala1 "+
"on master_triase_pemeriksaan.kode_pemeriksaan=master_triase_skala1.kode_pemeriksaan and "+
"master_triase_skala1.kode_skala1=data_triase_igddetail_skala1.kode_skala1 where data_triase_igddetail_skala1.no_rawat=? "+
"group by master_triase_pemeriksaan.kode_pemeriksaan order by master_triase_pemeriksaan.kode_pemeriksaan");
try {
ps2.setString(1,rs.getString("no_rawat"));
rs2=ps2.executeQuery();
if(rs2.next()){
TabSkala1dan2.setSelectedIndex(0);
Valid.tabelKosong(tabModePemeriksaan);
Valid.tabelKosong(tabModeSkala1);
rs2.beforeFirst();
while(rs2.next()){
tabModePemeriksaan.addRow(new Object[]{rs2.getString("kode_pemeriksaan"),rs2.getString("nama_pemeriksaan")});
ps3=koneksi.prepareStatement(
"select master_triase_skala1.kode_skala1,master_triase_skala1.pengkajian_skala1 from master_triase_skala1 inner join data_triase_igddetail_skala1 "+
"on master_triase_skala1.kode_skala1=data_triase_igddetail_skala1.kode_skala1 where "+
"master_triase_skala1.kode_pemeriksaan=? and data_triase_igddetail_skala1.no_rawat=? "+
"order by data_triase_igddetail_skala1.kode_skala1");
try {
ps3.setString(1,rs2.getString("kode_pemeriksaan"));
ps3.setString(2,rs.getString("no_rawat"));
rs3=ps3.executeQuery();
while(rs3.next()){
tabModeSkala1.addRow(new Object[]{true,rs3.getString("kode_skala1"),rs3.getString("pengkajian_skala1")});
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
if(ps3!=null){
ps3.close();
}
}
}
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs2!=null){
rs2.close();
}
if(ps2!=null){
ps2.close();
}
}
ps2=koneksi.prepareStatement(
"select master_triase_pemeriksaan.kode_pemeriksaan,master_triase_pemeriksaan.nama_pemeriksaan "+
"from master_triase_pemeriksaan inner join master_triase_skala2 inner join data_triase_igddetail_skala2 "+
"on master_triase_pemeriksaan.kode_pemeriksaan=master_triase_skala2.kode_pemeriksaan and "+
"master_triase_skala2.kode_skala2=data_triase_igddetail_skala2.kode_skala2 where data_triase_igddetail_skala2.no_rawat=? "+
"group by master_triase_pemeriksaan.kode_pemeriksaan order by master_triase_pemeriksaan.kode_pemeriksaan");
try {
ps2.setString(1,rs.getString("no_rawat"));
rs2=ps2.executeQuery();
if(rs2.next()){
TabSkala1dan2.setSelectedIndex(1);
Valid.tabelKosong(tabModePemeriksaan);
Valid.tabelKosong(tabModeSkala2);
rs2.beforeFirst();
while(rs2.next()){
tabModePemeriksaan.addRow(new Object[]{rs2.getString("kode_pemeriksaan"),rs2.getString("nama_pemeriksaan")});
ps3=koneksi.prepareStatement(
"select master_triase_skala2.kode_skala2,master_triase_skala2.pengkajian_skala2 from master_triase_skala2 inner join data_triase_igddetail_skala2 "+
"on master_triase_skala2.kode_skala2=data_triase_igddetail_skala2.kode_skala2 where "+
"master_triase_skala2.kode_pemeriksaan=? and data_triase_igddetail_skala2.no_rawat=? "+
"order by data_triase_igddetail_skala2.kode_skala2");
try {
ps3.setString(1,rs2.getString("kode_pemeriksaan"));
ps3.setString(2,rs.getString("no_rawat"));
rs3=ps3.executeQuery();
while(rs3.next()){
tabModeSkala2.addRow(new Object[]{true,rs3.getString("kode_skala2"),rs3.getString("pengkajian_skala2")});
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
if(ps3!=null){
ps3.close();
}
}
}
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs2!=null){
rs2.close();
}
if(ps2!=null){
ps2.close();
}
}
if(rs.getString("plan").equals("Ruang Resusitasi")){
PrimerResusitasi.setSelected(true);
}else if(rs.getString("plan").equals("Ruang Kritis")){
PrimerKritis.setSelected(true);
}
Valid.SetTgl2(PrimerTanggalTriase,rs.getString("tanggaltriase"));
PrimerCatatan.setText(rs.getString("catatan"));
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
} finally{
if(rs!=null){
rs.close();
}
if(ps!=null){
ps.close();
}
}
ps=koneksi.prepareStatement(
"select data_triase_igdsekunder.anamnesa_singkat,data_triase_igdsekunder.catatan,"+
"data_triase_igdsekunder.plan,data_triase_igdsekunder.tanggaltriase,data_triase_igdsekunder.nik,data_triase_igd.tekanan_darah,"+
"data_triase_igd.nadi,data_triase_igd.pernapasan,data_triase_igd.suhu,data_triase_igd.saturasi_o2,data_triase_igd.nyeri,"+
"data_triase_igd.no_rawat from data_triase_igdsekunder inner join data_triase_igd on data_triase_igd.no_rawat="+
"data_triase_igdsekunder.no_rawat where data_triase_igd.no_rawat=?");
try {
ps.setString(1,tbTriase.getValueAt(tbTriase.getSelectedRow(),0).toString());
rs=ps.executeQuery();
if(rs.next()){
kodepetugas=rs.getString("nik");
SekunderAnamnesa.setText(rs.getString("anamnesa_singkat"));
SekunderSuhu.setText(rs.getString("suhu"));
SekunderNyeri.setText(rs.getString("nyeri"));
SekunderTensi.setText(rs.getString("tekanan_darah"));
SekunderNadi.setText(rs.getString("nadi"));
SekunderSaturasi.setText(rs.getString("saturasi_o2"));
SekunderRespirasi.setText(rs.getString("pernapasan"));
TabTriase.setSelectedIndex(1);
ps2=koneksi.prepareStatement(
"select master_triase_pemeriksaan.kode_pemeriksaan,master_triase_pemeriksaan.nama_pemeriksaan "+
"from master_triase_pemeriksaan inner join master_triase_skala3 inner join data_triase_igddetail_skala3 "+
"on master_triase_pemeriksaan.kode_pemeriksaan=master_triase_skala3.kode_pemeriksaan and "+
"master_triase_skala3.kode_skala3=data_triase_igddetail_skala3.kode_skala3 where data_triase_igddetail_skala3.no_rawat=? "+
"group by master_triase_pemeriksaan.kode_pemeriksaan order by master_triase_pemeriksaan.kode_pemeriksaan");
try {
ps2.setString(1,rs.getString("no_rawat"));
rs2=ps2.executeQuery();
if(rs2.next()){
TabSkala3dan4dan5.setSelectedIndex(0);
Valid.tabelKosong(tabModePemeriksaan2);
Valid.tabelKosong(tabModeSkala3);
rs2.beforeFirst();
while(rs2.next()){
tabModePemeriksaan2.addRow(new Object[]{rs2.getString("kode_pemeriksaan"),rs2.getString("nama_pemeriksaan")});
ps3=koneksi.prepareStatement(
"select master_triase_skala3.kode_skala3,master_triase_skala3.pengkajian_skala3 from master_triase_skala3 inner join data_triase_igddetail_skala3 "+
"on master_triase_skala3.kode_skala3=data_triase_igddetail_skala3.kode_skala3 where "+
"master_triase_skala3.kode_pemeriksaan=? and data_triase_igddetail_skala3.no_rawat=? "+
"order by data_triase_igddetail_skala3.kode_skala3");
try {
ps3.setString(1,rs2.getString("kode_pemeriksaan"));
ps3.setString(2,rs.getString("no_rawat"));
rs3=ps3.executeQuery();
while(rs3.next()){
tabModeSkala3.addRow(new Object[]{true,rs3.getString("kode_skala3"),rs3.getString("pengkajian_skala3")});
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
if(ps3!=null){
ps3.close();
}
}
}
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs2!=null){
rs2.close();
}
if(ps2!=null){
ps2.close();
}
}
ps2=koneksi.prepareStatement(
"select master_triase_pemeriksaan.kode_pemeriksaan,master_triase_pemeriksaan.nama_pemeriksaan "+
"from master_triase_pemeriksaan inner join master_triase_skala4 inner join data_triase_igddetail_skala4 "+
"on master_triase_pemeriksaan.kode_pemeriksaan=master_triase_skala4.kode_pemeriksaan and "+
"master_triase_skala4.kode_skala4=data_triase_igddetail_skala4.kode_skala4 where data_triase_igddetail_skala4.no_rawat=? "+
"group by master_triase_pemeriksaan.kode_pemeriksaan order by master_triase_pemeriksaan.kode_pemeriksaan");
try {
ps2.setString(1,rs.getString("no_rawat"));
rs2=ps2.executeQuery();
if(rs2.next()){
TabSkala3dan4dan5.setSelectedIndex(1);
Valid.tabelKosong(tabModePemeriksaan2);
Valid.tabelKosong(tabModeSkala4);
rs2.beforeFirst();
while(rs2.next()){
tabModePemeriksaan2.addRow(new Object[]{rs2.getString("kode_pemeriksaan"),rs2.getString("nama_pemeriksaan")});
ps3=koneksi.prepareStatement(
"select master_triase_skala4.kode_skala4,master_triase_skala4.pengkajian_skala4 from master_triase_skala4 inner join data_triase_igddetail_skala4 "+
"on master_triase_skala4.kode_skala4=data_triase_igddetail_skala4.kode_skala4 where "+
"master_triase_skala4.kode_pemeriksaan=? and data_triase_igddetail_skala4.no_rawat=? "+
"order by data_triase_igddetail_skala4.kode_skala4");
try {
ps3.setString(1,rs2.getString("kode_pemeriksaan"));
ps3.setString(2,rs.getString("no_rawat"));
rs3=ps3.executeQuery();
while(rs3.next()){
tabModeSkala4.addRow(new Object[]{true,rs3.getString("kode_skala4"),rs3.getString("pengkajian_skala4")});
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
if(ps3!=null){
ps3.close();
}
}
}
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs2!=null){
rs2.close();
}
if(ps2!=null){
ps2.close();
}
}
ps2=koneksi.prepareStatement(
"select master_triase_pemeriksaan.kode_pemeriksaan,master_triase_pemeriksaan.nama_pemeriksaan "+
"from master_triase_pemeriksaan inner join master_triase_skala5 inner join data_triase_igddetail_skala5 "+
"on master_triase_pemeriksaan.kode_pemeriksaan=master_triase_skala5.kode_pemeriksaan and "+
"master_triase_skala5.kode_skala5=data_triase_igddetail_skala5.kode_skala5 where data_triase_igddetail_skala5.no_rawat=? "+
"group by master_triase_pemeriksaan.kode_pemeriksaan order by master_triase_pemeriksaan.kode_pemeriksaan");
try {
ps2.setString(1,rs.getString("no_rawat"));
rs2=ps2.executeQuery();
if(rs2.next()){
TabSkala3dan4dan5.setSelectedIndex(2);
Valid.tabelKosong(tabModePemeriksaan2);
Valid.tabelKosong(tabModeSkala5);
rs2.beforeFirst();
while(rs2.next()){
tabModePemeriksaan2.addRow(new Object[]{rs2.getString("kode_pemeriksaan"),rs2.getString("nama_pemeriksaan")});
ps3=koneksi.prepareStatement(
"select master_triase_skala5.kode_skala5,master_triase_skala5.pengkajian_skala5 from master_triase_skala5 inner join data_triase_igddetail_skala5 "+
"on master_triase_skala5.kode_skala5=data_triase_igddetail_skala5.kode_skala5 where "+
"master_triase_skala5.kode_pemeriksaan=? and data_triase_igddetail_skala5.no_rawat=? "+
"order by data_triase_igddetail_skala5.kode_skala5");
try {
ps3.setString(1,rs2.getString("kode_pemeriksaan"));
ps3.setString(2,rs.getString("no_rawat"));
rs3=ps3.executeQuery();
while(rs3.next()){
tabModeSkala5.addRow(new Object[]{true,rs3.getString("kode_skala5"),rs3.getString("pengkajian_skala5")});
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
if(ps3!=null){
ps3.close();
}
}
}
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs2!=null){
rs2.close();
}
if(ps2!=null){
ps2.close();
}
}
if(rs.getString("plan").equals("Zona Kuning")){
SekunderZonaKuning.setSelected(true);
}else if(rs.getString("plan").equals("Zona Hijau")){
SekunderZonaHijau.setSelected(true);
}
Valid.SetTgl2(SekunderTanggalTriase,rs.getString("tanggaltriase"));
SekunderCatatan.setText(rs.getString("catatan"));
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
} finally{
if(rs!=null){
rs.close();
}
if(ps!=null){
ps.close();
}
}
} catch (Exception e) {
System.out.println("Notif : "+e);
}
TNoRM1.setText("");
TPasien1.setText("");
LoadHTML.setText("");
ChkAccor.setSelected(false);
isMenu();
}
}
}
}//GEN-LAST:event_tbTriaseKeyPressed
private void formWindowOpened(java.awt.event.WindowEvent evt) {//GEN-FIRST:event_formWindowOpened
tampilPemeriksaan();
tampilPemeriksaan2();
tampil();
}//GEN-LAST:event_formWindowOpened
private void TNoRMActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_TNoRMActionPerformed
// TODO add your handling code here:
}//GEN-LAST:event_TNoRMActionPerformed
private void TabPilihanMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_TabPilihanMouseClicked
if(TabPilihan.getSelectedIndex()==1){
tampil();
}
}//GEN-LAST:event_TabPilihanMouseClicked
private void formWindowActivated(java.awt.event.WindowEvent evt) {//GEN-FIRST:event_formWindowActivated
if(this.getHeight()<620){
ScrollTriase.setVerticalScrollBarPolicy(javax.swing.ScrollPaneConstants.VERTICAL_SCROLLBAR_ALWAYS);
FormTriase.setPreferredSize(new Dimension(FormTriase.WIDTH,500));
if(this.getWidth()<780){
ScrollTriase.setHorizontalScrollBarPolicy(javax.swing.ScrollPaneConstants.HORIZONTAL_SCROLLBAR_ALWAYS);
FormTriase.setPreferredSize(new Dimension(770,500));
}else{
ScrollTriase.setHorizontalScrollBarPolicy(javax.swing.ScrollPaneConstants.HORIZONTAL_SCROLLBAR_NEVER);
}
}else{
ScrollTriase.setVerticalScrollBarPolicy(javax.swing.ScrollPaneConstants.VERTICAL_SCROLLBAR_NEVER);
if(this.getWidth()<780){
ScrollTriase.setHorizontalScrollBarPolicy(javax.swing.ScrollPaneConstants.HORIZONTAL_SCROLLBAR_ALWAYS);
FormTriase.setPreferredSize(new Dimension(770,FormTriase.HEIGHT));
}else{
ScrollTriase.setHorizontalScrollBarPolicy(javax.swing.ScrollPaneConstants.HORIZONTAL_SCROLLBAR_NEVER);
}
}
}//GEN-LAST:event_formWindowActivated
private void KdKasusKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_KdKasusKeyPressed
//Valid.pindah(evt, TCari,kdskala);
}//GEN-LAST:event_KdKasusKeyPressed
private void NmKasusKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_NmKasusKeyPressed
//Valid.pindah(evt,kdskala,BtnSimpan);
}//GEN-LAST:event_NmKasusKeyPressed
private void btnKasusActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnKasusActionPerformed
kasus.isCek();
kasus.setSize(internalFrame1.getWidth()-20,internalFrame1.getHeight()-20);
kasus.setLocationRelativeTo(internalFrame1);
kasus.setVisible(true);
}//GEN-LAST:event_btnKasusActionPerformed
private void btnKasusKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_btnKasusKeyPressed
Valid.pindah(evt,AlasanKedatangan,CaraMasuk);
}//GEN-LAST:event_btnKasusKeyPressed
private void TabTriaseMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_TabTriaseMouseClicked
if(TabTriase.getSelectedIndex()==0){
TabSkala1dan2MouseClicked(null);
}else if(TabTriase.getSelectedIndex()==1){
TabSkala3dan4dan5MouseClicked(null);
}
}//GEN-LAST:event_TabTriaseMouseClicked
private void PrimerSuhuKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_PrimerSuhuKeyPressed
Valid.pindah(evt,PrimerKeluhanUtama,PrimerNyeri);
}//GEN-LAST:event_PrimerSuhuKeyPressed
private void PrimerSaturasiKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_PrimerSaturasiKeyPressed
Valid.pindah(evt,PrimerNadi,PrimerRespirasi);
}//GEN-LAST:event_PrimerSaturasiKeyPressed
private void PrimerNyeriKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_PrimerNyeriKeyPressed
Valid.pindah(evt,PrimerSuhu,PrimerTensi);
}//GEN-LAST:event_PrimerNyeriKeyPressed
private void PrimerNadiActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_PrimerNadiActionPerformed
}//GEN-LAST:event_PrimerNadiActionPerformed
private void PrimerNadiKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_PrimerNadiKeyPressed
Valid.pindah(evt,PrimerTensi,PrimerSaturasi);
}//GEN-LAST:event_PrimerNadiKeyPressed
private void PrimerRespirasiKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_PrimerRespirasiKeyPressed
Valid.pindah(evt,PrimerSaturasi,PrimerKubutuhanKusus);
}//GEN-LAST:event_PrimerRespirasiKeyPressed
private void PrimerTensiKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_PrimerTensiKeyPressed
Valid.pindah(evt,PrimerNyeri,PrimerNadi);
}//GEN-LAST:event_PrimerTensiKeyPressed
private void PrimerKodePetugasKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_PrimerKodePetugasKeyPressed
// TODO add your handling code here:
}//GEN-LAST:event_PrimerKodePetugasKeyPressed
private void PrimerNamaPetugasKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_PrimerNamaPetugasKeyPressed
// TODO add your handling code here:
}//GEN-LAST:event_PrimerNamaPetugasKeyPressed
private void btnPrimerPetugasActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnPrimerPetugasActionPerformed
index=1;
pegawai.setSize(internalFrame1.getWidth()-20,internalFrame1.getHeight()-20);
pegawai.setLocationRelativeTo(internalFrame1);
pegawai.setAlwaysOnTop(false);
pegawai.setVisible(true);
}//GEN-LAST:event_btnPrimerPetugasActionPerformed
private void btnPrimerPetugasKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_btnPrimerPetugasKeyPressed
// TODO add your handling code here:
}//GEN-LAST:event_btnPrimerPetugasKeyPressed
private void TCariPemeriksaanKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_TCariPemeriksaanKeyPressed
if(evt.getKeyCode()==KeyEvent.VK_ENTER){
tampilPemeriksaan();
}else if(evt.getKeyCode()==KeyEvent.VK_PAGE_DOWN){
PrimerCatatan.requestFocus();
}else if(evt.getKeyCode()==KeyEvent.VK_PAGE_UP){
PrimerKubutuhanKusus.requestFocus();
}
}//GEN-LAST:event_TCariPemeriksaanKeyPressed
private void BtnCariPemeriksaanActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnCariPemeriksaanActionPerformed
tampilPemeriksaan();
}//GEN-LAST:event_BtnCariPemeriksaanActionPerformed
private void BtnCariPemeriksaanKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnCariPemeriksaanKeyPressed
// TODO add your handling code here:
}//GEN-LAST:event_BtnCariPemeriksaanKeyPressed
private void BtnTambahPemeriksaanActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnTambahPemeriksaanActionPerformed
this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR));
MasterTriasePemeriksaan form=new MasterTriasePemeriksaan(null,false);
form.isCek();
form.setSize(internalFrame1.getWidth()-20,internalFrame1.getHeight()-20);
form.setLocationRelativeTo(internalFrame1);
form.setVisible(true);
this.setCursor(Cursor.getDefaultCursor());
}//GEN-LAST:event_BtnTambahPemeriksaanActionPerformed
private void TCariSkala1KeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_TCariSkala1KeyPressed
if(evt.getKeyCode()==KeyEvent.VK_ENTER){
BtnCariSkala1ActionPerformed(null);
}else if(evt.getKeyCode()==KeyEvent.VK_PAGE_DOWN){
BtnCariSkala1.requestFocus();
}else if(evt.getKeyCode()==KeyEvent.VK_PAGE_UP){
BtnKeluar.requestFocus();
}
}//GEN-LAST:event_TCariSkala1KeyPressed
private void BtnCariSkala1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnCariSkala1ActionPerformed
if(tbPemeriksaan.getSelectedRow()!= -1){
tampilskala1();
tampilskala2();
}else{
JOptionPane.showMessageDialog(null,"Silahkan pilih pemeriksaan terlebih dahulu..!!");
}
}//GEN-LAST:event_BtnCariSkala1ActionPerformed
private void BtnCariSkala1KeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnCariSkala1KeyPressed
// TODO add your handling code here:
}//GEN-LAST:event_BtnCariSkala1KeyPressed
private void BtnTambahSkala1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnTambahSkala1ActionPerformed
if(TabSkala1dan2.getSelectedIndex()==0){
this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR));
MasterTriaseSkala1 form=new MasterTriaseSkala1(null,false);
form.isCek();
form.setSize(internalFrame1.getWidth()-20,internalFrame1.getHeight()-20);
form.setLocationRelativeTo(internalFrame1);
form.setVisible(true);
this.setCursor(Cursor.getDefaultCursor());
}else if(TabSkala1dan2.getSelectedIndex()==1){
this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR));
MasterTriaseSkala2 form=new MasterTriaseSkala2(null,false);
form.isCek();
form.setSize(internalFrame1.getWidth()-20,internalFrame1.getHeight()-20);
form.setLocationRelativeTo(internalFrame1);
form.setVisible(true);
this.setCursor(Cursor.getDefaultCursor());
}
}//GEN-LAST:event_BtnTambahSkala1ActionPerformed
private void tbPemeriksaanKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_tbPemeriksaanKeyPressed
if(tabModePemeriksaan.getRowCount()!=0){
if(evt.getKeyCode()==KeyEvent.VK_SHIFT){
TCariPemeriksaan.setText("");
TCariPemeriksaan.requestFocus();
}
}
}//GEN-LAST:event_tbPemeriksaanKeyPressed
private void tbPemeriksaanKeyReleased(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_tbPemeriksaanKeyReleased
if(tabModePemeriksaan.getRowCount()!=0){
if((evt.getKeyCode()==KeyEvent.VK_ENTER)||(evt.getKeyCode()==KeyEvent.VK_UP)||(evt.getKeyCode()==KeyEvent.VK_DOWN)){
try {
tampilskala1();
tampilskala2();
} catch (java.lang.NullPointerException e) {
}
}
}
}//GEN-LAST:event_tbPemeriksaanKeyReleased
private void tbPemeriksaanMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_tbPemeriksaanMouseClicked
if(tabModePemeriksaan.getRowCount()!=0){
try {
tampilskala1();
tampilskala2();
} catch (java.lang.NullPointerException e) {
}
}
}//GEN-LAST:event_tbPemeriksaanMouseClicked
private void TabSkala1dan2MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_TabSkala1dan2MouseClicked
if(TabSkala1dan2.getSelectedIndex()==0){
label11.setForeground(new Color(170,00,0));
TCariSkala1.setForeground(new Color(170,00,0));
BtnTambahSkala1.setEnabled(akses.getmaster_triase_skala1());
PrimerResusitasi.setSelected(true);
}else if(TabSkala1dan2.getSelectedIndex()==1){
label11.setForeground(new Color(255,0,0));
TCariSkala1.setForeground(new Color(255,00,0));
BtnTambahSkala1.setEnabled(akses.getmaster_triase_skala2());
PrimerKritis.setSelected(true);
}
}//GEN-LAST:event_TabSkala1dan2MouseClicked
private void SekunderSuhuKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_SekunderSuhuKeyPressed
Valid.pindah(evt,SekunderAnamnesa,SekunderNyeri);
}//GEN-LAST:event_SekunderSuhuKeyPressed
private void SekunderSaturasiKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_SekunderSaturasiKeyPressed
Valid.pindah(evt,SekunderNyeri,SekunderRespirasi);
}//GEN-LAST:event_SekunderSaturasiKeyPressed
private void SekunderNyeriKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_SekunderNyeriKeyPressed
Valid.pindah(evt,SekunderSuhu,SekunderSaturasi);
}//GEN-LAST:event_SekunderNyeriKeyPressed
private void SekunderNadiActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_SekunderNadiActionPerformed
// TODO add your handling code here:
}//GEN-LAST:event_SekunderNadiActionPerformed
private void SekunderNadiKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_SekunderNadiKeyPressed
Valid.pindah(evt,SekunderTensi,TCariPemeriksaan2);
}//GEN-LAST:event_SekunderNadiKeyPressed
private void SekunderRespirasiKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_SekunderRespirasiKeyPressed
Valid.pindah(evt,SekunderSaturasi,SekunderTensi);
}//GEN-LAST:event_SekunderRespirasiKeyPressed
private void SekunderTensiKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_SekunderTensiKeyPressed
Valid.pindah(evt,SekunderRespirasi,SekunderNadi);
}//GEN-LAST:event_SekunderTensiKeyPressed
private void TCariPemeriksaan2KeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_TCariPemeriksaan2KeyPressed
if(evt.getKeyCode()==KeyEvent.VK_ENTER){
tampilPemeriksaan2();
}else if(evt.getKeyCode()==KeyEvent.VK_PAGE_DOWN){
SekunderCatatan.requestFocus();
}else if(evt.getKeyCode()==KeyEvent.VK_PAGE_UP){
SekunderNadi.requestFocus();
}
}//GEN-LAST:event_TCariPemeriksaan2KeyPressed
private void BtnCariPemeriksaan1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnCariPemeriksaan1ActionPerformed
tampilPemeriksaan2();
}//GEN-LAST:event_BtnCariPemeriksaan1ActionPerformed
private void BtnCariPemeriksaan1KeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnCariPemeriksaan1KeyPressed
// TODO add your handling code here:
}//GEN-LAST:event_BtnCariPemeriksaan1KeyPressed
private void BtnTambahPemeriksaan1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnTambahPemeriksaan1ActionPerformed
this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR));
MasterTriasePemeriksaan form=new MasterTriasePemeriksaan(null,false);
form.isCek();
form.setSize(internalFrame1.getWidth()-20,internalFrame1.getHeight()-20);
form.setLocationRelativeTo(internalFrame1);
form.setVisible(true);
this.setCursor(Cursor.getDefaultCursor());
}//GEN-LAST:event_BtnTambahPemeriksaan1ActionPerformed
private void tbPemeriksaan2MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_tbPemeriksaan2MouseClicked
if(tabModePemeriksaan2.getRowCount()!=0){
try {
tampilskala3();
tampilskala4();
tampilskala5();
} catch (java.lang.NullPointerException e) {
}
}
}//GEN-LAST:event_tbPemeriksaan2MouseClicked
private void tbPemeriksaan2KeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_tbPemeriksaan2KeyPressed
if(tabModePemeriksaan2.getRowCount()!=0){
if(evt.getKeyCode()==KeyEvent.VK_SHIFT){
TCariPemeriksaan2.setText("");
TCariPemeriksaan2.requestFocus();
}
}
}//GEN-LAST:event_tbPemeriksaan2KeyPressed
private void tbPemeriksaan2KeyReleased(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_tbPemeriksaan2KeyReleased
if(tabModePemeriksaan2.getRowCount()!=0){
if((evt.getKeyCode()==KeyEvent.VK_ENTER)||(evt.getKeyCode()==KeyEvent.VK_UP)||(evt.getKeyCode()==KeyEvent.VK_DOWN)){
try {
tampilskala3();
tampilskala4();
tampilskala5();
} catch (java.lang.NullPointerException e) {
}
}
}
}//GEN-LAST:event_tbPemeriksaan2KeyReleased
private void TCariSkala3KeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_TCariSkala3KeyPressed
// TODO add your handling code here:
}//GEN-LAST:event_TCariSkala3KeyPressed
private void BtnCariSkala2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnCariSkala2ActionPerformed
if(tbPemeriksaan2.getSelectedRow()!= -1){
tampilskala3();
tampilskala4();
tampilskala5();
}else{
JOptionPane.showMessageDialog(null,"Silahkan pilih pemeriksaan terlebih dahulu..!!");
}
}//GEN-LAST:event_BtnCariSkala2ActionPerformed
private void BtnCariSkala2KeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnCariSkala2KeyPressed
// TODO add your handling code here:
}//GEN-LAST:event_BtnCariSkala2KeyPressed
private void BtnTambahSkala2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnTambahSkala2ActionPerformed
if(TabSkala3dan4dan5.getSelectedIndex()==0){
this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR));
MasterTriaseSkala3 form=new MasterTriaseSkala3(null,false);
form.isCek();
form.setSize(internalFrame1.getWidth()-20,internalFrame1.getHeight()-20);
form.setLocationRelativeTo(internalFrame1);
form.setVisible(true);
this.setCursor(Cursor.getDefaultCursor());
}else if(TabSkala3dan4dan5.getSelectedIndex()==1){
this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR));
MasterTriaseSkala4 form=new MasterTriaseSkala4(null,false);
form.isCek();
form.setSize(internalFrame1.getWidth()-20,internalFrame1.getHeight()-20);
form.setLocationRelativeTo(internalFrame1);
form.setVisible(true);
this.setCursor(Cursor.getDefaultCursor());
}else if(TabSkala3dan4dan5.getSelectedIndex()==2){
this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR));
MasterTriaseSkala5 form=new MasterTriaseSkala5(null,false);
form.isCek();
form.setSize(internalFrame1.getWidth()-20,internalFrame1.getHeight()-20);
form.setLocationRelativeTo(internalFrame1);
form.setVisible(true);
this.setCursor(Cursor.getDefaultCursor());
}
}//GEN-LAST:event_BtnTambahSkala2ActionPerformed
private void TabSkala3dan4dan5MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_TabSkala3dan4dan5MouseClicked
if(TabSkala3dan4dan5.getSelectedIndex()==0){
label13.setForeground(new Color(200,200,0));
TCariSkala3.setForeground(new Color(200,200,0));
BtnTambahSkala2.setEnabled(akses.getmaster_triase_skala3());
SekunderZonaKuning.setSelected(true);
}else if(TabSkala3dan4dan5.getSelectedIndex()==1){
label13.setForeground(new Color(0,170,0));
TCariSkala3.setForeground(new Color(0,170,0));
BtnTambahSkala2.setEnabled(akses.getmaster_triase_skala4());
SekunderZonaHijau.setSelected(true);
}else if(TabSkala3dan4dan5.getSelectedIndex()==2){
label13.setForeground(new Color(150,150,150));
TCariSkala3.setForeground(new Color(150,150,150));
BtnTambahSkala2.setEnabled(akses.getmaster_triase_skala5());
SekunderZonaHijau.setSelected(true);
}
}//GEN-LAST:event_TabSkala3dan4dan5MouseClicked
private void PrimerCatatanKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_PrimerCatatanKeyPressed
Valid.pindah(evt,TCariPemeriksaan,PrimerTanggalTriase);
}//GEN-LAST:event_PrimerCatatanKeyPressed
private void SekunderKodePetugasKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_SekunderKodePetugasKeyPressed
// TODO add your handling code here:
}//GEN-LAST:event_SekunderKodePetugasKeyPressed
private void SekunderNamaPetugasKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_SekunderNamaPetugasKeyPressed
// TODO add your handling code here:
}//GEN-LAST:event_SekunderNamaPetugasKeyPressed
private void btnSekunderPetugasActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnSekunderPetugasActionPerformed
index=2;
pegawai.setSize(internalFrame1.getWidth()-20,internalFrame1.getHeight()-20);
pegawai.setLocationRelativeTo(internalFrame1);
pegawai.setAlwaysOnTop(false);
pegawai.setVisible(true);
}//GEN-LAST:event_btnSekunderPetugasActionPerformed
private void btnSekunderPetugasKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_btnSekunderPetugasKeyPressed
Valid.pindah(evt,SekunderTanggalTriase,BtnSimpan);
}//GEN-LAST:event_btnSekunderPetugasKeyPressed
private void SekunderCatatanKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_SekunderCatatanKeyPressed
Valid.pindah(evt,TCariPemeriksaan2,SekunderTanggalTriase);
}//GEN-LAST:event_SekunderCatatanKeyPressed
private void TransportasiKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_TransportasiKeyPressed
Valid.pindah(evt,TCari,TanggalKunjungan);
}//GEN-LAST:event_TransportasiKeyPressed
private void TanggalKunjunganKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_TanggalKunjunganKeyPressed
Valid.pindah(evt,Transportasi,CaraMasuk);
}//GEN-LAST:event_TanggalKunjunganKeyPressed
private void AlasanKedatanganKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_AlasanKedatanganKeyPressed
Valid.pindah(evt,CaraMasuk,btnKasus);
}//GEN-LAST:event_AlasanKedatanganKeyPressed
private void CaraMasukKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_CaraMasukKeyPressed
Valid.pindah(evt,TanggalKunjungan,AlasanKedatangan);
}//GEN-LAST:event_CaraMasukKeyPressed
private void KeteranganKedatanganKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_KeteranganKedatanganKeyPressed
if(TabTriase.getSelectedIndex()==0){
Valid.pindah(evt,CaraMasuk,PrimerKeluhanUtama);
}else if(TabTriase.getSelectedIndex()==1){
Valid.pindah(evt,CaraMasuk,SekunderAnamnesa);
}
}//GEN-LAST:event_KeteranganKedatanganKeyPressed
private void SekunderAnamnesaKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_SekunderAnamnesaKeyPressed
Valid.pindah2(evt,KeteranganKedatangan,SekunderSuhu);
}//GEN-LAST:event_SekunderAnamnesaKeyPressed
private void PrimerKeluhanUtamaKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_PrimerKeluhanUtamaKeyPressed
Valid.pindah2(evt,KeteranganKedatangan,PrimerSuhu);
}//GEN-LAST:event_PrimerKeluhanUtamaKeyPressed
private void PrimerKubutuhanKususKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_PrimerKubutuhanKususKeyPressed
Valid.pindah(evt,PrimerRespirasi,TCariPemeriksaan);
}//GEN-LAST:event_PrimerKubutuhanKususKeyPressed
private void PrimerTanggalTriaseKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_PrimerTanggalTriaseKeyPressed
Valid.pindah(evt,PrimerCatatan,btnPrimerPetugas);
}//GEN-LAST:event_PrimerTanggalTriaseKeyPressed
private void btnPrimerPetugasKeyReleased(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_btnPrimerPetugasKeyReleased
Valid.pindah(evt,PrimerTanggalTriase,BtnSimpan);
}//GEN-LAST:event_btnPrimerPetugasKeyReleased
private void SekunderTanggalTriaseKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_SekunderTanggalTriaseKeyPressed
Valid.pindah(evt,SekunderCatatan,btnSekunderPetugas);
}//GEN-LAST:event_SekunderTanggalTriaseKeyPressed
private void tbTriaseKeyReleased(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_tbTriaseKeyReleased
if(tabMode.getRowCount()!=0){
if((evt.getKeyCode()==KeyEvent.VK_ENTER)||(evt.getKeyCode()==KeyEvent.VK_UP)||(evt.getKeyCode()==KeyEvent.VK_DOWN)){
try {
getData();
} catch (java.lang.NullPointerException e) {
}
}
}
}//GEN-LAST:event_tbTriaseKeyReleased
private void ChkAccorActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_ChkAccorActionPerformed
if(tbTriase.getSelectedRow()!= -1){
isMenu();
}else{
ChkAccor.setSelected(false);
JOptionPane.showMessageDialog(null,"Maaf, silahkan pilih data yang mau ditampilkan triasenya...!!!!");
}
}//GEN-LAST:event_ChkAccorActionPerformed
private void BtnPrint1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnPrint1ActionPerformed
if(TNoRM1.getText().trim().equals("")||TPasien1.getText().trim().equals("")){
Valid.textKosong(TCari,"Pasien");
}else{
if(tbTriase.getSelectedRow()> -1){
this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR));
i=0;
if(LoadHTML.getText().contains("#AA0000")){
Map 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"));
try {
ps=koneksi.prepareStatement(
"select data_triase_igdprimer.keluhan_utama,data_triase_igdprimer.kebutuhan_khusus,data_triase_igdprimer.catatan,"+
"data_triase_igdprimer.plan,data_triase_igdprimer.tanggaltriase,data_triase_igdprimer.nik,data_triase_igd.tekanan_darah,"+
"data_triase_igd.nadi,data_triase_igd.pernapasan,data_triase_igd.suhu,data_triase_igd.saturasi_o2,data_triase_igd.nyeri,"+
"data_triase_igd.no_rawat,pasien.no_rkm_medis,pasien.nm_pasien,pasien.jk,pasien.tgl_lahir,pegawai.nama,data_triase_igd.tgl_kunjungan, "+
"data_triase_igd.cara_masuk,master_triase_macam_kasus.macam_kasus from data_triase_igdprimer inner join data_triase_igd "+
"inner join pasien inner join pegawai inner join reg_periksa inner join master_triase_macam_kasus on "+
"data_triase_igd.no_rawat=data_triase_igdprimer.no_rawat and reg_periksa.no_rawat=data_triase_igd.no_rawat "+
"and reg_periksa.no_rkm_medis=pasien.no_rkm_medis and pegawai.nik=data_triase_igdprimer.nik "+
"and master_triase_macam_kasus.kode_kasus=data_triase_igd.kode_kasus where data_triase_igd.no_rawat=?");
try {
ps.setString(1,tbTriase.getValueAt(tbTriase.getSelectedRow(),0).toString());
rs=ps.executeQuery();
if(rs.next()){
param.put("norawat",rs.getString("no_rawat"));
param.put("norm",rs.getString("no_rkm_medis"));
param.put("namapasien",rs.getString("nm_pasien"));
param.put("tanggallahir",rs.getDate("tgl_lahir"));
param.put("jk",rs.getString("jk").replaceAll("L","Laki-Laki").replaceAll("P","Perempuan"));
param.put("tanggalkunjungan",rs.getDate("tgl_kunjungan"));
param.put("jamkunjungan",rs.getString("tgl_kunjungan").toString().substring(11,19));
param.put("caradatang",rs.getString("cara_masuk"));
param.put("macamkasus",rs.getString("macam_kasus"));
param.put("keluhanutama",rs.getString("keluhan_utama"));
param.put("kebutuhankhusus",rs.getString("kebutuhan_khusus"));
param.put("plan",rs.getString("plan"));
param.put("tanggaltriase",rs.getDate("tanggaltriase"));
param.put("jamtriase",rs.getString("tanggaltriase").toString().substring(11,19));
param.put("pegawai",rs.getString("nama"));
param.put("catatan",rs.getString("catatan"));
param.put("tandavital","Suhu (C) : "+rs.getString("suhu")+", Nyeri : "+rs.getString("nyeri")+", Tensi : "+rs.getString("tekanan_darah")+", Nadi(/menit) : "+rs.getString("nadi")+", Saturasi O²(%) : "+rs.getString("saturasi_o2")+", Respirasi(/menit) : "+rs.getString("pernapasan"));
finger=Sequel.cariIsi("select sha1(sidikjari.sidikjari) from sidikjari inner join pegawai on pegawai.id=sidikjari.id where pegawai.nik=?",rs.getString("nik"));
param.put("finger","Dikeluarkan di "+akses.getnamars()+", Kabupaten/Kota "+akses.getkabupatenrs()+"\nDitandatangani secara elektronik oleh "+rs.getString("nama")+"\nID "+(finger.equals("")?rs.getString("nik"):finger)+"\n"+Valid.SetTgl3(rs.getString("tanggaltriase")));
ps2=koneksi.prepareStatement(
"select master_triase_pemeriksaan.kode_pemeriksaan,master_triase_pemeriksaan.nama_pemeriksaan "+
"from master_triase_pemeriksaan inner join master_triase_skala1 inner join data_triase_igddetail_skala1 "+
"on master_triase_pemeriksaan.kode_pemeriksaan=master_triase_skala1.kode_pemeriksaan and "+
"master_triase_skala1.kode_skala1=data_triase_igddetail_skala1.kode_skala1 where data_triase_igddetail_skala1.no_rawat=? "+
"group by master_triase_pemeriksaan.kode_pemeriksaan order by master_triase_pemeriksaan.kode_pemeriksaan");
try {
Sequel.queryu("delete from temporary where temp37='"+akses.getalamatip()+"'");
ps2.setString(1,rs.getString("no_rawat"));
rs2=ps2.executeQuery();
while(rs2.next()){
datatriase="";
ps3=koneksi.prepareStatement(
"select master_triase_skala1.pengkajian_skala1 from master_triase_skala1 inner join data_triase_igddetail_skala1 "+
"on master_triase_skala1.kode_skala1=data_triase_igddetail_skala1.kode_skala1 where "+
"master_triase_skala1.kode_pemeriksaan=? and data_triase_igddetail_skala1.no_rawat=? "+
"order by data_triase_igddetail_skala1.kode_skala1");
try {
ps3.setString(1,rs2.getString("kode_pemeriksaan"));
ps3.setString(2,rs.getString("no_rawat"));
rs3=ps3.executeQuery();
while(rs3.next()){
datatriase=rs3.getString("pengkajian_skala1")+", "+datatriase;
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
if(ps3!=null){
ps3.close();
}
}
if(datatriase.endsWith(", ")){
datatriase = datatriase.substring(0,datatriase.length() - 2);
}
Sequel.menyimpan2("temporary","'"+i+"','"+rs2.getString("nama_pemeriksaan")+"','"+datatriase+"','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','"+akses.getalamatip()+"'","Transaksi");
i++;
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs2!=null){
rs2.close();
}
if(ps2!=null){
ps2.close();
}
}
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs!=null){
rs.close();
}
if(ps!=null){
ps.close();
}
}
} catch (Exception e) {
System.out.println("Notif : "+e);
}
try {
pilihan = (String)JOptionPane.showInputDialog(null,"Silahkan pilih Lembar/PDF Triase Skala 1..!","Pilihan",JOptionPane.QUESTION_MESSAGE,null,new Object[]{"Lembar Triase Skala 1","PDF Triase Skala 1"},"Lambar Triase Skala 1");
switch (pilihan) {
case "Lembar Triase Skala 1":
Valid.MyReportqry("rptLembarTriaseSkala1.jasper","report","::[ Triase Skala 1 ]::","select * from temporary where temporary.temp37='"+akses.getalamatip()+"' order by temporary.no",param);
break;
case "PDF Triase Skala 1":
Valid.MyReportqrypdf("rptLembarTriaseSkala1.jasper","report","::[ Triase Skala 1 ]::","select * from temporary where temporary.temp37='"+akses.getalamatip()+"' order by temporary.no",param);
break;
}
} catch (Exception e) {
}
}else if(LoadHTML.getText().contains("#FF0000")){
Map 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"));
try {
ps=koneksi.prepareStatement(
"select data_triase_igdprimer.keluhan_utama,data_triase_igdprimer.kebutuhan_khusus,data_triase_igdprimer.catatan,"+
"data_triase_igdprimer.plan,data_triase_igdprimer.tanggaltriase,data_triase_igdprimer.nik,data_triase_igd.tekanan_darah,"+
"data_triase_igd.nadi,data_triase_igd.pernapasan,data_triase_igd.suhu,data_triase_igd.saturasi_o2,data_triase_igd.nyeri,"+
"data_triase_igd.no_rawat,pasien.no_rkm_medis,pasien.nm_pasien,pasien.jk,pasien.tgl_lahir,pegawai.nama,data_triase_igd.tgl_kunjungan, "+
"data_triase_igd.cara_masuk,master_triase_macam_kasus.macam_kasus from data_triase_igdprimer inner join data_triase_igd "+
"inner join pasien inner join pegawai inner join reg_periksa inner join master_triase_macam_kasus on "+
"data_triase_igd.no_rawat=data_triase_igdprimer.no_rawat and reg_periksa.no_rawat=data_triase_igd.no_rawat "+
"and reg_periksa.no_rkm_medis=pasien.no_rkm_medis and pegawai.nik=data_triase_igdprimer.nik "+
"and master_triase_macam_kasus.kode_kasus=data_triase_igd.kode_kasus where data_triase_igd.no_rawat=?");
try {
ps.setString(1,tbTriase.getValueAt(tbTriase.getSelectedRow(),0).toString());
rs=ps.executeQuery();
if(rs.next()){
param.put("norawat",rs.getString("no_rawat"));
param.put("norm",rs.getString("no_rkm_medis"));
param.put("namapasien",rs.getString("nm_pasien"));
param.put("tanggallahir",rs.getDate("tgl_lahir"));
param.put("jk",rs.getString("jk").replaceAll("L","Laki-Laki").replaceAll("P","Perempuan"));
param.put("tanggalkunjungan",rs.getDate("tgl_kunjungan"));
param.put("jamkunjungan",rs.getString("tgl_kunjungan").toString().substring(11,19));
param.put("caradatang",rs.getString("cara_masuk"));
param.put("macamkasus",rs.getString("macam_kasus"));
param.put("keluhanutama",rs.getString("keluhan_utama"));
param.put("kebutuhankhusus",rs.getString("kebutuhan_khusus"));
param.put("plan",rs.getString("plan"));
param.put("tanggaltriase",rs.getDate("tanggaltriase"));
param.put("tandavital","Suhu (C) : "+rs.getString("suhu")+", Nyeri : "+rs.getString("nyeri")+", Tensi : "+rs.getString("tekanan_darah")+", Nadi(/menit) : "+rs.getString("nadi")+", Saturasi O²(%) : "+rs.getString("saturasi_o2")+", Respirasi(/menit) : "+rs.getString("pernapasan"));
param.put("jamtriase",rs.getString("tanggaltriase").toString().substring(11,19));
param.put("pegawai",rs.getString("nama"));
param.put("catatan",rs.getString("catatan"));
finger=Sequel.cariIsi("select sha1(sidikjari.sidikjari) from sidikjari inner join pegawai on pegawai.id=sidikjari.id where pegawai.nik=?",rs.getString("nik"));
param.put("finger","Dikeluarkan di "+akses.getnamars()+", Kabupaten/Kota "+akses.getkabupatenrs()+"\nDitandatangani secara elektronik oleh "+rs.getString("nama")+"\nID "+(finger.equals("")?rs.getString("nik"):finger)+"\n"+Valid.SetTgl3(rs.getString("tanggaltriase")));
ps2=koneksi.prepareStatement(
"select master_triase_pemeriksaan.kode_pemeriksaan,master_triase_pemeriksaan.nama_pemeriksaan "+
"from master_triase_pemeriksaan inner join master_triase_skala2 inner join data_triase_igddetail_skala2 "+
"on master_triase_pemeriksaan.kode_pemeriksaan=master_triase_skala2.kode_pemeriksaan and "+
"master_triase_skala2.kode_skala2=data_triase_igddetail_skala2.kode_skala2 where data_triase_igddetail_skala2.no_rawat=? "+
"group by master_triase_pemeriksaan.kode_pemeriksaan order by master_triase_pemeriksaan.kode_pemeriksaan");
try {
Sequel.queryu("delete from temporary where temp37='"+akses.getalamatip()+"'");
ps2.setString(1,rs.getString("no_rawat"));
rs2=ps2.executeQuery();
while(rs2.next()){
datatriase="";
ps3=koneksi.prepareStatement(
"select master_triase_skala2.pengkajian_skala2 from master_triase_skala2 inner join data_triase_igddetail_skala2 "+
"on master_triase_skala2.kode_skala2=data_triase_igddetail_skala2.kode_skala2 where "+
"master_triase_skala2.kode_pemeriksaan=? and data_triase_igddetail_skala2.no_rawat=? "+
"order by data_triase_igddetail_skala2.kode_skala2");
try {
ps3.setString(1,rs2.getString("kode_pemeriksaan"));
ps3.setString(2,rs.getString("no_rawat"));
rs3=ps3.executeQuery();
while(rs3.next()){
datatriase=rs3.getString("pengkajian_skala2")+", "+datatriase;
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
if(ps3!=null){
ps3.close();
}
}
if(datatriase.endsWith(", ")){
datatriase = datatriase.substring(0,datatriase.length() - 2);
}
Sequel.menyimpan2("temporary","'"+i+"','"+rs2.getString("nama_pemeriksaan")+"','"+datatriase+"','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','"+akses.getalamatip()+"'","Transaksi");
i++;
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs2!=null){
rs2.close();
}
if(ps2!=null){
ps2.close();
}
}
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs!=null){
rs.close();
}
if(ps!=null){
ps.close();
}
}
} catch (Exception e) {
System.out.println("Notif : "+e);
}
try {
pilihan = (String)JOptionPane.showInputDialog(null,"Silahkan pilih Lembar/PDF Triase Skala 2..!","Pilihan",JOptionPane.QUESTION_MESSAGE,null,new Object[]{"Lembar Triase Skala 2","PDF Triase Skala 2"},"Lambar Triase Skala 2");
switch (pilihan) {
case "Lembar Triase Skala 2":
Valid.MyReportqry("rptLembarTriaseSkala2.jasper","report","::[ Triase Skala 2 ]::","select * from temporary where temporary.temp37='"+akses.getalamatip()+"' order by temporary.no",param);
break;
case "PDF Triase Skala 2":
Valid.MyReportqrypdf("rptLembarTriaseSkala2.jasper","report","::[ Triase Skala 2 ]::","select * from temporary where temporary.temp37='"+akses.getalamatip()+"' order by temporary.no",param);
break;
}
} catch (Exception e) {
}
}else if(LoadHTML.getText().contains("#C8C800")){
Map 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"));
try {
ps=koneksi.prepareStatement(
"select data_triase_igdsekunder.anamnesa_singkat,data_triase_igdsekunder.catatan,"+
"data_triase_igdsekunder.plan,data_triase_igdsekunder.tanggaltriase,data_triase_igdsekunder.nik,data_triase_igd.tekanan_darah,"+
"data_triase_igd.nadi,data_triase_igd.pernapasan,data_triase_igd.suhu,data_triase_igd.saturasi_o2,data_triase_igd.nyeri,"+
"data_triase_igd.no_rawat,pasien.no_rkm_medis,pasien.nm_pasien,pasien.jk,pasien.tgl_lahir,pegawai.nama,data_triase_igd.tgl_kunjungan, "+
"data_triase_igd.cara_masuk,master_triase_macam_kasus.macam_kasus from data_triase_igdsekunder inner join data_triase_igd "+
"inner join pasien inner join pegawai inner join reg_periksa inner join master_triase_macam_kasus on "+
"data_triase_igd.no_rawat=data_triase_igdsekunder.no_rawat and reg_periksa.no_rawat=data_triase_igd.no_rawat "+
"and reg_periksa.no_rkm_medis=pasien.no_rkm_medis and pegawai.nik=data_triase_igdsekunder.nik "+
"and master_triase_macam_kasus.kode_kasus=data_triase_igd.kode_kasus where data_triase_igd.no_rawat=?");
try {
ps.setString(1,tbTriase.getValueAt(tbTriase.getSelectedRow(),0).toString());
rs=ps.executeQuery();
if(rs.next()){
param.put("norawat",rs.getString("no_rawat"));
param.put("norm",rs.getString("no_rkm_medis"));
param.put("namapasien",rs.getString("nm_pasien"));
param.put("tanggallahir",rs.getDate("tgl_lahir"));
param.put("jk",rs.getString("jk").replaceAll("L","Laki-Laki").replaceAll("P","Perempuan"));
param.put("tanggalkunjungan",rs.getDate("tgl_kunjungan"));
param.put("jamkunjungan",rs.getString("tgl_kunjungan").toString().substring(11,19));
param.put("caradatang",rs.getString("cara_masuk"));
param.put("macamkasus",rs.getString("macam_kasus"));
param.put("keluhanutama",rs.getString("anamnesa_singkat"));
param.put("plan",rs.getString("plan"));
param.put("tanggaltriase",rs.getDate("tanggaltriase"));
param.put("tandavital","Suhu (C) : "+rs.getString("suhu")+", Nyeri : "+rs.getString("nyeri")+", Tensi : "+rs.getString("tekanan_darah")+", Nadi(/menit) : "+rs.getString("nadi")+", Saturasi O²(%) : "+rs.getString("saturasi_o2")+", Respirasi(/menit) : "+rs.getString("pernapasan"));
param.put("jamtriase",rs.getString("tanggaltriase").toString().substring(11,19));
param.put("pegawai",rs.getString("nama"));
param.put("catatan",rs.getString("catatan"));
finger=Sequel.cariIsi("select sha1(sidikjari.sidikjari) from sidikjari inner join pegawai on pegawai.id=sidikjari.id where pegawai.nik=?",rs.getString("nik"));
param.put("finger","Dikeluarkan di "+akses.getnamars()+", Kabupaten/Kota "+akses.getkabupatenrs()+"\nDitandatangani secara elektronik oleh "+rs.getString("nama")+"\nID "+(finger.equals("")?rs.getString("nik"):finger)+"\n"+Valid.SetTgl3(rs.getString("tanggaltriase")));
ps2=koneksi.prepareStatement(
"select master_triase_pemeriksaan.kode_pemeriksaan,master_triase_pemeriksaan.nama_pemeriksaan "+
"from master_triase_pemeriksaan inner join master_triase_skala3 inner join data_triase_igddetail_skala3 "+
"on master_triase_pemeriksaan.kode_pemeriksaan=master_triase_skala3.kode_pemeriksaan and "+
"master_triase_skala3.kode_skala3=data_triase_igddetail_skala3.kode_skala3 where data_triase_igddetail_skala3.no_rawat=? "+
"group by master_triase_pemeriksaan.kode_pemeriksaan order by master_triase_pemeriksaan.kode_pemeriksaan");
try {
Sequel.queryu("delete from temporary where temp37='"+akses.getalamatip()+"'");
ps2.setString(1,rs.getString("no_rawat"));
rs2=ps2.executeQuery();
while(rs2.next()){
datatriase="";
ps3=koneksi.prepareStatement(
"select master_triase_skala3.pengkajian_skala3 from master_triase_skala3 inner join data_triase_igddetail_skala3 "+
"on master_triase_skala3.kode_skala3=data_triase_igddetail_skala3.kode_skala3 where "+
"master_triase_skala3.kode_pemeriksaan=? and data_triase_igddetail_skala3.no_rawat=? "+
"order by data_triase_igddetail_skala3.kode_skala3");
try {
ps3.setString(1,rs2.getString("kode_pemeriksaan"));
ps3.setString(2,rs.getString("no_rawat"));
rs3=ps3.executeQuery();
while(rs3.next()){
datatriase=rs3.getString("pengkajian_skala3")+", "+datatriase;
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
if(ps3!=null){
ps3.close();
}
}
if(datatriase.endsWith(", ")){
datatriase = datatriase.substring(0,datatriase.length() - 2);
}
Sequel.menyimpan2("temporary","'"+i+"','"+rs2.getString("nama_pemeriksaan")+"','"+datatriase+"','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','"+akses.getalamatip()+"'","Transaksi");
i++;
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs2!=null){
rs2.close();
}
if(ps2!=null){
ps2.close();
}
}
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs!=null){
rs.close();
}
if(ps!=null){
ps.close();
}
}
} catch (Exception e) {
System.out.println("Notif : "+e);
}
try {
pilihan = (String)JOptionPane.showInputDialog(null,"Silahkan pilih Lembar/PDF Triase Skala 3..!","Pilihan",JOptionPane.QUESTION_MESSAGE,null,new Object[]{"Lembar Triase Skala 3","PDF Triase Skala 3"},"Lembar Triase Skala 3");
switch (pilihan) {
case "Lembar Triase Skala 3":
Valid.MyReportqry("rptLembarTriaseSkala3.jasper","report","::[ Triase Skala 3 ]::","select * from temporary where temporary.temp37='"+akses.getalamatip()+"' order by temporary.no",param);
break;
case "PDF Triase Skala 3":
Valid.MyReportqrypdf("rptLembarTriaseSkala3.jasper","report","::[ Triase Skala 3 ]::","select * from temporary where temporary.temp37='"+akses.getalamatip()+"' order by temporary.no",param);
break;
}
} catch (Exception e) {
}
}else if(LoadHTML.getText().contains("#00AA00")){
Map 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"));
try {
ps=koneksi.prepareStatement(
"select data_triase_igdsekunder.anamnesa_singkat,data_triase_igdsekunder.catatan,"+
"data_triase_igdsekunder.plan,data_triase_igdsekunder.tanggaltriase,data_triase_igdsekunder.nik,data_triase_igd.tekanan_darah,"+
"data_triase_igd.nadi,data_triase_igd.pernapasan,data_triase_igd.suhu,data_triase_igd.saturasi_o2,data_triase_igd.nyeri,"+
"data_triase_igd.no_rawat,pasien.no_rkm_medis,pasien.nm_pasien,pasien.jk,pasien.tgl_lahir,pegawai.nama,data_triase_igd.tgl_kunjungan, "+
"data_triase_igd.cara_masuk,master_triase_macam_kasus.macam_kasus from data_triase_igdsekunder inner join data_triase_igd "+
"inner join pasien inner join pegawai inner join reg_periksa inner join master_triase_macam_kasus on "+
"data_triase_igd.no_rawat=data_triase_igdsekunder.no_rawat and reg_periksa.no_rawat=data_triase_igd.no_rawat "+
"and reg_periksa.no_rkm_medis=pasien.no_rkm_medis and pegawai.nik=data_triase_igdsekunder.nik "+
"and master_triase_macam_kasus.kode_kasus=data_triase_igd.kode_kasus where data_triase_igd.no_rawat=?");
try {
ps.setString(1,tbTriase.getValueAt(tbTriase.getSelectedRow(),0).toString());
rs=ps.executeQuery();
if(rs.next()){
param.put("norawat",rs.getString("no_rawat"));
param.put("norm",rs.getString("no_rkm_medis"));
param.put("namapasien",rs.getString("nm_pasien"));
param.put("tanggallahir",rs.getDate("tgl_lahir"));
param.put("jk",rs.getString("jk").replaceAll("L","Laki-Laki").replaceAll("P","Perempuan"));
param.put("tanggalkunjungan",rs.getDate("tgl_kunjungan"));
param.put("jamkunjungan",rs.getString("tgl_kunjungan").toString().substring(11,19));
param.put("caradatang",rs.getString("cara_masuk"));
param.put("macamkasus",rs.getString("macam_kasus"));
param.put("keluhanutama",rs.getString("anamnesa_singkat"));
param.put("plan",rs.getString("plan"));
param.put("tanggaltriase",rs.getDate("tanggaltriase"));
param.put("tandavital","Suhu (C) : "+rs.getString("suhu")+", Nyeri : "+rs.getString("nyeri")+", Tensi : "+rs.getString("tekanan_darah")+", Nadi(/menit) : "+rs.getString("nadi")+", Saturasi O²(%) : "+rs.getString("saturasi_o2")+", Respirasi(/menit) : "+rs.getString("pernapasan"));
param.put("jamtriase",rs.getString("tanggaltriase").toString().substring(11,19));
param.put("pegawai",rs.getString("nama"));
param.put("catatan",rs.getString("catatan"));
finger=Sequel.cariIsi("select sha1(sidikjari.sidikjari) from sidikjari inner join pegawai on pegawai.id=sidikjari.id where pegawai.nik=?",rs.getString("nik"));
param.put("finger","Dikeluarkan di "+akses.getnamars()+", Kabupaten/Kota "+akses.getkabupatenrs()+"\nDitandatangani secara elektronik oleh "+rs.getString("nama")+"\nID "+(finger.equals("")?rs.getString("nik"):finger)+"\n"+Valid.SetTgl3(rs.getString("tanggaltriase")));
ps2=koneksi.prepareStatement(
"select master_triase_pemeriksaan.kode_pemeriksaan,master_triase_pemeriksaan.nama_pemeriksaan "+
"from master_triase_pemeriksaan inner join master_triase_skala4 inner join data_triase_igddetail_skala4 "+
"on master_triase_pemeriksaan.kode_pemeriksaan=master_triase_skala4.kode_pemeriksaan and "+
"master_triase_skala4.kode_skala4=data_triase_igddetail_skala4.kode_skala4 where data_triase_igddetail_skala4.no_rawat=? "+
"group by master_triase_pemeriksaan.kode_pemeriksaan order by master_triase_pemeriksaan.kode_pemeriksaan");
try {
Sequel.queryu("delete from temporary where temp37='"+akses.getalamatip()+"'");
ps2.setString(1,rs.getString("no_rawat"));
rs2=ps2.executeQuery();
while(rs2.next()){
datatriase="";
ps3=koneksi.prepareStatement(
"select master_triase_skala4.pengkajian_skala4 from master_triase_skala4 inner join data_triase_igddetail_skala4 "+
"on master_triase_skala4.kode_skala4=data_triase_igddetail_skala4.kode_skala4 where "+
"master_triase_skala4.kode_pemeriksaan=? and data_triase_igddetail_skala4.no_rawat=? "+
"order by data_triase_igddetail_skala4.kode_skala4");
try {
ps3.setString(1,rs2.getString("kode_pemeriksaan"));
ps3.setString(2,rs.getString("no_rawat"));
rs3=ps3.executeQuery();
while(rs3.next()){
datatriase=rs3.getString("pengkajian_skala4")+", "+datatriase;
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
if(ps3!=null){
ps3.close();
}
}
if(datatriase.endsWith(", ")){
datatriase = datatriase.substring(0,datatriase.length() - 2);
}
Sequel.menyimpan2("temporary","'"+i+"','"+rs2.getString("nama_pemeriksaan")+"','"+datatriase+"','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','"+akses.getalamatip()+"'","Transaksi");
i++;
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs2!=null){
rs2.close();
}
if(ps2!=null){
ps2.close();
}
}
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs!=null){
rs.close();
}
if(ps!=null){
ps.close();
}
}
} catch (Exception e) {
System.out.println("Notif : "+e);
}
try {
pilihan = (String)JOptionPane.showInputDialog(null,"Silahkan pilih Lembar/PDF Triase Skala 4..!","Pilihan",JOptionPane.QUESTION_MESSAGE,null,new Object[]{"Lembar Triase Skala 4","PDF Triase Skala 4"},"Lembar Triase Skala 4");
switch (pilihan) {
case "Lembar Triase Skala 4":
Valid.MyReportqry("rptLembarTriaseSkala4.jasper","report","::[ Triase Skala 4 ]::","select * from temporary where temporary.temp37='"+akses.getalamatip()+"' order by temporary.no",param);
break;
case "PDF Triase Skala 4":
Valid.MyReportqrypdf("rptLembarTriaseSkala4.jasper","report","::[ Triase Skala 4 ]::","select * from temporary where temporary.temp37='"+akses.getalamatip()+"' order by temporary.no",param);
break;
}
} catch (Exception e) {
}
}else if(LoadHTML.getText().contains("#969696")){
Map 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"));
try {
ps=koneksi.prepareStatement(
"select data_triase_igdsekunder.anamnesa_singkat,data_triase_igdsekunder.catatan,"+
"data_triase_igdsekunder.plan,data_triase_igdsekunder.tanggaltriase,data_triase_igdsekunder.nik,data_triase_igd.tekanan_darah,"+
"data_triase_igd.nadi,data_triase_igd.pernapasan,data_triase_igd.suhu,data_triase_igd.saturasi_o2,data_triase_igd.nyeri,"+
"data_triase_igd.no_rawat,pasien.no_rkm_medis,pasien.nm_pasien,pasien.jk,pasien.tgl_lahir,pegawai.nama,data_triase_igd.tgl_kunjungan, "+
"data_triase_igd.cara_masuk,master_triase_macam_kasus.macam_kasus from data_triase_igdsekunder inner join data_triase_igd "+
"inner join pasien inner join pegawai inner join reg_periksa inner join master_triase_macam_kasus on "+
"data_triase_igd.no_rawat=data_triase_igdsekunder.no_rawat and reg_periksa.no_rawat=data_triase_igd.no_rawat "+
"and reg_periksa.no_rkm_medis=pasien.no_rkm_medis and pegawai.nik=data_triase_igdsekunder.nik "+
"and master_triase_macam_kasus.kode_kasus=data_triase_igd.kode_kasus where data_triase_igd.no_rawat=?");
try {
ps.setString(1,tbTriase.getValueAt(tbTriase.getSelectedRow(),0).toString());
rs=ps.executeQuery();
if(rs.next()){
param.put("norawat",rs.getString("no_rawat"));
param.put("norm",rs.getString("no_rkm_medis"));
param.put("namapasien",rs.getString("nm_pasien"));
param.put("tanggallahir",rs.getDate("tgl_lahir"));
param.put("jk",rs.getString("jk").replaceAll("L","Laki-Laki").replaceAll("P","Perempuan"));
param.put("tanggalkunjungan",rs.getDate("tgl_kunjungan"));
param.put("jamkunjungan",rs.getString("tgl_kunjungan").toString().substring(11,19));
param.put("caradatang",rs.getString("cara_masuk"));
param.put("macamkasus",rs.getString("macam_kasus"));
param.put("keluhanutama",rs.getString("anamnesa_singkat"));
param.put("plan",rs.getString("plan"));
param.put("tanggaltriase",rs.getDate("tanggaltriase"));
param.put("tandavital","Suhu (C) : "+rs.getString("suhu")+", Nyeri : "+rs.getString("nyeri")+", Tensi : "+rs.getString("tekanan_darah")+", Nadi(/menit) : "+rs.getString("nadi")+", Saturasi O²(%) : "+rs.getString("saturasi_o2")+", Respirasi(/menit) : "+rs.getString("pernapasan"));
param.put("jamtriase",rs.getString("tanggaltriase").toString().substring(11,19));
param.put("pegawai",rs.getString("nama"));
param.put("catatan",rs.getString("catatan"));
finger=Sequel.cariIsi("select sha1(sidikjari.sidikjari) from sidikjari inner join pegawai on pegawai.id=sidikjari.id where pegawai.nik=?",rs.getString("nik"));
param.put("finger","Dikeluarkan di "+akses.getnamars()+", Kabupaten/Kota "+akses.getkabupatenrs()+"\nDitandatangani secara elektronik oleh "+rs.getString("nama")+"\nID "+(finger.equals("")?rs.getString("nik"):finger)+"\n"+Valid.SetTgl3(rs.getString("tanggaltriase")));
ps2=koneksi.prepareStatement(
"select master_triase_pemeriksaan.kode_pemeriksaan,master_triase_pemeriksaan.nama_pemeriksaan "+
"from master_triase_pemeriksaan inner join master_triase_skala5 inner join data_triase_igddetail_skala5 "+
"on master_triase_pemeriksaan.kode_pemeriksaan=master_triase_skala5.kode_pemeriksaan and "+
"master_triase_skala5.kode_skala5=data_triase_igddetail_skala5.kode_skala5 where data_triase_igddetail_skala5.no_rawat=? "+
"group by master_triase_pemeriksaan.kode_pemeriksaan order by master_triase_pemeriksaan.kode_pemeriksaan");
try {
Sequel.queryu("delete from temporary where temp37='"+akses.getalamatip()+"'");
ps2.setString(1,rs.getString("no_rawat"));
rs2=ps2.executeQuery();
while(rs2.next()){
datatriase="";
ps3=koneksi.prepareStatement(
"select master_triase_skala5.pengkajian_skala5 from master_triase_skala5 inner join data_triase_igddetail_skala5 "+
"on master_triase_skala5.kode_skala5=data_triase_igddetail_skala5.kode_skala5 where "+
"master_triase_skala5.kode_pemeriksaan=? and data_triase_igddetail_skala5.no_rawat=? "+
"order by data_triase_igddetail_skala5.kode_skala5");
try {
ps3.setString(1,rs2.getString("kode_pemeriksaan"));
ps3.setString(2,rs.getString("no_rawat"));
rs3=ps3.executeQuery();
while(rs3.next()){
datatriase=rs3.getString("pengkajian_skala5")+", "+datatriase;
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
if(ps3!=null){
ps3.close();
}
}
if(datatriase.endsWith(", ")){
datatriase = datatriase.substring(0,datatriase.length() - 2);
}
Sequel.menyimpan2("temporary","'"+i+"','"+rs2.getString("nama_pemeriksaan")+"','"+datatriase+"','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','"+akses.getalamatip()+"'","Transaksi");
i++;
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs2!=null){
rs2.close();
}
if(ps2!=null){
ps2.close();
}
}
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs!=null){
rs.close();
}
if(ps!=null){
ps.close();
}
}
} catch (Exception e) {
System.out.println("Notif : "+e);
}
try {
pilihan = (String)JOptionPane.showInputDialog(null,"Silahkan pilih Lembar/PDF Triase Skala 5..!","Pilihan",JOptionPane.QUESTION_MESSAGE,null,new Object[]{"Lembar Triase Skala 5","PDF Triase Skala 5"},"Lembar Triase Skala 5");
switch (pilihan) {
case "Lembar Triase Skala 5":
Valid.MyReportqry("rptLembarTriaseSkala5.jasper","report","::[ Triase Skala 5 ]::","select * from temporary where temporary.temp37='"+akses.getalamatip()+"' order by temporary.no",param);
break;
case "PDF Triase Skala 5":
Valid.MyReportqry("rptLembarTriaseSkala5.jasper","report","::[ Triase Skala 5 ]::","select * from temporary where temporary.temp37='"+akses.getalamatip()+"' order by temporary.no",param);
break;
}
} catch (Exception e) {
}
}
this.setCursor(Cursor.getDefaultCursor());
}else{
JOptionPane.showMessageDialog(null,"Silahkan pilih terlebih dahulu data yang mau dicetak data personal triasenya..!!!");
}
}
}//GEN-LAST:event_BtnPrint1ActionPerformed
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(() -> {
RMTriaseIGD dialog = new RMTriaseIGD(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.ComboBox AlasanKedatangan;
private widget.Button BtnAll;
private widget.Button BtnBatal;
private widget.Button BtnCari;
private widget.Button BtnCariPemeriksaan;
private widget.Button BtnCariPemeriksaan1;
private widget.Button BtnCariSkala1;
private widget.Button BtnCariSkala2;
private widget.Button BtnEdit;
private widget.Button BtnHapus;
private widget.Button BtnKeluar;
private widget.Button BtnPrint;
private widget.Button BtnPrint1;
private widget.Button BtnSimpan;
private widget.Button BtnTambahPemeriksaan;
private widget.Button BtnTambahPemeriksaan1;
private widget.Button BtnTambahSkala1;
private widget.Button BtnTambahSkala2;
private widget.ComboBox CaraMasuk;
private widget.CekBox ChkAccor;
private widget.Tanggal DTPCari1;
private widget.Tanggal DTPCari2;
private widget.PanelBiasa FormInput;
private widget.PanelBiasa FormMenu;
private widget.InternalFrame FormTriase;
private widget.TextBox KdKasus;
private widget.TextBox KeteranganKedatangan;
private widget.Label LCount;
private widget.editorpane LoadHTML;
private widget.editorpane LoadHTML2;
private widget.TextBox NmKasus;
private widget.PanelBiasa PanelAccor;
private widget.TextBox PrimerCatatan;
private widget.TextArea PrimerKeluhanUtama;
private widget.TextBox PrimerKodePetugas;
private widget.RadioButton PrimerKritis;
private widget.ComboBox PrimerKubutuhanKusus;
private widget.TextBox PrimerNadi;
private widget.TextBox PrimerNamaPetugas;
private widget.TextBox PrimerNyeri;
private widget.TextBox PrimerRespirasi;
private widget.RadioButton PrimerResusitasi;
private widget.TextBox PrimerSaturasi;
private widget.TextBox PrimerSuhu;
private widget.Tanggal PrimerTanggalTriase;
private widget.TextBox PrimerTensi;
private widget.ScrollPane Scroll;
private widget.ScrollPane Scroll2;
private widget.ScrollPane Scroll3;
private widget.ScrollPane Scroll4;
private widget.ScrollPane Scroll5;
private widget.ScrollPane Scroll6;
private widget.ScrollPane Scroll7;
private widget.ScrollPane Scroll8;
private widget.ScrollPane ScrollHTML;
private widget.ScrollPane ScrollTriase;
private widget.TextArea SekunderAnamnesa;
private widget.TextBox SekunderCatatan;
private widget.TextBox SekunderKodePetugas;
private widget.TextBox SekunderNadi;
private widget.TextBox SekunderNamaPetugas;
private widget.TextBox SekunderNyeri;
private widget.TextBox SekunderRespirasi;
private widget.TextBox SekunderSaturasi;
private widget.TextBox SekunderSuhu;
private widget.Tanggal SekunderTanggalTriase;
private widget.TextBox SekunderTensi;
private widget.RadioButton SekunderZonaHijau;
private widget.RadioButton SekunderZonaKuning;
private widget.TextBox TCari;
private widget.TextBox TCariPemeriksaan;
private widget.TextBox TCariPemeriksaan2;
private widget.TextBox TCariSkala1;
private widget.TextBox TCariSkala3;
private widget.TextBox TNoRM;
private widget.TextBox TNoRM1;
private widget.TextBox TNoRw;
private widget.TextBox TPasien;
private widget.TextBox TPasien1;
private javax.swing.JTabbedPane TabPilihan;
private javax.swing.JTabbedPane TabSkala1dan2;
private javax.swing.JTabbedPane TabSkala3dan4dan5;
private javax.swing.JTabbedPane TabTriase;
private widget.Tanggal TanggalKunjungan;
private widget.ComboBox Transportasi;
private widget.Button btnKasus;
private widget.Button btnPrimerPetugas;
private widget.Button btnSekunderPetugas;
private javax.swing.ButtonGroup buttonGroup1;
private widget.InternalFrame internalFrame1;
private widget.InternalFrame internalFrame10;
private widget.InternalFrame internalFrame11;
private widget.InternalFrame internalFrame12;
private widget.InternalFrame internalFrame13;
private widget.InternalFrame internalFrame14;
private widget.InternalFrame internalFrame3;
private widget.InternalFrame internalFrame4;
private widget.InternalFrame internalFrame5;
private widget.InternalFrame internalFrame7;
private widget.InternalFrame internalFrame8;
private widget.InternalFrame internalFrame9;
private widget.Label jLabel10;
private widget.Label jLabel11;
private widget.Label jLabel12;
private widget.Label jLabel13;
private widget.Label jLabel14;
private widget.Label jLabel15;
private widget.Label jLabel16;
private widget.Label jLabel17;
private widget.Label jLabel18;
private widget.Label jLabel19;
private widget.Label jLabel20;
private widget.Label jLabel21;
private widget.Label jLabel22;
private widget.Label jLabel23;
private widget.Label jLabel24;
private widget.Label jLabel25;
private widget.Label jLabel26;
private widget.Label jLabel27;
private widget.Label jLabel28;
private widget.Label jLabel29;
private widget.Label jLabel30;
private widget.Label jLabel31;
private widget.Label jLabel32;
private widget.Label jLabel33;
private widget.Label jLabel34;
private widget.Label jLabel37;
private widget.Label jLabel38;
private widget.Label jLabel4;
private widget.Label jLabel5;
private widget.Label jLabel6;
private widget.Label jLabel7;
private widget.Label jLabel8;
private widget.Label jLabel9;
private javax.swing.JPanel jPanel3;
private javax.swing.JPanel jPanel4;
private javax.swing.JPanel jPanel5;
private javax.swing.JPanel jPanel6;
private widget.Label label10;
private widget.Label label11;
private widget.Label label12;
private widget.Label label13;
private widget.Label label14;
private widget.Label label15;
private widget.panelisi panelGlass8;
private widget.panelisi panelGlass9;
private widget.panelisi panelisi5;
private widget.panelisi panelisi6;
private widget.panelisi panelisi7;
private widget.panelisi panelisi8;
private widget.ScrollPane scrollPane1;
private widget.ScrollPane scrollPane2;
private widget.Table tbPemeriksaan;
private widget.Table tbPemeriksaan2;
private widget.Table tbSkala1;
private widget.Table tbSkala2;
private widget.Table tbSkala3;
private widget.Table tbSkala4;
private widget.Table tbSkala5;
private widget.Table tbTriase;
// End of variables declaration//GEN-END:variables
public void tampil() {
Valid.tabelKosong(tabMode);
try{
ps=koneksi.prepareStatement(
"select reg_periksa.no_rawat,pasien.no_rkm_medis,pasien.nm_pasien,data_triase_igd.tgl_kunjungan,"+
"data_triase_igd.cara_masuk,data_triase_igd.alat_transportasi,data_triase_igd.alasan_kedatangan,"+
"data_triase_igd.keterangan_kedatangan,data_triase_igd.kode_kasus,master_triase_macam_kasus.macam_kasus "+
"from reg_periksa inner join pasien inner join data_triase_igd inner join master_triase_macam_kasus "+
"on reg_periksa.no_rkm_medis=pasien.no_rkm_medis and reg_periksa.no_rawat=data_triase_igd.no_rawat "+
"and data_triase_igd.kode_kasus=master_triase_macam_kasus.kode_kasus "+
"where data_triase_igd.tgl_kunjungan between ? and ? and reg_periksa.no_rawat like ? or "+
"data_triase_igd.tgl_kunjungan between ? and ? and pasien.no_rkm_medis like ? or "+
"data_triase_igd.tgl_kunjungan between ? and ? and pasien.nm_pasien like ? or "+
"data_triase_igd.tgl_kunjungan between ? and ? and data_triase_igd.cara_masuk like ? or "+
"data_triase_igd.tgl_kunjungan between ? and ? and data_triase_igd.alat_transportasi like ? or "+
"data_triase_igd.tgl_kunjungan between ? and ? and data_triase_igd.alasan_kedatangan like ? or "+
"data_triase_igd.tgl_kunjungan between ? and ? and data_triase_igd.keterangan_kedatangan like ? or "+
"data_triase_igd.tgl_kunjungan between ? and ? and master_triase_macam_kasus.macam_kasus like ? order by data_triase_igd.tgl_kunjungan");
try {
ps.setString(1,Valid.SetTgl(DTPCari1.getSelectedItem()+"")+" 00:00:00");
ps.setString(2,Valid.SetTgl(DTPCari2.getSelectedItem()+"")+" 23:59:59");
ps.setString(3,"%"+TCari.getText().trim()+"%");
ps.setString(4,Valid.SetTgl(DTPCari1.getSelectedItem()+"")+" 00:00:00");
ps.setString(5,Valid.SetTgl(DTPCari2.getSelectedItem()+"")+" 23:59:59");
ps.setString(6,"%"+TCari.getText().trim()+"%");
ps.setString(7,Valid.SetTgl(DTPCari1.getSelectedItem()+"")+" 00:00:00");
ps.setString(8,Valid.SetTgl(DTPCari2.getSelectedItem()+"")+" 23:59:59");
ps.setString(9,"%"+TCari.getText().trim()+"%");
ps.setString(10,Valid.SetTgl(DTPCari1.getSelectedItem()+"")+" 00:00:00");
ps.setString(11,Valid.SetTgl(DTPCari2.getSelectedItem()+"")+" 23:59:59");
ps.setString(12,"%"+TCari.getText().trim()+"%");
ps.setString(13,Valid.SetTgl(DTPCari1.getSelectedItem()+"")+" 00:00:00");
ps.setString(14,Valid.SetTgl(DTPCari2.getSelectedItem()+"")+" 23:59:59");
ps.setString(15,"%"+TCari.getText().trim()+"%");
ps.setString(16,Valid.SetTgl(DTPCari1.getSelectedItem()+"")+" 00:00:00");
ps.setString(17,Valid.SetTgl(DTPCari2.getSelectedItem()+"")+" 23:59:59");
ps.setString(18,"%"+TCari.getText().trim()+"%");
ps.setString(19,Valid.SetTgl(DTPCari1.getSelectedItem()+"")+" 00:00:00");
ps.setString(20,Valid.SetTgl(DTPCari2.getSelectedItem()+"")+" 23:59:59");
ps.setString(21,"%"+TCari.getText().trim()+"%");
ps.setString(22,Valid.SetTgl(DTPCari1.getSelectedItem()+"")+" 00:00:00");
ps.setString(23,Valid.SetTgl(DTPCari2.getSelectedItem()+"")+" 23:59:59");
ps.setString(24,"%"+TCari.getText().trim()+"%");
rs=ps.executeQuery();
while(rs.next()){
tabMode.addRow(new Object[]{
rs.getString("no_rawat"),rs.getString("no_rkm_medis"),rs.getString("nm_pasien"),rs.getString("tgl_kunjungan"),
rs.getString("cara_masuk"),rs.getString("alat_transportasi"),rs.getString("alasan_kedatangan"),
rs.getString("keterangan_kedatangan"),rs.getString("kode_kasus"),rs.getString("macam_kasus")
});
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs!=null){
rs.close();
}
if(ps!=null){
ps.close();
}
}
}catch(Exception e){
System.out.println("Notifikasi : "+e);
}
LCount.setText(""+tabMode.getRowCount());
}
private void emptTeks(){
TNoRw.setText("");
TPasien.setText("");
TNoRM.setText("");
Transportasi.setSelectedIndex(0);
TanggalKunjungan.setDate(new Date());
AlasanKedatangan.setSelectedIndex(0);
KdKasus.setText("");
NmKasus.setText("");
CaraMasuk.setSelectedIndex(0);
KeteranganKedatangan.setText("");
PrimerKeluhanUtama.setText("");
PrimerSuhu.setText("");
PrimerNyeri.setText("");
PrimerTensi.setText("");
PrimerNadi.setText("");
PrimerSaturasi.setText("");
PrimerRespirasi.setText("");
PrimerKubutuhanKusus.setSelectedIndex(0);
PrimerCatatan.setText("");
PrimerTanggalTriase.setDate(new Date());
SekunderAnamnesa.setText("");
SekunderSuhu.setText("");
SekunderNyeri.setText("");
SekunderSaturasi.setText("");
SekunderRespirasi.setText("");
SekunderTensi.setText("");
SekunderNadi.setText("");
SekunderCatatan.setText("");
SekunderTanggalTriase.setDate(new Date());
TabPilihan.setSelectedIndex(0);
TabTriase.setSelectedIndex(0);
Transportasi.requestFocus();
jmlskala1=0;jmlskala2=0;jmlskala3=0;jmlskala4=0;jmlskala5=0;
kodepetugas="";
}
public void setNoRm(String norwt,String norm,String namapasien) {
emptTeks();
TNoRw.setText(norwt);
TNoRM.setText(norm);
TPasien.setText(namapasien);
TCari.setText(norwt);
}
public void tampilPemeriksaan() {
Valid.tabelKosong(tabModePemeriksaan);
try{
ps=koneksi.prepareStatement("select * from master_triase_pemeriksaan where kode_pemeriksaan like ? or nama_pemeriksaan like ? order by kode_pemeriksaan");
try {
ps.setString(1,"%"+TCariPemeriksaan.getText().trim()+"%");
ps.setString(2,"%"+TCariPemeriksaan.getText().trim()+"%");
rs=ps.executeQuery();
while(rs.next()){
tabModePemeriksaan.addRow(new Object[]{rs.getString(1),rs.getString(2)});
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs!=null){
rs.close();
}
if(ps!=null){
ps.close();
}
}
}catch(Exception e){
System.out.println("Notifikasi : "+e);
}
}
public void tampilPemeriksaan2() {
Valid.tabelKosong(tabModePemeriksaan2);
try{
ps=koneksi.prepareStatement("select * from master_triase_pemeriksaan where kode_pemeriksaan like ? or nama_pemeriksaan like ? order by kode_pemeriksaan");
try {
ps.setString(1,"%"+TCariPemeriksaan2.getText().trim()+"%");
ps.setString(2,"%"+TCariPemeriksaan2.getText().trim()+"%");
rs=ps.executeQuery();
while(rs.next()){
tabModePemeriksaan2.addRow(new Object[]{rs.getString(1),rs.getString(2)});
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs!=null){
rs.close();
}
if(ps!=null){
ps.close();
}
}
}catch(Exception e){
System.out.println("Notifikasi : "+e);
}
}
private void tampilskala1() {
if(tbPemeriksaan.getSelectedRow()!= -1){
try{
jml=0;
for(i=0;i=1){
btnPrimerPetugas.setEnabled(false);
btnSekunderPetugas.setEnabled(false);
PrimerKodePetugas.setText(akses.getkode());
SekunderKodePetugas.setText(akses.getkode());
PrimerNamaPetugas.setText(pegawai.tampil3(akses.getkode()));
SekunderNamaPetugas.setText(PrimerNamaPetugas.getText());
}
}
private void getData() {
if(tbTriase.getSelectedRow()!= -1){
try {
TNoRM1.setText(tbTriase.getValueAt(tbTriase.getSelectedRow(),1).toString());
TPasien1.setText(tbTriase.getValueAt(tbTriase.getSelectedRow(),2).toString());
ps=koneksi.prepareStatement(
"select data_triase_igdprimer.keluhan_utama,data_triase_igdprimer.kebutuhan_khusus,data_triase_igdprimer.catatan,"+
"data_triase_igdprimer.plan,data_triase_igdprimer.tanggaltriase,data_triase_igdprimer.nik,data_triase_igd.tekanan_darah,"+
"data_triase_igd.nadi,data_triase_igd.pernapasan,data_triase_igd.suhu,data_triase_igd.saturasi_o2,data_triase_igd.nyeri,"+
"data_triase_igd.no_rawat from data_triase_igdprimer inner join data_triase_igd on data_triase_igd.no_rawat="+
"data_triase_igdprimer.no_rawat where data_triase_igd.no_rawat=?");
try {
ps.setString(1,tbTriase.getValueAt(tbTriase.getSelectedRow(),0).toString());
rs=ps.executeQuery();
if(rs.next()){
kodepetugas=rs.getString("nik");
htmlContent = new StringBuilder();
htmlContent.append(
""+
"| Keterangan | "+
"Triase Primer | "+
"
"+
""+
"| Keluhan Utama | "+
""+rs.getString("keluhan_utama").replaceAll("(\r\n|\r|\n|\n\r)","
")+" | "+
"
"+
""+
"| Tanda Vital | "+
"Suhu (C) : "+rs.getString("suhu")+", Nyeri : "+rs.getString("nyeri")+", Tensi : "+rs.getString("tekanan_darah")+", Nadi(/menit) : "+rs.getString("nadi")+", Saturasi O²(%) : "+rs.getString("saturasi_o2")+", Respirasi(/menit) : "+rs.getString("pernapasan")+" | "+
"
"+
""+
"| Kebutuhan Khusus | "+
""+rs.getString("kebutuhan_khusus")+" | "+
"
"
);
ps2=koneksi.prepareStatement(
"select master_triase_pemeriksaan.kode_pemeriksaan,master_triase_pemeriksaan.nama_pemeriksaan "+
"from master_triase_pemeriksaan inner join master_triase_skala1 inner join data_triase_igddetail_skala1 "+
"on master_triase_pemeriksaan.kode_pemeriksaan=master_triase_skala1.kode_pemeriksaan and "+
"master_triase_skala1.kode_skala1=data_triase_igddetail_skala1.kode_skala1 where data_triase_igddetail_skala1.no_rawat=? "+
"group by master_triase_pemeriksaan.kode_pemeriksaan order by master_triase_pemeriksaan.kode_pemeriksaan");
try {
ps2.setString(1,rs.getString("no_rawat"));
rs2=ps2.executeQuery();
if(rs2.next()){
htmlContent.append(
""+
"| Pemeriksaan | "+
"Immediate/Segera | "+
"
");
rs2.beforeFirst();
while(rs2.next()){
htmlContent.append(
""+
"| "+rs2.getString("nama_pemeriksaan")+" | "+
""+
""
);
ps3=koneksi.prepareStatement(
"select master_triase_skala1.pengkajian_skala1 from master_triase_skala1 inner join data_triase_igddetail_skala1 "+
"on master_triase_skala1.kode_skala1=data_triase_igddetail_skala1.kode_skala1 where "+
"master_triase_skala1.kode_pemeriksaan=? and data_triase_igddetail_skala1.no_rawat=? "+
"order by data_triase_igddetail_skala1.kode_skala1");
try {
ps3.setString(1,rs2.getString("kode_pemeriksaan"));
ps3.setString(2,rs.getString("no_rawat"));
rs3=ps3.executeQuery();
while(rs3.next()){
htmlContent.append(
""+
"| "+rs3.getString("pengkajian_skala1")+" | "+
" "
);
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
if(ps3!=null){
ps3.close();
}
}
htmlContent.append(
" "+
" | "+
"
"
);
}
keputusan="#AA0000";
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs2!=null){
rs2.close();
}
if(ps2!=null){
ps2.close();
}
}
ps2=koneksi.prepareStatement(
"select master_triase_pemeriksaan.kode_pemeriksaan,master_triase_pemeriksaan.nama_pemeriksaan "+
"from master_triase_pemeriksaan inner join master_triase_skala2 inner join data_triase_igddetail_skala2 "+
"on master_triase_pemeriksaan.kode_pemeriksaan=master_triase_skala2.kode_pemeriksaan and "+
"master_triase_skala2.kode_skala2=data_triase_igddetail_skala2.kode_skala2 where data_triase_igddetail_skala2.no_rawat=? "+
"group by master_triase_pemeriksaan.kode_pemeriksaan order by master_triase_pemeriksaan.kode_pemeriksaan");
try {
ps2.setString(1,rs.getString("no_rawat"));
rs2=ps2.executeQuery();
if(rs2.next()){
htmlContent.append(
""+
"| Pemeriksaan | "+
"Emergensi | "+
"
");
rs2.beforeFirst();
while(rs2.next()){
htmlContent.append(
""+
"| "+rs2.getString("nama_pemeriksaan")+" | "+
""+
""
);
ps3=koneksi.prepareStatement(
"select master_triase_skala2.pengkajian_skala2 from master_triase_skala2 inner join data_triase_igddetail_skala2 "+
"on master_triase_skala2.kode_skala2=data_triase_igddetail_skala2.kode_skala2 where "+
"master_triase_skala2.kode_pemeriksaan=? and data_triase_igddetail_skala2.no_rawat=? "+
"order by data_triase_igddetail_skala2.kode_skala2");
try {
ps3.setString(1,rs2.getString("kode_pemeriksaan"));
ps3.setString(2,rs.getString("no_rawat"));
rs3=ps3.executeQuery();
while(rs3.next()){
htmlContent.append(
""+
"| "+rs3.getString("pengkajian_skala2")+" | "+
" "
);
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
if(ps3!=null){
ps3.close();
}
}
htmlContent.append(
" "+
" | "+
"
"
);
}
keputusan="#FF0000";
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs2!=null){
rs2.close();
}
if(ps2!=null){
ps2.close();
}
}
htmlContent.append(
""+
"| Plan/Keputusan | "+
"Zona Merah "+rs.getString("plan")+" | "+
"
"+
""+
"| | "+
"Dokter/Petugas Triase | "+
"
"+
""+
"| Tanggal & Jam | "+
""+rs.getString("tanggaltriase")+" | "+
"
"+
""+
"| Catatan | "+
""+rs.getString("catatan")+" | "+
"
"+
""+
"| Nama Dokter/Petugas | "+
""+rs.getString("nik")+" "+Sequel.cariIsi("select pegawai.nama from pegawai where pegawai.nik=?",rs.getString("nik"))+" | "+
"
"
);
LoadHTML.setText(
""+
""+
"");
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
} finally{
if(rs!=null){
rs.close();
}
if(ps!=null){
ps.close();
}
}
ps=koneksi.prepareStatement(
"select data_triase_igdsekunder.anamnesa_singkat,data_triase_igdsekunder.catatan,"+
"data_triase_igdsekunder.plan,data_triase_igdsekunder.tanggaltriase,data_triase_igdsekunder.nik,data_triase_igd.tekanan_darah,"+
"data_triase_igd.nadi,data_triase_igd.pernapasan,data_triase_igd.suhu,data_triase_igd.saturasi_o2,data_triase_igd.nyeri,"+
"data_triase_igd.no_rawat from data_triase_igdsekunder inner join data_triase_igd on data_triase_igd.no_rawat="+
"data_triase_igdsekunder.no_rawat where data_triase_igd.no_rawat=?");
try {
ps.setString(1,tbTriase.getValueAt(tbTriase.getSelectedRow(),0).toString());
rs=ps.executeQuery();
if(rs.next()){
kodepetugas=rs.getString("nik");
htmlContent = new StringBuilder();
htmlContent.append(
""+
"| Keterangan | "+
"Triase Sekunder | "+
"
"+
""+
"| Anamnesa Singkat | "+
""+rs.getString("anamnesa_singkat").replaceAll("(\r\n|\r|\n|\n\r)","
")+" | "+
"
"+
""+
"| Tanda Vital | "+
"Suhu (C) : "+rs.getString("suhu")+", Nyeri : "+rs.getString("nyeri")+", Tensi : "+rs.getString("tekanan_darah")+", Nadi(/menit) : "+rs.getString("nadi")+", Saturasi O²(%) : "+rs.getString("saturasi_o2")+", Respirasi(/menit) : "+rs.getString("pernapasan")+" | "+
"
"
);
ps2=koneksi.prepareStatement(
"select master_triase_pemeriksaan.kode_pemeriksaan,master_triase_pemeriksaan.nama_pemeriksaan "+
"from master_triase_pemeriksaan inner join master_triase_skala3 inner join data_triase_igddetail_skala3 "+
"on master_triase_pemeriksaan.kode_pemeriksaan=master_triase_skala3.kode_pemeriksaan and "+
"master_triase_skala3.kode_skala3=data_triase_igddetail_skala3.kode_skala3 where data_triase_igddetail_skala3.no_rawat=? "+
"group by master_triase_pemeriksaan.kode_pemeriksaan order by master_triase_pemeriksaan.kode_pemeriksaan");
try {
ps2.setString(1,rs.getString("no_rawat"));
rs2=ps2.executeQuery();
if(rs2.next()){
htmlContent.append(
""+
"| Pemeriksaan | "+
"Urgensi | "+
"
");
rs2.beforeFirst();
while(rs2.next()){
htmlContent.append(
""+
"| "+rs2.getString("nama_pemeriksaan")+" | "+
""+
""
);
ps3=koneksi.prepareStatement(
"select master_triase_skala3.pengkajian_skala3 from master_triase_skala3 inner join data_triase_igddetail_skala3 "+
"on master_triase_skala3.kode_skala3=data_triase_igddetail_skala3.kode_skala3 where "+
"master_triase_skala3.kode_pemeriksaan=? and data_triase_igddetail_skala3.no_rawat=? "+
"order by data_triase_igddetail_skala3.kode_skala3");
try {
ps3.setString(1,rs2.getString("kode_pemeriksaan"));
ps3.setString(2,rs.getString("no_rawat"));
rs3=ps3.executeQuery();
while(rs3.next()){
htmlContent.append(
""+
"| "+rs3.getString("pengkajian_skala3")+" | "+
" "
);
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
if(ps3!=null){
ps3.close();
}
}
htmlContent.append(
" "+
" | "+
"
"
);
}
keputusan="#C8C800";
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs2!=null){
rs2.close();
}
if(ps2!=null){
ps2.close();
}
}
ps2=koneksi.prepareStatement(
"select master_triase_pemeriksaan.kode_pemeriksaan,master_triase_pemeriksaan.nama_pemeriksaan "+
"from master_triase_pemeriksaan inner join master_triase_skala4 inner join data_triase_igddetail_skala4 "+
"on master_triase_pemeriksaan.kode_pemeriksaan=master_triase_skala4.kode_pemeriksaan and "+
"master_triase_skala4.kode_skala4=data_triase_igddetail_skala4.kode_skala4 where data_triase_igddetail_skala4.no_rawat=? "+
"group by master_triase_pemeriksaan.kode_pemeriksaan order by master_triase_pemeriksaan.kode_pemeriksaan");
try {
ps2.setString(1,rs.getString("no_rawat"));
rs2=ps2.executeQuery();
if(rs2.next()){
htmlContent.append(
""+
"| Pemeriksaan | "+
"Semi Urgensi/Urgensi Rendah | "+
"
");
rs2.beforeFirst();
while(rs2.next()){
htmlContent.append(
""+
"| "+rs2.getString("nama_pemeriksaan")+" | "+
""+
""
);
ps3=koneksi.prepareStatement(
"select master_triase_skala4.pengkajian_skala4 from master_triase_skala4 inner join data_triase_igddetail_skala4 "+
"on master_triase_skala4.kode_skala4=data_triase_igddetail_skala4.kode_skala4 where "+
"master_triase_skala4.kode_pemeriksaan=? and data_triase_igddetail_skala4.no_rawat=? "+
"order by data_triase_igddetail_skala4.kode_skala4");
try {
ps3.setString(1,rs2.getString("kode_pemeriksaan"));
ps3.setString(2,rs.getString("no_rawat"));
rs3=ps3.executeQuery();
while(rs3.next()){
htmlContent.append(
""+
"| "+rs3.getString("pengkajian_skala4")+" | "+
" "
);
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
if(ps3!=null){
ps3.close();
}
}
htmlContent.append(
" "+
" | "+
"
"
);
}
keputusan="#00AA00";
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs2!=null){
rs2.close();
}
if(ps2!=null){
ps2.close();
}
}
ps2=koneksi.prepareStatement(
"select master_triase_pemeriksaan.kode_pemeriksaan,master_triase_pemeriksaan.nama_pemeriksaan "+
"from master_triase_pemeriksaan inner join master_triase_skala5 inner join data_triase_igddetail_skala5 "+
"on master_triase_pemeriksaan.kode_pemeriksaan=master_triase_skala5.kode_pemeriksaan and "+
"master_triase_skala5.kode_skala5=data_triase_igddetail_skala5.kode_skala5 where data_triase_igddetail_skala5.no_rawat=? "+
"group by master_triase_pemeriksaan.kode_pemeriksaan order by master_triase_pemeriksaan.kode_pemeriksaan");
try {
ps2.setString(1,rs.getString("no_rawat"));
rs2=ps2.executeQuery();
if(rs2.next()){
htmlContent.append(
""+
"| Pemeriksaan | "+
"Non Urgensi | "+
"
");
rs2.beforeFirst();
while(rs2.next()){
htmlContent.append(
""+
"| "+rs2.getString("nama_pemeriksaan")+" | "+
""+
""
);
ps3=koneksi.prepareStatement(
"select master_triase_skala5.pengkajian_skala5 from master_triase_skala5 inner join data_triase_igddetail_skala5 "+
"on master_triase_skala5.kode_skala5=data_triase_igddetail_skala5.kode_skala5 where "+
"master_triase_skala5.kode_pemeriksaan=? and data_triase_igddetail_skala5.no_rawat=? "+
"order by data_triase_igddetail_skala5.kode_skala5");
try {
ps3.setString(1,rs2.getString("kode_pemeriksaan"));
ps3.setString(2,rs.getString("no_rawat"));
rs3=ps3.executeQuery();
while(rs3.next()){
htmlContent.append(
""+
"| "+rs3.getString("pengkajian_skala5")+" | "+
" "
);
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs3!=null){
rs3.close();
}
if(ps3!=null){
ps3.close();
}
}
htmlContent.append(
" "+
" | "+
"
"
);
}
keputusan="#969696";
}
} catch (Exception e) {
System.out.println("Notif : "+e);
} finally{
if(rs2!=null){
rs2.close();
}
if(ps2!=null){
ps2.close();
}
}
htmlContent.append(
""+
"| Plan/Keputusan | "+
""+rs.getString("plan")+" | "+
"
"
);
htmlContent.append(
""+
"| | "+
"Dokter/Petugas Triase | "+
"
"+
""+
"| Tanggal & Jam | "+
""+rs.getString("tanggaltriase")+" | "+
"
"+
""+
"| Catatan | "+
""+rs.getString("catatan")+" | "+
"
"+
""+
"| Nama Dokter/Petugas | "+
""+rs.getString("nik")+" "+Sequel.cariIsi("select pegawai.nama from pegawai where pegawai.nik=?",rs.getString("nik"))+" | "+
"
"
);
LoadHTML.setText(
""+
""+
"");
}
} catch (Exception e) {
System.out.println("Notifikasi : "+e);
} finally{
if(rs!=null){
rs.close();
}
if(ps!=null){
ps.close();
}
}
} catch (Exception e) {
System.out.println("Notif : "+e);
}
}
}
private void isMenu(){
if(ChkAccor.isSelected()==true){
ChkAccor.setVisible(false);
PanelAccor.setPreferredSize(new Dimension(470,HEIGHT));
FormMenu.setVisible(true);
ScrollHTML.setVisible(true);
ChkAccor.setVisible(true);
}else if(ChkAccor.isSelected()==false){
ChkAccor.setVisible(false);
PanelAccor.setPreferredSize(new Dimension(15,HEIGHT));
FormMenu.setVisible(false);
ScrollHTML.setVisible(false);
ChkAccor.setVisible(true);
}
}
private void hapus() {
Sequel.meghapus("data_triase_igd","no_rawat",tbTriase.getValueAt(tbTriase.getSelectedRow(),0).toString());
Sequel.meghapus("data_triase_igdprimer","no_rawat",tbTriase.getValueAt(tbTriase.getSelectedRow(),0).toString());
Sequel.meghapus("data_triase_igdsekunder","no_rawat",tbTriase.getValueAt(tbTriase.getSelectedRow(),0).toString());
Sequel.meghapus("data_triase_igddetail_skala1","no_rawat",tbTriase.getValueAt(tbTriase.getSelectedRow(),0).toString());
Sequel.meghapus("data_triase_igddetail_skala2","no_rawat",tbTriase.getValueAt(tbTriase.getSelectedRow(),0).toString());
Sequel.meghapus("data_triase_igddetail_skala3","no_rawat",tbTriase.getValueAt(tbTriase.getSelectedRow(),0).toString());
Sequel.meghapus("data_triase_igddetail_skala4","no_rawat",tbTriase.getValueAt(tbTriase.getSelectedRow(),0).toString());
Sequel.meghapus("data_triase_igddetail_skala5","no_rawat",tbTriase.getValueAt(tbTriase.getSelectedRow(),0).toString());
tampil();
TNoRM1.setText("");
TPasien1.setText("");
LoadHTML.setText("");
ChkAccor.setSelected(false);
isMenu();
}
private void ganti() {
Sequel.AutoComitFalse();
sukses=true;
Sequel.meghapus("data_triase_igdprimer","no_rawat",tbTriase.getValueAt(tbTriase.getSelectedRow(),0).toString());
Sequel.meghapus("data_triase_igddetail_skala1","no_rawat",tbTriase.getValueAt(tbTriase.getSelectedRow(),0).toString());
Sequel.meghapus("data_triase_igddetail_skala2","no_rawat",tbTriase.getValueAt(tbTriase.getSelectedRow(),0).toString());
Sequel.meghapus("data_triase_igdsekunder","no_rawat",tbTriase.getValueAt(tbTriase.getSelectedRow(),0).toString());
Sequel.meghapus("data_triase_igddetail_skala3","no_rawat",tbTriase.getValueAt(tbTriase.getSelectedRow(),0).toString());
Sequel.meghapus("data_triase_igddetail_skala4","no_rawat",tbTriase.getValueAt(tbTriase.getSelectedRow(),0).toString());
Sequel.meghapus("data_triase_igddetail_skala5","no_rawat",tbTriase.getValueAt(tbTriase.getSelectedRow(),0).toString());
if(TabTriase.getSelectedIndex()==0){
jmlskala1=0;jmlskala2=0;
for(i=0;i