CashReport

Aggrosoft\WAWIBundle\Entity\CashReport

Columns

Relations

Properties

Relationships

Click entity to navigate

→ CashJournal → User ↔ BanknoteCountProtocol ↔ ECReport ↔ VoucherReport ← CashReportItem → PublicKey

erDiagram
    CashReport {
                string id PK
                integer number
                decimal openingInventory
                boolean completed
                datetime completedDate
                date date
                        ___ ___more___
            }
                CashReport }o--|| CashJournal : "cashJournal"
        CashJournal {
        int id PK
    }
                CashReport }o--|| User : "user"
        User {
        int id PK
    }
                CashReport ||--|| BanknoteCountProtocol : "banknoteCountProtocol"
        BanknoteCountProtocol {
        int id PK
    }
                CashReport ||--|| ECReport : "ecReport"
        ECReport {
        int id PK
    }
                CashReport ||--|| VoucherReport : "voucherReport"
        VoucherReport {
        int id PK
    }
                CashReport ||--o{ CashReportItem : "items"
        CashReportItem {
        int id PK
    }
                CashReport }o--|| PublicKey : "publicKeyObject"
        PublicKey {
        int id PK
    }

Metadaten

Tabelle cashreport

Bundle WAWIBundle

Property	Column	Type	Flags	Twig Access
`id`	`id`	`string(36)`	PK AUTO	{{ entity.id }}
`number`	`number`	`integer`		{{ entity.number }}
`openingInventory`	`openingInventory`	`decimal`		{{ entity.openingInventory }}
`completed`	`completed`	`boolean`		{{ entity.completed }}
`completedDate`	`completedDate`	`datetime`		{{ entity.completedDate }}
`date`	`date`	`date`		{{ entity.date }}
`cashTotal`	`cashTotal`	`decimal`		{{ entity.cashTotal }}
`receiptTotal`	`receiptTotal`	`decimal`		{{ entity.receiptTotal }}
`outcomeTotal`	`outcomeTotal`	`decimal`		{{ entity.outcomeTotal }}
`signature`	`signature`	`string(255)`		{{ entity.signature }}
`wormSignature`	`wormSignature`	`text`		{{ entity.wormSignature }}
`tseTransactionNumber`	`tseTransactionNumber`	`string(32)`		{{ entity.tseTransactionNumber }}
`tseStartDate`	`tseStartDate`	`string(20)`		{{ entity.tseStartDate }}
`tseFinishDate`	`tseFinishDate`	`string(20)`		{{ entity.tseFinishDate }}
`tseSerialNumber`	`tseSerialNumber`	`string(255)`		{{ entity.tseSerialNumber }}
`note`	`note`	`text`		{{ entity.note }}

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`
`number` DB	read write	{{ entity.number }}	`getNumber()` `setNumber()`	`integer`
`date` DB	read write	{{ entity.date }}	`getDate()` `setDate()`	`\DateTime`
`cashJournal` DB	read write	{{ entity.cashJournal }}	`getCashJournal()` `setCashJournal()`	`\Aggrosoft\WAWIBundle\Entity\CashJournal`
`items` DB	read	{{ entity.items }}	`getItems()`	`\Doctrine\Common\Collections\Collection`
`completed` DB	read write	{{ entity.completed }}	`getCompleted()` `setCompleted()`	`boolean`
`cashTotal` DB	read write	{{ entity.cashTotal }}	`getCashTotal()` `setCashTotal()`	`string`
`receiptTotalSum` Computed	read	{{ entity.receiptTotalSum }}	`getReceiptTotalSum()`	-
`cashReceiptTotalSum` Computed	read	{{ entity.cashReceiptTotalSum }}	`getCashReceiptTotalSum()`	-
`cashExpensesTotalSum` Computed	read	{{ entity.cashExpensesTotalSum }}	`getCashExpensesTotalSum()`	-
`privateReceiptTotalSum` Computed	read	{{ entity.privateReceiptTotalSum }}	`getPrivateReceiptTotalSum()`	-
`invoiceReceiptTotalSum` Computed	read	{{ entity.invoiceReceiptTotalSum }}	`getInvoiceReceiptTotalSum()`	-
`taxRefundTotalSum` Computed	read	{{ entity.taxRefundTotalSum }}	`getTaxRefundTotalSum()`	-
`privateOutcomeTotalSum` Computed	read	{{ entity.privateOutcomeTotalSum }}	`getPrivateOutcomeTotalSum()`	-
`othersReceiptTotalSum` Computed	read	{{ entity.othersReceiptTotalSum }}	`getOthersReceiptTotalSum()`	-
`bankReceiptTotalSum` Computed	read	{{ entity.bankReceiptTotalSum }}	`getBankReceiptTotalSum()`	-
`transitReceiptTotalSum` Computed	read	{{ entity.transitReceiptTotalSum }}	`getTransitReceiptTotalSum()`	-
`othersOutcomeTotalSum` Computed	read	{{ entity.othersOutcomeTotalSum }}	`getOthersOutcomeTotalSum()`	-
`bankOutcomeTotalSum` Computed	read	{{ entity.bankOutcomeTotalSum }}	`getBankOutcomeTotalSum()`	-
`transitOutcomeTotalSum` Computed	read	{{ entity.transitOutcomeTotalSum }}	`getTransitOutcomeTotalSum()`	-
`cashStornoTotalSum` Computed	read	{{ entity.cashStornoTotalSum }}	`getCashStornoTotalSum()`	-
`outcomeTotalSum` Computed	read	{{ entity.outcomeTotalSum }}	`getOutcomeTotalSum()`	-
`cashTotalSum` Computed	read	{{ entity.cashTotalSum }}	`getCashTotalSum()`	-
`totalSum` Computed	read	{{ entity.totalSum }}	`getTotalSum()`	-
`cashAssetTotal` Computed	read	{{ entity.cashAssetTotal }}	`getCashAssetTotal()`	-
`taxTotalSum` Computed	read	{{ entity.taxTotalSum }}	`getTaxTotalSum()`	-
`preTaxTotalSum` Computed	read	{{ entity.preTaxTotalSum }}	`getPreTaxTotalSum()`	-
`receiptTotal` DB	read write	{{ entity.receiptTotal }}	`getReceiptTotal()` `setReceiptTotal()`	`string`
`outcomeTotal` DB	read write	{{ entity.outcomeTotal }}	`getOutcomeTotal()` `setOutcomeTotal()`	`string`
`banknoteCountProtocol` DB	read write	{{ entity.banknoteCountProtocol }}	`getBanknoteCountProtocol()` `setBanknoteCountProtocol()`	`\Aggrosoft\WAWIBundle\Entity\BanknoteCountProtocol`
`user` DB	read write	{{ entity.user }}	`getUser()` `setUser()`	`\Aggrosoft\WAWIBundle\Entity\User`
`completedDate` DB	read write	{{ entity.completedDate }}	`getCompletedDate()` `setCompletedDate()`	`\DateTime`
`openingInventory` DB	read write	{{ entity.openingInventory }}	`getOpeningInventory()` `setOpeningInventory()`	`float`
`ecReport` DB	read write	{{ entity.ecReport }}	`getEcReport()` `setEcReport()`	`\Aggrosoft\WAWIBundle\Entity\ECReport`
`voucherReport` DB	read write	{{ entity.voucherReport }}	`getVoucherReport()` `setVoucherReport()`	`\Aggrosoft\WAWIBundle\Entity\VoucherReport`
`soldVouchersSum` Computed	read	{{ entity.soldVouchersSum }}	`getSoldVouchersSum()`	-
`stornoTaxTotals` Computed	read	{{ entity.stornoTaxTotals }}	`getStornoTaxTotals()`	-
`taxTotals` Computed	read	{{ entity.taxTotals }}	`getTaxTotals()`	-
`pawnTaxTotals` Computed	read	{{ entity.pawnTaxTotals }}	`getPawnTaxTotals()`	-
`taxTotalsNetto` Computed	read	{{ entity.taxTotalsNetto }}	`getTaxTotalsNetto()`	-
`positiveDeviation` Computed	read	{{ entity.positiveDeviation }}	`getPositiveDeviation()`	-
`negativeDeviation` Computed	read	{{ entity.negativeDeviation }}	`getNegativeDeviation()`	-
`allReceiptsSum` Computed	read	{{ entity.allReceiptsSum }}	`getAllReceiptsSum()`	-
`negativeReceiptsSum` Computed	read	{{ entity.negativeReceiptsSum }}	`getNegativeReceiptsSum()`	-
`cashReceiptTotalNettoSum` Computed	read	{{ entity.cashReceiptTotalNettoSum }}	`getCashReceiptTotalNettoSum()`	-
`dayTotalSum` Computed	read	{{ entity.dayTotalSum }}	`getDayTotalSum()`	-
`cashDayTotalSum` Computed	read	{{ entity.cashDayTotalSum }}	`getCashDayTotalSum()`	-
`allOrderItems` Computed	read	{{ entity.allOrderItems }}	`getAllOrderItems()`	-
`discountTotalSum` Computed	read	{{ entity.discountTotalSum }}	`getDiscountTotalSum()`	-
`bonusCardTotalSum` Computed	read	{{ entity.bonusCardTotalSum }}	`getBonusCardTotalSum()`	-
`allItems` Computed	read	{{ entity.allItems }}	`getAllItems()`	-
`signature` DB	read write	{{ entity.signature }}	`getSignature()` `setSignature()`	`string`
`wormSignature` DB	read write	{{ entity.wormSignature }}	`getWormSignature()` `setWormSignature()`	`string`
`tseTransactionNumber` DB	read write	{{ entity.tseTransactionNumber }}	`getTseTransactionNumber()` `setTseTransactionNumber()`	`string`
`tseStartDate` DB	read write	{{ entity.tseStartDate }}	`getTseStartDate()` `setTseStartDate()`	`string`
`tseFinishDate` DB	read write	{{ entity.tseFinishDate }}	`getTseFinishDate()` `setTseFinishDate()`	`string`
`tseSerialNumber` DB	read write	{{ entity.tseSerialNumber }}	`getTseSerialNumber()` `setTseSerialNumber()`	`string`
`publicKeyObject` DB	read write	{{ entity.publicKeyObject }}	`getPublicKeyObject()` `setPublicKeyObject()`	`\Aggrosoft\WAWIBundle\Entity\PublicKey`
`note` DB	read write	{{ entity.note }}	`getNote()` `setNote()`	`string`

Property	Type	Target Entity	Mapped By	Inversed By	Cascade	Twig Access
`cashJournal`	ManyToOne	CashJournal	-	`cashReports`	-	{{ entity.cashJournal }}
`user`	ManyToOne	User	-	-	-	{{ entity.user }}
`banknoteCountProtocol`	OneToOne	BanknoteCountProtocol	-	-	-	{{ entity.banknoteCountProtocol }}
`ecReport`	OneToOne	ECReport	-	-	-	{{ entity.ecReport }}
`voucherReport`	OneToOne	VoucherReport	-	-	-	{{ entity.voucherReport }}
`items`	OneToMany	CashReportItem	`cashReport`	-	`persist` `remove` `refresh`	{{ entity.items }}
`publicKeyObject`	ManyToOne	PublicKey	-	`cashReportItems`	-	{{ entity.publicKeyObject }}

Keine Indexes definiert