Actions

Template

JourneyMaterials: Difference between revisions

From Dune Awakening DB

← Older edit
VisualWikitext
mNo edit summary
mNo edit summary
 
(6 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{#get_external_data:
{{#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}}
  source = externaldb
<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>
  |from = data_journey_materials
</div>
  |data = Level=level, ItemLabel=item_label, TotalQty=total_qty, InternalName=internal_name
<div class="materials-grid">
  |where = journey_id = {{{id|{{{1|}}}}}}
   <!-- LEVEL 1 – Direct Requirements -->
  |order by = level, item_label
  <div class="material-column level-1-column">
   |cache = yes
  <h3 class="column-header">Direct Requirements</h3>
}}
  <div class="material-items" data-level="1">
    {{#for_external_table:|
      {{#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>


<div class="materials-enhanced-container">
  <!-- LEVEL 2 – Components -->
  <!-- Progress Header -->
  <div class="material-column level-2-column">
  <div class="materials-progress-header">
  <h3 class="column-header">Components</h3>
     <div class="progress-bar-container">
  <div class="material-items" data-level="2">
      <div class="progress-bar" data-progress="0"></div>
     {{#for_external_table:|
    </div>
      {{#ifeq:{{{Level}}}|2|
    <div class="progress-text">
<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>
      <span class="progress-count">0</span> / <span class="total-count">0</span> Materials Ready
      |}}
     </div>
     }}
  </div>
   </div>
   </div>
 
 
   <!-- Materials Grid -->
   <!-- LEVEL 3 – Base Resources -->
   <div class="materials-grid">
   <div class="material-column level-3-column">
    <!-- Level 1 Column -->
  <h3 class="column-header">Base Resources</h3>
    <div class="material-column level-1-column">
  <div class="material-items" data-level="3">
      <h3 class="column-header">
    {{#for_external_table:|
        <span class="column-icon">🎯</span>
      {{#ifeq:{{{Level}}}|3|
        Direct Requirements
<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>
      </h3>
      |}}
      <div class="material-items" data-level="1">
    }}
        {{#for_external_table:|
  </div>
          {{#ifeq:{{{Level}}}|1|
            <div class="material-card" data-item="{{{InternalName}}}" data-level="1">
              <div class="material-checkbox-wrapper">
                <input type="checkbox" class="material-checkbox" id="mat-{{{InternalName}}}" data-qty="{{{TotalQty}}}">
                <label for="mat-{{{InternalName}}}"></label>
              </div>
              <div class="material-content">
                <div class="material-icon">
                  {{#ifexist:File:{{#replace:{{{ItemLabel}}}| |_}}_-_Icon.png
                    |[[File:{{#replace:{{{ItemLabel}}}| |_}}_-_Icon.png|32px|link=]]
                    |<span class="icon-placeholder">📦</span>
                  }}
                </div>
                <div class="material-info">
                  <span class="material-name">{{{ItemLabel}}}</span>
                  <span class="material-qty">{{{TotalQty}}}</span>
                </div>
              </div>
              <div class="material-children-indicator"></div>
            </div>
          |}}
        }}
      </div>
    </div>
   
    <!-- Level 2 Column -->
    <div class="material-column level-2-column">
      <h3 class="column-header">
        <span class="column-icon">⚙️</span>
        Components
      </h3>
      <div class="material-items" data-level="2">
        {{#for_external_table:|
          {{#ifeq:{{{Level}}}|2|
            <div class="material-card" data-item="{{{InternalName}}}" data-level="2">
              <div class="material-checkbox-wrapper">
                <input type="checkbox" class="material-checkbox" id="mat-{{{InternalName}}}" data-qty="{{{TotalQty}}}">
                <label for="mat-{{{InternalName}}}"></label>
              </div>
              <div class="material-content">
                <div class="material-icon">
                  {{#ifexist:File:{{#replace:{{{ItemLabel}}}| |_}}_-_Icon.png
                    |[[File:{{#replace:{{{ItemLabel}}}| |_}}_-_Icon.png|32px|link=]]
                    |<span class="icon-placeholder">🔧</span>
                  }}
                </div>
                <div class="material-info">
                  <span class="material-name">{{{ItemLabel}}}</span>
                  <span class="material-qty">{{{TotalQty}}}</span>
                </div>
              </div>
              <div class="material-children-indicator"></div>
            </div>
          |}}
        }}
      </div>
    </div>
   
    <!-- Level 3 Column -->
    <div class="material-column level-3-column">
      <h3 class="column-header">
        <span class="column-icon">⛏️</span>
        Base Resources
      </h3>
      <div class="material-items" data-level="3">
        {{#for_external_table:|
          {{#ifeq:{{{Level}}}|3|
            <div class="material-card" data-item="{{{InternalName}}}" data-level="3">
              <div class="material-checkbox-wrapper">
                <input type="checkbox" class="material-checkbox" id="mat-{{{InternalName}}}" data-qty="{{{TotalQty}}}">
                <label for="mat-{{{InternalName}}}"></label>
              </div>
              <div class="material-content">
                <div class="material-icon">
                  {{#ifexist:File:{{#replace:{{{ItemLabel}}}| |_}}_-_Icon.png
                    |[[File:{{#replace:{{{ItemLabel}}}| |_}}_-_Icon.png|32px|link=]]
                    |<span class="icon-placeholder">💎</span>
                  }}
                </div>
                <div class="material-info">
                  <span class="material-name">{{{ItemLabel}}}</span>
                  <span class="material-qty">{{{TotalQty}}}</span>
                </div>
              </div>
            </div>
          |}}
        }}
      </div>
    </div>
  </div>
 
  <!-- Quick Actions Footer -->
  <div class="materials-footer">
    <button class="check-all-btn">Check All</button>
    <button class="uncheck-all-btn">Uncheck All</button>
    <button class="toggle-view-btn" data-view="grid">
      <span class="icon">📋</span>
      List View
    </button>
   </div>
   </div>
</div>
</div>

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"