CommissionContract

Aggrosoft\WAWIBundle\Entity\CommissionContract

Columns

Relations

Properties

Relationships

Click entity to navigate

→ ContractGroup → Customer → EntityStatus → Shipping → Payment ← CommissionContractPaymentField ↔ Order → Client ← CommissionContractItem ← CommissionContractUpload ↔ ObjectGroup

erDiagram
    CommissionContract {
                string id PK
                datetime created
                boolean payout
                date contractDate
                date signDate
                date signRemindDate
                        ___ ___more___
            }
                CommissionContract }o--|| ContractGroup : "contractGroup"
        ContractGroup {
        int id PK
    }
                CommissionContract }o--|| Customer : "customer"
        Customer {
        int id PK
    }
                CommissionContract }o--|| EntityStatus : "status"
        EntityStatus {
        int id PK
    }
                CommissionContract }o--|| Shipping : "returnShipping"
        Shipping {
        int id PK
    }
                CommissionContract }o--|| Payment : "payment"
        Payment {
        int id PK
    }
                CommissionContract ||--o{ CommissionContractPaymentField : "paymentFields"
        CommissionContractPaymentField {
        int id PK
    }
                CommissionContract }o--o{ Order : "returnOrders"
        Order {
        int id PK
    }
                CommissionContract }o--|| Client : "client"
        Client {
        int id PK
    }
                CommissionContract ||--o{ CommissionContractItem : "items"
        CommissionContractItem {
        int id PK
    }
                CommissionContract ||--o{ CommissionContractUpload : "uploads"
        CommissionContractUpload {
        int id PK
    }
                CommissionContract }o--o{ ObjectGroup : "groups"
        ObjectGroup {
        int id PK
    }

Metadaten

Tabelle commissioncontract

Bundle WAWIBundle

Interfaces

IClientable IGroupable IPrivateEntity IOtherClientsAccessible

Property	Column	Type	Flags	Twig Access
`id`	`id`	`string(36)`	PK AUTO	{{ entity.id }}
`created`	`created`	`datetime`		{{ entity.created }}
`payout`	`payout`	`boolean`		{{ entity.payout }}
`contractDate`	`contractDate`	`date`		{{ entity.contractDate }}
`signDate`	`signDate`	`date`		{{ entity.signDate }}
`signRemindDate`	`signRemindDate`	`date`		{{ entity.signRemindDate }}
`signRemindCount`	`signRemindCount`	`integer(11)`		{{ entity.signRemindCount }}
`title`	`title`	`string(255)`		{{ entity.title }}
`number`	`number`	`bigint`		{{ entity.number }}
`contractType`	`contractType`	`string(50)`		{{ entity.contractType }}
`foreignId`	`foreignId`	`string(255)`		{{ entity.foreignId }}
`note`	`note`	`text`		{{ entity.note }}
`customerNote`	`customerNote`	`text`		{{ entity.customerNote }}
`percentFee`	`percentFee`	`decimal`		{{ entity.percentFee }}
`fixFee`	`fixFee`	`decimal`		{{ entity.fixFee }}
`feeFormula`	`feeFormula`	`string(255)`		{{ entity.feeFormula }}
`advancementTotal`	`advancementTotal`	`decimal`		{{ entity.advancementTotal }}

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` 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`
`number` DB	read write	{{ entity.number }}	`getNumber()` `setNumber()`	`integer`
`note` DB	read write	{{ entity.note }}	`getNote()` `setNote()`	`string`
`customer` DB	read write	{{ entity.customer }}	`getCustomer()` `setCustomer()`	`\Aggrosoft\WAWIBundle\Entity\Customer`
`items` DB	read	{{ entity.items }}	`getItems()`	`\Doctrine\Common\Collections\Collection`
`uploads` DB	read	{{ entity.uploads }}	`getUploads()`	`\Doctrine\Common\Collections\Collection`
`title` DB	read write	{{ entity.title }}	`getTitle()` `setTitle()`	`string`
`contractDate` DB	read write	{{ entity.contractDate }}	`getContractDate()` `setContractDate()`	`\DateTime`
`signDate` DB	read write	{{ entity.signDate }}	`getSignDate()` `setSignDate()`	`\DateTime`
`fixFee` DB	read write	{{ entity.fixFee }}	`getFixFee()` `setFixFee()`	`string`
`feeFormula` DB	read write	{{ entity.feeFormula }}	`getFeeFormula()` `setFeeFormula()`	`string`
`percentFee` DB	read write	{{ entity.percentFee }}	`getPercentFee()` `setPercentFee()`	`string`
`payout` DB	read write	{{ entity.payout }}	`getPayout()` `setPayout()`	`boolean`
`returnShipping` DB	read write	{{ entity.returnShipping }}	`getReturnShipping()` `setReturnShipping()`	`\Aggrosoft\WAWIBundle\Entity\Shipping`
`contractGroup` DB	read write	{{ entity.contractGroup }}	`getContractGroup()` `setContractGroup()`	`\Aggrosoft\WAWIBundle\Entity\ContractGroup`
`returnOrders` DB	read	{{ entity.returnOrders }}	`getReturnOrders()`	`\Doctrine\Common\Collections\Collection`
`payment` DB	read write	{{ entity.payment }}	`getPayment()` `setPayment()`	`\Aggrosoft\WAWIBundle\Entity\Payment`
`paymentFields` DB	read	{{ entity.paymentFields }}	`getPaymentFields()`	`\Doctrine\Common\Collections\Collection`
`status` DB	read write	{{ entity.status }}	`getStatus()` `setStatus()`	`\Aggrosoft\WAWIBundle\Entity\EntityStatus`
`groups` DB	read	{{ entity.groups }}	`getGroups()`	`\Doctrine\Common\Collections\Collection`
`privateCustomer` Computed	read	{{ entity.privateCustomer }}	`getPrivateCustomer()`	-
`customerNote` DB	read write	{{ entity.customerNote }}	`getCustomerNote()` `setCustomerNote()`	`string`
`signRemindDate` DB	read write	{{ entity.signRemindDate }}	`getSignRemindDate()` `setSignRemindDate()`	`\DateTime`
`signRemindCount` DB	read write	{{ entity.signRemindCount }}	`getSignRemindCount()` `setSignRemindCount()`	`integer`
`contractType` DB	read write	{{ entity.contractType }}	`getContractType()` `setContractType()`	`string`
`foreignId` DB	read write	{{ entity.foreignId }}	`getForeignId()` `setForeignId()`	`string`
`advancementTotal` DB	read write	{{ entity.advancementTotal }}	`getAdvancementTotal()` `setAdvancementTotal()`	`string`

Property	Type	Target Entity	Mapped By	Inversed By	Cascade	Twig Access
`contractGroup`	ManyToOne	ContractGroup	-	-	-	{{ entity.contractGroup }}
`customer`	ManyToOne	Customer	-	-	-	{{ entity.customer }}
`status`	ManyToOne	EntityStatus	-	-	-	{{ entity.status }}
`returnShipping`	ManyToOne	Shipping	-	-	-	{{ entity.returnShipping }}
`payment`	ManyToOne	Payment	-	-	-	{{ entity.payment }}
`paymentFields`	OneToMany	CommissionContractPaymentField	`commissionContract`	-	`persist` `remove`	{{ entity.paymentFields }}
`returnOrders`	ManyToMany	Order	-	`commissionContracts`	`persist`	{{ entity.returnOrders }}
`client`	ManyToOne	Client	-	-	-	{{ entity.client }}
`items`	OneToMany	CommissionContractItem	`commissionContract`	-	`all`	{{ entity.items }}
`uploads`	OneToMany	CommissionContractUpload	`commissionContract`	-	`all`	{{ entity.uploads }}
`groups`	ManyToMany	ObjectGroup	-	`commissioncontracts`	-	{{ entity.groups }}

Keine Indexes definiert