package keuangan; import fungsi.koneksiDB; import fungsi.sekuel; import fungsi.validasi; import fungsi.akses; import java.awt.Cursor; import java.awt.Desktop; import java.awt.event.KeyEvent; import java.io.BufferedWriter; import java.io.File; import java.io.FileWriter; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import javax.swing.text.Document; import javax.swing.text.html.HTMLEditorKit; import javax.swing.text.html.StyleSheet; public class KeuanganSaldoAkunPerBulan extends javax.swing.JDialog { private sekuel Sequel=new sekuel(); private validasi Valid=new validasi(); private Jurnal jur=new Jurnal(); private Connection koneksi=koneksiDB.condb(); private PreparedStatement ps,ps2,ps3,ps4,ps5,ps6,ps7,ps8,ps9,ps10,ps11,ps12,ps13; private ResultSet rs,rs2,rs3,rs4,rs5,rs6,rs7,rs8,rs9,rs10,rs11,rs12,rs13; private int i=0; private StringBuilder htmlContent; private double saldoawaljanuari=0,debetjanuari=0,kreditjanuari=0,saldoakhirjanuari=0, debetfebruari=0,kreditfebruari=0,saldoakhirfebruari=0,debetmaret=0,kreditmaret=0, saldoakhirmaret=0,debetapril=0,kreditapril=0,saldoakhirapril=0,debetmei=0,kreditmei=0, saldoakhirmei=0,debetjuni=0,kreditjuni=0,saldoakhirjuni=0,debetjuli=0,kreditjuli=0, saldoakhirjuli=0,debetagustus=0,kreditagustus=0,saldoakhiragustus=0,debetseptember=0, kreditseptember,saldoakhirseptember=0,debetoktober=0,kreditoktober=0,saldoakhiroktober=0, debetnovember=0,kreditnovember=0,saldoakhirnovember=0,debetdesember=0,kreditdesember=0, saldoakhirdesember=0; /** Creates new form DlgProgramStudi * @param parent * @param modal */ public KeuanganSaldoAkunPerBulan(java.awt.Frame parent, boolean modal) { super(parent, modal); initComponents(); HTMLEditorKit kit = new HTMLEditorKit(); LoadHTML.setEditable(true); LoadHTML.setEditorKit(kit); LoadHTML.setEditable(true); LoadHTML.setEditorKit(kit); StyleSheet styleSheet = kit.getStyleSheet(); styleSheet.addRule( ".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;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;}" ); Document doc = kit.createDefaultDocument(); LoadHTML.setDocument(doc); LoadHTML.setDocument(doc); Valid.LoadTahun(ThnCari); } /** 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") // //GEN-BEGIN:initComponents private void initComponents() { Kd2 = new widget.TextBox(); internalFrame1 = new widget.InternalFrame(); panelisi1 = new widget.panelisi(); label11 = new widget.Label(); ThnCari = new widget.ComboBox(); jLabel6 = new widget.Label(); TCari = new widget.TextBox(); btnCari = new widget.Button(); BtnAll = new widget.Button(); label9 = new widget.Label(); BtnPrint = new widget.Button(); BtnKeluar = new widget.Button(); Scroll = new widget.ScrollPane(); LoadHTML = new widget.editorpane(); Kd2.setName("Kd2"); // NOI18N Kd2.setPreferredSize(new java.awt.Dimension(207, 23)); 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)), "::[ Saldo Akun Per Bulan ]::", 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)); panelisi1.setName("panelisi1"); // NOI18N panelisi1.setPreferredSize(new java.awt.Dimension(100, 56)); panelisi1.setLayout(new java.awt.FlowLayout(java.awt.FlowLayout.LEFT, 5, 9)); label11.setText("Tahun :"); label11.setName("label11"); // NOI18N label11.setPreferredSize(new java.awt.Dimension(45, 23)); panelisi1.add(label11); ThnCari.setName("ThnCari"); // NOI18N ThnCari.setPreferredSize(new java.awt.Dimension(80, 23)); panelisi1.add(ThnCari); jLabel6.setText("Key Word :"); jLabel6.setName("jLabel6"); // NOI18N jLabel6.setPreferredSize(new java.awt.Dimension(70, 23)); panelisi1.add(jLabel6); TCari.setName("TCari"); // NOI18N TCari.setPreferredSize(new java.awt.Dimension(170, 23)); TCari.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { TCariKeyPressed(evt); } }); panelisi1.add(TCari); btnCari.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/accept.png"))); // NOI18N btnCari.setMnemonic('2'); btnCari.setToolTipText("Alt+2"); 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); } }); panelisi1.add(btnCari); BtnAll.setIcon(new javax.swing.ImageIcon(getClass().getResource("/picture/Search-16x16.png"))); // NOI18N BtnAll.setMnemonic('M'); BtnAll.setToolTipText("Alt+M"); BtnAll.setName("BtnAll"); // NOI18N BtnAll.setPreferredSize(new java.awt.Dimension(28, 23)); BtnAll.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { BtnAllActionPerformed(evt); } }); BtnAll.addKeyListener(new java.awt.event.KeyAdapter() { public void keyPressed(java.awt.event.KeyEvent evt) { BtnAllKeyPressed(evt); } }); panelisi1.add(BtnAll); label9.setHorizontalAlignment(javax.swing.SwingConstants.LEFT); label9.setName("label9"); // NOI18N label9.setPreferredSize(new java.awt.Dimension(60, 30)); panelisi1.add(label9); 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); } }); panelisi1.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); } }); panelisi1.add(BtnKeluar); internalFrame1.add(panelisi1, java.awt.BorderLayout.PAGE_END); Scroll.setName("Scroll"); // NOI18N Scroll.setOpaque(true); LoadHTML.setBorder(null); LoadHTML.setName("LoadHTML"); // NOI18N Scroll.setViewportView(LoadHTML); internalFrame1.add(Scroll, java.awt.BorderLayout.CENTER); getContentPane().add(internalFrame1, java.awt.BorderLayout.CENTER); pack(); }// //GEN-END:initComponents /* private void KdKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_TKdKeyPressed Valid.pindah(evt,BtnCari,Nm); }//GEN-LAST:event_TKdKeyPressed */ private void BtnPrintActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnPrintActionPerformed this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR)); try { File g = new File("file2.css"); BufferedWriter bg = new BufferedWriter(new FileWriter(g)); bg.write( ".isi td{border-right: 1px solid #e2e7dd;font: 11px tahoma;height:12px;border-bottom: 1px solid #e2e7dd;background: #ffffff;color:#323232;}"+ ".isi2 td{font: 11px tahoma;height:12px;background: #ffffff;color:#323232;}"+ ".isi3 td{border-right: 1px solid #e2e7dd;font: 11px 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;}" ); bg.close(); File f = new File("SaldoAkunPerBulan.html"); BufferedWriter bw = new BufferedWriter(new FileWriter(f)); bw.write(LoadHTML.getText().replaceAll("",""+ ""+ ""+ ""+ ""+ "
"+ ""+akses.getnamars()+"
"+ akses.getalamatrs()+", "+akses.getkabupatenrs()+", "+akses.getpropinsirs()+"
"+ akses.getkontakrs()+", E-mail : "+akses.getemailrs()+"

"+ "
") ); bw.close(); Desktop.getDesktop().browse(f.toURI()); } catch (Exception e) { System.out.println("Notifikasi : "+e); } this.setCursor(Cursor.getDefaultCursor()); }//GEN-LAST:event_BtnPrintActionPerformed private void BtnPrintKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnPrintKeyPressed if(evt.getKeyCode()==KeyEvent.VK_SPACE){ BtnPrintActionPerformed(null); }else{ Valid.pindah(evt,ThnCari,BtnKeluar); } }//GEN-LAST:event_BtnPrintKeyPressed private void BtnKeluarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnKeluarActionPerformed dispose(); }//GEN-LAST:event_BtnKeluarActionPerformed private void BtnKeluarKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnKeluarKeyPressed if(evt.getKeyCode()==KeyEvent.VK_SPACE){ dispose(); }else{Valid.pindah(evt,BtnPrint,ThnCari);} }//GEN-LAST:event_BtnKeluarKeyPressed private void btnCariActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnCariActionPerformed if(TCari.getText().trim().equals("")){ prosesCari(); }else{ prosesCari2(); } }//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, ThnCari, BtnPrint); } }//GEN-LAST:event_btnCariKeyPressed private void BtnAllActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_BtnAllActionPerformed TCari.setText(""); prosesCari(); }//GEN-LAST:event_BtnAllActionPerformed private void BtnAllKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_BtnAllKeyPressed if(evt.getKeyCode()==KeyEvent.VK_SPACE){ TCari.setText(""); prosesCari(); }else{ Valid.pindah(evt, BtnPrint, BtnKeluar); } }//GEN-LAST:event_BtnAllKeyPressed 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 /** * @param args the command line arguments */ public static void main(String args[]) { java.awt.EventQueue.invokeLater(() -> { KeuanganSaldoAkunPerBulan dialog = new KeuanganSaldoAkunPerBulan(new javax.swing.JFrame(), true); dialog.addWindowListener(new java.awt.event.WindowAdapter() { @Override public void windowClosing(java.awt.event.WindowEvent e) { System.exit(0); } }); dialog.setVisible(true); }); } // Variables declaration - do not modify//GEN-BEGIN:variables private widget.Button BtnAll; private widget.Button BtnKeluar; private widget.Button BtnPrint; private widget.TextBox Kd2; private widget.editorpane LoadHTML; private widget.ScrollPane Scroll; private widget.TextBox TCari; private widget.ComboBox ThnCari; private widget.Button btnCari; private widget.InternalFrame internalFrame1; private widget.Label jLabel6; private widget.Label label11; private widget.Label label9; private widget.panelisi panelisi1; // End of variables declaration//GEN-END:variables private void prosesCari() { this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR)); try { htmlContent = new StringBuilder(); htmlContent.append( ""+ "Kode Akun"+ "Akun Rekening"+ "Januari"+ "Februari"+ "Maret"+ "April"+ "Mei"+ "Juni"+ "Juli"+ "Agustus"+ "September"+ "Oktober"+ "November"+ "Desember"+ ""+ ""+ "Saldo Awal"+ "Debet"+ "Kredit"+ "Saldo Akhir"+ "Saldo Awal"+ "Debet"+ "Kredit"+ "Saldo Akhir"+ "Saldo Awal"+ "Debet"+ "Kredit"+ "Saldo Akhir"+ "Saldo Awal"+ "Debet"+ "Kredit"+ "Saldo Akhir"+ "Saldo Awal"+ "Debet"+ "Kredit"+ "Saldo Akhir"+ "Saldo Awal"+ "Debet"+ "Kredit"+ "Saldo Akhir"+ "Saldo Awal"+ "Debet"+ "Kredit"+ "Saldo Akhir"+ "Saldo Awal"+ "Debet"+ "Kredit"+ "Saldo Akhir"+ "Saldo Awal"+ "Debet"+ "Kredit"+ "Saldo Akhir"+ "Saldo Awal"+ "Debet"+ "Kredit"+ "Saldo Akhir"+ "Saldo Awal"+ "Debet"+ "Kredit"+ "Saldo Akhir"+ "Saldo Awal"+ "Debet"+ "Kredit"+ "Saldo Akhir"+ "" ); ps=koneksi.prepareStatement("select kd_rek, nm_rek "+ " from rekening where level='0' and kd_rek like ? or "+ " level='0' and nm_rek like ? order by kd_rek"); try { ps.setString(1,"%"+TCari.getText().trim()+"%"); ps.setString(2,"%"+TCari.getText().trim()+"%"); rs=ps.executeQuery(); while(rs.next()){ saldoawaljanuari=Sequel.cariIsiAngka2("select saldo_awal from rekeningtahun where thn=? and kd_rek=?",ThnCari.getSelectedItem().toString(),rs.getString("kd_rek")); debetjanuari=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-01"+"%",rs.getString("kd_rek")); kreditjanuari=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-01"+"%",rs.getString("kd_rek")); saldoakhirjanuari=saldoawaljanuari+(debetjanuari-kreditjanuari); debetfebruari=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-02"+"%",rs.getString("kd_rek")); kreditfebruari=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-02"+"%",rs.getString("kd_rek")); saldoakhirfebruari=saldoakhirjanuari+(debetfebruari-kreditfebruari); debetmaret=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-03"+"%",rs.getString("kd_rek")); kreditmaret=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-03"+"%",rs.getString("kd_rek")); saldoakhirmaret=saldoakhirfebruari+(debetmaret-kreditmaret); debetapril=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-04"+"%",rs.getString("kd_rek")); kreditapril=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-04"+"%",rs.getString("kd_rek")); saldoakhirapril=saldoakhirmaret+(debetapril-kreditapril); debetmei=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-05"+"%",rs.getString("kd_rek")); kreditmei=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-05"+"%",rs.getString("kd_rek")); saldoakhirmei=saldoakhirapril+(debetmei-kreditmei); debetjuni=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-06"+"%",rs.getString("kd_rek")); kreditjuni=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-06"+"%",rs.getString("kd_rek")); saldoakhirjuni=saldoakhirmei+(debetjuni-kreditjuni); debetjuli=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-07"+"%",rs.getString("kd_rek")); kreditjuli=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-07"+"%",rs.getString("kd_rek")); saldoakhirjuli=saldoakhirjuni+(debetjuli-kreditjuli); debetagustus=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-08"+"%",rs.getString("kd_rek")); kreditagustus=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-08"+"%",rs.getString("kd_rek")); saldoakhiragustus=saldoakhirjuli+(debetagustus-kreditagustus); debetseptember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-09"+"%",rs.getString("kd_rek")); kreditseptember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-09"+"%",rs.getString("kd_rek")); saldoakhirseptember=saldoakhiragustus+(debetseptember-kreditseptember); debetoktober=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-10"+"%",rs.getString("kd_rek")); kreditoktober=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-10"+"%",rs.getString("kd_rek")); saldoakhiroktober=saldoakhirseptember+(debetoktober-kreditoktober); debetnovember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-11"+"%",rs.getString("kd_rek")); kreditnovember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-11"+"%",rs.getString("kd_rek")); saldoakhirnovember=saldoakhiroktober+(debetnovember-kreditnovember); debetdesember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-12"+"%",rs.getString("kd_rek")); kreditdesember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-12"+"%",rs.getString("kd_rek")); saldoakhirdesember=saldoakhirnovember+(debetdesember-kreditdesember); htmlContent.append( ""+ ""+rs.getString("kd_rek")+""+ ""+rs.getString("nm_rek")+""+ ""+Valid.SetAngka(saldoawaljanuari)+""+ ""+Valid.SetAngka(debetjanuari)+""+ ""+Valid.SetAngka(kreditjanuari)+""+ ""+Valid.SetAngka(saldoakhirjanuari)+""+ ""+Valid.SetAngka(saldoakhirjanuari)+""+ ""+Valid.SetAngka(debetfebruari)+""+ ""+Valid.SetAngka(kreditfebruari)+""+ ""+Valid.SetAngka(saldoakhirfebruari)+""+ ""+Valid.SetAngka(saldoakhirfebruari)+""+ ""+Valid.SetAngka(debetmaret)+""+ ""+Valid.SetAngka(kreditmaret)+""+ ""+Valid.SetAngka(saldoakhirmaret)+""+ ""+Valid.SetAngka(saldoakhirmaret)+""+ ""+Valid.SetAngka(debetapril)+""+ ""+Valid.SetAngka(kreditapril)+""+ ""+Valid.SetAngka(saldoakhirapril)+""+ ""+Valid.SetAngka(saldoakhirapril)+""+ ""+Valid.SetAngka(debetmei)+""+ ""+Valid.SetAngka(kreditmei)+""+ ""+Valid.SetAngka(saldoakhirmei)+""+ ""+Valid.SetAngka(saldoakhirmei)+""+ ""+Valid.SetAngka(debetjuni)+""+ ""+Valid.SetAngka(kreditjuni)+""+ ""+Valid.SetAngka(saldoakhirjuni)+""+ ""+Valid.SetAngka(saldoakhirjuni)+""+ ""+Valid.SetAngka(debetjuli)+""+ ""+Valid.SetAngka(kreditjuli)+""+ ""+Valid.SetAngka(saldoakhirjuli)+""+ ""+Valid.SetAngka(saldoakhirjuli)+""+ ""+Valid.SetAngka(debetagustus)+""+ ""+Valid.SetAngka(kreditagustus)+""+ ""+Valid.SetAngka(saldoakhiragustus)+""+ ""+Valid.SetAngka(saldoakhiragustus)+""+ ""+Valid.SetAngka(debetseptember)+""+ ""+Valid.SetAngka(kreditseptember)+""+ ""+Valid.SetAngka(saldoakhirseptember)+""+ ""+Valid.SetAngka(saldoakhirseptember)+""+ ""+Valid.SetAngka(debetoktober)+""+ ""+Valid.SetAngka(kreditoktober)+""+ ""+Valid.SetAngka(saldoakhiroktober)+""+ ""+Valid.SetAngka(saldoakhiroktober)+""+ ""+Valid.SetAngka(debetnovember)+""+ ""+Valid.SetAngka(kreditnovember)+""+ ""+Valid.SetAngka(saldoakhirnovember)+""+ ""+Valid.SetAngka(saldoakhirnovember)+""+ ""+Valid.SetAngka(debetdesember)+""+ ""+Valid.SetAngka(kreditdesember)+""+ ""+Valid.SetAngka(saldoakhirdesember)+""+ "" ); ps2=koneksi.prepareStatement("select rekening.kd_rek, rekening.nm_rek "+ " from rekening inner join subrekening on rekening.kd_rek=subrekening.kd_rek2 "+ " where subrekening.kd_rek=? and rekening.level='1' and rekening.kd_rek like ? or "+ " subrekening.kd_rek=? and rekening.level='1' and rekening.nm_rek like ? order by rekening.kd_rek"); try { ps2.setString(1,rs.getString("kd_rek")); ps2.setString(2,"%"+TCari.getText().trim()+"%"); ps2.setString(3,rs.getString("kd_rek")); ps2.setString(4,"%"+TCari.getText().trim()+"%"); rs2=ps2.executeQuery(); while(rs2.next()){ saldoawaljanuari=Sequel.cariIsiAngka2("select saldo_awal from rekeningtahun where thn=? and kd_rek=?",ThnCari.getSelectedItem().toString(),rs2.getString("kd_rek")); debetjanuari=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-01"+"%",rs2.getString("kd_rek")); kreditjanuari=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-01"+"%",rs2.getString("kd_rek")); saldoakhirjanuari=saldoawaljanuari+(debetjanuari-kreditjanuari); debetfebruari=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-02"+"%",rs2.getString("kd_rek")); kreditfebruari=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-02"+"%",rs2.getString("kd_rek")); saldoakhirfebruari=saldoakhirjanuari+(debetfebruari-kreditfebruari); debetmaret=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-03"+"%",rs2.getString("kd_rek")); kreditmaret=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-03"+"%",rs2.getString("kd_rek")); saldoakhirmaret=saldoakhirfebruari+(debetmaret-kreditmaret); debetapril=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-04"+"%",rs2.getString("kd_rek")); kreditapril=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-04"+"%",rs2.getString("kd_rek")); saldoakhirapril=saldoakhirmaret+(debetapril-kreditapril); debetmei=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-05"+"%",rs2.getString("kd_rek")); kreditmei=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-05"+"%",rs2.getString("kd_rek")); saldoakhirmei=saldoakhirapril+(debetmei-kreditmei); debetjuni=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-06"+"%",rs2.getString("kd_rek")); kreditjuni=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-06"+"%",rs2.getString("kd_rek")); saldoakhirjuni=saldoakhirmei+(debetjuni-kreditjuni); debetjuli=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-07"+"%",rs2.getString("kd_rek")); kreditjuli=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-07"+"%",rs2.getString("kd_rek")); saldoakhirjuli=saldoakhirjuni+(debetjuli-kreditjuli); debetagustus=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-08"+"%",rs2.getString("kd_rek")); kreditagustus=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-08"+"%",rs2.getString("kd_rek")); saldoakhiragustus=saldoakhirjuli+(debetagustus-kreditagustus); debetseptember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-09"+"%",rs2.getString("kd_rek")); kreditseptember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-09"+"%",rs2.getString("kd_rek")); saldoakhirseptember=saldoakhiragustus+(debetseptember-kreditseptember); debetoktober=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-10"+"%",rs2.getString("kd_rek")); kreditoktober=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-10"+"%",rs2.getString("kd_rek")); saldoakhiroktober=saldoakhirseptember+(debetoktober-kreditoktober); debetnovember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-11"+"%",rs2.getString("kd_rek")); kreditnovember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-11"+"%",rs2.getString("kd_rek")); saldoakhirnovember=saldoakhiroktober+(debetnovember-kreditnovember); debetdesember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-12"+"%",rs2.getString("kd_rek")); kreditdesember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-12"+"%",rs2.getString("kd_rek")); saldoakhirdesember=saldoakhirnovember+(debetdesember-kreditdesember); htmlContent.append( ""+ " "+rs2.getString("kd_rek")+""+ " "+rs2.getString("nm_rek")+""+ ""+Valid.SetAngka(saldoawaljanuari)+""+ ""+Valid.SetAngka(debetjanuari)+""+ ""+Valid.SetAngka(kreditjanuari)+""+ ""+Valid.SetAngka(saldoakhirjanuari)+""+ ""+Valid.SetAngka(saldoakhirjanuari)+""+ ""+Valid.SetAngka(debetfebruari)+""+ ""+Valid.SetAngka(kreditfebruari)+""+ ""+Valid.SetAngka(saldoakhirfebruari)+""+ ""+Valid.SetAngka(saldoakhirfebruari)+""+ ""+Valid.SetAngka(debetmaret)+""+ ""+Valid.SetAngka(kreditmaret)+""+ ""+Valid.SetAngka(saldoakhirmaret)+""+ ""+Valid.SetAngka(saldoakhirmaret)+""+ ""+Valid.SetAngka(debetapril)+""+ ""+Valid.SetAngka(kreditapril)+""+ ""+Valid.SetAngka(saldoakhirapril)+""+ ""+Valid.SetAngka(saldoakhirapril)+""+ ""+Valid.SetAngka(debetmei)+""+ ""+Valid.SetAngka(kreditmei)+""+ ""+Valid.SetAngka(saldoakhirmei)+""+ ""+Valid.SetAngka(saldoakhirmei)+""+ ""+Valid.SetAngka(debetjuni)+""+ ""+Valid.SetAngka(kreditjuni)+""+ ""+Valid.SetAngka(saldoakhirjuni)+""+ ""+Valid.SetAngka(saldoakhirjuni)+""+ ""+Valid.SetAngka(debetjuli)+""+ ""+Valid.SetAngka(kreditjuli)+""+ ""+Valid.SetAngka(saldoakhirjuli)+""+ ""+Valid.SetAngka(saldoakhirjuli)+""+ ""+Valid.SetAngka(debetagustus)+""+ ""+Valid.SetAngka(kreditagustus)+""+ ""+Valid.SetAngka(saldoakhiragustus)+""+ ""+Valid.SetAngka(saldoakhiragustus)+""+ ""+Valid.SetAngka(debetseptember)+""+ ""+Valid.SetAngka(kreditseptember)+""+ ""+Valid.SetAngka(saldoakhirseptember)+""+ ""+Valid.SetAngka(saldoakhirseptember)+""+ ""+Valid.SetAngka(debetoktober)+""+ ""+Valid.SetAngka(kreditoktober)+""+ ""+Valid.SetAngka(saldoakhiroktober)+""+ ""+Valid.SetAngka(saldoakhiroktober)+""+ ""+Valid.SetAngka(debetnovember)+""+ ""+Valid.SetAngka(kreditnovember)+""+ ""+Valid.SetAngka(saldoakhirnovember)+""+ ""+Valid.SetAngka(saldoakhirnovember)+""+ ""+Valid.SetAngka(debetdesember)+""+ ""+Valid.SetAngka(kreditdesember)+""+ ""+Valid.SetAngka(saldoakhirdesember)+""+ "" ); ps3=koneksi.prepareStatement("select rekening.kd_rek, rekening.nm_rek "+ " from rekening inner join subrekening on rekening.kd_rek=subrekening.kd_rek2 "+ " where subrekening.kd_rek=? and rekening.level='1' and rekening.kd_rek like ? or "+ " subrekening.kd_rek=? and rekening.level='1' and rekening.nm_rek like ? order by rekening.kd_rek"); try { ps3.setString(1,rs2.getString("kd_rek")); ps3.setString(2,"%"+TCari.getText().trim()+"%"); ps3.setString(3,rs2.getString("kd_rek")); ps3.setString(4,"%"+TCari.getText().trim()+"%"); rs3=ps3.executeQuery(); while(rs3.next()){ saldoawaljanuari=Sequel.cariIsiAngka2("select saldo_awal from rekeningtahun where thn=? and kd_rek=?",ThnCari.getSelectedItem().toString(),rs3.getString("kd_rek")); debetjanuari=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-01"+"%",rs3.getString("kd_rek")); kreditjanuari=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-01"+"%",rs3.getString("kd_rek")); saldoakhirjanuari=saldoawaljanuari+(debetjanuari-kreditjanuari); debetfebruari=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-02"+"%",rs3.getString("kd_rek")); kreditfebruari=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-02"+"%",rs3.getString("kd_rek")); saldoakhirfebruari=saldoakhirjanuari+(debetfebruari-kreditfebruari); debetmaret=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-03"+"%",rs3.getString("kd_rek")); kreditmaret=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-03"+"%",rs3.getString("kd_rek")); saldoakhirmaret=saldoakhirfebruari+(debetmaret-kreditmaret); debetapril=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-04"+"%",rs3.getString("kd_rek")); kreditapril=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-04"+"%",rs3.getString("kd_rek")); saldoakhirapril=saldoakhirmaret+(debetapril-kreditapril); debetmei=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-05"+"%",rs3.getString("kd_rek")); kreditmei=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-05"+"%",rs3.getString("kd_rek")); saldoakhirmei=saldoakhirapril+(debetmei-kreditmei); debetjuni=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-06"+"%",rs3.getString("kd_rek")); kreditjuni=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-06"+"%",rs3.getString("kd_rek")); saldoakhirjuni=saldoakhirmei+(debetjuni-kreditjuni); debetjuli=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-07"+"%",rs3.getString("kd_rek")); kreditjuli=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-07"+"%",rs3.getString("kd_rek")); saldoakhirjuli=saldoakhirjuni+(debetjuli-kreditjuli); debetagustus=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-08"+"%",rs3.getString("kd_rek")); kreditagustus=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-08"+"%",rs3.getString("kd_rek")); saldoakhiragustus=saldoakhirjuli+(debetagustus-kreditagustus); debetseptember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-09"+"%",rs3.getString("kd_rek")); kreditseptember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-09"+"%",rs3.getString("kd_rek")); saldoakhirseptember=saldoakhiragustus+(debetseptember-kreditseptember); debetoktober=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-10"+"%",rs3.getString("kd_rek")); kreditoktober=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-10"+"%",rs3.getString("kd_rek")); saldoakhiroktober=saldoakhirseptember+(debetoktober-kreditoktober); debetnovember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-11"+"%",rs3.getString("kd_rek")); kreditnovember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-11"+"%",rs3.getString("kd_rek")); saldoakhirnovember=saldoakhiroktober+(debetnovember-kreditnovember); debetdesember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-12"+"%",rs3.getString("kd_rek")); kreditdesember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-12"+"%",rs3.getString("kd_rek")); saldoakhirdesember=saldoakhirnovember+(debetdesember-kreditdesember); htmlContent.append( ""+ "  "+rs3.getString("kd_rek")+""+ "  "+rs3.getString("nm_rek")+""+ ""+Valid.SetAngka(saldoawaljanuari)+""+ ""+Valid.SetAngka(debetjanuari)+""+ ""+Valid.SetAngka(kreditjanuari)+""+ ""+Valid.SetAngka(saldoakhirjanuari)+""+ ""+Valid.SetAngka(saldoakhirjanuari)+""+ ""+Valid.SetAngka(debetfebruari)+""+ ""+Valid.SetAngka(kreditfebruari)+""+ ""+Valid.SetAngka(saldoakhirfebruari)+""+ ""+Valid.SetAngka(saldoakhirfebruari)+""+ ""+Valid.SetAngka(debetmaret)+""+ ""+Valid.SetAngka(kreditmaret)+""+ ""+Valid.SetAngka(saldoakhirmaret)+""+ ""+Valid.SetAngka(saldoakhirmaret)+""+ ""+Valid.SetAngka(debetapril)+""+ ""+Valid.SetAngka(kreditapril)+""+ ""+Valid.SetAngka(saldoakhirapril)+""+ ""+Valid.SetAngka(saldoakhirapril)+""+ ""+Valid.SetAngka(debetmei)+""+ ""+Valid.SetAngka(kreditmei)+""+ ""+Valid.SetAngka(saldoakhirmei)+""+ ""+Valid.SetAngka(saldoakhirmei)+""+ ""+Valid.SetAngka(debetjuni)+""+ ""+Valid.SetAngka(kreditjuni)+""+ ""+Valid.SetAngka(saldoakhirjuni)+""+ ""+Valid.SetAngka(saldoakhirjuni)+""+ ""+Valid.SetAngka(debetjuli)+""+ ""+Valid.SetAngka(kreditjuli)+""+ ""+Valid.SetAngka(saldoakhirjuli)+""+ ""+Valid.SetAngka(saldoakhirjuli)+""+ ""+Valid.SetAngka(debetagustus)+""+ ""+Valid.SetAngka(kreditagustus)+""+ ""+Valid.SetAngka(saldoakhiragustus)+""+ ""+Valid.SetAngka(saldoakhiragustus)+""+ ""+Valid.SetAngka(debetseptember)+""+ ""+Valid.SetAngka(kreditseptember)+""+ ""+Valid.SetAngka(saldoakhirseptember)+""+ ""+Valid.SetAngka(saldoakhirseptember)+""+ ""+Valid.SetAngka(debetoktober)+""+ ""+Valid.SetAngka(kreditoktober)+""+ ""+Valid.SetAngka(saldoakhiroktober)+""+ ""+Valid.SetAngka(saldoakhiroktober)+""+ ""+Valid.SetAngka(debetnovember)+""+ ""+Valid.SetAngka(kreditnovember)+""+ ""+Valid.SetAngka(saldoakhirnovember)+""+ ""+Valid.SetAngka(saldoakhirnovember)+""+ ""+Valid.SetAngka(debetdesember)+""+ ""+Valid.SetAngka(kreditdesember)+""+ ""+Valid.SetAngka(saldoakhirdesember)+""+ "" ); ps4=koneksi.prepareStatement("select rekening.kd_rek, rekening.nm_rek "+ " from rekening inner join subrekening on rekening.kd_rek=subrekening.kd_rek2 "+ " where subrekening.kd_rek=? and rekening.level='1' and rekening.kd_rek like ? or "+ " subrekening.kd_rek=? and rekening.level='1' and rekening.nm_rek like ? order by rekening.kd_rek"); try { ps4.setString(1,rs3.getString("kd_rek")); ps4.setString(2,"%"+TCari.getText().trim()+"%"); ps4.setString(3,rs3.getString("kd_rek")); ps4.setString(4,"%"+TCari.getText().trim()+"%"); rs4=ps4.executeQuery(); while(rs4.next()){ saldoawaljanuari=Sequel.cariIsiAngka2("select saldo_awal from rekeningtahun where thn=? and kd_rek=?",ThnCari.getSelectedItem().toString(),rs4.getString("kd_rek")); debetjanuari=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-01"+"%",rs4.getString("kd_rek")); kreditjanuari=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-01"+"%",rs4.getString("kd_rek")); saldoakhirjanuari=saldoawaljanuari+(debetjanuari-kreditjanuari); debetfebruari=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-02"+"%",rs4.getString("kd_rek")); kreditfebruari=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-02"+"%",rs4.getString("kd_rek")); saldoakhirfebruari=saldoakhirjanuari+(debetfebruari-kreditfebruari); debetmaret=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-03"+"%",rs4.getString("kd_rek")); kreditmaret=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-03"+"%",rs4.getString("kd_rek")); saldoakhirmaret=saldoakhirfebruari+(debetmaret-kreditmaret); debetapril=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-04"+"%",rs4.getString("kd_rek")); kreditapril=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-04"+"%",rs4.getString("kd_rek")); saldoakhirapril=saldoakhirmaret+(debetapril-kreditapril); debetmei=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-05"+"%",rs4.getString("kd_rek")); kreditmei=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-05"+"%",rs4.getString("kd_rek")); saldoakhirmei=saldoakhirapril+(debetmei-kreditmei); debetjuni=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-06"+"%",rs4.getString("kd_rek")); kreditjuni=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-06"+"%",rs4.getString("kd_rek")); saldoakhirjuni=saldoakhirmei+(debetjuni-kreditjuni); debetjuli=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-07"+"%",rs4.getString("kd_rek")); kreditjuli=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-07"+"%",rs4.getString("kd_rek")); saldoakhirjuli=saldoakhirjuni+(debetjuli-kreditjuli); debetagustus=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-08"+"%",rs4.getString("kd_rek")); kreditagustus=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-08"+"%",rs4.getString("kd_rek")); saldoakhiragustus=saldoakhirjuli+(debetagustus-kreditagustus); debetseptember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-09"+"%",rs4.getString("kd_rek")); kreditseptember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-09"+"%",rs4.getString("kd_rek")); saldoakhirseptember=saldoakhiragustus+(debetseptember-kreditseptember); debetoktober=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-10"+"%",rs4.getString("kd_rek")); kreditoktober=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-10"+"%",rs4.getString("kd_rek")); saldoakhiroktober=saldoakhirseptember+(debetoktober-kreditoktober); debetnovember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-11"+"%",rs4.getString("kd_rek")); kreditnovember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-11"+"%",rs4.getString("kd_rek")); saldoakhirnovember=saldoakhiroktober+(debetnovember-kreditnovember); debetdesember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-12"+"%",rs4.getString("kd_rek")); kreditdesember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-12"+"%",rs4.getString("kd_rek")); saldoakhirdesember=saldoakhirnovember+(debetdesember-kreditdesember); htmlContent.append( ""+ "   "+rs4.getString("kd_rek")+""+ "   "+rs4.getString("nm_rek")+""+ ""+Valid.SetAngka(saldoawaljanuari)+""+ ""+Valid.SetAngka(debetjanuari)+""+ ""+Valid.SetAngka(kreditjanuari)+""+ ""+Valid.SetAngka(saldoakhirjanuari)+""+ ""+Valid.SetAngka(saldoakhirjanuari)+""+ ""+Valid.SetAngka(debetfebruari)+""+ ""+Valid.SetAngka(kreditfebruari)+""+ ""+Valid.SetAngka(saldoakhirfebruari)+""+ ""+Valid.SetAngka(saldoakhirfebruari)+""+ ""+Valid.SetAngka(debetmaret)+""+ ""+Valid.SetAngka(kreditmaret)+""+ ""+Valid.SetAngka(saldoakhirmaret)+""+ ""+Valid.SetAngka(saldoakhirmaret)+""+ ""+Valid.SetAngka(debetapril)+""+ ""+Valid.SetAngka(kreditapril)+""+ ""+Valid.SetAngka(saldoakhirapril)+""+ ""+Valid.SetAngka(saldoakhirapril)+""+ ""+Valid.SetAngka(debetmei)+""+ ""+Valid.SetAngka(kreditmei)+""+ ""+Valid.SetAngka(saldoakhirmei)+""+ ""+Valid.SetAngka(saldoakhirmei)+""+ ""+Valid.SetAngka(debetjuni)+""+ ""+Valid.SetAngka(kreditjuni)+""+ ""+Valid.SetAngka(saldoakhirjuni)+""+ ""+Valid.SetAngka(saldoakhirjuni)+""+ ""+Valid.SetAngka(debetjuli)+""+ ""+Valid.SetAngka(kreditjuli)+""+ ""+Valid.SetAngka(saldoakhirjuli)+""+ ""+Valid.SetAngka(saldoakhirjuli)+""+ ""+Valid.SetAngka(debetagustus)+""+ ""+Valid.SetAngka(kreditagustus)+""+ ""+Valid.SetAngka(saldoakhiragustus)+""+ ""+Valid.SetAngka(saldoakhiragustus)+""+ ""+Valid.SetAngka(debetseptember)+""+ ""+Valid.SetAngka(kreditseptember)+""+ ""+Valid.SetAngka(saldoakhirseptember)+""+ ""+Valid.SetAngka(saldoakhirseptember)+""+ ""+Valid.SetAngka(debetoktober)+""+ ""+Valid.SetAngka(kreditoktober)+""+ ""+Valid.SetAngka(saldoakhiroktober)+""+ ""+Valid.SetAngka(saldoakhiroktober)+""+ ""+Valid.SetAngka(debetnovember)+""+ ""+Valid.SetAngka(kreditnovember)+""+ ""+Valid.SetAngka(saldoakhirnovember)+""+ ""+Valid.SetAngka(saldoakhirnovember)+""+ ""+Valid.SetAngka(debetdesember)+""+ ""+Valid.SetAngka(kreditdesember)+""+ ""+Valid.SetAngka(saldoakhirdesember)+""+ "" ); ps5=koneksi.prepareStatement("select rekening.kd_rek, rekening.nm_rek "+ " from rekening inner join subrekening on rekening.kd_rek=subrekening.kd_rek2 "+ " where subrekening.kd_rek=? and rekening.level='1' and rekening.kd_rek like ? or "+ " subrekening.kd_rek=? and rekening.level='1' and rekening.nm_rek like ? order by rekening.kd_rek"); try { ps5.setString(1,rs4.getString("kd_rek")); ps5.setString(2,"%"+TCari.getText().trim()+"%"); ps5.setString(3,rs4.getString("kd_rek")); ps5.setString(4,"%"+TCari.getText().trim()+"%"); rs5=ps5.executeQuery(); while(rs5.next()){ saldoawaljanuari=Sequel.cariIsiAngka2("select saldo_awal from rekeningtahun where thn=? and kd_rek=?",ThnCari.getSelectedItem().toString(),rs5.getString("kd_rek")); debetjanuari=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-01"+"%",rs5.getString("kd_rek")); kreditjanuari=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-01"+"%",rs5.getString("kd_rek")); saldoakhirjanuari=saldoawaljanuari+(debetjanuari-kreditjanuari); debetfebruari=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-02"+"%",rs5.getString("kd_rek")); kreditfebruari=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-02"+"%",rs5.getString("kd_rek")); saldoakhirfebruari=saldoakhirjanuari+(debetfebruari-kreditfebruari); debetmaret=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-03"+"%",rs5.getString("kd_rek")); kreditmaret=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-03"+"%",rs5.getString("kd_rek")); saldoakhirmaret=saldoakhirfebruari+(debetmaret-kreditmaret); debetapril=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-04"+"%",rs5.getString("kd_rek")); kreditapril=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-04"+"%",rs5.getString("kd_rek")); saldoakhirapril=saldoakhirmaret+(debetapril-kreditapril); debetmei=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-05"+"%",rs5.getString("kd_rek")); kreditmei=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-05"+"%",rs5.getString("kd_rek")); saldoakhirmei=saldoakhirapril+(debetmei-kreditmei); debetjuni=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-06"+"%",rs5.getString("kd_rek")); kreditjuni=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-06"+"%",rs5.getString("kd_rek")); saldoakhirjuni=saldoakhirmei+(debetjuni-kreditjuni); debetjuli=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-07"+"%",rs5.getString("kd_rek")); kreditjuli=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-07"+"%",rs5.getString("kd_rek")); saldoakhirjuli=saldoakhirjuni+(debetjuli-kreditjuli); debetagustus=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-08"+"%",rs5.getString("kd_rek")); kreditagustus=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-08"+"%",rs5.getString("kd_rek")); saldoakhiragustus=saldoakhirjuli+(debetagustus-kreditagustus); debetseptember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-09"+"%",rs5.getString("kd_rek")); kreditseptember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-09"+"%",rs5.getString("kd_rek")); saldoakhirseptember=saldoakhiragustus+(debetseptember-kreditseptember); debetoktober=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-10"+"%",rs5.getString("kd_rek")); kreditoktober=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-10"+"%",rs5.getString("kd_rek")); saldoakhiroktober=saldoakhirseptember+(debetoktober-kreditoktober); debetnovember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-11"+"%",rs5.getString("kd_rek")); kreditnovember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-11"+"%",rs5.getString("kd_rek")); saldoakhirnovember=saldoakhiroktober+(debetnovember-kreditnovember); debetdesember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-12"+"%",rs5.getString("kd_rek")); kreditdesember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-12"+"%",rs5.getString("kd_rek")); saldoakhirdesember=saldoakhirnovember+(debetdesember-kreditdesember); htmlContent.append( ""+ "    "+rs5.getString("kd_rek")+""+ "    "+rs5.getString("nm_rek")+""+ ""+Valid.SetAngka(saldoawaljanuari)+""+ ""+Valid.SetAngka(debetjanuari)+""+ ""+Valid.SetAngka(kreditjanuari)+""+ ""+Valid.SetAngka(saldoakhirjanuari)+""+ ""+Valid.SetAngka(saldoakhirjanuari)+""+ ""+Valid.SetAngka(debetfebruari)+""+ ""+Valid.SetAngka(kreditfebruari)+""+ ""+Valid.SetAngka(saldoakhirfebruari)+""+ ""+Valid.SetAngka(saldoakhirfebruari)+""+ ""+Valid.SetAngka(debetmaret)+""+ ""+Valid.SetAngka(kreditmaret)+""+ ""+Valid.SetAngka(saldoakhirmaret)+""+ ""+Valid.SetAngka(saldoakhirmaret)+""+ ""+Valid.SetAngka(debetapril)+""+ ""+Valid.SetAngka(kreditapril)+""+ ""+Valid.SetAngka(saldoakhirapril)+""+ ""+Valid.SetAngka(saldoakhirapril)+""+ ""+Valid.SetAngka(debetmei)+""+ ""+Valid.SetAngka(kreditmei)+""+ ""+Valid.SetAngka(saldoakhirmei)+""+ ""+Valid.SetAngka(saldoakhirmei)+""+ ""+Valid.SetAngka(debetjuni)+""+ ""+Valid.SetAngka(kreditjuni)+""+ ""+Valid.SetAngka(saldoakhirjuni)+""+ ""+Valid.SetAngka(saldoakhirjuni)+""+ ""+Valid.SetAngka(debetjuli)+""+ ""+Valid.SetAngka(kreditjuli)+""+ ""+Valid.SetAngka(saldoakhirjuli)+""+ ""+Valid.SetAngka(saldoakhirjuli)+""+ ""+Valid.SetAngka(debetagustus)+""+ ""+Valid.SetAngka(kreditagustus)+""+ ""+Valid.SetAngka(saldoakhiragustus)+""+ ""+Valid.SetAngka(saldoakhiragustus)+""+ ""+Valid.SetAngka(debetseptember)+""+ ""+Valid.SetAngka(kreditseptember)+""+ ""+Valid.SetAngka(saldoakhirseptember)+""+ ""+Valid.SetAngka(saldoakhirseptember)+""+ ""+Valid.SetAngka(debetoktober)+""+ ""+Valid.SetAngka(kreditoktober)+""+ ""+Valid.SetAngka(saldoakhiroktober)+""+ ""+Valid.SetAngka(saldoakhiroktober)+""+ ""+Valid.SetAngka(debetnovember)+""+ ""+Valid.SetAngka(kreditnovember)+""+ ""+Valid.SetAngka(saldoakhirnovember)+""+ ""+Valid.SetAngka(saldoakhirnovember)+""+ ""+Valid.SetAngka(debetdesember)+""+ ""+Valid.SetAngka(kreditdesember)+""+ ""+Valid.SetAngka(saldoakhirdesember)+""+ "" ); ps6=koneksi.prepareStatement("select rekening.kd_rek, rekening.nm_rek "+ " from rekening inner join subrekening on rekening.kd_rek=subrekening.kd_rek2 "+ " where subrekening.kd_rek=? and rekening.level='1' and rekening.kd_rek like ? or "+ " subrekening.kd_rek=? and rekening.level='1' and rekening.nm_rek like ? order by rekening.kd_rek"); try { ps6.setString(1,rs5.getString("kd_rek")); ps6.setString(2,"%"+TCari.getText().trim()+"%"); ps6.setString(3,rs5.getString("kd_rek")); ps6.setString(4,"%"+TCari.getText().trim()+"%"); rs6=ps6.executeQuery(); while(rs6.next()){ saldoawaljanuari=Sequel.cariIsiAngka2("select saldo_awal from rekeningtahun where thn=? and kd_rek=?",ThnCari.getSelectedItem().toString(),rs6.getString("kd_rek")); debetjanuari=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-01"+"%",rs6.getString("kd_rek")); kreditjanuari=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-01"+"%",rs6.getString("kd_rek")); saldoakhirjanuari=saldoawaljanuari+(debetjanuari-kreditjanuari); debetfebruari=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-02"+"%",rs6.getString("kd_rek")); kreditfebruari=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-02"+"%",rs6.getString("kd_rek")); saldoakhirfebruari=saldoakhirjanuari+(debetfebruari-kreditfebruari); debetmaret=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-03"+"%",rs6.getString("kd_rek")); kreditmaret=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-03"+"%",rs6.getString("kd_rek")); saldoakhirmaret=saldoakhirfebruari+(debetmaret-kreditmaret); debetapril=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-04"+"%",rs6.getString("kd_rek")); kreditapril=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-04"+"%",rs6.getString("kd_rek")); saldoakhirapril=saldoakhirmaret+(debetapril-kreditapril); debetmei=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-05"+"%",rs6.getString("kd_rek")); kreditmei=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-05"+"%",rs6.getString("kd_rek")); saldoakhirmei=saldoakhirapril+(debetmei-kreditmei); debetjuni=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-06"+"%",rs6.getString("kd_rek")); kreditjuni=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-06"+"%",rs6.getString("kd_rek")); saldoakhirjuni=saldoakhirmei+(debetjuni-kreditjuni); debetjuli=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-07"+"%",rs6.getString("kd_rek")); kreditjuli=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-07"+"%",rs6.getString("kd_rek")); saldoakhirjuli=saldoakhirjuni+(debetjuli-kreditjuli); debetagustus=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-08"+"%",rs6.getString("kd_rek")); kreditagustus=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-08"+"%",rs6.getString("kd_rek")); saldoakhiragustus=saldoakhirjuli+(debetagustus-kreditagustus); debetseptember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-09"+"%",rs6.getString("kd_rek")); kreditseptember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-09"+"%",rs6.getString("kd_rek")); saldoakhirseptember=saldoakhiragustus+(debetseptember-kreditseptember); debetoktober=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-10"+"%",rs6.getString("kd_rek")); kreditoktober=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-10"+"%",rs6.getString("kd_rek")); saldoakhiroktober=saldoakhirseptember+(debetoktober-kreditoktober); debetnovember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-11"+"%",rs6.getString("kd_rek")); kreditnovember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-11"+"%",rs6.getString("kd_rek")); saldoakhirnovember=saldoakhiroktober+(debetnovember-kreditnovember); debetdesember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-12"+"%",rs6.getString("kd_rek")); kreditdesember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-12"+"%",rs6.getString("kd_rek")); saldoakhirdesember=saldoakhirnovember+(debetdesember-kreditdesember); htmlContent.append( ""+ "     "+rs6.getString("kd_rek")+""+ "     "+rs6.getString("nm_rek")+""+ ""+Valid.SetAngka(saldoawaljanuari)+""+ ""+Valid.SetAngka(debetjanuari)+""+ ""+Valid.SetAngka(kreditjanuari)+""+ ""+Valid.SetAngka(saldoakhirjanuari)+""+ ""+Valid.SetAngka(saldoakhirjanuari)+""+ ""+Valid.SetAngka(debetfebruari)+""+ ""+Valid.SetAngka(kreditfebruari)+""+ ""+Valid.SetAngka(saldoakhirfebruari)+""+ ""+Valid.SetAngka(saldoakhirfebruari)+""+ ""+Valid.SetAngka(debetmaret)+""+ ""+Valid.SetAngka(kreditmaret)+""+ ""+Valid.SetAngka(saldoakhirmaret)+""+ ""+Valid.SetAngka(saldoakhirmaret)+""+ ""+Valid.SetAngka(debetapril)+""+ ""+Valid.SetAngka(kreditapril)+""+ ""+Valid.SetAngka(saldoakhirapril)+""+ ""+Valid.SetAngka(saldoakhirapril)+""+ ""+Valid.SetAngka(debetmei)+""+ ""+Valid.SetAngka(kreditmei)+""+ ""+Valid.SetAngka(saldoakhirmei)+""+ ""+Valid.SetAngka(saldoakhirmei)+""+ ""+Valid.SetAngka(debetjuni)+""+ ""+Valid.SetAngka(kreditjuni)+""+ ""+Valid.SetAngka(saldoakhirjuni)+""+ ""+Valid.SetAngka(saldoakhirjuni)+""+ ""+Valid.SetAngka(debetjuli)+""+ ""+Valid.SetAngka(kreditjuli)+""+ ""+Valid.SetAngka(saldoakhirjuli)+""+ ""+Valid.SetAngka(saldoakhirjuli)+""+ ""+Valid.SetAngka(debetagustus)+""+ ""+Valid.SetAngka(kreditagustus)+""+ ""+Valid.SetAngka(saldoakhiragustus)+""+ ""+Valid.SetAngka(saldoakhiragustus)+""+ ""+Valid.SetAngka(debetseptember)+""+ ""+Valid.SetAngka(kreditseptember)+""+ ""+Valid.SetAngka(saldoakhirseptember)+""+ ""+Valid.SetAngka(saldoakhirseptember)+""+ ""+Valid.SetAngka(debetoktober)+""+ ""+Valid.SetAngka(kreditoktober)+""+ ""+Valid.SetAngka(saldoakhiroktober)+""+ ""+Valid.SetAngka(saldoakhiroktober)+""+ ""+Valid.SetAngka(debetnovember)+""+ ""+Valid.SetAngka(kreditnovember)+""+ ""+Valid.SetAngka(saldoakhirnovember)+""+ ""+Valid.SetAngka(saldoakhirnovember)+""+ ""+Valid.SetAngka(debetdesember)+""+ ""+Valid.SetAngka(kreditdesember)+""+ ""+Valid.SetAngka(saldoakhirdesember)+""+ "" ); ps7=koneksi.prepareStatement("select rekening.kd_rek, rekening.nm_rek "+ " from rekening inner join subrekening on rekening.kd_rek=subrekening.kd_rek2 "+ " where subrekening.kd_rek=? and rekening.level='1' and rekening.kd_rek like ? or "+ " subrekening.kd_rek=? and rekening.level='1' and rekening.nm_rek like ? order by rekening.kd_rek"); try { ps7.setString(1,rs6.getString("kd_rek")); ps7.setString(2,"%"+TCari.getText().trim()+"%"); ps7.setString(3,rs6.getString("kd_rek")); ps7.setString(4,"%"+TCari.getText().trim()+"%"); rs7=ps7.executeQuery(); while(rs7.next()){ saldoawaljanuari=Sequel.cariIsiAngka2("select saldo_awal from rekeningtahun where thn=? and kd_rek=?",ThnCari.getSelectedItem().toString(),rs7.getString("kd_rek")); debetjanuari=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-01"+"%",rs7.getString("kd_rek")); kreditjanuari=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-01"+"%",rs7.getString("kd_rek")); saldoakhirjanuari=saldoawaljanuari+(debetjanuari-kreditjanuari); debetfebruari=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-02"+"%",rs7.getString("kd_rek")); kreditfebruari=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-02"+"%",rs7.getString("kd_rek")); saldoakhirfebruari=saldoakhirjanuari+(debetfebruari-kreditfebruari); debetmaret=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-03"+"%",rs7.getString("kd_rek")); kreditmaret=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-03"+"%",rs7.getString("kd_rek")); saldoakhirmaret=saldoakhirfebruari+(debetmaret-kreditmaret); debetapril=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-04"+"%",rs7.getString("kd_rek")); kreditapril=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-04"+"%",rs7.getString("kd_rek")); saldoakhirapril=saldoakhirmaret+(debetapril-kreditapril); debetmei=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-05"+"%",rs7.getString("kd_rek")); kreditmei=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-05"+"%",rs7.getString("kd_rek")); saldoakhirmei=saldoakhirapril+(debetmei-kreditmei); debetjuni=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-06"+"%",rs7.getString("kd_rek")); kreditjuni=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-06"+"%",rs7.getString("kd_rek")); saldoakhirjuni=saldoakhirmei+(debetjuni-kreditjuni); debetjuli=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-07"+"%",rs7.getString("kd_rek")); kreditjuli=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-07"+"%",rs7.getString("kd_rek")); saldoakhirjuli=saldoakhirjuni+(debetjuli-kreditjuli); debetagustus=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-08"+"%",rs7.getString("kd_rek")); kreditagustus=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-08"+"%",rs7.getString("kd_rek")); saldoakhiragustus=saldoakhirjuli+(debetagustus-kreditagustus); debetseptember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-09"+"%",rs7.getString("kd_rek")); kreditseptember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-09"+"%",rs7.getString("kd_rek")); saldoakhirseptember=saldoakhiragustus+(debetseptember-kreditseptember); debetoktober=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-10"+"%",rs7.getString("kd_rek")); kreditoktober=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-10"+"%",rs7.getString("kd_rek")); saldoakhiroktober=saldoakhirseptember+(debetoktober-kreditoktober); debetnovember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-11"+"%",rs7.getString("kd_rek")); kreditnovember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-11"+"%",rs7.getString("kd_rek")); saldoakhirnovember=saldoakhiroktober+(debetnovember-kreditnovember); debetdesember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-12"+"%",rs7.getString("kd_rek")); kreditdesember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-12"+"%",rs7.getString("kd_rek")); saldoakhirdesember=saldoakhirnovember+(debetdesember-kreditdesember); htmlContent.append( ""+ "      "+rs7.getString("kd_rek")+""+ "      "+rs7.getString("nm_rek")+""+ ""+Valid.SetAngka(saldoawaljanuari)+""+ ""+Valid.SetAngka(debetjanuari)+""+ ""+Valid.SetAngka(kreditjanuari)+""+ ""+Valid.SetAngka(saldoakhirjanuari)+""+ ""+Valid.SetAngka(saldoakhirjanuari)+""+ ""+Valid.SetAngka(debetfebruari)+""+ ""+Valid.SetAngka(kreditfebruari)+""+ ""+Valid.SetAngka(saldoakhirfebruari)+""+ ""+Valid.SetAngka(saldoakhirfebruari)+""+ ""+Valid.SetAngka(debetmaret)+""+ ""+Valid.SetAngka(kreditmaret)+""+ ""+Valid.SetAngka(saldoakhirmaret)+""+ ""+Valid.SetAngka(saldoakhirmaret)+""+ ""+Valid.SetAngka(debetapril)+""+ ""+Valid.SetAngka(kreditapril)+""+ ""+Valid.SetAngka(saldoakhirapril)+""+ ""+Valid.SetAngka(saldoakhirapril)+""+ ""+Valid.SetAngka(debetmei)+""+ ""+Valid.SetAngka(kreditmei)+""+ ""+Valid.SetAngka(saldoakhirmei)+""+ ""+Valid.SetAngka(saldoakhirmei)+""+ ""+Valid.SetAngka(debetjuni)+""+ ""+Valid.SetAngka(kreditjuni)+""+ ""+Valid.SetAngka(saldoakhirjuni)+""+ ""+Valid.SetAngka(saldoakhirjuni)+""+ ""+Valid.SetAngka(debetjuli)+""+ ""+Valid.SetAngka(kreditjuli)+""+ ""+Valid.SetAngka(saldoakhirjuli)+""+ ""+Valid.SetAngka(saldoakhirjuli)+""+ ""+Valid.SetAngka(debetagustus)+""+ ""+Valid.SetAngka(kreditagustus)+""+ ""+Valid.SetAngka(saldoakhiragustus)+""+ ""+Valid.SetAngka(saldoakhiragustus)+""+ ""+Valid.SetAngka(debetseptember)+""+ ""+Valid.SetAngka(kreditseptember)+""+ ""+Valid.SetAngka(saldoakhirseptember)+""+ ""+Valid.SetAngka(saldoakhirseptember)+""+ ""+Valid.SetAngka(debetoktober)+""+ ""+Valid.SetAngka(kreditoktober)+""+ ""+Valid.SetAngka(saldoakhiroktober)+""+ ""+Valid.SetAngka(saldoakhiroktober)+""+ ""+Valid.SetAngka(debetnovember)+""+ ""+Valid.SetAngka(kreditnovember)+""+ ""+Valid.SetAngka(saldoakhirnovember)+""+ ""+Valid.SetAngka(saldoakhirnovember)+""+ ""+Valid.SetAngka(debetdesember)+""+ ""+Valid.SetAngka(kreditdesember)+""+ ""+Valid.SetAngka(saldoakhirdesember)+""+ "" ); ps8=koneksi.prepareStatement("select rekening.kd_rek, rekening.nm_rek "+ " from rekening inner join subrekening on rekening.kd_rek=subrekening.kd_rek2 "+ " where subrekening.kd_rek=? and rekening.level='1' and rekening.kd_rek like ? or "+ " subrekening.kd_rek=? and rekening.level='1' and rekening.nm_rek like ? order by rekening.kd_rek"); try { ps8.setString(1,rs7.getString("kd_rek")); ps8.setString(2,"%"+TCari.getText().trim()+"%"); ps8.setString(3,rs7.getString("kd_rek")); ps8.setString(4,"%"+TCari.getText().trim()+"%"); rs8=ps8.executeQuery(); while(rs8.next()){ saldoawaljanuari=Sequel.cariIsiAngka2("select saldo_awal from rekeningtahun where thn=? and kd_rek=?",ThnCari.getSelectedItem().toString(),rs8.getString("kd_rek")); debetjanuari=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-01"+"%",rs8.getString("kd_rek")); kreditjanuari=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-01"+"%",rs8.getString("kd_rek")); saldoakhirjanuari=saldoawaljanuari+(debetjanuari-kreditjanuari); debetfebruari=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-02"+"%",rs8.getString("kd_rek")); kreditfebruari=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-02"+"%",rs8.getString("kd_rek")); saldoakhirfebruari=saldoakhirjanuari+(debetfebruari-kreditfebruari); debetmaret=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-03"+"%",rs8.getString("kd_rek")); kreditmaret=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-03"+"%",rs8.getString("kd_rek")); saldoakhirmaret=saldoakhirfebruari+(debetmaret-kreditmaret); debetapril=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-04"+"%",rs8.getString("kd_rek")); kreditapril=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-04"+"%",rs8.getString("kd_rek")); saldoakhirapril=saldoakhirmaret+(debetapril-kreditapril); debetmei=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-05"+"%",rs8.getString("kd_rek")); kreditmei=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-05"+"%",rs8.getString("kd_rek")); saldoakhirmei=saldoakhirapril+(debetmei-kreditmei); debetjuni=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-06"+"%",rs8.getString("kd_rek")); kreditjuni=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-06"+"%",rs8.getString("kd_rek")); saldoakhirjuni=saldoakhirmei+(debetjuni-kreditjuni); debetjuli=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-07"+"%",rs8.getString("kd_rek")); kreditjuli=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-07"+"%",rs8.getString("kd_rek")); saldoakhirjuli=saldoakhirjuni+(debetjuli-kreditjuli); debetagustus=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-08"+"%",rs8.getString("kd_rek")); kreditagustus=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-08"+"%",rs8.getString("kd_rek")); saldoakhiragustus=saldoakhirjuli+(debetagustus-kreditagustus); debetseptember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-09"+"%",rs8.getString("kd_rek")); kreditseptember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-09"+"%",rs8.getString("kd_rek")); saldoakhirseptember=saldoakhiragustus+(debetseptember-kreditseptember); debetoktober=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-10"+"%",rs8.getString("kd_rek")); kreditoktober=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-10"+"%",rs8.getString("kd_rek")); saldoakhiroktober=saldoakhirseptember+(debetoktober-kreditoktober); debetnovember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-11"+"%",rs8.getString("kd_rek")); kreditnovember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-11"+"%",rs8.getString("kd_rek")); saldoakhirnovember=saldoakhiroktober+(debetnovember-kreditnovember); debetdesember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-12"+"%",rs8.getString("kd_rek")); kreditdesember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-12"+"%",rs8.getString("kd_rek")); saldoakhirdesember=saldoakhirnovember+(debetdesember-kreditdesember); htmlContent.append( ""+ "      "+rs8.getString("kd_rek")+""+ "      "+rs8.getString("nm_rek")+""+ ""+Valid.SetAngka(saldoawaljanuari)+""+ ""+Valid.SetAngka(debetjanuari)+""+ ""+Valid.SetAngka(kreditjanuari)+""+ ""+Valid.SetAngka(saldoakhirjanuari)+""+ ""+Valid.SetAngka(saldoakhirjanuari)+""+ ""+Valid.SetAngka(debetfebruari)+""+ ""+Valid.SetAngka(kreditfebruari)+""+ ""+Valid.SetAngka(saldoakhirfebruari)+""+ ""+Valid.SetAngka(saldoakhirfebruari)+""+ ""+Valid.SetAngka(debetmaret)+""+ ""+Valid.SetAngka(kreditmaret)+""+ ""+Valid.SetAngka(saldoakhirmaret)+""+ ""+Valid.SetAngka(saldoakhirmaret)+""+ ""+Valid.SetAngka(debetapril)+""+ ""+Valid.SetAngka(kreditapril)+""+ ""+Valid.SetAngka(saldoakhirapril)+""+ ""+Valid.SetAngka(saldoakhirapril)+""+ ""+Valid.SetAngka(debetmei)+""+ ""+Valid.SetAngka(kreditmei)+""+ ""+Valid.SetAngka(saldoakhirmei)+""+ ""+Valid.SetAngka(saldoakhirmei)+""+ ""+Valid.SetAngka(debetjuni)+""+ ""+Valid.SetAngka(kreditjuni)+""+ ""+Valid.SetAngka(saldoakhirjuni)+""+ ""+Valid.SetAngka(saldoakhirjuni)+""+ ""+Valid.SetAngka(debetjuli)+""+ ""+Valid.SetAngka(kreditjuli)+""+ ""+Valid.SetAngka(saldoakhirjuli)+""+ ""+Valid.SetAngka(saldoakhirjuli)+""+ ""+Valid.SetAngka(debetagustus)+""+ ""+Valid.SetAngka(kreditagustus)+""+ ""+Valid.SetAngka(saldoakhiragustus)+""+ ""+Valid.SetAngka(saldoakhiragustus)+""+ ""+Valid.SetAngka(debetseptember)+""+ ""+Valid.SetAngka(kreditseptember)+""+ ""+Valid.SetAngka(saldoakhirseptember)+""+ ""+Valid.SetAngka(saldoakhirseptember)+""+ ""+Valid.SetAngka(debetoktober)+""+ ""+Valid.SetAngka(kreditoktober)+""+ ""+Valid.SetAngka(saldoakhiroktober)+""+ ""+Valid.SetAngka(saldoakhiroktober)+""+ ""+Valid.SetAngka(debetnovember)+""+ ""+Valid.SetAngka(kreditnovember)+""+ ""+Valid.SetAngka(saldoakhirnovember)+""+ ""+Valid.SetAngka(saldoakhirnovember)+""+ ""+Valid.SetAngka(debetdesember)+""+ ""+Valid.SetAngka(kreditdesember)+""+ ""+Valid.SetAngka(saldoakhirdesember)+""+ "" ); ps9=koneksi.prepareStatement("select rekening.kd_rek, rekening.nm_rek "+ " from rekening inner join subrekening on rekening.kd_rek=subrekening.kd_rek2 "+ " where subrekening.kd_rek=? and rekening.level='1' and rekening.kd_rek like ? or "+ " subrekening.kd_rek=? and rekening.level='1' and rekening.nm_rek like ? order by rekening.kd_rek"); try { ps9.setString(1,rs8.getString("kd_rek")); ps9.setString(2,"%"+TCari.getText().trim()+"%"); ps9.setString(3,rs8.getString("kd_rek")); ps9.setString(4,"%"+TCari.getText().trim()+"%"); rs9=ps9.executeQuery(); while(rs9.next()){ saldoawaljanuari=Sequel.cariIsiAngka2("select saldo_awal from rekeningtahun where thn=? and kd_rek=?",ThnCari.getSelectedItem().toString(),rs9.getString("kd_rek")); debetjanuari=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-01"+"%",rs9.getString("kd_rek")); kreditjanuari=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-01"+"%",rs9.getString("kd_rek")); saldoakhirjanuari=saldoawaljanuari+(debetjanuari-kreditjanuari); debetfebruari=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-02"+"%",rs9.getString("kd_rek")); kreditfebruari=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-02"+"%",rs9.getString("kd_rek")); saldoakhirfebruari=saldoakhirjanuari+(debetfebruari-kreditfebruari); debetmaret=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-03"+"%",rs9.getString("kd_rek")); kreditmaret=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-03"+"%",rs9.getString("kd_rek")); saldoakhirmaret=saldoakhirfebruari+(debetmaret-kreditmaret); debetapril=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-04"+"%",rs9.getString("kd_rek")); kreditapril=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-04"+"%",rs9.getString("kd_rek")); saldoakhirapril=saldoakhirmaret+(debetapril-kreditapril); debetmei=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-05"+"%",rs9.getString("kd_rek")); kreditmei=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-05"+"%",rs9.getString("kd_rek")); saldoakhirmei=saldoakhirapril+(debetmei-kreditmei); debetjuni=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-06"+"%",rs9.getString("kd_rek")); kreditjuni=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-06"+"%",rs9.getString("kd_rek")); saldoakhirjuni=saldoakhirmei+(debetjuni-kreditjuni); debetjuli=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-07"+"%",rs9.getString("kd_rek")); kreditjuli=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-07"+"%",rs9.getString("kd_rek")); saldoakhirjuli=saldoakhirjuni+(debetjuli-kreditjuli); debetagustus=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-08"+"%",rs9.getString("kd_rek")); kreditagustus=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-08"+"%",rs9.getString("kd_rek")); saldoakhiragustus=saldoakhirjuli+(debetagustus-kreditagustus); debetseptember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-09"+"%",rs9.getString("kd_rek")); kreditseptember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-09"+"%",rs9.getString("kd_rek")); saldoakhirseptember=saldoakhiragustus+(debetseptember-kreditseptember); debetoktober=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-10"+"%",rs9.getString("kd_rek")); kreditoktober=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-10"+"%",rs9.getString("kd_rek")); saldoakhiroktober=saldoakhirseptember+(debetoktober-kreditoktober); debetnovember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-11"+"%",rs9.getString("kd_rek")); kreditnovember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-11"+"%",rs9.getString("kd_rek")); saldoakhirnovember=saldoakhiroktober+(debetnovember-kreditnovember); debetdesember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-12"+"%",rs9.getString("kd_rek")); kreditdesember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-12"+"%",rs9.getString("kd_rek")); saldoakhirdesember=saldoakhirnovember+(debetdesember-kreditdesember); htmlContent.append( ""+ "      "+rs9.getString("kd_rek")+""+ "      "+rs9.getString("nm_rek")+""+ ""+Valid.SetAngka(saldoawaljanuari)+""+ ""+Valid.SetAngka(debetjanuari)+""+ ""+Valid.SetAngka(kreditjanuari)+""+ ""+Valid.SetAngka(saldoakhirjanuari)+""+ ""+Valid.SetAngka(saldoakhirjanuari)+""+ ""+Valid.SetAngka(debetfebruari)+""+ ""+Valid.SetAngka(kreditfebruari)+""+ ""+Valid.SetAngka(saldoakhirfebruari)+""+ ""+Valid.SetAngka(saldoakhirfebruari)+""+ ""+Valid.SetAngka(debetmaret)+""+ ""+Valid.SetAngka(kreditmaret)+""+ ""+Valid.SetAngka(saldoakhirmaret)+""+ ""+Valid.SetAngka(saldoakhirmaret)+""+ ""+Valid.SetAngka(debetapril)+""+ ""+Valid.SetAngka(kreditapril)+""+ ""+Valid.SetAngka(saldoakhirapril)+""+ ""+Valid.SetAngka(saldoakhirapril)+""+ ""+Valid.SetAngka(debetmei)+""+ ""+Valid.SetAngka(kreditmei)+""+ ""+Valid.SetAngka(saldoakhirmei)+""+ ""+Valid.SetAngka(saldoakhirmei)+""+ ""+Valid.SetAngka(debetjuni)+""+ ""+Valid.SetAngka(kreditjuni)+""+ ""+Valid.SetAngka(saldoakhirjuni)+""+ ""+Valid.SetAngka(saldoakhirjuni)+""+ ""+Valid.SetAngka(debetjuli)+""+ ""+Valid.SetAngka(kreditjuli)+""+ ""+Valid.SetAngka(saldoakhirjuli)+""+ ""+Valid.SetAngka(saldoakhirjuli)+""+ ""+Valid.SetAngka(debetagustus)+""+ ""+Valid.SetAngka(kreditagustus)+""+ ""+Valid.SetAngka(saldoakhiragustus)+""+ ""+Valid.SetAngka(saldoakhiragustus)+""+ ""+Valid.SetAngka(debetseptember)+""+ ""+Valid.SetAngka(kreditseptember)+""+ ""+Valid.SetAngka(saldoakhirseptember)+""+ ""+Valid.SetAngka(saldoakhirseptember)+""+ ""+Valid.SetAngka(debetoktober)+""+ ""+Valid.SetAngka(kreditoktober)+""+ ""+Valid.SetAngka(saldoakhiroktober)+""+ ""+Valid.SetAngka(saldoakhiroktober)+""+ ""+Valid.SetAngka(debetnovember)+""+ ""+Valid.SetAngka(kreditnovember)+""+ ""+Valid.SetAngka(saldoakhirnovember)+""+ ""+Valid.SetAngka(saldoakhirnovember)+""+ ""+Valid.SetAngka(debetdesember)+""+ ""+Valid.SetAngka(kreditdesember)+""+ ""+Valid.SetAngka(saldoakhirdesember)+""+ "" ); ps10=koneksi.prepareStatement("select rekening.kd_rek, rekening.nm_rek "+ " from rekening inner join subrekening on rekening.kd_rek=subrekening.kd_rek2 "+ " where subrekening.kd_rek=? and rekening.level='1' and rekening.kd_rek like ? or "+ " subrekening.kd_rek=? and rekening.level='1' and rekening.nm_rek like ? order by rekening.kd_rek"); try { ps10.setString(1,rs9.getString("kd_rek")); ps10.setString(2,"%"+TCari.getText().trim()+"%"); ps10.setString(3,rs9.getString("kd_rek")); ps10.setString(4,"%"+TCari.getText().trim()+"%"); rs10=ps10.executeQuery(); while(rs10.next()){ saldoawaljanuari=Sequel.cariIsiAngka2("select saldo_awal from rekeningtahun where thn=? and kd_rek=?",ThnCari.getSelectedItem().toString(),rs10.getString("kd_rek")); debetjanuari=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-01"+"%",rs10.getString("kd_rek")); kreditjanuari=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-01"+"%",rs10.getString("kd_rek")); saldoakhirjanuari=saldoawaljanuari+(debetjanuari-kreditjanuari); debetfebruari=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-02"+"%",rs10.getString("kd_rek")); kreditfebruari=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-02"+"%",rs10.getString("kd_rek")); saldoakhirfebruari=saldoakhirjanuari+(debetfebruari-kreditfebruari); debetmaret=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-03"+"%",rs10.getString("kd_rek")); kreditmaret=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-03"+"%",rs10.getString("kd_rek")); saldoakhirmaret=saldoakhirfebruari+(debetmaret-kreditmaret); debetapril=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-04"+"%",rs10.getString("kd_rek")); kreditapril=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-04"+"%",rs10.getString("kd_rek")); saldoakhirapril=saldoakhirmaret+(debetapril-kreditapril); debetmei=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-05"+"%",rs10.getString("kd_rek")); kreditmei=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-05"+"%",rs10.getString("kd_rek")); saldoakhirmei=saldoakhirapril+(debetmei-kreditmei); debetjuni=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-06"+"%",rs10.getString("kd_rek")); kreditjuni=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-06"+"%",rs10.getString("kd_rek")); saldoakhirjuni=saldoakhirmei+(debetjuni-kreditjuni); debetjuli=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-07"+"%",rs10.getString("kd_rek")); kreditjuli=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-07"+"%",rs10.getString("kd_rek")); saldoakhirjuli=saldoakhirjuni+(debetjuli-kreditjuli); debetagustus=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-08"+"%",rs10.getString("kd_rek")); kreditagustus=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-08"+"%",rs10.getString("kd_rek")); saldoakhiragustus=saldoakhirjuli+(debetagustus-kreditagustus); debetseptember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-09"+"%",rs10.getString("kd_rek")); kreditseptember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-09"+"%",rs10.getString("kd_rek")); saldoakhirseptember=saldoakhiragustus+(debetseptember-kreditseptember); debetoktober=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-10"+"%",rs10.getString("kd_rek")); kreditoktober=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-10"+"%",rs10.getString("kd_rek")); saldoakhiroktober=saldoakhirseptember+(debetoktober-kreditoktober); debetnovember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-11"+"%",rs10.getString("kd_rek")); kreditnovember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-11"+"%",rs10.getString("kd_rek")); saldoakhirnovember=saldoakhiroktober+(debetnovember-kreditnovember); debetdesember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-12"+"%",rs10.getString("kd_rek")); kreditdesember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-12"+"%",rs10.getString("kd_rek")); saldoakhirdesember=saldoakhirnovember+(debetdesember-kreditdesember); htmlContent.append( ""+ "      "+rs10.getString("kd_rek")+""+ "      "+rs10.getString("nm_rek")+""+ ""+Valid.SetAngka(saldoawaljanuari)+""+ ""+Valid.SetAngka(debetjanuari)+""+ ""+Valid.SetAngka(kreditjanuari)+""+ ""+Valid.SetAngka(saldoakhirjanuari)+""+ ""+Valid.SetAngka(saldoakhirjanuari)+""+ ""+Valid.SetAngka(debetfebruari)+""+ ""+Valid.SetAngka(kreditfebruari)+""+ ""+Valid.SetAngka(saldoakhirfebruari)+""+ ""+Valid.SetAngka(saldoakhirfebruari)+""+ ""+Valid.SetAngka(debetmaret)+""+ ""+Valid.SetAngka(kreditmaret)+""+ ""+Valid.SetAngka(saldoakhirmaret)+""+ ""+Valid.SetAngka(saldoakhirmaret)+""+ ""+Valid.SetAngka(debetapril)+""+ ""+Valid.SetAngka(kreditapril)+""+ ""+Valid.SetAngka(saldoakhirapril)+""+ ""+Valid.SetAngka(saldoakhirapril)+""+ ""+Valid.SetAngka(debetmei)+""+ ""+Valid.SetAngka(kreditmei)+""+ ""+Valid.SetAngka(saldoakhirmei)+""+ ""+Valid.SetAngka(saldoakhirmei)+""+ ""+Valid.SetAngka(debetjuni)+""+ ""+Valid.SetAngka(kreditjuni)+""+ ""+Valid.SetAngka(saldoakhirjuni)+""+ ""+Valid.SetAngka(saldoakhirjuni)+""+ ""+Valid.SetAngka(debetjuli)+""+ ""+Valid.SetAngka(kreditjuli)+""+ ""+Valid.SetAngka(saldoakhirjuli)+""+ ""+Valid.SetAngka(saldoakhirjuli)+""+ ""+Valid.SetAngka(debetagustus)+""+ ""+Valid.SetAngka(kreditagustus)+""+ ""+Valid.SetAngka(saldoakhiragustus)+""+ ""+Valid.SetAngka(saldoakhiragustus)+""+ ""+Valid.SetAngka(debetseptember)+""+ ""+Valid.SetAngka(kreditseptember)+""+ ""+Valid.SetAngka(saldoakhirseptember)+""+ ""+Valid.SetAngka(saldoakhirseptember)+""+ ""+Valid.SetAngka(debetoktober)+""+ ""+Valid.SetAngka(kreditoktober)+""+ ""+Valid.SetAngka(saldoakhiroktober)+""+ ""+Valid.SetAngka(saldoakhiroktober)+""+ ""+Valid.SetAngka(debetnovember)+""+ ""+Valid.SetAngka(kreditnovember)+""+ ""+Valid.SetAngka(saldoakhirnovember)+""+ ""+Valid.SetAngka(saldoakhirnovember)+""+ ""+Valid.SetAngka(debetdesember)+""+ ""+Valid.SetAngka(kreditdesember)+""+ ""+Valid.SetAngka(saldoakhirdesember)+""+ "" ); ps11=koneksi.prepareStatement("select rekening.kd_rek, rekening.nm_rek "+ " from rekening inner join subrekening on rekening.kd_rek=subrekening.kd_rek2 "+ " where subrekening.kd_rek=? and rekening.level='1' and rekening.kd_rek like ? or "+ " subrekening.kd_rek=? and rekening.level='1' and rekening.nm_rek like ? order by rekening.kd_rek"); try { ps11.setString(1,rs10.getString("kd_rek")); ps11.setString(2,"%"+TCari.getText().trim()+"%"); ps11.setString(3,rs10.getString("kd_rek")); ps11.setString(4,"%"+TCari.getText().trim()+"%"); rs11=ps11.executeQuery(); while(rs11.next()){ saldoawaljanuari=Sequel.cariIsiAngka2("select saldo_awal from rekeningtahun where thn=? and kd_rek=?",ThnCari.getSelectedItem().toString(),rs11.getString("kd_rek")); debetjanuari=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-01"+"%",rs11.getString("kd_rek")); kreditjanuari=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-01"+"%",rs11.getString("kd_rek")); saldoakhirjanuari=saldoawaljanuari+(debetjanuari-kreditjanuari); debetfebruari=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-02"+"%",rs11.getString("kd_rek")); kreditfebruari=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-02"+"%",rs11.getString("kd_rek")); saldoakhirfebruari=saldoakhirjanuari+(debetfebruari-kreditfebruari); debetmaret=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-03"+"%",rs11.getString("kd_rek")); kreditmaret=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-03"+"%",rs11.getString("kd_rek")); saldoakhirmaret=saldoakhirfebruari+(debetmaret-kreditmaret); debetapril=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-04"+"%",rs11.getString("kd_rek")); kreditapril=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-04"+"%",rs11.getString("kd_rek")); saldoakhirapril=saldoakhirmaret+(debetapril-kreditapril); debetmei=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-05"+"%",rs11.getString("kd_rek")); kreditmei=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-05"+"%",rs11.getString("kd_rek")); saldoakhirmei=saldoakhirapril+(debetmei-kreditmei); debetjuni=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-06"+"%",rs11.getString("kd_rek")); kreditjuni=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-06"+"%",rs11.getString("kd_rek")); saldoakhirjuni=saldoakhirmei+(debetjuni-kreditjuni); debetjuli=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-07"+"%",rs11.getString("kd_rek")); kreditjuli=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-07"+"%",rs11.getString("kd_rek")); saldoakhirjuli=saldoakhirjuni+(debetjuli-kreditjuli); debetagustus=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-08"+"%",rs11.getString("kd_rek")); kreditagustus=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-08"+"%",rs11.getString("kd_rek")); saldoakhiragustus=saldoakhirjuli+(debetagustus-kreditagustus); debetseptember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-09"+"%",rs11.getString("kd_rek")); kreditseptember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-09"+"%",rs11.getString("kd_rek")); saldoakhirseptember=saldoakhiragustus+(debetseptember-kreditseptember); debetoktober=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-10"+"%",rs11.getString("kd_rek")); kreditoktober=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-10"+"%",rs11.getString("kd_rek")); saldoakhiroktober=saldoakhirseptember+(debetoktober-kreditoktober); debetnovember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-11"+"%",rs11.getString("kd_rek")); kreditnovember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-11"+"%",rs11.getString("kd_rek")); saldoakhirnovember=saldoakhiroktober+(debetnovember-kreditnovember); debetdesember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-12"+"%",rs11.getString("kd_rek")); kreditdesember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-12"+"%",rs11.getString("kd_rek")); saldoakhirdesember=saldoakhirnovember+(debetdesember-kreditdesember); htmlContent.append( ""+ "      "+rs11.getString("kd_rek")+""+ "      "+rs11.getString("nm_rek")+""+ ""+Valid.SetAngka(saldoawaljanuari)+""+ ""+Valid.SetAngka(debetjanuari)+""+ ""+Valid.SetAngka(kreditjanuari)+""+ ""+Valid.SetAngka(saldoakhirjanuari)+""+ ""+Valid.SetAngka(saldoakhirjanuari)+""+ ""+Valid.SetAngka(debetfebruari)+""+ ""+Valid.SetAngka(kreditfebruari)+""+ ""+Valid.SetAngka(saldoakhirfebruari)+""+ ""+Valid.SetAngka(saldoakhirfebruari)+""+ ""+Valid.SetAngka(debetmaret)+""+ ""+Valid.SetAngka(kreditmaret)+""+ ""+Valid.SetAngka(saldoakhirmaret)+""+ ""+Valid.SetAngka(saldoakhirmaret)+""+ ""+Valid.SetAngka(debetapril)+""+ ""+Valid.SetAngka(kreditapril)+""+ ""+Valid.SetAngka(saldoakhirapril)+""+ ""+Valid.SetAngka(saldoakhirapril)+""+ ""+Valid.SetAngka(debetmei)+""+ ""+Valid.SetAngka(kreditmei)+""+ ""+Valid.SetAngka(saldoakhirmei)+""+ ""+Valid.SetAngka(saldoakhirmei)+""+ ""+Valid.SetAngka(debetjuni)+""+ ""+Valid.SetAngka(kreditjuni)+""+ ""+Valid.SetAngka(saldoakhirjuni)+""+ ""+Valid.SetAngka(saldoakhirjuni)+""+ ""+Valid.SetAngka(debetjuli)+""+ ""+Valid.SetAngka(kreditjuli)+""+ ""+Valid.SetAngka(saldoakhirjuli)+""+ ""+Valid.SetAngka(saldoakhirjuli)+""+ ""+Valid.SetAngka(debetagustus)+""+ ""+Valid.SetAngka(kreditagustus)+""+ ""+Valid.SetAngka(saldoakhiragustus)+""+ ""+Valid.SetAngka(saldoakhiragustus)+""+ ""+Valid.SetAngka(debetseptember)+""+ ""+Valid.SetAngka(kreditseptember)+""+ ""+Valid.SetAngka(saldoakhirseptember)+""+ ""+Valid.SetAngka(saldoakhirseptember)+""+ ""+Valid.SetAngka(debetoktober)+""+ ""+Valid.SetAngka(kreditoktober)+""+ ""+Valid.SetAngka(saldoakhiroktober)+""+ ""+Valid.SetAngka(saldoakhiroktober)+""+ ""+Valid.SetAngka(debetnovember)+""+ ""+Valid.SetAngka(kreditnovember)+""+ ""+Valid.SetAngka(saldoakhirnovember)+""+ ""+Valid.SetAngka(saldoakhirnovember)+""+ ""+Valid.SetAngka(debetdesember)+""+ ""+Valid.SetAngka(kreditdesember)+""+ ""+Valid.SetAngka(saldoakhirdesember)+""+ "" ); ps12=koneksi.prepareStatement("select rekening.kd_rek, rekening.nm_rek "+ " from rekening inner join subrekening on rekening.kd_rek=subrekening.kd_rek2 "+ " where subrekening.kd_rek=? and rekening.level='1' and rekening.kd_rek like ? or "+ " subrekening.kd_rek=? and rekening.level='1' and rekening.nm_rek like ? order by rekening.kd_rek"); try { ps12.setString(1,rs11.getString("kd_rek")); ps12.setString(2,"%"+TCari.getText().trim()+"%"); ps12.setString(3,rs11.getString("kd_rek")); ps12.setString(4,"%"+TCari.getText().trim()+"%"); rs12=ps12.executeQuery(); while(rs12.next()){ saldoawaljanuari=Sequel.cariIsiAngka2("select saldo_awal from rekeningtahun where thn=? and kd_rek=?",ThnCari.getSelectedItem().toString(),rs12.getString("kd_rek")); debetjanuari=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-01"+"%",rs12.getString("kd_rek")); kreditjanuari=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-01"+"%",rs12.getString("kd_rek")); saldoakhirjanuari=saldoawaljanuari+(debetjanuari-kreditjanuari); debetfebruari=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-02"+"%",rs12.getString("kd_rek")); kreditfebruari=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-02"+"%",rs12.getString("kd_rek")); saldoakhirfebruari=saldoakhirjanuari+(debetfebruari-kreditfebruari); debetmaret=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-03"+"%",rs12.getString("kd_rek")); kreditmaret=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-03"+"%",rs12.getString("kd_rek")); saldoakhirmaret=saldoakhirfebruari+(debetmaret-kreditmaret); debetapril=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-04"+"%",rs12.getString("kd_rek")); kreditapril=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-04"+"%",rs12.getString("kd_rek")); saldoakhirapril=saldoakhirmaret+(debetapril-kreditapril); debetmei=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-05"+"%",rs12.getString("kd_rek")); kreditmei=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-05"+"%",rs12.getString("kd_rek")); saldoakhirmei=saldoakhirapril+(debetmei-kreditmei); debetjuni=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-06"+"%",rs12.getString("kd_rek")); kreditjuni=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-06"+"%",rs12.getString("kd_rek")); saldoakhirjuni=saldoakhirmei+(debetjuni-kreditjuni); debetjuli=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-07"+"%",rs12.getString("kd_rek")); kreditjuli=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-07"+"%",rs12.getString("kd_rek")); saldoakhirjuli=saldoakhirjuni+(debetjuli-kreditjuli); debetagustus=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-08"+"%",rs12.getString("kd_rek")); kreditagustus=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-08"+"%",rs12.getString("kd_rek")); saldoakhiragustus=saldoakhirjuli+(debetagustus-kreditagustus); debetseptember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-09"+"%",rs12.getString("kd_rek")); kreditseptember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-09"+"%",rs12.getString("kd_rek")); saldoakhirseptember=saldoakhiragustus+(debetseptember-kreditseptember); debetoktober=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-10"+"%",rs12.getString("kd_rek")); kreditoktober=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-10"+"%",rs12.getString("kd_rek")); saldoakhiroktober=saldoakhirseptember+(debetoktober-kreditoktober); debetnovember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-11"+"%",rs12.getString("kd_rek")); kreditnovember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-11"+"%",rs12.getString("kd_rek")); saldoakhirnovember=saldoakhiroktober+(debetnovember-kreditnovember); debetdesember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-12"+"%",rs12.getString("kd_rek")); kreditdesember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-12"+"%",rs12.getString("kd_rek")); saldoakhirdesember=saldoakhirnovember+(debetdesember-kreditdesember); htmlContent.append( ""+ "      "+rs12.getString("kd_rek")+""+ "      "+rs12.getString("nm_rek")+""+ ""+Valid.SetAngka(saldoawaljanuari)+""+ ""+Valid.SetAngka(debetjanuari)+""+ ""+Valid.SetAngka(kreditjanuari)+""+ ""+Valid.SetAngka(saldoakhirjanuari)+""+ ""+Valid.SetAngka(saldoakhirjanuari)+""+ ""+Valid.SetAngka(debetfebruari)+""+ ""+Valid.SetAngka(kreditfebruari)+""+ ""+Valid.SetAngka(saldoakhirfebruari)+""+ ""+Valid.SetAngka(saldoakhirfebruari)+""+ ""+Valid.SetAngka(debetmaret)+""+ ""+Valid.SetAngka(kreditmaret)+""+ ""+Valid.SetAngka(saldoakhirmaret)+""+ ""+Valid.SetAngka(saldoakhirmaret)+""+ ""+Valid.SetAngka(debetapril)+""+ ""+Valid.SetAngka(kreditapril)+""+ ""+Valid.SetAngka(saldoakhirapril)+""+ ""+Valid.SetAngka(saldoakhirapril)+""+ ""+Valid.SetAngka(debetmei)+""+ ""+Valid.SetAngka(kreditmei)+""+ ""+Valid.SetAngka(saldoakhirmei)+""+ ""+Valid.SetAngka(saldoakhirmei)+""+ ""+Valid.SetAngka(debetjuni)+""+ ""+Valid.SetAngka(kreditjuni)+""+ ""+Valid.SetAngka(saldoakhirjuni)+""+ ""+Valid.SetAngka(saldoakhirjuni)+""+ ""+Valid.SetAngka(debetjuli)+""+ ""+Valid.SetAngka(kreditjuli)+""+ ""+Valid.SetAngka(saldoakhirjuli)+""+ ""+Valid.SetAngka(saldoakhirjuli)+""+ ""+Valid.SetAngka(debetagustus)+""+ ""+Valid.SetAngka(kreditagustus)+""+ ""+Valid.SetAngka(saldoakhiragustus)+""+ ""+Valid.SetAngka(saldoakhiragustus)+""+ ""+Valid.SetAngka(debetseptember)+""+ ""+Valid.SetAngka(kreditseptember)+""+ ""+Valid.SetAngka(saldoakhirseptember)+""+ ""+Valid.SetAngka(saldoakhirseptember)+""+ ""+Valid.SetAngka(debetoktober)+""+ ""+Valid.SetAngka(kreditoktober)+""+ ""+Valid.SetAngka(saldoakhiroktober)+""+ ""+Valid.SetAngka(saldoakhiroktober)+""+ ""+Valid.SetAngka(debetnovember)+""+ ""+Valid.SetAngka(kreditnovember)+""+ ""+Valid.SetAngka(saldoakhirnovember)+""+ ""+Valid.SetAngka(saldoakhirnovember)+""+ ""+Valid.SetAngka(debetdesember)+""+ ""+Valid.SetAngka(kreditdesember)+""+ ""+Valid.SetAngka(saldoakhirdesember)+""+ "" ); ps13=koneksi.prepareStatement("select rekening.kd_rek, rekening.nm_rek "+ " from rekening inner join subrekening on rekening.kd_rek=subrekening.kd_rek2 "+ " where subrekening.kd_rek=? and rekening.level='1' and rekening.kd_rek like ? or "+ " subrekening.kd_rek=? and rekening.level='1' and rekening.nm_rek like ? order by rekening.kd_rek"); try { ps13.setString(1,rs12.getString("kd_rek")); ps13.setString(2,"%"+TCari.getText().trim()+"%"); ps13.setString(3,rs12.getString("kd_rek")); ps13.setString(4,"%"+TCari.getText().trim()+"%"); rs13=ps13.executeQuery(); while(rs13.next()){ saldoawaljanuari=Sequel.cariIsiAngka2("select saldo_awal from rekeningtahun where thn=? and kd_rek=?",ThnCari.getSelectedItem().toString(),rs13.getString("kd_rek")); debetjanuari=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-01"+"%",rs13.getString("kd_rek")); kreditjanuari=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-01"+"%",rs13.getString("kd_rek")); saldoakhirjanuari=saldoawaljanuari+(debetjanuari-kreditjanuari); debetfebruari=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-02"+"%",rs13.getString("kd_rek")); kreditfebruari=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-02"+"%",rs13.getString("kd_rek")); saldoakhirfebruari=saldoakhirjanuari+(debetfebruari-kreditfebruari); debetmaret=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-03"+"%",rs13.getString("kd_rek")); kreditmaret=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-03"+"%",rs13.getString("kd_rek")); saldoakhirmaret=saldoakhirfebruari+(debetmaret-kreditmaret); debetapril=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-04"+"%",rs13.getString("kd_rek")); kreditapril=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-04"+"%",rs13.getString("kd_rek")); saldoakhirapril=saldoakhirmaret+(debetapril-kreditapril); debetmei=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-05"+"%",rs13.getString("kd_rek")); kreditmei=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-05"+"%",rs13.getString("kd_rek")); saldoakhirmei=saldoakhirapril+(debetmei-kreditmei); debetjuni=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-06"+"%",rs13.getString("kd_rek")); kreditjuni=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-06"+"%",rs13.getString("kd_rek")); saldoakhirjuni=saldoakhirmei+(debetjuni-kreditjuni); debetjuli=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-07"+"%",rs13.getString("kd_rek")); kreditjuli=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-07"+"%",rs13.getString("kd_rek")); saldoakhirjuli=saldoakhirjuni+(debetjuli-kreditjuli); debetagustus=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-08"+"%",rs13.getString("kd_rek")); kreditagustus=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-08"+"%",rs13.getString("kd_rek")); saldoakhiragustus=saldoakhirjuli+(debetagustus-kreditagustus); debetseptember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-09"+"%",rs13.getString("kd_rek")); kreditseptember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-09"+"%",rs13.getString("kd_rek")); saldoakhirseptember=saldoakhiragustus+(debetseptember-kreditseptember); debetoktober=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-10"+"%",rs13.getString("kd_rek")); kreditoktober=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-10"+"%",rs13.getString("kd_rek")); saldoakhiroktober=saldoakhirseptember+(debetoktober-kreditoktober); debetnovember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-11"+"%",rs13.getString("kd_rek")); kreditnovember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-11"+"%",rs13.getString("kd_rek")); saldoakhirnovember=saldoakhiroktober+(debetnovember-kreditnovember); debetdesember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-12"+"%",rs13.getString("kd_rek")); kreditdesember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-12"+"%",rs13.getString("kd_rek")); saldoakhirdesember=saldoakhirnovember+(debetdesember-kreditdesember); htmlContent.append( ""+ "      "+rs13.getString("kd_rek")+""+ "      "+rs13.getString("nm_rek")+""+ ""+Valid.SetAngka(saldoawaljanuari)+""+ ""+Valid.SetAngka(debetjanuari)+""+ ""+Valid.SetAngka(kreditjanuari)+""+ ""+Valid.SetAngka(saldoakhirjanuari)+""+ ""+Valid.SetAngka(saldoakhirjanuari)+""+ ""+Valid.SetAngka(debetfebruari)+""+ ""+Valid.SetAngka(kreditfebruari)+""+ ""+Valid.SetAngka(saldoakhirfebruari)+""+ ""+Valid.SetAngka(saldoakhirfebruari)+""+ ""+Valid.SetAngka(debetmaret)+""+ ""+Valid.SetAngka(kreditmaret)+""+ ""+Valid.SetAngka(saldoakhirmaret)+""+ ""+Valid.SetAngka(saldoakhirmaret)+""+ ""+Valid.SetAngka(debetapril)+""+ ""+Valid.SetAngka(kreditapril)+""+ ""+Valid.SetAngka(saldoakhirapril)+""+ ""+Valid.SetAngka(saldoakhirapril)+""+ ""+Valid.SetAngka(debetmei)+""+ ""+Valid.SetAngka(kreditmei)+""+ ""+Valid.SetAngka(saldoakhirmei)+""+ ""+Valid.SetAngka(saldoakhirmei)+""+ ""+Valid.SetAngka(debetjuni)+""+ ""+Valid.SetAngka(kreditjuni)+""+ ""+Valid.SetAngka(saldoakhirjuni)+""+ ""+Valid.SetAngka(saldoakhirjuni)+""+ ""+Valid.SetAngka(debetjuli)+""+ ""+Valid.SetAngka(kreditjuli)+""+ ""+Valid.SetAngka(saldoakhirjuli)+""+ ""+Valid.SetAngka(saldoakhirjuli)+""+ ""+Valid.SetAngka(debetagustus)+""+ ""+Valid.SetAngka(kreditagustus)+""+ ""+Valid.SetAngka(saldoakhiragustus)+""+ ""+Valid.SetAngka(saldoakhiragustus)+""+ ""+Valid.SetAngka(debetseptember)+""+ ""+Valid.SetAngka(kreditseptember)+""+ ""+Valid.SetAngka(saldoakhirseptember)+""+ ""+Valid.SetAngka(saldoakhirseptember)+""+ ""+Valid.SetAngka(debetoktober)+""+ ""+Valid.SetAngka(kreditoktober)+""+ ""+Valid.SetAngka(saldoakhiroktober)+""+ ""+Valid.SetAngka(saldoakhiroktober)+""+ ""+Valid.SetAngka(debetnovember)+""+ ""+Valid.SetAngka(kreditnovember)+""+ ""+Valid.SetAngka(saldoakhirnovember)+""+ ""+Valid.SetAngka(saldoakhirnovember)+""+ ""+Valid.SetAngka(debetdesember)+""+ ""+Valid.SetAngka(kreditdesember)+""+ ""+Valid.SetAngka(saldoakhirdesember)+""+ "" ); } } catch (Exception e) { System.out.println("Notif rs13 : "+e); } finally{ if(rs13!=null){ rs13.close(); } if(ps13!=null){ ps13.close(); } } } } catch (Exception e) { System.out.println("Notif rs12 : "+e); } finally{ if(rs12!=null){ rs12.close(); } if(ps12!=null){ ps12.close(); } } } } catch (Exception e) { System.out.println("Notif rs11 : "+e); } finally{ if(rs11!=null){ rs11.close(); } if(ps11!=null){ ps11.close(); } } } } catch (Exception e) { System.out.println("Notif rs10 : "+e); } finally{ if(rs10!=null){ rs10.close(); } if(ps10!=null){ ps10.close(); } } } } catch (Exception e) { System.out.println("Notif rs9 : "+e); } finally{ if(rs9!=null){ rs9.close(); } if(ps9!=null){ ps9.close(); } } } } catch (Exception e) { System.out.println("Notif rs8 : "+e); } finally{ if(rs8!=null){ rs8.close(); } if(ps8!=null){ ps8.close(); } } } } catch (Exception e) { System.out.println("Notif rs7 : "+e); } finally{ if(rs7!=null){ rs7.close(); } if(ps7!=null){ ps7.close(); } } } } catch (Exception e) { System.out.println("Notif rs6 : "+e); } finally{ if(rs6!=null){ rs6.close(); } if(ps6!=null){ ps6.close(); } } } } catch (Exception e) { System.out.println("Notif rs5 : "+e); } finally{ if(rs5!=null){ rs5.close(); } if(ps5!=null){ ps5.close(); } } } } catch (Exception e) { System.out.println("Notif rs4 : "+e); } finally{ if(rs4!=null){ rs4.close(); } if(ps4!=null){ ps4.close(); } } } } catch (Exception e) { System.out.println("Notif rs3 : "+e); } finally{ if(rs3!=null){ rs3.close(); } if(ps3!=null){ ps3.close(); } } } } catch (Exception e) { System.out.println("Notif rs2 : "+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(); } } LoadHTML.setText( ""+ ""+ htmlContent.toString()+ "
"+ ""); } catch (Exception e) { System.out.println("Notif : "+e); } this.setCursor(Cursor.getDefaultCursor()); } private void prosesCari2() { this.setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR)); try { htmlContent = new StringBuilder(); htmlContent.append( ""+ "Kode Akun"+ "Akun Rekening"+ "Januari"+ "Februari"+ "Maret"+ "April"+ "Mei"+ "Juni"+ "Juli"+ "Agutus"+ "September"+ "Otober"+ "November"+ "Desember"+ ""+ ""+ "Saldo Awal"+ "Debet"+ "Kredit"+ "Saldo Akhir"+ "Saldo Awal"+ "Debet"+ "Kredit"+ "Saldo Akhir"+ "Saldo Awal"+ "Debet"+ "Kredit"+ "Saldo Akhir"+ "Saldo Awal"+ "Debet"+ "Kredit"+ "Saldo Akhir"+ "Saldo Awal"+ "Debet"+ "Kredit"+ "Saldo Akhir"+ "Saldo Awal"+ "Debet"+ "Kredit"+ "Saldo Akhir"+ "Saldo Awal"+ "Debet"+ "Kredit"+ "Saldo Akhir"+ "Saldo Awal"+ "Debet"+ "Kredit"+ "Saldo Akhir"+ "Saldo Awal"+ "Debet"+ "Kredit"+ "Saldo Akhir"+ "Saldo Awal"+ "Debet"+ "Kredit"+ "Saldo Akhir"+ "Saldo Awal"+ "Debet"+ "Kredit"+ "Saldo Akhir"+ "Saldo Awal"+ "Debet"+ "Kredit"+ "Saldo Akhir"+ "" ); ps=koneksi.prepareStatement("select kd_rek, nm_rek "+ " from rekening where kd_rek like ? or "+ " nm_rek like ? order by kd_rek"); try { ps.setString(1,"%"+TCari.getText().trim()+"%"); ps.setString(2,"%"+TCari.getText().trim()+"%"); rs=ps.executeQuery(); while(rs.next()){ saldoawaljanuari=Sequel.cariIsiAngka2("select saldo_awal from rekeningtahun where thn=? and kd_rek=?",ThnCari.getSelectedItem().toString(),rs.getString("kd_rek")); debetjanuari=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-01"+"%",rs.getString("kd_rek")); kreditjanuari=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-01"+"%",rs.getString("kd_rek")); saldoakhirjanuari=saldoawaljanuari+(debetjanuari-kreditjanuari); debetfebruari=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-02"+"%",rs.getString("kd_rek")); kreditfebruari=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-02"+"%",rs.getString("kd_rek")); saldoakhirfebruari=saldoakhirjanuari+(debetfebruari-kreditfebruari); debetmaret=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-03"+"%",rs.getString("kd_rek")); kreditmaret=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-03"+"%",rs.getString("kd_rek")); saldoakhirmaret=saldoakhirfebruari+(debetmaret-kreditmaret); debetapril=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-04"+"%",rs.getString("kd_rek")); kreditapril=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-04"+"%",rs.getString("kd_rek")); saldoakhirapril=saldoakhirmaret+(debetapril-kreditapril); debetmei=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-05"+"%",rs.getString("kd_rek")); kreditmei=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-05"+"%",rs.getString("kd_rek")); saldoakhirmei=saldoakhirapril+(debetmei-kreditmei); debetjuni=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-06"+"%",rs.getString("kd_rek")); kreditjuni=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-06"+"%",rs.getString("kd_rek")); saldoakhirjuni=saldoakhirmei+(debetjuni-kreditjuni); debetjuli=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-07"+"%",rs.getString("kd_rek")); kreditjuli=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-07"+"%",rs.getString("kd_rek")); saldoakhirjuli=saldoakhirjuni+(debetjuli-kreditjuli); debetagustus=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-08"+"%",rs.getString("kd_rek")); kreditagustus=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-08"+"%",rs.getString("kd_rek")); saldoakhiragustus=saldoakhirjuli+(debetagustus-kreditagustus); debetseptember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-09"+"%",rs.getString("kd_rek")); kreditseptember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-09"+"%",rs.getString("kd_rek")); saldoakhirseptember=saldoakhiragustus+(debetseptember-kreditseptember); debetoktober=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-10"+"%",rs.getString("kd_rek")); kreditoktober=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-10"+"%",rs.getString("kd_rek")); saldoakhiroktober=saldoakhirseptember+(debetoktober-kreditoktober); debetnovember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-11"+"%",rs.getString("kd_rek")); kreditnovember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-11"+"%",rs.getString("kd_rek")); saldoakhirnovember=saldoakhiroktober+(debetnovember-kreditnovember); debetdesember=Sequel.cariIsiAngka2("select sum(detailjurnal.debet) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-12"+"%",rs.getString("kd_rek")); kreditdesember=Sequel.cariIsiAngka2("select sum(detailjurnal.kredit) from jurnal inner join detailjurnal on detailjurnal.no_jurnal=jurnal.no_jurnal where jurnal.tgl_jurnal like ? and detailjurnal.kd_rek=?","%"+ThnCari.getSelectedItem().toString()+"-12"+"%",rs.getString("kd_rek")); saldoakhirdesember=saldoakhirnovember+(debetdesember-kreditdesember); htmlContent.append( ""+ ""+rs.getString("kd_rek")+""+ ""+rs.getString("nm_rek")+""+ ""+Valid.SetAngka(saldoawaljanuari)+""+ ""+Valid.SetAngka(debetjanuari)+""+ ""+Valid.SetAngka(kreditjanuari)+""+ ""+Valid.SetAngka(saldoakhirjanuari)+""+ ""+Valid.SetAngka(saldoakhirjanuari)+""+ ""+Valid.SetAngka(debetfebruari)+""+ ""+Valid.SetAngka(kreditfebruari)+""+ ""+Valid.SetAngka(saldoakhirfebruari)+""+ ""+Valid.SetAngka(saldoakhirfebruari)+""+ ""+Valid.SetAngka(debetmaret)+""+ ""+Valid.SetAngka(kreditmaret)+""+ ""+Valid.SetAngka(saldoakhirmaret)+""+ ""+Valid.SetAngka(saldoakhirmaret)+""+ ""+Valid.SetAngka(debetapril)+""+ ""+Valid.SetAngka(kreditapril)+""+ ""+Valid.SetAngka(saldoakhirapril)+""+ ""+Valid.SetAngka(saldoakhirapril)+""+ ""+Valid.SetAngka(debetmei)+""+ ""+Valid.SetAngka(kreditmei)+""+ ""+Valid.SetAngka(saldoakhirmei)+""+ ""+Valid.SetAngka(saldoakhirmei)+""+ ""+Valid.SetAngka(debetjuni)+""+ ""+Valid.SetAngka(kreditjuni)+""+ ""+Valid.SetAngka(saldoakhirjuni)+""+ ""+Valid.SetAngka(saldoakhirjuni)+""+ ""+Valid.SetAngka(debetjuli)+""+ ""+Valid.SetAngka(kreditjuli)+""+ ""+Valid.SetAngka(saldoakhirjuli)+""+ ""+Valid.SetAngka(saldoakhirjuli)+""+ ""+Valid.SetAngka(debetagustus)+""+ ""+Valid.SetAngka(kreditagustus)+""+ ""+Valid.SetAngka(saldoakhiragustus)+""+ ""+Valid.SetAngka(saldoakhiragustus)+""+ ""+Valid.SetAngka(debetseptember)+""+ ""+Valid.SetAngka(kreditseptember)+""+ ""+Valid.SetAngka(saldoakhirseptember)+""+ ""+Valid.SetAngka(saldoakhirseptember)+""+ ""+Valid.SetAngka(debetoktober)+""+ ""+Valid.SetAngka(kreditoktober)+""+ ""+Valid.SetAngka(saldoakhiroktober)+""+ ""+Valid.SetAngka(saldoakhiroktober)+""+ ""+Valid.SetAngka(debetnovember)+""+ ""+Valid.SetAngka(kreditnovember)+""+ ""+Valid.SetAngka(saldoakhirnovember)+""+ ""+Valid.SetAngka(saldoakhirnovember)+""+ ""+Valid.SetAngka(debetdesember)+""+ ""+Valid.SetAngka(kreditdesember)+""+ ""+Valid.SetAngka(saldoakhirdesember)+""+ "" ); } } catch (Exception e) { System.out.println("Notif : "+e); } finally{ if(rs!=null){ rs.close(); } if(ps!=null){ ps.close(); } } LoadHTML.setText( ""+ ""+ htmlContent.toString()+ "
"+ ""); } catch (Exception e) { System.out.println("Notif : "+e); } this.setCursor(Cursor.getDefaultCursor()); } public void isCek(){ BtnPrint.setEnabled(akses.getsaldo_akun_perbulan()); } }