Actions

Template

JourneyMaterials: Difference between revisions

From Dune Awakening DB

← Older edit
VisualWikitext
mNo edit summary
mNo edit summary
 
(21 intermediate revisions by the same user not shown)
Line 1: Line 1:
<includeonly><!-- Template:JourneyMaterials (fixed join order) -->
{{#get_external_data:source        = externaldb|from        = data_journey_materials|data        = Level=level, ItemLabel=item_label, TotalQty=total_qty, InternalName=internal_name|where        = journey_id = {{{id|{{{1|}}}}}}|order by    = level, item_label|cache        = yes}}
{{#get_external_data:
<div class="materials-enhanced-container"><div class="materials-progress-header materials-progress"><div class="progress-bar-container"><div class="progress-bar" data-progress="0"></div></div><div class="materials-progress-text"><span class="materials-progress-count">0/0</span> Materials Ready</div>
  source        = externaldb
</div>
  |from        = data_journey_objectives
<div class="materials-grid">
  |join on      = data_journey_tasks.objective_id = data_journey_objectives.id;
  <!-- LEVEL 1 – Direct Requirements -->
                  data_journey_task_components.task_id = data_journey_tasks.id;
   <div class="material-column level-1-column">
                  vw_recipe_inputs_by_level.root_item = data_journey_task_components.component_name
  <h3 class="column-header">Direct Requirements</h3>
  |data        = Level     = vw_recipe_inputs_by_level.level,
  <div class="material-items" data-level="1">
                  ItemLabel = vw_recipe_inputs_by_level.item_label,
    {{#for_external_table:|
                  TotalQty   = vw_recipe_inputs_by_level.total_qty,
      {{#ifeq:{{{Level}}}|1|
                  RootItem  = vw_recipe_inputs_by_level.root_item
<div class="material-item" data-item="{{{InternalName}}}" data-level="1"><div class="material-checkbox-wrapper"><span class="material-checkbox" data-qty="{{{TotalQty}}}"></span></div><div class="material-content"><span class="material-name">{{{ItemLabel}}}</span><span class="material-qty">{{{TotalQty}}}</span></div><div class="material-children-indicator"></div></div>
  |where        = data_journey_objectives.journey_id = {{{id|{{{1|}}}}}}
      |}}
  |group by    = vw_recipe_inputs_by_level.root_item,
    }}
                  vw_recipe_inputs_by_level.level,
  </div>
                  vw_recipe_inputs_by_level.item_label,
  </div>
                  vw_recipe_inputs_by_level.total_qty
   |order by    = vw_recipe_inputs_by_level.root_item,
                  vw_recipe_inputs_by_level.level,
                  vw_recipe_inputs_by_level.item_label
  |cache        = yes
}}


  <!-- LEVEL 2 – Components -->
  <div class="material-column level-2-column">
  <h3 class="column-header">Components</h3>
  <div class="material-items" data-level="2">
    {{#for_external_table:|
      {{#ifeq:{{{Level}}}|2|
<div class="material-item" data-item="{{{InternalName}}}" data-level="2"><div class="material-checkbox-wrapper"><span class="material-checkbox" data-qty="{{{TotalQty}}}"></span></div><div class="material-content"><span class="material-name">{{{ItemLabel}}}</span><span class="material-qty">{{{TotalQty}}}</span></div><div class="material-children-indicator"></div></div>
      |}}
    }}
  </div>
  </div>


<div class="materials-container">
  <!-- LEVEL 3 – Base Resources -->
<!-- Initialize variables -->
  <div class="material-column level-3-column">
{{#vardefine:current_level|0}}
  <h3 class="column-header">Base Resources</h3>
{{#vardefine:tier_open|false}}
  <div class="material-items" data-level="3">
 
    {{#for_external_table:|
<!-- Loop through materials -->
      {{#ifeq:{{{Level}}}|3|
{{#for_external_table:|
<div class="material-item" data-item="{{{InternalName}}}" data-level="3"><div class="material-checkbox-wrapper"><span class="material-checkbox" data-qty="{{{TotalQty}}}"></span></div><div class="material-content"><span class="material-name">{{{ItemLabel}}}</span><span class="material-qty">{{{TotalQty}}}</span></div></div>
    <!-- Check if we need to start a new tier -->
      |}}
    {{#ifeq:{{{Level}}}|{{#var:current_level}}||
        <!-- Close previous tier if open -->
        {{#ifeq:{{#var:tier_open}}|true|</div>|}}
       
        <!-- Start new tier -->
        <div class="materials-tier level-{{{Level}}}">
            <div class="tier-header">{{#switch:{{{Level}}}
                |1=Direct Materials Required
                |2=Components for Level 1 Materials 
                |3=Base Resources Needed
                |#default=Level {{{Level}}} Materials
            }}</div>
        {{#vardefine:tier_open|true}}
        {{#vardefine:current_level|{{{Level}}}}}
     }}
     }}
   
  </div>
    <!-- Display material -->
  </div>
    <div class="material-item">
</div>
        <span class="material-icon">
            {{#ifexist:File:{{#replace:{{{ItemLabel}}}| |_}}_-_Icon.png
            |[[File:{{#replace:{{{ItemLabel}}}| |_}}_-_Icon.png|20px|link=]]
            |
            }}
        </span>
        <span class="material-name">{{{ItemLabel}}}</span>
        <span class="material-qty">{{{TotalQty}}}</span>
    </div>
}}
 
{{#ifeq:{{#var:tier_open}}|true|</div>|}}
<!-- Summary -->
<div class="materials-summary">
    <p>Materials are shown in tiers. Level 1 are direct requirements, subsequent levels show components needed to craft those items.</p>
</div>
</div>
</includeonly><noinclude>
{{Documentation}}
</noinclude>

Latest revision as of 01:48, 2 June 2025

The query SELECT level,item_label,total_qty,internal_name FROM `data_journey_materials` WHERE journey_id = ORDER BY level, item_label is invalid (Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY level, item_label' at line 1 Function: EDConnectorRdbms::fetch Query: SELECT level,item_label,total_qty,internal_name FROM `data_journey_materials` WHERE journey_id = ORDER BY level, item_label ).

0/0 Materials Ready

Direct Requirements

Components

Base Resources

Retrieved from "https://dunedb.com/index.php?title=Template:JourneyMaterials&oldid=846"