<?php


class ProfileTable extends Doctrine_Table
{
    
    public static function getInstance()
    {
        return Doctrine_Core::getTable('Profile');
    }

    public function getOrderByNameQuery(Doctrine_Query $query = null)
    {
        if(is_null($query))
        {
            $query = $this->createQuery();
        }

        $query->select('*, IFNULL(name, CONCAT(first_name, last_name)) as sort')
              ->orderBy('sort ASC');

        return $query;
    }
}