/** * @return \yii\db\ActiveQuery */ public function getIdMattraffic() { return $this->hasOne(Mattraffic::className(), ['mattraffic_id' => 'id_mattraffic'])->from(['idMattraffic' => Mattraffic::tableName()])->inverseOf('trMats'); }
public function getCurrentMattraffic() { return $this->hasOne(Mattraffic::className(), ['id_material' => 'material_id'])->from(['currentmattraffic' => Mattraffic::tableName()])->leftJoin('mattraffic mt1', 'currentmattraffic.id_material = mt1.id_material and `currentmattraffic`.`mattraffic_tip` IN (1, 2) and mt1.mattraffic_tip IN (1, 2) and (currentmattraffic.mattraffic_date < mt1.mattraffic_date or currentmattraffic.mattraffic_date = mt1.mattraffic_date and currentmattraffic.mattraffic_id < mt1.mattraffic_id)')->andWhere(['in', 'currentmattraffic.mattraffic_tip', [1, 2]])->andWhere(['mt1.mattraffic_date' => NULL]); }
public function getIdMattraffic() { $a = new TrOsnov(); return $a->hasOne(Mattraffic::className(), ['mattraffic_id' => 'id_mattraffic'])->from(['idMattraffic' => Mattraffic::tableName()]); }
/** * @return \yii\db\ActiveQuery */ public function getMattraffics() { return $this->hasMany(Mattraffic::className(), ['id_mol' => 'employee_id'])->from(['mattraffics' => Mattraffic::tableName()]); }