|
Lines 53-59
sub calculate {
Link Here
|
| 53 |
} |
53 |
} |
| 54 |
else { |
54 |
else { |
| 55 |
$sth = $dbh->prepare(" |
55 |
$sth = $dbh->prepare(" |
| 56 |
SELECT itemtype, description, biblioitems.itemtype, COUNT(*) AS total |
56 |
SELECT biblioitems.itemtype, description, biblioitems.itemtype, COUNT(*) AS total |
| 57 |
FROM itemtypes, biblioitems, items |
57 |
FROM itemtypes, biblioitems, items |
| 58 |
WHERE biblioitems.itemtype=itemtypes.itemtype |
58 |
WHERE biblioitems.itemtype=itemtypes.itemtype |
| 59 |
AND items.biblioitemnumber=biblioitems.biblioitemnumber |
59 |
AND items.biblioitemnumber=biblioitems.biblioitemnumber |
|
Lines 65-71
sub calculate {
Link Here
|
| 65 |
} else { |
65 |
} else { |
| 66 |
if (C4::Context->preference('item-level_itypes')) { |
66 |
if (C4::Context->preference('item-level_itypes')) { |
| 67 |
$sth = $dbh->prepare(" |
67 |
$sth = $dbh->prepare(" |
| 68 |
SELECT itemtype, description,items.itype AS itemtype, COUNT(*) AS total |
68 |
SELECT biblioitems.itemtype, description,items.itype AS itemtype, COUNT(*) AS total |
| 69 |
FROM itemtypes,items |
69 |
FROM itemtypes,items |
| 70 |
WHERE items.itype=itemtypes.itemtype |
70 |
WHERE items.itype=itemtypes.itemtype |
| 71 |
GROUP BY items.itype |
71 |
GROUP BY items.itype |
| 72 |
- |
|
|