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 3: / Line 3: @@
 <!-- initialize the variables -->
 {{#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=%%}²,|category=align="left"¦²{Localize¦%%}²,|authority=align="center"¦²{division honor¦²{division abbrev¦%%}²}²,|skill=align="center"¦%%,|year=align="center"¦%%,}}}}
+{{#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 -->
@@ Line 18: / Line 18: @@
 |notcategory={{#if:{{{excat4|}}}|{{{excat4}}}{{GetLangSuffix}}}}
 |notcategory={{#if:{{{excat5|}}}|{{{excat5}}}{{GetLangSuffix}}}}
+|notcategory={{#if:{{{excat6|}}}|{{{excat6}}}{{GetLangSuffix}}}}
+|notcategory={{#if:{{{showPiloting|}}}||AY Honors/Piloting{{GetLangSuffix}}}}
 |nottitleregexp=.*/en$
 |ordermethod=sortkey
@@ Line 76: / Line 78: @@
 		"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"
@@ Line 93: / Line 100: @@
 		"excat4",
 		"excat5",
+		"excat6",
 		"catn"
 	]
 }
 </templatedata>[[Category:UsesLoops]]</noinclude>