model with recursive reference does not work

[yavasura]

CRUD displays a table where region field is not visible. Create new and update works, only list is not working properly

class Model_Region extends Model_Table {
    public $entity_code='region';
    function init(){
        parent::init();
        $this->addField('name')->mandatory('true');
        $this->hasOne('Region');
    }
}

[yavasura]

quick filter is also not working

[DarkSide666]

Recursive links never have worked well like that. You can try some workarounds. For example, use "fake" model, like Model_Region_Parent extends Model_Region and hasOne('Region_Parent','region_id') or something like that.

BTW:

• In model instead of $entity_code use $table because entity_code is obsolete.
• Why you reported this in atk4-addons section? CRUD is in atk4 main branch I guess. Or you're talking about some specific CRUD implementation from atk4-addons?

[romaninsh]

Here is how you define parent as per DarkSides's comment:

class Model_Region_Parent extends Model_Region { public $alias='region_parent'; }

[romaninsh]

attempt to add support for this resulted in few big problems with models, so above fix should address the problem.

[DarkSide666]

Hmm... didn't know that. Will have to try at some point.

BTW Romans, why you're not visible in IRC for last I guess 2 weeks? :)

[yavasura]

the above code do not work also:

sql looks like this: select SQL_CALC_FOUND_ROWS name,(select name from region where region.region_id = region.id ) region,id,region_id from region order by (select name from region where region.region_id = region.id ) limit 0, 25 []

my code:

class Model_Region extends Model_Table { public $table='region'; function init(){ parent::init(); $this->addField('name')->mandatory('true'); $this->hasOne('Region_Parent','region_id'); } }

class Model_Region_Parent extends Model_Region { public $alias='region_parent'; }

class page_region extends Page { function init(){ parent::init(); $crud=$this->add('CRUD'); $model = $crud->setModel('Model_Region'); $model->debug(); if($crud->grid){ $crud->grid->addPaginator(); $crud->grid->getColumn('name')->makeSortable(); $crud->grid->getColumn('region')->makeSortable(); $crud->grid->addQuickSearch(array('region','name')); } } }

[DarkSide666]

Reopened in https://github.com/atk4/atk4-addons/issues/33