Rerun Optimizing rep107.php.
authorJoe Hunt <joe.hunt.consulting@gmail.com>
Sun, 14 Jun 2020 08:08:14 +0000 (10:08 +0200)
committerJoe Hunt <joe.hunt.consulting@gmail.com>
Sun, 14 Jun 2020 08:08:14 +0000 (10:08 +0200)
reporting/rep107.php

index 83476d2135de1dce8f249627b8a4abc0cdca4c2c..501cf44c46016e6c0ec613d86cf5fe9e405aa109 100644 (file)
@@ -47,7 +47,7 @@ function get_invoice_range($from, $to, $currency=false)
                ." AND trans.trans_no BETWEEN ".db_escape($from)." AND ".db_escape($to);                        
 
        if ($currency !== false)
-               " AND cust.curr_code=".db_escape($currency);
+               $sql .= " AND cust.curr_code=".db_escape($currency);
 
        $sql .= " ORDER BY trans.tran_date, trans.$ref";