package database;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;

public class Main {


    public static void main( String ... args ) throws Exception {
        int key = 3000;

        Connection conn = DriverManager.getConnection( "jdbc:mysql://oege.ie.hva.nl/zeverae03", "everae03", "#7HDxm9bf" );
        Statement aa = conn.createStatement();
        ResultSet AA = aa.executeQuery( "SELECT * FROM `Database` WHERE serial = "+ key +"");
        //STAP 1 !!!
        if( AA.next() ) {
            System.out.println(
                    "Stap 1: key staat in database");
                        //STAP 3 !!!
                        Statement bb = conn.createStatement();
                        ResultSet BB = bb.executeQuery( "SELECT * FROM `Database` WHERE serial = "+ key +"");
                        while( BB.next() ) {
                        int id = BB.getInt( "Toegang" );
                        //STAP 4 !!!
                        if ( id == 2){
                                System.out.println("NOOD PAS, ONTRUIM GEBOUW OMG !!!\nP.S iedereen logd uit ;D");
                                PreparedStatement GG = conn.prepareStatement("UPDATE `Database` SET `Login` = '0'; ");
                                GG.executeUpdate();
                        }
                        if ( id == 1){
                        System.out.println("Stap 3: kaarthouder is eigenaar van winkel, DEUR OPEN !!");
                        }
                        //STAP 5 !!!
                        if ( id == 0){
                            System.out.println("Stap 3: kaarthouder is medewerker ");
                            Statement cc = conn.createStatement();
                            ResultSet CC = cc.executeQuery( "SELECT * FROM `Database` WHERE Login = '1'");
                            if ( CC.next() ) {
                                System.out.println("Stap 5: er is al iemand ingelogd ");
                            }
                            else {
                                System.out.println("Stap 5: er is niemand ingelogd dus deze kaart logd in, tijd opslaan + deur open ");
                                PreparedStatement DD = conn.prepareStatement("UPDATE `Database` SET `Login` = '1' WHERE `serial` ="+key +"; ");
                                DD.executeUpdate();
                                String intijd = "CURRENT_TIMESTAMP";
                                PreparedStatement HH = conn.prepareStatement("INSERT INTO `Tijden` ( `serial` , `InTijd` , `UitTijd` )VALUES ("+key+", "+intijd+" , '0000-00-00 00:00:00');");
                                HH.executeUpdate();


                            }
                        CC.close();
                        cc.close();
                            }

                        }
        bb.close();
        BB.close();

        }
        //STAP 2 !!!
        else {
            System.out.println("Stap 2: kaart staat niet in de database");
        }

        AA.close();
        aa.close();
        conn.close();


    }
}