From 004c40ff62cf9d6822af0d6f8dfab38533f78d17 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Fri, 30 Sep 2011 10:03:04 +0200 Subject: [PATCH] 0001091: Stock Check Sheets and Inventory Planning Report slow with lots of category and items --- reporting/rep302.php | 2 +- reporting/rep303.php | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/reporting/rep302.php b/reporting/rep302.php index 75feef5..cdeae91 100644 --- a/reporting/rep302.php +++ b/reporting/rep302.php @@ -40,7 +40,7 @@ function getTransactions($category, $location) FROM (".TB_PREF."stock_master, ".TB_PREF."stock_category) LEFT JOIN ".TB_PREF."stock_moves ON - (".TB_PREF."stock_master.stock_id=".TB_PREF."stock_moves.stock_id OR ".TB_PREF."stock_master.stock_id IS NULL) + (".TB_PREF."stock_master.stock_id=".TB_PREF."stock_moves.stock_id) WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id AND (".TB_PREF."stock_master.mb_flag='B' OR ".TB_PREF."stock_master.mb_flag='M')"; if ($category != 0) diff --git a/reporting/rep303.php b/reporting/rep303.php index d9904bf..a7beebc 100644 --- a/reporting/rep303.php +++ b/reporting/rep303.php @@ -41,7 +41,7 @@ function getTransactions($category, $location) FROM (".TB_PREF."stock_master, ".TB_PREF."stock_category) LEFT JOIN ".TB_PREF."stock_moves ON - (".TB_PREF."stock_master.stock_id=".TB_PREF."stock_moves.stock_id OR ".TB_PREF."stock_master.stock_id IS NULL) + (".TB_PREF."stock_master.stock_id=".TB_PREF."stock_moves.stock_id) WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id AND (".TB_PREF."stock_master.mb_flag='B' OR ".TB_PREF."stock_master.mb_flag='M')"; if ($category != 0) -- 2.30.2