<p>In file <b>C:\xampp\htdocs\eclass\include\action.php</b> on line <b>25</b> : <i>Unable to execute statement:"Table '.\eclass\actions_daily' is marked as crashed and should be repaired", sqlstate:"145", errornum:"HY000", 	statement:"SELECT id, TIME_TO_SEC(TIMEDIFF(NOW(), last_update)) AS diff, module_id                                                FROM actions_daily                                                WHERE user_id = ?                                                AND course_id = ?                                                AND day = DATE(NOW())                                                ORDER BY last_update DESC LIMIT 1", 	elapsed:0.001</i></p><p>In file <b>C:\xampp\htdocs\eclass\include\action.php</b> on line <b>50</b> : <i>Unable to execute statement:"Table '.\eclass\actions_daily' is marked as crashed and should be repaired", sqlstate:"145", errornum:"HY000", 	statement:"SELECT id                                    FROM actions_daily                                    WHERE user_id = ?                                    AND module_id = ?                                    AND course_id = ?                                    AND day = '2024-07-23'", 	elapsed:0.002</i></p><p>In file <b>C:\xampp\htdocs\eclass\include\action.php</b> on line <b>71</b> : <i>Unable to execute statement:"Table '.\eclass\actions_daily' is marked as crashed and should be repaired", sqlstate:"145", errornum:"HY000", 	statement:"INSERT INTO actions_daily SET                    user_id = ?,                    module_id = ?,                    course_id = ?,                    hits = 1,                    duration = 900,                    day = '2024-07-23'                     , last_update = NOW() ", 	elapsed:0.001</i></p>
abstract class Employee {
	
	public Employee(String text, double amount, int days)
	{
		name = text;
		income = amount;
		vacationDays = days;
	}
	
	public void setName(String text) { name = text; }
	public void setIncome(double amount) { income = amount; }
	public void setVacationDays(int days) { vacationDays = days; }
	
	public String getName() { return name; }
	public int getVacationDays() { return vacationDays; }
	
	public abstract void accept(Visitor visitor);
	
	private String name;
	protected double income;
	private int vacationDays;	
	
}

class Technician extends Employee {
	
	public Technician(String text, double amount, int days) 
	{
	   super(text, amount, days);
	}
	
	public double getIncome() { return income; }
	
	public void accept(Visitor visitor) {visitor.visit(this);}

}

class AdministrativeEmployee extends Employee {
	
	public AdministrativeEmployee(String text, double amount, int days, int extra) 
	{
	   super(text, amount, days);
	   bonus = extra;
	}

	public void setBonus(double amount) { bonus = amount; }
	public double getBonus() { return bonus; }
	
	public double getIncome() { return income; }
	
	public void accept(Visitor visitor) {visitor.visit(this);}
	
	private double bonus;	
}

interface Visitor {
	
	public void visit(Technician employee);
	public void visit(AdministrativeEmployee employee);
}

class IncomeVisitor implements Visitor {
	
	public void visit(Technician employee)
	{
		//Technicians get an increase 10% of their income
		employee.setIncome(employee.getIncome() * 1.10);
	}
	
	public void visit(AdministrativeEmployee employee)
	{
		//Administrative Employees get an increase 20% of their bonus
		employee.setBonus(employee.getBonus() * 1.20);
	}
}

class VacationDaysVisitor implements Visitor {

	public void visit(Technician employee)
	{
		//Technicians get an increase of 3 days
		employee.setVacationDays(employee.getVacationDays() + 3);
	}
	
	public void visit(AdministrativeEmployee employee)
	{
		//Administrative Employees get an increase of 2 days
		employee.setVacationDays(employee.getVacationDays() + 2);
	}	
}

public class VisitorTestFull {
	
	public static void main(String[] args) {
		
		Technician E1 = new Technician("Fred", 2000, 23);
		
		AdministrativeEmployee E2 = new AdministrativeEmployee("John", 3000, 25, 200);
		
		System.out.println(E1.getName() + ", Total Income: " + E1.getIncome() + 
		                   ", Vacation Days: " + E1.getVacationDays() );
		                   
        System.out.println(E2.getName() + ", Total Income: " + (E2.getIncome()+E2.getBonus()) + 
	                   ", Vacation Days: " + E2.getVacationDays() );

		IncomeVisitor v1 =  new IncomeVisitor();
		VacationDaysVisitor v2 = new VacationDaysVisitor();
		
		E1.accept(v1);
		E2.accept(v1);
		
		E1.accept(v2);
		E2.accept(v2);

		System.out.println("After visits have been performed....");
		
		System.out.println(E1.getName() + ", Total Income: " + E1.getIncome() + 
		                   ", Vacation Days: " + E1.getVacationDays() );
		                   
        System.out.println(E2.getName() + ", Total Income: " + (E2.getIncome()+E2.getBonus()) + 
	                   ", Vacation Days: " + E2.getVacationDays() );
 
		
	}
}