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

(-)a/misc/cronjobs/thirdparty/TalkingTech_itiva_outbound.pl (-1 / +2 lines)
Lines 221-227 sub GetOverdueIssues { Link Here
221
                JOIN biblio USING (biblionumber)
221
                JOIN biblio USING (biblionumber)
222
                JOIN branches ON (issues.branchcode = branches.branchcode)
222
                JOIN branches ON (issues.branchcode = branches.branchcode)
223
                JOIN overduerules USING (categorycode)
223
                JOIN overduerules USING (categorycode)
224
                JOIN overduerules_transport_types USING ( overduerules_id )
224
                WHERE ( overduerules.branchcode = borrowers.branchcode or overduerules.branchcode = '')
225
                WHERE ( overduerules.branchcode = borrowers.branchcode or overduerules.branchcode = '')
226
                AND overduerules_transport_types.message_transport_type = 'phone'
225
                AND ( (TO_DAYS(NOW())-TO_DAYS(date_due) ) = delay1
227
                AND ( (TO_DAYS(NOW())-TO_DAYS(date_due) ) = delay1
226
                  OR  (TO_DAYS(NOW())-TO_DAYS(date_due) ) = delay2
228
                  OR  (TO_DAYS(NOW())-TO_DAYS(date_due) ) = delay2
227
                  OR  (TO_DAYS(NOW())-TO_DAYS(date_due) ) = delay3 )
229
                  OR  (TO_DAYS(NOW())-TO_DAYS(date_due) ) = delay3 )
228
- 

Return to bug 16568