Difference between revisions of "Template: RNPrint"
From Genesys Documentation
| (15 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <includeonly><h2>{{#ifeq:{{#cargo_query:tables=ArticleCloudRN,ArticleCloudRN__ComponentId|join on=ArticleCloudRN._ID=ArticleCloudRN__ComponentId._rowID|fields=COUNT(*)|where=ArticleCloudRN._pageName="{{FULLPAGENAME}}" AND ArticleCloudRN._pageNamespace="{{NAMESPACENUMBER}}"|no html}}|1||{{{ComponentName|}}}:}} {{#if:{{{ReleaseDate|}}}|{{#time:F d, Y|{{{ReleaseDate|}}}}}|<span style="background-color:yellow">Date needed</span>}} {{#cargo_query: | + | <includeonly><!-- |
| − | tables=ComponentRN,DeploymentType=DT | + | |
| − | |join on=ComponentRN.DeploymentTypeId HOLDS DT.Id | + | Creating section heading |
| − | |fields=CONCAT('[[File:',DT.Image,'| | + | |
| − | |delimiter= | + | --><h2> |
| − | |where=ComponentRN.ComponentId HOLDS '{{{Component|}}} | + | {{#ifeq: |
| − | }} | + | {{#cargo_query:tables= |
| − | __NOCACHE__ | + | ArticleCloudRN, |
| − | {{#switch:{{NAMESPACENUMBER}}|620=<span style="font-size:80%">[[{{{Page|}}}|(Link to source)]]</span>|#default=}}</includeonly><noinclude>[[Category:RNAutomation]]</noinclude> | + | ArticleCloudRN__ComponentId |
| + | |join on=ArticleCloudRN._ID=ArticleCloudRN__ComponentId._rowID | ||
| + | |fields=COUNT(*) | ||
| + | |where= | ||
| + | ArticleCloudRN._pageName="{{FULLPAGENAME}}" | ||
| + | AND ArticleCloudRN._pageNamespace="{{NAMESPACENUMBER}}" | ||
| + | |no html | ||
| + | }} | ||
| + | |1||{{{ComponentName|}}}: | ||
| + | }} {{#if:{{{ReleaseDate|}}}|{{#time:F d, Y|{{{ReleaseDate|}}}}}|<span style="background-color:yellow">Date needed</span> | ||
| + | }}<!-- | ||
| + | |||
| + | DeplomymentType icons after RN heading | ||
| + | |||
| + | -->{{#cargo_query: | ||
| + | tables=ComponentRN, | ||
| + | DeploymentType=DT | ||
| + | |join on=ComponentRN.DeploymentTypeId HOLDS DT.Id | ||
| + | |fields=CONCAT('[[File:',DT.Image,'|',Size,'px|link=]]') | ||
| + | |delimiter= | ||
| + | |default= | ||
| + | |where= | ||
| + | ComponentRN.ComponentId="{{{Component|}}}" | ||
| + | AND ReleaseNumber="{{{ReleaseNumber|}}}" | ||
| + | AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}" | ||
| + | AND DT.Name!="Mixed mode" | ||
| + | }}</h2><!-- | ||
| + | |||
| + | adding anchor div for linking to RN entry | ||
| + | |||
| + | -->{{AnchorDiv|{{{ComponentName|}}}-{{{ReleaseNumber|}}}}}<!-- | ||
| + | |||
| + | printing subheading to indicate private edition or mixed mode release info | ||
| + | IMPORTANT: This query includes hard-coded value for DeploymentType.Name- | ||
| + | |||
| + | -->{{#cargo_query: | ||
| + | tables= | ||
| + | ComponentRN, | ||
| + | DeploymentType=DT | ||
| + | |join on=ComponentRN.DeploymentTypeId HOLDS DT.Id | ||
| + | |fields= | ||
| + | DT.Image=Image, | ||
| + | DT.Size=Size, | ||
| + | DT.Name=DTName, | ||
| + | ComponentRN.ComponentId=ComponentId, | ||
| + | ReleaseNumber, | ||
| + | PrivateEditionReleaseDate=PEDate, | ||
| + | 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" | ||
| + | }}<!-- | ||
| + | |||
| + | special handling for on-premises pages tagged with mixed MixedMode | ||
| + | |||
| + | -->{{#cargo_query: | ||
| + | tables= | ||
| + | ComponentRN, | ||
| + | DeploymentType=DT | ||
| + | |join on=ComponentRN.DeploymentTypeId HOLDS DT.Id | ||
| + | |fields= | ||
| + | CONCAT('<b>Note</b>: Availability of release ',ReleaseNumber,' for on-premises deployments is limited to select customers.') | ||
| + | |named args=yes | ||
| + | |default= | ||
| + | |where= | ||
| + | ComponentRN._pageNamespace="{{NAMESPACENUMBER}}" | ||
| + | AND ComponentRN.ComponentId="{{{Component|}}}" | ||
| + | AND ReleaseNumber="{{{ReleaseNumber|}}}" | ||
| + | AND 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> | ||