@@ -, +, @@ --- C4/Tags.pm | 7 ++++++- koha-tmpl/opac-tmpl/bootstrap/en/modules/opac-tags.tt | 9 +++++++-- 2 files changed, 13 insertions(+), 3 deletions(-) --- a/C4/Tags.pm +++ a/C4/Tags.pm @@ -208,7 +208,12 @@ sub get_tag_rows { push @exe_args, $hash->{$key}; } } - my $query = TAG_SELECT . ($wheres||'') . $limit; + my $query = q| + SELECT tall.tag_id, tall.borrowernumber, tall.biblionumber, tall.term, tall.language, tall.date_created, tapp.approved + FROM tags_all tall + LEFT JOIN tags_approval tapp ON tapp.term = tall.term + |; + $query .= ($wheres||'') . $limit; $debug and print STDERR "get_tag_rows query:\n $query\n", "get_tag_rows query args: ", join(',', @exe_args), "\n"; my $sth = C4::Context->dbh->prepare($query); --- a/koha-tmpl/opac-tmpl/bootstrap/en/modules/opac-tags.tt +++ a/koha-tmpl/opac-tmpl/bootstrap/en/modules/opac-tags.tt @@ -121,8 +121,13 @@ Tag: - - [% MY_TAG.term |html %] + [% IF MY_TAG.approved == 1 %] + [% MY_TAG.term |html %] + [% ELSE %] + [% MY_TAG.term |html %] (not approved) + [% END %] + + [% IF ( MY_TAG.XSLTBloc ) %] [% MY_TAG.XSLTBloc %] --