|
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 |
- |
|
|