Actions

Template

JourneyMaterials: Difference between revisions

From Dune Awakening DB

VisualWikitext
Created page with "<includeonly><!-- Template:JourneyMaterials (Optimized) --> <!-- Get and aggregate all materials for this journey --> {{#get_external_data:source=externaldb |from=data_journey_task_components jtc |join on=data_journey_tasks.id=jtc.task_id,data_journey_objectives.id=data_journey_tasks.objective_id |data=Component=jtc.component_name,Type=jtc.component_type,Qty=SUM(jtc.qty_needed) |cache=yes |where=data_journey_objectives.journey_id={{{id|{{{1|}}}}}} |group by=jtc.com..."
 
mNo edit summary
 
(24 intermediate revisions by the same user not shown)
Line 1: Line 1:
<includeonly><!-- Template:JourneyMaterials (Optimized) -->
{{#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 and aggregate all materials for this journey -->
<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>
{{#get_external_data:source=externaldb
</div>
|from=data_journey_task_components jtc
  <div class="materials-grid">
|join on=data_journey_tasks.id=jtc.task_id,data_journey_objectives.id=data_journey_tasks.objective_id
  <!-- LEVEL 1 – Direct Requirements -->
|data=Component=jtc.component_name,Type=jtc.component_type,Qty=SUM(jtc.qty_needed)
  <div class="material-column level-1-column">
|cache=yes
  <h3 class="column-header">Direct Requirements</h3>
|where=data_journey_objectives.journey_id={{{id|{{{1|}}}}}}
  <div class="material-items" data-level="1">
|group by=jtc.component_name, jtc.component_type
    {{#for_external_table:|
  |order by=jtc.component_name
      {{#ifeq:{{{Level}}}|1|
}}
<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>
      |}}
    }}
  </div>
  </div>


<!-- Count total materials -->
  <!-- LEVEL 2 – Components -->
{{#vardefine:mat_count|0}}
  <div class="material-column level-2-column">
{{#for_external_table:|{{#vardefine:mat_count|{{#expr:{{#var:mat_count}}+1}}}}}}
  <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-progress">
  <!-- LEVEL 3 – Base Resources -->
    <span class="materials-progress-text">Materials Collected</span>
  <div class="material-column level-3-column">
    <span class="materials-progress-count">0/{{#var:mat_count}}</span>
  <h3 class="column-header">Base Resources</h3>
</div>
  <div class="material-items" data-level="3">
<div class="materials-list">
    {{#for_external_table:|
    <div class="material-category">
      {{#ifeq:{{{Level}}}|3|
        <div class="material-category-title">Required Materials</div>
<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>
        {{#vardefine:mat_index|0}}
      |}}
        {{#for_external_table:|
    }}
            <div class="material-item" data-material-index="{{#var:mat_index}}">
  </div>
                <div class="material-checkbox"></div>
  </div>
                <div class="material-icon">
</div>
                    {{#ifexist:File:{{#replace:{{{Component}}}| |_}}_-_Icon.png
                    |[[File:{{#replace:{{{Component}}}| |_}}_-_Icon.png|20px|link=]]
                    |⚙️
                    }}
                </div>
                <div class="material-name">[[{{{Component}}}]]</div>
                <div class="material-qty">{{{Qty}}}</div>
            </div>
            {{#vardefine:mat_index|{{#expr:{{#var:mat_index}}+1}}}}
        }}
    </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"