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

(-)a/C4/Overdues.pm (-1 / +4 lines)
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
- 

Return to bug 11872