JourneyMaterials: Difference between revisions
From Dune Awakening DB
mNo edit summary |
mNo edit summary |
||
| Line 1: | Line 1: | ||
<includeonly><!-- Template:JourneyMaterials (procedure | <includeonly><!-- Template:JourneyMaterials (stored procedure) --> | ||
{{#get_external_data: | {{#get_external_data: | ||
source = externaldb | |||
|query = CALL sp_journey_components_bom({{{id|{{{1|}}}}}}) | |||
|data = Level = level, | |||
ItemLabel = item_label, | |||
TotalQty = total_qty | |||
|cache seconds = 3600 | |||
}} | }} | ||
<div class="materials-container" style="max-height: 600px; overflow-y: auto;"> | |||
<div class="materials-container"> | |||
{{#vardefine:current_level|0}}{{#vardefine:tier_open|false}} | {{#vardefine:current_level|0}}{{#vardefine:tier_open|false}} | ||
{{#for_external_table:| | {{#for_external_table:| | ||
{{#ifeq:{{{Level}}}|{{#var:current_level}}|| | {{#ifeq:{{{Level}}}|{{#var:current_level}}|| | ||
| Line 36: | Line 34: | ||
</div> | </div> | ||
}} | }} | ||
{{#ifeq:{{#var:tier_open}}|true|</div>|}} | {{#ifeq:{{#var:tier_open}}|true|</div>|}} | ||
</div> | </div> | ||
</includeonly><noinclude>{{Documentation}}</noinclude> | </includeonly><noinclude>{{Documentation}}</noinclude> | ||