Lines 100-109
if ($do_it) {
Link Here
|
100 |
} |
100 |
} |
101 |
|
101 |
|
102 |
my $query = " |
102 |
my $query = " |
103 |
SELECT round(amount,2) AS amount, description, |
103 |
SELECT round(amount,2) AS amount, al.description, |
104 |
bo.surname AS bsurname, bo.firstname AS bfirstname, m.surname AS msurname, m.firstname AS mfirstname, |
104 |
bo.surname AS bsurname, bo.firstname AS bfirstname, m.surname AS msurname, m.firstname AS mfirstname, |
105 |
bo.cardnumber, br.branchname, bo.borrowernumber, |
105 |
bo.cardnumber, br.branchname, bo.borrowernumber, |
106 |
al.borrowernumber, DATE(al.date) as date, al.credit_type_code, al.debit_type_code, al.amountoutstanding, al.note, al.timestamp, |
106 |
al.borrowernumber, DATE(al.date) as date, al.credit_type_code, al.debit_type_code, COALESCE(act.description,al.credit_type_code,adt.description,al.debit_type_code) AS type_description, al.amountoutstanding, al.note, al.timestamp, |
107 |
bi.title, bi.biblionumber, i.barcode, i.itype |
107 |
bi.title, bi.biblionumber, i.barcode, i.itype |
108 |
FROM accountlines al |
108 |
FROM accountlines al |
109 |
LEFT JOIN borrowers bo ON (al.borrowernumber = bo.borrowernumber) |
109 |
LEFT JOIN borrowers bo ON (al.borrowernumber = bo.borrowernumber) |
Lines 111-116
if ($do_it) {
Link Here
|
111 |
LEFT JOIN branches br ON (br.branchcode = m.branchcode ) |
111 |
LEFT JOIN branches br ON (br.branchcode = m.branchcode ) |
112 |
LEFT JOIN items i ON (i.itemnumber = al.itemnumber) |
112 |
LEFT JOIN items i ON (i.itemnumber = al.itemnumber) |
113 |
LEFT JOIN biblio bi ON (bi.biblionumber = i.biblionumber) |
113 |
LEFT JOIN biblio bi ON (bi.biblionumber = i.biblionumber) |
|
|
114 |
LEFT JOIN account_credit_types act ON (al.credit_type_code = act.code) |
115 |
LEFT JOIN account_debit_types adt ON (al.debit_type_code = adt.code) |
114 |
WHERE CAST(al.date AS DATE) BETWEEN ? AND ? |
116 |
WHERE CAST(al.date AS DATE) BETWEEN ? AND ? |
115 |
$whereTType |
117 |
$whereTType |
116 |
$whereBranchCode |
118 |
$whereBranchCode |
Lines 164-170
if ($do_it) {
Link Here
|
164 |
$row->{branchname}, |
166 |
$row->{branchname}, |
165 |
$row->{date}, |
167 |
$row->{date}, |
166 |
$row->{timestamp}, |
168 |
$row->{timestamp}, |
167 |
$row->{credit_type_code} || $row->{debit_type_code}, |
169 |
$row->{type_description}, |
168 |
$row->{note}, |
170 |
$row->{note}, |
169 |
$row->{amount}, |
171 |
$row->{amount}, |
170 |
$row->{title}, |
172 |
$row->{title}, |
171 |
- |
|
|