Lines 93-98
overdue items. It is primarily used by the 'misc/fines2.pl' script.
Link Here
|
93 |
|
93 |
|
94 |
Returns the list of all overdue books, with their itemtype. |
94 |
Returns the list of all overdue books, with their itemtype. |
95 |
|
95 |
|
|
|
96 |
This list does not include overdue items that are marked lost |
97 |
|
96 |
C<$overdues> is a reference-to-array. Each element is a |
98 |
C<$overdues> is a reference-to-array. Each element is a |
97 |
reference-to-hash whose keys are the fields of the issues table in the |
99 |
reference-to-hash whose keys are the fields of the issues table in the |
98 |
Koha database. |
100 |
Koha database. |
Lines 110-115
sub Getoverdues {
Link Here
|
110 |
FROM issues |
112 |
FROM issues |
111 |
LEFT JOIN items USING (itemnumber) |
113 |
LEFT JOIN items USING (itemnumber) |
112 |
WHERE date_due < NOW() |
114 |
WHERE date_due < NOW() |
|
|
115 |
AND itemlost = 0 |
113 |
"; |
116 |
"; |
114 |
} else { |
117 |
} else { |
115 |
$statement = " |
118 |
$statement = " |
Lines 118-123
LEFT JOIN items USING (itemnumber)
Link Here
|
118 |
LEFT JOIN items USING (itemnumber) |
121 |
LEFT JOIN items USING (itemnumber) |
119 |
LEFT JOIN biblioitems USING (biblioitemnumber) |
122 |
LEFT JOIN biblioitems USING (biblioitemnumber) |
120 |
WHERE date_due < NOW() |
123 |
WHERE date_due < NOW() |
|
|
124 |
AND itemlost = 0 |
121 |
"; |
125 |
"; |
122 |
} |
126 |
} |
123 |
|
127 |
|
124 |
- |
|
|