O:34:"Doctrine\ORM\Mapping\ClassMetadata":13:{s:19:"associationMappings";a:6:{s:12:"orderdetails";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":6:{s:9:"fieldName";s:12:"orderdetails";s:12:"sourceEntity";s:17:"App\Entity\Orders";s:12:"targetEntity";s:23:"App\Entity\Orderdetails";s:5:"fetch";i:4;s:8:"mappedBy";s:5:"order";s:7:"orderBy";a:2:{s:9:"sortorder";s:3:"ASC";s:11:"timecreated";s:3:"ASC";}}s:14:"invoiceAddress";O:46:"Doctrine\ORM\Mapping\OneToOneOwningSideMapping":8:{s:9:"fieldName";s:14:"invoiceAddress";s:12:"sourceEntity";s:17:"App\Entity\Orders";s:12:"targetEntity";s:20:"App\Entity\Addresses";s:5:"fetch";i:2;s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:16:"InvoiceAddressID";s:20:"referencedColumnName";s:9:"AddressID";s:10:"deferrable";b:0;s:6:"unique";b:1;s:8:"nullable";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:16:"InvoiceAddressID";s:16:"InvoiceAddressID";}s:24:"sourceToTargetKeyColumns";a:1:{s:16:"InvoiceAddressID";s:9:"AddressID";}s:24:"targetToSourceKeyColumns";a:1:{s:9:"AddressID";s:16:"InvoiceAddressID";}}s:8:"customer";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:8:"customer";s:12:"sourceEntity";s:17:"App\Entity\Orders";s:12:"targetEntity";s:20:"App\Entity\Customers";s:5:"fetch";i:2;s:10:"inversedBy";s:6:"orders";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:10:"CustomerID";s:20:"referencedColumnName";s:10:"CustomerID";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:10:"CustomerID";s:10:"CustomerID";}s:24:"sourceToTargetKeyColumns";a:1:{s:10:"CustomerID";s:10:"CustomerID";}s:24:"targetToSourceKeyColumns";a:1:{s:10:"CustomerID";s:10:"CustomerID";}}s:15:"operationalrole";O:46:"Doctrine\ORM\Mapping\OneToOneOwningSideMapping":8:{s:9:"fieldName";s:15:"operationalrole";s:12:"sourceEntity";s:17:"App\Entity\Orders";s:12:"targetEntity";s:27:"App\Entity\Rolesoperational";s:5:"fetch";i:2;s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:6:"RoleID";s:20:"referencedColumnName";s:6:"RoleID";s:10:"deferrable";b:0;s:6:"unique";b:1;s:8:"nullable";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:6:"RoleID";s:6:"RoleID";}s:24:"sourceToTargetKeyColumns";a:1:{s:6:"RoleID";s:6:"RoleID";}s:24:"targetToSourceKeyColumns";a:1:{s:6:"RoleID";s:6:"RoleID";}}s:8:"payments";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":7:{s:9:"fieldName";s:8:"payments";s:12:"sourceEntity";s:17:"App\Entity\Orders";s:12:"targetEntity";s:24:"App\Entity\Orderpayments";s:7:"cascade";a:1:{i:0;s:6:"remove";}s:5:"fetch";i:4;s:13:"orphanRemoval";b:1;s:8:"mappedBy";s:5:"order";}s:4:"tags";O:48:"Doctrine\ORM\Mapping\ManyToManyOwningSideMapping":10:{s:9:"fieldName";s:4:"tags";s:12:"sourceEntity";s:17:"App\Entity\Orders";s:12:"targetEntity";s:15:"App\Entity\Tags";s:5:"fetch";i:2;s:13:"orphanRemoval";b:1;s:10:"inversedBy";s:6:"orders";s:9:"joinTable";O:37:"Doctrine\ORM\Mapping\JoinTableMapping":4:{s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:7:"OrderID";s:20:"referencedColumnName";s:7:"OrderID";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:18:"inverseJoinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:5:"TagID";s:20:"referencedColumnName";s:5:"TagID";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:4:"name";s:10:"order_tags";s:7:"options";a:0:{}}s:16:"joinTableColumns";a:2:{i:0;s:7:"OrderID";i:1;s:5:"TagID";}s:26:"relationToSourceKeyColumns";a:1:{s:7:"OrderID";s:7:"OrderID";}s:26:"relationToTargetKeyColumns";a:1:{s:5:"TagID";s:5:"TagID";}}}s:11:"columnNames";a:26:{s:10:"customerid";s:10:"CustomerID";s:9:"orderdate";s:9:"OrderDate";s:10:"customerpo";s:10:"CustomerPO";s:8:"orderref";s:8:"OrderRef";s:10:"amountpaid";s:10:"AmountPaid";s:7:"paydate";s:7:"PayDate";s:9:"temptotal";s:9:"TempTotal";s:14:"deliverycharge";s:14:"DeliveryCharge";s:9:"surcharge";s:9:"SurCharge";s:14:"surchargevatid";s:14:"SurChargeVatID";s:16:"invoiceaddressid";s:16:"InvoiceAddressID";s:15:"payoncollection";s:15:"PayOnCollection";s:12:"creditstatus";s:12:"CreditStatus";s:13:"deliverynotes";s:13:"DeliveryNotes";s:13:"artworkmethod";s:13:"ArtworkMethod";s:10:"agreeddate";s:10:"AgreedDate";s:10:"ordernotes";s:10:"OrderNotes";s:9:"ordertype";s:9:"OrderType";s:8:"invoiced";s:8:"Invoiced";s:6:"roleid";s:6:"RoleID";s:9:"contactid";s:9:"ContactID";s:8:"lockedby";s:8:"LockedBy";s:7:"orderid";s:7:"OrderID";s:12:"modifieddate";s:12:"ModifiedDate";s:12:"invoiceddate";s:12:"InvoicedDate";s:10:"locationid";s:10:"LocationID";}s:13:"fieldMappings";a:26:{s:10:"customerid";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:10:"customerid";s:10:"columnName";s:10:"CustomerID";s:6:"length";i:6;}s:9:"orderdate";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:9:"orderdate";s:10:"columnName";s:9:"OrderDate";}s:10:"customerpo";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{s:4:"type";s:6:"string";s:9:"fieldName";s:10:"customerpo";s:10:"columnName";s:10:"CustomerPO";s:8:"nullable";b:1;s:6:"length";i:128;}s:8:"orderref";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{s:4:"type";s:6:"string";s:9:"fieldName";s:8:"orderref";s:10:"columnName";s:8:"OrderRef";s:8:"nullable";b:1;s:6:"length";i:128;}s:10:"amountpaid";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{s:4:"type";s:5:"float";s:9:"fieldName";s:10:"amountpaid";s:10:"columnName";s:10:"AmountPaid";s:9:"precision";i:12;s:5:"scale";i:2;}s:7:"paydate";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:7:"paydate";s:10:"columnName";s:7:"PayDate";s:8:"nullable";b:1;}s:9:"temptotal";O:33:"Doctrine\ORM\Mapping\FieldMapping":6:{s:4:"type";s:5:"float";s:9:"fieldName";s:9:"temptotal";s:10:"columnName";s:9:"TempTotal";s:8:"nullable";b:1;s:9:"precision";i:12;s:5:"scale";i:2;}s:14:"deliverycharge";O:33:"Doctrine\ORM\Mapping\FieldMapping":6:{s:4:"type";s:5:"float";s:9:"fieldName";s:14:"deliverycharge";s:10:"columnName";s:14:"DeliveryCharge";s:8:"nullable";b:1;s:9:"precision";i:7;s:5:"scale";i:2;}s:9:"surcharge";O:33:"Doctrine\ORM\Mapping\FieldMapping":6:{s:4:"type";s:5:"float";s:9:"fieldName";s:9:"surcharge";s:10:"columnName";s:9:"SurCharge";s:8:"nullable";b:1;s:9:"precision";i:7;s:5:"scale";i:2;}s:14:"surchargevatid";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"integer";s:9:"fieldName";s:14:"surchargevatid";s:10:"columnName";s:14:"SurChargeVatID";s:8:"nullable";b:1;}s:16:"invoiceaddressid";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"integer";s:9:"fieldName";s:16:"invoiceaddressid";s:10:"columnName";s:16:"InvoiceAddressID";s:8:"nullable";b:1;}s:15:"payoncollection";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:7:"integer";s:9:"fieldName";s:15:"payoncollection";s:10:"columnName";s:15:"PayOnCollection";}s:12:"creditstatus";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"integer";s:9:"fieldName";s:12:"creditstatus";s:10:"columnName";s:12:"CreditStatus";s:8:"nullable";b:1;}s:13:"deliverynotes";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{s:4:"type";s:4:"text";s:9:"fieldName";s:13:"deliverynotes";s:10:"columnName";s:13:"DeliveryNotes";s:8:"nullable";b:1;s:6:"length";i:65535;}s:13:"artworkmethod";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{s:4:"type";s:6:"string";s:9:"fieldName";s:13:"artworkmethod";s:10:"columnName";s:13:"ArtworkMethod";s:8:"nullable";b:1;s:6:"length";i:32;}s:10:"agreeddate";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:10:"agreeddate";s:10:"columnName";s:10:"AgreedDate";s:8:"nullable";b:1;}s:10:"ordernotes";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{s:4:"type";s:4:"text";s:9:"fieldName";s:10:"ordernotes";s:10:"columnName";s:10:"OrderNotes";s:8:"nullable";b:1;s:6:"length";i:65535;}s:9:"ordertype";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:7:"integer";s:9:"fieldName";s:9:"ordertype";s:10:"columnName";s:9:"OrderType";}s:8:"invoiced";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:7:"integer";s:9:"fieldName";s:8:"invoiced";s:10:"columnName";s:8:"Invoiced";}s:6:"roleid";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:7:"integer";s:9:"fieldName";s:6:"roleid";s:10:"columnName";s:6:"RoleID";}s:9:"contactid";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"integer";s:9:"fieldName";s:9:"contactid";s:10:"columnName";s:9:"ContactID";s:8:"nullable";b:1;}s:8:"lockedby";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"integer";s:9:"fieldName";s:8:"lockedby";s:10:"columnName";s:8:"LockedBy";s:8:"nullable";b:1;}s:7:"orderid";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"bigint";s:9:"fieldName";s:7:"orderid";s:10:"columnName";s:7:"OrderID";s:2:"id";b:1;}s:12:"modifieddate";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:12:"modifieddate";s:10:"columnName";s:12:"ModifiedDate";}s:12:"invoiceddate";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:12:"invoiceddate";s:10:"columnName";s:12:"InvoicedDate";s:8:"nullable";b:1;}s:10:"locationid";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"integer";s:9:"fieldName";s:10:"locationid";s:10:"columnName";s:10:"LocationID";s:8:"nullable";b:1;}}s:10:"fieldNames";a:26:{s:10:"CustomerID";s:10:"customerid";s:9:"OrderDate";s:9:"orderdate";s:10:"CustomerPO";s:10:"customerpo";s:8:"OrderRef";s:8:"orderref";s:10:"AmountPaid";s:10:"amountpaid";s:7:"PayDate";s:7:"paydate";s:9:"TempTotal";s:9:"temptotal";s:14:"DeliveryCharge";s:14:"deliverycharge";s:9:"SurCharge";s:9:"surcharge";s:14:"SurChargeVatID";s:14:"surchargevatid";s:16:"InvoiceAddressID";s:16:"invoiceaddressid";s:15:"PayOnCollection";s:15:"payoncollection";s:12:"CreditStatus";s:12:"creditstatus";s:13:"DeliveryNotes";s:13:"deliverynotes";s:13:"ArtworkMethod";s:13:"artworkmethod";s:10:"AgreedDate";s:10:"agreeddate";s:10:"OrderNotes";s:10:"ordernotes";s:9:"OrderType";s:9:"ordertype";s:8:"Invoiced";s:8:"invoiced";s:6:"RoleID";s:6:"roleid";s:9:"ContactID";s:9:"contactid";s:8:"LockedBy";s:8:"lockedby";s:7:"OrderID";s:7:"orderid";s:12:"ModifiedDate";s:12:"modifieddate";s:12:"InvoicedDate";s:12:"invoiceddate";s:10:"LocationID";s:10:"locationid";}s:15:"embeddedClasses";a:0:{}s:10:"identifier";a:1:{i:0;s:7:"orderid";}s:21:"isIdentifierComposite";b:0;s:4:"name";s:17:"App\Entity\Orders";s:9:"namespace";s:10:"App\Entity";s:5:"table";a:2:{s:4:"name";s:6:"orders";s:7:"indexes";a:1:{s:7:"OrderID";a:1:{s:7:"columns";a:1:{i:0;s:7:"OrderID";}}}}s:14:"rootEntityName";s:17:"App\Entity\Orders";s:11:"idGenerator";O:43:"Doctrine\ORM\Id\BigIntegerIdentityGenerator":0:{}s:13:"generatorType";i:4;}