Сортировка товаров

function get_orders($search = false){
        
    // Фильтрация заказов.
    if($search){
        // Генерация массива условий для поиска в БД.
        if(strlen($search['id']) > 0)               { $filters['id'] = " orders.id = ".(int) $search['id']; }
        if(strlen($search['number']) > 0)           { $filters['number'] = " orders.number LIKE '%" . escape($search['number']) . "%'"; }
        if(strlen($search['invoice']) > 0)          { $filters['invoice'] = " orders.invoice LIKE '%" . escape($search['invoice']) . "%'"; }
        if(strlen($search['name']) > 0)             { $filters['name'] = " orders.name LIKE '%" . escape($search['name']) . "%'"; }
        if(strlen($search['customer_name']) > 0)    { $filters['customer_name'] = " customers.name LIKE '%" . escape($search['customer_name']) . "%'"; }
        if(strlen($search['status_id']) > 0)        { $filters['status_id'] = " orders.status_id = " . (int) $search['status_id']; }
        if(strlen($search['manager_id']) > 0)       { $filters['manager_id'] = " orders.manager_id = " . (int) $search['manager_id']; }
        if(strlen($search['shop_id']) > 0)          { $filters['shop_id'] = " orders.shop_id = " . (int) $search['shop_id']; }
        
        // Генерация запроса к БД.
        $filter = "";
        if(isset($filters)){
            foreach($filters as $value):
                if(strlen($filter) > 0){
                    $filter .= " AND $value ";
                }else{
                    $filter .= " $value ";
                }
            endforeach;
        }
        if(strlen($filter) > 0){ $filter = "WHERE $filter"; }
        $query = "SELECT orders.id, orders.name, orders.urgency, orders.reg_date, users.name AS user, customers.name AS customer, order_statuses.name AS status
        FROM `orders`
            LEFT JOIN `users` ON orders.manager_id = users.id
            LEFT JOIN `order_statuses` ON orders.status_id = order_statuses.id
            LEFT JOIN `customers` ON orders.customer_id = customers.id
                $filter ORDER BY users.id, orders.id DESC";
            $orders = $this->controller->db->query($query);
    }else{
            // Обычный вывод
        }