Criteria Model Self Table Alias

Question

Criteria Model Self Table Alias

Ahmet Bora Jul '17

Created Jul '17	Last Reply Jul '17	Replies 2	Views 941	Votes 0

Ahmet Bora 58.1k

Jul '17

Hi,

I need to use alias of self model table. For ex: orders model

Orders model

self::query()
    ->where('Orders.status = :status:')
    ->bind(['status' => true])
    ->innerJoin("Users", "u.id = Orders.user_id", "u")
    ->execute();

I want to use o. instead of Orders. like following that:

self::query()
    ->where('o.status = :status:')
    ->bind(['status' => true])
    ->innerJoin("Users", "u.id = o.user_id", "u")
    ->execute();

How can i set alias of base query model?

Thanks

Lajos Bencz
77.7k

Accepted
answer

Jul '17

You cant.

What you can do, is use the queryBuilder:

// service container context
$resultSet = $this->modelsManager->createBuilder()
    ->addFrom('Orders','o')
    ->where('o.status = :status:')
    ->innerJoin("Users", "u.id = o.user_id", "u")
    ->bind(['status' => true])
    ->execute();

Jonathan Aaron Steel · Answer 1 · 2017-07-25T06:15:59-07:00

Something related: if you have namespaces for your models, you might want to set aliases globally via modelsManager:

$di->setShared('modelsManager', function() {
    $mm = new \Phalcon\Mvc\Model\Manager();
    //Registers shorter aliases for namespaces in PHQL statements
    //public registerNamespaceAlias (mixed $alias, mixed $namespaceName)
    $mm->registerNamespaceAlias('m', __NAMESPACE__ . '\Models');
    return $mm;
});

i.e.

$mm->registerNamespaceAlias('m', 'MyNameSpace\MyModels');