TestOrders: Difference between revisions

From MortiWiki
No edit summary
No edit summary
 
(28 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{#subobject:001|list=orders|action=plug|points=4|order date=12/4/17}}
<!--
{{#subobject:002|list=orders|action=rubber|points=2|order date=13/4/17}}
Each of these lines lists an 'object' with properties.
{{#subobject:003|list=orders|action=cum|points=-3|order date=13/4/2017}}
The bit after the first colon can be blank unless all the other properties are identical to another object,
{{#subobject:004|list=orders|action=chast|points=7|order date=14/4/17}}
which is why the last one has a :1 just for uniqueness.
{{#subobject:005|list=orders|action=ruin|points=-2|order date=14/4/17}}
{{#subobject:006|list=orders|action=plug|points=3|order date=14/4/17}}
{{#subobject:007|list=orders|action=cum|points=-3|order date=15/4/17}}
 


These can go onto any page in the wiki, so you can have pages for months etc.
These #subobject lines are not visible (except creating a blank line)
-->
{{#subobject:|list=orders|action=plug|points=4|order date=2017/03/11}}
{{#subobject:|list=orders|action=rubber|points=2|order date=2017/03/12}}
{{#subobject:|list=orders|action=cum|points=-3|order date=2017/03/12}}
{{#subobject:|list=orders|action=chast|points=7|order date=2017/03/13}}
{{#subobject:|list=orders|action=ruin|points=-2|order date=2017/03/13}}
{{#subobject:|list=orders|action=plug|points=3|order date=2017/03/14}}
{{#subobject:|list=orders|action=cum|points=-3|order date=2017/03/15}}
{{#subobject:1|list=orders|action=cum|points=-3|order date=2017/03/15}}
Orders:
Orders:
{{#ask:[[list::orders]]|?order date|?points}}
<!--
This displays a table of all subobjects with 'list=orders'.
The '?points' sets up a column, the last one tidies up (try without it)
-->
{{#ask:[[list::orders]]|?order date|?points|?action|mainlabel=-}}


<!-- This sums all the 'points' values for all 'list=orders' objects -->
Total points: {{#ask:[[list::orders]]|?points|format=sum}}


Total points:
<!-- This is a sort of graph but not so useful as the grouping and labelling not right -->
{{#ask:[[list::orders]]|?points|format=sum}}
 


{{#ask:[[list::orders]]
{{#ask:[[list::orders]]
|?points|
|?points
format=jqplotchart|charttype=bar
|?action
|?order date
|format=jqplotseries
|charttype=bar
}}
}}
__NOCACHE__

Latest revision as of 16:20, 28 August 2016





Orders:

Order datePointsAction
11 March 20174Plug
13 March 2017-2Ruin
13 March 20177Chast
12 March 20172Rubber
14 March 20173Plug
12 March 2017-3Cum
15 March 2017-3Cum
15 March 2017-3Cum

Total points: 5


Loading...