public function browse()
{
//TODO: Implement this feature.
RoutingEngine::setPage("runnDAILY Browse Training", "PV__100");
$format = isset($_GET["format"]) ? $_GET["format"] : "html";
$parser = new Sql_Parser(true, 5, 0);
$parser->addCondition(new Sql_RangeCondition("t_distance"));
$parser->addCondition(new Sql_RangeCondition("t_date", "FROM_UNIXTIME", "strtotime"));
$parser->addCondition(new Sql_RangeCondition("t_time", "", "TrainingLog::getSecondsFromFormat"));
$parser->addCondition(new Sql_LikeCondition("u_username"));
$parser->addCondition(new Sql_EqualCondition("u_uid"));
$parser->setData($_GET);
$stmt = Database::getDB()->prepare("\r\n\t\t\tSELECT *\r\n\t\t\tFROM training_times\r\n\t\t\tJOIN users ON u_uid = t_uid\r\n\t\t\tWHERE\r\n\t\t\t\t{$parser->getSQL()}\r\n\t\t");
$parser->bindParamToStmt($stmt);
$stmt->execute();
$stmt->store_result();
$t_items = array();
while ($row = $stmt->fetch_assoc()) {
$t_items[] = new TrainingLog($row);
}
RoutingEngine::getSmarty()->assign("t_items", $t_items);
RoutingEngine::getSmarty()->assign("query", $parser->getQueryString(true, true));
if ($format == "ajax") {
exit(RoutingEngine::getSmarty()->fetch("training/parts/item_list.tpl"));
}
}
public function users()
{
RoutingEngine::setPage("runnDAILY Admin", "PV__100");
$parser = new Sql_Parser(true, 10, 0);
$parser->addCondition(new Sql_RangeCondition("u_date_access", "FROM_UNIXTIME", "strtotime"));
$parser->addCondition(new Sql_LikeCondition("u_username"));
$parser->addCondition(new Sql_LikeCondition("u_email"));
$parser->addCondition(new Sql_EqualCondition("u_uid"));
$parser->addCondition(new Sql_RangeCondition("u_type"));
$parser->setData($_GET);
$stmt = Database::getDB()->prepare("\r\n\t\t\tSELECT *\r\n\t\t\tFROM users\r\n\t\t\tWHERE\r\n\t\t\t\t{$parser->getSQL()}\r\n\t\t");
$parser->bindParamToStmt($stmt);
$stmt->execute();
$stmt->store_result();
$users = array();
while ($row = $stmt->fetch_assoc()) {
$users[] = new User($row);
}
RoutingEngine::getSmarty()->assign("users", $users);
}
