таблицы Grid

$this->list_callback = function ($model) {
 
    $model->join( 'you_table', 'y', 'y.id = i.id');
 
    return $model;
};

<?php
 
class actionPassportHouse extends cmsAction
{
 
    use icms\traits\controllers\actions\listgrid {
        getListItemsGridHtml as private traitGetListItemsGridHtml;
    }
 
      private $param;
        public function __construct($controller, $params = []) {
 
        parent::__construct($controller, $params);
            $this->grid_name = 'house';
            $this->table_name = 'prt_akart';
            $this->param = $params;
 
                $this->list_callback = function ($model) {                            
                  $model->select('n.KWART');
                  $model->join('prt_numbers_kwartirs', 'n', 'i.K_SJE=n.K_SJE');
                  $model->filterEqual('SK_DOMA',$this->param[0]);
                 return $model;
                   };
 
        }
 
          public function getListItemsGridHtml() {
 
          $grid_html = $this->traitGetListItemsGridHtml();     
 
         return $this->cms_template->renderInternal($this, 'house', [
            'grid_html' => $grid_html,
        ]);
          }
 
}
 
 
 

SELECT i.*, n.KWART
FROM cms_prt_akart i
INNER JOIN cms_prt_numbers_kwartirs as n ON i.K_SJE=n.K_SJE
WHERE (i.SK_DOMA = '10127')
ORDER BY i.id asc
LIMIT 35850, 50