Lines 43-49
BEGIN {
Link Here
|
43 |
&subfield_is_koha_internal_p |
43 |
&subfield_is_koha_internal_p |
44 |
&GetPrinters &GetPrinter |
44 |
&GetPrinters &GetPrinter |
45 |
&GetItemTypes &getitemtypeinfo |
45 |
&GetItemTypes &getitemtypeinfo |
46 |
&GetItemTypesCategorized &GetItemTypesByCategory |
46 |
&GetItemTypesCategorized &GetItemTypesByCategory |
47 |
&GetSupportName &GetSupportList |
47 |
&GetSupportName &GetSupportList |
48 |
&get_itemtypeinfos_of |
48 |
&get_itemtypeinfos_of |
49 |
&getframeworks &getframeworkinfo |
49 |
&getframeworks &getframeworkinfo |
Lines 288-296
sub GetItemTypesCategorized {
Link Here
|
288 |
my $query = qq| |
288 |
my $query = qq| |
289 |
SELECT itemtype, description, imageurl, hideinopac, 0 as 'iscat' FROM itemtypes WHERE ISNULL(searchcategory) or length(searchcategory) = 0 |
289 |
SELECT itemtype, description, imageurl, hideinopac, 0 as 'iscat' FROM itemtypes WHERE ISNULL(searchcategory) or length(searchcategory) = 0 |
290 |
UNION |
290 |
UNION |
291 |
SELECT DISTINCT searchcategory AS `itemtype`, authorised_values.lib_opac AS description, authorised_values.imageurl AS imageurl, hideinopac, 1 as 'iscat' |
291 |
SELECT DISTINCT searchcategory AS `itemtype`, |
292 |
FROM itemtypes |
292 |
authorised_values.lib_opac AS description, |
293 |
LEFT JOIN authorised_values ON searchcategory = authorised_value WHERE searchcategory > '' |
293 |
authorised_values.imageurl AS imageurl, |
|
|
294 |
hideinopac, 1 as 'iscat' |
295 |
FROM itemtypes |
296 |
LEFT JOIN authorised_values ON searchcategory = authorised_value |
297 |
WHERE searchcategory > '' |
294 |
|; |
298 |
|; |
295 |
my $sth = $dbh->prepare($query); |
299 |
my $sth = $dbh->prepare($query); |
296 |
$sth->execute; |
300 |
$sth->execute; |
297 |
- |
|
|