From 301275c432501d9709168e69bb685c073fb621de Mon Sep 17 00:00:00 2001 From: Vitaly Takmazov Date: Tue, 10 Mar 2020 22:51:04 +0300 Subject: Mail unsubscribe API --- src/main/java/com/juick/service/EmailService.java | 3 +++ src/main/java/com/juick/service/EmailServiceImpl.java | 7 +++++++ 2 files changed, 10 insertions(+) (limited to 'src/main/java/com/juick/service') 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 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) { -- cgit v1.2.3