From: Dobrica Pavlinusic <dpavlin@rot13.org>
Date: Sat, 23 Feb 2019 09:03:32 +0000 (+0100)
Subject: extract @ffzg.hr mail or safeq smtp server will reject it
X-Git-Url: http://git.rot13.org/?p=virtual-ldap;a=commitdiff_plain;h=0e6a310cce589d12bb6543d7ebe2681f581fefd5;ds=sidebyside

extract @ffzg.hr mail or safeq smtp server will reject it
---

diff --git a/sql/hreduperson.sql b/sql/hreduperson.sql
index b3cb5b3..c40b846 100644
--- a/sql/hreduperson.sql
+++ b/sql/hreduperson.sql
@@ -15,7 +15,12 @@ select
 	b.borrowernumber					as objectGUID,
 	surname						as displayName,
 	a.attribute					as pager,
-	email						as mail,
+	case
+		when email    regexp '@ffzg.hr' then email
+		when emailpro regexp '@ffzg.hr' then emailpro
+	else
+		trim(userid)
+	end as mail,
 	categorycode					as memberOf,
 	categorycode					as ou,
 	categorycode					as department,