Actions

Template

JourneyMaterials: Difference between revisions

From Dune Awakening DB

mNo edit summary
mNo edit summary
Line 1: Line 1:
<includeonly><!-- Template:JourneyMaterials (stored procedure) -->
<includeonly><!-- Template:JourneyMaterials -->
{{#get_external_data:
{{#get_external_data:
   source = externaldb
   source = externaldb
   |query = CALL sp_journey_components_bom({{{id|{{{1|}}}}}})
   |sql  = CALL sp_journey_components_bom({{{id|{{{1|}}}}}})
   |data  = Level    = level,
   |data  = Level    = level,
           ItemLabel = item_label,
           ItemLabel = item_label,
           TotalQty  = total_qty
           TotalQty  = total_qty
   |cache seconds = 3600
   |cache seconds = 3600      
}}
}}
<div class="materials-container" style="max-height: 600px; overflow-y: auto;">
 
<div class="materials-container" style="max-height:600px;overflow-y:auto;">
{{#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 34: Line 36:
   </div>
   </div>
}}
}}
{{#ifeq:{{#var:tier_open}}|true|</div>|}}
{{#ifeq:{{#var:tier_open}}|true|</div>|}}
</div>
</div>
</includeonly><noinclude>{{Documentation}}</noinclude>
</includeonly><noinclude>{{Documentation}}</noinclude>

Revision as of 18:10, 31 May 2025