Template:MRFSidebar: Difference between revisions

No edit summary
No edit summary
Line 7: Line 7:
|Operator|{{#external_value:operator}}
|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"
{|class="wikitable"
|colspan="2"|Tonnage IN
|colspan="2"|Tonnage IN
|-
|Period || 2020
|-
|-
|Quarter 1 || {{formatnum:{{#external_value:inq1}}}}
|Quarter 1 || {{formatnum:{{#external_value:inq1}}}}
Line 22: Line 22:
|-
|-
|Total || {{formatnum:{{#external_value:totin}}}}
|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>
</div>