globals

package data;

public class Globals {

	int id = 1;
	float Basic_Teacher_Wage = 1200f;
	float Basic_Admin_Wage = 1000f;
	float Teacher_Rise_Percentage = 0.15f;
	float Admin_Rise_Percentage = 0.15f;
	float Member_Percentage = 0.05f;
	float Reasearch_Bonus = 500f;
	float Library_Bonus = 300f;
	float Basic_Temp_Teacher_Wage = 1200f;
	float Basic_Temp_Admin_Wage = 1000f;
	String DBdate;


	/* Constructor */
	public Globals() {
		super();
	}

	public Globals(String date) {
		super();
		this.DBdate = date;
	}

	public Globals(float wageAdmin, float wageEdu,float tempWageAdmin,
			float tempWageEdu, float allowanceLib , float allowanceRes,float allowanceDep ,
			float adminPercentage , float eduPercentage, String dBdate)
	{
		super();
		this.Basic_Admin_Wage = wageAdmin;
		this.Basic_Teacher_Wage = wageEdu;
		this.Basic_Temp_Teacher_Wage = tempWageEdu;
		this.Basic_Temp_Admin_Wage = tempWageAdmin;
		this.Library_Bonus = allowanceLib;
		this.Reasearch_Bonus = allowanceRes;
		this.Member_Percentage = allowanceDep;
		this.Teacher_Rise_Percentage = eduPercentage;
		this.Admin_Rise_Percentage = adminPercentage;
		this.DBdate = dBdate;

	}

	/* Setters/Getters */
	public int getId() {
		return id;
	}

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

	public float getBasic_Teacher_Wage() {
		return Basic_Teacher_Wage;
	}


	public void setBasic_Teacher_Wage(float basic_Teacher_Wage) {
		Basic_Teacher_Wage = basic_Teacher_Wage;
	}


	public float getBasic_Admin_Wage() {
		return Basic_Admin_Wage;
	}


	public void setBasic_Admin_Wage(float basic_Admin_Wage) {
		Basic_Admin_Wage = basic_Admin_Wage;
	}


	public float getTeacher_Rise_Percentage() {
		return Teacher_Rise_Percentage;
	}


	public void setTeacher_Rise_Percentage(float teacher_Rise_Percentage) {
		Teacher_Rise_Percentage = teacher_Rise_Percentage;
	}


	public float getAdmin_Rise_Percentage() {
		return Admin_Rise_Percentage;
	}


	public void setAdmin_Rise_Percentage(float admin_Rise_Percentage) {
		Admin_Rise_Percentage = admin_Rise_Percentage;
	}


	public float getMember_Percentage() {
		return Member_Percentage;
	}


	public void setMember_Percentage(float member_Percentage) {
		Member_Percentage = member_Percentage;
	}


	public float getReasearch_Bonus() {
		return Reasearch_Bonus;
	}


	public void setReasearch_Bonus(float reasearch_Bonus) {
		Reasearch_Bonus = reasearch_Bonus;
	}


	public float getLibrary_Bonus() {
		return Library_Bonus;
	}


	public void setLibrary_Bonus(float library_Bonus) {
		Library_Bonus = library_Bonus;
	}


	public float getBasic_Temp_Teacher_Wage() {
		return Basic_Temp_Teacher_Wage;
	}


	public void setBasic_Temp_Teacher_Wage(float basic_Temp_Teacher_Wage) {
		Basic_Temp_Teacher_Wage = basic_Temp_Teacher_Wage;
	}


	public float getBasic_Temp_Admin_Wage() {
		return Basic_Temp_Admin_Wage;
	}


	public void setBasic_Temp_Admin_Wage(float basic_Temp_Admin_Wage) {
		Basic_Temp_Admin_Wage = basic_Temp_Admin_Wage;
	}


	public String getDBdate() {
		return DBdate;
	}


	public void setDBdate(String dBdate) {
		DBdate = dBdate;
	}


	/* inserts Globals object to appropriate table in DB */
	public String insertToTable() {

		String insertGlobals = new String(

				"INSERT INTO Globals VALUES ('"+
						getId()+"','"+
						getBasic_Teacher_Wage()+"','"+
					    getBasic_Admin_Wage() +"','"+
					    getTeacher_Rise_Percentage() +"','"+
					    getAdmin_Rise_Percentage() +"','"+
					    getMember_Percentage() +"','"+
					    getReasearch_Bonus() +"','"+
					    getLibrary_Bonus() +"',"+
					    getBasic_Temp_Teacher_Wage() +",'"+
					    getBasic_Temp_Admin_Wage() +",'"+
						getDBdate()+"');");

		return insertGlobals;
	}

	/* Updates object values in table */
	public String updateToTable() {

		String updGlobals = new String(
				"UPDATE Globals SET "+
				"id='"+getId()+"',"+
				"Basic_Teacher_Wage='"+getBasic_Teacher_Wage()+"',"+
				"Basic_Admin_Wage='"+getBasic_Admin_Wage()+"',"+
				"Teacher_Rise_Percentage='"+getTeacher_Rise_Percentage()+"',"+
				"Admin_Rise_Percentage='"+getAdmin_Rise_Percentage()+"',"+
				"Member_Percentage='"+getMember_Percentage()+"',"+
				"Reasearch_Bonus='"+getReasearch_Bonus()+"',"+
				"Library_Bonus='"+getLibrary_Bonus()+"',"+
				"Basic_Temp_Teacher_Wage='"+getBasic_Temp_Teacher_Wage()+"',"+
				"Basic_Temp_Admin_Wage='"+getBasic_Temp_Admin_Wage()+"',"+
				"DBdate='"+getDBdate()
				+"'");

		return updGlobals;
	}

	public void updateGlobals(Globals updated)
	{
		// check only wages and allowances
		if(updated.Basic_Admin_Wage!=-1.0f && updated.Basic_Admin_Wage > this.Basic_Admin_Wage)
			this.Basic_Admin_Wage = updated.Basic_Admin_Wage;
		if(updated.Basic_Temp_Admin_Wage!=-1.0f && updated.Basic_Temp_Admin_Wage > this.Basic_Temp_Admin_Wage)
			this.Basic_Temp_Admin_Wage = updated.Basic_Temp_Admin_Wage;
		if(updated.Basic_Teacher_Wage!=-1.0f && updated.Basic_Teacher_Wage > this.Basic_Teacher_Wage)
			this.Basic_Teacher_Wage = updated.Basic_Teacher_Wage;
		if(updated.Basic_Temp_Teacher_Wage!=-1.0f && updated.Basic_Temp_Teacher_Wage > this.Basic_Temp_Teacher_Wage )
			this.Basic_Temp_Teacher_Wage = updated.Basic_Temp_Teacher_Wage;

		if(updated.Library_Bonus!=-1.0f && updated.Library_Bonus > this.Library_Bonus)
			this.Library_Bonus = updated.Library_Bonus;
		if(updated.Reasearch_Bonus!=-1.0f && updated.Reasearch_Bonus >this.Reasearch_Bonus)
			this.Reasearch_Bonus = updated.Reasearch_Bonus;

		if(updated.Teacher_Rise_Percentage!=-1.0f && updated.Teacher_Rise_Percentage >this.Teacher_Rise_Percentage)
			this.Teacher_Rise_Percentage = updated.Teacher_Rise_Percentage;
		if(updated.Admin_Rise_Percentage!=-1.0f && updated.Admin_Rise_Percentage >this.Admin_Rise_Percentage)
			this.Admin_Rise_Percentage = updated.Admin_Rise_Percentage;
		if(updated.Member_Percentage!=-1.0f && updated.Member_Percentage >this.Member_Percentage)
			this.Member_Percentage = updated.Member_Percentage;


	}

	public void printValues()
	{
		System.out.println("CHANGE?");
		System.out.println(this.Basic_Admin_Wage);
		System.out.println(this.Basic_Teacher_Wage);
		System.out.println(this.Basic_Temp_Teacher_Wage);
		System.out.println(this.Basic_Temp_Admin_Wage);
		System.out.println(this.Library_Bonus);
		System.out.println(this.Reasearch_Bonus);
		System.out.println(this.Member_Percentage);
		System.out.println(this.Teacher_Rise_Percentage);
		System.out.println(this.Admin_Rise_Percentage);
	}


}