php 8.1 deprecated null parameters fixed.

[fa-stable.git] / reporting / rep302.php

diff --git a/reporting/rep302.php b/reporting/rep302.php
index bfb515f1257ef238fdb0bb74b746eb3aa5fb148f..1c821689cf6cf067b9e2321d75a1c3a2da8a502f 100644 (file)
--- a/reporting/rep302.php
+++ b/reporting/rep302.php
@@ -36,7 +36,7 @@ function getTransactions($category, $location)
                        item.stock_id,
                        item.description, item.inactive,
                        IF(move.stock_id IS NULL, '', move.loc_code) AS loc_code,
-                       SUM(IFNULL(move.stock_id, 0)) AS qty_on_hand
+                       SUM(IF(move.stock_id IS NULL, 0, move.qty)) AS qty_on_hand
                FROM (".TB_PREF."stock_master item,"
                        .TB_PREF."stock_category category)
                        LEFT JOIN ".TB_PREF."stock_moves move ON item.stock_id=move.stock_id
@@ -113,11 +113,11 @@ function print_inventory_planning()
 
        $cols = array(0, 50, 150, 180, 210, 240, 270, 300, 330, 390, 435, 480, 525);
 
-       $per0 = strftime('%b',mktime(0,0,0,date('m'),1,date('Y')));
-       $per1 = strftime('%b',mktime(0,0,0,date('m')-1,1,date('Y')));
-       $per2 = strftime('%b',mktime(0,0,0,date('m')-2,1,date('Y')));
-       $per3 = strftime('%b',mktime(0,0,0,date('m')-3,1,date('Y')));
-       $per4 = strftime('%b',mktime(0,0,0,date('m')-4,1,date('Y')));
+       $per0 = substr(date('F',mktime(0,0,0,date('m'),1,date('Y'))), 0, 3);
+       $per1 = substr(date('F',mktime(0,0,0,date('m')-1,1,date('Y'))), 0, 3);
+       $per2 = substr(date('F',mktime(0,0,0,date('m')-2,1,date('Y'))), 0, 3);
+       $per3 = substr(date('F',mktime(0,0,0,date('m')-3,1,date('Y'))), 0, 3);
+       $per4 = substr(date('F',mktime(0,0,0,date('m')-4,1,date('Y'))), 0, 3);
 
        $headers = array(_('Category'), '', $per4, $per3, $per2, $per1, $per0, '3*M',
                _('QOH'), _('Cust Ord'), _('Supp Ord'), _('Sugg Ord'));