SubscriptionContract

Aggrosoft\WAWIBundle\Entity\SubscriptionContract

Columns

Relations

Properties

Relationships

Click entity to navigate

→ Order → ContractGroup → Customer → Address → EntityStatus → Payment → Shipping ← SubscriptionContractPaymentField → Currency → Client ← SubscriptionContractItem ← SubscriptionContractUpload ↔ ObjectGroup ← SubscriptionContractMetaField

erDiagram
    SubscriptionContract {
                string id PK
                datetime created
                string title
                date contractDate
                date terminatedDate
                datetime lastPaymentDate
                        ___ ___more___
            }
                SubscriptionContract }o--|| Order : "lastOrder"
        Order {
        int id PK
    }
                SubscriptionContract }o--|| ContractGroup : "contractGroup"
        ContractGroup {
        int id PK
    }
                SubscriptionContract }o--|| Customer : "customer"
        Customer {
        int id PK
    }
                SubscriptionContract }o--|| Address : "shippingAddress"
        Address {
        int id PK
    }
                SubscriptionContract }o--|| EntityStatus : "status"
        EntityStatus {
        int id PK
    }
                SubscriptionContract }o--|| Payment : "payment"
        Payment {
        int id PK
    }
                SubscriptionContract }o--|| Shipping : "shipping"
        Shipping {
        int id PK
    }
                SubscriptionContract ||--o{ SubscriptionContractPaymentField : "paymentFields"
        SubscriptionContractPaymentField {
        int id PK
    }
                SubscriptionContract }o--|| Currency : "currency"
        Currency {
        int id PK
    }
                SubscriptionContract }o--|| Client : "client"
        Client {
        int id PK
    }
                SubscriptionContract ||--o{ SubscriptionContractItem : "items"
        SubscriptionContractItem {
        int id PK
    }
                SubscriptionContract ||--o{ SubscriptionContractUpload : "uploads"
        SubscriptionContractUpload {
        int id PK
    }
                SubscriptionContract }o--o{ ObjectGroup : "groups"
        ObjectGroup {
        int id PK
    }
                SubscriptionContract ||--o{ SubscriptionContractMetaField : "metafields"
        SubscriptionContractMetaField {
        int id PK
    }

Metadaten

Tabelle subscriptioncontract

Bundle WAWIBundle

Interfaces

IClientable IGroupable IPrivateEntity IHasLanguage IUpdateTimeTrackable IPrototype IMetaExtendable

Property	Column	Type	Flags	Twig Access
`id`	`id`	`string(36)`	PK AUTO	{{ entity.id }}
`created`	`created`	`datetime`		{{ entity.created }}
`title`	`title`	`string(255)`		{{ entity.title }}
`contractDate`	`contractDate`	`date`		{{ entity.contractDate }}
`terminatedDate`	`terminatedDate`	`date`		{{ entity.terminatedDate }}
`lastPaymentDate`	`lastPaymentDate`	`datetime`		{{ entity.lastPaymentDate }}
`subscriptionPaymentTerm`	`subscriptionPaymentTerm`	`string(255)`		{{ entity.subscriptionPaymentTerm }}
`subscriptionNotifyEventTerm`	`subscriptionNotifyEventTerm`	`string(255)`		{{ entity.subscriptionNotifyEventTerm }}
`contractPeriod`	`contractPeriod`	`integer`		{{ entity.contractPeriod }}
`billFromDate`	`billFromDate`	`date`		{{ entity.billFromDate }}
`subscriptionPaymentTermFromDate`	`subscriptionPaymentTermFromDate`	`date`		{{ entity.subscriptionPaymentTermFromDate }}
`signDate`	`signDate`	`date`		{{ entity.signDate }}
`remindDate`	`remindDate`	`date`		{{ entity.remindDate }}
`remindCount`	`remindCount`	`integer`		{{ entity.remindCount }}
`number`	`number`	`bigint`		{{ entity.number }}
`paypalSubscriptionId`	`paypalSubscriptionId`	`string(255)`		{{ entity.paypalSubscriptionId }}
`paypalContractCheckDate`	`paypalContractCheckDate`	`datetime`		{{ entity.paypalContractCheckDate }}
`paypalSubscriptionTerminatedDate`	`paypalSubscriptionTerminatedDate`	`datetime`		{{ entity.paypalSubscriptionTerminatedDate }}
`nettoMode`	`nettoMode`	`boolean`		{{ entity.nettoMode }}
`pricesAsNetto`	`pricesAsNetto`	`boolean`		{{ entity.pricesAsNetto }}
`blocked`	`blocked`	`boolean`		{{ entity.blocked }}
`percentDiscount`	`percentDiscount`	`decimal`		{{ entity.percentDiscount }}
`fixDiscount`	`fixDiscount`	`decimal`		{{ entity.fixDiscount }}
`deliveryCost`	`deliveryCost`	`decimal`		{{ entity.deliveryCost }}
`paymentCost`	`paymentCost`	`decimal`		{{ entity.paymentCost }}
`note`	`note`	`text`		{{ entity.note }}
`paymentTermDate`	`paymentTermDate`	`string(255)`		{{ entity.paymentTermDate }}
`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
`titleWithName` Computed	read	{{ entity.titleWithName }}	`getTitleWithName()`	-
`client` DB	read write	{{ entity.client }}	`getClient()` `setClient()`	`\Aggrosoft\WAWIBundle\Entity\Client`
`id` DB	read	{{ entity.id }}	`getId()`	`string`
`created` DB	read write	{{ entity.created }}	`getCreated()` `setCreated()`	`\DateTime`
`contractDate` DB	read write	{{ entity.contractDate }}	`getContractDate()` `setContractDate()`	`\DateTime`
`terminatedDate` DB	read write	{{ entity.terminatedDate }}	`getTerminatedDate()` `setTerminatedDate()`	`\DateTime`
`signDate` DB	read write	{{ entity.signDate }}	`getSignDate()` `setSignDate()`	`\DateTime`
`title` DB	read write	{{ entity.title }}	`getTitle()` `setTitle()`	`string`
`number` DB	read write	{{ entity.number }}	`getNumber()` `setNumber()`	`integer`
`note` DB	read write	{{ entity.note }}	`getNote()` `setNote()`	`string`
`contractGroup` DB	read write	{{ entity.contractGroup }}	`getContractGroup()` `setContractGroup()`	`\Aggrosoft\WAWIBundle\Entity\ContractGroup`
`customer` DB	read write	{{ entity.customer }}	`getCustomer()` `setCustomer()`	`\Aggrosoft\WAWIBundle\Entity\Customer`
`status` DB	read write	{{ entity.status }}	`getStatus()` `setStatus()`	`\Aggrosoft\WAWIBundle\Entity\EntityStatus`
`payment` DB	read write	{{ entity.payment }}	`getPayment()` `setPayment()`	`\Aggrosoft\WAWIBundle\Entity\Payment`
`paymentFields` DB	read	{{ entity.paymentFields }}	`getPaymentFields()`	`\Doctrine\Common\Collections\Collection`
`items` DB	read	{{ entity.items }}	`getItems()`	`\Doctrine\Common\Collections\Collection`
`uploads` DB	read	{{ entity.uploads }}	`getUploads()`	`\Doctrine\Common\Collections\Collection`
`groups` DB	read	{{ entity.groups }}	`getGroups()`	`\Doctrine\Common\Collections\Collection`
`subscriptionPaymentTerm` DB	read write	{{ entity.subscriptionPaymentTerm }}	`getSubscriptionPaymentTerm()` `setSubscriptionPaymentTerm()`	`string`
`nettoMode` DB	read write	{{ entity.nettoMode }}	`getNettoMode()` `setNettoMode()`	`boolean`
`deliveryCost` DB	read write	{{ entity.deliveryCost }}	`getDeliveryCost()` `setDeliveryCost()`	`string`
`paymentCost` DB	read write	{{ entity.paymentCost }}	`getPaymentCost()` `setPaymentCost()`	`string`
`shipping` DB	read write	{{ entity.shipping }}	`getShipping()` `setShipping()`	`\Aggrosoft\WAWIBundle\Entity\Shipping`
`fixDiscount` DB	read write	{{ entity.fixDiscount }}	`getFixDiscount()` `setFixDiscount()`	`string`
`percentDiscount` DB	read write	{{ entity.percentDiscount }}	`getPercentDiscount()` `setPercentDiscount()`	`string`
`sum` Computed	read	{{ entity.sum }}	`getSum()`	-
`currency` DB	read write	{{ entity.currency }}	`getCurrency()` `setCurrency()`	`\Aggrosoft\WAWIBundle\Entity\Currency`
`contractPeriod` DB	read write	{{ entity.contractPeriod }}	`getContractPeriod()` `setContractPeriod()`	`integer`
`lastPaymentDate` DB	read write	{{ entity.lastPaymentDate }}	`getLastPaymentDate()` `setLastPaymentDate()`	`\DateTime`
`remindDate` DB	read write	{{ entity.remindDate }}	`getRemindDate()` `setRemindDate()`	`\DateTime`
`remindCount` DB	read write	{{ entity.remindCount }}	`getRemindCount()` `setRemindCount()`	`integer`
`billFromDate` DB	read write	{{ entity.billFromDate }}	`getBillFromDate()` `setBillFromDate()`	`\DateTime`
`paymentTermDate` DB	read write	{{ entity.paymentTermDate }}	`getPaymentTermDate()` `setPaymentTermDate()`	`string`
`lastOrder` DB	read write	{{ entity.lastOrder }}	`getLastOrder()` `setLastOrder()`	`\Aggrosoft\WAWIBundle\Entity\Order`
`pricesAsNetto` DB	read write	{{ entity.pricesAsNetto }}	`getPricesAsNetto()` `setPricesAsNetto()`	`boolean`
`blocked` DB	read write	{{ entity.blocked }}	`getBlocked()` `setBlocked()`	`boolean`
`privateCustomer` Computed	read	{{ entity.privateCustomer }}	`getPrivateCustomer()`	-
`subscriptionNotifyEventTerm` DB	read write	{{ entity.subscriptionNotifyEventTerm }}	`getSubscriptionNotifyEventTerm()` `setSubscriptionNotifyEventTerm()`	`string`
`subscriptionPaymentTermFromDate` DB	read write	{{ entity.subscriptionPaymentTermFromDate }}	`getSubscriptionPaymentTermFromDate()` `setSubscriptionPaymentTermFromDate()`	`\DateTime`
`language` Computed	read	{{ entity.language }}	`getLanguage()`	-
`selectedLanguage` Computed	read write	{{ entity.selectedLanguage }}	`getSelectedLanguage()` `setSelectedLanguage()`	-
`translatableLocale` Computed	write		`setTranslatableLocale()`	-
`paypalSubscriptionId` DB	read write	{{ entity.paypalSubscriptionId }}	`getPaypalSubscriptionId()` `setPaypalSubscriptionId()`	`string`
`paypalSubscriptionTerminatedDate` DB	read write	{{ entity.paypalSubscriptionTerminatedDate }}	`getPaypalSubscriptionTerminatedDate()` `setPaypalSubscriptionTerminatedDate()`	`\DateTime`
`paypalContractCheckDate` DB	read write	{{ entity.paypalContractCheckDate }}	`getPaypalContractCheckDate()` `setPaypalContractCheckDate()`	`\DateTime`
`updated` DB	read write	{{ entity.updated }}	`getUpdated()` `setUpdated()`	`\DateTime`
`shippingAddress` DB	read write	{{ entity.shippingAddress }}	`getShippingAddress()` `setShippingAddress()`	`\Aggrosoft\WAWIBundle\Entity\Address`
`metafields` DB	read	{{ entity.metafields }}	`getMetafields()`	`\Doctrine\Common\Collections\Collection`

Property	Type	Target Entity	Mapped By	Inversed By	Cascade	Twig Access
`lastOrder`	ManyToOne	Order	-	-	-	{{ entity.lastOrder }}
`contractGroup`	ManyToOne	ContractGroup	-	-	-	{{ entity.contractGroup }}
`customer`	ManyToOne	Customer	-	-	-	{{ entity.customer }}
`shippingAddress`	ManyToOne	Address	-	-	-	{{ entity.shippingAddress }}
`status`	ManyToOne	EntityStatus	-	-	-	{{ entity.status }}
`payment`	ManyToOne	Payment	-	-	-	{{ entity.payment }}
`shipping`	ManyToOne	Shipping	-	-	`persist` `refresh`	{{ entity.shipping }}
`paymentFields`	OneToMany	SubscriptionContractPaymentField	`subscriptionContract`	-	`persist` `remove`	{{ entity.paymentFields }}
`currency`	ManyToOne	Currency	-	-	-	{{ entity.currency }}
`client`	ManyToOne	Client	-	-	-	{{ entity.client }}
`items`	OneToMany	SubscriptionContractItem	`subscriptionContract`	-	`all`	{{ entity.items }}
`uploads`	OneToMany	SubscriptionContractUpload	`subscriptionContract`	-	`all`	{{ entity.uploads }}
`groups`	ManyToMany	ObjectGroup	-	`subscriptioncontracts`	-	{{ entity.groups }}
`metafields`	OneToMany	SubscriptionContractMetaField	`subscriptionContract`	-	`persist` `remove`	{{ entity.metafields }}

Keine Indexes definiert