diff options
| -rwxr-xr-x | includes/classes/StockAssembly.php | 7 | ||||
| -rwxr-xr-x | templates/user_galleries.tpl | 10 |
2 files changed, 15 insertions, 2 deletions
diff --git a/includes/classes/StockAssembly.php b/includes/classes/StockAssembly.php index 10a59d7..db017f7 100755 --- a/includes/classes/StockAssembly.php +++ b/includes/classes/StockAssembly.php @@ -1007,6 +1007,13 @@ class StockAssembly extends StockBase { AND mc.`content_type_guid` = 'stockmovement' AND mc.`user_id` = lc.`user_id` INNER JOIN `{$X}liberty_xref` xpbld ON xpbld.`content_id` = xasm.`content_id` AND xpbld.`item` = 'PBLD' WHERE xasm.`item` = 'ASSEMBLY' AND xasm.`xref` = lc.`content_id`) AS `prebuild_count`"; + $selectSql .= ", (SELECT FIRST 1 xpbld.`content_id` + FROM `{$X}liberty_xref` xasm + INNER JOIN `{$X}liberty_content` mc ON mc.`content_id` = xasm.`content_id` + AND mc.`content_type_guid` = 'stockmovement' AND mc.`user_id` = lc.`user_id` + INNER JOIN `{$X}liberty_xref` xpbld ON xpbld.`content_id` = xasm.`content_id` AND xpbld.`item` = 'PBLD' + WHERE xasm.`item` = 'ASSEMBLY' AND xasm.`xref` = lc.`content_id` + ORDER BY mc.`created` DESC) AS `prebuild_content_id`"; if( !empty( $pListHash['stgrp'] ) ) { $whereSql .= " AND EXISTS (SELECT 1 FROM `".BIT_DB_PREFIX."liberty_xref` sx WHERE sx.`content_id` = lc.`content_id` AND sx.`item` = ?)"; diff --git a/templates/user_galleries.tpl b/templates/user_galleries.tpl index bda5520..8813e23 100755 --- a/templates/user_galleries.tpl +++ b/templates/user_galleries.tpl @@ -37,8 +37,14 @@ <dl class="dl-horizontal small" style="margin-bottom:0"> <dt>{tr}Components{/tr}</dt> <dd>{$gal.component_count}</dd> - <dt>{tr}Prebuilt{/tr}</dt> - <dd>{$gal.prebuild_count|string_format:"%.0f"}</dd> + {if $gal.prebuild_content_id} + {assign var=pbldUrl value="`$smarty.const.STOCK_PKG_URL`view_movement.php?content_id=`$gal.prebuild_content_id`"} + <dt><a href="{$pbldUrl}">{tr}Prebuilt{/tr}</a></dt> + <dd><a href="{$pbldUrl}">{$gal.prebuild_count|string_format:"%.0f"}</a></dd> + {else} + <dt>{tr}Prebuilt{/tr}</dt> + <dd>{$gal.prebuild_count|string_format:"%.0f"}</dd> + {/if} </dl> </div> </div> |