From: Joe Hunt <joe.hunt.consulting@gmail.com>
Date: Sun, 12 Aug 2018 12:46:48 +0000 (+0200)
Subject: Avoid running same query multiple times. Rep307.php. Fixed
X-Git-Url: https://delta.frontaccounting.com/gitweb/?p=fa-stable.git;a=commitdiff_plain;h=f01da91c553b7d256b053475c0f5dc026c47c10d

Avoid running same query multiple times. Rep307.php. Fixed
---

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