Lines 220-226
sub GetOverdueIssues {
Link Here
|
220 |
JOIN biblio USING (biblionumber) |
220 |
JOIN biblio USING (biblionumber) |
221 |
JOIN branches ON (issues.branchcode = branches.branchcode) |
221 |
JOIN branches ON (issues.branchcode = branches.branchcode) |
222 |
JOIN overduerules USING (categorycode) |
222 |
JOIN overduerules USING (categorycode) |
|
|
223 |
JOIN overduerules_transport_types USING ( overduerules_id ) |
223 |
WHERE ( overduerules.branchcode = borrowers.branchcode or overduerules.branchcode = '') |
224 |
WHERE ( overduerules.branchcode = borrowers.branchcode or overduerules.branchcode = '') |
|
|
225 |
AND overduerules_transport_types.message_transport_type = 'phone' |
224 |
AND ( (TO_DAYS(NOW())-TO_DAYS(date_due) ) = delay1 |
226 |
AND ( (TO_DAYS(NOW())-TO_DAYS(date_due) ) = delay1 |
225 |
OR (TO_DAYS(NOW())-TO_DAYS(date_due) ) = delay2 |
227 |
OR (TO_DAYS(NOW())-TO_DAYS(date_due) ) = delay2 |
226 |
OR (TO_DAYS(NOW())-TO_DAYS(date_due) ) = delay3 ) |
228 |
OR (TO_DAYS(NOW())-TO_DAYS(date_due) ) = delay3 ) |
227 |
- |
|
|