/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/*
 * DlgLhtBiaya.java
 *
 * Created on 12 Jul 10, 16:21:34
 */

package keuangan;

import fungsi.WarnaTable;
import fungsi.koneksiDB;
import fungsi.sekuel;
import fungsi.validasi;
import fungsi.akses;
import java.awt.Cursor;
import java.awt.Dimension;
import java.awt.event.KeyEvent;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.HashMap;
import java.util.Map;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableColumn;

/**
 *
 * @author perpustakaan
 */
public final class DlgOmsetPenerimaan extends javax.swing.JDialog {
    private final DefaultTableModel tabMode,tabMode2,tabMode3,tabMode4,tabMode5,tabMode6,tabMode7,tabMode8;
    private Connection koneksi=koneksiDB.condb();
    private sekuel Sequel=new sekuel();
    private validasi Valid=new validasi();
    private PreparedStatement ps;
    private ResultSet rs;
    private double rawatjalan=0,rawatinap=0,jualbebas=0,pemasukanlain=0,deposit=0,bayarpiutang=0,bayarpiutanguang=0,bayarpiutangjasa=0;

    /** Creates new form DlgLhtBiaya
     * @param parent
     * @param modal */
    public DlgOmsetPenerimaan(java.awt.Frame parent, boolean modal) {
        super(parent, modal);
        initComponents();
        this.setLocation(8,1);
        setSize(885,674);

        tabMode=new DefaultTableModel(null,new Object[]{"Tanggal","No.Nota","No.Rawat","No.RM","Nama Pasien","Akun Bayar","Pembayaran"}){
              @Override public boolean isCellEditable(int rowIndex, int colIndex){return false;}
              Class[] types = new Class[] {
                java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, 
                java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, 
                java.lang.Double.class, 
             };
             @Override
             public Class getColumnClass(int columnIndex) {
                return types [columnIndex];
             }
        };
        tbRawatJalan.setModel(tabMode);
        tbRawatJalan.setPreferredScrollableViewportSize(new Dimension(500,500));
        tbRawatJalan.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);

        for (int i = 0; i < 7; i++) {
            TableColumn column = tbRawatJalan.getColumnModel().getColumn(i);
            if(i==0){
                column.setPreferredWidth(65);
            }else if(i==1){
                column.setPreferredWidth(103);
            }else if(i==2){
                column.setPreferredWidth(103);
            }else if(i==3){
                column.setPreferredWidth(80);
            }else if(i==4){
                column.setPreferredWidth(180);
            }else if(i==5){
                column.setPreferredWidth(200);
            }else if(i==6){
                column.setPreferredWidth(100);
            }
        }
        tbRawatJalan.setDefaultRenderer(Object.class, new WarnaTable());
        
        tabMode2=new DefaultTableModel(null,new Object[]{"Tanggal","No.Nota","No.Rawat","No.RM","Nama Pasien","Akun Bayar","Pembayaran"}){
              @Override public boolean isCellEditable(int rowIndex, int colIndex){return false;}
              Class[] types = new Class[] {
                java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, 
                java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, 
                java.lang.Double.class, 
             };
             @Override
             public Class getColumnClass(int columnIndex) {
                return types [columnIndex];
             }
        };
        tbRawatInap.setModel(tabMode2);
        tbRawatInap.setPreferredScrollableViewportSize(new Dimension(500,500));
        tbRawatInap.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);

        for (int i = 0; i < 7; i++) {
            TableColumn column = tbRawatInap.getColumnModel().getColumn(i);
            if(i==0){
                column.setPreferredWidth(65);
            }else if(i==1){
                column.setPreferredWidth(103);
            }else if(i==2){
                column.setPreferredWidth(103);
            }else if(i==3){
                column.setPreferredWidth(80);
            }else if(i==4){
                column.setPreferredWidth(180);
            }else if(i==5){
                column.setPreferredWidth(200);
            }else if(i==6){
                column.setPreferredWidth(100);
            }
        }
        tbRawatInap.setDefaultRenderer(Object.class, new WarnaTable());
        
        tabMode3=new DefaultTableModel(null,new Object[]{"Tanggal","No.Nota","Jenis Harga","No.RM","Nama Pasien","Akun Bayar","Pembayaran"}){
              @Override public boolean isCellEditable(int rowIndex, int colIndex){return false;}
              Class[] types = new Class[] {
                java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, 
                java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, 
                java.lang.Double.class, 
             };
             @Override
             public Class getColumnClass(int columnIndex) {
                return types [columnIndex];
             }
        };
        tbPenjualanBebas.setModel(tabMode3);
        tbPenjualanBebas.setPreferredScrollableViewportSize(new Dimension(500,500));
        tbPenjualanBebas.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);

        for (int i = 0; i < 7; i++) {
            TableColumn column = tbPenjualanBebas.getColumnModel().getColumn(i);
            if(i==0){
                column.setPreferredWidth(65);
            }else if(i==1){
                column.setPreferredWidth(103);
            }else if(i==2){
                column.setPreferredWidth(103);
            }else if(i==3){
                column.setPreferredWidth(80);
            }else if(i==4){
                column.setPreferredWidth(180);
            }else if(i==5){
                column.setPreferredWidth(200);
            }else if(i==6){
                column.setPreferredWidth(100);
            }
        }
        tbPenjualanBebas.setDefaultRenderer(Object.class, new WarnaTable());
        
        tabMode4=new DefaultTableModel(null,new Object[]{"Tanggal","Nomor","Terima Dari","Keperluan","Kategori","Pemasukan"}){
              @Override public boolean isCellEditable(int rowIndex, int colIndex){return false;}
              Class[] types = new Class[] {
                java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, 
                java.lang.Object.class, java.lang.Object.class, java.lang.Double.class, 
             };
             @Override
             public Class getColumnClass(int columnIndex) {
                return types [columnIndex];
             }
        };
        tbPemasukanLain.setModel(tabMode4);
        tbPemasukanLain.setPreferredScrollableViewportSize(new Dimension(500,500));
        tbPemasukanLain.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);

        for (int i = 0; i < 6; i++) {
            TableColumn column = tbPemasukanLain.getColumnModel().getColumn(i);
            if(i==0){
                column.setPreferredWidth(65);
            }else if(i==1){
                column.setPreferredWidth(103);
            }else if(i==2){
                column.setPreferredWidth(168);
            }else if(i==3){
                column.setPreferredWidth(190);
            }else if(i==4){
                column.setPreferredWidth(205);
            }else if(i==5){
                column.setPreferredWidth(100);
            }
        }
        tbPemasukanLain.setDefaultRenderer(Object.class, new WarnaTable());
        
        tabMode5=new DefaultTableModel(null,new Object[]{"Tanggal","No.Deposit","No.Rawat","No.RM","Nama Pasien","Akun Bayar","Deposit"}){
              @Override public boolean isCellEditable(int rowIndex, int colIndex){return false;}
              Class[] types = new Class[] {
                java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, 
                java.lang.Object.class, java.lang.Object.class, java.lang.Double.class, 
             };
             @Override
             public Class getColumnClass(int columnIndex) {
                return types [columnIndex];
             }
        };
        tbDeposit.setModel(tabMode5);
        tbDeposit.setPreferredScrollableViewportSize(new Dimension(500,500));
        tbDeposit.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);

        for (int i = 0; i < 7; i++) {
            TableColumn column = tbDeposit.getColumnModel().getColumn(i);
            if(i==0){
                column.setPreferredWidth(65);
            }else if(i==1){
                column.setPreferredWidth(103);
            }else if(i==2){
                column.setPreferredWidth(103);
            }else if(i==3){
                column.setPreferredWidth(80);
            }else if(i==4){
                column.setPreferredWidth(176);
            }else if(i==5){
                column.setPreferredWidth(204);
            }else if(i==6){
                column.setPreferredWidth(100);
            }
        }
        tbDeposit.setDefaultRenderer(Object.class, new WarnaTable());
        
        tabMode6=new DefaultTableModel(null,new Object[]{"Tanggal","No.Tagihan","No.RM","Nama Pasien","Akun Bayar","Akun Piutang","Pembayaran"}){
              @Override public boolean isCellEditable(int rowIndex, int colIndex){return false;}
              Class[] types = new Class[] {
                java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, 
                java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, 
                java.lang.Double.class, 
             };
             @Override
             public Class getColumnClass(int columnIndex) {
                return types [columnIndex];
             }
        };
        tbPiutangPasienDibayar.setModel(tabMode6);
        tbPiutangPasienDibayar.setPreferredScrollableViewportSize(new Dimension(500,500));
        tbPiutangPasienDibayar.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);

        for (int i = 0; i < 7; i++) {
            TableColumn column = tbPiutangPasienDibayar.getColumnModel().getColumn(i);
            if(i==0){
                column.setPreferredWidth(65);
            }else if(i==1){
                column.setPreferredWidth(103);
            }else if(i==2){
                column.setPreferredWidth(80);
            }else if(i==3){
                column.setPreferredWidth(150);
            }else if(i==4){
                column.setPreferredWidth(166);
            }else if(i==5){
                column.setPreferredWidth(167);
            }else if(i==6){
                column.setPreferredWidth(100);
            }
        }
        tbPiutangPasienDibayar.setDefaultRenderer(Object.class, new WarnaTable());
        
        tabMode7=new DefaultTableModel(null,new Object[]{"Tanggal","No.Tagihan","Kode","Peminjam","Akun Bayar","Pembayaran"}){
              @Override public boolean isCellEditable(int rowIndex, int colIndex){return false;}
              Class[] types = new Class[] {
                java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, 
                java.lang.Object.class, java.lang.Object.class, java.lang.Double.class 
             };
             @Override
             public Class getColumnClass(int columnIndex) {
                return types [columnIndex];
             }
        };
        tbPiutangUangDibayar.setModel(tabMode7);
        tbPiutangUangDibayar.setPreferredScrollableViewportSize(new Dimension(500,500));
        tbPiutangUangDibayar.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);

        for (int i = 0; i < 6; i++) {
            TableColumn column = tbPiutangUangDibayar.getColumnModel().getColumn(i);
            if(i==0){
                column.setPreferredWidth(65);
            }else if(i==1){
                column.setPreferredWidth(103);
            }else if(i==2){
                column.setPreferredWidth(80);
            }else if(i==3){
                column.setPreferredWidth(210);
            }else if(i==4){
                column.setPreferredWidth(180);
            }else if(i==5){
                column.setPreferredWidth(100);
            }
        }
        tbPiutangUangDibayar.setDefaultRenderer(Object.class, new WarnaTable());
        
        tabMode8=new DefaultTableModel(null,new Object[]{"Tanggal","No.Tagihan","Kode","Instansi/Perusahaan","Akun Bayar","Pembayaran"}){
              @Override public boolean isCellEditable(int rowIndex, int colIndex){return false;}
              Class[] types = new Class[] {
                java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, 
                java.lang.Object.class, java.lang.Object.class, java.lang.Double.class 
             };
             @Override
             public Class getColumnClass(int columnIndex) {
                return types [columnIndex];
             }
        };
        tbPiutangJasaDibayar.setModel(tabMode8);
        tbPiutangJasaDibayar.setPreferredScrollableViewportSize(new Dimension(500,500));
        tbPiutangJasaDibayar.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);

        for (int i = 0; i < 6; i++) {
            TableColumn column = tbPiutangJasaDibayar.getColumnModel().getColumn(i);
            if(i==0){
                column.setPreferredWidth(65);
            }else if(i==1){
                column.setPreferredWidth(103);
            }else if(i==2){
                column.setPreferredWidth(80);
            }else if(i==3){
                column.setPreferredWidth(210);
            }else if(i==4){
                column.setPreferredWidth(180);
            }else if(i==5){
                column.setPreferredWidth(100);
            }
        }
        tbPiutangJasaDibayar.setDefaultRenderer(Object.class, new WarnaTable());
    }  

    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
    private void initComponents() {

        internalFrame1 = new widget.InternalFrame();
        jPanel3 = new javax.swing.JPanel();
        panelGlass8 = new widget.panelisi();
        jLabel19 = new widget.Label();
        DTPCari1 = new widget.Tanggal();
        jLabel21 = new widget.Label();
        DTPCari2 = new widget.Tanggal();
        BtnCari = new widget.Button();
        jLabel16 = new javax.swing.JLabel();
        LCountTotal = new javax.swing.JLabel();
        BtnPrint = new widget.Button();
        BtnKeluar = new widget.Button();
        panelGlass9 = new widget.panelisi();
        jLabel10 = new javax.swing.JLabel();
        LCountRawatJalan = new javax.swing.JLabel();
        LCountRawatInap = new javax.swing.JLabel();
        jLabel11 = new javax.swing.JLabel();
        jLabel12 = new javax.swing.JLabel();
        LCountJualBebas = new javax.swing.JLabel();
        jLabel13 = new javax.swing.JLabel();
        LCountPemasukanLain = new javax.swing.JLabel();
        jLabel14 = new javax.swing.JLabel();
        LCountDeposit = new javax.swing.JLabel();
        jLabel15 = new javax.swing.JLabel();
        LCountPiutangDibayar = new javax.swing.JLabel();
        jLabel17 = new javax.swing.JLabel();
        jLabel18 = new javax.swing.JLabel();
        LCountPiutangUang = new javax.swing.JLabel();
        LCountPiutangJasa = new javax.swing.JLabel();
        TabRawat = new javax.swing.JTabbedPane();
        Scroll = new widget.ScrollPane();
        tbRawatJalan = new widget.Table();
        Scroll2 = new widget.ScrollPane();
        tbRawatInap = new widget.Table();
        Scroll3 = new widget.ScrollPane();
        tbPenjualanBebas = new widget.Table();
        Scroll4 = new widget.ScrollPane();
        tbPemasukanLain = new widget.Table();
        Scroll7 = new widget.ScrollPane();
        tbDeposit = new widget.Table();
        Scroll8 = new widget.ScrollPane();
        tbPiutangPasienDibayar = new widget.Table();
        Scroll9 = new widget.ScrollPane();
        tbPiutangUangDibayar = new widget.Table();
        Scroll10 = new widget.ScrollPane();
        tbPiutangJasaDibayar = new widget.Table();

        setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
        setUndecorated(true);
        setResizable(false);

        internalFrame1.setBorder(javax.swing.BorderFactory.createTitledBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(240, 245, 235)), "::[ Penerimaan/Omset/Kas Masuk ]::", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 0, 11), new java.awt.Color(50, 50, 50))); // NOI18N
        internalFrame1.setName("internalFrame1"); // NOI18N
        internalFrame1.setLayout(new java.awt.BorderLayout(1, 1));

        jPanel3.setName("jPanel3"); // NOI18N
        jPanel3.setOpaque(false);
        jPanel3.setPreferredSize(new java.awt.Dimension(44, 130));
        jPanel3.setLayout(new java.awt.BorderLayout(1, 1));

        panelGlass8.setName("panelGlass8"); // NOI18N
        panelGlass8.setPreferredSize(new java.awt.Dimension(44, 44));
        panelGlass8.setLayout(new java.awt.FlowLayout(java.awt.FlowLayout.LEFT, 5, 9));

        jLabel19.setText("Tanggal :");
        jLabel19.setName("jLabel19"); // NOI18N
        jLabel19.setPreferredSize(new java.awt.Dimension(55, 23));
        panelGlass8.add(jLabel19);

        DTPCari1.setForeground(new java.awt.Color(50, 70, 50));
        DTPCari1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "23-05-2025" }));
        DTPCari1.setDisplayFormat("dd-MM-yyyy");
        DTPCari1.setName("DTPCari1"); // NOI18N
        DTPCari1.setOpaque(false);
        DTPCari1.setPreferredSize(new java.awt.Dimension(90, 23));
        panelGlass8.add(DTPCari1);

        jLabel21.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        jLabel21.setText("s.d.");
        jLabel21.setName("jLabel21"); // NOI18N
        jLabel21.setPreferredSize(new java.awt.Dimension(23, 23));
        panelGlass8.add(jLabel21);

        DTPCari2.setForeground(new java.awt.Color(50, 70, 50));
        DTPCari2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "23-05-2025" }));
        DTPCari2.setDisplayFormat("dd-MM-yyyy");
        DTPCari2.setName("DTPCari2"); // NOI18N
        DTPCari2.setOpaque(false);
        DTPCari2.setPreferredSize(new java.awt.Dimension(90, 23));
        panelGlass8.add(DTPCari2);

        BtnCari.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/accept.png"))); // NOI18N
        BtnCari.setMnemonic('3');
        BtnCari.setToolTipText("Alt+3");
        BtnCari.setName("BtnCari"); // NOI18N
        BtnCari.setPreferredSize(new java.awt.Dimension(28, 23));
        BtnCari.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                BtnCariActionPerformed(evt);
            }
        });
        BtnCari.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyPressed(java.awt.event.KeyEvent evt) {
                BtnCariKeyPressed(evt);
            }
        });
        panelGlass8.add(BtnCari);

        jLabel16.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N
        jLabel16.setForeground(new java.awt.Color(50, 50, 50));
        jLabel16.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
        jLabel16.setText("Total Penerimaan :");
        jLabel16.setName("jLabel16"); // NOI18N
        jLabel16.setPreferredSize(new java.awt.Dimension(100, 23));
        panelGlass8.add(jLabel16);

        LCountTotal.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        LCountTotal.setForeground(new java.awt.Color(50, 50, 50));
        LCountTotal.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
        LCountTotal.setText("0");
        LCountTotal.setName("LCountTotal"); // NOI18N
        LCountTotal.setPreferredSize(new java.awt.Dimension(180, 23));
        panelGlass8.add(LCountTotal);

        BtnPrint.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/b_print.png"))); // NOI18N
        BtnPrint.setMnemonic('T');
        BtnPrint.setText("Cetak");
        BtnPrint.setToolTipText("Alt+T");
        BtnPrint.setName("BtnPrint"); // NOI18N
        BtnPrint.setPreferredSize(new java.awt.Dimension(100, 30));
        BtnPrint.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                BtnPrintActionPerformed(evt);
            }
        });
        BtnPrint.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyPressed(java.awt.event.KeyEvent evt) {
                BtnPrintKeyPressed(evt);
            }
        });
        panelGlass8.add(BtnPrint);

        BtnKeluar.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/exit.png"))); // NOI18N
        BtnKeluar.setMnemonic('K');
        BtnKeluar.setText("Keluar");
        BtnKeluar.setToolTipText("Alt+K");
        BtnKeluar.setName("BtnKeluar"); // NOI18N
        BtnKeluar.setPreferredSize(new java.awt.Dimension(100, 30));
        BtnKeluar.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                BtnKeluarActionPerformed(evt);
            }
        });
        BtnKeluar.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyPressed(java.awt.event.KeyEvent evt) {
                BtnKeluarKeyPressed(evt);
            }
        });
        panelGlass8.add(BtnKeluar);

        jPanel3.add(panelGlass8, java.awt.BorderLayout.CENTER);

        panelGlass9.setName("panelGlass9"); // NOI18N
        panelGlass9.setPreferredSize(new java.awt.Dimension(44, 74));
        panelGlass9.setLayout(null);

        jLabel10.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N
        jLabel10.setForeground(new java.awt.Color(50, 50, 50));
        jLabel10.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
        jLabel10.setText("Rawat Jalan :");
        jLabel10.setName("jLabel10"); // NOI18N
        jLabel10.setPreferredSize(new java.awt.Dimension(80, 23));
        panelGlass9.add(jLabel10);
        jLabel10.setBounds(0, 10, 120, 23);

        LCountRawatJalan.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        LCountRawatJalan.setForeground(new java.awt.Color(50, 50, 50));
        LCountRawatJalan.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
        LCountRawatJalan.setText("0");
        LCountRawatJalan.setName("LCountRawatJalan"); // NOI18N
        LCountRawatJalan.setPreferredSize(new java.awt.Dimension(180, 23));
        panelGlass9.add(LCountRawatJalan);
        LCountRawatJalan.setBounds(124, 10, 110, 23);

        LCountRawatInap.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        LCountRawatInap.setForeground(new java.awt.Color(50, 50, 50));
        LCountRawatInap.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
        LCountRawatInap.setText("0");
        LCountRawatInap.setName("LCountRawatInap"); // NOI18N
        LCountRawatInap.setPreferredSize(new java.awt.Dimension(180, 23));
        panelGlass9.add(LCountRawatInap);
        LCountRawatInap.setBounds(318, 10, 110, 23);

        jLabel11.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N
        jLabel11.setForeground(new java.awt.Color(50, 50, 50));
        jLabel11.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
        jLabel11.setText("Rawat Inap :");
        jLabel11.setName("jLabel11"); // NOI18N
        jLabel11.setPreferredSize(new java.awt.Dimension(80, 23));
        panelGlass9.add(jLabel11);
        jLabel11.setBounds(234, 10, 80, 23);

        jLabel12.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N
        jLabel12.setForeground(new java.awt.Color(50, 50, 50));
        jLabel12.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
        jLabel12.setText("Penjualan Bebas :");
        jLabel12.setName("jLabel12"); // NOI18N
        jLabel12.setPreferredSize(new java.awt.Dimension(80, 23));
        panelGlass9.add(jLabel12);
        jLabel12.setBounds(430, 10, 100, 23);

        LCountJualBebas.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        LCountJualBebas.setForeground(new java.awt.Color(50, 50, 50));
        LCountJualBebas.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
        LCountJualBebas.setText("0");
        LCountJualBebas.setName("LCountJualBebas"); // NOI18N
        LCountJualBebas.setPreferredSize(new java.awt.Dimension(180, 23));
        panelGlass9.add(LCountJualBebas);
        LCountJualBebas.setBounds(534, 10, 110, 23);

        jLabel13.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N
        jLabel13.setForeground(new java.awt.Color(50, 50, 50));
        jLabel13.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
        jLabel13.setText("Pemasukan Lain-lain :");
        jLabel13.setName("jLabel13"); // NOI18N
        jLabel13.setPreferredSize(new java.awt.Dimension(80, 23));
        panelGlass9.add(jLabel13);
        jLabel13.setBounds(0, 40, 120, 23);

        LCountPemasukanLain.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        LCountPemasukanLain.setForeground(new java.awt.Color(50, 50, 50));
        LCountPemasukanLain.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
        LCountPemasukanLain.setText("0");
        LCountPemasukanLain.setName("LCountPemasukanLain"); // NOI18N
        LCountPemasukanLain.setPreferredSize(new java.awt.Dimension(180, 23));
        panelGlass9.add(LCountPemasukanLain);
        LCountPemasukanLain.setBounds(124, 40, 110, 23);

        jLabel14.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N
        jLabel14.setForeground(new java.awt.Color(50, 50, 50));
        jLabel14.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
        jLabel14.setText("Deposit :");
        jLabel14.setName("jLabel14"); // NOI18N
        jLabel14.setPreferredSize(new java.awt.Dimension(80, 23));
        panelGlass9.add(jLabel14);
        jLabel14.setBounds(234, 40, 80, 23);

        LCountDeposit.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        LCountDeposit.setForeground(new java.awt.Color(50, 50, 50));
        LCountDeposit.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
        LCountDeposit.setText("0");
        LCountDeposit.setName("LCountDeposit"); // NOI18N
        LCountDeposit.setPreferredSize(new java.awt.Dimension(180, 23));
        panelGlass9.add(LCountDeposit);
        LCountDeposit.setBounds(318, 40, 110, 23);

        jLabel15.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N
        jLabel15.setForeground(new java.awt.Color(50, 50, 50));
        jLabel15.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
        jLabel15.setText("Piutang Pasien :");
        jLabel15.setName("jLabel15"); // NOI18N
        jLabel15.setPreferredSize(new java.awt.Dimension(80, 23));
        panelGlass9.add(jLabel15);
        jLabel15.setBounds(430, 40, 100, 23);

        LCountPiutangDibayar.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        LCountPiutangDibayar.setForeground(new java.awt.Color(50, 50, 50));
        LCountPiutangDibayar.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
        LCountPiutangDibayar.setText("0");
        LCountPiutangDibayar.setName("LCountPiutangDibayar"); // NOI18N
        LCountPiutangDibayar.setPreferredSize(new java.awt.Dimension(180, 23));
        panelGlass9.add(LCountPiutangDibayar);
        LCountPiutangDibayar.setBounds(534, 40, 110, 23);

        jLabel17.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N
        jLabel17.setForeground(new java.awt.Color(50, 50, 50));
        jLabel17.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
        jLabel17.setText("Piutang Uang :");
        jLabel17.setName("jLabel17"); // NOI18N
        jLabel17.setPreferredSize(new java.awt.Dimension(80, 23));
        panelGlass9.add(jLabel17);
        jLabel17.setBounds(646, 10, 85, 23);

        jLabel18.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N
        jLabel18.setForeground(new java.awt.Color(50, 50, 50));
        jLabel18.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
        jLabel18.setText("Piutang Jasa :");
        jLabel18.setName("jLabel18"); // NOI18N
        jLabel18.setPreferredSize(new java.awt.Dimension(80, 23));
        panelGlass9.add(jLabel18);
        jLabel18.setBounds(646, 40, 85, 23);

        LCountPiutangUang.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        LCountPiutangUang.setForeground(new java.awt.Color(50, 50, 50));
        LCountPiutangUang.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
        LCountPiutangUang.setText("0");
        LCountPiutangUang.setName("LCountPiutangUang"); // NOI18N
        LCountPiutangUang.setPreferredSize(new java.awt.Dimension(180, 23));
        panelGlass9.add(LCountPiutangUang);
        LCountPiutangUang.setBounds(735, 10, 110, 23);

        LCountPiutangJasa.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
        LCountPiutangJasa.setForeground(new java.awt.Color(50, 50, 50));
        LCountPiutangJasa.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
        LCountPiutangJasa.setText("0");
        LCountPiutangJasa.setName("LCountPiutangJasa"); // NOI18N
        LCountPiutangJasa.setPreferredSize(new java.awt.Dimension(180, 23));
        panelGlass9.add(LCountPiutangJasa);
        LCountPiutangJasa.setBounds(735, 40, 110, 23);

        jPanel3.add(panelGlass9, java.awt.BorderLayout.PAGE_START);

        internalFrame1.add(jPanel3, java.awt.BorderLayout.PAGE_END);

        TabRawat.setBackground(new java.awt.Color(255, 255, 254));
        TabRawat.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(239, 244, 234)));
        TabRawat.setForeground(new java.awt.Color(50, 50, 50));
        TabRawat.setFont(new java.awt.Font("Tahoma", 0, 11)); // NOI18N
        TabRawat.setName("TabRawat"); // NOI18N
        TabRawat.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                TabRawatMouseClicked(evt);
            }
        });

        Scroll.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(255, 255, 255)));
        Scroll.setName("Scroll"); // NOI18N
        Scroll.setOpaque(true);

        tbRawatJalan.setName("tbRawatJalan"); // NOI18N
        Scroll.setViewportView(tbRawatJalan);

        TabRawat.addTab("Rawat Jalan", Scroll);

        Scroll2.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(255, 255, 255)));
        Scroll2.setName("Scroll2"); // NOI18N
        Scroll2.setOpaque(true);

        tbRawatInap.setName("tbRawatInap"); // NOI18N
        Scroll2.setViewportView(tbRawatInap);

        TabRawat.addTab("Rawat Inap", Scroll2);

        Scroll3.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(255, 255, 255)));
        Scroll3.setName("Scroll3"); // NOI18N
        Scroll3.setOpaque(true);

        tbPenjualanBebas.setName("tbPenjualanBebas"); // NOI18N
        Scroll3.setViewportView(tbPenjualanBebas);

        TabRawat.addTab("Penjualan Bebas", Scroll3);

        Scroll4.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(255, 255, 255)));
        Scroll4.setName("Scroll4"); // NOI18N
        Scroll4.setOpaque(true);

        tbPemasukanLain.setName("tbPemasukanLain"); // NOI18N
        Scroll4.setViewportView(tbPemasukanLain);

        TabRawat.addTab("Pemasukan Lain-lain", Scroll4);

        Scroll7.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(255, 255, 255)));
        Scroll7.setName("Scroll7"); // NOI18N
        Scroll7.setOpaque(true);

        tbDeposit.setName("tbDeposit"); // NOI18N
        Scroll7.setViewportView(tbDeposit);

        TabRawat.addTab("Deposit", Scroll7);

        Scroll8.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(255, 255, 255)));
        Scroll8.setName("Scroll8"); // NOI18N
        Scroll8.setOpaque(true);

        tbPiutangPasienDibayar.setName("tbPiutangPasienDibayar"); // NOI18N
        Scroll8.setViewportView(tbPiutangPasienDibayar);

        TabRawat.addTab("Piutang Pasien Dibayar", Scroll8);

        Scroll9.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(255, 255, 255)));
        Scroll9.setName("Scroll9"); // NOI18N
        Scroll9.setOpaque(true);

        tbPiutangUangDibayar.setName("tbPiutangUangDibayar"); // NOI18N
        Scroll9.setViewportView(tbPiutangUangDibayar);

        TabRawat.addTab("Piutang Peminjaman Uang Dibayar", Scroll9);

        Scroll10.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(255, 255, 255)));
        Scroll10.setName("Scroll10"); // NOI18N
        Scroll10.setOpaque(true);

        tbPiutangJasaDibayar.setName("tbPiutangJasaDibayar"); // NOI18N
        Scroll10.setViewportView(tbPiutangJasaDibayar);

        TabRawat.addTab("Piutang Jasa Perusahaan Dibayar", Scroll10);

        internalFrame1.add(TabRawat, java.awt.BorderLayout.CENTER);

        getContentPane().add(internalFrame1, java.awt.BorderLayout.CENTER);

        pack();
    }// </editor-fold>//GEN-END:initComponents

    private void BtnCariKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnCariKeyPressed
        if(evt.getKeyCode()==KeyEvent.VK_SPACE){
            BtnCariActionPerformed(null);
        }else{
            Valid.pindah(evt, DTPCari2, BtnPrint);
        }
    }//GEN-LAST:event_BtnCariKeyPressed

    private void BtnCariActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnCariActionPerformed
        tampil();
    }//GEN-LAST:event_BtnCariActionPerformed

    private void BtnKeluarKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnKeluarKeyPressed
        if(evt.getKeyCode()==KeyEvent.VK_SPACE){
            dispose();
        }else{Valid.pindah(evt,BtnPrint,DTPCari2);}
    }//GEN-LAST:event_BtnKeluarKeyPressed

    private void BtnKeluarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnKeluarActionPerformed
        dispose();
    }//GEN-LAST:event_BtnKeluarActionPerformed

    private void BtnPrintKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnPrintKeyPressed
        if(evt.getKeyCode()==KeyEvent.VK_SPACE){
            BtnPrintActionPerformed(null);
        }else{
            Valid.pindah(evt, BtnPrint, BtnKeluar);
        }
    }//GEN-LAST:event_BtnPrintKeyPressed

    private void BtnPrintActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnPrintActionPerformed
        this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR));
        if(tabMode.getRowCount()!=0){
            Map<String, Object> param = new HashMap<>();
            param.put("namars",akses.getnamars());
            param.put("alamatrs",akses.getalamatrs());
            param.put("kotars",akses.getkabupatenrs());
            param.put("propinsirs",akses.getpropinsirs());
            param.put("kontakrs",akses.getkontakrs());
            param.put("emailrs",akses.getemailrs());
            param.put("logo",Sequel.cariGambar("select setting.logo from setting"));
            Valid.MyReportqry("rptOmsetRalan.jasper","report","::[ Penerimaan Pembayaran Pasien Rawat Jalan ]::",
                "select DATE_FORMAT(nota_jalan.tanggal,'%Y-%m-%d') as tanggal,nota_jalan.no_nota,nota_jalan.no_rawat,reg_periksa.no_rkm_medis,"+
                "pasien.nm_pasien,detail_nota_jalan.nama_bayar,detail_nota_jalan.besar_bayar "+
                "from nota_jalan inner join reg_periksa on nota_jalan.no_rawat=reg_periksa.no_rawat "+
                "inner join pasien on pasien.no_rkm_medis=reg_periksa.no_rkm_medis "+
                "inner join detail_nota_jalan on detail_nota_jalan.no_rawat=reg_periksa.no_rawat "+
                "where nota_jalan.tanggal between '"+Valid.SetTgl(DTPCari1.getSelectedItem().toString()+"")+"' and '"+Valid.SetTgl(DTPCari2.getSelectedItem().toString()+"")+"' order by nota_jalan.tanggal,nota_jalan.jam ",param);
        }
        
        if(tabMode2.getRowCount()!=0){
            Map<String, Object> param = new HashMap<>();
            param.put("namars",akses.getnamars());
            param.put("alamatrs",akses.getalamatrs());
            param.put("kotars",akses.getkabupatenrs());
            param.put("propinsirs",akses.getpropinsirs());
            param.put("kontakrs",akses.getkontakrs());
            param.put("emailrs",akses.getemailrs());
            param.put("logo",Sequel.cariGambar("select setting.logo from setting"));
            Valid.MyReportqry("rptOmsetRanap.jasper","report","::[ Penerimaan Pembayaran Pasien Rawat Inap ]::",
                "select DATE_FORMAT(nota_inap.tanggal,'%Y-%m-%d') as tanggal,nota_inap.no_nota,nota_inap.no_rawat,reg_periksa.no_rkm_medis,"+
                "pasien.nm_pasien,detail_nota_inap.nama_bayar,detail_nota_inap.besar_bayar "+
                "from nota_inap inner join reg_periksa on nota_inap.no_rawat=reg_periksa.no_rawat "+
                "inner join pasien on pasien.no_rkm_medis=reg_periksa.no_rkm_medis "+
                "inner join detail_nota_inap on detail_nota_inap.no_rawat=reg_periksa.no_rawat "+
                "where nota_inap.tanggal between '"+Valid.SetTgl(DTPCari1.getSelectedItem().toString()+"")+"' and '"+Valid.SetTgl(DTPCari2.getSelectedItem().toString()+"")+"' order by nota_inap.tanggal,nota_inap.jam ",param);
        }
        
        if(tabMode3.getRowCount()!=0){
            Map<String, Object> param = new HashMap<>();
            param.put("namars",akses.getnamars());
            param.put("alamatrs",akses.getalamatrs());
            param.put("kotars",akses.getkabupatenrs());
            param.put("propinsirs",akses.getpropinsirs());
            param.put("kontakrs",akses.getkontakrs());
            param.put("emailrs",akses.getemailrs());
            param.put("logo",Sequel.cariGambar("select setting.logo from setting"));
            Valid.MyReportqry("rptOmsetPenjualanObat.jasper","report","::[ Penerimaan Penjualan Bebas ]::",
                "select DATE_FORMAT(penjualan.tgl_jual,'%Y-%m-%d') as tanggal,penjualan.nota_jual,penjualan.jns_jual,penjualan.no_rkm_medis,"+
                "penjualan.nm_pasien,penjualan.nama_bayar,round(penjualan.ongkir+penjualan.ppn+sum(detailjual.total)) as total "+
                "from penjualan inner join detailjual on detailjual.nota_jual=penjualan.nota_jual "+
                "where penjualan.status='Sudah Dibayar' and penjualan.tgl_jual between '"+Valid.SetTgl(DTPCari1.getSelectedItem().toString()+"")+"' and '"+Valid.SetTgl(DTPCari2.getSelectedItem().toString()+"")+"' "+
                "group by penjualan.nota_jual order by penjualan.tgl_jual,penjualan.nota_jual ",param);
        }
        
        if(tabMode4.getRowCount()!=0){
            Map<String, Object> param = new HashMap<>();
            param.put("namars",akses.getnamars());
            param.put("alamatrs",akses.getalamatrs());
            param.put("kotars",akses.getkabupatenrs());
            param.put("propinsirs",akses.getpropinsirs());
            param.put("kontakrs",akses.getkontakrs());
            param.put("emailrs",akses.getemailrs());
            param.put("logo",Sequel.cariGambar("select setting.logo from setting"));
            Valid.MyReportqry("rptOmsetPemasukanLain.jasper","report","::[ Penerimaan Pemasukan Lain-lain ]::",
                "select DATE_FORMAT(pemasukan_lain.tanggal,'%Y-%m-%d') as tanggal,pemasukan_lain.no_masuk,pemasukan_lain.keterangan,"+
                "pemasukan_lain.keperluan,kategori_pemasukan_lain.nama_kategori,pemasukan_lain.besar "+
                "from pemasukan_lain inner join kategori_pemasukan_lain on pemasukan_lain.kode_kategori=kategori_pemasukan_lain.kode_kategori "+
                "where pemasukan_lain.tanggal between '"+Valid.SetTgl(DTPCari1.getSelectedItem().toString()+"")+" 00:00:00"+"' and '"+Valid.SetTgl(DTPCari2.getSelectedItem().toString()+"")+" 23:59:59"+"' order by pemasukan_lain.tanggal ",param);
        }
        
        if(tabMode5.getRowCount()!=0){
            Map<String, Object> param = new HashMap<>();
            param.put("namars",akses.getnamars());
            param.put("alamatrs",akses.getalamatrs());
            param.put("kotars",akses.getkabupatenrs());
            param.put("propinsirs",akses.getpropinsirs());
            param.put("kontakrs",akses.getkontakrs());
            param.put("emailrs",akses.getemailrs());
            param.put("logo",Sequel.cariGambar("select setting.logo from setting"));
            Valid.MyReportqry("rptOmsetDeposit.jasper","report","::[ Penerimaan Deposit Pasien ]::",
                "select DATE_FORMAT(deposit.tgl_deposit,'%Y-%m-%d') as tanggal,deposit.no_deposit,deposit.no_rawat,reg_periksa.no_rkm_medis,pasien.nm_pasien,deposit.nama_bayar, "+
                "deposit.besar_deposit from deposit inner join reg_periksa on deposit.no_rawat=reg_periksa.no_rawat inner join pasien on reg_periksa.no_rkm_medis=pasien.no_rkm_medis "+
                "where deposit.tgl_deposit between '"+Valid.SetTgl(DTPCari1.getSelectedItem().toString()+"")+" 00:00:00"+"' and '"+Valid.SetTgl(DTPCari2.getSelectedItem().toString()+"")+" 23:59:59"+"' order by deposit.tgl_deposit ",param);
        }
        
        if(tabMode6.getRowCount()!=0){
            Map<String, Object> param = new HashMap<>();
            param.put("namars",akses.getnamars());
            param.put("alamatrs",akses.getalamatrs());
            param.put("kotars",akses.getkabupatenrs());
            param.put("propinsirs",akses.getpropinsirs());
            param.put("kontakrs",akses.getkontakrs());
            param.put("emailrs",akses.getemailrs());
            param.put("logo",Sequel.cariGambar("select setting.logo from setting"));
            Valid.MyReportqry("rptOmsetPiutangDibayar.jasper","report","::[ Penerimaan Pembayaran Piutang ]::",
                "select DATE_FORMAT(bayar_piutang.tgl_bayar,'%Y-%m-%d') as tanggal,bayar_piutang.no_rawat,bayar_piutang.no_rkm_medis,pasien.nm_pasien,"+
                "rekening.nm_rek,rekening2.nm_rek,bayar_piutang.besar_cicilan "+
                "from bayar_piutang inner join pasien on bayar_piutang.no_rkm_medis=pasien.no_rkm_medis "+
                "inner join rekening on rekening.kd_rek=bayar_piutang.kd_rek "+
                "inner join rekening as rekening2 on rekening2.kd_rek=bayar_piutang.kd_rek_kontra "+
                "where bayar_piutang.tgl_bayar between '"+Valid.SetTgl(DTPCari1.getSelectedItem().toString()+"")+"' and '"+Valid.SetTgl(DTPCari2.getSelectedItem().toString()+"")+"' order by bayar_piutang.tgl_bayar ",param);
        }
        
        if(tabMode7.getRowCount()!=0){
            Map<String, Object> param = new HashMap<>();
            param.put("namars",akses.getnamars());
            param.put("alamatrs",akses.getalamatrs());
            param.put("kotars",akses.getkabupatenrs());
            param.put("propinsirs",akses.getpropinsirs());
            param.put("kontakrs",akses.getkontakrs());
            param.put("emailrs",akses.getemailrs());
            param.put("logo",Sequel.cariGambar("select setting.logo from setting"));
            Valid.MyReportqry("rptOmsetPiutangUangDibayar.jasper","report","::[ Penerimaan Pembayaran Piutang Peminjaman Uang ]::",
                "select DATE_FORMAT(bayar_piutang_lainlain.tgl_bayar,'%Y-%m-%d') as tanggal,bayar_piutang_lainlain.nota_piutang,bayar_piutang_lainlain.kode_peminjam,"+
                "peminjampiutang.nama_peminjam,bayar_piutang_lainlain.nama_bayar,bayar_piutang_lainlain.besar_cicilan "+
                "from bayar_piutang_lainlain inner join peminjampiutang on bayar_piutang_lainlain.kode_peminjam=peminjampiutang.kode_peminjam "+
                "where bayar_piutang_lainlain.tgl_bayar between '"+Valid.SetTgl(DTPCari1.getSelectedItem().toString()+"")+"' and '"+Valid.SetTgl(DTPCari2.getSelectedItem().toString()+"")+"' order by bayar_piutang_lainlain.tgl_bayar ",param);
        }
        
        if(tabMode8.getRowCount()!=0){
            Map<String, Object> param = new HashMap<>();
            param.put("namars",akses.getnamars());
            param.put("alamatrs",akses.getalamatrs());
            param.put("kotars",akses.getkabupatenrs());
            param.put("propinsirs",akses.getpropinsirs());
            param.put("kontakrs",akses.getkontakrs());
            param.put("emailrs",akses.getemailrs());
            param.put("logo",Sequel.cariGambar("select setting.logo from setting"));
            Valid.MyReportqry("rptOmsetPiutangJasaDibayar.jasper","report","::[ Penerimaan Pembayaran Piutang Jasa Perusahaan ]::",
                "select DATE_FORMAT(bayar_piutang_jasa_perusahaan.tgl_bayar,'%Y-%m-%d') as tanggal,bayar_piutang_jasa_perusahaan.no_piutang,bayar_piutang_jasa_perusahaan.kode_perusahaan,"+
                "perusahaan_pasien.nama_perusahaan,bayar_piutang_jasa_perusahaan.nama_bayar,bayar_piutang_jasa_perusahaan.besar_cicilan "+
                "from bayar_piutang_jasa_perusahaan inner join perusahaan_pasien on bayar_piutang_jasa_perusahaan.kode_perusahaan=perusahaan_pasien.kode_perusahaan "+
                "where bayar_piutang_jasa_perusahaan.tgl_bayar between '"+Valid.SetTgl(DTPCari1.getSelectedItem().toString()+"")+"' and '"+Valid.SetTgl(DTPCari2.getSelectedItem().toString()+"")+"' order by bayar_piutang_jasa_perusahaan.tgl_bayar ",param);
        }
        this.setCursor(Cursor.getDefaultCursor());
    }//GEN-LAST:event_BtnPrintActionPerformed

    private void TabRawatMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_TabRawatMouseClicked
        if(TabRawat.getSelectedIndex()==0){
            tampil();
        }else if(TabRawat.getSelectedIndex()==1){
            //tampil2();
        }
    }//GEN-LAST:event_TabRawatMouseClicked

    /**
    * @param args the command line arguments
    */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(() -> {
            DlgOmsetPenerimaan dialog = new DlgOmsetPenerimaan(new javax.swing.JFrame(), true);
            dialog.addWindowListener(new java.awt.event.WindowAdapter() {
                @Override
                public void windowClosing(java.awt.event.WindowEvent e) {
                    System.exit(0);
                }
            });
            dialog.setVisible(true);
        });
    }

    // Variables declaration - do not modify//GEN-BEGIN:variables
    private widget.Button BtnCari;
    private widget.Button BtnKeluar;
    private widget.Button BtnPrint;
    private widget.Tanggal DTPCari1;
    private widget.Tanggal DTPCari2;
    private javax.swing.JLabel LCountDeposit;
    private javax.swing.JLabel LCountJualBebas;
    private javax.swing.JLabel LCountPemasukanLain;
    private javax.swing.JLabel LCountPiutangDibayar;
    private javax.swing.JLabel LCountPiutangJasa;
    private javax.swing.JLabel LCountPiutangUang;
    private javax.swing.JLabel LCountRawatInap;
    private javax.swing.JLabel LCountRawatJalan;
    private javax.swing.JLabel LCountTotal;
    private widget.ScrollPane Scroll;
    private widget.ScrollPane Scroll10;
    private widget.ScrollPane Scroll2;
    private widget.ScrollPane Scroll3;
    private widget.ScrollPane Scroll4;
    private widget.ScrollPane Scroll7;
    private widget.ScrollPane Scroll8;
    private widget.ScrollPane Scroll9;
    private javax.swing.JTabbedPane TabRawat;
    private widget.InternalFrame internalFrame1;
    private javax.swing.JLabel jLabel10;
    private javax.swing.JLabel jLabel11;
    private javax.swing.JLabel jLabel12;
    private javax.swing.JLabel jLabel13;
    private javax.swing.JLabel jLabel14;
    private javax.swing.JLabel jLabel15;
    private javax.swing.JLabel jLabel16;
    private javax.swing.JLabel jLabel17;
    private javax.swing.JLabel jLabel18;
    private widget.Label jLabel19;
    private widget.Label jLabel21;
    private javax.swing.JPanel jPanel3;
    private widget.panelisi panelGlass8;
    private widget.panelisi panelGlass9;
    private widget.Table tbDeposit;
    private widget.Table tbPemasukanLain;
    private widget.Table tbPenjualanBebas;
    private widget.Table tbPiutangJasaDibayar;
    private widget.Table tbPiutangPasienDibayar;
    private widget.Table tbPiutangUangDibayar;
    private widget.Table tbRawatInap;
    private widget.Table tbRawatJalan;
    // End of variables declaration//GEN-END:variables

    public void tampil(){
        this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR)); 
        try{    
            Valid.tabelKosong(tabMode);
            rawatjalan=0;
            ps=koneksi.prepareStatement(
                    "select DATE_FORMAT(nota_jalan.tanggal,'%Y-%m-%d'),nota_jalan.no_nota,nota_jalan.no_rawat,reg_periksa.no_rkm_medis,"+
                    "pasien.nm_pasien,detail_nota_jalan.nama_bayar,detail_nota_jalan.besar_bayar "+
                    "from nota_jalan inner join reg_periksa on nota_jalan.no_rawat=reg_periksa.no_rawat "+
                    "inner join pasien on pasien.no_rkm_medis=reg_periksa.no_rkm_medis "+
                    "inner join detail_nota_jalan on detail_nota_jalan.no_rawat=reg_periksa.no_rawat "+
                    "where nota_jalan.tanggal between ? and ? order by nota_jalan.tanggal,nota_jalan.jam ");
            try {
                ps.setString(1,Valid.SetTgl(DTPCari1.getSelectedItem().toString()+""));
                ps.setString(2,Valid.SetTgl(DTPCari2.getSelectedItem().toString()+""));
                rs=ps.executeQuery();
                while(rs.next()){
                    tabMode.addRow(new Object[]{
                        rs.getString(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(6),rs.getDouble(7)
                    });
                    rawatjalan=rawatjalan+rs.getDouble(7);
                }
            } catch (Exception e) {
                System.out.println("Notif Rawat Jalan : "+e);
            } finally{
                if(rs!=null){
                    rs.close();
                }
                if(ps!=null){
                    ps.close();
                }
            }
            LCountRawatJalan.setText(Valid.SetAngka(rawatjalan));
            
            Valid.tabelKosong(tabMode2);
            rawatinap=0;
            ps=koneksi.prepareStatement(
                    "select DATE_FORMAT(nota_inap.tanggal,'%Y-%m-%d'),nota_inap.no_nota,nota_inap.no_rawat,reg_periksa.no_rkm_medis,"+
                    "pasien.nm_pasien,detail_nota_inap.nama_bayar,detail_nota_inap.besar_bayar "+
                    "from nota_inap inner join reg_periksa on nota_inap.no_rawat=reg_periksa.no_rawat "+
                    "inner join pasien on pasien.no_rkm_medis=reg_periksa.no_rkm_medis "+
                    "inner join detail_nota_inap on detail_nota_inap.no_rawat=reg_periksa.no_rawat "+
                    "where nota_inap.tanggal between ? and ? order by nota_inap.tanggal,nota_inap.jam ");
            try {
                ps.setString(1,Valid.SetTgl(DTPCari1.getSelectedItem().toString()+""));
                ps.setString(2,Valid.SetTgl(DTPCari2.getSelectedItem().toString()+""));
                rs=ps.executeQuery();
                while(rs.next()){
                    tabMode2.addRow(new Object[]{
                        rs.getString(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(6),rs.getDouble(7)
                    });
                    rawatinap=rawatinap+rs.getDouble(7);
                }
            } catch (Exception e) {
                System.out.println("Notif Rawat Inap : "+e);
            } finally{
                if(rs!=null){
                    rs.close();
                }
                if(ps!=null){
                    ps.close();
                }
            }
            LCountRawatInap.setText(Valid.SetAngka(rawatinap));
            
            Valid.tabelKosong(tabMode3);
            jualbebas=0;
            ps=koneksi.prepareStatement(
                    "select DATE_FORMAT(penjualan.tgl_jual,'%Y-%m-%d'),penjualan.nota_jual,penjualan.jns_jual,penjualan.no_rkm_medis,"+
                    "penjualan.nm_pasien,penjualan.nama_bayar,(penjualan.ongkir+penjualan.ppn+sum(detailjual.total)) "+
                    "from penjualan inner join detailjual on detailjual.nota_jual=penjualan.nota_jual "+
                    "where penjualan.status='Sudah Dibayar' and penjualan.tgl_jual between ? and ? "+
                    "group by penjualan.nota_jual order by penjualan.tgl_jual,penjualan.nota_jual ");
            try {
                ps.setString(1,Valid.SetTgl(DTPCari1.getSelectedItem().toString()+""));
                ps.setString(2,Valid.SetTgl(DTPCari2.getSelectedItem().toString()+""));
                rs=ps.executeQuery();
                while(rs.next()){
                    tabMode3.addRow(new Object[]{
                        rs.getString(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(6),Math.round(rs.getDouble(7))
                    });
                    jualbebas=jualbebas+rs.getDouble(7);
                }
            } catch (Exception e) {
                System.out.println("Notif Jual Bebas : "+e);
            } finally{
                if(rs!=null){
                    rs.close();
                }
                if(ps!=null){
                    ps.close();
                }
            }
            LCountJualBebas.setText(Valid.SetAngka(jualbebas));
            
            Valid.tabelKosong(tabMode4);
            pemasukanlain=0;
            ps=koneksi.prepareStatement(
                    "select DATE_FORMAT(pemasukan_lain.tanggal,'%Y-%m-%d'),pemasukan_lain.no_masuk,pemasukan_lain.keterangan,"+
                    "pemasukan_lain.keperluan,kategori_pemasukan_lain.nama_kategori,pemasukan_lain.besar "+
                    "from pemasukan_lain inner join kategori_pemasukan_lain on pemasukan_lain.kode_kategori=kategori_pemasukan_lain.kode_kategori "+
                    "where pemasukan_lain.tanggal between ? and ? order by pemasukan_lain.tanggal ");
            try {
                ps.setString(1,Valid.SetTgl(DTPCari1.getSelectedItem().toString()+"")+" 00:00:00");
                ps.setString(2,Valid.SetTgl(DTPCari2.getSelectedItem().toString()+"")+" 23:59:59");
                rs=ps.executeQuery();
                while(rs.next()){
                    tabMode4.addRow(new Object[]{
                        rs.getString(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getDouble(6)
                    });
                    pemasukanlain=pemasukanlain+rs.getDouble(6);
                }
            } catch (Exception e) {
                System.out.println("Notif Pemasukan Lain : "+e);
            } finally{
                if(rs!=null){
                    rs.close();
                }
                if(ps!=null){
                    ps.close();
                }
            }
            LCountPemasukanLain.setText(Valid.SetAngka(pemasukanlain));
            
            Valid.tabelKosong(tabMode5);
            deposit=0;
            ps=koneksi.prepareStatement(
                    "select DATE_FORMAT(deposit.tgl_deposit,'%Y-%m-%d'),deposit.no_deposit,deposit.no_rawat,reg_periksa.no_rkm_medis,pasien.nm_pasien,deposit.nama_bayar, "+
                    "deposit.besar_deposit from deposit inner join reg_periksa on deposit.no_rawat=reg_periksa.no_rawat inner join pasien on reg_periksa.no_rkm_medis=pasien.no_rkm_medis "+
                    "where deposit.tgl_deposit between ? and ? order by deposit.tgl_deposit ");
            try {
                ps.setString(1,Valid.SetTgl(DTPCari1.getSelectedItem().toString()+"")+" 00:00:00");
                ps.setString(2,Valid.SetTgl(DTPCari2.getSelectedItem().toString()+"")+" 23:59:59");
                rs=ps.executeQuery();
                while(rs.next()){
                    tabMode5.addRow(new Object[]{
                        rs.getString(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(6),rs.getDouble(7)
                    });
                    deposit=deposit+rs.getDouble(7);
                }
            } catch (Exception e) {
                System.out.println("Notif Deposit : "+e);
            } finally{
                if(rs!=null){
                    rs.close();
                }
                if(ps!=null){
                    ps.close();
                }
            }
            LCountDeposit.setText(Valid.SetAngka(deposit));
            
            Valid.tabelKosong(tabMode6);
            bayarpiutang=0;
            ps=koneksi.prepareStatement(
                    "select DATE_FORMAT(bayar_piutang.tgl_bayar,'%Y-%m-%d'),bayar_piutang.no_rawat,bayar_piutang.no_rkm_medis,pasien.nm_pasien,"+
                    "rekening.nm_rek,rekening2.nm_rek,bayar_piutang.besar_cicilan "+
                    "from bayar_piutang inner join pasien on bayar_piutang.no_rkm_medis=pasien.no_rkm_medis "+
                    "inner join rekening on rekening.kd_rek=bayar_piutang.kd_rek "+
                    "inner join rekening as rekening2 on rekening2.kd_rek=bayar_piutang.kd_rek_kontra "+
                    "where bayar_piutang.tgl_bayar between ? and ? order by bayar_piutang.tgl_bayar ");
            try {
                ps.setString(1,Valid.SetTgl(DTPCari1.getSelectedItem().toString()+"")+" 00:00:00");
                ps.setString(2,Valid.SetTgl(DTPCari2.getSelectedItem().toString()+"")+" 23:59:59");
                rs=ps.executeQuery();
                while(rs.next()){
                    tabMode6.addRow(new Object[]{
                        rs.getString(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(6),rs.getDouble(7)
                    });
                    bayarpiutang=bayarpiutang+rs.getDouble(7);
                }
            } catch (Exception e) {
                System.out.println("Notif Deposit : "+e);
            } finally{
                if(rs!=null){
                    rs.close();
                }
                if(ps!=null){
                    ps.close();
                }
            }
            LCountPiutangDibayar.setText(Valid.SetAngka(bayarpiutang));
            
            Valid.tabelKosong(tabMode7);
            bayarpiutanguang=0;
            ps=koneksi.prepareStatement(
                    "select DATE_FORMAT(bayar_piutang_lainlain.tgl_bayar,'%Y-%m-%d'),bayar_piutang_lainlain.nota_piutang,bayar_piutang_lainlain.kode_peminjam,"+
                    "peminjampiutang.nama_peminjam,bayar_piutang_lainlain.nama_bayar,bayar_piutang_lainlain.besar_cicilan "+
                    "from bayar_piutang_lainlain inner join peminjampiutang on bayar_piutang_lainlain.kode_peminjam=peminjampiutang.kode_peminjam "+
                    "where bayar_piutang_lainlain.tgl_bayar between ? and ? order by bayar_piutang_lainlain.tgl_bayar ");
            try {
                ps.setString(1,Valid.SetTgl(DTPCari1.getSelectedItem().toString()+"")+" 00:00:00");
                ps.setString(2,Valid.SetTgl(DTPCari2.getSelectedItem().toString()+"")+" 23:59:59");
                rs=ps.executeQuery();
                while(rs.next()){
                    tabMode7.addRow(new Object[]{
                        rs.getString(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getDouble(6)
                    });
                    bayarpiutanguang=bayarpiutanguang+rs.getDouble(6);
                }
            } catch (Exception e) {
                System.out.println("Notif Deposit : "+e);
            } finally{
                if(rs!=null){
                    rs.close();
                }
                if(ps!=null){
                    ps.close();
                }
            }
            LCountPiutangUang.setText(Valid.SetAngka(bayarpiutanguang));
            
            Valid.tabelKosong(tabMode8);
            bayarpiutangjasa=0;
            ps=koneksi.prepareStatement(
                    "select DATE_FORMAT(bayar_piutang_jasa_perusahaan.tgl_bayar,'%Y-%m-%d'),bayar_piutang_jasa_perusahaan.no_piutang,bayar_piutang_jasa_perusahaan.kode_perusahaan,"+
                    "perusahaan_pasien.nama_perusahaan,bayar_piutang_jasa_perusahaan.nama_bayar,bayar_piutang_jasa_perusahaan.besar_cicilan "+
                    "from bayar_piutang_jasa_perusahaan inner join perusahaan_pasien on bayar_piutang_jasa_perusahaan.kode_perusahaan=perusahaan_pasien.kode_perusahaan "+
                    "where bayar_piutang_jasa_perusahaan.tgl_bayar between ? and ? order by bayar_piutang_jasa_perusahaan.tgl_bayar ");
            try {
                ps.setString(1,Valid.SetTgl(DTPCari1.getSelectedItem().toString()+"")+" 00:00:00");
                ps.setString(2,Valid.SetTgl(DTPCari2.getSelectedItem().toString()+"")+" 23:59:59");
                rs=ps.executeQuery();
                while(rs.next()){
                    tabMode8.addRow(new Object[]{
                        rs.getString(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getDouble(6)
                    });
                    bayarpiutangjasa=bayarpiutangjasa+rs.getDouble(6);
                }
            } catch (Exception e) {
                System.out.println("Notif Deposit : "+e);
            } finally{
                if(rs!=null){
                    rs.close();
                }
                if(ps!=null){
                    ps.close();
                }
            }
            LCountPiutangJasa.setText(Valid.SetAngka(bayarpiutangjasa));
            
            LCountTotal.setText(Valid.SetAngka(rawatjalan+rawatinap+jualbebas+pemasukanlain+deposit+bayarpiutang+bayarpiutanguang+bayarpiutangjasa));
        }catch(Exception e){
            System.out.println("Notifikasi : "+e);
        }
        this.setCursor(Cursor.getDefaultCursor());
    }

    

}