Report

Aggrosoft\WAWIBundle\Entity\Report

Columns

Relations

Properties

Relationships

Click entity to navigate

← ReportColumn ← ReportCondition → Client → Language → User ↔ Product ↔ Customer ↔ Offer ↔ Offer ↔ ObjectGroup

erDiagram
    Report {
                string id PK
                boolean active
                boolean internalReport
                string title
                string entity
                string token
                        ___ ___more___
            }
                Report ||--o{ ReportColumn : "columns"
        ReportColumn {
        int id PK
    }
                Report ||--o{ ReportCondition : "conditions"
        ReportCondition {
        int id PK
    }
                Report }o--|| Client : "client"
        Client {
        int id PK
    }
                Report }o--|| Language : "language"
        Language {
        int id PK
    }
                Report }o--|| User : "gridReportForUser"
        User {
        int id PK
    }
                Report }o--o{ Product : "products"
        Product {
        int id PK
    }
                Report }o--o{ Customer : "customers"
        Customer {
        int id PK
    }
                Report }o--o{ Offer : "offers"
        Offer {
        int id PK
    }
                Report }o--o{ Offer : "orders"
        Offer {
        int id PK
    }
                Report }o--o{ ObjectGroup : "groups"
        ObjectGroup {
        int id PK
    }

Metadaten

Tabelle report

Bundle WAWIBundle

Interfaces

IClientable IClientClonable IGroupable IUpdateTimeTrackable

Property	Column	Type	Flags	Twig Access
`id`	`id`	`string(36)`	PK AUTO	{{ entity.id }}
`active`	`active`	`boolean`		{{ entity.active }}
`internalReport`	`internalReport`	`boolean`		{{ entity.internalReport }}
`title`	`title`	`string(255)`		{{ entity.title }}
`entity`	`entity`	`string(255)`		{{ entity.entity }}
`token`	`token`	`string(36)`		{{ entity.token }}
`exportType`	`exportType`	`integer(11)`		{{ entity.exportType }}
`fileName`	`fileName`	`string(255)`		{{ entity.fileName }}
`note`	`note`	`text`		{{ entity.note }}
`maxItemsCount`	`maxItemsCount`	`string(255)`		{{ entity.maxItemsCount }}
`startOffset`	`startOffset`	`string(255)`		{{ entity.startOffset }}
`customCondition`	`customCondition`	`text`		{{ entity.customCondition }}
`customConditionAfterGrouping`	`customConditionAfterGrouping`	`text`		{{ entity.customConditionAfterGrouping }}
`csvDelimiter`	`csvDelimiter`	`string(5)`		{{ entity.csvDelimiter }}
`csvEnclosure`	`csvEnclosure`	`string(5)`		{{ entity.csvEnclosure }}
`csvEncoding`	`csvEncoding`	`string(32)`		{{ entity.csvEncoding }}
`itemsPerCall`	`itemsPerCall`	`integer`		{{ entity.itemsPerCall }}
`sortingField`	`sortingField`	`string(255)`		{{ entity.sortingField }}
`sortingDirection`	`sortingDirection`	`string(4)`		{{ entity.sortingDirection }}
`sortingField2`	`sortingField2`	`string(255)`		{{ entity.sortingField2 }}
`sortingDirection2`	`sortingDirection2`	`string(4)`		{{ entity.sortingDirection2 }}
`lastLog`	`lastLog`	`text`		{{ entity.lastLog }}
`amountOfRowsPerEntity`	`amountOfRowsPerEntity`	`string(255)`		{{ entity.amountOfRowsPerEntity }}
`customRowTemplate`	`customRowTemplate`	`text`		{{ entity.customRowTemplate }}
`customHeaderTemplate`	`customHeaderTemplate`	`text`		{{ entity.customHeaderTemplate }}
`customFooterTemplate`	`customFooterTemplate`	`text`		{{ entity.customFooterTemplate }}
`dqlCondition`	`dqlCondition`	`text`		{{ entity.dqlCondition }}
`noHeader`	`noHeader`	`boolean`		{{ entity.noHeader }}
`useCRLF`	`useCRLF`	`boolean`		{{ entity.useCRLF }}
`fetchFromAllClients`	`fetchFromAllClients`	`boolean`		{{ entity.fetchFromAllClients }}
`additionalFooterRow`	`additionalFooterRow`	`text`		{{ entity.additionalFooterRow }}
`updated`	`updated`	`datetime`		{{ entity.updated }}

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

Property	Access	Twig Usage	Methods	Return Type
`client` DB	read write	{{ entity.client }}	`getClient()` `setClient()`	`\Aggrosoft\WAWIBundle\Entity\Client`
`id` DB	read	{{ entity.id }}	`getId()`	`string`
`title` DB	read write	{{ entity.title }}	`getTitle()` `setTitle()`	`string`
`entity` DB	read write	{{ entity.entity }}	`getEntity()` `setEntity()`	`string`
`note` DB	read write	{{ entity.note }}	`getNote()` `setNote()`	`string`
`columns` DB	read	{{ entity.columns }}	`getColumns()`	`\Doctrine\Common\Collections\Collection`
`customCondition` DB	read write	{{ entity.customCondition }}	`getCustomCondition()` `setCustomCondition()`	`string`
`active` DB	read write	{{ entity.active }}	`getActive()` `setActive()`	`boolean`
`csvDelimiter` DB	read write	{{ entity.csvDelimiter }}	`getCsvDelimiter()` `setCsvDelimiter()`	`string`
`csvEnclosure` DB	read write	{{ entity.csvEnclosure }}	`getCsvEnclosure()` `setCsvEnclosure()`	`string`
`csvEncoding` DB	read write	{{ entity.csvEncoding }}	`getCsvEncoding()` `setCsvEncoding()`	`string`
`token` DB	read write	{{ entity.token }}	`getToken()` `setToken()`	`string`
`fileName` DB	read write	{{ entity.fileName }}	`getFileName()` `setFileName()`	`string`
`itemsPerCall` DB	read write	{{ entity.itemsPerCall }}	`getItemsPerCall()` `setItemsPerCall()`	`integer`
`lastLog` DB	read write	{{ entity.lastLog }}	`getLastLog()` `setLastLog()`	`string`
`conditions` DB	read	{{ entity.conditions }}	`getConditions()`	`\Doctrine\Common\Collections\Collection`
`products` DB	read	{{ entity.products }}	`getProducts()`	`\Doctrine\Common\Collections\Collection`
`customers` DB	read	{{ entity.customers }}	`getCustomers()`	`\Doctrine\Common\Collections\Collection`
`offers` DB	read	{{ entity.offers }}	`getOffers()`	`\Doctrine\Common\Collections\Collection`
`orders` DB	read	{{ entity.orders }}	`getOrders()`	`\Doctrine\Common\Collections\Collection`
`sortingField` DB	read write	{{ entity.sortingField }}	`getSortingField()` `setSortingField()`	`string`
`sortingDirection` DB	read write	{{ entity.sortingDirection }}	`getSortingDirection()` `setSortingDirection()`	`string`
`language` DB	read write	{{ entity.language }}	`getLanguage()` `setLanguage()`	`\Aggrosoft\WAWIBundle\Entity\Language`
`dqlCondition` DB	read write	{{ entity.dqlCondition }}	`getDqlCondition()` `setDqlCondition()`	`string`
`groups` DB	read	{{ entity.groups }}	`getGroups()`	`\Doctrine\Common\Collections\Collection`
`noHeader` DB	read write	{{ entity.noHeader }}	`getNoHeader()` `setNoHeader()`	`boolean`
`maxItemsCount` DB	read write	{{ entity.maxItemsCount }}	`getMaxItemsCount()` `setMaxItemsCount()`	`string`
`startOffset` DB	read write	{{ entity.startOffset }}	`getStartOffset()` `setStartOffset()`	`string`
`exportType` DB	read write	{{ entity.exportType }}	`getExportType()` `setExportType()`	`integer`
`gridReportForUser` DB	read write	{{ entity.gridReportForUser }}	`getGridReportForUser()` `setGridReportForUser()`	`\Aggrosoft\WAWIBundle\Entity\User`
`customRowTemplate` DB	read write	{{ entity.customRowTemplate }}	`getCustomRowTemplate()` `setCustomRowTemplate()`	`string`
`customHeaderTemplate` DB	read write	{{ entity.customHeaderTemplate }}	`getCustomHeaderTemplate()` `setCustomHeaderTemplate()`	`string`
`customFooterTemplate` DB	read write	{{ entity.customFooterTemplate }}	`getCustomFooterTemplate()` `setCustomFooterTemplate()`	`string`
`fetchFromAllClients` DB	read write	{{ entity.fetchFromAllClients }}	`getFetchFromAllClients()` `setFetchFromAllClients()`	`boolean`
`customConditionAfterGrouping` DB	read write	{{ entity.customConditionAfterGrouping }}	`getCustomConditionAfterGrouping()` `setCustomConditionAfterGrouping()`	`string`
`sortingField2` DB	read write	{{ entity.sortingField2 }}	`getSortingField2()` `setSortingField2()`	`string`
`sortingDirection2` DB	read write	{{ entity.sortingDirection2 }}	`getSortingDirection2()` `setSortingDirection2()`	`string`
`useCRLF` DB	read write	{{ entity.useCRLF }}	`getUseCRLF()` `setUseCRLF()`	`boolean`
`amountOfRowsPerEntity` DB	read write	{{ entity.amountOfRowsPerEntity }}	`getAmountOfRowsPerEntity()` `setAmountOfRowsPerEntity()`	`string`
`additionalFooterRow` DB	read write	{{ entity.additionalFooterRow }}	`getAdditionalFooterRow()` `setAdditionalFooterRow()`	`string`
`updated` DB	read write	{{ entity.updated }}	`getUpdated()` `setUpdated()`	`\DateTime`
`internalReport` DB	read write	{{ entity.internalReport }}	`getInternalReport()` `setInternalReport()`	`boolean`

Property	Type	Target Entity	Mapped By	Inversed By	Cascade	Twig Access
`columns`	OneToMany	ReportColumn	`report`	-	`persist` `remove` `refresh`	{{ entity.columns }}
`conditions`	OneToMany	ReportCondition	`report`	-	`persist` `remove` `refresh`	{{ entity.conditions }}
`client`	ManyToOne	Client	-	`workflows`	-	{{ entity.client }}
`language`	ManyToOne	Language	-	-	-	{{ entity.language }}
`gridReportForUser`	ManyToOne	User	-	-	-	{{ entity.gridReportForUser }}
`products`	ManyToMany	Product	`reports`	-	-	{{ entity.products }}
`customers`	ManyToMany	Customer	`reports`	-	-	{{ entity.customers }}
`offers`	ManyToMany	Offer	`reports`	-	-	{{ entity.offers }}
`orders`	ManyToMany	Offer	`reports`	-	-	{{ entity.orders }}
`groups`	ManyToMany	ObjectGroup	-	`reports`	-	{{ entity.groups }}

Keine Indexes definiert