Difference between revisions of "Template: RNPrint"
From Genesys Documentation
m (1 revision imported) |
|||
Line 1: | Line 1: | ||
− | <includeonly><!-- Creating section heading--><h2>{{#ifeq:{{#cargo_query:tables=ArticleCloudRN, | + | <includeonly><!-- |
− | + | ||
− | + | Creating section heading | |
− | + | ||
− | + | --><h2> | |
− | + | {{#ifeq: | |
− | tables=ComponentRN, | + | {{#cargo_query:tables= |
− | DeploymentType=DT | + | ArticleCloudRN, |
− | |join on=ComponentRN.DeploymentTypeId HOLDS DT.Id | + | ArticleCloudRN__ComponentId |
− | |fields=CONCAT('[[File:',DT.Image,'|',Size,'px|link=]]') | + | |join on=ArticleCloudRN._ID=ArticleCloudRN__ComponentId._rowID |
− | |delimiter= | + | |fields=COUNT(*) |
− | |where=ComponentRN.ComponentId="{{{Component|}}}" | + | |where= |
− | AND ReleaseNumber="{{{ReleaseNumber|}}}" | + | ArticleCloudRN._pageName="{{FULLPAGENAME}}" |
− | AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}" | + | AND ArticleCloudRN._pageNamespace="{{NAMESPACENUMBER}}" |
− | }}</h2><!-- adding anchor div for linking to RN entry -->{{AnchorDiv|{{{ComponentName|}}}-{{{ReleaseNumber|}}}}}<!-- printing subheading to indicate private edition or mixed mode release info | + | |no html |
− | tables=ComponentRN, | + | }} |
− | DeploymentType=DT | + | |1||{{{ComponentName|}}}: |
− | |join on=ComponentRN.DeploymentTypeId HOLDS DT.Id | + | }} {{#if:{{{ReleaseDate|}}}|{{#time:F d, Y|{{{ReleaseDate|}}}}}|<span style="background-color:yellow">Date needed</span> |
− | |fields=DT.Image=Image, | + | }}<!-- |
− | DT.Size=Size, | + | |
− | DT.Name=DTName, | + | DeplomymentType icons after RN heading |
− | ComponentRN.ComponentId=ComponentId, | + | |
− | ReleaseNumber, | + | -->{{#cargo_query: |
− | PrivateEditionReleaseDate=PEDate, | + | tables=ComponentRN, |
− | MixedModeReleaseDate=MixedDate | + | DeploymentType=DT |
− | |named args=yes | + | |join on=ComponentRN.DeploymentTypeId HOLDS DT.Id |
− | |format=template | + | |fields=CONCAT('[[File:',DT.Image,'|',Size,'px|link=]]') |
− | |template=RNPrintSubhead | + | |delimiter= |
− | |default= | + | |where= |
− | |where=ComponentRN._pageNamespace="{{NAMESPACENUMBER}}" | + | ComponentRN.ComponentId="{{{Component|}}}" |
− | AND ComponentRN.ComponentId="{{{Component|}}}" | + | AND ReleaseNumber="{{{ReleaseNumber|}}}" |
− | AND ReleaseNumber="{{{ReleaseNumber|}}}" | + | AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}" |
− | AND (DT.Name="Private Edition" OR DT.Name="Mixed mode") | + | }}</h2><!-- |
− | }}<!-- printing out the list of Issues according to their IssueCategory-->{{#cargo_query: | + | |
− | tables=ComponentRN, | + | adding anchor div for linking to RN entry |
− | Issue, | + | |
− | IssueCategory | + | -->{{AnchorDiv|{{{ComponentName|}}}-{{{ReleaseNumber|}}}}}<!-- |
− | |join on=ComponentRN._pageName=Issue._pageName, | + | |
− | Issue.IssueCategoryId=IssueCategory.Id | + | printing subheading to indicate private edition or mixed mode release info |
− | |fields=IssueCategory.SectionName=Name, | + | IMPORTANT: This query includes hard-coded value for DeploymentType.Name- |
− | + | ||
− | + | -->{{#cargo_query: | |
− | + | tables= | |
− | + | ComponentRN, | |
− | + | DeploymentType=DT | |
− | ReleaseNumber, | + | |join on=ComponentRN.DeploymentTypeId HOLDS DT.Id |
− | ComponentId | + | |fields= |
− | |format=template | + | DT.Image=Image, |
− | |template=RNPrintFormat | + | DT.Size=Size, |
− | |named args=yes | + | DT.Name=DTName, |
− | |where=ComponentRN.ComponentId = "{{{Component|}}}" AND ReleaseNumber="{{{ReleaseNumber|}}}" AND IssueCategoryId IS NOT NULL AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}" | + | ComponentRN.ComponentId=ComponentId, |
− | |order by=IssueCategory.PrintOrder ASC | + | ReleaseNumber, |
− | |group by=IssueCategory.SectionName | + | PrivateEditionReleaseDate=PEDate, |
− | }}__NOCACHE__{{#switch:{{NAMESPACENUMBER}}|620=<span style="font-size:80%">[[{{{Page|}}}|(Link to source)]]</span>|#default=}}</includeonly><noinclude>[[Category:RNAutomation]][[Category:ComponentRN.ComponentId cleanup]][[Category:TrackConstants]]</noinclude> | + | MixedModeReleaseDate=MixedDate |
+ | |named args=yes | ||
+ | |format=template | ||
+ | |template=RNPrintSubhead | ||
+ | |default= | ||
+ | |where= | ||
+ | ComponentRN._pageNamespace="{{NAMESPACENUMBER}}" | ||
+ | AND ComponentRN.ComponentId="{{{Component|}}}" | ||
+ | AND ReleaseNumber="{{{ReleaseNumber|}}}" | ||
+ | AND (DT.Name="Private Edition" OR DT.Name="Mixed mode") | ||
+ | }}<!-- | ||
+ | |||
+ | printing out the list of Issues according to their IssueCategory | ||
+ | |||
+ | -->{{#cargo_query: | ||
+ | tables= | ||
+ | ComponentRN, | ||
+ | Issue, | ||
+ | IssueCategory | ||
+ | |join on= | ||
+ | ComponentRN._pageName=Issue._pageName, | ||
+ | Issue.IssueCategoryId=IssueCategory.Id | ||
+ | |fields= | ||
+ | IssueCategory.SectionName=Name, | ||
+ | ReleaseNumber, | ||
+ | ComponentId | ||
+ | |format=template | ||
+ | |template=RNPrintFormat | ||
+ | |named args=yes | ||
+ | |where= | ||
+ | ComponentRN.ComponentId = "{{{Component|}}}" | ||
+ | AND ReleaseNumber="{{{ReleaseNumber|}}}" | ||
+ | AND IssueCategoryId IS NOT NULL | ||
+ | AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}" | ||
+ | |order by=IssueCategory.PrintOrder ASC | ||
+ | |group by= | ||
+ | ComponentRN._pageID, | ||
+ | IssueCategory._pageID, | ||
+ | IssueCategory.PrintOrder, | ||
+ | IssueCategory.SectionName, | ||
+ | ReleaseNumber, | ||
+ | ComponentId | ||
+ | }}<!-- | ||
+ | |||
+ | supressing cache for this page | ||
+ | |||
+ | -->__NOCACHE__<!-- | ||
+ | |||
+ | adding link to the base unit RN in draft pages includeonly | ||
+ | |||
+ | -->{{#switch:{{NAMESPACENUMBER}} | ||
+ | |620=<span style="font-size:80%">[[{{{Page|}}}|(Link to source)]]</span> | ||
+ | |#default= | ||
+ | }}</includeonly><!-- | ||
+ | |||
+ | setting categories for this page, including TrackConstants as this page includes some hard-coded values | ||
+ | --><noinclude>[[Category:RNAutomation]][[Category:ComponentRN.ComponentId cleanup]][[Category:TrackConstants]]</noinclude> |