ProductStatistics

Aggrosoft\WAWIBundle\Entity\ProductStatistics

Columns

Relations

Properties

Relationships

Click entity to navigate

erDiagram
    ProductStatistics {
                string id PK
                decimal salesLastMonth
                decimal salesLastYear
                decimal returnsLastMonth
                decimal salesLast2Months
                decimal salesLast3Months
                        ___ ___more___
            }
                ProductStatistics }o--|| Product : "product"
        Product {
        int id PK
    }
                ProductStatistics }o--|| Client : "client"
        Client {
        int id PK
    }

Metadaten

Tabelle productstatistics

Bundle WAWIBundle

Property	Column	Type	Flags	Twig Access
`id`	`id`	`string(36)`	PK AUTO	{{ entity.id }}
`salesLastMonth`	`salesLastMonth`	`decimal`		{{ entity.salesLastMonth }}
`salesLastYear`	`salesLastYear`	`decimal`		{{ entity.salesLastYear }}
`returnsLastMonth`	`returnsLastMonth`	`decimal`		{{ entity.returnsLastMonth }}
`salesLast2Months`	`salesLast2Months`	`decimal`		{{ entity.salesLast2Months }}
`salesLast3Months`	`salesLast3Months`	`decimal`		{{ entity.salesLast3Months }}
`returnsLast6Months`	`returnsLast6Months`	`decimal`		{{ entity.returnsLast6Months }}
`returnsLastYear`	`returnsLastYear`	`decimal`		{{ entity.returnsLastYear }}
`salesNextMonthLastYear`	`salesNextMonthLastYear`	`decimal`		{{ entity.salesNextMonthLastYear }}
`salesCustomPeriod`	`salesCustomPeriod`	`decimal`		{{ entity.salesCustomPeriod }}
`returnsCustomPeriod`	`returnsCustomPeriod`	`decimal`		{{ entity.returnsCustomPeriod }}
`outboxesLastYear`	`outboxesLastYear`	`decimal`		{{ entity.outboxesLastYear }}
`receiptsLastYear`	`receiptsLastYear`	`decimal`		{{ entity.receiptsLastYear }}
`minPurchasePrice`	`minPurchasePrice`	`decimal`		{{ entity.minPurchasePrice }}
`minimumStock`	`minimumStock`	`decimal`		{{ entity.minimumStock }}
`maximumStock`	`maximumStock`	`decimal`		{{ entity.maximumStock }}

Tipp: Diese Properties sind über Getter/Setter-Methoden in Twig verfügbar. Verwende {{ entity.propertyName }} zum Lesen.

Property	Access	Twig Usage	Methods	Return Type
`id` DB	read	{{ entity.id }}	`getId()`	`string`
`salesLastMonth` DB	read write	{{ entity.salesLastMonth }}	`getSalesLastMonth()` `setSalesLastMonth()`	`string`
`salesCustomPeriod` DB	read write	{{ entity.salesCustomPeriod }}	`getSalesCustomPeriod()` `setSalesCustomPeriod()`	`string`
`product` DB	read write	{{ entity.product }}	`getProduct()` `setProduct()`	`\Aggrosoft\WAWIBundle\Entity\Product`
`client` DB	read write	{{ entity.client }}	`getClient()` `setClient()`	`\Aggrosoft\WAWIBundle\Entity\Client`
`minPurchasePrice` DB	read write	{{ entity.minPurchasePrice }}	`getMinPurchasePrice()` `setMinPurchasePrice()`	`string`
`salesLastYear` DB	read write	{{ entity.salesLastYear }}	`getSalesLastYear()` `setSalesLastYear()`	`string`
`salesNextMonthLastYear` DB	read write	{{ entity.salesNextMonthLastYear }}	`getSalesNextMonthLastYear()` `setSalesNextMonthLastYear()`	`string`
`minimumStock` DB	read write	{{ entity.minimumStock }}	`getMinimumStock()` `setMinimumStock()`	`string`
`maximumStock` DB	read write	{{ entity.maximumStock }}	`getMaximumStock()` `setMaximumStock()`	`string`
`returnsLastMonth` DB	read write	{{ entity.returnsLastMonth }}	`getReturnsLastMonth()` `setReturnsLastMonth()`	`string`
`returnsLastYear` DB	read write	{{ entity.returnsLastYear }}	`getReturnsLastYear()` `setReturnsLastYear()`	`string`
`returnsCustomPeriod` DB	read write	{{ entity.returnsCustomPeriod }}	`getReturnsCustomPeriod()` `setReturnsCustomPeriod()`	`string`
`returnsLast6Months` DB	read write	{{ entity.returnsLast6Months }}	`getReturnsLast6Months()` `setReturnsLast6Months()`	`string`
`salesLast3Months` DB	read write	{{ entity.salesLast3Months }}	`getSalesLast3Months()` `setSalesLast3Months()`	`string`
`salesLast2Months` DB	read write	{{ entity.salesLast2Months }}	`getSalesLast2Months()` `setSalesLast2Months()`	`string`
`outboxesLastYear` DB	read write	{{ entity.outboxesLastYear }}	`getOutboxesLastYear()` `setOutboxesLastYear()`	`string`
`receiptsLastYear` DB	read write	{{ entity.receiptsLastYear }}	`getReceiptsLastYear()` `setReceiptsLastYear()`	`string`

Property	Type	Target Entity	Mapped By	Inversed By	Cascade	Twig Access
`product`	ManyToOne	Product	-	`pictures`	-	{{ entity.product }}
`client`	ManyToOne	Client	-	-	-	{{ entity.client }}

Keine Indexes definiert