Template:ClinIncin: Difference between revisions

Latest revision as of 13:17, 14 June 2021

Error: no local variable "site" has been set.
[[File:Clin_{{{id}}}.png\|400px\|center\|Site Location]] See HT & Clin → page for a larger UK Wide map.
Waste Licence	Error: no local variable "epr" has been set.
Operator	[[Error: no local variable "operator" has been set.]]
Operational Capacity	Error: no local variable "plated" has been set.tpa
Number of Lines	Error: no local variable "line" has been set.
Region	[[:Category:Error: no local variable "region" has been set.\|Error: no local variable "region" has been set.]]

Annual Report Data

Year	Total In	Total Clinical	IBA Out	ACP Out	Op Hours

@@ Line 1: / Line 1: @@
 {{#clear_external_data:}}
-{{#get_db_data: db=engy |from=htclin |where=epr='{{{EPR}}}' | data=site=site,epr=epr,operator=operator,plated=plated}}
+{{#get_db_data:
+db=engy
+| from=listclinar
+| where=epr='{{{EPR}}}'
+| data=site=site,epr=epr,operator=operator,plated=plated,year=year, region=region, report = report, line = line, totalin = totalin, totclinin = totclinin, clinnonhazin = clinnonhazin, clinhazin = clinhazin, hazin = hazin, nonhazin = nonhazin, radioactin = radioactin, animin = animin, otherin = otherin, totpcplate = totpcplate, clinpctot = clinpctot, ibaout = ibaout, acpout = acpout, ophrs = ophrs, ophrspctot = ophrspctot
+}}
 <div style="float:right;">
 {|class="wikitable"
 |colspan="2" |<big>'''{{#external_value:site}}'''</big>
 |-
-|colspan="2"|[[File:clin_{{{id}}}.png|400px|center|Site Location]]
+|colspan="2"|[[File:Clin_{{{id}}}.png|400px|center|Site Location]]
 See [[High Temperature and Clinical Waste Incineration|HT & Clin →]] page for a larger UK Wide map.
 |-
@@ Line 18: / Line 23: @@
 |Operational Capacity
 |{{formatnum:{{#external_value:plated}}}}tpa
+|-
+|Number of Lines
+|{{#external_value:line}}
+|-
+|Region
+|[[:Category:{{#external_value:region}}|{{#external_value:region}}]]
+|}
+'''Annual Report Data'''
+{|class="wikitable"
+! Year
+! Total In
+! Total Clinical
+! IBA Out
+! ACP Out
+! Op Hours
+{{#for_external_table:<nowiki />
+{{!}}-
+{{!}} {{{year}}}
+{{!}} {{{totalin}}}
+{{!}} {{{totclinin}}}
+{{!}} {{{ibaout}}}
+{{!}} {{{acpout}}}
+{{!}} {{{ophrs}}}
+}}
 |}
+</div>