import java.sql.*;
import java.sql.Date;
import java.sql.DriverManager;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.*;

public class Logic extends Main {
    static ArrayList<Engineer> engList = new ArrayList<Engineer>();
    private static String myField; private static String myField2;
    private static int savedId; private static int savedId2;
    private static int savedCount; private static int savedCount2;
    private static int loopCounter = 0;

    static Date todaysDate = new Date(new java.util.Date().getTime());

    public static void createObjects() {
        try {
            Connection myConn = DriverManager.getConnection("jdbc:mysql://localhost:3306/engineer", "root", "");

            Statement myStmt = myConn.createStatement();

            ResultSet myRs = myStmt.executeQuery("select * from engineers");

            while (myRs.next()) {
//                System.out.println(myRs.getString("id") + ", " + myRs.getString("name") + ", " + myRs.getString("count") + ", " + myRs.getDate("date"));
                engList.add(new Engineer(myRs.getString("name"), myRs.getInt("id"), myRs.getInt("count"), myRs.getDate("date"))); //Loop creates object then adds to list till database runs out
            }

        } catch (Exception exc) {
            exc.printStackTrace();
        }
//        System.out.println(engList);
    }

    public static String getMyField()
    {
        //include validation, logic, logging or whatever you like here
        return myField;
    }
    public static void setMyField(String value)
    {
        //include more logic
        myField = value;
    }

    public static String getMyField2()
    {
        //include validation, logic, logging or whatever you like here
        return myField2;
    }
    public static void setMyField2(String value)
    {
        //include more logic
        myField2 = value;
    }


    public static void logic() {

        Date date = new Date(new java.util.Date().getTime() - 86400 * 1000);
        DateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");

        int x = 0;
            while (x < 1) {

                Random random = new Random();

                int randomId = random.nextInt(10) + 1;
                int randomId2 = random.nextInt(10) + 1;

                String strDate = dateFormat.format((engList.get(randomId - 1).getDate()));
                String strDate2 = dateFormat.format((engList.get(randomId2 - 1).getDate()));
                String yesterdayDate = dateFormat.format(date);

                if (randomId == randomId2) { // Rerolling non unique id's
                    randomId = random.nextInt(10) + 1;
                }
                else if (engList.get(randomId - 1).getCount() != 2 && (engList.get(randomId2 - 1).getCount() != 2) && (!strDate.equals(yesterdayDate) && (!strDate2.equals(yesterdayDate)))){
                    System.out.println("Employee workings is: " + engList.get(randomId - 1).getName());
                    System.out.println("Second employee workings is: " + engList.get(randomId2 - 1).getName());
                    String tempo = engList.get(randomId - 1).getName(); setMyField(tempo);
                    String tempo2 = engList.get(randomId2 - 1).getName(); setMyField2(tempo2);
                    savedCount = engList.get(randomId - 1).getCount()+1; savedCount2 = engList.get(randomId2 - 1).getCount() + 1;
                    savedId = engList.get(randomId - 1).getId(); savedId2 = engList.get(randomId2 - 1).getId();
                    System.out.println(savedId);
                    System.out.println(savedId2);
                    System.out.println(savedCount);
                    x = 1;
                    }
            }
    }

    public static void updateDatabase(){


        try {
            Connection myConn = DriverManager.getConnection("jdbc:mysql://localhost:3306/engineer", "root", "");
            Statement myStmt = myConn.createStatement();
            String sql = "UPDATE `engineers` SET `date` ='"+todaysDate+"', `count` = '"+savedCount+"' WHERE `engineers`.`id` = '"+savedId+"'";
            String sql2 = "UPDATE `engineers` SET `date` ='"+todaysDate+"', `count` = '"+savedCount2+"' WHERE `engineers`.`id` = '"+savedId2+"'";
            myStmt.executeUpdate(sql);
            myStmt.executeUpdate(sql2);

        } catch (Exception exc) {
            exc.printStackTrace();
        }
    }

    public static void hardReset(){


        try {
            Connection myConn = DriverManager.getConnection("jdbc:mysql://localhost:3306/engineer", "root", "");
            Statement myStmt = myConn.createStatement();
            ResultSet myRs = myStmt.executeQuery("select * from engineers");

            while (myRs.next()) {
                String sql = "UPDATE `engineers` SET `date` = '"+todaysDate+"', `count` = '0' WHERE `engineers`.`id` = '"+loopCounter+"'";
                Statement myStmt2 = myConn.createStatement();
                myStmt2.executeUpdate(sql);
                loopCounter++;
            }
            int finalId = (loopCounter)+1;
           String sql = "UPDATE `engineers` SET `date` = '"+todaysDate+"', `count` = '0' WHERE `engineers`.`id` = '"+finalId+"'";

        } catch (Exception exc) {
            exc.printStackTrace();
        }
    }



    public static void main(String[] args)  {

    }
}

import java.sql.Date;

public class Engineer extends Logic {
    String name;
    int id;
    int count;
    Date date;


    public Engineer(String name, int id, int count, Date date) { // Creating constructor for Engineer object
        // When Object is created do this
        this.name = name;
        this.id = id;
        this.count = count;
        this.date = date;

    }

    public int getId() {
        return id;
    }


    public int setId() {
        this.id = id;
        return id;
    }

    public String getName() {
        return name;
    }

    public String setName() {
        this.name = "jimbo";
        return name;
    }

    public Date getDate() {
        String date1date;
        return date;
    }

    public int getCount() {
        return count;
    }

    @Override
    public String toString() { // Overrides default toString to include return values of objects.
        return this.getId() + " " + this.getName() + " " + this.getCount() + " " + this.getDate();
    }

}