Template:ClinIncin: Difference between revisions

Revision as of 13:15, 12 May 2021

The query SELECT site,epr,operator,plated,ar19tin,ar19clin,clinpc19,ar19iba,ar19acpr FROM `htclin` WHERE epr='{{{EPR}}}' is invalid (Error 1054: Unknown column 'ar19tin' in 'field list' Function: EDConnectorRdbms::fetch Query: SELECT site,epr,operator,plated,ar19tin,ar19clin,clinpc19,ar19iba,ar19acpr FROM `htclin` WHERE epr='{{{EPR}}}' ).

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

Anual Report Data

colspan="2"	Waste Recieved
Clinical	{{format_number:Error: no local variable "ar19clin" has been set.}}
% of Total	{{format_number:Error: no local variable "clinpc19" has been set.}}
Total Waste	{{format_number:Error: no local variable "ar19tin" has been set.}}
colspan="2"	IBA & APCR Removed
Bottom Ash (t)	{{format_number:Error: no local variable "ar19iba" has been set.}}
Air Polution Residues	{{format_number:Error: no local variable "ar19acpr" has been set.}}

@@ 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=htclin |where=epr='{{{EPR}}}' | data=site=site,epr=epr,operator=operator,plated=plated,ar19tin=ar19tin,ar19clin=ar19clin,clinpc19=clinpc19,ar19iba=ar19iba,ar19acpr=ar19acpr}}
 <div style="float:right;">
@@ Line 18: / Line 18: @@
 |Operational Capacity
 |{{formatnum:{{#external_value:plated}}}}tpa
+|}
+'''Anual Report Data'''
+{|class="wikitable"
+|colspan="2"
+|Waste Recieved
+|-
+|Clinical
+|class="text-align:right;"|{{format_number:{{#external_value:ar19clin}}}}
+|-
+|% of Total
+|class="text-align:right;"|{{format_number:{{#external_value:clinpc19}}}}
+|-
+|Total Waste
+|class="text-align:right;"|{{format_number:{{#external_value:ar19tin}}}}
+|-
+|colspan="2"
+|IBA & APCR Removed
+|-
+|Bottom Ash (t)
+|class="text-align:right;"|{{format_number:{{#external_value:ar19iba}}}}
+|-
+|Air Polution Residues
+|class="text-align:right;"|{{format_number:{{#external_value:ar19acpr}}}}
 |}