Template:PrintServicesUpgradeStrat - Revision history

WikiSysop at 16:23, July 6, 2022

2022-07-06T16:23:58Z

WikiSysop at 12:15, July 6, 2022

2022-07-06T12:15:49Z

WikiSysop at 14:30, June 22, 2022

2022-06-22T14:30:53Z

WikiSysop at 13:45, June 22, 2022

2022-06-22T13:45:46Z

WikiSysop at 13:30, June 22, 2022

2022-06-22T13:30:45Z

WikiSysop at 13:30, June 21, 2022

2022-06-21T13:30:42Z

WikiSysop at 09:30, June 21, 2022

2022-06-21T09:30:45Z

WikiSysop at 07:15, June 21, 2022

2022-06-21T07:15:43Z

WikiSysop at 06:34, June 21, 2022

2022-06-21T06:34:34Z

WikiSysop at 20:00, June 20, 2022

2022-06-20T20:00:41Z

@@ Line 19: / Line 19: @@
 	|No
 	|#default=
-		<td>
+		<td style="text-align:center;">
 		{{#cargo_query:
 			tables=ArticlePEServiceUpgrade,Service,UpgradeStrategy
@@ Line 33: / Line 33: @@
 		}}
 		</td>
-		<td>
+		<td style="text-align:center;">
 		{{#cargo_query:
 		tables=ArticlePEServiceUpgrade,Service,UpgradeStrategy
@@ Line 47: / Line 47: @@
 		}}
 		</td>
-		<td>
+		<td style="text-align:center;">
 		{{#cargo_query:
 		tables=ArticlePEServiceUpgrade,Service,UpgradeStrategy

@@ Line 1: / Line 1: @@
 <tr>
 {{#switch:{{{AddIncluded|}}}
-|No
+	|No
-|#default=
+	|#default=
-<td>
+		<td>
-{{{Service|}}}
+		{{{Service|}}}
-</td>
+		</td>
-|Yes=
+	|Yes=
-<td colspan="4">
+		<td colspan="4">
-{{{Service|}}}
+		{{{Service|}}}
-</td>
+		</td>
 </tr>
 }}
 {{#switch:{{{AddIncluded|}}}
-|No
+	|No
-|#default=
+	|#default=
-<td>
+		<td>
-{{#cargo_query:
+		{{#cargo_query:
-tables=ArticlePEServiceUpgrade,Service,UpgradeStrategy
+			tables=ArticlePEServiceUpgrade,Service,UpgradeStrategy
-|join on=ArticlePEServiceUpgrade.ServiceId=Service.Id,ArticlePEServiceUpgrade.UpgradeStrategy=UpgradeStrategy.Id
+			|join on=
-|fields=IF(ArticlePEServiceUpgrade.UpgradeStrategy='40f069a2-01ae-4027-9aef-13f54bc53613',CONCAT('&#10003;'),CONCAT(''))
+				ArticlePEServiceUpgrade.ServiceId=Service.Id,
-|where=ArticlePEServiceUpgrade.ServiceId="{{{ServiceId}}}" AND {{#switch:{{NAMESPACENUMBER}}|620=ArticlePEServiceUpgrade._pageName LIKE "Draft:%%"|#default=ArticlePEServiceUpgrade._pageName NOT LIKE "Draft:%%"}}
+				ArticlePEServiceUpgrade.UpgradeStrategy=UpgradeStrategy.Id
-}}
+			|fields=IF(ArticlePEServiceUpgrade.UpgradeStrategy='40f069a2-01ae-4027-9aef-13f54bc53613',CONCAT('&#10003;'),CONCAT(''))
-</td>
+			|where=
-<td>
+				ArticlePEServiceUpgrade.ServiceId="{{{ServiceId}}}"
-{{#cargo_query:
+				AND {{#switch:{{NAMESPACENUMBER}}
-tables=ArticlePEServiceUpgrade,Service,UpgradeStrategy
+						|620=ArticlePEServiceUpgrade._pageName LIKE "Draft:%%"
-|join on=ArticlePEServiceUpgrade.ServiceId=Service.Id,ArticlePEServiceUpgrade.UpgradeStrategy=UpgradeStrategy.Id
+						|#default=ArticlePEServiceUpgrade._pageName NOT LIKE "Draft:%%"}}
-|fields=IF(ArticlePEServiceUpgrade.UpgradeStrategy='adcd5516-e0cf-4525-a74e-1467389675c9',CONCAT('&#10003;'),CONCAT(''))=Blue/Green,
+		}}
-|where=ArticlePEServiceUpgrade.ServiceId="{{{ServiceId}}}" AND {{#switch:{{NAMESPACENUMBER}}|620=ArticlePEServiceUpgrade._pageName LIKE "Draft:%%"|#default=ArticlePEServiceUpgrade._pageName NOT LIKE "Draft:%%"}}
+		</td>
-}}
+		<td>
-</td>
+		{{#cargo_query:
-<td>
+		tables=ArticlePEServiceUpgrade,Service,UpgradeStrategy
-{{#cargo_query:
+		|join on=
-tables=ArticlePEServiceUpgrade,Service,UpgradeStrategy
+			ArticlePEServiceUpgrade.ServiceId=Service.Id,
-|join on=ArticlePEServiceUpgrade.ServiceId=Service.Id,ArticlePEServiceUpgrade.UpgradeStrategy=UpgradeStrategy.Id
+			ArticlePEServiceUpgrade.UpgradeStrategy=UpgradeStrategy.Id
-|fields=IF(ArticlePEServiceUpgrade.UpgradeStrategy='d58cea3b-ff08-4fad-8b9d-7579b4145ba8',CONCAT('&#10003;'),CONCAT(''))=Canary,
+		|fields=IF(ArticlePEServiceUpgrade.UpgradeStrategy='adcd5516-e0cf-4525-a74e-1467389675c9',CONCAT('&#10003;'),CONCAT(''))=Blue/Green,
-|where=ArticlePEServiceUpgrade.ServiceId="{{{ServiceId}}}" AND {{#switch:{{NAMESPACENUMBER}}|620=ArticlePEServiceUpgrade._pageName LIKE "Draft:%%"|#default=ArticlePEServiceUpgrade._pageName NOT LIKE "Draft:%%"}}
+		|where=
-}}
+			ArticlePEServiceUpgrade.ServiceId="{{{ServiceId}}}"
-</td>
+			AND {{#switch:{{NAMESPACENUMBER}}
-|Yes=
+				|620=ArticlePEServiceUpgrade._pageName LIKE "Draft:%%"
-{{#cargo_query:
+				|#default=ArticlePEServiceUpgrade._pageName NOT LIKE "Draft:%%"}}
-tables=ArticlePEServiceUpgrade,Service,IncludedServiceUpgradeStrategy,IncludedService
+		}}
-|join on=ArticlePEServiceUpgrade.ServiceId=Service.Id,ArticlePEServiceUpgrade._pageName=IncludedServiceUpgradeStrategy._pageName, IncludedServiceUpgradeStrategy.IncludedServiceId=IncludedService.Id
+		</td>
-|fields=IncludedService.Name=Included Service,IncludedService.Id=IncludedServiceId
+		<td>
-|where=IncludedService.ServiceId="{{{ServiceId|}}}" AND ArticlePEServiceUpgrade._pageNamespace="{{NAMESPACENUMBER}}"
+		{{#cargo_query:
-|format=template
+		tables=ArticlePEServiceUpgrade,Service,UpgradeStrategy
-|named args=yes
+		|join on=
-|template=PrintIncludedServicesUpgradeStrat
+			ArticlePEServiceUpgrade.ServiceId=Service.Id,
-}}
+			ArticlePEServiceUpgrade.UpgradeStrategy=UpgradeStrategy.Id
 }}
 </tr>
 <noinclude>[[Category:PrivateEdition]]</noinclude>

@@ Line 21: / Line 21: @@
 |join on=ArticlePEServiceUpgrade.ServiceId=Service.Id,ArticlePEServiceUpgrade.UpgradeStrategy=UpgradeStrategy.Id
 |fields=IF(ArticlePEServiceUpgrade.UpgradeStrategy='40f069a2-01ae-4027-9aef-13f54bc53613',CONCAT('&#10003;'),CONCAT(''))
-|where=ArticlePEServiceUpgrade.ServiceId="{{{ServiceId}}}"
+|where=ArticlePEServiceUpgrade.ServiceId="{{{ServiceId}}}" AND {{#switch:{{NAMESPACENUMBER}}|620=ArticlePEServiceUpgrade._pageName LIKE "Draft:%%"|#default=ArticlePEServiceUpgrade._pageName NOT LIKE "Draft:%%"}}
 }}
 </td>
@@ Line 29: / Line 29: @@
 |join on=ArticlePEServiceUpgrade.ServiceId=Service.Id,ArticlePEServiceUpgrade.UpgradeStrategy=UpgradeStrategy.Id
 |fields=IF(ArticlePEServiceUpgrade.UpgradeStrategy='adcd5516-e0cf-4525-a74e-1467389675c9',CONCAT('&#10003;'),CONCAT(''))=Blue/Green,
-|where=ArticlePEServiceUpgrade.ServiceId="{{{ServiceId}}}"
+|where=ArticlePEServiceUpgrade.ServiceId="{{{ServiceId}}}" AND {{#switch:{{NAMESPACENUMBER}}|620=ArticlePEServiceUpgrade._pageName LIKE "Draft:%%"|#default=ArticlePEServiceUpgrade._pageName NOT LIKE "Draft:%%"}}
 }}
 </td>
@@ Line 37: / Line 37: @@
 |join on=ArticlePEServiceUpgrade.ServiceId=Service.Id,ArticlePEServiceUpgrade.UpgradeStrategy=UpgradeStrategy.Id
 |fields=IF(ArticlePEServiceUpgrade.UpgradeStrategy='d58cea3b-ff08-4fad-8b9d-7579b4145ba8',CONCAT('&#10003;'),CONCAT(''))=Canary,
-|where=ArticlePEServiceUpgrade.ServiceId="{{{ServiceId}}}"
+|where=ArticlePEServiceUpgrade.ServiceId="{{{ServiceId}}}" AND {{#switch:{{NAMESPACENUMBER}}|620=ArticlePEServiceUpgrade._pageName LIKE "Draft:%%"|#default=ArticlePEServiceUpgrade._pageName NOT LIKE "Draft:%%"}}
 }}
 </td>

@@ Line 41: / Line 41: @@
 </td>
 |Yes=
 {{#cargo_query:
 tables=ArticlePEServiceUpgrade,Service,IncludedServiceUpgradeStrategy,IncludedService
@@ Line 51: / Line 50: @@
 |template=PrintIncludedServicesUpgradeStrat
 }}
 }}
 </tr>
 <noinclude>[[Category:PrivateEdition]]</noinclude>

@@ Line 53: / Line 53: @@
 </td>
 }}
 <noinclude>[[Category:PrivateEdition]]</noinclude>

@@ Line 45: / Line 45: @@
 tables=ArticlePEServiceUpgrade,Service,IncludedServiceUpgradeStrategy,IncludedService
 |join on=ArticlePEServiceUpgrade.ServiceId=Service.Id,ArticlePEServiceUpgrade._pageName=IncludedServiceUpgradeStrategy._pageName, IncludedServiceUpgradeStrategy.IncludedServiceId=IncludedService.Id
-|fields=CONCAT('[[',ArticlePEServiceUpgrade._pageName,'|',IncludedService.Name,']]')=Included Service,Service.Id=ServiceId
+|fields=CONCAT('[[',ArticlePEServiceUpgrade._pageName,'|',IncludedService.Name,']]')=Included Service,IncludedService.Id=IncludedServiceId
 <!--|where=ArticlePEServiceUpgrade._pageNamespace="{{NAMESPACENUMBER}}" AND IncludedServiceUpgradeStrategy.IncludedServiceId IS NOT NULL-->
 |where=IncludedService.ServiceId="{{{ServiceId|}}}" AND ArticlePEServiceUpgrade._pageNamespace="{{NAMESPACENUMBER}}"