Actions

Template

JourneyMaterials: Difference between revisions

From Dune Awakening DB

mNo edit summary
mNo edit summary
Line 1: Line 1:
<includeonly><!-- Template:JourneyMaterials (procedure version) -->
<includeonly><!-- Template:JourneyMaterials (procedure version) -->
{{#get_db_data:
{{#get_db_data:
  db = externaldb
db=externaldb
 
|sql=CALL sp_journey_components_bom({{{id|{{{1|}}}}}});
  |sql =
|data=Level=level,
    CALL sp_journey_components_bom({{{id|{{{1|}}}}}});
       ItemLabel=item_label,
 
       TotalQty=total_qty
  |data =
|cache=yes
      Level     = level,
       ItemLabel = item_label,
       TotalQty = total_qty
 
  |cache = yes             <!-- optional; keeps result for default TTL -->
}}
}}


<div class="materials-container">
<div class="materials-container">
{{#vardefine:current_level|0}}
{{#vardefine:current_level|0}}{{#vardefine:tier_open|false}}
{{#vardefine:tier_open|false}}


{{#for_external_table:|
{{#for_external_table:|
  <!-- open/close tier blocks -->
   {{#ifeq:{{{Level}}}|{{#var:current_level}}||
   {{#ifeq:{{{Level}}}|{{#var:current_level}}||
     {{#ifeq:{{#var:tier_open}}|true|</div>|}}
     {{#ifeq:{{#var:tier_open}}|true|</div>|}}
Line 32: Line 25:
     {{#vardefine:current_level|{{{Level}}}}}
     {{#vardefine:current_level|{{{Level}}}}}
   }}
   }}
  <!-- material row -->
   <div class="material-item">
   <div class="material-item">
     <span class="material-icon">
     <span class="material-icon">
Line 46: Line 37:
}}
}}


{{#ifeq:{{#var:tier_open}}|true|</div>|}} <!-- close the last tier -->
{{#ifeq:{{#var:tier_open}}|true|</div>|}}
<div class="materials-summary">
<div class="materials-summary">
   <p>Materials are shown in tiers. Level&nbsp;1 are direct requirements; subsequent levels show components needed to craft those items.</p>
   <p>Materials are shown in tiers. Level&nbsp;1 are direct requirements; subsequent levels show the components needed to craft those items.</p>
</div>
</div>
</div>
</div>
</includeonly><noinclude>{{Documentation}}</noinclude>
</includeonly><noinclude>{{Documentation}}</noinclude>

Revision as of 15:39, 31 May 2025