Template:Historical harvest value fields

From MediaWiki

(Difference between revisions)
Jump to: navigation, search
(added column for 2020)
(added 2021 column)
 
Line 28: Line 28:
     CONCAT('$', FORMAT(ROUND((SUM(CASE WHEN YEAR(harvest.date)='2019' THEN harvest.quantity ELSE NULL END) * prices.price), 2), 2)) AS '<a href="/wiki/2019_harvest">2019</a>',
     CONCAT('$', FORMAT(ROUND((SUM(CASE WHEN YEAR(harvest.date)='2019' THEN harvest.quantity ELSE NULL END) * prices.price), 2), 2)) AS '<a href="/wiki/2019_harvest">2019</a>',
     CONCAT('$', FORMAT(ROUND((SUM(CASE WHEN YEAR(harvest.date)='2020' THEN harvest.quantity ELSE NULL END) * prices.price), 2), 2)) AS '<a href="/wiki/2020_harvest">2020</a>',
     CONCAT('$', FORMAT(ROUND((SUM(CASE WHEN YEAR(harvest.date)='2020' THEN harvest.quantity ELSE NULL END) * prices.price), 2), 2)) AS '<a href="/wiki/2020_harvest">2020</a>',
 +
    CONCAT('$', FORMAT(ROUND((SUM(CASE WHEN YEAR(harvest.date)='2021' THEN harvest.quantity ELSE NULL END) * prices.price), 2), 2)) AS '<a href="/wiki/2021_harvest">2021</a>',
     CONCAT('$', FORMAT(ROUND((SUM(harvest.quantity) * prices.price), 2), 2)) AS 'Total',
     CONCAT('$', FORMAT(ROUND((SUM(harvest.quantity) * prices.price), 2), 2)) AS 'Total',
     prices.market_type AS `Value`,
     prices.market_type AS `Value`,

Latest revision as of 19:25, 31 December 2020

Usage

This template is used to provide the fields in the various tables on the historical harvest page. They are collected here in the interest of easily adding new years, or changing the basic format and information. This template is unlikely to be useful in any other way.

Parameters

  1. none

Bugs

Example

See Also

Template

Share your opinion


blog comments powered by Disqus
Personal tools
Get our newsletter!
Name:
Email Address:

disturbance
entry points
help (off site)
Environmental jobs, green volunteering, good work! Powered by the wind! This server and other
EcoReality operations
are 100% wind powered.
Powered by Mac OS X Powered by Mac MediaWiki Powered by MariaDB Powered by Valentina Studio Pro