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