Warehouse

Aggrosoft\WAWIBundle\Entity\Warehouse

Columns

Relations

Properties

Relationships

Click entity to navigate

→ Country ← WarehouseStorageLocation ← VendorOrder ↔ WarehouseDimensions ↔ Client ↔ Client ↔ Client ↔ User ↔ User ↔ Inventory ↔ RetailStore ↔ SalesChannel ↔ ObjectGroup → Client

erDiagram
    Warehouse {
                string id PK
                string name
                string ident
                boolean active
                integer sort
                string type
                        ___ ___more___
            }
                Warehouse }o--|| Country : "country"
        Country {
        int id PK
    }
                Warehouse ||--o{ WarehouseStorageLocation : "storageLocations"
        WarehouseStorageLocation {
        int id PK
    }
                Warehouse ||--o{ VendorOrder : "orders"
        VendorOrder {
        int id PK
    }
                Warehouse ||--|| WarehouseDimensions : "dimensions"
        WarehouseDimensions {
        int id PK
    }
                Warehouse }o--o{ Client : "clients"
        Client {
        int id PK
    }
                Warehouse }o--o{ Client : "clientsForPicking"
        Client {
        int id PK
    }
                Warehouse }o--o{ Client : "excludedClients"
        Client {
        int id PK
    }
                Warehouse }o--o{ User : "users"
        User {
        int id PK
    }
                Warehouse }o--o{ User : "excludedUsers"
        User {
        int id PK
    }
                Warehouse }o--o{ Inventory : "inventories"
        Inventory {
        int id PK
    }
                Warehouse }o--o{ RetailStore : "retailStores"
        RetailStore {
        int id PK
    }
                Warehouse }o--o{ SalesChannel : "salesChannels"
        SalesChannel {
        int id PK
    }
                Warehouse }o--o{ ObjectGroup : "groups"
        ObjectGroup {
        int id PK
    }
                Warehouse }o--|| Client : "defaultInClient"
        Client {
        int id PK
    }

Metadaten

Tabelle warehouse

Bundle WAWIBundle

Repository Aggrosoft\WAWIBundle\Entity\Repository\WarehouseRepository

Interfaces

IMultiClientable IGroupable

Property	Column	Type	Flags	Twig Access
`id`	`id`	`string(36)`	PK AUTO	{{ entity.id }}
`name`	`name`	`string(255)`		{{ entity.name }}
`ident`	`ident`	`string(255)`		{{ entity.ident }}
`active`	`active`	`boolean`		{{ entity.active }}
`sort`	`sort`	`integer(11)`		{{ entity.sort }}
`type`	`type`	`string(2)`		{{ entity.type }}
`description`	`description`	`text`		{{ entity.description }}
`contactCompany`	`contactCompany`	`string(255)`		{{ entity.contactCompany }}
`contactSalutation`	`contactSalutation`	`string(20)`		{{ entity.contactSalutation }}
`contactFirstName`	`contactFirstName`	`string(255)`		{{ entity.contactFirstName }}
`contactLastName`	`contactLastName`	`string(255)`		{{ entity.contactLastName }}
`contactPhone`	`contactPhone`	`string(50)`		{{ entity.contactPhone }}
`contactFax`	`contactFax`	`string(50)`		{{ entity.contactFax }}
`contactMail`	`contactMail`	`string(255)`		{{ entity.contactMail }}
`contactDepartment`	`contactDepartment`	`string(255)`		{{ entity.contactDepartment }}
`street`	`street`	`string(255)`		{{ entity.street }}
`zip`	`zip`	`string(255)`		{{ entity.zip }}
`city`	`city`	`string(255)`		{{ entity.city }}
`state`	`state`	`string(255)`		{{ entity.state }}
`vatId`	`vatId`	`string(50)`		{{ entity.vatId }}
`glnNumber`	`glnNumber`	`string(128)`		{{ entity.glnNumber }}
`stockInAllClientsVisible`	`stockInAllClientsVisible`	`boolean`		{{ entity.stockInAllClientsVisible }}
`orderReservationOnlyThisClient`	`orderReservationOnlyThisClient`	`boolean`		{{ entity.orderReservationOnlyThisClient }}
`additionalSortingForPickList`	`additionalSortingForPickList`	`string(255)`		{{ entity.additionalSortingForPickList }}
`bookingCheckCondition`	`bookingCheckCondition`	`string(255)`		{{ entity.bookingCheckCondition }}

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` Computed	read write	{{ entity.client }}	`getClient()` `setClient()`	`\Aggrosoft\WAWIBundle\Entity\Client`
`id` DB	read	{{ entity.id }}	`getId()`	`string`
`name` DB	read write	{{ entity.name }}	`getName()` `setName()`	`string`
`ident` DB	read write	{{ entity.ident }}	`getIdent()` `setIdent()`	`string`
`description` DB	read write	{{ entity.description }}	`getDescription()` `setDescription()`	`string`
`contactSalutation` DB	read write	{{ entity.contactSalutation }}	`getContactSalutation()` `setContactSalutation()`	`string`
`contactFirstName` DB	read write	{{ entity.contactFirstName }}	`getContactFirstName()` `setContactFirstName()`	`string`
`contactLastName` DB	read write	{{ entity.contactLastName }}	`getContactLastName()` `setContactLastName()`	`string`
`contactPhone` DB	read write	{{ entity.contactPhone }}	`getContactPhone()` `setContactPhone()`	`string`
`contactFax` DB	read write	{{ entity.contactFax }}	`getContactFax()` `setContactFax()`	`string`
`contactMail` DB	read write	{{ entity.contactMail }}	`getContactMail()` `setContactMail()`	`string`
`contactDepartment` DB	read write	{{ entity.contactDepartment }}	`getContactDepartment()` `setContactDepartment()`	`string`
`street` DB	read write	{{ entity.street }}	`getStreet()` `setStreet()`	`string`
`zip` DB	read write	{{ entity.zip }}	`getZip()` `setZip()`	`string`
`city` DB	read write	{{ entity.city }}	`getCity()` `setCity()`	`string`
`state` DB	read write	{{ entity.state }}	`getState()` `setState()`	`string`
`country` DB	read write	{{ entity.country }}	`getCountry()` `setCountry()`	`\Aggrosoft\WAWIBundle\Entity\Country`
`storageLocations` DB	read	{{ entity.storageLocations }}	`getStorageLocations()`	`\Doctrine\Common\Collections\Collection`
`dimensions` DB	read write	{{ entity.dimensions }}	`getDimensions()` `setDimensions()`	`\Aggrosoft\WAWIBundle\Entity\WarehouseDimensions`
`contactCompany` DB	read write	{{ entity.contactCompany }}	`getContactCompany()` `setContactCompany()`	`string`
`orders` DB	read	{{ entity.orders }}	`getOrders()`	`\Doctrine\Common\Collections\Collection`
`activeClient` Computed	read	{{ entity.activeClient }}	`getActiveClient()`	-
`clients` DB	read	{{ entity.clients }}	`getClients()`	`\Doctrine\Common\Collections\Collection`
`inventories` DB	read	{{ entity.inventories }}	`getInventories()`	`\Doctrine\Common\Collections\Collection`
`type` DB	read write	{{ entity.type }}	`getType()` `setType()`	`string`
`sort` DB	read write	{{ entity.sort }}	`getSort()` `setSort()`	`integer`
`retailStores` DB	read	{{ entity.retailStores }}	`getRetailStores()`	`\Doctrine\Common\Collections\Collection`
`salesChannels` DB	read	{{ entity.salesChannels }}	`getSalesChannels()`	`\Doctrine\Common\Collections\Collection`
`active` DB	read write	{{ entity.active }}	`getActive()` `setActive()`	`integer`
`excludedClients` DB	read	{{ entity.excludedClients }}	`getExcludedClients()`	`\Doctrine\Common\Collections\Collection`
`users` DB	read	{{ entity.users }}	`getUsers()`	`\Doctrine\Common\Collections\Collection`
`excludedUsers` DB	read	{{ entity.excludedUsers }}	`getExcludedUsers()`	`\Doctrine\Common\Collections\Collection`
`groups` DB	read	{{ entity.groups }}	`getGroups()`	`\Doctrine\Common\Collections\Collection`
`vatId` DB	read write	{{ entity.vatId }}	`getVatId()` `setVatId()`	`string`
`defaultInClient` DB	read write	{{ entity.defaultInClient }}	`getDefaultInClient()` `setDefaultInClient()`	`\Aggrosoft\WAWIBundle\Entity\Client`
`stockInAllClientsVisible` DB	read write	{{ entity.stockInAllClientsVisible }}	`getStockInAllClientsVisible()` `setStockInAllClientsVisible()`	`boolean`
`orderReservationOnlyThisClient` DB	read write	{{ entity.orderReservationOnlyThisClient }}	`getOrderReservationOnlyThisClient()` `setOrderReservationOnlyThisClient()`	`boolean`
`clientsForPicking` DB	read	{{ entity.clientsForPicking }}	`getClientsForPicking()`	`\Doctrine\Common\Collections\Collection`
`additionalSortingForPickList` DB	read write	{{ entity.additionalSortingForPickList }}	`getAdditionalSortingForPickList()` `setAdditionalSortingForPickList()`	`string`
`bookingCheckCondition` DB	read write	{{ entity.bookingCheckCondition }}	`getBookingCheckCondition()` `setBookingCheckCondition()`	`string`
`glnNumber` DB	read write	{{ entity.glnNumber }}	`getGlnNumber()` `setGlnNumber()`	`string`
`streetWithoutHouseNumber` Computed	read	{{ entity.streetWithoutHouseNumber }}	`getStreetWithoutHouseNumber()`	-
`houseNumber` Computed	read	{{ entity.houseNumber }}	`getHouseNumber()`	-
`streetParts` Computed	read	{{ entity.streetParts }}	`getStreetParts()`	-

Property	Type	Target Entity	Mapped By	Inversed By	Cascade	Twig Access
`country`	ManyToOne	Country	-	-	-	{{ entity.country }}
`storageLocations`	OneToMany	WarehouseStorageLocation	`warehouse`	-	`all`	{{ entity.storageLocations }}
`orders`	OneToMany	VendorOrder	`warehouse`	-	-	{{ entity.orders }}
`dimensions`	OneToOne	WarehouseDimensions	-	-	`all`	{{ entity.dimensions }}
`clients`	ManyToMany	Client	-	`warehouses`	-	{{ entity.clients }}
`clientsForPicking`	ManyToMany	Client	`warehousesForPicking`	-	-	{{ entity.clientsForPicking }}
`excludedClients`	ManyToMany	Client	-	`excludedWarehouses`	-	{{ entity.excludedClients }}
`users`	ManyToMany	User	-	`warehouses`	-	{{ entity.users }}
`excludedUsers`	ManyToMany	User	-	`excludedWarehouses`	-	{{ entity.excludedUsers }}
`inventories`	ManyToMany	Inventory	`warehouses`	-	-	{{ entity.inventories }}
`retailStores`	ManyToMany	RetailStore	`warehouses`	-	-	{{ entity.retailStores }}
`salesChannels`	ManyToMany	SalesChannel	`warehouses`	-	-	{{ entity.salesChannels }}
`groups`	ManyToMany	ObjectGroup	-	`warehouses`	-	{{ entity.groups }}
`defaultInClient`	ManyToOne	Client	-	-	-	{{ entity.defaultInClient }}

Keine Indexes definiert