Template:MRFSidebar: Difference between revisions
No edit summary |
No edit summary |
||
| Line 9: | Line 9: | ||
|}{{#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)}}{{#vardefine:qualin|{{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)}}{{#vardefine:qualout|{{formatnum:{{#external_value:totout}}}}}}{{#clear_external_data:}}{{#get_db_data: db=engy|from=ea_ew_in|where=epr='{{{EPR}}}'|data=opt=sum(tin)}}{{#vardefine:eain|{{formatnum:{{#external_value:opt}}}}}}{{#clear_external_data:}}{{#get_db_data: db=engy|from=ea_ew_out|where=epr='{{{EPR}}}'|data=opt=sum(tin)}}{{#vardefine:eaout|{{formatnum:{{#external_value:opt}}}}}}<small> | |}{{#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)}}{{#vardefine:qualin|{{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)}}{{#vardefine:qualout|{{formatnum:{{#external_value:totout}}}}}}{{#clear_external_data:}}{{#get_db_data: db=engy|from=ea_ew_in|where=epr='{{{EPR}}}'|data=opt=sum(tin)}}{{#vardefine:eain|{{formatnum:{{#external_value:opt}}}}}}{{#clear_external_data:}}{{#get_db_data: db=engy|from=ea_ew_out|where=epr='{{{EPR}}}'|data=opt=sum(tin)}}{{#vardefine:eaout|{{formatnum:{{#external_value:opt}}}}}}<small> | ||
{|class="wikitable" | {|class="wikitable" | ||
|colspan="2"|'''Tonnage Summary''' | |||
|- | |- | ||
!Data !! 2020 | !Data !! 2020 | ||