/**
* Возвращает 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;
}
}
