Template:JourneyMaterials - Revision history

Operator at 05:48, 2 June 2025

2025-06-02T05:48:13Z

← Older revision		Revision as of 01:48, 2 June 2025
Line 9:		Line 9:
	{{#for_external_table:\|		{{#for_external_table:\|
	{{#ifeq:{{{Level}}}\|1\|		{{#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-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><div class="material-children-indicator"></div></div>		<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>
	\|}}		\|}}
	}}		}}
Line 21:		Line 21:
	{{#for_external_table:\|		{{#for_external_table:\|
	{{#ifeq:{{{Level}}}\|2\|		{{#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-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><div class="material-children-indicator"></div></div>		<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>
	\|}}		\|}}
	}}		}}

Operator at 05:46, 2 June 2025

2025-06-02T05:46:39Z

← Older revision		Revision as of 01:46, 2 June 2025
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
	\|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
	}}

	<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>		<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>
	</div>		</div>
	<div class="materials-grid">		<div class="materials-grid">

	<!-- LEVEL 1 – Direct Requirements -->		<!-- LEVEL 1 – Direct Requirements -->
	<div class="material-column level-1-column">		<div class="material-column level-1-column">
	<h3 class="column-header"~~><span class="column-icon">🎯</span~~>Direct Requirements</h3>		<h3 class="column-header">Direct Requirements</h3>
	<div class="material-items" data-level="1">		<div class="material-items" data-level="1">
	{{#for_external_table:\|		{{#for_external_table:\|
Line 26:		Line 17:
	<!-- LEVEL 2 – Components -->		<!-- LEVEL 2 – Components -->
	<div class="material-column level-2-column">		<div class="material-column level-2-column">
	<h3 class="column-header"~~><span class="column-icon">⚙️</span~~>Components</h3>		<h3 class="column-header">Components</h3>
	<div class="material-items" data-level="2">		<div class="material-items" data-level="2">
	{{#for_external_table:\|		{{#for_external_table:\|
Line 38:		Line 29:
	<!-- LEVEL 3 – Base Resources -->		<!-- LEVEL 3 – Base Resources -->
	<div class="material-column level-3-column">		<div class="material-column level-3-column">
	<h3 class="column-header"~~><span class="column-icon">⛏️</span~~>Base Resources</h3>		<h3 class="column-header">Base Resources</h3>
	<div class="material-items" data-level="3">		<div class="material-items" data-level="3">
	{{#for_external_table:\|		{{#for_external_table:\|
	{{#ifeq:{{{Level}}}\|3\|		{{#ifeq:{{{Level}}}\|3\|
	<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-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></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>
	\|}}		\|}}
	}}		}}

Operator at 04:51, 2 June 2025

2025-06-02T04:51:06Z

← Older revision		Revision as of 00:51, 2 June 2025
Line 8:		Line 8:
	}}		}}

	<div class="materials-enhanced-container">		<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>
	~~<!-- ▸ Progress Header -------------------------------------------------- -->~~
	<div class="materials-progress-header">
	<div class="progress-bar-container"><div class="progress-bar" data-progress="0"></div></div>
	<div class="progress-text"><span class="progress-count">0</~~span> / <span class="total-count">~~0</span> Materials Ready</div>
	</div>		</div>

	~~<!-- ▸ Materials Grid --------------------------------------------------- -->~~
	<div class="materials-grid">		<div class="materials-grid">

Operator at 04:41, 2 June 2025

2025-06-02T04:41:11Z

← Older revision		Revision as of 00:41, 2 June 2025
Line 24:		Line 24:
	{{#for_external_table:\|		{{#for_external_table:\|
	{{#ifeq:{{{Level}}}\|1\|		{{#ifeq:{{{Level}}}\|1\|
	<div class="material-~~card~~" 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-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><div class="material-children-indicator"></div></div>		<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-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><div class="material-children-indicator"></div></div>
	\|}}		\|}}
	}}		}}
Line 36:		Line 36:
	{{#for_external_table:\|		{{#for_external_table:\|
	{{#ifeq:{{{Level}}}\|2\|		{{#ifeq:{{{Level}}}\|2\|
	<div class="material-~~card~~" 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-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><div class="material-children-indicator"></div></div>		<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-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><div class="material-children-indicator"></div></div>
	\|}}		\|}}
	}}		}}
Line 48:		Line 48:
	{{#for_external_table:\|		{{#for_external_table:\|
	{{#ifeq:{{{Level}}}\|3\|		{{#ifeq:{{{Level}}}\|3\|
	<div class="material-~~card~~" 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-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></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-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></div>
	\|}}		\|}}
	}}		}}

Operator at 04:31, 2 June 2025

2025-06-02T04:31:48Z

@@ Line 3: / Line 3: @@
   |from         = data_journey_materials
   |data         = Level=level, ItemLabel=item_label, TotalQty=total_qty, InternalName=internal_name
-  |where        = journey_id = 4
+  |where        = journey_id = {{{id|{{{1|}}}}}}
   |order by     = level, item_label
   |cache        = yes
@@ Line 24: / Line 24: @@
      {{#for_external_table:|
        {{#ifeq:{{{Level}}}|1|
-<div class="material-card" data-item="{{{InternalName}}}" data-level="1">
+<div class="material-card" 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-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><div class="material-children-indicator"></div></div>
        |}}
      }}
@@ Line 47: / Line 36: @@
      {{#for_external_table:|
        {{#ifeq:{{{Level}}}|2|
-<div class="material-card" data-item="{{{InternalName}}}" data-level="2">
+<div class="material-card" 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-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><div class="material-children-indicator"></div></div>
        |}}
      }}
@@ Line 70: / Line 48: @@
      {{#for_external_table:|
        {{#ifeq:{{{Level}}}|3|
-<div class="material-card" data-item="{{{InternalName}}}" data-level="3">
+<div class="material-card" 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-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></div>
        |}}
      }}
@@ Line 86: / Line 54: @@
    </div>
   </div>

Operator at 04:22, 2 June 2025

2025-06-02T04:22:35Z

@@ Line 24: / Line 24: @@
      {{#for_external_table:|
        {{#ifeq:{{{Level}}}|1|
-<div class="material-card" 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-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><div class="material-children-indicator"></div></div>
+<div class="material-card" data-item="{{{InternalName}}}" data-level="1">
        |}}
      }}
@@ Line 36: / Line 47: @@
      {{#for_external_table:|
        {{#ifeq:{{{Level}}}|2|
-<div class="material-card" 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-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><div class="material-children-indicator"></div></div>
+<div class="material-card" data-item="{{{InternalName}}}" data-level="2">
        |}}
      }}
@@ Line 48: / Line 70: @@
      {{#for_external_table:|
        {{#ifeq:{{{Level}}}|3|
-<div class="material-card" 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-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></div>
+<div class="material-card" data-item="{{{InternalName}}}" data-level="3">
        |}}
      }}
@@ Line 55: / Line 87: @@
   </div>
-  <!-- ▸ Quick Actions Footer -------------------------------------------- -->
+  <!-- Footer removed as requested -->
 </div>

Operator at 04:19, 2 June 2025

2025-06-02T04:19:05Z

Show changes

Operator at 03:41, 2 June 2025

2025-06-02T03:41:22Z

Show changes

Operator at 21:17, 1 June 2025

2025-06-01T21:17:53Z

Show changes

Operator at 21:16, 1 June 2025

2025-06-01T21:16:44Z

← Older revision		Revision as of 17:16, 1 June 2025
Line 2:		Line 2:
	{{#get_external_data:		{{#get_external_data:
	source = externaldb		source = externaldb
	\|~~query~~ = ~~CALL sp_journey_components_bom(~~{{{id\|{{{1\|}}}}}})		\|from = data_journey_materials
	\|~~data = Level~~ = level,		\|data = Level=level, ItemLabel=item_label, TotalQty=total_qty
	~~ItemLabel =~~ item_label,		\|where = journey_id = {{{id\|{{{1\|}}}}}}
	~~TotalQty = total_qty~~		\|order by = level, item_label
	\|cache ~~seconds~~ = ~~3600~~		\|cache = yes
	}}		}}


	<div class="journey-materials-wrapper" data-journey-id="{{{id\|{{{1\|}}}}}}">		<div class="journey-materials-wrapper" data-journey-id="{{{id\|{{{1\|}}}}}}">
	<!-- Level 1 Materials (Left Column) -->		<!-- Level 1 Materials (Left Column) -->