View | Details | Raw Unified | Return to bug 6379
Collapse All | Expand All

(-)a/C4/Tags.pm (-1 / +6 lines)
Lines 208-214 sub get_tag_rows { Link Here
208
			push @exe_args, $hash->{$key};
208
			push @exe_args, $hash->{$key};
209
		}
209
		}
210
	}
210
	}
211
    my $query = TAG_SELECT . ($wheres||'') . $limit;
211
    my $query = q|
212
        SELECT tall.tag_id, tall.borrowernumber, tall.biblionumber, tall.term, tall.language, tall.date_created, tapp.approved
213
        FROM tags_all tall
214
        LEFT JOIN tags_approval tapp ON tapp.term = tall.term
215
    |;
216
    $query .= ($wheres||'') . $limit;
212
	$debug and print STDERR "get_tag_rows query:\n $query\n",
217
	$debug and print STDERR "get_tag_rows query:\n $query\n",
213
							"get_tag_rows query args: ", join(',', @exe_args), "\n";
218
							"get_tag_rows query args: ", join(',', @exe_args), "\n";
214
	my $sth = C4::Context->dbh->prepare($query);
219
	my $sth = C4::Context->dbh->prepare($query);
(-)a/koha-tmpl/opac-tmpl/bootstrap/en/modules/opac-tags.tt (-3 / +7 lines)
Lines 121-128 Link Here
121
                                        <tr>
121
                                        <tr>
122
                                            <td class="tagterm">
122
                                            <td class="tagterm">
123
                                                <span class="tdlabel">Tag:</span>
123
                                                <span class="tdlabel">Tag:</span>
124
                                                <a href="/cgi-bin/koha/opac-search.pl?tag=[% MY_TAG.term |url %]&amp;q=[% MY_TAG.term |url %]">
124
                                                [% IF MY_TAG.approved == 1 %]
125
                                            [% MY_TAG.term |html %]</a></td>
125
                                                    <a href="/cgi-bin/koha/opac-search.pl?tag=[% MY_TAG.term |url %]&amp;q=[% MY_TAG.term |url %]">[% MY_TAG.term |html %]</a>
126
                                                [% ELSE %]
127
                                                    [% MY_TAG.term |html %] (not approved)
128
                                                [% END %]
129
                                            </td>
130
126
                                            <td>
131
                                            <td>
127
                                                [% IF ( MY_TAG.XSLTBloc ) %]
132
                                                [% IF ( MY_TAG.XSLTBloc ) %]
128
                                                    [% MY_TAG.XSLTBloc %]
133
                                                    [% MY_TAG.XSLTBloc %]
129
- 

Return to bug 6379