Mail unsubscribe API

2 files changed, 10 insertions, 0 deletions

diff --git a/src/main/java/com/juick/service/EmailService.java b/src/main/java/com/juick/service/EmailService.java
index b957d5ed..82c2fe5f 100644
--- a/src/main/java/com/juick/service/EmailService.java
+++ b/src/main/java/com/juick/service/EmailService.java
@@ -17,6 +17,8 @@
 
 package com.juick.service;
 
+import com.juick.model.User;
+
 import java.util.List;
 
 /**
@@ -27,6 +29,7 @@ public interface EmailService {
     boolean addVerificationCode(Integer userId, String account, String code);
     boolean addEmail(Integer userId, String email);
     boolean deleteEmail(Integer userId, String account);
+    boolean disableEmail(User user, String account);
     String getNotificationsEmail(Integer userId);
     boolean setNotificationsEmail(Integer userId, String account);
     List<String> getEmails(Integer userId, boolean active);
diff --git a/src/main/java/com/juick/service/EmailServiceImpl.java b/src/main/java/com/juick/service/EmailServiceImpl.java
index 6f0cf995..8d053f50 100644
--- a/src/main/java/com/juick/service/EmailServiceImpl.java
+++ b/src/main/java/com/juick/service/EmailServiceImpl.java
@@ -17,6 +17,7 @@
 
 package com.juick.service;
 
+import com.juick.model.User;
 import org.apache.commons.lang3.StringUtils;
 import org.springframework.dao.EmptyResultDataAccessException;
 import org.springframework.jdbc.core.namedparam.MapSqlParameterSource;
@@ -66,6 +67,12 @@ public class EmailServiceImpl extends BaseJdbcService implements EmailService {
                         .addValue("email", account)) > 0;
     }
 
+    @Override
+    public boolean disableEmail(User user, String account) {
+        return getJdbcTemplate().update("UPDATE emails SET subscr_hour=NULL " +
+                "WHERE user_id=? AND email=?", user.getUid(), account) > 0;
+    }
+
     @Transactional(readOnly = true)
     @Override
     public String getNotificationsEmail(Integer userId) {