Mail unsubscribe API

1 files changed, 7 insertions, 0 deletions

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) {