public function getRoutejson($_routeid) { require '/var/www/db-init-climb.php'; require 'Comment.class.php'; $comment = new Comment(); $stmt = $db->prepare("SELECT RouteId, Name, Grade, Description \n FROM Route \n WHERE RouteId=:routeid"); $stmt->execute([':routeid' => $_routeid]); $data = $stmt->fetch(PDO::FETCH_ASSOC); $data['Grade'] = preg_replace('/-/', '', parent::unConvert($data['Grade'])); $muuttuja = $comment->getComments($_routeid, 'route'); $muuttuja = $muuttuja->fetchAll(); $data['Image'] = $this->loadRoutePic($_routeid); $data['Comments'] = $muuttuja; echo json_encode($data); }
echo "<h3>"; $startTime = strtotime($pstat['StartTime']); $endTime = strtotime($pstat['EndTime']); echo date("d.m.Y", $startTime) . " klo " . date("H:i", $startTime) . " - " . date("H:i", $endTime); echo "</h3>"; echo "<h3>Toppaukset</h3>"; //ollaan valittu ulkoharjoitus if ($pstat['IsOutside']) { $cursor = $estats->getExercises($id, "outdoor-top"); foreach ($cursor as $object) { $route = new Route($object['RouteId']); $routeRow = $route->getRoute(); echo "<div class='practice'>"; echo "Crag: <a href='showcrag.php?cid={$routeRow['CragId']}'>" . $routeRow['CragName'] . "</a><br>"; echo "Reitti: " . $routeRow['RouteName'] . "<br>"; echo "Grade: " . preg_replace('/-/', '', $converter->unConvert($estats->getRouteGrade($object['RouteId']))); echo "</div>"; } unset($route); unset($routeRow); } else { $cursor = $estats->getExercises($id, "indoor-top"); foreach ($cursor as $object) { $route = new Route($object['RouteId']); $routeRow = $route->getRoute(); echo "<div class='practice'>"; echo "Grade: " . preg_replace('/-/', '', $converter->unConvert($object['Grade'])); echo "</div>"; } } echo "<h3>Yritykset</h3>";
/** * Laskee kaikkien kiipeilysuoritusten keskiarvograden (Sisä ja ulko). * @return string Keskiarvograde. */ public function getAvgGrade() { $sum = 0; $count = 0; $cursor = $this->collection->find(['UserId' => $_SESSION['logged_user'], 'Type' => 'indoor-top']); foreach ($cursor as $object) { $sum += $object['Grade']; $count++; } $cursor = $this->collection->find(['UserId' => $_SESSION['logged_user'], 'Type' => 'outdoor-top']); foreach ($cursor as $object) { $sum += $this->getRouteGrade($object['RouteId']); $count++; } return parent::unConvert(round($sum / $count)); }