Make intelligent user (new points calculation)

diff --git a/src/org/cacert/gigi/User.java b/src/org/cacert/gigi/User.java
index e21596638cc78648fb331718371d9365e7b6c750..2dba0c5c7f4d72c3f2b79565a031f4beef30fe8a 100644 (file)
--- a/src/org/cacert/gigi/User.java
+++ b/src/org/cacert/gigi/User.java
@@ -19,7 +19,9 @@ public class User {
        public User(int id) {
                this.id = id;
                try {
-                       PreparedStatement ps = DatabaseConnection.getInstance().prepare(
+                       PreparedStatement ps = DatabaseConnection
+                                       .getInstance()
+                                       .prepare(
                                                        "SELECT `fname`, `lname`, `dob`, `email` FROM `users` WHERE id=?");
                        ps.setInt(1, id);
                        ResultSet rs = ps.executeQuery();
@@ -100,4 +102,58 @@ 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.equals(s.dob);
+       }
 }