Template:ClinIncin: Difference between revisions

From Wikiwaste
Arctellion (talk | contribs)
No edit summary
Arctellion (talk | contribs)
No edit summary
Line 1: Line 1:
{{#clear_external_data:}}
{{#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;">
<div style="float:right;">
Line 18: Line 18:
|Operational Capacity
|Operational Capacity
|{{formatnum:{{#external_value:plated}}}}tpa
|{{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}}}}
|}
|}

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.}}