public void prosesCari() { Valid.tabelKosong(tabMode); try { ps.setString(1, "%" + kdbangsal.getText() + "%"); rs = ps.executeQuery(); i = 1; totaljm = 0; while (rs.next()) { total = 0; tabMode.addRow(new Object[] {i + ".", rs.getString("nama"), "", "", "", ""}); // rawat jalan ps2.setString(1, Tgl1.getSelectedItem().toString()); ps2.setString(2, Tgl2.getSelectedItem().toString()); ps2.setString(3, rs.getString("nip")); rs2 = ps2.executeQuery(); rs2.last(); if (rs2.getRow() > 0) { tabMode.addRow(new Object[] {"", "", "Rawat Jalan :", "", "", ""}); } rs2.beforeFirst(); a = 1; while (rs2.next()) { tabMode.addRow( new Object[] { "", "", a + ". " + rs2.getString("tgl_registrasi"), rs2.getString("nm_pasien"), rs2.getString("nm_perawatan"), Valid.SetAngka(rs2.getDouble("tarif_tindakanpr")) }); a++; total = total + rs2.getDouble("tarif_tindakanpr"); } // periksa lab ps4.setString(1, Tgl1.getSelectedItem().toString()); ps4.setString(2, Tgl2.getSelectedItem().toString()); ps4.setString(3, rs.getString("nip")); rs4 = ps4.executeQuery(); rs4.last(); if (rs4.getRow() > 0) { tabMode.addRow(new Object[] {"", "", "Periksa Lab : ", "", "", ""}); } rs4.beforeFirst(); a = 1; while (rs4.next()) { tabMode.addRow( new Object[] { "", "", a + ". " + rs4.getString("tgl_periksa") + " " + rs4.getString("jam"), rs4.getString("nm_pasien"), rs4.getString("nm_perawatan"), Valid.SetAngka(rs4.getDouble("tarif_tindakanpr")) }); a++; total = total + rs4.getDouble("tarif_tindakanpr"); } // rs4.close(); // rawat inap ps3.setString(1, Tgl1.getSelectedItem().toString()); ps3.setString(2, Tgl2.getSelectedItem().toString()); ps3.setString(3, rs.getString("nip")); rs3 = ps3.executeQuery(); rs3.last(); ps5.setString(1, Tgl1.getSelectedItem().toString()); ps5.setString(2, Tgl2.getSelectedItem().toString()); ps5.setString(3, rs.getString("nip")); rs5 = ps5.executeQuery(); rs5.last(); ps6.setString(1, Tgl1.getSelectedItem().toString()); ps6.setString(2, Tgl2.getSelectedItem().toString()); ps6.setString(3, rs.getString("nip")); rs6 = ps6.executeQuery(); rs6.last(); ps7.setString(1, Tgl1.getSelectedItem().toString()); ps7.setString(2, Tgl2.getSelectedItem().toString()); ps7.setString(3, rs.getString("nip")); rs7 = ps7.executeQuery(); rs7.last(); ps8.setString(1, Tgl1.getSelectedItem().toString()); ps8.setString(2, Tgl2.getSelectedItem().toString()); ps8.setString(3, rs.getString("nip")); rs8 = ps8.executeQuery(); rs8.last(); ps9.setString(1, Tgl1.getSelectedItem().toString()); ps9.setString(2, Tgl2.getSelectedItem().toString()); ps9.setString(3, rs.getString("nip")); rs9 = ps9.executeQuery(); rs9.last(); ps10.setString(1, Tgl1.getSelectedItem().toString()); ps10.setString(2, Tgl2.getSelectedItem().toString()); ps10.setString(3, rs.getString("nip")); rs10 = ps10.executeQuery(); rs10.last(); ps11.setString(1, Tgl1.getSelectedItem().toString()); ps11.setString(2, Tgl2.getSelectedItem().toString()); ps11.setString(3, rs.getString("nip")); rs11 = ps11.executeQuery(); rs11.last(); if ((rs3.getRow() > 0) || (rs5.getRow() > 0) || (rs6.getRow() > 0) || (rs7.getRow() > 0) || (rs8.getRow() > 0) || (rs9.getRow() > 0) || (rs10.getRow() > 0) || (rs11.getRow() > 0)) { tabMode.addRow(new Object[] {"", "", "Rawat Inap :", "", "", ""}); } rs3.beforeFirst(); a = 1; while (rs3.next()) { tabMode.addRow( new Object[] { "", "", a + ". " + rs3.getString("tgl_perawatan") + " " + rs3.getString("jam_rawat"), rs3.getString("nm_pasien"), rs3.getString("nm_perawatan"), Valid.SetAngka(rs3.getDouble("tarif_tindakanpr")) }); a++; total = total + rs3.getDouble("tarif_tindakanpr"); } // asisten operator rs5.beforeFirst(); while (rs5.next()) { tabMode.addRow( new Object[] { "", "", a + ". " + rs5.getString("tgl_operasi"), rs5.getString("nm_pasien"), rs5.getString("nm_perawatan") + " (Asisten Operator 1)", Valid.SetAngka(rs5.getDouble("biayaasisten_operator1")) }); a++; total = total + rs5.getDouble("biayaasisten_operator1"); } // asisten anasthesi rs6.beforeFirst(); while (rs6.next()) { tabMode.addRow( new Object[] { "", "", a + ". " + rs6.getString("tgl_operasi"), rs6.getString("nm_pasien"), rs6.getString("nm_perawatan") + " (Asisten Operator 2)", Valid.SetAngka(rs6.getDouble("biayaasisten_operator2")) }); a++; total = total + rs6.getDouble("biayaasisten_operator2"); } // perawat luar rs7.beforeFirst(); while (rs7.next()) { tabMode.addRow( new Object[] { "", "", a + ". " + rs7.getString("tgl_operasi"), rs7.getString("nm_pasien"), rs7.getString("nm_perawatan") + " (Asisten Operator 3)", Valid.SetAngka(rs7.getDouble("biayaasisten_operator3")) }); a++; total = total + rs7.getDouble("biayaasisten_operator3"); } // perawat luar rs8.beforeFirst(); while (rs8.next()) { tabMode.addRow( new Object[] { "", "", a + ". " + rs8.getString("tgl_operasi"), rs8.getString("nm_pasien"), rs8.getString("nm_perawatan") + " (Perawat Resusitas)", Valid.SetAngka(rs8.getDouble("biayaperawaat_resusitas")) }); a++; total = total + rs8.getDouble("biayaperawaat_resusitas"); } // perawat luar rs9.beforeFirst(); while (rs9.next()) { tabMode.addRow( new Object[] { "", "", a + ". " + rs9.getString("tgl_operasi"), rs9.getString("nm_pasien"), rs9.getString("nm_perawatan") + " (Asisten Anestesi)", Valid.SetAngka(rs9.getDouble("biayaasisten_anestesi")) }); a++; total = total + rs9.getDouble("biayaasisten_anestesi"); } // perawat luar rs10.beforeFirst(); while (rs10.next()) { tabMode.addRow( new Object[] { "", "", a + ". " + rs10.getString("tgl_operasi"), rs10.getString("nm_pasien"), rs10.getString("nm_perawatan") + " (Bidan Operasi)", Valid.SetAngka(rs10.getDouble("biayabidan")) }); a++; total = total + rs10.getDouble("biayabidan"); } rs11.beforeFirst(); while (rs11.next()) { tabMode.addRow( new Object[] { "", "", a + ". " + rs11.getString("tgl_operasi"), rs11.getString("nm_pasien"), rs11.getString("nm_perawatan") + " (Perawat Luar)", Valid.SetAngka(rs11.getDouble("biayaperawat_luar")) }); a++; total = total + rs11.getDouble("biayaperawat_luar"); } if (total > 0) { tabMode.addRow(new Object[] {"", "", "Total :", "", "", Valid.SetAngka(total)}); } i++; totaljm = totaljm + total; } if (totaljm > 0) { tabMode.addRow( new Object[] {"<>> ", "Total Jasa Medis :", "", "", "", Valid.SetAngka(totaljm)}); } } catch (SQLException e) { System.out.println("Error : " + e); } }