Contact

Aggrosoft\WAWIBundle\Entity\Contact

Columns

Relations

Properties

Relationships

Click entity to navigate

→ Customer ← ContactMessage ← TimeTracking ↔ User ↔ User ↔ Customer → Order → SubscriptionContract → User → Client → Offer → EntityStatus ← ContactMetaField

erDiagram
    Contact {
                string id PK
                text subject
                integer ticketNumber
                boolean wasread
                boolean hasAttachments
                boolean timeTrackingAllowed
                        ___ ___more___
            }
                Contact }o--|| Customer : "customer"
        Customer {
        int id PK
    }
                Contact ||--o{ ContactMessage : "messages"
        ContactMessage {
        int id PK
    }
                Contact ||--o{ TimeTracking : "timeTrackings"
        TimeTracking {
        int id PK
    }
                Contact }o--o{ User : "assignedUsers"
        User {
        int id PK
    }
                Contact }o--o{ User : "excludedUsers"
        User {
        int id PK
    }
                Contact }o--o{ Customer : "assignedCustomers"
        Customer {
        int id PK
    }
                Contact }o--|| Order : "order"
        Order {
        int id PK
    }
                Contact }o--|| SubscriptionContract : "subscriptionContract"
        SubscriptionContract {
        int id PK
    }
                Contact }o--|| User : "contactClerk"
        User {
        int id PK
    }
                Contact }o--|| Client : "client"
        Client {
        int id PK
    }
                Contact }o--|| Offer : "offer"
        Offer {
        int id PK
    }
                Contact }o--|| EntityStatus : "status"
        EntityStatus {
        int id PK
    }
                Contact ||--o{ ContactMetaField : "metafields"
        ContactMetaField {
        int id PK
    }

Metadaten

Tabelle contact

Bundle WAWIBundle

Interfaces

IClientable IEntityStatus IPrototype IMetaExtendable IUpdateTimeTrackable

Property	Column	Type	Flags	Twig Access
`id`	`id`	`string(36)`	PK AUTO	{{ entity.id }}
`subject`	`subject`	`text(255)`		{{ entity.subject }}
`ticketNumber`	`ticketNumber`	`integer(11)`		{{ entity.ticketNumber }}
`wasread`	`wasread`	`boolean`		{{ entity.wasread }}
`hasAttachments`	`hasAttachments`	`boolean`		{{ entity.hasAttachments }}
`timeTrackingAllowed`	`timeTrackingAllowed`	`boolean`		{{ entity.timeTrackingAllowed }}
`flagged`	`flagged`	`boolean`		{{ entity.flagged }}
`lastReply`	`lastReply`	`datetime`		{{ entity.lastReply }}
`cc`	`cc`	`string(255)`		{{ entity.cc }}
`recipientMail`	`recipientMail`	`string(255)`		{{ entity.recipientMail }}
`customerNote`	`customerNote`	`text`		{{ entity.customerNote }}
`customerNote2`	`customerNote2`	`text`		{{ entity.customerNote2 }}
`internalNote`	`internalNote`	`text`		{{ entity.internalNote }}
`estimatedFulfillmentDate`	`estimatedFulfillmentDate`	`string(255)`		{{ entity.estimatedFulfillmentDate }}
`estimatedFulfillmentCosts`	`estimatedFulfillmentCosts`	`string(255)`		{{ entity.estimatedFulfillmentCosts }}
`fulfillmentBeginDate`	`fulfillmentBeginDate`	`datetime`		{{ entity.fulfillmentBeginDate }}
`fulfillmentEndDate`	`fulfillmentEndDate`	`datetime`		{{ entity.fulfillmentEndDate }}
`foreignId`	`foreignId`	`string(36)`		{{ entity.foreignId }}
`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`
`ticketNumber` DB	read write	{{ entity.ticketNumber }}	`getTicketNumber()` `setTicketNumber()`	`integer`
`customer` DB	read write	{{ entity.customer }}	`getCustomer()` `setCustomer()`	`\Aggrosoft\WAWIBundle\Entity\Customer`
`messages` DB	read	{{ entity.messages }}	`getMessages()`	`\Doctrine\Common\Collections\Collection`
`revertedMessages` Computed	read	{{ entity.revertedMessages }}	`getRevertedMessages()`	-
`assignedUsers` DB	read	{{ entity.assignedUsers }}	`getAssignedUsers()`	`\Doctrine\Common\Collections\Collection`
`client` DB	read write	{{ entity.client }}	`getClient()` `setClient()`	`\Aggrosoft\WAWIBundle\Entity\Client`
`subject` DB	read write	{{ entity.subject }}	`getSubject()` `setSubject()`	`string`
`status` DB	read write	{{ entity.status }}	`getStatus()` `setStatus()`	`EntityStatus`
`flagged` DB	read write	{{ entity.flagged }}	`getFlagged()` `setFlagged()`	`boolean`
`wasread` DB	read write	{{ entity.wasread }}	`getWasread()` `setWasread()`	`boolean`
`hasAttachments` DB	read write	{{ entity.hasAttachments }}	`getHasAttachments()` `setHasAttachments()`	`boolean`
`lastReply` DB	read write	{{ entity.lastReply }}	`getLastReply()` `setLastReply()`	`\DateTime`
`order` DB	read write	{{ entity.order }}	`getOrder()` `setOrder()`	`\Aggrosoft\WAWIBundle\Entity\Order`
`subscriptionContract` DB	read write	{{ entity.subscriptionContract }}	`getSubscriptionContract()` `setSubscriptionContract()`	`\Aggrosoft\WAWIBundle\Entity\SubscriptionContract`
`assignedCustomers` DB	read write	{{ entity.assignedCustomers }}	`getAssignedCustomers()` `setAssignedCustomers()`	`\Doctrine\Common\Collections\Collection`
`contactClerk` DB	read write	{{ entity.contactClerk }}	`getContactClerk()` `setContactClerk()`	`\Aggrosoft\WAWIBundle\Entity\User`
`foreignId` DB	read write	{{ entity.foreignId }}	`getForeignId()` `setForeignId()`	`string`
`customerNote` DB	read write	{{ entity.customerNote }}	`getCustomerNote()` `setCustomerNote()`	`string`
`internalNote` DB	read write	{{ entity.internalNote }}	`getInternalNote()` `setInternalNote()`	`string`
`estimatedFulfillmentDate` DB	read write	{{ entity.estimatedFulfillmentDate }}	`getEstimatedFulfillmentDate()` `setEstimatedFulfillmentDate()`	`string`
`estimatedFulfillmentCosts` DB	read write	{{ entity.estimatedFulfillmentCosts }}	`getEstimatedFulfillmentCosts()` `setEstimatedFulfillmentCosts()`	`string`
`fulfillmentBeginDate` DB	read write	{{ entity.fulfillmentBeginDate }}	`getFulfillmentBeginDate()` `setFulfillmentBeginDate()`	`\DateTime`
`fulfillmentEndDate` DB	read write	{{ entity.fulfillmentEndDate }}	`getFulfillmentEndDate()` `setFulfillmentEndDate()`	`\DateTime`
`timeTrackings` DB	read	{{ entity.timeTrackings }}	`getTimeTrackings()`	`\Doctrine\Common\Collections\Collection`
`customerNote2` DB	read write	{{ entity.customerNote2 }}	`getCustomerNote2()` `setCustomerNote2()`	`string`
`offer` DB	read write	{{ entity.offer }}	`getOffer()` `setOffer()`	`\Aggrosoft\WAWIBundle\Entity\Offer`
`timeTrackingAllowed` DB	read write	{{ entity.timeTrackingAllowed }}	`getTimeTrackingAllowed()` `setTimeTrackingAllowed()`	`boolean`
`excludedUsers` DB	read	{{ entity.excludedUsers }}	`getExcludedUsers()`	`\Doctrine\Common\Collections\Collection`
`cancelMails` Computed	read write	{{ entity.cancelMails }}	`getCancelMails()` `setCancelMails()`	-
`elapsedTime` Computed	read	{{ entity.elapsedTime }}	`getElapsedTime()`	-
`timeTrackingBilled` Computed	read	{{ entity.timeTrackingBilled }}	`isTimeTrackingBilled()`	-
`newMessage` Computed	read	{{ entity.newMessage }}	`getNewMessage()`	-
`metafields` DB	read	{{ entity.metafields }}	`getMetafields()`	`\Doctrine\Common\Collections\Collection`
`cc` DB	read write	{{ entity.cc }}	`getCc()` `setCc()`	`string`
`recipientMail` DB	read write	{{ entity.recipientMail }}	`getRecipientMail()` `setRecipientMail()`	`string`
`updated` DB	read write	{{ entity.updated }}	`getUpdated()` `setUpdated()`	`\DateTime`

Property	Type	Target Entity	Mapped By	Inversed By	Cascade	Twig Access
`customer`	ManyToOne	Customer	-	`contacts`	-	{{ entity.customer }}
`messages`	OneToMany	ContactMessage	`contact`	-	`remove`	{{ entity.messages }}
`timeTrackings`	OneToMany	TimeTracking	`contact`	-	`persist` `remove`	{{ entity.timeTrackings }}
`assignedUsers`	ManyToMany	User	-	`assignedTickets`	-	{{ entity.assignedUsers }}
`excludedUsers`	ManyToMany	User	-	`excludedTickets`	-	{{ entity.excludedUsers }}
`assignedCustomers`	ManyToMany	Customer	-	`assignedTickets`	-	{{ entity.assignedCustomers }}
`order`	ManyToOne	Order	-	-	-	{{ entity.order }}
`subscriptionContract`	ManyToOne	SubscriptionContract	-	-	-	{{ entity.subscriptionContract }}
`contactClerk`	ManyToOne	User	-	-	-	{{ entity.contactClerk }}
`client`	ManyToOne	Client	-	-	-	{{ entity.client }}
`offer`	ManyToOne	Offer	-	-	-	{{ entity.offer }}
`status`	ManyToOne	EntityStatus	-	-	-	{{ entity.status }}
`metafields`	OneToMany	ContactMetaField	`contact`	-	`persist` `remove`	{{ entity.metafields }}

Index Name	Columns	Type
`ticketNumber_idx`	`ticketNumber`	INDEX
`foreignId_idx`	`foreignId`	INDEX
`lastReply_idx`	`lastReply`	INDEX