diff options
Diffstat (limited to 'view_kitlocker.php')
| -rw-r--r-- | view_kitlocker.php | 31 |
1 files changed, 31 insertions, 0 deletions
diff --git a/view_kitlocker.php b/view_kitlocker.php new file mode 100644 index 0000000..2523337 --- /dev/null +++ b/view_kitlocker.php @@ -0,0 +1,31 @@ +<?php +/** + * Kitlocker group gallery — shows all stgrp items as a browsable grid. + * @package stock + */ + +namespace Bitweaver\Stock; + +use Bitweaver\KernelTools; + +require_once '../kernel/includes/setup_inc.php'; + +$gBitSystem->verifyPackage( 'stock' ); + +global $gBitSystem, $gBitSmarty, $gBitDb; + +$stgrpItems = $gBitDb->getAll( + "SELECT xi.`item`, xi.`cross_ref_title`, xi.`data`, + (SELECT COUNT(*) FROM `".BIT_DB_PREFIX."liberty_xref` x + INNER JOIN `".BIT_DB_PREFIX."liberty_content` lc ON lc.`content_id` = x.`content_id` + WHERE x.`item` = xi.`item` + AND lc.`content_type_guid` IN ('stockassembly','stockcomponent')) AS item_count + FROM `".BIT_DB_PREFIX."liberty_xref_item` xi + WHERE xi.`x_group` = 'stgrp' AND xi.`content_type_guid` = 'stock' + ORDER BY xi.`item`" +); + +$gBitSmarty->assign( 'stgrpItems', $stgrpItems ); + +$gBitSystem->setBrowserTitle( KernelTools::tra( 'Kitlocker' ) ); +$gBitSystem->display( 'bitpackage:stock/stock_fixed_grid_inc.tpl', null, [ 'display_mode' => 'display' ] ); |
