/**
* @param integer $tema
* @param integer $chastTemy
* @return Zanyatie|null
*/
private function findZanyatieByChastTemy($tema, $chastTemy)
{
return Zanyatie::customFind()->joinWith('zanyatiya_chastej_tem_rel', false)->where(['tema' => $tema, 'chast_temy' => $chastTemy])->one();
}
public function getZanyatiya_rel()
{
$q = (new Query())->select(['zct.zanyatie', 'r.kurs'])->from('zanyatie_chasti_temy zct')->leftJoin('tema t', 't.id = zct.tema')->leftJoin('podrazdel_kursa p', 'p.id = t.podrazdel')->leftJoin('razdel_kursa r', 'r.id = p.razdel');
return Zanyatie::customFind()->leftJoin(['q' => $q], 'q.zanyatie = zanyatie.id')->where(['q.kurs' => $this->id]);
}
