VendorProduct

Aggrosoft\WAWIBundle\Entity\VendorProduct

Columns

Relations

Properties

Relationships

Click entity to navigate

← VendorProductScalePrice → Product → Vendor

erDiagram
    VendorProduct {
                string id PK
                decimal minimumAmount
                decimal minimumAmountStep
                string buyingUnitName
                string buying2saleUnitFormula
                boolean multiplicatePurchasePriceForVendorOrders
                        ___ ___more___
            }
                VendorProduct ||--o{ VendorProductScalePrice : "scalePrices"
        VendorProductScalePrice {
        int id PK
    }
                VendorProduct }o--|| Product : "product"
        Product {
        int id PK
    }
                VendorProduct }o--|| Vendor : "vendor"
        Vendor {
        int id PK
    }

Metadaten

Tabelle vendorproduct

Bundle WAWIBundle

Interfaces

IPrototype IComplexPrototype

Property	Column	Type	Flags	Twig Access
`id`	`id`	`string(36)`	PK AUTO	{{ entity.id }}
`minimumAmount`	`minimumAmount`	`decimal`		{{ entity.minimumAmount }}
`minimumAmountStep`	`minimumAmountStep`	`decimal`		{{ entity.minimumAmountStep }}
`buyingUnitName`	`buyingUnitName`	`string(255)`		{{ entity.buyingUnitName }}
`buying2saleUnitFormula`	`buying2saleUnitFormula`	`string(255)`		{{ entity.buying2saleUnitFormula }}
`multiplicatePurchasePriceForVendorOrders`	`multiplicatePurchasePriceForVendorOrders`	`boolean`		{{ entity.multiplicatePurchasePriceForVendorOrders }}
`acceptanceRange`	`acceptanceRange`	`decimal`		{{ entity.acceptanceRange }}
`deliveryTime`	`deliveryTime`	`integer(3)`		{{ entity.deliveryTime }}
`vendorStock`	`vendorStock`	`decimal`		{{ entity.vendorStock }}
`price`	`price`	`decimal`		{{ entity.price }}
`futurePrice`	`futurePrice`	`decimal`		{{ entity.futurePrice }}
`futurePriceValidFrom`	`futurePriceValidFrom`	`date`		{{ entity.futurePriceValidFrom }}
`futureUvp`	`futureUvp`	`decimal`		{{ entity.futureUvp }}
`futureUvpValidFrom`	`futureUvpValidFrom`	`date`		{{ entity.futureUvpValidFrom }}
`basePrice`	`basePrice`	`decimal`		{{ entity.basePrice }}
`discount`	`discount`	`decimal`		{{ entity.discount }}
`percentDiscount`	`percentDiscount`	`decimal`		{{ entity.percentDiscount }}
`acquisitionCosts`	`acquisitionCosts`	`decimal`		{{ entity.acquisitionCosts }}
`vendorSku`	`vendorSku`	`string(255)`		{{ entity.vendorSku }}
`vendorTitle`	`vendorTitle`	`string(255)`		{{ entity.vendorTitle }}
`vendorEan`	`vendorEan`	`string(255)`		{{ entity.vendorEan }}
`comment`	`comment`	`string(255)`		{{ entity.comment }}
`lastStockUpdate`	`lastStockUpdate`	`date`		{{ entity.lastStockUpdate }}
`dropshipping`	`dropshipping`	`boolean`		{{ entity.dropshipping }}
`ondemand`	`ondemand`	`boolean`		{{ entity.ondemand }}
`addToOwnStock`	`addToOwnStock`	`boolean`		{{ entity.addToOwnStock }}
`useBuying2saleUnitFormulaForOwnStock`	`useBuying2saleUnitFormulaForOwnStock`	`boolean`		{{ entity.useBuying2saleUnitFormulaForOwnStock }}
`transferPriceToProductPurchasePrice`	`transferPriceToProductPurchasePrice`	`boolean`		{{ entity.transferPriceToProductPurchasePrice }}
`alwaysDisplayInProposals`	`alwaysDisplayInProposals`	`boolean`		{{ entity.alwaysDisplayInProposals }}
`discontinued`	`discontinued`	`boolean`		{{ entity.discontinued }}
`uvp`	`uvp`	`decimal`		{{ entity.uvp }}
`availableFrom`	`availableFrom`	`date`		{{ entity.availableFrom }}
`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
`id` DB	read	{{ entity.id }}	`getId()`	`string`
`minimumAmount` DB	read write	{{ entity.minimumAmount }}	`getMinimumAmount()` `setMinimumAmount()`	`float`
`acceptanceRange` DB	read write	{{ entity.acceptanceRange }}	`getAcceptanceRange()` `setAcceptanceRange()`	`float`
`deliveryTime` DB	read write	{{ entity.deliveryTime }}	`getDeliveryTime()` `setDeliveryTime()`	`integer`
`vendorStock` DB	read write	{{ entity.vendorStock }}	`getVendorStock()` `setVendorStock()`	`float`
`price` DB	read write	{{ entity.price }}	`getPrice()` `setPrice()`	`float`
`vendorSku` DB	read write	{{ entity.vendorSku }}	`getVendorSku()` `setVendorSku()`	`string`
`vendorTitle` DB	read write	{{ entity.vendorTitle }}	`getVendorTitle()` `setVendorTitle()`	`string`
`comment` DB	read write	{{ entity.comment }}	`getComment()` `setComment()`	`string`
`lastStockUpdate` DB	read write	{{ entity.lastStockUpdate }}	`getLastStockUpdate()` `setLastStockUpdate()`	`\DateTime`
`dropshipping` DB	read write	{{ entity.dropshipping }}	`getDropshipping()` `setDropshipping()`	`boolean`
`ondemand` DB	read write	{{ entity.ondemand }}	`getOndemand()` `setOndemand()`	`boolean`
`addToOwnStock` DB	read write	{{ entity.addToOwnStock }}	`getAddToOwnStock()` `setAddToOwnStock()`	`boolean`
`product` DB	read write	{{ entity.product }}	`getProduct()` `setProduct()`	`\Aggrosoft\WAWIBundle\Entity\Product`
`vendor` DB	read write	{{ entity.vendor }}	`getVendor()` `setVendor()`	`\Aggrosoft\WAWIBundle\Entity\Vendor`
`buyingUnitName` DB	read write	{{ entity.buyingUnitName }}	`getBuyingUnitName()` `setBuyingUnitName()`	`string`
`buying2saleUnitFormula` DB	read write	{{ entity.buying2saleUnitFormula }}	`getBuying2saleUnitFormula()` `setBuying2saleUnitFormula()`	`string`
`minimumAmountStep` DB	read write	{{ entity.minimumAmountStep }}	`getMinimumAmountStep()` `setMinimumAmountStep()`	`string`
`scalePrices` DB	read	{{ entity.scalePrices }}	`getScalePrices()`	`\Doctrine\Common\Collections\Collection`
`currency` Computed	read write	{{ entity.currency }}	`getCurrency()` `setCurrency()`	-
`priceInDefaultCurrency` Computed	read	{{ entity.priceInDefaultCurrency }}	`getPriceInDefaultCurrency()`	-
`transferPriceToProductPurchasePrice` DB	read write	{{ entity.transferPriceToProductPurchasePrice }}	`getTransferPriceToProductPurchasePrice()` `setTransferPriceToProductPurchasePrice()`	`boolean`
`uvp` DB	read write	{{ entity.uvp }}	`getUvp()` `setUvp()`	`string`
`onBuyingList2` Computed	read write	{{ entity.onBuyingList2 }}	`getOnBuyingList2()` `setOnBuyingList2()`	-
`availableFrom` DB	read write	{{ entity.availableFrom }}	`getAvailableFrom()` `setAvailableFrom()`	`\DateTime`
`multiplicatePurchasePriceForVendorOrders` DB	read write	{{ entity.multiplicatePurchasePriceForVendorOrders }}	`getMultiplicatePurchasePriceForVendorOrders()` `setMultiplicatePurchasePriceForVendorOrders()`	`boolean`
`futurePrice` DB	read write	{{ entity.futurePrice }}	`getFuturePrice()` `setFuturePrice()`	`string`
`futurePriceValidFrom` DB	read write	{{ entity.futurePriceValidFrom }}	`getFuturePriceValidFrom()` `setFuturePriceValidFrom()`	`\DateTime`
`acquisitionCosts` DB	read write	{{ entity.acquisitionCosts }}	`getAcquisitionCosts()` `setAcquisitionCosts()`	`string`
`alwaysDisplayInProposals` DB	read write	{{ entity.alwaysDisplayInProposals }}	`getAlwaysDisplayInProposals()` `setAlwaysDisplayInProposals()`	`boolean`
`vendorEan` DB	read write	{{ entity.vendorEan }}	`getVendorEan()` `setVendorEan()`	`string`
`futureUvp` DB	read write	{{ entity.futureUvp }}	`getFutureUvp()` `setFutureUvp()`	`string`
`futureUvpValidFrom` DB	read write	{{ entity.futureUvpValidFrom }}	`getFutureUvpValidFrom()` `setFutureUvpValidFrom()`	`\DateTime`
`useBuying2saleUnitFormulaForOwnStock` DB	read write	{{ entity.useBuying2saleUnitFormulaForOwnStock }}	`getUseBuying2saleUnitFormulaForOwnStock()` `setUseBuying2saleUnitFormulaForOwnStock()`	`boolean`
`basePrice` DB	read write	{{ entity.basePrice }}	`getBasePrice()` `setBasePrice()`	`string`
`discount` DB	read write	{{ entity.discount }}	`getDiscount()` `setDiscount()`	`string`
`percentDiscount` DB	read write	{{ entity.percentDiscount }}	`getPercentDiscount()` `setPercentDiscount()`	`string`
`discontinued` DB	read write	{{ entity.discontinued }}	`getDiscontinued()` `setDiscontinued()`	`boolean`
`updated` DB	read write	{{ entity.updated }}	`getUpdated()` `setUpdated()`	`\DateTime`

Property	Type	Target Entity	Mapped By	Inversed By	Cascade	Twig Access
`scalePrices`	OneToMany	VendorProductScalePrice	`vendorProduct`	-	`persist` `remove`	{{ entity.scalePrices }}
`product`	ManyToOne	Product	-	`vendor`	-	{{ entity.product }}
`vendor`	ManyToOne	Vendor	-	`products`	-	{{ entity.vendor }}

Index Name	Columns	Type
`search_idx`	`vendorSku` `vendorTitle`	INDEX