NotifyManyArticles
4.0.1
tuxwerk OHG
https://github.com/tuxwerk/OTRS-NotifyManyArticles
Send notification on too many answers on a ticket.
Sende Benachrichtigung bei zu viel Korrespondenz bei einem Ticket.
4.0.x
To enable the extension, create a group "NotifyManyArticles" and assign users or set the group name in sys config.
my $sql =<<EOF;
insert into notifications(notification_type, notification_charset, notification_language, subject,
text,
content_type, create_time, create_by, change_time, change_by)
values('Agent::NotifyManyArticles','utf-8','de','Ticket mit viel Korrespondenz',
'Hallo <OTRS_USERTITLE> <OTRS_USERLASTNAME>,
das Ticket "<OTRS_TICKET_NUMBER>" hat viel Korrespondenz!
Ticket#: <OTRS_TICKET_NUMBER>
Von: <OTRS_CUSTOMER_FROM>
Betreff: <OTRS_CUSTOMER_SUBJECT>
<OTRS_CUSTOMER_EMAIL[99]>
Bitte um weitere Bearbeitung:
<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom;TicketID=<OTRS_TICKET_TicketID>
Ihr OTRS Benachrichtigungs-Master',
'text/plain',now(),1,now(),1);
EOF
$Kernel::OM->Get("Kernel::System::DB")->Do(SQL => $sql);
$sql =<<EOF;
insert into notifications(notification_type, notification_charset, notification_language, subject,
text,
content_type, create_time, create_by, change_time, change_by)
values('Agent::NotifyManyArticles','utf-8','en','Ticket with many answers',
'Hi <OTRS_USERTITLE> <OTRS_USERLASTNAME>,
the ticket "<OTRS_TICKET_NUMBER>" has many answers!
ticket#: <OTRS_TICKET_NUMBER>
sender: <OTRS_CUSTOMER_FROM>
subject: <OTRS_CUSTOMER_SUBJECT>
<OTRS_CUSTOMER_EMAIL[99]>
please, check it here:
<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentZoom;TicketID=<OTRS_TICKET_TicketID>
Your OTRS Notification Master',
'text/plain',now(),1,now(),1);
EOF
$Kernel::OM->Get("Kernel::System::DB")->Do(SQL => $sql);
$Kernel::OM->Get("Kernel::System::DB")->Do(SQL => "delete from notifications where notification_type = 'Agent::NotifyManyArticles'");
2016-07-18 15:36:32
mono.o.tuxwerk.de
IyAtLQojIEtlcm5lbC9TeXN0ZW0vVGlja2V0L0V2ZW50L05vdGlmeU1hbnlBcnRpY2xlcy5wbSAtIG5vdGlmeSBtYW55IGFydGljbGVzIGV2ZW50IG1vZHVsZQojIENvcHlyaWdodCAoQykgMjAxNiB0dXh3ZXJrIE9IRywgaHR0cDovL3d3dy50dXh3ZXJrLmRlLwojIC0tCiMgVGhpcyBzb2Z0d2FyZSBjb21lcyB3aXRoIEFCU09MVVRFTFkgTk8gV0FSUkFOVFkuIEZvciBkZXRhaWxzLCBzZWUKIyB0aGUgZW5jbG9zZWQgZmlsZSBDT1BZSU5HIGZvciBsaWNlbnNlIGluZm9ybWF0aW9uIChBR1BMKS4gSWYgeW91CiMgZGlkIG5vdCByZWNlaXZlIHRoaXMgZmlsZSwgc2VlIGh0dHA6Ly93d3cuZ251Lm9yZy9saWNlbnNlcy9hZ3BsLnR4dC4KIyAtLQoKcGFja2FnZSBLZXJuZWw6OlN5c3RlbTo6VGlja2V0OjpFdmVudDo6Tm90aWZ5TWFueUFydGljbGVzOwoKdXNlIHN0cmljdDsKdXNlIHdhcm5pbmdzOwoKb3VyIEBPYmplY3REZXBlbmRlbmNpZXMgPSAoCiAgICAnS2VybmVsOjpTeXN0ZW06OkxvZycsCiAgICAnS2VybmVsOjpTeXN0ZW06OlRpY2tldCcsCiAgICAnS2VybmVsOjpTeXN0ZW06OlVzZXInLAogICAgJ0tlcm5lbDo6U3lzdGVtOjpHcm91cCcsCiAgICAnS2VybmVsOjpDb25maWcnLAopOwoKc3ViIG5ldyB7CiAgICBteSAoICRUeXBlLCAlUGFyYW0gKSA9IEBfOwoKICAgICMgYWxsb2NhdGUgbmV3IGhhc2ggZm9yIG9iamVjdAogICAgbXkgJFNlbGYgPSB7fTsKICAgIGJsZXNzKCAkU2VsZiwgJFR5cGUgKTsKCiAgICByZXR1cm4gJFNlbGY7Cn0KCnN1YiBSdW4gewogICAgbXkgKCAkU2VsZiwgJVBhcmFtICkgPSBAXzsKCiAgICAjIGdldCBuZWVkZWQgb2JqZWN0cwogICAgbXkgJExvZ09iamVjdCAgICA9ICRLZXJuZWw6Ok9NLT5HZXQoJ0tlcm5lbDo6U3lzdGVtOjpMb2cnKTsKICAgIG15ICRUaWNrZXRPYmplY3QgPSAkS2VybmVsOjpPTS0+R2V0KCdLZXJuZWw6OlN5c3RlbTo6VGlja2V0Jyk7CiAgICBteSAkVXNlck9iamVjdCAgID0gJEtlcm5lbDo6T00tPkdldCgnS2VybmVsOjpTeXN0ZW06OlVzZXInKTsKICAgIG15ICRHcm91cE9iamVjdCAgPSAkS2VybmVsOjpPTS0+R2V0KCdLZXJuZWw6OlN5c3RlbTo6R3JvdXAnKTsKICAgIG15ICRDb25maWdPYmplY3QgPSAkS2VybmVsOjpPTS0+R2V0KCdLZXJuZWw6OkNvbmZpZycpOwoKICAgICMgY2hlY2sgbmVlZGVkIHN0dWZmCiAgICBmb3IgKHF3KERhdGEgRXZlbnQgQ29uZmlnKSkgewogICAgICAgIGlmICggISRQYXJhbXskX30gKSB7CiAgICAgICAgICAgICRMb2dPYmplY3QtPkxvZyggUHJpb3JpdHkgPT4gJ2Vycm9yJywgTWVzc2FnZSA9PiAiTmVlZCAkXyEiICk7CiAgICAgICAgICAgIHJldHVybjsKICAgICAgICB9CiAgICB9CiAgICBmb3IgKHF3KFRpY2tldElEKSkgewogICAgICAgIGlmICggISRQYXJhbXtEYXRhfS0+eyRffSApIHsKICAgICAgICAgICAgJExvZ09iamVjdC0+TG9nKCBQcmlvcml0eSA9PiAnZXJyb3InLCBNZXNzYWdlID0+ICJOZWVkICRfIGluIERhdGEhIiApOwogICAgICAgICAgICByZXR1cm47CiAgICAgICAgfQogICAgfQogICAgaWYgKCAkUGFyYW17RXZlbnR9IG5lICdBcnRpY2xlQ3JlYXRlJyApIHsKICAgICAgICByZXR1cm4gMTsKICAgIH0KCiAgICBpZiAoJENvbmZpZ09iamVjdC0+R2V0KCdOb3RpZnlNYW55QXJ0aWNsZXM6OkVuYWJsZWQnKSAhPSAxKSB7CiAgICAgICAgcmV0dXJuIDE7CiAgICB9CgogICAgaWYgKCEkQ29uZmlnT2JqZWN0LT5HZXQoJ05vdGlmeU1hbnlBcnRpY2xlczo6R3JvdXAnKSkgewogICAgICAgICRMb2dPYmplY3QtPkxvZyggUHJpb3JpdHkgPT4gJ2Vycm9yJywgTWVzc2FnZSA9PiAiTmVlZCBOb3RpZnlNYW55QXJ0aWNsZXM6Okdyb3VwIiApOwogICAgICAgIHJldHVybjsKICAgIH0KCiAgICBteSAkR3JvdXBJRCA9ICRHcm91cE9iamVjdC0+R3JvdXBMb29rdXAoR3JvdXAgPT4gJENvbmZpZ09iamVjdC0+R2V0KCdOb3RpZnlNYW55QXJ0aWNsZXM6Okdyb3VwJykpOwoKICAgIGlmICghJENvbmZpZ09iamVjdC0+R2V0KCdOb3RpZnlNYW55QXJ0aWNsZXM6OkNvdW50JykpIHsKICAgICAgICAkTG9nT2JqZWN0LT5Mb2coIFByaW9yaXR5ID0+ICdlcnJvcicsIE1lc3NhZ2UgPT4gIk5lZWQgTm90aWZ5TWFueUFydGljbGVzOjpDb3VudCIgKTsKICAgICAgICByZXR1cm47CiAgICB9CgogICAgbXkgQEFsbEFydGljbGVzID0gJFRpY2tldE9iamVjdC0+QXJ0aWNsZUluZGV4KCBUaWNrZXRJRCA9PiAkUGFyYW17RGF0YX0tPntUaWNrZXRJRH0gKTsKICAgIGlmICgkI0FsbEFydGljbGVzID09ICRDb25maWdPYmplY3QtPkdldCgnTm90aWZ5TWFueUFydGljbGVzOjpDb3VudCcpKSB7CgogICAgICAgIG15IEBVc2VySURzID0gJEdyb3VwT2JqZWN0LT5Hcm91cE1lbWJlckxpc3QoCiAgICAgICAgICAgIEdyb3VwSUQgPT4gJEdyb3VwSUQsCiAgICAgICAgICAgIFR5cGUgICAgPT4gJ3JvJywKICAgICAgICAgICAgUmVzdWx0ICA9PiAnSUQnLAogICAgICAgICAgICApOwoKICAgICAgICAkTG9nT2JqZWN0LT5Mb2coCiAgICAgICAgICAgIFByaW9yaXR5ID0+ICdub3RpY2UnLAogICAgICAgICAgICBNZXNzYWdlID0+ICJBcnRpY2xlIGNvdW50IHJlYWNoZWQ6Ii4kI0FsbEFydGljbGVzLiIsIHNlbmRpbmcgbWFueSBhcnRpY2xlcyBub3RpZmljYXRpb24hIiwKICAgICAgICAgICAgKTsKCiAgICAgICAgbXkgJU5vdGlmeVVzZXI7CiAgICAgICAgZm9yZWFjaCBteSAkVXNlcklEIChAVXNlcklEcykgewogICAgICAgICAgICAkVGlja2V0T2JqZWN0LT5TZW5kQWdlbnROb3RpZmljYXRpb24oCiAgICAgICAgICAgICAgICBUeXBlID0+ICdOb3RpZnlNYW55QXJ0aWNsZXMnLAogICAgICAgICAgICAgICAgUmVjaXBpZW50SUQgPT4gJFVzZXJJRCwKICAgICAgICAgICAgICAgIEN1c3RvbWVyTWVzc2FnZVBhcmFtcyA9PiBcJVBhcmFtLAogICAgICAgICAgICAgICAgVGlja2V0SUQgPT4gJFBhcmFte0RhdGF9LT57VGlja2V0SUR9LAogICAgICAgICAgICAgICAgVXNlcklEID0+ICRQYXJhbXtVc2VySUR9LAogICAgICAgICAgICAgICAgKTsKICAgICAgICB9CiAgICB9CiAgICByZXR1cm4gMTsKfQoKMTsK
PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iaXNvLTg4NTktMSI/Pgo8b3Ryc19jb25maWcgdmVyc2lvbj0iMS4wIiBpbml0PSJBcHBsaWNhdGlvbiI+CgogIDxDb25maWdJdGVtIE5hbWU9IlRpY2tldDo6RXZlbnRNb2R1bGVQb3N0IyMjOTktTm90aWZ5TWFueUFydGljbGVzIiBSZXF1aXJlZD0iMCIgVmFsaWQ9IjEiPgogICAgPERlc2NyaXB0aW9uIExhbmc9ImVuIj5UaWNrZXQgZXZlbnQgbW9kdWxlIHRvIHNlbmQgbm90aWZpY2F0aW9ucy48L0Rlc2NyaXB0aW9uPgogICAgPEdyb3VwPlRpY2tldDwvR3JvdXA+CiAgICA8U3ViR3JvdXA+Q29yZTo6VGlja2V0PC9TdWJHcm91cD4KICAgIDxTZXR0aW5nPgogICAgICA8SGFzaD4KICAgICAgICA8SXRlbSBLZXk9Ik1vZHVsZSI+S2VybmVsOjpTeXN0ZW06OlRpY2tldDo6RXZlbnQ6Ok5vdGlmeU1hbnlBcnRpY2xlczwvSXRlbT4KICAgICAgICA8SXRlbSBLZXk9IkV2ZW50Ij5BcnRpY2xlQ3JlYXRlPC9JdGVtPgogICAgICA8L0hhc2g+CiAgICA8L1NldHRpbmc+CiAgPC9Db25maWdJdGVtPgoKICA8Q29uZmlnSXRlbSBOYW1lPSJOb3RpZnlNYW55QXJ0aWNsZXM6OkVuYWJsZWQiIFJlcXVpcmVkPSIxIiBWYWxpZD0iMSI+CiAgICA8RGVzY3JpcHRpb24gTGFuZz0iZW4iPkVuYWJsZSBvciBkaXNhYmxlPC9EZXNjcmlwdGlvbj4KICAgIDxHcm91cD5Ob3RpZnlNYW55QXJ0aWNsZXM8L0dyb3VwPgogICAgPFN1Ykdyb3VwPk5vdGlmeU1hbnlBcnRpY2xlczo6Q29yZTwvU3ViR3JvdXA+CiAgICA8U2V0dGluZz4KICAgICAgPFN0cmluZyBSZWdleD0iIj4xPC9TdHJpbmc+CiAgICA8L1NldHRpbmc+CiAgPC9Db25maWdJdGVtPgoKICA8Q29uZmlnSXRlbSBOYW1lPSJOb3RpZnlNYW55QXJ0aWNsZXM6Okdyb3VwIiBSZXF1aXJlZD0iMSIgVmFsaWQ9IjEiPgogICAgPERlc2NyaXB0aW9uIExhbmc9ImVuIj5OYW1lIG9mIGdyb3VwIHRvIGJlIG5vdGlmaWVkPC9EZXNjcmlwdGlvbj4KICAgIDxHcm91cD5Ob3RpZnlNYW55QXJ0aWNsZXM8L0dyb3VwPgogICAgPFN1Ykdyb3VwPk5vdGlmeU1hbnlBcnRpY2xlczo6Q29yZTwvU3ViR3JvdXA+CiAgICA8U2V0dGluZz4KICAgICAgPFN0cmluZyBSZWdleD0iIj5Ob3RpZnlNYW55QXJ0aWNsZXM8L1N0cmluZz4KICAgIDwvU2V0dGluZz4KICA8L0NvbmZpZ0l0ZW0+CgogIDxDb25maWdJdGVtIE5hbWU9Ik5vdGlmeU1hbnlBcnRpY2xlczo6Q291bnQiIFJlcXVpcmVkPSIxIiBWYWxpZD0iMSI+CiAgICA8RGVzY3JpcHRpb24gTGFuZz0iZW4iPlNlbmQgbm90aWZpY2F0aW9uIHdoZW4gYXJ0aWNsZSBjb3VudCBlcXVhbHMgdGhlIHZhbHVlPC9EZXNjcmlwdGlvbj4KICAgIDxHcm91cD5Ob3RpZnlNYW55QXJ0aWNsZXM8L0dyb3VwPgogICAgPFN1Ykdyb3VwPk5vdGlmeU1hbnlBcnRpY2xlczo6Q29yZTwvU3ViR3JvdXA+CiAgICA8U2V0dGluZz4KICAgICAgPFN0cmluZyBSZWdleD0iIj4yMDwvU3RyaW5nPgogICAgPC9TZXR0aW5nPgogIDwvQ29uZmlnSXRlbT4KCjwvb3Ryc19jb25maWc+Cg==