|
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 |
- |
|
|