Oversimplified Order Aggregate ... just trying stuff *lol

OrderAggregate.php

<?php
/**
 * @inherits ArrayAccess, IteratorAggregate, Countable from Collection
 * @author neun
 * @since  12.10.2015 22:24
 */
class OrderAggregate extends Collection
{
    /**
     * @var Order
     */
    protected $order;

    /**
     * @var Customer
     */
    protected $customer;

    /**
     * @var OrderItem[]
     */
    protected $items;

    public function __construct($orderId)
    {
        $sql = "SELECT * FROM `order` WHERE id = {$orderId}";
        $this->order = pdo('mono')->query($sql)->fetchObject('Order');

        $sql = "SELECT * FROM `customer` WHERE id = {$this->order->customerId()}";
        $this->customer = pdo('mono')->query($sql)->fetchObject('Customer');

        $sql = "SELECT * FROM `order_item` WHERE order_id = {$orderId}";
        $stm = pdo('mono')->query($sql);
        while ($item = $stm->fetchObject('OrderItem')) {
            $this->add($item);
        }
    }

    public function order()
    {
        return $this->order;
    }

    public function customer()
    {
        return $this->customer;
    }
}

Well ... I guess I just learned that ...

PDOStatement->fetchObject('Object')

... actually not only fills the properties of a model ... but also retains their visibility if column_name equals property_name ... and since you dont access properties directly your getters can still look like...

public function orderNumber() { return $this->order_number; }

sw33t =)