X-Git-Url: https://code.wpia.club/?p=gigi.git;a=blobdiff_plain;f=src%2Forg%2Fcacert%2Fgigi%2FUser.java;h=b6086aa9a074fcfe5a407e84ec5bc45437ebde6f;hp=a7e6357667e24caa425c17a5c40e26fb5d0ffdf1;hb=e1628fcef515073d132978e4f0bf8c8e20a3b1cd;hpb=0a814fdf958fab3f77d7d9d5333ad4307f7c9b8c

diff --git a/src/org/cacert/gigi/User.java b/src/org/cacert/gigi/User.java
index a7e63576..b6086aa9 100644
--- a/src/org/cacert/gigi/User.java
+++ b/src/org/cacert/gigi/User.java
@@ -3,7 +3,8 @@ package org.cacert.gigi;
 import java.sql.PreparedStatement;
 import java.sql.ResultSet;
 import java.sql.SQLException;
-import java.util.Date;
+import java.sql.Date;
+import java.util.Calendar;
 
 import org.cacert.gigi.database.DatabaseConnection;
 import org.cacert.gigi.util.PasswordHash;
@@ -11,7 +12,7 @@ import org.cacert.gigi.util.PasswordHash;
 public class User {
 
 	private int id;
-	Name name = new Name(null, null);
+	Name name = new Name(null, null, null, null);
 
 	Date dob;
 	String email;
@@ -19,13 +20,17 @@ public class User {
 	public User(int id) {
 		this.id = id;
 		try {
-			PreparedStatement ps = DatabaseConnection.getInstance().prepare(
-					"SELECT `fname`, `lname`, `dob` FROM `users` WHERE id=?");
+			PreparedStatement ps = DatabaseConnection
+					.getInstance()
+					.prepare(
+							"SELECT `fname`, `lname`,`mname`, `suffix`, `dob`, `email` FROM `users` WHERE id=?");
 			ps.setInt(1, id);
 			ResultSet rs = ps.executeQuery();
 			if (rs.next()) {
-				name = new Name(rs.getString(1), rs.getString(2));
-				dob = rs.getDate(3);
+				name = new Name(rs.getString(1), rs.getString(2),
+						rs.getString(3), rs.getString(4));
+				dob = rs.getDate(5);
+				email = rs.getString(6);
 			}
 			rs.close();
 		} catch (SQLException e) {
@@ -99,4 +104,89 @@ public class User {
 		System.out.println("Inserted: " + id);
 	}
 
+	public boolean canAssure() throws SQLException {
+		if (getAssurancePoints() < 100) {
+			return false;
+		}
+
+		return hasPassedCATS();
+
+	}
+	public boolean hasPassedCATS() throws SQLException {
+		PreparedStatement query = DatabaseConnection.getInstance().prepare(
+				"SELECT 1 FROM `cats_passed` where `user_id`=?");
+		query.setInt(1, id);
+		ResultSet rs = query.executeQuery();
+		if (rs.next()) {
+			return true;
+		} else {
+			return false;
+		}
+	}
+	public int getAssurancePoints() throws SQLException {
+		PreparedStatement query = DatabaseConnection
+				.getInstance()
+				.prepare(
+						"SELECT sum(points) FROM `notary` where `to`=? AND `deleted`=0");
+		query.setInt(1, id);
+		ResultSet rs = query.executeQuery();
+		int points = 0;
+		if (rs.next()) {
+			points = rs.getInt(1);
+		}
+		rs.close();
+		return points;
+	}
+	public int getExperiencePoints() throws SQLException {
+		PreparedStatement query = DatabaseConnection.getInstance().prepare(
+				"SELECT count(*) FROM `notary` where `from`=? AND `deleted`=0");
+		query.setInt(1, id);
+		ResultSet rs = query.executeQuery();
+		int points = 0;
+		if (rs.next()) {
+			points = rs.getInt(1) * 2;
+		}
+		rs.close();
+		return points;
+	}
+	@Override
+	public boolean equals(Object obj) {
+		if (!(obj instanceof User)) {
+			return false;
+		}
+		User s = (User) obj;
+		return name.equals(s.name) && email.equals(s.email)
+				&& dob.toString().equals(s.dob.toString()); // This is due to
+															// day cutoff
+	}
+	public int getMaxAssurePoints() throws SQLException {
+		int exp = getExperiencePoints();
+		int points = 10;
+		Calendar c = Calendar.getInstance();
+		c.setTime(dob);
+		int year = c.get(Calendar.YEAR);
+		int month = c.get(Calendar.MONTH);
+		int day = c.get(Calendar.DAY_OF_MONTH);
+		c.set(year + 18, month, day);
+		if (System.currentTimeMillis() < c.getTime().getTime()) {
+			return points; // not 18 Years old.
+		}
+
+		if (exp >= 10) {
+			points += 5;
+		}
+		if (exp >= 20) {
+			points += 5;
+		}
+		if (exp >= 30) {
+			points += 5;
+		}
+		if (exp >= 40) {
+			points += 5;
+		}
+		if (exp >= 50) {
+			points += 5;
+		}
+		return points;
+	}
 }