hasMany and belongsTo

Question

hasMany and belongsTo

Hélquisson Dourado Sep '16

Created Sep '16	Last Reply Sep '16	Replies 3	Views 2298	Votes 0

Hélquisson Dourado 3.9k

Sep '16

Hello guys,

I have:

<?php 

namespace Midas\Models\Proccess;

use Phalcon\Mvc\Model;

class Proccess extends Model {

    public $cod_processo;
    public $nome;
    public $data_criacao;

    public function initialize() {
        $this->setSource('proccess');
        $this->hasMany("cod_processo", "\Midas\Models\Proccess\ProccessActivity", "cod_processo");
    }

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

and

<?php 

namespace Midas\Models\Proccess;

use Phalcon\Mvc\Model;

class ProccessActivity extends Model {

    public $cod_atividade;
    public $cod_processo;
    public $nome;
    public $cliente;
    public $onde;
    public $quando;
    public $porque;
    public $tempo;
    public $como;
    public $ordem;

    public function initialize() {
        $this->setSource('proccess_activity');
        $this->hasMany("cod_atividade", "\Midas\Models\Proccess\ActivityResponsible", "cod_atividade");
        $this->belongsTo("cod_processo", "\Midas\Models\Proccess\Proccess", "cod_processo");
    }

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

but I can not just recover:

$proccess = Proccess::findFirst($id);           
$proccessActivity = $proccess->getProccessActivity();

following documentation: https://docs.phalcon.io/uk/latest/reference/models.html

i need help!!!! please!

Wojciech Ślawski
145.0k

Accepted
answer

edited Sep '16
Sep '16

Oh you didn't even set alias so change it like this:

$this->hasMany("cod_processo", "\Midas\Models\Proccess\ProccessActivity", "cod_processo", ['alias' => 'proccessActivity']);

And it should work fine. Also better to call it processActivites and method getProcessActivities

https://docs.phalcon.io/pl/latest/reference/models.html#aliasing-relationships

Edwin Manuel Cerrón Angeles · Answer 1 · 2016-09-06T14:24:38-07:00

Use phalcon-devtools for generation models.

 phalcon model --name=locale_source --camelize --mapcolumn --get-set --namespace=Midas\\Models

Wojciech Ślawski · Answer 2 · 2016-09-06T14:27:50-07:00

Because there is no such alias as ProccessActivity

use:

$proccessActivity = $proccess->getCodProcesso();
or
$proccessActivity = $proccess->cod_processo;

But because you defined property it can be a problem, try to remove it or add method like this:

public function getCodProcesso()
{
    return $this->getRelated('cod_processo')
}

Hélquisson Dourado · Answer 3 · 2016-09-06T15:13:11-07:00

I think I got it wrong.

well, the documentation says:

The first parameter indicates the field of the local model used in the relationship; the second indicates the name of the referenced model and the third the field name in the referenced model. You could also use arrays to define multiple fields in the relationship.

does not mention alias.

Hélquisson Dourado · Answer 4 · 2016-09-06T15:18:25-07:00

anyway, I will check only on Thursday, as tomorrow is a holiday and the company's repository is local. Thank you for now.

Hélquisson Dourado · Answer 5 · 2016-09-08T04:20:01-07:00

perfect!!!!!!

now:

<?php 

namespace Midas\Models\Process;

use Phalcon\Mvc\Model;

class Process extends Model {

    public $cod_processo;
    public $nome;
    public $data_criacao;

    public function initialize() {
        $this->setSource('process');
        $this->hasMany("cod_processo", "\Midas\Models\Process\ProcessActivity", "cod_processo", ["alias" => "ProcessActivity"]);
    }

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

and:

$process = Process::findFirst($id);
$processActivity = $process->getProcessActivity();

working!!!! thanks!