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

(-)a/reports/cash_register_stats.pl (-2 / +2 lines)
Lines 108-114 if ($do_it) { Link Here
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)
110
        LEFT JOIN borrowers m ON (al.manager_id = m.borrowernumber)
110
        LEFT JOIN borrowers m ON (al.manager_id = m.borrowernumber)
111
        LEFT JOIN branches br ON (br.branchcode = m.branchcode )
111
        LEFT JOIN cash_registers cr ON (al.register_id = cr.id)
112
        LEFT JOIN branches br ON (br.branchcode = cr.branch)
112
        LEFT JOIN items i ON (i.itemnumber = al.itemnumber)
113
        LEFT JOIN items i ON (i.itemnumber = al.itemnumber)
113
        LEFT JOIN biblio bi ON (bi.biblionumber = i.biblionumber)
114
        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_credit_types act ON (al.credit_type_code = act.code)
115
- 

Return to bug 30551