view_component: add Stock Levels tab showing movement totals per qty type

Query mirrors list_stock.php for a single component. Tab shows
level per qty type with danger/warning colouring, plus a link
to filtered stock history.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

1 files changed, 25 insertions, 0 deletions

diff --git a/view_component.php b/view_component.php
index 6f8ec93..de1958a 100755
--- a/view_component.php
+++ b/view_component.php
@@ -36,4 +36,29 @@ $gContent->addHit();
 
 $gContent->mInfo['stockcomponent_types'] = $gContent->getXrefGroupList();
 
+// Stock levels for this component, calculated from movement xrefs
+if( $gContent->isValid() ) {
+	$X    = BIT_DB_PREFIX;
+	$rows = $gBitDb->query(
+		"SELECT x.`item` AS qty_type,
+				SUM( CASE WHEN EXISTS (
+					SELECT 1 FROM `{$X}liberty_xref` r
+					WHERE r.`content_id` = x.`content_id` AND r.`item` IN ('TRANS','ORDER')
+				) THEN CAST(x.`xkey` AS DOUBLE PRECISION)
+				  ELSE -CAST(x.`xkey` AS DOUBLE PRECISION) END ) AS stock_level
+		 FROM `{$X}liberty_xref` x
+		 INNER JOIN `{$X}liberty_content` mc ON mc.`content_id` = x.`content_id`
+		 	AND mc.`content_type_guid` = 'stockmovement'
+		 WHERE x.`xref` = ? AND x.`item` IN ('SGL','PCK','SHT','VOL')
+		   AND x.`xkey` SIMILAR TO '[0-9]+(\.[0-9]+)?'
+		 GROUP BY x.`item`",
+		[ $gContent->mContentId ]
+	);
+	$stockLevels = [];
+	foreach( $rows as $row ) {
+		$stockLevels[$row['qty_type']] = (float)$row['stock_level'];
+	}
+	$gBitSmarty->assign( 'componentStockLevels', $stockLevels );
+}
+
 require_once STOCK_PKG_INCLUDE_PATH.'display_stock_component_inc.php';