From f01da91c553b7d256b053475c0f5dc026c47c10d Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Sun, 12 Aug 2018 14:46:48 +0200 Subject: [PATCH] Avoid running same query multiple times. Rep307.php. Fixed --- reporting/rep307.php | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/reporting/rep307.php b/reporting/rep307.php index aee04a26..18cfc6ea 100644 --- a/reporting/rep307.php +++ b/reporting/rep307.php @@ -155,11 +155,11 @@ function inventory_movements() $inward += trans_qty($myrow['stock_id'], $location, $from_date, $to_date); $outward += trans_qty($myrow['stock_id'], $location, $from_date, $to_date, false); - $rep->AmountCol(3, 4, $qoh_start, get_qty_dec($myrow['stock_id'])); - $rep->AmountCol(4, 5, $inward, get_qty_dec($myrow['stock_id'])); - $rep->AmountCol(5, 6, $outward, get_qty_dec($myrow['stock_id'])); - $rep->AmountCol(6, 7, $qoh_end, get_qty_dec($myrow['stock_id'])); - + $stock_qty_dec = get_qty_dec($myrow['stock_id']); + $rep->AmountCol(3, 4, $qoh_start, $stock_qty_dec); + $rep->AmountCol(4, 5, $inward, $stock_qty_dec); + $rep->AmountCol(5, 6, $outward, $stock_qty_dec); + $rep->AmountCol(6, 7, $qoh_end, $stock_qty_dec); $rep->NewLine(0, 1); } $rep->Line($rep->row - 4); -- 2.30.2