Actions

Template

JourneyMaterials: Difference between revisions

From Dune Awakening DB

← Older editNewer edit →
VisualWikitext
mNo edit summary
mNo edit summary
Line 2: Line 2:
   source = externaldb
   source = externaldb
   |from  = data_journey_materials
   |from  = data_journey_materials
   |data  = Level=level, ItemLabel=item_label, TotalQty=total_qty
   |data  = Level=level, ItemLabel=item_label, TotalQty=total_qty, InternalName=internal_name
   |where = journey_id = {{{id|{{{1|}}}}}}
   |where = journey_id = {{{id|{{{1|}}}}}}
   |order by = level, item_label
   |order by = level, item_label
Line 8: Line 8:
}}
}}


 
<div class="materials-enhanced-container">
<div class="materials-container" style="max-height:600px;overflow-y:auto;">
  <!-- Progress Header -->
{{#vardefine:current_level|0}}{{#vardefine:tier_open|false}}
  <div class="materials-progress-header">
 
    <div class="progress-bar-container">
{{#for_external_table:|
      <div class="progress-bar" data-progress="0"></div>
  {{#ifeq:{{{Level}}}|{{#var:current_level}}||
    </div>
     {{#ifeq:{{#var:tier_open}}|true|</div>|}}
    <div class="progress-text">
    <div class="materials-tier level-{{{Level}}}">
      <span class="progress-count">0</span> / <span class="total-count">0</span> Materials Ready
      <div class="tier-header">{{#switch:{{{Level}}}
    </div>
        |1=Direct Materials Required
  </div>
        |2=Components for Level&nbsp;1 Materials
 
        |3=Base Resources Needed
  <!-- Materials Grid -->
        |#default=Level&nbsp;{{{Level}}} Materials
  <div class="materials-grid">
      }}</div>
    <!-- Level 1 Column -->
     {{#vardefine:tier_open|true}}
    <div class="material-column level-1-column">
    {{#vardefine:current_level|{{{Level}}}}}
      <h3 class="column-header">
  }}
        <span class="column-icon">🎯</span>
  <div class="material-item">
        Direct Requirements
    <span class="material-icon">
      </h3>
      {{#ifexist:File:{{#replace:{{{ItemLabel}}}| |_}}_-_Icon.png
      <div class="material-items" data-level="1">
        |[[File:{{#replace:{{{ItemLabel}}}| |_}}_-_Icon.png|20px|link=]]
        {{#for_external_table:|
        |
          {{#ifeq:{{{Level}}}|1|
      }}
            <div class="material-card" data-item="{{{InternalName}}}" data-level="1">
    </span>
              <div class="material-checkbox-wrapper">
    <span class="material-name">{{{ItemLabel}}}</span>
                <input type="checkbox" class="material-checkbox" id="mat-{{{InternalName}}}" data-qty="{{{TotalQty}}}">
    <span class="material-qty">{{{TotalQty}}}</span>
                <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>
}}
{{#ifeq:{{#var:tier_open}}|true|</div>|}}
</div>
</div>
</includeonly><noinclude>{{Documentation}}</noinclude>

Revision as of 23:41, 1 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 

   <button class="check-all-btn">Check All</button>
   <button class="uncheck-all-btn">Uncheck All</button>
   <button class="toggle-view-btn" data-view="grid">
     📋
     List View
   </button>
Retrieved from "https://dunedb.com/index.php?title=Template:JourneyMaterials&oldid=827"