From b2f3afebc7de684d1d49042f5f79a9cbf9c1f2f2 Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Wed, 14 Mar 2018 10:04:40 +0300
Subject: refactor email settings

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

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

diff --git a/juick-server-jdbc/src/main/java/com/juick/service/EmailServiceImpl.java b/juick-server-jdbc/src/main/java/com/juick/service/EmailServiceImpl.java
index 1921354a..0cccc915 100644
--- a/juick-server-jdbc/src/main/java/com/juick/service/EmailServiceImpl.java
+++ b/juick-server-jdbc/src/main/java/com/juick/service/EmailServiceImpl.java
@@ -68,6 +68,14 @@ public class EmailServiceImpl extends BaseJdbcService implements EmailService {
                         .addValue("email", account)) > 0;
     }
 
+    @Transactional(readOnly = true)
+    @Override
+    public String getNotificationsEmail(Integer userId) {
+        List<String> list = getJdbcTemplate().queryForList(
+                "SELECT email FROM emails WHERE user_id=? AND subscr_hour IS NOT NULL", String.class, userId);
+        return list.isEmpty() ? StringUtils.EMPTY : list.get(0);
+    }
+
     @Override
     public boolean setNotificationsEmail(Integer userId, String account) {
         getJdbcTemplate().update("UPDATE emails SET subscr_hour=NULL WHERE user_id=?", userId);
-- 
cgit v1.2.3