Voucher

Aggrosoft\WAWIBundle\Entity\Voucher

Columns

Relations

Properties

Relationships

Click entity to navigate

→ Customer → Offer → Offer → Offer → Liability → Voucher → OfferItem → VoucherSerie

erDiagram
    Voucher {
                string id PK
                datetime created
                string foreignId
                string voucherNumber
                string internalNumber
                datetime usedDate
                        ___ ___more___
            }
                Voucher }o--|| Customer : "customer"
        Customer {
        int id PK
    }
                Voucher }o--|| Offer : "offer"
        Offer {
        int id PK
    }
                Voucher }o--|| Offer : "refundoffer"
        Offer {
        int id PK
    }
                Voucher }o--|| Offer : "saleoffer"
        Offer {
        int id PK
    }
                Voucher }o--|| Liability : "liability"
        Liability {
        int id PK
    }
                Voucher }o--|| Voucher : "refundedDiscountVoucher"
        Voucher {
        int id PK
    }
                Voucher }o--|| OfferItem : "saleofferitem"
        OfferItem {
        int id PK
    }
                Voucher }o--|| VoucherSerie : "voucherserie"
        VoucherSerie {
        int id PK
    }

Metadaten

Tabelle voucher

Bundle WAWIBundle

Interfaces

IHasLanguage IPrototype IUpdateTimeTrackable

Property	Column	Type	Flags	Twig Access
`id`	`id`	`string(36)`	PK AUTO	{{ entity.id }}
`created`	`created`	`datetime`		{{ entity.created }}
`foreignId`	`foreign_id`	`string(36)`		{{ entity.foreignId }}
`voucherNumber`	`voucherNumber`	`string(255)`		{{ entity.voucherNumber }}
`internalNumber`	`internalNumber`	`string(255)`		{{ entity.internalNumber }}
`usedDate`	`usedDate`	`datetime`		{{ entity.usedDate }}
`reservedDate`	`reservedDate`	`datetime`		{{ entity.reservedDate }}
`restValue`	`restValue`	`decimal`		{{ entity.restValue }}
`discount`	`discount`	`decimal`		{{ entity.discount }}
`refundedDiscount`	`refundedDiscount`	`decimal`		{{ entity.refundedDiscount }}
`released`	`released`	`boolean`		{{ entity.released }}
`lastUpdated`	`lastupdated`	`integer(11)`		{{ entity.lastUpdated }}
`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`
`created` DB	read write	{{ entity.created }}	`getCreated()` `setCreated()`	`\DateTime`
`foreignId` DB	read write	{{ entity.foreignId }}	`getForeignId()` `setForeignId()`	`string`
`voucherNumber` DB	read write	{{ entity.voucherNumber }}	`getVoucherNumber()` `setVoucherNumber()`	`string`
`usedDate` DB	read write	{{ entity.usedDate }}	`getUsedDate()` `setUsedDate()`	`\DateTime`
`restValue` DB	read write	{{ entity.restValue }}	`getRestValue()` `setRestValue()`	`string`
`discount` DB	read write	{{ entity.discount }}	`getDiscount()` `setDiscount()`	`string`
`lastUpdated` DB	read write	{{ entity.lastUpdated }}	`getLastUpdated()` `setLastUpdated()`	`integer`
`customer` DB	read write	{{ entity.customer }}	`getCustomer()` `setCustomer()`	`\Aggrosoft\WAWIBundle\Entity\Customer`
`offer` DB	read write	{{ entity.offer }}	`getOffer()` `setOffer()`	`\Aggrosoft\WAWIBundle\Entity\Offer`
`voucherserie` DB	read write	{{ entity.voucherserie }}	`getVoucherserie()` `setVoucherserie()`	`\Aggrosoft\WAWIBundle\Entity\VoucherSerie`
`released` DB	read write	{{ entity.released }}	`getReleased()` `setReleased()`	`boolean`
`saleoffer` DB	read write	{{ entity.saleoffer }}	`getSaleoffer()` `setSaleoffer()`	`\Aggrosoft\WAWIBundle\Entity\Offer`
`saleofferitem` DB	read write	{{ entity.saleofferitem }}	`getSaleofferitem()` `setSaleofferitem()`	`\Aggrosoft\WAWIBundle\Entity\OfferItem`
`availableDiscount` Computed	read	{{ entity.availableDiscount }}	`getAvailableDiscount()`	-
`currentRestValue` Computed	read	{{ entity.currentRestValue }}	`getCurrentRestValue()`	-
`thisOrVoucherSerieDiscount` Computed	read	{{ entity.thisOrVoucherSerieDiscount }}	`getThisOrVoucherSerieDiscount()`	-
`prepaidCardTotal` Computed	read	{{ entity.prepaidCardTotal }}	`getPrepaidCardTotal()`	-
`language` Computed	read	{{ entity.language }}	`getLanguage()`	-
`selectedLanguage` Computed	read write	{{ entity.selectedLanguage }}	`getSelectedLanguage()` `setSelectedLanguage()`	-
`translatableLocale` Computed	write		`setTranslatableLocale()`	-
`reservedDate` DB	read write	{{ entity.reservedDate }}	`getReservedDate()` `setReservedDate()`	`\DateTime`
`internalNumber` DB	read write	{{ entity.internalNumber }}	`getInternalNumber()` `setInternalNumber()`	`string`
`liability` DB	read write	{{ entity.liability }}	`getLiability()` `setLiability()`	`\Aggrosoft\WAWIBundle\Entity\Liability`
`refundoffer` DB	read write	{{ entity.refundoffer }}	`getRefundoffer()` `setRefundoffer()`	`\Aggrosoft\WAWIBundle\Entity\Offer`
`refundedDiscountVoucher` DB	read write	{{ entity.refundedDiscountVoucher }}	`getRefundedDiscountVoucher()` `setRefundedDiscountVoucher()`	`\Aggrosoft\WAWIBundle\Entity\Voucher`
`forCustomer` Computed	read	{{ entity.forCustomer }}	`getForCustomer()`	-
`updated` DB	read write	{{ entity.updated }}	`getUpdated()` `setUpdated()`	`\DateTime`
`refundedDiscount` DB	read write	{{ entity.refundedDiscount }}	`getRefundedDiscount()` `setRefundedDiscount()`	`string`

Property	Type	Target Entity	Mapped By	Inversed By	Cascade	Twig Access
`customer`	ManyToOne	Customer	-	-	-	{{ entity.customer }}
`offer`	ManyToOne	Offer	-	`vouchers`	-	{{ entity.offer }}
`refundoffer`	ManyToOne	Offer	-	`refundVouchers`	-	{{ entity.refundoffer }}
`saleoffer`	ManyToOne	Offer	-	`salevouchers`	-	{{ entity.saleoffer }}
`liability`	ManyToOne	Liability	-	`vouchers`	-	{{ entity.liability }}
`refundedDiscountVoucher`	ManyToOne	Voucher	-	-	-	{{ entity.refundedDiscountVoucher }}
`saleofferitem`	ManyToOne	OfferItem	-	-	-	{{ entity.saleofferitem }}
`voucherserie`	ManyToOne	VoucherSerie	-	`vouchers`	-	{{ entity.voucherserie }}

Index Name	Columns	Type
`foreign_idx`	`foreign_id`	INDEX
`number_idx`	`voucherNumber`	INDEX