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

import fungsi.koneksiDB;
import fungsi.sekuel;
import fungsi.validasi;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

/**
 *
 * @author khanzamedia
 */
public class Jurnal {
    private final sekuel Sequel=new sekuel();
    private final validasi Valid=new validasi();
    private final Connection koneksi=koneksiDB.condb(); 
    private ResultSet rs,rscek;
    private PreparedStatement ps2,ps,pscek;
    private String nojur="";
    private boolean sukses=true;
    public synchronized boolean simpanJurnal(String nobukti,String jenis,String keterangan){  
        try {
            pscek=koneksi.prepareStatement("select count(*) as jml,current_date() as tanggal,current_time() as jam,sum(tampjurnal.debet) as debet,sum(tampjurnal.kredit) as kredit from tampjurnal");
            try {
                rscek=pscek.executeQuery();
                if(rscek.next()){
                    if(rscek.getInt("debet")==rscek.getInt("kredit")){
                        if(rscek.getInt("jml")>0){
                            nojur=Valid.autoNomer3("select ifnull(MAX(CONVERT(RIGHT(jurnal.no_jurnal,6),signed)),0) from jurnal where jurnal.tgl_jurnal='"+rscek.getString("tanggal")+"' ","JR"+rscek.getString("tanggal").replaceAll("-",""),6);
                            try {
                                 sukses=true;
                                 ps=koneksi.prepareStatement("insert into jurnal values(?,?,?,?,?,?)");
                                 try {
                                    ps.setString(1,nojur);
                                    ps.setString(2,nobukti);
                                    ps.setString(3,rscek.getString("tanggal"));
                                    ps.setString(4,rscek.getString("jam"));
                                    ps.setString(5,jenis);
                                    ps.setString(6,keterangan);
                                    ps.executeUpdate();
                                 } catch (Exception e) {
                                    sukses=false;
                                    System.out.println("Notifikasi : "+e);
                                 } finally{
                                    if(ps!=null){
                                        ps.close();
                                    }
                                 }

                                 if(sukses==false){
                                     nojur=Valid.autoNomer3("select ifnull(MAX(CONVERT(RIGHT(jurnal.no_jurnal,6),signed)),0) from jurnal where jurnal.tgl_jurnal='"+rscek.getString("tanggal")+"' ","JR"+rscek.getString("tanggal").replaceAll("-",""),6);
                                     sukses=true;
                                     ps=koneksi.prepareStatement("insert into jurnal values(?,?,?,?,?,?)");
                                     try {
                                        ps.setString(1,nojur);
                                        ps.setString(2,nobukti);
                                        ps.setString(3,rscek.getString("tanggal"));
                                        ps.setString(4,rscek.getString("jam"));
                                        ps.setString(5,jenis);
                                        ps.setString(6,keterangan);
                                        ps.executeUpdate();
                                     } catch (Exception e) {
                                        sukses=false;
                                        System.out.println("Notifikasi : "+e);
                                     } finally{
                                        if(ps!=null){
                                           ps.close();
                                        }
                                     }
                                 }

                                 if(sukses==true){
                                    try {
                                       ps2=koneksi.prepareStatement("insert into detailjurnal values(?,?,?,?)");
                                       rs=koneksi.prepareStatement("select tampjurnal.kd_rek,tampjurnal.nm_rek,tampjurnal.debet,tampjurnal.kredit from tampjurnal").executeQuery();
                                       while(rs.next()){
                                           try {
                                               ps2.setString(1,nojur);
                                               ps2.setString(2,rs.getString(1));
                                               ps2.setString(3,rs.getString(3));
                                               ps2.setString(4,rs.getString(4));
                                               ps2.addBatch();
                                           } catch (Exception e) {
                                               sukses=false;
                                               System.out.println("Notifikasi sub : "+e);
                                           }
                                       }
                                       ps2.executeBatch();
                                       ps2.close();
                                    } catch (Exception e) {
                                        sukses=false;
                                        System.out.println("Notif Temp Rek : "+e);
                                    } finally{
                                        if(rs!=null){
                                            rs.close();
                                        }
                                    }
                                    if(sukses==true){
                                        try {
                                            rs=koneksi.prepareStatement("select sum(detailjurnal.debet),sum(detailjurnal.kredit) from detailjurnal where detailjurnal.no_jurnal='"+nojur+"'").executeQuery();
                                            while(rs.next()){
                                                if(rs.getInt(1)!=rs.getInt(2)){
                                                    sukses=false;
                                                    System.out.println("Notif : Debet dan Kredit tidak sama");
                                                }
                                            }
                                        } catch (Exception e) {
                                             sukses=false;
                                             System.out.println("Notifikasi : "+e);
                                        } finally{
                                             if(rs!=null){
                                                 rs.close();
                                             }
                                        }
                                        Sequel.queryu2("delete from tampjurnal"); 
                                    }   
                                 }            
                            } catch (Exception ex) {
                                sukses=false;
                                System.out.println("Notifikasi : "+ex);  
                            } 
                        }
                    }else{
                        System.out.println("Notif : Debet dan Kredit tidak sama");
                        sukses=false;
                    }
                }
            } catch (Exception e) {
                sukses=false;
                System.out.println("Notif : "+e);
            } finally{
                if(rscek!=null){
                    rscek.close();
                }
                if(pscek!=null){
                    pscek.close();
                }
            }
        } catch (Exception e) {
            sukses=false;
            System.out.println("Notif : "+e);
        }
        return sukses;
   }
}