Add natural (orderby) sort option

[khamkham]

Hi

Thanks for this great package!

Would it be possible to add a natural order sort to the query builder?
Perhaps as a third parameter within the orderBy method:

$users = User::orderBy('name', 'desc', 'natural')->get();

http://docs.mongodb.org/manual/reference/method/cursor.sort/#return-natural-order

[jenssegers]

Isn't natural sorting the default way of sorting?

[khamkham]

Thanks for the quick fix!

I think the default way of sorting is insertion sort (or the order in which the documents are stored).
The orderBy('natural') you just added is correctly affecting the order of the results now though, so there definitely is a difference.

I think the latest commit assumes the natural sort is always ascending. This should work for descending sort as well:

    /**
     * Add an "order by" clause to the query.
     *
     * @param  string  $column
     * @param  string  $direction
     * @return Builder
     */
    public function orderBy($column, $direction = 'asc')
    {
        $direction = (strtolower($direction) == 'asc' ? 1 : -1);

        if ($column == 'natural')
        {
            $this->orders['$natural'] = $direction;
        }
        else
        {
            $this->orders[$column] = $direction;
        }

        return $this;
    }

[jenssegers]

Mh, I forgot about the actual order. But in that case, what if you have an attribute called natural? Or I should assume the chance of that happening is quite small.

[jenssegers]

Can you make a pull request with your change?

[khamkham]

First pull request, fun stuff :)

[jenssegers]

Thanks!