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); }