/** * @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]); }