Inventory

Aggrosoft\WAWIBundle\Entity\Inventory

Columns

Relations

Properties

Relationships

Click entity to navigate

→ Category → Manufacturer ↔ Warehouse → WarehouseStorageLocation ← InventoryLocation

erDiagram
    Inventory {
                string id PK
                datetime created
                integer inventoryNumber
                boolean completed
                boolean protocolRollingInventory
                boolean includeAllProducts
                        ___ ___more___
            }
                Inventory }o--|| Category : "category"
        Category {
        int id PK
    }
                Inventory }o--|| Manufacturer : "manufacturer"
        Manufacturer {
        int id PK
    }
                Inventory }o--o{ Warehouse : "warehouses"
        Warehouse {
        int id PK
    }
                Inventory }o--|| WarehouseStorageLocation : "inventoredLocation"
        WarehouseStorageLocation {
        int id PK
    }
                Inventory ||--o{ InventoryLocation : "locations"
        InventoryLocation {
        int id PK
    }

Metadaten

Tabelle inventory

Bundle WAWIBundle

Interfaces

IUpload

Property	Column	Type	Flags	Twig Access
`id`	`id`	`string(36)`	PK AUTO	{{ entity.id }}
`created`	`created`	`datetime`		{{ entity.created }}
`inventoryNumber`	`inventoryNumber`	`integer`		{{ entity.inventoryNumber }}
`completed`	`completed`	`boolean`		{{ entity.completed }}
`protocolRollingInventory`	`protocolRollingInventory`	`boolean`		{{ entity.protocolRollingInventory }}
`includeAllProducts`	`includeAllProducts`	`boolean`		{{ entity.includeAllProducts }}
`inventoryType`	`inventoryType`	`integer`		{{ entity.inventoryType }}
`excludeNullStock`	`excludeNullStock`	`boolean`		{{ entity.excludeNullStock }}
`note`	`note`	`text`		{{ entity.note }}
`fetchInventoryAtDate`	`fetchInventoryAtDate`	`datetime`		{{ entity.fetchInventoryAtDate }}
`inventoryFileName`	`inventoryFile`	`string(255)`		{{ entity.inventoryFileName }}
`inventoryCSVProtocolFileName`	`inventoryCSVProtocolFile`	`string(255)`		{{ entity.inventoryCSVProtocolFileName }}
`lastUpdated`	`lastupdated`	`integer(11)`		{{ entity.lastUpdated }}

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`
`created` DB	read write	{{ entity.created }}	`getCreated()` `setCreated()`	`\DateTime`
`note` DB	read write	{{ entity.note }}	`getNote()` `setNote()`	`string`
`locations` DB	read	{{ entity.locations }}	`getLocations()`	`\Doctrine\Common\Collections\Collection`
`inventoryNumber` DB	read write	{{ entity.inventoryNumber }}	`getInventoryNumber()` `setInventoryNumber()`	`integer`
`completed` DB	read write	{{ entity.completed }}	`getCompleted()` `setCompleted()`	`boolean`
`warehouses` DB	read	{{ entity.warehouses }}	`getWarehouses()`	`\Doctrine\Common\Collections\Collection`
`subPath` Computed	read	{{ entity.subPath }}	`getSubPath()`	-
`uploadFields` Computed	read	{{ entity.uploadFields }}	`getUploadFields()`	-
`inventoryFileName` DB	read write	{{ entity.inventoryFileName }}	`getInventoryFileName()` `setInventoryFileName()`	`string`
`inventoryFile` Computed	read write	{{ entity.inventoryFile }}	`getInventoryFile()` `setInventoryFile()`	-
`includeAllProducts` DB	read write	{{ entity.includeAllProducts }}	`getIncludeAllProducts()` `setIncludeAllProducts()`	`boolean`
`lastUpdated` DB	read write	{{ entity.lastUpdated }}	`getLastUpdated()` `setLastUpdated()`	`integer`
`removeRouter` Computed	read	{{ entity.removeRouter }}	`getRemoveRouter()`	-
`inventoryType` DB	read write	{{ entity.inventoryType }}	`getInventoryType()` `setInventoryType()`	`integer`
`allLocations` Computed	read	{{ entity.allLocations }}	`getAllLocations()`	-
`purchaseSum` Computed	read	{{ entity.purchaseSum }}	`getPurchaseSum()`	-
`inventoryCSVProtocolFileName` DB	read write	{{ entity.inventoryCSVProtocolFileName }}	`getInventoryCSVProtocolFileName()` `setInventoryCSVProtocolFileName()`	`string`
`excludeNullStock` DB	read write	{{ entity.excludeNullStock }}	`getExcludeNullStock()` `setExcludeNullStock()`	`boolean`
`category` DB	read write	{{ entity.category }}	`getCategory()` `setCategory()`	`\Aggrosoft\WAWIBundle\Entity\Category`
`inventoredLocation` DB	read write	{{ entity.inventoredLocation }}	`getInventoredLocation()` `setInventoredLocation()`	`\Aggrosoft\WAWIBundle\Entity\WarehouseStorageLocation`
`manufacturer` DB	read write	{{ entity.manufacturer }}	`getManufacturer()` `setManufacturer()`	`\Aggrosoft\WAWIBundle\Entity\Manufacturer`
`protocolRollingInventory` DB	read write	{{ entity.protocolRollingInventory }}	`getProtocolRollingInventory()` `setProtocolRollingInventory()`	`boolean`
`fetchInventoryAtDate` DB	read write	{{ entity.fetchInventoryAtDate }}	`getFetchInventoryAtDate()` `setFetchInventoryAtDate()`	`\DateTime`

Property	Type	Target Entity	Mapped By	Inversed By	Cascade	Twig Access
`category`	ManyToOne	Category	-	`inventories`	-	{{ entity.category }}
`manufacturer`	ManyToOne	Manufacturer	-	`inventories`	-	{{ entity.manufacturer }}
`warehouses`	ManyToMany	Warehouse	-	`inventories`	-	{{ entity.warehouses }}
`inventoredLocation`	ManyToOne	WarehouseStorageLocation	-	-	-	{{ entity.inventoredLocation }}
`locations`	OneToMany	InventoryLocation	`inventory`	-	`persist` `remove` `refresh`	{{ entity.locations }}

Keine Indexes definiert