/** * Возвращает id незавершенного теста указанного уровня сложности * @param $levelId * @return null */ private function currentTestId($levelId) { $query = 'SELECT id FROM tests WHERE profile_id = ' . ProfileController::profileId() . ' AND level_id = ' . $levelId . ' AND NOT is_passed;'; $id = DB::select(DB::raw($query)); if ($id) { return $id[0]->id; } else { return null; } }
/** * Возвращает достижения пользователя * @return null */ public function getAchievements() { $query = 'SELECT achievements.id as id, name, description, is_checked FROM achievements JOIN users_achievements ON achievements.id = users_achievements.achievement_id WHERE profile_id = ' . ProfileController::profileId() . ';'; $achievements = DB::select(DB::raw($query)); if ($achievements) { $data = array(); foreach ($achievements as $achievement) { array_push($data, (array) $achievement); } return $achievements; } else { return null; } }