public function getByOrderNumber($number)
    {
        $connection = $this->getConnection();
        $select     = $connection->select()->from($this->getMainTable())->where('shopgate_order_number = :number');
        $bind       = [':number' => (string) $number];

        return $connection->fetchRow($select, $bind);
    }