Difference between revisions of "Template:MCFloorTotalCostItem"
Jump to navigation
Jump to search
imported>Elaeagnifolia |
imported>Elaeagnifolia (Undo revision 67425 by Elaeagnifolia (talk)) |
||
| Line 13: | Line 13: | ||
### Loop through all ManaPieceElement rows and find + sum Item | ### Loop through all ManaPieceElement rows and find + sum Item | ||
| − | -->{{#ifeq:{{#var:maxLimitBreakCount}} | 4 | {{# | + | -->{{#ifeq:{{#var:maxLimitBreakCount}} | 4 | {{#cargo_query:tables=MCNodes=mcn,ManaPieceElement=mpe |
| − | + | |join on=mcn.ManaPieceType=mpe.ManaPieceType | |
| − | | | + | |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 | |default=0 | ||
| + | |format=template | ||
| + | |named args=yes | ||
|template=MCFloorTotalCostItemSum | |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 |
| − | | | + | |named args=yes |
| + | |format=template | ||
|template=MCFloorTotalCostItemSum | |template=MCFloorTotalCostItemSum | ||
}}}}{{#var:itemTotal}}</includeonly> | }}}}{{#var:itemTotal}}</includeonly> | ||
