Template:MRFSidebar: Difference between revisions

Revision as of 07:43, 28 January 2022

Error: no local variable "site" has been set.
Error: no local variable "operator" has been set.

Tonnage IN
Period	2020
Quarter 1	Error: no local variable "inq1" has been set.
Quarter 2	Error: no local variable "inq2" has been set.
Quarter 3	Error: no local variable "inq3" has been set.
Quarter 4	Error: no local variable "inq4" has been set.
Total	Error: no local variable "totin" has been set.

Tonnage OUT
Period	2020
Quarter 1	Error: no local variable "outq1" has been set.
Quarter 2	Error: no local variable "outq2" has been set.
Quarter 3	Error: no local variable "outq3" has been set.
Quarter 4	Error: no local variable "outq4" has been set.
Total	Error: no local variable "totout" has been set.

@@ Line 7: / Line 7: @@
 |Operator|{{#external_value:operator}}
 |-
-|}
+|}{{#clear_external_data:}}{{#get_db_data:db=engy|from=mrfstats2020|where=epr='{{{EPR}}}'|data=inq1=inq1,inq2=inq2,inq3=inq3,inq4=inq4,totin=(inq1+inq2+inq3+inq4)}}
-{{#clear_external_data:}}
-{{#get_db_data:db=engy|from=mrfstats2020|where=epr='{{{EPR}}}'|data=inq1=inq1,inq2=inq2,inq3=inq3,inq4=inq4,totin=(inq1+inq2+inq3+inq4)}}
 {|class="wikitable"
 |colspan="2"|Tonnage IN
+|-
+|Period || 2020
 |-
 |Quarter 1 || {{formatnum:{{#external_value:inq1}}}}
@@ Line 22: / Line 22: @@
 |-
 |Total || {{formatnum:{{#external_value:totin}}}}
+|-
+|}{{#clear_external_data:}}{{#get_db_data:db=engy|from=mrfstats2020|where=epr='{{{EPR}}}'|data=outq1=outq1,outq2=outq2,outq3=outq3,outq4=outq4,totout=(outq1+outq2+outq3+outq4)}}
+{|class="wikitable"
+|colspan="2"|Tonnage OUT
+|-
+|Period || 2020
+|-
+|Quarter 1 || {{formatnum:{{#external_value:outq1}}}}
+|-
+|Quarter 2 || {{formatnum:{{#external_value:outq2}}}}
+|-
+|Quarter 3 || {{formatnum:{{#external_value:outq3}}}}
+|-
+|Quarter 4 || {{formatnum:{{#external_value:outq4}}}}
+|-
+|Total || {{formatnum:{{#external_value:totout}}}}
 |-
 |}
 </div>