diff options
| -rw-r--r-- | db/alert_types_eha.sql | 14 | ||||
| -rw-r--r-- | templates/emails/eha/alert-problem | 11 | ||||
| -rw-r--r-- | templates/emails/eha/alert-problem-area | 13 | ||||
| -rw-r--r-- | templates/emails/eha/alert-problem-council | 12 | ||||
| -rw-r--r-- | templates/emails/eha/alert-problem-nearby | 11 | ||||
| -rw-r--r-- | templates/emails/eha/alert-problem-ward | 13 | ||||
| -rw-r--r-- | templates/emails/eha/alert-update | 13 |
7 files changed, 80 insertions, 7 deletions
diff --git a/db/alert_types_eha.sql b/db/alert_types_eha.sql index 4ccd51cef..1dd19200b 100644 --- a/db/alert_types_eha.sql +++ b/db/alert_types_eha.sql @@ -7,7 +7,7 @@ insert into alert_type values ('new_updates', 'select * from problem where id=?', 'problem', 'Updates on {{title}}', '/', 'Updates on {{title}}', 'comment', 'comment.state=\'confirmed\'', 'created desc', - 'Update by {{name}}', '/report/{{problem_id}}#comment_{{id}}', '{{text}}', 'alert-update'); + 'Update by {{name}}', '/report/{{problem_id}}#comment_{{id}}', '{{text}}', 'eha/alert-update'); -- New problems anywhere on the site insert into alert_type @@ -18,7 +18,7 @@ insert into alert_type values ('new_problems', '', '', 'New reports on reportemptyhomes.com', '/', 'The latest empty properties reported by users', 'problem', 'problem.state in (\'confirmed\', \'fixed\')', 'created desc', - '{{title}}, {{confirmed}}', '/report/{{id}}', '{{detail}}', 'alert-problem'); + '{{title}}, {{confirmed}}', '/report/{{id}}', '{{detail}}', 'eha/alert-problem'); -- New fixed problems anywhere on the site insert into alert_type @@ -29,7 +29,7 @@ insert into alert_type values ('new_fixed_problems', '', '', 'Properties recently reported as put back to use on reportemptyhomes.com', '/', 'The latest properties reported back to use by users', 'problem', 'problem.state in (\'fixed\')', 'lastupdate desc', - '{{title}}, {{confirmed}}', '/report/{{id}}', '{{detail}}', 'alert-problem'); + '{{title}}, {{confirmed}}', '/report/{{id}}', '{{detail}}', 'eha/alert-problem'); -- New problems around a location insert into alert_type @@ -40,7 +40,7 @@ insert into alert_type values ('local_problems', '', '', 'New local reports on reportemptyhomes.com', '/', 'The latest local reports reported by users', 'problem_find_nearby(?, ?, ?) as nearby,problem', 'nearby.problem_id = problem.id and problem.state in (\'confirmed\', \'fixed\')', 'created desc', - '{{title}}, {{confirmed}}', '/report/{{id}}', '{{detail}}', 'alert-problem-nearby'); + '{{title}}, {{confirmed}}', '/report/{{id}}', '{{detail}}', 'eha/alert-problem-nearby'); -- New problems sent to a particular council insert into alert_type @@ -52,7 +52,7 @@ values ('council_problems', '', '', 'New reports to {{COUNCIL}} on reportemptyhomes.com', '/reports', 'The latest reports for {{COUNCIL}} reported by users', 'problem', 'problem.state in (\'confirmed\', \'fixed\') and (council like \'%\'||?||\'%\' or council is null) and areas like \'%,\'||?||\',%\'', 'created desc', - '{{title}}, {{confirmed}}', '/report/{{id}}', '{{detail}}', 'alert-problem-council' + '{{title}}, {{confirmed}}', '/report/{{id}}', '{{detail}}', 'eha/alert-problem-council' ); -- New problems within a particular ward sent to a particular council @@ -66,7 +66,7 @@ values ('ward_problems', '', '', 'The latest reports for {{COUNCIL}} within {{WARD}} ward reported by users', 'problem', 'problem.state in (\'confirmed\', \'fixed\') and (council like \'%\'||?||\'%\' or council is null) and areas like \'%,\'||?||\',%\'', 'created desc', - '{{title}}, {{confirmed}}', '/report/{{id}}', '{{detail}}', 'alert-problem-ward' + '{{title}}, {{confirmed}}', '/report/{{id}}', '{{detail}}', 'eha/alert-problem-ward' ); -- New problems within a particular voting area (ward, constituency, whatever) @@ -79,6 +79,6 @@ values ('area_problems', '', '', 'New reports within {{NAME}}\'s boundary on reportemptyhomes.com', '/reports', 'The latest reports within {{NAME}}\'s boundary reported by users', 'problem', 'problem.state in (\'confirmed\', \'fixed\') and areas like \'%,\'||?||\',%\'', 'created desc', - '{{title}}, {{confirmed}}', '/report/{{id}}', '{{detail}}', 'alert-problem-area' + '{{title}}, {{confirmed}}', '/report/{{id}}', '{{detail}}', 'eha/alert-problem-area' ); diff --git a/templates/emails/eha/alert-problem b/templates/emails/eha/alert-problem new file mode 100644 index 000000000..2b1660928 --- /dev/null +++ b/templates/emails/eha/alert-problem @@ -0,0 +1,11 @@ +Subject: New empty properties on reportemptyhomes.com + +The following empty properties have been added: + +<?=$values['data']?> + +Yours, +The Empty Homes Agency + +To stop receiving emails when there are new properties, +please follow this link: <?=$values['unsubscribe_url']?> diff --git a/templates/emails/eha/alert-problem-area b/templates/emails/eha/alert-problem-area new file mode 100644 index 000000000..cb8c96d0e --- /dev/null +++ b/templates/emails/eha/alert-problem-area @@ -0,0 +1,13 @@ +Subject: New empty properties in <?=$values['area_name']?> on reportemptyhomes.com + +The following empty properties have been added within +<?=$values['area_name']?>: + +<?=$values['data']?> + +Yours, +The Empty Homes Agency + +To stop receiving emails when there are new properties in +<?=$values['area_name']?>, please follow this link: +<?=$values['unsubscribe_url']?> diff --git a/templates/emails/eha/alert-problem-council b/templates/emails/eha/alert-problem-council new file mode 100644 index 000000000..703bd6911 --- /dev/null +++ b/templates/emails/eha/alert-problem-council @@ -0,0 +1,12 @@ +Subject: New empty properties reported to <?=$values['area_name']?> on reportemptyhomes.com + +The following empty properties have been reported to <?=$values['area_name']?>: + +<?=$values['data']?> + +Yours, +The Empty Homes Agency + +To stop receiving emails when there are new properties reported to +<?=$values['area_name']?>, please follow this link: +<?=$values['unsubscribe_url']?> diff --git a/templates/emails/eha/alert-problem-nearby b/templates/emails/eha/alert-problem-nearby new file mode 100644 index 000000000..a7ef16996 --- /dev/null +++ b/templates/emails/eha/alert-problem-nearby @@ -0,0 +1,11 @@ +Subject: New nearby empty properties on reportemptyhomes.com + +The following nearby empty properties have been added: + +<?=$values['data']?> + +Yours, +The Empty Homes Agency + +To stop receiving emails when there are nearby properties, +please follow this link: <?=$values['unsubscribe_url']?> diff --git a/templates/emails/eha/alert-problem-ward b/templates/emails/eha/alert-problem-ward new file mode 100644 index 000000000..425826b33 --- /dev/null +++ b/templates/emails/eha/alert-problem-ward @@ -0,0 +1,13 @@ +Subject: New empty properties reported to <?=$values['area_name']?> within <?=$values['ward_name']?> on reportemptyhomes.com + +The following empty properties have been reported to <?=$values['area_name']?> +within <?=$values['ward_name']?>: + +<?=$values['data']?> + +Yours, +The Empty Homes Agency + +To stop receiving emails when there are new properties reported to +<?=$values['area_name']?> within <?=$values['ward_name']?>, +please follow this link: <?=$values['unsubscribe_url']?> diff --git a/templates/emails/eha/alert-update b/templates/emails/eha/alert-update new file mode 100644 index 000000000..a725b050f --- /dev/null +++ b/templates/emails/eha/alert-update @@ -0,0 +1,13 @@ +Subject: New updates on empty property- '<?=$values['title']?>' + +The following updates have been left on this empty property: + +<?=$values['data']?> + +View or reply to these updates: <?=$values['problem_url']?> + +Yours, +The Empty Homes Agency + +To stop receiving emails when there are new updates on this property, +please follow this link: <?=$values['unsubscribe_url']?> |