Category

Aggrosoft\WAWIBundle\Entity\Category

Columns

Relations

Properties

Relationships

Click entity to navigate

→ Tax → Category → Category ↔ ObjectGroup ← CategoryMetaField ← Category ← Category ↔ Product ↔ Report ↔ Client ← CategoryCountryTax ← CategoryAccessory ↔ VoucherSerie ↔ Discount ↔ CustomerGroup ↔ SalesChannel ↔ ShippingCost ↔ Shipping ↔ ShippingCost ↔ Shipping ↔ ShippingPackage ↔ ShippingPackage → Client → User

erDiagram
    Category {
                string id PK
                string foreignId
                string foreignParentId
                string title
                string ident
                boolean active
                        ___ ___more___
            }
                Category }o--|| Tax : "tax"
        Tax {
        int id PK
    }
                Category }o--|| Category : "parent"
        Category {
        int id PK
    }
                Category }o--|| Category : "additionalParent"
        Category {
        int id PK
    }
                Category }o--o{ ObjectGroup : "groups"
        ObjectGroup {
        int id PK
    }
                Category ||--o{ CategoryMetaField : "metafields"
        CategoryMetaField {
        int id PK
    }
                Category ||--o{ Category : "children"
        Category {
        int id PK
    }
                Category ||--o{ Category : "additionalChildren"
        Category {
        int id PK
    }
                Category }o--o{ Product : "products"
        Product {
        int id PK
    }
                Category }o--o{ Report : "reports"
        Report {
        int id PK
    }
                Category }o--o{ Client : "clients"
        Client {
        int id PK
    }
                Category ||--o{ CategoryCountryTax : "countryTaxes"
        CategoryCountryTax {
        int id PK
    }
                Category ||--o{ CategoryAccessory : "accessories"
        CategoryAccessory {
        int id PK
    }
                Category }o--o{ VoucherSerie : "voucherseries"
        VoucherSerie {
        int id PK
    }
                Category }o--o{ Discount : "discounts"
        Discount {
        int id PK
    }
                Category }o--o{ CustomerGroup : "customergroups"
        CustomerGroup {
        int id PK
    }
                Category }o--o{ SalesChannel : "excludedSaleschannels"
        SalesChannel {
        int id PK
    }
                Category }o--o{ ShippingCost : "shippingcosts"
        ShippingCost {
        int id PK
    }
                Category }o--o{ Shipping : "shippings"
        Shipping {
        int id PK
    }
                Category }o--o{ ShippingCost : "excludedshippingcosts"
        ShippingCost {
        int id PK
    }
                Category }o--o{ Shipping : "excludedshippings"
        Shipping {
        int id PK
    }
                Category }o--o{ ShippingPackage : "shippingpackages"
        ShippingPackage {
        int id PK
    }
                Category }o--o{ ShippingPackage : "excludedshippingpackages"
        ShippingPackage {
        int id PK
    }
                Category }o--|| Client : "mainClient"
        Client {
        int id PK
    }
                Category }o--|| User : "createdByUser"
        User {
        int id PK
    }

Metadaten

Tabelle category

Bundle WAWIBundle

Repository Aggrosoft\WAWIBundle\Entity\Repository\CategoryRepository

Interfaces

IUpload IMultiClientable IMetaExtendable IMainClientable Translatable IUpdateTimeTrackable IPrototype IReportable IGroupable IHasLanguage

Property	Column	Type	Flags	Twig Access
`id`	`id`	`string(36)`	PK AUTO	{{ entity.id }}
`foreignId`	`foreign_id`	`string(36)`		{{ entity.foreignId }}
`foreignParentId`	`foreign_parent_id`	`string(36)`		{{ entity.foreignParentId }}
`title`	`title`	`string(255)`		{{ entity.title }}
`ident`	`ident`	`string(255)`		{{ entity.ident }}
`active`	`active`	`boolean`		{{ entity.active }}
`productGroup`	`productGroup`	`boolean`		{{ entity.productGroup }}
`hidden`	`hidden`	`boolean`		{{ entity.hidden }}
`skipDiscounts`	`skipDiscounts`	`boolean`		{{ entity.skipDiscounts }}
`sort`	`sort`	`integer(11)`		{{ entity.sort }}
`depth`	`depth`	`integer(11)`		{{ entity.depth }}
`description`	`description`	`string(255)`		{{ entity.description }}
`longdescription`	`longdescription`	`text`		{{ entity.longdescription }}
`categoryFullTitle`	`categoryFullTitle`	`string(255)`		{{ entity.categoryFullTitle }}
`additionalTitle`	`additionalTitle`	`string(255)`		{{ entity.additionalTitle }}
`additionalTitle2`	`additionalTitle2`	`string(255)`		{{ entity.additionalTitle2 }}
`additionalTitle3`	`additionalTitle3`	`string(255)`		{{ entity.additionalTitle3 }}
`additionalTitleFull`	`additionalTitleFull`	`text`		{{ entity.additionalTitleFull }}
`additionalTitle2Full`	`additionalTitle2Full`	`text`		{{ entity.additionalTitle2Full }}
`multiLangCategoryFullTitle`	`multiLangCategoryFullTitle`	`text`		{{ entity.multiLangCategoryFullTitle }}
`pictureName`	`picture`	`string(255)`		{{ entity.pictureName }}
`externalLink`	`externalLink`	`string`		{{ entity.externalLink }}
`iconName`	`icon`	`string(255)`		{{ entity.iconName }}
`lastUpdated`	`lastupdated`	`integer(11)`		{{ entity.lastUpdated }}
`customsTariffNumber`	`customsTariffNumber`	`string(32)`		{{ entity.customsTariffNumber }}
`showInCommission`	`showInCommission`	`boolean`		{{ entity.showInCommission }}
`numberOfActiveProducts`	`numberOfActiveProducts`	`integer`		{{ entity.numberOfActiveProducts }}
`customNumberOfProducts1`	`customNumberOfProducts1`	`integer`		{{ entity.customNumberOfProducts1 }}
`customNumberOfProducts2`	`customNumberOfProducts2`	`integer`		{{ entity.customNumberOfProducts2 }}
`customNumberOfProducts3`	`customNumberOfProducts3`	`integer`		{{ entity.customNumberOfProducts3 }}
`customNumberOfProducts4`	`customNumberOfProducts4`	`integer`		{{ entity.customNumberOfProducts4 }}
`customNumberOfProducts5`	`customNumberOfProducts5`	`integer`		{{ entity.customNumberOfProducts5 }}
`customNumberOfProducts6`	`customNumberOfProducts6`	`integer`		{{ entity.customNumberOfProducts6 }}
`customNumberOfProducts7`	`customNumberOfProducts7`	`integer`		{{ entity.customNumberOfProducts7 }}
`customNumberOfProducts8`	`customNumberOfProducts8`	`integer`		{{ entity.customNumberOfProducts8 }}
`customNumberOfProducts9`	`customNumberOfProducts9`	`integer`		{{ entity.customNumberOfProducts9 }}
`customNumberOfProducts10`	`customNumberOfProducts10`	`integer`		{{ entity.customNumberOfProducts10 }}
`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
`fullTitleWithoutRootParent` Computed	read	{{ entity.fullTitleWithoutRootParent }}	`getFullTitleWithoutRootParent()`	-
`uploadFields` Computed	read	{{ entity.uploadFields }}	`getUploadFields()`	-
`id` DB	read write	{{ entity.id }}	`getId()` `setId()`	`integer`
`foreignId` DB	read write	{{ entity.foreignId }}	`getForeignId()` `setForeignId()`	`string`
`foreignParentId` DB	read write	{{ entity.foreignParentId }}	`getForeignParentId()` `setForeignParentId()`	`string`
`title` DB	read write	{{ entity.title }}	`getTitle()` `setTitle()`	`string`
`active` DB	read write	{{ entity.active }}	`getActive()` `setActive()`	`boolean`
`sort` DB	read write	{{ entity.sort }}	`getSort()` `setSort()`	`integer`
`description` DB	read write	{{ entity.description }}	`getDescription()` `setDescription()`	`string`
`longdescription` DB	read write	{{ entity.longdescription }}	`getLongdescription()` `setLongdescription()`	`string`
`parent` DB	read write	{{ entity.parent }}	`getParent()` `setParent()`	`Aggrosoft\WAWIBundle\Entity\Category`
`children` DB	read	{{ entity.children }}	`getChildren()`	`Doctrine\Common\Collections\Collection`
`products` DB	read	{{ entity.products }}	`getProducts()`	`Doctrine\Common\Collections\Collection`
`pictureName` DB	read write	{{ entity.pictureName }}	`getPictureName()` `setPictureName()`	`string`
`picture` Computed	read write	{{ entity.picture }}	`getPicture()` `setPicture()`	-
`metafields` DB	read	{{ entity.metafields }}	`getMetafields()`	`Doctrine\Common\Collections\Collection`
`activeClient` Computed	read	{{ entity.activeClient }}	`getActiveClient()`	-
`rootParent` Computed	read	{{ entity.rootParent }}	`getRootParent()`	-
`rootParentOrThis` Computed	read	{{ entity.rootParentOrThis }}	`getRootParentOrThis()`	-
`subRootParent` Computed	read	{{ entity.subRootParent }}	`getSubRootParent()`	-
`subSubRootParent` Computed	read	{{ entity.subSubRootParent }}	`getSubSubRootParent()`	-
`clients` DB	read	{{ entity.clients }}	`getClients()`	`\Doctrine\Common\Collections\Collection`
`depth` DB	read write	{{ entity.depth }}	`getDepth()` `setDepth()`	`integer`
`tax` DB	read write	{{ entity.tax }}	`getTax()` `setTax()`	`\Aggrosoft\WAWIBundle\Entity\Tax`
`iconName` DB	read write	{{ entity.iconName }}	`getIconName()` `setIconName()`	`string`
`icon` Computed	read write	{{ entity.icon }}	`getIcon()` `setIcon()`	-
`hidden` DB	read write	{{ entity.hidden }}	`getHidden()` `setHidden()`	`boolean`
`externalLink` DB	read write	{{ entity.externalLink }}	`getExternalLink()` `setExternalLink()`	`string`
`lastUpdated` DB	read write	{{ entity.lastUpdated }}	`getLastUpdated()` `setLastUpdated()`	`integer`
`subPath` Computed	read	{{ entity.subPath }}	`getSubPath()`	-
`fullTitle` Computed	read	{{ entity.fullTitle }}	`getFullTitle()`	-
`translatableLocale` Computed	read write	{{ entity.translatableLocale }}	`getTranslatableLocale()` `setTranslatableLocale()`	-
`translatableLocaleOnlyThis` Computed	write		`setTranslatableLocaleOnlyThis()`	-
`translatableLocaleWithParent` Computed	write		`setTranslatableLocaleWithParent()`	-
`translatableLocaleWithAdditionalParent` Computed	write		`setTranslatableLocaleWithAdditionalParent()`	-
`allChildren` Computed	read	{{ entity.allChildren }}	`getAllChildren()`	-
`allChildrenAlsoAdditional` Computed	read	{{ entity.allChildrenAlsoAdditional }}	`getAllChildrenAlsoAdditional()`	-
`allChildrenAlsoAdditionalOnlyWithActiveProducts` Computed	read	{{ entity.allChildrenAlsoAdditionalOnlyWithActiveProducts }}	`getAllChildrenAlsoAdditionalOnlyWithActiveProducts()`	-
`allChildrenOnlyWithActiveProducts` Computed	read	{{ entity.allChildrenOnlyWithActiveProducts }}	`getAllChildrenOnlyWithActiveProducts()`	-
`childrenOrThis` Computed	read	{{ entity.childrenOrThis }}	`getChildrenOrThis()`	-
`parents` Computed	read	{{ entity.parents }}	`getParents()`	-
`additionalParents` Computed	read	{{ entity.additionalParents }}	`getAdditionalParents()`	-
`mainClient` DB	read write	{{ entity.mainClient }}	`getMainClient()` `setMainClient()`	`\Aggrosoft\WAWIBundle\Entity\Client`
`updated` DB	read write	{{ entity.updated }}	`getUpdated()` `setUpdated()`	`\DateTime`
`voucherseries` DB	read	{{ entity.voucherseries }}	`getVoucherseries()`	`\Doctrine\Common\Collections\Collection`
`removeRouter` Computed	read	{{ entity.removeRouter }}	`getRemoveRouter()`	-
`countryTaxes` DB	read	{{ entity.countryTaxes }}	`getCountryTaxes()`	`\Doctrine\Common\Collections\Collection`
`categoryFullTitle` DB	read write	{{ entity.categoryFullTitle }}	`getCategoryFullTitle()` `setCategoryFullTitle()`	`string`
`customsTariffNumber` DB	read write	{{ entity.customsTariffNumber }}	`getCustomsTariffNumber()` `setCustomsTariffNumber()`	`string`
`thisOrParentCustomsTariffNumber` Computed	read	{{ entity.thisOrParentCustomsTariffNumber }}	`getThisOrParentCustomsTariffNumber()`	-
`showInCommission` DB	read write	{{ entity.showInCommission }}	`getShowInCommission()` `setShowInCommission()`	`boolean`
`shippingcosts` DB	read	{{ entity.shippingcosts }}	`getShippingcosts()`	`\Doctrine\Common\Collections\Collection`
`excludedshippingcosts` DB	read	{{ entity.excludedshippingcosts }}	`getExcludedshippingcosts()`	`\Doctrine\Common\Collections\Collection`
`excludedshippings` DB	read	{{ entity.excludedshippings }}	`getExcludedshippings()`	`\Doctrine\Common\Collections\Collection`
`shippings` DB	read	{{ entity.shippings }}	`getShippings()`	`\Doctrine\Common\Collections\Collection`
`reports` DB	read	{{ entity.reports }}	`getReports()`	`\Doctrine\Common\Collections\Collection`
`shippingpackages` DB	read	{{ entity.shippingpackages }}	`getShippingpackages()`	`\Doctrine\Common\Collections\Collection`
`excludedshippingpackages` DB	read	{{ entity.excludedshippingpackages }}	`getExcludedshippingpackages()`	`\Doctrine\Common\Collections\Collection`
`discounts` DB	read	{{ entity.discounts }}	`getDiscounts()`	`\Doctrine\Common\Collections\Collection`
`skipDiscounts` DB	read write	{{ entity.skipDiscounts }}	`getSkipDiscounts()` `setSkipDiscounts()`	`boolean`
`groups` DB	read	{{ entity.groups }}	`getGroups()`	`\Doctrine\Common\Collections\Collection`
`productGroup` DB	read write	{{ entity.productGroup }}	`getProductGroup()` `setProductGroup()`	`boolean`
`thisOrParentSkipDiscounts` Computed	read	{{ entity.thisOrParentSkipDiscounts }}	`getThisOrParentSkipDiscounts()`	-
`accessories` DB	read	{{ entity.accessories }}	`getAccessories()`	`\Doctrine\Common\Collections\Collection`
`language` Computed	read	{{ entity.language }}	`getLanguage()`	-
`selectedLanguage` Computed	read write	{{ entity.selectedLanguage }}	`getSelectedLanguage()` `setSelectedLanguage()`	-
`ident` DB	read write	{{ entity.ident }}	`getIdent()` `setIdent()`	`string`
`productsWithLeafChildren` Computed	read	{{ entity.productsWithLeafChildren }}	`getProductsWithLeafChildren()`	-
`customergroups` DB	read	{{ entity.customergroups }}	`getCustomergroups()`	`\Doctrine\Common\Collections\Collection`
`excludedSaleschannels` DB	read	{{ entity.excludedSaleschannels }}	`getExcludedSaleschannels()`	`\Doctrine\Common\Collections\Collection`
`entityLocale` Computed	read	{{ entity.entityLocale }}	`getEntityLocale()`	-
`fullTitleWithForeignId` Computed	read	{{ entity.fullTitleWithForeignId }}	`getFullTitleWithForeignId()`	-
`dynamicField` Computed	read write	{{ entity.dynamicField }}	`getDynamicField()` `setDynamicField()`	-
`additionalParent` DB	read write	{{ entity.additionalParent }}	`getAdditionalParent()` `setAdditionalParent()`	`\Aggrosoft\WAWIBundle\Entity\Category`
`additionalChildren` DB	read	{{ entity.additionalChildren }}	`getAdditionalChildren()`	`\Doctrine\Common\Collections\Collection`
`childrenAlsoAdditional` Computed	read	{{ entity.childrenAlsoAdditional }}	`getChildrenAlsoAdditional()`	-
`rootAdditionalParent` Computed	read	{{ entity.rootAdditionalParent }}	`getRootAdditionalParent()`	-
`numberOfActiveProducts` DB	read write	{{ entity.numberOfActiveProducts }}	`getNumberOfActiveProducts()` `setNumberOfActiveProducts()`	`integer`
`customNumberOfProducts1` DB	read write	{{ entity.customNumberOfProducts1 }}	`getCustomNumberOfProducts1()` `setCustomNumberOfProducts1()`	`integer`
`customNumberOfProducts2` DB	read write	{{ entity.customNumberOfProducts2 }}	`getCustomNumberOfProducts2()` `setCustomNumberOfProducts2()`	`integer`
`customNumberOfProducts3` DB	read write	{{ entity.customNumberOfProducts3 }}	`getCustomNumberOfProducts3()` `setCustomNumberOfProducts3()`	`integer`
`multiLangCategoryFullTitle` DB	read write	{{ entity.multiLangCategoryFullTitle }}	`getMultiLangCategoryFullTitle()` `setMultiLangCategoryFullTitle()`	`string`
`additionalTitle` DB	read write	{{ entity.additionalTitle }}	`getAdditionalTitle()` `setAdditionalTitle()`	`string`
`additionalTitle2` DB	read write	{{ entity.additionalTitle2 }}	`getAdditionalTitle2()` `setAdditionalTitle2()`	`string`
`firstActiveParentOrThis` Computed	read	{{ entity.firstActiveParentOrThis }}	`getFirstActiveParentOrThis()`	-
`customNumberOfProducts4` DB	read write	{{ entity.customNumberOfProducts4 }}	`getCustomNumberOfProducts4()` `setCustomNumberOfProducts4()`	`integer`
`customNumberOfProducts5` DB	read write	{{ entity.customNumberOfProducts5 }}	`getCustomNumberOfProducts5()` `setCustomNumberOfProducts5()`	`integer`
`additionalTitleFull` DB	read write	{{ entity.additionalTitleFull }}	`getAdditionalTitleFull()` `setAdditionalTitleFull()`	`string`
`additionalTitle2Full` DB	read write	{{ entity.additionalTitle2Full }}	`getAdditionalTitle2Full()` `setAdditionalTitle2Full()`	`string`
`customNumberOfProducts6` DB	read write	{{ entity.customNumberOfProducts6 }}	`getCustomNumberOfProducts6()` `setCustomNumberOfProducts6()`	`integer`
`customNumberOfProducts7` DB	read write	{{ entity.customNumberOfProducts7 }}	`getCustomNumberOfProducts7()` `setCustomNumberOfProducts7()`	`integer`
`customNumberOfProducts8` DB	read write	{{ entity.customNumberOfProducts8 }}	`getCustomNumberOfProducts8()` `setCustomNumberOfProducts8()`	`integer`
`customNumberOfProducts9` DB	read write	{{ entity.customNumberOfProducts9 }}	`getCustomNumberOfProducts9()` `setCustomNumberOfProducts9()`	`integer`
`customNumberOfProducts10` DB	read write	{{ entity.customNumberOfProducts10 }}	`getCustomNumberOfProducts10()` `setCustomNumberOfProducts10()`	`integer`
`fullTitleWithClient` Computed	read	{{ entity.fullTitleWithClient }}	`getFullTitleWithClient()`	-
`createdByUser` DB	read write	{{ entity.createdByUser }}	`getCreatedByUser()` `setCreatedByUser()`	`\Aggrosoft\WAWIBundle\Entity\User`
`additionalTitle3` DB	read write	{{ entity.additionalTitle3 }}	`getAdditionalTitle3()` `setAdditionalTitle3()`	`string`
`activeChildren` Computed	read	{{ entity.activeChildren }}	`getActiveChildren()`	-

Property	Type	Target Entity	Mapped By	Inversed By	Cascade	Twig Access
`tax`	ManyToOne	Tax	-	-	-	{{ entity.tax }}
`parent`	ManyToOne	Category	-	`children`	-	{{ entity.parent }}
`additionalParent`	ManyToOne	Category	-	`additionalChildren`	-	{{ entity.additionalParent }}
`groups`	ManyToMany	ObjectGroup	-	`categories`	-	{{ entity.groups }}
`metafields`	OneToMany	CategoryMetaField	`category`	-	`persist` `remove`	{{ entity.metafields }}
`children`	OneToMany	Category	`parent`	-	`remove`	{{ entity.children }}
`additionalChildren`	OneToMany	Category	`additionalParent`	-	-	{{ entity.additionalChildren }}
`products`	ManyToMany	Product	`categories`	-	-	{{ entity.products }}
`reports`	ManyToMany	Report	-	`categories`	`persist`	{{ entity.reports }}
`clients`	ManyToMany	Client	-	`categories`	-	{{ entity.clients }}
`countryTaxes`	OneToMany	CategoryCountryTax	`category`	-	`persist` `remove`	{{ entity.countryTaxes }}
`accessories`	OneToMany	CategoryAccessory	`category`	-	`persist` `remove`	{{ entity.accessories }}
`voucherseries`	ManyToMany	VoucherSerie	-	`categories`	-	{{ entity.voucherseries }}
`discounts`	ManyToMany	Discount	-	`categories`	-	{{ entity.discounts }}
`customergroups`	ManyToMany	CustomerGroup	-	`categories`	`persist`	{{ entity.customergroups }}
`excludedSaleschannels`	ManyToMany	SalesChannel	-	`excludedcategories`	`persist`	{{ entity.excludedSaleschannels }}
`shippingcosts`	ManyToMany	ShippingCost	`categories`	-	-	{{ entity.shippingcosts }}
`shippings`	ManyToMany	Shipping	`categories`	-	-	{{ entity.shippings }}
`excludedshippingcosts`	ManyToMany	ShippingCost	`excludedCategories`	-	-	{{ entity.excludedshippingcosts }}
`excludedshippings`	ManyToMany	Shipping	`excludedCategories`	-	-	{{ entity.excludedshippings }}
`shippingpackages`	ManyToMany	ShippingPackage	`categories`	-	-	{{ entity.shippingpackages }}
`excludedshippingpackages`	ManyToMany	ShippingPackage	`excludedCategories`	-	-	{{ entity.excludedshippingpackages }}
`mainClient`	ManyToOne	Client	-	-	-	{{ entity.mainClient }}
`createdByUser`	ManyToOne	User	-	-	-	{{ entity.createdByUser }}

Index Name	Columns	Type
`search_idx`	`foreign_id` `foreign_parent_id`	INDEX
`title_idx`	`title` `additionalTitle` `additionalTitle2`	INDEX