JourneyMaterials: Difference between revisions
From Dune Awakening DB
mNo edit summary |
mNo edit summary |
||
| Line 1: | Line 1: | ||
<includeonly><!-- Template:JourneyMaterials ( | <includeonly><!-- Template:JourneyMaterials (Fixed SQL) --> | ||
<!-- Get materials from the tiered view --> | <!-- Get materials from the tiered view --> | ||
{{#get_external_data:source=externaldb | {{#get_external_data:source=externaldb | ||
|from=vw_recipe_inputs_by_level | |from=vw_recipe_inputs_by_level | ||
|join on=data_journey_task_components.component_name= | |join on=data_journey_task_components.component_name=vw_recipe_inputs_by_level.root_item,data_journey_tasks.id=data_journey_task_components.task_id,data_journey_objectives.id=data_journey_tasks.objective_id | ||
|data=Level= | |data=Level=vw_recipe_inputs_by_level.level,ItemLabel=vw_recipe_inputs_by_level.item_label,TotalQty=vw_recipe_inputs_by_level.total_qty,RootItem=vw_recipe_inputs_by_level.root_item | ||
|cache=yes | |cache=yes | ||
|where=data_journey_objectives.journey_id={{{id|{{{1|}}}}}} | |where=data_journey_objectives.journey_id={{{id|{{{1|}}}}}} | ||
|group by= | |group by=vw_recipe_inputs_by_level.root_item,vw_recipe_inputs_by_level.level,vw_recipe_inputs_by_level.item_label,vw_recipe_inputs_by_level.total_qty | ||
|order by= | |order by=vw_recipe_inputs_by_level.root_item,vw_recipe_inputs_by_level.level,vw_recipe_inputs_by_level.item_label | ||
}} | }} | ||
| Line 48: | Line 48: | ||
}} | }} | ||
{{#ifeq:{{#var:tier_open}}|true|</div>|}} | {{#ifeq:{{#var:tier_open}}|true|</div>|}} | ||
<!-- Summary --> | <!-- Summary --> | ||
<div class="materials-summary"> | <div class="materials-summary"> | ||