diff options
author | Byron Jones <glob@mozilla.com> | 2015-07-13 20:00:51 +0200 |
---|---|---|
committer | Byron Jones <glob@mozilla.com> | 2015-07-13 20:00:51 +0200 |
commit | 43740a1ba3a3ee680033fbea7c23daab221016d5 (patch) | |
tree | 76f47c17315890a117c8ff702a33d70b7eb6cc5a /extensions/RequestNagger/lib/Constants.pm | |
parent | 77f0501214e4a23415b7f4bd8b294510d8b38621 (diff) | |
download | bugzilla-43740a1ba3a3ee680033fbea7c23daab221016d5.tar.gz bugzilla-43740a1ba3a3ee680033fbea7c23daab221016d5.tar.xz |
Bug 984438 - Don't send 'Your Overdue Requests' reminder emails on weekends
Diffstat (limited to 'extensions/RequestNagger/lib/Constants.pm')
-rw-r--r-- | extensions/RequestNagger/lib/Constants.pm | 16 |
1 files changed, 12 insertions, 4 deletions
diff --git a/extensions/RequestNagger/lib/Constants.pm b/extensions/RequestNagger/lib/Constants.pm index 9f1b0ba98..435c0b167 100644 --- a/extensions/RequestNagger/lib/Constants.pm +++ b/extensions/RequestNagger/lib/Constants.pm @@ -62,7 +62,9 @@ sub REQUESTEE_NAG_SQL { setter.userid AS setter_id, requestee.userid AS requestee_id, flags.requestee_id AS recipient_id, - flags.requestee_id AS target_id + flags.requestee_id AS target_id, + products.nag_interval, + 0 AS extended_period FROM flags INNER JOIN flagtypes ON flagtypes.id = flags.type_id @@ -104,7 +106,9 @@ sub SETTER_NAG_SQL { setter.userid AS setter_id, requestee.userid AS requestee_id, flags.setter_id AS recipient_id, - flags.setter_id AS target_id + flags.setter_id AS target_id, + products.nag_interval, + 0 AS extended_period FROM flags INNER JOIN flagtypes ON flagtypes.id = flags.type_id @@ -147,7 +151,9 @@ sub WATCHING_REQUESTEE_NAG_SQL { setter.userid AS setter_id, requestee.userid AS requestee_id, nag_watch.watcher_id AS recipient_id, - requestee.userid AS target_id + requestee.userid AS target_id, + products.nag_interval, + COALESCE(extended_period.setting_value, 0) AS extended_period FROM flags INNER JOIN flagtypes ON flagtypes.id = flags.type_id @@ -197,7 +203,9 @@ sub WATCHING_SETTER_NAG_SQL { setter.userid AS setter_id, requestee.userid AS requestee_id, nag_watch.watcher_id AS recipient_id, - setter.userid AS target_id + setter.userid AS target_id, + products.nag_interval, + COALESCE(extended_period.setting_value, 0) AS extended_period FROM flags INNER JOIN flagtypes ON flagtypes.id = flags.type_id |