public function getDishProd($depId) { $prod_id = ''; $model = Dishes::model()->with('stuff', 'products')->findAll('t.department_id = :depId', array(':depId' => $depId)); foreach ($model as $value) { foreach ($value->getRelated('stuff') as $val) { $stuff = new Halfstaff(); $prod_id .= $stuff->getProdId($val->halfstuff_id); } foreach ($value->getRelated('products') as $val) { $prod_id .= $val->product_id . ":"; } } return $prod_id; }