public function view()
{
RoutingEngine::setPage("runnDAILY View Route", "PV__300");
RoutingEngine::getInstance()->registerParams("rid");
if (!isset($_GET["rid"])) {
Page::redirect("/routes");
}
$rid = $_GET["rid"];
//$route = Route::fromRouteIdentifier($rid);
$route = Route::sql()->select("routes.*, u_username, u_uid")->leftjoin("users", "u_uid", "r_uid", true)->where_eq("r_id", $rid)->execute(true, false);
//get training types for create new training modal
/*$stmt = Database::getDB()->prepare("
SELECT t_type_id, t_type_name
FROM training_types
");
$stmt->execute();
$stmt->store_result();
$types = array();
while($row = $stmt->fetch_assoc()){
$types[] = array("id"=>$row["t_type_id"], "name"=>$row["t_type_name"]);
}
$stmt->close();*/
$types_sql = new SQL("training_types");
$types = $types_sql->select("t_type_id, t_type_name")->execute(false, true);
//$training_items = TrainingLog::getItemsForUserForRoute(User::$current_user->uid, $rid);
$training_items = TrainingLog::sql()->select("r_name, t_rid, t_tid, t_time, t_distance, t_pace, t_date, t_comment")->leftjoin("routes", "r_id", "t_rid")->where_eq("t_uid", User::$current_user->uid)->where_eq("t_rid", $rid)->orderby("t_date")->execute(false, true);
RoutingEngine::getSmarty()->assign("t_types", $types);
RoutingEngine::getSmarty()->assign("route_view", $route);
RoutingEngine::getSmarty()->assign("training_items", $training_items);
}
public function view_user()
{
RoutingEngine::setPage("runnDAILY", "PV__300");
RoutingEngine::getInstance()->registerParams("uid");
if (!isset($_GET["uid"])) {
Page::redirect("/community");
}
$uid = $_GET["uid"];
//$routes = Route::getRoutesForUserInArray($uid, 50);
$routes = Route::sql()->select("r_id, r_name, r_distance, r_creation, r_description")->where_eq("r_uid", $uid)->orderby("r_creation")->limit(50)->execute(false, true, "r_id");
//$routes_js = json_encode_null($routes);
RoutingEngine::getSmarty()->assign("routes", $routes);
//RoutingEngine::getSmarty()->assign("routes_js", $routes_js);
//$index_items = TrainingLog::getIndexItemsForUser($uid);
$index_items = TrainingLog::sql()->select("r_name, t_rid, t_tid, t_time, t_distance, t_pace, t_date, t_comment")->leftjoin("routes", "r_id", "t_rid", false)->where_eq("t_uid", $uid)->orderby("t_date")->orderby("t_distance")->limit(50)->execute(false, true);
//$json_data = TrainingLog::buildChartData($index_items);
RoutingEngine::getSmarty()->assign("training_index_items", $index_items);
//RoutingEngine::getSmarty()->assign("JSON_Chart_Data", $json_data);
//var_dump(User::$current_user);
RoutingEngine::getSmarty()->assign("user", User::fromUid($uid));
}
