Template:Historical harvest for

From MediaWiki

(Difference between revisions)
Jump to: navigation, search
(LUT for month)
(Product by Value)
 
Line 67: Line 67:
     CONCAT('$', FORMAT(ROUND((SUM(CASE WHEN YEAR(harvest.date)='2015' AND MONTH(harvest.date)='{{{1}}}' THEN harvest.quantity ELSE NULL END) * prices.price), 2), 2)) AS `<a href="/wiki/2015-{{{1}}}_harvest">2015-{{{1}}}</a>`,
     CONCAT('$', FORMAT(ROUND((SUM(CASE WHEN YEAR(harvest.date)='2015' AND MONTH(harvest.date)='{{{1}}}' THEN harvest.quantity ELSE NULL END) * prices.price), 2), 2)) AS `<a href="/wiki/2015-{{{1}}}_harvest">2015-{{{1}}}</a>`,
     CONCAT('$', FORMAT(ROUND((SUM(CASE WHEN YEAR(harvest.date)='2016' AND MONTH(harvest.date)='{{{1}}}' THEN harvest.quantity ELSE NULL END) * prices.price), 2), 2)) AS `<a href="/wiki/2016-{{{1}}}_harvest">2016-{{{1}}}</a>`,
     CONCAT('$', FORMAT(ROUND((SUM(CASE WHEN YEAR(harvest.date)='2016' AND MONTH(harvest.date)='{{{1}}}' THEN harvest.quantity ELSE NULL END) * prices.price), 2), 2)) AS `<a href="/wiki/2016-{{{1}}}_harvest">2016-{{{1}}}</a>`,
 +
    CONCAT('$', FORMAT(ROUND((SUM(CASE WHEN YEAR(harvest.date)='2017' AND MONTH(harvest.date)='{{{1}}}' THEN harvest.quantity ELSE NULL END) * prices.price), 2), 2)) AS `<a href="/wiki/2017-{{{1}}}_harvest">2017-{{{1}}}</a>`,
     CONCAT('$', FORMAT(ROUND((SUM(harvest.quantity) * prices.price), 2), 2)) AS `<b>TOTAL</b>`
     CONCAT('$', FORMAT(ROUND((SUM(harvest.quantity) * prices.price), 2), 2)) AS `<b>TOTAL</b>`
FROM
FROM

Latest revision as of 05:37, 13 February 2017

Usage

This template is used to display a year-by-year summary of a particular month's harvest information.

Parameters

  1. the month in "MM" format.

See Also

Template:Annual harvest for

Example

as entered 
{{historical harvest for|09}}
as displayed 

Contents


This page shows a year-by-year comparison of September production.

Click on the arrows in any column header to sort by that column.

by Profit centre

Profit centre2007-092008-092009-092010-092011-092012-092013-092014-092015-092016-092017-09Units
Dairy57.5079.35161.56131.83141.37154.74242.51193.20249.94kilograms
Eggs22.00134.00182.00202.00251.00228.00119.0017.0063.00305.00each
Fruiticulture11.5287.801,025.8587.55208.47198.200.4379.35267.63254.32109.64kilograms
Market Garden13.7111.0249.6255.92209.33316.24263.59370.64223.61143.81719.23kilograms
Medicinal Herbs0.183.190.881.74kilograms
Value-Added4.2635.0352.95kilograms
TOTAL:47.23232.821,314.97424.81834.62909.30524.57677.86797.62896.331,080.56kilograms

by Product

Product by Quantity

IDProduct2007-092008-092009-092010-092011-092012-092013-092014-092015-092016-092017-09Units
77alfalfa0.80kilograms
18apples4.0713.5013.5718.861.195.0310.3551.8730.14kilograms
103apples, forage1.702.60kilograms
23basil0.560.481.680.082.360.382.571.28kilograms
213basil, holy (tulsi), buds and flowers0.182.470.831.74kilograms
7beans1.451.702.490.39kilograms
25beans, green4.540.137.342.236.952.662.291.11kilograms
122beans, purple3.916.911.40kilograms
123beans, scarlet runner2.11kilograms
58beets0.300.0514.441.01kilograms
143beets, golden6.20kilograms
9berries, blackberries0.2615.027.0223.3634.347.97kilograms
63berries, blueberries0.03kilograms
138berries, goji0.160.170.855.350.280.73kilograms
145berry, physalis0.102.130.130.2516.41kilograms
75bok choy0.02kilograms
26broccoli0.320.13kilograms
188cabbage, red12.12kilograms
15carrots1.131.6410.484.099.66kilograms
296celery, leaf6.55kilograms
20chard0.233.194.180.23kilograms
56cheese, goat, curds3.39kilograms
87cheese, goat, feta2.343.862.871.00kilograms
166collard greens0.37kilograms
179corn8.13kilograms
81cream0.430.37kilograms
182cucumber, armenian50.782.05kilograms
16cucumbers0.4030.3524.27347.2923.2212.801.00kilograms
259cucumbers, english2.75kilograms
362cucumbers, indian burr gherkin2.03kilograms
17cucumbers, lemon3.07kilograms
234cucumbers, miniature white33.887.3016.08kilograms
241cucumbers, mouse melon5.589.709.466.30kilograms
217dill weed0.34kilograms
329dock, sour0.20kilograms
374eggplant, Pintung Long4.69kilograms
344eggplant, turkish0.45kilograms
37eggs, chicken22.00134.00182.00202.00251.00211.00119.0017.0063.00297.00each
89eggs, duck8.00each
360fennel, seed0.11kilograms
359figs0.55kilograms
176fruit, juice, blackberry2.7635.03kilograms
157fruit, juice, pear13.48kilograms
173fruit, preserved, plum, ginger8.75liters
64garlic15.85kilograms
80horseradish0.10kilograms
338jaltomato0.40kilograms
60kale0.051.001.360.323.080.26kilograms
320kohlrabi1.07kilograms
328leaves, grape0.04kilograms
134leeks0.55kilograms
57lettuce0.160.21kilograms
184melon8.2830.75kilograms
185melon, cantelope17.053.18kilograms
263melon, tiger2.23kilograms
189melon, watermelon47.921.75kilograms
53milk, goat54.1177.01157.28130.40140.00154.74242.51193.20249.94kilograms
181onion, red13.93kilograms
180onion, yellow4.19kilograms
59onions0.500.240.80kilograms
76parsley0.05kilograms
31peaches0.14kilograms
27pears56.183.804.63195.4941.71kilograms
28pears, Bartlett0.575.10kilograms
29pears, Bosch6.48kilograms
82pears, forage1,000.0021.2062.910.57kilograms
108pears, juice20.0063.59201.32kilograms
52pears, Seckel3.3838.78118.24108.15kilograms
62peas0.584.607.631.500.32kilograms
135peas, pods0.13kilograms
136peas, shelling5.24kilograms
345pepper25.35kilograms
223pepper, ancho0.06kilograms
224pepper, cayenne0.18kilograms
196pepper, jalapeño0.061.120.250.86kilograms
349pepper, mulatto1.70kilograms
219pepper, pepperoncini4.75kilograms
351pepper, starfish0.520.20kilograms
352pepper, unspecified hot13.482.27kilograms
242pepper, unspecified sweet19.985.178.8944.76kilograms
3plums3.10kilograms
50plums, yellow45.096.50kilograms
61potatoes3.3039.303.050.41kilograms
73potatoes, blue0.27kilograms
106pumpkin, pie1.30kilograms
83radishes0.660.57kilograms
24salad greens, non-specific0.164.290.201.09kilograms
13spinach0.10kilograms
70squash1.208.4235.56kilograms
104squash, acorn41.33kilograms
153squash, butternut24.80kilograms
147squash, delicata0.40kilograms
325squash, hubbard blue16.97kilograms
71squash, patty pans1.203.327.0313.91kilograms
377squash, pumpkin, sugar17.24kilograms
125squash, Romanesque2.17kilograms
127squash, spaghetti22.781.20kilograms
105squash, summer10.139.1625.85kilograms
376squash, winter16.95kilograms
69squash, zucchini7.506.095.874.896.0511.29kilograms
74squash, zucchini, yellow2.24kilograms
313stevia0.05kilograms
79sunchokes8.35kilograms
274tincture, tulsi0.72liters
347tomatillo, pineapple13.11kilograms
6tomatillos1.807.846.026.0523.83kilograms
4tomatoes5.556.9611.436.2414.73100.968.08188.17129.8260.82314.97kilograms
137tomatoes, cherry23.8228.9514.7916.8111.9377.78kilograms
5tomatoes, paste4.0852.589.155.437.11kilograms
30tomatoes, yellow0.23kilograms
84turnips12.701.580.57kilograms
12vegetables11.82kilograms

Product by Value

IDProduct2007-092008-092009-092010-092011-092012-092013-092014-092015-092016-092017-09TOTAL
77alfalfa$8.00$8.00
18apples$12.70$42.12$42.34$58.83$3.70$15.68$32.29$161.83$94.04$463.53
103apples, forage$0.42$0.65$1.08
23basil$17.36$14.72$51.92$2.32$73.00$11.78$79.61$39.80$290.53
213basil, holy (tulsi), buds and flowers$7.84$107.38$36.15$75.79$227.17
7beans$4.84$5.68$8.32$1.29$20.12
25beans, green$16.98$0.49$27.43$8.34$25.99$9.95$8.55$4.14$101.87
275beans, green, canned
122beans, purple$25.81$45.57$9.21$80.59
123beans, scarlet runner$18.52$18.52
58beets$0.91$0.15$43.89$3.06$48.00
143beets, golden$34.10$34.10
9berries, blackberries$1.43$82.61$38.58$128.45$188.84$43.81$483.72
63berries, blueberries$0.10$0.10
138berries, goji$4.74$5.05$25.99$163.45$8.41$22.32$229.96
145berry, physalis$2.09$46.75$2.86$5.50$361.11$418.31
75bok choy$0.05$0.05
26broccoli$0.92$0.36$1.27
188cabbage, red$66.63$66.63
15carrots$1.90$2.76$17.60$6.86$16.22$45.34
296celery, leaf$19.65$19.65
20chard$1.57$21.72$28.51$1.57$53.37
56cheese, goat, curds$135.60$135.60
87cheese, goat, feta$117.00$192.75$143.50$50.00$503.25
166collard greens$2.41$2.41
179corn$27.79$27.79
81cream$12.90$10.95$23.85
182cucumber, armenian$335.15$13.50$348.64
16cucumbers$1.18$89.53$71.58$1,024.51$68.50$37.75$2.95$1,295.99
259cucumbers, english$18.15$18.15
362cucumbers, indian burr gherkin$26.80$26.80
17cucumbers, lemon$10.13$10.13
234cucumbers, miniature white$298.14$64.24$141.50$503.89
241cucumbers, mouse melon$294.36$511.90$499.22$332.64$1,638.12
217dill weed$2.21$2.21
329dock, sour
374eggplant, Pintung Long
344eggplant, turkish$5.87$5.87
37eggs, chicken$7.26$44.22$60.06$66.66$82.83$75.24$39.27$5.61$20.79$98.01$499.95
89eggs, duck$5.33$5.33
360fennel, seed$2.86$2.86
359figs
176fruit, juice, blackberry$27.60$350.30$377.90
157fruit, juice, pear$67.40$67.40
173fruit, preserved, plum, ginger
93fruit, preserved, unspecified$504.00$504.00
64garlic$418.44$418.44
80horseradish$4.18$4.18
338jaltomato$5.72$5.72
60kale$0.24$4.84$6.58$1.52$14.88$1.23$29.31
320kohlrabi$8.20$8.20
328leaves, grape
134leeks$2.50$2.50
57lettuce$0.69$0.91$1.60
184melon$36.41$135.28$171.69
185melon, cantelope$112.50$20.99$133.48
263melon, tiger$19.58$19.58
189melon, watermelon$158.12$5.76$163.88
53milk, goat$284.08$404.31$825.71$684.58$735.02$812.37$1,273.18$1,014.31$1,312.19$7,345.75
181onion, red$91.90$91.90
180onion, yellow$27.65$27.65
59onions$0.79$0.37$1.25$2.41
76parsley$0.29$0.29
31peaches$0.31$0.31
27pears$119.66$8.09$9.85$416.39$88.83$642.84
28pears, Bartlett$1.21$10.86$12.08
29pears, Bosch$17.88$17.88
82pears, forage$100.00$2.12$6.29$0.06$108.47
108pears, juice$35.20$111.91$354.32$501.43
52pears, Seckel$7.20$82.59$251.84$230.36$571.99
62peas$5.80$46.00$76.25$15.00$3.20$146.25
135peas, pods$0.86$0.86
136peas, shelling$34.56$34.56
345pepper
223pepper, ancho$0.66$0.66
224pepper, cayenne$2.02$2.02
196pepper, jalapeño$0.66$13.36$2.94$10.30$27.25
349pepper, mulatto$29.92$29.92
219pepper, pepperoncini$56.90$56.90
351pepper, starfish$9.15$3.43$12.58
352pepper, unspecified hot$237.18$39.90$277.08
242pepper, unspecified sweet$175.82$45.46$78.23$393.84$693.36
3plums$6.82$6.82
50plums, yellow$105.06$15.14$120.20
61potatoes$6.83$81.35$6.31$0.84$95.34
73potatoes, blue$0.75$0.75
106pumpkin, pie$3.35$3.35
83radishes$3.60$3.14$6.74
24salad greens, non-specific$3.20$85.80$3.90$21.80$114.70
117sauce, apple$7.50$7.50
187sauce, plum$7.50$7.50
270sauce, tomato$31.36$31.36
13spinach$0.39$0.39
70squash$3.05$21.37$90.32$114.74
104squash, acorn
153squash, butternut$81.82$81.82
147squash, delicata$1.73$1.73
325squash, hubbard blue
71squash, patty pans$3.06$8.45$17.93$35.47$64.91
377squash, pumpkin, sugar
125squash, Romanesque$19.05$19.05
127squash, spaghetti$75.17$3.96$79.13
105squash, summer$66.86$60.42$170.58$297.86
376squash, winter
69squash, zucchini$16.20$13.15$12.67$10.56$13.06$24.39$90.03
74squash, zucchini, yellow$5.64$5.64
313stevia$2.32$2.32
79sunchokes$206.83$206.83
274tincture, tulsi$201.60$201.60
347tomatillo, pineapple$471.78$471.78
6tomatillos$18.21$79.35$60.87$61.17$241.15$460.75
4tomatoes$24.42$30.62$50.29$27.43$64.82$444.20$35.53$827.93$571.19$267.60$1,385.85$3,729.88
266tomatoes, canned
137tomatoes, cherry$397.15$482.51$246.47$280.22$198.87$1,296.63$2,901.85
5tomatoes, paste$18.11$233.67$40.66$24.13$31.58$348.15
30tomatoes, yellow$1.01$1.01
84turnips$83.82$10.43$3.76$98.01
12vegetables$52.01$52.01

by Harvester

IDHarvester2007-092008-092009-092010-092011-092012-092013-092014-092015-092016-092017-09Units
516Jiho Shim7.96kilograms
359Ronald Ada8.27kilograms
277Farrah Alladin317.61kilograms
397Chelsea Baldwinson13.21kilograms
148Susie Anne Bartsch10.62kilograms
440Tara Bonham26.98kilograms
390Olivia Brooke1.21kilograms
436Barbara Canabe15.57kilograms
437Danny Canabe2.56kilograms
212Ben Corno404.79kilograms
5Shannon Cowan3.9833.13kilograms
482Sarah d'Apollonia43.24kilograms
518Leonard Dekens53.06kilograms
490Kevin Heumann3.3233.13kilograms
513Brent Ingram10.39kilograms
515Philipp Klein66.91kilograms
352Jason Lalancette0.25kilograms
164Morris Lamrock16.56kilograms
170Dennis Lucarelli0.34kilograms
217Colin McNair3.03kilograms
435Jon Peters0.96kilograms
386Aidan Pitt-Brooke31.05kilograms
216Sofya Raginsky7.59kilograms
431Kate Re28.01kilograms
401Pierre Roberge51.87kilograms
364Mindy Ross181.039.59kilograms
3Cleome Rowe48.42188.29203.2948.09404.97kilograms
165Rudy Siegers8.001.70kilograms
2Jan Steinman53.881,033.71155.53418.09257.88458.97216.12434.34290.18272.00kilograms
500Kate Stephenson209.06kilograms
473Christopher Strong251.22kilograms
0Undefined User25.231.2322.9924.16208.4123.06kilograms
394Steven Valleé214.85kilograms
438Elisabeth Vargas21.12kilograms
4Carol Wagner22.00166.96220.61269.2885.57208.08kilograms

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