Template:Historical sales fields

From MediaWiki

(Difference between revisions)
Jump to: navigation, search
(added column for 2020)
(added 2021 column)
 
Line 28: Line 28:
     CONCAT('$', FORMAT(SUM(CASE WHEN YEAR(sales.Date)='2019' THEN sales.Total ELSE NULL END), 2)) AS `<a href="/wiki/2019_sales">2019</a>`,
     CONCAT('$', FORMAT(SUM(CASE WHEN YEAR(sales.Date)='2019' THEN sales.Total ELSE NULL END), 2)) AS `<a href="/wiki/2019_sales">2019</a>`,
     CONCAT('$', FORMAT(SUM(CASE WHEN YEAR(sales.Date)='2020' THEN sales.Total ELSE NULL END), 2)) AS `<a href="/wiki/2020_sales">2020</a>`,
     CONCAT('$', FORMAT(SUM(CASE WHEN YEAR(sales.Date)='2020' THEN sales.Total ELSE NULL END), 2)) AS `<a href="/wiki/2020_sales">2020</a>`,
 +
    CONCAT('$', FORMAT(SUM(CASE WHEN YEAR(sales.Date)='2021' THEN sales.Total ELSE NULL END), 2)) AS `<a href="/wiki/2021_sales">2021</a>`,
     CONCAT('$', FORMAT(SUM(sales.Total), 2)) AS 'Total'
     CONCAT('$', FORMAT(SUM(sales.Total), 2)) AS 'Total'
FROM
FROM
     s_product_sales_log sales</includeonly>
     s_product_sales_log sales</includeonly>

Latest revision as of 19:34, 31 December 2020

Usage

This template is used to provide the fields in the various tables on the historical sales 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