From 5146e43ab81143a4fab59b43d4a71fd3de0f6ac9 Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Mon, 12 Dec 2016 14:28:34 +0300
Subject: juick-spring-www: settings templates and other WIP

---
 .../main/java/com/juick/service/EmailServiceImpl.java | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)

(limited to 'juick-server/src/main/java/com/juick/service/EmailServiceImpl.java')

diff --git a/juick-server/src/main/java/com/juick/service/EmailServiceImpl.java b/juick-server/src/main/java/com/juick/service/EmailServiceImpl.java
index bdd78609..b0bf9e20 100644
--- a/juick-server/src/main/java/com/juick/service/EmailServiceImpl.java
+++ b/juick-server/src/main/java/com/juick/service/EmailServiceImpl.java
@@ -1,5 +1,6 @@
 package com.juick.service;
 
+import org.apache.commons.lang3.StringUtils;
 import org.springframework.dao.EmptyResultDataAccessException;
 import org.springframework.jdbc.core.JdbcTemplate;
 import org.springframework.stereotype.Repository;
@@ -30,4 +31,22 @@ public class EmailServiceImpl extends BaseJdbcService implements EmailService {
         }
         return true;
     }
+
+    @Override
+    public boolean addVerificationCode(Integer userId, String account, String code) {
+        return getJdbcTemplate().update("INSERT INTO auth(user_id,protocol,account,authcode) VALUES (?,'email',?,?)",
+                userId, account, code) > 0;
+    }
+
+    @Override
+    public boolean deleteEmail(Integer userId, String account) {
+        return getJdbcTemplate().update("DELETE FROM emails WHERE user_id=? AND email=?", userId, account) > 0;
+    }
+
+    @Override
+    public boolean setSubscriptionHour(Integer userId, String account, String hour) {
+        getJdbcTemplate().update("UPDATE emails SET subscr_hour=NULL WHERE user_id=?", userId);
+        return StringUtils.isNotEmpty(account) && getJdbcTemplate().update(
+                "UPDATE emails SET subscr_hour=? WHERE user_id=? AND email=?", hour, userId, account) > 0;
+    }
 }
-- 
cgit v1.2.3