Actions

Template

JourneyMaterials: Difference between revisions

From Dune Awakening DB

mNo edit summary
mNo edit summary
Line 1: Line 1:
<includeonly><!-- Template:JourneyMaterials (uses vw_journey_components_bom) -->
<includeonly><!-- Template:JourneyMaterials (procedure version) -->
{{#get_external_data:
{{#get_db_data:
   source = externaldb
   db  = externaldb


   |from  = vw_journey_components_bom          <!-- the view we just built -->
   |sql =
    CALL sp_journey_components_bom({{{id|{{{1|}}}}}});


   |data = Level    = level,
   |data =
          ItemLabel = item_label,
      Level    = level,
          TotalQty  = total_qty
      ItemLabel = item_label,
      TotalQty  = total_qty


  |where = journey_id = {{{id|{{{1|}}}}}}
   |cache = yes             <!-- optional; keeps result for default TTL -->
 
  |order by = level,
              item_label
 
   |cache = yes
}}
}}


Line 22: Line 19:


{{#for_external_table:|
{{#for_external_table:|
   <!-- start new tier block if level changes -->
   <!-- open/close tier blocks -->
   {{#ifeq:{{{Level}}}|{{#var:current_level}}||
   {{#ifeq:{{{Level}}}|{{#var:current_level}}||
     {{#ifeq:{{#var:tier_open}}|true|</div>|}}   <!-- close old tier if open -->
     {{#ifeq:{{#var:tier_open}}|true|</div>|}}
     <div class="materials-tier level-{{{Level}}}">
     <div class="materials-tier level-{{{Level}}}">
       <div class="tier-header">{{#switch:{{{Level}}}
       <div class="tier-header">{{#switch:{{{Level}}}
Line 49: Line 46:
}}
}}


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

Revision as of 15:32, 31 May 2025