Lines 111-116
if ($do_it) {
Link Here
|
111 |
LEFT JOIN account_credit_types act ON (al.credit_type_code = act.code) |
111 |
LEFT JOIN account_credit_types act ON (al.credit_type_code = act.code) |
112 |
LEFT JOIN account_debit_types adt ON (al.debit_type_code = adt.code) |
112 |
LEFT JOIN account_debit_types adt ON (al.debit_type_code = adt.code) |
113 |
WHERE CAST(al.date AS DATE) BETWEEN ? AND ? |
113 |
WHERE CAST(al.date AS DATE) BETWEEN ? AND ? |
|
|
114 |
AND al.borrowernumber NOT in ( |
115 |
SELECT borrowernumber |
116 |
FROM accountlines |
117 |
WHERE debit_type_code = 'VOID' |
118 |
WHERE credit_type_code = 'VOID' |
119 |
) |
114 |
$whereTType |
120 |
$whereTType |
115 |
$whereBranchCode |
121 |
$whereBranchCode |
116 |
$whereRegister |
122 |
$whereRegister |
117 |
- |
|
|