private void BtnSeek2ActionPerformed(
     java.awt.event.ActionEvent evt) { // GEN-FIRST:event_BtnSeek2ActionPerformed
   var.setStatus(true);
   bangsal.tampil();
   bangsal.emptTeks();
   bangsal.setSize(internalFrame1.getWidth() - 50, internalFrame1.getHeight() - 50);
   bangsal.setLocationRelativeTo(internalFrame1);
   bangsal.setAlwaysOnTop(false);
   bangsal.setVisible(true);
 } // GEN-LAST:event_BtnSeek2ActionPerformed
  /**
   * Creates new form DlgProgramStudi
   *
   * @param parent
   * @param modal
   */
  public DlgRHTindakanParamedis(java.awt.Frame parent, boolean modal) {
    super(parent, modal);
    initComponents();

    Object[] row = {
      "No.", "Nama Paramedis", "Tgl.Tindakan", "Nama Pasien", "Tindakan Medis", "Jasa Medis"
    };
    tabMode =
        new DefaultTableModel(null, row) {
          @Override
          public boolean isCellEditable(int rowIndex, int colIndex) {
            return false;
          }
        };
    tbDokter.setModel(tabMode);

    tbDokter.setPreferredScrollableViewportSize(new Dimension(800, 800));
    tbDokter.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);

    for (i = 0; i < 6; i++) {
      TableColumn column = tbDokter.getColumnModel().getColumn(i);
      if (i == 0) {
        column.setPreferredWidth(35);
      } else if (i == 1) {
        column.setPreferredWidth(200);
      } else if (i == 2) {
        column.setPreferredWidth(130);
      } else if (i == 3) {
        column.setPreferredWidth(250);
      } else if (i == 4) {
        column.setPreferredWidth(250);
      } else if (i == 5) {
        column.setPreferredWidth(100);
      }
    }
    tbDokter.setDefaultRenderer(Object.class, new WarnaTable());

    kdbangsal.setDocument(new batasInput((byte) 5).getKata(kdbangsal));

    bangsal
        .getTable()
        .addMouseListener(
            new MouseListener() {
              @Override
              public void mouseClicked(MouseEvent e) {
                kdbangsal.setText(bangsal.getTextField().getText());
                Sequel.cariIsi(
                    "select nama from petugas where nip='" + bangsal.getTextField().getText() + "'",
                    nmbangsal);
                prosesCari();
              }

              @Override
              public void mousePressed(MouseEvent e) {}

              @Override
              public void mouseReleased(MouseEvent e) {}

              @Override
              public void mouseEntered(MouseEvent e) {}

              @Override
              public void mouseExited(MouseEvent e) {}
            });

    try {
      ps = koneksi.prepareStatement("select nip,nama from petugas where nip like ? order by nama");
      ps2 =
          koneksi.prepareStatement(
              "select pasien.nm_pasien,jns_perawatan.tarif_tindakanpr,"
                  + "jns_perawatan.nm_perawatan,reg_periksa.tgl_registrasi "
                  + "from pasien inner join reg_periksa  "
                  + "inner join jns_perawatan inner join rawat_jl_pr "
                  + "on rawat_jl_pr.no_rawat=reg_periksa.no_rawat "
                  + "and reg_periksa.no_rkm_medis=pasien.no_rkm_medis "
                  + "and rawat_jl_pr.kd_jenis_prw=jns_perawatan.kd_jenis_prw "
                  + "where reg_periksa.tgl_registrasi between ? and ? and rawat_jl_pr.nip=? "
                  + " and jns_perawatan.total_byrpr>0 order by reg_periksa.tgl_registrasi,jns_perawatan.nm_perawatan");
      ps4 =
          koneksi.prepareStatement(
              "select jns_perawatan.tarif_tindakanpr,pasien.nm_pasien,"
                  + "jns_perawatan.nm_perawatan,periksa_lab.tgl_periksa,periksa_lab.jam "
                  + " from periksa_lab inner join reg_periksa inner join pasien inner join petugas inner join jns_perawatan "
                  + " on periksa_lab.no_rawat=reg_periksa.no_rawat and reg_periksa.no_rkm_medis=pasien.no_rkm_medis "
                  + " and periksa_lab.nip=petugas.nip and periksa_lab.kd_jenis_prw=jns_perawatan.kd_jenis_prw "
                  + " where periksa_lab.tgl_periksa between ? and ? and periksa_lab.nip=? order by periksa_lab.tgl_periksa,periksa_lab.jam,jns_perawatan.nm_perawatan  ");
      ps3 =
          koneksi.prepareStatement(
              "select jns_perawatan_inap.tarif_tindakanpr,pasien.nm_pasien,jns_perawatan_inap.nm_perawatan,"
                  + "rawat_inap_pr.tgl_perawatan,rawat_inap_pr.jam_rawat "
                  + "from pasien inner join reg_periksa inner join jns_perawatan_inap inner join rawat_inap_pr "
                  + "on rawat_inap_pr.no_rawat=reg_periksa.no_rawat "
                  + "and reg_periksa.no_rkm_medis=pasien.no_rkm_medis "
                  + "and rawat_inap_pr.kd_jenis_prw=jns_perawatan_inap.kd_jenis_prw "
                  + "where rawat_inap_pr.tgl_perawatan between ? and ? and rawat_inap_pr.nip=? "
                  + " and jns_perawatan_inap.total_byrpr>0 order by rawat_inap_pr.tgl_perawatan,rawat_inap_pr.jam_rawat,jns_perawatan_inap.nm_perawatan  ");
      ps5 =
          koneksi.prepareStatement(
              "select operasi.biayaasisten_operator1,pasien.nm_pasien,paket_operasi.nm_perawatan,"
                  + "operasi.tgl_operasi from operasi inner join reg_periksa inner join pasien inner join paket_operasi "
                  + "on operasi.no_rawat=reg_periksa.no_rawat and reg_periksa.no_rkm_medis=pasien.no_rkm_medis and operasi.kode_paket=paket_operasi.kode_paket "
                  + "where operasi.tgl_operasi between ? and ? and operasi.asisten_operator1=? "
                  + " and operasi.biayaasisten_operator1>0 order by operasi.tgl_operasi,paket_operasi.nm_perawatan");
      ps6 =
          koneksi.prepareStatement(
              "select operasi.biayaasisten_operator2,pasien.nm_pasien,paket_operasi.nm_perawatan,"
                  + "operasi.tgl_operasi from operasi inner join reg_periksa inner join pasien inner join paket_operasi "
                  + "on operasi.no_rawat=reg_periksa.no_rawat and reg_periksa.no_rkm_medis=pasien.no_rkm_medis and operasi.kode_paket=paket_operasi.kode_paket "
                  + "where operasi.tgl_operasi between ? and ? and operasi.asisten_operator2=? "
                  + " and operasi.biayaasisten_operator2>0 order by operasi.tgl_operasi,paket_operasi.nm_perawatan");
      ps7 =
          koneksi.prepareStatement(
              "select operasi.biayaasisten_operator3,pasien.nm_pasien,paket_operasi.nm_perawatan,"
                  + "operasi.tgl_operasi from operasi inner join reg_periksa inner join pasien inner join paket_operasi "
                  + "on operasi.no_rawat=reg_periksa.no_rawat and reg_periksa.no_rkm_medis=pasien.no_rkm_medis and operasi.kode_paket=paket_operasi.kode_paket "
                  + "where operasi.tgl_operasi between ? and ? and operasi.asisten_operator3=? "
                  + " and operasi.biayaasisten_operator3>0 order by operasi.tgl_operasi,paket_operasi.nm_perawatan");
      ps8 =
          koneksi.prepareStatement(
              "select operasi.biayaperawaat_resusitas,pasien.nm_pasien,paket_operasi.nm_perawatan,"
                  + "operasi.tgl_operasi from operasi inner join reg_periksa inner join pasien inner join paket_operasi "
                  + "on operasi.no_rawat=reg_periksa.no_rawat and reg_periksa.no_rkm_medis=pasien.no_rkm_medis and operasi.kode_paket=paket_operasi.kode_paket "
                  + "where operasi.tgl_operasi between ? and ? and operasi.perawaat_resusitas=? "
                  + " and operasi.biayaperawaat_resusitas>0 order by operasi.tgl_operasi,paket_operasi.nm_perawatan");
      ps9 =
          koneksi.prepareStatement(
              "select operasi.biayaasisten_anestesi,pasien.nm_pasien,paket_operasi.nm_perawatan,"
                  + "operasi.tgl_operasi from operasi inner join reg_periksa inner join pasien inner join paket_operasi "
                  + "on operasi.no_rawat=reg_periksa.no_rawat and reg_periksa.no_rkm_medis=pasien.no_rkm_medis and operasi.kode_paket=paket_operasi.kode_paket "
                  + "where operasi.tgl_operasi between ? and ? and operasi.asisten_anestesi=? "
                  + " and operasi.biayaasisten_anestesi>0 order by operasi.tgl_operasi,paket_operasi.nm_perawatan");
      ps10 =
          koneksi.prepareStatement(
              "select operasi.biayabidan,pasien.nm_pasien,paket_operasi.nm_perawatan,"
                  + "operasi.tgl_operasi from operasi inner join reg_periksa inner join pasien inner join paket_operasi "
                  + "on operasi.no_rawat=reg_periksa.no_rawat and reg_periksa.no_rkm_medis=pasien.no_rkm_medis and operasi.kode_paket=paket_operasi.kode_paket "
                  + "where operasi.tgl_operasi between ? and ? and operasi.bidan=? "
                  + " and operasi.biayabidan>0 order by operasi.tgl_operasi,paket_operasi.nm_perawatan");
      ps11 =
          koneksi.prepareStatement(
              "select operasi.biayaperawat_luar,pasien.nm_pasien,paket_operasi.nm_perawatan,"
                  + "operasi.tgl_operasi from operasi inner join reg_periksa inner join pasien inner join paket_operasi "
                  + "on operasi.no_rawat=reg_periksa.no_rawat and reg_periksa.no_rkm_medis=pasien.no_rkm_medis and operasi.kode_paket=paket_operasi.kode_paket "
                  + "where operasi.tgl_operasi between ? and ? and operasi.perawat_luar=? "
                  + " and operasi.biayaperawat_luar>0 order by operasi.tgl_operasi,paket_operasi.nm_perawatan");
    } catch (SQLException e) {
      System.out.println(e);
    }
  }