Difference between revisions of "Template:Honor index"

Latest revision as of 01:52, 14 October 2023

Cannot access the database: :real_connect(): (08004/1040): Too many connections	Skill Level	Year
Fabric Yo-Yo	1	2012
Music - Beginners	1	Unknown
Papercraft	1	2012

Honor	Category	Skill Level	Year
Fabric Yo-Yo	Arts, Crafts and Hobbies	1	2012
Music - Beginners	Arts, Crafts and Hobbies	1	Unknown
Papercraft	Arts, Crafts and Hobbies	1	2012

This template creates a table view, containing the honors in this wiki. The columns shown can be modified also it can be defined which categories should be included and which excluded.

It is very complex so I try to explain what is going on. First in the template we create the needed variables for defining the table (text's of the header, wanted columns, row template). After we did that magic, we have the magic that enables the template to have a dynamic count of needed (included) categories.

That is the whole preparation. Now we only let DPL do it's magic and a nice table will be created... hopefully ;)

Template parameters
Parameter		Description	Type	Status
Shown columns (and order)	`columnselection`	This defines the shown columns and the order of those. Each column needs to be separated by a ":" and it needs to be started with a ":". Possible columns are: honorname, insignia, category, authority, skill, year Default :honorname:insignia:category:authority:skill:year Example :honorname:insignia:category:authority:skill:year Auto value `:honorname:insignia:category:authority:skill:year`	Unknown	optional
First excluded Category	`excat1`	The honor isn't allowed to be in that category. Example AY Honors/Approved by General Conference Auto value	Unknown	optional
Second excluded Category	`excat2`	The honor isn't allowed to be in that category. Example AY Honors/Approved by General Conference	Unknown	optional
Third excluded Category	`excat3`	The honor isn't allowed to be in that category. Example AY Honors/Approved by General Conference	Unknown	optional
Fourth excluded Category	`excat4`	The honor isn't allowed to be in that category. Example AY Honors/Approved by General Conference	Unknown	optional
Fifth excluded Category	`excat5`	The honor isn't allowed to be in that category. Example AY Honors/Approved by General Conference	Unknown	optional
Sixth excluded Category	`excat6`	The honor isn't allowed to be in that category. Example AY Honors/Approved by General Conference	Unknown	optional
Included Category	`catn`	This category needs to be included. The n needs to be replaced with an upcounting number, that way it is possible to add multiple categories. An honor included in the list needs to have every added category. For example add those arguments: cat1=mycategory1\|cat2=mycategory2 and so on. Example AY Honors/Skill Level 1	Unknown	optional

@@ Line 1: / Line 1: @@
-<!--- ¦ --->
+<!--- ¦ ---><includeonly>
-<includeonly>
+<!-- assemble the tablerow argument of DPL so it is customizeable -->
-<!-- that loop's through all argument's with the prefix cat and saves it into a variable -->
+<!-- initialize the variables -->
-{{#vardefine:argIncCat|AY Honors/Honor landing{{GetLangSuffix}}&AY Honors/Primary{{GetLangSuffix}}}}{{#forargs: cat | key | category |<nowiki />{{#vardefine: argIncCat |{{#var:argIncCat}}{{#if:{{#var:category}}|&{{#var:category}} }} }} }}
+{{#vardefine:selectedcolumns|{{{columnselection|:honorname:insignia:category:authority:skill:year}}}}}
+{{#vardefine:tablerow|}}{{#vardefine:tableheader|}}{{#vardefine:i|1}}{{#while: <!-- we need to start at word 1 because of the leading : -->|{{#if:{{#explode:{{#var:selectedcolumns}}|:|{{#var:i}}}}|true}}|{{#vardefine:tablerow|{{#var: tablerow}}{{#switch:{{#explode:{{#var: selectedcolumns }}|:|{{#var:i}}}}|honorname=data-sort-value=²{GetHonorName¦page=%PAGE%}²¦[[%PAGE%¦²{GetHonorName¦page=%PAGE%}²]],|insignia=²{GetInsigniaThumb¦insignia=%%¦usePilotNoPatch={{{usePilotNoPatch¦}}}}²,|category=align="left"¦²{Localize¦%%}²,|authority=align="center"¦²{division honor¦²{division abbrev¦%%}²}²,|skill=align="center"¦²{YearOrUnknown¦%%}²,|year=align="center"¦²{YearOrUnknown¦%%}²,}}}}
+{{#vardefine: tableheader|{{#var:tableheader}}{{#switch:{{#explode:{{#var:selectedcolumns}}|:|{{#var:i}}}}|honorname=,{{Localize|Honor}}|insignia=,{{Localize|Patch}}|category=,{{Localize|Category}}|authority=,{{Localize|Approval}}|skill=,{{Localize|Skill Level}}|year=,{{Localize|Year}}}}}}{{#vardefine:i|{{#expr:{{#var:i}}+1}}}}}}<nowiki />
+<!-- that loops through all arguments with the prefix cat and saves it into a variable -->
+{{#vardefine:argIncCat|AY Honors/HonorLanding{{GetLangSuffix}}&AY Honors/Primary}}{{#forargs: cat | key | category |<nowiki />{{#vardefine:argIncCat|{{#var:argIncCat}}{{#if:{{#var:category}}|&{{#var:category}}{{GetLangSuffix}} }} }} }}
 {{#dpl:
-|debug=0
+|debug={{{debug|0}}}
-|include={honor_landing}:honorname:insignia:category:authority:skill:year
+|include={HonorLanding}{{#var:selectedcolumns}}
-|table=class="wikitable sortable",-,{{Localize|Honor{{GetLangSuffix}}}},{{Localization:Patch{{GetLangSuffix}}}},{{Localization:Category{{GetLangSuffix}}}},{{Localization:Approval{{GetLangSuffix}}}},{{Localization:Skill Level{{GetLangSuffix}}}},{{Localization:Year}}
+|table=class="wikitable sortable",-{{#var:tableheader}}
-|tablerow=[[%PAGE%¦%%]],[[File:%%¦30px¦center]],align="left"¦%%,align="center"¦²{division honor¦²{division abbrev¦%%}²}²,align="center"¦%%,align="center"¦%%
+|tablerow={{#var:tablerow}}
 |category={{#var:argIncCat}}
-|notcategory={{{excat1|}}}
+|notcategory={{#if:{{{excat1|}}}|{{{excat1}}}{{GetLangSuffix}}}}
-|notcategory={{{excat2|}}}
+|notcategory={{#if:{{{excat2|}}}|{{{excat2}}}{{GetLangSuffix}}}}
-|notcategory={{{excat3|}}}
+|notcategory={{#if:{{{excat3|}}}|{{{excat3}}}{{GetLangSuffix}}}}
-|notcategory={{{excat4|}}}
+|notcategory={{#if:{{{excat4|}}}|{{{excat4}}}{{GetLangSuffix}}}}
-|notcategory={{{excat5|}}}
+|notcategory={{#if:{{{excat5|}}}|{{{excat5}}}{{GetLangSuffix}}}}
+|notcategory={{#if:{{{excat6|}}}|{{{excat6}}}{{GetLangSuffix}}}}
+|notcategory={{#if:{{{showPiloting|}}}||AY Honors/Piloting{{GetLangSuffix}}}}
 |nottitleregexp=.*/en$
 |ordermethod=sortkey
 |namespace=
+}}
+{{#if:{{{debug|}}}|
+*argIncCat = {{#var:argIncCat}}
+*key = {{#var:key}}
+*category = {{#var:category}}
+*tablerow = {{#var:tablerow}}
+*tableheader = {{#var:tableheader}}
+*selectedcolumns = {{#var:selectedcolumns}}
 }}
 </includeonly>
 <noinclude><nowiki />{{Honor index
+|cat1=AY Honors/Arts, Crafts and Hobbies
+|cat2=AY Honors/Skill Level 1
+|excat1=AY Honors/Approved by General Conference
+|excat2=AY Honors/Approved by North American Division
+|columnselection=:honorname:insignia:authority:skill:year
+}}<nowiki />{{Honor index
 |cat1=AY Honors/Arts, Crafts and Hobbies
 |cat2=AY Honors/Skill Level 1
@@ Line 25: / Line 45: @@
 |excat2=AY Honors/Approved by North American Division
 }}
-</noinclude>
+<templatedata>
+{
+	"params": {
+		"columnselection": {
+			"label": "Shown columns (and order)",
+			"description": "This defines the shown columns and the order of those. Each column needs to be separated by a \":\" and it needs to be started with a \":\". Possible columns are: honorname, insignia, category, authority, skill, year",
+			"example": ":honorname:insignia:category:authority:skill:year",
+			"default": ":honorname:insignia:category:authority:skill:year",
+			"autovalue": ":honorname:insignia:category:authority:skill:year"
+		},
+		"excat1": {
+			"label": "First excluded Category",
+			"description": "The honor isn't allowed to be in that category.",
+			"example": "AY Honors/Approved by General Conference",
+			"autovalue": ""
+		},
+		"excat2": {
+			"label": "Second excluded Category",
+			"description": "The honor isn't allowed to be in that category.",
+			"example": "AY Honors/Approved by General Conference"
+		},
+		"excat3": {
+			"label": "Third excluded Category",
+			"description": "The honor isn't allowed to be in that category.",
+			"example": "AY Honors/Approved by General Conference"
+		},
+		"excat4": {
+			"label": "Fourth excluded Category",
+			"description": "The honor isn't allowed to be in that category.",
+			"example": "AY Honors/Approved by General Conference"
+		},
+		"excat5": {
+			"label": "Fifth excluded Category",
+			"description": "The honor isn't allowed to be in that category.",
+			"example": "AY Honors/Approved by General Conference"
+		},
+		"excat6": {
+			"label": "Sixth excluded Category",
+			"description": "The honor isn't allowed to be in that category.",
+			"example": "AY Honors/Approved by General Conference"
+		},
+		"catn": {
+			"label": "Included Category",
+			"description": "This category needs to be included. The n needs to be replaced with an upcounting number, that way it is possible to add multiple categories. An honor included in the list needs to have every added category. For example add those arguments: cat1=mycategory1|cat2=mycategory2 and so on.",
+			"example": "AY Honors/Skill Level 1"
+		}
+	},
+	"description": "This template creates a table view, containing the honors in this wiki. The columns shown can be modified also it can be defined which categories should be included and which excluded.\n\nIt is very complex so I try to explain what is going on. First in the template we create the needed variables for defining the table (text's of the header, wanted columns, row template). \nAfter we did that magic, we have the magic that enables the template to have a dynamic count of needed (included) categories.\n\nThat is the whole preparation. Now we only let DPL do it's magic and a nice table will be created... hopefully ;) ",
+	"paramOrder": [
+		"columnselection",
+		"excat1",
+		"excat2",
+		"excat3",
+		"excat4",
+		"excat5",
+		"excat6",
+		"catn"
+	]
+}
+</templatedata>[[Category:UsesLoops]]</noinclude>