X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;f=C4%2FSuggestions.pm;h=c7955d7ca12e17298aeab4b9dc35f5e54de40a09;hb=0a460254b4dedce0220e6c88c22f2c63ac159faa;hp=4250db06f7f76b006dcda4fc3a11576bd606b798;hpb=5e9465a14a5dabb928d50d207475b1fd96247bbc;p=koha.git

diff --git a/C4/Suggestions.pm b/C4/Suggestions.pm
index 4250db06f7..c7955d7ca1 100644
--- a/C4/Suggestions.pm
+++ b/C4/Suggestions.pm
@@ -89,9 +89,12 @@ sub SearchSuggestion  {
     my $dbh = C4::Context->dbh;
     my $query = "
     SELECT suggestions.*,
+        U1.branchcode   AS branchcodesuggestedby,
         U1.surname   AS surnamesuggestedby,
         U1.firstname AS firstnamesuggestedby,
         U1.borrowernumber AS borrnumsuggestedby,
+        U1.categorycode AS categorycodesuggestedby,
+        U2.branchcode AS branchcodemanagedby,
         U2.surname   AS surnamemanagedby,
         U2.firstname AS firstnamemanagedby,
         U2.borrowernumber AS borrnummanagedby
@@ -223,7 +226,9 @@ sub GetSuggestionByStatus {
     my $query = qq(SELECT suggestions.*,
                         U1.surname   AS surnamesuggestedby,
                         U1.firstname AS firstnamesuggestedby,
-						U1.borrowernumber AS borrnumsuggestedby,
+            U1.branchcode AS branchcodesuggestedby,
+			U1.borrowernumber AS borrnumsuggestedby,
+			U1.categorycode AS categorycodesuggestedby,
                         U2.surname   AS surnamemanagedby,
                         U2.firstname AS firstnamemanagedby,
 						U2.borrowernumber AS borrnummanagedby
@@ -427,7 +432,8 @@ sub ModStatus {
         To => $emailinfo->{byemail},
         From => $emailinfo->{libemail},
         Subject => 'Koha suggestion',
-        Message => "".$template->output
+        Message => "".$template->output,
+        'Content-Type' => 'text/plain; charset="utf8"',
     );
     sendmail(%mail);
 }