/**
* @return \yii\db\ActiveQuery
*/
public function getUsersFakeMailsByDonors()
{
return $this->hasMany(UsersFakeMailsByDonors::className(), ['users_fake_mail_id' => 'id']);
}
public static function findFreeDonorEmail($donor_abbr)
{
$sql = 'SELECT ufm.id, ufm.email, ufm.password ' . ' FROM ' . self::tableName() . ' ufm ' . ' JOIN ' . UsersFakeMailsByDonors::tableName() . ' ufmbd ' . ' ON ufm.id = ufmbd.users_fake_mail_id ' . ' JOIN ' . ParseDonors::tableName() . ' pd ' . ' ON ufmbd.parse_donors_id = pd.id ' . ' WHERE pd.abbr = :abbr ' . ' AND ufm.user_id IS NULL ';
$result = self::findBySql($sql, [':abbr' => $donor_abbr])->asArray()->one();
return $result;
}
