Phalcon find with conditions of models relation

Question

I have this model code:

class TvguideChannel extends Model{

    public function initialize() {
        $this->setSource('tvguide_channel');
        $this->setConnectionService('db');

        $this->hasMany('code', __NAMESPACE__.'\Tvguide', "ch_code", ['alias' => 'Tvguide']);
    }

    public function getSource() {
        return 'tvguide_channel';
    } 
}

And Controller:

    $data = TvguideChannel::find();
    $dateDetails = $data->getTvguide(['order' => '$_POST["time"] DESC']);

    $paginator = new PaginatorModel(
        array(
            "data" => $data,
            "limit" => $limit,
            "page" => $curPage
        )
    );

    $items = $paginator->getPaginate();

This is not working. How I Can use columns from Tvguide model in controller? Thanks for help.

Nikolay Mihaylov · Accepted Answer · 2017-12-13T12:53:42.737

Your controller code will return a TvguideChannel instance. To access the relation you have to use the alias you defined above.

$data->Tvguide

The above should contain all Tvguide's for this record.

Here is a more detailed example of hasMany():

$this->hasMany(
    'id', // The primary key in your main table
    'Models\ServicesVideos', // The Model you are joining
    'service_id', // Foreign key for main table
    [
        'alias' => 'videos', // Alias which you use later to access the relation
        // additional parameters like where, order, limit etc...
        'params' => [
            'order' => 'position ASC',
            'conditions' => 'type = :type:',
            'bind' => [
                'type' => get_class($this)
            ]
        ]
    ]
);

UPDATE: example of passing parameters to the relation itself.

Model code:

class Orders extends BaseModel
{
    public function initialize()
    {
        $this->hasMany('id', 'Models\OrderDetails', 'order_id', [
            'alias' => 'details',
        ]);
    }
 }

Controller code:

// We want only related records with price higher than 9.00
$order = \Models\Orders::findFirst(17);
$orderDetails = $order->getDetails([
    'conditions' => 'price > 9.00'
]);

UPDATE 2

find() method returns a Resulset, which means you can not use directly $data->getTvguide. You have to iterate over each record and access its related entries.

$data = TvguideChannel::find();
foreach ($data as $item) {
    // This will return related guides for each channel.
    $dateDetails = $item->getTvguide(...);
}

but if I want send param for where ? ['conditions' => 'ch_code = $_POST["ch_code"]']. How I can Send this in model? — Jajaja, Dec 13 '17 at 10:24
If I understood you correct, you want to pass parameters to the `Tvguide` relation? Updated my answer with similar example above. — Nikolay Mihaylov, Dec 13 '17 at 11:12
Not working. Uncaught Error: Call to undefined method Phalcon\Mvc\Model\Resultset\Simple::getTvguide() — Jajaja, Dec 13 '17 at 12:27
Can you show how you call it? Perhaps try with `['alias' => 'guides']` and `$data->getGuides()` ? — Nikolay Mihaylov, Dec 13 '17 at 12:31
$data = TvguideChannel::find(); $dateDetails = $data->getTvguide(['order' => 'time DESC']); — Jajaja, Dec 13 '17 at 12:35

score 0 · Answer 2 · answered Dec 14 '17 at 10:11

0

If you need to find with where from related model then you need to use query builder.

answered Dec 14 '17 at 10:11

Juri

1,369
10
16

Phalcon find with conditions of models relation

2 Answers2