/** * @return \yii\db\ActiveQuery */ public function getParseDonors() { return $this->hasOne(ParseDonors::className(), ['id' => 'parse_donors_id']); }
public static function getUnsorted() { $sql = 'SELECT fs.id, fs.name, pd.url ' . ' FROM ' . self::tableName() . ' fs ' . ' LEFT JOIN ' . ParseDonors::tableName() . ' pd ' . ' ON fs.parse_donors_id = pd.id ' . ' WHERE fs.feature_id IS NULL ' . ' ORDER BY fs.name '; return self::findBySql($sql)->asArray()->all(); }
public static function getUnsorted() { $sql = 'SELECT fms.id, fms.metric_synonim, pd.url ' . ' FROM ' . self::tableName() . ' fms ' . ' LEFT JOIN ' . ParseDonors::tableName() . ' pd ' . ' ON fms.parse_donor_id = pd.id ' . ' WHERE fms.feature_metric_id IS NULL ' . ' ORDER BY fms.metric_synonim '; return self::findBySql($sql)->asArray()->all(); }
public static function getExistingDonorAccount($user_id, $donor_abbr) { $sql = 'SELECT uda.id, uda.login, uda.password,' . ' uda.user_id, uda.parse_donors_id, uda.reputation ' . ' FROM ' . self::tableName() . ' uda ' . ' JOIN ' . ParseDonors::tableName() . ' pd ' . ' ON uda.parse_donors_id = pd.id ' . ' WHERE uda.user_id = :user_id' . ' AND pd.abbr = :abbr'; $result = self::findBySql($sql, [':abbr' => $donor_abbr, ':user_id' => $user_id])->asArray()->one(); return $result; }
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; }
/** * Извлечение всех unsorted синонимов с url их сайтов-источников * @return array */ public static function getUnsorted() { $sql = 'SELECT cs.id, cs.name, cs.parent_category, cs.grandparent_category,' . ' pd.url ' . ' FROM ' . self::tableName() . ' cs ' . ' LEFT JOIN ' . ParseDonors::tableName() . ' pd ' . ' ON cs.parse_donors_id = pd.id ' . ' WHERE cs.category_id IS NULL' . ' ORDER BY cs.name'; return self::findBySql($sql)->asArray()->all(); }