blob: 0974b7539d06f5602c6451e66be1fc5ec516416a (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
|
<?php
/**
* Kitlocker group gallery — shows all stgrp items as a browsable grid.
* @package stock
*/
namespace Bitweaver\Stock;
use Bitweaver\KernelTools;
use Bitweaver\Liberty\LibertyContent;
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`"
);
foreach( $stgrpItems as &$row ) {
if( !empty( $row['data'] ) ) {
$parseHash = [ 'data' => $row['data'], 'format_guid' => 'bithtml' ];
$row['parsed_data'] = LibertyContent::parseDataHash( $parseHash );
}
}
unset( $row );
$gBitSmarty->assign( 'stgrpItems', $stgrpItems );
$gBitSystem->setBrowserTitle( KernelTools::tra( 'Kitlocker' ) );
$gBitSystem->display( 'bitpackage:stock/stock_fixed_grid_inc.tpl', null, [ 'display_mode' => 'display' ] );
|
