Difference between revisions of "Template:MCFloorTotalCostItem"
Jump to navigation
Jump to search
imported>Elaeagnifolia (Created page with "<noinclude>{{doc}}Category:Templates</noinclude><includeonly>{{#vardefine:itemTotal|0}}<!-- ### Loop through all ManaPieceElement rows and find + sum Item -->{{#cargo_que...") |
imported>Elaeagnifolia (Undo revision 67425 by Elaeagnifolia (talk)) |
||
| (47 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | <noinclude>{{doc}}[[Category:Templates]]</noinclude><includeonly>{{#vardefine:itemTotal|0}}<!-- | + | <noinclude>{{doc}}[[Category:Templates]]</noinclude><includeonly><!-- |
| + | -->{{#vardefine:itemTotal|0}}<!-- | ||
| + | -->{{#vardefine:10201LevelTotal|0}}<!-- | ||
| + | -->{{#vardefine:10301LevelTotal|0}}<!-- | ||
| + | -->{{#vardefine:10302LevelTotal|0}}<!-- | ||
| + | -->{{#vardefine:10303LevelTotal|0}}<!-- | ||
| + | -->{{#vardefine:10401LevelTotal|0}}<!-- | ||
| + | -->{{#vardefine:10402LevelTotal|0}}<!-- | ||
| + | -->{{#vardefine:10501LevelTotal|0}}<!-- | ||
| + | -->{{#vardefine:10601LevelTotal|0}}<!-- | ||
| + | -->{{#vardefine:10701LevelTotal|0}}<!-- | ||
| + | -->{{#vardefine:10801LevelTotal|0}}<!-- | ||
### Loop through all ManaPieceElement rows and find + sum Item | ### Loop through all ManaPieceElement rows and find + sum Item | ||
| − | -->{{#cargo_query:tables=ManaPieceElement | + | -->{{#ifeq:{{#var:maxLimitBreakCount}} | 4 | {{#cargo_query:tables=MCNodes=mcn,ManaPieceElement=mpe |
| − | |fields=CONCAT("{{{1|}}}")=Item,ManaMaterialId11,ManaMaterialQuantity11,ManaMaterialId12, | + | |join on=mcn.ManaPieceType=mpe.ManaPieceType |
| − | |where=ElementId=" | + | |fields=CONCAT("{{{1|}}}")=Item,CONCAT("1")=ManaPieceTypeLevel,mcn.ManaPieceType=ManaPieceType,ManaMaterialId11,ManaMaterialId12,ManaMaterialId13,ManaMaterialQuantity11,ManaMaterialQuantity12,ManaMaterialQuantity13,NeedDewPoint1,ManaMaterialId21,ManaMaterialId22,ManaMaterialId23,ManaMaterialQuantity21,ManaMaterialQuantity22,ManaMaterialQuantity23,NeedDewPoint2,ManaMaterialId31,ManaMaterialId32,ManaMaterialId33,ManaMaterialQuantity31,ManaMaterialQuantity32,ManaMaterialQuantity33,NeedDewPoint3,ManaMaterialId41,ManaMaterialId42,ManaMaterialId43,ManaMaterialQuantity41,ManaMaterialQuantity42,ManaMaterialQuantity43,NeedDewPoint4, |
| + | |where=mcn.Hierarchy != "6" AND mcn.MC="{{#var:manaCircleName}}" AND mpe.ManaPieceType IS NOT NULL AND mpe.ElementId="{{#var:shortManaCircleName}}" | ||
| + | |order by=mcn.Id | ||
| + | |group by=mcn.Id | ||
| + | |default=0 | ||
| + | |format=template | ||
| + | |named args=yes | ||
| + | |template=MCFloorTotalCostItemSum | ||
| + | }} | {{#cargo_query:tables=ManaPieceElement | ||
| + | |fields=CONCAT("{{{1|}}}")=Item,ManaMaterialId11,ManaMaterialQuantity11,ManaMaterialId12,ManaMaterialQuantity12,ManaMaterialId13,ManaMaterialQuantity13,ManaMaterialId21,ManaMaterialQuantity21,ManaMaterialId22,ManaMaterialQuantity22,ManaMaterialId23,ManaMaterialQuantity23,ManaMaterialId31,ManaMaterialQuantity31,ManaMaterialId32,ManaMaterialQuantity32,ManaMaterialId33,ManaMaterialQuantity33,ManaMaterialId41,ManaMaterialQuantity41,ManaMaterialId42,ManaMaterialQuantity42,ManaMaterialId43,ManaMaterialQuantity43 | ||
| + | |where=ElementId="{{#var:shortManaCircleName}}" | ||
|default=0 | |default=0 | ||
|named args=yes | |named args=yes | ||
|format=template | |format=template | ||
|template=MCFloorTotalCostItemSum | |template=MCFloorTotalCostItemSum | ||
| − | }}</includeonly> | + | }}}}{{#var:itemTotal}}</includeonly> |
